Troubleshooting
Problem
Db2 11.5 APAR Fix list contains list of APARs shipped for each Mod Pack, Fix Pack in Db2 Version 11.5 for Linux, UNIX and Windows products. The Severity column value of 1 is high and 4 is low. Severity column represents the severity of the Case at the time the APAR was opened.
Resolving The Problem
Tab navigation
************************************************************
Product Name : DB2 UDB Version 11.5
Updated : Oct 18, 2022
************************************************************
Select a Fix Pack: m8fp0 | m7fp0 | m6fp0 | m5fp1 | m5fp0 | m4fp0 | m3fp0 | m2fp0 | m3fp0
DB2 Version 11.5 Fix Pack m8fp0 | |||||
---|---|---|---|---|---|
Known Issue | Sev. | Abstract |
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 | |||
DT148494 | 2 | IT41361: GBP DETACH MISSING IN CF PREVENT MEMBER FROM ACTIVATING A DATABASE LEADING TO FODC | |||
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 APAR 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
DT147942 | 2 | IT40899: SQL0802 ARITHMETIC OVERFLOW ERROR OCCURS DURING TEXT SEARCH INDEX CREATION | |||
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. | |||
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 | |||
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 | |||
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 | |||
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 | |||
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' | |||
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 | |||
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 | |||
DT147742 | 2 | IT40681: 901 ERROR MIGHT OCCUR WITH THE MESSAGE "PLAN NOT FOUND FOR UNIONLEG" | |||
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 | |||
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 | |||
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 | |||
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 | |||
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= | |||
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 | |||
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) | |||
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 | |||||
---|---|---|---|---|---|
APAR | 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() | |||
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 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
IT35576 | 3 | HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN A DISTRIBUTED TRANSACTION | |||
IT37301 | 3 | DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY WILL FAIL WITH AN SQL2079N ERROR, 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 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
IT35883 | 3 | INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE | |||
IT34960 | 3 | DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS. | |||
IT32664 | 3 | XML INDEXES NOT USED IN DB2 11.5 EXPLAIN PLAN | |||
IT35798 | 3 | SLOW PERFORMANCE IN DPF OR CDE WHEN RUNNING A QUERY WITH SCALAR SUBQUERIES AND AN OUTER JOIN | |||
IT34748 | 3 | UPDATE STATEMENT SLOW PERFORMANCE CAUSED BY LATCH CONTENTION DURING THE MEMORY ALLOCATIONS. | |||
IT35017 | 3 | CDE JOIN MINMAXINFO DUMP: TRAP DUE TO DEREFERRENCING NULL POINTER | |||
IT35185 | 3 | DB2 MIGHT TRAP IN SQLRWTABLEMETRICSBUILDER::EXECUTE DURINGEXECUTION OF THE MON_GET TABLE FUNCTION | |||
IT35705 | 3 | DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE | |||
IT35439 | 3 | DB2ADV_VPC.LIC CAN MAKE Q REP FUNCTIONS AVAILABLE, IT IS NOT THE EXPECTED RESULT | |||
IT36027 | 3 | IMPROVEMENTS TO CDE JOIN MEMORY USEAGE. REDUCTION OF MEMORY NEEDED AND REDUCTION OF -955 ERRORS. | |||
IT33529 | 3 | PRESENCE OF CANDIDATE ACCESS PLAN WITH SINGLE-NODE HASH-DIRECTED PARTITIONING PREVENTS OPTIMAL PLAN WITH REPARTITIONED JOIN | |||
IT35680 | 3 | HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR | |||
IT34693 | 3 | DB2UNINS OF DATA SERVER CLIENT REMOVES SHARED C++ REG KEYS | |||
IT34396 | 3 | PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING | |||
IT34242 | 3 | BAD PERFORMANCE DUE TO DELAYED JOIN PREDICATE PUSHDOWN THROUGH UNION ALL PREVENTS JOIN ELIMINATION | |||
IT35833 | 3 | SQL1585N IS INCORRECTLY RETURNED FOR CERTAIN TYPES OF QUERIES | |||
IT34658 | 3 | DB2 QUERY MAY GENERATE FODC AND APP_ERR OR WRONG RESULT IN CERTAIN CONDITIONS | |||
IT35047 | 3 | MGB:STORED PROCEDURE CALLS PERFORMANCE ARE SIGNIFICANTLY WORSE AFTER MIGRATION | |||
IT34559 | 3 | ELEMENT ALLOCATION ISSUE, AND ONE OF THE VECTORS WAS MESSED UP AND CAUSE TRAP/SEGFAULT. | |||
IT31536 | 3 | MON_GET_LOCKS FAILS IN DPF WITH SQL1607N BECAUSE OF UNDERLYING RPC MECHANISM BEING LIMITED TO 2 GIGABYTES | |||
IT34108 | 3 | NLJN NOT PUSHING DOWN | |||
IT35033 | 3 | CUSTOMERS ENCOUNTERING ASN0569E DUE TO OUT-OF-ORDER REPLICATION LOG RECORDS DURING SAVEPOINT ROLLBACK | |||
IT35728 | 3 | SQL0407N WHEN COMMON SUBQUERY HAS VALUES | |||
IT35548 | 3 | HADR STANDBY FORCE DB SHUTDOWN, DB2DIAG.LOG SHOWS OBJECT IS NOT MARKED PENDDEL | |||
IT35739 | 3 | DB2 QUERY MAY NOT GENERATE TRAILING SPACE WHEN MINUS/EXCEPT IS USED IN THE QUERY. | |||
JR62967 | 3 | DB2 V11.5 QUERY PLAN WITH "UNION ALL" IS DIFFERENT FROM QUERY PLANS IN V11.1 | |||
IT35880 | 3 | DB2 11.5 PERF DEGRADATION ON LINUX: O_SYNC AND NOT O_DSYNC USED | |||
IT35992 | 3 | SQL0811N WHEN THERE IS SCALAR SUBQUERY WITH FETCH FIRST 1 ROWS | |||
IT36210 | 3 | IN VERY RARE CASE OF CDE RIGHT OUTER JOIN PROCESSING TRAP IS POSSIBLE. | |||
IT35399 | 3 | FEDERATED SERVER OPTION CONCURRENT_ACCESS_RESOLUTION='W' CAUSES CLI019E INVALID ATTRIBUTE ERRORS | |||
Fix Pack m5fp1 - Abstract Data Types and Spatial Extender | |||||
IT35444 | 2 | MULTIPLE MEMORY LEAKS IN GEO-SPATIAL CALLS WHEN EXECUTING CERTAIN GEO-SPATIAL FUNCTIONS | |||
Fix Pack m5fp1 - Buffer Pool Services | |||||
IT33994 | 2 | DB2 MAY HANG SHORTLY AFTER COMMITTING A CREATE TABLE WITH AN AGE NT WAITING FOR SQLO_LT_SQLD_TCB__LOADINPROGRESS LATCH IN SQLBFIX | |||
IT36108 | 2 | INTERRUPTING ALTER TABLESPACE REDUCE MAY CAUSE A MEMBER SHUTDOWN | |||
Fix Pack m5fp1 - CDE Data | |||||
IT35182 | 2 | CLEANUP OF IN-MEMORY STRUCTURE WHEN LOADING OF THE DICTIONARY FAILS (ADD CODE TO HANDLE EXCEPTIONS GRACEFULLY). | |||
IT34037 | 2 | DEADLATCH BETWEEN ONE THREAD WRITING A DICTIONARY TO DISK USING VECTORIZEDADC AND ANOTHER THREAD DOING A NEW EXTENT ALLOCATION | |||
Fix Pack m5fp1 - CDE Query | |||||
IT35163 | 1 | DB_MIGRATE HANGS WHEN USING ORDER BY CLAUSE | |||
IT36230 | 2 | DB2 TRAP IN FUNCTION EXTRAPAYLOADITERATOR::COPYPAYLOADSTO | |||
IT35211 | 2 | POSSIBLE SIGSEGV IN Q REPLICATION DUE TO INCORRECT LOG RECORDS FOR COLUMN-ORGANIZED DGTT IN DPF ENVIRONMENT | |||
IT35158 | 2 | REDUCE LIKELYHOOD OF SQL0954C FOR COLUMNAR ORGANIZED HSJN PLANS | |||
Fix Pack m5fp1 - Client Interfaces | |||||
IT35521 | 1 | CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS | |||
IT34606 | 2 | USING CFGREFRESHINTERVAL IN A MULTI-THREADED CLI APPLICATION LEADS TO SEGMENTATION FAULT | |||
IT34589 | 2 | ON WINDOWS PLATFORM CLIDRIVER CAN LOG SQL1531N DURING CONNECT EVEN WHEN CONNECTION IS SUCCESSFUL WITH SQL_SUCCESS_WITH_INFO | |||
IT35405 | 3 | CAN'T CONNECT TO DB2 VIA EXCEL 2016 USING DATA --> ?GET EXTERNAL DATA? WHEN UPGRADING RUNTIME CLIENT TO 11.5 | |||
Fix Pack m5fp1 - Codegen and Runtime | |||||
IT35377 | 2 | WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATAPART TABLE ON THE INNER AND NULL KEYS. | |||
IT35486 | 2 | DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG. JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT. | |||
IT34579 | 3 | DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY FAIL WITH SQL2079N ERROR | |||
Fix Pack m5fp1 - Communication | |||||
IT35289 | 1 | SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND (CVE-2020-5024) | |||
IT34882 | 2 | INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL | |||
IT34504 | 2 | GSKKM_STORECACERT: GSKIT ERROR = 100 ERRORS IN DB2DIAG.LOG | |||
Fix Pack m5fp1 - DRDA Services | |||||
IT35750 | 2 | THE FUNCTION WHICH TESTS THE 'FAILOVER' MEMBER DOES NOT TAKE SSL INTO ACCOUNT. | |||
IT34432 | 2 | FAILBACK PING INCORRECTLY USES TCPIP INSTEAD OF SSL | |||
Fix Pack m5fp1 - Data Management Services | |||||
IT34294 | 1 | SECURITY: IBM® DB2® IS VULNERABLE TO A DENIAL OF SERVICE ON WINDOWS (CVE-2020-4642) | |||
Fix Pack m5fp1 - Data Management Utilities | |||||
IT35936 | 2 | DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATAPART FUNCTION | |||
IT35965 | 3 | REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN | |||
Fix Pack m5fp1 - Engine Other | |||||
IT35987 | 2 | "114 ATTEMPT TO ACCESS ITEM BEYOND BOUNDS OF MEMORY" ERROR OCCURED IN 32 BIT MODE. | |||
Fix Pack m5fp1 - Federation | |||||
IT33598 | 2 | INSERT STATEMENT FAILS WITH -901 ERROR USING FEDERATION | |||
IT35968 | 2 | WHILE QUERYING THE WEB SERVICE NICKNAME, FEDERATION SERVER REPORTS ERROR SQL1822N | |||
IT34588 | 2 | SQL30090N WHEN WE USE UPDATE WITH PLACEHOLDER (VARIABLE) VIA JDBC | |||
IT35226 | 2 | CREATE OR REPLACE NICKNAME ON REMOTE DB2I SERIES (AS400) FAILS WITH SQL0901 AND DUMP FOLDER FODC_APPERR IS CREATED | |||
JR62802 | 2 | PROBLEM RUNNING UPDATE ON MARIADB (FEDERATION) | |||
IT34941 | 2 | QUERY ON NICKNAME RESULTS WITH VALUES TRUNCATED ON MARIADB | |||
IT34862 | 2 | DB2 CRASH DUE TO A -901 WAS RAISED BY MINMAXPARTIALEVALUATOR.CPP WHEN MAX(TO_CHAR()) OR MIN(TO_CHAR()) EXISTS IN THE SELECT LIST | |||
Fix Pack m5fp1 - Install and Catalog Services | |||||
IT35672 | 2 | UPDATING NETNAMES HIT ISSUE SAYING RSCT PEER IN REGISTRY DOES NOT MATCH ACTIVE DOMAIN NAME | |||
IT33810 | 2 | INVALID LICENSE ERROR USING DB2 CONNECT LICENSE WITH .NET CLI DRIVER ON OPENSHIFT CONTAINER | |||
Fix Pack m5fp1 - Platform Specific | |||||
IT34929 | 2 | ADD ENVVAR TO OVERRIDE WINDOWS COMMONAPPDATA PATH | |||
Fix Pack m5fp1 - Problem Determination | |||||
IT33783 | 2 | DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H (TIME PERIOD SPECIFIERS) | |||
Fix Pack m5fp1 - Process Model | |||||
IT34261 | 1 | IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND | |||
Fix Pack m5fp1 - Query Compiler Optimizer | |||||
IT35198 | 1 | A QUERY ON COLUMNAR TABLES MAY RETURN MORE ROWS THAN EXPECTED | |||
IT35183 | 2 | POOR QUERY PERFORMANCE WHEN IN SUBQUERY PREDICATE WITH NO DISTINCT. | |||
Fix Pack m5fp1 - Query Compiler QGM | |||||
IT34950 | 1 | DB2 SERVER TERMINATES ABNORMALLY WHEN SELECT FROM INVALID VIEWS | |||
IT34758 | 2 | SELECT DISTINCT QUERY FAILS WITH SQL0421 WHEN USED WITH SCROLLABLE CURSOR | |||
IT35670 | 2 | REGEXP_REPLACE AND REGEXP_SUBSTR WITH COLUMN-ORGANIZED TABLE MAY RESULT IN -901 | |||
IT34613 | 2 | INCORRECT RESULTS WITH DB2_EXTENDED_OPTIMIZATION='MQTENFORCE REPLICATED' | |||
IT35925 | 2 | DISTRIBUTION KEY ORDER IS NOT INHERITED FROM THE AS-RESULT-TABLE WHEN COISBAR IS ENABLED | |||
IT34311 | 2 | QUERY WITH ALIAS FOR COMPLEX COLUMN USED IN GROUP BY CLAUSE TRAPS AND GENERATES FODC | |||
IT34860 | 2 | DB2 QUERY MAY HANG WITH REGISRTY SETTING INJ_DUMMY_PRD4JOIN | |||
IT34304 | 2 | SQL0344N ERROR MAY OCCUR IN NON-UNICODE, VARCHAR2 ENABLED DATABASE WHEN QUERY REFERENCES SYSIBM.SYSDUMMY1 OR SYSIBM.DUAL | |||
IT34222 | 3 | 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE | |||
IT34940 | 3 | WRONG RESULT WHEN EQUALITY PREDICATE HAS IS NOT NULL WITH FALSE ON OTHER SIDE. | |||
Fix Pack m5fp1 - Relational Data Services | |||||
IT33355 | 2 | DEADLOCK BETWEEN INVALIDATION OF PACKAGE AND IMPLICIT REBIND OF THE SAME PACKAGE. | |||
IT35546 | 2 | -901 SQLCODE DURING REBIND FOR PACKAGES BOUND WITH CERTAIN BIND OPTIONS | |||
IT34671 | 2 | MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK | |||
IT33429 | 2 | SQL1598N MIGHT BE RAISED IF A LICENSE WAS NOT APPLIED BEFORE SIMULTANEOUS ATTEMPTS TO CONNECT THROUGH THE DATA SERVER DRIVER | |||
IT35221 | 2 | WLM ADMISSION CONTROL DOES NOT PROPERLY TRACK ACTUAL MEMORY HIST ORY FOR SHORT QUERIES. THIS CAN LEAD TO UNNECESSARY QUEUING OF V | |||
Fix Pack m5fp1 - Sailfish Operational Compatibility | |||||
IT35770 | 2 | OOM HIT WHILE RUNNING ET NZ INTERNAL FORMAT MIGRATION. | |||
IT35855 | 2 | MEMORY LEAK ENCOUNTERED WHEN YOU HAVE MORE THEN 1COLUMN OF SAME TYPE FROM TIMESTAMP/TIME/DATE WITH DB2 FORMAT SPECIFIED FOR IT | |||
IT35165 | 2 | DB_MIGRATE ISSUE WITH INTERNAL FORMAT WHEN INPUT STRING AFTER CODEPAGE CONVERSION EXCEED THE TARGET COLUMN SIZE. | |||
Fix Pack m5fp1 - Security | |||||
IT35445 | 1 | SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976) | |||
IT36060 | 2 | IN RARE INSTANCES, DB2 11.5.5 MAY CRASH DURING DB2START WHEN JWT AUTHENTICATION IS ENABLED | |||
IT36085 | 2 | DB2 11.5.5 MAY ENCOUNTER SQL30082N RC 15 WHEN USING GSS_SERVER_ENCRYPT OR KRB_SERVER_ENCRYPT AUTHENTICATION | |||
Fix Pack m5fp1 - pureScale Services | |||||
IT36088 | 1 | DB2CLUSTER -VERIFY MIGHT FAIL DURING RDMA PING DUE TO SEG FAULT | |||
IT36086 | 1 | DB2CLUSTER -VERIFY POTENTIAL HANG | |||
IT35303 | 1 | SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025) | |||
IT35552 | 2 | CF CHANGE TO ADD BREATHING POINT FOR DAT_EVD_DEQUEUE | |||
IT35558 | 2 | SIGNAL 11 TRAPS DURING CTSNAPS AFTER ROCE CABLE PULLS | |||
IT35662 | 2 | CREATE TABLE STATEMENTS ARE HANGING DUE TO RDMA COMMUNICATION TIMEOUTS BETWEEN MEMBER AND CF ON ZLINUX |
DB2 Version 11.5 Fix Pack m5fp0 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
Fix Pack m5fp0 - 1 | |||||
IT33863 | 3 | PURESCALE MEMBER MIGHT HANG WAITING FOR SQLO_LT_SQLB_BPD__BPDLAT CH_SX WHILE IN SQLBGBUPGRADELATCHFROMSHAREDURINGWAR | |||
IT33576 | 3 | REDUCE CHANCE OF SQL0289N | |||
IT33525 | 3 | INACCURATE RESULT OF DECIMAL DIVISION ON NON-AIX PLATFORM | |||
Fix Pack m5fp0 - Administration Tools | |||||
IT34534 | 3 | DB2 ADMINISTRATIVE TASK SCHEDULER STOPS EXECUTING SCHEDULED TASKS | |||
Fix Pack m5fp0 - Buffer Pool Services | |||||
IT34560 | 2 | DB2 ENGINE ABEND FOLLOWING DROP TABLE AND SQLBPREPARE2FREEEXTONTEMPSMP SEVERE ERROR | |||
Fix Pack m5fp0 - CDE Data | |||||
IT33714 | 1 | RUNNING REPLICATED CDE WORKLOAD WITH INVALID DB2_DCC_FILE_PATH VALUE WILL CAUSE DB2 TO FAIL WITH SQL1224. | |||
IT33570 | 2 | A CDE UPDATE STATEMENT MIGHT FAIL WITH SQL0901N '!ISROWLOGBUFFERINITIALIZED()' AND TRAP IN SQERDFSROWSERIALIZER | |||
IT34280 | 2 | CREATE TABLE FAILING WITH "NO MEMORY AVAILABLE IN 'APPLICATION HEAP' | |||
IT34500 | 2 | REORG RECLAIM CODE CAN LEAD TO DEADLATCH | |||
IT33707 | 2 | FODC_FORCEDBSHUTDOWN OCCURS AFTER AN INSERT STATEMENT IS INTERRUPTED AND ATTEMPTS TO ROLL BACK. | |||
Fix Pack m5fp0 - CDE Query | |||||
IT34026 | 2 | INSTANCE COULD GO DOWN WHEN DOING A FULL OUTER JOIN ON TWO COLUMNAR ORGANIZED TABLES WITH NULL COLUMNS | |||
IT34235 | 2 | IMPROVE PERFORMANCE BY IMPLEMENTING SCALAR FUNCTIONS DAYOFMONTH, DAYS_TO_END_OF_MONTH IN COLUMNAR ORGANIZED LOGIC. | |||
IT34147 | 2 | VARIOUS ERROR POSSIBLE: SQL0901N , SQL0955N | |||
IT33467 | 2 | CDE HSJN WITH RESIDUAL PREDICATES THAT HAVE SCALAR FUNCTION APPL IED TO A HOST VARIABLE OR REGISTRY VARIABLE COULD FAIL WITH -901 | |||
IT33293 | 2 | QUERY FAILING WITH SQL0901N AND AN ASSERTION FAILURE "UNABLE TO ACCESS TARGET PAGE FROM PAGE MAP" | |||
Fix Pack m5fp0 - Client Interfaces | |||||
IT33902 | 2 | INTERMITTENT FAILURE WITH CLR_EXCEPTION_SYSTEM.OBJECTDISPOSEDEXCEPTION | |||
IT31498 | 3 | SQL2731N WHEN AN INPUT FILE SIZE OF ZLOAD IS BIGGER THAN 4GB | |||
IT32956 | 3 | DB2 .NET PROVIDER WITH DOUBLE HYPHENS (--) STYLE COMMENT IN SQL STATEMENT HAVING NAMED PARAMETERS THROWS SQL0206N | |||
IT32276 | 3 | NO SQL OVERFLOW ERROR WHEN INSERTING A DECIMAL(20,4) THAT DOES NOT FIT INTO A SMALLINT OR INTEGER COLUMN | |||
IT33640 | 3 | IBM DATA SERVER ADD-INS FOR VISUAL STUDIO (VSAI) DOES NOT SHOW NON-TABLE SCHEMAS | |||
Fix Pack m5fp0 - Codegen and Runtime | |||||
IT33578 | 2 | OPTIMIZE THE PERCENTILE_CONT AGGREGATE FUNCTION TO USE MEMORY MORE EFFICIENTLY AND SPILL TO TEMP IF REQUIRED | |||
IT33236 | 2 | COMPLEX QUERIES WITH EXISTS CLAUSE ON A COLUMNAR TABLE EXECUTED WITH DEGREE GREATER THAN 1 MAY HANG | |||
Fix Pack m5fp0 - Data Recovery Services | |||||
IT32894 | 1 | DB2 : SET WRITE RESUME COMMAND HANGS | |||
IT34022 | 2 | DB2 MIGHT TRAP WHEN EXECUTING MON_GET_UNIT_OF_WORK | |||
IT33533 | 3 | SQL0913 RC=80 NOT BEING CAPTURED BY DB2PDCFG -CATCH LOCKTIMEOUT | |||
IT32560 | 3 | ILOGS ARE ARCHIVED TO BOTH LOG ARCHIVING METHODS ONLY FROM THE ACTIVE LOG PATH WITH DUAL LOGGING ENABLED | |||
Fix Pack m5fp0 - Federation | |||||
IT32523 | 1 | PRIVATE MEMORY LEAK DURING DDL ON COLUMN-ORGANIZED TABLES IN DPF ENVIRONMENT | |||
JR62529 | 2 | QUERIES ON NICKNAMES TO TABLE ON MARIADB RETRIEVES ONLY FIRST CHARACTER OF COLUMN NAMES | |||
JR62557 | 2 | FEDEATION MARIADB JDBC: DATA TYPE MAPPING ERROR | |||
JR62556 | 2 | INSERT INTO SELECT ERROR ON JDBC | |||
Fix Pack m5fp0 - Index Manager | |||||
IT31287 | 1 | DB2 MAY TRAP WHEN USING SELECT RID_BIT() FUNCTION ON A COLUMN ORGANIZED TABLE | |||
Fix Pack m5fp0 - Install and Catalog Services | |||||
IT33705 | 1 | AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES | |||
IT32984 | 1 | SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4411) | |||
IT32939 | 1 | SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4412) | |||
IT34221 | 1 | SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT | |||
IT33708 | 2 | DB2ICRT FAILS WHEN CHECKING GPFS ON PURESCALE | |||
IT33515 | 2 | AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERR ORS AND ENGINE CRASHES | |||
IT34039 | 2 | TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS FOR CDE TABLE MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT. | |||
IT32679 | 2 | ROUTINE MIGRATION FAILS WITH A SQL0478N WHEN A ROUTINE IS USED AS PART OF A TABLE DEFINITION | |||
IT33548 | 2 | AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERR ORS AND ENGINE CRASHES | |||
IT33712 | 3 | COMPLETE FIX FOR IT13674 | |||
IT33312 | 3 | DB2ICRT AND DB2PREQCHECK FREE SPACE AND HOST FAILURE | |||
Fix Pack m5fp0 - JDBC Driver | |||||
IT32581 | 3 | CLPPLUS 11.5 CLIENT THROWS EXCEPTION SQL20570N WITH EXTERNAL TABLE OPERATION HAVING EMPTY FILE WITH GZIP COMPRESSION | |||
IT33041 | 3 | JCC DRIVER NOT SENDING COMMIT AFTER THE LICENSE SP CALL EVEN IF AUTOCOMMIT IS TRUE | |||
IT33602 | 2 | INSERT FROM EXTERNAL TABLE FAILS WITH SQLCODE -4499 -T2LUW | |||
Fix Pack m5fp0 - Monitoring | |||||
IT34023 | 2 | FODC_PANIC WITH INVALID LATCH FROM SQLOLATCHCAS64.C WHEN ROUTINE EXECUTION LIST MONITORING IS ENABLED. | |||
IT33264 | 3 | CAPTURE_STORAGE_INFO MAY FAIL WITH SQL0443N | |||
Fix Pack m5fp0 - Parsing and SQL PL | |||||
IT34440 | 2 | ABNORMAL TERMINATION WHEN EXECUTING THE CREATE-STATEMENT OF A NZPLSQL STORED PROCEDURE | |||
IT33885 | 3 | DB2 MAY ATTEMPT TO REPEATEDLY OPEN A NON-EXISTENT FILE WHICH MAY IMPACT QUERY COMPILATION PERFORMANCE | |||
Fix Pack m5fp0 - Platform Specific | |||||
IT34140 | 1 | SQL20569N WITH REASON CODE "4" DURING LOADING LZ4 COMPRESSED | |||
IT34101 | 3 | FMP PROCESS CAN HANG IN NESTED SIGNAL HANDLER CODE PATH | |||
Fix Pack m5fp0 - Problem Determination | |||||
IT33783 | 2 | DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H (TIME PERIOD SPECIFIERS) | |||
Fix Pack m5fp0 - Process Model | |||||
IT33508 | 1 | IN DPF ENV, SORTSHRHEAPUTIL THRESHOLD MAY NOT TRIGGER PREDICTIVELY FOR QUERIES USING SORT MEMORY ON DATA NODES | |||
IT34607 | 2 | DB2CFIMP ADDS TRAILING CHARACTERS TO DB ALIAS. | |||
IT33186 | 2 | LOCK-WAIT ON DECOUPLED DB2ADCBLD | |||
IT34257 | 2 | DB2 WLM MAY CAUSE UNNECESSARY QUEUING AFTER INSERTS TO EXTERNAL TABLES IN A PARTITIONED DATABASE | |||
IT34284 | 2 | SORT MEMORY HARD CAPPING AND OVER-ESTIMATION ERROR CORRECTION FIXES IN WLM | |||
IT33826 | 2 | LIST STORAGE ACCESS COMMAND GIVES 0 ENTRIES EVEN IF THE CATALOG STORAGE ACCESS COMPLETED SUCCESSFULLY | |||
Fix Pack m5fp0 - Quality Assurance | |||||
IT34614 | 4 | SECURITY: MULTIPLE BUFFER OVERFLOW VULNERABILITIES AFFECT DB2 | |||
Fix Pack m5fp0 - Query Compiler Optimizer | |||||
IT33554 | 2 | SQL0901N PARTITIONED BLU SORT WITH 0 PARTCOLS IS UNEXPECTED | |||
IT34007 | 2 | DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE. | |||
IT33338 | 2 | COLUMNAR SEARCHED UPDATE AND DELETE STATEMENTS EXECUTING WITH HS JOIN THAT APPLIES RESIDUAL PREDICATES MIGHT FAIL WITH SQL0901N " | |||
Fix Pack m5fp0 - Query Compiler QGM | |||||
IT32992 | 1 | WRONG RESULT, WHEN OPTIMIZATION LEVEL IS LESS THAN 5 AND NULL EQUALS NULL PREDICATE | |||
IT34308 | 2 | REPLICATED MQT MATCH MAY FAIL IN SOME SPECIFIC SITUATIONS | |||
IT33171 | 2 | WRONG RESULT WHEN QUERY HAS SCALAR SUBQUERY AND FETCH FIRST 1 ROW | |||
IT34382 | 2 | POOR PERFORMANCE WHEN IN-LIST TO JOIN CAUSING EARLY COMPENSATION | |||
IT33459 | 2 | FIX ISSUES WITH OPTIMIZER VERSION CONTROL (DB2_OPTIMIZER_VERSION REGISTRY VARIABLE) | |||
IT33527 | 2 | POOR PERFORMANCE OF DB2 QUERY HAVING IN SUBQUERY PREDICATE | |||
IT34115 | 2 | INCORRECT QUERY OPTIMIZATIONS RESULTING IN POOR PERFORMANCE OCCUR WHEN STATEMENT CONCENTRATION IS ENABLED | |||
IT32923 | 2 | DB2 MAY ABEND WHEN COLUMN ALIAS USED IN PREDICATE. | |||
IT33870 | 2 | SQL901 WHEN SUBQUERY PREDICATE USED WITH OUTER JOIN | |||
IT32640 | 2 | QUERY FAILS WITH SQL0901 "NO CAST FUNCTION" WHEN DB2_ENABLE_MULTIPLE_CCSIDS=TRUE, DATABASE IS UNICODE | |||
IT33577 | 2 | PERFORMANCE: NEQN (I.E. NULL EQ NULL) PREDICATES NOT DETECTED BY MAGIC DECORRELATION | |||
IT34078 | 2 | DB2 MAY NOT GENERATE TRAILING SPACE AFTER GROUP BY | |||
IT33822 | 2 | HANG IN WHERE ALIAS DUE TO CYCLIC REFERENCE. | |||
IT34222 | 3 | 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE | |||
IT33557 | 3 | USING "ISNOTTRUE" OR "ISNOTFALSE" ROUTINES WITH DECFLOAT DATA TYPE RETURNS SQL0440N | |||
IT33871 | 3 | DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE | |||
Fix Pack m5fp0 - Relational Data Services | |||||
IT33691 | 1 | ON DPF INSTANCE APPLICATIONS MAY HANG WHILE DOING A COMMIT | |||
IT34110 | 2 | -901 SQLCODE (CANNOT FIND CURSOR INFO IN ERT) FOLLOWED BY TRAP | |||
Fix Pack m5fp0 - Routine Infrastructure | |||||
IT34156 | 2 | ALLOW FMP POOLING FOR SPECIFIC USER IDS | |||
Fix Pack m5fp0 - Sailfish Operational Compatibility | |||||
IT34151 | 2 | USING PIPE INTERFACE DURING UNLOAD OPERATION IF PIPE IS USED | |||
IT33740 | 2 | CREATE EXTERNAL TABLE USING SAMEAS/LIKE WITH BASE TABLE HAVING HIDDEN COLUMN IS GETTING CREATED WITH HIDDEN COLUMN | |||
IT33615 | 2 | SQL20570N WHILE LOADING EMPTY FILE USING OPTION REMOTESOURCE GZIP SAME WORKS FINE WITH LZ4 | |||
IT34356 | 2 | FMP TRAP WHILE USING -FORMAT INTERNAL DUE TO SCHEMA MISMATCH | |||
Fix Pack m5fp0 - Security | |||||
IT34107 | 2 | HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLE AND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES | |||
Fix Pack m5fp0 - pureScale Services | |||||
IT33790 | 3 | DB2AUTOSTART DOES NOT WORK ON REBOOT WHEN OS REBOOT IS VERY FAST. | |||
IT33851 | 3 | TSA INITIATED TAKEOVER IN AN AUTOMATED HADR ENVIRONMENT MAY FAIL DUE TO PEER WINDOW HAVING EXPIRED. |
DB2 Version 11.5 Fix Pack m4fp0 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
Fix Pack m4fp0 - Buffer Pool Services | |||||
IT32436 | 2 | HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR | |||
Fix Pack m4fp0 - CDE Data | |||||
IT30387 | 1 | DB2 MIGHT HANG WITH AN EDU WAITING ON SQLO_LT_SQLD_CHAIN__FULLCH AINLATCHNS WHILST HOLDING SQLO_LT_SQELOCALDATABASE__DBLATCH | |||
IT33198 | 2 | IN DB2 V11.5 GA, SQL0901N ERROR MAY OCCUR WITH DB2DIAG.LOG SQLER RMC "UNEXPECTED ERROR AT SYNOPSISTABLETUPLEACCUMULATOR.HPP:130" | |||
Fix Pack m4fp0 - CDE Query | |||||
IT32589 | 1 | CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON | |||
IT31975 | 2 | SELECT WITH SUBSTRING() RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN | |||
IJ24133 | 2 | WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N. | |||
Fix Pack m4fp0 - CLI | |||||
IV98044 | 2 | NEW MONGODB CLIENTS ARE UNABLE TO CONNECT TO IBM JSON WIRE LISTENER | |||
IT31045 | 3 | BULKCOPY ERROR WHILE CHAIN INITIALIZATION WITH NULL VALUE FOR DECIMAL COLUMNS | |||
IT33421 | 2 | SQLGETCONNECTATTR() FUNCTION CALL WITH SQL_ATTR_GET_LATEST_MEMBER_NAME TAKING TIME DUE TO GETADDRINFO TAKING MORE TIME | |||
IT30451 | 2 | NOT ABLE TO LOAD AND USE THE DB2CLIO.DLL | |||
IT33461 | 3 | ERROR ENCOUNTERED WHILE FETCHING SMALLINT DATA USING IBM DATASERVER PROVIDER FOR ENTITY FRAMEWORK CORE | |||
Fix Pack m4fp0 - Codegen and Runtime | |||||
IT32599 | 2 | QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW | |||
IT32367 | 2 | SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB | |||
Fix Pack m4fp0 - Communication | |||||
IT32766 | 1 | SECURITY - DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK | |||
IT32357 | 1 | SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION | |||
Fix Pack m4fp0 - DRDA Services | |||||
IT32363 | 2 | SECURITY: IBM® DB2® LUW IS VULNERABLE TO A DENIAL OF SERVICE ATTACK | |||
Fix Pack m4fp0 - Data Management Services | |||||
IT33146 | 1 | DB2 SERVER TERMINATES ABNORMALLY DURING ROLLFORWARD RECOVERY IN THE SQLPLRQ FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET. | |||
IT33218 | 1 | DB2 SERVER TERMINATES ABNORMALLY IN THE SQLDFETCHLARGEROW FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET. | |||
IT30494 | 2 | CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY | |||
Fix Pack m4fp0 - Data Recovery Services | |||||
IT33172 | 3 | SLOW DATABASE RECOVERY LOG REPLAY ON A WORKLOAD WITH MANY DDLS SPECIFICALLY CREATE / ALTER / TRUNCATE / DROP TABLE | |||
Fix Pack m4fp0 - Install and Catalog Services | |||||
IT31637 | 1 | SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204) | |||
IT32256 | 2 | DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY | |||
IT31741 | 2 | DB2PREREQCHECK FILLS UP / AND /TMP DUE TO SCP TSAMP WITH UNNECES SARY FILES DURING PURESCALE INSTALLATION OR DB2IUPDT COMMAND | |||
IT31588 | 3 | WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID | |||
IT32751 | 2 | HADR STANDBY FAILS WITH "BAD ENTRY STATE" REPORTED FROM SQLRLC_AUTH_GR_PROCESS_ENTRY_STATE | |||
Fix Pack m4fp0 - JDBC Driver | |||||
IT30972 | 2 | JDBC DRIVER NOT TERMINATING TIMER THREADS WITH VERSION 4.26.14 | |||
IT29195 | 2 | CLPPLUS DOES NOT RUN THE LOGIN.SQL SCRIPT DURING STARTUP. | |||
IT32580 | 2 | INTRODUCED A NEW PROPERTY USEJDBC4DATATYPE IN JCC DRIVER AS IT IS NOT BACKWARD COMPATIBLE FOR CLOB/CHAR/VARCHAR DATA TYPE. | |||
IT31612 | 3 | PIGGYBACK COMMANDS ARE NOT REPLAYED IF FAILURE HAPPENS DURING FIRST SQL EXECUTION IN CASE OF NON-SEAMLESS FAILOVER | |||
IT33042 | 2 | DB2STOP MEMBER CAUSED JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION | |||
Fix Pack m4fp0 - Monitoring | |||||
IT31573 | 2 | DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH. | |||
Fix Pack m4fp0 - Platform Specific | |||||
IT31704 | 2 | MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES | |||
IT32507 | 3 | ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID() | |||
Fix Pack m4fp0 - Problem Determination | |||||
IT32716 | 1 | SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE AND DENIAL OF SERVICE | |||
IT32689 | 1 | SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE | |||
IT32714 | 1 | SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE | |||
Fix Pack m4fp0 - Process Model | |||||
IT32439 | 1 | INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES | |||
IT31679 | 3 | DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH | |||
IT31378 | 2 | DB2STOP FAILS WITH SQL6037N, LEAVING [DB2SYSC]<DEFUNCT> | |||
Fix Pack m4fp0 - Query Compiler Optimizer | |||||
IT32195 | 2 | IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS | |||
Fix Pack m4fp0 - Query Compiler QGM | |||||
IT31557 | 2 | SQL1224N AFTER CERTAIN OUTER JOIN QUERIES | |||
IT32731 | 2 | DB2 SERVER TERMINATES ABNORMALLY DURING QUERY COMPILATION | |||
IT28109 | 2 | INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION? | |||
IT32612 | 2 | -901 ERROR IS HAPPENED(BAD PLAN; UNRESOLVED QNC FOUND) WHEN EXECUTING PACKAGE REBIND IN V11.5. | |||
IT31862 | 2 | TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE | |||
IT31634 | 2 | WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION. | |||
Fix Pack m4fp0 - Relational Data Services | |||||
IT31701 | 1 | APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS | |||
Fix Pack m4fp0 - Routine Infrastructure | |||||
IT32126 | 2 | MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO | |||
Fix Pack m4fp0 - Sailfish Operational Compatibility | |||||
IT32568 | 2 | FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH | |||
Fix Pack m4fp0 - Text Search | |||||
IT31755 | 2 | THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000 | |||
Fix Pack m4fp0 - pureScale Services | |||||
IT31054 | 3 | EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" | |||
IT31454 | 3 | EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" |
DB2 Version 11.5 Fix Pack m3fp0 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
Fix Pack m3fp0 - Buffer Pool Services | |||||
IT31892 | 1 | CRASH RECOVERY CAN FAIL AFTER INCORRECTLY REPLAYING EXTENT MOVEMENT LOG RECORDS WITH LARGE RECOVERY WINDOW | |||
IT32436 | 2 | HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR | |||
Fix Pack m3fp0 - CDE Data | |||||
IT31385 | 3 | INCORRECT CALCULATION OF COLUMNAR-ORGANIZED TABLE SPACE CONSUMPTION IN TBPSIZE_ENTITLEMENT_REQ.SQL | |||
Fix Pack m3fp0 - CDE Query | |||||
IT32589 | 1 | CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON | |||
IT31975 | 2 | SELECT WITH SUBSTRING() RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN | |||
IT31628 | 2 | SQL STATEMENT WITH ORDER BY ACCESSING COLUMNAR TABLES MAY BE HUNG IN DPF | |||
IJ24133 | 2 | WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N. | |||
IT31619 | 2 | IN DPF AGAINST COLUMNAR TABLES WRONG RESULT IS POSSIBLE FOR SQL WITH LIMIT WHEN OVER(PARTITION BY) AND ORDER BY IS USED | |||
IT30770 | 2 | SORTHEAP IS TOO SMALL | |||
Fix Pack m3fp0 - Client Interfaces | |||||
IT31515 | 1 | SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK. (CVE-2020-4200) | |||
Fix Pack m3fp0 - Codegen and Runtime | |||||
IT31163 | 1 | WRONG RESULTS ARE POSSIBLE WITH COMPLEX SQL WHICH USES UDFS AND CONSTANTS AND ENCOUNTER A COMPLEX PLAN. | |||
IT31783 | 2 | POSSIBLE TRAP (SEGV) WHEN RUNNING A QUERY ON A NICKNAME POINTING TO A FEDERATED SOURCE AND FEDERATED GOES DOWN. | |||
IT32599 | 2 | QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW | |||
IT32367 | 2 | SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB | |||
Fix Pack m3fp0 - Data Management Services | |||||
IT30494 | 2 | CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY | |||
Fix Pack m3fp0 - Data Recovery Services | |||||
IT30259 | 2 | ROLLFORWARD FAILS DURING LOG CHAIN SWITCH WHEN RUN WITH NORETRIEVE AND OVERFLOW PATH | |||
IT30816 | 3 | MESSAGE PDRECOVERY, PROBE:10 AND PROBE:20 IS LOGGED WITH EACH DIAGEVEL | |||
Fix Pack m3fp0 - Federation | |||||
IT32121 | 1 | SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 LEADING TO DENIAL OF SERVICE OR PRIVILEGE ESCALATION | |||
IT32598 | 2 | [FEDERATION]CREATE NICKNAME FAILS WITH -901 WHEN COLUMN IS DECIMAL(P,S) P>31 | |||
Fix Pack m3fp0 - Install and Catalog Services | |||||
IT31637 | 1 | SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204) | |||
IT32256 | 2 | DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY | |||
IT31588 | 2 | WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID | |||
IT31924 | 2 | INVOKE SCP WITH THE -T OPTION DUE TO CVE-2019-6111 | |||
Fix Pack m3fp0 - Monitoring | |||||
IT31573 | 2 | DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH. | |||
IT20712 | 3 | SYSIBMADM.LOG_UTILIZATION IS RETURNING SQL0801N ON STANDBY | |||
Fix Pack m3fp0 - Platform Specific | |||||
IT31704 | 2 | MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES | |||
IT31615 | 2 | UNNECESSARY SQLO_BAD_USER LOGGING INTO DB2DIAG.LOG | |||
IT22910 | 3 | PDHADDCOUNTER FAILED WITH OSERR -1073738824IN FUNCTION OSSGETPROCESSRAWCPUUSAGE() | |||
IT32507 | 3 | ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID() | |||
Fix Pack m3fp0 - Process Model | |||||
IT31520 | 1 | SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK (CVE-2020-4135) | |||
IT32439 | 1 | INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES | |||
IT31679 | 3 | DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH | |||
Fix Pack m3fp0 - Query Compiler Optimizer | |||||
IT31132 | 2 | DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN | |||
IT32195 | 2 | IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS | |||
IT30946 | 2 | DB2 MAY ABEND WHILE USING PARTICULAR EXPLAIN MODES | |||
Fix Pack m3fp0 - Query Compiler QGM | |||||
IT29945 | 1 | 10 CHAR VALUE CAN BE INSERTED INTO VARGRAPHIC(5 CODEUNITS32). THIS SHOULD FAIL WITH SQL0433N ERROR. | |||
IT31557 | 2 | SQL1224N AFTER CERTAIN OUTER JOIN QUERIES | |||
IT30866 | 2 | DB2 SERVER TERMINATES ABNORMALLY IN SQLNQ_UDF_SPECIFIC WITH STMT_CONC=LITERALS | |||
IT28109 | 2 | INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION? | |||
IT30926 | 2 | TRANSFER OWNERSHIP MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY | |||
IT31862 | 2 | TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE | |||
IT31634 | 2 | WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION. | |||
Fix Pack m3fp0 - Relational Data Services | |||||
IT31701 | 1 | APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS | |||
Fix Pack m3fp0 - Routine Infrastructure | |||||
IT32126 | 2 | MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO | |||
Fix Pack m3fp0 - Sailfish Operational Compatibility | |||||
IT32568 | 2 | FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH | |||
IT31437 | 2 | EMPTY STRING IS NOT INSERTED AS NULL VALUE WHEN NULLVALUE IS EMPTY STRING | |||
Fix Pack m3fp0 - Security | |||||
IT31969 | 3 | EXTRA PRIVILEGES ON NULLID.ATSO05 PACKAGE ARE ADDED TO PUBLIC AFTER RESTORING OLDER RESTRICTIVE DATABASE IMAGE | |||
Fix Pack m3fp0 - Text Search | |||||
IT31755 | 2 | THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000 | |||
IT31449 | 2 | INTERMITTENT HANG IN SOCKET SELECT | |||
Fix Pack m3fp0 - pureScale Services | |||||
IT31054 | 3 | EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" | |||
IT29256 | 3 | DB2INSTANCE -LIST MAY SHOW THE SECONDARY CF IN TRANSIENT ERROR STATE DURING CATCH UP ON BUSY SYSTEMS. | |||
IT31454 | 3 | EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" |
DB2 Version 11.5 Fix Pack m2fp0 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
Fix Pack m2fp0 - Buffer Pool Services | |||||
IT31716 | 1 | ON RARE OCCASION, DATA CORRUPTION MIGHT BE INDUCED BY FAILURE TO PANIC THE DATABASE ON ENCRYPTION ERROR. | |||
IT30898 | 2 | TABLESPACE CONTAINERS COULD BE DELETED WHEN A STORAGE GROUP EXIST ON DBPATH | |||
IT30326 | 2 | INSTANCE MAY TRAP IN FUNCTION SQLBGETVICTIMFROMBLOCKHATELIST | |||
Fix Pack m2fp0 - CDE Data | |||||
IT31719 | 2 | ADDING A NEW TABLE USE FOR DISABLING VECTORIZED ADC | |||
Fix Pack m2fp0 - CDE Query | |||||
IT31181 | 2 | INSTANCE CAN GO DOWN WHEN COLUMN ORGANIZED TABLES ARE USED | |||
Fix Pack m2fp0 - Codegen and Runtime | |||||
IT29583 | 2 | MEMORY LEAK RELATED TO JSON QUERIES. | |||
IT30005 | 2 | DB2 MAY PRODUCE INCORRECT RESULTS FOR HSJN WITH PREDICATE THAT HAS CASE(COALESCE) AND NLJN OR ZZJOIN ON THE OUTER | |||
IT30456 | 2 | INSERT INTO ... WITH IGNORE DUPLICATES MIGHT FAIL WITH -901 REASON "SQLRIOPN: TABLE IS NOT CREATED" | |||
Fix Pack m2fp0 - Data Management Services | |||||
IT30965 | 1 | AN ISCAN FETCH USING CURRENTLY COMMITTED IN PURESCALE MAY RETURN UNCOMMITTED RESULTS. | |||
IT29634 | 2 | INTERRUPTING ROLLFORWARD OPERATIONS DURING REPLAY CAN CAUSE SUBSEQUENT ROLLFORWARD TO FAIL | |||
IT30061 | 2 | DB2 TAKES Z LOCK WHEN ATTACHING PARTITION TO TABLE | |||
Fix Pack m2fp0 - Federation | |||||
IT30251 | 1 | WRONG RESULTS ARE POSSIBLE FOR FEDERATED OR COLUMNAR QUERY WITH AGGREGATION OVER DISTINCT OUTER JOIN | |||
Fix Pack m2fp0 - Install and Catalog Services | |||||
IT31481 | 1 | SECURITY: DB2 IS VULNERABLE TO A PRIVILEGE ESCALATION ATTACK (CVE-2020-4230) | |||
IT29832 | 3 | TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT. | |||
Fix Pack m2fp0 - Parsing and SQL PL | |||||
IT30157 | 1 | SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR UPD | |||
Fix Pack m2fp0 - Platform Specific | |||||
IT30432 | 1 | SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION (CVE-2019-4587) | |||
Fix Pack m2fp0 - Query Compiler QGM | |||||
IT31140 | 1 | CDE HSJN NOT PICKED UP FOR NON EQUAL PREDICATES(RANGE AND OR PREDICATES) | |||
IT30742 | 2 | QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP" | |||
IT31207 | 2 | INCORRECT RESULT WHEN USING TWICE JOIN WITH THE SAME TABLE WITH GROUP BY | |||
IT31462 | 2 | SECURITY: DB2 IS VULNERABLE TO DENIAL OF SERVICE ATTACK (CVE-2020-4161) | |||
IT30467 | 2 | DB2 MAY PRODUCE INCORRECT RESULTS WHEN EXECUTING QUERIES CONTAINING JOINS WITH DIFFERING FLOATING-POINT PRECISIONS | |||
IT29982 | 2 | DB2 MAY RETURN INCORRECT RESULTS WHEN EXECUTING IUD STATEMENTS CONTAINING A SUBQUERY WITH CORRELATION AND AGGREGATION | |||
IT30740 | 2 | COMMENT ON UNICODE TABLE IN A NON-UNICODE DATABASE RESULTS IN UNREADABLE COMMENT | |||
Fix Pack m2fp0 - pureScale Services | |||||
IT30143 | 1 | SECURITY: DB2 AFFECTED BY BUFFER OVERFLOW VULNERABILITIES (CVE-2019-4584) |
DB2 Version 11.5 Fix Pack m3fp0 | |||||
---|---|---|---|---|---|
APAR | Sev. | Abstract | |||
Fix Pack m3fp0 - Buffer Pool Services | |||||
IT30789 | 2 | ROLLFORWARD MAY FAIL WITH SQL1271W AND SQLB_TBSPACE_TOO_SMALL WHEN REPLAYING AN ALTER TABLESPACE OPERATION | |||
IT30784 | 2 | DEADLATCH BETWEEN AN ONLINE BACKUP, PREFETCHERS AND AN AGENT DOING A WRITE TO THE SAME TABLE SPACE | |||
IT30781 | 2 | FALSE POSITIVE AGAINST BACKUP WITH REGISTRY DB2_BCKP_PAGE_VERIFICATION | |||
IT30798 | 2 | TABLE SPACE RESTORE UNABLE TO USE ALL CONTAINER PATHS AND FAILS WITH DISK FULL | |||
IT30811 | 3 | DB2PD -TABLESPACE DOES NOT INDICATE LOCAL OFFLINE STATE | |||
IT30797 | 3 | EXTENT MOVEMENT RETURNS SQL1523N REASON CODE "15" WHEN EXTENT MOVEMENT NOT RUNNING | |||
IT30796 | 3 | RESTORE OF SMS AUTOMATIC STORAGE TABLE SPACE IN DB2 DEVELOPER-C EDITION FAILS WITH SQL1139N | |||
Fix Pack m3fp0 - CDE Query | |||||
IT30231 | 1 | ENGINE MIGHT TRAP IN IBM_CDE::TYPES::BITSTRING::ANDWITHEXPANDEDCPU | |||
Fix Pack m3fp0 - Client Interfaces | |||||
IT30803 | 3 | INCORRECT LENGTH FOR SQL_LOCAL_LEN AND SQL_CODESET_LEN ON AIX | |||
Fix Pack m3fp0 - Data Management Services | |||||
IT29231 | 2 | UNSUSTAINABLE TRAP CAN OCCUR AFTER A SUSTAINED TRAP IF THERETEMP TABLES ARE USED BY TRANSACTIONS | |||
Fix Pack m3fp0 - Data Management Utilities | |||||
IT30793 | 1 | RESTORING A LOADCOPY WHEN THERE IS A MODIFICATION STATE INDEX ON A COLUMN ORGANIZED TABLE MAY CORRUPT THE INDEX. | |||
IT30807 | 2 | ROLL FORWARD OR CRASH RECOVERY MAY CRASH WHEN WORKING ON INDEX PAGE. | |||
Fix Pack m3fp0 - Data Recovery Services | |||||
IT30786 | 2 | ABNORMAL SHUTDOWN OF DATABASE WHEN LOAD ENCOUNTERS SQLO_NOTAVAIL ERROR IN SQLPUPDATEGLOBALTIMEINGLFH | |||
Fix Pack m3fp0 - Federation | |||||
IT25058 | 2 | FEDERATION QUERY MAY GET SQL0302N DUE TO STRING TRUNCATION WHEN A HOST VARIABLE IS USED FOR A REMOTE COLUMN IN DIFFERENT CODEPAG | |||
IT30799 | 3 | RELAX DB2DIAG.LOG MESSAGE IN SQLSFETCHNEXTTEMPRECORD PROBE 504 | |||
Fix Pack m3fp0 - Install and Catalog Services | |||||
IT30778 | 2 | DB2 CRASH ON FUNCTION SQLRL_GET_FULL_NAME() | |||
Fix Pack m3fp0 - Monitoring | |||||
IT29595 | 2 | ADMIN_MOVE_TABLE CONVERTS AUTO CGS STATISTICS PROFILE INTO USER STATISTICS PROFILE | |||
IT30805 | 2 | EM_LIST_LATCH IS GRABBED AND RELEASED FREQUENTLY EVEN THERE IS NO TRANSACTION EVENT MONITOR CREATED/ACTIVE | |||
IT30808 | 3 | DB2 LOCK EVENT MONITOR REPORT: LOCK MODE HELD IS NONE IN PURESCALE | |||
Fix Pack m3fp0 - Platform Specific | |||||
IT30792 | 1 | DB2 MIGHT CRASH IN SQLOFMBLKEX->SQLO_MEM_POOL::MEMTREEPUT WITH "CORRUPT POOL FREE TREE NODE" ERROR MESSAGE IN DB2DIAG.LOG | |||
IT30794 | 2 | CLEANING UP OF EDU CAUSES PRIVATE MEMORY TO LEAK (WINDOWS PLATFORM ONLY) | |||
IT30801 | 3 | STMM REPORTS SEVERE ERRORS ABOUT STMMSIMULATESORTMERGE IN DB2DIAG.LOG | |||
Fix Pack m3fp0 - Problem Determination | |||||
IT30810 | 2 | DB2DART DETECTS ERRORS AFTER UPGRADING | |||
Fix Pack m3fp0 - Process Model | |||||
IT30790 | 2 | DB2LOGGP CAN TRAP WITH SIGNAL #11 IN A FEDERATED ENVIRONMENT | |||
IT21822 | 4 | THE DESCRIPTION OF MAXFILOP IN GET DATABASE CONFIGURATION OUTPUT IS WRONG | |||
Fix Pack m3fp0 - Query Compiler Optimizer | |||||
IT29048 | 2 | HSJN RESID PREDICATE ISSUE, LEADING TO -901 FOR THE CDE QUERY AT PARSERWRAPPER/JOINREWRITER | |||
Fix Pack m3fp0 - Query Compiler QGM | |||||
IT30000 | 2 | DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING EXTERNAL ACTIONS AND CORRELATION | |||
IT28424 | 3 | UNABLE TO CREATE STORED PROCEDURES WITH SAME NAME BUT DIFFERENT PARAMETERS WHEN SQL_COMPAT ='NPS' | |||
Fix Pack m3fp0 - Relational Data Services | |||||
IT30800 | 2 | SECOND EXECUTION OF A CACHED CDE QUERY IN DPF ENVIRONMENT MIGHT LEAD TO SEGV (FODC TRAP) OR FODC MEMORY FOR ILLEGAL REQUEST SIZE | |||
Fix Pack m3fp0 - pureScale Services | |||||
IT30787 | 2 | DB2CLUSTER SEGFAULT CAUSED BY WRONG ARGUMENTS TO PD_HEXDUMP WHEN RUNNING INSTALLFIXPACK ON PURESCALE | |||
IT30788 | 2 | HADR CANNOT BE STARTED DUE TO INSUFFICIENT HADR DATABASE RESOURCE VALIDATION | |||
IT30783 | 3 | A SEGMENTATION FAULT (CORE DUMPED) CAN OCCUR WHEN RUNNING DB2HAICU WITH AN XML INPUT FILE. | |||
IT30809 | 3 | EXTRANEOUS CODE IN THE MOUNTV111_STOP.KSH SCRIPT | |||
IT30806 | 4 | DB2CLUSTER -CM -LIST -TIEBREAKER RETURNS INCORRECT OUTPUT WHEN THE DOMAIN IS STOPPED OR IN MAINTENANCE |
Document Location
Worldwide
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"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:
20 December 2022
UID
ibm11102545