I have a situation where one of our clients are encountering the problem where too many Locks are acquired on the Server and terminates the process when the limits are exceeded.

The Locking on the tables is set to Row level. The application performs atomic saves (all or none)

Any clues on what needs to be changed to over this problem. Any configurations, settings etc.,

There is a LOCKS parameter in the $ONCONFIG file
also if it is a big load toy cal lock the table in the exclusive mode and then it will only use one lock

We have already thought about performing an Exclusive lock on the table, but that would limit other sessions from doing the saves in the application simultaneously (beats the purpose of data concurrency).

Any alternate approaches?

Is there a max limit to setting the Locks on the Server?

I am knid of new to INFORMIX. Prompt feedback appreciated

Thank you

Rama

We have already thought about performing an Exclusive lock on the table, but that would limit other sessions from doing the saves in the application simultaneously (beats the purpose of data concurrency).

Any alternate approaches?

Is there a max limit to setting the Locks on the Server?

I am kind of new to INFORMIX. Prompt feedback appreciated

Thank you

Rama

Increase the LOCKS parameter in the $ONCONFIG file
it is in $INFORMIXDIR/etc