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
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
IT37703 HADRV115_MONITOR.KSH TIMEOUT - CAUSE UNKNOWN
IT37690 SPACE USED BY LOBS IN SOME EVENT MONITORS NOT REUSED WHEN THOSE LOBS ARE DELETED
IT37671 TABLE SPACE ROLLFORWARD CAN FAIL UNDER ADVANCED LOG SPACE MANAGEMENT
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
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
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
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
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
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
IT37458 SELECT STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT")
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
IT37423 INSTALLDSDRIVER
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
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.
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'
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)
IT37253 IN SOME CASES, WLM THRESHOLDS FOR TEMP SPACES IS CALCULATING INCORRECTLY
IT37252 -P PARAMETER IS BEING IGNORED BY DB2ICRT
IT37239 POOR PERFORMANCE WITH QUERIES USING SAP MEMORY TABLE WITH GROUP BY
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 SOMETIMES FEW BYTES OF DATA ARE MISSING WHEN LOB LOCATORS ARE USED FOR FETCHING DATA WHICH CONTAINS MULTI BYTE CHARACTERS
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
IT37180 Instance may crash with sqliDumpInxCursor on the stack when dumping FODC diagnostics (-901 or trap)
IT37178 A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP
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
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
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
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
IT37079 COUNT DISTINCT QUERIES AGAINST COLUMNAR ORGANIZED TABLES COULD RETURN INCORRECT RESULTS
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
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
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
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
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
IT36883 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
IT36862 POSSIBLE 15 SECOND DELAY IN SQLEPEEKREQUEST
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 AND RUNSTATS/REORG ARE IN A SINGLE TRANSACTION AND THE TRANSACTION IS THEN ROLLEDBACK
IT36816 DB2CLUSTER -CFS -EXIT -MAINTENANCE MAY FAIL WITH RC=2
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
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
IT36606 CPU_UTILIZATION CAN BE SHOWING MORE THAN 100%
IT36601 SECURITY: IBM DB2 SERVER TERMINATES ABNORMALLY WHEN SELECT FROMINVALID VIEWS (CVE-2021-29703)
IT36600 SECURITY: IBM DB2 SERVER TERMINATES ABNORMALLY WHEN SELECT FROMINVALID VIEWS (CVE-2021-29703)
IT36599 SECURITY: IBM DB2 SERVER TERMINATES ABNORMALLY WHEN SELECT FROMINVALID VIEWS (CVE-2021-29703)
IT36583 CONNECTION SLOWNESS/HANG DUE TO MORE LATCH WAIT AT GROUP AUTHENTICATION STEP.
IT36581 A QUERY MAY HANG IN A MULTI-NODE ENVIRONMENT.
IT36572 FEDERATED QUERY MULTIBYTES CHARACTERS RETURNING '001A' USING THEODBC WRAPPER
IT36571 GET_CODEPAGE IS CALLED FOR EVERY PARAMETER MARKER WHICH CAUSED BAD PERFORMANCE IN DRDA WRAPPER
IT36569 DB2FLSN TOOL INCORRECTLY DISPLAYS "N/A" AS THE MAXIMUM LSN FOR ALOG FILE INSTEAD OF THE ACTUAL MAXIMUM LSN VALUE.
IT36568 A DATABASE OUTAGE IS REQUIRED IN ORDER FOR A NEW CERTIFICATE FORHADR WITH SSL TO TAKE EFFECT
IT36564 DROPPING A MEMBER USING DB2IUPDT -DROP MIGHT RUN INTO MEMORY FAULT
IT36563 TRAP IN SQLERSENDFMPSTART DUE TO SENDBUFFER BEING NULL
IT36559 TRAP IN SQLERSENDFMPSTART DUE TO SENDBUFFER BEING NULL
IT36535 INTERNAL LATCHING LOGIC ERROR FROM TABLE QUEUE SERVICES LEADS TODATABASE SHUTDOWN
IT36532 DB2 MAY CRASH IN A RARE TIMING WHEN RUNNING FEDERATED QUERIES WITH FENCED WRAPPER AND USER MAPPING PLUGIN IS ENABLED.
IT36527 DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET
IT36525 TRAP IN FUNCTION SQLPLRL WHEN DROPPING A SYSTEM TEMPORARY TABLE CREATED BY A QUERY RUNNING ON A HADR STANDBY
IT36524 TRAP IN FUNCTION SQLPLRL WHEN DROPPING A SYSTEM TEMPORARY TABLE CREATED BY A QUERY RUNNING ON A HADR STANDBY
IT36521 SQL405N REPORTED BY DB_MEMBERS AND DB_PARTITIONS TABLE FUNCTIONSIF NETNAME EXCEEDS 128 CHARACTERS IN DB2NODES.CFG
IT36512 DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET
IT36504 WHEN THE DBNAME DOES NOT MATCH THE DBALIAS HADR FAILS TO START ON THE PRIMARY
IT36499 901 COLUMN NUMBER OUT OF RANGE WHEN GB IN OJ AND GB COLUMN NOT USED IN OJ OR ABOVE (RELATED TO IT29755)
IT36498 DB2 MAY RETURN
IT36493 DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT.
IT36476 HANG DURING INSERT FROM NODES SENDING HISTOGRAMS
IT36475 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFO. DISC. IN SOME CASES WHEN A USER CREATES AN INLINE SQL FUNC. (CVE-2021-20579)
IT36474 WILD POINTER REQUEST->AGT_RUNTIME_OBJ IN SQLQG_SIGNAL_HANDLER LEADS TO DATABASE CRASH
IT36473 TRUNCATE TABLE WITHOUT IMMEDIATE ON CDE TABLES WITH DELIMITED IDENTIFIERS FAILS
IT36468 REPLAY OF REVOKE ON HADR STANDBY WITH READS ON STANDBY ENABLED MAY RESULT IN A SMALL MEMORY LEAK
IT36467 A TRUNCATE TABLE STATEMENT ON A COLUMN ORGANIZED TABLE WITH LOBSMAY RETURN SQLCODE -964 (TRANSACTION LOG IS FULL).
IT36462 BLU QUERY CAN TRAP IN EVALUATIONROUTINE::GETQUERYLITERAL
IT36461 ACTIVATE DATABASE ON ONE MEMBER IN PURESCALE HUNG WHEN ANOTHER MEMBER IS EXECUTING CREATE INDEX ON HADR PRIMARY DATABASE
IT36454 SQL0901N
IT36449 DB2 PREP COMMAND FAILS WITH THE ERROR SQL0318N WHEN THE VALUES CLAUSE CONTAINS THE KEYWORD FOR.
IT36444 SETTING DB2_DPS_RLOG_SHR_MEMBYTES CAUSES EXCESSIVE AMOUNT OF INFORMATION IN DB2DIAG.LOG
IT36443 SETTING DB2_DPS_RLOG_SHR_MEMBYTES CAUSES EXCESSIVE AMOUNT OF INFORMATION IN DB2DIAG.LOG
IT36441 DB2 QUERY PERFORMS BAD WHEN USING SUBQUERY PREDICATE WITH OR
IT36439 SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECTDB2 (CVE-20220-27216)
IT36431 DB2CLUSTER
IT36427 MON_GET_AUTO_MAINT_QUEUE() MAY FAIL WITH SQL0493N
IT36420 THE "DB2CLUSTER -CFS -EXIT -MAINTENANCE -ALL" COMMAND FAILS IN ASINGLE HOST PURESCALE CLUSTER
IT36418 LDAP PLUGIN NOW ALLOWS CONFIGURATION TO CHECK LDAP PASSWORDPOLICYRESPONSE
IT36416 WITH FEDERATION FUNCTION, IT IS POSSIBLE THAT INSERT STATEMENT WILL GET SQL1476N.
IT36413 SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECTDB2 (CVE-2020-27216)
IT36408 INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS
IT36404 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739)
IT36402 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739)
IT36401 901-COLUMN NUMBER OUT OF RANGE DURING QUERY COMPILATION, FORM_CSE CALL STACK
IT36400 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739)
IT36396 SQL0901N APPERR WHEN INSERT INTO AFTER TRUNCATE WITHOUT IMMEDIATE CLAUSE
IT36393 CIB ATTRIBUTE FAILED TO SET DURING PRIMARY REBOOT
IT36388 UNEXPECTED SQL206 WHEN COLUMN NAME OR COLUMN NAME QUALIFIER HAS TRAILING SPACES
IT36387 A FODC FMP TRAP IS REPORTED IN SQLQG_GET_TOSENDDATALEN WHILE QUERYING FEDERATION NICKNAMES
IT36386 A FODC FMP TRAP IS REPORTED IN SQLQG_GET_TOSENDDATALEN WHILE QUERYING FEDERATION NICKNAMES
IT36384 UPDATE STATEMENT WITH IN/EXISTS MAY GENERATE SQLCODE
IT36380 GET_CODEPAGE IS CALLED FOR EVERY PARAMETER MARKER WHICH CAUSED BAD PERFORMANCE IN DRDA WRAPPER
IT36378 DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT.
IT36376 EXPORT RETURNS SQL0204N "SYSTEM.SYSCAT.FUNCTIONS" IS UNDEFINED.
IT36374 DB2 HANGS EXECUTING ENV_GET_DB2_EDU_SYSTEM_RESOURCE
IT36366 DB2ICRT EXITS WITH DBI20000E AND FAILS TO CREATE A PURESCALE INSTANCE IN AN ENVIRONMENT WITH MANY NSD
IT36362 DB2CFEXP FAILS TO EXPORT SSL_CLNT_KEYDB AND SSL_CLNT_STASH DBM CFG PARAMETERS FROM A CLIENT INSTANCE
IT36337 PREFETCHERS INFINITELY LOOPING IN SQLBSERVICELEAFREQUEST
IT36334 ERROR LOG MAY BE CONTINUE TO GENERATE IN HADR CONFIGURED BY PACEMAKER ON AWS.
IT36333 INCORRECT CONNECTION DETAIL TOKEN STRINGS FOR A CLP CONNECTION USING A DBALIAS GREATER THAN DBNAME
IT36331 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTINGTO DATABASES CAN LEAD TO INSTANCE ABEND
IT36327 AUTO REORG..RECOMPRESS AND ONLINE BACKUP CANNOT BE RUN CONCURRENTLY
IT36323 MEMORY BLOCK FREED TWICE IN SQLOFMBLKEX
IT36320 QUERY EXECUTION MAY FAIL FOR OUTER JOIN QUERIES WITH PREDICATES WITH CAST FUNCTIONS
IT36311 WHEN RUNNING NLJN against COLUMNAR TABLES IT IS POSSIBLE TO GET SQL0901N ERROR
IT36285 INSTANCE TRAPPED DURING SNAPSHOT MONITORING IN FUNCTION SQLPGETDBMONLOG()
IT36279 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739)
IT36276 UNEXPECTED SQL0206N FROM FEDERATED VIEW USING WITH CLAUSE.
IT36275 UNCATALOG SYSTEM ODBC DATA SOURCE FAILS WITH DB21036E
IT36270 EXPLAIN_FROM_SECTION GENERATES EXPLAIN FILE WITH NEGATIVE VALUESWHEN NUMBER OF ROWS IS UPPER THAN INT LIMIT (2147483647)
IT36266 INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS
IT36259 SQL0952N ERROR SHOULD BE RAISED INSTEAD OF PRODUCING FODC_APPERRAND SQL0901N
IT36256 DB2 PREP COMMAND FAILS WITH SQL4003N 'THE SQL STATEMENT IS NOT SUPPORTED ...' OR SQL0104N 'UNEXPECTED TOKEN ...' ERROR
IT36253 SQLTEMPSPACE OR AGGSQLTEMPSPACE THRESHOLDS DO NOT WORK WITH ROWSTORE OLAP OPERATORS THAT SPILL TO DISK.
IT36252 ROLLBACK THE FIX OF MARIADB LENGTH(CHAR) PUSHDOWN
IT36248 INSTANCE CRASH USING WEB SERVICES WRAPPER
IT36245 SQL QUERY MAY BE SLOW WHEN USING DBMS_LOB.SUBSTR FUNCTION IN A VIEW
IT36242 ADMIN_GET_MSGS() MAY RETURN MIX OF MESSAGE UNDER RARE TIMING HOLE.
IT36236 POSSIBLE DB2BP TRAP/HANG UNDER THE EXIT() FUNCTION IF A SIGNAL IS RECEIVED.
IT36232 HANDLE THE ISSUE WHEN 'NULL' VALUE RETURNED FOR NO SHREDDER WORKER, TO AVOID A MEMBER CRASH IN PURESCALE.
IT36230 DB2 TRAP IN FUNCTION EXTRAPAYLOADITERATOR::COPYPAYLOADSTO
IT36227 PUSHDOWN ON DECFLOAT CAN RETURN -901 IN SOME CASES
IT36226 FAILURE TO BIND PORT DURING DB2START MAY RESULT IN SUCCESSFUL DB2START AND BLOCK FAILOVER IN HADR ENVIRONMENT
IT36225 HADR START SCRIPT MAY INCORRECTLY RETURN SUCCESSFUL WHEN INSTANCE IS DOWN
IT36221 INSTANCE CRASH USING WEB SERVICES WRAPPER
IT36216 TIMERTHREAD MAY HOLD COM.IBM.DB2.JCC.AM.* OBJECTS WHICH IN TURN CONTAINS LARGE ARRAYLISTS
IT36210 IN VERY RARE CASE OF CDE RIGHT OUTER JOIN PROCESSING TRAP IS POSSIBLE.
IT36207 TARGET DATABASE CAN FAIL STARTUP AFTER RESTORE INTO WHEN ACCESSING SOURCE DATABASE'S LOG FILES/TAG
IT36203 ADMIN_MOVE_TABLE WITH COPY_STATS OPTION MIGHT FAIL WITH SQL2102NRC 28
IT36201 A CLIENT MAY ABEND IN FUNCTION SQLXAPREPARECOMMIT
IT36200 A CLIENT MAY ABEND IN FUNCTION SQLXAPREPARECOMMIT
IT36199 POSSIBLE DB2FMP TRAP IN SQLQG_FMP_RUNTIME_OBJECT::GET_RSTATE_INFO() WHEN RUNNING FEDERATED QUERY
IT36192 WHEN SSL IS USED FOR HADR COMMUNICATION DB2HADRS EDU IS SPINNINGAFTER HADR GRACEFUL TAKEOVER.
IT36183 DATABASES CREATED WITH "AUTOMATIC STORAGE NO" MAY CORRUPT STORAGE GROUP FILES AFTER UPGRADE
IT36178 ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG
IT36177 WHEN USING GSSPLUGIN IBMIAMAUTH.SO CRASHES DB2
IT36172 ENGINE CRASH IN XMLRNNODEMGR::FETCHTEMPNODE()
IT36166 DATABASES CREATED WITH "AUTOMATIC STORAGE NO" MAY CORRUPT STORAGE GROUP FILES AFTER UPGRADE
IT36150 ADMIN_MOVE_TABLE CANNOT BE USED TO MOVE TABLE HAVING DOUBLE QUOTES IN NAME
IT36146 WITH ENABLESYSPLEXWLB SET TO TRUE, CONNECTION ABORT RESULTS IN
IT36141 STATS_ROWS_MODIFIES REPORTS 4294967295 FROM MON_GET_TABLE AND ADMIN_GET_TAB_INFO
IT36140 PERFORMANCE IMPACTS WITH HUGE AMOUNT OF ROW LOCKS
IT36139 PERFORMANCE IMPACTS WITH HUGE AMOUNT OF ROW LOCKS
IT36131 UNEXPECTED ERROR SEVERITY CODE 8 ERRORCODE=-4228, SQLSTATE=NULL WHEN USING PREPARED STATEMENT WITH SETARRAY METHOD
IT36128 ERROR SQL0901N IN CONCATINFO.HPP ENCOUNTERED WHILE RUNNING A QUERY
IT36113 V11.5.5 ONLY: DB2ADUTL COMMAND FAILS WITH SQL1031N IN PURESCALEON ALL MEMBERS EXCEPT MEMBER 0.
IT36108 INTERRUPTING "ALTER TABLESPACE REDUCE MAX" MAY CAUSE A MEMBER SHUTDOWN
IT36106 SQL0901 ON SELECT SAMPLE.TEST FOR SYSTEM_TIME BETWEEN
IT36104 DB2ADVIS WILL THROW A SQL0901N ON A QUERY THAT IS ORDERED BY AN EXPRESSION
IT36095 ZRC=0xFFFFFFFF=-1 error in db2diag.log when using purescale withSSL
IT36094 DB2CLUSTER -CFS -LIST -IGNOREMOUNTERROR -HOST FAILS WITH INTERNAL DB2CLUSTER ERROR
IT36093 DB2_FMP_COMM_HEAPSZ VALUES GREATER THAN 1GB NOT HONORED
IT36088 DB2CLUSTER -VERIFY MIGHT FAIL DURING RDMA PING DUE TO SEG FAULT
IT36086 DB2CLUSTER -VERIFY POTENTIAL HANG
IT36085 DB2 11.5.5 MAY ENCOUNTER SQL30082N RC 15 WHEN USING GSS_SERVER_ENCRYPT OR KRB_SERVER_ENCRYPT AUTHENTICATION
IT36077 SQL WITH A PREDICATE "X=UDF()" MIGHT CAUSE DB2 TRAP IF LENGTH(X)IS GREATER THAN LENGTH(UDF())
IT36076 EXECUTING ADMIN_MOVE_TABLE ON A TABLE WITH SOME KINDS OF STATEMENTS > 64KB SIZE, WILL RETURNED SQL0104N OR SQL1224N
IT36074 PRECOMPILER STRIPS C STYLE COMMENTS FROM SQL, CANNOT USE INLINEDOPTIMIZATION GUIDELINES
IT36060 IN RARE INSTANCES, DB2 11.5.5 MAY CRASH DURING DB2START WHEN JWTAUTHENTICATION IS ENABLED
IT36058 INSTALLFIXPACK TRIES TO EXIT MAINTENANCE MODE WHEN IT SHOULDN'T
IT36054 THE DB2MOVE COMMAND DOES NOT EXPORT PARTITIONED TABLES WHEN USED WITH OPTION: TS
IT36048 COMMUNICATION FAILURE BETWEEN DB2AGENT AND DB2FMP FOR SOME COMBINATIONS OF DATA SIZES AND APPLICATION SUPPORT LAYER HEAP SIZES
IT36046 PANIC MAY OCCUR IN HADR TAKEOVER
IT36041 ALTER TABLESPACE WITH NO FILE SYSTEM CACHING OPTION FAILS ON LINUX390
IT36027 IMPROVEMENTS TO CDE JOIN MEMORY USAGE. REDUCTION OF MEMORY NEEDED AND REDUCTION OF -955 ERRORS.
IT36026 Security: IBM Db2 is vulnerable to a DoS when a table is droppedwhile being accessed in another session (CVE-2021-29777)
IT36015 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT36014 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT36013 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT35997 SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR
IT35994 TRAP IN SQLNGREORDERAGGOPS WHEN ATTEMPTING TO COMPILE A JSON ARRAY
IT35993 ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG
IT35992 SQL0811N when there is scalar subquery with Fetch First 1 rows
IT35987 "114 ATTEMPT TO ACCESS ITEM BEYOND BOUNDS OF MEMORY" ERROR OCCURRED IN 32 BIT MODE.
IT35986 SELECT WITH GRANT FAILED TO GRANT FOR A VIEW WITH VALUES.
IT35984 A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT
IT35983 MON_GET_APPL_LOCKWAIT TABLE FUNCTION MIGHT RETURN INCORRECT 'HLD_MEMBER' IN PURESCALE
IT35979 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN USING SUBSTR
IT35976 ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG
IT35973 NESTED IN PREDICATES CAUSES -901 ERROR
IT35972 HADR STANDBY FORCE DB SHUTDOWN, DB2DIAG.LOG SHOWS OBJECT IS NOT MARKED PENDDEL
IT35969 DB2 11.5 MAY FAIL TO CREATE REBOOT SERVICE ON UBUNTU.
IT35968 WHILE QUERYING THE WEB SERVICE NICKNAME, FEDERATION SERVER REPORTS ERROR SQL1822N
IT35965 REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN
IT35964 REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN
IT35954 MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK
IT35953 INSERT FROM COMPLEX SELECT WITH ORDER BY IN DPF MODE MIGHT LEAD TO SEGV TRAP
IT35950 LEFT JOINS ARE NOT PUSHED DOWN IN A FEDERATED ENVIRONMENT
IT35949 OUT OF MEMORY: SIGNAL #11 DATABASETABLEACCESSOR::DESTROYDELETEREPLICATOR
IT35943 WRONG RESULT: QUERIES REFERENCING AN EXISTS SUB-QUERY WITH FETCHFIRST 1 ROW REFERENCED IN A CASE STATEMENT IN THE SELECT LIST
IT35936 DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATAPART FUNCTION
IT35933 SYSCODEPROPERTIES CONTINUONSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING
IT35932 POSSIBLE FMP TRAP WHEN RUNNING DB2EXPLAIN WITH A STATEMENT CONTAINING UNESCAPED NEWLINE (N) AND MULTIPLE SETS OF '(/)'
IT35926 WRONG RESULT WITH MULTIDIMENSIONAL CLUSTERING (MDC) TABLE AND ZIGZAG JOIN (ZZJN)
IT35925 DISTRIBUTION KEY ORDER IS NOT INHERITED FROM THE AS-RESULT-TABLEWHEN COISBAR IS ENABLED
IT35891 WRONG RESULT MIGHT BE RETURNED WHEN SUBSTR WITH IF ELSE CLAUSES WAS USED AND THE COLUMN WAS CREATED IN CODEUNIT32
IT35883 INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE
IT35880 DB2 11.5 PERF DEGRADATION ON LINUX: O_SYNC AND NOT O_DSYNC USED
IT35879 DB2 WAS UNABLE TO FORCE THE QUERY BECAUSE IT WAS STUCK EXECUTINGA HSJOIN
IT35877 SEVERE ERROR MESSAGE WRITTEN TO DB2DIAG.LOG WHEN ACCESSING A TABLE THAT IS IN A RESTRICTED STATE
IT35874 RARE TIMING WINDOW IN GETPARTITIONSTATSSUMMARY CAUSES DB2 SERVER/ DB2SYSC TO ABEND / TRAP
IT35864 FUNCTION GENERATE_UNIQUE() USED IN A MERGE STATEMENT RETURNS A NULL VALUE
IT35857 NO OUTPUT RETURNED USING PD_GET_LOG_MSGS OR PDLOGMSGS_LAST24HOURS ON WINDOW ENVIRONMENT
IT35855 MEMORY LEAK ENCOUNTERED WHEN YOU HAVE MORE THEN 1COLUMN OF SAME TYPE FROM TIMESTAMP/TIME/DATE WITH DB2 FORMAT SPECIFIED FOR IT
IT35853 AUDIT EVENT LOAD_TABLE EVENT STATUS 3534 FILLING UP AUDIT LOG
IT35841 THE REBIND PACKAGE COMMAND MIGHT FAIL WITH SQL0901N "COLUMN NUMBER OUT OF RANGE" ERROR.
IT35840 THE REBIND PACKAGE COMMAND MIGHT FAIL WITH SQL0901N "COLUMN NUMBER OUT OF RANGE" ERROR.
IT35833 SQL1585N is incorrectly returned for certain types of queries
IT35832 SQLCODE -1229 CONTINOUSLY WRITTEN IN DB2DIAG.LOG AFTER NODE FAILURE
IT35831 MISLEADING MESSAGE IN DB2DIAG.LOG FROM SQLRI_BUFFER_DISK_READ
IT35828 "DB2CLUSTER
IT35820 A TRAP MAY OCCUR WHEN CALLING THE ENV_GET_DB2_EDU_SYSTEM_RESOURCES FUNCTION IN RAPID SUCCESSION.
IT35819 Configure GPFS parameter failure due to MMSDRSERV PROCESS DIDN'TSPAWN AFTER CFS ENTER INTO MAINTENANCE MODE Since V11.5.4
IT35805 MULTI-THREADED DB2FMP TRAPPED IN SYBASE CALLS INTERMITTENTLY
IT35802 DB2 QUERY PLAN DOES NOT CHOOSE INDEX WHEN IN PREDICATE HAS PARAMETER MARKER.
IT35801 MISMATCH THAT THE OS HOSTNAME VALUE IS LOWER-CASED WHEREAS THE HADR_LOCAL_HOST/HADR_REMOTE_HOST VALUES ARE UPPER-CASED.
IT35800 DIAGNOSTICS DUMPING MAY HANG WHEN DUMPING PACKAGE CACHE INFORMATION
IT35798 SLOW PERFORMANCE IN DPF OR CDE WHEN RUNNING A QUERY WITH SCALAR SUBQUERIES AND AN OUTER JOIN
IT35770 OOM HIT WHILE RUNNING External Table with Netezza INTERNAL FORMAT MIGRATION.
IT35764 EXTENT MOVER CAN HANG WAITING FOR SQLO_LT_SQLB_POOL_CB__READLOTCH WHILE HOLDING SQLO_LT_SQLB_EXTENT_DESC__EXTENTLATCH
IT35758 AN OUTER JOIN QUERY MIGHT BE WRONGFULLY RE-WRITTEN TO AN INNER JOIN QUERY WHEN MQT MATCHING IS ENFORCED FOR SHADOW TABLES.
IT35750 THE FUNCTION WHICH TESTS THE 'FAILOVER' MEMBER DOES NOT TAKE SSLINTO ACCOUNT.
IT35749 UNION ALL MIGHT BEHAVE INCONSISTENT WHEN THE ORDER OF SQL'S IN IT IS CHANGED.
IT35741 SQL1585N is returned when the optimizer does not select a possible plan under some circumstances
IT35739 DB2 QUERY MAY NOT GENERATE TRAILING SPACE WHEN MINUS/EXCEPT IS USED IN THE QUERY.
IT35734 SYSCODEPROPERTIES CONTINUOUSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING
IT35728 SQL0407N WHEN COMMON SUBQUERY HAS VALUES
IT35720 PURESCALE MAY HANG WHEN THERE ARE 2 MORE CONCURRENT NODE FAILURES AND ONE OF THE NODE FAILURES CAUSES A DATABASE DEACTIVATION.
IT35719 SQL0407N WHEN COMMON SUBQUERY HAS VALUES
IT35712 PURESCALE MAY HANG WHEN THERE ARE 2 MORE CONCURRENT NODE FAILURES AND ONE OF THE NODE FAILURES CAUSES A DATABASE DEACTIVATION.
IT35710 Intermittent fast preallocation failures on AIX
IT35705 DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE
IT35695 INCORRECT HADR_TARGET_LIST CONFIGURATION IN PURESCALE CAN RESULTIN UNEXPECTED SQL1776 RC 6
IT35692 SQL0407N WHEN COMMON SUBQUERY HAS VALUES
IT35691 NO ROWCOMPESTIMATE FROM DB2INSPF OUTPUT WITH -TSI OPTION
IT35690 NO ROWCOMPESTIMATE FROM DB2INSPF OUTPUT WITH -TSI OPTION
IT35689 Query with 'ORDER BY' and referencing a common subexpression over column-organized tables may return rows in the wrong order
IT35685 Query with 'ORDER BY' and referencing a common subexpression over column-organized tables may return rows in the wrong order
IT35682 POSSIBLE FMPTRAP IN CHECK_CREATE() WHEN RUNNING DB2LOOK IF AN OBJECT GETS DROPPED WHILE THE TOOL IS RUNNING
IT35681 CLI DRIVER FAILING TO RETURN
IT35680 HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR
IT35679 UNDER CERTAIN CONDITIONS, THE "NUMBER OF ROWS ..." MESSAGE FROM INGEST UTILITY ARE INCORRECT.
IT35678 UNDER CERTAIN CONDITIONS, THE "NUMBER OF ROWS ..." MESSAGE FROM INGEST UTILITY ARE INCORRECT.
IT35672 UPDATING NETNAMES HIT ISSUE SAYING RSCT PEER IN REGISTRY DOES NOT MATCH ACTIVE DOMAIN NAME
IT35670 REGEXP_REPLACE AND REGEXP_SUBSTR WITH COLUMN-ORGANIZED TABLE MAYRESULT IN -901
IT35667 DB2DIAG.LOG MAY CONTAIN ERROR MESSAGE "ENVIRONMENT NOT GUARANTEED"
IT35663 A USER INTERRUPT DURING AN IMPLICIT REBIND WHILE OPENING A CURSOR IN A STORED PROCEDURE MAY CAUSE A TRAP
IT35662 CREATE TABLE STATEMENTS ARE HANGING DUE TO RDMA COMMUNICATION TIMEOUTS BETWEEN MEMBER AND CF ON ZLINUX
IT35610 POSSIBLE DB2BP TRAP/HANG UNDER THE EXIT() FUNCTION IF A SIGNAL IS RECEIVED.
IT35609 HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR
IT35578 HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN DISTRIBUTED TRANSACTION
IT35576 HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN A DISTRIBUTED TRANSACTION
IT35573 HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN DISTRIBUTED TRANSACTION
IT35566 MEMORY BLOCK FREED TWICE IN SQLOFMBLKEX
IT35558 SIGNAL 11 TRAPS DURING CTSNAPS AFTER ROCE CABLE PULLS
IT35553 DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG.JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT.
IT35552 CF CHANGE TO ADD BREATHING POINT FOR DAT_EVD_DEQUEUE
IT35550 BLU TABLE SELECT CAUSES INSTANCE CRASH TRAP ON WINDOWS
IT35548 HADR STANDBY FORCE DB SHUTDOWN, DB2DIAG.LOG SHOWS OBJECT IS NOT MARKED PENDDEL
IT35546 -901 SQLCODE during rebind for packages bound with certain bind options
IT35542 JAVA STORED-PROCEDURE THROWS NULLPOINTEREXCEPTION WHEN SETTING BOOLEAN OUTPUT PARAMETER
IT35538 TRAP WHEN MULTIPLE UNION BRANCHES WITH SAME TABLE
IT35521 CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS
IT35518 DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE
IT35517 DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE
IT35509 RESTORE DOESN'T PRESERVE THE ORIGINAL TABLESPACE LAYOUT LIKE THESOURCE DATABASE
IT35501 INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE
IT35494 WRONG RESULT WHEN EQUALITY PREDICATE HAS IS NOT NULL WITH FALSE ON OTHER SIDE.
IT35491 POSSIBLE TRAP FOLLOWING DB2DIAG.LOG MESSAGE "TRYING TO REGISTER AN INVALID SERVICE CLASS ID OF 0"
IT35486 DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG.JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT.
IT35485 DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE
IT35472 HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR
IT35446 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT35445 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976)
IT35444 MULTIPLE MEMORY LEAKS IN GEO-SPATIAL CALLS WHEN EXECUTING CERTAIN GEO-SPATIAL FUNCTIONS
IT35439 DB2ADV_VPC.LIC CAN MAKE Q REP FUNCTIONS AVAILABLE, IT IS NOT THEEXPECTED RESULT
IT35436 VALUE OF STATISTIC COLUMN AVGENCODEDCOLLEN IS INCORRECTLY COLLECTED DURING THE LOAD
IT35435 IMPROVE DETECTION/TOLERATION/REPORTING OF BAD INDEX PAGES.
IT35426 ON DB2/AIX, POST FROM THREAD_POST CAN BE SKIPPED/DEFERRED BY WAITER INTERRUPTED IN THREAD_WAIT , LEADING TO PANIC/SHUTDOWN
IT35418 SELECT DISTINCT STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT")
IT35416 INSERTS MAY INTERMITTENTLY RETURN SQL0289N WHILE TABLE SPACE EXTENT MOVEMENT IS IN-PROGRESS
IT35405 CAN'T CONNECT TO DB2 VIA EXCEL 2016 USING DATA --> ?GET EXTERNALDATA? WHEN UPGRADING RUNTIME CLIENT TO 11.5
IT35402 STRIPTNULLS MODIFIER IN LOAD AND IMPORT COMMANDS TRUNCATE NULLS (0X00) FROM GRAPHIC (FIXED-LENGTH) COLUMN, BUT IT SHOULD NOT
IT35400 WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATAPART TABLE ON THE INNER AND NULL KEYS.
IT35399 FEDERATED SERVER OPTION CONCURRENT_ACCESS_RESOLUTION='W' CAUSES CLI019E INVALID ATTRIBUTE ERRORS
IT35385 QUERY COULD FAIL WITH -901 WHEN MQT IS USED
IT35384 Private memory leak during DDL on column-organized tables in DPFenvironment
IT35381 NON ADMIN USER SHOULD NOT BE ABLE TO ADD A LICENSE TO THE DB2COPY ON WINDOWS
IT35380 UNION ALL MIGHT BEHAVE INCONSISTENT WHEN THE ORDER OF SQL'S IN IT IS CHANGED.
IT35377 WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATAPART TABLE ON THE INNER AND NULL KEYS.
IT35376 DB2 MIGHT CAUSE EXCESSIVE LOGGING (SQL0952N MESSAGES) WHEN A QUERY IS INTERRUPTED.
IT35318 LARGE PRIVATE MEMORY LEAK WHEN PD_GET_DIAG_HIST IS INTERRUPTED PROCESSING A LARGE DB2DIAG.LOG OR NOTIFY FILE
IT35309 DYNAMIC QUERY EXECUTION FAILS WITH SQLCODE SQL0901N REASON CODE "CONSTANT OF UNSUPPORTED TYPE"
IT35308 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35307 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35306 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35305 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35303 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025)
IT35294 Authorization errors in accessing CGTTs after a transfer owner of a SQL routine.
IT35292 SECURITY: - IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND. CVE-2020-5024
IT35291 SECURITY: - IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND. (CVE-2020-5024)
IT35290 SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND (CVE-2020-5024)
IT35289 SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND (CVE-2020-5024)
IT35270 Authorization errors in accessing CGTTs after a transfer owner of a SQL routine.
IT35265 FEDERATED QUERY COULD LEAD TO DB2 INSTANCE CRASH WITH FODC_PANICIN SQLQGINSERT
IT35257 DB2 TERMINATES ABNORMALLY COMPILING A QUERY.
IT35256 DB2 TERMINATES ABNORMALLY COMPILING A QUERY.
IT35247 DB2 11.1 DB2LOOK -PRINTDBCFG FAILS WITH SQL5066W THE DB CFG PARAMETER VALUE FOR TOKEN "SQLF_DBTN_APPLHEAPSZ"
IT35245 PROCESS CRASHES WITH SIGNAL 11 (MEMORY VIOLATIONS) WHEN APPLICATION CALLS SQLCONNECT OR SQLDRIVERCONNECT
IT35241 HOST FAILURE DETECTION TIME CAN GO OUT OF SYNC IF ADDING NEW NETWORK INTERFACES TO AN ALREADY EXISTING DB2 PURESCALE CLUSTER
IT35237 IXORING PLAN WITH ONLY PARTS OF A SUBTERM APPLIED IN A COMPLEX OR PREDICATE MIGHT RESULT IN CARDINALITY UNDERESTIMATE AT RIDSCN
IT35236 DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS.
IT35231 ONE COMPLEX QUERY TAKES VERY LONG TIME TO FINISH AFTER MIGRATINGFROM V10.5
IT35226 CREATE OR REPLACE NICKNAME ON REMOTE DB2I SERIES (AS400) FAILS WITH SQL0901 AND DUMP FOLDER FODC_APPERR IS CREATED
IT35221 WLM ADMISSION CONTROL DOES NOT PROPERLY TRACK ACTUAL MEMORY HISTORY FOR SHORT QUERIES
IT35216 OOM: REQUEST MEMORY IS FAILING UNNECESSARILY EARLY WHEN THERE ISCONTENTION TRYING TO STEAL MEMORY FROM OTHER CONSUMERS
IT35211 POSSIBLE SIGSEGV IN Q Replication due to incorrect log records for column-organized DGTT in DPF ENVIRONMENT
IT35208 DB2 : SET WRITE RESUME COMMAND HANGS
IT35200 REBIND FAILING WITH SQL0100W
IT35198 A QUERY ON COLUMNAR TABLES MAY RETURN MORE ROWS THAN EXPECTED
IT35195 ERROR OCCURS WHEN BATCH INSERT CONTAINS REGULAR RECORDS FOLLOWEDBY RECORDS WITH READONLY COLUMN USING IBM ENTITY FRAMEWORK CORE
IT35185 DB2 MIGHT TRAP IN SQLRWTABLEMETRICSBUILDER::EXECUTE DURING EXECUTION OF THE MON_GET TABLE FUNCTION
IT35183 POOR QUERY PERFORMANCE WHEN IN SUBQUERY PREDICATE WITH NO DISTINCT.
IT35182 CLEANUP OF IN-MEMORY STRUCTURE WHEN LOADING OF THE DICTIONARY FAILS (ADD CODE TO HANDLE EXCEPTIONS GRACEFULLY).
IT35180 BOOLEAN DATA TYPE GETS TRANSLATED AS SHORT-TEXT IN MS-ACCESS VIAODBC
IT35178 DB2 MIGHT ABEND WHEN EXECUTING A QUERY USING FIRST_VALUE AND REFERENCING TABLES ORGANIZED BY COLUMN
IT35165 DB_MIGRATE ISSUE WITH INTERNAL FORMAT WHEN INPUT STRING AFTER CODEPAGE CONVERSION EXCEED THE TARGET COLUMN SIZE.
IT35163 DB_MIGRATE HANGS WHEN USING ORDER BY CLAUSE
IT35161 DB2CKLOG PASSES BUT RETURNS MESSAGES APPEARING TO BE ERRORS
IT35159 DB2CKLOG PASSES BUT RETURNS MESSAGES APPEARING TO BE ERRORS
IT35158 REDUCE LIKELIHOOD OF SQL0954C FOR COLUMNAR ORGANIZED HSJN PLANS
IT35150 UNEXPECTED SQL0538 WITH NTILE BUILTIN FUNCTION
IT35124 CLASS NOT FOUND EXCEPTION: COM.IBM.DB2.INSTALL.CODEGEN.NLPACK INITIALIZER IN DB2SETUP.ERR
IT35119 RESTORE USING "NO ENCRYPT" FROM A DOWNLEVEL ENCRYPTED BACKUP IMAGE WILL RESULT IN DB STILL BEING ENCRYPTED
IT35118 POSSIBLE WRONG RESULT WITH ALWAYS-FALSE PRED OR EXISTS PRED
IT35117 DB2HAICU -DISABLE FAILS ON ZLINUX
IT35115 RESTORE USING "NO ENCRYPT" FROM A DOWNLEVEL ENCRYPTED BACKUP IMAGE WILL RESULT IN DB STILL BEING ENCRYPTED
IT35113 EVENT MONITOR ACT_EXEC_TIME WRAP AROUND AS AN INTEGER NOT AS BIGINT
IT35107 NO MESSAGE TO THE ADMINISTRATION NOTIFICATION LOG FOR DEADLOCKS WHEN MON_LCK_MSG_LVL IS SET TO 2 OR HIGHER
IT35101 SQL0901N IN GETJOINPAYLOADEVALUATOR.CPP:152
IT35086 SQL2536W DURING BACKUP
IT35085 DB2 SERVER MAY TERMINATE ABNORMALLY WITH SQLDCSL_BADPAGE "BAD DATA PAGE"
IT35082 High CPU and decreased performance with high concurrency of index creation (on TEMP TABLES)
IT35075 SELECTING FROM AN EXTERNAL TABLE THAT USES LFINSTRING ON CAN FAIL WITH SQL5199N
IT35071 RESTORE DOESN'T PRESERVE THE ORIGINAL TABLESPACE LAYOUT LIKE THESOURCE DATABASE
IT35070 QUERY EXECUTION FAILS WITH -901 "SQLRIDERIVEDUMMY FUNCTION SHOULD NEVER BE ACTUALLY CALLED"
IT35069 SELECT-STATEMENT INCORRECTLY RETURNS SQL20264N DURING EXECUTION
IT35068 DROP PACKAGE FAILS WITH SQL0553N WHEN "PL/SQL SUPPORT" IS ENABLED
IT35067 SQLCOLUMNS CLI FUNCTION MAY NOT WORK ON A TABLE NAME THAT INCLUDES MBCS CHARACTERS
IT35066 LPAD OR RPAD BUILTIN FUNCTION FAIL WITH
IT35065 Basic predicate "DECFLOAT != BIGINT" results in poor query performance
IT35064 DESCRIBE VIA ADMIN_CMD CAN SOMETIMES GIVE WRONG COLUMN ORDER.
IT35063 JDBC DatabaseMetaData.getTableTypes missing SYNONYM
IT35062 CREATING AN EXPRESSION-BASED INDEX FAILS WITH
IT35061 WHEN A USER ID WITH INSUFFICIENT PRIVILEGE ATTEMPTS TO RUN REORGFROM WITHIN A STORED PROCEDURE, THE STORED PROCEDURE RETURNS RC
IT35060 BOOLEAN PREDICATES RETURN WRONG RESULT WITH NULL INPUT
IT35059 LPAD, RPAD or REPLACE may result in SQLCODE
IT35058 SUBSTR IN COLUMN ORGANIZED COLUMN COMPARISON RETURN WRONG RESULTS
IT35057 WHEN A USER ID WITH INSUFFICIENT PRIVILEGE ATTEMPTS TO RUN REORGFROM WITHIN A STORED PROCEDURE, THE STORED PROCEDURE RETURNS RC
IT35056 CREATING AN EXPRESSION-BASED INDEX FAILS WITH -356 AND EMPTY REASON CODE
IT35055 DB2 SERVER TERMINATES ABNORMALLY WHEN AUTO_REVAL=DEFERRED_FORCE
IT35047 POOR UPDATE PERFORMANCE AFTER MIGRATING TO V11.5.4
IT35045 PACKAGE CONTAINING XML FUNCTIONS MAY RESULT IN -901 WHEN REBINDING WITH APREUSE
IT35043 SQL0901N ERROR MAY OCCUR WHEN COMMON TABLE EXPRESSION HAS "SYSPUBLIC" SCHEMA NAME
IT35033 CUSTOMERS ENCOUNTERING ASN0569E DUE TO OUT-OF-ORDER REPLICATION LOG RECORDS DURING SAVEPOINT ROLLBACK
IT35030 DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER
IT35029 DB2 MAY INCORRECTLY INCREMENT ROLLBACK_SQL_STMTS AND TOTAL_APP_ROLLBACKS MONITOR ELEMENTS WHEN CALLING AUTONOMOUS PROCEDURES
IT35021 High CPU and decreased performance with high concurrency of index creation (on TEMP TABLES)
IT35017 CDE JOIN MINMAXINFO DUMP: TRAP DUE TO DEREFERENCING NULL POINTER
IT34998 DB2 CAN CRASH DURING COMPILATION IF THE SAME EXPRESSION IS USED IN BOTH AN EQUALITY JOIN PREDICATE AND AN EXPRESSION-BASED INDEX
IT34991 QUERY WITH OLAP MIGHT FAIL WITH SQL0955C IN CDE
IT34987 DB2ADVIS WILL THROW A -901 ON A QUERY THAT IS ORDERED BY AN EXPRESSION
IT34970 ABNORMAL TERMINATION OF DATABASE WITH "ERROR DURING LOG PAGE VALIDATION." FROM SQLPGWLP, PROBE:390.
IT34966 SECURITY: DB2 EXTERNAL TABLE CREATION IS VULNERABLE TO RACE CONDITION ATTACK (CVE-2020-4885)
IT34964 SECURITY: IBM DB2 IS VULNERABLE TO AN ARBITRARY FILE OVERWRITE (CVE-2020-4945)

© Icons by Mark James www.famfamfam.com

invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Feature RequestFeature Request

Feature Request

Release NotesRelease Notes

Release Notes

Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service and SupportService and Support

Service and Support

IBM Db2 for purchasersIBM Db2 for purchasers

IBM Db2 for purchasers

IBM Software for ISVsIBM Software for ISVs

IBM Software for ISVs

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.