We are using Informix 9.4 on HPUX 11.11, with DataStage 7.5. A1 installed on the same server.
We have problems accessing Informix server with cli stage, when we use the 32 bits drivers we get an error on the connect "bad or invalid sign"?
Re: Informix 9.4 on HPUX 11.112005-08-23T03:01:04ZThis is the accepted answer. This is the accepted answer.Are you CERTAIN you're using the 32 bit drivers? That is, does their library appear before the 64 bit drivers' libaray in SHLIB_PATH?
If you've run a job, look at the log entry that exposes values of the environment variables (usually the second event logged in a run, immediately after the Started event).
Re: Informix 9.4 on HPUX 11.112005-08-24T04:52:15ZThis is the accepted answer. This is the accepted answer.Controling the SHLIB_PATH we only have 32 bit drivers in the path, all 64 bit drivers are removed from the PATH.
The SHLIB_PATH for dsadm user is only set in the dsenv file.
Re: Informix 9.4 on HPUX 11.112005-08-24T20:13:02ZThis is the accepted answer. This is the accepted answer."Bad or invalid sign" is a very unusual message to get when attempting to connect.
Is this an attempt to connect via View Data or via a running job? If it is a running job, can you trace the stage (subroutine calls and properties) that is experiencing the difficulty? This diagnostic information will help you, support or forum participants to see exactly what is being sent to and received from Informix via the CLI.
Re: Informix 9.4 on HPUX 11.112005-08-29T07:49:18ZThis is the accepted answer. This is the accepted answer.We fount the error, to connect to infomix we need to "." the informix.env file and this file was reseting the SHLIB_PATH insted of adding to the SHLIB_PATH.
After chaning this file to add to the SHLIB_PATH we can now connect
Thanks for the help.