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
IT22704HADR STANDBY ONLY WRITES ONE LOG PAGE AT A TIME TO DISK DURING REMOTE CATCHUP STATE WHICH COULD MAKE THE GAP BIGGER
IT22684SQL STATEMENTS EXECUTING AN INDEX SCAN WITH INTRA-PARTITION PARALLELISM ENABLED MIGHT RUN SLOW
IT22674EXPLAIN STATEMENT INCLUDING A PARAMETER MAKER FROM JCC APPLICATION MAY CAUSE THE INSTANCE CRASH
IT22673DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER
IT22665-901 OR TRAP WHEN OUTER JOIN ON GROUP BY AND UNION
IT22658EXPLAIN STATEMENT INCLUDING A PARAMETER MAKER FROM JCC APPLICATION MAY CAUSE THE INSTANCE CRASH
IT22646-901 OR TRAP WHEN OUTER JOIN ON GROUP BY AND UNION
IT22599UNABLE TO LOAD MORE THAN 2GB THROUGH REMOTE EXTERNAL TABLE USINGDB2 CLIENTS.
IT22593WLM STMT THRESHOLD DO NOT STOP EXECUTION WHEN SPECIFIC SQL IS RUN.
IT22580CRASH MAY BE ENCOUNTERED WHILE COLLECTING EXPLAIN ON A QUERY.
IT22567DB2READLOG API CAN HANG IN PURESCALE.
IT22566DIAGPATH IS CHANGED TO SQLLIB/DB2DUMP FROM THE DEFAULT PATH DURING CREATING ESE INSTANCE
IT22560AFTER ARCHIVING TO FAILARCHPATH, ARCHRETRYDELAY SETTING IS IGNORED
IT22555DIAGPATH IS CHANGED TO SQLLIB/DB2DUMP FROM THE DEFAULT PATH DURING CREATING ESE INSTANCE
IT22524HADR STANDBY CAN BECOME UNABLE TO DELETE EXTRA LOGS IN ACTIVE PATH, CAUSING LOGS TO ACCUMULATE
IT22522CHECK SYNOPSIS TABLE WHENEVER IT IS QUERIED
IT22504DB2 INVOKED THE USEREXIT TOO EARLY (USEREXIT WAS COPYING THE SOURCE LOG WHILE LOGGW WAS STILL WRITING NEW LOG DATA TO IT)
IT22494QUERY CONTAINS COUNT(CONSTANT) OR COUNT_BIG(CONSTANT) MIGHT RETURN INCORRECT RESULT
IT22459WLM STMT THRESHOLD DO NOT STOP EXECUTION WHEN SPECIFIC SQL IS RUN.
IT22453DB2 MAY INCORRECTLY RETURN SQL0420N WHILE COMPILING A QUERY CONTAINING UNION ALL OPERATORS
IT22443TRANSFER OWNERSHIP OF A VIEW THAT IS BASED ON A MODULE VARIABLE FAILS WITH SQL20342N
IT22440DB2 MAY HANG ON QUERIES INVOLVING INDEX COLUMNS WITH INTRA_PARALLEL ENABLED
IT22435VARIOUS -901 SQLCODES AND TRAPS DURING COMPILATION RELATING TO ACCESS OF THE TABLE PACKED DESCRIPTOR
IT22434DB2 PURESCALE HANG DUE TO MISSING LOCK NOTIFICATION
IT22432THE INSTANCE CAN TRAP IN XA FUNCTION TRAPPED IS SQLPRESETXIDINTENTRY WHEN DBHEAP IS SET TO A LOW VALUE
IT22430DB2: SILENT INSTALLATION MIGHT FAIL WITH SEGV IN ENCODEPASSWORD->STRCPY IF CRYPT() RETURNS AN ERROR (E.G. WITH FIPS_ENABLED)
IT22428THE INSTANCE CAN TRAP IN XA FUNCTION TRAPPED IS SQLPRESETXIDINTENTRY WHEN DBHEAP IS SET TO A LOW VALUE
IT22425INFINITE LOOP IN OSSCOMPUTEMONTGOMERYINVERSE32(), ROOT CAUSE UNKNOWN, ADD DIAGNOSTIC DUMPS
IT22422TRANSFER OWNERSHIP OF A VIEW THAT IS BASED ON A MODULE VARIABLE FAILS WITH SQL20342N
IT22392SQL0420 AFTER UPGRADE TO V11.1
IT22386DB2 : IF ANY COMMAND WITH RECLAIM EXTENTS OPTION IS RUN ON AN MDC TABLE DURING A BACKUP, A ROLLFORWARD ON IT COULD FAIL
IT22385DB2 : IF ANY COMMAND WITH RECLAIM EXTENTS OPTION IS RUN ON AN MDC TABLE DURING A BACKUP, A ROLLFORWARD ON IT COULD FAIL
IT22363SAP: POOR PERFORMANCE WHEN SAP MEMORY TABLE IN JOIN ON COLUMN ORGANIZED TABLES
IT22361SAP: POOR PERFORMANCE WHEN SAP MEMORY TABLE IN JOIN ON COLUMN ORGANIZED TABLES
IT22360WRONG RESULT WHEN EXPRESSION ON JOIN COLUMN
IT22357CALLING UTL_FILE.FCLOSE_ALL MAY CAUSE THE INSTANCE TRAP
IT22352DB2 : IF ANY COMMAND WITH RECLAIM EXTENTS OPTION IS RUN ON AN MDC TABLE DURING A BACKUP, A ROLLFORWARD ON IT COULD FAIL
IT22345WRONG RESULT WHEN EXPRESSION ON JOIN COLUMN
IT22343SQL0901N UNEXPECTED ERROR AT DATABASETABLEACCESSOR.HPP:1357"
IT22324WRONG RESULT WHEN EXPRESSION ON JOIN COLUMN
IT22297DB2 MIGHT TRAP WHEN EXECUTING COMPLEX QUERIES CONTAINING CSES
IT22284APPLICATION HEAP CAN BE EXHAUSTED BY REBAL FUNCTION AND THIS CANLEAD TO APPLICATION FAILURE WITH OUT OF MEMORY
IT22260INSTANCE CRASH AFTER RUNNING OUT OF MEMORY
IT22237THE DB2FMCD PROCESS DOES NOT START DB2 INSTANCES AT SYSTEM BOOT TIME.
IT22216HADR STANDBY CAN BECOME UNABLE TO DELETE EXTRA LOGS IN ACTIVE PATH, CAUSING LOGS TO ACCUMULATE
IT22211QUERY PERFORMANCE ISSUE WITH SMP PARALLELISM AND "LIMIT ?" CLAUSE
IT22210QUERY PERFORMANCE ISSUE WITH SMP PARALLELISM AND "LIMIT ?" CLAUSE
IT22207SQL0901N "COLUMN NUMBER OUT OF RANGE" ERROR WHEN GROUP BY IN NULL PRODUCING SIDE OF OUTER JOIN
IT22199POSSIBLE TRAP IN SQLNGSECTALLOCATEINTERNAL() WHEN RUNNING LARGE AND COMPLEX QUERIES
IT22197SQL0901N "COLUMN NUMBER OUT OF RANGE" ERROR WHEN GROUP BY IN NULL PRODUCING SIDE OF OUTER JOIN
IT22189SUPPORTING 1390/1390A AND 16684/16684A CONVERTERS WITH JDK 1.8
IT22188REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN
IT22183IF A PREPARED STATEMENT HAS A COMMENT WITHOUT PROPER MATCHING SINGLE QUOTE, ERROR HAPPENS.
IT22175QUERY FAILING WITH -901 ERROR UNEXPECTED ERROR AT DATATYPEIMPL.HPP:
IT22174CLI0150E WHEN SETTING CURSORHOLD ON VIA CLI APPLICATION THAT CONNECTS TO SERVER RUNNING ON LINUX PPC 64-BIT LE ENVIRONMENT
IT22162CONVERSION BETWEEN DIFFERENT CODE PAGES CAN LEAD TO UNEXPECTED TRUNCATION OF DATA
IT22161CONVERSION BETWEEN DIFFERENT CODE PAGES CAN LEAD TO UNEXPECTED TRUNCATION OF DATA
IT22160SEVERE ERRORS IN THE DB2DIAG.LOG RELATED TO INGEST(SQLUDISHM::CLEANFORMATTERBLOCK)
IT22148SEVERE ERRORS IN THE DB2DIAG.LOG RELATED TO INGEST(SQLUDISHM::CLEANFORMATTERBLOCK)
IT22132THE DB2CKUPGRADE TOOL DOES NOT CHECK IF THERE IS ENOUGH FREE SPACE IN DMS TEMPORARY TABLE SPACE BEFORE UPGRADE.
IT22130THE DB2CKUPGRADE TOOL DOES NOT CHECK IF THERE IS ENOUGH FREE SPACE IN DMS TEMPORARY TABLE SPACE BEFORE UPGRADE.
IT22118WINDOWS EVENT HANDLE LEAK WITH PARALLELIZED QUERY PLANS (INTRA_PARALLEL YES) - MAY CAUSE OSERR 1450
IT22113"DB2INSTANCE -LIST" MAY NOT SHOW ALERTS WHEN "DB2CLUSTER -CFS -LIST -FILESYSTEM <FSNAME> -DISK" IS ISSUED BY ROOT.
IT22111CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES WHEN HASH TABLE NEEDS TO BE SPILLED FOR A GROUPBY
IT22110CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES DURING HASH TABLE JOIN
IT22100ALTER TABLE DROP COLUMN MAY TRAP
IT22091CONVERSION BETWEEN DIFFERENT CODE PAGES CAN LEAD TO UNEXPECTED TRUNCATION OF DATA
IT22077HANG IN SQLESERVICECLASSDEREGISTERSYSENTITY WHILE HOLDING SQLO_LT_SQLE_SERVICE_CLASS__SERVICECLASSLATCH
IT22050DB2 : MISSING DATA ON QUERY WITH CURRENTLY COMMITTED FEATURE, WHEN SUCH QUERY IS EXECUTED IN THE MIDDLE OF COMMIT PROCESSING
IT22036DB2 MAY TRAP IN SQLEXGETENCRYPTIONSTRINGS FUNCTION.
IT22008DB2DART MIGHT TRAP WHEN FACED WITH CORRUPTIONS IN BLU TABLES
IT21985DOING LIKE ON A CODEUNITES32 FIXED LENGTH COLUMN &#160;IN THE COLUMNAR ORGANIZED TABLE COULD RETURN AN INCORRECT RESULT
IT21974SECURITY: USER WITHOUT PROPER AUTHORITY CAN ACTIVATE DATABASE.
IT21973SECURITY: USER WITHOUT PROPER AUTHORITY CAN ACTIVATE DATABASE.
IT21971DOING LIKE ON A CODEUNITES32 FIXED LENGTH COLUMN &#160;IN THE COLUMNAR ORGANIZED TABLE COULD RETURN AN INCORRECT RESULT
IT21965DB2UNINS CANNOT BE USED FROM INSTALLED COPY
IT21936DB2 OPTIMIZER MIGHT PRODUCE SUB-OPTIMAL ACCESS PLAN FOR QUERY REFERENCING COLUMN ORGANIZED TABLE WITH PRIMARY KEY
IT21897WRONG RESULT IS POSSIBLE WHEN CODEUNITS 32 IS USED IN A ROW DATATYPE ASSIGNMENT AND CAST IS USED
IT21777DB2 TEXT SEARCH MAY NOT RESPOND BY ECMTS SERVER HIGH CPU USAGE
IT21772INCORRECT LENGTH FOR SQL_LOCAL_LEN AND SQL_CODESET_LEN ON AIX
IT21771SQL30082 RC=15, PASSWDEXPIRED ERRNO=22 IF MISSING 64-BIT GSA MODULE
IT21767SQL30082 RC=15, PASSWDEXPIRED ERRNO=22 IF MISSING 64-BIT GSA MODULE
IT21760DB2 MAY RETURN WRONG RESULTS WITH ORACLE COMPATIBILITY AND SUBSTR
IT21691REORG, LOAD, TRUNCATE, DROP TABLE ON 10.5FP8 MAY BE SLOW WHEN DELETING PAGE ON CF
IT21679DB2IUPGRADE FAILS BECAUSE NO DB2_INSTANCE_END PORT IN SERVICES FILE.
IT21672SQL0408N ERROR FOR ALTER MODULE
IT21671SQL0408N ERROR FOR ALTER MODULE
IT21661AUTOMATIC RESTART(AR) INTERFERING WITH ROLLFORWARD CAUSES SQL1035
IT21623DB2CLUSTER -CFS -EXIT -MAINTENANCE MAY FAIL WITH RC=2
IT21605SQL0408N ERROR FOR ALTER MODULE
IT21604DB2 SERVER TERMINATES ABNORMALLY IN SQLNLS_UNPADDEDCHARLEN DURING QUERY COMPILATION
IT21593INGEST MAY USE EXCESSIVE AMOUNT FOR OVERFLOW MEMORY
IT21591SCA SEARCH AND INSERT LOGIC CAN LEAD TO A PERFORMANCE BOTTLENECKFOR AN XA WORKLOAD
IT21587DB2 TAKEOVER HADR COMMAND FAILS WITH SQL1387W IN AUTOMATED HADR ENVIRONMENT
IT21578FILEDSN IS NOT WORKING WITH V111M2FP2. DB2CLIO.DLL FAILS WITH SYSTEM ERROR 1114.
IT21576SQL0901N "NO SPACE TO INSERT KEY INTO CHT 85 0"
IT21569DURING CRASH RECOVERY, A LOG FILE MAY BY UNEXPECTEDLY OVERWRITTEN WHEN USING CIRCULAR LOGGING
IT21556DURING CRASH RECOVERY, A LOG FILE MAY BY UNEXPECTEDLY OVERWRITTEN WHEN USING CIRCULAR LOGGING
IT21553THE PRIMARY HADR DATABASE FAILS OVER TO THE STANDBY AFTER CONFIGURING FOR HA VIA DB2HAICU.
IT21539DB2ADUTL UPLOAD ALWAYS ESTIMATES BACKUP SIZE AT 4 MB
IT21535DB2ADUTL UPLOAD ALWAYS ESTIMATES BACKUP SIZE AT 4 MB
IT21530DB2CLUSTER ADD DISK TO A FILESYSTEM MAY FAIL IF THE FILESYSTEM CONTAINS A LARGE NUMBER OF DISKS
IT21517RUNNING INSPECT ON A TABLE SPACE MAY HANG CAUSING OTHER QUERIES ON THE SAME TABLE SPACE TO HANG
IT21509HASH FUNCTION FOR EMPTY BLOB RETURNS SQL0083C ERROR
IT21487DB2LOOK CORE DUMPS IN FUNCTION create_fkey_ddl
IT21485SCRIPTS FAILS WITH SQLSTATE 42702 / SQLCODE: -204
IT21468CRASH RECOVERY FAILED DUE TO MISSING OF ROR FILE
IT21467DB2ROCM CONSTANTLY CREATES DUMP FILES WHEN THE MEMBER IS STOPPED
IT21466SQL0901 from sqlnn_erds when executing UPDATE query
IT21465SECURITY: DB2 CAN BE USED TO OVERWRITE ARBITRARY FILES OWNED BY DB2 INSTANCE
IT21464SECURITY: DB2 CAN BE USED TO OVERWRITE ARBITRARY FILES OWNED BY DB2 INSTANCE
IT21463SECURITY: DB2 CAN BE USED TO OVERWRITE ARBITRARY FILES OWNED BY DB2 INSTANCE
IT21462SECURITY: USER WITHOUT PROPER AUTHORITY CAN ACTIVATE DATABASE.
IT21460DB2_FMP_COMM_HEAPSZ VALUES GREATER THAN 1GB NOT HONORED
IT21459SECURITY: USER WITHOUT PROPER AUTHORITY CAN ACTIVATE DATABASE.
IT21458SECURITY: DB2 CAN BE USED TO OVERWRITE ARBITRARY FILES OWNED BY DB2 INSTANCE
IT21455SECURITY: DB2CONNECT SERVER CAN CRASH UNDER SPECIFIC CONDITIONS.
IT21454SECURITY: DB2CONNECT SERVER CAN CRASH UNDER SPECIFIC CONDITIONS.
IT21441PROCESSOR SPECIFIC OPTIMIZATIONS ARE NOT USED AS EXPECTED
IT21440INSTANCE CRASH EVENT MONITOR WHEN PERFORMING A LOAD VIA CURSOR
IT21437ON ENCRYPTED DATABASES RUNNING EXTENT MOVEMENT EXTENTLATCH HELD BY PAGE CLEANER NOT RELEASED CAUSING HANG
IT21430DB2 MAY ABEND WHILE TRACING IS ON
IT21424THE PRIMARY HADR DATABASE FAILS OVER TO THE STANDBY AFTER CONFIGURING FOR HA VIA DB2HAICU.
IT21422DB2 MAY ABEND WHILE TRACING IS ON
IT21413BLOCK DROPPING OF CF DURING ROLLING UPGRADE
IT21412INSTANCE CRASH EVENT MONITOR WHEN PERFORMING A LOAD VIA CURSOR
IT21406DB2LOOK FOR TIMESTAMP COLUMNS GENERATES TIMESTAMP(9) WHEN DEFINED ON DB2 FOR Z/OS
IT21403FLOATING POINT TO DECIMAL CONVERSION IN ORA MODE CAN RESULT IN LESS ACCURATE RESULTS FOR NUMBERS WITH LARGE SCALE
IT21402FLOATING POINT TO DECIMAL CONVERSION IN ORA MODE CAN RESULT IN LESS ACCURATE RESULTS FOR NUMBERS WITH LARGE SCALE
IT21400SERVER TERMINATES ABNORMALLY DURING QUERY EXECUTION
IT21396ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21395ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21394ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21379IN DPF OR PURESCALE, TRAP OR HANG POSSIBLE AFTER INTERRUPT OF INTERNAL SQL
IT21364ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21363UNKNOWN COLUMN NAME TYPE_NAME -4460
IT21361DB2 DOES NOT CAST THE JOIN COLUMNS CORRECTLY, LEADING TO A -901 ERROR IN CDE
IT21354JCC 4.22.29 INVALID PARAMETER: UNKNOWN COLUMN NAME TYPE_NAME. ERRORCODE=-4460
IT21347SECURITY: CONNECTION STRING DISPLAYED IN ERROR MESSAGE
IT21327DB2 TAKEOVER HADR COMMAND FAILS WITH SQL1387W IN AUTOMATED HADR ENVIRONMENT
IT21317DB2 RESETS THE SYSLOG FACILITY TO USER
IT21315DURING NORMAL PROCESSING "ROUTINE FAILED WITH TERMINATION ERROR"ARE LOGGED AS ERROR IN DB2DIAG.LOG
IT21312In HADR, primary database could be brought down due to no heap memory is available
IT21309WRONG ERROR MESSAGE
IT21299THE CLI LOAD API MAY ABNORMALLY END (ABEND) ON CERTAIN VERSIONS OF LINUX
IT21273DB2AUDIT: USE OF UNINITIALIZED OBJECT SCHEMA IN AUDIT DATA.
IT21261DB2 MAY ABEND WHEN PLANS WITH SMP SORTS ARE INTERRUPTED
IT21260DB2 MAY ABEND WHEN PLANS WITH SMP SORTS ARE INTERRUPTED
IT21245DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES WHEN USING SQLDATAREADER
IT21244DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES WHEN USING SQLDATAREADER
IT21243DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES WHEN USING SQLDATAREADER
IT21242SQL0901N WHEN SAP MEMORY TABLE JOINS WITH UNION DISTINCT HAVING JOIN
IT21240SQL0083C - MEMORY ALLOCATION ERROR WHEN SAME COLUMN IN LOCAL ANDIN PREDICATE IN CASE STATEMENT
IT21236MEMBER PANIC DUE TO INVALID MEMORY SIZE IN SQLEINITWLDISPATCHER()
IT21235CLP MIGHT RETURN SQL1246N OR SQL1024N INTERMITTENTLY DUE TO DUPLICATE QUEUE ID.
IT21221LIST INDOUBT TRANSACTIONS MAY NOT RETURN TO PROPMT
IT21220CYCLIC JOIN IN STATISTICAL VIEW DEFINITION CAN LEAD TO CARDINALITY UNDER-ESTIMATION
IT21214WRONG TRIGGER IS BEING DROPPED FROM PACKED DESCRIPTOR RECORD IF USING LONGER SCHEMA NAME AND SAME TRIGGER NAME.
IT21211SLOW DATABASE ACTIVATION, CREATE/ALTER BUFFERPOOL, LOAD OPERATIONS ON LARGE WINDOWS SYSTEMS
IT21209SLOW MEMORY ALLOCATIONS OR POSSIBLE SEVERE DEGRADATION DURING OOM HANDLING DUE TO COALESCE MEMORY CHECK
IT21207SLOW MEMORY ALLOCATIONS OR POSSIBLE SEVERE DEGRADATION DURING OOM HANDLING DUE TO COALESCE MEMORY CHECK
IT21197SQL1233N AFTER MIGRATING NON-UNICODE, MBCS DATABASE TO 11.1.1.1 OR LATER
IT21182INTERRUPTED QUERY/SORT OPERATION CAUSES STMM TO UNNECESSARILY INCREASE SORT CONFIGURATION (SHEAPTHRES_SHR)
IT21181SUBOPTIMAL PERFORMANCE MAY PERSIST ON AN STMM-TUNED SYSTEM DUE TO LARGE CONSUMER NOT GIVING UP MEMORY
IT21177DB2AUDIT IS NOT REPORTING SQL0551N WHEN A USER WITH INSUFFICIENTAUTHORIZATION ATTEMPTS TO CALL A PROCEDURE
IT21176THE "DB2PD -CFPOOL DETAIL" COMMAND ABNORMALLY TERMINATES
IT21171CRASH RECOVERY FAILED DUE TO MISSING OF ROR FILE
IT21170DB2CMD.EXE MAY NOT WORK PROPERLY WHEN THE COMMAND LINE IS EXTREMELY LONG
IT21166SLOW ORDER BY WITH COLLATING SEQUENCE CLDR181
IT21164SECURITY: ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21163SECURITY: ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21149DB2DART REPORT ON A COLUMN-ORGANIZED (BLU) TABLE TAKES LONG TIMETO COMPLETE
IT21144SQL0443N FROM SYSTOOLS.JSON2BSON IF SECOND BSON > FIRST
IT21143SECURITY: ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21142SQL0443N FROM SYSTOOLS.JSON2BSON IF SECOND BSON > FIRST
IT21140SECURITY: ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21127STANDBY DATABASE SHUTS DOWN DUE TO CHECKSUM ERROR CAUSED BY NETWORK ISSUES AND NEEDS TO BE RESTARTED MANUALLY
IT21100UPDATE OF UNIQUE COLUMNS MIGHT RESULT IN DUPLICATES IN A TABLE WITH A UNIQUE INDEX
IT21090DB2 -A LIST APPLICATIONS DOES NOT SHOW SQLCA INFORMATION.
IT21084SQL0901N-The SQL statement or command failed because of a database system error. Reason-Unsupported date format for function 331
IT21083POOR PERFORMANCE WHEN FORCE_REPLICATED_MQT_MERGE IS SET
IT21082POOR PERFORMANCE WHEN LARGE NUMBER OF EXPRESSIONS IN THE QUERY
IT21077UPDATE OF UNIQUE COLUMNS MIGHT RESULT IN DUPLICATES IN A TABLE WITH A UNIQUE INDEX
IT21060SQL QUERIES WITH IN OR NOT IN CLAUSE MAY PRODUCE INCORRECT RESULTS FOR A COLUMN-ORGANIZED TABLE
IT21053QUERY COMPILATION MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT21048AN ONLINE BACKUP MAY DELETE ARCHIVED LOG FILES THAT ARE REQUIREDBY THE OLDEST REQUIRED BACKUP IMAGE.
IT21039ROLLING UPDATE FAILED DUE TO THE INSTALLER IS NOT ABLE TO DETECTIF A TSA EFIX IS ALREADY INSTALLED OR NOT
IT21015AGAINST COLUMNAR TABLES, COMBINATION OF EXCLUSIVE TABLE LOCK ANDUNCOMMITTED INSERT AND SELECT COULD RETURN INCORRECT RESULTS
IT20976If DB2 happens to be backing up the tablespace at the same time it is being altered, this could cause DB2 panic.
IT20963An online backup may trigger auto prune to delete the first log required by the oldest backup image that needs retaining.
IT20949SQL0901N WHEN SAP MEMORY TABLE JOINS WITH UNION DISTINCT HAVING JOIN
IT20939AUTHENTICATION VERY SLOW WITH HIGH CPU USAGE ON CERTAIN ZSERIES HARDWARE
IT20935GLOBAL XA STARTS THROWS XAER_OUTSIDE ERRORCODE=-4228
IT20925EXTENT MOVEMENT WITH NATIVE ENCRYPTION COULD LEAD TO CORRUPTED PAGE ONLY IN-MEMORY
IT20924IN DPF OR PURESCALE, TRAP OR HANG POSSIBLE AFTER INTERRUPT OF INTERNAL SQL
IT20923EXTENT MOVEMENT WITH NATIVE ENCRYPTION COULD LEAD TO CORRUPTED PAGE ONLY IN-MEMORY
IT20914UPGRADING DB2 V10.1 TO V11.1 WITH TEXT SEARCH RESULTS IN INCORRECT FOLDER DIRECTORY STRUCTURE WHICH REQUIRES MANUAL CREATION
IT20913DB2 CRASH IN PD_GET_DIAG_HIST_V10FP3
IT20912UPGRADING DB2 V10.1 TO V11.1 WITH TEXT SEARCH RESULTS IN INCORRECT CATALOG UPDATE
IT20903DB2 MAY ABEND WHILE RESTORING A DATABASE
IT20899DB2 MAY ABEND WHILE RESTORING A DATABASE
IT20895THE IMPLICIT CONNECT RESET WHEN IN A DB2DBDFT ENVIRONMENT
IT20893DB2VAL FAILS TO VALIDATE SYSADMIN AUTHORITY IF SYSADM_GROUP IS LESS THAN 8 CHAR LONG
IT20887POOR PERFORMANCE IN A FEDERATED ENVIRONMENT WHEN LOCAL PREDICATEON COLUMNS WITH SMALL NUMBER OF DISTINCT VALUES, <=3.
IT20886INGEST MAY USE EXCESSIVE AMOUNT FOR OVERFLOW MEMORY
IT20884DB2 MAY RETURN AN UNEXPECTED ERROR OR ABEND WHILE CASTING TO A UDT
IT20883SQL901N MAY OCCUR WHEN EXECUTING A SQL STATEMENT CONTAINING TWO OR MORE NOT IN OR NOT EXISTS PREDICATES
IT20874BLOCK USAGE OF UNARY +/- OPERATOR WITH BOOLEAN VALUE TRUE AND FALSE
IT20873"DB2PD -REORG" DOESN'T SHOW ONLINE REORG INFORMATION ON PURESCALE
IT20872QUERIES CONTAINING OUTER JOIN OPERATIONS AND AN OLAP FUNCTION NESTED WITHIN ONE OF THE INPUT OPERANDS MAY PERFORM POORLY UNDER C
IT20871DB21034E OCCURS FOR "SELECT" SQL STATEMENTS STARTING WITH BLOCK COMMENTS THROUGH CLP
IT20870ZRC=0X80580003=-2141716477=SQLKD_INTERRUPT "MAPPING FOR SQLKF_INTRP" DIA8003C APPEARS IN DB2DIAG.LOG REPEATEDLY
IT20869DB2 CLIENT APPLICATION ON WINDOWS MAY CRASH IN WINDOWS' FUNCTIONCALLED FROM DB2SYS!SQLZDB2SYSDLL.
IT20868COMPILED COMPOUND SQL OR A PL/SQL ANONYMOUS BLOCK CAN DELETE ALLROWS OF A ON COMMIT DELETE ROWS TEMPORARY TABLE
IT20857DROP/TRUNCATE PARTITION TABLE IS VERY SLOW ON PURESCALE
IT20851TRUNCATING CAST TO (VAR)CHAR AGAINST A COLUMNAR ORGANIZED TABLECOULD RETURN DANGLING BYTE INSTEAD OF A BLANK CHARACTER.
IT20837DB2 MAY RETURN AN UNEXPECTED ERROR OR ABEND WHILE CASTING TO A UDT
IT20831PLANS CONTAINING MULTI-KEY CHAR SORTS WITH GREATER THAN 500 ROWSON IDENTITY_16 DATABASES MAY RETURN INCORRECT RESULTS
IT20827ALTER TABLESPACE REDUCE OPERATIONS MIGHT LEAD TO ASYNCHRONOUS HIGH WATERMARKS IN HADR SYSTEMS
IT20826UTL_FILE.FOPEN MIGHT CAUSE MEMORY LEAK IN THE KRCBH (DBMS SET).
IT20818DB2NODES.CFG GETS CORRUPTED DURING A HA SHARD DISK FAILOVER.
IT20807OPTIMIZER MIGHT CHOOSE NON-OPTIMAL ACCESS PLAN FOR A COMPLEX QUERY INVOLVING COLUMN AND ROW ORGANIZED TABLES
IT20804POSSIBLE TRAP IN RELEASECONFLICT() BECAUSE PAUDITSETTINGS->AUDITSETTINGSLATCH IS ALREADY UNLOCKED
IT20801CLP NOT PROPAGATING SQLCA
IT20800CLP NOT PROPAGATING SQLCA
IT20799CLP NOT PROPAGATING SQLCA
IT20790INCORRECT RESULT POSSIBLE WHEN CASE AND ANOTHER PREDICATE HAVE THE SAME COMPARISON OPERATION
IT20788DYNAMIC SQL VARIATIONS WITH CGTTS ARE NOT REMOVED AUTOMATICALLY FROM THE PACKAGE CACHE WHEN APPLICATION TERMINATES
IT20786INCORRECT RESULT POSSIBLE WHEN CASE AND ANOTHER PREDICATE HAVE THE SAME COMPARISON OPERATION
IT20779DATA PROTECTION FOR SAP ON DB2: MAX_VERSIONS PURGES ONLY 1.COPY WHEN REDOLOG_COPIES ARE ON SEPARATE SERVERS
IT20757DB2 JDBC DRIVER MAY HANG AND FAIL WITH SQLCODE=-901 WHEN USING GET DIAGNOSTICS SQL STATEMENT.
IT20743IBM SPECTRUM PROTECT SNAPSHOT CLONE OPERATION FAILS WITH DBT2103N IF PATH DOES NOT CONTAIN THE DB NAME IN UPPER CASE.
IT20720TRUNCATING CAST TO (VAR)CHAR AGAINST A COLUMNAR ORGANIZED TABLECOULD RETURN DANGLING BYTE INSTEAD OF A BLANK CHARACTER.
IT20712SYSIBMADM.LOG_UTILIZATION IS RETURNING SQL0801N on standby
IT20698UPGRADING FROM 10.1 FP 4 OR FP 5 USING DB2UPDV10 MIGHT FAIL
IT20692POOR PERFORMANCE WHEN OJ AND JOIN ON IT HAS SAME TABLE
IT20683CLP NOT PROPAGATING SQLCA
IT20666CHECKSUM ERROR CAN BE DETECTED IN SQLSPCS FILE IF AUTOMATIC STORAGE PATHS ARE UNDER THE DATABASE PATH
IT20661WRONG RESULTS MIGHT OCCUR WHEN SCALAR SUB-QUERY IS ON THE LEFT HAND SIDE OF A NOT IN PREDICATE
IT20659WE CAN SAY THERE IS CLEARLY A REGRESSION INTRODUCED WITH THE EXTENSION OF THE EXISTS-TO-ANTIJOIN IN 10.1
IT20656MISSING WARNING WHEN REBIND WITH APREUSE
IT20645MBCS DOT CHARACTER IN JAPANESE GOT IQQS0032E ERROR IN CONTAINS FUNCTION
IT20644SPECIFIC MQT DEFINITION MAY LEAD TO DB2 ABEND WITH SIG11
IT20643DB2FMP CRASH OR TRAP WHEN RUNNING MONITORING QUERIES
IT20642POOR PERFORMANCE WHEN OJ AND JOIN ON IT HAS SAME TABLE
IT20637DB2 JDBC DRIVER MAY HANG AND FAIL WITH SQLCODE=-901 WHEN USING GET DIAGNOSTICS SQL STATEMENT.
IT20631A DB2 DPF ENVIRONMENT MAY EXPERIENCE A HANG DUE TO A DEADLATCH BETWEEN MASTERAPPLATCH AND TRANENTRYLATCH
IT20630A DB2 DPF ENVIRONMENT MAY EXPERIENCE A HANG DUE TO A DEADLATCH BETWEEN MASTERAPPLATCH AND TRANENTRYLATCH
IT20621SQL5190I HIT WHEN UPDATING DIAGPATH OR ALT_DIAGPATH TO NON-GPFS FILESYSTEM
IT20604In v10.1 Fixpack 6, the HADR Standby db diagpath can be flooded by "sqlpshrEdu, probe:3100" messages
IT20597WRONG RESULTS MIGHT OCCUR WHEN SCALAR SUB-QUERY IS ON THE LEFT HAND SIDE OF A NOT IN PREDICATE
IT20585SQL0901N WITH UNEXPECTED AVGBUILDTUPLESIZE=0 IN JOIN QUERY
IT20574QUERY MIGHT TRAP IN DATA PARTITION ELIMINATION OF A ZIGZAG JOIN
IT20572HADR STANDBY WAS SHUTDOWN WHEN IT TRIES TO CONVERT ALL THE BLOCKS OF THE BLOCK LIST TO ONDISK BLOCK
IT20571SECURITY: DB2 CLP WILL TRAP IF IT IS PASSED A ROUTINE NAME GREATER THEN THE ALLOWED MAXIMUM LENGTH (CVE-2017-1297).
IT20570SECURITY: DB2 CLP WILL TRAP IF IT IS PASSED A ROUTINE NAME GREATER THEN THE ALLOWED MAXIMUM LENGTH (CVE-2017-1297).
IT20569SECURITY: TSAMP PRIVILEGE ESCALATION VULNERABILITY AFFECTS DB2 (CVE-2017-1134).
IT20568SECURITY: BUFFER OVERFLOW THAT COULD ALLOW A LOCAL USER TO OVERWRITE DB2 FILES OR CAUSE A DENIAL OF SERVICE (CVE-2017-1105).
IT20567SECURITY: BUFFER OVERFLOW THAT COULD ALLOW A LOCAL USER TO OVERWRITE DB2 FILES OR CAUSE A DENIAL OF SERVICE (CVE-2017-1105).
IT20566SECURITY: DB2 IS AFFECTED BY VULNERABILITIES IN COMPRESSION ROUTINES.
IT20565SECURITY: DB2 IS AFFECTED BY VULNERABILITIES IN COMPRESSION ROUTINES.
IT20564SECURITY: DB2 IS AFFECTED BY VULNERABILITIES IN COMPRESSION ROUTINES.
IT20563SECURITY: BUFFER OVERFLOW THAT COULD ALLOW A LOCAL USER TO OVERWRITE DB2 FILES OR CAUSE A DENIAL OF SERVICE (CVE-2017-1105).
IT20562SECURITY: DB2 CLP WILL TRAP IF IT IS PASSED A ROUTINE NAME GREATER THEN THE ALLOWED MAXIMUM LENGTH (CVE-2017-1297).
IT20561SECURITY: DB2 LUW ON AIX AND LINUX AFFECTED BY A VULNERABILITY IN GPFS (CVE-2016-6115).
IT20559SQL0901N WITH UNEXPECTED AVGBUILDTUPLESIZE=0 IN JOIN QUERY
IT20555REPLICATION CENTER TOOL IS MISSING ON DATA SERVER CLIENT V11.1
IT20547A REPEATED POSITIONED UPDATE ON A ROW CAN LEAD TO AN ABEND/CRASHon sqlristm
IT20531RESPONSE FILE INSTALLATION FAILS TO SET SYSCTRL_GROUP OR OTHER AUTHORITY GROUPS ON WINDOWS PLATFORM
IT20528FSALERT FILE INCORRECTLY NAMED WHEN SETTING AN ALERT WHICH RESULTS IN THE ERROR MESSAGE: "ERROR SCANNING ALERT DIRECTORY"
IT20522SQL1038N ON CALL REORGCHK_IX_STATS('T','ALL')" WITH STMT_CONC=LITERALS
IT20518IN DPF, WHEN UNIQUE TQ IS PRESENT IN THE PLAN AND SPECIAL INTERNAL PERF OPT IS HAPPENING, POSSIBLE DUPLICATE VALUES RETURNED
IT20517IN DPF, WHEN UNIQUE TQ IS PRESENT IN THE PLAN AND SPECIAL INTERNAL PERF OPT IS HAPPENING, POSSIBLE DUPLICATE VALUES RETURNED
IT20510DB2 MAY CRASH WHEN PROCESSING EXTENSIVE LIST OF TABLESPACES IN HISTORY FILE
IT20502DB21018E RETURNED TO A CLP COMMAND RUN VIA NOHUP IF THE PARENT SHELL HAS EXITED.
IT20501INTERMITTENT LOAD ABNORMAL END IN THE BUILD PHASE: UNEXPECTED MSG. , 28, 0, DETECTED IN FILE:SQLUVLD.C, LINE:5506
IT20499SQL8001N AN ATTEMPT TO CONNECT TO THE DATABASE FAILED DUE A PRODUCT LICENSE PROBLEM ON V10.5 FP7
IT20498SECURITY: DB2 CLP WILL TRAP IF IT IS PASSED A ROUTINE NAME GREATER THEN THE ALLOWED MAXIMUM LENGTH (CVE-2017-1297).
IT20477SELECT QUERIES RUN ON HADR STANDBY WITH "UR CLAUSE" FAIL WITH ERROR -1773
IT20475INCORRECT RESULTS ARE POSSIBLE WHEN CONCURRENT QUERIES ACCESS COLUMNAR ORGANIZED TABLES AND USE CS ISOLATION
IT20470THE DB2 LUW COMMAND BIND USES BY DEFAULT DEALLOCATE FOR THE RELEASE OPTION
IT20463INCORRECT RESULTS ARE POSSIBLE WHEN CONCURRENT QUERIES ACCESS COLUMNAR ORGANIZED TABLES AND USE CS ISOLATION
IT20462SECURITY: TSAMP PRIVILEGE ESCALATION VULNERABILITY AFFECTS DB2 (CVE-2017-1134).
IT20461SECURITY: BUFFER OVERFLOW THAT COULD ALLOW A LOCAL USER TO OVERWRITE DB2 FILES OR CAUSE A DENIAL OF SERVICE (CVE-2017-1105).
IT20460SECURITY: TSAMP PRIVILEGE ESCALATION VULNERABILITY AFFECTS DB2 (CVE-2017-1134).
IT20456INTERRUPTED QUERY/SORT OPERATION CAUSES STMM TO UNNECESSARILY INCREASE SORT CONFIGURATION (SHEAPTHRES_SHR)
IT20440IN DPF, WHEN UNIQUE TQ IS PRESENT IN THE PLAN AND SPECIAL INTERNAL PERF OPT IS HAPPENING, POSSIBLE DUPLICATE VALUES RETURNED
IT20438INCORRECT RESULT OR SQL0811N ARE POSSIBLE WHEN SQL CONTAINS SCALAR NOT EXISTS SUBQUERY
IT20436INCORRECT RESULT OR SQL0811N ARE POSSIBLE WHEN SQL CONTAINS SCALAR NOT EXISTS SUBQUERY
IT20432DPF QUERY MAY HANG DUE WAITS ON SUBSECTIONS FOR ONE NODE
IT20421SQL0901N MAY OCCUR WHEN THE SAME TABLE OR VIEW IS USED AS INPUT TO TWO OR MORE GROUP BY OPERATIONS WITHIN THE QUERY.
IT20419ADD TOLERATION LOGIC IN CASE A STANDBY RECEIVES A BAD LOG PAGE DUE TO NETWORK ISSUE
IT20413DBT5555N THE DB2CKUPGRADE UTILITY FAILED BECAUSE THE DATABASE HAS ONE OR MORE INVALID OBJECTS.
IT20404IN DPF, DB2 TRAPS IN sqeDBMgr::LocalDeactivate IF A NODE FAILS AND THAT NODE IS THE CATALOG NODE FOR SOME DATABASE
IT20403IN DPF, DB2 TRAPS IN sqeDBMgr::LocalDeactivate IF A NODE FAILS AND THAT NODE IS THE CATALOG NODE FOR SOME DATABASE
IT20402IN DPF, DB2 TRAPS IN sqeDBMgr::LocalDeactivate IF A NODE FAILS AND THAT NODE IS THE CATALOG NODE FOR SOME DATABASE
IT20401SQLCODE -902 FROM SQLRICLS_COMPLEX ON QUERY WITH COLUMN-ORGANIZED TABLES AND ROW-ORGANIZED DETACHED CSE TEMPS IN DPF
IT20400SUBOPTIMAL PERFORMANCE MAY PERSIST ON AN STMM-TUNED SYSTEM DUE TO LARGE CONSUMER NOT GIVING UP MEMORY
IT20393MOVE REQUEST NOT SENT TO TSA DURING A HADR TAKEOVER TO AN UP-LEVEL VERSION OF DB2
IT20386DB2: INSTALLATION MIGHT RETURN DBI20105E WARNING AND NOT INSTALLTSAMP COMPONENT
IT20385No room for retrieved log number xxx in retrieveArray during Rollfoward or Crash recovery
IT20383CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES DURING HASH TABLE JOIN
IT20368SQLB_BADHDR ERROR DURING SQLB_VERIFY_PAGE CAUSING FODC DUMPS ANDDB MARKED BAD.
IT20367SQLB_BADHDR ERROR DURING SQLB_VERIFY_PAGE CAUSING FODC DUMPS ANDDB MARKED BAD.
IT20366ENABLING REOPT ALWAYS VIA OPTIMIZATION GUIDELINE MAY LEAD TO INCORRECT RESULTS AS PARAMETER VALUES MAY BE RE-USED INCORRECTLY
IT20355DBT5555N THE DB2CKUPGRADE UTILITY FAILED BECAUSE THE DATABASE HAS ONE OR MORE INVALID OBJECTS.
IT20351DB2 CHECK UPGRADE TOOL RETURNING WARNING ABOUT DISCONTINUED FUNCTION SYSFUN.ASCII1.
IT20345CONNECTIONS FAIL IN CRYPTDIGESTINIT WITH ECF_CRYPT_UNEXPECTED_ERROR
IT20342IMPORT AND EXPORT FAIL WITH SQL1031N WHEN CONNECTING TO DB BY DB2DSDRIVER.CFG.
IT20340SEVERAL ERRORS ARE LOGGED IN DB2DIAG.LOG WHENEVER DB2 LUW RECEIVES A CONNECTION FROM DRDA APPL IN EBCDIC ON AS/400 OR Z/OS
IT20335DB2LOOK -MOD MAY HANG FOREVER TILL IT IS KILLED MANUALLY
IT20334DB2LOOK -MOD MAY HANG FOREVER TILL IT IS KILLED MANUALLY
IT20333DB2LOOK -MOD MAY HANG FOREVER TILL IT IS KILLED MANUALLY
IT20332SQLB_BADHDR ERROR DURING SQLB_VERIFY_PAGE CAUSING FODC DUMPS ANDDB MARKED BAD.
IT20331DB2LOOK -MOD MAY HANG FOREVER TILL IT IS KILLED MANUALLY
IT20328CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES WHEN HASH TABLE NEEDS TO BE SPILLED FOR A GROUPBY
IT20324DB2: SILENT INSTALLATION MIGHT FAIL WITH SEGV IN ENCODEPASSWORD->STRCPY IF CRYPT() RETURNS AN ERROR (E.G. WITH FIPS_ENABLED)
IT20321SLOW INSERT PERFORMANCE WHEN USING A CLUSTERED INDEX.
IT20316SPATIAL EXTENDERS DATA TYPES NOT CLEARED AFTER DB2SE DISABLE_DB <DATABASE> AND CANNOT BE DROPPED
IT20304SEVERAL ERRORS ARE LOGGED IN DB2DIAG.LOG WHENEVER DB2 LUW RECEIVES A CONNECTION FROM DRDA APPL IN EBCDIC ON AS/400 OR Z/OS
IT20303CONNECTION HANG ON V10.5FP8 ONLY ON SOLARIS WITH SPARC64-X
IT20302SLOW INSERT PERFORMANCE WHEN USING A CLUSTERED INDEX.
IT20294CONNECTION ATTRIBUTE SQL_ATTR_CLIENT_APPLCOMPAT IS NOT CORRECTLYSET
IT20291SELECT QUERIES RUN ON HADR STANDBY WITH "UR CLAUSE" FAIL WITH ERROR -1773
IT20290CLP MAY HANG IF IT GETS SIGNAL WHILE IT TERMINATES
IT20287DB2 MAY SHOW INCREASED LATCHING WHEN PLANS WITH HASHJOIN PRODUCENO ROWS ON BUILD SIDE
IT20284SELECT STATEMENT FAILED WITH SQL1822N ON FEDERATED DATABASE
IT20281TEXT SEARCH EXTENDER SLOW FUZZY SEARCH QUERY PERFORMANCE DUE TO ALGORITHMIC LIMITATION WITHIN LUCENE 3
IT20280HADR TAKEOVER WITH READS ON STANDBY TRAPS DURING FREE TCB
IT20262APPLICATIONS FAIL WITH ERROR SQL30020N "0X124C"("0100") WHEN CONNECTING THROUGH A GATEWAY
IT20257DB2 MAY SHOW INCREASED LATCHING WHEN PLANS WITH HASHJOIN PRODUCENO ROWS ON BUILD SIDE
IT20251CREATE TABLE ... CCSID UNICODE ORGANIZE BY COLUMN FAILS WITH SQL1666N
IT20242SQL20288N "INDEX WITH XPTH TYPE". REASON CODE = "3" USING DB2LOOK -M OUPUT
IT20230DB2 SERVER TERMINATES ABNORMALLY EXECUTING DDL STATEMENT
IT20221DB2ICRT INCORRECTLY UPDATES SVCENAME with PORTNUMBER IN DBM CFG
IT20217DB2LOOK NOT GENERATING ALTER TABLE... ALTER COLUMN ... RESTART WITH # STATEMENT
IT20216DB2LOOK NOT GENERATING ALTER TABLE... ALTER COLUMN ... RESTART WITH # STATEMENT
IT20209DB2LOOK NOT GENERATING ALTER TABLE... ALTER COLUMN ... RESTART WITH # STATEMENT
IT20203SAP: ERROR SQL0607N FOR FUNCTION SYSFUN.ASCII1 FROM "DB2UPDV111 -R ..."
IT20201MANY DIFFERENT SIZED LOGS IN LOG DIRECTORY
IT20198THE IMPLICIT CONNECT RESET WHEN IN A DB2DBDFT ENVIRONMENT
IT20197THE IMPLICIT CONNECT RESET WHEN IN A DB2DBDFT ENVIRONMENT
IT20193DB2PD CONTINUES CHECKING USER AUTHORITIES INSTEAD STOPPING AFTERCONFIRMING USER HAS THE REQUIRED AUTHORITY.
IT20192ADDRESS SPACE CONFLICT MAY OCCUR IN DB2GCF IF ASLR IS ENABLED
IT20182WHEN CF SELF-TUNING MEMORY IS SET TO ON, YOU MAY OBSERVE PERFORMANCE ISSUES DUE TO ERRORS ON UPDATING GBP SIZE.
IT20174DB2 MAY ABEND WHEN A PLAN CONTAINING AGGREGATION IS INTERRUPTED AND SUBSEQUENTLY REEXECUTED
IT20173DB2 MAY ABEND WHEN A PLAN CONTAINING AGGREGATION IS INTERRUPTED AND SUBSEQUENTLY REEXECUTED
IT20169ABEND POSSIBLE IN QUERY COMPILER DUE TO STALE POINTER ACCESS WHEN USING TRUSTED CONNECTIONS
IT20165BACKUP AND RESTORE MIGHT TRAP
IT20156INVALID LENGTH/PRECISION FOR BOOLEAN IN DASHDB
IT20155CREATE MASK FAILING WITH BOOLEAN LITERAL VALUE
IT20141INCORRECT RESULT ON AN DISTINCT QUERY IN FEDERATION
IT20128ATTEMPTING TO REVALIDATE A COMPLEX MASK CALLING ADMIN_REVALIDATE_DB_OBJECTS MIGHT FAIL
IT20126DB2 SIG #11 CRASH IN SQLNO_HINT_VALIDATE WHEN REBINDING USING THE APREUSE (ACCESS PLAN REUSE) OPTION
IT20105CONTINUOUS PRIVATE MEMORY GROWTH ON DB2/AIX SYSTEMS WITH VERY LOW ACTIVITY
IT20104UNEXPECTED OOM ERRORS AFTER A LARGE DYNAMIC DATABASE CONFIGURATION INCREASE
IT20090DATE_TRUNC SCALAR FUNCTION RETURNS UNWANTED FRACTIONAL SECONDS WITH SCALE 4 WHEN SECOND INPUT ARGUMENT IS DATE TYPE.
IT20089ERROR MESSAGE "NON-FATAL ASSERTION FAILED!!!" FILLING UP DB2DIAG.LOG
IT20085JAVA.LANG.NULLPOINTEREXCEPTION WHEN CHECKING "CREATE DAS USER LATER" IN DB2SETUP
IT20078LOAD TERMINATE ON CORRUPT SMS TABLE (MISSING .INX FILE) WILL MARK DATABASE BAD
IT20057SQL20288N "INDEX WITH XPTH TYPE". REASON CODE = "3" USING DB2LOOK -M OUPUT
IT20053DB2 MIGHT PRODUCE SUBOPTIMAL PLAN FOR DEEPLY NESTED NOT EXISTENTIAL SUBQUERIES
IT20046GLOBAL BENEFIT IS INVALID
IT20042DB2VAL DOESN'T VERIFY THE PERMISSION FOR INSTANCE OWNER HOME DIRECTORY, MAY RESULT IN SQL1646N ERRORS
IT20018POSSIBLE TRAP IN SQLRIECC() IN DPF DURING EXCSQLSET REQUEST PROCESSING WHEN INTERRUPTED
IT20009"CLP SELECT STATEMENT DISPLAY FIX FOR CHAR AND VARCHAR CODEUNITS32 STRING UNITS"
IT20007DB2_DATABASE_CF_MEMORY and DB2_SD_ALLOW_SLOW_NETWORK in ENV_GET_REG_VARIABLE return different values from IBM Knowledge Center
IT20001WITH MULTIPLE DB2READLOG API CALLERS RETRIEVING THE SAME LOG FILE, DB2READLOG API CALLERS MAY TIME OUT OR FAIL WITH SQL2038N
IT20000INTERRUPT/CANCEL MAY NOT WORK FOR SSL CONNECTION TO DB2 PURESCALE SERVER
IT19998ENABLE CDE DATA-SKIPPING FOR QUERIES LIKE " WHERE PARTS_NO LIKE 'ABC%' "
IT19994SCA SEARCH AND INSERT LOGIC CAN LEAD TO A PERFORMANCE BOTTLENECKFOR AN XA WORKLOAD
IT19982DB2IUPGRADE COMMAND FAILS IF PATH TO INSTANCE HOME DIRECTORY CONTAINS "-D"
IT19980DB2 MAY FAIL EXECUTING QUERY DURING SEMIJOIN PROCESSING ON CDE
IT19976SQL QUERIES WITH IN OR NOT IN CLAUSE MAY PRODUCE INCORRECT RESULTS FOR A COLUMN-ORGANIZED TABLE
IT19962SLOW PERFORMANCE WHEN MONITORING SQL ROUTINES
IT19947HIGH NUMBER OF CATCACHE LOCKS IMPACTING PERFORMANCE OF QUERIES
IT19946HIGH NUMBER OF CATCACHE LOCKS IMPACTING PERFORMANCE OF QUERIES
IT19945HIGH NUMBER OF CATCACHE LOCKS IMPACTING PERFORMANCE OF QUERIES
IT19939HIGH NUMBER OF CATCACHE LOCKS IMPACTING PERFORMANCE OF QUERIES
IT19933DB2NODES.CFG GETS CORRUPTED DURING A HA SHARD DISK FAILOVER.
IT19926THE DB2CHECKSD OPERATION MAY HANG WHEN RESTORING A 11.1.0.0 ESE BACKUP IMAGE TO 11.1.1.1 PURESCALE ENVIRONMENT
IT19925ENCRLIB AND ENCROPTS VALUES MAY BE DISPLAYED INCORRECTLY, OR NOTDISPLAYED AT ALL, WHEN USING A V11.1 CLIENT TO DOWNLEVEL SERVER
IT19909ERROR MESSAGE "NON-FATAL ASSERTION FAILED!!!" FILLING UP DB2DIAG.LOG
IT19905BACKGROUND DAEMONS MIGHT NOT START JUST AFTER TAKEOVER HADR DUE TO TIMING HOLE.
IT19890SIGSEGV WHEN USING PARALLEL OPTION OF DB2MOVE
IT19881DB2 MAY DEPICT PERFORMANCE DESCRIPTION WHEN IS NOT NULL AND IN/LIKE PREDICATE ARE USED
IT19879IMPLICIT CONNECT RESET WHEN IN A DB2DBDFT ENVIRONMENT
IT19868DB2 MIGHT PRODUCE SUBOPTIMAL PLAN FOR DEEPLY NESTED NOT EXISTENTIAL SUBQUERIES
IT19853SIGNAL 11 TRAP AT SQLRA_GET_VAR
IT19843TRUNCATE TABLE WITH -M OPTION SHOWS 4294967295 ROWS DELETED
IT19842NSE CHACKNSEINDEX UTILITY MAY RETURN CTE5257E REASON CODE "2"
IT19826ENV_GET_REG_VARIABLES RETURNS INCORRECT DEFAULT VALUES FOR DB2_ALLOW_WLB_WITH_SEQUENCES.
IT19808COMPILED COMPOUND SQL OR A PL/SQL ANONYMOUS BLOCK CAN DELETE ALLROWS OF A ON COMMIT DELETE ROWS TEMPORARY TABLE
IT19807COMPILED COMPOUND SQL OR A PL/SQL ANONYMOUS BLOCK CAN DELETE ALLROWS OF A ON COMMIT DELETE ROWS TEMPORARY TABLE
IT19805COMPILED COMPOUND SQL OR A PL/SQL ANONYMOUS BLOCK CAN DELETE ALLROWS OF A ON COMMIT DELETE ROWS TEMPORARY TABLE
IT19801INSTANCE CRASHED WITH SIGSEGV IN LIBPTHREAD.SO.0
IT19798ABEND POSSIBLE IN QUERY COMPILER DUE TO STALE POINTER ACCESS WHEN USING TRUSTED CONNECTIONS
IT19796COMPILED COMPOUND SQL OR A PL/SQL ANONYMOUS BLOCK CAN DELETE ALLROWS OF A ON COMMIT DELETE ROWS TEMPORARY TABLE
IT19793A CREATE TABLE SQL0286N ERROR IN BLU REPORTS "BLU FAILED AT THISLINE, DETECTED IN FILE:SQLRL_TABLE.C" IN DB2DIAG.LOG
IT19781IN A DPF DATABASE INSTANCE, IN RARE TIMING CONDITION A SEG-FAULT/TRAP CAN OCCUR IN FUNCTION SQLPSETTID()
IT19780IN RARE TIMING CONDITION, THE DATABASE CAN HANG DUE TO DEADLATCHBETWEEN HADR PROCESSES.
IT19768DB2 MIGHT HANG DURING A MANUAL 'UPDATE DATABASE CFG' TO DECREASETHE DATABASE MEMORY CONFIG SETTING
IT19753ISSUE IS WITH DATA ENCRYPT WITH NULL LOB VALUE THERE IS EXCEPTION IN JCC TRACE WITH EMPTY DATA.
IT19742DB2 SERVER TERMINATES ABNORMALLY COMPILING SQL QUERY
IT19733LONG RUNNING ADMIN_MOVE_TABLE SWAP PHASE DUE TO STATISTICS COLLECTION
IT19732STATISTICS MAY INDICATE EMPTY TABLE AFTER ADMIN_MOVE_TABLE COMPLETED
IT19722EXECUTION OF INSTALLFIXPACK MAY FAIL BECAUSE THE COMMAND IS NOT ABLE TO DETECT IF DB2 LIBRARIES ARE STILL LOADED IN MEMORY.
IT19720DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING NOT EXISTS SUBQUERY WITH NESTED SUBQUERIES
IT19712REVOKING PRIVILEGES MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT19711REVOKING PRIVILEGES MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT19710REVOKING PRIVILEGES MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT19707AUTOMAINT_GET_POLICY returns incorrect output
IT19690THE SQL USING INDEX WITH REVERSE SCAN WITH INTRA_PARALLEL MAY RUN SLOWER.
IT19689Table function ENV_GET_REG_VARIABLES RETURNS INCORRECT DEFAULT VALUES FOR DB2_RESOLVE_CALL_CONFLICT.
IT19687DB2 upgrade may hit error SQL1762N even though there is sufficient disk space for upgrade
IT19676LOAD SHOULD FAIL WITH SQL6103C IF THE LOCK ESCALATION HAPPENS TO AVOID THE CONCURRENCY ISSUE
IT19671IF AN IBM DATA SERVER DRIVER PACKAGE ALREADY EXISTS ON WINDOWS SERVER, UPGRADING DB2 SERVER OR DS CLIENT TO HIGHER VERSION FAILS
IT19665ENV_GET_REG_VARIABLES RETURNS DEFAULT VALUE OF DB2_HADR_NO_IP_CHECK INCORRECTLY.
IT19663PROBLEM WITH THE GENERATED C/C++ CODE FROM THE DB2 PREP. IT CANNOT COMPILE WHEN IT CONTAINS THE ARRAY INSERT/UPDATE.
IT19659DB2 MIGHT ABEND WHEN EXECUTING QUERIES WITH MULTIPLE OUTER JOINSAND EQUALITY PREDICATES
IT19653PROBLEM WITH THE GENERATED C/C++ CODE FROM THE DB2 PREP. IT CANNOT COMPILE WHEN IT CONTAINS THE ARRAY INSERT/UPDATE.
IT19652SQLTEMPSPACE THRESHOLD DOES NOT WORK FOR WITH STATEMENT
IT19642DB2UPDV10 FAILS WITH ERROR GRANTING EXECUTE ON ADMIN_GET_VALID_BREAKPOINTS TO ROLE SYSDEBUGPRIVATE, -204
IT19637DB2 MAY CONVERT VIEW COLUMN TYPES INCORRECTLY OR RETURN SQL0418NUPON REVALIDATION OF A VIEW WITH UNTYPED EXPRESSIONS
IT19636DB2 MAY CONVERT VIEW COLUMN TYPES INCORRECTLY OR RETURN SQL0418NUPON REVALIDATION OF A VIEW WITH UNTYPED EXPRESSIONS
IT19633QUERY COMPILATION MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT19631QUERY EXECUTION CAUSES DB2 SERVER TO TERMINATE ABNORMALLY
IT19629EXECUTION OF INSTALLFIXPACK MAY FAIL BECAUSE THE COMMAND IS NOT ABLE TO DETECT IF DB2 LIBRARIES ARE STILL LOADED IN MEMORY.
IT19627LDAP PLUGIN NOW ALLOWS SIGNATURE ALGORITHMS TO BE SPECIFIED WHENUSING TLS 1.2
IT19614ENV_GET_REG_VARIABLES RETURNS INCORRECT DEFAULT VALUES FOR DB2GRAPHICUNICODESERVER.
IT19612ENV_GET_REG_VARIABLES RETURNS INCORRECT DEFAULT VALUES FOR DB2TCP_CLIENT_KEEPALIVE_TIMEOUT.
IT19610AUTOMAINT_GET_POLICY returns incorrect output
IT19608DB2 MAY CONVERT VIEW COLUMN TYPES INCORRECTLY OR RETURN SQL0418NUPON REVALIDATION OF A VIEW WITH UNTYPED EXPRESSIONS
IT19607WINDOWS SERVICES WITH PATH TO BINARY LONGER THAN 260 CAUSE MEMORY CORRUPTION DURING INSTALL
IT19603AUTO REORG FOR DATA PARTITIONS IGNORES USER SPECIFIED OPTIONS INREORG POLICY
IT19594CLI0112E FROM DB2BATCH JOB
IT19590DB2 MIGHT PRODUCE A SQL0901N, EXECUTING QUERIES WITH UNION ALL
IT19579SQL119N WHEN REFERENCING HOST VARIABLE WITH GROUP BY IN STATIC SQL
IT19572DB2IPRUNE and DB2_INSTALL FAIL WITH LIBIBMC++.SO.1: CANNOT OPEN SHARED OBJECT FILE
IT19570INCORRECT ERROR 406 FOR SELECT STATEMENT
IT19568WHEN A DATABASE IS ORACLE COMPATIBLE, A STATEMENT HEAP CAN GROW ENORMOUSLY WHEN A QUERY HAS A LOT OF REFERENCES TO DUAL TABLE.
IT19566WHEN INSTANCE STOPPED IN DB2STOP. IT IS INSTANCE STOPPED DID NORMAL, BUT THE ERROR LEVEL WAS OUTPUT BY DB2DIAG.LOG (SQL1064N).
IT19560'START HADR AS STANDBY' OPERATION MAY FAIL WITH SQL1776N RC=7 DURING REINTEGRATION IN PURESCALE
IT19555DB2 MIGHT PRODUCE SQL0901N ERROR MESSAGE WHEN EXECUTING LEFT JOIN QUERY ON TABLE WITH RCAC
IT19553DB2 OPERATIONS MAY HANG AND NOT RESPOND TO INTERRUPTS WHILE EXECUTING QUERIES AGAINST COLUMNAR TABLES
IT19549SECURITY MECHANISM NOT SUPPORTED EXCEPTION WHEN AUTHENTICATION=CLIENT AND PASSWORD AND USER ARE PROVIDED.
IT19545LOAD FROM CURSOR (LOCAL OR REMOTE DB) FROM SOURCE COLUMN CHAR(CODEUNITS32) MIGHT FAIL OR INSERT EXTRA TRAILING BYTES
IT19533SIGNIFICANT INCREASE IN SHARED APPLICATION HEAP AFTER UPGRADE TO10.5 FOR QUERIES REFERENCING RANGE PARTITIONED TABLES
IT19518NO ERROR MESSAGE IS RETURNED WHEN THE DATA EXCEEDS JSON ARRAY SIZE.
IT19506The optimizer might choose a non-optimal full table scan compared to a better performing index access on the inner of an NLJOIN
IT19505PERFORMANCE OF QUERIES WITH EXISTS PREDICATES DEGRADES AFTER UPGRADE TO FIX PACK 5
IT19504DB2 LOAD FAILING IN DPF ENVIRONMENT DUE TO SQL0969N THERE IS NO MESSAGE TEXT CORRESPONDING TO SQL ERROR "-2769"
IT19502NNSTAT JOB STUCK IN INFINITE CREATE INDEX LOOP
IT19501SQLP_NOTA FROM REMOTE NODE MAY CAUSE CLIENT TO TERMINATE THE APPLICATION.
IT19499ENV_GET_REG_VARIABLES RETURNS INCORRECT DEFAULT VALUES.
IT19483MEMORY ALLOCATED BY A MONITOR FUNCTION MIGHT NOT BE FREED UP ANDMIGHT LEAK AFTER DATABASE IS DEACTIVATED
IT19477FULL FIX FOR IT17851: AN SQL STMT IN A DPF ENV CONTAINING THE ROW_NUMBER() OVER() OPERATION MIGHT PRODUCE INCONSISTENT RESULTS
IT19474MEMORY GROWTH IN STATEMENT HEAP DURING COMPILE OF A QUERY WHICH MAY CAUSE A CRASH DUE TO OUT OF MEMORY CONDITION.
IT19471EXCESSIVE SHARED MEMORY ALLOCATION FOR FMP MEMORY LEADS TO UNEXPECTED MEMORY ALLOCATION FAILURES, LARGE COREDUMPS
IT19463DB2CLUSTER -VERIFY FAILED IN RDMA PING TEST
IT19462WINDOWS EVENT HANDLE LEAK WITH PARALLELIZED QUERY PLANS (INTRA_PARALLEL YES) - MAY CAUSE OSERR 1450
IT19457INSTANCE CRASH DUE TO STACK OVERFLOW DURING EXECUTION OF AN XQUERY WITH A LARGE NUMBER OF PREDICATES.
IT19445INSTANCE CRASH DUE TO STACK OVERFLOW DURING EXECUTION OF AN XQUERY WITH A LARGE NUMBER OF PREDICATES.
IT19442A DB2 FENCED ROUTINE MAY FAIL WITH ERROR SQL1646N DUE TO SHARED MEMORY PERMISSION PROBLEMS
IT19440SQL0901N WHEN COLUMN MASK ON NOT NULLABLE COLUMN RETURNS ALWAYS NOT NULL AND COLUMN IS IN NULL PRODUCING SIDE
IT19438SQL0901N WHEN COLUMN MASK ON NOT NULLABLE COLUMN RETURNS ALWAYS NOT NULL AND COLUMN IS IN NULL PRODUCING SIDE
IT19430ROLLFOWARD FAILS DUE TO PRIMARY OR MIRROR LOG PATH MARKED BAD AFTER RESTORE
IT19402PURESCALE MEMBER CAN CRASH IN PDDUMPVALISTELEMENT
IT19400SECURITY: TABLE PRIVILEGE CHECKING MAY RETURN OUTDATED RESULTS AFTER A TABLE IS RENAMED (CVE-2017-1150)
IT19399SECURITY: TABLE PRIVILEGE CHECKING MAY RETURN OUTDATED RESULTS AFTER A TABLE IS RENAMED (CVE-2017-1150)
IT19385ADMIN_MOVE_TABLE PROCEDURE FAILS WITH ERROR SQL0212N
IT19380THE DB2.EMP DIRECTORY IS NOT REMOVED AFTER V11.1 INSTALL FIXPACK1
IT19370DB2 MAY ABEND IN AN MPP ENVIRONMENT WHEN A QUERY INVOLVES XML COLUMNS AND THE KEYWORD DISTINCT
IT19365IN CASE OF SETTING UP DB2HAICU WITH MULTIPLE NIC CARDS, PROVIDE THE OPTION TO SKIP A CERTAIN NIC
IT19362ENV_GET_REG_VARIABLES RETURNS INCORRECT DEFAULT VALUES FOR DB2CHGPWD_EEE AND DB2LOGINRESTRICTIONS.
IT19348SQL5163N FROM APPLICATION.
IT19333DB2 MAY HANG DURING DLOPEN AND DLERROR OS CALLS
IT19324THE PRIMARY AND SECONDARY HADR NODES ARE NOT DISPLAYED CORRECTLYIN "DB2PD -HA" OUTPUT
IT19323ENV_GET_REG_VARIABLES RETURNS DEFAULT VALUE OF DB2_HADR_NO_IP_CHECK INCORRECTLY.
IT19317SQL5163N FROM APPLICATION.
IT19312REMARKS ON VIEW COLUMNS NOT RETAINED AFTER CHANGES TO BASE TABLE.
IT19306CRASH MAY OCCUR CREATING STORED PROCEDURE WITH XML QUERY WITH PASSING BY REF ON HOST VARIABLE
IT19303ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL2102N RC=22 WHEN USING COPY_USE_LOAD
IT19300CLI APPLICATION MAY GET CLI0002W DURING CALLING SQLGETCONNECTATTR ON DPF
IT19298DB2 MIGHT PRODUCE INCORRECT RESULTS WHEN RUNNING QUERIES WITH EQUALITY CHAR/VARCHAR PREDICATES.
IT19297DB2 MIGHT PRODUCE INCORRECT RESULTS WHEN RUNNING QUERIES WITH EQUALITY CHAR/VARCHAR PREDICATES.
IT19288INSTANCE MAY CRASH WHEN SQLGGTSS API IS RUN WITHOUT A CONNECTION
IT19285Snapshot backup might fail with error SQL2079N
IT19284INCONSISTENT STATE OF SYSIBMTS SCHEMA OBJECTS CANNOT BE CLEANED
IT19281DB2 CRASH DUE TO MEMORY ACCESS VIOLATION
IT19279SYSIBMADM.ENV_SYS_INFO RUNS SLOWER IN DB2 V10.5 BY 1 SECOND
IT19273LOAD UTILITY DOES NOT PROVIDE BENEFICIAL MESSAGES ON THE CONSTRAINT VIOLATION
IT19268IN PURESCALE ENVIRONMENT: DB2PD -REORGS DOESN'T SHOW REORG INFORMATION AFTER RUNNING ONLINE REORG SECOND TIME
IT19261REDUCE DIAGLEVEL FOR PROBE OUTPUT WHEN MON_GET_PKG_CACHE_STMT PROCESSING ON REMOTE NODE GETS SQLKD_INTERRUPT
IT19251CALLING A STORED PROCEDURE AGAINST NON-UDB SERVER RESULTS IN DB21102E
IT19248DB2 MAY CRASH DURING PROCESSING OF THE OPTIMIZER PROFILE
IT19243SQL0901N MAY BE RETURNED FOR QUERIES WITH UNION REFERENCING NODENUMBER/DBPARTITIONNUM FUNCTIONS
IT19233ON AIX WITH EXTSHM ENABLED DB2START RETURNS INVALID MEMORY ADDR ERROR INSTEAD OF WARNING
IT19230MON_GET_UNIT_OF_WORK INTERFACE - UOW_LOG_SPACE_USED REPORTING MIGHT BE INCORRECT
IT19223DB2 MAY ABEND IN AN MPP ENVIRONMENT WHEN A QUERY INVOLVES XML COLUMNS AND THE KEYWORD DISTINCT

© Icons by Mark James www.famfamfam.com

invispix 10x10

CURSOR Service Distribution - Navigationnavigator 400x400

Scope
Topics
Details
DB2 für Admins
x
DB2 Technische Infos
x
DB2 Dokumentation
x
DB2 Produktlinien
x
DB2 Newsletter
x
DB2 Bug-Recherche
x