------=_Part_3769_22864520.1214578149482
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
I can answer some of your questions, some I don't know enough about Oracle
to help with, others just don't relate to Informix. See below:
On Fri, Jun 27, 2008 at 8:50 AM, raja <tssr2001@[EMAIL PROTECTED]
> wrote:
> Hi 2 All,
>
> I am new to INFORMIX database.
Welcome. Keep an open mind and you'll grow to love it.
>
>
> I am using INFORMIX 9.4 database in HP-UX System.
Time for an upgrade. ;-)
>
>
> I have few questions, Please clarify those questions for me :
>
> 1. What is in INFORMIX, similar to sqlplus in ORACLE ( to view the
> schema details - tables, indexes,... ) ?
You can see this information in tabular format in dbaccess. Run:
dbaccess mydatabasename
from the menu choose Table, then Info and select a table by typing in the
name, or using the cursor keys if you terminal setup is correct. The top
menu now presents elements of the table to examine.
You can also see the SQL required to create the database with the dbschema
utility.
All are do***ented in the Administrator's Reference manual (dbaccess
actually has its own manual). IDS manuals are online at:
http://www-306.ibm.com/software/data/informix/pubs/library/
>
> 2. What is dbaccess in INFORMIX ?
It is a tool for executing SQL and viewing your database structure. It
includes a rudimentary SQL editor and can be used to create, modify, and
drop objects in the database. It has a menu mode and a commandline mode.
See the manual.
>
> 3. How to execute a sql script file in INFORMIX ?
1. Three basic ways. In the dbaccess menus, select Query-language.
Then
you can use New, Use-editor, or Modify to create or modify a script, or
Choose one from the current directory, then you can Run it.
2. dbaccess mydatabase myscriptname
3. dbaccess mydatabase - <myscriptname
>
> 4. What are the list of tables, that related to DBA, to tune the
> database ?
Read the Administrator's Guide, Administrator's Reference, and the
Performance Guide then start scanning this list history for pointers.
>
> 5. What are the tuning tools in INFORMIX ?
onstat, the ONCONFIG file ($INFORMIXDIR/etc/$ONCONFIG), the SET EXPLAIN
ON;
command, third party tools like AGS Server Studio, the bloody manuals!
> 6. What is in INFORMIX, similar to statspack/AWR Re****t in ORACLE ?
No idea.
>
> 7. What are the ways to tune a sql query in INFORMIX ?
> 8. What are the ways to tune a procedure in INFORMIX ?
See SET DEBUG FILE... and TRACE ... in the Guide to SQL Syntax manual.
>
>
> I would be very much thankful, if you Please explain me these
> questions separately with Examples.
No. RTFM! You'll also find white papers and blogs on IDS on the IBM web
site noted above.
>
> If you have any do***ents or URL, Please send me them.
>
> Thanks in Advance.
>
> With Regards,
> Raja.
> _______________________________________________
> Informix-list mailing list
> Informix-list@[EMAIL PROTECTED]
> http://www.iiug.org/mailman/listinfo/informix-list
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@[EMAIL PROTECTED]
)
Disclaimer: Please keep in mind that my own opinions are my own opinions
and
do not reflect on my employer, Oninit, the IIUG, nor any other
organization
with which I am associated either explicitly or implicitly. Neither do
those
opinions reflect those of other individuals affiliated with any entity
with
which I am affiliated nor those of the entities themselves.
------=_Part_3769_22864520.1214578149482
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
I can answer some of your questions, some I don't know enough about
Oracle to help with, others just don't relate to Informix. See
below:<br><br><div class="gmail_quote">On Fri, Jun 27, 2008 at 8:50 AM,
raja <<a href="mailto:tssr2001@[EMAIL PROTECTED]
">tssr2001@[EMAIL PROTECTED]
>>
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi 2 All,<br>
<br>
I am new to INFORMIX database.</blockquote><div><br>Welcome. Keep an
open mind and you'll grow to love it.<br> </div><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
I am using INFORMIX 9.4 database in HP-UX
System.</blockquote><div><br>Time for an upgrade.
;-)<br> </div><blockquote class="gmail_quote" style="border-left: 1px
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
I have few questions, Please clarify those questions for me :<br>
<br>
1. What is in INFORMIX, similar to sqlplus in ORACLE ( to view the<br>
schema details - tables, indexes,... ) ?</blockquote><div><br>You can see
this information in tabular format in dbaccess. Run:<br><br>dbaccess
mydatabasename<br><br>from the menu choose Table, then Info and select a
table by typing in the name, or using the cursor keys if you terminal
setup is correct. The top menu now presents elements of the table to
examine.<br>
<br>You can also see the SQL required to create the database with the
dbschema utility.<br><br>All are do***ented in the Administrator's
Reference manual (dbaccess actually has its own manual). IDS manuals
are online at: <br>
<br><a
href="http://www-306.ibm.com/software/data/informix/pubs/library/">http://www-306.ibm.com/software/data/informix/pubs/library/</a><br><br> </div><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
2. What is dbaccess in INFORMIX ?</blockquote><div><br>It is a tool for
executing SQL and viewing your database structure. It includes a
rudimentary SQL editor and can be used to create, modify, and drop objects
in the database. It has a menu mode and a commandline mode. See
the manual.<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
3. How to execute a sql script file in INFORMIX
?</blockquote><div><br><ol><li>Three basic ways. In the dbaccess
menus, select Query-language. Then you can use New, Use-editor, or
Modify to create or modify a script, or Choose one from the current
directory, then you can Run it.</li>
<li>dbaccess mydatabase myscriptname</li><li>dbaccess mydatabase -
<myscriptname<br></li></ol> </div><blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.8ex; padding-left: 1ex;">
<br>
4. What are the list of tables, that related to DBA, to tune the<br>
database ?</blockquote><div><br>Read the Administrator's Guide,
Administrator's Reference, and the Performance Guide then start
scanning this list history for pointers.<br> </div><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
5. What are the tuning tools in INFORMIX ?</blockquote><div><br>onstat,
the ONCONFIG file ($INFORMIXDIR/etc/$ONCONFIG), the SET EXPLAIN ON;
command, third party tools like AGS Server Studio, the bloody manuals!
<br><br></div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
6. What is in INFORMIX, similar to statspack/AWR Re****t in ORACLE
?</blockquote><div><br>No idea.<br> </div><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
7. What are the ways to tune a sql query in INFORMIX ?<br>
8. What are the ways to tune a procedure in INFORMIX
?</blockquote><div><br>See SET DEBUG FILE... and TRACE ... in the Guide to
SQL Syntax manual. <br></div><blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.8ex; padding-left: 1ex;">
<br>
<br>
I would be very much thankful, if you Please explain me these<br>
questions separately with Examples.</blockquote><div><br>No.
RTFM! You'll also find white papers and blogs on IDS on the IBM
web site noted above.<br> </div><blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.8ex; padding-left: 1ex;">
<br>
If you have any do***ents or URL, Please send me them.<br>
<br>
Thanks in Advance.<br>
<br>
With Regards,<br>
<font color="#888888">Raja.<br>
_______________________________________________<br>
Informix-list mailing list<br>
<a href="mailto:Informix-list@[EMAIL PROTECTED]
">Informix-list@[EMAIL PROTECTED]
><br>
<a href="http://www.iiug.org/mailman/listinfo/informix-list"
target="_blank">http://www.iiug.org/mailman/listinfo/informix-list</a><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Art S.
Kagel<br>Oninit (<a
href="http://www.oninit.com">www.oninit.com</a>)<br>IIUG
Board of
Directors (<a
href="mailto:art@[EMAIL PROTECTED]
">art@[EMAIL PROTECTED]
>)<br><br>Disclaimer: Please
keep in mind that my own opinions are my own opinions and do not reflect
on my employer, Oninit, the IIUG, nor any other organization with which I
am associated either explicitly or implicitly. Neither do those opinions
reflect those of other individuals affiliated with any entity with which I
am affiliated nor those of the entities themselves.<br>
------=_Part_3769_22864520.1214578149482--
|
