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.
- 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.
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 IA53CICS.
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 IA53COLL.
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.