Displaying posts tagged with

“database”

ITM TDW Schema

Not that there is a lot to the TDW layout, but knowing the schema assists in the documentation process and developing queries and procedures of the TDW (Tivoli Data Warehouse). Make short work of this by using the opensource tools of SchemaSpy and Graphviz SchemaSpy is a jar file that supports over 21 DBs, including [...]

TEMS dies: EIB Table Corruption

Sympton: TEMS process dies. Getting “Verify of <table> failed” in ms logs. Possible EIB Table corruption.   root@someserver:/tmp> /opt/IBM/ITM/ls3263/ms/bin/kgldbutl < qa1cstsc.def root@someserver:/tmp> root@someserver:/tmp> /opt/IBM/ITM/ls3263/ms/bin/kgldbutl < qa1cstsc.def Enter DataBase Utility Command Enter DataBase Utility Command DataBase file QA1CSTSC created Enter DataBase Utility Command Index PrimaryIndex,U for database QA1CSTSC created Enter DataBase Utility Command