Troubleshooting
Problem
Db2 11.5 Known Issue Fix list contains list of Known Issues shipped for each Mod Pack, Fix Pack in Db2 Version 11.5 for Linux, UNIX and Windows products. The Severity column value of 1 is high and 4 is low. Severity column represents the severity of the Case at the time the Known Issue was opened.
Resolving The Problem
Tab navigation
************************************************************
Product Name : DB2 UDB Version 11.5
Updated : Nov 15, 2023
************************************************************
Select a Fix Pack: m9fp0 | m8fp0 | m7fp0 | m6fp0 | m5fp1 | m5fp0 | m4fp0 | m3fp0 | m2fp0 | m3fp0
DB2 Version 11.5 Fix Pack m9fp0 | |||||
---|---|---|---|---|---|
Known Issue | Symptom | Abstract | |||
DT148867 | Incorrect Output (IN) | IT42001: DB2ADUTLUPLOAD MAY WRONGLY UPDATE A HISTFILE ENTRY THAT CORRESPONDS TO A BACKUP SEQUENCE THAT FAILS TO BE UPLOADED | |||
DT161058 | Abnormal End Of The Program (AB) | TRAP IN FUNCTION SQLPDOUPDATELSNVALUESINXHDRS WHEN WRITING A LOGRECORD | |||
DT173258 | Abnormal End Of The Program (AB) | LOGICAL_RESTORE fails with "Unable to find the metadata file info.json for" error when restoring single schema out of multi-schema backup image. | |||
DT179023 | Incorrect Output (IN) | It is not possible to upload images/logs using db2adutl when the attached database partition number is different than the one used in DBPARTITIONNUM | |||
DT195969 | New Function (NF) | LBAR - Fixing the Problem with CREATE EXTERNAL REMOTESOURCE | |||
DT196027 | New Function (NF) | LBAR - Fixing the Problem with Wrong Order of Restoring Dependent Views | |||
DT209085 | Integrity Problems (IG) | LOGICAL_RESTORE - Ignore RCAC Options if No RCAC Tables Present in Backup Image and in Restore Set | |||
DT212931 | Integrity Problems (IG) | INDOUBT TRANSACTIONS NOT RESOLVED AUTOMATICALLY | |||
DT222096 | Coded Halt (HL) | LOGICAL_RESTORE fails when replaying schema DDL statements with syntax errors | |||
DT228165 | Coded Wait (WS) | ROLLFORWARD COMMAND MAY HANG WITH LOW DBHEAP MEMORY | |||
DT237799 | Abnormal End Of The Program (AB) | ROLLFORWARD OF DATABASE RESTORED FROM SNAPSHOT BACKUP MAY FAIL WITH AN UNEXPECTED CONDITION | |||
DT149261 | Coded Halt (HL) | IT42027: PURESCALE MEMBER RESTART HANG DUE TO CIRCULAR DEPENDENCY WITH BACKUP EXECUTING ON A DIFFERENT MEMBER | |||
DT149262 | Incorrect Output (IN) | IT42041: HANG DURING CRASH RECOVERY WAITING FOR LOG ARCHIVE WITH MIRRORLOGPATH AND BLK_LOG_DSK_FUL ENABLED | |||
DT196637 | Integrity Problems (IG) | LOGICAL_RESTORE fails on image check due to unexpected file | |||
DT211715 | Incorrect Output (IN) | Ignore non Critical Errors During Logical_Restore | |||
DT212779 | Additional Information (AI) | Audit records failures to access RCAC table data originating from LOGICAL BACKUP when it is not run | |||
DT213313 | Performance (PR) | Slow performance during database recovery when replaying TRUNCATE TABLE or CREATE/ALTER TABLE NOT LOGGED INITIALLY | |||
DT224265 | Integrity Problems (IG) | When running an online backup with EXCLUDE LOGS option and with DB2_DISABLE_FLUSH_LOG setting enabled, backup gets completed successfully but db2diag.log shows "DIA8414C Logging can not continue due to an error" message. | |||
DT173699 | Abnormal End Of The Program (AB) | SQL1797N with "Directory not empty" errors when calling LOGICAL_RESTORE or LOGICAL_BACKUP_DETAILS | |||
DT189208 | Incorrect Output (IN) | -902 reported by LOGICAL_BACKUP or LOGICAL_RESTORE when provided incorrect cloud URL | |||
DT197487 | New Function (NF) | Using ET or LBAR with an unrecognized production IBM Cloud Object Storage endpoint results in SQL20569N | |||
DT208663 | Integrity Problems (IG) | Remove temporary directories and files as part of LOGICAL_RESTORE cleanup | |||
DT209692 | Abnormal End Of The Program (AB) | DATABASE OUTAGE DUE TO LACK OF LOG SPACE WHEN DB2_CDE _DCC ENABLED | |||
DT212699 | Coded Halt (HL) | SYSPROC.SYSINSTALLOBJECTS('LBAR', 'M' ...) stored procedure unable to migrate IIAS restore history tables | |||
DT215662 | Incorrect Output (IN) | Online BACKUP of SMS table space can fail with deadlock due to concurrent LOAD operation | |||
DT225192 | Incorrect Output (IN) | Unsetting OVERFLOWLOGPATH does not disable OVERFLOWLOGPATH after next activation | |||
DT148514 | Abnormal End Of The Program (AB) | OUT OF LOG SPACE DURING COMMIT OR ROLLBACK WHEN REPLICATION IS ENABLED | |||
DT173106 | Incorrect Output (IN) | Error message from db2logts EDU | |||
DT179518 | Incorrect Output (IN) | Db2diag.log is flooded with message from "sqlpLLMUpdateLockWithGLMResponse, probe:3090" | |||
DT189209 | New Function (NF) | LBAR: Allow -drop-existing with -keep-rcac for LOGICAL_RESTORE and Fixing -keep-rcac and -replace-rcac Pre-checks | |||
DT208660 | Loop (LP) | Hang in LOGICAL_RESTORE Python Script When Restoring from DPF to SMP | |||
DT208662 | Abnormal End Of The Program (AB) | LOGICAL_RESTORE fails to restore INC/DEL backup image | |||
DT208667 | Incorrect Output (IN) | ADMIN_DROP_SCHEMA or LOGICAL_RESTORE fail when RCAC tables exist in schema | |||
DT214627 | Incorrect Output (IN) | LOGICAL_BACKUP (Schema-Level Backup) Produces Corrupted Backup Image If There are RCAC Tables in the Schema | |||
DT238513 | Unpredictable (UN) | Security: Db2 is affected by vulnerabilities in compression routines (zlib) | |||
DT148686 | Abnormal End Of The Program (AB) | IT41856: TRAP/ERROR READING FROM LOG FILES WITH ALSM ENABLED | |||
DT170181 | New Function (NF) | Fixes to productize Logical Backup in Db2 11.5.8 | |||
DT188273 | Incorrect Output (IN) | SYSIBMADM.PRIVILEGES missing SCHEMARCAC privilege | |||
DT209817 | Abnormal End Of The Program (AB) | DATABASE OUTAGE AFTER CRASH RECOVERY when using columnal table with intra-parallelism. | |||
DT237077 | Integrity Problems (IG) | Table space not set to ROLLFORWARD PENDING state when it was not accessible during crash recovery | |||
DT237938 | Abnormal End Of The Program (AB) | logical_backup stored procedure with -tsm option fails with SQL1797N | |||
DT130507 | Errors when attempting to use UTL_DIR functions | ||||
DT169944 | Abnormal End Of The Program (AB) | Assertion Failure "nextTSNOnPage == currTSN". Additional info: Page next TSN inconsistent with table next TSN | |||
DT236724 | Incorrect Output (IN) | SQL0901N 'numCurrentHWMs <= numCachedHWMs' in a query that runs concurrent to insert/update activity | |||
DT188759 | Incorrect Output (IN) | SQL0901N unexpected error in InListEvaluator.cpp | |||
DT188951 | Incorrect Output (IN) | SQL0901N in JoinSpillInfo::resetPartInfoForRepart() with Keys mis-match before and after repartitioning | |||
DT211633 | Abnormal End Of The Program (AB) | Very rare risk of possible memory corruption in Columnar Join plans | |||
DT188654 | Abnormal End Of The Program (AB) | Protective logic against a possible trap CDE | |||
DT215592 | Abnormal End Of The Program (AB) | TRAP UNDER ibm_cde::query::SortInfo::getPublishingWork | |||
DT220310 | Incorrect Output (IN) | Incorrect Results when columnar tables JOIN predicate involves SUBSTR on CODEUNITS32 CHAR columns | |||
DT227816 | Incorrect Output (IN) | Db2 is missing rows inserted into table using QRep | |||
DT160159 | Unpredictable (UN) | Incorrect padding during conversion from char(8) to char(12) when using CCSID 1047 | |||
DT168620 | Performance (PR) | Excessive storage consumption due to Reorg Table Reclaim Extents not cleaning up extents properly after Trickle Feed Insert is disabled | |||
DT223178 | Abnormal End Of The Program (AB) | Rare memory corruption when HSJN is done in Columnar logic on Columnar Tables. | |||
DT228229 | Abnormal End Of The Program (AB) | Db2 takes long time to dump diagnostics to the first occurrence data capture (FODC) directory | |||
DT238478 | Abnormal End Of The Program (AB) | CDE Query fails with SQL0901N AssertionFailedException Thrown at Scheduler.cpp : 7525 | |||
DT171809 | Abnormal End Of The Program (AB) | Insert query crashes Db2 with RTABLE is ON | |||
DT180543 | Incorrect Output (IN) | SQL0901N - Reason "unexpected error at MinMaxPartialEvaluator.cpp:68" | |||
DT195966 | Abnormal End Of The Program (AB) | Insert statement hits FODC_Trap in SavepointResources::refreshNextTSNsToSplitAtSavepointOpen function | |||
DT215090 | Abnormal End Of The Program (AB) | Extra diagnostics to diagnose rare traps in Columnar HSJN that have CHTExtraPayloadPage in stack. | |||
DT215391 | Abnormal End Of The Program (AB) | Columnar Aggregation taking excessive amounts of memory | |||
DT223133 | Incorrect Output (IN) | Query might fail with -901 - Reason "unexpected error at TableQueueEvaluator.cpp:1096". | |||
DT236913 | Loop (LP) | A SELECT STATEMENT WITH CSE MAY HANG | |||
DT179633 | Abnormal End Of The Program (AB) | Invalid file handle error returned by SQLDriverConnect/W() API on windows platform causing engine abort | |||
DT221878 | Incorrect Output (IN) | IBM Database Add-Ins may not install if Build Tools for Visual Studio 2017 are present on the system. | |||
DT168942 | Incorrect Output (IN) | JCC driver returns ERRORCODE=-4499 where a seamless failover is expected | |||
DT196884 | Incorrect Output (IN) | Signals could get delivered to CLI sub threads which are meant to be delivered to CLI main thread | |||
DT208149 | Incorrect Output (IN) | DECIMAL_OLEDB to DECFLOAT conversion fails for value zero . | |||
DT174264 | Incorrect Output (IN) | odbc_cli driver package does not accept precision greater than 31 for decimal types while connecting to IBM i | |||
DT173390 | Abnormal End Of The Program (AB) | Null Pointer Exception during HADR failover | |||
DT197561 | Abnormal End Of The Program (AB) | AccessViolationException in db2app64.dll (Db2 .NET Provider native code) while invoking a StoredProcedure from Db2 .NET driver | |||
DT239599 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service when a specially crafted request is used via CLI (CVE-2023-45178) | |||
DT188190 | Unpredictable (UN) | Allow users with SCHEMAADM authority to create tables without having CREATETAB | |||
DT188650 | Incorrect Output (IN) | RCAC dependencies can cause database fixpack updates to fail with SQL0478N | |||
DT208717 | Incorrect Output (IN) | Routines and triggers do not get revalidated by SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS for objects with a schema length below 4 characters. | |||
DT214526 | Abnormal End Of The Program (AB) | High number of locked objects and lock waits on CatCacheLock - on table SYSIBM.SYSUSERAUTH | |||
DT145029 | Abnormal End Of The Program (AB) | db2look got SQL0206N when upgrading from Db2 11.5.4 to 11.5.6 or above without db2updv115 | |||
DT169621 | Incorrect Output (IN) | Stored Procedure definitions missing the PARAMETER MODE (IN/OUT/INOUT) | |||
DT180107 | Abnormal End Of The Program (AB) | Index(es) found in PD which are not found in SYSIBM.SYSINDEXES | |||
DT180628 | Unpredictable (UN) | Upgrade event monitor target tables fails with SQL0443 - SQL0444 | |||
DT189676 | Abnormal End Of The Program (AB) | Column-organized table may be locked in drop restrict state, preventing drop table from succeeding | |||
DT208817 | Incorrect Output (IN) | db2updv115 returned SQLCODE -104 error for drop statement | |||
DT209762 | Incorrect Output (IN) | TOTALDBPARTITIONCONNECTIONS into TOTALMEMBERCONNECTIONS in db2look | |||
DT211422 | Incorrect Output (IN) | Generate error message for DB2look when the wrong option is specified with -ct | |||
DT212546 | Incorrect Output (IN) | Binding from an 11.5 client to a down-level server can fail with an SQL0104N error. | |||
DT237745 | Coded Halt (HL) | db2look encounters SQL0804N in 11.5.8.0 | |||
DT171921 | Incorrect Output (IN) | FODC error during drop table - inconsistency between syscat.indexes and sysibmts.tsindexes | |||
DT172372 | Incorrect Output (IN) | Make Alter Table block correctly for the In clause and Long In clause condition | |||
DT221822 | Abnormal End Of The Program (AB) | Allowing the user to receive ownership of a function with a sequence alias as a dependent object | |||
DT168528 | Coded Message (MS) | Changing "sqeLocalDatabase::AutoBind, probe:20963" from "LEVEL: Warning" to "LEVEL: Error" | |||
DT223909 | Incorrect Output (IN) | CLP removes new line characters if there are a simple comment between bracketed comments and CREATE PROCEDURE statement | |||
DT178648 | Incorrect Output (IN) | Allow db2cli refreshldap to work on installed Db2 clients not just Drivers | |||
DT180609 | Incorrect Output (IN) | SQLCODE -902 can be returned when a client reads larger LOB data using application compile with AIX 32-bit library | |||
DT221927 | Incorrect Output (IN) | Missing column or index name in some explain diagnostic messages | |||
DT236621 | Incorrect Output (IN) | More than 350 EINVAL (22) "Invalid argument" LEVEL: Error (OS)[] errors is returned when you pipe the output of a DB2 command to the head operating system command | |||
DT173536 | Abnormal End Of The Program (AB) | Running zload on a file bigger than 2GB fails with SQL2731N Error while reading from input data file | |||
DT179678 | Incorrect Output (IN) | IQQD0008E Collection |
|||
DT213363 | Incorrect Output (IN) | Data loss potential when using Embedded SQL with multiple agents and Multi-row insert | |||
DT214747 | Performance (PR) | Server list missing alternate server when value of alternate server matches the value of the server it is set up on for the length of alternate server | |||
DT222034 | Incorrect Output (IN) | Compiling .cbl file generated by prep command failed with 309 "Malformed subscript" error | |||
DT173047 | Performance (PR) | Re-authentication occurs when re-using an existing transport for a member in xa transaction | |||
DT188305 | Incorrect Output (IN) | DB2BULKCOPY MAY RETURN CLI0125E WHEN TRYING TO LOAD MULTIPLES OF16K NUMBER OF ROWS | |||
DT188887 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to a denial of service when attempting to use ACR client affinity for unfenced DRDA federation wrappers. (CVE-2023-27555) | |||
DT207573 | Abnormal End Of The Program (AB) | TRAP IN SQLEGWRT FUNCTION | |||
DT212309 | Abnormal End Of The Program (AB) | When using JDBC type 2 driver, abort call from the Transaction Manager could return XAER_PROTO. | |||
DT214991 | Abnormal End Of The Program (AB) | ACR is disabled for the Federation DRDA fenced wrapper after applying fix for DT188887 | |||
DT173970 | Coded Message (MS) | "SSL socket setup failed" error logging in db2diag.log caused by monitoring the SSL socket | |||
DT178562 | Incorrect Output (IN) | Resize and redefine the size of char array program_z | |||
DT179750 | Incorrect Output (IN) | .NET application returns error SQL0843N during connect | |||
DT208528 | Abnormal End Of The Program (AB) | Documents are not indexed with warning IQQP0009W | |||
DT224887 | Incorrect Output (IN) | Memory Leak connected with db2acd process | |||
DT224696 | Loop (LP) | db2support collection hangs when there are indoubt transactions | |||
DT160471 | Performance (PR) | Possible page latch contention when inserting into an insert time clustered table | |||
DT168735 | Abnormal End Of The Program (AB) | The INGEST utility on AIX fails with DB21018E when connected to a remote database with an SSL encrypted connection | |||
DT173007 | Abnormal End Of The Program (AB) | Security: IBM Db2 may be vulnerable to a Denial of Service when executing a specially crafted 'Load' command. (CVE-2022-43929) | |||
DT178367 | Abnormal End Of The Program (AB) | Segmentation fault in sqldDumpDKEY | |||
DT198274 | Integrity Problems (IG) | Security: IBM Db2 db2set is vulnerable to arbitrary code execution. (CVE-2023-30431) | |||
DT147509 | Incorrect Output (IN) | IT38703: INGEST TO PARTITIONED DATABASE DOES NOT WORK OVER SSL | |||
DT147574 | Abnormal End Of The Program (AB) | IT41721: IMPORT WITH INSERT_UPDATE FAILS WITH SQL3203N AFTER GETTING SQL0437W. | |||
DT148311 | Abnormal End Of The Program (AB) | INDEX ERROR DURING ROLLBACK WHEN INSERTING INTO A DECLARED GLOBAL TEMPORARY TABLE THAT IS ORGANIZED BY COLUMN | |||
DT149264 | Abnormal End Of The Program (AB) | IT42035: A CLI LOAD INTO A COLUMN ORGANIZED TABLE MIGHT CRASH WITH A SPECIFIC STACK | |||
DT160180 | Performance (PR) | Rollforward/replay of online reorg log causes slow log replay | |||
DT169540 | Incorrect Output (IN) | IT42201: Difference in Per-Partition TSIZE between REORGCHK and REORGCHK_TB_STATS for Partitioned Tables | |||
DT174577 | Incorrect Output (IN) | SQL16003 from XML query | |||
DT188227 | Performance (PR) | Private memory leak on COS SDK | |||
DT188237 | Abnormal End Of The Program (AB) | LOAD into MQT table using LOCK WITH FORCE option does not force all locks and hangs on SET INTEGRITY | |||
DT221994 | Abnormal End Of The Program (AB) | ADMIN_MOVE_TABLE may hit SQL0911N Reason Code 68 when using CLP option autocomit off | |||
DT222000 | Performance (PR) | Deadlock on rows in SYSXMLSTRINGS or SYSXMLPATHS when many concurrent applications drive queries and inserts of XML documents | |||
DT241187 | Remove XML Extenders since it was discontinued in v9.7 | ||||
DT169362 | Incorrect Output (IN) | LOAD from cursor into inline XML with values longer than 256 characters results in SQL1194W | |||
DT169561 | Abnormal End Of The Program (AB) | Big SQL instance abends with an SQLO_UNEXPECTED_SYSERR from sqloWaitEDUWaitPost() | |||
DT189082 | Abnormal End Of The Program (AB) | Under certain conditions user can get false SQL0960C The maximum number of objects have been created in the table space | |||
DT205468 | Abnormal End Of The Program (AB) | db2prereqcheck -tb_dev failed with segmentation fault(segv) at strncpy() | |||
DT207549 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to denial of service with a specially crafted XML query statement (CVE-2023-38728) | |||
DT212891 | Incorrect Output (IN) | Data loss while ADMIN_MOVE_TABLE possible | |||
DT215290 | Incorrect Output (IN) | #pragma options in DB2 header files cause compiler warnings | |||
DT224960 | Integrity Problems (IG) | A table space in an offline state can be incorrectly brought online resulting in data corruption | |||
DT238088 | Incorrect Output (IN) | Automatic maintenance (db2acd) process may generate "hmonSQLConnect, probe:600 sqlcode=-1035" Error message every 5 minuets on db2diag.log while taking an offline backup | |||
DT147397 | Unpredictable (UN) | AUTO_REORG MIGHT BE TRIGGERED FOR TABLES WITH ADAPTIVE COMPRESSION ENABLED DUE TO F2 < 70 FOR MDC | |||
DT148675 | Abnormal End Of The Program (AB) | IT41241: POSSIBLE FMP TRAP WHEN USING ADMIN ROUTINES OR ANY MODULE USING LIBDB2XMLINIT531.A | |||
DT178232 | Integrity Problems (IG) | Error messages from sqlbExtentMovementEntryPoint can be inadvertently suppressed | |||
DT178710 | Performance (PR) | pureScale: hate lists temporarily empty after large queries | |||
DT180384 | Incorrect Output (IN) | Private memory leak while using Sequences | |||
DT202928 | Abnormal End Of The Program (AB) | Trap in dlopen() causes deadlatch with loadquery() called by Db2 signal handler | |||
DT208144 | Unpredictable (UN) | SQLD_REC_DELETED "DELETED RECORD ID" may show up during select from sysibmadm.admintabinfo | |||
DT214775 | Unpredictable (UN) | CONNECTION SLOWNESS/HANG DUE TO MORE LATCH WAIT AT GROUP AUTHENTICATION STEP. | |||
DT224997 | Abnormal End Of The Program (AB) | Db2 instance hang upon database creation failure SQL1643C | |||
DT148089 | Abnormal End Of The Program (AB) | IT39613: SIGNAL #11 IN XMLRNSERIALIZER::PACKSTATE | |||
DT148406 | Performance (PR) | IT38343: ENHANCE DB2_CSL_SEARCH_PERCENT TO IMPROVE INSERT PERFORMANCE | |||
DT148473 | Incorrect Output (IN) | IT40815: Difference in Per-Partition TSIZE between REORGCHK and REORGCHK_TB_STATS for Partitioned Tables | |||
DT171612 | Integrity Problems (IG) | Tablespace Reduce Max/HWM can provoke dumps .bin due to unexpected lock holding in SQLP_EXTENT_MOVE_STARTED | |||
DT179583 | Incorrect Output (IN) | Can't compile in Application with DB2 Client Server 11.5.8. This is the error that the system returns: libdb2.so: undefined reference to sqloRemStgDelete | |||
DT197696 | New Function (NF) | ENABLE OPTION TO ALLOW AUTOMATIC TABLE MAINTENANCE TO CHOOSE OFFLINE INSTEAD OF ONLINE INDEX REBUILD TO AVOID DEADLOCK. | |||
DT213899 | Performance (PR) | Slow RUNSTATS performance after upgrade from Db2 v10.5/v11.1 to v11.5 | |||
DT214206 | Abnormal End Of The Program (AB) | A Db2 instance can crash if a database encounters a too many open file handles (SQLO_FHNL) error while opening the database storage group files | |||
DT236661 | Incorrect Output (IN) | Invalid XML from table monitoring functions FOR BIT DATA | |||
DT188148 | Coded Wait (WS) | Automatic Reorg Evaluation on an ITC table can hold back completion of an automatic table reorganization on the table | |||
DT209167 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to denial of service under extreme stress conditions. (CVE-2023-40692) | |||
DT215950 | Coded Message (MS) | installFixPack fails with an ERROR for non-root installations, complains about loaded libraries | |||
DT173853 | Incorrect Output (IN) | db2iupdt fails to drop a collocated member using the member id | |||
DT197671 | Integrity Problems (IG) | Security: IBM Db2 on Windows is vulnerable to privilege escalation. (CVE-2023-27558) | |||
DT214851 | Incorrect Output (IN) | python2 is no longer needed for Db2, but still checked by db2prereqcheck | |||
DT173400 | Abnormal End Of The Program (AB) | InstallFixPack fails with DBI20105E when attempting to update Pacemaker | |||
DT178134 | Incorrect Output (IN) | On Sles 15, db2installPCMK hitting "nothing provides pkgconfig(libqb)" | |||
DT222769 | Abnormal End Of The Program (AB) | Validating "/etc/zipl.conf".. DBT3615E The db2prereqcheck.. Reason Code 3 for Db2 V11.5.8.0 | |||
DT242836 | Integrity Problems (IG) | Security: Multiple vulnerabilities in IBM Java SDK and IBM Java Runtime affect Db2 (Apr 2023 CPU) | |||
DT148431 | Incorrect Output (IN) | IT39324: FEDERATED OPERATIONS MIGHT LEAD TO INSTANCE CRASH WHEN HEALTH MONITOR IS TURNED ON | |||
DT160132 | Unpredictable (UN) | IT42096: INCORRECT ERROR HANDLING IN SQLEFEDFMPMANAGER::GETFMPFROMGLOBALPOOL LEADS TO DB2 INSTANCE CRASH | |||
DT173461 | Abnormal End Of The Program (AB) | Federation returns SQL0901N "Unknown type" error when query numeric value with single quote using ODBC wrapper | |||
DT198104 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service through a specially crafted federated query on specific federation objects (CVE-2023-29258) | |||
DT223376 | Abnormal End Of The Program (AB) | Oracle unfenced wrapper trapping | |||
DT237766 | Performance (PR) | Federated query performance degradation when DB2_MAXIMAL_PUSHDOWN is set to ‘Y’ by default | |||
DT238497 | Abnormal End Of The Program (AB) | Create Teradata nickname failed with SQL0204N | |||
DT143275 | Performance (PR) | IT41646: FEDERATION FUNCTIONS NOT PUSHED DOWN WHEN USING PARAMETER MARKERSUCH AS TO_TIMESTAMP(?,'YYYY-MM-DD HH24:MI:SS') | |||
DT148462 | Abnormal End Of The Program (AB) | IT40445: CRASH IN WHEN XML SOURCE FILE IS DELETED OR RENAMED | |||
DT173847 | Incorrect Output (IN) | SELECT NICKNAME MAY RETURN A GARBLED CHARACTER AT THE END | |||
DT213111 | Loop (LP) | If we lost connection from POSTGRESQL while fetching the data from POSTGRESQL using ODBC wrapper (Federation) and loading into DB2, then load is hanging | |||
DT214010 | New Function (NF) | Timestamp and Date not pushed down to MongoDB Data Source | |||
DT148223 | Incorrect Output (IN) | IT37810: REDUCE DB2DIAG.LOG MESSAGE "GET USER MAPPING" AND "SQLQG_FEDSTP_HOOK, PROBE:40 MESSAGE" | |||
DT173486 | Abnormal End Of The Program (AB) | Security: Db2 federated server is vulnerable to a denial of service when a specially crafted cursor is used. (CVE-2023-46167) | |||
DT208699 | Incorrect Output (IN) | CREATE NICKNAME command for a remote SQL Server table returns -204 error occurs: undefined name | |||
DT222119 | Performance (PR) | Db2 federation query with decimal and char comparison predicate becomes slow due to not being able to do pushdown | |||
DT224489 | Abnormal End Of The Program (AB) | Federating to SQL Server throws SQL1822N Unexpected error code "HY104" received from data source "". Associated text and tokens are " Invalid precision value". | |||
DT148065 | Incorrect Output (IN) | IT38517: MSSQL_SERVER::GET_ERROR_INFO ERROR IN MS-SQL FEDERATION CONFIGURATION | |||
DT170049 | Abnormal End Of The Program (AB) | Db2 Federation nickname driver issue | |||
DT180458 | Abnormal End Of The Program (AB) | Instance crash due to double memory free in sqlqgFedCmt1 | |||
DT187940 | Abnormal End Of The Program (AB) | Security: IBM Db2 federated server is vulnerable to a denial of service when using a specially crafted wrapper using certain options. (CVE-2023-30442). | |||
DT189684 | Incorrect Output (IN) | Federation: Oracle net8 wrapper-support function pushdown: replace, trim and to_number | |||
DT196289 | Incorrect Output (IN) | Federated does not push down certain predicates to z/OS | |||
DT196864 | Abnormal End Of The Program (AB) | Federation server memory panic caused by sqlqgFedRbk1 | |||
DT239700 | Integrity Problems (IG) | Security: Db2 Federated is affected by vulnerabilities in multiple opensource libraries | |||
DT160542 | Incorrect Output (IN) | Federation SQL1476N error "-433" insert into nickname(varchar_column) select varchar_column from local_table | |||
DT172037 | Incorrect Output (IN) | Federation ODBC wrapper characters might be truncated for MariaDB, MySQL community edition, and SAP hana data sources | |||
DT203382 | Incorrect Output (IN) | SQL query containing the OLAP LEAD function returns wrong results | |||
DT220220 | Incorrect Output (IN) | Federated user mapping change is not refreshed after HADR takeover | |||
DT224589 | Coded Message (MS) | sqlerReturnFmpToPool messages flood the db2diag.log | |||
DT228892 | System/3 Message (MI) | Creating Teradata wrapper on AIX failed with SQL10031N from V11.5.4 | |||
DT222637 | Incorrect Output (IN) | SYSTOOLS.MESSAGES is not created in the specified table space | |||
DT170035 | Abnormal End Of The Program (AB) | GET DB CFG traps if using DB2NODE to fetch data from a remote node | |||
DT170166 | Additional Information (AI) | LOGGING ENHANCEMENT FOR AN ISSUE CAUSING ORPHANED APPLICATION IN DECOUPLED STATUS IN DPF | |||
DT179060 | Loop (LP) | application not going away, stuck in sqkfChannel::BroadcastData | |||
DT195996 | Performance (PR) | Db2 concurrent workload may slow down due to heavy latch wait on the SQLO_LT_sqmPartitionedRequestMetrics__metricsSyncPoint latch | |||
DT202887 | Incorrect Output (IN) | PD_GET_DIAG_HIST and db2diag tool might return entries outside of specified time range. | |||
DT222611 | Incorrect Output (IN) | Db2 can fail with SQLKD_PARTNER_ERR - "Received HALT block with zero return code" | |||
DT222775 | Incorrect Output (IN) | Locking event monitor incorrectly reports RR isolation level for statements that are in compiling state | |||
DT237788 | Abnormal End Of The Program (AB) | Possible trap under sqkfChannel::AddSlaveChannel() on remote node | |||
DT242834 | Integrity Problems (IG) | Security: PCRE opensource library affected by multiple vulnerabilities | |||
DT148687 | Performance (PR) | IT41917: MON_GET_TABLE MAY BLOCK ON A LOCK WHEN EXTERNAL TABLES ARE BEINGUSED | |||
DT149281 | Incorrect Output (IN) | get_dbsize_info() may return unexpected large value for DATABASECAPACITY | |||
DT189651 | Loop (LP) | System applications may hang in sqlrrbck if they perform a rollback at the same time as an implicit database deactivation. | |||
DT197244 | Abnormal End Of The Program (AB) | Incorrect diagnostic log message in sqlkd_snd_buffer may lead to a crash | |||
DT160816 | Incorrect Output (IN) | Misleading/Incorrect Path Reported by db2diag command | |||
DT174378 | Abnormal End Of The Program (AB) | Security: Db2 could allow a local user with special privileges to cause a denial of service during database deactivation on DPF (CVE-2023-38719) | |||
DT179659 | Abnormal End Of The Program (AB) | db2csap generates a core dump when running db2support | |||
DT187963 | Integrity Problems (IG) | SYSMANAGEDQUERIES wlm work class of type RUNTIME in a 11.5.6 based database with old wlm default environment | |||
DT212788 | Incorrect Output (IN) | Drop event monitor may result in creation of an applicatoin on non-coordinator nodes | |||
DT214839 | Abnormal End Of The Program (AB) | Failure on an SQL statement with error may lead to trap in sqmSqlCacheMetrics::CaptureCoordHWMArgs | |||
DT223627 | Incorrect Output (IN) | During system controller startup, some diagnostics messages are not recorded in the diagnostics log | |||
DT147386 | Abnormal End Of The Program (AB) | IT41166: SQL1092 TOKEN:X180085 ON CALL GET_DBSIZE_INFO(?,?,?,0) | |||
DT148129 | Abnormal End Of The Program (AB) | IT41889: A NON ENCRYPTED DATABASE THAT IS RESTORED AS AN ENCRYPTED DATABASE IS NOT CONNECTABLE AFTER THE RESET DB CFG COMMAND. | |||
DT148130 | Incorrect Output (IN) | IT41926: TRACKING ERROR IN WLM ERROR CORRECTION CAN LEAD TO NON FATAL ASSERTION | |||
DT148314 | Abnormal End Of The Program (AB) | IT41989: THE EVMON_FORMAT_UE_TO_XML TABLE FUNCTION CAN TRAP FOR LOCK EVENTS INVOLVING A TABLESPACE LOCK WHEN THE TABLESPACE IS ALREADY DR | |||
DT172665 | Unpredictable (UN) | HADR status changed to disconnected after primary reboot | |||
DT188935 | Incorrect Output (IN) | Event Table Is Filling Up After the Event Monitor Is Dropped in DPF System | |||
DT236687 | Incorrect Output (IN) | Reduce severity level of db2diag probe if it is an interrupt for WLM monitoring functions | |||
DT148668 | Abnormal End Of The Program (AB) | IT40873: SQL1092 TOKEN:X180085 ON CALL GET_DBSIZE_INFO(?,?,?,0) | |||
DT188297 | Abnormal End Of The Program (AB) | DB2 trap in federation communication against DB2 z/os federated | |||
DT189583 | Abnormal End Of The Program (AB) | db2pd -apinfo crash with -debug option because of extended memory corruption | |||
DT211718 | Loop (LP) | "db2 force application('apphdl')" can fail to properly interrupt external table operations using SSL connection. | |||
DT222690 | Coded Halt (HL) | DB2 SYSTEM APPLICATIONS MAY HANG ON A DB2 DPF INSTANCE | |||
DT223336 | Incorrect Output (IN) | db2pd -dump all dumpdir='/scratch/' -repeat 5 2 may dump data into wrong directory | |||
DT228901 | Abnormal End Of The Program (AB) | db2pd -applications may result in messages "Changing data structure forced command termination" | |||
DT160459 | Coded Message (MS) | DB2DIAG.LOG FLOODED WITH DIAGNOSTIC MESSAGES | |||
DT228889 | Performance (PR) | Latch Contention in CF for Highly Concurrent, Read Heavy Workloads | |||
DT147773 | Abnormal End Of The Program (AB) | IT41923: CREATE INLINED TRIGGER FAILED WITH SQL901N (REASON "NO SOURCE TABLE FLAG SET FOR UPDATE FROM QUERY") | |||
DT148852 | Abnormal End Of The Program (AB) | SQL0901N FODC_AppErr generated when running a query | |||
DT160196 | Abnormal End Of The Program (AB) | Db2 server may terminate abnormally issuing a query with unreferenced CTE | |||
DT168886 | Abnormal End Of The Program (AB) | Db2 query may trap when cse with union | |||
DT172257 | Incorrect Output (IN) | Query execution plan has non-numeric Total Cost values | |||
DT172335 | Abnormal End Of The Program (AB) | IN MPP CONFIGURATIONS, UNDER RARE CONDITIONS, A QUERY WITH A CORRELATED COLUMN REFERENCE IN A SUBSELECT MIGHT RESULT IN A SEGV TRAP | |||
DT173793 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query. (CVE-2023-30449) | |||
DT188141 | Abnormal End Of The Program (AB) | Security: Db2 server may terminate abnormally when using a specially crafted query on certain databases. (CVE-2023-30987) | |||
DT188352 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30447) | |||
DT203400 | Abnormal End Of The Program (AB) | Security: IBM DB2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30446) | |||
DT208544 | Integrity Problems (IG) | Security: Db2 is vulnerable to denial of service with a specially crafted query (CVE-2023-30991) | |||
DT209233 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to denial of service with a specially crafted query (CVE-2023-43020) | |||
DT212885 | Performance (PR) | Provide method to favour access plans that can exploit performance enhancement to column-organized updates/deletes with joins | |||
DT212933 | Incorrect Output (IN) | A DB2 query may return incorrect results when query references a user defined function and at-least one columnar table | |||
DT220313 | Incorrect Output (IN) | SQL0901N "No Remote Query output columns given." from table function involving column-organized tables | |||
DT222709 | Abnormal End Of The Program (AB) | FIXPACK UPDATE MAY LEAD TO ERROR SQL901N | |||
DT237459 | Coded Halt (HL) | SQL0901 "Empty plan list detected!" when compiling query with full outer join | |||
DT147742 | Incorrect Output (IN) | 901 ERROR MIGHT OCCUR WITH THE MESSAGE "PLAN NOT FOUND FOR UNIONLEG" | |||
DT147960 | Abnormal End Of The Program (AB) | IT41629: ISSUING TRUNCATE TABLE STATEMENT MAY CAUSE THE SERVER TO TERMINATE ABNORMALLY. | |||
DT148293 | Performance (PR) | IT41067: ISSUING SELECT UNION ALL QUERY WITH LARGE CLOB MAY FAIL WITH SQL1585N | |||
DT160619 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to a denial of service as the server may crash when compiling a specially crafted SQL query. (CVE-2023-26021) | |||
DT168757 | Incorrect Output (IN) | IT42207: WRONG RESULT WHEN GROUP BY COL IS MISSING | |||
DT172693 | Abnormal End Of The Program (AB) | Creating NZPLSQL routine may result in stack memory corruption | |||
DT173255 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30448) | |||
DT173447 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query. (CVE-2023-30443) | |||
DT180503 | New Function (NF) | ALLOW AN EMBEDDED OPTIMIZATION GUIDELINE ANYWHERE WITHIN AN SQL STATEMENT. | |||
DT188497 | Incorrect Output (IN) | Query fails with error SQL0901N "nljn LOJ inner not nullable" | |||
DT188878 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to a denial of service. Under rare conditions, setting a special register may cause the Db2 server to terminate abnormally (CVE-2023-25930) | |||
DT197773 | Performance (PR) | Automatic catalog statistics sampling occurs incorrectly in some situations | |||
DT211543 | Incorrect Output (IN) | SQL0901N error with "Empty plan list detected" may be returned for MPP queries which construct XML elements | |||
DT220159 | Machine Check (MC) | A Db2 query may exhibit long compile times when there are several CSEs (Common Sub-Expressions) referenced | |||
DT228461 | Performance (PR) | THE FILTER FACTOR WILL NOT BE ADJUSTED TO THE REQUESTED VALUE SPECIFIED BY THE SELECTIVITY CLAUSE | |||
DT148689 | Incorrect Output (IN) | IT41977: POSSIBLE -901 ERROR FOR NESTED QUERIES WITH CASE EXPRESSIONS WITHSUB-QUERIES REFERENCED THE SELECT LIST. | |||
DT169994 | Performance (PR) | Slow compilation of queries involving INNER JOINs of multiple tables and some partitioned tables | |||
DT172119 | Performance (PR) | Poor performance of Db2 query when Group By list has expression and index column | |||
DT173349 | Incorrect Output (IN) | INSERT INTO COLUMN-ORGANIZED TABLE WITH SUB-SELECT REFERENCING THE TARGET OF THE INSERT MAY RETURN INCORRECT RESULTS IN DPF SYST | |||
DT178597 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to a denial of service as it may trap when compiling a variation of an anonymous block (CVE-2023-29255) | |||
DT211674 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to denial of service with a specially crafted RUNSTATS command on an 8TB table. (CVE-2023-40687) | |||
DT212371 | Incorrect Output (IN) | SQL0204N due to timestamp checking to compare start of compilation with the creation time of the table | |||
DT214149 | Incorrect Output (IN) | Subquery with FETCH FIRST n ROWS and OLAP function but without ORDER BY on column-organized tables might return more rows than expected | |||
DT237138 | Performance (PR) | Poor performance of Db2 query when the following conditions mentioned in the description are met | |||
DT147963 | Incorrect Output (IN) | IT41976: Missing table name in the diagnostic Information regarding not collected statistics in the explain plan file | |||
DT172317 | Incorrect Output (IN) | Db2 query may generate Incorrect result when tables have Referential Integrity(RI) relation. | |||
DT173830 | Incorrect Output (IN) | Use of non-supported RID function triggers SQL0901N error instead of the expected SQL5115N error | |||
DT174494 | Abnormal End Of The Program (AB) | Security: Db2 server may terminate abnormally when issuing a specially crafted query statement (CVE-2023-40374) | |||
DT178746 | Incorrect Output (IN) | CREATE TABLE IF NOT EXISTS ignores dft_table_org=COLUMN database configuration parameter | |||
DT187836 | Abnormal End Of The Program (AB) | Query compile fails with SQL0901N "pid type does not match original untyped code | |||
DT189181 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to a denial of service as the server may crash when using a specially crafted subquery. (CVE-2023-27559) | |||
DT189461 | Performance (PR) | COLUMN-ORGANIZED FETCH-IXSCAN ESTIMATED COST IS INACCURATE FOR QUERIES THAT RETRIEVE A LARGE NUMBER OF COLUMNS AND ROWS. | |||
DT189799 | Incorrect Output (IN) | Creating an expression-based index may lead to SQL0622N error | |||
DT209442 | Incorrect Output (IN) | SYSCAT.ROUTINEPARMS missing parameters for LAG and LEAD built-in functions | |||
DT209578 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to denial of service with a specially crafted SQL statement using External Tables. (CVE-2023-40372) | |||
DT211077 | Performance (PR) | Poor performance of merge statement when hidden column of PK absent in ON | |||
DT212934 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to denial of service with a specially crafted query containing common table expressions (CVE-2023-40373) | |||
DT215096 | Performance (PR) | Poor performance of Db2 query with always true regexp_like predicate. | |||
DT221828 | Abnormal End Of The Program (AB) | SQL0508N when DB2_EXTENDED_OPTIMIZATION=MARKMCARD_MISSINGPKCOL ON | |||
DT222859 | Abnormal End Of The Program (AB) | Security: Specially crafted statement results in abnormal termination of Db2 server (CVE-2023-38727) | |||
DT222991 | Incorrect Output (IN) | The SYSSTAT.TABLES.FPAGES statistic is sometimes inconsistent with NPAGES and MPAGES | |||
DT160511 | Performance (PR) | Performance issues when queries contain predicates on columns derived from constants in recursive sub-selects | |||
DT172015 | Additional Information (AI) | Info level diagnostics might be recorded in db2diag log file for DIAGLEVEL 0-3 | |||
DT173922 | Incorrect Output (IN) | With Db2 DPF, SQLCODE -901 "Correlated part col not in stream." might occur during compilation of a query with correlated grouping sets columns | |||
DT174288 | Incorrect Output (IN) | Plan ID changes when migrating from 10.x versions of Db2 to 11.1 and later. | |||
DT188308 | Incorrect Output (IN) | Explicit cast to VARCHAR or VARGRAPHIC without length ignores default string units | |||
DT189575 | Incorrect Output (IN) | -901 with Can not enforced Maxcard > 1 when multiple joins used in query | |||
DT189592 | Incorrect Output (IN) | SYSCAT.DATAPARTITIONS contains incorrect statistics values for column-organized tables | |||
DT197954 | Incorrect Output (IN) | A multi-join query involving column-organized tables and join predicates with complex expressions might yield incorrect results. | |||
DT209344 | Performance (PR) | Possible performance issue and high demand for STMTHEAP (or SQL0101N) for complex XML queries with multiple Union All branches | |||
DT215667 | Abnormal End Of The Program (AB) | Security: Specially crafted ALTER TABLE may cause abnormal termination of Db2 server (CVE-2023-38720) | |||
DT224882 | Incorrect Output (IN) | UPDATE or DELETE of global temporary table returns SQL0551 | |||
DT228679 | Abnormal End Of The Program (AB) | SQL0901 "Predicate not found" during Federated query compilation | |||
DT238314 | Abnormal End Of The Program (AB) | In complex queries using OLAP function first_value on column ordered tables, in MPP systems, may encounter a trap. | |||
DT174584 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30445) | |||
DT197297 | Incorrect Output (IN) | "SET ?" returns SQL0901 with stmt_conc=LITERALS | |||
DT189173 | Incorrect Output (IN) | Make DROPTAB_ACTION optional in Q Capture | |||
DT195980 | Fix the unique index issue and Update the new QMAP name for CCD columns. | ||||
DT197841 | Incorrect Output (IN) | If the target table already exists, and the unique index is suitable, Replication Center (RC) and ASNCLP incorrectly still try to create index | |||
DT208526 | Incorrect Output (IN) | Issue ASN7358I message on Q Capture startup when trans_batch_sz is greater than 1 and Q Capture automatically bumps up MAX_TRANS | |||
DT212936 | Integrity Problems (IG) | SQL Capture and Q Capture are not updating PART_HIST table for ATTACH/DETACH/ADD range Partition - Potential Data loss after Capture restart | |||
DT222106 | Incorrect Output (IN) | Oracle Apply initial load with SQL*Loader fails with ASN7530E bad data record for DECIMAL column data having equal precision and scale | |||
DT224566 | Incorrect Output (IN) | Q Capture needs to set correct default value for TRANS_COMMIT_MODE parameter | |||
DT228669 | Incorrect Output (IN) | SQL Error "-803" occurs when creating monitor tables with ASNCLP on Oracle. | |||
DT180608 | Incorrect Output (IN) | Oracle Q Apply gets error ORA-01400 for MRI due to incorrect default for RTRIM_CHAR_TO_VARCHAR parameter | |||
DT208925 | Incorrect Output (IN) | The message "Parameter index 78 is out of range." is displayed every time Capture is started | |||
DT209069 | Incorrect Output (IN) | Need COMMITs for retention_limit pruning in SQL Capture | |||
DT213082 | Performance (PR) | Q Apply should use compression with binary format during columnar table initial load | |||
DT215896 | Incorrect Output (IN) | Oracle Q Capture should not get ORA-01741 for inserts into the IBMQREP_CAPMON table | |||
DT223427 | Incorrect Output (IN) | Restore some operations in Replication Center | |||
DT172370 | Abnormal End Of The Program (AB) | Q Apply startup or STARTQ may fail with SQL-10 when checking if a target is a nickname. | |||
DT174287 | Incorrect Output (IN) | Replication Center does not display the Alert Group assigned contacts | |||
DT188249 | Incorrect Output (IN) | Fix ALTER TABLE ALTER COLUMN DROP/SET DEFAULT in v1158 | |||
DT188885 | Incorrect Output (IN) | "Delete gtran committed before restart point" message floods capture log when processing an empty global transaction | |||
DT199933 | Incorrect Output (IN) | ADDCOL Processing leads to ASN7814E due to inconsistent IS_KEY information between IBMQREP_SRC_COLS and IBMQREP_TGT_COLS | |||
DT211484 | Incorrect Output (IN) | Oracle QCapture should not stop on OCI_SUCCESS_WITH_INFO | |||
DT215449 | Incorrect Output (IN) | Asnmon report error message ASN5154W when the alert on QCAPTURE_MEMORY uses a value greater than 2047. | |||
DT225689 | Incorrect Output (IN) | Missing parameter marker in ASNDB2SQ package | |||
DT238900 | Incorrect Output (IN) | Q Apply should not activate range partition subscriptions if there are any rejected rows during the initial load | |||
DT172477 | Incorrect Output (IN) | Add the missing new column HAS_PARTS into migration script. | |||
DT173810 | Incorrect Output (IN) | Add "NO CACHE ORDER" when creating IBMQREP_APPLYCMD and IBMQREP_CAPCMD control tables. | |||
DT197143 | Incorrect Output (IN) | CP4D- Q replication server reported the message "ASN8999D Corrupted qStreamedTransMsgHeader on send queue xxxx" | |||
DT197526 | Abnormal End Of The Program (AB) | When running asnmon on LUW with control tables on z/OS, asnmon terminates with ASN0543E error | |||
DT214858 | Incorrect Output (IN) | Fix memory corruption error in Q Capture send queue | |||
DT222930 | Performance (PR) | Q Apply replicating columnar table in DPF may report SQL -644 if target table does not use all data partitions. | |||
DT172482 | Incorrect Output (IN) | Q Capture should read from serialized XML log records instead of fetching from the table when XML columns are defined in a separate long tablespace | |||
DT189305 | Incorrect Output (IN) | Q Apply poor performance for complex RI needs to be improved by doing dependency analysis based on RI key values | |||
DT215322 | Incorrect Output (IN) | Asnmon takes a sigsegv and a dump is generated when it writes to a file with a long path name. | |||
DT225087 | Incorrect Output (IN) | asnmon getting sql0803n after setting DB2_COMPATIBILITY_VECTOR=ORA | |||
DT238517 | Incorrect Output (IN) | On Unix and Windows platforms, ASNCLP expose error ASN1551E when creating SQL capture control tables if we specify the UOW keyword | |||
DT149266 | Incorrect Output (IN) | IT42044: SQL0955 RC=2 MAY BE RETURNED FOR SORT REQUESTS WITH A WIDE SORT KEY (>32K) WHEN AVAILABLE SORTHEAP IS LIMITED | |||
DT171981 | Abnormal End Of The Program (AB) | Insert into a DGTT which contains XML fields on MPP environment might crash the instance | |||
DT174686 | Loop (LP) | Agent cannot be forced under certain conditions | |||
DT203318 | Coded Halt (HL) | Array Input may report -901 sqlcode (probe 020 in sqlktopn(), msg=TQ already open) | |||
DT214228 | System/3 Message (MI) | OOM because of large section size | |||
DT222401 | Performance (PR) | A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT | |||
DT236512 | Abnormal End Of The Program (AB) | Db2 trap due to ipcresources is NULL during db2fmp shutdown | |||
DT239550 | Coded Wait (WS) | The package cache daemon leaves locks behind with DB2_VARLOCK_VARIANT_ENABLE enabled | |||
DT147258 | Abnormal End Of The Program (AB) | IT35932: POSSIBLE FMP TRAP WHEN RUNNING DB2EXPLAIN WITH A STATEMENT CONTAINING UNESCAPED NEWLINE (\N) AND MULTIPLE SETS OF '(/)' | |||
DT169432 | Incorrect Output (IN) | Warning message regarding stmmCreateVirtualSorts should be moved to STMM logs | |||
DT188693 | Abnormal End Of The Program (AB) | Security: IBM Db2 is vulnerable to a denial of service as the server may crash when an Out of Memory occurs. (CVE-2023-26022) | |||
DT197066 | Abnormal End Of The Program (AB) | FODC Trap in sqlra_find_var_var | |||
DT208631 | Abnormal End Of The Program (AB) | Interrupt to fmp may generate many harmless but confusing error message in db2diag.log. | |||
DT211306 | Performance (PR) | Excessive logging on interrupt in smp | |||
DT212824 | Abnormal End Of The Program (AB) | FODC Generated When Wide Row Split Across TQ Buffers | |||
DT238133 | Incorrect Output (IN) | CREATE PROCEDURE |
|||
DT147383 | Incorrect Output (IN) | IT41074: INVALID DATE FORMAT WHEN INSERTING DATES | |||
DT170011 | Incorrect Output (IN) | Using external UDF in recursive query executes only once and returns wrong number of rows | |||
DT172803 | Abnormal End Of The Program (AB) | Possible 3 ways hang with FMP and 2 db2agent | |||
DT223682 | Abnormal End Of The Program (AB) | On 11.5.8.0, java stored procedure may get an exception "java.security.ProviderException: Failed to initialize IBMJCEPlus provider" | |||
DT224613 | Abnormal End Of The Program (AB) | Possible sustained trap sqlrr_rds_common_post() when Federated Query fails | |||
DT239479 | Incorrect Output (IN) | PROCEDURE |
|||
DT128047 | Incorrect Output (IN) | IT40543: CONNECTION FROM DB2FMP TO THE ENGINE IS NOT CLEANED UP AFTER AN INTERRUPT | |||
DT147693 | Abnormal End Of The Program (AB) | IT38953: POSSIBLE CORE FILE, TRAP WITH CORRUPTED STACK GENERATED BY DB2FMP WHEN QUERY IS INTERRUPTED | |||
DT169902 | Abnormal End Of The Program (AB) | Big SQL instance panics with 'Corrupt pool free tree node' from sqloDiagnoseFreeBlockFailure() | |||
DT172626 | Coded Wait (WS) | An unexpected program error in Db2 self tuning memory (db2stmm) may cause query or database hang | |||
DT173315 | Incorrect Output (IN) | Wrong DateTime format or delimiter chosen | |||
DT196650 | Coded Message (MS) | Rebind of a package defined in a module can incorrectly fail with a SQL0440N | |||
DT208338 | Incorrect Output (IN) | select from DGTT may get wrong results if there is a regular table with the same schema and name | |||
DT208575 | Coded Message (MS) | SQL0901 (Reason "usertemp inconsistent IUD") | |||
DT213791 | Abnormal End Of The Program (AB) | DB2 may generate SQL0901N for blu insert query | |||
DT228412 | Abnormal End Of The Program (AB) | Memory leak while using JSON_TABLE function in sql | |||
DT238735 | Abnormal End Of The Program (AB) | INSTANCE MAY TRAP WITH POSSIBLE MEMORY CORRUPTION DETECTED | |||
DT160513 | Performance (PR) | PERFORMANCE DOWNGRADED AFTER UPGRADING TO V11.1.4.7 DUE TO MORE CALL OF sqlra_compile_var | |||
DT168876 | Abnormal End Of The Program (AB) | IN DPF, In an ERROR SCENARIO IF QUERY IS USING A VARIABLE, IT COULD FAIL WITH -901 or -902 (SQLKT_PGM_ERROR or SQLKT_SEVERE_PGM_ERROR) | |||
DT173735 | Performance (PR) | PERFORMANCE has slowed down with "DYNAMIC SQL CACHE NON REUSE" | |||
DT178557 | Abnormal End Of The Program (AB) | applications calling sqlugrpn() with datetime columns in distribution key may abort | |||
DT187825 | Performance (PR) | When Statement concentrator (stmt_conc) is set to COMMENTS or COMM_LIT, it could result in leak of package cache memory and a reduced package cache hit ratio | |||
DT198759 | Incorrect Output (IN) | FAILED_SQL_STMTS incorrectly increased the count when the DML statement failed to compile | |||
DT211214 | Loop (LP) | Under certain conditions query cannot be forced when agent is looping in sqlriPercentileGetValue. | |||
DT214258 | Coded Halt (HL) | fmp hung during force application | |||
DT195953 | Incorrect Output (IN) | Incremental restore failing with SQL20569N | |||
DT196248 | Incorrect Output (IN) | db2look generates an external table DDL that works on v11.5.5 but fails on later versions after two options became mutually exclusive | |||
DT208624 | Incorrect Output (IN) | create external table when using option TRIMBLANKS BOTH trailing trimming does not work | |||
DT209180 | Abnormal End Of The Program (AB) | LF/CR in quoted data results in failure when it appears in the last column, and the buffer ends with a record delimiter character | |||
DT209301 | Incorrect Output (IN) | NULL character in FIXED FORMAT binary data causes SELECT failure VARBINARY | |||
DT212411 | Creation of a view on a transient external table results in error “SQL0901 No column information found in the packed descriptor” | ||||
DT221915 | Incorrect Output (IN) | DBMS_LOCK.REQUEST not returning correct status code. | |||
DT169382 | Abnormal End Of The Program (AB) | External Table load failure when data file > 2MB contains sequential escape characters | |||
DT188851 | Incorrect Output (IN) | DBMS_LOCK.REQUEST throws error SQL0206N incorrectly when the same lock is requested from a different session which is already being held by another session. | |||
DT208377 | Abnormal End Of The Program (AB) | QUERY ON EXTERNAL TABLE HAVING BIGINT COLUMN FOLLOWED BY A COLUMN OF ANY DATA TYPE, FAILS WITH SQL20570N | |||
DT213994 | Incorrect Output (IN) | Under certain conditions DBMS_LOCK.ALLOCATE_UNIQUE can return NULL LOCK HANDLE | |||
DT149246 | Abnormal End Of The Program (AB) | When an external table command is run using the REMOTESOURCE option set to yes, and a scenario occurs where the coordinator is interrupted during the transfer of data from the remote source to the fmp process, a hang occurs. | |||
DT213848 | Incorrect Output (IN) | DBMS_LOCK.REQUEST throws error SQL0431N and SQL0803N incorrectly when the same lock is requested from a different session which is already being held by another session. | |||
DT147577 | Abnormal End Of The Program (AB) | IT41972: DB2 CRASH WHEN ALIAS IS USED TOGETHER WITH A PARTITIONED TRANSIENT EXTERNAL TABLE | |||
DT189717 | Incorrect Output (IN) | SQL20569N Error when specifying encoding utf8 option for an external table created in a database with non-unicode code page | |||
DT224383 | Incorrect Output (IN) | When the Db2 driver is repeatedly loaded and unloaded by an application, and the SSLServerCertificate parameter is configured, the in-memory keystore may leak a small amount of memory | |||
DT237617 | Incorrect Output (IN) | db2look output truncated when a Trusted Context contains a large number of attributes | |||
DT240334 | Integrity Problems (IG) | Pacemaker docs are being removed due to using an outdated opensource library. | |||
DT172470 | New Function (NF) | REVERT GSK_MS_CERTIFICATE_STORE BEHAVIOUR AND CREATE A SEPARATE SETTING TO TURN ON MSCNG | |||
DT173489 | Integrity Problems (IG) | Security: IBM Db2 is vulnerable to an information disclosure vulnerability due to improper privilege management when a specially crafted table access is used (CVE-2022-43927) | |||
DT174059 | Integrity Problems (IG) | Security: IBM Db2 on Windows is vulnerable to an information disclosure vulnerability as sensitive information may be included in a log file. (CVE-2022-43930) | |||
DT224740 | Integrity Problems (IG) | Security: In certain cases users with DATAACCESS authority can execute routines they are not authorized to (CVE-2023-38003) | |||
DT224814 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service under certain conditions when creating a table (CVE-2023-38740) | |||
DT228354 | Coded Message (MS) | JWTs(ACCESSTOKEN) exposed in CLI trace and SQLGetInfo | |||
DT236921 | Incorrect Output (IN) | When TLS 1.3 is enabled, GSKit error 446 might be seen in the diagnostic log when a Java client closes a connection | |||
DT173476 | Integrity Problems (IG) | Security: IBM Db2 for LUW is vulnerable to insufficient audit logging (CVE-2023-23487) | |||
DT178890 | Abnormal End Of The Program (AB) | On Linux and AIX platforms with a fix for IT41557, DB2 may panic or hang after a password check times out | |||
DT208180 | Integrity Problems (IG) | Security: IBM Db2 is vulnerable to remote code execution. (CVE-2023-29257) | |||
DT209435 | Incorrect Output (IN) | CREATE DATABASE may result in a SQL0552N if the user only has SYSCTRL authority | |||
DT223175 | Integrity Problems (IG) | Security: Db2 is affected by a vulnerability in GSKit (CVE-2023-32342) | |||
DT236965 | Integrity Problems (IG) | Security: A vulnerability in libqb affects Db2 High-Availability deployments using Pacemaker (CVE-2023-39976) | |||
DT208397 | Integrity Problems (IG) | SECURITY: IBM Db2 is vulnerable to information disclosure due to improper privilege management when certain federation features are used. (CVE-2023-29256) | |||
DT211379 | Integrity Problems (IG) | Security: IBM Db2 JDBC driver is vulnerable to arbitrary code execution. (CVE-2023-27867, CVE-2023-27868, CVE-2023-27869) | |||
DT215550 | Integrity Problems (IG) | Security: IBM Db2 is vulnerable to remote code execution. (CVE-2023-35012) | |||
DT238702 | Incorrect Output (IN) | When an SSL error occurs, Db2 might only return an error code in the diagnostic log rather than a message | |||
DT187810 | Incorrect Output (IN) | SQL1729N is encountered when attempting a CATALOG STORAGE ACCESS command with a KMIP or PKCS11 keystore | |||
DT173780 | Integrity Problems (IG) | Security: IBM Db2 Connect Server is affected by an HTTPclient vulnerability (CVE-2014-3577) | |||
DT239406 | Integrity Problems (IG) | Security: Db2 is vulnerable to privilege escalation or denial of service when using a specially crafted statement (CVE-2023-47701) | |||
DT245990 | New Function (NF) | CHANGE THE DEFAULT TLS VERSION TO TLS 1.2 | |||
DT148117 | Incorrect Output (IN) | IT41276: SUSTAINED TRAP ON HADR STANDBY BLOCKS REPLAY-ONLY WINDOW | |||
DT170023 | Abnormal End Of The Program (AB) | CF GBP missing detach failure | |||
DT172758 | Loop (LP) | Backup latches caused system hang on the database where the backup is running. | |||
DT208786 | Abnormal End Of The Program (AB) | Member may FODC when a RDMA adapter fails. | |||
DT215935 | Performance (PR) | Host time going backwards causes purge in connections | |||
DT237876 | Abnormal End Of The Program (AB) | Fix unnecessary wait for DPF partitions starting in a TSA automated environment | |||
DT169658 | Abnormal End Of The Program (AB) | db2cm -delete -qdevice fails while QDevice host is down | |||
DT170021 | Abnormal End Of The Program (AB) | SAL Panic, page name mismatch | |||
DT195923 | Abnormal End Of The Program (AB) | db2cm -enable not working in a two-sites multiple standby cluster with same-site failover automation | |||
DT198297 | Integrity Problems (IG) | HADR takeover by force fails when standby cannot resolve hostname of primary to IP | |||
DT238214 | Integrity Problems (IG) | HADR_REMOTE_HOST changed from hostname string to IP address after takeover in HADR with multiple standbys environment | |||
DT172989 | Abnormal End Of The Program (AB) | Db2 CLP by resource agents fails with SQL0332N error when database is used with locale that are incompatible with LANG C | |||
DT180011 | Abnormal End Of The Program (AB) | Reduce CF memory by shrink of GBP structure fails with timeout after 5 minutes | |||
DT189581 | Title: Query on HADR standby is forced off when DROP TABLE with SESSION as schema name is executed on the HADR primary database | ||||
DT195910 | Abnormal End Of The Program (AB) | db2cluster -verify -req -rdma_ping times out when the cluster is configured to use significant number of RDMA adapters | |||
DT198216 | Abnormal End Of The Program (AB) | db2start may fail when pacemaker is in the environment with an SQL1345 error | |||
DT209734 | Integrity Problems (IG) | HADR_REMOTE_HOST changed from hostname string to IP address after takeover | |||
DT221970 | New Function (NF) | "An unexpected error is encountered" can be observed in db2diag.log on RDMA pureScale clusters that have db2locssh configured for root ssh between hosts when ALM rdma ping running. | |||
DT224539 | Abnormal End Of The Program (AB) | Primary database hangs while starting HADR on standby in pureScale. | |||
DT147521 | Abnormal End Of The Program (AB) | IT39502: PRIMARY CF CRASH DUE TO ASSERT DURING MEMBER CRASH RECOVERY | |||
DT180017 | Incorrect Output (IN) | False positive error in CF cfdiag when reducing container size | |||
DT197154 | Unpredictable (UN) | Memory leak in db2fmd while monitored db2 instance is stopped. | |||
DT225098 | Incorrect Output (IN) | userprofile banner causes HADR issues | |||
DT238311 | Abnormal End Of The Program (AB) | Db2 pureScale members got trapped at libdb2cf_api.so.1 CF library | |||
DT238653 | Coded Message (MS) | db2cm command returns list of parameters and it includes invalid parameter for Mutual Failover environment. | |||
DT174277 | Abnormal End Of The Program (AB) | adding -remote_cmd option for db2cm fix to for systems with an ssh banner | |||
DT178933 | Incorrect Output (IN) | db2cluster -verify -req -rdma_ping : performance statistics are missing into result files | |||
DT223903 | Additional Information (AI) | Add a functionality to collect additional diagnostic data for a connection purge problem. | |||
DT224776 | Abnormal End Of The Program (AB) | Setting the CF_MEM_SZ too high (around 1 TB) will cause the CF to crash | |||
DT236712 | Abnormal End Of The Program (AB) | Starting HADR as primary in pureScale failed with ADM12509E reason code 6 | |||
DT237589 | Incorrect Output (IN) | Pacemaker may issue takeover back to original primary after graceful takeover to standby. | |||
DT238689 | Incorrect Output (IN) | Incorrect pureScale alert while network interface failure | |||
DT237784 | Incorrect Output (IN) | Rollback of transaction on event monitor table is not deferred on HADR TAKEOVER |
DB2 Version 11.5 Fix Pack m8fp0 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract |
Fix Pack m8fp0 - Availability | |||||
DT147361 | 2 | IT40335: HADR STANDBY IS SHUTDOWN DUE TO NOT FINDING A LOG FILE RETRIEVED FROM ARCHIVE | |||
---|---|---|---|---|---|
DT080075 | 2 | IT34214: STOP HADR ON PRIMARY HANGS WHEN HADR IS IN DISCONNECTED_PEER STATE | |||
DT147360 | 2 | IT40290: DB2FMTLOG TOOL DISPLAYS INTERNAL ERROR WHEN FORMATTING A DB2 LOGFILE. | |||
DT148050 | 2 | IT37338: CPU_UTILIZATION CAN BE SHOWING MORE THAN 100% | |||
DT147341 | 2 | IT39286: TOO MANY LOG FILES IN ACTIVE PATH ON HADR STANDBY | |||
DT147913 | 1 | IT40007: CONFIGURING HADR FOR TLS ON WINDOWS PLATFORM USING MICROSOFT CERTIFICATE STORE FAILS WITH SQL1768N REASON CODE 28 | |||
DT148461 | 2 | IT40356: A DROP ROLE STATEMENT MIGHT TRIGGER ERROR TRYING TO WRITE A LOG RECORD EXCEEDING MAXIMUM SIZE | |||
DT148627 | 3 | IT39175: FLUSH BUFFERPOOL IS NOT SUPPORTED ON STANDBY WITH LOG_DDL_STMTS=YES | |||
DT127114 | 2 | IT39973: Frequent activation/deactivation can cause file handle leak and increase in memory on db2 server | |||
DT148449 | 2 | IT40091: DB2CKBKP FAILS TO VALIDATE REMOTE BACKUP | |||
DT147303 | 2 | IT38144: FALSE LOW LOG DISK SPACE WARNINGS IN DB2DIAG.LOG AT DATABASE ACTIVATION | |||
DT148667 | 2 | IT40906: BACKUP USING LIBDB2NX842_ENCR.A MIGHT RETURN SQL2079N WITH RC=1 | |||
DT148475 | 2 | IT40877: RETRIEVE LOG FILE FAILED WITH SQLP_LOG_NOT_IN_ARCHIVE ERROR DUE TO SEARCHING WITH WRONG LOGCHAINID IN LOG ARCHIVE | |||
DT148672 | 2 | IT40975: MISLEADING DB2DIAG.LOG MESSAGE WHEN USING ZLIB BASED BACKUP OR LOG FILE COMPRESSION | |||
DT147327 | 2 | IT38859: DB2MOVE COPY FAILS WITH "INVALID OBJECT TYPE SPECIFIED" | |||
DT147532 | 2 | IT39956: ABNORMAL TERMINATION OF DATABASE WITH "ERROR DURING LOG PAGE VALIDATION." FROM SQLPGWLP, PROBE:390. | |||
DT148119 | 2 | TOO MANY LOG FILES IN ACTIVE LOG PATH ON HADR STANDBY AND ALSM ENABLED | |||
DT147905 | 2 | IT39846: HADR LOG SHIPPING MIGHT BE STUCK AFTER DB2 UPDATE ACROSS 11.5.6 | |||
DT148611 | 2 | IT38555: DEADLOCK BETWEEN MANUAL RUNSTATS AND AUTO REORG RECLAIM ISSUED BY AUTO MAINTENANCE | |||
DT147681 | 2 | IT38504: ONLINE BACKUP MAY FAIL WHILE PROCESSING TRANSACTION LOG FILE - BAD PAGELSO FOUND FOR LOG FILE | |||
DT148427 | 2 | IT39080: MINBUFFLSN DOES NOT UPDATE FOR A LONG PERIOD OF TIME DURING RECOVERY | |||
DT148430 | 3 | IT39320: STALE VALUE OF LOG_EXTRACTION_DISK_SPACE_USED_TOTAL WITH ADVANCED LOG SPACE MANAGEMENT ENABLED | |||
DT147895 | 2 | IT39287: HADR STANDBY MAY TAKE LONGER THAN NORMAL TO REACH PEER STATE ON ACTIVATION | |||
DT147517 | 3 | IT39359: Db2 hangs with many EDUs waiting on logTailHeartBeatLatch | |||
DT147954 | 2 | IT41265: HADR PRIMARY MIGHT CAUSE A TRAP WHEN PROCESS IS SLOW AND PEER WAIT LIMIT REACHED | |||
DT148118 | 2 | IT41121: GENERATING A REDIRECTED RESTORE SCRIPT MAY CRASH INSTANCE IF STORAGE GROUP FILES BECOME CORRUPTED | |||
DT147757 | 2 | IT41134: IN A DPF, MULTI-NODE ENVIRONMENT, A BACKUP TO PIPE WON'T TERMINATE (CTRL+C OR FORCE APP) UNTIL BOTH ENDS OF THE PIPE ARE IN USE | |||
DT147372 | 2 | IT40758: HANG ON FIRST CONNECT DRIVING CRASH RECOVERY WHEN DB2LOGMGR HANGS DUE TO VENDOR PROBLEM | |||
DT148659 | 3 | IT40544: DATABASE NOT SHUTDOWN WHEN LOAD REPLAY FAILS ON HADR STANDBY WITH DB2_FAIL_RECOVERY_ON_TABLESPACE_ERROR ENABLED | |||
DT147546 | 2 | IT40651: DB2LOGGX PROCESS CONSUMING HIGH CPU | |||
DT147368 | 2 | IT40585: ONLINE BACKUP INCLUDE LOGS MIGHT FAIL WITH ADM8010E | |||
DT147543 | 2 | IT40442: ON AIX GETMAXCOMPRESSEDSIZE MIGHT RETURN A TOO LOW VALUE | |||
DT147733 | 2 | IT40474: DB2 ZLIB BACKUP AND LOG FILE COMPRESSION DOES NOT USE HARDWARE ACCELERATION ON UBUNTU | |||
DT140019 | 2 | IT41420: TABLESPACE ROLLFORWARD IS VERY SLOW DUE TO EXCESSIVE NUMBER OF SQLBAFLSH() CALLS | |||
DT147767 | 3 | IT41547: INSTANCE CRASHED WHEN MULTIPLE CONNECTIONS IMPLICITLY ACTIVATE DATABASE WITH DIFFERENT CODEPAGE SETTING. | |||
DT147768 | 2 | IT41626: CRASH RECOVERY AFTER A DATABASE ROLLFORWARD TO POINT IN TIME THAT INCLUDES AN INDOUBT TRANSACTION FAILS WITH SQL1265 (ADM1532E) | |||
DT147876 | 2 | IT38402: DB2 IS FORCED SHUTDOWN WHEN IT ATTEMPTS TO PROCESS XAEND | |||
DT148308 | 2 | IT41729: TRANSACTION MAY NOT BE RESOLVED COMPLETELY IF A TABLESPACE IO ERROR IS ENCOUNTERED DURING RECOVERY WITH DB2_ONLINERECOVERY. | |||
DT147772 | 2 | IT41873: INCORRECT NUMBER OF LOG RECORDS COPIED FROM EXTRACTION LOG FILES | |||
DT148312 | 2 | IT41907: CRASH RECOVERY OF CIRCULAR LOGGING DATABASE FAILS WITH ADM1601E | |||
DT145587 | 2 | IT41639: EXCESSIVE DB2DIAG ENTRY FROM SQLPGRETRIEVELOOKUP | |||
DT147703 | 2 | IT39298: HADR STANDBY ENTERS AN INFINITE LOOP BETWEEN READ FROM MEMORY AND READ FROM DISK | |||
DT142794 | 3 | IT40564: DROP STORE PROCEDURE MIHGT CAUSE TRAP | |||
DT148464 | 3 | IT40526: HADR STANDBY FAILS WITH SQLRLC_FIND_LATCH_ANCHOR() PROBE:5 "INVALID ENTRY_TYPE" CALLED BY SQLPRDBREDOROSCATCACHEINV() | |||
DT148300 | 2 | IT41403: CRASH IN SQLPGETLOGTAILHEARTBEAT() | |||
DT148111 | 2 | IT41071: HADR STANDBY LOG REPLAY CANNOT KEEP UP WITH PRIMARY | |||
DT148663 | 2 | IT40735: DB2ICRT ?TBDEV COMMAND COULD OVERRIDE DISK SCSI-3 DISK CONFIGURATION | |||
Fix Pack m8fp0 - Storage and Compression for Column-Organized Tables | |||||
DT147331 | 2 | IT39064: FODC_Trap when printing mVariableBuffer during out-of-memory error | |||
DT147557 | 2 | IT41115: Query fails with SQL0901N and assertion failure "Evolved dictionary TSN cannot be larger than the last used TSN" | |||
DT132779 | 2 | IT40083: WRONG RESULT IS POSSIBLE IN COLUMNAR QUERY WITH REAL, FLOAT, OR DOUBLE COLUMNS AND RANGE PREDICATES WITH NEGATIVE VALUES | |||
DT147723 | 2 | IT40043: MEMORY LEAK IN COLUMNAR PAGE COMPRESSION CODE | |||
DT148075 | 2 | IT38961: HANG WAITING FOR LATCHES INSERTRANGE__MTABLEWRITERLATCH AND INSERTRANGE__MCONCURRENTINSERTLATCH | |||
DT148505 | 2 | IT41465: ADD ASSERTS TO PREVENT TRAP IN PAGEWRITECALLBACK METHODS | |||
DT148500 | 2 | IT41428: ADDITIONAL DIAGNOSTICS FOR SKILLS CASE TS009760113 (TRAP IN COLUMNDICTIONARYVERSIONBASE::GETSIZE) | |||
DT148491 | 3 | IT41301: ADD ASSERT TO RULE OUT POSSIBLE CAUSE OF Known Issue IT41275 | |||
DT134109 | 3 | IT41211: A TRAP DUE TO A SIGNAL 11 CAN OCCUR IN THE MEMORY CLEAN UP DAEMON. | |||
DT133462 | 2 | IT40407: SQL0954C, SQL0973N, OR OTHER OUT OF MEMORY ERROR WHEN BUILDING COLUMN DICTIONARY FOR LONG STRING COLUMN | |||
DT147732 | 2 | IT40412: PERFORMANCE DEGRADATION IN MPP SETUP WITH SQLCODE: -391 ERRORS IN DB2DIAG.LOG AFTER TRUNCATE WITHOUT IMMEDIATE ON REPLICATED MQT | |||
DT147958 | 2 | IT41486: CONVERT TRAP IN DATABASETABLEACCESSOR::GETCOLUMNDICTIONARYVERSIONBASE TO SQL0901N MESSAGE | |||
DT147765 | 2 | IT41464: SEVERE ERROR AND POSSIBLE MEMORY CORRUPTION DETECTED WHEN FUNCTION SQLRKRPC_FREEMSG TRIES TO FREE MEMORY | |||
DT147369 | 2 | IT40685: LOAD RESETDICTIONARYONLY IS INCOMPATIBLE WITH BLOCKNONLOGGED | |||
DT168621 | 2 | Assertion failure "FreeExtentMarker::isValid(&page) && ( !page.getPageIsForInsertGroup() || FreeExtentMarker::isWithUncondPastRedoInit(&page))" | |||
DT161029 | 2 | INSERT fails with BAD PAGE error due to Reorg Recompress concurrency issue | |||
Fix Pack m8fp0 - Client | |||||
DT171380 | 2 | IT40596: Driver throws ARRAYINDEXOUTOFBOUNDEXCEPTION in SQLJ heterogeneous batch environment | |||
DT171402 | 2 | IT41198: JCC DRIVER RETURNS -204 DUE TO IMPROPER SCHEMA ORDER REPLAY WHENUSING SYSPLEX WLB | |||
DT143276 | 2 | IT41270: ERRORCODE=-4474 RETURNED FROM JCC DRIVER FOR SET CURRENT PACKAGEPATH WHILE REUSING THE CONNECTION FROM THE POOL | |||
DT143251 | 2 | IT41578: IF XAER_RMFAIL RECEIVED WHILE READING A RESULTSET FROM APPLICATION THEN CONNECTIONEVENT LISTENER NEED TO RAISE XAER_RMFAIL EVENT | |||
DT148122 | 2 | IT41418: FEDERATION ZOS DB2 REPORT SQL0181N THE STRING REPRESENTATION OFA DATETIME VALUE ERROR WHEN QUERY WITH DATE AND TIMESTAMP COMPARED | |||
DT160547 | 2 | Setting QUERYPREFETCH=1 causes a segmentaion violation in DB2 ODBC and CLI driver | |||
DT171400 | 2 | IT38691: DECIMAL PRECISION DIFFERENCE IN JDBC WITH ORA & NON-ORA SETTING | |||
DT171385 | 2 | IT39194: INITIAL CONNECTION ERRORS LIKE -4499 ARE NOT COLLECTED IN DIAGNOSTIC DATA THROUGH DB2.JCC.DIAGLEVELEXCEPTIONCODE SETTING | |||
DT171378 | 2 | IT39628: JDBC ERROR "UNRECOGNIZED JDBC TYPE: 2011 ERRORCODE=-4228, SQLSTATE=NULL " WITH JDBC | |||
DT171377 | 2 | IT39269: NOSQLJSON SERIALIZER CRASHES WHEN NULL IS THE VALUE FOR JSON KEY | |||
DT171415 | 2 | IT39268: JSON WIRE LISTENER FAILS WHEN REGEX IS USED IN FIND COMMAND | |||
DT133003 | 2 | IT40903: MEMORY LEAK WHEN SQLGETCONNECTATTR() IS CALLED WITH THE SQL_ATTR_GET_LATEST_MEMBER ARGUMENT | |||
DT171405 | 2 | IT39267: NOSQL JAVA DRIVER THROWS RUNTIMEEXCEPTION FOR $SAMPLE IN AGGREGATE PIPELINE | |||
DT171389 | 2 | IT34348: .NET DRIVER CRASH DUE TO A TIMING HOLE | |||
DT171394 | 2 | IT39265: WIRE LISTENER FAILS TO ACCEPT NEW COMMAND POST EXCEPTION | |||
DT171410 | 2 | IT39266: WIRE LISTENER DO NOT HONOR THE LIMIT OPTION USED WITH FIND COMMAND | |||
DT171401 | 2 | IT39264: ROBO3T MONGODB TOOL THROWS ERROR POST UPDATE OR DELETE OF A JSONDOC IN A COLLECTION | |||
DT171376 | 2 | IT39058: CLPPLUS FAILS TO FLOW COMMIT FOR WARNING CASE SCENARIOS FROM STACOMMAND WHEN RUN AS A SCRIPT | |||
DT171393 | 2 | IT39263: NOSQLBOOSTER TOOL FAILS TO CONNECT TO WIRE LISTENER DUE TO MISSING SUPPORT FOR GETFREEMONITORINGSTATUS COMMAND | |||
DT168593 | 1 | IT40381: TRACEABILITY FOR LINE# AND FILE NAME IN DB2 .NET FOR FW AS WELL AS CORE RUNTIMES TO BE STAMPED IN MEM DIAGNOSTICS. | |||
DT146491 | 1 | IT36527: DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET | |||
DT168594 | 3 | IT41671: IN ODBC ADMINISTRATOR FIX SSL RELATED KEYWORD GUI OPTIONS AND FIX DBALIAS GETTING SAVED IN DB2CLI.INI FILE | |||
DT141609 | 2 | IT41590: INSERTING DECIMAL DATA VIA SQL_C_NUMERIC -> SQL_DECIMAL BIND-IN THROUGH ARRAY INSERT THROWS CLI0111E | |||
DT127662 | 3 | IT40458: RESULTSET.DELETE() METHOD RETURNS CLI0119E WITH SQLSTATE 58004 | |||
Fix Pack m8fp0 - Catalog Services | |||||
DT148083 | 2 | IT39321: SQL0818N CAN OCCUR AFTER A ROLLED BACK REVALIDATION | |||
DT147165 | 2 | IT35294: Authorization errors in accessing CGTTs after a transfer owner of a SQL routine. | |||
DT148072 | 2 | IT38739: MEMORY LEAKS OCCURRING ON COLUMN-ORGANIZED DGTTS | |||
DT142487 | 2 | IT40917: LATCH CONTENTION SQLO_LT_SQLRLC_ANCHOR_COMMON__ANCHOR_LATCH DURING SCHEMA AUTHORITIES CHECKS | |||
DT148677 | 2 | IT41440: DB2 MAY GENERATE FODC TRAP WHILE RUNNING A PROCEDURE | |||
DT147538 | 3 | IT40250: SQLRLC_EXECUTE_EVENT, PROBE:20 IS LOGGED AS ERROR | |||
Fix Pack m8fp0 - Connectivity | |||||
DT148492 | 2 | IT41322: FIXING RCCOPENDUMMYCONNECTION TO USE SQLCC CALLS INSTEAD OF DRDATO ATTEMPT TO OPEN AN SSL CONNECTION WITH TARGET SERVER. | |||
DT147729 | 2 | IT40256: A PREVIOUS SETTING OF CURRENT PACKAGESET MAY BE REUSED WHEN EXECUTING FENCED STORED PROCEDURES WHEN KEEPFENCED IS SET TO YES RES | |||
DT148254 | 2 | IT39347: ERROR ADM7009E AFTER UPGRADING TO 11.5 | |||
DT147890 | 3 | IT39092: UNCATALOG ODBC DOESN'T REMOVE ENTRY FROM DB2CLI.INI | |||
DT117148 | 0 | IT38866: INCORRECT LICENSE CHECK FOR INFORMIX DB WITH TRUSTED CONTEXT RELATED VERIFICATION | |||
DT148442 | 2 | IT39763: MORE ROBUST SIGNAL HANDLING ADDED TO COMMAND LINE OPERATIONS. | |||
DT147520 | 1 | IT39488: MULTI ROW FETCH IN DB2 11.5 LUW MAY NOT GIVE EXPECTED RESULTS | |||
DT147556 | 2 | IT41052: DB2 EXTERNAL TABLE CREATED WITH (SELECT.... LIMIT 0) FAILS WHILEINSERTING ROWS WHEN DB2_ENABLE_COS_SDK PARAMETER IS SET TO ON | |||
DT147394 | 3 | IT41518: LOAD FROM EXTERNAL TABLE FAILS AT 18,993 ROWS | |||
DT148306 | 2 | IT41623: REMOTE CLIENTS MAY NOT BE ABLE TO INTERRUPT QUERIES WITH SSL ONLY SERVER CONFIGURATIONS. | |||
DT148124 | 2 | IT41485: PACRALTSRVLST IS NOT NULL SPAMMING THE DB2DIAG.LOG | |||
DT148682 | 2 | IT41604: CLIENTS FAIL TO RECONNECT TO PURESCALE WITH TCP AND SSL SERVER CONFIGURATION | |||
Fix Pack m8fp0 - Connectivity - External Table | |||||
DT148470 | 2 | IT40634: USE OF EXTERNAL TABLE WITH REMOTESOURCE OPTION AND LOAD CURSOR RESULTS IN A CRASH OF THE DATABASE | |||
DT147901 | 2 | IT39616: EXTERNAL TABLE FIXED FORMAT LOAD FAILURE OF REAL DATA | |||
DT148235 | 3 | IT38615: EXTERNAL TABLE FIXED FORMAT LOAD OF VARCHAR WITH REFERENCE COLUMN 0 FAILS | |||
DT147699 | 2 | IT39208: DB2WH IS INTERPRETING A 0X00 BYTE IN THE DATA AS SIGNALING EOF. | |||
DT146617 | 3 | IT36368: SELECT FROM EXTERNAL FILE FAILS WITH SQL0644N WHEN TABLE IS DEFINED IN A NON-DEFAULT TABLESPACE WITH A DIFFERENT DB PARTITION GR | |||
DT147567 | 2 | IT41475: OVERFLOW OCCURRED WHILE PERFORMING CONVERSION FROM CODEPAGE 923 TO CODEPAGE 1208 FOR COLUMN AT INDEX 44" | |||
DT148796 | 1 | Select from external table might hang when escaped field delim is present in data with LFINSTRING TRUE and CRINSTRING TRUE. | |||
DT160131 | 2 | IT42092: EXTERNAL TABLE LOAD WITH COS AND PARTITION (EXPLICITLY DEFINED PARTITION STRING) CAUSES HANG | |||
DT147344 | 2 | IT39487: EXTERNAL TABLE FIXED FORMAT LOAD OF [VAR]BINARY[N], BLOB[N] FAILING | |||
Fix Pack m8fp0 - Connectivity - Text Search | |||||
DT147761 | 2 | IT41219: DB2 MAY TRAP AFTER SUCCESSFULLY UPDATING A TEXT SEARCH INDEX DUETO AN INCORRECT SQLCA | |||
DT148490 | 3 | IT41228: BAD PLAN CAUSED BY TEXT SEARCH CONTAINS() USING THE DEFAULT FILTER FACTOR | |||
DT146331 | 2 | IT35124: CLASS NOT FOUND EXCEPTION: COM.IBM.DB2.INSTALL.CODEGEN.NLPACK INITIALIZER IN DB2SETUP.ERR | |||
DT147942 | 2 | IT40899: SQL0802 ARITHMETIC OVERFLOW ERROR OCCURS DURING TEXT SEARCH INDEX CREATION | |||
Fix Pack m8fp0 - Data Management | |||||
DT148669 | 2 | IT40885: DEADLOCK BETWEEN TWO DROP TABLE STATEMENTS, EACH EXECUTING ABP'SDROPPED-OBJECT CANCELLATION. | |||
DT148476 | 2 | IT40894: DB2PD -LATCHES COMMAND WITH THE "GROUP" SUBOPTION MIGHT NOT REPORT LATCH HOLDERS CORRECTLY | |||
DT147940 | 2 | IT40872: NOT ALL IMAGE SEQUENCES UPLOADED TO REMOTE STORAGE DURING BACKUPWHEN USING SMALL MULTIPARTSIZEMB | |||
DT148486 | 2 | IT41162: SQLOSSIG, PROBE:10 DB2DIAG.LOG MESSAGE IS WRITTEN TO DB2DIAG.LOG REGARDLESS OF DIAGLEVEL SETTING | |||
DT148110 | 2 | IT40858: PURESCALE: Free space search during insert of a record might endprematurely. | |||
DT148093 | 2 | IT39870: CRM STATUS COMMAND REPORTS INCORRECT STATUS OF RESOURCES" | |||
DT148438 | 2 | IT39703: BUFFER POOL EVENT RECORDER LEAKS MEMORY IF CRASH RECOVERY FAILS | |||
DT148439 | 2 | IT39719: DATA SERVER DRIVER LIBDB2.SO.1 MISSING SYMBOLS ON LINUX X86_64 | |||
DT148649 | 2 | IT40061: BACKUP WITH DB2_RESOURCE_POLICY ENABLED MAY IMPACT SYSTEM PERFORMANCE MORE THAN WHEN DISABLED | |||
DT172292 | 2 | Running the LOAD command from 11.5.7 client to earlier-level11.5.x server (i.e. 11.5.0 to 11.5.6) fails | |||
DT147902 | 2 | IT39747: AVOID DB2 CRASH IF INSTANCE RUNS OUT OF FILE HANDLES. | |||
DT148063 | 2 | IT38384: DB2 ABENDS WHILE PAGE CLEANER EXECUTING SQLBCLNRGATHERFORHATETHRESH | |||
DT148242 | 2 | IT39050: BUFFER POOL PAGE PINCOUNT LEAKED DURING PAGE P-LOCK ACQUISITION | |||
DT148269 | 2 | IT40222: DB2 CRASH IN DB2PERF!SQLONTPPUTMSG | |||
DT097587 | 2 | IT36242: ADMIN_GET_MSGS() MAY RETURN MIX OF MESSAGE UNDER RARE TIMING HOLE. | |||
DT148228 | 3 | IT38409: NO WARNING MESSAGE WHEN DMS TABLESPACE CANNOT BE IMMEDI | |||
DT147661 | 1 | IT37712: SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE UNDER CERTAIN CIRCUMSTANCES WITH LOAD UTILITY (CVE-2021-20373) | |||
DT147924 | 2 | IT40275: DB2 BACKUPS FAIL WITH SQL2025N AN I/O ERROR OCCURRED. ERROR CODE: "-2029059658" WHEN STREAMING IS ENABLED | |||
DT148495 | 2 | IT41384: DB2 ENTERPRISE SERVER (DB2ESE) COMPLIANCE REPORT SHOW INDEX COMPRESSION LICENSE VIOLATION ON V11.5.6 AND 11.5.7 | |||
DT147728 | 2 | IT40226: HANG CAN OCCUR WITH INTRA_PARALLELISM ENABLED WHEN INDEX GETS CREATED | |||
DT148236 | 2 | IT38684: MEMBER CRASH RECOVERY MIGHT FAIL OR TABLE DATA COULD BE BAD IF CRASH OCCURS WHILE ONLINE TABLE REORGANIZATION IS RUNNING | |||
DT147553 | 2 | IT40806: TRUNCATING TABLE SPACE FILES (SQLSPCS.1/2) LARGER THAN 4GB MAY FAIL | |||
DT148657 | 2 | IT40520: SQLO_URL_UNKNOWN_HEADER RETURNED WHEN S3 BUCKET IS USING KMS ENCRYPTION | |||
DT148123 | 2 | IT41429: DB2_RESOURCE_POLICY DOESN'T WORK WITH DB2 ADVANCED EDITION | |||
DT148292 | 2 | IT41038: POSSIBLE DEADLATCH IN SQLOMEMINIT() WHEN IT LOADS CLIENT-SIDE LIBRARY | |||
DT147925 | 2 | IT40291: DB2PD -HELP RETURNS INCORRECT OPTION SYNTAX FOR -TCBSTATS | |||
DT148654 | 2 | IT40293: "GRANT DATAACCESS ON SCHEMA" PREVENTS LOAD WHEN MODIFIED BY "DUMPFILE DUMPFILEACCESSALL" | |||
DT148472 | 2 | IT40804: AUTO TABLE MAINTENANCE DB2ACD PROCESS FAILS TO CONNECT TO DATABASE WHEN DB2CLI.INI CONFIGURED TO ENFORCE TCP CONNECTIONS | |||
DT171404 | 2 | IT39128: CRASH WHILE CREATING ODBC DATA SOURCES FILE DSN ON WINDOWS PLATFORM USING DB2 ODBC CLI DRIVER | |||
Fix Pack m8fp0 - Data Management: Bufferpool | |||||
DT148474 | 2 | IT40819: REORG NOT RECLAIMING EXTENTS FOR ITC TABLES EFFICIENTLY. | |||
DT147918 | 2 | IT40063: DGTT MAY FAIL WITH SQL0289N WHEN UNDERLYING TEMP TABLE SPACE DEFINED IN LARGE FILESYSTEM | |||
DT147536 | 2 | IT40191: BLOCK CREATING BUFFERPOOLS WITH THE SAME NAME AS THE SYSTEM BUFFERPOOLS | |||
Fix Pack m8fp0 - Data Movement Utilities | |||||
DT148078 | 3 | IT39114: ADMIN_MOVE_TABLE ESTIMATE IS INCOMPATIBLE WITH BLOCKNONLOGGED | |||
DT147321 | 3 | IT38560: INGEST RESULT OUTPUT WRONGLY SHOWS "NUMBER OF ROWS INSERTED = 0"INSTEAD OF "NUMBER OF ROWS UPDATED / DELETED = <NUM>" | |||
DT147688 | 2 | IT38790: THE ADMIN_MOVE_TABLE PROCEDURE MAY STUCK IN CANCEL PHASE. | |||
DT147533 | 2 | IT39993: STRIPTNULLS MODIFIER IN LOAD AND IMPORT COMMANDS TRUNCATE NULLS (0X00) FROM GRAPHIC (FIXED-LENGTH) COLUMN, BUT IT SHOULD NOT | |||
DT148238 | 2 | IT38893: ADMIN_MOVE_TABLE WITH COPY_STATS MIGHT INVOKE LONG RUNNING RUNSTATS | |||
DT147390 | 2 | IT41348: DB2MOVE RETURNS SQL0206 WHEN EXECUTE INVALID STATEMENT SELECT OWNERTYPE FROM SYSIBM.SYSROUTINES | |||
DT147929 | 2 | IT40463: ADMIN_MOVE_TABLE RETURNS SQL20491N RC 6 FOR USER MAINTAINED TEMPORAL TABLES | |||
DT147878 | 2 | IT38519: ADMIN_MOVE_TABLE MIGHT FAIL IF TABLE HAS STATISTICS PROFILE CONTAINING COLUMN NAMES WITH SINGLE QUOTES | |||
DT148279 | 2 | IT40604: ADMIN_MOVE_TABLE COPY_STATS MIGHT FAIL IF SYSSTAT.COLDIST CONTAINS NON-PRINTABLE CHARACTERS | |||
Fix Pack m8fp0 - Deployment | |||||
DT054546 | 4 | IT31631: CREATE .PROFILE IF IT DOESN'T EXIST WHEN RUNNING DB2ICRT (CREATEINSTANCE) | |||
DT148048 | 4 | IT37187: ADD REQUIRED GPFS PACKAGE NET-TOOLS RPM TO DB2PREREQCHECK | |||
DT148466 | 4 | IT40553: DB2IUPDT -CHECK_COMMIT COMMAND DOES NOT RETURN MEANINGFUL ERROR | |||
DT147224 | 4 | IT28668: THE COMPONENTLIST_SERVER_T.HTM FILE AND DB2LS -Q COMMAND OUTPUT ARE INCONSISTENT | |||
DT147713 | 4 | IT39760: ON AIX WHEN A SCRIPT NEEDS TO EXECUTE DB2PROFILE IN A LOOP, LIBPATH HAS MULTIPLE REFERENCES TO GSKIT | |||
DT148272 | 4 | IT40294: WHEN RUN DB2SETUP OR DB2ICRT ON AIX, THE OUTPUT MAY BE CORRUPTED. | |||
DT072515 | 2 | IT33388: V11.5 DB2IUPGRADE DOES NOT CHANGE SUB DIRECTORIES' PERMISSION UNDER SQLLIB PROPERLY | |||
DT147824 | 4 | IT32790: DB2_DEINSTALL NON-PURESCALE COPY OF DB2 CHANGES CONFIGURATION OFGPFS USER MANAGED CLUSTER | |||
DT146371 | 2 | IT37290: IN-PLACE INSTALLFIXPACK MINOR ERROR WITH DAS | |||
DT147529 | 2 | IT39904: DB2PD -STACK ALL IS NOT WORKING ON WINDOWS | |||
DT148433 | 1 | IT39389: SECURITY: APACHE LOG4J REMOTE CODE EXECUTION - LOG4SHELL (CVE-2021-44228, CVE-2021-4104) | |||
DT147343 | 2 | IT39404: CLIENT CONNECTIONS SLOW TO DATABASE SERVER | |||
DT147275 | 3 | IT36769: DB2FMCD.SERVICES GETS DELETED IF THERE ARE TWO DB2 SETUPS AND ONE GETS REMOVED | |||
DT159579 | 1 | IT31637: SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204) | |||
DT147135 | 3 | IT34243: DB2CLUSTER -CFS -COMMIT FAILS, INSTALL SHOULD GENERATE A WARNING | |||
DT148303 | 2 | IT41487: INSTALLFIXPACK DELETES /ETC/SYSTEMD/SYSTEM/DB2FMCD.SERVICE FILE ON LINUX | |||
DT148092 | 4 | IT39766: DB2PREREQCHECK WITH THE -HL OPTION FAILS IF THE CONTENTS OF THE HOSTS FILE ARE NOT CORRECT | |||
DT147900 | 3 | IT39752: DB2ICRT & DB2IUPDT MAKE USE OF THE /DB2LOG DIRECTORY AND MAY OVERWRITE IT | |||
Fix Pack m8fp0 - Federation | |||||
DT148451 | 2 | IT40161: REMOTE STATEMENT HAS WRONG ORDER BY COLUMN SINCE V11.1 | |||
DT147948 | 2 | IT41139: DB2 FEDERATION RETURNS BLANK SQLSTATE FOR SQLCODE=100 THAT WILL CAUSE WRONG ERROR MESSAGE OF NICKNAME IUD | |||
DT148673 | 2 | IT41019: FEDERATION: POSSIBLE -430 ERROR WHEN CONNECTING MYSQL-CE VIA JDBC CONNECTIONWITH JRE VERSION 1.8.0 BUILD 8.0.7.5 (SR7 FP5) | |||
DT147730 | 2 | IT40261: FEDERATION: COLUMN LENGTH AUTO VARIATION (COLUMN_LENGTH_AUTO_VARIATION) CANNOT BE DISABLED WHEN TARGET DATABASE IS ORCALE | |||
DT147927 | 2 | IT40384: FEDERATION: ORACLE DATA SOURCE, CREATE NICKNAME TOO MANY TIMES MIGHT CAUSE "ORA-01000: MAXIMUM OPEN CURSORS EXCEEDED" ERROR | |||
DT148105 | 2 | IT40372: FEDERATION FAILED TO GET ZOS DB2 COBOL PROCEDURE PARAMETERS | |||
DT147523 | 2 | IT39544: GRAPHIC AND CHARACTER CONVERTS WRONG WHEN CODEPAGES OF FEDEDERATION DB AND REMOTE DB ARE DIFFERENT | |||
DT147897 | 4 | IT39474: SECURITY: Multiple vulnerabilities in Apache Log4j affect some features of IBM Db2 (CVE-2021-45046, CVE-2021-45105) | |||
DT147563 | 2 | IT41289: MEMORY LEAK IN SQLQG_MISC_FMP.C WHILE IMPORT DATA INTO NICKNAME WHEN WRAPPER OPTION "DB2_FENCED' TO 'Y' | |||
DT147330 | 2 | IT39055: FEDERATION CREATE SERVER TYPE OPTIMIZATION FOR ODBC WRAPPER | |||
DT148679 | 2 | IT41542: FEDERATION SQL0802N ARITHMETIC OVERFLOW OR OTHER ARITHMETIC EXCEPTION OCCURRED | |||
DT148307 | 1 | IT41637: IN DPF ENVIRONMENT, FEDERATION FMP COULD BE INTERPRETED BY OTHERINTERRUPT REQUEST FROM DB2 ENGINE. | |||
DT148305 | 2 | IT41617: DB2 NICKNAME CREATION FOR TABLE OR VIEW IN REMOTE AWS ATHENA FAILS WITH SQL1822N AFTER UPGRADING JAVA IN AIX | |||
DT147392 | 2 | IT41496: FEDERATION MSSQL SERVER SQL0142N THE SQL STATEMENT IS NOT SUPPORTED | |||
DT148299 | 2 | IT41331: CLI0125E FUNCTION SEQUENCE ERROR DUE TO DRDA_STATEMENT NOT OPEN | |||
DT148087 | 2 | IT39471: DB2V115_START.KSH: FAILS TO FIND SERVICE PORT ON NON-ENGLISH LOCALE | |||
DT148502 | 2 | IT41644: SQL1822 ON FEDERATION SERVER BETWEEN UTF8 AND ISO-1 DATABASE WHEN THE SERVER OPTION IS STRING_UNITS 'S' | |||
Fix Pack m8fp0 - Process Model | |||||
DT147938 | 2 | IT40749: ONLINE BACKUP MAY FAIL WITH SQL5193N IF DATABASE IS CREATED IN RESTRICTIVE MODE | |||
DT148671 | 2 | IT40926: DB2EVMONFMT MAY FAIL WITH SQLCODE=-104 WHEN USING THE -WTT OPTION | |||
DT147384 | 2 | IT41130: INSTANCE CRASH IN SQLMON_STMT::ESTIM_STMT_INFO_SZ | |||
DT147731 | 2 | IT40287: THRESHOLD DOES NOT FIRE WHEN CONCUR_OVERFLOW_ENABLED AND CONCUR_OVERFLOW_MAX ENABLED | |||
DT148460 | 2 | IT40343: DB2 CRASHES IN SQLECHECKBREATHINGPOINTWLMTHRESHOLD DURING SET WRITE RESUME | |||
DT147911 | 3 | IT39981: LIST ACTIVE DATABASE SHOWED DB NAME , EVEN IF DATABASE WAS DEACTIVATED | |||
DT147483 | 2 | IT37396: IN DPF SQL USING EARLY CLOSE MAY INCREASE FCM BUFFERS UNTIL APPLICATION TERMINATION | |||
DT147921 | 2 | IT40154: THE MON_GET_PKG_CACHE_STMT TABLE FUNCTION MAY TRAP WHEN AN SQL STATEMENT HAS COMMENTS > 10K AND STMT_CONC IS SET TO COMM_LIT | |||
DT147917 | 2 | IT40049: THE MAXIMUM NUMBER OF FCM SESSIONS IS NOT SET PROPERLY ON AIX | |||
DT147357 | 2 | IT40122: "FODC PANIC DUE TO STALE POINTER IN SQLEUCBLASTDIAGPOOL" | |||
DT147909 | 2 | IT39957: APPLICATION MAY HANG IN GETFASTWRITERRECORD IF THE INTERNAL POOLFOR EVENT MONITORING IS EXHAUSTED. | |||
DT147907 | 2 | IT39938: POSSIBLE MEMORY CORRUPTION WHEN CALLING PD_GET_DIAG_HIST | |||
DT148635 | 2 | IT39473: ARCHIVING DB2DIAG.LOG AND NOTIFICATION LOG (*.NFY) CAN LEAD TO DOUBLE FREE IN SQLRWCLEANUPWLMSCRATCHPAD WHEN RUNNING PD_GET_DIAG | |||
DT147906 | 2 | IT39877: DB2START IS FAILED WITH -1677 ERROR WHEN EACH MEMBER HAS A CONFIGURED INSTANCE_MEMORY VALUE AND THERE IS A GLOBAL INSTANCE_MEMOR | |||
DT147651 | 2 | IT37104: POSSIBLE TRAP FOLLOWING DB2DIAG.LOG MESSAGE "TRYING TO REGIS | |||
DT148255 | 2 | IT39331: STATS_ROWS_MODIFIES REPORTS 4294967295 FROM MON_GET_TABLE AND ADMIN_GET_TAB_INFO | |||
DT147336 | 1 | IT39184: IF MONHEAP IS EXHAUSTED SQL STATEMENTS MAY RECEIVE SQL0973N FOR MON_HEAP_SZ | |||
DT120319 | 1 | IT39148: IPC connection to Db2 11.5 FP6 from a downlevel client might fail with -1224 and SQLO_NOSEG+EACCESS error logged to db2diag.log | |||
DT148263 | 2 | IT39875: LOCKING EVENT MONITOR "DROPPED RECORD" EVENT LEADS TO THE FLOOD OF DB2DIAG.LOG WARNING MESSAGES | |||
DT148489 | 2 | IT41227: WHEN THE ATS FAILS TO RUN A TASK, IN SOME CASES THE TASK MAY REMAIN IN RUNNING STATE | |||
DT147939 | 2 | IT40849: APPLICATION MAY HANG IN WaitSendReady WHEN SENDING AN RPC MESSAGE | |||
DT147937 | 1 | IT40723: DB2STOP MAY TIMEOUT ON A PARTITIONED DATABASE DUE TO A LATCHING PROTOCOL PROBLEM | |||
DT148283 | 2 | IT40670: SQL1611W - NO DATA WAS RETURNED BY DATABASE SYSTEM MONITOR FOR "DB2 LIST ACTIVE DATABASES" DURING SET WRITE SUSPEND. | |||
DT147740 | 2 | IT40614: SQL0952N MIGHT HAPPEN WHEN REAL-TIME STATISTICS IS ENABLED FOR COLUMN-ORGANIZED TABLES | |||
DT147366 | 2 | IT40515: DB2ACD FAILS TO EXECUTE SCHEDULED TASKS WHEN THERE IS A DB2CLI.INI FILE | |||
DT148678 | 3 | IT41503: MONITOR ELEMENTS IN THE ACTIVITY EVENT MONITOR THAT DEPEND ON SNAPSHOT MAY BE INCORRECT FOR CREATE/DECLARE TABLE AS STATEMENTS | |||
DT147959 | 2 | IT41546: PERFORMANCE IS AFFECTED BY LATCH CONTENTION WHEN INPUT DATA VALUE CAPTURE IS ENABLED FOR A LOCKING EVENT MONITOR | |||
DT148310 | 2 | IT41782: CON_LOCAL_DBASES COUNTER IN MON_GET_INSTANCE MAY RETURN AN INCORRECT VALUE IF A DATABASE IS DEACTIVATED WHILE QUIESCED | |||
DT147770 | 2 | IT41807: DB2 TRAPS IN MON_GET_PKG_CACHE_STMT ON WINDOWS | |||
DT147745 | 1 | IT40751: RARE TIMING SCENARIO IN UPGRADE OF PURESCALE CLUSTERS CAN PREVENT CF MEMORY ALLOCATIONS FROM BEING ADJUSTED AUTOMATICALLY | |||
DT147385 | 2 | IT41143: POSSIBLE MEMORY LEAK USING PD_GET_DIAG_HIST() | |||
DT147387 | 2 | IT41259: GW_* METRICS ARE ZERO IN MON_GET_INSTANCE | |||
DT147570 | 2 | IT41556: WHEN USING AUTOSTART WRITE TO TABLE EVENT MONITORS, DATABASE ACTIVATION MAY HANG OR BE DELAYED IF A Z LOCK IS HELD ON ONE OF THE | |||
DT148296 | 2 | IT41222: IMPROVE DIAGNOSTICS FOR FCM DOUBLE FREE OF A CHANNEL | |||
Fix Pack m8fp0 - Query Compiler | |||||
DT171386 | 2 | IT39262: WIRELISTENER THROWS EXCEPTION WHEN AGGREGATE PIPELINE CONTAINS $INDEXSTATS | |||
DT058197 | 2 | IT31963: BAD PERFORMANCE FOR MODIFYING QUERIES DUE TO NO SEMIJOIN REWRITE | |||
DT147943 | 2 | IT40984: PERFORMANCE (HANG) ISSUE WHILE PROCESSING STACK OF NESTED TABLESWITH COMPLEX EXPRESSIONS | |||
DT147738 | 2 | IT40537: A FULL OUTER JOIN QUERY MAY PRODUCE A -901 WITH THE REASON "EMPTY PLAN LIST DETECTED!" | |||
DT146727 | 2 | IT35054: COLUMN-ORGANIZED EARLY UNIQUE AND SEMIJOIN TOGETHER RESULT IN SQLCODE -901 | |||
DT148284 | 2 | IT40755: SQLCODE -901 MAY OCCUR WITH MESSAGE "EMPTY PLAN LIST DETECTED" WHEN COMPILING A CDE QUERY | |||
DT133017 | 2 | IT41027: CARDINALITY MIGHT BE OVERESTIMATED WHEN TABLE CARDINALITY BOUND ADJUSTMENTS ARE ENABLED AND JOIN CYCLES ARE PRESENT" | |||
DT147952 | 2 | IT41223: ISSUING A CREATE TABLE QUERY MAY CAUSE THE SERVER TO TERMINATE ABNORMALLY ON AIX | |||
DT147758 | 2 | IT41082: DB2 SERVER TERMINATES ABNORMALLY WHEN STATEMENT CONCENTRATOR ENABLED | |||
DT147756 | 2 | IT41124: POOR PERFORMANCE FOR NLJOIN IN CDE | |||
DT148294 | 4 | IT41132: DB2 QUERY MAY GENERATE 901 WHEN MULTIPLE NOTIN SUBQUERY EXISTS. | |||
DT132815 | 4 | IT41028: ISSUING A SELECT QUERY MAY ENTERS AN INFINITE LOOP | |||
DT148115 | 4 | IT41113: -901 UNEXPECTED ERROR AT GETJOINPAYLOADEVALUATOR.CPP | |||
DT148112 | 4 | IT41083: Possible trap in sqlnq_scalar_aggregate() when using LISTAGG() WITHIN GROUP() | |||
DT147544 | 4 | IT40456: SQL0158 OR SQL0421 QUERYING FROM VIEW OVER TEMPORAL TABLE AFTER ADDING NEW COLUMN | |||
DT147711 | 4 | IT39621: POSSIBLE PERFORMANCE PROBLEMS FOR INSERT STATEMENTS WITH COMMON-TABLE EXPRESSIONS | |||
DT148079 | 4 | IT39136: NON-PUSHDOWNABLE HASH JOIN ELIGIBLE PREDICATES INVOLVING NICKNAMES MAY BE USED SUB-OPTIMALLY | |||
DT147346 | 4 | IT39586: THE OPTIMIZER MIGHT FAVOUR A NON-OPTIMAL PLAN WITH REGISTRY VARIABLE DB2_EXTENDED_OPTIMIZATION=NLJN_OFLOW | |||
DT148437 | 4 | IT39643: GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSINGCLAUSE MAY RETURN -901 | |||
DT148259 | 4 | IT39673: TRAP/901/HANG WHEN DB2 QUERY HAS CORRELATED IN PREDICATE IN SELECT. | |||
DT159650 | 4 | IT31973: DB2 SERVER TERMINATES ABNORMALLY PREPARING DECLARE GLOBAL TEMP TABLE STATEMENT | |||
DT147260 | 4 | IT35986: SELECT WITH GRANT FAILED TO GRANT FOR A VIEW WITH VALUES. | |||
DT147682 | 4 | IT38518: DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES WITH MULTIPLE OUTER JOINS | |||
DT147722 | 4 | IT40040: SPURIOUS ERROR MESSAGE IN DB2DIAG.LOG WHEN RUNNING DB2ADVIS | |||
DT147067 | 2 | IT38191: COMPILED TRIGGER REVALIDATION FAILS WITH SQL0901 "INVALID COMPILE ENV: CATALOG INDEX KEY VIOLATION" | |||
DT147981 | 2 | IT23350: DB2 MAY RETURN SQL0901N: EMPTY PLAN LIST DETECTED | |||
DT068582 | 2 | IT32990: UNQUALIFIED COLUMN REFERENCE WITH USING CLAUSE ON VIEW RETURNS SQLCODE=-206 | |||
DT147522 | 2 | IT39520: MERGE STATEMENT REFERENCING MATERIALIZED QUERY TABLES (MQTS) MAYFAIL WITH SQL0407N | |||
DT146510 | 2 | IT37983: POSSIBLE DB2 TRAP IN PSMGETVALIDBREAKPOINTS() WHEN CALLING SYSIBMINTERNAL.ADMIN_GET_VALID_BREAKPOINTS() | |||
DT146902 | 2 | IT37611: DB2 MAY PRODUCE WRONG RESULT ON UPDATE STATEMENT WITH VIEW DEPENDENCY | |||
DT147884 | 2 | IT38797: QUERY FAILS WITH ERROR SQL0901N "NLJN LOJ INNER NOT NULLABLE" | |||
DT148631 | 2 | IT39334: SQL0952N ERROR SHOULD BE RAISED INSTEAD OF PRODUCING FODC_APPERRAND SQL0901N" | |||
DT146220 | 2 | IT37458: SELECT STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT") | |||
DT146377 | 2 | IT38190: TRAP ON SQLNO_COL_WIDTH_INLINE | |||
DT148625 | 2 | IT38996: INSERTING DECIMAL MINUS ZERO INTO COLUMN ORGANIZED TABLE LEADS TO WRONG RESULT ON POWERPC | |||
DT148095 | 2 | IT39883: POOR PERFORMANCE WHEN FEDERATED TABLE JOINED WITH CDE TABLE | |||
DT148648 | 2 | IT40051: DB2 SERVER COULD TERMINATES ABNORMALLY OR GET -301 WHEN RU | |||
DT148099 | 3 | IT40003: DB2 QUERY MAY GENERATE 901 WHEN GROUP BY COLUMNS ARE UNUSED. | |||
DT147298 | 3 | IT37707: INSERT INTO COLUMN-ORGANIZED TABLE WITH SUB-SELECT REFERENCING THE TARGET OF THE INSERT MAY RETURN INCORRECT RESULTS IN DPF SYST | |||
DT147354 | 2 | IT39978: POOR PERFORMANCE OF DB2 QUERY HAVING OR PREDICATE ON AND WITH EXPRESSION. | |||
DT147168 | 2 | IT35538: TRAP WHEN MULTIPLE UNION BRANCHES WITH SAME TABLE | |||
DT159586 | 2 | IT33263: DB2 CREATE TABLE STATEMENT MAY ABEND WHEN DB2_DEFAULT_TABLE_DISTRIBUTION IS RANDOM. | |||
DT148643 | 2 | IT39807: INCORRECT RESULTS MIGHT BE RETURN FOR COUNT/COUNT_BIG OVER() SCALAR AGGREGATE FUNCTION UNDER AN OUTER JOIN | |||
DT146511 | 2 | IT38210: DB2 SERVER TERMINATES ABNORMALLY IN RECURSIVE_QGM | |||
DT148088 | 2 | IT39559: DB2 ENGINE MIGHT HANG WHEN UPDATING STATISTICS FOR INDEXES ON XML COLUMNS | |||
DT147710 | 3 | IT39560: QUERY SUCCCEED BUT GET ERROR MESSAGE WINNING PLAN STILL NEEDS GLUE IN DB2DIAG.LOG | |||
DT147873 | 3 | IT38215: SELECT-STATEMENT WITH WHERE-CLAUSE, FETCH-CLAUSE AND UPDATE-CLAUSE FAILS WITH SQLCODE -511 | |||
DT147896 | 2 | IT39337: INSERT statement performs poorly when source fullselect includesUNION ALL and fetch-clause | |||
DT159446 | 2 | IT34007: DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE. | |||
DT148207 | 2 | IT36857: DB2 ALTER TABLE QUERY MAY FAIL WITH SQL0109N ERROR | |||
DT117977 | 2 | IT38967: OPTGUIDELINES ARE NOT SUPPORTED FOR SET INTEGRITY STATEMENTS. | |||
DT148628 | 3 | IT39218: DB2 QUERY MAY GENERATE SQLCODE -901 WHEN LEFT/RIGHT OUTER JOIN PREDICATE ON EXPRESSION. | |||
DT148253 | 2 | IT39344: DB2 QUERY MAY GENERATE 901 WHEN SCALAR SUBQUERY HAS DISTINCT ANDFETHC FIRST 1 ROW. | |||
DT148434 | 2 | TRIM AND STRIP SCALAR FUNCTION RESOLUTION IGNORES CURRENT PATH | |||
DT147378 | 2 | INCORRECT RESULT WHEN DB2 QUERY HAS EQUAL PREDICATES WITH CONSTANTS | |||
DT147754 | 2 | TRAP WHEN UNION AND REFERENCE TO SAME SUBSELECT IN DB2 QUERY | |||
DT147889 | 2 | ABNORMAL TERMINATION OF QUERY WITH COMMON TABLE EXPRESSION | |||
DT147705 | 3 | IT39354: SPECIFIC MQT DEFINITION MAY LEAD TO DB2 ABEND WITH SIG11 | |||
DT146378 | 2 | IT38199: INCORRECT "TYPE" VALUE IN IMPLICITVALUE COLUMN OF SYSCAT.COLUMNSFOR ROW CHANGE TIMESTAMP, ROW END OR TRANSACTION START ID COLUMN | |||
DT147696 | 2 | IT38984: SQL0901N ERROR WHEN FETCH-CLAUSE OR OFFSET-CLAUSE INCLUDES A SCALAR FULLSELECT. | |||
DT147676 | 3 | IT38217: QUERY COMPILATION FAILS WITH SQLCODE -421 WHEN OLAP SPECIFICATION USED AS ARGUMENT TO INLINED SQL FUNCTION | |||
DT147309 | 3 | IT38214: MERGE STATEMENT RETURNS SQLCODE -206 WITH EMPTY OR WRONG COLUMN NAME | |||
DT148241 | 2 | IT38992: SEGV IN SQLKBFIX WHEN EXECUTING QUERY INVOLVING XML DATA AND AGGREGATION IN AN MPP CONFIGURATION | |||
DT148245 | 2 | IT39185: OPTIMIZER USES QUANTILE STATS FOR UNIQUE COLUMNS TO COMPUTE THE EQUALITY PREDICATE FILTER FACTOR WHICH LEADS TO OVER-ESTIMATION | |||
DT147524 | 2 | IT39550: DB2 SERVER MAY TERMINATE ABNORMALLY ISSUING ILLEGAL SQL STATEMENT | |||
DT146227 | 2 | IT38184: INCORRECT PROCESSING OF ROWID IS USED IN A SUBSELECT MAY PRODUCEA -901 WITH ERROR MinMaxPartialEvaluator.cpp : 99 | |||
DT147393 | 2 | IT41517: QUERY PERFORMANCE MAY VARY WHEN USING OUTER JOIN OPERATOR | |||
DT147382 | 2 | IT41054: POSSIBLE PERFORMANCE ISSUES FOR CORRELATED QUERIES WHEN MIGRATING TO DPF SYSTEMS | |||
DT147551 | 2 | IT40888: LIKE PREDICATES IMPROVEMENTS | |||
DT134914 | 2 | IT41317: -901 WHEN COMMON TABLE EXPRESSION USED IN JOIN. | |||
DT148385 | 2 | IT37178: A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP | |||
DT146335 | 2 | IT35178: DB2 MIGHT ABEND WHEN EXECUTING A QUERY USING FIRST_VALUE AND REFERENCING TABLES ORGANIZED BY COLUMN | |||
DT148114 | 2 | IT41104: POSSIBLE 901 ERROR WHEN RUNNING QUERY WITH TEXT SEARCH FUNCTION | |||
DT147719 | 2 | IT39905: LONG RUNNING QUERY WITH COMPLEX CASE EXPRESSIONS HANGS AT COMPILE TIME | |||
DT146726 | 2 | IT35045: PACKAGE CONTAINING XML FUNCTIONS MAY RESULT IN -901 WHEN REBINDING WITH APREUSE | |||
DT148485 | 3 | IT41140: WRONG RESULT WHEN PREDICATE WITH CONSTANT ON AGGREGATE FUNCTION WITH CASE. | |||
DT147934 | 1 | IT40646: EQUALITY PREDICATES CONTAINING COALESCE EXPRESSIONS COULD HAVE INACCURATE FILTER FACTOR ESTIMATES. | |||
DT148457 | 2 | IT40288: OPTIMIZER USES EMPTY QUANTILE STATS LEADING TO CARDINALITY UNDER-ESTIMATION | |||
DT147936 | 2 | IT40676: OPTIMIZER MAY GENERATE A NEW TYPE OF PLAN BECAUSE OF HOW INDEX ORING PLANS ARE BUILT BETWEEN 9.7 AND 10.5 | |||
DT148276 | 2 | IT40414: POSSIBLE TRAP (SEGV) IN PSM_DECLARE_VARIABLE_NODE() OR PSM_GEN_ROW_FIELD_VARIABLE() TRYING TO CREATE A PROCEDURE WITH A COMPLEX | |||
DT146224 | 2 | IT37893: DB2 MAY CRASH WHEN IT REPORTS COORDDB IS NULL | |||
DT147999 | 3 | IT31325: DB2EXFMT MAY HANG WITH SQL LONGER THAN 4096 AND COMMA OCCURS AT POSITION 4096 IN THE FORMATTED ORIGINAL STATEMENT | |||
DT055930 | 2 | IT31761: QUERY WITH STRING CAST FAILS WITH -901 "UNEXPECTED ERROR AT GETJOINPAYLOADEVALUATOR.CPP" | |||
DT148104 | 1 | IT40326: DB2 MAY TRAP WHEN RUNNING UPDATE STATEMENT THAT CONTAINS SPECIALCHARACTERS. | |||
DT142838 | 2 | IT40238: INSTANCE MAY CRASH DURING QUERY COMPILATION | |||
DT147956 | 3 | IT41466: DB2SUPPORT WITH THE -CL 2 OR -CL 3 OPTION CAN UNDER SOME CIRCUMSTANCES RESULT IN A SEGV TRAP | |||
DT146312 | 1 | IT34338: POSSIBLE PERFORMACE REGRESSION DUE TO OUTER JOIN - INNER JOIN REORDERING | |||
DT148506 | 2 | IT41713: INCORRECT RESULT WHEN CORRELATED PREDICATE ON PRIMARY KEY OF A TABLE. | |||
DT148086 | 2 | IT39524: DB2 SERVER MAY TERMINATE ABNORMALLY WHEN USING SUBSTR | |||
DT146899 | 2 | IT37308: DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ISSUING A SELECT QUERY | |||
DT148277 | 2 | IT40464: QUERY MIGHT TRAP IN DATA PARTITION ELIMINATION OF A ZIGZAG JOIN | |||
DT147352 | 2 | IT39906: POTENTIALLY BAD PERFORMANCE WHEN USING PARAMETER MARKERS IN QUERIES CONTAINING JOINS | |||
DT148127 | 2 | IT41735: XMLAGG WITH XMLQUERY INPUT AND GROUP-BY-CLAUSE MAY FAIL WITH -901 "BAD PLAN; UNRESOLVED QNC FOUND" | |||
DT148424 | 2 | IT38952: XML NODE MANAGER THROWS -901 ERROR WHILE RUNNING MANUAL RUNSTATSON XML TABLE." | |||
DT148510 | 2 | IT41821: QUERY WITH "WHERE RID() = <CONSTANT>" PREDICATE MIGHT RETURN INCORRECT RESULTS IN MPP | |||
DT147955 | 1 | IT41312: SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE AFTER ENTERING A MALFORMED SQL STATEMENT INTO THE DB2EXPLN TOOL | |||
DT148501 | 2 | IT41456: SQL0433N ON RETRIEVAL ASSIGNMENT WHEN DBCLOB CAST TO VARCHAR | |||
DT147753 | 3 | IT40953: "EXPLAIN PLAN FOR" DOES NOT WORK FOR TEXT SEARCH QUERY | |||
DT148021 | 2 | IT35030: DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER | |||
DT147626 | 2 | IT35043: SQL0901N ERROR MAY OCCUR WHEN COMMON TABLE EXPRESSION HAS "SYSPUBLIC" SCHEMA NAME | |||
DT147675 | 2 | IT38198: COMPILING A SQL QUERY THAT INCLUDES A SQL UDF WITH OLAP INPUT MAY INCORRECTLY RETURN SQLCODE -206 | |||
DT146640 | 3 | IT38211: DROP PACKAGE FAILS WITH SQL0553N WHEN "PL/SQL SUPPORT" IS ENABLED | |||
DT148488 | 2 | IT41215: STATICASDYNAMIC OPTION NOT SUPPORTED FOR COMPILED SQL OBJECTS | |||
DT148641 | 2 | IT39702: DB2 MAY COPY SELECTIVITY WHEN A SELECTIVITY CLAUSE IS USED ON A PREDICATE THAT'S COLUMN EQUIVALENT (C1=C2 AND C1=C3) | |||
DT148487 | 2 | IT41205: SLOW PERFORMANCE MIGHT BE OBSERVED WHEN RUNNING AN IUD STATEMENTWITH CERTAIN CHARACTERISTICS | |||
DT147560 | 3 | IT41220: DB2 MAY ABEND WHEN UNION HAS BOTH PUSHDOWNABLE AND NON PUSHDOWNABLE BRANCH | |||
DT148496 | 3 | IT41386: POOR PERFORMANCE WHEN IN SUBQUERY USES THE SAME TABLE | |||
DT148121 | 4 | IT41415: POOR PERFORMANCE OF DB2 QUERY WITH UNION SUBQUERIES | |||
DT148285 | 2 | IT40829: DB2 QUERY MAY TRAP WHEN DIFFERENT COLUMNS ACCESSED IN MULTIPLE SCALAR SUBQUERIES | |||
DT148662 | 1 | IT40718: DB2 QUERY MAY PERFORM POOR WHEN NOT IN SUBQUERY HAS EXPRESSION. | |||
DT148106 | 1 | IT40752: DB2 QUERY TRAPS WHEN MODIFYING STATEMENT USES SET COLUMN THAT ISNOT USED IN SUBQUERY PREDICATE | |||
DT147549 | 3 | IT40762: INCORRECT RESULT WITH QUERY HAVING UNION | |||
DT148467 | 2 | IT40560: LOCAL PREDICATE PUSHDOWN FAILS WHEN IN SUBQUERY IN SELECT | |||
DT148469 | 2 | IT40626: DB2 QUERY MAY GENERATE 901 FOR QUERIES WITH UNION | |||
DT168674 | 2 | IT42184: IDENTITY_VAL_LOCAL MIGHT NOT RETURN LAST VALUE IF PREVIOUS INSERT-FROM-VALUES STATEMENT CONTAINED SMP-PARALLELIZED SCALAR SUBSEL | |||
Fix Pack m8fp0 - Query Compiler - ADM/PSM | |||||
DT148619 | 2 | IT38951: DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN | |||
DT147726 | 2 | IT40092: DB2 SERVER TERMINATES ABNORMALLY OR RETURNS -901 WHILE PROCESSING JSON DATA | |||
DT147325 | 2 | IT38801: DB2 SERVER TERMINATES ABNORMALLY DURING CREATE/DECLARE TABLE | |||
DT148264 | 2 | IT40064: POSSIBLE WRONG RESULT WHEN PREDICATE INCLUDES CAST OF DBCLOB TO GRAPHIC OR VARGRAPHIC | |||
DT147139 | 2 | IT34443: A COLUMN MASK DEFINED ON A COLUMN WITH STRING LENGTH UNIT CODEUNITS32 MAY RESULT IN SQL20478N | |||
DT148653 | 2 | IT40270: WRONG DEFAULT VALUE FOR CHAR or GRAPHIC COLUMN IN AN EBCDIC TABLE WHEN DEFAULT VALUE IS NOT EXPLICITLY SPECIFIED | |||
Fix Pack m8fp0 - Query Compiler - Optimizer | |||||
DT148656 | 3 | IT40363: -1667 WITH TOKENS TABLE TYPE: "ORGANIZE BY COLUMN". OPERATION: "WITH RR" | |||
DT146873 | 3 | IT35741: SQL1585N is returned when the optimizer does not select a possible plan under some circumstances | |||
Fix Pack m8fp0 - Query Compiler - QRW | |||||
DT148447 | 2 | IT39872: POOR DB2 QUERY PERFORMANCE WHEN EXISTS SUBQUERIES PART OF OR | |||
DT148234 | 3 | IT38599: DB2 QUERY MAY GENERATE 901 WHEN JOIN ON SAME TABLE AND SELECT DISTINCT PRESENT | |||
Fix Pack m8fp0 - Runtime | |||||
DT168627 | 2 | IJ39696: HISTOGRAM PRODUCING BINS WITH ZERO TUPLES | |||
DT132361 | 2 | IT40868: DB2 INSTANCE CRASH ON FUNCTION SQLERGETFMPFROMPOOL() | |||
DT147379 | 2 | IT40966: -901 SECTION LENGTH MISMATCH WHEN EXECUTING STATIC SQL | |||
DT147381 | 2 | IT41020: SQL0901N IN MPP WITH COLUMNAR TABLES IN SQLKQ_STOPWRITE_FLUSH FOR SQLKF_RQST_TIMEOUT | |||
DT146780 | 2 | IT38212: SET INTEGRITY FAILS WITH SQLCODE -668, REASON CODE 1 AFTER ADDING NEW GENERATED COLUMN | |||
DT148261 | 2 | IT39748: WHEN CPU SUPPORTS AVX2 A RARE TRAP IN PACKEDBANKSIMD IS POSSIBLE | |||
DT148443 | 2 | IT39765: A RARE WRONG RESULT IS POSSIBLE AGAINST COLUMNAR TABLES WITH A PSCANCOL PLAN AND MULTIPLE HSJNs ON THE SAME TABLE COLUMNS | |||
DT147687 | 2 | IT38730: POSSIBLE TRAP IN JOINEXPANSIONMULTIPLIEREVALUATOR::EXPANDALLREGULARATTR WHEN RUNNING HSJN QUERIES | |||
DT148446 | 2 | IT39851: RARE DATABASE SHUTDOWN WITH -902 SQLD_PARM "PARAMETER ERROR" | |||
DT131647 | 2 | IT40771: APPLICATION MAY HANG DUE TO THE LOST COMMUNICATION BETWEEN THE AGENT AND FMP CODE | |||
DT147926 | 2 | IT40347: RARE CRASH IN ERROR SCENARIO IN SQLRA_OPEN_PKG FUNCTION | |||
DT147355 | 2 | IT40066: DECREASE DEFAULT MAX NUMBER OF THREAD TO 1023 INSTEAD OF 1024 ON AIX | |||
DT146453 | 4 | IT34719: DECIMAL FUNCTION ON COLUMN-ORGANIZED TABLE MIGHT FAIL WITH SQL0413N | |||
DT132780 | 2 | IT39950: IN RARE JOIN ON COLUMNAR TABLES COULD LOOSE ROWS | |||
DT148098 | 2 | IT39999: FMP MEMORY CORRUPTION DUE TO WRITING TO A FREED IPC | |||
DT123635 | 2 | IT39928: RARE WRONG RESULT IS POSSIBLE FOR QUERIES AGAINST CDE TABLES THAT WERE CREATED WITH EBCDIC CCSID | |||
DT148094 | 2 | IT39873: FLUSH PACKAGE CACHE DYNAMIC FOR EXECUTABLE ID REPORTS SQLP_LCON | |||
DT147337 | 2 | IT39201: INSTANCE CRASHES RUNNING ALTER PACKAGE PACKAGE-NAME OPTIMIZATIONPROFILE OPTIMIZATION-PROFILE-NAME | |||
DT148073 | 3 | IT38861: RELAX OF DIAGLEVEL OF SQLRR_RDS_COMMON_POST, PROBE:870 | |||
DT148271 | 2 | IT40274: TRAP IN FUNCTION SQLRA_GET_VAR WITH STMT_CONC SET TO COMM_LIT | |||
DT143619 | 2 | IT40019: DB2 GOT CRASHED WITH SIGINAL #11 AT SQLRILITERALREPLACE() | |||
DT147721 | 2 | IT40020: SQL RETURNING WRONG RESULT AFTER REPEATING SAME SELECT STATEMENT | |||
DT147534 | 2 | IT40028: XA INDOUBT TRANSACTIONS: AFTER DB2STOP QUIESCE IS RUN | |||
DT147718 | 2 | IT39869: SQLCODE -803, PRODUCES DB2DIAG.LOG MESSAGE: SQLRR_PROCESS_EXECUTE_REQUEST, PROBE:800 MESSAGE | |||
DT147708 | 2 | IT39551: DB2 MAY TRAP IN UPRV_TZNAME | |||
DT148428 | 2 | IT39145: INSERT INTO A LOB MAY FAIL WITH ERROR -30020 | |||
DT147333 | 3 | IT39081: A RARE TRAP WORKING WITH COLUMNAR TABLES IN A VERY SPECIFIC STACK | |||
DT130540 | 2 | IT40699: INSTANCE CRASH WHEN SQLO_CPSAME ERROR HAPPENS IN SQLRICASTG2C | |||
DT147568 | 2 | IT41514: -901 INVALID POOLID AND OR OBJECTID ERROR IS INCORRECTLY RETURNED AFTER A TEMP TABLESPACE FULL SCENARIO | |||
DT147566 | 2 | IT41469: Sortheap memory leak possible for index-and access on MDC tables | |||
DT148456 | 2 | IT40279: RUNNING BIG SQL RETURN ERROR -901 INSTEAD OF -955 | |||
DT148298 | 2 | IT41314: WRONG RESULT WHEN SORT WITH FETCH FIRST N ROWS IS DONE IN COLUMNAR LOGIC | |||
DT148674 | 2 | IT41238: HANGING QUERIES CANNOT BE TERMINATED THROUGH THE NORMAL METHOD OF FORCING THE APPLICATION | |||
DT148281 | 3 | IT40618: WARNING MESSAGE COULD BE LOGGED INCORRECTLY IN DB2DIAG.LOG. | |||
DT147930 | 2 | IT40476: WHEN OLAP IS DONE IN COLUMNAR LOGIC QUERY COULD EXPERIENCE A HANG | |||
DT147933 | 2 | IT40602: RARE TRAP IN RIGHT OUTER HSJN WHEN INTERRUPT IS ISSUED. | |||
DT148683 | 2 | IT41653: ERROR MESSAGES WITH SQLNLSICUCONVERTTODATEFORMAT_CLDR2701 | |||
DT148478 | 2 | IT40905: INCORRECT ROW COUNT REPORTED WITH INSERT .. IGNORE DUPLICATES , COLUMNAR TABLES ONLY. | |||
DT147564 | 2 | IT41340: DOUBLE FREE OF UNUSED CHANNEL | |||
DT148421 | 2 | IT38887: ENHANCEMENT OF THE PD MESSAGE WHEN REACH THE LIMIT CONFIGURED BYDB2_MAX_THREADS_PER_FMP | |||
DT148499 | 2 | IT41427: DATA TYPE CONVERSION LEADS TO -SQL0413N OVERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSION | |||
DT147375 | 2 | IT40874: SPIKES IN SQLO_LT_SQLRA_CACHED_ENV__LATCH WAIT, USING STMT_CONC=LITERALS, ON CONCURRENTLY COMPILATION OF A STATEMENT | |||
DT147540 | 4 | IT40328: DB2 MIGHT REPEATEDLY REPORT ISSUES IN SQLSMERGEREC | |||
DT147395 | 3 | IT41571: FODC APP ERR WITH -901 "REACHED RETRYCOUNT LIMIT" | |||
DT147541 | 4 | IT40351: SEVERITY CHANGE OF LOG ENTRY: "FUNCTION: DB2 UDB, ROUTINE_INFRASTRUCTURE, SQLERINITFMPHEAP, PROBE:995* RETCODE : ZRC=0X00000000= | |||
Fix Pack m8fp0 - SAP Tools | |||||
DT147371 | 2 | IT40744: UPDATE SAPTOOLS.UPPER/LOWER TO COMPLY WITH LATEST UNICODE STANDARD | |||
DT148286 | 2 | IT40840: SAPTOOLS.ADMIN_COL_ANALYZE_FRAGMENTATION MIGHT RETURN SQL0802N | |||
Fix Pack m8fp0 - Security | |||||
DT147525 | 1 | IT39584: SECURITY: A VULNERABILITY IN 2.17.0 APACHE LOG4J AFFECTS DB2 (CVE-2021-44832) | |||
DT148609 | 1 | IT38463: SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION | |||
DT148247 | 2 | IT39215: UPDATE GSKIT TO 8.0.55.26 | |||
DT148637 | 2 | IT39500: UNNECESSARY SQLO_BAD_GROUP LOGGING INTO DB2DIAG.LOG | |||
DT147695 | 2 | IT38958: POSSIBLE SEGMENTATION FAULT ON DB2AUDIT EXTRACT COMMAND | |||
DT147511 | 2 | IT38800: IN CERTAIN SITUATIONS, THE SSL FUNCTION GSK_SECURE_SOC_PEEK MAY FAIL WITH THE RETURN CODE "5" IN SQLCCSSLSOCKETPEEK | |||
DT148452 | 1 | IT40210: SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE (CVE-2022-22389) | |||
DT147923 | 1 | IT40217: SECURITY: IBM DB2 IS VULNERABLE TO UNAUTHORIZED ACCESS (CVE-2022-22390) | |||
DT147365 | 1 | IT40483: EXCESSIVE CALLS TO OPERATING SYSTEM DATETIME FUNCTIONS, FOR EXAMPLE LOCALTIME_R, CAUSES LOCK CONTENTION IN THE OPERATING SYSTEM | |||
DT148125 | 2 | IT41557: IN RARE SCENARIOS, CERTAIN DB2 FUNCTIONS CAN HANG WHEN ATTEMPTING TO RESPAWN A CHECK PASSWORD DAEMON | |||
DT147571 | 2 | IT41576: DB2AUDIT SYNTAX ERROR WRITES AN UNNECESSARY ERROR LEVEL MESSAGE IN DB2DIAG.LOG | |||
DT147539 | 2 | IT40300: CATALOG LDAP DATABASE... AUTHENTICATION TOKEN FAILS WITH ERROR SQL1400N | |||
DT148463 | 3 | IT40509: IMPROVE EFFICIENCY OF CLIENT SIDE TLS CONNECTIONS | |||
DT148670 | 1 | IT40879: SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE DUETO UNAUTHORIZED ACCESS. (CVE-2022-22483) | |||
Fix Pack m8fp0 - PureScale | |||||
DT147348 | 3 | IT39691: WORKAROUND TO AVOID ROOT PASSWORDLESS SSH IN PACEMAKER | |||
DT147949 | 3 | IT41161: OPTION TO DISABLE AUTO FAILOVER AFTER 2 CONSECUTIVE TSA DB MONITOR TIMEOUTS | |||
DT145604 | 3 | IT40835: SETTING HADR_SYNCMODE TO ASYNC/SUPERASYNC AND ACTIVATING DB IS NOT BLOCKED ON PACEMAKER AUTOMATED HADR DATABASE. | |||
DT148477 | 3 | IT40902: DB2CM -ENABLE OR -CREATE -DB MAY NOT RUN AS EXPECTED IF HOSTS HAVE OUTPUTS TO STDOUT IN THEIR LOGIN ENVIRONMENT OF HADR INSTANCE | |||
DT147915 | 3 | IT40026: TOTAL_CF_CMD_TIME_MICRO RETURNS -1 | |||
DT147912 | 2 | IT40004: OUTPUT FROM LOADING INSTANCE PROFILE CONFLICTS WITH EXPECTED STDOUT IN PARTS OF DB2CM SCRIPT | |||
DT148647 | 2 | IT40005: HADR_REMOTE_INST SHOULD ALWAYS BE LOWERCASE | |||
DT147714 | 4 | IT39781: DIA8532C IS SOMETIMES LOGGED IN DB2DIAG.LOG WHEN ACTIVATING DB VIA DB2V115_START.KSH | |||
DT147347 | 2 | IT39589: DB2INST RESOURCE AGENT MAY CAUSE HANG DURING META-DATA ACTION INPACEMAKER HADR | |||
DT147944 | 2 | IT41024: HIGH "SQLO_LT_SQLB_BP_AREA_INFO_PAGEAREA__CLOCKLATCH" CONTENTIONS ON DB2 PURESCALE | |||
DT147743 | 2 | IT40711: PRINT SYSTEM DUMP MESSAGES IN DB2DIAG.LOG WHEN DB2 INITIATE SYSDUMPSTART COMMAND DUE TO MEMBER OR CF PROCESS CANNOT BE KILLED | |||
DT148266 | 2 | IT40090: ERRORS UNDER UNDER /VAR/LOG/PACEMAKER | |||
DT124197 | 2 | IT38339: db2instance -list shows CF in ERROR state transiently | |||
DT148265 | 2 | IT40088: DB2CM -LIST ERROR COULD NOT GET PACEMAKERE VERSION - 679 | |||
DT147920 | 2 | IT40089: DB2CM -DUMP GENERATING ERRORS | |||
DT147391 | 2 | IT41467: SLOW CF PERFORMANCE AND LOW CF CPU UTILIZATION DURING HIGH RAR OPERATION DUE TO DE/RB LATCH CONTENTIONS | |||
DT129226 | 2 | IT39844: DB2START FAILS WITH SQLE_SAL_MIXED_TRANSPORTS_ERROR WHEN ONE OF THE RDMA ADAPTERS ON THE HOST IS IN UNKNOWN STATE | |||
DT148468 | 2 | IT40590: SETTING UP THE FAULT MONITOR FACILITY TO AUTOMATICALLY RESTART DB2 INSTANCES FAILS ON A NON-ROOT INSTALLATION | |||
DT148507 | 2 | IT41752: DB2SYSC PROCESS WAS NOT RESTARTED ON OLD PRIMARY AFTER TAKEOVER. | |||
DT147744 | 4 | IT40734: CLUSTER MANAGER MAY NOT FUNCTION AS EXPECTED IF /VAR IS FULL | |||
DT147345 | 4 | IT39517: THE DB2PD FUNCTION GETS VALUE FOR CF_GBP_SZ FROM THE DB CONFIG STRUCTURE IN MEMORY WHICH IS INCORRECT. |
DB2 Version 11.5 Fix Pack m7fp0 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract | |||
IT36682 | 3 | QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNION MAY GET INCORRECT RESULT | |||
IT41864 | 3 | EXTERNAL TABLE INSERT OR SELECT MAY INCORRECTLY RETURN SQL0100 | |||
IT33777 | 3 | BUILD IN FUNCTION "DATE_PART" MIGHT RETURN AN INCORRECT RESULT OF WEEK, I.E. DATE_PART('WEEK', '2020-03-09') | |||
IT38609 | 2 | REORG RECLAIM THROWS -901 AS INTERNAL QUERY COMPILATION FOR SYNOPSIS TABLE WAS INTERRUPTED | |||
IT37046 | 2 | DEBUG CODE IN ENGN/SQNG CHANGE FOR A TRAP IN CODEGEN | |||
IT38731 | 2 | CALLING CLR STORED PROCEDURE ON WINDOWS COULD RESULT IN SQL4301N RC=6 | |||
Fix Pack m7fp0 - Abstract Data Types and Spatial Extender | |||||
IT37105 | 2 | INTERMITTENT ISSUE IN ST_UNION RESULTING IN WRONG M VALUES | |||
Fix Pack m7fp0 - Administration Tools | |||||
IT38669 | 2 | MON_GET_AUTO_MAINT_QUEUE() MAY FAIL WITH SQL0493N | |||
IT37555 | 3 | AUTOMATIC MAINTENANCE (DB2ACD) PROCESS GENERATES "HMONSQLCONNECT , PROBE:600 SQLCODE-1060" DB2DIAG.LOG ERRORS ON STANDBY DATABASE | |||
Fix Pack m7fp0 - Buffer Pool Services | |||||
IT38002 | 2 | ALTER TABLESPACE REBALANCE HANGS ON DISK FULL ERROR | |||
IT38476 | 3 | YOU MIGHT SEE LOT OF SQLBPROCESSDSTACK MESSAGES IN DB2DIAG.LOG | |||
IT37395 | 3 | DB2PD -BUFFERPOOLS REPORTS INACCURATE HIT RATIO | |||
Fix Pack m7fp0 - CDE Data | |||||
IT37801 | 1 | UPDATE OF A COLUMN-ORGANIZED TABLE WITH A SEARCH PREDICATE ON AN INDEX MIGHT RETURN A SQL901 ERROR DURING EXECUTION. | |||
IT37048 | 1 | COLUMN ORGANIZED TABLES THAT HAVE BEEN MARKED UNAVAILABLE CANNOT BE RENAMED. DOING SO MAY CRASH DB2. | |||
IT37977 | 1 | SELECT OR COMMIT AFTER UPDATE OF A COLUMN-ORGANIZED TABLE IN A PARTITIONED DATABASE ENVIRONMENT MIGHT FAIL WITH SQL901 ERROR | |||
IT37868 | 2 | FODC_APPERR: 'COLUMN.GETISNULLABLE()' ASSERTION DURING REPLICATION FOR COLUMN-ORGANIZED TABLES | |||
IT37579 | 2 | POSSIBLE TRAP IN SQLUMERGETABLEACCESSORZRC() WHEN RUNNING LOAD IN CDE ENVIRONMENT | |||
IT37047 | 3 | HANG DUE TO DEADLATCH BETWEEN VECTORIZEDADC THREAD AND NORMAL APPLICATION THREAD WHICH IS ROLLING BACK | |||
Fix Pack m7fp0 - CDE Query | |||||
IT38155 | 1 | TRAP POSSIBLE WHEN COLUMNAR QUERY RUNNING WITH THE DB2 TRACE ENABLED IF "NOT IN" CLAUSE | |||
IT37179 | 1 | OTF ENCODING FOR THE LARGE COLUMNS LEADS TO QUERY EXECUTION FAILS WITH SQL0954 . | |||
IT37212 | 1 | RARE MEMORY CORRUPTION IN SORTHEAP WHEN CDE HSJN IS IN THE PLAN | |||
IT37045 | 2 | DEBUG CODE FOR CDE/GROUPBY TO ADD ASSERTION TO ENSURE NEXT VECTOR POSITION AND THE PAYLOAD POSITION | |||
IT38286 | 2 | TRAP IN SQLOFASTALLOCATOR::FREEBLOCK | |||
IT37674 | 2 | WRONG RESULTS FROM SELECT COUNT QUERY ON "ORGANIZE BY COLUMN" TABLE | |||
IT36462 | 2 | BLU QUERY CAN TRAP IN EVALUATIONROUTINE::GETQUERYLITERAL | |||
Fix Pack m7fp0 - Client Interfaces | |||||
IT35245 | 1 | PROCESS CRASHES WITH SIGNAL 11 (MEMORY VIOLATIONS) WHEN APPLICATION CALLS SQLCONNECT OR SQLDRIVERCONNECT | |||
IT38240 | 2 | JAVA.LANG.OUTOFMEMORYERROR WITH TIMERLEVELFORQUERYTIMEOUT DEFAULT SETTING | |||
IT37448 | 2 | AFTER TURNING ON CLI PREFETCHING FEATURE, SQL STATEMENT RECEIVES CLI0106E/CLI0108E OR SQL_ERROR WITHOUT DIAGNOSTIC INFO | |||
IT38241 | 2 | ALTERNATE SERVER BECOMES PRIMARY SERVER WHEN BOTH PRIMARY AND ALTERNATE SERVERS ARE DOWN DURING DB2 JCC ACR | |||
IT38541 | 2 | INSERT INTO XML COLUMN OF A DRDA NICKNAME MAY CAUSE A SIGNAL 11 TRAP | |||
IT38055 | 2 | DB2DSDCFGFILL DOES NOT CREATE A DB2DSDRIVER.CFG FILE | |||
IT37407 | 2 | SQLCOLUMNS CLI FUNCTION MAY NOT WORK ON A TABLE NAME THAT INCLUDES MBCS CHARACTERS | |||
IT36721 | 2 | REORGCHK F6 REPORTING INCORRECT VALUES | |||
IT33888 | 3 | NO OPTION TO CONFIGURE CLI KEYWORD SSLSERVERCERTIFICATE VIA MICROSOFT ODBC ADMINISTRATOR | |||
Fix Pack m7fp0 - Codegen and Runtime | |||||
IT38563 | 2 | DATABASE CRASH WHEN ARRAY TYPE VARIABLE USED IN "DGTT AS (SELECT ..) WITH DATA" SQL STATEMENT | |||
IT38313 | 2 | MEMORY LEAK IN RUNTIME ENGINE IF MEMORY POOL IS NOT CACHED | |||
IT37768 | 2 | PACKAGE RESTORE VALIDATION MAY CAUSE -901 AND FODC_APPERR | |||
IT38087 | 2 | SEGV AT SQLV_MIXD_BUILD_LIKE_SUBPAT() | |||
IT36048 | 2 | COMMUNICATION FAILURE BETWEEN DB2AGENT AND DB2FMP FOR SOME COMBINATIONS OF DATA SIZES AND APPLICATION SUPPORT LAYER HEAP SIZES | |||
Fix Pack m7fp0 - Communication | |||||
IT37963 | 2 | MEMORY LEAK IN DB2 11.5 MOD6 FP0 DUE TO A NEW FEATURE IN ESQL. | |||
Fix Pack m7fp0 - DRDA Services | |||||
IT38817 | 1 | SECURITY: CLIENT ENCRYPTION SETTINGS ARE NOT PRESERVED ON A FAIL OVER/RECONNECT RESULTING IN A DATA EXPOSURE. (CVE-2021-39002) | |||
IT36663 | 2 | INCORRECT CONNECTION DETAIL TOKEN STRINGS FOR A CLP CONNECTION USING A DBALIAS GREATER THAN DBNAME | |||
Fix Pack m7fp0 - Data Management Services | |||||
IT37470 | 1 | POSSIBLE SIGSEGV WHEN TURNING ON OR DURING MONITORING OF TABLE EVENTS | |||
IT39109 | 1 | BCD DECIMAL USING 0XF FOR SIGN NIBBLE MIGHT GET CONVERTED TO NEGATIVE VALUE | |||
IT37146 | 2 | SYSTEM TEMP TABLESPACE CAN BE LEFT IN SQLB_REORG_IN_PROGRESS IF REORGS WERE STARTED, BUT NOT COMPLETED BEFORE CRASH RECOVERY | |||
Fix Pack m7fp0 - Data Management Utilities | |||||
IT38564 | 2 | ADMIN_MOVE_TABLE(REPORT) OPERATION FAILS WITH -911 LOCK TIMEOUT DURING ADMIN_MOVE_TABLE(COPY_USE_LOAD) | |||
IT35853 | 2 | AUDIT EVENT LOAD_TABLE EVENT STATUS 3534 FILLING UP AUDIT LOG | |||
IT36654 | 2 | LARGE LOAD WITH LARGE AMOUNT OF LOB (> ~2-5 GB) DATA, AFTER LOAD COPY IMAGE FILE REPLAYED/PROCESSED, LEAD TO DATA CORRUPTION | |||
IT38511 | 3 | ROLLFORWARD OF LOAD COPY IMAGE FROM OBJECT STORAGE CANNOT BE RECOVERED DUE TO PATH TRUNCATION | |||
IT37792 | 3 | REMOVE DIAG MESSAGE "ROW HASH MISMATCH" WHEN LOAD ASKED TO DISCARD SUCH ROWS ON V11.5 | |||
Fix Pack m7fp0 - Data Recovery Services | |||||
IT37671 | 1 | TABLE SPACE ROLLFORWARD CAN FAIL UNDER ADVANCED LOG SPACE MANAGEMENT | |||
IT38506 | 1 | DB2READLOG API FAILS TO RETRIEVE LOG FILE WITH SQL2657N | |||
IT38461 | 2 | HADR STANDBY LOG FILES ACCUMULATING IN THE DATABASE LOG PATH. | |||
IT35086 | 2 | SQL2536W DURING BACKUP | |||
IT36964 | 2 | TOO MANY LOG FILES IN ACTIVE LOG PATH ON HADR STANDBY | |||
IT38900 | 2 | AFTER REACTIVATING A CRASHED STANDBY DATABASE, SOME READ ON STANDBY OPERATIONS MIGHT GET BACK SQL0901 | |||
IT38431 | 2 | DB2ADUTL UPLOAD FAILS TO UPLOAD THE WHOLE RANGE OF LOGS IF ONE OF THE LOGS WAS ALREADY UPLOADED | |||
IT37382 | 2 | TOTAL_LOG_USED INCREASE GRADUALLY TO AN UNREAL VALUE | |||
IT37021 | 2 | SNAPSHOT BACKUP FAILED WITH SQL1550N RC 5 | |||
IT37863 | 3 | HADR GRACEFUL TAKEOVER CAN TIMEOUT DUE TO SUSPENDED DB2AGENT PROCESSES | |||
IT36568 | 3 | A DATABASE OUTAGE IS REQUIRED IN ORDER FOR A NEW CERTIFICATE FOR HADR WITH SSL TO TAKE EFFECT | |||
IT37926 | 3 | LOCK ESCALATION OCCURS IN PURESCALE WHEN DB2_AVOID_LOCK_ESCALATION IS SET | |||
IT37514 | 3 | DB2 CRASH DUE TO LOG MISSING REQUIRED BY A ROLLBACK. | |||
Fix Pack m7fp0 - Federation | |||||
IT38046 | 1 | NNSTAT MIGHT FAIL TO UPDATE NUMERIC COLUMN STATS WITH SQL1227N RC=3 IF VACHAR2 COMPATIVILITY IS ENABLED. | |||
IT37846 | 1 | NNSTAT FAILS TO UPDATE NICKNAME'S STATICS DUE TO DIFFERENT CURRENT SCHEMA SETTING | |||
IT37965 | 1 | THE REMOTE CHAR COLUMN LENGTH OVER 86 REPORT SQL0901 AFTER THE COLUMN LENGTH AUTO VARIATION | |||
IT37587 | 2 | DB2 FEDERATION CAN NOT BE FORCED OFF DURING ABNORMAL SHUTDOWN OF MSSQL SOURCE SERVER | |||
IT38446 | 2 | WHEN REMOTE DATA SOURCE IS DB2 AND THE TABLE HAS CLOB COLUMN, IT MIGHT CAUSE THE -901 INVALID NICKNAME COLUMN LENGTH ERROR | |||
IT37014 | 2 | WITH FEDERATION USE OF A FLAT FILE FAILS IF THE FILE > 3GB IN SIZE ON WINDOWS | |||
IT38209 | 2 | AS FEDERAION LACK OF CODEPAGE CONVERSION FOR CLOB DATA TYPE IN R EMOTE DATA SOURCE, IT WILL CAUSE -901 ERROR "REAL COLUMN LENGTH | |||
Fix Pack m7fp0 - Index Manager | |||||
IT39048 | 1 | HANG WAITING FOR SQLO_LT_SQLI_IDXCB__IDXTREELATCH WITH NO HOLDERS AFTER FAILED REORG INDEX(ES) .. RECLAIM EXTENTS | |||
IT36666 | 1 | REORG TABLE RECLAIM EXTENTS ON INSERT TIME CLUSTERING (ITC) TABLES CAN RESULT IN FODC_INDEXERROR | |||
Fix Pack m7fp0 - Install and Catalog Services | |||||
IT37423 | 2 | INSTALLDSDRIVER -UPGRADE FAILS TO UPGRADE WHEN MOVING FROM ONE MODPACK TO ANOTHER | |||
IT37851 | 2 | INVALID ENTRIES IN CATALOGCACHE , REMOVE INVALID ENTRIES FROM SYSCODEPROPERTIES CACHE. | |||
IT37424 | 2 | TRAP WHEN RUNNING ADMIN_REVALIDATE_DB_OBJECTS() | |||
IT37995 | 2 | PURESCALE CAN NOT BE SETUP WITH DB2LOCSSH | |||
IT37836 | 2 | IN-PLACE INSTALLFIXPACK GETS SEGMENTATION FAULT ON RHEL 8.X WITH PACEMAKER | |||
IT38186 | 2 | APPLYING HIGH CAPACITY LICENSE ON TOP OF DB2 STANDARD OEM LICENSE DOES NOT REMOVE THE MEMORY AND CORE LIMITS. | |||
IT38027 | 2 | 32-BIT ICCSIG.TXT IS MISSING FROM DB2 11.5.6.0 UNIX (AIX, LINUX, ETC.) IMAGES | |||
Fix Pack m7fp0 - JDBC Driver | |||||
IT38240 | 2 | JAVA.LANG.OUTOFMEMORYERROR WITH TIMERLEVELFORQUERYTIMEOUT DEFAULT SETTING | |||
IT38241 | 2 | ALTERNATE SERVER BECOMES PRIMARY SERVER WHEN BOTH PRIMARY AND ALTERNATE SERVERS ARE DOWN DURING DB2 JCC ACR | |||
IT37644 | 2 | DURING XA TRANSACTION, WHEN XAER_RMFAIL IS RECEIVED FROM SERVER, SUCH CONNECTIONS ARE NOT ISOLATED, CLOSED AND REMOVED FROM CONN | |||
IT37216 | 2 | JCC 4.27.25 CAUSES ABENDS IN DB2 WHILE ACCESSING BLOB DATA MORE THAN 1MB SIZE | |||
IT37215 | 2 | SOMETIMES FEW BYTES OF DATA ARE MISSING WHEN LOB LOCATORS ARE USED FOR FETCHING DATA WHICH CONTAINS MULTI BYTE CHARACTERS | |||
IT37126 | 2 | ARRAYINDEXOUTOFBOUNDSEXCEPTION OCCURS DURING MULTITHREADED SQLJ APPLICATION PROFILE PROCESSING. | |||
IT36131 | 2 | UNEXPECTED ERROR SEVERITY CODE 8 ERRORCODE=-4228, SQLSTATE=NULL WHEN USING PREPARED STATEMENT WITH SETARRAY METHOD | |||
Fix Pack m7fp0 - Monitoring | |||||
IT38659 | 2 | EXECUTING ADMIN_MOVE_TABLE ON A TABLE WITH SOME KINDS OF STATEMENTS > 64KB SIZE, WILL RETURNED SQL0104N OR SQL1224N | |||
IT38013 | 2 | ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL2103N RC=16 IF RUNSTATS PROFILE CONTAINS NUM_FREQVALUES /NUM_QUANTILES | |||
IT38011 | 2 | ADMIN_MOVE_TABLE FAILS WITH ERROR WHEN MOVING TABLE WITH USAGE LIST AND SPECIAL CHARACTERS | |||
IT37690 | 2 | SPACE USED BY LOBS IN SOME EVENT MONITORS NOT REUSED WHEN THOSE LOBS ARE DELETED | |||
IT36891 | 2 | MON_GET_LOCKS FAILS IN SINGLE MEMBER WITH "NO MEMORY AVAILABLE". | |||
IT38627 | 2 | ADMIN_MOVE_TABLE COPY_STATS MIGHT FAIL WITH SQL0010N IF LOW2KEY/HIGH2KEY CONTAINING 0 BYTE | |||
IT37956 | 2 | ADMIN_MOVE_TABLE FAILS WITH SQL0104N WHEN MOVING TABLE WITH DOUBLE QUOTES IN NAME WHICH HAS A STATISTICS PROFILE | |||
IT36731 | 3 | ADMIN_MOVE_TABLE FAILS WITH SQL0010N - WHEN RUNSTATS STATS_PROFILE IS GREATER THAN 1024 CHARACTERS. | |||
IT36203 | 3 | ADMIN_MOVE_TABLE WITH COPY_STATS OPTION MIGHT FAIL WITH SQL2102N RC 28 | |||
Fix Pack m7fp0 - Parsing and SQL PL | |||||
IT37213 | 1 | SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR BACKUP (CVE-2021-29825) | |||
Fix Pack m7fp0 - Platform Specific | |||||
IT37087 | 1 | NX842 BACKUP AND LOG FILE COMPRESSION MIGHT FAIL | |||
IT38996 | 2 | INSERTING DECIMAL MINUS ZERO INTO COLUMN ORGANIZED TABLE LEADS TO WRONG RESULT ON POWERPC | |||
IT38006 | 2 | BACKUP FAILS WITH BAD PAGE ERRORS DUE TO MISMATCH BETWEEN THE PH YSICAL SIZE OF THE CONTAINER AND WHAT IS SAVED IN THE SPCS FILES | |||
IT36839 | 2 | DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY | |||
IT38467 | 3 | SQL1128W REASON CODE 6 MISSING FROM KC AND MRI MESSAGES | |||
Fix Pack m7fp0 - Problem Determination | |||||
IT37531 | 2 | DB2_HANG_DETECT SCRIPT MAY DETECT HANG INCORRECTLY AND KILL THE INSTANCE WITH ACTION=TERMINATE | |||
Fix Pack m7fp0 - Process Model | |||||
IT38238 | 2 | MEMORY CORRUPTION WHILE PERSISTING PLAN ACTUAL HASH TABLE TO DISK | |||
IT35720 | 2 | PURESCALE MAY HANG WHEN THERE ARE 2 MORE CONCURRENT NODE FAILUR ES AND ONE OF THE NODE FAILURES CAUSES A DATABASE DEACTIVATION. | |||
IT38379 | 2 | IN CERTAIN SITUATIONS, A SMALL MEMORY LEAK WILL BE OBSERVED IN SQLE_APPLICATION.C ON A DPF INSTANCE | |||
IT38716 | 2 | IN PURESCALE, POTENTIAL DATA CORRUPTION IF NETWORKING FAILS BETWEEN MEMBERS | |||
IT37339 | 2 | A USER INTERRUPT DURING AN IMPLICIT REBIND WHILE OPENING A CURSOR IN A STORED PROCEDURE MAY CAUSE A TRAP | |||
IT37164 | 2 | POSSIBLE TRAP IN SQLO_SLATCH_CAS64::RELEASECONFLICT WHEN CLEANING UP FEDERATED FMP | |||
IT37196 | 2 | IF NODE FAILURE RECOVERY OCCURS AFTER END OF TRANSACTION, THE NEXT OPERATION CAN RECEIVE SQL1229 | |||
IT37100 | 2 | DB2STOP RESULTS IN SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004 | |||
IT37240 | 3 | DB2CFEXP FAILS TO EXPORT SSL_CLNT_KEYDB AND SSL_CLNT_STASH DBM CFG PARAMETERS FROM A CLIENT INSTANCE | |||
IT36628 | 3 | ZRC=0XFFFFFFFF=-1 ERROR IN DB2DIAG.LOG WHEN USING PURESCALE WITH SSL | |||
Fix Pack m7fp0 - Query Compiler Optimizer | |||||
IT37511 | 2 | POOR PERFORMANCE OF FEDERATED QUERIES IN CERTAIN CASES | |||
IT37986 | 2 | INSTANCE CRASHED RUNNING A QUERY | |||
IT37081 | 2 | INCONSISTENT OLAP RESULTS ON COLUMNAR TABLES IN AN MPP ENVIRONMENT | |||
IT38246 | 2 | RUNSTATS FAILS DUE TO A DEADLOCK (SQL2310N ERROR "-911" ) ON SYSIBM.SYSCOLGROUPSCOLS WHEN COLLECTING COLUMN GROUP STATISTICS. | |||
IT36903 | 2 | -901 ERROR WITH REASON "NO PLAN FOUND" | |||
IT35804 | 2 | SEGV OCCURS WHILE PREPARING A QUERY WITH AN XML PREDICATE THAT CONTAINS ANY EMPTY STRING LITERAL, RESULTS IN SQL1224N. | |||
IT37540 | 2 | SQLCODE: -901 AND FODC_TRAP: ASSERTIONFAILEDEXCEPTION: AN ASSERT ION 'MCSETEMPMAP.FIND(CSETEMPNAME) == MCSETEMPMAP.END()' FAILED. | |||
IT38508 | 2 | EXCESSIVE QUERY COMPILATION TIME WITH A VERY LONG SELECT DISTINCT COLUMN LIST AND VERY MANY COLUMN GROUPS | |||
IT37911 | 2 | INNER JOIN OF AT LEAST 4 COLUMN-ORGANIZED TABLES MIGHT RETURN WRONG RESULTS UNDER SPECIFIC CONDITIONS | |||
IT37236 | 2 | EXPLAIN_FROM_SECTION RETURNS SQL0220N FOLLOWING UPGRADE TO DB2 V11.5.5 DESPITE RUNNING DB2EXMIG | |||
IT37168 | 3 | DB2EXFMT TRAPS WHILE PROCESSING A QUERY CONTAINING HEXADECIMAL VALUES | |||
Fix Pack m7fp0 - Query Compiler QGM | |||||
DT146904 | 1 | QUERY PERFORMANCE IS SUB-OPTIMAL WHEN SCROLLABLE CURSORS ARE USED WITH COLUMN-ORGANIZED INDEX SCANS | |||
IT38400 | 1 | INCORRECT RESULT WHEN DB2 QUERY HAS EXISTS SUB QUERY WITH IS NULL PREDICATE | |||
IT38558 | 1 | SECURITY: INDIRECT READ ACCESS TO A TABLE THAT THE USER IS NOT AUTHORIZED TO SELECT FROM (CVE-2021-38931) | |||
IT37556 | 2 | GRPBY INTRODUCED IN V11.5.5.X ACCESS PLAN CAUSED SQL16003N | |||
IT38549 | 2 | WRONG RESULT WHEN SUBSELECT WITH SCALAR AGGREGATE REFERENCED MULTIPLE TIMES | |||
IT36276 | 2 | UNEXPECTED SQL0206N FROM FEDERATED VIEW USING WITH CLAUSE. | |||
IT38832 | 2 | DB2 QUERY MAY PERFORM POORLY WHEN NULL PRODUCING SIDE OF OUTER JOIN IS ON BASE TABLE. | |||
IT38829 | 2 | DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONS AND SCALAR AGGREGATIONS | |||
IT35385 | 2 | QUERY COULD FAIL WITH -901 WHEN MQT IS USED | |||
IT38344 | 2 | SQL0901N ERROR CODE RETURNED WHEN CASTED MEMORY TABLE JOINING ON VARCHAR COLUMNS | |||
IT36016 | 2 | ABSTRACT: -901 ERROR WITH REASON PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP RETURNS IN QUERY COMPILATION. | |||
IT37785 | 2 | TRAP IN FUNCTION SQLNR_JOINPPD_COND WHEN RUNNING UPDATE STATEMENT | |||
IT36743 | 2 | PREVENT PUSHING DOWN LARGE IN LIST PREDICATES TO UNION BRANCHES. | |||
IT37889 | 2 | DB2 QUERY MAY ABEND OR RETURN A SQL 901 WHEN USING A CORRELATED COMMON TABLE EXPRESSION | |||
IT38399 | 2 | WRONG RESULT WHEN DB2 QUERY HAS CORRELATED EXISTS PREDICATE | |||
IT38833 | 3 | DB2 QUERY PLAN DOES NOT CHOOSE INDEX WHEN IN PREDICATE HAS PARAMETER MARKER. | |||
IT37626 | 3 | ERROR SQL0102N RETURNED WHEN DB CFG VARCHAR2=ON, STMT_CONC=LITERALS AND STRING_UNITS=CODEUNITS32 | |||
IT37632 | 3 | DB2 QUERY MAY ABEND WHEN EXPRESSION REFERENCED FROM MQT | |||
Fix Pack m7fp0 - Relational Data Services | |||||
IT37102 | 1 | APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED | |||
IT37425 | 2 | FODC TRAPS WHEN USING DPF, COLUMN ORGANIZED TABLES AND ARRAY INPUT | |||
IT36825 | 2 | SQLTEMPSPACE OR AGGSQLTEMPSPACE THRESHOLDS DO NOT WORK WITH ROWSTORE OLAP OPERATORS THAT SPILL TO DISK. | |||
IT38229 | 2 | LOCKTIMEOUT(VIRTUAL DEADLOCK) OCCURRED ON GLOBALPKGLOCK | |||
IT38355 | 2 | DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT | |||
IT38660 | 2 | MEMORY CORRUPTION DETECTED IF CONNECTION CONCENTRATOR IS ENABLED | |||
Fix Pack m7fp0 - Sailfish Operational Compatibility | |||||
IT37275 | 2 | EXTERNAL TABLE CAN FAIL WHEN A LARGE INPUT FILE CONTAINS STRING DATA THAT HAS AN ESCAPED QUOTE IN THE QUOTED STRING. | |||
IT37266 | 2 | EMPTY STRING INSERTED AS NULL WHEN USING QUOTEDVALUE | |||
IT37938 | 2 | EXTERNAL TABLE CAN FAIL WHEN A LARGE INPUT FILE CONTAINS STRING DATA THAT HAS AN ESCAPED QUOTE IN THE QUOTED STRING. | |||
IT38968 | 2 | INSERT BINARY DATA INTO EXTERNAL TABLE RETURNS ERROR SQL0901N | |||
IT38472 | 3 | EXTERNAL TABLE FIXED FORMAT LOAD OF NEGATIVE BIG INTS FAILING | |||
Fix Pack m7fp0 - Security | |||||
IT37939 | 4 | SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE (CVE-2021-29678) | |||
IT36906 | 4 | SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE UNDER SPECIFIC CONDITIONS (CVE-2021-29763) | |||
IT36907 | 4 | SECURITY: IBM DB2 IS VULNERABLE TO WEAK FILE PERMISSIONS ALLOWING ACCESS TO SPECIFIC FILES (CVE-2020-4976) | |||
IT37254 | 4 | SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE (CVE-2021-29752) | |||
IT38561 | 4 | SECURITY: INDIRECT READ ACCESS TO A TABLE THAT THE USER IS NOT AUTHORIZED TO SELECT FROM (CVE-2021-38931) | |||
IT38196 | 2 | ADD SUPPORT FOR FIPS MODE OF OPERATION TO LINUXPPC64LE | |||
IT37032 | 2 | IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG | |||
IT38170 | 2 | GROUP LOOKUP FAILING FOR GROUPS THAT CONTAIN LARGE NUMBER OF USERS | |||
IT36961 | 2 | FOR SSL CONNECTIONS ONLY, AUTHENTICATION CACHE IS NOT ABLE TO PERFORM USER OR GROUP LOOKUP | |||
IT36847 | 2 | WHEN DB2_ALTERNATE_GROUP_LOOKUP=GETUSERATTR, A USER'S PRIMARY GROUP MAY NOT BE REPORTED BY DB2. | |||
IT35907 | 2 | NO AUDIT OF START HADR AND STOP HADR | |||
IT38481 | 2 | PKCS11 DRIVER MAY RETURN UNEXPECTED ERROR CODES WHEN HSM SESSION IS CLOSED | |||
IT37184 | 3 | WHEN TRUSTED CONTEXT IS DROPPED, SETSESSIONUSER PRIVILEGES ARE ALSO DELETED | |||
Fix Pack m7fp0 - Text Search | |||||
IT37498 | 2 | TEXT SEARCH UPGRADE FROM 11.1 TO 11.5.5.1 DOES NOT UPDATE SYSIBMTS.SYSTSDEFAULTS | |||
Fix Pack m7fp0 - XML | |||||
IT38624 | 2 | ENGINE CRASH IN XMLRNNODEMGR::FETCHTEMPNODE() | |||
Fix Pack m7fp0 - pureScale Services | |||||
IT39233 | 2 | DATABASE CREATE FAILS WITH SQL2049N RC=2 WHEN DB2_DATABASE_CF_MEMORY BEING SET TO 0 | |||
IT37578 | 2 | NEW ENVIRONMENT VARIABLE TO TUNE WAIT TIMES BETWEEN UDAPL API CALLS ( LINUX ON IBM Z SYSTEMS ONLY ) | |||
IT39252 | 3 | DB2HAICU -REMOTE_ENABLE MAY FAIL WHEN REMOTE HOST USES NLS MESSAGES | |||
IT36213 | 3 | REMOVE IRRELEVANT ALERT ABOUT NETWORK INTERFACE: 'VIRBR0' WHEN USING PURESCALE ON REDHAT | |||
IT39261 | 3 | IMPROVE ERROR MESSAGE WHEN PUTTING CLUSTER IN TO MAINTENANCE MODE WITHOUT DB2CLUSTER -ALL OPTION. | |||
IT33256 | 3 | DB2CLUSTER -LIST -ALERT CAN FAIL TO LIST AN ALERT IN CERTAIN TRANSIENT STATES | |||
IT37136 | 3 | SQL1659 IS NOT RETURNED EVEN WHEN A RDMA DEVICE CANNOT BE OPENED DURING DB2START, AND DB2DIAG.LOG IS SPAMMED WITH ERROR MESSAGES |
DB2 Version 11.5 Fix Pack m6fp0 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract | |||
IT35576 | 3 | HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN A DISTRIBUTED TRANSACTION | |||
IT37301 | 3 | DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY WILL FAIL WITH AN SQL2079N ERROR, IN VERSION 11.1.4.4. | |||
IT37079 | 3 | COUNT DISTINCT QUERIES AGAINST COLUMNAR ORGANIZED TABLES COULD RETURN INCORRECT RESULTS | |||
IT35926 | 3 | WRONG RESULT WITH MULTIDIMENSIONAL CLUSTERING (MDC) TABLE AND ZIGZAG JOIN (ZZJN) | |||
IT36093 | 3 | DB2_FMP_COMM_HEAPSZ VALUES GREATER THAN 1GB NOT HONORED | |||
IT36323 | 3 | MEMORY BLOCK FREED TWICE IN SQLOFMBLKEX | |||
IT36128 | 3 | ERROR -901 IN CONCATINFO.HPP ENCOUNTERED WHILE RUNNING A QUERY | |||
IT36937 | 3 | IF ROW BEING SORTED IS VERY WIDE MEMORY OVERWRITES OR WRONG RESULTS ARE POSSIBLE. | |||
IT36948 | 3 | RARE TRAP IS POSSIBLE DURING COLUMNAR HASH JOIN . | |||
IT33777 | 3 | BUILD IN FUNCTION "DATE_PART" MIGHT RETURN AN INCORRECT RESULT OF WEEK, I.E. DATE_PART('WEEK', '2020-03-09') | |||
IT35943 | 3 | QUERIES REFERENCING AN EXISTS SUB-QUERY WITH FETCH FIRST 1 ROW R EFERENCED IN A CASE STATEMENT IN THE SELECT LIST MAY RESULT IN I | |||
IT35891 | 3 | WRONG RESULT MIGHT BE RETURNED WHEN SUBSTR WITH IF ELSE CLAUSES WAS USED AND THE COLUMN WAS CREATED IN CODEUNIT32 | |||
IT36753 | 3 | IN SOME RARE CASES, A SORT ON A COLUMNAR TABLE CAN HANG | |||
IT36467 | 3 | A TRUNCATE TABLE STATEMENT ON A COLUMN ORGANIZED TABLE WITH LOBS MAY RETURN SQLCODE -964 (TRANSACTION LOG IS FULL). | |||
IT36572 | 3 | FEDERATED QUERY MULTIBYTES CHARACTERS RETURNING '001A' USING THE ODBC WRAPPER | |||
Fix Pack m6fp0 - Administration Tools | |||||
IT35682 | 2 | POSSIBLE FMPTRAP IN CHECK_CREATE() WHEN RUNNING DB2LOOK IF AN OBJECT GETS DROPPED WHILE THE TOOL IS RUNNING | |||
IT32728 | 2 | PERIODIC TASKS THAT RUN THROUGH DB2ACD ARE NOT EXECUTED AFTER HADR FAIL OVER | |||
Fix Pack m6fp0 - Buffer Pool Services | |||||
IT33546 | 2 | QUERIES MIGHT HANG IN UOW-EXEC WAITING ON SQLO_LT_SQLB_HASH_BUCK ET_GROUP_HEADER__GROUPLATCH IN SQLBFINDPAGEINBPORSIM FUNCTION | |||
IT34100 | 2 | REDIRECT RESTORE FAILS AFTER SET TABLESPACE CONTAINERS USING AUTOMATIC STORAGE | |||
IT33688 | 2 | ROLLFORWARD CAN RESULT IN SQL1042C AFTER SET TABLE SPACE CONTAINERS USING AUTOMATIC STORAGE | |||
IT36166 | 2 | DATABASES CREATED WITH "AUTOMATIC STORAGE NO" MAY CORRUPT STORAGE GROUP FILES AFTER UPGRADE | |||
IT36337 | 3 | PREFETCHERS INFINITELY LOOPING IN SQLBSERVICELEAFREQUEST | |||
Fix Pack m6fp0 - CDE Data | |||||
IT33760 | 1 | SEGV OR PANIC WHILE DOING PARALLEL INSERTS | |||
IT36327 | 1 | AUTO REORG..RECOMPRESS AND ONLINE BACKUP CANNOT BE RUN CONCURRENTLY | |||
IT36818 | 1 | POSSIBLE DATA LOSS IF DELETE AND RUNSTATS/REORG ARE IN A SINGLE TRANSACTION AND THE TRANSACTION IS THEN ROLLEDBACK | |||
IT34924 | 2 | DB2DART AND INSPECT COMMANDS FOUND ERROR TYPE VARIABLE-LENGTH DA TA AT OFFSET XXXX IS READ INCORRECTLY. THE EXPECTED OFFSET IS 0 | |||
IT36476 | 2 | HANG DURING INSERT FROM NODES SENDING HISTOGRAMS | |||
IT35949 | 2 | OUT OF MEMORY: SIGNAL #11 DATABASETABLEACCESSOR::DESTROYDELETEREPLICATOR | |||
IT36396 | 2 | -901 APPERR WHEN INSERT INTO <TABLE> AFTER TRUNCATE <TABLE>WITHOUT IMMEDIATE CLAUSE | |||
Fix Pack m6fp0 - CDE Query | |||||
IT34991 | 2 | QUERY WITH OLAP MIGHT FAIL WITH SQL0955C IN CDE | |||
IT35973 | 2 | NESTED IN PREDICATES CAUSES -901 ERROR | |||
IT36924 | 2 | IN A RARE SCENARIO THE ERROR COULD BE LOST AND INSTEAD EITHER NULL OR SQL0901N RETURNED | |||
IT36311 | 2 | WHEN RUNNING NLJN AGAINST COLUMNAR TABLES IT IS POSSIBLE TO GET SQL0901N ERROR | |||
IT32579 | 3 | VALUE OF STATISTIC COLUMN AVGENCODEDCOLLEN IS INCORRECTLY COLLECTED DURING THE LOAD | |||
Fix Pack m6fp0 - Client Interfaces | |||||
IT36757 | 2 | CLR PROCEDURE ABORTS ABNORMALLY WITH ERROR SQL1024N WHEN IT USES IBM.DATA.DB2 .NET PROVIDER | |||
IT35180 | 2 | BOOLEAN DATA TYPE GETS TRANSLATED AS SHORT-TEXT IN MS-ACCESS VIA ODBC | |||
IT36275 | 2 | UNCATALOG SYSTEM ODBC DATA COURCE <DSN> FAILS WITH DB21036E | |||
IT33194 | 2 | IN CERTAIN TIMING CONDITIONS, CLI CLIENT ACR CAN FAIL TO REROUTE CONNECTIONS | |||
IT36235 | 2 | PRECOMPILER STRIPS C STYLE COMMENTS FROM SQL, CANNOT USE INLINED OPTIMIZATION GUIDELINES | |||
IT34587 | 3 | DB2TRC FMT -CLI CRASHES ON WINDOWS FOR SQLFREEHANDLE API | |||
Fix Pack m6fp0 - Codegen and Runtime | |||||
IT33610 | 2 | POSSIBLE FLOODING OF DB2DIAG.LOG FILE WITH MESSAGES FROM 'SQLNLSICUCONVERTTOMERIDIANFORMAT()' | |||
IT37253 | 2 | IN SOME CASES, WLM THRESHOLDS FOR TEMP SPACES IS CALCULATING INCORRECTLY | |||
IT35994 | 2 | TRAP IN SQLNGREORDERAGGOPS WHEN ATTEMPTING TO COMPILE A JASON ARRAY | |||
IT35984 | 2 | A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT | |||
IT36245 | 2 | SQL QUERY MAY BE SLOW WHEN USING DBMS_LOB.SUBSTR FUNCTION IN A VIEW | |||
IT33282 | 2 | DB2 MIGHT SHUTDOWN WHEN HANDLING A REGULAR EXPRESSION (REGEX) IN SQLRI_REGEXP_LIKE_LONG_BODY() WITH INVALID DATA | |||
IT34764 | 2 | SLOW PERFORMANCE IN REGULAR EXPRESSION FUNCTIONS ON BIG ENDIAN PLATFORMS | |||
Fix Pack m6fp0 - DB2 Tools | |||||
IT35061 | 2 | WHEN A USER ID WITH INSUFFICIENT PRIVILEGE ATTEMPTS TO RUN REORG FROM WITHIN A STORED PROCEDURE, THE STORED PROCEDURE RETURNS RC | |||
Fix Pack m6fp0 - DRDA Services | |||||
IT36026 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO A DOS WHEN A TABLE IS DROPPED WHILE BEING ACCESSED IN ANOTHER SESSION (CVE-2021-29777) | |||
IT36201 | 2 | A CLIENT MAY ABEND IN FUNCTION SQLXAPREPARECOMMIT | |||
Fix Pack m6fp0 - Data Management Services | |||||
IT34966 | 1 | SECURITY: DB2 EXTERNAL TABLE CREATION IS VULNERABLE TO RACE CONDITION ATTACK | |||
IT34964 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO AN ARBITRARY FILE OVERWRITE | |||
IT36525 | 1 | TRAP IN FUNCTION SQLPLRL WHEN DROPPING A SYSTEM TEMPORARY TABLE CREATED BY A QUERY RUNNING ON A HADR STANDBY | |||
IT34381 | 2 | A DEADLOCK MAY RESULT WHEN MULTIPLE APPLICATIONS CONCURRENTLY INSERT INTO A COLUMN-ORGANIZED TABLE WITH AN IDENTITY COLUMN | |||
IT35993 | 2 | ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG | |||
IT33456 | 2 | DB2 MIGHT HANG IN PURESCALE SETUP UNDER A MEMORY CONSTRAINED SITUATION | |||
IT31723 | 3 | LOB PAGES MAY NOT BE REUSED PROPERLY IN PURESCALE. | |||
IT35082 | 3 | HIGH CPU AND DECREASED PERFORMANCE WITH HIGH CONCURRENCY OF INDEX CREATION (ON TEMP TABLES) | |||
Fix Pack m6fp0 - Data Management Utilities | |||||
IT36770 | 2 | IMPORT MAY BE TERMINATED IF SQL0437W IS DETECTED, ALTHOUGH IT CAN BE IGNORED IN MOST SCENARIOS. | |||
IT35679 | 3 | UNDER CERTAIN CONDITIONS, THE "NUMBER OF ROWS ..." MESSAGE FROM INGEST UTILITY ARE INCORRECT. | |||
IT34197 | 3 | DB2 MIGHT REPEATEDLY REPORT ISSUS IN SQLSMERGEREC | |||
Fix Pack m6fp0 - Data Recovery Services | |||||
IT34889 | 2 | DB2ADUTL DELETE LOGS WITHOUT PROMPTING" DELETES LOGS ONE BY ONE AND THEREFORE SLOWER THAN DELETING LOGS IN BATCH | |||
IT36461 | 2 | ACTIVATE DATABASE ON ONE MEMBER IN PURESCALE HUNG WHEN ANOTHER MEMBER IS EXECUTING CREATE INDEX ON HADR PRIMARY DATABASE | |||
IT35714 | 2 | PERFORMANCE OF DB2LOGGR MIGHT BE AFFECTED DUE TO UNNECESSARY SYMBOL RESOLUTION IN SQLPGRENAMEFILEDURINGLOGRECLAIM | |||
IT36569 | 2 | DB2FLSN TOOL INCORRECTLY DISPLAYS "N/A" AS THE MAXIMUM LSN FOR A LOG FILE INSTEAD OF THE ACTUAL MAXIMUM LSN VALUE. | |||
IT35119 | 2 | RESTORE USING "NO ENCRYPT" FROM A DOWNLEVEL ENCRYPTED BACKUP IMAGE WILL RESULT IN DB STILL BEING ENCRYPTED | |||
IT36140 | 2 | PERFORMANCE IMPACTS WITH HUGE AMOUNT OF ROW LOCKS | |||
IT36820 | 2 | DB2ADUTL FAILS TO READ DB CONFIG ON PURESCALE OR DPF ON NODES OTHER THAN CATALOG NODE | |||
IT33960 | 2 | SQL0206N OR SQL0901N ON STANDBY AFTER ALTER TABLE ADD COLUMN ON PRIMARY WHEN HADR IS STOPPED | |||
IT36378 | 2 | DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT. | |||
IT31624 | 3 | REDIRECT RESTORE WITH REBUILD OPTION FAILS WITH SQL2025N | |||
IT35695 | 3 | INCORRECT HADR_TARGET_LIST CONFIGURATION IN PURESCALE CAN RESULT IN UNEXPECTED SQL1776 RC 6 | |||
IT35161 | 3 | DB2CKLOG PASSES BUT RETURNS MESSAGES APPEARING TO BE ERRORS | |||
IT37302 | 3 | HADR TAKEOVER FAILED WITH SQL1770 RC 7 DUE TO EVENT MONITOR BLOCKS FORCING OFF ONLINE REORG ON PRIMARY | |||
IT34547 | 4 | DIA8550C MESSAGES FILLING UP DB2DIAG.LOG WHEN LOG PATH IS MAPPED TO AN UNC PATH IN WINDOWS ENVIRONMENT | |||
Fix Pack m6fp0 - Engine Other | |||||
IT36334 | 3 | ERROR LOG MAY BE CONTINUE TO GENERATE IN HADR CONFIGURED BY PACEMAKER ON AWS. | |||
Fix Pack m6fp0 - Federation | |||||
IT36252 | 1 | ROLLBACK THE FIX OF MARIADB LENGTH(CHAR) PUSHDOWN | |||
IT36413 | 1 | SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 | |||
IT36279 | 1 | SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739) | |||
IT35685 | 1 | QUERY WITH 'ORDER BY' AND REFERENCING A COMMON SUBEXPRESSION OVER COLUMN-ORGANIZED TABLES MAY RETURN ROWS IN THE WRONG ORDER | |||
IT34670 | 2 | ACCESSING HIDDEN COLUMNS WITH FEDERATION RECEIVES SQL0206N | |||
IT36474 | 2 | WILD POINTER REQUEST->AGT_RUNTIME_OBJ IN SQLQG_SIGNAL_HANDLER LEADS TO DATABASE CRASH | |||
IT33184 | 2 | THE MARIADB COLUMN LENGHT IS OVER 32K, BUT THE IMPORT FILE ONLY HAS 32768 CHARACTERS. | |||
IT33052 | 2 | WITH FEDERATION FUNCTION, IT IS POSSIBLE THAT INSERT STATEMENT WILL GET SQL1476N. | |||
JR63711 | 2 | DV ISSUE: PUSHDOWN ISSUE FOR DB2 AND ORACLE JDBC WRAPPER | |||
IT36387 | 2 | A FODC FMP TRAP IS REPORTED IN SQLQG_GET_TOSENDDATALEN WHILE QUERYING FEDERATION NICKNAMES | |||
IT34402 | 2 | FEDERATION MARIADB CURRENT TIMESTAMP "GETTING PARAMETER TYPE METADATA ARE NOT SUPPORTED" ERROR SQL1822 | |||
IT33183 | 2 | FEDERATION SERVER ODBC WRAPPER FETCHES KOREAN CHARACTERS FROM MARIADB, BUT RETURNS UNREADABLE TEXT. | |||
IT36380 | 2 | GET_CODEPAGE IS CALLED FOR EVERY PARAMETER MARKER WHICH CAUSED BAD PERFORMANCE IN DRDA WRAPPER | |||
IT36199 | 2 | POSSIBLE DB2FMP TRAP IN SQLQG_FMP_RUNTIME_OBJECT::GET_RSTATE_INF O() WHEN RUNNING FEDERATED QUERY | |||
IT35805 | 2 | MULTI-THREADED DB2FMP TRAPPED IN SYBASE CALLS INTERMITTENTLY | |||
Fix Pack m6fp0 - Index Manager | |||||
IT36812 | 2 | INSTANCE MAY CRASH WITH SQLIDUMPINXCURSOR ON THE STACK WHEN DUMPING FODC DIAGNOSTICS (-901 OR TRAP) | |||
IT36449 | 2 | DB2 PREP COMMAND FAILS WITH THE ERROR SQL0318N WHEN THE VALUES CLAUSE CONTAINS THE KEYWORD FOR. | |||
IT36256 | 3 | DB2 PREP COMMAND FAILS WITH SQL4003N 'THE SQL STATEMENT IS NOT SUPPORTED ...' OR SQL0104N 'UNEXPECTED TOKEN ...' ERROR | |||
Fix Pack m6fp0 - Install and Catalog Services | |||||
IT36454 | 2 | SQL0901N - INVALID FEDERATED THREE PART NAME | |||
IJ21543 | 2 | DB2PREREQCHECK SHOULD NOT CHECK MODPROBE FILE WHEN USING MELLANOX CX-4 IB/ROCE CARD ON LINUX PLATFORM | |||
IT25907 | 2 | -P <PORT> PARAMETER IS BEING IGNORED BY DB2ICRT | |||
IT34619 | 2 | ENHANCEMENT: SETUP.EXE CHECKS CURRENT DIRECTORY NAME WHETHER IT HAS SPACE(S) OR NOT ON WINDOWS | |||
IT35734 | 2 | SYSCODEPROPERTIES CONTINUONSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING | |||
IT36376 | 2 | EXPORT RETURNS SQL0204N "SYSTEM.SYSCAT.FUNCTIONS" IS UNDEFINED. | |||
IT33815 | 3 | REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR | |||
IT34188 | 3 | DB2LOOK CREATEDB OR PRINTDBCFG PARAMETERS DON'T REPORT THE ACURATE VALUE IN DB2LOOK FOR STRING_UNITS . | |||
IT36468 | 3 | REPLAY OF REVOKE ON HADR STANDBY WITH READS ON STANDBY ENABLED MAY RESULT IN A SMALL MEMORY LEAK | |||
IT31631 | 3 | CREATE .PROFILE IF IT DOESN'T EXIST WHEN RUNNING DB2ICRT (CREATE INSTANCE) | |||
IT34384 | 4 | DB2PREREQCHECK CHECKS FOR JAVA, BUT WE BUNDLE JAVA WITH DB2 | |||
Fix Pack m6fp0 - Monitoring | |||||
IT36150 | 2 | ADMIN_MOVE_TABLE CANNOT BE USED TO MOVE TABLE HAVING DOUBLE QUOTES IN NAME | |||
IT36521 | 2 | SQL405N REPORTED BY DB_MEMBERS AND DB_PARTITIONS TABLE FUNCTIONS IF NETNAME EXCEEDS 128 CHARACTERS IN DB2NODES.CFG | |||
IT34510 | 3 | DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION | |||
Fix Pack m6fp0 - Parsing and SQL PL | |||||
IT30559 | 2 | DB2 MAY ABEND WHILE COMPILING COMPOUND SQL (COMPILED) STATEMENTS | |||
Fix Pack m6fp0 - Platform Specific | |||||
IT33313 | 2 | "DB2" FRONT END PROCESS DOES AN UNNECESSARY INTERNAL INITIALIZATION WHICH MIGHT CAUSE A PERFORMANCE DEGRADATION | |||
IT36041 | 3 | ALTER TABLESPACE WITH NO FILE SYSTEM CACHING OPTION FAILS ON LINUX390 | |||
IT35710 | 3 | INTERMITTENT FAST PREALLOCATION FAILURES ON AIX | |||
Fix Pack m6fp0 - Problem Determination | |||||
IT36266 | 2 | INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS | |||
IT34869 | 2 | DB2PD -DBPTNMEM CAN CRASH IF USING USING MEMBER NUMBERS GREATER THAN 9 | |||
IT35318 | 2 | LARGE PRIVATE MEMORY LEAK WHEN PD_GET_DIAG_HIST IS INTERRUPTED PROCESSING A LARGE DB2DIAG.LOG OR NOTIFY FILE | |||
IT37300 | 3 | NO OUTPUT RETURNED USING PD_GET_LOG_MSGS OR PDLOGMSGS_LAST24HOURS ON WINDOW ENVIRONMENT | |||
Fix Pack m6fp0 - Process Model | |||||
IT36331 | 1 | IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND | |||
IT36504 | 2 | WHEN THE DBNAME DOES NOT MATCH THE DBALIAS HADR FAILS TO START ON THE PRIMARY | |||
IT35376 | 2 | DB2 MIGHT CAUSE EXCESSIVE LOGGING (SQL0952N MESSAGES) WHEN A QUERY IS INTERRUPTED. | |||
IT36821 | 2 | SET EVENT MONITOR STATE STATEMENTS MAY BE INCORRECTLY QUEUED BY THE ADAPTIVE WORKLOAD MANAGER | |||
IT36833 | 2 | OCCURS ON PARTITIONED DATABASE, DB2 MAY CRASH WHEN TRYING TO UNLATCH A LATCH THAT IS NOT HELD | |||
IT33580 | 2 | INCORRECT ESTIMATION OF PARTITIONS WHERE QUERY MAY EXECUTE MAY CAUSE EXCESSIVE QUEUING WITH THE ADAPTIVE WORKLOAD MANAGER | |||
IT36862 | 2 | POSSIBLE 15 SECOND DELAY IN SQLEPEEKREQUEST | |||
IT33410 | 2 | SQL1041 DB2 NOT FOLLOWING NUMDB SETTING | |||
IT34227 | 3 | ADMIN_CMD AND GET_DB_CONFIG CANNOT HANDLE EXTENDED NUMBER RANGE OF LOGBUFSZ | |||
IT35832 | 3 | SQLCODE -1229 CONTINOUSLY WRITTEN IN DB2DIAG.LOG AFTER NODE FAILURE | |||
IT36113 | 3 | V11.5.5 ONLY: DB2ADUTL COMMAND FAILS WITH SQL1031N IN PURESCALE ON ALL MEMBERS EXCEPT MEMBER 0. | |||
Fix Pack m6fp0 - Query Compiler Optimizer | |||||
IT36104 | 1 | DB2ADVIS WILL THROW A -901 ON A QUERY THAT IS ORDERED BY AN EXPRESSION | |||
IT35953 | 1 | INSERT FROM COMPLEX SELECT WITH ORDER BY IN DPF MODE MIGHT LEAD TO SEGV TRAP | |||
IT34668 | 1 | INSERT INTO COLUMN-ORGANIZED TABLE FROM COMPLEX SUBSELECT CAN TRAP DURING QUERY OPTIMIZATION | |||
IT34102 | 2 | CURSOR-BASED UPDATE OR DELETE OF ROWS ON A TABLE WITH A RCAC DEFINED MAY LEAD TO A TRAP | |||
IT35309 | 2 | DYNAMIC QUERY EXECUTION FAILS WITH SQLCODE -901 REASON CODE "CONSTANT OF UNSUPPORTED TYPE" | |||
IT35997 | 2 | SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR | |||
Fix Pack m6fp0 - Query Compiler QGM | |||||
IT34871 | 2 | USING WRONG DELIMITER MIGHT CAUSE THE INSTANCE CRASH | |||
IT35066 | 2 | LPAD OR RPAD BUILTIN FUNCTION FAIL WITH -901 "VALUE IS TOO LARGE FOR THE BUFFER" | |||
IT35055 | 2 | DB2 SERVER TERMINATES ABNORMALLY WHEN AUTO_REVAL=DEFERRED_FORCE | |||
IT36401 | 2 | 901-COLUMN NUMBER OUT OF RANGE DURING QUERY COMPILATION, FORM_CSE CALL STACK | |||
IT34347 | 2 | MONTHS_BETWEEN FUNCTION IN NPS MODE RETURN NEGATIVE | |||
IT33192 | 2 | DB2 QUERY MAY ABEND WHEN THERE ARE COMMON TABLE EXPRESSION USED IN UNION | |||
IT36384 | 2 | UPDATE STATEMENT WITH IN/EXISTS MAY GENERATE SQLCODE -913 | |||
IT36742 | 2 | SQL0901N WHEN DB2 QUERY HAS CDE TABLE AND JOIN PREDICATE HAS TYPE MISMATCH | |||
IT35085 | 2 | DB2 SERVER MAY TERMINATE ABNORMALLY WITH SQLDCSL_BADPAGE "BAD DATA PAGE" | |||
IT36106 | 2 | SQL0901 ON SELECT SAMPLE.TEST FOR SYSTEM_TIME BETWEEN | |||
IT35059 | 2 | LPAD, RPAD OR REPLACE MAY RESULT IN SQLCODE -901 WHEN SOURCE-STRING REFERENCES A COLUMN-ORGANIZED TABLE COLUMN | |||
IT30018 | 2 | DB2 MAY RUN OUT OF STATEMENT HEAP WHILE COMPILING QUERIES INVOLVING UNIONS AND PREDICATES WITH WEAK UDTS | |||
IT36441 | 3 | DB2 QUERY PERFORMS BAD WHEN USING SUBQUERY PREDICATE WITH OR | |||
IT36498 | 3 | DB2 MAY RETURN -901 WHEN IMPLICITLY CASTING NON-STRING TO A STRING AND THE ENVIRONMENT DEFAULT STRING UNITS ARE CODEUNITS32. | |||
IT35058 | 3 | SUBSTR IN COLUMN ORGANIZED COLUMN COMPARISON RETURN WRONG RESULTS | |||
IT36473 | 3 | TRUNCATE TABLE WITHOUT IMMEDIATE ON CDE TABLES WITH DELIMITED IDENTIFIERS FAILS | |||
IT36320 | 3 | QUERY EXECUTION MAY FAIL FOR OUTER JOIN QUERIES WITH PREDICATES WITH CAST FUNCTIONS | |||
IT35062 | 3 | CREATING AN EXPRESSION-BASED INDEX FAILS WITH -356 AND EMPTY REASON CODE | |||
IT36388 | 3 | UNEXPECTED SQL206 WHEN COLUMN NAME OR COLUMN NAME QUALIFIER HAS TRAILING SPACES | |||
IT33287 | 3 | WRONG RESULT/901 WHEN IN USED ON SELECT | |||
Fix Pack m6fp0 - Relational Data Services | |||||
IT36046 | 2 | PANIC MAY OCCUR IN HADR TAKEOVER | |||
IT36853 | 2 | DB2AGENT REPORTED SQLD_PARM ERROR WHEN TRUYING TO FIND/FIX TCB WITH OBJECTID=0 | |||
IT35518 | 2 | DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE | |||
IT34418 | 2 | QUERY INTERRUPT DOES NOT RETURN SQL0952N WHEN A WLM THRESHOLD WAS CREATED | |||
IT32552 | 2 | MULTIPLE SEVERE/INFO MESSAGES WITH -803 COULD BE RECORDED IN DB2DIAG.LOG AND MAY AFFECT PERFORMANCE | |||
Fix Pack m6fp0 - Sailfish Operational Compatibility | |||||
IT36751 | 1 | EXTERNAL TABLES WITH LFINSTRING OPTION MAY FAIL IF DATA CONTAINS A FIELD INCLUDING A NON ESCAPED DELIMITER CHARACTER | |||
IT35075 | 2 | SELECTING FROM AN EXTERNAL TABLE THAT USES LFINSTRING ON CAN FAIL WITH SQL5199N | |||
Fix Pack m6fp0 - Security | |||||
IT36475 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO AN INFO. DISC. FOR USERS WHO CREATE AN INLINE SQL FUNC. WHEN AUTO_REVAL SET TO DEFFERED_FORC | |||
IT40980 | 2 | Security: IBM Db2 may be impacted by a Denial of Service | |||
IT36418 | 2 | LDAP PLUGIN NOW ALLOWS CONFIGURATION TO CHECK LDAP PASSWORDPOLICYRESPONSE | |||
IT36177 | 2 | WHEN USING GSSPLUGIN IBMIAMAUTH.SO CRASHES DB2 | |||
Fix Pack m6fp0 - pureScale Services | |||||
IT36431 | 2 | DB2CLUSTER -VERIFY FAILURE DUE LATE SERVER STARTUP | |||
IJ27796 | 2 | "LIST INDOUBT TRANSACTIONS" COMMAND PERFORMANCE IMPROVEMENT WITH PURESCALE. | |||
IT29557 | 2 | MORE ROBUST CLEANUP STATUS CHECKING | |||
IT35801 | 2 | MISMATCH THAT THE OS HOSTNAME VALUE IS LOWER-CASED WHEREAS THE H ADR_LOCAL_HOST/HADR_REMOTE_HOST VALUES ARE UPPER-CASED. THIS SHO | |||
IT37103 | 2 | PURESCALE DELETE ROWS PERFORMANCE REGRESSION ON RDMA NETWORKS | |||
IT35828 | 3 | "DB2CLUSTER -CFS -SET -OPTION CCRENABLED -VALUE NO" COMMAND TIMES OUT | |||
IT36816 | 3 | DB2CLUSTER -CFS -EXIT -MAINTENANCE MAY FAIL WITH RC=2 | |||
IT36894 | 3 | "TOO MANY ARGUMENTS" MESSAGE WHEN RUNNING DB2CM -CREATE -DB IN HADR WITH PACEMAKER WITH MULTIPLE STANDBY SETUP | |||
IT36393 | 3 | CIB ATTRIBUTE FAILED TO SET DURING PRIMARY REBOOT | |||
IT36457 | 4 | AFTER A REBOOT, HADR DATABASE MAY FAIL TO BE ACTIVATED BY AUTOMATION. |
DB2 Version 11.5 Fix Pack m5fp1 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract | |||
IT34838 | 2 | LEFT FUNCTION CAN NOT BE PUSHED DOWN | |||
IT35883 | 3 | INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE | |||
IT34960 | 3 | DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS. | |||
IT32664 | 3 | XML INDEXES NOT USED IN DB2 11.5 EXPLAIN PLAN | |||
IT35798 | 3 | SLOW PERFORMANCE IN DPF OR CDE WHEN RUNNING A QUERY WITH SCALAR SUBQUERIES AND AN OUTER JOIN | |||
IT34748 | 3 | UPDATE STATEMENT SLOW PERFORMANCE CAUSED BY LATCH CONTENTION DURING THE MEMORY ALLOCATIONS. | |||
IT35017 | 3 | CDE JOIN MINMAXINFO DUMP: TRAP DUE TO DEREFERRENCING NULL POINTER | |||
IT35185 | 3 | DB2 MIGHT TRAP IN SQLRWTABLEMETRICSBUILDER::EXECUTE DURINGEXECUTION OF THE MON_GET TABLE FUNCTION | |||
IT35705 | 3 | DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE | |||
IT35439 | 3 | DB2ADV_VPC.LIC CAN MAKE Q REP FUNCTIONS AVAILABLE, IT IS NOT THE EXPECTED RESULT | |||
IT36027 | 3 | IMPROVEMENTS TO CDE JOIN MEMORY USEAGE. REDUCTION OF MEMORY NEEDED AND REDUCTION OF -955 ERRORS. | |||
IT33529 | 3 | PRESENCE OF CANDIDATE ACCESS PLAN WITH SINGLE-NODE HASH-DIRECTED PARTITIONING PREVENTS OPTIMAL PLAN WITH REPARTITIONED JOIN | |||
IT35680 | 3 | HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR | |||
IT34693 | 3 | DB2UNINS OF DATA SERVER CLIENT REMOVES SHARED C++ REG KEYS | |||
IT34396 | 3 | PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING | |||
IT34242 | 3 | BAD PERFORMANCE DUE TO DELAYED JOIN PREDICATE PUSHDOWN THROUGH UNION ALL PREVENTS JOIN ELIMINATION | |||
IT35833 | 3 | SQL1585N IS INCORRECTLY RETURNED FOR CERTAIN TYPES OF QUERIES | |||
IT34658 | 3 | DB2 QUERY MAY GENERATE FODC AND APP_ERR OR WRONG RESULT IN CERTAIN CONDITIONS | |||
IT35047 | 3 | MGB:STORED PROCEDURE CALLS PERFORMANCE ARE SIGNIFICANTLY WORSE AFTER MIGRATION | |||
IT34559 | 3 | ELEMENT ALLOCATION ISSUE, AND ONE OF THE VECTORS WAS MESSED UP AND CAUSE TRAP/SEGFAULT. | |||
IT31536 | 3 | MON_GET_LOCKS FAILS IN DPF WITH SQL1607N BECAUSE OF UNDERLYING RPC MECHANISM BEING LIMITED TO 2 GIGABYTES | |||
IT34108 | 3 | NLJN NOT PUSHING DOWN | |||
IT35033 | 3 | CUSTOMERS ENCOUNTERING ASN0569E DUE TO OUT-OF-ORDER REPLICATION LOG RECORDS DURING SAVEPOINT ROLLBACK | |||
IT35728 | 3 | SQL0407N WHEN COMMON SUBQUERY HAS VALUES | |||
IT35548 | 3 | HADR STANDBY FORCE DB SHUTDOWN, DB2DIAG.LOG SHOWS OBJECT IS NOT MARKED PENDDEL | |||
IT35739 | 3 | DB2 QUERY MAY NOT GENERATE TRAILING SPACE WHEN MINUS/EXCEPT IS USED IN THE QUERY. | |||
JR62967 | 3 | DB2 V11.5 QUERY PLAN WITH "UNION ALL" IS DIFFERENT FROM QUERY PLANS IN V11.1 | |||
IT35880 | 3 | DB2 11.5 PERF DEGRADATION ON LINUX: O_SYNC AND NOT O_DSYNC USED | |||
IT35992 | 3 | SQL0811N WHEN THERE IS SCALAR SUBQUERY WITH FETCH FIRST 1 ROWS | |||
IT36210 | 3 | IN VERY RARE CASE OF CDE RIGHT OUTER JOIN PROCESSING TRAP IS POSSIBLE. | |||
IT35399 | 3 | FEDERATED SERVER OPTION CONCURRENT_ACCESS_RESOLUTION='W' CAUSES CLI019E INVALID ATTRIBUTE ERRORS | |||
Fix Pack m5fp1 - Abstract Data Types and Spatial Extender | |||||
IT35444 | 2 | MULTIPLE MEMORY LEAKS IN GEO-SPATIAL CALLS WHEN EXECUTING CERTAIN GEO-SPATIAL FUNCTIONS | |||
Fix Pack m5fp1 - Buffer Pool Services | |||||
IT33994 | 2 | DB2 MAY HANG SHORTLY AFTER COMMITTING A CREATE TABLE WITH AN AGE NT WAITING FOR SQLO_LT_SQLD_TCB__LOADINPROGRESS LATCH IN SQLBFIX | |||
IT36108 | 2 | INTERRUPTING ALTER TABLESPACE REDUCE MAY CAUSE A MEMBER SHUTDOWN | |||
Fix Pack m5fp1 - CDE Data | |||||
IT35182 | 2 | CLEANUP OF IN-MEMORY STRUCTURE WHEN LOADING OF THE DICTIONARY FAILS (ADD CODE TO HANDLE EXCEPTIONS GRACEFULLY). | |||
IT34037 | 2 | DEADLATCH BETWEEN ONE THREAD WRITING A DICTIONARY TO DISK USING VECTORIZEDADC AND ANOTHER THREAD DOING A NEW EXTENT ALLOCATION | |||
Fix Pack m5fp1 - CDE Query | |||||
IT35163 | 1 | DB_MIGRATE HANGS WHEN USING ORDER BY CLAUSE | |||
IT36230 | 2 | DB2 TRAP IN FUNCTION EXTRAPAYLOADITERATOR::COPYPAYLOADSTO | |||
IT35211 | 2 | POSSIBLE SIGSEGV IN Q REPLICATION DUE TO INCORRECT LOG RECORDS FOR COLUMN-ORGANIZED DGTT IN DPF ENVIRONMENT | |||
IT35158 | 2 | REDUCE LIKELYHOOD OF SQL0954C FOR COLUMNAR ORGANIZED HSJN PLANS | |||
Fix Pack m5fp1 - Client Interfaces | |||||
IT35521 | 1 | CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS | |||
IT34606 | 2 | USING CFGREFRESHINTERVAL IN A MULTI-THREADED CLI APPLICATION LEADS TO SEGMENTATION FAULT | |||
IT34589 | 2 | ON WINDOWS PLATFORM CLIDRIVER CAN LOG SQL1531N DURING CONNECT EVEN WHEN CONNECTION IS SUCCESSFUL WITH SQL_SUCCESS_WITH_INFO | |||
IT35405 | 3 | CAN'T CONNECT TO DB2 VIA EXCEL 2016 USING DATA --> ?GET EXTERNAL DATA? WHEN UPGRADING RUNTIME CLIENT TO 11.5 | |||
Fix Pack m5fp1 - Codegen and Runtime | |||||
IT35377 | 2 | WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATKnown IssueT TABLE ON THE INNER AND NULL KEYS. | |||
IT35486 | 2 | DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG. JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT. | |||
IT34579 | 3 | DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY FAIL WITH SQL2079N ERROR | |||
Fix Pack m5fp1 - Communication | |||||
IT35289 | 1 | SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND (CVE-2020-5024) | |||
IT34882 | 2 | INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL | |||
IT34504 | 2 | GSKKM_STORECACERT: GSKIT ERROR = 100 ERRORS IN DB2DIAG.LOG | |||
Fix Pack m5fp1 - DRDA Services | |||||
IT35750 | 2 | THE FUNCTION WHICH TESTS THE 'FAILOVER' MEMBER DOES NOT TAKE SSL INTO ACCOUNT. | |||
IT34432 | 2 | FAILBACK PING INCORRECTLY USES TCPIP INSTEAD OF SSL | |||
Fix Pack m5fp1 - Data Management Services | |||||
IT34294 | 1 | SECURITY: IBM® DB2® IS VULNERABLE TO A DENIAL OF SERVICE ON WINDOWS (CVE-2020-4642) | |||
Fix Pack m5fp1 - Data Management Utilities | |||||
IT35936 | 2 | DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATKnown IssueT FUNCTION | |||
IT35965 | 3 | REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN | |||
Fix Pack m5fp1 - Engine Other | |||||
IT35987 | 2 | "114 ATTEMPT TO ACCESS ITEM BEYOND BOUNDS OF MEMORY" ERROR OCCURED IN 32 BIT MODE. | |||
Fix Pack m5fp1 - Federation | |||||
IT33598 | 2 | INSERT STATEMENT FAILS WITH -901 ERROR USING FEDERATION | |||
IT35968 | 2 | WHILE QUERYING THE WEB SERVICE NICKNAME, FEDERATION SERVER REPORTS ERROR SQL1822N | |||
IT34588 | 2 | SQL30090N WHEN WE USE UPDATE WITH PLACEHOLDER (VARIABLE) VIA JDBC | |||
IT35226 | 2 | CREATE OR REPLACE NICKNAME ON REMOTE DB2I SERIES (AS400) FAILS WITH SQL0901 AND DUMP FOLDER FODC_APPERR IS CREATED | |||
JR62802 | 2 | PROBLEM RUNNING UPDATE ON MARIADB (FEDERATION) | |||
IT34941 | 2 | QUERY ON NICKNAME RESULTS WITH VALUES TRUNCATED ON MARIADB | |||
IT34862 | 2 | DB2 CRASH DUE TO A -901 WAS RAISED BY MINMAXPARTIALEVALUATOR.CPP WHEN MAX(TO_CHAR()) OR MIN(TO_CHAR()) EXISTS IN THE SELECT LIST | |||
Fix Pack m5fp1 - Install and Catalog Services | |||||
IT35672 | 2 | UPDATING NETNAMES HIT ISSUE SAYING RSCT PEER IN REGISTRY DOES NOT MATCH ACTIVE DOMAIN NAME | |||
IT33810 | 2 | INVALID LICENSE ERROR USING DB2 CONNECT LICENSE WITH .NET CLI DRIVER ON OPENSHIFT CONTAINER | |||
Fix Pack m5fp1 - Platform Specific | |||||
IT34929 | 2 | ADD ENVVAR TO OVERRIDE WINDOWS COMMONAPPDATA PATH | |||
Fix Pack m5fp1 - Problem Determination | |||||
IT33783 | 2 | DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H (TIME PERIOD SPECIFIERS) | |||
Fix Pack m5fp1 - Process Model | |||||
IT34261 | 1 | IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND | |||
Fix Pack m5fp1 - Query Compiler Optimizer | |||||
IT35198 | 1 | A QUERY ON COLUMNAR TABLES MAY RETURN MORE ROWS THAN EXPECTED | |||
IT35183 | 2 | POOR QUERY PERFORMANCE WHEN IN SUBQUERY PREDICATE WITH NO DISTINCT. | |||
Fix Pack m5fp1 - Query Compiler QGM | |||||
IT34950 | 1 | DB2 SERVER TERMINATES ABNORMALLY WHEN SELECT FROM INVALID VIEWS | |||
IT34758 | 2 | SELECT DISTINCT QUERY FAILS WITH SQL0421 WHEN USED WITH SCROLLABLE CURSOR | |||
IT35670 | 2 | REGEXP_REPLACE AND REGEXP_SUBSTR WITH COLUMN-ORGANIZED TABLE MAY RESULT IN -901 | |||
IT34613 | 2 | INCORRECT RESULTS WITH DB2_EXTENDED_OPTIMIZATION='MQTENFORCE REPLICATED' | |||
IT35925 | 2 | DISTRIBUTION KEY ORDER IS NOT INHERITED FROM THE AS-RESULT-TABLE WHEN COISBAR IS ENABLED | |||
IT34311 | 2 | QUERY WITH ALIAS FOR COMPLEX COLUMN USED IN GROUP BY CLAUSE TRAPS AND GENERATES FODC | |||
IT34860 | 2 | DB2 QUERY MAY HANG WITH REGISRTY SETTING INJ_DUMMY_PRD4JOIN | |||
IT34304 | 2 | SQL0344N ERROR MAY OCCUR IN NON-UNICODE, VARCHAR2 ENABLED DATABASE WHEN QUERY REFERENCES SYSIBM.SYSDUMMY1 OR SYSIBM.DUAL | |||
IT34222 | 3 | 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE | |||
IT34940 | 3 | WRONG RESULT WHEN EQUALITY PREDICATE HAS IS NOT NULL WITH FALSE ON OTHER SIDE. | |||
Fix Pack m5fp1 - Relational Data Services | |||||
IT33355 | 2 | DEADLOCK BETWEEN INVALIDATION OF PACKAGE AND IMPLICIT REBIND OF THE SAME PACKAGE. | |||
IT35546 | 2 | -901 SQLCODE DURING REBIND FOR PACKAGES BOUND WITH CERTAIN BIND OPTIONS | |||
IT34671 | 2 | MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK | |||
IT33429 | 2 | SQL1598N MIGHT BE RAISED IF A LICENSE WAS NOT APPLIED BEFORE SIMULTANEOUS ATTEMPTS TO CONNECT THROUGH THE DATA SERVER DRIVER | |||
IT35221 | 2 | WLM ADMISSION CONTROL DOES NOT PROPERLY TRACK ACTUAL MEMORY HIST ORY FOR SHORT QUERIES. THIS CAN LEAD TO UNNECESSARY QUEUING OF V | |||
Fix Pack m5fp1 - Sailfish Operational Compatibility | |||||
IT35770 | 2 | OOM HIT WHILE RUNNING ET NZ INTERNAL FORMAT MIGRATION. | |||
IT35855 | 2 | MEMORY LEAK ENCOUNTERED WHEN YOU HAVE MORE THEN 1COLUMN OF SAME TYPE FROM TIMESTAMP/TIME/DATE WITH DB2 FORMAT SPECIFIED FOR IT | |||
IT35165 | 2 | DB_MIGRATE ISSUE WITH INTERNAL FORMAT WHEN INPUT STRING AFTER CODEPAGE CONVERSION EXCEED THE TARGET COLUMN SIZE. | |||
Fix Pack m5fp1 - Security | |||||
IT35445 | 1 | SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976) | |||
IT36060 | 2 | IN RARE INSTANCES, DB2 11.5.5 MAY CRASH DURING DB2START WHEN JWT AUTHENTICATION IS ENABLED | |||
IT36085 | 2 | DB2 11.5.5 MAY ENCOUNTER SQL30082N RC 15 WHEN USING GSS_SERVER_ENCRYPT OR KRB_SERVER_ENCRYPT AUTHENTICATION | |||
Fix Pack m5fp1 - pureScale Services | |||||
IT36088 | 1 | DB2CLUSTER -VERIFY MIGHT FAIL DURING RDMA PING DUE TO SEG FAULT | |||
IT36086 | 1 | DB2CLUSTER -VERIFY POTENTIAL HANG | |||
IT35303 | 1 | SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025) | |||
IT35552 | 2 | CF CHANGE TO ADD BREATHING POINT FOR DAT_EVD_DEQUEUE | |||
IT35558 | 2 | SIGNAL 11 TRAPS DURING CTSNAPS AFTER ROCE CABLE PULLS | |||
IT35662 | 2 | CREATE TABLE STATEMENTS ARE HANGING DUE TO RDMA COMMUNICATION TIMEOUTS BETWEEN MEMBER AND CF ON ZLINUX |
DB2 Version 11.5 Fix Pack m5fp0 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract | |||
Fix Pack m5fp0 - 1 | |||||
IT34866 | 3 | IT34866: ADDITIONAL FIX TO Known Issue IT13674, TEST FOR -NOEXEC MOUNT INCORRECTLY FAILS IN DB2SETUP SCRIPT | |||
IT33863 | 3 | PURESCALE MEMBER MIGHT HANG WAITING FOR SQLO_LT_SQLB_BPD__BPDLAT CH_SX WHILE IN SQLBGBUPGRADELATCHFROMSHAREDURINGWAR | |||
IT33576 | 3 | REDUCE CHANCE OF SQL0289N | |||
IT33525 | 3 | INACCURATE RESULT OF DECIMAL DIVISION ON NON-AIX PLATFORM | |||
Fix Pack m5fp0 - Administration Tools | |||||
IT34534 | 3 | DB2 ADMINISTRATIVE TASK SCHEDULER STOPS EXECUTING SCHEDULED TASKS | |||
Fix Pack m5fp0 - Buffer Pool Services | |||||
IT34560 | 2 | DB2 ENGINE ABEND FOLLOWING DROP TABLE AND SQLBPREPARE2FREEEXTONTEMPSMP SEVERE ERROR | |||
Fix Pack m5fp0 - CDE Data | |||||
IT33714 | 1 | RUNNING REPLICATED CDE WORKLOAD WITH INVALID DB2_DCC_FILE_PATH VALUE WILL CAUSE DB2 TO FAIL WITH SQL1224. | |||
IT33570 | 2 | A CDE UPDATE STATEMENT MIGHT FAIL WITH SQL0901N '!ISROWLOGBUFFERINITIALIZED()' AND TRAP IN SQERDFSROWSERIALIZER | |||
IT34280 | 2 | CREATE TABLE FAILING WITH "NO MEMORY AVAILABLE IN 'APPLICATION HEAP' | |||
IT34500 | 2 | REORG RECLAIM CODE CAN LEAD TO DEADLATCH | |||
IT33707 | 2 | FODC_FORCEDBSHUTDOWN OCCURS AFTER AN INSERT STATEMENT IS INTERRUPTED AND ATTEMPTS TO ROLL BACK. | |||
Fix Pack m5fp0 - CDE Query | |||||
IT34026 | 2 | INSTANCE COULD GO DOWN WHEN DOING A FULL OUTER JOIN ON TWO COLUMNAR ORGANIZED TABLES WITH NULL COLUMNS | |||
IT34235 | 2 | IMPROVE PERFORMANCE BY IMPLEMENTING SCALAR FUNCTIONS DAYOFMONTH, DAYS_TO_END_OF_MONTH IN COLUMNAR ORGANIZED LOGIC. | |||
IT34147 | 2 | VARIOUS ERROR POSSIBLE: SQL0901N , SQL0955N | |||
IT33467 | 2 | CDE HSJN WITH RESIDUAL PREDICATES THAT HAVE SCALAR FUNCTION APPL IED TO A HOST VARIABLE OR REGISTRY VARIABLE COULD FAIL WITH -901 | |||
IT33293 | 2 | QUERY FAILING WITH SQL0901N AND AN ASSERTION FAILURE "UNABLE TO ACCESS TARGET PAGE FROM PAGE MAP" | |||
Fix Pack m5fp0 - Client Interfaces | |||||
IT33902 | 2 | INTERMITTENT FAILURE WITH CLR_EXCEPTION_SYSTEM.OBJECTDISPOSEDEXCEPTION | |||
IT31498 | 3 | SQL2731N WHEN AN INPUT FILE SIZE OF ZLOAD IS BIGGER THAN 4GB | |||
IT32956 | 3 | DB2 .NET PROVIDER WITH DOUBLE HYPHENS (--) STYLE COMMENT IN SQL STATEMENT HAVING NAMED PARAMETERS THROWS SQL0206N | |||
IT32276 | 3 | NO SQL OVERFLOW ERROR WHEN INSERTING A DECIMAL(20,4) THAT DOES NOT FIT INTO A SMALLINT OR INTEGER COLUMN | |||
IT33640 | 3 | IBM DATA SERVER ADD-INS FOR VISUAL STUDIO (VSAI) DOES NOT SHOW NON-TABLE SCHEMAS | |||
Fix Pack m5fp0 - Codegen and Runtime | |||||
IT33578 | 2 | OPTIMIZE THE PERCENTILE_CONT AGGREGATE FUNCTION TO USE MEMORY MORE EFFICIENTLY AND SPILL TO TEMP IF REQUIRED | |||
IT33236 | 2 | COMPLEX QUERIES WITH EXISTS CLAUSE ON A COLUMNAR TABLE EXECUTED WITH DEGREE GREATER THAN 1 MAY HANG | |||
Fix Pack m5fp0 - Data Recovery Services | |||||
IT32894 | 1 | DB2 : SET WRITE RESUME COMMAND HANGS | |||
IT34022 | 2 | DB2 MIGHT TRAP WHEN EXECUTING MON_GET_UNIT_OF_WORK | |||
IT33533 | 3 | SQL0913 RC=80 NOT BEING CAPTURED BY DB2PDCFG -CATCH LOCKTIMEOUT | |||
IT32560 | 3 | ILOGS ARE ARCHIVED TO BOTH LOG ARCHIVING METHODS ONLY FROM THE ACTIVE LOG PATH WITH DUAL LOGGING ENABLED | |||
Fix Pack m5fp0 - Federation | |||||
IT32523 | 1 | PRIVATE MEMORY LEAK DURING DDL ON COLUMN-ORGANIZED TABLES IN DPF ENVIRONMENT | |||
JR62529 | 2 | QUERIES ON NICKNAMES TO TABLE ON MARIADB RETRIEVES ONLY FIRST CHARACTER OF COLUMN NAMES | |||
JR62557 | 2 | FEDEATION MARIADB JDBC: DATA TYPE MAPPING ERROR | |||
JR62556 | 2 | INSERT INTO SELECT ERROR ON JDBC | |||
Fix Pack m5fp0 - Index Manager | |||||
IT31287 | 1 | DB2 MAY TRAP WHEN USING SELECT RID_BIT() FUNCTION ON A COLUMN ORGANIZED TABLE | |||
Fix Pack m5fp0 - Install and Catalog Services | |||||
IT33705 | 1 | AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES | |||
IT32984 | 1 | SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4411) | |||
IT32939 | 1 | SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4412) | |||
IT34221 | 1 | SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT | |||
IT33708 | 2 | DB2ICRT FAILS WHEN CHECKING GPFS ON PURESCALE | |||
IT33515 | 2 | AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES | |||
IT34039 | 2 | TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS FOR CDE TABLE MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT. | |||
IT32679 | 2 | ROUTINE MIGRATION FAILS WITH A SQL0478N WHEN A ROUTINE IS USED AS PART OF A TABLE DEFINITION | |||
IT33548 | 2 | AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES | |||
IT33712 | 3 | COMPLETE FIX FOR IT13674 | |||
IT33312 | 3 | DB2ICRT AND DB2PREQCHECK FREE SPACE AND HOST FAILURE | |||
Fix Pack m5fp0 - JDBC Driver | |||||
IT32581 | 3 | CLPPLUS 11.5 CLIENT THROWS EXCEPTION SQL20570N WITH EXTERNAL TABLE OPERATION HAVING EMPTY FILE WITH GZIP COMPRESSION | |||
IT33041 | 3 | JCC DRIVER NOT SENDING COMMIT AFTER THE LICENSE SP CALL EVEN IF AUTOCOMMIT IS TRUE | |||
IT33602 | 2 | INSERT FROM EXTERNAL TABLE FAILS WITH SQLCODE -4499 -T2LUW | |||
Fix Pack m5fp0 - Monitoring | |||||
IT34023 | 2 | FODC_PANIC WITH INVALID LATCH FROM SQLOLATCHCAS64.C WHEN ROUTINE EXECUTION LIST MONITORING IS ENABLED. | |||
IT33264 | 3 | CAPTURE_STORAGE_INFO MAY FAIL WITH SQL0443N | |||
Fix Pack m5fp0 - Parsing and SQL PL | |||||
IT34440 | 2 | ABNORMAL TERMINATION WHEN EXECUTING THE CREATE-STATEMENT OF A NZPLSQL STORED PROCEDURE | |||
IT33885 | 3 | DB2 MAY ATTEMPT TO REPEATEDLY OPEN A NON-EXISTENT FILE WHICH MAY IMPACT QUERY COMPILATION PERFORMANCE | |||
Fix Pack m5fp0 - Platform Specific | |||||
IT34140 | 1 | SQL20569N WITH REASON CODE "4" DURING LOADING LZ4 COMPRESSED | |||
IT34101 | 3 | FMP PROCESS CAN HANG IN NESTED SIGNAL HANDLER CODE PATH | |||
Fix Pack m5fp0 - Problem Determination | |||||
IT33783 | 2 | DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H (TIME PERIOD SPECIFIERS) | |||
Fix Pack m5fp0 - Process Model | |||||
IT33508 | 1 | IN DPF ENV, SORTSHRHEAPUTIL THRESHOLD MAY NOT TRIGGER PREDICTIVELY FOR QUERIES USING SORT MEMORY ON DATA NODES | |||
IT34607 | 2 | DB2CFIMP ADDS TRAILING CHARACTERS TO DB ALIAS. | |||
IT33186 | 2 | LOCK-WAIT ON DECOUPLED DB2ADCBLD | |||
IT34257 | 2 | DB2 WLM MAY CAUSE UNNECESSARY QUEUING AFTER INSERTS TO EXTERNAL TABLES IN A PARTITIONED DATABASE | |||
IT34284 | 2 | SORT MEMORY HARD CAPPING AND OVER-ESTIMATION ERROR CORRECTION FIXES IN WLM | |||
IT33826 | 2 | LIST STORAGE ACCESS COMMAND GIVES 0 ENTRIES EVEN IF THE CATALOG STORAGE ACCESS COMPLETED SUCCESSFULLY | |||
Fix Pack m5fp0 - Quality Assurance | |||||
IT34614 | 4 | SECURITY: MULTIPLE BUFFER OVERFLOW VULNERABILITIES AFFECT DB2 | |||
Fix Pack m5fp0 - Query Compiler Optimizer | |||||
IT33554 | 2 | SQL0901N PARTITIONED BLU SORT WITH 0 PARTCOLS IS UNEXPECTED | |||
IT34007 | 2 | DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE. | |||
IT33338 | 2 | COLUMNAR SEARCHED UPDATE AND DELETE STATEMENTS EXECUTING WITH HS JOIN THAT APPLIES RESIDUAL PREDICATES MIGHT FAIL WITH SQL0901N " | |||
Fix Pack m5fp0 - Query Compiler QGM | |||||
IT32992 | 1 | WRONG RESULT, WHEN OPTIMIZATION LEVEL IS LESS THAN 5 AND NULL EQUALS NULL PREDICATE | |||
IT34308 | 2 | REPLICATED MQT MATCH MAY FAIL IN SOME SPECIFIC SITUATIONS | |||
IT33171 | 2 | WRONG RESULT WHEN QUERY HAS SCALAR SUBQUERY AND FETCH FIRST 1 ROW | |||
IT34382 | 2 | POOR PERFORMANCE WHEN IN-LIST TO JOIN CAUSING EARLY COMPENSATION | |||
IT33459 | 2 | FIX ISSUES WITH OPTIMIZER VERSION CONTROL (DB2_OPTIMIZER_VERSION REGISTRY VARIABLE) | |||
IT33527 | 2 | POOR PERFORMANCE OF DB2 QUERY HAVING IN SUBQUERY PREDICATE | |||
IT34115 | 2 | INCORRECT QUERY OPTIMIZATIONS RESULTING IN POOR PERFORMANCE OCCUR WHEN STATEMENT CONCENTRATION IS ENABLED | |||
IT32923 | 2 | DB2 MAY ABEND WHEN COLUMN ALIAS USED IN PREDICATE. | |||
IT33870 | 2 | SQL901 WHEN SUBQUERY PREDICATE USED WITH OUTER JOIN | |||
IT32640 | 2 | QUERY FAILS WITH SQL0901 "NO CAST FUNCTION" WHEN DB2_ENABLE_MULTIPLE_CCSIDS=TRUE, DATABASE IS UNICODE | |||
IT33577 | 2 | PERFORMANCE: NEQN (I.E. NULL EQ NULL) PREDICATES NOT DETECTED BY MAGIC DECORRELATION | |||
IT34078 | 2 | DB2 MAY NOT GENERATE TRAILING SPACE AFTER GROUP BY | |||
IT33822 | 2 | HANG IN WHERE ALIAS DUE TO CYCLIC REFERENCE. | |||
IT34222 | 3 | 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE | |||
IT33557 | 3 | USING "ISNOTTRUE" OR "ISNOTFALSE" ROUTINES WITH DECFLOAT DATA TYPE RETURNS SQL0440N | |||
IT33871 | 3 | DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE | |||
Fix Pack m5fp0 - Relational Data Services | |||||
IT33691 | 1 | ON DPF INSTANCE APPLICATIONS MAY HANG WHILE DOING A COMMIT | |||
IT34110 | 2 | -901 SQLCODE (CANNOT FIND CURSOR INFO IN ERT) FOLLOWED BY TRAP | |||
Fix Pack m5fp0 - Routine Infrastructure | |||||
IT34156 | 2 | ALLOW FMP POOLING FOR SPECIFIC USER IDS | |||
Fix Pack m5fp0 - Sailfish Operational Compatibility | |||||
IT34151 | 2 | USING PIPE INTERFACE DURING UNLOAD OPERATION IF PIPE IS USED | |||
IT33740 | 2 | CREATE EXTERNAL TABLE USING SAMEAS/LIKE WITH BASE TABLE HAVING HIDDEN COLUMN IS GETTING CREATED WITH HIDDEN COLUMN | |||
IT33615 | 2 | SQL20570N WHILE LOADING EMPTY FILE USING OPTION REMOTESOURCE GZIP SAME WORKS FINE WITH LZ4 | |||
IT34356 | 2 | FMP TRAP WHILE USING -FORMAT INTERNAL DUE TO SCHEMA MISMATCH | |||
Fix Pack m5fp0 - Security | |||||
IT34107 | 2 | HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLE AND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES | |||
Fix Pack m5fp0 - pureScale Services | |||||
IT33790 | 3 | DB2AUTOSTART DOES NOT WORK ON REBOOT WHEN OS REBOOT IS VERY FAST. | |||
IT33851 | 3 | TSA INITIATED TAKEOVER IN AN AUTOMATED HADR ENVIRONMENT MAY FAIL DUE TO PEER WINDOW HAVING EXPIRED. |
DB2 Version 11.5 Fix Pack m4fp0 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract | |||
Fix Pack m4fp0 - Buffer Pool Services | |||||
IT32436 | 2 | HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR | |||
Fix Pack m4fp0 - CDE Data | |||||
IT30387 | 1 | DB2 MIGHT HANG WITH AN EDU WAITING ON SQLO_LT_SQLD_CHAIN__FULLCH AINLATCHNS WHILST HOLDING SQLO_LT_SQELOCALDATABASE__DBLATCH | |||
IT33198 | 2 | IN DB2 V11.5 GA, SQL0901N ERROR MAY OCCUR WITH DB2DIAG.LOG SQLER RMC "UNEXPECTED ERROR AT SYNOPSISTABLETUPLEACCUMULATOR.HPP:130" | |||
Fix Pack m4fp0 - CDE Query | |||||
IT32589 | 1 | CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON | |||
IT31975 | 2 | SELECT WITH SUBSTRING() RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN | |||
IJ24133 | 2 | WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N. | |||
Fix Pack m4fp0 - CLI | |||||
IV98044 | 2 | NEW MONGODB CLIENTS ARE UNABLE TO CONNECT TO IBM JSON WIRE LISTENER | |||
IT31045 | 3 | BULKCOPY ERROR WHILE CHAIN INITIALIZATION WITH NULL VALUE FOR DECIMAL COLUMNS | |||
IT33421 | 2 | SQLGETCONNECTATTR() FUNCTION CALL WITH SQL_ATTR_GET_LATEST_MEMBER_NAME TAKING TIME DUE TO GETADDRINFO TAKING MORE TIME | |||
IT30451 | 2 | NOT ABLE TO LOAD AND USE THE DB2CLIO.DLL | |||
IT33461 | 3 | ERROR ENCOUNTERED WHILE FETCHING SMALLINT DATA USING IBM DATASERVER PROVIDER FOR ENTITY FRAMEWORK CORE | |||
Fix Pack m4fp0 - Codegen and Runtime | |||||
IT32599 | 2 | QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW | |||
IT32367 | 2 | SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB | |||
Fix Pack m4fp0 - Communication | |||||
IT32766 | 1 | SECURITY - DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK | |||
IT32357 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
Fix Pack m4fp0 - DRDA Services | |||||
IT32363 | 2 | SECURITY: IBM® DB2® LUW IS VULNERABLE TO A DENIAL OF SERVICE ATTACK | |||
Fix Pack m4fp0 - Data Management Services | |||||
IT33146 | 1 | DB2 SERVER TERMINATES ABNORMALLY DURING ROLLFORWARD RECOVERY IN THE SQLPLRQ FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET. | |||
IT33218 | 1 | DB2 SERVER TERMINATES ABNORMALLY IN THE SQLDFETCHLARGEROW FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET. | |||
IT30494 | 2 | CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY | |||
Fix Pack m4fp0 - Data Recovery Services | |||||
IT33172 | 3 | SLOW DATABASE RECOVERY LOG REPLAY ON A WORKLOAD WITH MANY DDLS SPECIFICALLY CREATE / ALTER / TRUNCATE / DROP TABLE | |||
Fix Pack m4fp0 - Federation | |||||
IT31455 | 3 | CREATE SERVER COMMAND IS FAILED IN SQL1816N WHEN DB2/LUW IS SPECIFIED IN V11.5 | |||
Fix Pack m4fp0 - Install and Catalog Services | |||||
IT31637 | 1 | SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204) | |||
IT29745 | 1 | IN A PURESCALE ENVIRONMENT, DB2IUPDT COMMAND FAILS ON RHEL 7.6 AS IT CHECKS FOR AN OBSOLETE PACKAGE (LIBIBCM) | |||
IT32256 | 2 | DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY | |||
IT31741 | 2 | DB2PREREQCHECK FILLS UP / AND /TMP DUE TO SCP TSAMP WITH UNNECES SARY FILES DURING PURESCALE INSTALLATION OR DB2IUPDT COMMAND | |||
IT31588 | 3 | WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID | |||
IT32751 | 2 | HADR STANDBY FAILS WITH "BAD ENTRY STATE" REPORTED FROM SQLRLC_AUTH_GR_PROCESS_ENTRY_STATE | |||
Fix Pack m4fp0 - JDBC Driver | |||||
IT30972 | 2 | JDBC DRIVER NOT TERMINATING TIMER THREADS WITH VERSION 4.26.14 | |||
IT29195 | 2 | CLPPLUS DOES NOT RUN THE LOGIN.SQL SCRIPT DURING STARTUP. | |||
IT32580 | 2 | INTRODUCED A NEW PROPERTY USEJDBC4DATATYPE IN JCC DRIVER AS IT IS NOT BACKWARD COMPATIBLE FOR CLOB/CHAR/VARCHAR DATA TYPE. | |||
IT31612 | 3 | PIGGYBACK COMMANDS ARE NOT REPLAYED IF FAILURE HAPPENS DURING FIRST SQL EXECUTION IN CASE OF NON-SEAMLESS FAILOVER | |||
IT33042 | 2 | DB2STOP MEMBER CAUSED JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION | |||
Fix Pack m4fp0 - Monitoring | |||||
IT31573 | 2 | DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH. | |||
Fix Pack m4fp0 - Platform Specific | |||||
IT31007 | 2 | DT159865: MULTIPLE CLP FRONTENDS ISSUED FROM DIFFERENT SHELL SCRIPTS USES THE SAME BACKEND AGENT, CAUSING UNEXPECTED RESULTS OR ERRORS. | |||
IT31704 | 2 | MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES | |||
IT32507 | 3 | ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID() | |||
Fix Pack m4fp0 - Problem Determination | |||||
IT32716 | 1 | SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE AND DENIAL OF SERVICE | |||
IT32689 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE | |||
IT32714 | 1 | SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE | |||
Fix Pack m4fp0 - Process Model | |||||
IT32439 | 1 | INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES | |||
IT31679 | 3 | DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH | |||
IT31378 | 2 | DB2STOP FAILS WITH SQL6037N, LEAVING [DB2SYSC]<DEFUNCT> | |||
Fix Pack m4fp0 - Query Compiler Optimizer | |||||
IT32195 | 2 | IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS | |||
Fix Pack m4fp0 - Query Compiler QGM | |||||
IT31167 | 2 | SQLGETTYPEINFO WITH SQL_BOOLEAN IS NOT RETURNING ANY RESULT | |||
IT31557 | 2 | SQL1224N AFTER CERTAIN OUTER JOIN QUERIES | |||
IT32731 | 2 | DB2 SERVER TERMINATES ABNORMALLY DURING QUERY COMPILATION | |||
IT28109 | 2 | INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION? | |||
IT32612 | 2 | -901 ERROR IS HAPPENED(BAD PLAN; UNRESOLVED QNC FOUND) WHEN EXECUTING PACKAGE REBIND IN V11.5. | |||
IT31862 | 2 | TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE | |||
IT31634 | 2 | WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION. | |||
Fix Pack m4fp0 - Relational Data Services | |||||
IT31701 | 1 | APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS | |||
Fix Pack m4fp0 - Routine Infrastructure | |||||
IT32126 | 2 | MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO | |||
Fix Pack m4fp0 - Sailfish Operational Compatibility | |||||
IT32568 | 2 | FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH | |||
Fix Pack m4fp0 - Text Search | |||||
IT31755 | 2 | THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000 | |||
Fix Pack m4fp0 - pureScale Services | |||||
IT31054 | 3 | EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" | |||
IT31454 | 3 | EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" | |||
IT40847 | 2 | DT147376: ENDLESS ITERATION OF DB2 CLEANUP AND KILL PROCESSES MAKE DB2 PURESCALE CLUSTER HANG |
DB2 Version 11.5 Fix Pack m3fp0 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract | |||
Fix Pack m3fp0 - Buffer Pool Services | |||||
IT31892 | 1 | CRASH RECOVERY CAN FAIL AFTER INCORRECTLY REPLAYING EXTENT MOVEMENT LOG RECORDS WITH LARGE RECOVERY WINDOW | |||
IT32436 | 2 | HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR | |||
Fix Pack m3fp0 - CDE Data | |||||
IT31385 | 3 | INCORRECT CALCULATION OF COLUMNAR-ORGANIZED TABLE SPACE CONSUMPTION IN TBPSIZE_ENTITLEMENT_REQ.SQL | |||
Fix Pack m3fp0 - CDE Query | |||||
IT32589 | 1 | CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON | |||
IT31975 | 2 | SELECT WITH SUBSTRING() RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN | |||
IT31628 | 2 | SQL STATEMENT WITH ORDER BY ACCESSING COLUMNAR TABLES MAY BE HUNG IN DPF | |||
IJ24133 | 2 | WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N. | |||
IT31619 | 2 | IN DPF AGAINST COLUMNAR TABLES WRONG RESULT IS POSSIBLE FOR SQL WITH LIMIT WHEN OVER(PARTITION BY) AND ORDER BY IS USED | |||
IT30770 | 2 | SORTHEAP IS TOO SMALL | |||
Fix Pack m3fp0 - Client Interfaces | |||||
IT31515 | 1 | SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK. (CVE-2020-4200) | |||
Fix Pack m3fp0 - Codegen and Runtime | |||||
IT31163 | 1 | WRONG RESULTS ARE POSSIBLE WITH COMPLEX SQL WHICH USES UDFS AND CONSTANTS AND ENCOUNTER A COMPLEX PLAN. | |||
IT31783 | 2 | POSSIBLE TRAP (SEGV) WHEN RUNNING A QUERY ON A NICKNAME POINTING TO A FEDERATED SOURCE AND FEDERATED GOES DOWN. | |||
IT32599 | 2 | QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW | |||
IT32367 | 2 | SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB | |||
Fix Pack m3fp0 - Data Management Services | |||||
IT30494 | 2 | CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY | |||
Fix Pack m3fp0 - Data Recovery Services | |||||
IT30259 | 2 | ROLLFORWARD FAILS DURING LOG CHAIN SWITCH WHEN RUN WITH NORETRIEVE AND OVERFLOW PATH | |||
IT30816 | 3 | MESSAGE PDRECOVERY, PROBE:10 AND PROBE:20 IS LOGGED WITH EACH DIAGEVEL | |||
Fix Pack m3fp0 - Federation | |||||
IT32121 | 1 | SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 LEADING TO DENIAL OF SERVICE OR PRIVILEGE ESCALATION | |||
IT32598 | 2 | [FEDERATION]CREATE NICKNAME FAILS WITH -901 WHEN COLUMN IS DECIMAL(P,S) P>31 | |||
Fix Pack m3fp0 - Install and Catalog Services | |||||
IT31637 | 1 | SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204) | |||
IT32256 | 2 | DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY | |||
IT31588 | 2 | WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID | |||
IT31924 | 2 | INVOKE SCP WITH THE -T OPTION DUE TO CVE-2019-6111 | |||
Fix Pack m3fp0 - Monitoring | |||||
IT31573 | 2 | DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH. | |||
IT20712 | 3 | SYSIBMADM.LOG_UTILIZATION IS RETURNING SQL0801N ON STANDBY | |||
Fix Pack m3fp0 - Platform Specific | |||||
IT31704 | 2 | MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES | |||
IT31615 | 2 | UNNECESSARY SQLO_BAD_USER LOGGING INTO DB2DIAG.LOG | |||
IT22910 | 3 | PDHADDCOUNTER FAILED WITH OSERR -1073738824IN FUNCTION OSSGETPROCESSRAWCPUUSAGE() | |||
IT32507 | 3 | ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID() | |||
Fix Pack m3fp0 - Process Model | |||||
IT31520 | 1 | SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK (CVE-2020-4135) | |||
IT32439 | 1 | INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES | |||
IT31679 | 3 | DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH | |||
Fix Pack m3fp0 - Query Compiler Optimizer | |||||
IT31132 | 2 | DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN | |||
IT32195 | 2 | IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS | |||
IT30946 | 2 | DB2 MAY ABEND WHILE USING PARTICULAR EXPLAIN MODES | |||
Fix Pack m3fp0 - Query Compiler QGM | |||||
IT29945 | 1 | 10 CHAR VALUE CAN BE INSERTED INTO VARGRAPHIC(5 CODEUNITS32). THIS SHOULD FAIL WITH SQL0433N ERROR. | |||
IT31557 | 2 | SQL1224N AFTER CERTAIN OUTER JOIN QUERIES | |||
IT30866 | 2 | DB2 SERVER TERMINATES ABNORMALLY IN SQLNQ_UDF_SPECIFIC WITH STMT_CONC=LITERALS | |||
IT28109 | 2 | INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION? | |||
IT30926 | 2 | TRANSFER OWNERSHIP MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY | |||
IT31862 | 2 | TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE | |||
IT31634 | 2 | WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION. | |||
Fix Pack m3fp0 - Relational Data Services | |||||
IT31701 | 1 | APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS | |||
Fix Pack m3fp0 - Routine Infrastructure | |||||
IT32126 | 2 | MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO | |||
Fix Pack m3fp0 - Sailfish Operational Compatibility | |||||
IT32568 | 2 | FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH | |||
IT31437 | 2 | EMPTY STRING IS NOT INSERTED AS NULL VALUE WHEN NULLVALUE IS EMPTY STRING | |||
Fix Pack m3fp0 - Security | |||||
IT31969 | 3 | EXTRA PRIVILEGES ON NULLID.ATSO05 PACKAGE ARE ADDED TO PUBLIC AFTER RESTORING OLDER RESTRICTIVE DATABASE IMAGE | |||
Fix Pack m3fp0 - Text Search | |||||
IT31755 | 2 | THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000 | |||
IT31449 | 2 | INTERMITTENT HANG IN SOCKET SELECT | |||
Fix Pack m3fp0 - pureScale Services | |||||
IT31054 | 3 | EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" | |||
IT29256 | 3 | DB2INSTANCE -LIST MAY SHOW THE SECONDARY CF IN TRANSIENT ERROR STATE DURING CATCH UP ON BUSY SYSTEMS. | |||
IT31454 | 3 | EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" |
DB2 Version 11.5 Fix Pack m2fp0 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract | |||
Fix Pack m2fp0 - Buffer Pool Services | |||||
IT31716 | 1 | ON RARE OCCASION, DATA CORRUPTION MIGHT BE INDUCED BY FAILURE TO PANIC THE DATABASE ON ENCRYPTION ERROR. | |||
IT30898 | 2 | TABLESPACE CONTAINERS COULD BE DELETED WHEN A STORAGE GROUP EXIST ON DBPATH | |||
IT30326 | 2 | INSTANCE MAY TRAP IN FUNCTION SQLBGETVICTIMFROMBLOCKHATELIST | |||
Fix Pack m2fp0 - CDE Data | |||||
IT31719 | 2 | ADDING A NEW TABLE USE FOR DISABLING VECTORIZED ADC | |||
Fix Pack m2fp0 - CDE Query | |||||
IT31181 | 2 | INSTANCE CAN GO DOWN WHEN COLUMN ORGANIZED TABLES ARE USED | |||
Fix Pack m2fp0 - Codegen and Runtime | |||||
IT29583 | 2 | MEMORY LEAK RELATED TO JSON QUERIES. | |||
IT30005 | 2 | DB2 MAY PRODUCE INCORRECT RESULTS FOR HSJN WITH PREDICATE THAT HAS CASE(COALESCE) AND NLJN OR ZZJOIN ON THE OUTER | |||
IT30456 | 2 | INSERT INTO ... WITH IGNORE DUPLICATES MIGHT FAIL WITH -901 REASON "SQLRIOPN: TABLE IS NOT CREATED" | |||
Fix Pack m2fp0 - Data Management Services | |||||
IT30965 | 1 | AN ISCAN FETCH USING CURRENTLY COMMITTED IN PURESCALE MAY RETURN UNCOMMITTED RESULTS. | |||
IT29634 | 2 | INTERRUPTING ROLLFORWARD OPERATIONS DURING REPLAY CAN CAUSE SUBSEQUENT ROLLFORWARD TO FAIL | |||
IT30061 | 2 | DB2 TAKES Z LOCK WHEN ATTACHING PARTITION TO TABLE | |||
Fix Pack m2fp0 - Federation | |||||
IT30251 | 1 | WRONG RESULTS ARE POSSIBLE FOR FEDERATED OR COLUMNAR QUERY WITH AGGREGATION OVER DISTINCT OUTER JOIN | |||
Fix Pack m2fp0 - Install and Catalog Services | |||||
IT31481 | 1 | SECURITY: DB2 IS VULNERABLE TO A PRIVILEGE ESCALATION ATTACK (CVE-2020-4230) | |||
IT29832 | 3 | TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT. | |||
Fix Pack m2fp0 - Parsing and SQL PL | |||||
IT30157 | 1 | SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR UPD | |||
Fix Pack m2fp0 - Platform Specific | |||||
IT30432 | 1 | SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION (CVE-2019-4587) | |||
Fix Pack m2fp0 - Query Compiler QGM | |||||
IT31140 | 1 | CDE HSJN NOT PICKED UP FOR NON EQUAL PREDICATES(RANGE AND OR PREDICATES) | |||
IT30742 | 2 | QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP" | |||
IT31207 | 2 | INCORRECT RESULT WHEN USING TWICE JOIN WITH THE SAME TABLE WITH GROUP BY | |||
IT31462 | 2 | SECURITY: DB2 IS VULNERABLE TO DENIAL OF SERVICE ATTACK (CVE-2020-4161) | |||
IT30467 | 2 | DB2 MAY PRODUCE INCORRECT RESULTS WHEN EXECUTING QUERIES CONTAINING JOINS WITH DIFFERING FLOATING-POINT PRECISIONS | |||
IT29982 | 2 | DB2 MAY RETURN INCORRECT RESULTS WHEN EXECUTING IUD STATEMENTS CONTAINING A SUBQUERY WITH CORRELATION AND AGGREGATION | |||
IT30740 | 2 | COMMENT ON UNICODE TABLE IN A NON-UNICODE DATABASE RESULTS IN UNREADABLE COMMENT | |||
Fix Pack m2fp0 - pureScale Services | |||||
IT30143 | 1 | SECURITY: DB2 AFFECTED BY BUFFER OVERFLOW VULNERABILITIES (CVE-2019-4584) |
DB2 Version 11.5 Fix Pack m3fp0 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract | |||
Fix Pack m3fp0 - Buffer Pool Services | |||||
IT30789 | 2 | ROLLFORWARD MAY FAIL WITH SQL1271W AND SQLB_TBSPACE_TOO_SMALL WHEN REPLAYING AN ALTER TABLESPACE OPERATION | |||
IT30784 | 2 | DEADLATCH BETWEEN AN ONLINE BACKUP, PREFETCHERS AND AN AGENT DOING A WRITE TO THE SAME TABLE SPACE | |||
IT30781 | 2 | FALSE POSITIVE AGAINST BACKUP WITH REGISTRY DB2_BCKP_PAGE_VERIFICATION | |||
IT30798 | 2 | TABLE SPACE RESTORE UNABLE TO USE ALL CONTAINER PATHS AND FAILS WITH DISK FULL | |||
IT30811 | 3 | DB2PD -TABLESPACE DOES NOT INDICATE LOCAL OFFLINE STATE | |||
IT30797 | 3 | EXTENT MOVEMENT RETURNS SQL1523N REASON CODE "15" WHEN EXTENT MOVEMENT NOT RUNNING | |||
IT30796 | 3 | RESTORE OF SMS AUTOMATIC STORAGE TABLE SPACE IN DB2 DEVELOPER-C EDITION FAILS WITH SQL1139N | |||
Fix Pack m3fp0 - CDE Query | |||||
IT30231 | 1 | ENGINE MIGHT TRAP IN IBM_CDE::TYPES::BITSTRING::ANDWITHEXPANDEDCPU | |||
Fix Pack m3fp0 - Client Interfaces | |||||
IT30803 | 3 | INCORRECT LENGTH FOR SQL_LOCAL_LEN AND SQL_CODESET_LEN ON AIX | |||
Fix Pack m3fp0 - Data Management Services | |||||
IT29231 | 2 | UNSUSTAINABLE TRAP CAN OCCUR AFTER A SUSTAINED TRAP IF THERETEMP TABLES ARE USED BY TRANSACTIONS | |||
Fix Pack m3fp0 - Data Management Utilities | |||||
IT30793 | 1 | RESTORING A LOADCOPY WHEN THERE IS A MODIFICATION STATE INDEX ON A COLUMN ORGANIZED TABLE MAY CORRUPT THE INDEX. | |||
IT30807 | 2 | ROLL FORWARD OR CRASH RECOVERY MAY CRASH WHEN WORKING ON INDEX PAGE. | |||
Fix Pack m3fp0 - Data Recovery Services | |||||
IT30786 | 2 | ABNORMAL SHUTDOWN OF DATABASE WHEN LOAD ENCOUNTERS SQLO_NOTAVAIL ERROR IN SQLPUPDATEGLOBALTIMEINGLFH | |||
Fix Pack m3fp0 - Federation | |||||
IT25058 | 2 | FEDERATION QUERY MAY GET SQL0302N DUE TO STRING TRUNCATION WHEN A HOST VARIABLE IS USED FOR A REMOTE COLUMN IN DIFFERENT CODEPAG | |||
IT30799 | 3 | RELAX DB2DIAG.LOG MESSAGE IN SQLSFETCHNEXTTEMPRECORD PROBE 504 | |||
Fix Pack m3fp0 - Install and Catalog Services | |||||
IT30778 | 2 | DB2 CRASH ON FUNCTION SQLRL_GET_FULL_NAME() | |||
Fix Pack m3fp0 - Monitoring | |||||
IT29595 | 2 | ADMIN_MOVE_TABLE CONVERTS AUTO CGS STATISTICS PROFILE INTO USER STATISTICS PROFILE | |||
IT30805 | 2 | EM_LIST_LATCH IS GRABBED AND RELEASED FREQUENTLY EVEN THERE IS NO TRANSACTION EVENT MONITOR CREATED/ACTIVE | |||
IT30808 | 3 | DB2 LOCK EVENT MONITOR REPORT: LOCK MODE HELD IS NONE IN PURESCALE | |||
Fix Pack m3fp0 - Platform Specific | |||||
IT30792 | 1 | DB2 MIGHT CRASH IN SQLOFMBLKEX->SQLO_MEM_POOL::MEMTREEPUT WITH "CORRUPT POOL FREE TREE NODE" ERROR MESSAGE IN DB2DIAG.LOG | |||
IT30794 | 2 | CLEANING UP OF EDU CAUSES PRIVATE MEMORY TO LEAK (WINDOWS PLATFORM ONLY) | |||
IT30801 | 3 | STMM REPORTS SEVERE ERRORS ABOUT STMMSIMULATESORTMERGE IN DB2DIAG.LOG | |||
Fix Pack m3fp0 - Problem Determination | |||||
IT30810 | 2 | DB2DART DETECTS ERRORS AFTER UPGRADING | |||
Fix Pack m3fp0 - Process Model | |||||
IT30790 | 2 | DB2LOGGP CAN TRAP WITH SIGNAL #11 IN A FEDERATED ENVIRONMENT | |||
IT21822 | 4 | THE DESCRIPTION OF MAXFILOP IN GET DATABASE CONFIGURATION OUTPUT IS WRONG | |||
Fix Pack m3fp0 - Query Compiler Optimizer | |||||
IT29048 | 2 | HSJN RESID PREDICATE ISSUE, LEADING TO -901 FOR THE CDE QUERY AT PARSERWRAPPER/JOINREWRITER | |||
Fix Pack m3fp0 - Query Compiler QGM | |||||
IT30000 | 2 | DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING EXTERNAL ACTIONS AND CORRELATION | |||
IT28424 | 3 | UNABLE TO CREATE STORED PROCEDURES WITH SAME NAME BUT DIFFERENT PARAMETERS WHEN SQL_COMPAT ='NPS' | |||
Fix Pack m3fp0 - Relational Data Services | |||||
IT30800 | 2 | SECOND EXECUTION OF A CACHED CDE QUERY IN DPF ENVIRONMENT MIGHT LEAD TO SEGV (FODC TRAP) OR FODC MEMORY FOR ILLEGAL REQUEST SIZE | |||
Fix Pack m3fp0 - pureScale Services | |||||
IT30787 | 2 | DB2CLUSTER SEGFAULT CAUSED BY WRONG ARGUMENTS TO PD_HEXDUMP WHEN RUNNING INSTALLFIXPACK ON PURESCALE | |||
IT30788 | 2 | HADR CANNOT BE STARTED DUE TO INSUFFICIENT HADR DATABASE RESOURCE VALIDATION | |||
IT30783 | 3 | A SEGMENTATION FAULT (CORE DUMPED) CAN OCCUR WHEN RUNNING DB2HAICU WITH AN XML INPUT FILE. | |||
IT30809 | 3 | EXTRANEOUS CODE IN THE MOUNTV111_STOP.KSH SCRIPT | |||
IT30806 | 4 | DB2CLUSTER -CM -LIST -TIEBREAKER RETURNS INCORRECT OUTPUT WHEN THE DOMAIN IS STOPPED OR IN MAINTENANCE |
Document Location
Worldwide
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PknAAE","label":"Install\/Migrate\/Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF055","label":"zLinux"}],"Version":"11.5.0"}]
Was this topic helpful?
Document Information
Modified date:
25 January 2024
UID
ibm11102545