PAGE SET PAGE NUMBERING field (PAGESET_PAGENUM subsystem parameter)
The PAGESET_PAGENUM subsystem parameter specifies whether partition-by-range table spaces and associated partitioned indexes are created to use absolute page numbers across partitions or relative page numbers.
This subsystem parameter is new in Db2 12. It can be set at any function level, but it takes effect only after activation of function level 500 or higher.
| Acceptable values: | RELATIVE or ABSOLUTE |
|---|---|
| Default: | ABSOLUTE |
| Update: | option 15 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM.PAGESET_PAGENUM |
| Data sharing scope: | Use the same value on all members. |
- RELATIVE
- Partition-by-range table spaces are created so that PGNUM in the page header has no partition number, and the partition number is contained only in the header page for the partition. The same numbering system applies to partitioned indexes on a table in a table space with relative page numbering.
- ABSOLUTE
- Partition-by-range table spaces and associated indexes are created with absolute page numbers. The default for PAGESET_PAGENUM is ABSOLUTE.
