Compare Db2 objects sample report 1
The sample batch compare report shown in the following figure contains all sections of the batch compare report. The FIELDS IGNORED WHEN COMPARING SOURCE AND TARGET OBJECTS section shows all fields that were ignored. The OBJECT COMPARISON REPORT section shows only the objects that were changed, added, or dropped.
scale="80">-----------------------------------------------------------------------------------------------------
GOC2CMP - Compare DB2 Objects 2006-06-09 19:01
-----------------------------------------------------------------------------------------------------
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.
Parameters for this run:
Suppress DROP of objects : No
Suppress DROP of columns : No
Suppress adding columns : No
TRANSLATION MASKS
=========================================================
DBNAME : RRR8D81A , TTT8D81A
FIELDS IGNORED WHEN COMPARING SOURCE AND TARGET OBJECTS
=======================================================
SYSAUXRELS : AUXRELOBID(S), IBMREQD(S)
SYSCHECKS : DBID(S), OBID(S), TIMESTAMP(S), RBA(S), IBMREQD(S)
SYSCOLAUTH : TIMESTAMP(S), DATEGRANTED(S), TIMEGRANTED(S), IBMREQD(S),
CONTOKEN(S), GRANTEDTS(S)
SYSCOLUMNS : COLCARD(S), HIGH2KEY(S), LOW2KEY(S), IBMREQD(S), STATSTIME(S),
COLCARDF(S), CREATEDTS(S), ALTEREDTS(S)
SYSDATABASE : DBID(S), IBMREQD(S), CREATEDBY(S), TIMESTAMP(S), CREATEDTS(S),
ALTEREDTS(S), BPOOL(U), INDEXBP(U)
SYSDATATYPES : CREATEDBY(S), DATATYPEID(S), CREATEDTS(S), IBMREQD(S)
SYSDBAUTH : TIMESTAMP(S), DATEGRANTED(S), TIMEGRANTED(S), GRANTEETYPE(S),
IBMREQD(S), GRANTEDTS(S)
SYSFIELDS : IBMREQD(S)
SYSFOREIGNKEYS : IBMREQD(S)
SYSINDEXES : CLUSTERED(S), DBID(S), OBID(S), ISOBID(S), INDEXSPACE(S),
FIRSTKEYCARD(S), FULLKEYCARD(S), NLEAF(S), NLEVELS(S),
SPACE(S), IBMREQD(S), CLUSTERRATIO(S), CREATEDBY(S),
IOFACTOR(S), PREFETCHFACTOR(S), STATSTIME(S),
FIRSTKEYCARDF(S), FULLKEYCARDF(S), CREATEDTS(S), ALTEREDTS(S),
COPYLRSN(S), CLUSTERRATIOF(S), SPACEF(S), BPOOL(U)
SYSINDEXPART : CARD(S), FAROFFPOS(S), LEAFDIST(S), NEAROFFPOS(S), IBMREQD(S),
SPACE(S), STATSTIME(S), FAROFFPOSF(S), NEAROFFPOSF(S),
CARDF(S), ALTEREDTS(S), SPACEF(S), DSNUM(S), EXTENTS(S),
PSEUDO_DEL_ENTRIES(S), LEAFNEAR(S), LEAFFAR(S), CREATEDTS(S),
PQTY(U), SQTY(U), STORTYPE(U), STORNAME(U), VCATNAME(U),
FREEPAGE(U), PCTFREE(U), SECQTYI(U)
SYSKEYCOLUSE : IBMREQD(S)
SYSKEYS : IBMREQD(S)
SYSPACKDEP : IBMREQD(S)
SYSPLANDEP : IBMREQD(S)
SYSPARMS : ROUTINEID(S), DATATYPEID(S), CAST_FUNCTION_ID(S), IBMREQD(S)
SYSRELS : IBMREQD(S), RELOBID1(S), RELOBID2(S), TIMESTAMP(S)
SYSRESAUTH : TIMESTAMP(S), DATEGRANTED(S), TIMEGRANTED(S), IBMREQD(S),
GRANTEDTS(S)
SYSROUTINEAUTH : GRANTEDTS(S), IBMREQD(S)
SYSROUTINES : CREATEDBY(S), ROUTINEID(S), CREATEDTS(S), ALTEREDTS(S),
IBMREQD(S), PARM1(S), PARM2(S), PARM3(S), PARM4(S), PARM5(S),
PARM6(S), PARM7(S), PARM8(S), PARM9(S), PARM10(S), PARM11(S),
PARM12(S), PARM13(S), PARM14(S), PARM15(S), PARM16(S),
PARM17(S), PARM18(S), PARM19(S), PARM20(S), PARM21(S),
PARM22(S), PARM23(S), PARM24(S), PARM25(S), PARM26(S),
PARM27(S), PARM28(S), PARM29(S), PARM30(S)
SYSSCHEMAAUTH : GRANTEDTS(S), IBMREQD(S)
SYSSEQUENCES : NAME(S), SEQUENCEID(S), CREATEDBY(S), CREATEDTS(S),
ALTEREDTS(S), IBMREQD(S)
SYSSEQUENCEAUTH : CONTOKEN(S), GRANTEDTS(S), IBMREQD(S)
SYSSEQUENCESDEP : BSEQUENCEID(S), IBMREQD(S)
SYSSTOGROUP : VPASSWORD(S), SPACE(S), SPCDATE(S), IBMREQD(S), CREATEDBY(S),
STATSTIME(S), CREATEDTS(S), ALTEREDTS(S), SPACEF(S)
SYSSYNONYMS : IBMREQD(S), CREATEDBY(S), CREATEDTS(S)
SYSTABAUTH : TIMESTAMP(S), DATEGRANTED(S), TIMEGRANTED(S), IBMREQD(S),
GRANTEDTS(S)
SYSTABCONST : CREATEDTS(S), IBMREQD(S)
SYSTABLEPART : CARD(S), FARINDREF(S), NEARINDREF(S), PERCACTIVE(S),
PERCDROP(S), IBMREQD(S), CHECKRID(S), SPACE(S), PAGESAVE(S),
STATSTIME(S), CHECKRID5B(S), EPOCH(S), CARDF(S), ALTEREDTS(S),
SPACEF(S), DSNUM(S), EXTENTS(S), LIMITKEY_INTERNAL(S),
CREATEDTS(S)
SYSTABLES : DBID(S), OBID(S), CLUSTERRID(S), CARD(S), NPAGES(S),
PCTPAGES(S), IBMREQD(S), PARENTS(S), CHILDREN(S), KEYOBID(S),
CHECKRID(S), CREATEDBY(U), CREATEDTS(S), ALTEREDTS(S),
RBA1(S), RBA2(S), PCTROWCOMP(S), STATSTIME(S), CARDF(S),
CHECKRID5B(S), NPAGESF(S), SPACEF(S), AVGROWLEN(S),
RELCREATED(S)
SYSTABLESPACE : DBID(S), OBID(S), PSID(S), NTABLES(S), NACTIVE(S), SPACE(S),
IBMREQD(S), ROOTNAME(S), ROOTCREATOR(U), CREATEDBY(S),
STATSTIME(S), CREATEDTS(S), ALTEREDTS(S), NACTIVEF(S),
SPACEF(S), BPOOL(U)
SYSTRIGGERS : DBID(S), OBID(S), CREATEDBY(S), CREATEDTS(S), IBMREQD(S)
SYSVIEWDEP : IBMREQD(S)
SYSVIEWS : IBMREQD(S), RELCREATED(S), REFRESH_TIME(S), SIGNATURE(S)
SYSVOLUMES : IBMREQD(S)
(S) System ignore. Set automatically by compare
Also set for fields only used by newer versions of DB2
(U) User ignore. Requested by user input
(U) is reported for fields that are both System and User ignores
-----------------------------------------------------------------------------------------------------
GOC2CMP - Compare DB2 Objects 2006-06-09 19:01
-----------------------------------------------------------------------------------------------------
OBJECT COMPARISON REPORT
========================
Only changed, added and deleted objects will be reported
Source: VIEW ADDED
Extracted from location *FROM DDL FILE* at 2006-06-09 18:57 by UNKNOWN
Target: TABLESPACE TTT8S81D FROM CAT
Extracted from DSN8 at 2006-06-09 18:57 by VNDR230
Target system is DB2 Release 810
View VNDR230.VDEPTS not found on target
New View VNDR230.VDEPTS will be added
Authorisations for View VNDR230.VDEPTS will be copied from source
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 VNDR230.VASTRDE1 No change View
V VNDR230.VASTRDE2 VNDR230.VASTRDE2 No change View
V VNDR230.VDEPMG1 VNDR230.VDEPMG1 No change View
V VNDR230.VDEPT VNDR230.VDEPT No change View
V VNDR230.VDEPTS Added View
V VNDR230.VEMPDPT1 VNDR230.VEMPDPT1 No change View
V VNDR230.VHDEPT VNDR230.VHDEPT No change View
V VNDR230.VPHONE VNDR230.VPHONE No change View
----- ----------------------------- ------------------------------ -------------------- ------------
COMPARISON COUNTS REPORT
=========================
Object type On source On target Compared Added Dropped Altered Not Added Recreated
------------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
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
Views 8 7 7 1 0 0 0 0
Relations 2 2 2 0 0 0 0 0
If the comparison summary report includes any object names that are longer than 18 characters, those names are displayed across multiple rows, in the same column and with the same indentation, as shown in the following example:
COMPARISON SUMMARY REPORT
=========================
Obtyp Source Object Target Object Result Object type
----- ------------------------------- ------------------------------- -------------------- ------------
D TESTECUS TESTECUS No change Database
S TESTECUS.SH4909AB TESTECUS.SH4909AB No change Tablespace
T VIV1.EC_DOC_ATTRIBUTEDDDDEC_DO VIV1.EC_DOC_ATTRIBUTEDDDDEC_DO Altered Table
C_ATTRIBUTEDDDDFOGHTRESDFREEC_ C_ATTRIBUTEDDDDFOGHTRESDFREEC_
DOC_ATTRIBUTEDDDDEC_DOC_ATTRIB DOC_ATTRIBUTEDDDDEC_DOC_ATTRIB
UTEDDDDEC_DOC_ATTRIBUTED112ABC UTEDDDDEC_DOC_ATTRIBUTED112ABC
DEABCDEDRASDF DEABCDEDRASDF
X VIV1.SH4909ABA1SH4909ABA1SH49 VIV1.SH4909ABA1SH4909ABA1SH49 No change Index
X VIV1.SH4909ABA2SH4909ABA2SH49 VIV1.SH4909ABA2SH4909ABA2SH49 No change Index
0 0
X VIV1.SH4909ABA3SH4909ABA3SH49 Added Index
09ABA3SH4909ABA3ASDFGSH4909AB
A3SH4909ABA3SH4909ABA3SH4909A
BA3SH4909ABA3SH4909ABA3SH4909
ABA3FGSH4909
X VIV1.SH4909ABA4SH4909ABA4SH4S Added Index
H
X VIV1.SH4909ABPK VIV1.SH4909ABPK No change Index
S TESTECUS.SH4914 TESTECUS.SH4914 No change Tablespace
T VIV1.EC_ATTRIBUTE_TYP Added Table
X VIV1.SH4914PK VIV1.SH4914PK Altered Index
T VIV1.EC_ATTRIBUTE_TYP_CD Dropped Table
T VIV1.EC_ATTRIBUTE_TYP_CD_TABLE Dropped Table
WITH_LONG_NAME_TESTINGSUITE
----- ------------------------------- ------------------------------- -------------------- ------------