Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Where to START for improve performance

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Feb 04, 2009 5:41 pm    Post subject: Where to START for improve performance
Reply with quote

Hi,

I have consolidated an SQL report, it has INDB2_TIME, INDB2_CPU & planname.
INDB2_TIME - Time spent within DB2 for this statement
INDB2_CPU - CPU time spent processing this statement

I was told to find which PLAN takes a lot of time - That's done.
Now i was told to find some methods for improving ?

What i want to know is, where to start & what to see ?

Open to IDEAS & Suggestion,
Sushanth
Back to top
View user's profile Send private message

Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Wed Feb 04, 2009 8:01 pm    Post subject:
Reply with quote

Explain the PLAN. Find out the pain point queries. Check if there is a better way of writing an equivaent query. Check if the new equivalent query is actually better than the original.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Feb 05, 2009 4:38 pm    Post subject:
Reply with quote

Yes i also thought about that Bharath. EXPLAIN.
Quote:
Check if there is a better way of writing an equivalent query.

What if the queries are done dynamically using PREPARE STATMENT like that. Right now iam looking at the WAREHOUSING sub-system & its PLANs.
Suggesting MQT's are on my list.
What are the other things i need to look in WAREHOUSING kind of scenarios.

Sushanth
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Thu Feb 05, 2009 5:11 pm    Post subject:
Reply with quote

Quote:
What if the queries are done dynamically using PREPARE STATMENT like that.

Suggest to change it to static SQL. Dynamic SQLs are major pain points.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Creating ISPF Screens with Scrname vi... Albireo20 TSO/ISPF 9 Tue Sep 05, 2017 4:24 pm
No new posts How to Clear all TSQs during CICS sta... Hooman24 CICS 10 Mon Jun 26, 2017 9:46 pm
No new posts CONTIG for performance? JPVRoff JCL & VSAM 8 Fri Jun 09, 2017 8:39 am
No new posts BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts CICS START AND CANCEL blayek CICS 1 Wed Dec 07, 2016 3:27 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us