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.

The values returned for the columns in the view are closely related to the values returned by the Retrieve Journal Information (QjoRetrieveJournalInformation) API and the Work with Journal Attributes (WRKJRNA) CL command.

Authorization: The caller must have:

*EXECUTE authority to the library containing the journal, and
*OBJOPR authority and some data authority other than *EXECUTE to the journal.

The following table describes the columns in the view. The system name is JRN_OBJS. The schema is QSYS2.

Table 1. JOURNALED_OBJECTS view
Column Name	System Column Name	Data Type	Description
JOURNAL_LIBRARY	JRNLIB	VARCHAR(10)	The name of the library that contains the journal.
JOURNAL_NAME	JRNNAME	VARCHAR(10)	The name of the journal.
IASP_NUMBER	IASPNUMBER	INTEGER	The number of the auxiliary storage pool to which storage for the journal is allocated. 1 indicates the system ASP.
IASP_NAME	IASP_NAME	VARCHAR(10)	The device description name of the independent auxiliary storage pool (IASP). The special value of *SYSBAS indicates SYSBASE, which includes the system ASP (ASP 1) and the basic user ASPs (ASPs 2-32).
OBJECT_TYPE	OBJ_TYPE	VARCHAR(7)	Type of object. DIR Directory DTAARA Data area DTAQ Data queue FILE Database file JRNRCV Journal receiver LIB Library STMF Stream file SYMLNK Symbolic link
OBJECT_LIBRARY	OBJ_LIB	VARCHAR(10) Nullable	The name of the library that contains the object. Contains the null value if OBJECT_TYPE is DIR, STMF, or *SYMLNK.
OBJECT_NAME	OBJ_NAME	VARCHAR(10) Nullable	The name of the object. Contains the null value if OBJECT_TYPE is DIR, STMF, or *SYMLNK.
FILE_TYPE	FILE_TYPE	VARCHAR(8) Nullable	The type of file that is journaled. LOGICAL Logical file PHYSICAL Physical file Contains the null value if OBJECT_TYPE is not *FILE.
PATH_NAME	PATH_NAME	DBCLOB(16M) CCSID 1200 Nullable	The path name of an integrated file system object. Contains the null value if OBJECT_TYPE is not DIR, STMF, or *SYMLNK.
FILE_IDENTIFIER	FILE_ID	BINARY(16) Nullable	The identifier associated with the integrated file system object. Contains the null value if OBJECT_TYPE is not DIR, STMF, or *SYMLNK.
JOURNAL_IMAGES	IMAGES	VARCHAR(6) Nullable	Specifies the kinds of images written to the journal for this object. AFTER Only after images are written to the journal. BOTH Both before and after images are written to the journal. Contains the null value if OBJECT_TYPE is *JRNRCV.
OMIT_JOURNAL_ENTRY	OMIT_ENTRY	VARCHAR(10) Nullable	Specifies the journal entries that are omitted. NONE No entries are omitted. OPNCLO Open and close entries are omitted. Open and close operations on the specified file members do not create open and close journal entries. Using this option prevents the use of TOJOBO and TOJOBC entries on the Apply Journaled Changes (APYJRNCHG) and Remove Journaled Changes (RMVJRNCHG) commands, but it saves some storage space in the attached receivers. OPNCLOSYN Open, close, and force entries are omitted. Open, close, and force operations on the specified objects do not generate open, close and force journal entries. Using this option prevents the use of TOJOBO and TOJOBC entries on the Apply Journaled Changes (APYJRNCHG) command, but it saves some storage space in the journal receivers. Contains the null value if OBJECT_TYPE is JRNRCV.
INHERIT	INHERIT	VARCHAR(4) Nullable	Specifies whether new objects created within this journaled directory or library, moved into this journaled directory or library, or restored into this journaled directory or library should inherit the journal state of the parent directory or library. NO New objects will not inherit the journal state of the parent. YES New objects will inherit the journal state of the parent. Contains the null value if OBJECT_TYPE is not DIR or LIB.
REMOTE_JOURNAL_FILTER	RMT_FILTER	VARCHAR(4) Nullable	Specifies whether the journal entries deposited for objects that inherit the journal state of the directory or library are eligible for remote journal filtering by object. NO Journal entries deposited for objects will not be eligible for remote journal filtering by object. YES Journal entries deposited for objects will be eligible for remote journal filtering by object. When using remote journal filtering by object, journal entries for the object will not be sent to the target system. Contains the null value if OBJECT_TYPE is *JRNRCV.

Example

Review all the objects journaled to APPLIB/APPJRN.

SELECT *
  FROM QSYS2.JOURNALED_OBJECTS 
  WHERE OBJECT_LIBRARY = 'APPLIB' AND JOURNAL_NAME = 'APPJRN'
  ORDER BY OBJECT_TYPE, OBJECT_LIBRARY, OBJECT_NAME, PATH_NAME;