Displaying the Database Properties

Prerequisites

You are logged on to the database as database system administrator or as a DBM operator.
The database is in the ONLINE operational state.

Note that in ADMIN operational state, not all database properties are displayed.

Procedure

Select the database in the explorer tree.
In the context menu of the database, choose Administration.

Open the Overview tab page.

Area	Property	Description
General	Name	Database name <database_computer>:<database_name>
Operational State	Operational State
Version	Version of the database software
Operating System	Operating system of the database computer
Instance Type	Database Type
Installation Path	Installation path of the database software
Global Programs Path	Directory
Global Data Path	Directory
Private Data Path	Directory
Run Directory Path	Run Directory
Warnings		Displays warnings, for example if you need to carry out a backup, if the overwrite modus for the log area is activated, if you have damaged indexes or other warnings
Settings To change a setting, choose the corresponding link (where available).	Automatic Log Backup	Activating or Deactivating Automatic Log Backup
Monitoring	Analyzing Database Performance: Overview
Database Trace	Creating a Database Trace
Database Analyzer	Starting or Stopping Database Analyzer
Dynamic Data Area Adjustment	Activating or Deactivating the Dynamic Adjustment of the Data Area
Automatic Recreation of Bad Indexes	Activating or Deactivating the Automatic Recreation of Damaged Indexes
Automatic Statistics Update	Activating or Deactivating the Automatic SQL Optimizer Statistics Update
Database Event Dispatcher	Managing Database Events
Snapshots	Making Snapshots of the Data Area
Data Cache	Data Cache Size	Size
Data Cache Hit Rate	The lower the hit rate, the poorer your system's performance. We recommend a hit rate of > 99% for the data cache.
Hot Standby (only available in hot standby systems)	Virtual Computer Name	Virtual server name of the hot standby system
Shared Log Area	Indicates the type of hot standby system: No shared log area Shared log area For more information about hot standby systems, see Setting Up Hot Standby Systems: Overview.
Log Shipping	For hot standby systems (no shared resources only) Information about the time it takes to transfer log entries from the master database to the standby database and write them to the log area of the standby database.
Table	Status of the databases in the hot standby system

Next Steps

Database Administration, Creating Databases