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

Tab navigation

************************************************************
Product Name : DB2 UDB Version 11.5
Updated : Mon Jun 21 09:23:33 EDT 2021
************************************************************

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


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
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
IT34768 2 DOTNET APPLICATION CRASHES WITH ACCESSVIOLATIONEXCEPTION FOR ARRAY INSERT WHEN DB2TRC IS ON
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
IT37369 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
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  -   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
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
IT36334 3 ERROR LOG MAY BE CONTINUE TO GENERATE IN HADR CONFIGURED BY PACEMAKER ON AWS.
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

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
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
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":"BU053","label":"Cloud \u0026 Data Platform"},"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:
24 August 2021

UID

ibm11102545