DSNI052I csect-name AN AGENT 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. CONNECTION ID = connection-id. CORRELATION ID = correlation-id. LUWID=luwid. PACKAGE NAME=package-name. PLAN NAME=plan-name.
Explanation
The total amount of storage that an agent used in the work file database exceeded the threshold that is defined by subsystem parameter WFSTGUSE_AGENT_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 an agent can use before this message is issued. This value is the value of subsystem parameter WFSTGUSE_AGENT_THRESHOLD.
- total-storage
- The total amount of storage that is configured for the specified object type, in kilobytes.
- connection-id
- The connection identifier of the agent.
- correlation-id
- The correlation identifier of the agent.
- luwid
- The logical unit of work ID of the agent. An asterisk (*) denotes that the thread originated at the local site.
- package-name
- The package name that is associated with the agent.
- plan-name
- The plan name that is associated with the agent.
This message is issued once within each commit scope in the application.
System action
Processing continues.
System programmer response
Work with the application programmer to determine how the application program is using space in the work file database.
Determine whether the threshold that is specified by subsystem parameter WFSTGUSE_AGENT_THRESHOLD is too low.
- 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.
Programmer response
Use the agent information in the message to determine which application exceeded space use threshold WFSTGUSE_AGENT_THRESHOLD. Examine the application to determine the ways in which the application is using space in the work file database.