Interested to Buy Any Domain ? << Click Here >> for more details...
What are the abend codes occour in ur latest PROJECT in DB2
- 2 Answers
- 8803 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 |
How to see the structure of db2 table??
How can you split a table in to exactly half?
what is sql abend code -801,-802?
When is the access path determined for dynamic SQL?
What is auditing?
what is load and unload in db2
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
What is meant by index cardinality?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What are the three DB2 date and time data types and their associated functions?
What keyword does an SQL SELECT statement use for a string search?
What is meant by explain?
COBOL 
