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 13.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PH63985
7_Nov
2024
UI98978


DB2 13 FL506 SUPPORT
PH59116
1_Nov
2024
UI98936


WHEN DOING A CLASSIC COMPARE USING THE PANELS, THE JOB ENDS WITH AN RC=4, WITH AN ONCODE=150 PRESENT IN THE OUTPUT.
PH62673
1_Nov
2024
UI98933
UI98978


MERGE FAILS TO HANDLE ALTER INDEX CHANGES RESULTING IN A ADB8062E ERROR MESSAGE
PH62810
1_Nov
2024
UI98932
UI98936


OBJECT COMPARE TOOL SETS INCORRECT APPLICATION COMPATIBILITY LEVEL WHEN PROCESSING VIEW
PH62856
1_Nov
2024
UI98935


INCORRECT DDL GENERATED WHEN ALTERING TRUSTED CONTEXT ON PANEL ADB26CN
PH63146
1_Nov
2024
UI98937


ANALYZE FOR MULTI-TARGET CHANGE DOES NOT USE PANEL TEMPLATES OR UTILITIES AND ONLY FIRST CHANGE IN SUBSYSTEM USES TEMPLATES
PH63770
1_Nov
2024
UI98934
UI98936


COMPARE JOB HANGING WHEN TWO REORGS ARE NEEDED FOR ONE OBJECT
PH63627
24_Oct
2024
UI98870


DB2 13 FL506 TOLERATION
PH63721
18_Oct
2024
UI98817


OBJECT COMPARE SIMPLIFICATION
PH63723
18_Oct
2024
UI98816


INDICATION OF THE REASON FOR CONVERSION BY DROP/CREATE
PH62774
11_Oct
2024
UI98715


OBJECT COMPARE- TRIGGER CHANGE IS NOT RECOGNIZED
PH63220
11_Oct
2024
UI98716


MAXPARTITIONS IGNORE CAUSES INCORRECT CONVERSION TO UTS
PH62270
10_Oct
2024
UI98718


OBJECT COMPARE JOB RESULTS IN MISSING AUX-TABLE
PH62857
10_Oct
2024
UI98717


ON THE PACKAGE COPY PANEL, THE LASTUSED VALUE QUITE OFTEN DOES NOT MATCH THE CORRECT VALUE
PH63545
7_Oct
2024
UI98680


EXTENDED COVERAGE FOR DB2 CATALOG GENERATED UTILITIES
PH63369
30_Sep
2024
UI98610


Db2 ADMINISTRATION TOOL QUALITY IMPROVEMENTS
PH63372
30_Sep
2024
UI98611


SUPPORT SYSACCELERATEDPACKAGES AND RELATED BIND OPTIONS IN DET
PH62045
24_Sep
2024
UI98531


DB2 UNLOAD USING ADBTEP2 INSTEAD OF DSNUPROC FOR SOME UNLOAD STEPS
PH62067
24_Sep
2024
UI98519


PARSER FAILS TO HANDLE GROUP BY GROUPING SETS CLAUSE FOR STORED PROCEDURES
PH62044
24_Sep
2024
UI98522


ADB7350E ADB2CMT MODULE : ADB2CMT DETECTED AN ONCODE CONDITION 520 IN COMPARE_TABLES
PH62040
24_Sep
2024
UI98525


ENHANCEMENTS TO THE CATNAV API
PH63072
12_Sep
2024
UI98395
UI98396


IMPROVEMENTS FOR NON-UTS PARTITIONED TABLESPACES
PH63073
12_Sep
2024
UI98396


GENERATE DDL FOR HIDDEN ROWID COLUMNS
PH60959
4_Sep
2024
UI98278


OBJECT COMPARE CAUSING MISSING INDEXES WHEN 'SUPPRESS DROP OF OBJECTS' OPTION IS SET TO 'NO'
PH62309
4_Sep
2024
UI98277
UI98519


