Re: Informix session connect time
In article <83r8ql$2vc$1@nnrp1.deja.com>,
dineshjoshi@my-deja.com wrote:
> Would any one help me in find the connect or start time of informix
> user sessions.
>
database sysmaster;
select s.sid sesssion_id,
s.username,
datetime( 1970-01-01 00:00:00 ) year to second +
connected units second connected,
pid,
hostname[1,13],
hex(r.flags) state
from sysscblst s, sysrstcb r
where s.address = r.scb
and bitval(r.flags, '0x80000') = 1
-- and dbinfo('sessionid') != s.sid
order by 3
;
> Any help will be appreciated.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
--
Vardan Aroustamian
vaar@geocities.com
Sent via Deja.com http://www.deja.com/
Before you buy.