What is the quickest way to dump a large d2 table? I would prefer not to use export, because its to slow. Is there an export equivalent to the load command ?

Thanks

The only thing I know of that bypasses the db engine to dump data is db2dart, which lets you dump stuff in delimited ASCII, but that's not done for efficiency - it's for emergency recovery when you don't have a backup.

I think you're stuck with EXPORT... which should be very fast?

agree with Petruk, and don't use db2dart(read carefully before using it)

regards,

mujeeb