Device Allocation and Object Placement

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 SAP ASE.

Device allocation documentation

Task

See

Initialize and allocate a default pool of database devices

System Administration Guide: Volume 1 > Initializing Database Devices

Mirror database devices for recovery

System Administration Guide: Volume 2 > Mirroring Database Devices

After the initial disk resources have been allocated to SAP ASE, 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

Task

See

Place databases on specific database devices

System Administration Guide: Volume 2 > Creating and Managing User Databases

Place tables and indexes on specific database devices

System Administration Guide: Volume 2 > Creating and Managing User Databases

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 SAP ASE.