310 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
;
-- 1,9 specifies partitions 1 and 9
UNLOAD TABLESPACE PART(1,9)
USING BACKUP DATABASE CSTINSIGHT TABLESPACE ("FACT_TBSPC_2007") USE TSM ON
SOURCE HOST TAKEN AT 20120331080240;
SELECT * FROM GOSALESDW.CUSTOMER;
OUTFILE("%{source_host}:/work%{source_node}/HPU/pipe.%{source_node}")
FORMAT DEL
;
-- 2,10 specifies partitions 2 and 10 (continues to 8 and 16)
UNLOAD TABLESPACE PART(2,10)
USING BACKUP DATABASE CSTINSIGHT TABLESPACE ("FACT_TBSPC_2007") USE TSM ON
SOURCE HOST TAKEN AT 20120331084220;
SELECT * FROM GOSALESDW.CUSTOMER;
OUTFILE("%{source_host}:/work%{source_node}/HPU/pipe.%{source_node}")
FORMAT DEL
;
2. Create named pipes on each data node as specified in the control file.
The names in this example have the format /workN/HPU/pipe.XXX, where
XXX is the appropriate database logical node number.
The named pipes were created for the database partitions to be processed by
the unload block in the control file. Example 8-7 illustrates the commands
used to create the named pipes in the test environment.
Example 8-7 Sample control file to unload data from disk
-- Data Node 1
mkfifo /work1/HPU/pipe.001
mkfifo /work2/HPU/pipe.002
mkfifo /work3/HPU/pipe.003
mkfifo /work4/HPU/pipe.004
mkfifo /work5/HPU/pipe.005
mkfifo /work6/HPU/pipe.006
mkfifo /work7/HPU/pipe.007
mkfifo /work8/HPU/pipe.008
-- Data Node 2 (Symbolic links for /work1 to /work8 created)
mkfifo /work1/HPU/pipe.009
mkfifo /work2/HPU/pipe.010
mkfifo /work3/HPU/pipe.011
mkfifo /work4/HPU/pipe.012
mkfifo /work5/HPU/pipe.013
mkfifo /work6/HPU/pipe.014
mkfifo /work7/HPU/pipe.015
mkfifo /work8/HPU/pipe.016