Accessing DB2 for zOS Using a Resource Translation Table

Accessing DB2 for z/OS Using a Resource Translation Table

The resource translation table (RTT) maps IMS application control block names to DB2 for z/OS plan names. When an IMS transaction accesses DB2 for z/OS, the plan name used is, by default, the IMS application control block name. The control block name is the same as the PSB name that is specified in the APPLCTN macro. For more information about the APPLCTN macro, see "IMS System Definition Macros" on page 335.

The RTT is assembled in a CSECT with the name that is the same as the label of the first macro in the table. This CSECT must then be placed in an APF authorized library in the IMS.SDFSRESL concatenation of the IMS control region. The RTT is pointed to in the PROCLIB member that defines the DB2 attachment. If the RTT parameter is null, the RTT is not used.

It is possible to set up an RTT that translates an IMS application control block name to a different DB2 plan name. Setting up such a table is described in the DB2 for z/OS (not IMS) documentation. See "Defining DB2 plans for IMS applications (optional)" in DB2 Universal Database for z/OS Installation Guide for details on how to generate a resource translation table.

The reassembled table is picked up the next time IMS is stopped or started or after a stop (/STO SUBSYS xxxx) and restart (/STA SUBSYS xxxx) of the DB2 connection.