CMF-DB2 record selection

For the DB2® report, CMF record selection is the same as for all CMF Performance reports, with an additional criterion:
DB2 accounting record selection is based on:
  1. CMFONLY. Suppress DB2 record processing.
  2. SMFSTART, SMFSTOP. Like the CMF performance records, filter the DB2 Accounting records based on the SMF time stamp.
  3. SELECT(PERFORMANCE. INCLUDE or EXCLUDE DB2 Accounting records based on whether the DB2 thread Begin-End times are within the specified FROM-TO report intervals. Also you can filter the DB2 Accounting records based on UOWID field values.
  4. APPLID. Select by CICS® generic APPLID.
  5. SSID. Select by DB2 Subsystem ID.
Note: DB2 end time can be after CMF stop time if thread protection is in place. Consequently, if you specify SMFSTOP when protected threads are in use, it is possible that DB2 Accounting records are excluded that relate to CMF records that are included. In normal circumstances, 5 minutes (the initial DB2 thread PURGECYCLE delay after CICS startup) is expected to be the longest period an inactive DB2 thread is present before it is terminated by a PURGECYCLE. To allow for this, you should specify the SMFSTOP time at least 5 minutes after the ‘required stop time' specified in the FROM/TO report interval in the SELECT statement.

Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//report-reference/db2rsel.htm