Log and Query Analysis Tools
A user asked whether Informix has log/query profiling tools comparable to pgFouine for PostgreSQL, i.e. something that trawls logs to report query counts and execution times. Replies noted that Informix logical logs record data changes, not SQL text, so alternatives were suggested: SQLIDEBUG/sqliprint traces (Aubit has a formatter), the built-in SQLTRACE facility queried via sysmaster views, the free Open Admin Tool (OAT) for graphing/analysis, and commercial options like AGS Sentinel and Exact Solutions iWatch. The poster settled on trying OAT; download links were pointed out on the Aubit VMware images page.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi there, I hope my question isn't too naive, but I'm curious about how folks using Informix profile their database usage and query patterns. For other databases like Postgres and Oracle, there are programs that can trawl the logs, and come up with graphs or tables showing counts and execution times for specific or related queries. http://pgfouine.projects.postgresql.org/ (This looked neat, and helpful) We could write our own, but if there's already a product like that, free or otherwise, that would be fantastic. Thank you for your thoughts, Chris -- christopher.nielsen@gmail.com http://rhythm.com/
I think Lintel have something that can show what data has been changed (updates/deletes/inserts etc) - but I dont think it shows the SQLs/timings for things like SELECT.. You can get that (SQLIDEBUG springs to mind - I'm sure there are other ways too) - but to my knowledge the SQL statements are not stored in the log files (just the effect of the statements). If you try using SQLIDEBUG - we have a tool that can reformat the output from the 'sqliprint' command into something more readable :-) 2009/8/15 sparc <christopher.nielsen@gmail.com> > > Hi there, > > I hope my question isn't too naive, but I'm curious about how folks > using Informix profile their database usage and query patterns. > > For other databases like Postgres and Oracle, there are programs that > can trawl the logs, and come up with graphs or tables showing counts > and execution times for specific or related queries. > > http://pgfouine.projects.postgresql.org/ (This looked neat, and > helpful) > > We could write our own, but if there's already a product like that, > free or otherwise, that would be fantastic. > > Thank you for your thoughts, > > Chris > > -- > christopher.nielsen@gmail.com > http://rhythm.com/ > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >
> Mike Aubury <i...@aubit.com> wrote: > I think Lintel have something that can show what data > has been changed (updates/deletes/inserts etc) [...] If > you try using SQLIDEBUG - we have a tool that can reformat the output > from the 'sqliprint' command into something more readable :-) That sounds promising, yeah. > Dhanashri C Kudgavkar<dkudgavk@in.ibm.com> wrote: > Have you looked at Open Admin Tool available for IDS : > http://www-01.ibm.com/software/data/informix > Thanks, Dhanashree Kudgavkar That looks amazing too. There is so much analysis that app can do, and it's free too. I'll have to try setting it up, and taking it for a spin! Thank you all for the help :) I'm glad there's so much available for Informix. Chris -- christopher.nielsen@gmail.com Rhythm & Hues Studios: http://rhythm.com/
> Thank you all for the help :) I'm glad there's so much available for > Informix. All of the software at http://www.aubit.com/, also seem incredibly useful. Thanks again, Chris -- christopher.nielsen@gmail.com Rhythm & Hues Studios:http://rhythm.com/
"sparc" <christopher.nielsen@gmail.com> wrote in message news:92ec57e4-95a3-4cfd-8ca2-34d3c0783708@c29g2000yqd.googlegroups.com... > Thank you all for the help :) I'm glad there's so much available for > Informix. >> All of the software at http://www.aubit.com/, also seem incredibly useful. How did you download them? I moseyed around the site for a while but, other than seeing the facility to download an illutrative VMWare VM, I couldn't see how you would get them to evaluate. rgds
sparc wrote: > Hi there, > > I hope my question isn't too naive, but I'm curious about how folks > using Informix profile their database usage and query patterns. > > For other databases like Postgres and Oracle, there are programs that > can trawl the logs, and come up with graphs or tables showing counts > and execution times for specific or related queries. > > http://pgfouine.projects.postgresql.org/ (This looked neat, and > helpful) > > We could write our own, but if there's already a product like that, > free or otherwise, that would be fantastic. > > Thank you for your thoughts, > > Chris > > -- > christopher.nielsen@gmail.com > http://rhythm.com/ You can activate the SQL tracing facility. Just search the manual for SQLTRACE. It can collect a lot of stuff. Then you can process it using various ways: - OAT - Querying the sysmaster database views Other tools can probably be helpful (AGS Sentinel for example) Regards.
> How did you download them? I moseyed around the site for a while but, other > than seeing the facility to download an illutrative VMWare VM, I couldn't > see how you would get them to evaluate. rgds On the page with the VMWare SLES images, below the fold, there are more links to download Open Admin. There are links to tarballs and zips for for Linux, Windows, and OSX, 64bit and 32bit. - Chris -- christopher.nielsen@gmail.com http://rhythm.com/
On Aug 17, 1:11 am, sparc <christopher.niel...@gmail.com> wrote: > > How did you download them? I moseyed around the site for a while but, other > > than seeing the facility to download an illutrative VMWare VM, I couldn't > > see how you would get them to evaluate. rgds > > On the page with the VMWare SLES images, below the fold, there are > more links to download Open Admin. > > There are links to tarballs and zips for for Linux, Windows, and OSX, > 64bit and 32bit. > > - Chris > > -- > christopher.niel...@gmail.comhttp://rhythm.com/ Exact Solutions has the iWatch software to do this realtime with the ability to archive off performance data. You get timings on the network loop as well as how long it took the instance to respond to the query. Easy to drill down to identify slow queries. HTH Russ
On Fri, Aug 14, 2009 at 18:16, sparc<christopher.nielsen@gmail.com> wrote: > I hope my question isn't too naive, but I'm curious about how folks > using Informix profile their database usage and query patterns. > > For other databases like Postgres and Oracle, there are programs that > can trawl the logs, and come up with graphs or tables showing counts > and execution times for specific or related queries. > > http://pgfouine.projects.postgresql.org/ (This looked neat, and > helpful) > > We could write our own, but if there's already a product like that, > free or otherwise, that would be fantastic. I've not checked the referenced tool, but some of the facilities in OAT - the Open Admin Tool - sound similar to what you want. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Marie von Ebner-Eschenbach - "Even a stopped clock is right twice a day." - http://www.brainyquote.com/quotes/authors/m/marie_von_ebnereschenbac.html