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.

What does runstats do in db2?

0 Answers  

What is a clustered index?

1 Answers  

What is a db2 cursor?

0 Answers  

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

explain about index with examples

2 Answers   Syntel,

What is explain in db2?

0 Answers  

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

What is an intent lock?

3 Answers  

Define declaration generator (dclgen).

0 Answers  

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

2 Answers   IBM,

What are PACKAGES ?

3 Answers  

In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

2 Answers