CICS Performance Db2 Variables

This section describes variable information for the CICS Performance Db2 variable class.
cspm16
While the information in this topic remains supported, it has been deprecated in favor of newer variable definitions.
Syntax:
The following sample syntax creates a tabular report using the TAB command. Substitute
id_option
and
variable_name
from the following tables:
TAB [DATETIME | DATE | TIME]
id_option
, CICS [PERFORMANCE] DB2
variable_name
END RUN
ID Options
Use any CICS Performance Db2 variables with the following ID options:
ID Option
Description
ABCODE
Abend codes for transactions
APPLID
VTAM APPLIDs of CICS regions of the CICS system
DB2PROG
Db2 requesting programs
DB2STYPE
Db2 statement types
DB2PSNUM
Db2 precompiler statement numbers
ENDTIME
Transaction end time
JOBNAME
CICS jobname
STARTTIME
Transaction start time
SYSID
MVS system ID
TERMID
Terminal IDs
TRANID
Transaction IDs
TRANNUM
Transaction numbers
USERID
User IDs
VTAMLU
VTAM logical unit names of terminals
Variables
The following table provides a list of available variables for the CICS Performance Db2 variable class:
Variable Name
SMF Type
SMF Subtype
SMF Field
Description
REQUEST
255
27
MNSDB2_Requests
Number of Db2 requests
REQTime
255
27
MNSDB2_Time / MNSDB2_Requests
Average Db2 request time, in seconds
MAXREQTime
255
27
MNSDB2_Time_Max
Maximum Db2 request time, in seconds
Example
The following example uses CICS PERFORMANCE Db2 variables in a TAB report:
TAB DATETIME JOBNAME, CICS PERFORMANCE DB2 REQUEST AND, CICS PERFORMANCE DB2 REQTIME AND, CICS PERFORMANCE DB2 MAXREQTIME END RUN