Informix Profiling tool.
The poster wanted to capture a history of all SQL executed on an Informix instance, not just the active statements shown by "onstat -g sql", and asked whether onaudit would do this and what performance cost it would carry. Replies didn't really address onaudit; instead they pointed to third-party monitoring tools (Cobrasonic's DBSonar, AGS Server Studio with Sentinel) and to IDS 11's built-in SQL tracing via the OpenAdmin Tool, noted as available only on 11.10+. The poster said he would try the DBSonar evaluation; no outcome was reported.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
I would like to monitor all the SQLs executed or running in the
Informix Engine.
I can use "onstat -g sql ..." utility but this will show the active
SQL's information, but i would like to see the history SQL's status as
well.
I heard that "onaudit" can be used to capture all SQL's status like
Executed by whom, executed time and completed time and so on. If I
turn on this feature, will there be any performance issue in Informix
Engine?
or Is there any third party tool to monitor my Informix Engine?
Any notes or Web-link refering to Onaudit @ Informix will be
appreciated.
Regards,
Ravi Shankar N.
On 10 Dec, 06:24, nr.s...@gmail.com wrote:
> Hi,
>
> I would like to monitor all the SQLs executed or running in the
> Informix Engine.
> I can use "onstat -g sql ..." utility but this will show the active
> SQL's information, but i would like to see the history SQL's status as
> well.
> I heard that "onaudit" can be used to capture all SQL's status like
> Executed by whom, executed time and completed time and so on. If I
> turn on this feature, will there be any performance issue in Informix
> Engine?
> or Is there any third party tool to monitor my Informix Engine?
>
> Any notes or Web-link refering to Onaudit @ Informix will be
> appreciated.
>
> Regards,
> Ravi Shankar N.
CobarSonic have DBSonar http://www.cobrasonic.com/products/DBSonar_overview.html
Alternatively version 11 of Informix has a monitor and analyze recent
SQL statements feature.
http://publib.boulder.ibm.com/infocenter/idshelp/v111/topic/com.ibm.po.doc/new_features.htm#wq21
Cobrasonic's DBSonar and AGS's Server Studio with Sentinel are both
capable of tracking your SQL.
Art S. Kagel
nr.s...@gmail.com wrote:
> Hi,
>
> I would like to monitor all the SQLs executed or running in the
> Informix Engine.
> I can use "onstat -g sql ..." utility but this will show the active
> SQL's information, but i would like to see the history SQL's status as
> well.
> I heard that "onaudit" can be used to capture all SQL's status like
> Executed by whom, executed time and completed time and so on. If I
> turn on this feature, will there be any performance issue in Informix
> Engine?
> or Is there any third party tool to monitor my Informix Engine?
>
> Any notes or Web-link refering to Onaudit @ Informix will be
> appreciated.
>
> Regards,
> Ravi Shankar N.
On Dec 11, 4:00 am, "Art S. Kagel" <art.ka...@gmail.com> wrote:
> Cobrasonic's DBSonar and AGS's Server Studio with Sentinel are both
> capable of tracking your SQL.
>
> Art S. Kagel
>
>
>
> nr.s...@gmail.com wrote:
> > Hi,
>
> > I would like to monitor all the SQLs executed or running in the
> > Informix Engine.
> > I can use "onstat -g sql ..." utility but this will show the active
> > SQL's information, but i would like to see the history SQL's status as
> > well.
> > I heard that "onaudit" can be used to capture all SQL's status like
> > Executed by whom, executed time and completed time and so on. If I
> > turn on this feature, will there be any performance issue in Informix
> > Engine?
> > or Is there any third party tool to monitor my Informix Engine?
>
> > Any notes or Web-link refering to Onaudit @ Informix will be
> > appreciated.
>
> > Regards,
> > Ravi Shankar N.- Hide quoted text -
>
> - Show quoted text -
Thanks David...for your wonderful suggestion...let me try the demo
version of DBSonar.
The OpenAdmin Tool shipped with IDS 11 provides this capability
On Dec 11, 5:58 am, scottishpoet <drybur...@yahoo.com> wrote: > The OpenAdmin Tool shipped with IDS 11 provides this capability True, but only for IDS 11.10+ Art S. Kagel
Dear Ravi,
The DBSonar V5.1 from http://www.cobrasonic.com/downloads/full_form.html
does monitor all the SQLs executed. It is downloadable and free for 30
days evaluation. Please check it out.
Young Tan
Cobrasonic Inc.
On Dec 10, 2:24 pm, nr.s...@gmail.com wrote:
> Hi,
>
> I would like to monitor all the SQLs executed or running in the
> Informix Engine.
> I can use "onstat -g sql ..." utility but this will show the active
> SQL's information, but i would like to see the history SQL's status as
> well.
> I heard that "onaudit" can be used to capture all SQL's status like
> Executed by whom, executed time and completed time and so on. If I
> turn on this feature, will there be any performance issue in Informix
> Engine?
> or Is there any third party tool to monitor my Informix Engine?
>
> Any notes or Web-link refering to Onaudit @ Informix will be
> appreciated.
>
> Regards,
> Ravi Shankar N.
tracing of SQL Statements in IDS 11 was covered on todays technical Support Exchange If anyone would like the slides and replay details please email dryburj@uk.ibm.com
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g