Start reading IBM DB2 9.7 Advanced Administration Cookbook on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Colour:
Image not available
 

IBM DB2 9.7 Advanced Administration Cookbook [Kindle Edition]

Adrian Neagu , Robert Pelletier
4.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £40.99
Kindle Price: £29.99 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £11.00 (27%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £29.99  
Paperback £40.99  
Earn a Free Kindle Book
Earn a Free Kindle Book
Buy a Kindle book between now and 31 March and receive a promotional code good for one free Kindle book. Terms and conditions apply. Learn more

Book Description

This cookbook has recipes written in a simple, easy to understand format, with lots of screenshots and insightful tips and hints. If you are a DB2 Database Administrator who wants to understand and get hands on with the underlying aspects of database administration, then this book is for you. This book assumes that you have a basic understanding of DB2 database concepts.


Product Description

About the Author

Adrian Neagu


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 Pelletie


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.


Product details

  • Format: Kindle Edition
  • File Size: 2827 KB
  • Print Length: 480 pages
  • Publisher: Packt Publishing (24 Feb. 2012)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B007EDCVG2
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #836,629 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


Customer Reviews

5 star
0
3 star
0
2 star
0
1 star
0
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
0 of 1 people found the following review helpful
4.0 out of 5 stars long, intricate db2 commands 4 May 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?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.8 out of 5 stars  6 reviews
2 of 2 people found the following review helpful
5.0 out of 5 stars A Great Resource 20 Mar. 2012
By Robert W. Cooke - Published on Amazon.com
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.
1 of 1 people found the following review helpful
4.0 out of 5 stars long, intricate db2 commands 4 May 2012
By W Boudville - Published on Amazon.com
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.

Along the lines of backup, but extrapolating to the extreme case of disaster recovery, IBM has made HADR (High Availability Disaster Recovery). Used for a critical database failure or disaster. You need extra hardware, in the form of a standby server, which is preferably at a different location. That is the point, isn't it? HADR then does the backup of your primary database. If your data center is vital enough, take a serious look at this section of the text.
1 of 1 people found the following review helpful
5.0 out of 5 stars Excellent book 9 May 2012
By aroushdi - Published on Amazon.com
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 .
3 of 4 people found the following review helpful
5.0 out of 5 stars Best book for DB2 version 9.7 Advanced Administration Topics HIGHLY RECOMMEND!! 14 Mar. 2012
By Srilu - Published on Amazon.com
Format:Paperback
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.7 DPF,MDC, Security new features .I read Chapter12 from packtpub about Monitoring .Really good with practical examples .This book will help every DB2 UDB DBA for daily Job duties. I would highly recommend this book to fellow DBAs and developers.
Cheers ..
Srilu
2 of 3 people found the following review helpful
5.0 out of 5 stars Excellent book 2 Mar. 2012
By Martin - Published on Amazon.com
Format:Paperback
Excellent book, probably the best on this topic.The explanations and code snippets are outstanding.
Very recommended for who want to learn DB2 in a different way.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category