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