LiveCache Hosekeeping jobs

[Former Member]

Hi,

Can anyone help me to find a note or document which describes MaxDb/LiveCache hose keeping jobs ? I am looking for liveCache optimizer statistics, database structure checks etc.

Thanks in advance

Thanks

Prince Jose

[former_member229109]

Hello Prince Jose,

What is the version of the liveCache? What is the version of your system?

What is the version/SP of the SAP Basis SP?

1) Please review the SAP note::

521870 Database structure check (Verify/Check Data) of a liveCache

If you are using 3.0A or SAP APO 3.1 to SAP APO=> SAP note:

608608 Creating the SQL optimizer statistics in the liveCache

Please review the SAP notes::

990602 FAQ: CCMS for MaxDB/SAP liveCache technology

945757 Daily job for administration of monitoring data

You could use the Central DBA Planning Calendar to schedule the DBA jobs.

For example, see the SAP documentation at:

http://help.sap.com/saphelp_nw70/helpdata/en/b6/cbdda6248ff648ae9f39f8e28eb24f/frameset.htm

-> Database Administration in CCMS: SAP liveCache Technology

-> DBA Planning Calendar

< You could schedule to run Data backups, Log backups, Updating statistics for the SQL Optimizer,

Checking database structures, Storing and checking backups, Updating table statistics >

2) For SAP liveCache documentation see the SAP note 767598.

3) You are running liveCache, please also pay attention to the SAP note::

800927 Standard jobs in the SCM/APO area

Thank you and best regards, Natalia Khlopina