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

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