How can SAP be configured to prevent users from consuming locks?

[Former Member]

How can SAP be configured to prevent users from consuming locks?

The issue is that we want to prevent users to use upto maximum locks and so that we will not get lock table overflow issue. I know that we can assign parameter "enque/table_size" a good amount of value. But it is not for any specific user.

Also want to alert in CCMS if any user reaches to its maximum speficified limit of locks.

Thanks

Gopesh

[jens_hoetger]

Hello,

I don't think there is a possibility to limit lock entries to users.

For getting warned when there are a lot of lock entries you can use the RZ20 (SAP CCMS Monitor Templates -> Enqueue).

Kind regards

Jens Hoetger

[Former Member]

You cannot set a limit of locks per user. There are two ways to reduce/control the number of locks:

- change fewer records within one transaction

- cover more records with one lock using wildcards

Basically it is an application / development issue.

Best regards, Michael