DB2 Object Comparison Tool Version 7.1
|
|||||
APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
---|---|---|---|---|---|
2008 |
OC V71 VERSION FILES WHEN USED IN V72 COMPARE RESULTS IN DFSORT FAILURE | ||||
2008 |
ABEND80A/ABEND878 IRX0662E EXECIO ERRORIRX0043I ERROR RUNNING GOCGCMP IEC143I 213-C8,IFG0194D | ||||
2008 |
ABEND80A / ABEND878 IRX0662E EXECIO ERROR IRX0043I ERROR RUNNINGGOCGCMP IEC143I 213-C8 ,IFG0194D | ||||
2008 |
GOC2DTC PROBLEM: SPACE ISSUE FAILS OC JOBS. | ||||
2008 |
GOC2DTC UNSUCCESSFUL COMPLETION GOCC026E ONCODE 1040 DURING WRITE CATREC IEC030I B37 RC04 CATSIN ONCODE1040 OUT OF SPACE | ||||
2008 |
RECEIVING ONCODE350 STRINGRANGE CONDITION RAISED IN GOC2CMR AT ENTRY POINT ADD_OBJECT AT STATEMENT 2080 | ||||
2008 |
MSG REMOTE SYSTEM'S SSID NOT FOUND | ||||
2008 |
OC LOAD STEP FAILS MSGDSNU1036I DSNURELD - UNABLE TO ESTIMATE SPACE REQUIREMENTS FOR WORKDDN | ||||
2008 |
IGNORE SYSINDEXPART OPTIONS CHANGED | ||||
2008 |
GOC ALTER OF PRIMARY KEY IS MISSING SEMI COLON SO WHEN APPLY OF JCL OR RUN WSL GET SQLCODEN199 SQLCODE199N SQLCODE199 | ||||
2008 |
GOC SAP U4038 SUBSCRIPTRANGE CONDITION IN DROP_OBJECT.2906 WHEN COMPARING VERY LARGE QUANITIES OF OBJECTS | ||||
2008 |
OBJECT COMPARE SHOWS UNNECESSARY CHG ON LIMIT KEY ' ' OR ',' W DECP USED | ||||
2008 |
OC4 ON T03COMP STEP WHEN COMPARING TABLESPACES | ||||
2008 |
CM ALTER TABLE ALTER PARTITION N ENDING ENDS RC=08 SQLCODEN663 | ||||
2008 |
GOC WITH SOURCE BEING ONE TABLE COMPARING TO TABLE IN CATALOG WITH INDEX AND PACKAGES CAUSES DROP OF IX BUT NO REBIND OF PKG |
||||
2008 |
MASK NOT APPLIED TO RUNSTATS INDEX | ||||
2008 |
OC NEW FUNCTION - RETAIN THE CONSTRAINT NAME WHEN CHANGING OBJECT | ||||
2008 |
ALC SQLCODE = -607 ALTER INDEX ADD COLUMN WHEN FOREIGN KEYS EXISTS AS NO DROP FOREIGN KEY ISSUED | ||||
2008 |
UNLOAD CONVERT STEP FAILS WITH MSGIKJ56893I MSGIGD17401I MSGIGD306I | ||||
2008 |
OC LOAD STEP FAILS ON UTLDISC TEMPLATE WITH MESSAGE: INVALID KEYWORD SPACE FOR TAPE TEMPLATE | ||||
2007 |
JCL EXTENDS TO COLUMN 73 WHEN USED IN COMBINATION WITH OTHER OBJECT COMPARE PARAMETERS | ||||
2007 |
++HOLD FOR UK26615 UK26556 UK26557 INVALID , SADB AND ADB SHOULD BE SGOC AND GOC RESPECTIVELY IN ACTION INSTRUCTIONS |
||||
2007 |
LACK OF THE GENERATION OF THE REBUILD INDEX JOB FOR OBJECT COMPARE | ||||
2007 |
INVALID LIMITKEY DEFINITION GENERATED WHEN COMPARE OPTIONS IGNORE LIMITKEY AND TABLE CHANGES PRESENT. | ||||
2007 |
ALC LOAD STATEMENTS CONTAIN OLD COLUMN NAMES WHICH CAUSE A DSNU053I DSNURWUF - FIELD AAAA NOT FOUND RC=08 ERROR | ||||
2007 |
GOC DOES NOT GENERATE A REORG FOR A MAXROW WHEN "ALL RELEVANT" SPECIFIED THEREFORE ONLY NEW ROWS EFFECTED BY CHANGES | ||||
2007 |
"SMART" ALTER NOT PERFORMED WHEN OPTION, "SUPPRESS DROP OF COLUMNS" SELECTED. | ||||
2007 |
OBJECT COMPARISON NOT GENERATING REBIND DURING COMPARE PROCESSING WHEN A NEW INDEX IS DETECTED. | ||||
2007 |
GOC DOES NOT CREATE CORRECT DDL WHEN TABLE BASED PARTITIONING OBJECT ADDED. | ||||
2007 |
GOC DROPS RECREATES TABLESPACE THAT HAD NUMPARTS CHANGED WHEN IT SHOULD HAVE DONE A SMART ALTER | ||||
2007 |
INTERNAL APAR FOR DEFECT 6062 | ||||
2007 |
ABEND0CA IN ROUTINE ADB2REG GEN_PARTSPEC IN LOADMOD GOC2CMP | ||||
2007 |
GOC MASK NOT APPLIED TO MQT/MATERIALIZED QUERY TABLE DEFINITION | ||||
2007 |
LI119C - DB2 V8 MINVALUE / MAXVALUE SUPPORT IN LIMIT KEY - DTC | ||||
2007 |
MASK NOT APPLIED TO MQT DURING WSL CREATION. | ||||
2007 |
REPORT OF CHANGE IN DEFAULT VALUE REVERSES FROM AND TO VALUES | ||||
2007 |
GOC1CA - INCOMPLETE SCHEMA NAMES DISPLAYED | ||||
2007 |
APAR PK32112 IGNORE OF LIMITKEYS DOC CHANGES HOW IGNORE HANDLES SYSINDEXPART SYSTABLEPART LIMITKEY INTERNAL EXTERNAL | ||||
2007 |
COMPARE NOT RECOGNIZED RENAMED DB IN TS, CAUSE INCORRECT GRANTS | ||||
2007 |
GOC SCHEMA MASK NOT APPLIED TO PATH STATEMENT | ||||
2007 |
IBM INTERNAL APAR, OC WITH PARALLEL UNLOAD - INCREASE PART# RESULT IN MISSING DATA | ||||
2007 |
MQT NOT CREATED CREATE RUN JCL FAILED WITH -601: CREATE VIEW ALREADY EXISTED | ||||
2007 |
GOC FOR COLUMN CHANGE TO ROWID NOT NULL GENERATED ALWAYS GENERATES INCORRECT DDL OF ROWID NOT NULL GENERATED BY DEFAULT |
||||
2007 |
GOC MESSAGE GOCC025E - DUPLICATE RECORD WAS DETECTED FOR OBJECT RC=12 | ||||
2007 |
GOC APAR THAT GOES WITH ADB APAR PK40333 | ||||
2007 |
DURING COMPARE PROCESS A SET CURRENT SQLID IS MISSING FOR GRANTS | ||||
2007 |
CM ALTER ADD COLUMN CREATED REORG IN ERROR WHEN 'RUN REORG' MANDATORY SPECIFIED ON PANEL ADB2C11A | ||||
2007 |
DB2 OBJECT COMPARE GOC2CMP ABENDS U4038 ON GTT GLOBAL TEMPORAY TABLE T03COMP ABENDU4038 REASON 00000001 | ||||
2007 |
GOC PANEL ADB2 OPTION C 'DB2 OBJECT COMPARISON TOOL' HANG OR WAIT OR MSG ISPT034-TABLE IS NOT OPEN | ||||
2007 |
OBJECT COMPARE CREATES WSL FOR PARTITION COLUMN WITH DATE AND IS MISSING THE QUOTES AROUND DATE VALUE | ||||
2007 |
OC COMPARE PROGRAM OBJECTS BEING ALTERED/DROPPED: SHOULD REPORT "NO CHANGE" | ||||
2007 |
GOC APAR THAT GOES WITH ADB PK29144 | ||||
2007 |
TABLE OWNER WITHIN GRANT STILL USING SOURCE OWNER FOR TABLE BEING GRANTED, INSTEAD OF TARGET OWNER | ||||
2007 |
IBM INTERNALAPAR, CM - ABEND 4038 IN GOC2CMF | ||||
2007 |
IBM INTERNAL CMPR OBJECTS BEING ALTERED/DROPPED: SHOULD REPORT "NO CHANGE" | ||||
2007 |
TABLE OWNER WITHIN GRANT STILL USING SOURCE OWNER FOR TABLE BEING GRANTED, INSTEAD OF TARGET OWNER | ||||
2007 |
RUN SQLID ON VIEWS REFERENCING SYNONYMS FOR OBJECT COMPARE CREATES 2 PART NAME INCORRECTLY | ||||
2007 |
DURING COMPARE PROCESS A CHANGE IS DETECTED WITHIN A TRIGGER WHERE TRIGGER HAS A THIRD QUALIFIER . | ||||
2007 |
GOC APPLY JCL COMMENTS REFERENCE THE WRONG TABLE NAME IN THE LOAD STEPS | ||||
2007 |
GOC WSL APPLY STEP HAD IKJ56225I DATA SET ALREADY IN USE, TRY LATER+ MESSAGE BUT STEP ENDED RC=00 | ||||
2007 |
GOC2DTC DOES NOT REPORTS THE LAST DDL BEING PROCESSED RATHER THAN THE ACTUAL ERROR IE ERROR OCCURRED PROCESSING DDL STATEMENT | ||||
2007 |
OBJECT COMPARE WHEN COMPARING BETWEEN TWO SUBSYSTEMS DOES NOT USE THE TARGET LIBRARIES | ||||
2007 |
GOC PANEL GOCCI 'SPECIFY IGNORE FIELDS' DOES NOT HAVE A PATHSCHEMAS FOR SYSPACKAGE TO ALLOW TRIGGER DIFFERENCES TO BE IGNORED | ||||
2007 |
GOC2DTC DOES NOT REPORTS THE LAST DDL BEING PROCESSED RATHER THAN THE ACTUAL ERROR IE ERROR OCCURRED PROCESSING DDL STATEMENT | ||||
2007 |
SQLCODE -538 REFERENTIAL INTEGRITY CONSTRAINT FOREIGN KEY IS ADDED TO CHILD TABLE BEFORE PRIMARY KEY IS ADDED TO PARENT TABLE |
||||
2007 |
GOC WITH DB2XML.XMLVARCHAR GIVES GOC2DTC UNSUCCESSFUL COMPLETION UNEXPECTED TOKEN IN TABLE DEFINITION TOKEN | ||||
2007 |
MISSING RUNSTATS WHEN OBJECT COMPARE COMPARES SPACES FOR MULTIPLE DATABASE THAT HAD SEGSIZE CHANGES | ||||
2007 |
OBJECT COMPARE DOES NOT PROCESS PRIQTY AND SECQTY WITH A VALID VALUE OF -1 CORRECTLY | ||||
2007 |
GOC USING PANELID ADB2US01 FOR REORG SHRLEVEL CHANGE FOR MAPPING TABLE DOES NOT PRODUCE WSL DDL WITH THE MAPPING TABLE | ||||
2007 |
IBM INTERNAL LI101 FOLLOW ON | ||||
2007 |
GOC WSL APPLY STEP HAD IKJ56225I DATA SET ALREADY IN USE, TRY LATER+ MESSAGE BUT STEP ENDED RC=00 | ||||
2007 |
OBJECT COMPARE NOT HANDLING CHECK UNIQUE CONSTRAINT CORRECTLY CAUSING DROP OR DELETE AND RECREATE UNIQUE KEY | ||||
2007 |
OBJECT COMPARE GENERATES INVALID LOAD UTILITY FOR A PARTITIONED COMPRESSED TABLESPACE | ||||
2007 |
GOC MISSING SET SQLID FOR CREATE SYNONYM DESPITE MSG SAYING NEW SYNONYM AAA FOR AUTHID AAA WILL BE ADDED | ||||
2007 |
OBJECT COMPARE DOES NOT ALWAYS GENERATE A CHECK UTILITY STEP EVEN WHEN YES IS SPECIFIED | ||||
2007 |
GOC GENERATES DROP CREATE OF A TABLE WHEN IT SHOULD HAVE DONE A ALTER TABLE OR SMART ALTER WHEN CHANGING A COLUMN | ||||
2007 |
GOC ALTER INDEX ADD COL LEAVES INDEX IN REBUILD PENDING SQLCODE 610 AND CAUSES UTILITY TO FAIL RC=08 DSNU214I | ||||
2007 |
GOC PANEL GOC14 FOR LOCATION NAME GETS INVALID DB2 LOCATION WHENCORRECT LOCATION NAME IS ENTERED ONLY SSID IS ACCEPTED IN ERROR |
||||
2007 |
GOC WITH PARALLEL UNLOAD AND TARGET TABLESPACE HAS MORE PARTITIONS THAN THE SOURCE WSL GETS DSNU256I INVALID PARTITION |
||||
2007 |
OBJECT COMPARE DROPS A TABLESPACE ALONG WITH A VIEW BUT THE DROP OF VIEW IS UNNECESSARY BECAUSE IT WAS IMPLICITLY DROP | ||||
2007 |
GOC APPLY JOB FAILS SQLCODE148 AS ALTER FOR TABLE IN FOREIGN KEY RELATIONSHIP | ||||
2007 |
OBJECT COMPARE LOOP WHEN USING MASK THAT CAUSES SOME OBJECTS TO HAVE DUPLICATE NAMES AND ALIAS IS ALSO FOUND AS A VIEW | ||||
2006 |
GOC PERFORMANCE ISSUE WHEN DEALING WITH LARGE DDL SETS | ||||
2006 |
GOC WSL GETS DATA CONVERSION ERRORS BUT ONLY GETS RC04 IN WSL RUN AND DATA IS NOT LOADED INTO THE NEW OBJECT | ||||
2006 |
WHEN BP SET FOR VERY SMALL SPACE OBJECT COMPARE DOES NOT PUT UNLOAD DATA TO TAPE WSL RUNS S837 U4094 | ||||
2006 |
DEFECTS REPORTED BY IBM | ||||
2006 |
LONG NAMES USED ON GOC1TA TRYING TO ADD A TABLE FROM CATALOG IN GOC CAUSES NO ROWS RETURNED WHEN TABLE NAME LESS 18 CHAR USE | ||||
2006 |
GOC JOB FAILS WITH SQLCODE625 AS ALTER ADD PRIMARY KEY ON SECOND INDEX OCCURS BEFORE UNIQUE INDEX IS ALTERED. | ||||
2006 |
GOC CREATED DDL FOR ALTER INDEX ADD COLUMN INVALID WHEN MULTIPLE COLUMNS ADDED TO INDEX | ||||
2006 |
OBJECT COMPARE IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED ABEND U4038 | ||||
2006 |
GOC DEFER YES OMITTED FROM CREATED DDL | ||||
2006 |
GOC DROP VIEW CREATES TWO DROP STATEMENTS IN WSL SECOND DROP IS INCORRECT AND CAUSES ERROR WHEN RUN SQLCODEN204 SQLCODE204N 204 |
||||
2006 |
GOC IGNORE OF LIMITKEYS DOES NOT IGNORE CHANGE OF PARTITION LIMITKEY CONTINUES TO BE GENERATED | ||||
2006 |
SQLCODE610 RESULTS IN INDEX RBP REBUILD PENDING STATE AFTER DB2 OBJECT COMPARE GENERATES ALTER INDEX | ||||
2006 |
OBJECT COMPARE GIVES GOCC026E SEVERE ERROR WHEN GENERATING DDL GOCC002E SEVERE ERROR COMPARE TERMINATES | ||||
2006 |
GOCC024E - UNEXPECTED CATALOG ROW ON SOURCE FILE. | ||||
2006 |
OBJECT COMPARE DOES NOT PROCESS SYNONYMS CORRECTLY | ||||
2006 |
REORG M MANDATORY DOES NOT CREATE A REORG WHEN ALTER INDEX IS DONE IN OBJECT COMPARE PROCESS | ||||
2006 |
ENCODE 520 IBM0421S ONCODE=520 SUBSCRIPTRANGE CONDITION GOC2DTC MERGE CATRECS | ||||
2006 |
GOC ABENDS IBM0342S ONCODE=340 THE SIZE CONDITION WAS RAISED OR LOOP OCCURS WHEN PROCESSING LARGE DDL SET | ||||
2006 |
SQLCODE199 DSNT408I SQLCODE -199 ILLEGAL USE OF KEYWORD SQLCODEN199 SQLCODE199N BAD SYNTAX MISSING SEMICOLON | ||||
2006 |
OBJECT COMPARE ERROR DURING INPUT DDL FILE PARSING | ||||
2006 |
REFERENCE TO PK31838 | ||||
2006 |
ALLOW INFORMATION ABOUT RENAMED OBJECTS TO BE ENTERED EXPLOIT RENAME INFORMATION IN OBJECT COMPARE | ||||
2006 |
THE GOC APAR THAT GOES WITH ADB PK22717 | ||||
2006 |
GOC SQLCODE148 ALTER OF COLUMN WITH CHECK CONSTRAINT | ||||
2006 |
DIALOG SAVED IN MANAGE DIALOG IS NOT RETREIVED | ||||
2006 |
OBJECT COMPARE PRODUCES DUPLICATE STEPLIB DATASETS FOR DB2 LIBRARIES | ||||
2006 |
OBJECT COMPARE PANEL GOC14 REQUIREMENT FOR FIELD TO BE NON-BLANKCAUSES RC0012 ON T02DB2 FOR SPECIFY LOCATION NAME NON BLANK | ||||
2006 |
CHECK CONSTRAINTS DELETED AND REDEFINED EVEN WHEN IDENTICAL AND SYNTAX SQL CODE IS INCORRECT ALSO | ||||
2006 |
OBJECT COMPARE SQLCODE -104 GENERATED WHEN TRIGGERS ARE ADDED TOAN EXISTING DATABASE | ||||
2006 |
DB2 OBJECT COMPARISON TOOL RELEASE 710 FUNCTIONAL ENHANCEMENTS | ||||
2006 |
GOC COMPARE AGAINST DDL WITHOUT PRIQTY/SECQTY GETS MESSAGE 'TARGET PRIQTY=NNN IS KEPT' HOWEVER DDL HAS NO PRIQTY/SECQTY | ||||
2006 |
COMPARE CREATES BAD SYNTAX WHEN CHECK CONSTRAINT ADDED THEN CAUSING SQLCODE -546 SQLCODEN546 SQLERRD -901 | ||||
2006 |
OBJECT COMPARE IS GIVING INCONSISTENT RESULTS BASED ON MASK IGNORE AND SET SQL STATEMENTS | ||||
2006 |
OBJECT COMPARE DOES NOT USE ALTER TO CHANGE THE VOLATILE PARAMETER ON A TABLE | ||||
2006 |
OBJECT COMPARE INCORRECTLY UPDATES TABLE AND INDEX PARTITION INFORMATION | ||||
2006 |
OBJECT COMPARE INCORRECTLY CHANGES PARTITIONED INDEX INTO A SIMPLE INDEX | ||||
2006 |
SQLCODEN205 FOR CREATE INDEX WHEN COLUMNS TO BE ADDED VIA ALTER AND COMPARE AT DATABASE LEVEL | ||||
2006 |
GOC ALTER LIMIT KEY OF LAST PARTITION OF LARGE TABLESPACE RESULTS IN MESSAGE DSNU047I DSNURULD FOR THE SYSDISC DD CARD | ||||
2006 |
CORRESPONDING GOC APAR FOR ADB PK21692 | ||||
2006 |
CORRESPONDING GOC APAR FOR ADB PK19887 | ||||
2006 |
GOC COUNTER PART FOR ADB PK14753 | ||||
2006 |
GOC WSL CONTAINS GRANT STATEMENT FOR TABLE WHICH DOES NOT EXIST | ||||
2006 |
GOC JOB FAILS WITH IBM0855S ONCODE=3809 THE LENGTH OF A DATA AGGREGATE EXCEEDED THE MAXIMUM LIMIT WHEN MASK AND IGNORE USED |
||||
2006 |
VIEW COLUMN NAMES ARE NOT PROPERLY QUALIFIED WHEN RUNSQLID OPTION IS SELECTED | ||||
2006 |
GOC ALTER FAILS SQLCODEN190 WHEN DEC(10,0) COLUMN CHANGED TO DEC(11,4) | ||||
2006 |
OBJECT COMPARE DOES NOT GENERATE RUNSTATS FOR ALL INDEXES | ||||
2006 |
COMPARE DOES NOT HAVE THE OPTION TO REPLACE OR APPEND A WSL | ||||
2006 |
DB2 OBJECT COMPARISON TOOL DOES NOT GENERATE RUNSTATS FOR ALL INDEXES (ALSO, REFERENCE PK14499) | ||||
2006 |
GOC DOES NOT APPLY MASK TO INDEX NAMES FOR RUNSTATS UTILITY JOB | ||||
2006 |
GOC 0C4 GOC2CMR ENTRY: NOTIFY_REBIND_PKGS | ||||
2006 |
OBJECT COMPARE GENERATES INCORRECT DDL FOR SP. OUT PARM CHANGED TO IN PARM ON GENERATED DDL. | ||||
2006 |
OBJECT COMPARE TRIES TO CREATE DUPLICATE ALIAS | ||||
2006 |
OBJECT COMPARE DOES NOT USE A SMART ALTER TO REMOVE A TABLE CONSTRAINT | ||||
2006 |
OBJECT COMPARE IGNORES CERTAIN IGNORE PARAMETERS WHEN RUNSQLID OF <NONE> IS USED | ||||
2006 |
OBJECT COMPARE GENERATES INCORRECT MESSAGE FOR PARTITIONED TABLESPACE COMPARE | ||||
2006 |
GOC INVALID DDL PRODUCED WHEN ALL IGNORE OPTIONS SPECIFIED ON PANEL GOCCIF SELECT IGNORE FIELDS FOR SYSVIEWS | ||||
2005 |
THE CORRESPONDING PART IN OBJECT COMPARE TO ADMIN APAR PK15442 | ||||
2005 |
COMPARE COMPLETES RC0 BUT JOBLOG SHOWS ERROR IN GOCGAJOB EXEC, SHOWING MSGISRZ002 NOVALUE CONDITION RAISED | ||||
2005 |
COMPARE IGNORE LINE COMMAND IN PANEL GOCCI RESULTS IN ISPS108 INVALID LENGTHPARAMETER 'CSRROW' EXCEEDS THE ALLOWABLE LENGTH. |
||||
2005 |
GO WITH PK09476 (FROM GOC SIDE) | ||||
2005 |
ONCODE340 SIZE CONDITION RAISED AFTER ABEND0C8 FIXED POINT OVERFLOW IN ROUTINE CATREC_U_CNSTR | ||||
2005 |
OBJECT COMPARE USES A QUALIFIER IN SET CURRENT SQLID STATEMENT INSTEAD OF A VALID SQLID | ||||
2005 |
OBJECT COMPARE IGNORE FILE PARAMETERS ARE NOT BEING USED | ||||
2005 |
TABLE CONTROLLED PARTITIONING ALTER OF LIMITKEY CAUSES DROP CREATE INSTEAD OF ALTER - OR SQLCODE669 ON DROP TABLE | ||||
2005 |
COMPARE FAILS IN GOC2DTC - INVALID TOKEN AFTER LEFT PAREN - EXPECTED PART KEYWORD | ||||
2005 |
VARIOUS PROBLEMS HANDLING KEYWORDS FOR TABLE BASED PARTITIONING | ||||
2005 |
MSGIKJ58418I FOR MULTI-VOLUME VERSION FILES | ||||
2005 |
A FOLLOW-UP APAR FOR H25G710 | ||||
2005 |
THE ROLLUP APAR FOR H25G710 |