Troubleshooting
Problem
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(QGPL/EMAIL2) OUTMBR(EMAIL2) ENTDTALEN(512)
DSPJRN JRN(QZMF) OUTPUT(*OUTFILE) OUTFILE(QGPL/EMAIL2) OUTMBR(EMAIL2) ENTDTALEN(512)
STRSQL
SELECT * FROM QGPL/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 IBM Documentation link at the following URL:
https://www.ibm.com/docs/en/i/7.1?topic=information-mail-server-journal-entries
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHfAAM","label":"Email and SMTP"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]
Historical Number
570934043
Was this topic helpful?
Document Information
Modified date:
22 June 2022
UID
nas8N1012063