When configuring a new system, the system administrator must consider several issues that have a direct impact on the number and size of disk resources required. These device allocation issues refer to commands and procedures that add disk resources to Adaptive Server.
Task |
Chapter |
|---|---|
Initialize and allocate a default pool of database devices |
|
Mirror database devices for recovery |
Chapter 2, “Mirroring Database Devices,” in System Administration Guide: Volume 2 |
After the initial disk resources have been allocated to Adaptive Server, the system administrator, database owner, and object owners should consider how to place databases and database objects on specific database devices. These object placement issues determine where database objects reside on your system and whether or not the objects share devices. Object placement tasks are discussed throughout this manual, including the chapters shown in Table 6-2.
Task |
Chapter |
|---|---|
Place databases on specific database devices |
Chapter 6, “Creating and Managing User Databases,” in System Administration Guide: Volume 2 |
Place tables and indexes on specific database devices |
Chapter 6, “Creating and Managing User Databases,” in System Administration Guide: Volume 2 |
Do not consider allocating devices separately from object placement. For example, if you decide that a particular table must reside on a dedicated pair of devices, first allocate those devices to Adaptive Server. The remaining sections in this chapter provide an overview that spans both device allocation and object placement issues, providing pointers to chapters where appropriate.
