Re: How to know the number of Informix Instances
Posted in 1999
Opps - actually it's lined up much better than.
Madison Pruet wrote:
> 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"!|/ ////////|
> > +----------------------+-----------------------------------+-----------+