INZUTILB
Vs DSNUTILB, in DB2 v10 (NFM) for z/OS
a. INZUTILB is the DB2 High
Performance Unload utility that’s used to unload Data in Batch mode.
b. DSNUTILB is the
utilities Batch program which can be used for Unloading the Data from the DB2
Tables.
I executed both Utilities
on the largest Table we have in Production, to benchmark the performance.
And, below are the
Performance details.
Largest Prod Table
(Data Size: 104.43 GB)
|
Type
|
Elapsed Time (in Mins)
|
CPU Time (in Mins)
|
Recs Unloaded
|
INZUTILB
|
37.7
|
5.70
|
1,127,516,985
|
|
DSNUTILB
|
63.9
|
54.96
|
1,127,516,985
|
You can notice the
difference in both Elapsed & CPU times for the Utilities.
DB2 HPU is very helpful in
unloading very huge Tables on Mainframes.
Below JCL can be used for
unloading the Data using DB2 HPU.
//DB2HPU01 JOB
(S,0812,00000,0000000),'HIGH PERFORMANCE UNLOAD',
//
MSGCLASS=X,CLASS=E,NOTIFY=&SYSUID
//*
//UNLOAD EXEC
PGM=INZUTILB,REGION=0000M,COND=(4,LT),
//
PARM=(<system name>,)
//STEPLIB DD
DSN=XXX.XXXXXXXX,DISP=SHR
//
DD DSN=XXX.XXXXXXXX,DISP=SHR
//UTPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
TEMPLATE UNLDD
DSN
'&DB..&SN..A&PART..&UTILNAME.'
UNIT SYSDA
SPACE CYL
DISP (MOD,CATLG,CATLG)
UNLOAD TABLESPACE
<creator>.<tsname>
OPTIONS
NULL X'6F' X'00'
NULLID YES
NULLPOS AFTER
DATE DATE_DB2
TIME TIME_DB2
TIMESTAMP
TIMESTAMP_B
PIC ( '-' , LEAD
, '.' , '00.0' )
LENGTHBYTE YES
LENGTH REAL
UNLDDN UNLDD
/*
No comments:
Post a Comment