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

What does db2 plan contain?

962

Why do we need reorg in db2?

924

What are the various isolation levels possible?

1051

What is the meaning concurrency in the db2 database?

1061

Name the lockable units in DB2?

1075

What is the difference between using bind () and rebind () methods of naming class?

1331

What is scrollable cursor in db2?

1000

How do you find the maximum value in a column in db2?

1057

What is collection in db2 bind?

964

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

987

What are the contents of a dclmgen?

1067

What is the difference between cursor stability and repeatable read isolation levels?

1116

What is a cursor in programming?

1016

When the like statement is used?

1157

What is coalesce in db2?

1058