Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what needs to be done if a table is in copy pending / check
pending status?

Answer Posted / sudipta

first ckeck the ststus of the table by using the query:-

load query table <tab_name>;

load query table <tab_name> set all immidiate unchecked;

after the command execute all pending state will be removed

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

define clustering index.

1031


What is reorg?

1162


Explain in brief how does db2 determine what lock-size to use?

1045


What is a page in db2?

1027


What is the use of with ur in db2?

1058


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2727


What is coalesce in db2?

1136


What is bind plan?

1049


What is db2 look?

1026


Can there be more than one cursor open for any program?

1169


What is bind package and plan in db2?

1053


What is universal database?

1073


How and when does the db2 enforces the unique key?

1084


Mention the location where the output received from explain statement is stored.

1128


What is the purpose of using commit?

1100