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 specifies the maximum number of partition groups that can be allocated by Adaptive Server. Partition groups are internal structures used by Adaptive Server to control access to individual partitions of a table. Partition groups are used while upgrading or during a load database upgrade to unpartition Adaptive Server 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.