Automotive Holiday Deals Books Gift Guide Books Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Prime Music Sweepstakes egg_2015 All-New Amazon Fire TV Beauty Deals Gifts for Her Amazon Gift Card Offer cm15 cm15 cm15 $30 Off Amazon Echo $30 Off Fire HD 6 Kindle Cyber Monday Deals Nintendo Digital Games Outdoor Deals on HTL
IBM DB2 9.7 Advanced Administration Cookbook and over one million other books are available for Amazon Kindle. Learn more

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Buy New
In Stock.
Ships from and sold by Gift-wrap available.
IBM DB2 9.7 Advanced Admi... has been added to your Cart
Sell yours for a Gift Card
We'll buy it for $2.00
Learn More
Trade in now
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

IBM DB2 9.7 Advanced Administration Cookbook Paperback – February 24, 2012

6 customer reviews

See all 2 formats and editions Hide other formats and editions
New from Used from
"Please retry"
"Please retry"
$53.00 $63.65

Best Books of the Year So Far
Looking for something great to read? Browse our editors' picks for 2015's Best Books of the Year in fiction, nonfiction, mysteries, children's books, and much more.
$64.99 FREE Shipping. In Stock. Ships from and sold by Gift-wrap available.

Frequently Bought Together

  • IBM DB2 9.7 Advanced Administration Cookbook
  • +
  • DB2 Essentials: Understanding DB2 in a Big Data World (3rd Edition) (IBM Press)
Total price: $117.27
Buy the selected items together

Special Offers and Product Promotions

  • Take an Extra 30% Off Any Book: Use promo code HOLIDAY30 at checkout to get an extra 30% off any book for a limited time. Excludes Kindle eBooks and Audible Audiobooks. Restrictions apply. Learn more | Shop now

Editorial Reviews

About the Author

Adrian Neagu has over ten years experience as a database administrator, mainly with DB2 and Oracle databases. He started working with IBM DB2 in 2002. He is an IBM DB2 Certified Administrator version 8.1.2 and 9, Oracle Database Administrator Certified Master 10g, Oracle Database Administrator Certified Professional 9i, 10g and Sun Certified System Administrator Solaris 10. He is an expert in many areas of database administration such as performance tuning, high availability solutions, replication, backup and recovery. In his spare time he enjoys to cook, take photos and catch big pikes with huge jerkbaits and bulldawgs. Robert Pelletier is a Senior DBA Certified Oracle 8i, 9i, 10g, and DB2. He has twelve years experience as a DBA, as production/development support, database installation and configuration, tuning and troubleshooting. He has more than thirty years IT experience in many applications in development in central Environments, client-server, and UNIX. More recently he has added expertise in Oracle RAC 11gR2, 10gR2, 9i, DB2 UDB DBA, ORACLE 9iAS, Financials, PeopleSoft and also SAP R/2 and R/3. His expertise has been recognized by many major organizations worldwide, and he has a solid consulting background in well-known firms.
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.

Looking for the Audiobook Edition?
Tell us that you'd like this title to be produced as an audiobook, and we'll alert our colleagues at If you are the author or rights holder, let Audible help you produce the audiobook: Learn more at

Product Details

  • Paperback: 480 pages
  • Publisher: Packt Publishing (February 24, 2012)
  • Language: English
  • ISBN-10: 1849683328
  • ISBN-13: 978-1849683326
  • Product Dimensions: 7.5 x 1.1 x 9.2 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Best Sellers Rank: #1,823,644 in Books (See Top 100 in Books)

Customer Reviews

5 star
4 star
3 star
2 star
1 star
See all 6 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

2 of 2 people found the following review helpful By Robert W. Cooke on March 20, 2012
Format: Paperback
The IBM DB2 9.7 Advanced Administration Cookbook was a pleasant surprise to review. The book is in more of a step by step format than a book of recipes.The book begins where it should at initial DB2 installation and creating an instance. It then proceeds on to creating databases tablespaces, bufferpools, and database objects.

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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
1 of 1 people found the following review helpful By W Boudville HALL OF FAMEVINE VOICE on May 4, 2012
Format: Paperback
The authors emphasise, even if perhaps unintentionally, that using db2 entails a lot of typing of commands. That is one thing that struck me immediately about this text. Sure, there are sections with screen captures of the GUI that IBM provides as a more user friendly front end to running a db2 database. But more importantly, the complexity and specialised nature of many of the tasks done in the text are not fronted by a GUI. You invoke at the command line of the operating system the 'db2' program with an attendant and typically long list of options. In many ways, this reminds me of when I was a systems administrator of a cluster of IBM RS6000 workstations, that ran AIX, IBM's version of unix. AIX also had this feature of long command line commands. But AIX came with SMIT, a very nice and powerful GUI for the sysadmin, that let you far more easily run commands. Behind the scenes, SMIT generated the text of the commands, showed it to you in a window and ran it. In an analogous way, the db2 command really seems like it needs its corresponding GUI to be fully fleshed out.

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 ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
1 of 1 people found the following review helpful By aroushdi on May 9, 2012
Format: Paperback
Though IBM has the info center and other publications for DB2 , It is difficult to find the information we need and we jump from a page to another until we find the proper info .
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 .
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
IBM DB2 9.7 Advanced Administration Cookbook
This item: IBM DB2 9.7 Advanced Administration Cookbook
Price: $64.99
Ships from and sold by