Database Properties

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

Click Properties on your database to initiate the Properties wizard.

Wizard Option	Database 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 crash. Note: These options only apply to nonclustered Adaptive Server version 15.5 and later. Default location – Specify the default storage location to be used for remote tables if no storage location is provided via the stored procedure sp_addobjectdef. See the section on sysdatabases in the System Tables chapter of the Adaptive Server Reference Manual. DML logging – Click to enable DML logging. Database guest user – Select if guest users are configured on the database. Resynchronize proxy tables – Select this option to force re-synchronization of proxy tables in the proxy databases. See the alter database command in the Adaptive Server Reference Manual .
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	Table and index space – Sybase 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 Adaptive Server 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 for Adaptive Server Enterprise 15.7 ESD #2.