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
IT41578 IF XAER_RMFAIL RECEIVED WHILE READING A RESULTSET FROM APPLICATION THEN CONNECTIONEVENT LISTENER NEED TO RAISE XAER_RMFAIL EVENT
IT41557 IN RARE SCENARIOS, THE DB2WDOG PROCESS 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
IT41517 QUERY PERFORMANCE MAY VARY WHEN USING OUTER JOIN OPERATOR
IT41505 QUERY PERFORMANCE MAY VARY WHEN USING OUTER JOIN OPERATOR
IT41487 INSTALLFIXPACK DELETES /ETC/SYSTEMD/SYSTEM/DB2FMCD.SERVICE FILE ON LINUX
IT41481 RUNSTATS CALCULATES PCTINLINED INCORRECTLY WHEN USING TABLE SAMPLING
IT41474 CONNECTION FROM DB2FMP TO THE ENGINE IS NOT CLEANED UP AFTER AN INTERRUPT
IT41466 DB2SUPPORT WITH THE -CL 2 OR -CL 3 OPTION CAN UNDER SOME CIRCUMSTANCES RESULT IN A SEGV TRAP
IT41456 SQL0433N ON RETRIEVAL ASSIGNMENT WHEN DBCLOB CAST TO VARCHAR
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
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
IT41317 -901 WHEN COMMON TABLE EXPRESSION USED IN JOIN.
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 GRACEFUL TAKEOVER MIGHT CAUSE A TRAP ON THE NEW PRIMARY
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
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
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.
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
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)
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
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
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()
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
IT40840 SAPTOOLS.ADMIN_COL_ANALYZE_FRAGMENTATION MIGHT RETURN SQL0802N
IT40819 REORG NOT RECLAIMING EXTENTS FOR ITC TABLES EFFICIENTLY.
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
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
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
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
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
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
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
IT38739 MEMORY LEAKS OCCURRING ON COLUMN-ORGANIZED DGTTS
IT38734 OBJECTTYPE FIELD FROM OBJECTOWNERS IS NULL FOR CERTAIN TABLESPACES
IT38731 CALLING CLR STORED PROCEDURE ON WINDOWS COULD RESULT IN SQL4301NRC=6
IT38730 POSSIBLE TRAP IN JOINEXPANSIONMULTIPLIEREVALUATOR::EXPANDALLREGULARATTR WHEN RUNNING HSJN QUERIES
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
IT38615 EXTERNAL TABLE FIXED FORMAT LOAD OF VARCHAR WITH REFERENCE COLUMN 0 FAILS
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()
IT38526 SQL_STACK_TRACE IN SQLUCHECKPOOLFORREDO() GENERATES MANY DUMP FILES WHEN THERE IS PERMISSION PROBLEM TO ACCESS A TABLESPACE.
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 SQL2657N
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
IT38339 db2instance -list shows CF in ERROR state transiently
IT38313 Memory leak in runtime engine if memory pool is not cached

© 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