MAXLOCKS alert generation - SAP Live Cache

[srikanth_sandha]

Hello Guru's,

We have a requirement for setting alerting for parameter MAXLOCKS on live cache server when it reaches to a threshold value, but we couldn't find any monitoring set in RZ20.

So we have got an idea to use Count(*) on LOCKSTATISTICS and calculate a threshold. But not sure how to do it through Shell Script for MAx DB? Please suggest if any other options as well.

Thanks and Regards,

Sri's

[former_member229109]

Hello Sri's,

1.

Please review the notes:

65946 Lock escalations

1243937 FAQ: MaxDB SQL locks

As you know, the system table LOCKLISTSTATISTICS displays the statistics of the

lock management since the last database start. This system table is insufficient for the analysis of locking conflicts.

2.

Review the sapact script attach to the SAP Note No. 974758 as HINT to your question on collecting the output

of the statement :

SELECT * FROM SYSDBA.LOCKLISTSTATISTICS and

SELECT * FROM SYSDBA.LOCKSTATISTICS

Periodically during the job/application run in question.

Also use the DB analyzer to find the bottleneck in liveCache.

3.

Create the SAP message and get SAP support.

It will be helpful to know what is the version of your system, SAP basis SP, the liveCache version and the reason of your project.

Did you get the DB analyzer warnings with lock escalation?

Regards, Natalia Khlopina

[srikanth_sandha]

Natalia Khlopina, What you have suggested it exactly correct, we have suggested this to our customer on wednesday it self. But our DBA has implemented Other logic. They retrieved data from saplocks.sql used grep and calculations to set alert

Although I agree what we have found with LOCKLISTSTATICS is better solution. I have awared u points

Thanks very Much ..