Start of change

JOURNAL_RECEIVER_INFO view

The JOURNAL_RECEIVER_INFO view contains information about all journal receivers on the system.

The values returned for the columns in the view are closely related to the values returned by the Retrieve Journal Receiver Information (QjoRtvJrnReceiverInformation) API.

Authorization: The caller must have:
  • *EXECUTE authority to the library containing the journal receiver, and
  • *OBJOPR authority and some data authority other than *EXECUTE to the journal receiver.
If the journal receiver is associated with a journal, the caller must have:
  • *EXECUTE authority to the library containing the journal, and
  • *OBJOPR authority to the journal.

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

Table 1. JOURNAL_RECEIVER_INFO view

Column Name
System Column Name Data Type Description
JOURNAL_RECEIVER_LIBRARY JRNRCV_LIB VARCHAR(10) The name of the library that contains the journal receiver.
JOURNAL_RECEIVER_NAME JRNRCV VARCHAR(10) The name of the journal receiver.
DESCRIPTIVE_TEXT TEXT
VARCHAR(50)
Nullable
The text description of the journal receiver.
JOURNAL_RECEIVER_ASP_NUMBER RCV_ASPNUM INTEGER The number of the auxiliary storage pool to which storage for the journal receiver is allocated.
JOURNAL_RECEIVER_ASP_NAME RCV_ASPNAM VARCHAR(10) The name of the auxiliary storage pool (ASP) in which the journal receiver resides. A value of *SYSBAS indicates the system ASP or a basic user ASP.
JOURNAL_LIBRARY JRN_LIB
VARCHAR(10)
Nullable
The name of the library that contains the journal.

Contains the null value if the receiver has never been attached to a journal.

JOURNAL_NAME JOURNAL
VARCHAR(10)
Nullable
The name of the journal that the journal receiver is attached to or used to be attached to.

Contains the null value if the receiver has never been attached to a journal.

THRESHOLD THRESHOLD
INTEGER
Nullable
An auxiliary disk storage space threshold value (in kilobytes) for the journal receiver. If the threshold value is exceeded during journaling and the journal has the MNGRCV(*USER) attribute, a message (CPF7099) is sent to the message queue that is specified on the Create Journal (CRTJRN) or the Change Journal (CHGJRN) command. If the journal has the MNGRCV(*SYSTEM) attribute, the system creates and attaches a new journal receiver, detaches the old journal receiver when the threshold is reached, and sends message CPF7020 to the journal message queue.

Contains the null value for remote journal receivers.

SIZE SIZE INTEGER The number of kilobytes of auxiliary disk storage used by this journal receiver.
STATUS STATUS VARCHAR(8) The status of the journal receiver.
ATTACHED
The journal receiver is currently attached to the journal.
ONLINE
The journal receiver is online. The journal receiver has not been saved, and it has been detached from the journal.
SAVED
The journal receiver was saved after it was detached. The journal receiver storage was not freed when it was saved.
FREED
The journal receiver was saved after it was detached. The journal receiver storage was freed when it was saved.
PARTIAL
The journal receiver status is partial for one of the following reasons:
  • It was restored from a version that was saved while it was attached to the journal. Additional journal entries may have been written that were not restored.
  • It is associated with a remote journal and it does not contain all the journal entries that are in the associated journal receiver attached to the source journal.
EMPTY
The journal receiver has never been attached to a journal.
NUMBER_OF_JOURNAL_ENTRIES ENTRIES
DECIMAL(20,0)
Nullable
The number of journal entries that are contained in this journal receiver.

Contains the null value if STATUS is EMPTY.

FIRST_SEQUENCE_NUMBER FIRST_SEQ
DECIMAL(21,0)
Nullable
The journal sequence number of the first journal entry in this journal receiver.

Contains the null value if STATUS is EMPTY.

LAST_SEQUENCE_NUMBER LAST_SEQ
DECIMAL(21,0)
Nullable
The journal sequence number of the last journal entry in this journal receiver.

Contains the null value if STATUS is EMPTY.

