JOURNAL_INFO view

The JOURNAL_INFO view contains information about journals, including remote journals.

The values returned for the columns in the view are closely related to the values returned by the Retrieve Journal Information (QJORJRNI) API. Refer to the API for more detailed information.

Authorization: The caller must have:
  • *EXECUTE authority to 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 JRNINFO. The schema is QSYS2.

Table 1. JOURNAL_INFO view
Column Name System Column Name Data Type Description
JOURNAL_NAME JRNNAME VARCHAR(10) The name of the journal.
JOURNAL_LIBRARY SYS_DNAME VARCHAR(10) The name of the library that contains the journal.
ASP_NUMBER ASPNUMBER INTEGER The number of the auxiliary storage pool to which storage for the journal is allocated.
JOURNAL_ASPGRP JRNASPGRP VARCHAR(10) The name of the auxiliary storage pool (ASP) in which the journal resides. A value of *SYSBAS indicates the system ASP and all basic user ASPs.
ATTACHED_JOURNAL_RECEIVER_NAME ATTRCVNAME VARCHAR(10)
Nullable
The name of the journal receiver that is currently attached to this journal.

Contains the null value when there is no attached receiver.

ATTACHED_JOURNAL_RECEIVER_LIBRARY ATTRCVLIB VARCHAR(10)
Nullable
The name of the library that contains the attached journal receiver.

Contains the null value when there is no attached receiver.

MESSAGE_QUEUE MSGQNAME VARCHAR(10) The name of the message queue that is associated with this journal.
MESSAGE_QUEUE_LIBRARY MSGQLIB VARCHAR(10) The name of the library that contains the message queue.
DELETE_RECEIVER_OPTION DLTRCVOPT VARCHAR(3) Indicates whether the system deletes detached journal receivers that are associated with this journal when they are no longer needed for IPL or IASP vary on recovery.
NO
Detached journal receivers that are associated with this journal are not deleted when they are no longer needed for IPL or IASP vary on recovery.
YES
Detached journal receivers that are associated with this journal are deleted when they are no longer needed for IPL or IASP vary on recovery.
DELETE_RECEIVER_DELAY DLTRCVDLY INTEGER
Nullable
The delay time (in minutes) between attempts to delete journal receivers associated with this journal.

Contains the null value when DELETE_RECEIVER_OPTION is NO.

JOURNAL_TYPE TYPE VARCHAR(10) The scope of the journal and some of its characteristics.
*LOCAL
This is a local journal.
*REMOTE
This is a remote journal.
JOURNAL_STATE STATE VARCHAR(10) An indication as to whether journal entries are currently being sent to a journal. For a remote journal, this is whether the journal is actively receiving journal entries from the source system journal.
*ACTIVE
If this is a local journal, this means journal entries can be deposited to this journal. If this is a remote journal, this means journal entries can be received from a source journal.
*CTLINACT
The remote journal is in the process of a controlled inactivate.
*FAILED
If this is a remote journal, this means journal entries cannot be received from a source journal due to a remote journal function failure. Does not apply to local journals.
*INACTIVE
If this is a remote journal, this means journal entries cannot be received from a source journal.
*INACTPEND
If this is a remote journal, this means a request is being processed to set the journal state to *INACTIVE. Does not apply to local journals.
*PENDING
The remote journal is transitioning from an *INACTIVE state to an *ACTIVE state.
*STANDBY
If this is a local journal, this means that most journal entries are not deposited into the journal and there will be no errors indicating that the entry was not deposited. Does not apply to remote journals.
NUMBER_JOURNAL_RECEIVERS NUMJRNRCV INTEGER The total number of journal receivers that are associated with the journal.
TOTAL_SIZE_JOURNAL_RECEIVERS SIZJRNRCV BIGINT The total size of the journal receivers (in kilobytes) associated with the journal.
NUMBER_REMOTE_JOURNALS RMTJRNS INTEGER The total number of remote journals that are directly downstream of this journal.
REDIRECTED_RECEIVER_LIBRARY RDRRCVLIB VARCHAR(10)
Nullable
For a local or *TYPE1 remote journal, the redirected receiver library name that is currently in place on this journal's local journal for any downstream journal receivers associated with *TYPE1 remote journals.

Contains *NONE if no *TYPE1 remote journals have been added or if no receiver library redirection was specified when *TYPE1 remote journals were added.

