SAP Note 17947 - How can you determine the current extent size ?

Component : Informix -

Solution : https://service.sap.com/sap/support/notes/17947 (SAP Service marketplace login required)

Summary :
This SAP Note discusses checking and modifying the storage allocation for database tables regarding the next extent size. For database administrators needing to verify and adjust the space allocated for a table's next extent, the current setting can be identified using the command `oncheck -pt db_name:tab_name`. To modify this setting based on obtained results, the `alter table` command should be used (e.g., `alter table tab_name modify next size anzahl_kb`). The note emphasizes the difference in unit measurements between commands, where `oncheck` reports in pages and `alter table` in kilobytes.

Key words :
alter table atab modify, - alter table tab_name modify, execute alter table, alter table requires, - oncheck -pt db_name, oncheck -pt qih, additional key words, create table, tab_name -ss, additional extent

Related Notes :

548943FAQ: Avoiding disk space problems