Interested to Buy Any Domain ? << Click Here >> for more details...
What are the abend codes occour in ur latest PROJECT in DB2
- 2 Answers
- 8688 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 |
Explain package in db2 and its advantages?
Explain the use of the WHERE clause.
If I have a view which is a join of two or more tables, can this view be updatable?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
what happend with out using Commit,when closing cursor and program?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
Is Cursor exicutable ?
what is difference between Plan and Package
Can SQL statements/queries be included in a copybook?
Describe the elements of the SELECT query syntax?
What is drop table?
Why do chiropractors use drop table?
COBOL 
