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 7.2
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PM71055
10_Sep
2012
UK81673


IBM INTERNAL APAR FOR OC V720 - PM67393 - OBJECT COMP - GRANT
PM70324
10_Sep
2012
UK81663


ABENDS0C1 ADB2GEN STATEMENT 1998 USING TAPE DEVICE FOR VERSION FILES
PM67320
10_Aug
2012
UK81018


REORG ON TABLESPACE WITH TEMPLATE GENERATES INLINE COPY
PM55912
22_Mar
2012
UK77283


LISTDSI CC=19, IKJ58418I PARTIAL DATA SET INFORMATION NOT OBTAINED. IKJ58419I DATA SET RESIDES ON MULTIPLE VOLUMES.
PM53436
6_Feb
2012
UK75970


UTIL: NO LOAD LIBRARY LISTED FOR THE DSNUPROC LIB=STATEMENT WHEN CO'ED TO REMOTE LPAR AS LOCALLY ISSUED SYSDSN
PM53988
22_Dec
2011
UK75080


NEW OBJECT GRANT STMTS NOT PROPAGATED-ADB1873E PROCESSING ENDED BUT NOT ALL SUPPLIED CATROWS WERE USED
PM43744
8_Dec
2011
UK74610


INDEX CHANGE TO/FROM AUXILIARY TABLE NOT SUPPORTED" ADBC002E SEVERE ERROR. COMPARE TERMINATES RC12
PM45471
8_Dec
2011
UK74610


ONCODE=350 FROM ENTRY POINT BUILD_LIMITKEY AT STATEMENT 18715
PM46989
8_Dec
2011
UK74610


COMPARE WITH RECREATE OF XML TABLESPACE USES GBPCACHE UNKNOWN RESULTING IN RC8
PM41845
8_Oct
2011
UK72752


SQLCODEN204 ALTER PROCEDURE AS ALTER OCCURS BEFORE CREATE PROCEDURE
PM47082
8_Oct
2011
UK72754


MQT ATTRIBUTE NOT RETAINED WHEN CREATE TABLE / ALTER TABLE ADD MATERIALIZED QUERY DDL USED.
PM47325
8_Oct
2011
UK72755


ALTER PARTITIONING KEY OF TABLE WITH LOB COLUMN(S) RESULTS IN SQLCODEN20182
PM37270
30_Sep
2011
UK72492


DUPLICATE STEP NAMES WHEN PROCESSING MORE THAN 99 UNLOADS
PM40111
31_Aug
2011
UK71429


LISTDEF IS NOT DEFINED FOR RUNSTATS WHEN USING ALC ON A TABLE TOADD A PARTITION.
PM45100
31_Aug
2011
UK71429


RUNSTATS NOT EXECUTED ON LOB TABLE SPACES WHEN ADDING A COLUMN FROM OC
PM45348
31_Aug
2011
UK71429


DSNU1212I DSNUUUFA- INVALID FIELD NAME <COLNAME> FOR TABLE WHEN USING RENAMECOL MASK. FFA10 PM40975.
PM45522
31_Aug
2011
UK71429


COMPARE WHICH WILL DROP/RECREATE MQT DOES NOT CREATE MQT INDEX
PM33635
31_Aug
2011
UK71429


NO LOAD OR REFRESH AFTER DROP MATERIALIZED QUERY TABLE ( MQT) FFA10 PM47082
PM44228
31_Aug
2011
UK71429


COMPARE DDL TO DDL SHOWS MESSAGE "(A)FIELD COMPRESS CHANGED FROMNO TO NO" FOR AN INDEX
PM44629
31_Aug
2011
UK71429


SET CURRENT SQLID AFTER ALTER / DROP RESULTING IN SQLCODEN551
PM42090
22_Aug
2011
UK71065


ADBC099E: WSL MISMATCH. THE WSLS DID NOT COMPARE EQUALLY, FAILURE OCCURRED IN CM RUN JOB.
PM37726
11_Aug
2011
UK70736


WSL APPLY JOB LOAD RELATED DD NAMES DCB SPACE(1,50) CYL RESULTS IN ABENDX37
PM43671
11_Aug
2011
UK70739


INDEX SECQTY SET TO 0 WHEN THESE IGNORE OPTIONS ARE USED
PM34009
12_Jul
2011
UK69663
PM45653

ADB3009E ERROR PROCESSING INDEX IN CREATE STATEMENT: NUMBER OF INDEX PARTITIONS DOES NOT MATCH..OR SQLCODEN644 FFA10
PM40615.
PM35871
12_Jul
2011
UK69664


SET CURRENT SCHEMA MISSING FROM INITIAL CREATE TRIGGER. FFA10 PM42232.
PK78595
12_Jul
2011
UK69686


DB2 OBJECT COMPARE WHEN TABLE IS REFERENCED BY MQT, PARTITIONINGKEYS NOT ALTERED(MQT SHOULD BE DROPPED/CREATED).FFA10 PM42531
PM28170
12_Jul
2011
UK69663
PM45653

SOURCE TABLE (TABLE-BASED PARTITION) VS TARGET TABLE (INDEX- BASED PARTITION) DROPS/CREATES PARTITIONED INDEX.FFA10
PM42016
PM37985
12_Jul
2011
UK69686


INCORRECT NAMES SHOWING IN DB2 COMMANDS AND DB2 UTILITY STATEMENTS -STA DB(NOT NULL)| UNLOAD TABLESPACE NOT NULL.
PM36300
27_Jun
2011
UK69176


JCL ERROR IEFC618I OPERAND FIELD DOES NOT TERMINATE IN COMMA OR BLANK IEFC622I UNBALANCED PARENTHESES AND IEFC621I
CONTINUATION
PM38710
27_Jun
2011
UK69187


ALT JCL ISSUES DUPLICATE STEP NAMES, INCORRECT COMMENTS AND MISSING RESTART INSTRUCTIONS. FFA10 PM39365.
PM40579
27_Jun
2011
UK69176


BATCH WSL SYSPRINT DSN NOT RETRIEVED FROM ADB2UCUS. FFA10 PM36340.
PM35169
14_Jun
2011
UK68746


STORED PROCEDURE MISSING PARAMETER CCSID UNICODE. FFA10 PM39541.
PM35965
14_Jun
2011
UK68746


MESSAGE (D)FIELD OWNERTYPE CHANGED FROM <AUTHORIZATION_ID> TO <AUTHORIZATION_ID> ISSUED FOR UDF. FFA10 PM40608.
PM28168
14_Jun
2011
UK68745


DSNU1218I DSNUULIA LOGICAL RECORD LENGTH OF OUTPUT RECORD EXCEEDED THE LIMIT FOR TABLE UNLOAD STEP RC08 APPLY JOB FFA10
PM36028
PM40293
14_Jun
2011
UK68746


ALT JCL ISSUES DUPLICATE STEP NAMES, INCORRECT COMMENTS AND MISSING RESTART INSTRUCTIONS. FFA10 PM37814.
PM39822
7_Jun
2011
UK68552


SKELETON CHANGES FOR APAR PM36495
PM39843
7_Jun
2011
UK68550


OUT OF SEQUENCE OBJECT CREATION VIEW'S CREATED BEFORE MQT. FFA10 PM35568.
PM38734
7_Jun
2011
UK68550


JCL ERROR: IEF642I EXCESSIVE PARAMETER LENGTH IN THE PARM FIELD DURING CM ANALYZE WITH RECOVER SPECIFIED. FFA10 PM38739.
PM38845
27_May
2011
UK68268


ENSURE THAT THE SAME LRECL IS USED BY INPUT AND OUTPUT FILES USED BY SORT DURING COMPARE. FFA10 PM36904.
PM34523
20_May
2011
UK67990


PANEL GOC5 MESSAGE "TARGET MISMATCH" / "A CHANGE MUST BE REGISTERED ONLY AT THE TARGET LOCATION" & GENERATE APPLY
JOBS NO
PM35976
20_May
2011
UK67991