ADMIN TOOL: ADB27AC COMPLETES WITH RC<8 BUT TABLE IS MISSING RECORDS AFTER A TABLE STRUCTURE CHANGE
PH61564
3_Sep
2024
UI98263


PANEL ADB2MSPC DB2 SPACE MANAGER POPS UP WHEN USING LINE COMMAND DSN ON PANEL ADB21S WHEN THE DATABASE IS DSNDB01 OR DSNDB06
PH61921
3_Sep
2024
UI98264
UI98396


HUFFMAN CLAUSE MISSING IN DDL VIA MIG LINE COMMAND
PH61841
3_Sep
2024
UI98266
UI98278


REBUILD MISSING FOR AN ALTERED INDEX RESULTS IN RUNSTATS UTILITY FAILURE
PH61812
3_Sep
2024
UI98262
UI98267
UI98396


OBJECT COMPARE FAILS TO DROP THE VIEW OF A HISTORY TABLE WHEN ALTERING THE DEFAULT VALUE OF A COLUMN
PH61784
3_Sep
2024
UI98267
UI98396


SQLCODE -546 ON ALTER TBL ADD CHECK CONSTRAINT
PH62842
3_Sep
2024
UI98261
UI98396

HIPER

INCORRECT PROCESSING OF SQL TYPE REQUEST
PH62234
19_Aug
2024
UI98013


PERFORMANCE ISSUES IN CATALOG NAVIGATION FOR PACKAGES 24/08/15 PTF
PECHANGE
PH62395
16_Aug
2024
UI98061


TCZ ENHANCEMENTS
PH61578
14_Aug
2024
UI98021


ADMIN TOOL UTILITIES OPTION "VG - RECOVER TO LAST GDG" NOT WORKING
PH61567
14_Aug
2024
UI98017


(ADB) IMPORTING MULTI-TARGET CHANGES ONLY IMPORTS FIRST FILE
PH61754
14_Aug
2024
UI98015


ISSUES WITH INLINE REORG IN NON-WSL APPLY JOB
PH61891
14_Aug
2024
UI98014
UI98396


OBJECT COMPARE DUPLICATE DROP VERSIONING ON TABLE DROP
PH61198
5_Aug
2024
UI97921


PROVIDE AL FUNCTIONALITY INTO ALT
PH62527
5_Aug
2024
UI97922


NEW OPTION IN COMPARE TO IGNORE COLUMN SHUFFLING
PH62529
5_Aug
2024
UI97918


PARSER IMPROVEMENTS TO CATCH DDL ERRORS FOR INDEXES
PH60092
22_Jul
2024
UI97738


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


IMAGE COPY MISSING OR INCORRECT WITH CERTAIN PARAMETERS USING CM BATCH
PH61070
22_Jul
2024
UI97732


Include support for DATE/TIME and other column types for the ALTER/RENAME COLUMN option
PH61315
22_Jul
2024
UI97728


ADMIN TOOL : CONVERTING DATABASE FROM EBCDIC TO UNICODE WITH PROPAGATE = YES FAILS TO UPDATE IMPLICIT TABLESPACE
PH61301
22_Jul
2024
UI97729


ERROR "NOVALUE CONDITION RAISED" IN ADB22SQL WHEN USING PANEL OPTION 2.2, RUN OR EXPLAIN SQL STATEMENTS
PH61365
22_Jul
2024
UI97734
UI97738


INCORRECT TEMPLATE NAME IN CHANGE MANAGEMENT PROCESS
PH61355
22_Jul
2024
UI97730


ADMIN TOOL V550: ONCODE= 8094. ONLOC=ADB2SYS. ONLINE= 417
PH62034
22_Jul
2024
UI97733


SUMMARY REPORT IS NOT GENERATED PROPERLY FOR SOURCE OF OBJECT TYPE SEQUENCE
PH62129
3_Jul
2024
UI97578


SUPPORT FOR STATISTICS PROFILE TEXT
PH62122
3_Jul
2024
UI97579


