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.