SEPARATE WORK FILES field (WFDBSEP subsystem parameter)
The WFDBSEP subsystem parameter specifies whether DB2® should provide an unconditional separation of table spaces in the work file database based on the allocation attributes of the table spaces.
| Acceptable values: | YES, NO |
| Default: | NO |
| Update: | option 10 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM.WFDBSEP |
- YES
- DB2 directs declared global temporary table work only to DB2-managed (STOGROUP) work file table spaces that are defined as partition-by-growth (regardless of the SECQTY setting) or segmented (non-universal) table spaces with a non-zero SECQTY setting. DB2 directs work file work only to DB2-managed table spaces that are defined as segmented (non-universal) with a zero SECQTY value or user-managed table spaces. If no table space with the preferred allocation type is available, DB2 issues an error message, a negative SQLCODE, or both.
- NO
- DB2 attempts to direct declared global temporary table work to DB2-managed (STOGROUP) work file table spaces that are defined as partition-by-growth (regardless of the SECQTY value). It then attempts to direct the work to segmented (non-universal) table spaces with a non-zero SECQTY value. DB2 attempts to direct work file work to DB2-managed table spaces that are defined as segmented (non-universal) with a zero SECQTY value or user-managed table spaces. If no table space with the preferred allocation type is available, DB2 selects a table space with a non-preferred allocation type.
