What are the abend codes occour in ur latest PROJECT in DB2
- 2 Answers
- 7939 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
What is the result of open cursor statement?
what is consistency token
What is dynamic SQL?
What is check constraint in db2?
i want to maintain uniqueness on pdf without make lf??????????
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
why we create view.
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is db2 plan table?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Describe what a storage group(STOGROUP) is?
COBOL 
