View previous topic :: View next topic
|
Author |
Message |
srilata83
New User
Joined: 02 Apr 2009 Posts: 16 Location: chennai
|
|
|
|
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 |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
Back to top |
|
|
ashishsr123
New User
Joined: 06 May 2008 Posts: 33 Location: Chennai
|
|
|
|
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 |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
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 |
|
|
|