IBM Support

Fix List for Db2 Version 11.5 for Linux, UNIX and Windows

Troubleshooting


Problem

Db2 11.5 APAR Fix list contains list of APARs shipped for each Mod Pack, Fix Pack in Db2 Version 11.5 for Linux, UNIX and Windows products. The Severity column value of 1 is high and 4 is low. Severity column represents the severity of the Case at the time the APAR was opened.

Resolving The Problem

************************************************************
Product Name : DB2 UDB Version 11.5
Updated : Oct 18, 2022
************************************************************

Select a Fix Pack: m8fp0 | m7fp0 | m6fp0 | m5fp1 | m5fp0 | m4fp0 | m3fp0 | m2fp0 | m3fp0


DB2 Version 11.5 Fix Pack m8fp0
Known Issue Sev. Abstract
Availability
DT147361 2 IT40335: HADR STANDBY IS SHUTDOWN DUE TO NOT FINDING A LOG FILE RETRIEVED FROM ARCHIVE
DT080075 2 IT34214: STOP HADR ON PRIMARY HANGS WHEN HADR IS IN DISCONNECTED_PEER STATE
DT147360 2 IT40290: DB2FMTLOG TOOL DISPLAYS INTERNAL ERROR WHEN FORMATTING A DB2 LOGFILE.
DT148050 2 IT37338: CPU_UTILIZATION CAN BE SHOWING MORE THAN 100%
DT147341 2 IT39286: TOO MANY LOG FILES IN ACTIVE PATH ON HADR STANDBY
DT147913 1 IT40007: CONFIGURING HADR FOR TLS ON WINDOWS PLATFORM USING MICROSOFT CERTIFICATE STORE FAILS WITH SQL1768N REASON CODE 28
DT148461 2 IT40356: A DROP ROLE STATEMENT MIGHT TRIGGER ERROR TRYING TO WRITE A LOG RECORD EXCEEDING MAXIMUM SIZE
DT148627 3 IT39175: FLUSH BUFFERPOOL IS NOT SUPPORTED ON STANDBY WITH LOG_DDL_STMTS=YES
DT127114 2 IT39973: Frequent activation/deactivation can cause file handle leak and increase in memory on db2 server
DT148449 2 IT40091: DB2CKBKP FAILS TO VALIDATE REMOTE BACKUP
DT147303 2 IT38144: FALSE LOW LOG DISK SPACE WARNINGS IN DB2DIAG.LOG AT DATABASE ACTIVATION
DT148667 2 IT40906: BACKUP USING LIBDB2NX842_ENCR.A MIGHT RETURN SQL2079N WITH RC=1
DT148475 2 IT40877: RETRIEVE LOG FILE FAILED WITH SQLP_LOG_NOT_IN_ARCHIVE ERROR DUE TO SEARCHING WITH WRONG LOGCHAINID IN LOG ARCHIVE
DT148672 2 IT40975: MISLEADING DB2DIAG.LOG MESSAGE WHEN USING ZLIB BASED BACKUP OR LOG FILE COMPRESSION
DT147327 2 IT38859: DB2MOVE COPY FAILS WITH "INVALID OBJECT TYPE SPECIFIED"
DT147532 2 IT39956: ABNORMAL TERMINATION OF DATABASE WITH "ERROR DURING LOG PAGE VALIDATION." FROM SQLPGWLP, PROBE:390.
DT148119 2 TOO MANY LOG FILES IN ACTIVE LOG PATH ON HADR STANDBY AND ALSM ENABLED
DT147905 2 IT39846: HADR LOG SHIPPING MIGHT BE STUCK AFTER DB2 UPDATE ACROSS 11.5.6
DT148611 2 IT38555: DEADLOCK BETWEEN MANUAL RUNSTATS AND AUTO REORG RECLAIM ISSUED BY AUTO MAINTENANCE
DT147681 2 IT38504: ONLINE BACKUP MAY FAIL WHILE PROCESSING TRANSACTION LOG FILE - BAD PAGELSO FOUND FOR LOG FILE
DT148427 2 IT39080: MINBUFFLSN DOES NOT UPDATE FOR A LONG PERIOD OF TIME DURING RECOVERY
DT148430 3 IT39320: STALE VALUE OF LOG_EXTRACTION_DISK_SPACE_USED_TOTAL WITH ADVANCED LOG SPACE MANAGEMENT ENABLED
DT147895 2 IT39287: HADR STANDBY MAY TAKE LONGER THAN NORMAL TO REACH PEER STATE ON ACTIVATION
DT147517 3 IT39359: Db2 hangs with many EDUs waiting on logTailHeartBeatLatch
DT147954 2 IT41265: HADR PRIMARY MIGHT CAUSE A TRAP WHEN PROCESS IS SLOW AND PEER WAIT LIMIT REACHED
DT148118 2 IT41121: GENERATING A REDIRECTED RESTORE SCRIPT MAY CRASH INSTANCE IF STORAGE GROUP FILES BECOME CORRUPTED
DT147757 2 IT41134: IN A DPF, MULTI-NODE ENVIRONMENT, A BACKUP TO PIPE WON'T TERMINATE (CTRL+C OR FORCE APP) UNTIL BOTH ENDS OF THE PIPE ARE IN USE
DT147372 2 IT40758: HANG ON FIRST CONNECT DRIVING CRASH RECOVERY WHEN DB2LOGMGR HANGS DUE TO VENDOR PROBLEM
DT148659 3 IT40544: DATABASE NOT SHUTDOWN WHEN LOAD REPLAY FAILS ON HADR STANDBY WITH DB2_FAIL_RECOVERY_ON_TABLESPACE_ERROR ENABLED
DT147546 2 IT40651: DB2LOGGX PROCESS CONSUMING HIGH CPU
DT147368 2 IT40585: ONLINE BACKUP INCLUDE LOGS MIGHT FAIL WITH ADM8010E
DT147543 2 IT40442: ON AIX GETMAXCOMPRESSEDSIZE MIGHT RETURN A TOO LOW VALUE
DT147733 2 IT40474: DB2 ZLIB BACKUP AND LOG FILE COMPRESSION DOES NOT USE HARDWARE ACCELERATION ON UBUNTU
DT140019 2 IT41420: TABLESPACE ROLLFORWARD IS VERY SLOW DUE TO EXCESSIVE NUMBER OF SQLBAFLSH() CALLS
DT147767 3 IT41547: INSTANCE CRASHED WHEN MULTIPLE CONNECTIONS IMPLICITLY ACTIVATE DATABASE WITH DIFFERENT CODEPAGE SETTING.
DT147768 2 IT41626: CRASH RECOVERY AFTER A DATABASE ROLLFORWARD TO POINT IN TIME THAT INCLUDES AN INDOUBT TRANSACTION FAILS WITH SQL1265 (ADM1532E)
DT147876 2 IT38402: DB2 IS FORCED SHUTDOWN WHEN IT ATTEMPTS TO PROCESS XAEND
DT148308 2 IT41729: TRANSACTION MAY NOT BE RESOLVED COMPLETELY IF A TABLESPACE IO ERROR IS ENCOUNTERED DURING RECOVERY WITH DB2_ONLINERECOVERY.
DT147772 2 IT41873: INCORRECT NUMBER OF LOG RECORDS COPIED FROM EXTRACTION LOG FILES
DT148312 2 IT41907: CRASH RECOVERY OF CIRCULAR LOGGING DATABASE FAILS WITH ADM1601E
DT145587 2 IT41639: EXCESSIVE DB2DIAG ENTRY FROM SQLPGRETRIEVELOOKUP
DT147703 2 IT39298: HADR STANDBY ENTERS AN INFINITE LOOP BETWEEN READ FROM MEMORY AND READ FROM DISK
DT142794 3 IT40564: DROP STORE PROCEDURE MIHGT CAUSE TRAP
DT148464 3 IT40526: HADR STANDBY FAILS WITH SQLRLC_FIND_LATCH_ANCHOR() PROBE:5 "INVALID ENTRY_TYPE" CALLED BY SQLPRDBREDOROSCATCACHEINV()
DT148300 2 IT41403: CRASH IN SQLPGETLOGTAILHEARTBEAT()
DT148111 2 IT41071: HADR STANDBY LOG REPLAY CANNOT KEEP UP WITH PRIMARY
DT148663 2 IT40735: DB2ICRT ?TBDEV COMMAND COULD OVERRIDE DISK SCSI-3 DISK CONFIGURATION
DT148494 2 IT41361: GBP DETACH MISSING IN CF PREVENT MEMBER FROM ACTIVATING A DATABASE LEADING TO FODC
Storage and Compression for Column-Organized Tables
DT147331 2 IT39064: FODC_Trap when printing mVariableBuffer during out-of-memory error
DT147557 2 IT41115: Query fails with SQL0901N and assertion failure "Evolved dictionary TSN cannot be larger than the last used TSN"
DT132779 2 IT40083: WRONG RESULT IS POSSIBLE IN COLUMNAR QUERY WITH REAL, FLOAT, OR DOUBLE COLUMNS AND RANGE PREDICATES WITH NEGATIVE VALUES
DT147723 2 IT40043: MEMORY LEAK IN COLUMNAR PAGE COMPRESSION CODE
DT148075 2 IT38961: HANG WAITING FOR LATCHES INSERTRANGE__MTABLEWRITERLATCH AND INSERTRANGE__MCONCURRENTINSERTLATCH
DT148505 2 IT41465: ADD ASSERTS TO PREVENT TRAP IN PAGEWRITECALLBACK METHODS
DT148500 2 IT41428: ADDITIONAL DIAGNOSTICS FOR SKILLS CASE TS009760113 (TRAP IN COLUMNDICTIONARYVERSIONBASE::GETSIZE)
DT148491 3 IT41301: ADD ASSERT TO RULE OUT POSSIBLE CAUSE OF APAR IT41275
DT134109 3 IT41211: A TRAP DUE TO A SIGNAL 11 CAN OCCUR IN THE MEMORY CLEAN UP DAEMON.
DT133462 2 IT40407: SQL0954C, SQL0973N, OR OTHER OUT OF MEMORY ERROR WHEN BUILDING COLUMN DICTIONARY FOR LONG STRING COLUMN
DT147732 2 IT40412: PERFORMANCE DEGRADATION IN MPP SETUP WITH SQLCODE: -391 ERRORS IN DB2DIAG.LOG AFTER TRUNCATE WITHOUT IMMEDIATE ON REPLICATED MQT
DT147958 2 IT41486: CONVERT TRAP IN DATABASETABLEACCESSOR::GETCOLUMNDICTIONARYVERSIONBASE TO SQL0901N MESSAGE
DT147765 2 IT41464: SEVERE ERROR AND POSSIBLE MEMORY CORRUPTION DETECTED WHEN FUNCTION SQLRKRPC_FREEMSG TRIES TO FREE MEMORY
DT147369 2 IT40685: LOAD RESETDICTIONARYONLY IS INCOMPATIBLE WITH BLOCKNONLOGGED
DT168621 2 Assertion failure "FreeExtentMarker::isValid(&page) && ( !page.getPageIsForInsertGroup() || FreeExtentMarker::isWithUncondPastRedoInit(&page))"
DT161029 2 INSERT fails with BAD PAGE error due to Reorg Recompress concurrency issue
Client
DT171380 2 IT40596: Driver throws ARRAYINDEXOUTOFBOUNDEXCEPTION in SQLJ heterogeneous batch environment
DT171402 2 IT41198: JCC DRIVER RETURNS -204 DUE TO IMPROPER SCHEMA ORDER REPLAY WHENUSING SYSPLEX WLB
DT143276 2 IT41270: ERRORCODE=-4474 RETURNED FROM JCC DRIVER FOR SET CURRENT PACKAGEPATH WHILE REUSING THE CONNECTION FROM THE POOL
DT143251 2 IT41578: IF XAER_RMFAIL RECEIVED WHILE READING A RESULTSET FROM APPLICATION THEN CONNECTIONEVENT LISTENER NEED TO RAISE XAER_RMFAIL EVENT
DT148122 2 IT41418: FEDERATION ZOS DB2 REPORT SQL0181N THE STRING REPRESENTATION OFA DATETIME VALUE ERROR WHEN QUERY WITH DATE AND TIMESTAMP COMPARED
DT160547 2 Setting QUERYPREFETCH=1 causes a segmentaion violation in DB2 ODBC and CLI driver
DT171400 2 IT38691: DECIMAL PRECISION DIFFERENCE IN JDBC WITH ORA & NON-ORA SETTING
DT171385 2 IT39194: INITIAL CONNECTION ERRORS LIKE -4499 ARE NOT COLLECTED IN DIAGNOSTIC DATA THROUGH DB2.JCC.DIAGLEVELEXCEPTIONCODE SETTING
DT171378 2 IT39628: JDBC ERROR "UNRECOGNIZED JDBC TYPE: 2011 ERRORCODE=-4228, SQLSTATE=NULL " WITH JDBC
DT171377 2 IT39269: NOSQLJSON SERIALIZER CRASHES WHEN NULL IS THE VALUE FOR JSON KEY
DT171415 2 IT39268: JSON WIRE LISTENER FAILS WHEN REGEX IS USED IN FIND COMMAND
DT133003 2 IT40903: MEMORY LEAK WHEN SQLGETCONNECTATTR() IS CALLED WITH THE SQL_ATTR_GET_LATEST_MEMBER ARGUMENT
DT171405 2 IT39267: NOSQL JAVA DRIVER THROWS RUNTIMEEXCEPTION FOR $SAMPLE IN AGGREGATE PIPELINE
DT171389 2 IT34348: .NET DRIVER CRASH DUE TO A TIMING HOLE
DT171394 2 IT39265: WIRE LISTENER FAILS TO ACCEPT NEW COMMAND POST EXCEPTION
DT171410 2 IT39266: WIRE LISTENER DO NOT HONOR THE LIMIT OPTION USED WITH FIND COMMAND
DT171401 2 IT39264: ROBO3T MONGODB TOOL THROWS ERROR POST UPDATE OR DELETE OF A JSONDOC IN A COLLECTION
DT171376 2 IT39058: CLPPLUS FAILS TO FLOW COMMIT FOR WARNING CASE SCENARIOS FROM STACOMMAND WHEN RUN AS A SCRIPT
DT171393 2 IT39263: NOSQLBOOSTER TOOL FAILS TO CONNECT TO WIRE LISTENER DUE TO MISSING SUPPORT FOR GETFREEMONITORINGSTATUS COMMAND
DT168593 1 IT40381: TRACEABILITY FOR LINE# AND FILE NAME IN DB2 .NET FOR FW AS WELL AS CORE RUNTIMES TO BE STAMPED IN MEM DIAGNOSTICS.
DT146491 1 IT36527: DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET
DT168594 3 IT41671: IN ODBC ADMINISTRATOR FIX SSL RELATED KEYWORD GUI OPTIONS AND FIX DBALIAS GETTING SAVED IN DB2CLI.INI FILE
DT141609 2 IT41590: INSERTING DECIMAL DATA VIA SQL_C_NUMERIC -> SQL_DECIMAL BIND-IN THROUGH ARRAY INSERT THROWS CLI0111E
DT127662 3 IT40458: RESULTSET.DELETE() METHOD RETURNS CLI0119E WITH SQLSTATE 58004
Catalog Services
DT148083 2 IT39321: SQL0818N CAN OCCUR AFTER A ROLLED BACK REVALIDATION
DT147165 2 IT35294: Authorization errors in accessing CGTTs after a transfer owner of a SQL routine.
DT148072 2 IT38739: MEMORY LEAKS OCCURRING ON COLUMN-ORGANIZED DGTTS
DT142487 2 IT40917: LATCH CONTENTION SQLO_LT_SQLRLC_ANCHOR_COMMON__ANCHOR_LATCH DURING SCHEMA AUTHORITIES CHECKS
DT148677 2 IT41440: DB2 MAY GENERATE FODC TRAP WHILE RUNNING A PROCEDURE
DT147538 3 IT40250: SQLRLC_EXECUTE_EVENT, PROBE:20 IS LOGGED AS ERROR
Connectivity
DT148492 2 IT41322: FIXING RCCOPENDUMMYCONNECTION TO USE SQLCC CALLS INSTEAD OF DRDATO ATTEMPT TO OPEN AN SSL CONNECTION WITH TARGET SERVER.
DT147729 2 IT40256: A PREVIOUS SETTING OF CURRENT PACKAGESET MAY BE REUSED WHEN EXECUTING FENCED STORED PROCEDURES WHEN KEEPFENCED IS SET TO YES RES
DT148254 2 IT39347: ERROR ADM7009E AFTER UPGRADING TO 11.5
DT147890 3 IT39092: UNCATALOG ODBC DOESN'T REMOVE ENTRY FROM DB2CLI.INI
DT117148 0 IT38866: INCORRECT LICENSE CHECK FOR INFORMIX DB WITH TRUSTED CONTEXT RELATED VERIFICATION
DT148442 2 IT39763: MORE ROBUST SIGNAL HANDLING ADDED TO COMMAND LINE OPERATIONS.
DT147520 1 IT39488: MULTI ROW FETCH IN DB2 11.5 LUW MAY NOT GIVE EXPECTED RESULTS
DT147556 2 IT41052: DB2 EXTERNAL TABLE CREATED WITH (SELECT.... LIMIT 0) FAILS WHILEINSERTING ROWS WHEN DB2_ENABLE_COS_SDK PARAMETER IS SET TO ON
DT147394 3 IT41518: LOAD FROM EXTERNAL TABLE FAILS AT 18,993 ROWS
DT148306 2 IT41623: REMOTE CLIENTS MAY NOT BE ABLE TO INTERRUPT QUERIES WITH SSL ONLY SERVER CONFIGURATIONS.
DT148124 2 IT41485: PACRALTSRVLST IS NOT NULL SPAMMING THE DB2DIAG.LOG
DT148682 2 IT41604: CLIENTS FAIL TO RECONNECT TO PURESCALE WITH TCP AND SSL SERVER CONFIGURATION
Connectivity - External Table
DT148470 2 IT40634: USE OF EXTERNAL TABLE WITH REMOTESOURCE OPTION AND LOAD CURSOR RESULTS IN A CRASH OF THE DATABASE
DT147901 2 IT39616: EXTERNAL TABLE FIXED FORMAT LOAD FAILURE OF REAL DATA
DT148235 3 IT38615: EXTERNAL TABLE FIXED FORMAT LOAD OF VARCHAR WITH REFERENCE COLUMN 0 FAILS
DT147699 2 IT39208: DB2WH IS INTERPRETING A 0X00 BYTE IN THE DATA AS SIGNALING EOF.
DT146617 3 IT36368: SELECT FROM EXTERNAL FILE FAILS WITH SQL0644N WHEN TABLE IS DEFINED IN A NON-DEFAULT TABLESPACE WITH A DIFFERENT DB PARTITION GR
DT147567 2 IT41475: OVERFLOW OCCURRED WHILE PERFORMING CONVERSION FROM CODEPAGE 923 TO CODEPAGE 1208 FOR COLUMN AT INDEX 44"
DT148796 1 Select from external table might hang when escaped field delim is present in data with LFINSTRING TRUE and CRINSTRING TRUE.
DT160131 2 IT42092: EXTERNAL TABLE LOAD WITH COS AND PARTITION (EXPLICITLY DEFINED PARTITION STRING) CAUSES HANG
DT147344 2 IT39487: EXTERNAL TABLE FIXED FORMAT LOAD OF [VAR]BINARY[N], BLOB[N] FAILING
Connectivity - Text Search
DT147761 2 IT41219: DB2 MAY TRAP AFTER SUCCESSFULLY UPDATING A TEXT SEARCH INDEX DUETO AN INCORRECT SQLCA
DT148490 3 IT41228: BAD PLAN CAUSED BY TEXT SEARCH CONTAINS() USING THE DEFAULT FILTER FACTOR
DT147942 2 IT40899: SQL0802 ARITHMETIC OVERFLOW ERROR OCCURS DURING TEXT SEARCH INDEX CREATION
Data Management
DT148669 2 IT40885: DEADLOCK BETWEEN TWO DROP TABLE STATEMENTS, EACH EXECUTING ABP'SDROPPED-OBJECT CANCELLATION.
DT148476 2 IT40894: DB2PD -LATCHES COMMAND WITH THE "GROUP" SUBOPTION MIGHT NOT REPORT LATCH HOLDERS CORRECTLY
DT147940 2 IT40872: NOT ALL IMAGE SEQUENCES UPLOADED TO REMOTE STORAGE DURING BACKUPWHEN USING SMALL MULTIPARTSIZEMB
DT148486 2 IT41162: SQLOSSIG, PROBE:10 DB2DIAG.LOG MESSAGE IS WRITTEN TO DB2DIAG.LOG REGARDLESS OF DIAGLEVEL SETTING
DT148110 2 IT40858: PURESCALE: Free space search during insert of a record might endprematurely.
DT148438 2 IT39703: BUFFER POOL EVENT RECORDER LEAKS MEMORY IF CRASH RECOVERY FAILS
DT148439 2 IT39719: DATA SERVER DRIVER LIBDB2.SO.1 MISSING SYMBOLS ON LINUX X86_64
DT148649 2 IT40061: BACKUP WITH DB2_RESOURCE_POLICY ENABLED MAY IMPACT SYSTEM PERFORMANCE MORE THAN WHEN DISABLED
DT172292 2 Running the LOAD command from 11.5.7 client to earlier-level11.5.x server (i.e. 11.5.0 to 11.5.6) fails
DT147902 2 IT39747: AVOID DB2 CRASH IF INSTANCE RUNS OUT OF FILE HANDLES.
DT148063 2 IT38384: DB2 ABENDS WHILE PAGE CLEANER EXECUTING SQLBCLNRGATHERFORHATETHRESH
DT148242 2 IT39050: BUFFER POOL PAGE PINCOUNT LEAKED DURING PAGE P-LOCK ACQUISITION
DT148269 2 IT40222: DB2 CRASH IN DB2PERF!SQLONTPPUTMSG
DT097587 2 IT36242: ADMIN_GET_MSGS() MAY RETURN MIX OF MESSAGE UNDER RARE TIMING HOLE.
DT148228 3 IT38409: NO WARNING MESSAGE WHEN DMS TABLESPACE CANNOT BE IMMEDIATELY EXTENDED WHILE AN ONLINE BACKUP IS IN PROGRESS
DT147661 1 IT37712: SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE UNDER CERTAIN CIRCUMSTANCES WITH LOAD UTILITY (CVE-2021-20373)
DT147924 2 IT40275: DB2 BACKUPS FAIL WITH SQL2025N AN I/O ERROR OCCURRED. ERROR CODE: "-2029059658" WHEN STREAMING IS ENABLED
DT148495 2 IT41384: DB2 ENTERPRISE SERVER (DB2ESE) COMPLIANCE REPORT SHOW INDEX COMPRESSION LICENSE VIOLATION ON V11.5.6 AND 11.5.7
DT147728 2 IT40226: HANG CAN OCCUR WITH INTRA_PARALLELISM ENABLED WHEN INDEX GETS CREATED
DT148236 2 IT38684: MEMBER CRASH RECOVERY MIGHT FAIL OR TABLE DATA COULD BE BAD IF CRASH OCCURS WHILE ONLINE TABLE REORGANIZATION IS RUNNING
DT147553 2 IT40806: TRUNCATING TABLE SPACE FILES (SQLSPCS.1/2) LARGER THAN 4GB MAY FAIL
DT148657 2 IT40520: SQLO_URL_UNKNOWN_HEADER RETURNED WHEN S3 BUCKET IS USING KMS ENCRYPTION
DT148123 2 IT41429: DB2_RESOURCE_POLICY DOESN'T WORK WITH DB2 ADVANCED EDITION
DT148292 2 IT41038: POSSIBLE DEADLATCH IN SQLOMEMINIT() WHEN IT LOADS CLIENT-SIDE LIBRARY
DT147925 2 IT40291: DB2PD -HELP RETURNS INCORRECT OPTION SYNTAX FOR -TCBSTATS
DT148654 2 IT40293: "GRANT DATAACCESS ON SCHEMA" PREVENTS LOAD WHEN MODIFIED BY "DUMPFILE DUMPFILEACCESSALL"
DT148472 2 IT40804: AUTO TABLE MAINTENANCE DB2ACD PROCESS FAILS TO CONNECT TO DATABASE WHEN DB2CLI.INI CONFIGURED TO ENFORCE TCP CONNECTIONS
DT171404 2 IT39128: CRASH WHILE CREATING ODBC DATA SOURCES FILE DSN ON WINDOWS PLATFORM USING DB2 ODBC CLI DRIVER
Data Management: Bufferpool
DT148474 2 IT40819: REORG NOT RECLAIMING EXTENTS FOR ITC TABLES EFFICIENTLY.
DT147918 2 IT40063: DGTT MAY FAIL WITH SQL0289N WHEN UNDERLYING TEMP TABLE SPACE DEFINED IN LARGE FILESYSTEM
DT147536 2 IT40191: BLOCK CREATING BUFFERPOOLS WITH THE SAME NAME AS THE SYSTEM BUFFERPOOLS
Data Movement Utilities
DT148078 3 IT39114: ADMIN_MOVE_TABLE ESTIMATE IS INCOMPATIBLE WITH BLOCKNONLOGGED
DT147321 3 IT38560: INGEST RESULT OUTPUT WRONGLY SHOWS "NUMBER OF ROWS INSERTED = 0"INSTEAD OF "NUMBER OF ROWS UPDATED / DELETED = <NUM>"
DT147688 2 IT38790: THE ADMIN_MOVE_TABLE PROCEDURE MAY STUCK IN CANCEL PHASE.
DT147533 2 IT39993: STRIPTNULLS MODIFIER IN LOAD AND IMPORT COMMANDS TRUNCATE NULLS (0X00) FROM GRAPHIC (FIXED-LENGTH) COLUMN, BUT IT SHOULD NOT
DT148238 2 IT38893: ADMIN_MOVE_TABLE WITH COPY_STATS MIGHT INVOKE LONG RUNNING RUNSTATS
DT147390 2 IT41348: DB2MOVE RETURNS SQL0206 WHEN EXECUTE INVALID STATEMENT SELECT OWNERTYPE FROM SYSIBM.SYSROUTINES
DT147929 2 IT40463: ADMIN_MOVE_TABLE RETURNS SQL20491N RC 6 FOR USER MAINTAINED TEMPORAL TABLES
DT147878 2 IT38519: ADMIN_MOVE_TABLE MIGHT FAIL IF TABLE HAS STATISTICS PROFILE CONTAINING COLUMN NAMES WITH SINGLE QUOTES
DT148279 2 IT40604: ADMIN_MOVE_TABLE COPY_STATS MIGHT FAIL IF SYSSTAT.COLDIST CONTAINS NON-PRINTABLE CHARACTERS
Deployment
DT054546 4 IT31631: CREATE .PROFILE IF IT DOESN'T EXIST WHEN RUNNING DB2ICRT (CREATEINSTANCE)
DT148048 4 IT37187: ADD REQUIRED GPFS PACKAGE NET-TOOLS RPM TO DB2PREREQCHECK
DT148466 4 IT40553: DB2IUPDT -CHECK_COMMIT COMMAND DOES NOT RETURN MEANINGFUL ERROR
DT147224 4 IT28668: THE COMPONENTLIST_SERVER_T.HTM FILE AND DB2LS -Q COMMAND OUTPUT ARE INCONSISTENT
DT147713 4 IT39760: ON AIX WHEN A SCRIPT NEEDS TO EXECUTE DB2PROFILE IN A LOOP, LIBPATH HAS MULTIPLE REFERENCES TO GSKIT
DT148272 4 IT40294: WHEN RUN DB2SETUP OR DB2ICRT ON AIX, THE OUTPUT MAY BE CORRUPTED.
DT072515 2 IT33388: V11.5 DB2IUPGRADE DOES NOT CHANGE SUB DIRECTORIES' PERMISSION UNDER SQLLIB PROPERLY
DT147824 4 IT32790: DB2_DEINSTALL NON-PURESCALE COPY OF DB2 CHANGES CONFIGURATION OFGPFS USER MANAGED CLUSTER
DT146371 2 IT37290: IN-PLACE INSTALLFIXPACK MINOR ERROR WITH DAS
DT147529 2 IT39904: DB2PD -STACK ALL IS NOT WORKING ON WINDOWS
DT148433 1 IT39389: SECURITY: APACHE LOG4J REMOTE CODE EXECUTION - LOG4SHELL (CVE-2021-44228, CVE-2021-4104)
DT147343 2 IT39404: CLIENT CONNECTIONS SLOW TO DATABASE SERVER
DT147275 3 IT36769: DB2FMCD.SERVICES GETS DELETED IF THERE ARE TWO DB2 SETUPS AND ONE GETS REMOVED
DT159579 1 IT31637: SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204)
DT147135 3 IT34243: DB2CLUSTER -CFS -COMMIT FAILS, INSTALL SHOULD GENERATE A WARNING
DT148303 2 IT41487: INSTALLFIXPACK DELETES /ETC/SYSTEMD/SYSTEM/DB2FMCD.SERVICE FILE ON LINUX
DT148092 4 IT39766: DB2PREREQCHECK WITH THE -HL OPTION FAILS IF THE CONTENTS OF THE HOSTS FILE ARE NOT CORRECT
DT147900 3 IT39752: DB2ICRT & DB2IUPDT MAKE USE OF THE /DB2LOG DIRECTORY AND MAY OVERWRITE IT
Federation
DT148451 2 IT40161: REMOTE STATEMENT HAS WRONG ORDER BY COLUMN SINCE V11.1
DT147948 2 IT41139: DB2 FEDERATION RETURNS BLANK SQLSTATE FOR SQLCODE=100 THAT WILL CAUSE WRONG ERROR MESSAGE OF NICKNAME IUD
DT148673 2 IT41019: FEDERATION: POSSIBLE -430 ERROR WHEN CONNECTING MYSQL-CE VIA JDBC CONNECTIONWITH JRE VERSION 1.8.0 BUILD 8.0.7.5 (SR7 FP5)
DT147730 2 IT40261: FEDERATION: COLUMN LENGTH AUTO VARIATION (COLUMN_LENGTH_AUTO_VARIATION) CANNOT BE DISABLED WHEN TARGET DATABASE IS ORCALE
DT147927 2 IT40384: FEDERATION: ORACLE DATA SOURCE, CREATE NICKNAME TOO MANY TIMES MIGHT CAUSE "ORA-01000: MAXIMUM OPEN CURSORS EXCEEDED" ERROR
DT148105 2 IT40372: FEDERATION FAILED TO GET ZOS DB2 COBOL PROCEDURE PARAMETERS
DT147523 2 IT39544: GRAPHIC AND CHARACTER CONVERTS WRONG WHEN CODEPAGES OF FEDEDERATION DB AND REMOTE DB ARE DIFFERENT
DT147897 4 IT39474: SECURITY: Multiple vulnerabilities in Apache Log4j affect some features of IBM Db2 (CVE-2021-45046, CVE-2021-45105)
DT147563 2 IT41289: MEMORY LEAK IN SQLQG_MISC_FMP.C WHILE IMPORT DATA INTO NICKNAME WHEN WRAPPER OPTION "DB2_FENCED' TO 'Y'
DT147330 2 IT39055: FEDERATION CREATE SERVER TYPE OPTIMIZATION FOR ODBC WRAPPER
DT148679 2 IT41542: FEDERATION SQL0802N ARITHMETIC OVERFLOW OR OTHER ARITHMETIC EXCEPTION OCCURRED
DT148307 1 IT41637: IN DPF ENVIRONMENT, FEDERATION FMP COULD BE INTERPRETED BY OTHERINTERRUPT REQUEST FROM DB2 ENGINE.
DT148305 2 IT41617: DB2 NICKNAME CREATION FOR TABLE OR VIEW IN REMOTE AWS ATHENA FAILS WITH SQL1822N AFTER UPGRADING JAVA IN AIX
DT147392 2 IT41496: FEDERATION MSSQL SERVER SQL0142N THE SQL STATEMENT IS NOT SUPPORTED
DT148299 2 IT41331: CLI0125E FUNCTION SEQUENCE ERROR DUE TO DRDA_STATEMENT NOT OPEN
DT148087 2 IT39471: DB2V115_START.KSH: FAILS TO FIND SERVICE PORT ON NON-ENGLISH LOCALE
DT148502 2 IT41644: SQL1822 ON FEDERATION SERVER BETWEEN UTF8 AND ISO-1 DATABASE WHEN THE SERVER OPTION IS STRING_UNITS 'S'
Process Model
DT147938 2 IT40749: ONLINE BACKUP MAY FAIL WITH SQL5193N IF DATABASE IS CREATED IN RESTRICTIVE MODE
DT148671 2 IT40926: DB2EVMONFMT MAY FAIL WITH SQLCODE=-104 WHEN USING THE -WTT OPTION
DT147384 2 IT41130: INSTANCE CRASH IN SQLMON_STMT::ESTIM_STMT_INFO_SZ
DT147731 2 IT40287: THRESHOLD DOES NOT FIRE WHEN CONCUR_OVERFLOW_ENABLED AND CONCUR_OVERFLOW_MAX ENABLED
DT148460 2 IT40343: DB2 CRASHES IN SQLECHECKBREATHINGPOINTWLMTHRESHOLD DURING SET WRITE RESUME
DT147911 3 IT39981: LIST ACTIVE DATABASE SHOWED DB NAME , EVEN IF DATABASE WAS DEACTIVATED
DT147483 2 IT37396: IN DPF SQL USING EARLY CLOSE MAY INCREASE FCM BUFFERS UNTIL APPLICATION TERMINATION
DT147921 2 IT40154: THE MON_GET_PKG_CACHE_STMT TABLE FUNCTION MAY TRAP WHEN AN SQL STATEMENT HAS COMMENTS > 10K AND STMT_CONC IS SET TO COMM_LIT
DT147917 2 IT40049: THE MAXIMUM NUMBER OF FCM SESSIONS IS NOT SET PROPERLY ON AIX
DT147357 2 IT40122: "FODC PANIC DUE TO STALE POINTER IN SQLEUCBLASTDIAGPOOL"
DT147909 2 IT39957: APPLICATION MAY HANG IN GETFASTWRITERRECORD IF THE INTERNAL POOLFOR EVENT MONITORING IS EXHAUSTED.
DT147907 2 IT39938: POSSIBLE MEMORY CORRUPTION WHEN CALLING PD_GET_DIAG_HIST
DT148635 2 IT39473: ARCHIVING DB2DIAG.LOG AND NOTIFICATION LOG (*.NFY) CAN LEAD TO DOUBLE FREE IN SQLRWCLEANUPWLMSCRATCHPAD WHEN RUNNING PD_GET_DIAG
DT147906 2 IT39877: DB2START IS FAILED WITH -1677 ERROR WHEN EACH MEMBER HAS A CONFIGURED INSTANCE_MEMORY VALUE AND THERE IS A GLOBAL INSTANCE_MEMOR
DT147651 2 IT37104: POSSIBLE TRAP FOLLOWING DB2DIAG.LOG MESSAGE "TRYING TO REGISTER AN INVALID SERVICE CLASS ID OF 0"
DT148255 2 IT39331: STATS_ROWS_MODIFIES REPORTS 4294967295 FROM MON_GET_TABLE AND ADMIN_GET_TAB_INFO
DT147336 1 IT39184: IF MONHEAP IS EXHAUSTED SQL STATEMENTS MAY RECEIVE SQL0973N FOR MON_HEAP_SZ
DT120319 1 IT39148: IPC connection to Db2 11.5 FP6 from a downlevel client might fail with -1224 and SQLO_NOSEG+EACCESS error logged to db2diag.log
DT148263 2 IT39875: LOCKING EVENT MONITOR "DROPPED RECORD" EVENT LEADS TO THE FLOOD OF DB2DIAG.LOG WARNING MESSAGES
DT148489 2 IT41227: WHEN THE ATS FAILS TO RUN A TASK, IN SOME CASES THE TASK MAY REMAIN IN RUNNING STATE
DT147939 2 IT40849: APPLICATION MAY HANG IN WaitSendReady WHEN SENDING AN RPC MESSAGE
DT147937 1 IT40723: DB2STOP MAY TIMEOUT ON A PARTITIONED DATABASE DUE TO A LATCHING PROTOCOL PROBLEM
DT148283 2 IT40670: SQL1611W - NO DATA WAS RETURNED BY DATABASE SYSTEM MONITOR FOR "DB2 LIST ACTIVE DATABASES" DURING SET WRITE SUSPEND.
DT147740 2 IT40614: SQL0952N MIGHT HAPPEN WHEN REAL-TIME STATISTICS IS ENABLED FOR COLUMN-ORGANIZED TABLES
DT147366 2 IT40515: DB2ACD FAILS TO EXECUTE SCHEDULED TASKS WHEN THERE IS A DB2CLI.INI FILE
DT148678 3 IT41503: MONITOR ELEMENTS IN THE ACTIVITY EVENT MONITOR THAT DEPEND ON SNAPSHOT MAY BE INCORRECT FOR CREATE/DECLARE TABLE AS STATEMENTS
DT147959 2 IT41546: PERFORMANCE IS AFFECTED BY LATCH CONTENTION WHEN INPUT DATA VALUE CAPTURE IS ENABLED FOR A LOCKING EVENT MONITOR
DT148310 2 IT41782: CON_LOCAL_DBASES COUNTER IN MON_GET_INSTANCE MAY RETURN AN INCORRECT VALUE IF A DATABASE IS DEACTIVATED WHILE QUIESCED
DT147770 2 IT41807: DB2 TRAPS IN MON_GET_PKG_CACHE_STMT ON WINDOWS
DT147745 1 IT40751: RARE TIMING SCENARIO IN UPGRADE OF PURESCALE CLUSTERS CAN PREVENT CF MEMORY ALLOCATIONS FROM BEING ADJUSTED AUTOMATICALLY
DT147385 2 IT41143: POSSIBLE MEMORY LEAK USING PD_GET_DIAG_HIST()
DT147387 2 IT41259: GW_* METRICS ARE ZERO IN MON_GET_INSTANCE
DT147570 2 IT41556: WHEN USING AUTOSTART WRITE TO TABLE EVENT MONITORS, DATABASE ACTIVATION MAY HANG OR BE DELAYED IF A Z LOCK IS HELD ON ONE OF THE
DT148296 2 IT41222: IMPROVE DIAGNOSTICS FOR FCM DOUBLE FREE OF A CHANNEL
Query Compiler
DT171386 2 IT39262: WIRELISTENER THROWS EXCEPTION WHEN AGGREGATE PIPELINE CONTAINS $INDEXSTATS
DT058197 2 IT31963: BAD PERFORMANCE FOR MODIFYING QUERIES DUE TO NO SEMIJOIN REWRITE
DT147943 2 IT40984: PERFORMANCE (HANG) ISSUE WHILE PROCESSING STACK OF NESTED TABLESWITH COMPLEX EXPRESSIONS
DT147738 2 IT40537: A FULL OUTER JOIN QUERY MAY PRODUCE A -901 WITH THE REASON "EMPTY PLAN LIST DETECTED!"
DT146727 2 IT35054: COLUMN-ORGANIZED EARLY UNIQUE AND SEMIJOIN TOGETHER RESULT IN SQLCODE -901
DT148284 2 IT40755: SQLCODE -901 MAY OCCUR WITH MESSAGE "EMPTY PLAN LIST DETECTED" WHEN COMPILING A CDE QUERY
DT133017 2 IT41027: CARDINALITY MIGHT BE OVERESTIMATED WHEN TABLE CARDINALITY BOUND ADJUSTMENTS ARE ENABLED AND JOIN CYCLES ARE PRESENT"
DT147952 2 IT41223: ISSUING A CREATE TABLE QUERY MAY CAUSE THE SERVER TO TERMINATE ABNORMALLY ON AIX
DT147742 2 IT40681: 901 ERROR MIGHT OCCUR WITH THE MESSAGE "PLAN NOT FOUND FOR UNIONLEG"
DT147758 2 IT41082: DB2 SERVER TERMINATES ABNORMALLY WHEN STATEMENT CONCENTRATOR ENABLED
DT147756 2 IT41124: POOR PERFORMANCE FOR NLJOIN IN CDE
DT148294 4 IT41132: DB2 QUERY MAY GENERATE 901 WHEN MULTIPLE NOTIN SUBQUERY EXISTS.
DT132815 4 IT41028: ISSUING A SELECT QUERY MAY ENTERS AN INFINITE LOOP
DT148115 4 IT41113: -901 UNEXPECTED ERROR AT GETJOINPAYLOADEVALUATOR.CPP
DT148112 4 IT41083: Possible trap in sqlnq_scalar_aggregate() when using LISTAGG() WITHIN GROUP()
DT147544 4 IT40456: SQL0158 OR SQL0421 QUERYING FROM VIEW OVER TEMPORAL TABLE AFTER ADDING NEW COLUMN
DT147711 4 IT39621: POSSIBLE PERFORMANCE PROBLEMS FOR INSERT STATEMENTS WITH COMMON-TABLE EXPRESSIONS
DT148079 4 IT39136: NON-PUSHDOWNABLE HASH JOIN ELIGIBLE PREDICATES INVOLVING NICKNAMES MAY BE USED SUB-OPTIMALLY
DT147346 4 IT39586: THE OPTIMIZER MIGHT FAVOUR A NON-OPTIMAL PLAN WITH REGISTRY VARIABLE DB2_EXTENDED_OPTIMIZATION=NLJN_OFLOW
DT148437 4 IT39643: GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSINGCLAUSE MAY RETURN -901
DT148259 4 IT39673: TRAP/901/HANG WHEN DB2 QUERY HAS CORRELATED IN PREDICATE IN SELECT.
DT159650 4 IT31973: DB2 SERVER TERMINATES ABNORMALLY PREPARING DECLARE GLOBAL TEMP TABLE STATEMENT
DT147260 4 IT35986: SELECT WITH GRANT FAILED TO GRANT FOR A VIEW WITH VALUES.
DT147682 4 IT38518: DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES WITH MULTIPLE OUTER JOINS
DT147722 4 IT40040: SPURIOUS ERROR MESSAGE IN DB2DIAG.LOG WHEN RUNNING DB2ADVIS
DT147067 2 IT38191: COMPILED TRIGGER REVALIDATION FAILS WITH SQL0901 "INVALID COMPILE ENV: CATALOG INDEX KEY VIOLATION"
DT147981 2 IT23350: DB2 MAY RETURN SQL0901N: EMPTY PLAN LIST DETECTED
DT068582 2 IT32990: UNQUALIFIED COLUMN REFERENCE WITH USING CLAUSE ON VIEW RETURNS SQLCODE=-206
DT147522 2 IT39520: MERGE STATEMENT REFERENCING MATERIALIZED QUERY TABLES (MQTS) MAYFAIL WITH SQL0407N
DT146510 2 IT37983: POSSIBLE DB2 TRAP IN PSMGETVALIDBREAKPOINTS() WHEN CALLING SYSIBMINTERNAL.ADMIN_GET_VALID_BREAKPOINTS()
DT146902 2 IT37611: DB2 MAY PRODUCE WRONG RESULT ON UPDATE STATEMENT WITH VIEW DEPENDENCY
DT147884 2 IT38797: QUERY FAILS WITH ERROR SQL0901N "NLJN LOJ INNER NOT NULLABLE"
DT148631 2 IT39334: SQL0952N ERROR SHOULD BE RAISED INSTEAD OF PRODUCING FODC_APPERRAND SQL0901N"
DT146220 2 IT37458: SELECT STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT")
DT146377 2 IT38190: TRAP ON SQLNO_COL_WIDTH_INLINE
DT148625 2 IT38996: INSERTING DECIMAL MINUS ZERO INTO COLUMN ORGANIZED TABLE LEADS TO WRONG RESULT ON POWERPC
DT148095 2 IT39883: POOR PERFORMANCE WHEN FEDERATED TABLE JOINED WITH CDE TABLE
DT148648 2 IT40051: DB2 SERVER COULD TERMINATES ABNORMALLY OR GET -301 WHEN RUNNING A PROCEDURE.
DT148099 3 IT40003: DB2 QUERY MAY GENERATE 901 WHEN GROUP BY COLUMNS ARE UNUSED.
DT147298 3 IT37707: INSERT INTO COLUMN-ORGANIZED TABLE WITH SUB-SELECT REFERENCING THE TARGET OF THE INSERT MAY RETURN INCORRECT RESULTS IN DPF SYST
DT147354 2 IT39978: POOR PERFORMANCE OF DB2 QUERY HAVING OR PREDICATE ON AND WITH EXPRESSION.
DT147168 2 IT35538: TRAP WHEN MULTIPLE UNION BRANCHES WITH SAME TABLE
DT159586 2 IT33263: DB2 CREATE TABLE STATEMENT MAY ABEND WHEN DB2_DEFAULT_TABLE_DISTRIBUTION IS RANDOM.
DT148643 2 IT39807: INCORRECT RESULTS MIGHT BE RETURN FOR COUNT/COUNT_BIG OVER() SCALAR AGGREGATE FUNCTION UNDER AN OUTER JOIN
DT146511 2 IT38210: DB2 SERVER TERMINATES ABNORMALLY IN RECURSIVE_QGM
DT148088 2 IT39559: DB2 ENGINE MIGHT HANG WHEN UPDATING STATISTICS FOR INDEXES ON XML COLUMNS
DT147710 3 IT39560: QUERY SUCCCEED BUT GET ERROR MESSAGE WINNING PLAN STILL NEEDS GLUE IN DB2DIAG.LOG
DT147873 3 IT38215: SELECT-STATEMENT WITH WHERE-CLAUSE, FETCH-CLAUSE AND UPDATE-CLAUSE FAILS WITH SQLCODE -511
DT147896 2 IT39337: INSERT statement performs poorly when source fullselect includesUNION ALL and fetch-clause
DT159446 2 IT34007: DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE.
DT148207 2 IT36857: DB2 ALTER TABLE QUERY MAY FAIL WITH SQL0109N ERROR
DT117977 2 IT38967: OPTGUIDELINES ARE NOT SUPPORTED FOR SET INTEGRITY STATEMENTS.
DT148628 3 IT39218: DB2 QUERY MAY GENERATE SQLCODE -901 WHEN LEFT/RIGHT OUTER JOIN PREDICATE ON EXPRESSION.
DT148253 2 IT39344: DB2 QUERY MAY GENERATE 901 WHEN SCALAR SUBQUERY HAS DISTINCT ANDFETHC FIRST 1 ROW.
DT148434 2 TRIM AND STRIP SCALAR FUNCTION RESOLUTION IGNORES CURRENT PATH
DT147378 2 INCORRECT RESULT WHEN DB2 QUERY HAS EQUAL PREDICATES WITH CONSTANTS
DT147754 2 TRAP WHEN UNION AND REFERENCE TO SAME SUBSELECT IN DB2 QUERY
DT147889 2 ABNORMAL TERMINATION OF QUERY WITH COMMON TABLE EXPRESSION
DT147705 3 IT39354: SPECIFIC MQT DEFINITION MAY LEAD TO DB2 ABEND WITH SIG11
DT146378 2 IT38199: INCORRECT "TYPE" VALUE IN IMPLICITVALUE COLUMN OF SYSCAT.COLUMNSFOR ROW CHANGE TIMESTAMP, ROW END OR TRANSACTION START ID COLUMN
DT147696 2 IT38984: SQL0901N ERROR WHEN FETCH-CLAUSE OR OFFSET-CLAUSE INCLUDES A SCALAR FULLSELECT.
DT147676 3 IT38217: QUERY COMPILATION FAILS WITH SQLCODE -421 WHEN OLAP SPECIFICATION USED AS ARGUMENT TO INLINED SQL FUNCTION
DT147309 3 IT38214: MERGE STATEMENT RETURNS SQLCODE -206 WITH EMPTY OR WRONG COLUMN NAME
DT148241 2 IT38992: SEGV IN SQLKBFIX WHEN EXECUTING QUERY INVOLVING XML DATA AND AGGREGATION IN AN MPP CONFIGURATION
DT148245 2 IT39185: OPTIMIZER USES QUANTILE STATS FOR UNIQUE COLUMNS TO COMPUTE THE EQUALITY PREDICATE FILTER FACTOR WHICH LEADS TO OVER-ESTIMATION
DT147524 2 IT39550: DB2 SERVER MAY TERMINATE ABNORMALLY ISSUING ILLEGAL SQL STATEMENT
DT146227 2 IT38184: INCORRECT PROCESSING OF ROWID IS USED IN A SUBSELECT MAY PRODUCEA -901 WITH ERROR MinMaxPartialEvaluator.cpp : 99
DT147393 2 IT41517: QUERY PERFORMANCE MAY VARY WHEN USING OUTER JOIN OPERATOR
DT147382 2 IT41054: POSSIBLE PERFORMANCE ISSUES FOR CORRELATED QUERIES WHEN MIGRATING TO DPF SYSTEMS
DT147551 2 IT40888: LIKE PREDICATES IMPROVEMENTS
DT134914 2 IT41317: -901 WHEN COMMON TABLE EXPRESSION USED IN JOIN.
DT148385 2 IT37178: A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP
DT146335 2 IT35178: DB2 MIGHT ABEND WHEN EXECUTING A QUERY USING FIRST_VALUE AND REFERENCING TABLES ORGANIZED BY COLUMN
DT148114 2 IT41104: POSSIBLE 901 ERROR WHEN RUNNING QUERY WITH TEXT SEARCH FUNCTION
DT147719 2 IT39905: LONG RUNNING QUERY WITH COMPLEX CASE EXPRESSIONS HANGS AT COMPILE TIME
DT146726 2 IT35045: PACKAGE CONTAINING XML FUNCTIONS MAY RESULT IN -901 WHEN REBINDING WITH APREUSE
DT148485 3 IT41140: WRONG RESULT WHEN PREDICATE WITH CONSTANT ON AGGREGATE FUNCTION WITH CASE.
DT147934 1 IT40646: EQUALITY PREDICATES CONTAINING COALESCE EXPRESSIONS COULD HAVE INACCURATE FILTER FACTOR ESTIMATES.
DT148457 2 IT40288: OPTIMIZER USES EMPTY QUANTILE STATS LEADING TO CARDINALITY UNDER-ESTIMATION
DT147936 2 IT40676: OPTIMIZER MAY GENERATE A NEW TYPE OF PLAN BECAUSE OF HOW INDEX ORING PLANS ARE BUILT BETWEEN 9.7 AND 10.5
DT148276 2 IT40414: POSSIBLE TRAP (SEGV) IN PSM_DECLARE_VARIABLE_NODE() OR PSM_GEN_ROW_FIELD_VARIABLE() TRYING TO CREATE A PROCEDURE WITH A COMPLEX
DT146224 2 IT37893: DB2 MAY CRASH WHEN IT REPORTS COORDDB IS NULL
DT147999 3 IT31325: DB2EXFMT MAY HANG WITH SQL LONGER THAN 4096 AND COMMA OCCURS AT POSITION 4096 IN THE FORMATTED ORIGINAL STATEMENT
DT055930 2 IT31761: QUERY WITH STRING CAST FAILS WITH -901 "UNEXPECTED ERROR AT GETJOINPAYLOADEVALUATOR.CPP"
DT148104 1 IT40326: DB2 MAY TRAP WHEN RUNNING UPDATE STATEMENT THAT CONTAINS SPECIALCHARACTERS.
DT142838 2 IT40238: INSTANCE MAY CRASH DURING QUERY COMPILATION
DT147956 3 IT41466: DB2SUPPORT WITH THE -CL 2 OR -CL 3 OPTION CAN UNDER SOME CIRCUMSTANCES RESULT IN A SEGV TRAP
DT146312 1 IT34338: POSSIBLE PERFORMACE REGRESSION DUE TO OUTER JOIN - INNER JOIN REORDERING
DT148506 2 IT41713: INCORRECT RESULT WHEN CORRELATED PREDICATE ON PRIMARY KEY OF A TABLE.
DT148086 2 IT39524: DB2 SERVER MAY TERMINATE ABNORMALLY WHEN USING SUBSTR
DT146899 2 IT37308: DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ISSUING A SELECT QUERY
DT148277 2 IT40464: QUERY MIGHT TRAP IN DATA PARTITION ELIMINATION OF A ZIGZAG JOIN
DT147352 2 IT39906: POTENTIALLY BAD PERFORMANCE WHEN USING PARAMETER MARKERS IN QUERIES CONTAINING JOINS
DT148127 2 IT41735: XMLAGG WITH XMLQUERY INPUT AND GROUP-BY-CLAUSE MAY FAIL WITH -901 "BAD PLAN; UNRESOLVED QNC FOUND"
DT148424 2 IT38952: XML NODE MANAGER THROWS -901 ERROR WHILE RUNNING MANUAL RUNSTATSON XML TABLE."
DT148510 2 IT41821: QUERY WITH "WHERE RID() = <CONSTANT>" PREDICATE MIGHT RETURN INCORRECT RESULTS IN MPP
DT147955 1 IT41312: SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE AFTER ENTERING A MALFORMED SQL STATEMENT INTO THE DB2EXPLN TOOL
DT148501 2 IT41456: SQL0433N ON RETRIEVAL ASSIGNMENT WHEN DBCLOB CAST TO VARCHAR
DT147753 3 IT40953: "EXPLAIN PLAN FOR" DOES NOT WORK FOR TEXT SEARCH QUERY
DT148021 2 IT35030: DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER
DT147626 2 IT35043: SQL0901N ERROR MAY OCCUR WHEN COMMON TABLE EXPRESSION HAS "SYSPUBLIC" SCHEMA NAME
DT147675 2 IT38198: COMPILING A SQL QUERY THAT INCLUDES A SQL UDF WITH OLAP INPUT MAY INCORRECTLY RETURN SQLCODE -206
DT146640 3 IT38211: DROP PACKAGE FAILS WITH SQL0553N WHEN "PL/SQL SUPPORT" IS ENABLED
DT148488 2 IT41215: STATICASDYNAMIC OPTION NOT SUPPORTED FOR COMPILED SQL OBJECTS
DT148641 2 IT39702: DB2 MAY COPY SELECTIVITY WHEN A SELECTIVITY CLAUSE IS USED ON A PREDICATE THAT'S COLUMN EQUIVALENT (C1=C2 AND C1=C3)
DT148487 2 IT41205: SLOW PERFORMANCE MIGHT BE OBSERVED WHEN RUNNING AN IUD STATEMENTWITH CERTAIN CHARACTERISTICS
DT147560 3 IT41220: DB2 MAY ABEND WHEN UNION HAS BOTH PUSHDOWNABLE AND NON PUSHDOWNABLE BRANCH
DT148496 3 IT41386: POOR PERFORMANCE WHEN IN SUBQUERY USES THE SAME TABLE
DT148121 4 IT41415: POOR PERFORMANCE OF DB2 QUERY WITH UNION SUBQUERIES
DT148285 2 IT40829: DB2 QUERY MAY TRAP WHEN DIFFERENT COLUMNS ACCESSED IN MULTIPLE SCALAR SUBQUERIES
DT148662 1 IT40718: DB2 QUERY MAY PERFORM POOR WHEN NOT IN SUBQUERY HAS EXPRESSION.
DT148106 1 IT40752: DB2 QUERY TRAPS WHEN MODIFYING STATEMENT USES SET COLUMN THAT ISNOT USED IN SUBQUERY PREDICATE
DT147549 3 IT40762: INCORRECT RESULT WITH QUERY HAVING UNION
DT148467 2 IT40560: LOCAL PREDICATE PUSHDOWN FAILS WHEN IN SUBQUERY IN SELECT
DT148469 2 IT40626: DB2 QUERY MAY GENERATE 901 FOR QUERIES WITH UNION
DT168674 2 IT42184: IDENTITY_VAL_LOCAL MIGHT NOT RETURN LAST VALUE IF PREVIOUS INSERT-FROM-VALUES STATEMENT CONTAINED SMP-PARALLELIZED SCALAR SUBSEL
Query Compiler - ADM/PSM
DT148619 2 IT38951: DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN
DT147726 2 IT40092: DB2 SERVER TERMINATES ABNORMALLY OR RETURNS -901 WHILE PROCESSING JSON DATA
DT147325 2 IT38801: DB2 SERVER TERMINATES ABNORMALLY DURING CREATE/DECLARE TABLE
DT148264 2 IT40064: POSSIBLE WRONG RESULT WHEN PREDICATE INCLUDES CAST OF DBCLOB TO GRAPHIC OR VARGRAPHIC
DT147139 2 IT34443: A COLUMN MASK DEFINED ON A COLUMN WITH STRING LENGTH UNIT CODEUNITS32 MAY RESULT IN SQL20478N
DT148653 2 IT40270: WRONG DEFAULT VALUE FOR CHAR or GRAPHIC COLUMN IN AN EBCDIC TABLE WHEN DEFAULT VALUE IS NOT EXPLICITLY SPECIFIED
Query Compiler - Optimizer
DT148656 3 IT40363: -1667 WITH TOKENS TABLE TYPE: "ORGANIZE BY COLUMN". OPERATION: "WITH RR"
DT146873 3 IT35741: SQL1585N is returned when the optimizer does not select a possible plan under some circumstances
Query Compiler - QRW
DT148447 2 IT39872: POOR DB2 QUERY PERFORMANCE WHEN EXISTS SUBQUERIES PART OF OR
DT148234 3 IT38599: DB2 QUERY MAY GENERATE 901 WHEN JOIN ON SAME TABLE AND SELECT DISTINCT PRESENT
Runtime
DT168627 2 IJ39696: HISTOGRAM PRODUCING BINS WITH ZERO TUPLES
DT132361 2 IT40868: DB2 INSTANCE CRASH ON FUNCTION SQLERGETFMPFROMPOOL()
DT147379 2 IT40966: -901 SECTION LENGTH MISMATCH WHEN EXECUTING STATIC SQL
DT147381 2 IT41020: SQL0901N IN MPP WITH COLUMNAR TABLES IN SQLKQ_STOPWRITE_FLUSH FOR SQLKF_RQST_TIMEOUT
DT146780 2 IT38212: SET INTEGRITY FAILS WITH SQLCODE -668, REASON CODE 1 AFTER ADDING NEW GENERATED COLUMN
DT148261 2 IT39748: WHEN CPU SUPPORTS AVX2 A RARE TRAP IN PACKEDBANKSIMD IS POSSIBLE
DT148443 2 IT39765: A RARE WRONG RESULT IS POSSIBLE AGAINST COLUMNAR TABLES WITH A PSCANCOL PLAN AND MULTIPLE HSJNs ON THE SAME TABLE COLUMNS
DT147687 2 IT38730: POSSIBLE TRAP IN JOINEXPANSIONMULTIPLIEREVALUATOR::EXPANDALLREGULARATTR WHEN RUNNING HSJN QUERIES
DT148446 2 IT39851: RARE DATABASE SHUTDOWN WITH -902 SQLD_PARM "PARAMETER ERROR"
DT131647 2 IT40771: APPLICATION MAY HANG DUE TO THE LOST COMMUNICATION BETWEEN THE AGENT AND FMP CODE
DT147926 2 IT40347: RARE CRASH IN ERROR SCENARIO IN SQLRA_OPEN_PKG FUNCTION
DT147355 2 IT40066: DECREASE DEFAULT MAX NUMBER OF THREAD TO 1023 INSTEAD OF 1024 ON AIX
DT146453 4 IT34719: DECIMAL FUNCTION ON COLUMN-ORGANIZED TABLE MIGHT FAIL WITH SQL0413N
DT132780 2 IT39950: IN RARE JOIN ON COLUMNAR TABLES COULD LOOSE ROWS
DT148098 2 IT39999: FMP MEMORY CORRUPTION DUE TO WRITING TO A FREED IPC
DT123635 2 IT39928: RARE WRONG RESULT IS POSSIBLE FOR QUERIES AGAINST CDE TABLES THAT WERE CREATED WITH EBCDIC CCSID
DT148094 2 IT39873: FLUSH PACKAGE CACHE DYNAMIC FOR EXECUTABLE ID REPORTS SQLP_LCON
DT147337 2 IT39201: INSTANCE CRASHES RUNNING ALTER PACKAGE PACKAGE-NAME OPTIMIZATIONPROFILE OPTIMIZATION-PROFILE-NAME
DT148073 3 IT38861: RELAX OF DIAGLEVEL OF SQLRR_RDS_COMMON_POST, PROBE:870
DT148271 2 IT40274: TRAP IN FUNCTION SQLRA_GET_VAR WITH STMT_CONC SET TO COMM_LIT
DT143619 2 IT40019: DB2 GOT CRASHED WITH SIGINAL #11 AT SQLRILITERALREPLACE()
DT147721 2 IT40020: SQL RETURNING WRONG RESULT AFTER REPEATING SAME SELECT STATEMENT
DT147534 2 IT40028: XA INDOUBT TRANSACTIONS: AFTER DB2STOP QUIESCE IS RUN
DT147718 2 IT39869: SQLCODE -803, PRODUCES DB2DIAG.LOG MESSAGE: SQLRR_PROCESS_EXECUTE_REQUEST, PROBE:800 MESSAGE
DT147708 2 IT39551: DB2 MAY TRAP IN UPRV_TZNAME
DT148428 2 IT39145: INSERT INTO A LOB MAY FAIL WITH ERROR -30020
DT147333 3 IT39081: A RARE TRAP WORKING WITH COLUMNAR TABLES IN A VERY SPECIFIC STACK
DT130540 2 IT40699: INSTANCE CRASH WHEN SQLO_CPSAME ERROR HAPPENS IN SQLRICASTG2C
DT147568 2 IT41514: -901 INVALID POOLID AND OR OBJECTID ERROR IS INCORRECTLY RETURNED AFTER A TEMP TABLESPACE FULL SCENARIO
DT147566 2 IT41469: Sortheap memory leak possible for index-and access on MDC tables
DT148456 2 IT40279: RUNNING BIG SQL RETURN ERROR -901 INSTEAD OF -955
DT148298 2 IT41314: WRONG RESULT WHEN SORT WITH FETCH FIRST N ROWS IS DONE IN COLUMNAR LOGIC
DT148674 2 IT41238: HANGING QUERIES CANNOT BE TERMINATED THROUGH THE NORMAL METHOD OF FORCING THE APPLICATION
DT148281 3 IT40618: WARNING MESSAGE COULD BE LOGGED INCORRECTLY IN DB2DIAG.LOG.
DT147930 2 IT40476: WHEN OLAP IS DONE IN COLUMNAR LOGIC QUERY COULD EXPERIENCE A HANG
DT147933 2 IT40602: RARE TRAP IN RIGHT OUTER HSJN WHEN INTERRUPT IS ISSUED.
DT148683 2 IT41653: ERROR MESSAGES WITH SQLNLSICUCONVERTTODATEFORMAT_CLDR2701
DT148478 2 IT40905: INCORRECT ROW COUNT REPORTED WITH INSERT .. IGNORE DUPLICATES , COLUMNAR TABLES ONLY.
DT147564 2 IT41340: DOUBLE FREE OF UNUSED CHANNEL
DT148421 2 IT38887: ENHANCEMENT OF THE PD MESSAGE WHEN REACH THE LIMIT CONFIGURED BYDB2_MAX_THREADS_PER_FMP
DT148499 2 IT41427: DATA TYPE CONVERSION LEADS TO -SQL0413N OVERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSION
DT147375 2 IT40874: SPIKES IN SQLO_LT_SQLRA_CACHED_ENV__LATCH WAIT, USING STMT_CONC=LITERALS, ON CONCURRENTLY COMPILATION OF A STATEMENT
DT147540 4 IT40328: DB2 MIGHT REPEATEDLY REPORT ISSUES IN SQLSMERGEREC
DT147395 3 IT41571: FODC APP ERR WITH -901 "REACHED RETRYCOUNT LIMIT"
DT147541 4 IT40351: SEVERITY CHANGE OF LOG ENTRY: "FUNCTION: DB2 UDB, ROUTINE_INFRASTRUCTURE, SQLERINITFMPHEAP, PROBE:995* RETCODE : ZRC=0X00000000=
SAP Tools
DT147371 2 IT40744: UPDATE SAPTOOLS.UPPER/LOWER TO COMPLY WITH LATEST UNICODE STANDARD
DT148286 2 IT40840: SAPTOOLS.ADMIN_COL_ANALYZE_FRAGMENTATION MIGHT RETURN SQL0802N
Security
DT147525 1 IT39584: SECURITY: A VULNERABILITY IN 2.17.0 APACHE LOG4J AFFECTS DB2 (CVE-2021-44832)
DT148609 1 IT38463: SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION
DT148247 2 IT39215: UPDATE GSKIT TO 8.0.55.26
DT148637 2 IT39500: UNNECESSARY SQLO_BAD_GROUP LOGGING INTO DB2DIAG.LOG
DT147695 2 IT38958: POSSIBLE SEGMENTATION FAULT ON DB2AUDIT EXTRACT COMMAND
DT147511 2 IT38800: IN CERTAIN SITUATIONS, THE SSL FUNCTION GSK_SECURE_SOC_PEEK MAY FAIL WITH THE RETURN CODE "5" IN SQLCCSSLSOCKETPEEK
DT148452 1 IT40210: SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE (CVE-2022-22389)
DT147923 1 IT40217: SECURITY: IBM DB2 IS VULNERABLE TO UNAUTHORIZED ACCESS (CVE-2022-22390)
DT147365 1 IT40483: EXCESSIVE CALLS TO OPERATING SYSTEM DATETIME FUNCTIONS, FOR EXAMPLE LOCALTIME_R, CAUSES LOCK CONTENTION IN THE OPERATING SYSTEM
DT148125 2 IT41557: IN RARE SCENARIOS, CERTAIN DB2 FUNCTIONS CAN HANG WHEN ATTEMPTING TO RESPAWN A CHECK PASSWORD DAEMON
DT147571 2 IT41576: DB2AUDIT SYNTAX ERROR WRITES AN UNNECESSARY ERROR LEVEL MESSAGE IN DB2DIAG.LOG
DT147539 2 IT40300: CATALOG LDAP DATABASE... AUTHENTICATION TOKEN FAILS WITH ERROR SQL1400N
DT148463 3 IT40509: IMPROVE EFFICIENCY OF CLIENT SIDE TLS CONNECTIONS
DT148670 1 IT40879: SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE DUETO UNAUTHORIZED ACCESS. (CVE-2022-22483)
PureScale
DT147348 3 IT39691: WORKAROUND TO AVOID ROOT PASSWORDLESS SSH IN PACEMAKER
DT147949 3 IT41161: OPTION TO DISABLE AUTO FAILOVER AFTER 2 CONSECUTIVE TSA DB MONITOR TIMEOUTS
DT145604 3 IT40835: SETTING HADR_SYNCMODE TO ASYNC/SUPERASYNC AND ACTIVATING DB IS NOT BLOCKED ON PACEMAKER AUTOMATED HADR DATABASE.
DT148477 3 IT40902: DB2CM -ENABLE OR -CREATE -DB MAY NOT RUN AS EXPECTED IF HOSTS HAVE OUTPUTS TO STDOUT IN THEIR LOGIN ENVIRONMENT OF HADR INSTANCE
DT147915 3 IT40026: TOTAL_CF_CMD_TIME_MICRO RETURNS -1
DT147912 2 IT40004: OUTPUT FROM LOADING INSTANCE PROFILE CONFLICTS WITH EXPECTED STDOUT IN PARTS OF DB2CM SCRIPT
DT148647 2 IT40005: HADR_REMOTE_INST SHOULD ALWAYS BE LOWERCASE
DT147714 4 IT39781: DIA8532C IS SOMETIMES LOGGED IN DB2DIAG.LOG WHEN ACTIVATING DB VIA DB2V115_START.KSH
DT147347 2 IT39589: DB2INST RESOURCE AGENT MAY CAUSE HANG DURING META-DATA ACTION INPACEMAKER HADR
DT147944 2 IT41024: HIGH "SQLO_LT_SQLB_BP_AREA_INFO_PAGEAREA__CLOCKLATCH" CONTENTIONS ON DB2 PURESCALE
DT147743 2 IT40711: PRINT SYSTEM DUMP MESSAGES IN DB2DIAG.LOG WHEN DB2 INITIATE SYSDUMPSTART COMMAND DUE TO MEMBER OR CF PROCESS CANNOT BE KILLED
DT148266 2 IT40090: ERRORS UNDER UNDER /VAR/LOG/PACEMAKER
DT124197 2 IT38339: db2instance -list shows CF in ERROR state transiently
DT148265 2 IT40088: DB2CM -LIST ERROR COULD NOT GET PACEMAKERE VERSION - 679
DT147920 2 IT40089: DB2CM -DUMP GENERATING ERRORS
DT147391 2 IT41467: SLOW CF PERFORMANCE AND LOW CF CPU UTILIZATION DURING HIGH RAR OPERATION DUE TO DE/RB LATCH CONTENTIONS
DT129226 2 IT39844: DB2START FAILS WITH SQLE_SAL_MIXED_TRANSPORTS_ERROR WHEN ONE OF THE RDMA ADAPTERS ON THE HOST IS IN UNKNOWN STATE
DT148468 2 IT40590: SETTING UP THE FAULT MONITOR FACILITY TO AUTOMATICALLY RESTART DB2 INSTANCES FAILS ON A NON-ROOT INSTALLATION
DT148507 2 IT41752: DB2SYSC PROCESS WAS NOT RESTARTED ON OLD PRIMARY AFTER TAKEOVER.
DT147744 4 IT40734: CLUSTER MANAGER MAY NOT FUNCTION AS EXPECTED IF /VAR IS FULL
DT147345 4 IT39517: THE DB2PD FUNCTION GETS VALUE FOR CF_GBP_SZ FROM THE DB CONFIG STRUCTURE IN MEMORY WHICH IS INCORRECT.

