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
------------------------------