You will likely be using OS authentication, but you do need a user that has
privilege to get to the database.
First off, try running dbaccess (with no options). Choose Query, then
Select a database that you want to use (hopefully you can see one you are
Go to Use-Editor, or New and type in something like:
select * from systables;
Exit out of the editor and choose "Run".
If that went well, you should be looking at some information on tables.
There are different ways to do unloads. For small, simple tables just use
unload to mytable.unl select * from mytable;
This will unload the records to a pipe-delimited ASCII file.
For larger tables you will want to use High Performance Loader or External
To unload the entire database look into the "dbexport" command (note that
this does lock the database while it runs).
Also to check on things, take a look at the "onstat" command. Run onstat -?
To see the options.
onstat - : will show if the instance (a collection of
databases/memory/etc) is On-Line or not
onstat -u : will show connections
onstat -m : will show the end of the Informix log file
There's a bit much to cover in a list post, but hopefully this will get you
From: firstname.lastname@example.org [mailto:email@example.com]
On Behalf Of Jeremy Smith
Sent: Wednesday, September 23, 2015 1:09 AM
Subject: Complete Newbie
Hello, i'm an Oracle DBA and have just been given a Linux Server with dan
Informix database on.
I haven't a clue how to access it. Can anyone tell me how.
Ultimately I need to extract the data.
For now i'd just like to do a select query or something!!
I haven't bee given any passwords but i'm thinking you might be able to use
OS authentification like Oracle
I've Googled a lot but can't find anything remotely helpful.
I found these commands and here is the output
[***@webdad /]# dbaccess -V
DB-Access Version 7.25.UC6R1
[***@webdad /]# isql -V
IBM INFORMIX-SQL Version 7.32.UC3
thanks for your help.