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
Improve timestamp format in message and backup logs (ISO-8601)
Streaming messages to log ingestion systems, e.g. Elastic Stack, is a useful way of analysing logs and generating notifications when certain messages are seen. Displaying the messages in the right order when daylight saving switches occur is an is...
More efficient unique indexes for monotonically increasing keys and constraints
Currently an index on a SERIAL and other monotonically increasing keys only add to the last node in the index causing the node to split into two half filled nodes. Eventually a sufficient number of nodes have so split that the index's search effic...
enhancements to sysprocedures table and dbschema utility
Currently, there does not appear to be anything in the sysprocedures table to identify which procedures are provided by Informix (system routines) vs those created by users (user routines). The mode column does not appear to address this particula...
We raised a support case as follows: Following the recent change in status of Centos, we have customers who wish to convert their Informix servers to Rocky Linux soon. This will be for both IDS 12.10 and 14.10. Can you confirm that IBM/HCL would s...
Different message when transaction time limit reached
When transaction duration limit is reached the following message occurs in the online log file 08:56:28 sid 11617 - firstname.lastname@example.org - pid 6811 terminated because session transaction duration (60 seconds) has exceeded limit. This session i...
SQLTrace offers the DBA the tooling required to monitor a user session. However its difficult to monitor heavily used systems. For example one needs to have a buffer large enough to store 90 seconds of SQL queries (small lookup SQL's consume the b...
Allow Bufferpool Min_lru_dirty and Max_lru_dirty Threshold values to be altered dynamically
onparams -b can be used to add a new bufferpool and AUTO_LRU_TUNING are available on informix server but first only adds a bufferpool of a new page size and the latter only kicks in if some foreground writes occur on a server which ideally is neve...
Do not place IBM confidential, company confidential, or personal information into any field.