Compile new DB2 program in Changeman

Add new DB2 program in Changeman

Point to take care while creating new DB2 program in changeman and to promote it to test regions

Create a PKG member in the package where a new DB2 program is present. This member is required in order for DBRM to be promoted to the test region. If this member is not present, changeman gives error while promoting DBRM.

          BIND PACKAGE      (PVNPRBDL) +

                MEMBER          (PVNBPBOT) + 

                OWNER            (DABOC) + 

                QUALIFIER       (PVNDB001) + 

                ACTION           (REPLACE) + 

                DEGREE          (1) +  

                ISOLATION      (CS) + 

                VALIDATE       (BIND) + 

                EXPLAIN         (YES) +  

                 RELEASE       (COMMIT) + 

                CURRENTDATA  (YES) 

Member name = New program name.

Whenever we promote a DB2 component we need to promote all the three components related to the program namely DBR, LDB,PKG. Bind will automatically occur.

So we do not require a separate JCL to bind.

                PVNPNOT           DBR

                PVNPNOT           LDB

                PVNPNOT           PKG

In some mainframe enviornments, do not bind a program to a plan, since in the environment a lot of packages are bound to a plan. Doing a plan bind results in corruption of plan as only one DBRM is bound to the specific plan then.

So always do a package bind by the above process in case plan is bound by various packages in the test region. (Please check environment details with DBA before binding any program).