Informix

 View Only

  • 1.  DBACCESS - Comand not found

    Posted Tue May 18, 2021 03:26 AM
    Dears,

    cbasys@rs-om-btch-201:~$
    RS-OM-BTCH-201^C

    cbasys@rs-om-btch-201:~$ su - rpa_omdb_test
    Password:
    Authorized users only. All activity may be monitored and reported.
    mesg: cannot change mode

    rpa_omdb_test@rs-om-btch-201:~$ dbaccess oltp@test_ne51
    -bash: dbaccess: command not found
    rpa_omdb_test@rs-om-btch-201:~$  
    ​
    While connecting from Source sever to Destination Server getting above error. Why this error coming ?

    What I got to know that on the Source server CSDK must be installed for making connection ?  Am I correct?

    IF this is ok, then Do I need to install only CSDK on Source server or need to make any other entries also on Source server. 

    Kindly suggest.


    Thanks 
    Amit


    ------------------------------
    AMIT PATEL
    ------------------------------

    #Informix


  • 2.  RE: DBACCESS - Comand not found

    Posted Tue May 18, 2021 03:33 AM
    Hi Amit,

    Yes you need CSDK/JDBC for your applications to talk to Informix Server. Here not sure what you mean by "Source server"!. "dbaccess" utility is part of CSDK install (Informix Server install also ships dbaccess utility). You need to install CSDK in the machine from where you want to run/compile your applications.

    HTH

    Thanks
    -Shesh

    ------------------------------
    Sheshnarayan Agrawal
    ------------------------------

    Original Message


  • 3.  RE: DBACCESS - Comand not found

    Posted Tue May 18, 2021 03:39 AM
    Dear Sheshnarayan,
         

             Thanks for your reply.

        There are two server. One is DB server where informix installed and has whole running database.

       And one server where unix installed and from that server user needs to access the data by making connection thru "dbaccess dbname" .


    Thanks
    Amit Patel

    ------------------------------
    AMIT PATEL
    ------------------------------

    Original Message


  • 4.  RE: DBACCESS - Comand not found

    Posted Tue May 18, 2021 06:01 AM
    >>And one server where unix installed and from that server user needs to access the data by making connection thru "dbaccess dbname" .
    Shesh: In this Unix server, you need to install CSDK, beside INFORMIXDIR, PATH, INFORMIXSERVER environment variables, you also need to specify end points, server name and protocol of Informix Server (running on another machine) in the file and set the environment variable INFORMIXSQLHOSTS to this file.

    ------------------------------
    Sheshnarayan Agrawal
    ------------------------------

    Original Message


  • 5.  RE: DBACCESS - Comand not found

    IBM Champion
    Posted Tue May 18, 2021 03:34 AM
    As with any other software that doesn't install under system default directories, you need to make it known where to find it.
    You'd do that by either calling the program with a full path/to/program/binary, or by adding that path/to/program to PATH env var.

    In addition, certain software, e.g. Informix, will need other environment settings.

    So you'll have to set (and export):
    • INFORMIXDIR=/path/to/csdk
    • PATH=$INFORMIXDIR/bin:$PATH
    • INFORMIXSERVER=your_server


    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message


  • 6.  RE: DBACCESS - Comand not found

    Posted Tue May 18, 2021 03:45 AM
    Dear andreas,

        Source server is only Unix server and Destination Server where Informix Installed with database.

     So on the Source Server do I need to make entries like below

    So you'll have to set (and export):
    • INFORMIXDIR=/path/to/csdk  --$INFORMIXDIR/bin
    • PATH=$INFORMIXDIR/bin:$PATH 
    • INFORMIXSERVER=your_server   -- informix server name on destination server 

               Am I correct Andreas


    Thanks 
    Amit Patel


    ------------------------------
    AMIT PATEL
    ------------------------------

    Original Message


  • 7.  RE: DBACCESS - Comand not found

    Posted Tue May 18, 2021 04:35 AM
    Dear Andreas,

     If I login as informix user and type "env" command I get following 


    But when I do "env" from normal user login 


    So Do I need to export the command which you mentioned earlier , to do the needful. Kindly confirm.


    Thanks
    Amit

    ------------------------------
    AMIT PATEL
    ------------------------------

    Original Message


  • 8.  RE: DBACCESS - Comand not found

    IBM Champion
    Posted Tue May 18, 2021 04:59 AM
    Someone must have provided those environment settings in user informix' login environment (and also created and populated that sqlhosts.dba file). And there are quite some more settings relevant for your Informix connections in that environment which you might not want to miss.  (The INFORMIXDIR and PATH settings I mentioned mainly only would overcome the 'dbaccess not found' problem.)

    Go find out where this is being done (~informix/.bash_profile, ~informix/.bashrc, or a file referenced by one of those, ...)

    For a regular user, you'd have to implement the same or something comparable.​
    You might also have to take care of permissions, e.g. read access to that sqlhosts file.

    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message