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
IT26455WHEN USING REOPT OPTIMIZER GUIDELINE BATCH INSERTS MIGHT INSERT WRONG DATA
IT26454WHEN USING REOPT OPTIMIZER GUIDELINE BATCH INSERTS 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 SHUTDUWN 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
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
IT26290ERROR SQL2018N - LIMITATION OF DB2 CLOUD STORAGE FOR THE SUPPORTOF THE SIGNATURE 4 VERSION, REQUIRED FOR EU-CENTRAL-1
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
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()"
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
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.
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
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
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.
IT25869HADR GRACEFUL TAKEOVER ON PURESCALE COULD FAIL WITH SQL1770N RC7WHILE OLD PRIMARY DATABASE IS SWITCHING ROLE.
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
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
IT25755SAP JDBC NPE WITH KEEPDYNAMIC
IT25750SIGKILL ORIGINATING FROM DB2STOP FORCE NODENUM XX
IT25732DB2 IN DPF MAY HANG DURING IMPLICIT INDEX REBUILD ON COLUMNAR TABLE IF MORE THAN ONE INDEX IS RECREATED
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
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
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.
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
IT25522ERRORS WITH XML PROCESSING - XDBADVDOCHANDLER__ERROR, PROBE:1655
IT25519DB2INSTANCE -LIST COMMAND CAN FAIL WITH COREDUMP IF A ROUTING IS MISSING.
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
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 WHICH BUILT WITH SUPPLEMENTARY CHARACTERS FAILS TO CONVERT TO 1392 CODESET
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
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
IT25147QUERIES CONTAINING OUTER JOINS AND GROUP BY CLAUSES MIGHT PRODUCE WRONG RESULTS
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)
IT24956SQL0332N AFTER ALTERING COLUMN LENGTH
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
IT24847POSSIBLE SIGSEGV IN SQLDRETURNDATA WITH RANGE CLUSTERED TABLES
IT24841DB2 MIGHT TRAP WHEN EXECUTING COMPLEX QUERIES CONTAINING CSES
IT24840SECURITY: UPDATE IBM SDK, JAVA TECHNOLOGY EDITION QUARTERLY CPU - JAN 2018
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 MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING CASE SUB-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.
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
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
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
IT24425INDEX CORRUPTION MIGHT BE INTRODUCED ON A COMPRESSED INDEX DURING RECOVERY PROCESSING
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
IT24311SECURITY: RAH.EXE BUFFER OVERFLOW
IT24308BUG IN COLUMN COMMAND CLPPLUS
IT24301QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP"
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
IT24212DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
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.
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
IT24058UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT24047SLOW INSERT PERFORMANCE IN PURESCALE BECAUSE UNCOMMITTED DELETED SLOTS AREN'T REUSED CORRECTLY
IT24045QUERIES USING HASH JOINS MAY HANG AND NOT BE ABLE TO BE FORCED OFF
IT24041WRONG RESULTS OR SQL901N ERROR POSSIBLE WHEN EXECUTING SQL STATEMENT WITH SCALAR SUBQUERY ON COLUMN ORGANIZED TABLES
IT24028DB2 LOG REPLAY (RECOVERY, RFWD, HADR) MIGHT HANG WITH DB2REDOM IN SQLPRGETFREEQE->WAIT AND DB2REDOWS IN SQLPRFINDQUEUE->WAIT.
IT24027DB2 LOG REPLAY (RECOVERY, RFWD, HADR) MIGHT HANG WITH DB2REDOM IN SQLPRGETFREEQE->WAIT AND DB2REDOWS IN SQLPRFINDQUEUE->WAIT.
IT24004DB2ACD MIGHT INCORRECTLY CHOOSE INDEX REBUILD DURING AUTOMATIC TABLE MAINTENANCE EVEN WHEN NO OFFLINE WINDOW IS AVAILABLE
IT23978DB2 CLP FRONT END MIGHT HANG IN CLP_FP_SIG->SQLNLSMESSAGE AND LOCK DB2DIAG.LOG FILE
IT23966bad performance when replaying TLOGPREP_XA log records
IT23954HADR STANDBY FAILS WITH DBHEAP OUT OF MEMORY UPON RECONNECT
IT23941DB2 ABEND DUE TO MEMORY CORRUPTION USING COLUMN BASED TABLES
IT23938IN CDE, INCORRECT RESULTS MIGHT BE RETURNED FOR A QUERY THAT REFERENCES A CORRELATED SCALARY SUBQUERY IN A PREDICATE
IT23929THE TO_DATE FUNCTION IS NOT PUSHED DOWN CORRECTLY IN FEDERATED SETUP
IT23918NNSTAT MIGHT FAIL WITH SQL1227N THE CATALOG STATISTIC " " FOR COLUMN " " IS OUT OF RANGE FOR ITS TARGET COLUMN
IT23915SQL901N MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING UNION IN CDE
IT23909INTERMITTENT DB21018E ERROR RETURNED TO CLP DURING CONNECTION TOA DATABASE.
IT23907IN CDE, INCORRECT RESULTS MIGHT BE RETURNED FOR A QUERY THAT REFERENCES A CORRELATED SCALARY SUBQUERY IN A PREDICATE
IT23905INTERMITTENT DB21018E ERROR RETURNED TO CLP DURING CONNECTION TOA DATABASE.
IT23897DB2 SERVER TERMINATES ABNORMALLY COMPILING A MERGE STATEMENT
IT23894FEDERATION: COLUMN ALIAS IN REMOTE QUERY MAY BE MISSING, WHICH CAN CAUSE SQL0203N.
IT23875WRONG RESULTS ARE POSSIBLE WHEN EXECUTING A SQL STATEMENT ELIGIBLE FOR ZIGZAG JOIN ON A NON-PARTITIONED INDEX
IT23863APPLICATION ID IS NOT CAPTURED CORRECTLY BY ACTIVITY MONITOR, CAUSING NO INFO TO BE RETURNED WHEN RUNNING DB2EXPLN
IT23859DB2 CLP FRONT END MIGHT HANG IN CLP_FP_SIG->SQLNLSMESSAGE AND LOCK DB2DIAG.LOG FILE.
IT23848SQLCOLUMNS CLI FUNCTION MAY NOT WORK ON A TABLE NAME THAT INCLUDES MBCS CHARACTERS
IT23822MEMORY LEAK IN A DB2 PURESCALE ENVIRONMENT
IT23817RETRIEVE ARRAY GETTING FULL WHEN TWO OR MORE DB2READLOG API CALLERS TRYING TO READ FROM THE SAME LOG FILE
IT23814HADR LOG GAP ON AUXILARY STANDBY INCREASES SIGNFICANTLY WHILE ONLINE BACKUP IS RUNNING.
IT23812INSTANCE TRAP IS POSSIBLE WHEN QUERY AGAINST COLUMN ORGANIZED TABLES WITH OLAP SPECIFICATION IS RUN
IT23805.DB2TAG SHOULD BE CONVERTED TO .SWTAG AND NOT .SWIDTAG.
IT23804DB2 RESTORE MAY FAIL WITH ZRC=0X85020024=-2063466460=SQLB_TBLSPC_MAPS_TOO_BIG "MAP TOO BIG"
IT23803DB2 RESTORE MAY FAIL WITH ZRC=0X85020024=-2063466460=SQLB_TBLSPC_MAPS_TOO_BIG "MAP TOO BIG"
IT23799UNSAFE DESERIALIZATION IN DB2 JDBC DRIVER
IT23798UNSAFE DESERIALIZATION IN DB2 JDBC DRIVER
IT23797UNSAFE DESERIALIZATION IN DB2 JDBC DRIVER
IT23794SECURITY: UNSAFE DESERIALIZATION IN DB2 JDBC DRIVER
IT23791DB2 INVOKED THE USEREXIT TOO EARLY (USEREXIT WAS COPYING THE SOURCE LOG WHILE LOGGW WAS STILL WRITING NEW LOG DATA TO IT)
IT23787DATABASE MANAGER FAILS TO CREATE A NEW STRIPE SET OF CONTAINERS AND HANGS
IT23784QUERY FAILS WITH -901 FOUND ZERO CLOB.RESET OR -973
IT23775ALTER TABLE DROP COLUMN MAY TRAP
IT23768CHANGE PROBE WARNING IN DB2DIAG.LOG MESSAGE FROM "ERROR" TO "WARNING" FOR RETCODE : ZRC=0X801A006D=-2145779603=SQLZ_CA_BUILT (WL
IT23756DB2 MAY RETURN STMMSIMULATESORTMERGE ERROR AND NOT BENEFIT FROM SORT MEMORY SIMULATION
IT23742DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING OR PREDICATES AND EXISTS PREDICATES
IT23741A QUERY OVER NICKNAMES OR COLUMN ORGANIZED TABLES CONTAINING FETCH FIRST N ROWS ONLY CLAUSE MAY RETURN INCORRECT RESULTS
IT23724AMENDMENT ON SQL0270 RC= 113 MESSAGE
IT23720HADR: FAIL TO UNLOCK THE RESOURCE WHEN BOTH HOSTS COMING BACK ATSAME TIME CAUSES FREQUENT DISCONNECT AND BAD PERFORMANCE
IT23700INSTALLATION OF DATA PROTECTION SAP DB2/ORACLE FAILS WITH AN ILLEGAL INSTRUCTION EXCEPTION
IT23698DB2 MIGHT TRAP IN SQLRWPERFORMWORKLOADASSIGNMENT_NC() WHEN AGENTIS REUSED WITH ANOTHER DATABASE.
IT23694THE EXPLANATION FOR SQL0338N NEEDS AN UPDATE AFTER THE ENHANCEMENT MADE SINCE 10.1 TO ALLOW SUBQUERIES IN AN ON CLAUSE
IT23671SYSTOOLS.JSON_UPDATE CAN CRASH OR RETURN "BSON VALUE IS TOO LONG" WHEN UPDATING A NULL FIELD
IT23664A TRAP, PANIC OR A -901 SQLCODE (SQLRA_FREE_SECTION: SECTION NOT CLOSED) OCCURS IN DPF
IT23657Db2 skips verifying checksum for page from temp table
IT23650DB2 MAY TRAP WITH EXECUTING A QUERY WITH NODENUM OR DBPARTITIONNUM FUNCTION IN DPF ENVIRONMENT.
IT23649DB2 MIGHT TRAP WHEN EXECUTING A QUERY REFERENCING NODENUMBER OR DBPARTITIONNUM FUNCTION IN DPF ENVIRONMENT
IT23647DB2 MAY TRAP WITH EXECUTING A QUERY WITH NODENUM OR DBPARTITIONNUM FUNCTION IN DPF ENVIRONMENT.
IT23630RUNNING "DB2LOOK -L" IN DPF RESULTS IN VERY HIGH MEMORY USAGE - MEMORY LEAK
IT23629DB2LOOK WHEN USED WITH "-l" OPTION FAILS WITH ERROR SQL1635N orSQL1092N
IT23619TRANSACTION ID TABLE OVERFLOWED DURING HADR REPLAY
IT23617TRANSACTION ID TABLE OVERFLOWED DURING HADR REPLAY
IT23597JCC DRIVER CHARSET 1129 CONNECTIVITY ISSUE
IT23578SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR
IT23577INSTANCE CRASH WHEN CAPTURING SECTION EXPLAIN INFORMATION FOR SQL STATEMENT THAT CAN PRODUCE A VERY LARGE OPTIMIZED STATEMENT
IT23575JCC SECURITY VULNERABILITY
IT23571SQL0901N/-901 FODC_APPERR ON ALTER TABLE DROP COLUMN
IT23567CALLING/LOADING MF COBOL FENCED 32-BIT ROUTINE TRAPS IN LOAD() ON AIX 7.1 DUE TO MEMORY OVERWRITE
IT23562SYSPROC.REORGCHK_IX_STATS RETURNING INCORRECT VALUES OF F4 COLUMN FOR PARTITIONED TABLES
IT23558DBT5513N THE DB2CKUPGRADE UTILITY FAILED BECAUSE THE SYSCATSPACETABLE SPACE REQUIRES MORE SPACE IN ORDER TO COMPLETE THE UPGRAD
IT23557FEDERATED QUERY CONTAINING ROWNUM CRITERIA MISSING IN REMOTE SQL
IT23551INSTALLING IBM DATA SERVER RUNTIME CLIENT VIA SILENT INSTALL, FAILS TO CREATE A DB2 INSTANCE
IT23550DB2CLUSTER -CHFS -LIST -LOCALOSTVERSION COULD SHOW INCORRECT GPFS VETSION.
IT23535DOCUMENTATION TO PREVENT UNWANTED RESULTS WITH THE 7.1.8 AND 8.1.2 CLIENT ENHANCEMENTS BY INCOMPATIBLE LOCAL GSKIT VERSION
IT23534DB2LOOK WARNING NUMBER OF KEYS IN INDEX LIMITED TO 16 FOR DB2Z
IT23474DB2READLOG API SOMETIMES SLOW DOWN UNDER HEAVY WORKLOAD.
IT23463DB2LOOK FAILS WITH SQL0423N LOCATOR VARIABLE "1" DOES NOT CURRENTLY REPRESENT ANY VALUE.
IT23441DB2 MEMBER IS KILLED AND RESTARTED DUE TO GPFS MOUNT RESOURCE TEMPORARILY REPORTING OFFLINE
IT23438Running db2cluster to change hostfailuredetectiontime may fail indicating that the shared file system cluster must be stopped.
IT23431STATEMENT MAY FAIL WITH FOLLOWING ERROR: PERMANENT TAOB FOR MDC BIXA OBJECT IS NULL
IT23430DUMP.BIN FILES ARE GENERATED ON HADR STANDBY SERVER
IT23421ONCE SQL0954C IS FACED WITH APPLHEAPSZ DURING DB UPGRADE MAKE THE PARAMETER AUTO INTERNALLY FOR THE UPGRADE DURATION.
IT23420THE MOUNTV111_STOP.KSH SCRIPT MAY ERRONEOUSLY RUN THE FUSER -K COMMAND AGAINST THE ROOT FILE SYSTEM
IT23419Extra spaces generated from export when using codeunits32
IT23418Extra spaces generated from export when using codeunits32
IT23403RETRIEVE ARRAY GETTING FULL WHEN TWO OR MORE DB2READLOG API CALLERS TRYING TO READ FROM THE SAME LOG FILE
IT23402"CLP SELECT STATEMENT DISPLAY FIX FOR CHAR AND VARCHAR CODEUNITS32 STRING UNITS"
IT23400THE "DB2HAICU -DELETE" COMMAND MAY FAIL TO DELETE RESOURCES FOR THE INSTANCE IF A RESOURCE WAS INCOMPLETELY CREATED
IT23377RUBY APPLICATION OCCASIONALLY HANGS DURING FETCHING DATA
IT23376SQL0901N - REASON "INT. ERROR: QUERIED PERIOD IS NOT DEFINED" WHEN USING TEMPORAL TABLES
IT23375SQL0901N - REASON "INT. ERROR: QUERIED PERIOD IS NOT DEFINED" WHEN USING TEMPORAL TABLES
IT23360DB2READLOG API CAN HANG IN PURESCALE.
IT23359WHEN RUNNING A INGEST YOU ARE ABLE TO SELECT ROWS THAT HAVE BEENCOMMIT BY INGEST EVEN THOUGH NOT COMPLETED.
IT23357LOGTS BUFFER FULL CAUSING SLOW PERFORMANCE
IT23355ADDRESS MASTER SERVER BLACKOUT ISSUE AND DEK CACHING
IT23353SQL0901/SQL0404/ABEND when compiling UPDATE statement
IT23350DB2 MAY RETURN SQL0901N: EMPTY PLAN LIST DETECTED
IT23349DB2 MAY RETURN SQL0901N: EMPTY PLAN LIST DETECTED
IT23341WRONG RESULTS ARE POSSIBLE WHEN EXECUTING A SQL STATEMENT ELIGIBLE FOR ZIGZAG JOIN ON A NON-PARTITIONED INDEX
IT23322DB2LICM -L OUTPUT ON 11.1FP2 AESE/AWSE SHOWS IBM DB2 PERFORMANCEMANAGEMENT OFFERING IS NOT LICENSED.
IT23321DB2 MIGHT PANIC WHEN ATTEMPTING TO UNLOCK AN INVALID LATCH AFTER HDRCLOSECONN CALL ON TCP/IP ERROR
IT23319-901 ERROR IN SOME CASES WHEN EXPLAIN MODE IS ON AND A STATEMENTIS RUN TWICE
IT23318INCORRECT MISSING LOG FILE NUMBER IS REPORTED IN ERROR MESSAGES
IT23315A TRAP, PANIC OR A -901 SQLCODE (SQLRA_FREE_SECTION: SECTION NOT CLOSED) OCCURS IN DPF
IT23313QUERY FAILING WITH -901 ERROR UNEXPECTED ERROR AT DATATYPEIMPL.HPP:
IT23310WHEN USING SCRIPTED INTERFACE TIMESTAMP IN PROTOCOL FILE NAME AND IN CONTENTS OF PROTOCOL FILE MAY NOT BE EQUAL
IT23308.NET APPLICATION MAY FAIL WITH SYSTEM.ACCESSVIOLATIONEXCEPTION EXCEPTION
IT23295"CLP SELECT STATEMENT DISPLAY FIX FOR CHAR AND VARCHAR CODEUNITS32 STRING UNITS"
IT23294THE CAPTURE PROGRAM OF Q-REPLICATION TERMINATES WITH SQL2038N ONDB2 PURESCALE
IT23284MQFUNCTIONS DO NOT FUNCTION PROPERLY IN DB2 V11.1 ON AIX
IT23281THE DB2HAICU UTILITY MAY APPEAR TO HANG IN A DPF HA ENVIRONMENT CONTAINING MANY HOSTS
IT23275ADMIN_MOVE_TABLE DOES NOT TRANSFER INDEX RANDOM COLUMN ORDER
IT23269"SET ENCRYPTION PASSWORD" TRIGGER/SPL CAN CAUSE SQLCODE -20143
IT23267A QUERY OVER NICKNAMES CONTAINING FETCH FIRST N ROWS ONLY CLAUSEMAY RETURN INCORRECT RESULTS
IT23265FED:UNDER QUERIES:UNION: ERROR HANDLING FOR DISTINCT FROM SELECT_LIST FOR LOLEPOP: SORT.
IT23261INCORRECT RESULTS WITH AGGREGATION ON OUTER JOINED TABLE WITH FOREIGN KEY ON NULL PRODUCING TABLE
IT23260INCORRECT RESULTS WITH AGGREGATION ON OUTER JOINED TABLE WITH FOREIGN KEY ON NULL PRODUCING TABLE
IT23256WITH INFINITE LOGGING, AFTER FAILED LOG ARCHIVAL, TRANSACTION MIGHT GET STUCK DUE TO MAXIMUM ALLOWABLE UNARCHIVED LOG
IT23254Db2 HADR standby db can shutdown when log archive path is sharedwith a different database
IT23249EXECUTING A 4-PART NAME QUERY FROM MS SQL SERVER HANGS
IT23245TRAP WHEN IN/EXISTS SUBQUERY IN SELECT LIST AND ACCESS CONTROL ACTIVATED
IT23243TRAP WHEN IN/EXISTS SUBQUERY IN SELECT LIST AND ACCESS CONTROL ACTIVATED
IT23238HANG CAUSED BY DB2VEND PROCESS IN ACTIVATION PROCESS
IT23225INSTALLATION WITH WINDOWS EXTENDED SECURITY DISABLED BEHAVES AS THOUGH WINDOWS EXTENDED SECUIRTY WAS ENABLED.
IT23214Disk full for mirror logpath hit after updating logging method from archive to circular
IT23206SQL5133N AFTER MOVING A DB2 CLIENT INSTALLATION TYPE TO SERVER TYPE
IT23205ASYNCHRONOUS INDEX CLEANUP FAILS WHEN DB2LOCK_TO_RB IS SET TO STATEMENT
IT23204ASYNCHRONOUS INDEX CLEANUP FAILS WHEN DB2LOCK_TO_RB IS SET TO STATEMENT
IT23202LOAD OF BITEMPORAL TABLES MIGHT FAIL TO DETECT DUPLICATE / OVERLAPPING ROWS WITH INDEXING MODE REBUILD
IT23198SQL0156N WHEN UPDATING STATISTICS IN SYSSTAT.TABLES
IT23197SQLO_DISK MISLEADING ERROR MESSAGE IN DB2DIAG.LOG WHEN VERIFYINGSMS BAD PAGE.
IT23185MEMORY CORRUPTION DURING XA PROCESSING ON FEDERATED OBJECT
IT23181Disk full for mirror logpath hit after updating logging method from archive to circular
IT23180POSSIBLE TRAP IN SQLNN_ERDS() + 901 WHEN RUNNING QUERY WITH NAMED PARAMETER MARKERS IN FEDERATED ENVIRONMENT
IT23177ADMIN_MOVE_TABLE COULD CAUSE DATABASE CRASH WHILE COMPLETE WITH WARNINGS
IT23174[IFIX002_FINAL] SERVER_DEC IMAGE DOES NOT HAVE CORRECT LICENSE APPLIED
IT23173DECREASED PERFORMANCE, STMMSTARTHJMONITORIFNECESSARY ERRORS LOGGED IN CONSTRAINED/VOLATILE STMM ENVIRONMENTS
IT23166ASYNCHRONOUS INDEX CLEANUP FAILS WHEN DB2LOCK_TO_RB IS SET TO STATEMENT
IT23161UNDER DB2 DEVELOPER-C EDITION LICENSE, CREATE DATABASE WILL FAIL WITH SQL1139N.
IT23158SQL0901N COULD CAUSE INSTANCE OUTAGE FOR CDE CENTERED QUERIES, IF MESSAGE IS LONGER THEN 256 BYTES.
IT23157SQLO_DISK MISLEADING ERROR MESSAGE IN DB2DIAG.LOG WHEN VERIFYINGSMS BAD PAGE.
IT23147CBITS WAS MESSED UP WHEN MIGRATE OLD V2 PAGE DURING BACKUP
IT23146DB2VAL MAY CRASH IN DB2 10.5FP9
IT23141INTERMITTENT LOAD ABNORMAL END IN THE BUILD PHASE: UNEXPECTED MSG. , 28, 0, DETECTED IN FILE:SQLUVLD.C, LINE:5506
IT23135DUMP.BIN FILES ARE GENERATED ON THE HADR PRIMARY SERVER
IT23134DUMP.BIN FILES ARE GENERATED ON HADR STANDBY SERVER
IT23132DB2TS UPDATE INDEX COMMAND FAILS WITH CIE00759 COMMUNICATION TIMEOUT AFTER 2-HOURS HANG.
IT23130POSSIBLE HANG BETWEEN 3 EDUS INVOLVING SQLO_LT_SQELOCALDATABASE__DBLATCH AND ANOTHER UNTRACKED LATCH
IT23129CREATE DATABASE RETURNS -1051

© Icons by Mark James www.famfamfam.com

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