what is check point and restart Logic ? why do we go for
that ??
Answer Posted / 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 |
Post New Answer View All Answers
What is a system catalog table in db2?
Why db2 is called db2?
What are the various isolation levels possible?
How to test SQL -911 error while developing COB-DB2 program
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What does reorg do in db2?
Explain the benefits you can get from mainframe connect?
Mention data types used in db2 ?
What is role in db2?
What is the difference between drop table and delete table?
What is the use of runstats in db2?
What is the maximum length of sqlca?
What db2 400?
What is performance tuning db2?
Name the various locking levels available?