Lock Table Overflow

[Former Member]

Hi,

I am facing problem with Lock Table Overflow Error for a program. Can anyone plz let me know, how to resolve this error?

[manuel_bassani]

Hi Heena,

which program is it? standard or a custom one ?

If you try to lock many records passing the primary key, the lock table will quickly overflow

Perhaps you can try one of the following:

1. lock records by partial key (if possible)

2. Contact your SPA administrator and ask to add space to lock table

Have a nice day

Manuel

[Former Member]

Hi,

Thanks for the reply.

Its a custom program, it gave an error in the PCH Env.

So need to find the reason behind this overflow.

[Sm1tje]

Since it is a custom program, try to make sure that you only do indiviual locking of objects and don not forget to unlock them, before creating a new lock.

[Former Member]

hiii.

in case of a custom prg...if you lock many fields then this type of errors occur.

try to lock a less number of fields.....

and always use the enqueue and dequeue function modules and fix the scope to 2.

reward if helpful..

thanks...

[Former Member]

Hi,

Can you plz elobarate on "Scope to 2". What this says?

thanx.

[Former Member]

hii,

scope means that if you want to pass on the lock to the update work process also or not.

there r 3 type of scope.

1. 1-the lock only remains in the prg

2. 2-the lock remains in the prg and passed on to the lock process.

3. 3 -the lock remains remains both in the prg and also in the update work process.

if more details plz revert back.

reward if heplful.

thankssss.....