i would use hpl deluxe mode
since you have HDR you can not use express mode!!!!!
you can not use load this most likely will run out of locks and gives
a longtrx rollback; same for onload,
you could use dbload or write your own stuff.

Speeding it up...
if you can bounce the engine you could Maximize BUFFERS, set LOGBUF
big, maybe 4096 ...
set LRU MAX and mindirty to 99 ,

and use your own
checkpoints
using:
dbaccess sysmaster <<!
create procedure generatechkpt()
define dirty decimal (4,3);

while (1=1)

       select ( sum(lru_nmod) / sum ( lru_nfree + lru_nmod ))
                               into dirty
       from syslrus           ;

       if (dirty < 0.75 ) then
               system "sleep 1";
       else
               system "onmode -c";
       end if
       end while ;
end procedure;

execute  procedure generatechkpt();
!

that may speed up the thing.

If the data you need to reorg is more then half your database, you
could consider switching of HDR, use HPL express mode no conversion
and when all that is done, reset up HDR.

hmmm >  These tables have more than 50 extents by recreating what I
need to resize the extents and reduce the number of extents.

i would start to worry if they are getting close to the limit which is
about 200 so when a table has more then 150 extents, i would
start planning for the above.

Superboer.

way fast=http://www.clipjes.nl/clip/nederlands/n/normaal_-
_oerend_hard.html