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
DB2 Object Comparison Tool Version 3.1
APAR CLOSE
DATE		 PTF(s) Fixing APAR
if PE		 HIPER? Abstract
PK33735
26_Nov
2006
UK20016


OBJECT COMPARE IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED ABEND U4038
PK25809
18_Jul
2006
UK16375


CHECK CONSTRAINTS DELETED AND REDEFINED EVEN WHEN IDENTICAL AND SYNTAX SQL CODE IS INCORRECT ALSO
PK20882
10_Jul
2006
UK16375


GOC COMPARE AGAINST DDL WITHOUT PRIQTY/SECQTY GETS MESSAGE 'TARGET PRIQTY=NNN IS KEPT' HOWEVER DDL HAS NO PRIQTY/SECQTY
PK26898
10_Jul
2006
UK16375


COMPARE CREATES BAD SYNTAX WHEN CHECK CONSTRAINT ADDED THEN CAUSING SQLCODE -546 SQLCODEN546 SQLERRD -901
PK23386
11_May
2006
UK14392


OBJECT COMPARE DOES NOT USE ALTER TO CHANGE THE VOLATILE PARAMETER ON A TABLE
PK18764
22_Apr
2006
UK13805


OBJECT COMPARE INCORRECTLY UPDATES TABLE AND INDEX PARTITION INFORMATION
PK11635
22_Apr
2006
UK13805


OBJECT COMPARE INCORRECTLY CHANGES PARTITIONED INDEX INTO A SIMPLE INDEX
PK18124
22_Apr
2006
UK13805


SQLCODEN205 FOR CREATE INDEX WHEN COLUMNS TO BE ADDED VIA ALTER AND COMPARE AT DATABASE LEVEL
PK20375
30_Mar
2006
UK13141


GOC WSL CONTAINS GRANT STATEMENT FOR TABLE WHICH DOES NOT EXIST
PK20188
30_Mar
2006
UK13141


GOC JOB FAILS WITH IBM0855S ONCODE=3809 THE LENGTH OF A DATA AGGREGATE EXCEEDED THE MAXIMUM LIMIT WHEN MASK AND IGNORE
USED
PK19050
8_Mar
2006
UK12422


GOC ALTER FAILS SQLCODEN190 WHEN DEC(10,0) COLUMN CHANGED TO DEC(11,4)
PK19746
8_Mar
2006
UK12422


OBJECT COMPARE ADDS A REDUNDANT PRIMARY KEY CONSTRAINT
PK14499
22_Feb
2006
UK12028


OBJECT COMPARE DOES NOT GENERATE RUNSTATS FOR ALL INDEXES
PK19285
22_Feb
2006
UK12028


DB2 OBJECT COMPARISON TOOL DOES NOT GENERATE RUNSTATS FOR ALL INDEXES (ALSO, REFERENCE PK14499)
PK19660
22_Feb
2006
UK12028


GOC DOES NOT APPLY MASK TO INDEX NAMES FOR RUNSTATS UTILITY JOB
PK19023
19_Feb
2006
UK12028


GOC 0C4 GOC2CMR ENTRY: NOTIFY_REBIND_PKGS
PK10746
15_Feb
2006
UK12028


OBJECT COMPARE GENERATES INCORRECT DDL FOR SP. OUT PARM CHANGED TO IN PARM ON GENERATED DDL.
PK12122
11_Dec
2005
UK09986


COMPARE COMPLETES RC0 BUT JOBLOG SHOWS ERROR IN GOCGAJOB EXEC, SHOWING MSGISRZ002 NOVALUE CONDITION RAISED
PQ98842
21_Sep
2005
UK07472


OBJECT COMPARE IGNORE FILE PARAMETERS ARE NOT BEING USED
PK07144
21_Sep
2005
UK07472


TABLE CONTROLLED PARTITIONING ALTER OF LIMITKEY CAUSES DROP CREATE INSTEAD OF ALTER - OR SQLCODE669 ON DROP TABLE
PK08841
21_Sep
2005
UK07472


COMPARE FAILS IN GOC2DTC - INVALID TOKEN AFTER LEFT PAREN - EXPECTED PART KEYWORD
PK09487
21_Sep
2005
UK07472


VARIOUS PROBLEMS HANDLING KEYWORDS FOR TABLE BASED PARTITIONING
PK10142
28_Aug
2005
UK07472


MSGIKJ58418I FOR MULTI-VOLUME VERSION FILES
PK07297
28_Jul
2005
UK05807


RC16 INVALID TOKEN AFTER PRIQTY WHEN -1 VALUE USED IN DB2 V8
PK03532
14_Jul
2005
UK05389


OBJECT COMPARE DOES NOT GENERATE A REORG STEP FOR ALL RELEVANT WHEN TABLESPACE PLACED IN ADVISORY REORG STATUS (AREO)
PK03621
14_Jul
2005
UK05389


OBJECT COMPARE GENERATES SET CURRENT PATH STATEMENTS IN IMPROPER PLACES
PK05277
14_Jul
2005
UK05389


