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

Hi Mandy,

You will not find documentation for the 500x monitor records because those
are internal-use records generated only for IBM tooling. The supported way
to access and interpret the information is to use the ACS SQL Performance
Center to view the statements in the monitor file. This should show you
how the index is being used in your queries. (There should also be a 3001
record that corresponds to the index usage, which will also provide a lot
of information.)

Hope that helps,

Tim Clark
Dept 45X - DB2 for IBM i / SQL Optimizer

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 05/02/2021
07:44:42 AM:

From: <mandy.shaw@xxxxxxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxxxxxxxx>,
Date: 05/02/2021 07:53 AM
Subject: [EXTERNAL] Database monitor (V7R2) 5005 entries: meaning
and QQ1000L content
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: INVALID URI REMOVED

u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-

siA1ZOg&r=oCmVbiwufH6yM8U29GriOcB5LKDoEG8y1HZD-01RVtc&m=5GR5dV_nDhqYP-

zNR_h-4t08Cal40hlH_8XHiRRxoPw&s=VPwd6-SubBxe_Mo7B8KJoFO0Eyl_PNYBDD19Cy4bpbI&e=

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at INVALID URI REMOVED
u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-
siA1ZOg&r=oCmVbiwufH6yM8U29GriOcB5LKDoEG8y1HZD-01RVtc&m=5GR5dV_nDhqYP-

zNR_h-4t08Cal40hlH_8XHiRRxoPw&s=f9YfoxQnBZDScHkOPAwy0q-7egAQwcmGw02LGGXYRGU&e=

.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link:

INVALID URI REMOVED
u=https-3A__amazon.midrange.com&d=DwICAg&c=jf_iaSHvJObTbx-
siA1ZOg&r=oCmVbiwufH6yM8U29GriOcB5LKDoEG8y1HZD-01RVtc&m=5GR5dV_nDhqYP-

zNR_h-4t08Cal40hlH_8XHiRRxoPw&s=soeLBjZ_1OwX7AX8anRw7zcl-gjBqZ0pL4MtcOdeI-Y&e=