Start of Content Area

Background documentation SAP liveCache Technology Locate the document in its SAP Library structure

SAP liveCache technology is an object-based enhancement of the MaxDB database system and was developed to manage complex objects (e.g. 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 MaxDB, with an optimally configured SAP liveCache database instance, all data which must be accessible to the database system is located in the main memory.

First Steps

You can find information on the concepts from MaxDB and SAP liveCache technology in Structure linkConcepts of the Database System Use the Structure linkGlossary to find a topic in the documentation quickly.

Tools

The following tools are available for administering and monitoring your liveCache database instance:

Structure linkDBA Planning Calendar

Structure linkliveCache Assistant

Structure linkliveCache Alert Monitor

Database Manager: Structure linkDatabase Manager GUI (graphical user interface) and Structure linkDatabase Manager CLI (command line tool)

Structure linkDatabase Analyzer

Database console Structure linkXCONS

Tasks on Demand

Perform the tasks in the table below when the corresponding events occur.

Event

Task

Tool

More Information

Database OFFLINE

Switch the database instance to the ONLINE operational state (Structure linkstarting liveCache)

liveCache Assistant

Database Manager

Structure linkOperational State

Database instance failure with loss of data

Restoring the Database Instance

Database Manager

Structure linkRestoring the Database Instance

Damaged index

Restore the damaged index

Database Manager

Structure linkIndex

Structure linkIndex Analysis

Performance problems

Analyze Structure linkSlow-Running Transactions

liveCache Assistant

Database Analyzer

Database Manager

Structure linkPerformance

Database connection to another system required

Create a connection

liveCache Assistant

Structure linkName of the Database Connection

New database version available

Upgrade the database instance

SAPInst

service.sap.com/upgradeNW70 ®  Upgrade Guide – SAP NetWeaver 7.0 liveCache Technology

See also the SAP notes for the recommended parameter values for SAP liveCache technology under the component BC-DB-LVC.

System copy required

Create a system copy

SAPInst

SAP Note 210564

Other errors

Structure linkProblem Analysis

liveCache Assistant

Database Manager

XCONS

Structure linkTroubleshooting

Transaction LCA13

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

Monitor the database instance and check if there are any alerts

Structure linkMonitoring the Data Area

Structure linkMonitoring the Log Area

Structure linkMonitoring the Main Memory Areas

Structure linkMonitoring OMS Versions

Structure linkActivities Overview (I/O, locking, logging)

Structure linkUser Tasks (database sessions)

Structure linkPerformance

Structure linkBackup/Recovery

liveCache Alert Monitor

DBA Planning Calendar

Structure linkOMS Monitoring

Structure linkMonitoring:

 

Monitor CPU usage

Operating system commands

Structure linkOverview of Processes

 

Structure linkScheduling 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

Structure linkBacking up Data

Weekly

Structure linkArchiving Backup Files

Only necessary for log backups on data carriers of the File type

Operating system commands

Database Manager

Structure linkArchiving Backup Files

 

Structure linkScheduling an Interactive Log Backup

Only necessary if automatic log backup is switched off

DBA Planning Calendar

Structure linkBacking Up Log Entries

 

Structure linkScheduling a Database Structure Check

DBA Planning Calendar

Structure linkChecking Database Structures

 

Structure linkScheduling Updates of the SQL Optimizer Statistics

DBA Planning Calendar

Structure linkSQL Optimizer Statistics

See also:

Structure linkDatabase Administration in CCMS: SAP liveCache Technology

Structure linkMaxDB Security Guide

Overview of available documentation on Structure linkSAP liveCache technology

Overview of available documentation for Structure linkMaxDB

 

 

 

End of Content Area