Bookmark and Share
RSS

Recent Posts

Converting DBRMs to Packages in DB2 12

March 14, 2017

Prior to DB2 12, the DB2 bind command allowed you to specify either a list of database request modules (DBRM) using the member keyword or a list of packages using the PKLIST (package list) keyword. However, IBM, which deprecated the member keyword option in DB2 10, has removed it entirely from DB2 12. So any migration to DB2 12 should include taking the steps needed to rebind all plans without the member keyword.

To do this, you must locate all your current plans that have a DBRM, bind the DBRMs into a package and then bind the plan using PKLIST. The IBM Knowledge Center has more about converting DBRMs to packages.

In DB2 12, both existing plans and any new plans that go through the bind/rebind process will automatically be converted to PKLIST. DBRMs will be added to a collection named DSN_DEFAULT_COLLID_plan-name.

Given this BIND command:

BIND PLAN(HR01) -
     MEMBER(HRPGM01) -
     ACTION(ADD) -
     ISOLATION(CS) -
     OWNER(TROY) -
     QUALIFIER(PRODHR) -
     CACHESIZE(0) -
     ENABLE(CICS) CICS(CON1)


The DBRM member HRPGM01 will be bound into a package: DSN_DEFAULT_COLLID-HR01.HRPGM01. This is equivalent to performing these BIND PLAN and BIND PACKAGE commands:

BIND PLAN(HR01) -
     PKLIST(DSN_DEFAULT_COLLID_HR01.HRPGM01) -
     ACTION(ADD) -
     OWNER(TROY) -
     ENABLE(CICS) CICS(CON1)

BIND PACKAGE (DSN_DEFAULT_COLLID_HR01)
     MEMBER(HRPGM01) -
     ACTION(ADD) -
     ISOLATION(CS) -
     OWNER(TROY) -
     QUALIFIER(PRODHR) -
     CACHESIZE(0) -
     ENABLE(CICS) CICS(CON1)


If you prefer having a little more control over the naming convention used for collection names, use the bind package command to implement your shop standard collection name in place of the default DSN_DEFAULT_COLLID_plan-name.

If you find collection names like DSN_DEFAULT_COLLID on your system, it's essential that you modify your change control procedures today and replace the member keyword with PKLIST.

Posted March 14, 2017 | Permalink

comments powered by Disqus