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.

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

What does db2 plan contain?

0 Answers  

What is the significance of DB2 free space and what parameters control it?

1 Answers  

where will u check for sqlcode ?

2 Answers   TCS,

How do I delete a table in db2?

0 Answers  

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

What are the disadvantages of using VARCHAR?

3 Answers  

Is the primary key a clustered index?

0 Answers  

What is a composite index and how does it differ from a multiple index?

1 Answers  

What is copy book?

1 Answers   Thomson Reuters,

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers