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(KSWAN/EMAIL2) OUTMBR(EMAIL2) ENTDTALEN(512)
STRSQL
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:

http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_61/rzair/rzairjournal.htm
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/rzair/rzairjournal.htm
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzair/rzairjournal.htm
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rzair/rzairjournal.htm

Internal Use Only

I5/OS (5761SS1TC)

[{"Product":{"code":"SGYQGH","label":"IBM i"},"Business Unit":{"code":"BU009","label":"Systems - Server"},"Component":"Communications-TCP","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3;7.2.0;7.2;7.1.0;7.1;6.1.1;6.1.0;6.1;5.4.5;5.4.0","Edition":""},{"Product":{"code":"SSC5L9","label":"IBM i 7.2"},"Business Unit":{"code":"BU009","label":"Systems - Server"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":""},{"Product":{"code":"SSC52E","label":"IBM i 7.1"},"Business Unit":{"code":"BU009","label":"Systems - Server"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":""},{"Product":{"code":"SSC3X7","label":"IBM i 6.1"},"Business Unit":{"code":"BU009","label":"Systems - Server"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":""},{"Product":{"code":"SSTS2D","label":"IBM i 7.3"},"Business Unit":{"code":"BU009","label":"Systems - Server"},"Component":" ","Platform":[{"code":"","label":null}],"Version":"","Edition":""}]

Historical Number

570934043

Document Information

Modified date:
17 June 2018

UID

nas8N1012063