No comments about Backing Up DB2 Using Tivoli Storage Manager.

No comments about World Wide Web Access to DB2.

No comments about DB2 - Quick Upper Bound Estimate an Application Design Methodology.

No comments about DB2 for Mvs/Esa Version 4 Non-Data-Sharing Performance Topics.

No comments about Db2 on Mvs Platform; Data Sharing Recovery.

No comments about Backup, Recovery and Availability With DB2 Parallel Edition on Risc/6000 Sp.

No comments about Redbook with Media: DB2 Udb V7.1 Performance Tuning Guide (IBM Redbooks).

No comments about A Guide to DB2: A User's Guide to the IBM Product IBM Database 2 (A Relational Database Management System for Mvs Environment and Its Major Compani).

5 comments about DB2 for Z/OS and Os/390 Development for Performance (Volume 1).

1. This book excels in clarity , depth and the number of topics covered . The questions at the end of the chapters are helpful too .
   Also , anyone preparing for the DB2 Certification ( for OS/390 ) would benefit from this .



2. I've believed for some time that Gabrielle Wiorkowski knows as much as, or more than, anyone outside of IBM's DB2 development team about DB2's use of indexes, optimization, and other aspects of performance. This book is based on what she has learned, her direct experiences, and the experiences of other DB2 professionals with whom she comes in contact. ... It is you, the administrator, database designer, or application developer who applies its capabilities wisely or unwisely. This book provides practical information of use to you today in your job environment. Marilyn Bohl, Vice President, Work Process Systems, San Jose, CA.



3. Working with DB2 from 1985 forces one to read many books.
   Gabrielle's book is the best ever I've read (and use) for DB2 on OS/390 (Z/OS) platform.
   Very good explanations, clarity of write and easy to find structure.
   I have many other books, but this is my leading (by far) favorite.
   If you ever wish to know DB2 - this is the book you must have.



4. This book is amazing! . As a DBA , I keep on referring this book again & again . It has very useful information & can be used by anyone who wants a really good understanding of DB2

   Cheers to the author for writing such a wonderful book!




5. DB2 for Z/OS and Os/390 Development for Performance (Volume 1&2
   by Gabrielle Wiorkowski

   This book is extremely helpful for all levels of DBAs, system programmers and DB2 developers. It is most comprehensive and includes all features of v.6 and v.7.
   At our shop, we have always used Gabriell's book for all releases
   of DB2. This particular edition is very helpful, in the sense it is a text book for all levels and all parts of DB2 world.
   Anytime in question, we look it up in this book for answer.

   I will recommend this book as a must for DB2 tech team.

2 comments about High Availability Guide for DB2(R).

1. If you have been a sysadmin and are familiar with the concepts of full and incremental backups of an operating system, then this book's descriptions of dB2's abilities in this field are very impressive. dB2 offers far more fine grained control/resolution over the backing up of its data. Like the means of having circular or archival logging. So if you are just starting out as a dB2 administrator, you have quite a bit more to learn, just in this field.

   On a tangential note: Suppose you have your own non-database application, with its own native data file format, and you want to regularly save its activities. Try looking at the ideas in this book for how dB2 does its duties. You might be able to abstract out the ideas and reinstantiate them in your context. The book presents the right level of discussion for this. One caveat is that IBM has a portfolio of patents around dB2, and I do not know the extent that you might be able to implement some of the book's ideas without infringing on the patents.

   Of course, there is far more to dB2 than backups. The book goes into other topics. Like how to define and run a standby database, by sending log files to it in a systematic fashion. Or, how to make a "split mirror" warm standby.

   My overall impression is that IBM has engineered a vast amount of backup and availability into dB2, to handle almost any level of transaction load. There is a lot more to dB2 than just being able to handle standard SQL.




2. Having seen Chris talk at several IDUG events, I knew he had a deep knowledge of DB2 and its high availability features. This book highlights that knowledge.
   
   The section on logging is the clearest explanation of DB2 logging that I have seen anywhere. I found it especially useful that the parameters that affect logging are covered in detail. His chapter, "Minimizing Unplanned Outages" is full of good information about increasing data availability during required maintenance. His detail regarding online schema changes is quite helpful.
   
   The chapter on setting up standby database gives much good detail about the various techniques. Sample scripts are included in the chapter to make the DBAs good easier. The chapter on HACMP is very helpful for a DBA trying to understand how HACMP works.
   
   My only disappointment with the book is that it came out too early to cover HADR. Having a section on HADR would have made the book complete.