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
- Use the DB2® admin utility (get db cfg) to review the settings for the LOCKTIMEOUT and DLCHKTIME parameters.
- Set the lock timeout period to 10 seconds
as follows:
update db cfg using LOCKTIMEOUT 10
- 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.