AutoFix tool for XMeta

Download Description

This tool is intended to check XMETA repository for broken references and correct them accordingly.

To use the tool, follow these steps:

This tool is included with Information Server 11.7.0.2. To get the tool for 11.5.0.0 - 11.7.0.1, install patch_autofix_xmeta_ALL_11500-11701.

1. Go to <ISHOME>/ASBServer/bin/autoFixXMeta
2. Run "./fixXMeta.sh -preview" to generate SQL fix script if any broken references are found but without automatically executing the script. The SQL fix script generated can be found under <ISHOME>/ASBServer/bin/autoFixXMeta/logs/ location and the script will have the instructions to run it
3. Run "./fixXMeta.sh -applyFix" to generate and execute SQL fix script if any broken references are found to correct them in the XMETA repository
4. Run "./fixXMeta.sh -help" to show help text

Note: Any one of the above three options can be used at a time.

This will check for issues for the references specified in autoFixXMeta.properties file. It generates
a SQL fix script for the broken references and runs it on XMETA repository.

Logs can be found under the directory : <ISHOME>/ASBServer/bin/autoFixXMeta/logs/

More details:

• autoFixXMeta.properties file under <ISHOME>/ASBServer/bin/autoFixXMeta/ maintains the list of references to be checked for issues and correct them in case of any broken references.
• autoFixXMeta.properties file has entries in the form of

    <IssueType>=<Model>.<Class>.<Reference>.<FixType>

     For example: 

DANGLING_REFERENCE=CommonEvent.Subscriber.hasSubscription.NULL_OUT_REFERENCE;investigate.AnalysisOptionsExtended.of_AnalysisOptions.NULL_OUT_REFERENCE

• Supported values for <IssueType> are ABANDONED_REFERENCE, DANGLING_REFERENCE and  UNBALANCED_REFERENCE
• <Model>.<Class>.<Reference> value can be obtained from ISALite XMeta Healthchecker report
• Supported values for <FixType> are NULL_OUT_REFERENCE, ADD_BACK_REFERENCE and DELETE_SOURCE_OBJECT

More entries can be added to autoFixXMeta.properties file with the assistance of IBM support to check and correct other references where issues are found by ISALite XMeta Healthchecker Report. It's strongly recommended to contact IBM support before adding a new reference to autoFixXMeta.properties.

To ensure best results, it's strongly recommended that you run fixXMeta.sh script when there is little or no end user activity on the system that may be updating the content of the XMETA repository, like during overnight hours or over the weekend. The autoFix.sh script takes a fraction of the time taken to run the ISALite XMeta Healthchecker and can therefore be executed more often since it doesn't require end users to not be actively using the tools for a long period of time.