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

What is sqlca’s maximum length?

1152


What is the maximum number of columns in a db2 table?

1266


What is dbrm? When it will be created?

1010


What is difference between rollback and commit?

1133


What do you mean by storage group (stogroup)?

1022


Is db2 relational database?

962


What is query_cache_limit?

954


What is db2 look?

1007


What is bufferpool in db2?

1026


Give the name of some fields form sqlca.

1056


is it compulsory commitment control in journal?

2459


What are the two types of logging in the db2 database? Explain them.

1055


What is data manager?

1028


How can you classify the locks in db2?

1077


How is deadlock resolved?

1123