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
General	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 .
Devices	Database devices – you can add or remove devices associated with a selected database. See Modifying Database Storage Allocations. Transaction log – you can move the transaction log to a different location. See Modifying Database Storage Allocations.
Transaction Log	Transaction log buffer size – you can modify the I/O buffer size of the transaction log. See Modifying Transaction Log Buffer Size.
Options	Server configuration options – see Changing Database Options.
Usage	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.