oncheck -cDI >>> inconsistency warning
Sh To got an oncheck -cDI warning that data page 0x2c in systables had a bitmap mode mismatch (0xc versus 0x4) and asked whether answering yes was safe. Art Kagel said yes, except for corrupted index rebuilds, which are better dropped and rebuilt manually. Doug Lawry linked an article; Sh To found related APAR IC98053. Resolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello,
In an
oncheckbefore 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-linksI 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
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
------------------------------
Here is a whole article about it :-) https://www.oninitgroup.com/faq-items/informix-upgrades-and-oncheck ------------------------------ Doug Lawry Oninit Consulting ------------------------------
Thanks.
For those who are interested
oncheck -cDI warnings again on the same or different pages...
https://www.ibm.com/support/pages/apar/IC98053And
https://www.oninitgroup.com/faq-items/informix-upgrades-and-oncheck/
(Thanks Lawry)
------------------------------
Sh To
------------------------------