Re: Strange Output --
Session information, along with a lot of other stuff, is maintained in shared memory.
Informix has a data structure that they use to store this info. and that is constantly
changing due to the dynamics of the server. Onstat gives you a snapshot of the
server state, and cannot access this information while the data structure is changing.
The thing is, it's changing very quickly. Try to run it a few times and you'll see
the expected output in one of those attempts.
You might be seeing thread info. because that piece of info. is not volatile
at that moment.
Arun
Abhay Mannur wrote:
> I'm getting the strange output as follows
> -------------------------------------------------------------------------------------------
>
> fsce03:informix 146 $ onstat -g ses 3605
>
> INFORMIX-OnLine Version 7.23.UC4 -- On-Line -- Up 2 days 20:51:34 --
> 822760 Kbytes
> session #RSAM total used
> id user tty pid hostname threads memory memory
> 3605 prodadm 109 kbiltz-f 1 180224 56744
>
> tid name rstcb flags curstk status
> 11353 sqlexec 9aeb2a18 ---P--- 32840 9aeb2a18 running
>
> Memory pools count 1
> name class addr totalsize freesize #allocfrag #freefrag
> Changing data structure forced command termination.
> -------------------------------------------------------------------------------------------
>
> If I run onstat -gr act, this thread is running and CPU utilisation is
> 99%