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

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Mandy

As to different order of results, if you do not use an ORDER BY, it can 
be different every time, it doesn't matter whether you are using CQE or 
SQE. There is nothing we can do to affect that ordering that I know of.

Cheers
Vern

On 5/2/2021 7:44 AM, mandy.shaw@xxxxxxxxxxxxxxxx wrote:
> Hi
>
>   
>
> I am working on moving a set of Queries off CQE onto SQE.
>
> When running them with SQE on V7R2 I am encountering 5005 records in the
> database monitor output with what is clearly interesting information in the
> QQ1000L column.
>
>   
>
> Example:
>
> 1000      QUERY/400 MYLIB/MYTBL1.MYTBL1, MYLIB/MYTBL2.MYTBL2
>
> 5005
> 14.6.14.15.10.11.1.14.0.15.1.26.25.5:MYLIB/MYTBL2.MYLIB/MYTBL1.MYLIB/MYINDEX
>
> (MYINDEX is scoped over MYTBL2)
>
>   
>
> Does anyone know what the numeric codes on the front mean?
>
> I cannot find any documentation of this information (or even of the purpose
> of the 5005 record) anywhere at all on the web.
>
>   
>
> I am getting some differences in Query output order between CQE and SQE
> where there is no index usage logged in the database monitor at all, and
> where the other database monitor information logged effectively matches
> across CQE and SQE.
>
> This puzzles me, and I suspect that these 5005 entries might shed some light
> if I could only decode them.
>
>   
>
> Thanks
>
> Mandy Shaw