Live Cache Status

[Former Member]

Hi,

Is there any table through which we can find whether the live cache is acitve or inactive.

Thanks,

Siva.

[Former Member · Accepted solution]

I'm looking for a table which stores this information.

[former_member229109 · Accepted solution]

Hello Siva,

-> "Is there any table through which we can find whether the live cache is acitve or inactive."

What do you mean? Would you like to know, if the liveCache is running or not?

What problem do you have with liveCache?

What is the version of the liveCache?

-> You could check if the liveCache running or not using the following commands ::

dbmcli db_enum

dbmcli -d <SID> -u control, control db_state

< I assumed that the DBM user of the liveCache instance is control with the

default password :: control >

"I'm looking for a table which stores this information." =>

You could access the database tables/views, if the liveCache is in 'online' state!

For example, as SYSDBA user you could run the SQL statements

< default :: superdba & password: admin >::

'select * from users'

'select * from INFO_STATE'

'select * from db_state'

-> For SAP liveCache documentation see the SAP note 767598.

-> You could use the x_cons tool to see if there are any activities in the liveCache ::

x_cons <SID> -h

x_cons <SID> show active

-> Title of the thread "Live Cache Status".

Please see the SAP documentation, for example, at

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

--> User Manual: SAP liveCache

-> liveCache Monitoring

< -> Determining the liveCache status >

Also review the "System Tables" section in the database SAP documentation

< & "System Tables with Information on Database States" >.

Thank you and best regards, Natalia Khlopina

Edited by: Natalia Khlopina on May 6, 2008 1:22 PM

[Former Member · Accepted solution]

Hi Natalia Khlopina,

Thx for ur detailed reply.

I have a requirement where I need to validate the live cache status in my abap coding. If it is active then execute the program else throw an error. The table (db_state) mentioned by u is not available in the ABAP dictionary. So please do let me know how can I make use of this table and please explain how to use the below commands.

dbmcli db_enum

dbmcli -d -u control, control db_state

Thanks in advance.

Best Regards,

Siva.

[former_member229109 · Accepted solution]

Hello Siva,

-> What is the SAP basis SP on your system?

-> You could use the function 'LC_GET_STATE' to get the liveCache state

on your system, for example.

There are two connections on your system LCA, LDA < used for ATP functionality > &

as of SCM 5.0, LEA.

You could display the function in /nse37 or run it < F8 > with

Import-Parameter Wert

CON_NAME LCA

USE_DBMRFC S

< execute < F8 > > ==>

Export-Parameter Wert

LC_STATE WARM

LC_ENABLED 1

-> As example how to call the function you could review the 'FORM get_lc_state' in the

report /SAPAPO/OM_LC_COM_ANALYSIS.

-> As SAP customer you could get the SAP consulting or if there are any problems with liveCache,

SAP coding => SAP support via OSS ticket.

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Thx a lot for the function module.

Regards,

Siva.

[markus_doehr2]

you can check via LC10...

Markus