IBM Data and AI Ideas Portal for Customers
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 updates on 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
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
IBM Employees should enter Ideas at https://ideas.ibm.com
Delivered as part of the IBM Informix v15.0 release
This issue has been around for a long time but with trends towards Big Data and just Informix systems being around for longer, dealing with this problem comes up fairly frequently.
There are a few aspects to it. Ideally it would be good to sweep away this limitation entirely but given it is there it presents the following challenges:
Monitoring all tables and table fragments for the page limit and making predictions around when it might be reached based on table growth. I don't think there is anything in InformixHQ to do this, for example. Doing something here seems like the bare minimum to avoid a nasty surprise for the uninitated.
Workgroup edition users cannot use partitioning. This is understandable from the point of view of detach/drop, PDQ, other enterprise features but should not limit table size.
With a 2 kB page size, the unpartitioned table size limit is just 32 GB. Larger page sizes can help but only where the table is wide enough to use large page sizes (avoiding reaching another limit, 255 rows/page).
Range partitioning offers a possible solution, provided table have a suitable interval column, but sizing of the interval must be done carefully.
If the current constraints are not addressed it would perhaps be good to have an advisor of some kind to:
suggest the ideal page size for table.
suggest an interval column and interval size.
a method to easily convert a standard non-partitioned table to range partitioning.
This should take compression into consideration too and perhaps replace the compression estimator.
There could be an easy way to convert tables to range partitioning with minimal changes on disk or alternatively loopback replication could be used.
If the limitation is to be addressed fully, we would not mind a new dbspace type and would not necessarily expect existing dbspaces to automatically be converted or fixed.