DB2 Version 11.5 Fix Pack m7fp0
APAR Sev. Abstract
IT36682 3 QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNION MAY GET INCORRECT RESULT
IT41864 3 EXTERNAL TABLE INSERT OR SELECT MAY INCORRECTLY RETURN SQL0100
IT33777 3 BUILD IN FUNCTION "DATE_PART" MIGHT RETURN AN INCORRECT RESULT OF WEEK, I.E. DATE_PART('WEEK', '2020-03-09')
IT38609 2 REORG RECLAIM THROWS -901 AS INTERNAL QUERY COMPILATION FOR SYNOPSIS TABLE WAS INTERRUPTED
IT37046 2 DEBUG CODE IN ENGN/SQNG CHANGE FOR A TRAP IN CODEGEN
IT38731 2 CALLING CLR STORED PROCEDURE ON WINDOWS COULD RESULT IN SQL4301N RC=6
Fix Pack m7fp0  -   Abstract Data Types and Spatial Extender
IT37105 2 INTERMITTENT ISSUE IN ST_UNION RESULTING IN WRONG M VALUES
Fix Pack m7fp0  -   Administration Tools
IT38669 2 MON_GET_AUTO_MAINT_QUEUE() MAY FAIL WITH SQL0493N
IT37555 3 AUTOMATIC MAINTENANCE (DB2ACD) PROCESS GENERATES "HMONSQLCONNECT , PROBE:600 SQLCODE-1060" DB2DIAG.LOG ERRORS ON STANDBY DATABASE
Fix Pack m7fp0  -   Buffer Pool Services
IT38002 2 ALTER TABLESPACE REBALANCE HANGS ON DISK FULL ERROR
IT38476 3 YOU MIGHT SEE LOT OF SQLBPROCESSDSTACK MESSAGES IN DB2DIAG.LOG
IT37395 3 DB2PD -BUFFERPOOLS REPORTS INACCURATE HIT RATIO
Fix Pack m7fp0  -   CDE Data
IT37801 1 UPDATE OF A COLUMN-ORGANIZED TABLE WITH A SEARCH PREDICATE ON AN INDEX MIGHT RETURN A SQL901 ERROR DURING EXECUTION.
IT37048 1 COLUMN ORGANIZED TABLES THAT HAVE BEEN MARKED UNAVAILABLE CANNOT BE RENAMED. DOING SO MAY CRASH DB2.
IT37977 1 SELECT OR COMMIT AFTER UPDATE OF A COLUMN-ORGANIZED TABLE IN A PARTITIONED DATABASE ENVIRONMENT MIGHT FAIL WITH SQL901 ERROR
IT37868 2 FODC_APPERR: 'COLUMN.GETISNULLABLE()' ASSERTION DURING REPLICATION FOR COLUMN-ORGANIZED TABLES
IT37579 2 POSSIBLE TRAP IN SQLUMERGETABLEACCESSORZRC() WHEN RUNNING LOAD IN CDE ENVIRONMENT
IT37047 3 HANG DUE TO DEADLATCH BETWEEN VECTORIZEDADC THREAD AND NORMAL APPLICATION THREAD WHICH IS ROLLING BACK
Fix Pack m7fp0  -   CDE Query
IT38155 1 TRAP POSSIBLE WHEN COLUMNAR QUERY RUNNING WITH THE DB2 TRACE ENABLED IF "NOT IN" CLAUSE
IT37179 1 OTF ENCODING FOR THE LARGE COLUMNS LEADS TO QUERY EXECUTION FAILS WITH SQL0954 .
IT37212 1 RARE MEMORY CORRUPTION IN SORTHEAP WHEN CDE HSJN IS IN THE PLAN
IT37045 2 DEBUG CODE FOR CDE/GROUPBY TO ADD ASSERTION TO ENSURE NEXT VECTOR POSITION AND THE PAYLOAD POSITION
IT38286 2 TRAP IN SQLOFASTALLOCATOR::FREEBLOCK
IT37674 2 WRONG RESULTS FROM SELECT COUNT QUERY ON "ORGANIZE BY COLUMN" TABLE
IT36462 2 BLU QUERY CAN TRAP IN EVALUATIONROUTINE::GETQUERYLITERAL
Fix Pack m7fp0  -   Client Interfaces
IT35245 1 PROCESS CRASHES WITH SIGNAL 11 (MEMORY VIOLATIONS) WHEN APPLICATION CALLS SQLCONNECT OR SQLDRIVERCONNECT
IT38240 2 JAVA.LANG.OUTOFMEMORYERROR WITH TIMERLEVELFORQUERYTIMEOUT DEFAULT SETTING
IT37448 2 AFTER TURNING ON CLI PREFETCHING FEATURE, SQL STATEMENT RECEIVES CLI0106E/CLI0108E OR SQL_ERROR WITHOUT DIAGNOSTIC INFO
IT38241 2 ALTERNATE SERVER BECOMES PRIMARY SERVER WHEN BOTH PRIMARY AND ALTERNATE SERVERS ARE DOWN DURING DB2 JCC ACR
IT38541 2 INSERT INTO XML COLUMN OF A DRDA NICKNAME MAY CAUSE A SIGNAL 11 TRAP
IT38055 2 DB2DSDCFGFILL DOES NOT CREATE A DB2DSDRIVER.CFG FILE
IT37407 2 SQLCOLUMNS CLI FUNCTION MAY NOT WORK ON A TABLE NAME THAT INCLUDES MBCS CHARACTERS
IT36721 2 REORGCHK F6 REPORTING INCORRECT VALUES
IT33888 3 NO OPTION TO CONFIGURE CLI KEYWORD SSLSERVERCERTIFICATE VIA MICROSOFT ODBC ADMINISTRATOR
Fix Pack m7fp0  -   Codegen and Runtime
IT38563 2 DATABASE CRASH WHEN ARRAY TYPE VARIABLE USED IN "DGTT AS (SELECT ..) WITH DATA" SQL STATEMENT
IT38313 2 MEMORY LEAK IN RUNTIME ENGINE IF MEMORY POOL IS NOT CACHED
IT37768 2 PACKAGE RESTORE VALIDATION MAY CAUSE -901 AND FODC_APPERR
IT38087 2 SEGV AT SQLV_MIXD_BUILD_LIKE_SUBPAT()
Fix Pack m7fp0  -   Communication
IT37963 2 MEMORY LEAK IN DB2 11.5 MOD6 FP0 DUE TO A NEW FEATURE IN ESQL.
Fix Pack m7fp0  -   DRDA Services
IT38817 1 SECURITY: CLIENT ENCRYPTION SETTINGS ARE NOT PRESERVED ON A FAIL OVER/RECONNECT RESULTING IN A DATA EXPOSURE. (CVE-2021-39002)
IT36663 2 INCORRECT CONNECTION DETAIL TOKEN STRINGS FOR A CLP CONNECTION USING A DBALIAS GREATER THAN DBNAME
Fix Pack m7fp0  -   Data Management Services
IT37470 1 POSSIBLE SIGSEGV WHEN TURNING ON OR DURING MONITORING OF TABLE EVENTS
IT39109 1 BCD DECIMAL USING 0XF FOR SIGN NIBBLE MIGHT GET CONVERTED TO NEGATIVE VALUE
IT37146 2 SYSTEM TEMP TABLESPACE CAN BE LEFT IN SQLB_REORG_IN_PROGRESS IF REORGS WERE STARTED, BUT NOT COMPLETED BEFORE CRASH RECOVERY
Fix Pack m7fp0  -   Data Management Utilities
IT38564 2 ADMIN_MOVE_TABLE(REPORT) OPERATION FAILS WITH -911 LOCK TIMEOUT DURING ADMIN_MOVE_TABLE(COPY_USE_LOAD)
IT35853 2 AUDIT EVENT LOAD_TABLE EVENT STATUS 3534 FILLING UP AUDIT LOG
IT36654 2 LARGE LOAD WITH LARGE AMOUNT OF LOB (> ~2-5 GB) DATA, AFTER LOAD COPY IMAGE FILE REPLAYED/PROCESSED, LEAD TO DATA CORRUPTION
IT38511 3 ROLLFORWARD OF LOAD COPY IMAGE FROM OBJECT STORAGE CANNOT BE RECOVERED DUE TO PATH TRUNCATION
IT37792 3 REMOVE DIAG MESSAGE "ROW HASH MISMATCH" WHEN LOAD ASKED TO DISCARD SUCH ROWS ON V11.5
Fix Pack m7fp0  -   Data Recovery Services
IT37671 1 TABLE SPACE ROLLFORWARD CAN FAIL UNDER ADVANCED LOG SPACE MANAGEMENT
IT38506 1 DB2READLOG API FAILS TO RETRIEVE LOG FILE WITH SQL2657N
IT38461 2 HADR STANDBY LOG FILES ACCUMULATING IN THE DATABASE LOG PATH.
IT35086 2 SQL2536W DURING BACKUP
IT36964 2 TOO MANY LOG FILES IN ACTIVE LOG PATH ON HADR STANDBY
IT38900 2 AFTER REACTIVATING A CRASHED STANDBY DATABASE, SOME READ ON STANDBY OPERATIONS MIGHT GET BACK SQL0901
IT38431 2 DB2ADUTL UPLOAD FAILS TO UPLOAD THE WHOLE RANGE OF LOGS IF ONE OF THE LOGS WAS ALREADY UPLOADED
IT37382 2 TOTAL_LOG_USED INCREASE GRADUALLY TO AN UNREAL VALUE
IT37021 2 SNAPSHOT BACKUP FAILED WITH SQL1550N RC 5
IT37863 3 HADR GRACEFUL TAKEOVER CAN TIMEOUT DUE TO SUSPENDED DB2AGENT PROCESSES
IT36568 3 A DATABASE OUTAGE IS REQUIRED IN ORDER FOR A NEW CERTIFICATE FOR HADR WITH SSL TO TAKE EFFECT
IT37926 3 LOCK ESCALATION OCCURS IN PURESCALE WHEN DB2_AVOID_LOCK_ESCALATION IS SET
IT37514 3 DB2 CRASH DUE TO LOG MISSING REQUIRED BY A ROLLBACK.
Fix Pack m7fp0  -   Federation
IT38046 1 NNSTAT MIGHT FAIL TO UPDATE NUMERIC COLUMN STATS WITH SQL1227N RC=3 IF VACHAR2 COMPATIVILITY IS ENABLED.
IT37846 1 NNSTAT FAILS TO UPDATE NICKNAME'S STATICS DUE TO DIFFERENT CURRENT SCHEMA SETTING
IT37965 1 THE REMOTE CHAR COLUMN LENGTH OVER 86 REPORT SQL0901 AFTER THE COLUMN LENGTH AUTO VARIATION
IT37587 2 DB2 FEDERATION CAN NOT BE FORCED OFF DURING ABNORMAL SHUTDOWN OF MSSQL SOURCE SERVER
IT38446 2 WHEN REMOTE DATA SOURCE IS DB2 AND THE TABLE HAS CLOB COLUMN, IT MIGHT CAUSE THE -901 INVALID NICKNAME COLUMN LENGTH ERROR
IT37014 2 WITH FEDERATION USE OF A FLAT FILE FAILS IF THE FILE > 3GB IN SIZE ON WINDOWS
IT38209 2 AS FEDERAION LACK OF CODEPAGE CONVERSION FOR CLOB DATA TYPE IN R EMOTE DATA SOURCE, IT WILL CAUSE -901 ERROR "REAL COLUMN LENGTH
Fix Pack m7fp0  -   Index Manager
IT39048 1 HANG WAITING FOR SQLO_LT_SQLI_IDXCB__IDXTREELATCH WITH NO HOLDERS AFTER FAILED REORG INDEX(ES) .. RECLAIM EXTENTS
IT36666 1 REORG TABLE RECLAIM EXTENTS ON INSERT TIME CLUSTERING (ITC) TABLES CAN RESULT IN FODC_INDEXERROR
Fix Pack m7fp0  -   Install and Catalog Services
IT37423 2 INSTALLDSDRIVER -UPGRADE FAILS TO UPGRADE WHEN MOVING FROM ONE MODPACK TO ANOTHER
IT37851 2 INVALID ENTRIES IN CATALOGCACHE , REMOVE INVALID ENTRIES FROM SYSCODEPROPERTIES CACHE.
IT37424 2 TRAP WHEN RUNNING ADMIN_REVALIDATE_DB_OBJECTS()
IT37995 2 PURESCALE CAN NOT BE SETUP WITH DB2LOCSSH
IT37836 2 IN-PLACE INSTALLFIXPACK GETS SEGMENTATION FAULT ON RHEL 8.X WITH PACEMAKER
IT38186 2 APPLYING HIGH CAPACITY LICENSE ON TOP OF DB2 STANDARD OEM LICENSE DOES NOT REMOVE THE MEMORY AND CORE LIMITS.
IT38027 2 32-BIT ICCSIG.TXT IS MISSING FROM DB2 11.5.6.0 UNIX (AIX, LINUX, ETC.) IMAGES
Fix Pack m7fp0  -   JDBC Driver
IT38240 2 JAVA.LANG.OUTOFMEMORYERROR WITH TIMERLEVELFORQUERYTIMEOUT DEFAULT SETTING
IT38241 2 ALTERNATE SERVER BECOMES PRIMARY SERVER WHEN BOTH PRIMARY AND ALTERNATE SERVERS ARE DOWN DURING DB2 JCC ACR
IT37644 2 DURING XA TRANSACTION, WHEN XAER_RMFAIL IS RECEIVED FROM SERVER, SUCH CONNECTIONS ARE NOT ISOLATED, CLOSED AND REMOVED FROM CONN
IT37216 2 JCC 4.27.25 CAUSES ABENDS IN DB2 WHILE ACCESSING BLOB DATA MORE THAN 1MB SIZE
IT37215 2 SOMETIMES FEW BYTES OF DATA ARE MISSING WHEN LOB LOCATORS ARE USED FOR FETCHING DATA WHICH CONTAINS MULTI BYTE CHARACTERS
IT37126 2 ARRAYINDEXOUTOFBOUNDSEXCEPTION OCCURS DURING MULTITHREADED SQLJ APPLICATION PROFILE PROCESSING.
IT36131 2 UNEXPECTED ERROR SEVERITY CODE 8 ERRORCODE=-4228, SQLSTATE=NULL WHEN USING PREPARED STATEMENT WITH SETARRAY METHOD
Fix Pack m7fp0  -   Monitoring
IT38659 2 EXECUTING ADMIN_MOVE_TABLE ON A TABLE WITH SOME KINDS OF STATEMENTS > 64KB SIZE, WILL RETURNED SQL0104N OR SQL1224N
IT38013 2 ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL2103N RC=16 IF RUNSTATS PROFILE CONTAINS NUM_FREQVALUES /NUM_QUANTILES
IT38011 2 ADMIN_MOVE_TABLE FAILS WITH ERROR WHEN MOVING TABLE WITH USAGE LIST AND SPECIAL CHARACTERS
IT37690 2 SPACE USED BY LOBS IN SOME EVENT MONITORS NOT REUSED WHEN THOSE LOBS ARE DELETED
IT36891 2 MON_GET_LOCKS FAILS IN SINGLE MEMBER WITH "NO MEMORY AVAILABLE".
IT38627 2 ADMIN_MOVE_TABLE COPY_STATS MIGHT FAIL WITH SQL0010N IF LOW2KEY/HIGH2KEY CONTAINING 0 BYTE
IT37956 2 ADMIN_MOVE_TABLE FAILS WITH SQL0104N WHEN MOVING TABLE WITH DOUBLE QUOTES IN NAME WHICH HAS A STATISTICS PROFILE
IT36731 3 ADMIN_MOVE_TABLE FAILS WITH SQL0010N - WHEN RUNSTATS STATS_PROFILE IS GREATER THAN 1024 CHARACTERS.
IT36203 3 ADMIN_MOVE_TABLE WITH COPY_STATS OPTION MIGHT FAIL WITH SQL2102N RC 28
Fix Pack m7fp0  -   Parsing and SQL PL
IT37213 1 SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR BACKUP (CVE-2021-29825)
Fix Pack m7fp0  -   Platform Specific
IT37087 1 NX842 BACKUP AND LOG FILE COMPRESSION MIGHT FAIL
IT38996 2 INSERTING DECIMAL MINUS ZERO INTO COLUMN ORGANIZED TABLE LEADS TO WRONG RESULT ON POWERPC
IT38006 2 BACKUP FAILS WITH BAD PAGE ERRORS DUE TO MISMATCH BETWEEN THE PH YSICAL SIZE OF THE CONTAINER AND WHAT IS SAVED IN THE SPCS FILES
IT36839 2 DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY
IT38467 3 SQL1128W REASON CODE 6 MISSING FROM KC AND MRI MESSAGES
Fix Pack m7fp0  -   Problem Determination
IT37531 2 DB2_HANG_DETECT SCRIPT MAY DETECT HANG INCORRECTLY AND KILL THE INSTANCE WITH ACTION=TERMINATE
Fix Pack m7fp0  -   Process Model
IT38238 2 MEMORY CORRUPTION WHILE PERSISTING PLAN ACTUAL HASH TABLE TO DISK
IT35720 2 PURESCALE MAY HANG WHEN THERE ARE 2 MORE CONCURRENT NODE FAILUR ES AND ONE OF THE NODE FAILURES CAUSES A DATABASE DEACTIVATION.
IT38379 2 IN CERTAIN SITUATIONS, A SMALL MEMORY LEAK WILL BE OBSERVED IN SQLE_APPLICATION.C ON A DPF INSTANCE
IT38716 2 IN PURESCALE, POTENTIAL DATA CORRUPTION IF NETWORKING FAILS BETWEEN MEMBERS
IT37339 2 A USER INTERRUPT DURING AN IMPLICIT REBIND WHILE OPENING A CURSOR IN A STORED PROCEDURE MAY CAUSE A TRAP
IT37164 2 POSSIBLE TRAP IN SQLO_SLATCH_CAS64::RELEASECONFLICT WHEN CLEANING UP FEDERATED FMP
IT37196 2 IF NODE FAILURE RECOVERY OCCURS AFTER END OF TRANSACTION, THE NEXT OPERATION CAN RECEIVE SQL1229
IT37100 2 DB2STOP RESULTS IN SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004
IT37240 3 DB2CFEXP FAILS TO EXPORT SSL_CLNT_KEYDB AND SSL_CLNT_STASH DBM CFG PARAMETERS FROM A CLIENT INSTANCE
IT36628 3 ZRC=0XFFFFFFFF=-1 ERROR IN DB2DIAG.LOG WHEN USING PURESCALE WITH SSL
Fix Pack m7fp0  -   Query Compiler Optimizer
IT37511 2 POOR PERFORMANCE OF FEDERATED QUERIES IN CERTAIN CASES
IT37986 2 INSTANCE CRASHED RUNNING A QUERY
IT37081 2 INCONSISTENT OLAP RESULTS ON COLUMNAR TABLES IN AN MPP ENVIRONMENT
IT38246 2 RUNSTATS FAILS DUE TO A DEADLOCK (SQL2310N ERROR "-911" ) ON SYSIBM.SYSCOLGROUPSCOLS WHEN COLLECTING COLUMN GROUP STATISTICS.
IT36903 2 -901 ERROR WITH REASON "NO PLAN FOUND"
IT35804 2 SEGV OCCURS WHILE PREPARING A QUERY WITH AN XML PREDICATE THAT CONTAINS ANY EMPTY STRING LITERAL, RESULTS IN SQL1224N.
IT37540 2 SQLCODE: -901 AND FODC_TRAP: ASSERTIONFAILEDEXCEPTION: AN ASSERT ION 'MCSETEMPMAP.FIND(CSETEMPNAME) == MCSETEMPMAP.END()' FAILED.
IT38508 2 EXCESSIVE QUERY COMPILATION TIME WITH A VERY LONG SELECT DISTINCT COLUMN LIST AND VERY MANY COLUMN GROUPS
IT37911 2 INNER JOIN OF AT LEAST 4 COLUMN-ORGANIZED TABLES MIGHT RETURN WRONG RESULTS UNDER SPECIFIC CONDITIONS
IT37236 2 EXPLAIN_FROM_SECTION RETURNS SQL0220N FOLLOWING UPGRADE TO DB2 V11.5.5 DESPITE RUNNING DB2EXMIG
IT37168 3 DB2EXFMT TRAPS WHILE PROCESSING A QUERY CONTAINING HEXADECIMAL VALUES
Fix Pack m7fp0  -   Query Compiler QGM
DT146904 1 QUERY PERFORMANCE IS SUB-OPTIMAL WHEN SCROLLABLE CURSORS ARE USED WITH COLUMN-ORGANIZED INDEX SCANS
IT38400 1 INCORRECT RESULT WHEN DB2 QUERY HAS EXISTS SUB QUERY WITH IS NULL PREDICATE
IT38558 1 SECURITY: INDIRECT READ ACCESS TO A TABLE THAT THE USER IS NOT AUTHORIZED TO SELECT FROM (CVE-2021-38931)
IT37556 2 GRPBY INTRODUCED IN V11.5.5.X ACCESS PLAN CAUSED SQL16003N
IT38549 2 WRONG RESULT WHEN SUBSELECT WITH SCALAR AGGREGATE REFERENCED MULTIPLE TIMES
IT36276 2 UNEXPECTED SQL0206N FROM FEDERATED VIEW USING WITH CLAUSE.
IT38832 2 DB2 QUERY MAY PERFORM POORLY WHEN NULL PRODUCING SIDE OF OUTER JOIN IS ON BASE TABLE.
IT38829 2 DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONS AND SCALAR AGGREGATIONS
IT35385 2 QUERY COULD FAIL WITH -901 WHEN MQT IS USED
IT38344 2 SQL0901N ERROR CODE RETURNED WHEN CASTED MEMORY TABLE JOINING ON VARCHAR COLUMNS
IT36016 2 ABSTRACT: -901 ERROR WITH REASON PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP RETURNS IN QUERY COMPILATION.
IT37785 2 TRAP IN FUNCTION SQLNR_JOINPPD_COND WHEN RUNNING UPDATE STATEMENT
IT36743 2 PREVENT PUSHING DOWN LARGE IN LIST PREDICATES TO UNION BRANCHES.
IT37889 2 DB2 QUERY MAY ABEND OR RETURN A SQL 901 WHEN USING A CORRELATED COMMON TABLE EXPRESSION
IT38399 2 WRONG RESULT WHEN DB2 QUERY HAS CORRELATED EXISTS PREDICATE
IT38833 3 DB2 QUERY PLAN DOES NOT CHOOSE INDEX WHEN IN PREDICATE HAS PARAMETER MARKER.
IT37626 3 ERROR SQL0102N RETURNED WHEN DB CFG VARCHAR2=ON, STMT_CONC=LITERALS AND STRING_UNITS=CODEUNITS32
IT37632 3 DB2 QUERY MAY ABEND WHEN EXPRESSION REFERENCED FROM MQT
Fix Pack m7fp0  -   Relational Data Services
IT37102 1 APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED
IT37425 2 FODC TRAPS WHEN USING DPF, COLUMN ORGANIZED TABLES AND ARRAY INPUT
IT36825 2 SQLTEMPSPACE OR AGGSQLTEMPSPACE THRESHOLDS DO NOT WORK WITH ROWSTORE OLAP OPERATORS THAT SPILL TO DISK.
IT38229 2 LOCKTIMEOUT(VIRTUAL DEADLOCK) OCCURRED ON GLOBALPKGLOCK
IT38355 2 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
IT38660 2 MEMORY CORRUPTION DETECTED IF CONNECTION CONCENTRATOR IS ENABLED
Fix Pack m7fp0  -   Sailfish Operational Compatibility
IT37275 2 EXTERNAL TABLE CAN FAIL WHEN A LARGE INPUT FILE CONTAINS STRING DATA THAT HAS AN ESCAPED QUOTE IN THE QUOTED STRING.
IT37266 2 EMPTY STRING INSERTED AS NULL WHEN USING QUOTEDVALUE
IT37938 2 EXTERNAL TABLE CAN FAIL WHEN A LARGE INPUT FILE CONTAINS STRING DATA THAT HAS AN ESCAPED QUOTE IN THE QUOTED STRING.
IT38968 2 INSERT BINARY DATA INTO EXTERNAL TABLE RETURNS ERROR SQL0901N
IT38472 3 EXTERNAL TABLE FIXED FORMAT LOAD OF NEGATIVE BIG INTS FAILING
Fix Pack m7fp0  -   Security
IT37939 4 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE (CVE-2021-29678)
IT36906 4 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE UNDER SPECIFIC CONDITIONS (CVE-2021-29763)
IT36907 4 SECURITY: IBM DB2 IS VULNERABLE TO WEAK FILE PERMISSIONS ALLOWING ACCESS TO SPECIFIC FILES (CVE-2020-4976)
IT37254 4 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE (CVE-2021-29752)
IT38561 4 SECURITY: INDIRECT READ ACCESS TO A TABLE THAT THE USER IS NOT AUTHORIZED TO SELECT FROM (CVE-2021-38931)
IT38196 2 ADD SUPPORT FOR FIPS MODE OF OPERATION TO LINUXPPC64LE
IT37032 2 IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG
IT38170 2 GROUP LOOKUP FAILING FOR GROUPS THAT CONTAIN LARGE NUMBER OF USERS
IT36961 2 FOR SSL CONNECTIONS ONLY, AUTHENTICATION CACHE IS NOT ABLE TO PERFORM USER OR GROUP LOOKUP
IT36847 2 WHEN DB2_ALTERNATE_GROUP_LOOKUP=GETUSERATTR, A USER'S PRIMARY GROUP MAY NOT BE REPORTED BY DB2.
IT35907 2 NO AUDIT OF START HADR AND STOP HADR
IT38481 2 PKCS11 DRIVER MAY RETURN UNEXPECTED ERROR CODES WHEN HSM SESSION IS CLOSED
IT37184 3 WHEN TRUSTED CONTEXT IS DROPPED, SETSESSIONUSER PRIVILEGES ARE ALSO DELETED
Fix Pack m7fp0  -   Text Search
IT37498 2 TEXT SEARCH UPGRADE FROM 11.1 TO 11.5.5.1 DOES NOT UPDATE SYSIBMTS.SYSTSDEFAULTS
Fix Pack m7fp0  -   XML
IT38624 2 ENGINE CRASH IN XMLRNNODEMGR::FETCHTEMPNODE()
Fix Pack m7fp0  -   pureScale Services
IT39233 2 DATABASE CREATE FAILS WITH SQL2049N RC=2 WHEN DB2_DATABASE_CF_MEMORY BEING SET TO 0
IT37578 2 NEW ENVIRONMENT VARIABLE TO TUNE WAIT TIMES BETWEEN UDAPL API CALLS ( LINUX ON IBM Z SYSTEMS ONLY )
IT39252 3 DB2HAICU -REMOTE_ENABLE MAY FAIL WHEN REMOTE HOST USES NLS MESSAGES
IT36213 3 REMOVE IRRELEVANT ALERT ABOUT NETWORK INTERFACE: 'VIRBR0' WHEN USING PURESCALE ON REDHAT
IT39261 3 IMPROVE ERROR MESSAGE WHEN PUTTING CLUSTER IN TO MAINTENANCE MODE WITHOUT DB2CLUSTER -ALL OPTION.
IT33256 3 DB2CLUSTER -LIST -ALERT CAN FAIL TO LIST AN ALERT IN CERTAIN TRANSIENT STATES
IT37136 3 SQL1659 IS NOT RETURNED EVEN WHEN A RDMA DEVICE CANNOT BE OPENED DURING DB2START, AND DB2DIAG.LOG IS SPAMMED WITH ERROR MESSAGES

