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 / 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 length of physical storage of the given data types of db2 – date, timestamp, time
what is the sqlcode -501
What is the role of data manager in the db2 database?
What is the meaning concurrency in the db2 database?
What is commit in db2?
Is db2 relational database?
Can we delete records from view?
How do I change the column size in db2?
Which command is used to remove all rows from a table?
Can one database have multiple instances?
What is the syntax for creating a table in the db2 database?
What does a deadlock mean in DB2?
Explain about rct.
How do I delete a column in db2?
Explain package in db2 and its advantages?