Statement # 3268: @ 0x4d75f8a8
Database: 0x100004
Statement text:
select ss.sid, ss.username, ss.hostname, stn2.tabname, sl.tabname object,
sl.type, count(*) num
from syssessions ss, syslocks sl, systabnames stn1, systabnames stn2,
sysptnhdr sph
where sl.owner=ss.sid
and sl.dbsname = "bartest"
and sl.tabname=stn1.tabname and sl.dbsname=stn1.dbsname
and stn1.partnum=sph.partnum
and sph.lockid=stn2.partnum
group by 1,2,3,4,5,6
Statement information:
Sess_id User_id Stmt Type Finish Time Run Time TX Stamp PDQ
321 502 SELECT 23:55:42 0.0000 21a4b8 0
Statement Statistics:
Page Buffer Read Buffer Page Buffer Write
Read Read % Cache IDX Read Write Write % Cache
0 0 0.00 0 0 0 0.00
Lock Lock LK Wait Log Num Disk Memory
Requests Waits Time (S) Space Sorts Sorts Sorts
0 0 0.0000 0.000 B 0 0 0
Total Total Avg Max Avg I/O Wait Avg Rows
Executions Time (S) Time (S) Time (S) IO Wait Time (S) Per Sec
1 0.0000 0.0000 0.0000 0.000000 0.000000 99350.1689
Estimated Estimated Actual SQL ISAM Isolation SQL
Cost Rows Rows Error Error Level Memory
91 13 0 0 0 CR 301784