load with cursor VS. Pipe

[db2admin]

Hello,

I am wondering if someone have done comparison of loading data using
cursor VS. Pipe.
Please share your experience. which one is faster ?

regards

[Ian]

Re: load with cursor VS. Pipe

db2admin wrote:

Hello,
>
I am wondering if someone have done comparison of loading data using
cursor VS. Pipe.
Please share your experience. which one is faster ?

By "loading data using a pipe", do you mean something like:

mkfifo apipe
db2 "export to apipe of del select * from table"
db2 "load from apipe of del replace into another_table"


If so, I can't imagine how this could be faster than load from cursor.

DB2 has to externalize the data it writes to the pipe, vs. doing
everything in memory inside the engine (with a cursor).

For example, timestamp takes only 10 bytes to store internally, but
when externalized it's 26 bytes. There's similar gains for all numeric
data types as well as date/time.


Ian Bjorhovde