var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Abort/RollBack Transaction on Connection abort from client
We have multiple clients connecting to centralized server.
Clients acquire locks under transaction with isolation level committed when clients abort connections to server. Seems like DB2 isn't releasing the locks by transactions on various tables.
Is there a way to specify some settings on connection string in DB2 to abort/rollback/release locks from tables on aborted connections?
something like SET XACT_ABORT
Seems that the DB2 server deems your disconnected clients as alive.
You can change this behavior setting some OS & DB2 variables.
Look at the TCP/IP keepalive settings and related DB2 registry variables technote.
Note that starting with DB2 10.1 you have DB2TCP_SERVER_KEEPALIVE_TIMEOUT variable as well. Look at the Communications variables.
Tags for this Thread