Expand all | Collapse all

oncheck -cDI >>> inconsistency warning

  • 1.  oncheck -cDI >>> inconsistency warning

    Posted 6 days ago

    In an oncheck before upgrade that i took from here

    oncheck -cDI devdb

    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 ?


    Sh To

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

    Posted 6 days ago
    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 S. Kagel, President and Principal Consultant
    ASK Database Management Corp.

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

    Posted 6 days ago

    Here is a whole article about it :-)

    Doug Lawry
    Oninit Consulting

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

    Posted 5 days ago
    Edited by Sh To 5 days ago

    For those who are interested

    oncheck -cDI warnings again on the same or different pages...
    And (Thanks Lawry)

    Sh To