SUPPORT REORG AND CHECK DATA UTILITY OPTIONS
PH59114
1_Jul
2024
UI97544


SETTING USE DEFER YES TO YES IN THE GOC5 PANEL CAUSES WSL TO FAIL WITH RC=08
PH59779
1_Jul
2024
UI97551


FOREIGN KEY NOT RECREATED AFTER IMPLICIT DROP VIA OBJECT COMPARE
PH60655
1_Jul
2024
UI97548


ADMIN TOOL: AUTOMATICALLY SET LOCKPART = NO WHEN THE MAKEPBG COMMAND IS ENTERED AND NUMPART = 0 OR 1
PH60604
1_Jul
2024
UI97547
UI97734
UI97738


GDG DSN TEMPLATES CREATED IN ADB25TU PANEL GENERATES INCORRECTLY IN WORKLIST
PH60743
1_Jul
2024
UI97549


ADMIN TOOL: INCORRECT DB2 SUBSYSTEM NAME ON ADB2ED3 PANEL
PH61270
1_Jul
2024
UI97546


OBJECT COMPARE ONCODE=612 WHEN DEFAULT IS DROPPED
PH61382
1_Jul
2024
UI97552
UI97738


PANEL ADB2USV REPORTS DIFFERENCE ON TABLESPACE TYPE
PH61626
1_Jul
2024
UI97553
UI97738


ADBTEP2 ERROR WHEN AUTOREBIND=ALL
PH61897
20_Jun
2024
UI97396


INDICATION OF THE REASON FOR CONVERSION BY DROP/CREATE FOR INSERTED COLUMNS
PH61707
14_Jun
2024
UI97338


SUPPORT REDIRECTED RECOVERY FOR INDEXES
PH61705
14_Jun
2024
UI97339


June 2024 Bug Fixes
PH61704
14_Jun
2024
UI97340


PROVIDE AN OPTION TO GENERATE TS/TB DDL IN PHYSICAL PARTITION ORDER IN GEN
PH59493
10_Jun
2024
UI97261


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


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


APPLY JOB FAILS TO PROCESS A TABLE WITH LOWERCASE NAME
PH60656
10_Jun
2024
UI97254
UI97340


OBJECT COMPARE: SQLCODE -104 WHEN COMPARE ALTERS OLD VARCHAR COLUMN
PH60615
10_Jun
2024
UI97255


PANEL ADB27PGA IS SHOWN WHEN BEST UTILIZATION IS ALREADY ACHIEVE
PH61039
10_Jun
2024
UI97256


DROP/CREATE OF TABLE TO ALTER UNICODE VARCHAR COLUMN
PH61492
10_Jun
2024
UI97253


DIRECT LAUNCHING ISPF PANEL ADB2E CAUSES SQLCODE -104
PH61230
30_May
2024
UI97102


OPTIMIZE MEMORY USAGE IN MERGE AND OBJECT COMPARE
PH59690
20_May
2024
UI96965


ONCODE 9 DURING COMPARE WITH SOURCE DDL WITH HISTORY TABLE
PH60244
20_May
2024
UI96968
UI96969


MERGE INCORRECTLY DELETES WRONG COLUMN RECORDS WHICH LEADS TO SEVERE ERROR ADB7382S
PH60369
20_May
2024
UI96959


SOME COPY OPTIONS ARE IGNORED BY MIGRATE
PH60417
20_May
2024
UI96969


INCORRECT INDEX DSSIZE WHEN DEFAULT PAGENUM VALUE IS USED
PH60554
20_May
2024
UI96967


CM BATCH GENERATES INCORRECT APPLCOMPAT
PH60690
20_May
2024
UI96964
UI97261
UI98013
PH62234

ADMIN TOOL: PACKAGES BOUND BEFORE V12R1M505 ARE NOT RETURNED WHEN DISPLAYING PACKAGES
PH61141
20_May
2024
UI96960


