DB2 Object Comparison Tool Version 2.1

Click on an APAR number to display the full information for that APAR. There may be a few days delay after the APAR closes before it is available on this website.
Click on a PTF number to download that PTF. You will need an IBMID. Latest update: 6 July 2023

APAR	CLOSE DATE	PTF(s)	HIPER?	Abstract
DB2 Object Comparison Tool Version 2.1
PK03210	29_Jun 2005	UK05020		VIEW DEFINED JOINING TWO TABLES IS MISSING AFTER COMPARE
PK03862	29_Jun 2005	UK05020		OBJECT COMPARES DROPS OBJECTS WHEN KEEPTGT SPECIFIED AND ALSO REPORTS OBJECTS WILL BE KEPT
PK03080	27_Apr 2005	UK02920		DURING COMPARE OF A DATABASE THE RESULTING APPLY REORG STATEMENT OMITTED DATABASE NAME AND TABLESPACE NAME
PK03521	27_Apr 2005	UK02920		OBJECT COMPARE GIVES INCORRECT MESSAGE WHEN CHANGING A A PARTITIONING INDEX
PK01927	18_Apr 2005	UK02534		OBJECT COMPARE LOOP IN GOC2CMP MODULE
PQ93034	19_Feb 2005	UK00734		OBJECT COMPARE DOES NOT PRESERVE ALL PARTS OF SOURCE STORED PROCEDURE
PQ98613	19_Feb 2005	UK00734		OBJECT COMPARE DOES NOT GENERATE A DROP FOR VIEWS WHEN CHANGING PATH SCHEMAS
PQ98720	31_Jan 2005	UK00145		OBJECT COMPARE SETS CURRENT TERMINATOR INCORRECTLY IN A WORK STATEMENT LIST
PQ97638	27_Dec 2004	UK00065		OBJECT COMPARE DOES NOT INTERPRET DSSIZE CORRECTLY
PQ94158	3_Dec 2004	UQ95800		OBJECT COMPARE IS MISSING JOBPARM STATEMENT IN THE APPLY JOB(S) JCL
PQ96382	3_Dec 2004	UQ95847		RETRO-FIT OF PQ93847 TO GOC RELEASE 210 ( OBJECT COMPARE DOES NOT ALWAYS PRESERVE THE PATH STATEMENT )
PQ94908	4_Nov 2004	UQ94718		CLUSTER INDEX CHANGES NOTED DURING OBJECT COMPARISON, BUT NO REORG GENERATED WHEN USING OPTION "ALL RELEVENT"
PQ95533	4_Nov 2004	UQ94718		COLUMN DROPPED FROM TABLE WHEN SUPPRESS DROP OF COLUMN WAS SET TO YES
PQ95566	4_Nov 2004	UQ94718		TWO REFERENTIAL CONSTRAINTS ARE ATTEMPTED TO BE ADDED WITH THE SAME NAME
PQ94907	13_Oct 2004	UQ93992		TSO PREFIX COULD CAUSE RC16 RC=16 IN REXX EXEC GOCGAJOB DURING LISTDSI DATASET RECALL COMMAND
PQ93402	6_Oct 2004	UQ93710		IBM INTERNALLY FOUND PROBLEM: OBJECT COMPARE WITH ENFORCE NO (LOAD JOB IN HPU UNLOAD).
PQ91166	30_Aug 2004	UQ92384		INCONSISTENT CHANGE RESULTS FROM OBJECT COMPARE
PQ88662	16_Aug 2004	UQ91915		OBJECT COMPARE GOCGAJOB SIGNAL ERROR AND UNKNOWN CHANGES RECORD GIVES INCORRECT REORG STATEMENT
PQ90398	16_Aug 2004	UQ91915		SQLCODE672 SEEN WHEN PROCESSING FROM WSL WITH OBJECTS CONTAININGRESTRICT ON DROP
PQ90733	16_Aug 2004	UQ91915		OBJECT COMPARE INCORRECTLY DETECTS A DIFFERENCE IN A CONSTRAINT
PQ84056	16_Aug 2004	UQ91915		JOB OUTPUT SHOWS SOURCE AND TARGET EXTRACTED FROM THE SAME DB2 SUBSYSTEM WHEN SOURCE CAME FROM A DIFFERENT LOCATION
PQ88258	16_Aug 2004	UQ91915		GOCGAJOB EXEC FAILURE AT LINE 1581: SIGNAL ERROR, WHEN COMPARINGDDL TO DDL ALONG WITH UTILITY JOBS BEING GENERATED
PQ91926	5_Aug 2004	UQ91421		OBJECT COMPARE INCLUDES INVALID TEMPLATE STATEMENT
PQ81262	27_May 2004	UQ88995		LOSS OF RI COULD OCCUR, IF DDL IS FROM "USER CREATED" DDL, AND ALL OBJECTS FROM SOURCE DURING A COMPARE ARE NOT AVAILABLE.
PQ84661	20_May 2004	UQ88686		OBJECT COMPARE GENERATES DIFFERENT CCSID FOR CERTAIN TYPE OF COMPARE OPTIONS
PQ82446	12_May 2004	UQ88686		OBJECT COMPARE UNLOAD DOES NOT CALCULATE ADEQUATE SIZE FOR THE UNLOAD DATASET
PQ82143	7_May 2004	UQ88686		INCORRECT RESULTS IN STEP T03COMP WITH IGNORES DATA LIKE SYSCOLUMNS:FOREIGNKEY
PQ83319	5_May 2004	UQ88132		CONSTRAINT FOR PRIMARY KEY NOT GENERATED AND INVALID UNIQUE CONSTRAINT IS GENERATED
PQ81425	5_May 2004	UQ88132		OBJECT COMPARE DOES NOT PRESERVE COMMENTS ON COLUMNS AND TABLES WHEN IGNORE FILE FOR REMARKS USED ALONG WITH KEEP TARGET
PQ81633	5_May 2004	UQ88132		MSGDSNT408I SQLCODE = -538, ERROR: FOREIGN KEY .... DOES NOT CONFORM TO THE DESCRIPTION OF A PARENT KEY OF TABLE
PQ81718	5_May 2004	UQ88132		MSGDSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL ... WHEN THE OBJECT COMPARE APPLY JOB RUNS
PQ81889	5_May 2004	UQ88132		OBJECT COMPARE GOC2CMP GETS ABEND S0C4 RC 04 DURING COMPARE WHENTARGET DATABASE FOR GRANTS DOES NOT EXIST
PQ85638	5_May 2004	UQ88132		MSGDSNT408I AND SQLCODE204 -204 WHEN VIEWS ARE CREATED OUT OF ORDER DURING DROP / CREATE SCENARIO
PQ86171	5_May 2004	UQ88132		OBJECT COMPARE WORK STATEMENT LIST GENERATES INCORRECT START ANDSTOP DATABASE COMMANDS
PQ85515	2_May 2004	UQ88132		OBJECT COMPARE WORKLIST CAN UNDER CERTAIN CONDITIONS LEAVE OUT ENFORCE NO ON A LOAD
PQ88104	28_Apr 2004	UQ87775		EXPLICIT SYSIBM AND SYSPROC SHOULD NOT APPEAR IN THE SOURCE RECORDS
PQ80689	26_Apr 2004	UQ87775		STEP S01DDL END WITH RC16 ENDS UNSUCCESSFUL PARSE OF DDL STATEMENT. COMPARE FUNCTION IS TERMINATED. TOKEN NUMBER = 0007
PQ86465	26_Apr 2004	UQ87775		UNKNOWN OBJECT TYPE SPNAME NOT FOUND ON TARGET GOCC024E - UNEXPECTED CATALOG ROW ON SOURCE FILE.
PQ86154	21_Apr 2004	UQ87630		UNLOAD DATASET SIZE INCORRECT AND INCONSISTENT ( REFERENCE PQ83209 )
PQ78322	7_Apr 2004	UQ87225		OBJECT COMPARE DOES NOT PRESERVE SET CURRENT PATH STATEMENT
PQ80530	7_Apr 2004	UQ87225		T20DROP JOB ENDS WITH RC08 AND MSGDSNT408I SQLCODE = -672, ERROROPERATION DROP NOT ALLOWED ON TABLE XX.XX
PQ84430	5_Apr 2004	UQ87225		OBJECT COMPARE GOCGAJOB COMMAND ERROR RC=40 GOCGAJOB LINE 851 ZERRLM = ERROR EXECUTING EXEC - NOW TERMINATING
PQ86010	5_Apr 2004	UQ87225		ABENDU4038 RECEIVED WHEN USING SMALL DDL SOURCE AND VERY LARGE DDDL AS TARGET ALONG WITH OPTION KEEPTGT
PQ86020	5_Apr 2004	UQ87225		CONVERT STEP FAILS CC1012 MSGADBC200E INTERNAL ERROR. MAX PRIM KEY SEQ ^= #KEY COLS
PQ76424	5_Apr 2004	UQ87225		OBJECT COMAPRE DOES NOT DO REBINDS WHEN MULTIPLE PACKAGES EXIST BY VERSION FOR AN OBJECT
PQ85513	5_Apr 2004	UQ87225		OBJECT COMPARE PROGRAM GOC2CMP RETURNS CC12 WITH MESSAGE THAT THERE ARE TOO MANY CATROWS FOR OBJECT MSGGOCC022E
PQ75642	1_Apr 2004	UQ87225		COMPARE JOB FAILS CONVERTING DATA TO NEW FORMAT DUE TO SPACE ALLOCATED ABENDB37
PQ83955	18_Feb 2004	UQ85269		CREATE TABLE STATEMENT IS MISSING IN WSL WHEN COMPARE DDL AT THETABLESPACE LEVEL WITH EMPTY DATABASE FROM THE CATALOG
PQ81187	26_Jan 2004	UQ84468		DURING A COMPARE WITH OBJECTS CONTAINING FOREIGN KEYS WHEN ALL OBJECTS ARE NOT WITHIN SOURCE, TARGET OBJECTS MAY BE LOST.
PQ79629	27_Dec 2003	UQ84019		QUALIFIER MIS-COMPARED ON TRIGGER WHEN SOURCE DDL CONTAINED QUALIFIER BUT TARGET DDL FROM CATALOG DIDN'T SHOW QUALIFIER
PQ81872	27_Dec 2003	UQ84007		DB2 OBJECT COMPARE GENERATES DUPLICATE PARMS WHEN "EXTRACT DB2 CATALOG OBJECTS FOR SOURCE / TARGET"
PQ80164	17_Dec 2003	UQ84007		SKELETON GOCTUNL CAN PRODUCE AN UNLOAD UTILITY STATEMENT WHICH GOES BEYOND COLUMN 72 FOR OBJECT COMPARE
PQ80232	15_Dec 2003	UQ83145		SQLCODE -672 FOR A WSL COMPARE JOB THAT HAS PK/PI CHANGED FOR THE PARTITIONED TS TABLE DEFINED WITH "RESTRICT ON DROP"
PQ81283	15_Dec 2003	UQ83145		SEMICOLON IS MISSING AT THE END OF DDL.CREATE WHEN OBJECT COMPARE GENERATES APPLY JOB
PQ78447	3_Dec 2003	UQ82754	HIPER	SUPPORT FOR PRIMARY KEY AND FOREIGN KEY FIELDS REQUIRED BY DB2 ADMIN TOOL PQ76947 IS NEEDED IN DB2 OBJECT COMPARISON TOOL
PQ78913	30_Nov 2003	UQ82654		OBJECT COMPARE GIVES UNPREDICTABLE RESULTS DURING DB2 TRIGGER PROCESSISNG
PQ80632	30_Nov 2003	UQ82654		ABEND322 IN THE T03COMP STEP WHEN TRIGGERS ARE DEPENDENT ON UNUSUALLY LARGE LIST OF OBJECTS .
PQ78803	10_Nov 2003	UQ81994		AFTER OBJECT COMPARE A DROPPED COLUMN PERSISTS IN THE DB2 LOAD STATEMENT
PQ79633	30_Oct 2003	UQ81692		RESET OF CHECKPENDING AFTER OBJECT COMPARE GENERATED LOAD TABLES RESULTS IN REPORTED MISSING COLUMNS WITH RI
PQ78446	27_Oct 2003	UQ81475		NEW FUNCTION: ABILITY TO NOT GENERATE SET SQLID STATEMENTS
PQ79701	27_Oct 2003	UQ81475		OBJECT COMPARE T03COMP GIVES ERRORS WITH FIELDPROC IN TABLE GOCC026E AND GOCC002E
PQ78224	12_Oct 2003	UQ81033		COMPARE FAILS TO USE BP OR INDEXBP PARMS FROM CREATE DATABASE STATEMENT IN DDL SOURCE FILE
PQ78377	26_Sep 2003	UQ80588		OBJECT COMPARE SMART ALTER DOES A DROP ON OBJECTS OTHER TIMES MAY SKIP ADDING COLUMN
PQ78380	26_Sep 2003	UQ80588		OBJECT COMPARE SHOULD USE ENFORCE NO ON LOAD JOBS FOR OBJECTS USING REFFERENTIAL INTEGRITY
PQ75784	5_Sep 2003	UQ79924		NEW FUNCTION - HPU (NEED DB2 ADMIN TOOL V420 PQ75486 AS A PRE)
PQ77765	5_Sep 2003	UQ79924		COMPARE JOB FAILS UNLOADING DUE TO SPACE ALLOCATED FOR SYSREC ABEND837 USING WORK STATEMENT LIST
PQ76128	15_Aug 2003	UQ79459		OBJECT COMPARE INCORRECTLY PARSES VIEW WITH ARITHMETIC WHERE CLAUSE
PQ76662	15_Aug 2003	UQ79459		A LONG QUOTED STRING CONTAINING HYPENS IN COLUMNS 1 AND 2 IN DDLFOR VALUE CLAUSE IN CREATE INDEX CAUSES CC16 IN GOC2DTC
PQ76654	15_Aug 2003	UQ79459		ABEND4038 RUNNING T03COMP
PQ76948	15_Aug 2003	UQ79459	HIPER	DDL STACK FULL - GENERATED DDL INCOMPLETE
PQ75892	8_Aug 2003	UQ79311		OBJECT COMPARE MASKING NOT WORKING WHEN SOURCE HAS MULTIPLE OCCURRENCES OF CHARACTER TO BE MASKED
PQ76286	2_Aug 2003	UQ79130		IBM INTERNALLY-FOUND PROBLEM. SEE PROBLEM DESCRIPTION.
PQ75458	11_Jul 2003	UQ78490		MISSING OPTIONAL DB2 UTILITY JOBS (RUNSTATS, CHECK DATA, REORG, COPY, REBIND) WHILE COMPARING USING FILE DDL.
PQ66739	18_Jun 2003	UQ77785		SQLCODE204 WHEN RUN OC JOB OR WORKLIST. INVALID DROP VIEW WAS GENERATED RIGHT AFTER DROP TABLE.
PQ67109	18_Jun 2003	UQ77785		SQLCODE669 RUNNING WSL OF OC WHEN COMPARE TWO PARTITIONED TABLES
PQ67400	18_Jun 2003	UQ77785		SQLCODE104 RETURNED BY COMPARE JOB (OR STEP) T04GAPY WHEN IDENTITY COLUMN IS BEING ADDED TO A TABLE.
PQ73292	18_Jun 2003	UQ77785		SUPPRESS DROP OF COLUMNS IN OBJECT COMPARE DOES NOT KEEP THE ADDITIONAL COLUMNS ON TARGET TABLE
PQ73907	18_Jun 2003	UQ77785		DIFFERENCE FOUND IN COMPARE OF ALIAS OBJECT WHEN NO DIFFERENCE EXISTS
PQ73908	18_Jun 2003	UQ77785		SQLCODE669 RECEIVED ATTEMPTING TO DROP PRIMARY KEY INDEX
PQ74348	18_Jun 2003	UQ77785		INCORRECT DEFAULT FOR MINVALUE USED WHEN START WITH IS SPECIFIED AND THE INCREMENT IS ASCENDING
PQ72301	16_May 2003	UQ76955		SIGNAL ERROR CONDITION IN GOCGAJOB WAS RECEIVED CAUSED BY RECORD IN CHANGES DATASET.
PQ73813	16_May 2003	UQ76955		WILD CARD ( % ) NOT USED ON PANEL GOC1TA IF TABLE NAME ENTERED IS 8 CHAR OR MORE TRUNCATES WITH MSG NO ROWS RETURNED
PQ72280	20_Apr 2003	UQ76125		WRONG UNIT PARAMETER GENERATED IN JCL FOR UNLOAD DATASET BY OBJECT COMPARE
PQ72411	20_Apr 2003	UQ76125		APPLY JOBS NOT PICKING UP JOBCLASS FROM SUBSYSTEM DEFAULT WHEN JOB CLASS ON BP PANEL IS BLANK
PQ72681	17_Apr 2003	UQ76081		NEW FUNCTIONS TO BE DESCRIBED IN PROBLEM DESCRIPTION
PQ72841	17_Apr 2003	UQ76106	HIPER	SQLCODE104 RETURNED WHEN INITIATING A SEARCH FOR TABLE TO USE IN COMPARE, PERIOD CHARACTER PRECEEDS TABLE NAME
PQ71339	25_Mar 2003	UQ75395		FAILURE IN GOC2CMP AT EXTRACT_UNIQUE +A04F6 ONCODE520 SUBSCRIPTRANGE CONDITION RAISED. ABENDU4038 RC01
PQ71471	25_Mar 2003	UQ75395		COMPARE STEP T03COMP RECEIVES CC12 AND MSGGOCC002E SEVERE ERROR,UNABLE TO DROP PARTITIONING INDEX
PQ71113	15_Mar 2003	UQ75082		GOC2DTC- UNSUCCESSFUL COMPLETION WHILE PROCESSING 270K LINES OF DDL DURING VERSION FILE CREATION.
PQ71523	15_Mar 2003	UQ75079		INCORRECT LOAD STATEMENT GENERATED WHEN ADDING A ROWID COLUMN TO A TABLE - MSGDSNU269I FROM JOB T70R0001
PQ69371	6_Mar 2003	UQ74768		UNLOAD JOB CREATED DURING COMPARE PROCESSING IN SOME CASES GENERATES A UID GREATER THAN 16 BYTES.
PQ69911	6_Mar 2003	UQ74768		SOME COMPARE SKELETON LIBRARY MEMBERS HAVE INCORRECT DATASET NAME FOR DB2 ADMIN AND COMPARE LOAD LIBRARIES
PQ69954	6_Mar 2003	UQ74768		44 CHARACTER DATASET NAMES EXTEND INTO COLUMN 72 IN SOME SKELETON LIBRARY MEMBERS
PQ68027	3_Mar 2003	UQ74668		DB2 OBJECT COMPARISON V210 IBM INTERNALLY FOUND PROBLEMS
PQ68650	31_Jan 2003	UQ73718		OBJECT COMPARE DOES NOT SEE THE DIFFERENCE BETWEEN IDENTITY WITH CYCLE AND NO CYCLE
PQ69461	31_Jan 2003	UQ73718		GOC2DTC FAILS WITH TOKEN_INDEX = 15 . INVALID TOKEN AFTER PUBLICAT OR AFTER PUBLIAT .
PQ69462	31_Jan 2003	UQ73718		INVALID TOKEN AFTER COMMENT ON OBJECT CLAUSE - EXPECTED IS KEYWORD, FOR AN ALIAS DURING COMPARE PROCESSING .
PQ69709	31_Jan 2003	UQ73718		WHEN COMPARING IDENTICAL ROWID COLUMNS, A DIFFERENCE IS REPORTEDGENERATED ALWAYS IS OMITTED.
PQ69711	31_Jan 2003	UQ73718		WHEN ENLARGING A COLUMN FORCING A BUFFERPOOL CHANGE DURING COMPARE, THE ALTER TABLESPACE RECEIVED SQLCODE671
PQ69531	30_Jan 2003	UQ73676		OBJECT COMPARE RETURNS CC0 EVEN THOUGH ERROR MESSAGE GOCD180E IS RECEIVED AND AN EMPTY VERSION FILE IS CREATED.
PQ68923	29_Jan 2003	UQ73718		APPLY JOBS NOT PICKING UP JOBCLASS FROM BP COMMAND, BUT INSTEAD USE JOBCLASS DEFAULT SETUP FROM ADB2CUST EXEC.
PQ69725	29_Jan 2003	UQ73718		MSGDSNT302I ON START COMMAND TRYING TO START A TABLESPACE THAT WAS JUST DROPPED.
PQ65316	13_Jan 2003	UQ73161		WHEN KEEPTGT OPTION USED, DEPENDENT OBJECTS NOT RECREATED WHEN THE TABLES DROPPED.
PQ68358	4_Dec 2002	UQ72323		COMPARING DDL AGAINST CATALOG WITH A LONG VARCHAR DATA TYPE RESULTS IN MIS-COMPARE WHEN BOTH ARE THE SAME.
PQ67069	25_Nov 2002	UQ72105		LOOP IN GOC2DTC GENERATING A VERSION FILE FROM DDL WITH PARTITIONED TABLESPACES.
PQ67144	25_Nov 2002	UQ72107		IBM INTERNALLY FOUND PROBLEMS
PQ66836	19_Nov 2002	UQ71885		DUPLICATE DATA SET NAMES IN THE WORK STATEMENT LIST GENERATED BYOBJECT COMPARE.
PQ66978	16_Oct 2002	UQ70911		SQLCODE625 RUNNING T04GAPY AFTER PRIMARY KEY WAS CHANGED IN OBJECT COMPARE.
PQ66973	12_Oct 2002	UQ70781		COMPARE GENERATES ADMIN ALTER CONVERT CREATOR.NAME IN ERROR.
PQ66645	3_Oct 2002	UQ70455		IBM-FOUND PROBLEMS
PQ65436	4_Sep 2002	UQ69566		TABLE UNLOAD/RELOAD MISSING WHEN PARTITIONED INDEX CHANGED REFERENCE PQ62868
PQ63832	20_Aug 2002	UQ69184		WHEN USING A VARIABLE BLOCKED PDS FOR BATCH JOBS NO ERROR FLAGGED WHEN GENERATE APPLY JOBS SET TO YES
PQ63099	23_Jul 2002	UQ68367	HIPER	DB2 OBJECT COMPARISON TOOL ROLLUPS

Top of page