Re: How to know the number of Informix Instances

"Mark D. Stock" wrote: > > Jonathan Leffler wrote: > > > > >From: sanjeev sagar <sanjeevsagar@yahoo.com> > > >Date: Wed, 24 Feb 1999 11:49:13 -0800 (PST) > > > > > >onstat -g dis> > > > > >will tell you all the instances running on the host. > > > > On my machine, running OnLine 7.24, IDS 7.30, IDS/UDO 9.14, I ran 'onstat > > -g dis' with the environment set to the 9.14 instance, and it said: > > > <SNIP> > > > > The conclusion I draw from this is that at most, "onstat -g dis" displays > > the servers being run from the current INFORMIXDIR -- it clearly does not > > display every OnLine instance on my machine. But my machine setup is not > > all that common. > > This is not a valid assumption. If I run this command I see multiple > versions in multiple directories (INFORMIXDIR). MY assumption was that > this info came from /INFORMIXTMP. The INFORMIXDIR values for example are > stored in /INFORMIXTMP/.infxdirs. Instance details can them be found in > the $INFORMIXDIR/etc/.conf* & $INFORMIXDIR/etc/.infos* files. Of course it just occurs to me that many sites have cron jobs to explicitly clear down the /INFORMIXTMP directory. Maybe this is why you only see instances from one directory. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+

I've got a quick and dirty program that I wrote a while back that 'organizes' all of the processes on the system and then determines which shared memory segments are owned by which process. It works on Solaris and IDS/UDS (not XPS). It's output looks like ------------------------------------------------------------------------------------- List of processes LEVEL PPID PID COMMAND SHM KEY SERVERNUM/SEG . . . . . . . . 0 0 0 sched | . . . . . . . 1 0 1 init | | . . . . . . 2 1 85 rpcbind | | . . . . . . 2 1 87 keyserv | | . . . . . . 2 1 93 kerbd | | . . . . . . 2 1 102 inetd | | | . . . . . 3 102 275 rpc.ttdb | | | . . . . . 3 102 11005 in.telne | | | | . . . . 4 11005 11007 ksh | | | | | . . . 5 11007 11014 format_p | | | | | | . . 6 11014 11015 sh | | | | | | | . 7 11015 11016 ps ... blah blah blah ... | | . . . . . . . . 2 1 10880 oninit 0x526c4801 22/1 | | . . . . . . . . 0x526c4802 22/2 | | | . . . . . . . 3 10880 10884 oninit | | | . . . . . . . 3 10880 10886 oninit | | | . . . . . . . 3 10880 10888 oninit | | | . . . . . . . 3 10880 10890 oninit | | | . . . . . . . 3 10880 10895 oninit | | | . . . . . . . 3 10880 10900 oninit | | | . . . . . . . 3 10880 10901 oninit | | . . . . . . . . 2 1 10881 oninit 0x526b4801 21/1 | | . . . . . . . . 0x526b4802 21/2 | | | . . . . . . . 3 10881 10883 oninit | | | . . . . . . . 3 10881 10885 oninit | | | . . . . . . . 3 10881 10887 oninit | | | . . . . . . . 3 10881 10889 oninit | | | . . . . . . . 3 10881 10894 oninit | | | . . . . . . . 3 10881 10898 oninit | | | . . . . . . . 3 10881 10899 oninit | . . . . . . . . . 1 0 2 pageout | . . . . . . . . . 1 0 3 fsflush ---------------------------------------------------------------- I use it from time to time to see what SHM segments are associated with a given oninit. I don't mind putting the code into the IIUG repository, but I can't really support it. Would this be of interest to anyone? Who would I contact to put it into the repository? Mark D. Stock wrote: > "Mark D. Stock" wrote: > > > > Jonathan Leffler wrote: > > > > > > >From: sanjeev sagar <sanjeevsagar@yahoo.com> > > > >Date: Wed, 24 Feb 1999 11:49:13 -0800 (PST) > > > > > > > >onstat -g dis> > > > > > > >will tell you all the instances running on the host. > > > > > > On my machine, running OnLine 7.24, IDS 7.30, IDS/UDO 9.14, I ran 'onstat > > > -g dis' with the environment set to the 9.14 instance, and it said: > > > > > <SNIP> > > > > > > The conclusion I draw from this is that at most, "onstat -g dis" displays > > > the servers being run from the current INFORMIXDIR -- it clearly does not > > > display every OnLine instance on my machine. But my machine setup is not > > > all that common. > > > > This is not a valid assumption. If I run this command I see multiple > > versions in multiple directories (INFORMIXDIR). MY assumption was that > > this info came from /INFORMIXTMP. The INFORMIXDIR values for example are > > stored in /INFORMIXTMP/.infxdirs. Instance details can them be found in > > the $INFORMIXDIR/etc/.conf* & $INFORMIXDIR/etc/.infos* files. > > Of course it just occurs to me that many sites have cron jobs to > explicitly clear down the /INFORMIXTMP directory. Maybe this is why you > only see instances from one directory. > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > |Mark D. Stock - Informix SA http://www.informix.com |//////// /| > |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| > |http://www.iiug.org +-----------------------------------+//// / ///| > | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| > | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| > |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| > +----------------------+-----------------------------------+-----------+