Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Performance Improvement Tips

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> FAQ & Off Topics
View previous topic :: :: View next topic  
Author Message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1696
Location: NY,USA

PostPosted: Wed Mar 14, 2012 8:05 pm    Post subject: DB2 Performance Improvement Tips
Reply with quote

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
View user's profile Send private message

Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Wed Mar 14, 2012 8:41 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1696
Location: NY,USA

PostPosted: Wed Mar 14, 2012 8:44 pm    Post subject:
Reply with quote

Goodman,

Yes, your are right ofcourse.

Anything which does time saving, Disk I/O, CPU utilization eventually will be appriciated.
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1018
Location: Oostende, Belgium

PostPosted: Wed Mar 14, 2012 9:37 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1696
Location: NY,USA

PostPosted: Fri Mar 16, 2012 8:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> FAQ & Off Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm
No new posts DISP=(SHR,PASS) performance opinion steve-myers JCL & VSAM 1 Wed Dec 02, 2015 11:53 pm
No new posts Performance tuning of Online system bipinpeter All Other Mainframe Topics 2 Thu Nov 26, 2015 2:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us