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

Mention the definition of cobol in varchar field.

700


What is ibm db2 client?

523


How to test SQL -911 error while developing COB-DB2 program

6720


What is the physical storage length of the data types date, time, and timestamp?

612


What does runstats do in db2?

607






How do I create a view in db2?

606


If I have a view which is a join of two or more tables, can this view be updateable?

694


What is difference between isnull and coalesce?

621


What are the bind parameters ibm db2?

624


On which levels locks can be applied?

661


Explain in brief how does db2 determine what lock-size to use?

599


How do I import data from excel to db2?

616


What is the difference between spufi and qmf?

639


What is the role of the data page in the db2 database?

589


Is db2 relational database?

574