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.
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...
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...
Message UTF-8 => After conversion in EBCDIC EBCDIC_STR('Hi, my name is Андрей (Andrei)'); => Hi, my name is \0410\043D\0434\0440\0435\0439 (Andrei) But for the character � (UTF-8 replacement character) the function returns the value X'3F' in...
Increase messaging detail after STOP Db2 to provide shutdown status information.
As Db2 continues to allow more and more capacity in a single subsystem - larger bufferpools, more open datasets, etc - the time to shut down Db2 continues to increase. Operational staff has complained repeatedly that they cannot tell whether Db2 i...
For Dynamic Plan Stability, Only store the actual SQL statement in STMTTEXT column
While reviewing the SQL statements in SYSDYNQRY.STMTTEXT column, extra characters are added to the end of the SQL. This requires extra processing when comparing to the REAL SQL-text. In some cases, but not all, a compare like the following is need...
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...
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...
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...
Error message improvement when failing to convert tablespace to UTS PBG
Recently we are converting our old segmented and simple tablespaces to UTS PBG. When converting one of these tablespaces we got an abend and a DUMP showing reason code 00C90101. We opended a case (TS009249828) and analyzing the DUMP DB2 lab conclu...
Today we have situations where people authorized to start DB2 traces sometimes issue START TRACE commands with little qualifications with lead to traces being collected for lots of DB2 threads which ends having impact on general performance of the...
Do not place IBM confidential, company confidential, or personal information into any field.