IBM Support

QSYS2.MIRROR_DISPLAY_JOURNAL()

News


Abstract

The MIRROR_DISPLAY_JOURNAL table function formats Db2 Mirror specific audit journal entries as well as returning typical audit journal information.

Content


For complete details, view the IBM Documentation page: MIRROR_DISPLAY_JOURNAL table function.
 

Enhanced with IBM i 7.5 - [SF99951 Level 5 and SF99950 Level 5] & IBM i 7.4 - [SF99668 Level 23 and SF99704 Level 26]

  • MIRROR_DISPLAY_JOURNAL table function is enhanced to return a longer (e.g. VARCHAR(200)) result for both the ACTION and REASON columns to better align with the Db2 Mirror audit journal entry services.

Enhanced with IBM i 7.5 - [SF99951 Level 4 and SF99950 Level 4] & IBM i 7.4 - [SF99668 Level 22 and SF99704 Level 25]

  • MIRROR_DISPLAY_JOURNAL table function is enhanced to accept either STARTING_DATE and ENDING_DATE optional parameters or STARTING_TIMESTAMP and ENDING_TIMESTAMP optional parameters, to better align with the Db2 Mirror audit journal entry services.

Enhanced with IBM i 7.5 - [SF99951 Level 3 and SF99950 Level 3] & IBM i 7.4 - [SF99668 Level 21 and SF99704 Level 23]

  • MIRROR_DISPLAY_JOURNAL table function is enhanced with improved formatting of some of the content shown in the ACTION and DETAIL columns, to better align with the Db2 Mirror audit journal entry services.

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SSLLPF","label":"IBM Db2 Mirror for i"},"ARM Category":[{"code":"a8m0z0000001hExAAI","label":"DB2 Mirror"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;and future releases"},{"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":"a8m0z0000001hExAAI","label":"DB2 Mirror"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;and future releases"}]

Document Information

Modified date:
08 April 2025

UID

ibm16829479