Page 1 of 1

DB2 Performance Tuning

PostPosted: Thu Jan 06, 2011 7:17 pm
by kk12345
Hi all DB2 Experts,

Till now, I have wrote many simple SQL queries, where I won't bother about the Performance (i.e. Queries are not much complex) so they were tuned without my knowledge.

Now, I like to learn the Performance Tuning Techniques, Please suggest a good / PDF / eBook along with Links / authors, so that I can kick start with that.

I will be eagerly waiting for your response.

K K.
Hyderabad.

Re: DB2 Performance Tuning

PostPosted: Thu Jan 06, 2011 8:00 pm
by NicC
The DB2 manuals would be a good place to start - especially any user guide.

As for books, the one by Craig Mullins is much recommended by others.

Re: DB2 Performance Tuning

PostPosted: Thu Jan 06, 2011 8:22 pm
by kk12345
Dear NicC,

Please give me the links for DB2 Manuals or give me the Book title written by Craig Mullins.
If you can provide a response by tomorrow, I can utilize my week-end properly.

thanks in advance.

Re: DB2 Performance Tuning

PostPosted: Fri Jan 07, 2011 12:26 am
by NicC
Links to DB2 manuals cn be found at the IBM manuals website - the URL is posted often enough in the forum in various sections. Caan you not google DB2 + 'craig mullins'??? In my search it was the second hit but if you are not searching from the UK then you may get different results.

Re: DB2 Performance Tuning

PostPosted: Fri Jan 07, 2011 3:39 am
by dick scherrer