Answer / gopinath

The correct syntax is :

START DATABASE(Dbname) SPACENAM(Tbspacename) ACCESS(force)

Answer / mithun suresh

We can also remove COPYPENDING using REPAIR command

REPAIR SET TABLESPACE LVPERCFD.LVPCNTRS NOCOPYPEND

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)

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.

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

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.

how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,

What is a db2 schema?

0 Answers  

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

What is db2 bind process?

0 Answers  

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

What is meant by isolation level?

3 Answers  

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

When would you prefer to use VARCHAR?

3 Answers  

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

What is the function of buffer manager?

1 Answers