What is check pointing, sync point?

Question Posted / swapna

3 Answers
14482 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is check pointing, sync point?..

Answer / pranav

Checkpoint is synonymous to Sync point, commit point or
point of integrity. Whenever a checkpoint is issued all the
records are committed and after a checkpoint system is in a
stable state. A checkpoint record entry is written to the
Log file and also generates a checkpoint ID which is used
for restarting the job from a particular checkpoint.

Database changes before the most recent checkpoint are not
reversed by backward recovery.
Database changes logged after the most recent checkpoint are
not applied to an image copy of the database during forward
recovery.

Is This Answer Correct ?

6 Yes

0 No

What is check pointing, sync point?..

Answer / srikar

check point is the one which will holds the last abended
record address,so that when ever the job got abended we can
restart the job from the abended record with using the
check point.

sync point is nothing but a commit if you issue a sync
point after 100 records,those 100 records will be committed
after that if at all job got abended

Is This Answer Correct ?

9 Yes

4 No

What is check pointing, sync point?..

Answer / guest

It is used to control execution job steps.

Is This Answer Correct ?

2 Yes

3 No

Post New Answer