Answer / sasi

use repair utility
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCOPYPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NORCVRPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCHECKPEND

Answer / kiran bhamare

Hi,

You can do same by following tric.
STOP database and start it again using DB2 commands.
1)-DIS DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to dsisplay status of DB
2)-STOP DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to stop database.
3)-START DATABASE (DATABASENAME) SPACE (TABLESPACENAME) ACC
(FORCE)
to start database.

Answer / 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

Answer / sudipta

sorry the last answer is

db2= >> set integrity for <table_name> all immediate unchecked

Answer / suresh

we need to clear the flags of that particular utilities and
try to load the data into the database.

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

What does db2 plan contain?

0 Answers  

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,

Is there any advantage to denormalizing DB2 tables?

1 Answers  

Is the primary key a clustered index?

0 Answers  

When Can you be sure that a query will return only one row?

4 Answers   IBM,

i want to delete 20th million record how ?

4 Answers   IBM,

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  

What is db2 command?

0 Answers