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 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 V10 on z/OS® in CM is designed for DB2 V10 to be used as a drop in replacement for DB2 V9. 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 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.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed. End of change

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.

Start of changeREQUIRED for a Full configuration. For a Short configuration, this field is not displayed and defaults to BP1.End of change

DB2 PLAN NAME FOR DSNTEP2
The DB2 plan name for DB2 utility DSNTEP2.

REQUIRED.

DB2 PLAN NAME FOR CICS
Start of changeCICS 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 IA53CICS.

REQUIRED for a Full configuration. For a Short configuration, this field is not displayed.

End of change
DB2 COLLECTION ID
Start of change 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 IA53COLL.

REQUIRED for a Full configuration. For a Short configuration, this field is not displayed.

End of change
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.

Start of changeOPTIONAL. For a Short configuration, this field is not displayed.End of change