Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 58450 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 buffer pool and list some of them?
Is db2 a database?
What action db2 takes when a program aborts in the middle of a transaction?
Explain about rct.
What is a db2 collection?
What is netezza database?
How can you do the explain of a dynamic sql statement?
Explain about mirror activator disk mirroring?
How can deadlocks be resolved?
Which command is used to remove all rows from a table?
What is the use of with ur in db2?
What are host variables in db2?
What is scrollable cursor in db2?
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 ?...
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
