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 for the type of work file operation, as described in the following table. FL 508 A partition-by-growth (PBG) table space that was created with FOR SORT is never used for DGTT processing.
Work file operation Preferred table space attributes DGTT work - FL 508 PBG table space created with or without FOR DGTT
- Segmented (non-UTS) table space with a non-zero SECQTY value
- Db2-managed segmented (non-UTS) table space with SECQTY 0
- User-managed table space with any SECQTY value
Sort work - Optimal least-used table space with any of the following attributes:
- FL 508 PBG table space created with FOR SORT
- Segmented (non-UTS) table space with SECQTY 0
- User-managed table space with any SECQTY value
- If no table spaces with preferred attributes for sort operations are available, Db2 reverts to using a table space that is preferred for DGTT operations.
- YES
-
Db2 attempts to direct 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.
Work file operation Preferred table space attributes DGTT work - FL 508 PBG table space created with or without FOR DGTT
- Segmented (non-UTS) table space with a non-zero SECQTY value
Sort work -
Optimal least-used table space with any of the following attributes:
- PBG table space that was created with FOR SORT
- Segmented (non-UTS) table space with SECQTY 0
- User-managed table space with any SECQTY value