Try out snapshot command to identify the locks in the db.
get snapshot for locks on <db>
deepak n
Last Activity: Jul 1 '11, 04:11 AM
Joined: Dec 28 '10
Location:
-
-
Try the following query
SELECT sc.name
FROM SYSIBM.SYSCOLUM NS SC
WHERE SC.TBNAME = 'REGISTRATION'
AND sc.identity ='N'
AND sc.tbcreator=sc hemaname
AND sc.keyseq=1Leave a comment:
-
Try the following delete statement:
delete from t1 where t1.id in (select t1.id from t1,t2 where t1.pid =t2.pid and t1.cid<>t2.cid)Leave a comment:
No activity results to display
Leave a comment: