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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / sasi

Answer Posted / sasi

use repair utility
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCOPYPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NORCVRPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCHECKPEND

Is This Answer Correct ?    17 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about mirror activator disk mirroring?

1064

What is a system catalog table in db2?

1246

Explain about rct in db2?

1166

How can you classify the locks in db2?

1135

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1147

What is the purpose of using commit?

1154

What is a cursor in programming?

1115

What are the benefits of using the db2 database?

1295

Who uses db2?

1114

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1155

What is db2 catalog database?

1092

How can you find out the # of rows updated after an update statement?

1155

What is netezza database?

1082

What is a plan and package in db2?

1155

Explain in detail about buffer manager and its functionalities?

1146