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 is the soft code for deadlock ?

2 Answers   Logica CMG,

---

what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,

---

how to resolve -811

2 Answers   IBM,

---

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

1 Answers  

---

What kind of database is db2?

0 Answers  

---

What is a db2 tablespace?

0 Answers  

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  

---

What are the isolation levels possible ?

3 Answers  

---

What is tablespace?

3 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

How to find the number of rows in a db2 table?

0 Answers  

---