topic Re: Informix error in Operating System - HP-UX

Informix error

Pedro Cosmen — Wed, 15 Dec 2004 07:35:27 GMT

Hello:

I have a problem with an old F30 server runnig HP-UX 10.20 and Informix 7.31. every time i try to start Informix failed and the message i nthe online.log is :

Wed Dec 15 12:20:50 2004

12:20:50 Event alarms enabled. ALARMPROG = '/usr/bin/true'
12:20:56 DR: DRAUTO is 0 (Off)
12:20:56 listener-thread: err = -27006: oserr = 226: errstr = : Network driver
cannot establish listen endpoint.
System error = 226.
12:20:56 Attempting to bring listener thread down.

12:20:56 Server stopped.

Thank you for your help.

Re: Informix error

kamalnathan — Wed, 15 Dec 2004 16:48:25 GMT

Check the sqlhosts (in INFORMIXDIR )
and /etc/services file has the same name and entry for services.

also check the host IP is listed in /etc/hosts file

Re: Informix error

kamalnathan — Wed, 15 Dec 2004 16:50:16 GMT

please make sure INFORMIXSERVER variable is set to instant name

Re: Informix error

JJ_4 — Thu, 16 Dec 2004 06:03:37 GMT

Have a look under /INFORMIXTMP and see what files are there (post the ls -latr output)

If you have no other instances try :

mv /INFORMIXTMP /INFORMIXTMP.orig

and then

oninit -v

This will re-create /INFORMIXTMP.

If you have other instances, you would need to post your DBSERVERNAME and DBSERVERALIAS along with the $INFORMIXDIR/etc/sqlhosts file.

Re: Informix error

Pedro Cosmen — Thu, 16 Dec 2004 07:39:15 GMT

Thank you for your help, it was an .str file in the INFORMIXTMP dir.