This document describes how to use SQL to query the QZMF journal.
Resolving The Problem
When viewing the QZMF journal with many entries, it can be difficult to know what each item translates to, and it can be a long process if there are numerous entries. To work around this, you should dump the journal to an outfile and then run an SQL query over the file.
DSPJRN JRN(QZMF) OUTPUT(*OUTFILE) OUTFILE(KSWAN/EMAIL2) OUTMBR(EMAIL2) ENTDTALEN(512)
SELECT * FROM KSWAN/EMAIL2 WHERE JOENTT = 'LG' and JOESD like '%88 DLV%'
In this example, the LG is the 'type' and the 88 is the 'sub type' for the MSF journal entry.
Here is another query to display all 88 and 82 successful sub type entries for the SMTP Client for a specific date and time range.
SELECT * FROM LIBRARY/FILE WHERE
JOENTT = 'LG' AND
JODATE > 'MMDDYY' AND
JOTIME > 'HHMMSS' AND
(JOESD LIKE '%88 D%' OR JOESD LIKE '%82 R%')
ORDER BY JOSEQN
For details of the MSF journal entry and types, you should refer to the InfoCenter link at the following URL:
Internal Use Only
17 June 2018