Work file database enhancements
Db2 11 provides improved monitoring of storage use in the work file database so that you can alleviate storage shortages before application failures occur.
In Db2 11, Db2 provides the following improvements to help you monitor disk storage use in the work file database:
- Two subsystem parameters that provide threshold levels for alerts
about work file storage shortages, and two messages that provide the
alerts:
- WFSTGUSE_AGENT_THRESHOLD
- This subsystem parameter enables you to control when a message is issued to indicate that an agent is using too much disk space in the work file database. WFSTGUSE_AGENT_THRESHOLD determines the percentage of available space in the work file database on a Db2 subsystem or data sharing member that can be consumed by a single agent before message DSNI052I is issued.
- WFSTGUSE_SYSTEM_THRESHOLD
- This subsystem parameter enables you to control when a message is issued to indicate that the total disk space that is being used in the work file database by all agents is too great. WFSTGUSE_SYSTEM_THRESHOLD determines the percentage of available space in the work file database on a Db2 subsystem or data sharing member that can be consumed by all agents before message DSNI053I is issued.
- New statistics class 1 trace records that track work file space usage.