View previous topic :: View next topic
|
Author |
Message |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
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 |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Goodman,
Yes, your are right ofcourse.
Anything which does time saving, Disk I/O, CPU utilization eventually will be appriciated. |
|
Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009 Posts: 1306 Location: Vilnius, Lithuania
|
|
|
|
Do not retrieve the same data over and over again and don't select non-wildcard data you use in your where clause. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
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. |
|
Back to top |
|
|
|