Contains the redirected receiver library name that is currently in place on this remote journal if the specified journal is a *TYPE2 remote journal.

Contains the null value if no *TYPE1 remote journals have been added.

MAXIMUM_REMOTE_JOURNALS_
  ENTRIES_BEHIND
MAXRMTENTB INTEGER
Nullable
The maximum number of entries that are waiting to be sent to the target system for any remote journal.

Contains the null value if NUMBER_REMOTE_JOURNALS is 0 or if no attached remote journals are active with async delivery mode.

MAXIMUM_REMOTE_JOURNALS_
  TIME_BEHIND
MAXRMTSECB BIGINT
Nullable
The maximum value (in hundredths of seconds) that the source journal is behind in sending journal entries to the target system for any remote journal.

Contains the null value if NUMBER_REMOTE_JOURNALS is 0 or if no attached remote journals are active with async delivery mode.

MAXIMUM_REMOTE_JOURNALS_
  RETRANSMISSIONS
MAXRMTRETR BIGINT
Nullable
The maximum value for any remote journal of the total number of times the local system retransmitted a segment because an acknowledgement was not received.

Contains the null value if NUMBER_REMOTE_JOURNALS is 0 or if no attached remote journals are active using TCP/IP.

JOURNAL_TEXT TEXT VARCHAR(50)
Nullable
The text description of the journal.

Contains the null value if the journal has no text.

MANAGE_RECEIVER_OPTION MNGRCVOPT VARCHAR(10)
Nullable
Indicates whether the system or user manages the changing of journal receivers.
*SYSTEM
The system manages the changing of journal receivers.
*USER
The user manages the changing of journal receivers.

Contains the null value for a remote journal.

MANAGE_RECEIVER_DELAY MNGRCVDLY INTEGER
Nullable
The delay time (in minutes) between attempts to attach new journal receivers to this journal.

Contains the null value when MANAGE_RECEIVER_OPTION is *USER or the null value.

REMOVE_INTERNAL_ENTRIES RMVINTENT VARCHAR(3)
Nullable
Handling of internal system entries.
NO
The internal system entries are not removed.
YES
The size of the attached receivers is reduced by automatic removal of the internal system entries.

Contains the null value for a remote journal.

REMOVE_FIXED_LENGTH_DETAIL MINFIXLEN VARCHAR(3)
Nullable
Handling of fixed length details.
NO
Fixed length data is not removed.
YES
The size of the journal entries that are deposited into the attached journal receivers is reduced by the automatic removal of all fixed length data such as job name, machine sequence number, and so on.

Contains the null value for a remote journal.

RECEIVER_MAXIMUM_SIZE MAXOPT VARCHAR(10)
Nullable
The receiver size option that applies to this journal receiver.
*MAXOPT1
The journal receivers attached to the journal can have a maximum receiver size of approximately one terabyte (1,099,511,627,776 bytes) and a maximum sequence number of 9,999,999,999. Additionally, the maximum size of the journal entry that can be deposited is 15,761,440 bytes.
*MAXOPT2
The journal receivers attached to the journal can have a maximum receiver size of approximately one terabyte (1,099,511,627,776 bytes) and a maximum sequence number of 9,999,999,999. Additionally, the maximum size of the journal entry which can be deposited is 4,000,000,000 bytes.
*MAXOPT3
The journal receivers attached to the journal can have a maximum receiver size of approximately one terabyte (1,099,511,627,776 bytes) and a maximum sequence number of 18,446,744,073,709,551,600. Additionally, the maximum size of the journal entry which can be deposited is 4,000,000,000 bytes.
*NONE
The journal receivers attached to the journal can have a maximum journal receiver size of approximately 1.9 gigabytes and a maximum sequence number of 2,147,483,136.

Contains the null value for a remote journal.

MINIMIZE_ESD_FOR_DATA_AREAS MINDTAARA VARCHAR(3)
Nullable
Indicates whether journal entries for data areas may have minimized entry specific data.
NO
Journal entries for data areas do not have minimized entry specific data.
YES
Journal entries for data areas have minimized entry specific data.

Contains the null value for a remote journal.

