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


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/IC98053
And
https://www.oninitgroup.com/faq-items/informix-upgrades-and-oncheck/ (Thanks Lawry)

------------------------------
Sh To
------------------------------

Original Message:
Sent: Mon June 07, 2021 12:31 PM
From: Doug Lawry
Subject: oncheck -cDI >>> inconsistency warning

Here is a whole article about it :-)

https://www.oninitgroup.com/faq-items/informix-upgrades-and-oncheck

------------------------------
Doug Lawry
Oninit Consulting
------------------------------