Re: Database monitor (V7R2) 5005 entries: meaning and QQ1000L

Many thanks for your input Vern and Timothy.

Timothy, I can't use the nice ACS screens, unfortunately, because the name
of the Query being run is not logged anywhere in the Database Monitor, so I
am having to use various bits of locally meaningful SQL to match monitor
output against specific Queries. I don't suppose there is any way of easily
identifying the SQL for a specific panel (like you can in the Performance
navigation screens in iNav)? That would be really useful.
(I have given up on the 5005 entries for now!)

Anyway I've now got a bit further.
Am I right Vern (I think this was your point?) that Query Sort processing
has no specific information logged in the DBMON output, and is effectively
entirely unpredictable in its results?
This is absolutely what I am finding - everything else seems predictable.
In particular, if there are no sort fields at all and the optimisation
matches across SQE and CQE, then the output seems to match every time. The
only exception to this relates to the handling of Report Breaks where there
are no sort fields (it is clear that SQL GROUP type processing is not being
used, either in SQE or in CQE).

Finally, another question (sorry): what is the 'proper' way of identifying
SQE vs CQE in the DBMON output? I am using QQSMINTF/Plan_Iteration_Number,
treating null as CQE and everything else as SQE - this seems to work, but am
I missing a more formal/accurate method? Not all the record types include
the query options library name, or I'd use that.

Many thanks
Mandy