I have a DB2 table which has 1000 rows.after udatingg first
110 rows, my job abends. Now what I have to do if I want to
restart the job next time so that it should start updating
from 111th row (without updating first 110 rows again).
- 10 Answers
- 54786 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pradeep
CHECKPOINT-RESTART logic is used when your pgm performs
large no of database updates or inserts. If checkpoint
frequency has been set to 100, then on RESTART the pgm will
start processing from 101 record without restart from
starting.
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
Which is faster delete or truncate?
What is database alias db2?
What is dbrm? What it contains?
How do I delete a column in db2?
What is release/acquire in bind?
What are the various isolation levels possible?
How do I delete a table in db2?
What does runstats do in db2?
What are host variables in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is difference between alias and synonym in db2?
Can we insert update delete in view?
Define predicate?
How to get the ddl of a table in db2?
What is null indicator in cobol db2?
