DEFINE DATA SETS field (IMPDSDEF subsystem parameter)
The IMPDSDEF subsystem parameter specifies whether Db2 is to define the underlying data set for certain implicitly created table spaces and indexes.
This parameter applies to:
- Base table spaces
- Index spaces of indexes that are implicitly created on base tables
- Implicitly created LOB or XML table spaces
- Auxiliary indexes
- Node ID indexes
- Document ID indexes
| Acceptable values: | YES, NO |
|---|---|
| Default: | YES |
| Update: | option16 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP IMPDSDEF |
- YES
- Underlying data sets are defined when the table space or index space is created. This is the default setting.
- NO
- Underlying data sets are defined when data is first inserted into the table or index.
However, if all of the following conditions are met, underlying data sets are defined when the table space or index space is created:
- The table contains an LOB column.
- The table is in a clone relationship.
- The containing table space is a partition-by-growth table space.