Modifying Database Storage Allocations

System administrators can use the Database Properties wizard to add or modify space allocations for the database.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • Temporary Databases
    • Proxy Databases
    • Archive Databases
    • In-Memory Databases
    • In-Memory Temporary Databases
  3. Click the Name field of the database, then click the drop-down arrow and select Properties.
  4. Click Devices.
    You see the list of devices to which the database is allocated.
  5. (Optional) Modify storage allocation for your database:
    • Click Add to add space from a different device for your database. Specify whether the space is to be allocated for data or for the transaction log.
    • Click Remove to remove the space allocated to your database from a device. You can only remove devices that are added using the Add option.
    • Click Move log to move the transaction log of a database, with log and data on the same device, to a separate device. See sp_logdevice in the Reference Manual.
  6. (Optional) Click Create log or data fragment with override to force SAP ASE to allocate the data and log devices as specified, even if data and log are specified on the same device.
  7. (Optional) Click Preview to see the SQL statements for your command.
  8. Click Apply.
Related tasks
Changing Database Ownership
Modifying the Transaction Log Cache and the Log I/O Buffer Size
Changing Database Options
Viewing Database Statistics
Related reference
Database Properties