What are the abend codes occour in ur latest PROJECT in DB2

Answers were Sorted based on User's Feedback



What are the abend codes occour in ur latest PROJECT in DB2..

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

What are the abend codes occour in ur latest PROJECT in DB2..

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

Post New Answer

More DB2 Interview Questions

Explain what a plan is?

3 Answers   CTS,


Where can you declare a cursor in a cobol-db2 program?

0 Answers  


What does db2 blu stand for?

0 Answers  


what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,


how to resolve -811

2 Answers   IBM,






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.

1 Answers   Cap Gemini,


What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,


WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,


How are write I/Os from the buffer pool executed?

1 Answers  


How do you insert a record with a nullable column?

2 Answers  


How to find the maximum value in a column in the db2 database?

0 Answers  


Categories