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.

How do you pull up a query which was previously saved in qmf?

0 Answers  

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

What is performance tuning db2?

0 Answers  

---

Where do you specify them?

0 Answers  

---

What is load replace in db2?

0 Answers  

---

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,

---

What is deadlock in db2?

0 Answers  

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

What is the result of open cursor statement?

0 Answers  

---

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

Which command is used to remove all rows from a table?

0 Answers  

---