SHARED_DATAPART_PROCESSING

The purpose of this function is to change the default behavior of the Optim™ High Performance Unload unload processing of database partitions, when unloading data-partitioned tables. This to improve the performances of the Optim High Performance Unload unload, by enabling a parallel processing instead of a serial processing. With this option enabled, Optim High Performance Unload will start processing units that are shared by distinct data-partitions. As a result, the number of processing units that are started for the data-partitions of a given database partition can be limited to a number allowing that all the database partitions be processed in parallel.

When the shared data-partitions processing is enabled, the ability to separate the rows by data-partition is not supported. As a result, trying to separate the output files per data-partition, by specifying one of the three template keywords %{datapartition_id} , %{datapartition_name} or %{datapartition_tbspace} in the OUTFILE clause, will result in an error message.

SHARED_DATAPART_PROCESSING

Syntax: SHARED_DATAPART_PROCESSING YES | NO
Variable: None
Default: NO

EXAMPLES: Optim High Performance Unload execution reports corresponding to an unload of a data-partitioned table from backups of a database having two database-partitions.

Example 1: Execution with the shared data-partition processing disabled:

               
INZM031I Optim High Performance Unload for Db2 06.01.00.001(130110) 
         64 bits 01/10/2013 (Linux lat186 3.1.0-1.2-desktop x86_64)
INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for data segment
       ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----10---+----11---+----12---+----13-
000001 GLOBAL CONNECT TO SAMPLE
000002 USING BACKUP CATALOG SAMPLE FROM "/home/i975";
000003 SHARED_DATAPART_PROCESSING NO
000004 ;
000005 UNLOAD TABLESPACE
000006 DB2 NO
000007 SELECT * FROM TB_DP;
000008 OUTFILE("outfile.%{source_node}")
000009 FORMAT DEL
000010 USING BACKUP DATABASE SAMPLE FROM "/home/i975";
000011 ;
000012

INZU462I HPU control step start: 17:43:26.808.
INZU463I HPU control step end  : 17:43:27.015.
INZU464I HPU run step start    : 17:43:27.015.
INZU557I The partition 0 backup image taken at 20121203092820 is involved in the unload (Type FULL OFFLINE DATABASE, Device DISK).
INZU410I HPU utility has unloaded 1 rows on lat186 host for I975.TB_DP in outfile.000.                                                                    
INZU557I The partition 1 backup image taken at 20121203092828 is involved in the unload (Type FULL OFFLINE DATABASE, Device DISK).
INZU410I HPU utility has unloaded 5 rows on lat186 host for I975.TB_DP in outfile.001.
INZU465I HPU run step end      : 17:43:27.060.                                  
INZI441I HPU successfully ended: Real time -> 0m0.251669s                      
User time -> 0m0.055991s : Parent -> 0m0.055991s, Children -> 0m0.000000s       
Syst time -> 0m0.275958s : Parent -> 0m0.275958s, Children -> 0m0.000000s

Example 2: Execution with the shared data-partition processing enabled.

In that case, a message signals that the feature was enabled.

INZM031I Optim High Performance Unload for Db2 06.01.00.001(130110) 
         64 bits 01/10/2013 (Linux lat186 3.1.0-1.2-desktop x86_64)
INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for data segment
       ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----10---+----11---+----12---+----13-
000001 GLOBAL CONNECT TO SAMPLE
000002 USING BACKUP CATALOG SAMPLE FROM "/home/i975";
000003 SHARED_DATAPART_PROCESSING YES
000004 ;
000005 UNLOAD TABLESPACE
000006 DB2 NO
000007 SELECT * FROM TB_DP;
000008 OUTFILE("outfile.%{source_node}")
000009 FORMAT DEL
000010 USING BACKUP DATABASE SAMPLE FROM "/home/i975";
000011 ;
000012

INZU462I HPU control step start: 17:43:26.808.
INZU463I HPU control step end  : 17:43:27.015.
INZU464I HPU run step start    : 17:43:27.015.
INZU618I The data-partitions processing is shared for the I975.TB_DP table
INZU557I The partition 0 backup image taken at 20121203092820 is involved in the unload (Type FULL OFFLINE DATABASE, Device DISK).
INZU557I The partition 1 backup image taken at 20121203092828 is involved in the unload (Type FULL OFFLINE DATABASE, Device DISK).
INZU410I HPU utility has unloaded 5 rows on lat186 host for I975.TB_DP in outfile.001.
INZU410I HPU utility has unloaded 1 rows on lat186 host for I975.TB_DP in outfile.000.                                                                    
INZU465I HPU run step end      : 17:43:27.060.                                  
INZI441I HPU successfully ended: Real time -> 0m0.251669s                       
User time -> 0m0.055991s : Parent -> 0m0.055991s, Children -> 0m0.000000s       
Syst time -> 0m0.275958s : Parent -> 0m0.275958s, Children -> 0m0.000000s