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. These records can be directed to an SMF data set by:
To do this the MON,SMFACCT and/or SMFSTAT of the initialization macro DSN6SYSP are set to YES. See the DB2 Universal Database™ for OS/390® and z/OS® Administration Guide for more details.
Add entries for type 100, 101, and 102 records to the existing SMF member (SMFPRMxx) entry in SYS1.PARMLIB.
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 performace 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.