Previous Topic: Back Up an NDB

Next Topic: Monitor NDB Activity

Restore an NDB

If an NDB must be restored from a backup copy, then use the standard IDCAMS restore facility associated with the backup copy. For example, if REPRO was used to backup the database, then use REPRO to restore it; if EXPORT was used to backup the database, then use IMPORT to restore it.

When using REPRO, define the database with REUSE to allow the REUSE option of REPRO to be used. This makes a DELETE/DEFINE prior to the restore unnecessary.

The database must not be open while a restore is in progress. To create a consistent environment for NCL procedures using the NDB, issue an NDB STOP LOCK command prior to the restore. This causes all &NDBOPEN statements executed to get a database locked response.

Upon completion of the restore, issue the UDBCTL OPEN, as required, and an NDB START UNLOCK command to restart the database, and release the lock.