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: 11 October 2023
DB2 Administration Tool Version 13.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PH57198
9_Oct
2023
UI93945


INTERNAL APAR PH57198 ALLOW SPECIFYING SOURCE/TARGET OBJECTS FROM AN SQL SELECT STATEMENT IN COMPARE
PH57204
9_Oct
2023
UI93948


GRANT MANAGEMENT MESSAGE UPDATES.
PH57227
9_Oct
2023
UI93949


INTERNAL APAR SUPPORT NEW DB2 ZPARMS.
PH54720
27_Sep
2023
UI93769


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


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


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


CMBATCH SUPPORT FOR GENERATING FOREIGN KEY CHANGES WHEN CALLING GOCCM
PH55699
27_Sep
2023
UI93767


INCORRECT VALUES IN INTERPRETATION PANEL (ADB21KDI) WHEN DOING LINE COMMAND 'I' FROM ADB21KDS (PACKAGE DEPENDENCIES AT ST
LVL)
PH55727
27_Sep
2023
UI93756
UI93769


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


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


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


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


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


(ADB) INTERNAL APAR SUPPORT FOR MISSING LOAD UTILITY OPTIONS
PH53247
13_Sep
2023
UI91179
UI91758


ADB2GEN FAILS WITH S0C4-00000004 WHEN GEN JOB CONTAINS SQLCMTS='Y'
PH56326
11_Sep
2023
UI93533


INTERNAL APAR FOR PARSER IMPROVEMENTS (TABLESPACE).
PH56749
11_Sep
2023
UI93534


INTERNAL APAR TO PROVIDE OPTION TO MAP SOURCE & TARGET OBJECTS (MANAGED PROMOTIONS)
PH52643
5_Sep
2023
UI93444


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


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


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


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


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


UNSUPPORTED DB2 RELEASE ERROR IN OBJECT COMPARE
PH55210
5_Sep
2023
UI93448


REPORT REVOKE IMPACT DOES NOT REPORT ON SOME OR ALL VIEWS BEING DROPPED.
PH56285
16_Aug
2023
UI93216


INTERNAL APAR FOR GRANT MANAGEMENT SYSTEM.
PH54621
10_Aug
2023
UI93146
UI93216


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


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


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


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


MISLEADING TEXT "COMMANDS:" APPEARS ON PANELS ADB2MES AND ADB2MEX WHEN COMMAND(S) ARE NOT YET AVAILABLE.
PH55698
10_Aug
2023
UI93134
UI93216


WHEN OPTION 2H IS SELECTED ON PANEL ADB2Z, "INVALID CMD" IS DISPLAYED.
PH55780
31_Jul
2023
UI92973

HIPER

SELECT LEFT OUTER JOIN NEEDED FOR SYSENVIRONMENT TABLE
PH53653
24_Jul
2023
UI92880


PARSER ERROR DURING WSL VALIDATE STEP OF COMPARE
PH54580
24_Jul
2023
UI92870


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


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


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


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


WHEN ANALYZING SOURCE VF THAT HAS EMPTY DEFAULT VALUE FOR WLM ENVIRONMENT FIELD CAUSES SQLCODE=-104
PH55739
17_Jul
2023
UI92744


USE LISTDEF WHEN GENERATING UTILITIES
PH53913
10_Jul
2023
UI92673


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


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


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


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


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


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


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


ADMIN TOOL: PROBLEMS WITH ADB21KSE PANEL EXPLAIN COMMAND
PH37650
5_Jul
2023
UI92598


Generate ALTER VIEW REGENERATE using Application Compatability in Admin & OC
PH54753
5_Jul
2023
UI92597
UI92598


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


INTERNAL APAR BUGSMASH 2022
PH53065
12_Jun
2023
UI92211


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


ABSTRACT: OBJECT COMPARE DOES NOT SUBSTITUTE COMPRESS YES FIXEDLENGTH WITH COMPRESS YES ON DB2 Z/OS FLS < FL509
PH53874
12_Jun
2023
UI92214


LOAD UTILITY DISCARDS VALUES DURING CHANGE WITH UNICODE TABLE
PH52644
12_Jun
2023
UI92213


ADMIN TOOL: DET COMMAND ON A V13-BOUND PACKAGE SHOWS INCORRECT DETAILS
PH54657
5_Jun
2023
UI92091


