What are the abend codes occour in ur latest PROJECT in DB2
Answers were Sorted based on User's Feedback
Answer / g.kalyani
-305 --->NULL value is moved to the HOST VARIABLE
-803 ---->DUPLICATE ROW INSERTION
-904 ---->DB@ Resources not avalable
-805 --->PLAN not FOUNd
-911/-913 -->TIME OUT DUE TO DEAD LOCK
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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.
| Is This Answer Correct ? | 2 Yes | 0 No |
How do you pull up a query which was previously saved in qmf?
How to define the data items to receive the fetch items for the SQL?
What is performance tuning db2?
Where do you specify them?
What is load replace in db2?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is deadlock in db2?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What is the result of open cursor statement?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
what is Runstats? Whem will u choose to runatats?
Which command is used to remove all rows from a table?