Enqueue lock overflow

[former_member196664]

Hi All,

sm12 -Extras-->top capacity used-->current is showing below. Is this lock overflow? Is this problem? Please advice what action do I have to take? Increase enque/tablesize? Is this update hang? All related to table EQUI or MIGO transaction. Pls help.

400 VREINER 15:48:03 U 02/14 Nr_of_Locks:       85  Scope:  1 85 0

400 VREINER 15:48:03 U 02/14 Nr_of_Locks:       85  Scope:  2 0 85

400 AGADDI 15:53:46 U 02/14 Nr_of_Locks:      219  Scope:  2 0 219

In Central instance I have 36MB enque/tablesize. App server 4MB default value.

SM12 -->Extras-->Statistics showing below.

Enqueue Operations 5138898

rejected 86498

Error occured 0

Dequeue Operations 3861074

Error occured 0

Dequeue All Operations 1498607

Cleanup Operations 1

Backup Operations 97788

Read Operations 198835

Compress Operations 0

Verify Operations 0

Records written 1116312

to the backup file 1084252

Maximum Number of Lock Owners 32060

Maximum Fill level 73

Current Fill Level 56

Maximum Number of Lock Arguments 32060

Maximum Fill level 5092

Current Fill Level 309

Maximum Number of Lock Entries 32060

Maximum Fill level 5093

Current Fill Level 320

Update; Fill Level at Maximum 17

Current Fill Level 2

Time in Lock Table /Seconds 117.876150s

Wait for Lock Table /Seconds 14.854018s

Time in Lock Server /Seconds 166.004089s. Here it all looks fine.

Thanks,

Kavitha.

[former_member188883 · Accepted solution]

Hi Kavitha,

As per the information above maximum fill level of enque table is only

Maximum Fill level 5093.

This does not imply lock table overflow. You do not need to change the enque table size.

Regards,

Deepak Kori

[former_member196664 · Accepted solution]

Thanks for clarifying.

[former_member196664]

Deepak,

Still one more question. Current top capacity used is showing entries often. What does it mean? Not overflow....Any issue. Pls advise.

Thanks,

Kavitha.

[Former Member]

Hi Kavitha,

The enqueue lock table overflow occurs if the number of lock requests is bigger than the limit of the enqueue table. It is limited by the parameter “enque/table_size”. The reasons for an overflow are explained in the note 13907.

Please refer the note   Note 13907 - System error in the block handler, overflow lock table

I have faced this issue before.. I have fixed by applying the above note.

http://wiki.sdn.sap.com/wiki/display/SI/Enqueue

Thanks and Regards,

Vimal