IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Is it mandatory to Rebind after we perform RUNSTATS


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 1020
Location: India

PostPosted: Fri Mar 01, 2013 3:39 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Use of Perform Thru Exit COBOL Programming 6
No new posts Rebind issue - Package DB2 2
No new posts How to perform Digest Access Authenti... All Other Mainframe Topics 0
No new posts Should we Rebind Plan if no SQL changes DB2 2
No new posts How to embed RUNSTATS in an applicati... DB2 4
Search our Forums:

Back to Top