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


Please Help Members By Posting Answers For Below Questions

How do I import a csv file into db2?

560


How does db2 sample database connect?

572


What is db2 bind process?

757


What is cursor in dbms?

593


B37 abend during spufi?

982






What is the difference between drop table and delete table?

554


Why select is not preferred in embedded sql programs?

715


What is db2?

741


How to find schema of a table in db2?

572


What is the role of schema in the db2 database?

653


Explain the contention situations caused by locks?

592


How can you count the number of rows from a table tab?

637


What is the information associated with sysibm.syslinks table?

657


What is isolation level in db2?

577


What is bind and rebind in db2?

648