DB2 Version 11.5 Fix Pack m6fp0
APAR Sev. Abstract
IT35576 3 HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN A DISTRIBUTED TRANSACTION
IT37301 3 DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY WILL FAIL WITH AN SQL2079N ERROR, IN VERSION 11.1.4.4.
IT37079 3 COUNT DISTINCT QUERIES AGAINST COLUMNAR ORGANIZED TABLES COULD RETURN INCORRECT RESULTS
IT35926 3 WRONG RESULT WITH MULTIDIMENSIONAL CLUSTERING (MDC) TABLE AND ZIGZAG JOIN (ZZJN)
IT36093 3 DB2_FMP_COMM_HEAPSZ VALUES GREATER THAN 1GB NOT HONORED
IT36323 3 MEMORY BLOCK FREED TWICE IN SQLOFMBLKEX
IT36128 3 ERROR -901 IN CONCATINFO.HPP ENCOUNTERED WHILE RUNNING A QUERY
IT36937 3 IF ROW BEING SORTED IS VERY WIDE MEMORY OVERWRITES OR WRONG RESULTS ARE POSSIBLE.
IT36948 3 RARE TRAP IS POSSIBLE DURING COLUMNAR HASH JOIN .
IT33777 3 BUILD IN FUNCTION "DATE_PART" MIGHT RETURN AN INCORRECT RESULT OF WEEK, I.E. DATE_PART('WEEK', '2020-03-09')
IT35943 3 QUERIES REFERENCING AN EXISTS SUB-QUERY WITH FETCH FIRST 1 ROW R EFERENCED IN A CASE STATEMENT IN THE SELECT LIST MAY RESULT IN I
IT35891 3 WRONG RESULT MIGHT BE RETURNED WHEN SUBSTR WITH IF ELSE CLAUSES WAS USED AND THE COLUMN WAS CREATED IN CODEUNIT32
IT36753 3 IN SOME RARE CASES, A SORT ON A COLUMNAR TABLE CAN HANG
IT36467 3 A TRUNCATE TABLE STATEMENT ON A COLUMN ORGANIZED TABLE WITH LOBS MAY RETURN SQLCODE -964 (TRANSACTION LOG IS FULL).
IT36572 3 FEDERATED QUERY MULTIBYTES CHARACTERS RETURNING '001A' USING THE ODBC WRAPPER
Fix Pack m6fp0  -   Administration Tools
IT35682 2 POSSIBLE FMPTRAP IN CHECK_CREATE() WHEN RUNNING DB2LOOK IF AN OBJECT GETS DROPPED WHILE THE TOOL IS RUNNING
IT32728 2 PERIODIC TASKS THAT RUN THROUGH DB2ACD ARE NOT EXECUTED AFTER HADR FAIL OVER
Fix Pack m6fp0  -   Buffer Pool Services
IT33546 2 QUERIES MIGHT HANG IN UOW-EXEC WAITING ON SQLO_LT_SQLB_HASH_BUCK ET_GROUP_HEADER__GROUPLATCH IN SQLBFINDPAGEINBPORSIM FUNCTION
IT34100 2 REDIRECT RESTORE FAILS AFTER SET TABLESPACE CONTAINERS USING AUTOMATIC STORAGE
IT33688 2 ROLLFORWARD CAN RESULT IN SQL1042C AFTER SET TABLE SPACE CONTAINERS USING AUTOMATIC STORAGE
IT36166 2 DATABASES CREATED WITH "AUTOMATIC STORAGE NO" MAY CORRUPT STORAGE GROUP FILES AFTER UPGRADE
IT36337 3 PREFETCHERS INFINITELY LOOPING IN SQLBSERVICELEAFREQUEST
Fix Pack m6fp0  -   CDE Data
IT33760 1 SEGV OR PANIC WHILE DOING PARALLEL INSERTS
IT36327 1 AUTO REORG..RECOMPRESS AND ONLINE BACKUP CANNOT BE RUN CONCURRENTLY
IT36818 1 POSSIBLE DATA LOSS IF DELETE AND RUNSTATS/REORG ARE IN A SINGLE TRANSACTION AND THE TRANSACTION IS THEN ROLLEDBACK
IT34924 2 DB2DART AND INSPECT COMMANDS FOUND ERROR TYPE VARIABLE-LENGTH DA TA AT OFFSET XXXX IS READ INCORRECTLY. THE EXPECTED OFFSET IS 0
IT36476 2 HANG DURING INSERT FROM NODES SENDING HISTOGRAMS
IT35949 2 OUT OF MEMORY: SIGNAL #11 DATABASETABLEACCESSOR::DESTROYDELETEREPLICATOR
IT36396 2 -901 APPERR WHEN INSERT INTO <TABLE> AFTER TRUNCATE <TABLE>WITHOUT IMMEDIATE CLAUSE
Fix Pack m6fp0  -   CDE Query
IT34991 2 QUERY WITH OLAP MIGHT FAIL WITH SQL0955C IN CDE
IT35973 2 NESTED IN PREDICATES CAUSES -901 ERROR
IT36924 2 IN A RARE SCENARIO THE ERROR COULD BE LOST AND INSTEAD EITHER NULL OR SQL0901N RETURNED
IT36311 2 WHEN RUNNING NLJN AGAINST COLUMNAR TABLES IT IS POSSIBLE TO GET SQL0901N ERROR
IT32579 3 VALUE OF STATISTIC COLUMN AVGENCODEDCOLLEN IS INCORRECTLY COLLECTED DURING THE LOAD
Fix Pack m6fp0  -   Client Interfaces
IT36757 2 CLR PROCEDURE ABORTS ABNORMALLY WITH ERROR SQL1024N WHEN IT USES IBM.DATA.DB2 .NET PROVIDER
IT35180 2 BOOLEAN DATA TYPE GETS TRANSLATED AS SHORT-TEXT IN MS-ACCESS VIA ODBC
IT36275 2 UNCATALOG SYSTEM ODBC DATA COURCE <DSN> FAILS WITH DB21036E
IT33194 2 IN CERTAIN TIMING CONDITIONS, CLI CLIENT ACR CAN FAIL TO REROUTE CONNECTIONS
IT36235 2 PRECOMPILER STRIPS C STYLE COMMENTS FROM SQL, CANNOT USE INLINED OPTIMIZATION GUIDELINES
IT34587 3 DB2TRC FMT -CLI CRASHES ON WINDOWS FOR SQLFREEHANDLE API
Fix Pack m6fp0  -   Codegen and Runtime
IT33610 2 POSSIBLE FLOODING OF DB2DIAG.LOG FILE WITH MESSAGES FROM 'SQLNLSICUCONVERTTOMERIDIANFORMAT()'
IT37253 2 IN SOME CASES, WLM THRESHOLDS FOR TEMP SPACES IS CALCULATING INCORRECTLY
IT35994 2 TRAP IN SQLNGREORDERAGGOPS WHEN ATTEMPTING TO COMPILE A JASON ARRAY
IT35984 2 A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT
IT36245 2 SQL QUERY MAY BE SLOW WHEN USING DBMS_LOB.SUBSTR FUNCTION IN A VIEW
IT33282 2 DB2 MIGHT SHUTDOWN WHEN HANDLING A REGULAR EXPRESSION (REGEX) IN SQLRI_REGEXP_LIKE_LONG_BODY() WITH INVALID DATA
IT34764 2 SLOW PERFORMANCE IN REGULAR EXPRESSION FUNCTIONS ON BIG ENDIAN PLATFORMS
Fix Pack m6fp0  -   DB2 Tools
IT35061 2 WHEN A USER ID WITH INSUFFICIENT PRIVILEGE ATTEMPTS TO RUN REORG FROM WITHIN A STORED PROCEDURE, THE STORED PROCEDURE RETURNS RC
Fix Pack m6fp0  -   DRDA Services
IT36026 1 SECURITY: IBM DB2 IS VULNERABLE TO A DOS WHEN A TABLE IS DROPPED WHILE BEING ACCESSED IN ANOTHER SESSION (CVE-2021-29777)
IT36201 2 A CLIENT MAY ABEND IN FUNCTION SQLXAPREPARECOMMIT
Fix Pack m6fp0  -   Data Management Services
IT34966 1 SECURITY: DB2 EXTERNAL TABLE CREATION IS VULNERABLE TO RACE CONDITION ATTACK
IT34964 1 SECURITY: IBM DB2 IS VULNERABLE TO AN ARBITRARY FILE OVERWRITE
IT36525 1 TRAP IN FUNCTION SQLPLRL WHEN DROPPING A SYSTEM TEMPORARY TABLE CREATED BY A QUERY RUNNING ON A HADR STANDBY
IT34381 2 A DEADLOCK MAY RESULT WHEN MULTIPLE APPLICATIONS CONCURRENTLY INSERT INTO A COLUMN-ORGANIZED TABLE WITH AN IDENTITY COLUMN
IT35993 2 ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG
IT33456 2 DB2 MIGHT HANG IN PURESCALE SETUP UNDER A MEMORY CONSTRAINED SITUATION
IT31723 3 LOB PAGES MAY NOT BE REUSED PROPERLY IN PURESCALE.
IT35082 3 HIGH CPU AND DECREASED PERFORMANCE WITH HIGH CONCURRENCY OF INDEX CREATION (ON TEMP TABLES)
Fix Pack m6fp0  -   Data Management Utilities
IT36770 2 IMPORT MAY BE TERMINATED IF SQL0437W IS DETECTED, ALTHOUGH IT CAN BE IGNORED IN MOST SCENARIOS.
IT35679 3 UNDER CERTAIN CONDITIONS, THE "NUMBER OF ROWS ..." MESSAGE FROM INGEST UTILITY ARE INCORRECT.
IT34197 3 DB2 MIGHT REPEATEDLY REPORT ISSUS IN SQLSMERGEREC
Fix Pack m6fp0  -   Data Recovery Services
IT34889 2 DB2ADUTL DELETE LOGS WITHOUT PROMPTING" DELETES LOGS ONE BY ONE AND THEREFORE SLOWER THAN DELETING LOGS IN BATCH
IT36461 2 ACTIVATE DATABASE ON ONE MEMBER IN PURESCALE HUNG WHEN ANOTHER MEMBER IS EXECUTING CREATE INDEX ON HADR PRIMARY DATABASE
IT35714 2 PERFORMANCE OF DB2LOGGR MIGHT BE AFFECTED DUE TO UNNECESSARY SYMBOL RESOLUTION IN SQLPGRENAMEFILEDURINGLOGRECLAIM
IT36569 2 DB2FLSN TOOL INCORRECTLY DISPLAYS "N/A" AS THE MAXIMUM LSN FOR A LOG FILE INSTEAD OF THE ACTUAL MAXIMUM LSN VALUE.
IT35119 2 RESTORE USING "NO ENCRYPT" FROM A DOWNLEVEL ENCRYPTED BACKUP IMAGE WILL RESULT IN DB STILL BEING ENCRYPTED
IT36140 2 PERFORMANCE IMPACTS WITH HUGE AMOUNT OF ROW LOCKS
IT36820 2 DB2ADUTL FAILS TO READ DB CONFIG ON PURESCALE OR DPF ON NODES OTHER THAN CATALOG NODE
IT33960 2 SQL0206N OR SQL0901N ON STANDBY AFTER ALTER TABLE ADD COLUMN ON PRIMARY WHEN HADR IS STOPPED
IT36378 2 DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT.
IT31624 3 REDIRECT RESTORE WITH REBUILD OPTION FAILS WITH SQL2025N
IT35695 3 INCORRECT HADR_TARGET_LIST CONFIGURATION IN PURESCALE CAN RESULT IN UNEXPECTED SQL1776 RC 6
IT35161 3 DB2CKLOG PASSES BUT RETURNS MESSAGES APPEARING TO BE ERRORS
IT37302 3 HADR TAKEOVER FAILED WITH SQL1770 RC 7 DUE TO EVENT MONITOR BLOCKS FORCING OFF ONLINE REORG ON PRIMARY
IT34547 4 DIA8550C MESSAGES FILLING UP DB2DIAG.LOG WHEN LOG PATH IS MAPPED TO AN UNC PATH IN WINDOWS ENVIRONMENT
Fix Pack m6fp0  -   Engine Other
IT36334 3 ERROR LOG MAY BE CONTINUE TO GENERATE IN HADR CONFIGURED BY PACEMAKER ON AWS.
Fix Pack m6fp0  -   Federation
IT36252 1 ROLLBACK THE FIX OF MARIADB LENGTH(CHAR) PUSHDOWN
IT36413 1 SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2
IT36279 1 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739)
IT35685 1 QUERY WITH 'ORDER BY' AND REFERENCING A COMMON SUBEXPRESSION OVER COLUMN-ORGANIZED TABLES MAY RETURN ROWS IN THE WRONG ORDER
IT34670 2 ACCESSING HIDDEN COLUMNS WITH FEDERATION RECEIVES SQL0206N
IT36474 2 WILD POINTER REQUEST->AGT_RUNTIME_OBJ IN SQLQG_SIGNAL_HANDLER LEADS TO DATABASE CRASH
IT33184 2 THE MARIADB COLUMN LENGHT IS OVER 32K, BUT THE IMPORT FILE ONLY HAS 32768 CHARACTERS.
IT33052 2 WITH FEDERATION FUNCTION, IT IS POSSIBLE THAT INSERT STATEMENT WILL GET SQL1476N.
JR63711 2 DV ISSUE: PUSHDOWN ISSUE FOR DB2 AND ORACLE JDBC WRAPPER
IT36387 2 A FODC FMP TRAP IS REPORTED IN SQLQG_GET_TOSENDDATALEN WHILE QUERYING FEDERATION NICKNAMES
IT34402 2 FEDERATION MARIADB CURRENT TIMESTAMP "GETTING PARAMETER TYPE METADATA ARE NOT SUPPORTED" ERROR SQL1822
IT33183 2 FEDERATION SERVER ODBC WRAPPER FETCHES KOREAN CHARACTERS FROM MARIADB, BUT RETURNS UNREADABLE TEXT.
IT36380 2 GET_CODEPAGE IS CALLED FOR EVERY PARAMETER MARKER WHICH CAUSED BAD PERFORMANCE IN DRDA WRAPPER
IT36199 2 POSSIBLE DB2FMP TRAP IN SQLQG_FMP_RUNTIME_OBJECT::GET_RSTATE_INF O() WHEN RUNNING FEDERATED QUERY
IT35805 2 MULTI-THREADED DB2FMP TRAPPED IN SYBASE CALLS INTERMITTENTLY
Fix Pack m6fp0  -   Index Manager
IT36812 2 INSTANCE MAY CRASH WITH SQLIDUMPINXCURSOR ON THE STACK WHEN DUMPING FODC DIAGNOSTICS (-901 OR TRAP)
IT36449 2 DB2 PREP COMMAND FAILS WITH THE ERROR SQL0318N WHEN THE VALUES CLAUSE CONTAINS THE KEYWORD FOR.
IT36256 3 DB2 PREP COMMAND FAILS WITH SQL4003N 'THE SQL STATEMENT IS NOT SUPPORTED ...' OR SQL0104N 'UNEXPECTED TOKEN ...' ERROR
Fix Pack m6fp0  -   Install and Catalog Services
IT36454 2 SQL0901N - INVALID FEDERATED THREE PART NAME
IJ21543 2 DB2PREREQCHECK SHOULD NOT CHECK MODPROBE FILE WHEN USING MELLANOX CX-4 IB/ROCE CARD ON LINUX PLATFORM
IT25907 2 -P <PORT> PARAMETER IS BEING IGNORED BY DB2ICRT
IT34619 2 ENHANCEMENT: SETUP.EXE CHECKS CURRENT DIRECTORY NAME WHETHER IT HAS SPACE(S) OR NOT ON WINDOWS
IT35734 2 SYSCODEPROPERTIES CONTINUONSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING
IT36376 2 EXPORT RETURNS SQL0204N "SYSTEM.SYSCAT.FUNCTIONS" IS UNDEFINED.
IT33815 3 REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR
IT34188 3 DB2LOOK CREATEDB OR PRINTDBCFG PARAMETERS DON'T REPORT THE ACURATE VALUE IN DB2LOOK FOR STRING_UNITS .
IT36468 3 REPLAY OF REVOKE ON HADR STANDBY WITH READS ON STANDBY ENABLED MAY RESULT IN A SMALL MEMORY LEAK
IT31631 3 CREATE .PROFILE IF IT DOESN'T EXIST WHEN RUNNING DB2ICRT (CREATE INSTANCE)
IT34384 4 DB2PREREQCHECK CHECKS FOR JAVA, BUT WE BUNDLE JAVA WITH DB2
Fix Pack m6fp0  -   Monitoring
IT36150 2 ADMIN_MOVE_TABLE CANNOT BE USED TO MOVE TABLE HAVING DOUBLE QUOTES IN NAME
IT36521 2 SQL405N REPORTED BY DB_MEMBERS AND DB_PARTITIONS TABLE FUNCTIONS IF NETNAME EXCEEDS 128 CHARACTERS IN DB2NODES.CFG
IT34510 3 DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION
Fix Pack m6fp0  -   Parsing and SQL PL
IT30559 2 DB2 MAY ABEND WHILE COMPILING COMPOUND SQL (COMPILED) STATEMENTS
Fix Pack m6fp0  -   Platform Specific
IT33313 2 "DB2" FRONT END PROCESS DOES AN UNNECESSARY INTERNAL INITIALIZATION WHICH MIGHT CAUSE A PERFORMANCE DEGRADATION
IT36041 3 ALTER TABLESPACE WITH NO FILE SYSTEM CACHING OPTION FAILS ON LINUX390
IT35710 3 INTERMITTENT FAST PREALLOCATION FAILURES ON AIX
Fix Pack m6fp0  -   Problem Determination
IT36266 2 INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS
IT34869 2 DB2PD -DBPTNMEM CAN CRASH IF USING USING MEMBER NUMBERS GREATER THAN 9
IT35318 2 LARGE PRIVATE MEMORY LEAK WHEN PD_GET_DIAG_HIST IS INTERRUPTED PROCESSING A LARGE DB2DIAG.LOG OR NOTIFY FILE
IT37300 3 NO OUTPUT RETURNED USING PD_GET_LOG_MSGS OR PDLOGMSGS_LAST24HOURS ON WINDOW ENVIRONMENT
Fix Pack m6fp0  -   Process Model
IT36331 1 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND
IT36504 2 WHEN THE DBNAME DOES NOT MATCH THE DBALIAS HADR FAILS TO START ON THE PRIMARY
IT35376 2 DB2 MIGHT CAUSE EXCESSIVE LOGGING (SQL0952N MESSAGES) WHEN A QUERY IS INTERRUPTED.
IT36821 2 SET EVENT MONITOR STATE STATEMENTS MAY BE INCORRECTLY QUEUED BY THE ADAPTIVE WORKLOAD MANAGER
IT36833 2 OCCURS ON PARTITIONED DATABASE, DB2 MAY CRASH WHEN TRYING TO UNLATCH A LATCH THAT IS NOT HELD
IT33580 2 INCORRECT ESTIMATION OF PARTITIONS WHERE QUERY MAY EXECUTE MAY CAUSE EXCESSIVE QUEUING WITH THE ADAPTIVE WORKLOAD MANAGER
IT36862 2 POSSIBLE 15 SECOND DELAY IN SQLEPEEKREQUEST
IT33410 2 SQL1041 DB2 NOT FOLLOWING NUMDB SETTING
IT34227 3 ADMIN_CMD AND GET_DB_CONFIG CANNOT HANDLE EXTENDED NUMBER RANGE OF LOGBUFSZ
IT35832 3 SQLCODE -1229 CONTINOUSLY WRITTEN IN DB2DIAG.LOG AFTER NODE FAILURE
IT36113 3 V11.5.5 ONLY: DB2ADUTL COMMAND FAILS WITH SQL1031N IN PURESCALE ON ALL MEMBERS EXCEPT MEMBER 0.
Fix Pack m6fp0  -   Query Compiler Optimizer
IT36104 1 DB2ADVIS WILL THROW A -901 ON A QUERY THAT IS ORDERED BY AN EXPRESSION
IT35953 1 INSERT FROM COMPLEX SELECT WITH ORDER BY IN DPF MODE MIGHT LEAD TO SEGV TRAP
IT34668 1 INSERT INTO COLUMN-ORGANIZED TABLE FROM COMPLEX SUBSELECT CAN TRAP DURING QUERY OPTIMIZATION
IT34102 2 CURSOR-BASED UPDATE OR DELETE OF ROWS ON A TABLE WITH A RCAC DEFINED MAY LEAD TO A TRAP
IT35309 2 DYNAMIC QUERY EXECUTION FAILS WITH SQLCODE -901 REASON CODE "CONSTANT OF UNSUPPORTED TYPE"
IT35997 2 SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR
Fix Pack m6fp0  -   Query Compiler QGM
IT34871 2 USING WRONG DELIMITER MIGHT CAUSE THE INSTANCE CRASH
IT35066 2 LPAD OR RPAD BUILTIN FUNCTION FAIL WITH -901 "VALUE IS TOO LARGE FOR THE BUFFER"
IT35055 2 DB2 SERVER TERMINATES ABNORMALLY WHEN AUTO_REVAL=DEFERRED_FORCE
IT36401 2 901-COLUMN NUMBER OUT OF RANGE DURING QUERY COMPILATION, FORM_CSE CALL STACK
IT34347 2 MONTHS_BETWEEN FUNCTION IN NPS MODE RETURN NEGATIVE
IT33192 2 DB2 QUERY MAY ABEND WHEN THERE ARE COMMON TABLE EXPRESSION USED IN UNION
IT36384 2 UPDATE STATEMENT WITH IN/EXISTS MAY GENERATE SQLCODE -913
IT36742 2 SQL0901N WHEN DB2 QUERY HAS CDE TABLE AND JOIN PREDICATE HAS TYPE MISMATCH
IT35085 2 DB2 SERVER MAY TERMINATE ABNORMALLY WITH SQLDCSL_BADPAGE "BAD DATA PAGE"
IT36106 2 SQL0901 ON SELECT SAMPLE.TEST FOR SYSTEM_TIME BETWEEN
IT35059 2 LPAD, RPAD OR REPLACE MAY RESULT IN SQLCODE -901 WHEN SOURCE-STRING REFERENCES A COLUMN-ORGANIZED TABLE COLUMN
IT30018 2 DB2 MAY RUN OUT OF STATEMENT HEAP WHILE COMPILING QUERIES INVOLVING UNIONS AND PREDICATES WITH WEAK UDTS
IT36441 3 DB2 QUERY PERFORMS BAD WHEN USING SUBQUERY PREDICATE WITH OR
IT36498 3 DB2 MAY RETURN -901 WHEN IMPLICITLY CASTING NON-STRING TO A STRING AND THE ENVIRONMENT DEFAULT STRING UNITS ARE CODEUNITS32.
IT35058 3 SUBSTR IN COLUMN ORGANIZED COLUMN COMPARISON RETURN WRONG RESULTS
IT36473 3 TRUNCATE TABLE WITHOUT IMMEDIATE ON CDE TABLES WITH DELIMITED IDENTIFIERS FAILS
IT36320 3 QUERY EXECUTION MAY FAIL FOR OUTER JOIN QUERIES WITH PREDICATES WITH CAST FUNCTIONS
IT35062 3 CREATING AN EXPRESSION-BASED INDEX FAILS WITH -356 AND EMPTY REASON CODE
IT36388 3 UNEXPECTED SQL206 WHEN COLUMN NAME OR COLUMN NAME QUALIFIER HAS TRAILING SPACES
IT33287 3 WRONG RESULT/901 WHEN IN USED ON SELECT
Fix Pack m6fp0  -   Relational Data Services
IT36046 2 PANIC MAY OCCUR IN HADR TAKEOVER
IT36853 2 DB2AGENT REPORTED SQLD_PARM ERROR WHEN TRUYING TO FIND/FIX TCB WITH OBJECTID=0
IT35518 2 DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE
IT34418 2 QUERY INTERRUPT DOES NOT RETURN SQL0952N WHEN A WLM THRESHOLD WAS CREATED
IT32552 2 MULTIPLE SEVERE/INFO MESSAGES WITH -803 COULD BE RECORDED IN DB2DIAG.LOG AND MAY AFFECT PERFORMANCE
Fix Pack m6fp0  -   Sailfish Operational Compatibility
IT36751 1 EXTERNAL TABLES WITH LFINSTRING OPTION MAY FAIL IF DATA CONTAINS A FIELD INCLUDING A NON ESCAPED DELIMITER CHARACTER
IT35075 2 SELECTING FROM AN EXTERNAL TABLE THAT USES LFINSTRING ON CAN FAIL WITH SQL5199N
Fix Pack m6fp0  -   Security
IT36475 1 SECURITY: IBM DB2 IS VULNERABLE TO AN INFO. DISC. FOR USERS WHO CREATE AN INLINE SQL FUNC. WHEN AUTO_REVAL SET TO DEFFERED_FORC
IT40980 2 Security: IBM Db2 may be impacted by a Denial of Service
IT36418 2 LDAP PLUGIN NOW ALLOWS CONFIGURATION TO CHECK LDAP PASSWORDPOLICYRESPONSE
IT36177 2 WHEN USING GSSPLUGIN IBMIAMAUTH.SO CRASHES DB2
Fix Pack m6fp0  -   pureScale Services
IT36431 2 DB2CLUSTER -VERIFY FAILURE DUE LATE SERVER STARTUP
IJ27796 2 "LIST INDOUBT TRANSACTIONS" COMMAND PERFORMANCE IMPROVEMENT WITH PURESCALE.
IT29557 2 MORE ROBUST CLEANUP STATUS CHECKING
IT35801 2 MISMATCH THAT THE OS HOSTNAME VALUE IS LOWER-CASED WHEREAS THE H ADR_LOCAL_HOST/HADR_REMOTE_HOST VALUES ARE UPPER-CASED. THIS SHO
IT37103 2 PURESCALE DELETE ROWS PERFORMANCE REGRESSION ON RDMA NETWORKS
IT35828 3 "DB2CLUSTER -CFS -SET -OPTION CCRENABLED -VALUE NO" COMMAND TIMES OUT
IT36816 3 DB2CLUSTER -CFS -EXIT -MAINTENANCE MAY FAIL WITH RC=2
IT36894 3 "TOO MANY ARGUMENTS" MESSAGE WHEN RUNNING DB2CM -CREATE -DB IN HADR WITH PACEMAKER WITH MULTIPLE STANDBY SETUP
IT36393 3 CIB ATTRIBUTE FAILED TO SET DURING PRIMARY REBOOT
IT36457 4 AFTER A REBOOT, HADR DATABASE MAY FAIL TO BE ACTIVATED BY AUTOMATION.

