IBM Support

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

Technote (troubleshooting)


Problem(Abstract)

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 : Thu Oct 5 11:33:47 EDT 2017
************************************************************

Select a Fix Pack: m2if002 | m2ifx001 | 2 | m1ifx001 | 1


Db2 Version 11.1 Fix Pack m2if002
APAR Sev. Abstract
Fix Pack m2if002  -   Buffer Pool Services
IT23161 1 UNDER DB2 DEVELOPER-C EDITION LICENSE, CREATE DATABASE WILL FAIL WITH SQL1139N.
Fix Pack m2if002  -   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 m2if002  -   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 m2if002  -   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 m2if002  -   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 m2if002  -   Data Management Utilities
IT23419 2 EXTRA SPACES GENERATED FROM EXPORT WHEN USING CODEUNITS32
Fix Pack m2if002  -   Data Recovery Services
IT23073 2 CRASH RECOVERY OR A DATABASE ROLLFORWARD OR HADR TAKEOVER MAY FAIL DURING ONLINE RECOVERY PROCESSING.
Fix Pack m2if002  -   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 m2if002  -   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 m2if002  -   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 IBM DATA SERVER CLIENT CANNOT BE DETECTED BY IBM LICENSE METRIC TOOL (ILMT)
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 2
APAR Sev. Abstract
Fix Pack 2  -   Administration Tools
IT19594 2 CLI0112E FROM DB2BATCH JOB
IT19610 2 AUTOMAINT_GET_POLICY RETURNS INCORRECT OUTPUT
Fix Pack 2  -   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 2  -   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 2  -   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 2  -   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
IT12986 2 TRUNCATED QUESTION SENTENCE IN LANG=JA_JP WHEN "LIST INDOUBT TRANSACTIONS WITH PROMPTING"
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 2  -   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 2  -   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 2  -   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 2  -   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 2  -   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 2  -   Federation
IV92847 2 A SQL0901N ERROR DURING COMPILATION OF QUERY WITH UNION CONTAINING FOR BIT DATA COLUMN FROM COLUMN ORGANIZED TABLES
Fix Pack 2  -   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 2  -   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 2  -   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 2  -   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 2  -   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 2  -   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 2  -   Process Model
IT12058 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 2  -   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 2  -   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 2  -   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 2  -   Routine Infrastructure
IT19471 2 EXCESSIVE SHARED MEMORY ALLOCATION FOR FMP MEMORY LEADS TO UNEXPECTED MEMORY ALLOCATION FAILURES, LARGE COREDUMPS
Fix Pack 2  -   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 2  -   Text Search
IT19001 3 DB2 NSE V11.1 MOD1 FIXPACK1 INSTALLATION ISSUE
Fix Pack 2  -   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
OTHER - Uncategorised

Software version: 11.1

Operating system(s): AIX, Linux, Windows

Reference #: 1995889

Modified date: 12 December 2017


Translate this page: