The administrative DBChecker utility was developed to
check the WebSphere Administrative Repository Database
inconsistencies.
Download Description
The WebSphere Application Server administration repository database is
the persistence store for the configuration information for the WebSphere
administrative domain. The repository database contains various tables,
which hold the data related to the configuration of the WebSphere
Application Server.
The administrative 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 (in the sense that
the relationship has valid occurrences of target and source entities in
their respective tables, along with the existence of objects in the
OBJECT_TABLE.)
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 DBChecker please make sure that:
Either you have the WebSphere 3.5.x or 4.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.