Database Assistant

Use

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

Integration

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

or

In the User menu, choose Database: Monitoring and Configuration ® Database Assistant (transaction DB50).

Prerequisites

Prerequisites

Features

You can display the properties of the database instance.

The following views and functions are available:

?     Alert Monitor

?     Current Status

?     Problem Analysis

?     Statistics

?     Tools

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.

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

Session Mode

The Database Manager CLI program offers various operation modes. If you do not perform any other actions, you are working in command mode.  Creating and terminating sessions to execute a command are very expensive. We therefore recommend the use of the session mode. The use of a session is, in some, cases even necessary if a successive command is to be made in a certain status that can only be created by a preceding command in the same session (for example, transactions).

To activate or deactivate session mode, choose Activate the DBM Session Mode or Deactivate the DBM Session Mode.

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.