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 are the contents of a dclmgen?

1122

---

List out the three types of page locks that can be held.

1147

---

What is database reorganization?

1125

---

Name the various locking levels available?

1089

---

What is a collection in db2?

1032

---

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

1118

---

How to view db2 table structure?

1016

---

What is db2? Explain.

1041

---

What is the physical storage length of time data type?

1123

---

What are db2 tables?

1123

---

Describe major components of db2?

1090

---

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

7559

---

What is difference between rollback and commit?

1157

---

What is meant by dclgen?

1103

---

What is coalesce in db2?

1129

---