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 role in db2?

1164

---

What are bind parameters in db2?

1097

---

Explain about dbrm.

1109

---

How to check sequence on a table in db2?

1117

---

What is the maximum size of varchar data type in db2?

1177

---

Explain in detail about buffer manager and its functionalities?

1145

---

What is the advantage in De-normalizing tables in DB2?

1234

---

What are the prerogatives?

1129

---

What are iseries servers?

1132

---

How can you classify the locks in db2?

1133

---

What is reorg?

1243

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1788

---

Where can you declare a cursor in a cobol-db2 program?

1144

---

Mention some fields that are a part of sqlca.

1096

---

Which component is responsible for processing sql statements and selecting access paths?

1178

---