Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

RECOVER SPACE TO REPLICATION

The utility statement RECOVER SPACE TO REPLICATION allows the database administrator to reset user spaces of the original. The replication can be a complete replication or any partial replication. The user spaces to be reset must be current in the replication.

The same information as given in resetting spaces with SESAM backups or foreign copies applies to building indexes on index spaces. The NO INDEX clause can be used to prevent the generation of indexes on dependent index spaces; the affected indexes are then defective.

In the case of RECOVER SPACE USING REPLICATION with RENAME, the affected user spaces will subsequently no longer be available in the replication.
In the case of RECOVER SPACE USING REPLICATION with COPY, the affected user spaces will be retained in the replication, but they cannot be updated any further in the replication because logging was interrupted as a result of the resetting in the original.

The following steps are necessary to add reset spaces to the replication again:

  1. Copy spaces in the original

  2. Create new CAT-REC.COPY file with the administration statement CHANGE-CATLOG

  3. Update replication with REFRESH REPLICATION FOR SPACE without specifying the reset spaces

  4. Extend the replication by adding the reset spaces with REFRESH SPACE from the previously created backup