9. PROCESSING › 9.2 Collector Options And Operation

9.2 Collector Options And Operation

The collection of accounting type 101 and statistical type
101 data is optional with DB2.  To obtain the maximum benefit
from the DB2 Analyzer, both record types should be collected.
To enable the collection of DB2 accounting and statistical
data:

 1. Update the SMFPRMxx member of SYS1.PARMLIB by using a
    utility such as IEBUPDTE.  SMFPRM determines which
    records SMF will allow to be written.  Use SET SMFPRM=xx
    to select the member dynamically and cause SMF to begin
    logging DB2 records.

 2. Do one of the following as appropriate:

     a. During DB2 installation, use the ISPF installation
        panels to choose accounting and statistics.

     b. During an update to the DB2 installation parameters,
        use the appropriate ISPF panel to specify that DB2
        accounting and statistics data should be written to
        SMF.

     c. Activate the new SMFPRMxx member.  To do this, re-IPL 
        the system specifying the member (SMF=xx) or use the 
        SET SMF=xx command.

 3. Restart DB2 using the new installation parameters.

 4. To prepare the SMF data for processing, dump the SMF
    records to a sequential data set using the IFASMFDP
    routine.