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.