DB2 UDB V7 FP9 on AIX
Hi:

Before connecting to the database I issue the command to change isolation level to UR. After that I do select from tables and views. Is there any chance that I might still be holding locks on some objects?

dollar

See for yourself and please let us know :

Window 1:

db2 change isolation to UR
db2 connect to sample
db2 +c select * from employee


Window2 :

db2 get snapshot for locks on sample


cheers
Sathyaram