Database specifications define requirements for items such as database size, and the number of database devices per server.
| Item | Requirement | Notes |
|---|---|---|
| Databases per SAP ASE | A maximum of 32,767 databases per server | |
| Maximum database size |
Because SAP ASE reserves 256 logical page IDs—which cannot be allocated or used—at the high end of the logical page range, the sizes listed above are slightly higher than the actual amount of space available for use. This overhead reduces the actual amount of space available by 256 times the logical page size for each listed page size (for example, the actual available size for a 2K server is 8TB – (256 x 2K)). |
|
| 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 SAP ASE 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 |