There are several good books on the market that address performance tuning issues. Of course, the first one I have...
to recommend is my own DB2 Developer's Guide, 5th edition (SAMS, ISBN: 0672326132). This edition of the book was just published in May 2004 and is updated for DB2 for z/OS Version 8. There is an entire section devoted specifically to tuning and monitoring; and there are tuning guidelines and suggestions throughout the book. It can be ordered at amazon.com by following this link here.
Another good book, this one focused entirely on performance, is DB2 High Performance Design and Tuning by Richard Yevich and Susan Lawson. There is a lot of great information in this book, even though it is about 4 years old and could stand to be updated. This book can be ordered at amazon.com by following this link here.
Finally, you might want to consider augmenting the two books above with Gabrielle Wiorkowski's fine two-part book titled DB2 for OS/390 Development for Performance. Gabrielle self-publishes theses books and you can find information (including ordering details) about them at http://www.gabrielledb2.com.
Dig Deeper on IBM DB2 management
Related Q&A from Craig S. Mullins
Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ...continue reading
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ...continue reading
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.