Page 1 of 1

Unload of a big Table

PostPosted: Fri Sep 23, 2011 1:57 pm
by samb01
Hello,

i have to unload a table which contain 570 Millions rows.

But before i would like to know how much time does it take ?

Did an unlod put locks on a tbale durring the unload.

Il the Unload abended, in which state is the table (accessibel ?)

Thanks for your help.

Re: Unload of a big Table

PostPosted: Fri Sep 23, 2011 3:13 pm
by GuyC
unload takes shared-locks (read-locks).
and does not affect table accessibility.

If you do have imagecopies (which I should hope) you might want to consider UNLOAD FROMCOPYDDN.

Re: Unload of a big Table

PostPosted: Fri Sep 23, 2011 6:31 pm
by samb01
OK.

Thanks.