Workfile Database Panel (DSNTIP91)

This topic shows detailed information about System Parameters - Workfile Database Panel (DSNTIP91).

System Parameters - Workfile Database Panel (DSNTIP91)

The field labels shown in the following sample layout of System Parameters - Workfile Database Panel (DSNTIP91) are described in the following section. 


WORKFILE DATABASE PANEL (DSNTIP91)                             
----------------------------------                             
MAX TEMP STORAGE PER AGENT IN MB (MAXTEMPS)..............25,000
SEPARATE WORK FILES (WFDBSEP)................................NO
MAX TEMP RID (MAXTEMPS_RID)................................NONE
AGENT LEVEL THRESHOLD (WFSTGUSE_AGENT_THRESHOLD)............N/A
SYSTEM LEVEL THRESHOLD (WFSTGUSE_SYSTEM_THRESHOLD)..........N/A
MAX TEMP STORAGE PER AGENT IN MB (MAXTEMPS)

The maximum amount of temporary storage in megabytes (MB) for each agent.

Install parameter MAX TEMP STORAGE on panel DSNTIP6 or ZPARM MAXTEMPS in DSNTIP9.

Field Name: QWP4WFAL

SEPARATE WORK FILES (WFDBSEP)

YES directs processing of declared temporary tables only to Db2-managed table spaces that are defined with SECQTY>0 (Db2 field: QWP4WFDBSEP). It directs all other processing to Db2-managed table spaces that are defined with SECQTY=0 or to user-managed table spaces. This field corresponds to field "Separate Work Files" in installation panel DSNTIP9. The ZPARM name is WFDBSEP in DSN6SPRM.

Field Name: QWP4WFDBSEP

MAX TEMP RID (MAXTEMPS_RID)

The maximum number of RID blocks of temporary storage in the Workfile database that a single RID list can use at any point in time. This field corresponds to field MAX TEMP RID on installation panel DSNTIP9. The ZPARM name is MAXTEMPS_RID.

It can have the following values:
  • -1 if MAXTEMPS_RID=NONE
  • 0 if MAXTEMPS_RID=NOLIMIT
  • 1 to 329166 otherwise

Field Name: QWP4WFRD

AGENT LEVEL THRESHOLD (WFSTGUSE_AGENT_THRESHOLD)

Specifies the percentage of space that is used in the Workfile Database by a single agent when Db2 issues a warning message.

This value corresponds to field AGENT LEVEL THRESHOLD on installation panel DSNTIP91. The ZPARM name is WFSTGUSE_AGENT_THRESHOLD in DSN6SPRM.

Field Name: QWP4WFSAT

SYSTEM LEVEL THRESHOLD (WFSTGUSE_SYSTEM_THRESHOLD)

Specifies the percentage of space that is used in the Workfile Database by all agents in a Db2 subsystem or data sharing member when Db2 issues a warning message.

This value corresponds to field SYSTEM LEVEL THRESHOLD on installation panel DSNTIP91. The ZPARM name is WFSTGUSE_SYSTEM_THRESHOLD in DSN6SPRM.

Field Name: QWP4WFSST