Re: What is the Fastest Unload process?

[login to unmask email]

Re: What is the Fastest Unload process?
(in response to Richard Pack)
Richard,
At VCU, we use BMC Unload Plus.
We are on OS/390 V2.5, DB2 V4.1.
Using IBM supplied utilities, an unload of the SIS+ prod database took 8-10
hours.
Using BMC Unload Plus V5.1, I can unload the same data in 35 minutes.
(Loading takes < 4 hours using BMC Load Plus, IBM's load took over 18 hours!)
I understand that the utilities have been improved in DB2 for OS/390 V5 & V6.
Good luck,




Sean O'Keefe
Virginia Commonwealth University
Administrative Systems/Applications Technical Services
Operating Systems Analyst
(804) 828-8415
[login to unmask email]



|--------+------------------------->
| | Richard Pack |
| | <[login to unmask email]|
| | ATE.MO.US> |
| | |
| | 12/16/1999 |
| | 01:06 PM |
| | Please respond |
| | to DB2 Data |
| | Base Discussion|
| | List |
| | |
|--------+------------------------->
>----------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: (bcc: Sean M O'Keefe/AC/VCU) |
| Subject: What is the Fastest Unload process? |
>----------------------------------------------------------------------------|





I am looking for feedback on what users have found to be the fasted unload
process. Has anyone found a third party unload that is much faster than
IBM's DSNTIAUL? I know that IBM is saying that they are making theirs to
be competitive with the vendors products. We need the data in the unload
format. Any feedback will be appreciated.

TIA

Richard Pack
State of Missouri
OA/DIS/SDC
Technical Support
Phone: 751-5203
fax: 522-8305
mailto:[login to unmask email]








Jim Knisley

Re: What is the Fastest Unload process?
(in response to Mike Holmans)
Richard,
We have been using BMC's Unload Plus for several years and have had no major
problems. It will unload into a variety of formats, including the standard IBM
unload format. It has a lot of features and functionality built into the
product. Our benchmarking has found it to be 5 - 8 times faster that DSNTIAUL
against the same table. I have read that IBM is improving the performance of
the unload utility in Version 6, but I have not had a chance to test it yet.
BMC (and most other third party vendors) achieves their speed by native VSAM
access to the datasets instead of via the DB2 data manager.

Jim





Richard Pack <[login to unmask email]> on 12/16/99 01:06:49 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Jim Knisley/TFG/HII)
Subject: What is the Fastest Unload process?



I am looking for feedback on what users have found to be the fasted unload
process. Has anyone found a third party unload that is much faster than
IBM's DSNTIAUL? I know that IBM is saying that they are making theirs to
be competitive with the vendors products. We need the data in the unload
format. Any feedback will be appreciated.

TIA

Richard Pack
State of Missouri
OA/DIS/SDC
Technical Support
Phone: 751-5203
fax: 522-8305
mailto:[login to unmask email]








Michael Ebert

Re: What is the Fastest Unload process?
(in response to sokeefe@VCU.EDU)
IBM's REORG UNLOAD EXTERNAL is much much faster if you want to unload an entire
tablespace. However, it does allow only row-level SELECTs with simple
conditions, and it does not operate at the partition level even when you specify
a PART clause (at least when I tested it half a year ago - there may be a fix
for that in the meantime). Recently there was also an announcement from IBM
about a new FAST UNLOAD; however I did not keep it and so cannot tell you the
details. It's probably somewhere on the IBM web site.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




From: Richard Pack <[login to unmask email]> on 16/12/99 18:06 GMT



Please respond to DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]


cc: (bcc: Michael Ebert/MUC/AMADEUS)




Subject: What is the Fastest Unload process?




I am looking for feedback on what users have found to be the fasted unload
process. Has anyone found a third party unload that is much faster than
IBM's DSNTIAUL? I know that IBM is saying that they are making theirs to
be competitive with the vendors products. We need the data in the unload
format. Any feedback will be appreciated.

TIA

Richard Pack
State of Missouri
OA/DIS/SDC
Technical Support
Phone: 751-5203
fax: 522-8305
mailto:[login to unmask email]








Mike Holmans

