Answer / g.kalyani

-305 --->NULL value is moved to the HOST VARIABLE
-803 ---->DUPLICATE ROW INSERTION
-904 ---->DB@ Resources not avalable
-805 --->PLAN not FOUNd
-911/-913 -->TIME OUT DUE TO DEAD LOCK

Answer / yuvaevergreen

-803 ---->DUPLICATE ROW INSERTION
Identify the record for SQLCODE=-803 and rectify the issue.
-904 ---->DB@ Resources not avalable
Try to use display database and check the locks on which
pages.
DIS DB(MMLPDDDB) SPACENAM(MMLPD61T) LIMIT(*)
-805 --->PLAN not FOUNd
Rebind the package/plan.
-911/-913 -->TIME OUT DUE TO DEAD LOCK
1. change the lock size to 'ROW' for all the tablespaces(
tables) used in batch job program. here LOCKSIZE is a
tablespace property.

2. do a RUNSTATS on all tabalespaces(tables) used by the
batch program and mainly tables on which contention
occured.

3. bind the batch program package/plan with isolation level
CS and
deallocate bind parameter as COMMIT.

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

how to resolve -811 error. give clear explination

4 Answers   IBM,

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

How to select the duplicate rows from a table?

4 Answers  

---

What is concurrency in db2?

1 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

How does cobol compile db2 program?

0 Answers  

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---

What is sqlca’s maximum length?

0 Answers  

---