You can use both RECOVER CATALOG USING REPLICATION and RECOVER CATALOG TO REPLICATION to create a new original database. This new database must be entered in the SQL catalog list. RECOVER CATALOG USING/TO REPLICATION creates all the spaces of the new database from this replication provided these were current in the replication.
Procedure
The database administrator must use the administration statement ADD-SQL-DB-CATALOG-ENTRY to enter the new database in the DBH.
It is assigned the status LOCKED, because it does not exist yet.
The database is generated on the basis of the replication using RECOVER CATALOG TO/USING REPLICATION.
The following points must also be taken into consideration by the system administrator:
He/she must change and adapt the storage groups in the new database.
He/she must use COPY CATALOG to create separate SESAM backup copies, possibly followed by COPY SPACE since the old copies can no longer be accessed. He/she must then use the utility monitor to remove the metadata of old SESAM backup copies for the catalog space from the CAT-REC file. MODIFY RECOVERY must then be used to delete old references to SESAM backup copies for the user spaces
If the new original has been created from a partial replication, the missing spaces must be created with RECOVER... TO '*DUMMY' or explicitly deleted using DROP SPACE FORCED.
For further information on how to proceed, see section “Using a replication to repair an original database” and section “Reset the original database using replications”.