| Author |
Message
|
| MaheshPN |
 Posted: Wed Jun 23, 2004 9:53 am Post subject: db2 settings |
 |
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Hi Guys,
Does any of you guys have changed the value of LOCKTIMEOUT and DLCHKTIME? What is the recommended values for Workflow application.
I heard from db2 support team that, chanching these valuse will reduce the database deadlocks but they also said, be sure to
consult with the application developers or your vendor first to make sure the application is prepared to handle lock timeouts.
Any idea?
Thanks,
-Mahesh
IBM Certified Solution Expert - MQWorkflow |
|
| Back to top |
|
 |
| CHF |
| Posted: Wed Jun 23, 2004 10:35 am Post subject: |
|
|
Master
Joined: 16 Dec 2003
Posts: 297
|
I am not a DB2 guy.
My reply will not answer your question, but would like to share something about Database Deadlocks. We used to get tons of deadlocks until we did runstat/rebind for DB2. Performing runstats/rebind on DB2 greatly improved the speed, performance and experiencing no more deadlocks at all.
CHF  |
|
| Back to top |
|
|
| manoj |
| Posted: Wed Jun 23, 2004 11:07 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
Mahesh,
What's your current values for these variables...are you using the defaults now...any way post the values currently u have
_________________
-manoj |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Jun 23, 2004 12:05 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
This is a question that would best be answered by the developers. You probably should post it to the IBM MQWF Newsgroup
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Wed Jun 23, 2004 12:40 pm Post subject: |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
I am using the default values,
LOCKTIMEOUT = -1
DLCHKTIME is 10sec
Hope this will help
-Mahesh |
|
| Back to top |
|
|
| manoj |
| Posted: Wed Jun 23, 2004 3:39 pm Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
A locktimeout of -1 means there will not be any lock timeouts ....This default setting is very dangerous for an OLTP application..
I would suggest setting it 10 or 15 seconds.. here is the command
db2 "update db cfg for DBNAME using LOCKTIMEOUT 15"
Let me know the output of the following command before and after changing the locktimeout to 15 secs
db2 "get snapshot for database on DBNAME"
_________________
-manoj |
|
| Back to top |
|
|
|
|
