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
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
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
IT36527 DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET
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
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 -901 WHEN IMPLICITLY CASTING NON-STRING TO A STRING AND THE ENVIRONMENT DEFAULT STRING UNITS ARE CODEUNITS32.
IT36493 DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT.
IT36476 HANG DURING INSERT FROM NODES SENDING HISTOGRAMS
IT36473 TRUNCATE TABLE WITHOUT IMMEDIATE ON CDE TABLES WITH DELIMITED IDENTIFIERS FAILS
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 - INVALID FEDERATED THREE PART NAME
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
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.
IT36408 INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS
IT36401 901-COLUMN NUMBER OUT OF RANGE DURING QUERY COMPILATION, FORM_CSE CALL STACK
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 -913
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.
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
IT36331 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTINGTO DATABASES CAN LEAD TO INSTANCE ABEND
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()
IT36276 UNEXPECTED SQL0206N FROM FEDERATED VIEW USING WITH CLAUSE.
IT36275 UNCATALOG SYSTEM ODBC DATA COURCE 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
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
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
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 -913 UNDER GLOBAL TRANSACTION WORKLOAD
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 -901 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 -901 ON A QUERY THAT IS ORDERED BY AN EXPRESSION
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
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 TRAP IS OCCURRING IN SQLDDELTCB WHEN USING A CGTT TABLE IN AN ANONYMOUS BLOCK.
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 JASON 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
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 QUERIES REFERENCING AN EXISTS SUB-QUERY WITH FETCH FIRST 1 ROW REFERENCED IN A CASE STATEMENT IN THE SELECT LIST MAY RESULT IN I
IT35936 DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATAPART FUNCTION
IT35933 SYSCODEPROPERTIES CONTINUONSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING
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
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 -CFS -SET -OPTION CCRENABLED -VALUE NO" COMMAND TIMES OUT
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
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. THIS SHO
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 CONTINUONSLY 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 DB2/TRACKER/ISSUES/4662 CDE WRONG RESULTS ON S BUILD (ROWS IN WRONG ORDER); ASSERTION FAILURE ON N BUILD
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 -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS
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.
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
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.
IT35309 DYNAMIC QUERY EXECUTION FAILS WITH SQLCODE -901 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 -901 "VALUE IS TOO LARGEFOR THE BUFFER"
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 -356 AND EMPTY REASON CODE
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 -901 when source-string references a column-organized table column
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.
IT34960 DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS.
IT34956 NLJN cannot be pushed down
IT34955 PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING
IT34941 QUERY ON NICKNAME RESULTS with VALUES TRUNCATED on MARIADB
IT34940 WRONG RESULT WHEN EQUALITY PREDICATE HAS IS NOT NULL WITH FALSE ON OTHER SIDE.
IT34936 HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLEAND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES
IT34931 PREFETCHERS INFINITELY LOOPING IN SQLBSERVICELEAFREQUEST
IT34929 ADD ENVVAR TO OVERRIDE WINDOWS COMMONAPPDATA PATH
IT34928 DB2 MAY PANIC DURING ForceDBShutdown
IT34924 DB2DART AND INSPECT COMMANDS FOUND ERROR TYPE VARIABLE-LENGTH DATA AT OFFSET XXXX IS READ INCORRECTLY. THE EXPECTED OFFSET IS 0
IT34919 THE OPTIMIZER MAY CHOOSE A SUBOPTIMAL PLAN FOR QUERY WITH MULTIPLE CORRELATED SCALAR SUBQUERIES WHEN USING GREEDY JOIN ENUM
IT34916 APPLYING DB2 V11.5 FIX PACK FOR WINDOWS TO V11.5 GA LEVEL FAILS WITH 'ERROR APPLYING TRANSFORMS.' IN NON-ENGLISH LOCALE.
IT34913 SQL1227N ERROR WITH RC 11 WHEN RESETTING AVGPARTITION_CLUSTERRATIO COLUMN VALUE DURING INDEX STATS RESET.
IT34912 NEW OPTION FOR DB2LOOK -M NOT TO GENERATE RESET INDEX AND COLUMNSTATS IN THE OUTPUT VIA NEW ENVIRONMENT VARIABLE
IT34911 APAR IT17532 INTRODUCED RESET OF COLUMN STATS IN DB2LOOK MIMIC OUTPUT, CAUSING LOCKING BEHAVIOUR WITH ONLINE RUNNING APPS.
IT34910 CRASH IN UPLUG_INIT_44_DB2
IT34885 SIMPLIFIED SSL CONNECTIONS MAY FAIL WITH GSKIT ERROR 414 WHEN A STASH FILE IS IN USE
IT34884 SIMPLIFIED SSL CONNECTIONS MAY FAIL WITH GSKIT ERROR 414 WHEN A STASH FILE IS IN USE
IT34883 INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL
IT34882 INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL
IT34881 GSKKM_StoreCACert: GSKit Error = 100 errors in db2diag.log
IT34871 USING WRONG DELIMITER MIGHT CAUSE THE INSTANCE CRASH
IT34869 DB2PD -DBPTNMEM CAN CRASH IF USING USING MEMBER NUMBERS GREATER THAN 9
IT34866 ADDITIONAL FIX TO APAR IT13674, TEST FOR -NOEXEC MOUNT INCORRECTLY FAILS IN DB2SETUP SCRIPT
IT34860 DB2 QUERY MAY HANG WITH REGISTRY SETTING DB2_EXTENDED_OPTIMIZATION="INJ_DUMMY_PRD4JOIN"
IT34853 JAVA EXTERNAL ROUTINE MIGHT RETURN TRUNCATED CLOB
IT34852 WHEN REMOVING LICENSE, THE CORRECT ITLM TAG IS NOT CONVERTED BACK TO .DB2TAG FILE.
IT34844 DB2LOOK -XD DOES NOT SHOW ALL DATABASE AUTHORIZATION STATEMENTS GRANTED AT DATABASE CREATION TIME
IT34794 CLONE OPERATION MAY FAIL AFTER INITIAL CONFIGURATION OF THE CLONE HOST USING SETUP__UI.SH
IT34787 MON_UOW_EXECLIST CONSUMES MONHEAP EVEN WHEN OFF
IT34786 ACTIVATE COMMAND UNABLE TO START HADR DUE TO CLIENT CONNECT SESSION TERMINATED
IT34779 DURING RESTORES SPECTRUM PROTECT SNAPSHOT SHOWS FMM0644E ERROR VARYONVG: THE VOLUME GROUP IS ALREADY VARIED ON IN OTHER NODE
IT34775 SQL STATEMENT CALLING NTILE FUNCTION FAILS WITH : -901 BAD DYN INDEX. IDX=4294967294 SIZE=87 (OFF=5)
IT34774 For special queries DISTINCT is pulled up above the UNION level in the optimized statement, what may cause wrong results
IT34771 DB2GETROWPARTNUM() API RETURNS WRONG RESULT FOR BINARY/VARBINARYCOLUMN AND NULL VALUE
IT34768 DOTNET APPLICATION CRASHES WITH ACCESSVIOLATIONEXCEPTION FOR ARRAY INSERT WHEN DB2TRC IS ON
IT34765 JCC returns UNKNOWN SQL TYPE (-100008) for SYS_REFCURSOR Output parameter for stored procedure
IT34764 SLOW PERFORMANCE IN REGULAR EXPRESSION FUNCTIONS ON BIG ENDIAN PLATFORMS
IT34758 SELECT DISTINCT QUERY FAILS WITH SQL0421 WHEN USED WITH SCROLLABLE CURSOR
IT34755 DB2 MAY RETURN SQL0901N WITH ERROR MESSAGE "UNEXPECTED ERROR AT MINMAXPARTIALEVALUATOR.CPP"
IT34748 UPDATE STATEMENT SLOW PERFORMANCE CAUSED BY LATCH CONTENTION DURING THE MEMORY ALLOCATIONS.
IT34740 INSPECT ON A COLUMN-ORGANIZED SYNOPSIS TABLES MIGHT FAIL WITH FODC_APPERR
IT34731 RUNSTATS ON KEY COLUMNS SET PROFILE ON COLUMN-ORGANIZED TABLE WITH NO INDEXES MIGHT LATER LEAD TO SQLCODE -901
IT34723 TRAP/PANIC DURING SQLU_REGISTER_TABLE_UNLOAD ON CDE TEMPORAL TABLE
IT34721 SELECT DISTINCT QUERY FAILS WITH SQL0421 WHEN USED WITH SCROLLABLE CURSOR
IT34719 DECIMAL FUNCTION ON COLUMN-ORGANIZED TABLE MIGHT FAIL WITH SQL0413N
IT34715 MISSING INFORMATION IN DB2DIAG.LOG WHEN USERID AND PASSWORD ARE CORRECT, BUT THE USER IS REVOKED/DISABLED/LOCKED
IT34714 [MVP]CDE query which has "LIMIT 1"  or "FETCH FIRST 1 ROW ONLY" clause can be hang
IT34702 LOAD MIGHT HANG AFTER HITTING SQL0359N IDENTITY COLUMN VALUE EXHAUSTED
IT34701 FAILBACK PING INCORRECTLY USES TCPIP INSTEAD OF SSL
IT34697 DB2BATCH FAILS TO CAPTURE MONITORING STATISTICS FOR REMOTE INSTANCES IN A KERBEROS ENVIRONMENT
IT34696 MEMORY CRASH/TRAP WITH LOCAL PREDICATE ON OJ SUBSELECT
IT34693 DB2UNINS OF DATA SERVER CLIENT REMOVES SHARED C++ REG KEYS
IT34672 PLAN with EARLY_OUT NLJOIN AND CTQ IN THE INNER CAN HANG IN COMPLEX SCENARIOS.
IT34671 MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK
IT34670 ACCESSING HIDDEN COLUMNS WITH FEDERATION RECEIVES SQL0206N
IT34668 INSERT INTO COLUMN-ORGANIZED TABLE FROM COMPLEX SUBSELECT CAN TRAP DURING QUERY OPTIMIZATION
IT34658 DB2 QUERY MAY GENERATE FODC AND APP_ERR OR WRONG RESULT IN CERTAIN CONDITIONS
IT34655 A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP
IT34654 WARNING MESSAGES ARE GETTING LOGGED AS SEVERE MESSAGES
IT34634 ENHANCEMENT: DB2IUPDT CHECKS ROOT USER'S .PROFILE HAS DB2PROFILE
IT34619 ENHANCEMENT: SETUP.EXE CHECKS CURRENT DIRECTORY NAME WHETHER IT HAS SPACE(S) OR NOT ON WINDOWS
IT34615 THE DB2CLI COMMAND OR EXCEL MAY CRASH (PROGRAM STOPS WORKING) INFULL DB2 CLIENT WHEN USING A DSN FOR CONNECTION
IT34614 SECURITY: SEVERAL BUFFER OVERFLOW VULNERABILITIES AFFECT DB2
IT34613 INCORRECT RESULTS WITH DB2_EXTENDED_OPTIMIZATION='MQTENFORCE REPLICATED'
IT34609 QUERY SUCCCEED BUT GET ERROR MESSAGE WINNING PLAN STILL NEEDS GLUE IN DB2DIAG.LOG
IT34608 INCORRECT OUTPUT OF INQUIRE_DETAIL_CLONE COMMAND IN MULTI-NODE DB2 DPF ENVIRONMENT
IT34607 DB2CFIMP ADDS TRAILING CHARACTERS TO DB ALIAS.
IT34606 USING CFGREFRESHINTERVAL IN A MULTI-THREADED CLI APPLICATION LEADS TO SEGMENTATION FAULT
IT34602 Reorg start time unexpectedly updated during reorg reclaim extents on an ITC
IT34589 ON WINDOWS PLATFORM CLIDRIVER CAN LOG SQL1531N DURING CONNECT EVEN WHEN CONNECTION IS SUCCESSFUL WITH SQL_SUCCESS_WITH_INFO
IT34588 SQL30090N WHEN WE USE UPDATE WITH PLACEHOLDER (VARIABLE) VIA JDBC
IT34587 DB2TRC FMT -CLI CRASHES ON WINDOWS FOR SQLFREEHANDLE API
IT34585 DB2STOP FAILED WITH TIMEOUT WHEN MULTIPLE SEGMENTS FOR DBMS SET ARE ALLOCATED AND SQLO_ADDR_CONFLICT IS REPORTED BY DB2WDOG
IT34579 DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY WILL FAIL WITH SQL2079N ERROR
IT34560 DB2 ENGINE ABEND FOLLOWING DROP TABLE AND SQLBPREPARE2FREEEXTONTEMPSMP SEVERE ERROR
IT34559 ELEMENT ALLOCATION ISSUE, TRAP ON FUNCTION "ibm_cde::query::EvaluationRoutine::getQueryLiteral"
IT34556 FEDERATION FMP COMMUNICATION BUFFER CAUSES "SQL10003C THERE ARENOT ENOUGH SYSTEM RESOURCES TO PROCESS THE REQUEST
IT34547 DIA8550C MESSAGES FILLING UP DB2DIAG.LOG WHEN LOG PATH IS MAPPEDTO AN UNC PATH in Windows environment
IT34539 TWO PHASE COMMIT SQL0901N
IT34534 Db2 Administrative Task Scheduler stops executing scheduled tasks
IT34517 Newly created tablespace is missing on HADR standby due to disk full during replay
IT34510 DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION
IT34504 GSKKM_StoreCACert: GSKit Error = 100 errors in db2diag.log
IT34500 REORG RECLAIM CODE CAN LEAD TO DEADLATCH
IT34483 HADR STANDBY ENTERS AN INFINITE LOOP BETWEEN READ FROM MEMORY AND READ FROM DISK WHEN ENCOUNTERING A LOG FILE WITH CORRUPTED XHD
IT34474 SECURITY: SEVERAL BUFFER OVERFLOW VULNERABILITIES AFFECT DB2
IT34472 SECURITY: SEVERAL BUFFER OVERFLOW VULNERABILITIES AFFECT DB2
IT34469 CLIENT GETS -901 DTS MISMATCH BETWEEN REQUEST AND CACHE INSTEAD OF -910
IT34465 DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION
IT34443 A COLUMN MASK DEFINED ON A COLUMN WITH STRING LENGTH UNIT CODEUNITS32 MAY RESULT IN SQL20478N
IT34440 ABNORMAL TERMINATION WHEN EXECUTING THE CREATE-STATEMENT OF A NZPLSQL STORED PROCEDURE
IT34432 FAILBACK PING INCORRECTLY USES TCPIP INSTEAD OF SSL
IT34429 CRASH SIGNAL#11 SQLEHDIR__FP8SQLE_BWA IN DB2 V11.1.4.5
IT34425 HANGING QUERY IN CLOB TYPE STATEMENTS
IT34418 QUERY INTERRUPT DOES NOT RETURN SQL0952N WHEN A WLM THRESHOLD WAS CREATED
IT34417 QUERY INTERRUPT DOES NOT RETURN SQL0952N WHEN A WLM THRESHOLD WAS CREATED
IT34398 GET DB CFG FOR CAN FAIL IF GATEWAY CATALOGS TARGET DB WITH DIFFERENT NAME
IT34397 A MERGE STATEMENT CAN FAIL WITH AN SQL0901N: REASON (UNEXPECTEDERROR AT TSNRANGEITERATOR.CPP:841)
IT34396 PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING
IT34395 HADR GRACEFUL TAKEOVER FAILED DUE TO XML DICTIONARY CREATION ON PRIMARY THAT CANNOT BE FORCED OFF IN A TIMELY MANNER
IT34393 HADR GRACEFUL TAKEOVER FAILED DUE TO XML DICTIONARY CREATION ON PRIMARY THAT CANNOT BE FORCED OFF IN A TIMELY MANNER
IT34384 DB2PREREQCHECK CHECKS FOR JAVA, BUT WE BUNDLE JAVA WITH DB2
IT34382 POOR PERFORMANCE WHEN IN-LIST TO JOIN CAUSING EARLY COMPENSATION
IT34381 A DEADLOCK MAY RESULT WHEN MULTIPLE APPLICATIONS CONCURRENTLY INSERT INTO A COLUMN-ORGANIZED TABLE WITH AN IDENTITY COLUMN
IT34356 FMP TRAP WHILE USING -FORMAT INTERNAL DUE TO SCHEMA MISMATCH
IT34352 DURING START DB2DIAG.LOG MAY BE FLOODED WITH "NO HADR RESOURCE DEFINED" INFO MESSAGES IN AN ACTIVE-PASSIVE TOPOLOGY
IT34348 .NET DRIVER CRASH DUE TO A TIMING HOLE
IT34347 MONTHS_BETWEEN FUNCTION IN NPS MODE RETURN NEGATIVE
IT34327 USING ODBC ADMINISTRATOR FOR DB2 CLI ODBC DRIVER WITH SSL FOR A DSN THROWS SQL1042C ERROR ON TEST CONNECT
IT34317 SECURITY: DENIAL OF SERVICE CONDITION INSIDE THE "DB2 MANAGEMENT SERVICE"
IT34316 SECURITY: DENIAL OF SERVICE CONDITION INSIDE THE "DB2 MANAGEMENT SERVICE"
IT34315 SECURITY: DENIAL OF SERVICE CONDITION INSIDE THE "DB2 MANAGEMENT SERVICE" (CVE-2020-4642)
IT34314 SECURITY: IBM® Db2® is vulnerable to a Denial of Service on Windows (CVE-2020-4642)
IT34311 Query with alias for complex column used in group by clause traps and generates FODC
IT34308 REPLICATED MQT MATCH MAY FAIL IN SOME SPECIFIC SITUATIONS
IT34306 OPTIMIZER USES QUANTILE STATS FOR UNIQUE COLUMNS TO COMPUTE THE EQUALITY PREDICATE FILTER FACTOR WHICH LEADS TO OVER-ESTIMATION
IT34304 SQL0344N ERROR MAY OCCUR IN NON-UNICODE, VARCHAR2 ENABLED DATABASE WHEN QUERY REFERENCES SYSIBM.SYSDUMMY1 or SYSIBM.DUAL
IT34294 SECURITY: IBM Db2 is vulnerable to a Denial of Service on Windows (CVE-2020-4642)
IT34284 SORT MEMORY HARD CAPPING AND OVER-ESTIMATION ERROR CORRECTION FIXES IN WLM
IT34280 CREATE TABLE FAILING WITH "NO MEMORY AVAILABLE IN 'APPLICATION HEAP'
IT34261 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTINGTO DATABASES CAN LEAD TO INSTANCE ABEND
IT34257 DB2 WLM MAY CAUSE UNNECESSARY QUEUING AFTER INSERTS TO EXTERNAL TABLES IN A PARTITIONED DATABASE
IT34250 901/TRAP WHEN DB2 QUERY HAS GROUP BY AND OJ WITH UNION
IT34243 DB2CLUSTER -CFS -COMMIT FAILS, INSTALL SHOULD GENERATE A WARNING
IT34242 BAD PERFORMANCE DUE TO DELAYED JOIN PREDICATE PUSHDOWN THROUGH UNION ALL PREVENTS JOIN ELIMINATION
IT34241 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT
IT34240 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT
IT34239 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT
IT34238 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT
IT34235 IMPROVE PERFORMANCE BY IMPLEMENTING SCALAR FUNCTIONS DAYOFMONTH,DAYS_TO_END_OF_MONTH IN COLUMNAR ORGANIZED LOGIC.
IT34227 ADMIN_CMD and GET_DB_CONFIG cannot handle extended number range of LOGBUFSZ
IT34224 DB2CLUSTER -CFS -COMMIT FAILS, INSTALL SHOULD GENERATE A WARNING
IT34222 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE
IT34221 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT
IT34197 DB2 MIGHT REPEATEDLY REPORT ISSUS IN SQLSMERGEREC
IT34196 DB2 MIGHT REPEATEDLY REPORT ISSUS IN SQLSMERGEREC
IT34193 DB2 SERVER TERMINATES ABNORMALLY IN RECURSIVE_QGM
IT34190 DB2EGCF MAY CAUSE TRACE FLOODING DUE TO MEMORY SEG FAULT
IT34184 DB2 CRASHED FOR C0000005 EXCEPTION ON SQLV_CHR_2_NUM
IT34177 SLOW DATABASE ACTIVATION.
IT34161 DB2ADUTL DELETE LOGS WITHOUT PROMPTING" DELETES LOGS ONE BY ONE AND THEREFORE SLOWER THAN DELETING LOGS IN BATCHES.
IT34156 ALLOW FMP POOLING FOR SPECIFIC USER IDS
IT34151 USING PIPE INTERFACE DURING UNLOAD OPERATION IF PIPE IS USED
IT34147 VARIOUS ERROR POSSIBLE: SQL0901N , SQL0955N
IT34146 INTERMITTENT POOR PERFORMANCE WHEN WRITING TO DB2 TRANSACTION LOG FILES.
IT34140 SQL20569N WITH REASON CODE "4" DURING LOADING LZ4 COMPRESSED
IT34115 Registry variable controls for query transformations involving scalar sub-queries and common table expressions
IT34112 DB2BP TIMEOUT FOR LARGE UID
IT34111 INSERTS MAY INTERMITTENTLY RETURN SQL0289N WHILE TABLE SPACE EXTENT MOVEMENT IS IN-PROGRESS
IT34110 -901 SQLCODE (CANNOT FIND CURSOR INFO IN ERT) FOLLOWED BY TRAP
IT34109 CLPPLUS SSL PORT support to LDAP SERVER through DB2DSDRIVER.CFG
IT34108 NLJN not pushing down
IT34107 HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLEAND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES
IT34104 DB2 QUERY MAY HANG WITH REGISRTY SETTING INJ_DUMMY_PRD4JOIN
IT34102 CURSOR-BASED UPDATE OR DELETE OF ROWS ON A TABLE WITH A RCAC DEFINED MAY LEAD TO A TRAP
IT34100 REDIRECT RESTORE FAILS AFTER SET TABLESPACE CONTAINERS USING AUTOMATIC STORAGE
IT34078 DB2 MAY NOT GENERATE TRAILING SPACE AFTER GROUP BY
IT34063 BOOLEAN PREDICATES RETURN WRONG RESULT WITH NULL INPUT
IT34049 NEW BCD DIVISION IMPLEMENTATION FOR ROW BASED DECIMAL
IT34039 TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS FOR CDE TABLE MAYRESULT IN DEADLOCK IN DPF ENVIRONMENT.
IT34037 DEADLATCH BETWEEN ONE THREAD WRITING A DICTIONARY TO DISK USING VECTORIZEDADC AND ANOTHER THREAD DOING A NEW EXTENT ALLOCATION
IT34026 INSTANCE COULD GO DOWN WHEN DOING A FULL OUTER JOIN ON TWO COLUMNAR ORGANIZED TABLES WITH NULL COLUMNS
IT34023 FODC_PANIC WITH INVALID LATCH FROM SQLOLATCHCAS64.C WHEN ROUTINEEXECUTION LIST MONITORING IS ENABLED.
IT34022 DB2 MIGHT TRAP WHEN EXECUTING MON_GET_UNIT_OF_WORK
IT34007 DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE.
IT34006 DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE.
IT34005 DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE.
IT34000 An error during creating a system temporary table can lead to a database crash
IT33995 POPULATED STATISTICS WERE NOT CLEANED UP AFTER ALTER TABLE ALTERCOLUMNS
IT33994 DB2 MAY HANG SHORTLY AFTER COMMITTING A CREATE TABLE WITH AN AGENT WAITING FOR SQLO_LT_SQLD_TCB__LOADINPROGRESS LATCH IN SQLBFIX
IT33977 DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE.
IT33973 APPLICATION IN UOW EXECUTING USING HASH JOINS MAY HANG AND COULDNOT BE FORCED OFF
IT33965 FODC_PANIC WITH INVALID LATCH FROM SQLOLATCHCAS64.C WHEN ROUTINEEXECUTION LIST MONITORING IS ENABLED.
IT33960 SQL0206N OR SQL0901N ON STANDBY AFTER ALTER TABLE ADD COLUMN ON PRIMARY WHEN HADR IS STOPPED
IT33957 SQL1013N WHEN RUNNING 'DB2 GET DB CFG' ON REMOTE DB CONNECTION WITH DB2DSDRIVER.CFG
IT33956 DB2CLUSTER -CFS -COMMIT FAILED WITH 6027-1257 ERROR
IT33955 DB2 WILL RETURN -901 WHEN CASTING SUBSTRING WITH MIN(TO_CHAR) TOA VARCHAR.
IT33954 SQL0206N OR SQL0901N ON STANDBY AFTER ALTER TABLE ADD COLUMN ON PRIMARY WHEN HADR IS STOPPED
IT33902 INTERMITTENT FAILURE WITH CLR_EXCEPTION_SYSTEM.OBJECTDISPOSEDEXCEPTION
IT33889 NO MESSAGE TO THE ADMINISTRATION NOTIFICATION LOG FOR DEADLOCKS WHEN MON_LCK_MSG_LVL IS SET TO 2 OR HIGHER
IT33888 NO OPTION TO CONFIGURE CLI KEYWORD SSLSERVERCERTIFICATE VIA MICROSOFT ODBC ADMINISTRATOR
IT33885 Db2 may attempt to repeatedly open a non-existent file which mayimpact query compilation performance
IT33871 DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE
IT33870 SQL901 WHEN SUBQUERY PREDICATE USED WITH OUTER JOIN
IT33866 ANONYMOUS BLOCK WITH A CALL TO A PROCEDURE MAY FAIL WITH A SQLCODE OF -901
IT33865 HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLEAND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES
IT33863 PURESCALE MEMBER MIGHT HANG WAITING FOR SQLO_LT_SQLB_BPD__BPDLATCH_SX WHILE IN SQLBGBUPGRADELATCHFROMSHAREDURINGWAR
IT33851 TSA INITIATED TAKEOVER IN AN AUTOMATED HADR ENVIRONMENT MAY FAILDUE TO PEER WINDOW HAVING EXPIRED.
IT33841 ALLOW FOR DB2MEMDBG SETTING : DB2SET DB2MEMDBG=W:16,S:12:10485760:1:W:20:T
IT33836 PURESCALE MEMBER MIGHT HANG WAITING FOR SQLO_LT_SQLB_BPD__BPDLATCH_SX WHILE IN SQLBGBUPGRADELATCHFROMSHAREDURINGWAR
IT33826 LIST STORAGE ACCESS command gives 0 entries even if the catalog storage access completed successfully
IT33825 POSSIBLE INCORRECT RESULTS WHEN FEDERATION THREE-PART NAME IS USED IN A SCALAR SUB-QUERY
IT33824 LIST STORAGE ACCESS command gives 0 entries even if the catalog storage access completed successfully
IT33822 HANG IN WHERE ALIAS DUE TO CYCLIC REFERENCE.
IT33815 REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR
IT33814 REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR
IT33810 INVALID LICENSE ERROR USING DB2 CONNECT LICENSE WITH .NET CLI DRIVER ON OPENSHIFT CONTAINER
IT33805 WRONG RESULT/901 WHEN IN USED ON SELECT
IT33790 DB2AUTOSTART DOES NOT WORK ON REBOOT WHEN OS REBOOT IS VERY FAST.
IT33783 DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -t / -H (time period specifiers)
IT33761 REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR
IT33740 CREATE EXTERNAL TABLE USING SAMEAS/LIKE WITH BASE TABLE HAVING HIDDEN COLUMN IS GETTING CREATED WITH HIDDEN COLUMN
IT33735 IBM SPECTRUM PROTECT SNAPSHOT MAY MODIFY COPY RATE SETTING OF FLASHCOPY PAIRS NOT UNDER ITS CONTROL
IT33731 DB2 NSE INDEX UPDATES MAY FAIL WITH ERROR CTE0310

© 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.