Configuring DB2® database for integrated systems

Configure the time parameters in the DB2® database to avoid deadlock situations if you plan to use integrated systems and integrated offers in Unica Plan.

About this task

Complete the following steps to configure DB2® database:

Procedure

  1. Use the DB2® admin utility (get db cfg) to review the settings for the LOCKTIMEOUT and DLCHKTIME parameters.
  2. Set the lock timeout period to 10 seconds as follows:

    update db cfg using LOCKTIMEOUT 10

  3. Set the deadlock check time to 15,000 milliseconds as follows:

    update db cfg using DLCHKTIME 15000

Results

Setting deadlock check time prevents deadlock conditions from occurring when multiple users access database tables simultaneously.