Re: What is the Fastest Unload process?
(in response to Michael Ebert)
There's an IBM unload which is considerably faster than DSNTIAUL, as long as
you're on V5 or above. My experience with REORG UNLOAD EXTERNAL is that it
runs about five times faster than DSNTIAUL assuming your output is to disk,
and uses 30% less CPU.

Mike Holmans
BT ISE Technical Design
[login to unmask email]

The information above is presented on an as is basis with no warranty
expressed or implied, especially if you're using a different machine and
database to mine, which I sincerely hope you are or we've got a huge
security breach

> -----Original Message-----
> From: Richard Pack [SMTP:[login to unmask email]
> Sent: Thursday, December 16, 1999 6:07 PM
> To: [login to unmask email]
> Subject: What is the Fastest Unload process?
>
> I am looking for feedback on what users have found to be the fasted unload
> process. Has anyone found a third party unload that is much faster than
> IBM's DSNTIAUL? I know that IBM is saying that they are making theirs
> to
> be competitive with the vendors products. We need the data in the unload
> format. Any feedback will be appreciated.
>
> TIA
>
> Richard Pack
> State of Missouri
> OA/DIS/SDC
> Technical Support
> Phone: 751-5203
> fax: 522-8305
> mailto:[login to unmask email]
>
>
>
>
>



Manas Dasgupta

Re: What is the Fastest Unload process?
(in response to Jim Knisley)
If you are at V5 at a certain level, you can try REORG...UNLOAD EXTERNAL.
I've found it to be significantly faster than DSNTIAUL....about 50% less CPU
and elapsed for the tests that I ran.

And its free!

Manas.

> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
> Richard Pack
> Sent: Thursday, December 16, 1999 1:07 PM
> To: [login to unmask email]
> Subject: What is the Fastest Unload process?
>
>
> I am looking for feedback on what users have found to be the fasted unload
> process. Has anyone found a third party unload that is much faster than
> IBM's DSNTIAUL? I know that IBM is saying that they are making
> theirs to
> be competitive with the vendors products. We need the data in the unload
> format. Any feedback will be appreciated.
>
> TIA
>
> Richard Pack
> State of Missouri
> OA/DIS/SDC
> Technical Support
> Phone: 751-5203
> fax: 522-8305
> mailto:[login to unmask email]
>
>
> To change your subscription options or to cancel your
> subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list can be reached
> at [login to unmask email]
>



craig patton

Re: What is the Fastest Unload process?
(in response to Manas Dasgupta)
I have used both products from BMC and CA/PLAT and with large volumes of
data, both are WAY faster than DSNTIAUL, especially for full unloads. When
using a where predicate, they are slower, but still faster than DSNTIAUL.
For small numbers of rows (less than millions) the differences are not worth
the purchase price. But for handling 10s of millions and more, there is NO
comparison and the products start to pay for themselves.

HTH,
Craig Patton
DB2 DBA


>From: Richard Pack <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: What is the Fastest Unload process?
>Date: Thu, 16 Dec 1999 10:06:49 -0800
>
>I am looking for feedback on what users have found to be the fasted unload
>process. Has anyone found a third party unload that is much faster than
>IBM's DSNTIAUL? I know that IBM is saying that they are making theirs to
>be competitive with the vendors products. We need the data in the unload
>format. Any feedback will be appreciated.
>
>TIA
>
>Richard Pack
>State of Missouri
>OA/DIS/SDC
>Technical Support
>Phone: 751-5203
> fax: 522-8305
>mailto:[login to unmask email]
>
>
>
>
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



Manas Dasgupta

Re: What is the Fastest Unload process?
(in response to Manas Dasgupta)
True, there is (or was) a problem with PART option in that the entire
tablespace is unloaded even if you specify PART n. But if you also specified
the SORTDATA option then it would unload by partition.

Manas.

> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
> [login to unmask email]
> Sent: Thursday, December 16, 1999 11:23 AM
> To: [login to unmask email]
> Subject: Re: What is the Fastest Unload process?
>
>
> IBM's REORG UNLOAD EXTERNAL is much much faster if you want to
> unload an entire
> tablespace. However, it does allow only row-level SELECTs with simple
> conditions, and it does not operate at the partition level even
> when you specify
> a PART clause (at least when I tested it half a year ago - there
> may be a fix
> for that in the meantime). Recently there was also an
> announcement from IBM
> about a new FAST UNLOAD; however I did not keep it and so cannot
> tell you the
> details. It's probably somewhere on the IBM web site.
>
> Dr. Michael Ebert
> DB2 Database Administrator
> aMaDEUS Data Processing
> Erding / Munich, Germany
>
>
>
>
> From: Richard Pack <[login to unmask email]> on 16/12/99 18:06 GMT
>
>
>
> Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
>
> To: [login to unmask email]
>
>
> cc: (bcc: Michael Ebert/MUC/AMADEUS)
>
>
>
>
> Subject: What is the Fastest Unload process?
>
>
>
>
> I am looking for feedback on what users have found to be the fasted unload
> process. Has anyone found a third party unload that is much faster than
> IBM's DSNTIAUL? I know that IBM is saying that they are making
> theirs to
> be competitive with the vendors products. We need the data in the unload
> format. Any feedback will be appreciated.
>
> TIA
>
> Richard Pack
> State of Missouri
> OA/DIS/SDC
> Technical Support
> Phone: 751-5203
> fax: 522-8305
> mailto:[login to unmask email]
>
>
> To change your subscription options or to cancel your
> subscription visit the
>
>
>
>
> To change your subscription options or to cancel your
> subscription visit the DB2-L webpage at
http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]



