Yes, DB2 normally takes out next key locks on indexes. However, it does this to maintain repeatable read (RR) isolation levels, if you are not using repeatable read (likely), then set the registry setting:-
"db2set DB2_RR_TO_RS=on" This will get rid of that next key locking problem. James - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
