Lock Table Overflow

[Former Member]

What happens in a lock table overflow situation? Our enqueue table is 32K. It rarely overflows except during some year-end job. All jobs seem to finish successfully so I am not sure what actually occurs in the system. Do other jobs just wait until all locks are released or the enqueue table is cleared?

[Former Member]

Hi Sandeep,

Yes. You are correct.

The jobs will wait until the lock table is cleared. This might take an extra time where the jobs wait for the lock table to be cleared but its negligible.

In work processes on the enqueue server, a few 100 microseconds. In work processes of external application servers you have to include network communications and process changes. Depending on CPU and network load this amounts to a few milliseconds.

Cheers....,

Raghu