DB2 Version 11.5 Fix Pack m5fp1
APAR Sev. Abstract
IT35883 3 INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE
IT34960 3 DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS.
IT32664 3 XML INDEXES NOT USED IN DB2 11.5 EXPLAIN PLAN
IT35798 3 SLOW PERFORMANCE IN DPF OR CDE WHEN RUNNING A QUERY WITH SCALAR SUBQUERIES AND AN OUTER JOIN
IT34748 3 UPDATE STATEMENT SLOW PERFORMANCE CAUSED BY LATCH CONTENTION DURING THE MEMORY ALLOCATIONS.
IT35017 3 CDE JOIN MINMAXINFO DUMP: TRAP DUE TO DEREFERRENCING NULL POINTER
IT35185 3 DB2 MIGHT TRAP IN SQLRWTABLEMETRICSBUILDER::EXECUTE DURINGEXECUTION OF THE MON_GET TABLE FUNCTION
IT35705 3 DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE
IT35439 3 DB2ADV_VPC.LIC CAN MAKE Q REP FUNCTIONS AVAILABLE, IT IS NOT THE EXPECTED RESULT
IT36027 3 IMPROVEMENTS TO CDE JOIN MEMORY USEAGE. REDUCTION OF MEMORY NEEDED AND REDUCTION OF -955 ERRORS.
IT33529 3 PRESENCE OF CANDIDATE ACCESS PLAN WITH SINGLE-NODE HASH-DIRECTED PARTITIONING PREVENTS OPTIMAL PLAN WITH REPARTITIONED JOIN
IT35680 3 HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR
IT34693 3 DB2UNINS OF DATA SERVER CLIENT REMOVES SHARED C++ REG KEYS
IT34396 3 PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING
IT34242 3 BAD PERFORMANCE DUE TO DELAYED JOIN PREDICATE PUSHDOWN THROUGH UNION ALL PREVENTS JOIN ELIMINATION
IT35833 3 SQL1585N IS INCORRECTLY RETURNED FOR CERTAIN TYPES OF QUERIES
IT34658 3 DB2 QUERY MAY GENERATE FODC AND APP_ERR OR WRONG RESULT IN CERTAIN CONDITIONS
IT35047 3 MGB:STORED PROCEDURE CALLS PERFORMANCE ARE SIGNIFICANTLY WORSE AFTER MIGRATION
IT34559 3 ELEMENT ALLOCATION ISSUE, AND ONE OF THE VECTORS WAS MESSED UP AND CAUSE TRAP/SEGFAULT.
IT31536 3 MON_GET_LOCKS FAILS IN DPF WITH SQL1607N BECAUSE OF UNDERLYING RPC MECHANISM BEING LIMITED TO 2 GIGABYTES
IT34108 3 NLJN NOT PUSHING DOWN
IT35033 3 CUSTOMERS ENCOUNTERING ASN0569E DUE TO OUT-OF-ORDER REPLICATION LOG RECORDS DURING SAVEPOINT ROLLBACK
IT35728 3 SQL0407N WHEN COMMON SUBQUERY HAS VALUES
IT35548 3 HADR STANDBY FORCE DB SHUTDOWN, DB2DIAG.LOG SHOWS OBJECT IS NOT MARKED PENDDEL
IT35739 3 DB2 QUERY MAY NOT GENERATE TRAILING SPACE WHEN MINUS/EXCEPT IS USED IN THE QUERY.
JR62967 3 DB2 V11.5 QUERY PLAN WITH "UNION ALL" IS DIFFERENT FROM QUERY PLANS IN V11.1
IT35880 3 DB2 11.5 PERF DEGRADATION ON LINUX: O_SYNC AND NOT O_DSYNC USED
IT35992 3 SQL0811N WHEN THERE IS SCALAR SUBQUERY WITH FETCH FIRST 1 ROWS
IT36210 3 IN VERY RARE CASE OF CDE RIGHT OUTER JOIN PROCESSING TRAP IS POSSIBLE.
IT35399 3 FEDERATED SERVER OPTION CONCURRENT_ACCESS_RESOLUTION='W' CAUSES CLI019E INVALID ATTRIBUTE ERRORS
Fix Pack m5fp1  -   Abstract Data Types and Spatial Extender
IT35444 2 MULTIPLE MEMORY LEAKS IN GEO-SPATIAL CALLS WHEN EXECUTING CERTAIN GEO-SPATIAL FUNCTIONS
Fix Pack m5fp1  -   Buffer Pool Services
IT33994 2 DB2 MAY HANG SHORTLY AFTER COMMITTING A CREATE TABLE WITH AN AGE NT WAITING FOR SQLO_LT_SQLD_TCB__LOADINPROGRESS LATCH IN SQLBFIX
IT36108 2 INTERRUPTING ALTER TABLESPACE REDUCE MAY CAUSE A MEMBER SHUTDOWN
Fix Pack m5fp1  -   CDE Data
IT35182 2 CLEANUP OF IN-MEMORY STRUCTURE WHEN LOADING OF THE DICTIONARY FAILS (ADD CODE TO HANDLE EXCEPTIONS GRACEFULLY).
IT34037 2 DEADLATCH BETWEEN ONE THREAD WRITING A DICTIONARY TO DISK USING VECTORIZEDADC AND ANOTHER THREAD DOING A NEW EXTENT ALLOCATION
Fix Pack m5fp1  -   CDE Query
IT35163 1 DB_MIGRATE HANGS WHEN USING ORDER BY CLAUSE
IT36230 2 DB2 TRAP IN FUNCTION EXTRAPAYLOADITERATOR::COPYPAYLOADSTO
IT35211 2 POSSIBLE SIGSEGV IN Q REPLICATION DUE TO INCORRECT LOG RECORDS FOR COLUMN-ORGANIZED DGTT IN DPF ENVIRONMENT
IT35158 2 REDUCE LIKELYHOOD OF SQL0954C FOR COLUMNAR ORGANIZED HSJN PLANS
Fix Pack m5fp1  -   Client Interfaces
IT35521 1 CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS
IT34606 2 USING CFGREFRESHINTERVAL IN A MULTI-THREADED CLI APPLICATION LEADS TO SEGMENTATION FAULT
IT34589 2 ON WINDOWS PLATFORM CLIDRIVER CAN LOG SQL1531N DURING CONNECT EVEN WHEN CONNECTION IS SUCCESSFUL WITH SQL_SUCCESS_WITH_INFO
IT35405 3 CAN'T CONNECT TO DB2 VIA EXCEL 2016 USING DATA --> ?GET EXTERNAL DATA? WHEN UPGRADING RUNTIME CLIENT TO 11.5
Fix Pack m5fp1  -   Codegen and Runtime
IT35377 2 WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATAPART TABLE ON THE INNER AND NULL KEYS.
IT35486 2 DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG. JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT.
IT34579 3 DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY FAIL WITH SQL2079N ERROR
Fix Pack m5fp1  -   Communication
IT35289 1 SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND (CVE-2020-5024)
IT34882 2 INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL
IT34504 2 GSKKM_STORECACERT: GSKIT ERROR = 100 ERRORS IN DB2DIAG.LOG
Fix Pack m5fp1  -   DRDA Services
IT35750 2 THE FUNCTION WHICH TESTS THE 'FAILOVER' MEMBER DOES NOT TAKE SSL INTO ACCOUNT.
IT34432 2 FAILBACK PING INCORRECTLY USES TCPIP INSTEAD OF SSL
Fix Pack m5fp1  -   Data Management Services
IT34294 1 SECURITY: IBM® DB2® IS VULNERABLE TO A DENIAL OF SERVICE ON WINDOWS (CVE-2020-4642)
Fix Pack m5fp1  -   Data Management Utilities
IT35936 2 DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATAPART FUNCTION
IT35965 3 REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN
Fix Pack m5fp1  -   Engine Other
IT35987 2 "114 ATTEMPT TO ACCESS ITEM BEYOND BOUNDS OF MEMORY" ERROR OCCURED IN 32 BIT MODE.
Fix Pack m5fp1  -   Federation
IT33598 2 INSERT STATEMENT FAILS WITH -901 ERROR USING FEDERATION
IT35968 2 WHILE QUERYING THE WEB SERVICE NICKNAME, FEDERATION SERVER REPORTS ERROR SQL1822N
IT34588 2 SQL30090N WHEN WE USE UPDATE WITH PLACEHOLDER (VARIABLE) VIA JDBC
IT35226 2 CREATE OR REPLACE NICKNAME ON REMOTE DB2I SERIES (AS400) FAILS WITH SQL0901 AND DUMP FOLDER FODC_APPERR IS CREATED
JR62802 2 PROBLEM RUNNING UPDATE ON MARIADB (FEDERATION)
IT34941 2 QUERY ON NICKNAME RESULTS WITH VALUES TRUNCATED ON MARIADB
IT34862 2 DB2 CRASH DUE TO A -901 WAS RAISED BY MINMAXPARTIALEVALUATOR.CPP WHEN MAX(TO_CHAR()) OR MIN(TO_CHAR()) EXISTS IN THE SELECT LIST
Fix Pack m5fp1  -   Install and Catalog Services
IT35672 2 UPDATING NETNAMES HIT ISSUE SAYING RSCT PEER IN REGISTRY DOES NOT MATCH ACTIVE DOMAIN NAME
IT33810 2 INVALID LICENSE ERROR USING DB2 CONNECT LICENSE WITH .NET CLI DRIVER ON OPENSHIFT CONTAINER
Fix Pack m5fp1  -   Platform Specific
IT34929 2 ADD ENVVAR TO OVERRIDE WINDOWS COMMONAPPDATA PATH
Fix Pack m5fp1  -   Problem Determination
IT33783 2 DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H (TIME PERIOD SPECIFIERS)
Fix Pack m5fp1  -   Process Model
IT34261 1 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND
Fix Pack m5fp1  -   Query Compiler Optimizer
IT35198 1 A QUERY ON COLUMNAR TABLES MAY RETURN MORE ROWS THAN EXPECTED
IT35183 2 POOR QUERY PERFORMANCE WHEN IN SUBQUERY PREDICATE WITH NO DISTINCT.
Fix Pack m5fp1  -   Query Compiler QGM
IT34950 1 DB2 SERVER TERMINATES ABNORMALLY WHEN SELECT FROM INVALID VIEWS
IT34758 2 SELECT DISTINCT QUERY FAILS WITH SQL0421 WHEN USED WITH SCROLLABLE CURSOR
IT35670 2 REGEXP_REPLACE AND REGEXP_SUBSTR WITH COLUMN-ORGANIZED TABLE MAY RESULT IN -901
IT34613 2 INCORRECT RESULTS WITH DB2_EXTENDED_OPTIMIZATION='MQTENFORCE REPLICATED'
IT35925 2 DISTRIBUTION KEY ORDER IS NOT INHERITED FROM THE AS-RESULT-TABLE WHEN COISBAR IS ENABLED
IT34311 2 QUERY WITH ALIAS FOR COMPLEX COLUMN USED IN GROUP BY CLAUSE TRAPS AND GENERATES FODC
IT34860 2 DB2 QUERY MAY HANG WITH REGISRTY SETTING INJ_DUMMY_PRD4JOIN
IT34304 2 SQL0344N ERROR MAY OCCUR IN NON-UNICODE, VARCHAR2 ENABLED DATABASE WHEN QUERY REFERENCES SYSIBM.SYSDUMMY1 OR SYSIBM.DUAL
IT34222 3 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE
IT34940 3 WRONG RESULT WHEN EQUALITY PREDICATE HAS IS NOT NULL WITH FALSE ON OTHER SIDE.
Fix Pack m5fp1  -   Relational Data Services
IT33355 2 DEADLOCK BETWEEN INVALIDATION OF PACKAGE AND IMPLICIT REBIND OF THE SAME PACKAGE.
IT35546 2 -901 SQLCODE DURING REBIND FOR PACKAGES BOUND WITH CERTAIN BIND OPTIONS
IT34671 2 MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK
IT33429 2 SQL1598N MIGHT BE RAISED IF A LICENSE WAS NOT APPLIED BEFORE SIMULTANEOUS ATTEMPTS TO CONNECT THROUGH THE DATA SERVER DRIVER
IT35221 2 WLM ADMISSION CONTROL DOES NOT PROPERLY TRACK ACTUAL MEMORY HIST ORY FOR SHORT QUERIES. THIS CAN LEAD TO UNNECESSARY QUEUING OF V
Fix Pack m5fp1  -   Sailfish Operational Compatibility
IT35770 2 OOM HIT WHILE RUNNING ET NZ INTERNAL FORMAT MIGRATION.
IT35855 2 MEMORY LEAK ENCOUNTERED WHEN YOU HAVE MORE THEN 1COLUMN OF SAME TYPE FROM TIMESTAMP/TIME/DATE WITH DB2 FORMAT SPECIFIED FOR IT
IT35165 2 DB_MIGRATE ISSUE WITH INTERNAL FORMAT WHEN INPUT STRING AFTER CODEPAGE CONVERSION EXCEED THE TARGET COLUMN SIZE.
Fix Pack m5fp1  -   Security
IT35445 1 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT36060 2 IN RARE INSTANCES, DB2 11.5.5 MAY CRASH DURING DB2START WHEN JWT AUTHENTICATION IS ENABLED
IT36085 2 DB2 11.5.5 MAY ENCOUNTER SQL30082N RC 15 WHEN USING GSS_SERVER_ENCRYPT OR KRB_SERVER_ENCRYPT AUTHENTICATION
Fix Pack m5fp1  -   pureScale Services
IT36088 1 DB2CLUSTER -VERIFY MIGHT FAIL DURING RDMA PING DUE TO SEG FAULT
IT36086 1 DB2CLUSTER -VERIFY POTENTIAL HANG
IT35303 1 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35552 2 CF CHANGE TO ADD BREATHING POINT FOR DAT_EVD_DEQUEUE
IT35558 2 SIGNAL 11 TRAPS DURING CTSNAPS AFTER ROCE CABLE PULLS
IT35662 2 CREATE TABLE STATEMENTS ARE HANGING DUE TO RDMA COMMUNICATION TIMEOUTS BETWEEN MEMBER AND CF ON ZLINUX