LOBTEMPLATE DOES NOT HONOR THE DEFINITION FOUND ON PANEL ADB25TU3 LOBCOLDDN SETTING FOR THE SECOND INSTANCE.FFA10
PM37109
PM36495
20_May
2011
UK67991


COND CODE 0303 FOR CNT DATASET WHEN PROCESSING AN OBJECT CREATEDWITH DEFER YES. FFA10 PM22596.
PM22678
20_May
2011
UK67991


RENAME OF COLUMN FAILS SQLCODEN750 AS CONSTRAINT NOT DROPPED BEFORE RENAME. FFA10 PM31726.
PM29664
20_May
2011
UK67991


ADB1908E NO SYSTABLES ROW FOUND FOR 'CREATE AUXILIARY TABLE' RC12. FFA10 PM35870.
PM32005
20_May
2011
UK67991


RUNSTATS EXECUTES SUCCESSFULLY IN RUN CHANGE BUT VALUE OF COL N CARD IN ADB21TC STILL SHOWS -1. FFA10 PM31016
PM36913
20_May
2011
UK67991


PARSER ERROR WITH MSG - SYNTAX ERROR DURING STATEMENT SCAN. ERROR OCCURED WHEN PARSING THE FOLLOWING STMT.FFA10 PM30841.
PK79782
22_Apr
2011
UK67031


MISSING REBIND FOR PLANS/PACKAGES MARKED VALID 'A' CLARIFICATION OF HELP PANEL AND MANUAL. FFA PM34230.
PM06979
22_Apr
2011
UK67032


SYNONYMS FOR VIEWS ARE NOT RECREATED WITH THE RIGHT SQLID. FFA10 PM28154.
PM33186
12_Apr
2011
UK66739


SQLCODEN763 FOR CREATE TABLE AFTER (D)FIELD TABLESPACE TYPE CHANGED FROM PBG TO PBR INCORRECTLY REPORTED.
PK86262
1_Apr
2011
UK66435


FIRST DIFFERENCE UNDERLINING APPEARS BELOW EXACT TEXT MATCH IN OC JOBLOG. FFA10 PM30553.
PM19449
1_Apr
2011
UK66435


COMMENT ON COLUMN <SCHEMA>.<TABLENAME>.<COLUMN> MISSING ACTUAL COMMENT RESULTS IN SQLCODEN104. FFA10 PM31701
PM20528
1_Apr
2011
UK66435


COMPARISON OF TABLE/INDEX CREATED PRIOR TO V9 WITH OWNER=BLANK (D)FIELD OWNER CHANGED FROM '' TO TARGET OWNER. FFA10
PM29924.
PM22516
1_Apr
2011
UK66435


DROP IN TS CONTAINING MQT TABLE RESULT IN DROP TS THEN DROP MQT TABLE. DROP TS SHOULD BE SUFFICIENT. FFA10 PM29627.
PM22670
1_Apr
2011
UK66435


ALTER TABLE ADD PRIMARY KEY APPEARS IN .CHG FILE AFTER DROP/ RECREATE OF TABLE CONTAINING PRIMARY KEY. FFA10
PM32203.
PM27499
1_Apr
2011
UK66435


STORED PROCEDURE KEYWORD QUALIFIER NOT BEING MASKED FFA10 PM32201.
PM32665
1_Apr
2011
UK66435


ONCODE150 STRINGSIZE CONDITION. FFA10 PM18039.
PM33618
1_Apr
2011
UK66435


ONCODE=150 ENTRY POINT _CONCNVS TGT_INPUT AND RPT_OUTM COMPARE_FILES. FFA10 PM33633.
PM11409
1_Apr
2011
UK66435


COMMENT ON VIEW STATEMENTS MISSING AFTER COMPARE FFA10 PM32199.
PM19162
1_Apr
2011
UK66435


WHEN IGNORE PARTITIONING IS USED, DIFFERENCES IN PARTITIONING INDEX FOUND AND INDEX IS IDENTICAL. FFA10 PM32111.
PM22392
1_Apr
2011
UK66435


ALTER CONSTRAINT LENGTH DROPS RECREATES TABLE NOT, FFA10 PM31990DROP CONSTRAINT/ALTER TABLE/ADD CONSTRAINT/CHECK/REORG UTIL
PM23650
1_Apr
2011
UK66435


OBJECT COMPARE DROP/RECREATE TABLE USES " " AS TSNAME E.G. IN DBNAME." " FFA10 PM32117.
PM32869
1_Apr
2011
UK66435


DB2 OBJECT COMPARISON TOOL FOR Z/OS. ADD TESTS FOR SUPPORTED RELEASE MARKERS IN A VERSION FILE.
PM27427
16_Mar
2011
UK65848


DB2 OBJECT COMPARISON TOOL FOR Z/OS, MEMBER NAMING SEQUENCE ENHANCEMENT WHEN 'SINGLE COMPARE JOB' IS SET TO NO.
PK98233
16_Mar
2011
UK65834
UK65835


DB2 OBJECT COMPARISON RESULTS IN RC=20 UPON FTINCL GOCTUNL IN T04GAPY. INTERMITTENT FOR LARGE CHANGES FILES.FFA10
PM32530
PM29850
31_Jan
2011
UK64440

HIPER

IBM INTERNAL FOR PM13454. FFA10 PM29858.
PM19699
29_Dec
2010
UK63548


WSLVAL STEP ENDS FUNCTION = ADB2WVL, LINE 350: SIGNAL ERROR RC=08 SQLCODEN010 AND SQLCODEN104 COMMENT ON TABLE WITH SEMICOLON
PM13454
29_Dec
2010
UK63553


ADB3002E ERROR GENERATED WHEN TRIGGER TABLE IS UNQUALIFIED AND RUNSQLID IS USED WITH A DIFFERENT SQLID. FFA10 PM29858
PM17927
29_Dec
2010
UK63553


MQT MISSING AFTER COMPARE OF A CREATE TABLE / ALTER TABLE ADD MATERIALIZED QUERY DDL SET. FFA10 PM24212.
PM22711
29_Dec
2010
UK63553


EXPLICIT LOB TABLESPACE CONTAINING AUX TABLE CANNOT BE DROPPED BY ITSELF SQLCODEN616. FFA10 PM27631.
PM27179
29_Dec
2010
UK63553


IBM INTERNAL APAR FOR DTC SET RC FOR THE UNSUPPORTED STATEMENT. FFA10 PM29858.
PM08612
29_Dec
2010
UK63553


PANEL GOC5 'SINGLE COMPARE JOB' NO OPTION CAUSES JCL ERROR WHEN VERSION/MASK/IGNORE TABLE ENTRY USED. DISP=(NEW,PASS,DEL)
PM20404
29_Dec
2010
UK63553


TABLE COLUMN ROWID CHANGED TO GENERATED BY DEFAULT UPON DROP/RECREATE
PM22505
29_Dec
2010
UK63553


COMPARE WHICH WILL DROP/RECREATE MQT DOES NOT CREATE MQT INDEX FFA10 PM27184.
PM28620
29_Dec
2010
UK63553


ADB1815E NO SYSROUTINES ROW FOUND FOR 'CREATE PROCEDURE' RC=12 IN T03COMP. FFA10 PM28620.
PM16684
17_Nov
2010
UK62281


.CHGS FILE INCORRECTLY CREATED MISSING RIGHT PAREN AFTER ALTER TABLE XXX ADD COL DEC(##, # SEMI-COLON FFA10 PM22869
PM22057
17_Nov
2010
UK62281


*.DDL.CREATE MISSING ) ON ALTER TABLE XXX.XXXXX ADD CONSTRAINT FFA10 PM27695.
PM22125
28_Oct
2010
UK61721


DSNUPROC LIB PARM OF APFLIB IS GENERATED WHEN ADB2CUST :BL2LLIB TAG IS BLANK. FFA10 PM24212.
PM05622
28_Oct
2010
UK61720


MQT INDEX AND TRIGGERS CREATED PRIOR TO THE TABLE. FFA10 PM22869
PM08006
28_Oct
2010
UK61719


OBJECT COMPARE FOR Z/OS 7.2 ANALYZE AND RUN OUTPUT DIFFERENT FOR DB2 V9 FROM DB2 V8. FFA10 PM24212
PM21764
28_Oct
2010
UK61720