MINIMIZE_ESD_FOR_FILES MINFILE VARCHAR(19)
Nullable
Indicates whether journal entries for files may have minimized entry specific data.
MINIMIZED
Journal entries for files may have minimized entry specific data. The minimizing does not occur on field boundaries. Therefore, the entry specific data may not be viewable and may not be used for auditing purposes.
MINIMIZED FOR AUDIT
Journal entries for files may have minimized entry specific data. The minimizing occurs on field boundaries. Therefore, the entry specific data will be viewable and may be used for auditing purposes.
NO
Journal entries for files will have complete entry specific data.

Contains the null value for a remote journal.

JOURNAL_CACHE JRNCACHE VARCHAR(3)
Nullable
Specifies whether journal entries are cached before being written out to disk.
NO
Journal entries are not cached before being written out to disk.
YES
Journal entries are cached before being written out to disk.

Contains the null value for a remote journal.

FIXED_LENGTH_DATA_INCLUDES_
JOB_NAME
FLDJOB VARCHAR(3)
Nullable
Indicates whether the job name will be stored when journal entries are deposited.
NO
The job name will not be stored when journal entries are deposited.
YES
The job name will be stored when journal entries are deposited.

Contains the null value for a remote journal.

FIXED_LENGTH_DATA_INCLUDES_
  USER_NAME
FLDUSR VARCHAR(3)
Nullable
Indicates whether the user name will be stored when journal entries are deposited.
NO
The user name will not be stored when journal entries are deposited.
YES
The user name will be stored when journal entries are deposited.

Contains the null value for a remote journal.

FIXED_LENGTH_DATA_INCLUDES_
  PROGRAM_NAME
FLDPGM VARCHAR(3)
Nullable
Indicates whether the program name will be stored when journal entries are deposited.
NO
The program name will not be stored when journal entries are deposited.
YES
The program name will be stored when journal entries are deposited.

Contains the null value for a remote journal.

FIXED_LENGTH_DATA_INCLUDES_
  PROGRAM_LIBRARY
FLDPGMLIB VARCHAR(3)
Nullable
Indicates whether the program library name will be stored when journal entries are deposited.
NO
The program library name will not be stored when journal entries are deposited.
YES
The program library name will be stored when journal entries are deposited.

Contains the null value for a remote journal.

FIXED_LENGTH_DATA_INCLUDES_
  SYSTEM_SEQUENCE_NUMBER
FLDSYSSEQ VARCHAR(3)
Nullable
Indicates whether the system sequence number will be stored when journal entries are deposited.
NO
The system sequence number will not be stored when journal entries are deposited.
YES
The system sequence number will be stored when journal entries are deposited.

Contains the null value for a remote journal.

FIXED_LENGTH_DATA_INCLUDES_
  REMOTE_ADDRESS
FLDRMTADR VARCHAR(3)
Nullable
Indicates whether the remote address will be stored when journal entries are deposited.
NO
The remote address will not be stored when journal entries are deposited.
YES
The remote address will be stored when journal entries are deposited.

Contains the null value for a remote journal.

FIXED_LENGTH_DATA_INCLUDES_
  THREAD_ID
FLDTHD VARCHAR(3)
Nullable
Indicates whether the thread identifier will be stored when journal entries are deposited.
NO
The thread identifier will not be stored when journal entries are deposited.
YES
The thread identifier will be stored when journal entries are deposited.

Contains the null value for a remote journal.

FIXED_LENGTH_DATA_INCLUDES_
  LOGICAL_UNIT_OF_WORK_ID
FLDLUW VARCHAR(3)
Nullable
Indicates whether the logical unit of work identifier will be stored when journal entries are deposited.
NO
The logical unit of work identifier will not be stored when journal entries are deposited.
YES
The logical unit of work identifier will be stored when journal entries are deposited.

Contains the null value for a remote journal.

FIXED_LENGTH_DATA_INCLUDES_
  TRANSACTION_ID
FLDXID VARCHAR(3)
Nullable
Indicates whether the transaction identifier will be stored when journal entries are deposited.
NO
The transaction identifier will not be stored when journal entries are deposited.
YES
The transaction identifier will be stored when journal entries are deposited.

Contains the null value for a remote journal.

JOURNALED_OBJECT_LIMIT JRNOBJLMT VARCHAR(10)
Nullable
The number of objects that can be journaled to the journal.
*MAX250K
The maximum number of objects that can be journaled to the journal is 250,000.
*MAX10M
The maximum number of objects that can be journaled to the journal is 10,000,000.

Contains the null value for a remote journal.

