RE: shared memory not initialized

The holy trinity is ONCONFIG, sqlhosts and /etc/services. Your entries look ok at this point - sounds like your rootdbs either does not exist or has wrong ownership/permissions (previous note). You also need environment variables: INFORMIXSERVER=informixserver (in your case) ONCONFIG=whatever (no path - just filename) There are others, but these two should be enough to start. DBSERVERNAME must match $INFORMIXSERVER and needs an entry in sqlhosts. I was wrong to earlier critique your sqlhosts and indicate that an onipcshm was required, there are folks who run only with a network connection. (Hence why I used the word 'typically') an /etc/service entry must exist for all network connections (onsoctcp for example). I do not believe that it is required for shared memory connections. j. -----Original Message----- From: tom.priore@gmail.com [mailto:tom.priore@gmail.com] Sent: Wednesday, August 08, 2007 10:14 PM To: Jack Parker Subject: Re: shared memory not initialized Here is my (non-working config): sqlhosts: informixserver onipcshm informix sqlexec /etc/hosts: 127.0.0.1 localhost.localdomain localhost 192.168.26.66 informix /etc/services: sqlexec 9088/tcp onconfig ROOTNAME rootdbs # Root dbspace nameROOTPATH /opt/informix/dbs/rootdbs # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 30000 # Size of root dbspace (Kbytes) SERVERNUM 0 # Unique id corresponding to a OnLineinstance DBSERVERNAME informixserver # Name of default databaseserver #DBSERVERALIASES informixserver_tcp # List of alternate dbservernames NETTYPE # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 2000 # Maximum number of locks NUMAIOVPS # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes) CLEANERS 1 # Number of buffer cleaner processes SHMBASE 0x44000000L # Shared memory base address SHMVIRTSIZE 8192 # initial virtual shared memorysegment size SHMADD 8192 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited SHMVIRT_ALLOCSEG 0 # Values between 0 and .99 are %,values > 1 are # KB - when this much virtual memory is used we # try to get a new segment. 0 means "off". 2nd # parameter is alarm level CKPTINTVL 300 # Check point interval (in sec) TXTIMEOUT 300 # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) On Aug 8, 9:12 pm, "Jack Parker" <jack.park...@verizon.net> wrote:> I missed that entirely. >Sigh< the joys of going blind. > > Tom - are you good to go? > > j. > > -----Original Message----- > From: informix-list-boun...@iiug.org > > [mailto:informix-list-boun...@iiug.org]On Behalf Of Art S. Kagel > Sent: Wednesday, August 08, 2007 2:01 PM > To: informix-l...@iiug.org > Subject: Re: shared memory not initialized > > On Aug 8, 1:13 pm, "tom.pri...@gmail.com" <tom.pri...@gmail.com> > wrote: > > Thanks for you help. > > I have made those changes, oninit still fails and drops me to the > > shell. Should I have to change NETTYPE in the onconfig? > > > here is the output of onstat -m > <SNIP> > > 08:06:22 listener-thread: err = -930: oserr = 0: errstr = informix:> > Cannot connect to database server (informix). > <SNIP> > > > sqlhosts: > > > informixserver onipcshm informix dummy > > > informixserver_tcp onsoctcp informix sqlexec> > > > /etc/services: > > > sqlexec 1526/tcp # informixserver > > OK, the sqlhosts file says your server is named 'informixserver' and > is running on a machine whose name is 'informix' and the connection > uses service 'sqlexec' (port 1526). So far so good, though I question > your choice of machine and server names (what will you name things > when you bring up the second server for Informix?). However, the > failure message in the online log indicates that you have > INFORMIXSERVER set to 'informix' when it should be set to > 'informixserver'. Try fixing that. > > Art S. Kagel > > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list