ADB1908E NO SYSTABLES ROW FOUND FOR 'CREATE AUXILIARY TABLE' OC SENDS GEN MQT ALIAS RECORDS WHEN PROCESSING THE CREATE
TABLE
PM22647
28_Oct
2010
UK61721


DB2 OBJECT COMPARISON TOOL FOR Z/OS CHANGE MANAGMENT TO USE VALIDATION ENSURE CHANGE REGISTERED ON TARGET. FFA10 PM20404.
PM20918
27_Oct
2010
UK61718


ALTER COLUMN GENERATES CHECK PENDING WHICH PROHIBITS THE LOAD UTILITY FROM EXECUTING.
PM20391
16_Oct
2010
UK61414


SECQTY SET TO 0 WHEN THESE IGNORE OPTIONS ARE USED.FFA10 PM24212SYSTABLEPART:PQTY,SQTY AND/OR SYSINDEXPART:PQTY,SQTY.
PM22033
16_Oct
2010
UK61416


UNNEED REORG OF DSNDB06.SYSPKAGE / RUNSTATS TABLESPACE. DSNDB06.SYSPKAGE ENDS RUNSTATS UTILITY NOT RUN GTT FFA10
PM24212
PM10756
23_Sep
2010
UK60744


ADBCCME - MERGE VERSION FILES UNABLE TO LOCATE ROW TO UPDATE WHEN ALTERING TABLE WHEN RENAMECOL USED
PM08087
23_Sep
2010
UK60743


COMPARISON REPORT ERRONEOUSLY REPORTS KEPT VALUE FOR RELATIONS WITH KEEPTGT OPTION WHEN RELATIONS ARE DROPPED
PM13250
9_Sep
2010
UK60357


SQLCODE159 STATEMENT REFERENCES ALIAS WHICH IDENTIFIES A VIEW RATHER THAN A ALIAS
PM05959
26_Aug
2010
UK60023


REBUILD INDEX UTILITY GENERATED EVEN IF TABLESPACE/TABLE IS DROPPED
PM10659
26_Aug
2010
UK60023


ADB3011E ERROR PROCESSING TABLE SPACE AAA.AAA IN CREATE STATEMENT: THE TABLE SPACE IS PARTITIONED BUT PARTITIONING
INDEX
PK82885
26_Aug
2010
UK60023


MESSAGE NULLS/DEFAULT CHANGED FROM IDENTITY GENERATED BY DEFAULTTO IDENTITY GENERATED ALWAYS YET DDL HAS GENERATED BY DEFAULT
PK84634
26_Aug
2010
UK60018


METHODS FOR CONSTRUCTING THE DSN OF THE CONVERTED UNLOAD DATA SET TO BE CONSOLIDATED ADB2UCUS VARIABLES ASYRECD AND ASYRECG
PM06957
26_Aug
2010
UK60023


COMPARE ATTEMPTS TO UNLOAD A GLOBAL TEMPORARY TABLE RC=08 MESSAGE DSNU062I DSNUGMAP UNLOAD UTILITY MAY NOT BE RUN ON
TABLE
PM10018
26_Aug
2010
UK60023


MISSING SEMICOLON FROM ALTER TABLE DROP PRIMARY KEY
PM15566
26_Aug
2010
UK60023


COMPARE OF DDL (LONG VARCHAR) V8 AND LOWER TO TARGET (VARCHAR(32310)) V9, FINDS DIFFERENCE
PM15690
26_Aug
2010
UK60023


GOCC024E - UNEXPECTED CATALOG ROW ON TARGET FILE. EXPECTED:TP OR LK FOUND:YX
PM20152
26_Aug
2010
UK60023

HIPER

DB2 OBJECT COMPARISON TOOL FOR Z/OS ERROR FAILURE ON RECOVER CHANGES WITH GLOBAL TEMPORARY TABLES.
PK97116
7_Aug
2010
UK59529


OC AND CM DROP / CREATE SCENARIOS FAIL RC08 IN IC JOBSTEP WITH RESERVED TABLESPACE NAME "ROLE" AND TEMPLATE NAME SYSCOPY
PM10503
7_Aug
2010
UK59530


MESSAGE TARGET-LOCATION MISMATCH ISSUED ON PANEL GOC5
PM12052
27_Jul
2010
UK59209


VIEW NOT DROPPED AS EXPECTED WHEN CHANGE MANAGEMENT METHOD USED
PM05319
25_Jun
2010
UK58320


OC CM USES DROP CREATE INSTEAD OF ALTER TO CHANGE FROM INDEX CONTROLLED PARTITIONING TO TABLE BASED PARTITIONING
PM15568
1_Jun
2010
UK57522


IBM INTERNAL FOR DEFECT 15749 - NO VALUE CONDITION RAISED WHILEGENERATING APPLY JOBS
PM00456
26_May
2010
UK57310


NO IMAGECOPIES FROM BLOB SPACES AFTER CHANGING THE BASE TABLE
PM03166
26_May
2010
UK57310


INCONSISTENT RESULTS FOR SCHEMA / OWNER FOR VIEW ON DB2 OBJECTS DEFINED PRIOR TO DB2 V9
PM10429
26_May
2010
UK57310


NFDB29 OBJECT COMPARE SUPPORT FOR IMPLICIT LOB AND XML TABLESPACES.
PM06289
26_May
2010
UK57310


CHANGE TO LOB TABLESPACE REORG STEP FAILS RC08 WITH DSNU076I DSNURFIT KEYWORD INVALID FOR REORG LOB TABLE SPACE
PM00478
26_May
2010
UK57310


ABEND0C4 GOC2CMP PROGRAM GOC2CMP AT OFFSET X'5020'
PM06090
26_May
2010
UK57310


ADD PARTITION RESULTS IN DROP/CREATE NOT ALTER
PM07219
26_May
2010
UK57310


COPY AND RUNSTATS UTILITY MISSING ON AUX TABLE WHEN BASE TABLE IS DROPPED AND RECREATED
PM09650
26_May
2010
UK57310


COMPARE REPORTS THAT AN (A)DROP CONSTRAINT (A)ADD CONSTRAINT WHEN NO CHANGES EXIST
PM11621
26_May
2010
UK57310


NEW COLUMN REPORTED AS ALTERED RATHER THAN ADDED
PK95732
22_Apr
2010
UK56303


CM WSL CONTAINS INDIVIDUAL REBUILD INDEX STATEMENTS INSTEAD OF REBUILD INDEX(INDEX1, INDEX2, INDEXNN )
PK97903
22_Apr
2010
UK56303


MISSING REBUILD INDEX WHEN DEFER:*,YES MASK USED RESULTS IN DSNU214I DSNUGDTC - REBUILD PENDING ON INDEX PROHIBITS PROCESSING
PK99611
22_Apr
2010
UK56327


CM ANALYZE FAILS WITH MSGADM3000E ERROR PROCESSING SYNONYM IN CREATE STATEMENT: OBJECT ALREADY EXISTS
PK97390
22_Apr
2010
UK56327


CM ALTER TABLE ADD PARTITION REPLACED BY DROP TABLE CREATE TABLE WHEN SEVERAL PARTITIONS ADDED
PK98414
22_Apr
2010
UK56303


IGNORE PARTITIONING DOES NOT PREVENT DROP AND CREATE OF TABLE WITH MESSAGE (D)NUMBER OF PARTITIONS REDUCED BY N
PARTITION(S)
PM07425
22_Apr
2010
UK56303


SEGSIZE 64 MASK APPLIED EVEN THOUGH TABLESPACE IS LOB
PM10431
22_Apr
2010
UK56303


MISSING / INCORRECT VALUE CLAUSE FOR LIMIT KEY WHEN IGNORE USED.
PM07815
26_Mar
2010
UK55637


NFDB29 RENAME INDEX SUPPORT FOR OC/CM.
PK99473
18_Mar
2010
UK55339


PRIMARY KEY AND IT'S ENFORCING INDEX ARE DROPPED IN WRONG SEQUENCE IF OBJECT CREATED BEFORE DB2 9
PM05527
18_Mar
2010
UK55339


