Skip to Content
avatar image
Former Member

Background jobs are getting deleted due to lock table overflow.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 18, 2011 at 08:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded