Re: sql tracing and logging
- From: Jonathan Leffler <jleffler@xxxxxxxxxxxxx>
- Date: Sat, 29 Oct 2005 06:14:54 GMT
mc4u wrote:
The software I use came bundled with Informix and I would like to know how to trace which tables the data is stored in from any given screen in the application. For example, our support group informed me that they ran a trace on the screen in question and they referenced only one table. However, there are columns in this particular screen of the application which do not belong to the table. Any suggestions on how to trace or informix logging would be helpful.
Which version of IDS? Indeed, is the DBMS you're using IDS, or is it XPS or OnLine or SE? What language is the application written in? Platform?
Options to consider include: * Dynamic SET EXPLAIN - requires IDS 9.40 or later. * SQLIDEBUG - ideally requires sqliprint, which you may or may not have. * I-Spy - requires an extra product and some configuration. * Audit - ON-Audit, ON-ShowAudit; least informative, but would tell you which tables are in use. * DB-Schema - would show you the database structure. Add row counts (UPDATE STATISTICS) and you'd be able to track some activity.
There are probably other options too - network snooping is tantamount to using SQLIDEBUG without sqliprint, but would probably have less impact on the system, but only works for network connections.
-- Jonathan Leffler #include <disclaimer.h> Email: jleffler@xxxxxxxxxxxxx, jleffler@xxxxxxxxxx Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ .
- References:
- sql tracing and logging
- From: mc4u
- sql tracing and logging
- Prev by Date: Re: Insert unique values problem.
- Next by Date: Re: Google Base: All your base are, in fact, belong to us
- Previous by thread: sql tracing and logging
- Next by thread: Insert unique values problem.
- Index(es):
Relevant Pages
|
|
