IBM DB2 configuration settings

If you are running LiveCycle with a DB2 database and the computer stops responding, check the server log files for deadlock-related messages. If such messages are in the log files, change your DB2 configuration parameters:

  • Set the LOCKTIMEOUT parameter to 15.

  • Double the values for the APPLHEAPSZ, STMTHEAP, and SORTHEAP parameters.

You must then restart the database and application server.

// Ethnio survey code removed