Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose we are doing transaction in a table and abend happened in
between. Suppose i have completed the transaction upto X rows and
I want to start the transaction again where the abend happened. I
don't want to do the transaction from the first record. Then what
i have to do.
- 9 Answers
- 14602 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ignatius pradeep
We have a option called the BMC dedicated for this kind of
transaction errors. You can give a commit frequency too.
Example:
You have to insert 230 records into a table and your
transaction abends at 163 due to -803 or some error.
Now, If you define your BMC commit frequency to be 100, a
commit will be issued for every 100 records processed. So
in our example the first 100 records will be commited and a
checkpoint will be saved. When the transaction abends at
165 and you restart the job. The system will automatically
look at the last checkpoint and start processing from 101
record.
Let me know if i am wrong.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Mention the location where the output received from explain statement is stored.
What is dclgen (declaration generator)?
How do I add a column to an existing table in db2?
Why select is not preferred in embedded sql programs?
How can you quickly find out the # of rows updated after an update statement?
Can we update view in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
what is diffrence b/w file-aid tool and file-aid utility???
What is db2 and what is the use of db2 optimizer?
What is the use of db2 optimizer?
What is bind and rebind in db2?
What is declare cursor?
What is difference between alias and synonym in db2?
Explain about open switch business continuity software?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
