Restoring With All AMPs Online
It is feasible to restore even if AMPs are added to or deleted from the configuration after the archive.
Example
This example restores all databases with all AMPs online and assumes that none of the databases have journal table definitions. Journal tables must be dropped before running this job.
LOGON DBC,DBC;
DELETE DATABASE (DBC) ALL, EXCLUDE (DBC);
RESTORE DATA TABLES (DBC),
RELEASE LOCK,
FILE=ARCHIVE;
LOGOFF;
Run the post DBC restore script (post_dbc_restore).
LOGON DBC,DBC;RESTORE DATA TABLES (DBC) ALL,
EXCLUDE (DBC), (TD_SYSFNLIB),
RELEASE LOCK,
FILE=ARCHIVE;
LOGOFF;
Run the post data restore script (post_data_restore).
The DELETE DATABASE statement is included so that only the tables in database DBC are present. If the DELETE statement is omitted, the restore cannot finish.
When the operation is complete, check the print file to verify that all AMPs involved in the restore process remained online. If one or more AMPs went offline, see “Restoring With AMPs Offline” on page 62 for more information.