Sample full compare report
The following sample compare report is a full report, which means that it reports all objects that were compared, as opposed to only changed objects. A full report is generated when the Only changed objects field is set to NO on the Specify Compare Reporting Options (GOC5RO) panel.
-----------------------------------------------------------------------------------------------------------------------
GOC2CMP - Compare DB2 Objects 2026-05-26 14:29
-----------------------------------------------------------------------------------------------------------------------
Database 2 Object Comparison Tool
5698-AT3 Copyright IBM Corporation 2001, 2020.
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 :
CMDELTA mode produces statements intended for the Register
process of Change Management. The reports produced in CMDELTA
mode contain messages that are unique to this mode. Messages
indicating the action that will be taken for those changed
objects, such as the object will be dropped or altered, are
not applicable in CMDELTA mode and should be ignored. The
reports produced by the Analyze phase of Change Management
can be used to understand the actions taken on the changed
objects.
Suppress DROP of objects : Yes
Suppress DROP of columns : No
Suppress adding columns : No
Run SQLID : TS5764
TRANSLATION MASKS
=================
No translation masks specified in this run.
VERIFICATION MASKS
==========
OVERWRITES
==========
IXPCTFREE : SC597572.IU2_TB597571, 9
IXPRIQTY : SC597572.IP_TB597571, 25%
IXSECQTY : SC597572.IP_TB597571, 25%
Processed top down. First overwrite of a given type that fits a name will be used.
When rexx user exit returns value - ,masking will look for next overwrite of the same mask type.
RENAME INFORMATION
==================
No rename information specified in this run.
FIELDS IGNORED WHEN COMPARING SOURCE AND TARGET OBJECTS
=======================================================
Only user requested ignore fields are reported
SYSTABLEPART : DSSIZE(U)
SYSTABLESPACE : DSSIZE(U)
-----------------------------------------------------------------------------------------------------------------------
GOC2CMP - Compare DB2 Objects 2026-05-26 14:29
-----------------------------------------------------------------------------------------------------------------------
CMDELTA OBJECT COMPARISON REPORT
==============================
Original values will be applied to ignored fields of new objects.
Source:
Extracted from location *FROM DDL FILE* at 2026-05-26 14:29 by TS5764
Target:
Extracted from ADA1 at 2026-05-26 14:29 by TS5764
Target system is DB2 Release 1315
Compare database source(DB597572) and target(DB597572)
No changes to database
Compare tablespace source(DB597572.TL597571) and target(DB597572.TL597571)
No changes to Tablespace
Compare tablespace source(DB597572.TG597571) and target(DB597572.TG597571)
No changes to Tablespace
Compare table source(SC597572.TB597572) and target(SC597572.TB597572)
Auxiliary table SC597572.TB597572_AUX processed
No changes to Table
Compare index source(SC597572.IP_TB597572) and target(SC597572.IP_TB597572)
(A)Field PIECESIZE changed from '4 G' to '128 G'
Index will be altered
Compare auxiliary index source(SC597572.IU_TB597572_AUX) and target(SC597572.IU_TB597572_AUX)
(A)Field PIECESIZE changed from '4 G' to '128 G'
Index will be altered
Compare tablespace source(DB597572.TR597571) and target(DB597572.TR597571)
No changes to Tablespace
Compare table source(SC597572.TB597571) and target(SC597572.TB597571)
Source and/or target tablespaces use table-controlled partitioning
Comparison results may not reflect actual object differences
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 multiplied by 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.
No changes to Table
Compare index source(SC597572.IP_TB597571) and target(SC597572.IP_TB597571)
(A)Field PRIQTY changed from 72 to 20
(A)Field SECQTY changed from 72 to 20
Partition 1
(I)Field PRIQTY changed from 72 to 20
PRIQTY value from index level is propagated to every partition.
(I)Field SECQTY changed from 72 to 20
SECQTY value from index level is propagated to every partition.
(A)Field DSSIZE changed from 1G to 32G
Partition 2
(I)Field PRIQTY changed from 72 to 20
PRIQTY value from index level is propagated to every partition.
(I)Field SECQTY changed from 72 to 20
SECQTY value from index level is propagated to every partition.
Partition 3
(I)Field PRIQTY changed from 72 to 20
PRIQTY value from index level is propagated to every partition.
(I)Field SECQTY changed from 72 to 20
SECQTY value from index level is propagated to every partition.
(A)Field DSSIZE changed from 1G to 32G
Partition 4
(I)Field PRIQTY changed from 72 to 20
PRIQTY value from index level is propagated to every partition.
(I)Field SECQTY changed from 72 to 20
SECQTY value from index level is propagated to every partition.
(A)Field DSSIZE changed from 4G to 32G
Partition 5
(I)Field PRIQTY changed from 72 to 20
PRIQTY value from index level is propagated to every partition.
(I)Field SECQTY changed from 72 to 20
SECQTY value from index level is propagated to every partition.
Index will be altered
Compare index source(SC597572.IU1_TB597571) and target(SC597572.IU1_TB597571)
(A)Field DSSIZE changed from 128G to 256G
Partition 1
(D)Field DSSIZE changed from 1G to 1G
DSSIZE value from index level is propagated to every partition.
Therefore the value for this partition needs to be altered.
Partition 3
(D)Field DSSIZE changed from 1G to 1G
DSSIZE value from index level is propagated to every partition.
Therefore the value for this partition needs to be altered.
Partition 4
(D)Field DSSIZE changed from 4G to 4G
DSSIZE value from index level is propagated to every partition.
Therefore the value for this partition needs to be altered.
Partition 5
(D)Field DSSIZE changed from 1G to 1G
DSSIZE value from index level is propagated to every partition.
Therefore the value for this partition needs to be altered.
Index SC597572.IU1_TB597571 will be dropped
Index will be recreated
Compare index source(SC597572.IU2_TB597571) and target(SC597572.IU2_TB597571)
(A)Field FREEPAGE changed from 5 to 0
(A)Field PCTFREE changed from 10 to 9
(I)Field FREEPAGE changed from 5 to 0
FREEPAGE value from index level is propagated to every partition.
(I)Field PCTFREE changed from 10 to 9
PCTFREE value from index level is propagated to every partition.
Index will be altered
Compare index source(SC597572.IX1_TB597571) and target(SC597572.IX1_TB597571)
(A)Field PIECESIZE changed from '128 G' to '32 G'
Index will be altered
Compare index source(SC597572.IX2_TB597571) and target(SC597572.IX2_TB597571)
(A)Field PIECESIZE changed from '128 G' to '32 G'
Index will be altered
Compare index source(SC597572.IX3_TB597571) and target(SC597572.IX3_TB597571)
No changes to Index
COMPARISON SUMMARY REPORT
=========================
Obtyp Source Object Target Object Result Object type
----- ------------------------------- ------------------------------- -------------------- ---------------
D DB597572 DB597572 No change Database
S DB597572.TL597571 DB597572.TL597571 No change Tablespace
T SC597572.TB597572_AUX SC597572.TB597572_AUX No change Table
X SC597572.IU_TB597572_AUX SC597572.IU_TB597572_AUX Altered Index
S DB597572.TG597571 DB597572.TG597571 No change Tablespace
T SC597572.TB597572 SC597572.TB597572 No change Table
X SC597572.IP_TB597572 SC597572.IP_TB597572 Altered Index
S DB597572.TR597571 DB597572.TR597571 No change Tablespace
T SC597572.TB597571 SC597572.TB597571 No change Table
X SC597572.IP_TB597571 SC597572.IP_TB597571 Altered Index
X SC597572.IU1_TB597571 SC597572.IU1_TB597571 Dropped/created Index
X SC597572.IU2_TB597571 SC597572.IU2_TB597571 Altered Index
X SC597572.IX1_TB597571 SC597572.IX1_TB597571 Altered Index
X SC597572.IX2_TB597571 SC597572.IX2_TB597571 Altered Index
X SC597572.IX3_TB597571 SC597572.IX3_TB597571 No change Index
----- ------------------------------- ------------------------------- -------------------- ---------------
COMPARISON COUNTS REPORT
=========================
Object type On source On target Compared Added Kept 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
Sequence aliases 0 0 0 0 0 0 0 0
Global Variables 0 0 0 0 0 0 0 0
Databases 1 1 1 0 0 0 0 0
Tablespaces 3 3 3 0 0 0 0 0
Tables 3 3 3 0 0 0 0 0
Indexes 8 8 8 0 0 6 0 1
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
---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------