Can any one tell me about Restart logic in DB2.
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 rebinding ?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
Describe major components of db2?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
wht r the requirements for writing a cobol-db2 pgm ?
How to create db2 table in mainframe?
define clustering index.
What is collection in db2 bind?
What is a clustering index ?
What is the format (internal layout) of ?TIMESTAMP??
what is plan? is plan executable or package?
What information is contained in a SYSCOPY entry?