Db2® variables for CINT

The CICS® IA collector can capture Db2® EXEC SQL commands that are issued by your applications. If the applications that run in the CICS® regions you are configuring for do not use IBM® Db2®, you can set the COLLECTING Db2 FIELD field to NO and complete the configuration.

Note:

The Db2® subsystem that your CICS® regions are connected to can be different to the Db2® sub system where the CICS® IA database is defined.

COLLECTING Db2® INFORMATION: Set this field to YES or NO depending on whether you want to capture Db2® EXEC SQL commands.
REQUIRED.

Db2® VERSION: The Db2® version number. This variable is used with Db2® compatibility mode to decide which Db2® programs to bind and which Db2® resources are defined to enable the collection of EXEC SQL commands. This field defaults to V910.
REQUIRED.

Db2® COMPATABILITY MODE: Db2® sub systems can run in compatibility mode, CM, and in new function mode, NF. For example, Db2® 10 on z/OS® in CM is designed for Db2® 10 to be used as a drop in replacement for Db2® 9. If you are in compatibility mode, set this field to YES. This field is used with the Db2® version number to decide which Db2® programs to bind and which Db2® resources are defined to enable the collection of EXEC SQL commands.
REQUIRED.

Db2® LOAD DATA SET NAME: The data set name for the Db2® SDSNLOAD library.
REQUIRED.

Db2® SDSNEXIT DATA SET NAME: The data set name for the DB2 SDSNEXIT library. If you don't use a DB2 SDSNEXIT library then use the name of your DB2 SDSNLOAD library instead.
REQUIRED.

Db2® RUNLIB DATA SET NAME: The data set name for the Db2® RUNLIB.LOAD library.
REQUIRED.

Db2® SUB SYSTEM: The Db2® sub system identifier to which your CICS® regions are connected.
REQUIRED.

Db2® TABLE QUALIFIER: The Db2® qualifier, sometimes referred to as schema, for the SYSIBM database tables that are accessed by the CICS® IA collector. This value is used to set the QUALIFIER when you bind the CICS® IA Db2® collector programs. This field defaults to SYSIBM.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed.

Db2® TABLE OWNER: The TSO user ID that owns the Db2® resources that are required to enable the collection of EXEC SQL commands. This value is used to set the CURRENT SQLID during the creation of the Db2® objects and as the OWNER when you bind the CICS® IA Db2® CICS® programs.
REQUIRED.

Db2® BUFFERPOOL FOR INDEX: The Db2® BUFFERPOOL value that is used in the CREATE INDEX DDL statements. The CICS® IA collector accesses SYSIBM tables to retrieve data about the EXEC SQL commands. CICS® IA supplies sample INDEXES to improve the performance access to these tables.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to BP1.

Db2® PLAN NAME FOR DSNTEP2: The Db2® plan name for Db2® utility DSNTEP2.
REQUIRED.

Db2® PLAN NAME FOR CICS®: CICS® IA uses a number of Db2® programs in CICS® to access SYSIBM tables to retrieve data about the EXEC SQL commands. These programs are bound and packaged into this Db2® plan. Access to this plan can be granted to the required RACF® group or user ID. Access is required for only the user ID that the CICS® IA collector is started by. This variable is typically the default CICS® user ID. The plan name is also used to define the DB2TRAN and DB2ENTRY to CICS®. This field defaults to IA63CICS.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed.

Db2® COLLECTION ID: The Db2® collection identifier for the CICS® IA Db2® packages. This value is used during the bind of the Db2® packages and the Db2® CICS® plan that is used by CICS® IA. This field defaults to IA63COLL.
REQUIRED for a Full configuration. For a Short configuration, this field is not displayed

Db2® AUTHORIZATION ID: The Db2® authorization ID that is used to grant access to the CICS IA Db2® plans. The authorization ID can be set to a RACF® user ID, a RACF® group, or PUBLIC. CICS® IA uses a CICS® program to access SYSIBM tables to retrieve the data about the EXEC SQL command. These programs are bound and packaged into a Db2® plan. Access to this plan is then granted to the authorization ID. Set this field to the user ID under which CICS® IA runs.
OPTIONAL. For a Short configuration, this field is not displayed.