PAGE SET PAGE NUMBERING field (PAGESET_PAGENUM subsystem parameter)

The PAGESET_PAGENUM subsystem parameter specifies whether partition-by-range (PBR) table spaces and associated partitioned indexes are created to use relative page numbering (RPN) or absolute page numbering across the data partitions. Absolute page numbering is deprecated for PBR table spaces.

Acceptable values:	RELATIVE or ABSOLUTE
Default:	RELATIVE
Update:	option 15 on panel DSNTIPB
DSNZPxxx:	DSN6SPRM.PAGESET_PAGENUM
Data sharing scope:	Use the same value on all members.

RELATIVE

PBR table spaces are created with relative page numbers. That is, the 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. The default for PAGESET_PAGENUM is RELATIVE.

ABSOLUTE (deprecated)

PBR table spaces and associated indexes are created with absolute page numbering.

Tip: For best results, use relative page numbering (RPN) for PBR table spaces. RPN allows for larger partitions and more flexibility for partition growth. Absolute page numbering is deprecated for PBR table spaces.