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

If you have not registered on this portal please register at http://ibm.biz/IBM-Data-and-AI-Portal-Register . To complete registration you will need to open the email you will receive from Aha to confirm your identity.

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 offering manager 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 for z/OS

Showing 884

OPTIMIZER IGNORE INDEX indexcreator.indexname

Looking to replace NPI with DPSI. DSPI is created, and would like to verify that all SQLs that were using NPI, when Rebound/executed dynamically would either a) use either newly created DPSI or another index on the table and b) have run time ...
3 days ago in Db2 for z/OS 0 Submitted

Eliminate IN list limitation of 32767.

Our organization has a major customer that has run up against this limitation. They have migrated from DB2 LUW and they did not have this limitation. They have IN lists that exceed 100k at times.
about 1 month ago in Db2 for z/OS 1 Under review

Allow for "OPTIMIZE FOR n ROWS" to be added to DELETE, UPDATE Statements

OPTIMIZE FOR 1 ROW can be added to SELECT SQL. One reason may be to influence the optimizer to chose one index over another, or to not perform a SORT with List Prefetch Adding OPTIMIZE FOR 1 ROW to a DELETE statement results in an error: EXPLA...
about 1 month ago in Db2 for z/OS 0 Under review

Improve messaging surrounding the +20272 SQL warning in cases of a -904

A DBA was running an ALTER NOT CLUSTER. The ALTER should have converted the tablespace to table-controlled partitioning, but it encountered a -904. I have copied the output to "additional details".In the SPUFI output, after the -904, the ALTER dis...
4 days ago in Db2 for z/OS 0 Submitted

New Authorization for SELECT all tables (DataSelect)

We use the DataAccess Auth to let Select. Insert, Update & Delete on all tables.But we'll appreciate also a new Auth for letting only Select on all tables. That's why we thought about the name DataSelect.
3 months ago in Db2 for z/OS 1 Under review

Rebinding/Binding old native stored procedure packages

Let’s say you have a native SQL stored procedure package. And it was created/bound on Db2 V10 system. And you’d like to bind/rebind that same native SQL stored procedure package to V12R1M50+ (Let’s say for version next, if there is such a thing). ...
3 months ago in Db2 for z/OS 0 Under review

Preventing manual Stop/Start of a workfile after space issue

We had a space allocation failure in DSNDB07. After the storage failure has been relieved one of our batch job was crashing with reason 00D70011 as the DSNDB07 extend was flagged by DB2 WACTPUNAV bit as not usable. We finally had to manually St...
5 months ago in Db2 for z/OS 2 Under review

Distributed Thread cancelled due to Idle Thread Timeout or MONITOR IDLE THREADS not writing record to SYS1.LOGREC

We noticed that every DB2 distributed thread that is cancelled because: 1) Idle thread timeout value that is specified by Db2 subsystem parameter IDTHTOIN in macro DSN6FAC is exceeded; or 2) ATTRIBUTE2 value in a row with KEYWORD value MONITOR...
2 months ago in Db2 for z/OS 0 Under review

Standardize and allow LISTDEF PARTEVEL syntax for MODIFY STATISTICS utility

Currently MODIFY STATISTICS utility does not support LISTDEF with PARTLEVEL and throws an error like in example:LISTDEF DB2RK INCLUDE TABLESPACE DS0HUZX.S0HU37P PARTLEVEL(20) TEMPLATE COPYIC DSN(&SS..ICR.&DB..&TS..P&PA..&UQ.) T...
8 months ago in Db2 for z/OS 0 Under review

Expand error message -532 and and output parent table name and child table name

Table1 has 4 level foreign keyTable1 to Table2 --> FK_01Table2 to Table3 -->FK_01, FK_02Table3 to Table4-->FK_01, FK_02Table4 to Table5 --> FK_01If I delete row in Table1, I get the message:DSNT408I SQLCODE = -532, ERROR: THE RELATION...
6 months ago in Db2 for z/OS 5 Future consideration