DB2 Version 11.5 Fix Pack m5fp0
APAR Sev. Abstract
Fix Pack m5fp0  -   1
IT33863 3 PURESCALE MEMBER MIGHT HANG WAITING FOR SQLO_LT_SQLB_BPD__BPDLAT CH_SX WHILE IN SQLBGBUPGRADELATCHFROMSHAREDURINGWAR
IT33576 3 REDUCE CHANCE OF SQL0289N
IT33525 3 INACCURATE RESULT OF DECIMAL DIVISION ON NON-AIX PLATFORM
Fix Pack m5fp0  -   Administration Tools
IT34534 3 DB2 ADMINISTRATIVE TASK SCHEDULER STOPS EXECUTING SCHEDULED TASKS
Fix Pack m5fp0  -   Buffer Pool Services
IT34560 2 DB2 ENGINE ABEND FOLLOWING DROP TABLE AND SQLBPREPARE2FREEEXTONTEMPSMP SEVERE ERROR
Fix Pack m5fp0  -   CDE Data
IT33714 1 RUNNING REPLICATED CDE WORKLOAD WITH INVALID DB2_DCC_FILE_PATH VALUE WILL CAUSE DB2 TO FAIL WITH SQL1224.
IT33570 2 A CDE UPDATE STATEMENT MIGHT FAIL WITH SQL0901N '!ISROWLOGBUFFERINITIALIZED()' AND TRAP IN SQERDFSROWSERIALIZER
IT34280 2 CREATE TABLE FAILING WITH "NO MEMORY AVAILABLE IN 'APPLICATION HEAP'
IT34500 2 REORG RECLAIM CODE CAN LEAD TO DEADLATCH
IT33707 2 FODC_FORCEDBSHUTDOWN OCCURS AFTER AN INSERT STATEMENT IS INTERRUPTED AND ATTEMPTS TO ROLL BACK.
Fix Pack m5fp0  -   CDE Query
IT34026 2 INSTANCE COULD GO DOWN WHEN DOING A FULL OUTER JOIN ON TWO COLUMNAR ORGANIZED TABLES WITH NULL COLUMNS
IT34235 2 IMPROVE PERFORMANCE BY IMPLEMENTING SCALAR FUNCTIONS DAYOFMONTH, DAYS_TO_END_OF_MONTH IN COLUMNAR ORGANIZED LOGIC.
IT34147 2 VARIOUS ERROR POSSIBLE: SQL0901N , SQL0955N
IT33467 2 CDE HSJN WITH RESIDUAL PREDICATES THAT HAVE SCALAR FUNCTION APPL IED TO A HOST VARIABLE OR REGISTRY VARIABLE COULD FAIL WITH -901
IT33293 2 QUERY FAILING WITH SQL0901N AND AN ASSERTION FAILURE "UNABLE TO ACCESS TARGET PAGE FROM PAGE MAP"
Fix Pack m5fp0  -   Client Interfaces
IT33902 2 INTERMITTENT FAILURE WITH CLR_EXCEPTION_SYSTEM.OBJECTDISPOSEDEXCEPTION
IT31498 3 SQL2731N WHEN AN INPUT FILE SIZE OF ZLOAD IS BIGGER THAN 4GB
IT32956 3 DB2 .NET PROVIDER WITH DOUBLE HYPHENS (--) STYLE COMMENT IN SQL STATEMENT HAVING NAMED PARAMETERS THROWS SQL0206N
IT32276 3 NO SQL OVERFLOW ERROR WHEN INSERTING A DECIMAL(20,4) THAT DOES NOT FIT INTO A SMALLINT OR INTEGER COLUMN
IT33640 3 IBM DATA SERVER ADD-INS FOR VISUAL STUDIO (VSAI) DOES NOT SHOW NON-TABLE SCHEMAS
Fix Pack m5fp0  -   Codegen and Runtime
IT33578 2 OPTIMIZE THE PERCENTILE_CONT AGGREGATE FUNCTION TO USE MEMORY MORE EFFICIENTLY AND SPILL TO TEMP IF REQUIRED
IT33236 2 COMPLEX QUERIES WITH EXISTS CLAUSE ON A COLUMNAR TABLE EXECUTED WITH DEGREE GREATER THAN 1 MAY HANG
Fix Pack m5fp0  -   Data Recovery Services
IT32894 1 DB2 : SET WRITE RESUME COMMAND HANGS
IT34022 2 DB2 MIGHT TRAP WHEN EXECUTING MON_GET_UNIT_OF_WORK
IT33533 3 SQL0913 RC=80 NOT BEING CAPTURED BY DB2PDCFG -CATCH LOCKTIMEOUT
IT32560 3 ILOGS ARE ARCHIVED TO BOTH LOG ARCHIVING METHODS ONLY FROM THE ACTIVE LOG PATH WITH DUAL LOGGING ENABLED
Fix Pack m5fp0  -   Federation
IT32523 1 PRIVATE MEMORY LEAK DURING DDL ON COLUMN-ORGANIZED TABLES IN DPF ENVIRONMENT
JR62529 2 QUERIES ON NICKNAMES TO TABLE ON MARIADB RETRIEVES ONLY FIRST CHARACTER OF COLUMN NAMES
JR62557 2 FEDEATION MARIADB JDBC: DATA TYPE MAPPING ERROR
JR62556 2 INSERT INTO SELECT ERROR ON JDBC
Fix Pack m5fp0  -   Index Manager
IT31287 1 DB2 MAY TRAP WHEN USING SELECT RID_BIT() FUNCTION ON A COLUMN ORGANIZED TABLE
Fix Pack m5fp0  -   Install and Catalog Services
IT33705 1 AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES
IT32984 1 SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4411)
IT32939 1 SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4412)
IT34221 1 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT
IT33708 2 DB2ICRT FAILS WHEN CHECKING GPFS ON PURESCALE
IT33515 2 AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERR ORS AND ENGINE CRASHES
IT34039 2 TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS FOR CDE TABLE MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT.
IT32679 2 ROUTINE MIGRATION FAILS WITH A SQL0478N WHEN A ROUTINE IS USED AS PART OF A TABLE DEFINITION
IT33548 2 AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERR ORS AND ENGINE CRASHES
IT33712 3 COMPLETE FIX FOR IT13674
IT33312 3 DB2ICRT AND DB2PREQCHECK FREE SPACE AND HOST FAILURE
Fix Pack m5fp0  -   JDBC Driver
IT32581 3 CLPPLUS 11.5 CLIENT THROWS EXCEPTION SQL20570N WITH EXTERNAL TABLE OPERATION HAVING EMPTY FILE WITH GZIP COMPRESSION
IT33041 3 JCC DRIVER NOT SENDING COMMIT AFTER THE LICENSE SP CALL EVEN IF AUTOCOMMIT IS TRUE
IT33602 2 INSERT FROM EXTERNAL TABLE FAILS WITH SQLCODE -4499 -T2LUW
Fix Pack m5fp0  -   Monitoring
IT34023 2 FODC_PANIC WITH INVALID LATCH FROM SQLOLATCHCAS64.C WHEN ROUTINE EXECUTION LIST MONITORING IS ENABLED.
IT33264 3 CAPTURE_STORAGE_INFO MAY FAIL WITH SQL0443N
Fix Pack m5fp0  -   Parsing and SQL PL
IT34440 2 ABNORMAL TERMINATION WHEN EXECUTING THE CREATE-STATEMENT OF A NZPLSQL STORED PROCEDURE
IT33885 3 DB2 MAY ATTEMPT TO REPEATEDLY OPEN A NON-EXISTENT FILE WHICH MAY IMPACT QUERY COMPILATION PERFORMANCE
Fix Pack m5fp0  -   Platform Specific
IT34140 1 SQL20569N WITH REASON CODE "4" DURING LOADING LZ4 COMPRESSED
IT34101 3 FMP PROCESS CAN HANG IN NESTED SIGNAL HANDLER CODE PATH
Fix Pack m5fp0  -   Problem Determination
IT33783 2 DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H (TIME PERIOD SPECIFIERS)
Fix Pack m5fp0  -   Process Model
IT33508 1 IN DPF ENV, SORTSHRHEAPUTIL THRESHOLD MAY NOT TRIGGER PREDICTIVELY FOR QUERIES USING SORT MEMORY ON DATA NODES
IT34607 2 DB2CFIMP ADDS TRAILING CHARACTERS TO DB ALIAS.
IT33186 2 LOCK-WAIT ON DECOUPLED DB2ADCBLD
IT34257 2 DB2 WLM MAY CAUSE UNNECESSARY QUEUING AFTER INSERTS TO EXTERNAL TABLES IN A PARTITIONED DATABASE
IT34284 2 SORT MEMORY HARD CAPPING AND OVER-ESTIMATION ERROR CORRECTION FIXES IN WLM
IT33826 2 LIST STORAGE ACCESS COMMAND GIVES 0 ENTRIES EVEN IF THE CATALOG STORAGE ACCESS COMPLETED SUCCESSFULLY
Fix Pack m5fp0  -   Quality Assurance
IT34614 4 SECURITY: MULTIPLE BUFFER OVERFLOW VULNERABILITIES AFFECT DB2
Fix Pack m5fp0  -   Query Compiler Optimizer
IT33554 2 SQL0901N PARTITIONED BLU SORT WITH 0 PARTCOLS IS UNEXPECTED
IT34007 2 DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE.
IT33338 2 COLUMNAR SEARCHED UPDATE AND DELETE STATEMENTS EXECUTING WITH HS JOIN THAT APPLIES RESIDUAL PREDICATES MIGHT FAIL WITH SQL0901N "
Fix Pack m5fp0  -   Query Compiler QGM
IT32992 1 WRONG RESULT, WHEN OPTIMIZATION LEVEL IS LESS THAN 5 AND NULL EQUALS NULL PREDICATE
IT34308 2 REPLICATED MQT MATCH MAY FAIL IN SOME SPECIFIC SITUATIONS
IT33171 2 WRONG RESULT WHEN QUERY HAS SCALAR SUBQUERY AND FETCH FIRST 1 ROW
IT34382 2 POOR PERFORMANCE WHEN IN-LIST TO JOIN CAUSING EARLY COMPENSATION
IT33459 2 FIX ISSUES WITH OPTIMIZER VERSION CONTROL (DB2_OPTIMIZER_VERSION REGISTRY VARIABLE)
IT33527 2 POOR PERFORMANCE OF DB2 QUERY HAVING IN SUBQUERY PREDICATE
IT34115 2 INCORRECT QUERY OPTIMIZATIONS RESULTING IN POOR PERFORMANCE OCCUR WHEN STATEMENT CONCENTRATION IS ENABLED
IT32923 2 DB2 MAY ABEND WHEN COLUMN ALIAS USED IN PREDICATE.
IT33870 2 SQL901 WHEN SUBQUERY PREDICATE USED WITH OUTER JOIN
IT32640 2 QUERY FAILS WITH SQL0901 "NO CAST FUNCTION" WHEN DB2_ENABLE_MULTIPLE_CCSIDS=TRUE, DATABASE IS UNICODE
IT33577 2 PERFORMANCE: NEQN (I.E. NULL EQ NULL) PREDICATES NOT DETECTED BY MAGIC DECORRELATION
IT34078 2 DB2 MAY NOT GENERATE TRAILING SPACE AFTER GROUP BY
IT33822 2 HANG IN WHERE ALIAS DUE TO CYCLIC REFERENCE.
IT34222 3 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE
IT33557 3 USING "ISNOTTRUE" OR "ISNOTFALSE" ROUTINES WITH DECFLOAT DATA TYPE RETURNS SQL0440N
IT33871 3 DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE
Fix Pack m5fp0  -   Relational Data Services
IT33691 1 ON DPF INSTANCE APPLICATIONS MAY HANG WHILE DOING A COMMIT
IT34110 2 -901 SQLCODE (CANNOT FIND CURSOR INFO IN ERT) FOLLOWED BY TRAP
Fix Pack m5fp0  -   Routine Infrastructure
IT34156 2 ALLOW FMP POOLING FOR SPECIFIC USER IDS
Fix Pack m5fp0  -   Sailfish Operational Compatibility
IT34151 2 USING PIPE INTERFACE DURING UNLOAD OPERATION IF PIPE IS USED
IT33740 2 CREATE EXTERNAL TABLE USING SAMEAS/LIKE WITH BASE TABLE HAVING HIDDEN COLUMN IS GETTING CREATED WITH HIDDEN COLUMN
IT33615 2 SQL20570N WHILE LOADING EMPTY FILE USING OPTION REMOTESOURCE GZIP SAME WORKS FINE WITH LZ4
IT34356 2 FMP TRAP WHILE USING -FORMAT INTERNAL DUE TO SCHEMA MISMATCH
Fix Pack m5fp0  -   Security
IT34107 2 HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLE AND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES
Fix Pack m5fp0  -   pureScale Services
IT33790 3 DB2AUTOSTART DOES NOT WORK ON REBOOT WHEN OS REBOOT IS VERY FAST.
IT33851 3 TSA INITIATED TAKEOVER IN AN AUTOMATED HADR ENVIRONMENT MAY FAIL DUE TO PEER WINDOW HAVING EXPIRED.

