DB2 Performance Improvement Tips

Rohit Umarjikar · Posted: Wed Mar 14, 2012 8:05 pm

Hello All,

Could you please highlight on DB2 performance improvement scope for may be existing queries,DB2 unloads,loads,indexes, Stored procedures,GTT..so on.

Somthing which you have implemented and you have saved certain amount of CPU utilization.

Note:I do not any specific case to have suggestion on, but any generic ideas are appriciated.

Thank you!!

Regards,
Rohit

Ed Goodman · Active Member Joined: 08 Jun 2011 Posts: 556 Location: USA

Are you looking ONLY for CPU reduction? What about time savings, or disk I/O?

Are you being billed for CPU, but not the others?

I ask because there is usually a trade off with these types of things. There is also sometimes a dual benefit. As in, you do something to reduce I/O, and it also reduces CPU time taken.

Rohit Umarjikar · Posted: Wed Mar 14, 2012 8:44 pm

Goodman,

Yes, your are right ofcourse.

Anything which does time saving, Disk I/O, CPU utilization eventually will be appriciated.

prino · Posted: Wed Mar 14, 2012 9:37 pm

Do not retrieve the same data over and over again and don't select non-wildcard data you use in your where clause.

Rohit Umarjikar · Posted: Fri Mar 16, 2012 8:10 pm

Prino,
Thanks...

Also, recently we analysed one table which has several indexes on multiple columns but out of which only 2 columns which has indexes were in use.So we then contacted DBA and asked fro removing the indexes on unused columns and then we have seen the significant reduction in the CPU utization in the load JOB. As indexes were taking much more time for organizing the data also REORG utility now takes less time.