Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB2 - Concurrency issue

Status
Not open for further replies.

BritesJoe

Programmer
Mar 29, 2018
1
PT
Client application 1 makes an insert to the DB2 database and creates a IX table lock and a X row lock.
Client applications 2 and 3 connected to the same database table try to make selects, and the application stalls. The info in the database is that the Client applications 2 and 3 have a IS row lock.
When the client application 1 exits from the application, client applications 2 and 3 are unblocked, but any inserts commited to the database by client application 1 aren´t in the database table. There is no TCP/IP error in the log files.
It seems that client application 1 disconnects from DB2 database before making the commit.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top