Difference of INSERT thought LOAD and Normal INSERT



IBM's flagship relational database management system

Difference of INSERT thought LOAD and Normal INSERT

Postby fornanthakumar » Fri Feb 08, 2013 5:12 pm

Hi,

Just an query,

1. I have noticed that , when an TABLE in COPYPENDING stage

--> I can insert the data through LOAD anyway the table will again put in COPYPENDING but the desired data loaded into the table.
--> Unfortunately i could not insert the data through DB2-cOBOL PRogram or SPUFI..

Can anyone explain why the issue is.
Regards,
Nanthu.Y.
fornanthakumar
 
Posts: 69
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Difference of INSERT thought LOAD and Normal INSERT

Postby GuyC » Fri Feb 08, 2013 9:42 pm

First you have to understand what copypending means and why :
Copypending means that the table is in a unrecoverable state. If an error occurs on that table, it will be impossible to rollback. So DB2 does not allow you to do update or inserts.
It is perfectly possible to do some more unrecoverable stuff to the table like Load (log no)
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


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post