DEFAULT PARTITION SEGSIZE field (DPSEGSZ subsystem parameter)
The DPSEGSZ subsystem parameter specifies the default segment size in pages for a CREATE TABLESPACE statement that omits the SEGSIZE clause.
Acceptable values: | 0, 4–64 (multiples of 4) |
---|---|
Default: | 32 |
Update: | option 15 on panel DSNTIPB |
DSNZPxxx: | DSN6SYSP.DPSEGSZ |
The DPSEGSZ subsystem parameter has no effect for the creation of table spaces in a work file database or implicitly created table spaces. For explicit CREATE TABLESPACE statements that omit the SEGSIZE clause, it has the following effects:
- 0
- The default value is SEGSIZE 32.
- 4–64 (multiples of 4)
- The default SEGSIZE value is the specified value.