IBM Support

Fix List for DB2 Version 11.1 for Linux, UNIX and Windows

Troubleshooting


Problem

Db2 11.1 APAR Fix list contains list of APARs shipped for each fix pack in Db2 Version 11.1 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 PMR at the time the APAR was opened.

Resolving The Problem

Tab navigation

************************************************************
Product Name : DB2 UDB Version 11.1
Updated : Wed Feb 27 12:37:52 EST 2019
************************************************************

Select a Fix Pack: m4ifx001 | 4 | m3ifx002 | m3ifx001 | m3fp3 | m2ifx002 | m2ifx001 | m2fp2 | m1ifx001 | 1


DB2 Version 11.1 Fix Pack m4ifx001
APAR Sev. Abstract
Fix Pack m4ifx001  -   Administration Server
IT27210 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
Fix Pack m4ifx001  -   Buffer Pool Services
IT27148 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT28060 1 LOAD OPERATION MAY TRAP OR CAUSE DATA OR INDEX PAGE CORRUPTION IN V11.1.4.4, WHEN READING PAGES FROM 9.7 OR PRIOR RELEASE
Fix Pack m4ifx001  -   CDE Query
IT27216 1 PERFORMANCE REGRESSION IN BLU QUERIES CONTAINING JOIN ON VARCHAR COLUMNS ON AIX
IT27744 1 IF COLUMNAR FUNCTIONALITY IS USED ON A SYSTEM WITH INTEL CPU THAT SUPPORTS AVX-512 THEN WRONG RESULTS ARE POSSIBLE
Fix Pack m4ifx001  -   Client Interfaces
IT27217 1 PSIRT ADVISORY: 14302, PR: 127423 - 3RD PARTY IBM DB2 TOOL DB2CFIMP OPTION FILENAME IS VULNERABLE TO STACK OVERFLOW ATTACK
Fix Pack m4ifx001  -   Codegen and Runtime
IT26992 2 DETERMINISTIC UDF CAN CAUSE INSTANCE TO TRAP
Fix Pack m4ifx001  -   DRDA Services
IT27247 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT27415 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
Fix Pack m4ifx001  -   Data Recovery Services
IT27334 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT27424 2 DATABASE CRASHES WHEN DEFERRED ROLLBACK ENCOUNTERS SQLP_NOSPACE ERROR.
Fix Pack m4ifx001  -   Install and Catalog Services
IT27325 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT27321 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT27433 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT27364 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
Fix Pack m4ifx001  -   JCC
IT27728 2 V11.1M4FP4 JDBC DRIVER (4.25) DOES WORK WITH JAVA8 BUT NOT WITH JAVA6
Fix Pack m4ifx001  -   Platform Specific
IT27361 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
Fix Pack m4ifx001  -   Problem Determination
IT26878 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT26857 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
Fix Pack m4ifx001  -   Process Model
IT27199 1 SECURITY: PRIVILEGE ESCALATION IN ROOT SETUID EXECUTABLES
IT27343 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
Fix Pack m4ifx001  -   Query Compiler Optimizer
IT27331 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
Fix Pack m4ifx001  -   Query Compiler QGM
IJ10883 2 LIKE PREDICATE WITH HOST VARIABLE QUERY REWRITE AND IMPROVED FETCH FIRST N ROWS COSTING FOR COLUMN-ORGANIZED INDEX SCANS
IT27081 2 SAP: SUBOPTIMAL PERFORMANCE FOR QUERIES WITH INEQUALITY PREDICATES ON COLUMNIZED TABLES
IT27712 2 MERGE STATEMENT WITH DISTINCT CAN INCORRECTLY UPDATE MULTIPLE TARGET ROWS
IT27748 2 POSSIBLE TO LOAD BAD ROWS INTO A TABLE WHICH HAS "NOT NULL" GENERATED COLUMNS WHEN COMPUTED GENERATED VALUES ARE NULL
IT26856 2 SAP: SUBOPTIMAL PERFORMANCE DUE TO DISABLED LOTO1 SQL OPTIMIZER FEATURE
Fix Pack m4ifx001  -   Relational Data Services
IT27409 2 CUSTOMER RECEIVES -607 WHEN INVOKING ATS STORED PROCEDURE
IT26455 2 WHEN USING REOPT OPTIMIZER GUIDELINE UPDATES, INSERTS AND DELETES RUNNING IN BATCHES MIGHT INSERT WRONG DATA
Fix Pack m4ifx001  -   Replication
IT27318 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
Fix Pack m4ifx001  -   XML
IT27339 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT27370 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION

