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

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.