Start of change

EVALUATE_RECLONE_REPLICATION_CRITERIA table function

The EVALUATE_RECLONE_REPLICATION_CRITERIA table function returns a row for each replicated and non-replicated object that will be deleted on the copy node during a software reclone based on any library differences detected for replicated objects that only exist on the copy node.

Replicated objects that only exist on the copy node represent either newly replicated objects on the copy node identified from changes to the Replication Criteria List (RCL) that have not been resynchronized or operations in the Object Tracking List (OTL) that have not been processed.

When a replicated library is identified, each replicated and non-replicated object contained within the library that will be deleted will also be returned by this table function.

This function should be run on the node which will be the source node for the software reclone of SYSBAS or an IASP.

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 *ALLOBJ special authority. For the authority needed to use this function, see Authorization.

Read syntax diagramSkip visual syntax diagram EVALUATE_RECLONE_REPLICATION_CRITERIA ( IASP_NAME =>  iasp-name )
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 replication criteria rules. Can contain the following special value:
*SYSBAS
The replication criteria rules 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 represents an object which would be deleted on the copy node during a software reclone. All columns are nullable.

Table 1. EVALUATE_RECLONE_REPLICATION_CRITERIA table function
Column Name Data Type Description
LIBRARY_NAME VARCHAR(10) The name of the library containing the object that will be deleted.
OBJECT_NAME VARCHAR(10) The name of the object that will be deleted.
OBJECT_TYPE VARCHAR(8) Type of object.
INCLUSION_STATE VARCHAR(10) The replication inclusion state for this object.
DEFINITION
Only the definition of the object is replicated.
EXCLUDE
The object is excluded from any replication action.
INCLUDE
The object is included in any replication action.
INELIGIBLE
The object is not eligible for replication.

Examples

  • List the objects on the copy node for IASP33 that will be deleted during a software reclone operation. 
    CREATE TABLE MYLIB.RECLONE_DELETES AS (
  SELECT * FROM TABLE(QSYS2.EVALUATE_RECLONE_REPLICATION_CRITERIA('IASP33')))
  WITH DATA;
  • List the objects on the copy node for library LIB1, including the library itself, that will be deleted during a software reclone operation.
    SELECT * FROM TABLE(QSYS2.EVALUATE_RECLONE_REPLICATION_CRITERIA('*SYSBAS'))
  WHERE LIBRARY_NAME = 'LIB1' OR (OBJECT_TYPE = '*LIB' AND OBJECT_NAME = 'LIB1')
  ORDER BY LIBRARY_NAME, OBJECT_TYPE, OBJECT_NAME ;
End of change