IBM Sterling Ideas

formerly Watson Supply Chain

Submit new product ideas for IBM Sterling solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed. Order Management, Store Engagement, Watson Order Optimizer, Inventory Visibility, CPQ and Call Center are now part of Watson Supply Chain

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

Upgrade/Fix Installation should log and recreate the custom Database Indexes dropped during the installation

As per the current design , Fix installation drops all the Custom Indexes created on Database and recreates the Database schema without the custom indexes dropped. 


Customers will be having lot many custom changes (Custom Indexes) done on Database level for various reasons and It will be difficult to identify the Custom Indexes if Fix installation drops all the custom indexes. 




1. Fix installation should log the custom indexes before dropping.


2. It should recreate the custom Indexes if they are dropped. 


3. Instead of acting on complete schema level , It would be good if fix installation acts on table level. This way installation touches the tables which require changes instead of recreating whole schema.




  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Apr 22 2019
  • Planned for Future Release
How will this idea be used?
  • Customers might be having some set of customization done on DB level for various reasons and the fix installation is dropping all those. Customer will loose all the data and has to start from beginning to make the system normal. 
  • If customer didn't make a note of those custom indexes created , it is not possible to track the custom indexes dropped by the fix installation.
What is your industry? Banking
What is the idea priority? Urgent
DeveloperWorks ID
Link to original RFE
  • Attach files
  • Admin
    Ryan Wood commented
    13 Jan 19:18

    Thank you for participating in the request for enhancement community. Your feedback is valued. We have analyzed this request. While we agree this functionality would be a great enhancement to SFG & B2Bi and have added this to our roadmap