Automatic Checking of Database Structures

[Former Member]

In OSS note 521870 SAP recommends to perform a weekly

check of the Database Structures to verify that the

Maxdb database is not corrupt. Unfortunately this

OSS note only describes the manual procedure to

perform this task:

dbmgui -> Check -> Database Structure

Is there any way to easily schedule this also via dbmcli?

The SAP online documentation contains some interesting

information about integrating the check into the CCMS,

here I can see whether the database structure check

was performed recently, but unfortunately I cannot

schedule it

http://dev.mysql.com/doc/maxdb/en/30/5ada6e596211d4aa83006094b92fad/content.htm

All I can find here is to schedule it via DB13,

but unfortunately my SCM 4.1 system is running on

Oracle and I want to check the liveCache on Maxdb,

so I cannot use DB13 for scheduling the check.

[former_member229109 · Accepted solution]

Hello Mark,

Central DBA Planning Calendar ::

"

In the user menu, choose the Central DBA Planning Calendar

(transaction DB13C).

If it is not already there, add your liveCache to the list of systems.

To do this, choose Configuration ® Add System.

System ID: Enter here the liveCache name that you assigned during the

integration of the liveCache (using MaxDB/liveCache System Overview).

Database: Choose SDB/LVC.

Database Release: Choose the liveCache Version in accordance with the    

 version notation .

Select No SAP Basis.

Database Server: Enter the name of the liveCache server.

Connection Name: Enter the name of the database connection.

To switch to a local DBA planning calendar, choose Local Calendar and then

select the system for which you want to edit actions.

"

Please also review the SAP notes 940420, 521870 ( you already know this note ).

And note 820824 FAQ: MaxDB to find the note for the documentation & more -

For SAP liveCache documentation in English:

http://help.sap.com/saphelp_nw04/helpdata/en/f2/0271f49770f0498d32844fc0283645/frameset.htm

->Database Administration in CCMS: SAP liveCache ->

-> Central DBA Planning Calendar

If you are the official SAP customer, I recommend you to create

the ticket to SAP on 'BC-DB-LVC' queue.

Thank you and best regards, Natalia Khlopina