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.

Only update rows in referenced tables only once per template repair (with p > 0), thus avoid deadlock & LongTX

Product in Use IBM Informix 11.70UC8X6
Customer Information Duane Guthrie
Email: dguthrie@cisco.com Phone: 972-813-5115
Sizing info TBD
Product Enhancement Request Abstract Request to only update rows in referenced tables (t1 and t2 here) only once per template repair (with p > 0), thus avoid the deadlock situation that leads to a long transaction.

1 Problem Description/Usage Scenario


As part of Cisco's migration strategy, they take a backup of a node and restore it on a new node. During this time updates can occur, so this new node needs to be checked (w/ cdr check –repair) to see if it's in sync with the rest of the cluster when brought online.

In this scenario table1(t1), table2(t2), table3(t3), and table4(t4) are all part of a replicate template. Both t3 and t4 have references to both t1 and t2. When running cdr check repair with p>0, and both t3 and t4 needing repairs, it is possible to see deadlocks that ultimately lead to long transactions.
1.1 Describe your current usage scenarios of Informix and problem associated with it
See above.
1.2 Describe what would you like the new product to do for your business
This would allow the setup process for new nodes to avoid deadlocks/long tx's which cause the setup process to fail.
2 List any special considerations around expected solution
2.1 Expected Capability
That Informix would only updating rows in referenced tables (t1 and t2 here) only once per template repair, thus avoid the deadlock situation that leads to a long transaction.
2.2 Standards Compliance
N/A
2.3 Platform-Specific Considerations
Cisco runs Linux RH6 32-bit.
2.4 List any restrictions which would need to be placed on the enhancement's implementation
N/A

2.5 List any performance expectations

3 Deadlines/Known Revenue Impacts/Impact of not meeting requirements

3.1 Timeframe
As soon as possible

3.2 Product Release
Ideally in the next interim release of 11.70/12.10

3.3 What is the business benefit of having this enhancement?
By only updating rows in referenced tables (t1 and t2 here) only once per template repair, thus avoid the deadlock situation that leads to a long transaction.
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 24 2018
  • Not Under Consideration
Idea Priority High
Customer Name IBM (on behalf of Cisco Systems)
  • 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