SQLCODEs - columns (ISPF)
These columns are available for use on the various SQLCODEs panels.
- Authid
- The primary authorization ID.
- Collection ID
- The collection ID.
- CorrID
- The correlation ID.
- Connname
- The connection name.
- DBRM/Package
- The Db2 package or DBRM name.
- Jobname
- The name of the job.
- 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.
- SECT#
- The section number.
- Sqlcode
- The SQL return code issued by Db2.
- SSID
- The Db2 subsystem on which the activity occurred.
- STMT#
- The statement number assigned by PRECOMPILER.
- Statement Type
- The type of SQL call executed by a package or DBRM within Db2 (for example, PREPARE, OPEN, FETCH, etc).
- Timestamp
- The timestamp of the SQLCODE.
- SQLCODE
- The return codes in the SQLCODE and SQLSTATE host variables or corresponding fields of the SQLCA.