[login to unmask email]

Re: What is the Fastest Unload process?
(in response to Roger Miller)
Richard,

Haven't used this myself, but take a look at url
http://www-4.ibm.com/software/data/dbtools/db2unload/. This is IBM's new
High Performance Unload.

Cheers,
Jay


Jay Reavill
[login to unmask email]
IBM Global Services
Tampa, Florida
Tel: (813) 878-3525, Tie Line 8-427-3525
-----------------------------------------------------
Happiness is not around the corner.
Happiness is the corner.
- BMW
-----------------------------------------------------


Richard Pack <[login to unmask email]>@RYCI.COM> on 12/16/99 01:06:49 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: What is the Fastest Unload process?



I am looking for feedback on what users have found to be the fasted unload
process. Has anyone found a third party unload that is much faster than
IBM's DSNTIAUL? I know that IBM is saying that they are making theirs to
be competitive with the vendors products. We need the data in the unload
format. Any feedback will be appreciated.

TIA

Richard Pack
State of Missouri
OA/DIS/SDC
Technical Support
Phone: 751-5203
fax: 522-8305
mailto:[login to unmask email]








Roger Miller

Re: What is the Fastest Unload process?
(in response to craig patton)
Who wins the race? It depends upon the race track. There are many
different
kinds of unloads. I'll describe a couple of options and what we have from
IBM.
I'm sure that several vendors will be pointing out their advantages.

DSNTIAUL does pretty well where the optimizer chooses a good path and
you return a few hundred rows.

If you want to unload everything in the table space, then try the REORG
UNLOAD EXTERNAL option. This is V5, and you tend to need APARs

PQ19897 UQ23242 98/11/24 New REORG options - UNLOAD EXTERNAL
and DISCARD
PQ23219 UQ28920 99/04/27 REORG utility usability enhancements,
WHEN conditions

If you want to unload from an image copy, reformat extensively, we have a
separate product available: Here's the URL you can paste together:
http://www1.ibmlink.ibm.com/cgi-bin/master?xh=oHtyJOis62tpy$0USenGnN9332&request=announcements&parms=H%5f299%2d313&xhi=usa%2emain%7cannouncements%5e&xfr=N

If you are looking for more options, an UNLOAD utility has been showing up
in
our picture of what comes next.

Roger Miller



Richard Pack <[login to unmask email]>@RYCI.COM> on 12/16/99 10:06:49 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: What is the Fastest Unload process?



I am looking for feedback on what users have found to be the fasted unload
process. Has anyone found a third party unload that is much faster than
IBM's DSNTIAUL? I know that IBM is saying that they are making theirs to
be competitive with the vendors products. We need the data in the unload
format. Any feedback will be appreciated.

TIA

Richard Pack
State of Missouri
OA/DIS/SDC
Technical Support
Phone: 751-5203
fax: 522-8305
mailto:[login to unmask email]








