Hardware reclone of a database IASP

Recloning a database IASP can be done through the Db2® Mirror GUI or by using SQL services and the Qshell command db2mtool. You can choose to keep the current IASP properties and Replication Criteria List (RCL) or set new values as part of the cloning process.

The IASP cannot have a replication state of ACTIVE when starting the reclone process. Replication for an active IASP can be suspended either by varying off the IASP on the secondary node, or by suspending and resuming replication for SYSBAS with the auto-resume property set to NO for the IASP.

To suspend replication for the IASP by suspending and resuming SYSBAS:

Set the auto-resume property to NO for the IASP.
Suspend SYSBAS replication. All IASPs will also be suspended.
Resume SYSBAS replication. The IASP will remain suspended.

Hardware reclone of a database IASP using the Db2 Mirror GUI

To reclone an IASP, from the home page for the Db2 Mirror configuration select the IASP from the bottom panel. Right-click on the IASP and choose Reconfigure the IASP as shown below.

Figure 1. Reconfigure IASP from IASP home page

The reconfigure option is also available by selecting the Independent Auxiliary Storage Pools icon on the left side of any panel, choosing Database IASP –Management to see the list of registered IASPs, and right-clicking on the IASP that is to be the source of the clone.

Figure 2. Reconfigure IASP from Manage IASP

The method to reconfigure the database IASP must be selected. This is shown in the figure below.

If you would like to change properties, the default inclusion state, or the RCL, you must choose Reconfigure with prompts.
If you want to use all of the existing configuration parameters, you can choose Reconfigure based on the original configuration. This will start the cloning process immediately.
If you plan to restore an RCL from a backup and use that, choose the Reconfigure using Restored RCL. This process is documented in Restoring Replication Criteria List data.

When you click Reconfigure, the process will begin.

Figure 3. Selecting reconfiguration method

For Reconfigure with prompts, you will be guided through the configuration panels where you can choose between a cold and warm clone, update storage server information, and define the IASP host information. When you reach the default inclusion state panel, you can choose to change the default inclusion state for the IASP.

If the default inclusion state is changed, the existing RCL will be deleted. A confirmation panel will be shown as a warning that all current replication rules will be removed and replication will be terminated.

Figure 4. Confirm change to default inclusion state

If the default inclusion state is not changed, you will see a confirmation panel asking if you want to proceed, shown below. This is the point at which replication is terminated in preparation for the reclone.

Figure 5. Confirmation that mirroring will be terminated

The next panel allows changes to the RCL prior to the reclone. If the default inclusion state is not changed, the panel will be populated with the existing RCL rules. Rules can be added, removed, or updated.

Finally, a summary screen will be shown. Click Finish to begin the cloning process.

Figure 6. Summary of reclone configuration

When the reclone is complete, the IASP will have a replication state of ACTIVE.

Hardware reclone of a database IASP using commands

To reclone, you must perform the following steps. For complete command details, refer to Setting up Db2 Mirror using commands. The steps listed in italics can be skipped if no changes are needed.

End Db2 Mirror for the IASP.
- To keep the current default inclusion state and RCL, call the following SQL procedure:
  - QSYS2.ADD_MIRROR_IASP(IASP_NAME=><iasp-name>, USAGE=>'DATABASE', ACTION=>'RECLONE')
    Using ACTION=>'RECLONE' will keep the current properties, default inclusion state, and RCL. It will clear the OTL.
- To change the default inclusion state or delete the RCL, call the following SQL procedures:
  - QSYS2.REMOVE_MIRROR_IASP(IASP_NAME=><iasp-name>)
  - QSYS2.ADD_MIRROR_IASP(IASP_NAME=><iasp-name>, USAGE=>'DATABASE', ACTION=>'NEW', INCLUSION_STATE=><incl-state>)
    This will re-register the IASP with a new default inclusion state and RCL. The OTL will be cleared and a new RCL will be created with only system-specified rules.
Change the RCL on the setup source node.
Update storage and cloning attributes in the clone_info.json configuration file using Qshell command db2mtool action=update.
Reclone database IASPs using Qshell command db2mtool action=iaspcopy.