DB2 Performance Tuning



IBM's flagship relational database management system

DB2 Performance Tuning

Postby kk12345 » Thu Jan 06, 2011 7:17 pm

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.
kk12345
 
Posts: 18
Joined: Sun Dec 26, 2010 6:26 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Performance Tuning

Postby NicC » Thu Jan 06, 2011 8:00 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: DB2 Performance Tuning

Postby kk12345 » Thu Jan 06, 2011 8:22 pm

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.
kk12345
 
Posts: 18
Joined: Sun Dec 26, 2010 6:26 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Performance Tuning

Postby NicC » Fri Jan 07, 2011 12:26 am

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: DB2 Performance Tuning

Postby dick scherrer » Fri Jan 07, 2011 3:39 am

Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post