Customer Reviews

DB2 for OS/390 Development for Performance

5 star:		(12)
4 star:		(0)
3 star:		(0)
2 star:		(0)
1 star:		(0)

 

 

The 2nd edition (March 2000) is the first to include V6 features and facilities. We certainly have a myriad of impressive features to use to our advantage in 2000 and Gabrielle covers them all as well as all you need to design and develop applications full of tips and techniques for performance.

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!

I used Wiorkowski work for the tuning of a large DataWarehouse for a firm in the shipping industry.

Outside the IBM manuals, there are primarily three works for the tuning and performance of OS/390 DB2: Wiorkowski, Craig Mullins, and Lawson & Ford.

Each have their merits. Estimating how the the DB2 database engine works for large volumes of data is often an art, wherefore several texts and perspectives are clearly beneficial.

Wiorkowski's book is organized in an unconventional way. The chapters are not numbered but they are abbreviated with two letters (as the standard). Therefor the reader's overview of the table of contents is necessary. Fortunately this reflects important aspects and views of DB2.

Wiorkowski's work covers precisely and in depth many DBA issues.
For example (using the DataWarehouse example)issues which are necessary for optimising a single access method for a few tables in the DataWarehouse. We use pages 127-129 (partitioning index) and pages 218-219 for this purpose (logical partitioning index usage), among other things, and the notions of cardinality and clustering in a partitioned index.

Wiorkowski's book is in the category of serious works on optimising a database for a particular database engine (here OS/390 DB2): it demands attentive study.

The book explains many things about DB2 use and workings in an easy to understand fashion. It is designed both for the beginner and intermediate to advanced DB2 person because most of us cannot be advanced in all DB2 topics. I never found any other book for DB2 OS/390 as useful as this one.

This book definitely deserves 5 stars because : - Range of topics covered - Detailed - Clarity and treatment of the subject - Useful questions and answers at the end of the chapters - Clarity , again .

I am especially pleased with the organization and depth you present; one gets a good overview, yet can drill down for thorough understanding.

The book is an excellent, practical, hands-on guide. It is proving to be very useful in helping us solve our day-to-day problems. I think it's a must have for any serious minded DB2 technician. I have encouraged all my DBAs to get it and use it.

The book is very good and I am very impressed with the content and the way you present things. I like the questions and answers approach to the end of each chapter, which makes you really think about what you just learned.

"For database administrators, developers, and more technical managers, this book is the definitive look under the hood into the mechanism that drives the operational engines of DB2. Those responsible for squeezing performance out of DB2 should get access to it. Study it, and reap the benefits." Excerpt from ACM Computing Reviews, Sept.1998.

It provides a bridge for theory I've studied to tackle real life problems and consolidates my understanding of SQL tuning in particular.