SET_DEFAULT_INCLUSION_STATE procedure

Edit online

The SET_DEFAULT_INCLUSION_STATE procedure sets the default inclusion state for objects that are in SYSBAS. To set the default inclusion state for objects in an IASP, use the QSYS2.ADD_MIRROR_IASP procedure.

The default inclusion state setting will be used when no applicable rules for an object are found in the Replication Criteria List (RCL). When no applicable rule is found in the RCL, the default inclusion state indicates whether or not the object should be replicated. The RCL cannot be configured until the default inclusion state is set to INCLUDE or EXCLUDE. The default inclusion state can only be set or changed when replication has ended and the replication state of the node is set to NOT MIRRORED.

An RCL can be restored on the primary node for use when Db2® Mirror is configured. If a restored RCL is found and the default inclusion state of the restored RCL matches the default inclusion state specified on the SET_DEFAULT_INCLUSION_STATE procedure call, the restored RCL will be adopted by the Db2 Mirror configuration. When the default inclusion states do not match, an error will be returned to indicate that the restored RCL cannot be used. If you determine the restored RCL should not be used, call the QSYS2.SET_DEFAULT_INCLUSION_STATE('RESET') procedure to delete the RCL so it will not be used during Db2 Mirror configuration processing. See Restoring Replication Criteria List data for more details on restoring an RCL.

Authorization: For the authority needed to use this procedure, see Authorization.

Read syntax diagramSkip visual syntax diagramSET_DEFAULT_INCLUSION_STATE( INCLUSION_STATE =>  inclusion-state)

The schema is QSYS2.

inclusion-state
A character or graphic string that indicates whether all objects that are eligible for replication should be included or excluded from replication by default.
EXCLUDE
Eligible objects not covered by an RCL rule will not be replicated.
INCLUDE
Eligible objects not covered by an RCL rule will be replicated.
RESET
Clear the default inclusion state. The RCL will be deleted, if it exists.

Example

  • Configure the default inclusion state so all eligible objects are replicated.
       CALL QSYS2.SET_DEFAULT_INCLUSION_STATE('INCLUDE');
  • Change the default inclusion state of SYSBAS from exclude to include. To do this, all replication between the primary and secondary mirror nodes must be ended. 
    CALL QSYS2.TERMINATE_MIRROR(ACTION => 'RECLONE');
CALL QSYS2.SET_DEFAULT_INCLUSION_STATE('RESET');
CALL QSYS2.SET_DEFAULT_INCLUSION_STATE('INCLUDE');