Informix

Expand all | Collapse all

DBACCESS - Comand not found

  • 1.  DBACCESS - Comand not found

    Posted 26 days ago
    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
    ------------------------------


  • 2.  RE: DBACCESS - Comand not found

    Posted 26 days ago
    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
    ------------------------------



  • 3.  RE: DBACCESS - Comand not found

    Posted 26 days ago
    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
    ------------------------------



  • 4.  RE: DBACCESS - Comand not found

    Posted 26 days ago
    >>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
    ------------------------------



  • 5.  RE: DBACCESS - Comand not found

    Posted 26 days ago
    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
    ------------------------------



  • 6.  RE: DBACCESS - Comand not found

    Posted 26 days ago
    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
    ------------------------------



  • 7.  RE: DBACCESS - Comand not found

    Posted 26 days ago
    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
    ------------------------------



  • 8.  RE: DBACCESS - Comand not found

    Posted 26 days ago
    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
    ------------------------------