What is COPY PENDING status?

Answer Posted / vat

Applies to REORG as well.. The TS/partition will be
in 'COPY' (Copy Pending status) unless you take an inline
image copy OR specify SHRLEVEL REFERENCE/CHANGE OR sepcify
LOG YES

To resolve this, you can

1. Start Access(Force)
OR
2. Repair
OR
3. Take an image copy

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between drop table and delete table?

550


What is temporal table in db2?

601


Explain how can you do the explain of a dynamic sql statement?

649


What is the difference between spufi and qmf?

637


Explain about mirror activator disk mirroring?

558






What is a db2 collection?

603


Is ibm db2 open source?

584


What are the benefits of using the db2 database?

658


What is the difference between cursor and select statement?

613


How can you count the number of rows from a table tab?

633


What is load replace in db2?

560


What is a db2 schema?

760


What is an instance database?

598


What kind of database is db2?

569


can all users have the privilage to use the sql statement select * (dml)?

638