var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
DB2 UDB V7 FP9 on AIX
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?
See for yourself and please let us know :
db2 change isolation to UR
db2 connect to sample
db2 +c select * from employee
db2 get snapshot for locks on sample
Visit the new-look IDUG Website , register to gain access to the excellent content.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors