Backup of livecache profile

[former_member246694]

Dear All,

Before changing a parameter value , I would like to take a backup of the existing profile in livecache .

How to do this?

What is the file that holds all the parameter values of livecache?

Thanks n Regards,

KK

[former_member229109]

Hello,

1. What liveCache parameter you are planning to change?

Please review SAP Note 1139904 (FAQ MaxDB/liveCache Kernel Parameter)

• Please change the liveCache parameters using the SAP notes or SAP support

• Create the complete databackup and the configuration of the database parameters could be restorred from the databackup.

• You could use the dbm command "param_gethistory NAME=< database parameter name>" to see the history of the parameter change.

• In the config database directory you could see the bynary <SID> PARAM file which has the current values of the database parameters and the bynary <SID>.01 which has the old values of the database parameters. All our liveCache configuration parameters and parameter changes are stored in one binary parameter file '<IndepDataPath>/config/<SID>'.

In addition, we keep a history of the last 9 parameter changes by simply renaming the 'old'-files to 'LCP.01' to 'LCP.09'.

This enables us to restore any older parameter file version using 'dbmcli' tool - dbm command 'param_restore'.

!! Pay attention, that not in all cases you could restart the database after you restored the old version of the PARAM config. Additional action will be needed. I recommend to create the SAP message & get SAP support if you you have no expierence in this area yet.

2. What is the version of the liveCache instance?

What is the version of your system?

3. In general the information you asked is available for the database users in the the MAXDB library.

http://maxdb.sap.com/doc/7_7/default.htm

Database Administration ->

Changing Database Properties ->

Database Parameters

http://maxdb.sap.com/doc/7_7/default.htm

Database Administration ->

Changing Database Properties ->

Configuration Files

< see PARAM file >

Thank you and best regards, Natalia Khlopina