Interested to Buy Any Domain ? << Click Here >> for more details...
What is COPY PENDING status?
- 6 Answers
- 36979 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gopinath
The correct syntax is :
START DATABASE(Dbname) SPACENAM(Tbspacename) ACCESS(force)
| Is This Answer Correct ? | 17 Yes | 5 No |
Answer / mithun suresh
We can also remove COPYPENDING using REPAIR command
REPAIR SET TABLESPACE LVPERCFD.LVPCNTRS NOCOPYPEND
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / sabahat khan
any table space will be in copy pending status
After a load is performed on the DB2 table,with log no
parameter
or
if load is performed without taking an image copy
or
if the job abend during load
or
if NOCOPYPEND parameter is not specified in syspunch dataset
in all of the above scenario our table space will be in
COPYPENDIND status.
-START(DBname)TBSPACE(Tablespace)ACCESS(FORCE)
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / rshk
After a load is performed on the DB2 table, it will be in
Copy pending status. When the table is in copy pending
status, you cannot access the table. In order to release the
table from copy pending status, we need to force complete it
using the Db2 command:
-START(DBname)TBSPACE(Tablespace)ACCESS(FORCE)
Pls check the syntax of the above command.
| Is This Answer Correct ? | 14 Yes | 8 No |
Answer / 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 |
Answer / dalwinder singh
A table is load pending state if a load operation that has
been active on the table is aborted before the data could
be committed. To return the table to Normal state, invoke a
load terminate, load restart, or load replace operation.
| Is This Answer Correct ? | 3 Yes | 0 No |
How many clustering indexes can be defined for a table?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What r the comman abends in db2, jcl and cobol???????
What is the maximum size of a char data type in db2?
What is the purpose of the QUIESE Utility?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is difference between isnull and coalesce?
When can an insert of a new primary key value threaten referential integrity?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
How can you find out the # of rows updated after an update statement?
How to handle null values in db2
What is buffer pool in the db2 database?
COBOL 
