Show TOC

Database AssistantLocate this document in the navigation structure

Use

The Database Assistant (also known as the DB Assistant) is a tool for database administration in the CCMS. You can administer local or remote databases (with the exception of SAP liveCache databases).

Note

For SAP liveCache technology, you can use the liveCache Assistant. The documentation for the Database Assistant usually also applies for the liveCache Assistant. If there are functional differences, these are explained.

Integration

In the MaxDB/liveCache System Overview, select the desired database and choose Start of the navigation path Goto Next navigation step Assistant End of the navigation path (transaction DB50 or DB50N).

or

In the user menu, select Start of the navigation path Database: Monitoring and Configuration Next navigation step Database Assistant End of the navigation path (transaction DB50).

Many DBA functions are part of the DBA Cockpit and can therefore be called through the DBA Cockpit (transaction DBACOCKPIT).

Prerequisites
Features

You can display the properties of the database.

The following views and functions are available:

You could also display or change integration data, or have the error codes or information from system tables of schema SYSINFO displayed, amongst other things.

Note

The information displayed in the specific areas can vary depending on the specific database version in use. It is possible that only some of the information described is displayed for certain database versions.

Displaying Critical States (Alerts)

When you begin work with the database assistant, a query immediately appears to ask whether you want to have the critical states (Alerts) displayed. If you do not require this option, you can prevent the window appearing for all users by switching it off. Select the relevant option in the window or go to Automatic Monitoring.

More Information