Re: sid <--> tid

Posted in 1998

ccremid — Wed, 13 May 1998 09:57:09 -0400 — source: Informix-list mailing list archive (1991-1998)

Serg Shejkin wrote: > > Hi everyone. > > How I can determine, to what user session (sid) belongs thread ( tid ) > > Thanks. > > Serg Try Database sysmaster; select sid from sysrstcb where tid = 1234 ^^^^ your tid. You can select more information about the session: select a.* from syssessions a, sysrctcb b where a.sid = b.sid and b.tid = 1234 ^^^^ Your tid Hope this helps Tino