DB2 Version 11.5 Fix Pack m4fp0
APAR Sev. Abstract
Fix Pack m4fp0  -   Buffer Pool Services
IT32436 2 HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR
Fix Pack m4fp0  -   CDE Data
IT30387 1 DB2 MIGHT HANG WITH AN EDU WAITING ON SQLO_LT_SQLD_CHAIN__FULLCH AINLATCHNS WHILST HOLDING SQLO_LT_SQELOCALDATABASE__DBLATCH
IT33198 2 IN DB2 V11.5 GA, SQL0901N ERROR MAY OCCUR WITH DB2DIAG.LOG SQLER RMC "UNEXPECTED ERROR AT SYNOPSISTABLETUPLEACCUMULATOR.HPP:130"
Fix Pack m4fp0  -   CDE Query
IT32589 1 CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON
IT31975 2 SELECT WITH SUBSTRING() RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN
IJ24133 2 WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N.
Fix Pack m4fp0  -   CLI
IV98044 2 NEW MONGODB CLIENTS ARE UNABLE TO CONNECT TO IBM JSON WIRE LISTENER
IT31045 3 BULKCOPY ERROR WHILE CHAIN INITIALIZATION WITH NULL VALUE FOR DECIMAL COLUMNS
IT33421 2 SQLGETCONNECTATTR() FUNCTION CALL WITH SQL_ATTR_GET_LATEST_MEMBER_NAME TAKING TIME DUE TO GETADDRINFO TAKING MORE TIME
IT30451 2 NOT ABLE TO LOAD AND USE THE DB2CLIO.DLL
IT33461 3 ERROR ENCOUNTERED WHILE FETCHING SMALLINT DATA USING IBM DATASERVER PROVIDER FOR ENTITY FRAMEWORK CORE
Fix Pack m4fp0  -   Codegen and Runtime
IT32599 2 QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW
IT32367 2 SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB
Fix Pack m4fp0  -   Communication
IT32766 1 SECURITY - DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK
IT32357 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
Fix Pack m4fp0  -   DRDA Services
IT32363 2 SECURITY: IBM® DB2® LUW IS VULNERABLE TO A DENIAL OF SERVICE ATTACK
Fix Pack m4fp0  -   Data Management Services
IT33146 1 DB2 SERVER TERMINATES ABNORMALLY DURING ROLLFORWARD RECOVERY IN THE SQLPLRQ FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET.
IT33218 1 DB2 SERVER TERMINATES ABNORMALLY IN THE SQLDFETCHLARGEROW FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET.
IT30494 2 CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY
Fix Pack m4fp0  -   Data Recovery Services
IT33172 3 SLOW DATABASE RECOVERY LOG REPLAY ON A WORKLOAD WITH MANY DDLS SPECIFICALLY CREATE / ALTER / TRUNCATE / DROP TABLE
Fix Pack m4fp0  -   Install and Catalog Services
IT31637 1 SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204)
IT32256 2 DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY
IT31741 2 DB2PREREQCHECK FILLS UP / AND /TMP DUE TO SCP TSAMP WITH UNNECES SARY FILES DURING PURESCALE INSTALLATION OR DB2IUPDT COMMAND
IT31588 3 WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID
IT32751 2 HADR STANDBY FAILS WITH "BAD ENTRY STATE" REPORTED FROM SQLRLC_AUTH_GR_PROCESS_ENTRY_STATE
Fix Pack m4fp0  -   JDBC Driver
IT30972 2 JDBC DRIVER NOT TERMINATING TIMER THREADS WITH VERSION 4.26.14
IT29195 2 CLPPLUS DOES NOT RUN THE LOGIN.SQL SCRIPT DURING STARTUP.
IT32580 2 INTRODUCED A NEW PROPERTY USEJDBC4DATATYPE IN JCC DRIVER AS IT IS NOT BACKWARD COMPATIBLE FOR CLOB/CHAR/VARCHAR DATA TYPE.
IT31612 3 PIGGYBACK COMMANDS ARE NOT REPLAYED IF FAILURE HAPPENS DURING FIRST SQL EXECUTION IN CASE OF NON-SEAMLESS FAILOVER
IT33042 2 DB2STOP MEMBER CAUSED JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION
Fix Pack m4fp0  -   Monitoring
IT31573 2 DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH.
Fix Pack m4fp0  -   Platform Specific
IT31704 2 MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES
IT32507 3 ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID()
Fix Pack m4fp0  -   Problem Determination
IT32716 1 SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE AND DENIAL OF SERVICE
IT32689 1 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE
IT32714 1 SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE
Fix Pack m4fp0  -   Process Model
IT32439 1 INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES
IT31679 3 DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH
IT31378 2 DB2STOP FAILS WITH SQL6037N, LEAVING [DB2SYSC]<DEFUNCT>
Fix Pack m4fp0  -   Query Compiler Optimizer
IT32195 2 IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS
Fix Pack m4fp0  -   Query Compiler QGM
IT31557 2 SQL1224N AFTER CERTAIN OUTER JOIN QUERIES
IT32731 2 DB2 SERVER TERMINATES ABNORMALLY DURING QUERY COMPILATION
IT28109 2 INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION?
IT32612 2 -901 ERROR IS HAPPENED(BAD PLAN; UNRESOLVED QNC FOUND) WHEN EXECUTING PACKAGE REBIND IN V11.5.
IT31862 2 TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE
IT31634 2 WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION.
Fix Pack m4fp0  -   Relational Data Services
IT31701 1 APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS
Fix Pack m4fp0  -   Routine Infrastructure
IT32126 2 MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO
Fix Pack m4fp0  -   Sailfish Operational Compatibility
IT32568 2 FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH
Fix Pack m4fp0  -   Text Search
IT31755 2 THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000
Fix Pack m4fp0  -   pureScale Services
IT31054 3 EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING"
IT31454 3 EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING"