INTERNAL APAR DSNTYPE_LARGE OPTION TO INCREASE SPACE FOR LARGE UTILITY DDS.
PH54154
2_Jun
2023
UI92090


INTERNAL APAR ALTER COLUMN SUPPORT IN AL (PHASE 2)
PH54716
2_Jun
2023
UI92089


INTERNAL APAR HANDLE MISSING TABLESPACE AND INDEX ATTRIBUTES IN CREATE/ALTER FLOW (PANELS).
PH54723
2_Jun
2023
UI92087


INTERNAL APAR SUPPORT NEW DSN_PROFILE_ATTRIBUTES VALUES
PH51730
23_May
2023
UI91950


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


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


ADMIN TOOL - MANAGE FAST INDEX TRAVERSAL PANEL ERROR (PANEL ADB2Z2I2)
PH52954
23_May
2023
UI91956


ALLOCATION ERROR WITH GCMDS COMMAND IN DB2 ADMIN TOOL
PH53444
23_May
2023
UI91948


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


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


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


INTERNAL APAR MASKING SUPPORT FOR REMOVING KEY LABEL.
PH53409
10_May
2023
UI91758


NEW MASKING SERVICE/STORED PROCEDURE
PH49831
1_May
2023
UI91586
UI91772


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


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


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


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


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


DB2 ADMINISTRATION TOOL - SELECT FOR REMOTE TABLES RETURNS NO ROWS
PH52274
1_May
2023
UI91605


ADMIN TOOL: (V13 ONLY) REORG PART X WITHOUT COPYDDN WHEN USING PANEL ADB2314
PH52437
1_May
2023
UI91588
UI91594


ADMIN TOOL: "SQLCODE = -331, ERROR: CHARACTER CONVERSION ERROR PANEL ADB21K LINE CMD KC, ON A PACKAGE CREATED IN DB2 Z/OS
V13
PH53408
1_May
2023
UI91640


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


FAST INDEX TRAVERSAL OPTION OF RUNNING INDEXTRAVERSECOUNT RESULTS
PH53655
18_Apr
2023
UI91485


ADB1031E ERROR WHEN CALLING ADBGDDL
PH52343
13_Apr
2023
UI91446


ALTER RELATED CONSTRAINTS SUPPORT
PH51813
10_Apr
2023
UI91308
UI91556
UI92089


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

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


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


GENERATED AOC/TCZ JOB ASSOCIATED WITH TEMPLATE ADBCVUTS IS MISSING VALUES FOR OWNER AND SCHEMA.
PH52163
10_Apr
2023
UI91254


ADMIN TOOL V13: ALTPART COMMAND ABENDS WITH USER COMPLETION CODE=4039 REASON CODE=00000000
PH53236
4_Apr
2023
UI91281


AVOID DEFAULTING BUFFERPOOL
PH53235
28_Mar
2023
UI91180


EMBED IFF-FILE INTO WSL
PH51646
21_Mar
2023
UI91047


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


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


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


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


ADMIN TOOL - CLREST COMMAND: "PROCESSING ERROR" MESSAGE
PH51895
20_Mar
2023
UI90957
UI91281


COMPARE PRE VERSION 12 (FL500) OBJECTS - GEN DDL AGAINST THE CATALOG - GIVING ALTERS FOR SECQTY IN INDEXES.
PH51155
20_Mar
2023
UI91045


ADMIN TOOL:Z.2H CAUSES SQLCODE = -104, ERROR:ILLEGAL SYMBOL WHEN DSNHDECP DECIMAL PARM IS SET TO COMMA
PH50946
17_Mar
2023
UI91023


DEFECT BACKLOG
PH52919
17_Mar
2023
UI91022


NEW QUERY_ACCEL_OPTIONS ZPARM VALUE
PH52918
13_Mar
2023
UI90925


DB2 13 FL503 TOLERATION AND SUPPORT
PH50758
1_Mar
2023
UI90769
UI90811


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


ELIMINATE UNNECESSARY REORGS WHEN RUNNING CHANGES
PH49614
27_Feb
2023
UI90760
UI90811


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


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


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


REST SERVICES UPPER CASE OPTION RESETS INAPPROPRIATELY
PH51126
27_Feb
2023
UI90758
UI90760
UI90811


