RE: STRDBMON

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Cool, Sudha

Actually, the site <http://www-1.ibm.com/servers/eserver/iseries/perfmgmt>
has lots of good performance stuff for iSeries. The white paper is listed
in the Resources ares.

Vern

At 12:07 PM 11/7/2002 -0600, you wrote:
> This is really good Vern.  (I found your company name as well.) Thanks!
> Sudha
>
> -----Original Message-----
> From: Vern Hamberg [mailto:vhamberg@centerfieldtechnology.com]
> Sent: Thursday, November 07, 2002 11:05 AM
> To: midrange-l@midrange.com
> Subject: Re: STRDBMON
>
> Sudha
>
> There's a white paper on this
> <http://www-1.ibm.com/servers/eserver/iseries/perfmgmt/pdf/dbmonitor.pdf>
> "Using AS/400 Database Monitor To Identify and Tune SQL Queries". It even
> mentions our company as one that makes tools to analyze this data.
>
> DBMON data is really messy. It has multiple record types in a single file,
> and each type uses different fields from the record. There is a unique id
> field, that links multiple record types for a given operation.
>
> The white paper is excellent. You should also look at Appendix A of the
> manual
> <http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzajq/rzajqmst.pdf>
> "Database Performance and Query Optimization"