This portal is to open public enhancement requests for IBM Sterling products and services. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updateson them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Specific links you will want to bookmark for future use
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.
SBI SFG Team.
What is your industry?
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.
Do not place IBM confidential, company confidential, or personal information into any field.