Informix on AIX (newbie).
Nuno Paquete, new to Informix on AIX, asked how to interact with it and list databases. Doug Lawry named dbaccess, onmonitor and onstat plus graphical ODBC/JDBC tools; Nuno asked for an exact command. Art Kagel pointed to his listdb tool in utils2_ak in the IIUG repository and listed utilities such as dbschema, dbexport, dbimport, onlog, onparams, onspaces and finderr.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi goup, I need to start administering an Informix database that runs on an AIX server. I've no problem using unix systems (specially linux) but I don't know how to star interacting with the database. I've got some good manuals about Informix, but I'm a little confuse with the way I can interact with it. Is it something like MySql on Linux (mysql -u username -p) ? For example, how can I see all the databases and tables of the system? Any help would be appreciated. Regards, Nuno Paquete
The main command line tools are:
dbaccess (SQL queries)
onmonitor (configuration)
onstat (information)
These are all described under Database Servers at:
www.ibm.com/software/data/informix/pubs/library
However, I recommend using an ODBC or JDBC graphical interface,
the best of which is at:
www.serverstudio.com
--
Regards,
Doug Lawry
www.douglawry.webhop.org
"Nuno Paquete" <nmp@ispgaya.pt> wrote in message
news:41d3efa0$0$3744$a729d347@news.telepac.pt...
> Hi goup,
>
> I need to start administering an Informix database that runs on an AIX
> server.
> I've no problem using unix systems (specially linux) but I don't know how to
> star interacting with the database.
> I've got some good manuals about Informix, but I'm a little confuse with the
> way I can interact with it.
> Is it something like MySql on Linux (mysql -u username -p) ?
> For example, how can I see all the databases and tables of the system?
> Any help would be appreciated.
>
> Regards,
>
> Nuno Paquete
Hi,
Thank you for the answer.
Can you give me an example about the commands you gave me?
Lets suppose that I'm at the command line and I need to see all the
databases of the server...
Can you give the entire command?
Thanks in advance.
"Doug Lawry" <lawry@nildram.co.uk> escreveu na mensagem
news:cr0unf$4oi$1@nntp0.reith.bbc.co.uk...
> The main command line tools are:
>
> dbaccess (SQL queries)
> onmonitor (configuration)
> onstat (information)
>
> These are all described under Database Servers at:
>
> www.ibm.com/software/data/informix/pubs/library
>
> However, I recommend using an ODBC or JDBC graphical interface,
> the best of which is at:
>
> www.serverstudio.com
>
> --
> Regards,
> Doug Lawry
> www.douglawry.webhop.org
>
>
> "Nuno Paquete" <nmp@ispgaya.pt> wrote in message
> news:41d3efa0$0$3744$a729d347@news.telepac.pt...
>> Hi goup,
>>
>> I need to start administering an Informix database that runs on an AIX
>> server.
>> I've no problem using unix systems (specially linux) but I don't know how
>> to
>> star interacting with the database.
>> I've got some good manuals about Informix, but I'm a little confuse with
>> the
>> way I can interact with it.
>> Is it something like MySql on Linux (mysql -u username -p) ?
>> For example, how can I see all the databases and tables of the system?
>> Any help would be appreciated.
>>
>> Regards,
>>
>> Nuno Paquete
>
>
Nuno Paquete wrote:
> Hi goup,
Note that there are also a ton of useful tools in the IIUG Software
Repository on the IIUG web site (www.iiug.org and select 'software').
Including tools like my listdb tool (in the package utils2_ak which contains
several other DBA level tools as well. In addition to the IBM tools already
mentioned look at:
dbschema - print the DDL schema of a table or entire database
dbexport - export a database to ascii files or tape
dbimport - import the output of a dbexport run
onunload - export a table or entire database to to binary page image files
or tape
onlog - view logical log records
dbload - load data from several formats into database table(s)
finderr - translate SQL and ISAM error codes into text
ipload/onpload - High speed data loader/unloader
onparams - manage manage logical and physical logs
onspaces - manage server chunks
onperf - configurable server performance monitor
xtree - graphical query watcher
See the Administrator's Reference manual for details
Art S. Kagel
> I need to start administering an Informix database that runs on an AIX
> server.
> I've no problem using unix systems (specially linux) but I don't know how to
> star interacting with the database.
> I've got some good manuals about Informix, but I'm a little confuse with the
> way I can interact with it.
> Is it something like MySql on Linux (mysql -u username -p) ?
> For example, how can I see all the databases and tables of the system?
> Any help would be appreciated.
>
> Regards,
>
> Nuno Paquete
>
>