Programming Books C Java PHP Python Learn more Browse Programming Books
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide (5th Edition) Paperback – February 20, 2003

ISBN-13: 007-6092019091 ISBN-10: 0130463612 Edition: 5th

6 New from $10.95 28 Used from $0.72
Amazon Price New from Used from
Paperback
"Please retry"
$10.95 $0.72
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 912 pages
  • Publisher: IBM Press; 5 edition (February 20, 2003)
  • Language: English
  • ISBN-10: 0130463612
  • ISBN-13: 978-0130463616
  • Product Dimensions: 9.3 x 7.1 x 1.3 inches
  • Shipping Weight: 2.9 pounds
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (10 customer reviews)
  • Amazon Best Sellers Rank: #1,143,531 in Books (See Top 100 in Books)

Editorial Reviews

From the Back Cover

DB2 Universal Database v8 builds on the world's #1 enterprise database to simplify anytime/anywhere information integration, streamline management, automate resource tuning,enhance business intelligence, and maximize performance, scalability, and reliability.

Now, IBM offers complete, start-to-finish coverage of DB2 Universal Database v8 administration and development for UNIX, Linux, and Windows platforms... and authoritative preparation for IBM's newest DB2 certification exam.

This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database v8, including best practices for DB2 database design and development; day-to-day administration and backup; expert techniques for deploying networked, Internet-centered, and XML-based database applications; migrating to DB2 UDB v8; and much more.You'll also find an unparalleled collection of IBM tips and tricks for maximizing the performance, availability, and value of any database system. Coverage includes:

  • Manageability and serviceability enhancements, including new tools for storagemanagement and monitoring database health
  • Performance improvement withmultidimensional clustering, enhanced prefetching, threading of Java UDFs and storedprocedures, and materialized query tables
  • New Setup wizards, configuration assistants, GUItools, and DB2 Administration Server (DAS) improvements
  • Availability andscalability enhancements
  • New DB2 v8 Replication and Data Warehouse Centers
  • Major improvements for developers, including SQL, XML, JDBC, and CLIenhancements

Whether you're a DBA, a developer, a DB2 certification candidate, or all three, DB2Universal Database v8 for Linux, UNIX, and Windows Database AdministrationCertification Guide is the one book you can't afford to be without.

  • Straight from IBM, the ultimate guide to running DB2 v8 and preparing for IBM's latest DB2certification exam!
  • In-depth coverage of DB2 v8 database administration and development
  • Covers new DB2 v8 enhancements in manageability, serviceability, reliability, availability, and performance
  • Contains in-depth coverage of new DB2 v8 tools, including the Replication, Data Warehouse, and Development Centers
  • Presents expert tips and best practices from IBM's own DB2 customer support organization
About the CD

The CD-ROM included with this book contains a complete trial version of DB2 UDB V8Personal Edition, plus the DB2DEMO program to help explore the many features of DB2.

About the Author

GEORGE BAKLARZ, IBM Senior Manager for DB2 Technical Sales Support, works closely withcustomers to help them understand new DB2 technology, and to gain their feedback for improvingDB2 products. He has spent 20 years at IBM working on various aspects of database technology.He is also a lecturer at the University of Guelph, teaching relational database concepts tostudents. BILL WONG, IBM DB2 Program Director, is responsible for assisting customers tounderstand IBM's latest DB2 technology and future directions for Linux, Life Sciences, and GridComputing. His 18 years of database experience encompass DB2 system and databaseadministration, technical sales support, vendor enablement, and product planning.


More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.1 out of 5 stars
5 star
6
4 star
1
3 star
2
2 star
0
1 star
1
See all 10 customer reviews
Fairly easy to follow.
PK Ganapathy
Beside being an excellent certification reference, it is very handy as a deskside how-to reference.
Philip K Gunning
I recomend this book to the DBA or the developer.
Frederick L. Merritt Jr.

Most Helpful Customer Reviews

10 of 12 people found the following review helpful By Ted Pin on October 1, 2003
Format: Paperback
I have been involved with DB2 for a number of years and this book definitely introduced a few new tricks to me. This is especially good reading for those migrating to v8 or thinking of migrating as it covers many of the new and changed features between v7 and v8. Despite being a good source of information, this is by far the most contradictory book I have read to date (and I have read many technical books). The most annoying contradictions are when a paragraph will state that something is IMPOSSIBLE or there is ONLY ONE WAY to do it, and then the next paragraph will list a way (or many ways) to perform that exact something. One example:
p.298 "Note: The ORDER BY clause, if used, must be the last clause in your SQL statement."
p.299 "TO limit the number of rows sorted in a SELECT, the FETCH FIRST ... ROWS [clause] must be added to the end of the ORDER BY [clause]."
This doesn't really bother me because I know why FETCH would go after ORDER BY, but why state ORDER BY must be the last clause, then go on to show that ORDER BY is in fact NOT the last clause on the next page? How about not say it at all! These types of contradictions are scattered throughout the book, but I am too irritated to list them here.
Another good example of frustrating trends in this book is also on pg.298:
"You can also rename a column using an alias."
Well, what is an alias, and how do you create one? Again, this time I knew what an alias was and how to create one from prior experience, but why Baklarz and Wong do not include an explaination here (or at least a reference) is beyond me. They do not even mention that the concept of an "alias" will used for the first time in an example on pg.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By Philip K Gunning on April 10, 2003
Format: Paperback
This is a must have for production DBAs. Beside being an excellent certification reference, it is very handy as a deskside how-to reference. This edition has been updated to address sequences, MQTs, write-to-table event monitors, Health monitor and Health Center, and common client changes. The book touches on just about every area you need to know about as a DBA.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By RiversandLakes on April 10, 2006
Format: Paperback
So it claims that Chapter 1-8 covers the objectives for Exam 700. It should have said - and MORE, SO MUCH MORE. Which borders on garbage.

Please focus only on the exam objectives. The topic on MDC perhaps should have covered over 30 pages in a book titled "DB2 New Features" instead of this one?

I passed 700 and 701 thanks to FREE IBM Exam Prep Tutorials and the Supplementals. These 2 are ALL one needs.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Frederick L. Merritt Jr. on July 5, 2005
Format: Paperback
I boought and read a couple of other IBM press books looking for this one. If you are a DBA or a wanna be BDA then this is the book that you want to read. I found the writting smooth and usefull. I did read a paragraph that was lifted almost directly from the IBM db2 administration guide. I have not made use of the cd yet nor have I taken the certification test so I can not comment on the works usefullness in those two areas.

I recomend this book to the DBA or the developer. I would not recommend this book to the nontechnical reader.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Adrian Matala on July 5, 2003
Format: Paperback
This book is more than a Certification Study Guide, it is a complete DB2 v8.1 reference covering in a clear and well organized manner both standard well-known DB2 features and new less known features introduced in version 8.1.
It is a must read for any administrator trying to get up-to-speed with DB2 UDB v8.1.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Search