LiveCache Monitoring

This article answers following queries:

• What are the monitoring checks for live Cache in SCM or APO System?
• How to check “Activity Overview” in Live cache system?
• How to check OMS locks in live cache system?
• How to check SQL locks in live cache system?
• How to check exclusive waits in live cache SAP system?
• How to check database manager messages in live cache system?
• How to check the parameters in live cache system?
• How to check parameter history in live cache system?
• What are the different memory areas in live cache system?
• How to check Caches, Heap usage, data area and Log area in Live cache of APO   or SCM system?

-----------------------------------------------------------------------------------------

This article explains you how to monitor/view  various paramaters, parmeter history, OMS locks, SQL locks,  cache usage, exclusive waits, database messages, various configuration related to memory. This knowledge will be very much useful to troubleshoot and fix the problem  in case you encounter any  performance issues in Livecache system.

Please login into livecache system using LC10 transaction and providing LCA in the name of database connection as below. Click on Pushbutton “Livecache Monitoring” to proceed further.

System redirects to the following screen.  As shown, in the screen, please click on “ Activity Overview” item  to view details/statistics  related to

• SQL Statements
• I/O Activity
• Lock Activity
• Logging Activity
• Scan and Sort Activity

To view OMS locks (or logical object locks) , navigate to LCA->  Problem Analysis ->  OMS locks -> Overview  as shown in the  below screen.

To view exclusive waits, navigate to LCA -> Problem Analysis -> SQL Locks -> Waits as shown in the below screen

To view existing SQL Locks and SQL lock requests, navigate to LCA -> Problem Analysis -> SQL Locks -> Overview as shown in the below screen

To check database manager messages, navigate to LCA -> Problem Analysis -> Messages -> Database Manager as shown in the below screen.

To view the defined parameters and their values in the live cache system, navigate to LCA -> Administration -> Configuration -> Parameters  as shown in the below screen

To view the history of the parameters that are changed date wise, navigate to to LCA -> Administration -> Configuration ->Parameter History as shown in the below screen

To view the Cache related information, navigate to LCA -> Current Status -> Memory Areas -> Caches as shown in the below screen.

To view the OMS Heap  related information, navigate to LCA -> Current Status -> Memory Areas -> Heap Usage  as shown in the below screen.

To view the “ Data area”  related information, navigate to LCA -> Current Status -> Memory Areas -> Data Area  as shown in the below screen.

To view the “ Log Area ”  related information, navigate to LCA -> Current Status -> Memory Areas -> Log  Area  as shown in the below screen.

Related Link :

How to start or stop livecache in SAP SCM or APO system?

How to start or stop live cache in SCM or APO SAP systems?

This article answers following queries:

• How to start or stop live cache in SCM or APO SAP systems?
• What is the transaction used to administer livecache in SCM or APO systems?
• How to monitor livecache in SCM or APO systems?
• How to check operational state of livecache in SCM systems?
• How to check when was the last date on which live cache started in SCM system?
• How to check live cache related alerts in SCM systems?
• What is the database on which livecache runs on SCM systems?
• What is the start/stop sequence of livecache?
• How to check the live cache version?

-------------------------------------------------------------------------------------------

STOP sequence of livecache in SCM or APO system:

Sometimes to perform any maintenance it is required for basis administrator to shut down the SAP system. If an SAP system consists of livecache then it is required to know the sequence in which system to be bought down to avoid issues

Shutdown sequence:

• First of all shutdown livecache (Process explained below)
• Shut down ABAP system (as per the standard process of shutting down any SAP system)
• Shut down Database system ( as per the standard process)

START sequence of livecache in SCM or APO System:

Start sequence of livecache system is exactly reverse order of shutting down process.

Start sequence:

• Start Database of the SAP SCM system (As per standard process)
• Start the ABAP stack (As per standard process)
• Start the live cache (process explained below)

How to Check the live cache Operational State :

Login to SAP system and goto transaction LC10.

Systems displays screen similar to below. Please select name of database connection as LCA and click on "Livecache: Monitoring" tab to proceed further. 

After this, you will be redirected to the below screen. Here you can check the operational state of the live cache. It is green currently. It means live cache is up and running.

 From the below screen, we can determine

• live cache version
• live cache operational state
• Database server version
• Operating system
• What was the date/time at which livecache started in this system
• When was the last livecache start/stop activity done
• Automatic log backup is on or off
• Database Trace/Command monitor/Resource monitor on/off status
• Different directories/files belonging to livecache

Note : By clicking on the Alert monitor link (as shown in above screen), we can check various alerts that are belonging to livecache.

Once you click Alert monitor, it opens another screen as below. From here you can click on "open alerts" pushbutton to view all the alerts related to livecache. In addition to that, we can drill down on various parameters in the below screen and we can identify problematic areas.

If there is an issue in any area, that will be highlighted in red as shown in screen below

How to Stop LiveCache:

To stop the livecache, In this screen, navigate to Administration -> Operating and click on "Stop livecache" pushbutton  (as shown in the below screen). 

 Once the livecache got stopped, the operational state button which is green earlier will turn to red confirming that the live cache is down.

How to Start LiveCache:

To start the live cache again, navigate to Administration -> Operating and please click "Start Livecache" pushbutton in the above screen.

Once the livecache started successfully, its operational state turns into green color indicating that livecache is up and running.

Please note that live cache runs on a MAXDB database.

Related Link :

How to start or stop live cache in SAP SCM or APO system?