TCZ PRODUCT PARAMETER "COLLECTION ID" DID NOT ALTER STORED PROCEDURES THAT REFERENCE COLLID
PH61339
20_May
2024
UI96971


INSUFFICIENT INPUT VALIDATION FOR STATIME_DDF ZPARM
PH61395
20_May
2024
UI96972


ISPF ERROR ON PANEL ADBH WHEN EMULATOR CONFIGURATION IS 24X80
PH61154
10_May
2024
UI96854


INTERNAL APAR SEPARATE LOCATION STATS FROM STATIME_MAIN SUPPORT
PH61291
10_May
2024
UI96855


SUPPORT DB2 V13 FL505 E24380 TEMPORAL SECURITY-RELATED CATALOG TABLES
PH60436
7_May
2024
UI96801


INTERNAL APAR SUPPORT DISPLAY AND ALTER OF INDEX AND INDEX PARTITION'S DSSIZE
PH61157
7_May
2024
UI96802


SUPPORT FOR SQL DATA INSIGHTS
PH61155
7_May
2024
UI96803


INTERNAL APAR RESOLVE INCONSISTENCIES IN CM BATCH UTILITY OPTION VALUES
PH61066
1_May
2024
UI96735


DB2 13 FL505 TOLERATION
PH59454
26_Apr
2024
UI96702


DROP IMPACT ANALYSIS SUMMARY - LOB TS NOT CONSIDERED
PH59873
26_Apr
2024
UI96701


ON PANEL ADB21KF, CAPITALIZE THE SHORT FORM TO BE ENTERED FOR PLANMGMTSCOPE FIELD OPTIONS "PREVIOUS" AND "PHASEOUT".
PH59833
26_Apr
2024
UI96700


INCONSISTENT RESULTS OCCUR WHEN RUNNING RTS LINE COMMAND AFTER UNSUCCESSFUL RH LINE COMMAND IN PANEL ADB21S
PH60204
26_Apr
2024
UI96703


RC=28 IN ADBGAJOB ON PBR-TO-PBG CONVERSION WITH EMBED IFF INTO WSL
PH60281
26_Apr
2024
UI96707


GENERATION OF COPY UTILITY JCL TAKES A LONG TIME WHEN DONE FROM A LIST OF TABLE SPACE PARTITIONS
PH60416
26_Apr
2024
UI96705


GRANT MANAGEMENT NOT GENERATING ADBTEP2 JOB AFTER "PRIVILEGES" OPTION
PH60622
26_Apr
2024
UI96704


ADMIN TOOL - TCZ ADBSETUP JOB FOR GRANT MANAGEMENT: SUPPORT ONEINDEX CLUSTER PER TABLE
PH60775
18_Apr
2024
UI96564


INCORRECT SCHEMA AND SCHEMA ALIAS INFO IN EXPLAIN MAINTENANCE PANEL CAUSES ERRORS
PH60855
18_Apr
2024
UI96568


INTERNAL APAR FOR BUG SMASH 2023 (PHASE 3).
PH60828
18_Apr
2024
UI96566


INTERNAL APAR TO NON-DISRUPTIVE ADD COLUMN NOT NULL WITH NO DEFAULT
PH60926
18_Apr
2024
UI96565


UTILITY HISTORY ENHANCEMENTS
PH59092
10_Apr
2024
UI96462


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


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


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


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


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


TWO SORTDEVT OPTIONS FOR LOAD DATA ARE GENERATED WHEN MIG PANEL ADB28M INPUT FIELDS UNLOAD METHOD = HPU AND PARALLEL
UTILITIES =
PH59677
10_Apr
2024
UI96480


RTS PANEL SHOWS INCORRECT INFORMATION FOR ACTIVE PAGES AND MESSAGE ADB255E IS UNDOCUMENTED AND NOT INFORMATIVE ENOUGH
PH60268
10_Apr
2024
UI96482


