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.
Answer Posted / ramakrishna javvaji
create a temporary table and write every row before
processing and delete it after it is processed.
In case of abend you will have the row at which it abended
in the temporary table. you can now drive the process based
on this info.
correct me if i am wrong.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is data manager?
What is the meaning concurrency in the db2 database?
How to compare data between two tables in db2?
Explain in detail about buffer manager and its functionalities?
What is explain plan in db2?
Which component is responsible for processing sql statements and selecting access paths?
List down the types of triggers in the db2 database?
How to find the number of rows in db2 tables?
Is ibm db2 free?
On which levels locks can be applied?
Are view updateable?
What is the role of schema in the db2 database?
When the like statement is used?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is alias in db2?