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


ADD A NEW IDEA

FILTER BY CATEGORY

Db2 SQL Performance Analyzer for z/OS

Showing 18

Create a new report in additional to ANLDELTA, one line per SQL statement meeting the filtering requirements

Need new report to make it easy to see queries easily which have increased costs, decreased costs and new statements. This is based on filters. ANLDELTA has alot of detail which makes it very difficult to determine what queries with increase cos...
5 months ago in Db2 SQL Performance Analyzer for z/OS 0 Future consideration

Currently =X does not work from any panel, should add this to the product

Must press pf3 to get out of the product, then =X or =XALL
about 1 year ago in Db2 SQL Performance Analyzer for z/OS 1 Not under consideration

Add capability to run TEST with APREUSE(WARN) added to the REBIND

ADP is rebinding packages with APREUSE(WARN). This attempts to use the same access path for each SQL statement. Since SQL/PA TEST is not running with this, the product will produce more changes which is not true when APREUSE(WARN) is used.
3 months ago in Db2 SQL Performance Analyzer for z/OS 0 Future consideration

Using the TEST function, Need to Filter by Index Name or Table Name

Looking to convert an NPI to DPSI. Need a way to compare access paths of all SQLs that are currently using the NPI to What-if the NPI was not there (aka Virtual Index Delete). The TEST function (Dynamic Explain) currently does not allow filt...
5 months ago in Db2 SQL Performance Analyzer for z/OS 0 Not under consideration

SQL/PA - Going from ANLPFILE to various options causes package location to be blank where it was populated previously.

Don't blank it out.
5 months ago in Db2 SQL Performance Analyzer for z/OS 1 Delivered

Change ANLPCOLL JCL generation from using DSNTEP2 to ADBTEP2 to facilitate easy restart if job abends

No description provided
10 months ago in Db2 SQL Performance Analyzer for z/OS 2 Not under consideration

Capture cost and path information for New SQL to help DBAs determine if there might be an access problem

There is a new release of application code. Currently SQL/PA does a COMPARE of current and previous access paths. There is a hole for NEW SQL that takes a bad access path. DBAs need to know if this is occurring.
over 1 year ago in Db2 SQL Performance Analyzer for z/OS 1 Delivered

SQL/PA COMPARE - add Statement matching option 2 - match like "1", but also compare the SQL statement text

This should be added as it exists in the TEST function. I believe this is more important in COMPARE than in TEST. TEST is taking a package from the catalog and just rebinding it. I don't see how any queryno should change value. But when COMPAR...
2 months ago in Db2 SQL Performance Analyzer for z/OS 0 Future consideration

SQL/PA - TEST with Explain Type D, VERSION, New Version is PH37648.51 and not Package version

When Explain Type is D, New Version is on report is populated with latest APAR instead of the package version. New Package version should be the from the package being explained. New version should be RLSE2142 not PH37648.51 | ...
2 months ago in Db2 SQL Performance Analyzer for z/OS 0 Future consideration

Add field(s) to ANLPCOLL to allow the generation of COMMITs within the stat DML for x number of deletes/updates/inserts

No description provided
10 months ago in Db2 SQL Performance Analyzer for z/OS 0 Future consideration