Re: find session id
In article <55cfj5$pn8@netnews.csie.nctu.edu.tw>, ccliu
<ccliu@csie.nctu.edu.tw> writes
>Hi,
> When informix has BUS error, it will show:
>
>18:20:13 Checkpoint Completed: duration was 1 seconds.
>18:21:09 Assert Failed: Internal Error - Bus Error
>18:21:09 Who:Session(11445, mes@u3hsrv3, 8702, -1073275464)
> Thread(13999, sqlexec, c0053420, 3)
>18:21:09 Results: OnLine must abort
>18:21:09 Action: Reinitialize shared memory
>18:21:09 See Also: /tmp/af.36af2c15, shmem.36af2c15.0
>18:22:59 rsinit.c, line 9151, thread 13999, proc id 25483, Bus Error.
>18:22:59 DR: ping timeout
>18:22:59 PANIC: Attempting to bring system down>
>
>Usually, using onstat -u, we can find session id and look at the session by
>onstat -g ses ses-id.>
>But how can I find the session 11445 after the system bring down and up?
>Does INFORMIX store this kind of information?
>
>
>Jack
>.
>
Yes in the shared memory file "shmem.36af2c15.0". DO
onstat shmem.36af2c15.0 -u
onstat shmem.36af2c15 -g ses ses-id etc.
--
David Williams