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.
- *EXECUTE authority to the library containing the journal receiver, and
- *OBJOPR authority and some data authority other than *EXECUTE to the journal receiver.
- *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.
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.
|
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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:
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';