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.

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...

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.