JOURNALED_OBJECTS JRNALL INTEGER
Nullable
Total of all objects journaled to the journal. This count includes explicitly journaled objects such as files, file members, access paths, data areas, data queues, libraries, and integrated file system objects. This count also includes implicitly journaled objects such as journal receivers, commitment definitions, and objects journaled for system recovery purposes.

Contains the null value for a remote journal.

JOURNALED_FILES JRNFILE INTEGER
Nullable
The total number of files that are currently being journaled to this journal.

Contains the null value for a remote journal.

JOURNALED_MEMBERS JRNMBR INTEGER
Nullable
The total number of file members that are currently being journaled to this journal.

Contains the null value for a remote journal.

JOURNALED_DATA_AREAS JRNDTAARA INTEGER
Nullable
The total number of data areas that are currently being journaled to this journal.

Contains the null value for a remote journal.

JOURNALED_DATA_QUEUES JRNDTAQ INTEGER
Nullable
The total number of data queues that are currently being journaled to this journal.

Contains the null value for a remote journal.

JOURNALED_IFS_OBJECTS JRNIFS INTEGER
Nullable
The total number of integrated file system objects of type *DIR, *STMF, and *SYMLNK that are currently being journaled to this journal.

Contains the null value for a remote journal.

JOURNALED_ACCESS_PATHS JRNAP INTEGER
Nullable
The total number of access paths that are currently being journaled to this journal.

Contains the null value for a remote journal.

JOURNALED_COMMITMENT_DEFINITIONS JRNCMTDFN INTEGER
Nullable
The total number of commitment definitions that are currently being implicitly journaled to this journal.

Contains the null value for a remote journal.

JOURNALED_LIBRARIES JRNLIB INTEGER
Nullable
The total number of libraries that are currently being journaled to this journal.

Contains the null value for a remote journal.

JOURNAL_RECOVERY_COUNT JRNRCYCNT INTEGER
Nullable
The approximate number of journaled changes that would need to be recovered during journal synchronization for this journal in the event of an abnormal IPL or vary on.

Contains the null value for a local journal with the value *SYSDFT or for a remote journal.

REMOTE_JOURNAL_TYPE RMTJRNTYPE VARCHAR(10)
Nullable
The type of remote journal. Values are *TYPE1 and *TYPE2.

Contains the null value for a local journal.

JOURNAL_DELIVERY_MODE DELIVMODE VARCHAR(10)
Nullable
The journal delivery mode that is being used to replicate journal entries to this journal.
*ASYNC
Journal entries are being delivered or replicated asynchronously.
*ASYNCPEND
Journal entries are to be delivered or replicated asynchronously, but the journal is currently in catch-up mode.
*SYNC
Journal entries are being delivered or replicated synchronously.
*SYNCPEND
Journal entries are to be delivered or replicated synchronously, but the journal is currently in catch-up mode.

Contains the null value for a local journal or a remote journal whose JOURNAL_STATE field is not *ACTIVE or *CTLINACT.

LOCAL_JOURNAL_NAME LCLJRNNAME VARCHAR(10)
Nullable
The journal name of the local journal. The local journal is the journal that is the initiator of the original journal deposit that has been replicated downstream to this journal.

Contains the null value for a local journal.

LOCAL_JOURNAL_LIBRARY LCLJRNLIB VARCHAR(10)
Nullable
The library name of the local journal.

Contains the null value for a local journal.

LOCAL_JOURNAL_SYSTEM LCLJRNSYS VARCHAR(8)
Nullable
The name of the system for the local journal.

Contains *UNKNOWN if journal is a remote journal and does not have an attached receiver.

Contains the null value for a local journal.

LOCAL_JOURNAL_ASPGRP LCLASPGRP VARCHAR(10)
Nullable
The name of the independent auxiliary storage pool (ASP) group of the local journal. *SYSBAS is used to indicate the system ASP and all basic user ASPs.

Contains *UNKNOWN if journal is a remote journal and does not have an attached receiver.

Contains the null value for a local journal.

SOURCE_JOURNAL_NAME SRCJRNNAME VARCHAR(10)
Nullable
The journal name of the source journal. The source journal is the journal that is directly upstream of this journal.

Contains *UNKNOWN if journal is a remote journal and does not have an attached receiver.

Contains the null value for a local journal.

