Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 iseries database?

0 Answers  

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

What does db2 stand for?

0 Answers  

What is copy book?

1 Answers   Thomson Reuters,

What is the picture clause of null indicator variable?

0 Answers  

what is copy pending and check pending ?

1 Answers   Xansa,

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

What are types of indexes?

0 Answers  

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

What is rebind in db2?

0 Answers