OBJECT COMPARE DOES NOT PRODUCE RUNSTATS STEP IN APPLY JOB
PK05668
14_Jul
2005
UK05389


OBJECT COMPARE DOES NOT CREATE CORRECT REORG OR RUNSTATS
PK07229
14_Jul
2005
UK05389


SQLCODE104 FROM SMART ALTER INDEX REMOVING CLUSTER
PK08206
14_Jul
2005
UK05389


ONCODE520 SUBSCRIPTION RANGE, OUT OF STORAGE CONDITION, UNPREDICTABLE RESULTS, ABEND0C4 LE RUNNING BTL
PK03210
29_Jun
2005
UK05021


VIEW DEFINED JOINING TWO TABLES IS MISSING AFTER COMPARE
PK03862
29_Jun
2005
UK05021


OBJECT COMPARES DROPS OBJECTS WHEN KEEPTGT SPECIFIED AND ALSO REPORTS OBJECTS WILL BE KEPT
PQ97040
29_Jun
2005
UK05021


DATA TYPE MISMATCH OCCURS FOR A COLUMN WITH A USER DEFINED DATA TYPE OF DISTINCT TYPE
PQ98895
29_Jun
2005
UK05021


OBJECT COMPARE DOES NOT GENERATE A CHECK DATA JOB WHEN REQUESTED
PK01021
29_Jun
2005
UK05021


COMMENT AND LABEL ON A VIEW OF THE COMPARE SOURCE ARE NOT APPLIED TO THE TARGET VIEW
PK02341
29_Jun
2005
UK05021


WSL EDIT AND WSL SHOW EDIT DISPLAY DIFFERENT VALUES INSIDE QUOTED STRING FOR WSL BUILT BY COMPARE
PK03154
29_Jun
2005
UK05021


OBJECT COMPARE ENCOUNTERS ERRORS WITH MATERIALIZED QUERY TABLES
PK03080
27_Apr
2005
UK02921


DURING COMPARE OF A DATABASE THE RESULTING APPLY REORG STATEMENT OMITTED DATABASE NAME AND TABLESPACE NAME
PK03521
27_Apr
2005
UK02921


OBJECT COMPARE GIVES INCORRECT MESSAGE WHEN CHANGING A A PARTITIONING INDEX
PK01927
18_Apr
2005
UK02535


OBJECT COMPARE LOOP IN GOC2CMP MODULE
PQ99462
18_Apr
2005
UK02535


SQLCODE104 RETURNED FOR ALTER SET COLUMN STATEMENT WHEN DECIMAL POINT IS COMMA IN DSNZPARM
PK00102
18_Apr
2005
UK02535


AFTER ALTER TABLE TO ADD COLUMN TO THE END, VIEW DEFINED AS ' SELECT * ' IS NOT REFRESHED
PK01152
18_Apr
2005
UK02535


OBJECT COMPARE RUNSTATS ISSUES
PK01590
18_Apr
2005
UK02535


OBJECT COMPARE CREATES UTILITY STEPS OUT OF SEQUENCE IN THE APPLY JOB
PK01653
18_Apr
2005
UK02535


OBJECT COMPARE CAN OMIT AND ALSO RUN SOME UTILITIES OUT OF IDEALSEQUENCE WHEN CHANGING AN OBJECT
PK02855
18_Apr
2005
UK02535


ABEND0C4 OR ONCODE520 IN ROUTINE NOTIFY_REBIND_PKGS
PK01160
24_Mar
2005
UK01811


VARCHAR LENGTH CHANGE DID NOT GENERATE "SMART ALTER"
PK00618
8_Mar
2005
UK01257


OBJECT COMPARE ADB27AC GETS COMMAND ERROR AND HAS UTILITIES OUT OF SEQUENCE IN A WORK STATEMENT LIST
PK01161
8_Mar
2005
UK01257


OBJECT COMPARE PRODUCES INVALID RUNSTATS SYNTAX WHEN USING A WORK STATEMENT LIST
PQ98370
24_Feb
2005
UK00868


OBJECT COMPARE GET ABEND S837 AND ABEND S0C4 DURING TEMPLATE USAGE
PQ93034
19_Feb
2005
UK00735


OBJECT COMPARE DOES NOT PRESERVE ALL PARTS OF SOURCE STORED PROCEDURE
PQ98613
19_Feb
2005
UK00735


OBJECT COMPARE DOES NOT GENERATE A DROP FOR VIEWS WHEN CHANGING PATH SCHEMAS
PQ98601
10_Feb
2005
UK00461


GOC2DTC GETS IBM0342S ONCODE=340 THE SIZE CONDITION WAS RAISED RC=16 ABEND=S0C8 ON INVALID PARSING ERROR
PQ99798
10_Feb
2005
UK00461


OBJECT COMPARE FOR MULTIPLE OBJECTS DOES NOT PRESERVE THE DIALOGDB2 SUBSYSTEM
PK00111
10_Feb
2005
UK00461


CHANGES IN THE INTERFACE TO THE SPACE CALCULATION ROUTINE IN ADMIN (PQ97975) CAUSE THE APPLY JOB IN OBJECT COMPARE TO FAIL
PQ98720
31_Jan
2005
UK00146


