Answer Posted / 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 use of value function?

1153

---

What is deadlock in db2?

1073

---

What is the role of schema in the db2 database?

1278

---

What are the contents of a dclmgen?

1133

---

What is ibm db2 connect?

1003

---

What is buffer pool?

1110

---

What is the physical storage length of the data types date, time, and timestamp?

1093

---

Explain about open switch business continuity software?

1140

---

Which isolation level provides maximum concurrency?

1156

---

What is isolation level in db2?

1011

---

How do I create a view in db2?

1027

---

What is the maximum length of sqlca?

1531

---

How to test SQL -911 error while developing COB-DB2 program

7579

---

What are types of indexes?

1079

---

What is dbrm? What it contains?

1163

---