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 is buffer pool and list some of them?

1007

What is the connection string to connect to the DB2 Database ?

1093

How to create db2 table in mainframe?

1137

What is clone table?

1029

How to test SQL -911 error while developing COB-DB2 program

7530

How do I add a column to a table in db2?

1094

How do you stop a db2 database in linux?

993

What is the syntax for seeing the columns and data types of a table in the db2 database?

1146

What is dbrm in db2 database?

1093

Which command is used to remove all rows from a table?

1091

Is db2 a programming language?

1032

What is the use of predicate?

1025

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1027

What is db2 command?

1013

What is copy pending status in db2?

1104