Correlation ID translation

The correlation ID is a Db2® field that identifies the task executed by Db2.

The correlation ID contains:
Batch jobs
Jobname
TSO applications
Original authorization ID (the logon user ID)
Applications using the Db2 call attachment facility
Original authorization ID (the logon user ID)
CICS® transactions
Connection type, thread type, thread number, and the transaction ID
IMS applications
PST number and PSBNAME of the application
RRS applications
The character string provided by the application during signon

Particularly for CICS and IMS it is useful to break the correlation ID into several parts, so that you can easily distinguish the transaction ID (for CICS threads) from the PSBNAME (for IMS threads).