MAXIMUM_ENTRY_SPECIFIC_DATA_LENGTH MAX_ESD
DECIMAL(20,0)
Nullable
The length in bytes of the longest entry-specific data among all journal entries in this journal receiver.

Contains the null value if STATUS is EMPTY.

MAXIMUM_NULL_VALUE_INDICATORS MAX_NVI
INTEGER
Nullable
The maximum number of null value indicators among all journal entries in this journal receiver.

Contains the null value if STATUS is EMPTY.

ATTACH_TIMESTAMP ATTACHED
TIMESTAMP(0)
Nullable
The date and time that this journal receiver was attached to the journal. For a journal receiver attached to a remote journal, this is the date and time that the journal receiver was attached on the local system.

Contains the null value if STATUS is EMPTY.

DETACH_TIMESTAMP DETACHED
TIMESTAMP(0)
Nullable
The date and time that this journal receiver was detached from the journal. For a journal receiver attached to a *REMOTE journal, this is the date and time that the journal receiver was detached on the local system.

Contains the null value if STATUS is EMPTY, ATTACHED, or PARTIAL.

SAVE_TIMESTAMP SAVED
TIMESTAMP(0)
Nullable
The date and time that the journal receiver was last saved. This value reflects when the receiver was saved from the system it exists on (either the source or target system time).

Contains the null value if the journal receiver was never saved.

PREVIOUS_JOURNAL_RECEIVER_LIBRARY PREV_RCVL
VARCHAR(10)
Nullable
The name of the library of the previous journal receiver that is associated with the same journal.

Contains the null value if STATUS is EMPTY, if there was no journal receiver attached to the journal prior to this journal receiver, or if it is currently associated with a remote journal.

PREVIOUS_JOURNAL_RECEIVER PREV_RCV
VARCHAR(10)
Nullable
The name of the previous journal receiver that is associated with the same journal.

Contains the null value if STATUS is EMPTY, if there was no journal receiver attached to the journal prior to this journal receiver, or if it is currently associated with a remote journal.

NEXT_JOURNAL_RECEIVER_LIBRARY NEXT_RCVL
VARCHAR(10)
Nullable
The name of the library of the next journal receiver that is associated with the same journal.

v

NEXT_JOURNAL_RECEIVER NEXT_RCV
VARCHAR(10)
Nullable
The name of the next journal receiver that is associated with the same journal.

v

RECEIVER_MAXIMUM_SIZE MAXOPT pendin
VARCHAR(8)
Nullable
The journal receiver sequence number and size option for this journal receiver. If this journal receiver is attached to a remote journal, the value is determined by the local journal.
*NONE
The journal receiver has a maximum journal receiver size of approximately 1.9 gigabytes and a maximum sequence number of 2,147,483,136.
*MAXOPT1
The journal receiver has a maximum journal 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. This occurs if this receiver was attached when RCVSIZOPT(*MAXOPT1) was in effect for the journal.
*MAXOPT2
The journal receiver has a maximum journal receiver size of approximately one terabyte (1,099,511,627,776 bytes) and a maximum sequence number of 9,999,999,999. This occurs if this receiver was attached when RCVSIZOPT(*MAXOPT2) was in effect for the journal. Additionally, the maximum size of the journal entry which can be deposited is 4,000,000,000 bytes.
*MAXOPT3
The journal receiver has a maximum journal 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. This occurs if this receiver was attached when RCVSIZOPT(*MAXOPT3) was in effect for the journal. Additionally, the maximum size of the journal entry which can be deposited is 4,000,000,000 bytes.

Contains the null value if STATUS is EMPTY.

MINIMIZE_ESD_FOR_DATA_AREAS MINDTAARA
VARCHAR(3)
Nullable
Whether the entry-specific data for data areas is minimized. If this journal receiver is attached to a remote journal, the value for is determined by the local journal.
NO
Journal entries for data areas have complete entry specific data.
YES
Journal entries for data areas may have minimized entry specific data.

Contains the null value if STATUS is EMPTY.

