Yes, it is safe to allow oncheck to correct any problems that it finds correctable. The only exception is corrupted index rebuilds and only because oncheck uses a single threaded sort to rebuild the damaged index so it is slow and will lock the table. Better to drop and rebuild it manually using PSORT_NPROCS or positive PDQPRIORITY and building it with the ONLINE keyword to avoid locking the table.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Mon June 07, 2021 08:00 AM
From: Sh To
Subject: oncheck -cDI >>> inconsistency warning
Hello,
In an oncheck before upgrade that i took from here
https://youtu.be/xsylAz5U1sY?t=1374
oncheck -cDI devdb
https://www.ibm.com/docs/en/informix-servers/12.10?topic=utility-oncheck-cd-oncheck-cd-commands-check-pages
https://www.ibm.com/docs/en/informix-servers/12.10?topic=utility-oncheck-ci-ci-check-index-node-links
I get this warning
TBLspace data check for devdb:informix.systables
WARNING: data page 0x2c in tablespace 0xb00002 appears to be
more or less full than is indicated in the bitmap.
Bitmap mode: 0xc, Calculated mode: 0x4.
Reset the bitmap mode for this page?
Is it safe and right to answer yes ?
Thanks
------------------------------
Sh To
------------------------------
#Informix