Setting locktimeout value

[Justin]

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/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc/info/exp/ae/rprf_db2parameters.html

[Justin]

Re: Setting locktimeout value


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...

[Artur]

Re: Setting locktimeout value

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