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)

CORRNUM

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

The CONNECTION_TYPE is used for parsing the CORRID value.

Data type

INTEGER

OPTKEYS(CORRID) processing does not parse the CORRID 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).