invispix 10x10

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
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
IT39589 DB2INST RESOURCE AGENT MAY CAUSE HANG DURING META-DATA ACTION INPACEMAKER HADR
IT39586 THE OPTIMIZER MIGHT FAVOUR A NON-OPTIMAL PLAN WITH REGISTRY VARIABLE DB2_EXTENDED_OPTIMIZATION=NLJN_OFLOW
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
IT39520 MERGE STATEMENT REFERENCING MATERIALIZED QUERY TABLES (MQTS) MAYFAIL WITH SQL0407N
IT39519 SELECT WITH GRANT FAILED TO GRANT FOR A VIEW WITH VALUES.
IT39516 DB2 ALTER TABLE QUERY MAY FAIL WITH SQL0109N ERROR
IT39500 UNNECESSARY SQLO_BAD_GROUP LOGGING INTO DB2DIAG.LOG
IT39499 UNNECESSARY SQLO_BAD_GROUP LOGGING INTO DB2DIAG.LOG
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.
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
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
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 WHEN ENCOUNTERING A LOG FILE WITH CORRUPTED XHD
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
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
IT39218 DB2 QUERY MAY GENERATE SQLCODE -901 WHEN LEFT/RIGHT OUTER JOIN PREDICATE ON EXPRESSION.
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
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
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
IT38872 ABNORMAL TERMINATION OF QUERY WITH COMMON TABLE EXPRESSION
IT38866 INCORRECT LICENSE CHECK FOR INFORMIX DB WITH TRUSTED CONTEXT RELATED VERIFICATION
IT38861 RELAX OF DIAGLEVEL OF SQLRR_RDS_COMMON_POST, PROBE:870
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
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
IT38800 IN CERTAIN SITUATIONS, THE SSL FUNCTION GSK_SECURE_SOC_PEEK MAY FAIL WITH THE RETURN CODE "5" IN SQLCCSSLSOCKETPEEK
IT38794 DB2 DOES NOT DETECT SMT ON LINUX ON Z SYSTEMS
IT38790 THE ADMIN_MOVE_TABLE PROCEDURE MAY STUCK IN CANCEL PHASE.
IT38785 SQL STATEMENTS WITH MANY LIKE PREDICATES COULD RUN SLOWER ON V10.5 FP7 AND LATER
IT38755 DB2PREREQCHECK RETURNS SYNTAX ERRORS WHEN YOU DON'T USE OPTIONS
IT38734 OBJECTTYPE FIELD FROM OBJECTOWNERS IS NULL FOR CERTAIN TABLESPACES
IT38731 CALLING CLR STORED PROCEDURE ON WINDOWS COULD RESULT IN SQL4301NRC=6
IT38716 IN PURESCALE, POTENTIAL DATA CORRUPTION IF NETWORKING FAILS BETWEEN MEMBERS
IT38710 RARE WRONG RESULT IN CDE INDEX CASE WHEN WITH UR IS USED
IT38691 DECIMAL PRECISION DIFFERENCE IN JDBC WITH ORA & NON-ORA SETTING
IT38686 Db2 write performance on Linux might be affected due to file system journal waits
IT38678 DECIMAL PRECISION DIFFERENCE IN JDBC WITH ORA & NON-ORA SETTING
IT38669 MON_GET_AUTO_MAINT_QUEUE() MAY FAIL WITH SQL0493N
IT38665 SNAPSHOT MONITOR TRAPPED IN FUNCTION SQLPLGETLOCKWAITINFO()
IT38660 MEMORY CORRUPTION DETECTED IF CONNECTION CONCENTRATOR IS ENABLED
IT38659 EXECUTING ADMIN_MOVE_TABLE ON A TABLE WITH SOME KINDS OF STATEMENTS > 64KB SIZE, WILL RETURNED SQL0104N OR SQL1224N
IT38655 FEDERATED OPERATIONS MIGHT LEAD TO INSTANCE CRASH WHEN HEALTH MONITOR IS TURNED ON
IT38637 DB2CLUSTER -LIST -ALERT SHOWS A FALSE FILESYSTEM REPLICATION RELATED ALERT
IT38629 DB2CLEANCAT CANNOT REMOVE SYNOPSIS TABLE ORPHAN ENTRY IN SYSVIEWDEP
IT38627 ADMIN_MOVE_TABLE COPY_STATS MIGHT FAIL WITH SQL0010N IF LOW2KEY/HIGH2KEY CONTAINING 0 BYTE
IT38624 ENGINE CRASH IN XMLRNNODEMGR::FETCHTEMPNODE()
IT38619 SQL0901N - UNEXPECTED ERROR AT CDE_INTERFACE.C:2561
IT38609 Reorg reclaim throws -901 as internal query compilation for synopsis table was interrupted
IT38599 DB2 QUERY MAY GENERATE 901 WHEN JOIN ON SAME TABLE AND SELECT DISTINCT PRESENT
IT38590 INGEST TO PARTITIONED DATABASE DOES NOT WORK OVER SSL
IT38584 IF MONHEAP IS EXHAUSTED SQL STATEMENTS MAY RECEIVE SQL0973N FOR MON_HEAP_SZ
IT38576 DB2DIAG.LOG MESSAGE WITH ERROR "FILE NOT FOUND" IN "SQLPGOPENLOGEXTENTANDUNCOMPRESSFORLFR, PROBE:4075" MAY BE MISLEADING
IT38564 ADMIN_MOVE_TABLE(REPORT) OPERATION FAILS WITH -911 LOCK TIMEOUT DURING ADMIN_MOVE_TABLE(COPY_USE_LOAD)
IT38563 DATABASE CRASH WHEN ARRAY TYPE VARIABLE USED IN "DGTT AS (SELECT..) WITH DATA" SQL STATEMENT
IT38561 SECURITY: INDIRECT READ ACCESS TO A TABLE THAT THE USER IS NOT AUTHORIZED TO SELECT FROM (CVE-2021-38931)
IT38560 INGEST RESULT OUTPUT WRONGLY SHOWS "NUMBER OF ROWS INSERTED = 0"INSTEAD OF "NUMBER OF ROWS UPDATED / DELETED = "
IT38558 SECURITY: INDIRECT READ ACCESS TO A TABLE THAT THE USER IS NOT AUTHORIZED TO SELECT FROM (CVE-2021-38931)
IT38555 DEADLOCK BETWEEN MANUAL RUNSTATS AND AUTO REORG RECLAIM ISSUED BY AUTO MAINTENANCE
IT38549 WRONG RESULT WHEN SUBSELECT WITH SCALAR AGGREGATE REFERENCED MULTIPLE TIMES
IT38541 INSERT INTO XML COLUMN OF A DRDA NICKNAME MAY CAUSE A SIGNAL 11 TRAP
IT38536 WRONG STRING COMPARISON FOR THAI NLSCHAR DATABASE COULD HAPPEN
IT38534 DB2ICRT CREATES / CHANGES .PROFILE OF THE INSTANCE OWNER TO HAVEA GROUP OF THE FENCED USER SPECIFIED WITH IT.
IT38533 A CLIENT APPLICATION TRAPPED INSIDE A CALL TO DB2GRECOVER()
IT38519 ADMIN_MOVE_TABLE MIGHT FAIL IF TABLE HAS STATISTICS PROFILE CONTAINING COLUMN NAMES WITH SINGLE QUOTES
IT38518 DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES WITH MULTIPLE OUTER JOINS
IT38517 MSSQL_SERVER::GET_ERROR_INFO ERROR IN MS-SQL FEDERATION CONFIGURATION
IT38511 ROLLFORWARD OF LOAD COPY IMAGE FROM OBJECT STORAGE CANNOT BE RECOVERED DUE TO PATH TRUNCATION
IT38508 EXCESSIVE QUERY COMPILATION TIME WITH A VERY LONG SELECT DISTINCT COLUMN LIST AND VERY MANY COLUMN GROUPS
IT38506 DB2READLOG API FAILS TO RETRIEVE LOG FILE WITH SQL2038 AND GENERATES FODC DUMP.
IT38504 ONLINE BACKUP MAY FAIL WHILE PROCESSING TRANSACTION LOG FILE - BAD PAGELSO FOUND FOR LOG FILE
IT38496 DB2ICRT CREATES / CHANGES .PROFILE OF THE INSTANCE OWNER TO HAVEA GROUP OF THE FENCED USER SPECIFIED WITH IT.
IT38495 DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES WITH MULTIPLE OUTER JOINS
IT38481 PKCS11 DRIVER MAY RETURN UNEXPECTED ERROR CODES WHEN HSM SESSIONIS CLOSED
IT38476 YOU MIGHT SEE LOT OF SQLBPROCESSDSTACK MESSAGES IN DB2DIAG.LOG
IT38472 EXTERNAL TABLE FIXED FORMAT LOAD OF NEGATIVE BIG INTS FAILING
IT38467 SQL1128W REASON CODE 6 MISSING FROM KC and MRI messages
IT38466 SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION (CVE-2021-38926)
IT38465 SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION (CVE-2021-38926)
IT38464 SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION (CVE-2021-38926)
IT38463 SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION (CVE-2021-38926)
IT38461 HADR STANDBY LOG FILES ACCUMULATING IN THE DATABASE LOG PATH.
IT38460 SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION (CVE-2021-38926)
IT38449 POSSIBLE PERFORMANCE ISSUES FOR CORRELATED SCALAR SUB-QUERIES REFERENCED IN THE SELECT LIST
IT38446 WHEN REMOTE DATA SOURCE IS DB2 AND THE TABLE HAS CLOB COLUMN, ITMIGHT CAUSE THE -901 INVALID NICKNAME COLUMN LENGTH ERROR
IT38439 DB2 QUERY MAY ABEND OR RETURN A SQL 901 WHEN USING A CORRELATED COMMON TABLE EXPRESSION
IT38431 DB2ADUTL UPLOAD FAILS TO UPLOAD THE WHOLE RANGE OF LOGS IF ONE OF THE LOGS WAS ALREADY UPLOADED
IT38419 FMM6981E RECEIVED AN ERROR FROM THE ADAPTER: ILLEGAL SVC VDISK STATUS STRING VALUE: DELETING
IT38409 NO WARNING MESSAGE WHEN DMS TABLESPACE CANNOT BE IMMEDIATELY EXTENDED WHILE AN ONLINE BACKUP IS IN PROGRESS
IT38403 INCORRECT RESULT WHEN DB2 QUERY HAS EXISTS SUB QUERY WITH IS NULL PREDICATE
IT38402 DB2 IS FORCED SHUTDOWN WHEN IT ATTEMPTS TO PROCESS XAEND
IT38400 INCORRECT RESULT WHEN DB2 QUERY HAS EXISTS SUB QUERY WITH IS NULL PREDICATE
IT38399 WRONG RESULT WHEN DB2 QUERY HAS CORRELATED EXISTS PREDICATE
IT38391 DB2 QUERY MAY GENERATE INCORRECT RESULT WHEN THE FOLLOWING CONDITIONS ARE MET:
IT38384 DB2 ABENDS WHILE PAGE CLEANER EXECUTING SQLBCLNRGATHERFORHATETHRESH
IT38383 DB2 ABENDS WHILE PAGE CLEANER EXECUTING SQLBCLNRGATHERFORHATETHRESH
IT38379 IN CERTAIN SITUATIONS, A SMALL MEMORY LEAK WILL BE OBSERVED IN SQLE_APPLICATION.C ON A DPF INSTANCE
IT38370 NO WARNING MESSAGE WHEN DMS TABLESPACE CANNOT BE IMMEDIATELY EXTENDED WHILE AN ONLINE BACKUP IS IN PROGRESS
IT38355 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
IT38345 DB2 PREP COMMAND FAILS WITH THE ERROR SQL0318N WHEN THE VALUES CLAUSE CONTAINS THE KEYWORD FOR.
IT38344 SQL0901N ERROR CODE RETURNED WHEN CASTED MEMORY TABLE JOINING ONVARCHAR COLUMNS
IT38343 ENHANCE DB2_CSL_SEARCH_PERCENT TO IMPROVE INSERT PERFORMANCE
IT38313 Memory leak in runtime engine if memory pool is not cached
IT38310 POSSIBLE TRAP (SEGV) WHEN RUNNING A QUERY ON A NICKNAME POINTINGTO A FEDERATED SOURCE AND FEDERATED GOES DOWN.
IT38284 DEADLATCH causing APPLICATION HUNG DOING INSERT/SELECT ON TABLE WITH XML COLUMNS
IT38257 SQL0952N could be retuned for accessing tables having a LOB row.
IT38246 RUNSTATS FAILS DUE TO A DEADLOCK (SQL2310N ERROR "-911" ) ON SYSIBM.SYSCOLGROUPSCOLS WHEN COLLECTING COLUMN GROUP STATISTICS.
IT38241 ALTERNATE SERVER BECOMES PRIMARY SERVER WHEN BOTH PRIMARY AND ALTERNATE SERVERS ARE DOWN DURING DB2 JCC ACR
IT38240 JAVA.LANG.OUTOFMEMORYERROR WITH TIMERLEVELFORQUERYTIMEOUT DEFAULT SETTING
IT38238 MEMORY CORRUPTION WHILE PERSISTING PLAN ACTUAL HASH TABLE TO DISK
IT38233 ADD SUPPORT FOR FIPS MODE OF OPERATION TO LINUXPPC64LE
IT38232 INCORRECT RESULTS MIGHT BE RETURN FOR COUNT/COUNT_BIG OVER() SCALAR AGGREGATE FUNCTION UNDER AN OUTER JOIN
IT38229 LOCKTIMEOUT(VIRTUAL DEADLOCK) OCCURRED ON GLOBALPKGLOCK
IT38217 QUERY COMPILATION FAILS WITH SQLCODE -421 WHEN OLAP SPECIFICATION USED AS ARGUMENT TO INLINED SQL FUNCTION
IT38216 ROWID=? PREDICATE IS SLOW WHEN DB2_DEFERRED_PREPARE_SEMANTICS=YES
IT38215 SELECT-STATEMENT WITH WHERE-CLAUSE, FETCH-CLAUSE AND UPDATE-CLAUSE FAILS WITH SQLCODE -511
IT38214 MERGE STATEMENT RETURNS SQLCODE -206 WITH EMPTY OR WRONG COLUMN NAME
IT38212 SET INTEGRITY FAILS WITH SQLCODE -668, REASON CODE 1 AFTER ADDING NEW GENERATED COLUMN
IT38211 DROP PACKAGE FAILS WITH SQL0553N WHEN "PL/SQL SUPPORT" IS ENABLED
IT38210 DB2 SERVER TERMINATES ABNORMALLY IN RECURSIVE_QGM
IT38209 AS FEDERAION LACK OF CODEPAGE CONVERSION FOR CLOB DATA TYPE IN REMOTE DATA SOURCE, IT WILL CAUSE -901 ERROR "REAL COLUMN LENGTH
IT38201 ENHANCE DB2_CSL_SEARCH_PERCENT TO IMPROVE INSERT PERFORMANCE
IT38200 CASE THEN EXPRESSION WITH INLINED SQL FUNCTION MAY BE EVALUATED BEFORE WHEN CONDITION
IT38199 INCORRECT "TYPE" VALUE IN IMPLICITVALUE COLUMN OF SYSCAT.COLUMNSFOR ROW CHANGE TIMESTAMP, ROW END OR TRANSACTION START ID COLUMN
IT38198 COMPILING A SQL QUERY THAT INCLUDES A SQL UDF WITH OLAP INPUT MAY INCORRECTLY RETURN SQLCODE -206
IT38196 ADD SUPPORT FOR FIPS MODE OF OPERATION TO LINUXPPC64LE
IT38191 COMPILED TRIGGER REVALIDATION FAILS WITH SQL0901 "INVALID COMPILE ENV: CATALOG INDEX KEY VIOLATION"
IT38190 TRAP ON SQLNO_COL_WIDTH_INLINE
IT38189 DB2 MAY NOT REVALIDATE CURSOR VARIABLE IF DEPENDENT OBJECTS ARE NOT FULLY QUALIFIED WITH SCHEMA
IT38187 CONSTANT CURSOR VARIABLE REVALIDATION FAILS WITH SQL0501N ERROR WHEN DEPENDED OBJECTS ARE RECREATED.
IT38186 APPLYING HIGH CAPACITY LICENSE ON TOP OF DB2 STANDARD OEM LICENSE DOES NOT REMOVE THE MEMORY AND CORE LIMITS.
IT38184 INCORRECT PROCESSING OF ROWID IS USED IN A SUBSELECT MAY PRODUCEA -901 WITH ERROR MinMaxPartialEvaluator.cpp : 99
IT38182 ORDER BY COLUMN ALIAS ASC NULLS FIRST FAILS WITH SYNTAX ERROR
IT38180 ADM16504E IS GENERATED IN DB2DIAG.LOG IN PURESCALE AFTER DB2STOPIS RUN
IT38174 INCORRECT RESULT WHEN DB2 QUERY HAS EXISTS SUB QUERY WITH IS NULL PREDICATE
IT38170 GROUP LOOKUP FAILING FOR GROUPS THAT CONTAIN LARGE NUMBER OF USERS
IT38155 TRAP POSSIBLE WHEN COLUMNAR QUERY RUNNING WITH THE DB2 TRACE ENABLED IF "NOT IN" CLAUSE
IT38144 FALSE LOW LOG SPACE WARNINGS IN DB2 V11.5 MOD 6
IT38141 ON HADR STANDBY, DB2 DIAG DIRECTORY MAY FILL UP WITH BIN DUMP FILES WHILE RUNNING LOADS ON HADR PRIMARY
IT38124 REMOTE STORAGE OPERATION FAILS DUE TO LIBCRYPTO LIBRARY NAMES AND PATHS
IT38116 DB2FMTLOG MY ENCOUNTER ERROR "THE DATA POINTER IS NOT CONTAINEDWITHIN THE BUFFER" WHEN FORMATTING SOME LOG RECORDS.
IT38111 SQL0901N MIGHT OCCUR WITH QUERIES CONTAINING CASCADED SELECTS AND THE SAME LOCAL PREDICATES ON THESE SELECTS
IT38108 CONNECT TO A INCORRECTLY CATALOGED DATABASE CAUSED AGENT SPAWNING
IT38107 CONNECT TO A INCORRECTLY CATALOGED DATABASE CAUSED AGENT SPAWNING
IT38093 SQL0952N could be retuned for accessing tables having a LOB row.
IT38087 SEGV AT SQLV_MIXD_BUILD_LIKE_SUBPAT()
IT38081 HIPER: WRONG RESULT WITH MULTIDIMENSIONAL CLUSTERING (MDC) TABLEAND ZIGZAG JOIN (ZZJN)
IT38055 DB2DSDCFGFILL DOES NOT CREATE A DB2DSDRIVER.CFG FILE
IT38046 NNSTAT MIGHT FAIL TO UPDATE NUMERIC COLUMN STATS WITH SQL1227N RC=3 IF VACHAR2 COMPATIVILITY IS ENABLED.
IT38030 A QUERY ON COLUMNAR TABLES MAY RETURN MORE ROWS THAN EXPECTED
IT38027 32-Bit ICCSIG.TXT is missing from DB2 11.5.6.0 Unix (AIX, Linux,etc.) Images
IT38024 FODC_PANIC IN LATCH RELEASECONFLICT() WHEN MAXIMUM NUMBER OF SYSTEM TEMPORARY TABLES IN USE FOR COLUMN-ORGANIZED TABLE WORKLOADS
IT38013 ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL2103N RC=16 if RUNSTATS profile contains NUM_FREQVALUES /NUM_QUANTILES
IT38011 ADMIN_MOVE_TABLE FAILS WITH ERROR WHEN MOVING TABLE WITH USAGE LIST AND SPECIAL CHARACTERS
IT38006 BACKUP FAILS WITH BAD PAGE ERRORS DUE TO MISMATCH BETWEEN THE PHYSICAL SIZE OF THE CONTAINER AND WHAT IS SAVED IN THE SPCS FILES
IT38004 BACKUP USING DYNAMIC TARGET ALLOCATION CAN LEAVE BEHIND ORPHANEDFLASHCOPY PAIRS AND VOLUMES
IT38003 BACKUP FAILS WITH BAD PAGE ERRORS DUE TO MISMATCH BETWEEN THE PHYSICAL SIZE OF THE CONTAINER AND WHAT IS SAVED IN THE SPCS FILES
IT38002 ALTER TABLESPACE REBALANCE HANGS ON DISK FULL ERROR
IT37998 ALTER TABLESPACE REBALANCE HANGS ON DISK FULL ERROR
IT37995 PURESCALE CAN NOT BE SETUP WITH DB2LOCSSH
IT37991 SPACE USED BY LOBS IN SOME EVENT MONITORS NOT REUSED WHEN THOSE LOBS ARE DELETED
IT37986 INSTANCE Crashed running a query
IT37983 POSSIBLE DB2 TRAP IN PSMGETVALIDBREAKPOINTS() WHEN CALLING SYSIBMINTERNAL.ADMIN_GET_VALID_BREAKPOINTS()
IT37980 LOCK ESCALATION OCCURS IN PURESCALE WHEN DB2_AVOID_LOCK_ESCALATION IS SET
IT37977 SELECT OR COMMIT AFTER UPDATE OF A COLUMN-ORGANIZED TABLE IN A PARTITIONED DATABASE ENVIRONMENT MIGHT FAIL WITH SQL901 ERROR
IT37965 THE REMOTE CHAR COLUMN LENGTH OVER 86 REPORT SQL0901 AFTER THE COLUMN LENGTH AUTO VARIATION
IT37964 SEGV AT SQLV_MIXD_BUILD_LIKE_SUBPAT()
IT37963 MEMORY LEAK IN DB2 11.5 MOD6 FP0 DUE TO A NEW FEATURE IN ESQL.
IT37960 SUBSEQUENT ATTACH PARTITIONS DOES NOT DISPLAY WARNING MESSAGE SQL3601W
IT37956 ADMIN_MOVE_TABLE FAILS WITH SQL0104N WHEN MOVING TABLE WITH DOUBLE QUOTES IN NAME WHICH HAS A STATISTICS PROFILE
IT37955 SUBSEQUENT ATTACH PARTITIONS DOES NOT DISPLAY WARNING MESSAGE SQL3601W
IT37942 SECURITY: IBM DB2 may be vulnerable to an Information Disclosure (CVE-2021-29678)
IT37941 SECURITY: IBM DB2 may be vulnerable to an Information Disclosure (CVE-2021-29678)
IT37940 SECURITY: IBM DB2 may be vulnerable to an Information Disclosure (CVE-2021-29678)
IT37939 SECURITY: IBM DB2 may be vulnerable to an Information Disclosure (CVE-2021-29678)
IT37938 EXTERNAL TABLE CAN FAIL WHEN A LARGE INPUT FILE CONTAINS STRING DATA THAT HAS AN ESCAPED QUOTE IN THE QUOTED STRING.
IT37934 WRONG RESULT WHEN DB2 QUERY HAS CORRELATED EXISTS PREDICATE
IT37918 .NET APPLICATION USING FULL FW NUGET CLOUD PACKAGE DOESN'T WORK ALONG WITH MULTIPLE COPIES ON THE SAME MACHINE
IT37911 INNER JOIN OF AT LEAST 4 COLUMN-ORGANIZED TABLES MIGHT RETURN WRONG RESULTS UNDER SPECIFIC CONDITIONS
IT37906 DEADLATCH causing APPLICATION HUNG DOING INSERT/SELECT ON TABLE WITH XML COLUMNS
IT37891 WHEN TRUSTED CONTEXT IS DROPPED, SETSESSIONUSER PRIVILEGES ARE ALSO DELETED
IT37889 DB2 QUERY MAY ABEND OR RETURN A SQL 901 WHEN USING A CORRELATED COMMON TABLE EXPRESSION
IT37883 FAILURE TO STOP SPECTRUM SCALE MMSYSMONCONTROL DAEMON MAY LEAD TO 'UNABLE TO UNLOAD KERNEL MODULES' WHEN ENTERING FS MAINTENANCE
IT37868 FODC_APPERR: 'COLUMN.GETISNULLABLE()' ASSERTION DURING REPLICATION FOR COLUMN-ORGANIZED TABLES
IT37863 HADR GRACEFUL TAKEOVER CAN TIMEOUT DUE TO SUSPENDED DB2AGENT PROCESSES
IT37857 BUILD IN FUNCTION "DATE_PART" MIGHT RETURN AN INCORRECT RESULT OF WEEK, I.E. DATE_PART('WEEK', '2020-03-09')
IT37846 NNSTAT FAILS TO UPDATE NICKNAME'S STATICS DUE TO DIFFERENT CURRENT SCHEMA SETTING
IT37840 INNER JOIN OF AT LEAST 4 COLUMN-ORGANIZED TABLES MIGHT RETURN WRONG RESULTS UNDER SPECIFIC CONDITIONS
IT37836 IN-PLACE INSTALLFIXPACK GETS SEGMENTATION FAULT ON RHEL 8.X WITHPACEMAKER
IT37810 REDUCE DB2DIAG.LOG MESSAGE "GET USER MAPPING" AND "SQLQG_FEDSTP_HOOK, PROBE:40 MESSAGE"
IT37801 UPDATE OF A COLUMN-ORGANIZED TABLE WITH A SEARCH PREDICATE ON ANINDEX MIGHT RETURN A SQL901 ERROR DURING EXECUTION.
IT37792 REMOVE DIAG MESSAGE "ROW HASH MISMATCH" WHEN LOAD ASKED TO DISCARD SUCH ROWS ON V11.5
IT37785 TRAP IN FUNCTION SQLNR_JOINPPD_COND WHEN RUNNING UPDATE STATEMENT
IT37768 PACKAGE RESTORE VALIDATION MAY CAUSE -901 AND FODC_APPERR
IT37755 DB2CLUSTER COMMAND WILL TIMEOUT IF EXCEEDS 22 MINUTES
IT37748 A FODC TRAP MAY OCCUR WHEN DIA5000C MESSAGE IS ISSUED DUE TO A PARSING ERROR.
IT37731 BIND OF PACKAGE FROM NON CATALOG NODE RESULTS WITH A SQL0727 WITH SQLCODE-805
IT37721 LOAD INTO SMALL MDC TABLE MAY FAIL IN SQLBPURGEORFLUSHALLPAGESINSMALLRANGE, MAY CAUSE DB SHUTDOWN AND CRASH RECOVERY FAILURE
IT37720 LOAD INTO SMALL MDC TABLE MAY FAIL IN SQLBPURGEORFLUSHALLPAGESINSMALLRANGE, MAY CAUSE DB SHUTDOWN AND CRASH RECOVERY FAILURE
IT37717 SECURITY: IBM DB2 may be vulnerable to an Information Disclosure (CVE-2021-29678)
IT37715 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE UNDER CERTAIN CIRCUMSTANCES WITH LOAD UTILITY (CVE-2021-20373)
IT37714 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE UNDER CERTAIN CIRCUMSTANCES WITH LOAD UTILITY (CVE-2021-20373)
IT37713 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE UNDER CERTAIN CIRCUMSTANCES WITH LOAD UTILITY (CVE-2021-20373)
IT37712 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE UNDER CERTAIN CIRCUMSTANCES WITH LOAD UTILITY (CVE-2021-20373)
IT37704 CRASH ENCOUNTERED WHEN THERE IS A UNION/NLJN/ISCAN/SORT COMBINATION
IT37703 HADRV115_MONITOR.KSH TIMEOUT - CAUSE UNKNOWN
IT37690 SPACE USED BY LOBS IN SOME EVENT MONITORS NOT REUSED WHEN THOSE LOBS ARE DELETED
IT37674 WRONG RESULTS FROM SELECT COUNT QUERY ON "ORGANIZE BY COLUMN" TABLE
IT37671 TABLE SPACE ROLLFORWARD CAN FAIL UNDER ADVANCED LOG SPACE MANAGEMENT
IT37658 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE UNDER CERTAIN CIRCUMSTANCES WITH LOAD UTILITY (CVE-2021-20373)
IT37655 REDUCED PACKAGE CACHE CAPACITY MIGHT RESULT OVER TIME WHEN WITH HISTORY MONITORING IS ENABLED
IT37644 DURING XA TRANSACTION, WHEN XAER_RMFAIL IS RECEIVED FROM SERVER,SUCH CONNECTIONS ARE NOT ISOLATED, CLOSED AND REMOVED FROM CONN
IT37638 HADR TAKEOVER FAILED WITH SQL1770 RC 7 DUE TO EVENT MONITOR BLOCKS FORCING OFF ONLINE REORG ON PRIMARY
IT37637 HADR PRIMARY STUCK IN CRASH RECOVERY BECAUSE NOT ABLE TO SHIP LOGS TO STANDBY IN PEER STATE
IT37634 HANG IF REMOTE NODE OUTPUT OF MON_GET_LOCKS OR MON_GET_PKG_CACHE_STMT IS BIGGER THAN 2GB
IT37632 DB2 QUERY MAY ABEND WHEN EXPRESSION REFERENCED FROM MQT
IT37626 ERROR SQL0102N RETURNED WHEN DB CFG VARCHAR2=ON, STMT_CONC=LITERALS AND STRING_UNITS=CODEUNITS32
IT37611 DB2 MAY PRODUCE WRONG RESULT ON UPDATE STATEMENT WITH VIEW DEPENDENCY
IT37607 OPTIMIZE FOR N ROWS CLAUSE CAUSES THE QUERY TO SCAN THE SUB-OPTIMAL PLAN
IT37602 IMPROVE ERROR MESSAGE WHEN PUTTING CLUSTER IN TO MAINTENANCE MODE WITHOUT DB2CLUSTER -ALL OPTION.
IT37592 DB2 TEXT SEARCH MIGHT RETURN INCORRECT RESULT WITH MORPHOLOGICALINDEXING
IT37589 DB2 FEDERATION CAN NOT BE FORCED OFF DURING ABNORMAL SHUTDOWN OF MSSQL SOURCE SERVER
IT37587 DB2 FEDERATION CAN NOT BE FORCED OFF DURING ABNORMAL SHUTDOWN OF MSSQL SOURCE SERVER
IT37583 HADR PRIMARY STUCK IN CRASH RECOVERY BECAUSE NOT ABLE TO SHIP LOGS TO STANDBY IN PEER STATE
IT37579 POSSIBLE TRAP IN SQLUMERGETABLEACCESSORZRC() WHEN RUNNING LOAD IN CDE ENVIRONMENT
IT37578 NEW ENVIRONMENT VARIABLE TO TUNE WAIT TIMES BETWEEN UDAPL API CALLS ( LINUX ON IBM Z SYSTEMS ONLY )
IT37563 POSSIBLE FMP TRAP WHEN RUNNING DB2EXPLAIN WITH A STATEMENT CONTAINING UNESCAPED NEWLINE (N) AND MULTIPLE SETS OF '(/)'
IT37559 CONFIGURATION ADVISOR SHOWS INADEQUATE RECOMMANDED VALUE FOR NUM_IOSERVERS/NUM_IOCLEANERS/DFT_PREFETCH_SZ
IT37556 GRPBY INTRODUCED IN V11.5.5.X ACCESS PLAN CAUSED SQL16003N
IT37555 AUTOMATIC MAINTENANCE (DB2ACD) PROCESS GENERATES "HMONSQLCONNECT, PROBE:600 SQLCODE-1060" DB2DIAG.LOG ERRORS ON STANDBY DATABASE
IT37548 DATABASE ROLLFORWARD MAY FAIL WITH SQL1265N
IT37547 HANG BETWEEN STOP HADR, SET WRITE SUSPEND AND ARCHIVE LOG COMMANDS
IT37546 INDEX SPECIFICATION IS NOT CREATED WHEN THE NICKNAME IS CREATED IF THE INDEX KEY GREATER THAN 1024 BYTES
IT37543 INDEX SPECIFICATION IS NOT CREATED WHEN THE NICKNAME IS CREATED IF THE INDEX KEY GREATER THAN 1024 BYTES
IT37540 SQLCODE: -901 AND FODC_TRAP: ASSERTIONFAILEDEXCEPTION: AN ASSERTION 'MCSETEMPMAP.FIND(CSETEMPNAME) == MCSETEMPMAP.END()' FAILED.
IT37537 ON DB2/AIX, POST FROM THREAD_POST CAN BE SKIPPED/DEFERRED BY WAITER INTERRUPTED IN THREAD_WAIT , LEADING TO PANIC/SHUTDOWN
IT37534 PLAN WITH HSJN DONE IN COLUMNAR LOGIC COULD ENCOUNTER -901 WHEN NULL EQUALS NULL CLAUSE IS PRESENT
IT37531 DB2_HANG_DETECT SCRIPT MAY DETECT HANG INCORRECTLY AND KILL THE INSTANCE WITH ACTION=TERMINATE
IT37514 db2 crash due to log missing required by a rollback.
IT37511 POOR PERFORMANCE OF FEDERATED QUERIES IN CERTAIN CASES
IT37498 TEXT SEARCH UPGRADE FROM 11.1 TO 11.5.5.1 DOES NOT UPDATE SYSIBMTS.SYSTSDEFAULTS
IT37496 TOTAL_LOG_USED MONITOR ELEMENT SHOW UNREASONABLY HIGH VALUE
IT37490 DB2_HANG_DETECT SCRIPT MAY DETECT HANG INCORRECTLY AND KILL THE INSTANCE WITH ACTION=TERMINATE
IT37470 Possible SIGSEGV when turning on or during monitoring of table events
IT37458 SELECT STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT")
IT37455 DB2ICRT AND DB2IUPDT FAIL WITH DBI20048E
IT37454 WHILE DOING AN XML LOAD, DB2 MAY CRASH WHEN PROCESSING A ROW WITH INVALID DATA
IT37448 AFTER TURNING ON CLI PREFETCHING FEATURE, SQL STATEMENT RECEIVESCLI0106E/CLI0108E OR SQL_ERROR WITHOUT DIAGNOSTIC INFO
IT37447 ROLLFORWARD ON UNAVAILABLE NLI TABLE MAY CAUSE FODC_BADPAGE ERRORS
IT37446 CLR PROCEDURE ABORTS ABNORMALLY WITH ERROR SQL1024N WHEN IT USESIBM.DATA.DB2 .NET provider
IT37436 DATABASE CREATE FAILS WITH SQL2049N RC=2 WHEN DB2_DATABASE_CF_MEMORY BEING SET TO 0
IT37424 TRAP WHEN RUNNING ADMIN_REVALIDATE_DB_OBJECTS()
IT37423 INSTALLDSDRIVER -UPGRADE FAILS TO UPGRADE WHEN MOVING FROM ONE MODPACK TO ANOTHER
IT37416 db2icrt fails if more than three cfnets or two hdisk are specified. db2iupdt
IT37407 SQLCOLUMNS CLI FUNCTION MAY NOT WORK ON A TABLE NAME THAT INCLUDES MBCS CHARACTERS
IT37396 IN DPF SQL USING EARLY CLOSE MAY INCREASE FCM BUFFERS UNTIL APPLICATION TERMINATION
IT37395 DB2PD -BUFFERPOOLS REPORTS INACCURATE HIT RATIO
IT37394 DB2PD
IT37382 TOTAL_LOG_USED INCREASE GRADUALLY TO AN UNREAL VALUE
IT37375 IN DPF SQL USING EARLY CLOSE MAY INCREASE FCM BUFFERS UNTIL APPLICATION TERMINATION
IT37374 REDO OF FREEEXTS LOG RECORD CAN CORRUPT HWM OF TALBESPACE
IT37369 IN CERTAIN TIMING CONDITIONS, CLI CLIENT ACR CAN FAIL TO REROUTECONNECTIONS
IT37345 WITH FEDERATION FUNCTION, IT IS POSSIBLE THAT INSERT STATEMENT WILL GET SQL1476N.
IT37339 A USER INTERRUPT DURING AN IMPLICIT REBIND WHILE OPENING A CURSOR IN A STORED PROCEDURE MAY CAUSE A TRAP
IT37338 CPU_UTILIZATION CAN BE SHOWING MORE THAN 100%
IT37337 MORE ROBUST CLEANUP STATUS CHECKING
IT37336 MISMATCH THAT THE OS HOSTNAME VALUE IS LOWER-CASED WHEREAS THE HADR_LOCAL_HOST/HADR_REMOTE_HOST VALUES ARE UPPER-CASED. THIS SHO
IT37326 TOTAL_LOG_USED MONITOR ELEMENT SHOW UNREASONABLY HIGH VALUE
IT37320 Server may trap WHEN STMT_CONC IS SET AS COMM_LIT
IT37308 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ISSUING A SELECT QUERY
IT37307 XML NODE MANAGER THROWS SQL0901N ERROR WHILE RUNNING MANUAL RUNSTATS ON XML TABLE
IT37302 HADR TAKEOVER FAILED WITH SQL1770 RC 7 DUE TO EVENT MONITOR BLOCKS FORCING OFF ONLINE REORG ON PRIMARY
IT37301 DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY WILL FAIL WITH AN SQL2079N ERROR, IN VERSION 11.1.4.4.
IT37300 NO OUTPUT RETURNED USING PD_GET_LOG_MSGS OR PDLOGMSGS_LAST24HOURS ON WINDOW ENVIRONMENT
IT37299 LARGE PRIVATE MEMORY LEAK WHEN PD_GET_DIAG_HIST IS INTERRUPTED PROCESSING A LARGE DB2DIAG.LOG OR NOTIFY FILE
IT37297 MISS FETCHING THE RESTRICT ACCESS CFG FROM API (DB2LOOK)
IT37290 IN-PLACE INSTALLFIXPACK MINOR ERROR WITH DAS
IT37280 STANDBY_ERROR_TIME DOES NOT CHANGE AFTER ERRONEOUS TABLE SPACE IS REINITIALIZED
IT37275 EXTERNAL TABLE CAN FAIL WHEN A LARGE INPUT FILE CONTAINS STRING DATA THAT HAS AN ESCAPED QUOTE IN THE QUOTED STRING.
IT37270 CREATE TABLE FAILING WITH "NO MEMORY AVAILABLE IN 'APPLICATION HEAP'
IT37266 EMPTY STRING INSERTED AS NULL WHEN USING QUOTEDVALUE
IT37263 DB2CKUPGRADE MISSING ROW ACCESS THAT DEPEND ON SYSTEM VIEWS.
IT37261 STANDBY_ERROR_TIME DOES NOT CHANGE AFTER ERRONEOUS TABLE SPACE IS REINITIALIZED
IT37255 PROBLEM RUNNING UPDATE ON MARIADB (FEDERATION)
IT37254 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE (CVE-2021-29752)
IT37253 IN SOME CASES, WLM THRESHOLDS FOR TEMP SPACES IS CALCULATING INCORRECTLY
IT37252 -P PARAMETER IS BEING IGNORED BY DB2ICRT
IT37240 DB2CFEXP FAILS TO EXPORT SSL_CLNT_KEYDB AND SSL_CLNT_STASH DBM CFG PARAMETERS FROM A CLIENT INSTANCE
IT37239 POOR PERFORMANCE WITH QUERIES USING SAP MEMORY TABLE WITH GROUP BY
IT37237 NX842 BACKUP AND LOG FILE COMPRESSION MIGHT FAIL
IT37236 EXPLAIN_FROM_SECTION RETURNS SQL0220N FOLLOWING UPGRADE TO DB2 V11.5.5 DESPITE RUNNING DB2EXMIG
IT37217 BEING UNABLE TO CREATE LOGSTREAM SUBDIRECTORIES SHOULD NOT FAIL ROLLFORWARD
IT37216 JCC 4.27.25 CAUSES ABENDS IN DB2 WHILE ACCESSING BLOB DATA MORE THAN 1MB SIZE
IT37215 MISSING BYTES OF DATA WHEN FETCHING LOB COLUMNS CONTAINING MULTIBYTE CHARACTERS FROM JCC
IT37213 SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMDWITH LOAD OR BACKUP (CVE-2021-29825)
IT37212 RARE MEMORY CORRUPTION IN SORTHEAP WHEN CDE HSJN IS IN THE PLAN
IT37210 SQL1598 IS RETURNED WHEN USING DB2CONSV_T.LIC IN 11.1.4.5
IT37209 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ISSUING A SELECT QUERY
IT37196 IF NODE FAILURE RECOVERY OCCURS AFTER END OF TRANSACTION, THE NEXT OPERATION CAN RECEIVE SQL1229
IT37190 REBIND FAILING WITH SQL0100W
IT37184 WHEN TRUSTED CONTEXT IS DROPPED, SETSESSIONUSER PRIVILEGES ARE ALSO DELETED
IT37183 IBM ENTITYFRAMEWORK CORE 5.0 PROVIDER THROWS ERROR SQL0104N WHENAPPLICATION USES TRANSACTION
IT37181 POSSIBLE SIGSEGV WHEN SELECTING A ROW FROM A NONPARTITIONED TABLE USING AN INVALID RID_BIT VALUE
IT37180 Instance may crash with sqliDumpInxCursor on the stack when dumping FODC diagnostics (-901 or trap)
IT37179 OTF ENCODING FOR THE LARGE COLUMNS LEADS TO QUERY EXECUTION FAILS WITH SQL0954 .
IT37178 A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP
IT37177 SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMDWITH LOAD OR BACKUP (CVE-2021-29825)
IT37168 DB2EXFMT TRAPS WHILE PROCESSING A QUERY CONTAINING HEXADECIMAL VALUES
IT37164 POSSIBLE TRAP IN SQLO_SLATCH_CAS64::RELEASECONFLICT WHEN CLEANING UP FEDERATED FMP
IT37160 JSON_UPDATE FUNCTION MIGHT WORK UNEXPECTEDLY.
IT37157 FODC_APPERR DURING STRESS RUN, SQL901: ERROR UNHOLDING VARIATIONLOCK
IT37150 A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP
IT37149 SYSTEM TEMP TABLESPACE CAN BE LEFT IN SQLB_REORG_IN_PROGRESS IF REORGS WERE STARTED, BUT NOT COMPLETED BEFORE CRASH RECOVERY
IT37147 CRASH ENCOUNTERED WHEN THERE IS A UNION/NLJN/ISCAN/SORT COMBINATION
IT37146 SYSTEM TEMP TABLESPACE CAN BE LEFT IN SQLB_REORG_IN_PROGRESS IF REORGS WERE STARTED, BUT NOT COMPLETED BEFORE CRASH RECOVERY
IT37136 SQL1659 is not returned even when a RDMA device cannot be openedduring db2start, and db2diag.log is spammed with error messages
IT37132 SQL0180N IS RETURNED WHEN TRY TO INSERT ODBC FORMAT TIMESTAMP.
IT37130 Open error on primary log path could lead to forced database shutdown and panic
IT37126 ARRAYINDEXOUTOFBOUNDSEXCEPTION OCCURS DURING MULTITHREADED SQLJ APPLICATION PROFILE PROCESSING.
IT37114 QUERIES REFERENCING MULTIPLE IDENTICAL SCALAR SUB-QUERIES IN THESELECT LIST MAY RETURN INCORRECT RESULTS
IT37105 INTERMITTENT ISSUE IN ST_UNION RESULTING IN WRONG M VALUES
IT37104 POSSIBLE TRAP FOLLOWING DB2DIAG.LOG MESSAGE "TRYING TO REGISTER AN INVALID SERVICE CLASS ID OF 0"
IT37103 PURESCALE DELETE ROWS PERFORMANCE REGRESSION ON RDMA NETWORKS
IT37102 APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED
IT37100 DB2STOP RESULTS IN SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004
IT37095 DB2STOP RESULTS IN SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004
IT37088 A NON ENCRYPTED DATABASE THAT IS RESTORED AS AN ENCRYPTED DATABASE IS NOT CONNECTABLE AFTER THE RESET DB CFG COMMAND.
IT37087 NX842 BACKUP AND LOG FILE COMPRESSION MIGHT FAIL
IT37084 APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED
IT37081 INCONSISTENT OLAP RESULTS ON COLUMNAR TABLES IN AN MPP ENVIRONMENT
IT37079 COUNT DISTINCT QUERIES AGAINST COLUMNAR ORGANIZED TABLES COULD RETURN INCORRECT RESULTS
IT37048 COLUMN ORGANIZED TABLES THAT HAVE BEEN MARKED UNAVAILABLE CANNOTBE RENAMED. DOING SO MAY CRASH DB2.
IT37047 HANG DUE TO DEADLATCH BETWEEN VECTORIZEDADC THREAD AND NORMAL APPLICATION THREAD WHICH IS ROLLING BACK
IT37043 FOR SSL CONNECTIONS ONLY, AUTHENTICATION CACHE IS NOT ABLE TO PERFORM USER OR GROUP LOOKUP
IT37042 IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG
IT37037 DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY
IT37034 EXECUTING A PROCEDURE AFTER TRANSFER OWNERSHIP OF SPECIFIC PROCEDURE RESULTS IN SQLCODE -551 REPORTED FOR ORIGINAL OWNER.
IT37032 IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG
IT37021 SNAPSHOT BACKUP FAILED WITH SQL1550N RC 5
IT37015 CORRECT THE HANDLING OF THE DEFERRED SYNOPSIS TUPLE ROLLBACK SCENARIO.
IT37014 WITH FEDERATION USE OF A FLAT FILE FAILS IF THE FILE > 3GB IN SIZE ON WINDOWS
IT37006 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
IT37005 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
IT36964 TOO MANY LOG FILES IN ACTIVE LOG PATH ON HADR STANDBY
IT36961 FOR SSL CONNECTIONS ONLY, AUTHENTICATION CACHE IS NOT ABLE TO PERFORM USER OR GROUP LOOKUP
IT36948 RARE TRAP IS POSSIBLE DURING COLUMNAR HASH JOIN .
IT36941 Security: IBM Db2 is vulnerable to a DoS when a table is droppedwhile being accessed in another session (CVE-2021-29777)
IT36940 Security: IBM Db2 is vulnerable to a DoS when a table is droppedwhile being accessed in another session (CVE-2021-29777)
IT36939 Security: IBM Db2 is vulnerable to a DoS when a table is droppedwhile being accessed in another session (CVE-2021-29777)
IT36938 Security: IBM Db2 is vulnerable to a DoS when a table is droppedwhile being accessed in another session (CVE-2021-29777)
IT36937 IF ROW BEING SORTED IS VERY WIDE MEMORY OVERWRITES OR WRONG RESULTS ARE POSSIBLE.
IT36935 DB2 TEXT SEARCH MIGHT RETURN INCORRECT RESULT WITH MORPHOLOGICALINDEXING
IT36932 SVT CSI BLUSEL: DB2_V111M1FP1: ASSERTION: WRONG SIBLING FOR (56,0) FOUND WITH ID:0,0,0
IT36931 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE (CVE-2021-29752)
IT36928 IF ROW BEING SORTED IS VERY WIDE MEMORY OVERWRITES OR WRONG RESULTS ARE POSSIBLE.
IT36927 EXECUTING A PROCEDURE AFTER TRANSFER OWNERSHIP OF SPECIFIC PROCEDURE RESULTS IN SQLCODE -551 REPORTED FOR ORIGINAL OWNER.
IT36924 IN A RARE SCENARIO THE ERROR COULD BE LOST AND INSTEAD EITHER NULL OR SQL0901N returned
IT36915 AN INDOUBT TRANSACTIONS MAY BE CREATED UNNECESSARILY WHEN USING AN XA TRANSACTIONS ON PURESCALE WITH A FEDERATED DATABASE
IT36910 SECURITY: IBM DB2 IS VULNERABLE TO WEAK FILE PERMISSIONS ALLOWING ACCESS TO SPECIFIC FILES (CVE-2020-4976)
IT36909 SECURITY: IBM DB2 IS VULNERABLE TO WEAK FILE PERMISSIONS ALLOWING ACCESS TO SPECIFIC FILES (CVE-2020-4976)
IT36908 SECURITY: IBM DB2 IS VULNERABLE TO WEAK FILE PERMISSIONS ALLOWING ACCESS TO SPECIFIC FILES (CVE-2020-4976)
IT36907 SECURITY: IBM DB2 IS VULNERABLE TO WEAK FILE PERMISSIONS ALLOWING ACCESS TO SPECIFIC FILES (CVE-2020-4976)
IT36906 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE UNDER SPECIFIC CONDITIONS (CVE-2021-29763)
IT36903 -901 ERROR WITH REASON "NO PLAN FOUND"
IT36902 -901 ERROR WITH REASON "NO PLAN FOUND"
IT36894 "TOO MANY ARGUMENTS" MESSAGE WHEN RUNNING DB2CM
IT36892 SNAPSHOT BACKUP FAILED WITH SQL1550N RC 5
IT36891 MON_GET_LOCKS FAILS IN SINGLE MEMBER WITH "NO MEMORY AVAILABLE".
IT36888 A SQL STATEMENT CAUSES THE AGENT TO TRAP
IT36883 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
IT36870 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE UNDER SPECIFIC CONDITIONS (CVE-2021-29763)
IT36869 SECURITY: IBM DB2 IS VULNERABLE TO WEAK FILE PERMISSIONS ALLOWING ACCESS TO SPECIFIC FILES (CVE-2020-4976)
IT36862 POSSIBLE 15 SECOND DELAY IN SQLEPEEKREQUEST
IT36857 DB2 ALTER TABLE QUERY MAY FAIL WITH SQL0109N ERROR
IT36853 DB2AGENT REPORTED SQLD_PARM ERROR WHEN TRYING TO FIND/FIX TCB WITH OBJECTID=0
IT36851 WHEN DB2_ALTERNATE_GROUP_LOOKUP=GETUSERATTR, A USER'S PRIMARY GROUP MAY NOT BE REPORTED BY DB2.
IT36847 WHEN DB2_ALTERNATE_GROUP_LOOKUP=GETUSERATTR, A USER'S PRIMARY GROUP MAY NOT BE REPORTED BY DB2.
IT36839 DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY
IT36834 XML NODE MANAGER THROWS -901 ERROR WHILE RUNNING MANUAL RUNSTATSON XML TABLE.
IT36833 OCCURS ON PARTITIONED DATABASE, DB2 MAY CRASH WHEN TRYING TO UNLATCH A LATCH THAT IS NOT HELD
IT36825 SQLTEMPSPACE OR AGGSQLTEMPSPACE THRESHOLDS DO NOT WORK WITH ROWSTORE OLAP OPERATORS THAT SPILL TO DISK.
IT36821 SET EVENT MONITOR STATE STATEMENTS MAY BE INCORRECTLY QUEUED BY THE ADAPTIVE WORKLOAD MANAGER
IT36820 DB2ADUTL FAILS TO READ DB CONFIG ON PURESCALE OR DPF ON NODES OTHER THAN CATALOG NODE
IT36818 POSSIBLE DATA LOSS IF DELETE OPERATION AND RUNSTATS/REORG RECLAIM ARE IN SAME TRANSACTION & THEN THE TRANSACTION IS ROLLED BACK
IT36816 DB2CLUSTER -CFS -EXIT -MAINTENANCE MAY FAIL WITH RC=2
IT36813 WARNING MESSAGE FROM SQLNLS_INITICUCALLBACKS PROBE 30 AND 50 IN DB2DIAG.LOG
IT36812 Instance may crash with sqliDumpInxCursor on the stack when dumping FODC diagnostics (-901 or trap)
IT36810 FODC TRAP might occur when using UTL_MAIL module
IT36770 IMPORT MAY BE TERMINATED IF SQL0437W IS DETECTED, ALTHOUGH IT CAN BE IGNORED IN MOST SCENARIOS.
IT36769 DB2FMCD.SERVICES GETS DELETED IF THERE ARE TWO DB2 SETUPS AND ONE GETS REMOVED
IT36757 CLR PROCEDURE ABORTS ABNORMALLY WITH ERROR SQL1024N WHEN IT USESIBM.DATA.DB2 .NET provider
IT36753 IN SOME RARE CASES, A SORT ON A COLUMNAR TABLE CAN HANG
IT36751 EXTERNAL TABLES WITH LFINSTRING OPTION MAY FAIL IF DATA CONTAINSA FIELD INCLUDING A NON ESCAPED DELIMITER CHARACTER
IT36748 DB2EGCF CAUSES TRACE FLOODING DUE TO MEMORY SEG FAULT
IT36743 PREVENT PUSHING DOWN LARGE IN LIST PREDICATES TO UNION BRANCHES.
IT36742 SQL0901N WHEN DB2 QUERY HAS CDE TABLE AND JOIN PREDICATE HAS TYPE MISMATCH
IT36731 ADMIN_MOVE_TABLE FAILS WITH SQL0010N - WHEN RUNSTATS STATS_PROFILE IS GREATER THAN 1024 CHARACTERS.
IT36721 REORGCHK F6 REPORTING INCORRECT VALUES
IT36720 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFO. DISC. IN SOME CASES WHEN A USER CREATES AN INLINE SQL FUNC. (CVE-2021-20579)
IT36719 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFO. DISC. IN SOME CASES WHEN A USER CREATES AN INLINE SQL FUNC. (CVE-2021-20579)
IT36718 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFO. DISC. IN SOME CASES WHEN A USER CREATES AN INLINE SQL FUNC. (CVE-2021-20579)
IT36717 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFO. DISC. IN SOME CASES WHEN A USER CREATES AN INLINE SQL FUNC. (CVE-2021-20579)
IT36692 STORED PROCEDURE CREATED USING THE OUT PARAMETER, WILL CAUSE DB2TO CRASH WHEN USED WITH FEDERATION
IT36690 QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNIONMAY GET INCORRECT RESULT
IT36689 REORGCHK F6 REPORTING INCORRECT VALUES
IT36682 QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNIONMAY GET INCORRECT RESULT
IT36666 REORG TABLE RECLAIM EXTENTS ON INSERT TIME CLUSTERING (ITC) TABLES CAN RESULT IN FODC_INDEXERROR
IT36665 REORG TABLE RECLAIM EXTENTS ON INSERT TIME CLUSTERING (ITC) TABLES CAN RESULT IN FODC_INDEXERROR
IT36658 MON_GET_APPL_LOCKWAIT MIGHT HANG IN PURESCALE
IT36654 LARGE LOAD WITH LARGE AMOUNT OF LOB (> ~2-5 GB) DATA, AFTER LOADCOPY IMAGE FILE REPLAYED/PROCESSED, LEAD TO DATA CORRUPTION
IT36653 LARGE LOAD WITH LARGE AMOUNT OF LOB (> ~2-5 GB) DATA, AFTER LOADCOPY IMAGE FILE REPLAYED/PROCESSED, LEAD TO DATA CORRUPTION
IT36648 CRASH RECOVERY CAN FAIL WITH SQLCODE "-10003"
IT36646 FEDERATED TABLE IMPLICIT DATE CONVERSION TO TIMESTAMP NOT WORKING
IT36639 DB2 PURESCALE CLUSTER MEMBERS MAY CRASH DUE TO CERTIAN DISK IO ISSUES IN A CF NODE
IT36633 DB2IPERIODICWATCH TIMEOUT MESSAGE
IT36628 ZRC=0xFFFFFFFF=-1 error in db2diag.log when using purescale withSSL

© Icons by Mark James www.famfamfam.com

invispix 10x10
invispix 10x10
Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

invispix 10x10
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.