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
 
Bind and Rebind

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

New User


Joined: 02 Apr 2009
Posts: 16
Location: chennai

PostPosted: Wed Apr 22, 2009 6:06 pm    Post subject: Bind and Rebind
Reply with quote

Hi All,
Can anyone tell me what is bind and rebind in DB2 ?As someone told me Bind has to done from the beginning so as to generate a new timestamp and it generally done when there is any changes made in cobol program.
but when rebind has to done?can anyone tell me the scenario when we have to go for rebind instead of bind.
i was checking for the plans whether the binding has done for this or not, then i found many plans are not bound.what shud we go for in this case, BIND or REBIND?
If there is no changes made in cobol program then shall we go for Rebind, but why?

Please clarify my doubts and correct me if my understanding is wrong about this concept.

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

ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Wed Apr 22, 2009 7:36 pm    Post subject:
Reply with quote

http://ibmmainframes.com/viewtopic.php?t=23965
Back to top
View user's profile Send private message
ashishsr123

New User


Joined: 06 May 2008
Posts: 33
Location: Chennai

PostPosted: Wed Apr 22, 2009 10:50 pm    Post subject:
Reply with quote

Quote:
If there is no changes made in cobol program then shall we go for Rebind, but why?


Rebind will reassess the optimized access paths and if required choose some other access path.
This will be done when, there has been lot of insertion & Deletions in the Database . This generally happens over long period of time.
Whenever you will RE0RG database then also you will use it.

That's what I think.
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 193
Location: chennai

PostPosted: Thu Apr 23, 2009 12:57 am    Post subject: Reply to: Bind and Rebind
Reply with quote

Hi srilata83

It is better to go through the link and read the manual as ashimer replied, because there has been a lot of things to know about BIND and REBIND.
If you have doubts after reading the IBM manual, post your doubts. Someone will clear it.

Regards
Raghu
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 Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
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 What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts What is Bind Error? Chetan Kumar Mainframe Interview Questions 1 Fri Oct 16, 2015 7:00 pm

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