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
 
DB2 Explain

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

New User


Joined: 11 Nov 2011
Posts: 24
Location: India

PostPosted: Wed Aug 28, 2013 6:23 pm    Post subject: DB2 Explain
Reply with quote

Hello All,

Does DB2 explain take into account the amount of Data present in Tables?

If I have less data in my test region compared to the production enviorment, will the explains against each enviorment produce different results ?

Thanks,
Sabari Girish
Back to top
View user's profile Send private message

agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Wed Aug 28, 2013 7:08 pm    Post subject:
Reply with quote

Yes. That's why you hear the suggestion to get the latest RUNSTATS so often.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 658
Location: Whitby, ON, Canada

PostPosted: Wed Aug 28, 2013 9:54 pm    Post subject:
Reply with quote

It you have the knowledge and the necessary authority the catalog stats can be manipulated to simulate, in a test environment catalog, what the production table will look like after it is populated. This authority is probably restricted to your local DBA team.
Back to top
View user's profile Send private message
girishbs13

New User


Joined: 11 Nov 2011
Posts: 24
Location: India

PostPosted: Tue Sep 03, 2013 5:45 pm    Post subject:
Reply with quote

thanks for the information
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 Can someone explain me this JCL line ... PeterHolland JCL & VSAM 9 Sat Dec 12, 2015 7:22 am
No new posts can some one explain the below code... ram_vizag JCL & VSAM 3 Thu Aug 22, 2013 4:35 pm
No new posts Please explain this SQL CODE. tamminenisidhartha DB2 4 Wed Mar 13, 2013 5:05 pm
No new posts Explain Comparision Report gylbharat DB2 4 Tue Jun 05, 2012 5:48 pm
No new posts Explain what ICETOOL will do for trai... esaccy DFSORT/ICETOOL 13 Fri May 27, 2011 2:37 pm

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