DSNI053I csect-name THE DB2 SUBSYSTEM HAS EXCEEDED THE THRESHOLD FOR STORAGE USE IN WORK FILE DATABASE database-name FOR object-type. THRESHOLD=percentage PERCENT. TOTAL STORAGE CONFIGURED=total-storage KB.

Explanation

This message warns of a possible storage shortage in the work file database. The amount of storage that is being used has exceeded the system-level warning threshold that is defined by subsystem parameter WFSTGUSE_SYSTEM_THRESHOLD.

csect-name
The name of the control section that issued the message.
database-name
The name of the work file database.
object-type
The type of object. Possible values are:
DECLARED GLOBAL TEMP TABLES
Specifies that the storage is being used for declared temporary tables.
WORK FILES
Specifies that the storage is being used for work files.
DECLARED GLOBAL TEMP TABLES AND WORK FILES
Specifies that the storage is being used for declared temporary tables and work files.
percentage
The maximum percentage of work file database storage that is used before this warning is issued. This value is the value of subsystem parameter WFSTGUSE_SYSTEM_THRESHOLD.
total-storage
The total amount of storage that is configured for the work file database, in kilobytes.

This message is issued at five-minute intervals, for as long as the criteria for issuing the message are met.

System action

Processing continues.

If the situation is not alleviated, applications that use the work file database might fail.

System programmer response

Determine whether the warning threshold that is specified by subsystem parameter WFSTGUSE_SYSTEM_THRESHOLD is too low.

If WFSTGUSE_AGENT_THRESHOLD is not too low, take one or both of the following actions:
  • Create additional table spaces in the work file database of the object types that are specified in this message.

    Use the DSNTWFG exec in job step DSNTIST of installation job DSNTIJTM to create additional table spaces.

  • Change the value of subsystem parameter WFDBSEP from NO to YES.

    Work file table spaces can be used for declared temporary tables or for work file work, such as sorting. When subsystem parameter WFDBSEP is set to NO, Db2 selects work file table spaces that can grow into secondary extents for declared temporary tables, and chooses work file table spaces that cannot grow into secondary extents for work file work. If there is not enough space in one type of table space, Db2 switches to the other type. When Db2 uses work file table spaces that are designated for work file activity for declared temporary tables, space for work file activity might be quickly consumed. When Db2 uses work file table spaces that are designated for declared temporary tables for work file activity, space for declared temporary table tables might be rapidly consumed because of growth through secondary extents. To prevent Db2 from switching from one type of table space to the other, set WFDBSEP to YES. Doing so can cause high-consuming agents to experience resource unavailable conditions, but can help protect other agents on the system that are using work file resources.