Re: Strange Output --
You will also get this message if you are using the wrong version of onstat against the shared
memory structure. For example, if the engine is started with 7.11.uc1 and the onstat executable
is part of a 7.11.uc2 install.
Arun Shastry wrote:
> 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%