I am using Oracle GAteway to connect to INFORMIX database . I need the following information

Hostname,port,server alias, database

Can some one please give me commands to get this information on server having INFORMIX database.

Its on Unix server.
I know the hostname and database bt how to get port number and server alias

Thankyou

Hi

the serveralias is contained in the $INFORMIXDIR/etc/$ONCONFIG file
look at the value for the DBSERVERALIASES.

Once you got this value, open the $INFORMIXDIR/etc/sqlhosts, find this value in the 1st column, the service name for this instance is in the 4th column. Then find the service name in the /etc/services files, and you'll get the port number.

And there you go!