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
************************************************************
Product Name : DB2 UDB Version 11.1
Updated : Mon Apr 18 16:14:55 EDT 2022
************************************************************
Select a Fix Pack: m4fp7 | m4fp6 | m4fp5 | m4if1 | 4 | m3ifx002 | m3ifx001 | m3fp3 | m2ifx002 | m2ifx001 | m2fp2 | m1ifx001 | 1
-->
Db2 Version 11.1 Fix Pack m4fp7 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
Fix Pack m4fp7 - Administration Tools | |||||
IT38460 | 1 | SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION (CVE-2021-38926) | |||
IT36427 | 2 | MON_GET_AUTO_MAINT_QUEUE() MAY FAIL WITH SQL0493N | |||
IT35682 | 2 | POSSIBLE FMPTRAP IN CHECK_CREATE() WHEN RUNNING DB2LOOK IF AN OBJECT GETS DROPPED WHILE THE TOOL IS RUNNING | |||
Fix Pack m4fp7 - Buffer Pool Services | |||||
IJ35954 | 2 | THE RESIZE WARNING SHOULD BE REMOVED FROM DB2DIAG.LOG | |||
IT36183 | 2 | DATABASES CREATED WITH "AUTOMATIC STORAGE NO" MAY CORRUPT STORAGE GROUP FILES AFTER UPGRADE | |||
IT39085 | 2 | HIGH "SQLO_LT_SQLB_BP_AREA_INFO_PAGEAREA__CLOCKLATCH" CONTENTIONS ON DB2 PURESCALE | |||
IT35764 | 2 | EXTENT MOVER CAN HANG WAITING FOR SQLO_LT_SQLB_POOL_CB__READLOTCH WHILE HOLDING SQLO_LT_SQLB_EXTENT_DESC__EXTENTLATCH | |||
IT38383 | 2 | DB2 ABENDS WHILE PAGE CLEANER EXECUTING SQLBCLNRGATHERFORHATETHRESH | |||
IT37998 | 2 | ALTER TABLESPACE REBALANCE HANGS ON DISK FULL ERROR | |||
IT34931 | 3 | PREFETCHERS INFINITELY LOOPING IN SQLBSERVICELEAFREQUEST | |||
IT37394 | 3 | DB2PD -BUFFERPOOLS REPORTS INACCURATE HIT RATIO | |||
IT38370 | 3 | NO WARNING MESSAGE WHEN DMS TABLESPACE CANNOT BE IMMEDIATELY EXTENDED WHILE AN ONLINE BACKUP IS IN PROGRESS | |||
Fix Pack m4fp7 - CDE Query | |||||
IT37434 | 1 | DPF/BLU SYSTEMS TQ HANG IN RECEIVEFROMANYCONNECTION | |||
IT38619 | 2 | SQL0901N - UNEXPECTED ERROR AT CDE_INTERFACE.C:2561 | |||
IT37353 | 2 | COUNT DISTINCT QUERIES AGAINST COLUMNAR ORGANIZED TABLES COULD RETURN INCORRECT RESULTS | |||
IT38955 | 2 | WRONG RESULTS FROM SELECT COUNT QUERY ON "ORGANIZE BY COLUMN" TABLE | |||
Fix Pack m4fp7 - Client Interfaces | |||||
IT35681 | 1 | CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS | |||
IT36689 | 2 | REORGCHK F6 REPORTING INCORRECT VALUES | |||
IT39762 | 2 | MORE ROBUST SIGNAL HANDLING ADDED TO COMMAND LINE OPERATIONS. | |||
IT35067 | 2 | SQLCOLUMNS CLI FUNCTION MAY NOT WORK ON A TABLE NAME THAT INCLUDES MBCS CHARACTERS | |||
IT37446 | 2 | CLR PROCEDURE ABORTS ABNORMALLY WITH ERROR SQL1024N WHEN IT USES IBM.DATA.DB2 .NET PROVIDER | |||
IT31815 | 2 | JDBC DATABASEMETADATA RETURNS WRONG TYPE INFO FOR BINARY AND VARBINARY DATA TYPES | |||
IT35610 | 2 | POSSIBLE DB2BP TRAP/HANG UNDER THE EXIT() FUNCTION IF A SIGNAL IS RECEIVED. | |||
IT39057 | 3 | INITIAL CONNECTION ERRORS LIKE -4499 ARE NOT COLLECTED IN DIAGNOSTIC DATA THROUGH DB2.JCC.DIAGLEVELEXCEPTIONCODE SETTING | |||
IT39056 | 3 | IMPROPER SPECIAL REGISTER CURRENT SCHEMA CAUSING SQLSYNTAXERROREXCEPTION | |||
IT38678 | 3 | DECIMAL PRECISION DIFFERENCE IN JDBC WITH ORA & NON-ORA SETTING | |||
IT36074 | 3 | PRECOMPILER STRIPS C STYLE COMMENTS FROM SQL, CANNOT USE INLINED OPTIMIZATION GUIDELINES | |||
Fix Pack m4fp7 - Codegen and Runtime | |||||
IT36581 | 1 | A QUERY MAY HANG IN A MULTI-NODE ENVIRONMENT. | |||
IT38870 | 2 | RARE WRONG RESULT IN CDE INDEX CASE WHEN WITH UR IS USED | |||
IT38093 | 2 | SQL0952N COULD BE RETUNED FOR ACCESSING TABLES HAVING A LOB ROW. | |||
IT39220 | 2 | STATIC PACKAGES WITH COLUMNAR LOGIC FROM LEVELS OLDER THEN V11.1 FP3 COULD CAUSE MEMORY OVERWRITES | |||
IT37964 | 2 | SEGV AT SQLV_MIXD_BUILD_LIKE_SUBPAT() | |||
IT38969 | 2 | WRONG STRING COMPARISON FOR THAI NLSCHAR DATABASE COULD HAPPEN | |||
IT35932 | 2 | POSSIBLE FMP TRAP WHEN RUNNING DB2EXPLAIN WITH A STATEMENT CONTAINING UNESCAPED NEWLINE (\N) AND MULTIPLE SETS OF '(/)' | |||
IT37147 | 2 | CRASH ENCOUNTERED WHEN THERE IS A UNION/NLJN/ISCAN/SORT COMBINATION | |||
IT39146 | 2 | EXTREME FAST DB2DIAG.LOG GROWTH CAUSED BY WARNING MESSAGE IN RUNTIME INTERPRETER SQLRISRT | |||
IT35400 | 2 | WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATAPART TABLE ON THE INNER AND NULL KEYS. | |||
IT37857 | 2 | BUILD IN FUNCTION "DATE_PART" MIGHT RETURN AN INCORRECT RESULT OF WEEK, I.E. DATE_PART('WEEK', '2020-03-09') | |||
IT38310 | 2 | POSSIBLE TRAP (SEGV) WHEN RUNNING A QUERY ON A NICKNAME POINTING TO A FEDERATED SOURCE AND FEDERATED GOES DOWN. | |||
IT37132 | 3 | SQL0180N IS RETURNED WHEN TRY TO INSERT ODBC FORMAT TIMESTAMP. | |||
IT36690 | 3 | QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNION MAY GET INCORRECT RESULT | |||
Fix Pack m4fp7 - Communication | |||||
IT37600 | 3 | ESTABLISHED SSL CONNECTIONS ARE DROPPED AFTER 180 SECONDS | |||
Fix Pack m4fp7 - DRDA Services | |||||
IT36512 | 2 | DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET | |||
IT36200 | 2 | A CLIENT MAY ABEND IN FUNCTION SQLXAPREPARECOMMIT | |||
IT36333 | 2 | INCORRECT CONNECTION DETAIL TOKEN STRINGS FOR A CLP CONNECTION USING A DBALIAS GREATER THAN DBNAME | |||
IT38816 | 3 | SECURITY: CLIENT ENCRYPTION SETTINGS ARE NOT PRESERVED ON A FAIL OVER/RECONNECT RESULTING IN A DATA EXPOSURE. (CVE-2021-39002) | |||
IT39387 | 3 | SECURITY: APACHE LOG4J REMOTE CODE EXECUTION - LOG4SHELL (CVE-2021-44228, CVE-2021-4104) | |||
Fix Pack m4fp7 - Data Management Services | |||||
IT36524 | 1 | TRAP IN FUNCTION SQLPLRL WHEN DROPPING A SYSTEM TEMPORARY TABLE CREATED BY A QUERY RUNNING ON A HADR STANDBY | |||
IT37149 | 2 | SYSTEM TEMP TABLESPACE CAN BE LEFT IN SQLB_REORG_IN_PROGRESS IF REORGS WERE STARTED, BUT NOT COMPLETED BEFORE CRASH RECOVERY | |||
IT36178 | 2 | ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG | |||
IT38081 | 3 | HIPER: WRONG RESULT WITH MULTIDIMENSIONAL CLUSTERING (MDC) TABLE AND ZIGZAG JOIN (ZZJN) | |||
Fix Pack m4fp7 - Data Management Utilities | |||||
IT37658 | 1 | SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSUR E UNDER CERTAIN CIRCUMSTANCES WITH LOAD UTILITY (CVE-2021-20373) | |||
IT37720 | 1 | LOAD INTO SMALL MDC TABLE MAY FAIL IN SQLBPURGEORFLUSHALLPAGESIN SMALLRANGE, MAY CAUSE DB SHUTDOWN AND CRASH RECOVERY FAILURE | |||
IT37454 | 2 | WHILE DOING AN XML LOAD, DB2 MAY CRASH WHEN PROCESSING A ROW WITH INVALID DATA | |||
IT36653 | 2 | LARGE LOAD WITH LARGE AMOUNT OF LOB (> ~2-5 GB) DATA, AFTER LOAD COPY IMAGE FILE REPLAYED/PROCESSED, LEAD TO DATA CORRUPTION | |||
IT38590 | 2 | INGEST TO PARTITIONED DATABASE DOES NOT WORK OVER SSL | |||
IT36928 | 2 | IF ROW BEING SORTED IS VERY WIDE MEMORY OVERWRITES OR WRONG RESULTS ARE POSSIBLE. | |||
IT38526 | 3 | SQL_STACK_TRACE IN SQLUCHECKPOOLFORREDO() GENERATES MANY DUMP FILES WHEN THERE IS PERMISSION PROBLEM TO ACCESS A TABLESPACE. | |||
Fix Pack m4fp7 - Data Recovery Services | |||||
IT35472 | 2 | HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR | |||
IT36892 | 2 | SNAPSHOT BACKUP FAILED WITH SQL1550N RC 5 | |||
IT33954 | 2 | SQL0206N OR SQL0901N ON STANDBY AFTER ALTER TABLE ADD COLUMN ON PRIMARY WHEN HADR IS STOPPED | |||
IT37326 | 2 | TOTAL_LOG_USED MONITOR ELEMENT SHOW UNREASONABLY HIGH VALUE | |||
IT35041 | 2 | DB2 LOG FILE IS NOT OPENED WITH DIO FLAG WHEN CALLING BY DB2FLSN AND DB2READLOGAPI | |||
IT36658 | 2 | MON_GET_APPL_LOCKWAIT MIGHT HANG IN PURESCALE | |||
IT35501 | 2 | INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE | |||
IT35972 | 2 | POSSIBLE HADR STANDBY SHUTDOWN WHEN REPLAY ONLY WINDOW AVOIDANCE IS ACTIVE | |||
IT36139 | 2 | PERFORMANCE IMPACTS WITH HUGE AMOUNT OF ROW LOCKS | |||
IT37980 | 3 | LOCK ESCALATION OCCURS IN PURESCALE WHEN DB2_AVOID_LOCK_ESCALATION IS SET | |||
IT39279 | 3 | DB2 HANGS WITH MANY EDUS WAITING ON LOGTAILHEARTBEATLATCH | |||
IT35573 | 3 | HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN DISTRIBUTED TRANSACTION | |||
Fix Pack m4fp7 - Federation | |||||
IT35689 | 1 | QUERY WITH 'ORDER BY' AND REFERENCING A COMMON SUBEXPRESSION OVER COLUMN-ORGANIZED TABLES MAY RETURN ROWS IN THE WRONG ORDER | |||
IT38046 | 1 | NNSTAT MIGHT FAIL TO UPDATE NUMERIC COLUMN STATS WITH SQL1227N RC=3 IF VACHAR2 COMPATIVILITY IS ENABLED. | |||
IT36400 | 1 | SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739) | |||
IT37846 | 1 | NNSTAT FAILS TO UPDATE NICKNAME'S STATICS DUE TO DIFFERENT CURRENT SCHEMA SETTING | |||
IT36532 | 1 | DB2 MAY CRASH IN A RARE TIMING WHEN RUNNING FEDERATED QUERIES WITH FENCED WRAPPER AND USER MAPPING PLUGIN IS ENABLED. | |||
IT36439 | 1 | SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 (CVE-20220-27216) | |||
IT35384 | 1 | PRIVATE MEMORY LEAK DURING DDL ON COLUMN-ORGANIZED TABLES IN DPF ENVIRONMENT | |||
IT39053 | 2 | DB2 FEDERATION CAN NOT BE FORCED OFF DURING ABNORMAL SHUTDOWN OF MSSQL SOURCE SERVER | |||
IT37810 | 2 | REDUCE DB2DIAG.LOG MESSAGE "GET USER MAPPING" AND "SQLQG_FEDSTP_HOOK, PROBE:40 MESSAGE" | |||
IT39055 | 2 | FEDERATION CREATE SERVER TYPE OPTIMIZATION FOR ODBC WRAPPER | |||
IT36386 | 2 | A FODC FMP TRAP IS REPORTED IN SQLQG_GET_TOSENDDATALEN WHILE QUERYING FEDERATION NICKNAMES | |||
IT35265 | 2 | FEDERATED QUERY COULD LEAD TO DB2 INSTANCE CRASH WITH FODC_PANIC IN SQLQGINSERT | |||
IT37748 | 2 | A FODC TRAP MAY OCCUR WHEN DIA5000C MESSAGE IS ISSUED DUE TO A PARSING ERROR. | |||
IT38655 | 2 | FEDERATED OPERATIONS MIGHT LEAD TO INSTANCE CRASH WHEN HEALTH MONITOR IS TURNED ON | |||
IT36221 | 2 | INSTANCE CRASH USING WEB SERVICES WRAPPER | |||
IT36199 | 2 | POSSIBLE DB2FMP TRAP IN SQLQG_FMP_RUNTIME_OBJECT::GET_RSTATE_INF O() WHEN RUNNING FEDERATED QUERY | |||
JR63293 | 2 | MULTI-THREADED DB2FMP TRAPPED IN SYBASE CALLS INTERMITTENTLY | |||
JR63109 | 2 | SQL1822 ON FEDERATION SERVER BETWEEN UTF8 AND ISO-1 DATABASE WHEN THE SERVER OPTION IS STRING_UNITS 'S' | |||
IT36646 | 2 | FEDERATED TABLE IMPLICIT DATE CONVERSION TO TIMESTAMP NOT WORKING | |||
IT37543 | 3 | INDEX SPECIFICATION IS NOT CREATED WHEN THE NICKNAME IS CREATED IF THE INDEX KEY GREATER THAN 1024 BYTES | |||
Fix Pack m4fp7 - Index Manager | |||||
IT36665 | 1 | REORG TABLE RECLAIM EXTENTS ON INSERT TIME CLUSTERING (ITC) TABLES CAN RESULT IN FODC_INDEXERROR | |||
IT39051 | 1 | HANG WAITING FOR SQLO_LT_SQLI_IDXCB__IDXTREELATCH WITH NO HOLDERS AFTER FAILED REORG INDEX(ES) .. RECLAIM EXTENTS | |||
IT37180 | 2 | INSTANCE MAY CRASH WITH SQLIDUMPINXCURSOR ON THE STACK WHEN DUMPING FODC DIAGNOSTICS (-901 OR TRAP) | |||
IT38345 | 2 | DB2 PREP COMMAND FAILS WITH THE ERROR SQL0318N WHEN THE VALUES CLAUSE CONTAINS THE KEYWORD FOR. | |||
Fix Pack m4fp7 - Install and Catalog Services | |||||
IT36366 | 1 | DB2ICRT EXITS WITH DBI20000E AND FAILS TO CREATE A PURESCALE INSTANCE IN AN ENVIRONMENT WITH MANY NSD | |||
IT31638 | 1 | SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204) | |||
IT36870 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE UNDER SPECIFIC CONDITIONS (CVE-2021-29763) | |||
IT36938 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO A DOS WHEN A TABLE IS DROPPED WHILE BEING ACCESSED IN ANOTHER SESSION (CVE-2021-29777) | |||
IT39848 | 2 | DB2UNINS OF DATA SERVER CLIENT REMOVES MCAFEE SHARED REG KEYS | |||
IT39402 | 2 | CLIENT CONNECTIONS SLOW TO DATABASE SERVER | |||
IT35734 | 2 | SYSCODEPROPERTIES CONTINUOUSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING | |||
IT33761 | 3 | REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR | |||
IT36769 | 3 | DB2FMCD.SERVICES GETS DELETED IF THERE ARE TWO DB2 SETUPS AND ONE GETS REMOVED | |||
IT38534 | 3 | DB2ICRT CREATES / CHANGES .PROFILE OF THE INSTANCE OWNER TO HAVE A GROUP OF THE FENCED USER SPECIFIED WITH IT. | |||
IT33814 | 3 | REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR | |||
IT37210 | 3 | SQL1598 IS RETURNED WHEN USING DB2CONSV_T.LIC IN 11.1.4.5 | |||
Fix Pack m4fp7 - Monitoring | |||||
IT36931 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE (CVE-2021-29752) | |||
IT36141 | 2 | STATS_ROWS_MODIFIES REPORTS 4294967295 FROM MON_GET_TABLE AND ADMIN_GET_TAB_INFO | |||
IT39754 | 2 | LOCKING EVENT MONITOR "DROPPED RECORD" EVENT LEADS TO THE FLOOD OF DB2DIAG.LOG WARNING MESSAGES | |||
IT37991 | 2 | SPACE USED BY LOBS IN SOME EVENT MONITORS NOT REUSED WHEN THOSE LOBS ARE DELETED | |||
IT34630 | 2 | DB2CONVERT DOES NOT WORK WITH DPF AND WITH A TABLE IN A TABLE SPACE THAT DOES NOT EXIST ON THE HEAD NODE | |||
IT36076 | 2 | EXECUTING ADMIN_MOVE_TABLE ON A TABLE WITH SOME KINDS OF STATEMENTS > 64KB SIZE, WILL RETURNED SQL0104N OR SQL1224N | |||
IT28390 | 3 | THE ADMIN_MOVE_TABLE PROCEDURE MAY STUCK IN CANCEL PHASE. | |||
Fix Pack m4fp7 - Parsing and SQL PL | |||||
IT37177 | 1 | SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR BACKUP (CVE-2021-29825) | |||
Fix Pack m4fp7 - Platform Specific | |||||
IT36374 | 1 | DB2 HANGS EXECUTING ENV_GET_DB2_EDU_SYSTEM_RESOURCE | |||
IT35426 | 1 | ON DB2/AIX, POST FROM THREAD_POST CAN BE SKIPPED/DEFERRED BY WAITER INTERRUPTED IN THREAD_WAIT , LEADING TO PANIC/SHUTDOWN | |||
IT39499 | 2 | POSSIBLE DEADLATCH IN SQLOMEMINIT() WHEN IT LOADS CLIENT-SIDE LIBRARY | |||
IT37037 | 2 | DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY | |||
IT33268 | 2 | "DB2" FRONT END PROCESS DOES AN UNNECESSARY INTERNAL INITIALIZATION WHICH MIGHT CAUSE A PERFORMANCE DEGRADATION | |||
IT35874 | 2 | RARE TIMING WINDOW IN GETPARTITIONSTATSSUMMARY CAUSES DB2 SERVER / DB2SYSC TO ABEND / TRAP | |||
IT35820 | 3 | A TRAP MAY OCCUR WHEN CALLING THE ENV_GET_DB2_EDU_SYSTEM_RESOURCES FUNCTION IN RAPID SUCCESSION. | |||
Fix Pack m4fp7 - Problem Determination | |||||
IT36872 | 1 | SECURITY: IBM DB2 ON WINDOWS HAS NO PROTECTIONS ON THE TRACE SHARED MEMORY REGION (CVE-2021-29782) | |||
IT36408 | 2 | INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS | |||
IT35690 | 3 | NO ROWCOMPESTIMATE FROM DB2INSPF OUTPUT WITH -TSI OPTION | |||
Fix Pack m4fp7 - Process Model | |||||
IT38584 | 1 | IF MONHEAP IS EXHAUSTED SQL STATEMENTS MAY RECEIVE SQL0973N FOR MON_HEAP_SZ | |||
IT21845 | 2 | IF NODE FAILURE RECOVERY OCCURS AFTER END OF TRANSACTION, THE NEXT OPERATION CAN RECEIVE SQL1229 | |||
IT35712 | 2 | PURESCALE MAY HANG WHEN THERE ARE 2 MORE CONCURRENT NODE FAILUR ES AND ONE OF THE NODE FAILURES CAUSES A DATABASE DEACTIVATION. | |||
IT37088 | 2 | A NON ENCRYPTED DATABASE THAT IS RESTORED AS AN ENCRYPTED DATABASE IS NOT CONNECTABLE AFTER THE RESET DB CFG COMMAND. | |||
IT35663 | 2 | A USER INTERRUPT DURING AN IMPLICIT REBIND WHILE OPENING A CURSOR IN A STORED PROCEDURE MAY CAUSE A TRAP | |||
IT37095 | 2 | DB2STOP RESULTS IN SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004 | |||
IT36095 | 3 | ZRC=0XFFFFFFFF=-1 ERROR IN DB2DIAG.LOG WHEN USING PURESCALE WITH SSL | |||
IT36362 | 3 | DB2CFEXP FAILS TO EXPORT SSL_CLNT_KEYDB AND SSL_CLNT_STASH DBM CFG PARAMETERS FROM A CLIENT INSTANCE | |||
Fix Pack m4fp7 - Query Compiler Optimizer | |||||
IT38030 | 1 | A QUERY ON COLUMNAR TABLES MAY RETURN MORE ROWS THAN EXPECTED | |||
IT34987 | 1 | DB2ADVIS WILL THROW A -901 ON A QUERY THAT IS ORDERED BY AN EXPRESSION | |||
IT24280 | 2 | GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSING CLAUSE MAY RETURN -901 | |||
IT34306 | 2 | OPTIMIZER USES QUANTILE STATS FOR UNIQUE COLUMNS TO COMPUTE THE EQUALITY PREDICATE FILTER FACTOR WHICH LEADS TO OVER-ESTIMATION | |||
IT34193 | 2 | DB2 SERVER TERMINATES ABNORMALLY IN RECURSIVE_QGM | |||
IT33573 | 2 | POOR PERFORMANCE OF FEDERATED QUERIES IN CERTAIN CASES | |||
IT36888 | 2 | A SQL STATEMENT CAUSES THE AGENT TO TRAP | |||
IT33977 | 2 | DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE. | |||
IT31125 | 2 | DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN | |||
IT40228 | 2 | OPTIMIZER MISS THE CHECK FOR THE MINIMUM ROW WIDTH MAY LEAD TO MEMORY OVERWRITES OR WRONG RESULTS | |||
IT36902 | 2 | -901 ERROR WITH REASON "NO PLAN FOUND" | |||
IT24515 | 2 | DB2 ENGINE MIGHT HANG WHEN UPDATING STATISTICS FOR INDEXES ON XML COLUMNS | |||
IT39306 | 2 | THE OPTIMIZER MIGHT FAVOUR A NON-OPTIMAL PLAN WITH REGISTRY VARIABLE DB2_EXTENDED_OPTIMIZATION=NLJN_OFLOW | |||
IT37840 | 2 | INNER JOIN OF AT LEAST 4 COLUMN-ORGANIZED TABLES MIGHT RETURN WRONG RESULTS UNDER SPECIFIC CONDITIONS | |||
IT35581 | 2 | SEGV OCCURS WHILE PREPARING A QUERY WITH AN XML PREDICATE THAT CONTAINS ANY EMPTY STRING LITERAL, RESULTS IN SQL1224N. | |||
IT27030 | 3 | SQL1585N IS RETURNED WHEN THE OPTIMIZER DOES NOT SELECT A POSSIBLE PLAN UNDER SOME CIRCUMSTANCES | |||
IT34609 | 3 | QUERY SUCCCEED BUT GET ERROR MESSAGE WINNING PLAN STILL NEEDS GLUE IN DB2DIAG.LOG | |||
Fix Pack m4fp7 - Query Compiler QGM | |||||
IT38558 | 1 | SECURITY: INDIRECT READ ACCESS TO A TABLE THAT THE USER IS NOT AUTHORIZED TO SELECT FROM (CVE-2021-38931) | |||
IT36599 | 1 | SECURITY: IBM DB2 SERVER TERMINATES ABNORMALLY WHEN SELECT FROM INVALID VIEWS (CVE-2021-29703) | |||
IT38174 | 1 | INCORRECT RESULT WHEN DB2 QUERY HAS EXISTS SUB QUERY WITH IS NULL PREDICATE | |||
IT29641 | 2 | QUERY FAILS WITH ERROR SQL0901N "NLJN LOJ INNER NOT NULLABLE" | |||
IT37209 | 2 | DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ISSUING A SELECT QUERY | |||
IT33068 | 2 | TRAP ON SQLNO_COL_WIDTH_INLINE | |||
IT30007 | 2 | INSERT STATEMENT PERFORMS POORLY WHEN SOURCE FULLSELECT INCLUDES UNION ALL AND FETCH-CLAUSE | |||
IT36857 | 2 | DB2 ALTER TABLE QUERY MAY FAIL WITH SQL0109N ERROR | |||
IT32879 | 2 | CREATE OR REPLACE VIEW FAILS WITH SQL0727 WHEN VIEW DOES NOT EXIST | |||
IT21098 | 2 | SQL0901N ERROR EXECUTING COMPLEX QUERY IN BLU DPF | |||
IT35418 | 2 | SELECT DISTINCT STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT") | |||
IT24722 | 2 | DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONS AND SCALAR AGGREGATIONS | |||
IT25599 | 2 | SQL0407N MIGHT OCCUR WHEN RUNNING QUERIES CONTAIN SCALAR SUB-QUERIES AND COMMON SUB-EXPRESSIONS | |||
IT26127 | 2 | NON-PUSHDOWNABLE HASH JOIN ELIGIBLE PREDICATES INVOLVING NICKNAMES MAY BE USED SUB-OPTIMALLY | |||
IT35385 | 2 | QUERY COULD FAIL WITH -901 WHEN MQT IS USED | |||
IT36259 | 2 | SQL0952N ERROR SHOULD BE RAISED INSTEAD OF PRODUCING FODC_APPERR AND SQL0901N | |||
IT26459 | 2 | SLOW PERFORMANCE MIGHT BE OBSERVED WHEN RUNNING AN IUD STATEMENT WITH CERTAIN CHARACTERISTICS | |||
IT27969 | 2 | SQL0901N MIGHT OCCUR WITH QUERIES CONTAINING CASCADED SELECTS AND THE SAME LOCAL PREDICATES ON THESE SELECTS | |||
IT35986 | 2 | SELECT WITH GRANT FAILED TO GRANT FOR A VIEW WITH VALUES. | |||
IT29337 | 2 | 'SQL0901 BAD PLAN; UNRESOLVED QNC FOUND' WHEN CALLING A TABLE FUNCTION WITH CSE REFERENCING A FUNCTION ARGUMENT. | |||
IT25481 | 2 | SQL0901N ERROR OR HANG MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING NOT EXISTS OR NOT IN SUB-QUERIES | |||
IT26303 | 2 | INCORRECT "TYPE" VALUE IN IMPLICITVALUE COLUMN OF SYSCAT.COLUMNS FOR ROW CHANGE TIMESTAMP, ROW END OR TRANSACTION START ID COLUMN | |||
IT29458 | 2 | POSSIBLE PERFORMANCE PROBLEMS FOR INSERT STATEMENTS WITH COMMON-TABLE EXPRESSIONS | |||
IT35692 | 2 | SQL0407N WHEN COMMON SUBQUERY HAS VALUES | |||
IT37934 | 2 | WRONG RESULT WHEN DB2 QUERY HAS CORRELATED EXISTS PREDICATE | |||
IT39336 | 2 | TRAP/901/HANG WHEN DB2 QUERY HAS CORRELATED IN PREDICATE IN SELECT. | |||
IT31747 | 2 | MERGE STATEMENT REFERENCING MATERIALIZED QUERY TABLES (MQTS) MAY FAIL WITH SQL0407N | |||
IT38439 | 2 | DB2 QUERY MAY ABEND OR RETURN A SQL 901 WHEN USING A CORRELATED COMMON TABLE EXPRESSION | |||
IT38495 | 2 | DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES WITH MULTIPLE OUTER JOINS | |||
IT28568 | 2 | AN OUTER JOIN QUERY MIGHT BE WRONGFULLY RE-WRITTEN TO AN INNER JOIN QUERY WHEN MQT MATCHING IS ENFORCED FOR SHADOW TABLES. | |||
IT31211 | 2 | DB2 QUERY MAY PERFORM POORLY WHEN NULL PRODUCING SIDE OF OUTER JOIN IS ON BASE TABLE. | |||
IT22746 | 2 | FEDERATED QUERY WITH FUNCTION TEMPLATE OVER A GROUP BY OR UNION MAY FAIL WITH -901 "NO FTSLPD THROUGH GB/UNION DISTINCT" | |||
IT26617 | 2 | SQL901N ERROR MIGHT OCCUR WITH QUERIES CONTAINING UNIONS AND EXPRESSIONS | |||
IT39079 | 2 | DB2 SERVER TERMINATES ABNORMALLY WHEN CREATE TABLES. | |||
IT28402 | 2 | DB2 MIGHT ABEND WHEN RUNNING QUERIES WITH UNION IN EXISTS/IN SUBQUERIES | |||
IT34655 | 2 | A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP | |||
IT35979 | 2 | DB2 SERVER MAY TERMINATE ABNORMALLY WHEN USING SUBSTR | |||
IT29744 | 2 | SQL0901 ON SELECT SAMPLE.TEST FOR SYSTEM_TIME BETWEEN | |||
IT39482 | 2 | DB2 SERVER MAY TERMINATE ABNORMALLY ISSUING ILLEGAL SQL STATEMENT | |||
IT38232 | 2 | INCORRECT RESULTS MIGHT BE RETURN FOR COUNT/COUNT_BIG OVER() SCALAR AGGREGATE FUNCTION UNDER AN OUTER JOIN | |||
IT27039 | 2 | DB2 CRASH OR LONG COMPILATION TIME THAT MIGHT ERROR OUT WITH SQL 101N - BOX_COPY__9SQLNQ_QTBFPP9SQLNQ_QTBP9SQLNQ_QURI SQLNR_SUBSU | |||
IT27202 | 3 | SPECIFIC MQT DEFINITION MAY LEAD TO DB2 ABEND WITH SIG11 | |||
IT39352 | 3 | XML INDEXES NOT USED IN DB2 11.5 EXPLAIN PLAN | |||
IT27914 | 3 | MERGE STATEMENT RETURNS SQLCODE -206 WITH EMPTY OR WRONG COLUMN NAME | |||
IT28028 | 3 | SELECT-STATEMENT WITH WHERE-CLAUSE, FETCH-CLAUSE AND UPDATE-CLAUSE FAILS WITH SQLCODE -511 | |||
IT32967 | 3 | QUERY COMPILATION FAILS WITH SQLCODE -421 WHEN OLAP SPECIFICATION USED AS ARGUMENT TO INLINED SQL FUNCTION | |||
IT35802 | 3 | DB2 QUERY PLAN DOES NOT CHOOSE INDEX WHEN IN PREDICATE HAS PARAMETER MARKER. | |||
IT32989 | 3 | UNQUALIFIED COLUMN REFERENCE WITH USING CLAUSE ON VIEW RETURNS SQLCODE=-206 | |||
IT35069 | 3 | SELECT-STATEMENT INCORRECTLY RETURNS SQL20264N DURING EXECUTION | |||
IT36320 | 3 | QUERY EXECUTION MAY FAIL FOR OUTER JOIN QUERIES WITH PREDICATES WITH CAST FUNCTIONS | |||
IT24558 | 3 | ERROR SQL0102N RETURNED WHEN DB CFG VARCHAR2=ON, STMT_CONC=LITERALS AND STRING_UNITS=CODEUNITS32 | |||
Fix Pack m4fp7 - Relational Data Services | |||||
IT37084 | 1 | APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED | |||
IT35566 | 1 | MEMORY BLOCK FREED TWICE IN SQLOFMBLKEX | |||
IT37005 | 2 | DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT | |||
IT35517 | 2 | DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE | |||
IT39319 | 2 | SQL0818N CAN OCCUR AFTER A ROLLED BACK REVALIDATION | |||
IT36253 | 2 | SQLTEMPSPACE OR AGGSQLTEMPSPACE THRESHOLDS DO NOT WORK WITH ROWSTORE OLAP OPERATORS THAT SPILL TO DISK. | |||
IT35485 | 2 | DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE | |||
IT39916 | 2 | POSSIBLE MEMORY CORRUPTION WHEN CALLING PD_GET_DIAG_HIST | |||
IT35270 | 2 | AUTHORIZATION ERRORS IN ACCESSING CGTTS AFTER A TRANSFER OWNER OF A SQL ROUTINE. | |||
IT36927 | 2 | EXECUTING A PROCEDURE AFTER TRANSFER OWNERSHIP OF SPECIFIC PROCEDURE RESULTS IN SQLCODE -551 REPORTED FOR ORIGINAL OWNER. | |||
IT35491 | 2 | POSSIBLE TRAP FOLLOWING DB2DIAG.LOG MESSAGE "TRYING TO REGISTER AN INVALID SERVICE CLASS ID OF 0" | |||
IT36606 | 2 | CPU_UTILIZATION CAN BE SHOWING MORE THAN 100% | |||
Fix Pack m4fp7 - Routine Infrastructure | |||||
IT37717 | 1 | SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE (CVE-2021-29678) | |||
IT36563 | 2 | TRAP IN SQLERSENDFMPSTART DUE TO SENDBUFFER BEING NULL | |||
Fix Pack m4fp7 - Security | |||||
IT36717 | 1 | SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFO. DISC. IN SOME CASES WHEN A USER CREATES AN INLINE SQL FUNC. (CVE-2021-20579) | |||
IT36869 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO WEAK FILE PERMISSIONS ALLOWING ACCESS TO SPECIFIC FILES (CVE-2020-4976) | |||
IT38916 | 2 | POSSIBLE SEGMENTATION FAULT ON DB2AUDIT EXTRACT COMMAND | |||
IT38233 | 2 | ADD SUPPORT FOR FIPS MODE OF OPERATION TO LINUXPPC64LE | |||
IT37042 | 2 | IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG | |||
IT40358 | 2 | UPDATE GSKIT TO 8.0.55.26 | |||
IT37043 | 2 | FOR SSL CONNECTIONS ONLY, AUTHENTICATION CACHE IS NOT ABLE TO PERFORM USER OR GROUP LOOKUP | |||
IT36851 | 2 | WHEN DB2_ALTERNATE_GROUP_LOOKUP=GETUSERATTR, A USER'S PRIMARY GROUP MAY NOT BE REPORTED BY DB2. | |||
IT39446 | 2 | PKCS11 DRIVER MAY RETURN UNEXPECTED ERROR CODES WHEN HSM SESSION IS CLOSED | |||
IT37891 | 3 | WHEN TRUSTED CONTEXT IS DROPPED, SETSESSIONUSER PRIVILEGES ARE ALSO DELETED | |||
Fix Pack m4fp7 - Text Search | |||||
IT39918 | 1 | SECURITY: VERSION OF LIBEXPAT USED BY DB2 MAY ALLOW A REMOTE ATT ACKER TO EXECUTE ARBITRARY CODE (CVE-2022-23852,CVE-2022-23990) | |||
IT37592 | 2 | DB2 TEXT SEARCH MIGHT RETURN INCORRECT RESULT WITH MORPHOLOGICAL INDEXING | |||
Fix Pack m4fp7 - XML | |||||
IT36834 | 2 | XML NODE MANAGER THROWS -901 ERROR WHILE RUNNING MANUAL RUNSTATS ON XML TABLE. | |||
Fix Pack m4fp7 - pureScale Services | |||||
IT40659 | 2 | DB2 HADR START MAY TIMEOUT WAITING FOR DB2 START | |||
IT37602 | 2 | IMPROVE ERROR MESSAGE WHEN PUTTING CLUSTER IN TO MAINTENANCE MODE WITHOUT DB2CLUSTER -ALL OPTION. | |||
IT35801 | 2 | MISMATCH THAT THE OS HOSTNAME VALUE IS LOWER-CASED WHEREAS THE H ADR_LOCAL_HOST/HADR_REMOTE_HOST VALUES ARE UPPER-CASED. | |||
IJ29301 | 2 | CF CPU USAGE ALWAYS SHOWS "CPU USAGE = 0" AND CPU_USAGE_TOTAL 0 ON CF S. | |||
IT37436 | 3 | DATABASE CREATE FAILS WITH SQL2049N RC=2 WHEN DB2_DATABASE_CF_MEMORY BEING SET TO 0 | |||
IT34383 | 3 | DB2HAICU -REMOTE_ENABLE FAILS IN CASE REMOTE HOST USES NLS MESSAGE. |
DB2 Version 11.1 Fix Pack m4fp6 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
Fix Pack m4fp6 - Administration Tools | |||||
IT36054 | 2 | THE DB2MOVE COMMAND DOES NOT EXPORT PARTITIONED TABLES WHEN USED WITH OPTION: TS | |||
IT34911 | 2 | APAR IT17532 INTRODUCED RESET OF COLUMN STATS IN DB2LOOK MIMIC OUTPUT, CAUSING LOCKING BEHAVIOUR WITH ONLINE RUNNING APPS. | |||
IT32389 | 2 | DB2MOVE CURRENTLY DOESN'T POSSESS THE CAPABILITY TO PARSE '--' COMMENTS AND IT JUST SKIPS OVER THEM | |||
IT34912 | 2 | NEW OPTION FOR DB2LOOK -M NOT TO GENERATE RESET INDEX AND COLUMN STATS IN THE OUTPUT VIA NEW ENVIRONMENT VARIABLE | |||
IT34697 | 2 | DB2BATCH FAILS TO CAPTURE MONITORING STATISTICS FOR REMOTE INSTANCES IN A KERBEROS ENVIRONMENT | |||
IT34913 | 2 | SQL1227N ERROR WITH RC 11 WHEN RESETTING AVGPARTITION_CLUSTERRATIO COLUMN VALUE DURING INDEX STATS RESET. | |||
IT30496 | 2 | DB2CKUPGRADE MISSING ROW ACCESS THAT DEPEND ON SYSTEM VIEWS. | |||
IT27946 | 3 | DB2MOVE IN LOAD_ONLY MODE MAY LEAVE TABLES IN SET INTEGRITY PENDING | |||
IT30569 | 3 | DB2 ADMINISTRATIVE TASK SCHEDULER STOPS EXECUTING SCHEDULED TASKS | |||
IT35247 | 3 | DB2 11.1 DB2LOOK -PRINTDBCFG FAILS WITH SQL5066W THE DB CFG PARAMETER VALUE FOR TOKEN "SQLF_DBTN_APPLHEAPSZ" | |||
IT34844 | 3 | DB2LOOK -XD DOES NOT SHOW ALL DATABASE AUTHORIZATION STATEMENTS GRANTED AT DATABASE CREATION TIME | |||
IT30905 | 3 | DB2MOVE FAILS DUE TO SQL0668N RC 1 FOR CREATE OF INDEXES ON MQTS | |||
Fix Pack m4fp6 - Buffer Pool Services | |||||
IT31714 | 1 | ON RARE OCCASION, DATA CORRUPTION MIGHT BE INDUCED BY FAILURE TO PANIC THE DATABASE ON ENCRYPTION ERROR. | |||
IT32155 | 2 | DB2 INSTANCE MIGHT PANIC WHILE RUNNING QUERIES INVOLVING A SORT OPERATOR | |||
IT33393 | 2 | DB2 ENGINE ABEND FOLLOWING DROP TABLE AND SQLBPREPARE2FREEEXTONTEMPSMP SEVERE ERROR | |||
IT30726 | 2 | PURESCALE INSTANCE MAY PANIC WHEN UNFIXING A PAGE DUE TO AN INVALID PAGE LATCH | |||
IT31308 | 2 | IN DB2 PURESCALE EXTENT MOVEMENT MIGHT TIMEOUT AND THEN BRING DB DOWN WHEN LOCKTIMEOUT IS NOT -1 | |||
IT32593 | 2 | DISK FULL ERROR ON SMS SYSTEM TEMPORARY TABLE SPACE MAY CAUSE BA D CONTENTION TO DB2DIAG.LOG BETWEEN PAGE CLEANER & APPLICATIONS | |||
IT30434 | 2 | INTERRUPTING ALTER TABLESPACE REDUCE MAY CAUSE A MEMBER SHUTDOWN | |||
IT33687 | 2 | ROLLFORWARD CAN RESULT IN SQL1042C AFTER SET TABLE SPACE CONTAINERS USING AUTOMATIC STORAGE | |||
IT32180 | 2 | HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR | |||
IT32972 | 2 | DB2RELOCATEDB ALSO REMOVES A DATABASE ENTRY FROM THE SOURE DATABASE | |||
IT33836 | 2 | PURESCALE MEMBER MIGHT HANG WAITING FOR SQLO_LT_SQLB_BPD__BPDLAT CH_SX WHILE IN SQLBGBUPGRADELATCHFROMSHAREDURINGWAR | |||
IT32301 | 2 | DATABASE MANAGER FAILS TO CREATE A NEW STRIPE SET IN NEW STORAGE CONTAINERS FOR AUTOMATIC STORAGE TABLESPACE AND HANGS | |||
IT31384 | 2 | IN PURESCALE UNNECESSARY SQLB_EAT_OBJ_TYPE_NOT_FOUND MESSAGES MAY BE WRITTEN INTO DB2DIAG.LOG | |||
IT32973 | 2 | REDO OF FREEEXTS LOG RECORD CAN CORRUPT HWM OF TALBESPACE | |||
IT34517 | 2 | NEWLY CREATED TABLESPACE IS MISSING ON HADR STANDBY DUE TO DISK FULL DURING REPLAY | |||
IT33488 | 2 | QUERIES MIGHT HANG IN UOW-EXEC WAITING ON SQLO_LT_SQLB_HASH_BUCK ET_GROUP_HEADER__GROUPLATCH IN SQLBFINDPAGEINBPORSIM FUNCTION | |||
IT30650 | 2 | INSTANCE MAY TRAP REPORTING INVALID POOL ID | |||
IT31272 | 2 | FALSE POSITIVE AGAINST REGISTRY ENV_DB2_BCKP_PAGE_VERIFICATION | |||
IT32394 | 3 | DB2 INSTANCE CRASH MIGHT BE EXPERIENCED DUE TO AN UNINITIALIZED PREFETCHER, WHEN RESTORING TO A NEW DATABASE IN DPF ENVIRONMENT. | |||
IT29546 | 3 | DB2RELOCATEDB ERROR : DBT1020N THE CONFIGURATION FILE CONTAINS AN INVALID ENTRY AT LINE "1". REASON CODE = "11". | |||
IT32396 | 3 | FODC_TRAP DURING DATABASE RESTORE | |||
IT30278 | 3 | TABLESPACE CONTAINERS COULD BE DELETED WHEN A STORAGE GROUP EXIST ON DBPATH | |||
IT34111 | 3 | INSERTS MAY INTERMITTENTLY RETURN SQL0289N WHILE TABLE SPACE EXTENT MOVEMENT IS IN-PROGRESS | |||
Fix Pack m4fp6 - Build Team | |||||
IJ23783 | 2 | "DB2CLUSTER -CFS -LIST -NETWORK_RESILIENCY -RESOURCES" NOT LISTING RESOURCES | |||
IT33428 | 2 | SQL1598N MIGHT BE RAISED IF A LICENSE WAS NOT APPLIED BEFORE SIMULTANEOUS ATTEMPTS TO CONNECT THROUGH THE DATA SERVER DRIVER | |||
IT29520 | 3 | ZLIB SYMBOLS INSIDE LIBDB2.SO ARE GLOBALLY VISIBLE WHICH MEANS THEY COLLIDE WITH ZLIB SYMBOLS INSIDE LIBZ.SO | |||
Fix Pack m4fp6 - CDE Data | |||||
IT32080 | 2 | SQL0901N ERROR WITH AN ASSERTION 'TARGETCOLSPEC.GETWIDTHINBITS() < SOURCECOLSPEC.GETWIDTHINBITS()' FAILED IN DB2DIAG.LOG | |||
Fix Pack m4fp6 - CDE Query | |||||
IT35231 | 1 | ONE COMPLEX QUERY TAKES VERY LONG TIME TO FINISH AFTER MIGRATING FROM V10.5 | |||
IT33322 | 2 | CDE QUERY SEEMS HANGING, IT DOESN'T COMPLETE IN HOURS WHEN IT NO RMALLY COMPLETES IN MINUTES THE CAUSE IS CDE PARADISE SORT HANGS | |||
IT32049 | 2 | DB2 MAY TRAP DURING A COLUMN ORGANIZED SORT OF A VERY LARGE (4 BILLION+ ROW) TABLE. | |||
IT31335 | 2 | IF COLUMNAR FUNCTIONALITY IS USED ON A SYSTEM WITH INTEL CPU THAT SUPPORTS AVX-512 MIGHT TRAP IN VECTORSIMD::COMPACTVECTORCPU | |||
Fix Pack m4fp6 - Client Interfaces | |||||
IT30039 | 1 | SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK(CVE-2020-4200) | |||
IT34112 | 1 | DB2BP TIMEOUT FOR LARGE UID | |||
IT33350 | 2 | HANG IN MULTITHREADED APP WHEN 1 THREAD IS WAITING TO COMPLETE OPERATION WHILE 2ND THREAD CALLS SQLGETINFOW() BEFORE NEW CONN. | |||
IT31052 | 2 | CLP MIGHT TRUNCATE LAST CHARACTER OF UID AND PW. | |||
IT27743 | 2 | JDBC DATABASEMETADATA.GETTABLETYPES MISSING SYNONYM | |||
IT26968 | 2 | BOOLEAN DATA TYPE GETS TRANSLATED AS SHORT-TEXT IN MS-ACCESS VIA ODBC | |||
IT32404 | 2 | SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB | |||
IT30675 | 2 | DB2 CLI/ODBC FAILING WHEN INSERTING THE NULL VALUE TO BOOLEAN DATA TYPE USING PARAMETER MARKER | |||
IT20674 | 2 | DB2CFIMP INCORRECT IMPORT OF SVCE_NAME AND NUMDB FROM V9.7 TO V11 | |||
IT31696 | 3 | MEMORY LEAK IN CLP WHEN SET SERVEROUTPUT ON COMMAND IS USED | |||
IT30287 | 3 | HADR ROLE IS SHOWN AS STANDARD WHEN LOG CONTROL FILES ARE NOT ACCESSIBLE | |||
IT31497 | 3 | SQL2731N WHEN AN INPUT FILE SIZE OF ZLOAD IS BIGGER THAN 4GB | |||
IT33345 | 3 | DB2DSDCFGFILL MAY HANG IF A NODE ENTRY HAS BEEN UNCATALOGED / MISSING FROM THE NODE DIRECTORY OF THE INSTANCE | |||
Fix Pack m4fp6 - Codegen and Runtime | |||||
IT31151 | 1 | WRONG RESULTS ARE POSSIBLE WITH COMPLEX SQL WHICH USES UDFS AND CONSTANTS AND ENCOUNTER A COMPLEX PLAN. | |||
IT35553 | 1 | DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG. JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT. | |||
IT31442 | 2 | HASH JOIN QUERY CAN HANG IN REBAL | |||
IT33973 | 2 | APPLICATION IN UOW EXECUTING USING HASH JOINS MAY HANG AND COULD NOT BE FORCED OFF | |||
IT31339 | 2 | SQL QUERY MAY BE SLOW WHEN USING DBMS_LOB.SUBSTR FUNCTION IN A VIEW | |||
IT34775 | 2 | SQL STATEMENT CALLING NTILE FUNCTION FAILS WITH : -901 BAD DYN INDEX. IDX=4294967294 SIZE=87 (OFF=5) | |||
IT32828 | 2 | FODC TRAP DUE TO LIMITED FD_SET SIZE FOR SELECT SYSTEM CALL IN UTL_MAIL MODULE | |||
IT33644 | 2 | IN SOME CASES, WLM THRESHOLDS FOR TEMP SPACES IS CALCULATING INCORRECTLY | |||
IT31866 | 2 | FODC_TRAP IN MEMCOPY IS POSSIBLE WHEN EXECUTING A COMPLEX QUERY WITH RID FUNCTION WHEN INTERNAL OPTIMIZATIONS ARE DONE | |||
IT32897 | 2 | POSSIBLE TRAP (SEGV) OR MEMORY ERROR IN SQLVFREELOBMEM() IF QUERYING A TABLE FUNCTION RETURNING A ROWTYPE WITH A CLOB IN IT | |||
IT33112 | 2 | DB2 MIGHT TRAP DURING A ZIGZAG-JOIN | |||
IT34910 | 2 | CRASH IN UPLUG_INIT_44_DB2 | |||
IT34184 | 2 | DB2 CRASHED FOR C0000005 EXCEPTION ON SQLV_CHR_2_NUM | |||
IT33321 | 2 | DB2 MAY TRAP ON MEMORY VALIDATION FAILURE DUE TO CORRUPT BLOCK HEADER IN SQLRA_SQLW_MEM_FREE_SIBLING_LIST | |||
IT34469 | 3 | CLIENT GETS -901 DTS MISMATCH BETWEEN REQUEST AND CACHE INSTEAD OF -910 | |||
IT34049 | 3 | NEW BCD DIVISION IMPLEMENTATION FOR ROW BASED DECIMAL | |||
Fix Pack m4fp6 - Communication | |||||
IT32356 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION (CVE-2020-4363) | |||
IT31485 | 1 | CONTENTION ON SQLO_LT_SRVLST_CB__SRVLSTLATCHL LATCH DURING SSL CONNECTIONS | |||
IT35290 | 1 | SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND. (CVE-2020-####) | |||
IT29715 | 2 | FODC_TRAP ZN8SMEMNODE18FINDPARENTSPOINTEREPPS CAUSING INSTANCE TO GO DOWN | |||
IT32123 | 2 | BSU HEAP ALLOCATION IS NOT RELEASED AFTER A MISCONFIGURED SSL CONNECTION TERMINATES | |||
IT32309 | 2 | REMOTE APPLICATIONS UNABLE TO CONNECT AND DIA3208E AND DIA3202C MESSAGES IN THE DB2DIAG.LOG | |||
IT34885 | 2 | SIMPLIFIED SSL CONNECTIONS MAY FAIL WITH GSKIT ERROR 414 WHEN A STASH FILE IS IN USE | |||
IT34881 | 2 | GSKKM_STORECACERT: GSKIT ERROR = 100 ERRORS IN DB2DIAG.LOG | |||
IT34883 | 2 | INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL | |||
IT32777 | 3 | SECURITY - DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK (CVE-2020-4355) | |||
Fix Pack m4fp6 - DB2 Tools | |||||
IT32042 | 2 | EXTRA PRIVILEGES ON NULLID.ATSO05 PACKAGE ARE ADDED TO PUBLIC AFTER RESTORING OLDER RESTRICTIVE DATABASE IMAGE | |||
IT30272 | 2 | DESCRIBE VIA ADMIN_CMD CAN SOMETIMES GIVE WRONG COLUMN ORDER. | |||
IT31887 | 2 | ADMIN_MOVE_TABLE: SQL2103N REASON CODE 17, DIFFERENCE OF PCTFREE VALUE OF SYSTEM GENERATED INDEXES | |||
IT31956 | 2 | ADMIN_MOVE_TABLE: REPORT MAY RETURN UNREASONABLE HIGH VALUES | |||
IT32569 | 2 | SQL2102N RETURNS FROM THE ADMIN_MOVE_TABLE COMMAND | |||
IT35057 | 2 | WHEN A USER ID WITH INSUFFICIENT PRIVILEGE ATTEMPTS TO RUN REORG FROM WITHIN A STORED PROCEDURE, THE STORED PROCEDURE RETURNS RC | |||
Fix Pack m4fp6 - DRDA Services | |||||
IT31100 | 2 | SQL0206N ERROR MAY OCCUR WHEN EXECUTING 'SET CURRENT LOCALE LC_TIME' WITH USING JCC PROPERTY ENABLESYSPLEXWLB=TRUE | |||
IT32287 | 2 | A DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND. (CVE-2020-4420) | |||
IT31707 | 3 | DB2DIAG.LOG IS FLOODED WITH DIA3220W WHEN CONNECTIN LEGACY DB2 CLIENT TO DB2 V11.1 SERVER | |||
IT34715 | 3 | MISSING INFORMATION IN DB2DIAG.LOG WHEN USERID AND PASSWORD ARE CORRECT, BUT THE USER IS REVOKED/DISABLED/LOCKED | |||
Fix Pack m4fp6 - Data Management Services | |||||
IT34314 | 1 | SECURITY: DENIAL OF SERVICE CONDITION INSIDE THE "DB2 MANAGEMENT SERVICE" | |||
IT31317 | 2 | DB2 : MISSING DATA ON QUERY WITH CURRENTLY COMMITTED FEATURE, WHEN SUCH QUERY IS EXECUTED IN THE MIDDLE OF COMMIT PROCESSING | |||
IT35021 | 2 | HIGH CPU AND DECREASED PERFORMANCE WITH HIGH CONCURRENCY OF INDEX CREATION (ON TEMP TABLES) | |||
IT31850 | 2 | TWO PHASE COMMIT SQL0901N | |||
IT33423 | 2 | DB2 MIGHT HANG IN PURESCALE SETUP UNDER A MEMORY CONSTRAINED SITUATION | |||
IT34395 | 2 | HADR GRACEFUL TAKEOVER FAILED DUE TO XML DICTIONARY CREATION ON PRIMARY THAT CANNOT BE FORCED OFF IN A TIMELY MANNER | |||
IT34602 | 2 | REORG START TIME UNEXPECTEDLY UPDATED DURING REORG RECLAIM EXTENTS ON AN ITC | |||
IT31708 | 3 | LOB PAGES MAY NOT BE REUSED PROPERLY IN PURESCALE. | |||
Fix Pack m4fp6 - Data Management Utilities | |||||
IT28601 | 2 | LOAD REPLACE CAN DEADLOCK WITH APPLICATIONS ON SYSIBM.SYSTABLES | |||
IT26343 | 2 | LOAD ERROR: "OPEN LOCFILE FOR WRITE FAILED!" IF A LOAD QUERY TABLE IS EXECUTED IN PARALLEL | |||
IT30690 | 2 | LISTENING PORT MAY LEAK WHEN RUNNING CLI LOAD. | |||
IT31247 | 2 | LOAD HANGS WHEN RUNNING A LOAD FROM CURSOR ON A COLUMN-ORGANIZED TABLE AND LOAD RECEIVES A -955 AT A PARTICULAR STAGE | |||
IT34723 | 2 | TRAP/PANIC DURING SQLU_REGISTER_TABLE_UNLOAD ON CDE TEMPORAL TABLE | |||
IT27171 | 2 | DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATAPART FUNCTION | |||
IT32448 | 2 | IMPORT MAY BE TERMINATED IF SQL0437W IS DETECTED, ALTHOUGH IT CAN BE IGNORED IN MOST SCENARIOS. | |||
IT35964 | 3 | REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN | |||
IT35678 | 3 | UNDER CERTAIN CONDITIONS, THE "NUMBER OF ROWS ..." MESSAGE FROM INGEST UTILITY ARE INCORRECT. | |||
IT34771 | 3 | DB2GETROWPARTNUM() API RETURNS WRONG RESULT FOR BINARY/VARBINARY COLUMN AND NULL VALUE | |||
IT34196 | 3 | DB2 MIGHT REPEATEDLY REPORT ISSUS IN SQLSMERGEREC | |||
IT31514 | 3 | EXPORT TRAPS WITH SIGSEGV IF CLP CONNECTION IS NO LONGER AVAILABLE/CONNECTION FORCED OFF | |||
Fix Pack m4fp6 - Data Recovery Services | |||||
IT31315 | 1 | DATABASE ERROR AFTER TABLESPACE I/O ERROR DURING RECOVERY WHEN DB2_ONLINERECOVERY IS ON. | |||
IT32869 | 2 | PRIMARY HUNG WHEN HADR_FLAGS= STANDBY_RECV_BLOCKED SSL_PROTOCOL | |||
IT34161 | 2 | DB2ADUTL DELETE LOGS WITHOUT PROMPTING" DELETES LOGS ONE BY ONE AND THEREFORE SLOWER THAN DELETING LOGS IN BATCHES. | |||
IT32752 | 2 | HANDLE THE ISSUE WHEN 'NULL' VALUE RETURNED FOR NO SHREDDER WORKER, TO AVOID A MEMBER CRASH IN PURESCALE. | |||
IT33596 | 2 | ROLLFORWARD WITH NORETRIEVE OPTION STILL TRIGGERED LOG RETRIEVAL FROM ARCHIVE AND CAUSED SQL1273N ERROR | |||
IT31677 | 2 | A SYMPTOM IS HIGH LATCH WAIT TIMES ON SQLO_LT_SQELOCALDATABASE__ DBLATCH CAUSING SLOW CONNECTIONS IN AUTOMATED HADR. | |||
IT30844 | 2 | IN DPF ENVIRONMENT THE RESTART DATABASE COMMAND MAY FAIL WITH SQL10003C IF TABLESPACE(S) ARE IN AN ABNORMAL STATE | |||
IT34146 | 2 | INTERMITTENT POOR PERFORMANCE WHEN WRITING TO DB2 TRANSACTION LOG FILES. | |||
IT30833 | 2 | RESTORE INCREMENTAL AUTO OR RESTORE REBUILD FAILS WITH SQL1224 | |||
IT35446 | 2 | SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976) | |||
IT32115 | 2 | DB2 BACKUP WITH COMPRESSION USING AIX NX842 RETURNED SQL2079 GET MA XCOMPRESSEDSIZE PROMISED THAT THIS BUFFER WOULD BE BIG ENOUGH | |||
IT30879 | 2 | SQLP_SEQUENCE_CATALOG_CDE_DICT_STATE LOCK IS INCORRECTLY BEING CONFUSED WITH A SQLP_SEQUENCE_EXT_IND_DESC LOCK | |||
IT33463 | 2 | HADR STANDBY FAILED WITH SQLP_LMAX ERROR WHEN LOCKLIST IS CONFIGURED AS AUTOMATIC | |||
IT32011 | 2 | DB ACTIVATION AFTER AN INSTANCE CRASH FAILS WITH SQL1042C DUE SQLO_SHAR ERROR OPENING TRANSACTION LOGS | |||
IT31496 | 2 | TABLE SPACE BUFFERPOOL FLUSHING TIME 1" IN DB2PD -BARSTATS AND DB2DIAG.LOG SQLUXLOGDATASTATS | |||
IT31101 | 2 | INSTANCE TRAPPED DURING SNAPSHOT MONITORING IN FUNCTION SQLPGETDBMONLOG() | |||
IT32039 | 2 | OPEN ERROR ON PRIMARY LOG PATH COULD LEAD TO FORCED DATABASE SHUTDOWN AND PANIC | |||
IT31115 | 2 | DB2 MAY HANG WHEN DATABASE IS CONFIGURED WITH SMALL LOCKLIST AND DB2_KEEPTABLECOUNT=CONNECTION IS USED | |||
IT35115 | 2 | RESTORE USING "NO ENCRYPT" FROM A DOWNLEVEL ENCRYPTED BACKUP IMAGE WILL RESULT IN DB STILL BEING ENCRYPTED | |||
IT32346 | 2 | "BOTH LOG PATHS SEEM TO BE BAD, TRY PATH1" MESSAGES IN DB2DIAG.LOG MAY CAUSE PERFORMANCE DEGRADATION | |||
IT31098 | 2 | RECOVERY FAILING DUE TO DUPLICATE XIDS IN THE TRANSACTION LOGS | |||
IT31149 | 2 | DISTRIBUTED TRANSACTION ON DATABASE IN DPF ENVIRONMENT MIGHT ENCOUNTER TRAP | |||
IT30257 | 2 | ROLLFORWARD FAILS DURING LOG CHAIN SWITCH WHEN RUN WITH NORETRIEVE AND OVERFLOW PATH | |||
IT30473 | 3 | IN A PURESCALE ENVIRONMENT, A DB2 INSTANCE ON A MEMBER MAY CRASH WHILE PERFORMING BACKUP AND ANOTHER MEMBER CANNOT BE REACHED | |||
IT33151 | 3 | SLOW DATABASE RECOVERY LOG REPLAY ON A WORKLOAD WITH MANY DDLS SPECIFICALLY CREATE / ALTER / TRUNCATE / DROP TABLE | |||
IT29273 | 3 | ENCRLIB DB CFG PARAMETER CAN BE RESET TO THE DEFAULT VALUE AFTER AN INCREMENTAL RESTORE OPERATION. | |||
IT30599 | 3 | BACKUP TAKEN WITH NX842 COMPRESSION MIGHT REPORT GETMAXCOMPRESSE DSIZE PROMISED THAT THIS BUFFER WOULD BE BIG ENOUGH | |||
IT31103 | 3 | INCORRECT REPORTING OF HADR_SPOOL_LIMIT / STANDBY_SPOOL_PERCENT WHEN HADR_SPOOL_LIMIT IS SET TO -1 | |||
Fix Pack m4fp6 - Federation | |||||
IT32122 | 1 | SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 LEADING TO DENIAL OF SERVICE OR PRIVILEGE ESCALATION | |||
IT34956 | 2 | NLJN CANNOT BE PUSHED DOWN | |||
IT31387 | 2 | WHEN DB2_TWO_PHASE_COMMIT=Y AND READONLY=TRUE ON FEDERATION, GET FODC_FORCEDBSHUTDOWN | |||
IT32451 | 2 | PUSHDOWN ON DECFLOAT CAN RETURN -901 IN SOME CASES | |||
JR63050 | 2 | PROBLEM RUNNING UPDATE ON MARIADB (FEDERATION) | |||
IT34955 | 2 | PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING | |||
IT31358 | 2 | POSSIBLE STACK CORRUPTION IN COPYREMOTESTATS() | |||
JR62802 | 2 | PROBLEM RUNNING UPDATE ON MARIADB (FEDERATION) | |||
IT34755 | 2 | DB2 MAY RETURN SQL0901N WITH ERROR MESSAGE "UNEXPECTED ERROR AT MINMAXPARTIALEVALUATOR.CPP" | |||
IT35236 | 2 | DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS. | |||
IT31970 | 2 | SQL0901N ERROR WITH REASON "UNEXPECTED ERROR AT GETJOINPAYLOADEVALUATOR.CPP:151 | |||
IT31380 | 3 | REMOVE ERROR MESSAGES FROM DB2DIAG.LOG FOR ORACLE WRAPPER WHEN SQL0803N ERROR IS RECEIVED | |||
Fix Pack m4fp6 - Index Manager | |||||
IT31229 | 1 | DB2 MAY TRAP WHEN USING SELECT RID_BIT() FUNCTION ON A COLUMN ORGANIZED TABLE | |||
IT32238 | 2 | IN VERY RARE SCENARIOS CONCURRENT UPDATES OR INSERTS INTO INSERT TIME CLUSTERING (ITC) TABLES CAN LEAD TO DEADLATCH | |||
IT31740 | 2 | DB2 PREP COMMAND FAILS WITH SQL4003N 'THE SQL STATEMENT IS NOT SUPPORTED ...' OR SQL0104N 'UNEXPECTED TOKEN ...' ERROR | |||
IT31828 | 3 | STATISTICS COLLECTED WITH INDEX SAMPLING MAY PRODUCE INACCURATE REAL-TIME INDEX STATISTICS AND MON_GET_INDEX INFORMATION | |||
Fix Pack m4fp6 - Install and Catalog Services | |||||
IT34238 | 1 | SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739) | |||
IT32985 | 1 | SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4412) | |||
IT32977 | 1 | SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4412) | |||
IT31604 | 1 | SECURITY: DB2 IS VULNERABLE TO A PRIVILEGE ESCALATION ATTACK (CVE-2020-4230) | |||
IT31278 | 2 | DB2LOOK -M -R CREATE UPDATE SYSSTAT.INDEXES STATEMENT FOR TABLE EVEN WHEN TABLE HAS NO INDEX | |||
IT25254 | 2 | UPGRADE DATABASE CAN FAIL WITH SQL0954 WHEN THERE ARE ROUTINES WITH A LARGE NUMBER OF DEPENDENCIES | |||
IT30568 | 2 | AGGSQLTEMPSPACE THRESHOLD DOES NOT LIMIT TEMPORARY TABLE SPACE SIZE. | |||
IT32719 | 2 | HADR STANDBY FAILS WITH "BAD ENTRY STATE" REPORTED FROM SQLRLC_AUTH_GR_PROCESS_ENTRY_STATE | |||
IT31580 | 2 | FODC_APPERR SQL0901N "UNEXPECTED ERROR AT COLUMN.HPP" WHEN QUERYING FROM COLUMN-ORGANIZED TEMPORAL TABLES | |||
IT31396 | 2 | UTL_FILE BUILT-IN ROUTINES MIGHT BE INVALIDATED WHEN "REVOKE EXECUTE ON MODULE SYSIBMADM.UTL_FILE FROM USER" IS EXECUTED | |||
IT32527 | 2 | DB2 MIGRATE DB DBNAME FAILS WITH ERROR : SQL0461N A VALUE WITH D ATA TYPE "SYSIBM.VARCHAR" CANNOT BE CAST TO TYPE "SYSIBM.VARBINA | |||
IT32727 | 2 | ROUTINE MIGRATION FAILS WITH A SQL0478N WHEN A ROUTINE IS USED AS PART OF A TABLE DEFINITION | |||
IT32198 | 2 | INSTALLFIXPACK TRIES TO EXIT MAINTENANCE MODE WHEN IT SHOULDN'T | |||
IT30507 | 2 | DETACH PARTITION TAKES A LONG TIME -601 ERROR REPORTED ON DB2DIAG.LOG | |||
IT31952 | 2 | DB2 UPGRADE DATABASE APPEARS TO HANG OR RUN VERY SLOW WHEN UPGRADING DATABASE TO V11 | |||
IT32059 | 2 | DBT3568E THE DB2PREREQCHECK UTILITY FOUND THAT THE INPUT/OUTPUT COMPLETION PORT (IOCP) IS NOT INSTALLED ON HOST | |||
IT32796 | 2 | THE GSKIT_PATH ON A TIE-BREAKER HOST IS NOT UPDATED AUTOMATICALLY DURING INSTALLFIXPACK | |||
IJ21542 | 2 | DB2PREREQCHECK SHOULD NOT CHECK MODPROBE FILE WHEN USING MELLANOX CX-4 IB/ROCE CARD ON LINUX PLATFORM | |||
IT29170 | 3 | ADDITIONAL FIX TO APAR IT13674, TEST FOR -NOEXEC MOUNT INCORRECTLY FAILS IN DB2SETUP SCRIPT | |||
IT28890 | 3 | DB2ICRT MAY BE SLOW TO COMPLETE | |||
IT32814 | 3 | TYPENAME FROM ADMIN_GET_TEMP_COLUMNS IS TRUNCATING TO 8 CHARACTERS | |||
IT31757 | 3 | DB2ICRT AND DB2IUPDT FAIL WITH DBI20048E | |||
IT33995 | 3 | POPULATED STATISTICS WERE NOT CLEANED UP AFTER ALTER TABLE ALTER COLUMNS | |||
IT20221 | 3 | DB2ICRT INCORRECTLY UPDATES SVCENAME WITH PORTNUMBER IN DBM CFG | |||
IT35700 | 3 | DB2PREREQCHECK ON AIX DOESN'T CORRECTLY IDENTIFY POWER LEVEL OR IOPORTS | |||
Fix Pack m4fp6 - Monitoring | |||||
IT31310 | 1 | SIGSEGV DURING LOAD WHEN SELF TUNING MEMORY IS ENABLED | |||
IT34787 | 2 | MON_UOW_EXECLIST CONSUMES MONHEAP EVEN WHEN OFF | |||
IT32654 | 2 | ACTIVITY EVENT MONITORS RETURN INCORRECT CPU TIME FOR SP CALLS WITH NESTED STATEMENTS | |||
IT33965 | 2 | FODC_PANIC WITH INVALID LATCH FROM SQLOLATCHCAS64.C WHEN ROUTINE EXECUTION LIST MONITORING IS ENABLED. | |||
IT32749 | 2 | MON_GET_CONNECTION REPORTS SOME METRICS AS 0 FOR APPLICATIONS THAT HAVE ONLY CONNECTED TO A DATABASE BUT STAY IDLE | |||
IT32735 | 2 | INACCURATE LATCH WAIT TIMES REPORTED BY MONITOR INTERFACES ON AIX. | |||
IT35113 | 2 | EVENT MONITOR ACT_EXEC_TIME WRAP AROUND AS AN INTEGER NOT AS BIGINT | |||
IT32515 | 2 | FODC_TRAP GENERATED DURING MON_GET_CONNECTION PROCESSING AN APPLICATION | |||
IT32938 | 3 | CAPTURE_STORAGE_INFO MAY FAIL WITH SQL0443N | |||
IT33889 | 3 | NO MESSAGE TO THE ADMINISTRATION NOTIFICATION LOG FOR DEADLOCKS WHEN MON_LCK_MSG_LVL IS SET TO 2 OR HIGHER | |||
IT25183 | 3 | LOG_TO_FILE OPTION OF EVMON_FORMAT_UE_TO_XML TABLE FUNCTION CANNOT WRITE OUT XML DOCUMENT MORE THAN 100MB | |||
IT34465 | 3 | DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION | |||
Fix Pack m4fp6 - Parsing and SQL PL | |||||
IT30558 | 2 | DB2 MAY ABEND WHILE COMPILING COMPOUND SQL (COMPILED) STATEMENTS | |||
IT27156 | 3 | DB2 MAY ATTEMPT TO REPEATEDLY OPEN A NON-EXISTENT FILE WHICH MAY IMPACT QUERY COMPILATION PERFORMANCE | |||
Fix Pack m4fp6 - Performance | |||||
IT31657 | 1 | CONNECTION SLOWNESS/HANG DUE TO MORE LATCH WAIT AT GROUP AUTHENTICATION STEP. | |||
Fix Pack m4fp6 - Platform Specific | |||||
IT31896 | 1 | APPLICATION TRAPS IN MON_GET_PKG_CACHE_STMT CAUSING DB2 TO CRASH | |||
IT31398 | 2 | DB2FMP SPORADICALLY TERMINATING WITH SQL1224 | |||
IT31613 | 2 | UNNECESSARY SQLO_BAD_USER LOGGING INTO DB2DIAG.LOG | |||
IT32228 | 2 | IF DB2_ALL IS EXECUTED IN PARALLEL IN THE BACKGROUND, STANDARD OUTPUTS FOR SOME NODES MIGHT BE MISSING | |||
IT30411 | 2 | IBM SSH SERVER'S SESSION CAN COME DOWN | |||
IT32619 | 2 | DB2START FAILS DUE TO ENFORCEMENT OF MAXIMUM SEMAPHORE ARRAYS ON LINUX KERNELS 3.10.0-1127.EL7 AND 4.18.0-147.EL8_1 AND NEWER | |||
IT31758 | 2 | POSSIBLE SLOWDOWN (PSEUDO HANG) IF CONNECTION EVENT MONITOR IS ON ON SOLARIS | |||
IT33841 | 2 | ALLOW FOR DB2MEMDBG SETTING : DB2SET DB2MEMDBG=W:16,S:12:10485760:1:W:20:T | |||
IT31704 | 2 | MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES | |||
IT33045 | 2 | POSSIBLE DEADLATCH IN SQLOMEMINIT() WHEN IT LOADS CLIENT-SIDE LIBRARY | |||
IT31776 | 2 | INSERT SQL WITH MULTIPLE VALUES FAILS AFTER SOME MINUTES - DB21018E | |||
IT35550 | 2 | BLU TABLE SELECT CAUSES INSTANCE CRASH TRAP ON WINDOWS | |||
IT35216 | 2 | OOM: REQUEST MEMORY IS FAILING UNNECESSARILY EARLY WHEN THERE IS CONTENTION TRYING TO STEAL MEMORY FROM OTHER CONSUMERS | |||
IT32877 | 2 | SIGNAL STACK OVERFLOW WHILE EXECUTING IN THE SIGNAL HANDLE SQLOEDUCODETRAPHANDLER | |||
IT29989 | 3 | TABLE FUNCTION ENV_GET_NETWORK_RESOURCES() RETURNS NO DATA | |||
IT28835 | 3 | "CATALOG USER ODBC DATA SOURCE" IN LDAP/AD ENVIRONMENT MIGHT CLEAR DB2CLI.INI IF USER HAS NO WRITE ACCESS TO THE USER OBJECT | |||
IT32586 | 3 | ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID() | |||
Fix Pack m4fp6 - Problem Determination | |||||
IT32741 | 1 | SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE AND DENIAL OF SERVICE (CVE-2020-4414) | |||
IT32690 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE (CVE-2020-4387) | |||
IT32737 | 1 | SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE(CVE-2020-4386) | |||
IT32033 | 2 | DB2DART RECEIVES SIGNAL #11 DUE TO TOO MANY TABLESPACES AND OR CONTAINERS | |||
IT31711 | 2 | POSSIBLE TRAP (SEGV) IN PDEDUHOLDSLATCHES() WHEN RUNNING DB2START | |||
IT33367 | 2 | PRIVATE MEMORY LEAK IN DB2SYSC SERVICE ON WINDOWS CAUSED BY DB2PD -MEMBLOCKS. | |||
IT32377 | 2 | DB2PD PROCESS DOES NOT HAVE PROPER SIGNAL CATCHING AND EXIT CAPABILITIES, THUS GENERATING A CORE DUMP WHEN IT SHOULD NOT. | |||
IT31050 | 2 | ON LINUX, DB2 MAY HANG AFTER ISSUING DB2PD -STACK ALL, DB2PD -DUMP ALL IN QUICK SUCCESSION | |||
IT29348 | 3 | DB2SUPPORT MIGHT NOT COLLECT DB2DIAG.N.LOG IN DIAGPATH. | |||
IT28319 | 3 | THE DB2CAEM TOOL MAY FAIL WITH DIFFERENT ERRORS | |||
Fix Pack m4fp6 - Process Model | |||||
IT34261 | 1 | IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND | |||
IT31521 | 1 | SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK(CVE-2020-4135) | |||
IT32437 | 2 | POSSIBLE TRAP IN SQLO_SLATCH_CAS64::RELEASECONFLICT WHEN CLEANING UP FEDERATED FMP | |||
IT31891 | 2 | WITH ROOT_SQUASH ENABLED THE ADD DBPARTITIONNUM COMMAND CAN FAIL WITH SQL6073N | |||
IT29399 | 2 | SLOW CONNECTION DUE TO CONFLICT ON SQLDBCONF (DATABASE CONFIGURATION FILE). | |||
IT31779 | 2 | DB2 MIGHT TRAP IN SQLRWAPPLICATIONAGENTITERATOR:EXECUTE() DURING EXECUTION OF THE MON_GET_APPL_LOCKWAIT TABLE FUNCTION | |||
IT28311 | 2 | BSUH MEMORY LEAK WHEN CONNECTING TO FORMER HADR PRIMARY WHICH HAS BEEN DEACTIVATED DUE TO TAKEOVER BY FORCE | |||
IT33957 | 2 | SQL1013N WHEN RUNNING 'DB2 GET DB CFG' ON REMOTE DB CONNECTION WITH DB2DSDRIVER.CFG | |||
IT31945 | 2 | INSTANCE CAN HANG DURING NODE FAILURE RECOVERY | |||
IT30628 | 2 | DB2 GET DB CFG RECEIVES SSQL5060N WHEN V11.1 CLIENT TO LOWER VERSION SERVER | |||
IT31071 | 2 | SQLKD_PARTNER_ERR LEADS TO SQELOCALDATABASE::FORCEDBSHUTDOWN | |||
IT28618 | 2 | RESTORE MIGHT FAIL WITH SQL5133N | |||
IT30424 | 2 | THE SQLKF_NODE_FAILED MESSGAES IN THE DB2DIAG.LOG DRIVEN BY DB2CFMT EDU. | |||
IT31868 | 2 | INSTANCE WITH MULTIPLE DATABASES TRAPPED ON HADR TAKEOVER OR REPLAY ONLY WINDOW | |||
IT33055 | 2 | MON_GET_TRANSACTION_LOG FUNCTION WHERE IT IS NOT CALCULATING THE RIGHT LOG ALLOCATIONS. | |||
IT26163 | 2 | IN DPF , DB2 MAY CRASH WHEN TRYING TO UNLATCH A LATCH THAT IS NOT HELD | |||
IT22077 | 2 | HANG IN SQLESERVICECLASSDEREGISTERSYSENTITY WHILE HOLDING SQLO_LT_SQLE_SERVICE_CLASS__SERVICECLASSLATCH | |||
IT32855 | 2 | ON BUSY WINDOWS SYSTEMS, IF WLM DISPATCHER IS ON, SOMETIMES THE WHOLE INSTANCE CAN HANG | |||
IT33014 | 2 | SOME 'DB2BP' PROCESS MIGHT HANG AND NOT TERMINATE CAUSING LATER CONNECTIONS TO FAIL WITH "BAD QUEUE HANDLE" OR HANG | |||
IT34786 | 2 | ACTIVATE COMMAND UNABLE TO START HADR DUE TO CLIENT CONNECT SESSION TERMINATED | |||
IT33470 | 2 | DB2CFIMP ADDS TRAILING CHARACTERS TO DB ALIAS. | |||
IT34654 | 2 | WARNING MESSAGES ARE GETTING LOGGED AS SEVERE MESSAGES | |||
IT30401 | 2 | LINUXIA32 AND LINUXAMD64 HAVE DIFFERENT VALUES OF SQLE_LEVEL_BUILD_ID6 ON V11.1 FP4 IFIX001 | |||
IT30402 | 2 | LINUXIA32 AND LINUXAMD64 HAVE DIFFERENT VALUES OF SQLE_LEVEL_BUILD_ID6 ON V11.1 FP4 IFIX001 | |||
IT34472 | 2 | SECURITY: SEVERAL BUFFER OVERFLOW VULNERABILITIES AFFECT DB2 (CVE-2020-4701) | |||
IT31374 | 2 | AFTER INSTALL USING RESPONSE FILE WITH OUT EXTENDED SECURITY DB2SET CRASHING AND DB2ICRT FAILING | |||
IT28392 | 3 | DB2STOP REACHES THE TIMEOUT AND RETURNS SQL1042C ERROR WHEN AN INSTANCE HAS SUSTAINED A TRAP BY A SYSTEM APPLICATION | |||
IT33294 | 3 | CRASH SIGNAL#11 SQLEHDIR__FP8SQLE_BWA IN DB2 V11.1.4.5 | |||
IT26197 | 3 | DB2START MIGHT FAIL WITH SQL6036 AFTER DB2STOP TIMEOUT OCCURS | |||
IT19566 | 3 | WHEN INSTANCE STOPPED IN DB2STOP. IT IS INSTANCE STOPPED DID NOR MAL, BUT THE ERROR LEVEL WAS OUTPUT BY DB2DIAG.LOG (SQL1064N). | |||
IT34398 | 3 | GET DB CFG FOR <DBALIAS> CAN FAIL IF GATEWAY CATALOGS TARGET DB WITH DIFFERENT NAME | |||
IT24179 | 3 | DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH | |||
IT17317 | 3 | THE SMARTGUIDE MAY OVERSIZE BUFFERPOOLS FOR NEW DATABASES ON DPF SETUP. | |||
Fix Pack m4fp6 - Query Compiler Optimizer | |||||
IT30761 | 1 | DB2 MAY RETURN SQL0901N ("COMBINED KEY LENGTH TOO BIG FOR SYSTEM TEMP") WHEN EXECUTING QUERIES INVOLVING ZIGZAG JOINS | |||
IT31026 | 1 | REAL TIME STATISTICS (RTS) PROCESSING ISSUES | |||
IT29611 | 2 | EXPLAIN_FROM_SECTION GENERATES EXPLAIN FILE WITH NEGATIVE VALUES WHEN NUMBER OF ROWS IS UPPER THAN INT LIMIT (2147483647) | |||
IT30825 | 2 | AUTO REORG EVALUATION MAY REPORT TABLE PARTITION SIZE EXCEEDS OF FLINE REORG SIZE CRITERIA BUT LESS THAN MAXOFFLINEREORGTABLESIZE | |||
IT33544 | 2 | SQL0901N PARTITIONED BLU SORT WITH 0 PARTCOLS IS UNEXPECTED | |||
IT28266 | 2 | DYNAMIC QUERY EXECUTION FAILS WITH SQLCODE -901 REASON CODE "CONSTANT OF UNSUPPORTED TYPE" | |||
IT33422 | 2 | AUTO TABLE MAINTENANCE DB2ACD PROCESS FAILS TO CONNECT TO DATABASE WHEN DB2CLI.INI CONFIGURED TO ENFORCE TCP CONNECTIONS | |||
IT34919 | 2 | THE OPTIMIZER MAY CHOOSE A SUBOPTIMAL PLAN FOR QUERY WITH MULTIP LE CORRELATED SCALAR SUBQUERIES WHEN USING GREEDY JOIN ENUM | |||
IT28405 | 2 | SQL1585N IN A CERTAIN QUERY AFTER UPGRADING FROM V10.5 TO V11.1M3FP3A | |||
IT23578 | 2 | SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR | |||
IT31996 | 2 | QUERY WITH OUTER JOIN TOGETHER WITH "DBPARTITIONNUM() =" LOCAL P REDICATE NO LONGER GETS THE DESIRED PLAN. | |||
IT34731 | 2 | RUNSTATS ON KEY COLUMNS SET PROFILE ON COLUMN-ORGANIZED TABLE WITH NO INDEXES MIGHT LATER LEAD TO SQLCODE -901 | |||
IT30945 | 2 | DB2 MAY ABEND WHILE USING PARTICULAR EXPLAIN MODES | |||
IT26734 | 2 | DB2 MAY AVOID CONSIDERING CERTAIN INDEX ACCESS PLANS WHEN FETCH-FIRST-CLAUSE IS PRESENT AND OPTIMIZE-FOR-CLAUSE IS NOT | |||
IT32994 | 3 | SELECT WITH "DB2GSE.ST_CONTAINS(DB2GSE.ST_POLYGON('POLYGO..." C AUSING ERROR SQL0901N "EXTRA COLUMNS REQUIRED FROM INPUT STREAM" | |||
IT25787 | 3 | DB2 MAY RETURN SQL0901N ERROR WHEN COMPILING A QUERY CONTAINING A GROUP BY AND OLAP FUNCTIONS | |||
IT33252 | 3 | AUTOMATIC TABLE MAINTENANCE REORG RECLAIM EXTENTS OPERATIONS ON QUALIFYING ITC TABLES MAY NOT GET TRIGGERED AFTER A DB RESTART | |||
IT33158 | 3 | AUTO_REORG ENABLED DATABASES MAY PERFORM REORG EVALUATION OF TABLES USING THE ADMIN_GET_TAB_INFO() ROUTINE UNNECESSARILY. | |||
Fix Pack m4fp6 - Query Compiler QGM | |||||
IT34696 | 1 | MEMORY CRASH/TRAP WITH LOCAL PREDICATE ON OJ SUBSELECT | |||
IT31751 | 1 | DB2 SERVER MAY FAILED DURING QUERY COMPILATION WITH DECODE FUNCTION | |||
IT32773 | 1 | DB2 UPDATE QUERY SHOWS POOR PERFORMANCE WHEN CORRELATION ON MULTIPLE TABLES | |||
IT34063 | 1 | BOOLEAN PREDICATES RETURN WRONG RESULT WITH NULL INPUT | |||
IT34998 | 1 | DB2 CAN CRASH DURING COMPILATION IF THE SAME EXPRESSION IS USED IN BOTH AN EQUALITY JOIN PREDICATE AND AN EXPRESSION-BASED INDEX | |||
IT33004 | 1 | WRONG RESULT, WHEN OPTIMIZATION LEVEL IS LESS THAN 5 AND NULL EQUALS NULL PREDICATE | |||
IT32754 | 1 | SUSTAINABLE TRAP DUE TO QUERY RE-WRITE WITH MQTS | |||
IT29941 | 1 | 10 CHAR VALUE CAN BE INSERTED INTO VARGRAPHIC(5 CODEUNITS32). THIS SHOULD FAIL WITH SQL0433N ERROR. | |||
IT33071 | 2 | DB2 MIGHT RETURN -901 WHEN RUNNING WITH OUTER JOINS AND INNER JOINS. | |||
IT28641 | 2 | SUBSTR IN COLUMN ORGANIZED COLUMN COMPARISON RETURN WRONG RESULTS | |||
IT29346 | 2 | POSSIBLE PERFORMANCE REGRESSION FOR UPDATE STATEMENTS WHEN MIGRATING TO DB2 V11.1.4 | |||
IT33824 | 2 | LIST STORAGE ACCESS COMMAND GIVES 0 ENTRIES EVEN IF THE CATALOG STORAGE ACCESS COMPLETED SUCCESSFULLY | |||
IT35118 | 2 | POSSIBLE WRONG RESULT WITH ALWAYS-FALSE PRED OR EXISTS PRED | |||
IT32009 | 2 | BASIC PREDICATE "DECFLOAT != BIGINT" RESULTS IN POOR QUERY PERFORMANCE | |||
IT32242 | 2 | LPAD OR RPAD BUILTIN FUNCTION FAIL WITH -901 "VALUE IS TOO LARGE FOR THE BUFFER" | |||
IT26579 | 2 | DB2 SERVER MAY TERMINATE ABNORMALLY WITH SQLDCSL_BADPAGE "BAD DATA PAGE" | |||
IT19505 | 2 | PERFORMANCE OF QUERIES WITH EXISTS PREDICATES DEGRADES AFTER UPGRADE TO FIX PACK 5 | |||
IT34774 | 2 | FOR SPECIAL QUERIES DISTINCT IS PULLED UP ABOVE THE UNION LEVELIN THE OPTIMIZED STATEMENT, WHAT MAY CAUSE WRONG RESULTS | |||
IT19659 | 2 | DB2 MIGHT ABEND WHEN EXECUTING QUERIES WITH MULTIPLE OUTER JOINS AND EQUALITY PREDICATES | |||
IT25305 | 2 | SQL0332N WITH NVL2 FUNCTION AND VARCHAR FOR BIT DATA AND GRAPHIC | |||
IT25849 | 2 | GRANT / REVOKE PRIVILEGE DID NOT TAKE EFFECT IN CATALOG CACHE IMMEDIATELY ON HADR STANDBY SIDE | |||
IT31995 | 2 | AFTER UPGRADE FROM V105, DB2 MAY BE UNABLE TO MATCH ELIGIBLE XML INDEXES FOR XQUERY, LEADING TO POOR QUERY PERFORMANCE. | |||
IT28112 | 2 | DB2 MAY TRAP IN SQLNO_PRED_BUILD_EQ_CLASSES OR SQLNQ_OPRQUNCHILD WHEN A QUERY CONTAINING THE PUSH DOWN OF A TABLE THROUGH AN OUT | |||
IT27796 | 2 | DB2 SERVER TERMINATES ABNORMALLY WHEN AUTO_REVAL=DEFERRED_FORCE | |||
IT29688 | 2 | POSSIBLE FAILURE IN FUNCTION SQLNR_BLD_UPD_COMPENSATION() FOR CORRELATED UPDATE STATEMENTS | |||
IT35150 | 2 | UNEXPECTED SQL0538 WITH NTILE BUILTIN FUNCTION | |||
IT26451 | 2 | DB2 MAY ABEND WHEN ATTEMPTING TO REVALIDATE A MATERIALIZED QUERY TABLE | |||
IT28460 | 2 | QUERY FAILS WITH -901 FOUND ZERO CLOB.RESET OR -973 | |||
IT30629 | 2 | A QUERY COULD HANG WHEN IT HAS CASE EXPRESSION IN GROUP BY | |||
IT29671 | 2 | QUERY MIGHT FAIL WITH SQL0901N AND REASON "UNSUPPORTED LEAF NODE OF THE TREE" | |||
IT25841 | 2 | DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CSES AND CORRELATED SUB-QUERIES | |||
IT30819 | 2 | DB2 SERVER TERMINATES ABNORMALLY IN SQLNQ_UDF_SPECIFIC WITH STMT_CONC=LITERALS | |||
IT31281 | 2 | FODC_TRAP IN SQLVDECFLOATTOCHARWRAPPER | |||
IT29495 | 2 | SERVER TERMINATES ABNORMALLY DURING QUERY COMPILATION | |||
IT29900 | 2 | 901 WITH REASON CODE "INCONSISTENT QPDS FOR THIS XPR" WHEN QUERY HAS XML TABLE AND MQT. | |||
IT27908 | 2 | THE PERFORMANCE CAN BE SUB-OPTIMAL WHEN MAX IS USED AS A LAST HEAD EXPRESSION IN A QUERY. | |||
IT29755 | 2 | 901 COLUMN NUMBER OUT OF RANGE WHEN GB IN OJ AND GB COLUMN IS NOT USED IN OJ OR ABOVE. | |||
IT32300 | 2 | DB2 MAY FAILED WITH -901 | |||
IT31525 | 2 | WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION. | |||
IT19590 | 2 | DB2 MIGHT PRODUCE A SQL0901N, EXECUTING QUERIES WITH UNION ALL | |||
IT30942 | 2 | TRANSFER OWNERSHIP MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY | |||
IT31862 | 2 | TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE | |||
IT31145 | 2 | CDE HSJN NOT PICKED UP FOR NON EQUAL PREDICATES(RANGE AND OR PREDICATES) | |||
IT30017 | 2 | DB2 MAY RUN OUT OF STATEMENT HEAP WHILE COMPILING QUERIES INVOLVING UNIONS AND PREDICATES WITH WEAK UDTS | |||
IT25969 | 2 | QUERY FAILS WITH SQL0901N REASON "PARENT ENTITY NOT PROVIDED" OR REASON "FOUND ZERO CLOB.RESET" | |||
IT34250 | 2 | 901/TRAP WHEN DB2 QUERY HAS GROUP BY AND OJ WITH UNION | |||
IT31146 | 2 | ANTIJOIN BLOCKED WHEN QUERY HAS SIDE EFFECTS | |||
IT31223 | 2 | BAD PERFORMANCE DUE TO DELAYED JOIN PREDICATE PUSHDOWN THROUGH UNION ALL PREVENTS JOIN ELIMINATION | |||
IT34104 | 2 | DB2 QUERY MAY HANG WITH REGISRTY SETTING INJ_DUMMY_PRD4JOIN | |||
IT28270 | 2 | LPAD, RPAD OR REPLACE MAY RESULT IN SQLCODE -901 WHEN SOURCE-STRING REFERENCES A COLUMN-ORGANIZED TABLE COLUMN | |||
IT30620 | 2 | INCORRECT OUTPUT WHEN ROWNUM IS USED IN THE SAME WHERE CLAUSE AS INLINED UDF | |||
IT30741 | 2 | QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP" | |||
IT31208 | 2 | INCORRECT RESULT WHEN USING TWICE JOIN WITH THE SAME TABLE WITH GROUP BY | |||
IT33038 | 3 | DB2 QUERY PERFORMS BAD WHEN USING SUBQUERY PREDICATE WITH OR | |||
IT35256 | 3 | DB2 TERMINATES ABNORMALLY COMPILING A QUERY. | |||
IT29658 | 3 | DB2 MIGHT ABEND WITH -901 OR CAN HAVE WRONG RESULT WHEN RUNNING QUERIES WITH OUTER JOINS AND INNER JOINS | |||
IT30337 | 3 | INCORRECT RESULTS FOR A QUERY ON COLUMN-ORGANIZED TABLE WHEN FETCH FIRST N ROWS ONLY CALUSE USED | |||
IT35056 | 3 | CREATING AN EXPRESSION-BASED INDEX FAILS WITH -356 AND EMPTY REASON CODE | |||
IT26685 | 3 | DB2 MAY RETURN SQL0901N WHEN EXECUTING A QUERY INVOLVING VARCHAR CODEUNITS32 IMPLICIT CASTING AND COLUMNAR TABLES | |||
IT33805 | 3 | WRONG RESULT/901 WHEN IN USED ON SELECT | |||
IT29574 | 3 | WRONG RESULT MIGHT OUTPUT FROM QUERIES WITH INNER JOINS AND CORRELATED EXISTS SUB-QUERIES CONTAINING OUTER JOINS | |||
Fix Pack m4fp6 - Relational Data Services | |||||
IT31025 | 1 | REDUCED PACKAGE CACHE CAPACITY MIGHT RESULT OVER TIME WHEN WITH HISTORY MONITORING IS ENABLED | |||
IT34417 | 2 | QUERY INTERRUPT DOES NOT RETURN SQL0952N WHEN A WLM THRESHOLD WAS CREATED | |||
IT35954 | 2 | MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK | |||
IT31088 | 2 | EXPLICT REBIND AND ATTACH/DETACH/ADD PARTITION MAY DEADLOCK | |||
IT35200 | 2 | REBIND FAILING WITH SQL0100W | |||
IT27923 | 2 | DPF PACKAGE CACHE REBIND DAEMON (DB2PKGRB) MAY HANG IN A PENDING REMOTE REQUEST STATE | |||
IT30925 | 2 | SEVERE MESSAGE WITH -803 COULD BE RECORDED IND B2DIAG.LOG. | |||
IT33039 | 2 | DIAGNOSTIC DATA DUMPING AFTER -901 CAUSED TRAP | |||
IT31808 | 2 | TRAP MAY HAPPEN WHEN RUNNING DB2EXPLN BY '-CACHE' OPTION WITH WRONG ENVIRONMENT ID | |||
IT31700 | 2 | APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS | |||
IT31614 | 2 | FODC_TRAP AND CRASH IN SQLRA_LOAD_VAR | |||
IT31752 | 2 | SELECT IO_WAIT_TIME_PERCENT FROM SYSIBMADM.MON_DB_SUMMARY CAN RE TURN WITH "SQL0413N OVERFLOW OCCURRED DURING NUMERIC DATA TYPE C | |||
IT32551 | 2 | MULTIPLE SEVERE/INFO MESSAGES WITH -803 COULD BE RECORDED IN DB2DIAG.LOG AND MAY AFFECT PERFORMANCE | |||
IT32303 | 2 | DB2JDBCBIND COMMAND GENERATES FODC_APPERR FOLDERS | |||
IT31416 | 2 | PANIC MAY OCCUR IN HADR TAKEOVER (11.1 M4FP5 ONLY) | |||
IT35983 | 3 | MON_GET_APPL_LOCKWAIT TABLE FUNCTION MIGHT RETURN INCORRECT 'HLD_MEMBER' IN PURESCALE | |||
IT32291 | 4 | REORG INDEXES ALL REPORTS MISLEADING "SQLRREORG_INDEXES, PROBE:1160" IN DB2DIAG.LOG | |||
Fix Pack m4fp6 - Routine Infrastructure | |||||
IT32125 | 2 | MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO | |||
IT33665 | 2 | WHEN INTERRUPT HAPPENS, FMP TRAPS DUE TO EMPTY THREAD LIST ACCESS | |||
IT34425 | 2 | HANGING QUERY IN CLOB TYPE STATEMENTS | |||
IT34853 | 3 | JAVA EXTERNAL ROUTINE MIGHT RETURN TRUNCATED CLOB | |||
Fix Pack m4fp6 - Security | |||||
IT33865 | 2 | HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLE AND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES | |||
IT31215 | 2 | UNDER RARE SCENARIOS, AUTHENTICATION WILL HANG DURING A PASSWORD CHECK | |||
IT31205 | 2 | CONNECT WITH SIMPLIFIED SSL FAILS WITH SQL10013N "GSKIT ERROR: 202" | |||
IT31730 | 2 | "DB2AUDIT EXTRACT" MIGHT FAIL WITH AUD0003N DUE TO FILE DESCRIPTOR LEAK | |||
IT31330 | 2 | INCORRECTLY CONFIGURED SSL CONNECTION MAY TRIGGER DB2 TRAP | |||
IT32706 | 3 | SYSPROC.AUDIT_ARCHIVE DOES NOT CREATE A FILE WHEN CONNECTED TO A DATABASE ALIAS. | |||
Fix Pack m4fp6 - Text Search | |||||
IT31316 | 1 | INTERMITTENT HANG IN SOCKET SELECT | |||
IT33731 | 2 | DB2 NSE INDEX UPDATES MAY FAIL WITH ERROR CTE0310 | |||
IT31754 | 2 | THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000 | |||
IT28446 | 2 | DB2 SERVER GOT CRASHED IN CIEUTIL!CIE::CTEERROR::MAKEDIAGNOSTICMESSAGE | |||
Fix Pack m4fp6 - XML | |||||
IT32856 | 2 | DB2 MAY TRAP WHEN QUERYING XML COLUMNS WITH THE XMLCAST FUNCTION | |||
Fix Pack m4fp6 - pureScale Services | |||||
IT35305 | 1 | SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-####) | |||
IT31574 | 2 | MODIFICATION TO /ETC/FILESYSTEMS FILE MAY INTERFERE WITH DB2 MOUNT MONITOR | |||
IT31547 | 2 | IN AN AUTOMATED HADR ENVIRONMENT, THERE MAY BE ERRORS IN ATTEMPTING TO DELETE MOUNT RESOURCES WHICH DO NOT EXIST | |||
IT29557 | 2 | MORE ROBUST CLEANUP STATUS CHECKING | |||
IT33221 | 2 | DB2 WILL LEAK PRIVATE (HEAP) MEMORY ON VERSION 11.1 MOD 4 FIX PACK 5 IN ENVIRONMENTS WITH TSA HA AUTOMATION. | |||
IT31295 | 2 | "DB2CLUSTER -VERIFY" COMMAND SOMETIMES FAILS IN RDMA PING TEST PHASE WITH DAT API ERROR "UNEXPECTED EVENT: 0X4003" | |||
IT31337 | 2 | DB2CLUSTER COMMAND WILL TIMEOUT IF EXCEEDS 22 MINUTES | |||
IT32517 | 2 | IN DB2 V11.1 M4FP5, SLOWNESS IN DB2LOCSSH OR DB2SCP COMMAND MAY CAUSE DB2ICRT COMMAND TO EXECUTE VERY SLOWLY OR HANG | |||
IT33195 | 2 | DB2CLUSTER -ENTER -MAINTENANCE STEPS NEED TO BE CHANGED ACCORDING TO NEW GPFS TECHNOTE | |||
IT31780 | 2 | ADM16504E IS GENERATED IN DB2DIAG.LOG IN PURESCALE AFTER DB2STOP IS RUN | |||
IT31706 | 2 | NETWORK OUTAGE WHILE DB2CFCONNPOOLMGR REBALANCES CF CONNECTION POOL MAY HANG CONNECTION POOL MANAGER. | |||
IT33122 | 2 | STANDBY HOST FOR PARTITIONS IS NOT UPDATED IN A DPF ENVIRONMENT WITH THE ROVING HA FEATURE ENABLED | |||
IT34352 | 3 | DURING START DB2DIAG.LOG MAY BE FLOODED WITH "NO HADR RESOURCE DEFINED" INFO MESSAGES IN AN ACTIVE-PASSIVE TOPOLOGY | |||
IT31531 | 3 | THE DB2CLUSTER -CM -CLEAR -ALERT COMMAND FAILS WHEN RUN AS NON INSTANCE OWNER PART OF SYSADM, SYSMAINT, OR SYSADM GROUP | |||
IT30720 | 3 | DB2PD BINARY PATH NOT SPECIFIED IN HADRV111_MONITOR.KSH AND OTHER AUTOMATION SCRIPTS | |||
IT34190 | 3 | DB2EGCF MAY CAUSE TRACE FLOODING DUE TO MEMORY SEG FAULT | |||
IT36094 | 3 | DB2CLUSTER -CFS -LIST -IGNOREMOUNTERROR -HOST <HOSTNAME> FAILS WITH INTERNAL DB2CLUSTER ERROR |
DB2 Version 11.1 Fix Pack m4fp5 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
Fix Pack m4fp5 - Administration Tools | |||||
IT29771 | 2 | UPDATE OF STATS USING "DB2LOOK -D <DB_NAME> -Z <SCHEMA_NAME> -T <TABLE_NAME> -M -C -R" OUTPUT CAUSES DEADLOCKS | |||
IT29449 | 2 | MISSING START MESSAGE OF AUTOMATIC BACKUP EVALUATION IN DB2DIAG.LOG. | |||
IT26913 | 2 | DB2LOOK INCORRECTLY ADDS THE DELIMITER WITHIN THE COMMENT PLACED AT THE END OF THE STORED PROCEDURE | |||
IV98044 | 2 | MEMORY LEAK IN DB2TOP WHEN VIEWING DYNAMIC SQL | |||
IT25645 | 2 | DB2LOOK WITH -CT DOES NOT GENERATE SET SCHEMA DDL'S BEFORE CREATE MQT/SUMMARY TABLES WITH IMPLICIT SCHEMAS | |||
IT25377 | 2 | GRANT STATEMENT IS MISSING FROM DB2LOOK OUTPUT. | |||
IT26311 | 2 | DB2: DB2LOOK -L WILL USE AN EXCESSIVE AMOUNT MEMORY IN PARTITIONED (DPF) ENVIRONMENTS WITH MULTIPLE DMS TABLESPACES. | |||
IT29577 | 2 | DB2LOOK IS NOT DISPLAYING THE TABLE COMMENTS PROPERLY USING DOUBLE QUOTES | |||
IT29967 | 2 | DB2LK390.BND IS BOUND ON Z/OS WITH THE SAME PACKAGE NAME BUT DIFFERENT CONTOKENS FOR DIFFERENT DB2 CLIENT LEVELS | |||
IT29789 | 2 | DB2LOOK -E -CT -DP FAILS :CALL DB2LK_GENERATE_DDL FAILED, SQLCOD E IS -443; SYSPROC.DB2LK_GENERATE_DDL?DB2LK_GENERATE_DDL?INVA | |||
IT29891 | 3 | INCORRECT ORDER OF INDEX AND PRIMARY KEY GENERATED DURING DB2LOOK -CT PROCESSING | |||
IT29892 | 3 | DBDB2LOOK (DB2LK390) ATTEMPTS TO GENERATE VIEWS | |||
IT28001 | 3 | "ALTER SEQUENCE SEQUANCE_NAME RESTART WITH" - STATEMENT IN DB2LOOK OUTPUT HAS INCORRECT VALUES | |||
Fix Pack m4fp5 - Buffer Pool Services | |||||
IT30189 | 1 | UPGRADE DB MAY CORRUPT SQLSPCS FILES AND RESULT IN CHECKSUM ERROR WHEN DB IS ACTIVATED | |||
IT28165 | 2 | DB2 PURESCALE INSTANCE MAY PANIC DURING BUFFERPOOL DECREASE | |||
IT28622 | 2 | NUMBLOCKPAGES OF A BUFFERPOOL MAY BE ADJUSTED TO AN INVALID VALUE | |||
IT29380 | 2 | ROLLFORWARD MAY FAIL WITH SQL1271W AND SQLB_TBSPACE_TOO_SMALL WHEN REPLAYING AN ALTER TABLESPACE OPERATION | |||
IT29081 | 2 | FALSE POSITIVE AGAINST BACKUP WITH REGISTRY DB2_BCKP_PAGE_VERIFICATION | |||
IT28881 | 2 | TABLE SPACE RESTORE UNABLE TO USE ALL CONTAINER PATHS AND FAILS WITH DISK FULL | |||
IT26440 | 2 | DB2RELOCATEDB ERROR: COULD NOT OPEN FILE/DEVICE | |||
IT27775 | 2 | SLOW DATABASE ROLLFORWARD OR HADR REPLAY OF "REDUCE MAX" OPERATION | |||
IT29297 | 2 | INCOMPATIBLE OPERATIONS OF EXTENT MOVEMENT AND REBALANCE RUN AT THE SAME TIME CAN CAUSE DATA CORRUPTION | |||
IT29233 | 2 | INSTANCE PANIC WHEN PAGE CLEANER AIO FAILS DUE TO OUT-OF-MEMORY ERROR. | |||
IT27943 | 2 | DEADLATCH BETWEEN AN ONLINE BACKUP, PREFETCHERS AND AN AGENT DOING A WRITE TO THE SAME TABLE SPACE | |||
IT26871 | 2 | TABLE SPACE OFFLINE AFTER "ALTER TABLESPACE ... MANAGED BY AUTOMATIC STORAGE" COMMAND | |||
IT27666 | 2 | DB2 INSTANCE PANIC WHILE RUNNING QUERIES INVOLVING A SORT OPERATOR | |||
IT26870 | 2 | DB2 PURESCALE DATABASE SNAPSHOT MAY REPORT SEVERE ERROR "INVALID STORAGE GROUP IDENTIFIED FOUND." | |||
IT29381 | 2 | A FAILURE WHILE REPLAYING A TABLE SPACE LOG RECORD MAY CAUSE SUBSEQUENT ROLLFORWARDS TO CORRUPT THE TABLE SPACE | |||
IT30526 | 3 | ADDING DEBUG CODE FOR SQLBFIX - BFIX DETECTED AN ERROR | |||
IT28320 | 3 | RESTORE OF SMS AUTOMATIC STORAGE TABLE SPACE IN DB2 DEVELOPER-C EDITION FAILS WITH SQL1139N | |||
IT28880 | 3 | EXTENT MOVEMENT RETURNS SQL1523N REASON CODE "15" WHEN EXTENT MOVEMENT NOT RUNNING | |||
IT28615 | 3 | DB2PD -TABLESPACE DOES NOT INDICATE LOCAL OFFLINE STATE | |||
Fix Pack m4fp5 - Build Team | |||||
IT28459 | 2 | SELECT FROM PIPE VIA EXTERNAL TABLES DOES NOT WORK ON WINDOWS CLIENT | |||
Fix Pack m4fp5 - CDE Data | |||||
IT28206 | 2 | ASSERTION FAILURE AND BAD PAGE ERROR WHEN ROLLING BACK INSERT THAT SPECIFIES IGNORE DUPLICATES | |||
Fix Pack m4fp5 - CDE Query | |||||
IT26894 | 2 | ROUND() SCALAR FUNCTION MAY RETURN INCORRECT RESULT WITH FLOATING POINT NUMBER ON COLUMN-ORGANIZED TABLE | |||
IT27064 | 2 | ERROR SQL0901N RAISED DURING SELECT FOR TABLE ORGANIZE BY COLUMN (INTRA_PARALLEL INTRAPARTITION PARALLELISM) | |||
IT29344 | 2 | MEMORY CORRUPTION / TRAP IN ALLOCMEM TERMFASTALLOC DURING COLUMNAR DATA PROCESSING | |||
IJ17234 | 2 | FODC_APPERR AND SQL0901: UNEXPECTED ERROR AT LOADCOLVALUEEVALUATOR.CPP:2417 PROCESSTSNRANGEONPAGE | |||
IT28586 | 2 | QUERY HANG IN LOADNESTEDQUERYEVALUATOR::GETCSENESTEDQUERYOUTPUT | |||
IT28596 | 2 | QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNION MAY GET INCORRECT RESULT | |||
IT29786 | 2 | SQL0901N: UNEXPECTED ERROR AT QUERYINFOCONTAINER.HPP:395 | |||
IJ10997 | 2 | MEMORY CORRUPTION/ABEND DURING ARRAY UPDATE ON COLUMNAR BASED TABLES ON DPF ONLY | |||
IJ10998 | 2 | PRIVATE MEMORY LEAK WHEN PERFORMING ARRAY UPDATE ON COLUMNAR DATABASE IN DPF | |||
IT28258 | 2 | TRAP ON IBM_CDE::TYPES::BITSTRING::COMPACTANDAPPENDCPU | |||
IJ08464 | 2 | BUFFERPOOL DECREASE HANGS WHEN USING COLUMNAR STORAGE | |||
Fix Pack m4fp5 - Client Interfaces | |||||
IT27213 | 1 | PSIRT ADVISORY: 14288, PR: 127374 - 3RD PARTY IBM DB2 TOOL DB2CFEXP OPTION FILENAME IS VULNERABLE TO STACK OVERFLOW ATTACK | |||
IT30106 | 1 | ERROR WHILE LINKING WITH LIBDB2O.SO | |||
IT27328 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION (CVE-2019-4014) | |||
IT28438 | 2 | ERROR CLI0111E SEEN WHEN FETCHING A DATE OR TIMESTAMP DATABASE COLUMN AS A SQL_C_BINARY FIELD | |||
IT26429 | 2 | MULTI ROW FETCH IN DB2 11.1 LUW MAY NOT GIVE EXPECTED RESULTS | |||
IT26596 | 2 | XA CONNECTION FAILS IF KEYWORD VALUE IN CONNECTION STRING CONTAI NS SPACE.SSLSERVERCERTIFICATE IS NOT WORKING WITH XA CONNECTION. | |||
IT29857 | 2 | SQLCREATEPKG API IS FAILING WITH SQL0031C ERROR. | |||
IT29781 | 2 | SQLGETCONNECTATTR() FUNCTION CALL WITH SQL_ATTR_GET_LATEST_MEMBE R_NAME TAKING TIME DUE TO GETADDRINFO TAKING MORE TIME | |||
IT29428 | 2 | LOG MESSAGES IN CLPBP_INSTALL_SIGNALS FLOODING THE DB2DIAG.LOG | |||
IT25589 | 2 | LIST HISTORY COMMAND FAILS WITH DB21018E ERROR WHEN THE HISTORY FILE CONTAINS A DROPPED TABLE EVENT WITH LONGER TABLE NAME. | |||
IT27700 | 2 | WHEN CALLING EXTERNAL STORED PROCEDURE AGAINST IBM I SERVER, APP THROWS EXCEPTION : SQL30073N PARAMETER VALUE IS NOT SUPPORTED | |||
IT29994 | 2 | DB2STOP MEMBER CAUSED JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION | |||
IT30123 | 2 | OCI FUNCTION OCILOBGETLENGTH() RETURNS ERROR -1 FOR LENGTH GREATER THAN 1 MB | |||
IT27223 | 2 | SLOWNESS WHEN USING THE DB2DSDRIVER.CFG FROM NFS LOCATION | |||
IT26025 | 2 | INTERMITTENT DB21016E AND/OR DB21018E ERROR ON AIX. | |||
IT29206 | 2 | SQLSETCONNECTATTRW() WITH SQL_ATTR_SESSION_GLOBAL_VAR ATTRIBUTE IS NOT WORKING AS EXPECTED | |||
IT28771 | 2 | SQLGETTYPEINFO WITH SQL_BOOLEAN IS NOT RETURNING ANY RESULT | |||
IT29782 | 2 | SQLCODE -514 USING IBM DATA SERVER DRIVER FOR JDBC WITH XA AGAINST Z/OS V12 | |||
IT30258 | 3 | JDBC ERROR "UNRECOGNIZED JDBC TYPE:-15 ERRORCODE=-4228, SQLSTATE=NULL " | |||
IT29195 | 3 | CLPPLUS DOES NOT RUN THE LOGIN.SQL SCRIPT DURING STARTUP. | |||
IT27374 | 3 | DB2DSDRIVER.CFG, XML COMMENTS DO NOT WORK ON A WHOLE BLOCK OF PARAMETERS, BUT ONLY ONE A SINGLE LINE AT A TIME | |||
IT21772 | 3 | INCORRECT LENGTH FOR SQL_LOCAL_LEN AND SQL_CODESET_LEN ON AIX | |||
IT29501 | 3 | DB2DSDCFGFILL COMMAND WITH -MIGRATECLIINIFOR.NET OPTION IS NOT MIGRATING ALL THE ENTIRES IN DB2CLI.INI TO DB2DSDRIVER.CFG | |||
IT27650 | 3 | CLI INCORRECTLY CONVERTS AN EMPTY STRING TO 0 FOR WCHAR TO INTEGER CONVERSION | |||
Fix Pack m4fp5 - Codegen and Runtime | |||||
IT27720 | 1 | WHEN EXECUTING QUERY CONTAINING XML WITH REOPT ALWAYS IT IS POSSIBLE TO HIT SQL0901N REASON "SQLRIMSO: CURLSE > NUM_LSE" | |||
IT29350 | 1 | SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE (CVE-2019-4386) | |||
IT28021 | 1 | DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY WILL FAIL WITH AN SQL2079N ERROR, IN VERSION 11.1.4.4. | |||
IT26954 | 1 | DB2 SERVER MAY TRAP IN ICU PROCESSING DATE-TIME FUNCTION. | |||
IT25991 | 2 | THE IMPORT UTILITY MAY FAIL WITH ERROR -16129 ON PARTITIONED DATABASE. | |||
IT30426 | 2 | USE OF JSON FUNCTION MAY CAUSE PANIC | |||
IT28228 | 2 | DB2 MAY ABEND ON A QUERY THAT CONTAINS A COLUMNAR FETCH-INDEX SCAN THAT RUNS OUT OF APPLICATION HEAP | |||
IT30060 | 2 | INSTANCE COULD GO DOWN WHEN EXECUTING QUERY WITH AN EXECUTION PLAN THAT INCLUDES AN INDEX AND OPERATION. | |||
IT27067 | 2 | HANG MAY OCCUR WITH COLUMN ORGANIZED QUERY IN DPF ENVIRONMENT WHERE AGENT CANNOT BE FORCED | |||
IT28014 | 2 | WRONG RESULT IS POSSIBLE IF QUERY OPTIMIZATION IS SET TO 0 AND QUERY HAS "ALL" | |||
IT29545 | 2 | DB2 MIGHT TRAP OR FAIL WITH SQL0901 DURING THE ACCESS TO BLU TABLES | |||
IT30119 | 2 | SELECT MIGHT UNNECESSARILY ACQUIRE IN LOCK | |||
IT28638 | 2 | DB2 MAY PRODUCE INCORRECT RESULTS FOR HSJN WITH PREDICATE THAT HAS CASE(COALESCE) AND NLJN OR ZZJOIN ON THE OUTER | |||
IT27001 | 2 | POSSIBLE TRAPS AND/OR EBADF (ERRNO 9) ERRORS WHEN USING UTL_MAIL.SEND() AND THE ROUTINES FAILS | |||
IT28843 | 2 | SECTION_LEVEL_LOB FLAG CAUSING UPDATE STATMENT FAILED DURING SAP JAVA EHP UPGRADE | |||
IT26035 | 2 | INSTANCE CAN CRASH IN SQLRICLS_COMPLEX DUE TO MEMORY CORRUPTION. | |||
IT28098 | 2 | DB2 CRASHES PRODUCING AN FODC_TRAP | |||
IT30294 | 3 | DBMS_LOB.CONVERTTOCLOB REDEFINED AS READS SQL DATA | |||
IT30105 | 3 | USE OF JSON_TO_BSON FUNCTION MIGHT CAUSE TRAP OR PANIC. | |||
IT28344 | 3 | RELAX INTERRUPT DIAG LOG IN SQLRISRT TO WARNING | |||
Fix Pack m4fp5 - DB2 Tools | |||||
IT28743 | 2 | ADMIN_MOVE_TABLE: MISLEADING ERROR MESSAGE REFERRING TO SEMAPHORES. SQL2102N REASON CODE 33 | |||
IT27659 | 2 | SYSTOOLS.JSON_TABLE(SYSTOOLS.JSON2BSON("") RUNS IN A LOOP AND NEVER RETURN | |||
IT26704 | 3 | ADMIN_MOVE_TABLE: OUTPUT OF OPERATION ESTIMATE MAY RETURN SOURCE TABLE SIZES OF -4 AND SMALLER | |||
IT27847 | 3 | MON_GET_CONTAINER TABLE FUNCTION RETURNS MISLEADING VALUES IN FILESYSTEM COLUMNS FOR RAW DEVICES | |||
Fix Pack m4fp5 - DRDA Services | |||||
IT27418 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
IT27287 | 2 | XA FUNCTION MAY CAUSE MEMORY LEAK AND RETURN XAER_RMERR WITHOUT ADDITIONAL INFORMATION | |||
Fix Pack m4fp5 - Data Management Services | |||||
IT27351 | 1 | DBHEAP MAY BECOME EXHAUSTED DUE TO MEMORY LEAK WHEN RUNNING ALTERS ON A PARTITIONED TABLE | |||
IT26394 | 2 | DB2 TAKES Z LOCK WHEN ATTACHING PARTITION TO TABLE | |||
IT29633 | 2 | INTERRUPTING ROLLFORWARD OPERATIONS DURING REPLAY CAN CAUSE SUBSEQUENT ROLLFORWARD TO FAIL | |||
IT24585 | 2 | INSERTS TO A PAGE MAY NOT RE-USE RESERVED SPACE ON A PAGE PROPERLY WHICH CAUSES NEW PAGE ALLOCATION AND OVERFLOW RECORDS | |||
IT27940 | 2 | DB2 REORG RECLAIM EXTENTS ON ITC TABLES MIGHT DEADLOCK WITH AN APPLICATION | |||
IT27061 | 2 | PAUSED-REORG RECORD IS REMOVED IN DB2PD -REORG BY REORG PAUSE COMMAND ON THE SAME TABLE IN PURESCALE | |||
IT29241 | 3 | LIMIT THE AMOUNT OF DIAGNOSTICS DUMPED WHEN SERVICELEVEL=BASIC | |||
IT28059 | 3 | PERFORMANCE ISSUE SEEN ON HADR ROS WITH ONLY ONE BUFFERPOOL | |||
Fix Pack m4fp5 - Data Management Utilities | |||||
IT28784 | 1 | RESTORING A LOADCOPY WHEN THERE IS A MODIFICATION STATE INDEX ON A COLUMN ORGANIZED TABLE MAY CORRUPT THE INDEX. | |||
IT26658 | 2 | UNEXPECTED SQL1188N ON LOAD FROM REMOTE CURSOR WHEN USING MODIFIED BY ROWCHANGETIMESTAMPIGNORE | |||
IT12871 | 2 | LOAD HITTING OUT OF MEMORY ERROR IN SOME SPECIFIC POINT MAY LEAD TO AN INSTANCE CRASH. | |||
IT29629 | 2 | APPLICATION CAN GET CAUGHT IN ENDLESS LOOP IN BSORTINITCNTSRTSTACKINFO IF APPLHEAPSZ = 2147483647 | |||
IT19545 | 2 | LOAD FROM CURSOR (LOCAL OR REMOTE DB) FROM SOURCE COLUMN CHAR(CODEUNITS32) MIGHT FAIL OR INSERT EXTRA TRAILING BYTES | |||
IT26773 | 2 | DB2 TRAPS DUE TO DATASTAGE PASSES NON-NULL PIOUTPUTNODES BUT INUMNODES=0 WHEN CALLING DB2LOAD() | |||
IT25793 | 2 | DB2 MAY HANG IN ACCESSING GLFH FILE WHEN USING MULTIPLE CONCURRENT IMPORT IN DPF | |||
IT23771 | 2 | ROLL FORWARD OR CRASH RECOVERY MAY CRASH WHEN WORKING ON INDEX PAGE. | |||
IT27044 | 2 | DB2 MAY HANG IN ACCESSING GLFH FILE WHEN USING MULTIPLE CONCURRENT IMPORT IN DPF | |||
IT24856 | 2 | DB2 MIGHT CRASH IN LOAD CLEANUP | |||
IT22728 | 3 | ERROR PROBLEMS DOWNGRADING SYSTABLES LOCK WHILE LOAD IS SUCCESSFUL | |||
IT26313 | 3 | YOU MAY ENCOUNTER ERROR SQL27970N DURING EXECUTION OF IMPORT COMMAND WITH COMMITCOUNT AUTOMATIC | |||
Fix Pack m4fp5 - Data Recovery Services | |||||
IT28195 | 1 | UNEXPECTED SQLP_LTIMEOUT ERROR CAN CAUSE ABNORMAL DATABASE SHUTDOWN. | |||
IT29178 | 1 | DETECT LFR MOVING TO NEXT EXTENT TOO EARLY AND FAIL SO THAT READLOG DOES NOT SKIP LOG RECORDS. | |||
IT29648 | 2 | APPLICATIONS MAY HANG DURING TAKEOVER IN AUTOMATED TSA HADR ENVIRONMENT DURING FIX PACK UPGRADE | |||
IT29822 | 2 | HADR STANDBY WITH ROS CAN HANG DURING ENDING OF REPLAY ONLY WINDOW | |||
IT28326 | 2 | DB2CKBKP -E MAY RESULT IN A TRAP IF THE USER INPUT A NON-EXISTING OBJECT TYPE IN EXTRACTPAGE.IN | |||
IT28801 | 2 | BACKUP WITH AIX COMPRESSION NX842 RETURN SQL2079 GETMAXCOMPRESSE DSIZE PROMISED THAT THIS BUFFER WOULD BE BIG ENOUGH | |||
IT29417 | 2 | SNAPSHOT MONITOR TRAPPED IN FUNCTION SQLPLGETLOCKWAITINFO() | |||
IT29736 | 2 | REPLAYING DROP TABLESPACE WOULD SET POOL ID TO -1 IN FILTERED TA BLESPACE LIST ON STANDBY, CAUSING SQLPRSETPOOLENDLFS() TO PANIC | |||
IT28267 | 2 | SECURITY: DB2 DOES NOT EXPLICITLY FORBID A WEAKER THAN EXPECTED 3DES CIPHER WHEN CONFIGURED TO USE SSL (CVE-2019-4102) | |||
IT24200 | 2 | IN SPECIFIC TIMING CONDITIONS DB2READLOG API CALLER CAN THROW SQL2038N ERROR. | |||
IT29730 | 2 | DB2 TRIES TO ROLLFORWARD A TABLESPACE TO PIT BEFORE MRT | |||
IT26775 | 2 | HADR STANDBY HUNG AFTER LOSING CONNECTION WITH THE PRIMARY | |||
IT26452 | 2 | RESTORE OF A NON-ENCRYPTED DATABASE INTO AN ENCRYPTED ONE (TO IMPLEMENT ENCRYPTION) WILL NOT ALLOW ACTIVATION OF THE DATABASE | |||
IT29280 | 2 | ABNORMAL SHUTDOWN OF DATABASE WHEN LOAD ENCOUNTERS SQLO_NOTAVAIL ERROR IN SQLPUPDATEGLOBALTIMEINGLFH | |||
IT28756 | 2 | DB2 11.1 MOD4 FP4 (INCLUDING IFIX 001) MIGHT HANG, CRASH OR FAI L WITH SQL0958C DUE TO EMFILE ERROR (TOO MANY OPEN FILES) ON AIX | |||
IT29750 | 2 | WHEN SSL IS USED FOR HADR COMMUNICATION DB2HADRS EDU IS SPINNING AFTER HADR GRACEFUL TAKEOVER. | |||
IT30512 | 2 | DPF INDOUBT RESOLUTION WILL ONLY RESOLVE 1 INDOUBT PER NODE REGA RDLESS OF THE NUMBER OF INDOUBTS THAT EXIST AT DATABASE START | |||
IT29447 | 2 | CRASH IN SQLPISROSIMPACTLOCK() | |||
IT29407 | 3 | AFTER HADR STANDBY IS RESTARTED, DB2PD -HADR NO LONGER REPORTS TABLESPACE IN RESTORE PENDING STATE | |||
IT27443 | 3 | HIGH MEMORY CONSUPTION WITH CDC IF BACKUPS WITH MULTIPLE SEQUENCES(TARGET LOCATIONS) | |||
IT27808 | 3 | DB2DIAG.LOG FILLED WITH SQLPSHRFINDEXTENTFORLFSLSN, PROBE:800 | |||
IT30204 | 3 | INCORRECT ERROR LEVEL MESSAGE IS WRITTEN IN DB2DIAG.LOG | |||
IT29873 | 3 | HEARTBEAT_EXPECTED ON HADR PRIMARY DOES NOT INCREASE AS EXPECTED | |||
IT29937 | 3 | DB2PD -LOGS DISPLAYS WRONG LOG FILE NAME WHEN LOG NUMBER IS GREATER THAN 9999999 | |||
IT27242 | 3 | LOGARCHMETH2 OFF NOT UPDATED ON HADR STANDBY | |||
IT27252 | 3 | NOT ABLE TO FORM HADR CONNECTION AFTER TAKEOVER WHEN PURESCALE HADR STANDBY MEMBERS ON SAME HOST HAVE THE SAME HADR_LOCAL_SVC | |||
IT27868 | 3 | IN CERTAIN SITUATION ON PURESCALE, "DIA8132C CONDITIONAL LOCK ERROR? MAY BE REPORTED AS ERROR, WHICH SHOULD BE AT WARNING LEVE | |||
IT29398 | 3 | DUMP FILE GENERATED AFTER "UNEXPECTED ISVALID() STATUS. RECOVERING." MESSAGE IN DB2DIAG.LOG | |||
IT27982 | 3 | BACKUP ON PURESCALE FAILED WITH SQL0901N (REASON "LOG FILE REGIS TRATION PENDING PREVENTING BACKUP FROM PROCEEDING") SQLSTATE=580 | |||
IT28023 | 3 | DB2DIAG.LOG GROWING VERY FAST WITH MANY MESSAGES FROM SQLPLOGALLOCCANDIDATEPOOL::REFRESH, PROBE:60 | |||
IT23318 | 3 | INCORRECT MISSING LOG FILE NUMBER IS REPORTED IN ERROR MESSAGES | |||
IT29009 | 4 | UNNECESSARY WARNING MESSAGES IN DB2DIAG.LOG ON HADR STANDBY FOR SQL2171N | |||
Fix Pack m4fp5 - Federation | |||||
IT30249 | 1 | WRONG RESULTS ARE POSSIBLE FOR FEDERATED OR COLUMNAR QUERY WITH AGGREGATION OVER DISTINCT OUTER JOIN | |||
IT30111 | 2 | SEGMENTATION VIOLATION IN __INTEL_SSSE3_REP_MEMCPY (MEMCPY) IN FENCEDDRDA_SERVER::INITIALIZE_MY_SERVER | |||
IT28205 | 2 | USER MIGHT RETRIEVE WRONG DATA FROM REMOTE ORACLE TABLES IF THE COLUMNS CONTAIN DATE TYPE AND THE DATA MIGHT BECOMES CORRECT AFT | |||
IV79788 | 2 | SMALL PRIVATE MEMORY LEAK IN DB2'S PRIVATE PERSISTENT HEAP WHEN COMPILING STATEMENTS ACCESSING COLUMNAR TABLES | |||
IT27904 | 2 | QUERY FAILS WITH SQLCODE -901 | |||
JR60168 | 2 | INSERT INTO ZDB2 THROUGH NICKNAME FAILS WITH "COLUMN <COLNAME> HAS A TYPE OF GRAPHIC WHICH IS NOT RECOGNIZED" | |||
IT28192 | 2 | DB2 TRAPS WHEN AN INSERT WITH A RECURSIVE SELECT IS RUN ON A FEDERATED SERVER | |||
IT27455 | 3 | RELAX DB2DIAG.LOG MESSAGE IN SQLSFETCHNEXTTEMPRECORD PROBE 504 | |||
Fix Pack m4fp5 - Index Manager | |||||
IT26487 | 1 | OFFLINE BACKUP MAY FAIL WITH SQL2048N WHEN PROCESSING AN MDC TABLE | |||
IT27901 | 2 | INDEX RECLAIM EXTENTS MAY HOLD ALTER TABLE LOCK INDEFINITELY WHILE PROCESSING A LOOP | |||
IT30242 | 2 | SQLIUNDOADDKEY MAY CRASH THE DATABASE IF ANOTHER TRANSACTION IS PERFORMING A SMO ON THE SAME PAGE | |||
IT25941 | 2 | INDEX KEY NOT FOUND ERROR MIGHT INCORRECTLY BE REPORTED BY THE SERVER | |||
Fix Pack m4fp5 - Install and Catalog Services | |||||
IT28440 | 1 | SECURITY: DB2 IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2019-4154) | |||
IT27920 | 1 | LOCK-WAITS/DEADLOCKS ON SYSDATATYPES CATALOG TABLE DURING MODULE DEPLOYMENT | |||
IT30341 | 1 | PERFORMANCE ISSUE DUE TO THE HIGH NUMBER OF ANCHOR LATCH CONTENTION | |||
IT27037 | 1 | SECURITY: IBM JAVA THAT DB2 BUNDLES IS AFFECTED BY MULTIPLE VULNERABILITIES (JAVA CPU JULY 2019) | |||
IT27425 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
IT27412 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
IT28444 | 2 | PROCESS KRBPLUGIN PARAMETER FROM BOTH DB2CLI.INI AND DB2DSDRIVER.CFG CONFIGURATION FILES. | |||
IT26563 | 2 | ALTER TABLE WITH ALTER COLUMN OPTION MIGHT TRAP AND CRASH THE INSTANCE WHEN AUTO_REVAL IS DISABLED. | |||
IT26146 | 2 | SECURITY: IBM SDK JAVA QUARTERLY CPU - JUL 2018 | |||
IT27267 | 2 | DB2: DROP XSROBJECT MIGHT FAIL WITH "SQLRI_DDL_COMMON: UNEXPECTED SQLCODE FOR DDL" IF SCHEMA HAS EXACTLY 100 DOCUMENTS | |||
IT29646 | 2 | 'ALTER TABLE ALTER COLUMN SET DATA TYPE' MAY CRASH THE INSTANCE | |||
IT28882 | 2 | LARGE VOLUME OF SQLKD_INTERRUPT ERRORS FROM SQLRLCATALOGSCAN::OPEN FUNCTION GENERATED IN DB2DIAG.LOG | |||
IT29021 | 2 | DB2 TRAPS IN SQLRL_GET_FULL_NAME() | |||
IT26112 | 2 | DB2PREREQCHECK CHECKING INSUFFICIENT SNWLLIBC LEVEL | |||
IT27494 | 2 | ENGINE CRASH IN SQLDINVCURSORPOS | |||
IT29803 | 2 | DB2PREREQCHECK FOR PURESCALE MIGHT CRASH WITH SEGMENTATION FAULT (SEGV) IN "VALIDATING TIE-BREAKER DISK INFO" SECTION. | |||
IT27228 | 2 | DB2 WINDOWS INSTALLATION CRASHES IF THE INSTALLING USER BELONGS TO A LARGE NUMBER OF LOCAL/GLOBAL GROUPS. | |||
IT29948 | 2 | TRAP / SIGSEGV OCCURS WHEN DROPPING A TABLE (OR INDEX OF A TABLE) AND A LARGE STATISTICS PROFILE EXISTS | |||
IT30122 | 3 | INSTALLFIXPACK DELETES /ETC/SYSTEMD/SYSTEM/DB2FMCD.SERVICE FILE ON LINUX | |||
IT29494 | 3 | CUSTOM JAR FILES UNDER ~/SQLLIB/FUNCTION/JAR NOT COPIED TO NEW VERSION AFTER UPGRADING | |||
Fix Pack m4fp5 - Monitoring | |||||
IT26760 | 2 | ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL0668N WHEN RETRYING COPY OPERATION ON COLUMNAR TARGET TABLE | |||
IT27078 | 2 | MEMORY ALLOCATED BY A MONITOR FUNCTION ON STANDBY MIGHT NOT BE FREED UP AND MIGHT LEAK AFTER DATABASE IS DEACTIVATED/TAKEOVER | |||
IT15107 | 2 | DB2CONVERT FAILS WITH SQL0802N WHEN TABLE HAS MORE THAN 2147483647 ROWS | |||
IT30178 | 2 | POTENTIAL HANG WAITING ON TRANENTRY LATCH IN SQLPM_WRITE_APPL_LOCKS DURING LOCK SNAPSHOT | |||
IT27809 | 3 | DB2 LOCK EVENT MONITOR REPORT: LOCK MODE HELD IS NONE IN PURESCALE | |||
Fix Pack m4fp5 - Parsing and SQL PL | |||||
IT30156 | 1 | SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR UPDATE ALERT CFG (CVE-2019-4524) | |||
Fix Pack m4fp5 - Platform Specific | |||||
IT30431 | 1 | SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION (CVE-2019-4587) | |||
IT28414 | 1 | DB2 MIGHT CRASH IN SQLOFMBLKEX->SQLO_MEM_POOL::MEMTREEPUT WITH "CORRUPT POOL FREE TREE NODE" ERROR MESSAGE IN DB2DIAG.LOG | |||
IT29415 | 1 | SCALAR FUNCTION HASH8 MAY RETURN DIFFERENT RESULTS FOR THE SAME INPUT ON POWER(TM) LITTLE ENDIAN SYSTEMS | |||
IT27152 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION (CVE-2018-1936) | |||
IT28248 | 2 | CLEANING UP OF EDU CAUSES PRIVATE MEMORY TO LEAK (WINDOWS PLATFORM ONLY) | |||
IT25066 | 2 | SLOW MEMORY ALLOCATIONS OR POSSIBLE SEVERE DEGRADATION DURING OOM HANDLING DUE TO COALESCE MEMORY CHECK | |||
IT22487 | 2 | GETDB2VERSIONCODE FAILS WITH ECF_BUFFER_TOO_SMALL | |||
IT25493 | 2 | DB2 STANDBY CRASH ON SQLOGETMEMPOOLSTATSUNLATCHED WHEN DB2_HADR_ROS IS ENABLED | |||
IT28412 | 2 | DB2 FAILS ON SOME AVX-512 CAPABLE CPUS | |||
IT28543 | 2 | START HADR HANG AFTER UPGRADE TO V11.1.4.4 | |||
IT30978 | 2 | MULTIPLE CLP FRONTENDS ISSUED FROM DIFFERENT SHELL SCRIPTS USES THE SAME BACKEND AGENT, CAUSING UNEXPECTED RESULTS OR ERRORS. | |||
IT28103 | 3 | STMM REPORTS SEVERE ERRORS ABOUT STMMSIMULATESORTMERGE IN DB2DIAG.LOG | |||
IT27198 | 3 | DB2START CREATES A SEVERE MESSAGE IN DB2DIAG.LOG FOR INSTANCE ALREADY RUNNING ON WINDOWS | |||
IT26730 | 3 | DB2SET -G DB2INSTDEF SHOULD FAIL WITH DIFFERENT ERROR | |||
IT30202 | 3 | ERRORNEOUS ERROR HANDLING IN SQLOLOOKUPGROUPINFOFORUSER | |||
IT27816 | 3 | NO DIGNOSTIC DATA IS DUMPED WHEN STATUS_STACK_BUFFER_OVERRUN(I.E. 0XC0000409) HAPPENED ON WINDOWS | |||
IT25628 | 3 | WIN32 ONLY: DB2LEVEL GIVES SQL1022C IF INSTANCE NAME IS LONGER THAN 7 BYTES. | |||
IT29813 | 4 | "SQLBGETVICTIMFROMPAGEHATELIST" WARNING MESSAGES APPEAR IN THE DB2DIAG.LOG | |||
Fix Pack m4fp5 - Problem Determination | |||||
IT28255 | 1 | SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE (CVE-2019-4101) | |||
IT29115 | 1 | SECURITY: DB2 AFFECTED BY BUFFER OVERFLOW VULNERABILITIES (CVE-2019-4322) | |||
IT29836 | 2 | DB2SUPPORT MIGHT REQUIRE A LONG TIME TO COMPLETE ON AIX SYSTEM WITH A LARGE NUMBER OF LOGICAL VOLUMES AND VOLUME GROUPS. | |||
IT29582 | 2 | DB2DART SHOULD DETECT WHEN A CONTAINER SIZE IS LESS THAN THE SIZE OF THE TOTALPGS+PAGESIZE. | |||
IT26667 | 2 | DB2DIAG -F MAY ABNORMAL FAIL IN SEGMENTATION FAULT | |||
IT25656 | 2 | DB2DIAG INCORRECT FORMATTING | |||
IT30313 | 2 | TRAP IN PDDIAGLOGGETEVENTFIELD WHEN USING PD_GET_DIAG_HIST | |||
IT29127 | 2 | DB2DART DETECTS ERRORS AFTER UPGRADING TO V11.1FP4 | |||
IT27084 | 3 | DB2DIAG -F MIGHT FAIL WITH SEGV IN PDDIAGGETDIAGFILES ON PURESCALE | |||
IT25390 | 3 | DB2 INSPECT MIGHT INCORRECTLY REPORT OUT OF RANGE ERRORS FOR BLU TABLES | |||
IT22978 | 3 | DB2PD HANG | |||
Fix Pack m4fp5 - Process Model | |||||
IT28616 | 2 | PURESCALE - MON_GET_PKG_CACHE_STMT CAUSES SEVERAL SQLESUBREQUEST ROUTER AND SQLKDRECEIVEDATA PROBES MESSAGES IN DB2DIAG.LOG. | |||
IT29015 | 2 | WHEN USING DB2CFIMP, IF THE DB2CFEXP OUTPUT BEING IMPORTED HAS TWO DSN WITH SAME NAME, THE 2ND DOES NOT GET PROCESSED/IMPORTED | |||
IT27009 | 2 | INSTANCE CRASH DURING'a0EVALUATION OF WLM'a0THRESHOLD'a0SQLROWSREAD | |||
IT29539 | 2 | CREATING DATABASE ON DB2 HIGHER CLIENT TO DB2 LOWER SERVER CAN FAIL WITH SQL0001N | |||
IT29660 | 2 | DB2STOP FAILS WITH SQL6037N, LEAVING [DB2SYSC]<DEFUNCT>. | |||
IT29468 | 2 | DB2LOGGP CAN TRAP WITH SIGNAL #11 IN A FEDERATED ENVIRONMENT | |||
IT19279 | 2 | SYSIBMADM.ENV_SYS_INFO RUNS SLOWER IN DB2 V10.5 BY 1 SECOND | |||
IT26326 | 2 | INTRA_PARALLEL QUERY MIGHT FAIL WITH SQL6040C FCM OUT OF BUFFER | |||
IT30358 | 3 | APPLICATION CONNECTIONS / NO CONNECTIONS ARE FORCED OFF INSTEAD OF A SPECIFIC LOW PRIORITY LOCK HOLDING SYSTEM APPLICATION | |||
IT27292 | 3 | DBM CFG PARAMETER ASLHEAPSZ DEPENDS ON RULE "QUERY_HEAP_SZ >= ASLHEAPSZ" | |||
IJ01118 | 3 | DYNAMIC UPDATE TO MON_HEAP_SZ MULTIPLIES THE MEMORY POOL SIZE ADJUSTMENT BY ADDITIONAL 4K | |||
IT27971 | 3 | DB2DIAG.LOG IS FILLING UP WITH A WARNING MESSAGE "SQEWLMACTIVITYPLANHASHTABLE::PRUNEOLDENTRIES" | |||
Fix Pack m4fp5 - Query Compiler Optimizer | |||||
IT26586 | 1 | DB2 MAY ABEND WHILE COMPILING A QUERY THAT MAY PRODUCE A STAR SCHEMA JOIN | |||
IT30256 | 2 | SQL0901N MAY BE RETURNED FOR QUERIES WITH UNION REFERENCING NODENUMBER/DBPARTITIONNUM FUNCTIONS | |||
IT25572 | 2 | UPGRADE FROM 10.1 FP5 TO 11.1 MAY CRASH ENGINE DURING DATABASE ACTIVATION | |||
IT23228 | 2 | QUERY USING STATISTICAL VIEW CONTAINING COLUMN GROUP STATISTICS MAY CAUSE SQL0901N | |||
Fix Pack m4fp5 - Query Compiler QGM | |||||
IT26936 | 1 | [COE_TIM]DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING AGGREGATE DISTINCT ON COLUMNIZED TABLES | |||
IT29425 | 1 | SECURITY: CERTAIN DB2 COMMANDS MAY LEAD TO INFORMATION DISCLOSUR E WHEN AUTO_REVAL IS SET TO DEFERRED_FORCE (CVE-2019-4438) | |||
IT29537 | 2 | CREATE GLOBAL TEMPORARY TABLE IS IGNORING THE GROUP PRIVILEGES | |||
IT27763 | 2 | SUBOPTIMAL PERFORMANCE WITH QUERIES CONTAINING OUTER JOINS AND OLAP FUNCTIONS | |||
IT27875 | 2 | DB2 MAY COPY SELECTIVITY WHEN A SELECTIVITY CLAUSE IS USED ON A PREDICATE THAT'S COLUMN EQUIVALENT (C1=C2 AND C1=C3) | |||
IT29981 | 2 | DB2 MAY RETURN INCORRECT RESULTS WHEN EXECUTING IUD STATEMENTS CONTAINING A SUBQUERY WITH CORRELATION AND AGGREGATION | |||
IT29099 | 2 | DB2 MAY RETURN INCORRECT RESULT WHEN EXECUTING QUERY WITH UNION VIEW INCLUDE MULTIPLE TABLES | |||
IT28286 | 2 | POSSIBLE PERFORMACE REGRESSION FOR SELECT DISTINCT SUB-QUERY WHEN MIGRATING TO DB2 V11.1.3 | |||
IT28739 | 2 | WRONG RESULTS MIGHT BE OBSERVED WHEN RUNNING QUERIES WITH OUTER JOINS AND GROUP BY OPERATIONS | |||
IT28831 | 2 | UPDATE STATEMENT WITH CORRELATED SCALAR SUBQUERY FAILS WITH SQLCODE -407 | |||
IT28782 | 2 | ALTER TABLE DROP CONSTRAINT DOES NOT INVALIDATE THE DEPENDENT PACKAGE AND CAUSES WRONG RESULTS TO BE RETURNED | |||
IT30466 | 2 | DB2 MAY PRODUCE INCORRECT RESULTS WHEN EXECUTING QUERIES CONTAINING JOINS WITH DIFFERING FLOATING-POINT PRECISIONS | |||
IT26298 | 2 | SQL SCALAR FUNCTION DECLARED WITH BEGIN ATOMIC AND CONSISTING OF A SINGLE RETURN STATEMENT MAY PRODUCE WRONG RESULTS | |||
IT30001 | 2 | DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING EXTERNAL ACTIONS AND CORRELATION | |||
Fix Pack m4fp5 - Relational Data Services | |||||
IT27829 | 1 | HIGH NUMBER OF SQL VARIATIONS & ANCHOR_COMMON LATCH WAITS CAUSING CPU SPIKE | |||
IT27842 | 2 | A STALE SQLCA POINTER FROM SQLZESQLCODE() CORRUPTS THE STACK FRAME LEADING TO AN ENDLESS LOOP | |||
IJ15638 | 2 | SECOND EXECUTION OF A CACHED CDE QUERY IN DPF ENVIRONMENT MIGHT LEAD TO SEGV (FODC TRAP) OR FODC MEMORY FOR ILLEGAL REQUEST SIZE | |||
IT26866 | 2 | DEADLOCK WAS OCCURRED IN SYSPLANLOCK IN PURESCALE | |||
IT26909 | 2 | ENCOUNTERED DEADLOCK IN DB2ABP. | |||
IT27729 | 2 | SQL0901 SQLRL_USERTEMPIUD: TID/FID NOT FOUND | |||
IT27263 | 2 | FAILED REORG CAN BE SHOWED IN THE LIST HISTORY WITHOUT ERROR | |||
IT28200 | 2 | SEGV OR SQL0901N (UNKNOWN DYNAMICRULES) MAY BE RETURNED DURING A PREPARE OR A SQL1803N MAY BE RETURNED DURING A BIND OR REBIND | |||
IT30771 | 2 | TRAP AFTER SECTION INITIALIZATION FAILED. REGRESSION INTRODUCED IN V105FP10 AND V111M4FP4 | |||
IT28809 | 2 | DB2 ACTIVITIES EVENT MONITOR MIGHT REPORT INCORRECT METRICS IN ACTIVITIES TABLE FOR BATCHED STATEMENTS | |||
IT29242 | 2 | PERFORMANCE MAY BE AFFECTED BY DYNAMIC SQL CACHE NON REUSE | |||
IT27088 | 2 | SET GLOBAL VARIABLE MAY REPORT ERROR. | |||
IT29255 | 2 | LATCH CONTENTION IN ROUTINE ADDORUPDATEACTIVITYENTRY | |||
IT27701 | 2 | SQL0901 USERTEMP ENV DOESN'T MATCH CURRENT APP | |||
IT30381 | 3 | CHANGE APM PERFORMANCE SETTINGS WILL CAUSE "SEVERE" MESSAGE IN DB2DAIG.LOG | |||
IT26999 | 3 | RELAX OF DIAGLEVEL OF SQLRR_RDS_COMMON_POST, PROBE:870 | |||
Fix Pack m4fp5 - Replication | |||||
IT27367 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
IT27421 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
Fix Pack m4fp5 - Routine Infrastructure | |||||
IT27993 | 1 | DPF INSTANCE MAY CRASH DUE TO MEMORY CORRUPTION WHEN CALLING STORED PROCEDURE. | |||
IT27203 | 1 | SECURITY: PRIVILEGE ESCALATION DURING ROUTINE EXECUTION IN FENCED MODE (CVE-2019-4057) | |||
Fix Pack m4fp5 - Security | |||||
IT25046 | 3 | RESTORE WITH "SHOW MASTER KEY DETAILS" DID NOT SHOW ALL THE KEY LABEL | |||
IT28712 | 3 | EXCESSIVE NUMBER OF LDAP AUTHENTICATION REQUEST FOR SINGLE USER CAUSED BY GROUP-WDIE AUTHENTICATION LOOKUP | |||
IT29181 | 3 | DPF PHYSICAL PARTITIONED CONFIGURED ENABLED FOR ONLY SSL DB2COMM, CONNECT TO REMOTE NODE FAILS WITH SQL1468N | |||
IT27152 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION (CVE-2018-1936) | |||
IT27203 | 1 | SECURITY: PRIVILEGE ESCALATION DURING ROUTINE EXECUTION IN FENCED MODE (CVE-2019-4057) | |||
IT27328 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION (CVE-2019-4014) | |||
Fix Pack m4fp5 - XML | |||||
IT29876 | 2 | DB2 MIGHT CRASH WITH SQLRICLS_COMPLEX -> XMLRNHASHTABLE::DEALLOCATE() ON THE STACK PROCESSING XML QUERY | |||
IT29758 | 2 | INCORRECT DATA MAY BE INSERTED IN XML COLUMNS | |||
IT26337 | 3 | DB2 MAY THROW A SQL0901N 'XML STATS SANITY CHECK FAILED' ERROR DURING A AUTO RUNSTATS ON A XML TABLE | |||
Fix Pack m4fp5 - pureScale Services | |||||
IT30142 | 1 | SECURITY: DB2 AFFECTED BY BUFFER OVERFLOW VULNERABILITIES (CVE-2019-4584) | |||
IT29259 | 2 | ENDLESS ITERATION OF DB2 CLEANUP AND KILL PROCESSES MAKE DB2 PURESCALE CLUSTER HANG | |||
IT29277 | 2 | IN PURESCALE, WHILE USING I/O DRAWER, DB2 MEMBER MAY GO DOWN WHEN THERE IS A PROBLEM WITH A ROCE PORT | |||
IT28069 | 2 | HANG OR ERROR DURING DB2CLUSTER -VERIFY COMMAND WITHOUT REMOTE ROOT LOGIN AND PASSWORDLESS SSH | |||
IT29225 | 2 | HADR CANNOT BE STARTED DUE TO INSUFFICIENT HADR DATABASE RESOURCE VALIDATION | |||
IT29188 | 2 | THE "DB2CLUSTER -CM -ENTER -MAINTENANCE -ALL" COMMAND MAY FAIL IF LANG IS NOT SET TO ENGLISH | |||
IT29276 | 2 | CF MEMORY TUNER MAY NOT BE ABLE TO ADJUST MEMORY IN CERTAIN SITUATIONS | |||
IT26370 | 2 | IN A DB2 PURESCALE CLUSTER CONTAINING 8 OR MORE MEMBERS, APPLICATIONS MAY INDEFINITELY HANG IN LOCK-WAIT STATUS. | |||
IT27963 | 2 | DB2CLUSTER SEGFAULT CAUSED BY WRONG ARGUMENTS TO PD_HEXDUMP WHEN RUNNING INSTALLFIXPACK ON PURESCALE | |||
IT28750 | 2 | THE "DB2CLUSTER -CM -ENTER -MAINTENANCE -ALL" COMMAND MAY FAIL | |||
IT28804 | 2 | UPON A REBOOT, IF THE RSCT DOMAIN TAKES LONGER TO COME ONLINE, THE SPECTRUM SCALE CLUSTER MAY NOT START SUCCESSFULLY | |||
IT27298 | 2 | ON PURESCALE SYSTEMS WITH A LARGE NUMBER OF MEMBERS OR FILESYSTEMS, DB2CLUSTER -CFS -ENTER -MAINTENANCE -ALL MAY HANG | |||
IT29443 | 2 | DB2INSTANCE -LIST COMMAND FAILS AFTER ROCE ADAPTER FAILURE | |||
IT29768 | 2 | DB2 PURESCALE MEMBER MAY HIT FODC_PANIC DUE TO XI FAILURES IN RU SCENARIO. | |||
IT27690 | 2 | "DB2CLUSTER -CM -ENTER -MAINTENANCE -ALL" FAILS AS IT CANNOT VERIFY IF MOUNTS ARE IN MAINTENANCE ON REMOTE HOSTS | |||
IT26159 | 3 | 'DB2INSTANCE -INSTANCE DB2INST2 -LIST' RUN AS ROOT REPORTS ERROR " LIBSQLHA: SQLHAGETOBJECTATTRIBUTE()" | |||
IT28506 | 3 | IN DB2 V11.1.4.4, A SEGMENTATION FAULT (CORE DUMPED) CAN OCCUR WHEN RUNNING DB2HAICU WITH AN XML INPUT FILE. | |||
IJ11280 | 3 | DB2CLUSTER -CFS -COMMIT PRINTS INCORRECT GPFS VERSION. | |||
IT29232 | 3 | EXTRANEOUS CODE IN THE MOUNTV111_STOP.KSH SCRIPT | |||
IT27015 | 3 | WITH A ROTATING DB2 DIAGNOSTIC LOG, CERTAIN MESSAGES FROM THE DB2HAVEND PROCESS WILL BE LOGGED TO THE DEFAULT DB2DIAG.LOG FILE | |||
IJ13295 | 3 | THE DB2START COMMAND MAY FAIL WITH SQLCODE SQL1345N IN AN AUTOMATED HADR ENVIRONMENT | |||
IT28938 | 3 | DB2AUTOSTART DOES NOT WORK ON REBOOT WHEN OS REBOOT IS VERY FAST. | |||
IT29435 | 3 | CA-SERVER PROCESS TAKES LONGER THAN EXPECTED TO BE KILLED DURING DB2STOP |
DB2 Version 11.1 Fix Pack m4if1 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
Fix Pack m4if1 - Administration Server | |||||
IT27210 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
Fix Pack m4if1 - 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 m4if1 - 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 m4if1 - Codegen and Runtime | |||||
IT26992 | 2 | DETERMINISTIC UDF CAN CAUSE INSTANCE TO TRAP | |||
Fix Pack m4if1 - 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 m4if1 - 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 m4if1 - 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 m4if1 - JCC | |||||
IT27728 | 2 | V11.1M4FP4 JDBC DRIVER (4.25) DOES WORK WITH JAVA8 BUT NOT WITH JAVA6 | |||
Fix Pack m4if1 - Platform Specific | |||||
IT27361 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
Fix Pack m4if1 - 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 m4if1 - 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 m4if1 - Query Compiler Optimizer | |||||
IT27331 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
Fix Pack m4if1 - 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 m4if1 - 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 m4if1 - Replication | |||||
IT27318 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
Fix Pack m4if1 - 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 | |||
DT172081 | 1 | MON_GET_LATCH table function can trap while getting latches | |||
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 - JCC | |||||
IT30258 | 3 | JDBC ERROR "UNRECOGNIZED JDBC TYPE:-15 ERRORCODE=-4228,SQLSTATE=NULL " | |||
IT29782 | 2 | SQLCODE -514 USING IBM DATA SERVER DRIVER FOR JDBC WITH XA AGAINST Z/OS V12 | |||
IT29994 | 2 | DB2STOP MEMBER CAUSED JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION | |||
IT28261 | 3 | JAVA.LANG.CLASSCASTEXCEPTION DURING EXECUTEBATCH() WITH SQLJAVOIDTIMESTAMPCONVERSION | |||
IT28512 | 3 | DB2 JCC DRIVER HANGS WHILE EXECUTING SQLS WHICH HAS CURLY BRACES. | |||
IT28573 | 3 | XML INSERT DUPLICATES VALUE IN DB2 LUW | |||
IT28262 | 3 | JCC DRIVER THROWS ERROR CODE SQLCODE=-514 DURING FAILOVER AGAINST DB2 ZOS V12 SYSPLEX MEMBER WITH KEEPDYNAMIC(ON) | |||
IT28263 | 3 | DB2CONNECTACTIVATE -CHECKEXISTING THROWS AN ERROR:EXCEPTION IN THREAD "MAIN" JAVA.LANG.NULLPOINTEREXCEPTION WHILE CONNECTING V12R1M501 OR HIGHER | |||
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'a0 | |||
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'a0VULNERABILITIES IN'a0OPENSOURCE 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 |
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"OTHER - Uncategorised","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
03 November 2022
UID
swg21995889