On Mon, 31 December 2001, Jim.Nelson@RCIS-NET.COM wrote:

> Oops.  Didn't mean to imply it was the STRDBG command - forget the name, but
> there is a performance monitoring tool that logs, in great detail, the
> QZDASOINIT jobs.  This showed each statement, and how long it took to
> complete it.

I suspect you used STRDBMON (Start Database Monitor), a very handy tool.

But note that this can only report on the AS/400 side and really only for the 
actual database part. If, for example, the initial request was passed through 
the Jet engine on a Windows client, or if you have exit programs monitoring 
server requests, or if a number of other possibilities exist, you might see 
only a part of the cost of accessing that database.

Tom Liotta

Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788
Fax  253-872-7904

The ALL NEW CS2000 from CompuServe
 Better!  Faster! More Powerful!
 250 FREE hours! Sign-on Now!

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.