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 page in db2?
What is load utility in db2?
How to find primary key of a table in db2?
Define declaration generator (dclgen).
Which component is responsible for processing sql statements and selecting access paths?
How do I delete a column in db2?
What is plan in cobol db2?
What is sqlca’s maximum length?
Explain what are the various isolation levels possible?
How to create backup table in db2?
Is db2 a programming language?
What is dpf in db2?
How can you find out the # of rows updated after an update statement?
What is lock escalation in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE