Administration of SAP liveCache Technology 
SAP liveCache technology is an object-based enhancement of the SAP MaxDB database system and was developed to manage complex objects (for example in logistical solutions such as SAP SCM/APO).
In solutions of this type, large volumes of data must be permanently available and modifiable. You can use SAP liveCache technology to represent data structures and data flows (such as networks and relationships) more easily and effectively.
In contrast to SAP MaxDB, with an optimally configured SAP liveCache database, all data which must be accessible to the database system is located in the main memory.
Getting Started
You can find information on the concepts from SAP MaxDB and SAP liveCache technology in Concepts of the Database System Use the Glossary to find a topic in the documentation quickly.
Tools
The following tools are available for administering and monitoring your SAP liveCache database:
· Database Manager: Database Manager GUI (graphical user interface) and Database Manager CLI (command line tool)
· Database console XCONS
Tasks on Demand
Perform the tasks in the table below when the corresponding events occur.
Event |
Task |
Tool |
More Information |
Database OFFLINE |
Switching the database to the ONLINE operational state (Starting liveCache) |
liveCache Assistant Database Manager |
|
Database instance failure with loss of data |
Restoring the database instance |
Database Manager |
|
Damaged index |
Restoring the damaged index |
Database Manager |
|
Performance problems |
Analyzing slow-running transactions |
liveCache Assistant Database Analyzer Database Manager |
|
Database connection to another system required |
Creating a connection |
liveCache Assistant |
|
New database version available |
Upgrading the database instance |
SAPInst |
See also the SAP notes for the recommended parameter values for SAP liveCache technology under the component BC-DB-LVC. |
System copy required |
Creating a system copy |
SAPInst |
SAP Note 210564 |
Other errors |
liveCache Assistant Database Manager XCONS |
Transaction LCA13 |
Upgrade Guide – SAP NetWeaver 7.0 liveCache Technology 
Periodic Tasks
Regularly perform the tasks listed in the table below. If possible, use the liveCache planning calendar for these tasks.
Recommendation
We recommend that you activate the automatic log backup. Log backups are the prerequisite for a complete backup history.
Occurrence |
Task |
Recommended Tool |
More Information |
Daily |
Monitoring the database instance and checking if there are any alerts Monitoring the Main Memory Areas Activities Overview (I/O, locking, logging) User Tasks (database sessions) |
liveCache Alert Monitor DBA Planning Calendar |
|
Monitoring CPU usage |
Operating system commands |
||
Scheduling a complete data backup If you cannot or do not want to perform a complete data backup every day, then you should perform at least an incremental data backup on each productive day. The more current the last data backup is, the fewer log entries have to be imported again if you need to restore the database instance. |
DBA Planning Calendar |
||
Weekly |
Only necessary for log backups on data carriers of the File type |
Operating system commands Database Manager |
|
Scheduling an Interactive Log Backup Only necessary if automatic log backup is switched off |
DBA Planning Calendar |
||
DBA Planning Calendar |
|||
DBA Planning Calendar |
More information:
Documentation: Database Administration in CCMS: SAP liveCache Technology
Overview of available documentation on SAP liveCache technology
Overview of available documentation for MaxDB