Problem solve Get help with specific problems with your technologies, process and projects.

z/OS DB2 tuning resources

I am interested in gaining more knowledge on how to tune DB2 applications on z/OS. Could you please suggest any books that specifically addresses the area of DB2 performance tuning.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.