Can any one tell me about Restart logic in DB2.
- 2 Answers
- 6336 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 is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
Write a query to retrive partial string.
When Can you be sure that a query will return only one row?
Which components manage deadlocks in db2?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
What is the syntax for creating a table in the db2 database?
What is the format (internal layout) of ?TIMESTAMP??
What is a recovery log?
what is difference between Static call and Dynamic call? How does it function?
What is the purpose of rollback and commit?
Why db2 is called db2?
COBOL 