CM RUNSTATS TABLESPACE IS INVALID
PM09381
18_Mar
2010
UK55339


GOCC034E - PROGRAM GOC2CMT DETECTED AN ONCODE CONDITION 520, IN PROCESS_LVC.
PK98614
18_Mar
2010
UK55339


MASK SEGSIZE:*.*,64 RESULTS IN (D)TABLESPACE CHANGE FROM PARTITIONED TO PARTITION-BY-RANGE MESSAGE ADB5031W
PM05246
18_Mar
2010
UK55339


MSGADBC002E DURING ANALYSE MERGE3 STEP ADDED TABLE MQT ALREADY EXISTS
PK67044
18_Mar
2010
UK55339


DB2 OBJECT COMPARE CHANGE DB/TS NAME FROM IMPLICIT WITH ALC TB USING CM.
PK94159
27_Feb
2010
UK54758

HIPER

DSNU310I DSNURCON DISCARDED CONVERSION ERROR OR DSNU1218I DSNUULIA LOGICAL RECORD LENGTH OF OUTPUT RECORD EXCEEDED
PM05986
27_Feb
2010
UK54758


SEGSIZE 64 MASK APPLIED EVEN THOUGH TABLESPACE IS PARTITIONED
PM05498
27_Feb
2010
UK54758


OBJECT COMPARE DOES NOT GENERATE IMAGE COPY FOR CHANGED TABLES
PM04862
27_Feb
2010
UK54758


UNEXPECTED CATALOG ROW ON TARGET WHEN MASKING AND IGNORE USED
PM04868
27_Feb
2010
UK54758


NFDB29 - SUPPORT CLONED TABLES - OBJECT COMPARE SUPPORT.
PK94503
26_Feb
2010
UK54758


ALTER INDEX CLUSTER TO NOT CLUSTER AND NOT CLUSTER TO CLUSTER WITH REORG ALL RELEVANT SPECIFIED DID NOT BUILD A REORG
PK96038
26_Feb
2010
UK54758


CHANGE MANAGEMENT CHG FILE CONTAINS AN EXTRA ALTER TABLE ADD CONSTRAINT PRIMARY KEY MERGE "ADD PRIMARY KEY FAILED"
ERROR
PK96401
26_Feb
2010
UK54758


CHANGE MANAGEMENT CHG FILE CONTAINS INCORRECT SET CURRENT SCHEMA
PM03277
26_Feb
2010
UK54758


MSG (D)NUMBER OF PARTITIONING KEY COLUMNS HAVE CHANGED FROM 0 TO 2
PM00134
26_Feb
2010
UK54758


IF ANALYZE DETECTS THAT THE ONLY DIFFERENCE BETWEEN TWO VIEWS ISTHE OWNER, IT WANTS TO RECREATE THE VIEW. VALIDATE WOULD
FAIL.
PK85809
26_Feb
2010
UK54758


MSG GOCC025E - DUPLICATE RECORD WAS DETECTED FOR OBJECT<TRIGGER NAME> ERROR PROBABLY CAUSED BY MASKING. RC=12
PK84596
26_Feb
2010
UK54758


CHANGES TO PANEL GOC5 DESCRIPTION OF DATASETS AND CONSISTENT NAMING CONVENSION FOR BATCH VS ONLINE GENERATION.
PM06552
26_Feb
2010
UK54758


OPTION V TO CREATE VERSION FILE FROM DB2 VERSION SCOPE RESULTS IN SOURCE INCOMPLETE ERROR
PK94505
21_Jan
2010
UK53737


CM IBM0361W ONCODE=350 THE STRINGRANGE CONDITION WAS RAISED. BUILD_LIMITKEY COMPARE_TABLES
PK95782
21_Jan
2010
UK53737


CHANGE TO CREATE TABLE PARTITION BY CLAUSE NOT FOUND
PM02891
21_Jan
2010
UK53737


NFDB29 - OC BATCH INITIALIZATION FOR TRUSTED CONTEXT.
PM02455
21_Jan
2010
UK53737


ADBC139E INTFIN AND C001 MISMATCH. COLNAMES NOT EQUAL INTFIN: AAAAAAAA C001 : DSN_IDENTITY
PK84531
18_Dec
2009
UK53039


DB29 - TRUSTED CONTEXT & ROLES - SUPPORT SCHEMA, NEW OWNER COLUMNS, ROLES AND TRUSTED CONTEXT - GEN, MASKING
PK99577
18_Dec
2009
UK53039


CHANGE MANAGEMENT MQT DROP TABLE AFTER DROP TABLESPACE RESULTS IN SQLCODEN204
PK84598
18_Dec
2009
UK53039


IMPROVED SOS ERROR HANDLING
PK92928
16_Nov
2009
UK52001


COMPARE REPORTS (A)DROP CONSTRAINT (A)ADD CONSTRAINT TABLES HAVE IDENTICAL COLUMN LISTS TABLE WILL BE ALTERED WHEN NO
CHANGE
PK95234
16_Nov
2009
UK52001


CM LABEL BEING ADDED REPORTED BUT NO CHANGES GENERATED ( NOT THE SAME AS PK78594 )
PK98472
16_Nov
2009
UK52001


DB2 OBJECT COMPARISON ABILITY TO COMPARE BASED ON OBJECT TYPES.
PK87981
20_Oct
2009
UK51211


OC SUPPORT DB2 UNLOADS CONSTANT OPTION TO PROVIDE INITIAL VALUE FOR NEW NOT NULL NO DEFAULT COLUMNS.
PK95225
20_Oct
2009
UK51211


OC MIGRATING FROM INDEX-BASED PARTITIONING TO TABLE-BASED PARTITIONING IN SOME CASES THE INDEX NEEDS TO BE
DROPPED/CREATED
PK92885
20_Sep
2009
UK50282


OBJECT COMPARE SUPPORT FOR INACTIVE NATIVE SQL PROCEDURES.
PK94220
20_Sep
2009
UK50282


COLUMN (D)FIELD OWNERTYPE CHANGED FROM<GARBAGE> TO <GARBAGE> RESULTS IN TABLE BEING DROPPED AND RECREATED - NO IGNORE
PK84050
20_Sep
2009
UK50282


AFTER MSGS "CONVERSION NOT SUPPORTED" AND "TABLE DATA CONVERSION JOBSTEP WILL BE GENERATED" ARE ISSUED NO JOB IS BUILT
PK84752
20_Aug
2009
UK49454


IMPROVEMENTS TO ERROR HANDLING TO ALLOW CUSTOMERS TO SEE SORT MESSAGES SUCH AS THE ICE039A INSUFFICIENT MAIN STORAGE
MESSAGES
PK86601
20_Aug
2009
UK49454


MESSAGE (D)COLUMN DB2_GENERATED_ROWID_FOR_LOBS DROPPED RESULTS IN TABLE WITH LOB COLUMNS BEING DROPPED AND RECREATED
PK91570
20_Aug
2009
UK49454


NOVALUE CONDITION NOVALUE CONDITION RAISED FOR VARIABLE GOCRCH GOCGCMP, LINE 1392: IF GOCRCH = 'Y' THEN
PK93189
20_Aug
2009
UK49454


OC ONCODE=350 STRINGRANGE CONDITION WAS RAISED
PK74335
20_Aug
2009
UK49454


RUNSTATS TABLESPACE INDEX(ALL) AND RUNSTATS INDEX CREATED BY OC REDUNDANT RUNSTATS UTILITY CREATED
PK81863
20_Aug
2009
UK49454


SQLCODEN644 WHEN CHANGING THE NUMBER OF PARTITIONS IN A TABLE AND THE TABLE HAS A PARTITIONED INDEX
PK83129
20_Aug
2009
UK49454


INVALID DB2 LOCATION ERROR MESSAGE IN PANEL GOC14
PK72445
25_Jul
2009
UK48695


NATIVE STORED PROCEDURES SUPPORT NFDB29
PK89541
24_Jun
2009
UK47718


