Sample compare report 2
The following sample compare report is a full report, which means that it reports all
objects that were compared (in the OBJECT COMPARISON REPORT section), as
opposed to only changed objects. Only user-specified ignores are listed (in the FIELDS
IGNORED WHEN COMPARING SOURCE AND TARGET OBJECTS section).
This report shows objects that are compared, added, and dropped. In this report, the first comparison involves source object RRR8D81A.DSN8S81D and target object TTT8D81A.DSN8S81D (a typical example of a comparison between a development and production system). In this case, objects are also added and dropped. For example, the report shows that a new view named VNDR230.VDEPTS is to be added, and a view named VNDR230.VASTRDE1 is to be dropped.
-----------------------------------------------------------------------------------------------------
GOC2CMP - Compare DB2 Objects 2006-06-10 09:20
-----------------------------------------------------------------------------------------------------
Database 2 Object Comparison Tool
5697-L40 (C) Copyright IBM Corporation 2001, 2006.
All rights reserved. Licensed materials - property of IBM.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP schedule contract with IBM Corp.
TRANSLATION MASKS
=========================================================
DBNAME : RRR8D81A , TTT8D81A
FIELDS IGNORED WHEN COMPARING SOURCE AND TARGET OBJECTS
=======================================================
Only user requested ignore fields are reported
SYSINDEXES : BPOOL(U)
SYSINDEXPART : PQTY(U), SQTY(U), STORTYPE(U), STORNAME(U), VCATNAME(U),
FREEPAGE(U), PCTFREE(U), SECQTYI(U)
SYSTABLEPART : PQTY(U), SQTY(U), STORTYPE(U), STORNAME(U), VCATNAME(U),
FREEPAGE(U), PCTFREE(U), SECQTYI(U)
SYSTABLESPACE : BPOOL(U), MAXROWS(U)
-----------------------------------------------------------------------------------------------------
GOC2CMP - Compare DB2 Objects 2006-06-10 09:20
-----------------------------------------------------------------------------------------------------
OBJECT COMPARISON REPORT
========================
Source: VIEW ADDED, FULL REPORT
Extracted from location *FROM DDL FILE* at 2006-06-10 09:16 by UNKNOWN
Target: TABLESPACE TTT8S81D FROM CATLG
Extracted from DSN8 at 2006-06-10 09:16 by VNDR230
Target system is DB2 Release 810
Compare tablespace source(RRR8D81A.DSN8S81D) and target(TTT8D81A.DSN8S81D)
No changes to Tablespace
Grant(target): Grantor=VNDR230 Grantee:PUBLIC (Kept)
Compare table source(VNDR230.DEPT) and target(VNDR230.DEPT)
No changes to Table
Grant(target): Grantor=VNDR230 Grantee:PUBLIC* (Kept)
Compare index source(VNDR230.XDEPT1) and target(VNDR230.XDEPT1)
No changes to Index
Compare index source(VNDR230.XDEPT2) and target(VNDR230.XDEPT2)
No changes to Index
Compare index source(VNDR230.XDEPT3) and target(VNDR230.XDEPT3)
No changes to Index
View VNDR230.VASTRDE1 not found on source
View VNDR230.VASTRDE1 will be dropped
View VNDR230.VASTRDE2 not found on source
View VNDR230.VASTRDE2 will be dropped
View VNDR230.VDEPMG1 not found on source
View VNDR230.VDEPMG1 will be dropped
Compare View source(VNDR230.VDEPT) and target(VNDR230.VDEPT)
No changes to View
Grant(target): Grantor=VNDR230 Grantee:PUBLIC* (Kept)
View VNDR230.VDEPTS not found on target
New View VNDR230.VDEPTS will be added
Authorisations for View VNDR230.VDEPTS will be copied from source
View VNDR230.VEMPDPT1 not found on source
View VNDR230.VEMPDPT1 will be dropped
Compare View source(VNDR230.VHDEPT) and target(VNDR230.VHDEPT)
No changes to View
Grant(target): Grantor=VNDR230 Grantee:PUBLIC* (Kept)
View VNDR230.VPHONE not found on source
View VNDR230.VPHONE will be dropped
Compare Referential Constraint source(RDD) and target(RDD)
No changes to Referential constraint
Compare Referential Constraint source(RDE) and target(RDE)
No changes to Referential constraint
COMPARISON SUMMARY REPORT
=========================
Obtyp Source Object Target Object Result Object type
----- ----------------------------- ------------------------------ -------------------- ------------
S RRR8D81A.DSN8S81D TTT8D81A.DSN8S81D No change Tablespace
T VNDR230.DEPT VNDR230.DEPT No change Table
X VNDR230.XDEPT1 VNDR230.XDEPT1 No change Index
X VNDR230.XDEPT2 VNDR230.XDEPT2 No change Index
X VNDR230.XDEPT3 VNDR230.XDEPT3 No change Index
R RDD RDD No change Relation
R RDE RDE No change Relation
V VNDR230.VASTRDE1 Dropped View
V VNDR230.VASTRDE2 Dropped View
V VNDR230.VDEPMG1 Dropped View
V VNDR230.VDEPT VNDR230.VDEPT No change View
V VNDR230.VDEPTS Added View
V VNDR230.VEMPDPT1 Dropped View
V VNDR230.VHDEPT VNDR230.VHDEPT No change View
V VNDR230.VPHONE Dropped View
----- ----------------------------- ------------------------------ -------------------- ------------
COMPARISON COUNTS REPORT
=========================
Object type On source On target Compared Added Dropped Altered Not Added Recreated
------------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
Schemas 0 0 0 0 0 0 0 0
User Def Types 0 0 0 0 0 0 0 0
Sequences 0 0 0 0 0 0 0 0
Databases 0 0 0 0 0 0 0 0
Tablespaces 1 1 1 0 0 0 0 0
Tables 1 1 1 0 0 0 0 0
Indexes 3 3 3 0 0 0 0 0
Aliases 0 0 0 0 0 0 0 0
Storage groups 0 0 0 0 0 0 0 0
Synonyms 0 0 0 0 0 0 0 0
Functions 0 0 0 0 0 0 0 0
Stored procedures 0 0 0 0 0 0 0 0
Triggers 0 0 0 0 0 0 0 0
Views 3 7 2 1 5 0 0 0
Relations 2 2 2 0 0 0 0 0
------------------ ---------- ---------- ---------- ---------- ---------- ---------- --------- ---------