Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one tell me about Restart logic in DB2.
- 2 Answers
- 7294 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / girish kumar
suppose if we have 1000 rows for update, while we updating
incase if we get abend occures at 999 even a single record
could not be saved to database with out execute commit.
so that if we can place a commit for every 100 records
incase abend occres at 999 cursor start for 900 onwords by
issuing rollback along with commit.
this is db2 logic better to refer MUTTU REFRESHNER
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / muneer
suppose if we have 1000 records while retriving data we got
abend at any stage we will use restart logic.this is the
basic idea of restart logic...
| Is This Answer Correct ? | 1 Yes | 1 No |
What techniques will be used to avoid deadlock??
What do the initials DDL and DML stand for and what is their meaning?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
Define db2.
What is consistency token in db2?
How to resolve deadlock issue
How does one remove entries from the SCT02 table?
What's the maximum number of characters that a tablename can have?
How many clustering indexes can be defined for a table?
What is the maximum No of rows per page?
What else is there in the PLAN apart from the access path?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
COBOL 
