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 |