Skip to Main Content
IBM Data and AI Ideas Portal for Customers


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:

Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

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

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


Status Not under consideration
Workspace Db2
Created by Guest
Created on Oct 7, 2014

DB2 Partitioned Indices Order Preservation and Performance

GTECH is in the lottery and gaming business. They use DB2 as a competitive advantage in their offering. They are an IBM SW Reseller. They are always looking at new ways to leverage DB2, DB2 Blu, DB2 Merge/Backup,IBM Replication IIDR, to gain competitive advantage. Customer Satisfaction with DB2 is critical for continued adoption, and promotion. Large GTECH customers are the State Governments and they require efficiencies in operations.

Competitive Data (What are our competitors doing in this area?): Oracle and other DBMS offerings are always
an alternative to DB2.

Current workarounds: The current workaround suggested by L3 Support was to introduce redundant indices, adding partitioned indices to non-partitioned indices. This degraded query performance and was not usable.

Customer impact if not delivered: In short-term, customer will continue to incur operations cost of excessive time to perform detach operation. Customer satisfaction with DB2 will decrease. Ultimately, customer will look at other alternatives.
Background (History and current state): GTECH is an important IBM ASL Program, Reseller of IBM solutions. They are looking to adopt any/all IBM solutions that can be cost effectively embedded into their software/hw offerings to the state lotteries, and customers worldwide. Increasing their strengthening relationship with IBM is critical for future success, and short-term sales of IBM Inf.Management software. There are current opportunities in 2014 to sell GTECH $500K-$2M worth of software. These could be negatively impacted by our response to their request. Lets review request with them carefully and perform adequate due diliigence. Thank you!.

Customer currently has two (2) objectives:
1) Maintain or improve current SQL query performance of queries that contain min(), max(), count() functions AND

2) Improve Detach performance which is currently excessive.
Existing customer implementation uses non-partitioned (global) indices. Customer is trying to reduce the time it takes to detach. Time currently exceeds 30 minutes, to detach.

Customer says process is excessive. They must first delete global (non-partitioned) indices, detach, and later re-create.
As a potential solution to improve detach performance, IBM L3 Support suggested adding partitioned indices to the same partitioned columns (which already have non-partitioned indices). After adding these redundant indices, the customer's SQL query performance significantly degraded.

Customer Contact is "Jarocki, Janusz" - Janusz.Jarocki@gtech.com

Originally entered into DB2 Enhancement Request System as R2PRO00009341

IBM DB2 Owner = Carmen Wong - ckmwong@ca.ibm.com|Carmen Wong

Urgency= High - Needs to be in next release