DBACCESS - Comand not found

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

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 ------------------------------

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 ------------------------------

Dear , 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 ------------------------------

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 serverAm I correct Andreas Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------

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 ------------------------------

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 ------------------------------

>> 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 ------------------------------