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: 21 November 2024
DB2 Administration Tool Version 12.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PH62045
24_Sep
2024
UI98520


DB2 UNLOAD USING ADBTEP2 INSTEAD OF DSNUPROC FOR SOME UNLOAD STEPS
PH62044
24_Sep
2024
UI98530


ADB7350E ADB2CMT MODULE : ADB2CMT DETECTED AN ONCODE CONDITION 520 IN COMPARE_TABLES
PH61841
3_Sep
2024
UI98265
UI98530


REBUILD MISSING FOR AN ALTERED INDEX RESULTS IN RUNSTATS UTILITY FAILURE
PH61578
14_Aug
2024
UI98019


ADMIN TOOL UTILITIES OPTION "VG - RECOVER TO LAST GDG" NOT WORKING
PH60092
22_Jul
2024
UI97737


S414 ABEND AND HANG RUNNING ADBTEP2 WHEN SYSPRINT IS A DATASET
PH60552
22_Jul
2024
UI97735


IMAGE COPY MISSING OR INCORRECT WITH CERTAIN PARAMETERS USING CM BATCH
PH61355
22_Jul
2024
UI97731


ADMIN TOOL V550: ONCODE= 8094. ONLOC=ADB2SYS. ONLINE= 417
PH59779
1_Jul
2024
UI97550


FOREIGN KEY NOT RECREATED AFTER IMPLICIT DROP VIA OBJECT COMPARE
PH61270
1_Jul
2024
UI97545


OBJECT COMPARE ONCODE=612 WHEN DEFAULT IS DROPPED
PH59493
10_Jun
2024
UI97260


REDUNDANT HEXADECIMAL VALUES IN ADB21T PANEL QUERY
PH60343
10_Jun
2024
UI97262


WSL WORKLIST ERROR IN DB2 ADMIN TOOL VALIDATION WHEN USING SESSION_USER
PH60294
10_Jun
2024
UI97257


APPLY JOB FAILS TO PROCESS A TABLE WITH LOWERCASE NAME
PH61230
30_May
2024
UI97101


OPTIMIZE MEMORY USAGE IN MERGE AND OBJECT COMPARE
PH61339
20_May
2024
UI96970


INSUFFICIENT INPUT VALIDATION FOR STATIME_DDF ZPARM
PH61154
10_May
2024
UI96853


INTERNAL APAR SEPARATE LOCATION STATS FROM STATIME_MAIN SUPPORT
PH60281
26_Apr
2024
UI96706


GENERATION OF COPY UTILITY JCL TAKES A LONG TIME WHEN DONE FROM A LIST OF TABLE SPACE PARTITIONS
PH60855
18_Apr
2024
UI96567


INTERNAL APAR FOR BUG SMASH 2023 (PHASE 3).
PH59092
10_Apr
2024
UI96461


DB2 SPACE MANAGER PANEL APPEARS AFTER DSN LINE COMMAND IN ADB21S TABLESPACE PANEL FOR USER TABLE SPACE.
PH59113
10_Apr
2024
UI96466


WHEN PERFORMING A COMPARE WITH CM=YES, RUNNING THE CHG JOB FAILS DUE TO INCORRECT ALTERS ON TRIGGERS.
PH59221
10_Apr
2024
UI96478


DSNX200I SQLCODE -104 AND DSNT233I UNSUCCESSFUL BIND FOR PACKAGE
PH59218
10_Apr
2024
UI96470


THE PARSER DOES NOT SUPPORT THE PERIOD FOR .. CLAUSE IN CREATE TABLE
PH59491
10_Apr
2024
UI96463


ADMIN TOOL MOVETB DATA SET NOT CATALOGED
PH59569
10_Apr
2024
UI96472


TWO SORTDEVT OPTIONS FOR LOAD DATA ARE GENERATED WHEN MIG PANEL ADB28M INPUT FIELDS UNLOAD METHOD = HPU AND PARALLEL
UTILITIES =
PH60526
29_Mar
2024
UI96322


(ADB) INTERNAL APAR FOR SUPPORT FOR MISSING REPAIR UTILITY OPTIONS.
PH58606
25_Mar
2024
UI96224
UI96230


DROP OF MQT TABLE SPACE VIA OBJECT COMPARE GENERATING UNNECESSARY DROP TABL
PH58787
25_Mar
2024
UI96230


REORG WITH USE PROFILE OPTION FAILS WHEN COLUMN IS DROPPED
PH58892
25_Mar
2024
UI96227


CURSOR NUMBER LIMIT IS REACHED IN WSL VALIDATE
PH59147
25_Mar
2024
UI96222


UPDATE SORT HELP PANEL TO REFLECT USE OF SORT SEQUENCE NUMBER
PH59223
25_Mar
2024
UI96232


KEYWORD UNIT IS DUPLICATED IN UTILITY TEMPLATE WHEN CHANGE IS RUN USING CM BATCH
PH60091
15_Mar
2024
UI96103


OBJECT COMPARE TOOL IS GENERATING WORKLIST IN WRONG ORDER, CAUSING SQLCODE -628 ON APPLY JOB 24/03/15 PTF
PECHANGE
PH59607
7_Mar
2024
UI95998


INTERNAL APAR FOR BUG SMASH 2023 (PHASE 2)
PH58311
26_Feb
2024
UI95822


QUERYACCELERATION BIND OPTION STICKING
PH58313
26_Feb
2024
UI95811


CHANGE IN TRIGGER EXECUTION ORDER IS NOT DETECTED IN CM ANALYZE
PH58314
26_Feb
2024
UI95818


COMPARE REPORTS TABLE AS ALTERED WHEN NO CHANGES ARE NEEDED
PH58508
26_Feb
2024
UI95819


INTERPRET PANELS ADB21KI1 AND ADBP1KSI HAVE INVALID OR INADEQUATE DESCRIPTION OF COPYID VALUES
PH58511
26_Feb
2024
UI95814


INTERPRET PANELS ADB21KI1 AND ADBP1KSI HAVE INVALID OR INADEQUATE DESCRIPTION OF COPYID VALUES
PH58570
26_Feb
2024
UI95809


"INVALID DATASET NAME" ERROR MESSAGE OCCURS WHEN ZFS FILE IS SPECIFIED FOR "LIBRARY"
PH58605
26_Feb
2024
UI95807


COMPARE DOES NOT HANDLE CHANGES TO APPLCOMPAT FOR TRIGGERS
PH59016
26_Feb
2024
UI95805
UI95818


ADMIN TOOL: COLUMN CHANGE FAILS WHEN IT REQUIRES A NEW BUFFER POOL BECAUSE OF LARGER PAGESIZE
PH57667
2_Feb
2024
UI95540
UI95807


PARSER ERROR WHEN GENERATING DDL FOR ADVANCED TRIGGER
PH57777
2_Feb
2024
UI95546


PROBLEM OCCURS WHEN ALT IMMEDIATE CHANGE IS DONE ON AN ACCELERATED TABLE
PH57997
2_Feb
2024
UI95542


ISPP153 PANEL 'ADB21S' ERROR (OR 'ADB21D'); INVALID QUOTED STRING, END QUOTE OR CONTINUATION ("+") MISSING
PH58256
2_Feb
2024
UI95535


ADMIN TOOL: -551 ERROR ON SYSIBM.SYSENVIRONMENT
PH58267
2_Feb
2024
UI95544


CONSTRAINT AND PRIMARY KEY ARE MISSING FROM GENERATED CREATE TABLE AND ALTER TABLE DDL.
PH58340
2_Feb
2024
UI95538


IMPROVE ADB3002E MESSAGE IN DDL VALIDATION WHEN TABLESPACE IS DROPPED IMPLICITLY
PH54523
16_Jan
2024
UI95251


PARSER ERROR: UNEXPECTED TOKEN AFTER VARIABLE KEYWORD - EXPECTED KEYWORD CCSID
PH57109
16_Jan
2024
UI95253


DDL READER ERROR WHEN LEAVE FOUND IN SP BODY
PH57197
16_Jan
2024
UI95244


ISPT034 TABLE IS NOT OPEN ERROR IN ADB28SC JOB TBBOTTOM ISSUED FOR TABLE ADB28XCL THAT IS NOT OPEN CC 990
PH57420
16_Jan
2024
UI95246


SUBSCRIPTRANGE ONCODE 520 IN CM30251 OR STORE_TGT_VIEW WHEN COMPARING SOURCE AND TARGET CREATE VIEW DDL WITH MANY TABLE
REF.
PH57615
16_Jan
2024
UI95241


OBJECT COMPARE INCORRECTLY GENERATES THE CHECK DATA AFTER FIRST FOREIGN KEY CHANGE, LEADING TO SQLCODE = -20385
PH57782
16_Jan
2024
UI95248


WHEN MAKEPBG ON PANEL ADB21SAR IS ENTERED FIRST, CHANGE TO PART LEVEL ATTRIBUTES (I.E., PRIQTY) ARE IGNORED.
PH58846
3_Jan
2024
UI95099


BUG SMASH 2023 (PHASE 1)
PH56144
20_Dec
2023
UI95023


ADMIN TOOL RETURNS MISLEADING PACKAGE DEPENDENCIES FOR INDEXES
PH54047
15_Dec
2023
UI94964


REPLICATION ON IDAA FAILS TO BE ENABLED FOLLOWING TABLE NAME CHANGE
PH56578
15_Dec
2023
UI94960


SQLCODE=-205 ERROR WHEN QUOTED COLUMN NAMES AND CHECK CONSTRAINT INCLUDED
PH56571
15_Dec
2023
UI94956


CHANGE VIEW OF GENERATION OUTPUT REPORT FROM EDIT MODE TO BROWSE MODE
PH56696
15_Dec
2023
UI94966


UNABLE TO ADD TEMPORARY TABLE TO TABLESPACE VIA COMPARE, ALTHOUGH ALLOWED BY DB2
PH56916
15_Dec
2023
UI94962


PARSER ERROR WHEN GENERATING DDL FOR A TRIGGER
PH58315
5_Dec
2023
UI94719


(ADB) INTERNAL APAR PH58315 SUPPORT FOR MISSING RUNSTATS INDEX UTILITY OPTIONS.
PH58388
5_Dec
2023
UI94722


INTERNAL APAR PH58388 4Q 2023 AOC12 DEFECT BACKLOG REDUCTION EPIC (AOC12 AND 13)
PH56416
30_Nov
2023
UI94665


WHEN DROP/CREATE OF A TABLE WITH TRIGGERS IS GENERATED, RO ON TABLESPACE PREVENTS CREATE OF TABLE AFTER DROP
PH54980
22_Nov
2023
UI94591


Compare attempts to drop and create archive TS when only base table is modified and present on source DDL
PH56370
22_Nov
2023
UI94587


GENERATE INDEXES IN CHRONOLOGICAL ORDER INSTEAD OF ALPHABETICALLY
PH56371
22_Nov
2023
UI94589


INCORRECT REVOKE STATEMENTS ISSUED WHEN DOING A PRIMARY COMMAND REVOKE ON PANEL ADB2AUD
PH56415
22_Nov
2023
UI94594


REORG INCORRECTLY GENERATED FOR A PAGENUM RELATIVE TABLESPACE WHEN INCREASING TABLESPACE DSSIZE
PH57629
22_Nov
2023
UI94596


ADBTEP2 RESETS CURRENT SQLID AFTER UTILITY CALL
PH57103
16_Nov
2023
UI94205


OPTION Z.2Z RESULTS IN ADB402 <> 0 RC FROM THE INSTRUMENTATION FACILITY: RETURN CODE = 00000004. REASON CODE = 00E60804
PH58158
15_Nov
2023
UI94473


PH58158 ADD MAXPARTITIONS SUPPORT TO MOVETB PANEL ADB2MVT1
PH56172
9_Nov
2023
UI94401


CHANGE MANAGEMENT ANALYZE STEP SETS INCORRECT PAGENUM VALUE ON TABLE SPACE
PH56186
9_Nov
2023
UI94397


AL COMMAND ON PBR TABLE SPACE WITH PAGENUM ABSOLUTE DOES NOT VALIDATE SEGSIZE OR MEMBER CLUSTER AND DOES NOT SHOW DSSIZE
PH57107
9_Nov
2023
UI94399


FIELD RO SHOWS BLANK IN DB2X APPLICATION PLANS (PANELID ADB21P)
PH57694
27_Oct
2023
UI94202


INTERNAL APAR PH57694 ALLOW EXECUTION OF REVOKE IMPACT IN BATCH MODE
PH55312
16_Oct
2023
UI94024


DB2 ADMIN V12/V13: ON PANEL ADB2314, THE PARTITION COLUMN SCROLLS OFF SCREEN INSTEAD OF REMAINING ON SCREEN.
PH55450
16_Oct
2023
UI94028


Admin tool should catch SCHEMA mismatch in DDL for AUX and base tables pre-masking
PH55588
16_Oct
2023
UI94022


OBJECT COMPARES FAILS TO PROPAGATE THE DEFAULT TABLESPACE DSSIZE TO TABLESPACE PARTITIONS
PH55591
16_Oct
2023
UI94032


OBJECT COMPARE - EMPTY ALTER SEQUENCE STATEMENT ADDED TO WSL
PH55592
16_Oct
2023
UI94026


Import DDL to recreate a table without CREATE TS should have error message to include TS in DDL.
PH56225
16_Oct
2023
UI94030
UI94032


OBJECT COMPARE USES TABLE NAME FOR DROP TRIGGER STATEMENT WHEN EXPLICITLY DROPPING TRIGGER
PH54720
27_Sep
2023
UI93770


ADB2A5.TOKENIZE ERROR WHEN QUESTION MARK IS USED AS A STORED PROCEDURE PARAMETER MARKER
PH55435
27_Sep
2023
UI93757
UI93770


OBJECT COMPARE FAILS TO HANDLE CCSID COLUMN ATTRIBUTE
PH55449
27_Sep
2023
UI93765


UNSUCCESSFUL BIND OCCURS IF DBRM LIBRARY ON BIND PACKAGE PANEL DOES NOT EXIST
PH55583
27_Sep
2023
UI93759


CMBATCH SUPPORT FOR GENERATING FOREIGN KEY CHANGES WHEN CALLING GOCCM
PH55727
27_Sep
2023
UI93755
UI93770


OBJECT COMPARE FAILS TO ACKNOWLEDGE THE SYSINDEXES BPOOL IGNORE FOR IMPLICIT INDEXES
PH55801
27_Sep
2023
UI93753
UI93770


COMPARE GENERATES INVALID WSL WITH VIEW THAT CONTAINS INCORRECT TERMINATOR
PH56227
27_Sep
2023
UI93763


OBJECT COMPARE: WHEN EXCL SPEC IS INVOKED, PANEL ADBPC7L TRUNCATES THE MESSAGE COLUMN VALUES TO ONE CHARACTER
PH55748
20_Sep
2023
UI93639
UI93770


REDUCE MEMORY USAGE IN MERGE AND OBJECT COMPARE
PH56993
20_Sep
2023
UI93642
PH60091

INTERNAL APAR FOR SMART REORG GENERATION (PHASE 3)
PH56994
20_Sep
2023
UI93644


(ADB) INTERNAL APAR SUPPORT FOR MISSING LOAD UTILITY OPTIONS
PH53247
13_Sep
2023
UI91178
UI93141
UI93770


ADB2GEN FAILS WITH S0C4-00000004 WHEN GEN JOB CONTAINS SQLCMTS='Y'
PH52643
5_Sep
2023
UI93443


ADMIN TOOL: DET COMMAND ON PACKAGE FAILS WITH ERROR CONDITION IN MAPHV
PH54408
5_Sep
2023
UI93441


ADMIN TOOL:ADDING SOURCE EXCLUDE CAUSES UNRELATED GRANT STATEMENTS AND DROP ALIAS STATEMENTS TO BE MISSING FROM THE
WSL
PH54690
5_Sep
2023
UI93445


WHEN USING MOVETB (COMMAND OR LINE COMMAND), PANEL ADB2MVT1 ISSUE ERRONEOUS MESSAGE WHEN A FULLY QUALIFIED DATASET IS
SPECIFIED.
PH54871
5_Sep
2023
UI93449
UI93644


DROP MQT TABLE SPACE VIA OBJECT COMPARE GENERATING UNNECESSARY START TABLE SPACE IN RW MODE
PH55144
5_Sep
2023
UI93439


DB2 ADMIN TOOL: S522 OR S414 ABEND IN ADBTEP2 AFTER AN I/O ERROR ON SYSPRINT WHEN SYSPRINT IS A DATASET
PH55210
5_Sep
2023
UI93447


REPORT REVOKE IMPACT DOES NOT REPORT ON SOME OR ALL VIEWS BEING DROPPED.
PH54621
10_Aug
2023
UI93145


DB2 AOC: COMPARE TOOL GENERATES INVALID WSL THAT FAILS WITH SQLCODE = -20385
PH55135
10_Aug
2023
UI93143


GENERATION OF CATALOG COPY OBJECTS MAY TAKE A VERY LONG TIME OR TIME OUT BEFORE FINISHING
PH55143
10_Aug
2023
UI93141


SQL STATEMENT IS GENERATED WITH A LONG STRING LITERAL TRUNCATED TO 4000 CHARACTERS.
PH55216
10_Aug
2023
UI93135


PREFIX IS MISSING FROM RECOVER WSL AND JCL DATA SET NAMES WHEN DATA TO RECOVER IS SET TO 'B'
PH55260
10_Aug
2023
UI93139


MISLEADING TEXT "COMMANDS:" APPEARS ON PANELS ADB2MES AND ADB2MEX WHEN COMMAND(S) ARE NOT YET AVAILABLE.
PH53067
31_Jul
2023
UI92972


DB2 ADMIN TOOL V13 GENERATES RECTYPE PREFIX UNRECOGNIZED BY DB2 ADMIN TOOL V12-ADB27AC ERROR
PH54580
24_Jul
2023
UI92869


CLEAN UP COLLECTION PANEL DOES NOT ALLOW LOAD LIBRARIES WITH NON-ZERO LRECL
PH54617
24_Jul
2023
UI92877


DB2 ADMIN TOOL: ERROR ADB3024E ISSUED INCORRECTLY WHILE PROCESSING OBJECT IN CREATE STATEMENT
PH54692
24_Jul
2023
UI92875


SQLCODE = -750 WHEN ADDING A TABLE COLUMN AND RENAMING A TABLE COLUMN REFERENCED BY A VIEW
PH54830
24_Jul
2023
UI92873


ADMIN TOOL: BIND COPY OF PACKAGE WITH MIXED-CASE NAME, MAKES PACKAGE NAME UPPER CASE. 23/06/15 PTF
PECHANGE
PH55623
24_Jul
2023
UI92871


WHEN ANALYZING SOURCE VF THAT HAS EMPTY DEFAULT VALUE FOR WLM ENVIRONMENT FIELD CAUSES SQLCODE=-104
PH53913
10_Jul
2023
UI92665


DB2 ADMIN TOOL V12.1: ERROR RUNNING ADB2ZDC
PH53885
10_Jul
2023
UI92667


B37 ON ADBDIAG AND THEN ERROR DOING REVOKE SYSADM
PH53831
10_Jul
2023
UI92662


DET FAILS TO OUTPUT ENTIRE SQL STATEMENT, CAUSING VALUES TO BE WRITTEN ON TOP OF EACH OTHER
PH53740
10_Jul
2023
UI92666


ADMIN TOOL: CREATE UNIQUE INDEX STATEMENT INCORRECTLY ADDING DSSIZE
PH52946
10_Jul
2023
UI92668


DB2 ADMINISTRATION TOOL - DSN LINE COMMAND ON PANEL ADB21S DOES NOT WORK
PH53832
10_Jul
2023
UI92661
UI92972


ALTERING TABLES WHILE USING NOPAD UTILITY OPTION RESULTS IN ONCODE = 520
PH53593
10_Jul
2023
UI92663


PARSER FAILS TO TOKENIZE VALUES PRECEDING CONCAT OPERATOR '!!' UNDER CCSID 500 (ADMIN TOOL V13)
PH54451
10_Jul
2023
UI92664


ADMIN TOOL: PROBLEMS WITH ADB21KSE PANEL EXPLAIN COMMAND
PH54753
5_Jul
2023
UI92596
UI92600


ONCODE 340 IN BUILD_DEPOBJ_LIST WHEN STORED PROCEDURES ARE COMPARED
PH54714
5_Jul
2023
UI92600


INTERNAL APAR BUGSMASH 2022
PH53065
12_Jun
2023
UI92210


AOC: WHEN RUNNING OBJECT COMPARE IN CMDELTA MODE, ALTER TABLE STATEMENTS CAUSE THE TABLESPACE TO BE REQ. FOR THE
COMPARE
PH53497
12_Jun
2023
UI92212


ALT INDEX FAILS WITH "INVALID PIECESIZE VALUE" MESSAGE
PH53588
12_Jun
2023
UI92208


ABSTRACT: OBJECT COMPARE DOES NOT SUBSTITUTE COMPRESS YES FIXEDLENGTH WITH COMPRESS YES ON DB2 Z/OS FLS < FL509
PH54682
5_Jun
2023
UI92093


DB2 ADMIN TOOL UTILITY FIXES
PH54716
2_Jun
2023
UI92088


INTERNAL APAR HANDLE MISSING TABLESPACE AND INDEX ATTRIBUTES IN CREATE/ALTER FLOW (PANELS).
PH51730
23_May
2023
UI91949


WITH MOVETB, ADD AN OPTION TO GENERATE RUNSTATS FOR NEW TABLESPACES
PH52511
23_May
2023
UI91779


ADMIN TOOL: TEMPLATES FOR REBUILD INDEX ARE NOT GENERATED WHEN RECOVERING A TABLESPACE
PH52515
23_May
2023
UI91747


ADMIN TOOL - MANAGE FAST INDEX TRAVERSAL PANEL ERROR (PANEL ADB2Z2I2)
PH53444
23_May
2023
UI91957


WSL EDIT COMMAND HAS FORMATTING PROBLEMS WHEN DONE ON LARGE STATEMENTS
PH54480
15_May
2023
UI91802


SUPPORT DDL VS DDL COMPARE IN CMBATCH
PH54153
11_May
2023
UI91773


INTERNAL APAR SUPPORT NEW DB2 ZPARMS.
PH54152
11_May
2023
UI91771


INTERNAL APAR MASKING SUPPORT FOR REMOVING KEY LABEL.
PH49831
1_May
2023
UI91584
UI91771


Admin Tool: Adding a ROWID or LOB column followed by ALTER to tablespace PAGENUM fails with SQL -20385
PH51812
1_May
2023
UI91593


THE DET COMMAND ON A PACKAGE COPY DISPLAYS DETAILS OF THE LIVE PACKAGE AND NOT THE EXPECTED INACTIVE PACKAGE
PH52438
1_May
2023
UI91419
UI92088


ADMIN TOOL: INCORRECT REORG WHEN PAGENUM IS ALTERED WITH OTHER PENDING CHANGES
PH53248
1_May
2023
UI91641
UI91593


ABENDE37-08 ABEND OCCURS WHEN USING DET COMMAND ON ACCELERATOR TABLE
PH51594
1_May
2023
UI91634


RESZ COMMAND ON PANEL ADB2M1S PAGE SET STATISTICS BUILDS INCORRECT REORG JCL THAT CAUSES RC=8 WHEN RUN
PH53408
1_May
2023
UI91639


USE OF THE TAB KEY ON PANEL ADB21 CAUSES CURSOR TO POSITION ON OPTION AO.
PH52342
24_Apr
2023
UI91540


FAST INDEX TRAVERSAL OPTION OF RUNNING INDEXTRAVERSECOUNT RESULTS
PH51813
10_Apr
2023
UI91255
UI91419
UI92088


FREEPAGE CHANGE MISSING FROM WSL/REPORT WHEN USING OBJECT COMPARE
PH51974
10_Apr
2023
UI91309
PH54830

ADMIN TOOL: BIND COPY OF PACKAGE WITH MIXED-CASE NAME CHANGED TO UPPER CASE
PH52563
10_Apr
2023
UI91374


ADB2CMT DETECTED AN ONCODE CONDITION 8094 IN COMPARE_TABLES AT 7678
PH53295
10_Apr
2023
UI91378


GENERATED AOC/TCZ JOB ASSOCIATED WITH TEMPLATE ADBCVUTS IS MISSING VALUES FOR OWNER AND SCHEMA.
PH53236
4_Apr
2023
UI91280


AVOID DEFAULTING BUFFERPOOL
PH53429
4_Apr
2023
UI91279


WSL AND OBJECT COMPARE FIXES FOR DB2 ADMIN TOOL V12
PH51646
21_Mar
2023
UI91046


ADMIN TOOL: REBINDS SHOULD BE GENERATED AS PART OF WSL AND NOT VIA AUTOREBIND WHEN ADDING DELETE CASCADE
PH51241
20_Mar
2023
UI91026


DSNTYPE LARGE SPECIFIED FOR TEMPLATES IN ADB25TS BUT WAS CHANGED BY ADMIN TOOL TO DSNTYPE LIBRARY INSTEAD
PH51372
20_Mar
2023
UI91024


FOR DB2 12 FL505 AND NEWER, DB2 ADMIN TOOL SUPPORT IS MISSING FOR FREE PACKAGE PLANMGMTSCOPE(PHASEOUT)
PH51592
20_Mar
2023
UI90961
UI91279


MULTIPLE RUNSTATS GENERATED FOR TABLESPACE, TABLE AND INDEX
PH51684
20_Mar
2023
UI91018


ADMIN TOOL - CLREST COMMAND: "PROCESSING ERROR" MESSAGE
PH51895
20_Mar
2023
UI90946
UI91280


COMPARE PRE VERSION 12 (FL500) OBJECTS - GEN DDL AGAINST THE CATALOG - GIVING ALTERS FOR SECQTY IN INDEXES.
PH50946
17_Mar
2023
UI91020


DEFECT BACKLOG
PH52919
17_Mar
2023
UI91021


NEW QUERY_ACCEL_OPTIONS ZPARM VALUE
PH50758
1_Mar
2023
UI90766
UI90810


NO PARTITION INFORMATION IN DDL VIA GEN FOR INDEX WITH BUSINESS TIME WITHOUT OVERLAPS SPECIFIED
PH52639
1_Mar
2023
UI90810


ELIMINATE UNNECESSARY REORGS WHEN RUNNING CHANGES
PH49614
27_Feb
2023
UI90759
UI90810


DB2 ADMINISTRATION TOOL: ONCODE 8094 IN ADB2CMT AT COMPARE_TABLES AT 20269
PH50390
27_Feb
2023
UI90753


OBJECT COMPARE REPORT WITH THE ERROR MESSAGE ADB7955E
PH50662
27_Feb
2023
UI90751


WHEN SORT COMMAND IS USED IN THE "EDIT/RUN SQL STATEMENT" HELP PANEL ADBHSORT LISTS COMMAND THAT IT SHOULDN'T
PH50722
27_Feb
2023
UI90761


REST SERVICES UPPER CASE OPTION RESETS INAPPROPRIATELY
PH51126
27_Feb
2023
UI90757
UI90759
UI90810


DUPLICATE REORG GENERATED FOR TABLESPACE
PH51314
27_Feb
2023
UI90755
UI90759
UI90810


SYSTABLESPACE IGNORE FOR TRACKMOD SHOULD EXTEND TO SYSTABLEPART TO AVOID COMPARING TRACKMOD FOR IMPLICIT LOB TABLESPACES
PH51329
27_Feb
2023
UI90748
UI92088


AL LINE COMMAND SHOULD NOT ALLOW TRACKMOD ALTER FOR IMPLICIT LOB TABLESPACE AS IT IS A DB2 RESTRICTION
PH52517
27_Feb
2023
UI90776
UI90810


COMPARE INCORRECTLY GENERATES A CHANGE FOR THE TABLESPACE COMPRESS ATTRIBUTE
PH52344
22_Feb
2023
UI90641


SUPPORT FOR MISSING DB2 COPY UTILITY OPTIONS
PH45889
5_Feb
2023
UI90380


DB2 AOC: WSL EDITOR LINE COMMAND PROBLEMS WITH LARGE DDL OBJECTS GREATER THAN 32704 CHARACTERS - DDL TRUNCATION
PH49471
5_Feb
2023
UI90388
UI92664
PH54451

DB2 ADMIN: PROBLEMS WITH ADB21KSE PANEL EXPLAIN COMMAND
PH50227
5_Feb
2023
UI90384


EXPLICIT COUNT FOR TYPE "GLOBAL TEMPORARY" ON PANEL ADB2AUS SHOWS > 1, YET LINE COMMAND AE AGAINST IT SHOWS "NO ROWS
TURN"
PH50425
5_Feb
2023
UI90394
UI90396


COMPARE GENERATES DROP/CREATE FOR DSSIZE CHANGE IF PARTITIONING IS IGNORED
PH50488
5_Feb
2023
UI90382
UI90776
UI90810


ERROR MESSAGE ADB8067E OCCURS WHEN OBJECT COMPARE EVALUATES THE TABLE DROP RESTRICTION & OTHER TABLE ATTRIBUTE CHANGES
TOGETHER
PH50508
5_Feb
2023
UI90392
UI92093


ERROR MESSAGE ADB7955E FOR WARNING SQLCODE +162 IN ADBTEP2 OUTPUT
PH50547
5_Feb
2023
UI90378


UNABLE TO GENERATE DDL FOR AN OBJECT STARTING WITH SPACE CHARACTER
PH50562
5_Feb
2023
UI90390
UI90396


NO COMMIT AFTER ALTER TABLE ADD COLUMN STATEMENTS
PH50588
5_Feb
2023
UI90386


COMPLETION CODE=0C4 REASON CODE=00000010 OCCURS DURING INVOCATION STARTUP OF DB2 ADMIN TOOL.
PH50611
5_Feb
2023
UI90396


UNLOAD FAILS FOR A TABLE IN INCOMPLETE STATE
PH49653
20_Jan
2023
UI90193
UI90197


DB2 ADMIN TOOL: ADBCCME DETECTED AN ONCODE CONDITION 8094 IN MERGE_TABLES - ADD A SECOND INDEX ON A HISTORY TABLE
PH48760
20_Jan
2023
UI90181
UI90197


OBJECT COMPARE: INCORRECT HANDLING OF ALTER TABLE <TB> ADD <COL> GENERATED BY DEFAULT IDENTITY AND ADD NEW INDEX
PH49713
20_Jan
2023
UI90179
UI90197


