IBM Mainframe Forum

Hi,
I'm trying to load a table using Load utility.Load job runs successfully and all records are loaded however sysout displays a warning "Table is in copy pending status". What does this means??
I can see all the records in the table.Does this means I can't update this table?
How to remove this status?
Please help me.

Thanks,
Vikram

Hello Vikram and welcome to the forum,

Does this means I can't update this table?
How to remove this status?

An Image Copy on a table needs to be taken, In this status, the table is available only for queries. You cannot update this table. To remove the COPY PENDING status, you take an image copy or use REPAIR utility.

Hi Vikram,
yes Vikram you are absolutely right after this warning message you are not able to update this page. To get rid from "copy pending status" warning message you need to use the repair utility. for this situation I will reccomend you to use the DB2 database repair utility. the osftware will really help you to updat the table without any hassle.