Unload of a big Table



IBM's flagship relational database management system

Unload of a big Table

Postby samb01 » Fri Sep 23, 2011 1:57 pm

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.
samb01
 
Posts: 431
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Unload of a big Table

Postby GuyC » Fri Sep 23, 2011 3:13 pm

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.
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: Unload of a big Table

Postby samb01 » Fri Sep 23, 2011 6:31 pm

OK.

Thanks.
samb01
 
Posts: 431
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post