SEPARATE WORK FILES field (WFDBSEP subsystem parameter)

The WFDBSEP subsystem parameter specifies whether Db2 unconditionally separates table spaces in the work file database based on the allocation attributes of the table spaces.

Acceptable values: NO, YES
Default: NO
Update: option 18 on panel DSNTIPB
DSNZPxxx: DSN6SPRM.WFDBSEP
NO
Db2 attempts to direct work file operations based on the preferred table space allocation attributes in the following table. If no table space is available with the preferred attributes, Db2 selects a table space with a non-preferred allocation type.
YES
Db2 attempts directs work file operations only to table spaces with the preferred allocation attributes in the following table. When YES is specified and no table space is available with the preferred attributes, Db2 issues an error message, a negative SQLCODE, or both.

DGTTs cannot span table spaces when this setting is used.

Start of change

Preferred allocation attributes for Db2 work files

Regardless of the specified WFDBSEP setting, Db2 always prefers to use table spaces with the following allocation attributes for declared global temporary table (DGTT) and other work file operations such as sort.

Start of change
Work file operation Preferred table space attributes
DGTT work
  1. A Db2-managed (STOGROUP) partition-by-growth (PBG) table space (with any SECQTY value)
  2. A segmented (non-UTS) table space with a non-zero SECQTY value
Sort work
  1. A Db2-managed segmented (non-UTS) table spaces with a zero SECQTY value
  2. A user-managed table space, regardless of secondary space allocation
End of change End of change