how does db2 plan binds the packages

IBM's flagship relational database management system

how does db2 plan binds the packages

Postby dhoomphatash » Thu Nov 20, 2014 3:33 am

I am new to the COBOL db2 field, so excuse me if the information is not sufficient.

We have 3 COBOL db2 programs which work just fine. Package bind and then plan bind works as usual and we do use changeman. Now my question is once a plan bind is complete, and then I update one of the 3 programs (updates are to the COBOL portion only. no change to the sql queries) changeman automatically does a package bind(which is fine and understandable). Now Is it necessary to do a plan bind again? And when I see the packages in the plan thru fileaid ca screen, I see the contoken is updated automatically in the plan for the particular package. Any help with how the plan gets updated with the new package information when a plan bind wasn't even done would be immensely appreciated.

Posts: 10
Joined: Sat May 15, 2010 2:44 am
Has thanked: 0 time
Been thanked: 0 time

Re: how does db2 plan binds the packages

Postby alexm » Wed Nov 26, 2014 9:36 pm

Hi dhoomphatash,

"binding an application" in DB2 z/OS Application Programming and SQL Guide and its related sub-chapters would by a good starting point for this type of questions (the link takes you to DB2 version 10 for z/OS, you may need to navigate to your version's library)

Happy reading,
User avatar
Posts: 35
Joined: Wed Oct 13, 2010 6:40 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DB2


  • Related topics
    Last post