DB2 Version 11.5 Fix Pack m3fp0
APAR Sev. Abstract
Fix Pack m3fp0  -   Buffer Pool Services
IT31892 1 CRASH RECOVERY CAN FAIL AFTER INCORRECTLY REPLAYING EXTENT MOVEMENT LOG RECORDS WITH LARGE RECOVERY WINDOW
IT32436 2 HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR
Fix Pack m3fp0  -   CDE Data
IT31385 3 INCORRECT CALCULATION OF COLUMNAR-ORGANIZED TABLE SPACE CONSUMPTION IN TBPSIZE_ENTITLEMENT_REQ.SQL
Fix Pack m3fp0  -   CDE Query
IT32589 1 CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON
IT31975 2 SELECT WITH SUBSTRING() RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN
IT31628 2 SQL STATEMENT WITH ORDER BY ACCESSING COLUMNAR TABLES MAY BE HUNG IN DPF
IJ24133 2 WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N.
IT31619 2 IN DPF AGAINST COLUMNAR TABLES WRONG RESULT IS POSSIBLE FOR SQL WITH LIMIT WHEN OVER(PARTITION BY) AND ORDER BY IS USED
IT30770 2 SORTHEAP IS TOO SMALL
Fix Pack m3fp0  -   Client Interfaces
IT31515 1 SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK. (CVE-2020-4200)
Fix Pack m3fp0  -   Codegen and Runtime
IT31163 1 WRONG RESULTS ARE POSSIBLE WITH COMPLEX SQL WHICH USES UDFS AND CONSTANTS AND ENCOUNTER A COMPLEX PLAN.
IT31783 2 POSSIBLE TRAP (SEGV) WHEN RUNNING A QUERY ON A NICKNAME POINTING TO A FEDERATED SOURCE AND FEDERATED GOES DOWN.
IT32599 2 QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW
IT32367 2 SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB
Fix Pack m3fp0  -   Data Management Services
IT30494 2 CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY
Fix Pack m3fp0  -   Data Recovery Services
IT30259 2 ROLLFORWARD FAILS DURING LOG CHAIN SWITCH WHEN RUN WITH NORETRIEVE AND OVERFLOW PATH
IT30816 3 MESSAGE PDRECOVERY, PROBE:10 AND PROBE:20 IS LOGGED WITH EACH DIAGEVEL
Fix Pack m3fp0  -   Federation
IT32121 1 SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 LEADING TO DENIAL OF SERVICE OR PRIVILEGE ESCALATION
IT32598 2 [FEDERATION]CREATE NICKNAME FAILS WITH -901 WHEN COLUMN IS DECIMAL(P,S) P>31
Fix Pack m3fp0  -   Install and Catalog Services
IT31637 1 SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204)
IT32256 2 DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY
IT31588 2 WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID
IT31924 2 INVOKE SCP WITH THE -T OPTION DUE TO CVE-2019-6111
Fix Pack m3fp0  -   Monitoring
IT31573 2 DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH.
IT20712 3 SYSIBMADM.LOG_UTILIZATION IS RETURNING SQL0801N ON STANDBY
Fix Pack m3fp0  -   Platform Specific
IT31704 2 MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES
IT31615 2 UNNECESSARY SQLO_BAD_USER LOGGING INTO DB2DIAG.LOG
IT22910 3 PDHADDCOUNTER FAILED WITH OSERR -1073738824IN FUNCTION OSSGETPROCESSRAWCPUUSAGE()
IT32507 3 ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID()
Fix Pack m3fp0  -   Process Model
IT31520 1 SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK (CVE-2020-4135)
IT32439 1 INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES
IT31679 3 DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH
Fix Pack m3fp0  -   Query Compiler Optimizer
IT31132 2 DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN
IT32195 2 IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS
IT30946 2 DB2 MAY ABEND WHILE USING PARTICULAR EXPLAIN MODES
Fix Pack m3fp0  -   Query Compiler QGM
IT29945 1 10 CHAR VALUE CAN BE INSERTED INTO VARGRAPHIC(5 CODEUNITS32). THIS SHOULD FAIL WITH SQL0433N ERROR.
IT31557 2 SQL1224N AFTER CERTAIN OUTER JOIN QUERIES
IT30866 2 DB2 SERVER TERMINATES ABNORMALLY IN SQLNQ_UDF_SPECIFIC WITH STMT_CONC=LITERALS
IT28109 2 INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION?
IT30926 2 TRANSFER OWNERSHIP MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT31862 2 TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE
IT31634 2 WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION.
Fix Pack m3fp0  -   Relational Data Services
IT31701 1 APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS
Fix Pack m3fp0  -   Routine Infrastructure
IT32126 2 MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO
Fix Pack m3fp0  -   Sailfish Operational Compatibility
IT32568 2 FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH
IT31437 2 EMPTY STRING IS NOT INSERTED AS NULL VALUE WHEN NULLVALUE IS EMPTY STRING
Fix Pack m3fp0  -   Security
IT31969 3 EXTRA PRIVILEGES ON NULLID.ATSO05 PACKAGE ARE ADDED TO PUBLIC AFTER RESTORING OLDER RESTRICTIVE DATABASE IMAGE
Fix Pack m3fp0  -   Text Search
IT31755 2 THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000
IT31449 2 INTERMITTENT HANG IN SOCKET SELECT
Fix Pack m3fp0  -   pureScale Services
IT31054 3 EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING"
IT29256 3 DB2INSTANCE -LIST MAY SHOW THE SECONDARY CF IN TRANSIENT ERROR STATE DURING CATCH UP ON BUSY SYSTEMS.
IT31454 3 EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING"

