RE: - the simple query on the 400: SUBJECT CHANGE to SQL Server f aster

[thomas@xxxxxxxxxxx]

Jim:

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
http://www.400Security.com


___________________________________________________
The ALL NEW CS2000 from CompuServe
 Better!  Faster! More Powerful!
 250 FREE hours! Sign-on Now!
 http://www.compuserve.com/trycsrv/cs2000/webmail/