IBM Maximo: Integrity Check Tool

Maximo has an internal tool called Integrity Checker for data integrity and it is also a recommended tool to confirm whether some upgrade process for example was successful.

You can use it for non-upgrade purposes too, specially if you suspect your Maximo data could be corrupted, since the tool reports data integrity issues to be fixed.

Below i show some messages and how to solve = Solutions =

BMXAA0443E -- Erro - BMXAA0443E -- Error - Sequence MAXVARSSEQ not setup correctly
Solution find the highest value for sequence and update sequence:

Drop Sequence LOGINTRACKINGUSEQ ; Create Sequence LOGINTRACKINGUSEQ Start With 3756493 Increment By 1 Nocache Nocycle ; Update maxsequence Set maxreserved=3756493 Where sequencename='LOGINTRACKINGUSEQ';


 * IBM Maximo: Java code to check and update sequence


 * Integrity Checker - Sequence not setup correctly

BMXAA6292E Records exist in the Wogen table which need be deleted.

 * IBM Maximo: Java code to cleanup WOGEN table


 * WOGEN table data growing exponentially

= Ver também =


 * Artigos sobre IBM Maximo
 * Mais Artigos sobre Cloud / WebDev / Tecnologias