Interested to Buy Any Domain ? << Click Here >> for more details...
what is check point and restart Logic ? why do we go for
that ??
- 2 Answers
- 27607 Views
- CGI, UST, Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / milky
Checkpoint-Restart logic is used when your program performs
a large number of database updates or inserts. If you want
to process and insert say 1000 records in a table, and your
program abends at 726th record, then if the checkpoint
frequency has been set to 100, then, on restart the program
will start processing from 701th record as each processing
of 100 records results in a COMMIT.
| Is This Answer Correct ? | 68 Yes | 5 No |
Answer / harsha
check point and restart logic are mainly used when our
table has 1000 records and we are getting abend after 100
records and we want to start the execution after 100th
record we use this.for this we have to use check points for
every 100 records
| Is This Answer Correct ? | 41 Yes | 12 No |
How to find primary key of a table in db2?
List down the types of triggers in the db2 database?
what is differnece between DROP TABLE & DELETE TABLE .
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What Utility is used to migrate DB2 from one release to the next?
WHAT IS MEANT BY COMMIT COMMAND?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What are the prerogatives?
What is a clustering index?
What os does db2 run on?
COBOL 
