Maximo Open Forum

 View Only

Related Content

  • 1.  IBM DB2 Errors

    Posted 15 days ago

    Good day, dear experts!
    For some time now, I've been seeing an error in the Windows event log, albeit quite rarely. How can I avoid it in the future and fix it now?
    From the perspective of IBM Maximo users, they don't experience any inconvenience.
    The error looks like this:

    2026-03-31-00.38.01.605000 Instance:CTGINST1 Node:000
    PID:1772(db2syscs.exe) TID:19192 Appid:*LOCAL.CTGINST1.260330213816
    data management sqldDataFetch Probe:6550 Database:VR_PRD
     
    ADM5595E Inconsistent index data was detected for table "SYSIBM "."SYSCOLDIST".
    Run "INSPECT CHECK TABLE NAME
    "SYSCOLDIST" SCHEMA "SYSIBM " INDEXDATA RESULTS KEEP "SYSCOLDIST"_resfile.out" on the failed node and report this error to DB2 Support.

    #EverythingMaximo

    ------------------------------
    Sergey Melnikov
    RusNet
    ------------------------------


  • 2.  RE: IBM DB2 Errors

    Posted 7 days ago

    Hello Sergey ,

    The error looks like the data inconsistency with respect to existing index.

    1. You can give a fresh full system restart. 

    2. You can run below and see whether there is any index inconsistency.

    INSPECT CHECK TABLE NAME "SYSCOLDIST" SCHEMA "SYSIBM" INDEXDATA  RESULTS KEEP SYSCOLDIST_resfile.out 

    3. You may also try to rebuild the index.



    ------------------------------
    Tinnokesh AP
    ------------------------------

    Original Message