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.

Explain db2.

1034

---

What is difference between alias and synonym in db2?

1140

---

What does reorg do in db2?

1029

---

What is the syntax for creating a table in the db2 database?

1105

---

How to check last update on table in db2?

1059

---

What is db2 command?

1035

---

What is performance tuning db2?

1061

---

Can you use max on a char column?

1097

---

What is the role of the data page in the db2 database?

1028

---

what is the role of the cursor in db2?

1067

---

What is the syntax for FETCH in DB2 ?

1212

---

What is a plan and package in db2?

1102

---

Is db2 a database?

968

---

Is it possible using max on a char column?

1139

---

What type of database is db2?

971

---