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

On which levels locks can be applied?

1136

What is cloudant database?

1103

How to access db2 tables in mainframe?

1056

Who uses db2?

1053

What is copy pending and check pending in db2?

1007

Describe major components of db2?

1095

Name the various locking levels available?

1098

What is view db2?

1083

What is the physical storage length of timestamp data type?

1101

How is deadlock resolved?

1152

What is db2 stogroup?

1164

What is the difference between plan and package in db2?

1119

How can deadlocks be resolved?

943

When the like statement is used?

1225

How can record locking be achieved in those DB2 versions which do not support it?

1081