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.
Add REMARKS column to SYSIBM.SYSDATABASE and COMMENT support for database object
We would like to ask you, to add the REMARKS column in SYSIBM.SYSDATABASE and support for COMMENT statement for databases. There is no possibility currently to store some form of a description for databases in DB2 catalog. In big sites where thous...
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.
Expand error message -532 and and output parent table name and child table name
Table1 has 4 level foreign key Table1 to Table2 --> FK_01 Table2 to Table3 -->FK_01, FK_02 Table3 to Table4-->FK_01, FK_02 Table4 to Table5 --> FK_01 If I delete row in Table1, I get the message: DSNT408I SQLCODE = -532, ERROR: THE REL...
Avoid Reorg Abends by improving estimation of average row length
Today, for estimating the average row length being passed to sort, REORG gets that from catalog statistics with either AVGROWLEN or COMPRESSRATIO. The reason RTS stats is not used, is because RTS only contains the compressed data size.
I would like to force the use of the "DEFER" option on the creation of an index (using Zparm to make it optional).
We have DBAs that at times (accidently) run a "CREATE INDEX" and fail to include the "DEFER" option. This is rather easy to do because the reverse engineering tools fail to create syntax with the "DEFER" option. The creation of indexes can be very...
Show DB2 Recovery progress status in the db2 master log
Improve the messaging in the db2 log in order to be able to have a better idea of the progress of a recovery and how long it might take. For instance, currently message DSNR048I is issued every 2 minutes during abort recovery. It would be very hel...
Up to now a RENAME FOREIGN KEY is only possible by dropping and re-creating it, thus asking for a CHECK UTILITY to be run.The enhancement of the ALTER to a RENAME would make those actions superfluous and would be much faster.
IFCID 172/196 (Deadlock/Timeout) â€“ Add STCK for Held Locks
At IFCID 172/196 (Deadlock/Timestamp) please add a STCK for the held lock (blocker) when the lock was granted. In case of a lockout with this STCK the sequence of the locks, and so the sequence of the blocker-SQLs, can be reconstructed â€˜post mor...
almost 9 years ago
in Db2 for z/OS
Not under consideration
Do not place IBM confidential, company confidential, or personal information into any field.