Re: Informix on AIX (newbie).
--0-447906701-1104438541=:67945
Content-Type: text/plain; charset=us-ascii
Assuming you only have one instance of informix running, you can just type in 'dbaccess' and all the databases for that instance will display in the dbaccess window.
onstat -- will show you all the onstat options ( which will apply to your instance )
onmode -- will show you all the onmode options.
oncheck -- will show you all the oncheck options.
echo "select * from sysdatabases" | dbaccess sysmaster will show you all the databases too.
Nuno Paquete <nmp@ispgaya.pt> wrote:
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" 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" 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
>
>
========================
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator
email: fwellers@yahoo.com
Work: 703-733-4126
Pager: 703-705-9241
Email Pager: 7037059241@my2way.com
Home: 703-430-0805
Cell: 703-477-6045
========================
--0-447906701-1104438541=:67945
Content-Type: text/html; charset=us-ascii
<DIV>Assuming you only have one instance of informix running, you can just type in 'dbaccess' and all the databases for that instance will display in the dbaccess window.</DIV>
<DIV> </DIV>
<DIV>onstat -- will show you all the onstat options ( which will apply to your instance )</DIV>
<DIV>onmode -- will show you all the onmode options.</DIV>
<DIV>oncheck -- will show you all the oncheck options.</DIV>
<DIV> </DIV>
<DIV>echo "select * from sysdatabases" | dbaccess sysmaster will show you all the databases too.</DIV>
<DIV><BR><BR><B><I>Nuno Paquete <nmp@ispgaya.pt></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Hi,<BR><BR>Thank you for the answer.<BR>Can you give me an example about the commands you gave me?<BR>Lets suppose that I'm at the command line and I need to see all the <BR>databases of the server...<BR>Can you give the entire command?<BR><BR>Thanks in advance.<BR><BR><BR>"Doug Lawry" <LAWRY@NILDRAM.CO.UK>escreveu na mensagem <BR>news:cr0unf$4oi$1@nntp0.reith.bbc.co.uk...<BR>> The main command line tools are:<BR>><BR>> dbaccess (SQL queries)<BR>> onmonitor (configuration)<BR>> onstat (information)<BR>><BR>> These are all described under Database Servers at:<BR>><BR>> www.ibm.com/software/data/informix/pubs/library<BR>><BR>> However, I recommend using an ODBC or JDBC graphical interface,<BR>> the best of which is at:<BR>><BR>> www.serverstudio.com<BR>><BR>> -- <BR>> Regards,<BR>> Doug Lawry<BR>>
www.douglawry.webhop.org<BR>><BR>><BR>> "Nuno Paquete" <NMP@ISPGAYA.PT>wrote in message<BR>> news:41d3efa0$0$3744$a729d347@news.telepac.pt...<BR>>> Hi goup,<BR>>><BR>>> I need to start administering an Informix database that runs on an AIX<BR>>> server.<BR>>> I've no problem using unix systems (specially linux) but I don't know how <BR>>> to<BR>>> star interacting with the database.<BR>>> I've got some good manuals about Informix, but I'm a little confuse with <BR>>> the<BR>>> way I can interact with it.<BR>>> Is it something like MySql on Linux (mysql -u username -p) ?<BR>>> For example, how can I see all the databases and tables of the system?<BR>>> Any help would be appreciated.<BR>>><BR>>> Regards,<BR>>><BR>>> Nuno Paquete<BR>><BR>> <BR><BR></BLOCKQUOTE><BR><BR><DIV>
<DIV>========================<BR>-<<Floyd Wellershaus>>-<BR>Database Administrator<BR>Unix Administrator</DIV>
<DIV><BR>email: <A href="mailto:fwellers@yahoo.com">fwellers@yahoo.com</A><BR>Work: 703-733-4126</DIV>
<DIV>Pager: 703-705-9241 </DIV>
<DIV>Email Pager: <A href="mailto:7037059241@my2way.com">7037059241@my2way.com</A></DIV>
<DIV>Home: 703-430-0805</DIV>
<DIV>Cell: 703-477-6045<BR>========================</DIV></DIV>
--0-447906701-1104438541=:67945--
sending to informix-list