Solving deadlocks when using composer with an Informix database

You encounter a database deadlock when two concurrent transactions cannot make progress because each one waits for the other to release a lock. If you encounter an Informix deadlock while using composer commands, perform the following steps:

1. Stop WebSphere Application Server Liberty Base, as described in Application server - starting and stopping.
2. Browse to the TWSConfig.properties file, located in the following paths:

   On Windows operating systems

   <TWA_home>\usr\servers\engineServer\resources\properties

   On UNIX operating systems

   <TWA_DATA_DIR>/usr/servers/engineServer/resources/properties

3. Add the following property to the file:

   com.ibm.tws.dao.rdbms.ids.lockTimeout=0

4. Start WebSphere Application Server Liberty Base, as described in Application server - starting and stopping.

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).