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 are concurrency issues?
what is the sqlcode -501
What is dbrm library?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How connect db2 database to datastage?
How do you find the maximum value in a column in db2?
Which isolation level provides highest data integrity?
What type of database is db2?
Can there be more than one cursor open for any program?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is copy pending status in db2?
How would you find out the total number of rows in a db2 table?
What is the syntax for seeing the columns and data types of a table in the db2 database?
what is utility for parm lib
What is the role of schema in the db2 database?