Journal Services

These services provide information about audit journals and data journals.

ASSOCIATE_JOURNAL_RECEIVER table function
The ASSOCIATE_JOURNAL_RECEIVER table function associates one or more journal receivers with a journal if the journal receiver was originally associated with the journal.
Audit journal entry services
These table functions provide detailed information for audit journal entries.
DISPLAY_JOURNAL table function
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.
JOURNAL_INFO view
The JOURNAL_INFO view contains information about journals, including remote journals.
JOURNAL_RECEIVER_INFO view
The JOURNAL_RECEIVER_INFO view contains information about all journal receivers on the system.
JOURNALED_OBJECTS view
The JOURNALED_OBJECTS view returns information about journaled objects. Only information about external objects is returned. Internal objects such as commit blocks and access paths are not included.
REMOTE_JOURNAL_INFO view
The REMOTE_JOURNAL_INFO view returns information about every remote journal defined for a local or remote journal on the IBM® i where this view is referenced. The remote journals returned by this service exist on a different IBM i, as noted by the remote database (RDB) name.
SMAPP_ACCESS_PATHS view
The SMAPP_ACCESS_PATHS view returns a list of access paths which are monitored by System-Managed Access Path Protection (SMAPP).

Parent topic: IBM i Services