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.

What is pagespace?

1 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

Which component is used to execute the sql statements?

0 Answers  

---

What language is db2 written in?

0 Answers  

---

What is an access path?

3 Answers  

---

what is different three logs in DB2?

1 Answers   Syntel,

---

What is concurrency?

0 Answers  

---