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.
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...
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...
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 ...
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.
Reorging a TS with NPSIs, SORT NPSI = AUTO, getting IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR which resulted in DSNU3341I 171 01:39:59.85 DSNURPCT - CANNOT ALLOCATE SORT DATASETS WITHIN 255 LIMIT , REORG should change to SORTNPSI = NO to prevent abend
Reorg TS with NPSIs and SORTNPSI or zparm REORG_PART_SORT_NPSI = AUTO. Reorg decides to run with SORTNPSI YES which sorts all keys for NPSIs. Job is having issues getting DASD resulting in numerous:01.39.58 J0916868 IGD17272I VOLUME SELECTION H...
Global Variables: A global variable can be created with a default value. Each session that uses it will then instantiate a version of that global variable, with the default value and any change in the value is limited in scope to its unit-of-work....
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...
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...
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...
issue DISPLAY BLOCKERS instead of DISPLAY CLAIMERS when DRAIN timeout
Currently when DRAIN fails during REORG, a DISPLAY CLAIMERS is issued. The draw back is there is no "age" information, so user does not know which thread is the blocker, because the claimer could also be waiter.
Do not place IBM confidential, company confidential, or personal information into any field.