Back in November, a user asked how they could find an Informix database on a Unix server.....they were told to try the onstat -d command, and to try dbaccess.

Brand newto all of this here....if I'm at the command prompt of the Unix server, do I simply type onstat -d and return?

Hi there,

onstat -d will give list of all dbspaces. type dbaccess at command prompt, it is a tool thru which you can run ur sql statements. visit the informix site
http://www-3.ibm.com/software/data/i.../pubs/library/

Hmmmm.....not working....do I have to be in a particular directory?

Make sure all your environmental variables are set

INFORMIXDIR=/Informix; export INFORMIXDIR
PATH=$INFORMIXDIR/bin:$PATH; export PATH
ONCONFIG=onconfig; export ONCONFIG
INFORMIXSERVER=servername; export INFORMIXSERVER
INFORMIXSQLHOSTS=/Informix/etc/sqlhosts;
export INFORMIXSQLHOSTS