[login to unmask email]

Re: What is the Fastest Unload process?
(in response to damcon2@US.IBM.COM)
Hi,

Several years ago we gave up the 3rd party fast utilities. The
way we accomplished the same work in the same time frame was to
run more concurrent jobs. So instead of running five OEM unloads,
reorgs, etc., that took two hours total we now run ten concurrent
IBM utility jobs that run in the same window. Divide and conquer
and save some dough!

Regards,

Michael Levine
Premier Data Services, Inc.


>I am looking for feedback on what users have found to be the fasted unload
>process. Has anyone found a third party unload that is much faster than
>IBM's DSNTIAUL? I know that IBM is saying that they are making theirs to
>be competitive with the vendors products. We need the data in the unload
>format. Any feedback will be appreciated.
>
>TIA
>
>Richard Pack
>State of Missouri
>OA/DIS/SDC
>Technical Support
>Phone: 751-5203
> fax: 522-8305
>mailto:[login to unmask email]
>
>
>


>
>



Richard Pack

What is the Fastest Unload process?
I am looking for feedback on what users have found to be the fasted unload
process. Has anyone found a third party unload that is much faster than
IBM's DSNTIAUL? I know that IBM is saying that they are making theirs to
be competitive with the vendors products. We need the data in the unload
format. Any feedback will be appreciated.

TIA

Richard Pack
State of Missouri
OA/DIS/SDC
Technical Support
Phone: 751-5203
fax: 522-8305
mailto:[login to unmask email]



Myron Miller

Re: What is the Fastest Unload process?
(in response to Mike_Levine@TEKHELP.NET)
I would agree that REORG EXTERNAL is a very good
option PROVIDED you don't have a lot of tables in the
tablespace and don't want just one table out of all of
them. If you have a very large number of tables and
some of them are pretty large (granted this is not a
good condition but is common with Peoplesoft and some
other products), it can be pretty combersome with
REORG EXTERNAL to get the data that you want.

Today, for large tables, both BMC and Platinum UNLOAD
products significantly outperform DSNTIAUL and can
handle the multiple tables per tablespace situation.
But they are costly products and a careful cost
benefit analysis needs to be performed.

In the future, who knows, its a moving area as all the
vendors are constantly and significantly improving
their products.

--- Roger Miller <[login to unmask email]> wrote:
> Who wins the race? It depends upon the race track.
> There are many
> different
> kinds of unloads. I'll describe a couple of options
> and what we have from
> IBM.
> I'm sure that several vendors will be pointing out
> their advantages.
>
> DSNTIAUL does pretty well where the optimizer
> chooses a good path and
> you return a few hundred rows.
>
> If you want to unload everything in the table space,
> then try the REORG
> UNLOAD EXTERNAL option. This is V5, and you tend to
> need APARs
>
> PQ19897 UQ23242 98/11/24 New REORG
> options - UNLOAD EXTERNAL
> and DISCARD
> PQ23219 UQ28920 99/04/27 REORG utility
> usability enhancements,
> WHEN conditions
>
> If you want to unload from an image copy, reformat
> extensively, we have a
> separate product available: Here's the URL you can
> paste together:
>
http://www1.ibmlink.ibm.com/cgi-bin/master?xh=oHtyJOis62tpy$0USenGnN9332&request=announcements&parms=H%5f299%2d313&xhi=usa%2emain%7cannouncements%5e&xfr=N
>
> If you are looking for more options, an UNLOAD
> utility has been showing up
> in
> our picture of what comes next.
>
> Roger Miller
>
>
>
> Richard Pack <[login to unmask email]>@RYCI.COM> on
> 12/16/99 10:06:49 AM
>
> Please respond to DB2 Data Base Discussion List
> <[login to unmask email]>
>
> Sent by: DB2 Data Base Discussion List
> <[login to unmask email]>
>
>
> To: [login to unmask email]
> cc:
> Subject: What is the Fastest Unload process?
>
>
>
> I am looking for feedback on what users have found
> to be the fasted unload
> process. Has anyone found a third party unload that
> is much faster than
> IBM's DSNTIAUL? I know that IBM is saying that
> they are making theirs to
> be competitive with the vendors products. We need
> the data in the unload
> format. Any feedback will be appreciated.
>
> TIA
>
> Richard Pack
> State of Missouri
> OA/DIS/SDC
> Technical Support
> Phone: 751-5203
> fax: 522-8305
> mailto:[login to unmask email]
>
>
> To change your subscription options or to cancel
> your subscription visit
> the DB2-L webpage at http://www.ryci.com/db2-l. The
> owners of the list can
>
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can
>

