Regarding INFORMIX Basic Details

Hi 2 All,

I am new to INFORMIX database.

I am using INFORMIX 9.4 database in HP-UX System.

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,... ) ?
2. What is dbaccess in INFORMIX ?
3. How to execute a sql script file in INFORMIX ?
4. What are the list of tables, that related to DBA, to tune the
database ?
5. What are the tuning tools in INFORMIX ?
6. What is in INFORMIX, similar to statspack/AWR Re****t in ORACLE ?
7. What are the ways to tune a sql query in INFORMIX ?
8. What are the ways to tune a procedure in INFORMIX ?

I would be very much thankful, if you Please explain me these
questions separately with Examples.
If you have any do***ents or URL, Please send me them.

Thanks in Advance.

With Regards,
Raja.