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).
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.
In the MaxDB/liveCache System Overview, select the desired database and choose (transaction DB50 or DB50N).
In the user menu, select (transaction DB50).
Many DBA functions are part of the DBA Cockpit and can therefore be called through the DBA Cockpit (transaction DBACOCKPIT).
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.
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.
Database Administration, Troubleshooting
Database Administration, Monitoring Databases