CONFIRM_RECLONE_SECURITY_OBJECTS view

The CONFIRM_RECLONE_SECURITY_OBJECTS view returns one row for each *AUTL, *FCNUSG, *SECATR, or *USRPRF object that is different from the same object on the other node. Any differences in the security attributes could result in failures when a software reclone is attempted.

The view identifies objects that are different or only exist on one of the nodes and indicates whether any tracked entries in the Object Tracking List (OTL) have not been processed for those objects. The columns with _SOURCE in their name indicate values on the node where the view was queried. Columns with _TARGET in their name indicate values from the other node of the Db2® Mirror pair.

Authorization: The privileges held by the authorization ID of the statement must include *SECADM special authority or QIBM_DB_SECADM function usage authority. For the authority needed to use this view, see Authorization.

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

Table 1. CONFIRM_RECLONE_SECURITY_OBJECTS view
Column Name	System Column Name	Data Type	Description
OBJECT_TYPE	OBJ_TYPE	VARCHAR(8)	Type of object. AUTL Authorization list FCNUSG Function usage SECATR Security attributes USRPRF User profile
OBJECT_NAME	OBJ_NAME	VARCHAR(30)	System name of the object. Contains the null value if OBJECT_TYPE is *SECATR.
OBJECT_ON_SOURCE	OBJ_SRC	VARCHAR(3)	Indicates whether the object was found on the source node. NO This object was not found on the source node. YES This object was found on the source node.
OBJECT_ON_TARGET	OBJ_TGT	VARCHAR(3)	Indicates whether the object was found on the target node. NO This object was not found on the target node. YES This object was found on the target node.
TRACKED_ON_SOURCE	TRACK_SRC	VARCHAR(3)	Indicates whether the object has any tracked entries in the OTL that have not been processed on the source node. NO This object does not have any tracked entries on the source node. YES This object has tracked entries on the source node.
TRACKED_ON_TARGET	TRACK_TGT	VARCHAR(3)	Indicates whether the object has any tracked entries in the OTL that have not been processed on the target node. NO This object does not have any tracked entries on the target node. YES This object has tracked entries on the target node.

Example

Create a table that lists any security differences between the two Db2 Mirror nodes.

CREATE TABLE MYLIB.RECLONE_SECURITY_DIFFERENCES AS (
  SELECT * FROM QSYS2.CONFIRM_RECLONE_SECURITY_OBJECTS)
  WITH DATA;