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.

Which isolation level provides maximum concurrency?

662

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2044

---

How can you quickly find out the # of rows updated after an update statement?

630

---

What is a trigger in the db2 database?

592

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2274

---

---

Is db2 free?

684

---

What is db2 bind?

636

---

How would the varchar column remarks defined?

634

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2685

---

Define sqlca.

647

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1896

---

What is the function of logging in the db2 database?

638

---

Explain about mirror activator disk mirroring?

557

---

what is utility for parm lib

1873

---

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

640

---