View previous topic :: View next topic |
Author |
Message |
bufbooth Beginner
Joined: 15 Mar 2005 Posts: 8 Topics: 4
|
Posted: Tue Apr 05, 2005 10:13 am Post subject: Fastest DB2 unload utilities |
|
|
Hello, could anyone comment on what the fastest DB2 database unload utilities are on the market for obtaining data from large (millions of rows of records) databases? I know about the DSNTIAUL utility, but do not know how it compares to some of the other third party utilities.
Thanks,
Dennis... |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Tue Apr 05, 2005 10:34 am Post subject: |
|
|
bufbooth,
IBM now has a new utility UNLOAD that delivers better performance and more flexibility than DSNTIAUL. It supports both Tablespace and Image Copy as the source and allows unloading of multiple partitions in parallel. You can provide field selection for the unloaded data and the ordering and formatting options via SQL-like syntax. UNLOAD also provides for record sampling and character encoding. The new UNLOAD utility can dynamically allocate both sysrec and syspunch datasets ( dynalloc sysrec and syspunch ).
Check this link for a detailed explanation of the utility
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH13/2.27?DT=20020826194002
The DB2 High Performance Unload for z/OS also outperforms the DSNTIAUL and is used for unloading large data.
Check this link for explanation of the utility
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/INZUGB11/CCONTENTS
Also CA's Fast Unload outperforms DSNTIAUL
Hope this helps...
Cheers
kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
bufbooth Beginner
Joined: 15 Mar 2005 Posts: 8 Topics: 4
|
Posted: Tue Apr 05, 2005 3:32 pm Post subject: BMC Unload Plus for DB2 |
|
|
Hello,
I just found out that I have the utility "BMC Unload Plus for DB2", however, I cannot find any documentation on how it compares to DSNTIAUL or UNLOAD.
Thanks for any help,
Dennis... |
|
Back to top |
|
|
coolman Intermediate
Joined: 03 Jan 2003 Posts: 283 Topics: 27 Location: US
|
Posted: Tue Apr 05, 2005 4:29 pm Post subject: |
|
|
BMC is good in the sense that it offers lot of advantages to a DBA in similarity to the IBM's unload. It uses a program BMCUNLD for unloading the data.
________
drug test |
|
Back to top |
|
|
|
|