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
 
PROCSU reduction impact measure

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

New User


Joined: 02 Sep 2010
Posts: 1
Location: Pune

PostPosted: Thu Sep 02, 2010 7:54 pm    Post subject: PROCSU reduction impact measure
Reply with quote

Hi,

Am facing a strange situation. We were trying to improve performance for some query. On doing some query modifications; PROCSU in DSN_STATMNT_TABLE did reduce from 4 to 1. But when I run the jobs using these queries with the same volume of input file records; CPU time is almost same. Does the change in PROCSU reflects somewhere else and not CPU time? Then how the performance would impact. Please share your thoughts.
Back to top
View user's profile Send private message

VENKATA S KRISHNAMOORTHY

New User


Joined: 03 Sep 2010
Posts: 3
Location: CHENNAI, INDIA

PostPosted: Fri Sep 03, 2010 10:57 pm    Post subject: Reply to: PROCSU reduction impact measure
Reply with quote

DB2 EXPLAIN is dynamic in nature. PROCSU is more like a hint provided by optimizer on how much service units (read as resource) a query "might" consume. When you bind your package and execute the actual query optimizer may take a more informed decision depending upon various factors. It is always better to use EXPLAIN PROCSU as an estimate.
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 MIPS/CPU consumption reduction in Batch vishwakotin DFSORT/ICETOOL 4 Sat Mar 18, 2017 5:46 pm
This topic is locked: you cannot edit posts or make replies. MIPS reduction for Batch job Virendra Shambharkar All Other Mainframe Topics 8 Mon Nov 07, 2016 4:02 pm
No new posts z/OS V2R2 Migration Impact on Existin... dexter.mozer All Other Mainframe Topics 4 Mon Feb 29, 2016 6:22 pm
No new posts Increasing a record length of vsam fi... ashim prodhan JCL & VSAM 5 Sat Jun 21, 2014 10:05 pm
No new posts BMC unload execution time reduction ManSab IMS DB/DC 14 Fri Nov 22, 2013 4:34 am

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