DUPLICATE REORG GENERATED FOR TABLESPACE
PH51314
27_Feb
2023
UI90756
UI90760
UI90811


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


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


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


SUPPORT FOR MISSING DB2 COPY UTILITY OPTIONS
PH52346
21_Feb
2023
UI90640


NEW SHARE_LOCKS KEYWORD FOR DSN_PROFILE_ATTRIBUTES
PH52574
21_Feb
2023
UI90638
UI92089


VALIDATE RANDOM RELATED INDEX OPTIONS ON PANEL ADB21XAR
PH45889
5_Feb
2023
UI90381


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

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


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
UI90395
UI90397


COMPARE GENERATES DROP/CREATE FOR DSSIZE CHANGE IF PARTITIONING IS IGNORED
PH50488
5_Feb
2023
UI90383
UI90775
UI91023


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


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


UNABLE TO GENERATE DDL FOR AN OBJECT STARTING WITH SPACE CHARACTER
PH50562
5_Feb
2023
UI90391
UI90397


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


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


UNLOAD FAILS FOR A TABLE IN INCOMPLETE STATE
PH50947
31_Jan
2023
UI90350


DB2 ADMIN TOOL INTERFACE TO SQLPA
PH51300
31_Jan
2023
UI90351


SQL FORMATTING AS A SERVICE
PH51888
31_Jan
2023
UI90348

HIPER

TOLERATION SUPPORT FOR DB2 13 PRDID CHANGE
PH49653
20_Jan
2023
UI90194
UI90198


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


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


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


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


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
UI90192
UI90194
UI90198


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


ACCELERATION OF A TABLE IS NOT RESTORED AFTER THE TABLE IS ALTERED
PH51453
20_Jan
2023
UI83975
UI90198


DDL command after ALTER produces additional attributes form SYSINDEXPART 23/01/20 PTF
PECHANGE
PH50383
20_Jan
2023
UI90184


DB2 ADMIN TOOL V13 GETTING INVALID LINE CMD ERROR IN PANEL ADB21I WHEN USING LINE CMD UT
PH48623
9_Jan
2023
UI83973
UI90665


WRONG TABLESPACE NAME USED AT START COMMAND
PH48786
9_Jan
2023
UI83973
UI90665


ADMIN TOOL ISSUES START SPACES RW TOO EARLY, AFTER DELETING 2 COLUMNS ON 2 TABLES WITH VERSIONING
PH50890
19_Dec
2022
UI83800


DB2 V13 FL502 TOLERATION AND SUPPORT
PH49058
9_Dec
2022
UI83665
UI90198


OBJECT COMPARE: CREATE TABLESPACE STATEMENT PARTITION ERRORS
PH49882
9_Dec
2022
UI83667
UI90198


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


ADMIN TOOL: DDL GENERATION WITH MASK IS NOT GENERATING DDL
PH47743
9_Dec
2022
UI83657
UI83800


ADMIN TOOL ERROR CONDITION RAISED DURING DET COMMAND ON PACKAGE
PH48741
9_Dec
2022
UI83661
UI90198


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


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


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


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


DB2 ADMIN TOOL FAILS TO ADD HISTORY TABLE TO ACCELERATOR V7.5.7
PH47258
16_Nov
2022
UI82697
UI82699
UI83663


OBJECT COMPARE ATTEMPTS TO EXPLICITLY CREATE AN IMPLICITLY CREATED AUX TABLE
PH47295
16_Nov
2022
UI82699
UI83663


OBJECT COMPARE: DB2_GENERATED_DOCID_FOR_XML IMPLICIT COLUMN NOT BEING IGNORED
PH47699
16_Nov
2022
UI83321
UI83663
UI90198


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


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


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
UI83311


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


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


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
UI83173


SUPPORT FOR LASTLOG REORG KEYWORD
PH50653
8_Nov
2022
UI83177


EXTENDED SUPPORT FOR > 30 BYTE COLUMN NAMES
PH49601
1_Nov
2022
UI83088
UI83663
UI83975
UI90198
PH51453

IGNORING CHANGES BETWEEN V12 AND MIGRATED PRE V12 OBJECTS
PH50333
1_Nov
2022
UI83086


ALLOW SPECIFICATION FOR REBIND PACKAGE OPTIONS
PH47791
21_Oct
2022
UI82972
UI83086


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


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


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


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


