473,322 Members | 1,620 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Setting locktimeout value


When setting the locktimeout value, is it immediately changed for the
database? or will we have to de-activate the db? Or stop / restart
db2?

Did not see this info available on the db2 docs:
http://publib.boulder.ibm.com/infoce...arameters.html

Jun 5 '07 #1
2 4498

Version: DB2 v8.1 fixpack 11

On Jun 5, 9:44 am, Justin <kfw...@hotmail.comwrote:
When setting the locktimeout value, is it immediately changed for the
database? or will we have to de-activate the db? Or stop / restart
db2?

Did not see this info available on the db2 docs:http://publib.boulder.ibm.com/infoce...ndex.jsp?topic...

Jun 5 '07 #2
On 5 Cze, 15:45, Justin <kfw...@hotmail.comwrote:
Version: DB2 v8.1 fixpack 11

On Jun 5, 9:44 am, Justin <kfw...@hotmail.comwrote:
When setting the locktimeout value, is it immediately changed for the
database? or will we have to de-activate the db? Or stop / restart
db2?
Did not see this info available on the db2 docs:http://publib.boulder.ibm.com/infoce...ndex.jsp?topic...
locktimeout sets the default for all applications that are connected
to the database.

changing the parameter requires to deactivate the db.

but, If you want to change it dynamically, you should do this within
your application with SET CURRENT LOCK TIMEOUT

-- Artur Wronski

Jun 7 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Philip Yale | last post by:
Recently, using PERFMON, I've been rather dismayed to find that our application is averaging 3 - 4 lock timeouts per second, and frequently has extended periods of several minutes where this...
6
by: Niyazi | last post by:
Hi, We have and IBM AS400 and I belive the reional setting is Turkish. The IBM Client-Access for Windows that install in our PC (WIN XP SP2) set to Turkish characters. Now my PC has English...
1
by: db2group88 | last post by:
we use db2 udb v8.1 on windows, our application use jdbc to create connection and sql statement, we will need the row lock prevent other session update but allow to read at the same time for the...
18
by: Dixie | last post by:
Can I set the Format property in a date/time field in code? Can I set the Input Mask in a date/time field in code? Can I set the Format of a Yes/No field to Checkbox in code? I am working on...
0
by: Shravan | last post by:
Hi, I am setting a row value in my grid using ((DataRowView)grid.ListManager) = value; if the given rowNo is not the current position in the currencymanager, setting some value in the row is...
3
by: Patient Guy | last post by:
Subject line would seem to say it all: How does one trigger the execution of a method within an object or any other code/function with the setting of an object property? More elaboration for...
1
by: laredotornado | last post by:
Hi, I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed using Apache's apxs and the php library was installed to /usr/local/php. However, when I set my "error_reporting"...
8
by: Andrus | last post by:
..NET 2 Winforms application. How to create new setting and set it default value in userSettings section of app.config file or overwrite existing setting value ? I found code below in this list...
7
by: PetterL | last post by:
I have a setting called My.settings.firstrun set to True, set in the setting manager. When i read this in the first form form_Load in a IF sentence it always come out as false. I have tried to...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.