469,964 Members | 1,683 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,964 developers. It's quick & easy.

Understanding Navigator output for DB2 i/Series 5r3


I'm using Navigator to review performance monitors for a system under
test and finding the 'statement usage count' confusing.

The column doesn't seem to be a count of the times the statement was
actually executed (as I had thought it would be), nor does it map
clearly to 'steps' in a statement (same statement run once only does
not always produce the same count).

I've had a hunt through the Information Centre manuals and whilst this
column is mentioned a number of times it is usually just to say it
exists or to map it onto QQCNT.

Does anyone know for sure what this column is really telling me or can
they point me at another reference point than Information Centre which
is reliable for this type of information? Without a clear understanding
of where this number comes from I'm not sure if there is a bug in the
reporting or how reliable the output actually is.

i/Series is not my home platform so if I'm missing something obvious
please tell me - there seems to be a lot less informal discussion/web
resources about this platform than *nix or z/os!

Dec 22 '06 #1
0 950

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.