APAR Update

This month we have a nice spread of fixes! All checked on the 6th of September 2022.

HIPERS:

PH48073 UI82094 UI82095 WHEN UPDATE SET CLAUSE CONTAINS A SCQ WITH A MINUS SIGN, AN INCORROUT OR AN ABEND (ABEND0C4 AT DSNXGDT2 OFFSET00980) MAY


Interesting for RTS and Statistics:

PH45916 UI81253 UI81254 COPYUPDATEDPAGES IS INCORRECT AFTER LOAD WITH INLINE COPY, INCREMENTAL COPY GETS SKIPPED, RECOVER REQUIRES LOG APPLY

PH46767 UI82201 UI82202 DROP INDEX LEAVES ORPHAN ROWS IN SYSIBM.SYSCOLDIST

PH47090 UI81865 UI81866 SYSIBM.SYSINDEXSPACESTATS(STATSLASTTIME) DOES NOT GET UPDATED FROM LOAD REPLACE WITH INLINE STATISTICS SPECIFIED.


For Query performance:

PH47354 UI81962 UI81963 THE FILTER FACTOR FOR THE IN SUBQUERY PREDICATE MIGHT BE ESTIMATED TOO HIGH SO THE INEFFICIENT INDEX MIGHT BE PICKED UP.


For IAG2 users:

PH46570 Just Db2 13 UI81635 IAG2 ABEND04E 00C90105 IN DSNIASFP ERQUAL 0CA4
PH47249 UI82028 UI82029(IAG2) ABEND04E RC00C90101 AT DSNIASFP ERQUAL5001


For FTB users:

PH48078 UI82129 UI82130 FTB SIZE EXCEEDS THE VALUE OF ZPARM INDEX_MEMORY_CONTROL


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, MODIFIED or PE xxxxx. A PE means that this APAR went PE and the xxxxx is the corrective APAR. Modified does not mean the PTF has really been changed. It is just that IBM, for some reason or other, has updated the modified date. Sometimes this is to signify a new PTF or that a PTF has gone PE or even HIPER. In the next release of this page I will remove modified unless I see a real change as there are 100’s of them for no reason!

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:

APARCLOSEDSTATUSDb2 12Db2 13HIPERDescription
PH063562020-03-04 UI68224N/A REORG OF A PARTITION IS SETTING SOME STATISTICS INCORRECTLY IN RTS ( REORGINSERTS AND REORGAPPENDINSERTS )
PH161462020-10-05 UI71920N/A REORG UTILITY ISSUING DSNU3343I MSG FOR UPDATESIZE
PH207582020-10-20 UI72171N/A REBUILD INDEX SHRLEVEL CHANGE OF DIRECTORY INDEX DSNDB1XA GETS DSNU590I WITH RC00C900AE BUT COMPLETES SUCCESSFULLY
PH228382020-06-17 UI70107N/A GETPAGES COLUMN OF SYSINDEXSPACESTATS AND SYSTABLESPACESTATS CAN MAX OUT AND NOT GET INCREMENTED WITH SUBSEQUENT GETPAGE REQUESTS
PH265712020-09-02 UI71381N/A RTS GETPAGES VALUE WRONG IN SYSINDEXSPACESTATS FOR DEFER YES INDEXES
PH271522020-09-14 UI71536N/A DB2 ABEND04E DSNITCUS ERQUAL5002 DURING ONLINE REORG OF DSNDB06.SYSTSCOL
PH277312020-12-23 UI73288N/A INCORRECT NPAGES VALUE IN SYSIBM.SYSTABLESPACESTATS AFTER MASS DELETE AND LOAD RESUME, THEN RUNSTATS GETS RC00E40214 DSNUSUPT
PH311242021-01-28 UI73674N/A REBUILD INDEX SHRLEVEL REFERENCE OF DIRECTORY INDEX DSNDB1XA OR DSNDB01X GETS DSNU590I WITH RC00C900AE BUT COMPLETES SUCCESSFULL
PH314982021-01-06 UI73361N/A NO RTS UPDATE DURING RUNSTATS TABLESPACE SHRLEVEL REFERENCE UPDATE ALL IN V12 FL505 AND ABOVE.
PH322242020-12-30 UI73321N/A LOAD REPLACE AND REBUILD INDEX DO NOT RESET SYSIBM.SYSTABLESPACESTATS.GETPAGES
PH348072021-03-29 UI74649N/A EXTRA CPU COST OF MASS DELETE
PH355892021-05-04 UI75212N/A AFTER A PIT RECOVER , RTS REORGLASTTIME IS NULL AND DSNACCOX DOES NOT EXTRACT THE OBJECT FOR REORG
PH395032021-08-23 UI76887N/A ABEND04E RC0090101 IN DSNILKPD:1001 CAN OCCUR ON A QUERY IF STATS SAY TABLE IS EMPTY AND BUFFERPOOL SIZE IS ZERO
PH414802021-11-12 UI78060N/AYABEND04E RC00C90D01 DSNONLLE ERQUAL53AC DURING DISASTER RECOVERYRECOVER OF DB2 CATALOG AND DIRECTORY
PH459162022-06-29New & ClosedUI81253UI81254 COPYUPDATEDPAGES IS INCORRECT AFTER LOAD WITH INLINE COPY, INCREMENTAL COPY GETS SKIPPED, RECOVER REQUIRES LOG APPLY
PH470902022-08-08New & Closed UI81865UI81866 SYSIBM.SYSINDEXSPACESTATS(STATSLASTTIME) DOES NOT GET UPDATED FROM LOAD REPLACE WITH INLINE STATISTICS SPECIFIED.

RUNSTATS APARs:

APARCLOSEDSTATUSDb2 12Db2 13HIPERDescription
PH163452020-04-01 UI68772N/A     CODE TO SUPPORT FUTURE NEW FUNCTION WITH RUNSTATS UTILITY
PH194312020-02-13 UI67909N/A     RUNSTATS ABEND04E RC00E4001A – DSNUSSIN+0434 WHEN STPRIN01 DD STATEMENT IS NOT ALLOCATED
PH207452020-08-12 UI71041N/A     DB2 UTILITY LOOPS WHILE ALLOCATING SORT WORK DATASETS.
PH215962020-04-01 UI68767N/A     RUNSTATS TABLESPACE TABLE(ALL) INDEX(ALL) REPORT YES UPDATES SYSINDEXES.FULLKEYCARDF WITHOUT A MESSAGE.
PH228962020-05-03 UI69321N/A     RUNSTATS USE PROFILE ENDING WITH RC08 AND MSGDSNU611I DUE TO BAD SYNTAX IN PROFILE_TEXT OF SYSIBM.SYSTABLES_PROFILES
PH229332020-07-06 UI70419N/A     ACCESS PATH DEGRADED AFTER INDEX CHANGED TO EXCLUDE NULL KEYS
PH252772020-09-21 UI71670N/A     RUNSTATS CONSUMES LOTS OF REAL STORAGE WHEN USER SPECIFY FREQVAL COUNT(1000)
PH259792020-07-17 UI70631N/A     RUNSTATS FAILED WITH REASON=X’00E40213′ CAUSE=X’00C9004F’
PH282562020-11-11 UI72533N/A     RUNSTATS USE PROFILE ENDING WITH MSGDSNU611I OR MSGDSNU048I DUE TO BAD SYNTAX IN PROFILE_TEXT OF SYSIBM.SYSTABLES_PROFILES
PH285572020-10-07 UI71989N/A    YLow Dynamic Statement cache (DSC) hit ratio caused by IDAA statistics block storage leak 20/10/16 PTF PECHANGE
PH290622020-11-05 UI72412N/A     ABEND04E RC00E40231 DURING A RUNSTATS TABLESPACE INDEX
PH304692020-12-15 UI73163N/A     RUNSTATS USE PROFILE ABENDS S0C4 IN DSNXA02
PH312042020-11-24 UI72763N/A     RUNSTATS WITH MANY OBJECTS IN LISTDEF DOES NOT PROCESS ALL OBJECTS AND PROCESSES OTHER OBJECTS MULTIPLE TIMES
PH324482021-01-07 UI73367N/A     RUNSTATS UTILITY IS NOT COLLECTING THE SYSCOLDISTSTAT THAT IS BEING SPECIFIED (EG. FREQVAL COUNT 10 MOST)
PH332262021-02-26 UI74173N/A    YDB2 BUFFER MANAGER OPEN PAGESET STORAGE LEAK
PH341232021-03-01 UI74210N/A     RUNSTATS DOES NOT COLLECT DISTRIBUTION STATISTICS FOR SINGLE COLUMN COLGROUP FOR SEGMENTED MULTI-TABLE TABLE SPACES
PH352672021-06-01 UI75649N/A     RUNSTATS DOES NOT UPDATE COLUMN SYSCOLDIST.CARDF CORRECTLY WHEN NUMCOLUMNS > 1
PH375452021-07-14 UI76330N/A     RUNSTATS ABENDS0CF RC0000000F IN DSNUSEOF.
PH401892022-03-30 UI79958N/A    YRUNSTATS AT PARTITION LEVEL GOT ABEND04E RC00E40213 WITH CAUSE 00C9004F
PH435032022-03-31 UI79966N/A     RUNSTATS TABLESPACE REGISTER NO FAILS WITH RC00C90637 OR ABEND04E WITH RC00C90101 AT DSNIOW ERQUAL 2002
PH442462022-04-01 UI79986N/A    YABEND04E RC00E2000F DSNSVSFB+00A2A DURING A RUNSTATS TABLESPACE WITH EXCLUDE NULL KEYS INDEX
PH455332022-05-20 UI80643N/A     INCORRECT VALUE OF CARDF IN SYSIBM.SYSCOLDISTSTATS WHEN RUNSTATS COLLECTS KEYCARD STATISTICS ON DPSI INDEX
PH463512022-06-01ModifiedN/AUI80817 INCORRECT VALUE OF CARDF IN SYSIBM.SYSCOLDIST WHEN RUNSTATS COLLECTS KEYCARD STATISTICS ON DPSI INDEX
PH467672022-08-31New & ClosedUI82201UI82202 DROP INDEX LEAVES ORPHAN ROWS IN SYSIBM.SYSCOLDIST
PH471832022-07-19 UI81531UI81532 RUNSTATS USE PROFILE GOT TIMEOUT ON WAITING SYSCOLDISTSTATS TABLE X LOCK DURING LOCK ESCALATION.
PH484072022-09-02New & ClosedUI82237UI82238 RUNSTATS AT PARTITION LEVEL GETS ABEND04E RC00E40213 WITH CAUSE 00C9004F
PH49119 NewN/AOPEN COLCARDF IN SYSIBM.SYSCOLUMNS IS INCORRECT (RESET TO ZERO) AFTER A REORG AT PARTITION LEVEL USING INLINE STATISTICS

SQL PERFORMANCE and general HIPERs:

