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