IBM Support

QSYS2.DISPLAY_JOURNAL()

News


Abstract

The DISPLAY_JOURNAL table function returns information about journal entries. It returns information similar to what is returned by the Display Journal (DSPJRN) CL command and the Retrieve Journal Entries (QjoRetrieveJournalEntries) API.

Content

Note: Querying this function at a sub-second rate could have disruptive performance impacts.
 
For complete detail, visit this IBM Documentation age: DISPLAY_JOURNAL table function

Enhanced with IBM i 7.5 SF99750 Level 5 and IBM i 7.4 SF99704 Level 26:

  • Add COMMIT_CYCLE and INCLUDE_INTERNAL input parameters

Enhanced with IBM i 7.4 SF99704 Level 15 and IBM i 7.3 SF99703 Level 26:

  • Add the USER_NAME column as an alternative to the "CURRENT_USER" column
  • Add the special value *CURSEQCHN to the STARTING_RECEIVER_NAME input parameter

Enhanced with IBM i 7.4 SF99704 Level 13 and IBM i 7.3 SF99703 Level 24:

  • Syslog generated detail enhanced for audit journal types: CP, CY, ZR, and ZC

Enhanced with IBM i 7.4 SF99704 Level 10 and IBM i 7.3 SF99703 Level 22:

  • The OBJECT_NAME optional parameter for filtering is extended from a single object name to up to 300 object names
  • Remaining (46) audit journal entry types generated in Syslog format (100% coverage of Audit Journal entries)
  • Syslog format is returned for Journal Code U - User-Generated Entries
  • The JOB input parameter is enhanced to accept 'job-number/job-user/job-name' style.

Enhanced with IBM i 7.4 SF99704 Level 7 and IBM i 7.3 SF99703 Level 18

  • 22 additional audit journal entry types generated in Syslog format

Enhanced with IBM i 7.3 SF99703 Level 7 and IBM i 7.2 SF99702 Level 19

  • Callers can optionally direct Db2 for i to generate the result data in Syslog format

Enhanced with IBM i 7.3 SF99703 Level 3 and IBM i 7.2 SF99702 Level 14

  • RCAC and Field procedures are applied when querying DISPLAY_JOURNAL and the related file has active RCAC or Field procedures.

Enhanced with IBM i 7.3 and IBM i 7.2 SF99702 Level 11

  • New optional input parameters are added to control the ending point for a journal query.

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"6.1.0;and future releases"}]

Document Information

Modified date:
25 March 2025

UID

ibm11136710

Page Feedback