REMOTE_JOURNAL_INFO view

The REMOTE_JOURNAL_INFO view returns information about every remote journal defined for a local or remote journal on the IBM® i where this view is referenced. The remote journals returned by this service exist on a different IBM i, as noted by the remote database (RDB) name.

This information is similar to what is returned by the Retrieve Journal Information (QjoRetrieveJournalInformation) API.

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 RMT_JRNS. The schema is QSYS2.

Table 1. REMOTE_JOURNAL_INFO view
Column Name	System Column Name	Data Type	Description
SOURCE_JOURNAL_LIBRARY	SRC_JRNLIB	VARCHAR(10)	The library that contains SOURCE_JOURNAL.
SOURCE_JOURNAL	SRC_JRN	VARCHAR(10)	The name of the journal that has the remote journal defined.
REMOTE_DATABASE_NAME	RMT_RDB	VARCHAR(18)	The name of the remote database that is the target and contains the remote journal.
REMOTE_JOURNAL_LIBRARY	RMT_JRNLIB	VARCHAR(10)	The library that contains REMOTE_JOURNAL.
REMOTE_JOURNAL	RMT_JRN	VARCHAR(10)	The name of the remote journal that is the target for remote journaling.
REMOTE_JOURNAL_RECEIVER_LIBRARY	RMT_RCVLIB	VARCHAR(10)	The library name of the remote journal receiver that is the target for remote journaling. The special value of *SRCRCVLIB indicates the journal receivers are created on the target system in the same library as they exist on the source system.
REMOTE_JOURNAL_STATE	RMT_STATE	VARCHAR(8)	The state of the remote journaling. ACTIVE The remote journal is ready to receive any journal entries from its source journal. CTLINACT The remote journal is in the process of a controlled inactivate. Therefore, the remote journal will be receiving those journal entries that were already queued for replication when the Change Remote Journal (CHGRMTJRN) command or the Change Journal State (QjoChangeJournalState) API requested to inactivate the remote journal. However, no entries deposited after that request will be replicated to the remote journal. FAILED The remote journal is not ready to receive any journal entries from its source journal due to a remote journal function failure, for example, a communications failure. You will need to inactivate the remote journal by using the Change Remote Journal (CHGRMTJRN) command or by calling the Change Journal State (QjoChangeJournalState) API. INACTIVE The remote journal is not ready to receive any journal entries from its source journal. PENDING The remote journal is transitioning from an INACTIVE state to an ACTIVE state.
REMOTE_JOURNAL_TYPE	RMT_JTYPE	VARCHAR(6)	The type of remote journal that was created. The type influences characteristics of the remote journal such as journal receiver restore options, redirection capabilities, and remote journal association support. TYPE1 Type 1 remote journal TYPE2 Type 2 remote journal
DELIVERY_MODE	DELIVERY	VARCHAR(10) Nullable	The remote journal delivery mode that is being used to replicate journal entries to the remote journal. ASYNC Journal entries are being delivered or replicated asynchronously. ASYNCPEND Journal entries are to be delivered or replicated asynchronously, but the remote 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 remote journal is currently in catch-up mode. Contains the null value if REMOTE_JOURNAL_STATE is not ACTIVE or CTLINACT.
DATA_PORT_SERVICES_NODE_ID	NODE_ID	VARCHAR(8) Nullable	The node identifier being used by data port services to identify the target system in a cluster environment. If a node identifier and at least one internet address is retrieved, then data port services is being used as an alternate communication method to the target system. Contains the null value if the remote journal is not configured for data port services.
DATA_PORT_SERVICES_ADDRESS_1	IP_ADDR1	VARCHAR(45) Nullable	The first internet address being used by data port services to communicate to the target system. Contains the null value if the remote journal is not configured for data port services.
DATA_PORT_SERVICES_ADDRESS_2	IP_ADDR2	VARCHAR(45) Nullable	The second internet address being used by data port services to communicate to the target system. Contains the null value if the remote journal is not configured for data port services or there are less than two internet addresses being used.
DATA_PORT_SERVICES_ADDRESS_3	IP_ADDR3	VARCHAR(45) Nullable	The third internet address being used by data port services to communicate to the target system. Contains the null value if the remote journal is not configured for data port services or there are less than three internet addresses being used.
DATA_PORT_SERVICES_ADDRESS_4	IP_ADDR4	VARCHAR(45) Nullable	The fourth internet address being used by data port services to communicate to the target system. Contains the null value if the remote journal is not configured for data port services or there are less than four internet addresses being used.
VALIDITY_CHECKING	VALID_CHK	VARCHAR(9) Nullable	The validity checking status. When communications validity checking is turned on, the remote journal environment provides additional checking to verify that the data which is received by the target system matches the data that was sent from the source system. If the data does not match, the data will not be written to the target system, the remote journal environment will be inactivated, and messages indicating the communications failure will be issued to the journal message queue and QHST. DISABLED Communications validity checking is turned off for this remote journal environment. ENABLED Communications validity checking is turned on for this remote journal environment. Contains the null value if REMOTE_JOURNAL_STATE is not ACTIVE or CTLINACT.
SENDING_TASK_PRIORITY	PRIORITY	INTEGER Nullable	The priority of the sending task on the source system. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or DELIVERY_MODE is not ASYNC or ASYNCPEND.
SYNCHRONOUS_SENDING_TIME_OUT	TIME_OUT	INTEGER Nullable	The maximum amount of time, in seconds, to wait for a response from the remote system when a response is required in a synchronous remote journal environment. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or DELIVERY_MODE is not SYNC or SYNCPEND.
MAXIMUM_RESTART_ATTEMPTS	MAXRESTART	INTEGER Nullable	The number of times the operating system will attempt to reactivate the remote journal after a recoverable failure. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE.
RESTART_DELAY_TIME	RESTARTDLY	INTEGER Nullable	The number of seconds between attempts to reactivate the remote journal after a recoverable failure. Contains the null value if MAXIMUM_RESTART_ATTEMPTS is null or 0.
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 REMOTE_JOURNAL_STATE is INACTIVE.
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 REMOTE_JOURNAL_STATE is INACTIVE.
FILTER_PROGRAMS	FTR_PGM	INTEGER Nullable	The number of programs returned in FILTER_PROGRAM_ARRAY. Journal entries sent on behalf of these programs will not be sent to the remote journal. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE.
FILTER_PROGRAM_ARRAY	FTR_ARRAY	VARCHAR(219) Nullable	An array of up to 20 names of 22 characters each. 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 REMOTE_JOURNAL_STATE is INACTIVE 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.
BUNDLES_SENT	BUNDLES	BIGINT Nullable	The number of bundles that have been sent to the target system since the source journal transitioned to an active state. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE.
MAXIMUM_BUNDLE_SIZE	BUNDLE_SIZ	BIGINT Nullable	The number of bytes in the largest bundle that has been sent to the target system since the source journal transitioned to an active state. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE.
MAXIMUM_BUNDLE_SIZE_TIME	BUNDLE_TIM	TIMESTAMP Nullable	The date and time that the maximum bundle size was sent to the target system. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or MAXIMUM_BUNDLE_SIZE is 0.
SUPER_BUNDLE_MODE_COUNT	SUPER_CNT	BIGINT Nullable	The number of times that the remote journal environment has automatically gone into super bundling mode. Super bundling mode helps the remote journal environment keep up with the local journal when the local journal has a high rate of journal entry deposits. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or DELIVERY_MODE is not ASYNC or ASYNCPEND.
ENTRIES_BEHIND	BEHIND	BIGINT Nullable	The number of entries that are waiting to be sent to the target system. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or DELIVERY_MODE is not ASYNC or ASYNCPEND.
MAXIMUM_ENTRIES_BEHIND	MBEHIND	BIGINT Nullable	The maximum number of entries that were waiting to be sent to the target system since the source journal transitioned to an active state. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or DELIVERY_MODE is not ASYNC or ASYNCPEND.
MAXIMUM_ENTRIES_BEHIND_TIME	MBEHINDT	TIMESTAMP Nullable	The date and time that MAXIMUM_ENTRIES_BEHIND occurred. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or DELIVERY_MODE is not ASYNC or ASYNCPEND or MAXIMUM_ENTRIES_BEHIND is 0.
TIME_BEHIND	TBEHIND	BIGINT Nullable	The value, in hundredths of seconds, that the source journal is behind in sending journal entries to the target system. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or DELIVERY_MODE is not ASYNC or ASYNCPEND.
MAXIMUM_TIME_BEHIND	MTBEHIND	BIGINT Nullable	The maximum value, in hundredths of seconds, that the source journal was behind in sending journal entries to the target system. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or DELIVERY_MODE is not ASYNC or ASYNCPEND.
MAXIMUM_TIME_BEHIND_TIME	MTBEHINDT	TIMESTAMP Nullable	The date and time that MAXIMUM_TIME_BEHIND occurred. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE or DELIVERY_MODE is not ASYNC or ASYNCPEND or MAXIMUM_TIME_BEHIND is 0.
RETRANSMISSIONS	RETRANS	BIGINT Nullable	The total number of times the local system retransmitted a segment because an acknowledgement was not received. This is a cumulative count of all segments resent since the remote journal was last activated. A value greater than zero may indicate a problem with the network. Contains the null value if this information is not available
LAST_CATCHUP_TIME	LAST_CATCH	TIMESTAMP Nullable	The date and time that the remote journal environment last transitioned to DELIVERY_MODE ASYNCPEND or SYNCPEND. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE.
LAST_ACTIVE_TIME	LAST_ACT	TIMESTAMP Nullable	The date and time that the remote journal environment last transitioned from DELIVERY_MODE ASYNCPEND or SYNCPEND to DELIVERY_MODE ASYNC or SYNC. Contains the null value if REMOTE_JOURNAL_STATE is INACTIVE
CONTROLLED_INACTIVATE_SEQUENCE_ NUMBER	INACT_SEQ	DECIMAL(21,0) Nullable	The sequence number of the last journal entry that was queued for replication before the Change Remote Journal (CHGRMTJRN) command or the Change Journal State (QjoChangeJournalState) API was called to start a controlled inactivate of the remote journal. Contains the null value if REMOTE_JOURNAL_STATE is not CTLINACT.
CONTROLLED_INACTIVATE_JOURNAL_ RECEIVER_LIBRARY	INACTJRCVL	VARCHAR(10) Nullable	The library of the journal receiver that contains the CONTROLLED_INACTIVATE_SEQUENCE_NUMBER. Contains the null value if REMOTE_JOURNAL_STATE is not CTLINACT.
CONTROLLED_INACTIVATE_JOURNAL_ RECEIVER	INACTJRCV	VARCHAR(10) Nullable	The name of the journal receiver that contains the CONTROLLED_INACTIVATE_SEQUENCE_NUMBER. Contains the null value if REMOTE_JOURNAL_STATE is not CTLINACT.
SOURCE_JOURNAL_IASP_NUMBER	SRC_ASPNUM	INTEGER	The number of the auxiliary storage pool to which storage for the journal that has the remote journal defined is allocated.
SOURCE_JOURNAL_IASP_NAME	SRC_ASPNAM	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).

Example

Return information about remote journals defined for system RMTSYS1.

SELECT * FROM QSYS2.REMOTE_JOURNAL_INFO
  WHERE REMOTE_DATABASE_NAME = 'RMTSYS1';