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
I'm trying to check if a serial value has reached its upper limit. I noticed the following unpleasant behaviour. In the sysmaster tables sysptnhdr and sysactptnhdr the currently used serial values are in three fields for the datatypes serial, seri...
Informix version 12.10.FC13 - on Solaris server I want to use different BACKUP_FILTER settings for onbar and ontape.
I use onbar for daily backups and logs and ontape for syncing RSS.
For onbar - BACKUP_FILTER = /opt/csw/bin/pigz -1 -p 2 -b 25...
Allow storage expansion and extension during an archive
Need the ability to use onspaces, onparams, & API functions to manage storage allocation while an archive is executing. This is especially true with auto-extension of chunks and auto-expanding dbspaces by adding chunks automatically from the s...
Add configurable per session/per PDQ thread log cache similar to Sybase user log cache.
For high volume environments OLTP environments e.g. thousands of sessions and HDR/RSS nodes add a per session/PDQ thread log cache. This is flushed to the physical and logical log buffers either when full or at transaction commit time.
Improve performance on multifact query on an informix database
We make Cognos reports on multifacts creating multifact queries with full outer join. To keep the query execution time low, we need absolutely the enhancement/fix be implemented in the next informix fixpack 12.10. It is unacceptable when the compe...
Make onstat -g rss log buffer(s) size configurable.
I have run onstat -g rss log and are seeing 10% cache misses on some systems. I would like the underlying buffer space to be configurable similar to etc. As per our Lab Advocate: From my interpretation of the source the information displayed on th...
Allow placement of tablespace BYTE and TEXT data in a separate dbspace from the table's base row data.
Allow specifying a normal dbspace for a BYTE or TEXT column to isolate IOs for the blob data from main row data for the table. This would be logged space just like IN TABLE as opposed to IN blobspace blob pages.
Informix has a rows/page limit of 255 rows/page. Perhaps this was not a problem originally but over time we have seen new features: larger page sizes (up to 16 kB against 2 kB or 4 kB previously, dependent on operating system). compression option....
Automatic conversion of ifx_loc_t (TEXT/BYTE) to/from ifx_lo_t (CLOB/BLOB)
We have legacy ESQL/C code using ifx_loc_t to handle TEXT/BYTE columns. Customers want now to replace TEXT/BYTE by CLOB/BLOB columns in the database... and we would avoid to touch our ESQL/C code. Informix can support simple type conversion. For e...
A tmp database created with the server, analogous to the /tmp file system
In Linux systems (and in all Unix flavors) there is a /tmp directory or better, a /tmp file system. Anyone can create a file or directory in there and, in Linux, it cleared at boot time. (Other flavors use a cron job to clear out unused files.) I ...
Do not place IBM confidential, company confidential, or personal information into any field.