SYSTEM LEVEL THRESHOLD field (WFSTGUSE_SYSTEM_THRESHOLD subsystem parameter)
The WFSTGUSE_SYSTEM_THRESHOLD subsystem parameter 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 a warning message is issued.
Space in the work file database can be configured for declared temporary table work and for sort work. Sort work includes work for global temporary tables and transition tables for triggers.
| Acceptable values: | 0–100 |
|---|---|
| Default: | 90 |
| Update: | option 18 on panel DSNTIPB |
| DSNZPxxx: | WFSTGUSE_SYSTEM_THRESHOLD |
- 1–100
- If the WFDBSEP subsystem parameter is set to YES, Db2 issues a warning message when the percentage of total temporary work file space or the percentage of total sort work file space that is consumed by all agents exceeds this value.
If WFDBSEP is set to NO, Db2 issues a warning message when the percentage of all work file space that is consumed by all agents exceeds this value.
- 0
- Db2 does not issue system-level space usage warnings for the work file database.