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,
Post an idea
Upvote ideas that matter most to you
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.
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 ...
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...
Hello Db2 for Z/OS Development.Apar PM89016 was created several years ago to implement the lock avoidance for singleton SELECTs with ISO(CS) and CD(YES) when R-scan is used, or the index that is chosen has matching predicates on all columns of th...
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...
As mentioned in Case TS004024647 there are some situations where inserts in lob structures do not provide the expected performance. Instead they cause massive CPU consumption in the Coupling Facility for the spacemap search.The problem is excessi...
A number of our common customers run DB2 utilities from third party vendors and IBM replication solutions. They are requesting that our LOAD and REORG utilities write the old dictionary pages to the log for later retrieval by a replication produc...
Stop package invalidation after ALTER MAXPARTITIONS
These days in an agile world we have to ALTER PBG spaces on-the-fly to raise the MAXPARTITIONS value. Sadly this ALTER, even though it is an immediate ALTER, sets all dependent packages to VALID = 'N' which is, of course, a disaster.
DB2 Z/OS Sync Logical and Physical Parts after full Reorg
ADD PART was used to insert a new physical partition in the middle of a tablespace. Now the Logical and Physical partitions are mismatch.If a Full Reorg on the full tablespace is performed, the utility can include an option to resync the logi...
Profile Tables today support only remote connections and no support for local/batch applications. When PT is used to set certain registers, it only works for remote applications and local apps needs to be changed to add certain SET commands.
DSNT376I message don't supply total information to solve the problem analisys
I found that as soon as the DB2 Lock Escalation message occurred (DSNI031I), DB2 seems to begin rejecting the ESS SQL calls against this tablespace, *immediately* without waiting the DB2 lock timeout interval. This probably explains w...
Do not place IBM confidential, company confidential, or personal information into any field.