CHANGE MANAGEMENT CM SQLCODEN104 SQLCODE -104 LABEL ISSUE.
PK72441
18_Jun
2009
UK47564


DB2 9 GEN, OC, AND CM SUPPORT NFDB29 FSS
PK79864
27_Apr
2009
UK46072


CHANGE MANAGEMENT CM SQLCODEN104 SQLCODE -104 LABEL ISSUE
PK73206
6_Apr
2009
UK45542


OBJECT COMPARE 720, RESTRICT THE USE OF CLONED TABLES, XML AND HIDDEN CLOUMNS FOR DB2 V9 NFDB29
PK77192
5_Apr
2009
UK45542


MISSING SET CURRENT PATH FOR CREATE VIEW, CREATE TRIGGER AND CREATE TABLE ( MQT ).
PK76963
5_Apr
2009
UK45542


ABEND0C4 IN GOC2CMP ROUTINE TGT_INPUT STATEMENT 3132 RESULTS IN LE ABENDU4039 RC0 WITH ONCODE8094
PK79322
5_Apr
2009
UK45542

HIPER

DB2 OBJECT COMPARE ABENDU4091 RC0B IN ADB2WVL ADB2WVL LINE 261 SIGNAL ERROR
PK82748
5_Apr
2009
UK45542


CATOUT DD NAME HAS INCORRECT DCB SPACE INFORMATION WHEN COMPARING DB2 CATALOG TO EMPTY DDL FILE
PK71059
5_Apr
2009
UK45542


DB2 OBJECT COMPARE ALLOW USER TO CHANGE ENCODING SCHEME.
PK79772
12_Mar
2009
UK44861


OBJECT COMPARE LOAD SUMMARY REPORT OPTION TO SYSOUT OR DATASET.
PK75684
10_Feb
2009
UK43899


MISC PERFORMANCE IMPROVEMENTS TO GOCGAJOB / GOCGCMP
PK76210
10_Feb
2009
UK43899


PANEL GOC5 PDS CHANGES HANDLING RESULTS IN IEC141I 013-14
PK78555
10_Feb
2009
UK43899


GOCGCMP, LINE 2701: VERPRIM = FORMAT(SYSUSED*VERPRIMFACTOR,,0) WHEN PDSE USED.
PK76269
16_Jan
2009
UK43241


GOCC024E - UNEXPECTED CATALOG ROW ON TARGET FILE. EXPECTED:TA FOUND:TB WHEN PROCESSING MQT
PK69728
16_Jan
2009
UK43241


CHECK DATA UTILITY GENERATED BY OBJECT COMPARE WHEN NO LOAD/ RELOAD UTILITY USED
PK75284
15_Dec
2008
UK42509


DB2 OBJECT COMPARE FIX PADDING AND RECORD SIZE IN THE INCLUDE MODULE GOC2CMPC.
PK74694
15_Dec
2008
UK42509


DB2 OBJECT COMPARE TRIGGER CREATED PRIOR TO DEPENDENT VIEW WHEN TRIGGER ON TARGET
PK75059
15_Dec
2008
UK42508


NEW FUNCTION FOR PERFORMING CHECK UTILITY PROCESSING
PK68568
15_Dec
2008
UK42509


INCONSISTENCY IN PANEL GOC3 AND PANEL GOC4
PK69848
15_Dec
2008
UK42509


REORG UTILITY GENERATED BY OBJECT COMPARE WHEN TABLESPACE IS NOTIN REORG PENDING STATE
PK70014
15_Dec
2008
UK42511


OC-OBJECT COMPARE LOB SUPPORT.
PK74058
14_Nov
2008
UK41565


DB2 OBJECT COMPARE ADD PRIMARY KEY FAILED. TABLE OWNER.NAME ALREADY HAS A PRIMARY KEY
PK74513
14_Nov
2008
UK41565


ABEND0C4 IN GOC2CMP ROUTINE GET_HEADER_INFO
PK71689
14_Nov
2008
UK41565


TRIGGER NOT MASKED CORRECTLY - CHANGES FILE HAS CORRECT NAME HOWEVER THE CREATE STATEMENT HAS THE UNMASKED NAME
PK72328
14_Nov
2008
UK41565


GOCC031E - SUBSTR OUTSIDE STRING - INTERNAL ERROR
PK74046
13_Nov
2008
UK41565


OC COMPARE GENERATES MESSAGE GOCC032E DUPLICATE RECORD
PK64178
13_Nov
2008
UK41565


CHANGE MANAGEMENT GENERATED ALTER SET DATA TYPE FOR TABLE DEFINED WITH DATA CAPTURE CHANGES END RC=08 SQLCODEN148
PK73717
13_Nov
2008
UK41565


TABLESPACE DROPPED AND RECREATED RATHER THAN DROP OF INDEX WHEN COLUMN REMOVED FROM CLUSTERING INDEX
PK73799
13_Nov
2008
UK41565


OC UNABLE TO IGNORE PARTITIONING BETWEEN A TABLE BASED PARTITIONED OBJECT AND A INDEX PARTITIONED OBJECT
PK74167
13_Nov
2008
UK41565


DB2 OBJECT COMPARE CHANGE WITH ADD LABEL/COMMENT TO A COL RC24 (WARNING) STEP REG10 ANALYZE - CHANGE CHANGE FILE IS
EMPTY
PK68229
13_Nov
2008
UK41565


CREATE TRIGGER WITH DEPENDENCY ON DROPPED VIEW IS CREATED BEFOREVIEW RESULTS IN SQLCODEN20100 AND SQLCODEN204 WITHIN CREATE
TRIG
PK70003
13_Nov
2008
UK41565


ADBCCME - ERROR(S) FOUND ADDED VIEW AAAAAAA.AAAAAAAA ALREADY EXISTS ADBC002E - SEVERE ERROR. MERGE TERMINATES RC=12
PK70140
13_Nov
2008
UK41565


OC WSL FAILS SQLCODEN661 -661 WHEN CHANGING NUMBER OF PARTITIONS
PK73328
13_Nov
2008
UK41565


WSL CLONE APPENDS QUOTATION MARKS TO LOWERCASE COLUMNS RESULTING IN SQLCODEN206 IS NOT A COLUMN OF AN INSERTED TABLE
PK73518
13_Nov
2008
UK41565


SPECIFYING WSL COMPARING UNICODE OBJECTS GENERATES DSNT408I SQLCODE -874
PK43747
13_Nov
2008
UK41565


CM CHANGES AMENDED CCSID FROM EBCDIC TO UNICODE EVEN AFTER MESSAGE ATTEMPTED CHANGE OF FIELD ENCODING SCHEME IS NOT
SUPPORTED.
PK48235
3_Nov
2008
UK41297


MISLEADING MESSAGE GOCC025E - DUPLICATE RECORD WAS DETECTED FOR OBJECT WHEN OBJECT BEING RENAMED (OLD NAME LISTED NOT NEW
NAME)
PK48326
3_Nov
2008
UK41297


GOC MISSING BIND FOR PACKAGE WHEN ALTER TABLE FOREIGN KEY ON DELETE SET NULL ISSUED.
PK66167
3_Nov
2008
UK41297


WHEN DECP DECIMAL=COMMA, LKEY GENERATED IS INTEGER
PK73075
3_Nov
2008
UK41297


OC CREATED WSL IMAGECOPY DATASET NAME RESOLVED &PART TO LAST PARTITION REFERENCED RATHER THAN THE STRING ALL
PK50584
3_Nov
2008
UK41297


TABLENAMES WITH SPCL CHARS NOT ENCLOSED IN SINGLE QUOTES
PK61263
3_Nov
2008
UK41297


ALTER OF TABLE WITH VALIDPROC FAILS WITH SQLCODE -148
PK68160
8_Oct
2008
UK40599


CM ANALYZE MERGE3 RC12 ADBCCME ADBC002E
PK64483
8_Oct
2008
UK40599


OC PERFORMS DROP/CREATE INSTEAD OF ALTER TABLE ALTER PARTITION
PK66898
8_Oct
2008
UK40599


