Object replication considerations

You must determine which objects you want replicated for Db2® Mirror. The Replication Criteria List (RCL) is where you register the rules for objects.

The RCL is a set of rules that define the objects that are to be replicated. To understand how the RCL works, see Managing the Replication Criteria List.

Default inclusion state

The highest level rule for the RCL is called the default inclusion state. This must be defined for SYSBAS as part of the initial configuration. It must be defined for each database independent auxiliary storage pool (IASP) before the IASP is added to the Db2 Mirror environment. The default inclusion state has two possible settings:
  • EXCLUDE - No objects will be replicated by default. You must create rules to identify the objects that are to be included in replication.
  • INCLUDE - All eligible objects will be replicated by default. You can create additional rules that identify objects to be excluded.

Once set, the default inclusion state cannot be changed during the course of normal RCL management. The default inclusion state can only be set during the initial Db2 Mirror setup process or if a pair of nodes is recloned and all existing rules are removed during the reclone process.

Object considerations

Most objects used by applications are supported to be replicated in the Db2 Mirror environment. The list of supported objects is listed in Replication-eligible objects. Objects that are not supported for replication need to be considered as part of your Db2 Mirror implementation plan. For additional details of what needs to be considered in your applications, see Application considerations.

It is highly recommended that if any object in a group of related objects is replicated, all objects in the group should be replicated. For example, if a view that you plan to replicate references two tables and three functions, the view, the tables, and the functions should all be replicated. In addition, any objects that the functions reference should be replicated as well.

Database IASPs

Each registered database IASP contains an independent set of objects that can be included in Db2 Mirror replication. Each IASP has its own RCL and its own default inclusion state. Rules defined for an IASP only apply to the objects that reside in that IASP.