locksheld in syssesprof table

Hi, can anybody help me: When I query the table syssesprof in IDS 9.3, I get zeros in column locksheld even though onstat command returns there are locks from users on certain tables. When I query the table syssesprof in IDS 9.2, results of query matches to onstat results. What is happening in IDS 9.3? How can I obtain information about currently held locks (besides onstat)? Thank you. Aleksandar

pacekva@yahoo.co.uk wrote: > Hi, > can anybody help me: When I query the table syssesprof in IDS 9.3, I > get zeros in column locksheld even though onstat command > returns there > are locks from users on certain tables. When I query the table > syssesprof in IDS 9.2, results of query matches to onstat results. > What is happening in IDS 9.3? How can I obtain information about > currently held locks (besides onstat)? > > Thank you. > Aleksandar The below is the SQL for all locks and the one below that is for blocking locks. select t2.dbsname database,t8.txt type, t2.tabname table, t4.sid lock_sess, t5.username lock_user, t6.sid wait_sess, t7.username wait_user,t1.rowidr row_id,t1.keynum from sysmaster:'informix'.syslcktab t1, sysmaster:'informix'.systabnames t2,sysmaster:'informix'.systxptab t3,sysmaster:'informix'.sysrstcb t4,sysmaster:'informix'.sysscblst t5, outer sysmaster:'informix'.sysrstcb t6, sysmaster:'informix'.sysscblst t7) , sysmaster:'informix'.flags_text t8 where t1.owner = t3.address and t3.owner = t4.address and t1.wtlist = t6.address and t1.partnum = t2.partnum and t4.sid = t5.sid and t8.tabname = 'syslcktab' and t8.flags = t1.type and t6.sid = t7.sid For blocking locks select t2.dbsname database, t8.txt type, t2.tabname table, t4.sid lock_sess, t5.username lock_user, t6.sid wait_sess, t7.username wait_user,t1.rowidr row_id,t1.keynum from sysmaster:'informix'.syslcktab t1, sysmaster:'informix'.systabnames t2,sysmaster:'informix'.systxptab t3,sysmaster:'informix'.sysrstcb t4,sysmaster:'informix'.sysscblst t5, sysmaster:'informix'.sysrstcb t6, sysmaster:'informix'.sysscblst t7 ,sysmaster:'informix'.flags_text t8 where t1.owner = t3.address and t1.partnum = t2.partnum and t3.owner = t4.address and t1.wtlist = t6.address and t4.sid = t5.sid and t8.tabname = 'syslcktab' and t8.flags = t1.type and t6.sid = t7.sid --Ganesan. -- Direct access to this group with http://web2news.com http://web2news.com/?comp.databases.informix