Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Thumbs down Unanswered: Lock table overflow

    Hi Gurus Informix,

    In last days informix show me this message in the online.log

    Subject: desa_tcp : Attention! : Dynamic Server resource overflow: 'Locks'.

    Lock table overflow - user id 10417, session id 36045

    In the ONCONFIG file, the value in the parameter LOCKS is 4000000.

    I can know what is the user or process than is produce this message?

    there are other parameters that will be modified?

    What is the problem?.

    Thank you for you help.

  2. #2
    Join Date
    Jul 2007
    Posts
    2
    do an 'onstat -k' to list the active locks . if none available, then you need to allocate more locks. sorry, can't be sure about next course of action...

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    In the file ONCONFIG, the parameter ALARMPROGRAM have a script, in a moment informix send e-mails.

    Subject: prod_tcp : Attention! : Dynamic Server resource overflow: 'Locks'.
    To: bbdd@notes.creditoycaucion.es

    Lock table overflow - user id 220, session id 172274

    How can capture what user or session is overflow the value in the parameter ALARMPROGRAM, ¿ I need change my script in ALARMPROGRAM? ¿ What solution there are for this case whitout add more locks in onconfig.?

    Thank yuo for you help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •