Specifying DB2 connection parameters
The following keyword values and positional parameters are valid for the DB2 subsystem type:
ssn | Required. The MVS subsystem name (one to four characters) of the DB2 subsystem that AR/CTL attaches. This name is determined by your site and must match the name identified to MVS during MVS system generation. |
|---|---|
SYS1 | Optional. AR/CTL maintains this field for compatibility with IMS. |
esmt | Required. The table name (one to eight characters) of the DB2 external subsystem module table. This table is created by DB2 and defined in DB2. The usual module name is DSNMIN10. It specifies the DB2 modules that AR/CTL must load and the work areas that AR/CTL must create. AR/CTL maintains this field for compatibility with IMS. |
rtt | Optional. The table name (one to eight characters) of the resource translation table. This table is created by DB2 with the DSNMAPN macro. AR/CTL uses the resource translation table to map an application program module to a DB2 application plan. AR/CTL maintains this field for compatibility with IMS. For more information about generation of the resource translation table, see the DB2 administration documentation. |
reo | Optional. The region error option code (one character) that determines the action AR/CTL takes if the application program issues a DB2 request before connection to the DB2 subsystem is complete or if problems are encountered with the DB2 subsystem. The table shows values that are valid. The default value is R: |
Value | Description |
|---|---|
R | AR/CTL sends an SQL return code to the application program, indicating that the request for DB2 services has failed. If AR/CTL cannot establish an initial connection to DB2, it does not send an SQL return code; the application program terminates with a U1776 abend. |
Q | AR/CTL does not use this value when executing without IMS but maintains it for compatibility with IMS. AR/CTL translates the value to A. |
A | AR/CTL issues a U1776 abend for the application program. |
crc | Optional. The command recognition character. AR/CTL does not use this value but maintains it for compatibility with IMS. The value can be any single EBCDIC character. |
|---|