Unloading objects by using Db2 High Performance Unload

You can use Db2® High Performance Unload with the MIG function to unload Db2 objects more efficiently.

Before you begin

You must have Db2 High Performance Unload installed.

About this task

Although Db2 Admin Tool does not run HPU in z/OS storage key 7, this situation does not cause any problems in running HPU. If you receive warning message INZU241I from HPU, you can ignore this message unless abends occur.

Procedure

To unload objects by using Db2 High Performance Unload :
  1. On the Migrate Table Spaces (ADB28S) panel, issue the NEXT primary command.
  2. On the Migrate Parameters (ADB28M) panel, issue the UO primary command.
  3. On the Change Utilities Options (ADB2UOPS) panel, enter the HPU option.
    Figure 1. Change Utilities Options (ADB2UOPS) panel
    ADB2UOPS  ---------------- Change Utilities Options ---------------- 12:29
Option ===>                                                                    
                                                                               
Select one of the following, then press Enter.                                 
                                                                               
   C - Image copy                                                              
  KD - Check data                                                              
   M - Modify                                                                  
   O - Reorg tablespace                                                        
  OI - Reorg index                                                             
   R - Runstats tablespace                                                     
   U - Unload                                                                  
 HPU - High Performance Unload                                                 
   L - Load
  4. On the Specify Utility Options - HPU (ADBPUSH) panel, specify values for your HPU parameters.
    Figure 2. Specify Utility Options - HPU (ADBPUSH) panel
    ADBPUSH n -------------- Specify Utility Options - HPU ------------- 12:35
Command ===>                                                                   
                                                                               
Execute utility on migrate object                                              
                                                                               
  using the following options:                                                 
                                                                               
DB2 . . . . . . . . . . . YES        (Yes, No, Force)                          
LOCK  . . . . . . . . . . NO         (Yes/No)                                  
QUIESCE . . . . . . . . . NO         (Yes/No)                                  
PARALLELISM degree for:                                                        
  Max partitions  . . . .            (1-65535)                                 
  DB2 SELECT statements . 4545       (1-65535)                                 
  Multiple table spaces . 222        (1-65535)                                 
SPANNED . . . . . . . . . NO         (Yes/No)                                  
  ENFORCE COLUMN ORDER  .            (Yes/No)                                  
FORMAT  . . . . . . . . . VARIABLE   (1-DELIMITED, 2-DSNTIAUL, 3-EXTERNAL,     
                                      4-INTERNAL,  5-VARIABLE)                 
  DELIMITED                                                                    
    SEP . . . . . . . . . 'P'        (One byte or X'dd')                       
    DELIM . . . . . . . . X'FF'      (One byte or X'dd')                       
    NULL DELIM  . . . . . YES        (Yes/No)                                  
  DSNTIAUL                                                                     
    STRICT  . . . . . . .            (Yes/No)                                  
    LIKE                                                                       
      Schema  . . . . . . SYSADM    >           (default is MARLINO)           
      Name  . . . . . . . PJTBEMP2            > (? to look up)                 
  VARIABLE  . . . . . . . END        (End/All)                                 
    LIKE                                                                       
      Schema  . . . . . . SYSADM    >           (default is MARLINO)           
      Name  . . . . . . . PJTB1P              > (? to look up)
  5. Press PF3 to return to the Migrate Parameters (ADB28M) panel, where you can continue with the MIG process.