Maximo Open Forum

 View Only
  • 1.  IBM DB2 Errors

    Posted 03-31-2026 01:47

    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 04-07-2026 10:01

    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
    ------------------------------



  • 3.  RE: IBM DB2 Errors

    Posted 05-25-2026 15:36

    Hello!
    Thank you so much for your reply!
    I tried rebuilding the indexes this way, but it's a system-wide operation, and those commands don't work.
    I also tried running db2dart, but that command requires a service password.



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



Newest Episode
Ep. 4 | System Properties in IBM Maximo

Watch Steven Shull walk through practical IBM Maximo system properties that can improve usability, query behavior, attachment handling, and the overall Maximo user experience.

MORE by Naviam Episode 4 cover
Watch Episode 4
Also available: Ep. 3 | Work Order Role-Based Application