OBJECT COMPARE SHOULD NOT REPORT PATHSCHEMAS CHANGE
PH48246
21_Oct
2022
UI82974
UI83663
UI90198


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


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


NEW ADMIN ALTER STATEMENT INSERT COLUMN AFTER
PH49636
13_Oct
2022
UI82833


PANEL ADB2CRO HANGS AFTER CHANGE IS REGISTERED AND NEXT IS SELECTED
PH48215
3_Oct
2022
UI82693
UI82695
UI82823


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


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


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


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


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
UI82695
UI82823


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


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


EXTENDING SPACE ESTIMATION CAPABILITY
PH49639
27_Sep
2022
UI82568


CHANGE REORG SHRLEVEL DEFAULT TO CHANGE
PH46803
12_Sep
2022
UI82381


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


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


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


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


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


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


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
UI82194
UI82378


SUPPORT FOR COMPARE SMART REORG GENERATION
PH48927
31_Aug
2022
UI82193


ELIMINATE ADMIN DROP CREATE IN ALT INDEX
PH45856
18_Aug
2022
UI82019
UI82193


OBJECT COMPARE INCORRECTLY REPORTS CHANGES TO COMPRESS ATTRIBUTE
PH46574
18_Aug
2022
UI82015
UI82193


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


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


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


MOVETB LINE COMMAND GENERATES INCORRECT REORG UTILITY CONTROL STATEMENT
PH46616
18_Aug
2022
UI82014
UI83663


DB2 ADMIN TOOL UNLOAD FROM IMAGE COPY UNBALANCED PARENTHESES ERROR
PH46941
18_Aug
2022
UI82016
UI82193


OBJECT COMPARE REPORT DOES NOT INDICATE WHEN A STOP INDEX IS ISSUED.
PH47028
15_Aug
2022
UI81940
UI82016
UI82193


SQLCODE -625 WHEN ADDING A COLUMN TO AN INDEX AND PRIMARY KEY ONA TABLE
PH48508
15_Aug
2022
UI81942


ELIMINATE ADMIN DROP CREATE IN ALT TABLESPACE
PH47480
15_Aug
2022
UI81941


V13 GA ADDITIONAL FUNCTIONALITY APAR
PH45487
28_Jul
2022
UI81704
UI82381


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


DB2 AOC: WSL EDITOR LINE COMMAND PROBLEMS WITH LARGE DDL OBJECTS GREATER THAN 32704 CHARACTERS
PH45588
28_Jul
2022
UI81702
UI82375
UI82568


GENERATING APPLY JOBS RESULTS IN ADBGAJOB ERROR RC=12 WHEN ADDING INLINE REORG
PH45611
28_Jul
2022
UI81700
UI83177


PARSER FAILURE WHEN PROCESSING TRIM FORMAT
PH45652
28_Jul
2022
UI81701
UI82193


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


USING WORK STATEMENT LISTS FOR LOAD PROCESS VIA DB2 ADMIN TOOL OMITS LOADS CONTAINING 0 RECORDS IN THE LOAD SUMMARY REPORT
PH47981
25_Jul
2022
UI81642


ANALYZE AND RUN MTC CHANGES FOR TARGET SYSTEMS WHILE ON THE CENTRAL SYSTEM V13.1
PH48010
25_Jul
2022
UI81643


ADD OPTION FOR UNLOAD ALTERED TABLES TO ONLY UNLOAD DESTRUCTIVE ALTERS
PH47979
21_Jul
2022
UI81577


UPDATE MESSAGING IN COMPARE REPORT TO NOTIFY USER OF OTHER AFFECTED OBJECTS
PH47259
14_Jul
2022
UI81478
UI90762


IMPROVE USABILITY OF REST SERVICE PANEL ADB21RS
PH45301
14_Jul
2022
UI81482
UI92091


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


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


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


ISSUE 1: WHEN DB2 LIBRARIES ARE NOT SPECIFIED ON DB2 PARAMETERS PANEL CCQPDB2 BECAUSE THE DB2 LIBRARIES ARE USED FROM
LINKLIST,
PH47398
8_Jul
2022
UI81379


ROLLUP APAR FOR V12 DELIVERED FIXES
PH46162
25_May
2022
UI80656

HIPER

SUPPORT FOR DB2 ADMIN TOOL FOR Z/OS 13.1 GA PTF

Top of page