IBM Data and AI

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

We welcome and appreciate your feedback on IBM Data and 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.

Avoid Single point of failure for Db2's critical files

If the critical files of Db2 damage, e.g. by erroneously deletion, file system corruption Db2 will no longer be available (#usable). Since some of the critical files are permanently updated a restore of the critical files does solve the problem. A loss of (part of) the local database directory requires a complete restore of a database which means hours of outage.

Mirroring the local database directory to a different path (preferably a different file system) could make Db2 tolerant to such kind of problems. This kind of enhancement could work roughly comparable to MIRRORLOGPATH, which allows to configure a mirror path for the log files, a DB parameter like DBDIRMIRRORPATH could allow to specify a mirror path for the local database directory

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jul 29 2020
  • Future consideration
Who would benefit from this IDEA? The measurable benefit would be a fault tolerance of Db2 regarding the loss of critical files, resulting in avoiding full database restores for customers.
How should it work?

The proposed solution for the problem is to specify a mirror path for the local database directory.

The measurable benefit would be a fault tolerance of Db2 regarding the loss of critical files, resulting in avoiding full database restores for customers.

Today, there is no known work around for the problem of the loss of Db2's critical files. If this happens a complete database restore is required (See TS003901255).

Idea Priority Urgent
Priority Justification This functionality could avoid a complete database restore (outage)
Customer Name Finanz Informatik
  • Attach files

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