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.

How to create db2 table in mainframe?

1105

---

What is host variable in db2 cobol?

1032

---

How can we read records for specific member in CL? AND rpg?

649

---

What is an instance in db2?

987

---

What is the use of runstats in db2?

1024

---

What is null indicator in db2?

1054

---

Explain the contents that are a part of dclgen.

1038

---

What is the use of db2 optimizer?

1043

---

Explain how can you do the explain of a dynamic sql statement?

1066

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1977

---

What are types of indexes?

1001

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2181

---

What is database manager in db2?

968

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1012

---

What language is db2 written in?

983

---