select s.sid, trim(o.odb_dbname) odb_dbname, fo.txt,
q.scb_sqerrno, q.scb_iserrno,

trim(s.username) username, decode(s.ttyin,'',s.hostname,s.ttyin) ttyin,
dbinfo('utc_to_datetime',s.connected) ConnectTime, s.pid,
dbinfo('utc_to_datetime',t.th_startrun) last_run_time,
p.po_usedamt+p.po_freeamt total, p.po_usedamt,

--sdb_executions, sdb_cumtime, sdb_partnum, sdb_recnum, sdb_pdq_prio_req, sdb_pdq_priority,

r.lktout, r.nlocks, r.nreads, r.nwrites, r.upf_bufreads, r.upf_bufwrites,

r.upf_iscommit, r.upf_isrollback, upf_seqscans, upf_dsksorts, upf_totsorts, upf_logspuse,
bitval( r.flags, '0x00000001') us_inuse,
bitval( r.flags, '0x00000002') w_latch,
bitval( r.flags, '0x00000004') w_lock,
bitval( r.flags, '0x00000008') w_buffer,
bitval( r.flags, '0x00000010') w_checkpoint,
bitval( r.flags, '0x00000020') inreadRSAMcall,
bitval( r.flags, '0x00000040') backup_log,
bitval( r.flags, '0x00000080') OnMonitor,
bitval( r.flags, '0x00000100') inCriticalSection,
bitval( r.flags, '0x00000200') specDaemon,
bitval( r.flags, '0x00000400') archiving,
bitval( r.flags, '0x00000800') cleanDeadPS,
bitval( r.flags, '0x00001000') w_writeOfLogBuffer,
bitval( r.flags, '0x00002000') buffer_flushing,
bitval( r.flags, '0x00004000') remoteDBServer,
bitval( r.flags, '0x00008000') deadlockTime,
bitval( r.flags, '0x00010000') regularTime,
bitval( r.flags, '0x00040000') w_transaction,
bitval( r.flags, '0x00080000') primary,
bitval( r.flags, '0x00100000') building_indexes,
bitval( r.flags, '0x00200000') BtreeCleaner,

--(select 1 from sysconblock where r.sid = cbl_sessionid and cbl_sdbno <> 0 and cbl_flags=0 and cbl_flags2=0 and cbl_selflag=0) is_rollback,
0 is_rollback,
t.th_conwait

from syssqscb q, sysrstcb r, sysscblst s, systhreads t, syspoollst p,
outer syssdblock l, sysopendb o, flags_text fo
where s.sid = r.sid and t.th_addr=r.mttcb
and (po_name = s.sid||'') -- or po_name like s.sid||'*O%'
and s.sid = q.scb_sessionid --and q.scb_feversion > 0
and s.sid = l.sdb_sessionid and l.sdb_iscurrent = 'Y'
and s.sid = o.odb_sessionid and o.odb_iscurrent = 'Y'
and fo.tabname = 'sysopendb' and fo.flags = o.odb_isolation

order by scb_sqerrno, odb_dbname, ttyin, username