informix IDS 9.3 refusing to start

[Umapathy S]

hi
I have hpux 11.0 on HP9000-A class servers. I installed Informix 9.3 IDS on that box. I configured the Demo server and it went fine.

when I wanted to start my own server of NETTYPE onsoctcp, listener thread refuses to start saying the following error.

listener-thread: err = -931: oserr = 0: errstr = infsql: Cannot locate infsql service/tcp service in /etc/services

but
$ cat /etc/services |grep infsql
infsql 1526/tcp # listener for informix db

I have attached online.log for reference.

Please help me in solving this. I dont know whether I am wrong somewhere or it is a bug.

Any pointers info are greatly appreciated

warm regards
Umapathy

This is to Dna, Jef, ...
I am not able to attach more than one file. Can you look into this

[Animesh Chakraborty]

Make sure that the port 1526 is free
#netstat -a|grep 1526
then check sqlhost file and onconfig file that the servies assign to correct server name

Change the port number(sud be more than 1500 and unique) and try to restart that.

[Umapathy S]

No service is listening at 1526.

I wrote a sample program using getservbyname() to check for /etc/services. It works for other well known services like echo, time etc.
But it fails miserably for "infsql" which is my servername in /etc/services.

I suspected a corrupt /etc/services and moved "infsql" entry to the top of the file but in vain.

regards
Umapathy

[Rainer von Bongartz]

could you post your $INFORMIXDIR/etc/sqlhosts please


Regards
Rainer

[Umapathy S]

here comes the sqlhosts file

[Umapathy S]

here comes the onconfig file

[Rainer von Bongartz]

Everything looks quite ok, so no direct explanation for the behaviour.

Try defining another service with a different port number

Regards
Rainer

[Umapathy S]

I tried that out also. I wrote one small program using getservbyname() which works just fine for other standard services and not for all of the entries I added.

Now I suspect it is a problem with the machine and not with Informix.

Any ideas pointers on this. Is there any patch for this.

regards
Umapathy

[Tim D Fulford]

You MUST have a shm poll thread, even if it is on NET-vp

$ONCONFIG
DBSERVERNAME thbs
DBSERVERALIASES thbshm
NETTYPE soctcp,1,100,CPU
NETTYPE ipcshm,1,100,NET
NUMCPUVPS 1

sqlhosts...
thbs onsoctcp dolphin infsql
thbshm onipcshm dolphin infshm

*If* you are running on an 8 CPU machine *&* you are PREDOMENANTLY doing network stuff...you could split the poll threads over 7 cpu-vps

NETTYPE soctcp,6,100,CPU
NETTYPE ipcshm,1,100,CPU
NUMCPUVPS 7

Regards

Tim

It all depends on what ratio you are c

[Rainer von Bongartz]

Tim,


I can't confirm that you MUST have a shm poll thread.

I have configured INFORMIX servers running with ONLY socket connections

So from my point the configured server with a soc poll thread should work.


Regards
Rainer