To get the free app, enter your mobile phone number.
IBM DB2 9.7 Advanced Administration Cookbook Paperback – February 24, 2012
|New from||Used from|
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently Bought Together
Customers Who Bought This Item Also Bought
About the Author
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 89%). Print edition purchase must be sold by Amazon. Learn more.
For thousands of qualifying books, your past, present, and future print-edition purchases now lets you buy the Kindle edition for $2.99 or less. (Textbooks available for $9.99 or less.)
Top Customer Reviews
I was most impressed by the Backup and Recovery, Monitoring, and Tuning and Optimization chapters. The Backup and Recovery chapter is short but it covers all forms of online and offline backups and different recovery options. Monitoring covers system, snapshot, and event monitoring as well as using the memory visualizer and health monitor. DB2 Tuning and Optimization gives examples of O/S monitoring, using explain, and how indexes, reorgs, and runstats can help performance.
The cookbook also discusses DB2 tools such as db2dart, db2look, db2move, db2pd, reorgchk, list tablespaces and others. It mentions db2top but does not demonstrate it.There is a chapter on DB2 PureScale but I'm not experienced with that product.
The cookbook could contain more common problems/issues and troubleshooting but an entire book could be written just on that topic. All in all the IBM DB2 9.7 Advanced Administration Cookbook provides a well rounded approach to a new or novice DB2 DBA. Even an experienced DBA would learn a few things. It does not deep drive into everything but it goes far enough and provides good examples to perform the main DB2 DBA tasks. The IBM DB2 document ion and redbooks will provide the fine details.
As for the text's contents, they do warrant a pre-existing sophisticated understanding of SQL and relational database theory. IBM's db2 comes with useful features like an optimiser that tries to improve the performance of complex queries. The book also makes you pay attention (well, it tries at least) to mundane but key issues like doing a tape backup. Using Tivoli Storage Manager. This particular topic has a bunch of grubby details in the examples. But that is the reality of most backups. You should also look carefully at the incremental backups. These are inherently far faster to perform.Read more ›
This book closes this gap and you find the information needed in a very short time.
From my point of view it is targeted to all audience from beginners to the expert .
Still relevant even for DB2 V10 with the exeption of the new functionalaties.
The only thing I miss in the book is the WINDOWS specific environment .
Most Recent Customer Reviews
This is a great book with quick reference and simple straight forward answers. This book is highly recommended to all DB2 DBA admins.Published on April 23, 2012 by cly
This is First V9.7 DB2 udb book with detailed info. Book covers all the topics and new fetures for 'DB2 9.7 Advanced Database Administrator including V9.8 db2 pureScale and V9. Read morePublished on March 14, 2012 by Srilu