Sysview for Db2 request APPLEXCP RECORD SORT-ENDED lacks CORR-ID, PLAN-NAME and CONN-NAME

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

In Sysview Performance Management Option for Db2 for z/OS (IDB2) request hlq.CDBATREQ(APPLEXCP),
the record SORT-ENDED (IFCID 96) does not contain CORR-ID, PLAN-NAME or CONN-NAME.

Where are the values coming from for these fields?

Resolution

CORR-ID, PLAN-NAME, and CONN-NAME are what is known as common fields. They may not be in the SORT-ENDED record,
but they are kept separately for use in any request. This is documented in the IDB2 documentation under IFCID Records / Common Fields.