QSYS2.EVALUATE_RECLONE_RELATED_OBJECTS()

Abstract

The EVALUATE_RECLONE_RELATED_OBJECTS table function returns a row for each nonreplicated database object dependent upon a replicated object that will be deleted on the copy node during a software reclone.

A software reclone is performed by resynchronizing replicated objects by using save and restore operations from the source node to the copy node. As part of this process, some replicated objects must be deleted from the copy node before the resynchronization can be performed. Nonreplicated dependent objects might be deleted by cascading delete rules. Replicated objects are reestablished on the copy node by the software reclone while nonreplicated objects remain deleted. For example, if a nonreplicated view is defined over a replicated table, when the table is dropped during the software reclone processing, the nonreplicated dependent view is dropped and not re-created or restored. The result rows from this function indicate objects that should be saved before the software reclone and restored when it is complete.