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.
Database: Properties Area
Property
Description
General
Name
Database name
<database_computer>:<database_name>
State
Operational state of the database
Version
Version of the database software
Operating System
Operating system of the database computer
Installation Path
Installation path of the database software
Global Program Path
More information: Glossary, Directory
Global Data Path
More information: Glossary, Directory
Private Data Path
More information: Glossary, Directory
Run Directory Path
Warnings
Displays warnings, for example if you need to carry out a backup.
Settings
To change settings, choose the corresponding link (where available).
Automatic Log Backup
Command Monitor
You can use the command monitor to analyze long-running SQL statements and identify bottlenecks.
Resource Monitor
You can use the resource monitor to monitor resource usage in the database and identify expensive SQL statements.
Database Trace
Database Analyzer
Data Area Extension
Activating or Deactivating Automatic Extension of the Data Area
Automatic Recreation of Bad Indexes
Activating or Deactivating the Automatic Recreation of Damaged I
Automatic Statistics Update
Activating or Deactivating the Automatic SQL Optimizer Statistics Update
Database Event Dispatcher
Snapshots
Data Cache
Size
Size
Hit Rate
The lower the hit rate, the poorer your system's performance.
We recommend a hit rate of > 99% for the data cache.
More Information
Database Administration, Creating Databases