Combining CICS and DB2 performance data

You can create reports that show the DB2® activity caused by a CICS® transaction by combining CICS and DB2 performance data.

For each CICS task, CICS generates an LU6.2 unit-of-work ID. DB2 also creates an LU6.2 unit-of-work ID. Figure 1 shows how DB2 data can be correlated with CICS performance data using the DB2 token (QWHCTOKN) to identify the task.
Figure 1. Correlating a CICS performance-monitoring record with a DB2 accounting record
You can match the NETNAME and UOWID from the CICS performance-monitoring record, to the DB2 token (QWHCTOKN) from the DB2 accounting record.

Matching the NETUOWPX and NETUOWSX fields in a CICS record to the DB2 token, you can create reports that show the DB2 activity caused by a CICS transaction.



dfht3c0053.html | Timestamp icon Last updated: Monday, 5 June 2017