what is check point and restart Logic ? why do we go for
that ??

Answers were Sorted based on User's Feedback



what is check point and restart Logic ? why do we go for that ??..

Answer / 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

what is check point and restart Logic ? why do we go for that ??..

Answer / harsha

check point and restart logic are mainly used when our
table has 1000 records and we are getting abend after 100
records and we want to start the execution after 100th
record we use this.for this we have to use check points for
every 100 records

Is This Answer Correct ?    41 Yes 12 No

Post New Answer

More DB2 Interview Questions

What is dclgen in db2?

0 Answers  


Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,


What is normalization and what are the five normal forms?

1 Answers  


database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  






What is rebind in db2?

0 Answers  


What is DCLGEN ?

3 Answers  


what is the input to PLAN? what is the input to DBRM?

4 Answers  


How do you find the maximum value in a column in db2?

0 Answers  


define clustering index.

0 Answers  


What is the function of logging in the db2 database?

0 Answers  


What are the various data types available in db2?

0 Answers  


Categories