Step: Configure DB2® database for integrated systems
If your installation uses a DB2® database, integrates IBM® Marketing Operations with Campaign, and has offer integration enabled, you must configure timing parameters for the database.
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 LOCKTIMEOUT 10
3.
Set the deadlock check time to 15,000 milliseconds as follows:
update db cfg DLCHECKTIME 15000
These settings prevent deadlock conditions from occurring when multiple users access database tables simultaneously.
Copyright IBM Corporation 2013. All Rights Reserved.