OBJECT COMPARE SETS CURRENT TERMINATOR INCORRECTLY IN A WORK STATEMENT LIST
PQ99803
31_Jan
2005
UK00146


OBJECT COMPARE PANEL GOCMCRL GIVES ERROR IS OPTIONAL DATA SET SUFFIX FIELD VALUE IS NOT PROVIDED
PQ97638
27_Dec
2004
UK00066


OBJECT COMPARE DOES NOT INTERPRET DSSIZE CORRECTLY
PQ97644
27_Dec
2004
UK00066


COMPARE JOB FAILS WITH JCL ERROR WHEN USING SAME NEW PDS DATASET FOR SOURCE VERSION FILE AND TARGET VERSION FILE
PQ96926
14_Dec
2004
UQ96054


DB2 OBJECT COMPARISON TOOL RELEASE 310 NEW FUNCTION APAR
PQ98221
14_Dec
2004
UQ96054


A FOLLOW-UP APAR TO THE NEW FUNCTION APAR PQ96926
PQ94158
3_Dec
2004
UQ95801


OBJECT COMPARE IS MISSING JOBPARM STATEMENT IN THE APPLY JOB(S) JCL
PQ96152
9_Nov
2004
UQ94880


GOCGAJOB EXEC MAY FAIL WITH MSGISPS105 AND NOVALUE CONDITION RAISED WHILE RUNNING COMPARE JOB STEP T04GAPY
PQ94908
4_Nov
2004
UQ94719


CLUSTER INDEX CHANGES NOTED DURING OBJECT COMPARISON, BUT NO REORG GENERATED WHEN USING OPTION "ALL RELEVENT"
PQ95533
4_Nov
2004
UQ94719


COLUMN DROPPED FROM TABLE WHEN SUPPRESS DROP OF COLUMN WAS SET TO YES
PQ95566
4_Nov
2004
UQ94719


TWO REFERENTIAL CONSTRAINTS ARE ATTEMPTED TO BE ADDED WITH THE SAME NAME
PQ93847
28_Oct
2004
UQ94489


OBJECT COMPARE DOES NOT ALWAYS PRESERVE THE PATH STATEMENT
PQ94907
13_Oct
2004
UQ93993


TSO PREFIX COULD CAUSE RC16 RC=16 IN REXX EXEC GOCGAJOB DURING LISTDSI DATASET RECALL COMMAND
PQ93402
6_Oct
2004
UQ93711


IBM INTERNALLY FOUND PROBLEM: OBJECT COMPARE WITH ENFORCE NO (LOAD JOB IN HPU UNLOAD).
PQ93864
6_Oct
2004
UQ93711


DEFAULT PRIQTY AND SECQTY INCORRECTLY ASSUMED BY COMPARE IF PRIQTY AND SECQTY KEYWORDS ARE OMITTED FROM DDL OF SOURCE.
PQ91166
30_Aug
2004
UQ92385


INCONSISTENT CHANGE RESULTS FROM OBJECT COMPARE
PQ89788
26_Aug
2004
UQ92286


AUG NF
PQ88662
16_Aug
2004
UQ91884


OBJECT COMPARE GOCGAJOB SIGNAL ERROR AND UNKNOWN CHANGES RECORD GIVES INCORRECT REORG STATEMENT
PQ90398
16_Aug
2004
UQ91884


SQLCODE672 SEEN WHEN PROCESSING FROM WSL WITH OBJECTS CONTAININGRESTRICT ON DROP
PQ90733
16_Aug
2004
UQ91884


OBJECT COMPARE INCORRECTLY DETECTS A DIFFERENCE IN A CONSTRAINT
PQ84056
16_Aug
2004
UQ91884


JOB OUTPUT SHOWS SOURCE AND TARGET EXTRACTED FROM THE SAME DB2 SUBSYSTEM WHEN SOURCE CAME FROM A DIFFERENT LOCATION
PQ88258
16_Aug
2004
UQ91884


GOCGAJOB EXEC FAILURE AT LINE 1581: SIGNAL ERROR, WHEN COMPARINGDDL TO DDL ALONG WITH UTILITY JOBS BEING GENERATED
PQ91926
5_Aug
2004
UQ91420


OBJECT COMPARE INCLUDES INVALID TEMPLATE STATEMENT
PQ89417
19_Jul
2004
UQ90781


OBJECT COMPARE PROBLEMS WITH GRANTS ON COLLECTIONS, UDTS, PACKAGES, PLANS
PQ90214
9_Jul
2004
UQ90516


AN I-TYPE APAR THAT FOLLOWS UP THE ROLLUP APAR
PQ89015
1_Jul
2004
UQ90286


COUNTER PART OF PQ88531 IN DB2 OBJECT COMPARISON TOOL
PQ89688
16_Jun
2004
UQ89662

HIPER

 PQ89688 IS THE ROLLUP APAR FOR DB2 OBJECT COMPARISON TOOL RELEASE 310 (FMID H25G310).

Top of page