DB2 Version 11.1 Fix Pack 4
APAR Sev. Abstract
Fix Pack 4  -   Administration Server
IT26130 1 SECURITY: DB2 DAS PRIVILEGE ESCALATION FROM DAS OWNER TO ROOT VIA SYMBOLIC LINK ATTACK
IT24283 1 SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN THE DB2 DAS COMPONENT ON WINDOWS
Fix Pack 4  -   Administration Tools
IT19890 3 SIGSEGV WHEN USING PARALLEL OPTION OF DB2MOVE
Fix Pack 4  -   Buffer Pool Services
IT26000 1 ONLINE BACKUP FAILS WITH SQL0293N SQLB_CONTAINER_NOT_ACCESSIBLE READING LOB PAGES
IT24105 1 DB2 MIGHT TRAP DURING ROLLBACK OF TRUNCATE TABLE
IT24744 2 CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
IT25027 2 ISSUE NONEXISTENT TABLESPACE IN "SET TABLESPACE CONTAINERS" COMM AND DURING REDIRECT RESTORE LEAK LATCH AND LEAD DATABASE HANG
IT24968 2 CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
IT25867 2 ENCRYPTED PAGE MAY BE LOADED INTO BUFFERPOOL DUE TO INCORRECT ERROR HANDLING
IT23804 2 DB2 RESTORE MAY FAIL WITH ZRC=0X85020024=-2063466460=SQLB_TBLSPC _MAPS_TOO_BIG "MAP TOO BIG"
IT23157 3 SQLO_DISK MISLEADING ERROR MESSAGE IN DB2DIAG.LOG WHEN VERIFYING SMS BAD PAGE.
IT25952 4 DB2V111M3FP3 DPF: GETTING STMM DATABASE NAME IS NOT VALID MESSAGES IN DB2DIAG.LOG
Fix Pack 4  -   Build Team
IT25830 2 SECURITY: VULNERABILITIES IN GSKIT AFFECT IBM SPECTRUM SCALE
Fix Pack 4  -   CDE Data
IT26275 1 UNDER SOME CONDITIONS, A BUFFER OVERFLOW CAN OCCUR WHEN READING FROM BLU PAGES THAN LEADS TO A HANG OR CRASH
IV98007 1 INCORRECT RESULT IN CONCURRENT INSERT/UPDATE ON BLU TABLE
Fix Pack 4  -   CDE Query
IT23521 1 SQL WITH OLAP SPECIFICATION EXECUTED AGAINST COLUMNAR ORGANIZED TABLES COULD PRODUCE INTERMITTENT WRONG RESULT
IJ08700 1 SERVER MAY TRAP RUNNING INSERT INTO TABLE ORGANIZE BY COLUMN ON A DPF PARTITION.
IT25300 1 COLUMN BASED QUERY MAY HANG IF THE QUERY CONTAINS AGGREGATION FUNCTIONS AND DATA EXCEPTION OCCURS
IT24193 1 INTERMITTENT WRONG RESULTS ARE POSSIBLE WITH A PLAN WHERE COLUMNAR EARLY OUT NLJN IS PRESENT
IT25187 2 UDF FUNCTIONS RUN AGAINST COLUMNAR (BLU) TABLES MIGHT RETURN INCORRECT RESULTS
IT26009 2 COLUMNAR ONLY: POSSIBLE WRONG RESULT IN EQUALITY JOIN WHEN COMPARING ZERO BINARY FLOATING POINT VALUE
IT25370 2 POTENTIAL ACCESS VIOLATION IN BANKUNPACKER GETCODES
IT25162 2 SECURITY: DENIAL OF SERVICE WHEN USING TRUNC SCALAR FUNCTION
Fix Pack 4  -   Client Interfaces
IT26296 1 CLP INTERMITTENTLY RETURNS DATE VALUES IN AN INCORRECT FORMAT
IT25765 1 DB2 CLIENT FAILS WITH SIGSEGV OR GIVES SQL ERRORS WHEN EMBEDDEDSQL APPLICATION EXECUTES MULTI ROW INSERT
IT25466 1 SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN DB2CACPY
IT24592 2 EXCEPTION MESSAGES THROWN BY .NET DRIVER ARE INCOMPLETE AND WRONG.
IT25267 2 CALLING STORED PROCEDURE { ? = CALL SOMESPNAME( ?, ?, ?, ?, ? ) } RESULTS IN APPLICATION CRASH 0XC0000005
IT25228 2 DB2 CLIENT CACHE FILE SRVLST.XML SIZE GROWS BY 6 BYTES EVERY TIME WHEN CONNECT TO PURESCALE.
IT24692 2 LOAD COMMAND FAILS WHEN COLUMN NAME COMMENTS IS USED IN TARGET TABLE
IT25633 2 PMR37651,999,000 BOOL DATATYPE MISMATCH B/W MICROSOFT AND DB2 LUW ( DB2 ON CLOUD)
IT23909 3 INTERMITTENT DB21018E ERROR RETURNED TO CLP DURING CONNECTION TO A DATABASE.
Fix Pack 4  -   Codegen and Runtime
IT24956 1 SQL0332N AFTER ALTERING COLUMN LENGTH
IT24407 1 TRAP IN SQLBPFADDTOQ WHEN RUNNING A QUERY INVOLVING A FETCH-IXSCAN PLAN AGAINST A BLU TABLE.
IT24855 1 DB2 MIGHT CRASH
IT24811 2 STEPPING TQS MAY EXPERIENCE A HANG IN SITUATIONS WHEN WE ARE TRYING TO STOP TQ DRAINING AS A PERFORMANCE OPTIMIZATION.
IT25578 2 SQLKD_SYSERR MAPPED TO -902 BY RUNTIME, CAUSING DATABASE MARKED BAD.
IT24955 2 DB2 CRASH IN DPF + SMP AFTER INTERNAL INTERRUPT (SQL0952N)
IT25025 2 DB2 CAN TRAP WHEN USING DBMS_SQL.PARSE
IT24828 2 IUD OPERATIONS AGAINST COLUMNAR TABLES COULD ENCOUNTER AN ABEND WHEN PLAN IS COMPLEX AND NLJN IS PRESENT ABOVE IUD OPERATION
IT24624 2 INSTANCE MAY CRASH IN SQLRH_FREE_HANDLE
IT25651 2 WRONG RESULT IS POSSIBLE WHEN SQL HAS SEVERAL INSTANCES OF SYSIBM.RAND(SEED)
IT25326 2 UNICODE DATA CONTAINING CJK EXT-B FAILS TO CONVERT TO 1392 CODEPAGE
IT24944 2 DATABASE MARKED BAD (SQLO_INV_PARM) ON INTERRUPT IN REGULAR EXPRESSION PROCESSING
IT24205 2 DB2 SERVER COULD CRASH IN RARE SCENARIOS WHEN PLAN HAS STACKED UNIONS
IT24846 3 DBMS_SQL.OPEN_CURSOR CAUSES MEMORY LEAK IN KRCBH POOL
Fix Pack 4  -   DB2 Tools
IT24642 1 SECURITY: DB2CONVERT IS VULNERABLE TO BUFFER OVERFLOW
IT25722 2 NOSQL UPDATE WITH "$SET" COULD UPDATE DATA WITH NULL VALUE AND CAUSE SUBSEQUENT ERRORS
IT24963 2 CHANGE PROBE WARNING IN DB2DIAG.LOG MESSAGE FROM "ERROR" TO "WAR NING" FOR RETCODE : ZRC=0X801A006D=-2145779603=SQLZ_CA_BUILT (WL
IT17464 2 CF MAY CRASH WITH ABORT() AFTER CHANGING CF_LOCK_SZ.
IT25524 3 THE DB2DCLGN TOOL RETURNS INCORRECT OUTPUT FOR COBOL IN ZOS COMPATIBILITY MODE
Fix Pack 4  -   Data Management Services
IT24668 1 HADR STANDBY LOG REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO BAD PAGE WHILE DOING AN INSERT
IT26559 2 WHEN DB2_ONLINERECOVERY FEATURE IS ENABLED, ENCOUNTER DATABASE OUTAGE AFTER CRASH RECOVERY.
IT24954 2 SLOW INSERT PERFORMANCE IN PURESCALE BECAUSE UNCOMMITTED DELETED SLOTS AREN'T REUSED CORRECTLY
IT24847 2 POSSIBLE SIGSEGV IN SQLDRETURNDATA WITH RANGE CLUSTERED TABLES
IT26380 2 DEBUG CODE ADDED WITH IT22695 MAY CAUSE FALSE APPEND CACHE ERRORS
IT25070 3 ADMIN_GET_TAB_INFO WAITING ON REORG TABLE RECLAIM EXTENTS ON ITC TABLE
Fix Pack 4  -   Data Management Utilities
IT20864 2 PLANS CONTAINING MULTI-KEY CHAR SORTS WITH GREATER THAN 500 ROWS ON IDENTITY_16 DATABASES MAY RETURN INCORRECT RESULTS
IT24964 3 LOAD REPLACE RESETDICTIONARYONLY INCORRECTLY REPORT ERRORS IN DB2DIAG.LOG (SQLBSTATEGETCHECK)
IT23816 3 DB2 MAY RETURN STMMSIMULATESORTMERGE ERROR AND NOT BENEFIT FROM SORT MEMORY SIMULATION
IT26085 3 LOAD'S SQL3227W MESSAGE AFTER HITTING WARNINGCOUNT LIMIT MAY GIVE INCORRECT LINE NUMBER
IT22375 3 LOAD COMMAND FAILS AGAINST COLUMN-ORGANIZED TABLES IF DATA BUFFER IS SET TO A LOW VALUE
Fix Pack 4  -   Data Recovery Services
IT24028 1 DB2 LOG REPLAY (RECOVERY, RFWD, HADR) MIGHT HANG WITH DB2REDOM IN SQLPRGETFREEQE->WAIT AND DB2REDOWS IN SQLPRFINDQUEUE->WAIT.
IT25029 2 RESTORE FROM INCREMENTAL BACKUP WITH MULTIPLE STREAMS - DB2 MAY ERROR SQL2032N THE "BUFFER_NUM" PARAMETER IS NOT VALID. SQLSTATE
IT26307 2 TABLE SPACE ROLLFORWARD FAILS WITH SQL0804N DUE TO LARGE TABLE SPACE NAME LIST
IT25956 2 AUTOMATIC RESTORE FEATURE CAN PROVIDE AN INCORRECT SYNTAX IN THE COMMAND PASSED TO DB2
IT23954 2 HADR STANDBY FAILS WITH DBHEAP OUT OF MEMORY UPON RECONNECT
IT26772 2 DB2 SEGV IN DB2HADRP THREAD WHEN COPYING HADR REMOTE HOST TCPIP HANDLE STRING
IT25556 2 DB2 ACTIVE LOGS NOT BEING REMOVED FROM ACTIVE LOG DIRECTORY WHEN NO LONGER NEEDED.
IT24957 2 POSSIBLE TRAP (FODC) IN 'HDREDUACCEPTEVENT()' DUE TO INVALID CONNECTION SEQUENCE
IT24361 2 DB2 V11.1 DB2DIAG.LOG MESSAGE WITH ERROR "FILE NOT FOUND" IN "SQLPGOPENLOGEXTENT, PROBE:10000" MAY BE MISLEADING
IT26107 2 DB2READLOG API MIGHT SKIP LOG RECORDS INTERMITTENTLY
IT26781 2 THE NEW "--VENDOR_ARCHIVE_TIMEOUT" OPTION DOES NOT WORK WITH SPECIAL BUILDS
IT24447 2 AFTER DB2 RECYCLE, DB2 STARTED ARCHIVING OLD LOG FILES CAUSING ACTIVE LOG FILESYSTEM QUICK GROWTH.
IT25968 2 CREATE INDEX FAILS WITH SQL0901N IN PURESCALE WHEN OLD LOG FILES ARE REMOVED IN ARCHIVE LOG DIRECTORY
IT26391 2 ERRORS FROM SQLPRECOVERYLSN IN CREATING LOG AT BACKUP FILE CAN LEAVE A TABLE SPACE UNABLE TO BE ROLLED FORWARD
IT24424 2 FIRST TAKEOVERS AFTER MIGRATION FROM 9.7 TO 11.X CAN LOOP IN REMOVEEXTRACANDIDATES FUNCTION AND TIMEOUT
IT26566 2 REDUCE UNNECESSARY DIAGNOSTICS GENREATION FOR NON-CRITICAL FEDERATION (SQLPQG) ERRORS DURING COMMIT
IT24524 2 RARE TIMING ISSUE MAY CAUSE INSTANCE CRASH ON BACKUP COMPLETION
IT23181 3 DISK FULL FOR MIRROR LOGPATH HIT AFTER UPDATING LOGGING METHOD FROM ARCHIVE TO CIRCULAR
IT25990 3 STARTING HADR AS STANDBY ON A PURESCALE DATABASE COULD SOMETIME RETURN SQL1776N RC7
IT25680 3 "ROLLFORWARD LAST COMMITTED TIMESTAMP" VALUE IS NOT SHOWN IN A DATABASE SNAPSHOT ISSUED AGAINST A HADR STANDBY DATABASE
IT25994 3 HADR GRACEFUL TAKEOVER ON PURESCALE COULD FAIL WITH SQL1770N RC7 WHILE OLD PRIMARY DATABASE IS SWITCHING ROLE.
IT24518 3 MANY DIFFERENT SIZED LOGS IN LOG DIRECTORY
IT25196 3 OLDER DATAL ARCHIVE LOGS ARE NOT PRUNED BY "PRUNE HISTORY TIMESTAMP AND DELETE" COMMAND UNEXPECTEDLY
IT25801 3 INVALID MIRROR LOG PATH MESSAGE IS SEEN IN DIAG LOG
IT25992 3 HADR GRACEFUL TAKEOVER ON PURESCALE COULD TIME OUT WAITING FOR PRIMARY DATABASE TO PROGRESS DUE TO GLFH LOTCH CONTENTION.
Fix Pack 4  -   Federation
IT22979 2 CREATED FEDERARED PROCEDURE FOR A SP WITH NO ARGUMENTS IN ORACLE DATABASE MAY FAIL WITH -901
IT26427 2 DB2 MAY CRASH WITH COREDUMP IF WINDOWS SYSTEM IS SHUTDUWN STATE DURING FETCH PROCESSING.
JR59479 2 MEMORY CORRUPTION WHEN SELECT TO FEDERATED DB USING JDBC TO POSTGRESQL
IT24300 2 ON FEDERATION, GETS SQL0214N RC=2 BY SELECT DISTINCT
IT23930 2 THE TO_DATE FUNCTION IS NOT PUSHED DOWN CORRECTLY IN FEDERATED SETUP
IT23918 2 NNSTAT MIGHT FAIL WITH SQL1227N THE CATALOG STATISTIC " " FOR COLUMN " " IS OUT OF RANGE FOR ITS TARGET COLUMN
IT24434 2 CREATE NICKNAME AGAINST AN ORACLE TABLE MAY FAIL WITH ERROR SQL0802N
Fix Pack 4  -   Index Manager
IT24493 2 LOCK EXCLUSIVE MDC TABLE WITH LOCKSIZE SET TO BLOCKINSERT, INSERTING ROWS WILL RESULT IN ADDITIONAL LOCKS BEING ACQUIRED.
IT24129 2 DB2 MAY DEADLATCH DURING AN INSERT INTO AN ITC TABLE WHILE THERE ARE 2 OR MORE OTHER CONCURRENT IUD TRANSACTIONS
IT24962 2 SQL1007N ERROR IN FINDING PAGES FOR AN OBJECT IN A TABLE SPACE
Fix Pack 4  -   Install and Catalog Services
IT24473 1 SECURITY: BUFFER OVERFLOW IN DB2LICM
IT25819 1 SECURITY: BUFFER OVERFLOW IN DB2 DB2LICM UTILITY
IT24840 1 SECURITY: UPDATE IBM SDK, JAVA TECHNOLOGY EDITION QUARTERLY CPU - JAN 2018
IT26315 1 SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION
IT24958 1 DB2VAL MAY CRASH IN DB2 10.5FP9
IT23551 2 INSTALLING IBM DATA SERVER RUNTIME CLIENT VIA SILENT INSTALL, FAILS TO CREATE A DB2 INSTANCE
IT24581 2 ALL HOSTS IN THE PURESCALE CLUSTER MUST HAVE AN ENTRY IN SQLLIB_SHARED/.UPDATE OR INSTALLFIXPACK COULD FAIL.
IT23805 2 .DB2TAG SHOULD BE CONVERTED TO .SWTAG AND NOT .SWIDTAG.
IT20386 2 DB2: INSTALLATION MIGHT RETURN DBI20105E WARNING AND NOT INSTALL TSAMP COMPONENT
IT24961 2 ATTEMPT TO INSTALL DB2 SERVER 10.5 64 BIT FIXPACK 9 FAILS DURING UPGRADE WHEN DB2 V10.5 32 BIT ALREADY EXISTS ON WINDOWS
IT24578 2 INSTALLATION OF DB2 V11.1.3.3 ON SOLARIS RAISES UNKNOWN KEYWORD "TSA_GPFS_ONLY"
IT26514 2 SECURITY: DB2 IS AFFECTED BY A VULNERABILITY IN IBM SPECTRUM SCALE
IT26054 2 -901 ERROR WITH TEXT "WITH HOLD BUT USAGE LOCK ARGUMENT NULL" RE PORTED BY SQLRLC_REQUEST_ULOCK() AS CALLED BY SQLRLGETREPLMQTREF
IT24346 3 PERMISSIONS TO TBPSIZE_ENTITLEMENT_REQ.PL AND TBPSIZE_ENTITLEMENT_REQ.SQL FILES
IV94387 3 DB2VAL MIGHT FAIL WITH RC=10 IF NL PACK IS NOT INSTALLED.
IT17370 3 INSTALLFIXPACK -P (INTO A NEW LOCATION) OPTION STILL CHECKS EXISTING LOCATION AND INSTANCES
IT24712 3 AFTER RENAMING A TABLE A SUBSEQUENT SELECT MAY INCORRECTLY RETURN SQL0551
IT23225 3 INSTALLATION WITH WINDOWS EXTENDED SECURITY DISABLED BEHAVES AS THOUGH WINDOWS EXTENDED SECUIRTY WAS ENABLED.
IT26008 3 DB2LOOK HAS DUPLICATE/INCORRECT COLUMN IN REFERENCES CLAUSE OF FOREIGN KEY DDL.
IT25623 3 DB2IUPDT -CHECK_COMMIT / -COMMIT_LEVEL FAILED
Fix Pack 4  -   Monitoring
IT25527 2 ADMIN_MOVE_TABLE: INDEX IS NOT GENERATED IF TARGET TABLE IS COLUMNAR
IT25342 2 ADMIN_MOVE_TABLE FORCE_ALL DOES NOT FORCE OFF APPLICATIONS HOLDING OTHER CONFLICTING LOCKS THAN TABLE LOCKS
IT25363 2 SYSPROC.MON_GET_CONNECTION DOES NOT DIFFERENTIATE BETWEEN SECURE AND NON-SECURE CONNECTIONS TO A DATABASE.
IT24513 2 ADMIN_MOVE_TABLE: INTRODUCE OPTIONS TO PREVENT CREATION OF NON-UNIQUE INDEXES AND MODSTATE INDEX ON TARGET TABLE
IT22976 2 ROUTINE EXECUTION MONITORING STOPS WORKING, SPAMS DB2DIAG.LOG WITH ALLOCRTNSTMTTABLE MESSAGE
IT25560 2 STATISTICS EVENT MONITOR TRAPS WHEN EVENT MONITOR GENERATION OVERLAPS ACTIVATION OF THE STATISTICS EVENT MONITOR.
IT25281 3 SLOW INSERT PERFORMANCE WHEN USING MON_OBJ_METRICS EXTENDED
IT25389 3 PREP_TIME = -1 IN EVENT MONITOR FOR ACTIVITIES WHEN CALLING STORED PROCEDURES
Fix Pack 4  -   JCC
IT25755 2 JCC NPE WITH KEEPDYNAMIC YES IN SAP
IT24982 3 DB2 NAMED PARMETER MARKER in common table expression is result in a error in JAVA application
IT25872 2 DB2:HADR FAILOVER, JAVA APP DEPLOYED ON JBOSS FAILED TO RETRIEVE SCHEMA BUT USE CONNECTION AUTH ID DIRECTLY.
IT25943 2 NPE WITH ACR AND CLIENT AFFINITY IN PURESCALE IF THE FIRST MEMBER IS DOWN
IT24308 2 BUG IN COLUMN COMMAND CLPPLUS
Fix Pack 4  -   Platform Specific
IT24174 1 SECURITY: OSSEMEMDBG ARBITRARY FILE OVERWRITE VULNERABILITY
IT24172 1 SECURITY: MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT26129 1 SECURITY: DB2 IS VULNERABLE TO SYMBOLIC LINK ATTACK LEADING TO PRIVILEGE ESCALATION
IT24173 1 SECURITY: DB2OPTSTATS ARBITRARY FILE OVERWRITE VULNERABILITY
IT24171 1 SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24311 1 SECURITY: RAH.EXE BUFFER OVERFLOW
IT25135 2 BACKUP V9.7 DB FROM V11.1 CLIENT MIGHT FAIL WITH SQL1651N
IT23724 2 AMENDMENT ON SQL0270 RC= 113 MESSAGE
IT24702 2 THE EXPLANATION FOR SQL0338N NEEDS AN UPDATE AFTER THE ENHANCEMENT MADE SINCE 10.1 TO ALLOW SUBQUERIES IN AN ON CLAUSE
Fix Pack 4  -   Problem Determination
IT24823 1 SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
IT26131 1 SECURITY: DB2 VULNERABLE TO SYMBOLIC LINK ATTACK RESULTING IN PRIVILEGE ESCALATION
IT26713 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT25927 2 PADIAGLOGCOLL::PARSEFILTERPARMS SHOWS UP IN DB2DIAG.LOG FREQUENTLY.
IT24696 2 THE DB2SUPPORT TOOL MAY REMOVE DATABASE FILES, RESULTING IN A DATABASE CORRUPTION OR AN INSTANCE-WIDE OUTAGE
Fix Pack 4  -   Process Model
IT25769 1 DB2XPRT TOOL IS FAILING TO FORMAT WINDOWS TRAP FILES IN SPECIAL BUILDS.
IT25731 2 AUTOCONFIGURE MAY FAIL WITH SQL0802N IF THE SUM OF THE SIZES OF ALL TABLE PACKED DESCRIPTORS EXCEEDS 2147483647
IT25993 2 WHEN THERE ARE MANY CONNECTIONS TO THE PRIMARY DATABASE, HADR TAKEOVER COULD RETURN SQL1770N RC7.
IT24048 2 FCM_PARALLELISM RETURNS WRONG VALUE IN V11.1 PURESCALE
IT26820 2 NOMEM ERROR CAUSED INSTANCE HANG WITH SERIOUS MEMORY LATCH CONTENTION
IT25750 2 SIGKILL ORIGINATING FROM DB2STOP FORCE NODENUM XX
IT22132 2 THE DB2CKUPGRADE TOOL DOES NOT CHECK IF THERE IS ENOUGH FREE SPACE IN DMS TEMPORARY TABLE SPACE BEFORE UPGRADE.
Fix Pack 4  -   Query Compiler Optimizer
IT24078 1 DB2 MAY HIT SUSTAINABLE TRAP IN SQLNO_CREATE_TEMPORAL_KEYS PROCESSING
IT24799 1 SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT20585 2 SQL0901N WITH UNEXPECTED AVGBUILDTUPLESIZE=0 IN JOIN QUERY
IT26322 2 JOIN OF COLUMN-ORGANIZED TABLES MIGHT RETURN INCORRECT RESULTS
IT24568 2 DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING COMMON-TABLE-EXPRESSIONS
IJ06105 2 OPT GENERATES NON-OPTIMAL CDE ACCESS PLANS DUE TO INCORRECT DATA CO-LOCATION DETERMINATION IN DISTRIBUTED SYSTEM.
IT24737 2 AUTOMATIC ONLINE REORG FAILS WITH SQL0270N BECAUSE THE CLAUSE AL LOW WRITE ACCESS IS GENERATED AND NOT SUPPORTED ON MDC TABLE. (R
IT23577 2 INSTANCE CRASH WHEN CAPTURING SECTION EXPLAIN INFORMATION FOR SQL STATEMENT THAT CAN PRODUCE A VERY LARGE OPTIMIZED STATEMENT
IT23647 2 DB2 MAY TRAP WITH EXECUTING A QUERY WITH NODENUM OR DBPARTITIONNUM FUNCTION IN DPF ENVIRONMENT.
IT24631 2 DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING CORRELATED PREDICATES
IJ05838 2 IMPROVE QUERY OPTIMIZATION FOR COLUMN-ORGANIZED INDEX SCAN PLANS
IT24821 2 WITH UCA COLLATION RUNSTATS CAN CAUSE THE INSTANCE TO TRAP
IT26278 2 INDEXES ON COLUMN-ORGANIZED TABLES ARE NOT CHOSEN FOR SOME TYPES OF SQL STATEMENTS
IT24004 3 DB2ACD MIGHT INCORRECTLY CHOOSE INDEX REBUILD DURING AUTOMATIC TABLE MAINTENANCE EVEN WHEN NO OFFLINE WINDOW IS AVAILABLE
Fix Pack 4  -   Query Compiler QGM
IT26479 1 POTENTIAL WRONG QUERY RESULT IF A FROM CLAUSE INCLUDES A MIXTURE OF LEFT OUTER AND LEFT OUTER TO ONE JOINS
IT23376 1 SQL0901N - REASON "INT. ERROR: QUERIED PERIOD IS NOT DEFINED" WHEN USING TEMPORAL TABLES
IT25553 1 CREATE PROCEDURE MAY CAUSE DB2 TO TERMINATE ABNORMALLY IN SQLNQ_SEM_LIMIT
IT24439 1 SQL0440N ERROR CAN OCCUR WHEN QUERIES CONTAIN OUTER JOINS AND INNER JOINS
IT25908 2 PL/SQL PACKAGE WITH AN INITIALIZATION SECTION CAN RETURN -301 ERROR WHEN CALLED VIA JAVA OR CLPPLUS
IT25229 2 DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING REDUNDANT PREDICATE
IT22941 2 TRAP/901 WHEN XML COLUMN NOT REFERENCED
IT26595 2 SECURITY: FGAC RULES NOT BEING ENFORCED BY CTAS SUB-SELECT STATEMENTS
IT18322 2 DB2 CRASH OR LONG COMPILATION TIME THAT MIGHT ERROR OUT WITH SQL101N
IT18837 2 UPDATE STATEMENT MAY TRAP WHEN USING A NOT-IN SUBQUERY
IT25195 2 QUERIES CONTAINING OUTER JOINS AND GROUP BY CLAUSES MIGHT PRODUCE WRONG RESULTS
IT22972 2 QUERY INVOLVING OUTER JOINS HAS WRONG COLUMN RESULT NULLABILITY
IT24989 2 SQL0420N ERROR MIGHT OCCUR WHEN RUNNING UPDATE STATEMENTS CONTAINING SCALAR SUB-QUERIES
IT25707 2 DB2 SERVER TERMINATES ABNORMALLY DURING QUERY COMPILATION
IT26282 2 UPDATE ON FULL TABLE WHICH USES SUB_SELECT COULD INCORRECTLY SET VALUES TO NULL FOR COLUMN BEING UPDATED.
IT24750 2 SQL0901/SQL0183 MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING CASE SUB-EXPRESSIONS
IT26621 2 UNDER RARE CIRCUMSTANCES, DB2 MAY ABEND WHEN A QUERY CONTAINS AN EXPRESSION THAT CAN BE MATCHED TO AN INDEXED EXPRESSION
IT25654 2 DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSION, UNION AND UDF
IT26178 2 WRONG RESULTS FROM SELECT INTO STATEMENT CONTAINING WITH CLAUSE AND DATA-CHANGE-TABLE-REFERENCE
IT24201 2 SQL0507N ERROR COULD OCCUR WHEN AN UPDATE TARGET TABLE RESIDES IN REMOTE DATA SOURCE
IT22207 2 SQL0901N "COLUMN NUMBER OUT OF RANGE" ERROR WHEN GROUP BY IN NULL PRODUCING SIDE OF OUTER JOIN
IT20692 2 POOR PERFORMANCE WHEN OJ AND JOIN ON IT HAS SAME TABLE
IT24632 2 DB2 SERVER TERMINATES ABNORMALLY COMPILING A MERGE STATEMENT
IT22297 2 DB2 MIGHT TRAP WHEN EXECUTING COMPLEX QUERIES CONTAINING CSES
IT25706 2 INCORRECT RESULTS COULD HAPPEN WITH OUTER JOINS AND EXPRESSIONS IN JOIN COLUMNS
IT23245 2 TRAP WHEN IN/EXISTS SUBQUERY IN SELECT LIST AND ACCESS CONTROL ACTIVATED
IT19881 3 DB2 MAY DEPICT PERFORMANCE DESCRIPTION WHEN IS NOT NULL AND IN/LIKE PREDICATE ARE USED
IT21696 3 SELECT FROM VIEW WITH DECIMAL(DATE) FAILS WITH SQLCODE SQL0344N, SQLSTATE 42825
Fix Pack 4  -   Relational Data Services
IT25516 2 TRAP IN SQLRA_CLOSE_SECTIONS_ON_COMMIT IN DPF ENVIRONMENT
IT24734 2 INSTANCE MAY PANIC DURING A DROP SEQUENCE
IT25647 2 SQL0901N "DESCRIBE LEVEL (0X3) SQLDD LEVEL (0X2)" WHEN USING DB2 REPLICATION CENTER TO CREATE FEDERATED CONNECTION
IT25333 2 PERFORMANCE MAY BE AFFECTED BY DYNAMIC SQL CACHE NON REUSE
IT25435 2 FLUSH PACKAGE CACHE MAY NOT REMOVE ALL ENTRIES
IT24609 2 DB2EXPLN SEGV AND CRASHES THE SERVER
IT25732 2 DB2 IN DPF MAY HANG DURING IMPLICIT INDEX REBUILD ON COLUMNAR TABLE IF MORE THAN ONE INDEX IS RECREATED
IT24960 2 -901 ERROR IN SOME CASES WHEN EXPLAIN MODE IS ON AND A STATEMENT IS RUN TWICE
IT23698 2 DB2 MIGHT TRAP IN SQLRWPERFORMWORKLOADASSIGNMENT_NC() WHEN AGENT IS REUSED WITH ANOTHER DATABASE.
IT25431 2 YOU MAY ENCOUNTER A FODC PANIC DURING DROP TABLE COMMAND IN DPF.
Fix Pack 4  -   Security
IT26132 1 SECURITY: PRIVILEGE ESCALATION IN ROOT SETUID EXECUTABLES
IT24474 1 SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH
IT26252 2 DES CONNECTIONS USING GATEWAY CONCENTRATOR AGAINST DB2 FOR Z/OS CAN FAIL
IT25880 2 GATEWAY CONCENTRATOR CAN CAUSE JDBC DES CLIENTS TO FAIL TO AUTHENTICATE WHEN JDBC AES CLIENTS ARE ALSO BEING USED.
IT25813 3 SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION
Fix Pack 4  -   Text Search
IT24343 2 DB2 BUILDS DOES NOT CONTAIN THE TEXT SEARCH FUNCTIONALITY AFTER V11 FP1 ON POWER LINUX PLATFORM (PPC64LE)
Fix Pack 4  -   XML
IT26036 2 DB2 MAY TRAP WHEN EVALUATING AN XML QUERY THAT INVOLVES RENAMES.
IT25388 2 DB2 MIGHT TRAP DURING PROCESSING XML DATA
IT25523 2 ERRORS WITH XML PROCESSING - XDBADVDOCHANDLER__ERROR, PROBE:1655
Fix Pack 4  -   pureScale Services
IT24749 1 DB2 MAY CRASH IN SAL FLIGHT RECORDER CODE
IT25601 2 "DB2CLUSTER -CM -ENTER -MAINTENANCE" COMMAND FAILS IF RUN ON A TIEBREAKER HOST IN GDPC ENVIRONMENT
IT26264 2 DB2CLUSTER -CFS -ENTER -MAINTENANCE MIGHT FAIL WITH 2610-602 RSCT ERROR
IT25400 2 DB2PD -HA CAN OUTPUT "COULD NOT RETRIEVE NUMBER OF RESOURCE GROUPS IN THE CLUSTER"
IT24959 2 ATTEMPTING TO MOVE HADR DATABASES VIA THE DB2HAICU MAINTENANCEMENU OPTION MAY FAIL
IT25519 2 DB2INSTANCE -LIST COMMAND CAN FAIL WITH COREDUMP IF A ROUTING IS MISSING.
IT24735 2 MEMBER FAILBACK MAY FAIL WITH SQL1072C AFTER RMCD PROCESS FAILURE ON MEMBER?S HOME HOST.
IT25138 2 THE "DB2CLUSTER -CM -ENTER -MAINTENANCE COMMAND" MAY FAIL DUE TO TSA RESOURCES PROBLEM
IT24571 2 IF THE LINUX ASLR FEATURE IS ENABLED, SEVERE DB2DIAG MESSAGES WITH TAG SQLO_ADDR_CONFLICT MAY BE INFREQUENTLY OBSERVED
IT25552 2 UPDATING THE AUDIT DATA PATH OR THE INSTANCE DIAGPATH MAY FAIL IN AN AUTOMATED HADR ENVIRONMENT
IT25373 3 CF MEMBER COMMUNICATION TIMEOUT LEADS TO CONNECTION RESET IMPACTING PERFORMANCE
IT23438 3 RUNNING DB2CLUSTER TO CHANGE HOSTFAILUREDETECTIONTIME MAY FAIL INDICATING THAT THE SHARED FILE SYSTEM CLUSTER MUST BE STOPPED.
IT22113 3 "DB2INSTANCE -LIST" MAY NOT SHOW ALERTS WHEN "DB2CLUSTER -CFS-LIST -FILESYSTEM <FSNAME> -DISK" IS ISSUED BY ROOT.
IT24427 3 THE PRIMARY AND SECONDARY HADR NODES ARE NOT DISPLAYED CORRECTLY IN "DB2PD -HA" OUTPUT
IT25464 3 DB2ROCM CONSTANTLY DUMP *SQLHA.EVENTS.BIN IF MEMBER FAILS TO START.

DB2 Version 11.1 Fix Pack m3ifx002
APAR Sev. Abstract
Fix Pack m3ifx002  -   Administration Server
IT24283 1 SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN THE DB2 DAS COMPONENT ON WINDOWS
Fix Pack m3ifx002  -   Codegen and Runtime
IT24956 1 SQL0332N AFTER ALTERING COLUMN LENGTH
IT24687 2 QUERIES USING THE SAME UNNEST IN DIFFERENT PARTS OF THE PLAN COULD RETURN WRONG RESULTS FOR SOME COLUMNS
Fix Pack m3ifx002  -   Install and Catalog Services
IT25322 1 DB2CKUPGRADE FAILS WITH SQL10007N MESSAGE "5556" COULD NOT BE RE TRIEVED. REASON CODE: "4" WHEN UPGRADING FROM V10.5FP10 TO V11.1
Fix Pack m3ifx002  -   Monitoring
IT24513 2 ADMIN_MOVE_TABLE: INTRODUCE OPTIONS TO PREVENT CREATION OF NON-UNIQUE INDEXES AND MODSTATE INDEX ON TARGET TABLE
Fix Pack m3ifx002  -   Problem Determination
IT24823 1 SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
Fix Pack m3ifx002  -   Query Compiler Optimizer
IJ06105 2 OPT GENERATES NON-OPTIMAL CDE ACCESS PLANS DUE TO INCORRECT DATA CO-LOCATION DETERMINATION IN DISTRIBUTED SYSTEM.
IJ05838 2 IMPROVE QUERY OPTIMIZATION FOR COLUMN-ORGANIZED INDEX SCAN PLANS
IT24004 3 DB2ACD MIGHT INCORRECTLY CHOOSE INDEX REBUILD DURING AUTOMATIC TABLE MAINTENANCE EVEN WHEN NO OFFLINE WINDOW IS AVAILABLE
Fix Pack m3ifx002  -   Query Compiler QGM
IT22972 2 QUERY INVOLVING OUTER JOINS HAS WRONG COLUMN RESULT NULLABILITY
IT25783 2 -901 ERROR WITH TEXT "WITH HOLD BUT USAGE LOCK ARGUMENT NULL" RE PORTED BY SQLRLC_REQUEST_ULOCK() AS CALLED BY SQLRLC_FED_FETCH()
Fix Pack m3ifx002  -   Relational Data Services
IT25431 2 YOU MAY ENCOUNTER A FODC PANIC DURING DROP TABLE COMMAND IN DPF.
Fix Pack m3ifx002  -   Security
IT24474 1 SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH

DB2 Version 11.1 Fix Pack m3ifx001
APAR Sev. Abstract
Fix Pack m3ifx001  -   Buffer Pool Services
IT24744 2 CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
IT24968 2 CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
Fix Pack m3ifx001  -   CDE Query
IT24494 2 OVERLAPS FUNCTION EXECUTED AGAINST COLUMNAR ORGANIZED TABLE COULD RETURN WRONG RESULTS IF INPUT COLUMNS HAVE NULL VALUES
Fix Pack m3ifx001  -   Codegen and Runtime
IT24407 1 TRAP IN SQLBPFADDTOQ WHEN RUNNING A QUERY INVOLVING A FETCH-IXSCAN PLAN AGAINST A BLU TABLE.
Fix Pack m3ifx001  -   DB2 Tools
IT24642 1 SECURITY: DB2CONVERT IS VULNERABLE TO BUFFER OVERFLOW
Fix Pack m3ifx001  -   Data Recovery Services
IT24028 1 DB2 LOG REPLAY (RECOVERY, RFWD, HADR) MIGHT HANG WITH DB2REDOM IN SQLPRGETFREEQE->WAIT AND DB2REDOWS IN SQLPRFINDQUEUE->WAIT.
IT23954 2 HADR STANDBY FAILS WITH DBHEAP OUT OF MEMORY UPON RECONNECT
Fix Pack m3ifx001  -   Install and Catalog Services
IT24473 1 SECURITY: BUFFER OVERFLOW IN DB2LICM
Fix Pack m3ifx001  -   Platform Specific
IT24171 1 SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24311 1 SECURITY: RAH.EXE BUFFER OVERFLOW
Fix Pack m3ifx001  -   Problem Determination
IT24696 2 THE DB2SUPPORT TOOL MAY REMOVE DATABASE FILES, RESULTING IN A DATABASE CORRUPTION OR AN INSTANCE-WIDE OUTAGE
Fix Pack m3ifx001  -   Query Compiler Optimizer
IT24799 1 SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT20634 2 INCORRECT RESULT WHEN AT LEAST 3 COLUMNAR TABLES ARE JOINED THROUGH CDE NLJNS AND TOP NLJN IS EARLY OUT

DB2 Version 11.1 Fix Pack m3fp3
APAR Sev. Abstract
Fix Pack m3fp3  -   Abstract Data Types and Spatial Extender
IT21931 3 SPATIAL EXTENDERS DATA TYPES NOT CLEARED AFTER DB2SE DISABLE_DB <DATABASE> AND CANNOT BE DROPPED
Fix Pack m3fp3  -   Administration Tools
IT22587 2 DB2LOOK FOR TIMESTAMP COLUMNS GENERATES TIMESTAMP(9) WHEN DEFINED ON DB2 FOR Z/OS
IT23534 2 DB2LOOK WARNING NUMBER OF KEYS IN INDEX LIMITED TO 16 FOR DB2Z
IT20335 2 DB2LOOK -MOD MAY HANG FOREVER TILL IT IS KILLED MANUALLY
IT17532 3 SQL1227N CAN OCCUR WHEN APPLYING STATISTICS TAKEN BY DB2LOOK -M -R
Fix Pack m3fp3  -   Buffer Pool Services
IT21456 1 MEMBER CRASH RECOVERY OF A RUNSTATS OPERATION MAY LEAD TO A DISK CORRUPTION
IT20368 2 SQLB_BADHDR ERROR DURING SQLB_VERIFY_PAGE CAUSING FODC DUMPS ANDDB MARKED BAD.
IV95270 2 DB2 IS DOWN WHEN AIO FAILED TO COLLECT ALL OUTSTANDING IO REQUESTS.
IT21930 2 IF DB2 HAPPENS TO BE BACKING UP THE TABLESPACE AT THE SAME TIME IT IS BEING ALTERED, THIS COULD CAUSE DB2 PANIC.
IT21920 2 ALTER TABLESPACE REDUCE OPERATIONS MIGHT LEAD TO ASYNCHRONOUS HIGH WATERMARKS IN HADR SYSTEMS
IT22464 3 DB2DIAG.LOG FILLED WITH ERROR ON FUNCTION SQLBFINDPAGEINBPORSIM PROBE: 1952 SQL0003N THE DATABASE NAME IS NOT VALID
Fix Pack m3fp3  -   Build Team
IT23794 1 SECURITY: UNSAFE DESERIALIZATION IN DB2 JDBC DRIVER
IT19753 2 ISSUE IS WITH DATA ENCRYPT WITH NULL LOB VALUE THERE IS EXCEPTION IN JCC TRACE WITH EMPTY DATA.
Fix Pack m3fp3  -   CDE Data
IT23941 1 DB2 ABEND DUE TO MEMORY CORRUPTION USING COLUMN BASED TABLES
IT22343 1 SQL0901N UNEXPECTED ERROR AT DATABASETABLEACCESSOR.HPP:1357"
IT21085 2 AGAINST COLUMNAR TABLES, COMBINATION OF EXCLUSIVE TABLE LOCK AND UNCOMMITTED INSERT AND SELECT COULD RETURN INCORRECT RESULTS
IV98006 2 WRONG RESULTS RETURNED WITH EXCLUSIVE TABLE LOCK
IT21938 2 DB2DART REPORT ON A COLUMN-ORGANIZED (BLU) TABLE TAKES LONG TIME TO COMPLETE
IT22680 2 SELF-BLOCKING SQL INSERT OR UPDATE - SELF-DEADLATCH IN SQLO_LT_SQLD_CCB__CCBLATCH
Fix Pack m3fp3  -   CDE Query
IT23812 1 INSTANCE TRAP IS POSSIBLE WHEN QUERY AGAINST COLUMN ORGANIZED TABLES WITH OLAP SPECIFICATION IS RUN
IV92342 2 SAP: BLU QUERY MAY FAIL WITH -955 WHEN HASH JOIN BUILD TABLE CONTAINS MANY DUPLICATE VALUES
IT20898 2 QUERY AGAINST COLUMN ORGANIZED TABLE USING THE SAME DIVISION OPERATION IN NESTED CASE STATEMENTS CAN RECEIVE SQL0801N
IJ02025 2 TRAP IN MERGEINFO::DUMP IS POSSIBLE AS A RESULT OF A -901 ERROR OR DB2PD _DUMP COMMAND
IJ01914 2 SERVER MAY TRAP WHILE RUNNING QUERY WITH COLUMNAR BASED TABLE.
IT22175 2 QUERY FAILING WITH -901 ERROR UNEXPECTED ERROR AT DATATYPEIMPL.HPP:
IT22051 2 BLU/CDE SQL STATEMENT MIGHT FAIL WITH SQL1225N IN A DPF INSTANCE.
IT22344 2 DB2 MAY FAIL EXECUTING QUERY DURING SEMIJOIN PROCESSING ON CDE
Fix Pack m3fp3  -   Client Interfaces
IT21235 2 CLP MIGHT RETURN SQL1246N OR SQL1024N INTERMITTENTLY DUE TO DUPLICATE QUEUE ID.
IT21245 2 DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES WHEN USING SQLDATAREADER
IT21917 2 THE DB2 LUW COMMAND BIND USES BY DEFAULT DEALLOCATE FOR THE RELEASE OPTION
IT21982 2 DB2CMD.EXE MAY NOT WORK PROPERLY WHEN THE COMMAND LINE IS EXTREMELY LONG
IT23055 2 ERROR -518 DURING A CLI ARRAY INPUT CHAINING
IT22945 2 SQLGETTYPEINFO RETURNS 255 FOR CHAR DATATYPE WHEN CONNECTION FROM V11 CLIENT TO V10.5 SERVER.
IT21999 2 SQL1038N ON CALL REORGCHK_IX_STATS('T','ALL')" WITH STMT_CONC=LITERALS
IT23249 2 EXECUTING A 4-PART NAME QUERY FROM MS SQL SERVER HANGS
IT21934 2 LIST INDOUBT TRANSACTIONS MAY NOT RETURN TO PROPMT
IT20683 2 CLP NOT PROPAGATING SQLCA
IT23016 3 DB2 AUTHORITIES ARE IGNORED WITH CHANGE DATABASE CONFIGURATION
IT24218 3 CLP CRASHES WITH DB21018E
IT21090 3 DB2 -A LIST APPLICATIONS DOES NOT SHOW SQLCA INFORMATION.
IT20009 3 "CLP SELECT STATEMENT DISPLAY FIX FOR CHAR AND VARCHAR CODEUNITS32 STRING UNITS"
Fix Pack m3fp3  -   Codegen and Runtime
IT22284 1 APPLICATION HEAP CAN BE EXHAUSTED BY REBAL FUNCTION AND THIS CAN LEAD TO APPLICATION FAILURE WITH OUT OF MEMORY
IT22260 1 INSTANCE CRASH AFTER RUNNING OUT OF MEMORY
IT21166 2 SLOW ORDER BY WITH COLLATING SEQUENCE CLDR181
IT20287 2 DB2 MAY SHOW INCREASED LATCHING WHEN PLANS WITH HASHJOIN PRODUCE NO ROWS ON BUILD SIDE
IT21308 2 WRONG ERROR MESSAGE
IT21509 2 HASH FUNCTION FOR EMPTY BLOB RETURNS SQL0083C ERROR
IT21403 2 FLOATING POINT TO DECIMAL CONVERSION IN ORA MODE CAN RESULT IN LESS ACCURATE RESULTS FOR NUMBERS WITH LARGE SCALE
IT22392 2 SQL0420 AFTER UPGRADE TO V11.1
IJ00102 2 INSERT FROM A SELECT ON A COLUMN-ORGANIZED COLUMN CAN HANG IN DPF OR SMP(FP2A)
IT22508 2 ?CA0104? ERROR ON QREP APPLY IN Z/OS WITH RETRIEVING "FOR BIT DATA? COLUMN FROM DB2 LUW
IT22627 2 DPF QUERY MAY HANG DUE WAITS ON SUBSECTIONS FOR ONE NODE
IT21912 2 A REPEATED POSITIONED UPDATE ON A ROW CAN LEAD TO AN ABEND/CRASH ON SQLRISTM
IT20477 3 SELECT QUERIES RUN ON HADR STANDBY WITH "UR CLAUSE" FAIL WITH ERROR -1773
IT22367 3 AN SQL0901N "EXPECTING CACHED ZVAL FOR MARKED PID" IS POSSIBLE
Fix Pack m3fp3  -   Communication
IT21933 2 APPLICATIONS FAIL WITH ERROR SQL30020N "0X124C"("0100") WHEN CONNECTING THROUGH A GATEWAY
Fix Pack m3fp3  -   DB2 Tools
IT23671 2 SYSTOOLS.JSON_UPDATE CAN CRASH OR RETURN "BSON VALUE IS TOOLONG" WHEN UPDATING A NULL FIELD
IT21142 2 SQL0443N FROM SYSTOOLS.JSON2BSON IF SECOND BSON > FIRST
IT22588 2 DB2LOOK CORE DUMPS
IT22629 2 UPDATING DB2LOOK -L TO WORK WITH DPF DATABASES TIMELY
IT21921 2 NO ERROR MESSAGE IS RETURNED WHEN THE DATA EXCEEDS JSON ARRAY SIZE.
IT21919 3 THE "DB2PD -CFPOOL DETAIL" COMMAND ABNORMALLY TERMINATES
Fix Pack m3fp3  -   DRDA Services
IT21390 3 DB2 CONNECT SERVER MAY TRAP IF SSL IS IN USE AND DATABASE IS CATALOGUE WITH ALTERNATE DB2 CONNECT SERVER.
Fix Pack m3fp3  -   Data Management Services
IT20321 2 SLOW INSERT PERFORMANCE WHEN USING A CLUSTERED INDEX.
Fix Pack m3fp3  -   Data Management Utilities
IT21593 2 INGEST MAY USE EXCESSIVE AMOUNT FOR OVERFLOW MEMORY
IT22626 2 LOAD IN ENCRYPTED DATABASE WILL LEAK SOME ENCRYPTION RELATED MEMORY BLOCKS
IT16704 2 WITH VARCHAR2-SUPPORTED DATABASE YOU MIGHT GET AN ERROR -305 WHILE PERFORMING AN EXPORT
IT23202 2 LOAD OF BITEMPORAL TABLES MIGHT FAIL TO DETECT DUPLICATE / OVERLAPPING ROWS WITH INDEXING MODE REBUILD
IT22162 2 CONVERSION BETWEEN DIFFERENT CODE PAGES CAN LEAD TO UNEXPECTED TRUNCATION OF DATA
IT23173 2 DECREASED PERFORMANCE, STMMSTARTHJMONITORIFNECESSARY ERRORS LOGGED IN CONSTRAINED/VOLATILE STMM ENVIRONMENTS
IT22148 2 SEVERE ERRORS IN THE DB2DIAG.LOG RELATED TO INGEST(SQLUDISHM::CLEANFORMATTERBLOCK)
IT23141 2 INTERMITTENT LOAD ABNORMAL END IN THE BUILD PHASE: UNEXPECTED MSG. , 28, 0, DETECTED IN FILE:SQLUVLD.C, LINE:5506
IT22625 2 LOAD UTILITY DOES NOT PROVIDE BENEFICIAL MESSAGES ON THE CONSTRAINT VIOLATION
IT21261 3 DB2 MAY ABEND WHEN PLANS WITH SMP SORTS ARE INTERRUPTED
Fix Pack m3fp3  -   Data Recovery Services
IT23791 1 DB2 INVOKED THE USEREXIT TOO EARLY (USEREXIT WAS COPYING THE SOURCE LOG WHILE LOGGW WAS STILL WRITING NEW LOG DATA TO IT)
IT22524 2 HADR STANDBY CAN BECOME UNABLE TO DELETE EXTRA LOGS IN ACTIVE PATH, CAUSING LOGS TO ACCUMULATE
IT22631 2 DB2 MAY CRASH WHEN PROCESSING EXTENSIVE LIST OF TABLESPACES IN HISTORY FILE
IT23134 2 DUMP.BIN FILES ARE GENERATED ON HADR STANDBY SERVER
IT23619 2 TRANSACTION ID TABLE OVERFLOWED DURING HADR REPLAY
IT23294 2 THE CAPTURE PROGRAM OF Q-REPLICATION TERMINATES WITH SQL2038N ON DB2 PURESCALE
IT23033 2 DB2 MIGHT TRY TO READ LOG RECORDS THAT DO NO LONGER EXIST AFTER LOG FILE TRUNCATION
IT22519 2 IN A DPF ENVIRONMENT, AN INSERT MAY FAIL WITH ERROR SQL0912N RC=1 IF THERE IS A SEQUENCE
IT21915 2 'START HADR AS STANDBY' OPERATION MAY FAIL WITH SQL1776N RC=7 DURING REINTEGRATION IN PURESCALE
IT22366 2 HANG CAUSED BY SET WRITE SUSPEND/RESUME AND LOAD
IT21937 2 ADD TOLERATION LOGIC IN CASE A STANDBY RECEIVES A BAD LOG PAGE DUE TO NETWORK ISSUE
IT22143 2 NO ROOM FOR RETRIEVED LOG NUMBER XXX IN RETRIEVEARRAY DURING ROLLFOWARD OR CRASH RECOVERY
IT21539 2 DB2ADUTL UPLOAD ALWAYS ESTIMATES BACKUP SIZE AT 4 MB
IT21981 2 RESTORE DATABASE COMMAND HAVING HISTORY FILE OPTION FAILED AND INSTANCE CRASHED.
IT21935 2 FATAL ERROR WHEN TAKING MULTIPLE SNAPSHOT BACKUPS WITH NO TRANSACTION(S) IN BETWEEN
IT23360 2 DB2READLOG API CAN HANG IN PURESCALE.
IT23817 2 RETRIEVE ARRAY GETTING FULL WHEN TWO OR MORE DB2READLOG API CALLERS TRYING TO READ FROM THE SAME LOG FILE
IT22185 2 ON A NAT ENVIRONMENT WITH THE REGISTRY VARIABLE DB2_HADR_NO_IP_C HECK TURNED ON, HAS ISSUES WITH MULTIPLE HADR STANDBYS.
IT21569 2 DURING CRASH RECOVERY, A LOG FILE MAY BY UNEXPECTEDLY OVERWRITTEN WHEN USING CIRCULAR LOGGING
IT22432 2 THE INSTANCE CAN TRAP IN XA FUNCTION TRAPPED IS SQLPRESETXIDINTENTRY WHEN DBHEAP IS SET TO A LOW VALUE
IT22009 2 STANDBY CRASHES IF MIRROR LOG PATH IS CHANGED AND DATABASE IS NOT REACTIVATED AFTERWARDS.
IT23135 2 DUMP.BIN FILES ARE GENERATED ON THE HADR PRIMARY SERVER
IT21781 3 MEMBER COULD NOT BE ACTIVATED AFTER IT WAS STOPPED IN PURESCALE.
IT21939 3 IN HADR, PRIMARY DATABASE COULD BE BROUGHT DOWN DUE TO NO HEAP MEMORY IS AVAILABLE
IT23052 3 RESTORE TRANSPORT MAY RESULT IN SQL0601N
IT21048 3 AN ONLINE BACKUP MAY DELETE ARCHIVED LOG FILES THAT ARE REQUIRED BY THE OLDEST REQUIRED BACKUP IMAGE.
Fix Pack m3fp3  -   Federation
IT22011 2 DB2 DOES NOT CAST THE JOIN COLUMNS CORRECTLY, LEADING TO A -901 ERROR IN CDE FOR DPF
JR57507 2 FEDERATED OLAP QUERY TO ISERIES CAN FAIL WITH AN SQL0104N ERROR.
IT22445 2 MEMORY LEAK IN FEDERATED FMP PROCESS DUE TO USE OF PASSTHRU.
IT23284 2 MQFUNCTIONS DO NOT FUNCTION PROPERLY IN DB2 V11.1 ON AIX
IT23557 2 FEDERATED QUERY CONTAINING ROWNUM CRITERIA MISSING IN REMOTE SQL
IT21534 3 SQL1476N ERROR WHEN RUNNING SELECT QUERY WITH JDBC WRAPPER NICKNAME
Fix Pack m3fp3  -   Index Manager
IT23205 2 ASYNCHRONOUS INDEX CLEANUP FAILS WHEN DB2LOCK_TO_RB IS SET TO STATEMENT
IT22684 2 SQL STATEMENTS EXECUTING AN INDEX SCAN WITH INTRA-PARTITION PARALLELISM ENABLED MIGHT RUN SLOW
IJ00213 2 QUERY WITH CURRENTLY COMMITTED SEMANTICS ON COLUMNAR TABLE WHILE AN UPDATE IS BEING COMMITTED MAY CAUSE INCORRECT RESULT
Fix Pack m3fp3  -   Install and Catalog Services
IT21965 1 DB2UNINS CANNOT BE USED FROM INSTALLED COPY
IT19947 1 HIGH NUMBER OF CATCACHE LOCKS IMPACTING PERFORMANCE OF QUERIES
IT22447 1 VARIOUS -901 SQLCODES AND TRAPS DURING COMPILATION RELATING TOACCESS OF THE TABLE PACKED DESCRIPTOR
IT23558 2 DBT5513N THE DB2CKUPGRADE UTILITY FAILED BECAUSE THE SYSCATSPACE TABLE SPACE REQUIRES MORE SPACE IN ORDER TO COMPLETE THE UPGRAD
IT22624 2 DB2VAL FAILS TO VALIDATE SYSADMIN AUTHORITY IF SYSADM_GROUP IS LESS THAN 8 CHAR LONG
IT20324 2 DB2: SILENT INSTALLATION MIGHT FAIL WITH SEGV IN ENCODEPASSWORD- >STRCPY IF CRYPT() RETURNS AN ERROR (E.G. WITH FIPS_ENABLED)
IT22593 2 WLM STMT THRESHOLD DO NOT STOP EXECUTION WHEN SPECIFIC SQL IS RUN.
IT21063 2 OBJECTS GET INVALIDATED AFTER UPGRADE FROM 10.5 TO 11 WHEN DB2_COMPATIBILITY_VECTOR=ORA
IT23174 2 [IFIX002_FINAL] SERVER_DEC IMAGE DOES NOT HAVE CORRECT LICENSE APPLIED
IJ00587 2 INSTALLFIXPACK FAILED WHILE PERFORMING ROLLING UPDATE ON HOST WITH TWO MEMBERS.
IT21940 2 FIXPACK UPDATE GETS ERRORS FOR NOT EXIST "DB2" INSTANCE.
IT23253 2 WHEN USER SPECIFY A WRONG PASSWORD ON DB2CKUPGRADE TOOL(EXPLICIT LY OR IMPLICITLY), THE TOOL DOES NOT HAVE CLEAR MESSAGE RETURNED
IT20797 2 RUNSTATS DOES NOT HANDLE ALIASES ON CGTTS CORRECTLY
IT19341 2 AFTER INSTALLING DB2 11.1 DB2GREG -DUMP RETURNS UNDEFINED SYMBOL: OSSONETIMEONLYEX IN DB2 10.5
IT22415 2 SECURITY: DB2 INSTALL USES WEAK PASSWORD ENCRYPTION (CVE-2017-1571)
IT21916 2 NON-ROOT FIXPACK UPDATE UISNG INSTALLFIXPACK NOT REPLACING THE FILES IN THE SECURITY DIRECTORY.
IT21679 2 DB2IUPGRADE FAILS BECAUSE NO DB2_INSTANCE_END PORT IN SERVICES FILE.
IT21926 3 WRONG TRIGGER IS BEING DROPPED FROM PACKED DESCRIPTOR RECORD IF USING LONGER SCHEMA NAME AND SAME TRIGGER NAME.
IT22555 3 DIAGPATH IS CHANGED TO SQLLIB/DB2DUMP FROM THE DEFAULT PATH DURING CREATING ESE INSTANCE
IT22058 3 DB2RSPGN GENERATES AN INCORRECT RESPONSE FILE
IT23072 3 SQL0156N WHEN UPDATING STATISTICS IN SYSSTAT.TABLES
IT21911 3 DB2CKUPGRADE FAILS WITH DBT5501N IF PATH/FILENAME CONTAINS "-D"
IV99188 3 ADDING MEMBER MAY FAIL WITH DBI20048E ERROR IF THE VALUE SPECIFIED FOR '-M' OPTION DOES NOT MATCH THE CASE OF HOST
IT21914 3 ON WINDOWS PLATFORMS, RETRIEVING AN SSL CERTIFICATE FROM THE OS CERTIFICATE STORE MIGHT FAIL FOR CLIENT PRODUCTS
IT23221 3 SILENT INSTALL OF DATA SERVER DRIVER PACKAGE REBOOTS EVEN THO REBOOT=NO CONFIGURED
IT22589 4 DB2AUDIT IS NOT REPORTING SQL0551N WHEN A USER WITH INSUFFICIENT AUTHORIZATION ATTEMPTS TO CALL A PROCEDURE
Fix Pack m3fp3  -   Monitoring
IT21440 2 INSTANCE CRASH EVENT MONITOR WHEN PERFORMING A LOAD VIA CURSOR
IT22782 2 STORED PROCEDURE SAPTOOLS.PARTITION_MERGE SPORADICALLY FAILS WITH SQL668 REASON CODE 11
Fix Pack m3fp3  -   Parsing and SQL PL
IT20899 2 DB2 MAY ABEND WHILE RESTORING A DATABASE
IT19165 2 FETCH-FIRST-CLAUSE RESULTS IN SQL0104N
Fix Pack m3fp3  -   Platform Specific
IT24170 1 SECURITY: DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
IT21181 2 SUBOPTIMAL PERFORMANCE MAY PERSIST ON AN STMM-TUNED SYSTEM DUE TO LARGE CONSUMER NOT GIVING UP MEMORY
IT21441 2 PROCESSOR SPECIFIC OPTIMIZATIONS ARE NOT USED AS EXPECTED
IT21182 2 INTERRUPTED QUERY/SORT OPERATION CAUSES STMM TO UNNECESSARILY INCREASE SORT CONFIGURATION (SHEAPTHRES_SHR)
IT20818 2 DB2NODES.CFG GETS CORRUPTED DURING A HA SHARD DISK FAILOVER.
IT21211 3 SLOW DATABASE ACTIVATION, CREATE/ALTER BUFFERPOOL, LOAD OPERATIONS ON LARGE WINDOWS SYSTEMS
Fix Pack m3fp3  -   Problem Determination
IT21317 2 DB2 RESETS THE SYSLOG FACILITY TO USER
IT22008 2 DB2DART MIGHT TRAP WHEN FACED WITH CORRUPTIONS IN BLU TABLES
Fix Pack m3fp3  -   Process Model
IT22622 2 INSTANCE MAY CRASH WHEN SQLGGTSS API IS RUN WITHOUT A CONNECTION
IT21924 2 MEMBER PANIC DUE TO INVALID MEMORY SIZE IN SQLEINITWLDISPATCHER()
IT23206 2 SQL5133N AFTER MOVING A DB2 CLIENT INSTALLATION TYPE TO SERVER TYPE
IT21927 2 BLOCK DROPPING OF CF DURING ROLLING UPGRADE
IT20924 2 IN DPF OR PURESCALE, TRAP OR HANG POSSIBLE AFTER INTERRUPT OF INTERNAL SQL
Fix Pack m3fp3  -   Query Compiler Optimizer
IJ02639 1 CDE OPTIMIZER UNINTERRUPTIBLE HANG IN HSJN WHEN INNER ROW SIZE > 32K
IT20887 2 POOR PERFORMANCE IN A FEDERATED ENVIRONMENT WHEN LOCAL PREDICATE ON COLUMNS WITH SMALL NUMBER OF DISTINCT VALUES, <=3.
IT21422 2 DB2 MAY ABEND WHILE TRACING IS ON
IT23741 2 A QUERY OVER NICKNAMES OR COLUMN ORGANIZED TABLES CONTAINING FETCH FIRST N ROWS ONLY CLAUSE MAY RETURN INCORRECT RESULTS
IT21449 2 DB2 MAY RETURN -901 OR ABEND DURING UPDATE/DELETE CONTAINING A SUBSELECT AND NON-COLLOCATED TABLES
IT21033 2 COST OVER-ESTIMATE OF THE REFETCH DURING UPDATE/DELETE/MERGE OPERATION
IT23907 2 IN CDE, INCORRECT RESULTS MIGHT BE RETURNED FOR A QUERY THAT REFERENCES A CORRELATED SCALARY SUBQUERY IN A PREDICATE
IT21816 2 THE OPTIMIZER MIGHT CHOOSE A NON-OPTIMAL FULL TABLE SCAN COMPARE D TO A BETTER PERFORMING INDEX ACCESS ON THE INNER OF AN NLJOIN
IT21936 2 DB2 OPTIMIZER MIGHT PRODUCE SUB-OPTIMAL ACCESS PLAN FOR QUERY REFERENCING COLUMN ORGANIZED TABLE WITH PRIMARY KEY
IT21918 2 CRASH MAY OCCUR CREATING STORED PROCEDURE WITH XML QUERY WITH PASSING BY REF ON HOST VARIABLE
IT20825 2 DB2 BLU QUERY CAN END UP WITH WRONG JOIN ORDER SO THAT HASH JOIN IS BUILDING ON LARGE TABLE
IT23875 2 WRONG RESULTS ARE POSSIBLE WHEN EXECUTING A SQL STATEMENT ELIGIBLE FOR ZIGZAG JOIN ON A NON-PARTITIONED INDEX
IT22580 2 CRASH MAY BE ENCOUNTERED WHILE COLLECTING EXPLAIN ON A QUERY.
IJ01362 2 IN DPF, WITH ORDER BY IN THE QUERY, YOU MIGHT HIT THE FOLLOWING SQL0901 ERROR
IT22968 2 RUNSTATS WITH INDEX SAMPLING CAN PRODUCE INCORRECT NLEAF OF PARTITIONED INDEX FOR LARGE RANGE PARTITIONED TABLE
Fix Pack m3fp3  -   Query Compiler QGM
IT22586 1 POOR PERFORMANCE WHEN FORCE_REPLICATED_MQT_MERGE IS SET
IT22590 1 POOR PERFORMANCE WHEN LARGE NUMBER OF EXPRESSIONS IN THE QUERY
IT20884 2 DB2 MAY RETURN AN UNEXPECTED ERROR OR ABEND WHILE CASTING TO A UDT
IT23915 2 SQL901N MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING UNION IN CDE
IT23742 2 DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING OR PREDICATES AND EXISTS PREDICATES
IT23261 2 INCORRECT RESULTS WITH AGGREGATION ON OUTER JOINED TABLE WITH FOREIGN KEY ON NULL PRODUCING TABLE
IT22826 2 WRONG RESULT WHEN PREDICATE HAS CONCATENATED CONSTANT AND COLUMN.
IT17699 2 DB2 INSTANCE MAY ABEND WHEN PREPARING A SQL QUERY
IT22505 2 DB2 MAY INCORRECTLY RETURN SQL0420N WHILE COMPILING A QUERY CONTAINING UNION ALL OPERATORS
IT18428 2 DB2 POOR PERFORMANCE IN UPDATE QUERY HAVING CORRELATION
IT21604 2 DB2 SERVER TERMINATES ABNORMALLY IN SQLNLS_UNPADDEDCHARLEN DURING QUERY COMPILATION
IT24041 2 WRONG RESULTS OR SQL901N ERROR POSSIBLE WHEN EXECUTING SQL STATEMENT WITH SCALAR SUBQUERY ON COLUMN ORGANIZED TABLES
IT21303 2 CU32 IN CDE WRONG RESULT. MORE DETAILS TO COME.
IT21922 2 DB2AUDIT: USE OF UNINITIALIZED OBJECT SCHEMA IN AUDIT DATA.
IT22363 2 SAP: POOR PERFORMANCE WHEN SAP MEMORY TABLE IN JOIN ON COLUMN ORGANIZED TABLES
IT19440 2 SQL0901N WHEN COLUMN MASK ON NOT NULLABLE COLUMN RETURNS ALWAYS NOT NULL AND COLUMN IS IN NULL PRODUCING SIDE
IT21466 2 SQL0901/SQL0404/ABEND ARE POSSIBLE IN SOME CASES WHEN COMPILING UPDATE STATEMENT
IT22630 2 WE CAN SAY THERE IS CLEARLY A REGRESSION INTRODUCED WITH THE EXTENSION OF THE EXISTS-TO-ANTIJOIN IN 10.1
IT21240 2 SQL0083C - MEMORY ALLOCATION ERROR WHEN SAME COLUMN IN LOCAL AND IN PREDICATE IN CASE STATEMENT
IT22221 2 WRONG RESULTS OR SQL901N MAY OCCUR WHEN EXECUTING A SQL STATEMENT CONTAINING TWO OR MORE NOT IN OR NOT EXISTS PREDICATES
IT21053 2 QUERY COMPILATION MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT22646 2 -901 OR TRAP WHEN OUTER JOIN ON GROUP BY AND UNION
IT22880 2 DB2 ENGINE MIGHT CRASH WHEN QUERIES HAVE OUTER JOINS, NOT EXISTS OR NOT IN PREDICATES
Fix Pack m3fp3  -   Relational Data Services
IT23315 2 A TRAP, PANIC OR A -901 SQLCODE (SQLRA_FREE_SECTION: SECTION NOT CLOSED) OCCURS IN DPF
IT21694 2 DB2 FAILS TO REINITIALIZE THE PL/SQL PACKAGE AFTER RECOMPILATION OF THE PACKAGE BODY IN AN ORACLE COMPATIBLE DATABASE.
IT21996 2 SQL0901N ERROR CAN BE HAPPENED WHEN USING AN INDEX ON EXPRESSION
IT21923 2 POSSIBLE TRAP IN RELEASECONFLICT() BECAUSE PAUDITSETTINGS->AUDITSETTINGSLATCH IS ALREADY UNLOCKED
IT22658 3 EXPLAIN STATEMENT INCLUDING A PARAMETER MAKER FROM JCC APPLICATION MAY CAUSE THE INSTANCE CRASH
IT22446 4 MISSING WARNING WHEN REBIND WITH APREUSE
Fix Pack m3fp3  -   Routine Infrastructure
IT22759 2 DB2 AGENT/DB2FMP CAN HANG DUE TO INCOMPLETE HANDSHAKE DURING INTERRUPT
IT21460 2 DB2_FMP_COMM_HEAPSZ VALUES GREATER THAN 1GB NOT HONORED
IT20643 2 DB2FMP CRASH OR TRAP WHEN RUNNING MONITORING QUERIES
IT21925 2 DURING NORMAL PROCESSING "ROUTINE FAILED WITH TERMINATION ERROR" ARE LOGGED AS ERROR IN DB2DIAG.LOG
Fix Pack m3fp3  -   Security
IT24155 2 CONNECTIONS FAIL IN CRYPTDIGESTINIT WITH ECF_CRYPT_UNEXPECTED_ERROR
IT24059 2 SECURITY: UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT21848 2 LDAP PLUGIN NOW ALLOWS SIGNATURE ALGORITHMS TO BE SPECIFIED WHEN USING TLS 1.2
IT20345 2 CONNECTIONS FAIL IN CRYPTDIGESTINIT WITH ECF_CRYPT_UNEXPECTED_ERROR
IT22623 2 CONNECTION HANG ON V10.5FP8 ONLY ON SOLARIS WITH SPARC64-X
IT21909 2 SLOW PERFORMANCE IN DB2AUDIT EXTRACT DELASC DUE TO MANY SMALL WRITES TO THE OUTPUT FILE
IT23355 2 ADDRESS MASTER SERVER BLACKOUT ISSUE AND DEK CACHING
Fix Pack m3fp3  -   Text Search
IT20912 3 UPGRADING DB2 V10.1 TO V11.1 WITH TEXT SEARCH RESULTS IN INCORRECT CATALOG UPDATE
IT21928 3 MBCS DOT CHARACTER IN JAPANESE GOT IQQS0032E ERROR IN CONTAINS FUNCTION
Fix Pack m3fp3  -   XML
IT22783 1 INCORRECT RESULT WHEN USING THE XMLTABLE FUNCTION AND REFERENCING ELEMENTS THAT DON"T EXIST IN THE SOURCE DOCUMENT
IT21913 2 INSTANCE CAN TRAP IN XMLRNPERMMNXRFORMATTER::ENDREGIONINSERT WHEN INSERTING/DELETING XML RECORDS
Fix Pack m3fp3  -   pureScale Services
IV98881 1 DB2START DOESN'T SET THE KERNEL PARAMETERS(ACCEPT_LOCAL, ARP_IGNORE,RP_FILTER)ON MEMBER AUTOMATICALLY IN V10.5
IT23400 2 THE "DB2HAICU -DELETE" COMMAND MAY FAIL TO DELETE RESOURCES FOR THE INSTANCE IF A RESOURCE WAS INCOMPLETELY CREATED
IT21929 2 DB2START FAILS DUE TO THE TSA LICENSE INFORMATION GATHERED IN A LANGUAGE OTHER THAN ENGLISH
IT23281 2 THE DB2HAICU UTILITY MAY APPEAR TO HANG IN A DPF HA ENVIRONMENT CONTAINING MANY HOSTS
IT21587 2 DB2 TAKEOVER HADR COMMAND FAILS WITH SQL1387W IN AUTOMATED HADR ENVIRONMENT
IT21932 2 ADDRESS SPACE CONFLICT MAY OCCUR IN DB2GCF IF ASLR IS ENABLED
IT22628 2 GPFS ENTERS ARBITRATING STATE ON DB2CLUSTER MAINTENANCE.
IT21553 2 THE PRIMARY HADR DATABASE FAILS OVER TO THE STANDBY AFTER CONFIGURING FOR HA VIA DB2HAICU.
IJ00150 2 ERROR UPDATING LOCK SIZE (CF_LOCK_SZ) INCORRECTLY SETS THE RESIZE STATE.
IT22805 2 CF STUCK IN CATCHUP STATE
IT23441 2 DB2 MEMBER IS KILLED AND RESTARTED DUE TO GPFS MOUNT RESOURCE TEMPORARILY REPORTING OFFLINE
IT23128 2 CREATE DATABASE RETURNS -1051
IT23420 2 THE MOUNTV111_STOP.KSH SCRIPT MAY ERRONEOUSLY RUN THE FUSER -K COMMAND AGAINST THE ROOT FILE SYSTEM
IT21530 2 DB2CLUSTER ADD DISK TO A FILESYSTEM MAY FAIL IF THE FILESYSTEM CONTAINS A LARGE NUMBER OF DISKS
IT20621 2 SQL5190I HIT WHEN UPDATING DIAGPATH OR ALT_DIAGPATH TO NON-GPFS FILESYSTEM
IT19365 2 IN CASE OF SETTING UP DB2HAICU WITH MULTIPLE NIC CARDS, PROVIDE THE OPTION TO SKIP A CERTAIN NIC
IT24290 3 MOUNTV105_START.KSH COULDN'T DETERMINE FILESYSTEM TYPE AND FINALLY ATTEMPT TO "FSCK -P".
IT22237 3 THE DB2FMCD PROCESS DOES NOT START DB2 INSTANCES AT SYSTEM BOOT TIME.

DB2 Version 11.1 Fix Pack m2ifx002
APAR Sev. Abstract
Fix Pack m2ifx002  -   Buffer Pool Services
IT23161 1 UNDER DB2 DEVELOPER-C EDITION LICENSE, CREATE DATABASE WILL FAIL WITH SQL1139N.
Fix Pack m2ifx002  -   CDE Data
IT23158 2 SQL0901N COULD CAUSE INSTANCE OUTAGE FOR CDE CENTERED QUERIES, IF MESSAGE IS LONGER THEN 256 BYTES.
IT22522 3 CHECK SYNOPSIS TABLE WHENEVER IT IS QUERIED
Fix Pack m2ifx002  -   CDE Query
IT22780 1 CRASH MAY OCCUR DURING CDE JOIN WHEN PROCESSING A LARGE AMOUNT OF DATA
IV99561 1 RARE TRAP DURING CDE HASH JOIN WHEN DATA VOLUME ON THE INNER OF THE JOIN IS EXTREMELY LARGE
IV97845 2 A QUERY AGAINST COLUMNAR ORGANIZED TABLE AND ARITHMETIC ON BOTH TIME AND DECIMAL DATATYPES MAY RETURN INCORRECT RESULT
IT21985 2 DOING LIKE ON A CODEUNITES32 FIXED LENGTH COLUMN IN THE COLUMNAR ORGANIZED TABLE COULD RETURN AN INCORRECT RESULT
Fix Pack m2ifx002  -   Client Interfaces
IT23069 2 FILEDSN IS NOT WORKING WITH V111M2FP2 : SPECIFIED DRIVER COULD N OT BE LOADED DUE TO SYSTEM ERROR 1114: A DYNAMIC LINK LIBRARY (
IT21578 2 FILEDSN IS NOT WORKING WITH V111M2FP2. DB2CLIO.DLL FAILS WITH SYSTEM ERROR 1114.
IT22632 2 SCRIPTS FAILS WITH SQLSTATE 42702 / SQLCODE: -204
IT23402 3 "CLP SELECT STATEMENT DISPLAY FIX FOR CHAR AND VARCHAR CODEUNITS32 STRING UNITS"
Fix Pack m2ifx002  -   Codegen and Runtime
IT22013 1 WRONG RESULT IS POSSIBLE WHEN CODEUNITS 32 IS USED IN A ROW DATA TYPE ASSIGNMENT AND CAST IS USED
IT23431 2 STATEMENT MAY FAIL WITH FOLLOWING ERROR: PERMANENT TAOB FOR MDC BIXA OBJECT IS NULL
IT22750 3 POSSIBLE WRONG RESULTS WITH VARCHAR_FORMAT WHEN USING 'DY DDD YYYY' FORMAT
Fix Pack m2ifx002  -   Data Management Utilities
IT23419 2 EXTRA SPACES GENERATED FROM EXPORT WHEN USING CODEUNITS32
Fix Pack m2ifx002  -   Data Recovery Services
IT23073 2 CRASH RECOVERY OR A DATABASE ROLLFORWARD OR HADR TAKEOVER MAY FAIL DURING ONLINE RECOVERY PROCESSING.
Fix Pack m2ifx002  -   Index Manager
IT22386 1 DB2 : IF ANY COMMAND WITH RECLAIM EXTENTS OPTION IS RUN ON AN MDC TABLE DURING A BACKUP, A ROLLFORWARD ON IT COULD FAIL
Fix Pack m2ifx002  -   Query Compiler Optimizer
IJ00193 3 PARALLEL IXSCANS FOR COLUMN-ORGANIZED TABLES MIGHT CAUSE AN ABEN D/WRONG RESULTS IF UPDATE ACTIVITY OCCURS IN THE SAME CONNECTION
Fix Pack m2ifx002  -   Query Compiler QGM
IT21948 2 DB2 MAY RETURN WRONG RESULTS WITH ORACLE COMPATIBILITY AND SUBSTR
IT22946 2 LPAD/RPAD RETURN EMPTY STRING INSTEAD OF NULL IN ORA-MODE DATABASE
IT22345 3 WRONG RESULT WHEN EXPRESSION ON JOIN COLUMN

DB2 Version 11.1 Fix Pack m2ifx001
APAR Sev. Abstract
Fix Pack m2ifx001  -   Buffer Pool Services
IT21437 2 ON ENCRYPTED DATABASES RUNNING EXTENT MOVEMENT EXTENTLATCH HELD BY PAGE CLEANER NOT RELEASED CAUSING HANG
Fix Pack m2ifx001  -   CDE Data
IJ00488 2 WRONG RESULTS RETURNED WITH EXCLUSIVE TABLE LOCK
IT21100 2 UPDATE OF UNIQUE COLUMNS MIGHT RESULT IN DUPLICATES IN A TABLE WITH A UNIQUE INDEX
Fix Pack m2ifx001  -   CDE Query
IT22111 2 CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES WHEN HASH TABLE NEEDS TO BE SPILLED FOR A GROUPBY
IT20786 2 INCORRECT RESULT POSSIBLE WHEN CASE AND ANOTHER PREDICATE HAVE THE SAME COMPARISON OPERATION
IT22110 2 CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES DURING HASH TABLE JOIN
IT19976 2 SQL QUERIES WITH IN OR NOT IN CLAUSE MAY PRODUCE INCORRECT RESULTS FOR A COLUMN-ORGANIZED TABLE
IT20720 3 TRUNCATING CAST TO (VAR)CHAR AGAINST A COLUMNAR ORGANIZED TABLE COULD RETURN DANGLING BYTE INSTEAD OF A BLANK CHARACTER.
Fix Pack m2ifx001  -   Codegen and Runtime
IT22211 2 QUERY PERFORMANCE ISSUE WITH SMP PARALLELISM AND "LIMIT ?" CLAUSE
IT20518 2 IN DPF, WHEN UNIQUE TQ IS PRESENT IN THE PLAN AND SPECIAL INTERN AL PERF OPT IS HAPPENING, POSSIBLE DUPLICATE VALUES RETURNED
IT22118 3 WINDOWS EVENT HANDLE LEAK WITH PARALLELIZED QUERY PLANS (INTRA_PARALLEL YES) - MAY CAUSE OSERR 1450
Fix Pack m2ifx001  -   DRDA Services
IT22599 2 UNABLE TO LOAD MORE THAN 2GB THROUGH REMOTE EXTERNAL TABLE USING DB2 CLIENTS.
IT21455 3 SECURITY: DB2CONNECT SERVER CAN CRASH UNDER SPECIFIC CONDITIONS.
Fix Pack m2ifx001  -   Install and Catalog Services
IT22643 2 [IFIX_CANDIDATE] ADD DSCLIENT SWIDTAG FILE TO PACKAGING
IT21347 2 SECURITY: CONNECTION STRING DISPLAYED IN ERROR MESSAGE
Fix Pack m2ifx001  -   Process Model
IT21458 1 SECURITY: DB2 CAN BE USED TO OVERWRITE ARBITRARY FILES OWNED BY DB2 INSTANCE
Fix Pack m2ifx001  -   Query Compiler QGM
IT18136 2 INSERT QUERY THAT HAS A COLUMN VALUE GENERATED USING TRIGGER COULD PRODUCE WRONG RESULTS OR SQL0407N
IT20438 2 INCORRECT RESULT OR SQL0811N ARE POSSIBLE WHEN SQL CONTAINS SCALAR NOT EXISTS SUBQUERY
IT21400 2 SERVER TERMINATES ABNORMALLY DURING QUERY EXECUTION
IT20949 2 SQL0901N WHEN SAP MEMORY TABLE JOINS WITH UNION DISTINCT HAVING JOIN
Fix Pack m2ifx001  -   Routine Infrastructure
IT21140 1 SECURITY: ESCALATION TO ROOT VULNERABILITY IN DB2.
Fix Pack m2ifx001  -   Security
IT21459 1 SECURITY: USER WITHOUT PROPER AUTHORITY CAN ACTIVATE DATABASE.
Fix Pack m2ifx001  -   pureScale Services
IT22532 1 FAILURE ON MEMBER-CF COMMUNICATION ONCE ONE OF REDUNDANT SWITCHES IS FAILED.
IT21167 1 SECURITY: ESCALATION TO ROOT VULNERABILITY IN DB2.

DB2 Version 11.1 Fix Pack m2fp2
APAR Sev. Abstract
Fix Pack m2fp2  -   Administration Tools
IT19594 2 CLI0112E FROM DB2BATCH JOB
IT19610 2 AUTOMAINT_GET_POLICY RETURNS INCORRECT OUTPUT
Fix Pack m2fp2  -   Buffer Pool Services
IT20923 1 EXTENT MOVEMENT WITH NATIVE ENCRYPTION COULD LEAD TO CORRUPTED PAGE ONLY IN-MEMORY
IV91111 2 DROP/TRUNCATE PARTITION TABLE IS VERY SLOW ON PURESCALE
Fix Pack m2fp2  -   Build Team
IV96938 2 HIT WITH 901 WHILE DOING SORT ON BOOLEAN DATATYPE IN DB2_DEBUG MODE
IT18995 2 CF MAY ENCOUNTER A HANG AND GET RESTARTED WITH THE FOLLOWING MES SAGE LOGGED IN DB2DIAG.LOG - PS GET SERVER ROLE FAILED. STATUS:
IV91110 2 CF SIGNAL HANDLER INCORRECTLY DETACHED TRACE MEMORY CAUSING ANOTHER THREAD CRASH
IV92503 2 -901 OBSERVED WHILE RUNNING FK FILTER SCENARIO FOR BOOLEAN
IT20566 3 SECURITY: DB2 IS AFFECTED BY VULNERABILITIES IN COMPRESSION ROUTINES.
Fix Pack m2fp2  -   CDE Query
IT18083 2 WRONG RESULTS AGAINST COLUMN ORGANIZED TABLE ARE POSSIBLE WITH EXPANDING JOIN PLAN
IT18873 2 MEMORY LEAK IN CDE-SORT WHEN USING BLU-MPP ENVIRONMENT
Fix Pack m2fp2  -   Client Interfaces
IT20562 1 SECURITY: DB2 CLP WILL TRAP IF IT IS PASSED A ROUTINE NAME GREATER THEN THE ALLOWED MAXIMUM LENGTH (CVE-2017-1297).
IT18786 2 SQLGETINFOW RETURN INCORRECT VERSION NUMBER
IT20294 2 CONNECTION ATTRIBUTE SQL_ATTR_CLIENT_APPLCOMPAT IS NOT CORRECTLY SET
IT19251 2 CALLING A STORED PROCEDURE AGAINST NON-UDB SERVER RESULTS IN DB21102E
IT18042 2 SQL0998 RETURNED FROM ENLISTDISTRIBUTEDTRANSACTION
IT20198 2 THE IMPLICIT CONNECT RESET WHEN IN A DB2DBDFT ENVIRONMENT
IT20290 2 CLP MAY HANG IF IT GETS SIGNAL WHILE IT TERMINATES
IT20156 2 INVALID LENGTH/PRECISION FOR BOOLEAN IN DASHDB
IT20502 2 DB21018E RETURNED TO A CLP COMMAND RUN VIA NOHUP IF THE PARENT SHELL HAS EXITED.
IT19300 2 CLI APPLICATION MAY GET CLI0002W DURING CALLING SQLGETCONNECTATTR ON DPF
IT18550 2 PASSWORD IN DB2CONNECTION.CONNECTIONSTRING DISPLAYED IN SYSTEM.R EFLECTION.FIELDINFO OUTPUT WITH PERSIST SECURITY INFO=FALSE
IT18766 2 DB2 ADO .NET RETURNS CLI0102E WHEN CALLING PREPARE
IT16132 2 DB21018E RETURNED TO A CLP COMMAND RUN VIA NOHUP IF THE PARENT SHELL HAS EXITED.
IT19570 3 INCORRECT ERROR 406 FOR SELECT STATEMENT
IT18649 3 CLP CALL STATEMENT IN DB2 V11.1 IS BEHAVING DIFFERENTLY FROM PREVIOUS VERSIONS AND IT RESULTS IN SQL0433N.
IT20871 3 DB21034E OCCURS FOR "SELECT" SQL STATEMENTS STARTING WITH BLOCK COMMENTS THROUGH CLP
IT19039 3 SIGSEGV IN CLI FUNCITON CLIEXECCMRIFLUSHARRAY ON SQLCANCEL WHEN USING MULTI-ROW INSERT (MRI) FEATURE
Fix Pack m2fp2  -   Codegen and Runtime
IT17549 1 FODC/TRAP WHEN RUNNING SOME KIND OF QUERY
IT18506 1 DB2 CAN RETURN WRONG RESULTS WHEN USING THE SPECIAL REGISTER 'CU RRENT DECFLOAT ROUNDING MODE' IN A QUERY IN AN MPP ENVIRONMENT
IT19533 2 SIGNIFICANT INCREASE IN SHARED APPLICATION HEAP AFTER UPGRADE TO 10.5 FOR QUERIES REFERENCING RANGE PARTITIONED TABLES
IT19152 2 CALLING DBMS_SQL ROUTINES CAN LEAK MEMORY BLOCKS.
IV93080 2 WRONG RESULT IS POSSIBLE WHEN COLUMNAR TABLES ARE INVOLVED IN A PLAN WITH A UNION AND CSE IS PUSHED DOWN ON TO CDE
IT19457 2 INSTANCE CRASH DUE TO STACK OVERFLOW DURING EXECUTION OF AN XQUERY WITH A LARGE NUMBER OF PREDICATES.
IT19370 2 DB2 MAY ABEND IN AN MPP ENVIRONMENT WHEN A QUERY INVOLVES XML COLUMNS AND THE KEYWORD DISTINCT
IT20174 2 DB2 MAY ABEND WHEN A PLAN CONTAINING AGGREGATION IS INTERRUPTED AND SUBSEQUENTLY REEXECUTED
IT18339 2 -420 ( INCORRECT FORMAT), IF DATA IS BOUND AS CHAR TO A DECIMAL COLUMN BY EBCIDIC CLIENT
IT20242 2 SQL20288N "INDEX WITH XPTH TYPE". REASON CODE = "3" USING DB2LOOK -M OUPUT
IT14154 2 SIGNIFICANT INCREASE IN SHARED APPLICATION HEAP AFTER UPGRADE TO 10.5 FOR QUERIES REFERENCING RANGE PARTITIONED TABLES
IT18742 3 TRUNC ON MINIMUM INTEGER VALUE MIGHT RETURN 0 WHEN (VALUE, -X) IS DONE
Fix Pack m2fp2  -   DB2 Tools
IT19003 2 EXESSIVE ENTRY IN DB2DIAG.LOG AFTER RUN DB2PD -HADR COMMAND
IT19663 3 PROBLEM WITH THE GENERATED C/C++ CODE FROM THE DB2 PREP. IT CANNOT COMPILE WHEN IT CONTAINS THE ARRAY INSERT/UPDATE.
Fix Pack m2fp2  -   Data Management Services
IT18118 2 INSTANCE CAN TRAP IN SQLDVALFROMFIXEDCOMMON WHEN SELECT A NULL CLOB
IT18797 2 PURESCALE: QUERY MIGHT RETURNS WRONG RESULT WHEN INPLACE (ONLINE) TABLE REORGANIZATION IS RUNNING
IT20873 3 "DB2PD -REORG" DOESN'T SHOW ONLINE REORG INFORMATION ON PURESCALE
Fix Pack m2fp2  -   Data Management Utilities
IT18502 1 DB2 MAY RETURN SQLCODE:-901 OR RETURN WRONG RESULTS ON QUERIES WITH PLANS THAT INVOVLE SORT ON AN ENCRYPTED DATABASE
IT18375 2 LOAD FROM V11 AIX OR WINDOWS CLIENT AGAINST DOWNLEVEL SERVER (OLDER THAN V10.5 FIXPACK 3) MIGHT FAIL WITH SQL1651N
Fix Pack m2fp2  -   Data Recovery Services
IT19230 2 MON_GET_UNIT_OF_WORK INTERFACE - UOW_LOG_SPACE_USED REPORTING MIGHT BE INCORRECT
IT19925 2 ENCRLIB AND ENCROPTS VALUES MAY BE DISPLAYED INCORRECTLY, OR NOT DISPLAYED AT ALL, WHEN USING A V11.1 CLIENT TO DOWNLEVEL SERVER
IT19128 2 DB2ACSUTIL MAY TRAP IF THE OPTION OLDER THAN <N> DAYS AGO IS NOT COMPLETELY USED
IT19187 2 DB2 WILL TRAP IF THE SUBTRANSACTION WORKS ON A TABLESPACE WITH ID > 4096
IT18603 2 SQL1419N ERROR (REASON CODE 23) IN PURESCALE ENVIRONMENT WHEN USING THE REBUILD OPTION OF THE RESTORE COMMAND.
IT18984 2 UPDATE THE COLUMN OTHER THAN LOB TO THE SAME VALUE, A LOG RECORD IS WRITTEN
IT19323 3 ENV_GET_REG_VARIABLES RETURNS DEFAULT VALUE OF DB2_HADR_NO_IP_CHECK INCORRECTLY.
Fix Pack m2fp2  -   Federation
IV92847 2 A SQL0901N ERROR DURING COMPILATION OF QUERY WITH UNION CONTAINING FOR BIT DATA COLUMN FROM COLUMN ORGANIZED TABLES
Fix Pack m2fp2  -   Index Manager
IV93868 2 A DEADLATCH AND HANG OCCURS WHEN ALTERING A TABLE TO ATTACH A PARTITION WITH XML INDEXES
IT18944 2 POSSIBLE HANG CAUSED BY A 'DB2TASKP' EDU WHEN BRINGING DOWN A DATABASE
IV96953 2 PRIMARY KEY CONTAINING INTEGER AND BOOLEAN TYPES CAUSES TRAP AFTER INDEX KEY INSERTION
Fix Pack m2fp2  -   Install and Catalog Services
IT19607 1 WINDOWS SERVICES WITH PATH TO BINARY LONGER THAN 260 CAUSE MEMORY CORRUPTION DURING INSTALL
IT19712 2 REVOKING PRIVILEGES MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT20462 2 SECURITY: TSAMP PRIVILEGE ESCALATION VULNERABILITY AFFECTS DB2 (CVE-2017-1134).
IT19572 2 DB2IPRUNE AND DB2_INSTALL FAIL WITH LIBIBMC++.SO.1: CANNOT OPEN SHARED OBJECT FILE
IT19312 2 REMARKS ON VIEW COLUMNS NOT RETAINED AFTER CHANGES TO BASE TABLE.
IT18129 2 TEST FOR -NOEXEC MOUNT INCORRECTLY FAILS IN DB2SETUP SCRIPT
IT20355 2 DBT5555N THE DB2CKUPGRADE UTILITY FAILED BECAUSE THE DATABASE HAS ONE OR MORE INVALID OBJECTS.
IT16602 2 REMOVE THE SETTING OF DB2INSTDEF
IT20203 2 SAP: ERROR SQL0607N FOR FUNCTION SYSFUN.ASCII1 FROM "DB2UPDV111 -R ..."
IT17148 2 ACCIDENTAL REMOVAL OF DAT FILE FROM SMS TABLESPACE COULD RESULT IN DUPLICATE TABLE IDS IN CATALOGS
IT18668 2 DB2 INSTALLATION WITH TSAMP HITS SEGMENTATIONS FAULT ON UBUNTU
IT20351 2 DB2 CHECK UPGRADE TOOL RETURNING WARNING ABOUT DISCONTINUED FUNCTION SYSFUN.ASCII1.
IT17673 3 DB2CAT -G DOES NOT GENERATE A USABLE PACKED DESCRIPTOR FOR PARTITIONED TABLE
IT18811 3 DB2CKUPGRADE FAILS TO IDENTIFY "TABLE DICTIONARY VERSION MISMATCH" INDUCED BY APAR IV53366
IT19722 3 EXECUTION OF INSTALLFIXPACK MAY FAIL BECAUSE THE COMMAND IS NOT ABLE TO DETECT IF DB2 LIBRARIES ARE STILL LOADED IN MEMORY.
IT19380 3 THE DB2.EMP DIRECTORY IS NOT REMOVED AFTER V11.1 INSTALL FIXPACK1
IT17372 4 DBI20050I SHOULD MENTION RUN THE DB2IUPDT ON ALL HOSTS IS NOT APPLICABLE TO DPF ENVIRONMENT
Fix Pack m2fp2  -   JDBC
IT19753 3 TYPE-4 LUW CONNECTIVITY: ISSUE IS WITH DATA ENCRYPT WITH NULL LOB VALUE THERE IS EXCEPTION IN JCC TRACE WITH EMPTY DATA.
IT20937 3 TYPE-4 CONNECTIVITY: WHILE DOING THE PORTAL DATABASE TRANSFER USER IS GETTING UNRECOGNIZED JDBC TYPE: -9. ERRORCODE=-4228, SQLSTATE=NULL
Fix Pack m2fp2  -   Monitoring
IT17287 2 A LOCKING EVENT MONITOR CAN INCORRECTLY CAPTURE STATIC STMT TEXT AND REPORT INCORRECT NUMBER OF INPUT VARIABLES
IT19962 2 SLOW PERFORMANCE WHEN MONITORING SQL ROUTINES
IT17754 2 "UOW LOG SPACE USED" IN APP SNAPSHOT NEVER RESET WHEN USING XA TRANSACTION
IT16408 3 DYNAMIC SQL SNAPSHOT MAY FAIL WITH SQL1224N WHEN CLIENT AND SERVER USE DIFFERENT CODEPAGE
IT20870 4 ZRC=0X80580003=-2141716477=SQLKD_INTERRUPT "MAPPING FOR SQLKF_INTRP" DIA8003C APPEARS IN DB2DIAG.LOG REPEATEDLY
Fix Pack m2fp2  -   Platform Specific
IT20105 1 CONTINUOUS PRIVATE MEMORY GROWTH ON DB2/AIX SYSTEMS WITH VERY LOW ACTIVITY
IT20104 1 UNEXPECTED OOM ERRORS AFTER A LARGE DYNAMIC DATABASE CONFIGURATION INCREASE
IT19442 2 A DB2 FENCED ROUTINE MAY FAIL WITH ERROR SQL1646N DUE TO SHARED MEMORY PERMISSION PROBLEMS
IT20046 3 GLOBAL BENEFIT IS INVALID
IT20869 3 DB2 CLIENT APPLICATION ON WINDOWS MAY CRASH IN WINDOWS' FUNCTION CALLED FROM DB2SYS!SQLZDB2SYSDLL.
IT19499 4 ENV_GET_REG_VARIABLES RETURNS INCORRECT DEFAULT VALUES.
Fix Pack m2fp2  -   Problem Determination
IT20563 2 SECURITY: BUFFER OVERFLOW THAT COULD ALLOW A LOCAL USER TO OVER WRITE DB2 FILES OR CAUSE A DENIAL OF SERVICE (CVE-2017-1105).
IT18449 3 SHOULD NOT DUMP "PDDIAGREADFROMFILEINTOBUFFERBS, PROBE:25" WITH DIAGLEVEL 3
Fix Pack m2fp2  -   Process Model
IT21701 2 "NET STOP" AND "NET START" DO NOT RELEASE THE QUIECE MODE
IT20340 2 SEVERAL ERRORS ARE LOGGED IN DB2DIAG.LOG WHENEVER DB2 LUW RECEIVES A CONNECTION FROM DRDA APPL IN EBCDIC ON AS/400 OR Z/OS
IT13860 2 BACKGROUND DAEMONS MIGHT NOT START JUST AFTER TAKEOVER HADR DUE TO TIMING HOLE.
IT18310 2 ADDITIONAL CALLS IN AGENT BREATHING POINT CAUSE POOR PERFORMANCE IN LOAD UTILITY
IT17367 2 IN DPF ENV, USER WITH APPROPRIATE AUTHORITIES RECIEVES ERROR SQL6048N COMMUNICATION ERROR ON UPDATE DBM CFG
IT17665 2 IN PURESCALE WHEN AN APP RECEIVES SQL0997W MESSAGES ARE LOGGED WITH LEVEL SEVERE/ERROR THAT SHOULD BE INFORMATIONAL
IT20531 3 RESPONSE FILE INSTALLATION FAILS TO SET SYSCTRL_GROUP OR OTHER AUTHORITY GROUPS ON WINDOWS PLATFORM
IT18390 3 UPDATE DBM CFG IN A CLIENT INSTANCE FAILS WITH SQL5126N AFTER UPGRADING FROM LOWER VERSION.
Fix Pack m2fp2  -   Query Compiler Optimizer
IT20401 1 SQLCODE -902 FROM SQLRICLS_COMPLEX ON QUERY WITH COLUMN-ORGANIZE D TABLES AND ROW-ORGANIZED DETACHED CSE TEMPS IN DPF
IT20463 2 INCORRECT RESULTS ARE POSSIBLE WHEN CONCURRENT QUERIES ACCESS COLUMNAR ORGANIZED TABLES AND USE CS ISOLATION
IV95471 2 CERTAIN TYPES OF QUERIES ARE UNNECESSARILY SERIALIZED WHEN A COMBINATION OF ROW AND COLUMN-ORGANIZED TABLES ARE REFERENCED
IT18101 2 AN SQL STATEMENT IN A PARTITIONED DATABASE ENV CONTAINING THE ROW_NUMBER() OVER() OPERATION MIGHT PRODUCE INCONSISTENT RESULTS
IT20126 2 DB2 SIG #11 CRASH IN SQLNO_HINT_VALIDATE WHEN REBINDING USING THE APREUSE (ACCESS PLAN REUSE) OPTION
IT18846 3 SQL0551N RECEIVED FROM A CALL TO EXPLAIN_FROM_DATA STORED PROCEDURE
Fix Pack m2fp2  -   Query Compiler QGM
IT17787 1 SQL STATEMENT WITH AN EXISTS PREDICATE AND A JOIN INVOLVING NON-DETERMINISTIC CORRELATED SUBQUERY MAY RETURN MORE ROWS
IT19092 2 DB2 SERVER TERMINATES ABNORMALLY EXECUTING DDL STATEMENT
IT20872 2 QUERIES CONTAINING OUTER JOIN OPERATIONS AND AN OLAP FUNCTION NE STED WITHIN ONE OF THE INPUT OPERANDS MAY PERFORM POORLY UNDER C
IT19202 2 DB2 MAY ISSUE SQL0119N WHEN REFERENCING A CORRELATED COLUMN INSIDE A SCALAR AGGREGATE FUNCTION
IT18381 2 DB2 MAY RETURN INCORRECT RESULTS IF USING A CASE STATEMENT TO CO MPARE FIXED CHAR/GRAPHIC STRINGS IN VARCHAR2 COMPATIBILITY MODE
IT19631 2 QUERY EXECUTION CAUSES DB2 SERVER TO TERMINATE ABNORMALLY
IT20230 2 DB2 SERVER TERMINATES ABNORMALLY EXECUTING DDL STATEMENT
IT19998 2 ENABLE CDE DATA-SKIPPING FOR QUERIES LIKE " WHERE PARTS_NO LIKE 'ABC%' "
IT19197 2 DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING XQUERY WITH MULTIPLE OR SUBTERMS
IT18496 2 TRAP IN BLD_UPD_COMPENSATION WHEN PREDICATE HAS SCALAR SUBQUERY
IT20090 2 DATE_TRUNC SCALAR FUNCTION RETURNS UNWANTED FRACTIONAL SECONDS WITH SCALE 4 WHEN SECOND INPUT ARGUMENT IS DATE TYPE.
IT18021 2 INCORRECTLY GENERATED DERIVED PREDICATES MIGHT CAUSE INCORRECTQUERY RESULTS DUE TO TRAILING BLANKS
IT20169 2 ABEND POSSIBLE IN QUERY COMPILER DUE TO STALE POINTER ACCESS WHEN USING TRUSTED CONNECTIONS
IT18745 2 DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERY WITH GROUPBY AND OUTER JOIN
IT18204 2 WRONG RESULT IS POSSIBLE IN ORACLE COMPATIBILITY MODE UNICODE DB WHEN COMPARING A CHAR COLUMN WITH A GRAPHIC CONSTANT
IT20155 2 CREATE MASK FAILING WITH BOOLEAN LITERAL VALUE
IT17894 2 PREDICATE COMPARING SUBSTR ON CODEUNITES32 COLUMN IN THE COLUMN AR ORGANIZED TABLE TO HOST VAR COULD RETURN AN INCORRECT RESULT
IT20661 2 WRONG RESULTS MIGHT OCCUR WHEN SCALAR SUB-QUERY IS ON THE LEFT HAND SIDE OF A NOT IN PREDICATE
IT19608 3 DB2 MAY CONVERT VIEW COLUMN TYPES INCORRECTLY OR RETURN SQL0418N UPON REVALIDATION OF A VIEW WITH UNTYPED EXPRESSIONS
IT20874 3 BLOCK USAGE OF UNARY +/- OPERATOR WITH BOOLEAN VALUE TRUE AND FALSE
IT20053 3 DB2 MIGHT PRODUCE SUBOPTIMAL PLAN FOR DEEPLY NESTED NOT EXISTENTIAL SUBQUERIES
Fix Pack m2fp2  -   Relational Data Services
IT19853 1 SIGNAL 11 TRAP AT SQLRA_GET_VAR
IT20868 1 COMPILED COMPOUND SQL OR A PL/SQL ANONYMOUS BLOCK CAN DELETE ALL ROWS OF A ON COMMIT DELETE ROWS TEMPORARY TABLE
IT19926 2 THE DB2CHECKSD OPERATION MAY HANG WHEN RESTORING A 11.1.0.0 ESE BACKUP IMAGE TO 11.1.1.1 PURESCALE ENVIRONMENT
IT20018 2 POSSIBLE TRAP IN SQLRIECC() IN DPF DURING EXCSQLSET REQUEST PROCESSING WHEN INTERRUPTED
IT18820 2 WHEN RUNNING THE DYNAMIC SQL IN A PACKAGE, THE WRONG STATEMENT COULD BE PICKED UP, RESULTING IN WRONG RESULT.
IT18427 2 DB2 MIGHT LEAK PRIVATE MEMORY IF LOCATORS ARE USED TO ACCESS THE DATA (E.G. TO FETCH LOBS)
IT18653 2 PD_GET_DIAG_HIST GOT PANIC OR -902 IN DPF
Fix Pack m2fp2  -   Routine Infrastructure
IT19471 2 EXCESSIVE SHARED MEMORY ALLOCATION FOR FMP MEMORY LEADS TO UNEXPECTED MEMORY ALLOCATION FAILURES, LARGE COREDUMPS
Fix Pack m2fp2  -   Security
IT19162 2 SLOW PERFORMANCE IN DB2AUDIT EXTRACT DELASC DUE TO MANY SMALL WRITES TO THE OUTPUT FILE
IT17647 2 SECURITY: VULNERABILITY IN GSKIT AFFECTS IBM DB2 (CVE-2016-2183)
IT19138 2 IN V11.1 YOU MAY EXPERIENCE PERFORMANCE DEGRADATION, TIMEOUTS, IF DATABASE NATIVE ENCRYPTION IS ENABLED.
IT19362 3 ENV_GET_REG_VARIABLES RETURNS INCORRECT DEFAULT VALUES FOR DB2CHGPWD_EEE AND DB2LOGINRESTRICTIONS.
Fix Pack m2fp2  -   Text Search
IT19001 3 DB2 NSE V11.1 MOD1 FIXPACK1 INSTALLATION ISSUE
Fix Pack m2fp2  -   pureScale Services
IV96673 2 GPFS GETS SHUTDOWN BY CM ENTER MAINTENANCE MODE
IT17909 2 DB2 COMMANDS AND CONNECTION ATTEMPT HANG WHEN CF SCA STRUCTURE MEMORY IS FULL
IT19994 2 SCA SEARCH AND INSERT LOGIC CAN LEAD TO A PERFORMANCE BOTTLENECK FOR AN XA WORKLOAD
IT19139 2 SET PRIMARY CF USING COMMAND "DB2CLUSTER -CM -SET -OPTION PPRIMARY -VALUE ***" NOT WORKING CORRECTLY
IV90425 2 "DB2CLUSTER -CREATE -FILESYSTEM" SEGMENTATION FAULT
IV95313 2 A MEMBER GOES DOWN WITH FODC_PANIC DUMPS WHEN EDUS RUSH TO RETRIEVE THE CONNECTIONS
IT19402 2 PURESCALE MEMBER CAN CRASH IN PDDUMPVALISTELEMENT
IT19463 3 DB2CLUSTER -VERIFY FAILED IN RDMA PING TEST

DB2 Version 11.1 Fix Pack m1ifx001
APAR Sev. Abstract
Fix Pack m1ifx001  -   CDE Data
IT18637 2 [POST11M1FP1GASAP_CANDIDATE]-901 CAN ONLY INPLACE UPDATE THE HEAD REC OF A MULTI-PAGE RECORD, DATABASEMETAWRITER.CPP:1417
IV91752 2 THE FIRST UPDATE STATEMENT FOR A COLUMN-ORGANIZED TABLE MAY IN RARE CASES CAUSE FUTURE QUERIES TO MISS SOME MATCHING RESULTS.
Fix Pack m1ifx001  -   CDE Query
IT18914 2 WITH DB2 V11.1 M1FP1 ON ZLINUX WITH HARDWARE LEVEL EQUAL OR OLDER THAN ZEC13 DB2START WILL FAIL
Fix Pack m1ifx001  -   Codegen and Runtime
IT18072 2 SQL0902 MAY OCCUR DURING EXECUTION OF QUERY CONTAINING LARGE RESULTSET
IT19462 2 WINDOWS EVENT HANDLE LEAK WITH PARALLELIZED QUERY PLANS (INTRA_PARALLEL YES) - MAY CAUSE OSERR 1450
IT18671 2 SQL0902 MAY OCCUR DURING EXECUTION OF QUERY CONTAINING LARGE RESULTSET
Fix Pack m1ifx001  -   Data Recovery Services
IT17844 1 UPGRADE DATABASE COMMAND MIGHT FAIL IN SQLPMIGRATEMFH
IT19687 2 DB2 NOT CALCULATING 'REUSABLE' SPACE CORRECTLY DURING UPGRADE
IT19023 2 AFTER CRASH RECOVERY, AN DEFERRED ONLINE REORG CLEANUP MIGHT CAUSE AN X ROW LOCK MISSING FOR AN INDOUBT TRANSACTION.
IT19780 2 IN RARE TIMING CONDITION, THE DATABASE CAN HANG DUE TO DEADLATCH BETWEEN HADR PROCESSES.
IT19781 2 IN A DPF DATABASE INSTANCE, IN RARE TIMING CONDITION A SEG-FAULT/TRAP CAN OCCUR IN FUNCTION SQLPSETTID()
Fix Pack m1ifx001  -   Install and Catalog Services
IT15485 2 SECURITY: TABLE PRIVILEGE CHECKING MAY RETURN OUTDATED RESULTS AFTER A TABLE IS RENAMED (CVE-2017-1150)
Fix Pack m1ifx001  -   Process Model
IT16127 1 IN DPF, DB2 TRAPS IN SQEDBMGR::LOCALDEACTIVATE IF A NODE FAILS AND THAT NODE IS THE CATALOG NODE FOR SOME DATABASE
Fix Pack m1ifx001  -   Query Compiler QGM
IT18170 2 WRONG RESULT IS POSSIBLE IF GENERATED ALWAYS EXPRESSION REFERENCES A BUILT-IN FUNCTION WITH MORE THEN ONE STRING INPUT
Fix Pack m1ifx001  -   pureScale Services
IT17913 3 DB2GCF MIGHT INCORRECTLY REPORT INSTANCE AS OPERABLE INSTEAD OF AVAILABLE WHEN USING VIRTUAL HOSTNAME IN DB2NODES.CFG

DB2 Version 11.1 Fix Pack 1
APAR Sev. Abstract
Fix Pack 1  -   Buffer Pool Services
IT15752 1 REVERT TO PREVIOUS METHOD OF CALCULATING ASYNCHRONOUS WRITE TIME FOR DB2 MONITORING
Fix Pack 1  -   CDE Data
IT16128 2 SLOW PERFORMANCE WITH GROUP BY ON VARCHAR COLUMN WITH COLUMN BASED TABLES
Fix Pack 1  -   Client Interfaces
IT17403 1 CONNECTION TO DB2 DATABASE USING ODBC DRIVER MANAGER IN MAC OS X FAILS WITH SQL1024N ERROR
IT11512 2 DB2DCLGN -Z OS390 WRITES 05 LEVEL FOR GRAPHIC DATA TYPE
Fix Pack 1  -   Codegen and Runtime
IT17179 2 IF ARRAY USED IN AN OPEN CURSOR IS MODIFIED THEN WRONG RESULT OR A TRAP ARE POSSIBLE
IT16869 2 SELECT ROW CHANGE TOKEN WILL RETURN WRONG RESULT WHEN USINGRIDSCAN (ROW IDENTIFIER SCAN)
IT17259 2 QUERY MIGHT TRAP IN DATA PARTITION ELIMINATION OF A ZIGZAG JOIN
IT16656 2 SQL0801 AND WRONG RESULTS FROM STDDEV_SAMP, VARIANCE_SAMP, COVARIANCE_SAMP WHEN USED IN AN OLAP SPECIFICATION
IT16860 2 DB2STOP FORCE HANG DUE TO THE NOT INTERRUPTIBLE OSSSLEEP FUNCTION IN WINDOWS
Fix Pack 1  -   DRDA Services
IT11963 3 KILL -9 TO A PURESCALE MEMBER RETURNS XAER_RMFAIL UNEXPECTEDLY
Fix Pack 1  -   Data Management Services
IT17214 2 THE DATABASE MIGHT ABEND DUE TO PROGRAMMING ERROR IN LIST PREFETCH PROCESSING.
IT17489 2 SELECT AGAINST AN MDC TABLE WITH A RANGE PREDICATE IN SMP MIGHT RETURN A WRONG RESULT
IT16569 2 CURCOUNT IN DB2PD -REORG IS NOT MONITORED WHEN ONLINE REORG WITH CLEANUP OVERFLOWS OPTION
Fix Pack 1  -   Data Management Utilities
IT17130 2 SORT RESERVATION MAY BE LEAKED UNDER CONSTRAINED SORT TUNING CON DITIONS, LEADING TO PERFORMANCE DEGRADATION AND SQL0955 ERRORS
Fix Pack 1  -   Data Recovery Services
IT12449 2 DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT.
IT16274 2 DB2CKBKP/DB2ADUTL MIGHT REPORT INCONSISTENT OBJECT HEADER FLAGS IN COMPRESSED BACKUP IMAGE
IT18238 3 EXCESSIVE DB2DIAG MESSAGE WHILE RUNNING READLOG PROGRAM
Fix Pack 1  -   Federation
IV90269 1 QUERIES WITH MULTIPLE OLAP CLAUSES AND DISTINCT AGAINST COLUMN ORGANIZED TABLES COULD RETURN WRONG RESULTS
JR56738 2 CREATE WRAPPER AND CREATE NICKNAME FAILING WITH FODC TRAP ON SIG #4
IT16062 3 DB2 MIGHT RETURN SQL0901N WHEN EXECUTING QUERY WITH SCALAG FUNCTIONS USED IN A CASE STATEMENT
Fix Pack 1  -   Index Manager
IT17023 2 DEADLATCHING DURING MULTIPLE INDEX INFO PAGES CREATION IN PURESCALE
Fix Pack 1  -   Install and Catalog Services
JR57036 2 REPLICATION CENTRE TOOL IS MISSING ON V11.1
IT16385 2 DB2 DATA SERVER CLIENT SILENT INSTALL FAILS WITH ERROR: PRODUCT: IBM DATA SERVER CLIENT - DB2COPY1 -- ERROR 1314.
IT17230 2 ADD LIBIBMC++.SO.1 32 BIT AND 64 BIT TO DB2 IMAGE FOR LINUX UBUNTU 16, SLES 12 AND RHEL 7 ON IBM Z SYSTEMS.
IT16407 2 DB2PREREQCHECK INCORRECTLY LISTS LIBSTDC++.SO.5 AS REQUIRED FOR INSTALLATION OF DB2 V11.1 ON LINUX 390 (ZSERIES)
IT16741 3 CUSTOMER CANNOT INSTALL DB2 WINDOWS CLIENT AFTER USING DB2UINS -F TO UNINSTALL OLDER VERSION OF DB2 WINDOWS CLIENT
IT17219 3 SYSCAT.COLUMNS AND SYSIBM.SYSCOLUMNS MAY SHOW INLINE_LENGTH OF 0 FOR A TABLE'S LOB COLUMNS
IT17097 3 SYSCAT.COLUMNS AND SYSIBM.SYSCOLUMNS MAY SHOW INLINE_LENGTH OF 0 FOR A TABLE'S LOB COLUMNS
Fix Pack 1  -   JDBC Driver
IT18775 3 TO DOCUMENT ALL THE JCC APARS THAT ARE SHIPPED WITH DB2V11.1 M1 FP1
IT18705 3 JCC RETURNS STALE DATA CALLING AN ARRAY STORED PROCEDURE AGAINSTDB2 Z/OS
IT17030 3 LOADING OF GLOBAL FILE USING -D OPTION WITH INCORRECT LOCATION NOT THROWING CORRECT EXCEPTION FOR JCC4
IT16801 3 JDBC DRIVER RETURNS INCORRECT DATA_TYPE FOR "GRAPHIC","VARGRAPHIC" ,"DBCLOB","XML"
IT16454 3 WLB FOR XA DISTRIBUTED TRANSACTION FOR LUW/PURESCALE
IT16173 3 JCC GSS-API DB2JCCPLUGIN CONCURRENCY ISSUE
IT15830 2 JCC GSS-API DOES NOT INVOKE THE DB2JCCPLUGIN FREEPLUGIN() METHODIN A GSS-API FAILURE SCENARIO
IT15338 2 NO AUTOCOMMIT FOR "COMMIT ON RETURN NO" STORED PROCEDURES FOR XASINGLE PHASE
IT18774 3 SQLSYNTAXERROREXCEPTION WAS THROWN WHEN SQL WAS EXECUTED USING CACHED PREPARED STATEMENT
Fix Pack 1  -   Parsing and SQL PL
IV90750 2 INCORRECT RESULTS ARE POSSIBLE WHEN MULTIPLE ROW_NUMBER() , INLINED SQL SCALAR UDF AND COLUMN ORGANIZED TABLES ARE PRESENT
IT17941 2 POSSIBLE WRONG RESULTS WHEN THE INPUT PARAMETERS OF AN INLINED SQL SCALAR UDF CONTAINS AN OLAP SPECIFICATION
Fix Pack 1  -   Performance
IT07722 2 HADR STANDBY MAY CRASH DUE TO MEMORY CORRUPTION WITH TOP FUNCTION SQLOCRASHONCRITICALMEMORYVALIDATIONFAILURE
Fix Pack 1  -   Problem Determination
IT03399 2 THE AMOUNT OF DATA WITCH CAN BE FETCHED BY PD UDFS IS AT MOST 500MB.
Fix Pack 1  -   Process Model
IT17143 2 MEMBER SUBSET IS NOT DROPPED AFTER HOST DATABASE IS DROPPED
Fix Pack 1  -   Query Compiler Optimizer
IT17556 1 INCORRECT RESULTS ARE POSSIBLE WHEN JOIN AGAINST CDE TABLES IS DONE AND AN UNDOCUMENTED JOIN SUPPORT REGISTRY VARIABLE SET
IT17458 2 IN DB2 DPF, POSSIBLE WRONG RESULT WHEN OUTER JOIN PREDICATE COL1=COL2 AND BOTH COLUMNS ARE FROM THE OUTER TABLE
Fix Pack 1  -   Query Compiler QGM
IT17361 1 FODC_TRAP, DROP() HIT SEGV DURING SQLNR_SPLIT_AND_GBPD
IT16271 2 JOIN-CONDITION RETURNS SQLCODE -338 WHEN TABLE FROM IMPLICIT CROSS JOIN IS REFERENCED
IT16703 2 DB2 MAY RETURN INCORRECT RESULTS WHEN USING STRING EQUALITY PREDICATES CONTAINING DIFFERING CODE UNITS
IT16599 2 THE DB2 SERVER TERMINATES ABNORMALLY IN SQLNQ_HANDLE_MODULE_OBJ_REF WHEN CREATING A SQL ROUTINE
IT16792 2 INCORRECT QUERY RESULTS WHEN USING OFFSET-CLAUSE AND/OR FETCH-FIRST-CLAUSE
IT17872 2 DB2 MAY TRAP IN SQLNR_CHECK_CAN_ADD_GB_DISTINCT WHEN COMPILING SOME QUERIES
IT17256 2 DB2 CRASH ON INVALID OBJECT
IT17452 2 WRONG RESULT IN STORED PROCEDURE QUERY WHEN ADD/DROP CHECK CONSTRAINT
IT16575 2 SQLCODE -120 WHEN UDF WITH DEFAULT VALUE USED WITHIN AN AGGREGATE FUNCTION IN SQL PL OR PL/SQL
IT09673 2 XML QUERY MAY RETURN INCORRECT RESULT WHEN IT HAS OLAP AND ORDER BY
IT16112 3 A CORRELATED SCALAR SUBQUERY IN AN UPDATE STATEMENT MAY NOT CORRECTLY RETURN SQL0811N
Fix Pack 1  -   Security
IT17190 2 DB2AUDIT HIT EFAULT WHEN TRYING TO FORMAT THE OUTPUT.
IT16893 2 ONLINE BACKUP WITH COMPRESSION AND ENCRYPTION MAY CREATE A CORRUPTED BACKUP FILE
Fix Pack 1  -   Text Search
IT17233 2 SECURITY: NET SEARCH EXTENDER AFFECTED BY MULTIPLE VULNERABILITIES IN OPENSOURCE EXPAT XML PARSER
IT15265 2 DB2TS CLEAR EVENTS DOES NOT WORK WHEN EVENTTABLLE HAS ROWS > 1000.
Fix Pack 1  -   pureScale Services
IT16158 1 DB2 PURESCALE HANG DUE TO MISSING LOCK NOTIFICATION
IT17462 3 RHEL 7: THE DB2 FAULT MONITOR FEATURE DOES NOT SUPPORT THE SYSTEMD INIT SYSTEM
IT17469 3 WHEN RUNNING 'DB2CLUSTER -LIST -ALERT', DB2ROCME LOGS TO THE DB2DIAG.LOG WITH UTC TIMESTAMP (+000) INSTEAD OF LOCAL TIME


Document information

More support for: DB2 for Linux, UNIX and Windows

Component: OTHER - Uncategorised

Software version: 11.1

Operating system(s): AIX, Linux, Windows

Reference #: 1995889

Modified date: 13 March 2019