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
- DCLSTMT
- The decimal value of the statement number (the STMTNO column in the Db2 SYSPACKSTMT table) for the DECLARE statement that corresponds to this SQL. This value should be used when a query number is not set by Db2. A value of -1 is displayed if STMTNO cannot be found.
- Offload table name
- CQM_SQLCODE_DET
- Column name
- DECLARE_STMT_NUM
- 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
- QUERYNO
- The decimal value of the Db2 query number from the QUERYNO column in the Db2 SYSPACKSTMT table. A value of -1 is displayed if QUERYNO cannot be found in the SYSPACKSTMT table for this SQL.
- Offload table name
- CQM_SQLCODE_DET
- Column name
- QUERY_NUMBER
- SECT#
- The section number.
- Offload table name
- CQM_SQLCODE_DET
- Column name
- SECTION
- Sqlcode
- The SQL return code issued by conref="GUID-f19c3fc8-730a-4346-9497-bfed895564c6.dita#conrefs/db2"/>.
- Offload table name
- CQM_SQLCODE_DET
- Column name
- SQLERRM
- SSID
- The Db2 subsystem on which the activity occurred.
- STMT#
- The statement number assigned by PRECOMPILER.
- Offload table name
- CQM_SQLCODE_DET
- Column name
- STMT
- STMTID
- The SQL statement number assigned by the Db2 precompiler to an individual SQL call.
- Offload table name
- CQM_SQLCODE_DET
- Column name
- STMT_ID
- Statement Type
- The type of SQL call executed by a package or DBRM within Db2 (for example, PREPARE, OPEN, and FETCH).
- 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.