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
Provide ROWID addition for PBG to PBR conversion in V13 ALTER statement.
In V13m we get to convert PBG tablespace to PBR by a simple ALTER statement. However, we will be forced to look for a partitioning key by working with application team. In the mean time, in V12 we have a feature called "Hidden ROWID support for pa...
JDBC connection property currentSchema should be externalised in an IFCID
We have jdbc applications which have set the jdbc property currentSchema to determine the collection of db2 objects like tables, views etc. When we want to trace the application with a performance trace, we're not able to analyse the correct colle...
Indicate whether the fallback SPE for Db2 13 migration is installed
As a user planning to migrate to Db2 13 I already activated V12R1M510 on my Db2 12 subsystem. However, I also want to make sure that I have the fallback SPE PH37108 https://www.ibm.com/support/pages/apar/PH37108 installed. Could this information b...
Enable DSNTIAUL to generate NUMRECS in the punchdataset
The UNLOAD using DSNUTILB generates the NUMRECS parameter which makes the Allocation of Sort/Workdatasets for the Load utility very effective. Because some collegues use IKJEFT01 (DSNTIAUL) for unloading data, we tried to use NUMRECS here also. Bu...
Implicit Tablespaces for conversion of multi-table tablespaces to UTS PBG
When converting multi-table tablespaces to universal tablespaces with new command ALTER TABLESPACE MOVE TABLE you need to create a new tablespace for each table explicitely before you can use the command. It would be very nice if the ALTER TABLESP...
DB2 z/OS - Message id - DSNJ110E - Additional alerts for active log monitoring and highlighted new message id when DB2 logging was suspended
We had a major incident due to suspended logging for one of the critical customer.
One of the critical production DB2 subsystem logging was suspended , caused by stalled archive log offloading process due to insufficient storage space on archive...
Rotate an archive-enabled PBR tablespace without causing a deadlock
When we try to rotate partitions of an archive-enabled PBR tablespace, Db2 requires us to disable archiving before the rotate then re-enable archiving after the rotate. However, when we re-enable archiving we cause a deadlock with CICS and the onl...
DB2 Return Code Differentiate for Deadlock and Timeout via Subsys Normal Call Exit
DB2 presents IMS ( via Subsystem Normal Call Exit ) with the same return code (4) for:
DB2 resource deadlocks
DB2 resource unavailable conditions
Example, lock timeouts on object locks, such as are taken by DB2 utilities and those caused b...
DB2 profiles - register START PROFILE and STOP PROFILE commands
Summary: Log all -START PROFILE and -STOP PROFILE commands in a DB2 table, ready to be used for queries onto the history tables. Details: When DB2 profiles are being enabled (SYSIBM.DSN_PROFILE_TABLE.PROFILE_ENABLED='Y'), the next -START PROFILE c...
Issue command DISPLAY DB CLAIMERS on a LOAD SHRLEVEL NONE when DRAIN fails in UTILINIT phas
We faced situations in which LOAD SHRLEVEL NONE jobs abends with S04E and Reason Code 00C200EC during UTILINIT phase. When this abends occurs, LOAD was unable to DRAIN all the claimers, once it is SHRLEVEL NONE, before beggining LOAD data into tab...
Do not place IBM confidential, company confidential, or personal information into any field.