LOGON DBCID/USERID,PASSWORD; ARCHIVE DATA TABLES (DB1) ALL,(DB2), RELEASE LOCK, FILE=ARCHIVE; LOGOFF;
This script performs these restore operations:
- ARCMAIN logs on to a Teradata Database pointed to by database DBCID.
- ARCMAIN places Host Utility (HUT) locks on the databases to be restored before starting the restore operation.
- The database’s DB1, all its descendent databases, and DB2 are restored. The operation is performed database by database in alphabetical order.
For each database, these operations are performed table by table in alphabetical order:
- Primary data is restored.
- If applicable, fallback and index data are built from primary data.
- The RELEASE LOCK option releases the HUT locks after the restore of each database is complete.
- After all databases are restored, the LOGOFF command disconnects ARCMAIN from the Teradata Database.