APAR UPDATE August 22nd 2024

Quite a few HIPERs this month and a couple of IAG2 fixes.

HIPERs:

PH57644: DB2 ABNORMAL TERMINATION WITH RC00F70603 AFTER DSN7508I WAS ISSUED WITH RC08 AND RSN0C080887

PH60836: INCORROUT MAY HAPPEN FOR INSERT AND SELECT PROCESSING AFTER A MASS DELETE ON A DECLARED TEMPORARY TABLE WITH NOT LOGGED

PH61323: ABEND04E RC00C200D8 IN DSNB1SWS [Due to PGSTEAL(NONE) heavily used or very small buffer pool size]

PH62312: AI SIMILARITY AND CONDITIONAL BLOCK FETCH WILL NOT WORK PROPERLY.

PH62292: ABEND04E RC00C90101 AT DSNIREPR ERQUAL507E DURING SQL UPDATE 24/07/15 PTF PECHANGE [Due to APAR PE PH58258 – UI96554 / UI96555]

Interesting for RTS:

None.

RUNSTATS:

None.

Query performance:

None.

IAG2:

PH62078: INSERT ABENDS0C4 00000038 RC38 PIC38 IN DSNISRTI OFFSET0A694 [IAG2]

PH62108: IFCID IAG2 NEW FUNCTION

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:

APARCLOSEDSTATUSDb2 12Db2 13HIPERDescription
PH459162022‑06‑29 UI81253UI81254 COPYUPDATEDPAGES IS INCORRECT AFTER LOAD WITH INLINE COPY, INCREMENTAL COPY GETS SKIPPED, RECOVER REQUIRES LOG APPLY
PH470902022‑08‑08 UI81865UI81866 SYSIBM.SYSINDEXSPACESTATS(STATSLASTTIME) DOES NOT GET UPDATED FROM LOAD REPLACE WITH INLINE STATISTICS SPECIFIED.
PH511082023‑01‑04 UI83921UI83922YACCESS DATABASE() SPACE() MODE(STATS) COMMAND DOES NOT UPDATE LASTDATACHANGE ON THE PARTITION WHICH IS CLOSED BY 010.PM2PCP01
PH538372023‑06‑08UI92151UI92152 RIGHT AFTER START DB2 WITH ZPARM RETRY_STOPPED_OBJECTS YES, STOP DB(DSNDB01) SP(*) NEEDS LONG TIME TO COMPLETE.
PH547002023‑09‑07 UI93485UI93486REORG SHRLEVEL CHANGE OF DSNDB06.DBD01 LEAVES RESIDUAL RTS ROWS AND ORPHAN OBDS FOR THE MAPPING OBJECTS IN THE DBD
PH570122023-11-27UI94631UI94632THE NLEVELS COLUMN IN THE SYSIBM.SYSINDEXSPACESTATS CATALOG TABLE HAS A HIGH VALUE.
PH572812024-02-19N/AUI95739INCORRECT TOTALROWS IN SYSIBM.SYSTABLESPACESTATS AFTER LOAD PARTREPLACE USING STATISTIC SAMPLING
PH61976N/AOPENCATMAINT TIMEOUT WITH SYSTEM THREAD 014.RTSTST00 ON DYNAMIC SQL PLAN STABILITY CATALOG TABLESPACES

RUNSTATS APARs:

APARCLOSEDSTATUSDb2 12Db2 13HIPERDescription
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‑01PE PH54783N/AUI80817 INCORRECT VALUE OF CARDF IN SYSIBM.SYSCOLDIST WHEN RUNSTATS COLLECTS KEYCARD STATISTICS ON DPSI INDEX
PH467672022‑08‑31 UI82201UI82202 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‑02 UI82237UI82238 RUNSTATS AT PARTITION LEVEL GETS ABEND04E RC00E40213 WITH CAUSE 00C9004F
PH491192022‑11‑04 UI83135UI83136 COLCARDF IN SYSIBM.SYSCOLUMNS IS INCORRECT (RESET TO ZERO) AFTER A REORG AT PARTITION LEVEL USING INLINE STATISTICS
PH494102022‑11‑07 UI83157UI83158 ABEND04E RC00C90101 AT DSNIOW ERQUAL2002 DURING RUNSTATS SHRLEVEL CHANGE REGISTER NO
PH517502023‑05‑16 N/AUI91849 UTILITY HISTORY IS NOT COLLECTED WHEN A UTILITY TARGET IS AN INDEX AND THE INDEX CREATOR IS OMITTED.
PH517662023-03-29PE see PH56078 PH56389UI91174UI91175YEXCESS STORAGE CONSUMPTION BY THOUSANDS OF 022.WDFND THREADS
PH519012023‑02‑22 UI90670UI90671 RUNSTATS INVALIDATECACHE FUNCTION CAUSES ACCESSPATH PROBLEMS
PH519052023‑05‑11 UI91777UI91778 PCTROWCOMP SET BY RUNSTATS MIGHT BE INACCURATE
PH524392023‑05‑12 UI91785UI91786 TERM UTILITY COMMAND HANGS
PH536772023‑06‑08 UI92149UI92150 ABEND04E RC00C90205 DSNIOST2 ERQUAL504E ON A SELECT – Actually a parallel DELETE and RUNSTATS
PH541552023-12-28PE PH60632UI95076UI95077ICE046A RUNNING REORG WITH VERY MANY AND LARGE COLGROUPS IN A USE PROFILE FOR COLLECTING DISTRIBUTED STATS – ST01WKNN ISSUE
PH550762023‑07‑07 UI92645UI92646 RECURRING ROW WITH REASON=CONFLICT IN SYSIBM.SYSSTATFEEDBACK AFTER RUNSTATS
PH552052023-08-11UI93158UI93159YABEND0C4 RC38 AT DSNXECWA OFFSET0A636 DURING ABORT PROCESSING. SUBSYSTEM TERMINATED WITH ABEND04F RC00E50702
PH552962023‑07‑22UI92859UI92860 RUNSTATS UPDATE PROFILE MESSAGE MSGDSNU1360I DISPLAYED IN OUTPUT
PH559142023‑08‑16N/AUI93217 NEW FUNCTION (actually two RUNSTATS bugs!)
PH572132023-12-08UI94836UI94837REORG WITH INLINE STATISTICS GETS MSGDSNU622I WITH RC00C9004F WHEN UPDATING THE FREQUENCY IN SYSIBM.SYSCOLDIST
PH575162024-04-19UI96586UI96587PCTROWCOMP VALUE IS INCONSISTENT BETWEEN REORG WITH STATISTICS OPTION AND RUNSTATS
PH57537OPENOPENFTB ACTIVATED BUT NO INDEX WAS LOADED IN MEMORY
PH576222024-02-19N/AUI95740YREORG DISCARD WITH INLINE STATISTICS AND STATPGSAMP=SYSTEM DOES NOT UPDATE THE STATISTICS IN THE CATALOG TABLES CORRECTLY
PH578532024-01-29UI95460UI95461ABEND0C7 IN DSNUSAH2 +0C838 DURING REORG WITH INLINE STATISTICS AND HISTOGRAM PROCESSING
PH587682024-02-02UI95522UI95523RUNSTATS 04E 00C90101 ABEND DSNINXPG ERQUAL2003
PH593632024-05-09N/AUI96830V13R1M500 REORG OF DIRECTORY TABLESPACES DSNDB01.SYSLGRNX & DSNDB01.SPT01 MATERIALIZE 64GB TO 256GB COLLECTS INLINE STATS
PH599952024-05-08UI96814UI96815KEYSEQ 0 IN MESSAGE DSNU1351I DOES NOT CONSISTENT WITH VALUE IN SYSIBM.SYSKEYTARGETS.
PH606322024-05-14See PH54155UI96899UI96900YRUNSTATS OR REORG WITH INLINE STATISTICS TERMINATE with ABEND0C4 IN DSNUSAF 24/04/02 PTF PECHANGE
PH61253N/AOPENCOLCARDF IN SYSIBM.SYSCOLUMNS IS ZERO AFTER RUNSTATS INDEX ALL ON A PARTITIONED TABLESPACE WITH PARTITIONED INDEX

SQL PERFORMANCE and general HIPERs:

