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
.
Complete the following steps to configure
DB2
®
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 using LOCKTIMEOUT 10
3.
Set the deadlock check time to 15,000 milliseconds as follows:
update db cfg using DLCHKTIME 15000
Setting deadlock check time prevents deadlock conditions from occurring when multiple users access database tables simultaneously.
Copyright IBM Corporation 2014. All Rights Reserved.