Quote:
Originally Posted by ricardovp
Hi Bella!
The problem is that the ID-8 was just executing SELECT statements, there was nothing to commit… As I said, the problem was not the application, because when I do the downgrade to the version 6 of the DB2 (and used another backup file to create the database) it works just fine… the problem was the creation of the database with a backup file that has problems…
Thanks for your help!
Ricardo
|
You are forgetting that by default even basic select will have an isolation level of CR. So, it will hold locks causing other PID's to go in Lock-wait.
dBforums
>
Lock Wait problems with DB2 8.2 Express Edition
03-19-10, 09:15
Linear Mode
