Lu:
The manual for v11.50 does not specify a default value, but it does state that the value in the onconfig.std (sample ONCONFIG file) is '0', so that is likely the default (you can find out by running this query:
select * from sysconfig where cf_name = 'MAX_FILL_DATA_PAGES';
The cf_default column holds the default for the parameter and the cf_effective holds the current value that is in effect in the server, whether or not the parameter is present in the ONCONFIG file.
The problem with turning this parameter on in earlier releases (prior to 14.10.FC3 I believe) is that there was not cache of variable length pages with more the 10% free space so sometimes an INSERT would have to search multiple pages that had a bitmap entry that indicates that it has at least some free space, but that might not have enough free space to allow the new row to be placed there, especially on a table that experiences periodic deletes or updates that shrink existing rows' lengths (freeing up space on the page). Later releases introduced a cache (PFSC in 12.10) and later v14.10 releases populate the cache on server startup (PFSC_BOOST) making it more efficient and finally useful for nearly all variable length tables.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Tue August 05, 2025 09:24 AM
From: chuan lu
Subject: oncheck warning,What impact will it have on the future?
Ok, I make sense. Althrough I can't see that parameter in ONCONFIG, but it really exists with default value.
------------------------------
chuan lu
Original Message:
Sent: Tue August 05, 2025 01:48 AM
From: Doug Lawry
Subject: oncheck warning,What impact will it have on the future?
This proves MAX_FILL_DATA_PAGES is in 11.50.FC9:
https://www.ibm.com/mysupport/s/defect/aCIKe000000XmUyOAK/dt412502
------------------------------
Doug Lawry
Oninit Consulting
Original Message:
Sent: Mon August 04, 2025 10:13 PM
From: chuan lu
Subject: oncheck warning,What impact will it have on the future?
Thanks for you time.
The IDS version is 11.50FC9W3, so the parameter MAX_FILL_DATA_PAGES doesn't exist.
lu chuan
Original Message:
Sent: 8/4/2025 12:32:00 PM
From: Andreas Legner
Subject: RE: oncheck warning,What impact will it have on the future?
Does the table have varchar columns?
If so, what's the MAX_FILL_DATA_PAGES configuration on either side?
Tables (partitions) have bitmaps tracking data pages' fullness, in case of data pages there's only semi-full and full.
In a table using varchars, i.e. a variable row length, whether a particular page is considered semi-full or full, depends on MAX_FILL_DATA_PAGES setting.
'bitmap mode' is the bitmaps record of a given page's fullness, 'calculated mode' is oncheck's view on things (which depends on MAX_FILL_DATA_PAGES).
HTH,
Andreas
------------------------------
Andreas Legner
Informix Dev
HCL Software
Original Message:
Sent: Mon August 04, 2025 10:05 AM
From: chuan lu
Subject: oncheck warning,What impact will it have on the future?
Hi, expert:
The customer restore the instance into another machine ,and run oncheck on the whole database, it report below errors . but I can't see those errors in the production environment.
TBLspace data check for gapsdb:gaps.beps_fft_qydjb
WARNING: data page 0xb240 in tablespace 0x60016b appears to be
more or less full than is indicated in the bitmap.
Bitmap mode:0xc,Calcuated mode:0x4.
data page x111df in tablespace 0x60016b appears to be more or less full than is indicated in the bitmap
.Bitmap mode:0xc，cacuated mode:0x4.
I have two question.
1)What impact will it have on the future?
2）What does Bitmap mode and Calcuated mode mean？
What impact will it have on the future?
any suggestion are welcome.
------------------------------
chuan lu
------------------------------