DB2 ADMIN TOOL: NEXTVAL IS WRAPPED IN QUOTES WHEN GENERATING DDLFOR A TRIGGER CAUSING A -206 ERROR
PH50088
20_Jan
2023
UI90195


SIZE ERROR DUE TO OVERFLOW OF COUNTER IN GEN_UNIQUE_CONSTRAINTS()
PH50090
20_Jan
2023
UI90186


COMPARE OF AN ADDITIONAL INDEX ON SRC SIDE GENERATES DROP/CREATE TABLESPACE BUT W/O CREATE OF TABLE AND INDEX ON
TAR
PH50364
20_Jan
2023
UI90191
UI90193
UI90197


SUBGROUPS OF TRIGGERS ARE INCORRECTLY UPDATED DURING MERGE
PH50892
20_Jan
2023
UI90197


ACCELERATION OF A TABLE IS NOT RESTORED AFTER THE TABLE IS ALTERED
PH51453
20_Jan
2023
UI83974
UI90197


DDL command after ALTER produces additional attributes form SYSINDEXPART 23/01/20 PTF
PECHANGE
PH48623
9_Jan
2023
UI83970
UI90641


WRONG TABLESPACE NAME USED AT START COMMAND
PH48786
9_Jan
2023
UI83970
UI90641


ADMIN TOOL ISSUES START SPACES RW TOO EARLY, AFTER DELETING 2 COLUMNS ON 2 TABLES WITH VERSIONING
PH50918
4_Jan
2023
UI83918
UI92088


VALIDATE RANDOM RELATED INDEX OPTIONS ON PANEL ADB21XAR
PH48961
13_Dec
2022
UI83727
UI90191
UI90193
UI90197


ADMIN TOOL - INCORRECT ALTER TABLE SEQUENCE GENERATED
PH49058
9_Dec
2022
UI83664
UI90197


OBJECT COMPARE: CREATE TABLESPACE STATEMENT PARTITION ERRORS
PH49882
9_Dec
2022
UI83666
UI90197


"UNEXPECTED <SELECT> SYNTAX IN THE WITH CLAUSE" WHEN FULLSELECT CONTAINS VALUES CLAUSE
PH46375
9_Dec
2022
UI83662


ADMIN TOOL: DDL GENERATION WITH MASK IS NOT GENERATING DDL
PH47743
9_Dec
2022
UI83655
UI91593


ADMIN TOOL ERROR CONDITION RAISED DURING DET COMMAND ON PACKAGE
PH48741
9_Dec
2022
UI83660
UI90197


ADMIN TOOL: ERRONEOUS ADB5256I MESSAGE WHEN CALL TO SYSPROC.ADMIN_INFO_SSID HAS FAILED
PH48906
9_Dec
2022
UI83650
UI83662


ADB2GEN PROGRAM FAILS WITH SYSTEM ABEND 0C4 REASON CODE 00000004
PH49390
9_Dec
2022
UI83668


ADB7350E ERROR - ADB2CMO DETECTED AN ONCODE CONDITION 451 IN ADD_V9_TABLE
PH50130
9_Dec
2022
UI83652


TCZ JOB ADBSETUP FAILS WITH -20008, ERROR: ATTEMPT TO USE UNSUPPORTED FEATURE 'CREATE IN NON-UTS'. REASON CODE: 8
PH50194
9_Dec
2022
UI83658


DB2 ADMIN TOOL FAILS TO ADD HISTORY TABLE TO ACCELERATOR V7.5.7
PH47258
16_Nov
2022
UI82696
UI82698
UI83662


OBJECT COMPARE ATTEMPTS TO EXPLICITLY CREATE AN IMPLICITLY CREATED AUX TABLE
PH47295
16_Nov
2022
UI82698
UI83662


OBJECT COMPARE: DB2_GENERATED_DOCID_FOR_XML IMPLICIT COLUMN NOT BEING IGNORED
PH47699
16_Nov
2022
UI83322
UI83662
UI90197


MISSING REBUILD CAUSING ERROR ON CHECK DATA STATEMENT
PH48355
16_Nov
2022
UI83314


ADMIN TOOL: SM (SPACE MANAGEMENT) FOR INDEX OF AN ARCHIVE TABLE IN ADMIN TOOL DOES NOT WORK.
PH47830
16_Nov
2022
UI83316
UI83662


DDL COMMAND ON A STORED PROCEDURE RESULTS IN PARSER ERRORS WHEN STORED PROCEDURE HAD NON-BUILT-IN DATA TYPE DECLARE WITH
DEFAULT
PH48474
16_Nov
2022
UI83312


ADMIN TOOL: DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD FETCH - FROM PANEL ADB21KD (PACKAGE DEPENDENCIES)
PH48626
16_Nov
2022
UI83320


ADMIN TOOL LOOPING BETWEEN SCREENS ON PANEL ADB26COV ("ALTER STORED PROCEDURE")
PH49958
16_Nov
2022
UI83318


WHEN AO IS SELECTED ON PANEL ADB21, END RETURNS TO PANEL ADB2 WHEREAS USERS WERE EXPECTING END TO RETURN TO PANEL ADB21
PH50651
8_Nov
2022
UI83174


SUPPORT FOR LASTLOG REORG KEYWORD
PH49601
1_Nov
2022
UI83087
UI83662
UI83974
UI90197
PH51453

IGNORING CHANGES BETWEEN V12 AND MIGRATED PRE V12 OBJECTS
PH47791
21_Oct
2022
UI82971
UI83662


ADMIN TOOL: ADDING A COLUMN TO A TABLE DOES NOT RECREATE ALL DEPENDENT VIEWS
PH48332
21_Oct
2022
UI82961


ADMIN TOOL: GEN IS MISSING 'DATABASE NAME' FIELD
PH48690
21_Oct
2022
UI82967


DB2 ADMIN TOOL: COMMAND CLREST ABENDS WITH E37 REASON CODE 4 WHEN CREATING DATASET FOR DBRM BACKUPS
PH49959
21_Oct
2022
UI82965


MISSING REORG SHRLVEL FOR AN ALT INDEX BUFFERPOOL CAUSES AREOR STATE
PH47804
21_Oct
2022
UI82969


OBJECT COMPARE SHOULD NOT REPORT PATHSCHEMAS CHANGE
PH48246
21_Oct
2022
UI82973
UI83662
UI90197


ABSTRACT: OBJECT COMPARE - ACCELERATED TABLES REPLICATION AND ACCELERATION STATUS ARE OVERRIDDEN INSTEAD OF RESTORED
PH48416
21_Oct
2022
UI82963


ADMIN TOOL: ERROR RUNNING ADB2DIP (DROP IMPACT) WHEN ACCELERATOR-ONLY TABLE IS PRESENT
PH49637
13_Oct
2022
UI82832


NEW ADMIN ALTER STATEMENT INSERT COLUMN AFTER
PH48215
3_Oct
2022
UI82692
UI82694
UI82832


WHEN RUNNING A CHANGE, THE TABLE SPACE IS STARTED TWICE, EVEN BEFORE THE UNIQUE INDEX HAS BEEN CREATED.
PH48419
3_Oct
2022
UI82686


ADMIN TOOL - VERSION GENERATED BY GOCCM INCOMPLETE AND CANNOT BE USED TO GENERATE DDL
PH49221
3_Oct
2022
UI82690
UI82832


ADMIN TOOL - DDL COMMAND ON INDEX NOT SHOWING PARTITION DSSIZES 22/09/20 PTF
PECHANGE
PH46937
3_Oct
2022
UI82684
UI91949


ADMIN TOOL: MOVETB LINE COMMAND GENERATES INCORRECT UTLREC DATASET NAME
PH47927
3_Oct
2022
UI82682


DB2 ADMIN TOOL RESOURCE LIMIT PANEL ADB2Z2RS MUST NOT ALLOW LINE COMMAND U (UPDATE) TO UPDATE A ROW WITH PLAN NAME.
PH48023
3_Oct
2022
UI82694
UI82832


DB2 ADMIN TOOL: ALTER RENAME COLUMN FAILS FOR TABLE WITH CLONE
PH48179
3_Oct
2022
UI82688


DB2 ADMIN TOOL: S522 OR S414 ABEND IN ADBTEP2
PH42549
27_Sep
2022
UI82572


EXTENDING SPACE ESTIMATION CAPABILITY
PH49639
27_Sep
2022
UI82573


CHANGE REORG SHRLEVEL DEFAULT TO CHANGE
PH46803
12_Sep
2022
UI82373


AOC: ADB2RE CALL TERMINATES EARLY IF SEMICOLONS ARE MISSING FROMTHE END OF PARAMETERS OR IF DB2REL IS NOT SPECIFIED.
PH46599
12_Sep
2022
UI82372


DB2 ADMIN TOOL MISSING SUPPORT FOR IGNORE FOR FIELD CREATEDTS IN SYSIBM.SYSKEYS
PH46973
9_Sep
2022
UI82353
UI82372


OBJECT COMPARE REPORT - ERROR MESSAGE ADB8067E IN MERGE VERSION FILES SECTION
PH46980
9_Sep
2022
UI82352
UI82573


ADMIN START FOR TABLE COMMAND IS GENERATED AT THE END OF WSL FILE AFTER THE DROP DATABASE STATEMENT.
PH46331
9_Sep
2022
UI82351


DB2 ADMIN TOOL - HELP TEXT AND MESSAGE NEEDED FOR OPTION TU (SPECIFY TEMPLATE USAGE) LINE COMMANDS
PH46653
9_Sep
2022
UI82354


