IDS Forum

Re: DB Monitoring

Posted By: Richard Snoke
Date: Tuesday, 6 January 2009, at 12:03 p.m.

In Response To: DB Monitoring (KRISHNAN BALASUBRAMANIAN)

Version and platform?

If you're on IDS 11.10 or later, then you might consider SQL Tracing. Or
you might consider the audit facility to audit only those events you care
about (begin and end transaction events). I suspect SQL Tracing will
alter the test too much, but auditing a small number of events will
probably not change things significantly.

If you can wait until the test finishes, you might use onlog to find the
begin work and commit/rollback records after the test is finished.

You might consider SQLIDEBUG/sqliprint, but then you'll have quite a chore
to parse out what you want, and that generates a very large file very
quickly.

During the test, onstat -p or a query on sysmaster:sysprofile will let you
watch the number of commits and rollbacks. onstat -pr 10 is what I use to
gauge the rate of progress of a performance test. That lets me watch the
transaction rate, the latch, lock and buffer waits, and other things all
at once. When the test is over, I capture data from sysmaster:sysptprof
to ensure the right number of actions were done on each table.

Cheers,
Dick Snoke
IBM Data Management - ChannelWorks
dsnoke@us.ibm.com
(404) 487-1595

From:
"KRISHNAN BALASUBRAMANIAN" <krishnanbalasubramanian@rediffmail.com>
To:
ids@iiug.org
Date:
01/06/2009 04:12 AM
Subject:
DB Monitoring [14444]

Hi,

What is the best way to monitor the forground and background processing of
an
application in informix...?

Example: I have an application which undergoes for a performance testing,
the
tester wants to know how to monitor each and every transactions, execution

time, etc.

Thanks

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• DB Monitoring
  KRISHNAN BALASUBRAMANIAN -- Tuesday, 6 January 2009, at 4:10 a.m.
  • RE: DB Monitoring
    R Fo -- Tuesday, 6 January 2009, at 7:22 a.m.
    • Re: RE: DB Monitoring
      KRISHNAN BALASUBRAMANIAN -- Tuesday, 6 January 2009, at 7:29 a.m.
      • RE: DB Monitoring
        R Fo -- Tuesday, 6 January 2009, at 7:39 a.m.
      • Re: RE: DB Monitoring
        Art Kagel -- Tuesday, 6 January 2009, at 11:53 a.m.
        • Re: RE: DB Monitoring
          KRISHNAN BALASUBRAMANIAN -- Tuesday, 6 January 2009, at 11:35 p.m.
          • Re: RE: DB Monitoring
            John Miller iii -- Wednesday, 7 January 2009, at 1:12 a.m.
          • Re: RE: DB Monitoring
            Art Kagel -- Wednesday, 7 January 2009, at 9:18 a.m.
  • Re: DB Monitoring
    Art Kagel -- Tuesday, 6 January 2009, at 11:35 a.m.
  • Re: DB Monitoring
    Richard Snoke -- Tuesday, 6 January 2009, at 12:03 p.m.
  • Re: DB Monitoring
    John Miller iii -- Tuesday, 6 January 2009, at 1:37 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.