CORRID processing for compatibility with OMEGAMON
Db2® Query Monitor CORRID processing supports compatibility with IBM® OMEGAMON for Db2 Performance Expert on z/OS® (OMEGAMON) and allows related metrics to be queried between the Db2 Query Monitor performance history database and the OMEGAMON repository.
The correlation columns in the CQM_SUMM_METRICS and CQM_EXCEPTIONS tables include:
- CORRID
- The correlation ID.
- Data type
- CHAR(12)
- CORRNAME
- The correlation ID adjusted by the conventions used by IMS and CICS.
- Data type
- CHAR(8)
- CORRNAME
- The correlation number which is set based on the default OMEGAMON parsing of the CORRID value.
- Data type
- CHAR(8)
- CONNECTION_TYPE
- The Db2 connection type. Valid connection types include:
- 1 - TSO
- TSO Foreground and Background
- 2 - DB2CALL
- Db2 Call Attach
- 3 - IMSDLI
- DL/I Batch
- 4 - CICS®
- CICS Attach
- 5 - IMSBMP
- IMS™ Attach BMP
- 6 - IMSMMP
- IMS Attach MPP
- 7 - DB2PRIV
- Db2 Private Protocol
- 8 - DRDA®
- DRDA Protocol
- 9 - IMSCTL
- IMS Control Region
- A - IMSTRAN
- IMS Transaction BMP
- B - UTILITY
- Db2 Utilities
- C - RRSAF
- RRSAF Attach
- Data type
- INTEGER
OPTKEYS(CORRID) processing does not parse theCORRID value. CORRNAME and CORRNUM values are based on the default OMEGAMON parsing of the CORRID value.
Parsing of the CORRID value to obtain the CORRNAME matches the default OMEGAMON parsing of the CORRID. When OPTKEYS(CORRNAME) is specified the CORRID and CORRNUM values are blanks.
User-specified translation
By specifying the CORRID_TRANSLATION parameter in CQMPARMS, you can control how the CORRNAME and CORRNUM values are parsed from the CORRID.
OMEGAMON uses the Db2® trace record DSNDQWHC to obtain the connection name (QWHCCN) to determine how to parse the correlation ID (QWHCCV).