USING "RL" OPTION ((REFERENTIAL CONSTRAINT) IS NOT WORKING CORRECTLY IN PANEL ADBPC7L ("CM-EXCLUDE OBJECTS")
PH48830
9_Sep
2022
UI82350


WHEN USING THE ALT/TS OPTION MAKEPBR ON PANEL ADB21SAR TO CONVERT TO UTS PBR AND INCREASE/DECREASE NUMPARTS, THE LIMITKEYS
PANEL
PH48016
31_Aug
2022
UI82192
UI82372


SUPPORT FOR COMPARE SMART REORG GENERATION
PH45856
18_Aug
2022
UI82009
UI82372


OBJECT COMPARE INCORRECTLY REPORTS CHANGES TO COMPRESS ATTRIBUTE
PH46574
18_Aug
2022
UI82005
UI82372


OBJECT COMPARE : SYSPRINT SHOWS INCORRECT VERSION DETAILS VIA DDL TO DDL COMPARE
PH47008
18_Aug
2022
UI82010


ADMIN TOOL: WHEN USING BH LINE COMMAND ON PANEL ADBPZRP, THE DATA INSERTED INTO HISTORY TABLE IS TRUNCATED
PH47060
18_Aug
2022
UI82008
UI82372


ADMIN TOOL: GEN SHOWS INCORR DDL WHEN PARM "INCLUDING DB2 PENDING CHANGES" IS Y AND THE PENDING CHG IS A DROP COLUMN
PH47164
18_Aug
2022
UI82003
UI82372


OBJECT COMPARE GENERATING IBM0421S ONCODE 520 AND IBM0441W ONCODE 150
PH46022
18_Aug
2022
UI82007


MOVETB LINE COMMAND GENERATES INCORRECT REORG UTILITY CONTROL STATEMENT
PH46616
18_Aug
2022
UI82004
UI83662


DB2 ADMIN TOOL UNLOAD FROM IMAGE COPY UNBALANCED PARENTHESES ERROR
PH46941
18_Aug
2022
UI82006
UI82372


OBJECT COMPARE REPORT DOES NOT INDICATE WHEN A STOP INDEX IS ISSUED.
PH47028
15_Aug
2022
UI81939
UI82006
UI82372


SQLCODE -625 WHEN ADDING A COLUMN TO AN INDEX AND PRIMARY KEY ONA TABLE
PH48327
15_Aug
2022
UI81938
UI82353
UI82372


ONCODE=350 FROM ENTRY POINT CONVERT_LIMITKEY AT STATEMENT 30372
PH45487
28_Jul
2022
UI81697
UI82373


GEN FAILS WITH ONCODE 340 WHEN FORMATTING DBCS COMMENT - SIZE AND TRUNCATION ISSUES OCCUR
PH45872
28_Jul
2022
UI81696
UI90380


DB2 AOC: WSL EDITOR LINE COMMAND PROBLEMS WITH LARGE DDL OBJECTS GREATER THAN 32704 CHARACTERS
PH45588
28_Jul
2022
UI81695
UI82352
UI82573


GENERATING APPLY JOBS RESULTS IN ADBGAJOB ERROR RC=12 WHEN ADDING INLINE REORG
PH45611
28_Jul
2022
UI81693
UI83316
UI83662


PARSER FAILURE WHEN PROCESSING TRIM FORMAT
PH45652
28_Jul
2022
UI81694
UI82192
UI82372


OBJECT COMPARE - INCORRECT COLUMN ORDERING WHEN INSERTING AND DROPPING COLUMNS
PH45751
28_Jul
2022
UI81692


USING WORK STATEMENT LISTS FOR LOAD PROCESS VIA DB2 ADMIN TOOL OMITS LOADS CONTAINING 0 RECORDS IN THE LOAD SUMMARY REPORT
PH47259
14_Jul
2022
UI81477
UI90761


IMPROVE USABILITY OF REST SERVICE PANEL ADB21RS
PH45301
14_Jul
2022
UI81481


GENERATING UNLOAD ON A TABLE VIA U.UL COMMAND RESULTS IN SECONDARY EXTENT SPACE PARAMETER THAT IS TOO LARGE
PH45607
14_Jul
2022
UI81479


ADB2GEN RC=12 SQLCODE -811 WHEN ACCELERATOR-ONLY TABLE IS DEFINED FOR HIGH AVAILABILITY.
PH46360
14_Jul
2022
UI81475


ADMIN TOOL REST SERVICE - B AND CRE LINE COMMANDS DO NOT WORK WITH LOWER CASE LETTERS
PH46858
14_Jul
2022
UI81483


ISSUE 1: WHEN DB2 LIBRARIES ARE NOT SPECIFIED ON DB2 PARAMETERS PANEL CCQPDB2 BECAUSE THE DB2 LIBRARIES ARE USED FROM
LINKLIST,
PH44688
30_Jun
2022
UI81262


ANALYZE AND RUN MTC CHANGES FOR TARGET SYSTEMS WHILE ON THE CENTRAL SYSTEM
PH47478
30_Jun
2022
UI81260


ADD OPTION FOR UNLOAD ALTERED TABLES TO ONLY UNLOAD DESTRUCTIVE ALTERS
PH44947
21_Jun
2022
UI81113
UI83662


OBJECT COMPARE: STRINGSIZE CONDITION WITH ERROR: " ONCODE()=" 150"
PH45383
21_Jun
2022
UI81114


ERRORS IN THE ALTER TRUSTED CONTEXTS PANEL ADB26CN
PH45540
21_Jun
2022
UI81116


CONVERTED WSL FILE IS NOT CREATED
PH45170
21_Jun
2022
UI81117


AN ALTER PARTITION FOR A PAGENUM RELATIVE TABLESPACE WITH 256 PARTS FAILS WHEN TRYING TO ADD 257TH PART
PH45445
21_Jun
2022
UI81112


DB2 ADMIN TOOLS SADBEXEC IN VB PRODUCES ERROR
PH46530
21_Jun
2022
UI81115


GOCCCM ENDS CC 04 WHEN THE SOURCE DDL HAS CREATE AUX TB ONLY
PH46252
7_Jun
2022
UI80925
UI81695
UI82352
UI82573


REORG TABLESPACE ON THE SECOND OBJECT FAILS WITH RC=0008 DUE TO CHECK PENDING 22/05/12 PTF
PECHANGE
PH43865
5_May
2022
UI80431
UI80433


CHANGE MANAGEMENT APPLY: DIALOG ERROR ISPV006 OCCURS WHEN CHANGEID IS MORE THAN 4 DIGITS
PH42871
5_May
2022
UI80433


REMOVING PARTITION(S) USING ALT LINE COMMAND FAILS
PH44269
5_May
2022
UI80430


DROP REPORT IMPACT INCOMPLETE - NOT SHOWING DEPENDENT FUNCTION
PH44466
5_May
2022
UI80428
UI80433


DEPENDEND PACKAGES NOT REBOUND WHEN DROP ALIAS/CREATE ALIAS
PH44608
5_May
2022
UI80426
UI81693
UI83316
UI83662


DB2 ADMIN TOOL: "ALL' NOT HANDLED BY PARSER WHEN USED AS A QUALIFIER IN CREATE VIEW STATEMENT
PH44610
5_May
2022
UI80424


DB2 ADMIN: SQLCODE = -122 OCCURS WHEN CMD MIGRI OR LINE CMDS ADDRI, ADDHIS, ADDARC ARE USED ON PANEL ADB28T 'MIGRATE
TABLE'
PH44828
5_May
2022
UI80432


AOC CM: &CHGTAG IS NOT SET CORRECTLY IN WSL CM BATCH JCL FOR ADBTEMPL TEMPLATES
PH44864
5_May
2022
UI80425
UI80426
UI81693
UI83316
UI83662


DB2 AOC: SYSTIMESTAMP NOT SUPPORTED AS SPECIAL REGISTER
PH44937
5_May
2022
UI80429
UI81697
UI82373


DB2 ADMIN: MISSING DATE / TIME FORMAT IN STORED PROCEDURE DDL GENERATION
PH42750
15_Apr
2022
UI80172


EXCLUDE OF STORED PROCEDURE IN OBJECT COMPARE NOT HONORED IF SCHEMA OF SP ADDED TO SOURCE
PH43820
15_Apr
2022
UI80173
UI80432
UI80925
UI81695
UI82352
UI82573
PH46252

CONVERSION OF VARCHAR TO CLOB USING DB2 ADMINISTRATION TOOL DOESN'T CLEAR COPY PENDING IN LOB TABLE SPACE
PH44696
15_Apr
2022
UI80171
UI81477
UI90761


DB2 AOC: PANEL ADB21RS COLLECTION ID FIELD IS TOO SHORT
PH44766
15_Apr
2022
UI80170


ADDING PARTS. FOR A PAGENUM RELATIVE PART. TABLESPACE VIA "ADD/ INSERT/ALTER PARTITION" DOES NOT ALLOW ADDING A NEW PART >256
PH42024
15_Apr
2022
UI80174


OBJECT COMPARE MAY ATTEMPT TO ADD SECOND TABLE TO UNIVERSAL TABLE SPACE (UTS)
PH42940
15_Apr
2022
UI80169
UI80433
UI82690
UI82832
PH49221

DDL LINE COMMAND GENERATES SYNTACTICALLY INCORRECT DDL FOR INDEXWITH DSSIZE AND BUSINESS_TIME
PH43175
15_Apr
2022
UI80176


ABEND0C4 OR ABENDU4083 OCCURS RUNNING LINE COMMAND DET OR BET AGAINST A PACKAGE
PH36178
25_Mar
2022
UI79890
UI80174


CHOOSING M FOR REORG DOESN'T GENERATE REORG AFTER ALTER INDEX CAUSING AREOR STATE; REORG STILL GENERATED FOR INDEX
BUFFERPOOL CH
PH42485
25_Mar
2022
UI79884


INCORRECT DEFER PREPARE INFORMATION ON PANEL ADB21KI1
PH42556
25_Mar
2022
UI79886


MULTIPLE ISSUES GENERATED BY PANEL ADB21T LINE COMMAND 'I' TO INTERPRET SYSTABLE USAGE OF SYSACCELERATEDTABLES
PH43112
25_Mar
2022
UI79883
UI81260


HELP PANEL ADBHPCO EXPLANATION OF CHANGE OPTION PRESERVE_ALL_DATA MISSING IMPORTANT DETAILS
PH43274
25_Mar
2022
UI79887
UI79890
UI80174


ERROR SQLCODE -20181 WHEN ADDING COLUMN TO INDEX CONTAINING INCLUDE CLAUSE
PH42301
25_Mar
2022
UI79888


ADD NEW OPTION UNIQUE-VERSION TO BIND AVOIDANCE PROGRAM ADBBMA3
PH42937
25_Mar
2022
UI79885
UI80433


ALTER "INTEGER WITH DEFAULT 1" TO "WITH DEFAULT NULL" GENERATES DROP/RECREATE IN CHANGE MANAGEMENT WHEN ALTER POSSIBLE
PH42961
25_Mar
2022
UI79889
UI80174


OBJECT COMPARE DDL-TO-DDL ADD VERSIONING STATEMENT RESULTS IN ONCODE 520 COMPARE_TABLES
PH44658
25_Mar
2022
UI79882
UI91593


DEP AND T LINE COMMANDS NOT WORKING 22/03/17 PTF
PECHANGE
PH41400
3_Mar
2022
UI79563
UI80173
UI80432
UI80925
UI81695
UI82352
UI82573
PH46252

ALTER XML TS GENERATES UNNECESSARY REORG FOR BASE TS
PH42590
3_Mar
2022
UI79566


ADB9013E "SCOPE . NOT FOUND" ERROR WHEN TRYING TO GENERATE VERSION FILE FROM SOURCE SET AS VERSION SCOPE
PH42637
3_Mar
2022
UI79562
UI80433


OBJECT COMPARE ONCODE=340 IN REGISTER_PARTINFO
PH41598
3_Mar
2022
UI79565
UI83662


OBJECT COMPARE VALIDATE SQLCODE = -104 DUE TO MISSING #SET TERMINATOR STATEMENT; COMPARE & VALIDATE REPORTS INCONSISTENT
PH42627
3_Mar
2022
UI79564
UI79889
UI80174


OBJECT COMPARE INCORRECTLY GENERATES DROP/CREATE INSTEAD OF ALTER WHEN CHANGING SET DEFAULT VALUE NON-LOB COLUMN ADB7145I
PH41576
14_Feb
2022
UI79296


DISPLAY UTILITY UTILID LOWER CASE LETTERS PANEL ADB2Z2U2 DSN112I NO AUTHORIZED UTILITY FOUND FOR UTILID
PH42195
14_Feb
2022
UI79302
UI79563
UI80173
UI80432
UI80925
UI81695
UI82352
UI82573
PH46252

ADD START DB RW PRIOR TO REORG IN WSL TO MAKE TABLES AVAILABLE SOONER AFTER CHANGES
PH42270
14_Feb
2022
UI79298


ALT CONVERT COLUMN TO IDENTITY MISSING "START WITH" VALUE ADB2PA PARSE ERROR ADB9755E ONCODE = 612 MSG7954
PH43358
14_Feb
2022
UI79301
UI79885
UI80433


OBJECT COMPARE GENERATES CREATE UNIQUE INDEX STATEMENT MISSING 'ENDING AT' CLAUSE FOR PARTITIONS SQLCODE = -660
PH43838
14_Feb
2022
UI79295
UI79297
UI79565
UI83662


MISSING SET TERMINATOR FOR CREATE TRIGGER WHEN COMPARE CREATES BOTH BASIC AND ADVANCED TRIGGERS
PH41745
14_Feb
2022
UI79294


"I" LINE COMMAND INDEX WITH LOW CLUSTERRATIO CLUSTERING RATIO 0: NO STATS MISLEADING AND INCORRECT
PH42005
14_Feb
2022
UI79299
UI80433


RENAMETB DOES NOT WORK CORRECTLY WHEN WILDCARDS USED TO QUALIFY HISTORY TABLES
PH42066
14_Feb
2022
UI79300
UI79564
UI79889
UI80174


OBJECT COMPARE FAILS WITH ADB7383E WHEN CHANGING PARTITIONING KEY
PH42284
14_Feb
2022
UI79297
UI79565
UI83662


MISSING ALTER TO DISABLE ARCHIVE ON TABLE BEFORE DROPPING TABLESPACE RETURNS SQLCODE = -478
PH43570
14_Feb
2022
UI79303
UI83662


DB2 OBJECT COMPARISON TOOL JOB ENDS WITH RC=12 ONCODE 451 CHECK_ALLOC
PH41530
21_Jan
2022
UI79008


ADB398E ISSUED TO INDICATE SPECIFIED TS NOT UNICODE WHEN CREATING A PLAN_TABLE WITH TS DEFINED AS UNICODE
PH42836
21_Jan
2022
UI79011


DB2 ADMIN TOOL: 'DDL' LINE COMMAND FAILS SYNTAX ERRORS ADB2GEN.REXX WHEN SADBEXEC.VB USED 22/01/10 PTF
PEREMOVE
PH41451
21_Jan
2022
UI79012


DB2 ADMIN TOOL PANEL ADB21F COMMAND DPK DOESN'T WORK IF SPECIFIC NAME DIFFERENT THAN FUNCTION NAME.
PH40516
20_Jan
2022
UI77884


INCREASE NAME FIELD TO 18 CHARS ON PANELS ADB2ARL AND ADB2AN; IKJ56584I ADBRPGM NOT FOUND EXECUTING 'TSO ADBEDIAG REPORT'
PH41150
20_Jan
2022
UI78998
UI80433


REORG WITH ALTER TABLE ADD COLUMN SHOULD BE GENERATED WITHOUT PROFILE STATS
PH41191
20_Jan
2022
UI78999
UI83655
UI91593


PANEL ADB21K DET/BET ON PACKAGE DOES NOT DISPLAY ALL EXPLAIN INFO; PERFORMANCE IMPROVEMENTS FOR PACKAGES WITH MANY QUERIES
PH41286
20_Jan
2022
UI79001
UI83662


CM MASKED IMPORT WITH "SET CURRENT PATH" GREATER THAN 78 CHARACTERS ONCODE150 ADB9409E
PH41486
20_Jan
2022
UI78994


AL LINE COMMAND PANEL ADB21TA ALTER TABLE CHANGING ATTRIBUTE TWICE DOES NOT PROCESS SECOND CHANGE SQLCODE = -601
PH41681
20_Jan
2022
UI78996
UI82684
UI91949


MOVETB LINE COMMAND GENERATES REORG STATEMENT WITHOUT MAPPING TABLE FOR MULTI-TABLE TABLE SPACES
PH41293
20_Jan
2022
UI78997
UI83662


ALT DOES WRONG CONVERSION FOR ZERO INTEGER TO CHAR(35)
PH41533
20_Jan
2022
UI78995
UI79303
UI83662


GEN: ERROR GENERATING DDL VIEW "MISSING <SELECT-LIST> OR * AFTER SELECT" ADB2PA STATEMENT COULD NOT BE PARSED
PH42193
20_Jan
2022
UI79000
UI80174


OBJECT COMPARE PBG SEGMENTED TABLESPACES ERRORS ADB7955E ADB1664E
PH42874
20_Jan
2022
UI78993


CRE LINE COMMAND CREATE REST SERVICE PANEL ADB21RS ISPF DIALOG ERROR: DATA ID SPECIFIED IN EDIT OR VIEW SERVICE IS
UNDEFINED
PH42870
29_Dec
2021
UI78768


ONCODE=350 WITH LOOP IN COMPARE 21/12/16 PTF
PECHANGE
PH43052
29_Dec
2021
UI78769
UI81262

HIPER

INVALID VARIABLE NAME ERROR DURING TCZ EXECUTION 21/12/29 PTF
PECHANGE
PH40534
16_Dec
2021
UI78598
UI80174


DB2 OBJECT COMPARE WSL SQLCODE = -625 / SQLCODEN625 ADDING PK TOTABLE W/ NEW COLUMN BEFORE COLUMN ADDED TO INDEX
PH40552
16_Dec
2021
UI78597
UI79882
UI91593
PH44658

DUPLICATE ASSOCIATED OBJECTS LIST ON PANEL WHEN LINE COMMAND EXECUTED ON ADB21K AFTER PACKAGE REBOUND W/
PLANMGMT(EXTENDED)
PH41018
16_Dec
2021
UI78596
UI78997
UI83662


INVALID KEYWORD DSN_NULL_IND_000xx ON LOAD FOLLOWING UNLOAD SPANNED YES NOPAD ROWID
PH41128
16_Dec
2021
UI78592
UI80430


GEN IN TSO MODE ON CATALOG COPY FAILS AND DOES NOT GENERATE DDL WHEN REBIND = N
PH42075
16_Dec
2021
UI78593
UI78768


DB2 ADMIN TOOL CHANGE MANAGEMENT ADB5146E UNEXPECTED SQLCODE -913 IN :DELETE ADBDBETLIST
PH42322
16_Dec
2021
UI78599


SUPPORT FOR NEW DB2 ZPARMS
PH39367
16_Dec
2021
UI78595
UI78768


OBJECT COMPARE SET CURRENT SQLID AND SCHEMA STATEMENTS FOUND IN CHANGE FILE EVEN THOUGH NO OBJECT CHANGES EXIST
PH40454
16_Dec
2021
UI78591


SEARCH DOES NOT FIND LOWER CASE 'NEW ID' NAMES PANEL ADB2Z55
PH40458
16_Dec
2021
UI78594


ALLOW 'A' AND 'ALT' TO BE USED INTERCHANGEABLY ON PANEL ADB27CA FOR LINE COMMAND 'A - ALTER OBJECT'
PH42319
16_Dec
2021
UI78589


ISSUES ON PANEL ADBPMSPI AND HELP PANEL ADBHMSPI SPECIFYING NULL VALUE CALLING STORED PROCEDURE
PH37342
9_Dec
2021
UI78483


SUPPORT FOR MISSING DB2 UTILITY OPTIONS (PHASE #3) : REORG INDEXAND RECOVER UTILITIES
PH42324
2_Dec
2021
UI78376
UI78768
PH42870

INSERT PARTITION FAILURE RELATED TO AUX, HISTORY AND ARCHIVE TABLES
PH39146
19_Nov
2021
UI78181


HELP PANEL ADBHP2 GET DB2 ZPARM REPLACE DSNWZP WITH ADMIN_INFO_SYSPARM;COMPARE CLARIFY REASON NO ROWID CHANGE
PH39501
19_Nov
2021
UI78180
UI78996
UI82684
UI91949


TEMPLATE SCOPY MAY HAVE EMPTY DATA SET NAME FOR REORG
PH40510
19_Nov
2021
UI78182


ALT UPDATE IDENTITY COLUMN RESULTS IN 'NO CHANGE' MESSAGE PANEL ADB27CA
PH36794
19_Nov
2021
UI78186
UI78376
UI78768
PH42870

MASKED STOGROUP ANALYZE/COMPARE PROCESSING ERROR ADB7184E ADB7955E
PH38797
19_Nov
2021
UI78183
UI80433


ANALYZE EXCLUDES DROP SYNONYM OF VIEW FROM WSL
PH39168
19_Nov
2021
UI78178
UI81262


CM BATCH GENERATED RUN JOB JCL ERROR IEFC009I WITH CLASS INCLUDED IN JOB_CARD_LINE_X PARM
PH39224
19_Nov
2021
UI78185
UI78376
UI78768
PH42870

ADBTEP2 MAY TREAT RELATED DB2 UTILITY STATEMENTS AS INDEPENDENT AND IGNORE OPTIONS
PH39934
19_Nov
2021
UI78184
UI78376
UI78768
PH42870

CM ANALYZE INCLUDING TRIGGERS ADB7105E SUBSTR OUTSIDE STRING INTERNAL ERROR ADB7380E
PH39937
19_Nov
2021
UI78179
UI78181


GENERATE REORG FOR ALTER KEY LABEL REORG OPTION 'M'
PH40738
19_Nov
2021
UI78177


ALT TABLE SPACE MESSAGING IMPROVEMENTS ADB21SAR DSSIZE PQTY SQTY ADB27RDR DROP RESTRICT
PH41894
12_Nov
2021
UI78054


ADD SCOPE FUNCTION TO MIG
PH39764
1_Nov
2021
UI77891
UI77893
UI83662


DB2_GENERATED_ROWID_FOR_LOBS COLUMN SHOULD NOT BE INCLUDED IN COMPARE
PH34099
1_Nov
2021
UI77892


MISSING GRANTS FOR VIEW RENAMED VIA ALT
PH38504
1_Nov
2021
UI77889
UI80174


OBJECT COMPARE ERROR ADB7383E ERROR PROCESSING SPECIFIED LIMIT KEY USING IGNORE SYSCOLUMNS:COLTYPE
PH38535
1_Nov
2021
UI77890


GEN: MISSING COMMENTS IN SQL FUNCTIONS
PH38974
1_Nov
2021
UI77893
UI83662


CORRECT PROCESSING ORDER WHEN ALTERING A TABLE ON AN ACCELERATOR
PH39899
1_Nov
2021
UI77888


REPORT INDICATES 'NO CHANGES TO TRIGGER' EVEN THOUGH TRIGGER IS DEPENDENT ON A VIEW THAT WILL BE DROPPED AND RECREATED
PH40337
1_Nov
2021
UI77887


PANEL ADB21TSE RESET COMMAND DOES NOT RESET WHERE CLAUSE FROM SEL LINE COMMAND PERFORMED EARLIER
PH40371
1_Nov
2021
UI77886
UI78054


ADMIN TOOL MIGRATE SOURCE JOB STEPLIB UNNECESSARY SADBLINK; MIGRATE JOBS SHOW LIB= EVEN WITH "USE DSNUPROC LIB=" SET TO
"NO"
PH37080
20_Oct
2021
UI76599
UI76601
UI78596
UI78997
UI83662


DB2 ADMIN TOOL: CHANGE FROM TIMESTAMP (12) TO TIMESTAMP (6) - RELOAD DSNU310I CONVERSION ERROR ERROR CODE 14
PH37341
20_Oct
2021
UI77730
PH43052

SUPPORT FOR MISSING DB2 UTILITY OPTIONS (PHASE 2)
PH38604
8_Oct
2021
UI77516
UI78178
UI81262


CM BATCH COMPARE INCOMPATIBLE OPTIONS WITH TARGET_TYPE = 'AUTO' NOT CHECKED; MESSAGE ADB9757E ENHANCED
PH38495
7_Oct
2021
UI77496
UI77498
UI80433
UI83662


MESSAGE ADB7382S MAY CONTAIN GARBLED TEXT
PH38513
7_Oct
2021
UI77495
UI78999
UI83655
UI91593


IBM0441W The STRINGSIZE condition was raised during DET command with ACCESSTYPE = RW explain data
PH39531
7_Oct
2021
UI77494
UI82354


EXCLUDE OBJECTS MAY NOT BE SAVED ON PANEL ADBPC7L
PH40469
7_Oct
2021
UI77491
UI77892


ALT UPDATE COLUMN ADD OBJECT ALTER ADB27CA SQLCODE = -206 / SQLCODEN206 SP.FORMAT NOT VALID CONTEXT USED
PH40604
7_Oct
2021
UI77498
UI80433
UI83662


CMBATCH FAILS WITH RC=8 ADB7211E MESSAGE TO CONVERT PBR RPN TO PBR
PH38198
7_Oct
2021
UI77492


LIST EXCLUDED OBJECTS ADBPRINT IN SAME ORDER AS ON PANEL ADBPC7L
PH39947
7_Oct
2021
UI77490
UI79001
UI83662


GEN/DDL VIEW XMLEXISTS CLAUSE TRUNCATED
PH40662
7_Oct
2021
UI77493
UI77890


GEN/DDL NOT FORMATTING LARGE CHECK CONSTRAINTS CORRECTLY
PH41042
7_Oct
2021
UI77499
UI77893
UI83662


COMPARE GETS INVALID TRIGGER DDL
PH31556
28_Sep
2021
UI77358


SUPPORT MISSING DB2 V12 TABLESPACE AND INDEX ATTRIBUTES
PH31960
28_Sep
2021
UI77354


DB2 ADMIN TOOL PACKAGE CLEANUP PROGRAM NEW CLREST COMMAND RESTORE FREED PACKAGES
PH40074
28_Sep
2021
UI77357


SUPPORT FOR MISSING DB2 12 ZPARMS
PH40076
28_Sep
2021
UI77359


SUPPORT ADDITIONAL CREATE TABLE CLAUSES FOR IMPLICIT TABLESPACES
PH38429
17_Sep
2021
UI77209
UI77358


GEN: DB2_GENERATED_ROWID_FOR_LOBS MISSING IN 'PARTITION BY' CLAUSE
PH38494
17_Sep
2021
UI77210


DB2 UTILITY STATEMENT INCLUDES UNNECESSARY DEFAULT SORTNUM KEYWORD
PH39039
17_Sep
2021
UI77211


DB2 OBJECT COMPARE VALIDATE ADB3018E WHEN CONSTRAINT DEFINED WITHOUT CONSTRAINT KEYWORD 21/08/19 PTF
PECHANGE
PH39472
17_Sep
2021
UI77203
UI77730
PH43052

DB2 OBJECT COMPARISON TOOL ISPD014 ADBGAJOB NOVALUE CONDITION VARIABLE NAME TABLESPACE PARTITION CHANGE TABLE EXCLUDED
PH39864
17_Sep
2021
UI77204


PANEL ADB2ZBH2 COLUMN "SEQUENTIAL PAGES READ" TRUNCATED IF GREATER THAN 8 CHARACTERS; COLUMN "SEQ PREFETCH" INCORRECT
PH40031
17_Sep
2021
UI77205


INPUT FIELDS ON PANEL ADB21TCA ('ALTER TABLE ADD CLONE') DO NOT USE ALL AVAILABLE SPACE
PH36955
17_Sep
2021
UI77207


MESSAGE ADB9013E MISSING EXCLUDE NAME WHEN EXCLUDE DOES NOT EXIST
PH37095
17_Sep
2021
UI77208


DB2 ADMIN TOOL. MAKEPBR GENERATES A SYSREC DD WHEN THE REORG HAS NOSYSREC CODED.
PH38785
17_Sep
2021
UI77206
UI77358


CM BATCH INVALID DDL DATASET ISSUE ERROR MESSAGE INSTEAD OF ONLYIBM0121S ONCODE=21
PH39334
3_Sep
2021
UI77019


ALLOW FOR DROP OF FOREIGN KEYS IN COMPARE
PH37528
26_Aug
2021
UI76933
UI77359


DB2 ADMIN TOOL: GEN ADB2PA PARSER ERROR ON STRING UNIT SPECIFICATIONS: CODEUNITS32, CODEUNITS16, OCTETS
PH37652
26_Aug
2021
UI76935
UI77359


IMPROVE MESSAGE ADB6003E ADBALT ONCODE 9250 STORAGE CONSTRAINT
PH37364
26_Aug
2021
UI76937
UI77019


CM BATCH ALTER TABLESPACE ALTER ADD COLUMN RUN TIME ERROR SQLCODE = -20385
PH37438
26_Aug
2021
UI76936
UI77019


WHEN TRANSFERRING OWNERSHIP OF TABLE AND ALTERING/APPENDING PARTITIONS IN SAME COMPARE, CHG FILE MAY BE INCORRECT
PH37406
26_Aug
2021
UI76938


DB2 ADMIN TOOL: PANELS ADB21RS ADB21KF REST SERVICE ISSUES FREE CREATE BIND VERSIONING
PH37874
26_Aug
2021
UI76934
UI78591


SEARCH FOR LOWER CASE USERNAME PASSWORD PANEL ADB2Z55 RESULTS INMESSAGE 'NO ROWS MATCH'
PH38852
26_Aug
2021
UI76932


RESET COMMAND PANEL ADB21TSE GENERATES CLAUSE "WHERE WHERE CREATOR LIKE '>SCHEMA<'"
PH39190
26_Aug
2021
UI76931
UI83318


RS REST SERVICES OPTION ON PANEL ADB21 NO ROWS RETURNED OR SQLCODE = -204 PANEL ADB21RS
PH37477
13_Aug
2021
UI76735


FIXES FOR VARIOUS DEFECTS 1H2021
PH39331
13_Aug
2021
UI76734


NEW COMMAND TO DISPLAY ONLY EXPLICITLY GRANTED AUTHORITIES ON AUTHORIZATION PANELS
PH36494
4_Aug
2021
UI76602
UI76735


ADDING VERSIONING TO TABLE NOT CLASSIFIED AS CHANGE
PH37191
4_Aug
2021
UI76597
UI77730
PH43052

DB2 ADMIN TOOL: ERROR GENERATING RECOVER JOB ON ALTER GIVES PANEL ERROR ISPN106
PH36936
4_Aug
2021
UI76598
UI76933
UI77359


GEN/DDL FUNCTION XMLTABLE XMLPARSE FUNCTION PARSE ERROR UNEXPECTED TOKEN...EXPECTED KEYWORD CORRELATION-NAME ADB2PA
PH37022
4_Aug
2021
UI76601
UI78596
UI78997
UI83662


ERROR ADB5184E DURING LOAD WHEN ROW CHANGE TIMESTAMP COLUMN CHANGED FROM GENERATED BY DEFAULT TO GENERATED ALWAYS
PH38103
30_Jul
2021
UI76538


ACCELERATED TABLES REPLICATION STATUS & ROW COUNT DISPLAY ENHANCEMENTS AND FIXES
PH36418
21_Jul
2021
UI76402


UPDATES TO CHANGE MANAGEMENT ANALYZE OPTIONS UNLOAD ALTERED TABLES AND RECREATE FOR NULLS CHANGE
PH35923
16_Jul
2021
UI76349


DB2 ADMIN TOOL INTERPRETATION ON PANEL ADB2ATI1 NEEDS UPDATING FOR AUTHORIZATIONS GRANTED TO PACKAGES
PH36231
16_Jul
2021
UI76351


WHEN USING ALT WITH CM, THE CM ENTRY SHOWS EXTRA SET CURRENT SQLID STATEMENTS
PH36588
16_Jul
2021
UI76348
UI76350
UI76352


INCORRECT DIFFERENCE IN DSSIZE REPORTED IN OBJECT COMPARE
PH35988
16_Jul
2021
UI76353


DB2 ADMIN TOOL: DSN NAME TOO LONG ERROR REORG USING SYSCOPY DEFAULT PANEL ADBPUSOC WHEN USING GDG
PH36514
16_Jul
2021
UI76346
UI76599
UI76601
UI78596
UI78997
UI83662


DATATYPE CHANGE DECIMAL TO VARCHAR LOAD FAILS INVALID HEXADECIMAL OPERAND - X' '
PH36943
16_Jul
2021
UI76347
UI76352


DB2 OBJECT COMPARE ALLOW IMPLICIT DROP EXCLUDED OBJECTS ADB7350E ADB2CMF ONCODE = 340 ADD_TGT_OBJECT
PH37554
16_Jul
2021
UI76350
UI76352


COMPARE WITH TARGET DDL AS SOURCE CAUSES COMPARE FAILURE ADB7955E DUE TO NON-EXISTENT DIFFERENCES
PH37926
16_Jul
2021
UI76352


PAGESET_PAGENUM ZPARM SUPPORT
PH30015
28_Jun
2021
UI76115
UI76352


COMPARE TABLESPACE WITH TABLE XML COLUMN DOES NOT GENERATE ALTER STATEMENTS FOR IMPLICIT XML TABLESPACE
PH34964
28_Jun
2021
UI76109
UI76114
UI76352


OBJECT COMPARE REPORTING DIFFERENCE WHEN USING DDL AS TARGET - LONG VARCHAR VS VARCHAR
PH34007
28_Jun
2021
UI76116
UI76402


DB2 ADMIN TOOL: THE DIAGNOSE TYPE(XXX) UTILITY CONTROL STATEMENTMAY NOT FUNCTION PROPERLY IN ADBTEP2
PH34909
28_Jun
2021
UI76110
UI76352


OBJECT COMPARE REPORT ISSUES DUPLICATE TABLESPACE PCTFREE CHANGED MESSAGES
PH34995
28_Jun
2021
UI76112


DB2 ADMIN TOOL: -204, ERROR: SESSION.TABLESINUNLOAD IS AN UNDEFINED NAME WHEN RUNNING A WSL
PH35158
28_Jun
2021
UI76114
UI76352


CREATING NEW INDEX ON HISTORY TABLE ALSO ADDS EXTRA ALTER TABLE <OWNER>.<TBNAME> ADD PRIMARY KEY SQLCODE = -624
PH38036
28_Jun
2021
UI76117
UI78054


DISPLAY OPTIONS SETTING - "HIDE DESCRIPTIONS" UNDER "SHOW LINE COMMANDS" INCORRECT LINE COMMAND LISTS DISPLAYED
PH36790
23_Jun
2021
UI76030


EXTENDED FL508 SUPPORT
PH35853
23_Jun
2021
UI76029


SUPPORT FOR MISSING DB2 UTILITY OPTIONS
PH34657
3_Jun
2021
UI75679
UI76598
UI76933
UI77359


DB2 ADMIN TOOL: PARSER ERROR DURING GEN/DDL COMMAND ON A VIEW REFERENCING COLUMNS NAMED CASE
PH34699
3_Jun
2021
UI75685
UI76029


ALT WSL GENERATED JCL MISSING DISP PARAMETER SPECIFIED IN USER-DEFINED TEMPLATE
PH34842
3_Jun
2021
UI75676
UI76030


DB2 OBJECT COMPARE: BASIC TRIGGERS WITH SYSTEM_TIME SENSITIVE, BUSINESS_TIME SENSITIVE, ARCHIVE SENSITIVE SET TO NO
PH35221
3_Jun
2021
UI75677
UI75686


CHANGE MANAGEMENT SAVES LOWER CASE STATEMENT AS UPPER WHEN REGISTERING CHANGE VIA PANEL ADB22 ('EXECUTE SQL STATEMENTS')
PH35250
3_Jun
2021
UI75686


Db2 Admin:Errors in MTC reg. may go unseen causing analyze issues/plus ANO/RNO line cmd receive ISPF errors
PH35261
3_Jun
2021
UI75678


DB2 ADMIN CM: ADBPC7L - LINE COMMAND R NOT WORKING WHEN ENTERED ON NON-COMMITTED LINE, GET BLANK LINE INSTEAD
PH33848
3_Jun
2021
UI75680


CATALOG COPY: LOAD STATEMENTS FOR TABLES MULTI-TABLE TABLE SPACE GENERATED WRONG ORDER CAUSING CATALOG COPY SIZE
INCREASE
PH34023
3_Jun
2021
UI75688
UI82572


DB2 ADMIN TOOL: SPACE MANAGER DOES NOT PROPERLY HANDLE TABLES WITH MORE THAN 1 BILLION ROWS
PH34565
3_Jun
2021
UI75687
UI76030


DB2 ADMIN TOOL: EXCESSIVE REORGS AFTER INDEX ALTERS
PH34921
3_Jun
2021
UI75684
UI76030


ALT DROP COLUMN TEMPORAL TABLE RUN REORG/REBIND = 'M' SQL ERROR -20385 ON RUN JOB
PH34970
3_Jun
2021
UI75683
UI76347
UI76352


DB2 ADMIN: DURING A COMPARE, EXPLICITLY DROPPING OBJECTS IN THE SRC DDL RESULTS IN ERRORS IN THE CHG FILE AND WSL
PH35165
3_Jun
2021
UI75681
UI83662


DB2 ADMIN: ADB7955E MESSAGE IN AUTHORIZATION SWITCHING DOES NOT DISPLAY VALID AND INVALID SERVER OR CPUID
PH36482
21_May
2021
UI75518


FL509 HIGH AVAILABILITY FOR IDAA AOTS
PH36485
21_May
2021
UI75519


FL509 OBJECT LEVEL COMPRESSION
PH37105
14_May
2021
UI75410
UI82373


IMPROVEMENTS FOR ADBGDDL
PH33411
13_May
2021
UI75385
UI75387


DB2 ADMIN TOOL - COMPARE DOING A DROP/CREATE OF INDEX INSTEAD OF ALTER INDEX FOR ADD COLUMN.
PH33609
13_May
2021
UI75387


DB2 ADMIN TOOL: GOC CM - DROP_PART PARAMETER GENERATED FOR REORGON PBR RESULTING IN DSNU073I
PH33944
13_May
2021
UI75378
UI82372


DB2 ADMIN TOOL: PACKAGE DET LINE COMMAND NOT SHOWING ALL SQL STATEMENTS
PH34877
13_May
2021
UI75373
UI75519


DB2 ADMIN TOOL: XML COMMAND AGAINST ARCHIVE OR HISTORY TABLE NOTSUPPORTED ON PANEL ADB21T
PH33176
13_May
2021
UI75383
UI75519


DB2 ADMIN TOOL: ADB1933E PARSER ERROR ON LEFT OUTER TO ONE JOIN CLAUSE
PH33319
13_May
2021
UI75382
UI75383
UI75519


DB2 OBJECT COMPARE DBNAME MASK DROP TABLESPACE CHANGE FILE EMPTY
PH33332
13_May
2021
UI75376
UI75383
UI75519


GEN DDL STORED PROCEDURE PARSE ERROR ASC DESC KEYWORD XMLAGG ADB7955E ADB2PA ADB1932W REASON CODE = 28
PH33999
13_May
2021
UI75375
UI77887


DB2 ADMIN TOOL: PANEL ADB21TSR - RESET PROTOTYPE - CURSOR SHOULDSKIP TO NEXT FIELD
PH34162
13_May
2021
UI75381
UI75383
UI75519


DB2 ADMIN TOOL: DURING A COMPARE, DDL FOR ALTER ADD COLUMN AND CREATE INDEX GENERATED IN WRONG ORDER
PH34388
13_May
2021
UI75384
UI75386
UI75519


OBJECT COMPARE ADB7350E IBM0342S ONCODE = 340 REGISTER_PARTINFO ONCODE = 9050 PREPARE_BASE
PH35114
13_May
2021
UI75386
UI75519


DB2 ADMIN TOOL: CM ANALYZE FAILS WHEN APPENDING PARTITIONS
PH36827
13_May
2021
UI75388
UI75519


STA DB COMMAND ISSUED AFTER TS IS ALREADY DROPPED
PH33320
5_May
2021
UI75243
UI75383
UI75519


DB2 ADMIN TOOL - ADB8067E ALTER INCONSISTENCY ERROR WHEN REDUCING PARTITIONS
PH36481
5_May
2021
UI75241


SUPPORT FL509 TAMPER-PROOF AUDIT POLICY
PH36687
5_May
2021
UI75242


CREATE NATIVE REST API SUPPORT
PH33058
26_Apr
2021
UI75084


DB2 ADMIN TOOL GEN: MISHANDLING GRANT UNLOAD AUTHORIZATION FOR TABLES
PH33690
26_Apr
2021
UI75085


DB2 ADMIN TOOL: DDL EXTRACT DOES NOT WORK WHEN DB IS WILDCARDED
PH34101
26_Apr
2021
UI75094
UI75519


DB2 ADMIN TOOL: PENDING CHANGE NOT HANDLED BY REORG BEFORE ALTERTABLE IS EXECUTED. SQLCODE -20385
PH34314
26_Apr
2021
UI75088
UI75376
UI75383
UI75519


DB2 ADMIN TOOL: GEN - THE CORRELATION NAME USED WITHIN A SUBSELECT MAY BE INCORRECT
PH34739
26_Apr
2021
UI75082
UI75519


ADMIN TOOL PANEL ADB21S DROP PRIMARY COMMAND PANEL ERROR ISPP296.ATTR SPECIFIED FIELD NOT ON TABLE 21/04/30 PTF
PECHANGE
PH35222
26_Apr
2021
UI75086
UI75089
UI75087
UI75519


DB2 ADMIN : COMPARE REPORTS DIFFERENCE IN HISTORY TABLE DEFAULT VALUE WHEN SOURCE AND TARGET ARE IDENTICAL
PH36475
26_Apr
2021
UI75083
UI75383
UI75519


ONCODE-8094 IN ADBTEP2 WHEN ATTEMPTING TO AUTOMATICALLY SET APPLCOMPAT TO OVERCOME ADB5146E SQLCODE = -20008
PH33349
26_Apr
2021
UI75095
UI75383
UI75519


DB2 OBJECT COMPARE DOES NOT INCLUDE PENDING DDL WHEN PROCESSING OBJECT CHANGES
PH33412
26_Apr
2021
UI75089
UI75519


ACTIVATE COLUMN ACCESS CONTROL NOT INCLUDED IN WSL
PH34610
26_Apr
2021
UI75092
UI75094
UI75519


DB2 ADMIN TOOL: AN ALTER THAT RESULTS IN A DROP/CREATE OF A TABLE, AND ALSO A DROP COLUMN RESULTS IN MERGE ERRORS
PH34847
26_Apr
2021
UI75093
UI75383
UI75519


DB2 OBJECT COMPARE: MULTIPLE ONCODE 150 STATEMENTS AND ADB7184E
PH34946
26_Apr
2021
UI75087
UI75089
UI75519


CM BATCH OPTION USE_DEFER_YES = 'Y' RESULTS IN UNNECESSARY REBUILD INDEX STATEMENT IN RUN JOB FOR NEW TABLE AND INDEX
PH35111
26_Apr
2021
UI75090


DB2 ADMIN TOOL: ONCODE 451 IN ADB2CMF COMPARE_VIEW
PH36092
13_Apr
2021
UI74912


PARSER IMPROVEMENTS FOR CREATE/ALTER DATABASE COMMANDS; APPLCOMPAT FIELD INCORRECT ON MAIN MENU PANEL ADB2
PH32569
2_Apr
2021
UI74738


INDEX REORG JCL DOES NOT CONTAIN '//DSNUPROC.SYSIN DD *' STATEMENT
PH32638
2_Apr
2021
UI74746


GEN/DDL DOES NOT DISPLAY COMMENTS FOR TRIGGERS
PH32854
2_Apr
2021
UI74742


DB2 ADMIN: U.UL ON HISTORY TABLE, TYPE=H, GETTING INVALID OBJECT TYPE
PH32882
2_Apr
2021
UI74739


DB2 ADMIN: BROWSING IMAGE COPY DATASETS RECEIVES ERROR WITH RC = '0019'
PH32899
2_Apr
2021
UI74736
UI78376
UI78768
PH42870

ADBTEP2: SQLCODE -305 WHEN REFERENCING SYSIBM.TEMPORAL_LOGICAL_TRANSACTION_TIME
PH33006
2_Apr
2021
UI74749
UI75387


ALTER TABLE IN SEGMENTED TABLESPACE RUN JOB MISSING -STA ACCESS(RW) FOR TS BEFORE CREATE TABLE ERROR SQLCODE = -904
PH35216
2_Apr
2021
UI74735
UI76931
UI83318


DB2 ADMIN: SQLCODE -206 WHEN USING OPTION VA ON ADB21
PH35847
2_Apr
2021
UI74750
UI75092
UI75094
UI75519


OC DOES NOT CORRECTLY COMPARE MASKED UDT COLUMNS
PH31955
2_Apr
2021
UI74744


DB2 ADMIN TOOL: UNNECESSARY REBINDS BEING GENERATED FOR ALTER TO PCTFREE FOR TABLESPACE AND INDEX
PH32354
2_Apr
2021
UI74740
UI74744


OBJECT COMPARE ADD PARTITION DECIMAL COLUMN LEADING ZEROES ADB7383E ERROR PROCESSING LIMIT KEY WRONG INPUT PARAMETERS
PH32570
2_Apr
2021
UI74748
UI75383
UI75519


DB2 AOC: A COMPARE WITH WSL=NO AND HPU=Y FOR A TEMPORAL TABLE GENERATES LOAD CARDS WITH INVALID NAMES
PH32660
2_Apr
2021
UI74747
UI75519


WSL CREATE TRIGGER INCORRECT TERMINATION CHARACTER SQLCODE = -104; INTERPRET OF WSL ADBW1 ONCODE = 150 STRINGSIZE TOKENIZE
PH32825
2_Apr
2021
UI74737
UI76402


HLQ OF DEFAULT DATA SET NAME WSL SYSPRINT FORMAT CHANGE
PH34445
2_Apr
2021
UI74743


JCLLIB MISSING IN GENERATED UTILITY JOBS AFTER USING OPTION DD FOR REMOTE CONNECTION
PH35130
31_Mar
2021
UI74702


NEW GEN STORED PROCEDURE ADBGDDL
PH35204
26_Mar
2021
UI74630
UI77354


NEW ADMIN TOOL EXEC THAT SCANS AN EXISTING DBRMOUT DATASET AND COPIES THE DBRMS TO A PDS
PH34878
12_Mar
2021
UI74411
UI77358


DB2 ADMIN TOOL: GEN: -811 GENERATING DDL ON TABLE IN IMPLICIT PBG TABLE SPACE
PH30332
12_Mar
2021
UI74413


BND2440W MESSAGES RUNNING PACKAGE CLEANUP PROGRAM ADBBMCL; REDUCE OVERHEAD AND STORAGE NEEDS FOR PROGRAM
PH31414
11_Mar
2021
UI74376
UI74743


CHANGE TCZ PROMPT OPTION DEFAULT TO YES
PH31552
11_Mar
2021
UI74382
UI74385


DDL/GEN OUTPUT OF TABLE MISSING 'IN DATABASE' CLAUSE FOR DATABASE DSNDB04
PH32744
11_Mar
2021
UI74385


GEN/DDL NO 'IMPLICITLY HIDDEN' FOR ROWID COLUMN; INTERPRET ROWID COLUMN 'R' NOT TRANSLATED; COMPARE CHANGE ':NOT HIDDEN'
PH33606
11_Mar
2021
UI74379


DB2 ADMIN TOOL: ERROR USING CREX COMMAND: FILE UCREIX NOT ALLOCATED+
PH34119
11_Mar
2021
UI74377


CURRENT FL < 502 ALT TABLE TABLEOPTS DIALOG ERROR ISPP296 ADBP7TOP .ATTR SPECIFIED FOR FIELD NOT ON PANEL
PH34945
11_Mar
2021
UI74374
UI78994


EXECUTING LINE COMMAND 'AL' ON TEMPORAL TABLE, ALTER TABLE OPTION ADD COLUMN NOT ENABLED ON PANEL ADB21TA
PH31735
11_Mar
2021
UI74388
UI74744


DB2 OBJECT COMPARE ERROR ADB8035E ATTEMPT UPDATE VERSION FILE MATCHING ROW IN A DELTA CHANGE NOT FOUND
PH32222
11_Mar
2021
UI74380
UI76029


DB2 ADMIN TOOL: : ISPP241 ERROR ON PANEL ADB2USRA, RUNSTATS OPTIONS.
PH32239
11_Mar
2021
UI74386
UI81692


CM BATCH OBJECT COMPARE RUN JOB REORG LOOP LOAD SUMMARY REPORT IBM0441W ONCODE = 150 STRINGSIZE CONDITION 20/12/14 PTF
PECHANGE
PH32535
11_Mar
2021
UI74383
UI74384
UI74385


ALTER COLUMN DEFAULT VALUE RUN REBIND(M) NO REBIND STATEMENTS IN WSL
PH32907
11_Mar
2021
UI74384
UI74385


OBJECT COMPARE OWNER IGNORE NOT WORKING WHEN RENAME MASK USED TO RENAME TABLE SCHEMA
PH34049
11_Mar
2021
UI74378
UI76117
UI78054


ADMIN TOOL PANEL ERROR ADB21D ADB21S .ATTR SPECIFIED FIELD NOT ON PANEL W/ DISPLAY OPTION "SHOW PRIMARY COMMANDS" NOT
SELECTED
PH34736
11_Mar
2021
UI74375
UI75084


GEN DOES NOT PRODUCE CREATE OR GRANT STATEMENT FOR SEQUENCE OR SEQUENCE ALIAS
PH35125
11_Mar
2021
UI74387


SET CURRENT SCHEMA STATEMENT TRUNCATED FROM LEFT WHEN MULTIPLE TABLES ARE PRESENT
PH31562
4_Mar
2021
UI74263


LINE COMMAND IMPROVEMENTS (PHASE #2)
PH31035
18_Feb
2021
UI74042
UI74702


MIGRATE OR GEN STATISTICS ENDS ADB7955E SQLCODE = -420 VALUE STRING ARGUMENT NOT ACCEPTABLE SYSIBM.BIGINT FUNCTION
PH31228
18_Feb
2021
UI74041
UI74382
UI74385


DDL/GEN OF TABLE WITH NON-ROWID COLUMN SYSCOLUMNS DEFAULT 'A' EXECUTING DDL RESULTS IN SQLCODE = -104
PH31234
18_Feb
2021
UI74047
UI77208


REMOVE WORKDDN KEYWORD FROM REORG TABLESPACE STATEMENT
PH31968
18_Feb
2021
UI74057
UI74383
UI74384
UI74385


OBJECT COMPARE USING CHANGE MANAGEMENT INCORRECT CREATE ALTER LOGICAL PARTITION 0 ADB8073E ADB8068I MERGE_TABLES
PH32461
18_Feb
2021
UI74048
UI74387


DB2 OBJECT COMPARE DUPLICATE OBJECTS RENAME OR MASKING ADB7184E RC = 12 ALLOW TO CONTINUE PROCESSING CHANGE TO RC = 8
PH31010
18_Feb
2021
UI74049
UI74050


DB2 ADMIN TOOL: EXPECTED 2 ALTER COLUMN STMTS, AOC GENERATES 1 ALTER COLUMN AND 1 ADD COLUMN STMT
PH31226
18_Feb
2021
UI74043
UI75678


UPDATE OR DELETE OBJECT FROM EXCLUDE SPECIFICATION PANEL ADBPC7LMESSAGE SQL WARN(+100), OBJECT NOT UPDATED OR DELETED
PH31507
18_Feb
2021
UI74051
UI74748
UI75383
UI75519


DB2 ADMIN COMPARE GENERATES WRONG UTILITY LOAD CARDS AT EXECUTION TIME.
PH32014
18_Feb
2021
UI74044
UI74702


DB2 ADMIN TOOL: THE GEN COMMAND IS NOT GENERATING ANY DDL FOR VIEWS EXISTING ON AN AOT
PH32457
18_Feb
2021
UI74046


DB2 ADMIN TOOL: REVOKE IMPACT REPORT COULD BE INCORRECT FOR USERS WITHOUT SYSADM ACCESS
PH32617
18_Feb
2021
UI74058
UI75094
UI75519


RENAME ENABLED ACCELERATOR TABLE RUN TIME ERRORS ADB5258E TABLE CANNOT BE RECREATED ADB5702I; WRONG TABLE NAME ADB7146I
ADB7176I
PH34132
18_Feb
2021
UI74045


DB2 AOC: PANEL ADB2PSTM ERROR: ISPF107 INVALID CONTROL WORD PARAMETER, ADB2PSQL RECORD-130
PH34313
18_Feb
2021
UI74059
UI75243
UI75383
UI75519


OBJECT COMPARE MESSAGE ONCODE=150 THE STRINGSIZE CONDITION WAS RAISED ADDING NEW AUXILIARY TABLE
PH34368
18_Feb
2021
UI74050


PERFORMANCE IMPROVEMENTS PACKAGE CLEANUP PROGRAM ADBBMCL LINE COMMAND CL PANEL ADB21L SADBSAMP MEMBER ADBCLJB
PH31561
12_Feb
2021
UI73967


FEBRUARY 2021 MAINTENANCE UPDATES
PH33914
12_Feb
2021
UI73969


PANEL ADB21XS HORIZONTAL SCROLL SUPPORT
PH34152
12_Feb
2021
UI73968
UI75519


DB2 FL 509 TOLERATION
PH33921
2_Feb
2021
UI73755
UI75519


OBJECT COMPARE DROP STATEMENTS IN SOURCE ERROR ADB8027E ADB2DICT; DROP OF GTT MAY GENERATE DROP OF TABLE SPACE
PH30833
29_Jan
2021
UI73709


CHANGE MANAGEMENT ANALYZE-GENERATED RUN JOB USES DEFAULT JOBCARD; ER LINE COMMAND ADB2C11A BINDERROR DEFAULT
PH30896
29_Jan
2021
UI73702
UI73710
UI73706


DB2 ADMIN TOOL, CM ERROR: ADB7350E ADB2CMT MODULE: ADB2CMT DETECTED AN ONCODE 520 IN COMPARE_TABLES
PH30985
29_Jan
2021
UI73707


DB2 ADMIN TOOL: REORG ON A LOB TABLESPACE MAY FAIL WITH AN ERROR: REORG SHRLEVEL NONE IS NO LONGER SUPPORTED
PH31622
29_Jan
2021
UI73704


DB2 ADMIN TOOL, KC COMMAND ON PANEL ADB21K RECEIVES 'INVALID LINE COMMAND'
PH29571
29_Jan
2021
UI73710


ADD FIELD TO "OPTIONS FOR CHANGE FUNCTIONS" PANEL ADB2PCO GENERATE DATACHANGED OPTION FOR IDAA
PH30781
29_Jan
2021
UI73708
UI73710


CM BATCH OBJECT COMPARE ANALYZE STORED PROCEDURE ADB7749E ADBCDTS DDL READER UNEXPECTED TOKEN MAIN
PH30862
29_Jan
2021
UI73706
UI73710


OBJECT COMPARE MAY REPORT UNNECESSARY CHANGE IF DEFAULT VALUE FOR COLUMN IS SESSION_USER
PH30883
29_Jan
2021
UI73699
UI73710


PARSER ERROR WITH COLUMN NAME "CHECK" UNEXPECTED TOKEN AFTER XXXXXX KEYWORD EXPECTED KEYWORD DISTINCT-NAME
PH30981
29_Jan
2021
UI73705


DB2 ADMIN TOOL PANEL ADB2Z2T2 DISPLAY/MANAGE TRACES INCORRECT IFSADBEXEC CONVERTED FB TO VB
PH32296
29_Jan
2021
UI73703


PERFORMANCE OPTION 3.13 PANEL ADB23 SQLCODE = -103 INVALID NUMERIC CONSTANT
PH31554
15_Jan
2021
UI73496
PH34739

DB2 V12 FL 508
PH33079
15_Jan
2021
UI73498


GEN LOOPS WHEN GENERATING DDL FOR A DB WHEN REBIND IS REQUESTED 21/01/06 PTF
PECHANGE
PH30036
7_Jan
2021
UI73382
UI73496
PH34739

CHANGE MANAGEMENT: IMPORTING INVALID SQL RESULTS IN IBM0032S ONCODE=612 THE CONVERSION CONDITION WAS RAISED
PH30198
7_Jan
2021
UI73389
UI73496
PH34739

AOC: NO INDEX REBUILD IS GENERATED IN THE WORKLIST WHEN AN PRIMARY INDEX IS CREATED WITH DEFER YES
PH30282
7_Jan
2021
UI73390
UI73496
PH34739

DB2 ADMIN TOOL: PACKAGE DET LINE COMMAND REPEATING EXPLAIN INFORMATION AND POOR PERFORMANCE
PH32684
7_Jan
2021
UI73380
UI73496
PH34739

CM BATCH UTIL_REORG_NOSYSREC 'Y' UTIL_REORG_SHRLEVEL 'C' ADB9722E ADB9723E NOSYSREC SHRLEVEL_CHANGE MUTUALLY EXCLUSIVE
PH30193
7_Jan
2021
UI73386
UI73496
PH34739

DB2 ADMIN TOOL: DDL COMMAND FAILS ON SQL STORED PROC. WHEN AN ADDITIONAL VARIABLE IS DECLARED AFTER SQLSTATE.
PH30261
7_Jan
2021
UI73388
UI73496
PH34739

DB2 ADMIN TOOL DDL/GEN COMMAND ON OBJECT CONTAINING CAST CLAUSE GENERATES INCORRECT DDL FOR THE CAST
PH30867
7_Jan
2021
UI73387
UI77887


DB2 ADMIN TOOL: CREATE VIEW COMMAND, CREV, IS LOSING ANY CHANGES DONE USING THE CREV EDIT COMMAND
PH31934
7_Jan
2021
UI73381


DB2 ADMIN TOOL: MOVE ICTYPE BACK TO FIRST SCREEN OF PANEL ADB21I
PH24104
6_Jan
2021
UI71178
UI76402


ALTER COLUMN NOT NULL TO WITH DEFAULT NULL UNLOAD ALTERED TABLE YES DATA LOSS;NEW OPTION RECREATE FOR NULLS CHANGE
PH27084
24_Dec
2020
UI73299


DB2 V12 INSERT PARTITIONS IMPROVEMENTS ALT TABLE SPACE; COMPARE ADB7383E INPUT_LIMITKEY BLANK; ALT INDEX PARTITIONS PARSE
ERROR
PH32218
24_Dec
2020
UI73297
UI75519
UI77211
PH39039

NEW MESSAGE ADB3018E WSL VALIDATION PREVENTS SQLCODE = -542 DUE TO NULLABLE COLUMN
PH30132
24_Dec
2020
UI73298


EXTENDED SCHEMA SUPPORT AND INCLUDE PARENT OBJECTS FOR GEN AND MIGRATE; ADB1970W ADB1971S USING REP LINE CMD
PH31558
24_Dec
2020
UI73302


SUPPORT FOR NATIVE REST APIS.
PH29895
4_Dec
2020
UI72926
UI73298


ALTER/COMPARE ADD OR CHANGE COLUMN DEFAULT VALUE REPORT CONTAINS '<STRING CONSTANT>' NOT ACTUAL VALUE
PH29932
4_Dec
2020
UI72927
UI73299


ALT ADDING PARTITIONS LIMITKEYS TO TABLESPACE CONVERT PBR ADB8073E PARTITION CANNOT BE INSERTED/ADDED ALREADY
EXISTS
PH30001
4_Dec
2020
UI72922
UI73496
PH34739

FORCEROLLUP VALUE NOT RETAINED ON PANEL ADB2USRA IF ACCESSED VIAPANEL ADB2UOPS OPTION R
PH30074
4_Dec
2020
UI72932
UI73298


GOC: DDL GENERATED TO ADD A PARTITION IS INCORRECT. ONLY ONE LINE: ADD PARTITION ENDING AT (99)
PH30415
4_Dec
2020
UI72925
UI72933
UI73298


DDL/GEN DOES NOT GENERATE PAGENUM PARAMETER WHEN ONLY ONE PARTITION SPECIFIED FOR TABLESPACE
PH30788
4_Dec
2020
UI72933
UI73298


CM ANALYZE FAILS FOR CHANGE CONVERTING PRE DB2 V8 TS TO PBR
PH32259
4_Dec
2020
UI72935
UI73298


VF TO VF COMPARE CAUSING ONCODE=150
PH25281
4_Dec
2020
UI72934


DB2 ADMIN TOOL LINE COMMAND RD REGENERATE DBRM PANEL ADB21K USS PATH DSNT231I BIND DBRM ERROR INCONSISTENT STATE DSNT233I
PH29365
4_Dec
2020
UI72923


DB2 ADMIN TOOL: DROP COLUMN OPTION CANNOT BE SELECTED ON PANEL ADB21TA.
PH29624
4_Dec
2020
UI72928


Find command on panel ADB21KSE may not highlight all occurences,also panel ADB2USO does not detect mutually excl. options
PH30787
4_Dec
2020
UI72924
UI73298


GEN: STORED PROCEDURE FUNCTION PACKAGE PATH TRUNCATED WITH ONCODE = 150 ERROR
PH31538
4_Dec
2020
UI72929


DROP VIEW ADB21T ISPT058 PANEL "ADB26DT" ERROR
PH30515
23_Nov
2020
UI72735
UI73298


GEN STATS AND COMMITS
PH31186
23_Nov
2020
UI72738


ALLOW REGISTERING CHANGES TO COLUMN MASKS & ROW PERMISSIONS
PH31272
23_Nov
2020
UI72730


SUPPORT ACCELERATOR NAME IN DB2 TABLE EDITOR
PH30514
23_Nov
2020
UI72736
UI73498
PH33079

EXTERNALIZE AUTOREBIND IN ADBTEP2.
PH31273
23_Nov
2020
UI72733
UI77357


FTB ENHANCEMENT RELATED TO INDEX_MEMORY_CONTROL ZPARM
PH29024
12_Nov
2020
UI72550
UI72735
UI73298


DB2 ADMIN TOOL: ADB1646E DURING GEN FOR A STORED PROCEDURE
PH29364
12_Nov
2020
UI72552


OBJECT COMPARE NUMPARTS SOURCE NOT TARGET TS ADB7955E ADBC024E UNEXPECTED CATALOG ROW; PANEL ADBHSARG UPDATED
PH29393
12_Nov
2020
UI72547
UI74747
UI75519


DB2 OBJECT COMPARE ADD NEW MESSAGES IF MASK USED WITH EXCLUDE SPECIFICATION
PH29606
12_Nov
2020
UI72543


DB2 ADMIN : ERROR DURING MULTI-TARGET CHANGE, DSNT408I SQLCODE = -443, ERROR: ROUTINE ADBCRSP
PH29649
12_Nov
2020
UI72549
UI72735
UI73298


DB2 ADMIN TOOL: ADB1664E AN INTERNAL ERROR OCCURRED WHEN DROPPING A DATABASE
PH27878
12_Nov
2020
UI72542


ADMIN TOOL LINE COMMAND DET PANEL ADB21K MAY NOT DISPLAY COMPLETE SQL; PARSER ERRORS CURSOR NAMES MULTIPLE HYPHENS
PH27885
12_Nov
2020
UI72539
UI72736
UI73498
PH33079

CM BATCH OBJECT COMPARE ALTER TABLE ADD RESTRICT ON DROP ANALYZENOTHING TO PROCESS EMPTY WSL
PH28116
12_Nov
2020
UI72553
UI72735
UI73298


WHEN A TABLE IS ALTERED TO ADD A PARTITION, THE EXPORTED CHANGE HAS A DROP/CREATE INSTEAD OF THE ALTER TABLE ADD PARTITION
PH28642
12_Nov
2020
UI72548


DB2 ADMIN TOOL: ADMIN_INFO_SYSPARM FAILED. SQL CODE = 000" MESSAGES WHEN USER LACKS MONITOR1 AUTHORITY
PH28678
12_Nov
2020
UI72545
UI72730


DB2 ADMIN TOOL: LKEY IS NOT VALID FOR A PBR HISTORY TABLE
PH28865
12_Nov
2020
UI72541
UI73496
PH34739

DB2 ADMIN TOOL. ERROR WHEN MIGRATING A DATABASE: ADB5146E UNEXPECTED SQLCODE -20565 IN :SYSIBMADM.GET_ARCHIVE
PH29089
12_Nov
2020
UI72540
UI74702


DB2 ADMIN TOOL. UPDATE VIEW ADBCHGV1 STATEMENT IN AOC/TCZ ADBSETUP.
PH29251
12_Nov
2020
UI72544
UI74749
UI75387


DB2 AOC: REBIND WITH A LONG VERSION STRING THAT CAUSES THE BIND TO BE MULTIPLE LINES GIVE ERROR: IKJ56712I INVALID KEYWORD, )
PH29438
12_Nov
2020
UI72551
UI72934


BIND OF RD GENERATED DBRM DSNX200I SQLCODE -104 TRANSFER GET SQLSAVEPOINT HOLD FREE CALL
PH29726
12_Nov
2020
UI72546
UI72550
UI72735
UI73298


DB2 ADMIN TOOL: GEN ON AN EXTERNAL STORED PROCEDURE FAILS WITH ADB1934W REASON CODE = 48
PH28560
6_Nov
2020
UI72420


LINE COMMAND IMPROVEMENTS (PHASE #1)
PH28566
5_Nov
2020
UI72419


APPLCOMPAT RELATED SUPPORT FOR VIEWS, SYNONYMS, AND HASH-ORGANIZED TABLES
PH29663
5_Nov
2020
UI72418
UI72736
UI73498
PH33079

OBJECT COMPARE NSP ISSUES: VALIDATE RUN IN WSL; ADB8007E CREATE PROCEDURE ALREADY EXISTS; WRONG VERSION COMPARE SUMMARY
REPORT
PH28282
27_Oct
2020
UI72227
UI73496
PH34739

ADMIN ACCELERATOR LOAD OF NEWLY-ADDED TABLE EVEN WITH DATACHANGED YES; CHANGES TO MSG ADB5264W
PH27399
25_Oct
2020
UI72223
UI72542


DET LINE COMMAND PACKAGE PANEL ADB21K IBM0441W ONCODE = 150 / ONCODE150 STRINGSIZE WRITEEXPLAININFO FORMATDATA
PH27566
25_Oct
2020
UI72229


GEN ON CATALOG COPY MAY RESULT IN -805 ERRORS OR INCORRECT OUTPUT
PH27875
25_Oct
2020
UI72225
UI73496
PH34739

DB2 ADMIN TOOL: GEN FOR MQTS WITH MULTIPLE JOINS, GENERATES DUPLICATE PARAMETERS
PH28522
25_Oct
2020
UI72228


DB2 ADMIN TOOL OPTION Z HAS EXTRA LINE IN PANEL ADSB2Z, WHEN FUNCTION LEVEL < 503
PH27373
25_Oct
2020
UI72222


DB2 ADMIN TOOL: PANEL 'ADB21VVI' ERROR - PANEL DEFINITION TOO LARGE
PH27464
25_Oct
2020
UI72224
UI72542


GEN DDL OBJECT CREATED BY SECONDARY AUTHID MAY RESULT IN SQLCODE= -553 / SQLCODE553N ESM VIOLATION 'SET CURRENT SQLID'
PH28117
25_Oct
2020
UI72226
UI72229


DB2 ADMIN TOOL: ALTER INDEX ERROR: REGISTER FAILED, REASON CODE = 20, REASON: FAILED WHILE BUILDING THE DELTA VERSION.
PH30133
19_Oct
2020
UI72139


DB2 FL508 TOLERATION
PH27088
12_Oct
2020
UI72032


DB2 V12 FL 506 IMPROVEMENTS
PH28892
12_Oct
2020
UI72031


ADD REFRESH PRIMARY COMMAND ON CHANGE MANAGEMENT PANEL ADB2C11
PH26753
5_Oct
2020
UI71911
UI72032


VALIDATE_DDL YES: COLUMN NAME LOWER CASE ADB3006E COLUMN NOT EXIST; PARTITIONED TS ADB3011E PARTITIONING IX NOT FOUND
PH27117
5_Oct
2020
UI71908


PROVIDE HIDDEN LINE COMMAND OPTION "SQO" ON PANEL ADB21K TO DISPLAY SQL FROM PACKAGES IN ORIGINAL FORMAT
PH27465
5_Oct
2020
UI71918
UI72544
UI74749
UI75387


CM BATCH OBJECT COMPARE DROP/RECREATE TABLESPACE RUN JOB START DATABASE COMMAND FAILS DSNT302I INVALID NAME
>TABLESPACE_NAME<
PH26043
5_Oct
2020
UI71914


ADMIN TOOL PANEL ADB21K RD REGENERATE DBRM LINE COMMAND ALLOW USS PATH DEFAULTS STATEMENT MESSAGE BND2161W
PH26568
5_Oct
2020
UI71909
UI72736
UI73498
PH33079

DB2 ADMIN TOOL: GEN -305 GENERATING DDL ON OBJECTS WITH MIGRATED PENDING CHANGES
PH27017
5_Oct
2020
UI71912
UI72032


CM BATCH OBJECT COMPARE GENERATES INVALID TIMESTAMP(001) LOAD CONTROL STATEMENT DSNU049I DSNUGPRS INVALID OPERAND '1'
PH22700
5_Oct
2020
UI71915
UI71919
UI73299


EXECUTING OBJECT COMPARE WSL MAY CAUSE SQLCODE -669 DUE TO EXPLICIT DROP OF UTS TABLE
PH26579
5_Oct
2020
UI71910
UI71919
UI73299


CM BATCH GENERATE_RECOVER_CHANGE = 'Y' IFF RUN JOB ADBC139E INTFIN C001 MISMATCH; CHGTAG_TYPE = 'NAME' INVALID DATA SET
NAME
PH29448
5_Oct
2020
UI71919
UI73299


CM BATCH: WSL VALIDATE LOOKS FOR WRONG DSN WHEN PREFIX_FOR_DATA_SETS IS SET
PH28647
28_Sep
2020
UI71802


SUPPORT FOR DB2 V12 FL 507
PH25775
8_Sep
2020
UI71452


DB2 ADMINISTRATION TOOL: RUNSTATS FAILING AFTER ALTER TABLE COLUMN. EXTRA DOUBLE QUOTES GENERATED FOR THE TABLE SCHEMA
PH26292
8_Sep
2020
UI71454
UI71455
UI71802


DB2 ADMIN TOOL: THE SEQUENCE OF TWO DEPENDING RENAME COLUMN STATEMENTS IS SWITCHED IN AOC, EXECUTION FAILS WITH A -601
PH16500
8_Sep
2020
UI71451
UI71802


BROWSE FEDERATED DB2 UDB TABLES DSNT408I SQLCODE = -644 / SQLCODEN644 SQLSTATE = 42615 SYNTAX ERROR ACCESS RULE
VIOLATION
PH25944
8_Sep
2020
UI71456


SUPPORT COMMENTS SQL FUNCTIONS NATIVE STORED PROCEDURES GEN TSO DDL
PH26602
8_Sep
2020
UI71455
UI71802


OBJECT COMPARE DROP COLUMN TABLE WITH TRIGGER ADB7192I ALTER TABLE DROP COLUMN RESTRICT STATEMENT REASON CODE 1
PH29207
8_Sep
2020
UI71457
UI71909
UI72736
UI73498
PH33079

GEN VIA OBJECT COMPARE OR CHANGE MANAGEMENT RECEIVES -525 DURINGTRIGGER PROCESSING DB2 V11
PH28563
26_Aug
2020
UI71253


ADBMSGS IMPROVEMENTS RELATED TO CM BATCH PARMS
PH28564
26_Aug
2020
UI71254


PANEL SCROLLING SUPPORT.
PH26846
20_Aug
2020
UI71175
UI71802


ADMIN TOOL GEN MASKING IBM0361W ONCODE = 350 STRINGRANGE REMOVE_TRAILING_BLANKS
PH28277
20_Aug
2020
UI71172
UI71178
UI76402


SET CURRENT PATH STATEMENT TRUNCATED IN OC CHG FILE
PH25046
20_Aug
2020
UI71174


ADMIN TOOL PANEL ADB2USO REORG FORCEROLLERUP YES NON-PARTITIONED TABLE SPACE INVALID SPECIFICATION
PH26731
20_Aug
2020
UI71173
UI73298


MIG: GENERATED GEN JCL INCORRECTLY SPECIFIES DDSQL PARAMETER
PH25179
20_Aug
2020
UI71177
UI74702


MIG OR GEN TABLESPACE CATALOG STATISTICS NULL VALUE UPDATESIZE SYSTABLESPACESTATS DSNU3343I;ADB2RE GENSTATS NO STATISTICS
PH25426
20_Aug
2020
UI71176
UI74386
UI81692
PH32239

DB2 ADMINISTRATION TOOL RUN JOB LOAD SUMMARY REPORT MISTAKENLY INCLUDES REORGED TABLE WITH PRECEDING TABLE'S NUMBER OF ROWS
PH27090
7_Aug
2020
UI70956


INDEX MANAGER AND UTILITIES ENHANCEMENTS
PH27083
7_Aug
2020
UI70958


DB2 V12 FL 504 IMPROVEMENTS
PH27089
7_Aug
2020
UI70959


ERROR MESSAGE ADB8052E ANALYZING CHANGE WITH ADVANCED TRIGGERS; VARIOUS OTHER FIXES
PH24002
31_Jul
2020
UI70857


DB2 V12 RECOVER AND MODIFY RECOVERY UTILITY ENHANCEMENTS
PH24006
31_Jul
2020
UI70853
UI70958


CM BATCH OBJECT COMPARE ADD COLUMN INDEX ADB8064E ALREADY INDEX COLUMN ADB8068; BUSINESS_TIME WITHOUT OVERLAPS MISSING
PH24013
31_Jul
2020
UI70851
UI71802


CM BATCH OBJECT COMPARE CREATE OR REPLACE TRIGGER ADB2PA STATEMENT CANNOT BE PARSED MISSING SEMI-COLON ADB7955E RC16
PH24149
31_Jul
2020
UI70856


DB2 ADMIN TOOL ADB325E LINE COMMANDS AOT, LKEY COMMAND ARCHIVE TABLE; ALTER INSERT ALGORITHM TABLESPACE ALLOWS VALUE 0
PH25089
31_Jul
2020
UI70854
UI71802


COMPARE TABLESPACE DROPPED ADDED COLUMNS RUN JOB LOAD FAILS INVALID COLUMN SPECIFICATION FOR ADB_IGNOREFIELD_20
PH25099
31_Jul
2020
UI70849
UI71802


DB2 ADMIN TOOL: PARSING FAILURE ON SQL USING THE MINUS KEYWORD
PH26950
31_Jul
2020
UI70855


DB2 ADMIN TOOL EXPLAIN ERRORS: INCORR SCHEMA PLAN_TABLE -204; 'NO ROWS RETURNED' SCHEMA SQLID DIFFER; HLQ INCORR SCHEMA
PH24320
31_Jul
2020
UI70852
UI70853
UI70958


OBJECT COMPARE STOGROUP MASK/IGNORE GENERATES ALTER WITH NULL STOGROUP NAME UNEXPECTED TOKEN ADB2PA UNSUCCESSFUL PARSE
PH24400
31_Jul
2020
UI70850
UI71802


DB2 ADMIN TOOL - ADB3006E ERROR OCCURS WHEN ADDING A NEW COLUMN TO A TABLE AND ALTERING THE INDEX TO INCLUDE IT
PH27086
17_Jul
2020
UI70630


MODIFY TRACE IMPROVEMENTS
PH27085
17_Jul
2020
UI70629
UI70958


COMPARE REPORT LONG NAME SUPPORT
PH27087
17_Jul
2020
UI70628


DB2 OBJECT COMPARISON TOOL SAVE AND RESTORE USER OPTIONS PANEL GOC5 AND SUBORDINATE PANELS
PH26320
13_Jul
2020
UI70488
UI70956


OBJECT COMPARE DROP/RECREATE IMPLICIT TABLE START DATABASE() SPACENAM() COMMAND FAILS DSNT302I INVALID NAME
PH23480
10_Jul
2020
UI70490


DB2 ADMIN TOOL STORED PROCEDURES ADBCRSP AND / OR ADBCRSU END WITH SQLCODE -430. 878-10 ABENDS GETMAIN ERRORS ARE ALSO
SEEN.
PH25570
10_Jul
2020
UI70491
UI78376
UI78768
PH42870

BIND OF DBRM ADBTEP2 SQLCODE = -206 SQLCODEN206 STATEMENT 8443 TOKEN LTRANSACTION
PH24115
10_Jul
2020
UI70492
UI70956


CM BATCH UTIL_REORG_STATISTICS_USE_PROFILE = 'Y' INVALID OPERANDTABLE KEYWORD REORG ADBT015I FAILURE EXECUTING ADB2UTIL
PH24383
10_Jul
2020
UI70494
UI70849
UI71802


GEN/DDL MQT ADB1847E PARSER ERROR ADB1873E NOT ALL SUPPLIED CATROWS USED
PH25003
10_Jul
2020
UI70495
UI71802


DB2 OBJECT COMPARE: UNEXPECTED <SELECT> SYNTAX IN THE WITH CLAUSE ADB2PA: THE FOLLOWING STATEMENT COULD NOT BE
D
PH25920
10_Jul
2020
UI70493


INCLUDE DB2 PENDING CHGS OPTION FOR MIG/GEN;TCz DISCOVER to use ISPF BROWSE IF VIEW FAILS;ADBSETUP REMOVE 20/07/16 PTF
PECHANGE
PH26453
10_Jul
2020
UI70489
UI71451
UI71802


ADMIN TOOL PANEL ADB222 RUN SQL FROM DATA SET CREATE VIEW GREATER THAN 32765 SQL ERROR -104 / SQLCODE104N ILLEGAL
SYMBOL
PH25686
6_Jul
2020
UI70405
UI71802


SUPPORT FOR DB2 V12 FUNCTION LEVEL 506
PH25983
6_Jul
2020
UI70406
UI72139


DB2 V12 FL 507 TOLERATION.
PH22554
25_Jun
2020
UI70261


GEN: COMPRESS YES NOT GENERATED FOR CREATE TABLE STATEMENT FOR IMPLICIT TABLE SPACE
PH22848
25_Jun
2020
UI70256
UI70257
UI70261


CM BATCH IMPORT TRIGGER VALIDATE_DDL ADB3014E ADB3002E ADB2WVL COLUMN DOES NOT EXIST NOR KNOWN GLOBAL VARIABLE
PH22020
25_Jun
2020
UI70259


RUN JOB ZPARM DDL_MATERIALIZATION ALWAYS_PENDING ALTER SET DATA TYPE ALTER ADD COLUMN SQLCODE = -20385
PH22460
25_Jun
2020
UI70258
UI70259


ADMIN TOOL SQLCODE = -20180 ALTER TABLE ADD VERSIONING USE HISTORY TABLE EXECUTED BEFORE ALTER TABLE ALTER COLUMN
PH22584
25_Jun
2020
UI70257
UI70261


PARSING ERROR IN FUNCTIONS USING LISTAGG
PH22942
12_Jun
2020
UI70022
UI70259


CM BATCH ACTION_CONVERT_TO_READ_WSL = 'Y' ADB9972E ADBCCM CONVERT TO READ WSL DATASET NOT FOUND
PH22001
12_Jun
2020
UI70026
UI70027
UI70491
UI78376
UI78768
PH42870

DB2 ADMIN TOOL RUN JOB SUMMARY REPORT OMITS NAME OF LOB INDEX
PH23303
12_Jun
2020
UI70028
PH25920

CUSTOMIZE SCHEMA INDEX SYSRESAUTH; ADB21T LINE CMD 'K'; ADB TBGET ADBTPARM ERR; ADBHPIU PANEL ERR; ADB25TU3 NO ERR
MSG
PH22008
11_Jun
2020
UI70017
UI70257
UI70261


DB2 OBJECT COMPARE. COMPARE OF IDENTICAL SEQUENCES FINDS DIFFERENCES AND CAUSES A DROP/RECREATE.
PH21914
11_Jun
2020
UI70019
UI70258
UI70259


DB2 ZOS ADMIN TOOL COMPARE: MISSING ERROR-MESSAGE IN REPORT
PH21995
11_Jun
2020
UI70021
UI71254


DB2 ADMIN TOOL STORED PROCEDURE PACKAGE PATH NOT COLLID LINE COMMAND K PANEL ADB21O "NO ROWS RETURNED"
PH22702
11_Jun
2020
UI70020
UI70259


CHANGE MANAGEMENT REMOVES THE ON DELETE CLAUSE FOR SYSTEM TEMPORAL TABLES
PH22907
11_Jun
2020
UI70027
UI70491
UI78376
UI78768
PH42870

DB2 ADMIN TOOL: ADBT333I MESSAGES FROM ADBTTP DURING LOAD
PH23165
11_Jun
2020
UI70018
UI70258
UI70259


DB2 ADMIN TOOL:-20180 ALTER TABLE ALTER COLUMN ERROR WHEN AN ALTER IS DONE ON A ROW CHANGE TIMESTAMP COLUMN.
PH22951
4_Jun
2020
UI69880


SUPPORT FOR DB2 FUNCTION LEVEL 504.
PH24230
4_Jun
2020
UI69881


SUPPORT FOR DB2 V12 FUNCTION LEVEL 505
PH22698
26_May
2020
UI69677


SUPPORT FOR DB2 V12 FUNCTION LEVELS 502 (KEY LABELS) and 503 (Db2ZAI)
PH22431
26_May
2020
UI69678


CM BATCH OBJECT COMPARE NESTED STORED PROCEDURES DROPS WRONG ORDER SQLCODE -478 / SQLCODEN478
PH25220
26_May
2020
UI69676


DB2 ADMIN TOOL CHANGE MANAGEMENT - ADB5036E A TRAILING PAREN HAS BEEN OMITTED OR NO VALUE WAS PROVIDED.
PH25528
18_May
2020
UI69571

HIPER

DBRM VERSIONID WAS NOT UPDATED
PH21447
12_May
2020
UI69456
UI69677


DDL GEN FUNCTION UDF DECLARE CHAR INTEGER UNEXPECTED TOKEN;VALIDATE BIND 'VALID' 'N' ADB1664E INTERNAL ERROR
PH24114
12_May
2020
UI69453


DB2 ADMIN TOOLS ACCEL TRACE IS FILLING UP /TMP DIRECTORY
PH24975
12_May
2020
UI69451


PARTITION RELATED FIXES 20/04/30 PTF
PECHANGE
PH21348
12_May
2020
UI69459
UI69677


DB2 ADMINISTRATION TOOL FOR Z/OS INCORRECTLY ISSUES ERRORS WHEN A DDL/GEN IS RUN ON MERGE STATEMENTS.
PH21379
12_May
2020
UI69458
UI69571


DB2 ADMIN TOOL COPY CATALOG SQLCODE = -204 DELETE GLOBAL TEMPORARY TABLE SESSION TABLENAME DOES NOT EXIST
PH21414
12_May
2020
UI69455
UI69677


CHANGE MANAGEMENT OBJECT COMPARE "SET CURRENT RULES = 'STD'" APPEARS IN WSL AFTER ALTER STATEMENT INSTEAD OF BEFORE IT
PH21640
12_May
2020
UI69460


ADMIN TOOL ADB21K PACKAGES RD LINE COMMAND BND2177E DB2 RELEASES EARLIER THAN 2.3 NOT SUPPORTED
PH23707
12_May
2020
UI69461
UI69677


GEN MASKING CREATE INDEX VIEW RUN SQLID ONCODE = 520 SUBSCRIPTRANGE UPDATE_COLUMN_SPEC
PH23813
12_May
2020
UI69462
UI69677


DUPLICATE DROP VERSIONING STATEMENT WHEN DROPPING VERSIONING AND DROPPING COLUMNS FROM A TEMPORAL HISTORY TABLE PAIR.
PH23909
12_May
2020
UI69457
UI69677


ADMIN TOOL GEN NON-PBG TABLESPACE PART 1 MISSING; FREEPG MASK NOT HONORED; MASK EDITING SEGSIZE DSSIZE
PH20648
24_Apr
2020
UI69179
UI69451
PH24975

DB2V12 INSERT PARTITIONS ENHANCEMENTS
PH22022
16_Apr
2020
UI69049
UI69179
UI69451
PH24975

DDL/GEN STORED PROCEDURE DOES NOT DISPLAY 'AUTONOMOUS' IF DB2 ZPARM APPLCOMPAT DOES NOT SUPPORT IT
PH23115
16_Apr
2020
UI69052
UI69179
UI69451
PH24975

CM BATCH OBJECT COMPARE ADB7350E ADB2CMF ONCODE 8094 DROP_OBJECT ADB7380E ADB2CMP SEVERE ERROR
PH20257
16_Apr
2020
UI69050


NEW CM BATCH OPTION TO GENERATE COMPLETE READABLE JCL FROM WSL
PH23800
16_Apr
2020
UI69051


ADMIN TOOL REBIND RB ADB21K PLANMGMT INCORRECT PATH DSNT216I DSNT233I; APPLCOMPAT ADB21KRT V11R1 V12R1 INVALID VALUE
PH20792
6_Apr
2020
UI68841


DB2 OBJECT COMPARE ALTER COLUMN SET DATA TYPE DDL_MATERIALIZATION = ALWAYS_IMMEDIATE UNIQUE INDEX RBDP
STATUS
PH21122
6_Apr
2020
UI68843


DB2 ADMIN TOOL AL LINE CMD ADB26COV NATIVE STORED PROCEDURE CANNOT CHANGE COMMIT ON RETURN TO OR FROM 'A' ('AUTONOMOUS')
PH20832
6_Apr
2020
UI68842


DB2 ZOS ADMIN TOOL COMPARE LOOP WITH INVALID SQL
PH21886
6_Apr
2020
UI68842


ANALYZE ALTER CHG FILE RECORD ATLUTIL CHECK ISPT034 UNKNOWN CHANGES RECORD
PH22548
27_Mar
2020
UI68603


CHANGE MANAGEMENT, OBJECT COMPARE, AND UTS ENHANCEMENTS.
PH21635
24_Mar
2020
UI68601


CM GENERATE RECOVER CHANGE INCONSISTENT RECOVERY POINT; ALTER DUPLICATE DATA; UNLOAD NOT GENERATED FOR ALTERED TABLE
PH23202
24_Mar
2020
UI68598


PARTITIONING ENHANCEMENTS - DISPLAY LOGICAL PART AND ROW COUNT PART 1/2.
PH18439
20_Mar
2020
UI68430


BIND MANAGER PROGRAM BNDAVB3 ADDED TO DB2 ADMIN TOOL AS ADBBMA3
PH20512
17_Mar
2020
UI68435


ACCELERATED TABLE NOT GETTING ENABLED FOR REPLICATION AFTER RECREATE 20/01/07 PTF
PECHANGE
PH19222
16_Mar
2020
UI68426
UI69179
UI69451
PH24975

OBJECT COMPARE PAGENUM ABSOLUTE DSSIZE SQLCODE = -628; ADB8013E ERROR VERIFYING CHANGE TO COMMENT ON COLUMN
PH20094
16_Mar
2020
UI68420
UI68601


DB2 OBJECT COMPARISON TOOL SAVE COMPARE RESULTS YES ADB7221W UNEXPECTED SQLCODE : -803 INSERT DATA INTO ADBCMPREPOBJLINES
PH21134
16_Mar
2020
UI68429


DB2 ADMIN TOOL DISPLAY OVER 100 SSIDS LAUNCHPAD ADB2SYS ISPS100 ISPF DIALOG ERROR INVALID SERVICE NAME ZPYYXXXXYY
PH20522
16_Mar
2020
UI68421


DB2 ADMINISTRATION TOOL REBIND RB REST SERVICE PACKAGE FAILED DSNT215I BIND OPTION NOT ALLOWED DSNT233I UNSUCCESSFUL BIND
PH20652
16_Mar
2020
UI68425
UI69677


ADB1848W UNFORMATTED DDL WILL BE GENERATED FOR THE FOLLOWING MQT BECAUSE IT COULD NOT BE PARSED.
PH16874
3_Mar
2020
UI68168


VARIOUS FIXES ALTER TRIGGER PARSER FORMATTING ONCODE = 150 SQLCODE = -4743 ADB21TAU ADB21PL ADB25TS ADB21K COPYDDN
PH19522
17_Feb
2020
UI67944
UI68425
UI69677


ADMIN TOOL DOES NOT ALLOW X'5A5A' AS A CONCATENATION CHARACTER. THIS IS VALID IN DB2 FOR SOME EBCDIC CCSIDS
PH19635
17_Feb
2020
UI67938


DB2 ADMIN TOOL ADB2USO NOSYSREC ADB2USR ADB21T AUX ARCHIVE ADB21D ADB2USO1 ADB21H ADB2U DSNUM 1
PH21563
17_Feb
2020
UI67945
UI69179
UI69451
PH24975

DDL/GEN VIEW COLUMN NAME KEYWORD NO QUOTES ADB2PA PARSE ERROR
PH21624
17_Feb
2020
UI67940
UI67941
UI67945
UI69179
UI69451
PH24975

DB2 ADMIN TOOL, GEN / DDL, ADB1848W UNFORMATTED DDL WILL BE GENERATED FOR THE FOLLOWING VIEW BECAUSE IT COULD NOT BE
PARSED
PH17903
17_Feb
2020
UI67942


ALTER TABLE TO ADD COLUMN GIVING ISSUE DURING LOAD
PH19519
17_Feb
2020
UI67941
UI67945
UI69179
UI69451
PH24975

ADB7715E THE DDL READER COULD NOT PARSE A DDL STATEMENT TOKEN ONLY (FETCH FIRST ROWS ONLY)
PH20419
17_Feb
2020
UI67943


REGENERATE DBRMS WITH VERSION NUMBER V12.1.0.0000000 SO THAT LAST 7 DIGITS CONTAIN PTF IDENTIFIER
PH21064
17_Feb
2020
UI67939
UI67943


DB2 ADMIN TOOL GEN NO STATISTICS FOR ARCHIVE TABLE WHEN NO DDL REQUESTED OR ARCHIVE TABLE ALPHABETICALLY PRECEDES BASE TABLE
PH20650
7_Feb
2020
UI67764


RECOVER AND TIME OUT RETRY ENHANCEMENTS
PH18028
28_Jan
2020
UI67591
UI67601


CM BATCH OBJECT COMPARE INCORRECTLY ADDS BACK VERSIONING WITH UNLOAD_ALTERED_TABLES SET TO 'YES'
PH18884
28_Jan
2020
UI67592
UI68168


AUDIT AND DATACAPTURE NOT HONORED FROM MASK-ENTRY
PH10996
28_Jan
2020
UI67601


GEN/DDL OBJECT COMPARE DDL OUTPUT TABLESPACE ERRONEOUS FREEPAGE PCTFREE PCTFREE_UPD VALUES DB2 V12.1
PH18447
28_Jan
2020
UI67593
UI68426
UI69179
UI69451
PH24975

CM BATCH OBJECT COMPARE ALTER MULTIPLE ADD COLUMN CLAUSES MISSING ALTER STATEMENTS FOR SOME COLUMNS
PH18635
28_Jan
2020
UI67594
UI83660
UI90197


ACCELERATOR MESSAGE TRUNCATED SYSPRINT ADBMSGS ADBTEP2 ADB5264I AQT10301E ADDITIONAL DIAGNOSTIC INFORMATION
PH19028
28_Jan
2020
UI67601


CM BATCH OBJECT COMPARE DROP CREATE TEMPORAL TABLE DUPLICATE ALTER TABLE DROP VERSIONING ADB7955E SQLCODE -20525
PH16953
17_Jan
2020
UI67441
UI69179
UI69451
PH24975

DB2 OBJECT COMPARE ANALYZE INDEX DIFFERENT PARTITIONS ADBC024E MSGADBC024E;TABLE DIFFERENT COLUMNS ONCODE=520 CHECK_DROP_COL
PH16964
17_Jan
2020
UI67436
UI67441
UI69179
UI69451
PH24975

OBJECT COMPARISON TOOL COLUMN CHANGES TABLE UTS DROP/CREATE NOT ALTERS; VIEW "SELECT *" NOT CHANGED
PH17149
17_Jan
2020
UI67441
UI69179
UI69451
PH24975

CM BATCH OBJECT COMPARE DROP HISTORY TABLE ANALYZE ADB7220E INDEX CANNOT BE DROPPED; RUN JOB SQLCODE = -669 / SQLCODEN669
PH17676
17_Jan
2020
UI67435
UI67436
UI67441
UI69179
UI69451
PH24975

ADMIN TOOL ALTER PARTITION ADD PARTITION TABLE LIMIT KEY MINVALUE MAXVALUE SQLCODE = -20385 SQLCODEN20385
PH17806
17_Jan
2020
UI67439
UI69179
UI69451
PH24975

CM BATCH ANALYZE TRIGGER OLD_TABLE VALIDATE_DDL ADB3002E MSGADB3002E ADB2WVL ERROR OBJECT DOES NOT EXIST
PH18460
17_Jan
2020
UI67431
UI67601


GEN DOES NOT GENERATE TS ERASE FIELD FOR PARTITIONED TABLESPACES
PH18888
17_Jan
2020
UI67432


ONCODE=350 THE STRINGRANGE CONDITION WAS RAISED DURING GEN VIEW
PH17085
17_Jan
2020
UI67441
UI69179
UI69451
PH24975

OBJECT COMPARE CM ANALYZE ALTER AUX HISTORY TABLE ADB7227E MSGADB7227E DUPLICATE RECORD FOR OBJECT FOUND
PH18193
17_Jan
2020
UI67440
UI68435


RECREATING AND LOADING OF MORE THAN 1 TABLE ONTO IDAA WITH ADBTEP2 NOT WORK CORRECTLY
PH18230
17_Jan
2020
UI67437
UI67441
UI69179
UI69451
PH24975

CM BATCH OBJECT COMPARE GENERATES DATA CAPTURE CHANGE ONLY FOR BASE TABLE, NOT FOR HISTORY TABLE
PH18943
17_Jan
2020
UI67438
UI67441
UI69179
UI69451
PH24975

DB2 OBJECT COMPARISON TOOL ALTER ARCHIVE BASE TABLES WSL RUN JOB SQLCODE = -20554 / SQLCODEN20554
PH12621
22_Dec
2019
UI67161
UI69676
PH25220

DB2 ADMINISTRATION TOOL FOR Z/OS - CM BATCH RECOVER JOB FAILS WITH ADB5007E
PH19997
21_Dec
2019
UI67159


ADB - INSUFFICIENT SCOPE WARNING ENHANCEMENT
PH15424
12_Dec
2019
UI66930
UI67432
UI67940
UI67941
UI67945
UI69179
UI69451
PH24975

SYNTAX ISSUE WHEN EDIT STORED PROCEDURES
PH15994
12_Dec
2019
UI66928


CAN'T GENERATE A DDL FOR A STORED PROCEDURE THAT HAS THE QUERY KEYWORD IN IT
PH16281
10_Dec
2019
UI66934


SQL ERROR -331 FROM PANEL ADB2AT WHEN SELECTING THE GRANT COMMAND
PH16564
10_Dec
2019
UI66931
UI67432


GEN OF TABLESPACE OF ARCHIVE OR HISTORY COMPLEX NOT CONSISTENT INCLUDING ALTER ENABLE ARCHIVE/ADD VERSIONING
STMTS
PH17310
10_Dec
2019
UI66932


DB2 ADMIN TOOL : COMPARE REPORTING ON SYNONYMS THAT DO NOT EXIST
PH19031
10_Dec
2019
UI66933


New DBRMS V12.1.0.0000000; 'OWNER' masks unintentional results; ADBCMBAT job fails; export changes mig dataset fails
PH15526
25_Nov
2019
UI66624


ADMIN TOOL DET DETAIL FUNCTION ADBPZAT SQLCODE = -923 00E30301 CATALOG COPY TABLE IDAA DB2 IFI ERROR
PH18697
25_Nov
2019
UI66622


ADB - DB2V12 FL506 TOLERATION
PH15035
25_Nov
2019
UI66505


NEED A METHOD TO SET LOCKMODE PARAMETER ON IDAA LOAD.
PH14886
6_Nov
2019
UI66307


OBJECT COMPARE STORED PROCEDURE GOC5 CM IMPORT CHANGES ADB2C14 ADB7749E UNEXPECTED TOKEN MAIN ADB9409E FAILED BUILDING DELTA
PH15483
6_Nov
2019
UI66299


OBJECT COMPARE HISTORY TABLE ADBC024E UNEXPECT CATALOG ROW ON TARGET FILE EXPECTED FL FOUND CO ADB7380E ADB2CMP SEVERE
ERROR
PH16346
6_Nov
2019
UI66301
UI66302


DB2 ADMINISTRATION TOOL - AN ALTER TABLE (OF A BASE TABLE) WITH LOB COLUMNS TO ADD A COLUMN, LOAD FAILS DSNU323I
PH18055
6_Nov
2019
UI66305


MIG IS NOT SETTING CCSID CORRECTLY
PH15162
6_Nov
2019
UI66297


ALT COMMAND TO CREATE WSL A -STAT AND UNLOAD ARE GENERATED TWICE
PH15547
6_Nov
2019
UI66296
UI67432


COLUMN CHANGE DEFAULT NULL / NOT NULL LOAD RECORDS DISCARDED INVALID DSN_NULL_IND or INPUT INVALID FOR DATE/TIMEINT S04E
PH15913
6_Nov
2019
UI66298
UI66299


CM BATCH ANALYZE OBJECT COMPARE DROP CREATE TEMPORAL HISTORY TABLES MISSING ALTER TABLE ADD VERSIONING STATEMENTS IN
WSL
PH16068
6_Nov
2019
UI66295
UI66505


CM BATCH SQLCODE = -204 / SQLCODEN204 CREATE INDEX COLUMN DROPPED FROM TABLE
PH16106
6_Nov
2019
UI66303
UI66306


PARSER DOES NOT SUPPORT A TABLE-REFERENCE CLAUSE AFTER USING KEYWORD.
PH18015
6_Nov
2019
UI66302


ALT COMMAND TO ALTER A COLUMN NAME FAILS. ONLY A RUNSTATS JOB IS GENERATED, NO DDL.
PH18437
6_Nov
2019
UI66306


INVALID OPERAND 'INVALIDATECACHE' KEYWORD 'REORG'; ADB9003W Invalid text file(RUNPARMS): DB2AFL='nnn';SP
formatting
PH14642
25_Oct
2019
UI66082
UI67432


CM BATCH IMPORT DDL LOWER CASE COLUMN NAME VALIDATE_DDL = Y ERROR ADB3006E / msgadb3006e
PH15880
25_Oct
2019
UI66077
UI66298
UI66299


OBJECT COMPARE CMDELTA TARGET VIEW NOT ON SOURCE ANALYZE ADB8007E msgadb8007e ATTEMPT CREATE VIEW ALREADY
EXISTS
PH16820
25_Oct
2019
UI66076
UI67943


GEN MULTIPLE STORED PROCEDURES CONSUMES HIGH CPU
PH17126
25_Oct
2019
UI66080


GEN OF VIEW WITH PARMS('/MASK') WITH EMPTY MASK FILE SHOWS COLUMNS IN SELECT CLAUSE AS SCHEMA.TABLENAME.COLUMNAME
PH17772
25_Oct
2019
UI66081
UI66505


ALT TABLE USING CM CAUSES MASK SPECIFIED IN GOC3 WAS USED.
PH17015
25_Oct
2019
UI66079
UI66297


OBJECT COMPARE DOES DROP/CREATE TABLE WITH LOB EVEN THOUGH NO CHANGES
PH16862
17_Oct
2019
UI65929


ENHANCEMENTS RELATED TO DB2 V12 SUPERFAST UNCLUSTERED INSERT.
PH12524
7_Oct
2019
UI65730


CM BATCH IMPORT VALIDATE INVALID ALTER 3-PART NAME ERROR MESSAGE ADB3001E CONTAINS DOT AS TABLE NAME
PH14258
7_Oct
2019
UI65732


DB2 ADMINISTRATION TOOL - WSL VALIDATION FAILS FOR COMPARE WITH MULTIPLE TABLESPACES
PH14073
7_Oct
2019
UI65736


CM BATCH CLONE TABLE WSL RUN JOB PREFIX_FOR_DATA_SETS TEMPLATE DSN UNLOAD DSNU1031I DSNUGTDS TOO LONG
PH14296
7_Oct
2019
UI65731


CONVERSION OF ALTERED COLUMNS ADB27AC ADB6300E IBM0342S ONCODE = 340 ONCODE340 SIZE DYNAMIC_POPULATE_CONV_CONTROLS
PH14708
7_Oct
2019
UI65734


DB2 ADMIN. TOOL - ERROR WHEN ADDING A COMMENT TO A VIEW
PH17000
7_Oct
2019
UI65733
UI70959


PANEL ADB2GEN "ALTER TABLE ADD FOREIGN KEY" VALUE NOT ALWAYS RETAINED.
PH10086
26_Sep
2019
UI65544


CANNOT GENERATE GRANT UNLOAD TABLE PRIVILEGE PANEL ADB2GT DB2 V12
PH14208
13_Sep
2019
UI65318


OBJECT COMPARE INCORRECT APPLY DATASET MEMBER NAME GENERATE ONE JOB PROCESS GOC5 T10U0002 LOAD UNLOAD
PH16427
13_Sep
2019
UI65321


ADB21D may not display views; DB2AMROW value blank; ?GV schema name no rows returned; ADB2USV DSNUM incorrectly requires
PAGE
PH16475
13_Sep
2019
UI65319


MESSAGE ADB7198I HAS A TYPO.
PH12506
13_Sep
2019
UI65317


ADMIN TOOL ALTER COLUMN SIZE ERROR MESSAGE TOO LARGE FOR PAGE SIZE DOES NOT ALLOW TABLESPACE BUFFERPOOL CHANGE
PH12941
5_Sep
2019
UI65153


OBJECT COMPARE MASK IGNORED FIELDS YES ALIAS VIEW ADB7382S ADB7380EADBC026E Severe error ADB2CMP
PH15392
5_Sep
2019
UI65157


CALL ADB21O INCORR MSG ADBC089E;ADB2Z52U BLANK IPADDR NOT ALLOWED;ADB21Q GRANT DIALOG ERR;ADB21X Cluster ratio;DSNT243I
PH12600
5_Sep
2019
UI65154
UI67943


DB2 ADMINISTRATION TOOL FOR Z/OS - ADB5146E UNEXPECTED SQLCODE -551 WITH ADBTEP2 ON RESTART
PH13238
5_Sep
2019
UI65156


DDL GEN Object Compare STORED PROCEDURE PARSE ERROR ADB2PA UNEXPECTED TOKEN ADB1932W / msgadb1932w EXPECTED KEYWORD
RESULT
PH13325
5_Sep
2019
UI65155
UI65156


GEN ON NATIVE SQL PROCEDURE RETURNS ADB2PA: FOLLOWING STATEMENT COULD NOT BE PARSED ADB1933E / msgadb1933e
PH16189
5_Sep
2019
UI65158


REG: OBJECT COMPARE RC=28 CLASSIC COMPARE W/MASK.
PH12214
21_Aug
2019
UI64892
UI66302
PH18015

DB2 ADMINISTRATION TOOL - COMPARE WITH NON-WSL GENERATES CHECK DATA JCL IN THE DDL.CREATE DATASET
PH12616
21_Aug
2019
UI64890


CM BATCH OBJECT COMPARE CM BATCH IMPORT OBJECT COMPARE PROCEDURE VALIDATE_DDL = 'Y' ADB2WVL ADB3002E / msgadb3002e
PH12608
21_Aug
2019
UI64889
UI65155
UI65156


DB2 ADMINISTRATION TOOL FOR Z/OS - STATEMENT COULD NOT BE PARSEDFOR A TRIGGER
PH13501
21_Aug
2019
UI64888


DB2 ADMINISTRATION TOOL - CMBATCH IMPORT IGNORES ALTER TABLE ADDCONSTRAINT FOREIGN KEY STATEMENTS
PH15501
21_Aug
2019
UI64891


COMPARE THROWS EXTRANEOUS ONCODE=150 WARNING.
PH15605
21_Aug
2019
UI64893


GEN CM BATCH OBJECT COMPARE ANALYZE ERROR MESSAGE ADB1458E msgadb1458e NUMBER OF PACKAGES EXCEEDED PRODUCT LIMIT OF 32K
PH11958
8_Aug
2019
UI64656
UI64892
UI66302
PH18015

CM BATCH COMPARE ALTER ADBGAJOB ISPT034 NOVALUE CONDITION VARIABLE Y RELATIVE GOCD2CMD DELIMPOS PGRELATV RC8
PH12032
8_Aug
2019
UI64655


CM BATCH COMPARE IMPORT CHANGE TARGET_VERSION_SCOPE_OWNER TARGET_VERSION_SCOPE_NAME ADB0006E ADBCCM - ERROR(S)
FOUND
PH12185
8_Aug
2019
UI64659


CM BATCH COMPARE IMPORT ANALYZE ALTER TABLE DROP COLUMNAME (WITHOUT COLUMN KEYWORD) ADB8044I NO OBJECTS TO PROCESS
PH12336
8_Aug
2019
UI64657


GEN DDL MQT IBM0534S ONCODE=8094 / ONCODE8094 PROTECTION EXCEPTION CREATE_MQT_DDL
PH02457
8_Aug
2019
UI64651


DB2 ADMIN TOOL - ADD SUPPORT FOR NEW DB2 RUNSTATS OPTION INVALIDATECACHE
PH11845
8_Aug
2019
UI64658
UI68603


ADMIN TOOL TOOLS CUSTOMIZER GRANT DB2 CATALOG TABLES YES ALLOWS SELECT ACCESS TO SYS*AUTH USERNAMES TABLES
PH12697
8_Aug
2019
UI64654
UI64889
UI65155
UI65156


DB2 ADMINISTRATION TOOL - ADB2PA PARSER ERROR WHEN CURSOR NAME HAS A DASH
PH12820
8_Aug
2019
UI64653


ADMIN TOOL PANEL ADB233 'O' REORG INDEXES SQL = -418 / SQLCODEN418 INVALID USE PARAMETER MARKERS
PH10500
30_Jul
2019
UI64477


DB2 ADMINISTRATION TOOL - BND2706S RUN TIME ERROR OCCURRED IN PROCESS_PACKAGE, SYMPTOM=8094
PH10618
19_Jul
2019
UI64317


DB2 ADMINISTRATION TOOL - SM LINE COMMAND WILL ONLY RUN ON DB2 SYSTEM WHERE WLM IS CONFIGURED
PH11627
19_Jul
2019
UI64314


ADMIN TOOL GEN OBJECT COMPARE LARGE NUMBER OBJECTS IBM0451S ONCODE=451 STORAGE CONDITION CHECK_ALLOC
PH10551
19_Jul
2019
UI64313


DB2 ADMINISTRATION TOOL - RELOAD OF TEMPORAL TABLE FAILS WITH DSNU269I
PH13380
19_Jul
2019
UI64315


DB2 ADMINISTRATION TOOL - SYSREC MISSING DURING MIGRATION OF A CLONE TABLE WHEN 'GENERATE TEMPLATE STATEMENTS' YES
PH13433
19_Jul
2019
UI64316


DB2 ADMINISTRATION TOOL - INSERT HINT COMMAND FAILS WITH SQLCODE-117 OR EXPLAIN UT PLAN_TABLE NO UPGRADE DONE ADB2E
PH09443
2_Jul
2019
UI64046


DB2 ADMINISTRATION TOOL - INCORRECT SEQUENCE OF VIEWS FOR COMPARE
PH09855
2_Jul
2019
UI64051


ADMIN TOOL SSID COMMAND NOT DISABLED "SSID SWITCHING" "NO" CCQPPRD CCQPDB2 TCZ SQLCODE -30080 DSNB260I REMOTE
PH05868
2_Jul
2019
UI64047


CM BATCH OBJECT COMPARE DROP/CREATE COLUMN TEMPORAL TABLE INSTEAD OF DROP/CREATE BASE/TEMPORAL TABLES
PH07769
2_Jul
2019
UI64045


DB2 ADMINISTRATION TOOL - COMPARE SHOULD GENERATE ALTERS TO DROP A COLUMN WHEN THE TS CHANGES TO A UTS IN THE SAME COMPARE
PH08540
2_Jul
2019
UI64048
UI68435
PH20512

ADBPZAT LINE COMMAND DEL FAILS DB2 DROPPED ACCELERATED TABLE CANNOT BE DELETED BECAUSE IT CONTAINS ARCHIVED
PARTITION(S)
PH09049
2_Jul
2019
UI64049


ADMIN TOOL PANELS ALT TBLOPTS ALTER ENABLE ARCHIVE YES ADBP1TAL NEXT INVALID CMD NO CHANGES
PH12055
2_Jul
2019
UI64042


ENHANCEMENTS RELATED TO DB2 NEW FUNCTION TOLERATION AND MESSAGES.
PH12998
2_Jul
2019
UI64044


MERGE FAILS WITH COMPLETION CODE 4094 AND REASON CODE 00000018.
PH10291
2_Jul
2019
UI64052
UI65317


DB2 ADMINISTRATION TOOL - ALTER TABLE ADD COLUMN, AN INVALID USER DEFINED DEFAULT IS ACCEPTED
PH10489
2_Jul
2019
UI64053


DB2 ADMINISTRATION TOOL - ADB2PA: STATEMENT COULD NOT BE PARSED WHEN USING THE GEN COMMAND FOR A SQL EXTERNAL PROCEDURE
PH12054
2_Jul
2019
UI64040


DB2 ADMINISTRATION TOOL - ALTER TABLE ADD DATE/TIMESTAMP/TIME COLUMN NOT PICKING UP INVALIDATED PACKAGES
PH13165
17_Jun
2019
UI63686
UI70959


GEN ON DATABASE USING MASK OR EXCLUDE AFTER ADBPGENE OR ADBGENM REVERTS TO PANEL ADB2GEN. 19/06/11 PTF
PECHANGE
PH09487
12_Jun
2019
UI63597


ACCELERATOR TRACE DETAILS ON PANEL ADBPZATR FOR IDAA V7.X LEADS TO AQT10205S FOR SYSPROC.ACCEL_CONTROL_ACCELERATOR
PH10560
12_Jun
2019
UI63599


OBJECT COMPARE DDL HISTORY TABLES FIELDPROC ADB1664E ADB2REG.COL_PROC INTERR00000003FL.TB ADB7382S
PH12622
12_Jun
2019
UI63600


UTILITY PANEL ADB2UXB (REBUILD INDEX) ONLY SHOWS SHRLEVEL INPUT PATH.
PH08815
12_Jun
2019
UI63595


CM BATCH COMPARE ADD NEW COLUMN AND INDEX RECOVER CHANGE USES UNLOAD DROP CREATE AND LOAD TABLE INSTEAD OF ALTER
PH09482
12_Jun
2019
UI63596


OBJECT COMPARE TEMPORAL HISTORY TABLE UNEXPECTED SQLCODE : -803 IN INSERT DATA INTO ADBCMPREPOBJLINES SAVE COMPARE RESULTS
YES
PH10508
12_Jun
2019
UI63598


DB2 ADMINISTRATION TOOL - GEN PUTS "FOR SBCS DATA" FOR UNICODE COLUMN WHICH IS INVALID SYNTAX
PH12895
6_Jun
2019
UI63477


CM BATCH COMPARE ADB7184E DUPLICATE RECORD MASKING PACKAGE 19/06/05 PTF PECHANGE
PH06942
4_Jun
2019
UI63402


DB2 ADMIN TOOL - TABLE SPACES RECREATED IN INCORRECT ORDER
PH07715
30_May
2019
UI63334


ADDING HPU 5.1 DSNA064C SDSNLOD2 MIG STEPLIB CONCATENATION ERROR SPANNED YES ADB586E IFI WARNING 00E60800 ADB2Z2T2
IFCIDS
PH08078
30_May
2019
UI63331


DB2 ADMINISTRATION TOOL - COMPARE GENERATES TWO PCTFREE CLAUSES
PH08599
30_May
2019
UI63335
UI64315


DB2 ADMINISTRATION TOOL - SUBMIT OF MIG WSL GETS SQLCODE = -104, ERROR: ILLEGAL SYMBOL "UNIT"
PH08747
30_May
2019
UI63337


DB2 ADMINISTRATION TOOL - ADB5700E ON ADBTEPIN DD STATEMENTS
PH08765
30_May
2019
UI63338


CM CHANGE PENDING CHANGES APPLY VIRTUAL CHANGES ADB2CCR ADB27CX ISPT034 TBQUERY ISSUED FOR TABLE ADBCVC$D THAT IS NOT OPEN
PH08817
30_May
2019
UI63339


DDL GEN ACCELERATOR ONLY TABLE (AOT) INVALID LOGGED KEYWORD SQLCODE -4747 / SQLCODEN4747
PH09431
30_May
2019
UI63341


DB2 ADMINISTRATION TOOL - ADBTEP2 DUPLICATES SPANNED YES
PH07249
30_May
2019
UI63331


OBJECT COMPARE EXPRESSION BASED INDEX KEYTARGET_COUNT CHANGE MANAGEMENT CREATES EMPTY CHANGE
PH07440
30_May
2019
UI63332


DB2 ADMINISTRATION TOOL - ADMIN ALTER INDEX FAILS ADBC024E - UNEXPECTED CATALOG ROW ON SOURCE FILE
PH07657
30_May
2019
UI63333


DB2 ADMINISTRATION TOOL - CATALOG COPY USABILITY ISSUES
PH08742
30_May
2019
UI63336
UI70959
PH13165

DB2 ADMINISTRATION TOOL - GEN 'EXECUTION MODE' NOT SET CORRECTLY
PH08931
30_May
2019
UI63340


DB2 ADMINISTRATION TOOL - CHANGE MANAGEMENT IMPORT DDL WITH 'VALIDATE_DDL' FAILS WITH ONCODE 8097 IN ADB2WVL
PH12267
30_May
2019
UI63342


Admin Tool compare DDL ONCODE=520 / ONCODE520 SUBSCRIPTRANGE CATREC_INDEX INDEX PARTITIONED TABLE
PH11853
15_May
2019
UI63053


DB2 ADMINISTRATION TOOL - DDL/GEN FAIL WITH PANEL 'ADB2GEN' ERROR 19/05/14 PTF
PECHANGE
PH06936
10_May
2019
UI62948


DB2 ADMIN TOOL - INCORRECT DROP STATEMENT FOR FOREIGN KEY, SQLCODE = -204
PH07032
10_May
2019
UI62948


CM BATCH COMPARE ANALYZE GENERATES UNNECESSARY REBUILD INDEX AFTER REORG TABLESPACE
PH07201
10_May
2019
UI62946


CM BATCH COMPARE ANALYZE VALIDATE DOES NOT FLAG ERROR CREATE TRIGGER INSERT INTO TABLE CREATE INDEX COLUMN NOT EXIST
PH08745
10_May
2019
UI62951


DB2 ADMINISTRATION TOOL - ADB8052E WHEN ALTERING PRIMARY KEY ON ARHIVE TABLE
PH08892
10_May
2019
UI62950


DB2 ADMINISTRATION TOOL - PANEL ADB21K LINE COMMAND RD GETS BND2132W PACKAGE NOT FOUND IN SUBSYSTEM
PH11551
10_May
2019
UI62949


MERGE ERROR FOR ALTER TABLE STATEMENT.
PH06931
9_May
2019
UI62948


DB2 ADMIN TOOL - FOREIGN KEYS NOT RECREATED AFTER DROP PRIMARY KEY
PH06907
9_May
2019
UI62935


POOR PERFORMANCE LP LIST PLAN TABLE LINE COMMAND ADB21K PACKAGES DSN_QUERYINFO_TABLE ADB2AK1I MISSING BINDS
PH07273
9_May
2019
UI62934


DB2 ADMINISTRATION TOOL - CM BATCH USING CAF INSTEAD OF RRS ATTACH FOR THE WSL CONVERSION FUNCTIONS.
PH07494
2_May
2019
UI62825


EXECUTE GENERATED VIEW DDL SQLCODE -206 COMMON TABLE EXPRESSION CTE GEN ERROR NEW VALUE FOR SQL_STMT_PREP TOO LARGE
STRINGSIZE
PH07943
23_Apr
2019
UI62635
PH11853

DB2 ADMINISTRATION TOOL - RENAMETS FAILS WITH ADB8012E
PH10394
23_Apr
2019
UI62628


OBJECT COMPARE DDL CREATE FILE MISSING STATEMENTS APPLY JOB
PH05075
23_Apr
2019
UI62635
PH11853

DB2 ADMIN TOOL - CM BATCH SUMMARY AND COUNT REPORT DOES NOT REFLECT ALTER TABLE
PH05538
23_Apr
2019
UI62635
PH11853

DB2 ADMIN TOOL - ALTER FUNCTION MAKES THE FUNCTION INVALID
PH06164
23_Apr
2019
UI62635
PH11853

ADMIN TOOL OBJECT COMPARISON TOOL DB2 CONTINUOUS DELIVERY FL503 FUNCTION LEVELS SUPPORT
PH06939
23_Apr
2019
UI62635
PH11853

DB2 ADMIN TOOL - PARTITION KEY CHANGES GENERATES DROP/CREATE WHEN ALTER/REORG IS SUFFICIENT
PH07498
23_Apr
2019
UI62635
PH11853

DB2 ADMINISTRATION TOOL - DROP OF A HISTORY TABLE RESULTS IN ONCODE CONDITION 8094 OR INVALID ALTER STATEMENT
PH08302
23_Apr
2019
UI62635
PH11853

DDL GEN LINE COMMAND GENERATES INVALID PBG TABLESPACE DDL PART1 ILLEGAL SYMBOL "(" SQLCODE -104 /SQLCODEN104
PH08202
23_Apr
2019
UI62635
PH11853

CM BATCH OBJECT COMPARE ALTER INDEX NO REBUILD INDEX OR REORG GENERATED IN RUN JOB
PH10162
22_Apr
2019
UI62602
UI64313


DB2 ADMINISTRATION TOOL - REMOVE TRAILING BLANKS WHEN COVERTING FROM DECIMAL TO VARCHAR
PH06946
12_Apr
2019
UI62509
PH12895

GEN CM BATCH OBJECT COMPARE ANALYZE ERROR MESSAGE ADB1458E THE NUMBER OF PACKAGES HAS EXCEEDED THE PRODUCT LIMIT OF 32K
PH08484
3_Apr
2019
UI62085


MESSAGE AND REPORT ENHANCEMENTS IN ADBMSGS.
PH06862
3_Apr
2019
UI62303


DB2 ADMIN TOOL - MOVING COLUMN FROM INDEX INCLUDE LIST INTO INDEX KEY CREATES DUPLICATE INDEX KEYS
PH06885
3_Apr
2019
UI62302


DB2 ADMIN TOOL - SQLCODE -650 REASON 22 WHEN ALTERING A TABLE WITH VIEW TO SET DEFAULT VALUE ON DECIMAL COLUMN
PH07215
3_Apr
2019
UI62305


OBJECT COMPARE REBUILD INDEX PANEL ADB2UXB FIELDS DISABLED EXCEPT SHRLEVEL
PH07200
3_Apr
2019
UI62304


DB2 ADMINISTRATION TOOL - INCORRECT COMPARE OF INLINE LENGTH CAUSES SQL -270
PH07674
27_Mar
2019
UI62167
UI64313


DB2 ADMINISTRATION TOOL - DECIMAL TO CHAR/VARCHAR CONVERSION ERROR WHEN 'COMMA' IS DECIMAL POINT AND UNICODE TABLE
PH09606
22_Mar
2019
UI62086


ADD "INVOCATION EXIT" OPTION SUPPORT THAT CAN AUTOMATICALLY BE EXECUTED BEFORE INVOCATION OF AOC.
PH09757
21_Mar
2019
UI62055


ADMIN TOOL ADB2ZZMN SYSTEM PARAMETERS ZPARM DISPLAY DB2 V10 NFM ZPARM ERRONEOUS OUTPUT
PH05551
14_Mar
2019
UI61893


DB2 ADMIN TOOL - UTIL_LISTDEF_PARTLEVEL DOES NOT WORK WITH ALTERTABLE
PH05801
14_Mar
2019
UI61894


DB2 ADMIN TOOL - ONCODE 9999 FOR COMPARE OF RENAMED TEMPORAL TABLES
PH05854
14_Mar
2019
UI61894


DB2 ADMIN TOOL - ADB7184E FOR RENAME OF HISTORY TABLE
PH05948
14_Mar
2019
UI61895


VALIDATE WSL CM BATCH ANALYZE FAILS ADB2WVL ONCODE 8094
PH05305
14_Mar
2019
UI61892


PERFORMANCE QUERIES TABLE SPACE MAINTENANCE ADB2314 REORG ADB2U NOVALUE CONDITION RAISED VARIABLE OPTKEYWD PAGENUM
PH06987
14_Mar
2019
UI61896


CM BATCH PARAMETER ANALYZE UTIL_REORG_SORTNUM BLANK STILL GENERATES SORTNUM 4 REORG JCL
PH07266
14_Mar
2019
UI61897


DB2 ADMINISTRATION TOOL - THE SQL PARSER FAILS ON COMMENTS THAT STARTS WITH /*=
PH04532
4_Mar
2019
UI61644


DB2 ADMIN TOOL - CM BATCH COMPARE FOR HISTORY TABLE FAILS WITH ONCODE=520
PH05012
4_Mar
2019
UI61639


CM BATCH COMPARE COMMENT LABEL ADB2PA3 UNSUCCESSFUL PARSE IMPORT ADB9409E RC16 REGISTER ERROR
PH08021
4_Mar
2019
UI61644


CM BATCH OBJECT COMPARE JOB IBM0451S ONCODE451 / ONCODE = 451 STORAGE CONDITION RAISED IEFUSI EXIT
PH04649
4_Mar
2019
UI61637


ADMIN TOOL PANEL ADB21KI1 NOT DISPLAY CONTOKEN SQL PACKAGE
PH04254
4_Mar
2019
UI61644


CM BATCH COMPARE SPATIAL INDEX OBJECT COMPARISON REPORT FIELD IX_EXTENSION_TYPE CHANGED SIMPLE INDEX
PH06984
4_Mar
2019
UI61644


CM BATCH COMPARE WSL RUN SQLCODEN206 / SQL ERROR -206 RUN SQLID CTE COMMON TABLE EXPRESSION CREATE VIEW
PH03794
27_Feb
2019
UI61544


CM BATCH COMPARE ALTER TABLE DROP CONSTRAINT STATEMENT EMPTY WSL
PH05472
27_Feb
2019
UI61543


DB2 ADMIN TOOL - INCORRECT WSL FOR RENAME AND REESTABLISH TEMPORAL RELATIONSHIP
PH05470
6_Feb
2019
UI61172


DB2 ADMIN TOOL - ADB2PA: THE FOLLOWING STATEMENT COULD NOT BE PARSED, TOKEN = CLIENT_CORR_TOKEN
PH05631
6_Feb
2019
UI61168


TEMPLATE DSN WITH SYMBOLIC VARIABLE &DB USES INCORRECT LENGTH
PH07031
6_Feb
2019
UI61176


DB2 ADMINISTRATION TOOL - REWORKING OF UNLOAD ALTER TABLES OPTION
PH07136
6_Feb
2019
UI61186


CM BATCH ANALYZE OBJECT COMPARE CHANGES TIMESTAMP WITHOUT TIMEZONE NOT NULL TO WITH DEFAULT NULL
PH03397
6_Feb
2019
UI61183


DB2 ADMIN TOOL - SYNONYM ON VIEW IS IMPLICITLY DROPPED BUT NOT RECREATED AFTER VIEW IS RECREATED
PH03861
6_Feb
2019
UI61170


DB2 ADMINISTRATION TOOL - AN ALTER TABLE (OF A BASE TABLE) WITH LOB COLUMNS TO ADD A COLUMN, LOAD FAILS DSNU323I
PH03987
6_Feb
2019
UI61174


CM BATCH COMPARE RUN WSL REBUILD INDEX DOUBLE QUOTES LISTDEF DSNU088I DSNUGTIS INVALID CHARACTER OPERAND RC=8
PH07159
6_Feb
2019
UI61179


DB2 ADMINISTRATION TOOL - EXPLAIN INFLUENCED BY MAX NO OF ROWS TO FETCH
PH07910
6_Feb
2019
UI61183


MISLEADING EXIT CONFIRMATION MESSAGE WHEN EXITING ALT TABLE.
PH02540
6_Feb
2019
UI61152
UI65157


ADMIN TOOL PANELS ADB21F MAY LIST INCORRECT NUMBER FUNCTIONS FOR SCHEMA
PH03412
25_Jan
2019
UI60960


DB2 ADMIN TOOL - OBJECT COMPARISON TOOL DOES NOT CREATE WORKLISTFOR PARTITIONED INDEX
PH06124
25_Jan
2019
UI60958


CM BATCH OBJECT COMPARE ANALYZE COMMENT CHECK NAMES AREN'T TOO LONG STRINGSIZE RAISED ONCODE 150 / ONCODE150 NOT IN ADBMSGS
PH03076
25_Jan
2019
UI60960


OBJECT COMPARISON TOOL CHANGE COLUMN TYPE CHANGES FILE MISSING 'WITH DEFAULT' CLAUSE
PH03305
25_Jan
2019
UI60956


DB2 ADMIN TOOL - DEFAULT VALUES FOR LOB REORG
PH05064
25_Jan
2019
UI60960


DB2 ADMIN TOOL - ALTER ON INDEX FAILS SQLCODE -644
PH04050
20_Dec
2018
UI60412
UI65157


ADMIN TOOL STORED PROCEDURES GRANTOR SQLCODE -199 SQLCODEN199 ILLEGAL USE OF KEYWORD T
PH06267
20_Dec
2018
UI60415


BIND MANAGER INTEGRATION.
PH06125
20_Dec
2018
UI60414


DB2 ADMIN TOOL - CATALOG COPY, GENERATED DDL DOES NOT QUALIFY LOB TABLES
PH01056
11_Dec
2018
UI60204


GEN SETS INCORRECT SQLID AND SCHEMA VALUES FOR MQT.
PH02306
11_Dec
2018
UI60204


CM BATCH OR OBJECT COMPARE ANALYZE WSL MAY NOT INCLUDE COLUMN RENAME WHEN TABLE IS ALSO RENAMED RENAMETB RENAMECOL MASK
PH03241
11_Dec
2018
UI60216
UI64653


DB2 ADMIN TOOL - PANEL ADB23 "PERFORMANCE QUERIES" OPTION 2 GETSSQLCODE -802
PH03868
11_Dec
2018
UI60213


ADMIN TOOL ADB2DF SCROLL BROWSE RESULT OF SQL SELECT INCORRECT DATA DISPLAY PF10 PF11
PH04534
11_Dec
2018
UI60209
UI64313


DB2 ADMIN TOOL - DATA CORRUPTED AFTER ALT COMMAND ON UNICODE TABLE TO CONVERT DECIMAL TO CHARACTER/VARCHAR
PH06133
11_Dec
2018
UI60204


ADDITIONAL OR INCORRECT SET CURRENT SQLID STATEMENT GENERATED IN WORKLIST SQLCODE -551 / SQLCODEN551 RUN SQLID OBJECT
GRANTOR
PH01667
11_Dec
2018
UI60207


ADMIN TOOL PANEL ADB21KB BIND PACKAGE LIBRARY ZFS ABSOLUTE PATH DOUBLE QUOTES ERROR MESSAGE INVALID DSN - QUALIFIER
PH01684
11_Dec
2018
UI60211


DB2 ADMIN TOOL - SYNTAX ERROR DURING STATEMENT SCAN WITH LOGICAL "NOT"SIGN X'B0'
PH02752
11_Dec
2018
UI60204


DB2 ADMIN TOOL - HISTORY TABLE CHANGES ARE REPORTED IN THE COMPARE BUT NOT GENERATED IN THE WORKLIST
PH02128
11_Dec
2018
UI60204


DB2 OBJECT COMPARISON TOOL - INVALID ALTER STATEMENTS ARE GENERATED AND DROP/CREATE WHERE ALTER WILL DO.
PH01135
14_Nov
2018
UI59718
PH10394

CM BATCH ERRORS FROM VALIDATE_DDL APPEAR IN DD SYSPRINT BUT NOT IN DD ADBMSGS
PH01723
14_Nov
2018
UI59718
PH10394

POOR PERFORMANCE GENERATING ADMIN TOOL CM BATCH OR OBJECT COMPARISON TOOL JCL
PH04920
14_Nov
2018
UI59718
PH10394

CM BATCH COMPARE SQLCODE -683 SQLCODEN683 BUSINESS_TIME ANALYZE INCOMPATIBLE CLAUSES COLUMN SPECIFICATION APPLY JOB
PH03675
15_Oct
2018
UI59110


SUPPORT FOR PARTITION LEVEL IMAGE COPIES FOR COPY STATEMENTS GENERATED BY CMBATCH
PI89334
5_Oct
2018
UI58929
PH04920

DB2 ADMINISTRATION TOOL - SQLCODE683 SHOULD BE FOUND IN STEP WSLVAL6 IN CHANGE MANAGEMENT ANALYZE JOB
PI99743
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL - INCORRECT/INVALID DDL IS GENERATED WHEN USING THE CRE LINE COMMAND
PH00005
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL ADB21II1 IMAGE COPY ICTYPE=C FORMAT INCORRECT BROKEN PAGE BASIC PAGE CREATE INTERPRETATION SYSCOPY
PH00220
5_Oct
2018
UI58929
PH04920

ALT IX-CONTROLLED TABLESPACE PBR PARTITIONING COLUMNS KEY LIMITS ADB80673 ALTER INCONSISTENCY ADB8057I ALTER_ROW
PH00280
5_Oct
2018
UI58929
PH04920

PANEL ADB21 FSEL OUTPUT MAY INCLUDE STORED PROCEDURES IN ADDITION TO USER-DEFINED CAST FUNCTIONS ROUTINETYPE
SYSROU
PH00545
5_Oct
2018
UI58929
PH04920

ADMIN TOOL MIGRATE SOURCE MASK HPU UNLOAD 256 STEPS IEFC602I EXCESSIVE NUMBER EXECUTE STATEMENTS ADB28M UNLDDN TEMPLATE
PH00674
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL - ADBL DISPLAY MESSAGE IDC0005I AND PROMPTS FOR ENTER TO CONTINUE
PH00736
5_Oct
2018
UI58929
PH04920

CMBATCH COMPARE RUN ERROR SQLCODE -501 SHOULD DISPLAY SQLCODE -904 ADBHOLD ADB5146E ADB5185E
PH00794
5_Oct
2018
UI58929
PH04920

CM BATCH COMPARE RUN NON-PARTITIONED PARTITIONED TABLESPACE DSNU047I DSNURELD DISCARDDN SYSDISC TEMPLATE MISSING RC
= 8
PH00812
5_Oct
2018
UI58929
PH04920

DDL GEN VIEW CROSS JOIN IBM0421S ONCODE = 520 ONCODE520 SUBSCRIPTRANGE JOIN_SPEC U4038 ABEND
PH00924
5_Oct
2018
UI58929
PH04920

CM BATCH OBJECT COMPARE ADVISORY REORG ALTER SQLCODE -20385 BUFFERPOOL INDEX TABLE
PH02156
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL - GEN DOES NOT SUPPORT TS PENDING CHANGE TO MEMBER CLUSTER WITH "INCLUDE DB2 PENDING CHGS YES" OPTION
PI98304
5_Oct
2018
UI58929
PH04920

RUNNING DSNUPROC JCL MAY RESULT IN IEFC657I SYMBOL LIB NOT USED; NOVALUE condition raised ADB2CUST SYS00236
PI98735
5_Oct
2018
UI58929
PH04920

GEN USING OWNER MASKS CHANGES SCHEMA VALUES IN SET CURRENT PATH STATEMENTS VIEWS TRIGGERS MIGRATE COMPARE ADB3356W
PI99132
5_Oct
2018
UI58929
PH04920

CM BATCH COMPARE ALTER ACCELERATED TABLE RESULTS ACCELERATION DISABLED INITIAL LOAD PENDING REPLICATION UNAVAILABLE
PI99342
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL - PANEL ADB233 OPT 'OS' RETURNS 'NOVALUE CONDITION FOR VARIABLE HASLOBS
PI99349
5_Oct
2018
UI58929
PH04920

ADMIN TOOL CREV CREATE VIEW LINE COMMAND ADB21T ADB21VV PROMPT PANEL ADB2PSTM ADDS X'0D15' STATEMENT IN SYSIBM.SYSVIEWS
PI99649
5_Oct
2018
UI58929
PH04920

ADD ACCELERATOR BIND REBIND PACKAGE OPTION ADMIN TOOL PANELS ADB21KB ADB21KBR
PH00805
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL - AFTER AN ALT, WSL NOT GENERATING MQT OR VIEWS ON MQT OR SQLCODE -750
PH00859
5_Oct
2018
UI58929
PH04920

DDL GEN STORED PROCEDURE SET ASSIGNMENT CASE ADB1932W PARSER ERROR REASON CODE 28 ADB2PA FOLLOWING STATEMENT NOT PARSED
PH01256
5_Oct
2018
UI58929
PH04920

DDL GEN CANNOT COMPLETE VIEW ADB1847E PARSER ERROR REASON CODE = 8 ADB1664E INTERNAL ERROR ADB1873E
PH01280
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL - REVOKE SYSADM, CASCADE NO, REVOKE IMPACT YES NO OBJECTS SHOWN EVEN WHEN OBJECTS ARE IMPACTED ADB2RZ
PH01307
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL - DDL/GEN COMMAND ABEND FOR STORED PROCEDURE KEYWORD "UNNEST" PARSER ERROR ADB2PA COLLECTION-DERIVED-TABLE
PH02248
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL - ROLE AUTHORIZATIONS ON PANEL ADB2AUS
PH00527
5_Oct
2018
UI58929
PH04920

DB2 ADMIN TOOL - COMPARE GENERATED DROP/CREATE CONVERTING TABLE TO USE TABLE-CONTROLED PARTITIONING, ALTER WOULD DO.
PI99347
5_Oct
2018
UI58929
PH04920

ADMIN TOOL PANEL ADB2ZBH2 BUFFER POOL HIT RATIOS COLUMN BUFFERS ALLOCATD TRUNCATED VALUES Db2 V12
PH01662
5_Oct
2018
UI58929
PH04920

TOOLS CUSTOMIZER PANEL CCQPDB2 APPLCOMPAT VALUE V12R1M502 DB2 VERSION 12 V12 CCQV099E ADB21KB ADB21KR ADB21KRT ISPP195
PI87960
20_Sep
2018
UI58622


OBJECT COMPARE AND CM BATCH GENERATE DROP/CREATE TABLE STATEMENTS WHEN COLUMNS ARE ADDED OR DROPPED
PH00575
20_Sep
2018
UI58622


DB2 ADMIN TOOL - CMBATCH REBIND - NO REBIND OUTPUT - ADB5060I -CALLPROC_ADMIN_COMMAND_DSN CALL DSN SP SQLCODE= 466
PI97616
20_Sep
2018
UI58622


DB2 ADMIN TOOL - DDL COMMAND/CREATE ERROR FOR CREATE MQT "NOT LOGGED"
PI98255
20_Sep
2018
UI58622


DB2 ADMIN TOOL - THE ADBDIAG FILE IS DISPLAYED AFTER ENTERING NEXT FROM PANEL ADB27CA WITH NO CHANGES
PI99083
20_Sep
2018
UI58622


DB2 ADMIN TOOL - COMPARE FINDS DIFFERENCES IN THE LOB-TABLESPACETHOUGH IT IS UNCHANGED
PI99281
20_Sep
2018
UI58622


CM BATCH AND COMPARE DO NOT DETECT CHANGE IN SEQUENCE DATATYPE RESULTING IN SQLCODE = -846 / SQLCODEN846
PI99526
20_Sep
2018
UI58622


CM BATCH COMPARE ALTER TABLESPACE ALTER INDEX ADVISORY REORG PENDING SQLCODE =-20385
PI99604
20_Sep
2018
UI58622


CM BATCH COMPARE WSL ALTER PERIOD DOUBLE QUOTES IBM0590S ONCODE 9250 ONCODE9250 ADBPMSG MSG7955
PH00168
20_Sep
2018
UI58622


CM BATCH OBJECT COMPARE ADB2PA PARSE ERROR ONCODE 350 ONCODE150 COLLATE_NUMBER COMPARE_TRIGGERS IBM0441W VIEW
PH00212
20_Sep
2018
UI58622


CM BATCH COMPARE ANALYZE ALTER WLM SP IBM0441W ONCODE = 150 STRINGSIZE COMPARE_WLM_ENV ADB2PA PARSE ERROR TRIGGER
PH00279
20_Sep
2018
UI58622


DB2 ADMIN TOOL / OBJECT COMPARISON TOOL - INVALID FREEPAGE SPECIFICATION WITH PBR-TABLESPACE
PH01964
20_Sep
2018
UI58622


DB2 ADMIN TOOL - MODULE ADB2CMP, GOCC034E - PROGRAM GOC2CMP DETECTED AN ONCODE CONDITION 8094
PH00217
6_Sep
2018
UI58344


GEN MASK LEADING BLANKS EDIT YES ERROR ADB2MASK LABEL NOT FOUND ADB2MSKP ADBGENM RETCODE 20016
PH00293
6_Sep
2018
UI58574


DB2 ADMIN TOOL / OBJECT COMPARISON TOOL - CM BATCH INTERFACE ADB7382S SEVERE ERROR WHILE GENERATING DDL FOR IX
PI99231
6_Sep
2018
UI58342
UI70855


DB2 ADMIN TOOL - SQ LINE COMMAND ON A TRIGGER PACKAGE CONTAINING XML SYNTAX: MACHINE STORAGE EXHAUSTED
PH00004
5_Sep
2018
UI58307


DB2 ADMIN TOOL - ADB8020E WHEN RUNNING CM BATCH INTERFACE
PH00406
5_Sep
2018
UI58309


DB2 ADMIN TOOL - CRITICAL ERROR DURING SEQUENCE ALTER
PI98512
5_Sep
2018
UI58313


ADB0006E ADBCCM - ERROR(S) FOUND BUT SQLCODE -805 / SQLNCODE805 NOT DISPLAYED IF PACKAGE ADB0 NOT BOUND
PI98930
5_Sep
2018
UI58311
UI64313


ADMIN TOOL CM COMPARE ALTER MAY FAIL ADBC139E INTFIN AND C001 MISMATCH. COLNAMES NOT EQUAL RC=12
PI99230
5_Sep
2018
UI58315
UI73298


ADMIN TOOL PANEL ADB21T DOES NOT DISPLAY VIEWS WHEN OPTION 'T', DATABASE NAME, SPECIFIED IN D/L/H ON PANEL ADB21
PI99523
5_Sep
2018
UI58317


CM BATCH RUN JOB HANGS PROCESSING ALTER FOREIGN KEY AUTO REBIND SELF REFERENCING RELATIONSHIP
PI97915
28_Aug
2018
UI58146


DB2 ADMIN TOOL - PANEL ADB2BRIF, BROWSE PACKAGES, PACKAGE LASTUSED DATES SORT IN INCORRECT SEQUENCE
PI99585
28_Aug
2018
UI58142


DB2 ADMIN TOOL - GEN/MIG COMMANDS GENERATE WRONG ORDER OF PRIMARY AND FOREIGN KEYS ALTER STATEMENTS
PH00860
28_Aug
2018
UI58144


DISPLAY ZPARMS ADB2Z2Z IBM0537S ONCODE 8097 ONCODE8097 DATA EXCEPTION TRANSSPRM 0C7 ADB2ZZ 18/07/26 PTF
PECHANGE
PH00193
27_Aug
2018
UI58112


CM BATCH OBJECT COMPARE GENERATES CHECK DATA WSL FOR ALTER TABLE ADD FOREIGN KEY NOT ENFORCED
PI98093
27_Aug
2018
UI58108


EXECUTING ADMIN TOOL-GENERATED GRANT DDL MAY RESULT IN SQLCODE = -552 / SQLNCODE552
PI98235
24_Aug
2018
UI58071


DB2 ADMIN TOOL - WHEN 'QUERY TYPE FOR VIEWS' SET TO ENHANCED, SQLCODE -206 IF FILTER OPTION SPECIFIES A SYSVIEWS COLUMN
PI97905
24_Aug
2018
UI58065


DB2 ADMIN TOOL - PANEL ADB2USU UTILITY OPTIONS DISPLAYS MULTIPLE TABLE NAMES
PI99340
24_Aug
2018
UI58073


DB2 OBJECT COMPARISON TOOL - INCORRECT DDL GENERATION FOR PARTITIONED INDEX
PI96915
23_Aug
2018
UI58050


CM BATCH OBJECT COMPARE COPY IN WSL RUN JOB FAILS DSNUGDTC CHECK PENDING PROHIBITS PROCESSING RC08 RC = 08 ADBTEP2_AC
YES
PH00180
23_Aug
2018
UI58047


ADMIN TOOL ALTER CX CREATE INDEX ADB27CA ADB21XAS BAD ARITHMETIC CONVERSION CONVERTDSSIZE $DSSIZE
FIRSTTIME
PI99594
11_Jul
2018
UI57205


PROMPT OPTIONS ON PANEL ADB2PRMT STUCK, PF3 NOR ENTER WORKS.
PI95189
9_Jul
2018
UI57116


ADMIN TOOL BATCH JOB OR WSL REVOKE COMMAND SQLCODE -551 WHEN GENERATED UNDER SECONDARY AUTHID AND AUTH SQL PROMPT YES
PI95148
9_Jul
2018
UI57114


DB2 ADMIN TOOL - LINE COMMAND IUSER DOESN'T WORK
PI95281
9_Jul
2018
UI57118


DB2 ADMIN TOOL - GEN/DDL DOES NOT FORMAT DECLARE GLOBAL TEMPORARY TABLE WELL
PI97215
9_Jul
2018
UI57120


ADMIN TOOL PANEL ADB2GR GRANT PRIVILEGES ADB2ZBH HIT RATIOS BUFFER POOL BP16K9 "INVALID BUFFER POOL" ERROR MESSAGE
PI97240
9_Jul
2018
UI57127


CM BATCH COMPARE RUN JOB SQLCODE -612 / SQLCODEN612 DUPLICATE NAME ERROR ATTEMPTING TO RECREATE AN INDEX
PI97637
9_Jul
2018
UI57125


DB2 ADMIN TOOL - CHANGE MANAGEMENT ANALYZE JOB FAILS WITH ERROR ADB7380E OR ADB7184E
PI98106
9_Jul
2018
UI57129


DB2 ADMIN TOOL - WORK STATEMENT LIST FAILED IN RESTART AFTER CHECK PENDING SQLCODE 162 AND THEN A NEGATIVE SQLCODE
PI97301
9_Jul
2018
UI57123


DB2 ADMIN TOOL - OBJECT COMPARE GENERATES CURRENT SCHEMA INSTEADOF CURRENT SQLID
PI97334
9_Jul
2018
UI57122


OBJECT COMPARE CHANGE MANAGEMENT ANALYZE INVALID PCTFREE FOR UPDATE WITH ZPARM PCTFREE_UPD AUTO SQLCODE -644 /
SQLNCODE644
PI98632
9_Jul
2018
UI57133


DB2 ADMIN TOOL - PANEL ADB2Z2U2 NOT ALL UTILITIES & CONFLICTING INFORMATION IS DISPLAYED
PI98608
9_Jul
2018
UI57149


CM BATCH COMPARE ALTER ADD FK SELF-REFERENTIAL DELETE RULE NO ACTION GENERATES UNNECESSARY PACKAGE REBIND STATEMENTS
PI99461
9_Jul
2018
UI57136
UI69677


ADMIN TOOL ALTER UPDATE COLUMN DECIMAL ADB26CTU ERROR ADB27DUP BAD ARITHMETIC CONVERSION 18/08/09 PTF
PECHANGE
PI98322
9_Jul
2018
UI57130


ADMIN TOOL ADB1848W Reason code = 28 ADB2PA PARSER ERROR GEN SCH = %
PI96121
3_Jul
2018
UI57015


DB2 ADMIN TOOL - UPDATE ADBCMBIV.DENU WITH ALL IDENTIFIED MISSING CM BATCH PARAMETERS (E.G., UTIL_UNLOAD_SPANNED = 'Y')
PI92385
29_Jun
2018
UI56984
PH00860

ATTEMPT TO DISPLAY DB2 V12.1 ZPARMS ON PANEL ADB2Z2Z RESULTS IN ERROR 'THIS FUNCTION DOES NOT SUPPORT DB2 RELEASE 1215.'
PI96918
19_Jun
2018
UI56694


ADMIN TOOL MIGRATE LOAD FAILS TABLESPACE NOT EMPTY RC 8; INPUT FIELD 'FIELDNAME' NOT ENTIRELY WITHIN INPUT RECORD S04E HPU
PI90668
18_Jun
2018
UI56655


DB2 ADMIN TOOL - TABLES REFERENCED IN TRIGGER BODY AND NOT INCLUDED IN COMPARE RUN ARE NOT REPORTED
PI93800
18_Jun
2018
UI56655


CM BATCH OBJECT COMPARE MESSAGE ADB8057I "AN ERROR OCCURRED DURING MERGE PROCESSING" MAY HAVE GARBLED INCORRECT DETAILS
PI94398
18_Jun
2018
UI56655


DB2 ADMIN TOOL - GRANTS ON CLONE TABLE ARE LOST AFTER A CHANGE
PI94747
18_Jun
2018
UI56655


DB2 ADMIN TOOL - OBJECT COMPARE JOB ENDS WITH RC=8 IN STEP T03VAL, SQLCODE -104
PI94840
18_Jun
2018
UI56655


CM BATCH JOB RENAME TABLE AND CREATE ALIAS WITH ORIGINAL TABLE NAME ERROR MESSAGE ADB7184E DUPLICATE RECORD DETECTED
PI95565
18_Jun
2018
UI56655


DB2 ADMIN TOOL - CMBATCH IMPORT OF DROP/ADD CONSTRAINT FAILS ADBC002E RC12 - <CONSTRAINT_NAME> ALREADY EXISTS
PI95642
18_Jun
2018
UI56655


DB2 ADMIN TOOL - ADB8007E AN ATTEMPT WAS MADE TO CREATE A VIEW THAT ALREADY EXISTS
PI96058
18_Jun
2018
UI56655


SUPPORT FOR GEN TO TOLERATE OR SUPPORT CURRENT DB2 FUNCTION LEVEL.
PI96683
18_Jun
2018
UI56655


CM BATCH OR COMPARE ALTER ADD PRIMARY KEY DDL TRUNCATE IBM0441W ONCODE=150 STRINGSIZE CONDITION ADBPA PARSE ERROR
PI96636
18_Jun
2018
UI56655


DB2 ADMIN TOOL - GEN COMMAND RETURNS ADB1223E ADB2REM: UNEXPECTED SQLCODE IN : SELECT SYSTABLES, SQLCODE -811
PI96777
18_Jun
2018
UI56655


DB2 ADMIN TOOL - CM BATCH INCORRECTLY GENERATES ALTER TABLE ADD COLUMN ON GTT
PI95317
18_Jun
2018
UI56658


ADMIN TOOL IDAA ADBPZAT KEYS ADBXGTI ONCODE 8094 ONLOC PARSEXMLDOC ADBPZAC ADBXCAC CONTENT_CHARACTERS
PI95659
18_Jun
2018
UI56655


DDL/GEN STORED PROCEDURE DGTT NOT LOGGED ADB1932W PARSER ERROR ADB1423W RC 28 UNEXPECTED TOKEN EXPECTED VOLATILE KEYWORD
PI95736
18_Jun
2018
UI56655


OBJECT COMPARE 0C4 RC 12 UNRECOGNIZED PARAMETER IN CMPPARMS FILE IBM0534S ONCODE 8094 PROTECTION EXCEPTION CM20077
PI95739
18_Jun
2018
UI56655


DB2 ADMIN TOOL - CM BATCH ALTER GENERATES STRANGE ADDITIONAL STATEMENT & VIEW NOT RECREATED
PI96005
18_Jun
2018
UI56655


DB2 OBJECT COMPARISON TOOL - CREATE SYNONYM STATEMENT FOR THE VIEW WAS NOT GENERATED
PI96044
18_Jun
2018
UI56655


ADMIN TOOL GEN INCLUDING MATERIALIZED QUERY TABLE (MQT) VIEWS RUN SQLID ABEND U4038 CEE3845I PLIDUMP UPDATE_COLUMN_SPEC
PI97260
18_Jun
2018
UI56655


DB2 ADMIN TOOL - WSL ENTRY FOR DROP INDEX TRUNCATED
PI97148
15_Jun
2018
UI56613


UNEXPECTED UTILITY OPTIONS GENERATED SETTING PANEL ADB2US "REVIEW/CHANGE OPTIONS" TO 'N' ADB909E
PI94748
15_Jun
2018
UI56610


DB2 ADMIN TOOL - ALTER OF UDF GENERATES WRONG DDL AND DROPS COMMENT
PI97702
15_Jun
2018
UI56615
UI71254


DB2 ADMIN TOOL - ISPF DIALOG ERROR WHEN ADDING A FOREIGN KEY FROM ALT PANEL ADBP7AD
PI98190
15_Jun
2018
UI56616


DB2 ADMIN TOOL - USING ALT/TS FUNCTION ISSUES ERROR MESSAGE ADB330E WHEN DSSIZE IS NULL AT PART LEVEL
PI92826
21_May
2018
UI55972


COMPARE RESULTING IN IMPORT (CMDELTA) SHOULD NOT ERROR OUT ON DEPENDENCIES
PI93801
21_May
2018
UI55972


DB2 ADMIN TOOL - MERGE ERROR WHEN DROPPING COLUMN FROM TEMPORAL TABLE
PI97273
21_May
2018
UI55972


DB2 ADMIN TOOL - COMPARE FAILING DURING PARSING, ADB2PA: THE FOLLOWING STATEMENT COULD NOT BE PARSED
PI93407
18_May
2018
UI55955


DB2 ADMIN TOOL - MIG COMMAND GENERATES WRONG DDL FOR AUXILIARY TABLE
PI94143
18_May
2018
UI55956


DB2 ADMIN TOOL - ALL X FROM PANEL ADB21K GIVES SQLCODE -206
PI94160
18_May
2018
UI55949


INCORRECT PAGE SIZE DEFINE CLUSTER GENERATED BY ADMIN TOOL SPACE MANAGEMENT VDEF OMITS CONTROLINTERVALSIZE
PI94246
18_May
2018
UI55953


JCLLIB statement generated in Admin Tool jobs even when Change Management not enabled
PI95296
18_May
2018
UI55958


DB2 ADMIN TOOL - UTIL UL (UNLOAD) USES ADBTEP2 INSTEAD OF DSNUPROC WHEN REVIEW/CHANGE OPTION IS NO
PI96986
18_May
2018
UI55951
UI91593


ADMIN TOOL BET COMMAND BATCH JOB DOES NOT PRODUCE REPORT IF ADBL EXECUTED WITHOUT PLAN PARAMETER
PI93437
26_Apr
2018
UI55497


IBM0421S ONCODE=520 ENTRY POINT CM30057 COMPARING OBJECTS; ADB2PA PARSING ERROR STORED PROCEDURE ANALYZE JOB
PI93743
26_Apr
2018
UI55515


ADMIN TOOL CM OR OBJECT COMPARE MERGE MESSAGES NOT WRITTEN TO ADBMSGS DD REPORT DD OUTPUT
PI93758
26_Apr
2018
UI55502


DB2 ADMIN TOOL - ISPF DIALOG ERROR FOR "REPORT REVOKE IMPACTS" FOR "BY ROLE XXXX"
PI94157
26_Apr
2018
UI55519
UI82963


DB2 ADMIN TOOL - REPORT DROP IMPACTS YES RETURNS: ISPP241 PANEL 'ADB2DIP' ERROR WITH DB2 VERSIONS OLDER THAN 11.1 NFM.
PI96053
26_Apr
2018
UI55505


ENHANCEMENTS FOR SUPPORTING DET IN BATCH AND GENERATING READABLEWSL IN CM BATCH.
PI93873
26_Apr
2018
UI55499


DB2 ADMIN TOOL - CMBATCH COMPARE ADBC024E - UNEXPECTED CATALOG ROW ON SOURCE FILE. EXPECTED:CO FOUND:TC
PI93899
26_Apr
2018
UI55505


DB2 ADMIN TOOL - CM BATCH NAME PARAMETER MISSING AN APOSTROPHE ENDS RC8, WITH NO ERROR MESSAGE.
PI94102
26_Apr
2018
UI55510


DB2 ADMIN TOOL - CMBATCH GENERATES INVALID DROP OF PGB TABLE
PI94115
26_Apr
2018
UI55492
PI99461

DB2 ADMIN TOOL - ALTER TABLE LEADS TO ERROR ADB7168E
PI94165
26_Apr
2018
UI55517


AFTER ADD GRAPHIC COLUMN HPU UNLOAD CHANGE RUN LOAD FAILS INPUT FIELD NOT ENTIRELY WITHIN INPUT RECORD
PI94305
26_Apr
2018
UI55512


ADMIN TOOL ADD COLUMN ALT ADB7380E SEVERE ERROR COMPARE STOPPED PROGRAM ERROR DDL LINE TOO LONG.
PI94328
26_Apr
2018
UI55508


ADMIN TOOL PANEL ISSUES ADB21SPH ISPP296 PANEL 'ADB21SPI' ERROR; ACTION BAR COMMANDS INVALID CMD
PI94255
26_Apr
2018
UI55510


DB2 ADMIN TOOL - WSL DOES NOT RECREATE THE LOB TABLE SPACES, REPORTS LOB TABLESPACE "NOT ADDED"
PI94516
26_Apr
2018
UI55521


DB2 ADMIN TOOL - COMMENT WITH DOUBLE DASH NOT PARSED
PI94835
26_Apr
2018
UI55494


SQLCODE -206/SQLCODEN206 CM BATCH CHANGE RUN JOB BECAUSE VIEW DDL GENERATED WITH EXTRA QUALIFIER
PI95302
26_Apr
2018
UI55495


DB2 ADMIN TOOL - PANEL ADB21SAC CONTINUOUSLY SHOWS AFTER F3/END
PI93493
6_Apr
2018
UI55052
UI67594
UI83660
UI90197


ADMIN TOOL BATCH JOB ADBTEP2 ERROR SQLCODE -4743/SQLCODEN4743 OR -525/SQLCODEN525
PI93679
6_Apr
2018
UI55056


AFTER MULTIPLE ALTER TABLE ALTER PARTITION STATEMENTS, GEN/DDL ENDS WITH EMPTY PARTITION KEY AND MESSAGES ADB1664E,ADB1646E
PI93929
6_Apr
2018
UI55059


DB2 ADMIN TOOL - ADB7115E INVALID PARENT KEY OF TABLE
PI92373
6_Apr
2018
UI55059


DB2 ADMIN TOOL - ADB1664E AN INTERNAL ERROR OCCURRED. / ADB7382S SEVERE ERROR WHILE GENERATING DDL
PI92995
6_Apr
2018
UI55050


CM BATCH OR OBJECT COMPARE GENERATES INCORRECT VIEW DDL WORKLIST EXECUTION ENDS SQLCODE -204 (SQLCODEN204)
PI93566
6_Apr
2018
UI55056


DB2 ADMIN TOOL - GEN/MIG COMMANDS DO NOT INCLUDE PRIMARY KEY INDEX WHEN TABLE SPACE IS IMPLICITLY CREATED
PI94049
6_Apr
2018
UI55054


DB2 ADMIN TOOL - ADB9006I THE PROGRAM ADBCVOB COMPLETED ABNORMALLY.
PI93206
15_Mar
2018
UI54435


WHEN USING LINE COMMANDS ALT, GEN, OR DDL MSG "ISPF PROCESSOR ENDED ADBNORMALLY' IS DISPLAYED. 18/03/29 PTF
PECHANGE
PI90840
13_Mar
2018
UI54435


SUMMARY REPORT ADBRPTSM DD ADBTEP2 EXECUTE WSL TRUNCATE OBJECT NAME
PI91527
13_Mar
2018
UI54435


CM BATCH OR COMPARE GOCCM STEP QUICK SCOPE INVALID NAME ADB1007E ENDS WITH RC=4 INSTEAD OF RC=8
PI88719
13_Mar
2018
UI54435


DB2 ADMINISTRTION TOOL - B37 ON SRC2OUT AS MULTIVOLUME DATASET IS NOT ALLOWED ON REFER BACKS IN JCL
PI91311
13_Mar
2018
UI54435


DB2 ADMIN TOOL - ADBRPTSM HAS ABEND CODE IN DECIMAL INSTEAD OF HEX
PI91344
13_Mar
2018
UI54435


DB2 ADMIN TOOL - RC08 AND ADB5266E WITH ADMIN ACCELERATOR LOAD
PI92033
7_Mar
2018
UI54323


THE REASON CODES FOR ERROR MESSAGE ADB9929E, CHANGE >OWNER.NAME< WAS NOT DELETED, ARE NOT DOCUMENTED
PI93052
5_Mar
2018
UI54252


CM BATCH ANALYZE VERIFICATION REXX EXIT FK NAME TRUNCATED IBM0441W ONCODE=150 STRINGSIZE CONDITION
COMPUTE_REXX_INP
PI93848
5_Mar
2018
UI54250


BATCH ANALYZE COMMENT ON INDEX ADB1223E ADB2REM: UNEXPECTED SQLCODE IN : SELECT SYSTABLES SQLCODE=-302/SQLCODEN302
PI90626
2_Mar
2018
UI54212
UI79296


DB2 ADMIN TOOL - PANEL ADB2Z2U2 FIELD "COUNT" IS TOO SHORT
PI90685
2_Mar
2018
UI54214


DB2 ADMIN TOOL - COMPARE - CHANGE TO LABEL STATEMENT
PI91337
2_Mar
2018
UI54209


DB2 ADMIN TOOL - NO BIND PLAN STATEMENTS GENERATED WHEN ON REMOTE
PI92096
2_Mar
2018
UI54221
UI69677


Selecting option DB2 Admin Tool main menu ISPF processor ended abnormally System abend code 0C4 Reason Code 10
PI92136
2_Mar
2018
UI54230


CM BATCH/COMPARE ALTER MAXPARTITIONS AND ALTER ADD RESTRICT ON DROP SQLCODE -20385/SQLCODEN20385
PI92160
2_Mar
2018
UI54223


DEFAULT(NO) RTS VARIABLE SETTINGS NOT SAVED WHEN SWITCHING BETWEEN PANELS ADB2314T AND ADB2314I
PI92435
2_Mar
2018
UI54226


DB2 ADMIN TOOL - MISSING GRANT FOR SYSACCEL.SYSACCELERATEDPACKAGES IN TCZ
PI90996
2_Mar
2018
UI54216


ONLINE REORG MAY END WITH RC08 DSNU047I DSNURORG - A REQUIRED DDCARD OR TEMPLATE IS MISSING.
PI91695
2_Mar
2018
UI54218


DB2 ADMIN TOOL - UNEXPECTED MERGE ERROR FROM GOCCM: ADB8052E
PI92601
2_Mar
2018
UI54228


DB2 ADMIN TOOL - USER AUTHORIZATIONS RETURNS SQLCODE = -204, ERROR: SYSIBM.SYSVARIABLEAUTH IS AN UNDEFINED NAME
PI92430
2_Mar
2018
UI54224


DB2 ADMIN TOOL - WHEN CREATING CATALOG-COPY, SOME LOB-TS ARE CREATED AFTER THEIR CREATE AUX TABLE, RETURNS SQLCODE = -204
PI92040
2_Mar
2018
UI54219


DB2 ADMIN TOOL - 12.1 DDL FOR WORKFILE MISSING SEGSIZE
PI93239
2_Feb
2018
UI53643


BIND OF ADBTEP2 AFTER MAINT FAILS DSNT208I PROGRAM ..ADBTEP PRECOMP 18/02/01 PTF PECHANGE
PI90185
29_Jan
2018
UI53521


DB2 OBJECT COMPARISON TOOL - ISSUES WITH SYNONYNS
PI90599
26_Jan
2018
UI53482


ENTIRE TABLE REORGANIZED EVEN THOUGH PART SPECIFICATION ENTERED ON REORG ONLINE PANEL ADB2USO
PI91001
26_Jan
2018
UI53484


CM BATCH IMPORT OF VIEW MAY FAIL WITH RC12 AND ERROR MESSAGE: "FAILED IN OPENING CURSOR C_RELTV".
PI92636
26_Jan
2018
UI53493


RECOGNIZE AND TOLERATE REVOKE, TRUNCATE AND DML.
PI91270
26_Jan
2018
UI53486


DB2 ADMINISTRATION TOOL - CM BATCH COMPARE INCORRECTLY GENERATEDCHANGE
PI92262
26_Jan
2018
UI53491


UCD WORKFLOW UPDATE.
PI92484
26_Jan
2018
UI53488


AN INFRASTRUCTURE CHANGE.
PI92812
24_Jan
2018
UI53429
PI93239

CORRECT ++HOLD INFO FOR APAR PI89214 / PTF UI52221 18/01/24 PTF
PECHANGE
PI90029
19_Jan
2018
UI53336


DB2 ADMIN TOOL - ***DATA LOSS *** ALT ON PBG TS TO NUMPARTS RESULTS IN DATA LOSS WHEN FOREGROUND OPTION IS USED.
PI89309
19_Jan
2018
UI53336


DB2 ADMINISTRATION TOOL - COMPARE GENERATED WSL GETTING SQLCODE -650 REASON CODE 22
PI90713
19_Jan
2018
UI53340


DB2 ADMIN TOOL - CHANGE MANAGEMENT ABENDS WHEN ATTEMPTING TO CHANGE THE NAME OF A COLUMN
PI90709
19_Jan
2018
UI53338
PI93239

SECURITY VIOLATION/ADB5146E RUNNING ADBTEP2 WHEN LACKING ACCESS TO GLOBAL VARIABLES GET_ARCHIVE AND MOVE_TO_ARCHIVE
PI90063
19_Jan
2018
UI53336


RUNNING A CM BATCH WORK STATEMENT LIST (WSL) MAY RESULT IN HANG OR IBM0534S ONCODE=8094 PROTECTION EXCEPTION
PI89543
17_Jan
2018
UI53281


DB2 ADMIN TOOL - GENERATE TABLESPACE WITH CLOB COLUMN(S), AUX TABLE NOT INCLUDE IN ADB2GEN "SUMMARY OF OBJECTS CREATED"
REPORT
PI90106
17_Jan
2018
UI53268


MIGRATE OF LARGE NUMBER OF TABLES IN TABLESPACE RESULTS IN "LOAD STATEMENT TOO LONG" AND RETURN CODE 1000
PI91310
17_Jan
2018
UI53279


DB2 ADMIN TOOL - MIG JOB ADBMGT1 RESULTS IN SQLCODE -672 DUE TO MISSING ALTER TABLE ... DROP RESTRICT ON DROP STATEMENT
PI90935
17_Jan
2018
UI53292


DB2 ADMIN TOOL - CM BATCH NO WARNING ON PENDING CHANGES
PI86552
16_Jan
2018
UI53258


DB2 ADMIN TOOL PANEL ADB2Z2RI (INSERT RLIMIT) DOES NOT ALLOW BLANKS FOR IP ADDRESS
PI89411
16_Jan
2018
UI53255


DB2 ADMIN TOOL - PANEL ADBPD HELP PANEL DESCRIBES PART NUMBERS INCORRECTLY / EXIT FROM ADMIN TOOL RC=4 NO
INFORMATION
PI90625
16_Jan
2018
UI53253


DB2 ADMIN TOOL - PROBLEM WITH DDL OPTION FOR STORED PROCEDURE
PI92080
16_Jan
2018
UI53245
PI93206

ADMIN TOOL AND COMPARISON TOOL SUPPORT ALIAS ON SEQUENCE.
PI89342
22_Dec
2017
UI52909


DB2 ADMINISTRATION TOOL - ISPP178 PANEL 'ADB21XSD' ERROR RC16 VARIABLE CPYULRSN
PI88314
22_Dec
2017
UI52911


EXECUTING GEN ON A VIEW, WITH 'RUN SQLID' NOT BLANK, MAY GENERATE INVALID DDL, RESULTING IN SQLCODE -206 WHEN
EXECU
PI74538
12_Dec
2017
UI52632


DB2 ADMIN TOOL TA (AND VA) OPTION IS NOT ACCEPTED ON THE CM MANAGE EXCLUDE SPECIFICATIONS PANEL ADBPC7L
PI87865
12_Dec
2017
UI52619


EXCLUDING TRIGGER DURING COMPARE MAY RESULT IN U4087 ABEND IBM0441W ONCODE=150 STRINGSIZE ENTRY POINT
ISSUE_EXCLUDE_M
PI88631
12_Dec
2017
UI52630


DB2 ADMINISTRATION TOOL - ALT COLUMN TO SET DEFAULT NULL GENERATES UNNECESSARY DROP/CREATE TABLE
PI85711
12_Dec
2017
UI52626


DB2 ADMINISTRATION TOOL - WRONG DD ASSIGNMENTS ON GENERATED CUSTOMIZATION JOB
PI87286
12_Dec
2017
UI52640


DB2 ADMINISTRATION TOOL - COMPARE STEP FAILED ADB1664E, NOT CLEAR WHAT THE PROBLEM WAS OR WHERE IT WAS
PI88243
12_Dec
2017
UI52628


DB2 ADMIN TOOL GENERATES INVALID REORG JCL, JOB ENDS IN ABEND UNABLE TO OPEN DCB FOR DDNAME SYSIN REASON CODE X'00E40070'
PI89213
12_Dec
2017
UI52630


DB2 ADMINISTRATION TOOL - ONCODE=340 SIZE CONDITION FROM ENTRY POINT PROCESS_LVC
PI89383
12_Dec
2017
UI52623
UI70855


SQ LINE COMMAND MAY HANG WHEN EXECUTED AGAINST A PACKAGE ON PANEL ADB21K.
PI90116
12_Dec
2017
UI52621


LINE COMMAND AE ON PANEL ADB2AUS DOES NOT DISPLAY EXPLICIT AUTHORIZATIONS ON CLONE TABLES
PI90970
1_Dec
2017
UI52339


CM OR COMPARE JOB USING TEMPLATE ENDS ADB0006E ADBCCM - ERROR(S)FOUND. PLEASE REVIEW OUTPUT ADB2PA RETURNING RC=16
PI85945
28_Nov
2017
UI52221
PI92812

IBM0441W ONCODE=150 THE STRINGSIZE CONDITION WAS RAISED EXTRACTING CATALOG STATISTICS VIA GEN WITH MASKING
PI87594
28_Nov
2017
UI52204


DB2 OBJECT COMPARISON TOOL - COMPARING STORED PROCEDURES FAILS WITH ADB8043I/ONCODE CONDITION 8094
PI88326
28_Nov
2017
UI52190


CM BATCH/COMPARE ANALYZE JOB WITH &UNIQ IN TEMPLATE MAY FAIL WITH IKJ56545I INVALID &SUBSTR RANGE OR EXIT CODE EXPRESSION
PI84979
28_Nov
2017
UI52184
PI90970

CM OR COMPARE JOB USING TEMPLATE ENDS ADB0006E ADBCCM - ERROR(S)FOUND. PLEASE REVIEW OUTPUT ADB2PA RETURNING RC=16
PI86541
28_Nov
2017
UI52202


OBJECT COMPARE CONVERT OF NON-PARTITIONED TO PARTITIONED INDEX GENERATES PIECESIZE PARM AND CREATE FAILS WITH SQLCODE = -876
PI88251
28_Nov
2017
UI52202


CM BATCH ANALYZE PHASE OF CHANGE ENDS WITH RC=12 AND MESSAGES No sysindexpart row found for Create index, ADB7380E,
andADBC026
PI88238
28_Nov
2017
UI52186


DB2 ADMINISTRATION TOOL - LACK OF SPARSE INDEX INDICATOR IN ADB2ELI PANEL
PI88322
28_Nov
2017
UI52221
PI92812

OBJECT COMPARE JOB ENDS RC=12 ADB7350E MODULE : ADB2CMP DETECTED ONCODE CONDITION 8094 IN OUTPUT_ADDCLONE AT
107
PI89214
28_Nov
2017
UI52221
PI92812

DB2 ADMINISTRATION TOOL - TOOL DOES NOT CREATE/LOAD TABLES DEFINED ON IDAA IN ALL CASES
PI89261
28_Nov
2017
UI52192


GEN/DDL MAY PRODUCE UNFORMATTED DDL FOR VIEW
PI89457
28_Nov
2017
UI52202


DB2 ADMIN TOOL ALTERING TABLE TO PBR, ERROR ON CREATE, PREPARE FUNCTION SQLCODE = -104, APAR PI80388 COMPLETION FIX.
PI89311
16_Nov
2017
UI51942


DDL or GEN function may generate UNFORMATTED DDL AND MESSAGE ADB1848W for view
PI86242
16_Nov
2017
UI51944


CMBATCH OR COMPARE ANALYZE TEMPLATE COMMA=DECIMAL DSNHDECP FAILSADB2PA RETURNING RC=16 ADB0006E ADBCCM - ERROR(S) FOUN
PI88853
16_Nov
2017
UI51938


DB2 ADMINISTRATION TOOL - THE TEXT FOR ERROR MESSAGE ADB7139E ISMISLEADING / NOT COMPLETE
PI87505
15_Nov
2017
UI51907


USING PRIMARY COMMAND GRANT ON PANEL ADB2AK MAY RESULT IN ERROR 'NOVALUE CONDITION RAISED FOR VARIABLE ADB530E'
PI87870
15_Nov
2017
UI51905


COMPARE JOB MAY END WITH CEE0374C CONDITION=IBM0780S...TOKEN=...WHILE RUNNING PROGRAM IBMBERRI...U4039 ABEND
PI86938
15_Nov
2017
UI51909


DB2 ADMIN TOOL - WHEN ALTERING STORAGE ATTRIBUTES THE GENERATEDJOB IS INCOMPLETE
PI87863
15_Nov
2017
UI51940


ENTERING 'GA' COMMAND FROM PANEL ADB2Z MAY RESULT IN ERROR: TABLE IS NOT OPEN
PI88912
15_Nov
2017
UI51936


DB2 ADMINISTRATION TOOL - REXX FUNCTION : ADB2C21 SYNTAX ERROR 7IN LINE 533 USING VB EXEC LIB.
PI89048
15_Nov
2017
UI51902


CHANGE MANAGEMENT COMPARE DOES NOT GENERATE DDL FOR HISTORY TABLESPACE WHEN MASKS ARE USED
PI66475
7_Nov
2017
UI51741


ENHANCE CM BATCH INTERFACE AND OBJECT COMPARE OUTPUT - IMPROVE MESSAGING.
PI85825
7_Nov
2017
UI51741


DDL OR GEN LINE COMMAND GENERATES ACCELERATOR TABLE DDL WHICH MAY RESULT IN SQLCODE -4747 WHEN EXECUTED
PI86411
7_Nov
2017
UI51741


COPY CATALOG JOB FAILS WITH SQLCODE 100 ON SYSPACKAGE; GEN TRUNCATES TS NAME IF > 8 CHARACTERS IN INPUT REQUESTNAME > 8
PI86672
7_Nov
2017
UI51741


DB2 ADMINISTRATION TOOL - USER ABEND 4039; IBM0451S ONCODE=451 THE STORAGE CONDITION WAS RAISED
PI87268
7_Nov
2017
UI51741


RUNNING WSL REFERENCING GLOBAL VARIABLE RESULTS IN MESSAGE ADB2W1: SETBACKUPDDLVARS: UNRECOGNIZED TYPE: VARIABLE
PI87964
7_Nov
2017
UI51741


DB2 ADMINISTRATION TOOL - INCORRECT VALUE FOR TYPE PASSED TO VERIFICATION EXIT WHEN MAXPARTITIONS IS ALTERED
PI87255
7_Nov
2017
UI51741


DB2 ADMIN TOOL - CHANGE MANAGEMENT RUN JOB ABENDS WHILE EXECUTING CHECK DATA UTILITY BEFORE REBUILD INDEX
PI80511
1_Nov
2017
UI51582


DB2 ADMINISTRATION TOOL ALTER DSSIZE OF PARTITIONED TABLESPACE MISSING STATEMENT FOR DISCARDDN IN THE LOAD PHASE
PI85243
1_Nov
2017
UI51623


CM BATCH JOB GENERATES UNWANTED GRANTS ON TARGET AFTER IMPORT OF DDL CONTAINING DROP STATEMENT
PI87366
1_Nov
2017
UI51623


CHANGE MANAGEMENT ANALYZE JOB W/ DEBUG ERROR ADB9703E PROGRAM ADBCCM DETECTED AN ONCODE CONDITION 8094 IN
DUMP_TABLE_REGISTR
PI80498
1_Nov
2017
UI51623


DB2 OBJECT COMPARISON TOOL MISSPELLED A COLUMN OF "ALTER TABLE FOREIGN KEY" DID NOT GET A ERROR
PI83888
31_Oct
2017
UI51580


DDL OR GEN GENERATES VIEW DDL WITH INCORRECT CONCATENATION CHARACTER WHEN USING CCSID=500
PI84875
31_Oct
2017
UI51586


DB2 ADMINISTRATION TOOL - SOME ZPARMS GENERATED BY ADMIN TOOL ARE INCORRECT
PI87356
27_Oct
2017
UI51511


DB2 ADMINISTRATION TOOL - INCORRECT MASKING INSIDE WHEN CLAUSE OF UPDATE TRIGGER
PI84820
23_Oct
2017
UI51344


CM GENERATED WSL TO ADD COLUMN TO INDEX MAY RESULT IN SQLCODE20181 IF INDEX INVOLVED IN REFERENTIAL
CONSTRAI
PI88904
18_Oct
2017
UI51240


LIBDEF STILL OCCURS WITH LIBDEF(NO), CM OPTION ON MAIN MENU MAY RESULT IN SQLCODE 204
PI85077
18_Oct
2017
UI51255


DDL OR GEN DOES NOT DISPLAY SQL-ROUTINE-BODY FOR SQL EXTERNAL PROCEDURES
PI85779
29_Sep
2017
UI50758


OBJECT COMPARE AND CM BATCH ANALYZE GENERATE REORG STATEMENT EVEN WITH OPTION 'REORG/REBUILD' SET TO NO
PI86086
29_Sep
2017
UI50771


RELOAD AFTER COMPARE OR CM BATCH ADD OF COLUMN AND UNLOAD MAY FAIL WITH "DSNU323I DSNURWUF - COLUMN 'COLUMNAME' IS OMITTED"
PI86879
29_Sep
2017
UI50760


EXECUTING ADMIN TOOL GEN LINE COMMAND ON VIEW MAY RESULT IN ABEND 0C4 OR MESSAGE ADB1848W
PI61852
22_Sep
2017
UI50555
PI94328

ADD SUPPORT FOR CM BATCH RESTART WITH WSL
PI78226
22_Sep
2017
UI50555
PI94328

CREATE STATEMENT NOT FORMATTED WHEN IMPORTING DDL VIA ADMIN TOOL CHANGE MANAGEMENT USING MASK
PI71829
22_Sep
2017
UI50555
PI94328

DB2 OBJECT COMPARE INCONSISTENCIES OF THE COMPARISON SUMMARY REPORT
PI80830
22_Sep
2017
UI50555
PI94328

DB2 ADMIN TOOL - USING X'BBBB' CONCATENATION CHARACTERS GETS ADB2PA: THE FOLLOWING STATEMENT COULD NOT BE PARSED
PI82330
22_Sep
2017
UI50555
PI94328

CONVERSION OF TABLESPACE FROM EBCDIC TO UNICODE
PI83063
22_Sep
2017
UI50555
PI94328

DB2 ADMIN TOOL / AOC GENERATES UTILITY RELATED DATASETS USING &ZUSER INSTEAD OF PREFIX FOR SYSERR AND SYSPRINT.
PI83140
22_Sep
2017
UI50555
PI94328

ADMIN TOOL GEN COMMAND ON VIEW MAY RESULT IN ADB2PA MESSAGE THE FOLLOWING STATEMENT COULD NOT BE PARSED
PI83882
22_Sep
2017
UI50555
PI94328

DDL LINE CMD ON VIEW RESULTS IN MESSAGE UNEXPECTED TABLE SPECIFICATION SYNTAX AND ADB2PA PARSE ERROR
PI86128
22_Sep
2017
UI50555
PI94328

PERFORMANCE ISSUES GENERATING BATCH JOB VIA DB2 ADMIN TOOL PANEL ADB21KB OR ADB21KR TO BIND OR REBIND ALL PACKAGES
PI76887
22_Sep
2017
UI50555
PI94328

PACKAGE NAME IS TRANSLATED TO UPPER CASE IN PANEL ADB21KR
PI77851
22_Sep
2017
UI50555
PI94328

DB2 OBJECT COMPARISON TOOL - ADB2CMO DETECTED AN ONCODE CONDITION 8094 IN SYMBTAB_PRINT WHEN DEBUG ON
PI78487
22_Sep
2017
UI50555
PI94328

DB2 OBJECT COMPARISON TOOL - COMPARE GENERATES WORKLIST WITH INCOMPLETE AND IRRELEVANT MQT INSTRUCTIONS
PI79134
22_Sep
2017
UI50555
PI94328

DB2 ADMIN TOOL APPLY RETURNS SQLCODE = -876, ERROR: 'INDEX' CANNOT BE CREATED OR ALTERED
PI83146
22_Sep
2017
UI50555
PI94328

ADMIN TOOL GEN COMMAND ON VIEW CONTAINING SELECT UNIQUE RESULTS IN ADB1847E PARSER ERROR
PI84589
22_Sep
2017
UI50555
PI94328

DB2 ADMINISTRATION TOOL - ALTER TABLE ADD LOB COLUMN WHEN LOB COLUMNS ALREADY EXIST - PHASE 2
PI85002
22_Sep
2017
UI50555
PI94328

BIND/REBIND PANEL ADB21K: OBJECT DOES NOT EXIST TABLE SYSACCEL.SYSACCELERATEDPACKAGES MUST EXIST IN ORDER
TO
PI86557
22_Sep
2017
UI50555
PI94328

ADMIN TOOL SPACE MANAGEMENT OPTION RESULTS IN SQLCODE = -104 ON PANEL ADB21SA 'ALTER TABLE SPACE'
PI86578
22_Sep
2017
UI50555
PI94328

DB2 ADMINISTRATION TOOL - ERROR MESSAGE 'NOT POSSIBLE' IS RECEIVED WITH UT LINE COMMAND ON PANEL ADB21S 'TABLE SPACES'
PI80125
22_Sep
2017
UI50555
PI94328

AOC 12.1 - DB2 ADMIN PCTFREE FOR UPDATE FOR ALTER TABLESPACE.
PI82963
28_Aug
2017
UI49875


DB2 OBJECT COMPARE DOES NOT REPORT AS DIFFERENCE CHANGE IN REFERENTIAL CONSTRAINT FROM 'NOT ENFORCED' TO 'ENFORCED'
PI82903
25_Aug
2017
UI49875


ALTER OF TABLESPACE CONTAINING AN INDEX-CONTROLLED PARTITIONED TABLE FAILS WITH RC=12 WHEN SELECTING THE MAKEPBR OPTION
PI83012
25_Aug
2017
UI49875


ADMIN TOOL GENERATED BATCH JOB MOVING PAGE SET FROM VCAT TO STOGROUP OMITS IDCAMS ALTER STATEMENT FOR VSAM DATA COMPONENT
PI73610
25_Aug
2017
UI49875


DB2 ADMIN TOOL - GRANTS GENERATED OUT OF ORDER IN WSL
PI74305
25_Aug
2017
UI49875


ADB318E MSG ON PANEL ADB26COV USING 24 X 80 SCREEN SIZE
PI83079
25_Aug
2017
UI49875


DB2 ADMIN TOOL TABLE SPACE MAINTENANCE RECOMMENDATIONS MAY INCORRECTLY RECOMMEND A REORG
PI83877
25_Aug
2017
UI49875


ADBTEP2 ENDS WITH RC0 WHEN USER-SPECIFIED RESTART LABEL NOT IN WSL; WSL CANNOT RESTART AT PREVIOUS POINT OF FAILURE
PI84810
25_Aug
2017
UI49875


DB2 ADMIN TOOL - COMPARE STEP OF ANALYZE JOB FAILS WITH 'NO SYSINDEXPART ROW FOUND FOR CREATE INDEX' DB2V8 OR OLDER INDEX
PI76989
25_Aug
2017
UI49875


DB2 OBJECT COMPARISON TOOL - CLONE IS GENERATED IN CHECK DATA FOR TABLE SPACE THAT DOES NOT CONTAIN CLONE TABLE
PI80388
25_Aug
2017
UI49875


DB2 ADMIN TOOL ALTERING TABLE TO PBR SQLERROR ON CREATE COMMAND,PREPARE FUNCTION SQLCODE = -104
PI81716
25_Aug
2017
UI49875


ERROR UPDATING ZPARM UTILITY CONVERSION OF RBA IN OBJECT TO NOBASIC ON PANEL ADB2ZZUT
PI83187
25_Aug
2017
UI49875


DB2 ADMIN TOOL - REMOTE WSL BATCH GENERATION NOT WORKING
PI83840
25_Aug
2017
UI49875


DB2 ADMIN TOOL - UNABLE TO SET ZPARM QUERY_ACCEL_OPTIONS TO (2,5)
PI83892
25_Aug
2017
UI49875


ADDING PRODUCT TO DB2 TOOLS LAUNCHPAD MAY RESULT IN FOLLOWING ERROR MESSAGE: ENTRY WAS NOT ADDED TO TABLE ADBDMT - RC = 8
PI84585
25_Aug
2017
UI49875


DB2 ADMINISTRATION TOOL - ANALYZE FOR RECOVER WITH DDL ONLY DEFAULT ON ADB2C11A PANEL
PI85139
25_Aug
2017
UI49875


MINOR TYPO IN OBJECT COMPARE REPORT: COLUMN >COLUMN NAME< REORDERD
PI85408
25_Aug
2017
UI49820


DB2 ADMIN TOOL - CM BATCH COMPARE/ANALYZE THE JOB ENDS WITH RC=16 / SYSPRINT SHOWS ADB2PA PARSER ERROR
PI82966
25_Aug
2017
UI49875


NO PROVISION ON CCQPDB2 'DB2 PARAMETERS' PANEL TO OVERRIDE PARAMETERS BY SUBSYSTEM
PI84092
25_Aug
2017
UI49875


DDL LINE COMMAND FOR VIEW INSERTS FORMAT CHARACTERS X'0D15' INTO STATEMENT COLUMN OF SYSIBM.SYSVIEWS
PI84971
25_Aug
2017
UI49875


USE OF LIKE AND SAVE COMMANDS ON PANEL ADB21 SYSTEM CATALOG RESULTS IN TRUNCATION OF 'CRITERIA NOT SAVED'
PI85650
25_Aug
2017
UI49875


COMPARE FAILS WITH 'GOC2CMP - ERROR(S) FOUND' DECREASING # OF MAXPARTITIONS FOR IMPLICIT TABLESPACE;ONCODE=150 ERRORS
PI82181
25_Aug
2017
UI49875


DB2 ADMIN TOOL - COMPARE GENERATES DROP ON AUX INDEX WHEN SUPPRESS DROP OF OBJECTS SET TO YES
PI83150
25_Aug
2017
UI49875


ADB5031W MESSAGE AND SQLCODE -713 RUNNING ADBTEP2 RESTART
PI83306
17_Aug
2017
UI49637


DB2 OBJECT COMPARISION TOOL - ADBC002E SEVERE ERROR IN MERGE, ADDED FK ALREADY EXISTS
PI84319
17_Aug
2017
UI49643


IBM0818S ONCODE=1018 WHEN CM BATCH NAME PARAMETER IS MISSING AN APOSTROPHE
PI85069
17_Aug
2017
UI49641


DB2 ADMINISTRATION TOOL GOCCM IMPORT DOES NOT PARSE GENERATED ASIDENTITY
PI85409
17_Aug
2017
UI49639


DB2 ADMIN TOOL - CMBATCH CHANGES TARGET COLUMN TYPE TO 'FOR SBCS DATA' INSTEAD OF 'FOR BIT DATA'
PI83077
10_Aug
2017
UI49460


DB2 ADMIN TOOL - ADBTEMPL NOT USED FOR BATCH COMPARE
PI84033
10_Aug
2017
UI49468


CMBATCH JOB WITH VERFICATION MASKING RESULTS IN ONCODE 8097 IN COMPUTE_REXX_INPUT
PI73893
12_Jul
2017
UI48738


DB2 ADMIN TOOL ALTER TABLE TO ADD LOB COLUMN WHEN EXISTING LOB COLUMNS EXIST AND ALL HAVE EXPLICIT LOB TABLE SPACES
PI80083
12_Jul
2017
UI48736


PANEL ADB2C11A, "REQUIRED DATA SET INFORMATION" FIELDS "PDS FOR WSL" AND "PDS FOR ANALYZE JOB" CONTINUOUSLY GET RESET.
PI81346
30_Jun
2017
UI48499


DB2 ADMIN TOOL - RENAME OF A COLUMN IN TEMPORAL AND HISTORY TABLES RESULTED IN ANALYZE ERROR
PI74211
30_Jun
2017
UI48499


DB2 OBJECT COMPARISON TOOL FOR Z/OS - DROP OF TRIGGER GENERATED BUT NOT LISTED IN THE COMPARISON REPORT
PI81548
30_Jun
2017
UI48499


DB2 ADMIN TOOL - GRANT ON MIXED CASE PACKAGE NAMES FAILS. ROLL-UP OF OTHER FIXES.
PI81829
30_Jun
2017
UI48499


DB2 ADMIN TOOL - IMPROVE MESSAGE ADB8052E A CHANGE WAS FOUND FOR <OBJECT> BUT NO BASE DEFINITION WAS FOUND
PI76776
30_Jun
2017
UI48499


OBJECT COMPARISON TOOL VALIDATE STEP PROCESSING INDEX RESULTS IN ERRORS ADB3006E AND IBM0441W ONCODE=150
PI76636
30_Jun
2017
UI48499


SQLCODE = -20182 ERROR ON ATTEMPTED RECREATE OF PARTITIONING INDEX AFTER IT IS DROPPED
PI81303
30_Jun
2017
UI48499


DB2 ADMIN TOOL - IBM0342S ONCODE=340 THE SIZE CONDITION WAS WRITE_REPORT ENTRY POINT
PI73628
26_Jun
2017
UI48284
PI88904

'M' (DBRM) LISTED AS A VALID LINE COMMAND EVEN THOUGH IT IS NOT VALID.
PI76552
26_Jun
2017
UI48284
PI88904

DB2 ADMIN TOOL SQLCODE -530 TRANSFERRING STATISTICS
PI82940
26_Jun
2017
UI48284
PI88904

LIBDEF STILL OCCURS WITH LIBDEF(NO), CM OPTION ON MAIN MENU MAY RESULT IN SQLCODE 204
PI69690
26_Jun
2017
UI48284
PI88904

DB2 ADMIN TOOL ALTER XML PBG TABLESPACE MAXPARTITIONS NOT ALLOWED
PI77194
26_Jun
2017
UI48284
PI88904

DB2 OBJECT COMPARISON TOOL - INDEX SOURCE(X) AND TARGET(Y) (A)FIELD COMPRESS CHANGED FROM NO TO NO INDEX WILL BE ALTERED
PI77319
26_Jun
2017
UI48284
PI88904

DB2 ADMIN TOOL - AFTER APPLYING APAR PI65113 PANEL ADB2US STILL SEE THE F3 LOOP
PI78265
26_Jun
2017
UI48284
PI88904

DB2 ADMIN TOOL - INVOKING A REMOTE CONNECTION RETURNS RETCODE 16ISPP178 PANEL 'ADB2' ERROR
PI78500
26_Jun
2017
UI48284
PI88904

SQL CODE = -471 ERROR ATTEMPTING TO REVOKE PRIVILEGES EVEN THOUGH GET DB2 ZPARM IS SET TO NO
PI78729
26_Jun
2017
UI48284
PI88904

COMPARE JOB FAILS WITH ADB0351E MODULE : ADBCMPDB DETECTED AN ONCODE CONDITION 8094 AT INSERT_ADBCMPREPOBJLINES_DATA
PI79129
26_Jun
2017
UI48284
PI88904

APPLICATION PROGRAMMING DEFAULTS DO NOT DISPLAY FROM PANEL ADB2ZZMN IF ZPARM STORMXAB ABOVE 225
PI79884
26_Jun
2017
UI48284
PI88904

DB2 ADMINISTRATION TOOL WRONG LOAD STATEMENT GENERATED WHEN CHANGING UTF16 TABLE AND HPU DOES UNLOAD
PI80395
26_Jun
2017
UI48284
PI88904

INTERNAL APAR TO CARRY 12.1 FIX FOR APAR PI76886 AND PI75764
PI75768
26_Jun
2017
UI48284
PI88904

DB2 ADMIN TOOL CM BATCH INTERFACE PARAMETER "MASK_IGNORED_FIELDS" NOT WORKING
PI76745
26_Jun
2017
UI48284
PI88904

DDL COMMAND ON VIEWS GIVES MSG ADB2PA - AOC V 11.2/12.1.
PI77675
26_Jun
2017
UI48284
PI88904

DB2 ADMIN TOOL - CM/MTC IMPORT USING TARGET MASKS PROBLEM
PI78481
26_Jun
2017
UI48284
PI88904

ERRORS GENERATING DB2 SYSTEM PRIVILEGE GRANT REQUESTS AND DISPLAYING GLOBAL VARIABLES FOR USER AUTHORIZATIONS
PI81121
26_Jun
2017
UI48284
PI88904

DB2 ADMINISTRATION TOOL - REORG GENERATED EVEN WITH RUN_REORG_REBUILD = 'N'
PI81347
26_Jun
2017
UI48284
PI88904

DB2 ADMIN TOOL - SUPPORT ACCELERATOR FUNCTIONS IN BATCH INVOLVING LONG LIST OF TABLES (CLOB SIZE LIMIT)
PI82171
26_Jun
2017
UI48284
PI88904

DB2 ADMINISTRATION TOOL RELEASE NUMBER AND PROGRAM NUMBER INCORRECT ON LAUNCHPAD
PI80899
24_Jun
2017
UI48281


DB2 ADMIN TOOL - GEN AND DDL COMMANDS CANNOT PARSE UDF - ADB1933E / ADB2PA
PI72268
16_Jun
2017
UI48104


SQLCODE 100, "NO ROWS RETURNED" WHEN ADDING NEW PACKAGE
PI78189
16_Jun
2017
UI48107


SQLCODE = -203 WHEN LISTING A PLAN_TABLE WITH DB2 ADMIN TOOL
PI80110
13_Jun
2017
UI48022


DELIVERY OF VARIOUS FORWARD FITS AND FIXES
PI82074
13_Jun
2017
UI48016


DB2 ADMIN TOOL WITH APAR PI71905 ON DB2 V11CM OR DB2 V10 - INVALID OPERAND 'PERIODOVERRIDE' FOR KYWRD 'LOAD'
PI81570
9_Jun
2017
UI47922


CREATE MAY RESULT IN SQLCODE -206 BECAUSE OF INCORRECT DDL OR WSL GENERATED BY DB2 ADMIN TOOL
PI79944
9_Jun
2017
UI47922


DB2 ADMINISTRATION TOOL UNABLE TO PARSE THE DDL DEFINITION FOR A XML-BASED VIEW
PI78723
7_Jun
2017
UI47856


IKJ56545I MESSAGE RUNNING ADB2DSN DURING APPLY PHASE OF ANALYZE JOB
PI74209
24_May
2017
UI47552


PARAMETER IGNORED AND NOT FLAGGED IF INCORRECTLY PLACED UNDER DD ADBTEPIN
PI81446
24_May
2017
UI47545


RUN DDL UCD WORKFLOW - AOC 12.1
PI63630
23_May
2017
UI47474


SQLCODE = -478 WHEN DROPPING TRIGGER THAT DEPENDS ON SEQUENCE
PI73723
23_May
2017
UI47479


DB2 OBJECT COMPARISON TOOL - LONG VARCHAR/LONGVAR DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD LONG.
PI74800
23_May
2017
UI47491


PARSER ERROR GENERATING DDL FOR VIEW CONTAINING COLUMN NAMED 'ARRAY'
PI75021
23_May
2017
UI47482


DB2 ADMIN TOOL - ADBPLANS BIND JOB 'THE CHANGE MANAGEMENT "ALLOW CHANGE DELETE"' COMMENT MAY BE MISLEADING
PI68734
23_May
2017
UI47486


ALTERING A COLUMN WHICH IS PART OF AN EXTENDED INDEX AND PART OF A FOREIGN KEY MAY RESULT IN SQLCODE = -20180
PI81355
23_May
2017
UI47488


DB2 ADMIN TOOL - ADMIN ACCELERATOR LOAD STATEMENT DOES NOT LOAD ALL SELECTED ACCELERATED TABLES
PI76500
23_May
2017
UI47476


DB2 COMPARISON TOOL - COMPARISON OF A STORED PROCEDURE DOES NOT FIND SQL PATH CHANGE
PI80619
23_May
2017
UI47484


DB2 ADMINISTRATION TOOL - WSL MISMATCH (ADBC099E) AND PARTIAL ADMIN STATEMENTS IN WSL FOR IDAA RELATED OBJECTS
PI77789
19_May
2017
UI47324


ABILITY TO EDIT MULTIPLE COLUMNS AT A TIME DURING CREATE / ALTERTABLE
PI71414
17_May
2017
UI47316


ANALYZE OF CHANGE MAY END WITH ADB8052E
PI73042
17_May
2017
UI47327


GENERATING LONG DDL OF A VIEW MAY RESULT IN: ERROR IN COMMON_TABLE_EXPRESSION
PI80775
17_May
2017
UI47322


V12.1 PTF FOR APAR PI60995
PI60989
17_May
2017
UI47314


DB2 ADMIN TOOL SQLCODEN104 WITH OPTION P, I, 1
PI72598
17_May
2017
UI47319


DB2 OBJECT COMPARE - ADB2CMO DETECTED AN ONCODE CONDITION 451 INEXTEND
PI76067
17_May
2017
UI47321


INCOMPLETE DDL GENERATED WHEN MOVING XML TABLESPACE TO A DIFERENT STOGROUP.
PI72461
5_May
2017
UI46974


BINDS UNDER DB2 V11 CM FAIL WITH DSNT758I ATTEMPT TO USE NEW COMMAND OR OPTION (APPLCOMPAT(V11R1)) BEFORE NEW FUNCTION
MOD
PI78046
4_May
2017
UI46967


DB2 ADMIN TOOL TO GENERATE STEPLIB FOR DB2 SORT FOR HPU JOBS
PI78880
4_May
2017
UI46976


ALTER/MAKEPBR COMMAND FAILS USING CHANGE MANAGEMENT FOR 11.2 AND 12.1.
PI66050
27_Apr
2017
UI46780


DB2 ADMIN TOOL LOST DATA, MISSING DATA BETWEEN THE UNLOAD STEP AND LOAD STEP, MESSAGES:ADB5076I, ADB5077I, JOB ENDED RC4
PI71905
27_Apr
2017
UI46780


ERROR DURING LOAD IN DB2 V10: INVALID OPERAND 'OVERRIDE' FOR KYWRD 'LOAD'
PI71987
27_Apr
2017
UI46784


DB2 ADMIN TOOL CUSTOMIZATION: ALLOW IDAA ENTRIES TO BE SPECIFIED UNDER DB2 PARAMETERS
PI65180
27_Apr
2017
UI46780


SQLCODE = -104 GENERATING DDL FOR SP REFERENCING XMLELEMENT
PI72678
27_Apr
2017
UI46780


ADMIN TOOL ADB2GEN JOB ON VIEW MAY RESULT IN ERROR ADB1847E
PI70826
27_Apr
2017
UI46780


DB2 ADMIN TEMPORAL TABLES RENAME COLUMN RETURNS -601 ON HISTORY TABLE
PI73413
27_Apr
2017
UI46780


SUPPORT FOR NEW ADMIN ALTER STATEMENTS RELATING TO PARTITIONING FOR AOC 11.2 AND 12.1.
PI74820
27_Apr
2017
UI46780


COMPARE DOES NOT EXERCISE VER MASKS IN CM ANALYZE
PI70326
25_Apr
2017
UI46780


COMPARE GENERATES A WSL WITH TWO REORGS WHEN A PARTITION IS BEING ADDED TO A TABLE
PI76920
25_Apr
2017
UI46681


ISPF VIEW AS ALTERNATIVE TO BROWSE: NEW DRAW FUNCTION
PI77432
25_Apr
2017
UI46685


ADB5146E UNEXPECTED SQLCODE=-117 IN :INSERT DBETLIST WHEN UNLOADIS RESTARTED IN WSL.
PI65433
17_Apr
2017
UI46479


ADB2USOT ISPF PANEL DISPLAYED WITH TEXT "THIS PANEL SHOULD NEVER BE SEEN BY THE USER" IF 'DEBUG ON'
PI66511
13_Apr
2017
UI46416


PERFORMANCE QUERIES RETURNING INCORRECT RECOMMENDATIONS FOR TABLESPACES
PI68682
13_Apr
2017
UI46421


GENERATING DDL FOR TRIGGER CONTAINING NEXT VALUE FOR IN SELECT RESULTS IN IBM0421S ONCODE=520
PI71757
13_Apr
2017
UI46423


ADB7350E MODULE : ADB2CMF DETECTED AN ONCODE CONDITION 8094 IN CM30233 AT 37471 WHEN ATTEMPTING TO ALTER A PARTITIONING
INDEX
PI67084
13_Apr
2017
UI46419


DB2 ADMIN TOOL PANEL ADB25LE "UTILITY LISTDEF" LINE COMMAND DELETE RETURNS SQLCODE -104
PI75136
13_Apr
2017
UI46432
UI83314


DB2 ADMIN TOOL SPACE MANAGEMENT FOR IMPLICIT CREATED XML
PI76712
13_Apr
2017
UI46435


CONTEXT SENSITIVE HELP FOR AOC/TCZ PARAMETER "USER CMDS LIB(MBR)" NEEDS TO PROVIDE GUIDANCE.
PI76613
13_Apr
2017
UI46433


DB2 ADMIN TOOL ADB2GEN OF DATABASE RESULTS IN SQLCODE -305
PI69751
30_Mar
2017
UI46045


MIGRATE MAY FAIL WITH DSNU1218I ON A BLOB COLUMN UNLOAD
PI67247
30_Mar
2017
UI46038


SYSTEM PARAMETERS PANEL DISPLAYS BIF_COMPATIBILITY VALUE V9_TRIM AS BLANK
PI76109
30_Mar
2017
UI46048


CLARIFY MESSAGE APPEARING IN LAUNCHPAD PANEL ADBDMT REFERRING TO INSTALLED/ACTIVE PRODUCTS.
PI76889
30_Mar
2017
UI46050


DB2 ADMIN TOOL - 'ALL S' CMD DOESN'T LIST TS (FOR HISTORY TBS)
PI71342
2_Mar
2017
UI45191


SUPPORT REPAIR CATALOG COMMAND IN DB2 V11 COMPATIBILITY MODE
PI71909
2_Mar
2017
UI45191


DB2 OBJECT COMPARE CM BATCH COMPARE GETS ERROR ADB8014E IN THE ANALYZE DURING MERGE
PI72188
2_Mar
2017
UI45197


FROM THE CLIENT: I WOULD LIKE THE LISTDEF AS I TYPE IT IN, TO BELEFT EXACTLY AS
PI72861
2_Mar
2017
UI45191


DB2 ADMIN TOOL GEN ON STORED PROCEDURE RETURNS ADB1932W PARSER ERROR
PI74911
2_Mar
2017
UI45187


DROP VERSIONING NOT GENERATED BY ANALYZE WHEN BASE OR HISTORY TABLE IS DROPPED
PI67259
2_Mar
2017
UI45194
UI72229


-924 ERROR WHEN TRYING TO EXPORT STATISTICS FOR A TABLESPACE FROM A CATALOG COPY DURING MIGRATE
PI72759
2_Mar
2017
UI45202


SSID COMMAND MAY NOT SWITCH USER TO DIRECTLY TO SPECIFIED SUBSYSTEM
PI73625
2_Mar
2017
UI45205


VERIFICATION OF OBJECT FAILS WITH ADB2PA PARSER ERROR IF DDL CONTAINS A BLANK LINE
PI66055
2_Mar
2017
UI45191


ADBT007E - SQL ERROR ON ADBCHKPT TABLE, SQL CODE=- 305 SQL ERROR TOKENS: 20
PI67855
2_Mar
2017
UI45191


DB2 ADMIN TOOL CM BATCH REPLACE A CHANGE GETS RC12 ADB8007E
PI74777
2_Mar
2017
UI45191


CM BATCH COMPARE AND RUN WITHOUT THE CONTEXT OF A CHANGE
PI74779
2_Mar
2017
UI45191


SUPPORT FOR DATACHANGED AND LOCKMODE NONE ON THE ADMIN ACCELERATOR LOAD
PI76120
2_Mar
2017
UI45191


PRESERVE TABLE SPACE STATUS AFTER A CHANGE
PI75477
17_Feb
2017
UI44778


ONCODE =150 ERROR IN ADB2ZP IN DB2 V11
PI73409
31_Jan
2017
UI44358


DB2 ADMIN TOOL CMDS DOES NOT SHOW USER SPECIFIED TLIB
PI68758
31_Jan
2017
UI44350


DB2 ADMIN TOOL / OBJECT COMPARE TCZ GRANT TO PUBLIC
PI67906
30_Jan
2017
UI44333


SUPPORT DROP PACKAGE STATEMENT IN DB2 ADMIN TOOL PANELS
PI72725
9_Jan
2017
UI43764


DB2 ADMINISTRATION TOOL FOR Z/OS FOLLOW-ON PTF.
PI69960
14_Nov
2016
UI42602


DB2 ADMINISTRATION TOOL FOR Z/OS 12.1 GA PTF

Top of page