home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36

DB2 - Solutions to problems

Here you can find, daily actualized, the list of reported problems assorted after APAR-Numbers.

Due to restrictions of the IBM APAR-Numbers (IBM DB2 Problem-Numbers) which are branded with a lock-symbol can only be seen by registered users.

Move your mouse over an APAR-Number to show the bug description in a Tooltip.

If you click on the number, the complete description will appear in a new tab.

For full text search for bug descriptions click here

Problems reported sorted by APAR number
IT45824 DOCUMENTATION SHOWS THAT THE SVC_COPY_RATE AND SVC_CLEAN_RATE VALUES ARE INCORRECT
IT42546 AFTER UPGRADING DB2 TO 11.5.6 OR HIGHER IN SAP ENTERPRISE RESOURCE PLANNING, REDIRECTED RESTORE BY BACKOM COMMAND CAN FAIL
IT42207 WRONG RESULT WHEN GROUP BY COL IS MISSING
IT42201 Difference in Per-Partition TSIZE between REORGCHK and REORGCHK_TB_STATS for Partitioned Tables
IT42190 TRAP IN FUNCTION SQLPDOUPDATELSNVALUESINXHDRS WHEN WRITING A LOGRECORD
IT42184 IDENTITY_VAL_LOCAL MIGHT NOT RETURN LAST VALUE IF PREVIOUS INSERT-FROM-VALUES STATEMENT CONTAINED SMP-PARALLELIZED SCALAR SUBSEL
IT42041 HANG DURING CRASH RECOVERY WAITING FOR LOG ARCHIVE WITH MIRRORLOGPATH AND BLK_LOG_DSK_FUL ENABLED
IT42040 HANG DURING CRASH RECOVERY WAITING FOR LOG ARCHIVE WITH MIRRORLOGPATH AND BLK_LOG_DSK_FUL ENABLED
IT42033 HANG DURING CRASH RECOVERY WAITING FOR LOG ARCHIVE WITH MIRRORLOGPATH AND BLK_LOG_DSK_FUL ENABLED
IT42001 DB2ADUTLUPLOAD MAY WRONGLY UPDATE A HISTFILE ENTRY THAT CORRESPONDS TO A BACKUP SEQUENCE THAT FAILS TO BE UPLOADED
IT41999 DB2ADUTLUPLOAD MAY WRONGLY UPDATE A HISTFILE ENTRY THAT CORRESPONDS TO A BACKUP SEQUENCE THAT FAILS TO BE UPLOADED
IT41976 Missing table name in the diagnostic Information regarding not collected statistics in the explain plan file
IT41952 Difference in Per-Partition TSIZE between REORGCHK and REORGCHK_TB_STATS for Partitioned Tables
IT41939 DB2READLOG PERFORMANCE PROBLEM DUE TO UNNECESSARY NETWORK TRANSFER BETWEEN CLIENT AND SERVER
IT41924 DB2READLOG PERFORMANCE PROBLEM DUE TO UNNECESSARY NETWORK TRANSFER BETWEEN CLIENT AND SERVER
IT41917 MON_GET_TABLE MAY BLOCK ON A LOCK WHEN EXTERNAL TABLES ARE BEINGUSED
IT41907 CRASH RECOVERY OF CIRCULAR LOGGING DATABASE FAILS WITH ADM1601E
IT41889 A NON ENCRYPTED DATABASE THAT IS RESTORED AS AN ENCRYPTED DATABASE IS NOT CONNECTABLE AFTER THE RESET DB CFG COMMAND.
IT41873 INCORRECT NUMBER OF LOG RECORDS COPIED FROM EXTRACTION LOG FILES
IT41864 EXTERNAL TABLE INSERT OR SELECT MAY INCORRECTLY RETURN SQL0100
IT41856 TRAP/ERROR READING FROM LOG FILES WITH ALSM ENABLED
IT41834 QUERYING A MASKED TABLE COLUMN MAY RETURN -901 "COULD NOT FIND HXP TO MATCH TUPLE"
IT41827 ONLINE BACKUP MAY HANG WITH ALSM FEATURE ENABLED
IT41821 QUERY WITH "WHERE RID() = " PREDICATE MIGHT RETURN INCORRECT RESULTS IN MPP
IT41807 DB2 TRAPS IN MON_GET_PKG_CACHE_STMT ON WINDOWS
IT41782 CON_LOCAL_DBASES COUNTER IN MON_GET_INSTANCE MAY RETURN AN INCORRECT VALUE IF A DATABASE IS DEACTIVATED WHILE QUIESCED
IT41764 IN DPF ENVIRONMENT, FEDERATION FMP COULD BE INTERPRETED BY OTHERINTERRUPT REQUEST FROM DB2 ENGINE.
IT41757 DB2 TRAPS IN MON_GET_PKG_CACHE_STMT ON WINDOWS
IT41735 XMLAGG WITH XMLQUERY INPUT AND GROUP-BY-CLAUSE MAY FAIL WITH -901 "BAD PLAN; UNRESOLVED QNC FOUND"
IT41729 TRANSACTION MAY NOT BE RESOLVED COMPLETELY IF A TABLESPACE IO ERROR IS ENCOUNTERED DURING RECOVERY WITH DB2_ONLINERECOVERY.
IT41684 ROLLFORWARD DOES NOT COMPLETE WITH COMPRESSED FILE IN OVERFLOW LOG PATH
IT41683 ROLLFORWARD DOES NOT COMPLETE WITH COMPRESSED FILE IN OVERFLOW LOG PATH
IT41680 AUTO_REORG MIGHT BE TRIGGERED FOR TABLES WITH ADAPTIVE COMPRESSION ENABLED DUE TO F2 < 70 FOR MDC
IT41655 QUERIES USING FETCH FIRST N ROWS AND COLUMN-ORGANIZED INDEX SCANS COULD PERFORM POORLY
IT41653 ERROR MESSAGES WITH SQLNLSICUCONVERTTODATEFORMAT_CLDR2701
IT41646 FEDERATION FUNCTIONS NOT PUSHED DOWN WHEN USING PARAMETER MARKERSUCH AS TO_TIMESTAMP(?,'YYYY-MM-DD HH24:MI:SS')
IT41644 SQL1822 ON FEDERATION SERVER BETWEEN UTF8 AND ISO-1 DATABASE WHEN THE SERVER OPTION IS STRING_UNITS 'S'
IT41639 EXCESSIVE DB2DIAG ENTRY FROM SQLPGRETRIEVELOOKUP
IT41626 CRASH RECOVERY AFTER A DATABASE ROLLFORWARD TO POINT IN TIME THAT INCLUDES AN INDOUBT TRANSACTION FAILS WITH SQL1265 (ADM1532E)
IT41578 IF XAER_RMFAIL RECEIVED WHILE READING A RESULTSET FROM APPLICATION THEN CONNECTIONEVENT LISTENER NEED TO RAISE XAER_RMFAIL EVENT
IT41576 DB2AUDIT SYNTAX ERROR WRITES AN UNNECESSARY ERROR LEVEL MESSAGE IN DB2DIAG.LOG
IT41557 IN RARE SCENARIOS, CERTAIN DB2 FUNCTIONS CAN HANG WHEN ATTEMPTING TO RESPAWN A CHECK PASSWORD DAEMON
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
IT41547 INSTANCE CRASHED WHEN MULTIPLE CONNECTIONS IMPLICITLY ACTIVATE DATABASE WITH DIFFERENT CODEPAGE SETTING.
IT41546 PERFORMANCE IS AFFECTED BY LATCH CONTENTION WHEN INPUT DATA VALUE CAPTURE IS ENABLED FOR A LOCKING EVENT MONITOR
IT41536 TRANSACTIONS MIGHT BE BLOCKED IN COMMIT ACTIVE STATE WHEN DB2 ISEXTENDING A TRUNCATED LOG FILE
IT41517 QUERY PERFORMANCE MAY VARY WHEN USING OUTER JOIN OPERATOR
IT41514 -901 INVALID POOLID AND OR OBJECTID ERROR IS INCORRECTLY RETURNED AFTER A TEMP TABLESPACE FULL SCENARIO
IT41505 QUERY PERFORMANCE MAY VARY WHEN USING OUTER JOIN OPERATOR
IT41503 MONITOR ELEMENTS IN THE ACTIVITY EVENT MONITOR THAT DEPEND ON SNAPSHOT MAY BE INCORRECT FOR CREATE/DECLARE TABLE AS STATEMENTS
IT41487 INSTALLFIXPACK DELETES /ETC/SYSTEMD/SYSTEM/DB2FMCD.SERVICE FILE ON LINUX
IT41486 CONVERT TRAP IN DATABASETABLEACCESSOR::GETCOLUMNDICTIONARYVERSIONBASE TO SQL0901N MESSAGE
IT41481 RUNSTATS CALCULATES PCTINLINED INCORRECTLY WHEN USING TABLE SAMPLING
IT41474 CONNECTION FROM DB2FMP TO THE ENGINE IS NOT CLEANED UP AFTER AN INTERRUPT
IT41469 Sortheap memory leak possible for index-and access on MDC tables
IT41466 DB2SUPPORT WITH THE -CL 2 OR -CL 3 OPTION CAN UNDER SOME CIRCUMSTANCES RESULT IN A SEGV TRAP
IT41465 Add asserts to prevent traps in pageWriteCallback methods
IT41464 Severe error and possible memory corruption detected when function sqlrkrpc_freemsg tries to free memory
IT41456 SQL0433N ON RETRIEVAL ASSIGNMENT WHEN DBCLOB CAST TO VARCHAR
IT41428 Trap due to signal 11 (SIGSEGV) in function ColumnDictionaryVersionBase::getSize
IT41427 DATA TYPE CONVERSION LEADS TO -SQL0413N OVERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSION
IT41421 TABLESPACE ROLLFORWARD IS VERY SLOW DUE TO EXCESSIVE NUMBER OF SQLBAFLSH() CALLS
IT41420 TABLESPACE ROLLFORWARD IS VERY SLOW DUE TO EXCESSIVE NUMBER OF SQLBAFLSH() CALLS
IT41418 FEDERATION ZOS DB2 REPORT SQL0181N THE STRING REPRESENTATION OFA DATETIME VALUE ERROR WHEN QUERY WITH DATE AND TIMESTAMP COMPA
IT41415 POOR PERFORMANCE OF DB2 QUERY WITH UNION SUBQUERIES
IT41403 CRASH IN SQLPGETLOGTAILHEARTBEAT()
IT41386 POOR PERFORMANCE WHEN IN SUBQUERY USES THE SAME TABLE
IT41384 DB2 ENTERPRISE SERVER (DB2ESE) COMPLIANCE REPORT SHOW INDEX COMPRESSION LICENSE VIOLATION ON V11.5.6 AND 11.5.7
IT41358 FEDERATED SQL20357N ONE OR MORE FEDERATED ONE-PHASE COMMIT DATA SOURCE SITES HAVE FAILED COMMIT OR ROLLBACK PROCESSING
IT41356 FEDERATED SQL20357N ONE OR MORE FEDERATED ONE-PHASE COMMIT DATA SOURCE SITES HAVE FAILED COMMIT OR ROLLBACK PROCESSING
IT41348 DB2MOVE RETURNS SQL0206 WHEN EXECUTE INVALID STATEMENT SELECT OWNERTYPE FROM SYSIBM.SYSROUTINES
IT41340 Errors in complex INSERT FROM SELECT scenario involving ColumnarTables.
IT41339 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE AFTER ENTERING A MALFORMED SQL STATEMENT INTO THE DB2EXPLN TOOL
IT41338 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE AFTER ENTERING A MALFORMED SQL STATEMENT INTO THE DB2EXPLN TOOL
IT41322 FIXING RCCOPENDUMMYCONNECTION TO USE SQLCC CALLS INSTEAD OF DRDATO ATTEMPT TO OPEN AN SSL CONNECTION WITH TARGET SERVER.
IT41317 -901 WHEN COMMON TABLE EXPRESSION USED IN JOIN.
IT41316 TOO MANY LOG FILES IN ACTIVE LOG PATH ON HADR STANDBY AND ALSM ENABLED
IT41314 WRONG RESULT WHEN SORT WITH FETCH FIRST N ROWS IS DONE IN COLUMNAR LOGIC
IT41312 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE AFTER ENTERING A MALFORMED SQL STATEMENT INTO THE DB2EXPLN TOOL
IT41301 ADD ASSERT TO RULE OUT POSSIBLE CAUSE OF APAR IT41275
IT41289 MEMORY LEAK IN SQLQG_MISC_FMP.C WHILE IMPORT DATA INTO NICKNAME WHEN WRAPPER OPTION "DB2_FENCED' TO 'Y'
IT41276 SUSTAINED TRAP ON HADR STANDBY BLOCKS REPLAY-ONLY WINDOW
IT41270 ERRORCODE=-4474 RETURNED FROM JCC DRIVER FOR SET CURRENT PACKAGEPATH WHILE REUSING THE CONNECTION FROM THE POOL
IT41265 HADR PRIMARY MIGHT CAUSE A TRAP WHEN PROCESS IS SLOW AND PEER WAIT LIMIT REACHED
IT41264 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
IT41259 GW_* METRICS ARE ZERO IN MON_GET_INSTANCE
IT41253 HADR GRACEFUL TAKEOVER MIGHT CAUSE A TRAP ON THE NEW PRIMARY
IT41248 DB2 INSTALLER SETUP.EXE DOES NOT START UP WHEN COMSPEC HAS TWO CMD.EXE ON WINDOWS
IT41241 POSSIBLE FMP TRAP WHEN USING ADMIN ROUTINES OR ANY MODULE USING LIBDB2XMLINIT531.A
IT41238 QUERY USING JSON CANNOT BE TERMINATED THROUGH THE NORMAL METHOD OF FORCING THE APPLICATION
IT41235 HADR FAILOVER TOOK LONG TO COMPLETE WHEN DB2_ONLINERECOVERY IS ENABLED
IT41234 INGEST MY HANG WHEN THE AMOUNT OF SHARED MEMORY IS INSUFFICIENT FOR FORMATTERS AND FLUSHERS
IT41228 BAD PLAN CAUSED BY TEXT SEARCH CONTAINS() USING THE DEFAULT FILTER FACTOR
IT41227 WHEN THE ATS FAILS TO RUN A TASK, IN SOME CASES THE TASK MAY REMAIN IN RUNNING STATE
IT41223 ISSUING A CREATE TABLE QUERY MAY CAUSE THE SERVER TO TERMINATE ABNORMALLY ON AIX
IT41222 IMPROVE DIAGNOSTICS FOR FCM DOUBLE FREE OF A CHANNEL
IT41220 DB2 MAY ABEND WHEN UNION HAS BOTH PUSHDOWNABLE AND NON PUSHDOWNABLE BRANCH
IT41215 STATICASDYNAMIC OPTION NOT SUPPORTED FOR COMPILED SQL OBJECTS
IT41211 A TRAP DUE TO A SIGNAL 11 CAN OCCUR IN THE MEMORY CLEAN UP DAEMON.
IT41205 SLOW PERFORMANCE MIGHT BE OBSERVED WHEN RUNNING AN IUD STATEMENTWITH CERTAIN CHARACTERISTICS
IT41198 JCC DRIVER RETURNS -204 DUE TO IMPROPER SCHEMA ORDER REPLAY WHENUSING SYSPLEX WLB
IT41184 POTENTIALLY BAD PERFORMANCE WHEN USING PARAMETER MARKERS IN QUERIES CONTAINING JOINS
IT41178 DB2ICRT COMMAND FAILS TO CREATE RESOURCE DUE TO UNKNOWN TRANSPORT TYPE
IT41166 SQL1092 TOKEN:X180085 ON CALL GET_DBSIZE_INFO(?,?,?,0)
IT41162 "SQLOSSIG, PROBE:10" DB2DIAG.LOG MESSAGE IS WRITTEN TO DB2DIAG.LOG REGARDLESS OF DIAGLEVEL SETTING
IT41161 OPTION TO DISABLE AUTO FAILOVER AFTER 2 CONSECUTIVE TSA DB MONITOR TIMEOUTS
IT41152 SQL0973N with token 'Applications Shared Heap' when very complex sql is run with high degree of SMP parallelism.
IT41143 POSSIBLE MEMORY LEAK USING PD_GET_DIAG_HIST()
IT41140 WRONG RESULT WHEN PREDICATE WITH CONSTANT ON AGGREGATE FUNCTION WITH CASE.
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
IT41132 DB2 QUERY MAY GENERATE 901 WHEN MULTIPLE NOTIN SUBQUERY EXISTS.
IT41130 INSTANCE CRASH IN SQLMON_STMT::ESTIM_STMT_INFO_SZ
IT41124 POOR PERFORMANCE FOR NLJOIN IN CDE
IT41121 GENERATING A REDIRECTED RESTORE SCRIPT MAY CRASH INSTANCE IF STORAGE GROUP FILES BECOME CORRUPTED
IT41115 Query fails with SQL0901N and assertion failure "Evolved dictionary TSN cannot be larger than the last used TSN"
IT41113 -901 UNEXPECTED ERROR AT GETJOINPAYLOADEVALUATOR.CPP
IT41104 POSSIBLE 901 ERROR WHEN RUNNING QUERY WITH TEXT SEARCH FUNCTION
IT41083 Possible trap in sqlnq_scalar_aggregate() when using LISTAGG() WITHIN GROUP()
IT41082 DB2 SERVER TERMINATES ABNORMALLY WHEN STATEMENT CONCENTRATOR ENABLED
IT41057 SQL0407N RETURNED WHEN RUNNING AN INSERT FROM RTABLE
IT41054 POSSIBLE PERFORMANCE ISSUES FOR CORRELATED QUERIES WHEN MIGRATING TO DPF SYSTEMS
IT41049 INSERT STATEMENTS WITH USER-DEFINED SQL FUNCTIONS AND VALUES TABLE FUNCTIONS MIGHT SHOW PERFORMANCE ISSUES.
IT41028 ISSUING A SELECT QUERY MAY ENTERS AN INFINITE LOOP
IT41024 HIGH "SQLO_LT_SQLB_BP_AREA_INFO_PAGEAREA__CLOCKLATCH" CONTENTIONS ON DB2 PURESCALE
IT41019 POSSIBLE -430 ERROR WHEN CONNECTING MYSQL-CE VIA JDBC CONNECTIONWITH JRE VERSION 1.8.0 BUILD 8.0.7.5 (SR7 FP5)
IT41003 AUTO_REORG MIGHT BE TRIGGERED FOR TABLES WITH ADAPTIVE COMPRESSION ENABLED DUE TO F2 < 70 FOR MDC
IT40987 TRAP WHEN UNION AND REFERENCE TO SAME SUBSELECT IN DB2 QUERY
IT40984 PERFORMANCE (HANG) ISSUE WHILE PROCESSING STACK OF NESTED TABLESWITH COMPLEX EXPRESSIONS
IT40980 Trap in JSON function
IT40975 MISLEADING DB2DIAG.LOG MESSAGE WHEN USING ZLIB BASED BACKUP OR LOG FILE COMPRESSION
IT40965 PERFORMANCE (HANG) ISSUE WHILE PROCESSING STACK OF NESTED TABLESWITH COMPLEX EXPRESSIONS
IT40953 "EXPLAIN PLAN FOR" DOES NOT WORK FOR TEXT SEARCH QUERY
IT40926 DB2EVMONFMT MAY FAIL WITH SQLCODE=-104 WHEN USING THE -WTT OPTION
IT40920 SQL0973N WHEN ACQUIRING HEAP MEMORY FROM DATABASE MEMORY, ALTHOUGH WE HAVE LARGE UNRESERVED MEMORY LEFT IN THE SET.
IT40917 LATCH CONTENTION SQLO_LT_SQLRLC_ANCHOR_COMMON__ANCHOR_LATCH DURING SCHEMA AUTHORITIES CHECKS
IT40916 WHEN DB2_TWO_PHASE_COMMIT=Y AND READONLY=TRUE ON FEDERATION, GETFODC_FORCEDBSHUTDOWN
IT40913 INCORRECT RESULT WHEN DB2 QUERY HAS EQUAL PREDICATES WITH CONSTANTS
IT40910 THE COMPONENTLIST_SERVER_T.HTM FILE AND DB2LS -Q COMMAND OUTPUT ARE INCONSISTENT
IT40909 FEDERATED PUSHDOWN OF A DATE COMPARISON PREDICATE CAN EITHER FAIL OR RETURN SQL0901N.
IT40906 BACKUP USING LIBDB2NX842_ENCR.A MIGHT RETURN SQL2079N WITH RC=1
IT40905 INCORRECT ROW COUNT REPORTED WITH INSERT .. IGNORE DUPLICATES , COLUMNAR TABLES ONLY.
IT40903 MEMORY LEAK WHEN SQLGETCONNECTATTR() IS CALLED WITH THE SQL_ATTR_GET_LATEST_MEMBER ARGUMENT
IT40898 SECURITY: IBM DB2 IS AFFECTED BY MULTIPLE VULNERABILITIES IN LIBEXPAT LIBRARY
IT40897 SECURITY: IBM DB2 IS AFFECTED BY MULTIPLE VULNERABILITIES IN LIBEXPAT LIBRARY
IT40896 SECURITY: IBM DB2 IS AFFECTED BY MULTIPLE VULNERABILITIES IN LIBEXPAT LIBRARY
IT40895 SECURITY: IBM DB2 IS AFFECTED BY MULTIPLE VULNERABILITIES DUE TOvulnerabilities in LIBEXPAT library
IT40894 "DB2PD -LATCHES" COMMAND WITH THE "GROUP" SUBOPTION MIGHT NOT REPORT LATCH HOLDERS CORRECTLY
IT40893 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE DUETO UNAUTHORIZED ACCESS. (CVE-2022-22483)
IT40892 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE DUETO UNAUTHORIZED ACCESS. (CVE-2022-22483)
IT40888 LIKE PREDICATES IMPROVEMENTS
IT40885 DEADLOCK BETWEEN TWO DROP TABLE STATEMENTS, EACH EXECUTING ABP'SDROPPED-OBJECT CANCELLATION.
IT40880 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE DUETO UNAUTHORIZED ACCESS. (CVE-2022-22483)
IT40879 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE DUETO UNAUTHORIZED ACCESS. (CVE-2022-22483)
IT40877 RETRIEVE LOG FILE FAILED WITH SQLP_LOG_NOT_IN_ARCHIVE ERROR DUE TO SEARCHING WITH WRONG LOGCHAINID IN LOG ARCHIVE
IT40874 SPIKES IN SQLO_LT_SQLRA_CACHED_ENV__LATCH WAIT, USING STMT_CONC=LITERALS, ON CONCURRENTLY COMPILATION OF A STATEMENT
IT40873 SQL1092 TOKEN:X180085 ON CALL GET_DBSIZE_INFO(?,?,?,0)
IT40868 DB2 INSTANCE CRASH ON FUNCTION SQLERGETFMPFROMPOOL()
IT40867 DRDA WRAPPER REPORTS SQL30020 WHEN REMOTE COLUMN IS CHAR CODEUNITS32 AND FEDERATED DATABASE IS SBCS
IT40858 PURESCALE: Free space search during insert of a record might endprematurely.
IT40849 APPLICATION MAY HANG IN WaitSendReady WHEN SENDING AN RPC MESSAGE
IT40847 ENDLESS ITERATION OF DB2 CLEANUP AND KILL PROCESSES MAKE DB2 PURESCALE CLUSTER HANG
IT40843 TBSCAN INSTEAD OF IXSCAN IS INCORRECTLY USED BY THE OPTIMIZER
IT40840 SAPTOOLS.ADMIN_COL_ANALYZE_FRAGMENTATION MIGHT RETURN SQL0802N
IT40829 DB2 QUERY MAY TRAP WHEN DIFFERENT COLUMNS ACCESSED IN MULTIPLE SCALAR SUBQUERIES
IT40819 REORG NOT RECLAIMING EXTENTS FOR ITC TABLES EFFICIENTLY.
IT40815 Difference in Per-Partition TSIZE between REORGCHK and REORGCHK_TB_STATS for Partitioned Tables
IT40806 TRUNCATING TABLE SPACE FILES (SQLSPCS.1/2) LARGER THAN 4GB MAY FAIL
IT40804 AUTO TABLE MAINTENANCE DB2ACD PROCESS FAILS TO CONNECT TO DATABASE WHEN DB2CLI.INI CONFIGURED TO ENFORCE TCP CONNECTIONS
IT40802 SECURITY: IBM DB2 IS AFFECTED BY MULTIPLE VULNERABILITIES IN LIBEXPAT LIBRARY
IT40781 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE DUETO UNAUTHORIZED ACCESS. (CVE-2022-22483)
IT40771 APPLICATION MAY HANG DUE TO THE LOST COMMUNICATION BETWEEN THE AGENT AND FMP CODE
IT40762 INCORRECT RESULT WITH QUERY HAVING UNION
IT40758 HANG ON FIRST CONNECT DRIVING CRASH RECOVERY WHEN DB2LOGMGR HANGS DUE TO VENDOR PROBLEM
IT40755 SQLCODE -901 MAY OCCUR WITH MESSAGE "EMPTY PLAN LIST DETECTED" WHEN COMPILING A CDE QUERY
IT40752 DB2 QUERY TRAPS WHEN MODIFYING STATEMENT USES SET COLUMN THAT ISNOT USED IN SUBQUERY PREDICATE
IT40751 RARE TIMING SCENARIO IN UPGRADE OF PURESCALE CLUSTERS CAN PREVENT CF MEMORY ALLOCATIONS FROM BEING ADJUSTED AUTOMATICALLY
IT40749 ONLINE BACKUP MAY FAIL WITH SQL5193N IF DATABASE IS CREATED IN RESTRICTIVE MODE
IT40744 UPDATE SAPTOOLS.UPPER/LOWER TO COMPLY WITH LATEST UNICODE STANDARD
IT40742 DB2READLOG API FAILED WITH SQL2038N DUE TO CHANGING OVERFLOWLOGPATH ONLINE
IT40723 DB2STOP MAY TIMEOUT ON A PARTITIONED DATABASE DUE TO A LATCHING PROTOCOL PROBLEM
IT40718 DB2 QUERY MAY PERFORM POOR WHEN NOT IN SUBQUERY HAS EXPRESSION.
IT40711 PRINT SYSTEM DUMP MESSAGES IN DB2DIAG.LOG WHEN DB2 INITIATE SYSDUMPSTART COMMAND DUE TO MEMBER OR CF PROCESS CANNOT BE KILLED
IT40710 DB2 FAILS TO REINITIALIZE PL/SQL PACKAGES AND SQL PL MODULES AFTER RECOMPILATION OF THE PACKAGE/MODULE BODY (MULTI-CONNECTION)
IT40708 INSTALLFIXPACK SHOULDN'T CHECK IF GPFS IS MANAGED BY DB2 BY USERON TIEBREAKER HOSTS
IT40699 INSTANCE CRASH WHEN SQLO_CPSAME ERROR HAPPENS IN SQLRICASTG2C
IT40685 LOAD RESETDICTIONARYONLY IS INCOMPATIBLE WITH BLOCKNONLOGGED
IT40676 OPTIMIZER MAY GENERATE A NEW TYPE OF PLAN BECAUSE OF HOW INDEX ORING PLANS ARE BUILT BETWEEN 9.7 AND 10.5
IT40670 SQL1611W - NO DATA WAS RETURNED BY DATABASE SYSTEM MONITOR FOR "DB2 LIST ACTIVE DATABASES" DURING SET WRITE SUSPEND.
IT40660 DB2START FAILS WITH SQLE_SAL_MIXED_TRANSPORTS_ERROR WHEN ONE OF THE RDMA ADAPTERS ON THE HOST IS IN UNKNOWN STATE
IT40659 DB2 HADR START MAY TIMEOUT WAITING FOR DB2 START
IT40657 ONLINE BACKUP MAY FAIL WITH SQL5193N IF DATABASE IS CREATED IN RESTRICTIVE MODE
IT40651 DB2LOGGX PROCESS CONSUMING HIGH CPU
IT40634 USE OF EXTERNAL TABLE WITH REMOTESOURCE OPTION AND LOAD CURSOR RESULTS IN A CRASH OF THE DATABASE
IT40626 DB2 QUERY MAY GENERATE 901 FOR QUERIES WITH UNION
IT40625 DB2 QUERY MAY GENERATE 901 FOR QUERIES WITH UNION
IT40618 WARNING MESSAGE COULD BE LOGGED INCORRECTLY IN DB2DIAG.LOG.
IT40614 SQL0952N MIGHT HAPPEN WHEN REAL-TIME STATISTICS IS ENABLED FOR COLUMN-ORGANIZED TABLES
IT40604 ADMIN_MOVE_TABLE COPY_STATS MIGHT FAIL IF SYSSTAT.COLDIST CONTAINS NON-PRINTABLE CHARACTERS
IT40602 RARE TRAP IN RIGHT OUTER HSJN WHEN INTERRUPT IS ISSUED.
IT40596 Driver throws ARRAYINDEXOUTOFBOUNDEXCEPTION in SQLJ heterogeneous batch environment
IT40590 SETTING UP THE FAULT MONITOR FACILITY TO AUTOMATICALLY RESTART DB2 INSTANCES FAILS ON A NON-ROOT INSTALLATION
IT40585 ONLINE BACKUP INCLUDE LOGS MIGHT FAIL WITH ADM8010E
IT40564 DROP STORE PROCEDURE MIHGT CAUSE TRAP
IT40560 LOCAL PREDICATE PUSHDOWN FAILS WHEN IN SUBQUERY IN SELECT
IT40544 DATABASE NOT SHUTDOWN WHEN LOAD REPLAY FAILS ON HADR STANDBY WITH DB2_FAIL_RECOVERY_ON_TABLESPACE_ERROR ENABLED
IT40543 CONNECTION FROM DB2FMP TO THE ENGINE IS NOT CLEANED UP AFTER AN INTERRUPT
IT40539 DB2IUPDT FAILS TO UPDATE THE FENCED ID. IT UPDATES PARTIALLY.
IT40538 DB2IUPDT FAILS TO UPDATE THE FENCED USERID
IT40537 A FULL OUTER JOIN QUERY MAY PRODUCE A -901 WITH THE REASON "EMPTY PLAN LIST DETECTED!"
IT40527 HADR STANDBY FAILS WITH SQLRLC_FIND_LATCH_ANCHOR() PROBE:5 "INVALID ENTRY_TYPE" CALLED BY SQLPRDBREDOROSCATCACHEINV()
IT40526 HADR STANDBY FAILS WITH SQLRLC_FIND_LATCH_ANCHOR() PROBE:5 "INVALID ENTRY_TYPE" CALLED BY SQLPRDBREDOROSCATCACHEINV()
IT40525 DB2ACD FAILS TO EXECUTE SCHEDULED TASKS WHEN THERE IS A DB2CLI.INI FILE
IT40523 FLUSH BUFFERPOOL IS NOT SUPPORTED ON STANDBY WITH LOG_DDL_STMTS=YES
IT40520 SQLO_URL_UNKNOWN_HEADER RETURNED WHEN S3 BUCKET IS USING KMS ENCRYPTION
IT40515 DB2ACD FAILS TO EXECUTE SCHEDULED TASKS WHEN THERE IS A DB2CLI.INI FILE
IT40511 HADR STANDBY IS SYNCHRONOUSLY DELETING OLD LOG FILES DURING ACTIVATION
IT40509 IMPROVE EFFICIENCY OF CLIENT SIDE TLS CONNECTIONS
IT40504 CLP RETURNS THE UNEXPECTED VALUE ?S AT CTRL_FILE_RECOV_PATH UNDER LANG=JA_JP.UTF8
IT40483 EXCESSIVE CALLS TO OPERATING SYSTEM DATETIME FUNCTIONS, FOR EXAMPLE LOCALTIME_R, CAUSES LOCK CONTENTION IN THE OPERATING SYSTEM
IT40476 WHEN OLAP IS DONE IN COLUMNAR LOGIC QUERY COULD EXPERIENCE A HANG
IT40474 DB2 ZLIB BACKUP AND LOG FILE COMPRESSION DOES NOT USE HARDWARE ACCELERATION ON UBUNTU
IT40464 QUERY MIGHT TRAP IN DATA PARTITION ELIMINATION OF A ZIGZAG JOIN
IT40463 ADMIN_MOVE_TABLE RETURNS SQL20491N RC 6 FOR USER MAINTAINED TEMPORAL TABLES
IT40462 DB2 CRASHES AND TRAPS IN THE SSQLRICDESECTIONCLEANUPRETAINEDSCHEDINFO FUNCTION
IT40460 DB2PD -BARSTATS TIME ACCOUNTING INCORRECT WHEN OBJECT (REMOTE) STORAGE IS USED
IT40458 RESULTSET.DELETE() METHOD RETURNS CLI0119E WITH SQLSTATE 58004
IT40456 SQL0158 OR SQL0421 QUERYING FROM VIEW OVER TEMPORAL TABLE AFTER ADDING NEW COLUMN
IT40445 CRASH IN WHEN XML SOURCE FILE IS DELETED OR RENAMED
IT40442 ON AIX GETMAXCOMPRESSEDSIZE MIGHT RETURN A TOO LOW VALUE
IT40438 A DROP ROLE STATEMENT MIGHT TRIGGER ERROR TRYING TO WRITE A LOG RECORD EXCEEDING MAXIMUM SIZE
IT40414 POSSIBLE TRAP (SEGV) IN PSM_DECLARE_VARIABLE_NODE() OR PSM_GEN_ROW_FIELD_VARIABLE() TRYING TO CREATE A PROCEDURE WITH A COMPLEX
IT40412 PERFORMANCE DEGRADATION IN MPP SETUP WITH SQLCODE: -391 ERRORS IN DB2DIAG.LOG AFTER TRUNCATE WITHOUT IMMEDIATE ON REPLICATED MQT
IT40410 DECIMAL PRECISION DIFFERENCE IN JDBC WITH ORA & NON-ORA SETTING
IT40408 DB2 V11.5.4 DB2START GETS UNDEFINED SYMBOL CRYPTO_NUM_LOCKS ERROR
IT40407 SQL0954C, SQL0973N, OR OTHER OUT OF MEMORY ERROR WHEN BUILDING COLUMN DICTIONARY FOR LONG STRING COLUMN
IT40405 SPECTRUM PROTECT SNAPSHOT MIGHT LEAVE ORPHANED VOLUMES AFTER BACKUP OR CLONE OPERATIONS.
IT40386 DB2IUPDT REPORTS INCORRECT EXPLANATION FOR DBI1291E
IT40384 FEDERATION: ORACLE DATA SOURCE, CREATE NICKNAME TOO MANY TIMES MIGHT CAUSE "ORA-01000: MAXIMUM OPEN CURSORS EXCEEDED" ERROR
IT40381 TRACEABILITY FOR LINE# AND FILE NAME IN DB2 .NET FOR FW AS WELL AS CORE RUNTIMES TO BE STAMPED IN MEM DIAGNOSTICS.
IT40363 -1667 WITH TOKENS TABLE TYPE: "ORGANIZE BY COLUMN". OPERATION: "WITH RR"
IT40359 POSSIBLE DEADLATCH IN SQLOMEMINIT() WHEN IT LOADS CLIENT-SIDE LIBRARY
IT40358 UPDATE GSKIT TO 8.0.55.26
IT40356 A DROP ROLE STATEMENT MIGHT TRIGGER ERROR TRYING TO WRITE A LOG RECORD EXCEEDING MAXIMUM SIZE
IT40351 SEVERITY CHANGE OF LOG ENTRY: "FUNCTION: DB2 UDB, ROUTINE_INFRASTRUCTURE, SQLERINITFMPHEAP, PROBE:995* RETCODE : ZRC=0X00000000=
IT40335 HADR STANDBY IS SHUTDOWN DUE TO NOT FINDING A LOG FILE RETRIEVED FROM ARCHIVE
IT40328 DB2 MIGHT REPEATEDLY REPORT ISSUES IN SQLSMERGEREC
IT40326 DB2 MAY TRAP WHEN RUNNING UPDATE STATEMENT THAT CONTAINS SPECIALCHARACTERS.
IT40316 DB2 MAY TRAPP IN DFPAL_DECIMAL128FROMSTRING
IT40315 DB2 MAY TRAPP IN DFPAL_DECIMAL128FROMSTRING
IT40313 MERGE STATEMENT FAILS WITH SQLCODE -151 SQLSTATE 42808
IT40294 WHEN RUN DB2SETUP OR DB2ICRT ON AIX, THE OUTPUT MAY BE CORRUPTED.
IT40293 "GRANT DATAACCESS ON SCHEMA" PREVENTS LOAD WHEN MODIFIED BY "DUMPFILE DUMPFILEACCESSALL"
IT40290 DB2FMTLOG TOOL DISPLAYS INTERNAL ERROR WHEN FORMATTING A DB2 LOGFILE.
IT40288 OPTIMIZER USES EMPTY QUANTILE STATS LEADING TO CARDINALITY UNDER-ESTIMATION
IT40287 THRESHOLD DOES NOT FIRE WHEN CONCUR_OVERFLOW_ENABLED AND CONCUR_OVERFLOW_MAX ENABLED
IT40279 RUNNING BIG SQL RETURN ERROR -901 INSTEAD OF -955
IT40274 TRAP IN FUNCTION SQLRA_GET_VAR WITH STMT_CONC SET TO COMM_LIT
IT40270 WRONG DEFAULT VALUE FOR CHAR or GRAPHIC COLUMN IN AN EBCDIC TABLE WHEN DEFAULT VALUE IS NOT EXPLICITLY SPECIFIED
IT40261 FEDERATION: COLUMN LENGTH AUTO VARIATION (COLUMN_LENGTH_AUTO_VARIATION) CANNOT BE DISABLED WHEN TARGET DATABASE IS ORCALE
IT40256 A PREVIOUS SETTING OF CURRENT PACKAGESET MAY BE REUSED WHEN EXECUTING FENCED STORED PROCEDURES WHEN KEEPFENCED IS SET TO YES RES
IT40253 DB2IUPDT RETURNS DBI1084E WHEN TRYING TO CREATE THE FENCED INFO FILE
IT40251 RUNNING BIG SQL RETURN ERROR -901 INSTEAD OF -955
IT40238 INSTANCE MAY CRASH DURING QUERY COMPILATION
IT40228 OPTIMIZER MISS THE CHECK FOR THE MINIMUM ROW WIDTH MAY LEAD TO MEMORY OVERWRITES OR WRONG RESULTS
IT40226 HANG CAN OCCUR WITH INTRA_PARALLELISM ENABLED WHEN INDEX GETS CREATED
IT40220 SECURITY: IBM DB2 IS VULNERABLE TO UNAUTHORIZED ACCESS (CVE-2022-22390)
IT40219 SECURITY: IBM DB2 IS VULNERABLE TO UNAUTHORIZED ACCESS (CVE-2022-22390)
IT40218 SECURITY: IBM DB2 IS VULNERABLE TO UNAUTHORIZED ACCESS (CVE-2022-22390)
IT40217 SECURITY: IBM DB2 IS VULNERABLE TO UNAUTHORIZED ACCESS (CVE-2022-22390)
IT40213 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE (CVE-2022-22389)
IT40212 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE (CVE-2022-22389)
IT40211 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE (CVE-2022-22389)
IT40210 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE (CVE-2022-22389)
IT40203 A LARGE INCREASE IN BUFFER POOL SIZE CAN LEAD TO SUBOPTIMAL PERFORMANCE
IT40198 HANG CAN OCCUR WITH INTRA_PARALLELISM ENABLED WHEN INDEX GETS CREATED
IT40161 REMOTE STATEMENT HAS WRONG ORDER BY COLUMN SINCE V11.1
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
IT40143 DB2 DOES NOT CORRECTLY REPORT HARDWARE CRYPTOGRAPHIC CAPABILITIES ON POWER PLATFORMS
IT40122 "FODC PANIC DUE TO STALE POINTER IN SQLEUCBLASTDIAGPOOL"
IT40092 DB2 SERVER TERMINATES ABNORMALLY OR RETURNS -901 WHILE PROCESSING JSON DATA
IT40091 DB2CKBKP FAILS TO VALIDATE REMOTE BACKUP
IT40090 ERRORS UNDER UNDER /VAR/LOG/PACEMAKER
IT40089 DB2CM -DUMP GENERATING ERRORS
IT40088 DB2CM -LIST ERROR COULD NOT GET PACEMAKERE VERSION - 679
IT40083 WRONG RESULT IS POSSIBLE IN COLUMNAR QUERY WITH REAL, FLOAT, OR DOUBLE COLUMNS AND RANGE PREDICATES WITH NEGATIVE VALUES
IT40080 INSERT STATEMENTS WITH USER-DEFINED SQL FUNCTIONS AND VALUES TABLE FUNCTIONS MIGHT SHOW PERFORMANCE ISSUES.
IT40070 CAPTURE ADDITIONAL DIAGNOSTIC INFORMATION IN BLU MEMORY MANAGEMENT
IT40066 DECREASE DEFAULT MAX NUMBER OF THREAD TO 1023 INSTEAD OF 1024 ONAIX
IT40065 DECREASE DEFAULT MAX NUMBER OF THREAD TO 1023 INSTEAD OF 1024 ONAIX
IT40064 POSSIBLE WRONG RESULT WHEN PREDICATE INCLUDES CAST OF DBCLOB TO GRAPHIC OR VARGRAPHIC
IT40063 DGTT MAY FAIL WITH SQL0289N WHEN UNDERLYING TEMP TABLE SPACE DEFINED IN LARGE FILESYSTEM
IT40061 BACKUP WITH DB2_RESOURCE_POLICY ENABLED MAY IMPACT SYSTEM PERFORMANCE MORE THAN WHEN DISABLED
IT40051 DB2 SERVER COULD TERMINATES ABNORMALLY OR GET -301 WHEN RUNNING A PROCEDURE.
IT40049 THE MAXIMUM NUMBER OF FCM SESSIONS IS NOT SET PROPERLY ON AIX
IT40046 Frequent activation/deactivation can cause file handle leak and increase in memory on db2 server
IT40043 MEMORY LEAK IN COLUMNAR PAGE COMPRESSION CODE
IT40040 SPURIOUS ERROR MESSAGE IN DB2DIAG.LOG WHEN RUNNING DB2ADVIS
IT40028 XA INDOUBT TRANSACTIONS: AFTER DB2STOP QUIESCE IS RUN
IT40026 TOTAL_CF_CMD_TIME_MICRO RETURNS -1
IT40020 SQL RETURNING WRONG RESULT AFTER REPEATING SAME SELECT STATEMENT
IT40019 DB2 GOT CRASHED WITH SIGINAL #11 AT SQLRILITERALREPLACE()
IT40007 CONFIGURING HADR FOR TLS ON WINDOWS PLATFORM USING MICROSOFT CERTIFICATE STORE FAILS WITH SQL1768N REASON CODE 28
IT40003 DB2 QUERY MAY GENERATE 901 WHEN GROUP BY COLUMNS ARE UNUSED.
IT39993 STRIPTNULLS MODIFIER IN LOAD AND IMPORT COMMANDS TRUNCATE NULLS (0X00) FROM GRAPHIC (FIXED-LENGTH) COLUMN, BUT IT SHOULD NOT
IT39981 LIST ACTIVE DATABASE SHOWED DB NAME , EVEN IF DATABASE WAS DEACTIVATED
IT39980 UNEXPECTED -798 ON SPECIFYING COLUMN VALUE FOR SYS_START AFTER CALL TO SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY WHEN CLIENT RE-R
IT39973 Frequent activation/deactivation can cause file handle leak and increase in memory on db2 server
IT39969 LOAD COMMAND ISSUED FROM 11.5.7 CLIENT TO EARLIER-LEVEL 11.5.X SERVER FAILS WITH SQL0901N ERROR.
IT39957 APPLICATION MAY HANG IN GETFASTWRITERRECORD IF THE INTERNAL POOLFOR EVENT MONITORING IS EXHAUSTED.
IT39956 ABNORMAL TERMINATION OF DATABASE WITH "ERROR DURING LOG PAGE VALIDATION." FROM SQLPGWLP, PROBE:390.
IT39955 ABNORMAL TERMINATION OF DATABASE WITH "ERROR DURING LOG PAGE VALIDATION." FROM SQLPGWLP, PROBE:390.
IT39950 IN RARE JOIN ON COLUMNAR TABLES COULD LOOSE ROWS
IT39945 APPLICATION MAY HANG IN GETFASTWRITERRECORD IF THE INTERNAL POOLFOR EVENT MONITORING IS EXHAUSTED.
IT39938 POSSIBLE MEMORY CORRUPTION WHEN CALLING PD_GET_DIAG_HIST
IT39928 RARE WRONG RESULT IS POSSIBLE FOR QUERIES AGAINST CDE TABLES THAT WERE CREATED WITH EBCDIC CCSID
IT39923 SECURITY: VERSION OF LIBEXPAT USED BY DB2 MAY ALLOW A REMOTE ATTACKER TO EXECUTE ARBITRARY CODE (CVE-2022-23852,CVE-2022-23990)
IT39922 SECURITY: VERSION OF LIBEXPAT USED BY DB2 MAY ALLOW A REMOTE ATTACKER TO EXECUTE ARBITRARY CODE (CVE-2022-23852,CVE-2022-23990)
IT39920 SECURITY: VERSION OF LIBEXPAT USED BY DB2 MAY ALLOW A REMOTE ATTACKER TO EXECUTE ARBITRARY CODE (CVE-2022-23852,CVE-2022-23990)
IT39918 SECURITY: VERSION OF LIBEXPAT USED BY DB2 MAY ALLOW A REMOTE ATTACKER TO EXECUTE ARBITRARY CODE (CVE-2022-23852,CVE-2022-23990)
IT39916 POSSIBLE MEMORY CORRUPTION WHEN CALLING PD_GET_DIAG_HIST
IT39906 POTENTIALLY BAD PERFORMANCE WHEN USING PARAMETER MARKERS IN QUERIES CONTAINING JOINS
IT39905 LONG RUNNING QUERY WITH COMPLEX CASE EXPRESSIONS HANGS AT COMPILE TIME
IT39904 DB2PD -STACK ALL IS NOT WORKING ON WINDOWS
IT39883 POOR PERFORMANCE WHEN FEDERATED TABLE JOINED WITH CDE TABLE
IT39877 DB2START IS FAILED WITH -1677 ERROR WHEN EACH MEMBER HAS A CONFIGURED INSTANCE_MEMORY VALUE AND THERE IS A GLOBAL INSTANCE_MEMOR
IT39873 FLUSH PACKAGE CACHE DYNAMIC FOR EXECUTABLE ID REPORTS SQLP_LCON
IT39872 POOR DB2 QUERY PERFORMANCE WHEN EXISTS SUBQUERIES PART OF OR
IT39870 CRM STATUS COMMAND REPORTS INCORRECT STATUS OF RESOURCES
IT39869 SQLCODE -803, PRODUCES DB2DIAG.LOG MESSAGE: SQLRR_PROCESS_EXECUTE_REQUEST, PROBE:800 MESSAGE
IT39851 RARE DATABASE SHUTDOWN WITH -902 SQLD_PARM "PARAMETER ERROR"
IT39848 DB2UNINS OF DATA SERVER CLIENT REMOVES MCAFEE SHARED REG KEYS
IT39846 HADR LOG SHIPPING MIGHT BE STUCK AFTER DB2 UPDATE ACROSS 11.5.6
IT39844 DB2START FAILS WITH SQLE_SAL_MIXED_TRANSPORTS_ERROR WHEN ONE OF THE RDMA ADAPTERS ON THE HOST IS IN UNKNOWN STATE
IT39807 INCORRECT RESULTS MIGHT BE RETURN FOR COUNT/COUNT_BIG OVER() SCALAR AGGREGATE FUNCTION UNDER AN OUTER JOIN
IT39800 DB2 SERVER COULD TERMINATES ABNORMALLY OR GET -301 WHEN RUNNING A PROCEDURE.
IT39798 THE CURRENT/DELAYED VALUE FOR "CLUSTER MANAGER" IN DBM CFG IS NOT UPDATED PROPERLY AFTER DB2HAICU [-DISABLE]
IT39797 INACCURATE ERROR MESSAGE FOR FIXPACK INSTALL WITH NO INSTANCE ONDB2 Windows Install
IT39796 DB2 UPGRADE DB MAY TRAP or FAIL WITH SQL1704N IF THE DB CONTAINSA TYPE WITH (SCHEMA+NAME) LENGTH OVER 56 CHARACTERS
IT39792 CONCURRENT INSERT INTO A COLUMNAR TABLE WITH ENFORCED PRIMARY KEY MAY DEADLOCK
IT39783 CIE00756E IS LOGGED WHILE STARTING TEXT SEARCH
IT39781 DIA8532C IS SOMETIMES LOGGED IN DB2DIAG.LOG WHEN ACTIVATING DB VIA DB2V115_START.KSH
IT39769 DB2 MIGHT REPORT AN ERROR FOR COMPLEX UNION REFERENCED IN COMMONTABLE EXPRESSIONS
IT39766 DB2PREREQCHECK WITH THE -HL OPTION FAILS IF THE CONTENTS OF THE HOSTS FILE ARE NOT CORRECT
IT39765 A RARE WRONG RESULT IS POSSIBLE AGAINST COLUMNAR TABLES WITH A PSCANCOL PLAN AND MULTIPLE HSJNs ON THE SAME TABLE COLUMNS
IT39763 MORE ROBUST SIGNAL HANDLING ADDED TO COMMAND LINE OPERATIONS.
IT39762 MORE ROBUST SIGNAL HANDLING ADDED TO COMMAND LINE OPERATIONS.
IT39760 ON AIX WHEN A SCRIPT NEEDS TO EXECUTE DB2PROFILE IN A LOOP, LIBPATH HAS MULTIPLE REFERENCES TO GSKIT
IT39759 ON AIX WHEN A SCRIPT NEEDS TO EXECUTE DB2PROFILE IN A LOOP, LIBPATH HAS MULTIPLE REFERENCES TO GSKIT
IT39754 LOCKING EVENT MONITOR "DROPPED RECORD" EVENT LEADS TO THE FLOOD OF DB2DIAG.LOG WARNING MESSAGES
IT39752 DB2ICRT & DB2IUPDT MAKE USE OF THE ~/DB2LOG DIRECTORY AND MAY OVERWRITE IT
IT39750 ALTERS TO LBAC SECURITY POLICIES ARE NOT INCLUDED IN THE DB2LOOKOUTPUT
IT39748 WHEN CPU SUPPORTS AVX2 A RARE TRAP IN PACKEDBANKSIMD IS POSSIBLE
IT39747 AVOID DB2 CRASH IF INSTANCE RUNS OUT OF FILE HANDLES.
IT39741 REGISTRY KEY HKLMSOFTWAREODBCODBC.INI IS REMOVED AFTER UNINSTALLING DB2 PRODUCT
IT39731 DB2PREREQCHECK FAILS WITH REQUIRED MINIMUM "UDAPL" LEVEL: "7.2.4.0", AND "ACTUAL VERSION: "7.2.5.100""
IT39719 DATA SERVER DRIVER LIBDB2.SO.1 MISSING SYMBOLS ON LINUX X86_64
IT39703 BUFFER POOL EVENT RECORDER LEAKS MEMORY IF CRASH RECOVERY FAILS
IT39702 DB2 MAY COPY SELECTIVITY WHEN A SELECTIVITY CLAUSE IS USED ON A PREDICATE THAT'S COLUMN EQUIVALENT (C1=C2 AND C1=C3)
IT39673 TRAP/901/HANG WHEN DB2 QUERY HAS CORRELATED IN PREDICATE IN SELECT.
IT39655 $ACTION LEAK OUT FROM `DB2PROFILE`
IT39643 GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSINGCLAUSE MAY RETURN -901
IT39628 JDBC ERROR "UNRECOGNIZED JDBC TYPE: 2011 ERRORCODE=-4228, SQLSTATE=NULL " WITH JDBC
IT39623 FEDERATION SELECT DISTINCT, LIMIT, AND CURRENT DATE NOT PUSHED DOWN CAUSES QUERY SLOWLY
IT39621 POSSIBLE PERFORMANCE PROBLEMS FOR INSERT STATEMENTS WITH COMMON-TABLE EXPRESSIONS
IT39613 SIGNAL #11 IN XMLRNSERIALIZER::PACKSTATE
IT39593 DB2_REDUCED_OPTIMIZATION OPTIONS MDC_COST_OVERFLOW AND COL_IXSCAN MAY RESULT IN SUB-OPTIMAL ACCESS PLAN
IT39589 DB2INST RESOURCE AGENT MAY CAUSE HANG DURING META-DATA ACTION INPACEMAKER HADR
IT39587 SQL0955C IN QUERIES WITH AGG DISTINCT DONE IN COLUMNAR LOGIC : HANDLEINSUFFICIENTMEMORYFORAGGDISTINCT
IT39586 THE OPTIMIZER MIGHT FAVOUR A NON-OPTIMAL PLAN WITH REGISTRY VARIABLE DB2_EXTENDED_OPTIMIZATION=NLJN_OFLOW
IT39584 SECURITY: A VULNERABILITY IN 2.17.0 APACHE LOG4J AFFECTS DB2 (CVE-2021-44832)
IT39580 DB2 QUERY GENERATES 901 WHEN MULTIPLE CORRELATIONS IN SCALAR SUBQUERY.
IT39560 QUERY SUCCCEED BUT GET ERROR MESSAGE WINNING PLAN STILL NEEDS GLUE IN DB2DIAG.LOG
IT39559 DB2 ENGINE MIGHT HANG WHEN UPDATING STATISTICS FOR INDEXES ON XML COLUMNS
IT39550 DB2 SERVER MAY TERMINATE ABNORMALLY ISSUING ILLEGAL SQL STATEMENT
IT39544 GRAPHIC AND CHARACTER CONVERTS WRONG WHEN CODEPAGES OF FEDEDERATION DB AND REMOTE DB ARE DIFFERENT
IT39532 DB2 PURESCALE: MEMBER MAY FODC_PANIC DUE TO CORRUPTED LATCH WITHIN DB2CFCONNPOOLMGR EDU
IT39531 DB2CKUPGRADE UTILITY FAILS WITH CLI0125E FUNCTION SEQUENCE ERROR.
IT39524 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN USING SUBSTR
IT39520 MERGE STATEMENT REFERENCING MATERIALIZED QUERY TABLES (MQTS) MAYFAIL WITH SQL0407N
IT39519 SELECT WITH GRANT FAILED TO GRANT FOR A VIEW WITH VALUES.
IT39517 THE DB2PD FUNCTION GETS VALUE FOR CF_GBP_SZ FROM THE DB CONFIG STRUCTURE IN MEMORY WHICH IS INCORRECT.
IT39516 DB2 ALTER TABLE QUERY MAY FAIL WITH SQL0109N ERROR
IT39502 PRIMARY CF CRASH DUE TO ASSERT DURING MEMBER CRASH RECOVERY
IT39500 UNNECESSARY SQLO_BAD_GROUP LOGGING INTO DB2DIAG.LOG
IT39499 UNNECESSARY SQLO_BAD_GROUP LOGGING INTO DB2DIAG.LOG
IT39487 EXTERNAL TABLE FIXED FORMAT LOAD OF [VAR]BINARY[N], BLOB[N] FAILING
IT39485 MON_GET_LOCKS FAILS IN SINGLE MEMBER WITH "NO MEMORY AVAILABLE".
IT39482 DB2 SERVER MAY TERMINATE ABNORMALLY ISSUING ILLEGAL SQL STATEMENT
IT39477 DB2 MIGHT UPDATE KERNEL.MSGMNI AND KERNEL.SHMMNI TO 32K IN CASE IPCMNI_EXTEND IS DISABLED.
IT39474 SECURITY: Multiple vulnerabilities in Apache Log4j affect some features of IBM® Db2® (CVE-2021-45046, CVE-2021-45105)
IT39471 DB2V115_START.KSH: FAILS TO FIND SERVICE PORT ON NON-ENGLISH LOCALE
IT39461 TRIM AND STRIP SCALAR FUNCTION RESOLUTION IGNORES CURRENT PATH
IT39446 PKCS11 DRIVER MAY RETURN UNEXPECTED ERROR CODES WHEN HSM SESSIONIS CLOSED
IT39404 CLIENT CONNECTIONS SLOW TO DATABASE SERVER
IT39402 CLIENT CONNECTIONS SLOW TO DATABASE SERVER
IT39390 SECURITY: APACHE LOG4J REMOTE CODE EXECUTION - LOG4SHELL (CVE-2021-44228, CVE-2021-4104)
IT39389 SECURITY: APACHE LOG4J REMOTE CODE EXECUTION - LOG4SHELL (CVE-2021-44228, CVE-2021-4104)
IT39387 SECURITY: APACHE LOG4J REMOTE CODE EXECUTION - LOG4SHELL (CVE-2021-44228, CVE-2021-4104)
IT39374 DB2START IS FAILED WITH -1677 ERROR WHEN EACH MEMBER HAS A CONFIGURED INSTANCE_MEMORY VALUE AND THERE IS A GLOBAL INSTANCE_MEMOR
IT39359 Db2 hangs with many EDUs waiting on logTailHeartBeatLatch
IT39354 SPECIFIC MQT DEFINITION MAY LEAD TO DB2 ABEND WITH SIG11
IT39352 XML INDEXES NOT USED IN DB2 11.5 EXPLAIN PLAN
IT39347 ERROR ADM7009E AFTER UPGRADING TO 11.5
IT39344 DB2 QUERY MAY GENERATE 901 WHEN SCALAR SUBQUERY HAS DISTINCT ANDFETHC FIRST 1 ROW.
IT39337 INSERT statement performs poorly when source fullselect includesUNION ALL and fetch-clause
IT39336 TRAP/901/HANG WHEN DB2 QUERY HAS CORRELATED IN PREDICATE IN SELECT.
IT39334 SQL0952N ERROR SHOULD BE RAISED INSTEAD OF PRODUCING FODC_APPERRAND SQL0901N
IT39331 STATS_ROWS_MODIFIES REPORTS 4294967295 FROM MON_GET_TABLE AND ADMIN_GET_TAB_INFO
IT39321 SQL0818N CAN OCCUR AFTER A ROLLED BACK REVALIDATION
IT39320 STALE VALUE OF LOG_EXTRACTION_DISK_SPACE_USED_TOTAL WITH ADVANCED LOG SPACE MANAGEMENT ENABLED
IT39319 SQL0818N CAN OCCUR AFTER A ROLLED BACK REVALIDATION
IT39306 THE OPTIMIZER MIGHT FAVOUR A NON-OPTIMAL PLAN WITH REGISTRY VARIABLE DB2_EXTENDED_OPTIMIZATION=NLJN_OFLOW
IT39298 HADR STANDBY ENTERS AN INFINITE LOOP BETWEEN READ FROM MEMORY AND READ FROM DISK
IT39288 LOGS DO NOT GET ARCHIVED WHEN CHANGE TO CIRCULAR LOGGING DOES NOT TAKE EFFECT
IT39287 HADR STANDBY MAY TAKE LONGER THAN NORMAL TO REACH PEER STATE ON ACTIVATION
IT39286 TOO MANY LOG FILES IN ACTIVE PATH ON HADR STANDBY
IT39279 Db2 hangs with many EDUs waiting on logTailHeartBeatLatch
IT39275 A CLI LOAD INTO A COLUMN ORGANIZED TABLE MIGHT CRASH WITH A SPECIFIC STACK
IT39274 DB2 MIGHT PRODUCE A SQL0901N, EXECUTING QUERIES WITH UNION ALL
IT39269 NOSQLJSON SERIALIZER CRASHES WHEN NULL IS THE VALUE FOR JSON KEY
IT39268 JSON WIRE LISTENER FAILS WHEN REGEX IS USED IN FIND COMMAND
IT39267 NOSQL JAVA DRIVER THROWS RUNTIMEEXCEPTION FOR $SAMPLE IN AGGREGATE PIPELINE
IT39266 WIRE LISTENER DO NOT HONOR THE LIMIT OPTION USED WITH FIND COMMAND
IT39265 WIRE LISTENER FAILS TO ACCEPT NEW COMMAND POST EXCEPTION
IT39264 ROBO3T MONGODB TOOL THROWS ERROR POST UPDATE OR DELETE OF A JSONDOC IN A COLLECTION
IT39263 NOSQLBOOSTER TOOL FAILS TO CONNECT TO WIRE LISTENER DUE TO MISSING SUPPORT FOR GETFREEMONITORINGSTATUS COMMAND
IT39262 WIRELISTENER THROWS EXCEPTION WHEN AGGREGATE PIPELINE CONTAINS $INDEXSTATS
IT39261 IMPROVE ERROR MESSAGE WHEN PUTTING CLUSTER IN TO MAINTENANCE MODE WITHOUT DB2CLUSTER -ALL OPTION.
IT39257 TRANSFER OWNERSHIP OF A COMPILED TRIGGER IS MISSING INVALIDATION.
IT39256 Security: Client encryption settings are not preserved on a failover/reconnect resulting in a data exposure. (CVE-2021-39002)
IT39255 Security: Client encryption settings are not preserved on a failover/reconnect resulting in a data exposure. (CVE-2021-39002)
IT39254 Security: Client encryption settings are not preserved on a failover/reconnect resulting in a data exposure. (CVE-2021-39002)
IT39252 DB2HAICU -REMOTE_ENABLE MAY FAIL WHEN REMOTE HOST USES NLS MESSAGES
IT39249 UPDATE/DELETE STATEMENTS WITH THE TARGET TABLE REFERENCED IN THESUB-SELECT MIGHT CAUSE PROBLEMS.
IT39240 A FODC TRAP MAY OCCUR WHEN DIA5000C MESSAGE IS ISSUED DUE TO A PARSING ERROR.
IT39233 DATABASE CREATE FAILS WITH SQL2049N RC=2 WHEN DB2_DATABASE_CF_MEMORY BEING SET TO 0
IT39221 A CLI LOAD INTO A COLUMN ORGANIZED TABLE MIGHT CRASH WITH A SPECIFIC STACK
IT39220 STATIC PACKAGES WITH COLUMNAR LOGIC FROM LEVELS OLDER THEN v11.1FP3 COULD CAUSE MEMORY OVERWRITES
IT39218 DB2 QUERY MAY GENERATE SQLCODE -901 WHEN LEFT/RIGHT OUTER JOIN PREDICATE ON EXPRESSION.
IT39215 UPDATE GSKIT TO 8.0.55.26
IT39205 WHEN LISTAGG IS DONE ON CODEUNITS32 COLUMN AND LITERAL IN DPF INRARE PLANS EXTRA SPACES COULD BE GENERATED
IT39201 INSTANCE CRASHES RUNNING ALTER PACKAGE PACKAGE-NAME OPTIMIZATIONPROFILE OPTIMIZATION-PROFILE-NAME
IT39194 INITIAL CONNECTION ERRORS LIKE -4499 ARE NOT COLLECTED IN DIAGNOSTIC DATA THROUGH DB2.JCC.DIAGLEVELEXCEPTIONCODE SETTING
IT39185 OPTIMIZER USES QUANTILE STATS FOR UNIQUE COLUMNS TO COMPUTE THE EQUALITY PREDICATE FILTER FACTOR WHICH LEADS TO OVER-ESTIMATION
IT39184 IF MONHEAP IS EXHAUSTED SQL STATEMENTS MAY RECEIVE SQL0973N FOR MON_HEAP_SZ
IT39175 FLUSH BUFFERPOOL IS NOT SUPPORTED ON STANDBY WITH LOG_DDL_STMTS=YES
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
IT39146 EXTREME FAST DB2DIAG.LOG GROWTH CAUSED BY WARNING MESSAGE IN RUNTIME INTERPRETER SQLRISRT
IT39145 INSERT INTO A LOB MAY FAIL WITH ERROR -30020
IT39142 "PRUNE LOGFILE PRIOR TO" command MAY RESULT IN UNEXPECTED SQLP_EXT_INVALID "INVALID EXTENT HEADER (FILENUMBER OR SIGNATURE IDS).
IT39138 QUERY COULD TRAP WITH -901 WHEN THERE?S CASE PREDICATE IN THE HAVING CLAUSE
IT39136 NON-PUSHDOWNABLE HASH JOIN ELIGIBLE PREDICATES INVOLVING NICKNAMES MAY BE USED SUB-OPTIMALLY
IT39128 CRASH WHILE CREATING ODBC DATA SOURCES FILE DSN ON WINDOWS PLATFORM USING DB2 ODBC CLI DRIVER
IT39114 ADMIN_MOVE_TABLE ESTIMATE IS INCOMPATIBLE WITH BLOCKNONLOGGED
IT39109 BCD DECIMAL USING 0XF FOR SIGN NIBBLE MIGHT GET CONVERTED TO NEGATIVE VALUE
IT39092 UNCATALOG ODBC DOESN'T REMOVE ENTRY FROM DB2CLI.INI
IT39085 HIGH "SQLO_LT_SQLB_BP_AREA_INFO_PAGEAREA__CLOCKLATCH" CONTENTIONS ON DB2 PURESCALE
IT39081 A RARE TRAP WORKING WITH COLUMNAR TABLES IN A VERY SPECIFIC STACK
IT39080 MINBUFFLSN DOES NOT UPDATE FOR A LONG PERIOD OF TIME DURING RECOVERY
IT39079 DB2 SERVER TERMINATES ABNORMALLY WHEN CREATE TABLES.
IT39058 CLPPLUS FAILS TO FLOW COMMIT FOR WARNING CASE SCENARIOS FROM STACOMMAND WHEN RUN AS A SCRIPT
IT39057 INITIAL CONNECTION ERRORS LIKE -4499 ARE NOT COLLECTED IN DIAGNOSTIC DATA THROUGH DB2.JCC.DIAGLEVELEXCEPTIONCODE SETTING
IT39056 IMPROPER SPECIAL REGISTER CURRENT SCHEMA CAUSING SQLSYNTAXERROREXCEPTION
IT39055 FEDERATION CREATE SERVER TYPE OPTIMIZATION FOR ODBC WRAPPER
IT39053 DB2 FEDERATION CAN NOT BE FORCED OFF DURING ABNORMAL SHUTDOWN OF MSSQL SOURCE SERVER
IT39051 HANG WAITING FOR SQLO_LT_SQLI_IDXCB__IDXTREELATCH WITH NO HOLDERS after failed REORG INDEX(ES) .. RECLAIM EXTENTS
IT39050 BUFFER POOL PAGE PINCOUNT LEAKED DURING PAGE P-LOCK ACQUISITION
IT39049 AFTER HADR UPGRADE AND THEN TAKEOVER FROM STANDBY, LOG WRITES ONNEW PRIMARY CAN CAUSE FORCEDBSHUTDOWN.
IT39048 HANG WAITING FOR SQLO_LT_SQLI_IDXCB__IDXTREELATCH WITH NO HOLDERS after failed REORG INDEX(ES) .. RECLAIM EXTENTS
IT38996 INSERTING DECIMAL MINUS ZERO INTO COLUMN ORGANIZED TABLE LEADS TO WRONG RESULT ON POWERPC
IT38984 SQL0901N ERROR WHEN FETCH-CLAUSE OR OFFSET-CLAUSE INCLUDES A SCALAR FULLSELECT.
IT38982 FODC_WLM_QUEUE GENERATION CAN TAKE TOO LONG
IT38969 WRONG STRING COMPARISON FOR THAI NLSCHAR DATABASE COULD HAPPEN
IT38967 OPTGUIDELINES ARE NOT SUPPORTED FOR SET INTEGRITY STATEMENTS.
IT38961 HANG WAITING FOR LATCHES INSERTRANGE__MTABLEWRITERLATCH AND INSERTRANGE__MCONCURRENTINSERTLATCH
IT38958 POSSIBLE SEGMENTATION FAULT ON DB2AUDIT EXTRACT COMMAND
IT38955 WRONG RESULTS FROM SELECT COUNT QUERY ON "ORGANIZE BY COLUMN" TABLE
IT38952 XML NODE MANAGER THROWS -901 ERROR WHILE RUNNING MANUAL RUNSTATSON XML TABLE.
IT38951 DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN
IT38942 LOGS DO NOT GET ARCHIVED WHEN CHANGE TO CIRCULAR LOGGING DOES NOT TAKE EFFECT
IT38941 RSCT TIEBREAKER BEEN WRONGLY SET AS THE SAME DISK WITH GPFS
IT38927 FEDERATION OVERLOADED PROCEDURE FAIL WITH SQL0901 RC = -2144272209=SQLNN_E_BADNEWS
IT38916 POSSIBLE SEGMENTATION FAULT ON DB2AUDIT EXTRACT COMMAND
IT38900 AFTER REACTIVATING A CRASHED STANDBY DATABASE, SOME READ ON STANDBY OPERATIONS MIGHT GET BACK SQL0901
IT38893 ADMIN_MOVE_TABLE WITH COPY_STATS MIGHT INVOKE LONG RUNNING RUNSTATS
IT38887 ENHANCEMENT OF THE PD MESSAGE WHEN REACH THE LIMIT CONFIGURED BYDB2_MAX_THREADS_PER_FMP
IT38872 ABNORMAL TERMINATION OF QUERY WITH COMMON TABLE EXPRESSION
IT38870 RARE WRONG RESULT IN CDE INDEX CASE WHEN WITH UR IS USED
IT38866 INCORRECT LICENSE CHECK FOR INFORMIX DB WITH TRUSTED CONTEXT RELATED VERIFICATION
IT38861 RELAX OF DIAGLEVEL OF SQLRR_RDS_COMMON_POST, PROBE:870
IT38859 DB2MOVE COPY FAILS WITH "INVALID OBJECT TYPE SPECIFIED"
IT38833 DB2 QUERY PLAN DOES NOT CHOOSE INDEX WHEN IN PREDICATE HAS PARAMETER MARKER.
IT38832 DB2 QUERY MAY PERFORM POORLY WHEN NULL PRODUCING SIDE OF OUTER JOIN IS ON BASE TABLE.
IT38829 DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONSAND SCALAR AGGREGATIONS
IT38827 ADM6093W DURING AN EXTENDING CONTAINER FILE ON WINDOWS CAUSE A DB2 CRASH
IT38822 IBM SPECTRUM PROTECT SNAPSHOT CREATED COPY MAY BECOME INVALID DUE TO SAN VOLUME CONTROLLER HU02427 ISSUE
IT38817 Security: Client encryption settings are not preserved on a failover/reconnect resulting in a data exposure. (CVE-2021-39002)
IT38816 Security: Client encryption settings are not preserved on a failover/reconnect resulting in a data exposure. (CVE-2021-39002)
IT38810 SYSTEM.ARGUMENTEXCEPTION OCCURS WHILE PERFORMING DML OPERATION ON LARGE BATCH STATEMENTS VIA EF CORE
IT38801 DB2 SERVER TERMINATES ABNORMALLY DURING CREATE/DECLARE TABLE

© Icons by Mark James www.famfamfam.com