Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one tell me about Restart logic in DB2.
- 2 Answers
- 7167 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 happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Name the lockable units in DB2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What is page size in db2?
Highlight all the advantages that are attached to a package.
What is db2 and what is the use of db2 optimizer?
what happend with out using Commit,when closing cursor and program?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
What are the levels of isolation available with DB2V4
What is bind in db2?
COBOL 
