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
- 54713 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
What is the syntax for seeing the columns and data types of a table in the db2 database?
Define db2 and its databases?
What is a bind in db2?
What is query_cache_limit?
What is lock escalation in db2?
Why do we bind in db2?
What is a db2 collection?
What is reorg?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is meant by union and union all?
What is data manager?
What are the various isolation levels possible?
What is dbrm?
What is cursor in dbms?
Is db2 a mainframe?