SOME OPTIONS ARE MISSING WHEN SAVING/RESTORING MIGRATE SPECIFICATIONS
PH60390
29_Mar
2024
UI96328


ENHANCE EXPLAIN TABLE MAINTENANCE
PH60526
29_Mar
2024
UI96323


(ADB) INTERNAL APAR FOR SUPPORT FOR MISSING REPAIR UTILITY OPTIONS.
PH60534
29_Mar
2024
UI96325


INTERNAL APAR FOR IDAA V7 TRACE ENHANCEMENTS
PH60529
29_Mar
2024
UI96327


SUPPORT FOR MORE GRANULAR MONITOR CONNECTIONS FOR SECURITY PROFILES
PH60528
29_Mar
2024
UI96324


(ADB) INTERNAL APAR FOR ADB27C PANEL CONSTRAINT/PRIMARY KEY COLUMN FLAG
PH60527
29_Mar
2024
UI96326
UI96471


INTERNAL APAR FOR SUPPORT FOR CREATE TABLE LIKE STATEMENTS IN COMPARE
PH58606
25_Mar
2024
UI96225
UI96231


DROP OF MQT TABLE SPACE VIA OBJECT COMPARE GENERATING UNNECESSARY DROP TABL
PH58607
25_Mar
2024
UI96226
UI96231


ADB7350E ADB2CMT MODULE : ADB2CMT DETECTED AN ONCODE CONDITION 520 IN CM10033
PH58787
25_Mar
2024
UI96231


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


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


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


KEYWORD UNIT IS DUPLICATED IN UTILITY TEMPLATE WHEN CHANGE IS RUN USING CM BATCH
PH60368
25_Mar
2024
UI96229


CHANGE MANAGEMENT ANALYZE REPORTING INCORRECT PAGENUM DURING ALTER OF PBR
PH60091
15_Mar
2024
UI96104


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


INTERNAL APAR FOR BUG SMASH 2023 (PHASE 2)
PH59776
1_Mar
2024
UI95902
UI96326


INTERNAL APAR FOR PARSER IMPROVEMENTS TO CATCH DDL ERRORS FOR TABLES
PH58311
26_Feb
2024
UI95823


QUERYACCELERATION BIND OPTION STICKING
PH58313
26_Feb
2024
UI95812


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


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


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


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


COMPARE DOES NOT HANDLE CHANGES TO APPLCOMPAT FOR TRIGGERS
PH59016
26_Feb
2024
UI95806
UI95817


ADMIN TOOL: COLUMN CHANGE FAILS WHEN IT REQUIRES A NEW BUFFER POOL BECAUSE OF LARGER PAGESIZE
PH59774
16_Feb
2024
UI95716


INTERNAL APAR HYBRID REBIND SOLUTION
PH57667
2_Feb
2024
UI95541
UI95808


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


PROBLEM OCCURS WHEN ALT IMMEDIATE CHANGE IS DONE ON AN ACCELERATED TABLE
PH57686
2_Feb
2024
UI95537


DB2 ADMIN SQLCODE : -338 SELECT TABLES - DBNAME IN FIELD: IN DB/COLL
PH57997
2_Feb
2024
UI95543


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


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


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


IMPROVE ADB3002E MESSAGE IN DDL VALIDATION WHEN TABLESPACE IS DROPPED IMPLICITLY
PH59324
29_Jan
2024
UI95462


INTERNAL APAR FOR CMDS INTERFACE UPDATES
PH55470
25_Jan
2024
UI95422


INTERNAL APAR TO GENERATE ALTER VIEW REGENERATE FOR ALTER COLUMN CHANGE
PH58569
17_Jan
2024
UI95259


USING "DB2" FOR TCZ GRANT MANAGEMENT PARAMETER "STOGROUP VCAT" RESULTS IN INCORRECT VCAT VALUE
PH54523
16_Jan
2024
UI95252


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


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


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


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
UI95242
UI95422


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


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