__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one place.
Yahoo! Shopping: http://shopping.yahoo.com



Elaine Morelli

Re: What is the Fastest Unload process?
(in response to Myron Miller)
DSNTIAUL is not an unload utility. It is a sample program that everyone
uses to do unloads. IBM REORG UNLOAD EXTERNAL is a faster method of
unloading using the IBM base utilities. IBM also markets a DB2 High
Performance Unload utility that is an additionally priced product.



Tim Lowe

Re: What is the Fastest Unload process?
(in response to Elaine Morelli)
Richard,
The primary problem that I have had with using REORG UNLOAD EXTERNAL is the
authorization required. You have to have REORG authorization on the database in
order to unload a table with this. I would rather not grant someone reorg
authority on a database to unload a table, so this does have a limited use.

Other than that, some of my tests have shown REORG UNLOAD EXTERNAL to perform
better than Platinum "fast unload" (for 0% of the price).
With small unloads (small tables or predicates reducing the number of rows),
then DSNTIAUL can also perform better than Platinum "fast unload".
But, as Roger said, it depends.

It is not hard to create "benchmarks" that demonstrate any one of these is the
"fastest". (Just use the "right" example.)

When this subject comes up, one feature that people have liked best about the
"third party" DB2 unlad tools is that they can unload from an image copy.
Previously, IBM could not do this. However, IBM recently announced their "DB2
high-performance unload" tool that can do this. (I heard that they bought
it from a third-party vendor, but I do not know who.)

Thanks,
Tim Lowe

P.S. I have seen people people using "fast unload" to unload to a tape and
taking much more time mounting the tape than they took unloading the few rows
that they wanted. (A waste of a "fast" utility and of a tape.)



Isaac Yassin

Re: What is the Fastest Unload process?
(in response to suthep thampranee)
Hi,
Please don't forget that DSNTIAUL is using SQL to access data. It's older
versions had an incorrect way to calculate blocksize for the output file so it
needed many I/O's to do it which prolonged the run (i used to manually fix the
assembler code to make it run much faster just by changing the blocksize
calculations) - nowadays
the calculation are ok. 3rd party products don't use SQL to read the data but
access the VSAM CI by themselves (and then there's the need to flush buffers
from memory to get latest data changes and handle all changes done while
running) - so you need some "beef" in the table before it's shows the benefit.
Then comes the question of price (+ maintenance fees). So we go into "computer
economics" now...



--
Isaac Yassin

DBMS & IT Consultant

Tel: +972 9 9505172
Cel: +972 54 452793
Fax: +972 9 9560803



suthep thampranee

Re: What is the Fastest Unload process?
(in response to Tim Lowe)
Dear DB2 Specialists,
In my opinion IBM REORG UNLOAD EXTERNAL could not
unload with conditions for example,unload table owner.name where name like
'?%'
but DSNTIAUL could be done
JOE



Craig Mullins

Re: What is the Fastest Unload process?
(in response to Isaac Yassin)
There has been a lot of discussion the past couple of days on UNLOAD speed.
I just wanted to drop in my two cents worth to say that speed, though
probably the single most important feature of an UNLOAD utility, is only one
of many factors that should be considered. The goal of UNLOAD, as I see it,
is to move consistent data from DB2 tables into flat files as
non-disruptively to your overall environment as possible. To accomplish
this, some things to look for (in addition to speed) include:
* the ability to unload from an image copy or DSN1COPY instead of the
table or tablespace
* the ability to unload from multiple tables or tablespaces in a
single job
* the ability to unload from aliases, views, and synonyms
* flexibility - one product with one interface to process multiple
types of unloads efficiently; do you really want to have to try to figure
out which of two or three or four unload options to run based on the type of
processing?
* the ability to generate LOAD cards for subsequent loading of this
data back to the same or another table
* Efficiency - does the "right thing" out of the box to ensure optimal
performance; (such as, correct blocking, processing multiple SELECT
statements in a single pass of the data, ) - in other words, it was designed
properly
* the ability to properly convert data types and to create multiple
types of output files (comma-delimited, fixed length, variable length, LOAD
format, DSNTIAUL format, etc.)
(Of course, there are other features you might want to look for but I will
limit the size of the list so I do not clutter up DB2-L...)

