Page 1 of 1

Copy pending status in DB2??

PostPosted: Tue Oct 28, 2008 11:50 pm
by vikram_saini_2008
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

Re: Copy pending status in DB2??

PostPosted: Wed Oct 29, 2008 1:21 am
by dick scherrer
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.

Re: Copy pending status in DB2??

PostPosted: Sat May 22, 2010 3:42 pm
by bipsa
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.