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/
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.