DB2 ADMIN TOOL: ALLOCATION ERROR WITH GCMDS COMMAND
PH58846
3_Jan
2024
UI95100


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


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


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


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


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


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


KC LINE COMMAND SHOWING INCORRECT PACKAGE VERSION AND DET COMMAND ON PACKAGE HANGS
PH56729
15_Dec
2023
UI94958


LISTAGG FUNCTION IN ALT INDEX CAUSES SQL ERROR ON DB2 12 FL500
PH56916
15_Dec
2023
UI94963


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


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


(ADB 13) INTERNAL APAR PH58226 SUPPORT UNLOAD NOPAD FOR CATALOG COPY
PH58388
5_Dec
2023
UI94723


INTERNAL APAR PH58388 4Q 2023 AOC12 DEFECT BACKLOG REDUCTION EPIC (AOC12 AND 13)
PH58387
5_Dec
2023
UI94724


(ADB) INTERNAL APAR PH58387 FOR 4Q 2023 ADMIN V13 BASE BACKLOG DEFECT REDUCTION (AOC13 ONLY)
PH56416
30_Nov
2023
UI94666


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


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


POOR PERFORMANCE OF AN SQL QUERY AFTER RUNNING SQ LINE COMMAND
PH56370
22_Nov
2023
UI94588


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


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


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


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


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


(ADB) PH57692 INTERNAL APAR TO MANAGE APPLCOMPAT ON INDEXES
PH58019
15_Nov
2023
UI94475


INTERNAL APAR PH58019 DEPLOYMENT OF REST SERVICES
PH58136
15_Nov
2023
UI94477


(ADB) INTERNAL APAR PH58136 SAVE AND RESTORE MIGRATE SPECIFICATIONS
PH58158
15_Nov
2023
UI94474


PH58158 ADD MAXPARTITIONS SUPPORT TO MOVETB PANEL ADB2MVT1
PH55610
9_Nov
2023
UI94404
UI94593


SB COMMAND ON ALIAS OBJECT IN PACKAGE DEPENDENCIES RESULTS IN DSNT408I SQLCODE = -199,
PH56172
9_Nov
2023
UI94402


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


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


RTS LINE COMMAND ON PANEL ADB21S RETURNS 0 ROWS WHEN ROWS EXISTS WHEN USING DDF
PH57107
9_Nov
2023
UI94400
UI94481


FIELD RO SHOWS BLANK IN DB2X APPLICATION PLANS (PANELID ADB21P)
PH57348
9_Nov
2023
UI94407


ADMIN TOOL V13: PANEL ADB21SAR SHOWSINVALID VALUE MESSAGE FOR TABLE SPACES WITH COMPRESS = NULL OR '?'
PH57600
9_Nov
2023
UI94405


ADD TCZ PROVISION TO CREATE ONE OR MORE GRANT MANAGEMENT DATABASES/HUBS
PH57761
3_Nov
2023
UI94263


INTERNAL APAR DB2 13 FL504 TOLERATION AND SUPPORT
PH57695
28_Oct
2023
UI94203


INTERNAL APAR PH57695 GRANT MANAGEMENT FOLLOW-ON IMPROVEMENTS
PH57694
27_Oct
2023
UI94201


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


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


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


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


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


Import DDL to recreate a table without CREATE TS should have error message to include TS in DDL.
PH56015
16_Oct
2023
UI94035


POOR SQL PERFORMANCE USING ICS COMMAND ON UTILITY HISTORY PANEL ADB2Z2H1
PH56225
16_Oct
2023
UI94031
UI94033


OBJECT COMPARE USES TABLE NAME FOR DROP TRIGGER STATEMENT WHEN EXPLICITLY DROPPING TRIGGER
PH56964
16_Oct
2023
UI94034


CHOOSING RANDOM FOR A NOT PADDED INDEX DOESN'T PREVENT USER ON PANEL ADB21XAR
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
UI94203


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
PH60091

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