Monday, September 26, 2011

DB2: Sample job for DB2 High Performance Unload utility


IBM DB2 High Performance Unload (DB2 HPU) is a high-speed DB2 utility for unloading DB2 tables from either a table space or from an image copy. It works outside DB2, directly accessing the VSAM or sequential files that contain the table space or image copy data set. DB2 HPU also provides superior performance, especially in terms of CPU and elapsed time.

Sample job for this utility is below

//STEP1    EXEC PGM=INZUTILB,REGION=0M,DYNAMNBR=99,                   
//         PARM='DBXT,UNLD'                                       
//STEPLIB  DD  DSN=DBDCXXX.HPU.DBXT.SINZLINK,DISP=SHR                 
//         DD  DSN=DBDCXXX.DB2.DBXT.SDSNEXIT,DISP=SHR                 
//         DD  DSN=DBDCXXX.DB2.DBXT.SDSNLOAD,DISP=SHR                 
//*                                                                    
//SREC001  DD DSN=output dataset
//            DISP=(,CATLG),UNIT=(SYSDA,59),BUFNO=100,                
//            SPACE=(CYL,(50,50),RLSE)                                
//*                                                                   
//SYSPUNCH DD DSN=SYSPUNCH dataset…
//            DISP=(,CATLG),UNIT=(SYSDA,15),                          
//            SPACE=(CYL,(1,5),RLSE)                                  
//UTPRINT  DD  SYSOUT=*                                               
//SYSPRINT DD  SYSOUT=*                                               
//SYSIN    DD  *                                                      
  UNLOAD TABLESPACE                                                   
  DB2 YES  
  SELECT  *                              
  FROM MY.TAB;
  OUTDDN (SREC001)                       
  FORMAT DSNTIAUL                        
  LOADDDN SYSPUNCH                       
/
DB2 parameter specifies the processing to be performed for SELECT statements that are not supported by DB2 HPU. Value YES Indicates that if the SELECT statement is too complex to be handled directly by DB2 HPU, DB2 is called to extract the rows. A warning message (severity 4) is issued to report this occurrence. Value NO Indicates that the SELECT statements must be processed by DB2 HPU. If a SELECT statement is not supported by DB2 HPU, an error occurs and processing stops.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.