MINIMIZE_ESD_FOR_FILES MINFILE
VARCHAR(6)
Nullable
Whether the entry-specific data for files is minimized. If this journal receiver is attached to a remote journal, the value is determined by the local journal.
FLDBDY
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 have complete entry specific data.
YES
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.

Contains the null value if STATUS is EMPTY.

FIXED_LENGTH_DATA_INCLUDES_JOB_NAME FLDJOB
VARCHAR(3)
Nullable
Indicates whether the job name is stored when journal entries are deposited.
NO
The job name is not stored when journal entries are deposited.
YES
The job name is stored when journal entries are deposited.

Contains the null value if STATUS is EMPTY.

FIXED_LENGTH_DATA_INCLUDES_USER_NAME FLDUSR
VARCHAR(3)
Nullable
Indicates whether the user name is stored when journal entries were deposited.
NO
The user name is not stored when journal entries are deposited.
YES
The user name is stored when journal entries are deposited.

Contains the null value if STATUS is EMPTY.

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

Contains the null value if STATUS is EMPTY.

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

Contains the null value if STATUS is EMPTY.

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

Contains the null value if STATUS is EMPTY.

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

Contains the null value if STATUS is EMPTY.

FIXED_LENGTH_DATA_INCLUDES_THREAD_ID FLDTHD
VARCHAR(3)
Nullable
Indicates whether the thread identifier is stored when journal entries were deposited.
NO
The thread identifier is not stored when journal entries are deposited.
YES
The thread identifier is stored when journal entries are deposited.

Contains the null value if STATUS is EMPTY.

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

Contains the null value if STATUS is EMPTY.

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

Contains the null value if STATUS is EMPTY.

PENDING_TRANSACTIONS PEND_TRANS
VARCHAR(3)
Nullable
Whether the journal receiver contains journal entries for commitment control transactions that have not yet been committed or rolled back.
NO
The journal receiver does not contain entries for pending commitment control transactions.
YES
The journal receiver contains entries for pending commitment control transactions.

Contains the null value if STATUS is EMPTY or the journal receiver was attached to a remote journal.

REMOTE_JOURNAL_TYPE RMT_TYPE
VARCHAR(6)
Nullable
If this journal receiver was attached to a remote journal, this is the remote journal type for that journal when this journal receiver was attached. Values are *TYPE1 and *TYPE2.

Contains the null value if the journal receiver was not attached to a remote journal.

LOCAL_JOURNAL_SYSTEM LCLJRNSYS
VARCHAR(8)
Nullable
The system 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 if the journal receiver was not attached to a remote journal.

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

Contains the null value if the journal receiver was not attached to a remote journal.

LOCAL_JOURNAL_NAME LCLJRNNAME
VARCHAR(10)
Nullable
The 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 if the journal receiver was not attached to a remote journal.

LOCAL_JOURNAL_ASP_GROUP LCLASPGRP
VARCHAR(10)
Nullable
The independent auxiliary storage pool (IASP) group of the local journal.

Contains the null value if the journal receiver was not attached to a remote journal.

LOCAL_JOURNAL_RECEIVER_LIBRARY LCLRCVLIB
VARCHAR(10)
Nullable
The library name of the journal receiver that is associated with the local journal.

Contains the null value if the journal receiver was not attached to a remote journal.

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

Contains the null value if the journal receiver was not attached to a remote journal.

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

Contains the null value if the journal receiver was not attached to a remote journal.

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

Contains the null value if the journal receiver was not attached to a remote journal.

SOURCE_JOURNAL_ASP_GROUP SRCASPGRP
VARCHAR(10)
Nullable
The independent auxiliary storage pool (IASP) group of the source journal.

Contains the null value if the journal receiver was not attached to a remote journal.

SOURCE_JOURNAL_RECEIVER_LIBRARY SRCRCVLIB
VARCHAR(10)
Nullable
The library name of the journal receiver that is associated with the source journal.

Contains the null value if the journal receiver was not attached to a remote journal.

