SQLCODEs - columns (ISPF)

These columns are available for use on the various SQLCODEs panels.

Authid
The primary authorization ID.
Offload table name
CQM_SQLCODE_DET
Column name
AUTHID
Collection ID
The collection ID.
Offload table name
CQM_SQLCODE_DET
Column name
COLLECTION
CorrID
The correlation ID.
Offload table name
CQM_SQLCODE_DET
Column name
CORRID
Connname
The connection name.
Offload table name
CQM_SQLCODE_DET
Column name
CONNECTION
DBRM/Package
The Db2 package or DBRM name.
Offload table name
CQM_SQLCODE_DET
Column name
PROGRAM
Jobname
The name of the job.
Offload table name
CQM_SQLCODE_DET
Column name
JOBNAME
Occurrences
The number of instances of the SQL code. An asterisk (*) next to the number of instances of the SQL code denotes that the number of detail records collected for the SQL code has reached the maximum SQL code detail value that you have set in CQMPARMS. An asterisk is only shown for the current interval on the local Query Monitor Subsystem .
Plan
The Db2 plan name.
Offload table name
CQM_SQLCODE_DET
Column name
PLAN
SECT#
The section number.
Offload table name
CQM_SQLCODE_DET
Column name
SECTION
Sqlcode
The SQL return code issued by Db2.
Offload table name
CQM_SQLCODE_DET
Column name
SQLCODE
SSID
The Db2 subsystem on which the activity occurred.
Offload table name
CQM_SQLCODES
Column name
DB2_SUBSYSTEM
STMT#
The statement number assigned by PRECOMPILER.
Offload table name
CQM_SQLCODE_DET
Column name
STMT
Statement Type
The type of SQL call executed by a package or DBRM within Db2 (for example, PREPARE, OPEN, FETCH, etc).
Offload table name
CQM_SQLCODE_DET
Column name
TYPE
Timestamp
The timestamp of the SQLCODE.
Offload table name
CQM_SQLCODE_DET
Column name
SQLCODE_TIMESTAMP
SQLCODE
The return codes in the SQLCODE and SQLSTATE host variables or corresponding fields of the SQLCA.