Happy New Year! All APARs from 2023 have now been deleted and off we go again!
A very quiet month with a just a few fixes.
HIPER:
PH62143: Incorrect output when ARRAY_AGG function ORDER BY contains an EXPRESSION.
Interesting for RTS:
None.
RUNSTATS:
PH69138 RUNSTATS UTILITY GETTING ABEND0C4 IN DSNUSUCD +0027E WHEN USING FREQVAL COUNT 0 AFTER MIGRATING TO DB2 V13.
Ph69329 REORG WITH INLINE STATISTICS SPECIFYING HISTOGRAM OPTION TERMINATES ABNORMALLY WITH ABEND04E RC00E2002F IN DSNSVSFM+00718
Query performance:
PH68058 WITH DDL_MATERIALIZATION = ALWAYS_PENDING CONFIGURED, DROPPING XML TYPE MODIFIER DOESN’T DROP THE MODIFIER
IAG2:
None.
FIT/FTB:
None.
Now come the three tables containing all the APARs.
First are the Real-time Statistics APARs – If the RTS are incorrect then any Utility generation or Access path decision based upon them could also be incorrect.
Next are the RUNSTATS APARs – If RUNSTATS causes data problems this, obviously, can have a major impact upon performance after the following BIND, REBIND or dynamic SQL PREPARE.
Finally, come the SQL PERFORMANCE APARs – In here are all relevant performance APARs as well as HIPERs that do not fit into any other category. A HIPER warrants a check in all cases.
All three tables have the same headings:
APAR – The assigned APAR for the problem.
CLOSED – This is the date in YYYY-MM-DD format when the APAR was closed.
STATUS – This column is NEW, NEW & CLOSED, CLOSED or PE xxxxx. A PE means that this APAR went PE and the xxxxx is the corrective APAR.
Db2 12 – If the PTF is for Db2 12 then it is listed here else N/A or OPEN.
Db2 13 – If the PTF is for Db2 13 then it is listed here else N/A or OPEN.
HIPER – Contains Y if the APAR is a HIPER. Can also contain (Y) if it is OPEN but presumed to be a HIPER, else it is blank.
Description – This is the APAR description taken from the header text. Sometimes I add extra details if the description is misleading or incorrect.
Note: If the PTF column has OPEN it means that the PTF was still open when the last check was done; of course it could have been Closed since this post was updated. Every year all APARs that were closed over two years ago are deleted.
RTS APARs:
| APAR | CLOSED | STATUS | Db2 12 | Db2 13 | HIPER | Description |
| PH57281 | 2024-02-19 | N/A | UI95739 | INCORRECT TOTALROWS IN SYSIBM.SYSTABLESPACESTATS AFTER LOAD PARTREPLACE USING STATISTIC SAMPLING | ||
| PH61976 | 2024-11-15 | N/A | UI99070 | CATMAINT TIMEOUT WITH SYSTEM THREAD 014.RTSTST00 ON DYNAMIC SQL PLAN STABILITY CATALOG TABLESPACES | ||
| PH62962 | 2024-11-21 | UI99162 | UI99163 | INCORRECT STATISTICS IN SYSINDEXSPACESTATS FOLLOWING A MASS DELETE AND LOAD RESUME | ||
| PH64496 | 2025-02-06 | N/A | UI99916 | SYSTABLESPACESTATS.REORGUNCLUSTINS IS INCORRECTLY UPDATED FOR SEGMENTED TSS WITH MEMBER CLUSTER FOR SQL INSERT. | ||
| PH65573 | 2025-04-17 | N/A | UO02860 | INCORRECT RTS FIELD NLEVELS AFTER REORG OF AN EMPTY TABLESPACE PARTION WITH OPTION SORTNPSI NO | ||
| PH66005 | 2025-06-24 | N/A | UO03796 | DRIVETYPE IN SYSIBM.SYSTABLESPACESTATS REPORTS SDD INSTEAD OF SSD AFTER APPLY OA67067 | ||
| PH66937 | 2025-07-02 | N/A | UO03903 | RTS RETURNS INCORRECT TOTALENTRIES TO INDEX SERVICE AND IT CAUSES TABLE SCAN DURING THE RUNTIME. | ||
| PH67415 | 2025-09-12 | N/A | UO04871 | INSERT ABEND04E 00C90101 IN DSNKNXT2 ERQUAL 1006 | ||
| PH67680 | N/A | OPEN | ORPHANED ENTRIES LEFT IN RTS DURING PBG TO PBR CONVERSION, WHEN DDL MATERIALIZATION REORG FAILS BEFORE SWITCH PHASE | |||
| PH68528 | 2025-11-13 | N/A | UO05789 | DIFFERENT PSID VALUES BETWEEN SYSINDEXSPACESTATS AND SYSTABLESPACESTATS FOLLOWING MOVE TABLE | ||
| PH68536 | 2025-12-02 | N/A | UO06045 | MULTIPLE CONCURRENT LOAD INTO TABLE PART X RESUME YES UTILITIES CAUSING ABEND04E RC00E400E5 | ||
| PH69015 | N/A | OPEN | ABEND04E 00C90101 DSNIKESR 500B AND/OR ABEND04E 00E2000E DSNSVSFB OFFSET0098E MAY HAPPEN DURING CATMAINT RTS MIGRATION | |||
| PH69530 | New | N/A | OPEN | BACKUP SYSTEM UTILITY IS CAUSING BAD UPDATE TO COLUMN COPYCHANGES IN SYSTABLESPACESTATS AND SYSINDEXSPACESTATS [Set to 1077952576 or x’40404040′] |
RUNSTATS APARs:
| APAR | CLOSED | STATUS | Db2 12 | Db2 13 | HIPER | Description |
| PH57516 | 2024-04-19 | UI96586 | UI96587 | PCTROWCOMP VALUE IS INCONSISTENT BETWEEN REORG WITH STATISTICS OPTION AND RUNSTATS | ||
| PH57622 | 2024-02-19 | N/A | UI95740 | Y | REORG DISCARD WITH INLINE STATISTICS AND STATPGSAMP=SYSTEM DOES NOT UPDATE THE STATISTICS IN THE CATALOG TABLES CORRECTLY | |
| PH57853 | 2024-01-29 | UI95460 | UI95461 | ABEND0C7 IN DSNUSAH2 +0C838 DURING REORG WITH INLINE STATISTICS AND HISTOGRAM PROCESSING | ||
| PH58768 | 2024-02-02 | UI95522 | UI95523 | RUNSTATS 04E 00C90101 ABEND DSNINXPG ERQUAL2003 | ||
| PH59363 | 2024-05-09 | N/A | UI96830 | V13R1M500 REORG OF DIRECTORY TABLESPACES DSNDB01.SYSLGRNX & DSNDB01.SPT01 MATERIALIZE 64GB TO 256GB COLLECTS INLINE STATS | ||
| PH59995 | 2024-05-08 | UI96814 | UI96815 | KEYSEQ 0 IN MESSAGE DSNU1351I DOES NOT CONSISTENT WITH VALUE IN SYSIBM.SYSKEYTARGETS. | ||
| PH60632 | 2024-05-14 | See PH54155 | UI96899 | UI96900 | Y | RUNSTATS OR REORG WITH INLINE STATISTICS TERMINATE with ABEND0C4 IN DSNUSAF 24/04/02 PTF PECHANGE |
| PH61253 | 2024-08-02 | UI97897 | UI97898 | COLCARDF IN SYSIBM.SYSCOLUMNS IS ZERO AFTER RUNSTATS INDEX ALL ON A PARTITIONED TABLESPACE WITH PARTITIONED INDEX | ||
| PH63152 | 2024-11-12 | UI99012 | UI99013 | VALUE OF SYSCOLUMNS.COLCARDF IS INACCURATE AFTER RUNSTATS. | ||
| PH65024 | N/A | OPEN | RUNSTATS WITH USE PROFILE GETS DSNU554I -DB2A DSNUSSRI – DUPLICATE INDEX NAMES EXIST IN THE SPECIFIED INDEX NAME LIST | |||
| PH65659 | N/A | OPEN | RUNSTATS ABEND04E RC00C90101 IN DSNIDBMF :5017 ERQUAL5017 AFTER MOVE TABLE AND REORG | |||
| PH66148 | 2025-07-30 | UO04330 | UO04331 | WHEN RUNNING REORG WITH INLINE STATISTICS AND USE PROFILE , IN A SYSTEM WITH CCSID 1026, UTILITY ENDS WITH RC08 MSGDSNU611I | ||
| PH66211 | 2025-07-14 | UO04066 | UO04067 | ABEND04E RC00E40213 WITH CAUSE 00C9004F DURING RUNSTATS | ||
| PH66545 | 2025-09-30 | See PH45533 / PH46351 | UO05166 | UO05167 | ZIIP USAGE OF RUNSTATS INCREASES WHEN IT COLLECTS KEYCARD CARDINALITY FROM MULTI-KEY-COLUMN PARTITIONING INDEX. | |
| PH66717 | 2025-08-14 | N/A | UO04468 | AFTER MIGRATION TO DB2 13 FL500 REORG AND LOAD UTILITIES WITH INLINE STATISTICS GET INCREASE IN CPU AND ELAPSED TIME | ||
| PH67680 | N/A | OPEN | ORPHANED ENTRIES LEFT IN RTS DURING PBG TO PBR CONVERSION, WHEN DDL MATERIALIZATION REORG FAILS BEFORE SWITCH PHASE | |||
| PH69138 | 2025-12-23 | Closed | N/A | UO06352 | RUNSTATS UTILITY GETTING ABEND0C4 IN DSNUSUCD +0027E WHEN USING FREQVAL COUNT 0 AFTER MIGRATING TO DB2 V13. | |
| PH69329 | 2026-01-09 | New & Closed | N/A | UO06441 | REORG WITH INLINE STATISTICS SPECIFYING HISTOGRAM OPTION TERMINATES ABNORMALLY WITH ABEND04E RC00E2002F IN DSNSVSFM+00718 |
SQL PERFORMANCE and general HIPERs:
| APAR | CLOSED | STATUS | Db2 12 | Db2 13 | HIPER | Description |
| PH11864 | OPEN | OPEN | SQL SELECT RETURNS INCORROUT AFTER TABLE WITH LOB COLUMNS IS UPDATED | |||
| PH26180 | OPEN | OPEN | CARTESIAN PRODUCT RESULTING FROM INCORRECT JOIN ORDER | |||
| PH51434 | 2024-03-08 | UI96016 | N/A | ABEND04E RC00C90101 IN DSNIRFNX ERQUAL5399 AFTER A REDIRECTED RECOVERY OF BASE + XML TABLES | ||
| PH56333 | 2024-02-01 | UI95514 | UI95515 | Y | LOAD PARALLEL OVERLAYS BUFFER CAUSING ABEND0C4 IN DSNSVSVB AND ABEND04E RC00E2000E IN DSNSVSFB | |
| PH56443 | 2024-04-18 | UI95741 | UI95742 | ABEND04E RC00C90101 DSNKINSL ERQUAL5033 OR DSNIOW ERQUAL5003 USING INSERT ALGORITHM 2 IAG2 | ||
| PH56978 | 2024-02-08 | UI95619 | UI95620 | Y | AN INCORROUT OR A DATA LOSS MAY HAPPEN WHEN A SAME SECTION IS REUSED TO EXECUTE IMMEDIATE A DIFFERENT STATEMENT. | |
| PH57418 | 2024-01-24 | UI95407 | UI95408 | Y | INCORRECT OUTPUT MAY OCCUR FOR SQL REFERENCING A SUM FUNCTION W/ARITHMETIC EXPRESSION & PARAMETER MARKER INSIDE TABLE-EXPR/VIEW | |
| PH57644 | 2024-07-29 | UI97833 | UI97834 | Y | DB2 ABNORMAL TERMINATION WITH RC00F70603 AFTER DSN7508I WAS ISSUED WITH RC08 AND RSN0C080887 | |
| PH57787 | 2024-01-12 | UI95216 | UI95217 | Y | EXCESSIVE DRAIN LOCKS WHEN USING IFI 306 READS CALLS REQUESTING DATA VERSIONING | |
| PH57851 | OPEN | OPEN | ABEND0C4 MAY HAPPEN AT DSNXOGP:0AB44 FOR QUERY WITH MULTI-INDEX ACCESS. | |||
| PH57919 | 2024-06-21 | UI97424 | UI97425 | Y | ABEND04E RC00E510A1 IN DSNVSRX OFFSET3414 DB2 ABNORMAL TERMINATION RC00E50054 | |
| PH57956 | 2024-01-22 | UI95363 | UI95364 | INEFFICIENT ACCESS PATH COULD BE CHOSEN FOR AN SQL STATEMENT WITH ORDER BY | ||
| PH58060 | 2024-03-28 | UI96316 | UI96317 | ABEND04E RC00E70005 DSNXEPM M450 FOR THE QUERY INVOLVING TRIGGER | ||
| PH58135 | 2024-02-14 | UI95690 | UI95691 | Y | ABEND0C4 RC04 IN DSNXEDC OFFSET001B4 MAY OCCUR FOR A QUERY WITH A TABLE EXPRESSION AND A SPATIAL INDEX | |
| PH58214 | 2024-01-29 | UI95467 | UI95468 | A SQL CODE -4743 MAY BE INCORRECTLY ISSUED FOR ALTER VIEW REGENERATE WITH EXPLICIT APPLCOMPAT. | ||
| PH58258 | 2024-04-18 | PE PH62292 | UI96554 | UI96555 | Y | ABEND04E RC00C90101 AT DSNIBHUN ERQUAL5013 DURING ROLLBACK OF GLOBAL TRANSACTION |
| PH58292 | 2024-01-31 | UI95504 | UI95505 | Y | RECOVER UTILITY FROM FLASHCOPY IMAGE COPY GETS ADR017E FROM DFDSS AND ENDS WITH RC08 | |
| PH58325 | 2024-03-05 | UI95962 | UI95963 | Y | INCORROUT MAY HAPPEN IF A QUERY CONTAINS A REDUNDANT PREDICATE ON AN AGGREGATE FUNCTION COLUMN OF A TABLE EXPRESSION | |
| PH58403 | 2024-01-16 | N/A | UI95239 | ABEND04E 00C90101 IN DSNISRTW 5064 | ||
| PH58409 | 2024-03-01 | UI95900 | UI95901 | UNNECESSARY ENTRY IN SYSPACKDEP FOR INDEX ON EXPRESSION | ||
| PH58448 | 2024-03-05 | UI95951 | UI95952 | ABEND04E RC00E70005 AT DSNXISB2 P942 DURING INTERNAL BIND FOR ALTER PROCEDURE | ||
| PH58488 | 2024-02-09 | UI95627 | UI95628 | Y | DB2 IN HANG AFTER WLM DUMP | |
| PH58491 | 2024-02-13 | UI95667 | UI95668 | QUERY WITH SELECT DISTINCT AND OPTIMIZE FOR 1 ROW/FETCH FIRST 1 ROW CLAUSE,DB2 MAY FAVOR ‚O‘ ACCESS WHICH CAUSE POOR PERFORMANCE | ||
| PH58613 | 2024-02-16 | N/A | UI95720 | ABEND04E RC00E70005 AT DSNXEFDA:M122 MAY ISSUE FOR QUERY REFERENCING BOTH VIEW AND BASE TABLE OF THE VIEW | ||
| PH58678 | 2024-07-10 | Fix in error. See PH62423 | UI97619 | UI97620 | DB2 12 AND DB2 13 FOR Z/OS NEW FUNCTION FOR XML | |
| PH58683 | 2024-02-26 | UI95815 | UI95816 | INEFFICIENT INDEX MAY BE CHOSEN FOR AN SQL STATEMENT CONTAINING EQUAL AND RANGE PREDICATES | ||
| PH58686 | 2024-01-29 | UI95457 | UI95458 | Y | ABEND04E 00C90101 AT DSNIBHUN 5020 , DSNIBHRE 5006 AND ABEND04E 00C90102 AT DSNIBHRE 0C26 DURING DR RESTART | |
| PH58722 | 2024-04-11 | See PH63624 for Db2 13 | UI96494 | N/A | EXTERNAL SQL STORED PROCEDURE SOMETIMES FAILS WITH SQLCODE = -20442 USING GLOBAL ARRAY VARIABLE. | |
| PH58730 | 2024-06-17 | UI97365 | UI97366 | A SLOW ACCESS PATH COULD HAPPEN ON A LEFT OUTER JOIN QUERY CONTAINING AN after-join IS NULL predicate | ||
| PH58811 | 2024-02-11 | N/A | UI95506 | Y | ABENDS0C4 RC00000038 DURING REDIRECTED RECOVERY WITH ENHANCED SPACE LEVEL RECOVERY | |
| PH58833 | 2024-02-29 | UI95884 | UI95885 | INCORRECT SYNTAX MAYBE INSERTED INTO SYSIBM.SYSTABLES_PROFILES | ||
| PH58843 | 2024-03-01 | UI95907 | UI95908 | AN ABEND04E FOR DSNXOGP:M833 MAY HAPPEN IF SQLCODE IS ISSUED INTERNALLY AND PUSHDOWN ACCESS PATH IS TO BE USED. | ||
| PH58847 | 2024-03-29 | UI96330 | UI96331 | DB2 ABEND04E RC00C90101 IN DSNIDLDU ERQUAL5016 (IAG2) | ||
| PH58950 | 2024-02-12 | UI95651 | UI95652 | INCORRECT DSNT286I MESSAGE MIGHT OCCUR FOR A TRIGGER PACKAGE CONTAINING SIMPLE WHEN CLAUSE | ||
| PH58984 | 2024-04-03 | UI96356 | UI96357 | AN INEFFICIENT ACCESS PATH MAY BE CHOSEN FOR A QUERY REFERRING TO TABLE DEFINED WITH VOLATILE KEYWORD. | ||
| PH59005 | 2024-05-07 | UI96797 | UI96798 | Y | AN INCORROUT MAY HAPPEN FOR QUERY WITH GROUP BY AND UNION ALL. | |
| PH59030 | 2024-05-30 | PE PH61876 | UI97104 | UI97105 | AN ABEND04E FOR DSNXIALC:P068 MAY HAPPEN WHILE PROCESSING ALTER TABLE STATEMENT. | |
| PH59084 | 2024-02-12 | N/A | UI95650 | Y | INCORRECT MSGDSNU1316I DURING PIT RECOVER FOR LOB TABLE SPACE | |
| PH59094 | 2024-03-01 | See PH54863 | N/A | UI95910 | ABEND04E RC00E2000C AT DSNXKBLM.DSNSVSVB OFFSET00A58 WITH PTF UI92616 APPLIED | |
| PH59102 | 2024-03-22 | UI96208 | N/A | AFTER IMPLICIT AUTO REGENERATE, A FUNCTIONS ASSOCIATED SYSPACKAGE.CREATOR FIELD MAY BE BLANK. | ||
| PH59104 | 2024-04-09 | N/A | UI96424 | Y | IX LOCK ON SYS_PITR INCORRECTLY HELD BY PSEUDO CHECKPOINT PROCESSOR TASK. | |
| PH59153 | 2024-03-06 | UI95982 | UI95983 | A ++HOLD CORRECTION FOR APAR PH57026 PTFS UI94693 (FOR V12) AND UI94694 (FOR V13). 24/01/26 PTF PECHANGE | ||
| PH59192 | 2024-02-01 | UI95518 | UI95519 | Y | HIGH CSA CONSUMPTION BY DB2 | |
| PH59236 | 2024-05-08 | UI96819 | UI96820 | AN ABEND04E MAY HAPPEN FOR DSNXOMTX:M140 FOR A QUERY WITH A TABLE EXPRESSION HAVING GROUP BY AND HAVING CLAUSES. | ||
| PH59348 | 2024-03-08 | PE See PH67531 | UI95948 | UI95949 | Y | LOOP IN CSECT DSN3ID30 WHILE AMGS LATCH IS HELD. |
| PH59381 | 2024-03-07 | UI95985 | UI95986 | Y | QUIESCE UTILITY WITH WRITE(YES) DOES NOT WRITE ALL UPDATED PAGESFROM GBP 24/01/25 PTF PECHANGE | |
| PH59388 | 2024-04-03 | UI96375 | UI96376 | ABEND04E RC00C90101 IN DSNISRID 501E | ||
| PH59407 | 2024-02-28 | See PH53916 | UI95867 | UI95868 | Y | WITH UI92301 APPLIED, GET SQLCODE -204 DUE TO CURRENTSCHEMA NOT APPLIED. |
| PH59411 | 2024-03-18 | See PH49721 | UI96109 | UI96110 | A SQLCODE -104 MAY BE ISSUED WHEN CREATING A STORED PROCEDURE WITH A SIGNAL STATEMENT USING AN UDF. 24/02/06 PTF PECHANGE | |
| PH59413 | 2025-05-30 | N/A | UO03451 | AN UNNECESSARY SORT MAY BE PERFORMED FOR A QUERY USING AN UNION ALL CLAUSE. | ||
| PH59435 | 2024-04-08 | UI96404 | UI96405 | DB2 NATIVE REST MAY NOT CORRECTLY PROCESS JSON ESCAPED INPUT VALUES WHEN THERE ARE MORE THAN 49 INPUT PARAMETERS | ||
| PH59483 | 2024-03-05 | See PH61191 | UI95964 | UI95965 | IAG2 INSERT PROCESSING ABENDS0C4 00000004 PIC04 RC04 IN DSNISFPIOFFSET01598 | |
| PH59494 | 2024-02-20 | UI95760 | UI95761 | WORKFILE ABEND04E RC00C90101 DSNISFW ERQUAL500B OR RC00E72018 DSNXSTSE:P100 | ||
| PH59503 | 2024-03-01 | UI95904 | UI95905 | DB2 NATIVE REST PACKAGES CONTAINS STMTNO COLUMN VALUE 0 FOR ALL ROWS IN SYSIBM.SYSPACKSTMT | ||
| PH59541 | 2024-05-28 | UI97062 | UI97063 | ABND04E 00C90101 DSNOTCSO 5020 [Recursive CTE with LOB Column] | ||
| PH59548 | 2024-04-02 | PE OH61871 | UI96351 | UI96352 | ABEND04E RC00C90101 AT DSNIWNRF:502C WHEN PREDICATE CONTAINS MULTIPLE SUB-SELECT EMBEDDED INSIDE CASE EXPRESSION. | |
| PH59581 | 2024-03-13 | N/A | UI96074 | MAXSORT_IN_MEMORY NOT SET CORRECTLY | ||
| PH59591 | 2024-04-08 | UI96407 | UI96408 | Y | AN ABEND04E MAY HAPPEN FOR DSNXSZK:P035 FOR A QUERY USING PARALLELISM, INDEX ACCESS AND OUTER JOIN. | |
| PH59666 | 2024-03-26 | UI96253 | UI96254 | Y | ECSA STORAGE LEAK IN ADMF IRLM SUBPOOL | |
| PH59813 | 2024-04-03 | N/A | UI96374 | ABEND04E RC00E50007 IN DSNXRLPT AT LOCATION P220 MAY OCCUR | ||
| PH59920 | 2024-04-19 | UI96581 | UI96582 | AN ABEND0C4 MAY HAPPEN AT DSNXOCT+0155E FOR A STATEMENT USING UNION ALL OR UNION. | ||
| PH59939 | 2024-06-25 | UI97458 | UI97459 | AN UTILITY CALL CATMAINT UPDATE SCHEMA SWITCH MAY SWITCH THE SCHEMA FOR AN UDF RESULTING WITH CATALOG INCONSISTENCIES. | ||
| PH60051 | 2024-03-21 | UI96171 | UI96172 | ABEND0C4 RC38 AT DSNXRSGB OFFSET0127E FOR A QUERY WITH A SCALAR FULL/SUBSELECT WITH GROUP BY WITH AN IN PREDICATE | ||
| PH60155 | 2024-04-17 | UI96538 | UI96539 | AN ABEND0C4 MAY HAPPEN AT DSNXOQ2+03FA4 FOR A STATEMENT USING ROW_NUMBER ( ) OVER ( ORDER BY …) CLAUSE AND JOIN PREDICATE. | ||
| PH60161 | 2024-05-09 | UI96831 | UI96832 | AN ABEND0C4 MAY HAPPEN AT DSNXRCLS+0073C FOR A SIMPLE STATEMENT DURING CLEANUP AFTER IT WAS CANCELLED DURING SORT PROCESSING. | ||
| PH60255 | 2024-03-28 | N/A | UI96301 | Y | LISTAGG ISSUE | |
| PH60447 | 2024-05-21 | N/A | UI96993 | Y | ABEND05E RC28 CAN OCCUR FOR A SQL DATA INSIGHTS AI QUERY THAT CONTAINS AI BIFS, AND THE QUERY IS FROM DDF | |
| PH60564 | 2024-06-21 | UI97429 | UI97430 | Y | AN ABEND04E FOR DSNXGDT2:M100 MAY HAPPEN FOR A STATEMENT USING LISTAGG AGGREGATION FUNCTION IN EXISTS CLAUSE. | |
| PH60627 | 2025-03-27 | N/A | UO02562 | Y | INCORRECT OUTPUT RECEIVED AFTER LOAD INDEXDEFER ALL | |
| PH60396 | 2024-04-19 | UI96584 | UI96585 | ABEND04E WITH RC00D31108 IN DSNLCCLO ABNDID0004 MAY OCCUR WHILE RUNNING SQL STATEMENT USING XML DATA | ||
| PH60725 | 2024-05-13 | UI96882 | UI96883 | ABEND0C4 RC38 IN DSNXOTS+18082 CAN OCCUR FOR A QUERY WHERE ONE OF THE TABLES HAS FULLY MATCHING EQUAL UNIQUE INLIST ACCESS | ||
| PH60741 | 2024-05-10 | UI96845 | UI96846 | Y | ABEND04E RC00D10312 LOC=DSNJL002.DSNJR103+009B0 | |
| PH60758 | 2024-05-10 | UI96851 | UI96852 | Y | AN INCORROUT MAY HAPPEN FOR A QUERY USING SPARSE INDEX ACCESS PATH. | |
| PH60776 | 2024-05-16 | UI96929 | UI96930 | PRESERVE THE INDEX PLAN FOR COST COMPETITION TO AVOID SORT PROCESSING OF AN OLAP FUNCTION | ||
| PH60836 | 2024-07-29 | UI97828 | UI97829 | Y | INCORROUT MAY HAPPEN FOR INSERT AND SELECT PROCESSING AFTER A MASS DELETE ON A DECLARED TEMPORARY TABLE WITH NOT LOGGED | |
| PH60879 | 2024-07-11 | UI97627 | UI97628 | Y | ABEND0C7 RC00000000 AT DSNXRRP OFFSET00E6E MAY OCCUR IN A QUERY CONTAINING A CEILING | |
| PH60885 | 2024-08-30 | UI98237 | UI98238 | A SQLCODE -670 MAY BE ISSUED DUE TO AN UNEXPECTED ACCESS PATH CHANGE. | ||
| PH60975 | 2024-05-16 | UI96950 | UI96951 | ABEND04E RC00E72048 IN DSNXSORI:P007 WHEN USING COLUMN MASK AS ARRAY_AGG SORT KEY, MORE THAN ONE EXPR IN THE ORDER BY CLAUSE | ||
| PH60984 | 2024-08-23 | N/A | UI98166 | INCORROUT FOR DISPLAY BLOCKERS(DBNAME) DETAIL IF THE MESSAGE LIMIT EXCEED | ||
| PH61053 | 2024-06-26 | UI97485 | UI97486 | DB2 MAY SELECT AN INEFFICIENT SPARSE INDEX PLAN WHILE AN EQUAL UNIQUE INDEX PLAN CAN BE USED | ||
| PH61100 | 2024-10-01 | PE See PH65334 | N/A | UI98623 | ENHANCEMENTS FOR BIND LOCKING | |
| PH61121 | 2024-05-23 | See PH55497 | N/A | UI97035 | STORAGE LEAK WHEN CALLING A STORED PROCEDURE OR USER DEFINED FUNCTION 24/04/29 PTF PECHANGE | |
| PH61171 | 2024-05-31 | UI97107 | UI97108 | ABENDS0C4 PIC04 RC04 MAY OCCUR WITH RECOVER UTILITY IN DSNIFLRD OFFSET03296 | ||
| PH61191 | 2024-05-29 | See PH56945, PH58137, PH59483 | UI97072 | UI97073 | INSERT ALGORITHM 2 (IAG2) WAS NEVER RE-ENABLED AFTER IAG2 WAS DISABLED WITH MSGDSNI055I 24/05/02 PTF PECHANGE | |
| PH61252 | 2024-06-04 | UI97166 | UI97167 | ABEND0C4 RC0000003B AT DSNXOSUD OFFSET003E4 MAY ISSUE WHEN REBIND QUERY WITH OPTHINT | ||
| PH61318 | 2024-08-14 | PE See PH65055 | UI98024 | UI98025 | ABEND04E RC00C90101 IN DSNIZMOS AT ERQUAL5016 MAY OCCUR ON A WORKFILE TABLESPACE | |
| PH61323 | 2024-07-25 | UI97794 | UI97795 | Y | ABEND04E RC00C200D8 IN DSNB1SWS | |
| PH61391 | 2024-08-01 | See PH59388 | UI97877 | UI97878 | ABEND04E RC00C90101 IN DSNIONXP 1001 | |
| PH61556 | 2024-11-13 | See PH61171 | UI99030 | UI99031 | Y | ABEND04E RC00E40333 IN DSNUCACL DURING RECOVER. |
| PH61607 | 2024-07-19 | UI97703 | UI97704 | DB2 ABNORMAL TERMINATION REASON 00E50702 IN BM, CAUSED BY THE CALL TO FREE FTB STORAGE, AFTER THE START OF REORG UTILITY. | ||
| PH61633 | 2024-07-03 | UI97574 | UI97575 | Y | ABEND04E RC00C90207 DSNIOW ERQUAL5003 24/06/19 PTF PECHANGE | |
| PH61838 | 2024-08-02 | UI97905 | UI97906 | REBIND OF PACKAGE WITH APREUSE WILL FAIL IF THE QUERY MATCHES CERTAIN CONDITIONS | ||
| PH61871 | 2024-07-11 | UI97581 | UI97582 | AN ABEND04E MAY HAPPEN FOR DSNXOFPD:P001 WHEN OUTER JOIN HAS AN AFTER-JOIN PREDICATE THAT IS A SUBQUERY. | ||
| PH61876 | 2024-07-11 | UI97625 | UI97626 | Y | ABEND04E RC00E70005 DSNXIDDL.DSNXICDM:P032 FOR AN ALTER TABLE ALTER PARTITION LIMIT KEY 24/06/14 PTF PECHANGE | |
| PH61908 | 2024-08-26 | UI98179 | UI98180 | AN INEFFICIENT INDEX PLAN MAY BE CHOSEN WHEN THE INDICES ARE COMPETING. | ||
| PH61970 | 2024-11-18 | N/A | UI99104 | Y | New function to enhance EXPLAIN(ONLY) option for REBIND PACKAGE. | |
| PH62055 | 2024-08-16 | UI98054 | UI98055 | ABEND04E RC00C200C3 AT DSNB1REL OFFSET0255A OR RC00C200B0 AT DSNB1GNV OFFSET00C18 | ||
| PH62078 | 2024-08-05 | N/A | UI97915 | INSERT ABENDS0C4 00000038 RC38 PIC38 IN DSNISRTI OFFSET0A694 [IAG2] | ||
| PH62108 | 2024-08-12 | N/A | UI97989 | IFCID IAG2 NEW FUNCTION | ||
| PH62120 | 2024-08-29 | UI98228 | UI98229 | AN ABEND04E RC00E70005 FOR DSNXGDT2:M206 MAY HAPPEN WHEN USING AGGREGATED TIMESTAMP COLUMN IN RANK OLAP FUNCTION. | ||
| PH62143 | 2026-01-19 | New & Closed | UO06509 | UO06510 | Y | Incorrect output when ARRAY_AGG function ORDER BY contains an EXPRESSION |
| PH62149 | 2024-11-18 | N/A | UI99096 | Y | AN ERROR WITH REASON CODE 00C900A6 MAY OCCUR AFTER RUNNING CATMAINT TO BRING UP CATALOG LEVEL FROM V13R1M100 TO V13R1M504 | |
| PH62246 | 2024-08-19 | UI98078 | UI98079 | ABEND0C4 RC04 AT DSNXRBND OFFSET0499C | ||
| PH62292 | 2024-08-08 | See PH58258 | UI97955 | UI97956 | Y | ABEND04E RC00C90101 AT DSNIREPR ERQUAL507E DURING SQL UPDATE 24/07/15 PTF PECHANGE |
| PH62312 | 2024-08-02 | N/A | UI97910 | Y | AI SIMILARITY AND CONDITIONAL BLOCK FETCH WILL NOT WORK PROPERLY | |
| PH62407 | 2024-08-22 | UI98138 | UI98139 | ABEND0C4 RC00000004 AT DSNXRRTN OFFSET011E6 | ||
| PH62452 | 2024-11-06 | UI98979 | UI98980 | ABEND04E 00C90101 AT DSNKFTBU ERQUAL5061 WHEN OTHER DB2 MEMBER IS IN THE MIDDLE OF RESTART [FTB] | ||
| PH62511 | 2024-09-12 | UI98407 | UI98408 | Y | INCORRECT OUTPUT WHEN REFERENCING COLUMN WITH COLUMN MASK TWICE | |
| PH62521 | 2024-09-09 | UI98338 | UI98339 | Y | INCORROUT DUE TO ONE INDEX KEY IS NOT SET UP CORRECTLY WHEN MULTI-INDEX ACCESS IS USED ON TABLE. | |
| PH62543 | 2024-09-06 | N/A | UI98320 | NEW FUNCTION SUPPORT FOR LOAD UTILITY | ||
| PH62549 | 2024-08-30 | UI98239 | UI98240 | Y | PENDING ALTER TABLE TRIGGERED ABEND0C4 DSNICMT2+05E10 ABEND WHENTRIGGERS EXIST | |
| PH62558 | 2024-10-15 | UI98755 | UI98756 | ABEND0C4 RC00000010 DSNXGRDS DSNXOCSC OFFSET1B142 [XML INDEX ISSUE] | ||
| PH62651 | 2024-10-15 | N/A | UI98757 | Y | SQL DI UNEXPECTED NULL RESULT FROM AI FUNCTION | |
| PH62656 | 2024-09-12 | UI98399 | UI98400 | ABEND04E RC00C90101 AT DSNOTFLA ERQUAL5001 FOR QUERY WITH XMLSERIALIZE | ||
| PH62783 | 2024-09-16 | UI98450 | UI98451 | ABEND04E 00C90101 DSNIWKFD:5007 DSNICMT2:50FE | ||
| PH62959 | 2024-11-14 | N/A | UI99057 | UNPRINTABLE ERROR MESSAGE TOKEN IN SQLCODE -551 FOR ADVANCED TRIGGERS | ||
| PH63060 | 2024-11-13 | PE See PH65696 | UI99040 | UI99041 | Y | COPY UTILITY SETS TABLESPACE TO RECP WHILE A REORG IS CONVERTING IT TO PAGENUM RELATIVE IN THE MEANWHILE |
| PH63310 | 2025-04-10 | UO02791 | UO02792 | ABEND0C7 AT DSNXRINT OFFSET04D06 MAY ISSUE FOR SQL STMT CONTAINS HOST VARIABLE AND THE INPUT VALUE OF HV IS NULL | ||
| PH63383 | 2025-02-19 | UO02147 | UO02149 | UNEXPECTED ABEND ON CO-EXISTENCE SYSTEM WHEN ADVANCE TRIGGER IS BEING IMPLICITLY REGENERATED | ||
| PH63830 | 2024-11-11 | UI99004 | UI99005 | A DB2ZAI CLEANUP SYSTEM THREAD IS NOT SHUTTING DOWN WITH A DB2 SHUTDOWN | ||
| PH63624 | 2024-11-20 | N/A | UI99139 | EXTERNAL SQL STORED PROCEDURE SOMETIMES FAILS WITH SQLCODE = -20442 USING GLOBAL ARRAY VARIABLE. (See PH58722) | ||
| PH63641 | 2024-12-31 | UI99554 | UI99555 | ABEND0C4 RC4 AT DSNXOLDE OFFSET0A336 | ||
| PH63720 | 2024-12-09 | UI99347 | UI99348 | AN ABEND04C MAY HAPPEN FOR DSNXGRDS.DSNXOCS+0A426 DURING ACCESS PLAN SELECTION. | ||
| PH63749 | 2024-12-31 | UI99549 | UI99550 | ABEND 4E-00E70005,LOC=DSNXGRDS.DSNXOEA :M888 may occur for an SQL statement that contains tables which may be rewritten by MQTs | ||
| PH63789 | 2025-01-09 | N/A | UI99595 | ABEND04E 00C90101 DSNIREPR ERQUAL 507E | ||
| PH63890 | 2024-12-10 | N/A | UI99368 | Y | 00D94001 AFTER ABEND0C4 RC4 DSNIRLPG+03102 DURING LOAD UTILITY | |
| PH63936 | 2024-12-31 | N/A | UI99546 | Y | LOAD UTILITY ABENDS S04E RC00E40045 OR S0C4. | |
| PH63971 | 2025-01-23 | UI99728 | UI99729 | Y | DB2 SUBSYSTEM HUNG DUE TO A DUPLICATE CONTROL BLOCK BEING ADDED TO THE CHAIN, WHICH RESULTED IN A LOOP IN PROCESSING. | |
| PH64030 | 2025-02-04 | UI99861 | UI99862 | Y | LOAD REPLACE WITH PRESORT PUT THE DISCARD ROWS INTO THE TABLE | |
| PH64166 | 2025-02-13 | UO02073 | UO02074 | Y | INLINE LOB ABENDS0C4 00000004 RC04 PIC04 IN DSNOGETD OFFSET02A16 | |
| PH64207 | 2025-03-07 | UO02384 | UO02385 | COST REDUCTION FOR PIPELINE ACCESS PLANS IN SPECIFIC QUERY CONDITIONS. | ||
| PH64280 | 2025-02-04 | UI99863 | UI99864 | EXECUTION OF THE FREE SERVICE COMMAND WITHOUT APPROPRIATE PRIVILEGES MAY VOID THE CATALOG CONSISTENCY. | ||
| PH64414 | 2025-02-20 | UO02169 | UO02170 | Y | ABEND0D6 RC00D94001 AND ABEND04F RC00000000 DUE TO A STORAGE OVERLAY BY DSNXOSJH WHICH LED TO A DB2 CRASH | |
| PH64523 | 2025-02-19 | N/A | UO02156 | Y | AN INTENTIONAL ABEND04E RC00E70005 MAY HAPPEN FOR DSNXEFDA:M500 FOR AN EXPLAIN STATEMENT. | |
| PH64577 | 2025-03-14 | UO02460 | UO02461 | AN INEFFICIENT ACCESS PLAN MAY BE CHOSEN WHEN COMPARING COVERAGE OF INDEX MATCHING PREDICATES AND INDEX SCREENING PREDICATES. | ||
| PH64590 | 2025-04-25 | UO02959 | UO02960 | AN INEFFICIENT ACCESS PLAN MAY BE CHOSEN WHEN JOINING TABLES. | ||
| PH64620 | 2025-01-31 | N/A | UI99841 | Y | INCORRECT OUTPUT MAY HAPPEN WHEN QUERY CONTAINS A COLUMN XQUERY EXPRESSION CONSTANT OF AN XMLTABLE FUNCTION | |
| PH64622 | 2025-02-28 | UO02297 | UO02298 | AN INTENTIONAL ABEND04E RC00E70005 MAY HAPPEN FOR DSNXOSR:P018 FOR SELECT COUNT DISTINCT ON MASKED COLUMN. | ||
| PH64643 | 2025-02-06 | UI99917 | UI99918 | UPDATE PROCESSING ABEND04E 00C90101 DSNIREPR ERQUAL 5020 | ||
| PH64648 | 2025-02-06 | N/A | UI99915 | ABEND04E RC00E2000F AT DSNXSORI DSNSVSFB OFFSET009B8 ON SORT PROCESSING | ||
| PH64702 | 2025-01-31 | UI99838 | UI99839 | ABEND DB2DIST RC00E70005 DSNXGRTS M248 | ||
| PH64880 | 2025-04-22 | UO02894 | UO02895 | DB2 REFERENCES AN INCORRECT OFFSET OF STORAGE | ||
| PH64900 | 2025-02-06 | UI99919 | UI99920 | AN ABEND0C4 MAY HAPPEN FOR DSNXSIFG+09468 FOR A SORT FOR A QUERY HAVING AN AGGREGATION AND A FFNR AND A GROUP BY CLAUSES. | ||
| PH64948 | 2025-02-28 | UO02299 | UO02300 | AN EXCESSIVE AMOUNT OF HOST VARIABLE DATA MAY BE COLLECTED FOR SOME QUERIES THAT DB2ZAI IS OPTIMIZING FOR SQL OPTIMIZATION | ||
| PH64964 | 2025-03-03 | UO02307 | UO02308 | Y | Long Running UR Created During Db2 restart Forward log recovery due to REDO Log Apply on down level Index Page | |
| PH64966 | 2025-02-19 | UO02154 | UO02155 | Y | ABEND 0C7 RC00000000 IN DSNXRBND AT OFFSET8E2 MAY OCCUR WITH A CASE STATEMENT CONTAINING NEXTVAL. | |
| PH65055 | 2025-04-07 | UO02746 | UO02747 | Y | ABEND04E IN DSNIZMOS AT EQUAL5016 MAY OCCUR WITH A SET OPERATION AND A COMMON TABLE EXPRESSION WITH GROUP 25/02/11 PTF PECHANGE | |
| PH65062 | 2025-04-10 | UO02789 | UO02790 | Y | AN ABEND0C4 FOR DSNXGRDS.DSNXOSOB+01A00 OR AN INCORRECT OUTPUT MAY HAPPEN WHEN AN IN-SUBQUERY ACCESS AND AN OLAP FUNCTION. | |
| PH65134 | 2025-03-14 | UO02458 | UO02459 | INCORRECT OUTPUT RESULT MAY OCCUR WHEN A QUERY CONTAINS A LARGE INLIST WITH SUBSTR,YEAR,DATE COLUMN EXPRESSIONS AND INDEX ACCESS | ||
| PH65237 | 2025-03-14 | N/A | UO02448 | Y | WITH UI99566 APPLIED, ABND=04E-00E20003,LOC=DSNLTEXC.DSNSVBK +02D7A CAN OCCUR | |
| PH65250 | 2025-03-26 | UO02566 | UO02567 | NEW FUNCTION FOR INDEX FAST TRAVERSE BLOCK (FTB) | ||
| PH65291 | 2025-03-26 | N/A | UO02573 | APREUSE FAILS WHEN ATTEMPTING TO REUSE A MULTI-INDEX ACCESS PATH | ||
| PH65334 | 2025-04-08 | N/A | UO02761 | AUTOBIND DEADLOCK WITH ANOTHER AUTOBIND ON SAME PACKAGE MSGDSNT375I 25/03/04 PTF PECHANGE | ||
| PH65369 | 2025-06-17 | UO03684 | UO03685 | Y | AN INCORRECT OUTPUT MAY HAPPEN FOR A QUERY USING THE AGGREGATION FUNCTIONS AND A TABLE WITH DPSI INDEX. | |
| PH65370 | 2025-06-30 | N/A | UO03875 | ABEND0C4 RC00000004 DSNXROHL OFFSET024E WITH SET CURRENT PACKAGE PATH AND TRIGGER WITH SELECT INTO | ||
| PH65380 | 2025-04-22 | UO02904 | UO02905 | Y | ABENDS S0C4-04 & S0C4-10 IN LOC=DSN3AMGP.DSN3AUCN AND POSSIBLE OVERLAY DURING DSN3AUCN RECOVERY CAN CAUSE S0C1 IN DSN3EC0X | |
| PH65441 | 2025-03-28 | UO02621 | UO02622 | AN ABEND0C4 MAY HAPPEN AT DSNXOOS1+09056 WHEN QUERY CONTAINS A CASE CLAUSE WITH A SUBSELECT USING AGGREGATION. | ||
| PH65442 | 2025-04-10 | UO02794 | UO02795 | AN INTENTIONAL ABEND04E RC00E70005 MAY HAPPEN FOR DSNXOB2:M105 WHEN CSWL, UNION ALL AND IOE ARE USED. | ||
| PH65543 | 2025-06-03 | UO03477 | UO03478 | ABEND0C4 RC04 DSNXOGRL OFFSET02D0A WHEN A QUERY RUNS WITH PARALLELISM | ||
| PH65550 | 2025-04-17 | UO02856 | UO02858 | AN ABEND0C4 MAY HAPPEN FOR DSNXOGA1+052DC FOR AN UPDATE STATEMENT WITH A SUBQUERY REFERRING TO A HISTORY TABLE. | ||
| PH65598 | 2025-05-02 | UO03035 | UO03036 | ABEND04E RC00E72068 DSNXSMRE OFFSET06E5C MAY OCCUR WHEN A QUERY IS PROCESSING WITH PARALLELISM TO DO RANGE PARTITIONING FOR SORT | ||
| PH65607 | 2025-06-30 | UO03876 | UO03877 | WORKFILE SYSTEM STORAGE WARNING MSGDSNI053I ISSUED FREQUENTLY EVEN THOUGH PLENTY OF WORKFILE SPACE AVAILABLE | ||
| PH65743 | 2025-05-20 | N/A | UO03312 | Y | ABEND0C4 RC00000010 DSNXECL OFFSET00B84 DUE TO A ONE BIT OVERLAYIN DSNGEPDL WHEN DDL STATEMENT DOES STATEM 25/05/21 PTF PECHANGE | |
| PH65779 | 2025-06-03 | UO3479 | UO03480 | DB2 MAY SELECT AN INSUFFICIENT SPARSE INDEX WHEN A QUERY HAS LEFT JOIN AND ONE OF THE TARGET TABLES IS A VIEW. | ||
| PH65795 | 2025-08-18 | UO04524 | UO04525 | ABEND04E RC00E70005 DSNXEFDA M500 MIGHT OCCUR WHEN QUERY CALLS A UDF THAT REFERENCES A TABLE/VIEW AND THE TABLE/VIEW IS DROPPED | ||
| PH66122 | 2025-05-16 | N/A | UO03281 | Y | REBIND PACKAGE COMMAND DOES NOT RESTORE TO THE SAVE POINT WHEN ENCOUNTERING CERTAIN TYPES OF ERRORS. | |
| PH66158 | 2025-06-24 | UO03801 | UO03802 | Y | ABEND04E RC00E70005 IN DSNXOVM AT M305 WHEN SELECT FROM MERGE STATEMENT CONTAINS INCLUDE COLUMN. | |
| PH66189 | 2025-08-21 | PE See PH68017 | UO04591 | UO04592 | Y | ABND04E RC00C90101 DSNKINSL ERQUAL5033 DURING X->SIX PAGESET P-LOCK DOWNGRADE |
| PH66247 | 2025-08-14 | N/A | UO04469 | ABEND04E RC00E20007 AT DSNSLD4.DSNSVSVP OFFSET0128E | ||
| PH66295 | 2025-06-04 | UO03797 | UO3798 | Y | ABEND04E RC00C90101 IN DSNICUMW ERQUAL5003 FOR A DB2 INTERNAL MODIFY OF DSNDB06.SYSTSTPF. FINALLY DB2 TERMINATION DSNV086E | |
| PH66396 | 2025-10-24 | UO05538 | UO05539 | INCORRECT SORT ORDER IN SQL RESULT USING ORDER BY DESC | ||
| PH66470 | 2025-09-15 | UO04911 | N/A | NEW FUNCTION OF DB2ZAI | ||
| PH66492 | 2025-06-18 | N/A | UO03719 | Y | SYSTEM AGENTS FOR REFRESH PREFETCH HANG | |
| PH66535 | 2025-07-21 | N/A | UO04151 | Y | ABEND04E RC00C90101 IN DSNIRNXT ERQUAL100A DURING SQL SELECT OF AN XML TB | |
| PH66537 | 2026-01-05 | New & Closed | N/A | UO06382 | REORG WITH LOB TABLESPACE USING AUX YES DOES NOT CORRECTLY CLUSTER THE DATA FOR A CLUSTERING INDEX | |
| PH66584 | 2025-08-28 | UO04693 | UO04694 | Y | RECOVER UTILITY WITH THE ERROR RANGE OPTION ON A PARTITIONED TABLE SPACE MAY RESULT IN MISSING OR BROKEN DATA | |
| PH66668 | 2025-07-09 | PE See PH67878 | N/A | UO04009 | Y | PREVENTING V13 LOSS OF DATA INTEGRITY FOR PARTITION-BY-RANGE RPN TABLESPACE RUNNING IN A CO-EXISTENCE ENVIRONMENT [Red Alert 7158065] |
| PH66825 | 2025-06-19 | N/A | UO03735 | ABEND 04E-00E2000F LOC=DSNLJXUS.DSNSVSFB+009B8 | ||
| PH66908 | 2025-08-14 | N/A | UO04471 | ABEND04E RC00E70005 AT DSNXGRDS.DSNXGINB:M200 | ||
| PH66939 | 2025-08-07 | UO4440 | N/A | AN INTENTIONAL ABEND04E MAY HAPPEN FOR DSNXGRDS.DSNXOSJT:M110 FOR A QUERY USING STAR JOINS AND CONTAINING MULTIPLE OUTER | ||
| PH66924 | 2025-07-16 | N/A | UO04107 | AUTOMATIC ML START ALONG WITH DB2 RE-START UPON THE LATEST ACTIVE ML STATUS MIGHT NOT WORK CORRECTLY | ||
| PH66984 | 2025-10-14 | UO05333 | UO05334 | ABEND04E RC00E70005 IN DSNXGRTS AT LOCATION M307 WHEN A JOIN PREDICATE REFERENCES A COLUMN DEFINED WITH FIELDPROC | ||
| PH67024 | 2025-07-30 | UO04337 | UO04338 | ABEND 04E RC00C90206 DSNIIDIS 5002 | ||
| PH67193 | 2025-09-12 | UO04867 | UO04868 | AN ABEND0CF MAY HAPPEN AT DSNXODFE+0161A FOR A QUERY REFERENCING PREDICATE WITH COLUMN HAVING ONLY ONE DISTINCT VALUE IN STATS. | ||
| PH67253 | 2025-10-08 | UO05257 | UO05258 | Y | AN INTENTIONAL ABEND04E MAY HAPPEN FOR DSNXRIPS:M125 FOR A QUERY USING PARALLELISM, DPSI AND EARLY OUTPUT. [DEGREE=1 to avoid parallelism might help] | |
| PH67324 | 2025-09-15 | UO04913 | UO04914 | AN ABEND0C4 MAY HAPPEN AT DSNXOPCO+08EFC FOR A QUERY REFERENCING A CTE AND A UNION ALL. | ||
| PH67359 | 2025-10-07 | N/A | UO05230 | Y | LOAD RESUME YES WITH BACKOUT YES AND PARALLELISM ABEND04E RC00E4D5D2 IN DSNURWT+0A822 | |
| PH67531 | 2025-09-22 | UO05023 | UO05024 | Y | ABEND0C4 DSNYEATE +90 WHEN REFERENCING REGISTER 6 25/10/22 PTF PECHANGE | |
| PH67572 | 2025-10-16 | UO05365 | UO05366 | ABEND0C4 RC10 AT DSNXOGA1 OFFSET00386 FOR A QUERY THAT CONTAINS A TOP UNION ALL | ||
| PH67598 | 2025-10-29 | UO05593 | UO05594 | Y | AFTER CF OUTAGE GBP STRUCTURES COULD NOT SUCCESSFULLY RECONNECT (AS INDICATED BY IXL040E IXL049E). THIS LED TO A DB2 HANG | |
| PH67774 | 2025-11-05 | N/A | UO05686 | Y | ABENDS0C4 00000038 RC38 PIC38 IN DSNIASFP OFFSET0162C WITH DB2 CRASH DSNV086E 00E50702 | |
| PH67795 | 2025-11-19 | N/A | UO05866 | Y | ABEND04E RC00C90110 MAY BE ISSUED FOR DSNGD001 DSNGDART ERQUAL505D DURING ALTER TO DROP ARCHIVING 25/08/19 PTF PECHANGE | |
| PH67847 | 2025-09-17 | N/A | UO04939 | Y | STORAGE LEAK IN Db2 Lock Manager TRWA Pool IMPACTING PERFORMANCE | |
| PH67878 | 2025-10-01 | N/A | UO05179 | Y | PBR RPN TABLESPACES INCORRECTLY BLOCKED IN A NON-DATA SHARING ENVIRONMENT WITH PH66668/UO04009 APPLIED 25/09/03 PTF PECHANGE | |
| PH67952 | 2025-10-07 | N/A | UO05235 | BIND WITH APREUSE OR OPTHINT CHANGES PAGE_RANGE TO YES WHEN A NON-PARTITIONING INDEX PARTIALLY MATCHES THE PARTITIONING KEY | ||
| PH68017 | 2025-10-20 | UO05414 | UO05416 | Y | ABEND04E RC00E50001 AT DSNB1CPS +02E64 FOLLOWED BY MSGDSNV086E DB2 ABNORMAL TERMINATION RC00E50702 25/09/05 PTF PECHANGE | |
| PH68035 | 2025-12-02 | UO06042 | UO06044 | ABEND04E RC00E72018 DSNXSZK P035 WHEN A PLAN WITH OPTHINT IS BOUND WITH APREUSE | ||
| PH68057 | 2025-12-09 | N/A | UO06137 | DB2 ISSUES ABND0C4 DUE TO BAD INPUT REST SERVICES REQUEST DATA PAYLOAD WHEN IT SHOULD RESULT IN ERROR MESSAGE/RESPONSE CODE. | ||
| PH68058 | 2025-12-09 | New & Closed | N/A | UO06139 | WITH DDL_MATERIALIZATION = ALWAYS_PENDING CONFIGURED, DROPPING XML TYPE MODIFIER DOESN’T DROP THE MODIFIER | |
| PH68241 | 2025-10-27 | UO5568 | UO5569 | Y | DURING INSERT ABENDS0C4 PIC38 RC38 IN DSNKINSL OFFSET1902E | |
| PH68326 | 2025-10-15 | N/A | UO5348 | Y | WITH PH67380/UO04472 APPLIED ARCHIVE LOGS CAN EXCEED MAX OF 10,000 25/09/29 PTF PECHANGE | |
| PH68458 | 2025-12-30 | Closed | UO06369 | UO06370 | A BIND OF A QUERY MAY RESULT WITH AN OPTHINT/APREUSE FAILURE (WITH REASON 50) IN PLAN_TABLE. | |
| PH68544 | 2025-12-30 | Closed | UO06372 | UO06373 | AN INTENTIONAL ABEND04E RC00E70005 MAY BE ISSUED FOR DSNXOTS:M099 WHEN CREATING A STORED PROCEDURE. | |
| PH68546 | 2025-11-21 | UO05918 | UO05919 | AN ABEND0C4 RC00000010 MAY HAPPEN AT DSNXOMS+002E0 FOR A STATEMENT USING AN IOE AND A RID ACCESS. | ||
| PH68575 | 2025-11-13 | UO05777 | UO05778 | Y | DATA LOSS DURING REORG OF A SUBSET OF PARTITIONS OF A PBG TABLESPACE USING ‚SORTDATA NO‘ AND SORTNUM AND DB2SORT | |
| PH68610 | 2025-12-19 | New & Closed | N/A | UO06335 | DB2: RC00E72018,LOC=DSNXGRDS.DSNXSIGS ERROR OCCUR WHEN RUNNING QUERY WITH UNION ALL | |
| PH68614 | 2025-11-21 | UO05920 | UO05921 | AN ABEND0C4 RC00000010 MAY HAPPEN AT DSNXOQSJ+00EC2 FOR A STATEMENT THAT MAY USE A STAR JOIN. [Interesting example of DSN_INLINE_OPT_HINT here!] | ||
| PH68641 | 2025-11-13 | See PH66924 | UO05790 | UO5791 | AN INTENTIONAL ABEND04E RC00C90101 MAY HAPPEN FOR DSNIDM.DSNIBNRF:5002 DURING DB2ZAI DATA COLLECTION IN DB2ZAI 1.6.2. | |
| PH68682 | 2025-12-09 | UO06144 | UO06145 | ABEND0C7 RC00 IN DSNXRDEC AT OFFSET077CE MAY OCCUR WHEN DECIMAL TYPE SQL variable IS NULL IN SQL | ||
| PH68936 | 2025-12-19 | Closed | UO06336 | UO06337 | AN INTENTIONAL ABEND04E RC00E70005 MAY HAPPEN FOR DSNXOB2:M105 WHEN EXECUTING A QUERY USING AN UDF CALLED USING HOST VARIABLE. | |
| PH68967 | 2025-12-19 | New & Closed | UO06341 | UO06342 | ABEND0C4 AT DSNXGRDS.DSNXOCU +00190 OCCURS WHEN A UNQUALIFIED TRANSITION VARIABLE PASSED TO A CALL STMT INSIDE ADVANCD TRIGGER | |
| PH69110 | N/A | OPEN | ABEND04E RC00D3001A MAY OCCUR IN DSNXRPJP OFFSET04614 FOR PAIR-WISE JOIN ACCESS FOR A QUERY. | |||
| PH69125 | N/A | OPEN | VARIOUS ABENDS IN DSNNXML DSNNOSRT MAY OCCUR WHEN SUBSTR OF XMLSERIALIZE BUILT IN FUNCTION IS FETCHED FOR A REMOTE QUERY | |||
| PH69250 | 2026-01-09 | Closed | N/A | UO06449 | DOCUMENTATION CHANGE APAR FOR INDEX MANAGER FTB REASON CODES | |
| PH69268 | N/A | OPEN | AN APREUSE FAILURE OCCURS WHEN THE ACCESS PATH TO BE REUSED HAS A COMBINATION OF LIST PREFETCH AND SET FUNCTION ACCESS=X | |||
| PH69272 | N/A | OPEN | ABEND0C4 AT DSNB1ABS OFFSET029F4 OR ABEND0C4 AT DSNGERBK OFFSET01A3C OR ABEND04E AT DSNSVSFB OFFSET009B8 OR OTHER ABENDS | |||
| PH69367 | N/A | OPEN | COST REDUCTION FOR SINGLE TABLE QUERY TO AVOID MATERIALIZATION OR SORTING WHEN USING OPTIMIZE FOR 1 ROW / FETCH FIRST 1 ROW | |||
| PH69629 | New | N/A | OPEN | MISSING REVOKE DEPENDENCY RECORDS IN SYSXXXAUTH TABLES. | ||
| PH69673 | New | N/A | OPEN | DB2 DISPLAY STATS(ITC) COMMAND USABILITY IMPROVEMENTS FOR INDEX MANAGER FAST TRAVERSE BLOCKS (FTB) |
If you have any comments or wishes please feel free to contact me!
TTFN,
Roy Boxwell