OBJECT COMPARE REMOVE ALTER INDEX LEFTOVER ALTER. ALTER INDEX STATEMENT DOES NOT REMOVE EXCESS OPTIONS.
PK67682
8_Oct
2008
UK40599


DB2 OBJECT COMPARE REBUILD INDEX IF OPTION DEFER=YES IS CHOSEN.
PK67827
8_Oct
2008
UK40599


DB2 OBJECT COMPARE DSN PREFIX, INCONSISTENT LENGTH IMPLEMENTATION IN PANELS
PK70473
8_Oct
2008
UK40599


VARIOUS LINKEDIT ERRORS WHEN ADMIN PTFS ARE APPLIED WITHOUT REQUIRED OBJECT COMPARE PTFS WHEN JCLIN CHANGES
PK71066
8_Oct
2008
UK40599


OC MULTIPLE INPUT DELTA CHANGE FILES INTO A SINGLE CHANGE FOR CHANGE MANAGEMENT
PK71298
8_Oct
2008
UK40599


CHANGE UTILITIES IN OBJECT COMPARE SO THE MODIFY STEP IS NOT GENERATED AFTER A COPY.
PK63360
8_Oct
2008
UK40599


USING OC, GRANTS ARE GENERATED PRIOR TO MQT TABLE CREATION
PK64316
24_Sep
2008
UK40164


CM ALTER SQLCODEN20181 COLUMN CANNOT BE ADDED TO INDEX
PK68130
24_Sep
2008
UK40164


DB2 OBJECT COMPARE 213-C8,IFG0194D COMPRESSED DATASETS
PK66205
24_Sep
2008
UK40164


DB2 OBJECT COMPARE SUBSCRIPT RANGE ONCODE=520
PK69642
24_Sep
2008
UK40164


ABENDS0CA ABEND IN GOC2CMP WHEN OLDER VERSION FILES USED
PK67490
15_Aug
2008
UK39002


ABEND80A/ABEND878 IRX0662E EXECIO ERRORIRX0043I ERROR RUNNING GOCGCMP IEC143I 213-C8,IFG0194D
PK68069
15_Aug
2008
UK39002


USING MIG WITH VIEW CREATED WITH AN ALIAS CREATES THE VIEW WITH THE SAME TBOWNER AS THE ALIAS.
PK47139
15_Aug
2008
UK39002


CM ALC TIMESTAMP TO DATE COLUMN CHANGE REPORTED AS "NO CHANGES TO TABLE"
PK62666
15_Aug
2008
UK39002


ADB2WVL SIGNAL ERROR RC8 MSGISPS102 MSGADB3000E ERROR PROCESSINGTABLE XXX IN CREATE STATEMENT: OBJECT ALREADY EXISTS.
PK65287
10_Jul
2008
UK37995


ADMIN REQUIRED DD CARD OR TEMPLATE IS MISSING NAME=STPRIN01 (THIS IS OBJECT COMPANION APAR FOR ADMIN APAR PK64428.)
PK65601
10_Jul
2008
UK37995


NEW FUNCTION CHANGES TO THE MAXE COMMAND - SUPPORT FOR STOPPING ON FAILING DB2 COMMAND BUT NOT FAILING BIND COMMAND
PK51806
10_Jul
2008
UK37995


OC WITH KEEPTGT COMPARING SOURCE WITH EXPLICIT DROP ON INDEX ALSO UNNECESSARILY IMPLICITLY DROPS VIEW IMPLICIT VIEWS DROP
PK52932
10_Jul
2008
UK37995


GOC5 GENERATE APPLY JOBS = NO GIVES INCORRECT OUTPUT WHEN USED AS A DELTA AND IMPORTED TO NEW SYSTEM DOCUMENTATION CONFUSING
PK62636
10_Jul
2008
UK37995


VOLUME TO BE ADDED TO IGNORE LIST
PK52850
15_May
2008
UK36526


CHANGE MANAGEMENT DOES NOT COMPLETELY SUPPORT ROTATE PARTITION
PK60557
15_May
2008
UK36526


OC COMPANION FOR PK60194 - DROP OF AN INDEX WHICH ENFORCES THE PRIMARY KEY CONSTRAINT RESULTS IN SQLCODE -669
PK61994
15_May
2008
UK36526


ANALYZE FAILS WITH MERGE ERROR WHEN A COLUMN IS ADDED WITH IS PART OF THE PRIMARY KEY AND UNIQUE INDEX
PK62187
15_May
2008
UK36526


DSNT408I SQLCODE -109 WHEN PARTITIONED TABLE WITH DSSIZE CHANGEDTO NON PARTITIONED
PK44435
15_May
2008
UK36526


GOC2DTC UNSUCCESSFUL COMPLETION GOCC026E ONCODE 1040 DURING WRITE CATREC IEC030I B37 RC04 CATSIN ONCODE1040 OUT OF SPACE
PK44799
15_May
2008
UK36526


RECEIVING ONCODE350 STRINGRANGE CONDITION RAISED IN GOC2CMR AT ENTRY POINT ADD_OBJECT AT STATEMENT 2080
PK54827
15_May
2008
UK36526


OC TO SUPPORT TABLE-BASED TO INDEX-BASED PARTITION DIFFERENCE AND USE ADD PARTITION WHEN THE NUMPARTS INCREASES
PK55704
15_May
2008
UK36526


OC LOAD STEP FAILS MSGDSNU1036I DSNURELD - UNABLE TO ESTIMATE SPACE REQUIREMENTS FOR WORKDDN
PK57584
15_May
2008
UK36526


IGNORE SYSINDEXPART OPTIONS CHANGED
PK64121
15_May
2008
UK36526


GOC5 VAL, THEN ADB2CMRO=YES FOR CM IS ACCEPTED (Y IS NOT)
PK57848
15_May
2008
UK36526


MASK SCHEMA DOES NOT PREVENT 'D)FIELD PATHSCHEMAS CHANGED FROM AAA TO BBB' AND 'VIEW WILL BE RECREATED' MESSAGES
PK59648
15_May
2008
UK36526


NEW FUNCTION
PK61812
15_May
2008
UK36526


DSNT408I SQLCODE = -20182, ERROR: PARTITIONING CLAUSE ENDING AT ON CREATE
PK61810
15_May
2008
UK36526


OBJECT COMPARE DROPPING LABEL ON VIEW WHEN TEXT UNCHANGED.
PK62158
15_May
2008
UK36526


OC USING WSL UNINITIALIZED VARIABLE IN EXEC ADB2W1 AT LINE 1451.
PK62638
15_May
2008
UK36526


GOCONL VARIABLE NOT INITIALIZED
PK63672
15_May
2008
UK36526


CM ANALYZE B37 EXDLTA VEROUT DD HARDCODED (THIS IS OBJECT COMPANION APAR FOR ADMIN APAR PK62075.)
PK57391
9_Apr
2008
UK35297


CMDELTA CHANGES FILE CONTAINS VIEW WITHOUT DROP RESULTS IN ADBCCME ADDED VIEW AAA.AAA ALREADY EXISTS
PK58632
9_Apr
2008
UK35297


CM DELTA CHANGES FILE MISSING DATATYPE CHANGE WHEN FOREIGN KEY PRESENT.
PK60531
9_Apr
2008
UK35297


ALTER OF CLUSTERING INDEX NOT PERFORMED BEFORE CREATE OF NEW CLUSTERING INDEX
PK50436
9_Apr
2008
UK35297


GOC ALTER OF PRIMARY KEY IS MISSING SEMI COLON SO WHEN APPLY OF JCL OR RUN WSL GET SQLCODEN199 SQLCODE199N SQLCODE199
PK55154
9_Apr
2008
UK35297


SUPPORT FOR PARTITION LEVEL REORG RATHER THAN TABLESPACE REORG WHEN CHANGES EFFECT PARTITION LEVEL
PK55844
9_Apr
2008
UK35297


SQLCODEN644 ALTER LOB TABLESPACE MAXROWS
PK60185
9_Apr
2008
UK35297


OC COMMENT ON INDEX NOT HANDLED CORRECTLY
PK53013
6_Apr
2008
UK35297


