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.

How will you return the number of records in table?

0 Answers  

How to design maps

1 Answers   Virtusa,

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

How to check last update on table in db2?

0 Answers  

Are views updatable ?

4 Answers  

Give the COBOL definition of a VARCHAR field.

2 Answers  

What are the disadvantages of using VARCHAR?

3 Answers  

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

where will u check for sqlcode ?

2 Answers   TCS,

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,