IBM Mainframe Forum

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.

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)