All data older than 23rd January 2023 has been purged. A very quiet month to start the year!
HIPERs:
Db2 13 only – PH63936: LOAD UTILITY ABENDS S04E RC00E40045 OR S0C4.
Interesting for RTS:
None.
RUNSTATS:
None.
Query performance:
PH63749: ABEND 4E-00E70005,LOC=DSNXGRDS.DSNXOEA :M888 may occur for an SQL statement that contains tables which may be rewritten by MQTs
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 |
| PH53837 | 2023‑06‑08 | UI92151 | UI92152 | RIGHT AFTER START DB2 WITH ZPARM RETRY_STOPPED_OBJECTS YES, STOP DB(DSNDB01) SP(*) NEEDS LONG TIME TO COMPLETE. | ||
| PH54700 | 2023‑09‑07 | UI93485 | UI93486 | Y | REORG SHRLEVEL CHANGE OF DSNDB06.DBD01 LEAVES RESIDUAL RTS ROWS AND ORPHAN OBDS FOR THE MAPPING OBJECTS IN THE DBD | |
| PH57012 | 2023-11-27 | UI94631 | UI94632 | THE NLEVELS COLUMN IN THE SYSIBM.SYSINDEXSPACESTATS CATALOG TABLE HAS A HIGH VALUE. | ||
| 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 | N/A | OPEN | SYSTABLESPACESTATS.REORGUNCLUSTINS IS INCORRECTLY UPDATED FOR SEGMENTED TSS WITH MEMBER CLUSTER FOR SQL INSERT. |
RUNSTATS APARs:
| APAR | CLOSED | STATUS | Db2 12 | Db2 13 | HIPER | Description |
| PH51750 | 2023‑05‑16 | N/A | UI91849 | UTILITY HISTORY IS NOT COLLECTED WHEN A UTILITY TARGET IS AN INDEX AND THE INDEX CREATOR IS OMITTED. | ||
| PH51766 | 2023-03-29 | PE see PH56078 PH56389 | UI91174 | UI91175 | Y | EXCESS STORAGE CONSUMPTION BY THOUSANDS OF 022.WDFND THREADS |
| PH51901 | 2023‑02‑22 | UI90670 | UI90671 | RUNSTATS INVALIDATECACHE FUNCTION CAUSES ACCESSPATH PROBLEMS | ||
| PH51905 | 2023‑05‑11 | UI91777 | UI91778 | PCTROWCOMP SET BY RUNSTATS MIGHT BE INACCURATE | ||
| PH52439 | 2023‑05‑12 | UI91785 | UI91786 | TERM UTILITY COMMAND HANGS | ||
| PH53677 | 2023‑06‑08 | UI92149 | UI92150 | ABEND04E RC00C90205 DSNIOST2 ERQUAL504E ON A SELECT – Actually a parallel DELETE and RUNSTATS | ||
| PH54155 | 2023-12-28 | PE PH60632 | UI95076 | UI95077 | ICE046A RUNNING REORG WITH VERY MANY AND LARGE COLGROUPS IN A USE PROFILE FOR COLLECTING DISTRIBUTED STATS – ST01WKNN ISSUE | |
| PH55076 | 2023‑07‑07 | UI92645 | UI92646 | RECURRING ROW WITH REASON=CONFLICT IN SYSIBM.SYSSTATFEEDBACK AFTER RUNSTATS | ||
| PH55205 | 2023-08-11 | UI93158 | UI93159 | Y | ABEND0C4 RC38 AT DSNXECWA OFFSET0A636 DURING ABORT PROCESSING. SUBSYSTEM TERMINATED WITH ABEND04F RC00E50702 | |
| PH55296 | 2023‑07‑22 | UI92859 | UI92860 | RUNSTATS UPDATE PROFILE MESSAGE MSGDSNU1360I DISPLAYED IN OUTPUT | ||
| PH55914 | 2023‑08‑16 | N/A | UI93217 | NEW FUNCTION (actually two RUNSTATS bugs!) | ||
| PH57213 | 2023-12-08 | UI94836 | UI94837 | REORG WITH INLINE STATISTICS GETS MSGDSNU622I WITH RC00C9004F WHEN UPDATING THE FREQUENCY IN SYSIBM.SYSCOLDIST | ||
| PH57516 | 2024-04-19 | UI96586 | UI96587 | PCTROWCOMP VALUE IS INCONSISTENT BETWEEN REORG WITH STATISTICS OPTION AND RUNSTATS | ||
| PH57537 | 2023-11-09 | UI94411 | UI94412 | FTB ACTIVATED BUT NO INDEX WAS LOADED IN MEMORY | ||
| 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. |
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 | |||
| PH46567 | 2023-02-15 | UI90541 | UI90542 | Y | EDM POOL ABEND04E RC00C90101 IN DSNGERBK ERQUAL 5015 | |
| PH46568 | 2023-01-23 | N/A | UI90223 | UNNECESSARY OVERFLOW RECORD IS CREATED FOR PAGE LEVEL LOCKING OBJECTS | ||
| PH49825 | 2023-04-10 | UI91369 | UI91370 | ORPHANED ROWS IN SYSIBM.SYSPACKDEP AFTER DROP VIEW | ||
| PH50410 | 2023-05-15 | UI91799 | N/A | DIAGNOSTIC APAR TO PRODUCE A DUMP WHEN MSGDSNI055I IS ISSUED INDICATING IAG2 HAS BEEN DISABLED. | ||
| PH50624 | 2023-01-23 | UI90224 | UI90225 | DSNIDLDU:5016 ABEND DURING LOAD RESUME IN DB2 12. | ||
| PH50781 | 2023-02-13 | UI90503 | UI90504 | Y | DB2 RECOVERY-LOOP WITH REPETITIVE ABEND0C4 RC10 AT DSNXRIHB OFFSET2D490 AT LEVEL UI65759 | |
| PH50959 | 2023-02-16 | UI90575 | UI90576 | Y | SELECT ENTERED INTO A LOOP BETWEEN DSNKTRAV AND DSNKNXT2 IN FTB PROCESS (Non-unique support problem) | |
| PH51086 | 2023-04-06 | UI91132 | UI91133 | Y | ABND=04E with RC00E50053 or RC00E20042 leads to DB2 crash with RC00E50727. | |
| PH51088 | 2023-04-07 | UI91344 | UI91345 | ABEND0C4 RC00000010 MAY HAPPEN IN DSNXRRID OFFSET007618 FOR A QUERY USING PREFETCH=’L‘ ACCESS | ||
| PH51181 | 2023-02-08 | UI90445 | UI90446 | Y | SERVICEABILITY APAR TO TAKE DIAGNOSTIC DUMP TO PREVENT DUPLICATEQWE PUT ON CHAIN LEADING TO LOOP IN PROCESSING | |
| PH51264 | 2023-01-30 | UI90327 | UI90328 | ABEND04E RC00C90101 AT DSNIBCTD ERQUAL5007 MAY OCCUR FOR EXPLAIN AN SQL STATEMENT | ||
| PH51404 | 2023-03-23 | UI91051 | UI91052 | ALTER TABLESPACE MOVE TABLE MAY INPROPERLY HANDLE 3-PART TABLE NAMES | ||
| PH51434 | 2024-03-08 | UI96016 | N/A | ABEND04E RC00C90101 IN DSNIRFNX ERQUAL5399 AFTER A REDIRECTED RECOVERY OF BASE + XML TABLES | ||
| PH51565 | 2023-02-13 | PE PH52893 | N/A | UI90510 | FTB NEW FUNCTION | |
| PH51766 | 2023-03-29 | See PH56078 | UI91174 | UI91175 | Y | EXCESS STORAGE CONSUMPTION BY THOUSANDS OF 022.WDFND THREADS |
| PH51860 | 2023-01-31 | UI90345 | UI90346 | ABEND04E RC00E70005 IN DSNXOUWF P009 MAY OCCUR FOR A QUERY WITH A SCROLLABLE CURSOR AND OUTER JOIN | ||
| PH52051 | 2023‑02‑16 | UI90584 | N/A | QUERY USING LISTAGG FUNCTION MAY ISSUE SQLCODE ‑137 DESPITE THAT PROPER LENGTH WAS PROVIDED ON INPUT. | ||
| PH52112 | 2023‑04‑07 | UI91333 | UI91334 | Y | ABND0C4‑04 IN DSN3AMGP.DSN3AUCM AT +00AF4 | |
| PH52126 | 2023‑04‑07 | UI91331 | UI91332 | Y | QUERY RECEIVES SQLCODE ‑312 FOR A MERGE STATEMENT WITH HOST VARIABLES WHEN BATCH NODE IS ENABLED WITH DB2JCC4 DRIVER | |
| PH52147 | 2023‑03‑01 | UI90806 | UI90807 | Y | STORAGE OVERLAY ABEND04E RC00E2002F IN DSNSVSFM OFFSET00702 AND DB2 CRASH MSGDSNV086E RC00D96001 | |
| PH52155 | 2023‑03‑03 | UI90770 | UI90771 | Y | INCORROUT MAY OCCUR FOR A QUERY USING OUTER JOIN | |
| PH52180 | 2023‑05‑03 | UI91674 | UI91675 | Y | ABEND04E RC00E3007B DSNTGSCC DSNTABA | |
| PH52273 | 2023‑03‑23 | UI91053 | UI91054 | Y | ABEND0C4 RC38 IN DSNXRINT OFFSET00904 IN ALTER TABLESPACE STMT OF MAXPARTITIONS TO CONVERT AN EMPTY DEFINE NO TABLESPACE TO PBG | |
| PH52275 | 2023‑03‑14 | See PH54566 | UI90954 | UI90955 | Y | ABEND0C4 RC38 IN DSN3EOT0 OFFSET0992 |
| PH52279 | 2023‑02‑24 | UI90721 | UI90722 | SQLCODE418 MAY BE RETURNED FOR AN SQL STATEMENT THAT CONTAINS ANXMLTABLE JOINED WITH A VIEW OR TABLE EXPRESSION | ||
| PH52397 | 2023‑03‑13 | UI90932 | UI90933 | DB2 MAY ISSUE SQLCODE ‑204 OR ABEND04E RC00E70005 IN DSNXGRDS.DSNXOFL:M110 FOR TUDF CONTAINING COMMON TABLE | ||
| PH52442 | 2023‑04‑03 | UI91102 | UI91103 | ABEND04 RC00C90101 AT DSNIDEFS:5001 | ||
| PH52455 | 2023‑04‑07 | UI91348 | UI91349 | INLIST PREDICATE PUSHDOWN INTO VIEW OR TABLE EXPRESSION MAY BE INCORRECTLY HANDLED CAUSING ABEND0C4 RC00000010 IN DSNXOPRS+03A58 | ||
| PH52534 | 2023‑03‑24 | UI91123 | UI91124 | ABEND04E RC00E70005 AT DSNXGRTS:M902 MAY HAPPEN FOR QUERY WITH OFFSET AND UNION ALL WHEN USED IN CURSOR WITH INSENSITIVE SCROLL | ||
| PH52650 | 2023‑04‑07 | UI91342 | UI91343 | INCONSISTENCIES AND VARIOUS ABEND04E RC00C90101 RC00C90216 RC00C9021C DUE TO OVERLAY CAUSED BY MASS DELETE | ||
| PH52651 | 2023‑04‑14 | UI91460 | UI91461 | Y | DDF ABNORMALLY TERMINATED WITH ABEND04E RC00D30014 IN DSNLMTOK:0001 DUE TO LUWID TOKENS BEING EXHAUSTED. | |
| PH52653 | 2023‑04‑27 | UI91589 | UI91590 | Y | PERFORMANCE DEGRADATION FOR FREE PACKAGE ‑ INCREASED I/O ON THE DB2 CATALOG (SYSIBM.SYSPACKAUTH) 23/04/18 PTF PECHANGE | |
| PH52717 | 2023‑04‑07 | PE PH54823 | UI91352 | UI91353 | Y | INCORROUT FOR QUERY REFERENCING COLUMNS THAT HAVE COLUMN MASKS DEFINED AND ONE REFERENCES A GLOBAL VARIABLE |
| PH52808 | 2023‑03‑14 | UI90958 | UI90959 | MSGBPXF024I MESSAGES OCCUR IN DB2 WHEN ENABLING AND DISABLING MULTIPLE PACKAGES VERY QUICKLY IN SQL SCOPE SETTINGS FROM DB2ZAI | ||
| PH52821 | 2023‑05‑05 | UI91713 | UI91714 | Y | THREADS HUNG IN DSNB1LTS AND DSNB1LTX WAITING ON A PAGE LATCH | |
| PH52893 | 2023‑03‑17 | N/A | UI91002 | OBSOLETE FTB MSGDSNI070I MESSAGE DISPLAYED FOR V13 23/02/27 PTF PECHANGE | ||
| PH52915 | 2023‑04‑28 | UI91610 | UI91611 | ABEND0C4 RC04 AT DSNXRSOR OFFSET00136 FOR QUERY THAT INCLUDES OUTER JOIN AND INNER JOIN, SUBQUERY PREDICATE AND DISTINCT | ||
| PH52988 | 2023‑04‑12 | UI91424 | UI91425 | DB2 MAY CHOOSE AN INDEX WITH ONLY MATCHING PREDICATES INSTEAD OF A BETTER PERFORMING INDEX WITH MATCHING&SCREENING PREDICATES | ||
| PH53069 | 2023‑04‑14 | N/A | UI91462 | Y | ABEND05E RC28 AND DB2 ABNORMAL TERMINATION RC00E50054 FOR SQL DATA INSIGHTS QUERY RUNNING FROM A DDF THREAD | |
| PH53084 | 2023‑06‑07 | UI92131 | UI92132 | ABEND04E RC00C90101 IN DSNK1CNE 5005 | ||
| PH53176 | 2023‑05‑16 | UI91834 | UI91835 | Y | RC00C90206 DSNIIDIS ERQUAL5002 INDEX DATA INCONSISTENCIES ARE REPORTED DUE TO PAGE REGRESSION 23/03/12 PTF PECHANGE | |
| PH53237 | 2023‑04‑13 | UI91447 | UI91448 | INEFFICIENT ACCESS PATH COULD BE CHOSEN FOR A SQL STATEMENT WITH CSWL ENABLED COMPARING TIMESTAMP(6) COLUMN WITH LITERAL VALUE. | ||
| PH53318 | 2023‑04‑12 | UI91421 | UI91422 | AFTER APPLYING PH44833/UI83589 SQLCODE904 WITH RC00E70082 MAY OCCUR DUE TO NOT DECREMENTING UDF INTERNAL COUNTER | ||
| PH53426 | 2023-08-01 | UI92997 | UI92998 | AFTER SPLITTING OF LAST PBR PARTITION (ALTER+ADD PARTITION), QUERY USING PARTITIONED INDEX ACCESS MIGHT NOT RETURN ALL ROWS. | ||
| PH53525 | 2023-08-31 | UI93410 | UI93411 | Y | ABEND0C4 RC00000038 IN DSNGESLC OFFSET0226A WHEN A PLAN WAS CANCELLED IN A DATA SHARING ENVIRONMENT | |
| PH53561 | 2023‑05‑01 | UI91627 | UI91628 | ABEND04E RC00E70005 AT DSNXEBR M666 COULD HAPPEN WHEN THERE ARE TWO CONDITIONS RAISED DURING THE OR PREDICATE (This is for XML) | ||
| PH53566 | 2023-07-26 | UI92909 | UI92910 | Db2 zAI 1.5 New Function | ||
| PH53572 | 2023‑04‑30 | UI91621 | UI91622 | ABEND04E RC00C90101 IN DSNIWIPR ERQUAL5064 RUNNIG A VERY COMPLEX QUERY | ||
| PH53600 | 2023-04-28 | UI91612 | UI91613 | BIND/REBIND WITH APREUSE MIGHT FAIL IF AP CONTAINS RANGE LIST INDEX SCAN WHICH CAN AVOID SORT | ||
| PH53621 | 2023‑05‑25 | UI91977 | UI91978 | Y | INCORROUT MAY HAPPEN WHEN QUERY USES HINT WHERE QBLOCK_TYPE OF CHILD QUERY BLOCK IS NOT VALID FOR PARENT QUERY BLOCK | |
| PH53717 | 2023‑04‑28 | N/A | UI91614 | Y | WORKFILE SORT ERROR MSGDSNT501I 0000006C 00000D02 DSNDB07 | |
| PH53747 | 2023‑05‑01 | UI91629 | UI91630 | Y | ABEND04E RC00C90101 DSNGEDFR:50FF, ABEND04E RC00E3000A AT DSNTFRCV OFFSETF92 AND ABEND0C4 RC38 AT DSNTFRCV OFFSETF76 | |
| PH53779 | 2023‑06‑26 | UI92474 | UI92475 | REBIND WITH OPTHINT CAN BE SUCCESSFUL EVEN THOUGH MULTI‑INDEX PLAN IS NOT THE SAME | ||
| PH53809 | 2023‑05‑16 | UI91846 | UI91847 | ABEND0C7 RC00 IN DSNXRDEC OFFSET08A4C MAY OCCUR WHILE RUNNING SQL SELECT WITH PARALLELISM | ||
| PH53916 | 2023-06-16 | See PH59407 | UI92301 | UI92302 | DB2CONNECT NON-JAVA APPLICATIONS CREATING A VAST AMOUNT OF CONNECTIONS. | |
| PH53968 | 2023-09-20 | UI93657 | UI93658 | IMPROVE PERFORMANCE OF STORAGE POOL FOR RMID=BB1RMID | ||
| PH54009 | 2023-06-09 | IRLM UI92175 | Y | ABEND04E RC00C90101 IN DSNICUMW 5003 AND DSNKNXT2 5004 | ||
| PH54023 | 2023‑05‑17 | N/A | UI91868 | FTB NEW FUNCTION | ||
| PH54370 | 2023‑06‑24 | UI92432 | UI92433 | ABEND04E RC00E70005 AT DSNXRFF M105 FOR AN ADVANCED TRIGGER WHEN SPECIAL REG CURRENT PACKAGE PATH IS SET ON TRIGGERING SQL | ||
| PH54397 | 2023-08-30 | UI93365 | UI93366 | LESS ROWS MIGHT BE RETURNED FOR FETCH FROM PARTITIONED TABLE WITH A DPSI INDEX WHEN THERE IS CROSS-PARTITION UPDATE. | ||
| PH54410 | 2023‑06‑28 | UI92539 | UI92540 | PREPARE THE SIMPLIFICATION OF DB2ZAI(DB2 AI FOR Z/OS) | ||
| PH54429 | 2023-08-08 | See PH57550 for Db2 12 | N/A | UI93105 | ABEND04E RC00E2000F FOR DSNSVSFB OFFSET 009B8 MAY ISSUE FOR BIND/REBIND USING PLANMGMT WITH APREUSE | |
| PH54439 | 2023‑06‑23 | UI92428 | UI92429 | ABEND04E RC00E70005 AT DSNXOBM P110 CAN HAPPEN WHEN QUERY CONTAINS AN OUTER JOIN AND A BETWEEN PREDICATE ON THE OUTER JOIN | ||
| PH54507 | 2023‑06‑09 | PE PH56254 | UI92181 | UI92182 | SERIOUS PERFORMANCE DEGRADATION WHEN RUNNING DB2 QUERIES | |
| PH54511 | 2023‑06‑23 | UI92418 | UI92419 | FOR TABLE WITH MANY INDEXES, INDEX PRUNING MAY GET RID OF GOOD INDEX AND DEGRADE PERFORMANCE. | ||
| PH54566 | 2023‑06‑28 | UI92532 | UI92533 | Y | ABEND0C4 RC04 IN DSN3ID50 OFFSET0568 23/05/18 PTF PECHANGE | |
| PH54670 | 2023‑06‑22 | UI92401 | UI92402 | Y | HYBRID JOIN MAY CAUSE INCORRECT OUTPUT OF LOB COLUMN | |
| PH54695 | 2023-06-26 | UI92467 | UI92468 | ABND=04E-00D31010 LOC=DSNLILLM.DSNLCMSL:0002 DURING NEXT FETCH OF XML COLUMN USING PROGRESSIVE REFERENCES. | ||
| PH54701 | 2023‑08‑28 | UI93325 | UI93326 | DB2XML.HTTPGETCLOB MAY RETURN SQLCODE ‑4302 | ||
| PH54783 | 2023-09-11 | UI93531 | UI93532 | REORG WITH STATISTICS INDEX OPTION MISSES STATISTCICS OF SOME KEY COLUMNS COMBINATIONS IN SYSCOLDIST | ||
| PH54823 | 2023‑08‑08 | UI93101 | UI93102 | ABEND04E RC00E70005 AT DSNXOV1 M600 WITH UI91352 (V12) OR UI91353 (V13) APPLIED | ||
| PH54863 | 2023‑07‑06 | PE PH59094 | N/A | UI92616 | NEW FUNCTION | |
| PH54901 | 2023-09-06 | UI93463 | UI93464 | Y | DURING RESTART LIGHT, DB2 ABENDS S04E RC00C20101 IN DSNB1ABS FOR A PGSTEAL(NONE) BUFFERPOOL. | |
| PH55018 | 2023‑07‑21 | UI92854 | UI92855 | ABEND0C4 RC38 IN DSNXOSOB OFFSET020A0 COULD HAPPEN FOR AN SQL STMT THAT CONTAINS AN EXISTS SUBQUERY PREDICATE WITH UNION/UNION | ||
| PH55049 | 2023‑07‑13 | UI92713 | UI92714 | INCORRECT FTB DMCFTOM LATCH CLASS | ||
| PH55078 | 2023‑08‑30 | N/A | UI93373 | DIAGNOSTIC APAR TO ADD MORE IAG2 INFORMATION IN THE DIAGNOSTIC LOG RECORDS WHEN DSNI055I IS ISSUED. | ||
| PH55169 | 2023-07-07 | UI92463 | UI92644 | ABND=04E-00D35011 IN DSNLZLLM.DSNLZS00:003C DURING CALL OF A STORED PROCEDURE. | ||
| PH55205 | 2023‑08‑11 | UI93158 | UI93159 | Y | ABEND0C4 RC38 AT DSNXECWA OFFSET0A636 DURING ROLLBACK PROCESSING. SUBSYSTEM TERMINATED WITH ABEND04F RC00E50702 | |
| PH55215 | 2023‑08‑10 | UI93125 | UI93126 | Y | INCORRECT OUTPUT MAY OCCUR FOR SQL STATEMENT REFERENCING A SET FN WITH A DECIMAL ARITHMETIC EXPR CONTAINING A PARAMETER MARKER | |
| PH55255 | 2023-08-23 | UI93292 | N/A | FTB NEW FUNCTION Add FTB Factor to DISPLAY STATS(ITC) output and IFCID 389 | ||
| PH55294 | 2023-09-18 | UI93601 | UI93602 | Y | AFTER ROLLBACK OF ALTER INDEX PIECESIZE OF NPI, AN OBD FIELD MAY BE SET INCORRECTLY, CAUSING ERROR ON REPAIR DBD REPAIR/TEST | |
| PH55379 | 2023-08-02 | UI93027 | UI93028 | ABEND04E RC00E70005 DSNXOTS P666 CAN HAPPEN WHEN PROCESSING SORTMERGE JOIN PREDICATES DIFFERENTLY WHEN JOIN PREDICATE PUSHDOWN | ||
| PH55385 | 2023-08-29 | UI93355 | UI93356 | Y | ABEND04E RC00C200C6 DSNB5SCM OFFSET04EE0 AFTER CANCEL OF BIND JOB | |
| PH55427 | 2023-10-13 | UI94001 | UI94002 | COUNT() WITH GROUP BY MIGHT RETURN INCORRECT RESULTS WHEN THE COUNT RESULT IS HUGE. | ||
| PH55479 | 2023‑07‑17 | UI92754 | UI92755 | Y | SELECT GOT 00C90D01 ABEND AT DSNONLLE+035D4 AFTER REORG SHRLEVELCHANGE AND CONCURRENT INSERT COMPLETED. | |
| PH55497 | 2023-08-10 | PE PH61121 | N/A | UI93128 | Code to support future enhancement to automatic rebind | |
| PH55498 | 2023‑07‑25 | UI92906 | UI92907 | Y | ABEND0C4‑4 IN MODULE DSNTLTIM AT OFFSET 00728 IN DB2 V13 FL503 | |
| PH55631 | 2023-08-04 | UI93057 | UI93058 | Y | The SYSREC generated by REORG UNLOAD EXTERNAL misses the first one-byte data for the variable length NOT NULL column. | |
| PH55639 | 2023-07-27 | UI92918 | UI92919 | Y | RESOURCE UNAVAILABLE ERROR SQLCODE904 WITH REASON 00000000 DURING INDEX SPLIT AND 00C20023 PAGE LATCH NOT GRANTED | |
| PH55854 | 2023-09-08 | UI93498 | UI93499 | SQLCODE -20442 RECEIVED WHEN RUNNING A SELECT STATEMENT REFERENCING AN UNNEST FUNCTION | ||
| PH55886 | 2023-09-08 | UI93495 | UI93496 | Y | LOAD GENERATES INCORRECT TRAILING BLANKS FOR A UNICODE COLUMN IN EBCDIC TABLE. | |
| PH55977 | 2023-09-04 | UI93428 | UI93429 | ABND=04E-00E20018 AT DSNSLD4 .DSNSTKGG+00DB0 [XMLQUERY bug] | ||
| PH56025 | 2023‑09‑01 | UI93415 | UI93416 | SQLCODE420 MAY OCCUR FOR A QUERY THAT HAS A PREDICATE COMPARING A DECFLOAT OR A FLOAT COLUMN WITH A DECIMAL VALUE. | ||
| PH56059 | 2023-08-28 | UI93329 | UI93330 | Y | HIGH NUMBER OF SPACEMAP GETPAGE REQUEST CAUSED BY INSERT INTO PBG MEMBER CLUSTER APPEND NO OBJECTS | |
| PH56078 | 2023-08-17 | UI93229 | N/A | Y | WITH UI91174 APPLIED FOR DB2 12, DB2 MAY TERMINATE WITH DSNV086E REASON=00E50702 23/08/16 PTF PECHANGE | |
| PH56079 | 2023-09-13 | UI93544 | UI93545 | SELECT A VIEW WITH OPTHINT CREATED BY TEP2/3/SPUFI ISSUES ABEND 00E20027 AT DSNSVBK | ||
| PH56094 | 2023-08-15 | UI93211 | UI93211 | Y | IRLM: SERVICEABILITY APAR TO AID IN IDENTIFYING PLOCK MEMBER HOLDING LOCK | |
| PH56095 | 2023‑08‑17 | See PH56179 | UI93228 | N/A | Y | DB2 SERVICEABILITY APAR TO ASSIST IN DIAGNOSING BM PLOCK HANG |
| PH56118 | 2023-09-04 | N/A | UI93430 | Y | UTILITY JOBS ABNORMALLY TERMINATED WITH 00E20004. | |
| PH56150 | 2023-11-15 | UI94492 | UI94493 | ACCES PATH HAS PREFETCH=’O‘ IN PLAN TABLE | ||
| PH56179 | 2023-08-31 | N/A | UI93409 | Y | DB2 SERVICEABILITY APAR TO ASSIST IN DIAGNOSING BM PLOCK HANG | |
| PH56254 | 2023‑09‑11 | UI93527 | UI93528 | INEFFICIENT ACCESS PATH MAY BE CHOSEN AFTER APPLICATION OF PTF FOR APAR PH54507. 23/08/08 PTF PECHANGE | ||
| PH56284 | 2023-10-10 | UI93967 | UI93968 | Y | THREADS HUNG IN DSNB1LTS AND DSNB1LTX WAITING ON PAGE LATCH | |
| PH56318 | 2023‑09‑18 | UI93607 | UI93608 | MESSAGE MSGDSNI055I REPORTS INVALID URID OF DISABLING AGENT | ||
| PH56328 | 2023-09-29 | UI93835 | UI93836 | REDUCE QEH SAMPLING ON AP LOCKED SQLS AND ADD VERIFICATION CHECKON HOSTVAR MODEL VALUES | ||
| PH56333 | 2024-02-01 | UI95514 | UI95515 | Y | LOAD PARALLEL OVERLAYS BUFFER CAUSING ABEND0C4 IN DSNSVSVB AND ABEND04E RC00E2000E IN DSNSVSFB | |
| PH56347 | 2023-10-04 | UI93883 | UI93884 | Y | ABEND04E RC00C90101 DSNIPSI:5002 CAUSED BY STORAGE OVERLAY FOLLOWING LOAD PARALLEL SHRLEVEL NONE AND BACKOUT | |
| PH56366 | 2023-09-13 | UI93553 | UI93554 | Y | SERVICEABILITY IMPROVEMENTS FOR OVERLAY DETECTION. | |
| PH56389 | 2023-09-01 | N/A | UI93413 | Y | WITH UI91175 APPLIED FOR DB2 13, DB2 MAY TERMINATE WITH DSNV086E REASON=00E50702 | |
| PH56443 | 2024-04-18 | UI95741 | UI95742 | ABEND04E RC00C90101 DSNKINSL ERQUAL5033 OR DSNIOW ERQUAL5003 USING INSERT ALGORITHM 2 IAG2 | ||
| PH56559 | 2023-09-21 | UI93665 | UI93683 | ABEND0C4 RC10 IN DSNXOPRS +114E8 CAN OCCUR ON BIND/PREPARE OF A QUERY WITH MULTI-COLUMN FREQ STATS ON NONMATCHING INDEX | ||
| PH56646 | 2023-10-13 | N/A | UI94005 | ERROR MSG DSNX961I CAN OCCUR WHEN RUNNING SYSFUN.XSLTRANSFORM WITH IBM SEMERU JAVA 17 | ||
| PH56653 | 2023-12-06 | UI94744 | UI94745 | INCORRECT OUTPUT AFTER REORG REBALANCE DUE TO PLAN STABILIZATIONQUERY NOT BEING INVALIDATED | ||
| PH56737 | 2023-10-25 | UI94172 | UI94173 | ABEND0C4 RC10 IN DSNXOTS1+04DA4 CAN OCCUR FOR A QUERY CONTAININGGROUP BY OR SET FUNCTION DISTINCT AND R-SCAN IS CHOSEN FOR TABLE | ||
| PH56742 | 2023-11-10 | UI94432 | UI94433 | UNEXPECTED ACCESS PATH FOR AN UPDATE STATEMENT ON VOLATILE TABLEWITH AN UNIQUE INDEX WHICH CAN MATCH ALL PREDICATES | ||
| PH56796 | 2023-10-18 | UI94075 | UI94076 | Y | INCORROUT OCCURS QUERY INVOLVING CORRELATED PREDICATE REFERENCING SET FUNCTION WITH ACCESSTYPE ‚O‘ | |
| PH56871 | 2023-11-08 | UI94387 | UI94388 | ABEND04E RC00C90101 DSNIDM.DSNOCHLO:5006 MAY HAPPEN ON QUERY WITH ORDER BY AND XML COLUMN WITH XMLSERIALIZE TO LOB TYPE | ||
| PH56940 | 2023-10-25 | UI94170 | UI94171 | ABEND0C4 RC10 AT DSNXOD3 OFFSET04726 MAY OCCUR FOR THE QUERY USING SINGLE INDEX ACCESS | ||
| PH56945 | 2023-12-04 | PE PH61191 | UI94680 | UI94681 | ABEND0C4 RC0000003B RC3B IN DSNISFPI OFFSET010A2 REMOVING A PAGEFROM AN IAG2 PIPE THAT WAS DISABLED BY ANOTHER IAG2 THREAD | |
| 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. | |
| PH57015 | 2023-12-15 | UI94968 | UI94969 | AN ABEND0C4 MAY HAPPEN IN DSNXGRDS.DSNXRFHJ+0045A WHEN AN INVALID UNSUPPORTED ACCESS PLAN WAS CHOSEN. | ||
| PH57019 | 2023-10-26 | UI94186 | UI94187 | DB2ZAI SQL OPTIMIZATION SELF-HEALING FOR DYNAMIC SQL COULD BE MISSED IN DATA SHARING ENVIRONMENT WHEN DSC INVALIDATION OCCURS | ||
| PH57026 | 2023-12-04 | PE PH59153 | UI94693 | UI94694 | Y | AN INTENTIONAL ABEND0C4 MAY HAPPEN FOR DSNXIAX2 P213 FOR AN INDEX WITH A LONG SCALAR EXPRESSION WHEN PROCESSING AN ALTER |
| PH57059 | 2023-12-14 | UI94931 | UI94932 | Y | AN INVALID COLUMN LENGTH MAY BE CALCULATED FOR A VIEW WITH RECURSIVE COMMON TABLE EXPRESSION AND STORED IN CATALOG. | |
| PH57071 | 2023-10-19 | N/A | UI94095 | CHANGE READING FTB SYSIBM.SYSINDEXCONTROL TABLE FROM 10 MINUTES TO EVERY 2 MINUTES | ||
| PH57084 | 2023-03-29 | UI96319 | UI96320 | Y | CATMAINT DOESN’T SET ADVISORY REORG PENDING FOR OBJECTS ALTERED | |
| PH57175 | 2023-11-01 | UI94251 | UI94252 | ABEND0C4 RC00000010 IN DSNNORES OFFSET0A1A0 MAY OCCUR WHEN RUNNING AN SQL/PL STORED PROCEDURE | ||
| PH57254 | 2023-12-05 | See PH50239 | UI94710 | UI94711 | ACCESS PATH REGRESSION MAY HAPPEN FOR A QUERY WHICH GOT A BAD COST CALCULATED. | |
| 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 | |
| PH57423 | 2023-12-15 | UI94970 | UI94971 | INEFFICIENT AP FOR QUERY CONTAINS SARGABLE JOIN PREDICATE WITH COLUMN EXPRESSION AND JOIN PREDICATES COMPARING NUMERIC AND CHAR | ||
| PH57433 | 2023-11-10 | N/A | UI94434 | Y | SYSAIDB.SYSAICOLUMNCONFIG.MAX_DATA_VALUE_LEN MAY BE INACCURATE, ABEND0C4 DSNSVBK+013EA OR DSNXOAIF+03146 FOR SQLDI QUERY | |
| PH57473 | 2023-11-09 | See PH50149 | UI94409 | UI94410 | Y | BROKEN DATA PAGE CAUSED ABEND04E RC00C90101 AT DSNIBHRE ERQUAL0C33 WHEN RUNNING A COPY UTILITY. 23/10/13 PTF PECHANGE |
| PH57506 | 2023-12-11 | UI94852 | UI94853 | INCORROUT (TOO MANY ROWS RETURNED) AFTER ALTER TABLE ADD COLUMN OF DATA TYPE TIMESTAMP WITH DEFAULT | ||
| PH57537 | 2023-11-09 | UI94411 | UI94412 | FTB ACTIVATED BUT NO INDEX WAS LOADED IN MEMORY | ||
| PH57550 | 2023-11-02 | Retrofit PH54429 | UI94260 | N/A | ABEND04E RC00E2000F FOR DSNSVSFB OFFSET 009B8 WHICH CALLER IS DSNXOAF MAY ISSUE FOR BIND/REBIND USING PLANMGMT WITH APREUSE | |
| PH57561 | 2023-11-16 | UI94519 | UI94520 | ABEND0C4 RC00000004 IN DSNLILLM.DSNLCMRL+006CC | ||
| PH57580 | 2023-11-10 | UI94428 | UI94429 | ABEND0C4 RC00000010 IN DSNXROJ1 OFFSET05618 MAY OCCUR DURING JOIN PROCESSING USING SPARSE INDEX | ||
| PH57644 | 2024-07-29 | UI97833 | UI97834 | Y | DB2 ABNORMAL TERMINATION WITH RC00F70603 AFTER DSN7508I WAS ISSUED WITH RC08 AND RSN0C080887 | |
| PH57664 | 2023-11-16 | N/A | UI94517 | Y | POOR PERFORMING APPLICATION THAT HAS A COMMIT OR ROLLBACK SQL STMT AND PRECOMPILED BEFORE V8 DUE TO UNNEEDED CCSID CONVERSION | |
| PH57781 | 2023-12-19 | UI95002 | UI95003 | Y | INCREMENTAL COPY DETECTS BROKEN PAGE IN TABLESPACE BUT STILL INSERT AN ENTRY WITH ICTYPE=I TO SYSIBM.SYSCOPYS | |
| 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 | ||
| PH57971 | 2023-12-18 | UI94981 | UI94982 | ABEND04E RC00E70005 DSNXISTK OFFSET02004 OR ABEND04E RC00E7000A DSNXISUB OFFSET0CAA4 MAY OCCUR WHEN RUNNING DB2ZAI | ||
| PH58060 | 2024-03-28 | UI96316 | UI96317 | ABEND04E RC00E70005 DSNXEPM M450 FOR THE QUERY INVOLVING TRIGGER | ||
| PH58069 | 2023-12-15 | UI94954 | UI94955 | DB2 MAY CHOOSE AN INDEX WITH EQUAL MATCHING PREDICATES WHILE THE COLUMN IN THE PREDICATE HAS HIGH FREQUENCY. | ||
| PH58119 | 2023-12-07 | UI94795 | UI94796 | ABEND04E RC00E2000C DSNXOPPD DSNSVSVB OFFSET00A54 MAY OCCUR FOR COMPLEX QUERY WITH HUGE NUMBER OF OR CONDITIONS AND DIST CRASH | ||
| 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 | |
| PH58137 | 2023-12-20 | See PH61191 | N/A | UI95025 | DIAGNOSTIC APAR TO ADD MORE IAG2 INFORMATION IN THE DIAGNOSTIC LOG RECORDS WHEN DSNI055I IS ISSUED. 23/11/10 PTF PECHANGE | |
| 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 | 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 | N/A | OPEN | 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. | |
| 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 | OPEN | OPEN | 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 | 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 | 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. | ||
| 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 | UI99040 | UI99041 | Y | COPY UTILITY SETS TABLESPACE TO RECP WHILE A REORG IS CONVERTING IT TO PAGENUM RELATIVE IN THE MEANWHILE | |
| 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 | New & Closed | 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 | New & Closed | UI99549 | UI99550 | ABEND 4E-00E70005,LOC=DSNXGRDS.DSNXOEA :M888 may occur for an SQL statement that contains tables which may be rewritten by MQTs | |
| PH63890 | 2024-12-10 | N/A | UI99368 | Y | 00D94001 AFTER ABEND0C4 RC4 DSNIRLPG+03102 DURING LOAD UTILITY | |
| PH63936 | 2024-12-31 | New & Closed | N/A | UI99546 | Y | LOAD UTILITY ABENDS S04E RC00E40045 OR S0C4. |
| PH64207 | OPEN | OPEN | COST REDUCTION FOR PIPELINE ACCESS PLANS IN SPECIFIC QUERY CONDITIONS. | |||
| PH64280 | OPEN | OPEN | EXECUTION OF THE FREE SERVICE COMMAND WITHOUT APPROPRIATE PRIVILEGES MAY VOID THE CATALOG CONSISTENCY. | |||
| PH64577 | OPEN | OPEN | AN INEFFICIENT ACCESS PLAN MAY BE CHOSEN WHEN COMPARING COVERAGE OF INDEX MATCHING PREDICATES AND INDEX SCREENING PREDICATES. | |||
| PH64590 | OPEN | OPEN | AN INEFFICIENT ACCESS PLAN MAY BE CHOSEN WHEN JOINING TABLES. | |||
| PH64622 | New | OPEN | OPEN | AN INTENTIONAL ABEND04E RC00E70005 MAY HAPPEN FOR DSNXOSR:P018 FOR SELECT COUNT DISTINCT ON MASKED COLUMN. | ||
| PH64648 | New | N/A | OPEN | ABEND04E RC00E2000F AT DSNXSORI DSNSVSFB OFFSET009B8 ON SORT PROCESSING |
If you have any comments or wishes please feel free to contact me!
TTFN,
Roy Boxwell