|
DB2 Administration Tool Version 13.1
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
2024 |
DROP IMPACT ANALYSIS SUMMARY - LOB TS NOT CONSIDERED | ||||
2024 |
ON PANEL ADB21KF, CAPITALIZE THE SHORT FORM TO BE ENTERED FOR PLANMGMTSCOPE FIELD OPTIONS "PREVIOUS" AND "PHASEOUT". | ||||
2024 |
INCONSISTENT RESULTS OCCUR WHEN RUNNING RTS LINE COMMAND AFTER UNSUCCESSFUL RH LINE COMMAND IN PANEL ADB21S | ||||
2024 |
RC=28 IN ADBGAJOB ON PBR-TO-PBG CONVERSION WITH EMBED IFF INTO WSL | ||||
2024 |
GENERATION OF COPY UTILITY JCL TAKES A LONG TIME WHEN DONE FROM A LIST OF TABLE SPACE PARTITIONS | ||||
2024 |
GRANT MANAGEMENT NOT GENERATING ADBTEP2 JOB AFTER "PRIVILEGES" OPTION | ||||
2024 |
ADMIN TOOL - TCZ ADBSETUP JOB FOR GRANT MANAGEMENT: SUPPORT ONEINDEX CLUSTER PER TABLE | ||||
2024 |
INCORRECT SCHEMA AND SCHEMA ALIAS INFO IN EXPLAIN MAINTENANCE PANEL CAUSES ERRORS | ||||
2024 |
INTERNAL APAR FOR BUG SMASH 2023 (PHASE 3). | ||||
2024 |
INTERNAL APAR TO NON-DISRUPTIVE ADD COLUMN NOT NULL WITH NO DEFAULT | ||||
2024 |
UTILITY HISTORY ENHANCEMENTS | ||||
2024 |
DB2 SPACE MANAGER PANEL APPEARS AFTER DSN LINE COMMAND IN ADB21S TABLESPACE PANEL FOR USER TABLE SPACE. | ||||
2024 |
WHEN PERFORMING A COMPARE WITH CM=YES, RUNNING THE CHG JOB FAILS DUE TO INCORRECT ALTERS ON TRIGGERS. | ||||
2024 |
DSNX200I SQLCODE -104 AND DSNT233I UNSUCCESSFUL BIND FOR PACKAGE | ||||
2024 |
THE PARSER DOES NOT SUPPORT THE PERIOD FOR .. CLAUSE IN CREATE TABLE | ||||
2024 |
ADMIN TOOL MOVETB DATA SET NOT CATALOGED | ||||
2024 |
TWO SORTDEVT OPTIONS FOR LOAD DATA ARE GENERATED WHEN MIG PANEL ADB28M INPUT FIELDS UNLOAD METHOD = HPU AND PARALLEL UTILITIES = |
||||
2024 |
RTS PANEL SHOWS INCORRECT INFORMATION FOR ACTIVE PAGES AND MESSAGE ADB255E IS UNDOCUMENTED AND NOT INFORMATIVE ENOUGH | ||||
2024 |
SOME OPTIONS ARE MISSING WHEN SAVING/RESTORING MIGRATE SPECIFICATIONS | ||||
2024 |
ENHANCE EXPLAIN TABLE MAINTENANCE | ||||
2024 |
(ADB) INTERNAL APAR FOR SUPPORT FOR MISSING REPAIR UTILITY OPTIONS. | ||||
2024 |
INTERNAL APAR FOR IDAA V7 TRACE ENHANCEMENTS | ||||
2024 |
SUPPORT FOR MORE GRANULAR MONITOR CONNECTIONS FOR SECURITY PROFILES | ||||
2024 |
(ADB) INTERNAL APAR FOR ADB27C PANEL CONSTRAINT/PRIMARY KEY COLUMN FLAG | ||||
2024 |
UI96471 |
INTERNAL APAR FOR SUPPORT FOR CREATE TABLE LIKE STATEMENTS IN COMPARE | |||
2024 |
UI96231 |
DROP OF MQT TABLE SPACE VIA OBJECT COMPARE GENERATING UNNECESSARY DROP TABL | |||
2024 |
UI96231 |
ADB7350E ADB2CMT MODULE : ADB2CMT DETECTED AN ONCODE CONDITION 520 IN CM10033 | |||
2024 |
REORG WITH USE PROFILE OPTION FAILS WHEN COLUMN IS DROPPED | ||||
2024 |
CURSOR NUMBER LIMIT IS REACHED IN WSL VALIDATE | ||||
2024 |
UPDATE SORT HELP PANEL TO REFLECT USE OF SORT SEQUENCE NUMBER | ||||
2024 |
KEYWORD UNIT IS DUPLICATED IN UTILITY TEMPLATE WHEN CHANGE IS RUN USING CM BATCH | ||||
2024 |
CHANGE MANAGEMENT ANALYZE REPORTING INCORRECT PAGENUM DURING ALTER OF PBR | ||||
2024 |
OBJECT COMPARE TOOL IS GENERATING WORKLIST IN WRONG ORDER, CAUSING SQLCODE -628 ON APPLY JOB 24/03/15 PTF PECHANGE |
||||
2024 |
INTERNAL APAR FOR BUG SMASH 2023 (PHASE 2) | ||||
2024 |
UI96326 |
INTERNAL APAR FOR PARSER IMPROVEMENTS TO CATCH DDL ERRORS FOR TABLES | |||
2024 |
QUERYACCELERATION BIND OPTION STICKING | ||||
2024 |
CHANGE IN TRIGGER EXECUTION ORDER IS NOT DETECTED IN CM ANALYZE | ||||
2024 |
COMPARE REPORTS TABLE AS ALTERED WHEN NO CHANGES ARE NEEDED | ||||
2024 |
INTERPRET PANELS ADB21KI1 AND ADBP1KSI HAVE INVALID OR INADEQUATE DESCRIPTION OF COPYID VALUES | ||||
2024 |
"INVALID DATASET NAME" ERROR MESSAGE OCCURS WHEN ZFS FILE IS SPECIFIED FOR "LIBRARY" | ||||
2024 |
COMPARE DOES NOT HANDLE CHANGES TO APPLCOMPAT FOR TRIGGERS | ||||
2024 |
UI95817 |
ADMIN TOOL: COLUMN CHANGE FAILS WHEN IT REQUIRES A NEW BUFFER POOL BECAUSE OF LARGER PAGESIZE | |||
2024 |
INTERNAL APAR HYBRID REBIND SOLUTION | ||||
2024 |
UI95808 |
PARSER ERROR WHEN GENERATING DDL FOR ADVANCED TRIGGER | |||
2024 |
PROBLEM OCCURS WHEN ALT IMMEDIATE CHANGE IS DONE ON AN ACCELERATED TABLE | ||||
2024 |
DB2 ADMIN SQLCODE : -338 SELECT TABLES - DBNAME IN FIELD: IN DB/COLL | ||||
2024 |
ISPP153 PANEL 'ADB21S' ERROR (OR 'ADB21D'); INVALID QUOTED STRING, END QUOTE OR CONTINUATION ("+") MISSING | ||||
2024 |
ADMIN TOOL: -551 ERROR ON SYSIBM.SYSENVIRONMENT | ||||
2024 |
CONSTRAINT AND PRIMARY KEY ARE MISSING FROM GENERATED CREATE TABLE AND ALTER TABLE DDL. | ||||
2024 |
IMPROVE ADB3002E MESSAGE IN DDL VALIDATION WHEN TABLESPACE IS DROPPED IMPLICITLY | ||||
2024 |
INTERNAL APAR FOR CMDS INTERFACE UPDATES | ||||
2024 |
INTERNAL APAR TO GENERATE ALTER VIEW REGENERATE FOR ALTER COLUMN CHANGE | ||||
2024 |
USING "DB2" FOR TCZ GRANT MANAGEMENT PARAMETER "STOGROUP VCAT" RESULTS IN INCORRECT VCAT VALUE | ||||
2024 |
PARSER ERROR: UNEXPECTED TOKEN AFTER VARIABLE KEYWORD - EXPECTED KEYWORD CCSID | ||||
2024 |
DDL READER ERROR WHEN LEAVE FOUND IN SP BODY | ||||
2024 |
ISPT034 TABLE IS NOT OPEN ERROR IN ADB28SC JOB TBBOTTOM ISSUED FOR TABLE ADB28XCL THAT IS NOT OPEN CC 990 | ||||
2024 |
UI95422 |
SUBSCRIPTRANGE ONCODE 520 IN CM30251 OR STORE_TGT_VIEW WHEN COMPARING SOURCE AND TARGET CREATE VIEW DDL WITH MANY TABLE REF. |
|||
2024 |
UI95422 |
OBJECT COMPARE INCORRECTLY GENERATES THE CHECK DATA AFTER FIRST FOREIGN KEY CHANGE, LEADING TO SQLCODE = -20385 | |||
2024 |
WHEN MAKEPBG ON PANEL ADB21SAR IS ENTERED FIRST, CHANGE TO PART LEVEL ATTRIBUTES (I.E., PRIQTY) ARE IGNORED. | ||||
2024 |
DB2 ADMIN TOOL: ALLOCATION ERROR WITH GCMDS COMMAND | ||||
2024 |
BUG SMASH 2023 (PHASE 1) | ||||
2023 |
ADMIN TOOL RETURNS MISLEADING PACKAGE DEPENDENCIES FOR INDEXES | ||||
2023 |
REPLICATION ON IDAA FAILS TO BE ENABLED FOLLOWING TABLE NAME CHANGE | ||||
2023 |
SQLCODE=-205 ERROR WHEN QUOTED COLUMN NAMES AND CHECK CONSTRAINT INCLUDED | ||||
2023 |
CHANGE VIEW OF GENERATION OUTPUT REPORT FROM EDIT MODE TO BROWSE MODE | ||||
2023 |
UNABLE TO ADD TEMPORARY TABLE TO TABLESPACE VIA COMPARE, ALTHOUGH ALLOWED BY DB2 | ||||
2023 |
KC LINE COMMAND SHOWING INCORRECT PACKAGE VERSION AND DET COMMAND ON PACKAGE HANGS | ||||
2023 |
LISTAGG FUNCTION IN ALT INDEX CAUSES SQL ERROR ON DB2 12 FL500 | ||||
2023 |
PARSER ERROR WHEN GENERATING DDL FOR A TRIGGER | ||||
2023 |
(ADB) INTERNAL APAR PH58315 SUPPORT FOR MISSING RUNSTATS INDEX UTILITY OPTIONS. | ||||
2023 |
(ADB 13) INTERNAL APAR PH58226 SUPPORT UNLOAD NOPAD FOR CATALOG COPY | ||||
2023 |
INTERNAL APAR PH58388 4Q 2023 AOC12 DEFECT BACKLOG REDUCTION EPIC (AOC12 AND 13) | ||||
2023 |
(ADB) INTERNAL APAR PH58387 FOR 4Q 2023 ADMIN V13 BASE BACKLOG DEFECT REDUCTION (AOC13 ONLY) | ||||
2023 |
WHEN DROP/CREATE OF A TABLE WITH TRIGGERS IS GENERATED, RO ON TABLESPACE PREVENTS CREATE OF TABLE AFTER DROP | ||||
2023 |
Compare attempts to drop and create archive TS when only base table is modified and present on source DDL | ||||
2023 |
POOR PERFORMANCE OF AN SQL QUERY AFTER RUNNING SQ LINE COMMAND | ||||
2023 |
GENERATE INDEXES IN CHRONOLOGICAL ORDER INSTEAD OF ALPHABETICALLY | ||||
2023 |
INCORRECT REVOKE STATEMENTS ISSUED WHEN DOING A PRIMARY COMMAND REVOKE ON PANEL ADB2AUD | ||||
2023 |
REORG INCORRECTLY GENERATED FOR A PAGENUM RELATIVE TABLESPACE WHEN INCREASING TABLESPACE DSSIZE | ||||
2023 |
ADBTEP2 RESETS CURRENT SQLID AFTER UTILITY CALL | ||||
2023 |
OPTION Z.2Z RESULTS IN ADB402 <> 0 RC FROM THE INSTRUMENTATION FACILITY: RETURN CODE = 00000004. REASON CODE = 00E60804 | ||||
2023 |
(ADB) PH57692 INTERNAL APAR TO MANAGE APPLCOMPAT ON INDEXES | ||||
2023 |
INTERNAL APAR PH58019 DEPLOYMENT OF REST SERVICES | ||||
2023 |
(ADB) INTERNAL APAR PH58136 SAVE AND RESTORE MIGRATE SPECIFICATIONS | ||||
2023 |
PH58158 ADD MAXPARTITIONS SUPPORT TO MOVETB PANEL ADB2MVT1 | ||||
2023 |
UI94593 |
SB COMMAND ON ALIAS OBJECT IN PACKAGE DEPENDENCIES RESULTS IN DSNT408I SQLCODE = -199, | |||
2023 |
CHANGE MANAGEMENT ANALYZE STEP SETS INCORRECT PAGENUM VALUE ON TABLE SPACE | ||||
2023 |
AL COMMAND ON PBR TABLE SPACE WITH PAGENUM ABSOLUTE DOES NOT VALIDATE SEGSIZE OR MEMBER CLUSTER AND DOES NOT SHOW DSSIZE | ||||
2023 |
RTS LINE COMMAND ON PANEL ADB21S RETURNS 0 ROWS WHEN ROWS EXISTS WHEN USING DDF | ||||
2023 |
UI94481 |
FIELD RO SHOWS BLANK IN DB2X APPLICATION PLANS (PANELID ADB21P) | |||
2023 |
ADMIN TOOL V13: PANEL ADB21SAR SHOWSINVALID VALUE MESSAGE FOR TABLE SPACES WITH COMPRESS = NULL OR '?' | ||||
2023 |
ADD TCZ PROVISION TO CREATE ONE OR MORE GRANT MANAGEMENT DATABASES/HUBS | ||||
2023 |
INTERNAL APAR DB2 13 FL504 TOLERATION AND SUPPORT | ||||
2023 |
INTERNAL APAR PH57695 GRANT MANAGEMENT FOLLOW-ON IMPROVEMENTS | ||||
2023 |
INTERNAL APAR PH57694 ALLOW EXECUTION OF REVOKE IMPACT IN BATCH MODE | ||||
2023 |
DB2 ADMIN V12/V13: ON PANEL ADB2314, THE PARTITION COLUMN SCROLLS OFF SCREEN INSTEAD OF REMAINING ON SCREEN. | ||||
2023 |
Admin tool should catch SCHEMA mismatch in DDL for AUX and base tables pre-masking | ||||
2023 |
OBJECT COMPARES FAILS TO PROPAGATE THE DEFAULT TABLESPACE DSSIZE TO TABLESPACE PARTITIONS | ||||
2023 |
OBJECT COMPARE - EMPTY ALTER SEQUENCE STATEMENT ADDED TO WSL | ||||
2023 |
Import DDL to recreate a table without CREATE TS should have error message to include TS in DDL. | ||||
2023 |
POOR SQL PERFORMANCE USING ICS COMMAND ON UTILITY HISTORY PANEL ADB2Z2H1 | ||||
2023 |
UI94033 |
OBJECT COMPARE USES TABLE NAME FOR DROP TRIGGER STATEMENT WHEN EXPLICITLY DROPPING TRIGGER | |||
2023 |
CHOOSING RANDOM FOR A NOT PADDED INDEX DOESN'T PREVENT USER ON PANEL ADB21XAR | ||||
2023 |
INTERNAL APAR PH57198 ALLOW SPECIFYING SOURCE/TARGET OBJECTS FROM AN SQL SELECT STATEMENT IN COMPARE | ||||
2023 |
UI94203 |
GRANT MANAGEMENT MESSAGE UPDATES. | |||
2023 |
INTERNAL APAR SUPPORT NEW DB2 ZPARMS. | ||||
2023 |
ADB2A5.TOKENIZE ERROR WHEN QUESTION MARK IS USED AS A STORED PROCEDURE PARAMETER MARKER | ||||
2023 |
UI93769 |
OBJECT COMPARE FAILS TO HANDLE CCSID COLUMN ATTRIBUTE | |||
2023 |
UNSUCCESSFUL BIND OCCURS IF DBRM LIBRARY ON BIND PACKAGE PANEL DOES NOT EXIST | ||||
2023 |
CMBATCH SUPPORT FOR GENERATING FOREIGN KEY CHANGES WHEN CALLING GOCCM | ||||
2023 |
INCORRECT VALUES IN INTERPRETATION PANEL (ADB21KDI) WHEN DOING LINE COMMAND 'I' FROM ADB21KDS (PACKAGE DEPENDENCIES AT ST LVL) |
||||
2023 |
UI93769 |
OBJECT COMPARE FAILS TO ACKNOWLEDGE THE SYSINDEXES BPOOL IGNORE FOR IMPLICIT INDEXES | |||
2023 |
UI93769 |
COMPARE GENERATES INVALID WSL WITH VIEW THAT CONTAINS INCORRECT TERMINATOR | |||
2023 |
OBJECT COMPARE: WHEN EXCL SPEC IS INVOKED, PANEL ADBPC7L TRUNCATES THE MESSAGE COLUMN VALUES TO ONE CHARACTER | ||||
2023 |
UI93769 |
REDUCE MEMORY USAGE IN MERGE AND OBJECT COMPARE | |||
2023 |
INTERNAL APAR FOR SMART REORG GENERATION (PHASE 3) | ||||
2023 |
(ADB) INTERNAL APAR SUPPORT FOR MISSING LOAD UTILITY OPTIONS | ||||
2023 |
UI91758 |
ADB2GEN FAILS WITH S0C4-00000004 WHEN GEN JOB CONTAINS SQLCMTS='Y' | |||
2023 |
INTERNAL APAR FOR PARSER IMPROVEMENTS (TABLESPACE). | ||||
2023 |
INTERNAL APAR TO PROVIDE OPTION TO MAP SOURCE & TARGET OBJECTS (MANAGED PROMOTIONS) | ||||
2023 |
ADMIN TOOL: DET COMMAND ON PACKAGE FAILS WITH ERROR CONDITION IN MAPHV | ||||
2023 |
ADMIN TOOL:ADDING SOURCE EXCLUDE CAUSES UNRELATED GRANT STATEMENTS AND DROP ALIAS STATEMENTS TO BE MISSING FROM THE WSL |
||||
2023 |
WHEN USING MOVETB (COMMAND OR LINE COMMAND), PANEL ADB2MVT1 ISSUE ERRONEOUS MESSAGE WHEN A FULLY QUALIFIED DATASET IS SPECIFIED. |
||||
2023 |
UI93645 |
DROP MQT TABLE SPACE VIA OBJECT COMPARE GENERATING UNNECESSARY START TABLE SPACE IN RW MODE | |||
2023 |
DB2 ADMIN TOOL: S522 OR S414 ABEND IN ADBTEP2 AFTER AN I/O ERROR ON SYSPRINT WHEN SYSPRINT IS A DATASET | ||||
2023 |
UNSUPPORTED DB2 RELEASE ERROR IN OBJECT COMPARE | ||||
2023 |
REPORT REVOKE IMPACT DOES NOT REPORT ON SOME OR ALL VIEWS BEING DROPPED. | ||||
2023 |
INTERNAL APAR FOR GRANT MANAGEMENT SYSTEM. | ||||
2023 |
UI93216 |
DB2 AOC: COMPARE TOOL GENERATES INVALID WSL THAT FAILS WITH SQLCODE = -20385 | |||
2023 |
GENERATION OF CATALOG COPY OBJECTS MAY TAKE A VERY LONG TIME OR TIME OUT BEFORE FINISHING | ||||
2023 |
SQL STATEMENT IS GENERATED WITH A LONG STRING LITERAL TRUNCATED TO 4000 CHARACTERS. | ||||
2023 |
PREFIX IS MISSING FROM RECOVER WSL AND JCL DATA SET NAMES WHEN DATA TO RECOVER IS SET TO 'B' | ||||
2023 |
MISLEADING TEXT "COMMANDS:" APPEARS ON PANELS ADB2MES AND ADB2MEX WHEN COMMAND(S) ARE NOT YET AVAILABLE. | ||||
2023 |
UI93216 |
WHEN OPTION 2H IS SELECTED ON PANEL ADB2Z, "INVALID CMD" IS DISPLAYED. | |||
2023 |
SELECT LEFT OUTER JOIN NEEDED FOR SYSENVIRONMENT TABLE | ||||
2023 |
PARSER ERROR DURING WSL VALIDATE STEP OF COMPARE | ||||
2023 |
CLEAN UP COLLECTION PANEL DOES NOT ALLOW LOAD LIBRARIES WITH NON-ZERO LRECL | ||||
2023 |
UI92880 |
DB2 ADMIN TOOL: ERROR ADB3024E ISSUED INCORRECTLY WHILE PROCESSING OBJECT IN CREATE STATEMENT | |||
2023 |
SQLCODE = -750 WHEN ADDING A TABLE COLUMN AND RENAMING A TABLE COLUMN REFERENCED BY A VIEW | ||||
2023 |
ADMIN TOOL: BIND COPY OF PACKAGE WITH MIXED-CASE NAME, MAKES PACKAGE NAME UPPER CASE. 23/06/15 PTF PECHANGE |
||||
2023 |
WHEN ANALYZING SOURCE VF THAT HAS EMPTY DEFAULT VALUE FOR WLM ENVIRONMENT FIELD CAUSES SQLCODE=-104 | ||||
2023 |
USE LISTDEF WHEN GENERATING UTILITIES | ||||
2023 |
DB2 ADMIN TOOL V12.1: ERROR RUNNING ADB2ZDC | ||||
2023 |
B37 ON ADBDIAG AND THEN ERROR DOING REVOKE SYSADM | ||||
2023 |
DET FAILS TO OUTPUT ENTIRE SQL STATEMENT, CAUSING VALUES TO BE WRITTEN ON TOP OF EACH OTHER | ||||
2023 |
ADMIN TOOL: CREATE UNIQUE INDEX STATEMENT INCORRECTLY ADDING DSSIZE | ||||
2023 |
DB2 ADMINISTRATION TOOL - DSN LINE COMMAND ON PANEL ADB21S DOES NOT WORK | ||||
2023 |
ALTERING TABLES WHILE USING NOPAD UTILITY OPTION RESULTS IN ONCODE = 520 | ||||
2023 |
PARSER FAILS TO TOKENIZE VALUES PRECEDING CONCAT OPERATOR '!!' UNDER CCSID 500 (ADMIN TOOL V13) | ||||
2023 |
ADMIN TOOL: PROBLEMS WITH ADB21KSE PANEL EXPLAIN COMMAND | ||||
2023 |
Generate ALTER VIEW REGENERATE using Application Compatability in Admin & OC | ||||
2023 |
UI92598 |
ONCODE 340 IN BUILD_DEPOBJ_LIST WHEN STORED PROCEDURES ARE COMPARED | |||
2023 |
INTERNAL APAR BUGSMASH 2022 | ||||
2023 |
AOC: WHEN RUNNING OBJECT COMPARE IN CMDELTA MODE, ALTER TABLE STATEMENTS CAUSE THE TABLESPACE TO BE REQ. FOR THE COMPARE |
||||
2023 |
ABSTRACT: OBJECT COMPARE DOES NOT SUBSTITUTE COMPRESS YES FIXEDLENGTH WITH COMPRESS YES ON DB2 Z/OS FLS < FL509 | ||||
2023 |
LOAD UTILITY DISCARDS VALUES DURING CHANGE WITH UNICODE TABLE | ||||
2023 |
ADMIN TOOL: DET COMMAND ON A V13-BOUND PACKAGE SHOWS INCORRECT DETAILS | ||||
2023 |
INTERNAL APAR DSNTYPE_LARGE OPTION TO INCREASE SPACE FOR LARGE UTILITY DDS. | ||||
2023 |
INTERNAL APAR ALTER COLUMN SUPPORT IN AL (PHASE 2) | ||||
2023 |
INTERNAL APAR HANDLE MISSING TABLESPACE AND INDEX ATTRIBUTES IN CREATE/ALTER FLOW (PANELS). | ||||
2023 |
INTERNAL APAR SUPPORT NEW DSN_PROFILE_ATTRIBUTES VALUES | ||||
2023 |
WITH MOVETB, ADD AN OPTION TO GENERATE RUNSTATS FOR NEW TABLESPACES | ||||
2023 |
ADMIN TOOL: TEMPLATES FOR REBUILD INDEX ARE NOT GENERATED WHEN RECOVERING A TABLESPACE | ||||
2023 |
ADMIN TOOL - MANAGE FAST INDEX TRAVERSAL PANEL ERROR (PANEL ADB2Z2I2) | ||||
2023 |
ALLOCATION ERROR WITH GCMDS COMMAND IN DB2 ADMIN TOOL | ||||
2023 |
WSL EDIT COMMAND HAS FORMATTING PROBLEMS WHEN DONE ON LARGE STATEMENTS | ||||
2023 |
SUPPORT DDL VS DDL COMPARE IN CMBATCH | ||||
2023 |
INTERNAL APAR SUPPORT NEW DB2 ZPARMS. | ||||
2023 |
INTERNAL APAR MASKING SUPPORT FOR REMOVING KEY LABEL. | ||||
2023 |
NEW MASKING SERVICE/STORED PROCEDURE | ||||
2023 |
UI91772 |
Admin Tool: Adding a ROWID or LOB column followed by ALTER to tablespace PAGENUM fails with SQL -20385 | |||
2023 |
THE DET COMMAND ON A PACKAGE COPY DISPLAYS DETAILS OF THE LIVE PACKAGE AND NOT THE EXPECTED INACTIVE PACKAGE | ||||
2023 |
UI92089 |
ADMIN TOOL: INCORRECT REORG WHEN PAGENUM IS ALTERED WITH OTHER PENDING CHANGES | |||
2023 |
UI91594 |
ABENDE37-08 ABEND OCCURS WHEN USING DET COMMAND ON ACCELERATOR TABLE | |||
2023 |
RESZ COMMAND ON PANEL ADB2M1S PAGE SET STATISTICS BUILDS INCORRECT REORG JCL THAT CAUSES RC=8 WHEN RUN | ||||
2023 |
DB2 ADMINISTRATION TOOL - SELECT FOR REMOTE TABLES RETURNS NO ROWS | ||||
2023 |
ADMIN TOOL: (V13 ONLY) REORG PART X WITHOUT COPYDDN WHEN USING PANEL ADB2314 | ||||
2023 |
UI91594 |
ADMIN TOOL: "SQLCODE = -331, ERROR: CHARACTER CONVERSION ERROR PANEL ADB21K LINE CMD KC, ON A PACKAGE CREATED IN DB2 Z/OS V13 |
|||
2023 |
USE OF THE TAB KEY ON PANEL ADB21 CAUSES CURSOR TO POSITION ON OPTION AO. | ||||
2023 |
FAST INDEX TRAVERSAL OPTION OF RUNNING INDEXTRAVERSECOUNT RESULTS | ||||
2023 |
ADB1031E ERROR WHEN CALLING ADBGDDL | ||||
2023 |
ALTER RELATED CONSTRAINTS SUPPORT | ||||
2023 |
UI91556 UI92089 |
FREEPAGE CHANGE MISSING FROM WSL/REPORT WHEN USING OBJECT COMPARE | |||
2023 |
ADMIN TOOL: BIND COPY OF PACKAGE WITH MIXED-CASE NAME CHANGED TO UPPER CASE | ||||
2023 |
ADB2CMT DETECTED AN ONCODE CONDITION 8094 IN COMPARE_TABLES AT 7678 | ||||
2023 |
GENERATED AOC/TCZ JOB ASSOCIATED WITH TEMPLATE ADBCVUTS IS MISSING VALUES FOR OWNER AND SCHEMA. | ||||
2023 |
ADMIN TOOL V13: ALTPART COMMAND ABENDS WITH USER COMPLETION CODE=4039 REASON CODE=00000000 | ||||
2023 |
AVOID DEFAULTING BUFFERPOOL | ||||
2023 |
EMBED IFF-FILE INTO WSL | ||||
2023 |
ADMIN TOOL: REBINDS SHOULD BE GENERATED AS PART OF WSL AND NOT VIA AUTOREBIND WHEN ADDING DELETE CASCADE | ||||
2023 |
DSNTYPE LARGE SPECIFIED FOR TEMPLATES IN ADB25TS BUT WAS CHANGED BY ADMIN TOOL TO DSNTYPE LIBRARY INSTEAD | ||||
2023 |
FOR DB2 12 FL505 AND NEWER, DB2 ADMIN TOOL SUPPORT IS MISSING FOR FREE PACKAGE PLANMGMTSCOPE(PHASEOUT) | ||||
2023 |
UI91180 |
MULTIPLE RUNSTATS GENERATED FOR TABLESPACE, TABLE AND INDEX | |||
2023 |
ADMIN TOOL - CLREST COMMAND: "PROCESSING ERROR" MESSAGE | ||||
2023 |
UI91281 |
COMPARE PRE VERSION 12 (FL500) OBJECTS - GEN DDL AGAINST THE CATALOG - GIVING ALTERS FOR SECQTY IN INDEXES. | |||
2023 |
ADMIN TOOL:Z.2H CAUSES SQLCODE = -104, ERROR:ILLEGAL SYMBOL WHEN DSNHDECP DECIMAL PARM IS SET TO COMMA | ||||
2023 |
DEFECT BACKLOG | ||||
2023 |
NEW QUERY_ACCEL_OPTIONS ZPARM VALUE | ||||
2023 |
DB2 13 FL503 TOLERATION AND SUPPORT | ||||
2023 |
UI90811 |
NO PARTITION INFORMATION IN DDL VIA GEN FOR INDEX WITH BUSINESS TIME WITHOUT OVERLAPS SPECIFIED | |||
2023 |
ELIMINATE UNNECESSARY REORGS WHEN RUNNING CHANGES | ||||
2023 |
UI90811 |
DB2 ADMINISTRATION TOOL: ONCODE 8094 IN ADB2CMT AT COMPARE_TABLES AT 20269 | |||
2023 |
OBJECT COMPARE REPORT WITH THE ERROR MESSAGE ADB7955E | ||||
2023 |
WHEN SORT COMMAND IS USED IN THE "EDIT/RUN SQL STATEMENT" HELP PANEL ADBHSORT LISTS COMMAND THAT IT SHOULDN'T | ||||
2023 |
REST SERVICES UPPER CASE OPTION RESETS INAPPROPRIATELY | ||||
2023 |
UI90760 UI90811 |
DUPLICATE REORG GENERATED FOR TABLESPACE | |||
2023 |
UI90760 UI90811 |
SYSTABLESPACE IGNORE FOR TRACKMOD SHOULD EXTEND TO SYSTABLEPART TO AVOID COMPARING TRACKMOD FOR IMPLICIT LOB TABLESPACES | |||
2023 |
UI92089 |
AL LINE COMMAND SHOULD NOT ALLOW TRACKMOD ALTER FOR IMPLICIT LOB TABLESPACE AS IT IS A DB2 RESTRICTION | |||
2023 |
UI91023 |
COMPARE INCORRECTLY GENERATES A CHANGE FOR THE TABLESPACE COMPRESS ATTRIBUTE | |||
2023 |
SUPPORT FOR MISSING DB2 COPY UTILITY OPTIONS | ||||
2023 |
NEW SHARE_LOCKS KEYWORD FOR DSN_PROFILE_ATTRIBUTES | ||||
2023 |
UI92089 |
VALIDATE RANDOM RELATED INDEX OPTIONS ON PANEL ADB21XAR | |||
2023 |
DB2 AOC: WSL EDITOR LINE COMMAND PROBLEMS WITH LARGE DDL OBJECTS GREATER THAN 32704 CHARACTERS - DDL TRUNCATION | ||||
2023 |
UI92672 |
DB2 ADMIN: PROBLEMS WITH ADB21KSE PANEL EXPLAIN COMMAND | |||
2023 |
EXPLICIT COUNT FOR TYPE "GLOBAL TEMPORARY" ON PANEL ADB2AUS SHOWS > 1, YET LINE COMMAND AE AGAINST IT SHOWS "NO ROWS TURN" |
||||
2023 |
UI90397 |
COMPARE GENERATES DROP/CREATE FOR DSSIZE CHANGE IF PARTITIONING IS IGNORED | |||
2023 |
UI90775 UI91023 |
ERROR MESSAGE ADB8067E OCCURS WHEN OBJECT COMPARE EVALUATES THE TABLE DROP RESTRICTION & OTHER TABLE ATTRIBUTE CHANGES TOGETHER |
|||
2023 |
UI91180 |
ERROR MESSAGE ADB7955E FOR WARNING SQLCODE +162 IN ADBTEP2 OUTPUT | |||
2023 |
UNABLE TO GENERATE DDL FOR AN OBJECT STARTING WITH SPACE CHARACTER | ||||
2023 |
UI90397 |
NO COMMIT AFTER ALTER TABLE ADD COLUMN STATEMENTS | |||
2023 |
COMPLETION CODE=0C4 REASON CODE=00000010 OCCURS DURING INVOCATION STARTUP OF DB2 ADMIN TOOL. | ||||
2023 |
UNLOAD FAILS FOR A TABLE IN INCOMPLETE STATE | ||||
2023 |
DB2 ADMIN TOOL INTERFACE TO SQLPA | ||||
2023 |
SQL FORMATTING AS A SERVICE | ||||
2023 |
TOLERATION SUPPORT FOR DB2 13 PRDID CHANGE | ||||
2023 |
UI90198 |
DB2 ADMIN TOOL: ADBCCME DETECTED AN ONCODE CONDITION 8094 IN MERGE_TABLES - ADD A SECOND INDEX ON A HISTORY TABLE | |||
2023 |
UI90198 |
OBJECT COMPARE: INCORRECT HANDLING OF ALTER TABLE <TB> ADD <COL> GENERATED BY DEFAULT IDENTITY AND ADD NEW INDEX | |||
2023 |
UI90198 |
DB2 ADMIN TOOL: NEXTVAL IS WRAPPED IN QUOTES WHEN GENERATING DDLFOR A TRIGGER CAUSING A -206 ERROR | |||
2023 |
SIZE ERROR DUE TO OVERFLOW OF COUNTER IN GEN_UNIQUE_CONSTRAINTS() | ||||
2023 |
COMPARE OF AN ADDITIONAL INDEX ON SRC SIDE GENERATES DROP/CREATE TABLESPACE BUT W/O CREATE OF TABLE AND INDEX ON TAR |
||||
2023 |
UI90194 UI90198 |
SUBGROUPS OF TRIGGERS ARE INCORRECTLY UPDATED DURING MERGE | |||
2023 |
ACCELERATION OF A TABLE IS NOT RESTORED AFTER THE TABLE IS ALTERED | ||||
2023 |
UI90198 |
DDL command after ALTER produces additional attributes form SYSINDEXPART 23/01/20 PTF PECHANGE |
|||
2023 |
DB2 ADMIN TOOL V13 GETTING INVALID LINE CMD ERROR IN PANEL ADB21I WHEN USING LINE CMD UT | ||||
2023 |
UI90665 |
WRONG TABLESPACE NAME USED AT START COMMAND | |||
2023 |
UI90665 |
ADMIN TOOL ISSUES START SPACES RW TOO EARLY, AFTER DELETING 2 COLUMNS ON 2 TABLES WITH VERSIONING | |||
2022 |
DB2 V13 FL502 TOLERATION AND SUPPORT | ||||
2022 |
UI90198 |
OBJECT COMPARE: CREATE TABLESPACE STATEMENT PARTITION ERRORS | |||
2022 |
UI90198 |
"UNEXPECTED <SELECT> SYNTAX IN THE WITH CLAUSE" WHEN FULLSELECT CONTAINS VALUES CLAUSE | |||
2022 |
ADMIN TOOL: DDL GENERATION WITH MASK IS NOT GENERATING DDL | ||||
2022 |
UI83800 |
ADMIN TOOL ERROR CONDITION RAISED DURING DET COMMAND ON PACKAGE | |||
2022 |
UI90198 |
ADMIN TOOL: ERRONEOUS ADB5256I MESSAGE WHEN CALL TO SYSPROC.ADMIN_INFO_SSID HAS FAILED | |||
2022 |
UI83663 |
ADB2GEN PROGRAM FAILS WITH SYSTEM ABEND 0C4 REASON CODE 00000004 | |||
2022 |
ADB7350E ERROR - ADB2CMO DETECTED AN ONCODE CONDITION 451 IN ADD_V9_TABLE | ||||
2022 |
TCZ JOB ADBSETUP FAILS WITH -20008, ERROR: ATTEMPT TO USE UNSUPPORTED FEATURE 'CREATE IN NON-UTS'. REASON CODE: 8 | ||||
2022 |
DB2 ADMIN TOOL FAILS TO ADD HISTORY TABLE TO ACCELERATOR V7.5.7 | ||||
2022 |
UI82699 UI83663 |
OBJECT COMPARE ATTEMPTS TO EXPLICITLY CREATE AN IMPLICITLY CREATED AUX TABLE | |||
2022 |
UI83663 |
OBJECT COMPARE: DB2_GENERATED_DOCID_FOR_XML IMPLICIT COLUMN NOT BEING IGNORED | |||
2022 |
UI83663 UI90198 |
MISSING REBUILD CAUSING ERROR ON CHECK DATA STATEMENT | |||
2022 |
ADMIN TOOL: SM (SPACE MANAGEMENT) FOR INDEX OF AN ARCHIVE TABLE IN ADMIN TOOL DOES NOT WORK. | ||||
2022 |
UI83663 |
DDL COMMAND ON A STORED PROCEDURE RESULTS IN PARSER ERRORS WHEN STORED PROCEDURE HAD NON-BUILT-IN DATA TYPE DECLARE WITH DEFAULT |
|||
2022 |
ADMIN TOOL: DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD FETCH - FROM PANEL ADB21KD (PACKAGE DEPENDENCIES) | ||||
2022 |
ADMIN TOOL LOOPING BETWEEN SCREENS ON PANEL ADB26COV ("ALTER STORED PROCEDURE") | ||||
2022 |
WHEN AO IS SELECTED ON PANEL ADB21, END RETURNS TO PANEL ADB2 WHEREAS USERS WERE EXPECTING END TO RETURN TO PANEL ADB21 | ||||
2022 |
SUPPORT FOR LASTLOG REORG KEYWORD | ||||
2022 |
EXTENDED SUPPORT FOR > 30 BYTE COLUMN NAMES | ||||
2022 |
UI83663 UI83975 UI90198 |
IGNORING CHANGES BETWEEN V12 AND MIGRATED PRE V12 OBJECTS | |||
2022 |
ALLOW SPECIFICATION FOR REBIND PACKAGE OPTIONS | ||||
2022 |
UI83086 |
ADMIN TOOL: ADDING A COLUMN TO A TABLE DOES NOT RECREATE ALL DEPENDENT VIEWS | |||
2022 |
ADMIN TOOL: GEN IS MISSING 'DATABASE NAME' FIELD | ||||
2022 |
DB2 ADMIN TOOL: COMMAND CLREST ABENDS WITH E37 REASON CODE 4 WHEN CREATING DATASET FOR DBRM BACKUPS | ||||
2022 |
UI92091 |
MISSING REORG SHRLVEL FOR AN ALT INDEX BUFFERPOOL CAUSES AREOR STATE | |||
2022 |
OBJECT COMPARE SHOULD NOT REPORT PATHSCHEMAS CHANGE | ||||
2022 |
UI83663 UI90198 |
ABSTRACT: OBJECT COMPARE - ACCELERATED TABLES REPLICATION AND ACCELERATION STATUS ARE OVERRIDDEN INSTEAD OF RESTORED | |||
2022 |
ADMIN TOOL: ERROR RUNNING ADB2DIP (DROP IMPACT) WHEN ACCELERATOR-ONLY TABLE IS PRESENT | ||||
2022 |
NEW ADMIN ALTER STATEMENT INSERT COLUMN AFTER | ||||
2022 |
PANEL ADB2CRO HANGS AFTER CHANGE IS REGISTERED AND NEXT IS SELECTED | ||||
2022 |
UI82695 UI82823 |
WHEN RUNNING A CHANGE, THE TABLE SPACE IS STARTED TWICE, EVEN BEFORE THE UNIQUE INDEX HAS BEEN CREATED. | |||
2022 |
ADMIN TOOL - VERSION GENERATED BY GOCCM INCOMPLETE AND CANNOT BE USED TO GENERATE DDL | ||||
2022 |
UI82823 |
ADMIN TOOL - DDL COMMAND ON INDEX NOT SHOWING PARTITION DSSIZES 22/09/20 PTF PECHANGE |
|||
2022 |
UI91950 |
ADMIN TOOL: MOVETB LINE COMMAND GENERATES INCORRECT UTLREC DATASET NAME | |||
2022 |
DB2 ADMIN TOOL RESOURCE LIMIT PANEL ADB2Z2RS MUST NOT ALLOW LINE COMMAND U (UPDATE) TO UPDATE A ROW WITH PLAN NAME. | ||||
2022 |
UI82823 |
DB2 ADMIN TOOL: ALTER RENAME COLUMN FAILS FOR TABLE WITH CLONE | |||
2022 |
DB2 ADMIN TOOL: S522 OR S414 ABEND IN ADBTEP2 | ||||
2022 |
EXTENDING SPACE ESTIMATION CAPABILITY | ||||
2022 |
CHANGE REORG SHRLEVEL DEFAULT TO CHANGE | ||||
2022 |
AOC: ADB2RE CALL TERMINATES EARLY IF SEMICOLONS ARE MISSING FROMTHE END OF PARAMETERS OR IF DB2REL IS NOT SPECIFIED. | ||||
2022 |
DB2 ADMIN TOOL MISSING SUPPORT FOR IGNORE FOR FIELD CREATEDTS IN SYSIBM.SYSKEYS | ||||
2022 |
UI82378 |
OBJECT COMPARE REPORT - ERROR MESSAGE ADB8067E IN MERGE VERSION FILES SECTION | |||
2022 |
UI82568 |
ADMIN START FOR TABLE COMMAND IS GENERATED AT THE END OF WSL FILE AFTER THE DROP DATABASE STATEMENT. | |||
2022 |
DB2 ADMIN TOOL - HELP TEXT AND MESSAGE NEEDED FOR OPTION TU (SPECIFY TEMPLATE USAGE) LINE COMMANDS | ||||
2022 |
USING "RL" OPTION ((REFERENTIAL CONSTRAINT) IS NOT WORKING CORRECTLY IN PANEL ADBPC7L ("CM-EXCLUDE OBJECTS") | ||||
2022 |
WHEN USING THE ALT/TS OPTION MAKEPBR ON PANEL ADB21SAR TO CONVERT TO UTS PBR AND INCREASE/DECREASE NUMPARTS, THE LIMITKEYS PANEL |
||||
2022 |
UI82378 |
SUPPORT FOR COMPARE SMART REORG GENERATION | |||
2022 |
ELIMINATE ADMIN DROP CREATE IN ALT INDEX | ||||
2022 |
UI82193 |
OBJECT COMPARE INCORRECTLY REPORTS CHANGES TO COMPRESS ATTRIBUTE | |||
2022 |
UI82193 |
OBJECT COMPARE : SYSPRINT SHOWS INCORRECT VERSION DETAILS VIA DDL TO DDL COMPARE | |||
2022 |
ADMIN TOOL: WHEN USING BH LINE COMMAND ON PANEL ADBPZRP, THE DATA INSERTED INTO HISTORY TABLE IS TRUNCATED | ||||
2022 |
UI82378 |
ADMIN TOOL: GEN SHOWS INCORR DDL WHEN PARM "INCLUDING DB2 PENDING CHANGES" IS Y AND THE PENDING CHG IS A DROP COLUMN | |||
2022 |
MOVETB LINE COMMAND GENERATES INCORRECT REORG UTILITY CONTROL STATEMENT | ||||
2022 |
UI83663 |
DB2 ADMIN TOOL UNLOAD FROM IMAGE COPY UNBALANCED PARENTHESES ERROR | |||
2022 |
UI82193 |
OBJECT COMPARE REPORT DOES NOT INDICATE WHEN A STOP INDEX IS ISSUED. | |||
2022 |
UI82016 UI82193 |
SQLCODE -625 WHEN ADDING A COLUMN TO AN INDEX AND PRIMARY KEY ONA TABLE | |||
2022 |
ELIMINATE ADMIN DROP CREATE IN ALT TABLESPACE | ||||
2022 |
V13 GA ADDITIONAL FUNCTIONALITY APAR | ||||
2022 |
UI82381 |
GEN FAILS WITH ONCODE 340 WHEN FORMATTING DBCS COMMENT - SIZE AND TRUNCATION ISSUES OCCUR | |||
2022 |
UI90381 |
DB2 AOC: WSL EDITOR LINE COMMAND PROBLEMS WITH LARGE DDL OBJECTS GREATER THAN 32704 CHARACTERS | |||
2022 |
UI82375 UI82568 |
GENERATING APPLY JOBS RESULTS IN ADBGAJOB ERROR RC=12 WHEN ADDING INLINE REORG | |||
2022 |
UI83177 |
PARSER FAILURE WHEN PROCESSING TRIM FORMAT | |||
2022 |
UI82193 |
OBJECT COMPARE - INCORRECT COLUMN ORDERING WHEN INSERTING AND DROPPING COLUMNS | |||
2022 |
USING WORK STATEMENT LISTS FOR LOAD PROCESS VIA DB2 ADMIN TOOL OMITS LOADS CONTAINING 0 RECORDS IN THE LOAD SUMMARY REPORT | ||||
2022 |
ANALYZE AND RUN MTC CHANGES FOR TARGET SYSTEMS WHILE ON THE CENTRAL SYSTEM V13.1 | ||||
2022 |
ADD OPTION FOR UNLOAD ALTERED TABLES TO ONLY UNLOAD DESTRUCTIVE ALTERS | ||||
2022 |
UPDATE MESSAGING IN COMPARE REPORT TO NOTIFY USER OF OTHER AFFECTED OBJECTS | ||||
2022 |
UI90762 |
IMPROVE USABILITY OF REST SERVICE PANEL ADB21RS | |||
2022 |
UI92091 |
GENERATING UNLOAD ON A TABLE VIA U.UL COMMAND RESULTS IN SECONDARY EXTENT SPACE PARAMETER THAT IS TOO LARGE | |||
2022 |
ADB2GEN RC=12 SQLCODE -811 WHEN ACCELERATOR-ONLY TABLE IS DEFINED FOR HIGH AVAILABILITY. | ||||
2022 |
UI83800 |
ADMIN TOOL REST SERVICE - B AND CRE LINE COMMANDS DO NOT WORK WITH LOWER CASE LETTERS | |||
2022 |
ISSUE 1: WHEN DB2 LIBRARIES ARE NOT SPECIFIED ON DB2 PARAMETERS PANEL CCQPDB2 BECAUSE THE DB2 LIBRARIES ARE USED FROM LINKLIST, |
||||
2022 |
ROLLUP APAR FOR V12 DELIVERED FIXES | ||||
2022 |
SUPPORT FOR DB2 ADMIN TOOL FOR Z/OS 13.1 GA PTF | ||||