Copy pending status in DB2??



IBM's flagship relational database management system

Copy pending status in DB2??

Postby vikram_saini_2008 » Tue Oct 28, 2008 11:50 pm

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
vikram_saini_2008
 
Posts: 1
Joined: Tue Oct 28, 2008 11:41 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Copy pending status in DB2??

Postby dick scherrer » Wed Oct 29, 2008 1:21 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Copy pending status in DB2??

Postby bipsa » Sat May 22, 2010 3:42 pm

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.
bipsa
 
Posts: 1
Joined: Sat May 22, 2010 3:34 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post