Start of change

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 on the library containing the journal, and
  • *OBJOPR 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.
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;
End of change