This is another bumber HIPER month with a nice smattering of other fixes! All checked on the 1st June 2023.
HIPERs:
PH51766:EXCESS STORAGE CONSUMPTION BY THOUSANDS OF 022.WDFND THREADS (This is caused by Db2 AI)
PH52180: ABEND04E RC00E3007B DSNTGSCC DSNTABA (This is caused by an unlucky cancel of a thread using the BLOCKING_THREADS Built-in Table Function)
PH52653: PERFORMANCE DEGRADATION FOR FREE PACKAGE – INCREASED I/O ON THE DB2 CATALOG (SYSIBM.SYSPACKAUTH) 23/04/18 PTF PECHANGE
PH52821: THREADS HUNG IN DSNB1LTS AND DSNB1LTX WAITING ON A PAGE LATCH (datasharing problems)
PH53176: RC00C90206 DSNIIDIS ERQUAL5002 INDEX DATA INCONSISTENCIES ARE REPORTED DUE TO PAGE REGRESSION 23/03/12 PTF PECHANGE (Caused by PH50627)
PH53621: INCORROUT MAY HAPPEN WHEN QUERY USES HINT WHERE QBLOCK_TYPE OF CHILD QUERY BLOCK IS NOT VALID FOR PARENT QUERY BLOCK
PH53717: WORKFILE SORT ERROR MSGDSNT501I 0000006C 00000D02 DSNDB07 (ORDER BY and last column is VARCHAR > 100 bytes)
PH53747: ABEND04E RC00C90101 DSNGEDFR:50FF, ABEND04E RC00E3000A AT DSNTFRCV OFFSETF92 AND ABEND0C4 RC38 AT DSNTFRCV OFFSETF76 (This is actually an XML fix)
PH54823 (OPEN) due to PE of PH52717 HIPER=Y
Interesting for RTS:
None.
RUNSTATS:
None.
Query performance:
PH52915: ABEND0C4 RC04 AT DSNXRSOR OFFSET00136 FOR QUERY THAT INCLUDES OUTER JOIN AND INNER JOIN, SUBQUERY PREDICATE AND DISTINCT
PH53572: ABEND04E RC00C90101 IN DSNIWIPR ERQUAL5064 RUNNIG A VERY COMPLEX QUERY (This is actually a LISTAGG bug!)
IAG2:
PH50410: DIAGNOSTIC APAR TO PRODUCE A DUMP WHEN MSGDSNI055I IS ISSUED INDICATING IAG2 HAS BEEN DISABLED. This is a Db2 12 only APAR.
FIT/FTB:
PH54023: FTB NEW FUNCTION. This is a Db2 13 only APAR which increases the frequency of checking parameter INDEX_MEMORY_CONTROL and a small sorting bug if the FTB factor was negative.
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 |
| PH31124 | 2021-01-28 | UI73674 | N/A | REBUILD INDEX SHRLEVEL REFERENCE OF DIRECTORY INDEX DSNDB1XA OR DSNDB01X GETS DSNU590I WITH RC00C900AE BUT COMPLETES SUCCESSFULL | ||
| PH31498 | 2021-01-06 | UI73361 | N/A | NO RTS UPDATE DURING RUNSTATS TABLESPACE SHRLEVEL REFERENCE UPDATE ALL IN V12 FL505 AND ABOVE. | ||
| PH34807 | 2021-03-29 | UI74649 | N/A | EXTRA CPU COST OF MASS DELETE | ||
| PH35589 | 2021-05-04 | UI75212 | N/A | AFTER A PIT RECOVER , RTS REORGLASTTIME IS NULL AND DSNACCOX DOES NOT EXTRACT THE OBJECT FOR REORG | ||
| PH39503 | 2021-08-23 | UI76887 | N/A | ABEND04E RC0090101 IN DSNILKPD:1001 CAN OCCUR ON A QUERY IF STATS SAY TABLE IS EMPTY AND BUFFERPOOL SIZE IS ZERO | ||
| PH41480 | 2021-11-12 | UI78060 | N/A | Y | ABEND04E RC00C90D01 DSNONLLE ERQUAL53AC DURING DISASTER RECOVERYRECOVER OF DB2 CATALOG AND DIRECTORY | |
| PH45916 | 2022-06-29 | UI81253 | UI81254 | COPYUPDATEDPAGES IS INCORRECT AFTER LOAD WITH INLINE COPY, INCREMENTAL COPY GETS SKIPPED, RECOVER REQUIRES LOG APPLY | ||
| PH47090 | 2022-08-08 | UI81865 | UI81866 | SYSIBM.SYSINDEXSPACESTATS(STATSLASTTIME) DOES NOT GET UPDATED FROM LOAD REPLACE WITH INLINE STATISTICS SPECIFIED. | ||
| PH51108 | 2023-01-04 | UI83921 | UI83922 | Y | ACCESS DATABASE() SPACE() MODE(STATS) COMMAND DOES NOT UPDATE LASTDATACHANGE ON THE PARTITION WHICH IS CLOSED BY 010.PM2PCP01 | |
| PH54700 | New | OPEN | OPEN | REORG SHRLEVEL CHANGE OF DSNDB06.DBD01 LEAVES RESIDUAL RTS ROWS AND ORPHAN OBDS FOR THE MAPPING OBJECTS IN THE DBD |
RUNSTATS APARs:
| APAR | CLOSED | STATUS | Db2 12 | Db2 13 | HIPER | Description |
| PH32448 | 2021-01-07 | UI73367 | N/A | RUNSTATS UTILITY IS NOT COLLECTING THE SYSCOLDISTSTAT THAT IS BEING SPECIFIED (EG. FREQVAL COUNT 10 MOST) | ||
| PH33226 | 2021-02-26 | UI74173 | N/A | Y | DB2 BUFFER MANAGER OPEN PAGESET STORAGE LEAK | |
| PH34123 | 2021-03-01 | UI74210 | N/A | RUNSTATS DOES NOT COLLECT DISTRIBUTION STATISTICS FOR SINGLE COLUMN COLGROUP FOR SEGMENTED MULTI-TABLE TABLE SPACES | ||
| PH35267 | 2021-06-01 | UI75649 | N/A | RUNSTATS DOES NOT UPDATE COLUMN SYSCOLDIST.CARDF CORRECTLY WHEN NUMCOLUMNS > 1 | ||
| PH37545 | 2021-07-14 | UI76330 | N/A | RUNSTATS ABENDS0CF RC0000000F IN DSNUSEOF. | ||
| PH40189 | 2022-03-30 | UI79958 | N/A | Y | RUNSTATS AT PARTITION LEVEL GOT ABEND04E RC00E40213 WITH CAUSE 00C9004F | |
| PH43503 | 2022-03-31 | UI79966 | N/A | RUNSTATS TABLESPACE REGISTER NO FAILS WITH RC00C90637 OR ABEND04E WITH RC00C90101 AT DSNIOW ERQUAL 2002 | ||
| PH44246 | 2022-04-01 | UI79986 | N/A | Y | ABEND04E RC00E2000F DSNSVSFB+00A2A DURING A RUNSTATS TABLESPACE WITH EXCLUDE NULL KEYS INDEX | |
| PH45533 | 2022-05-20 | UI80643 | N/A | INCORRECT VALUE OF CARDF IN SYSIBM.SYSCOLDISTSTATS WHEN RUNSTATS COLLECTS KEYCARD STATISTICS ON DPSI INDEX | ||
| PH46351 | 2022-06-01 | N/A | UI80817 | INCORRECT VALUE OF CARDF IN SYSIBM.SYSCOLDIST WHEN RUNSTATS COLLECTS KEYCARD STATISTICS ON DPSI INDEX | ||
| PH46767 | 2022-08-31 | UI82201 | UI82202 | DROP INDEX LEAVES ORPHAN ROWS IN SYSIBM.SYSCOLDIST | ||
| PH47183 | 2022-07-19 | UI81531 | UI81532 | RUNSTATS USE PROFILE GOT TIMEOUT ON WAITING SYSCOLDISTSTATS TABLE X LOCK DURING LOCK ESCALATION. | ||
| PH48407 | 2022-09-02 | UI82237 | UI82238 | RUNSTATS AT PARTITION LEVEL GETS ABEND04E RC00E40213 WITH CAUSE 00C9004F | ||
| PH49119 | 2022-11-04 | UI83135 | UI83136 | COLCARDF IN SYSIBM.SYSCOLUMNS IS INCORRECT (RESET TO ZERO) AFTER A REORG AT PARTITION LEVEL USING INLINE STATISTICS | ||
| PH49410 | 2022-11-07 | UI83157 | UI83158 | ABEND04E RC00C90101 AT DSNIOW ERQUAL2002 DURING RUNSTATS SHRLEVEL CHANGE REGISTER NO | ||
| PH51750 | 2023-05-16 | New & Closed | N/A | UI91849 | UTILITY HISTORY IS NOT COLLECTED WHEN A UTILITY TARGET IS AN INDEX AND THE INDEX CREATOR IS OMITTED. | |
| PH51901 | 2023-02-22 | UI90670 | UI90671 | RUNSTATS INVALIDATECACHE FUNCTION CAUSES ACCESSPATH PROBLEMS | ||
| PH51905 | 2023-05-11 | Closed | UI91777 | UI91778 | PCTROWCOMP SET BY RUNSTATS MIGHT BE INACCURATE | |
| PH52439 | 2023-05-12 | Closed | UI91785 | UI91786 | TERM UTILITY COMMAND HANGS |
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 | |||
| PH21793 | 2021-01-05 | UI73335 | N/A | ABEND04E RC00E2000D AT DSNXESTR DSNSVSFB OFFSET00A18 | ||
| PH26180 | OPEN | OPEN | CARTESIAN PRODUCT RESULTING FROM INCORRECT JOIN ORDER | |||
| PH26498 | OPEN | OPEN | (Y) | ABEND04E RC00C90101 DSNISFPI ERQUAL5019 WHEN USING INSERT ALGORITHM 2 IAG2 | ||
| PH27840 | 2021-02-05 | UI73843 | N/A | INCORROUT FROM QUERY THAT REFERENCES A LARGE VARCHAR FOR BIT DATA COLUMN AS A JOIN PREDICATE FOR SORT MERGE JOIN | ||
| PH28731 | 2021-01-07 | UI73383 | N/A | ABEND04E RC00C90101 AT DSNIDM DSNISRID ERQUAL500A OCCURRED FOR A SECOND FETCH FROM A ROWSET CURSOR | ||
| PH28810 | 2021-01-28 | UI73671 | N/A | MSGDSNT286I INDICATES APREUSE WAS NOT SUCCESSFUL WHEN THE ACCESSPATH BEING REUSED CONTAINS CORRELATED SPARSE INDEX IN TBL EXPR | ||
| PH29918 | 2021-01-19 | UI73538 | N/A | ABEND0C7 AT DSNXRDEC OFFSET8960 MAY BE ISSUED FOR A QUERY THAT REF A VIEW OR AN SQL TABLE UDF THAT CONTAINS RECURSIVE CTE | ||
| PH30396 | 2021-01-06 | UI73347 | N/A | OPTIMAL ACCESS PATH MIGHT NOT BE USED FOR A JOIN QUERY WHICH CONTAINS BOTH LOCAL PREDICATE AND JOIN PREDICATE ON SAME COLUMN. | ||
| PH30978 | 2021-06-01 | UI75643 | N/A | SUBSYSTEM PARAMETER TO ENABLE INDEX IN-MEMORY OPTIMIZATION (FTB) FOR NON-UNIQUE INDEXES | ||
| PH31118 | 2021-01-06 | UI73357 | N/A | INEFFICIENT JOIN ORDER AND JOIN TYPE CAN BE SELECTED AFTER QUERYBLOCK MERGE | ||
| PH31146 | 2021-01-20 | UI73548 | N/A | ABEND0C4 RC0000003A RC04 PIC3A DSNSVSVB +00CB0 FOR THE QUERY WITH HUGE NUMBER OF UDFS | ||
| PH31490 | 2021-01-06 | UI73359 | N/A | ABEND0C4 DSNXRSOR +146 @ UI62958 | ||
| PH31566 | 2022-01-12 | UI78898 | N/A | Y | USER RECEIVED AN UNEXPECTED ABEND04E RC00E70100 IN DSNXGRDS DSNXISB7 P110 ON AN INSERT STATEMENT | |
| PH31621 | 2021-01-07 | UI73365 | N/A | POOR PERFORMING QUERY WHEN DB2 SELECTS INDEX + LIST PREFETCH AP FOR LEADING TABLE WHILE INDEX IS CLUSTERING AND CAN AVOID SORT | ||
| PH31680 | 2021-02-15 | UI73982 | N/A | POOR PERFORMANCE CAN OCCUR FOR A QUERY WITH TABLES HAVING DIFFERENT CCSID’S | ||
| PH31775 | 2022-01-05 | UI78823 | N/A | Y | A LINEAR INDEX WITH > 255 PIECES IS NOT RECOVERED BY RESTORE SYSTEM UTILITY | |
| PH31796 | 2021-01-08 | UI73397 | N/A | Y | A QUERY USING DEGREE=’ANY‘ MAY HAVE IDENTICAL ROWS RETURNED | |
| PH31872 | 2021-02-02 | UI73756 | N/A | AN INEFFICIENT ACCESS PATH IS CHOSEN AFTER A TABLE EXPRESSION ISMERGED | ||
| PH32097 | 2021-02-02 | UI73760 | N/A | THE QUERY USING OFFSET CLAUSE WITH UNION AND HOST-VARIABLE CAN RETURN EMPTY RESULT SET | ||
| PH32355 | 2021-02-12 | UI73972 | N/A | Y | INCORRECT RESULT WITH NO ROWS RETURNED FOR QUERY FROM TABLE FUNCTION USING LITERAL | |
| PH32376 | 2021-01-06 | UI73362 | N/A | Y | ADDITIONAL TAG SORT AND SORT POOL VERIFICATION. | |
| PH32468 | 2021-01-20 | UI73559 | N/A | INEFFICIENT ACCESS CAN BE CHOSEN FOR A QUERY CONTAINING A FF1R CLAUSE | ||
| PH32661 | 2021-01-07 | UI73394 | N/A | ABEND04E RC00E70005 AT DSNXEFDA OFFSET035FC FOR A QUERY THAT REQUIRES A VERY LARGE RID SORT. | ||
| PH32688 | 2021-03-03 | UI74227 | N/A | POOR PERFORMANCE CAN OCCUR FOR A QUERY WITH FF1R. | ||
| PH32690 | 2021-02-18 | UI74060 | N/A | Y | INCORROUT WHEN A SAME EXPRESSION ALIAS APPEARS IN THE SELECTION LIST MULTIPLE TIMES AND THIS QUERY RUNS ON PARALLELISM | |
| PH32726 | 2021-03-03 | UI74226 | N/A | POOR PERFORMANCE CAN BE SEEN WHEN A QUERY CONTAINS MULTIPLE PREDICATES. | ||
| PH32982 | 2021-01-20 | UI73560 | N/A | POOR PERFORMING SQL QUERY WHEN THE QUERY HAS MULTIPLE RANGE OR BETWEEN PREDICATES WHICH QUALIFIED MULTI-INDEX ACCESS | ||
| PH32985 | 2021-02-03 | UI73782 | N/A | ABND0C4 REASON00000004 AT DSNXGRDS DSNXOLIT OFFSET004DC MAY OCCUR FOR QUERY WITH STATEMENT CONCENTRATION ENABLED | ||
| PH33128 | 2021-02-10 | PE PH41952 | UI73918 | N/A | POOR PERFORMANCE CAN OCCUR FOR A QUERY CONTAINING A FFNR | |
| PH33196 | 2021-04-19 | UI74989 | N/A | PERFORMANCE ISSUE WHEN SPARSE INDEX WAS CHOSEN AND THERE EXISTS PREDICATES THAT ARE CAST TO VERY LONG LENGTHS | ||
| PH33285 | 2021-03-11 | UI74393 | N/A | INCORRECT ACCESS PATH WHEN A VALUE COMPARE OR A BETWEEN PREDICATE WITH ARITHMETIC EXPRESSION ON DECIMAL VARIABLES AND A | ||
| PH33339 | 2021-03-03 | UI74234 | N/A | LACK OF IFCID 376 REASON 3 (TIMESTAMP) IN DB2 V12 TRACE WHEN APPLCOMPAT = V10R1 AND BIF_COMPAT IS NOT CURRENT | ||
| PH33414 | 2021-03-29 | UI74634 | N/A | Y | RECOVER UTILITY DOES NOT CORRECTLY RECOVER THE COPY YES INDEXES CAUSING DATA/INDEX MISMATCH | |
| PH33443 | 2021-02-10 | UI73921 | N/A | ABEND04E RC00C900D0 AT DSNXROHB OFFSET23DC4 MAY OCCUR FOR NOT NULL LOB/XML COLUMN INVOLVING IN OUTER JOIN | ||
| PH33636 | 2021-03-08 | UI74325 | N/A | INCORRECT OUTPUT FOR AN SQL STATEMENT THAT REFERENCES A VIEW WITH MULTIPLE OUTER JOINS | ||
| PH34045 | 2021-03-15 | UI74443 | N/A | Y | INCORRECT SORT ORDER IN OUTPUT OF SELECT STATEMENT | |
| PH34046 | 2021-03-29 | UI74636 | N/A | INCORROUT FOR A QUERY WITH EXISTS PREDICATE IN CASE EXPRESSION AND OUTER JOINS | ||
| PH34056 | 2021-04-02 | UI74752 | N/A | ABEND04E RC00E70005 AT DSNXOW2D P333 MAY HAPPEN WHEN UPDATING A VIEW WITH AN ISNULL PREDICATE | ||
| PH34096 | 2021-02-16 | UI74002 | N/A | ABEND0C4 RC38 DSNXOGA OFFSETAE6C AE6C WHILE RUNNING COMPLEX QUERY | ||
| PH34178 | 2021-05-03 | UI75206 | N/A | SUB-OPTIMAL ACCESS PATH CAN BE CHOSEN FOR THE QUERY | ||
| PH34189 | 2021-04-07 | UI74812 | N/A | ABEND04E RC00C90101 AT DSNIDM DSNIWNRF ERQUAL5006 MIGHT HAPPEN WHEN A QUERY WITH LEFT OUTER JOIN AND SORT MERGE JOIN IS USED | ||
| PH34241 | 2021-04-12 | UI74891 | N/A | ABEND0C4 RC38 DSNXECST OFFSET09F6 09F6 WHILE RUNNING COMPLEX QUERY | ||
| PH34247 | 2021-03-12 | UI74421 | N/A | INEFFICIENT INDEX CHOSEN IN A RANGE-LIST ACCESS PATH. | ||
| PH34292 | 2021-06-23 | UI76040 | N/A | Y | ROLLBACK AFTER ALTER TABLE ALTER COLUMN SET WITH DEFAULT DOES NOT RESTORE PRIOR DEFAULT VALUE | |
| PH34425 | 2021-03-08 | UI74327 | N/A | INCORRECT OUTPUT OF CASE WHEN COMPARING VARCHAR COLUMNS | ||
| PH34465 | 2021-04-16 | UI74966 | N/A | Y | ABENDS0C4 IN DSNIASFP OFFSET001A8 DURING INSERT WORKLOAD USING INSERT ALGORITHM 2 – IAG2 | |
| PH34468 | 2021-04-20 | UI75007 | N/A | ABEND04E RC00C90101 AT DSNKTRAV ERQUAL5021 VIA FTB TRAVERSAL | ||
| PH34584 | 2021-03-30 | UI74673 | N/A | Y | ABEND04E AT DSNXOB2 M105 ON A REBIND PACKAGE 21/03/23 PTF PECHANGE | |
| PH34642 | 2021-05-17 | UI75437 | N/A | INCORROUT WRONG ROWS RETURNED FOR A QUERY WITH MULTIPLE JOINS WITH NOT EXISTS CORRELATED SUBQUERY | ||
| PH34689 | 2021-04-02 | UI74759 | N/A | Y | INCORRECT OUTPUT FROM SELECT WHEN NULL HOST VARIABLE WAS USED IN A PREDICATE AGAINST NOT NULL COLUMN | |
| PH34807 | 2021-03-29 | UI74649 | N/A | EXTRA CPU COST OF MASS DELETE | ||
| PH34859 | 2021-05-05 | UI75254 | N/A | DB2 12 FOR Z/OS NEW FUNCTION FOR FTB (FAST TRAVERSE BLOCKS) | ||
| PH34903 | 2021-03-17 | UI74490 | N/A | ABEND04E RC00E70005 DSNXOFL M120 OCCURS ON UNION ALL | ||
| PH34908 | 2021-04-13 | UI74918 | N/A | ABEND0C4 RC04 IN DSNXSRME OFFSET061A FOR SELECT USING TABLE EXPRESSION AND HYBRID JOIN | ||
| PH35080 | 2021-03-23 | UI74586 | N/A | SQLCODE16061 ISSUED FOR A QUERY USING XMLCAST | ||
| PH35088 | 2021-04-07 | UI74809 | N/A | Y | HIGH CPU DUE TO LONG PREPARES AND LOW HIT RATIO IN DYNAMIC STATEMENT CACHE WHEN DYNAMIC SQL PLAN STABILITY IS ENABLED | |
| PH35464 | 2021-04-20 | UI75013 | N/A | INEFFICIENT INDEX CHOSEN BETWEEN COMPETING INDEXES WHEN ONE CANDIDATE PROVIDES INDEX ONLY | ||
| PH35596 | 2021-04-07 | UI74814 | N/A | Y | INSERT SPLITTING PAGE INTO FTB LEAF NODE GOT DSNKFTIN:5002 ABEND BECAUSE OLD PAGE THAT CAUSE THE PAGE SPLIT WAT MISSING IN FTB. | |
| PH35872 | 2021-06-17 | UI75961 | N/A | Y | ABEND0C4 RC4 DSNURWBF+0B012 IN PARALLEL LOAD TO THE SAME PARTITION | |
| PH35959 | 2021-04-13 | UI74908 | N/A | Y | INCORROUT FOR QUERY WHERE LEADING TABLE IN ACCESS PATH IS ACCESSED WITH AN EQUAL UNIQUE INDEX AND NEXT TABLE HAS PREFETCH | |
| PH36093 | 2021-07-30 | UI76541 | N/A | INEFFICIENT JOIN TYPE CHOSEN WHEN THE SAME INDEX IS USED WITH LESS MATCHING COLUMNS | ||
| PH36147 | 2021-04-29 | UI75178 | N/A | ABEND04E RC00E20018 AT DSNSTKGG OFFSET00D76 ISSUED FOR A QUERY ON VIEW AND ITERATING ENTRIES OF DSNXOV1 IN FORMATTED DUMP TRACE | ||
| PH36179 | 2021-06-02 | UI75667 | N/A | DB2 12 FOR Z/OS ENHANCEMENT – APREUSE supports page range screening | ||
| PH36212 | 2021-10-28 | UI77851 | N/A | JOIN PREDICATE PUSHDOWN IS BEING ELIMINATED UNDER SOME CIRCUMSTANCES. | ||
| PH36222 | 2021-05-14 | UI75411 | N/A | Y | INCORRECT OUTPUT (TOO FEW ROWS RETURNED) POSSIBLE ON FULL OUTER JOIN RUNNING W/PARALLELISM, OUTER & INNER TABLES W/INDEX ACCESS | |
| PH36297 | 2021-06-23 | UI76046 | N/A | INEFFICIENT ACCESS PATH WHEN A POOR FILTERING INDEX LEG FOR RID LIST ACCESS IS CHOSEN FOR A JOIN 21/05/27 PTF PECHANGE | ||
| PH36300 | 2021-08-11 | UI76686 | N/A | UNNECESSARY MULTI-INDEX LEGS ARE GENERATED WHEN A QUERY CONTAINSA HIGH UNCERTAINTY PREDICATE | ||
| PH36356 | 2021-05-24 | UI75545 | N/A | Y | UNEXPECTED NULL RESULT IN QUERY RESULT. | |
| PH36406 | 2021-05-07 | UI75288 | N/A | INSERT KEY INTO FTB PROCESS DETECTING INCONSISTENT STRUCTURE MODIFICATION NUMBER THEN GOT DSNKFTIN:5043 ABEND | ||
| PH36430 | 2021-05-13 | UI75393 | N/A | Y | INCORROUT WHEN A TABLE EXPRESSION IS ACCESSED BY ‚O‘ ACCESS TYPE WHILE ITS BODY IS A SINGLE TABLE QUERYBLOCK AND INDEX IS USED | |
| PH36434 | 2021-05-13 | UI75392 | N/A | DB2 12 FOR Z/OS INTERNAL SERVICEABILITY UPDATE (Improve Create / Free FTB log recs) | ||
| PH36507 | 2021-08-18 | UI76828 | N/A | Y | INCORROUT ON QUERY WITH MULTIPLE LEFT JOINS, COALESCE AND SPARSE INDEX | |
| PH36531 | 2021-05-13 | UI75391 | N/A | Y | ABEND04E RC00C90101 AT DSNKINSN ERQUAL5009 AND DSNKFTIN ERQUAL5066 FOR FTB INSERT PLOCK FAILURE | |
| PH36540 | 2021-05-11 | UI75345 | N/A | AN INEFFICIENT ACCESS PATH USING LIST PREFETCH+SORT IS CHOSEN WHEN DIRECT INDEX ACCESS PROVIDES BETTER PERFORMANCE. | ||
| PH36737 | 2021-07-19 | UI76363 | N/A | RIDPOOL FAILURES FOR QUERY WITH MULTI-INDEX ANDING AND NO QUALI FYING RIDS FOR SECOND INDEX | ||
| PH36908 | 2021-08-03 | UI76579 | N/A | BACKING OUT THE BEHAVIOR FOR LOAD FORMAT DELIMITED FOR DECIMAL FIELDS WITHOUT A DECIMAL POINT THAT WAS IN 21/05/04 PTF PECHANGE | ||
| PH36978 | 2021-06-18 | UI75978 | N/A | FTB MESSAGE MSGDSNT351I ISSUED INCORRECTLY | ||
| PH37019 | 2021-08-03 | UI76581 | N/A | DB2 12 FOR Z/OS NEW FUNCTION FOR APREUSE | ||
| PH37116 | 2021-07-06 | UI76220 | N/A | ABEND0C4 RC38 IN DSNSVSFB OFFSET0758 WHILE EXECUTING DYNAMIC SQL AND DYNAMIC PLAN STABILITY IS ACTIVE | ||
| PH37119 | 2021-08-03 | UI77291 | N/A | INCONSISTENT ACCESS PATH FOR THE QUERY USING BETWEEN PREDICATE VERSUS RANGE PREDICATE | ||
| PH37151 | 2021-08-24 | UI76897 | N/A | IAG2 ABEND04E RC00C90101 DSNIBHRE ERQUAL5007 | ||
| PH37171 | 2021-06-15 | UI75893 | N/A | INCORROUT MAY OCCUR FOR A QUERY USING INLIST OR BETWEEN WHICH CONTAINS COLUMNS | ||
| PH37416 | 2021-11-02 | UI77911 | N/A | EXPLAIN PROVIDES INCORRECT ESTIMATE OF SU/TIME FOR QUERY. | ||
| PH37472 | 2021-06-25 | UI76090 | N/A | WORKFILE ABENDS0C4 PIC4 AT DSNIWNRF OFFSET0DE50 | ||
| PH37852 | 2021-07-22 | UI76410 | N/A | DSNTIAUL INCORRECT OUTPUT CAN HAPPEN FOR SELECT FROM UTF-16 VARGRAPHIC COLUMN | ||
| PH38003 | 2021-09-21 | UI77249 | N/A | SLOW QUERY PERFORMANCE FOR LEFT OUTER JOIN QUERY | ||
| PH38212 | 2021-07-07 | UI76239 | N/A | Y | ABEND04E RC00C90101 AT DSNKFTBU ERQUAL5061 AND DSNK1CNE ERQUAL5006 DURING FTB CREATION | |
| PH38261 | 2021-10-18 | UI77686 | N/A | Y | DSNIIDIS:5002 OCCURRED DUE TO A MISSING INDEX ENTRY CAUSED BY A FAILURE OF SERIALIZATION BETWEEN CREATE INIDEX AND INSERT. | |
| PH38274 | 2021-08-04 | UI76596 | N/A | ABEND04E RC00E2000C AT DSNXRSPL DSNSVSVB OFFSET00A54 WHEN INVOKING AN ADVANCED TRIGGER WITH HANDLER | ||
| PH38415 | 2021-10-25 | UI77810 | N/A | POOR INDEX MAY BE CHOSEN FOR QUERY WITH MULTIPLE PREDICATES ON THE SAME COLUMN | ||
| PH38551 | 2021-08-06 | UI76633 | N/A | ABEND04E RC00E2000F IN DSNSVSFB +00A2A WHILE RUNNING STORED PROCEDURES | ||
| PH38640 | 2021-08-09 | UI76642 | N/A | DB2 PARALLELISM TASK ABEND04E RC00C90101 IN WORKILE MODULE DSNIWNRF ERQUAL 5010 | ||
| PH38872 | 2021-09-02 | UI77010 | N/A | UPDATE THE LENGTH OF THE ASCE AND PRHW – Fix in error see PH40706 | ||
| PH39105 | 2021-10-18 | UI77687 | N/A | DB2 12 FTB INDEXTRAVERSECOUNT = 4294967295 FOR OBJECTS NOT ENABLED FOR FTB | ||
| PH39111 | 2021-09-15 | UI77157 | N/A | POOR PERFORMANCE OF AN UDPATE STATEMENT THAT CONTAINS A TABLE EXPRESSION ON THE NULL PADDING SIDE OF AN OUTER JOIN | ||
| PH39286 | 2021-08-23 | UI76886 | N/A | Y | ABEND0C4 RC003B AT DSNXODN OFFSET00600 AND ABEND04E RC00E2000D DSNLXDAL DSNSVSFB OFFSET00A18 LEAD TO DB2 ABTERM RC00E50702 | |
| PH39303 | 2021-10-18 | UI77691 | N/A | ABEND04E RC00E70005 AT DSNXOP1 M150 FOR A CREATE FUNCTION | ||
| PH39413 | 2021-09-02 | UI77014 | N/A | SQLCODE104 ISSUED WHEN REBIND ADVANCED TRIGGER WHICH CONTAINS A CALL STATEMENT WITH TABLE LOCATOR AS ITS PARAMETER | ||
| PH39584 | 2021-09-21 | UI77253 | N/A | INEFFICIENT ACCESS PATH CHOSEN WHEN A QUERY CONTAINS A FF1R CLAUSE AND AN INDEX ACCESS CAN BE MATCHING | ||
| PH39631 | 2022-01-28 | UI79120 | N/A | Y | ABND0C4 RC10 IN DSNVXUL0 +00324 AFTER CANCEL THREAD | |
| PH39677 | 2021-09-07 | UI77044 | N/A | AN ALL ZERO PAGE ERROR – ABEND DSNKTRAV:5021 | ||
| PH39751 | 2021-09-14 | UI77134 | N/A | THE INEFFICIENT JOIN SEQUENCE MAY BE CHOSEN, WHEN THE JOIN TABLE HAS A CORRELATED PREDICATE | ||
| PH39822 | 2021-09-27 | UI77334 | N/A | DB2 12 SERVICEABILITY FOR INFLUENCING ACCESS PATH SELECTION AND SUPPORTING INDEXABILITY FOR SQL STMTS USING IMPLICIT CAST | ||
| PH39875 | 2021-09-02 | UI77013 | N/A | ABEND04E RC00E70005 DSNXOACM P070 WHEN A COLUMN MASK IS DEFINED | ||
| PH40003 | 2021-09-27 | UI77336 | N/A | Y | CORRELATED SQL ISSUE, WHEN A TRANSITIVE CLOSURE PREDICATE IS GENERATED IN A SUB-QUERY INSIDE A CASE-WHEN CLAUSE. | |
| PH40216 | 2022-01-21 | UI79013 | N/A | BLOCK JOIN PREDICATE PUSHDOWN WHEN THE TARGET SUBQUERY ACCESS PATH IS TABLESPACE SCAN | ||
| PH40243 | 2022-04-19 | UI80210 | N/A | DCC NEW FUNCTION FOR DB2ZAI V1.5 | ||
| PH40269 | 2021-09-16 | UI77189 | N/A | Y | ABEND04E RC00E72068 AT DSNXSRME OFFSET01024 DUE TO A TIMING WINDOW WHEN USING INDEX FAST TRAVERSE BLOCK (FTB) | |
| PH40273 | 2021-11-09 | UI78000 | N/A | IMPROVE PERFORMANCE OF FTB STORAGE POOL ADMF INDEX MANAGER CL20 | ||
| PH40274 | 2021-11-01 | UI77882 | N/A | SQL0119N MIGHT BE ISSUED WHEN THE QUERY REFERENCES A VIEW AND THERE IS GROUP BY AND UNION ALL IN THE VIEW | ||
| PH40282 | 2021-09-21 | UI77258 | N/A | Y | ABEND04E RC00E2000C DUE TO STORAGE LEAK IN SUBPOOL ADMF AGL 64. | |
| PH40432 | 2021-09-21 | UI77254 | N/A | POOR PERFORMING QUERY WHEN AN INEFFICIENT JOIN ORDER IS CHOSEN FOR QUERY WITH FETCH FIRST N ROWS ONLY CLAUSE | ||
| PH40461 | 2021-11-02 | UI77909 | N/A | ABEND04E RC00E70005 DSNXOSTP M210 CAN OCCUR ON A CREATE TRIGGER WHICH CONTAINS MORE THAN ONE CALL STATEMENT | ||
| PH40527 | 2021-10-26 | UI77824 | N/A | Y | INCORRECT OUTPUT RETURNED BY A QUERY WHOSE ACCESS PATH IS BASED ON A DB2ZAI HOST VARIABLE MODEL | |
| PH40539 | 2021-10-07 | UI77500 | N/A | FTB DEADLOCK OCCURS WITH SYSTEM ITASK – CORRID=014.IFTOMK01 | ||
| PH40543 | 2021-10-01 | UI77407 | N/A | SLOW QUERY PERFORMANCE COULD OCCUR WHEN LIST PREFETCH IS CHOSEN | ||
| PH40667 | 2022-03-02 | PE PH46287 | UI79547 | N/A | ENHANCEMENT TO DB2 STACK STORAGE HANDLING | |
| PH40706 | 2021-11-10 | UI78014 | N/A | ABEND0C4-04 IN DSN3ID80 WITH PTF UI77010 APPLIED 21/09/17 PTF PECHANGE | ||
| PH40981 | 2021-12-14 | UI78548 | N/A | ABEND0C4 AT DSNXRSOR OFFSET00136 FOR QUERY WITH VIRTUAL TABLE ACCESS ON TABLE EXPRESSION WITH CASE EXPRESSION | ||
| PH41055 | 2021-12-27 | UI78742 | N/A | Y | STORAGE LEAK WHILE RUNNING DRIVER PACKAGES WITH INCORRECT CLIENTAPPLCOMPAT SETTING | |
| PH41205 | 2022-02-14 | UI79308 | N/A | ABEND04E RC00E72068 AT DSNXSRME OFFSET0106E CAN OCCUR WHEN A TABLE EXPRESSION OR A VIEW CONTAINS UNIONALL | ||
| PH41212 | 2022-01-12 | UI78897 | N/A | Y | INCORRECT OUTPUT MAY OCCUR FOR A QUERY USING XMLTABLE FUNCTION. | |
| PH41216 | 2021-11-17 | UI78137 | N/A | ABENDS0C4 RC04 PIC04 RC00000004 IN DSN3ID80 | ||
| PH41307 | 2021-11-17 | UI78136 | N/A | PERFORMANCE ISSUE WHEN THE JPP IS NOT ALLOWED FOR QUERY USING VIEW WITH UNION ALL INCLUDING A SMALL TABLE | ||
| PH41331 | 2021-12-08 | UI78449 | N/A | ABEND0C4 RC11 DSNXOSL OFFSET074C8 ON A CREATE TRIGGER STATEMENT | ||
| PH41335 | 2021-12-04 | UI78403 | N/A | ABEND04E 00C90101 AT DSNICMTC ERQUAL 5004 | ||
| PH41350 | 2021-11-29 | UI78295 | N/A | Y | INCORRECT OUTPUT MAY OCCUR WHEN IMPLICIT CAST IS PERFORMED FROM SMALL INT TO INT | |
| PH41436 | 2022-01-24 | UI78933 | N/A | Y | ABEND04E RC00E70005 AT DSNXRFN:M509 MIGHT HAPPEN FOR A QUERY WITH A CORRELATED SUBQUERY CONTAINING FETCH FIRST N ROWS ONLY | |
| PH41446 | 2021-12-22 | UI78714 | N/A | Y | POSTPONED ABORT ENTERED INTO AN INFINITE LOOP IN DSNB1CLM DUE TODB2 INTERNAL CONTROL BLOCK POINTING TO ITSELF | |
| PH41448 | 2021-11-02 | UI77914 | N/A | ABEND0C4 RC10 AT DSNXOCS OFFSET03770 WHEN RUNNING QUERIES WITH VIEWS OR TABLE EXPRESSIONS WITH JOIN RELATIONS | ||
| PH41535 | 2021-12-09 | UI78457 | N/A | Y | HIGH ECSA USAGE AFTER DB2 ABNORMAL TERMINATION | |
| PH41567 | 2021-11-23 | UI78244 | N/A | DB2ZAI: A LONG RUNNING DB2ZAI DAEMON THREAD CANNOT BE PROPERLY HANDLED EVEN AFTER -STOP ML COMMAND | ||
| PH41627 | 2022-02-21 | UI79152 | N/A | Y | DB2 SHOULD PROCESS DIFFERENT TIMESTAMP DIGITS WITH SAME LENGTH, BUT ACTUALLY NOT | |
| PH41670 | 2021-12-14 | UI78560 | N/A | ABEND04E RC00E70005 AT DSNXOSSF M909 WHEN A FNMEDIAN OR PERCENTILE_CONT/PERCENTILE_DISC IN A TABLE EXPRESSION IS NOT | ||
| PH41751 | 2021-12-01 | UI78344 | N/A | DB2 12 FOR Z/OS NEW FUNCTION | ||
| PH41793 | 2022-05-26 | UI80317 | N/A | Y | SQLCODE904 RC00C90084 TYPE100 FOR STATIC SQL STATMENT FROM A PACKAGE RUNNING WITH ISOLATION LEVEL RR | |
| PH41943 | 2021-11-22 | UI78223 | N/A | Y | INCORRECT OUTPUT MAY OCCUR FOR SUBSEQUENT QUERIES WITH A SINGLE UNION ALL AND DB2ZAI ENABLED | |
| PH41952 | 2022-01-07 | UI78851 | N/A | DB2 MAY CHOOSE DIRECT INDEX ACCESS OVER INDEX PLAN WITH SORT WITH LOWER COST | ||
| PH41978 | 2021-12-07 | UI78424 | N/A | DISTRIBUTED CONNECTION CONTROL (DCC) PROCESSING OF IFCID0402 FORDB2ZAI DESIGN CHANGE TO PRODUCE DELTA VALUES | ||
| PH42046 | 2022-01-27 | UI79100 | N/A | ABEND04E RC00C90101 AT DSNOTFLA ERQUAL5001 FOR QUERY WITH A COMBINATION OF XMLSERIALIZE AND ORDER BY | ||
| PH42081 | 2022-01-27 | UI79099 | N/A | Y | AN UNEXPECTED SQLCODE406 RESULTS FROM USING THE MULTIPLY_ALT BUILT-IN FUNCTION WHEN USING BIGINT ARGUMENTS. | |
| PH42198 | 2021-12-28 | UI78765 | N/A | SQLCODE -805 MIGHT ISSUE FOR A DROPPED TRIGGER IN SMALL TIME WINDOW | ||
| PH42469 | 2022-01-24 | UI79037 | N/A | Y | INCORROUT MAY HAPPEN WHEN THERE IS CORRELATED SUBQUERY WITH EXISTS OR NOT EXISTS WITH FFNR CLAUSE AND A HYBRID JOIN IS USED. | |
| PH42517 | 2022-03-23 | UI79856 | N/A | Y | INCORROUT MAY HAPPEN FOR QUERY USE HYBRID JOIN AND IOE INDEX | |
| PH42572 | 2021-12-28 | UI78763 | N/A | INEFFICIENT R-SCAN IS SELECTED FOR TABLES OF 3RD VIEW JOINED | ||
| PH42554 | 2022-01-04 | PE PH45702 | N/A | N/A | Y | DB2 V11 ABEND04E RC00E2000F ON DSNSVSFB OFFSET08C6 DURING DBET PROCESS. |
| PH42578 | 2022-02-14 | UI79305 | N/A | Y | LATCH CONTENTION AFTER DB2 RESTART AND LPL RECOVERY HAS COMPLETED | |
| PH42582 | 2022-02-01 | UI79151 | N/A | ABEND04E RC00E72068 AT DSNXSMUA OFFSET017F0 MAY HAPPEN TO SQL STATEMENT THAT CONTAINS ORDER BY ON THE RESULT OF UNION ALL | ||
| PH42975 | 2022-01-27 | UI79112 | N/A | SMF FIELD QISTFTBSIZE EXCEEDS ZPARM INDEX_MEMORY_CONTROL | ||
| PH42999 | 2022-03-09 | UI79656 | N/A | ABEND04E RC00E70005 IN DSNXOSJT M110 MAY OCCUR FOR A QUERY WITH MULTIPLE OUTER JOINS WHEN STAR JOIN IS ENABLE | ||
| PH43083 | 2022-03-10 | UI79673 | N/A | LOOP OCCURS IN DSNXOEXB DURING THE PREPARE OF A QUERY WHICH CONTAINS OUTER JOINS AND AN IN SUB-QUERY PREDICATE | ||
| PH43338 | 2022-02-14 | UI79313 | N/A | Y | INCONSISTENT DATA AND VARIOUS ABENDS IN DSNIRNXT FOR PBR RPN TABLESPACE AFTER RECOVER USING AN INLINE COPY CREATED BY REORG. | |
| PH43460 | 2022-07-11 | UI81408 | UI81409 | Y | ABEND04E RC000C90101 AT DSNGEPLC ERQUAL5064 MIGHT HAPPEN WHEN EXECUTING A PACKAGE IF REBIND IS OCCURRING AT THE SAME TIME | |
| PH43495 | 2022-03-10 | UI79683 | N/A | COMMIT LSN ENHANCEMENT IN V12 IS DISABLED. | ||
| PH43547 | 2022-02-17 | UI79400 | N/A | INEFFICIENT ACCESS PLAN CAN BE PICKED FOR QUERIES WITH FETCH FIRST N ROWS ONLY / OPTIMIZE FOR N ROWS CLAUSE | ||
| PH43562 | 2022-02-22 | UI79465 | N/A | Y | INCORROUT OR ABEND04E RC00C20305 MAY OCCUR FOR A PREDICATE COMPARING ROWIDS FROM DIFFERENT TABLES, DIRECT ROW ACCESS IS USE | |
| PH43565 | 2022-02-14 | UI79317 | N/A | Y | INCORROUT WITH FTB AND NON-UNIQUE INDEXES WITH GREATER THAN PREDICATE | |
| PH43569 | 2022-03-04 | UI79586 | N/A | ABEND04E RC00E70005 MIGHT HAPPEN AT DSNXOMB M020 FOR A QUERY WHEN HYBRID JOIN IS SELECTED | ||
| PH43663 | 2022-02-08 | UI79219 | N/A | Y | DB2 THREAD ABEND ABND=0C1-00000001 from ssidDIST asid | |
| PH43706 | 2022-05-27 | UI80740 | N/A | IAG2 ABEND04E 00C90105 IN DSNIASFP ERQUAL 0CA4 | ||
| PH43728 | 2022-02-22 | UI79437 | N/A | WORKFILE ABEND04E RC00C90101 DSNISFW ERQUAL500B | ||
| PH43735 | 2022-03-10 | UI79674 | N/A | AFTER ISSUING A DISPLAY STATISTICS COMMAND DISPLAY STATS(ITC) LIMIT(*), DB2 INVALIDLY ISSUES AN ABEND04E 00F9000C | ||
| PH43797 | 2022-02-22 | PE PH47264 | UI79458 | N/A | Y | ABEND04E 00F31100 – Plus Early APAR PH41216 |
| PH43798 | 2022-03-16 | UI79767 | N/A | ACCESS PATH IS NOT REUSED ON REBIND PACKAGE WITH APREUSE FOR TABLES WHERE EXPANSION_REASON <> ‚ ‚ IN THE PLAN TABLE | ||
| PH43806 | 2022-03-24 | UI79873 | N/A | Y | DB2 SUBSYSTEM ABNORMAL TERMINATION WITH RC00D94001 AFTER ABEND04E RC00E20028 DUE TO AN OVERLAY BY REORG REBALANCE | |
| PH43949 | 2022-03-24 | UI79862 | N/A | Y | DB2Z AI SQL OPTIMIZATION DASHBOARD DISPLAYS THE PACKAGE ERROR MESSAGE | |
| PH44062 | 2022-02-24 | UI79486 | N/A | ABEND04E RC00E70005 DSNXOV0:M101 MAY OCCUR FOR SQL THAT REFERENCES AN UDF THAT CONTAINS AN XMLSERIALIZE FUNCTION | ||
| PH44073 | 2022-03-08 | UI79643 | N/A | Y | DB2 CRASHES WITH ABEND04E RC00E50079 DSNURMPG +386 AND 04F RC00E50054 AFTER RESTART(CURRENT) OF LOAD UTILITY | |
| PH44109 | 2022-03-31 | UI79969 | N/A | Y | ALLEVIATE QUIESCING BEHAVIOR CHANGES DURING THE POPULATION OF NEW V12 SPACE LEVEL ATTRIBUTE FOR ALTER TABLESPACE PROCESSING | |
| PH44119 | 2022-06-07 | UI80920 | UI80921 | SYSIBM.SYSTABLEPART LIMITKEY COLUMN HAS AN INCORRECT VALUE AFTERREORG ON A SUBSYSTEM WITH DECIMAL=COMMA IN THE DSNHDECP | ||
| PH44137 | 2022-03-14 | UI79717 | N/A | SQLCODE904 WITH RC00D50001 AND RESOURCE 0000090A MIGHT OCCUR WHEN XMLCAST AND XMLQUERY OCCURS IN THE WHERE CLAUSE | ||
| PH44181 | 2022-04-01 | UI79984 | N/A | ABEND04E RC00C90101 IN DSNICUBC ERQUAL5004 | ||
| PH44211 | 2022-03-14 | UI79710 | N/A | Y | QUERY PREDICATE PUSHDOWN INTO CTE SUBQUERY UNION LEG, FOR SUBQUERY WITH FFNR, MAY CAUSE INCORRECT OUTPUT | |
| PH44231 | 2022-03-14 | UI79718 | N/A | ABEND0C4 RC38 AT DSNXOYP1 OFFSET09BF6 issued for CREATE OR REPLACE PROCEDURE | ||
| PH44260 | 2022-05-17 | UI80553 | N/A | ABEND0C4 RC04 AT DSNXOSEP OFFSET063C8 MAY OCCUR WHEN QUERY CONTAINS CTE OR TABLE EXPRESSIONS | ||
| PH44291 | 2022-07-20 | UI81583 | UI81584 | Y | ABENDS0C4 RC00000038 RC38 AT DSNIACCH+19B92 OR ABEND04E RC00C90101 AT DSNISRTI ERQUAL534C | |
| PH44356 | 2022-03-22 | UI79841 | N/A | Y | WORKFILE ABEND04E RC00C90101 IN DSNIWKFD ERQUAL5005 AND DB2 CRASH WITH MSGDSNV086E RC00F30801 | |
| PH44362 | 2022-06-13 | UI80989 | N/A | ABEND 04E RC00E70005 AT DSNXOBM P030 WHEN QUERY HAS A CORRELATED PREDICATE THAT COULD BE USED AS A SPARSE INDEX KEY | ||
| PH44421 | OPEN | OPEN | DB2 12 FOR Z/OS NEW FUNCTION TO SUPPORT DB2Z AI | |||
| PH44618 | 2022-04-11 | UI80090 | N/A | Y | ABEND04E RC00E70005 DSNXESX4 P403 CAN OCCUR FOR AN OUTER JOIN QUERY REFERENCING A LOB COLUMN WITH A SHORT INLINE LOB LENGTH | |
| PH44628 | 2022-04-11 | UI80089 | N/A | Y | PRECONDITIONING APAR FOR A FUNCTION IMPROVEMENT OF IN-MEMORY RLFTABLE AUTO REFRESH IN DATA SHARING GROUP | |
| PH44631 | 2022-06-06 | UI80891 | N/A | ABEND0C4 RC00 AT DSNXRDEC OFFSET087F8 WHEN MIGRATING AN EXTERNALSQL PROCEDURE TO A NATIVE SQL PROCEDURE | ||
| PH44701 | 2022-04-01 | UI79998 | N/A | ABEND04E RC00E70005 AT DSNXOGP ERQUALP666 MAY HAPPEN FOR THE QUERY WITH MORE THAN 1023 QUERY BLOCKS | ||
| PH44833 | 2022-12-08 | PE PH53318 | UI83589 | UI83590 | NEW FUNCTION FOR LIMITING THE NUMBER OF UDF RUNNING CONCURRENTLY | |
| PH44840 | 2022-06-21 | PE PH48139 | UI81105 | N/A | ABEND0C4-3B IN DSNWARDS OFFSET024F8 – See PH48139 | |
| PH44916 | 2022-07-27 | UI81675 | UI81676 | EDM STORAGE CAN GROW BEYOND VALUE OF EDMCSTMTC AND BEING NOT CONTRACTED | ||
| PH44928 | 2022-04-11 | UI80091 | N/A | Y | INCORRECT OUTPUT CAN OCCUR WHEN AN EXPRESSION-BASED INDEX IS USED | |
| PH44972 | 2022-06-02 | UI80862 | N/A | MESSAGE DSNP007I RC00D70002 ISSUED FOR WORKFILE EXTEND FAILURE ON 32K WORKFILES | ||
| PH44983 | 2022-04-20 | UI80092 | N/A | DB2Z AI SYSTEM ASSESSMENT PERIODICALLY INSERTS RECORDS INTO TABLES MORE FREQUENTLY THAN THE STATIME_MAIN SYSTEM PARAMETER | ||
| PH44999 | 2022-04-28 | UI80349 | N/A | Y | INCORRECT RESULT SET COULD BE RETURNED WHEN USING JSON SQL | |
| PH45085 | 2022-04-05 | UI80027 | N/A | SQLCODE=-725 MIGHT BE RETURNED WHEN OFFLOADING A QUERY WHICH REFERENCES A VIEW WITH CTE HINT | ||
| PH45100 | 2022-06-01 | UI80840 | N/A | Y | ABEND04E 00C90101 AT DSNICUMW ERQUAL 5003 | |
| PH45200 | 2022-06-02 | UI80859 | N/A | Y | DB2 ABEND04E 00E2000F IN DSNSVSFB OFFSET00A6A AND DB2 CRASH MSGDSNV086E REASON 00F30801 | |
| PH45262 | 2022-04-25 | UI80308 | N/A | Y | ABEND0C4 AND STORAGE OVERLAY AFTER WILD BRANCH IN DSN9SCN9 TO INVOKE THE FRR ROUTINE DURING DISPLAY DB COMMAND EXECUTION | |
| PH45272 | 2022-10-03 | UI82679 | UI82680 | USING QUERY ACCELERATION WITH PREPARE ATTRIBUTES CLAUSE ‚ CONCENTRATE STATEMENTS OFF ‚ MAY CAUSE PERFORMANCE IMPACT | ||
| PH45322 | 2022-11-03 | UI83120 | UI83130 | ABEND04E RC00E2000C AT DSNSVBK OFFSET00A54 MAY HAPPEN WHEN THREAD HANDLES A LARGE NUMBER OF ALTER STATEMENTS. | ||
| PH45358 | 2022-05-20 | N/A | UI80601 | Y | WHEN RUNNING SQL DATA INSIGHTS Z16 WITH ZAIU GET ABEND=U4039 | |
| PH45369 | 2022-06-15 | UI81024 | N/A | PERFORMANCE ISSUE WHEN SPARSE INDEX WAS CHOSEN BUT IT SPILLS INTO PHYSICAL WORKFILE | ||
| PH45483 | 2022-05-12 | UI80499 | N/A | ABEND04E 00E20018 AT DSNSLD4 DSNSTKGG OFFSET00F76 | ||
| PH45581 | 2022-05-06 | UI80442 | N/A | Y | ABEND04E RC009C0101 AT DSNKINSL ERQUAL5033 DURING INSERT | |
| PH45643 | 2022-05-11 | UI80483 | N/A | SQL STATEMENT POOR PERFORMANCE DUE TO INEFFICIENT JOIN ORDER FOR SUBQUERY IF THERE ARE TWO TABLES JOIN ON UNIQUE KEY. | ||
| PH45702 | 2022-05-03 | N/A | N/A | Y | DB2 V11 REAL STORAGE CREEPS AFTER APPLY APAR PH42554/PTF UI78803 22/04/14 PTF PECHANGE – PH45702 Db2 11 | |
| PH45748 | 2022-05-11 | UI80481 | N/A | Y | AN INCORRECT RESULT CAN BE RETURNED FROM A QUERY WITH UNION ALL THAT INCLUDES AN ORDER BY CLAUSE WITH OFFSET SPECIFIED. | |
| PH45790 | 2022-05-11 | UI80484 | N/A | DB2 MAY MATERIALIZE A SIDE WAY REFERENCED TABLE EXPRESSION/VIEW, WHILE JPP CAN PROVIDE BETTER PERFORMANCE. | ||
| PH46028 | 2022-05-28 | N/A | UI80758 | DB2Z AI SYSTEM ASSESSMENT PERIODICALLY INSERTS RECORDS INTO TABLES MORE FREQUENTLY THAN THE STATIME_MAIN SYSTEM PARAMETER | ||
| PH46058 | 2022-07-05 | UI81303 | N/A | Y | CROSS LOADER (LOAD WITH INCURSOR) GETS ABENDS0C1 ABENDS0C6 PECHANGE 22/05/19 PTF | |
| PH46099 | 2022-09-07 | UI82304 | UI82305 | Y | DB2 SYSTEM HUNG WITH A LATCH. | |
| PH46165 | 2022-06-16 | UI81044 | N/A | Y | ABEND04E RC00E70005 AT DSNXEPP M180 CAN OCCUR IN IN A V12/V13 COEXISTENCE ENVIRONMENT. | |
| PH46206 | 2022-06-09 | UI80959 | UI80960 | Y | AUTOMATIC GRECP RECOVERY 014.ASUTOGREC HANG UP AFTER ABEND0C4 PIC38 IN DSNIFLAA DUE TO ZERO PAGE SET CONTROL BLOCK POINTER | |
| PH46209 | 2022-06-06 | N/A | UI80890 | UNEXPECTED VALUE WHEN QUERY FROM THE PLAN TABLE | ||
| PH46212 | 2022-06-02 | N/A | UI80863 | ABEND04E RC00E70005 DSNXOV0:M101 MAY OCCUR FOR SQL THAT REFERENCES AN UDF THAT CONTAINS AN XMLSERIALIZE FUNCTION | ||
| PH46221 | 2022-07-19 | N/A | UI81536 | Y | IN A DATA SHARING GROUP, RLF WAS STARTED UNEXPECTEDLY BY OTHER MEMBER’S NOTIFICATION WITH SCOPE LOCAL | |
| PH46287 | 2022-06-01 | UI80832 | N/A | Y | ABENDS0D3 00000013 OR VARIOUS ABENDS AFTER APPLYING PH40667/UI79547 | |
| PH46295 | 2022-06-17 | N/A | UI81087 | Y | ABEND04E RC00E70005 DSNXESX4 P403 CAN OCCUR FOR AN OUTER JOIN QUERY REFERENCING A LOB COLUMN WITH A SHORT INLINE LOB LENGTH | |
| PH46312 | 2022-05-28 | N/A | UI80761 | SQL STATEMENT POOR PERFORMANCE DUE TO INEFFICIENT JOIN ORDER FOR SUBQUERY IF THERE ARE TWO TABLES JOIN ON UNIQUE KEY. | ||
| PH46313 | 2022-05-28 | N/A | UI80762 | DB2 MAY MATERIALIZE A SIDE WAY REFERENCED TABLE EXPRESSION/VIEW, WHILE JPP CAN PROVIDE BETTER PERFORMANCE. | ||
| PH46314 | 2022-06-03 | N/A | UI80871 | Y | AN INCORRECT RESULT CAN BE RETURNED FROM A QUERY WITH UNION ALL THAT INCLUDES AN ORDER BY CLAUSE WITH OFFSET SPECIFIED. | |
| PH46319 | 2022-06-29 | N/A | UI81245 | ABEND0C4 RC04 AT DSNXOSEP OFFSET063C8 MAY OCCUR WHEN QUERY CONTAINS CTE OR TABLE EXPRESSIONS | ||
| PH46323 | 2022-06-02 | N/A | UI80849 | Y | ABEND04E 00C90101 AT DSNICUMW ERQUAL 5003 | |
| PH46348 | 2022-06-03 | N/A | UI80880 | Y | ABEND0C4 AND STORAGE OVERLAY AFTER WILD BRANCH IN DSN9SCN9 TO INVOKE THE FRR ROUTINE DURING DISPLAY DB COMMAND EXECUTION | |
| PH46349 | 2022-06-01 | N/A | UI80818 | ABEND04E 00E20018 AT DSNSLD4 DSNSTKGG OFFSET00F76 | ||
| PH46368 | 2022-06-29 | UI81246 | UI81247 | Y | AN INCORRECT RESULT CAN BE RETURNED FROM THE TIMESTAMPADD BUILT-IN FUNCTION IF THE INPUT TIME EXPRESSION HAS HOUR 24. | |
| PH46376 | 2022-07-08 | UI81376 | UI81377 | ADDITIONAL GETPAGES WHEN A NON RESULT SET STORED PROCEDURE CALLSADDITIONAL PROGRAMS (PACKAGES) DURING EXECUTION. | ||
| PH46412 | 2022-07-12 | N/A | UI81433 | ABEND 04E RC00E70005 AT DSNXOBM P030 WHEN QUERY HAS A CORRELATED PREDICATE THAT COULD BE USED AS A SPARSE INDEX KEY | ||
| PH46441 | 2022-06-07 | N/A | UI80916 | POOR QUERY PERFORMANCE FOR QUERY REFERENCING SPECIAL REGISTER SUCH AS CURRENT TIMESTAMP, WHEN NOT REOPT(ALWAYS) OR REOPT(ONCE) | ||
| PH46446 | 2022-09-29 | UI82645 | N/A | PRE-CONDITIONING APAR FOR A NEW FUNCTION (PBR changes) | ||
| PH46487 | 2022-07-19 | N/A | UI81549 | ACCESS PATH IS NOT REUSED ON REBIND PACKAGE WITH APREUSE FOR TABLES WHERE EXPANSION_REASON <> ‚ ‚ IN THE PLAN TABLE | ||
| PH46564 | 2022-05-31 | UI80796 | N/A | DB2Z AI SYSTEM ASSESSMENT (SA) MISSING INFORMATION IN SOME TABLES THAT SUPPORT SA | ||
| 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 | ||
| PH46570 | 2022-07-22 | N/A | UI81635 | IAG2 ABEND04E 00C90105 IN DSNIASFP ERQUAL 0CA4 | ||
| PH46603 | 2022-05-31 | N/A | UI80807 | DB2Z AI SYSTEM ASSESSMENT (SA) MISSING INFORMATION IN SOME TABLES THAT SUPPORT SA | ||
| PH46604 | 2022-05-31 | N/A | UI80813 | ABEND0C4 RC38 AT DSNXOYP1 OFFSET09BF6 issued for CREATE OR REPLACE PROCEDURE | ||
| PH46618 | 2022-06-24 | N/A | UI81417 | PERFORMANCE ISSUE WHEN SPARSE INDEX WAS CHOSEN BUT IT SPILLS INTO PHYSICAL WORKFILE | ||
| PH46619 | 2022-06-21 | N/A | UI81106 | MESSAGE DSNP007I RC00D70002 ISSUED FOR WORKFILE EXTEND FAILURE ON 32K WORKFILES | ||
| PH46655 | OPEN | OPEN | (Y) | WLMHEALTH IS BEING IMPROPERLY SET TO 1 | ||
| PH46767 | 2022-08-31 | UI82201 | UI82202 | DROP INDEX LEAVES ORPHAN ROWS IN SYSIBM.SYSCOLDIST | ||
| PH46875 | 2022-06-29 | N/A | UI81255 | Y | CROSS LOADER (LOAD WITH INCURSOR) GETS ABENDS0C1 ABENDS0C6 | |
| PH47100 | 2022-07-18 | N/A | UI81528 | Y | DB2 ABEND04E 00E2000F IN DSNSVSFB OFFSET00A6A AND DB2 CRASH MSGDSNV086E REASON 00F30801 | |
| PH47141 | 2022-08-22 | UI82057 | UI82058 | PERFORMANCE ISSUE CAN OCCUR DUE TO LACK OF JOIN PREDICATE PUSH DOWN | ||
| PH47153 | 2022-07-12 | UI81425 | UI81426 | POOR QUERY PERFORMANCE MAY OCCUR FOR A QUERY THAT CONTAINS OR PREDICATE REFERENCING MULTIPLE TABLES. | ||
| PH47230 | 2022-07-07 | N/A | UI81355 | Y | SQLCODE904 RC00C90084 TYPE100 FOR STATIC SQL STATMENT FROM A PACKAGE RUNNING WITH ISOLATION LEVEL RR | |
| PH47249 | 2022-08-19 | UI82028 | UI82029 | (IAG2) ABEND04E RC00C90101 AT DSNIASFP ERQUAL5001 | ||
| PH47264 | 2022-07-29 | UI81719 | UI81720 | ABEND04E 00F31100 AFTER ASSOCIATE CALL 22/07/28 PTF PECHANGE | ||
| PH47312 | 2022-11-08 | UI83182 | UI83183 | ABEND04E RC00E70005 AT DSNXOSR P020 FOR COMPLEX QUERY | ||
| PH47354 | 2022-08-16 | UI81962 | UI81963 | THE FILTER FACTOR FOR THE IN SUBQUERY PREDICATE MIGHT BE ESTIMATED TOO HIGH SO THE INEFFICIENT INDEX MIGHT BE PICKED UP. | ||
| PH47374 | OPEN | OPEN | (Y) | ABEND04E RC00C90101 DSNOTFLA ERQUAL5021 FOR A QUERY THAT CONTAINS AN INLINE LOB AND THERE IS A WORK FILE INVOLVED | ||
| PH47397 | 2022-09-29 | UI82646 | UI82647 | INSERT ABEND04E RC00C90101 DSNISFPI ERQUAL5001 USING IAG2 | ||
| PH47644 | 2022-07-21 | UI81608 | UI81609 | ABEND04E RC00E70005 MIGHT HAPPEN AT DSNNQTOP M679 FOR QUERY USING XMLTABLE | ||
| PH47686 | 2022-12-14 | UI83753 | UI83754 | DB2 ABEND04E RC00E20018 IN DSNSLD4.DSNSTKGG OFFSET00B98 OFFSET00BC2 (EXPLAIN of extremely large SQL) | ||
| PH47706 | 2022-08-17 | UI81978 | UI81979 | ABEND04E RC00E70005 ABEND HAPPENS ON A REBIND WITH A MERGE STATEMENT WITH AN INCLUDE COLUMN | ||
| PH47795 | 2023-01-04 | UI83915 | UI83916 | Y | ABEND04E 00C90101 AT DSNK1CNE ERQUAL 5005 DURING NORMAL DB2 PROCESSING (FTB) | |
| PH47926 | 2022-08-05 | UI81840 | UI81841 | SQLCODE510 MAY BE ISSUED FOR AN AMBIGUOUS CURSOR WITH A COMMON TABLE EXPRESSION CTE | ||
| PH47952 | 2022-08-04 | UI81820 | UI81821 | Y | INCREASED DB2 DIST ADDRESS SPACE CPU USAGE MAY BE OBSERVED AFTER PH40244 / UI80196 22/07/15 PTF | |
| PH48013 | OPEN | OPEN | (Y) | EXCESSIVE DB2 STORAGE BEING ALLOCATED BY BUFFER MANAGER IN ADMF GLOBAL CL1 POOL. THIS IS FOUND IN CSA/ECSA CAUSES OUT_OF_CSA | ||
| PH48073 | 2022-08-24 | UI82094 | UI82095 | Y | WHEN UPDATE SET CLAUSE CONTAINS A SCQ WITH A MINUS SIGN, AN INCORROUT OR AN ABEND (ABEND0C4 AT DSNXGDT2 OFFSET00980) MAY | |
| PH48078 | 2022-08-29 | UI82129 | UI82130 | FTB SIZE EXCEEDS THE VALUE OF ZPARM INDEX_MEMORY_CONTROL | ||
| PH48085 | 2022-08-17 | UI81980 | UI81981 | ABEND04E RC00E70005 IN DSNXRITV M106 CAN OCCUR FOR A TRIGGER | ||
| PH48099 | 2022-11-09 | UI83218 | UI83219 | POOR QUERY PERFORMANCE MAY OCCUR FOR A QUERY THAT COULD TAKE ADVANTAGE OF REVERSE INDEX SCAN | ||
| PH48139 | 2022-08-22 | PE PH49206 | UI82068 | UI82069 | Y | DB2 ABEND0C4-3B IN DSNWARDS OFFSET 00C5C (Caused by PH44840 UI81105) |
| PH48149 | 2022-09-07 | UI82301 | UI82302 | DIS STATS(ITC) DOES NOT CALCULATE INDEX TRAVERSE COUNT WHEN FTB FUNCTION IS DISABLED. | ||
| PH48261 | 2022-10-19 | UI82887 | UI82888 | Y | INCORRECT OUT MAY OCCUR FOR A QUERY REFERENCING A VIEW OR CTE AND USING SET FUNCTION IN THE PREDICATE. | |
| PH48289 | 2022-12-27 | UI83868 | UI83869 | Y | DB2 CRASH WITH ABEND 00D10231 | |
| PH48384 | OPEN | OPEN | (Y) | ABEND04E RC00C90101 IN DSNGEDM.DSNGEDYI:0000 CAN OCCUR WHEN RUNNING SQL WITH DYNAMIC PLAN STABILITY ENABLED | ||
| PH48493 | 2022-10-19 | UI82898 | UI82899 | ABEND04E RC00E72018 AT DSNXSING P040 MIGHT HAPPEN FOR A QUERY SATISFYING SOME CONDITIONS | ||
| PH48602 | 2022-09-06 | N/A | UI82284 | Y | INCORRECT OUTPUT CAN OCCUR WHEN AN EXPRESSION-BASED INDEX IS USED | |
| PH48705 | 2022-12-12 | UI83696 | UI83697 | Y | TABLE SCAN COULD MISS SOME RECORDS FOR HASH OBJECT DEFINED WITH PAGE LEVEL LOCKING | |
| PH49206 | 2022-09-16 | UI82437 | N/A | DB2 ABEND0C4-00000004 IN DSNWARDS AT OFFSET 03846 | ||
| PH49317 | 2022-11-11 | N/A | UI83270 | Y | SPRC VERSION INCORRECT | |
| PH49442 | 2022-10-19 | UI82901 | UI82902 | Y | SLOW DB2 SHUTDOWN DUE TO CHECKPOINT FOR WORKFILE | |
| PH49479 | OPEN | N/A | (Y) | DSNT225I BIND ERROR FOR PACKAGE DEPLEVEL OPTION NOT SUPPORTED RECEIVED AT A V13R1M501 OR LOWER DB2 FOR Z/OS SERVER | ||
| PH49543 | 2022-10-27 | UI83046 | UI83047 | ABEND04E RC00E70005 DSNXOEXB M200 OR SQLCODE206 FOR UPDATE OF VIEW W/ INSTEAD OF TRIGGERS AND UPDATE STMT CONTAINS CORRSUBQ | ||
| PH49602 | 2022-12-06 | UI83591 | UI83592 | SPARSE INDEX MIGHT BE CHOSEN AND CAUSE PERFORMANCE REGRESSION BECAUSE OF COST ESTIMATED TOO HIGH WITH NO PENALTY. | ||
| PH49619 | 2022-11-18 | UI83368 | UI83369 | Y | SELECT REPLACE BIF HAVING MORE THAN 4K SEARCH STRING CAUSES DSNOLIKE ABEND0C4 PIC38 DUE TO AN OVERLAY. | |
| PH49674 | 2022-11-21 | UI83388 | UI83389 | Y | INCORRECT OUTPUT MAY OCCUR WHEN AN EXPRESSION-BASED INDEX IS USED WITH BETWEEN CLAUSE. | |
| PH49721 | 2022-10-21 | UI82954 | UI82955 | SQL PROCEDURE, HAVING SIGNAL STATEMENT WITH XML TYPE VARIABLE REFERENCED IN MESSAGE_TEXT, GOT ABEND0C4 PIC4 AT DSNOGETD+028CE | ||
| PH49759 | 2022-11-23 | UI83438 | UI83439 | ACCESS PATH REGRESSION | ||
| PH49792 | 2022-12-07 | UI83619 | UI83620 | THE ABEND RC00E70005 IN DSNXGSFN MAY HAPPEN WHEN A SQL STATEMENT CONTAINS OUTER JOINS AND A CCSID CAST ON A FOR BIT DATA COLUMN. | ||
| PH49825 | 2023-04-10 | UI91369 | UI91370 | ORPHANED ROWS IN SYSIBM.SYSPACKDEP AFTER DROP VIEW | ||
| PH49901 | 2022-12-14 | UI83755 | UI83756 | ABEND04E RC00E70005 IN DSNXRFMG M110 MAY OCCUR FOR SQL MERGE STATEMENT | ||
| PH49929 | 2022-12-21 | UI83841 | UI83842 | A LESS EFFICIENT INDEX MAY BE SELECTED WHILE ANOTHER INDEX CAN PROVIDE BETTER FILTERING. | ||
| PH49972 | 2022-11-18 | N/A | UI83371 | DB2 13 FOR Z/OS NEW FUNCTION (PARENT_PLANNO usage in PLAN_TABLE for VIEW or Table Expression) | ||
| PH50129 | 2023-01-05 | UI83939 | UI83940 | Y | ABND=04E-00D31010 DSNLILLM.DSNLCDG2:0001 OR DSNLCDG2:0005 | |
| PH50239 | 2022-12-23 | UI83861 | UI83862 | DISCOURAGE THE USE OF SPARSE INDEX WHEN INNER CTE OR VIEW SIZE IS BIG WITH THE HUGE ESTIMATED ROWS AMOUNT AND SMJ IS ELIGIBLE. | ||
| PH50367 | 2023-01-20 | UI90201 | UI90202 | DSNT286I FOR REBIND PACKAGE WITH APREUSE(WARN) EVEN THOUGH RESULTING ACCESS PATH IS THE SAME | ||
| PH50382 | 2022-11-30 | N/A | UI83522 | Y | ABEND 0C4 IN DSNVEUS1 AT OFFSET E34 | |
| PH50410 | 2023-05-15 | Closed | UI91799 | N/A | DIAGNOSTIC APAR TO PRODUCE A DUMP WHEN MSGDSNI055I IS ISSUED INDICATING IAG2 HAS BEEN DISABLED. | |
| PH50499 | 2022-12-01 | UI83543 | UI83544 | Y | ABEND 04E RC00C90101 DSNILKTO ERQUAL1002 (After restart from disk failure – Local fix Conditional Restart with FORWARD=NO) | |
| PH50583 | 2023-01-06 | UI83947 | UI83948 | DEGRADED PERFORMANCE FOR SOME QUERIES WITH A RANGE PREDICATE WITH BIFS: YEAR, DATE, OR SUBSTR ON THE LEFT HAND SIDE | ||
| PH50624 | 2023-01-23 | UI90224 | UI90225 | DSNIDLDU:5016 ABEND DURING LOAD RESUME IN DB2 12. | ||
| PH50627 | 2022-12-12 | PE PH53176 | UI83688 | UI83689 | Y | ABEND04E RC00C200D8 DSNB1SWS 22/11/02 PTF PECHANGE |
| PH50729 | 2023-01-09 | UI83963 | UI86964 | DB2 FOR Z/OS PROFILE (IFCID 402) STATISTICS ENHANCEMENT | ||
| PH50781 | 2023-02-13 | UI90503 | UI90504 | Y | DB2 RECOVERY-LOOP WITH REPETITIVE ABEND0C4 RC10 AT DSNXRIHB OFFSET2D490 AT LEVEL UI65759 | |
| PH50882 | 2022-12-21 | UI83844 | UI83845 | ABEND04E RC00E70005 AT DSNXOIXP P030 COULD HAPPEN WHEN AN SQL STATEMENT CONTAINS A VIEW AND HUGE NUMBER OF PREDICATES | ||
| PH50959 | 2023-02-16 | UI90575 | UI90576 | Y | SELECT ENTERED INTO A LOOP BETWEEN DSNKTRAV AND DSNKNXT2 IN FTB PROCESS (Non-unique support problem) | |
| PH50973 | 2022-12-28 | N/A | UI83889 | LOOP OCCURS IN DSNXOEXB DURING THE PREPARE OF A QUERY WHICH CONTAINS OUTER JOINS AND AN IN SUB-QUERY PREDICATE | ||
| PH50974 | 2022-12-27 | N/A | UI83883 | Y | ABEND0C4 DSNURLOG+049D0 REORG TABLESPACE SHRLEVEL CHANGE DURING PBG TO PBR CONVERSION | |
| PH50997 | 2022-12-28 | UI83884 | UI83885 | ABEND04E RC00E70005 AT DSNXGDT2 M205 FOR QUERY ON VIEW | ||
| 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 | ||
| PH51108 | 2023-01-04 | UI83921 | UI83922 | Y | ACCESS DATABASE() SPACE() MODE(STATS) COMMAND DOES NOT UPDATE LASTDATACHANGE ON THE PARTITION WHICH IS CLOSED BY 010.PM2PCP01 | |
| 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 | ||
| PH51565 | 2023-02-13 | PE PH52893 | N/A | UI90510 | FTB NEW FUNCTION | |
| PH51766 | 2023-03-29 | New & Closed | 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 | Closed | 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 | ||
| PH52590 | OPEN | N/A | IFCID0389 CONTAINS AN INCORRECT VALUE FOR QW0389LV (NUMBER OF INDEX LEVELS IN THE FAST TRAVERSAL BLOCK) | |||
| 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 | New & Closed | 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 | New & Closed | 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 | Closed | 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 | OPEN | N/A | ABEND04E RC00C90101 IN DSNK1CNE 5005 | |||
| PH53176 | 2023-05-16 | New & Closed | 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 | OPEN | N/A | AFTER SPLITTING OF LAST PBR PARTITION (ALTER+ADD PARTITION), QUERY USING PARTITIONED INDEX ACCESS MIGHT NOT RETURN ALL ROWS. | |||
| PH53525 | New | OPEN | OPEN | (Y) | ABEND0C4 RC00000038 IN DSNGESLC OFFSET0226A WHEN A PLAN WAS CANCELLED IN A DATA SHARING ENVIRONMENT | |
| PH53561 | 2023-05-01 | New & Closed | UI91627 | UI91628 | ABEND04E RC00E70005 AT DSNXEBR M666 COULD HAPPEN WHEN THERE ARE TWO CONDITIONS RAISED DURING THE OR PREDICATE (This is for XML) | |
| PH53572 | 2023-04-30 | New & Closed | UI91621 | UI91622 | ABEND04E RC00C90101 IN DSNIWIPR ERQUAL5064 RUNNIG A VERY COMPLEX QUERY | |
| PH53621 | 2023-05-25 | Closed | 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 | Closed | N/A | UI91614 | Y | WORKFILE SORT ERROR MSGDSNT501I 0000006C 00000D02 DSNDB07 |
| PH53747 | 2023-05-01 | Closed | UI91629 | UI91630 | Y | ABEND04E RC00C90101 DSNGEDFR:50FF, ABEND04E RC00E3000A AT DSNTFRCV OFFSETF92 AND ABEND0C4 RC38 AT DSNTFRCV OFFSETF76 |
| PH53779 | OPEN | N/A | REBIND WITH OPTHINT CAN BE SUCCESSFUL EVEN THOUGH MULTI-INDEX PLAN IS NOT THE SAME | |||
| PH53809 | 2023-05-16 | Closed | UI91846 | UI91847 | ABEND0C7 RC00 IN DSNXRDEC OFFSET08A4C MAY OCCUR WHILE RUNNING SQL SELECT WITH PARALLELISM | |
| PH54023 | 2023-05-17 | New & Closed | N/A | UI91868 | FTB NEW FUNCTION | |
| PH54370 | New | OPEN | OPEN | ABEND04E RC00E70005 AT DSNXRFF M105 FOR AN ADVANCED TRIGGER WHEN SPECIAL REG CURRENT PACKAGE PATH IS SET ON TRIGGERING SQL | ||
| PH54410 | New | OPEN | OPEN | PREPARE THE SIMPLIFICATION OF DB2ZAI(DB2 AI FOR Z/OS) | ||
| PH54439 | New | OPEN | OPEN | ABEND04E RC00E70005 AT DSNXOBM P110 CAN HAPPEN WHEN QUERY CONTAINS AN OUTER JOIN AND A BETWEEN PREDICATE ON THE OUTER JOIN | ||
| PH54507 | New | OPEN | OPEN | SERIOUS PERFORMANCE DEGRADATION WHEN RUNNING DB2 QUERIES | ||
| PH54511 | New | OPEN | OPEN | FOR TABLE WITH MANY INDEXES, INDEX PRUNING MAY GET RID OF GOOD INDEX AND DEGRADE PERFORMANCE. | ||
| PH54566 | New | OPEN | OPEN | (Y) | ABEND0C4 RC04 IN DSN3ID50 OFFSET0568 23/05/18 PTF PECHANGE | |
| PH54670 | New | OPEN | OPEN | HYBRID JOIN MAY CAUSE INCORRECT OUTPUT OF LOB COLUMN | ||
| PH54701 | New | OPEN | OPEN | DB2XML.HTTPGETCLOB MAY RETURN SQLCODE -4302 | ||
| PH54823 | New | OPEN | OPEN | ABEND04E RC00E70005 AT DSNXOV1 M600 WITH UI91352 (V12) OR UI91353 (V13) APPLIED |
If you have any comments or wishes please feel free to contact me!
TTFN,
Roy Boxwell