Migrating to the Db2 13 ODBC driver

When you migrate the ODBC driver for Db2 for z/OS® from the Db2 12 driver to the Db2 13 driver, you must set up the Db2 13 ODBC run time environment.

About this task

You must bind the Db2 13 ODBC DBRMs to each data source you want to migrate to the Db2 13 ODBC driver.

The online bind sample is available in DSN1310.SDSNSAMP(DSNTIJCL). You can use this bind sample as a guide for binding DBRMs to packages and binding an application plan.

Procedure

To migrate to the Db2 13 ODBC driver:

  1. Bind the DBRMs in DSND10.SDSNDBRM to all data sources to which your ODBC applications connect. You must specify ENCODING(EBCDIC) when you bind the ODBC DBRMs to the local Db2 for z/OS subsystem.
  2. Create at least one Db2 plan. Use the PKLIST keyword to specify all the packages that you create from the DBRMs
    Specify an appropriate ACTION parameter in the BIND PLAN statement:
    • If the plan does not exist, specify ACTION(ADD).

      If you specify ACTION(ADD), and the plan exists, the BIND command fails, and Db2 does not create a plan.

    • If the plan exists, and you want to retain the EXECUTE privilege on the plan for all users who already have that privilege, specify ACTION(REPLACE) RETAIN.
    • If the plan exists, and you want to revoke the EXECUTE privilege for everyone except the plan owner, specify ACTION(REPLACE). This is the default.