Starting SMF for Db2 accounting, statistics, and tuning

Through its instrumentation facility, Db2® produces a system management facility (SMF) type 101 accounting record at each CICS® Db2 thread termination and at each CICS Db2 signon. Db2 also produces an SMF type 100 record to hold Db2 statistics on a Db2 sub system basis. Performance and global trace records are produced as SMF type 102 records.

About this task

The SMF records produced by Db2 can be directed to an SMF data set in the following ways:
  • Specifying at Db2 installation that accounting or statistics data or both are required.

    To do this the MON,SMFACCT or SMFSTAT of the initialization macro DSN6SYSP are set to YES. See Db2 for z/OS product documentation for more details.

  • Activating SMF to write the records.

    Add entries for type 100, 101, and 102 records to the existing SMF member (SMFPRMxx) entry in SYS1.PARMLIB.

  • Starting Db2 trace.

    Starting Db2 trace can be done at Db2 startup time by setting the parameters of the initialization macro DSN6SYSP, or by using the Db2 -START TRACE command giving the specific trace and classes to be started. The latter is the way to start recording accounting, statistics and performance data on a periodic basis.

Db2 does not produce any reports from the recorded data for accounting, monitoring, or performance purposes. To produce your own reports you can write your own programs to process this data, or use the Db2 Performance Monitor (DB2PM) Program Product.