APARCLOSEDSTATUSDb2 12Db2 13HIPERDescription
PH11864  OPENOPEN SQL SELECT RETURNS INCORROUT AFTER TABLE WITH LOB COLUMNS IS UPDATED
PH26180  OPENOPEN CARTESIAN PRODUCT RESULTING FROM INCORRECT JOIN ORDER
PH315662022-01-12 UI78898N/A    YUSER RECEIVED AN UNEXPECTED ABEND04E RC00E70100 IN DSNXGRDS DSNXISB7 P110 ON AN INSERT STATEMENT
PH317752022-01-05 UI78823N/A    YA LINEAR INDEX WITH > 255 PIECES IS NOT RECOVERED BY RESTORE SYSTEM UTILITY
PH396312022-01-28 UI79120N/A    YABND0C4 RC10 IN DSNVXUL0 +00324 AFTER CANCEL THREAD
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
PH406672022-03-02PE PH46287UI79547N/A ENHANCEMENT TO DB2 STACK STORAGE HANDLING
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.
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
PH416272022-02-21 UI79152N/A    YDB2 SHOULD PROCESS DIFFERENT TIMESTAMP DIGITS WITH SAME LENGTH, BUT ACTUALLY NOT
PH417932022-05-26 UI80317N/A    YSQLCODE904 RC00C90084 TYPE100 FOR STATIC SQL STATMENT FROM A PACKAGE RUNNING WITH ISOLATION LEVEL RR
PH419522022-01-07 UI78851N/A     DB2 MAY CHOOSE DIRECT INDEX ACCESS OVER INDEX PLAN WITH SORT WITH LOWER COST
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.
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
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-27 UI80740N/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-07 UI80920UI80921 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-17 UI80553N/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-13 UI80989N/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 UI83257UI83258 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-06 UI80891N/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
PH448332022-12-08PE PH53318UI83589UI83590 NEW FUNCTION FOR LIMITING THE NUMBER OF UDF RUNNING CONCURRENTLY
PH448402022-06-21PE PH48139UI81105N/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-02 UI80862N/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-28 UI80349N/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-01 UI80840N/A    YABEND04E 00C90101 AT DSNICUMW ERQUAL 5003
PH452002022-06-02 UI80859N/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
PH452722022-10-03 UI82679UI82680 USING QUERY ACCELERATION WITH PREPARE ATTRIBUTES CLAUSE ‘ CONCENTRATE STATEMENTS OFF ‘ MAY CAUSE PERFORMANCE IMPACT
PH453222022-11-03 UI83120UI83130 ABEND04E RC00E2000C AT DSNSVBK OFFSET00A54 MAY HAPPEN WHEN THREAD HANDLES A LARGE NUMBER OF ALTER STATEMENTS.
PH453582022-05-20 N/A    UI80601YWHEN RUNNING SQL DATA INSIGHTS Z16 WITH ZAIU GET ABEND=U4039
PH453692022-06-15 UI81024N/A     PERFORMANCE ISSUE WHEN SPARSE INDEX WAS CHOSEN BUT IT SPILLS INTO PHYSICAL WORKFILE
PH454832022-05-12 UI80499N/A     ABEND04E 00E20018 AT DSNSLD4 DSNSTKGG OFFSET00F76
PH455812022-05-06 UI80442N/A    YABEND04E RC009C0101 AT DSNKINSL ERQUAL5033 DURING INSERT
PH456432022-05-11 UI80483N/A     SQL STATEMENT POOR PERFORMANCE DUE TO INEFFICIENT JOIN ORDER FOR SUBQUERY IF THERE ARE TWO TABLES JOIN ON UNIQUE KEY.
PH457022022-05-03 N/A    N/A    YDB2 V11 REAL STORAGE CREEPS AFTER APPLY APAR PH42554/PTF UI78803 22/04/14 PTF PECHANGE – PH45702 Db2 11
PH457482022-05-11 UI80481N/A    YAN INCORRECT RESULT CAN BE RETURNED FROM A QUERY WITH UNION ALL THAT INCLUDES AN ORDER BY CLAUSE WITH OFFSET SPECIFIED.
PH457902022-05-11 UI80484N/A     DB2 MAY MATERIALIZE A SIDE WAY REFERENCED TABLE EXPRESSION/VIEW, WHILE JPP CAN PROVIDE BETTER PERFORMANCE.
PH460282022-05-28 N/A    UI80758 DB2Z AI SYSTEM ASSESSMENT PERIODICALLY INSERTS RECORDS INTO TABLES MORE FREQUENTLY THAN THE STATIME_MAIN SYSTEM PARAMETER
PH460582022-07-05 UI81303N/A    YCROSS LOADER (LOAD WITH INCURSOR) GETS ABENDS0C1 ABENDS0C6 PECHANGE 22/05/19 PTF
PH460992022-09-07 UI82304UI82305YDB2 SYSTEM HUNG WITH A LATCH.
PH461552022-07-12UI81428N/AYSOME UNICODE CHARACTERS ARE NOT CONVERTED PROPERLY FROM A BINARY REPRESENTATION USING USER-DEFINED FUNCTION BSON2JSON.
PH461652022-06-16 UI81044N/A    YABEND04E RC00E70005 AT DSNXEPP M180 CAN OCCUR IN IN A V12/V13 COEXISTENCE ENVIRONMENT.
PH462062022-06-09 UI80959UI80960YAUTOMATIC GRECP RECOVERY 014.ASUTOGREC HANG UP AFTER ABEND0C4 PIC38 IN DSNIFLAA DUE TO ZERO PAGE SET CONTROL BLOCK POINTER
PH462092022-06-06 N/A    UI80890 UNEXPECTED VALUE WHEN QUERY FROM THE PLAN TABLE
PH462122022-06-02 N/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
PH462872022-06-01 UI80832N/AYABENDS0D3 00000013 OR VARIOUS ABENDS AFTER APPLYING PH40667/UI79547
PH462952022-06-17 N/A    UI81087YABEND04E RC00E70005 DSNXESX4 P403 CAN OCCUR FOR AN OUTER JOIN QUERY REFERENCING A LOB COLUMN WITH A SHORT INLINE LOB LENGTH
PH463122022-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.
PH463132022-05-28 N/A    UI80762 DB2 MAY MATERIALIZE A SIDE WAY REFERENCED TABLE EXPRESSION/VIEW, WHILE JPP CAN PROVIDE BETTER PERFORMANCE.
PH463142022-06-03 N/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-02 N/A    UI80849YABEND04E 00C90101 AT DSNICUMW ERQUAL 5003
PH463482022-06-03 N/A    UI80880YABEND0C4 AND STORAGE OVERLAY AFTER WILD BRANCH IN DSN9SCN9 TO INVOKE THE FRR ROUTINE DURING DISPLAY DB COMMAND EXECUTION
PH463492022-06-01 N/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-07 N/A    UI80916 POOR QUERY PERFORMANCE FOR QUERY REFERENCING SPECIAL REGISTER SUCH AS CURRENT TIMESTAMP, WHEN NOT REOPT(ALWAYS) OR REOPT(ONCE)
PH464462022-09-29 UI82645N/A PRE-CONDITIONING APAR FOR A NEW FUNCTION (PBR changes)
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-31 UI80796N/A     DB2Z AI SYSTEM ASSESSMENT (SA) MISSING INFORMATION IN SOME TABLES THAT SUPPORT SA
PH465672023-02-15 UI90541    UI90542YEDM POOL ABEND04E RC00C90101 IN DSNGERBK ERQUAL 5015
PH465682023-01-23 N/AUI90223 UNNECESSARY OVERFLOW RECORD IS CREATED FOR PAGE LEVEL LOCKING OBJECTS
PH465702022-07-22 N/A    UI81635 IAG2 ABEND04E 00C90105 IN DSNIASFP ERQUAL 0CA4
PH466032022-05-31 N/A    UI80807 DB2Z AI SYSTEM ASSESSMENT (SA) MISSING INFORMATION IN SOME TABLES THAT SUPPORT SA
PH466042022-05-31 N/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-21 N/A    UI81106 MESSAGE DSNP007I RC00D70002 ISSUED FOR WORKFILE EXTEND FAILURE ON 32K WORKFILES
PH46655 2022-09-17 UI82394UI82395YWLMHEALTH IS BEING IMPROPERLY SET TO 1
PH467672022-08-31 UI82201UI82202 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-22 UI82057UI82058 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-19 UI82028UI82029 (IAG2) ABEND04E RC00C90101 AT DSNIASFP ERQUAL5001
PH472642022-07-29 UI81719UI81720 ABEND04E 00F31100 AFTER ASSOCIATE CALL 22/07/28 PTF PECHANGE
PH473122022-11-08 UI83182UI83183 ABEND04E RC00E70005 AT DSNXOSR P020 FOR COMPLEX QUERY
PH473542022-08-16 UI81962UI81963 THE FILTER FACTOR FOR THE IN SUBQUERY PREDICATE MIGHT BE ESTIMATED TOO HIGH SO THE INEFFICIENT INDEX MIGHT BE PICKED UP.
PH473742022-08-08 UI81863UI81864YABEND04E RC00C90101 DSNOTFLA ERQUAL5021 FOR A QUERY THAT CONTAINS AN INLINE LOB AND THERE IS A WORK FILE INVOLVED
PH473972022-09-29 UI82646UI82647 INSERT ABEND04E RC00C90101 DSNISFPI ERQUAL5001 USING IAG2
PH475812022-08-18N/AUI82002DB2 13 FOR Z/OS NEW FUNCTION [Allow index access for MERGE statement]
PH476442022-07-21 UI81608UI81609 ABEND04E RC00E70005 MIGHT HAPPEN AT DSNNQTOP M679 FOR QUERY USING XMLTABLE
PH476862022-12-14 UI83753UI83754 DB2 ABEND04E RC00E20018 IN DSNSLD4.DSNSTKGG OFFSET00B98 OFFSET00BC2 (EXPLAIN of extremely large SQL)
PH477062022-08-17 UI81978UI81979 ABEND04E RC00E70005 ABEND HAPPENS ON A REBIND WITH A MERGE STATEMENT WITH AN INCLUDE COLUMN
PH477952023-01-04 UI83915UI83916YABEND04E 00C90101 AT DSNK1CNE ERQUAL 5005 DURING NORMAL DB2 PROCESSING (FTB)
PH479262022-08-05 UI81840UI81841 SQLCODE510 MAY BE ISSUED FOR AN AMBIGUOUS CURSOR WITH A COMMON TABLE EXPRESSION CTE
PH479522022-08-04PE PH48157UI81820UI81821YINCREASED DB2 DIST ADDRESS SPACE CPU USAGE MAY BE OBSERVED AFTER PH40244 / UI80196 22/07/15 PTF
PH48013 2022-08-18 UI81998UI81999YEXCESSIVE DB2 STORAGE BEING ALLOCATED BY BUFFER MANAGER IN ADMF GLOBAL CL1 POOL. THIS IS FOUND IN CSA/ECSA CAUSES OUT_OF_CSA
PH480732022-08-24 UI82094UI82095YWHEN UPDATE SET CLAUSE CONTAINS A SCQ WITH A MINUS SIGN, AN INCORROUT OR AN ABEND (ABEND0C4 AT DSNXGDT2 OFFSET00980) MAY
PH480782022-08-29 UI82129UI82130 FTB SIZE EXCEEDS THE VALUE OF ZPARM INDEX_MEMORY_CONTROL
PH480852022-08-17 UI81980UI81981 ABEND04E RC00E70005 IN DSNXRITV M106 CAN OCCUR FOR A TRIGGER
PH480992022-11-09 UI83218UI83219 POOR QUERY PERFORMANCE MAY OCCUR FOR A QUERY THAT COULD TAKE ADVANTAGE OF REVERSE INDEX SCAN
PH481392022-08-22PE PH49206UI82068UI82069YDB2 ABEND0C4-3B IN DSNWARDS OFFSET 00C5C (Caused by PH44840 UI81105)
PH481492022-09-07 UI82301UI82302 DIS STATS(ITC) DOES NOT CALCULATE INDEX TRAVERSE COUNT WHEN FTB FUNCTION IS DISABLED.
PH481572022-12-23 UI83859UI83860YREADS FOR IFCID 411 OR IFCID 412 RETURNING INCORRECT DATA 23/06/21 PTF PECHANGE
PH482612022-10-19 UI82887UI82888YINCORRECT OUT MAY OCCUR FOR A QUERY REFERENCING A VIEW OR CTE AND USING SET FUNCTION IN THE PREDICATE.
PH482892022-12-27 UI83868UI83869YDB2 CRASH WITH ABEND 00D10231
PH483842022-10-24 UI82993UI82994ABEND04E RC00C90101 IN DSNGEDM.DSNGEDYI:0000 CAN OCCUR WHEN RUNNING SQL WITH DYNAMIC PLAN STABILITY ENABLED
PH484932022-10-19 UI82898UI82899 ABEND04E RC00E72018 AT DSNXSING P040 MIGHT HAPPEN FOR A QUERY SATISFYING SOME CONDITIONS
PH486022022-09-06 N/AUI82284YINCORRECT OUTPUT CAN OCCUR WHEN AN EXPRESSION-BASED INDEX IS USED
PH487052022-12-12 UI83696UI83697YTABLE SCAN COULD MISS SOME RECORDS FOR HASH OBJECT DEFINED WITH PAGE LEVEL LOCKING
PH492062022-09-16 UI82437N/A DB2 ABEND0C4-00000004 IN DSNWARDS AT OFFSET 03846
PH493172022-11-11 N/AUI83270YSPRC VERSION INCORRECT
PH494422022-10-19 UI82901UI82902YSLOW DB2 SHUTDOWN DUE TO CHECKPOINT FOR WORKFILE
PH494792022-09-29  UI82640N/AYDSNT225I BIND ERROR FOR PACKAGE DEPLEVEL OPTION NOT SUPPORTED RECEIVED AT A V13R1M501 OR LOWER DB2 FOR Z/OS SERVER
PH495432022-10-27 UI83046UI83047 ABEND04E RC00E70005 DSNXOEXB M200 OR SQLCODE206 FOR UPDATE OF VIEW W/ INSTEAD OF TRIGGERS AND UPDATE STMT CONTAINS CORRSUBQ
PH496022022-12-06 UI83591UI83592 SPARSE INDEX MIGHT BE CHOSEN AND CAUSE PERFORMANCE REGRESSION BECAUSE OF COST ESTIMATED TOO HIGH WITH NO PENALTY.
PH496192022-11-18 UI83368UI83369YSELECT REPLACE BIF HAVING MORE THAN 4K SEARCH STRING CAUSES DSNOLIKE ABEND0C4 PIC38 DUE TO AN OVERLAY.
PH496742022-11-21 UI83388UI83389YINCORRECT OUTPUT MAY OCCUR WHEN AN EXPRESSION-BASED INDEX IS USED WITH BETWEEN CLAUSE.
PH497212022-10-21PE PH59411UI82954UI82955 SQL PROCEDURE, HAVING SIGNAL STATEMENT WITH XML TYPE VARIABLE REFERENCED IN MESSAGE_TEXT, GOT ABEND0C4 PIC4 AT DSNOGETD+028CE
PH497592022-11-23 UI83438UI83439 ACCESS PATH REGRESSION
PH497922022-12-07 UI83619UI83620 THE ABEND RC00E70005 IN DSNXGSFN MAY HAPPEN WHEN A SQL STATEMENT CONTAINS OUTER JOINS AND A CCSID CAST ON A FOR BIT DATA COLUMN.
PH498252023-04-10 UI91369UI91370 ORPHANED ROWS IN SYSIBM.SYSPACKDEP AFTER DROP VIEW
PH499012022-12-14 UI83755UI83756 ABEND04E RC00E70005 IN DSNXRFMG M110 MAY OCCUR FOR SQL MERGE STATEMENT
PH499292022-12-21 UI83841UI83842 A LESS EFFICIENT INDEX MAY BE SELECTED WHILE ANOTHER INDEX CAN PROVIDE BETTER FILTERING.
PH499722022-11-18 N/AUI83371 DB2 13 FOR Z/OS NEW FUNCTION (PARENT_PLANNO usage in PLAN_TABLE for VIEW or Table Expression)
PH501292023-01-05 UI83939UI83940YABND=04E-00D31010 DSNLILLM.DSNLCDG2:0001 OR DSNLCDG2:0005
PH501492022-12-13PE PH57473UI83724UI83725INSERT RECEIVED RC00C90101 DSNISGRT ERQUAL500A ERROR
PH502392022-12-23 UI83861UI83862 DISCOURAGE THE USE OF SPARSE INDEX WHEN INNER CTE OR VIEW SIZE IS BIG WITH THE HUGE ESTIMATED ROWS AMOUNT AND SMJ IS ELIGIBLE.
PH503672023-01-20 UI90201UI90202 DSNT286I FOR REBIND PACKAGE WITH APREUSE(WARN) EVEN THOUGH RESULTING ACCESS PATH IS THE SAME
PH503822022-11-30 N/AUI83522YABEND 0C4 IN DSNVEUS1 AT OFFSET E34
PH504102023-05-15 UI91799N/A DIAGNOSTIC APAR TO PRODUCE A DUMP WHEN MSGDSNI055I IS ISSUED INDICATING IAG2 HAS BEEN DISABLED.
PH504992022-12-01 UI83543UI83544YABEND 04E RC00C90101 DSNILKTO ERQUAL1002 (After restart from disk failure – Local fix Conditional Restart with FORWARD=NO)
PH505832023-01-06 UI83947UI83948 DEGRADED PERFORMANCE FOR SOME QUERIES WITH A RANGE PREDICATE WITH BIFS: YEAR, DATE, OR SUBSTR ON THE LEFT HAND SIDE
PH506242023-01-23 UI90224UI90225 DSNIDLDU:5016 ABEND DURING LOAD RESUME IN DB2 12.
PH506272022-12-12PE PH53176UI83688UI83689YABEND04E RC00C200D8 DSNB1SWS 22/11/02 PTF PECHANGE
PH507292023-01-09 UI83963UI86964 DB2 FOR Z/OS PROFILE (IFCID 402) STATISTICS ENHANCEMENT
PH507812023-02-13 UI90503UI90504YDB2 RECOVERY-LOOP WITH REPETITIVE ABEND0C4 RC10 AT DSNXRIHB OFFSET2D490 AT LEVEL UI65759
PH508822022-12-21 UI83844UI83845 ABEND04E RC00E70005 AT DSNXOIXP P030 COULD HAPPEN WHEN AN SQL STATEMENT CONTAINS A VIEW AND HUGE NUMBER OF PREDICATES
PH509592023-02-16 UI90575UI90576YSELECT ENTERED INTO A LOOP BETWEEN DSNKTRAV AND DSNKNXT2 IN FTB PROCESS (Non-unique support problem)
PH509732022-12-28 N/AUI83889 LOOP OCCURS IN DSNXOEXB DURING THE PREPARE OF A QUERY WHICH CONTAINS OUTER JOINS AND AN IN SUB-QUERY PREDICATE
PH509742022-12-27 N/AUI83883YABEND0C4 DSNURLOG+049D0 REORG TABLESPACE SHRLEVEL CHANGE DURING PBG TO PBR CONVERSION
PH509972022-12-28 UI83884UI83885 ABEND04E RC00E70005 AT DSNXGDT2 M205 FOR QUERY ON VIEW
PH510862023-04-06 UI91132UI91133YABND=04E with RC00E50053 or RC00E20042 leads to DB2 crash with RC00E50727.
PH510882023-04-07 UI91344UI91345 ABEND0C4 RC00000010 MAY HAPPEN IN DSNXRRID OFFSET007618 FOR A QUERY USING PREFETCH=’L’ ACCESS
PH511082023-01-04 UI83921UI83922YACCESS DATABASE() SPACE() MODE(STATS) COMMAND DOES NOT UPDATE LASTDATACHANGE ON THE PARTITION WHICH IS CLOSED BY 010.PM2PCP01
PH511812023-02-08 UI90445UI90446YSERVICEABILITY APAR TO TAKE DIAGNOSTIC DUMP TO PREVENT DUPLICATEQWE PUT ON CHAIN LEADING TO LOOP IN PROCESSING
PH512642023-01-30 UI90327UI90328 ABEND04E RC00C90101 AT DSNIBCTD ERQUAL5007 MAY OCCUR FOR EXPLAIN AN SQL STATEMENT
PH514042023-03-23 UI91051UI91052 ALTER TABLESPACE MOVE TABLE MAY INPROPERLY HANDLE 3-PART TABLE NAMES
PH514342024-03-08UI96016N/AABEND04E RC00C90101 IN DSNIRFNX ERQUAL5399 AFTER A REDIRECTED RECOVERY OF BASE + XML TABLES
PH515652023-02-13PE PH52893N/AUI90510 FTB NEW FUNCTION
PH517662023-03-29See PH56078UI91174UI91175YEXCESS STORAGE CONSUMPTION BY THOUSANDS OF 022.WDFND THREADS
PH518602023-01-31 UI90345UI90346 ABEND04E RC00E70005 IN DSNXOUWF P009 MAY OCCUR FOR A QUERY WITH A SCROLLABLE CURSOR AND OUTER JOIN
PH520512023‑02‑16 UI90584N/A QUERY USING LISTAGG FUNCTION MAY ISSUE SQLCODE ‑137 DESPITE THAT PROPER LENGTH WAS PROVIDED ON INPUT.
PH521122023‑04‑07 UI91333UI91334YABND0C4‑04 IN DSN3AMGP.DSN3AUCM AT +00AF4
PH521262023‑04‑07 UI91331UI91332YQUERY RECEIVES SQLCODE ‑312 FOR A MERGE STATEMENT WITH HOST VARIABLES WHEN BATCH NODE IS ENABLED WITH DB2JCC4 DRIVER
PH521472023‑03‑01 UI90806UI90807YSTORAGE OVERLAY ABEND04E RC00E2002F IN DSNSVSFM OFFSET00702 AND DB2 CRASH MSGDSNV086E RC00D96001
PH521552023‑03‑03 UI90770UI90771YINCORROUT MAY OCCUR FOR A QUERY USING OUTER JOIN
PH521802023‑05‑03 UI91674UI91675YABEND04E RC00E3007B DSNTGSCC DSNTABA
PH522732023‑03‑23 UI91053UI91054YABEND0C4 RC38 IN DSNXRINT OFFSET00904 IN ALTER TABLESPACE STMT OF MAXPARTITIONS TO CONVERT AN EMPTY DEFINE NO TABLESPACE TO PBG
PH522752023‑03‑14See PH54566UI90954UI90955YABEND0C4 RC38 IN DSN3EOT0 OFFSET0992
PH522792023‑02‑24 UI90721UI90722 SQLCODE418 MAY BE RETURNED FOR AN SQL STATEMENT THAT CONTAINS ANXMLTABLE JOINED WITH A VIEW OR TABLE EXPRESSION
PH523972023‑03‑13 UI90932UI90933 DB2 MAY ISSUE SQLCODE ‑204 OR ABEND04E RC00E70005 IN DSNXGRDS.DSNXOFL:M110 FOR TUDF CONTAINING COMMON TABLE
PH524422023‑04‑03 UI91102UI91103 ABEND04 RC00C90101 AT DSNIDEFS:5001
PH524552023‑04‑07 UI91348UI91349 INLIST PREDICATE PUSHDOWN INTO VIEW OR TABLE EXPRESSION MAY BE INCORRECTLY HANDLED CAUSING ABEND0C4 RC00000010 IN DSNXOPRS+03A58
PH525342023‑03‑24 UI91123UI91124 ABEND04E RC00E70005 AT DSNXGRTS:M902 MAY HAPPEN FOR QUERY WITH OFFSET AND UNION ALL WHEN USED IN CURSOR WITH INSENSITIVE SCROLL
PH526502023‑04‑07 UI91342UI91343 INCONSISTENCIES AND VARIOUS ABEND04E RC00C90101 RC00C90216 RC00C9021C DUE TO OVERLAY CAUSED BY MASS DELETE
PH526512023‑04‑14 UI91460UI91461YDDF ABNORMALLY TERMINATED WITH ABEND04E RC00D30014 IN DSNLMTOK:0001 DUE TO LUWID TOKENS BEING EXHAUSTED.
PH526532023‑04‑27 UI91589UI91590YPERFORMANCE DEGRADATION FOR FREE PACKAGE ‑ INCREASED I/O ON THE DB2 CATALOG (SYSIBM.SYSPACKAUTH) 23/04/18 PTF PECHANGE
PH527172023‑04‑07PE PH54823UI91352UI91353YINCORROUT FOR QUERY REFERENCING COLUMNS THAT HAVE COLUMN MASKS DEFINED AND ONE REFERENCES A GLOBAL VARIABLE
PH528082023‑03‑14 UI90958UI90959 MSGBPXF024I MESSAGES OCCUR IN DB2 WHEN ENABLING AND DISABLING MULTIPLE PACKAGES VERY QUICKLY IN SQL SCOPE SETTINGS FROM DB2ZAI
PH528212023‑05‑05 UI91713UI91714YTHREADS HUNG IN DSNB1LTS AND DSNB1LTX WAITING ON A PAGE LATCH
PH528932023‑03‑17 N/AUI91002 OBSOLETE FTB MSGDSNI070I MESSAGE DISPLAYED FOR V13 23/02/27 PTF PECHANGE
PH529152023‑04‑28 UI91610UI91611 ABEND0C4 RC04 AT DSNXRSOR OFFSET00136 FOR QUERY THAT INCLUDES OUTER JOIN AND INNER JOIN, SUBQUERY PREDICATE AND DISTINCT
PH529882023‑04‑12 UI91424UI91425 DB2 MAY CHOOSE AN INDEX WITH ONLY MATCHING PREDICATES INSTEAD OF A BETTER PERFORMING INDEX WITH MATCHING&SCREENING PREDICATES
PH530692023‑04‑14 N/AUI91462YABEND05E RC28 AND DB2 ABNORMAL TERMINATION RC00E50054 FOR SQL DATA INSIGHTS QUERY RUNNING FROM A DDF THREAD
PH530842023‑06‑07 UI92131UI92132 ABEND04E RC00C90101 IN DSNK1CNE 5005
PH531762023‑05‑16 UI91834UI91835YRC00C90206 DSNIIDIS ERQUAL5002 INDEX DATA INCONSISTENCIES ARE REPORTED DUE TO PAGE REGRESSION 23/03/12 PTF PECHANGE
PH532372023‑04‑13 UI91447UI91448 INEFFICIENT ACCESS PATH COULD BE CHOSEN FOR A SQL STATEMENT WITH CSWL ENABLED COMPARING TIMESTAMP(6) COLUMN WITH LITERAL VALUE.
PH533182023‑04‑12 UI91421UI91422 AFTER APPLYING PH44833/UI83589 SQLCODE904 WITH RC00E70082 MAY OCCUR DUE TO NOT DECREMENTING UDF INTERNAL COUNTER
PH53426 2023-08-01 UI92997UI92998 AFTER SPLITTING OF LAST PBR PARTITION (ALTER+ADD PARTITION), QUERY USING PARTITIONED INDEX ACCESS MIGHT NOT RETURN ALL ROWS.
PH53525 2023-08-31UI93410UI93411YABEND0C4 RC00000038 IN DSNGESLC OFFSET0226A WHEN A PLAN WAS CANCELLED IN A DATA SHARING ENVIRONMENT
PH535612023‑05‑01 UI91627UI91628 ABEND04E RC00E70005 AT DSNXEBR M666 COULD HAPPEN WHEN THERE ARE TWO CONDITIONS RAISED DURING THE OR PREDICATE (This is for XML)
PH535662023-07-26UI92909UI92910Db2 zAI 1.5 New Function
PH535722023‑04‑30 UI91621UI91622 ABEND04E RC00C90101 IN DSNIWIPR ERQUAL5064 RUNNIG A VERY COMPLEX QUERY
PH536002023-04-28UI91612UI91613BIND/REBIND WITH APREUSE MIGHT FAIL IF AP CONTAINS RANGE LIST INDEX SCAN WHICH CAN AVOID SORT
PH536212023‑05‑25 UI91977UI91978YINCORROUT MAY HAPPEN WHEN QUERY USES HINT WHERE QBLOCK_TYPE OF CHILD QUERY BLOCK IS NOT VALID FOR PARENT QUERY BLOCK
PH537172023‑04‑28 N/AUI91614YWORKFILE SORT ERROR MSGDSNT501I 0000006C 00000D02 DSNDB07
PH537472023‑05‑01 UI91629UI91630YABEND04E RC00C90101 DSNGEDFR:50FF, ABEND04E RC00E3000A AT DSNTFRCV OFFSETF92 AND ABEND0C4 RC38 AT DSNTFRCV OFFSETF76
PH537792023‑06‑26 UI92474UI92475 REBIND WITH OPTHINT CAN BE SUCCESSFUL EVEN THOUGH MULTI‑INDEX PLAN IS NOT THE SAME
PH538092023‑05‑16 UI91846UI91847 ABEND0C7 RC00 IN DSNXRDEC OFFSET08A4C MAY OCCUR WHILE RUNNING SQL SELECT WITH PARALLELISM
PH539162023-06-16See PH59407UI92301UI92302DB2CONNECT NON-JAVA APPLICATIONS CREATING A VAST AMOUNT OF CONNECTIONS.
PH539682023-09-20UI93657UI93658IMPROVE PERFORMANCE OF STORAGE POOL FOR RMID=BB1RMID
PH540092023-06-09IRLM UI92175YABEND04E RC00C90101 IN DSNICUMW 5003 AND DSNKNXT2 5004
PH540232023‑05‑17 N/AUI91868 FTB NEW FUNCTION
PH543702023‑06‑24 UI92432UI92433 ABEND04E RC00E70005 AT DSNXRFF M105 FOR AN ADVANCED TRIGGER WHEN SPECIAL REG CURRENT PACKAGE PATH IS SET ON TRIGGERING SQL
PH543972023-08-30UI93365UI93366LESS ROWS MIGHT BE RETURNED FOR FETCH FROM PARTITIONED TABLE WITH A DPSI INDEX WHEN THERE IS CROSS-PARTITION UPDATE.
PH544102023‑06‑28 UI92539UI92540 PREPARE THE SIMPLIFICATION OF DB2ZAI(DB2 AI FOR Z/OS)
PH544292023-08-08See PH57550 for Db2 12N/AUI93105ABEND04E RC00E2000F FOR DSNSVSFB OFFSET 009B8 MAY ISSUE FOR BIND/REBIND USING PLANMGMT WITH APREUSE
PH544392023‑06‑23 UI92428UI92429 ABEND04E RC00E70005 AT DSNXOBM P110 CAN HAPPEN WHEN QUERY CONTAINS AN OUTER JOIN AND A BETWEEN PREDICATE ON THE OUTER JOIN
PH545072023‑06‑09PE PH56254UI92181UI92182 SERIOUS PERFORMANCE DEGRADATION WHEN RUNNING DB2 QUERIES
PH545112023‑06‑23 UI92418UI92419 FOR TABLE WITH MANY INDEXES, INDEX PRUNING MAY GET RID OF GOOD INDEX AND DEGRADE PERFORMANCE.
PH545662023‑06‑28 UI92532UI92533YABEND0C4 RC04 IN DSN3ID50 OFFSET0568 23/05/18 PTF PECHANGE
PH546702023‑06‑22 UI92401UI92402YHYBRID JOIN MAY CAUSE INCORRECT OUTPUT OF LOB COLUMN
PH546952023-06-26UI92467UI92468ABND=04E-00D31010 LOC=DSNLILLM.DSNLCMSL:0002 DURING NEXT FETCH OF XML COLUMN USING PROGRESSIVE REFERENCES.
PH54701 2023‑08‑28UI93325UI93326 DB2XML.HTTPGETCLOB MAY RETURN SQLCODE ‑4302
PH54783 2023-09-11UI93531UI93532 REORG WITH STATISTICS INDEX OPTION MISSES STATISTCICS OF SOME KEY COLUMNS COMBINATIONS IN SYSCOLDIST
PH54823 2023‑08‑08 UI93101UI93102 ABEND04E RC00E70005 AT DSNXOV1 M600 WITH UI91352 (V12) OR UI91353 (V13) APPLIED
PH548632023‑07‑06PE PH59094N/AUI92616NEW FUNCTION
PH549012023-09-06UI93463UI93464YDURING RESTART LIGHT, DB2 ABENDS S04E RC00C20101 IN DSNB1ABS FOR A PGSTEAL(NONE) BUFFERPOOL.
PH55018 2023‑07‑21 UI92854UI92855 ABEND0C4 RC38 IN DSNXOSOB OFFSET020A0 COULD HAPPEN FOR AN SQL STMT THAT CONTAINS AN EXISTS SUBQUERY PREDICATE WITH UNION/UNION
PH550492023‑07‑13 UI92713UI92714 INCORRECT FTB DMCFTOM LATCH CLASS
PH55078 2023‑08‑30N/AUI93373 DIAGNOSTIC APAR TO ADD MORE IAG2 INFORMATION IN THE DIAGNOSTIC LOG RECORDS WHEN DSNI055I IS ISSUED.
PH551692023-07-07UI92463UI92644ABND=04E-00D35011 IN DSNLZLLM.DSNLZS00:003C DURING CALL OF A STORED PROCEDURE.
PH55205 2023‑08‑11 UI93158UI93159YABEND0C4 RC38 AT DSNXECWA OFFSET0A636 DURING ROLLBACK PROCESSING. SUBSYSTEM TERMINATED WITH ABEND04F RC00E50702
PH55215 2023‑08‑10 UI93125UI93126YINCORRECT OUTPUT MAY OCCUR FOR SQL STATEMENT REFERENCING A SET FN WITH A DECIMAL ARITHMETIC EXPR CONTAINING A PARAMETER MARKER
PH55255 2023-08-23UI93292N/A FTB NEW FUNCTION Add FTB Factor to DISPLAY STATS(ITC) output and IFCID 389
PH552942023-09-18UI93601UI93602YAFTER ROLLBACK OF ALTER INDEX PIECESIZE OF NPI, AN OBD FIELD MAY BE SET INCORRECTLY, CAUSING ERROR ON REPAIR DBD REPAIR/TEST
PH553792023-08-02 UI93027UI93028 ABEND04E RC00E70005 DSNXOTS P666 CAN HAPPEN WHEN PROCESSING SORTMERGE JOIN PREDICATES DIFFERENTLY WHEN JOIN PREDICATE PUSHDOWN
PH553852023-08-29UI93355UI93356YABEND04E RC00C200C6 DSNB5SCM OFFSET04EE0 AFTER CANCEL OF BIND JOB
PH55427 2023-10-13 UI94001UI94002 COUNT() WITH GROUP BY MIGHT RETURN INCORRECT RESULTS WHEN THE COUNT RESULT IS HUGE.
PH55479 2023‑07‑17 UI92754UI92755YSELECT GOT 00C90D01 ABEND AT DSNONLLE+035D4 AFTER REORG SHRLEVELCHANGE AND CONCURRENT INSERT COMPLETED.
PH554972023-08-10PE PH61121N/AUI93128Code to support future enhancement to automatic rebind
PH55498 2023‑07‑25 UI92906UI92907YABEND0C4‑4 IN MODULE DSNTLTIM AT OFFSET 00728 IN DB2 V13 FL503
PH556312023-08-04UI93057UI93058YThe SYSREC generated by REORG UNLOAD EXTERNAL misses the first one-byte data for the variable length NOT NULL column.
PH556392023-07-27UI92918UI92919YRESOURCE UNAVAILABLE ERROR SQLCODE904 WITH REASON 00000000 DURING INDEX SPLIT AND 00C20023 PAGE LATCH NOT GRANTED
PH558542023-09-08UI93498UI93499SQLCODE -20442 RECEIVED WHEN RUNNING A SELECT STATEMENT REFERENCING AN UNNEST FUNCTION
PH558862023-09-08UI93495UI93496YLOAD GENERATES INCORRECT TRAILING BLANKS FOR A UNICODE COLUMN IN EBCDIC TABLE.
PH559772023-09-04UI93428UI93429ABND=04E-00E20018 AT DSNSLD4 .DSNSTKGG+00DB0 [XMLQUERY bug]
PH560252023‑09‑01UI93415UI93416SQLCODE420 MAY OCCUR FOR A QUERY THAT HAS A PREDICATE COMPARING A DECFLOAT OR A FLOAT COLUMN WITH A DECIMAL VALUE.
PH560592023-08-28UI93329UI93330YHIGH NUMBER OF SPACEMAP GETPAGE REQUEST CAUSED BY INSERT INTO PBG MEMBER CLUSTER APPEND NO OBJECTS
PH560782023-08-17UI93229N/AYWITH UI91174 APPLIED FOR DB2 12, DB2 MAY TERMINATE WITH DSNV086E REASON=00E50702 23/08/16 PTF PECHANGE
PH560792023-09-13UI93544UI93545SELECT A VIEW WITH OPTHINT CREATED BY TEP2/3/SPUFI ISSUES ABEND 00E20027 AT DSNSVBK
PH560942023-08-15UI93211UI93211YIRLM: SERVICEABILITY APAR TO AID IN IDENTIFYING PLOCK MEMBER HOLDING LOCK
PH560952023‑08‑17See PH56179UI93228N/AYDB2 SERVICEABILITY APAR TO ASSIST IN DIAGNOSING BM PLOCK HANG
PH561182023-09-04N/AUI93430YUTILITY JOBS ABNORMALLY TERMINATED WITH 00E20004.
PH561502023-11-15UI94492UI94493ACCES PATH HAS PREFETCH=’O’ IN PLAN TABLE
PH561792023-08-31N/AUI93409YDB2 SERVICEABILITY APAR TO ASSIST IN DIAGNOSING BM PLOCK HANG
PH562542023‑09‑11UI93527UI93528INEFFICIENT ACCESS PATH MAY BE CHOSEN AFTER APPLICATION OF PTF FOR APAR PH54507. 23/08/08 PTF PECHANGE
PH562842023-10-10UI93967UI93968YTHREADS HUNG IN DSNB1LTS AND DSNB1LTX WAITING ON PAGE LATCH
PH563182023‑09‑18UI93607UI93608MESSAGE MSGDSNI055I REPORTS INVALID URID OF DISABLING AGENT
PH563282023-09-29UI93835UI93836REDUCE QEH SAMPLING ON AP LOCKED SQLS AND ADD VERIFICATION CHECKON HOSTVAR MODEL VALUES
PH563332024-02-01UI95514UI95515YLOAD PARALLEL OVERLAYS BUFFER CAUSING ABEND0C4 IN DSNSVSVB AND ABEND04E RC00E2000E IN DSNSVSFB
PH563472023-10-04UI93883UI93884YABEND04E RC00C90101 DSNIPSI:5002 CAUSED BY STORAGE OVERLAY FOLLOWING LOAD PARALLEL SHRLEVEL NONE AND BACKOUT
PH563662023-09-13UI93553UI93554YSERVICEABILITY IMPROVEMENTS FOR OVERLAY DETECTION.
PH563892023-09-01N/AUI93413YWITH UI91175 APPLIED FOR DB2 13, DB2 MAY TERMINATE WITH DSNV086E REASON=00E50702
PH564432024-04-18UI95741UI95742ABEND04E RC00C90101 DSNKINSL ERQUAL5033 OR DSNIOW ERQUAL5003 USING INSERT ALGORITHM 2 IAG2
PH565592023-09-21UI93665UI93683ABEND0C4 RC10 IN DSNXOPRS +114E8 CAN OCCUR ON BIND/PREPARE OF A QUERY WITH MULTI-COLUMN FREQ STATS ON NONMATCHING INDEX
PH566462023-10-13N/AUI94005ERROR MSG DSNX961I CAN OCCUR WHEN RUNNING SYSFUN.XSLTRANSFORM WITH IBM SEMERU JAVA 17
PH566532023-12-06UI94744UI94745INCORRECT OUTPUT AFTER REORG REBALANCE DUE TO PLAN STABILIZATIONQUERY NOT BEING INVALIDATED
PH567372023-10-25UI94172UI94173ABEND0C4 RC10 IN DSNXOTS1+04DA4 CAN OCCUR FOR A QUERY CONTAININGGROUP BY OR SET FUNCTION DISTINCT AND R-SCAN IS CHOSEN FOR TABLE
PH567422023-11-10UI94432UI94433UNEXPECTED ACCESS PATH FOR AN UPDATE STATEMENT ON VOLATILE TABLEWITH AN UNIQUE INDEX WHICH CAN MATCH ALL PREDICATES
PH567962023-10-18UI94075UI94076YINCORROUT OCCURS QUERY INVOLVING CORRELATED PREDICATE REFERENCING SET FUNCTION WITH ACCESSTYPE ‘O’
PH568712023-11-08UI94387UI94388ABEND04E RC00C90101 DSNIDM.DSNOCHLO:5006 MAY HAPPEN ON QUERY WITH ORDER BY AND XML COLUMN WITH XMLSERIALIZE TO LOB TYPE
PH569402023-10-25UI94170UI94171ABEND0C4 RC10 AT DSNXOD3 OFFSET04726 MAY OCCUR FOR THE QUERY USING SINGLE INDEX ACCESS
PH569452023-12-04PE PH61191UI94680UI94681ABEND0C4 RC0000003B RC3B IN DSNISFPI OFFSET010A2 REMOVING A PAGEFROM AN IAG2 PIPE THAT WAS DISABLED BY ANOTHER IAG2 THREAD
PH569782024-02-08UI95619UI95620YAN INCORROUT OR A DATA LOSS MAY HAPPEN WHEN A SAME SECTION IS REUSED TO EXECUTE IMMEDIATE A DIFFERENT STATEMENT.
PH570152023-12-15UI94968UI94969AN ABEND0C4 MAY HAPPEN IN DSNXGRDS.DSNXRFHJ+0045A WHEN AN INVALID UNSUPPORTED ACCESS PLAN WAS CHOSEN.
PH570192023-10-26UI94186UI94187DB2ZAI SQL OPTIMIZATION SELF-HEALING FOR DYNAMIC SQL COULD BE MISSED IN DATA SHARING ENVIRONMENT WHEN DSC INVALIDATION OCCURS
PH570262023-12-04PE PH59153UI94693UI94694YAN INTENTIONAL ABEND0C4 MAY HAPPEN FOR DSNXIAX2 P213 FOR AN INDEX WITH A LONG SCALAR EXPRESSION WHEN PROCESSING AN ALTER
PH570592023-12-14UI94931UI94932YAN INVALID COLUMN LENGTH MAY BE CALCULATED FOR A VIEW WITH RECURSIVE COMMON TABLE EXPRESSION AND STORED IN CATALOG.
PH570712023-10-19N/AUI94095CHANGE READING FTB SYSIBM.SYSINDEXCONTROL TABLE FROM 10 MINUTES TO EVERY 2 MINUTES
PH570842023-03-29UI96319UI96320YCATMAINT DOESN’T SET ADVISORY REORG PENDING FOR OBJECTS ALTERED
PH571752023-11-01UI94251UI94252ABEND0C4 RC00000010 IN DSNNORES OFFSET0A1A0 MAY OCCUR WHEN RUNNING AN SQL/PL STORED PROCEDURE
PH572542023-12-05See PH50239UI94710UI94711ACCESS PATH REGRESSION MAY HAPPEN FOR A QUERY WHICH GOT A BAD COST CALCULATED.
PH574182024-01-24UI95407UI95408YINCORRECT OUTPUT MAY OCCUR FOR SQL REFERENCING A SUM FUNCTION W/ARITHMETIC EXPRESSION & PARAMETER MARKER INSIDE TABLE-EXPR/VIEW
PH574232023-12-15UI94970UI94971INEFFICIENT AP FOR QUERY CONTAINS SARGABLE JOIN PREDICATE WITH COLUMN EXPRESSION AND JOIN PREDICATES COMPARING NUMERIC AND CHAR
PH574332023-11-10N/AUI94434YSYSAIDB.SYSAICOLUMNCONFIG.MAX_DATA_VALUE_LEN MAY BE INACCURATE, ABEND0C4 DSNSVBK+013EA OR DSNXOAIF+03146 FOR SQLDI QUERY
PH574732023-11-09See PH50149UI94409UI94410YBROKEN DATA PAGE CAUSED ABEND04E RC00C90101 AT DSNIBHRE ERQUAL0C33 WHEN RUNNING A COPY UTILITY. 23/10/13 PTF PECHANGE
PH575062023-12-11UI94852UI94853INCORROUT (TOO MANY ROWS RETURNED) AFTER ALTER TABLE ADD COLUMN OF DATA TYPE TIMESTAMP WITH DEFAULT
PH575372023-11-09UI94411UI94412FTB ACTIVATED BUT NO INDEX WAS LOADED IN MEMORY
PH575502023-11-02Retrofit PH54429UI94260N/AABEND04E RC00E2000F FOR DSNSVSFB OFFSET 009B8 WHICH CALLER IS DSNXOAF MAY ISSUE FOR BIND/REBIND USING PLANMGMT WITH APREUSE
PH575612023-11-16UI94519UI94520ABEND0C4 RC00000004 IN DSNLILLM.DSNLCMRL+006CC
PH575802023-11-10UI94428UI94429ABEND0C4 RC00000010 IN DSNXROJ1 OFFSET05618 MAY OCCUR DURING JOIN PROCESSING USING SPARSE INDEX
PH576442024-07-29New & ClosedUI97833UI97834YDB2 ABNORMAL TERMINATION WITH RC00F70603 AFTER DSN7508I WAS ISSUED WITH RC08 AND RSN0C080887
PH576642023-11-16N/AUI94517YPOOR PERFORMING APPLICATION THAT HAS A COMMIT OR ROLLBACK SQL STMT AND PRECOMPILED BEFORE V8 DUE TO UNNEEDED CCSID CONVERSION
PH577812023-12-19UI95002UI95003YINCREMENTAL COPY DETECTS BROKEN PAGE IN TABLESPACE BUT STILL INSERT AN ENTRY WITH ICTYPE=I TO SYSIBM.SYSCOPYS
PH577872024-01-12UI95216UI95217YEXCESSIVE DRAIN LOCKS WHEN USING IFI 306 READS CALLS REQUESTING DATA VERSIONING
PH57851OPENOPENABEND0C4 MAY HAPPEN AT DSNXOGP:0AB44 FOR QUERY WITH MULTI-INDEX ACCESS.
PH579192024-06-21UI97424UI97425YABEND04E RC00E510A1 IN DSNVSRX OFFSET3414 DB2 ABNORMAL TERMINATION RC00E50054
PH579562024-01-22UI95363UI95364INEFFICIENT ACCESS PATH COULD BE CHOSEN FOR AN SQL STATEMENT WITH ORDER BY
PH579712023-12-18UI94981UI94982ABEND04E RC00E70005 DSNXISTK OFFSET02004 OR ABEND04E RC00E7000A DSNXISUB OFFSET0CAA4 MAY OCCUR WHEN RUNNING DB2ZAI
PH580602024-03-28UI96316UI96317ABEND04E RC00E70005 DSNXEPM M450 FOR THE QUERY INVOLVING TRIGGER
PH580692023-12-15UI94954UI94955DB2 MAY CHOOSE AN INDEX WITH EQUAL MATCHING PREDICATES WHILE THE COLUMN IN THE PREDICATE HAS HIGH FREQUENCY.
PH581192023-12-07UI94795UI94796ABEND04E RC00E2000C DSNXOPPD DSNSVSVB OFFSET00A54 MAY OCCUR FOR COMPLEX QUERY WITH HUGE NUMBER OF OR CONDITIONS AND DIST CRASH
PH581352024-02-14UI95690UI95691YABEND0C4 RC04 IN DSNXEDC OFFSET001B4 MAY OCCUR FOR A QUERY WITH A TABLE EXPRESSION AND A SPATIAL INDEX
PH581372023-12-20See PH61191N/AUI95025DIAGNOSTIC APAR TO ADD MORE IAG2 INFORMATION IN THE DIAGNOSTIC LOG RECORDS WHEN DSNI055I IS ISSUED. 23/11/10 PTF PECHANGE
PH582142024-01-29UI95467UI95468A SQL CODE -4743 MAY BE INCORRECTLY ISSUED FOR ALTER VIEW REGENERATE WITH EXPLICIT APPLCOMPAT.
PH582582024-04-18PE PH62292UI96554UI96555YABEND04E RC00C90101 AT DSNIBHUN ERQUAL5013 DURING ROLLBACK OF GLOBAL TRANSACTION
PH582922024-01-31UI95504UI95505YRECOVER UTILITY FROM FLASHCOPY IMAGE COPY GETS ADR017E FROM DFDSS AND ENDS WITH RC08
PH583252024-03-05UI95962UI95963YINCORROUT MAY HAPPEN IF A QUERY CONTAINS A REDUNDANT PREDICATE ON AN AGGREGATE FUNCTION COLUMN OF A TABLE EXPRESSION
PH584032024-01-16N/AUI95239ABEND04E 00C90101 IN DSNISRTW 5064
PH584092024-03-01UI95900UI95901UNNECESSARY ENTRY IN SYSPACKDEP FOR INDEX ON EXPRESSION
PH584482024-03-05UI95951UI95952ABEND04E RC00E70005 AT DSNXISB2 P942 DURING INTERNAL BIND FOR ALTER PROCEDURE
PH584882024-02-09UI95627UI95628YDB2 IN HANG AFTER WLM DUMP
PH584912024-02-13UI95667UI95668QUERY WITH SELECT DISTINCT AND OPTIMIZE FOR 1 ROW/FETCH FIRST 1 ROW CLAUSE,DB2 MAY FAVOR ‘O’ ACCESS WHICH CAUSE POOR PERFORMANCE
PH586132024-02-16N/AUI95720ABEND04E RC00E70005 AT DSNXEFDA:M122 MAY ISSUE FOR QUERY REFERENCING BOTH VIEW AND BASE TABLE OF THE VIEW
PH58678OPENOPENDB2 12 AND DB2 13 FOR Z/OS NEW FUNCTION FOR XML
PH586832024-02-26UI95815UI95816INEFFICIENT INDEX MAY BE CHOSEN FOR AN SQL STATEMENT CONTAINING EQUAL AND RANGE PREDICATES
PH586862024-01-29UI95457UI95458YABEND04E 00C90101 AT DSNIBHUN 5020 , DSNIBHRE 5006 AND ABEND04E 00C90102 AT DSNIBHRE 0C26 DURING DR RESTART
PH587222024-04-11UI96494N/AEXTERNAL SQL STORED PROCEDURE SOMETIMES FAILS WITH SQLCODE = -20442 USING GLOBAL ARRAY VARIABLE.
PH587302024-06-17UI97365UI97366A SLOW ACCESS PATH COULD HAPPEN ON A LEFT OUTER JOIN QUERY CONTAINING AN after-join IS NULL predicate
PH588112024-02-11N/AUI95506YABENDS0C4 RC00000038 DURING REDIRECTED RECOVERY WITH ENHANCED SPACE LEVEL RECOVERY
PH588332024-02-29UI95884UI95885INCORRECT SYNTAX MAYBE INSERTED INTO SYSIBM.SYSTABLES_PROFILES
PH588432024-03-01UI95907UI95908AN ABEND04E FOR DSNXOGP:M833 MAY HAPPEN IF SQLCODE IS ISSUED INTERNALLY AND PUSHDOWN ACCESS PATH IS TO BE USED.
PH588472024-03-29UI96330UI96331DB2 ABEND04E RC00C90101 IN DSNIDLDU ERQUAL5016 (IAG2)
PH589502024-02-12UI95651UI95652INCORRECT DSNT286I MESSAGE MIGHT OCCUR FOR A TRIGGER PACKAGE CONTAINING SIMPLE WHEN CLAUSE
PH589842024-04-03UI96356UI96357AN INEFFICIENT ACCESS PATH MAY BE CHOSEN FOR A QUERY REFERRING TO TABLE DEFINED WITH VOLATILE KEYWORD.
PH590052024-05-07UI96797UI96798YAN INCORROUT MAY HAPPEN FOR QUERY WITH GROUP BY AND UNION ALL.
PH590302024-05-30PE PH61876UI97104UI97105AN ABEND04E FOR DSNXIALC:P068 MAY HAPPEN WHILE PROCESSING ALTER TABLE STATEMENT.
PH590842024-02-12N/AUI95650YINCORRECT MSGDSNU1316I DURING PIT RECOVER FOR LOB TABLE SPACE
PH59094See PH54863OPENOPENABEND04E RC00E2000C AT DSNXKBLM.DSNSVSVB OFFSET00A58 WITH PTF UI92616 APPLIED
PH591022024-03-22UI96208N/AAFTER IMPLICIT AUTO REGENERATE, A FUNCTIONS ASSOCIATED SYSPACKAGE.CREATOR FIELD MAY BE BLANK.
PH591532024-03-06UI95982UI95983A ++HOLD CORRECTION FOR APAR PH57026 PTFS UI94693 (FOR V12) AND UI94694 (FOR V13). 24/01/26 PTF PECHANGE
PH591922024-02-01UI95518UI95519YHIGH CSA CONSUMPTION BY DB2
PH592362024-05-08UI96819UI96820AN ABEND04E MAY HAPPEN FOR DSNXOMTX:M140 FOR A QUERY WITH A TABLE EXPRESSION HAVING GROUP BY AND HAVING CLAUSES.
PH593482024-03-08UI95948UI95949YLOOP IN CSECT DSN3ID30 WHILE AMGS LATCH IS HELD.
PH593812024-03-07UI95985UI95986YQUIESCE UTILITY WITH WRITE(YES) DOES NOT WRITE ALL UPDATED PAGESFROM GBP 24/01/25 PTF PECHANGE
PH593882024-04-03UI96375UI96376ABEND04E RC00C90101 IN DSNISRID 501E
PH594072024-02-28See PH53916UI95867UI95868YWITH UI92301 APPLIED, GET SQLCODE -204 DUE TO CURRENTSCHEMA NOT APPLIED.
PH594112024-03-18See PH49721UI96109UI96110A SQLCODE -104 MAY BE ISSUED WHEN CREATING A STORED PROCEDURE WITH A SIGNAL STATEMENT USING AN UDF. 24/02/06 PTF PECHANGE
PH59413N/AOPENAN UNNECESSARY SORT MAY BE PERFORMED FOR A QUERY USING AN UNION ALL CLAUSE.
PH594352024-04-08UI96404UI96405DB2 NATIVE REST MAY NOT CORRECTLY PROCESS JSON ESCAPED INPUT VALUES WHEN THERE ARE MORE THAN 49 INPUT PARAMETERS
PH594832024-03-05See PH61191UI95964UI95965IAG2 INSERT PROCESSING ABENDS0C4 00000004 PIC04 RC04 IN DSNISFPIOFFSET01598
PH595032024-03-01UI95904UI95905DB2 NATIVE REST PACKAGES CONTAINS STMTNO COLUMN VALUE 0 FOR ALL ROWS IN SYSIBM.SYSPACKSTMT
PH595412024-05-28UI97062UI97063ABND04E 00C90101 DSNOTCSO 5020 [Recursive CTE with LOB Column]
PH595482024-04-02PE OH61871UI96351UI96352ABEND04E RC00C90101 AT DSNIWNRF:502C WHEN PREDICATE CONTAINS MULTIPLE SUB-SELECT EMBEDDED INSIDE CASE EXPRESSION.
PH595812024-03-13N/AUI96074MAXSORT_IN_MEMORY NOT SET CORRECTLY
PH595912024-04-08UI96407UI96408YAN ABEND04E MAY HAPPEN FOR DSNXSZK:P035 FOR A QUERY USING PARALLELISM, INDEX ACCESS AND OUTER JOIN.
PH598132024-04-03N/AUI96374ABEND04E RC00E50007 IN DSNXRLPT AT LOCATION P220 MAY OCCUR
PH599202024-04-19UI96581UI96582AN ABEND0C4 MAY HAPPEN AT DSNXOCT+0155E FOR A STATEMENT USING UNION ALL OR UNION.
PH599392024-06-25UI97458UI97459AN UTILITY CALL CATMAINT UPDATE SCHEMA SWITCH MAY SWITCH THE SCHEMA FOR AN UDF RESULTING WITH CATALOG INCONSISTENCIES.
PH600512024-03-21UI96171UI96172ABEND0C4 RC38 AT DSNXRSGB OFFSET0127E FOR A QUERY WITH A SCALAR FULL/SUBSELECT WITH GROUP BY WITH AN IN PREDICATE
PH601552024-04-17UI96538UI96539AN ABEND0C4 MAY HAPPEN AT DSNXOQ2+03FA4 FOR A STATEMENT USING ROW_NUMBER ( ) OVER ( ORDER BY …) CLAUSE AND JOIN PREDICATE.
PH601612024-05-09UI96831UI96832AN ABEND0C4 MAY HAPPEN AT DSNXRCLS+0073C FOR A SIMPLE STATEMENT DURING CLEANUP AFTER IT WAS CANCELLED DURING SORT PROCESSING.
PH602552024-03-28N/AUI96301YLISTAGG ISSUE
PH604472024-05-21N/AUI96993YABEND05E RC28 CAN OCCUR FOR A SQL DATA INSIGHTS AI QUERY THAT CONTAINS AI BIFS, AND THE QUERY IS FROM DDF
PH60627OPENOPENINCORRECT OUTPUT RECEIVED AFTER LOAD INDEXDEFER ALL
PH603962024-04-19UI96584UI96585ABEND04E WITH RC00D31108 IN DSNLCCLO ABNDID0004 MAY OCCUR WHILE RUNNING SQL STATEMENT USING XML DATA
PH607252024-05-13UI96882UI96883ABEND0C4 RC38 IN DSNXOTS+18082 CAN OCCUR FOR A QUERY WHERE ONE OF THE TABLES HAS FULLY MATCHING EQUAL UNIQUE INLIST ACCESS
PH607412024-05-10UI96845UI96846YABEND04E RC00D10312 LOC=DSNJL002.DSNJR103+009B0
PH607582024-05-10UI96851UI96852YAN INCORROUT MAY HAPPEN FOR A QUERY USING SPARSE INDEX ACCESS PATH.
PH607762024-05-16UI96929UI96930PRESERVE THE INDEX PLAN FOR COST COMPETITION TO AVOID SORT PROCESSING OF AN OLAP FUNCTION
PH608362024-07-29ClosedUI97828UI97829YINCORROUT MAY HAPPEN FOR INSERT AND SELECT PROCESSING AFTER A MASS DELETE ON A DECLARED TEMPORARY TABLE WITH NOT LOGGED
PH608792024-07-11UI97627UI97628YABEND0C7 RC00000000 AT DSNXRRP OFFSET00E6E MAY OCCUR IN A QUERY CONTAINING A CEILING
PH60885OPENOPENA SQLCODE -670 MAY BE ISSUED DUE TO AN UNEXPECTED ACCESS PATH CHANGE.
PH609752024-05-16UI96950UI96951ABEND04E RC00E72048 IN DSNXSORI:P007 WHEN USING COLUMN MASK AS ARRAY_AGG SORT KEY, MORE THAN ONE EXPR IN THE ORDER BY CLAUSE
PH60984N/AOPENINCORROUT FOR DISPLAY BLOCKERS(DBNAME) DETAIL IF THE MESSAGE LIMIT EXCEED
PH610532024-06-26UI97485UI97486DB2 MAY SELECT AN INEFFICIENT SPARSE INDEX PLAN WHILE AN EQUAL UNIQUE INDEX PLAN CAN BE USED
PH611212024-05-23See PH55497N/AUI97035STORAGE LEAK WHEN CALLING A STORED PROCEDURE OR USER DEFINED FUNCTION 24/04/29 PTF PECHANGE
PH611912024-05-29See PH56945, PH58137, PH59483UI97072UI97073INSERT ALGORITHM 2 (IAG2) WAS NEVER RE-ENABLED AFTER IAG2 WAS DISABLED WITH MSGDSNI055I 24/05/02 PTF PECHANGE
PH612522024-06-04UI97166UI97167ABEND0C4 RC0000003B AT DSNXOSUD OFFSET003E4 MAY ISSUE WHEN REBIND QUERY WITH OPTHINT
PH613182024-08-14ClosedUI98024UI98025ABEND04E RC00C90101 IN DSNIZMOS AT ERQUAL5016 MAY OCCUR ON A WORKFILE TABLESPACE
PH613232024-07-25New & ClosedUI97794UI97795YABEND04E RC00C200D8 IN DSNB1SWS
PH61391See PH59388N/AOPENABEND04E RC00C90101 IN DSNIONXP 1001
PH616072024-07-19UI97703UI97704DB2 ABNORMAL TERMINATION REASON 00E50702 IN BM, CAUSED BY THE CALL TO FREE FTB STORAGE, AFTER THE START OF REORG UTILITY.
PH616332024-07-03UI97574UI97575YABEND04E RC00C90207 DSNIOW ERQUAL5003 24/06/19 PTF PECHANGE
PH618712024-07-11UI97581UI97582AN ABEND04E MAY HAPPEN FOR DSNXOFPD:P001 WHEN OUTER JOIN HAS AN AFTER-JOIN PREDICATE THAT IS A SUBQUERY.
PH618762024-07-11UI97625UI97626YABEND04E RC00E70005 DSNXIDDL.DSNXICDM:P032 FOR AN ALTER TABLE ALTER PARTITION LIMIT KEY 24/06/14 PTF PECHANGE
PH61908OPENOPENAN INEFFICIENT INDEX PLAN MAY BE CHOSEN WHEN THE INDICES ARE COMPETING.
PH620552024-08-16New & ClosedUI98054UI98055ABEND04E RC00C200C3 AT DSNB1REL OFFSET0255A OR RC00C200B0 AT DSNB1GNV OFFSET00C18
PH620782024-08-05ClosedN/AUI97915INSERT ABENDS0C4 00000038 RC38 PIC38 IN DSNISRTI OFFSET0A694 [IAG2]
PH621082024-08-12ClosedN/AUI97989IFCID IAG2 NEW FUNCTION
PH62120OPENOPENAN ABEND04E RC00E70005 FOR DSNXGDT2:M206 MAY HAPPEN WHEN USING AGGREGATED TIMESTAMP COLUMN IN RANK OLAP FUNCTION.
PH622462024-08-19ClosedUI98078UI98079ABEND0C4 RC04 AT DSNXRBND OFFSET0499C
PH622922024-08-08New & ClosedUI97955UI97956YABEND04E RC00C90101 AT DSNIREPR ERQUAL507E DURING SQL UPDATE 24/07/15 PTF PECHANGE
PH623122024-08-02New & ClosedN/AUI97910YAI SIMILARITY AND CONDITIONAL BLOCK FETCH WILL NOT WORK PROPERLY
PH62452NewOPENOPENABEND04E 00C90101 AT DSNKFTBU ERQUAL5061 WHEN OTHER DB2 MEMBER IS IN THE MIDDLE OF RESTART [FTB]
PH62521NewOPENOPENINCORROUT DUE TO ONE INDEX KEY IS NOT SET UP CORRECTLY WHEN MULTI-INDEX ACCESS IS USED ON TABLE.
PH62651NewN/AOPENSQL DI UNEXPECTED NULL RESULT FROM AI FUNCTION
PH62783NewOPENOPENABEND04E 00C90101 DSNIWKFD:5007 DSNICMT2:50FE

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

TTFN,

Roy Boxwell