Adaptive Server devices and databases are subject to the following limits:
The maximum device size is 4TB.
The minimum usable device size depends on the servers logical page size. Databases manage space in groups of 256 logical pages, and the smallest specifiable disk piece size is 1MB, so the smallest usable device is the larger of 1MB or 256 logical pages:
The minimum device size for a 2K page server is 1MB
The minimum device size for a 4K page server is 1MB
The minimum device size for an 8K page server is 2MB
The minimum device size for a 16K page server is 4MB
The maximum number of database devices is 2,147,483,647. However, Adaptive Server must retain a description of each device in memory, so in practice this number is limited by your system’s memory. Your operating system also limits how many devices one program can open simultaneously.
A database can contain up to 2,147,483,648 logical pages, so its maximum size depends on its logical page size:
The maximum database size on a 2K page server is 4TB.
The maximum database size on a 4K page server is 8TB.
The maximum database size on an 8K page server is 16TB.
The maximum database size on a 16K page server is 32TB.
The minimum database size is the size of the installation’s model database.
Each database is stored on one or more database devices, in one or more disk pieces. The maximum number of disk pieces in one database is 8,388,608. However, Adaptive Server must retain a description of all active databases, so in practice this number is also limited by your operating system memory.
By default, srvbuild creates the
devices in $SYBASE/data directory.
