Chapter 6. Implementing changes to a design (Vn) 301
We also see this new change registered in CM. See Figure 6-65.
Figure 6-65 Changes (ADB2C11)
6.2.6 ANALYZE and RUN
Once the Object Compare job completes, the change can be analyzed and run as a normal
change within CM.
Another way to use Object Compare is to promote changes. You can create a delta file of the
changes that Object Compare found when the GOC job runs. The delta file is stored in the
source system's CM database and can then be imported and registered as a change on the
target system, which can then be analyzed and run within CM.
6.2.7 Specify Ignore Fields (optional)
The use of an ignore file within Object Compare allows you to specify that certain fields in the
DB2 catalog records are to be ignored when objects are compared. An ignore file is used
when GOC is analyzing the changes. You want to compare the source changes to the target
objects but also want to maintain certain values in the target object. An example might be that
you want to preserve certain physical fields like primary and secondary space values or buffer
pools for the database. Ignoring these physical fields by selecting these options in the ignore
file tells Object Compare to ignore and not compare these fields in both the source and target
files. Therefore DB2 Object Compare does not try to change these values and thereby
preserves them.
Some catalog fields are automatically ignored, such as statistics, dates, and internal
identifiers. These are called system ignores and are automatically included by default.
Those fields that you can select are used to protect or preserve the fields from updates. You
might want to use this when comparing test objects to the production system objects.
DB2 Admin ------------------ CM - Changes -------------------- Row 1 to 8 of 8
Command ===> Scroll ===> PAGE
Line commands:
U - Update AN - Analyze RN - Run VE - Versions ST - Statements
PQ - Prerequisites IG - Ignores MA - Masks
? - Show all line commands
Sel ID Owner Name Type Status Comment
* * * * * *
--- -------- -------- ------------------ ------- -------- ------------------->
233 PAOLOR4 ADCOL1GWLTEMP CHANGE COMPLETE AL ADDCOL1 CHAR 12 G
290 PAOLOR4 ALCPRIMKEY1 CHANGE COMPLETE ALC PRIMKEY DEPT_NO
292 PAOLOR4 RALCPRIMKEY RECOVER ANALYZED RECOVER CHANGE FOR H
293 PAOLOR4 GOCDSG24D04 CHANGE DEFINED GOC APRIL 8 CHANGES
******************************* END OF DB2 DATAA ******************************
Note: Ignore fields are applied to both the target and the source objects before the
definitions are compared. No field in the DB2 catalog record for which an ignore is
specified is compared. If an object is dropped and re-created because of other changes,
values for ignored fields are taken from the target version. All other fields have values from
the source version.
302 DB2 for z/OS Administration Tools for Enhanced Change Management
Table 6-3 shows the available Ignore fields.
Table 6-3 The DB2 catalog table ignore fields
DB2 catalog table Ignore fields
SYSCHECKS CREATOR, CHECKCONDITION
SYSCOLUMNS COLTYPE, LENGTH, SCALE, NULLS, REMARKS, DEFAULT, KEYSEQ,
FOREIGNKEY, FLDPROC, LABEL, DEFAULTVALUE, LENGTH2,
TYPESCHEMA, TYPENAME, STATS_FORMAT, PARTKEY_COLSEQ,
PARTKEY_ORDERING, ALTEREDTS
SYSDATABASE CREATOR, STGROUP, BPOOL, ROSHARE, TYPE, GROUP_MEMBER,
ENCODING_SCHEME, SBCS_CCSID, DBCS_CCSID, MIXED_CCSID,
INDEXBP
SYSDATATYPES OWNER, SOURCESCHEMA, SOURCETYPE, METATYPE, LENGTH,
SCALE, SUBTYPE, ENCODING_SCHEME, REMARKS
SYSFIELDS FLDPROC, WORKAREA, EXITPARML, PARMLIST, EXITPARM
SYSINDEXES UNIQUERULE, CLUSTERING, BPOOL, PGSIZE, ERASERULE,
DSETPASS, CLOSERULE, INDEXTYPE, PIECESIZE, COPY, SPACEF,
REMARKS, PADDED, VERSION, OLDEST_VERSION,
CURRENT_VERSION, RELCREATED, AVGKEYLEN
SYSINDEXPART PARTITION, PQTY, SQTY, STORTYPE, STORNAME, VCATNAME,
LIMITKEY, FREEPAGE, PCTFREE, INDEXTYPE, GBPCACHE, SECQTYI,
SPACEF, DSNUM, EXTENTS, PSEUDO_DEL_ENTRIES, LEAFNEAR,
LEAFFAR
SYSSYSKEYS COLSEQ, ORDERING
SYSPARMS OWNER, SPECIFICNAME, CAST_FUNCTION, PARMNAME, ROWTYPE,
ORDINAL, TYPESCHEMA, TYPENAME, LOCATOR, TABLE,
TABLE_COLNO, LENGTH, SCALE, SUBTYPE, CCSID,
ENCODING_SCHEME
SYSRELS RELNAME, DELETERULE, IXOWNER, IXNAME, ENFORCED,
CHECKEXISTINGDATA
SYSROUTINES OWNER, CREATEDBY, SPECIFICNAME, RETURN_TYPE, ORIGIN,
FUNCTION_TYPE, PARM_COUNT, LANGUAGE, COLLID,
SOURCESCHEMA, SOURCESPECIFIC, DETERMINISTIC,
EXTERNAL_ACTION, NULL_CALL, CAST_FUNCTION, SCRATCHPAD,
SCRATCHPAD_LENGTH, FINAL_CALL
SYSSEQUENCES OWNER, SEQTYPE, INCREMENT, START, MAXVALUE, MINVALUE,
CYCLE, CACHE, ORDER, REMARKS, PRECISION, RESTARTWITH
SYSTABLEPART IXNAME, IXCREATOR, PQTY, SQTY, STORTYPE, STORNAME,
VCATNAME, LIMITKEY, FREEPAGE, PCTFREE, COMPRESS,
GBPCACHE, TRACKMOD, SECQTYI, SPACEF, DSNUM, EXTENTS,
LOGICAL_PART
SYSTABLES TYPE, DBNAME, TSNAME, EDPROC, VALPROC, CLUSTERTYPE,
REMARKS, KEYCOLUMNS, STATUS, LABEL, AUDITING, CREATEDBY,
LOCATION, TBCREATOR, TBNAME, DATACAPTURE, CHECKS,
ENCODING_SCHEME

Get DB2 for z/OS Administration Tools for Enhanced Change Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.