Informix

 View Only
  • 1.  oncheck -cDI >>> inconsistency warning

    Posted Mon June 07, 2021 08:01 AM
    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


  • 2.  RE: oncheck -cDI >>> inconsistency warning

    IBM Champion
    Posted Mon June 07, 2021 08:05 AM
    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
    ------------------------------



  • 3.  RE: oncheck -cDI >>> inconsistency warning

    Posted Mon June 07, 2021 12:32 PM

    Here is a whole article about it :-)

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



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



  • 4.  RE: oncheck -cDI >>> inconsistency warning

    Posted Mon June 07, 2021 11:54 PM
    Edited by System Fri January 20, 2023 04:10 PM
    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
    ------------------------------