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
IT22008DB2DART MIGHT TRAP WHEN FACED WITH CORRUPTIONS IN BLU TABLES
IT21985DOING LIKE ON A CODEUNITES32 FIXED LENGTH COLUMN  IN THE COLUMNAR ORGANIZED TABLE COULD RETURN AN INCORRECT RESULT
IT21971DOING LIKE ON A CODEUNITES32 FIXED LENGTH COLUMN  IN THE COLUMNAR ORGANIZED TABLE COULD RETURN AN INCORRECT RESULT
IT21965DB2UNINS CANNOT BE USED FROM INSTALLED COPY
IT21897WRONG RESULT IS POSSIBLE WHEN CODEUNITS 32 IS USED IN A ROW DATATYPE ASSIGNMENT AND CAST IS USED
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
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.
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
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
IT21460DB2_FMP_COMM_HEAPSZ VALUES GREATER THAN 1GB NOT HONORED
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
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
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
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
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
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
IT21149DB2DART REPORT ON A COLUMN-ORGANIZED (BLU) TABLE TAKES LONG TIMETO COMPLETE
IT21144SQL0443N FROM SYSTOOLS.JSON2BSON IF SECOND BSON > FIRST
IT21142SQL0443N FROM SYSTOOLS.JSON2BSON IF SECOND BSON > FIRST
IT21127STANDBY DATABASE SHUTS DOWN DUE TO CHECKSUM ERROR CAUSED BY NETWORK ISSUES AND NEEDS TO BE RESTARTED MANUALLY
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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"
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.
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
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
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.
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.
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
IT19268IN PURESCALE ENVIRONMENT: DB2PD -REORGS DOESN'T SHOW REORG INFORMATION AFTER RUNNING ONLINE REORG SECOND TIME
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
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
IT19202DB2 MAY ISSUE SQL0119N WHEN REFERENCING A CORRELATED COLUMN INSIDE A SCALAR AGGREGATE FUNCTION
IT19197DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING XQUERY WITH MULTIPLE OR SUBTERMS
IT19196DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING XQUERY WITH MULTIPLE OR SUBTERMS
IT19195DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING XQUERY WITH MULTIPLE OR SUBTERMS
IT19187DB2 WILL TRAP IF THE SUBTRANSACTION WORKS ON A TABLESPACE WITH ID > 4096
IT19186DB2MQ.MQRECEIVEALL TRAPS RESULTING IN AN SQL0430N ERROR.
IT19172COMMENTS ON COLUMNS FROM VIEWS ARE DELETED AFTER REVALIDATION OFTHE VIEW
IT19166Crash in embeddedSQL application while closing the cursor.
IT19165FETCH-FIRST-CLAUSE RESULTS IN SQL0104N
IT19162SLOW PERFORMANCE IN DB2AUDIT EXTRACT DELASC DUE TO MANY SMALL WRITES TO THE OUTPUT FILE
IT19161SLOW PERFORMANCE IN DB2AUDIT EXTRACT DELASC DUE TO MANY SMALL WRITES TO THE OUTPUT FILE
IT19152CALLING DBMS_SQL ROUTINES CAN LEAK MEMORY BLOCKS.
IT19151CALLING DBMS_SQL ROUTINES CAN LEAK MEMORY BLOCKS.
IT19150CALLING DBMS_SQL ROUTINES CAN LEAK MEMORY BLOCKS.
IT19143DB2 CLIENT APPLICATION ON WINDOWS MAY CRASH IN WINDOWS' FUNCTIONCALLED FROM DB2SYS!SQLZDB2SYSDLL.
IT19139SET PRIMARY CF USING COMMAND "DB2CLUSTER -CM -SET -OPTION PPRIMARY -VALUE ***" NOT WORKING CORRECTLY
IT19138IN V11.1 YOU MAY EXPERIENCE PERFORMANCE DEGRADATION, TIMEOUTS, IF DATABASE NATIVE ENCRYPTION IS ENABLED.
IT19137DB2CKLOG FALSE NEGATIVE
IT19135BIND ACTION ADD GRANT PUBLIC FROM A DOWNLEVEL CLIENT FAILS WITH SQL0719N
IT19129SECURITY: DB2 IS AFFECTED BY VULNERABILITIES IN COMPRESSION ROUTINES.
IT19128DB2ACSUTIL MAY TRAP IF THE OPTION OLDER THAN <N> DAYS AGO IS NOTCOMPLETELY USED
IT19113EVMON_FORMAT_UE_TO_XML DOES NOT SORT PARTICIPANT PAST ACTIVITIESIN A USEFUL WAY
IT19108BIND ACTION ADD GRANT PUBLIC FROM A DOWNLEVEL CLIENT FAILS WITH SQL0719N
IT19095DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING XQUERY WITH MULTIPLE OR SUBTERMS
IT19092DB2 SERVER TERMINATES ABNORMALLY EXECUTING DDL STATEMENT
IT19091DB2 SERVER TERMINATES ABNORMALLY EXECUTING DDL STATEMENT
IT19083SECURITY: DB2 LUW ON AIX AND LINUX AFFECTED BY A VULNERABILITY IN GPFS (CVE-2016-6115).
IT19082DB2 CAN RETURN -901 FOR A NON-LUW CLIENT IF A PROCEDURE RETURNS RESULT SETS THAT CLIENT DOES NOT EXPECT
IT19078DPF: SQL0901N: SQLRA_FREE_SECTION: SECTION NOT CLOSED FROM REMOTE PARTITIONS IN THE AFTERMATH OF A NODE FAILUIRE
IT19054HIGH LOCK ACTIVITY ON SYSCODEPROPERTIES TABLE DURING SQL PROCEDURE INVOCATIONS
IT19046RUNSTATS WITH UNQUALIFIED INDEX NAME CAN CAUSE TRAP IN ENGINE INCERTAIN CONDITION
IT19039SIGSEGV IN CLI FUNCITON CLIEXECCMRIFLUSHARRAY ON SQLCANCEL WHEN USING MULTI-ROW INSERT (MRI) FEATURE
IT19030DB2 MAY DEPICT PERFORMANCE DESCRIPTION WHEN IS NOT NULL AND IN/LIKE PREDICATE ARE USED
IT19025INSTANCE CAN TRAP IN XMLRNPERMMNXRFORMATTER::ENDREGIONINSERT WHEN INSERTING/DELETING XML RECORDS
IT19023AFTER CRASH RECOVERY, AN DEFERRED ONLINE REORG CLEANUP MIGHT CAUSE AN X ROW LOCK MISSING FOR AN INDOUBT TRANSACTION.
IT19008CALLING DBMS_SQL ROUTINES CAN LEAK MEMORY BLOCKS.
IT19003EXESSIVE ENTRY IN DB2DIAG.LOG AFTER RUN DB2PD -HADR COMMAND
IT18995CF MAY ENCOUNTER A HANG AND GET RESTARTED WITH THE FOLLOWING MESSAGE LOGGED IN DB2DIAG.LOG - PS GET SERVER ROLE FAILED. STATUS:
IT18985QUERY COMPILATION FAILS WITH SQL0901N "UNEXPECTED ERROR AT EVALUATIONROUTINE.CPP"
IT18984UPDATE THE COLUMN OTHER THAN LOB TO THE SAME VALUE, A LOG RECORDIS WRITTEN
IT18975THE IBM SPECTRUM PROTECT ERP INSTALLER OFFERS THE MISLEADING CHOICE TO CONFIGURE BOTH LOGARCHMETHS FOR THE PRODUCT
IT18970AUTOMAINT_SET_POLICYFILE DOESN'T REPORT ERROR WHEN FILTERCLAUSE SPECIFIED IS TOO LONG
IT18969TRAP WHEN RUNNING SELECT WITH WHERE IN CLAUSE ON TABLE WITH A FEW THOUSANDS PARTITIONS AND EXPLAIN MODE SET
IT18944POSSIBLE HANG CAUSED BY A 'DB2TASKP' EDU WHEN BRINGING DOWN A DATABASE
IT18943POSSIBLE HANG CAUSED BY A 'DB2TASKP' EDU WHEN BRINGING DOWN A DATABASE
IT18942POSSIBLE HANG CAUSED BY A 'DB2TASKP' EDU WHEN BRINGING DOWN A DATABASE
IT18931UPDATING SOFTMAX ON STANDBY DOESN'T TAKE EFFECT
IT18927SET INTEGRITY IMMEDIATE CHECKED may cause server to TERMINATE ABNORMALLY
IT18926SET INTEGRITY IMMEDIATE CHECKED may cause server to TERMINATE ABNORMALLY
IT18925THE DB2LOOK GENERATES UNIQUE CONSTRAINT DDL FOLLOWED BY UNIQUE INDEX DDL, THE INVALID ORDER CAUSES SQL0605W.
IT18923SET INTEGRITY IMMEDIATE CHECKED may cause server to TERMINATE ABNORMALLY
IT18919READAHEAD PREFETCHING COULD FIX INDEX RESERVED PAGE AND CAUSED UNPREDICTABLE BEHAVIORS
IT18915SQL0902 MAY OCCUR DURING EXECUTION OF QUERY CONTAINING LARGE RESULTSET
IT18914WITH DB2 V11.1 M1FP1 ON ZLINUX WITH HARDWARE LEVEL EQUAL OR OLDER THAN ZEC12 DB2START WILL FAIL
IT18900RUNSTATS WITH UNQUALIFIED INDEX NAME CAN CAUSE TRAP IN ENGINE INCERTAIN CONDITION
IT18876ADMIN_MOVE_TABLE SWAP TAKES LOCKS IN SUBOPTIMAL ORDER
IT18873MEMORY LEAK IN CDE-SORT WHEN USING BLU-MPP ENVIRONMENT
IT18870POOR PERFORMANCE IN QUERY HAVING IN SUBQUERY AND JOINS
IT18865CONTINUOUS PRIVATE MEMORY GROWTH ON DB2/AIX SYSTEMS WITH VERY LOW ACTIVITY
IT18850IF NODE FAILURE RECOVERY OCCURS AFTER END OF TRANSACTION, THE NEXT OPERATION CAN RECEIVE SQL1229
IT18849DROP PACKAGE FAILS WITH SQL0553N WHEN "PL/SQL SUPPORT" IS ENABLED
IT18846SQL0551N RECEIVED FROM A CALL TO EXPLAIN_FROM_DATA STORED PROCEDURE
IT18839FATAL ERROR WHEN TAKING MULTIPLE SNAPSHOT BACKUPS WITH NO TRANSACTION(S) IN BETWEEN
IT18837UPDATE STATEMENT MAY TRAP WHEN USING A NOT-IN SUBQUERY
IT18836UPDATE STATEMENT MAY TRAP WHEN USING A NOT-IN SUBQUERY
IT18835LONG QUERY RUNTIME WITH INTRA-PARALLEL AND COMPRESSED INDEXES
IT18834UPDATE STATEMENT MAY TRAP WHEN USING A NOT-IN SUBQUERY
IT18831OUTPUT OF SELECT STATEMENT IS DUPLICATED TWICE IN SPOOL OUTPUT FILE WHEN TRIMSPOOL IS SET TO ON IN CLPPLUS
IT18830INSTANCE MAY TRAP IN GETENV FUNCTION WHEN RUNNING TEXT SEARCH QUERIES.
IT18823FATAL ERROR WHEN TAKING MULTIPLE SNAPSHOT BACKUPS WITH NO TRANSACTION(S) IN BETWEEN
IT18820WHEN RUNNING THE DYNAMIC SQL IN A PACKAGE, THE WRONG STATEMENT COULD BE PICKED UP, RESULTING IN WRONG RESULT.
IT18818WHEN RUNNING THE DYNAMIC SQL IN A PACKAGE, THE WRONG STATEMENT COULD BE PICKED UP, RESULTING IN WRONG RESULT.
IT18817WHEN RUNNING THE DYNAMIC SQL IN A PACKAGE, THE WRONG STATEMENT COULD BE PICKED UP, RESULTING IN WRONG RESULT.
IT18816COMPARING LARGE VARYING CHARACTER AND GRAPHIC STRINGS CAN CAUSE WRONG RESULTS IN UNICODE DATABASES
IT18815COMPARING LARGE VARYING CHARACTER AND GRAPHIC STRINGS CAN CAUSE WRONG RESULTS IN UNICODE DATABASES
IT18814COMPARING LARGE VARYING CHARACTER AND GRAPHIC STRINGS CAN CAUSE WRONG RESULTS IN UNICODE DATABASES
IT18811DB2CKUPGRADE FAILS TO IDENTIFY "TABLE DICTIONARY VERSION MISMATCH" INDUCED BY APAR IV53366
IT18809POSSIBLE HANG CAUSED BY A 'DB2TASKP' EDU WHEN BRINGING DOWN A DATABASE
IT18797PURESCALE: QUERY MIGHT RETURNS WRONG RESULT WHEN INPLACE (ONLINE) TABLE REORGANIZATION IS RUNNING
IT18786SQLGETINFOW RETURN INCORRECT VERSION NUMBER
IT18775TO DOCUMENT ALL THE JCC APARS THAT ARE SHIPPED WITH DB2V11.1 M1 FP1
IT18774SQLSYNTAXERROREXCEPTION WAS THROWN WHEN SQL WAS EXECUTED USING CACHED PREPARED STATEMENT
IT18771PURESCALE: QUERY MIGHT RETURNS WRONG RESULT WHEN INPLACE (ONLINE) TABLE REORGANIZATION IS RUNNING
IT18766DB2 ADO .NET RETURNS CLI0102E WHEN CALLING PREPARE
IT18762COMPARING LARGE VARYING CHARACTER AND GRAPHIC STRINGS CAN CAUSE WRONG RESULTS IN UNICODE DATABASES
IT18761TRUNC ON MINIMUM INTEGER VALUE MIGHT RETURN 0 WHEN (VALUE, -X) IS DONE
IT18760TRUNC ON MINIMUM INTEGER VALUE MIGHT RETURN 0 WHEN (VALUE, -X) IS DONE
IT18759TRUNC ON MINIMUM INTEGER VALUE MIGHT RETURN 0 WHEN (VALUE, -X) IS DONE
IT18749ADM15001E OCCURRED WHILE RUNNING PD_GET_DIAG_HIST.
IT18745DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERY WITH GROUPBY ANDOUTER JOIN
IT18744DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERY WITH GROUPBY ANDOUTER JOIN
IT18742TRUNC ON MINIMUM INTEGER VALUE MIGHT RETURN 0 WHEN (VALUE, -X) IS DONE
IT18736JCC USING ORACLE 7 JAVA FAILS TO CONNECT TO DB2 SERVER SET WITH TLSV1.2 SSL VERSION.
IT18732WHEN RUNNING THE DYNAMIC SQL IN A PACKAGE, THE WRONG STATEMENT COULD BE PICKED UP, RESULTING IN WRONG RESULT.
IT18721CLI KEYWORDS NOT IMPORTED DURING INSTALL BECAUSE DB2CLI.INI DOES NOT EXIST
IT18715CREATE WRAPPER AND CREATE NICKNAME FAILING WITH FODC TRAP ON SIG#4
IT18708IMPROVE PD DIAGNOSTICS FOR DB2HACFSVERIFYMAINTENANCEMODE() AND DB2HACFSSETCLUSTERCONFIGURATION() FUNCTIONS.
IT18705JCC RETURNS STALE DATA CALLING AN ARRAY STORED PROCEDURE AGAINSTDB2 Z/OS
IT18704OUTPUT OF SELECT STATEMENT IS DUPLICATED TWICE IN SPOOL OUTPUT FILE WHEN TRIMSPOOL IS SET TO ON IN CLPPLUS
IT18703THE FIX OF APAR IT09089 IS INCOMPLETE
IT18702DB2 CAN RETURN -901 FOR A NON-LUW CLIENT IF A PROCEDURE RETURNS RESULT SETS THAT CLIENT DOES NOT EXPECT
IT18671SQL0902 MAY OCCUR DURING EXECUTION OF QUERY CONTAINING LARGE RESULTSET
IT18668DB2 INSTALLATION WITH TSAMP HITS SEGMENTATIONS FAULT ON UBUNTU
IT18660DB2VAL RUN AS INSTANCE OWNER IN DPF ENVIRONMENT MIGHT INCORRECTLY REPORT FCM VALIDATION FAILURE
IT18659DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES.
IT18658DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES.
IT18655-901 SQLERRMC: PROBE 020 IN SQLKTOPN(), MSG=TQ ALREADY OPEN
IT18654-901 SQLERRMC: PROBE 020 IN SQLKTOPN(), MSG=TQ ALREADY OPEN
IT18653PD_GET_DIAG_HIST GOT PANIC OR -902 IN DPF
IT18651MEMORY LEAK IN DBHEAP IF DB2READLOG RECEIVES AN ERROR TO FIND LOG FILE.
IT18649CLP CALL STATEMENT IN DB2 V11.1 IS BEHAVING DIFFERENTLY FROM PREVIOUS VERSIONS AND IT RESULTS IN SQL0433N.
IT18639DB2 MIGHT PRODUCE A SUBOPTIMAL PLAN WHEN EXECUTING A QUERY WITH COMPLEX JOINS AND EXISTENTIAL SUBQUERY
IT18637[POST11M1FP1GASAP_CANDIDATE]-901 CAN ONLY INPLACE UPDATE THE HEAD REC OF A MULTI-PAGE RECORD, DATABASEMETAWRITER.CPP:1417
IT18626DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES.
IT18623HIGH CONTENTION ON SQLO_LT_SQLRISECTINIT_C__DYNAMIC_XLATCH with high degree of smp parallelism when cleaning up sort operators
IT18618DB2_INSTALL IS FAILING ON HCAMP CLUSTER EVEN IF TSAMP FEATURE ISEXPLICITLY EXCLUDED
IT18614DB2 TRAPS ON SQLELOOKUPAUDITSETTINGS WITH SQLO_SLATCH_ERROR_HELDX_WITH_SHARED_HOLDERS ON DPF
IT18611ACTIVATE DATABASE MIGHT HANG WHEN LOGARCHMETH1 IS TURNED OFF
IT18608ON A NAT ENVIRONMENT WITH THE REGISTRY VARIABLE DB2_HADR_NO_IP_CHECK TURNED ON, HAS ISSUES WITH MULTIPLE HADR STANDBYS.
IT18607DB2GCF MIGHT INCORRECTLY REPORT INSTANCE AS OPERABLE INSTEAD OF AVAILABLE WHEN USING VIRTUAL HOSTNAME IN DB2NODES.CFG
IT18603SQL1419N ERROR (REASON CODE 23) IN PURESCALE ENVIRONMENT WHEN USING THE REBUILD OPTION OF THE RESTORE COMMAND.
IT18601DB2 11.1 BLU QUERY USING EXCESSIVE TEMPSPACE AS COMPARED TO DB2 10.5
IT18591IN FEDERATION, SYSPROC.NNSTAT SEEMS TO UPDATE STATS_TIME
IT18590DB2 CLIENT APPLICATION ON WINDOWS MAY CRASH IN WINDOWS' FUNCTIONCALLED FROM DB2SYS!SQLZDB2SYSDLL.
IT18578A COMPLICATED SELECT STATEMENT MAY RECEIVE SQL0901N RARELY
IT18567TRAP ON ICU LIBRARIES ICU_3_8::TIMEZONE::INITDEFAULT
IT18553STANDBY CRASHES IF MIRROR LOG PATH IS CHANGED AND DATABASE IS NOT REACTIVATED AFTERWARDS.
IT18550PASSWORD IN DB2CONNECTION.CONNECTIONSTRING DISPLAYED IN SYSTEM.REFLECTION.FIELDINFO OUTPUT WITH PERSIST SECURITY INFO=FALSE
IT18547PASSWORD IN DB2CONNECTION.CONNECTIONSTRING DISPLAYED IN SYSTEM.REFLECTION.FIELDINFO OUTPUT WITH PERSIST SECURITY INFO=FALSE

© 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