Database specifications define requirements for items such as database size, and the number of database devices per server.
Item | Requirement | Notes |
---|---|---|
Databases per Adaptive Server | A maximum of 32,767 databases per server | |
Maximum database size | ||
Minimum allowable sybsystemprocs database | 136MB | Required for an upgrade |
Maximum size of a database device (disk partition) | 242 (4TB) | If the operating system supports file sizes up to 4TB, then Adaptive Server supports file system devices up to 4TB |
Maximum number of database devices per server | 231 | |
Maximum number of devices or device pieces per database | Unlimited | Limited by available memory |
Maximum number of segments per database | 31 | |
Maximum number of login IDs per serve | 2147516416 | |
Maximum number of users per database | 2146484223 | |
Maximum number of groups per database | 1032193 |