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.
Difference between Bind and Rebind
Moderators: Kalicharan, Moderator Group
REBINDs are usually done during the maintenance. When there are lot of inserts/updates/deletes were done on the table, there is a potential of having data spread far from its page. In order to regain the performance, tables will be reorganized and statistics will be collected. These new statistics will not be available for the DB2 programs (plans & packages) until they are bound again with these new statistics. When you rebind DB2 can use the new statistics and update the access paths so that the programs can perform better / efficiently.
Kishore
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
hi,
Suggest you spend some time here with this link Sticky:Plans,DBRMS,Packages,Collections,Versions ..Confusion. and post us back if you still have questions . . .
Suggest you spend some time here with this link Sticky:Plans,DBRMS,Packages,Collections,Versions ..Confusion. and post us back if you still have questions . . .
Regards,
Anuj
Anuj
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page