EVALUATE_RECLONE_JOURNALED_OBJECTS table function

The EVALUATE_RECLONE_JOURNALED_OBJECTS table function is used prior to a software reclone to identify objects on the copy node which will have journaling ended during the software reclone. A row will be returned for each non-replicated object on the copy node which is journaled to a replicated journal.

The software reclone processing will end journaling for all objects journaled to any replicated journals (*JRN). Journaling will only be reestablished for replicated objects. Use this service to identify any non-replicated objects that should have journaling reestablished manually after the software reclone has completed.

When iasp-name is *SYSBAS:

This function is invoked on the primary node. The replication state must be TRACKING or BLOCKED. The replication detail must be SUSPENDED.
The copy node for the software reclone must be available.
The NRGs must be started.

When iasp-name is not *SYSBAS:

The replication state for SYSBAS must be ACTIVE.
The replication state of the IASP on the node where this function is invoked must be TRACKING. The replication detail must be SUSPENDED.
The IASP must be a database IASP and must be available on both nodes.

Authorization: The privileges held by the authorization ID of the statement must include:

*EXECUTE authority on the library containing the journal, and
*OBJOPR and some data authority other than *EXECUTE to the journal
*ALLOBJ special authority
For the authority needed to use this function, see Authorization.

The schema is QSYS2.

iasp-name

A character or graphic string expression that identifies the name of the auxiliary storage pool (ASP) group used to locate the journaled objects. Can contain the following special value:

*SYSBAS: The journaled objects are associated with the system ASP (ASP 1) and any basic user ASPs (ASPs 2-32).

The result of the function is a table containing rows with the format shown in the following table. Each row lists an object on the other node that would have journaling ended if that node is used as the copy node for a software reclone. All columns are nullable.

Table 1. EVALUATE_RECLONE_JOURNALED_OBJECTS table function
Column Name	Data Type	Description
JOURNAL_LIBRARY	VARCHAR(10)	The name of the library that contains the replicated journal.
JOURNAL_NAME	VARCHAR(10)	The name of the replicated journal.
OBJECT_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	VARCHAR(10)	The name of the library that contains the object. Contains the null value if OBJECT_TYPE is DIR, STMF, or *SYMLNK.
OBJECT_NAME	VARCHAR(10)	The name of the object that will have journaling ended. Contains the null value if OBJECT_TYPE is DIR, STMF, or *SYMLNK.
FILE_TYPE	VARCHAR(8)	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	DBCLOB(16M) CCSID 1200	The path name of an integrated file system object that will have journaling ended. Contains the null value if OBJECT_TYPE is not DIR, STMF, or *SYMLNK.
FILE_IDENTIFIER	BINARY(16)	The identifier associated with the integrated file system object. Contains the null value if OBJECT_TYPE is not DIR, STMF, or *SYMLNK.
JOURNAL_IMAGES	VARCHAR(6)	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.
OMIT_JOURNAL_ENTRY	VARCHAR(10)	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.
INHERIT	VARCHAR(4)	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	VARCHAR(4)	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

List all the non-replicated objects journaled to a replicated journal in SYSBAS that would have journaling ended on the copy node if a software reclone is performed.
```
CREATE TABLE MYLIB.RECLONE_NOT_JOURNALED AS (
  SELECT * FROM TABLE(QSYS2.EVALUATE_RECLONE_JOURNALED_OBJECTS(IASP_NAME => '*SYSBAS')))
    WITH DATA;
```