This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
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:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updateson them if they matter to you. If you can't find what you are looking for,
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
Specific links you will want to bookmark for future use
In order to find out data set name(s) for a given table space
, you have to be in panel ADB21S and type the DSN line command next to the relevant tablespace. If you have requested details of a table and you are in panel ADB21T, you cannot find out...
Please update the LKEY and TT commands to work with all table types (not aliases and views but should include regular tables like archive, history, and MQT, etc.) Also, TT should be displayed on first search screen. Refer to case TS003373784
On the ADB27C panel, give the user a facility (or let them know upfront) whether any columns are part of a constraint, index or anything that requires “extra work” (e.g. Having to use UP,DP to update, etc.
Provide mask to control the DEFER setting based on the UNIQUERULE(SYSINDEXES) of the index (either via REXX or standalone). Currently the REXX won’t handle this because the Db2 catalog row sent to masking is the SYSINDEXPART row which doesn’t cont...
If I go into view the catalog object. Let's say environment UNIT for table XYZ then back out to switch environments the tool should remember what I searched on last. Or even better be able to switch Db2 groups on the search panel and not have to g...
Provide a way to run CM Batch with CAF, so that the RRS limitation is bypassed and DSNREXX can be used in REXX verification exits.
The costumer's DBA team want to avoid any new tablespace creation not using Partitioned by Grouth Universal Tablespaces. As MAXPARTTITIONS is not a suitable override mask, we try using a REXX verification mask in the form: VER,TS:REXX(ADBDSIZE, DB...
Object search screen - lengthen space for object names
Currently, the length of a table name or similar object is limited to 18 characters. This is an outdated standard since Db2 can accept much longer names. The pain point is that it's difficult to view or search for tables and impossible to copy/pas...
Line command '?' does not work on all menus, should be made consistent
In the Db2 Administration Tool v12, under the “Db2 system catalog” option, on the “Application Plans” and the “Table Authorizations” menus, the “?” line command does not work like it does on other menus. It returns an “Invalid line cmd” message.
In Panel ADB21A you can list ALIASES and there are some line commands. One of them is DROP. In some cases our DBA would need to drop a whole bunch of ALIASES at a time. And it is quite uncomfortable to acknowledge all of DROP one by ...
DB2 Administration Tool enhancement for SQL, DDL, DML syntax checking
Add enhancement to syntax check SQL, DDL, DML before execution. Recently attended presentation of Db2 DevOps Experience for z/OS and it has a 'Smart Editor' which performed these checks. I asked about it and was told it is using macros from the DB...
Do not place IBM confidential, company confidential, or personal information into any field.