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
How do I import a csv file into db2?
How to fetch the last row from the table in SQL (db2)?
What os does db2 run on?
How to find the maximum value in a column in the db2 database?
What is the syntax for creating a table in the db2 database?
is it compulsory commitment control in journal?
What is load replace in db2?
How do I create a view in db2?
What is the picture clause of null indicator variable?
What is the maximum length of sqlca?
What is dbrm in db2 database?
What is the role of data manager in the db2 database?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How to find primary key of a table in db2?
Why select is not preferred in embedded sql programs?