Filter
Top Products
Configuration Guide 109
CHAPTER 9
Managing Adaptive Server
Databases
The administration of Adaptive Server databases includes both routine
tasks and performance and tuning considerations.
•The System Administration Guide discusses most of the
administrative tasks in detail.
•The Performance and Tuning Guide provides in-depth explanations
of performance issues.
Managing database devices
The term database device refers to a disk or a portion of a disk that stores
Adaptive Server databases and database objects.
Device requirements
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
Topic Page
Managing database devices 109