Recording SMF trace data

Each location is responsible for processing the SMF records produced by Db2 trace.

Procedure

Begin program-specific programming interface information.To record SMF trace data, use the following approaches:

  • Use the z/OS® operator command SETSMF or SS to alter SMF parameters that you specified previously. 
    SETSMF SYS(TYPE(100:102))
    To execute this command, specify PROMPT(ALL) or PROMPT(LIST) in the SMFPRMxx member used from SYS1.PARMLIB. If you are not using measured usage licensing, do not specify type 89 records or you incur the overhead of collecting that data.
    Statistics (record type 100), accounting (record type 101), and performance (record type 102) data are recorded to SMF.
  • Use the SMF program IFASMFDP to dump these records to a sequential data set.
    You might want to develop an application or use IBM® OMEGAMON® for Db2 Performance Expert on z/OS to process these records.End program-specific programming interface information.