Describe the effect of the "checkpoint" t-sql statement.

Showing Answers 1 - 6 of 6 Answers

sreenivasmurthy

  • Jun 19th, 2007
 

As per my knowledge in abinitio checkpoints are the intermediate stopping points. These will save information about the recent processed data in the form of *rec files. so whenever there occurs a failure in the graph it will automatically rollbacks to the nearest checkpoint & if you re-run the graph you will re-run the graph from that checkpoint only not from the beginning of the graph which ultimately improves the performance.

  Was this answer useful?  Yes

prakirn

  • Mar 1st, 2008
 

As per database point of view, checkpoint is used to flush the data from DB buffer (memory) to the physical disc.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions