Informix

Hi community,

I am trying to raise the profile within HCL of a couple of issues related to how Informix stores data on disk and get them on the Informix roadmap. If you have a large system you will be familiar with them already I am sure.

They are the Informix data pages per fragment limit of 16,775,134 and the rows per page limit of 255 rows per page. My opinion is that these limits are going to be more of a problem in the future as a lot of well-established systems are only getting bigger and there is a trend towards Big Data.

The first is the most serious as, if you reach this limit for any table or table partition, no-one can no longer insert any data and dealing with the issue is often not straightforward or quick. Even if you don't ever have a catastrophe, planning around them, putting in place the necessary monitoring and re-organising tables affected can be a drain on DBA time and cause downtime for your business.

I have updated someone else's existing RFE with more information regarding the pages per partition limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-31

And raised my own RFE about the rows per page limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-374

I would be grateful if you could vote for one or both of them.

Thank you,
Ben.

------------------------------
Benjamin Thompson
------------------------------

#Informix

Original Message:
Sent: 6/2/2020 12:16:00 PM
From: Benjamin Thompson
Subject: Informix storage limits

Hi community,

I am trying to raise the profile within HCL of a couple of issues related to how Informix stores data on disk and get them on the Informix roadmap. If you have a large system you will be familiar with them already I am sure.

They are the Informix data pages per fragment limit of 16,775,134 and the rows per page limit of 255 rows per page. My opinion is that these limits are going to be more of a problem in the future as a lot of well-established systems are only getting bigger and there is a trend towards Big Data.

The first is the most serious as, if you reach this limit for any table or table partition, no-one can no longer insert any data and dealing with the issue is often not straightforward or quick. Even if you don't ever have a catastrophe, planning around them, putting in place the necessary monitoring and re-organising tables affected can be a drain on DBA time and cause downtime for your business.

I have updated someone else's existing RFE with more information regarding the pages per partition limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-31

And raised my own RFE about the rows per page limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-374

I would be grateful if you could vote for one or both of them.

Thank you,
Ben.

------------------------------
Benjamin Thompson
------------------------------

#Informix

Original Message:
Sent: 6/2/2020 12:24:00 PM
From: Hal Maner
Subject: RE: Informix storage limits

Yes, that existing RFE on pages per fragment limit is probably the one I put out there a while back and the initial feedback I received was that it was not likely to get done, yet I agree this is an important limitation to get rid of.  I will vote for the other one as well.  I hope they get into the plans to address.

Hal Maner

M Systems International, Inc.

Original Message:
Sent: 6/2/2020 12:16:00 PM
From: Benjamin Thompson
Subject: Informix storage limits

Hi community,

I am trying to raise the profile within HCL of a couple of issues related to how Informix stores data on disk and get them on the Informix roadmap. If you have a large system you will be familiar with them already I am sure.

They are the Informix data pages per fragment limit of 16,775,134 and the rows per page limit of 255 rows per page. My opinion is that these limits are going to be more of a problem in the future as a lot of well-established systems are only getting bigger and there is a trend towards Big Data.

The first is the most serious as, if you reach this limit for any table or table partition, no-one can no longer insert any data and dealing with the issue is often not straightforward or quick. Even if you don't ever have a catastrophe, planning around them, putting in place the necessary monitoring and re-organising tables affected can be a drain on DBA time and cause downtime for your business.

I have updated someone else's existing RFE with more information regarding the pages per partition limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-31

And raised my own RFE about the rows per page limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-374

I would be grateful if you could vote for one or both of them.

Thank you,
Ben.

------------------------------
Benjamin Thompson
------------------------------

#Informix

Original Message:
Sent: 6/2/2020 12:16:00 PM
From: Benjamin Thompson
Subject: Informix storage limits

Hi community,

I am trying to raise the profile within HCL of a couple of issues related to how Informix stores data on disk and get them on the Informix roadmap. If you have a large system you will be familiar with them already I am sure.

They are the Informix data pages per fragment limit of 16,775,134 and the rows per page limit of 255 rows per page. My opinion is that these limits are going to be more of a problem in the future as a lot of well-established systems are only getting bigger and there is a trend towards Big Data.

The first is the most serious as, if you reach this limit for any table or table partition, no-one can no longer insert any data and dealing with the issue is often not straightforward or quick. Even if you don't ever have a catastrophe, planning around them, putting in place the necessary monitoring and re-organising tables affected can be a drain on DBA time and cause downtime for your business.

I have updated someone else's existing RFE with more information regarding the pages per partition limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-31

And raised my own RFE about the rows per page limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-374

I would be grateful if you could vote for one or both of them.

Thank you,
Ben.

------------------------------
Benjamin Thompson
------------------------------

#Informix

It would be good in Workgroup edition if use of partitioning for reasons of storage space was separated from PDQ, detach/drop, fragment elimination and other benefits of having Enterrprise Edition, otherwise this solution is only available to a small portion of users.

------------------------------
Benjamin Thompson
------------------------------

Original Message:
Sent: Tue June 02, 2020 12:58 PM
From: Paul Watson
Subject: Informix storage limits

I remember Scott discussing this years ago, he wanted to make every fragmented by default as he claimed it would easier to add more fragments at a later date.  He usually knew what he was taking about

 

Cheers

Paul

 

Original Message:
Sent: 6/2/2020 12:16:00 PM
From: Benjamin Thompson
Subject: Informix storage limits

Hi community,

I am trying to raise the profile within HCL of a couple of issues related to how Informix stores data on disk and get them on the Informix roadmap. If you have a large system you will be familiar with them already I am sure.

They are the Informix data pages per fragment limit of 16,775,134 and the rows per page limit of 255 rows per page. My opinion is that these limits are going to be more of a problem in the future as a lot of well-established systems are only getting bigger and there is a trend towards Big Data.

The first is the most serious as, if you reach this limit for any table or table partition, no-one can no longer insert any data and dealing with the issue is often not straightforward or quick. Even if you don't ever have a catastrophe, planning around them, putting in place the necessary monitoring and re-organising tables affected can be a drain on DBA time and cause downtime for your business.

I have updated someone else's existing RFE with more information regarding the pages per partition limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-31

And raised my own RFE about the rows per page limit:
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-374

I would be grateful if you could vote for one or both of them.

Thank you,
Ben.

------------------------------
Benjamin Thompson
------------------------------

#Informix