Interested to Buy Any Domain ? << Click Here >> for more details...
What are the abend codes occour in ur latest PROJECT in DB2
- 2 Answers
- 8645 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 does the RUNSTATS Utility do?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
Explain about rct in db2?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What is lock escalation?
What do you mean by commit and rollback?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is SPUFI?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the maximum size of varchar data type in db2?
what is static sql? what is dynamic sql? Give me details
COBOL 
