page utilization percent  partition spinlock ratio

Chapter 5: Setting Configuration Parameters

partition groups

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 during upgrade 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 16384 (1024 times 16) open partitions. The actual number of partitions may be slightly less, due to the grouping of partitions.





Copyright © 2005. Sybase Inc. All rights reserved. partition spinlock ratio

View this book as PDF