Lock Table Overflow

[Former Member]

Hi,

enque/table_size=32768

Enqueue Operations 3810566

rejected 259753

Error occured 145221

Dequeue Operations 3113817

Error occured 0

Dequeue All Operations 315377

Cleanup Operations 0

Backup Operations 13

Read Operations 6301

Compress Operations 0

Verify Operations 0

Records written 3677

to the backup file 74

Maximum Number of Lock Owners 3603

Maximum Fill level 64

Current Fill Level 6

Maximum Number of Lock Arguments 3603

Maximum Fill level 3602

Current Fill Level 4

Maximum Number of Lock Entries 3603

Maximum Fill level 3602

Current Fill Level 4

Update; Fill Level at Maximum 1

Current Fill Level 0

Time in Lock Table /Seconds 152.664510s

Wait for Lock Table /Seconds 5.754401s

Time in Lock Server /Seconds 573.023198s

I just want to confirm ...can we increase maximum number of lock entries.

enque/table_size=32768

I have one request that hold more than 8000 locks...I want to run this report bu every time its failed as lock table overflowed.

Thanks

Manmohan

[Former Member]

Hi,

Yes, you can increase the lock table size.

On my ECC- production system, I have enque/table_size=102400 which makes possible :

Maximum Number of Lock Entries 126415

If you still need more than 126 415 lock entries, the program is definitively badly programmed !

Regards,

Olivier

[Former Member]

Hi,

You can increase the lock table size as well as you can increase the no.of enqueu wp depending on the load of the system.

Regards,

Vamshi.

[Former Member]

I want to increase Maximum Number of Lock Entries i.e. 3603 now

[venkata_emandi]

Hello,

Could be that the report has to be turned if itis Z-Report.

try running the report during non peack hours.

Thanks

venkata

[former_member185031]

Have you gone through the Note 13907 - System error in the block handler, overflow lock table

Regards,

Subhash