IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

  • If you have not registered on this portal please click on the following link and register. To complete registration you will need to open the email you will receive from Aha to confirm your identity. http://ibm.biz/IBM-Data-and-AI-Portal-Register

Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas

  • To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

255 rows/page limit should be addressed

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.

This is coupled with the problem of the system limit of 16,777,215 pages per table or table partition which is documented in the following RFEs:

To increase the maximum size of a table or also to increase system efficiency large page sizes can be used, however for many narrow tables the benefit is taken away by being unable to fill a page.

The Informix compression option is superb and achieves amazing size reductions but the benefits are often only fully realised for indices where the rows per page limit does not exist. For tables small page sizes must be used for the majority of tables on our system to avoid hitting this limit.

Overall I think the negative consequences of this are:

  • DBA time in working out, dealing with the problem, goes against the idea that Informix has a low support requirement.

  • Unable to benefit from the efficiencies of larger page sizes without wasted space.

  • Wasted space, inefficient use of storage.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jun 2 2020
  • Under Review
Who would benefit from this IDEA? This would save DBA time, improve efficiency and reduce the need to code tools to work around the issue.
How should it work?

Ideally the limit should be removed, maybe along with the 16,777,215 pages per table or table partition limit.

If not, the following would help:

  • InformixHQ report on tables where the average row size is not big enough to fill a page.

  • Advisor for recommended page sizes for tables both with and without compression.

Idea Priority Medium
Priority Justification Would benefit all users, not as high a priority as the pages per partition limitation.
Customer Name Bonne Terre
  • Attach files

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions