IBM Data & AI

 Welcome to the IBM Data & AI Ideas Portal for Clients! 

We welcome and appreciate your feedback on IBM Data & AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal.  If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.
  • If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity. http://ibm.biz/IBM-Data-and-AI-Portal-Register
Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas
  • To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps
  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases
  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

terminate rollback

When  database is rollback a long transaction , it may take a long time. User don't want to wait for rollback to finish.

One scenario is that user has made a large change on a table that is not that important table so they are willing to drop it (or they can recreate the data).  So they would rather Db2 make the affected table not accessible and not perform all the compensation on that table.

  • Ling Qin
  • Aug 9 2019
  • Needs review
Why is it useful?
Who would benefit from this IDEA?
How should it work?

the transaction being rolled back holds various resources to protect the changes that are still to be backed out.   Terminating the rollback means not performing the backing out and release these resources.  Then other applications will see inconsistent data.   So there will be consequences for such termination.  User will have to at least agree that they are willing to live with such consequences on all (or at least some) of the affected data.

We should give user a choice. If user can accept data lost, we can terminate the rollback quickly and make database usable.

Idea Priority Medium
Priority Justification
Customer Name CMB
Submitting Organization
Submitter Tags
  • Attach files
  • Matthew Emmerton commented
    7 Oct, 2019 09:28pm

    What is the desired functionality here?

    1) Do you want the ability to mark a table as "not recoverable", so that when the active session acting on that table is interrupted, the rollback will skip undoing changes to that table, thus making rollback faster?
    This would require this specific object to be dropped (and possibly recreated). Other objects modified in that transaction would have those operations rolled back as per usual..

    2) Do you want the ability to interrupt a rollback, and have Db2 automatically mark all affected objects in the transaction as "not recoverable", so that the rollback will skip undoing changes to all objects, thus making rollback faster?
    This would require that all affected objects be dropped (and possibly recreated).

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions