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 buffer in memory?
Give the name of some fields form sqlca.
What is iseries database?
How to find the maximum value in a column in the db2 database?
Comment whether the cursor is closed during commit or not.
Is ibm db2 free?
Explain the contention situations caused by locks?
What is the maximum size of a char data type in db2?
What are the uses of db2 optimizer?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Explain about open switch business continuity software?
What is the difference between dbm cfg and db cfg file in db2 ?
How do I add a column in db2?
What is the usage of open cursor command?