The Admin DBChecker utility was developed to check the WebSphereŽ Application Server administrative repository database inconsistencies.
Download Description
The WebSphere Application Server administrative repository database is the persistence store for the configuration information for the administrative domain. The repository database contains various tables, which hold the data related to the configuration of the WebSphere Application Server.
The Admin DBChecker utility was developed to check the administrative repository with respect to the integrity of the information contained in the relationship instance table, and the entity tables, to which those relationships refer. The basic function of this utility is to walk through each of the base or entity tables, and ensure that any relationships that each entity participates in is valid. The relationship of occurrences of target and source entities in their respective tables, along with the existence of objects in the OBJECT_TABLE, can be validated.
This is checked both from the perspective of the entity being the source or owner of the relationship, and from the view of the entity being the target of a relationship with some other entity object.
The initial checks are done for the TYPE_TABLE and REL_DEFN_TABLE. Both tables are scanned and validation is done that the relations exist in REL_DEFN_TABLE must have TYPE_IDs matching to the INSTANCE_IDs in the TYPE_TABLE.
This utility does a full scan on each individual base table, checking that for each row, the TYPE_ID is correct, that the OBJECT_TABLE entries exist for these objects, and that the type_id's agree between the base table and the entry in the OBJECT_TABLE.
LIVE_OBJECT_TABLE and LIVE_OBJ_GRP_TABLE are also scanned, validating that each object has a corresponding OBJECT_TABLE entry.
The binary column in the OBJECT_TABLE is then de-serialized and the object values are printed by using Java reflection API.
For each row in a base table, the utility attempts to validate all relationships defined (in the REL_INSTANCE_TABLE) for that instance. The relationships checked include both those in which the object participates in as the source (owner/parent) and all relationships in which it participates in the role of a target (child).
At the end of a relationship check, the REL_INSTANCE_TABLE is checked and the cardinality of each relation is verified against the cardinality as per in relationship definition in REL_DEFN_TABLE.
Prerequisites
Before running the Admin DBChecker please make sure that:
Either you have the WebSphere Application Server V3.5.x or V4.0.x installed on the local machine
Or admin.jar,repository.jar,ujc.jar,ibmwebas.jar should be located somewhere in the classpath.
Installation instructions
Please view the readme file for detailed instructions.