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 |
Explain what a plan is?
Where can you declare a cursor in a cobol-db2 program?
What does db2 blu stand for?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
how to resolve -811
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What are the abend codes occour in ur latest PROJECT in DB2
WHAT IS MEANT BY COMMIT COMMAND?
Suppose if I need to update a column, how you do that using cursor?
How are write I/Os from the buffer pool executed?
How do you insert a record with a nullable column?
How to find the maximum value in a column in the db2 database?