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
Mention the definition of cobol in varchar field.
What is ibm db2 client?
How to test SQL -911 error while developing COB-DB2 program
What is the physical storage length of the data types date, time, and timestamp?
What does runstats do in db2?
How do I create a view in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is difference between isnull and coalesce?
What are the bind parameters ibm db2?
On which levels locks can be applied?
Explain in brief how does db2 determine what lock-size to use?
How do I import data from excel to db2?
What is the difference between spufi and qmf?
What is the role of the data page in the db2 database?
Is db2 relational database?