Background jobs are getting deleted due to lock table overflow.

[Former Member]

Hi All,

We are facing critical problem in production whenever lock table overflow issue occurred suddenly some critical jobs are getting deleted and it is effecting business badly. When we check system log getting the below:

Failed to reschedule a periodic job

> job ... AUTO-DELIVER

> Unable to generate ID number for job

Help us on how to resolve this issue for not to delete any job and why the jobs are getting deleted, we have also increased

enque/table_size=16000 to 32000 now changed to 64000.

When we have changed from 16000 to 32000 also many jobs are got deleted.

Regards,

Karthik.

[Former Member]

What is the error in the System log?

Get the the below Values of SM12> Extras--> Stats

Maximum Number of Lock Owners

Maximum Fill level

Current Fill Level

Maximum Number of Lock Arguments

Maximum Fill level

Current Fill Level

Maximum Number of Lock Entries

Maximum Fill level

Current Fill Level

Update; Fill Level at Maximum

Current Fill Level

DId the above values reached the maximum?

What about the file descriptors value at OS level?

Example: nfile in HP-UX.

What are the values in your central instance for this below parameters?

rdisp/wp_ca_blk_no

rdisp/appc_ca_blk_no

rdisp/elem_per_queue?

Regards

SM