CHANGE MANAGEMENT GENERATED JCL FAILS SQLCODEN661 -661 WHEN CHANGING NUMBER OF PARTITIONS AND RUNSQLID SPECIFIED
PK55969
6_Apr
2008
UK35297


OBJECT COMPARE MISCOMPARE OF IDENTICAL VIEWS WITH 1 VIEW CREATEDWITH LEADING SPACES
PK60271
6_Apr
2008
UK35297


CM DELTA CHANGES FILE MISSING ALTER TABLE ADD COLUMN AND ALTER TABLE ALTER COLUMN SET DATA TYPE
PK49772
6_Apr
2008
UK35297


DROP OF SOURCE ALIAS WHEN MASKING USED
PK51238
6_Apr
2008
UK35297


GOC SAP U4038 SUBSCRIPTRANGE CONDITION IN DROP_OBJECT.2906 WHEN COMPARING VERY LARGE QUANITIES OF OBJECTS
PK57766
6_Apr
2008
UK35297


OBJECT COMPARE SHOWS UNNECESSARY CHG ON LIMIT KEY ' ' OR ',' W DECP USED
PK55219
6_Apr
2008
UK35297


MESSAGE ADB1843E 'NO SYSVIEWS ROW FOUND FOR 'CREATE VIEW'' AND 'PARSING OF NEW SOURCE VIEW FAILED' WHEN MASK USED ON
VIEW
PK57682
6_Apr
2008
UK35297


SQL ERROR IN PREPARE FOR STATEMENT: ADMIN DROP TABLE SQLCODE -199
PK57842
6_Apr
2008
UK35297


QOUTES ADDED TO VIEW COLUMN NAMES
PK58181
6_Apr
2008
UK35297


OC COUNTERPART FOR PK57452
PK58329
6_Apr
2008
UK35297


OC COMPARE STEP FAILED WITH 'LOAD NOT SUPPORTED FOR PARTITIONS
PK58607
6_Apr
2008
UK35297


'MASKING IS NOT APPLIED CORRECTLY FOR ADMIN ALTER STATEMENTS
PK53764
13_Feb
2008
UK33681


WHEN USING OBJECT COMPARE AND MASK AND 2 STOGROUPS WHICH WILL RESULT IN STOGROUPS BEING DUPLICATED, OBJECT COMPARE ABENDS
PK58427
13_Feb
2008
UK33680


CM ALTER TABLE ALTER PARTITION N ENDING ENDS RC=08 SQLCODEN663
PK54239
13_Feb
2008
UK33680


MSG ADD PRIMARY KEY FAILED. TABLE XXX ALREADY HAS A PRIMARY KEY
PK58190
13_Feb
2008
UK33681


ABENDS80A-10 OCCURRING WHEN USING DB2 ADMINISTRATION TOOL (OBJECT COMPARE FIX FOR PK57316)
PK39306
13_Feb
2008
UK33680


FF720 FFPK35127 GOC APPLY JOB FAILS SQLCODE148 ALTER FOR TABLE IN FOREIGN KEY RELATIONSHIP SQLCODEN148 FORWARD FIT FOR
PK35127
PK46168
13_Feb
2008
UK33680


GOC WITH SOURCE BEING ONE TABLE COMPARING TO TABLE IN CATALOG WITH INDEX AND PACKAGES CAUSES DROP OF IX BUT NO REBIND OF
PKG
PK49941
13_Feb
2008
UK33680


MASK NOT APPLIED TO RUNSTATS INDEX
PK52029
13_Feb
2008
UK33680


NEW FUNCTION APAR REMOVAL OF RESTRICTIONS LIFTED BY DB2 APAR PK51853
PK53158
13_Feb
2008
UK33680


OC NEW FUNCTION - RETAIN THE CONSTRAINT NAME WHEN CHANGING OBJECT
PK50350
13_Feb
2008
UK33680


CREATE TRIGGER SQLCODEN199 MISSING TERMINATOR
PK52409
13_Feb
2008
UK33680


'SUPPRESS ADDING COLUMNS' OPTION ON PANEL GOC5 DID NOT STOP TABLE FROM BEING DROPPED AND RECREATED WHEN MASKING USED
PK56518
13_Feb
2008
UK33681


CM OBJECT COMPARE ON CMDELTA USING TEMPLATES CREATES BAD REBUILDINDEX SYNTAX BAD COPYDDN VALUE INVALID OPERAND COPYDDN
REBUILD
PK57475
13_Feb
2008
UK33681


OC - VERSION STORED IN CM SHOULD BE BASE NOT DELTA
PK53194
17_Jan
2008
UK33041


UNLOAD CONVERT STEP FAILS WITH MSGIKJ56893I MSGIGD17401I MSGIGD306I
PK55690
17_Jan
2008
UK33041


OC LOAD STEP FAILS ON UTLDISC TEMPLATE WITH MESSAGE: INVALID KEYWORD SPACE FOR TAPE TEMPLATE
PK49792
7_Dec
2007
UK32042


JCL EXTENDS TO COLUMN 73 WHEN USED IN COMBINATION WITH OTHER OBJECT COMPARE PARAMETERS
PK53350
7_Dec
2007
UK32079


NEW FUNCTION
PK54512
8_Nov
2007
UK31056


++HOLD FOR UK26615 UK26556 UK26557 INVALID , SADB AND ADB SHOULD BE SGOC AND GOC RESPECTIVELY IN ACTION
INSTRUCTIONS
PK52113
12_Oct
2007
UK30239


CM ANALYZE JOB FAILS RC 12 'INSERT COL UNABLE TO LOCATE POSITIONCOLUMN' WHEN TWO COLUMNS ADDED TO TABLE
PK46951
12_Oct
2007
UK30238


LACK OF THE GENERATION OF THE REBUILD INDEX JOB FOR OBJECT COMPARE
PK51782
12_Oct
2007
UK30239


INCORRECT VERSION FILE TYPE ASSIGNED IN OBJECT COMPARE WHEN THE OLD VERSION FILE IS OVERWRITTEN IN CHANGE MANAGEMENT
PK51942
12_Oct
2007
UK30239


GOC SIBLING APAR FOR PK51878 CM ISSUES WITH RENAME COLUMN INCORRECT / MISSING LOAD STEP
PK44100
2_Oct
2007
UK29840


ONCODE=350 STRINGRANGE CONDITION IN MODULE ADB27AC AT ENTRY INTERPRETE_LOAD_STMT AT STMT 1796 WITH NOPAD OPTION ACTIVE
PK49062
2_Oct
2007
UK29840


MISSING REORG USING CM WHEN A - ALL RELEVANT IS CHOSEN
PK39229
2_Oct
2007
UK29840


INVALID LIMITKEY DEFINITION GENERATED WHEN COMPARE OPTIONS IGNORE LIMITKEY AND TABLE CHANGES PRESENT.
PK39133
2_Oct
2007
UK29840


ALC LOAD STATEMENTS CONTAIN OLD COLUMN NAMES WHICH CAUSE A DSNU053I DSNURWUF - FIELD AAAA NOT FOUND RC=08 ERROR
PK38128
2_Oct
2007
UK29840


GOC DOES NOT GENERATE A REORG FOR A MAXROW WHEN "ALL RELEVANT" SPECIFIED THEREFORE ONLY NEW ROWS EFFECTED BY CHANGES
PK39167
2_Oct
2007
UK29840


"SMART" ALTER NOT PERFORMED WHEN OPTION, "SUPPRESS DROP OF COLUMNS" SELECTED.
PK40104
2_Oct
2007
UK29840


OBJECT COMPARISON NOT GENERATING REBIND DURING COMPARE PROCESSING WHEN A NEW INDEX IS DETECTED.
PK33848
2_Oct
2007
UK29840


GOC DROPS RECREATES TABLESPACE THAT HAD NUMPARTS CHANGED WHEN IT SHOULD HAVE DONE A SMART ALTER
PK43476
2_Oct
2007
UK29840


INTERNAL APAR IN ORDER TO PROVIDE GOC FIX, PK42992 IS ADB APAR.
PK44645
2_Oct
2007
UK29840


