Allocating SMF buffers
When you specify a performance trace type, the volume of data that Db2 can collect can be quite large. If you are sending this data to SMF, you must allocate adequate SMF buffers; the default buffer settings are probably insufficient.
About this task
If an SMF buffer shortage occurs,
SMF rejects any trace records sent to it. Db2 sends
a message (DSNW133I) to the MVS™ operator
when this occurs. Db2 treats
the error as temporary and remains active even though data could be
lost. Db2 sends
another message (DSNW123I) to the z/OS® operator
when the shortage has been alleviated and trace recording has resumed.
You can determine if trace data has been lost by examining the Db2 statistics records with an IFCID of 0001, as mapped by macro DSNDQWST. These records show:
- The number of trace records successfully written
- The number of trace records that could not be written
- The reason for the failure
If your location uses SMF for performance data or global trace data, be sure that:
Procedure
To allocate SMF buffers: