A very quiet month to end the year!
HIPERs:
Db2 13: PH63890: 00D94001 AFTER ABEND0C4 RC4 DSNIRLPG+03102 DURING LOAD UTILITY
Interesting for RTS:
PH61976: CATMAINT TIMEOUT WITH SYSTEM THREAD 014.RTSTST00 ON DYNAMIC SQL PLAN STABILITY CATALOG TABLESPACES.
RUNSTATS:
None.
Query performance:
PH63720: AN ABEND04C MAY HAPPEN FOR DSNXGRDS.DSNXOCS+0A426 DURING ACCESS PLAN SELECTION.
IAG2:
None.
FIT/FTB:
None.
Now come the three tables containing all the APARs.
First are the Real-time Statistics APARs – If the RTS are incorrect then any Utility generation or Access path decision based upon them could also be incorrect.
Next are the RUNSTATS APARs – If RUNSTATS causes data problems this, obviously, can have a major impact upon performance after the following BIND, REBIND or dynamic SQL PREPARE.
Finally, come the SQL PERFORMANCE APARs – In here are all relevant performance APARs as well as HIPERs that do not fit into any other category. A HIPER warrants a check in all cases.
All three tables have the same headings:
APAR – The assigned APAR for the problem.
CLOSED – This is the date in YYYY-MM-DD format when the APAR was closed.
STATUS – This column is NEW, NEW & CLOSED, CLOSED or PE xxxxx. A PE means that this APAR went PE and the xxxxx is the corrective APAR.
Db2 12 – If the PTF is for Db2 12 then it is listed here else N/A or OPEN.
Db2 13 – If the PTF is for Db2 13 then it is listed here else N/A or OPEN.
HIPER – Contains Y if the APAR is a HIPER. Can also contain (Y) if it is OPEN but presumed to be a HIPER, else it is blank.
Description – This is the APAR description taken from the header text. Sometimes I add extra details if the description is misleading or incorrect.
Note: If the PTF column has OPEN it means that the PTF was still open when the last check was done; of course it could have been Closed since this post was updated. Every year all APARs that were closed over two years ago are deleted.
RTS APARs:
| APAR | CLOSED | STATUS | Db2 12 | Db2 13 | HIPER | Description |
| 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 | |
| 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 | Closed | 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 | New | N/A | OPEN | SYSTABLESPACESTATS.REORGUNCLUSTINS IS INCORRECTLY UPDATED FOR SEGMENTED TSS WITH MEMBER CLUSTER FOR SQL INSERT. |
RUNSTATS APARs:
| APAR | CLOSED | STATUS | Db2 12 | Db2 13 | HIPER | Description |
| 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 | PE PH54783 | 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 | 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 | OPEN | OPEN | FTB ACTIVATED BUT NO INDEX WAS LOADED IN MEMORY | |||
| PH57622 | 2024-02-19 | N/A | UI95740 | Y | REORG DISCARD WITH INLINE STATISTICS AND STATPGSAMP=SYSTEM DOES NOT UPDATE THE STATISTICS IN THE CATALOG TABLES CORRECTLY | |
| PH57853 | 2024-01-29 | UI95460 | UI95461 | ABEND0C7 IN DSNUSAH2 +0C838 DURING REORG WITH INLINE STATISTICS AND HISTOGRAM PROCESSING | ||
| PH58768 | 2024-02-02 | UI95522 | UI95523 | RUNSTATS 04E 00C90101 ABEND DSNINXPG ERQUAL2003 | ||
| PH59363 | 2024-05-09 | N/A | UI96830 | V13R1M500 REORG OF DIRECTORY TABLESPACES DSNDB01.SYSLGRNX & DSNDB01.SPT01 MATERIALIZE 64GB TO 256GB COLLECTS INLINE STATS | ||
| PH59995 | 2024-05-08 | UI96814 | UI96815 | KEYSEQ 0 IN MESSAGE DSNU1351I DOES NOT CONSISTENT WITH VALUE IN SYSIBM.SYSKEYTARGETS. | ||
| PH60632 | 2024-05-14 | See PH54155 | UI96899 | UI96900 | Y | RUNSTATS OR REORG WITH INLINE STATISTICS TERMINATE with ABEND0C4 IN DSNUSAF 24/04/02 PTF PECHANGE |
| PH61253 | 2024-08-02 | UI97897 | UI97898 | COLCARDF IN SYSIBM.SYSCOLUMNS IS ZERO AFTER RUNSTATS INDEX ALL ON A PARTITIONED TABLESPACE WITH PARTITIONED INDEX | ||
| PH63152 | 2024-11-12 | UI99012 | UI99013 | VALUE OF SYSCOLUMNS.COLCARDF IS INACCURATE AFTER RUNSTATS. |
SQL PERFORMANCE and general HIPERs:
| APAR | CLOSED | STATUS | Db2 12 | Db2 13 | HIPER | Description |
| PH11864 | OPEN | OPEN | SQL SELECT RETURNS INCORROUT AFTER TABLE WITH LOB COLUMNS IS UPDATED | |||
| PH26180 | OPEN | OPEN | CARTESIAN PRODUCT RESULTING FROM INCORRECT JOIN ORDER | |||
| PH31566 | 2022-01-12 | UI78898 | N/A | Y | USER RECEIVED AN UNEXPECTED ABEND04E RC00E70100 IN DSNXGRDS DSNXISB7 P110 ON AN INSERT STATEMENT | |
| PH31775 | 2022-01-05 | UI78823 | N/A | Y | A LINEAR INDEX WITH > 255 PIECES IS NOT RECOVERED BY RESTORE SYSTEM UTILITY | |
| PH39631 | 2022-01-28 | UI79120 | N/A | Y | ABND0C4 RC10 IN DSNVXUL0 +00324 AFTER CANCEL THREAD | |
| 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 | ||
| PH40667 | 2022-03-02 | PE PH46287 | UI79547 | N/A | ENHANCEMENT TO DB2 STACK STORAGE HANDLING | |
| 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. | |
| 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 | |
| PH41627 | 2022-02-21 | UI79152 | N/A | Y | DB2 SHOULD PROCESS DIFFERENT TIMESTAMP DIGITS WITH SAME LENGTH, BUT ACTUALLY NOT | |
| PH41793 | 2022-05-26 | UI80317 | N/A | Y | SQLCODE904 RC00C90084 TYPE100 FOR STATIC SQL STATMENT FROM A PACKAGE RUNNING WITH ISOLATION LEVEL RR | |
| PH41952 | 2022-01-07 | UI78851 | N/A | DB2 MAY CHOOSE DIRECT INDEX ACCESS OVER INDEX PLAN WITH SORT WITH LOWER COST | ||
| 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. | |
| 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 | |
| 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 | 2022-11-10 | UI83257 | UI83258 | 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. | |
| PH46155 | 2022-07-12 | UI81428 | N/A | Y | SOME UNICODE CHARACTERS ARE NOT CONVERTED PROPERLY FROM A BINARY REPRESENTATION USING USER-DEFINED FUNCTION BSON2JSON. | |
| 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 | 2022-09-17 | UI82394 | UI82395 | 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 | 2022-08-08 | UI81863 | UI81864 | 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 | ||
| PH47581 | 2022-08-18 | N/A | UI82002 | DB2 13 FOR Z/OS NEW FUNCTION [Allow index access for MERGE statement] | ||
| 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 | PE PH48157 | UI81820 | UI81821 | Y | INCREASED DB2 DIST ADDRESS SPACE CPU USAGE MAY BE OBSERVED AFTER PH40244 / UI80196 22/07/15 PTF |
| PH48013 | 2022-08-18 | UI81998 | UI81999 | 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. | ||
| PH48157 | 2022-12-23 | UI83859 | UI83860 | Y | READS FOR IFCID 411 OR IFCID 412 RETURNING INCORRECT DATA 23/06/21 PTF PECHANGE | |
| 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 | 2022-10-24 | UI82993 | UI82994 | 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 | 2022-09-29 | UI82640 | 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 | PE PH59411 | 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 | |
| PH50149 | 2022-12-13 | PE PH57473 | UI83724 | UI83725 | INSERT RECEIVED RC00C90101 DSNISGRT ERQUAL500A ERROR | |
| 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 | 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 | ||
| 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 | OPEN | OPEN | 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 | See PH54863 | OPEN | OPEN | ABEND04E RC00E2000C AT DSNXKBLM.DSNSVSVB OFFSET00A58 WITH PTF UI92616 APPLIED | ||
| PH59102 | 2024-03-22 | UI96208 | N/A | AFTER IMPLICIT AUTO REGENERATE, A FUNCTIONS ASSOCIATED SYSPACKAGE.CREATOR FIELD MAY BE BLANK. | ||
| PH59104 | 2024-04-09 | N/A | UI96424 | Y | IX LOCK ON SYS_PITR INCORRECTLY HELD BY PSEUDO CHECKPOINT PROCESSOR TASK. | |
| PH59153 | 2024-03-06 | UI95982 | UI95983 | A ++HOLD CORRECTION FOR APAR PH57026 PTFS UI94693 (FOR V12) AND UI94694 (FOR V13). 24/01/26 PTF PECHANGE | ||
| PH59192 | 2024-02-01 | UI95518 | UI95519 | Y | HIGH CSA CONSUMPTION BY DB2 | |
| PH59236 | 2024-05-08 | UI96819 | UI96820 | AN ABEND04E MAY HAPPEN FOR DSNXOMTX:M140 FOR A QUERY WITH A TABLE EXPRESSION HAVING GROUP BY AND HAVING CLAUSES. | ||
| PH59348 | 2024-03-08 | UI95948 | UI95949 | Y | LOOP IN CSECT DSN3ID30 WHILE AMGS LATCH IS HELD. | |
| PH59381 | 2024-03-07 | UI95985 | UI95986 | Y | QUIESCE UTILITY WITH WRITE(YES) DOES NOT WRITE ALL UPDATED PAGESFROM GBP 24/01/25 PTF PECHANGE | |
| PH59388 | 2024-04-03 | UI96375 | UI96376 | ABEND04E RC00C90101 IN DSNISRID 501E | ||
| PH59407 | 2024-02-28 | See PH53916 | UI95867 | UI95868 | Y | WITH UI92301 APPLIED, GET SQLCODE -204 DUE TO CURRENTSCHEMA NOT APPLIED. |
| PH59411 | 2024-03-18 | See PH49721 | UI96109 | UI96110 | A SQLCODE -104 MAY BE ISSUED WHEN CREATING A STORED PROCEDURE WITH A SIGNAL STATEMENT USING AN UDF. 24/02/06 PTF PECHANGE | |
| PH59413 | N/A | OPEN | AN UNNECESSARY SORT MAY BE PERFORMED FOR A QUERY USING AN UNION ALL CLAUSE. | |||
| PH59435 | 2024-04-08 | UI96404 | UI96405 | DB2 NATIVE REST MAY NOT CORRECTLY PROCESS JSON ESCAPED INPUT VALUES WHEN THERE ARE MORE THAN 49 INPUT PARAMETERS | ||
| PH59483 | 2024-03-05 | See PH61191 | UI95964 | UI95965 | IAG2 INSERT PROCESSING ABENDS0C4 00000004 PIC04 RC04 IN DSNISFPIOFFSET01598 | |
| PH59494 | 2024-02-20 | UI95760 | UI95761 | WORKFILE ABEND04E RC00C90101 DSNISFW ERQUAL500B OR RC00E72018 DSNXSTSE:P100 | ||
| PH59503 | 2024-03-01 | UI95904 | UI95905 | DB2 NATIVE REST PACKAGES CONTAINS STMTNO COLUMN VALUE 0 FOR ALL ROWS IN SYSIBM.SYSPACKSTMT | ||
| PH59541 | 2024-05-28 | UI97062 | UI97063 | ABND04E 00C90101 DSNOTCSO 5020 [Recursive CTE with LOB Column] | ||
| PH59548 | 2024-04-02 | PE OH61871 | UI96351 | UI96352 | ABEND04E RC00C90101 AT DSNIWNRF:502C WHEN PREDICATE CONTAINS MULTIPLE SUB-SELECT EMBEDDED INSIDE CASE EXPRESSION. | |
| PH59581 | 2024-03-13 | N/A | UI96074 | MAXSORT_IN_MEMORY NOT SET CORRECTLY | ||
| PH59591 | 2024-04-08 | UI96407 | UI96408 | Y | AN ABEND04E MAY HAPPEN FOR DSNXSZK:P035 FOR A QUERY USING PARALLELISM, INDEX ACCESS AND OUTER JOIN. | |
| PH59813 | 2024-04-03 | N/A | UI96374 | ABEND04E RC00E50007 IN DSNXRLPT AT LOCATION P220 MAY OCCUR | ||
| PH59920 | 2024-04-19 | UI96581 | UI96582 | AN ABEND0C4 MAY HAPPEN AT DSNXOCT+0155E FOR A STATEMENT USING UNION ALL OR UNION. | ||
| PH59939 | 2024-06-25 | UI97458 | UI97459 | AN UTILITY CALL CATMAINT UPDATE SCHEMA SWITCH MAY SWITCH THE SCHEMA FOR AN UDF RESULTING WITH CATALOG INCONSISTENCIES. | ||
| PH60051 | 2024-03-21 | UI96171 | UI96172 | ABEND0C4 RC38 AT DSNXRSGB OFFSET0127E FOR A QUERY WITH A SCALAR FULL/SUBSELECT WITH GROUP BY WITH AN IN PREDICATE | ||
| PH60155 | 2024-04-17 | UI96538 | UI96539 | AN ABEND0C4 MAY HAPPEN AT DSNXOQ2+03FA4 FOR A STATEMENT USING ROW_NUMBER ( ) OVER ( ORDER BY …) CLAUSE AND JOIN PREDICATE. | ||
| PH60161 | 2024-05-09 | UI96831 | UI96832 | AN ABEND0C4 MAY HAPPEN AT DSNXRCLS+0073C FOR A SIMPLE STATEMENT DURING CLEANUP AFTER IT WAS CANCELLED DURING SORT PROCESSING. | ||
| PH60255 | 2024-03-28 | N/A | UI96301 | Y | LISTAGG ISSUE | |
| PH60447 | 2024-05-21 | N/A | UI96993 | Y | ABEND05E RC28 CAN OCCUR FOR A SQL DATA INSIGHTS AI QUERY THAT CONTAINS AI BIFS, AND THE QUERY IS FROM DDF | |
| PH60564 | 2024-06-21 | UI97429 | UI97430 | Y | AN ABEND04E FOR DSNXGDT2:M100 MAY HAPPEN FOR A STATEMENT USING LISTAGG AGGREGATION FUNCTION IN EXISTS CLAUSE. | |
| PH60627 | OPEN | OPEN | INCORRECT OUTPUT RECEIVED AFTER LOAD INDEXDEFER ALL | |||
| PH60396 | 2024-04-19 | UI96584 | UI96585 | ABEND04E WITH RC00D31108 IN DSNLCCLO ABNDID0004 MAY OCCUR WHILE RUNNING SQL STATEMENT USING XML DATA | ||
| PH60725 | 2024-05-13 | UI96882 | UI96883 | ABEND0C4 RC38 IN DSNXOTS+18082 CAN OCCUR FOR A QUERY WHERE ONE OF THE TABLES HAS FULLY MATCHING EQUAL UNIQUE INLIST ACCESS | ||
| PH60741 | 2024-05-10 | UI96845 | UI96846 | Y | ABEND04E RC00D10312 LOC=DSNJL002.DSNJR103+009B0 | |
| PH60758 | 2024-05-10 | UI96851 | UI96852 | Y | AN INCORROUT MAY HAPPEN FOR A QUERY USING SPARSE INDEX ACCESS PATH. | |
| PH60776 | 2024-05-16 | UI96929 | UI96930 | PRESERVE THE INDEX PLAN FOR COST COMPETITION TO AVOID SORT PROCESSING OF AN OLAP FUNCTION | ||
| PH60836 | 2024-07-29 | UI97828 | UI97829 | Y | INCORROUT MAY HAPPEN FOR INSERT AND SELECT PROCESSING AFTER A MASS DELETE ON A DECLARED TEMPORARY TABLE WITH NOT LOGGED | |
| PH60879 | 2024-07-11 | UI97627 | UI97628 | Y | ABEND0C7 RC00000000 AT DSNXRRP OFFSET00E6E MAY OCCUR IN A QUERY CONTAINING A CEILING | |
| PH60885 | 2024-08-30 | UI98237 | UI98238 | A SQLCODE -670 MAY BE ISSUED DUE TO AN UNEXPECTED ACCESS PATH CHANGE. | ||
| PH60975 | 2024-05-16 | UI96950 | UI96951 | ABEND04E RC00E72048 IN DSNXSORI:P007 WHEN USING COLUMN MASK AS ARRAY_AGG SORT KEY, MORE THAN ONE EXPR IN THE ORDER BY CLAUSE | ||
| PH60984 | 2024-08-23 | N/A | UI98166 | INCORROUT FOR DISPLAY BLOCKERS(DBNAME) DETAIL IF THE MESSAGE LIMIT EXCEED | ||
| PH61053 | 2024-06-26 | UI97485 | UI97486 | DB2 MAY SELECT AN INEFFICIENT SPARSE INDEX PLAN WHILE AN EQUAL UNIQUE INDEX PLAN CAN BE USED | ||
| PH61100 | 2024-10-01 | N/A | UI98623 | ENHANCEMENTS FOR BIND LOCKING | ||
| PH61121 | 2024-05-23 | See PH55497 | N/A | UI97035 | STORAGE LEAK WHEN CALLING A STORED PROCEDURE OR USER DEFINED FUNCTION 24/04/29 PTF PECHANGE | |
| PH61171 | 2024-05-31 | UI97107 | UI97108 | ABENDS0C4 PIC04 RC04 MAY OCCUR WITH RECOVER UTILITY IN DSNIFLRD OFFSET03296 | ||
| PH61191 | 2024-05-29 | See PH56945, PH58137, PH59483 | UI97072 | UI97073 | INSERT ALGORITHM 2 (IAG2) WAS NEVER RE-ENABLED AFTER IAG2 WAS DISABLED WITH MSGDSNI055I 24/05/02 PTF PECHANGE | |
| PH61252 | 2024-06-04 | UI97166 | UI97167 | ABEND0C4 RC0000003B AT DSNXOSUD OFFSET003E4 MAY ISSUE WHEN REBIND QUERY WITH OPTHINT | ||
| PH61318 | 2024-08-14 | UI98024 | UI98025 | ABEND04E RC00C90101 IN DSNIZMOS AT ERQUAL5016 MAY OCCUR ON A WORKFILE TABLESPACE | ||
| PH61323 | 2024-07-25 | UI97794 | UI97795 | Y | ABEND04E RC00C200D8 IN DSNB1SWS | |
| PH61391 | See PH59388 | N/A | OPEN | 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 | New & Closed | N/A | UI99057 | UNPRINTABLE ERROR MESSAGE TOKEN IN SQLCODE -551 FOR ADVANCED TRIGGERS | |
| PH63060 | 2024-11-13 | UI99040 | UI99041 | Y | COPY UTILITY SETS TABLESPACE TO RECP WHILE A REORG IS CONVERTING IT TO PAGENUM RELATIVE IN THE MEANWHILE | |
| PH63830 | 2024-11-11 | UI99004 | UI99005 | A DB2ZAI CLEANUP SYSTEM THREAD IS NOT SHUTTING DOWN WITH A DB2 SHUTDOWN | ||
| PH63624 | 2024-11-20 | N/A | UI99139 | EXTERNAL SQL STORED PROCEDURE SOMETIMES FAILS WITH SQLCODE = -20442 USING GLOBAL ARRAY VARIABLE. (See PH58722) | ||
| PH63720 | 2024-12-09 | New & Closed | UI99347 | UI99348 | AN ABEND04C MAY HAPPEN FOR DSNXGRDS.DSNXOCS+0A426 DURING ACCESS PLAN SELECTION. | |
| PH63890 | 2024-12-10 | New & Closed | N/A | UI99368 | Y | 00D94001 AFTER ABEND0C4 RC4 DSNIRLPG+03102 DURING LOAD UTILITY |
| PH64207 | OPEN | OPEN | COST REDUCTION FOR PIPELINE ACCESS PLANS IN SPECIFIC QUERY CONDITIONS. | |||
| PH64280 | OPEN | OPEN | EXECUTION OF THE FREE SERVICE COMMAND WITHOUT APPROPRIATE PRIVILEGES MAY VOID THE CATALOG CONSISTENCY. | |||
| PH64577 | New | OPEN | OPEN | AN INEFFICIENT ACCESS PLAN MAY BE CHOSEN WHEN COMPARING COVERAGE OF INDEX MATCHING PREDICATES AND INDEX SCREENING PREDICATES. | ||
| PH64590 | New | OPEN | OPEN | AN INEFFICIENT ACCESS PLAN MAY BE CHOSEN WHEN JOINING TABLES. |
If you have any comments or wishes please feel free to contact me!
TTFN,
Roy Boxwell