Finally the most essential DB2 book for DBAs has been updated for the latest release of DB2: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition).
Congratulations to both George Baklarz and Paul Zikopoulos! As you may know, Bill Wong was George's co-author for the fourth and fifth editions to this book (as well as one of mine :). Bill had moved to a job in Tivoli, but is now back in DB2... which I'm quite happy about. Paul joined the team and I'm sure that this edition follows the tradition of the previous editions: well-written, easy to read, thorough, and essential!
What can you find in this book? Well, 1136 pages, for starters! As you can tell from the sheer size of the book is that you'll find much more than exam prep details! In fact, I would suggest that you continue to buy / read the Exam Study Guides by Roger Sanders to prepare for DB2 Certification Exams, but buy this book as your way to learn what you need to know, beyond the exams.
The sections of the book that I'd like to draw your attention to include:
1) Security. Although it doesn't cover the topic as thoroughly as Understanding DB2 9 Security does, it does include important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator role
2) SQL. There is an entire section of the book devoted to SQL. In my mind, there IS no other book you need for SQL beyond this one. Coverage includes pure XML, advanced SQL, and yes, even SQL for beginners. George is somewhat of an SQL expert and creates examples of all sorts to demonstrate a variety of SQL. But, George and Paul rarely rely solely on their own knowledge alone. They are well-connected with the entire development team and the book benefits from additions and reviews by the top experts in the area.
3) Autonomics. Want to make your environment more automatic? Learn about the operational improvements that can enhance your efficiency. Coverage includes self-tuning memory allocation, automated storage management, and storage optimization.
4) Partitioning. Perhaps an advanced topic, but important none-the-less. Learn about the new table-partitioning features that improve scalability and manageability.
5) Development. My dream would be to publish a book for this area alone, but since that isn't in the cards right now, read this book to learn about the powerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all data.
I plan to work with both George and Paul to further feature unique aspects about their book, so stay tuned.
Interestingly, this book is not on special on amazon.com. I'm not sure why that is, but I'll keep watching to see if they put a sale on this book that matches their usual 37% discount. You may buy the book from the IBM Press websites at a discount:
United States - Use the coupon code DB2SAVE to get 35% off this and other books.Canada - 35% off all IBM Press titlesEMEA - 35% off all IBM Press titles.
IBMers may choose to purchase the book through an Internal Site.
Buy today and keep up to speed on the latest features.
Keep on Learning
Matching: onebook X
If you are a DBA and only want to buy a single book to have as a reference, here's what I suggest:
DB2 for Linux, UNIX, and Windows
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
Written by long time DB2 experts and DB2 evangelists, George Baklarz and Paul Zikopoulos, this book is the reference and guide that you will use over and over as you do your job!
DB2 for z/OS
DB2 Developer's Guide (5th Edition) by long time DB2 expert and consultant, Craig Mullins. This book keeps on selling and selling... so it may be that everyone who works on DB2 for z/OS already owns a copy! If you don't, you should!
Informix Dynamic Server
Administering Informix Dynamic Server: Building the Foundation by long time IDS expert Carlton Doe. At this point, this is the ONLY up to date IDS book that is available! Buy it because it WILL update you on all the changes in the product, but also, the more books that sell, the more likely it is that we'll have more IDS books published!
If you do not find that these books fill your needs... don't worry... we have many others! See our IBM IM Bookstore and the channelDB2.com DB2inBooks discussion group.