467,185 Members | 1,238 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,185 developers. It's quick & easy.

Client connection crash and Rollback..

Hi,

When a client application crash in the middle of a transaction, db2
keeps the locks on tables updated in the transaction whereas the
connection has been killed...there is the same behavior under oracle
as long as the server do not check (by default) the state of
connection, but we can active it in a parameter file.

Is there a way under DB2 to automatically kill connection of client
that have crashed?

Thanks
Nov 12 '05 #1
  • viewed: 1767
Share:
2 Replies
Db2 will eventually clean up on the server side...when depends on the
comms protocol (for example tcp/ip the setting to check that a
connection is alive is made at the os level).

worky wrote:
Hi,

When a client application crash in the middle of a transaction, db2
keeps the locks on tables updated in the transaction whereas the
connection has been killed...there is the same behavior under oracle
as long as the server do not check (by default) the state of
connection, but we can active it in a parameter file.

Is there a way under DB2 to automatically kill connection of client
that have crashed?

Thanks

Nov 12 '05 #2
Thanks for answer,

do you know which parameter i have to set under window at the os level
to clean up the server side?

Thanks
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Tyler Hudson | last post: by
1 post views Thread by Darren McDowell via .NET 247 | last post: by
3 posts views Thread by Me Alone | last post: by
9 posts views Thread by timor.super@gmail.com | last post: by
1 post views Thread by hal9000cr@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.