Skip to Main Content
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
book

Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

by Whei-Jen Chen, Pat Bates, Timothy Donovan, Garrett Fitzsimons, Jon Lind, Rogerio Silva
October 2012
Beginner to intermediate content levelBeginner to intermediate
506 pages
12h 43m
English
IBM Redbooks
Content preview from Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
Chapter 8. Building a corporate backup and recovery strategy 311
3. Execute the Optim High Performance Unload command that specifies the
required control file.
Example 8-8 Sample command line to issue db2hpu with control file
db2hpu -f CUSTOMER_disk_pipes.ctl
4. Start the DB2 load operation.
Example 8-9 shows the load commands.
Example 8-9 Sample LOAD command to complete recovery
-- Issue LOAD commands for all database partitions to be recovered
db2 "LOAD from pipe OF DEL INSERT INTO GOSALESDW.CUSTOMER PARTITIONED DB
CONFIG MODE LOAD_ONLY_VERIFY_PART PART_FILE_LOCATION /work1/HPU
OUTPUT_DBPARTNUMS(1,9)"
db2 "LOAD from pipe OF DEL INSERT INTO GOSA ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Reinventing the Organization for GenAI and LLMs

Reinventing the Organization for GenAI and LLMs

Ethan Mollick

Publisher Resources

ISBN: 0738437255Purchase book