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
 
Is it mandatory to Rebind after we perform RUNSTATS

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

New User


Joined: 04 Jun 2009
Posts: 30
Location: Bangalore

PostPosted: Fri Mar 01, 2013 2:02 pm    Post subject: Is it mandatory to Rebind after we perform RUNSTATS
Reply with quote

Hi, I am performing RUNSTATS on table space.

So, do I need to rebind my Cobol-Db2 modules before i run them the next time.

When i tried running the same it ran fine, but as a process do i need to REBIND.

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

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Mar 01, 2013 3:39 pm    Post subject:
Reply with quote

Furor,

It depends on the reason why you are running RUNSTATS.

If you are running runstats just to keep the statistics of the table and index up-to-date and your program is already running fine. You don't have to run rebind.

If you are analyzing a program and you found out that stats are out-of-date or n/a, then you have to rebind.

Thanks,
Sushanth
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 How to perform Digest Access Authenti... vasanthz All Other Mainframe Topics 0 Tue Mar 15, 2016 4:47 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts How to embed RUNSTATS in an applicati... ravindra.vadali DB2 4 Tue Oct 15, 2013 8:33 pm
No new posts Rebind package not working as intended Abhinav Chandra DB2 10 Tue Oct 01, 2013 7:24 pm
No new posts Is Rebind required for dynamic SQL Co... Furor DB2 1 Thu Sep 19, 2013 9:35 am

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