Limit in Informix 15.0.0.0 - "LO_hdr_partn"
Boycho Velkov asked whether the 16777215-page limit on the LO_hdr_partn sbspace metadata partition still exists in Informix 15. Andreas Legner said yes for now but it need not stay that way. Boycho explained a client with large BLOB/CLOB data must create a new 1 TB sbspace every 6 months, and raised RFE INFX-I-667. Andreas asked for sblob counts per month; the details moved to private mail.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi,
Does the limitation of 16777215 pages in sbspace LO_hdr_partn still exist in Informix 15?
Regarding presentations and other information:
Some instance objects remain unchanged regardless of the infrastructure version such as
...
Internal SLOB space partitions
....
And output of oncheck command give us:
sbspace Metadata Partitions
...
TBLSpace Report for xxxxx:'informix'.LO_hdr_partn
TBLspace Flags 200802 Row Locking
TBLspace uses 4 bit bit-maps
...
This is valid for normal sbspace and external sbspace.
How can I avoid this limit?
Regards,
------------------------------
Boycho Velkov
------------------------------
Hi Boycho, for now, yes, but we think it doesn't need to stay this way, so stay tuned! ------------------------------ Andreas Legner Dev Engineer HCL Software ------------------------------
Thanks, Andreas! ------------------------------ Boycho Velkov ------------------------------
Hi Andreas&Andreas, & I wish you all the best with: IBM TechXchange: Informix Technology Days 2025 on March 12 & 13, 2025 I read that JC Lengyel will be one of the speakers. Can you ask him for this limit in Informix 15.0.0.0 - "LO_hdr_partn". Best Regards, ------------------------------ Boycho Velkov ------------------------------
Hi Boycho, of course this will be possible, but could I ask you to be a little more specific about what you/your business needs and what you'd like to see? We might even be working on exactly that... after all, v15 just got started! Cheers, Andreas ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------
Hi Andreas, One of our clients has a system with big amount of BLOB/CLOB data. Every 6 months we must create a new sbspace about 1TB - with 8 chunks x 140GB, because we reach the limit in LO_hdr_partn in sbspace Metadata Partition in every chunk. So, we will not have a problem in Informix V15 with bigger chunks or partitions in table(which is perfect), but we'll still have a limitation of 16777215 pages in LO_hdr_partn in sbspace Metadata Partition. I know that a lot of work has done into this version and there are a lot of changes to the kernel. I was Beta tester. Respect for your work! ------------------------------ Boycho Velkov ------------------------------
Hi Andreas, I raised an RFE for this limit: Increasing LO_hdr_partn size limit in every chunk in sbspace Metadata partition Increasing LO_hdr_partn | IBM Data and AI Ideas Portal for Customers https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-667 Best regards, ------------------------------ Boycho Velkov ------------------------------
Hi Boycho, noted and appreciated! Would you mind detailing the rate of new sblobs per say month, in terms of number rather than overall space consumption, as this actually is what's "eating" LO header partition space. BR, Andreas ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------
Hi Andreas, Can you send your e-mail address to my e-mail. I'll will answer to you privately. Best regards, ------------------------------ Boycho Velkov ------------------------------
Hi, Voted. Regards, David. ------------------------------ David Williams Senior Database Platform Engineer Flutter London ------------------------------