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
- 58430 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
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
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Is db2 a database?
What is explain in db2?
What is dbrm? What it contains?
What os does db2 run on?
Comment whether the cursor is closed during commit or not.
When reorg is used?
What is the maximum number of columns in a db2 table?
What is the physical storage length of date data type?
What is the result of open cursor statement?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is view db2?
What are types of indexes?
Mention the downsides of page level lock.
What is the use of value function?
