Compare version files
Db2 Object Comparison Tool operates on sorted version files. The version file record prefix is the sort key. Masks are applied to the prefix of the source version file before the file is sorted. The result is that objects in the source and target version files are in the same sequence.
- An object was not found in the source version file.
In this case, the object is registered for deletion unless the option to keep target objects was specified through the Suppress DROP of objects field in the Generate Compare Jobs (GOC5) panel.
- An object was not found in the target version file.
In this case, the object definition is saved to create the object at a later stage. Masks are applied to the relevant fields before the object definition DDL is built.
- An object was found in the source and target version files.
In this case, masks are applied to the source version Db2catalog records that describe the source object.
The objects are compared; only fields for which ignore has not been specified (explicitly or by default) are included. The possible results of the comparison are:
- Objects are identical
- Upgrade can be performed by altering the target object
- Upgrade requires drop and re-create of the target object
The differences are reported, and the actions that are required to upgrade the target version to the source version (if any) are written to the CHANGES file for use at a later stage.