REDIRECTED_RECEIVER_LIBRARY REDIR_LIB
VARCHAR(10)
Nullable
The *TYPE1 receiver library redirection that was in effect when this journal receiver was attached.

Contains the null value if the journal receiver was not attached to a remote journal or REMOTE_JOURNAL_TYPE is not *TYPE1.

FILTER_BY_OBJECT FTR_OBJECT
VARCHAR(4)
Nullable
Specifies whether journal entries sent to the remote journal will be filtered by object.
*NO
Journal entries sent to the remote journal will not be filtered by object.
*YES
Journal entries deposited for objects that indicated remote journal filtering at the time they were deposited will not be sent to the remote journal.

Contains the null value if the journal receiver was not attached to a remote journal.

FILTER_IMAGES FTR_IMAGE
VARCHAR(7)
Nullable
Specifies whether before images will be sent to the remote journal.
*NONE
All journal entries will be sent to the remote journal, unless they are filtered by the Filter by object or Filter by program specifications.
*BEFORE
Before images will not be sent to the remote journal.

Contains the null value if the journal receiver was not attached to a remote journal.

FILTER_PROGRAMS FTR_PGM
INTEGER
Nullable
The number of programs for which journal entries sent on behalf of these programs were filtered when sent to this journal receiver. These programs are listed in the FILTER_PROGRAM_ARRAY and FILTER_PROGRAM_JSON columns.

Contains the null value if the journal receiver was not attached to a remote journal.

FILTER_PROGRAM_ARRAY FTR_ARRAY
VARCHAR(219)
Nullable
An array of up to 20 names of 22 characters apiece. The first 10 of each is a program name, followed by a blank, followed by 10 characters for the program library name. One comma separates the entries. The program library name can be *ALL. Journal entries sent on behalf of these programs will not be sent to the remote journal.

Contains the null value if the journal receiver was not attached to a remote journal or FILTER_PROGRAMS is zero.

FILTER_PROGRAM_JSON FTR_LISTJ
VARCHAR(498) CCSID 1208
Nullable
A list of programs and libraries. Journal entries sent on behalf of these programs were filtered when sent to this journal receiver. The program’s library name may be *ALL.
This list is returned as an array within a JSON object. Each entry in the JSON array contains two JSON objects:
  • An object with a name of "LIBRARY" and a value of the library name containing the program
  • An object with a name of "PROGRAM" and a value of the program name

Contains the null value if the journal receiver was not attached to a remote journal or FILTER_PROGRAMS is zero.

Examples

  • Return a list of journal receivers that have not been saved.
    SELECT JOURNAL_RECEIVER_LIBRARY, JOURNAL_RECEIVER_NAME, STATUS
    	FROM QSYS2.JOURNAL_RECEIVER_INFO
    	WHERE STATUS = 'ONLINE';
  • Return the length of time, in seconds, that journal receivers in RCVLIB were attached.
    SELECT JOURNAL_RECEIVER_LIBRARY, JOURNAL_RECEIVER_NAME, TIMESTAMPDIFF(SECOND, DETACH_TIMESTAMP, ATTACH_TIMESTAMP), SIZE
    	FROM QSYS2.JOURNAL_RECEIVER_INFO
    	WHERE DETACH_TIMESTAMP IS NOT NULL AND
                 JOURNAL_RECEIVER_LIBRARY = 'RCVLIB';
  • Return a list of programs contained in the FILTER_PROGRAMS_JSON column related to journal receiver RCV1 in RCVLIB.
    SELECT j.*, r.*
      FROM QSYS2.JOURNAL_RECEIVER_INFO r, 
           JSON_TABLE(FILTER_PROGRAM_JSON, 'lax $.PROGRAM_LIST' 
                      COLUMNS(LIBRARY VARCHAR(10),
                              PROGRAM VARCHAR(10))) j
      WHERE JOURNAL_RECEIVER_LIBRARY = 'RCVLIB' AND JOURNAL_RECEIVER_NAME = 'RCV1';
    
End of change