Is 148 (thread-stats) written to SMF?

Article Id: 32460

Status: Published

Updated On: 14-02-2018 08:27

Legacy Id: TEC1700536

Products:

CA Bind Analyzer for DB2 for z/OS , CA SQL-Ease for DB2 for z/OS , CA Sysview Performance Management Option for DB2 for z/OS , CA Database Detector for DB2 for z/OS , CA Plan Analyzer for DB2 for z/OS , CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction:

Question:

Is IFCID 148 (thread-stats) written to SMF? If so, can you easily filter/extract the data from SMF?

Answer:

Record 148 (thread-stats) is not written to SMF. This record is only captured with a MONITOR type trace. Insight's MONITOR trace is always started with destination (OPx), not SMF. Accounting record (003) is nearly identical and offers a field called QMDA_CONNECTIONS which reports on the DB2 connection name.

Additional Information:

Some other information that might also help clarify is found in Chapter 3 of the Writing Requests Manual under the heading of Reporting Control Block Data

Environment:

Release:
Component: CIDB