A bit late this month but a bumpre crop of HIPERS for you all!
HIPERs:
PH63971 DB2 SUBSYSTEM HUNG DUE TO A DUPLICATE CONTROL BLOCK BEING ADDED TO THE CHAIN, WHICH RESULTED IN A LOOP IN PROCESSING. [Only in UDF recovery]
PH64030 LOAD REPLACE WITH PRESORT PUT THE DISCARD ROWS INTO THE TABLE
PH64166 INLINE LOB ABENDS0C4 00000004 RC04 PIC04 IN DSNOGETD OFFSET02A16 [Partitioning key column update via trigger where base table contains an inline LOB]
PH64414 ABEND0D6 RC00D94001 AND ABEND04F RC00000000 DUE TO A STORAGE OVERLAY BY DSNXOSJH WHICH LED TO A DB2 CRASH [Virtual index over load!]
PH64523 AN INTENTIONAL ABEND04E RC00E70005 MAY HAPPEN FOR DSNXEFDA:M500 FOR AN EXPLAIN STATEMENT.
PH64620 INCORRECT OUTPUT MAY HAPPEN WHEN QUERY CONTAINS A COLUMN XQUERY EXPRESSION CONSTANT OF AN XMLTABLE FUNCTION
PH64964: Long Running UR Created During Db2 restart Forward log recovery due to REDO Log Apply on down level Index Page
PH64966 ABEND 0C7 RC00000000 IN DSNXRBND AT OFFSET8E2 MAY OCCUR WITH A CASE STATEMENT CONTAINING NEXTVAL.
Interesting for RTS:
PH64496 SYSTABLESPACESTATS.REORGUNCLUSTINS IS INCORRECTLY UPDATED FOR SEGMENTED TSS WITH MEMBER CLUSTER FOR SQL INSERT.
RUNSTATS:
None.
Query performance:
PH64280 EXECUTION OF THE FREE SERVICE COMMAND WITHOUT APPROPRIATE PRIVILEGES MAY VOID THE CATALOG CONSISTENCY. [This should have been a HIPER in my personal opinion]
PH64702 ABEND DB2DIST RC00E70005 DSNXGRTS M248 [Use of OFFSET]
PH64900 AN ABEND0C4 MAY HAPPEN FOR DSNXSIFG+09468 FOR A SORT FOR A QUERY HAVING AN AGGREGATION AND A FFNR AND A GROUP BY CLAUSES.
IAG2:
PH64643 UPDATE PROCESSING ABEND04E 00C90101 DSNIREPR ERQUAL 5020.
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 | 2025-02-06 | Closed | N/A | UI99916 | 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. | ||
| PH65024 | New | N/A | OPEN | RUNSTATS WITH USE PROFILE GETS DSNU554I -DB2A DSNUSSRI – DUPLICATE INDEX NAMES EXIST IN THE SPECIFIED INDEX NAME LIST |
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. | |
| 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 | 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 | |
| PH63383 | 2025-02-19 | New & Closed | 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 | ||
| 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 | New & Closed | 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 | New & Closed | UI99861 | UI99862 | Y | LOAD REPLACE WITH PRESORT PUT THE DISCARD ROWS INTO THE TABLE |
| PH64166 | 2025-02-13 | New & Closed | UO02073 | UO02074 | Y | INLINE LOB ABENDS0C4 00000004 RC04 PIC04 IN DSNOGETD OFFSET02A16 |
| PH64207 | OPEN | OPEN | COST REDUCTION FOR PIPELINE ACCESS PLANS IN SPECIFIC QUERY CONDITIONS. | |||
| PH64280 | 2025-02-04 | Closed | UI99863 | UI99864 | EXECUTION OF THE FREE SERVICE COMMAND WITHOUT APPROPRIATE PRIVILEGES MAY VOID THE CATALOG CONSISTENCY. | |
| PH64414 | 2025-02-20 | New & Closed | 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 | New & Closed | N/A | UO02156 | Y | AN INTENTIONAL ABEND04E RC00E70005 MAY HAPPEN FOR DSNXEFDA:M500 FOR AN EXPLAIN STATEMENT. |
| 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. | |||
| PH64620 | 2025-01-31 | New & Closed | N/A | UI99841 | Y | INCORRECT OUTPUT MAY HAPPEN WHEN QUERY CONTAINS A COLUMN XQUERY EXPRESSION CONSTANT OF AN XMLTABLE FUNCTION |
| PH64622 | 2025-02-28 | Closed | UO02297 | UO02298 | AN INTENTIONAL ABEND04E RC00E70005 MAY HAPPEN FOR DSNXOSR:P018 FOR SELECT COUNT DISTINCT ON MASKED COLUMN. | |
| PH64643 | 2025-02-06 | New & Closed | UI99917 | UI99918 | UPDATE PROCESSING ABEND04E 00C90101 DSNIREPR ERQUAL 5020 | |
| PH64648 | 2025-02-06 | Closed | N/A | UI99915 | ABEND04E RC00E2000F AT DSNXSORI DSNSVSFB OFFSET009B8 ON SORT PROCESSING | |
| PH64702 | 2025-01-31 | New & Closed | UI99838 | UI99839 | ABEND DB2DIST RC00E70005 DSNXGRTS M248 | |
| PH64880 | New | OPEN | OPEN | DB2 REFERENCES AN INCORRECT OFFSET OF STORAGE | ||
| PH64900 | 2025-02-06 | New & Closed | 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 | New & Closed | 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 | New & Closed | 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 | New & Closed | UO02154 | UO02155 | Y | ABEND 0C7 RC00000000 IN DSNXRBND AT OFFSET8E2 MAY OCCUR WITH A CASE STATEMENT CONTAINING NEXTVAL. |
| PH65055 | New | N/A | OPEN | ABEND04E IN DSNIZMOS AT EQUAL5016 MAY OCCUR WITH A SET OPERATION AND A COMMON TABLE EXPRESSION WITH GROUP 25/02/11 PTF PECHANGE | ||
| PH65237 | New | N/A | OPEN | WITH UI99566 APPLIED, ABND=04E-00E20003,LOC=DSNLTEXC.DSNSVBK +02D7A CAN OCCUR | ||
| PH65250 | New | OPEN | OPEN | NEW FUNCTION FOR INDEX FAST TRAVERSE BLOCK (FTB) | ||
| PH65291 | New | N/A | OPEN | APREUSE FAILS WHEN ATTEMPTING TO REUSE A MULTI-INDEX ACCESS PATH | ||
| PH65369 | New | OPEN | OPEN | PH65369: AN INCORRECT OUTPUT MAY HAPPEN FOR A QUERY USING THE AGGREGATION FUNCTIONS AND A TABLE WITH DPSI INDEX. | ||
| PH65370 | New | N/A | OPEN | ABEND0C4 RC00000004 DSNXROHL OFFSET024E WITH SET CURRENT PACKAGE PATH AND TRIGGER WITH SELECT INTO | ||
| PH65442 | New | OPEN | OPEN | AN INTENTIONAL ABEND04E RC00E70005 MAY HAPPEN FOR DSNXOB2:M105 WHEN CSWL, UNION ALL AND IOE ARE USED. |
If you have any comments or wishes please feel free to contact me!
TTFN,
Roy Boxwell