Unable to give DBSERVERALIASES to an Instance.

[Pradip]

I am running INFORMIX 7.23 OnLine on SUN OS having single instance.
Now I want to give another name to my database server. So I did
following steps :

My System Configuration section of onconfig file was originally as

# System Configuration

SERVERNUM 1 # Unique id corresponding to a OnLine
instance
DBSERVERNAME baanhzw # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE tlitcp,2,100,CPU # Configure poll thread(s) for
nettype
NETTYPE sqlmux,,, # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No =
0)

MULTIPROCESSOR 1 # 0 for single-processor, 1 for
multi-processor
NUMCPUVPS 2 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps
to one

NOAGE 1 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 2 # Affinity number of processors

In above file, I modified DBSERVERALIASES=ittest & added
NETTYPE=tlitcp,2,100,NET.

After that I made entry in sqlhosts file which looks like

baanhzw ontlitcp baanapp1 infserv m=1
ittest ontlitcp baanapp1 infserv1

Finally I added service in /etc/services as
infserv1 6800/tcp # INFORMIX

After above modifications I tried to restart instance by oninit it
gave me error as :

oninit: DBSERVERNAME 'ittest' not in sqlhosts file or sqlhosts file
contents
are damaged.

Can anyone tell where I am wrong??

[Scott Hanson]

Have you set $INFORMIXSQLHOSTS to anything other than
$INFORMIXDIR/etc/sqlhosts?

Scott
--
Scott Hanson t:01932 724027
Technical Director m:07768 038436
Ardenta Limited e:scott....@ardenta.com

"Pradip" <pradip...@hotmail.com> wrote in message
news:802a305.01100...@posting.google.com...

[Mark D. Stock]

The usual cause of this type of error, if all looks okay in your
configuration, is that you HAVE or HAVEN'T set INFORMIXSQLHOSTS. ;-)

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mds...@mydas.freeserve.co.uk |//////// /|
| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+

[Hari Gupta]

Hi Pradip,

Presuming that you have sqlhosts under $INFORMIXDIR/etc, can you test the
following for me pl. ?

In your sqlhosts:

baanhzw ontlitcp baanapp1 infserv m=1
ittest ontlitcp baanapp1 infserv1

Do it for me and let me know:

change second line above of sqlhosts file as:

ittest ontlitcp baanapp1 baanhzw

If it doesn't work then we may need to look at /etc/services also.

Thanks,

Hari Gupta

"Pradip" <pradip...@hotmail.com> wrote in message
news:802a305.01100...@posting.google.com...