SOURCE_JOURNAL_LIBRARY SRCJRNLIB VARCHAR(10)
Nullable
The library name of the source journal.

Contains *UNKNOWN if journal is a remote journal and does not have an attached receiver.

Contains the null value for a local journal.

SOURCE_JOURNAL_SYSTEM SRCJRNSYS VARCHAR(8)
Nullable
The name of the system for the source journal.

Contains *UNKNOWN if journal is a remote journal and does not have an attached receiver.

Contains the null value for a local journal.

SOURCE_JOURNAL_ASPGRP SRCASPGRP VARCHAR(10)
Nullable
The name of the independent auxiliary storage pool (ASP) group of the source journal.

Contains *UNKNOWN if journal is a remote journal and does not have an attached receiver.

Contains the null value for a local journal.

LOCAL_RECEIVER_SYSTEM LCLRCVSYS VARCHAR(8)
Nullable
If this journal receiver is associated with a remote journal, the name of the system for the local journal.

Contains *UNKNOWN if journal is a remote journal and does not have an attached receiver.

Contains the null value for a local journal.

SOURCE_RECEIVER_SYSTEM SRCRCVSYS VARCHAR(8)
Nullable
If this journal receiver is associated with a remote journal, the name of the system for the source journal.

Contains *UNKNOWN if journal is a remote journal and does not have an attached receiver.

Contains the null value for a local journal.

ACTIVATION_TIME ACTDT TIMESTAMP
Nullable
If the journal is a remote journal and it is currently active, the date and time the journal was activated.

Contains the null value for a local journal or a remote journal whose JOURNAL_STATE field is not *ACTIVE or *CTLINACT.

ESTIMATED_TIME_BEHIND ESTBEHIND BIGINT
Nullable
If the journal is an active remote journal and the delivery mode is asynchronous, this is the estimated amount of time, in milliseconds, between when the journal entries are written to disk on the source system and when they are received on the target system.

Contains the null value for a local journal or a remote journal whose JOURNAL_STATE field is not *ACTIVE or *CTLINACT.

MAXIMUM_TIME_BEHIND MAXBEHIND BIGINT
Nullable
The maximum value of ESTIMATED_TIME_BEHIND since the journal was activated.

Contains the null value for a local journal or a remote journal whose JOURNAL_STATE field is not *ACTIVE or *CTLINACT.

MAXIMUM_BEHIND_TIMESTAMP MAXBHNDTIM TIMESTAMP
Nullable
The date and time that the ESTIMATED_TIME_BEHIND occurred.

Contains the null value for a local journal or a remote journal whose JOURNAL_STATE field is not *ACTIVE or *CTLINACT.

JOURNAL_ENTRY_FILTERING FILTER VARCHAR(3)
Nullable
Indicates whether or not journal entry filtering is active for this journal.
NO
Journal entry filtering is not active for this journal.
YES
Journal entry filtering is active for this journal.

Contains the null value for a local journal or a remote journal whose JOURNAL_STATE field is not *ACTIVE or *CTLINACT.

Examples

  • List all journals that are falling behind sending entries to one or more remote journals:
    SELECT JOURNAL_NAME, JOURNAL_LIBRARY, 
         MAXIMUM_REMOTE_JOURNALS_ENTRIES_BEHIND, 
         MAXIMUM_REMOTE_JOURNALS_TIME_BEHIND, MAXIMUM_REMOTE_JOURNALS_RETRANSMISSIONS 
            FROM QSYS2.JOURNAL_INFO
            WHERE MAXIMUM_REMOTE_JOURNALS_ENTRIES_BEHIND > 0 
            ORDER BY MAXIMUM_REMOTE_JOURNALS_ENTRIES_BEHIND DESC
  • Find any remote journals that are not currently active:
    SELECT * FROM QSYS2.JOURNAL_INFO 
             WHERE JOURNAL_TYPE = '*REMOTE' 
                 AND JOURNAL_STATE <> '*ACTIVE'
             ORDER BY JOURNAL_LIBRARY, JOURNAL_NAME,
  • For security auditing reasons, find any journals that are not recording remote address info:
    SELECT * FROM QSYS2.JOURNAL_INFO 
             WHERE REMOVE_FIXED_LENGTH_DETAIL = 'YES' 
                 OR FIXED_LENGTH_DATA_INCLUDES_REMOTE_ADDRESS = 'NO'