GOC MASK NOT APPLIED TO MQT/MATERIALIZED QUERY TABLE DEFINITION
PK45751
2_Oct
2007
UK29840


MASK NOT APPLIED TO MQT DURING WSL CREATION.
PK50887
2_Oct
2007
UK29840


GOC1CA - INCOMPLETE SCHEMA NAMES DISPLAYED
PK43649
2_Oct
2007
UK29840


DB2 OBJECT COMPARISON TOOL OUTPUT PARAMETER REPORT SHOWS INCORRECT VALUE FOR RUN SQLID , VALUE " <NONE> " IS INVALID .
PK45191
2_Oct
2007
UK29840


GOC WHEN RUNNING APPLY JOB DOING CONVERSION STEP GET ABEND0C4 IN GOC2LCC
PK46993
2_Oct
2007
UK29840


GOC PRODUCES INCORRECT DDL FOR TABLE CHECK CONSTRAINT APPLY GETSDSNT408I SQLCODEN104 SQLCODE 104 ILLEGAL SYMBOL ION
SQLCODE104N
PK47244
2_Oct
2007
UK29840


SQLCODE636 FROM MULTIPLE CHANGE IN LIMITKEY VALUES
PK48309
2_Oct
2007
UK29840


ALTER ADD PARTITION AND LIMIT KEY CHANGES NOT IMPLIMENTED CORRECTLY
PK49369
2_Oct
2007
UK29840


COMPARE APPLY JOB FAILS CONVERT STEP CC1012 WITH MSGADBC107E ERROR IN OLD COL NUMBERS
PK38700
1_Oct
2007
UK29840


APAR PK32112 IGNORE OF LIMITKEYS DOC CHANGES HOW IGNORE HANDLES SYSINDEXPART SYSTABLEPART LIMITKEY INTERNAL EXTERNAL
PK40964
1_Oct
2007
UK29840


FF720 GOC PANEL GOCCI 'SPECIFY IGNORE FIELDS' DOES NOT HAVE PATHSCHEMA FOR SYSPACKAGE TO ALLOW TRIGGER DIFFERENCES TO BE
IGNORED
PK45153
23_Jul
2007
UK27387


COMPARE NOT RECOGNIZED RENAMED DB IN TS, CAUSE INCORRECT GRANTS
PK38517
29_Jun
2007
UK26716


GOC SCHEMA MASK NOT APPLIED TO PATH STATEMENT
PK41852
29_Jun
2007
UK26716


MQT NOT CREATED CREATE RUN JCL FAILED WITH -601: CREATE VIEW ALREADY EXISTED
PK42104
29_Jun
2007
UK26716


FF720 GOC WITH DB2XML XMLVARCHAR GIVES GOC2DTC UNSUCCESSFUL COMPLETION UNEXPECTED TOKEN IN TABLE DEFINITION TOKEN F/F
PK42718
29_Jun
2007
UK26716


GOC FOR COLUMN CHANGE TO ROWID NOT NULL GENERATED ALWAYS GENERATES INCORRECT DDL OF ROWID NOT NULL GENERATED BY
DEFAULT
PK43007
29_Jun
2007
UK26716


GOC MESSAGE GOCC025E - DUPLICATE RECORD WAS DETECTED FOR OBJECT RC=12
PK43346
29_Jun
2007
UK26716


GOC APAR THAT GOES WITH ADB APAR PK40333
PK43744
29_Jun
2007
UK26716


DURING COMPARE PROCESS A SET CURRENT SQLID IS MISSING FOR GRANTS
PK43753
29_Jun
2007
UK26716


CM ALTER ADD COLUMN CREATED REORG IN ERROR WHEN 'RUN REORG' MANDATORY SPECIFIED ON PANEL ADB2C11A
PK38969
29_Jun
2007
UK26716


GOC PANEL GOC14 FOR LOCATION NAME GETS INVALID DB2 LOCATION WHENCORRECT LOCATION NAME IS ENTERED ONLY SSID IS ACCEPTED IN
ERROR
PK39296
29_Jun
2007
UK26716


GOC GENERATES DROP CREATE OF A TABLE WHEN IT SHOULD HAVE DONE A ALTER TABLE OR SMART ALTER WHEN CHANGING A COLUMN
PK39298
29_Jun
2007
UK26716


OBJECT COMPARE NOT HANDLING CHECK UNIQUE CONSTRAINT CORRECTLY EYCAUSING DROP OR DELETE AND RECREATE UNIQUE KEY
PK38753
26_Jun
2007
UK26557


IBM INTERNALAPAR, CM - ABEND 4038 IN GOC2CMF
PK39158
26_Jun
2007
UK26557


IBM INTERNAL CMPR OBJECTS BEING ALTERED/DROPPED: SHOULD REPORT "NO CHANGE"
PK39610
26_Jun
2007
UK26557


TABLE OWNER WITHIN GRANT STILL USING SOURCE OWNER FOR TABLE BEING GRANTED, INSTEAD OF TARGET OWNER
PK40611
26_Jun
2007
UK26557


FF720 RUN SQLID ON VIEWS REFERENCING SYNONYMS FOR OBJECT COMPARE CREATES 2 PART NAME INCORRECTLY FFPK36310 PK36310
R710
PK37357
26_Jun
2007
UK26557


DURING COMPARE PROCESS A CHANGE IS DETECTED WITHIN A TRIGGER WHERE TRIGGER HAS A THIRD QUALIFIER .
PK38433
26_Jun
2007
UK26557


GOC APPLY JCL COMMENTS REFERENCE THE WRONG TABLE NAME IN THE LOAD STEPS
PK40955
26_Jun
2007
UK26557


FF720 GOC MISSING SET SQLID FOR CREATE SYNONYM DESPITE MSG SAYING NEW SYNONYM AAA FOR AUTHID AAA WILL BE ADDED F/F
PK32584
PK41507
26_Jun
2007
UK26557


FF720 GOC WITH PARALLEL UNLOAD AND TARGET TABLESPACE HAS MORE PARTITIONS THAN THE SOURCE WSL GETS DSNU256I INVALID
PARTITION
PK38479
26_Jun
2007
UK26557


TEMPLATES USED IN CM ANALYZE FUNCTION WERE NOT BEING USED CERTAIN CONDITIONS IBM INTERNAL
PK38331
26_Jun
2007
UK26557


IBM INTERNAL APAR, CONVERSION ERROR FLAG RC ENHANCEMENT
PK38783
26_Jun
2007
UK26557


OBJECT COMPARE GENERATES INVALID LOAD UTILITY FOR A PARTITIONED COMPRESSED TABLESPACE
PK39531
26_Jun
2007
UK26557


FF720 GOC ALTER INDEX ADD COL LEAVES INDEX IN REBUILD PENDING SQLCODE 610 UTILITY FAILS RC=08 DSNU214I FFPK34308
PK40485
26_Jun
2007
UK26557


FF720 IBM INTERNAL APAR, AEP GOC RUNSTATS NOT GENERATED, IT'S F/F FOR PK34487 (710) FFPK34487
PK36231
20_Feb
2007
UK22356

HIPER

PK36231 IS THE FOLLOW-ON APAR H25G720 07/03/13 PTF
PECHANGE
PK27180
16_Feb
2007
UK22304
PK36231

SQLCODE -538 REFERENTIAL INTEGRITY CONSTRAINT FOREIGN KEY IS ADDED TO CHILD TABLE BEFORE PRIMARY KEY IS ADDED TO PARENT
TABLE
PK36338
16_Feb
2007
UK22304
PK36231

GOC USING PANELID ADB2US01 FOR REORG SHRLEVEL CHANGE FOR MAPPING TABLE DOES NOT PRODUCE WSL DDL WITH THE MAPPING TABLE
PK38757
16_Feb
2007
UK22304
PK36231

GOC WSL APPLY STEP HAD IKJ56225I DATA SET ALREADY IN USE, TRY LATER+ MESSAGE BUT STEP ENDED RC=00
PK34919
16_Jan
2007
UK21300

HIPER

H25G720 ROLLUP APAR

Top of page