Function documentationDatabase Assistant Locate this document in the navigation structure

 

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).

Integration

In the MaxDB/liveCache System Overview, select the desired database and choose   Goto   Assistant   (transaction DB50 or DB50N).

or

In the user menu, select   Database: Monitoring and Configuration   Database Assistant   (transaction DB50).

Many DBA functions are integral parts of the DBA Cockpit and can therefore be called via the DBA Cockpit.

Prerequisites

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 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.

End of the note.
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.