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).
Answer Posted / shashi
Instead of commiting at the last point, commit at certain
intervals (increase the frequency of commit, say after
every 100 records in this situation)
Create one temporary table with a dummy record and insert
one record into the table for every commit with key and
occurance of commit. And this insertion should happen just
before the issue of commit.
And in the procedure division, first paragraph should read
the last record of the table and skip the records that are
already processed and committed. After processing all the
records delete the entries in the table and issue one final
commit.
Is This Answer Correct ? | 21 Yes | 2 No |
Post New Answer View All Answers
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is runstats db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is db2 bind process?
What is the syntax for creating a table in the db2 database?
What is performance tuning db2?
Explain package in db2 and its advantages?
Is ibm db2 open source?
What are types of indexes?
Are views updateable?
Why do chiropractors use drop table?
What is syscat in db2?
Describe major components of db2?
What is the use of dclgen in db2?