Informix: Modify Next Extent Size of a Primary Key Index
Posted in 2026
Topics: High Availability & Replication, Storage & Space Management
Dear all,
We have a primary key on a table where the next extent size got way above what we usually add as chunks size for that table (the only table in this DBSpace).
For tables, the
ALTER TABLE <table> MODIFY NEXT SIZE <KB>;
statement exists. But for my current state of knowledge a corresponding statement does not even exist in Informix 15.
All i found in the interwebs was a suggestion to recreate the index and to supply extent and next extend size with the CREATE INDEX statement. But i would like to avoid recreating a primary key for the purpose of changing next extent size.
Can it be updated directly in sysmaster:sysptnhdr? Like
SELECT partn FROM sysfragments WHERE indexname = <index name>;UPDATE sysmaster:sysptnhdr
SET nextsiz = <next size in pages>
WHERE partn = <partn from SELECT above>
;
If this is possible somehow, which engine state would be needed? Stopping application and other inserts is clear but are there any other precautions to take?
BR
Wilhelm
You are subscribed to "Informix" as paul.cdi@oninit.com. To change your subscriptions, go to http://community.ibm.com/community/user/preferences?section=Subscriptions. To unsubscribe from this community discussion, go to [link removed]