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
IT22979CREATED FEDERARED PROCEDURE FOR A SP WITH NO ARGUMENTS IN ORACLEDATABASE MAY FAIL WITH -901
IT22978DB2PD HANG
IT22972QUERY INVOLVING OUTER JOINS HAS WRONG COLUMN RESULT NULLABILITY
IT22968RUNSTATS with index sampling can produce INCORRECT NLEAF OF PARTITIONED INDEX FOR LARGE RANGE PARTITIONED TABLE
IT22962CREATED FEDERARED PROCEDURE FOR A SP WITH NO ARGUMENTS IN ORACLEDATABASE MAY FAIL WITH -901
IT22946LPAD/RPAD RETURN EMPTY STRING INSTEAD OF NULL IN ORA-MODE DATABASE
IT22945SQLGETTYPEINFO RETURNS 255 FOR CHAR DATATYPE WHEN CONNECTION FROM V11 CLIENT TO V10.5 SERVER.
IT22941TRAP/901 WHEN XML COLUMN NOT REFERENCED
IT22921DUMP.BIN FILES ARE GENERATED ON THE HADR PRIMARY SERVER
IT22920DUMP.BIN FILES ARE GENERATED ON THE HADR STANDBY SERVER
IT22919IN ORA COMPATIBITITY MODE, ROUND FUNCTION MAY RETURN VALUES AS EXPONENT EXPRESSION
IT22906RESTORE OF A SNAPSHOT BACKUP IMAGE FROM A DOWNLEVEL RELEASE FAILS IN A PARTITIONED DATABASE ENVIRONMENT WITH SQL1031N
IT22893DB2PD HANG
IT22892LOAD IN DPF DATABASE CREATES TEMP FILES THAT ARE NOT CLEANED-UP AFTER THE LOAD IS COMPLETED
IT22884TRAP/901 WHEN XML COLUMN NOT REFERENCED
IT22880DB2 ENGINE MIGHT CRASH WHEN QUERIES HAVE OUTER JOINS, NOT EXISTSOR NOT IN PREDICATES
IT22873ADMIN TASKS NOT EXECUTED DUE TO NEXT INVOCATION TIME IN THE PAST
IT22871ADMIN TASKS NOT EXECUTED DUE TO NEXT INVOCATION TIME IN THE PAST
IT22869DB2PD -OSINFO MIGHT IN RARE TIMING CONDITIONS CRASH WITH SEGV
IT22862AGGSQLTEMPSPACE THRESHOLD DOES NOT LIMIT TEMPORARY TABLE SPACE SIZE.
IT22850DECREASED PERFORMANCE, STMMSTARTHJMONITORIFNECESSARY ERRORS LOGGED IN CONSTRAINED/VOLATILE STMM ENVIRONMENTS
IT22826WRONG RESULT WHEN PREDICATE HAS CONCATENATED CONSTANT AND COLUMN.
IT22822WRONG RESULT WHEN PREDICATE HAS CONCATENATED CONSTANT AND COLUMN.
IT22815CRASH MAY OCCUR DURING CDE JOIN WHEN PROCESSING A LARGE AMOUNT OF DATA
IT22814THE DB2.EMP DIRECTORY IS NOT REMOVED AFTER RUNNING INSTALLFIXPACK
IT22796DB2EXPLN FAILS WITH SQL1131N
IT22791POSSIBLE WRONG RESULTS WITH VARCHAR_FORMAT WHEN USING 'DY DDD YYYY' FORMAT
IT22790BUG IN VARCHAR_FORMAT WHEN USING 'DY DDD YYYY' FORMAT
IT22783INCORRECT RESULT WHEN USING THE XMLTABLE FUNCTION AND REFERENCING ELEMENTS THAT DON"T EXIST IN THE SOURCE DOCUMENT
IT22782STORED PROCEDURE SAPTOOLS.PARTITION_MERGE SPORADICALLY FAILS WITH SQL668 REASON CODE 11
IT22780CRASH MAY OCCUR DURING CDE JOIN WHEN PROCESSING A LARGE AMOUNT OF DATA
IT22776INSTALLFIXPACK PARAMETER "-P" IS INVALID FOR NON-ROOT INSTALLATION
IT22769SNAPSHOT TEMPORARY FILES LEFT IN SQLLIB/TMP AFTER FMP INTERRUPTION
IT22759DB2 AGENT/DB2FMP CAN HANG DUE TO INCOMPLETE HANDSHAKE DURING INTERRUPT
IT22757DB2 MIGHT SEEM TO HANG DURING QUERY COMPILATION
IT22750POSSIBLE WRONG RESULTS WITH VARCHAR_FORMAT WHEN USING 'DY DDD YYYY' FORMAT
IT22746FEDERATED QUERY WITH FUNCTION TEMPLATE OVER a GROUP BY or UNION may fail with -901 "No ftslpd through GB/UNION DISTINCT"
IT22743APPLICATIONS MAY RECEIVE SQL1034C WHEN TAKEOVER HADR BY FORCE ISISSUED.
IT22740DB2 MAY TRAP IN @114@OSSPOWERPCFETCHANDNOOP64__FPVL SQLMONSZAGNT__FUI13SQM_ENTITY_IDP6SQLMAIPUIP5SQLCA
IT22735COMPONENTLIST.HTM LISTS ESE INSTEAD OF SERVER
IT22725NUM_DB_BACKUPS AND REC_HIS_RETENTN MIGHT NOT BE PROPERLY HANDLEDBY PRUNE HISTORY
IT22718DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER
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
IT22681INSERT into a column-organized table table might fail with errorSQL901.
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
IT22647STATEMENT MAY FAIL WITH FOLLOWING ERROR: PERMANENT TAOB FOR MDC BIXA OBJECT IS NULL
IT22646-901 OR TRAP WHEN OUTER JOIN ON GROUP BY AND UNION
IT22643IBM DATA SERVER CLIENT CANNOT BE DETECTED BY IBM LICENSE METRIC TOOL (ILMT)
IT22621SECURITY MECHANISM NOT SUPPORTED EXCEPTION WHEN AUTHENTICATION=CLIENT AND PASSWORD AND USER ARE PROVIDED.
IT22620DB2PREREQCHECK REPORTS MISSING OF LIBIPATHVERBS.I686 INCORRECTLY
IT22619"DB2IUPDT -COMMIT_LEVEL <INSTANCE NAME>" FAILED WITH DBI1558E SAYING CF IS NOT SAME LEVEL WITH MEMBER
IT22618DB2 MIGHT INCORRECTLY LIMIT NUMBER OF CPU CORES USED WHEN RUNNING WITH CPU_LIMITED LICENSE.
IT22617FAILURE TO ALLOCATE SHM SEGMENT WITH HUGE PAGES MIGHT END UP WITH TRAP OR INCORRECT BEHAVIOR
IT22616THE "ADD DBPARTITIONNUM" STATEMENT MAY FAIL WITH SQL1483N
IT22615OWNER / QUALFIER OF STORED PROCEDURE CHANGED TO SYSIBM
IT22614RUNGSEDEMO FAILS WITH SQL0604N IF DB CFG STRING_UNITS = CODEUNITS32
IT22613ADDITIONAL CALLS IN AGENT BREATHING POINT CAUSE POOR PERFORMANCEIN LOAD UTILITY
IT22612HADR ROS FAILS WHEN A QUERY ON THE STANDBY HAS AN ORDER BY CLAUSE
IT22611SQLOAMINSTALLIMAGE LEAKING FILE DESCRIPTORS
IT22610UNDER RARE CIRCUMSTANCES WHEN HISTORY FILE GROWS MORE THAN 4 GB BACKUP CAN HANG
IT22609DATABASE RESTORE HITS ADM6091W ON TABLESPACE MAXSIZE
IT22608DB2 DUMP FILE SIZE IS GETTING BIGGER WHEN REPEATING SAME WARNINGMESSAGE IN LOG RETRIEVING
IT22607THE 512 BYTES MISALIGMENT DURING LOB PROCESSING MIGHT INTRODUCE CONTENTION ON GPFS.
IT22606A LOCKING EVENT MONITOR CAN INCORRECTLY CAPTURE STATIC STMT TEXTAND REPORT INCORRECT NUMBER OF INPUT VARIABLES
IT22605HADR STANDBY MIGHT GET CORRUPTED IN CASE FAILURE DURING MULTIPLEREORG RUNNING ON HADR PRIMARY
IT22604DB2START MIGHT HANG IN TRCATTACHSHARED() ON THE SYSTEM WITH LOW SHARED MEMORY SEGMENT SIZE LIMIT (SHMMAX)
IT22603AUTOMATIC REORG CAN KEEP OCCURRING ON TABLES IF THERE IS A SINGLE INDEX PAGE & IS PSEUDO EMPTY.
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
IT22548INCORRECT RESULT WHEN USING THE XMLTABLE FUNCTION AND REFERENCING ELEMENTS THAT DON"T EXIST IN THE SOURCE DOCUMENT
IT22532FAILURE ON MEMBER-CF COMMUNICATION ONCE ONE OF REDUNDANT SWITCHES IS FAILED.
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
IT22464DB2DIAG.LOG FILLED WITH ERROR ON FUNCTION SQLBFINDPAGEINBPORSIMPROBE: 1952 SQL0003N THE DATABASE NAME IS NOT VALID
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
IT22261SLOW INSERT PERFORMANCE WHEN USING MON_OBJ_METRICS EXTENDED
IT22260INSTANCE CRASH AFTER RUNNING OUT OF MEMORY
IT22243DB2CONNECT server may trap if CURRENT CLIENT_CORR_TOKEN is explicitly set by an application.
IT22237THE DB2FMCD PROCESS DOES NOT START DB2 INSTANCES AT SYSTEM BOOT TIME.
IT22221SQL901N MAY OCCUR WHEN EXECUTING A SQL STATEMENT CONTAINING TWO OR MORE NOT IN OR NOT EXISTS PREDICATES
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
IT22056QUERY INVOLVING OUTER JOINS HAS WRONG COLUMN RESULT NULLABILITY
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
IT21910INSTANCE CRASHED WITH SIGSEGV IN LIBPTHREAD.SO.0
IT21908ATTEMPTING TO REVALIDATE A COMPLEX MASK CALLING ADMIN_REVALIDATE_DB_OBJECTS MIGHT FAIL
IT21907DB2 MIGHT HANG DURING A MANUAL 'UPDATE DATABASE CFG' TO DECREASETHE DATABASE MEMORY CONFIG SETTING
IT21906NSE CHACKNSEINDEX UTILITY MAY RETURN CTE5257E REASON CODE "2"
IT21905DB2 MIGHT PRODUCE SUBOPTIMAL PLAN FOR DEEPLY NESTED NOT EXISTENTIAL SUBQUERIES
IT21903Crash in embeddedSQL application while closing the cursor.
IT21902BACKGROUND DAEMONS MIGHT NOT START JUST AFTER TAKEOVER HADR DUE TO TIMING HOLE.
IT21897WRONG RESULT IS POSSIBLE WHEN CODEUNITS 32 IS USED IN A ROW DATATYPE ASSIGNMENT AND CAST IS USED
IT21849ALTER OF CHAR/VARCHAR COLUMN TO GRAPHIC/VARGRAPHIC DATA TYPE IN A NON-UNICODE DATABASE COULD CAUSE SQL2216N
IT21848LDAP PLUGIN NOW ALLOWS SIGNATURE ALGORITHMS TO BE SPECIFIED WHENUSING TLS 1.2
IT21847AUTO REORG FOR DATA PARTITIONS IGNORES USER SPECIFIED OPTIONS INREORG POLICY
IT21846DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING NOT EXISTS SUBQUERY WITH NESTED SUBQUERIES
IT21844DB2 MAY CRASH DURING PROCESSING OF THE OPTIMIZER PROFILE
IT21843THE CLI LOAD API MAY ABNORMALLY END (ABEND) ON CERTAIN VERSIONS OF LINUX
IT21842IN XA/PURESCALE ENVIRONMENT, XA-END COULD BE BROADCASTED TO ALL NODES EVEN IF THEY WEREN'T PART OF THE TRANSACTION.
IT21841ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL2102N RC=22 WHEN USING COPY_USE_LOAD
IT21840UNEXPECTED OOM ERRORS AFTER A LARGE DYNAMIC DATABASE CONFIGURATION INCREASE
IT21839INCONSISTENT STATE OF SYSIBMTS SCHEMA OBJECTS CANNOT BE CLEANED
IT21838THE SAME 'DATABASE NAME' IS LISTED AT 'LOCAL DATABASE ALIAS' EVEN IF 'ALIAS' AND 'NAME' ARE DIFFERENT IN DB2DSDRIVER.CFG.
IT21837IN PURESCALE ENVIRONMENT: DB2PD -REORGS DOESN'T SHOW REORG INFORMATION AFTER RUNNING ONLINE REORG SECOND TIME
IT21836ACS FILES PRESENT IN $INSTHOME/SQLLIB/ACS WHEN CLIENT INSTANCE CREATED FROM SERVER INSTALL
IT21835IMPROVE PD DIAGNOSTICS FOR DB2HACFSVERIFYMAINTENANCEMODE() AND DB2HACFSSETCLUSTERCONFIGURATION() FUNCTIONS.
IT21834DB2MOVE MAY NOT COPY UNDER SUPPORTED MULTI-BYTE CODE CONVERSION ENVIRONMENT
IT21833INGEST MAY FAIL IF 'ALIAS' AND 'NAME' IS DIFFERENT IN DB2DSDRIVER.CFG
IT21831ERROR MESSAGE SQLP_NOTA "TRANSACTION WAS NOT FOUND" FOR SQLRR_XROLLBACK IS INCORRECTLY LOGGED IN DB2DIAG.LOG
IT21830SQL0818N RETURNED TO APPLICATION WHEN SQL PROCEDURE INVOKED AFTER THE PRIOR INVOCATION WAS ROLLED BACK.
IT21829CONCURRENT INGEST MIGHT FAIL INTERMITTENTLY WITH SQL0901N "INVALID PARAMETER"
IT21827Snapshot backup might fail with error SQL2079N
IT21826EVMON_FORMAT_UE_TO_XML DOES NOT SORT PARTICIPANT PAST ACTIVITIESIN A USEFUL WAY
IT21825A COMPLICATED SELECT STATEMENT MAY RECEIVE SQL0901N RARELY
IT21824IN FEDERATION, SYSPROC.NNSTAT SEEMS TO UPDATE STATS_TIME
IT21823MEMORY LEAK IN DBHEAP IF DB2READLOG RECEIVES AN ERROR TO FIND LOG FILE.
IT21821SIGSEGV AFTER CALLING SQLBDIRTYTBSPACEFLAGSFORBACKUP
IT21820LATCHES SUCH AS SQLO_LT_SQLP_DBCB__READBUFSEM ARE NOT BEING REPORTED IN MON_GET_EXTENDED_LATCH_WAIT
IT21819TBSP_INCREASE_SIZE RETURNED BY MON_GET_TABLESPACE HAS INVALID VALUE
IT21818-30020 WITH MULTI ROW FETCH AND SPLIT BUFFER THAT CONTAINS LOB DATA
IT21817SUB-OPTIMAL PERFORMANCE OF DBMS_UTILITY.GET_HASH_VALUE
IT21814SQLDPREFETCHFORESTIMATE, PROBE:7433 ZRC=99 MAY BE SEEN WHEN USING ADMIN_GET_TAB_COMPRESS_INFO
IT21813WPLISTENER.SH FAILS TO START WITH : 75: [: -START: UNEXPECTED OPERATOR ERROR
IT21812PURESCALE MEMBER STUCK IN CRASH RECOVERY.
IT21811FEDERATION AND DBMS_SQL MAY RECEIVE SIGSEGV AT SQLEUCTRUSTEDLVLINIT
IT21810MEMORY CRASH WHEN CALL SYBASE WRAPPER THROUGH FEDERATED.
IT21809THE DB2SUPPORT TOOL MAY ABNORMALLY END (ABEND) ON CERTAIN VERSIONS OF LINUX
IT21808VARIOUS MEMORY LEAKS IN DB2SYSC WHEN USING TEXTSEARCH
IT21807INSTANCE MAY TRAP IN GETENV FUNCTION DURING UPDATING DB2 TEXT SEARCH INDEXES
IT21806JUMP SCAN MAY GET SIGSEGV AT SQLNO_PLAN_ARGS_SCAN
IT21805QUERY ABNORMALLY ENDS IN SQL0901N "EMPTY PLAN LIST DETECTED!"
IT21804FLUSH BUFFERPOOL ALL ON STANDBY MAY CAUSE FORCEDBSHUTDOWN
IT21803AUTO_REORG ON ITC TABLES MAY FAIL WITH SQL0960, INDEX EVALUATIONIS LOOPING
IT21802CLOB DATA GREATER THAN 32KB MIGHT BE CORRUPTED IF FEDERATION SERVER SENDS IT TO ORACLE DATABASE.
IT21801CTE0243 AND CTE0277 ERROR WHEN CALLING DB2EXT.TEXTSEARCH PROCEDURE EVEN THOUGH THE CACHE FOR THE INDEX IS ACTIVATED.
IT21800SQL901 ERROR DURING QUERY COMPILATION.
IT21799DB2 HEALTH MONITOR PROCESS (DB2ACD) MIGHT LEAK MEMORY IN HADR ENVIRONMENT AFTER A TAKEOVER
IT21798MSSQL WRAPPER MIGHT RETURN SQL1822N (HY024: INVALID ARGUMENT VALUE) IF SOURCE TABLE HAS LARGE NUMBER OF COLUMNS.
IT21797CRASH IN XMLRNSETUPXMLDD BECAUSE FAILING TO ALLOCATE MEMORY AND THEN FREEING MEMORY WE WEREN'T ABLE TO ACQUIRE
IT21796"UOW LOG SPACE USED" IN APP SNAPSHOT NEVER RESET WHEN USING XA TRANSACTION
IT21795SOME EXTRA LOG FILES REMAIN IN MIRRORLOGPATH AFTER CHANING LOGPRIMARY AND/OR LOGSECOND IN CIRCULAR LOGGING MODE
IT21793DB2 UPGRADE DATABASE MIGHT FAIL WITH SQL1704N RC 17 IF MAXSIZE LIMIT FOR SYSCATSPACE IS HIT DURING THE UPGRADE (ADM6091W)
IT21792DB2 EVENT MONITOR FOR CHANGE HISTORY IS NOT LOGGING THE ATTACH PARTITION COMMAND
IT21791MSDTC PROCESS CAN CRASH IN DB2APP64.DLL
IT21790INGEST REPORTS SQL1057W OR SQL1031N WHEN USING DS DRIVER BUT DATABASE IS NOT CATALOGED IN THE DATABASE DIRECTORY
IT21789DB2 MIGHT INCORRECTLY TRY TO ADD CONTAINER WITH A DUPLICATE NAME
IT21788DB2 REQUIRES OLDER ARCHIVE LOG FILE FOR DB2READLOG API EVEN IF REQUESTED LSN IS NEWER THAN STARTLSN OF THE CURRENT ACTIVE LOG
IT21787WHEN INTRA_PARALLEL IS ON QUERIES USING HASH JOINS MAY HANG AND NOT BE ABLE TO BE FORCED OFF
IT21786RUNNING THE "DB2CLUSTER -LIST -ALERT" COMMAND GENERATES "SQLHA EVENT RECORDER HEADER DATA" MESSAGES IN THE DB2DIAG.LOG
IT21785DB2 LOAD FAILING IN DPF ENVIRONMENT DUE TO SQL0969N THERE IS NO MESSAGE TEXT CORRESPONDING TO SQL ERROR "-2769"
IT21784MEMORY LEAK IN TASK SCHEDULER AS ATSTASK OBJECTS ARE NEVER DESTROYED
IT21783IMPROVE PD DIAGNOSTICS FOR DB2HACFSEXITMAINTENANCEMODE() AND DB2HACFSENTERMAINTENANCEMODE() FUNCTIONS.
IT21781MEMBER COULD NOT BE ACTIVATED AFTER IT WAS STOPPED IN PURESCALE.
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
IT21755ENTITY FRAMEWORK EXCEPTION 'MAPPING SPECIFIED IS NOT VALID' WHENUSING BOOLEAN COLUMNS WITH INFORMIX
IT21754SQL5193N RECEIVED ON WORKLOAD ASSIGNMENT WHEN ROLE IS INHERITEDFROM A TRUSTED CONTEXT
IT21753DB2LOOK -XD DOES NOT GENERATE GRANTS FOR AUTHORIZATIONS IMPLICITLY GIVEN ON THE OBJECT
IT21751DB2 EDU MIGHT TRAP IN SQMFASTWRITER::INITFASTWRITER() DURING THETAKEOVER IN HADR ENVIRONMENT AFTER SQLO_NOMEM_DBH ERROR
IT21750PRIVATE MEMORY LEAK BY DB2FCMS IN A PURESCALE ENVIRONMENT
IT21749SQLKDDISPATCHREQUEST FAILS WITH SQLKF_NODE_FAILED ERROR EVEN AFTER ROCM REPORTS DEPARTURE NOTIFICATION
IT21748SIGNAL 11 TRAPS GENERATED IN SQLMONBACKEND FUNCTION
IT21746CREATE TABLE FAILS WITH SQL1655C INTERMITTENTLY AFTER FAILED LOAD
IT21745OPTIMIZER MIGHT CHOOSE A SUBOPTIMAL TBSCAN OVER IXSCAN FOR SQL STATEMENT CONTAINING A SUBQUERY PREDICATE
IT21744-901: INVALID SVAR LEN, PRODUCING FODC_APPERR
IT21743APPLICATION INTERRUPT ERROR MESSAGES IN DB2DIAG.LOG DUE TO AUTO RUNSTATS
IT21742NOT ABLE TO DROP A PACKAGE AND INSTANCE GOING DOWN WHEN DROP PACKAGE DUE TO FUNCTIONS HAVE DEPENDENCY ON EACH OTHER
IT21741THE CHARACTER DATA IS CORRUPTED IN SYSIBMTS.TSEVENT VIEW IS INCORRECT IF DB2TS UPDATE INDEX IS SCHEDULED BY ALTER INDEX COMMAND.
IT21740DB2 Text Search Fails to Create Text Index On XML Datatype Output From UDF Due to CIE00312 Error
IT21739ADMIN_GET_TAB_COMPRESS_INFO TABLE FUNCTION RETURNED SQL0901N ERROR WITH LOAD PENDING TABLESPECE HAVING PARTITIONED TABLE.
IT21738MEMORY LEAK IN 'DB2ACD' WHEN 'AUTO REORG' IS EVALUATED
IT21737INSTANCE MIGHT CRASH WHEN WHEN THE RID WAS DELETED FROM INDEX AND MDC TABLE
IT21736TRAP IN DPF ENVIRONMENT WHEN COMPLEX QUERY WITH AGGREGATION IS RUN
IT21735QUERY MAY FAIL WITH SQL1585N LOOKING FOR A 4K TEMP TABLESPACE DESPITE OTHER TEMP SPACES ARE AVAILABLE
IT21734DB2 CONNECTS TO STANDBY EVEN PRIMARY DATA IS UP.
IT217338KB MEMORY LEAK IN CLI_SETSESSIONGLOBALVARIABLES()
IT21732DATABASE UPGRADE/RESTORE FROM PRE-10.1 MIGHT CORRUPT CONTAINER PATH IN SPCS IF SYMLINK IS USED
IT21731ERROR DURING RETRIVAL OF LOG FILES WHILE TAKING THE DATABASE BACKUP.
IT21730IN SOME CIRCUMSTANCES REVALIDATION OF INVALIDATED VIEWS MAY NOT SUCCEED
IT21728THE ROUTINE AUDIT_LIST_LOGS IS NOT ABLE NOT HANDLE 64 FILES.
IT21727CREATE DATABASE FAILS WITH "ERROR ACCESSING A TABLE SPACE CONTAINER" ON A DEVICE WITH SECTOR SIZE OTHER THAN 512 BYTES.
IT21726Deadlatch caused query on a range partitioned table to hang in aparallel environment
IT21725INDEX SCAN MAY ENCOUNTER CRASH WHEN RID IS NEEDED FOR USER DEFINED TEMP TABLE
IT21724SMALL MEMORY LEAK IN DB2 CLIENT/DRIVER IF CLIENT AFFNITY IS ENABLED
IT21723DB2FOC DOES NOT CHECK FOR ELEVATED PRIVILEGES ON WINDOWS
IT21722ON DB2 V10.5 FP7 DB2 -L /DEV/NULL <ANY OPERATION> RESULTS INTO ERROR DB21005E
IT21721SQL0901N REASON "PROBE 015 IN SQLKT_PACK_TUPLE(), MSG=INVALID LEN.CLEN(X) OR STORAGELEN" WHEN CREATING AN INDEX
IT21720DB2INIDB WILL GO INTO INFINITE LOOP IF SQLSPCS FILE IS GREATER THAN 2GB
IT21719'DB2 WRITE SUSPEND FOR DATABASE' COMMAND HUNG DUE TO DEAD LATCH WHEN USING 'EXCLUDE LOGS' OPTION
IT21718DB21018E RETURNED TO A CLP COMMAND RUN VIA NOHUP IF THE PARENT SHELL HAS EXITED.
IT21717INSTANCE MAY PANIC WHEN TRYING TO DROP AN OBJECT IF ANOTHER AGENT HAS ACCESS ON THE OBJECT WITH ERROR TCB FIX COUNT != 1 IN DB2D
IT21716DB2 CONNECTIONS WORKS FINE WHEN A PASSWORD IS EXPIRED
IT21715CLOB DATA MIGHT BE GARBLED IF SOURCE EBCDIC DBCS STRING EXCEEDS 32K.
IT21713TEST FOR -NOEXEC MOUNT INCORRECTLY FAILS IN DB2SETUP SCRIPT
IT21712SIGNIFICANT INCREASE IN SHARED APPLICATION HEAP AFTER UPGRADE TO10.5 FOR QUERIES REFERENCING RANGE PARTITIONED TABLES
IT21711REVOKING PRIVILEGES MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT21710REMOVE LICENSE CHECKING FROM THE CONNECTION CREATION LOGIC ON SERVER SIDE TO IMPROVE PERFORMANCE
IT21709CLI APPLICATION RECEIVES SIGNAL SIGSEGV DURING A CALL OF A STORED PROCEDURE
IT21707ADD PDLOGS TO DB2 HA TSA WRAPPER FUNCTIONS
IT21706ALTER TABLE STATEMENT WITH AN ATTACH PARTITION CLAUSE MAY RECEIVE SQL0803N
IT21705IN DPF, DB2 TRAPS IN sqeDBMgr::LocalDeactivate IF A NODE FAILS AND THAT NODE IS THE CATALOG NODE FOR SOME DATABASE
IT21704DYNAMIC SQL SNAPSHOT MAY FAIL WITH SQL1224N WHEN CLIENT AND SERVER USE DIFFERENT CODEPAGE
IT21701"NET STOP" AND "NET START" DO NOT RELEASE THE QUIECE MODE
IT21695DB2READLOG API CALLERS THAT START READING FROM A GIVEN LFS/LSN THAT EXIST IN A MISSING LOG EXTENT MAY CAUSE SQL2654W
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
IT21328FEDERATED QUERY WITH FUNCTION TEMPLATE OVER a GROUP BY or UNION may fail with -901 "No ftslpd through GB/UNION DISTINCT"
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
IT21033COST OVER-ESTIMATE OF THE REFETCH DURING UPDATE/DELETE/MERGE OPERATION
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

© 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