CLS;
CONNECT TO DB1C;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
RESTORE DATABASE DB2Z FROM "C:\BackUp" TAKEN AT 20100929210626 INTO DB1C LOGTARGET "C:\DB2_01\NODE0000\SQL00002\SQLOGDIR" WITH 2 BUFFERS BUFFER 1024 REPLACE HISTORY FILE PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO DB1C;
UNQUIESCE DATABASE;
CONNECT RESET;
еще
Naming convention for backup files
The naming convention for DB2 backup files contains the following items:
• Database alias
• Digit indicating the type of backup (0 for a full database, 3 for a
tablespace backup, 4 for a copy from LOAD)
• Instance name
• Database node (always NODE0000 for a single-partition database)
• Catalog node number (always CATN0000 for a single-partition database)
• Timestamp of the backup
• Image sequence number