Database Properties

Use the Database Properties window to modify database options, cache options and storage allocation, extend log buffers, and change the owner.

Click the Name field of the database, then click the drop-down arrow and select Properties.

Pages Properties
  • Change Owner – see Changing Ownership of a Database.
  • Instance name (cluster environment only)
  • Data cache – from the drop-down menu, select the cache to which you want to bind the database.
  • Durability level – select one of:
    • NO_RECOVERY – there is no guarantee that, at runtime, committed transactions are written to the disk.
    • AT_SHUTDOWN – all committed transactions are written to disk during a normal server shutdown.
    • FULL – a complete recovery of committed transactions is possible after a system failure.
  • Note: These options apply only to nonclustered version 15.5 and later.
    Default location – specify the default storage location for remote tables if no storage location is provided via sp_addobjectdef. See the section on sysdatabases in the Reference Manual: Tables.
  • DML logging – enable DML logging.
  • Database guest user – guest users are configured on the database.
  • Resynchronize proxy tables – force resynchronization of proxy tables in the proxy databases. See the alter database command in the Reference Manual: Commands .
Transaction Log
  • Details – SAP Control Center displays a graph of the space used by the tables and indexes of your database. Use these values to determine if you have enough unreserved space to accommodate new database objects.

    In SAP ASE version 15.7 ESD #3, "Other" displays the space usage for the object allocation map (OAM). For more information about OAM, see the System Administration Guide: Volume 2.

  • Largest user tables – shows the largest user tables based on space reserved, used space, and row count.
Related tasks
Creating a User Database
Creating a Temporary Database
Creating a Proxy Database
Creating an Archive Database
Creating an In-Memory Database
Creating an In-Memory Temporary Database
Creating a Temporary Database Group
Mounting an SAP ASE Database
Changing Database Ownership
Modifying Database Storage Allocations
Modifying the Transaction Log Cache and the Log I/O Buffer Size
Changing Database Options
Viewing Database Statistics