Copy Data on DB2 - emphasis on speed

This is in light of the excellent post - https://www.lawsonguru.co...to-test-environment/


We are on DB2 and we currently have an expsysdb/impexp script in place.  It takes a couple hours all told.


I've been trying to reduce the time, so all my questions here have that in mind - how to make the data copy go faster.


I have two leads:


1) db2move with the COPY option


unfortunately this takes about as much time as expsysdb/impexp.  Is this typical?  I just did a straight LOAD_ONLY mode, haven't tried dropping data/indexes manually yet...  Do you know of any way to speeds this up?


2) db2 load from cursor (I haven't tried nicknames, do not know which wrapper to use for the create server, and all docs say cursors are faster than nicknames anyway)


this is the most promising.  It takes about 4 minutes to copy gltrans, which is almost half of our data right there.  So, you would think I can transfer all my data in 10 minutes or so, compared to db2move's 2 hours?  That's what I thought, and I was wrong.


Unfortunately, regardless of table size, every db2 load from cursor has ~10 seconds of overhead, even for empty tables.  (I'm guessing this has to do with logging in or re-setting up the cursor somehow...) so with ~1700 tables, even if they're all empty, I'm looking at 4+ hours


Again, my question is, can I make any of this work faster?  Are these typical results?  Do you have any other leads to make data replication faster on DB2?  Perhaps some fee tools?


Thanks,
Phil