Topic
4 replies Latest Post - ‏2005-08-29T07:49:18Z by SystemAdmin
SystemAdmin
SystemAdmin
332 Posts
ACCEPTED ANSWER

Pinned topic Informix 9.4 on HPUX 11.11

‏2005-08-19T06:11:17Z |
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"?
Updated on 2005-08-29T07:49:18Z at 2005-08-29T07:49:18Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    332 Posts
    ACCEPTED ANSWER

    Re: Informix 9.4 on HPUX 11.11

    ‏2005-08-23T03:01:04Z  in response to SystemAdmin
    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).
  • SystemAdmin
    SystemAdmin
    332 Posts
    ACCEPTED ANSWER

    Re: Informix 9.4 on HPUX 11.11

    ‏2005-08-24T04:52:15Z  in response to SystemAdmin
    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.
  • SystemAdmin
    SystemAdmin
    332 Posts
    ACCEPTED ANSWER

    Re: Informix 9.4 on HPUX 11.11

    ‏2005-08-24T20:13:02Z  in response to SystemAdmin
    "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.
  • SystemAdmin
    SystemAdmin
    332 Posts
    ACCEPTED ANSWER

    Re: Informix 9.4 on HPUX 11.11

    ‏2005-08-29T07:49:18Z  in response to SystemAdmin
    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.