APARCLOSEDSTATUSDb2 12Db2 13HIPERDescription
PH071952020-03-31 UI68741N/A    YERRONEOUS SQLCODE -136 CAN BE ISSUED FOR A QUERY WHEN THE SORT KEY LENGTH IS NOT ACTUALLY TOO LONG
PH113762020-08-27 UI71295N/A     ABENDSOCF DSNUSEOF +X’07F42′ DURING REORG WITH INLINE STATISTICS EXECUTED ON MULTI TABLE TABLESPACE.
PH11864  OPENOPEN SQL SELECT RETURNS INCORROUT AFTER TABLE WITH LOB COLUMNS IS UPDATED
PH158962020-02-13 UI67906N/A     AUTOBIND DOES NOT TRY TO REUSE THE ACCESS PATH FROM CURRENT PACKAGE COPY SO ACCESS PATH COULD CHANGE, AFFECTING PERFORMANCE
PH162712020-01-29 UI67631N/A     PAIR-WISE STAR JOIN CHOSEN WHEN NESTED LOOP IS THE BETTER CHOICE
PH175112020-04-08 UI68926N/A     BLOCK SPARSE INDEX USAGE ON CERTAIN JOIN PREDICATE PUSHDOWN CASES.
PH178992020-01-04 UI67248N/A    YINCORRECT OUTPUT CAN OCCUR WHEN AN INDEX ON EXPRESSION INDEX IS USED.
PH179672020-04-09 UI68971N/A    YABEND RC00C90206 MESSAGE DSNI013I DSNIIDIS POTENTIALLY INCONSISTENT DATA ERQUAL 5002
PH181532020-02-28 UI68151N/A     AN INEFFICIENT ACCESS WITH INDEX+LISTPREFETCH IS CHOSEN WHILE DIRECT INDEX ACCESS CAN AVOID SORT FOR SQL WITH ORDERBY/GROUPBY
PH186482020-04-03 UI69157N/A    YABEND0C4 DSNISGSU USING INSERT ALGORITHM 2 IAG2
PH187392020-02-03 UI67690N/A     FTB DB2 12 FOR Z/OS NEW FUNCTION
PH187662020-02-21 UI68040N/A     INEFFICIENT INDEX SELECTION CAN OCCUR WITH A QUERY CONTAINING UNION ALL AND ORDER BY
PH189442020-02-05 UI68041N/A    YDB2 INTERNAL SERVICEABILITY APAR FOR INSERT ALGORITHM 2 – IAG2
PH189452020-03-18 UI68489N/A    YABEND04E 00C90101 DSNIDM DSNISFPI ERQUAL 5001 DURING INSERT IN TO A TABLE USING INSERT ALGORITHM 2 – IAG2
PH190442020-02-10 UI67374N/A     ACCESS PATH CHANGES FROM R-SCAN TO NON-MATCHING INDEX SCAN WHEN TABLESPACE IS CHANGED FROM SEGMENTED TO PARTITIONED
PH190712020-01-05 UI67253N/A     INCORROUT NO ROWS RETURNED WHEN RUNNING A QUERY WITH PARALLELISM
PH194082020-03-23 N/A    N/A     QUERY PERFORMANCE ISSUE MAY OCCUR WHEN A MULTI-INDEX PLAN WITH LARGE UNCERTAINTY IS USED
PH194832020-02-13 UI67378N/A    YDISALLOW LOCK AVOIDANCE FOR SINGLETON SELECT WITH ISOLATION(CS) AND CURRENTDATA(YES)
PH200332020-01-13 UI67370N/A     THE REBIND TRIGGER PACKAGE COMMAND WITH THE APREUSE(WARN) OPTIONCAN CAUSE THE SYSPACKDEP AND SYSDEPENDENCIES ROWS TO DISAPPEAR.
PH200972020-03-16 UI68427N/A     INEFFICIENT INDEX CAN BE CHOSEN WHEN TWO COMPETING INDEXES CONTAIN A SUBSET OF THE SAME COLUMNS
PH201242020-03-25 UI68623N/A    YDB2 11 – INCORROUT WITH DEGREE ANY USING COUNT DISTINCT WHEN PARALLELISM PROCESSING IS ACTIVE.
PH202392020-03-09 UI68273N/A     INEFFICIENT INDEX CAN BE CHOSEN BASED ON HIGH UNCERTAINTY PREDICATES.
PH202472020-02-11 UI67810N/A    YINCORROUT FOR A QUERY WITH OUTER AND INNER JOIN WITH A CORRELATED SUBQUERY AND VALUE FUNCTION
PH204322020-04-09 UI68964N/A     IN DB2 12, PIPELINED INNER(ACCESSTYPE=O) IS USED WHEN BETTER ACCESS PATH EXSITS
PH208622020-04-03 UI68808N/A    YPOSSIBLE INCORRECT OUTPUT WHEN OFFLOADING QUERY W/ HEX() SCALAR FUNCTIONIN EBCDIC SCHEME TO IBM DB2 ANALYTICS ACCELERATOR V7
PH211522020-02-18 UI67959N/A     FTB ABENDS0C4 RC0000003A DSNSLD4 DSNSVSFB OFFSET0075E
PH211532020-03-31 UI68737N/A     INCORROUT FOR A CLONE TABLE WITH -DIS DB(DBR000) SPACENAM(TSXXR000) RESTRICT ADVISORY
PH211612020-02-10 UI67794N/A     ABEND04E RC00E72018 AT DSNXSMRE P630 OCCURRED WHEN USING SPARSE INDEX ACCESS WITH HASHBOTH
PH212992020-03-16 UI68428N/A     ABEND04E RC00E70005 AT DSNXOTS M099 MAY ISSUED FOR QUERY WITH JOIN TO AN XML TABLE
PH213772020-03-25 UI68626N/A    YWRONG RESULT FOR SELECT WITH HAVING
PH213862020-02-13 UI67902N/A     ABEND04E RC00C90101 AT DSNIDM DSNIPSFI ERQUAL5007 OCCURRED WHEN AN OUTER JOIN QUERY CONTAINS A UDF FUNCTION
PH214772020-04-28 UI69248N/A    YINCORROUT FOR LEFT JOIN QUERY
PH215152020-03-09 UI68275N/A     ABEND04E RC00E70005 AT DSNXOV1 M315 FOR QUERY THAT REFERENCES A TABLE UDF
PH215802020-02-20 UI68034N/A     POOR PERFORMING RSCAN AP CHOSEN OVER NON-MATCHING INDEX SCAN WHEN TABLE IS CREATED AS VOLATILE
PH216412020-03-16 UI68434N/A     POSSIBLE INCORRECTOUT WHEN OFFLOADING CHAR SCALAR FUNCTION WITH THE FIRST PARAMETER AS DATETIME
PH217452020-07-08 UI70453N/A     ABEND04E RC00E70005 AT DSNXRSFN M205 DURING SQL PROCESSING
PH217932021-01-05 UI73335N/A     ABEND04E RC00E2000D AT DSNXESTR DSNSVSFB OFFSET00A18
PH218172020-03-04 UI68218N/A     UNNECESSARY SORT PERFORMED FOR IN SUBQUERY WITH FF1R
PH218302020-04-14 UI69002N/A     INEFFICIENT ACCESS PATH CAN BE CHOSEN WHEN THE QUERY CONTAINS A SUBQUERY THAT RETURNS A SINGLE ROW
PH219162020-03-25 UI68631N/A     ABEND04E RC00C90101 IN LOC=DSNIDM DSNKFLOK 1001 DURING FAST TRAVERSAL PROCESSING
PH221722020-05-29 UI69769N/A     FIRST LEG IN A MULTI INDEX ACCESS PATH CONTAINS HIGH UNCERTAINTY PREDICATE RESULTING IN POOR PERFORMANCE
PH221862020-07-31 UI70861N/A    YPOOR PERFORMANCE FOR A QUERY CONTAINING AN EXPRESSION JOIN PREDICATE AND AN INDEX ON EXPRESSION INDEX IS …
PH222242020-04-08 UI68924N/A     ABEND04E RC00E70005 AT DSNXGDT2 M111 MAY OCCUR FOR QUERY UNDER INSENSITIVE SCROLL CURSOR AND ORDER BY
PH223852020-04-15 UI69032N/A    YINCORRECT OUTPUT CAN OCCUR WHEN AN INDEX ON EXPRESSION INDEX IS USED AND THE QUERY USES HOST VARIABLES.
PH224362020-03-11 UI68315N/A    YINCORROUT USING THE STRIP BIF AND APPLCOMPAT = V10R1
PH226172020-03-25 UI68630N/A     DISABLE AGGRESSIVE QUERY BLOCK MERGE WHEN A SARGABLE JOIN PREDICATE DOES NOT EXIST.
PH226332020-08-10PE PH31619UI70980N/A     CHANGE THE RID POOL THRESHOLD FROM APS ESTIMATE TO ACTUAL WHEN POSSIBLE
PH226882020-05-01 UI68577N/A     DB2 12 FOR Z/OS INTERNAL SERVICEABILITY UPDATE
PH227102020-03-16 UI68437N/A     DIFFERENT RESULTS ARE RETURNED FROM A QUERY OFFLOADED TO IDAA BETWEEN V5 AND V7 USING BIF_COMPATIBILITY = V9_DECIMAL_VARCHAR
PH228582020-03-31 UI68746N/A     ABEND04E RC00E70005 AT DSNXROJ1 M524 FOR A QUERY THAT USES AN ACCESS PATH WITH SPARSE INDEX
PH229332020-07-06 UI70419N/A     ACCESS PATH DEGRADED AFTER INDEX CHANGED TO EXCLUDE NULL KEYS
PH232302020-05-07 UI69391N/A     PAIR-WISE STAR JOIN ( PWJ ) CHOSEN WHEN THERE IS A MORE EFFICIENT ACCESS PATH
PH232382020-06-10 UI69968N/A     DB2 12 FOR Z/OS FTB NEW FUNCTION
PH232552020-04-20 UI69109N/A     REMOTE QUERY USING MULTIPLE UNION ALL CLAUSES RECEIVES SQLCODE30020 OR ABEND04E RC00E70005 AT DSNXRSBC P041
PH232602020-06-24 UI70240N/A    YDSNKTRAV GOT A PAGE NUMBER X’FFFFFFFF’ AFTER CHECKING A LEAF PAGE AND CAUSED ABEND04E DSNKTRAF:2029
PH233432020-05-27 UI69715N/A    YABEND04E RC00C90101 AT DSNIDM DSNIRNXT ERQULA5029 OCCURRED ON A QUERY WITH CTE AND FULL OUTER JOIN
PH234032020-04-01 UI68773N/A     INCORRECT JOIN ORDER CAN BE CHOSEN FOR A QUERY WITH SIDEWAYS REFERENCES
PH235932020-04-14 UI69007N/A    YINCORRECT ORDER WHEN EXECUTING QUERY WHICH INCLUDES FULL OUTER JOIN AND ORDER BY AND AN OLAP FUNCTION
PH235942020-06-10 UI69974N/A    YINCORROUT FOR QUERY WITH INLIST (IN-LIST) ACCESS PATH (LESS ROWS THAN EXPECTED)
PH236442020-07-31 UI70859N/A     ABEND04E RC00E70005 AT DSNXRUNA M200 WHEN RUNNING A QUERY
PH239432020-04-23 UI69168N/A    YINCORROUT NULL RETURNED INSTEAD OF A COUNT FOR A QUERY USING PERCENTILE_DISC(0) WITH NULLS IN THE DATA AND DESCENDING ORDER
PH242792020-07-08 UI70454N/A    YOPTIMAL ACCESS PATH IS NOT USED WHEN AFTERJOIN PREDICATE WITH CHILD PREDICATE AS JOIN PREDICATE DOESN’T PROVIDE EXTRA
PH243372020-05-04 UI69325N/A     PERFORMANCE PROBLEM CAN OCCUR WITH TABLE EXPRESSIONS AND MORE UNION DISTRIBUTION
PH246672020-06-02 UI69831N/A    YABEND04E 00C90101 LOC DSNIDM DSNKDPG ERQUAL 500A OCCURRED DURING INDEX PAGE DELETION FOR FTB
PH249792020-07-01 UI70375N/A    YLOOP MAY OCCUR WHEN PARALLELISM IS ENABLED AND LOOPING OCCURS IN DSNXOLDP
PH250452020-08-28 UI71313N/A    YLIST PREFETCH ACCESS WAS CHOSEN ON THE INNER TABLE WHEN DYNAMIC PREFECH MAY BE BETTER.
PH251482020-06-01 UI69794N/A     ABEND0C4 RC00000010 AT DSNXOGBM OFFSETC29E MAY OCCUR FOR QUERY WITH COLUMN EXPRESSION AS THE LAST PREDICATE AND TABLE IS EMPTY
PH251962020-09-01 UI71349N/A     FTB SERVICEABILITY FIXES FOR DB2 12 FOR Z/OS
PH252402020-06-02 UI69834N/A    YIRLM SUPPORT TO HANDLE ERROR RETURNED FROM DB2 P-LOCK EXIT WHEN DRIVEN FOR SHARED STATE TRACKING ONLY
PH254482020-11-23 UI72734N/A    YINCORROUT FOR AN INNER JOIN QUERY THAT USING CTE, MORE ROWS THAN EXPECTED WILL RETURN
PH255072020-06-25ModifiedUI70250N/A     INEFFICIENT ACCESS PATH AFTER CONVERSION TO UTS
PH256892020-11-03 UI72379N/A     EVEN WITH DB2 V12 DESCSTAT=NO, DESCRIBE CURSOR FOR STATIC QUERY RETURNS COLUMN NAMES INSTEAD OF COLUMN NUMBERS OR ORDINAL POS
PH257002020-08-25 UI71239N/A     INEFFICIENT ACCESS PATH EXCLUDES MULTI-INDEX ACCESS AFTER CONVERSION TO UTS
PH257352020-06-29 UI70324N/A     ABEND04E RC00E70005 AT DSNXGARI M621 FOR A QUERY WITH AN ACCESS PATH USING A VIRTUAL TABLE IN ITS OUTER JOIN
PH258012020-06-17 UI70116N/A    YABEND04E RC00C90101 LOC DSNIDM DSNKTRAV ERQUAL501C OCCURRED DURING INDEX SPLIT WITH FTB
PH258592020-06-17 UI70114N/A    YFTB STORAGE LEAK IN EXTENDED LSQA CAUSED BY DSNKFTOM – DSNV508I
PH258972020-07-28 UI70793N/A    YABEND0C7 AT DSNXRDEC OFFSETE380 FOR QUERY CONTAINS MULTIPLICATION ON DECIMALS WHEN CURRENT PRECISION = DEC31
PH259492020-12-11 UI73092N/A    YABEND04E 00C90105 AT DSNIASFP 0CA4 DURING INSERT WORKLOADS USING INSERT ALGORITHM 2 – IAG2
PH261092020-06-25 UI70271N/A    YFTB OVERLAY ABEND04E RC00E2002F DSNKFTOM DSNSVSFM OFFSET008AE
PH261152020-07-10 UI70500N/A     ABEND0C4 RC00000038 IN DSNXOPDS AT OFFSET00188 OR OFFSET0018C CAN OCCUR FOR QUERY WITH AN XMLAGG FUNCTION
PH26180  OPENOPEN CARTESIAN PRODUCT RESULTING FROM INCORRECT JOIN ORDER
PH263262020-07-31 UI70860N/A     ABEND04E RC00E70005 AT DSNXOSR :P002 MAY ISSUED FOR QUERY HAVE PREDICATE USE LISTAGG WITH DISTINCT
PH264022020-06-30 UI70325N/A     FTB ABEND04E 00C90101 LOC=DSNIDM DSNKMDEL ERQUAL 5010 OCCURS DURING MASS DELETE OPERATION
PH264202020-11-09 UI72485N/A     ACCESSTYPE=O IS USED TO PUSHDOWN JOIN PREDICATES ON TABLE EXPRESSION OR VIEW WHEN BETTER ACCESS PATH EXISTS
PH264322020-08-11 UI71022N/A    YINCORRECT ORDER RETURNED ON SQL STATEMENT WITH INLIST SUBQUERY AND INDEX CAN NOT MATCH ALL THE COLUMNS IN THE INLIST PREDICATE
PH26498  OPENOPEN(Y)ABEND04E RC00C90101 DSNISFPI ERQUAL5019 WHEN USING INSERT ALGORITHM 2 IAG2
PH265822020-08-24 UI71214N/A    YINEFFICIENT ACCESS PATH INCLUDING A NESTED LOOP JOIN TO THE INNER TABLE USING RSCAN
PH266332020-07-30 UI70837N/A     SUB-OPTIMIAL ACCESS PATH IS USED FOR A STAR JOIN QUERY WHEN A DIMENSION TABLE RETURNS 0 ROW
PH266442020-10-21 UI72188N/A    YRC00C90101 AT DSNOPUFF ERQUAL500A
PH267512020-08-20 UI71166N/A    YINCORRECT OUTPUT OR POOR PERFORMANCE FOR CORRELATED QUERIES WITHCOMPLEX JOINS
PH268152020-07-13 UI70523N/A    YFTB INSERT ABENDS0C4 RC00000038 PIC38 IN DSNKTRAV OFFSET1B81A
PH268232020-08-31 UI71329N/A    YSQLCODE171 FOR SQL REPLACE ON UNICODE GRAPHIC CHARACTER WHEN there’s surrogate pair
PH268452020-07-13 UI70523N/A    YFTB INSERT ABENDS0C4 RC00000038 PIC38 IN DSNKTRAV OFFSET1B81A
PH268792020-07-20 UI70672N/A     ABEND04E RC00E70005 AT DSNXGSGP M002 MAY ISSUE FOR QUERY WITH GROUP BY THAT CONTAINS SAME COLUMN MORE THAN ONCE
PH269172020-07-15 UI70569N/A    YPOOR PERFORMING QUERY DUE TO LESS INDEX MATCHING PREDICATES DETECTED WITH MULTIPLE QUERY BLOCKS WITH NESTED TABLE EXPR
PH270782020-09-04PE PH35088UI71423N/A    YABEND0C4 RC04 AT DSNXEDSC+03D32 OR ABEND04E RC00E70005 AT DSNXEBR:M705 CAN OCCUR ON A QUERY
PH271002020-08-11 UI71023N/A     BEST INDEX IS NOT USED WHEN QUERY HAS A BETWEEN AND PREDICATE ON PARTITION KEY AND SOME PARTITIONS ARE EMPTY
PH272072020-08-04 UI70899N/A    YABEND04E RC00E501A1 AT CSECT DSNVSRX OFFSET03186 WHEN CANCELLING A COMPLEX QUERY WHICH CONTAINS MULTIPLE PAIR WISE JOINS
PH273202020-07-29 UI70814N/A     FTB ABENDS0C4 00000011 IN DSNKFTDL OFFSET0117C DURING DELETE PROCESSING FOR INDEX KEY X’FFFFFFFF’
PH273302020-08-28 UI71312N/A     SLOW SQL PERFORMANCE CAN OCCUR WHEN FETCH FIRST N ROWS ONLY OR OPTIMIZE FOR N ROWS IS SPECIFIED AND THERE ARE NO STATS ON TABLE
PH273352020-10-02PE PH32375UI71890N/A     ABEND ON RID SPECIFIC DELETE AFTER MASS DELETE
PH275082020-08-03 UI70877N/A    YPOOR PERFORMING ACCESS PATH CHOSEN WHEN AN INDEX THAT CAN MATCH ON JOIN PREDICATES MAY BE INCORRECTLY PRUNED
PH275552020-08-26 UI71269N/A     IN DB2 12, SUB-OPTIMAL ACCESS PATH IS USED FOR QUERY CONTAINING A VIEW OR TABLE EXPRESSION WHICH HAS MULTIPLE OUTER JOINS
PH276162020-10-01 N/A    N/A     POOR PERFORMING QUERY DUE TO IMPACT OF UNDERESTIMATED JOIN SIZE TO THE DECISION OF JOIN PREDICATE PUSH DOWN
PH276712020-08-20 UI71162N/A     SQLCODE410 OR SQLWARN366 ON AN UPDATE OF A DECFLOAT COLUMN WHEN DECP HAS DECIMAL=COMMA
PH276872020-09-02 UI71392N/A     PROVIDE RELIEF FOR QUERIES REACHING THE LIMITS OF ZPARM MAX_OPT_STOR
PH277302020-09-22 UI71704N/A     ABEND04E RC00E70005 AT DSNXRRPO M104 WHEN FULL OUTER JOIN ON PREDICATE COLUMN IS DECFLOAT
PH278222020-08-20 UI71171N/A    YDEFAULT_INSERT_ALGORITHM SUBSYSTEM PARAMETER CHANGE OF DEFAULT FROM 2 TO 1
PH278402021-02-05 UI73843N/A     INCORROUT FROM QUERY THAT REFERENCES A LARGE VARCHAR FOR BIT DATA COLUMN AS A JOIN PREDICATE FOR SORT MERGE JOIN
PH279142020-09-02 UI71393N/A     ABEND0C4 RC00000010 IN DB2 DIST AT DSNXOTS FOR OFFSET11FC2 OR OFFSET11EE0
PH280502020-09-10 UI71492N/A    YR-SCAN IS USED WHEN MATCHING INDEX EXISTS
PH281042020-09-04PE PH36908UI71428N/A     LOAD FORMAT DELIMITED OF DECIMAL FIELDS WITHOUT A DECIMAL POINT SPECIFIED CAN FAIL WITH MSGDSNU333I AND DISCARDING THE RECORD
PH281792020-10-22 UI72212N/A     CREATE INSTEAD OF TRIGGER ON A VIEW CAN GET AN UNEXPECTED SQLCODE -552 ERROR
PH281822020-09-25 UI71784N/A     INDEX LOOK ASIDE SUPPORT WHEN INDEX FAST TRAVERSE BLOCK(FTB) IS IN USE
PH282282020-09-10 UI71496N/A     ABEND0C4 RC38 AT DSNXOW1 OFFSET03490 FOR A QUERY WITH OVER 32767COLUMNS IN PREDICATES OR UNION DISTRIBUTION
PH282642020-09-04 UI71430N/A    YINCORROUT MAY HAPPEN FOR AN SQL STATEMENT REFERENCING A TABLE EXPRESSION OR VIEW OR SQLTABLEUDF WHICH CONTAINS MULTIPLE JOINS
PH284342020-09-02 UI71390N/A     BLOCK JOIN PREDICATE PUSHDOWN WHEN THE TARGET SUBQUERY CONTAINS A MATERIALIZED WORKFILE
PH284432020-12-07 UI72960N/A     ABEND04E RC00D3440B DSNLXOQS AT LOGICAL OFFSET 0378
PH285082020-10-28 UI72281N/A     ABEND 0C4 AT DSNXGRDS.DSNXODTX+00206 MAY OCCUR WHEN THE QUERY CONTAINS GROUPING SET AND THERE IS A GROUP BY IN THE BODY OF A
PH285512020-09-29 UI71812N/A     BACK OUT CERTAIN CASES OF IMPLICIT CAST INDEXABLE SUPPORT THAT INTRODUCED IN V12
PH286212020-09-15 UI71567N/A     XMLQUERY AND XMLTABLE ADD INVALID DATA WHEN INPUT MESSAGE GREATER THAN 1M
PH287312021-01-07 UI73383N/A     ABEND04E RC00C90101 AT DSNIDM DSNISRID ERQUAL500A OCCURRED FOR A SECOND FETCH FROM A ROWSET CURSOR
PH288102021-01-28 UI73671N/A     MSGDSNT286I INDICATES APREUSE WAS NOT SUCCESSFUL WHEN THE ACCESSPATH BEING REUSED CONTAINS CORRELATED SPARSE INDEX IN TBL EXPR
PH289232020-10-20 UI72172N/A     INEFFICIENT ACCESS CAN OCCUR WHEN A PREDICATE VALUE FALLS OUTSIDE THE RANGE OF H2KEY/L2KEY
PH291022020-10-27 UI72276N/A     ABEND04E DSNKTRAV ERQUAL505B RC00C90101 FTB TRAVERSAL
PH291432020-10-05 UI71927N/A    YSTORAGE LEAK FOR PREDICATE PROC MAY OCCUR WHEN EXECUTING A PACAKGE ON FL505
PH291752020-10-19 UI72147N/A     SQLCODE199 REBINDING AN SQLPL PACKAGE WHICH CONTAINS SQL WITH A TABLE EXPRESSION THAT HAS AN ORDER BY WITH VARIABLE
PH293362020-09-22 UI71351N/A    IRLMCORRECT RESULTANT HELD STATE FOR FTB PLOCKS WHEN PLOCK EXIT WOULD HAVE EXITTED WITH ERROR.
PH294822020-10-19 UI72148N/A     POSSIBLE INCORROUT WHEN QUERY W/ TEMPORAL PREDICATE IS OFFLOADEDAND BOTH OPERANDS OF TEMPORAL PRED ARE LITERALS WITH CHAR/VARCHA
PH295662020-11-13 UI72590N/A      INCORROUT MAY HAPPEN FOR QUERY WITH UNION ALL AND ORDER BY
PH296122020-10-05 UI71930N/A    YINCORROUT USING LISTAGG. MISSING SQLCODE -137 AND INCORRECT LENGTH REPORTED.
PH296662020-10-01 UI71877N/A     DB2 12 SERVICEABILITY FOR INFLUENCING ACCESS PATH SELECTION
PH296762020-10-16 UI72118N/A     ABEND04E RC00C90101 AT DSNKTRAV 5058 DURING INSERT VIA FTB
PH298422020-10-19 UI72148N/A     POSSIBLE INCORROUT WHEN QUERY W/ TEMPORAL PREDICATE IS OFFLOADEDAND BOTH OPERANDS OF TEMPORAL PRED ARE LITERALS WITH CHAR/VARCHA
PH299182021-01-19 UI73538N/A     ABEND0C7 AT DSNXRDEC OFFSET8960 MAY BE ISSUED FOR A QUERY THAT REF A VIEW OR AN SQL TABLE UDF THAT CONTAINS RECURSIVE CTE
PH299792020-10-27 UI72275N/A    YINCORRECT OUTPUT FOR SELECT USING MAX() OR ROWNUMBER() OVER() FUNCTION USED WITHIN INSERT
PH300402020-10-27 UI72279N/A    YINCORRECT OUTPUT CAN OCCUR WITH AN ACCESS PATH USING PAGE RANGE SCREENING.
PH301362020-12-30 N/A    N/A     POOR PERFORMING QUERY DUE TO INEFFICIENT JOIN ORDER CHOSEN AFTERQUERY BLOCK MERGE
PH302312020-11-17 UI72634N/A     ABEND04E RC00E70005 DSNXOACM M120 FOR A QUERY WITH A COMMON TABLE EXPRESSION AND COLUMN WITH A COLUMN MASK
PH302932020-11-16 UI72614N/A     ABEND04E RC00E2000C DSNSVSVB OFFSET0A54 FOR A QUERY USING SORT
PH303572020-10-28 UI72302N/A     SUBOPTIMAL QUERY PERFORMANCE DUE TO GLOBAL OPTIMIZATION TRANSFORMATION OF NONCORRELATED IN-SUBQUERY PREDICATE
PH303652020-11-09PE PH34584UI72487N/A     PREDICATES THAT ARE PUSHED INTO A VIEW CONTAINING UNION ALL CANNOT UTILIZE EXPRESSION INDEXES.
PH303662020-12-15 UI73164N/A    YDSNICUMW 5003 OR DSNIOW 5003 00C90101 ABENDS OCCUR WHEN THE DATAPAGE IS RE-FORMATTED BY AN INSERT THREAD RUNNING IAG2
PH303962021-01-06 UI73347N/A     OPTIMAL ACCESS PATH MIGHT NOT BE USED FOR A JOIN QUERY WHICH CONTAINS BOTH LOCAL PREDICATE AND JOIN PREDICATE ON SAME COLUMN.
PH304102020-11-05 UI72426N/A     DB2 MAY CHOOSE TO MATERIALIZE CERTAIN QUERY BLOCKS THAT SHOULD BE CORRELATED VIA PIPELINING
PH304672020-12-14 UI73119N/A     ABEND04E RC00E70005 AT DSNXOPCO M096 FOR AN SQL STATEMENT SATISFYING ALL CONDITIONS DESCRIBED IN THIS APAR
PH304682020-10-28 UI72283N/A    YINCORROUT COULD OCCUR FOR A QUERY WITH WHERE NOT EXISTS OR HAVING NOT EXISTS IF THERE IS ALSO A GROUP BY ON A
PH305942020-11-10 UI72503N/A    YINFINITE LOOP MAY OCCUR FOR AN SQL STATEMENT WITH MULTIPLE OUTER JOINS AND IN-SUBQUERY PREDICATES
PH307382020-11-05 UI72422N/A    YABEND0C4 00000004 RC04 PIC04 DSNB1DCM +0123E
PH307792020-12-03 UI72907N/A     ALLOW INDEXABILITY FOR SET COLUMN FUNCTIONS UNDER CERTAIN CONDITIONS
PH309782021-06-01ModifiedUI75643N/A     SUBSYSTEM PARAMETER TO ENABLE INDEX IN-MEMORY OPTIMIZATION (FTB) FOR NON-UNIQUE INDEXES
PH309792020-11-23 UI72742N/A    YDATA CORRUPTION AFTER REORG COMPLETED WITH RC00 WITH PH28092 INSTALLED, RC00C90206 ERQUAL5007, INCORROUT, ABEND0C4 DSNURBXD
PH309822020-11-30PE PH38003UI72850N/A     INEFFICIENT LESS MATCHING INDEX CHOSEN.
PH311182021-01-06 UI73357N/A     INEFFICIENT JOIN ORDER AND JOIN TYPE CAN BE SELECTED AFTER QUERYBLOCK MERGE
PH311462021-01-20 UI73548N/A     ABEND0C4 RC0000003A RC04 PIC3A DSNSVSVB +00CB0 FOR THE QUERY WITH HUGE NUMBER OF UDFS
PH313852020-11-30 UI72849N/A     PERFORMANCE ISSUES CAN OCCUR WHEN A QUERY CONTAINS A UNION ALL
PH314902021-01-06 UI73359N/A     ABEND0C4 DSNXRSOR +146 @ UI62958
PH315662022-01-12 UI78898N/A    YUSER RECEIVED AN UNEXPECTED ABEND04E RC00E70100 IN DSNXGRDS DSNXISB7 P110 ON AN INSERT STATEMENT
PH316192020-12-01 UI72872N/A    YPOOR PERFORMING SQL QUERY DUE TO LIST PREFETCH INCORRECTLY FALLING BACK TO RSCAN DUE TO A NEGATIVE RID LIMIT THRESHOLD
PH316212021-01-07 UI73365N/A     POOR PERFORMING QUERY WHEN DB2 SELECTS INDEX + LIST PREFETCH AP FOR LEADING TABLE WHILE INDEX IS CLUSTERING AND CAN AVOID SORT
PH316802021-02-15 UI73982N/A     POOR PERFORMANCE CAN OCCUR FOR A QUERY WITH TABLES HAVING DIFFERENT CCSID’S
PH317752022-01-05 UI78823N/A    YA LINEAR INDEX WITH > 255 PIECES IS NOT RECOVERED BY RESTORE SYSTEM UTILITY
PH317962021-01-08 UI73397N/A    YA QUERY USING DEGREE=’ANY’ MAY HAVE IDENTICAL ROWS RETURNED
PH318722021-02-02 UI73756N/A     AN INEFFICIENT ACCESS PATH IS CHOSEN AFTER A TABLE EXPRESSION ISMERGED
PH319092020-12-24 UI73307N/A     INSERT STATEMENT WITH TIMESTAMP FUNCTION TO INSERT INTO A VARCHAR/CHAR COLUMN MAY GET SQLCODE -408 INCORRECTLY RETURNED
PH320972021-02-02 UI73760N/A     THE QUERY USING OFFSET CLAUSE WITH UNION AND HOST-VARIABLE CAN RETURN EMPTY RESULT SET
PH323552021-02-12 UI73972N/A    YINCORRECT RESULT WITH NO ROWS RETURNED FOR QUERY FROM TABLE FUNCTION USING LITERAL
PH323752020-12-30 UI73320N/A     INSERT ROW FAILS WITH SQLCODE161 AFTER PH27335/UI71890 HAS BEEN APPLIED 20/12/04 PTF PECHANGE
PH323762021-01-06 UI73362N/A    YADDITIONAL TAG SORT AND SORT POOL VERIFICATION.
PH324682021-01-20 UI73559N/A     INEFFICIENT ACCESS CAN BE CHOSEN FOR A QUERY CONTAINING A FF1R CLAUSE
PH326612021-01-07 UI73394N/A     ABEND04E RC00E70005 AT DSNXEFDA OFFSET035FC FOR A QUERY THAT REQUIRES A VERY LARGE RID SORT.
PH326882021-03-03 UI74227N/A     POOR PERFORMANCE CAN OCCUR FOR A QUERY WITH FF1R.
PH326902021-02-18 UI74060N/A    YINCORROUT WHEN A SAME EXPRESSION ALIAS APPEARS IN THE SELECTION LIST MULTIPLE TIMES AND THIS QUERY RUNS ON PARALLELISM
PH327262021-03-03 UI74226N/A     POOR PERFORMANCE CAN BE SEEN WHEN A QUERY CONTAINS MULTIPLE PREDICATES.
PH329822021-01-20 UI73560N/A     POOR PERFORMING SQL QUERY WHEN THE QUERY HAS MULTIPLE RANGE OR BETWEEN PREDICATES WHICH QUALIFIED MULTI-INDEX ACCESS
PH329852021-02-03 UI73782N/A     ABND0C4 REASON00000004 AT DSNXGRDS DSNXOLIT OFFSET004DC MAY OCCUR FOR QUERY WITH STATEMENT CONCENTRATION ENABLED
PH331282021-02-10PE PH41952UI73918N/A     POOR PERFORMANCE CAN OCCUR FOR A QUERY CONTAINING A FFNR
PH331962021-04-19 UI74989N/A     PERFORMANCE ISSUE WHEN SPARSE INDEX WAS CHOSEN AND THERE EXISTS PREDICATES THAT ARE CAST TO VERY LONG LENGTHS
PH332852021-03-11 UI74393N/A     INCORRECT ACCESS PATH WHEN A VALUE COMPARE OR A BETWEEN PREDICATE WITH ARITHMETIC EXPRESSION ON DECIMAL VARIABLES AND A
PH333392021-03-03 UI74234N/A     LACK OF IFCID 376 REASON 3 (TIMESTAMP) IN DB2 V12 TRACE WHEN APPLCOMPAT = V10R1 AND BIF_COMPAT IS NOT CURRENT
PH334142021-03-29 UI74634N/A    YRECOVER UTILITY DOES NOT CORRECTLY RECOVER THE COPY YES INDEXES CAUSING DATA/INDEX MISMATCH
PH334432021-02-10 UI73921N/A     ABEND04E RC00C900D0 AT DSNXROHB OFFSET23DC4 MAY OCCUR FOR NOT NULL LOB/XML COLUMN INVOLVING IN OUTER JOIN
PH336362021-03-08 UI74325N/A     INCORRECT OUTPUT FOR AN SQL STATEMENT THAT REFERENCES A VIEW WITH MULTIPLE OUTER JOINS
PH340452021-03-15 UI74443N/A    YINCORRECT SORT ORDER IN OUTPUT OF SELECT STATEMENT
PH340462021-03-29 UI74636N/A     INCORROUT FOR A QUERY WITH EXISTS PREDICATE IN CASE EXPRESSION AND OUTER JOINS
PH340562021-04-02 UI74752N/A     ABEND04E RC00E70005 AT DSNXOW2D P333 MAY HAPPEN WHEN UPDATING A VIEW WITH AN ISNULL PREDICATE
PH340962021-02-16 UI74002N/A     ABEND0C4 RC38 DSNXOGA OFFSETAE6C AE6C WHILE RUNNING COMPLEX QUERY
PH341782021-05-03 UI75206N/A     SUB-OPTIMAL ACCESS PATH CAN BE CHOSEN FOR THE QUERY
PH341892021-04-07 UI74812N/A     ABEND04E RC00C90101 AT DSNIDM DSNIWNRF ERQUAL5006 MIGHT HAPPEN WHEN A QUERY WITH LEFT OUTER JOIN AND SORT MERGE JOIN IS USED
PH342412021-04-12 UI74891N/A     ABEND0C4 RC38 DSNXECST OFFSET09F6 09F6 WHILE RUNNING COMPLEX QUERY
PH342472021-03-12 UI74421N/A     INEFFICIENT INDEX CHOSEN IN A RANGE-LIST ACCESS PATH.
PH342922021-06-23 UI76040N/A    YROLLBACK AFTER ALTER TABLE ALTER COLUMN SET WITH DEFAULT DOES NOT RESTORE PRIOR DEFAULT VALUE
PH344252021-03-08 UI74327N/A     INCORRECT OUTPUT OF CASE WHEN COMPARING VARCHAR COLUMNS
PH344652021-04-16ModifiedUI74966N/A    YABENDS0C4 IN DSNIASFP OFFSET001A8 DURING INSERT WORKLOAD USING INSERT ALGORITHM 2 – IAG2
PH344682021-04-20 UI75007N/A     ABEND04E RC00C90101 AT DSNKTRAV ERQUAL5021 VIA FTB TRAVERSAL
PH345842021-03-30 UI74673N/A    YABEND04E AT DSNXOB2 M105 ON A REBIND PACKAGE 21/03/23 PTF PECHANGE
PH346422021-05-17 UI75437N/A     INCORROUT WRONG ROWS RETURNED FOR A QUERY WITH MULTIPLE JOINS WITH NOT EXISTS CORRELATED SUBQUERY
PH346892021-04-02 UI74759N/A    YINCORRECT OUTPUT FROM SELECT WHEN NULL HOST VARIABLE WAS USED IN A PREDICATE AGAINST NOT NULL COLUMN
PH348072021-03-29 UI74649N/A     EXTRA CPU COST OF MASS DELETE
PH348592021-05-05 UI75254N/A     DB2 12 FOR Z/OS NEW FUNCTION FOR FTB (FAST TRAVERSE BLOCKS)
PH349032021-03-17 UI74490N/A     ABEND04E RC00E70005 DSNXOFL M120 OCCURS ON UNION ALL
PH349082021-04-13 UI74918N/A     ABEND0C4 RC04 IN DSNXSRME OFFSET061A FOR SELECT USING TABLE EXPRESSION AND HYBRID JOIN
PH350802021-03-23 UI74586N/A     SQLCODE16061 ISSUED FOR A QUERY USING XMLCAST
PH350882021-04-07 UI74809N/A    YHIGH CPU DUE TO LONG PREPARES AND LOW HIT RATIO IN DYNAMIC STATEMENT CACHE WHEN DYNAMIC SQL PLAN STABILITY IS ENABLED
PH354642021-04-20 UI75013N/A     INEFFICIENT INDEX CHOSEN BETWEEN COMPETING INDEXES WHEN ONE CANDIDATE PROVIDES INDEX ONLY
PH355962021-04-07 UI74814N/A    YINSERT SPLITTING PAGE INTO FTB LEAF NODE GOT DSNKFTIN:5002 ABEND BECAUSE OLD PAGE THAT CAUSE THE PAGE SPLIT WAT MISSING IN FTB.
PH358722021-06-17 UI75961N/A    YABEND0C4 RC4 DSNURWBF+0B012 IN PARALLEL LOAD TO THE SAME PARTITION
PH359592021-04-13 UI74908N/A    YINCORROUT FOR QUERY WHERE LEADING TABLE IN ACCESS PATH IS ACCESSED WITH AN EQUAL UNIQUE INDEX AND NEXT TABLE HAS PREFETCH
PH360932021-07-30 UI76541N/A     INEFFICIENT JOIN TYPE CHOSEN WHEN THE SAME INDEX IS USED WITH LESS MATCHING COLUMNS
PH361472021-04-29 UI75178N/A     ABEND04E RC00E20018 AT DSNSTKGG OFFSET00D76 ISSUED FOR A QUERY ON VIEW AND ITERATING ENTRIES OF DSNXOV1 IN FORMATTED DUMP TRACE
PH361792021-06-02 UI75667N/A     DB2 12 FOR Z/OS ENHANCEMENT – APREUSE supports page range screening
PH362122021-10-28 UI77851N/A     JOIN PREDICATE PUSHDOWN IS BEING ELIMINATED UNDER SOME CIRCUMSTANCES.
PH362222021-05-14 UI75411N/A    YINCORRECT OUTPUT (TOO FEW ROWS RETURNED) POSSIBLE ON FULL OUTER JOIN RUNNING W/PARALLELISM, OUTER & INNER TABLES W/INDEX ACCESS
PH362972021-06-23 UI76046N/A     INEFFICIENT ACCESS PATH WHEN A POOR FILTERING INDEX LEG FOR RID LIST ACCESS IS CHOSEN FOR A JOIN 21/05/27 PTF PECHANGE
PH363002021-08-11 UI76686N/A     UNNECESSARY MULTI-INDEX LEGS ARE GENERATED WHEN A QUERY CONTAINSA HIGH UNCERTAINTY PREDICATE
PH363562021-05-24 UI75545N/A    YUNEXPECTED NULL RESULT IN QUERY RESULT.
PH364062021-05-07 UI75288N/A     INSERT KEY INTO FTB PROCESS DETECTING INCONSISTENT STRUCTURE MODIFICATION NUMBER THEN GOT DSNKFTIN:5043 ABEND
PH364302021-05-13 UI75393N/A    YINCORROUT WHEN A TABLE EXPRESSION IS ACCESSED BY ‘O’ ACCESS TYPE WHILE ITS BODY IS A SINGLE TABLE QUERYBLOCK AND INDEX IS USED
PH364342021-05-13 UI75392N/A     DB2 12 FOR Z/OS INTERNAL SERVICEABILITY UPDATE (Improve Create / Free FTB log recs)
PH365072021-08-18 UI76828N/A    YINCORROUT ON QUERY WITH MULTIPLE LEFT JOINS, COALESCE AND SPARSE INDEX
PH365312021-05-13 UI75391N/A    YABEND04E RC00C90101 AT DSNKINSN ERQUAL5009 AND DSNKFTIN ERQUAL5066 FOR FTB INSERT PLOCK FAILURE
PH365402021-05-11 UI75345N/A     AN INEFFICIENT ACCESS PATH USING LIST PREFETCH+SORT IS CHOSEN WHEN DIRECT INDEX ACCESS PROVIDES BETTER PERFORMANCE.
PH367372021-07-19 UI76363N/A     RIDPOOL FAILURES FOR QUERY WITH MULTI-INDEX ANDING AND NO QUALI FYING RIDS FOR SECOND INDEX
PH369082021-08-03 UI76579N/A     BACKING OUT THE BEHAVIOR FOR LOAD FORMAT DELIMITED FOR DECIMAL FIELDS WITHOUT A DECIMAL POINT THAT WAS IN 21/05/04 PTF PECHANGE
PH369782021-06-18 UI75978N/A     FTB MESSAGE MSGDSNT351I ISSUED INCORRECTLY
PH370192021-08-03 UI76581N/A     DB2 12 FOR Z/OS NEW FUNCTION FOR APREUSE
PH371162021-07-06 UI76220N/A     ABEND0C4 RC38 IN DSNSVSFB OFFSET0758 WHILE EXECUTING DYNAMIC SQL AND DYNAMIC PLAN STABILITY IS ACTIVE
PH371192021-08-03 UI77291N/A     INCONSISTENT ACCESS PATH FOR THE QUERY USING BETWEEN PREDICATE VERSUS RANGE PREDICATE
PH371512021-08-24 UI76897N/A     IAG2 ABEND04E RC00C90101 DSNIBHRE ERQUAL5007
PH371712021-06-15 UI75893N/A     INCORROUT MAY OCCUR FOR A QUERY USING INLIST OR BETWEEN WHICH CONTAINS COLUMNS
PH374162021-11-02 UI77911N/A     EXPLAIN PROVIDES INCORRECT ESTIMATE OF SU/TIME FOR QUERY.
PH374722021-06-25 UI76090N/A     WORKFILE ABENDS0C4 PIC4 AT DSNIWNRF OFFSET0DE50
PH378522021-07-22 UI76410N/A     DSNTIAUL INCORRECT OUTPUT CAN HAPPEN FOR SELECT FROM UTF-16 VARGRAPHIC COLUMN
PH380032021-09-21 UI77249N/A     SLOW QUERY PERFORMANCE FOR LEFT OUTER JOIN QUERY
PH382122021-07-07 UI76239N/A    YABEND04E RC00C90101 AT DSNKFTBU ERQUAL5061 AND DSNK1CNE ERQUAL5006 DURING FTB CREATION
PH382612021-10-18 UI77686N/A    YDSNIIDIS:5002 OCCURRED DUE TO A MISSING INDEX ENTRY CAUSED BY A FAILURE OF SERIALIZATION BETWEEN CREATE INIDEX AND INSERT.
PH382742021-08-04 UI76596N/A     ABEND04E RC00E2000C AT DSNXRSPL DSNSVSVB OFFSET00A54 WHEN INVOKING AN ADVANCED TRIGGER WITH HANDLER
PH384152021-10-25 UI77810N/A     POOR INDEX MAY BE CHOSEN FOR QUERY WITH MULTIPLE PREDICATES ON THE SAME COLUMN
PH385512021-08-06 UI76633N/A     ABEND04E RC00E2000F IN DSNSVSFB +00A2A WHILE RUNNING STORED PROCEDURES
PH386402021-08-09 UI76642N/A     DB2 PARALLELISM TASK ABEND04E RC00C90101 IN WORKILE MODULE DSNIWNRF ERQUAL 5010
PH388722021-09-02 UI77010N/A     UPDATE THE LENGTH OF THE ASCE AND PRHW – Fix in error see PH40706
PH391052021-10-18 UI77687N/A     DB2 12 FTB INDEXTRAVERSECOUNT = 4294967295 FOR OBJECTS NOT ENABLED FOR FTB
PH391112021-09-15 UI77157N/A     POOR PERFORMANCE OF AN UDPATE STATEMENT THAT CONTAINS A TABLE EXPRESSION ON THE NULL PADDING SIDE OF AN OUTER JOIN
PH392862021-08-23 UI76886N/A    YABEND0C4 RC003B AT DSNXODN OFFSET00600 AND ABEND04E RC00E2000D DSNLXDAL DSNSVSFB OFFSET00A18 LEAD TO DB2 ABTERM RC00E50702
PH393032021-10-18 UI77691N/A     ABEND04E RC00E70005 AT DSNXOP1 M150 FOR A CREATE FUNCTION
PH394132021-09-02 UI77014N/A     SQLCODE104 ISSUED WHEN REBIND ADVANCED TRIGGER WHICH CONTAINS A CALL STATEMENT WITH TABLE LOCATOR AS ITS PARAMETER
PH395842021-09-21 UI77253N/A     INEFFICIENT ACCESS PATH CHOSEN WHEN A QUERY CONTAINS A FF1R CLAUSE AND AN INDEX ACCESS CAN BE MATCHING
PH396312022-01-28 UI79120N/A    YABND0C4 RC10 IN DSNVXUL0 +00324 AFTER CANCEL THREAD
PH396772021-09-07 UI77044N/A     AN ALL ZERO PAGE ERROR – ABEND DSNKTRAV:5021
PH397512021-09-14 UI77134N/A     THE INEFFICIENT JOIN SEQUENCE MAY BE CHOSEN, WHEN THE JOIN TABLE HAS A CORRELATED PREDICATE
PH398222021-09-27 UI77334N/A     DB2 12 SERVICEABILITY FOR INFLUENCING ACCESS PATH SELECTION AND SUPPORTING INDEXABILITY FOR SQL STMTS USING IMPLICIT CAST
PH398752021-09-02 UI77013N/A     ABEND04E RC00E70005 DSNXOACM P070 WHEN A COLUMN MASK IS DEFINED
PH400032021-09-27 UI77336N/A    YCORRELATED SQL ISSUE, WHEN A TRANSITIVE CLOSURE PREDICATE IS GENERATED IN A SUB-QUERY INSIDE A CASE-WHEN CLAUSE.
PH402162022-01-21 UI79013N/A     BLOCK JOIN PREDICATE PUSHDOWN WHEN THE TARGET SUBQUERY ACCESS PATH IS TABLESPACE SCAN
PH402432022-04-19 UI80210N/A     DCC NEW FUNCTION FOR DB2ZAI V1.5
PH402692021-09-16 UI77189N/A    YABEND04E RC00E72068 AT DSNXSRME OFFSET01024 DUE TO A TIMING WINDOW WHEN USING INDEX FAST TRAVERSE BLOCK (FTB)
PH402732021-11-09 UI78000N/A     IMPROVE PERFORMANCE OF FTB STORAGE POOL ADMF INDEX MANAGER CL20
PH402742021-11-01 UI77882N/A     SQL0119N MIGHT BE ISSUED WHEN THE QUERY REFERENCES A VIEW AND THERE IS GROUP BY AND UNION ALL IN THE VIEW
PH402822021-09-21 UI77258N/A    YABEND04E RC00E2000C DUE TO STORAGE LEAK IN SUBPOOL ADMF AGL 64.
PH404322021-09-21 UI77254N/A     POOR PERFORMING QUERY WHEN AN INEFFICIENT JOIN ORDER IS CHOSEN FOR QUERY WITH FETCH FIRST N ROWS ONLY CLAUSE
PH404612021-11-02 UI77909N/A     ABEND04E RC00E70005 DSNXOSTP M210 CAN OCCUR ON A CREATE TRIGGER WHICH CONTAINS MORE THAN ONE CALL STATEMENT
PH405272021-10-26 UI77824N/A    YINCORRECT OUTPUT RETURNED BY A QUERY WHOSE ACCESS PATH IS BASED ON A DB2ZAI HOST VARIABLE MODEL
PH405392021-10-07 UI77500N/A     FTB DEADLOCK OCCURS WITH SYSTEM ITASK – CORRID=014.IFTOMK01
PH405432021-10-01 UI77407N/A     SLOW QUERY PERFORMANCE COULD OCCUR WHEN LIST PREFETCH IS CHOSEN
PH407062021-11-10 UI78014N/A     ABEND0C4-04 IN DSN3ID80 WITH PTF UI77010 APPLIED 21/09/17 PTF PECHANGE
PH409812021-12-14 UI78548N/A     ABEND0C4 AT DSNXRSOR OFFSET00136 FOR QUERY WITH VIRTUAL TABLE ACCESS ON TABLE EXPRESSION WITH CASE EXPRESSION
PH410552021-12-27 UI78742N/A    YSTORAGE LEAK WHILE RUNNING DRIVER PACKAGES WITH INCORRECT CLIENTAPPLCOMPAT SETTING
PH412052022-02-14 UI79308N/A     ABEND04E RC00E72068 AT DSNXSRME OFFSET0106E CAN OCCUR WHEN A TABLE EXPRESSION OR A VIEW CONTAINS UNIONALL
PH412122022-01-12 UI78897N/A    YINCORRECT OUTPUT MAY OCCUR FOR A QUERY USING XMLTABLE FUNCTION.
PH412162021-11-17 UI78137N/A     ABENDS0C4 RC04 PIC04 RC00000004 IN DSN3ID80
PH413072021-11-17 UI78136N/A     PERFORMANCE ISSUE WHEN THE JPP IS NOT ALLOWED FOR QUERY USING VIEW WITH UNION ALL INCLUDING A SMALL TABLE
PH413312021-12-08 UI78449N/A     ABEND0C4 RC11 DSNXOSL OFFSET074C8 ON A CREATE TRIGGER STATEMENT
PH413352021-12-04 UI78403N/A     ABEND04E 00C90101 AT DSNICMTC ERQUAL 5004
PH413502021-11-29 UI78295N/A    YINCORRECT OUTPUT MAY OCCUR WHEN IMPLICIT CAST IS PERFORMED FROM SMALL INT TO INT
PH414362022-01-24 UI78933N/A    YABEND04E RC00E70005 AT DSNXRFN:M509 MIGHT HAPPEN FOR A QUERY WITH A CORRELATED SUBQUERY CONTAINING FETCH FIRST N ROWS ONLY
PH414462021-12-22 UI78714N/A    YPOSTPONED ABORT ENTERED INTO AN INFINITE LOOP IN DSNB1CLM DUE TODB2 INTERNAL CONTROL BLOCK POINTING TO ITSELF
PH414482021-11-02 UI77914N/A     ABEND0C4 RC10 AT DSNXOCS OFFSET03770 WHEN RUNNING QUERIES WITH VIEWS OR TABLE EXPRESSIONS WITH JOIN RELATIONS
PH415352021-12-09 UI78457N/A    YHIGH ECSA USAGE AFTER DB2 ABNORMAL TERMINATION
PH415672021-11-23 UI78244N/A     DB2ZAI: A LONG RUNNING DB2ZAI DAEMON THREAD CANNOT BE PROPERLY HANDLED EVEN AFTER -STOP ML COMMAND
PH416272022-02-21 UI79152N/A    YDB2 SHOULD PROCESS DIFFERENT TIMESTAMP DIGITS WITH SAME LENGTH, BUT ACTUALLY NOT
PH416702021-12-14 UI78560N/A     ABEND04E RC00E70005 AT DSNXOSSF M909 WHEN A FNMEDIAN OR PERCENTILE_CONT/PERCENTILE_DISC IN A TABLE EXPRESSION IS NOT
PH417512021-12-01 UI78344N/A     DB2 12 FOR Z/OS NEW FUNCTION
PH417932022-05-26ModifiedUI80317N/A    YSQLCODE904 RC00C90084 TYPE100 FOR STATIC SQL STATMENT FROM A PACKAGE RUNNING WITH ISOLATION LEVEL RR
PH419432021-11-22 UI78223N/A    YINCORRECT OUTPUT MAY OCCUR FOR SUBSEQUENT QUERIES WITH A SINGLE UNION ALL AND DB2ZAI ENABLED
PH419522022-01-07 UI78851N/A     DB2 MAY CHOOSE DIRECT INDEX ACCESS OVER INDEX PLAN WITH SORT WITH LOWER COST
PH419782021-12-07 UI78424N/A     DISTRIBUTED CONNECTION CONTROL (DCC) PROCESSING OF IFCID0402 FORDB2ZAI DESIGN CHANGE TO PRODUCE DELTA VALUES
PH420462022-01-27 UI79100N/A     ABEND04E RC00C90101 AT DSNOTFLA ERQUAL5001 FOR QUERY WITH A COMBINATION OF XMLSERIALIZE AND ORDER BY
PH420812022-01-27 UI79099N/A    YAN UNEXPECTED SQLCODE406 RESULTS FROM USING THE MULTIPLY_ALT BUILT-IN FUNCTION WHEN USING BIGINT ARGUMENTS.
PH421982021-12-28 UI78765N/A     SQLCODE -805 MIGHT ISSUE FOR A DROPPED TRIGGER IN SMALL TIME WINDOW
PH424692022-01-24 UI79037N/A    YINCORROUT MAY HAPPEN WHEN THERE IS CORRELATED SUBQUERY WITH EXISTS OR NOT EXISTS WITH FFNR CLAUSE AND A HYBRID JOIN IS USED.
PH425172022-03-23 UI79856N/A    YINCORROUT MAY HAPPEN FOR QUERY USE HYBRID JOIN AND IOE INDEX
PH425722021-12-28 UI78763N/A     INEFFICIENT R-SCAN IS SELECTED FOR TABLES OF 3RD VIEW JOINED
PH425542022-01-04PE PH45702N/A    N/A    YDB2 V11 ABEND04E RC00E2000F ON DSNSVSFB OFFSET08C6 DURING DBET PROCESS.
PH425782022-02-14 UI79305N/A    YLATCH CONTENTION AFTER DB2 RESTART AND LPL RECOVERY HAS COMPLETED
PH425822022-02-01 UI79151N/A     ABEND04E RC00E72068 AT DSNXSMUA OFFSET017F0 MAY HAPPEN TO SQL STATEMENT THAT CONTAINS ORDER BY ON THE RESULT OF UNION ALL
PH429752022-01-27 UI79112N/A     SMF FIELD QISTFTBSIZE EXCEEDS ZPARM INDEX_MEMORY_CONTROL
PH429992022-03-09 UI79656N/A     ABEND04E RC00E70005 IN DSNXOSJT M110 MAY OCCUR FOR A QUERY WITH MULTIPLE OUTER JOINS WHEN STAR JOIN IS ENABLE
PH430832022-03-10 UI79673N/A     LOOP OCCURS IN DSNXOEXB DURING THE PREPARE OF A QUERY WHICH CONTAINS OUTER JOINS AND AN IN SUB-QUERY PREDICATE
PH433382022-02-14 UI79313N/A    YINCONSISTENT DATA AND VARIOUS ABENDS IN DSNIRNXT FOR PBR RPN TABLESPACE AFTER RECOVER USING AN INLINE COPY CREATED BY REORG.
PH434602022-07-11 UI81408UI81409YABEND04E RC000C90101 AT DSNGEPLC ERQUAL5064 MIGHT HAPPEN WHEN EXECUTING A PACKAGE IF REBIND IS OCCURRING AT THE SAME TIME
PH434952022-03-10 UI79683N/A     COMMIT LSN ENHANCEMENT IN V12 IS DISABLED.
PH435472022-02-17 UI79400N/A     INEFFICIENT ACCESS PLAN CAN BE PICKED FOR QUERIES WITH FETCH FIRST N ROWS ONLY / OPTIMIZE FOR N ROWS CLAUSE
PH435622022-02-22 UI79465N/A    YINCORROUT OR ABEND04E RC00C20305 MAY OCCUR FOR A PREDICATE COMPARING ROWIDS FROM DIFFERENT TABLES, DIRECT ROW ACCESS IS USE
PH435652022-02-14 UI79317N/A    YINCORROUT WITH FTB AND NON-UNIQUE INDEXES WITH GREATER THAN PREDICATE
PH435692022-03-04 UI79586N/A     ABEND04E RC00E70005 MIGHT HAPPEN AT DSNXOMB M020 FOR A QUERY WHEN HYBRID JOIN IS SELECTED
PH436632022-02-08 UI79219N/A    YDB2 THREAD ABEND ABND=0C1-00000001 from ssidDIST asid
PH437062022-05-27ModifiedUI80740N/A     IAG2 ABEND04E 00C90105 IN DSNIASFP ERQUAL 0CA4
PH437282022-02-22 UI79437N/A     WORKFILE ABEND04E RC00C90101 DSNISFW ERQUAL500B
PH437352022-03-10 UI79674N/A     AFTER ISSUING A DISPLAY STATISTICS COMMAND DISPLAY STATS(ITC) LIMIT(*), DB2 INVALIDLY ISSUES AN ABEND04E 00F9000C
PH437972022-02-22PE PH47264UI79458N/A    YABEND04E 00F31100 – Plus Early APAR PH41216
PH437982022-03-16 UI79767N/A     ACCESS PATH IS NOT REUSED ON REBIND PACKAGE WITH APREUSE FOR TABLES WHERE EXPANSION_REASON <> ‘ ‘ IN THE PLAN TABLE
PH438062022-03-24 UI79873N/A    YDB2 SUBSYSTEM ABNORMAL TERMINATION WITH RC00D94001 AFTER ABEND04E RC00E20028 DUE TO AN OVERLAY BY REORG REBALANCE
PH439492022-03-24 UI79862N/A    YDB2Z AI SQL OPTIMIZATION DASHBOARD DISPLAYS THE PACKAGE ERROR MESSAGE
PH440622022-02-24 UI79486N/A     ABEND04E RC00E70005 DSNXOV0:M101 MAY OCCUR FOR SQL THAT REFERENCES AN UDF THAT CONTAINS AN XMLSERIALIZE FUNCTION
PH440732022-03-08 UI79643N/A    YDB2 CRASHES WITH ABEND04E RC00E50079 DSNURMPG +386 AND 04F RC00E50054 AFTER RESTART(CURRENT) OF LOAD UTILITY
PH441092022-03-31 UI79969N/A    YALLEVIATE QUIESCING BEHAVIOR CHANGES DURING THE POPULATION OF NEW V12 SPACE LEVEL ATTRIBUTE FOR ALTER TABLESPACE PROCESSING
PH441192022-06-07ModifiedUI80920UI80921 SYSIBM.SYSTABLEPART LIMITKEY COLUMN HAS AN INCORRECT VALUE AFTERREORG ON A SUBSYSTEM WITH DECIMAL=COMMA IN THE DSNHDECP
PH441372022-03-14 UI79717N/A     SQLCODE904 WITH RC00D50001 AND RESOURCE 0000090A MIGHT OCCUR WHEN XMLCAST AND XMLQUERY OCCURS IN THE WHERE CLAUSE
PH441812022-04-01 UI79984N/A     ABEND04E RC00C90101 IN DSNICUBC ERQUAL5004
PH442112022-03-14 UI79710N/A    YQUERY PREDICATE PUSHDOWN INTO CTE SUBQUERY UNION LEG, FOR SUBQUERY WITH FFNR, MAY CAUSE INCORRECT OUTPUT
PH442312022-03-14 UI79718N/A     ABEND0C4 RC38 AT DSNXOYP1 OFFSET09BF6 issued for CREATE OR REPLACE PROCEDURE
PH442602022-05-17ModifiedUI80553N/A     ABEND0C4 RC04 AT DSNXOSEP OFFSET063C8 MAY OCCUR WHEN QUERY CONTAINS CTE OR TABLE EXPRESSIONS
PH442912022-07-20 UI81583UI81584YABENDS0C4 RC00000038 RC38 AT DSNIACCH+19B92 OR ABEND04E RC00C90101 AT DSNISRTI ERQUAL534C
PH443562022-03-22 UI79841N/A    YWORKFILE ABEND04E RC00C90101 IN DSNIWKFD ERQUAL5005 AND DB2 CRASH WITH MSGDSNV086E RC00F30801
PH443622022-06-13ModifiedUI80989N/A     ABEND 04E RC00E70005 AT DSNXOBM P030 WHEN QUERY HAS A CORRELATED PREDICATE THAT COULD BE USED AS A SPARSE INDEX KEY
PH44421  OPENOPEN DB2 12 FOR Z/OS NEW FUNCTION TO SUPPORT DB2Z AI
PH446182022-04-11 UI80090N/A    YABEND04E RC00E70005 DSNXESX4 P403 CAN OCCUR FOR AN OUTER JOIN QUERY REFERENCING A LOB COLUMN WITH A SHORT INLINE LOB LENGTH
PH446282022-04-11 UI80089N/A    YPRECONDITIONING APAR FOR A FUNCTION IMPROVEMENT OF IN-MEMORY RLFTABLE AUTO REFRESH IN DATA SHARING GROUP
PH446312022-06-06ModifiedUI80891N/A     ABEND0C4 RC00 AT DSNXRDEC OFFSET087F8 WHEN MIGRATING AN EXTERNALSQL PROCEDURE TO A NATIVE SQL PROCEDURE
PH447012022-04-01 UI79998N/A     ABEND04E RC00E70005 AT DSNXOGP ERQUALP666 MAY HAPPEN FOR THE QUERY WITH MORE THAN 1023 QUERY BLOCKS
PH448402022-06-21New & ClosedUI81105N/A     ABEND0C4-3B IN DSNWARDS OFFSET024F8 – See PH48139
PH449162022-07-27 UI81675UI81676 EDM STORAGE CAN GROW BEYOND VALUE OF EDMCSTMTC AND BEING NOT CONTRACTED
PH449282022-04-11 UI80091N/A    YINCORRECT OUTPUT CAN OCCUR WHEN AN EXPRESSION-BASED INDEX IS USED
PH449722022-06-02ModifiedUI80862N/A     MESSAGE DSNP007I RC00D70002 ISSUED FOR WORKFILE EXTEND FAILURE ON 32K WORKFILES
PH449832022-04-20 UI80092N/A     DB2Z AI SYSTEM ASSESSMENT PERIODICALLY INSERTS RECORDS INTO TABLES MORE FREQUENTLY THAN THE STATIME_MAIN SYSTEM PARAMETER
PH449992022-04-28ModifiedUI80349N/A    YINCORRECT RESULT SET COULD BE RETURNED WHEN USING JSON SQL
PH450852022-04-05 UI80027N/A     SQLCODE=-725 MIGHT BE RETURNED WHEN OFFLOADING A QUERY WHICH REFERENCES A VIEW WITH CTE HINT
PH451002022-06-01ModifiedUI80840N/A    YABEND04E 00C90101 AT DSNICUMW ERQUAL 5003
PH452002022-06-02ModifiedUI80859N/A    YDB2 ABEND04E 00E2000F IN DSNSVSFB OFFSET00A6A AND DB2 CRASH MSGDSNV086E REASON 00F30801
PH452622022-04-25 UI80308N/A    YABEND0C4 AND STORAGE OVERLAY AFTER WILD BRANCH IN DSN9SCN9 TO INVOKE THE FRR ROUTINE DURING DISPLAY DB COMMAND EXECUTION
PH45272  OPENOPEN USING QUERY ACCELERATION WITH PREPARE ATTRIBUTES CLAUSE ‘ CONCENTRATE STATEMENTS OFF ‘ MAY CAUSE PERFORMANCE IMPACT
PH45322 NewOPENOPEN ABEND04E RC00E2000C AT DSNSVBK OFFSET00A54 MAY HAPPEN WHEN THREAD HANDLES A LARGE NUMBER OF ALTER STATEMENTS.
PH453582022-05-20ModifiedN/A    UI80601YWHEN RUNNING SQL DATA INSIGHTS Z16 WITH ZAIU GET ABEND=U4039
PH453692022-06-15ModifiedUI81024N/A     PERFORMANCE ISSUE WHEN SPARSE INDEX WAS CHOSEN BUT IT SPILLS INTO PHYSICAL WORKFILE
PH454832022-05-12ModifiedUI80499N/A     ABEND04E 00E20018 AT DSNSLD4 DSNSTKGG OFFSET00F76
PH455812022-05-06ModifiedUI80442N/A    YABEND04E RC009C0101 AT DSNKINSL ERQUAL5033 DURING INSERT
PH456432022-05-11ModifiedUI80483N/A     SQL STATEMENT POOR PERFORMANCE DUE TO INEFFICIENT JOIN ORDER FOR SUBQUERY IF THERE ARE TWO TABLES JOIN ON UNIQUE KEY.
PH457022022-05-03ModifiedN/A    N/A    YDB2 V11 REAL STORAGE CREEPS AFTER APPLY APAR PH42554/PTF UI78803 22/04/14 PTF PECHANGE – PH45702 Db2 11
PH457482022-05-11ModifiedUI80481N/A    YAN INCORRECT RESULT CAN BE RETURNED FROM A QUERY WITH UNION ALL THAT INCLUDES AN ORDER BY CLAUSE WITH OFFSET SPECIFIED.
PH457902022-05-11ModifiedUI80484N/A     DB2 MAY MATERIALIZE A SIDE WAY REFERENCED TABLE EXPRESSION/VIEW, WHILE JPP CAN PROVIDE BETTER PERFORMANCE.
PH460282022-05-28ModifiedN/A    UI80758 DB2Z AI SYSTEM ASSESSMENT PERIODICALLY INSERTS RECORDS INTO TABLES MORE FREQUENTLY THAN THE STATIME_MAIN SYSTEM PARAMETER
PH460582022-07-05New & ClosedUI81303N/A    YCROSS LOADER (LOAD WITH INCURSOR) GETS ABENDS0C1 ABENDS0C6 PECHANGE 22/05/19 PTF
PH461652022-06-16ModifiedUI81044N/A    YABEND04E RC00E70005 AT DSNXEPP M180 CAN OCCUR IN IN A V12/V13 COEXISTENCE ENVIRONMENT.
PH462062022-06-09ModifiedUI80959UI80960YAUTOMATIC GRECP RECOVERY 014.ASUTOGREC HANG UP AFTER ABEND0C4 PIC38 IN DSNIFLAA DUE TO ZERO PAGE SET CONTROL BLOCK POINTER
PH462092022-06-06ModifiedN/A    UI80890 UNEXPECTED VALUE WHEN QUERY FROM THE PLAN TABLE
PH462122022-06-02ModifiedN/A    UI80863 ABEND04E RC00E70005 DSNXOV0:M101 MAY OCCUR FOR SQL THAT REFERENCES AN UDF THAT CONTAINS AN XMLSERIALIZE FUNCTION
PH462212022-07-19 N/A    UI81536YIN A DATA SHARING GROUP, RLF WAS STARTED UNEXPECTEDLY BY OTHER MEMBER’S NOTIFICATION WITH SCOPE LOCAL
PH462952022-06-17ModifiedN/A    UI81087YABEND04E RC00E70005 DSNXESX4 P403 CAN OCCUR FOR AN OUTER JOIN QUERY REFERENCING A LOB COLUMN WITH A SHORT INLINE LOB LENGTH
PH463122022-05-28ModifiedN/A    UI80761 SQL STATEMENT POOR PERFORMANCE DUE TO INEFFICIENT JOIN ORDER FOR SUBQUERY IF THERE ARE TWO TABLES JOIN ON UNIQUE KEY.
PH463132022-05-28ModifiedN/A    UI80762 DB2 MAY MATERIALIZE A SIDE WAY REFERENCED TABLE EXPRESSION/VIEW, WHILE JPP CAN PROVIDE BETTER PERFORMANCE.
PH463142022-06-03ModifiedN/A    UI80871YAN INCORRECT RESULT CAN BE RETURNED FROM A QUERY WITH UNION ALL THAT INCLUDES AN ORDER BY CLAUSE WITH OFFSET SPECIFIED.
PH463192022-06-29 N/A    UI81245 ABEND0C4 RC04 AT DSNXOSEP OFFSET063C8 MAY OCCUR WHEN QUERY CONTAINS CTE OR TABLE EXPRESSIONS
PH463232022-06-02ModifiedN/A    UI80849YABEND04E 00C90101 AT DSNICUMW ERQUAL 5003
PH463482022-06-03ModifiedN/A    UI80880YABEND0C4 AND STORAGE OVERLAY AFTER WILD BRANCH IN DSN9SCN9 TO INVOKE THE FRR ROUTINE DURING DISPLAY DB COMMAND EXECUTION
PH463492022-06-01ModifiedN/A    UI80818 ABEND04E 00E20018 AT DSNSLD4 DSNSTKGG OFFSET00F76
PH463682022-06-29 UI81246UI81247YAN INCORRECT RESULT CAN BE RETURNED FROM THE TIMESTAMPADD BUILT-IN FUNCTION IF THE INPUT TIME EXPRESSION HAS HOUR 24.
PH463762022-07-08 UI81376UI81377 ADDITIONAL GETPAGES WHEN A NON RESULT SET STORED PROCEDURE CALLSADDITIONAL PROGRAMS (PACKAGES) DURING EXECUTION.
PH464122022-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
PH464412022-06-07ModifiedN/A    UI80916 POOR QUERY PERFORMANCE FOR QUERY REFERENCING SPECIAL REGISTER SUCH AS CURRENT TIMESTAMP, WHEN NOT REOPT(ALWAYS) OR REOPT(ONCE)
PH464872022-07-19 N/A    UI81549 ACCESS PATH IS NOT REUSED ON REBIND PACKAGE WITH APREUSE FOR TABLES WHERE EXPANSION_REASON <> ‘ ‘ IN THE PLAN TABLE
PH465642022-05-31ModifiedUI80796N/A     DB2Z AI SYSTEM ASSESSMENT (SA) MISSING INFORMATION IN SOME TABLES THAT SUPPORT SA
PH46567 NewN/A    OPEN(Y)EDM POOL ABEND04E RC00C90101 IN DSNGERBK ERQUAL 5015
PH465702022-07-22ClosedN/A    UI81635 IAG2 ABEND04E 00C90105 IN DSNIASFP ERQUAL 0CA4
PH466032022-05-31ModifiedN/A    UI80807 DB2Z AI SYSTEM ASSESSMENT (SA) MISSING INFORMATION IN SOME TABLES THAT SUPPORT SA
PH466042022-05-31ModifiedN/A    UI80813 ABEND0C4 RC38 AT DSNXOYP1 OFFSET09BF6 issued for CREATE OR REPLACE PROCEDURE
PH466182022-06-24 N/A    UI81417 PERFORMANCE ISSUE WHEN SPARSE INDEX WAS CHOSEN BUT IT SPILLS INTO PHYSICAL WORKFILE
PH466192022-06-21ModifiedN/A    UI81106 MESSAGE DSNP007I RC00D70002 ISSUED FOR WORKFILE EXTEND FAILURE ON 32K WORKFILES
PH46655  OPENOPEN(Y)WLMHEALTH IS BEING IMPROPERLY SET TO 1
PH46767  OPENOPEN DROP INDEX LEAVES ORPHAN ROWS IN SYSIBM.SYSCOLDIST
PH468752022-06-29 N/A    UI81255YCROSS LOADER (LOAD WITH INCURSOR) GETS ABENDS0C1 ABENDS0C6
PH471002022-07-18 N/A    UI81528YDB2 ABEND04E 00E2000F IN DSNSVSFB OFFSET00A6A AND DB2 CRASH MSGDSNV086E REASON 00F30801
PH471412022-08-22ClosedUI82057UI82058 PERFORMANCE ISSUE CAN OCCUR DUE TO LACK OF JOIN PREDICATE PUSH DOWN
PH471532022-07-12 UI81425UI81426 POOR QUERY PERFORMANCE MAY OCCUR FOR A QUERY THAT CONTAINS OR PREDICATE REFERENCING MULTIPLE TABLES.
PH472302022-07-07 N/A    UI81355YSQLCODE904 RC00C90084 TYPE100 FOR STATIC SQL STATMENT FROM A PACKAGE RUNNING WITH ISOLATION LEVEL RR
PH472492022-08-19ClosedUI82028UI82029 (IAG2) ABEND04E RC00C90101 AT DSNIASFP ERQUAL5001
PH472642022-07-29New & ClosedUI81719UI81720 ABEND04E 00F31100 AFTER ASSOCIATE CALL 22/07/28 PTF PECHANGE
PH473542022-08-16ClosedUI81962UI81963 THE FILTER FACTOR FOR THE IN SUBQUERY PREDICATE MIGHT BE ESTIMATED TOO HIGH SO THE INEFFICIENT INDEX MIGHT BE PICKED UP.
PH47374 NewOPENOPEN(Y)ABEND04E RC00C90101 DSNOTFLA ERQUAL5021 FOR A QUERY THAT CONTAINS AN INLINE LOB AND THERE IS A WORK FILE INVOLVED
PH47397  OPENOPEN INSERT ABEND04E RC00C90101 DSNISFPI ERQUAL5001 USING IAG2
PH476442022-07-21New & ClosedUI81608UI81609 ABEND04E RC00E70005 MIGHT HAPPEN AT DSNNQTOP M679 FOR QUERY USING XMLTABLE
PH477062022-08-17New & ClosedUI81978UI81979 ABEND04E RC00E70005 ABEND HAPPENS ON A REBIND WITH A MERGE STATEMENT WITH AN INCLUDE COLUMN
PH47795 NewOPENOPEN ABEND04E 00C90101 AT DSNK1CNE ERQUAL 5005 DURING NORMAL DB2 PROCESSING (FTB)
PH479262022-08-05New & ClosedUI81840UI81841 SQLCODE510 MAY BE ISSUED FOR AN AMBIGUOUS CURSOR WITH A COMMON TABLE EXPRESSION CTE
PH48013 NewOPENOPEN(Y)EXCESSIVE DB2 STORAGE BEING ALLOCATED BY BUFFER MANAGER IN ADMF GLOBAL CL1 POOL. THIS IS FOUND IN CSA/ECSA CAUSES OUT_OF_CSA
PH480732022-08-24New & ClosedUI82094UI82095YWHEN UPDATE SET CLAUSE CONTAINS A SCQ WITH A MINUS SIGN, AN INCORROUT OR AN ABEND (ABEND0C4 AT DSNXGDT2 OFFSET00980) MAY
PH480782022-08-29New & ClosedUI82129UI82130 FTB SIZE EXCEEDS THE VALUE OF ZPARM INDEX_MEMORY_CONTROL
PH480852022-08-17New & ClosedUI81980UI81981 ABEND04E RC00E70005 IN DSNXRITV M106 CAN OCCUR FOR A TRIGGER
PH48099 NewOPENOPEN POOR QUERY PERFORMANCE MAY OCCUR FOR A QUERY THAT COULD TAKE ADVANTAGE OF REVERSE INDEX SCAN
PH48139 NewOPENOPEN(Y)DB2 ABEND0C4-3B IN DSNWARDS OFFSET 00C5C (Caused by PH44840 UI81105)
PH48149 NewOPENOPEN DIS STATS(ITC) DOES NOT CALCULATE INDEX TRAVERSE COUNT WHEN FTB FUNCTION IS DISABLED.
PH48384 NewOPENOPEN(Y)ABEND04E RC00C90101 IN DSNGEDM.DSNGEDYI:0000 CAN OCCUR WHEN RUNNING SQL WITH DYNAMIC PLAN STABILITY ENABLED
PH48493 NewOPENOPEN ABEND04E RC00E72018 AT DSNXSING P040 MIGHT HAPPEN FOR A QUERY SATISFYING SOME CONDITIONS
PH48602 NewOPENOPEN(Y)INCORRECT OUTPUT CAN OCCUR WHEN AN EXPRESSION-BASED INDEX IS USED

If you have any comments or wishes please feel free to contact me!

TTFN,

Roy Boxwell