invispix 10x10

DB2 - Solutions to problems

36783801-107x160Here 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
IT27292DBM CFG PARAMETER ASLHEAPSZ DEPENDS ON RULE "QUERY_HEAP_SZ >= ASLHEAPSZ"
IT27274DBM CFG PARAMETER ASLHEAPSZ DEPENDS ON RULE "QUERY_HEAP_SZ >= ASLHEAPSZ"
IT27252NOT ABLE TO FORM HADR CONNECTION AFTER TAKEOVER WHEN PURESCALE HADR STANDBY MEMBERS ON SAME HOST HAVE THE SAME HADR_LOCAL_SVC
IT27242LOGARCHMETH2 OFF NOT UPDATED ON HADR STANDBY
IT27228DB2 WINDOWS INSTALLATION CRASHES IF THE INSTALLING USER BELONGS TO A LARGE NUMBER OF LOCAL/GLOBAL GROUPS.
IT27221DB2 : MISSING DATA ON QUERY WITH CURRENTLY COMMITTED FEATURE, WHEN SUCH QUERY IS EXECUTED IN THE MIDDLE OF COMMIT PROCESSING
IT27216PERFORMANCE REGRESSION IN BLU QUERIES CONTAINING JOIN ON VARCHARCOLUMNS ON AIX
IT27202SPECIFIC MQT DEFINITION MAY LEAD TO DB2 ABEND WITH SIG11
IT27198DB2START CREATES A SEVERE MESSAGE IN DB2DIAG.LOG FOR INSTANCE ALREADY RUNNING ON WINDOWS
IT27178TIMING ISSUE IN PACKAGE CACHE WORKSPACE MAY CAUSE PANIC
IT27170REMOVE SERVICE PASSWORD REQUIREMENTS FOR DB2TRC ON -DEBUG DB2.SQLCC.SQLCCTCPCONNMGR_CHILD.115 -SUSPEND COMMAND
IT27157NOT ABLE TO FORM HADR CONNECTION AFTER TAKEOVER WHEN PURESCALE HADR STANDBY MEMBERS ON SAME HOST HAVE THE SAME HADR_LOCAL_SVC
IT27130DB2 MAY COPY SELECTIVITY WHEN A SELECTIVITY CLAUSE IS USED ON A LOCAL PREDICATE WHOSE COLUMN IS ALSO IN A JOIN PREDICATE
IT27110DB2ACD/JITS RUNSTATS MAY CAUSE LOCK WAIT DUE TO NOT RELEASING EXCLUSIVE CATALOG CACHE LOCK
IT27094CMMVC6369W SVC LICENSED CAPACITY WARNING CAUSES UNMOUNT OPERATIONS WITH DYNAMIC TARGET ALLOCATION TO ABORT
IT27081SAP: SUBOPTIMAL PERFORMANCE FOR QUERIES WITH INEQUALITY PREDICATES ON COLUMNIZED TABLES
IT27078MEMORY ALLOCATED BY A MONITOR FUNCTION ON STANDBY MIGHT NOT BE FREED UP AND MIGHT LEAK AFTER DATABASE IS DEACTIVATED/TAKEOVER
IT27067HANG MAY OCCUR WITH COLUMN ORGANIZED QUERY IN DPF ENVIRONMENT WHERE AGENT CANNOT BE FORCED
IT27044DB2 MAY HANG IN ACCESSING GLFH FILE WHEN USING MULTIPLE CONCURRENT IMPORT IN DPF
IT27040AUTOMAINT_SET_POLICYFILE DOESN'T REPORT ERROR WHEN FILTERCLAUSE SPECIFIED IS TOO LONG
IT27039DB2 CRASH OR LONG COMPILATION TIME THAT MIGHT ERROR OUT WITH SQL101N - BOX_COPY__9SQLNQ_QTBFPP9SQLNQ_QTBP9SQLNQ_QURI SQLNR_SUBSU
IT27034QUERIES USING HASH JOINS MAY HANG AND NOT BE ABLE TO BE FORCED OFF
IT27015WITH A ROTATING DB2 DIAGNOSTIC LOG, CERTAIN MESSAGES FROM THE DB2HAVEND PROCESS WILL BE LOGGED TO THE DEFAULT DB2DIAG.LOG FILE
IT27009INSTANCE CRASH DURING EVALUATION OF WLM THRESHOLD SQLROWSREAD
IT27001POSSIBLE TRAPS AND/OR EBADF (ERRNO 9) ERRORS WHEN USING UTL_MAIL.SEND() AND THE ROUTINES FAILS
IT26999RELAX OF DIAGLEVEL OF SQLRR_RDS_COMMON_POST, PROBE:870
IT26992DETERMINISTIC UDF CAN CAUSE INSTANCE TO TRAP
IT26979SUBOPTIMAL UPDATE STATEMENT PERFORMANCE DUE TO ACCESS PLAN
IT26939INCORRECT RESULTS WITH OUTER JOINS AND EXPRESSIONS IN JOIN COLUMNS
IT26936[COE_TIM]DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING AGGREGATE DISTINCT ON COLUMNIZED TABLES
IT26895DB2LOOK INCORRECTLY ADDS THE DELIMITER WITHIN THE COMMENT PLACEDAT THE END OF THE STORED PROCEDURE
IT26894ROUND() SCALAR FUNCTION MAY RETURN INCORRECT RESULT WITH FLOATING POINT NUMBER ON COLUMN-ORGANIZED TABLE
IT26888SQL0901 SQLRL_USERTEMPIUD: TID/FID NOT FOUND
IT26874OPTIMIZER INCLUDES THE COST OF TEMP CREATION FOR EACH RE-USE IN THE ACCESS PLAN
IT26872OPTIMIZER INCLUDES THE COST OF TEMP CREATION FOR EACH RE-USE IN THE ACCESS PLAN
IT26866DEADLOCK WAS OCCURRED IN SYSPLANLOCK IN PURESCALE
IT26856SAP: SUBOPTIMAL PERFORMANCE DUE TO DISABLED LOTO1 SQL OPTIMIZER FEATURE
IT26828SQL0901 USERTEMP env doesn't match current app
IT26821SPECTRUM PROTECT SNAPSHOT DB2 STANDBY DATABASE NAMES LONGER THAN 6 CHARS ENDS WITH AN ERROR FMM6825E
IT26820NOMEM ERROR CAUSED INSTANCE HANG WITH SERIOUS MEMORY LATCH CONTENTION
IT26818UNQUALIFIED SCALAR FUNCTION TRUNCATE MAY INCORRECTLY RESOLVE TO SYSFUN.TRUNCATE
IT26816DB2 ABEND DUE TO MEMORY CORRUPTION USING COLUMN BASED TABLES
IT26772DB2 SEGV IN DB2HADRP THREAD WHEN COPYING HADR REMOTE HOST TCPIP HANDLE STRING
IT26760ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL0668N WHEN RETRYING COPY OPERATION ON COLUMNAR TARGET TABLE
IT26758DB2 MIGHT TRAP WHEN CREATING A COLUMN ORIENTED TABLE ON LINUX PPC 64
IT26754DB2 MAY CRASH IF REMOTE MS SQL SERVER IS IN SHUTDUWN STATE DURING FETCH PROCESSING.
IT26753DB2CKBKP ERROR : TABLESPACE PAGE SIZE INCONSISTENT
IT26734DB2 MAY AVOID CONSIDERING CERTAIN INDEX ACCESS PLANS WHEN FETCH-FIRST-CLAUSE IS PRESENT AND OPTIMIZE-FOR-CLAUSE IS NOT
IT26730DB2SET -G DB2INSTDEF SHOULD FAIL WITH DIFFERENT ERROR
IT26717SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT26715SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT26714SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT26713SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION
IT26704ADMIN_MOVE_TABLE: OUTPUT OF OPERATION ESTIMATE MAY RETURN SOURCETABLE SIZES OF -4 AND SMALLER
IT26685DB2 MAY RETURN SQL0901N WHEN EXECUTING A QUERY INVOLVING VARCHARCODEUNITS32 IMPLICIT CASTING AND COLUMNAR TABLES
IT26667DB2DIAG -F MAY ABNORMAL FAIL IN SEGMENTATION FAULT
IT26666DB2FMP'S SIGALRM SIGNAL HANDLER WAS CHANGED IN V10.5FP9.
IT26658UNEXPECTED SQL1188N ON LOAD FROM REMOTE CURSOR WHEN USING MODIFIED BY ROWCHANGETIMESTAMPIGNORE
IT26649SQL1585N is returned when the optimizer does not select a possible plan under some circumstances
IT26624DB2PD COMMAND MAY CRASH WITH NO OUTPUT
IT26621UNDER RARE CIRCUMSTANCES, DB2 MAY ABEND WHEN A QUERY CONTAINS ANEXPRESSION THAT CAN BE MATCHED TO AN INDEXED EXPRESSION
IT26611SQL901N ERROR MIGHT OCCUR WITH QUERIES CONTAINING UNIONS AND EXPRESSIONS
IT26595SECURITY: FGAC RULES NOT BEING ENFORCED BY CTAS SUB-SELECT STATEMENTS
IT26586DB2 MAY ABEND WHILE COMPILING A QUERY THAT MAY PRODUCE A STAR SCHEMA JOIN
IT26579DB2 SERVER MAY TERMINATE ABNORMALLY WITH SQLDCSL_BADPAGE "BAD DATA PAGE"
IT26563ALTER TABLE WITH ALTER COLUMN OPTION MIGHT TRAP AND CRASH THE INSTANCE WHEN AUTO_REVAL IS DISABLED.
IT26559WHEN DB2_ONLINERECOVERY FEATURE IS ENABLED, ENCOUNTER DATABASE OUTAGE AFTER CRASH RECOVERY.
IT26520DB2 PURESCALE DATABASE SNAPSHOT MAY REPORT SEVERE ERROR "INVALID STORAGE GROUP IDENTIFIED FOUND."
IT26517DB2 MAY ABEND WHILE COMPILING A QUERY THAT MAY PRODUCE A STAR SCHEMA JOIN
IT26514SECURITY: DB2 IS AFFECTED BY A VULNERABILITY IN IBM SPECTRUM SCALE
IT26513SECURITY: DB2 IS AFFECTED BY A VULNERABILITY IN IBM SPECTRUM SCALE
IT26489REORG WITH "RECLAIM EXTENTS" DOES NOT REDUCE FPAGES
IT26487OFFLINE BACKUP MAY FAIL WITH SQL2048N WHEN PROCESSING AN MDC TABLE
IT26479POTENTIAL WRONG QUERY RESULT IF A FROM CLAUSE INCLUDES A MIXTUREOF LEFT OUTER AND LEFT OUTER TO ONE JOINS
IT26459SLOW PERFORMANCE MIGHT BE OBSERVED WHEN RUNNING AN IUD STATEMENTWITH CERTAIN CHARACTERISTICS
IT26455WHEN USING REOPT OPTIMIZER GUIDELINE UPDATES, INSERTS AND DELETES RUNNING IN BATCHES MIGHT INSERT WRONG DATA
IT26454WHEN USING REOPT OPTIMIZER GUIDELINE UPDATES, INSERTS AND DELETES RUNNING IN BATCHES MIGHT INSERT WRONG DATA
IT26452RESTORE OF A NON-ENCRYPTED DATABASE INTO AN ENCRYPTED ONE (TO IMPLEMENT ENCRYPTION) WILL NOT ALLOW ACTIVATION OF THE DATABASE
IT26451DB2 MAY ABEND WHEN ATTEMPTING TO REVALIDATE A MATERIALIZED QUERYTABLE
IT26449DB2 MAY ABEND WHEN ATTEMPTING TO REVALIDATE A MATERIALIZED QUERYTABLE
IT26445DB2 SEGV IN DB2HADRP THREAD WHEN COPYING HADR REMOTE HOST TCPIP HANDLE STRING
IT26444DB2 SEGV IN DB2HADRP THREAD WHEN COPYING HADR REMOTE HOST TCPIP HANDLE STRING
IT26440DB2RELOCATEDB ERROR: COULD NOT OPEN FILE/DEVICE
IT26439JOIN OF COLUMN-ORGANIZED TABLES MIGHT RETURN INCORRECT RESULTS
IT26429MULTI ROW FETCH IN DB2 11.1 LUW MAY NOT GIVE EXPECTED RESULTS
IT26427DB2 MAY CRASH WITH COREDUMP IF WINDOWS SYSTEM IS IN SHUTDOWN STATE DURING FETCH PROCESSING.
IT26406DB2RELOCATEDB ERROR: COULD NOT OPEN FILE/DEVICE
IT26394DB2 TAKES Z LOCK WHEN ATTACHING PARTITION TO TABLE
IT26391ERRORS FROM SQLPRECOVERYLSN IN CREATING LOG AT BACKUP FILE CAN LEAVE A TABLE SPACE UNABLE TO BE ROLLED FORWARD
IT26388ERRORS FROM SQLPRECOVERYLSN IN CREATING LOG AT BACKUP FILE CAN LEAVE A TABLE SPACE UNABLE TO BE ROLLED FORWARD
IT26383DEBUG CODE ADDED WITH IT22695 MAY CAUSE FALSE APPEND CACHE ERRORS
IT26380DEBUG CODE ADDED WITH IT22695 MAY CAUSE FALSE APPEND CACHE ERRORS
IT26358SQLRLDELETESYNOPSISDEPENDENCY CAUSING LOCK WAITS DUE TO UNNECESSARY RREAD LOCK ISOLATION
IT26343LOAD ERROR: "OPEN LOCFILE FOR WRITE FAILED!" IF A LOAD QUERY TABLE IS EXECUTED IN PARALLEL
IT26339TABLE SPACE OFFLINE AFTER "ALTER TABLESPACE ... MANAGED BY AUTOMATIC STORAGE" COMMAND
IT26337DB2 MAY THROW A SQL0901N 'XML Stats Sanity check failed' error DURING A AUTO RUNSTATS ON a XML TABLE
IT26326INTRA_PARALLEL QUERY MIGHT FAIL WITH SQL6040C FCM OUT OF BUFFER
IT26323DB2CLUSTER -CFS -ENTER -MAINTENANCE MIGHT FAIL WITH 2610-602 RSCT ERROR
IT26322JOIN OF COLUMN-ORGANIZED TABLES MIGHT RETURN INCORRECT RESULTS
IT26319DB2 MAY TRAP WITH SQLZSORTZVALUEARRAYELIMDUPS FUNCTION IN THE STACK WHEN PROCESSING VALUES OF DECIMAL DATA TYPE
IT26318SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION
IT26317SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION
IT26316SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION
IT26315SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION
IT26313You may encounter error SQL27970N during execution of IMPORT command with COMMITCOUNT AUTOMATIC
IT26311DB2: DB2LOOK -L WILL USE AN EXCESSIVE AMOUNT MEMORY IN PARTITIONED (DPF) ENVIRONMENTS WITH MULTIPLE DMS TABLESPACES.
IT26307TABLE SPACE ROLLFORWARD FAILS WITH SQL0804N DUE TO LARGE TABLE SPACE NAME LIST
IT26303INCORRECT "TYPE" VALUE IN IMPLICITVALUE COLUMN OF SYSCAT.COLUMNSFOR ROW CHANGE TIMESTAMP, ROW END OR TRANSACTION START ID COLUMN
IT26302TABLE SPACE ROLLFORWARD FAILS WITH SQL0804N DUE TO LARGE TABLE SPACE NAME LIST
IT26296CLP INTERMITTENTLY RETURNS DATE VALUES IN AN INCORRECT FORMAT
IT26290ERROR SQL2018N - LIMITATION OF DB2 CLOUD STORAGE FOR THE SUPPORTOF THE SIGNATURE 4 VERSION, REQUIRED FOR EU-CENTRAL-1
IT26282UPDATE ON FULL TABLE WHICH USES SUB_SELECT COULD INCORRECTLY SET VALUES TO NULL FOR COLUMN BEING UPDATED.
IT26278INDEXES ON COLUMN-ORGANIZED TABLES ARE NOT CHOSEN FOR SOME TYPESOF SQL STATEMENTS
IT26276DB2: DB2LOOK -L WILL USE AN EXCESSIVE AMOUNT MEMORY IN PARTITIONED (DPF) ENVIRONMENTS WITH MULTIPLE DMS TABLESPACES.
IT26275UNDER SOME CONDITIONS, A BUFFER OVERFLOW CAN OCCUR WHEN READING FROM BLU PAGES THAN LEADS TO A HANG OR CRASH
IT26264DB2CLUSTER -CFS -ENTER -MAINTENANCE MIGHT FAIL WITH 2610-602 RSCT ERROR
IT26253DES CONNECTIONS USING GATEWAY CONCENTRATOR AGAINST DB2 FOR Z/OS CAN FAIL
IT26252DES CONNECTIONS USING GATEWAY CONCENTRATOR AGAINST DB2 FOR Z/OS CAN FAIL
IT26206A JAVA PROCESS USING JCC TYPE 2 DRIVER WHICH ACCESSES DB2 ON Z/OS THROUGH DB2 CONNECT MAY CRASH DUE TO SIGSEGV.
IT26178WRONG RESULTS FROM SELECT INTO STATEMENT CONTAINING WITH CLAUSE AND DATA-CHANGE-TABLE-REFERENCE
IT26159'DB2INSTANCE -INSTANCE DB2INST2 -LIST' RUN AS ROOT REPORTS ERROR" LIBSQLHA: SQLHAGETOBJECTATTRIBUTE()"
IT26156SECURITY: IBM SDK JAVA QUARTERLY CPU - JUL 2018
IT26146SECURITY: IBM SDK JAVA QUARTERLY CPU - JUL 2018
IT26144SECURITY: PRIVILEGE ESCALATION IN ROOT SETUID EXECUTABLES
IT26143SECURITY: PRIVILEGE ESCALATION IN ROOT SETUID EXECUTABLES
IT26142SECURITY: DB2 VULNERABLE TO SYMBOLIC LINK ATTACK RESULTING IN PRIVILEGE ESCALATION
IT26141SECURITY: DB2 DAS PRIVILEGE ESCALATION FROM DAS OWNER TO ROOT VIA SYMBOLIC LINK ATTACK
IT26140SECURITY: DB2 VULNERABLE TO SYMBOLIC LINK ATTACK RESULTING IN PRIVILEGE ESCALATION
IT26139SECURITY: DB2 DAS PRIVILEGE ESCALATION FROM DAS OWNER TO ROOT VIA SYMBOLIC LINK ATTACK
IT26138SECURITY: PRIVILEGE ESCALATION IN ROOT SETUID EXECUTABLES
IT26137SECURITY: DB2 VULNERABLE TO SYMBOLIC LINK ATTACK RESULTING IN PRIVILEGE ESCALATION
IT26136SECURITY: DB2 DAS PRIVILEGE ESCALATION FROM DAS OWNER TO ROOT VIA SYMBOLIC LINK ATTACK
IT26135SECURITY: DB2 IS VULNERABLE TO SYMBOLIC LINK ATTACK LEADING TO PRIVILEGE ESCALATION
IT26134SECURITY: DB2 IS VULNERABLE TO SYMBOLIC LINK ATTACK LEADING TO PRIVILEGE ESCALATION
IT26133SECURITY: DB2 IS VULNERABLE TO SYMBOLIC LINK ATTACK LEADING TO PRIVILEGE ESCALATION
IT26132SECURITY: PRIVILEGE ESCALATION IN ROOT SETUID EXECUTABLES
IT26131SECURITY: DB2 VULNERABLE TO SYMBOLIC LINK ATTACK RESULTING IN PRIVILEGE ESCALATION
IT26130SECURITY: DB2 DAS PRIVILEGE ESCALATION FROM DAS OWNER TO ROOT VIA SYMBOLIC LINK ATTACK
IT26129SECURITY: DB2 IS VULNERABLE TO SYMBOLIC LINK ATTACK LEADING TO PRIVILEGE ESCALATION
IT26127NON-PUSHDOWNABLE HASH JOIN ELIGIBLE PREDICATES INVOLVING NICKNAMES MAY BE USED SUB-OPTIMALLY
IT26125NON-PUSHDOWNABLE HASH JOIN ELIGIBLE PREDICATES INVOLVING NICKNAMES MAY BE USED SUB-OPTIMALLY
IT26119COMPILING A SQL QUERY THAT INCLUDES A SQL UDF WITH OLAP INPUT MAY INCORRECTLY RETURN SQLCODE -206
IT26112DB2PREREQCHECK CHECKING INSUFFICIENT SNWLLIBC LEVEL
IT26107DB2READLOG API MIGHT SKIP LOG RECORDS INTERMITTENTLY
IT26096DB2READLOG API MIGHT SKIP LOG RECORDS INTERMITTENTLY
IT26095DB2LOOK MAY ABEND ON A DPF SYSTEM WHEN TEMPORARY FILES HAVEN'T BEEN CLEANED UP.
IT26085LOAD'S SQL3227W MESSAGE AFTER HITTING WARNINGCOUNT LIMIT MAY GIVE INCORRECT LINE NUMBER
IT26077ACR FAILOVER HANGS WHEN SERVER AFFINITY LIST IS LONG
IT26072UPGRADE DATABASE COMMAND RETURNS SQL1224, SQL0954 WHEN APPLHEAPSZ IS SET TO SMALL FIXED VALUE
IT26046DB2FODC -HADR DETECT FAILING IF NODE TYPE IS MPP/ DPF
IT26045RESTORE OF A NON-ENCRYPTED DATABASE INTO AN ENCRYPTED ONE (TO IMPLEMENT ENCRYPTION) WILL NOT ALLOW ACTIVATION OF THE DATABASE
IT26043DIA3202C THE TCP/IP CALL SETSOCKOPT(TCP_RTO_MAX)
IT26036DB2 MAY TRAP WHEN EVALUATING AN XML QUERY THAT INVOLVES RENAMES.
IT26034DB2 MAY TRAP WHEN EVALUATING AN XML QUERY THAT INVOLVES RENAMES.
IT26029DB2CONVERT FAILS WITH SQL0573N ERROR FOR TABLE HAVING NOT ENFORCED PRIMARY KEY CONSTRAINT.
IT26025INTERMITTENT DB21016E AND/OR DB21018E ERROR ON AIX.
IT26009COLUMNAR ONLY: POSSIBLE WRONG RESULT IN EQUALITY JOIN WHEN COMPARING ZERO BINARY FLOATING POINT VALUE
IT26000ONLINE BACKUP FAILS WITH SQL0293N SQLB_CONTAINER_NOT_ACCESSIBLE READING LOB PAGES
IT25994HADR GRACEFUL TAKEOVER ON PURESCALE COULD FAIL WITH SQL1770N RC7WHILE OLD PRIMARY DATABASE IS SWITCHING ROLE.
IT25993WHEN THERE ARE MANY CONNECTIONS TO THE PRIMARY DATABASE, HADR TAKEOVER COULD RETURN SQL1770N RC7.
IT25992HADR GRACEFUL TAKEOVER ON PURESCALE COULD TIME OUT WAITING FOR PRIMARY DATABASE TO PROGRESS DUE TO GLFH LOTCH CONTENTION.
IT25991The Import utility may fail with error -16129 on partitioned database.
IT25990STARTING HADR AS STANDBY ON A PURESCALE DATABASE COULD SOMETIME RETURN SQL1776N RC7
IT25986DIAGNOSTICS DUMPING MAY HANG WHEN DUMPING PACKAGE CACHE INFORMATION
IT25977DIA3202C THE TCP/IP CALL SETSOCKOPT(TCP_RTO_MAX)
IT25974SIGSEGV WHEN USING PARALLEL OPTION OF DB2MOVE
IT25969QUERY FAILS WITH SQL0901N REASON "PARENT ENTITY NOT PROVIDED" ORREASON "FOUND ZERO CLOB.RESET"
IT25968CREATE INDEX FAILS WITH SQL0901N IN PURESCALE WHEN OLD LOG FILESARE REMOVED IN ARCHIVE LOG DIRECTORY
IT25967STARTING HADR AS STANDBY ON A PURESCALE DATABASE COULD SOMETIME RETURN SQL1776N RC7
IT25965HADR GRACEFUL TAKEOVER ON PURESCALE COULD TIME OUT WAITING FOR PRIMARY DATABASE TO PROGRESS DUE TO GLFH LOTCH CONTENTION.
IT25963WHEN THERE ARE MANY CONNECTIONS TO THE PRIMARY DATABASE, HADR TAKEOVER COULD RETURN SQL1770N RC7.
IT25956AUTOMATIC RESTORE FEATURE CAN PROVIDE AN INCORRECT SYNTAX IN THECOMMAND PASSED TO DB2
IT25943NPE WITH ACR AND CLIENT AFFINITY
IT25941INDEX KEY NOT FOUND ERROR MIGHT INCORRECTLY BE REPORTED BY THE SERVER
IT25937ODBC CONNECTION CHARACTER LIMIT USER ID
IT25936SPECTRUM PROTECT SNAPSHOT OFFLOAD BACKUPS FAIL WITH FMM2001E SOCKET ERROR WHILE CONNECTING TO ACSD AT <DEFAULT PORT NUMBER>
IT25935FODC APPERR AFTER APPLYING FIXPACK10 ON V10.5 for queries against Created Global Temporary Tables
IT25927PADIAGLOGCOLL::PARSEFILTERPARMS SHOWS UP IN DB2DIAG.LOG FREQUENTLY.
IT25915CONNECTION TIMEOUT COULD OCCUR WHEN ConnectionTimeout IS SET TO 10 SEC OR LESS.
IT25908PL/SQL PACKAGE WITH AN INITIALIZATION SECTION CAN RETURN -301 ERROR WHEN CALLED VIA JAVA OR CLPPLUS
IT25907-P <PORT> PARAMETER IS BEING IGNORED BY DB2ICRT
IT25880GATEWAY CONCENTRATOR CAN CAUSE JDBC DES CLIENTS TO FAIL TO AUTHENTICATE WHEN JDBC AES CLIENTS ARE ALSO BEING USED.
IT25879GATEWAY CONCENTRATOR CAN CAUSE JDBC DES CLIENTS TO FAIL TO AUTHENTICATE WHEN JDBC AES CLIENTS ARE ALSO BEING USED.
IT25872DB2:HADR FAILOVER, JAVA APP DEPLOYED ON JBOSS FAILED TO RETRIEVESCHEMA BUT USE CONNECTION AUTH ID DIRECTLY.
IT25869HADR GRACEFUL TAKEOVER ON PURESCALE COULD FAIL WITH SQL1770N RC7WHILE OLD PRIMARY DATABASE IS SWITCHING ROLE.
IT25867ENCRYPTED PAGE MAY BE LOADED INTO BUFFERPOOL DUE TO INCORRECT ERROR HANDLING
IT25864GRANT / REVOKE PRIVILEGE DID NOT TAKE EFFECT IN CATALOG CACHE IMMEDIATELY ON HADR STANDBY SIDE
IT25857FODC_TRAP IN RESETRESVLOGSPACEIFSTATEMENTCHANGED
IT25849GRANT / REVOKE PRIVILEGE DID NOT TAKE EFFECT IN CATALOG CACHE IMMEDIATELY ON HADR STANDBY SIDE
IT25841DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CSES AND CORRELATED SUB-QUERIES
IT25840POSSIBLE TIMING ISSUE BETWEEN APPLICATIONS DISASSOCIATING FROM ADATABASE MAY LEAD TO A CRASH.
IT25830SECURITY: VULNERABILITIES IN GSKIT AFFECT IBM SPECTRUM SCALE
IT25829SECURITY: VULNERABILITIES IN GSKIT AFFECT IBM SPECTRUM SCALE
IT25827FODC PANIC DUE TO MEMORY CORRUPTION CAUSED BY INVALID LENGTH ASSIGNMENT
IT25826SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION
IT25825SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION
IT25824SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION
IT25820SECURITY: BUFFER OVERFLOW IN DB2 DB2LICM UTILITY
IT25819SECURITY: BUFFER OVERFLOW IN DB2 DB2LICM UTILITY
IT25816SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN DB2CACPY
IT25815SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN DB2CACPY
IT25814SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN DB2CACPY
IT25813SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION
IT25811INDEX KEY NOT FOUND ERROR MIGHT INCORRECTLY BE REPORTED BY THE SERVER
IT25801INVALID MIRROR LOG PATH MESSAGE IS SEEN IN DIAG LOG
IT25793DB2 MAY HANG IN ACCESSING GLFH FILE WHEN USING MULTIPLE CONCURRENT IMPORT IN DPF
IT25784DB2 MAY CRASH DURING A "REORG RECLAIM EXTENT" ON AN ITC TABLE
IT25783-901 ERROR WITH TEXT "WITH HOLD BUT USAGE LOCK ARGUMENT NULL" REPORTED BY SQLRLC_REQUEST_ULOCK() AS CALLED BY SQLRLC_FED_FETCH()
IT25781DB2 MAY ABEND WHEN COMPILING A QUERY CONTAINING A SEMI-JOIN
IT25774IMPROPER WORNING MESSAGE "ACCESS NOT ALLOWED. TBLSPC RF IN PROGRESS." IS LOGGED DURING "ROLLFORWARD" COMMAND WITH "QUERY STATUS"
IT25770INSTANCE CRASHES DURING CLEANUP A VARIATION FROM THE PACKAGE CACHE
IT25769DB2XPRT TOOL IS FAILING TO FORMAT WINDOWS TRAP FILES IN SPECIAL BUILDS.
IT25767DB2TRC & DB2HAICU SEGMENTATION FAULT
IT25765DB2 CLIENT FAILS WITH SIGSEGV OR GIVES SQL ERRORS WHEN embeddedSQL application EXECUTES MULTI ROW INSERT
IT25755SAP JDBC NPE WITH KEEPDYNAMIC
IT25750SIGKILL ORIGINATING FROM DB2STOP FORCE NODENUM XX
IT25735INCORRECT RESULTS COULD HAPPEN WITH OUTER JOINS AND EXPRESSIONS IN JOIN COLUMNS
IT25732DB2 IN DPF MAY HANG DURING IMPLICIT INDEX REBUILD ON COLUMNAR TABLE IF MORE THAN ONE INDEX IS RECREATED
IT25731AUTOCONFIGURE MAY FAIL WITH SQL0802N IF THE SUM OF THE SIZES OF ALL TABLE PACKED DESCRIPTORS EXCEEDS 2147483647
IT25722NOSQL UPDATE WITH "$SET" COULD UPDATE DATA WITH NULL VALUE AND CAUSE SUBSEQUENT ERRORS
IT25719SECURITY: BUFFER OVERFLOW IN DB2 DB2LICM UTILITY
IT25707DB2 SERVER TERMINATES ABNORMALLY DURING QUERY COMPILATION
IT25706INCORRECT RESULTS COULD HAPPEN WITH OUTER JOINS AND EXPRESSIONS IN JOIN COLUMNS
IT25680"ROLLFORWARD LAST COMMITTED TIMESTAMP" VALUE IS NOT SHOWN IN A DATABASE SNAPSHOT ISSUED AGAINST A HADR STANDBY DATABASE
IT25654DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSION,UNION AND UDF
IT25651WRONG RESULT IS POSSIBLE WHEN SQL HAS SEVERAL INSTANCES OF SYSIBM.RAND(SEED)
IT25647SQL0901N "DESCRIBE LEVEL (0X3) SQLDD LEVEL (0X2)" WHEN USING DB2REPLICATION CENTER TO CREATE FEDERATED CONNECTION
IT25645DB2LOOK WITH -CT DOES NOT GENERATE SET SCHEMA DDL'S BEFORE CREATE MQT/SUMMARY TABLES WITH IMPLICIT SCHEMAS
IT25633PMR37651,999,000 BOOL DATATYPE MISMATCH B/W MICROSOFT AND DB2 LUW ( DB2 ON CLOUD)
IT25628WIN32 ONLY: DB2LEVEL GIVES SQL1022C IF INSTANCE NAME IS LONGER THAN 7 BYTES.
IT25623DB2IUPDT -CHECK_COMMIT / -COMMIT_LEVEL FAILED
IT25601"DB2CLUSTER -CM -ENTER -MAINTENANCE" COMMAND FAILS IF RUN ON A TIEBREAKER HOST IN GDPC ENVIRONMENT
IT25599SQL0407N MIGHT OCCUR WHEN RUNNING QUERIES CONTAIN SCALAR SUB-QUERIES AND COMMON SUB-EXPRESSIONS
IT25589LIST HISTORY COMMAND FAILS WITH DB21018E ERROR WHEN THE HISTORY FILE CONTAINS A DROPPED TABLE EVENT WITH LONGER TABLE NAME.
IT25582SQL0407N MIGHT OCCUR WHEN RUNNING QUERIES CONTAIN SCALAR SUB-QUERIES AND COMMENT SUB-EXPRESSIONS
IT25578SQLKD_SYSERR MAPPED TO -902 BY RUNTIME, CAUSING DATABASE MARKED BAD.
IT25560Statistics event monitor traps when event monitor generation overlaps activation of the statistics event monitor.
IT25556DB2 ACTIVE LOGS NOT BEING REMOVED FROM ACTIVE LOG DIRECTORY WHENNO LONGER NEEDED.
IT25553CREATE PROCEDURE MAY CAUSE DB2 TO TERMINATE ABNORMALLY IN SQLNQ_SEM_LIMIT
IT25552UPDATING THE AUDIT DATA PATH OR THE INSTANCE DIAGPATH MAY FAIL IN AN AUTOMATED HADR ENVIRONMENT
IT25536SQLKD_SYSERR MAPPED TO -902 BY RUNTIME, CAUSING DATABASE MARKED BAD.
IT25527ADMIN_MOVE_TABLE: INDEX IS NOT GENERATED IF TARGET TABLE IS COLUMNAR
IT25525DB2 MAY TERMINATE ABNORMALLY DURING COMPILATION OF A QUERY WITH OPTIMIZER GUIDELINE
IT25524THE DB2DCLGN TOOL RETURNS INCORRECT OUTPUT FOR COBOL IN ZOS COMPATIBILITY MODE
IT25523ERRORS WITH XML PROCESSING - XDBADVDOCHANDLER__ERROR, PROBE:1655
IT25522ERRORS WITH XML PROCESSING - XDBADVDOCHANDLER__ERROR, PROBE:1655
IT25519db2instance & db2haicu might fail with a SEGV in sqlhaGetInfoForClusterObject if route or IPv4 IP is not assigned to NIC
IT25516TRAP IN SQLRA_CLOSE_SECTIONS_ON_COMMIT IN DPF ENVIRONMENT
IT25502YOU MAY ENCOUNTER A FODC PANIC DURING DROP TABLE COMMAND in DPF.
IT25495DB2 MAY RETURN SQL0901N ERROR WHEN COMPILING A QUERY CONTAINING A GROUP BY AND OLAP FUNCTIONS
IT25493DB2 STANDBY CRASH ON SQLOGETMEMPOOLSTATSUNLATCHED WHEN DB2_HADR_ROS IS ENABLED
IT25481SQL0901N ERROR MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING NOT EXISTS SUB-QUERIES
IT25478CLP MIGHT NOT REMOVE 0x0A BYTE FROM THE STATEMENTS IF THY ARE EXECUTED FROM SHELL SCRIPT.
IT25468THE DB2MOVE COMMAND DOES NOT EXPORT PARTITIONED TABLES WHEN USED WITH OPTION: TS
IT25466SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN DB2CACPY
IT25464DB2ROCM CONSTANTLY DUMP *SQLHA.EVENTS.BIN IF MEMBER FAILS TO START.
IT25455DB2 MAY TERMINATE ABNORMALLY DURING COMPILATION OF A QUERY WITH OPTIMIZER GUIDELINE
IT25435FLUSH PACKAGE CACHE MAY NOT REMOVE ALL ENTRIES
IT25431YOU MAY ENCOUNTER A FODC PANIC DURING DROP TABLE COMMAND in DPF.
IT25400DB2PD -HA CAN OUTPUT "COULD NOT RETRIEVE NUMBER OF RESOURCE GROUPS IN THE CLUSTER"
IT25396PURESCALE HADR STANDBY MIGHT CRASH WITH SQLO_XLATCH::RELEASECONFLICT: "UNLOCKING AN UNLATCHED LOCK"
IT25391PURESCALE HADR STANDBY MIGHT CRASH WITH SQLO_XLATCH::RELEASECONFLICT: "UNLOCKING AN UNLATCHED LOCK"
IT25390DB2 INSPECT MIGHT INCORRECTLY REPORT OUT OF RANGE ERRORS FOR BLUTABLES
IT25388DB2 MIGHT TRAP DURING PROCESSING XML DATA
IT25377GRANT STATEMENT IS MISSING FROM DB2LOOK OUTPUT.
IT25373CF MEMBER COMMUNICATION TIMEOUT LEADS TO CONNECTION RESET IMPACTING PERFORMANCE
IT25370POTENTIAL ACCESS VIOLATION IN BANKUNPACKER GETCODES
IT25368TO_NCHAR() RETURNS WRONG RESULT WITH UNION
IT25363SYSPROC.MON_GET_CONNECTION DOES NOT DIFFERENTIATE BETWEEN SECUREAND NON-SECURE CONNECTIONS TO A DATABASE.
IT25359DB2 INSPECT MIGHT INCORRECTLY REPORT OUT OF RANGE ERRORS FOR BLUTABLES
IT25342ADMIN_MOVE_TABLE FORCE_ALL DOES NOT FORCE OFF APPLICATIONS HOLDING OTHER CONFLICTING LOCKS THAN TABLE LOCKS
IT25338DB2PD -HA CAN OUTPUT "COULD NOT RETRIEVE NUMBER OF RESOURCE GROUPS IN THE CLUSTER"
IT25336INFORMATIONAL: IF COLUMNAR TABLES ARE PRESENT THEN UPGRADE FROM10.5FP10 to 11.1 MIGHT REQUIRE A SPECIAL BUILD
IT25333PERFORMANCE MAY BE AFFECTED BY DYNAMIC SQL CACHE NON REUSE
IT25326UNICODE DATA CONTAINING CJK Ext-B FAILS TO CONVERT TO 1392 CODEPAGE
IT25322db2ckupgrade fails with SQL10007N Message "5556" could not be retrieved. Reason code: "4" when upgrading from v10.5fp10 to v11.1
IT25314UNICODE DATA WHICH BUILT WITH SUPPLEMENTARY CHARACTERS FAILS TO CONVERT TO 1392 CODESET
IT25305SQL0332N WITH NVL2 FUNCTION AND VARCHAR FOR BIT DATA AND GRAPHIC
IT25302POTENTIALLY BAD PERFORMANCE WHEN USING PARAMETER MARKERS IN QUERIES CONTAINING JOINS
IT25300COLUMN BASED QUERY MAY HANG IF THE QUERY CONTAINS AGGREGATION FUNCTIONS AND DATA EXCEPTION OCCURS
IT25285DB2 PURESCALE USING CF_TRANSPORT_METHOD TCP MIGHT TRIGGER A FODC PANIC WITH "SAL: PAGE NAME MISMATCH IN RETRIEVED PAGE!"
IT25281SLOW INSERT PERFORMANCE WHEN USING MON_OBJ_METRICS EXTENDED
IT25271CLI/ODBC CONNECTION CRASHES WHEN CONNECTING TO THE HA INSTANCE OR PURESCALE CLUSTER OF DB2 ON CLOUD DUE TO LARGE HOSTNAME.
IT25267CALLING STORED PROCEDURE { ? = CALL SOMESPNAME( ?, ?, ?, ?, ? ) } RESULTS IN APPLICATION CRASH 0XC0000005
IT25229DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING REDUNDANT PREDICATE
IT25228DB2 CLIENT CACHE FILE SRVLST.XML SIZE GROWS BY 6 BYTES EVERY TIME WHEN CONNECT TO PURESCALE.
IT25196OLDER DATAL ARCHIVE LOGS ARE NOT PRUNED BY "PRUNE HISTORY TIMESTAMP AND DELETE" COMMAND UNEXPECTEDLY
IT25195QUERIES CONTAINING OUTER JOINS AND GROUP BY CLAUSES MIGHT PRODUCE WRONG RESULTS
IT25194TO_NCHAR() RETURNS WRONG RESULT WITH UNION
IT25187UDF FUNCTIONS RUN AGAINST COLUMNAR (BLU) TABLES MIGHT RETURN INCORRECT RESULTS
IT25185DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING REDUNDANT PREDICATE
IT25183LOG_TO_FILE OPTION OF EVMON_FORMAT_UE_TO_XML TABLE FUNCTION CANNOT WRITE OUT XML DOCUMENT MORE THAN 100MB
IT25162SECURITY: DENIAL OF SERVICE WHEN USING TRUNC SCALAR FUNCTION
IT25150NOMEM ERROR CAUSED INSTANCE HANG WITH SERIOUS MEMORY LATCH CONTENTION
IT25147QUERIES CONTAINING OUTER JOINS AND GROUP BY CLAUSES MIGHT PRODUCE WRONG RESULTS
IT25138THE "DB2CLUSTER -CM -ENTER -MAINTENANCE COMMAND" MAY FAIL DUE TOTSA RESOURCES PROBLEM
IT25136QUERY EXECUTION FAILS WITH -901 "SQLRIDERIVEDUMMY FUNCTION SHOULD NEVER BE ACTUALLY CALLED"
IT25135BACKUP V9.7 DB FROM V11.1 CLIENT MIGHT FAIL WITH SQL1651N
IT25121"RECOVER DB" COMMAND IS NOT PICKING UP CORRECT DB2 BACKUP IMAGE FOR RECOVERY TILL POINT IN TIME.
IT25100MERGE BACKUP - PROGRAM FAILURE DURING THE INVENTORY PHASE
IT25072INCORRECT ROW NUMBER FOR ERROR/WARNINGS IN COMPOUND SQL STATEMENTS(statement chaining) IN .NET APPLICATIONS:
IT25070ADMIN_GET_TAB_INFO WAITING ON REORG TABLE RECLAIM EXTENTS ON ITCTABLE
IT25066SLOW MEMORY ALLOCATIONS OR POSSIBLE SEVERE DEGRADATION DURING OOM HANDLING DUE TO COALESCE MEMORY CHECK
IT25058FEDERATION QUERY MAY GET SQL0302N DUE TO STRING TRUNCATION WHEN A HOST VARIABLE IS USED FOR A REMOTE COLUMN IN DIFFERENT CODEPAG
IT25046RESTORE WITH "SHOW MASTER KEY DETAILS" DID NOT SHOW ALL THE KEY LABEL
IT25044DB2 SERVER MAY CRASH WHEN RUNNING LOOSELY COUPLED XA TRANSACTIONor using MSDTC AS TRANSACTION MANAGER
IT25038GBP CLEANUP CAN BE SLOW ON A LARGE GBP DURING MEMBER CRASH RECOVERY
IT25035DB2 MAY REPORT A 'SEVERE' LEVEL MESSAGE WITHIN THE DB2OPTSTATS LOG WHEN COLLECTING RUNSTATS ON A TABLE IN LOAD PENDING STATE
IT25029RESTORE FROM INCREMENTAL BACKUP WITH MULTIPLE STREAMS - DB2 MAY ERROR SQL2032N THE "BUFFER_NUM" PARAMETER IS NOT VALID. SQLSTATE
IT25028RESTORE FROM INCREMENTAL BACKUP WITH MULTIPLE STREAMS - DB2 MAY ERROR SQL2032N THE "BUFFER_NUM" PARAMETER IS NOT VALID. SQLSTATE
IT25025DB2 CAN TRAP WHEN USING DBMS_SQL.PARSE
IT25024RESTORE FROM INCREMENTAL BACKUP WITH MULTIPLE STREAMS - DB2 MAY ERROR SQL2032N THE "BUFFER_NUM" PARAMETER IS NOT VALID. SQLSTATE
IT25023DB2 MAY REPORT A 'SEVERE' LEVEL MESSAGE WITHIN THE DB2OPTSTATS LOG WHEN COLLECTING RUNSTATS ON A TABLE IN LOAD PENDING STATE
IT25021ADMIN_GET_TAB_INFO WAITING ON REORG TABLE RECLAIM EXTENTS ON ITCTABLE
IT24990SQL0811N ERROR MIGHT OCCUR WHEN RUNNING UPDATE STATEMENTS CONTAINING SCALAR SUB-QUERIES
IT24989SQL0420N ERROR MIGHT OCCUR WHEN RUNNING UPDATE STATEMENTS CONTAINING SCALAR SUB-QUERIES
IT24982JCC NAMED PARAMETER MARKER SUPPORT FOR SQL STARTS WITH 'WITH' CLAUSE 4.25/3.72
IT24971/DB2.TMP.<PID> DIRECTORY REMAINS AFTER FIXPACK APPLICATION
IT24968CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
IT24964LOAD REPLACE RESETDICTIONARYONLY INCORRECTLY REPORT ERRORS IN DB2DIAG.LOG (SQLBSTATEGETCHECK)
IT24963CHANGE PROBE WARNING IN DB2DIAG.LOG MESSAGE FROM "ERROR" TO "WARNING" FOR RETCODE : ZRC=0X801A006D=-2145779603=SQLZ_CA_BUILT (WL
IT24962SQL1007N ERROR IN FINDING PAGES FOR AN OBJECT IN A TABLE SPACE
IT24961ATTEMPT TO INSTALL DB2 SERVER 10.5 64 BIT FIXPACK 9 FAILS DURINGUPGRADE WHEN DB2 V10.5 32 BIT ALREADY EXISTS ON WINDOWS
IT24960-901 ERROR IN SOME CASES WHEN EXPLAIN MODE IS ON AND A STATEMENTIS RUN TWICE
IT24959ATTEMPTING TO MOVE HADR DATABASES VIA THE DB2HAICU MAINTENANCE MENU OPTION MAY FAIL
IT24957POSSIBLE TRAP (FODC) IN 'HDREDUACCEPTEVENT()' DUE TO INVALID CONNECTION SEQUENCE
IT24956SQL0332N AFTER ALTERING COLUMN LENGTH
IT24955DB2 CRASH IN DPF + SMP AFTER INTERNAL INTERRUPT (SQL0952N)
IT24954SLOW INSERT PERFORMANCE IN PURESCALE BECAUSE UNCOMMITTED DELETED SLOTS AREN'T REUSED CORRECTLY
IT24944DATABASE MARKED BAD (SQLO_INV_PARM) ON INTERRUPT IN REGULAR EXPRESSION PROCESSING
IT24919CLP CRASHES WITH DB21018E
IT24911CAPTURE ADDITIONAL DIAGNOSTIC INFORMATION IN BLU MEMORY MANAGEMENT
IT24895CAPTURE ADDITIONAL DIAGNOSTIC INFORMATION IN BLU MEMORY MANAGEMENT
IT24892APPLICATIONS ISSUING ALTER TABLE ADD/ATTACH/DROP/DETACH MAY DEADLOCK WITH APPLICATIONS REBINDING PACKAGES
IT24868POSSIBLE SIGSEGV IN SQLDRETURNDATA WITH RANGE CLUSTERED TABLES
IT24866IN A HADR HA(TSA) ENVIRONMENT, IN THE EVENT OF A PRIMARY SERVER FAILURE, THE STANDBY MAY NOT BE REINTEGRATED ON INSTANCE STARTUP
IT24863INCORRECT LOG COMPENSATION BEHAVIOUR CAN LEAD TO DATABASE CORRUPTION WHEN USING LOAD ON A TABLE WITH AN XML COLUMN
IT24855A rare timing condition could cause instance to go down.
IT24847POSSIBLE SIGSEGV IN SQLDRETURNDATA WITH RANGE CLUSTERED TABLES
IT24846DBMS_SQL.OPEN_CURSOR CAUSES MEMORY LEAK IN KRCBH POOL
IT24841DB2 MIGHT TRAP WHEN EXECUTING COMPLEX QUERIES CONTAINING CSES
IT24840SECURITY: UPDATE IBM SDK, JAVA TECHNOLOGY EDITION QUARTERLY CPU - JAN 2018 and APR 2018
IT24837SECURITY: IBM JAVA UPDATE
IT24830STEPPING TQS MAY EXPERIENCE A HANG IN SITUATIONS WHEN WE ARE TRYING TO STOP TQ DRAINING AS A PERFORMANCE OPTIMIZATION.
IT24829LONG DURATION OF HOLDING OF THE Statement ANCHOR LATCH CAUSED LATCH CONTENTION
IT24828IUD OPERATIONS AGAINST COLUMNAR TABLES COULD ENCOUNTER AN ABEND WHEN PLAN IS COMPLEX AND NLJN IS PRESENT ABOVE IUD OPERATION
IT24827SQL1007N ERROR IN FINDING PAGES FOR AN OBJECT IN A TABLE SPACE
IT24826SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
IT24825SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
IT24824SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
IT24823SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
IT24821WITH UCA COLLATION RUNSTATS CAN CAUSE THE INSTANCE TO TRAP
IT24820WITH UCA COLLATION RUNSTATS CAN CAUSE THE INSTANCE TO TRAP
IT24811STEPPING TQS MAY EXPERIENCE A HANG IN SITUATIONS WHEN WE ARE TRYING TO STOP TQ DRAINING AS A PERFORMANCE OPTIMIZATION.
IT24809DBMS_SQL.OPEN_CURSOR CAUSES MEMORY LEAK IN KRCBH POOL
IT24808INSTANCE MAY CRASH WHEN EXTERNAL CODEPAGE CONVERSION TABLES ARE IN USE ON DB2 SERVER
IT24804SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT24803SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT24802SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT24799SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT24788ATTEMPTING TO MOVE HADR DATABASES VIA THE DB2HAICU MAINTENANCE MENU OPTION MAY FAIL
IT24783LOAD REPLACE RESETDICTIONARYONLY INCORRECTLY REPORT ERRORS IN DB2DIAG.LOG (SQLBSTATEGETCHECK)
IT24765TIMING ISSUE IN PACKAGE CACHE WORKSPACE MAY CAUSE PANIC
IT24764DEADLOCK ON SYSIBM.SYSTABLES WHEN RUNNING LOAD ON DPF
IT24761SQL20478N REASON CODE 30 MAY OCCUR WHEN EXECUTING A DATA-CHANGE-STATEMENT
IT24752LOAD UTILITY MAY FILL DB2DIAG.LOG WHEN LOAD HITS PROBLEM DURING INITIALIZATION PHASE.
IT24750SQL0901/SQL0183 MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING CASESUB-EXPRESSIONS
IT24749DB2 MAY CRASH IN SAL FLIGHT RECORDER CODE
IT24744CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
IT24743CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
IT24740POSSIBLE SEGV DURING CONNECTION WITH CLI IF MULTI THREADED PROGRAM AND XML SRVRLST.XML FILE EXISTS
IT24739DB2 CRASH ON -901 IN SQLRA_CACHE_FILL_SEC WITH "SECTION LENGTH MISMATCH"
IT24737AUTOMATIC ONLINE REORG FAILS WITH SQL0270N BECAUSE THE CLAUSE ALLOW WRITE ACCESS IS GENERATED AND NOT SUPPORTED ON MDC TABLE. (R
IT24735Member failback may fail with SQL1072C after rmcd process failure on member?s home host.
IT24734INSTANCE MAY PANIC DURING A DROP SEQUENCE
IT24727SQL4917N MAY BE THROWN WHEN A COBOL APPLICATION IS RUN ON A 64 BIT MACHINE
IT24722DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONSAND SCALAR AGGREGATIONS
IT24712AFTER RENAMING A TABLE A SUBSEQUENT SELECT MAY INCORRECTLY RETURN SQL0551
IT24710AFTER RENAMING A TABLE A SUBSEQUENT SELECT MAY INCORRECTLY RETURN SQL0551
IT24702THE EXPLANATION FOR SQL0338N NEEDS AN UPDATE AFTER THE ENHANCEMENT MADE SINCE 10.1 TO ALLOW SUBQUERIES IN AN ON CLAUSE
IT24696The db2support tool may remove database files, resulting in a database corruption or an instance-wide outage
IT24692LOAD COMMAND FAILS WHEN COLUMN NAME COMMENTS IS USED IN TARGET TABLE
IT24688QUERIES USING THE SAME UNNEST IN DIFFERENT PARTS OF THE PLAN COULD RETURN WRONG RESULTS FOR SOME COLUMNS
IT24687QUERIES USING THE SAME UNNEST IN DIFFERENT PARTS OF THE PLAN COULD RETURN WRONG RESULTS FOR SOME COLUMNS
IT24668HADR STANDBY LOG REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO BAD PAGE WHILE DOING AN INSERT
IT24665SCAN OF COLUMNAR TABLE WITH SYNOPSIS COULD PRODUCE DUPLICATE ROWS IF UNCOMMITTED INSERTS OR UPDATES WERE DONE
IT24663HADR STANDBY LOG REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO BAD PAGE WHILE DOING AN INSERT
IT24657MEMORY CORRUPTION DURING XA PROCESSING ON FEDERATED OBJECT
IT24656DB2PD CONTINUES CHECKING USER AUTHORITIES INSTEAD STOPPING AFTERCONFIRMING USER HAS THE REQUIRED AUTHORITY.
IT24655POSSIBLE TRAP / MEMORY CORRUPTION AFTER CONNECT RESET PERFORMED ON A LOAD
IT24652INDEX ACCESS MAY NOT BE CHOSEN FOR SUBPLAN WITH INSERT WITH COLUMN ORGANIZED TABLES
IT24645SECURITY: DB2CONVERT IS VULNERABLE TO BUFFER OVERFLOW
IT24642SECURITY: DB2CONVERT IS VULNERABLE TO BUFFER OVERFLOW
IT24641IN A AIX SPECIFIC PURESCALE ENV, DB2START MAY HIT SQL1659N DUE TO STATIC ROUTES NOT BEING CONFIGURED PROPERLY.
IT24632DB2 SERVER TERMINATES ABNORMALLY COMPILING A MERGE STATEMENT
IT24631DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING CORRELATED PREDICATES
IT24630DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING CORRELATED PREDICATES
IT24624INSTANCE MAY CRASH IN SQLRH_FREE_HANDLE
IT24609DB2EXPLN SEGV AND CRASHES THE SERVER
IT24602CREATING NEW CONNECTIONS BETWEEN MEMBER AND CACHING FACILITY ON PURESCALE CAN FAIL WITH A TIMEOUT ON OFED ROCE STACK
IT24592EXCEPTION MESSAGES THROWN BY .NET DRIVER ARE INCOMPLETE AND WRONG.
IT24585INSERTS TO A PAGE MAY NOT RE-USE RESERVED SPACE ON A PAGE PROPERLY WHICH CAUSES NEW PAGE ALLOCATION AND OVERFLOW RECORDS
IT24584INSERTS TO A PAGE MAY NOT RE-USE RESERVED SPACE ON A PAGE PROPERLY WHICH CAUSES NEW PAGE ALLOCATION AND OVERFLOW RECORDS
IT24581ALL HOSTS IN THE PURESCALE CLUSTER MUST HAVE AN ENTRY IN SQLLIB_SHARED/.UPDATE OR INSTALLFIXPACK COULD FAIL.
IT24578INSTALLATION OF DB2 V11.1.3.3 ON SOLARIS RAISES UNKNOWN KEYWORD "TSA_GPFS_ONLY"
IT24571IF THE LINUX ASLR FEATURE IS ENABLED, SEVERE DB2DIAG MESSAGES WITH TAG SQLO_ADDR_CONFLICT MAY BE INFREQUENTLY OBSERVED
IT24568DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING COMMON-TABLE-EXPRESSIONS
IT24567DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING COMMON-TABLE-EXPRESSIONS
IT24561ALTER TABLE ALTER COLUMN SET DEFAULT 'STRING LITERAL' ALLOWS VALUE > 254 BYTES.
IT24558ERROR SQL0102N RETURNED WHEN DB CFG VARCHAR2=ON, STMT_CONC=LITERALS AND STRING_UNITS=CODEUNITS32
IT24545DB2LOOK HAS DUPLICATE/INCORRECT COLUMN IN REFERENCES CLAUSE OF FOREIGN KEY DDL.
IT24539INSTANCE MAY CRASH IN SQLRH_FREE_HANDLE
IT24531AVOIDANCE COMPILATION AND PACKAGE CACHE FOR SET QUERY BYPASS STATEMENTS
IT24525SQL0332N AFTER ALTERING COLUMN LENGTH
IT24524RARE TIMING ISSUE MAY CAUSE INSTANCE CRASH ON BACKUP COMPLETION
IT24523DB2 PANICS DURING PARALLEL INSERT BRINGS THE INSTANCE DOWN
IT24522CAN NOT STOP ROLLFORWARD WHEN HITTING LOG CORRUPTION (PARTIAL RECORD AT THE END OF A TRUNCATED LOG FILE)
IT24520HADR LOG GAP ON AUXILARY STANDBY INCREASES SIGNFICANTLY WHILE ONLINE BACKUP IS RUNNING.
IT24519ROLLFORWARD ASKS FOR MORE LOGS THAT ARE NOT INCLUDED IN THE ONLINE BACKUP IMAGE
IT24518MANY DIFFERENT SIZED LOGS IN LOG DIRECTORY
IT24515DB2 ENGINE MIGHT HANG WHEN UPDATING STATISTICS FOR INDEXES ON XML COLUMNS
IT24513ADMIN_MOVE_TABLE: INTRODUCE OPTIONS TO PREVENT CREATION OF NON-UNIQUE INDEXES AND MODSTATE INDEX ON TARGET TABLE
IT24508DB2 ENGINE MIGHT HANG WHEN UPDATING STATISTICS FOR INDEXES ON XML COLUMNS
IT24497LOG_TO_FILE OPTION OF EVMON_FORMAT_UE_TO_XML TABLE FUNCTION CANNOT WRITE OUT XML DOCUMENT MORE THAN 100MB
IT24494OVERLAPS FUNCTION EXECUTED AGAINST COLUMNAR ORGANIZED TABLE COULD RETURN WRONG RESULTS IF INPUT COLUMNS HAVE NULL VALUES
IT24493LOCK EXCLUSIVE MDC TABLE WITH LOCKSIZE SET TO BLOCKINSERT, INSERTING ROWS WILL RESULT IN ADDITIONAL LOCKS BEING ACQUIRED.
IT24478SECURITY: BUFFER OVERFLOW IN DB2LICM
IT24477SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH
IT24476SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH
IT24475SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH
IT24474SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH
IT24473SECURITY: BUFFER OVERFLOW IN DB2LICM
IT24466SECURITY: RAH.EXE BUFFER OVERFLOW
IT24465SECURITY: RAH.EXE BUFFER OVERFLOW
IT24464SECURITY: RAH.EXE BUFFER OVERFLOW
IT24463SECURITY: PRIVELEGE ESCALATION VULNERABILIY IN THE DB2 DAS COMPONENT ON WINDOWS
IT24462SECURITY: PRIVELEGE ESCALATION VULNERABILIY IN THE DB2 DAS COMPONENT ON WINDOWS
IT24461SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN THE DB2 DAS COMPONENT ON WINDOWS
IT24456LOCK EXCLUSIVE MDC TABLE WITH LOCKSIZE SET TO BLOCKINSERT, INSERTING ROWS WILL RESULT IN ADDITIONAL LOCKS BEING ACQUIRED.
IT24450DB2 INSTANCE MIGHT PANIC AFTER FORCEDBSHUTDOWN
IT24447AFTER DB2 RECYCLE, DB2 STARTED ARCHIVING OLD LOG FILES CAUSING ACTIVE LOG FILESYSTEM QUICK GROWTH.
IT24445IF ONE OF THE PORTS IS DOWN ON A MEMBER, EVEN IF THERE IS ANOTHER FUNCTIONING PORT, DB2START MAY TIMEOUT.
IT24439SQL0440N ERROR CAN OCCUR WHEN QUERIES CONTAIN OUTER JOINS AND INNER JOINS
IT24434CREATE NICKNAME AGAINST AN ORACLE TABLE MAY FAIL WITH ERROR SQL0802N
IT24427THE PRIMARY AND SECONDARY HADR NODES ARE NOT DISPLAYED CORRECTLYIN "DB2PD -HA" OUTPUT
IT24425INDEX CORRUPTION MIGHT BE INTRODUCED ON A COMPRESSED INDEX DURING RECOVERY PROCESSING
IT24424FIRST TAKEOVERS AFTER MIGRATION FROM 9.7 TO 11.X CAN LOOP IN REMOVEEXTRACANDIDATES FUNCTION AND TIMEOUT
IT24418SQL0901 SQLRI_MAX SANITY CHECK FAILED
IT24417PREREQCHECK FAILS DB2ICRT ON AIX 7.2 TL01 SP3
IT24407TRAP IN SQLBPFADDTOQ WHEN RUNNING A QUERY INVOLVING A FETCH-IXSCAN PLAN AGAINST A BLU TABLE.
IT24403THE LIMITATION CONCERNING DB2 NON-DEFAULT STORAGE GROUPS AND RESTORE IS NOT DOCUMENTED
IT24390THE "DB2HAICU -DELETE" COMMAND MAY FAIL TO DELETE RESOURCES FOR THE INSTANCE IF A RESOURCE WAS INCOMPLETELY CREATED
IT24382DB2 SERVER MAY REPORT -901 WITH ERROR MESSAGE "PARENT OBJECT SHOULD NOT HAVE A SWIZZLE DEPENDENCY"
IT24381DB2 SERVER MAY REPORT -901 WITH ERROR MESSAGE "PARENT OBJECT SHOULD NOT HAVE A SWIZZLE DEPENDENCY"
IT24361DB2 V11.1 DB2DIAG.LOG MESSAGE WITH ERROR "FILE NOT FOUND" IN "SQLPGOPENLOGEXTENT, PROBE:10000" MAY BE MISLEADING
IT24355DB2ROCM CONSTANTLY CREATES DUMP FILES WHEN THE MEMBER IS STOPPED
IT24347INDEX CORRUPTION MIGHT BE INTRODUCED ON A COMPRESSED INDEX DURING RECOVERY PROCESSING
IT24346PERMISSIONS TO TBPSIZE_ENTITLEMENT_REQ.PL AND TBPSIZE_ENTITLEMENT_REQ.SQL FILES
IT24311SECURITY: RAH.EXE BUFFER OVERFLOW
IT24308CLPPLUS COLUMN COMMAND RESULTS -DB250408E: NO USER SUBSTITUTION VARIABLES ARE DEFINED
IT24301QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP"
IT24300ON FEDERATION, GETS SQL0214N RC=2 BY SELECT DISTINCT
IT24299DB2 CRASH IN DPF + SMP ENVIRONMENT AFTER INTERNAL INTERRUPT (SQL0952N)
IT24295RESTART OF A PARTITIONED DATABASE FAILS WITH SQL10003C ON NON-CATALOG PARTITION
IT24283SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN THE DB2 DAS COMPONENT ON WINDOWS
IT24280GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSINGCLAUSE MAY RETURN -901
IT24278GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSINGCLAUSE MAY RETURN -901 (FOR UPDATE STATEMENTS)
IT24274ATTEMPT TO INSTALL DB2 SERVER 10.5 64 BIT FIXPACK 9 FAILS DURINGUPGRADE WHEN DB2 V10.5 32 BIT ALREADY EXISTS ON WINDOWS
IT24232RARE TIMING ISSUE MAY CAUSE INSTANCE CRASH ON BACKUP COMPLETION
IT24218CLP CRASHES WITH DB21018E
IT24217SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24216SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24215SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24214DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
IT24213DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
IT24212SECURITY: DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
IT24205DB2 SERVER COULD CRASH IN RARE SCENARIOS WHEN PLAN HAS STACKED UNIONS
IT24201SQL0507N ERROR COULD OCCUR WHEN AN UPDATE TARGET TABLE RESIDES IN REMOTE DATA SOURCE
IT24200IN SPECIFIC TIMING CONDITIONS DB2READLOG API CALLER CAN THROW SQL2038N ERROR.
IT24193INTERMITTENT WRONG RESULTS ARE POSSIBLE WITH A PLAN WHERE COLUMNAR EARLY OUT NLJN IS PRESENT
IT24180CHECK SYNOPSIS TABLE WHENEVER IT IS QUERIED
IT24179DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH
IT24171SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24170SECURITY: DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
IT24155CONNECTIONS FAIL IN CRYPTDIGESTINIT WITH ECF_CRYPT_UNEXPECTED_ERROR
IT24131DB2 MAY DEADLATCH DURING AN INSERT INTO AN ITC TABLE WHILE THEREARE 2 OR MORE OTHER CONCURRENT IUD TRANSACTIONS
IT24129DB2 MAY DEADLATCH DURING AN INSERT INTO AN ITC TABLE WHILE THEREARE 2 OR MORE OTHER CONCURRENT IUD TRANSACTIONS
IT24126ERROR SQL0437W RC=13 WITH THE CERTAIN ROWS IN A GENERATING AN ACCESS PLAN WHEN USING AN OPTIMIZATION PROFILE.
IT24115DB2ACD MIGHT INCORRECTLY CHOOSE INDEX REBUILD DURING AUTOMATIC TABLE MAINTENANCE EVEN WHEN NO OFFLINE WINDOW IS AVAILABLE
IT24105DB2 MIGHT TRAP DURING ROLLBACK OF TRUNCATE TABLE
IT24104DB2 MIGHT TRAP DURING ROLLBACK OF TRUNCATE TABLE
IT24090AFTER DB2 RECYCLE, DB2 STARTED ARCHIVING OLD LOG FILES CAUSING ACTIVE LOG FILESYSTEM QUICK GROWTH.
IT24078DB2 MAY HIT SUSTAINABLE TRAP IN SQLNO_CREATE_TEMPORAL_KEYS PROCESSING
IT24063POSSIBLE TRAP (FODC) IN 'HDREDUACCEPTEVENT()' DUE TO INVALID CONNECTION SEQUENCE
IT24061UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT24060UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT24059SECURITY: UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT24058SECURITY: UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT24048FCM_PARALLELISM RETURNS WRONG VALUE IN V11.1 PURESCALE
IT24047SLOW INSERT PERFORMANCE IN PURESCALE BECAUSE UNCOMMITTED DELETED SLOTS AREN'T REUSED CORRECTLY

© Icons by Mark James www.famfamfam.com

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

IBM Db2 for Administrators

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

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.
More information Ok