Sunil Raja said:
> Hi,
>
>
>>From your previous suggestions,
>
> 1. sorry its not analyzed, which i mentioned in the previous mail.
> a. its regarding the update statistics. regarding update
> statistics, still have doubt. still dont know which one we should use as
> default (low, high, medium ), or which should be used in common to an
> application.
> b. dont know how to find whether a table or index or schema
> has
> updated statistics, so that we need not perform update statistics.
>
> 2. found to execute a sql script using dbaccess. its working fine
> 3. have downloaded *utils2_ak*. will check and get back to you.
>
>
> *Doubts:
> *1. if we want to tune a query in INFORMIX, first we see the EXPLAIN
PLAN
> of
> the query using *SET EXPLAIN ON*.
> similarly if we want to tune a procedure, in *ORACLE* there is *
> DBMS_PROFILER*, which when run shows a similar kind of explain plan for
> the
> procedure and then shows which line of the procedure is taking how much
> time
> to execute.... from this we can check the performance bottlenecks...
> similarly what is there in *INFORMIX 9.4 using HP-UX 5.3
> *
SET TRACE ON;
> 2. do you have any scripts such as health check of the database, which
> would
> help to diagnise or analyze the performance bottlenecks. or any scripts
> that
> would tel where the problem is in the database with regard to
performance
> tuning. ( the performance tuning is to be done for an *OLTP *application
)
>
There are no scripts that I know of. Run the command "onstat -p", and
"onstat -c" then post the output here. Or just RTFM.
> 3. *ONPERF, ONBAR, ONLOG* are not working
onperf doesn't run on all platforms.
onbar needs a storage manager, just use ontape.
onlog should work, log a sup****t case.
> (also *SAR* is not working ) ,
Sar is not an Informix utility. :o)
Try "glance"
> any
> suggestions. are these utilities so im****tant for performance tuning. or
*
> ONSTAT* is enough
onstat is enough.
> With Regards,
> Raja.
>
>
>
>
> On Tue, Jul 1, 2008 at 2:56 AM, Obnoxio The Clown
> <obnoxio@[EMAIL PROTECTED]
>
> wrote:
>
>>
>> Sunil Raja said:
>> > Hi,
>> >
>> > Thanks for your suggestions, Had a view at onstat, onconfig file,
>> > sysmaster
>> > tables, systables,...
>> >
>> > Please clarify me the following questions :
>> >
>> > 1. How / Where can i find whether a table/index/... is analyzed or
not
>> ?
>> > and
>> > when was it analyzed last ( last date analyzed ) ?
>>
>> What do you mean analysed?
>
>
> **
>
>> 2. How to analyze a particular table or index or entire schema ? (
>> Please
>> explain with example, as got confused with high, low and
>> medium parameters... )
>
> Download the utils2_ak bundle from iiug.org, and use the dostats
utility.
>
>
>
>> 3. How to run/execute a sql script and view the output in dbaccess ?
>
> dbaccess databasename scriptname.sql | more
>>
>> > 4. What are the ways to tune a sql query in INFORMIX ?
>>
>> Huh?
>>
>> > 5. What are the ways to tune a procedure in INFORMIX ?
>>
>> Huh?
>>
>> --
>> Bye now,
>> Obnoxio
>>
>> "There were a myriad of problems which conspired to corrupt your reason
>> and rob you of your common sense. Fear got the best of you, and in your
>> panic you turned to the Labour Party. They promised you order, they
>> promised you peace, and all they demanded in return was your silent,
>> obedient consent."
>>
>>
>>
>
>
>
--
Bye now,
Obnoxio
"There were a myriad of problems which conspired to corrupt your reason
and rob you of your common sense. Fear got the best of you, and in your
panic you turned to the Labour Party. They promised you order, they
promised you peace, and all they demanded in return was your silent,
obedient consent."
|
