
Chapter 8. Building a corporate backup and recovery strategy 309
-- Select Blocks specifies customer table and output files
SELECT * FROM db2inst1.CUSTOMER;
OUTFILE("%{source_host}:/work%{source_node}/HPU/db2inst1.customer.file.%{
source_node}")FORMAT DEL
;
The LOAD command is issued to complete the recovery (Example 8-5).
Example 8-5 Sample control file to unload data from disk
db2 "LOAD from db2inst1.customer.file OF DEL INSERT
INTO db2inst1.CUSTOMER PARTITIONED DB CONFIG MODE LOAD_ONLY_VERIFY_PART
PART_FILE_LOCATION /work1/HPU OUTPUT_DBPARTNUMS(1,9)”
db2 "LOAD from db2inst1.customer.file OF DEL INSERT
INTO db2inst1.CUSTOMER PARTITIONED DB CONFIG MODE ...