Sample compare report 4
The following sample compare report shows a subset of the report when LOB objects are
converted from explicit to implicit. The OBJECT COMPARISON REPORT section
includes messages about the converted objects. The COMPARISON SUMMARY REPORT
section lists all objects and the end result of the action performed.
OBJECT COMPARISON REPORT
==========================
Tablespace DB33971.TL971APN not found on target
New LOB Tablespace DB33971.TL971APN will be added
Compare tablespace source(DB33971.TL971AP1) and target(DB33971.TL971AP1)
No changes to Tablespace
Compare tablespace source(DB33971.TL971AP2) and target(DB33971.TL971AP2)
No changes to Tablespace
Compare tablespace source(DB33971.TL971AP3) and target(DB33971.TL971AP3)
No changes to Tablespace
Tablespace DB33971.TL971BP1 not found on target
New LOB Tablespace DB33971.TL971BP1 will be added
Compare tablespace source(DB33971.TS33971A) and target(DB33971.TS33971A)
(A)Field NUMPARTS changed from 3 to 4
Tablespace will be altered
Tablespace DB33971.TS33971B not found on target
New Tablespace DB33971.TS33971B will be added
Compare table source(VNDR1.TB33971A) and target(VNDR1.TB33971A)
(D)Column CLOB2 added
(A)Partition(s) added to the target table
Auxiliary table VNDR1.TB971AP1 processed
Auxiliary table VNDR1.TB971AP2 processed
Auxiliary table VNDR1.TB971AP3 processed
Auxiliary table VNDR1.TB971APN added
ADB7163W The number of auxiliary tables associated with the source
table might not be consistent with the number of LOB columns
in the source table and with the number of partitions in the
table space. Implicit LOB objects are used when the base
table is re-created. After changes are applied, ensure that
one auxiliary table exists for each LOB column in each
partition.
Table VNDR1.TB33971A is partitioned and will be dropped by dropping tablespace DB33971.TS33971A
Table will be recreated
Table data will not be converted
Not eligible for FORMAT INTERNAL processing
Table VNDR1.TB33971B not found on target
Auxiliary table VNDR1.TB971BP1 processed
ADB7150W Source contains incomplete set of explicit LOB objects
therefore all LOB objects for this base table will be created
implicitly.
New Table VNDR1.TB33971B will be added
Compare index source(VNDR1.IX33971A) and target(VNDR1.IX33971A)
Index VNDR1.IX33971A will be dropped by dropping the tablespace
Index will be recreated because the base table will be dropped and recreated
Index VNDR1.IX33971B not found on target
New Index VNDR1.IX33971B will be added
Index VNDR1.IX971APN not found on target
This is an index on auxiliary table.
The index is will not be created because the auxiliary table has been converted from explicit to implicit.
The respective index will be created implicitly by DB2.
Compare auxiliary index source(VNDR1.IX971AP1) and target(VNDR1.IX971AP1)
Index VNDR1.IX971AP1 will be dropped
Index will not be recreated because the auxiliary table has been converted from explicit to implicit
Compare auxiliary index source(VNDR1.IX971AP2) and target(VNDR1.IX971AP2)
Index VNDR1.IX971AP2 will be dropped
Index will not be recreated because the auxiliary table has been converted from explicit to implicit
Compare auxiliary index source(VNDR1.IX971AP3) and target(VNDR1.IX971AP3)
Index VNDR1.IX971AP3 will be dropped
Index will not be recreated because the auxiliary table has been converted from explicit to implicit
Index VNDR1.IX971BP1 not found on target
This is an index on auxiliary table.
The index is will not be created because the auxiliary table has been converted from explicit to implicit.
The respective index will be created implicitly by DB2.
COMPARISON SUMMARY REPORT
=========================
Obtyp Source Object Target Object Result Object type
----- ------------------------------- ------------------------------- -------------------- --------------
D DB33971 DB33971 No change Database
S DB33971.TL971APN Not added Tablespace
T VNDR1.TB971APN Not added Table
X VNDR1.IX971APN Not added Index
S DB33971.TL971AP1 DB33971.TL971AP1 No change Tablespace
T VNDR1.TB971AP1 VNDR1.TB971AP1 Dropped Table
X VNDR1.IX971AP1 VNDR1.IX971AP1 Dropped Index
S DB33971.TL971AP2 DB33971.TL971AP2 No change Tablespace
T VNDR1.TB971AP2 VNDR1.TB971AP2 Dropped Table
X VNDR1.IX971AP2 VNDR1.IX971AP2 Dropped Index
S DB33971.TL971AP3 DB33971.TL971AP3 No change Tablespace
T VNDR1.TB971AP3 VNDR1.TB971AP3 Dropped Table
X VNDR1.IX971AP3 VNDR1.IX971AP3 Dropped Index
S DB33971.TL971BP1 Not added Tablespace
T VNDR1.TB971BP1 Not added Table
X VNDR1.IX971BP1 Not added Index
S DB33971.TS33971A DB33971.TS33971A Altered Tablespace
T VNDR1.TB33971A VNDR1.TB33971A Dropped/created Table
X VNDR1.IX33971A VNDR1.IX33971A Dropped/created Index
S DB33971.TS33971B Added Tablespace
T VNDR1.TB33971B Added Table
X VNDR1.IX33971B Added Index
----- ------------------------------- ------------------------------- -------------------- --------------
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 1 1 1 0 0 0 0 0
Tablespaces 7 4 4 1 0 1 2 0
Tables 7 4 4 1 0 0 2 0
Indexes 7 4 4 1 0 0 2 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 0 0 0 0 0 0 0 0
Column masks 0 0 0 0 0 0 0 0
Row permissions 0 0 0 0 0 0 0 0
Relations 0 0 0 0 0 0 0 0
------------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------