partition groups

partition groups specifies the maximum number of partition groups that can be allocated by SAP ASE.

Summary Information

Default value

1024

Range of values

1–2147483647

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration groups

Memory Use, Meta-Data Cache

Partition groups are internal structures used by SAP ASE to control access to individual partitions of a table. Partition groups are used while upgrading or during a load database upgrade to unpartition SAP ASE 12.5.x and earlier partitions.

The default value allows a maximum 1024 open partition groups and a maximum of 2147483647 open partitions. The actual number of partitions may be slightly less, due to the grouping of partitions.