As DBAs most of us want solutions that are easy to implement, easy to use,
and efficient when operating. The bottom line with third party unload tools,
such as UNLOAD PLUS from BMC Software, is that you have to determine if the
ROI for purchasing the solution is worth it to you. If it keeps your data
more available, keeps your systems running more smoothly, streamlines your
DBA processes, and/or helps you implement e-business requirements
(24x7x366), then these products may be cheap if your only option is a "free"
tool that is not as fast, functional, or easy to use. Let's face it, "free"
software is only "free" if your time is worthless.

And now, a quick plug for BMC's UNLOAD PLUS. BMC is committed to continually
providing leading edge and efficient "High Performance Utilities." Evidence
of this is the Parallel Sysplex support now available in UNLOAD PLUS. The
sysplex environment allows for the distribution of tasks over a greater
number of processors. This availability to processors can reduce the elapsed
time required to perform the unload even more than what UNLOAD PLUS achieves
on a single system (UNLOAD PLUS can multitask the unload in a single-system
multiprocessor environment, too, but the sysplex environment can be more
efficient because multiple processors can be deployed).

To exploit the benefits of the sysplex environment, UNLOAD PLUS utilizes XIM
(a BMC technology) to distribute work and communicate with it in the sysplex
environment. UNLOAD PLUS distributes tasks, via XIM, to processors within
the sysplex environment in what is termed units of work (UOW). A UOW is
essentially a multitasking unload process. It is a collection of tasks that
unloads a given set of partitions or tablespaces. For each output data set
that UNLOAD PLUS produces, a unique unit of work is created to produce the
output in that data set.

For more information on UNLOAD PLUS from BMC Software, use the following
URL:
http://www.bmc.com/products/proddocview.html?id=2205&l=en&r=Americas&c=

Cheers,
Craig S. Mullins
Director, DB2 Technology Planning
[login to unmask email]
http://www.craigsmullins.com
BMC Software
http://www.bmc.com



John Arbogast

Re: What is the Fastest Unload process?
(in response to Craig Mullins)
I heard the IBM "Fast Unload" was purchased from
Infotel. Dunno if this is correct.

--- [login to unmask email] wrote:
> Richard,
> The primary problem that I have had with using REORG
> UNLOAD EXTERNAL is the
> authorization required. You have to have REORG
> authorization on the database in
> order to unload a table with this. I would rather
> not grant someone reorg
> authority on a database to unload a table, so this
> does have a limited use.
>
> Other than that, some of my tests have shown REORG
> UNLOAD EXTERNAL to perform
> better than Platinum "fast unload" (for 0% of the
> price).
> With small unloads (small tables or predicates
> reducing the number of rows),
> then DSNTIAUL can also perform better than Platinum
> "fast unload".
> But, as Roger said, it depends.
>
> It is not hard to create "benchmarks" that
> demonstrate any one of these is the
> "fastest". (Just use the "right" example.)
>
> When this subject comes up, one feature that people
> have liked best about the
> "third party" DB2 unlad tools is that they can
> unload from an image copy.
> Previously, IBM could not do this. However, IBM
> recently announced their "DB2
> high-performance unload" tool that can do this.
> (I heard that they bought
> it from a third-party vendor, but I do not know
> who.)
>
> Thanks,
> Tim Lowe
>
> P.S. I have seen people people using "fast unload"
> to unload to a tape and
> taking much more time mounting the tape than they
> took unloading the few rows
> that they wanted. (A waste of a "fast" utility and
> of a tape.)
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can
>

__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one place.
Yahoo! Shopping: http://shopping.yahoo.com



Roger Miller

Re: What is the Fastest Unload process?
(in response to John Arbogast)
APAR PQ23219 adds many of the other predicates, including the LIKE
predicate
to REORG UNLOAD EXTERNAL.

Roger