IBM Support

How to Query the MSF Journal to Find Specific Entries

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)

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

Document Information

Modified date:
22 June 2022

UID

nas8N1012063