DB2 Version 11.5 Fix Pack m2fp0
APAR Sev. Abstract
Fix Pack m2fp0  -   Buffer Pool Services
IT31716 1 ON RARE OCCASION, DATA CORRUPTION MIGHT BE INDUCED BY FAILURE TO PANIC THE DATABASE ON ENCRYPTION ERROR.
IT30898 2 TABLESPACE CONTAINERS COULD BE DELETED WHEN A STORAGE GROUP EXIST ON DBPATH
IT30326 2 INSTANCE MAY TRAP IN FUNCTION SQLBGETVICTIMFROMBLOCKHATELIST
Fix Pack m2fp0  -   CDE Data
IT31719 2 ADDING A NEW TABLE USE FOR DISABLING VECTORIZED ADC
Fix Pack m2fp0  -   CDE Query
IT31181 2 INSTANCE CAN GO DOWN WHEN COLUMN ORGANIZED TABLES ARE USED
Fix Pack m2fp0  -   Codegen and Runtime
IT29583 2 MEMORY LEAK RELATED TO JSON QUERIES.
IT30005 2 DB2 MAY PRODUCE INCORRECT RESULTS FOR HSJN WITH PREDICATE THAT HAS CASE(COALESCE) AND NLJN OR ZZJOIN ON THE OUTER
IT30456 2 INSERT INTO ... WITH IGNORE DUPLICATES MIGHT FAIL WITH -901 REASON "SQLRIOPN: TABLE IS NOT CREATED"
Fix Pack m2fp0  -   Data Management Services
IT30965 1 AN ISCAN FETCH USING CURRENTLY COMMITTED IN PURESCALE MAY RETURN UNCOMMITTED RESULTS.
IT29634 2 INTERRUPTING ROLLFORWARD OPERATIONS DURING REPLAY CAN CAUSE SUBSEQUENT ROLLFORWARD TO FAIL
IT30061 2 DB2 TAKES Z LOCK WHEN ATTACHING PARTITION TO TABLE
Fix Pack m2fp0  -   Federation
IT30251 1 WRONG RESULTS ARE POSSIBLE FOR FEDERATED OR COLUMNAR QUERY WITH AGGREGATION OVER DISTINCT OUTER JOIN
Fix Pack m2fp0  -   Install and Catalog Services
IT31481 1 SECURITY: DB2 IS VULNERABLE TO A PRIVILEGE ESCALATION ATTACK (CVE-2020-4230)
IT29832 3 TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT.
Fix Pack m2fp0  -   Parsing and SQL PL
IT30157 1 SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR UPD
Fix Pack m2fp0  -   Platform Specific
IT30432 1 SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION (CVE-2019-4587)
Fix Pack m2fp0  -   Query Compiler QGM
IT31140 1 CDE HSJN NOT PICKED UP FOR NON EQUAL PREDICATES(RANGE AND OR PREDICATES)
IT30742 2 QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP"
IT31207 2 INCORRECT RESULT WHEN USING TWICE JOIN WITH THE SAME TABLE WITH GROUP BY
IT31462 2 SECURITY: DB2 IS VULNERABLE TO DENIAL OF SERVICE ATTACK (CVE-2020-4161)
IT30467 2 DB2 MAY PRODUCE INCORRECT RESULTS WHEN EXECUTING QUERIES CONTAINING JOINS WITH DIFFERING FLOATING-POINT PRECISIONS
IT29982 2 DB2 MAY RETURN INCORRECT RESULTS WHEN EXECUTING IUD STATEMENTS CONTAINING A SUBQUERY WITH CORRELATION AND AGGREGATION
IT30740 2 COMMENT ON UNICODE TABLE IN A NON-UNICODE DATABASE RESULTS IN UNREADABLE COMMENT
Fix Pack m2fp0  -   pureScale Services
IT30143 1 SECURITY: DB2 AFFECTED BY BUFFER OVERFLOW VULNERABILITIES (CVE-2019-4584)

DB2 Version 11.5 Fix Pack m3fp0
APAR Sev. Abstract
Fix Pack m3fp0  -   Buffer Pool Services
IT30789 2 ROLLFORWARD MAY FAIL WITH SQL1271W AND SQLB_TBSPACE_TOO_SMALL WHEN REPLAYING AN ALTER TABLESPACE OPERATION
IT30784 2 DEADLATCH BETWEEN AN ONLINE BACKUP, PREFETCHERS AND AN AGENT DOING A WRITE TO THE SAME TABLE SPACE
IT30781 2 FALSE POSITIVE AGAINST BACKUP WITH REGISTRY DB2_BCKP_PAGE_VERIFICATION
IT30798 2 TABLE SPACE RESTORE UNABLE TO USE ALL CONTAINER PATHS AND FAILS WITH DISK FULL
IT30811 3 DB2PD -TABLESPACE DOES NOT INDICATE LOCAL OFFLINE STATE
IT30797 3 EXTENT MOVEMENT RETURNS SQL1523N REASON CODE "15" WHEN EXTENT MOVEMENT NOT RUNNING
IT30796 3 RESTORE OF SMS AUTOMATIC STORAGE TABLE SPACE IN DB2 DEVELOPER-C EDITION FAILS WITH SQL1139N
Fix Pack m3fp0  -   CDE Query
IT30231 1 ENGINE MIGHT TRAP IN IBM_CDE::TYPES::BITSTRING::ANDWITHEXPANDEDCPU
Fix Pack m3fp0  -   Client Interfaces
IT30803 3 INCORRECT LENGTH FOR SQL_LOCAL_LEN AND SQL_CODESET_LEN ON AIX
Fix Pack m3fp0  -   Data Management Services
IT29231 2 UNSUSTAINABLE TRAP CAN OCCUR AFTER A SUSTAINED TRAP IF THERETEMP TABLES ARE USED BY TRANSACTIONS
Fix Pack m3fp0  -   Data Management Utilities
IT30793 1 RESTORING A LOADCOPY WHEN THERE IS A MODIFICATION STATE INDEX ON A COLUMN ORGANIZED TABLE MAY CORRUPT THE INDEX.
IT30807 2 ROLL FORWARD OR CRASH RECOVERY MAY CRASH WHEN WORKING ON INDEX PAGE.
Fix Pack m3fp0  -   Data Recovery Services
IT30786 2 ABNORMAL SHUTDOWN OF DATABASE WHEN LOAD ENCOUNTERS SQLO_NOTAVAIL ERROR IN SQLPUPDATEGLOBALTIMEINGLFH
Fix Pack m3fp0  -   Federation
IT25058 2 FEDERATION QUERY MAY GET SQL0302N DUE TO STRING TRUNCATION WHEN A HOST VARIABLE IS USED FOR A REMOTE COLUMN IN DIFFERENT CODEPAG
IT30799 3 RELAX DB2DIAG.LOG MESSAGE IN SQLSFETCHNEXTTEMPRECORD PROBE 504
Fix Pack m3fp0  -   Install and Catalog Services
IT30778 2 DB2 CRASH ON FUNCTION SQLRL_GET_FULL_NAME()
Fix Pack m3fp0  -   Monitoring
IT29595 2 ADMIN_MOVE_TABLE CONVERTS AUTO CGS STATISTICS PROFILE INTO USER STATISTICS PROFILE
IT30805 2 EM_LIST_LATCH IS GRABBED AND RELEASED FREQUENTLY EVEN THERE IS NO TRANSACTION EVENT MONITOR CREATED/ACTIVE
IT30808 3 DB2 LOCK EVENT MONITOR REPORT: LOCK MODE HELD IS NONE IN PURESCALE
Fix Pack m3fp0  -   Platform Specific
IT30792 1 DB2 MIGHT CRASH IN SQLOFMBLKEX->SQLO_MEM_POOL::MEMTREEPUT WITH "CORRUPT POOL FREE TREE NODE" ERROR MESSAGE IN DB2DIAG.LOG
IT30794 2 CLEANING UP OF EDU CAUSES PRIVATE MEMORY TO LEAK (WINDOWS PLATFORM ONLY)
IT30801 3 STMM REPORTS SEVERE ERRORS ABOUT STMMSIMULATESORTMERGE IN DB2DIAG.LOG
Fix Pack m3fp0  -   Problem Determination
IT30810 2 DB2DART DETECTS ERRORS AFTER UPGRADING
Fix Pack m3fp0  -   Process Model
IT30790 2 DB2LOGGP CAN TRAP WITH SIGNAL #11 IN A FEDERATED ENVIRONMENT
IT21822 4 THE DESCRIPTION OF MAXFILOP IN GET DATABASE CONFIGURATION OUTPUT IS WRONG
Fix Pack m3fp0  -   Query Compiler Optimizer
IT29048 2 HSJN RESID PREDICATE ISSUE, LEADING TO -901 FOR THE CDE QUERY AT PARSERWRAPPER/JOINREWRITER
Fix Pack m3fp0  -   Query Compiler QGM
IT30000 2 DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING EXTERNAL ACTIONS AND CORRELATION
IT28424 3 UNABLE TO CREATE STORED PROCEDURES WITH SAME NAME BUT DIFFERENT PARAMETERS WHEN SQL_COMPAT ='NPS'
Fix Pack m3fp0  -   Relational Data Services
IT30800 2 SECOND EXECUTION OF A CACHED CDE QUERY IN DPF ENVIRONMENT MIGHT LEAD TO SEGV (FODC TRAP) OR FODC MEMORY FOR ILLEGAL REQUEST SIZE
Fix Pack m3fp0  -   pureScale Services
IT30787 2 DB2CLUSTER SEGFAULT CAUSED BY WRONG ARGUMENTS TO PD_HEXDUMP WHEN RUNNING INSTALLFIXPACK ON PURESCALE
IT30788 2 HADR CANNOT BE STARTED DUE TO INSUFFICIENT HADR DATABASE RESOURCE VALIDATION
IT30783 3 A SEGMENTATION FAULT (CORE DUMPED) CAN OCCUR WHEN RUNNING DB2HAICU WITH AN XML INPUT FILE.
IT30809 3 EXTRANEOUS CODE IN THE MOUNTV111_STOP.KSH SCRIPT
IT30806 4 DB2CLUSTER -CM -LIST -TIEBREAKER RETURNS INCORRECT OUTPUT WHEN THE DOMAIN IS STOPPED OR IN MAINTENANCE

Document Location

Worldwide

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PknAAE","label":"Install\/Migrate\/Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF055","label":"zLinux"}],"Version":"11.5.0"}]

Document Information

Modified date:
20 December 2022

UID

ibm11102545