Disk Resource Issues

Many SAP ASE defaults are set to reasonable values for aspects of storage management, such as database, table, and index location, and how much space is allocated for each one. Responsibility for storage allocation and management is often centralized, and usually, the system administrator has ultimate control over the allocation of disk resources to SAP ASE and the physical placement of databases, tables, and indexes on those resources.

• 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.
• Commands for Managing Disk Resources
  SAP ASE offers many commands and strategies for managing disk resources.
• Considerations in Storage Management Decisions
  The system administrator must make many decisions regarding the physical allocation of space to SAP ASE databases.
• Status and Defaults at Installation
  The installation program and scripts initialize the master device and set up the master, model, sybsystemprocs, sybsecurity, and temporary databases for you.
• System Tables That Manage Storage
  Two system tables in the master database, sysusages and sysdevices, and three more in each user database (syssegments, sysindexes, and syspartitions) track the placement of databases, tables (including the transaction log table, syslogs), and indexes.