Fix List for DB2 Version 10.1 for Linux, UNIX and Windows

Technote (troubleshooting)


Problem(Abstract)

DB2 10.1 APAR Fix list contains list of APARs shipped for each fix pack in DB2 Version 10.1 for Linux, UNIX and Windows products. The Severity column value of 1 is high and 4 is low. Severity column represents the severity of the PMR at the time the APAR was opened.

Resolving the problem

Tab navigation

************************************************************
Product Name : DB2 UDB Version 10.1
Updated : Fri May 23 11:52:27 EDT 2014
************************************************************

Select a Fix Pack: 4 | 3a | 3 | 2 | 1


DB2 Version 10.1 Fix Pack 4
APAR Sev. Abstract
IT02365 2 MANY MMKSH PROCESSES ARE SPAWNED FROM MOUNTV10_MONITOR.KSH AND MAY CONSUME HIGH CPU
Fix Pack 4  -   Abstract Data Types and Spatial Extender
IC98507 3 PERFORMANCE MAY BE SLOW FOR SOME QUERIES USING DB2GSE.ST_INTERSECTS
Fix Pack 4  -   Administration Server
IC96292 2 WHEN A SCRIPT RUNS IN TASK CENTRE, EXTRA SLASH ADDED TO LIBPATH CAUSING INSTANCE ENV SWITCH USING DB2PROFILE TO FAIL
IC96468 3 USERS ON AIX IN DB2 V10.1 FP3, DASJVM::INITIALIZATION ERROR IN DB2DIAG.LOG, SQLCODE: -22209 RETURNED.
Fix Pack 4  -   Administration Tools
IC96680 1 DB2LOOK DOES NOT GENERATE COLUMN OPTIONS FOR TYPED TABLES
IC98333 2 SQL3022N - SQL ERROR "-104" EXECUTING DB2MOVE WITH EXPORT FROM DB2 Z/OS DATABASE
IC96865 2 AUTOMATIC BACKUP DOES NOT DELETE OLD BACKUP IMAGE IN DB2 V10
IC98508 2 DB2LOOK -M GENERATES RUNSTATS COMMAND WITH WRONG "NUM_FREQVALUES-1 NUM_QUANTILES -1" OPTIONS
IC97811 2 SQL0206N "A.TYPERULES" NOT FOUND SHOULD NOT BLOCK DB2LOOK TO GENERATE DDLS FOR OTHER OBJECTS
IC99625 2 DB2LOOK -L COLLECTS CONTAINER INFORMATION FOR AUTOMATIC STORAGE TABLESPACES WHICH IS NOT NEEDED BUT COULD CAUSE SLOWNESS ON DPF
IC97151 2 DB2LOOK -T OPTION WITH TWO-PART TABLE NAMES OF THE FORMAT SCHEMA.TABLE AGAINST DB2 Z/OS IT DOES NOT FIND THE TABLE.
IC96693 2 SQL0104N IS RETURNED WHEN UPDATING SYSSTAT.COLDIST.COLVALUE VIA DB2LOOK MIMIC MODE
JR47442 2 FED: DB2LOOK GENERATE INCORRECT FUNCTION MAPPING DDL
IC99726 2 CALL SYSPROC.AUTOMAINT_SET_POLICY() TO SET A NEW AUTO_REORG POLICY MAY RETURN SQL1437N - 'UNTERMINATED END TAG' DB2AUTOREORG
IC98071 3 DB2IUPGRADE FAILS WHEN MOVING FROM V8.2 TO V9.7FP5 AND HIGHER
IC96302 3 "INTERNAL HEALTH MONITOR ERROR " ERRORS DUMPED IN THE DB2DIAG.LOG FOR "DB2.MAX_SORT_PRIVMEM_UTIL" HEALTH INDICATOR
IC96694 3 ATS DAEMON MAY CAUSE A STACK OVERFLOW DUE TO RECURSIVE CALLS ANDSUBSEQUENT SEGV IF AN ERROR CONDITION IS ENCOUNTERED
IC97128 3 DB2LOOK MAY GENERATE THE SAME PREDICATE TO MIMIC STATISTICS FOR UNIQUE INDEXES.
JR47702 3 DB2LOOK GENERATES INCORRECT HIGH2KEY/LOW2KEY FOR CHAR/VARCHAR WHEN VARCHAR CAPATIBILITY IS ON
IC97821 3 PAGE_FETCH_PAIRS AND AVGPARTITION_PAGE_FETCH_PAIRS STATISTICS CANNOT BE CLEARED BY MANUAL UPDATE IF VARCHAR2 COMPATIBILITY IS ON
IC96298 3 HEALTH MONITOR FAILS TO DIFFERENTIATE BETWEEN HADR PRIMARY AND SECONADRY AFTER HADR TAKEOVER.
Fix Pack 4  -   Buffer Pool Services
IC99216 1 POSSIBLE CRASH (PANIC) OF DB2 IN SQLBREMOVEPAGEFROMTHISDIRTYLISTWITH MESSAGE "DEQUEUE W/0 PAGES ON DL"
IC99381 2 DATABASE HANG DURING FORCED SHUTDOWN OR HADR TAKEOVER
IC96706 2 PREFETCHER ERROR WITH SQLB_BADHDR "BAD PAGE HEADER" IN SQLB_VERIFY_PAGE, PROBE:6
IC99961 2 INCREMENTAL BACKUP MAY FAIL WITH SIGSEGV OR SQLO_EOF / SQL1655 DURING EMP CHAIN PROCESSING
IC98005 2 DROPPING ALL INDEXES FROM INDEX OBJECT FOLLOWING REORG INDEX RECLAIM EXTENTS MAY RETURN SQL1034C AND CAUSE INSTANCE ABEND
IT01599 2 ADDING STORAGE AND HITTING DISK FULL RESULTS IN A BAD SGF FILE
IC97599 2 CRASH RECOVERY FAIL WHEN FREEING DELETE PENDING EXTENTS
IC96465 2 TABLE SPACES HAVING ONLY ONE CONTAINER CAN NOT MAKE USE OF "VECTORED IO"
IC96692 2 DB2RELOCATEDB OR "DB2INIDB ... RELOCATE USING" MIGHT CONSTRUCT WRONG CONTAINER PATH NAME
IT01115 2 INCREMENTAL BACKUP MAY FAIL WITH ZRC SQL_EOF AND SQL1655 DURING EMP PAGE PROCESSING FOR LONG DATATYPE OBJECTS
Fix Pack 4  -   Build Team
IC94760 2 XQUERY MAY GET SQL1224N AND SIGSEGV
IC90397 2 SECURITY: MULTIPLE GSKIT VULNERABILITIES IN IBM DB2 (CVE-2012-2190, CVE-2012-2191, CVE-2012-2203, CVE-2013-0169).
IC97471 3 SECURITY: NULL POINTER DEREFERENCE IN DB2'S XSLT PARSING ENGINE (CVE-2013-5466).
Fix Pack 4  -   Client Interfaces
IC99396 1 UNHANDLED EXCEPTION: SYSTEM.ACCESSVIOLATIONEXCEPTION: ATTEMPTED TO READ OR WRITE PROTECTED MEMORY.
IC98963 1 WHEN APP HAVE BOTH CLIENT SIDE TRIAL LIC AND SERVER LIC, THE SQLGETINFO (CLI) FUNCTION WILL REPORT INCORRECT INFORMATION
IC97838 1 CLPPLUS DISPLAYS INCORRECT RESULT WHEN MORE THAN ONE LIKE CLAUSEIS SPECIFIED IN A SELECT STATEMENT
IC99554 1 SQLPARAMDATAADONET SYSTEM.ACCESSVIOLATIONEXCEPTION
IC93857 2 CALLING SQLSETSTMTATTR WITH THE OPTION SQL_ATTR_CHAINING_END CANRETURN SQL_ERROR , BUT DOESN'T UPDATE THE ERROR HEADER.
IC96303 2 CONVERSION ISSUE WHEN COMPILING WITH OPTION "WCHARTYPE"
IC91407 2 ERROR WHEN CLPPLUS PERFORMS ENVIRONMENT VARIABLE SUBSTITUTION FOR SQL STATEMENT THAT INCLUDES % CHARACTER
IC99202 2 ADO.NET DB2 PROVIDER - ACCESSVIOLATIONEXCEPTION ISSUE WHEN PERFORMING ARRAY INSERT OF LARGE BINARY VALUES ON A BLOB COLUMN.
IC96684 2 BATCH EXECUTION INTRODUCES INTERNAL COMMIT (EVEN WITH AUTOCOMMITOFF)
IC96874 2 CLI0113E ERROR OCCURS ON TIMESTAMP LITERAL VALUE FOR OUTPUT PARAMETER OF STORED PROCEDURE WHEN IMPLICIT CAST IS DISABLED
IC96300 2 END COMPOUND STATEMENTS THROWS DRIVER NOT CAPABLE AGAINST INFORMIX 12.0, WORKS FINE WITH IDS 11.7
IC96716 2 TWO MINOR MEMORY LEAKS IN CLI WITH SPECIAL REGISTERS AND ONE MAJOR MEMORY LEAK IN .NET
IC96695 2 CLIDRIVER AND DSDRIVER NOT WORKING ON HP PLATFORM :ERROR "SHAREDLIBRARY NOT FOUND 'LIBDB2.SO'"
IC98360 2 CLP +W OPTION DOES NOT HIDE WARNING FOR SELECT STATEMENTS
IC97835 2 EREG :CLIDRIVER AND DSDRIVER , SUN PLATFORM ONLY, 'DB2CLI VALIDATE -DSN DSN_TEST1' THROWS SEGMENTATION FAULT(COREDUMP)
IC95854 2 ERRORS SUCH AS SQL0313N AFTER A CLI APPLICATION EXECUTES DELETE OR UPDATE WITH WHERE CURRENT OF <CURSOR-NAME> CLAUSE
IC99205 2 ADO .NET PROGRAM CRASHES WITH ACCESS VIOLATION ERROR IN A MULTI-THREADED PROGRAM FOR MULTI ROW INSERT.
IC98468 2 VISUAL STUDIO ENTITY DATA MODEL WIZARD MIGHT NOT SHOW ISERIES TYPE L AND TYPE P TABLES
IC98106 2 PARAMETERS STORED AS STRINGS ARE NOT APPLIED BY DB2CFIMP (ERROR -5060)
IC96696 2 FORMATTING DB2TRC USING -CLI OPTION TERMINATES ABNORMALLY ON 64BIT LU PLATFORMS FOR 32BIT APPLICATIONS.
IC98102 2 DB2CFEXP DOES NOT EXPORT AUTOMATIC VALUES PROPERLY IF BACKUP CLAUSE IS SPECIFIED
IC98385 2 DB2CFEXP/DB2CFIMP UTILITIES FAIL TO EXPORT/IMPORT THE CORRECT SECURITY TYPE FOR NODE CREATED WITH SSL SECURITY.
IC95014 2 "DB2 PREP" IS FACING WITH SIGSEGV ERROR WHILE IT IS CALLED IN A MAKEFILE.
IC94998 2 ENTITY FRAMEWORK APPLICATION MAY GET -181 ERROR USING DATETIME AGAINST DATE COLUMN
IC98942 2 INCORRECT RESULTS WHEN FETCHING LOB DATA VIA CLI WITH MULTI-ROW FETCH
IC99456 2 WHEN STATEMENTCONCENTRATOR IS SET ALONG WITH SQL_ATTR_PARAMOPT_ATOMIC=0, CLI APP ERRORS OUT AGAINST DB2 Z/OS(-20186,-215, -312)
IC98799 2 CLI APPLICATION CRASHES DUE TO ARRAY INPUT FLAG FAILS TO RESET IN CLI LAYER WHILE CLI APPLICATION PERFORMS ARRAY INPUT.
IC94807 2 APPLICATION CAN CRASH WHEN USING DB2DSDRIVER.CFG AND IF THE SRVRLST.XML FILE CANNOT BE CREATED
IC97834 2 SQL0902 UNEXPECTED EXCEPTION ERROR MAY OCCUR IN DB2 .NET PROVIDER DUE TO UNHANDLED RETURN CODE DURING CODE PAGE CONVERSION
IC96683 3 DB2CLI VALIDATE -DSN <DSN> -CONNECT FAILES WITH SQL1032N ERROR
IC98273 3 ERROR CLI0199E WHEN CONNECTING TO A CATALOGED DATABASE IF AUTHENTICATION IS SPECIFIED IN CONNECTION STRING OR DB2CLI.INI
IC98607 3 CLI RETURNS BOOLEAN SUPPORT FLAG AGAINST ISERIES AND Z/OS SERVERAS TRUE WHEN BOTH THE SERVER DOES NOT SUPPORT BOOLEAN.
IC97248 3 THE CONNECTION ISOLATION LEVEL IS NOT PRESERVED AFTER A TRANSACTION BUT RE-SET TO THE PRODUCT DEFAULT.
IC95944 3 WHEN DBALIAS IS MENTIONED IN CONNECTION STRING, CLI IS NOT PROCESSING COMMON SECTION OF DB2CLI.INI
IC94310 3 CLPPLUS CAN NOT PUT NEW LINE WITH DBMS_OUTPUT.NEW_LINE.
IC97827 3 APPLICATIONS USING THE IBM DATA SERVER DRIVER RECEIVE SQL0902C ERROR IF DATABASE NAME IS NOT IN THE DB2DSDRIVER.CFG FILE.
IC99430 3 DB2BATCH MAY TERMINATE ABNORMALLY WITH SEGMENTATION FAULT
IC97147 3 DB2CLI VALIDATE -DSN DATABASE RETURNED "MESSAGE : NO CHARACTER DATA IS ALLOWED BY CONTENT MODEL"
IC98852 3 CONCURRENTACCESSRESOLUTION DS DRIVER KEYWORD DOES NOT TAKE EFFECT IF VALUE IS SPECIFIED BY STRING.
IC96642 3 CLPPLUS DOES NOT READ DB2DSDRIVER.CFG PRESENT UNDER CFG FOLDER FOR IBM DATA SERVER PRODUCT INSTALLATION
Fix Pack 4  -   Codegen and Runtime
IC97719 1 UNDER HIGH CONCURRENCY THE FAST INTEGER SORT ( FIS ) FEATURE CANCAUSE HIGH LATCH CONTENTION AND PERFORMANCE DEGRADATION
IC98683 1 ROWS MISSING WHEN LARGE RESULT SET IS PRODUCED BY NULLS FIRST SORT ON INTEGER OR BIGINT
IC97456 1 INCORRECT RESULTS FOR A QUERY WITH A SORTED UNION
IC98361 2 ZIGZAG JOIN GIVES WRONG RESULTS
IC96553 2 SQL0901N ERROR TRIGGERED IN SQLKTSND:AT SANITY CHECK IN CODE
IC97379 2 THE ROUND FUNCTION WITH A MINIMUM VALUE FOR INTEGER AND BIGINT VALUES IS NOT RETURNING THE CORRECT RESULTS
IC97836 2 POOR PERFORMANCE DUE TO FREQUENT MEMORY OPERATIONS DURING QUERIES WITH 'LIKE' PREDICATES.
IC97546 2 INSTANCE CRASH DUE TO RUNTIME SERVICES FREEING AN XML NULL POINTER
IC98141 2 THE UTL_MAIL.SEND PROCEDURE RETURNS SQL1336 AFTER APPLYING SOLARIS PATCH
IC99204 2 DB2 MIGHT DUMP FODC_APPERR DUE TO CODEPAGE ERROR WHEN SELECTING XML COLUMN VIA VIEW WHEN TRUNCATION IS HAPPENING.
IC97775 2 INSTANCE MIGHT ABEND OR RETURN INCORRECT RESULTS DUE TO AN INCORRECT EXECUTION SECTION FOR STAR JOIN
IC95583 2 UNDER RARE MEMORY CONDITIONS, STMM HASH JOIN SIMULATION MAY FAILAND CAUSE FODC TO BE PRODUCED
IT00929 2 COLLATION_KEY_BIT MIGHT GENERATE EMPTY STRINGS IN ORACLE MODE IFINPUT STRING CONSISTS OF BLANKS
IC97793 2 INCORRECT RESULT IN UNICODE DB WITH LIKE PREDICATE AND FULLWIDTH UNDERSCORE WILD CHARACTER ON A CLOB COLUMN
IC97837 2 DB2DIAG.LOG IS FILLED WITH -443 WARNING MESSAGES
IC98959 2 INSTANCE MAY CRASH IF THERE INCONSISTENT STATISTICS
IC98021 2 AN ACCESS PLAN WITH NESTED MDTQ OPERATORS WITHOUT A SORT OR TEMPOPERATOR IN BETWEEN MAY HANG
IC99898 2 FIX CHECK FOR CURRENT_SPECIAL_BUILD
IC95108 2 DB2 INSTANCE MAY TRAP WITH SIGNAL #11 ON SQLKQSND FUNCTION
IC99905 2 SELECT INTO STATEMENT DOES NOT SET VALUE TO A GLOBAL VARIABLE
IC98848 3 COPY PROCEDURE IN DBMS_LOB MODULE MIGHT FAIL AFTER 32KB DATA, ALTHOUGH DBMS_LOB MODULE SUPPORTS LOB DATA UP TO 10MB.
IC97339 3 QUERIES WITH THE XMLTABLE FUNCTION MIGHT RETURN INCORRECT RESULTS
IC97304 3 DIAGNOSTIC FIX TO COLLECT EXTRA DATA, PERFORM EXTRA CHECKS AND PREVENT TRAPS DUE TO MEMORY OVERWRITES IN TABLE QUEUES
IC95046 3 THE DBMS_LOB.COMPARE FUNCTION AND DBMS_LOB.READ PROCEDURE DO NOTPROCESS CLOBS CORRECTLY IF MULTI-BYTE CHARACTERS ARE PRESENT
IC94836 3 WITH CURRENTLY COMMITTED SEMANTICS DISABLED A STATEMENT MAY INCORRECTLY FAIL WITH SQL0901N ( REASON "IMPROPER LOCKING" )
IC98114 3 IN DB2 DPF ENVIRONMENTS ONLY, A SPECIFIC TYPE OF QUERY AND RESULTING ACCESS PLAN MIGHT RETURN WRONG RESULTS
Fix Pack 4  -   Communication
IC96685 2 RETURN ERROR WHEN MULTI-TRANSPORT TM ATTEMPTS TO XACOMMIT/XAROLLBACK WHEN THERE IS WITH-HOLD CURSOR IN USE.
IC97831 2 RESUMPTION OF SUPPORT FOR NAMED PIPES COMMUNICATION PROTOCOL.
IC97833 2 AUTHENTICATION VERY SLOW ON CERTAIN PSERIES HARDWARE WITH POWER7CPU'S
IC97569 3 APPLICATION DELAYS MAY OCCUR WHEN DISCONNECTING FROM DB2 SERVERSON WINDOWS
Fix Pack 4  -   DB2 Tools
IC95264 2 SQL1096N WHEN WE TRY TO STOP/START THE DB2 INSTANCE VIA THE DB2SYSTRAY ICON.
IC97829 2 SQL0108N RETURNED WHEN USING ADMIN_CMD PROCEDURE TO DO TABLE REORG WITH TEMP TABLESPACE OPTION BEING SPECIFIED
IC98031 2 RUN NNSTAT FAILED WITH SQL0134N OR SQL1131N WHEN THERE IS AN INDEX INCLUDE LOB TYPE COLUMN
IC97830 2 LOAD COMMAND USING THE ADMIN_CMD PROCEDURE DOES NOT SHOW ROWS_SKIPPED, ROWS_LOADED, ROWS_DELETED, AND ROWS_COMMITTED WITH DPF
IC97828 3 MESSAGE: "POSSIBLE MEMORY CORRUPTION" IN DB2DIAG.LOG WHEN USING ADMIN_MOVE_TABLE()
Fix Pack 4  -   DRDA Services
IT00893 1 AUTOMATIC CLIENT REROUTE DOES NOT RECONNECT TO THE PRIMARY OR ORIGINAL SERVER
IC99147 1 DB2 DRIVER/CLIENT MAY TRAP FOR APPLICATIONS USING THE WORKLOAD BALANCING (WLB) FEATURE.
IC98074 2 DB2 INSTANCE MIGHT CRASH AFTER REPORTING 'CM PARAMETER BAD' ERROR.
IC94589 2 XA_COMMIT() RETURNED XAER_RMFAIL(-7) WITH PURESCALE ENVIRONMENT DURING XA TRANSACTION RECOVERY, WHEN USING AFFINITIES.
IC95200 2 EXEC SQL SET CONNECTION FAILED WITH SQL0843N
IC99702 2 CHAR DATA CORRUPTION DURING SELECT WITH QUERY ACCELARATION.
IT01405 2 CLI APPLICATION MAY CRASH IN CLI_EXECCMRIFLUSHARRAY() FUNCTION
IC98918 2 INSTANCE TRAPS IN SQLDDADDEXTENDEDDDENTRY()
IC97878 2 SQL30020N ON ROLLBACK, IF CONNECTING TO DB2 10.1 SERVER VIA DB2 CONNECT 9.7 GATEWAY
IC95556 2 THE SINGLE-THREADED APPLICATION CONVERTS TO MILTI-THREADED (2 THREADS)
Fix Pack 4  -   Data Management Services
IT00380 1 SQL1476N WITH ERROR "-668" RETURNED WHEN SET INTEGRITY FOR AN MQT OF "COMPRESS YES" AND "REFRESH IMMEDIATE"
IC98351 1 SEVERE ERROR INDICATED WHILE READING LOB ALLOCATION MAP
IC96825 2 DB2 INSTANCE MIGHT CRASH WHEN USING INCORRECT TABLE DESIGNATOR VALUE FOR RID SCALAR FUNCTIONS.
IT00796 2 AN SQL STATEMENT THAT REFERENCES A CREATE GLOBAL TEMPORARY TABLEON WHICH NO RUNSTATS WAS PERFORMED MAY RESULT IN SQL901N
IC94323 2 LATCH PROTOCOL ISSUE IN ZIG ZAG JOIN EXECUTION LEADING TO DEADLATCH BETWEEN SUBAGENTS
IC98167 2 DATABASE CRASHES WHEN ATTEMPTING A DROP COMMAND THAT CONTAINS "NULLS"
IC91168 2 SQL STATEMENT MAY HANG DUE TO A DEADLATCH WHEN PROCESSING SUBSECTIONS OF A ZIG ZAG JOIN PLAN
IC96823 2 LOG FULL DURING TABLE TRUNCATION CAUSES CRITICAL ERROR AND MARKSDATABASE BAD
IT00629 2 BADPAGE OR OTHER ERRORS WHEN ACCESSING TABLES IN A TABLESPACE THAT IS BEING RESTORED OR ROLLED FORWARD
IC95009 2 IN PURESCALE ENVIRNMENT, 3-WAY DEADLATCH COULD HAPPEN IN RARE TIMING SCENARIO.
IC99072 2 ADMIN_GET_TAB_COMPRESS_INFO_V97 IS SHOWING NEGATIVE NUMBER FOR ROWS_SAMPLED FOR A LARGE TABLE
IC94695 2 SLOW CONCURRENT INSERTS INTO LARGE TABLE
IT00694 2 SQLDREPLACEROW REPORTS SQLD_BADPAGE DURING ROLL FORWARD
IC99788 2 FAILURE DURING ONLINE TABLE REORGANIZATION MIGHT LEAD TO DATABASE HANG
Fix Pack 4  -   Data Management Utilities
IC99741 2 FORCE APPLICATION OF LOAD FROM CURSOR MIGHT CAUSE LOAD TO HANG
IC95947 2 -901 IN REDISTRIBUTE ABORT AFTER SUCCESSFUL REDISTRIBUTE ABORT/CONTINUE WITH EXCLUDE KEYWORD.
IC99917 2 IMPORT MIGHT HIT SQL0304N ERROR AND REJECT ROWS CONTAINING TIMESTAMP DATA IF TIMESTAMPFORMAT IS SPECIFIED FOR ASC/DEL FILE
IT01473 2 ROLLFORWARD FAILS WITH SQL1042C / "DMS DATABASE TERMINATION: FIX COUNT != 0"
IC96098 2 REMOTE CLIENT LOAD HANGS AND COULD NOT BE KILLED
IC96870 2 DB2 DOES NOT RESPOND TO FORCE APPLICATION OR INTERRUPT REQUEST AGAINST LOAD APPLICATION
IC96951 2 INGEST UTILITY MIGHT INSERT NULLS INSTEAD OF CORRECT DATA TO NUMERIC COLUMNS WHEN INPUT FILE SIZE IS HUGE
IC94696 2 DB2 EXPORT AND DB2 IMPORT ONLY SUPPORT STATEMENTS < 32700 BYTES AGAINST NON-LUW SERVERS
IC97046 2 A LOAD COMMAND WITH LOW WARNINGCOUNT MIGHT HANG
IC98199 2 LOAD MIGHT FAIL WITH SQL2043N WHEN IT IS ABOUT TO END IN A RARE TIMING-DEPENDENT SCENARIO
IC97332 2 LOAD FROM REMOTE CURSOR (REMOTE FETCH LOAD) MAY HANG AFTER GETTING AN ERROR IN VERY EARLY PHASE
IC96873 2 ROLLFOWARD FAILURE FOR THE LOAD COPY YES INTO /DEV/NULL MAY WRONGLY LEAVE THE TABLESPACE IN NORMAL STATE
IC97127 2 POSSIBLE CRASH (SEGV/ABORT) IN SQLDFORMATLOBLONGCOL() WITH LOAD FROM CURSOR ON TABLE WITH LOB AND CODESET CONVERSION
IC98479 2 INGEST UTILITY: ERROR SQL2038N WHEN A DISTRIBUTION KEY COLUMN TYPE IS A UDT
IC93301 3 SORTS FROM SMALL INDEX BUILDS OVER-RESERVE SORT MEMORY, STMM MAYUNNECESSARILY INCREASE SORT TUNING
IC97045 3 LOAD MIGHT HANG IF INPUT DATA HAS LARGE CORRUPTED SECTION
IC97902 3 INGEST COMMAND NO LONGER RETURNS SQL3604N WHEN EXCEPTION TABLE HAS DB2SECURITYLABEL COLUMN
IC96703 3 UNDER RARE CONDITIONS, LOAD CANNOT BE FORCED OFF DURING A FORCE APPLICATION PROCESSING IN A DPF ENVIRONMENT.
Fix Pack 4  -   Data Recovery Services
IC99041 1 DIVIDE BY ZERO TRAP IN PAGE_AGE CODE IN SQLPCHECKFORBAFLSH
IC97897 1 UNEXPECTED LOCK ESCALATIONS ON DB2 PURESCALE SYSTEMS USING STMM LOCKLIST TUNING OR MANUAL DYNAMIC UPDATE OF LOCKLIST SETTING
IC98278 1 DUE TO LSN CHANGES IN PURESCALE ARCHITECTURE TOOLS USING DB2READLOG API MAY SUFFER BAD PERFORMANCE IF AN OLD LSN IS REQUESTED
IC98998 1 ROLLFORWARD TO END OF BACKUP IMAGE MIGHT FAIL DUE TO CLOCK SKEW FOR A DPF DATABASE ON MULTIPLE PHYSICAL NODES
IT00609 1 RESTART DATABASE FAILS WITH ERROR SQL1042C
IC96296 1 SLOW COMMITS WHEN STMM-MANAGED LOCKLIST GROWS INTO OVERFLOW
IT01189 1 TABLE SPACE ROLLFORWARD MIGHT NOT UNDO TRANSACTION CORRECTLY, LEAVING INCONSISTENT DATA
IC97150 1 COMPENSATION LSN AS RETURNED FROM DB2READLOG API DIFFERS FROM THE ACTUAL VALUE
IC99737 2 DATABASE MIGRATION TO V10 CAN TAKE A LONG TIME TO COMPLETE, WHILE V10 LOGFILES ARE ALLOCATED IN BACKGROUND
IC96925 2 DB2ADUTL FAILS WITH SQL1019 WHEN ACQUIRING INSTANCE CONNECTION TO DETERMINE NODE NUMBER WHEN INSTANCE NAME IS LESS THAN 8 CHARAC
IC97815 2 STANDBY MAY FAIL TO CONNECT TO PRIMARY WITHIN HADR_TIMEOUT, WHENDB2_HADR_BUF_SIZE IS SET TO A VERY LARGE VALUE
IC98629 2 ROLLFORWARD DATABASE RETURNS SQL1774N ON HADR DATABSE AFTER SNAPSHOT RESTORE AND DB2INIDB AS MIRROR
IC98861 2 SILENT SWITCH TO THE DEFAULT LOGPATH PATH
IC96738 2 DB2READLOG API WAS RETURNED SQLCODE -1273
IC96682 2 ONLINE BACKUP MIGHT BLOCK TRANSACTIONS THAT ARE DOING COMMIT.
IC99671 2 DB2 DOES NOT REMOVE OLD LOGS DURING UPGRADE IN V10
IC96876 2 IMPROVE SQL2038N ERROR MESSAGE
IC98168 2 WHEN USING DB2ADUTL DELETE OLDER THAN S00000XX.LOG COMMAND THE LOG INCLUDING S00000XX.LOG WOULD BE REMOVED.
IC97591 2 THE SPLIT SNAPSHOT FLAG IS NOT CLEARED DURING A SNAPSHOT BACKUP
IC98024 2 IN PURESCALE ENV ROLLFORWARD ON MEMBER X WON'T FETCH LOGS FROM TSM FOR OTHER MEMBERS WHEN RESTORING TO NEW DATABASE NAME
IC96297 2 ONLINE BACKUP FAILS DUE TO BAD FIRSTLOS AFTER TAKEOVER
IC96871 2 IN DPF ENVIRONMENT PRUNE WILL NOT DELETE IMAGE FROM DISK WHERE THE DATABASE PARTITION EXPRESSION $N WAS USED IN TARGET DIRECTORY
IC95901 2 DB2 ROLLFORWARD MIGHT HANG IN BACKWARD PHASE WHEN INFINITE LOGGING IS USED
IC96209 2 IN AN AUTOMATED HADR ENVIRONMENT THE TAKEOVER HADR COMMAND SUCCEEDS, BUT A MOVE REQUEST IS NOT SENT TO TSA
IC94077 2 IN XA ENVIRONMENT, DB2 TRAPS WHEN PROCESSING THE JOIN WITH CURSOR CALL
IC92741 2 ONLINE BACKUP PERFORMANCE DEGRADATION AND ABNORMAL BACKUP IMAGE FILE SIZE VARIATIONS IN V10.1
IC97548 2 RESTORE GENERATING ERRORS DUE TO COMPRESSION LIBRARY ALREADY EXISTING.
IC97550 3 HADR PRIMARY DISCONNECTS AND STANDBY SHOWS PEER STATE WHEN DISK IS FULL ON STANDBY.
IC97176 3 HADR STANDBY DB COULD RUN INTO A TRAP WHEN IT'S REMOTE DB IS ALSO A STANDBY DB
IC98575 3 DATABASE UPGRADE TO DB2 V10.X DOES NOT DELETE THE PRE-V10 DB2TSCHG.HIS FILE
IC97549 3 BACKUP LIST UTILITIES COMPLETED WORK ESTIMATE INACCURATE WHEN BACKUP-COMPRESSION ENABLED.
Fix Pack 4  -   E2E Monitoring code
IC98016 2 ALL MONITORING INFORMATION SHOWS UNDER NULL CLIENT INFO VALUES ON THE OPM EI DASHBOARD
Fix Pack 4  -   Federation
IT01598 1 FEDERATION SERVER CREATE NICKNAME COMMAND REDUCES THE LENGTH OF DBCLOB COLUMN
JR48650 2 FED:PFORMANCE ENHANCEMENT FOR ORACLE
IC95657 2 FED: UPDATE NICKNAME FAILED WITH SQL1822N WITH "HY104 INVALID PRECISION VALUE"
JR48544 2 FED:IN PREDICATE CAN NOT BE PUSHDOWN DUE TO BLANK PADDING
IC98696 2 FEDERATION SERVER QUERY RESPONSE SLOWLY EVEN IF JR47502 IS APPLIED
JR48442 2 USING SERVER OPTION DB2_REQUESTS_IO_BLOCK_BUF MAY CAUSE A DATABASE FORCED SHUTDOWN WHEN SELECT FROM NICKNAME
JR47419 2 INSERT INTO ODBC/JDBC NICKNAME FAILED WITH SQL0901N REASON "BAD COMPILER RETURN CODE"
IC97633 2 FEDERATED QUERY MAY RECEIVE SQL0418N ERROR IF FEDERATED DATABASESET STMT_CONC=LITERALS
IC96771 2 QUERIES WITH/WITHOUT PREDICATES RETURNED SAME RESULT, PUSHDOWNABLE PREDICATE IS NOT COMPOSED INTO REMOTE STATEMENT
JR49446 2 INCORRECT DATA COULD BE INSERTED INTO NICKNAME WITH AN INSERT STATEMENT HAS A PLAN WITH TQ UNDER SHIP
IC96704 2 SQL0901N ERROR WHEN CREATING NICKNAME ON NICKNAME
IC95660 2 FEDERATION SERVER MAY CRASH WHEN FORCING APP ON COOR NODE FROM NONE-COOR NODE
JR49341 2 BLOCK FETCH MAY CAUSE ENGINE CRASH WHEN DB2FMP TERMINATES ABNORMALLY
IC99650 2 DRDA WRAPPER REPORTS SQL3324N WHEN CREATING NICKNAME FOR A TABLE USES LBAC
IC98030 2 RECEIVE SQL0901N REASON "UNKNOWN TYPE" WHEN QUERYING A TERADATA NICKNAME INCLUDING HUGE NUMBER OF ROWS
JR48747 2 TIMESTAMP-TIMESTAMP PREDICATE IS NOT PUSHDOWNED WHEN USING ORACLE WRAPPER IN ORACLE MODE
IC98349 2 A QUERY WITH AN OR PREDICATE MIGHT RETURN INCORRECT RESULTS
IC98826 2 FEDERATION SERVER QUERY RESPONSE SLOWLY EVEN IF JR47502 IS APPLIED
JR48649 2 FED:PERFORMANCE ENHANCEMENT FOR PLAN HINT PUSHDOWN
IC99795 3 PUSHDOWN PERFORMANCE ISSUE DUE TO MISSING '=' FUNCTION MAPPINGS FOR DECIMAL/DECFLOAT
Fix Pack 4  -   Index Manager
IC99374 1 USING LOAD FOR MDC TABLES ON CASE INSENSITIVE DATABASES MIGHT CAUSE BLOCK INDEX CORRUPTION
IC98073 1 DEADLOCK MAY OCCUR SURROUNDING ANONYMOUS BLOCKS PACKAGES WHEN DB2ABC (APM CACHE CLEANUP) AND DDL STATEMENT RUN CONCURRENTLY.
IC95923 1 ABP DAEMON (DB2TASKD EDU) STOPPED AND NOT RESTARTED IN DPF MODE AFTER A NON-CATALOG PARTITION IS FORCED AND RESTARTED
IT00335 2 LOAD INTO MDC TABLE FAILS WITH SQL0902C OR SQL0990C
IC97306 2 INSTANCE MAY CRASH WITH ERROR (IN DB2DIAG.LOG) "ROLLOUT CB LIST IS NOT EMPTY AT TX BOUNDARY! "
IC97632 2 SAMPLED DETAILED INDEX RUNSTATS ON RANGE PARTITIONED TABLES CAN RESULT IN HIGH PRIVATE MEMORY USE AND LONG EXECUTION TIME
IC98288 2 AFTER PERFORMING AN OFFLINE REORG IN HADR ENVIRONMENT, INDEX SMSTABLESPACES HAVE DIFFERENT SIZES ON PRIMARY COMPARED TO STANDBY
IC94549 2 RUNSTATS WITH SAMPLED DETAILED INDEXES ON PARTITIONED, MDC TABLEMIGHT RESULT IN EXCESSIVE MEMORY UTILIZATION AND SQL0973N ERROR
IT00423 2 POTENTIAL INDEX CORRUPTION WHEN USING INDEX COMPRESSION AND UNICDOE DATABASES WHICH USE UCA COLLATION WITH S(STRENGTH) = 1 OR 2
Fix Pack 4  -   Install and Catalog Services
IC99752 1 LUM LIBRARY NEEDS TO BE UPDATED FOR LINUXAMD64
IC95658 2 32-BIT IBM DB2 ODBC DRIVER NOT ENABLED FOR CONNECTION POOLING, ON 64-BIT WINDOWS INSTALL
IC96294 2 SQL0901N REASON "COLUMN NUMBER OUT OF RANGE" WHEN SELECTING FROMTABLES RELATED VIA FOREIGN KEY, AFTER ALTER DROP COLUMN
IC97792 2 DROP ROLE COMMAND CAUSES A SQLOSPINLOCKCONFLICT IN SQLRLC_ROLECACHE.C AND SQLRLC_INLINES.H FUNCTIONS AND LOCKING ABOUT 52 APPLIC
IC96218 2 RENAME TABLESPACE NOT HANDLING ERROR DURING SYSTEM CATALOG UPDATE AND LEAVING ORPHAN ROW(S)
IC99289 2 POSSIBLE CACHE CORRUPTION(SEGV/CRASH): ENTRY CAN BE FREED BY ONETHREAD AND ADDED TO LRU BY ANOTHER AT THE SAME TIME
JR49622 2 NNSTAT MAY FAIL WITH SQL0181N/SQL0180N ERROR WITH METHOD 0 OR 1
IC96837 2 DB2UPDV10 RETURN ERROR: SYSDEBUGPRIVATE, -204
IC97143 2 DATABASE UPGRADE FAILS WITH SQL20481N
IC97260 2 DATABASE UPGRADE TO DB2 V10 MAY TRAP WITH SEGMENTATION VIOLATIONIN FUNCTION SQLRLM_CHECKMIGRATEFLAG
IC99281 2 WHILE ADDING A NEW MEMBER/CF OR NETNAME TO A MEMBER/CF YOU MAY GET THIS ERROR " RSCT PEER DOMAIN IS ONLINE "
IC99536 2 ALTER TABLESPACE PREFETCH SIZE ON TABLEPSAPCES WITH MANY OBJECTSFLOODS CATALOG CACHE
IC95588 2 UPGRADE DATABASE MAY TAKE LONG IN DPF ENVIRONMENT DUE TO DYNAMICSTATEMENT CACHE INVALIDATION
IC98832 2 DATABASE MIGRATION FROM V9.8 PURESCALE ENV. TO V10.5 MAY TRAP WITH SQL1224N ERROR.
IC96686 2 DB2 WSE : DB2LICM -G OUTPUT SHOULD DISPLAY A VIOLATION WHEN COMPRESSION IS USED
IC97598 2 AFTER LOGS BECOME FULL, AN INSERT INTO A GLOBAL TEMPORARY TABLE (DGTT) FAILS WITH SQL0901N
IC97826 2 LDAP LIBRARIES ARE MISSING AFTER AN INSTALLATION DONE WITH A RESPONSE FILE GENERATED BY DB2RSPGN
IC97876 2 DURING VIEW REGENERATION , DROPPING OF STATISTICS DON'T SET STATISTICS_PROFILE COLUMN OF SYSTABLES CATALOG TABLE TO NULL.
IC99857 2 DB2IUPDT FAILS FOR DPF ENV WHEN VIRTUAL IPS ARE USED
IC97163 2 SQL1499W WHEN UPGRADING DATABASE
IC99006 3 ALTER INDEX ON TABLE CORRUPTS AUDIT LOG FILE
IC96901 3 DB2CFEXP DOES NOT EXPORT SOME DATABASE MANAGER CONFIG PARAMETERS.
IC92907 3 DB2PREREQCHECK MAY PRINT OUT UNNECESSARY QUOTES.
IC97302 3 DB2ICRT COMMAND SKIPS SOME OPEN PORTS RANGE IN /ETC/SERVICES DURING FCM PORTS RESERVATION
IC98154 3 USABILITY: INSTANCE CREATION, UPGRADE, UPDATE HARD FAILS IF IT IS NOT ABLE TO RESERVE 4 PORTS IN /ETC/SERVICES FOR AN ESEINSTAN
IC98881 3 DB2SETUP WILL UPDATE SVCENAME WITH PORTNUMBER INSTEAD OF SERVICENAME.
IC96687 3 DURING SILENT INSTALLATION OF DB2 RUNTIME CLIENT, IF CREATE_ICONIS SET TO NO, DB2.EXE IS NOT INSTALLED.
IC96705 3 IMPLEMENTATION FIELD IN SYSCAT.ROUTINES FOR A SOURCED FUNCTION MISSING MODULE NAME
IC99322 3 DB2 NOT REGISTERED AS THE DEFAULT COPY WHEN IT IS THE ONLY COPY AND DEFAULT_COPY=NO & DEFAULT_CLIENT_INTERFACE_COPY=NO
Fix Pack 4  -   JDBC Driver
IT02967 3 TO DOCUMENT ALL THE JCC APAR AND DEFECTS SHIPPED WITH  DB2  V10.1FP4 RELEASE
IC99026 2 JCC PROPERTIES SUCH AS CURRENTSCHEMA ARE SOMETIMES IGNORED. A POSSIBLE SYMPTOM IS AN SQLEXCEPTION WITH SQLCODE=-204
IT02676 2 CONNECTION.ISVALID(INT TIMEOUT) API DOES NOT WORK UNEXPECTEDLY
IC97033 2 WHEN USING XADATASOURCE WITH ENABLESYSPLEXWLB=TRUE, A GRADUALAND PERMANENT GROWTH IN TRANSPORT OBJECTS MAY OCCUR
IC98295 2 XAER_PROTO. ERRORCODE=-4203, ERROR RETURNED WHEN FIRST QUERYFAILS IN AN TRANSACTION
IC94489 3 EXECUTEBATCH FAILS IF ONE OF THE STRING COLUMN IS SET USING SETDBSTRINGASBYTES WITH SQLCODE = -302
Fix Pack 4  -   Monitoring
IC95740 2 DB2 INSTANCE MIGHT TRAP IN SQMAGENTRTNSTACK::GETRTNCTXFORSND() WHILE CONSTRUCTING THE ROUTINE CONTEXT INFORMATION.
IC98138 2 GLOBAL LOCK SNAPSHOT CAN TRAP WHEN INDOUBT TRANSACTIONS ARE PRESENT IN A DPF ENVIRONMENT
IC97824 2 ADMIN_MOVE_TABLE DOESN'T RECREATE THE SECURITY LABEL ON A COLUMN
IC96688 2 LOOP IN EXPLAINREADACTUALSFROMACTEVMON() CALLED BY SYSPROC.EXPLAIN_FROM_ACTIVITY()
IC96030 2 SYSTEM APPLICATIONS INVOLVED IN A LOCKING EVENT ONLY SHOW UP AS PARTIAL EVENTS.
IC97983 2 ADMIN_MOVE_TABLE FAILED WITH SQL0104N IF THE SOURCE TABLE HAS NOINDEX AND THE 1ST COLUMN SIZE EXCEEDS THE MAX KEY LENGTH LIMIT
IC96022 2 POTENTIAL HANG ON TRANENTRY LATCH IN SQLPM_WRITE_APPL_LOCKS DURING LOCK SNAPSHOT
IC99906 3 ADM2017C MAY BE OCURRED EVEN IF FILESYSTEM HAS ENOUGH ROOM.
IC98017 3 IF A TABLE HAS DB2SECURITYLABEL COLUMN, ADMIN_MOVE_TABLE FAILED WITH SQL0683N.
IC98282 3 ON SOME RARE OCASIONS, LOCKING EVENT MONITOR MIGHT FAIL TO REPORT ALL PARTICIPANTS OF A DEADLOCK
IC99580 3 RUNNING ADMIN_MOVE_TABLE TWICE DOES NOT SET GENERATE ALWAYS AS IDENTITY VALUES CORRECTLY
IC97066 3 DBSUMMARY() METRICS BREAKDOWN MAY REPORT INACCURATE VALUES FOR POOL_READ_TIME OR POOL_WRITE_TIME COMPARED TO TOTAL_WAIT_TIME
IC97547 3 ADMIN_MOVE_TABLE DOES NOT PROVIDE CORRESPONDING LOAD OPTION "TEMPFILES PATH"
IC95655 3 WHEN USING ADMIN_MOVE_TABLE, THE STAGING AND TARGET TABLE IS NOTCLEANED DURING THE CANCEL OPERATION WHEN INIT PHASE FAILS.
IC97877 3 WHEN USING ADMIN_MOVE_TABLE WITH COPY_STATS OPTION ON SWAP PHASE, IT COULD FAILS WITH SQL2102N, REASON CODE 28.
Fix Pack 4  -   Parsing and SQL PL
IC97043 2 SQL20046N USING STORED PROCEDURES
IC95790 2 CALLING A SQL STORED PROCEDURE AFTER MIGRATION FAILS WITH EITHERAN SQL1224 OR SQL0471 ERROR IT MAY ALSO TRAP
IC97333 3 DYNAMIC STATEMENT NOT FOUND IN STATEMENT CACHE AND RECOMPILED UNNECESSARILY RESULTING IN POOR RUN TIME PERFORMANCE
IC96291 3 USER-DEFINED CONDITIONS IF DEFINED IN MODULES MIGHT NOT FUNCTIONCORRECTLY, IF DB CONTAINS 10000+ ENTRIES IN SYSIBM.SYSVARIABLES
Fix Pack 4  -   Platform Specific
IC98177 1 HANG AFTER LOG ARCHIVE
IC99076 1 DB2AIOTHR SEEMS TO STUCK IN THE SOLARIS KERNEL
IT01393 2 A HANG RELATED TO STMM MAY BE ENCOUNTERED SHOULD AN INTERNAL COUNTER TRACKING SHARED SORT HEAP PAGES BECOME NEGATIVE.
IC91295 2 POSSIBLE HIGH CPU USAGE OF FUNCTION STMMPCFINDSIMVAR UNDER VERY HIGH WORKLOAD
IT00726 2 AN ATTEMPT TO ATTACH LOCAL NODE BY DATA SERVER CLIENT MIGHT THROW SQL1032N.
IC94330 2 MEMBER FAILED TO START ON HOME HOST DUE TO SQL1677N ERROR
IC98699 2 INSTANCE ABEND IN DB2STMM WHEN EVALUATING SCALAR AGGREGATE OPERATORS.
IC98883 2 DB2 CACHES GROUP MEMBERSHIP OF LOCALSYSTEM (SYSTEM) UNTIL NEXT INSTANCE RECYCLING.
IT01182 2 SETTING DB2PATH MAY CAUSE FAILURE TO START THE INSTANCE
IC98332 2 CURRENT TIMEZONE SPECIAL REGISTER MAY GIVE WRONG RESULT ON SUN PLATFORM BEING ACCESSED CONCURRENTLY.
IC97733 2 DB2START RETURNS SQL6030N START OR STOP DATABASE MANAGER FAILED. REASON CODE "4".
IC94989 2 GETTING PASSWORD EXPIRED WHEN USING TRANSPARENT LDAP WITH KERBEROS
IC95654 2 SQL30082N RC=24 ERROR MAY OCCUR USING PAM_KRB5.SO WITH TRANSPARENT LDAP
IC98933 3 RUNSTATS COMMAND CAN POTENTIALLY HANG IF RUN WITH UTIL_IMPACT_PRIORITY CLAUSE.
IC97825 3 DB2OSCONF DOES NOT SHOW SEMUME IN HP-UX.
IC96987 3 SAP - REMOVE STMM PACKAGE CACHE CAP LIMIT FROM DB2_WORKLOAD=SAP
IC97748 3 DB2INSTDEF IS SET BY DEFAULT DURING INSTANCE CREATION EVEN IF NON-WINDOWS PLATFORMS.
IC94231 3 SQL1042C / ECF_FILE_DEVICE_UNAVAILABLE ERROR CONNECTING TO DATABASE WITH SERVER_ENCRYPT AUTHENTICATION
IC96756 3 MEMORY LEAK POSSIBLE ON WINDOWS IF A WINDOWS PERFORMANCE API FUNCTION RETURNS AN UNEXPECTED RETURN CODE
IC96666 3 LOAD FROM CURSOR MAY ACCUMULATE WINDOWS EVENT HANDLES OVER TIME
IC98002 3 INDEX CREATION ON A SMS TABLESPACE DUMPS FULL STACK IN DB2DIAG.LOG AS AN EVENT
IC95659 3 STMM ON 32-BIT INSTANCE PLATFORM MAY FAIL TO UPDATE PCKCACHESZ WHEN IT IS WORKING ON 64-BIT WINDOWS
IC97285 3 ON SOLARIS, ONCE DIO IS ENABLED THERE IS NO WAY DISABLE IT WITHIN DB2.
IC96872 3 IF THE DB2SYSC PROCESS DEPLETES THE PROCESS HEAP AN ATTEMPT TO ALLOCATE ADDITIONAL MEMORY MIGHT LEAD TO A PROCESS TRAP.
IC97875 3 CONTAINER RESIZE BEYOND 16 TB DOES NOT FAIL AND CAUSES UNEXPECTED RESULTS.
IC96875 3 IN A DPF, IF AGENTPRI IS CHANGED, DB2START GETS SQL1042C AND DB2INSTANCE CAN'T START.
Fix Pack 4  -   Problem Determination
IC98864 2 DB2TRC BUFFER ALLOCATION
IC98524 2 DB2PD -MEMBLOCK PID=<DB2SYSC PID> MAY FAIL WITH PDPROCGETMEMMAP RC = 1
IC97501 2 INSPECT UTILITY DOES NOT REPORT PAGES THAT HAVE A INCORRECT CHECK SUM
IC99774 2 DB2TOP GRANULARITY IN BACKGROUND MODE FOR DATABASE METRICS
IC99528 2 SEVERE WLMTABLEFUNCTIONMERGED MESSAGES AGAINST RUNNING OF PD_GET_DIAG_HIST TABLE FUNCTION
IC94545 2 IN SOME CASES CALLING 'USER-SPECIFIED PROFILE' FROM DB2SUPPORT MAY CAUSE SCRIPT TIME-OUT REGARDLESS OF THE SETTING OF 'TIMEOUT'.
IC96921 2 PD_GET_LOG_MSGS TABLE FUNCTION 'TIMESTAMP' PARAMETER ACTS AS IF ONLY NULL IS PASSED
IC97386 2 PD_GET_DIAG_HIST() TABLE FUNCTION WITH GIVEN TIMESTAMP PARAMETERS OR DB2DIAG TOOL WITH -H OR -T OPTION MAY HANG.
IC90716 2 IN SOME RARE CIRCUMSTANCES THE PD_GET_DIAG_HIST() TABLE FUNCTIONMAY HANG.
IC97756 2 OPTIMIZER DB2SUPPORT COLLECTION IS NOT SUCCESSFUL
IT00302 2 DB2SUPPORT WRONGLY ASSUMES SHARED PATH IF DB2DIAGPATH IS NOT SPLIT AND HAS THE SAME VALUE ON MULTIPLE NODES
IC95703 2 DB2PD -STACK ALL OR DB2PD -DUMP ALL MAY CRASH THE INSTANCE WITH SIGNAL 11.
IC96839 2 CALLING PD_GET_DIAG_HIST IN DB2 V10.1 FP3 ON PLATFORM WINDOWS RESULTS IN AN ERROR
IC98020 2 DB2DART CRASH IN MEMORY VALIDATION
IC99804 2 CRASH IN DB2TOP COLLECTOR MODE WHEN COMPRESSING THE SNAPSHOT DATA
IC98108 3 DB2PD -DBP NUMBER -EVERYTHING RETURNED "INVALID -DBP SUBOPTION. PROVIDE DATABASE PARTITION NUMBER."
IC99539 3 DB2TOP IN BACKGROUND REPLAY MODE IGNORES THE FIRST SNAPSHOT STREAM DATA
IC96862 3 DB2SUPPORT DOES NOT COLLECT DB2DIAG.LOG ON WINDOWS WHEN $M IS USED IN DIAGPATH
IC96592 3 ON WINDOWS, AN ADMIN MESSAGE MAY BE LOGGED IN DB2DIAG.LOG AND WINDOWS EVENT LOG WITH DIFFERENT LEVEL
IC96246 3 A LOCK ON THE NOTIFY LOG OR DB2DIAG.LOG CAN MAKE THE ENGINE SO SLOW THAT IT WOULD LOOK LIKE A HANG
IC99191 3 DB2CAEM FAILS IF THE SQL INPUT CONTAINS A COMMENT "--" WHICH IS NOT AT THE START OF A LINE
IC96689 3 A LOCK ON THE NOTIFY LOG OR DB2DIAG.LOG CAN MAKE THE ENGINE SO SLOW THAT IT WOULD LOOK LIKE A HANG
IC96701 3 DB2PD -REORG ON HADR STANDY TRAPS WHEN THE TABLE NAME OR SCHEMA HAS NOT BEEN ALLOCATED WITHIN THE TCB
Fix Pack 4  -   Process Model
IC95792 1 DB2HAICU INCORRECTLY REPORTS AN IP ADDRESS AS ALIVE WHEN IT IS NOT.
IC99747 1 DB2 STORED PROCEDURES ARE UNABLE TO LOAD THE GSKIT SHIPPED WITH DB2
IC98312 2 IN LOW OR NO MEMORY CONDITIONS DB2 MAY TRAP IN SQLRR_SQL_REQUEST_PRE
IC99932 2 DATABASE REMAINS IN QUIESCE STATE AFTER INSTANCE UNQUIESCED
IC99903 2 DB2IUPGRADE FAILURE WHEN DB2NODES.CFG CONTAINS VIRTUAL IP ADDRESSES
IC97822 2 DB2 MAY TRAP IN SQLECLEANUPFEDDAEMONANCHOR DURING MULTIPLE LOGICAL NODES STARTUP
IC94868 2 COORDINATOR AGENT MAY HANG WITH PENDING REMOTE REQUEST STATUS DUE TO DISCARDED BUFFER.
IC92291 2 RE-CREATING A PREVIOUSLY DROPPED DATABASE WITH DIFFERENT PATH MAY FAIL WITH SQL1031N
IC98289 2 INSTANCE MAY CRASH IN SQLOCRASHONCRITICALMEMORYVALIDATIONFAILURE
IT00907 2 SQL1052 WHEN DROPPING A DATABASE IN DPF ENVIRONMENT USING RELATIVE PATHS OR SOFTLINKS
IC97832 2 THE DB2 REGISTRY VARIABLE DB2_MAX_THREADS_PER_FMP MAY NOT WORK IN A FEDERATION ENVIRONMENT.
IC98913 2 TRAP OR HANG WHEN LDAP DIRECTORY ENTRIES FOR A DB2 DATABASE ARE INCONSISTENT.
IC97518 2 DB2 INTERMITTENTLY CRASHES WITH A MEMORY CORRUPTION WHEN CALLINGSQLERGETFMPIPC
IC99231 2 DEADLATCH BETWEEN INSTANCE QUIESCE AND HADR START DUE TO LATCHING ORDER
IC96702 2 UPDATING LOGARCHMETH1 DATABASE CONFIGURATION PARAMETER WHILE A DATABASE IS BEING ACTIVATED CAN CAUSE DB2 TO HANG
IT01368 2 TRAPS AND/OR CRASHES IN DPF DURING QUERY ACTIVITY AGAINST A DB THAT WAS PREVIOUSLY CREATED WITH A REDIRECTED RESTORE
IT00763 3 INCORRECT WARNING SQL1363W RAISED WHEN UPDATING A DB CFG PARAMETER ON INACTIVE DATABASE
IT00385 3 DROP DATABASE FAILS WITH: SQL0969N THERE IS NO MESSAGE TEXT CORRESPONDING TO SQL ERROR -2029060079"
IC95142 3 UPGRADE FROM DOWNLEVEL PERMITS OTHER CONNECTION FROM SAME USER PERFORMING UPGRADE TO CONNECT AND CRASH THE SERVER.
IC98511 3 MAKE CERTAIN SQLERINVOKEFENCEDROUTINE AND SQLERRETURNFMPTOPOOL MESSAGES IN DB2DIAG.LOG WARNING INSTEAD OF ERROR OR SEVERE
IC96909 3 IT IS POSSIBLE TO CATALOG A DATABASE WITHOUT A DB NAME OR ALIAS WHEN CREATING AN ODBC DSN IN MICROSOFT ODBC ADMINISTRATOR
Fix Pack 4  -   Query Compiler Optimizer
IC99629 1 PD CORRUPTION ON TABLE AFTER ALTER TABLE ADD OR REMOVE A COLUMN WHEN RTS IS ENABLED
IC99818 1 SQL STATEMENT WITH UNCORRELATED SUBQUERY PREDICATE MIGHT RETURN INCORRECT RESULTS WHEN INTRA_PARALLEL IS ENABLED
IC98311 1 DB2 CAN TRAP WHEN COMPILING A SQL STATEMENT THAT FITS THE CRITERIA FOR ZIGZAG JOIN
IT00482 2 DB2 OPTIMIZER CAN CHOOSE A NON-OPTIMAL BLOCK INDEX TO ACCESS MDCTABLE WHEN THE BLOCK INDEXES HAVE ONLY 1 LEVEL
IC96375 2 DB2 INSTANCE MAY TRAP WITH SIGNAL#11 WITH FUNCTION SQLNX_EXP_DUMP_DIAG_CACHE.
IC98179 2 WHEN INTRA_PARALLEL ENABLED, AN SQL STATEMENT MIGHT FAIL WITH SQL0901N IN SQLNO_SMP_CREATE_PGBY
IC96999 2 DB2 NOT GENERATING TBSCAN ON INNER OF NLJN WHEN OUTER CAN HAVE ONLY 1 ROW
IC99319 2 SQL STATEMENT WITH ORDERED COLUMN GROUP OR PREDICATES MIGHT RETURN INCORRECT RESULT SET WHEN JUMP SCAN USED
IC97297 2 OPTIMIZER COMPUTES INCORRECT CARDINALITY ESTIMATE IN PRESENCE OFSTATISTICAL VIEW WITH A PREDICATE THAT HAS AN EXPRESSION
IC98822 2 RUNSTATS PROFILE DOESN'T ALLOW TO EXCLUDE COLUMNS FROM DISTRIBUTION STATISTICS COLLECTION (NUM_FREQVALUES OR NUM_QUANTILES = 0)
IC98761 2 COMPILING A SQL STATEMENT CAN RETURN SQL0901N WITH REASON "TOO MANY COLUMNS OR RECORD LENGTH EXCEEDED."
JR49140 2 FED: ROWNUM OR FETCH FIRST N ROW CLAUSE COULD NOT BE PUSHED DOWN
IC97823 2 RUNNING DB2ADVIS TO RECOMMEND DPF PARTITIONING IN ORACLE COMPATIBILITY MODE CAN CAUSE DB2 TO TRAP
IC99408 2 THE SQL0437W MIGHT BE INDUCED BY RUNSTATS RESULTING IN INCORRECTCOLCARD VALUE
IC99521 2 DB2ADVIS MAY HANG ON DATABASE THAT ENABLES DATE AS TIMESTAMP (0)SUPPORT
IC97570 2 DB2 OPTIMIZER MAY CHOOSE TO DEFER PROCESSING DISTINCT CLAUSE OF A UNION-BRANCH
IC98806 2 QUERY MAY PERFORM BAD WHEN CONTAINS OR SCORE FUNCTIONS ARE USED WITH VARIABLES IN THE SEARCH STRING AND REOPT ONCE IS SPECIFIED
JR48968 2 PERFORMANCE COULD BE POOR WHEN A SMALL NICKNAME JOINS A LARGE NICKNAME JOIN RESULT
IC98769 2 DB2 OPTIMIZER MAY USE FREQUENCY VALCOUNT IN SYSSTAT.COLDIST INCORRECTLY AND GIVE SUB-OPTIMIAL ACCESS PLAN.
IC98320 2 DB2 MIGHT TRAP WHILE COMPILING A SQL STATEMENT CONSISTING OF MULTIPLE TABLES JOINED ON THE PARTITION BY RANGE COLUMNS
IC99102 2 AN SQL STATEMENT JOINING A TABLE TO A VALUES CLAUSE MIGHT RESULTIN SUBOPTIMAL PERFORMANCE
IC94959 2 ATM FAILED TO REORG SOME INDEXES WHICH EXCEEDED F4 AND F5 UNDER DB2_WORKLOAD=SAP
JR49139 2 FED: HANG, CRASH OR -901 WITH MEMORY DOUBLE FREE MESSAGE COULD OCCUR WHEN FUNCTION TEMPLATE IS USED
IC97715 2 DB2 MIGHT TRAP WHILE COMPILING A SQL STATEMENT THAT IS ELIGIBLE FOR ZIGZAG JOIN
IC96894 2 DB2 MIGHT TRAP WHILE COMPILING A SQL STATEMENT WITH A DISTINCT CLAUSE WHEN INTRA-PARTITION PARALLELISM IS ENABLED
IC99860 2 POSSIBLE WRONG RESULTS WHEN INDEX JUMP SCANS ARE USED IN REFERENTIAL INTEGRITY CHECKING
IC97984 2 OPTIMIZER MIGHT FAVOUR HSJOIN OVER AN ORDERED NLJOIN
IC94258 2 DELETE QUERY FAILS WITH -901 ERROR "EMPTY PLAN LIST DETECTED!"
IC97505 2 DB2ACD PROCESS CAN ABEND WHEN IT PROCESSES FEDERATED TABLES FOR AUTOMATIC RUNSTATS.
IC97044 2 DB2 MIGHT ABEND WHILE COMPILING SQL QUERY.
IC95716 3 SQL0901 REASON "ORDER COLS REMOVED FROM SORT OUTPUT COLS." WITH DB2_WORKLOAD=PUREDATA_OLAP
IC97808 3 QUERIES INVOLVING ZIGZAG JOIN MAY GET UNEXPECTED SQL0811N ERROR
IC96826 3 DB2 OPTIMIZER MIGHT NOT CHOOSE A ONE-FETCH GROUP BY WHEN CARDINALITY IS UNDERESTIMATED
IC98550 3 COLLECTING INDEX-ONLY STATISTICS CAN INCORRECTLY UPDATE SYSCAT.COLUMNS.NQUANTILES AND SYSCAT.COLUMNS.NMOSTFREQ TO -1.
Fix Pack 4  -   Query Compiler QGM
IC97737 1 SECURITY: QUERY WITH OLAP SPECIFICATION CAUSES DB2 SERVER TO SHUTDOWN DATABASE. (CVE-2013-6717)
IT00386 1 SQL QUERY CONTAINS NOT EXISTS SUBQUERY AND NODENUMBER PREDICATE MIGHT PRODUCE AN INCORRECT RESULT
IC96725 1 CASE EXPRESSION PREDICATES MIGHT BE INCORRECTLY REWRITTEN IN DB2V10.1 FIXPACK 3
IC98176 1 OUTER JOIN QUERIES WITH COMPLEX OPERANDS MAY EXPERIENCE POOR PERFORMANCE
IC99125 1 IMPROVE QUERY PERFORMANCE WHEN QUERY CONTAINS CARTESIAN JOIN OVER SELECT DISTINCT FROM ALIAS
IC98902 1 DB2 MIGHT PRODUCE INCORRECT RESULTS FOR QUERY WITH MULTIPLE QUANTIFIED SUBQUERIES IN OR PREDICATE
IT01197 2 QUERY MIGHT HAVE OR PREDICATE WRONGLY REMOVED RESULTING IN EXTRAROWS IN THE RESULTS
IC96963 2 SQL20208N RC=4 WHEN DECLARING A GLOBAL TEMPORARY TABLE BASED ON MULTIPLE TABLES WITH DIFFERENT SECURITY POLICIES
IC90465 2 PERFORMANCE DEGRADATION MIGHT BE NOTICED WITH NOT EXISTS SUBQUERY WITH MULTIPLE TABLES.
IT00414 2 DB2 MIGHT RETURN EXTRA ROWS WHEN AN EQUAL JOIN PREDICATE ON COLUMNS INVOLVES NON-CAST EXPRESSIONS.
IT00617 2 QUERY CONTAINING CONSTANT BEFORE OLAP FUNCTION MAY FAIL WITH -901: UNEXPECTED NULL ZVALUE OR ABEND WITH SEGV IN SQLRISET
IC97582 2 SOME COMPILER REGISTRY VARIABLES MAY NOT TAKE EFFECT IMMEDIATELYWHEN UPDATED WITH THE IMMEDIATE OPTION
IC99842 2 SQLSTATE 01503 WARNING RETURNED AFTER FETCH TO ANCHORED ROW TYPEGLOBAL VARIABLE
IC98336 2 INTERNAL ERROR SQL0901N WITH NOT IN PREDICATE
IC98084 2 DATABASE MAY CRASH WHEN A REPLICATED MQT IS ENFORCED
IC98953 2 COMPILING A QUERY CAN ABEND WHEN A TABLE IN THE QUERY HAS CGS, AND IF RTS UPDATES THE TABLE'S STATISTICS DURING COMPILATION.
IC99415 2 DB2 MIGHT PRODUCE INCORRECT RESULTS WHEN EXECUTING QUERY WITH MULTIPLE "IN" LIST PREDICATES ON SAME COLUMN
IC99601 2 DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING NOT IN QUERY WITH CORRELATED SUBSELECT
IC94256 2 CREATE FUCNTION FAILS WITH SQL0109 WHEN QUERY INCLUDES "WITH UR"
IC98129 2 POSSIBLE INCORRECT RESULT ON MULTIPLE OUTER JOINS AND A COMBINATION OF EQUALITY JOIN PREDICATES AND LOCAL PREDICATES
IC98379 2 BUILT-IN STRING FUNCTIONS MAY RETURN AN INCORRECT RESULT OR FAILWITH SQL0901N WHEN CODEUNITS16 OR CODEUNITS32 IS SPECIFIED
IC97001 2 MQT NOT CONSIDERED FOR REWRITE MATCHING IN INSENSITIVE SCROLLABLE CURSOR QUERIES
IC99461 2 ADJUST FILTER FACTOR FOR RCAC'S VERIFY_* FUNCTIONS LIKE VERIFY_ROLE_FOR_USER()
JR48099 2 QUERIES CONTAINING FUNCTION TEMPLATE IN FEDERATED ENVIRONMENT MAY RETURN SQL0142N
IC98772 2 QUERIES USING THE XMLSERIALIZE FUNCTION MAY NOT BENEFIT FROM THESTATEMENT CONCENTRATOR
IC97862 2 ERROR CODE -901 WHILE EXECUTING A SELECT STATEMENT - MESSAGE "COLUMN NUMBER OUT OF RANGE "
IC98694 2 A VALUE ASSIGNMENT FROM ARRAY OF ROW DATA TYPE TO ROW DATA TYPE MIGHT CAUSE AN INSTANCE CRASH.
IC99901 2 SELECT INTO GLOBAL VARIABLE WITH 'FOR UPDATE' SPECIFIED RETURNS SQL0151N ERROR
IC97072 2 DB2 MIGHT PRODUCE INCORRECT RESULTS FOR QUERIES CONTAINING UNIONALL AND CTE OR VIEWS
IC98655 2 SUBQUERIES REFERENCING AN ALWAYS FALSE PREDICATE MIGHT NOTICE BAD PERFORMANCE
IC94727 2 USING ADMIN_MOVE_TABLE ON TABLE WITH GENERATED COLUMN REFERENCEDBY MDC KEY RESULTS IN SQL20209N
IC99490 2 DB2 MIGHT PRODUCE SQL0551N WHEN CREATING A COMPILED ROUTINE OR TRIGGER REFERENCING DGTT
IC97491 2 DATE PARAMETER MARKER IS NOT CONVERTED TO TIMESTAMP(0) IN A DATEAS TIMESTAMP(0) ENABLED DATABASE WITH DEFERRED PREPARE ENABLED
IC99128 2 DB2 MAY TRAP IF AGGREGATE FUNCTION NAME IS USED AS AN ARGUMENT TO NESTED PROCEDURE CALL STATEMENT
IC96677 2 SET INTEGRITY IMMEDIATE UNCHECKED FAILED WITH SQL20209N IF THE PARTITIONING KEY CONTAINS GENERATED COLUMN
IC98170 2 MERGE COMMAND WITH INSERT IN XML COLUMN RETURN ERROR SQL16084N
IC96698 2 -901 WITH "NO COLUMN INFORMATION FOUND IN THE PACKED DESCRIPTOR" ON CREATE PROCEDURE
IC99862 2 SQL0901N REASON "SQLNQ_PSM_SEM_ACT" FROM PL/SQL ROUTINE WITH FOR-LOOP CURSOR OVER A JOIN OF MULTIPLE COMMON TABLE EXPRESSIONS
IC96822 2 QUERY WITH TABLES FUNCTIONS AND EXISTENTIAL SUBQUERY MIGHT PRODUCE SQL0901N
IC94039 2 SQL20454N RC =2 WHEN OUTER JOIN OPERATOR "(+)" IS USED IN A CURSOR WHICH IS DECLARED IN A PACKAGE
IC96050 2 A QUERY MAY HANG WHEN IT CONTAINS CONNECT BY AND LEFT OUTER JOIN
IC96681 2 SQL FUNCTION CONTAINING XML ARGUMENTS MIGHT CAUSE DB ABEND
IC95625 2 DB2 MAY ABEND WHILE COMPILING QUERY WITH ALWAYS FALSE PREDICATE AT LEFT OUTER JOIN ON CLAUSE
IC94331 2 CREATE FUNCTION FAILS WITH SQL0109 WHEN QUERY INCLUDES "WITH UR"
IT01100 2 CHAR(' ',0) RETURNS EMPTY STRING INSTEAD OF NULL IN VARCHAR2 ENABLED DATABASE.
IC96437 2 MERGE STATEMENT RETURNS SQL0901N ("COLUMN NUMBER OUT OF RANGE")
IC96268 2 IN A FEDERATION SYSTEM, AN UPDATE/DELETE STATEMENT DOES NOT APPLY THE PREDICATES CONTAINING FUNCTION TEMPLATES
IC97915 2 QUERY MAY RETURN INCORRECT RESULTS WHEN IT CONTAINS A SUB-SELECTWITH CORRELATION AND A FETCH FIRST N ROWS CLAUSE
IC96299 2 MQT OR STATISTICAL VIEW MAY BE NOT MATCHED OR IMPROPERLY MATCHED
IT00514 2 DB2 CRASHES ON RUNSTATS WITH SQLDINDEXSTATS 'NO COLSTAT STRUCTURE FOUND FOR INDEX WITH ITOKEN' IN DB2DIAG.LOG
IC99096 2 QUERY PERFORMANCE MAY BE POOR IN A FEDERATED DPF ENVIRONMENT FOR QUERIES INVOLVING THE LATERAL KEYWORD IN THE STATEMENT TEXT
IT01073 2 INCORRECT RESULTS MIGHT BE PRODUCED WITH PREDICATES INVOLVING NULL CONSTANTS
IC94117 2 UPDATE A NICKNAME WITH MORE THAN 1012 COLUMNS MAY RESULT IN SQL0901N
IC87186 3 QUERY CONTAINING DUPLICATE BRANCHES MIGHT CAUSE PERFORMANCE DEGRADATION
IC89970 3 SQL0901N WHEN INSERTING INTO TABLE WITH A TRIGGER CALLING MQ UDF
IC89047 3 GET DIAGNOSTICS RETURNS SQL0401N WHEN ROW_COUNT VARIABLE IS DECLARED AS DECIMAL
IC96295 3 QUERY COMPILATION SHOULD RETURN SQL0418N IF IT HAS UNTYPED GROUPING SETS COLUMN
IC90466 3 UDI QUERY MIGHT PRODUCE SQL0901N WHEN EXTENDED INDICATOR OPTION IS ON
IC97348 3 IN A RARE SCENARIO, REPLICATED MQTS ARE NOT EXPLOITED TO IMPROVEPERFORMANCE OF QUERIES
IC96707 3 SQL0901N WHEN INSERTING INTO TABLE WITH A TRIGGER CALLING MQ UDF
IC97757 3 QUERY PERFORMANCE ISSUE DUE TO STATISTICS PREVENTING PUSHDOWN OFJOINS
IC96967 3 SQL ROUTINES THAT USE THE SAME VARIABLE FOR BOTH THE IN AND OUT PARAMETERS MAY RETURN NULL
IC96290 3 SQL0153N INSTEAD OF SQL0783N ERROR IS RETURNED , IF DECLARE CURSOR OF FOR STATEMENT HAS UNNAMED COLUMN.
Fix Pack 4  -   Relational Data Services
IC98741 1 IN DB2 10.1, BURST OF DIA8039C/ SQLP_PROTO MAY BE SEEN AFTER DEADLOCK, WHERE AN ARRAY INSERT IS PART OF THE DEADLOCK CYCLE
IC96700 2 DB2 TRAPS WHEN DB2EXPLN TRYS TO DESCRIBE THE ACCESS PLAN OF A SQL THAT DOESN'T EXIST WITH "-CACHE" OPTION
IT01399 2 DATABASE IS MARKED BAD DUE TO "NO ACTIVE SAVE POINT" ERROR FOR MISHANDLING SAVE POINT WHEN THERE IS AN INTERRUPT.
IC97283 2 THE REBIND COMMAND FAILED WITH SQL0901N ERROR.
IC98072 2 FALSE SQL0901N WITHIN QUERY COMPILER
IC96821 2 QUERIES USING ORDER BY CLAUSE MAY FAIL WITH SQL1585N ON THE HADRSTANDBY SERVER(READS ON STANDBY ENABLED)
IC96699 2 INSTANCE MIGHT TRAP WHILE EXECUTING PL/SQL ANONYMOUS BLOCK STATEMENT IF ADDRESS CONNECTION IS USED FOR WORKLOAD ASSIGNMENT
IC99772 2 TRAILING SPACES ON PACKAGE IDENTIFIERS ARE NOT IGNORED, WHICH MIGHT LEAD TO -901 ERROR: SECTION LENGTH MISMATCH
IC98196 2 ANONYMOUS BLOCK FAILS WITH SQL0551N AFTER 3 OR MORE HADR TAKEOVER.
IC95653 2 DB2 TRAPS WHEN DB2EXPLN TRYS TO DESCRIBE THE ACCESS PLAN OF A SQL THAT DOESN'T EXIST WITH "-CACHE" OPTION
IC97714 3 MONITOR ROUTINE ALLOCATIONS FAIL WITH SQL0954
Fix Pack 4  -   Security
IC99475 1 SECURITY: IBM DB2 is impacted by multiple TLS/SSL security vulnerabilities (CVE-2013-6747, CVE-2014-0963)
IC99480 1 SECURITY: VULNERABILITY IN STORED PROCEDURE INFRASTRUCTURE CAN ALLOW ESCALATION OF PRIVILEGE TO ADMINISTRATOR (CVE-2013-6744).
IT00686 1 SECURITY: ELEVATED PRIVILEGES WITH DB2 EXECUTABLES (CVE-2014-0907)
IT00779 1 DB2START FAILS WITH SQL1042C ERROR OR CONNECTION FROM DS DRIVER PACKAGE FAILS AFTER AN UPGRADE FROM V9.7 FP9 OR HIGHER
IC98130 2 PARAMETER MARKERS CAN UNEXPECTEDLY BE LOGGED WHEN AUDITING A TABLE
IC95073 2 NEW VALUE JCC_ENFORCE_SECMEC FOR DB2 REGISTRY VARIABLE DB2AUTH TO REJECT NON-ENCRYPTED USERNAMES AND PASSWORDS FROM JCC CLIENT
IC96690 2 NEW VALUE JCC_ENFORCE_SECMEC FOR DB2 REGISTRY VARIABLE DB2AUTH TO REJECT NON-ENCRYPTED USERNAMES AND PASSWORDS FROM JCC CLIENT
IC96146 2 WHEN DOING SWITCH USER IN A TRUSTED CONNECTION, THE CLIENT OMITSTO SEND USER REGISTRY NAME (USRREGNM) TO THE DATABASE SERVER
IC97236 3 IN DB2 GATEWAY, WHEN REMOTE NODE IS CATALOGED WITH SSL ENABLED, MEMORY FOOTPRINT PER CONNECTION IS IMPACTED BY KEY DATABASE SIZE
IC98578 3 DB2AUDIT ERRORS FROM DB2AUD PROCESS WHEN USING KRB_SERVER_ENCRYPT
Fix Pack 4  -   XML
IC97664 1 PRIVATE MEMORY LEAK IN DB2SYSC TRIGGERED BY EXECUTING XML QUERIES
IC97450 2 CRASH IN XMLVSTREAMINGNORMSPACE ON LINUX/PPC64
IT00248 2 QUERIES WITH XMLTABLE FUNCTIONS MIGHT RETURN INCORRECT RESULTS WHEN MORE THAN ONE EQUAL PREDICATE IS USED IN WHERE CLAUSE
IC95656 3 DECOMPOSE XML WILL FAIL TO RETURN AN SQLSTATE IN CASE OF UNSUCCESSFUL DECOMPOSITION.
Fix Pack 4  -   pureScale Services
IC96691 1 IN A TSA AUTOMATED HADR ENVIRONMENT, AN AUTOMATED HADR FAILOVER OCCURS IMMEDIATELY AFTER THE TAKEOVER HADR COMMAND IS RUN
IC99930 1 DATABASE RESTORE FAILS ON PURESCALE CLUSTER DUE TO INSUFFICIENT SCA MEMORY ON THE CF (SQLE_RC_INSUFFICIENT_CA_MEMORY_FOR_SCA)
IC98722 2 DB2 WILL WAIT FOR MORE THAN 8 HOURS FOR TSA TO CHANGE RESOURCE LOCK STATE APPEARING AS A HANG
IC97631 2 MOUNTV97_MONITOR.KSH TAKES ACTION WHEN TSA IS IN MANUAL MODE
IC97667 2 MAKE HADRVXX_MONITOR.KSH SCRIPT MORE ROBUST TO REDUCE FALSE NEGATIVES
IC98552 2 WHEN RUNNING DB2GCF AS ROOT TO STOP A PARTITION THE COMMAND EXITS WITH RC=3 AND ERROR MESSAGE
IT01472 2 THE DB2UDB_SVC_PROBE.KSH SCRIPT USED FOR HA WITH SUN CLUSTER INCORRECTLY RETURNS WITH RC=1 CAUSING AN INSTANCE RESTART
IC97145 2 ENHANCE "DB2CLUSTER -CFS -ENTER -MAINTENANCE" TO ENSURE GPFS IS BACK TO NORMAL AFTER "-EXIT -MAINTENANCE"
IC96663 2 ENHANCE MOUNTV97_MONITOR.KSH TO HANDLE TEMPORARY UNEXPECTED OUTPUT OF LSLV ON AIX PLATFORM
IC99208 2 THE DB2V10_STOP.KSH SCRIPT DOES NOT KILL THE DB2SYSC PROCESS AS EXPECTED IN THE CASE WHERE THE HOME DIRECTORY IS NOT ACCESSIBLE.
IC99272 2 DB2HAICU FAILS TO CREATE A MOUNT RESOURCE FOR AN EXT4 BASED MOUNT POINT
IC95661 2 IN A LARGE DPF/HA CLUSTER, IF ALL RESOURCES ARE STARTED AT ONCE IT IS POSSIBLE THAT CERTAIN RESOURCES ARE NOT BROUGHT ONLINE
IC98309 2 IN A TSA/HADR ENVIRONMENT, AUTOMATIC REINTEGRATION OF THE HADR STANDBY DATABASE FAILS
IC99792 3 VARIOUS DB2HAICU OPERATIONS FAILING IN A CONFIGURATION CONTAINING 50 OR MORE HIGHLY AVAILABLE HADR DATABASES
IC96697 3 DURING RESTART OF THE SERVER, DB2FMCD PROCESS CAN REPORT MESSAGETHERE IS ALREADY A COPY OF FAULT MONITOR DAEMON PROCESS RUNNING
IC98813 3 DB2V10_START.KSH SCRIPT HANGS IN CASE OF REMOTELY CATALOGED DATABASES
IC94301 3 PURESCALE FAILS TO START MEMBER WHERE ONE OR MORE OF ITS ASSOCIATED GPFS FILESYSTEMS IS SET TO AUTOMOUNT


DB2 Version 10.1 Fix Pack 3a
APAR Sev. Abstract
IC97737 1 SECURITY: QUERY WITH OLAP SPECIFICATION CAUSES DB2 SERVER TO SHUTDOWN DATABASE. (CVE-2013-6717)
IC97471 1 SECURITY: NULL POINTER DEREFERENCE IN DB2'S XSLT PARSING ENGINE(CVE-2013-5466).
IC99480 1 SECURITY: VULNERABILITY IN STORED PROCEDURE INFRASTRUCTURE CAN ALLOW ESCALATION OF PRIVILEGE TO ADMINISTRATOR (CVE-2013-6744)
IC99475 1 SECURITY: IBM DB2 IS IMPACTED BY MULTIPLE TLS/SSL SECURITY VULNERABILITIES (CVE-2013-6747, CVE-2014-0963)
IT00686 1 SECURITY: ELEVATED PRIVILEGES WITH DB2 EXECUTABLES (CVE-2014-0907)


DB2 Version 10.1 Fix Pack 3
APAR Sev. Abstract
IC92832 1 FAILED BACKUP, TABLESPACES ARE MARKED AS UNMODIFIED, DATA MIGHT NOT BE INCLUDED IN SUBSEQUENT INCREMENTAL BACKUPS IMAGES
Fix Pack 3  -   Abstract Data Types and Spatial Extender
IC92698 2 SPATIAL UPGRADE FROM V9.5 TO V9.7 FAILS
Fix Pack 3  -   Administration Server
IC91732 2 DATABASE ADMINISTRATION SERVER, DAS, MAY CRASH
Fix Pack 3  -   Administration Tools
IC94074 2 DB2ATS MAY BE REMAINED, IF DBMS_JOB.CHANGE WAS EXECUTED.
IC89718 2 DB2LOOK GENERATES DDL FOR DMS TABLESPACE WITH MAXSIZE ROUNDED DOWN.
IC89707 2 IN AN EEE MULTI-PARITION ENVIROMENT, THE TEMP FILE "DB2LOOK_DUMPFILE" DOESN'T GET DELETED AFTER EXECUTION OF DB2LOOK COMMAND
IC92760 3 'PARAMETER STYLE GENERAL WITH NULLS' CLAUSE IS EXTRACTED WRONGLYBY DB2LOOK
IC91755 3 HMONSQLCONNECT, PROBE:100 ERROR WAS OCCURRED.
IC87047 3 DB2LOOK DOES NOT WRAP THE SOURCE FUNCTIONS WITH QUOTATION MARKS WHEN GENERATES STATEMENTS FOR SOURCED FUNCTIONS
IC87086 3 DB2LOOK GENERATES INCORRECT IDENTITY COLUMN RESTART VALUE FOR ALTER TABLE DDL
IC92764 3 THE GRANT COMMAND FOR THE PROCEDURE IS NOT COLLECTED WHEN WE ISSUE THE DB2LOOK COMMAND.
IC96282 3 THE GRANT COMMAND FOR THE PROCEDURE IS NOT COLLECTED WHEN WE ISSUE THE DB2LOOK COMMAND.
IC92763 3 THE GRANT COMMAND FOR THE PROCEDURE IS NOT COLLECTED WHEN WE ISSUE THE DB2LOOK COMMAND.
IC92759 3 'PARAMETER STYLE GENERAL WITH NULLS' CLAUSE IS EXTRACTED WRONGLYBY DB2LOOK
IC91746 3 "INTERNAL HEALTH MONITOR ERROR " ERRORS DUMPED IN THE DB2DIAG.LOG FOR "DB2.MAX_SORT_PRIVMEM_UTIL" HEALTH INDICATOR
Fix Pack 3  -   Buffer Pool Services
IC91607 1 TRAP IN SQLBFINDPAGEINBPORSIM FOLLOWING FAILED BUFFER POOL REDUCE
IC93806 1 LOG FILE CORRUPTION AND POSSIBLE PANIC WHILE DROPPING JUST THE GLOBAL INDEX FROM A RANGE PARTITIONED TABLE.
IC91676 2 SET WRITE SUSPEND FAILS WITH SQL1550N RC 5 DUE TO TABLE SPACE INBACKUP PENDING OR OFFLINE STATE
IC93086 2 SET WRITE SUSPEND CONSISTENTLY FAILS WITH SQL1550N RC=5 WHEN THE BUFFERPOOL IS STMM ENABLED.
IC91221 2 CONTENTION DURING CONCURRENT LOADS CAUSED BY UNNECESSARY SMP PAGE SEARCHES
IC94721 2 PREFETCHER FAILURES CAUSED BY PREADV64 PROBLEMS ON 32 BIT LINUX DISTRIBUTIONS
IC92599 2 PRIVATE MEMORY LEAK ON THE DB2 SERVER BY THE DB2PFCHR THREAD
IC93301 2 SORTS FROM SMALL INDEX BUILDS OVER-RESERVE SORT MEMORY, STMM MAYUNNECESSARILY INCREASE SORT TUNING
IC92253 2 PAGE PREFETCH REQUEST MIGHT FAIL WITH ERROR EFBIG "FILE TOO LARGE"
IC89738 2 SQL0901 FOUND IN DB2DIAG.LOG INDICATING "BAD ALLOCATION IN TABLESPACE" FROM "SQLBMOVEHIGHESTEXTENT"
IC89555 2 BACKUP OF DATABASE UPGRADED FROM PREVIOUS RELEASE FAILS WITH SQL1224N IN SHARED DATA CONFIGURATION
IC90443 2 SHORTAGE OF DATABASE HEAP MEMORY RESULTS IN INSTANCE ABEND IN SQLB_TPL::SQLBTPLITERATOR::GETCURRENTPAGE
IC90146 2 DATABASE ROLLFORWARD FAILS DURING REPLAY OF A CLASSIC REORG IF THE REQUIRED SYSTEM TEMPSPACE IS IN RF PENDING
IC91323 2 TURNING OFF AUTO-RESIZE WHILE THE SAME TABLE SPACE IS BEING EXTENDED MAY RESULT IN UNREPLAYABLE LOG RECORD SEQUENCE
IC96385 2 DB2 CREATE TABLESPACE COMMAND CAN FAIL WITH SQL0289N WHEN FILE SYSTEM SIZE EXCEEDS 16 TB
IC92805 2 FIX EMP CHAIN WALKING CODE IN INCREMENTAL BACKUP CODE PATH
IC94033 2 ROLLFORWARD FOLLOWING RESTORE FROM ONLINE BACKUP IMAGE FAILS WITH BAD PAGE AND SQL1271W IN DB2 PURESCALE ENVIRONMENT
IC90557 2 STMM BUFFERPOOL MINIMUM NORMAL PAGE AREA AND CONFIGURED BLOCK PAGE AREA ARE NOT MAINTAINED ON ACTIVATION WITH SCALE BACK
IC92661 3 GETTING SQL1763N WHEN CREATING A TABLESPACE WITH NO FILE SYSTEM CACHING OPTION ON A ZLINUX ENV
IC91790 3 SPECIFYING SHARED CONTAINER PATH DURING CREATION OF DMS TABLE SPACE IN PARTITIONED ENVIRONMENT MAY CAUSE INSTANCE ABEND
IC91762 3 PRINT ADM12512W WARNING INTO ADMINISTRATION LOG FILE WHENEVER A TABLESPACE IS NO LONGER MAINTAINED BY LOG REPLAY ON HADR STANDBY
IC91366 3 DB2RELOCATEDB CAN FAIL WITH DBT1015N WHEN CHANGING STORAGE_PATH
IC91761 4 "FODC IS IN PROGRESS" STATE IS NOT TURNED OFF AFTER DATA CAPTUREIN CERTAIN SITUATIONS
IC88781 4 SQL0083C WHEN QUERYING TABLE SPACE CONTAINERS
Fix Pack 3  -   Build Team
IC89765 2 UNDEFINED SYMBOL SQLHARESOURCEMODELRECREATE WITHIN LIBDB2O.SO
IC92566 2 DB2 INSTALLATION MAY HIT JVMJ9VM015W INITIALIZATION ERROR FOR LIBRARY JCLSE7B_26
IC92067 3 A 32-BIT CLI APPLICATION RUNNING WITH DB2 64-BIT ON AIX FAILS WITH ILLEGAL INSTRUCTION ERROR
Fix Pack 3  -   Client Interfaces
IC94163 1 IN SOME CASES SQLGETDIAGFIELDW FUNCTION WILL TRUNCATE THE DIAGNOSTIC MESSAGE RETURNED.
IC93122 1 CRASH CAN HAPPEN IN SQLFREECONNECT2 WHEN DBALIAS IS GIVEN WHILE CONNECTING.
IC91777 1 .NET APPLICATION MAY HANG AFTER RECEIVING COMMUNICATION ERROR
IC90602 1 FORMATTING DB2TRC WITH -CLI OPTION MAY TERMINATE ABNORMALLY
IC95642 2 CLI0106E ERROR OCCURS DUE TO PHYSICAL NETWORK TIMEOUT BY LONG IDLE TIME
IC93375 2 TYPEDEF IS NOT WORKING AS EXPECTED WHEN TWO OR MORE TYPEDEF STRUCTURES WITH SIMILAR MEMBER NAME EXIST.
IC89698 2 A HOST STRUCTURE DECLARED IN SQL DECLARE SECTION GENERATES ERRORS DEPENDING ON A NAME OR A LOCATION.
IC90779 2 .NET DB2BULKCOPY - CLI0125E
IC91774 2 DB2CLI VALIDATE IS GIVING IMPROPER ERROR MESSAGE WHEN DB2DSDRIVER.XSD FILE DOESN'T EXISTS
IC94344 2 CCA3018N WHEN USING DB2CFIMP DUE TO WRITE PERMISSION MISSING ON INPUT FILE
IC90047 2 SET ECHO OFF COMMAND DOESN'T DISABLE THE DISPLAY OF COMMANDS ANDTHEIR OUTPUT
IC92197 2 A HOST STRUCTURE DECLARED USING TYPEDEF IN SQL DECLARE SECTION GENERATES ERRORS DEPENDING ON A NAME OR A LOCATION.
IC91284 2 DEFAULT IBMDADB2 PROVIDER NOT REGISTERED WHEN INSTALLING IBM DATA SERVER DRIVER OR SWITCHING DEFAULT COPY TO THE DS DRIVER
IC96041 2 FOR VARCHAR COLUMN IF WE SUPPLY DATA > 32K THROUGH SQLPUTDATA ITIS THROWING RC = SQL_ERROR AND RETURNS NO ERROR.
IC91724 2 DEFAULT IBMDADB2 PROVIDER NOT REGISTERED WHEN INSTALLING IBM DATA SERVER DRIVER OR SWITCHING DEFAULT COPY TO THE DS DRIVER
IC91730 2 DTC:XA:NOT SUPPORTED ISOLATIONLEVEL IN ADO.NET SCENARIO
IC89251 2 CALL PROCEDURE FAILS FROM CLPPLUS COMMAND PROMPT WHEN ARGUMENT VALUE CONTAINS OPEN OR CLOSED PARATHESIS '(' / ')' AND ','
IC89906 2 CAST() IN QUERY USED IN .NET FRAMEWORK DOES NOT ADEQUATELY RESOLVE PRECISION OF DATETIME DATATYPE IN IDS DATABASE.
IC91731 2 SQL5060N RESULTS FROM DB2CFIMP FOR SETTING DFT_MON_UOW TO ON IN DB2 V10.1
IC96277 2 SQL1086C WHEN CREATING DATABASE IF CURRENT WORKING DIRECTORY (CWD) IS EMPTY.
IC96267 2 MULTI-THREADED APPLICATIONS USING BOTH ESQL/C AND CLI INTERFACESMAY EXPERIENCE HANGS OR CRASHES WHEN NOT USING EXPLICIT CONTEXT
IC92230 2 DB2CLI REGISTERDSN -ADD -ALLDSN SYSTEM HAS MISSING ODBC DSNS WITH A LARGE NUMBER OF DSNS IN DB2CLI.INI OR DB2DSDRIVER.CFG
IC94085 2 .NET APPLICATION GETS SYSTEM.EXECUTIONENGINEEXCEPTION AFTER CONNECTING TO A DATABASE
IC92664 2 IN CLPPLUS NON WINDOW MODE PAUSE MAKES THE CLPPLUS WINDOW HANG
JR43257 2 MQSEND DOESN'T SEND A DATAGRAM BY DEFAULT
IC94081 2 CONVERSION ISSUE WHEN COMPILING WITH OPTION "WCHARTYPE"
IC88755 2 NEEDS MERGING -- ISSUE WITH CREATE DB PROPERTY PAGESIZE(WSDBU01058320)
IC91953 2 MULTI-THREADED APPLICATIONS USING BOTH ESQL/C AND CLI INTERFACESMAY EXPERIENCE HANGS OR CRASHES WHEN NOT USING EXPLICIT CONTEXT
IC96270 2 SQL_COLUMN_LENGTH RETURNS A LENGTH OF 16 INSTEAD OF 26 FOR TIMESTAMP COLUMNS WITH PATCH1=131072 ENABLED IN THE DB2CLI.INI FILE
IC91268 2 MISSING .NET DB2EXCEPTION BECAUSE OF MISSING RECORD IN SQLGETDIAGREC()
IC91752 2 CLPPLUS SHOULD NOT GET INTO INTERACTIVE MODE WHEN USER SPECIFIESINCORRECT CREDENTIALS IN THE CONNECT STRING GIVEN WHILE LAUNCHI
IC92616 2 SQLGETDIAGFIELDW() RETURNS THE STRINGLENGTHPTR AS CHARACTERS INSTEAD OF BYTES.
IC87451 2 .NET PROVIDER THROWS EXCEPTION WITH INFORMIX: A SYNTAX ERROR HASOCCURRED
IC91739 2 CLPPLUS WILL THROW A JCC EXCEPTION WHEN CONNECTION FAILS TO ESTABLISH AND 'WHENEVER SQLERROR' CLAUSE IS SET.
IC91292 2 INCORRECT OUTPUT FROM CLPPLUS WHEN SUBSTITUTION CHARACTER "&" PRECEDED BY "O"
IC92437 2 DB2CFEXP DOES NOT EXPORT ALTERNATE SERVER INFORMATION
IC87640 2 ALTER FUNCTION STATEMENT CAN FAIL WITH SQL0104N WHEN EXECUTED VIA DB2.NET OR CLI
IC87079 2 SQLGETCONNECTATTR() WITH SQL_ATTR_PING_DB AFTER A SEAMLESS FAILOVER
IC90117 2 REORGCHK CAN RETURN INCORRECT VALUES FOR LEAF_RECSIZE & NLEAF_RECSIZE RESULT IN INCORRECT F5 & F6 VALUES.
IC94183 2 .NET EXCEPTION WHEN SERVER SIDE PAGINATION IS ENABLED WITH ODATAWITH INFORMIX DATABASE
IC89720 2 SQL0644N ON STATEMENTS AFTER SELECT WITH STMTCONCENTRATOR=LITERALS & CURSORHOLD=1
IC91725 2 CLP PLUS NOT ACCEPTING PASSWORD EXPLICITLY WHEN CONNECTING USINGA DSN.
IC95044 2 CLI OR .NET APPLICATION WITH PUREQUERY CLIENT OPTIMIZATION MAY THROW SQL0805N WHEN USING FORCESINGLEBINDISOLATION OPTION.
IC91627 2 SQL1086C WHEN CREATING DATABASE IF CURRENT WORKING DIRECTORY (CWD) IS EMPTY.
IC83840 2 ERROR FOR EXECUTING DB2BATCH IN DB2DIAG.LOG WITH V9.7 FP5
IC91734 2 DECIMAL VALUES ARE INCORRECTLY RETURNED BY A STORED PROCEDURE
IC89035 2 EXCEPTION "THERE IS NO MORE DATA TO RETURN" WHEN USING ENTITIES W/ WFC SERVICES AND QUERYING TABLES W/ LOB COLUMNS USING EXPAND
IC89703 2 DB2DSDCFGFILL CREATES DUPLICATE LINES IN THE DB2DSDRIVER.CFG FILE DUE TO MORE THAN 255 DATABASES OR NODES CATALOGED
IC92226 2 CLI0143E ON SQLBINDPARAMETER FOR TIMESTAMP TYPE WITH CBCOLDEF=-1
IC89697 2 SQL0516N ERROR RUNNING QUERY FROM THE DB2 CLP AGAINST DB2 FOR Z/OS WITH IDAA ENABLED
IC89867 2 ADD WINDOW DOES NOT APPEAR USING IBM DATA SERVER DRIVER FOR ODBCAND CLI
IC96281 2 ABEND POSSIBLE IN CLI_SQLDISCONNECT WITH > 512 DATABASE HANDLES ALLOCATED IN MULTITHREAD ENVIRONMENT
IC91791 2 'LOAD QUERY' COMMAND ENCOUNTERS SQL6024C AND HOLD LOCKS ON CATALOG TABLES
IC90805 2 CAST() IN QUERY USED IN .NET FRAMEWORK INCORRECTLY MAPS VARCHAR(1) TO TEXT DATATYPE IN IDS DATABASE.
IC92026 3 OCISESSIONBEGIN FAILS WITH OCI_STMT_CACHE MODE
IC96286 3 SQL_DIAG_ROW_NUMBER RETURNS THE WRONG ROW NUMBER WITH ARRAY INPUT CHAINING
IC89023 3 DB2DSDRIVER.XSD NOT FOUND ON INSTANCE BASED CLIENTS
IC96257 3 POSSIBLE ABEND DURING SQLCONNECT CALL WHEN CONNECTIONS ARE FORCED ON THE SERVER SIDE.
IC94378 3 USING THE DB2CFIMP TO IMPORT CONNECTIVITY CONFIGURATION PARAMETERS CAUSES AUTOMATIC VALUES TO BE RESET TO MINIMUM VALUES.
IC92594 3 REORGCHK CURRENT STATISTICS ON TABLE MIGHT RETURN INCORRECT VALUE OF F2 FORMULA IN PARTITIONED DATABASE ENVIRONMENT
IC92736 3 XA CONNECTIONS DRIVEN BY XA_OPEN DO NOT USE DB2DSDRIVER.CFG AND THROWS SQL1013N ERROR
IC89494 3 IBM DATA SERVER DRIVER .NET DLL FILES NOT UPGRADED AFTER INSTALLOF SPECIAL BUILD
IC91305 3 WHEN DATABASE IS ACTIVATED AND LIST APPLICATIONS COMMAND IS ISSUED, SQLCODE IS NOT SET CORRECTLY.
IC92517 3 DB2 CLP DUMPS CORE WITH OPTION -L AND STATEMENTS BIGGER THAN 128K
IC91721 3 A TEMPORARY FILE ON /TMP IS LEFT AFTER EXECUTING CLPPLUS
IC90908 3 DB21034E ERROR OCCURS WHEN BLOCK COMMENTS IS AT THE BEGINNING OFFILE AND 'WITH' SQL STATEMENT IS AFTER BLOCK COMMENT.
IC93000 3 OCISTMTEXECUTE() MAY GET OCI_NEED_DATA ERROR
IC91737 4 WHEN STMT_CONC IS SET TO LITERALS, CLPPLUS IS NOT DISPLAYING THEEXPLAIN PLAN FOR STATEMENTS WHICH CONTAIN LITERAL VALUES.
Fix Pack 3  -   Codegen and Runtime
IC90241 1 USING XML IN QUERIES WITH REOPT BIND OPTION OR EXTENDED INDICATORS LEAKS MEMORY IN DATABASE HEAP IN DPF ENVIRONMENTS
IC89415 1 READ STABILITY ISOLATION IS NOT ENFORCED UNDER CERTAIN SQL ACCESS PLANS
IC93811 1 IN ENVIRONMENTS WHERE SORT MEMORY IS CONSTRAINED SEGV CAN HAPPENON HASH JOIN QUERIES DOING AGGREGATION
IC93009 1 ON DPF, A HANG CAN OCCUR IF AN INTERRUPT IS RECEIVED DURING THE EXECUTION OF A QUERY THAT CONTAINS A CORRELATED SUB QUERY.
IC89044 1 INSTANCE TRAP IN SQLRI_LIKE_ALLOC()
IC91197 2 INSTANCE PANIC WHEN AGGREGATION FUNCTION(IE.MIN,MAX,SUM...) IS USED AGAINST ROWID RESULT
IC92052 2 EXCESSIVELY LARGE MEMORY ALLOCATION ATTEMPTS FROM FAST INTEGER SORT DUE TO WRONG MEMORY SIZE CALCULATION
IC91822 2 CASTING XML ATOMIC INTO ONE OF SQL CHARACTER TYPES MAY LEAD TO ADM0503C.
IC92731 2 RETURN OF SQL0083C MAY CAUSE A HANG IN AN SMP ENVIRONMENT.
IC91989 2 QUERY WITH TABLESAMPLE SYSTEM() MIGHT HANG IN SMP MODE (INTRA_PARALLEL = YES)
IC91743 2 MEMORY OVERWRITE WHEN USING UTL_FILE OR DBMS_OUTPUT.ENABLE WITH BUFFER SIZE BIGGER THEN 32K.
IC92001 2 MEMORY CORRUPTION ISSUE WITH XML ON DPF ENV
IC91639 2 MEMORY OVERWRITE CAN HAPPEN WHEN ARRAYS WITH ELEMENTS OF LARGE SIZE ARE USED.
IC90798 2 INCORRECT RESULTS MIGHT BE RETURNED FOR THE SELECT QUERY INVOLVING THE AGGREGATION FUNCTION WITH THE OLAP WINDOW FUNCTION
IC89631 2 MEMORY LEAK IN APPL HEAP WITH INTRA-PARTITION PARALLELISM AND PLANS CHOOSE TO REBALANCING ROWS BETWEEN SMP SUBAGENTS (REBAL).
IC91741 2 TRAP IN RECYCLEANDREINIT FOR AN INTERRUPTED XML QUERY IN DPF
IC90017 2 CRASH IN SQLRIMOVEDATALEN FOR A RECURSIVE QUERY WITH UNION AND HOST VARIABLES
IC91689 2 FEDERATED OBJECT REFERENCES SHOULD BE DISALLOWED WITHIN COMPILEDSQL FUNCTIONS
IC92513 2 PERFORMANCE ISSUE DURING OPERATIONS ON GLOBAL COLLECTIONS
IC93789 2 DB2 ABEND IN FAST INTEGER SORT FUNCTIONS LIKE SQLSFASTINTDISTCOUNTSORT IF SORT MEMORY EXCEEDS 2GB
IC91283 2 SQL0901N IS RETURNED FOR A QUERY THAT FEATURES A UNION ALL VIEW WITH A HOST VARIABLE PREDICATE ON THAT VIEW.
IC86715 2 FEDERATED OBJECT REFERENCES SHOULD BE DISALLOWED WITHIN COMPILEDSQL FUNCTIONS
IC90906 2 A QUERY INVOLVING AT LEAST TWO COUNT(DISTINCT ...) AGGREGATE FUNCTIONS MIGHT RETURN WRONG RESULTS
IC89710 2 PRECISION PROBLEM WHEN CONVERTING A DOUBLE TO A DECIMAL.
IC92353 2 IN A DPF ENVIRONMENT, AN ACCESS PLAN WITH A LISTENER TQ OPERATORMAY ENCOUTER A NULL POINTER AND CAUSE DB2 TO CRASH.
IC94465 2 BITWISE SCALAR FUNCTIONS MIGHT RETURN INCORRECT RESULTS WHEN USED WITH DECFLOAT DATATYPE ON AIX POWER7
IC89700 2 INSTANCE TRAP DUE TO SQLRINLJNMUSTIDOINNER
IC87452 2 DYNAMIC WINDOW COUNT ADJUSTMENTS IS TOO AGGRESSIVELY REDUCING WINDOW COUNT.
IC94377 2 POSSIBLE SEGV (CRASH/TRAP) IN SQLDROWFETCH() WHEN SQL IS USING PBT(PARAMETERIZED BASE TABLE) ACCESS IN A NESTED LOOP JOIN
IC91117 2 DB2 TRAP IN REBAL CODE DUE TO MEMORY CORRUPTION
IC90770 2 ZIGZAG JOIN WITH QUERY DEGREE > 1 MAY HANG OR FAIL WHEN A SUBAGENT EXITS EARLY WITH NO ROWS FOUND IN DIMENSION PROCESSING
IC90452 3 DB2 MIGHT CRASH WHEN RUNNING DBMS_ALERT.SET_DEFAULTS() SQL FUNCTION.
IC91744 3 SORT SHARED MEMORY COUNTER UNDERFLOW MAY CAUSE SEVERE MESSAGE INTHE DB2DIAG.LOG
IC92571 3 GRAPH GENERATED WITH 'DB2EXPLN -G' DOES NOT CONTAIN STATISTICS
IC87506 3 ON V10.1, SQLRR_APPL_TERM() MAY REPORT SEVERE SQL0901N MESSAGE
IC86835 3 SQL STATEMENT FAILS WITH SQL0901N (REASON "ASSERT ZZJN DIM TEMP TAOB HAS A DUMMY RESID ")
IC91803 3 MEMORY LEAK IN UCA500R1 COLLATION DATABASE WHEN USING COLUMN NAME IN PATTERN-EXPRESSION OF LIKE CLAUSE
IC90756 3 SQL0901 IS RETURNED FOR A QUERY THAT FETCHES ZERO-LENGTH LARGE OBJECTS ON DPF
IC92732 3 QUERY HANG WHEN SELECTING LARGE OBJECT COLUMNS FROM A TABLE FUNCTION ON DPF
IC91800 3 SQL0956C THROWN WHEN CALLING PARSE PROCEDURE WITH AN INPUT SQL STATEMENT CONTAINING A COMMENT WITH COLON (:) FOLLOWED BY A SPACE
IC91405 3 SOMETIMES A QUERY INVOLVING A ZIGZAG JOIN MAY FAIL WITH WITH A SQL0901N ERROR
Fix Pack 3  -   Communication
IC89975 2 WHEN THIRD PARTY SOFTWARE LOADS GSKIT-CRYPTO INSTEAD OF FULL GSKIT , DB2 LOADS ITS LOCAL GSKIT-CRYPTO , DB2 FAILS WITH SQL1042C
IC91990 2 FALSE COMMUNICATION ERROR DETECTED BETWEEN DB2FMP PROCESS AND DB2 EDU LEADING TO INCORRECT SQL1646N ERROR RETURNED
IC90914 2 DB2TCPCM EDU NEED TO HANDLE SETSOCKOPT() FAILURES MORE GRACEFULLY
IC89978 2 XAER_NOTA RETURNED BY DB2 CONNECT SERVER WHEN TM TRIES TO PREPARE/COMMIT/ROLLBACK A TRANSACTION IN DISTRIBUTED ENVIRONMENT.
IC89541 3 DB2 IS UNABLE TO CLEAN UP THE SSL RESOURCES CORRECTLY WHEN IT FAILS TO LOAD GSKIT AND THUS CAUSES UNRECOVERABLE ERROR
IC91756 3 ADD RETRY WHEN DB2 RECEIVES WSAEACCESS WHEN BINDING TCP SERVICE PORT IN WINDOWS.
Fix Pack 3  -   DB2 Tools
IC96394 1 PERFORMANCE EXPERT MAY HANG WHEN UTILIZING FUNCTIONS PROVIDED BYTHE DB2 CONTROL CENTER
IC89706 2 DBA7510 FROM THE CONTROL CENTER USING WIZARD: CREATE DATABASE WITH AUTOMATIC MAINTENANCE
IC91740 2 ADMIN_CMD LOOPS IF MORE THAN 32767 MSG IN SQLLIB/TMP, AND/OR ADMIN_REMOVE_MSGS FAILS WITH SQL20193N RC=10.
IC96283 2 SYSPROC.NNSTAT PROCEDURE CAN FAIL IF USING METHOD 2 WITH SQL0206N ERROR.
IC96260 2 NNSTAT METHOD 1 OR 0 REPORTS SQL1227N RC=3 WHEN IT TRIES TO UPDATE HIGH2KEY TO SINGLE BLANK FOR AN INTEGER COLUMN
JR46839 3 DB2FMP CRASHES WHEN RUNNING NNSTAT FOR A NICKNAME THAT HAS AN INDEX CONTAINS TOO MANY COLUMNS
Fix Pack 3  -   DRDA Services
IC96255 1 CONNECTION HANGS ON ACR AFTER COMMUNICATION ERROR. ALTERNATE SERVER INFORMATION FROM THE DATABASE CATALOG IS NOT USED.
IC91681 2 STORED PROCEDURE FAILS WITH SQL30020N WHEN THERE ARE 10684 PARAMETER MARKERS
IC92712 2 .NET XA APPLICATION WITH AUTOMATIC ENLISTMENT CAN CRASHE ON FIRSTCONNECT DURING LICENSE ACTIVATION
IC92173 2 2 MINOR MEMORY LEAKS WHEN CONNECTING USING CLI.
IC91776 2 AFTER UPGRADING TO V9.7 FP7, QUERY DRDA NICKNAME WILL FAIL IF DB2 REGISTRY DB2TCP_CLIENT_CONTIMEOUT IS SET
IC89783 2 AFTER AN APPLICATION IS BEING KILLED, ITS SPAWNED TRANSACTIONS ARE LEFT IN EXECUTING STATE
IC96284 2 WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.
IC96386 2 DB2 CONNECT INSTANCE MAY CRASH IN THE FUTURE AFTER A COMMUNICATION ERROR WHEN LDAP SUPPORT IS ENABLED (DB2_ENABLE_LDAP=YES).
IC91302 2 XA PROTOCOL ERRORS AFTER RM_FAIL ON XA_END.
IC92178 2 SQLNN_E_SYNTAX SYNTAX ERROR ON 'CALL 47' STORED PROCEDURE CALL SEEN IN DB2DIAG.LOG
IC91807 2 WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.
IC92966 2 XA_END MAY RETURN XA_RBOTHER INSTEAD OF XAER_RMFAIL AFTER REPORTING COMMUNICATION ERROR.
IC91805 2 DIA5000C "INVALID DDM REQUEST" AND SYNTAX ERROR REPORTED WHEN DB2 FOR ZOS ATTEMPTS TO SWITCH ID ON A TRUSTED CONNECTION
IC96287 2 ACR IS NOT ENABLED FOR CONNECTIONS TO Z/OS THRU DB2 CONNECT SERVER EVEN ALTERNATE SERVER IS SET
IC92081 2 APPLICATION MAY SEE ERROR SQL301N OR SQL30020N, IF A SQL/PL IS CREATED WITH ARRAY TYPE.
IC91771 2 SQL0998N OR XAER_PROTO WHEN DB2LIC.SYSLIC IS CALLED TO CHECK SERVER ACTIVATION
IC92079 2 APPLICATION MAY SEE ERROR SQL301N OR SQL30020N, IF A SQL/PL IS CREATED WITH ARRAY TYPE.
IC91767 2 AN OUT OF MEMORY ERROR ENCOUNTERED WHILST COPYING A DATA DESCRIPTOR COULD LEAD TO A CRASH.
IC93738 2 SQL1001N ERROR FROM CLI APPLICATION WHEN ENLISTING THE DATABASE WITH MSDTC.
IC93060 2 DB2 CONNECT SERVER CONNECTION CONCENTRATOR MAY FAIL TO RE-ESTABLISH CONNECTION OR TRUSTED CONNECTION.
IC94088 3 CLIENT REROURE FAILS TO ZOS SERVER WITH ERRONEOUS MESSAGE "ENSURE APAR PM24292 IS INSTALLED ON THAT SYSTEM."
IC91794 3 CLI EXTENDED DIAGNOSTICS, ARRAYINPUTCHAIN ENABLED AGAINST A BUSYDB2 ZOS SERVER RETURNS SQL0904N-NO REASON CODE, RESOURCE NAME
IC87379 3 ERRONEOUS MESSAGE "ENSURE APAR PM24292 IS INSTALLED" WHILE CONNECTING TO ISERIES SERVER
IC96396 3 DB2 CONNECT SERVER MIGHT CRASH IF DCS DIRECTORY IS CATALOGUED TOUSE MAP-FILE OPTION
IC96449 3 ADMIN_MOVE_TABLE MIGHT PRODUCE TRAP OR FAIL IF ORIGINAL TABLE HAS MORE THAN 100 REFERENCES
Fix Pack 3  -   Data Management Services
IC94243 1 SQLE_SAL_CACHE_RAR_NODATA USING THE DB2READLOG API
IC91306 2 WHEN DB2 UDB SERVER ENCOUNTERS BLOCK INDEX ISSUE, DB2 SERVER SHOULD RETURN SQL0901N ERROR INSTEAD OF TRAP.
IC89580 2 WHEN DB2 UDB SERVER ENCOUNTERS BLOCK INDEX ISSUE, DB2 SERVER SHOULD RETURN SQL0901N ERROR INSTEAD OF TRAP.
IC91168 2 SQL STATEMENT MAY HANG DUE TO A DEADLATCH WHEN PROCESSING SUBSECTIONS OF A ZIG ZAG JOIN PLAN
IC89100 2 REORG FAILS WITH SQL2216N (-301) ON HP DPF ENVIRONMENT
IC92799 2 IN RARE TIMING SCENARIO, LOAD PERFORMANCE WITH LOB VALUES MAY DEGRADE
IC94173 2 SIGNAL 11 TRAP IN SQLSBINSORTPOPULATERECPOINTERS
IC92699 2 DB2CAT FAILS TO GENERATE A NEW PACKED DESCRIPTOR (-G OPTION) IN DB2 V10.1, WHEN TABLE HAS INDEXES
IC94160 4 INCORRECT CUR INDEX AND START TIME VALUES IN DB2PD -REORGS INDEXAFTER AN INTERRUPTED INDEX REORG
Fix Pack 3  -   Data Management Utilities
IC95010 1 THE LOAD COMMAND WITH THE REMOTE FETCH OR SOURCEUSEREXIT OPTIONSMIGHT FAIL TO INSERT SOME ROWS INTO A TABLE
IC95993 1 INGEST: RUN TIME IS 32X WORSE THAN IMPORT WHEN TABLE HAS MANY UDTS
IC88134 2 LOAD COMMAND MIGHT HANG WHEN LOADING DATA INTO DATA PARTITIONED TABLES OR MDC TABLES
IC91763 2 RESTORE DB WITH TRANSPORT FAILS WITH ERROR SQL2590N DUE TO LOG ARCHIVING FAILURE ON STAGING DATABASE.
IC89203 2 LOAD MIGHT TRAP AND CRASH THE INSTANCE IN CERTAIN CONDITIONS
IC94720 2 LOAD TRAPS WHEN TARGET TABLE HAS GENERATED COLUMN WHICH IS USINGCOMPILED COMPOUND SQL UDF; SHOULD FAIL GRACEFULLY.
IC90269 2 'LOAD QUERY' COMMAND ENCOUNTERS SQL6024C AND HOLD LOCKS ON CATALOG TABLES
IC91801 2 IMPORT NULL VALUE TO A COLUMN THAT IS A PART OF PRIMARY KEY WITHINSERT_UPDATE AND USEDEFAULTS OPTIONS WILL COMPLAIN -206 ERROR.
IC91297 2 DB2 LOAD INTO PARTITIONED TABLE THAT CONTAINS AN XML COLUMN MAY FAIL WITH SQL0901N - "MAX PSEUDO RID REACHED"
IC94134 2 SQL2918N RECEIVED WHEN THE INGEST COMMAND SPECIFIES BOTH ONE OF THE IMPLICITLYHIDDEN OPTIONS AND THE EXCEPTION TABLE CLAUSE
IC90772 2 SQL2036N WHEN USING RECOVER WITH RESTORED RECOVERY HISTORY FILE FROM A BACKUP THAT HAS MORE THAN 1 SEQUENCES
IC91792 2 LOAD MAY FAIL WITH SQL0902C RC85 IF THERE IS AN INDEX WITH KEY LENGTH AROUND 4000 OR 8100 BYTES
IC93013 2 LOAD: RECORDS REJECTED DURING PARTITIONING ARE NOT COUNTED TOWARDS WARNINGCOUNT
IC88474 2 LOAD REMOTE FETCH MIGHT TRAP AND CRASH DB2 INSTANCE DURING THE INDEX COPY PHASE
IC91704 2 DB2 INGEST FAILS ON WINDOWS VISTA AND WINDOWS 7
IC94987 2 DPF: DB2DART REPORTED INDEX KEY ERRORS AFTER REDISTRIBUTE ON A TABLE WITH ADAPTIVE COMPRESSION
IC93053 2 XML LOAD TERMINATE RESULTS IN SQL1007N (ERROR IN FINDING PAGES FOR AN OBJECT IN A TABLE SPACE.)
IC91272 2 DB2 INSTANCE CRASH IN SQLUCONVDATATOTARGET() DURING LOAD INTO TABLE
IC89228 2 LOAD MIGHT CHANGE THE CURRENT WORKING DIRECTORY OF DB2SYSC WHEN LOADING LOB/XML DATA IN A NON-DPF ENVIRONMENT
IC89200 3 COLUMN CONTAINING INVALID CHARACTER DATA REJECTED BY LOAD REMOTEFETCH
IC93161 3 BINDING DB2UCKTB.BND AGAINST LOWER RELEASE DB2 LUW DATABASE THROWS ERROR.
IC84263 3 REDISTRIBUTE UPDATES TABLE PACKED DESCRIPTOR AND OVERWRITES UPDATES OF RUNSTATS
IC90126 3 ON WINDOWS IMPORT UTILITY MIGHT FAIL WITH ERROR SQL0604N WHEN DB2_COMPATIBILITY_VECTOR=ORA IS SET.
Fix Pack 3  -   Data Recovery Services
IC92015 1 A SECOND DATABASE RECOVERY THAT NEEDS TO REPLAY SOME LOG RECORDSREPLAYED DURING A PREVIOUS DATABASE RECOVERY MAY FAIL.
IC94728 1 REQUIRED TRANSACTION LOGS FOR ONLINE BACKUP CAN GET DELETED IN DB2 V10.X. RESULTING IN SQL2048N ERROR.
IC94114 2 DB2FLSN -LSO MAY RETURN A WRONG LOG FILE NAME
IC90510 2 DB2 ONLINE BACKUP WITH INCLUDE LOGS FAILS WITH ERROR SQL2428N
IC89675 2 GRACEFUL TAKEOVER ON A HADR READS ENABLED STANDBY RETURNS SQL1773N IF THERE ARE UNCOMMITTED IN-DOUBT TRANSACTIONS ON PRIMARY.
IC90952 2 HADR STANDBY DATABASE ENCOUNTERS LOG PAGE CHECKSUM ERROR
IC90923 2 UPGRADE CODE CHECK-IN OPTION FOR VALID RUNSTATS PROFILES
IC90695 2 ARCHIVED LOG CORRUPTION POSSIBLE USING LOG COMPRESSION AND VENDOR SETTING
IC92474 2 DB2 V10.1 DOES NOT WRITE THE "STARTED ARCHIVE FOR LOG FILE XXX"MESSAGE TO THE DB2DIAG.LOG FILE ANYMORE
IC93281 2 NO AUTO DELETION OF OLD BACKUP IMAGES ON DISK AFTER MIGRATION TO10.1
IC91656 2 HADR START AS STANDBY FAILS DUE TO ENOBUFS ERROR AND RETURNS HDR_ZRC_CONFIG_LOCAL_HOST
IC91789 2 ONLINE BACKUP CAN FAIL WITH SQL0100W AND INCORRECTLY REPORT BACKUP COMPLETE AS WELL AS OVERWRITING THE BACKUP TRACKING STRUCTURE
IC91266 2 SQL1042C ERROR CAN OCCUR WHILE APPLYING TRANSACTION LOGS (TILL "END OF BACKUP" OPTION) ON DB2 FOR WINDOWS.
IC89312 2 "DB2CKLOG CHECK -M" FAILS WITH DBT7045E IN V10.1, WHEN THE CHECKED DATABASE IS ACTIVE
IC92997 2 DB2FLSN -Q (QUIET MODE) DOES NOT WORK CORRECTLY
IC93536 2 DB2ADULT RETURNS READING OF DB CFG FILE FAILED! AND TSM RC=137 IN PURESCALE INSTANCE ENV
IC91793 2 DB2CKBKP REPORTS MISLEADING ERROR "NO PAGE HEADER: POSSIBLE LOB.ERROR - TABLESPACE PAGE SIZE INCONSISTENT FOR TABLESPACE ID <#>"
IC93405 2 DB2PD -LOGS AND MON_GET_TRANSACTION_LOG() DO NOT RETURN RIGHT LOG CHAIN ID
IC94252 2 TCP CONNECTIONS FROM NON-HADR DATABASE SOFTWARE TO THE STANDBY MIGHT ALTER THE HADR STATE AND STALL LOG SHIPPING ON THE PRIMARY
IC89732 3 DB2CKBKP RETURNS FALSE ERRORS FOR COMPRESSED BACKUPS
IC93241 3 DB2READLOG API WAS RETURNED SQLCODE -1273 DURING ONLINE BACKUP.
IC92623 3 RESTORE FAILS IF VENDOR LIBRARY CANNOT BE INITIALIZED, DESPITE USING BACKUP IMAGE AND LOG FILES PREVIOUSLY EXTRACTED TO DISK
IC91779 3 A TABLE SPACE BACKUP DOESN'T RESPONSE INTERRUPT FROM "CTROL+C" OR "FORCE APPLICATION".
IC92696 3 SQLUDREPAIROFFLINEBACKUPENDMARKER, PROBE:1719 ON RESTORE
IC90960 3 GROUP READ PERMISSION IS REVOKED ON ARCHIVE LOG FILES.
IC96259 3 SYNTAX CHECK FOR RECOVER DB USING HISTORY FILE NEEDS TO BE MOVEDFROM CLIENT TO SERVER
IC88511 3 EXCESSIVE DIAGNOSTIC LOGGING SERVICING ASYNCHRONOUS LOG READ REQUESTS (DB2READLOG API)
Fix Pack 3  -   ESE Monitoring code
IC93167 2 CLI APPLICATION MAY TRAP DUE TO MEMORY CORRUPTION
Fix Pack 3  -   Federation
JR48045 2 RUN NNSTAT FAILED WITH THE ERROR SQL1227N
IC96754 2 YOU MAY MEET SQL1227N ERROR WHEN HIGH2KEY AND LOW2KEY IS TIMESTAMP TYPE IN ORACLE MODE
IC96258 2 FED: ALTER NICKNAME IN ORA COMPATIBLE MODE, FAILED TO MAP REMOTEDATE TO LOCAL TIMESTAMP(0)
IC91455 2 ERROR RAISED INCORRECTLY FROM SQLEFEDFMPMANAGER::DISCONNECT UPONSUBAGENT CLEANUP
IC89715 2 BAD PERFORMACE WHEN USING SYBASE NICKNAME WITH BIGINT COLUMN PREDICATES
IC91289 2 ORACLE WRAPPER LEAKS MEMORY WHEN ITERATIVELY EXECUTES DYNAMIC IUD STATEMENTS IN A PACKAGE
IC96269 2 ADD ERROR MAPPINGS FOR SOME ORACLE CONNECTION ERRORS TO DB2 ERROR SQL30080N
JR47218 2 REPORT SQL0901N (REASON "BAD OPCODE -9, REF_ARITY 3, SQLNQ_PID ID 941 (SYSIBM.DJ_RPAD)".)
IC93252 2 TO_CHAR AND OTHER BUILT-IN FUNCTIONS COULD NOT BE PUSHED DOWN
IC96256 2 DB2 MAY TRAP AT THE DESTRUCTOR OF SQLQG_REMOTE_STMTS.
IC91768 2 INCORRECT OUTPUT OF DATETIME AND DATETIME2 IN SQL SERVER
IC91286 2 INCORRECT OUTPUT OF DATETIME AND DATETIME2 IN SQL SERVER
IC96275 2 SQL1822N ERROR WHEN QUERYING CURRENT DATE OR TIMESTAMP FROM NICKNAME
IC96412 2 THE FEDERATED SERVER DOES NOT SUPPORT USER-DEFINED TYPES, DISTINCT TYPES, AND REFERENCE TYPES AS COLUMNS OF NICKNAMES.
IC88789 2 INCORRECT OUTPUT OF DATETIME AND DATETIME2 IN SQL SERVER
IC96266 2 FENCED ORACLE WRAPPER LEAKS MEMORY WHEN ITERATIVELY EXECUTES INSERT/UPDATE STATEMENTS INVOLVING A LOB COLUMN
JR46877 2 CREATE NICKNAME AGAINST ORACLE TABLE (USING ORACLE WRAPPER) MIGHT FAIL WITH ERROR SQL0802N FOR ORACLE TABLE WITH FEW BILLION ROW
IC91813 2 REPLACE OLD API OCIENVINIT AND?OCIINITIALIZE TO OCIENVCREATE SINCE ORACLE HAS NOT SUPPORT IT ANYMORE
JR45770 2 FEDERATED FMP TRAPPED WHEN QUERY JDBC NICKNAME WITH CLOB DATA LONGER THAN 32K
IC87539 2 BAD PERFORMACE WHEN USING SYBASE NICKNAME WITH BIGINT COLUMN PREDICATES
IC89699 2 CREATE NICKNAME FOR A TABLE ON DB2/Z VERSION 10 FAILED WITH SQL0901N REASON "ERROR SERVER VERSION"
IC96411 2 ENHANCE FEDERATION SERVER INFORMIX WRAPPER PERFORMANCE WHEN IT HAS BIGINT
JR46425 2 JDBC DOESN'T REPORT SQLCODE 100 WHEN NO DATA IS UPDATED OR DELETED
JR46976 2 RECEIVE SQL1822N/SQL0401N ERROR WHEN QUERYING A NICKNAME IN AN ORA MODE DATABASE
IC93251 2 UDF WITH STRING RESULT TYPES COULD BE BLOCKED FROM BEING PUSHED DOWN
IC96413 2 THE REMOTE CONNECTION'S ISOLATION LEVEL IS SERIALIZABLE WHEN USING SQL SERVER WRAPPER 2PC FEATURE
IC91719 3 QUERY MAY HANG WITH FEDERATED AND DB2_COMPATIBILITY_VECTOR=ORA
IC91773 3 INCORRECT OUTPUT OF DATETIME AND DATETIME2 IN SQL SERVER
IC91775 3 INCORRECT VARCHAR2 COMPARISON PREDICATE IS PUSHED DOWN TO ORACLECAUSES -1822 ERROR
IC91780 3 "GROUP BY 1" SYNTAX IS PUSHED DOWN MSSQL INCORRECTLY
IC91722 3 ADD DIAGNOSIS INFORMATION WHEN ORACLE WRAPPER FAILED AFTER CALLING OCIENVINIT
IC91671 3 NESTED TABLE EXPRESSIONS WITH OUTER JOIN NOT PUSH DOWN
Fix Pack 3  -   Index Manager
IC92990 1 INDEX / DATA MISMATCH MIGHT OCCUR IN AN MDC TABLE AFTER A DEFERRED ROLLOUT
IC90039 2 DEADLATCH DURING MEMBER CRASH RECOVERY IN A DB2 PURESCALE ENVIRONMENT
IC92798 2 RUNNING MULTIPLE CONCURRENT SAMPLED DETAILED INDEX RUNSTATS MIGHT CAUSE A SERVER ABEND OR INACCURATE INDEX STATISTICS
IC89032 2 SQLI_SMP_ERR ERROR DURING ROLLBACK OF FREE PAGE OPERATION ON AN INDEX
IC91650 2 INSPECT WITH THE INDEXDATA OPTION PANICS AFTER ENCOUNTERING AN INVALID RECORD ID
IC89288 2 INDEX CORRUPTION MIGHT BE INTRODUCED DURING A DATABASE UPGRADE TO DB2 VERSION 10.1
IC92146 2 MULTIPLE DETACH PARTITION FROM THE SAME UNIT OF WORK WILL DEADLOCK WITH EACH OTHER
IC88239 2 MEMORY LEAK IN APPLICATION SHARED HEAP INSERTING INTO PARTITIONED MDC TABLES
IC86929 2 INCREASE CONCURRENCY OF PARALLEL RECOVERY FOR LOG RECORDS ASSOCIATED WITH RECLAIM EXTENTS OPTION OF REORG INDEXES COMMAND
IC91894 2 LOG FULL DURING REORG INDEX(ES ALL) WITH THE CLEANUP ONLY ALL OPTION
IC91709 2 DATABASE MARKED BAD WHILE DROPPING AN INDEX
IC90894 2 POSSIBLE HANG IN INDEX CLEANUP LOGIC WHEN MULTIPLE ASYNCHRONOUS CLEANUP OPERATIONS ARE ACTIVE ON THE SAME TABLE
IC91351 3 CREATION OF LARGE INDEXES OF LARGE INDEXES IS SLOWER THAN EXPECTED WHEN USING THE DB2 PURESCALE FEATURE
IC89543 3 SQLB_EMP_MAP_INFO_NOT_FOUND FROM SQLBPFTRIGGERPREFETCH IN DB2DIAG.LOG
IC93092 3 UPDATE OF UNIQUE COLUMNS MIGHT RESULT IN DUPLICATES IN A TABLE WITH A UNIQUE INDEX
Fix Pack 3  -   Install and Catalog Services
IC91824 1 CONCURRENT CREATE/ALTER TABLE STATEMENTS CONTAINING "GENERATED ALWAYS AS IDENTITY" COLUMN MIGHT END UP WITH AN INFINITE LOOP
IC95081 1 DB2 CRASHES WHEN THREE PART NAME IS USED ON NON-CATALOG NODE.
IC93982 2 WITHOUT UPGRADE_PRIOR_VERSIONS=TRUE, THE UPGRADE IS TREATED AS ANEW INSTALLATION
IC91613 2 V10.1 ONLY: DB2IUPDT COMMAND OVERRIDES FENCEDID BY INSTANCE OWNER IF -U OPTION IS NOT SPECIFIED.
IC89175 2 POSSIBLE ABEND IN SQLOFMBLKEX CALLED FROM SQLNQ_SEQUENCE_REF_BODY
IC91806 2 DB2 INSTALLATION UNDER WINDOWS OS MAY FAIL WHEN EXTENDED SECURITY FEATURE IS ENABLED IN AD ENVIRONMENT.
IC91745 2 DB2CI64.LIB IS MISSING FROM INSTALL IMAGE. ALSO MISSING IN V10 IMAGES AND SO ON.
IC91941 2 DB2IUPGRADE IS FAILING DUE TO DUPLICATE MATCHING RECORDS IN /ETC/SERVICES
IC96262 2 A DEADLOCK MAY OCCUR,IF ALTER SEQUENCE IS EXECUTED AT THE SAME TIME.
IC92405 2 DB2IUPGRADE/DB2IUPDT MAY CAUSE OPERATION TO FAIL WITH "DBI1250E APPLICATIONS ARE STILL USING THE INSTANCE"
IC91038 2 CREATE EVENT MONITOR FAILS WITH SQL0604N ON "BLOB (32) INLINE LENGTH 32"
IC96451 2 THE GRANT COMMAND FOR THE PROCEDURE IS NOT COLLECTED WHEN WE ISSUE THE DB2LOOK COMMAND.
IC91271 2 PERFORMING DB2 BRUTE FORCE UNINSTALLATION DAMAGES GSK 7(IF INSTALLED).
IC91736 2 INSTALL ISO UPDATE OF A FIXPACK FAILS WITH: "PLEASE INSERT THE DISK: 1"
IC86755 2 DB2CKUPGRADE PERFORMANCE IMPROVEMENT FOR TABLE LOAD PENDING CHECK
IC89735 2 DB2LICM -L OUTPUT IS NOT LISTING THE DB2 STORAGE OPTIMIZATION FEATURE LICENSE FOR RESTRICTED SERVER EDITIONS.
IC89957 2 INSTALLING DB2 NON-PURESCALE FAILS ON WPAR
IC89155 2 GPFS UPDATE FAILS DURING DB2 INSTALLATION IF TIVOLI.TSM.CLIENT.BA64.GPFS.BASE IS PRESENT IN THE MACHINE
IC92056 2 IN ENVIRONMENT WHERE CF AND MEMBER IS IN ON LPAR, UPDATING CF ORMEMBER CHANGES INFINIBAND INFORMATION ABNORMALLY.
IC90825 2 DB2IUPGRADE HANGS FOREVER IN THE DB2 ACS UPGRADE STEP WHEN THEREARE SPECIAL FILES LIKE NAMED PIPES LOCATED IN THE ACS DIRECTORY
IC89048 2 DB2IUPGRADE COMPLETES WITHOUT ERROR HOWEVER DOES NOT UPGRADE THEINSTANCE
IC90839 2 DB2PREREQCHK SHOULD DISPLAY WARNING MESSAGES INSTEAD OF ERRORS ONLY FOR /OPT WHEN SPACE REQUIREMENTS ARE NOT MET
IC90783 2 TRAP ON USING VARIABLE OBJECT AFTER UPGRADE TO V10.1
IC90953 2 DB2CKUPGRADE FAILS WHEN THERE IS A CERTAIN DEPENDENCY ON SEQUENCE.
IC96252 2 ENHANCE DB2CAT CATALOG VALIDATION TO CHECK FOR STATISTIC PROFILEINCONSISTENCIES
IC94634 2 THERE MIGHT BE A DOUBLE FREE OR LIST CORRUPTION IN THE SQLRLC_CSM_DEFUNCT() FUNCTION
IC90790 2 DB2UNINS CRASHES FOR MULTIPLE INSTALL AND UNINSTALL ON WIN7 PLATFORM FOR DB2 EXPC PRODUCT
IC92293 2 WLM CONFIGURATION WIZARD FAILS TO START WITH WLM51018E AFTER MIGRATING TO DB2 V10
IC89737 2 "DB2LICM -L" DOES NOT REPORT THE DATABASE PARTITIONING LICENSE EVEN AFTER THAT LICENSE HAS BEEN APPLIED (USING DB2DPF.LIC)
IC89154 2 DB2IUPGRADE OF PURESCALE FAILS IF FENCED USER'S RLOGIN IS NOT SET TO TRUE.
LI77216 2 DB2CKUPGRADE FAILS WHEN THERE IS A CERTAIN DEPENDENCY ON SEQUENCE.
IV37139 2 DB2SETUP FAILS TO UPDATE TSA EFIX WHEN TSA AND RSCT INSTALLED AND MEDIA LEVEL ARE SAME.
IC90505 2 UNABLE TO UPDATE EXISTING V10.1 FIX PACK 2 INSTALLATION ON WINDOWS 8 OR WINDOWS 2012
IC90132 2 DBI1264E ERROR DURING CLIENT INSTANCE UPGRADE USING DB2IUPGRADE COMMAND
IC90161 2 DBI1264E ERROR DURING CLIENT INSTANCE UPGRADE USING DB2IUPGRADE COMMAND
IC84303 2 1603 : ERROR_INSTALL_FAILURE WHEN UPGRADING DB2 9.7 TO DB2 VERSION 10.1 ON WINDOWS (64 BIT)
IC92497 2 DB2 V10.1 IBM DATA SERVER RUNTIME CLIENT INSTALL USING LOCAL SYSTEM ACCOUNT FAILS ON WINDOWS 64-BIT SERVER
IC91904 2 DB2_INSTALL FAILS WITH ERROR : DB2SETUP_EXEC: 15205012 MEMORYFAULT - CORE DUMPED
IC91164 2 DB2IUPDT FAILS WHILE TRYING TO MOVE INSTANCE TO NEWLY INSTALLED FIXPACK LOCATION, IF FIXPACK IS INSTALLED USING UNIVERSAL IMAGE
IC86862 3 DB2ICRT -P OPTION DOES NOT UPDATE THE SVCENAME CONFIGURATION PARAMETER WHEN PORT NUMBER IS A NUMERIC VALUE
IC96397 3 SQL0440N ON SYSIBM BUILT IN FUNCTIONS AFTER RESTORE REPLACE EXISTING OF A DATABASE ONTO A PREVIOUS RELEASE FIX PACK
IC91282 3 DEFAULT IBMDADB2 PROVIDER NOT REGISTERED WHEN INSTALLING IBM DATA SERVER DRIVER OR SWITCHING DEFAULT COPY TO THE DS DRIVER
IC91094 3 DB2VAL GETS "ERROR WHILE LOADING SHARED LIBRARIES"
IC93316 3 DB2IUPGRADE MAY RETURN MISLEADING "CTRL/.INSTUSE" ERRORS BECAUSEIT CHECKS OTHER UNRELATED INSTANCES
IC90512 3 DB2PREREQCHECK OUTPUTS FOR DB2 V10.1 ON WINDOWS 2008 R2 OR WINDOWS 2012 ARE MISLEADING
IC91727 3 DB2_INSTALL WITH "-F NOTSAMP" OPTION FAILS ON HP-UX WITH: UNKNOWN KEYWORD "INSTALL_TSAMP"
IC93074 3 DB2PREREQCHECK DOES NOT SHOW DBT3514W AGAINST 32-BIT C LIBRARY IN THE SUMMARY.
IC93123 3 INSTALLING FIXPACK FOR DB2 CLIENT USING DB2 SERVER OR UNIVERSALIMAGE MAY REPORT A MINOR ERROR RELATED TO TSA.
IC88377 3 DB2 INSTALLATION USING SETUP.EXE WITH -I EN OPTION WITH GERMAN LOCALE OS SETTINGS GETS STUCK AT THE SSH SERVER INSTALLATION PAGE
IC91349 3 THE UNINSTALLER OF 64-BIT DATA SERVER CLIENT/DRIVER DOESN'T REMOVE 32BIT ODBC DATA SOURCES.
IC90691 3 %PATH% ENVIRONMENT VARIABLE VALUE IS CHANGED TO LOWER CASE AFTERDB2 IS INSTALLED ON WINDOWS 7, 2008 R2
IC87176 3 DB2_INSTALL AND INSTALLFIXPACK COMMANDS CANNOT FIND THE DEFAULT FILE LOCATION OF THE NLPACK
IC90152 3 %PATH% ENVIRONMENT VARIABLE VALUE IS CHANGED TO LOWER CASE AFTERDB2 IS INSTALLED ON WINDOWS 7, 2008 R2
IC90574 3 CHANGE TO ENHANCE ERROR MESSAGE REGARDING MINIMUM FREE SPACE REQUIREMENTS FOR INSTALLATION AND INSTANCE CREATE/UPDATE OPERATIONS
IC90300 3 DB2ICRT FAILS TO CREATE INSTANCE, WHILE SYMBOLIC LINKS FROM OTHER DB2 COPY CREATED WITH COMMAND DB2LN EXISTS IN THE SYSTEM
IC89695 3 SQL20005N WHEN CREATING TYPES EVEN THOUGH LIMIT HAS NOT BEEN REACHED.
IC92160 3 WHEN DOING THE REDIRECT RESTORE TO MIGRATE DATABASE FROM V9.7 TOV10.1, RESTORE GENERATED WARNING MESSAGES OF -1704 RC=5
IC88767 3 CHANGE TO REVERT BACK DB2AUTOSTART REGISTRY VARIABLE BEHAVIOUR WITHIN DB2ICRT AS WAS IN DB2 VERSION 9.7
IC90826 3 CREATE OR REPLACE FUNCTION CAN REPLACE A SYSTEM-GENERATED CAST FUNCTION FOR A DISTINCT TYPE
IC90103 3 DB2SETUP FAIL WITH ERROR "TSA BINARY VALIDATION FOR NON SD HAS FAILED" EVEN IF TSAMP FEATURE IS DISABLED
IC91304 3 PACKAGEAUTH CONTAINS RECORDS WITH GRANTEE='SYSIBM' AND GRANTEETYPE='S'
IC92482 3 DB2IUPDT MAY SET DB2AUTOSTART TO YES.
IC89202 3 ADDING A MEMBER/CF USING DB2IUPDT -ADD MAY GENERATE AN ERROR IN THE DB2IUPDT LOG
Fix Pack 3  -   JDBC Driver
IC98624 2 FIXES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ SHIPPED WITH DB2 V101 FIXPACK 3
IC90437 3 TYPE 2 JCC DRIVER CONNECTED TO DB2Z RETURNS SQLFEATURENOTSUPPORTEDEXCEPTION (SQLCODE -4450) ON A SETQUERYTIMEOUT( ) CALL
IC91262 3 USING TYPE 2 JCC DRIVER, INTEGER DATATYPES GET INSERTED WITH INCORRECT VALUES
IC91171 3 INCORRECT PARSING OF TWO SINGLE QUOTES IN A CALLABLE STATEMENT AGAINST Z/OS T4 CONNECTIVITY
IC94485 3 FAILBACK TO PRIMARY DOES NOT OCCUR WHEN USING CLIENT AFFINITIES WITH AFFINITY FAILBACK INTERVAL
IC90686 3 ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN RUNNING AGAINST DB Z/OS WITH PUREQUERY IN STATIC EXECUTION MODE
IC88582 2 -401 RECEIVED FROM DB2 SERVER WHILE UPDATING A SMALLINT COLUMNWITH SETBOOLEAN METHOD
IC92105 3 JCC DRIVER DOESN'T CLOSE NON XA TRANSACTION (WITH AUTO COMMITON) IN CASE OF EXCEPTION IN EXECUTION
Fix Pack 3  -   MQListener
JR47914 2 MAY ENCOUNTER MEMORY ERROR IN DB2DIAG.LOG RANDOMLY WHEN RUNNING MQLISTENER
Fix Pack 3  -   Monitoring
IC92891 1 LOCKING EVENT MONITOR CONTAINS INVALID DATA IN PARTICIPANT_ACTIVITIES WHEN PARTICIPANT IS COMPILING SQL
IC91277 2 DB2 APPLICATION MIGHT BE STUCK IN "COMMIT ACTIVE" STATUS.
IC93638 2 ADMIN_MOVE_TABLE REDIRECT AND CLEANUP OPERATION RETURNS WITH SQL2102N RC33, WHEN IT FAILS TO ACQUIRE THE SEMAPHORE WITHOUT RETRY
IC90281 2 CHANGE HISTORY EVENT MONITOR CAN CAUSE INSTANCE ABEND WHEN USINGLOAD FROM CURSOR WITH LONG SQL
IC91475 2 TRAP IN MON_GET_PKG_CACHE_STMT IN SD OR DPF ENVIRONMENT IF EXECUTING WHILE A MEMBER IS STOPPING
IC90784 2 INSTANCE MAY TRAP WITH SIGSEGV IN MONITORING CODE DURING DATABASE MANAGER SNAPSHOT COLLECTION AND ACTIVE AIC PROCESSING
IC91753 2 ADMIN MOVE TABLE ON TABLE WITH VIEWS - GRANTS NOT PRESERVED ON VIEWS WHEN AUTO_REVAL IS DISABLED OR NO_AUTO_REVAL IS SPECIFIED
IC91616 2 NULL VALUES OR EMPTY STRINGS IN MON_GET_MEMORY_POOL() COLUMN MEMORY_POOL_TYPE
IC89816 2 SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS PERFORMS POORLY FOR TABLE OBJECTS ON LARGE DATABASES
IC91495 2 ACTIVITYSTMT TABLE OF ACTIVITIES EVENT MONITOR DOES NOT CAPTURE SQL STATEMENTS COMPILED USING THE REOPT ALWAYS BIND OPTION
IC89151 2 FILE EVENT MONITOR LEAKS PRIVATE MEMORY WHEN FAILING TO WRITE OUT EVENT HEADER
IC95141 2 THRESHOLD VIOLATIONS EVENT MONITOR IS MISSING DATA FOR SOME COLUMNS
IC93177 2 STOPPING A FILE EVENT MONITOR MAY CAUSE DB2 TO MARK DATABASE BADAND BRING INSTANCE DOWN
IC91279 2 REDUCE INPUT PARAMETER BLOB SIZE OF THE DB2 MONITORING UDFS
IC94180 2 ON A PURESCALE INSTANCE TABLE FUNCTION ENV_GET_SYSTEM_RESOURCES CAN TRAP IF A MEMBER IS IN RESTART LIGHT MODE
IC90794 2 ADMIN_MOVE_TABLE FAILS WITH SQL0206N WHEN RANGE PARTITION KEY REFERS TO A COLUMN NAME GREATER THAN 8 CHARACTERS
IC93056 2 SYSPROC.SNAP_GET_DYN_SQL_V95 MAY SOMETIMES FAILS WITH ERROR SQL0430N
IC91854 2 ADMIN_MOVE_TABLE MIGHT PRODUCE TRAP OR FAIL IF ORIGINAL TABLE HAS MORE THAN 100 REFERENCES
IC90069 2 THE PROCEDURE SYSPROC.ADMIN_MOVE_TABLE STRIPS SPACES FROM OR ADDS SPACES TO THE END OF A TABLE NAME.
IC91855 2 MON_GET_PAGE_ACCESS_INFO() CAN END UP WITH SEGV (CRASH/ABORT) OREVENTUALLY MEMORY CORRUPTION
IC91367 2 INSTANCE MAY TRAP IN DB2 V10.1 WHEN STATEMENT MONITOR IS TURNED ON
IC87633 2 THE GLOBAL FEDERATED SNAPSHOTS WILL FAIL IF FEDERATED APPLICATIONS EXIST ON MORE THAN ON MEMBER IN DPF AND SD ENVIRONMENTS.
IC91440 3 NEGATIVE NUMBER IS RETURNED FOR PROCESSING TIME OR WAIT TIME COUNTER FROM MON_GET TABLE FUNCTION
IC91322 3 MON_GET_INDEX_USAGE_LIST MAY SHOW 0 VALUE FOR OBJECT_INDEX_LBP_PAGES_FOUND AND OBJECT_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP
IC90911 3 DEACTIVATE EVENT MONITOR MAY CAUSE MISLEADING SQLO_INTRP ERRORS ON NON-CATALOG PARTITION IN DB2DIAG.LOG
IC87091 3 SYSPROC.ALTOBJ FAILS WITH -204 ERROR FOR LOWERCASE OBJECT NAMES AND -305 ERROR IN DB2_COMPATIBILITY_VECTOR
IC92831 3 LOCKING TABLE EVENT LOCKING MONITOR SHOULD USE NULL VALUES WHEN DATA IS UNAVAILABLE
IC89502 3 SQLMTABLEITERATOR::EXECUTE SQLM_RC_MON_BUFFER_FULL ERROR MESSAGESHOULD NOT BE RAISED IN DB2DIAG.LOG
IC88745 3 THE UNIT FOR MEMORY_POOL_USED AND MEMORY_POOL_USED_HWM SHOULD BEIN KB
IC96026 3 DYNAMIC SQL SNAPSHOTS MAY EXIT WITH SQLO_DBCSTRUNC ERROR
IC88994 3 CHANGING SQM___DELETE_SQLMON_STMT DB2DIAG.LOG ERROR TO INFORMATIONAL
IC94387 3 MICROSECONDS PORTION IN RESOLUTION_TIMESTAMP IS ALWAYS 0
IC96273 3 DYNAMIC SQL SNAPSHOTS MAY EXIT WITH SQLO_DBCSTRUNC ERROR
IC91715 3 SYSPROC.REORGCHK_IX_STATS STORED PROCEDURE CALL FROM A CLI APPLICATION FAILS WITH SQL0440N
IC93690 3 PARTIAL EVENT MESSAGES LOGGED IN DB2DIAG.LOG FROM EVMON_FORMAT_UE_TO_XML TABLE FUNCTION
IC92325 1 AND, OR OPERATORS MAY CAUSE -104 ERRORS IN PL/SQL INITIALIZER EXPRESSIONS
IC89879 2 SQL0480N WITH ASSOCIATE RESULT SET LOCATORS INSIDE EXCEPTION HANDLER WHEN SQLCODE > 0
IC92134 2 SQL0471N IS RETURNED UPON CALLING LANGUAGE SQL ROUTINES AFTER MIGRATION OF 32-BIT DATABASES TO 64-BIT VERSION
IC89949 2 INSTANCE TRAP IN SQLRXCON_SIMPLE()
IC89606 3 CREATE TYPE STATEMENT FAILS WITH -104 WHEN USING A QUALIFIED OBJECTTYPE VALUE
IC91825 3 "SQLCODE" VARIABLE MAY HAVE AN UNEXPECTED VALUE (0) WHEN A STORED PROCEDURE IS BEING DEBUGGED IN IBM DATA STUDIO.
IC90349 3 SQL0104N WHEN CREATING A VARIABLE CALLED PIPE IN PL/SQL STATEMENT
Fix Pack 3  -   Platform Specific
IC92793 1 THE DB2MSCS UTILITY FAILS TO CLUSTER A DB2 ESE INSTANCE ON WINDOWS SERVER 2012
IC89859 1 DB2 MAY ABEND WHEN USING DB2 TEXT EXTENDERS
IC92158 2 TIMESTAMPS MAY NOT REFLECT DAYLIGHT SAVINGS TIME CHANGES IN CERTAIN SITUATIONS
IC94172 2 DB2 ON AIX UNABLE TO FIND USER WHEN USING TRANSPARENT LDAP.
IC90242 2 EXCESSIVE MEMORY USAGE WITH XML SYSTEM TEMPORARY TABLES
IC90531 2 DB2 WINDOWS MESSAGE : ZRC=0X870F0002=-2029060094=SQLO_BPSE "DEBUG LOGIC ERROR DETECTED" WITH NO FILE SYSTEM CACHE
IC96395 2 SQLOGETFSATTRIB() FAILS TO REPORT THE CORRECT FREE DISK SIZE OF A DISK VOLUME THAT IS ON A JUNCTION POINT.
IC95167 2 TIMESTAMPS MAY NOT REFLECT DAYLIGHT SAVINGS TIME CHANGES IN CERTAIN SITUATIONS
IC94305 2 EXCESSIVE MEMORY ALLOCATION FOR DBMS MEMORY SET ON SOLARIS / SPARC ARCHITECTURE
IC87527 2 DB2START DOES NOT REPORT AN ERROR WHEN DB2CKPWD FAILS TO START IN LOW MEMORY LINUX SERVERS
IC92031 2 POSSIBLE CRASH (ABORT/SEGV) WHEN RUNNING OUT OF MEMORY BECAUSE OF RECURSION CONSUMING UP THE STACK
IC93472 2 STMM UNNECESSARILY DECREASES CONFIGURATION WHEN 0 BENEFIT DETECTED
IC91193 2 DB2VEND PROCESS CAN FAIL TO ATTACH SERVER (DATABASE MEMORY SET) SHARED MEMORY SEGMENT (SQLO_ADDR_CONFLICT IN DB2DIAG.LOG)
IC91288 2 DEADLOCK CAN BE HAPPEN BETWEEN THE IBM INFORMIX CSDK ODBC DRIVERAND THE IBM DB2 DATASERVER DRIVER WHEN USED IN THE SAME APP
IC89716 2 A VALID DOMAIN USER OF A DOMAIN GROUP WITH CONNECT PRIVILEGE GETS CONNECTION DENIED IN CASE OF GERMAN CHARACTER
IC94382 2 STORED PROCEDURES RANDOMLY FAILS WITH ERROR SQL1124N
IC96276 2 WINDOWS ONLY: DB2PD WITH DB OPTIONS MIGHT RETURN BLANKS ONLY.
IC90190 2 PARALLEL MODE OF DB2_ALL AND RAH CAN LEAVE PROCESSES LOOPING FOREVER SINCE DB2 V9.7 FP6, REGRESSION OF APAR IC81335
IC91228 2 AFTER A CRASH IN TSMAPI64.DLL, SUBSEQUENT DB2START FAILS.
IC91287 2 SQLE_ZRC_CTX_NO_CTX MIGHT BE REPORTED IN DB2DIAG.LOG
IC90501 3 OSSGETDISKINFO REPORTS THE ERROR MESSAGE IN DB2DIAG.LOG ABOUT FILESYSTEMS NOT RELATED TO DB2
IC89705 3 ENABLE_MQFUNCTIONS UTILITY SHOWS UNSUPPORTED PARAMETER "-Q" IN USAGE MESSAGE
IC89615 3 DB2 TRAPPED IN SQLOFREEOSSINTERNALMEMORY
IC92555 3 A FAILURE TO START DB2VEND PROCESS MIGHT RESULT IN SELF-KILLING OF AN INSTANCE
IC87160 3 EXPORT TO PIPE MAY FAIL WITH ERROR SQL3001C
IC91542 3 OVERRIDE VIRTUAL AND OTHER USER LIMITS FOR DB2CKPW DAEMON IN LOWMEMORY LINUX SYSTEMS
IC96271 3 STMM ON 32-BIT INSTANCE PLATFORM MAY FAIL TO UPDATE PCKCACHESZ WHEN IT IS WORKING ON 64-BIT WINDOWS
IC91409 3 WLM THREADS LOSING THEIR ELEVATED PRIORITY WHEN USING DB2_RESOURCE_POLICY FILE WITH SCHEDULING_POLICY ELEMENT
IC91810 3 WLM THREADS LOSING THEIR ELEVATED PRIORITY WHEN USING DB2_RESOURCE_POLICY FILE WITH SCHEDULING_POLICY ELEMENT
IC91728 3 IN DPF ENVIROMENT, DB2 INSTANCE MIGHT BE CRASH (SEGV/ABORT) DURING DB2START
IC96279 3 DB2MSCS FAILS WITH ERROR "THE OBJECT ALREADY EXISTS" WHEN ATTEMPTING TO CREATE A NETWORK SHARE THAT ALREADY EXISTS.
IC91913 3 PREVENT MESSAGE FROM FUNCTION STMMSIMULATEHJPACKPARTITIONS, PROBE:3555, FROM BEING DUMPED INTO DB2DIAG.LOG
IC91703 3 DB2PD -LATCHES OR -APINFO MAY RETURN NO DETAILS IF HOST HAS MULTIPLE ENTRIES IN THE /ETC/HOSTS FILE
IC91758 3 DB2 REPORTS NUMBER OF PROCESSOR CORES WITH INTEL HYPERTHREADING INCORRECTLY (CONTINUATION OF IC81317 )
Fix Pack 3  -   Problem Determination
IC91705 2 DB2DART /RHWM COMMAND FAILS AND REPORTS ERRORS AS IT IS TRYING TO ACCESS NONEXISTING PAGE.
IC94545 2 IN SOME CASES CALLING 'USER-SPECIFIED PROFILE' FROM DB2SUPPORT MAY CAUSE SCRIPT TIME-OUT REGARDLESS OF THE SETTING OF 'TIMEOUT'.
IC87014 2 DATABASE MEMORY SET ID DISPLAYED BY DB2PD -MEMSETS IS NOT CORRECT
IC93170 2 EXCESSIVE MEMORY GETS UTILIZED BY PD_GET_DIAG_HIST
IC91670 2 DB2DART TRUNCATES DBPATH NAMES CONTAINING BLANKS ON WINDOWS AND LINUX
IC91765 2 -MEMBER/-DBP PROBLEMS FOR DB2FODC COMMAND ON DPF
IC91757 2 THE DATABASE FIELD (DB : <DBNAME>) MAY NOT BE RECORDED IN DB2DIAG.LOG FOR EDU: DB2LOGGW ( DATABASE LOG WRITER )
IC90716 2 IN SOME RARE CIRCUMSTANCES THE PD_GET_DIAG_HIST() TABLE FUNCTIONMAY HANG.
IC89927 2 DB2TRC FAILS WHILE LOADING SHARED LIBRARIES LIBCA_API.SO
IC91747 2 DUMP 'DB2PD -DPSDBCD' DATA AND 'DB2PD -DPSPRCB' DATA BY 'DB2FODC-HANG' COMMAND
IC91488 2 DB2SUPPORT -D <DB_NAME> MIGHT HANG BECAUSE OF LOCK HELD BY OTHERAPPLICATIONS ON SYSTEM CATALOG ROWS/TABLES
IC89731 2 PREVENT DB2DART FROM ACCEPTING POOL RELATIVE PAGE ADDRESSES
IC94153 2 TABLE FUNCTION SYSPROC.PD_GET_DIAG_HIST MAY TRAP WITH SIGSEGV WHEN START_TIME/END_TIME PARAMETERS ARE PROVIDED
IC91823 2 CLEANUP OF MESSAGES QUEUES USED TO COMMUNICATE WITH DB2AUD WHEN PROCESS INTERRUPTED BY USER
IC96393 2 SYSPROC.PD_GET_LOG_MSGS FUNCTION CAN FAIL WITH SQL0430N / SQLSTATE=38503
IC94011 2 DB2TOP COLLECTOR MODE (-C) STOPS IF 2GB OUTPUT FILE SIZE IS REACHED
IC91251 2 DB2PD AND DB2PDCFG COMMANDS TERMINATE ABNORMALLY WHEN DB2AUDIT IS ENABLED ON WINDOWS PLATFORM
IC93932 2 DB2 INSPECT: SPACE MAP PAGE INVALID PAGE STATES FOR EXTENT AT LOCATION <NNNN> IN THE SPACE MAP PAGE, EXTENT CONTAINS USED AND NO
IC92866 2 SEND SIGINT, [CTRL]+[C] TO DB2PD MAKES NO NEW CONNECTION
IC94224 3 DB2DART FAILING TO RUN WITH SQLSPCS FILES MORE THAN 2G SIZE
IC95078 3 FFDC IMPROVEMENTS IN PARTITIONED ENVIRONMENTS
IC91799 3 WHEN QUITTING DB2TOP INTERACTIVE MODE USING INTERRUPT KEY '^C', TRAP FILE (*.APP_TRAP.TXT) IN 0 BYTE WILL BE GENERATED.
IC96261 3 PROBLEM WITH HANDLING "\R" CARRIAGE RETURN ON WINDOWS DURING PARSING DB2SUPPORT.PROFILE FILE.
IC93949 3 DB2NODES RELATED ERRORS DURING DB2SETUP/DB2ISETUP
IC91659 3 DB2DART IS NOT DUMPING THE REFERRING PAGE IN AN INDEX CORRUPTIONDETECTION
IC88212 3 WHEN QUITTING DB2TOP INTERACTIVE MODE USING INTERRUPT KEY '^C', TRAP FILE (*.APP_TRAP.TXT) IN 0 BYTE WILL BE GENERATED.
IC90056 3 DB2SUPPORT TOOL WHILE RUNNING IN OPTIMIZER MODE DOESN'T CLEANUP ALL EXPLAIN TABLES
IC91735 3 THE FUNCTION PDEDUISINDB2KERNELOPERATION MAY DETERMINE COMPONENTINCORRECTLY
IC96392 4 KERNEL TID FIELD IS CONCATENATED WITH PREVIOUS TID FIELD IN DB2PD -EDU OUTPUT
Fix Pack 3  -   Process Model
IC88925 1 ON LARGE DPF SYSTEMS, DB2START MAY FAIL WITH SQL0901 ON SOME MEMBERS DUE TO INSUFFICIENT FCM MEMORY
IC91808 2 CALLS TO SQLF_FIX_DBM_CFG BY DOWNLEVEL CLIENT CAN RESULT IN EACCESS IF USER DOESN'T HAVE WRITE PERMISSION TO DB2SYSTM
IC96337 2 DB2STOP FORCE HANGS WHEN INSTANCE IS QUIESCED IN RESTRICTED ACCESS
IC91909 2 DB2 TRAPPED WITH SIGSEGV IN SQLTGETS
IC93744 2 REGRESSION WITH WSDBU0094097; SQLOCLOSE FAILS WITH INVALID FILE HANDLE DURING FIRST CONNECT ON MEMBER SINCE WE ATTEMPT TO CLOSE
IC89727 2 HEALTH MONITOR MAY GET WRONG ACTIVE LOG FILE NUMBER WHEN ONLINE BACKUP WAS ISSUED AND MISTAKENLY ASSUMED FLIPPED OVER BY LOGGING
IC90884 2 DB2 V10.1 DB2INSTANCESTOP() API IS NOT DOWNLEVEL COMPATIBLE, DB2STOPOPTIONSSTRUCT WAS CHANGED
IC90961 2 TRAP IN SQLODSHR CALLED FROM SQLESUBCOORDTERM
IC84775 2 ENABLE NAMED LIST SUPPORT TO ADDRESS SCALABILITY OF DB2 PAGE DELETION FROM THE CLUSTER CACHING FACILITY
IC96272 2 DB2 INTERMITTENTLY CRASHES WITH A MEMORY CORRUPTION WHEN CALLINGSQLERGETFMPIPC
IC91276 2 ON A GATEWAY ENVIRONMENT, CONNECT TO A DATABASE MIGHT FAIL AND THE DATABASE WILL BE MARKED BAD
IC89704 2 DB2PD CAUSED STACK OVERFLOW
IC88374 2 UNCATALOGED STORED PROCEDURE CALLS FROM APPLICATION FAIL INTERMITTENTLY WITH SQL CODE -9999
IC89736 2 FMP TRAP ON SQLOXLTC_APP EXECUTING SYSPROC.SNAP_GET_DB_V97
IC91285 2 DB2 INSTANCE PANICS IN SETUPCTLMSGTARGETS WHEN TRYING TO ACTIVATE EVENT MONITOR WRITERS.
IC96278 2 DB2 MIGHT ENCOUNTER "MEMORY CORRUPTION" ERROR AND THEN PANIC
IC90085 2 FCM_PARALLELISM DBM CFG PARAMETER DOES NOT WORK AS EXPECTED IN DB2 V10.1
IC87355 2 DB2FMP DUMPS A CORE FILE OR CONSUMES CPU USAGE RARELY.
IC91772 2 ACTIVITYTOTALTIME THRESHOLD VALUE BREACHED BUT NOT RECORDED IN THRESHOLD VALUE TABLE
IC91242 2 SQL0973 NO MEMORY IN PACKAGE CACHE WHEN USING INSUFFICIENT FIXEDDATABASE MEMORY SETTING
IC93952 2 THE DB2 INSTANCE MAY HANG OR TRAP ON LINUX WHEN USING A HIGH NUM_INITAGENTS SETTING
IC90789 2 RESTORE DB2_VENDOR_INI REGISTRY VARIABLE
IC89712 2 FENCED WRAPPER GETS HANG SPORADICALLY AFTER -1131 ERROR
IC92927 2 UNNECESSARY INCREASE IN DBMS SET SIZE IN VERSION 10 FOR WORKLOADDISPATCHER
IC91883 2 SYSIBMADM.DBCFG NOT DISPLAYING FLAGS AND DEFERRED FLAGS VLAUE COMPUTED
IC90996 2 SQL0952N : INCORRECT TIMEOUT VALUE OF -1 LEADS TO NODE FAILURES AND INTERMITTENT "LOG STATE MARKED BAD" ERRORS
IC91361 3 SQLCODE -1229 RECEIVED ON DB2LUSED CONTINUOSLY EVEN AFTER A LOT OF TIME HAS PASSED AFTER THE LAST NODE RECOVERY
IC91476 3 INCORRECT PERMISSIONS ON DB2NODES.CFG FILE AFTER FAILOVER
IC90391 3 FOR A NONE PURESCALE INSTANCE, DB2 SHOUD NOT DISPLAY THE VALUE FOR RSTRT_LIGHT_MEM.
IC91759 3 INCORRECT MESSAGE IS DISPLAYED WHEN 'DB2 UPDATE DBM CFG ' IS ISSUED WITHOUT ATTACHING TO INSTANCE
IC96380 3 DB2 PURESCALE WILL NOT START ON REDHAT VERSION 6 IF HOSTNAME IN DB2NODES.CFG AND OUTPUT OF HOSTNAME COMMAND DO NOT MATCH.
IC88874 3 FMP ROUTINE HISTORY BUFFER IS LEAKED ON FAILED FMP STARTUP OR ONTHREADED FMP TERMINATION
IC91720 3 SQL0804N MAY BE RETURNED WHEN A WLM SQLROWSREAD THRESHOLD IS VIOLATED.
Fix Pack 3  -   Quality Assurance
IC92518 2 INSTANCE MIGHT CRASH IF A QUERY THAT FEATURES A SORT IS RE-EXECUTED AFTER IT PREVIOUSY RECEIVED SQL0973.
IC91333 2 XQUERY MAY RETURN INCORRECT RESULT WHEN WHERE CLAUSE PREDICATE HAS CERTAIN FORMAT AND XML INDEX IS USED
IC91770 3 DB2CAEM RETURNS SQL0104 WHEN SQL HAS SINGLE QUOTE
Fix Pack 3  -   Query Compiler Optimizer
IC91811 1 DB2 CAN TRAP WHEN COMPILING A SUB-QUERY THAT IS APPLIED ON XMLQUERY()
IC91848 2 INSTANCE CRASH WHEN DATABASE MANAGER HAS INTRA_PARALLEL SET TO "ON" AND MAX_QUERY_DEGREE IS GREATER THEN 1 OR IS "ANY"
IC95207 2 DB2 COMMAND EDITOR CRASHES WHILE RUNNING VISUAL EXPLAIN
IC91751 2 OPTIMIZER MIGHT CHOOSE NON-OPTIMAL JOIN IN PRESENCE OF CYCLES WHEN DB2_REDUCED_OPTIMIZATION=JOIN IS SET
IC91683 2 SQL0901 ERROR IN DPF WHEN COMPILING A QUERY WITH AN EQUALITY PREDICATE REFERENCING A NULL CONSTANT
IC91291 2 DB2 CAN RETURN A SQL0901N ERROR WITH REASON "SQLNO_ITR_PLAN::NEXT [300]:RC( 0)"
IC92065 2 DB2 CAN TRAP IN SQLRIZZDIMMAX1RUNTIME
IC90915 2 DB2 CAN TRAP IN SQLNO_ZZ_STARJN_COMPUTE_INDEX_QUNS_REFD
IC91223 2 INACCURATE DENSITY AND SEQUENTIAL_PAGES STATISTICS FOR PARTITIONED INDEXES MIGHT LEAD TO NON-OPTIMAL ACCESS PLANS
IC93059 2 RANGE PARTITIONED TABLES DEFINED WITH A NULLS FIRST PARTITIONINGCOLUMN MIGHT RETURN INCORRECT RESULTS
IC93787 2 AUTOMATIC REORG RETURNS SQL2220W ON REORG OF EMPTY COMPRESSED TABLE AND DICTIONARYOPTION="REBUILD"
IC89725 2 DB2ADVIS CAN PRODUCE A RECOMMENDATION OF UNIQUE INDEXES ON SYSTEM-MAINTAINED MQTS
IC96008 2 UNDER RARE CIRCUMSTANCES A QUERY MIGHT FAIL WITH -901 WHEN COMPILING IN SMP
IC91955 2 UNDER RARE CONDITIONS, AUTOMATIC STATISTICS COLLECTION MIGHT NOTOCCUR DUE TO LOST UDI INFORMATION
IC91884 2 "EDU HAS BEEN SUSPENDED" MESSAGE IS RETURNED WHEN USING 'COL IN (...)' PREDICATE
IC91769 2 AUTOMATIC RUNSTATS MIGHT NOT EVALUATE A TABLE IF DATABASE DEACTIVATION OCCURRED WHILE THE TABLE WAS BEING PROCESSED.
IC92016 2 SQL0901 ERROR WHEN EXECUTING AN SQL STATEMENT ELIGIBLE FOR ZIGZAG JOIN STRATEGY
IC89492 2 DB2RUNSTATS API CAN FAIL WITH SQL1197N OR UNEXPECTEDLY EXECUTE WITH INDEX SAMPLING
IC89696 2 LOAD WITH STATS COLLECTION MIGHT GENERATE NLEVEL VALUE AS 0 IN CERTAIN SCENARIO FOR PARTITIONED INDEXES.
IC90321 2 COMPILING CERTAIN SQL STATEMENT IN DPF CAN TAKE A LONG TIME OR RESULT IN SQL0101N
IC90009 2 SMALL PRIVATE MEMORY LEAK ON THE DB2 SERVER EVERY TIME AN OPTIMIZATION PROFILE IS LOADED
IC93132 2 DB2 GET RECOMMENDATIONS FOR HEALTH INDICATOR DB.TB_REORG_REQ ON DATABASE RETURN WRONG RESULTS
IC91281 2 AUTO_RUNSTATS MIGHT TERMINATE EARLY IN FEDERATED DATABASES THAT HAVE BOTH NICKNAMES AND LOCAL TABLES WITH STATISTICS PROFILES
IC91294 2 IN A DPF ENVIRONMENT THE COLLECTION OF SECTION ACTUALS MIGHT SHOW "NA" AT SOME OPERATORS IN THE EXPLAIN OUTPUT
IC93543 2 EXECUTION OF A QUERY USING DB2 TEXT SEARCH MIGHT BE SLOW
IC87037 2 DB2 MIGHT HANG WHILE COMPILING AN SQL STATEMENT ELIGIBLE FOR ZIGZAG JOIN STRATEGY.
IC96285 2 DB2ADVIS MAY FAIL WITH SQL0304N WHEN PROCESSING LARGE INPUT FILES
IC92454 2 A SELECT STATEMENT WITH A PREDICATE 'IN ( ITEM-1, ITEM-2, ... ITEM-N )' MIGHT CRASH THE DB2 SERVER
IC89701 2 CREATE INDEX COLLECT STATISTICS CAN GENERATE INCORRECT EXTERNAL INDEX STATISTICS
IC94478 2 OPTIMIZER COMPUTES INCORRECT CARDINALITY ESTIMATE IN PRESENCE OFSTATISTICAL VIEW WITH OVERLAPPING COLUMN GROUP STATISTICS
IC91299 2 ASYNCHRONOUS RUNSTATS REQUESTS MIGHT BE LOST IN DPF ENVIRONMENTSFOR TABLES THAT DO NOT RESIDE ON THE CATALOG DATABASE PARTITION
IC87969 2 EXECUTION OF SQL STATEMENT WITH DBPARTITIONNUM IS NOT PARALLELIZED WHEN USING TABLE OR LATERAL CONSTRUCT IN DPF
IC91749 2 OPTIMIZER MIGHT CHOOSE A SUB-OPTIMAL ACCESS FOR TABLE WITH THE SAME SINGLE COLUMN RANGE PARTITIONING KEY AND DISTRIBUTION KEY
IC91760 2 A QUERY WITH CORRELATION AND FLOWING XML DATA MIGHT PRODUCE INCORRECT RESULTS.
IC89724 2 IN DPF, XML QUERIES INCLUDING XMLTABLE EXPRESSIONS USING BIND-INHOST VARIABLES CAN RESULT IN BADPAGE ERROR DUE TO A BAD EXECUTI
IC91954 2 UNDER RARE CONDITIONS, AUTOMATIC STATISTICS COLLECTION CAN LEAD TO AN ACTIVE LOG FULL CONDITION.
IC89505 3 AUTOREORG USES INDEX REBUILD OPTION AGAINST PURESCALE SERVER RESULTING IN SQL1419
IC91418 3 USER-DEFINED FUNCTION WITH INDEX EXTENSION EXPLOITATION MIGHT RETURN INCORRECT RESULTS IF INDEX IS NOT PRESENT
IC90427 3 SYSCAT.COLUMNS.NUMNULLS STATISTICS MIGHT BE INACCURATE AT ALL TABLE SAMPLING RATES.
IC96274 3 RUNSTATS ON XML COLUMNS PRODUCES INAPPROPRIATE WARNING LEVEL DIAGNOSTIC MESSAGES.
IC92610 3 DB2 MIGHT TRAP WHILE COMPILING AN SQL STATEMENT ELIGIBLE FOR STAR JOIN
IC96244 3 PAGE_FETCH_PAIRS AND AVGPARTITION_PAGE_FETCH_PAIRS STATISTICS CANNOT BE CLEARED BY MANUAL UPDATE IF VARCHAR2 COMPATIBILITY IS ON
IC90180 3 RUNSTATS SAMPLING MIGHT BEHAVE INCORRECTLY IN DPF ENVIRONMENTS
Fix Pack 3  -   Query Compiler QGM
IC90517 1 ERROR SQL0171N WHEN CASTING DBCLOB COLUMN INTO CHAR OR VARCHARUSING SCALAR FUNCITON
IC95130 1 MERGE STATEMENT WITH ONLY MATCHED CONDITION AND DISTINCT MIGHT LEAD TO PERFORMANCE DEGRADATION
IC91784 1 ERROR SQL0171N WHEN CASTING DBCLOB COLUMN INTO CHAR OR VARCHARUSING SCALAR FUNCITON
IC92765 1 CREATING STORED PROCEDURES FROM APPLICATIONS CONCURRENTLY CAN CAUSE DB2 TO CRASH
IC91301 1 A PREDICATE USING CONTAINS FUNCTION ON A COLUMN DERIVED FROM A UNION ALL OPERATION MIGHT RETURN SQL0901N
IC93791 1 DB2 CRASH CAUSED BY PACKED DESCRIPTOR INCONSISTENCY AFTER ALTER TABLE SET TYPE BLOB/CLOB
IC91504 2 AN INSERT, UPDATE OR DELETE STATEMENT ON A TABLE WITH ROW AND COLUMN ACCESS CONTROL ENABLED MAY RESULT IN SQL901N OR SQL1224N.
IC90310 2 DB2 MIGHT ABEND WHEN A QUERY CONTAINS A VERY LARGE NUMBER OF LITERALS/PARAMETER MARKERS/HOST VARIABLES
IC92118 2 INSTANCE CRASH IF A QUERY CONTAINS A SUB-SELECT STATEMENT WHICH INCLUDES ONE OR MORE OLAP FUNCTIONS
IC91293 2 DB2 MIGHT ABEND WHILE EXECUTING A COMPOUND SQL STATEMENT
IC96288 2 ALTER TABLE STATEMENT REFERENCING A TABLE NAME CONTAINING TRAILING SPACES MIGHT PRODUCE SQL0901N
IC91729 2 INCORRECT SYNTAX COMBINATION OF CAST AND DATE FUNCTIONS SUCH AS DAYS, MINUTES ETC CAN CAUSE COMPILER CRASH INSTEAD OF SQL0104
IC92227 2 MEMORY LEAK IN COMPILER MEMORY POOL WHEN COMPILING A SQL QUERY THAT REFERENCES A FEDERATED DATA SOURCE
IC89749 2 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ROWID IS REFERENCED IN A TRIGGER
IC92082 2 POOR QUERY PERFORMANCE IF JOIN PREDICATE APPLIED TO THE FIRST AND LAST COLUMNS OF AN INDEX WITH INTERMEDIATE LOCAL PREDICATES
IC96263 2 QUERY WITH XQUERY/XPATH OPERATORS MAY RUN SLOWER WHEN UPGRADING FROM VERSION 9.5.
IC91788 2 IN2JOIN OPTIMIZATION GUIDELINE IS NOT APPLIED TO REWRITE IN PREDICATE TO A JOIN
IC88128 2 DB2 MIGHT ABEND WHILE COMPILING QUERY WITH MULTIPLE OUTER JOINS AND IS NULL PREDICATE
IC88178 2 -901 ERROR MAY OCCUR WHILE REVALIDATING ROUTINE WITH UNUSED CTE,FOLLOWED BY INSTANCE TRAP AT SQLNQ_FTB.
IC93193 2 AN OUTER JOIN ON A UNION ALL VIEW MIGHT RESULT IN SQL1585N ERROR
IC96253 2 DB2 MAY ABEND WHILE COMPILING QUERY HAVING NESTED OR PREDICATE WITH (NOT) EXISTS SUBTERM
IC89723 2 QUERY WITH OLAP FUNCTION AND SET OPERATIONS MIGHT PRODUCE SQL0901N
IC86717 2 PREDICATES MIGHT NOT BE PUSHED DOWN FOR QUERY CONTAINING UNION ALL AND MULTIPLE NESTED SUBQUERIES
IC91273 2 SLOWER QUERY PLAN CAN BE MADE ON VARCHAR2 COMPABILITY DB IF EQUALITY JOIN PREDICATES ON CHAR OR GRAPHIC COLS WITH HOST VARIABLES
IC89730 2 POSSIBLE PERFORMANCE REGRESSION FROM SCALAR SUBQUERY PUSH DOWN INTO OUTER JOIN
IC89913 2 UNEXPECTED OPTIMIZED STATEMENT FOR VIEW
IC91395 2 THE QUERY COMPILER CAN ASSUME A DEFAULT CARDINALITY FOR A CGTT
IC91303 2 REMOVE REDUNDANT SUBTERM PREDICATE FROM AN OR PREDICATE
IC91738 2 PREDICATE SELECTIVITY CLAUSE MAY NOT TAKE EFFECT IN LEFT OUTER JOIN QUERY
IC94331 2 CREATE FUNCTION FAILS WITH SQL0109 WHEN QUERY INCLUDES "WITH UR"
IC90636 2 DATABASE SYSTEM ERROR 'SQLCODE=-901, SQLSTATE=58004' MAY OCCUR WHILE CREATING PL/SQL PACKAGES
IC89458 2 DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF SIMPLE SINGLE-ROW MERGE STATEMENT
IC89846 2 TABLE MAY INHERIT WRONG COLLATION FROM A CATALOG TABLE OR VIEW
IC91051 2 EXCEPTIONALLY LONG COMPILATION TIME WHILE QUERY CONTAINS GROUPING SETS, ROLLUP OR CUBE
IC88658 2 QUERY CONTAINING "NOT IN" PREDICATE WITH A PARAMETER MARKER MIGHT CAUSE DB2 TO ABEND
IC90465 2 PERFORMANCE DEGRADATION MIGHT BE NOTICED WITH NOT EXISTS SUBQUERY WITH MULTIPLE TABLES.
IC92697 2 DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING A QUERY WITH DATETIME PREDICATES
IC89937 2 A MERGE STATEMENT AGAINST AN ALIAS MAY CAUSE DB2 SERVER TO TERMINATE ABNORMALLY
IC94360 2 QUERY CONTAINING EXISTENTIAL SUBQUERIES WITH MULTIPLE TABLES MIGHT HAVE PERFORMANCE DEGRADATION
IC91229 2 SQL FUNCTION DEFINER NOT GIVEN WITH GRANT OPTION (CAN LEAD TO ERRORS LIKE SQL0551N ON LATER GRANT)
IC89714 2 POSSIBLE ABEND DUE TO DOUBLE FREE IN STMTHEAP MEMORY WHEN COMPILING A COMPLEX QUERY WITH MULTIPLE GROUP-BY SUBQUERIES
IC89297 2 QUERIES WITH A NOT EXISTS OR NOT IN PREDICATE, AND A PREDICATE REFERENCING GENERATED COLUMNS MAY CAUSE SQL0901N
IC89237 2 QUERY CONTAINING MULTIPLE EQUIJOIN PREDICATES MIGHT FAIL WITH SQL0901N
IC96264 2 FED:FEDERATED QUERY WITH A LARGE AMOUNT OF COLUMNS COULD EXPERIENCE LONG TIME COMPILATION
IC88197 2 QUERY WITH LEFT OUTER JOIN AND IS NULL PREDICATE MIGHT FAIL WITHSQL0901N
IC90174 2 REROUTING A QUERY TO MQT MAY RETURN INCORRECT RESULT
IC91812 2 QUERY CONTAINING EXISTS SUBQUERY AND FETCH FIRST N ROWS CLAUSE MIGHT PRODUCE INCORRECT RESULTS
IC89750 2 SQL20253N RETURNED WHEN MULTIPLE UPDATES ON THE SAME COLUMN FOR COMPILED TRIGGERS
IC84206 2 QUERIES USING OUTER JOINS AND SCALAR SUBQUERY RUNS SIGNIFICANTLYSLOWER COMPARING TO OUTER JOINS AND LOCAL PREDICATES
IC89439 2 QUERY MIGHT FAIL WITH SQL0901N - BAD PLAN, UNRESOLVED QNC FOUND
IC95053 2 THE QUERY STATEMENT WITH A SUBQUERY PREDICATE MIGHT NOT RETURN ROWS AFTER ENABLING DB2_COMPATIBILITY_VECTOR=ORA
IC89491 2 SQL0206N ERROR REFERENCING COLUMN RETURNED FROM A ASSOCIATIVE ARRAY OR RECORDS ORACLE COMPATIBILITY MODE
IC87433 2 AFTER DATA TYPE IS ALTERED ON A COLUMN WITH DEFAULT VALUE, DDLS AND DMLS MIGHT FAIL WITH SQL0901N "BAD DEFAULT"
IC94328 2 DATABASE UPGRADE FAILS WITH SQLCODE -727 SQLSTATE=56098
IC89912 2 UNEXPECTED OPTIMIZED STATEMENT FOR VIEW
IC91783 2 PERFORMANCE DEGRADATION WHEN SEQUENCE IS PRESENT IN THE SELECT LIST COLUMN
IC91690 2 QUERY WITH NUMEROUS PARAMETER MARKERS IN AN IN LIST HANGS DURINGCOMPILATION
IC91809 2 DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF SIMPLE SINGLE-ROW MERGE STATEMENT
IC96254 2 LOCAL PREDICATES MAY NOT BE PUSHED DOWN BELOW A UNION OPERATOR WHEN THE UNION OPERATOR IS REFERENCED MORE THAN ONCE.
IC94359 2 QUERY WITH EXISTS OR EXISTS PREDICATES MIGHT HAVE PERFORMANCE DEGRADATION
IC96232 2 QUERY ON VARCHAR2 ENABLED DATABASE DOES NOT USE INDEX SCAN
IC96265 2 DB2 MIGHT PRODUCE SQL0901N WHEN USING RATIO_TO_REPORT OLAP FUNCTION
IC91296 2 DB2 MAY ABEND WHILE COMPILING QUERY THAT CONTAINS THE QUARTER FUNCTION
IC91804 2 SET VARIABLE STATEMENT MAY CAUSE DB2 TO TERMINATE ABNORMALLY.
IC91876 2 COLUMN OF XML TYPE WITH INLINE LENGTH OPTION MIGHT CAUSE MEMORY CORRUPTION
IC88471 3 SQL0901N ERROR MAY BE RETURNED WHEN CREATING AN INDEX ON A USER-DEFINED TEMPORARY TABLE.
IC90170 3 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ROWID IS USED IN AN INSERT OR UPDATE STATEMENT
IC90500 3 QUERY WITH NOT EXISTS PREDICATES MIGHT HAVE PERFORMANCE DEGRADATION
IC91723 3 XMLTABLE() RETURNING MULTIPLE XML NODES MAY RETURN SQL16003N
IC90093 3 QUERY CONTAINING AN ORDER BY CLAUSE REFERENCING AN AGGREGATE FUNCTION MIGHT PRODUCE A SQL0901N
IC96280 3 DIFFERENT BEHAVIOUR IN DB2 WHEN USING ORACLE SYNTAX "CONNECT BY NOCYCLE LEVEL"
IC90655 3 DB2 SERVER TERMINATES ABNORMALLY COMPILING A QUERY WITH EXTENDEDINDICATORS ENABLED
IC91787 3 VALUES STATEMENT CONTAINING THE VALUE NULL MIGHT RETURN SQL901N IN THE PARTITIONED DATABASE ENVIRONMENT
IC89708 3 DB2 RETURNS -901 FOR TARGET TYPE IS NOT TYPED WHEN COMPILING MERGE STATEMENT
IC94356 3 TO_CHAR( CHARACTER-EXPRESSION, FORMAT-STRING ) RETURNS SQL20447NIN VARCHAR2 COMPATIBILITY MODE
IC92186 3 TRANSLATE FUNCTION RETURNS WRONG DATA TYPE WITH MIXED GRAPHIC/NON-GRAPHIC ARGS
IC89584 3 DB2 IS ALLOWING PL/SQL ROUTINES TO BE CREATED WHEN VARIABLES FORTHE CURSOR DO NOT MATCH THOSE IN THE FOR LOOP.
IC90071 4 OUTER JOIN PREDICATE ON EXPRESSIONS USING THE HASH JOIN MIGHT RETURN SQL0901N
Fix Pack 3  -   Relational Data Services
IC92080 1 INSTANCE TRAP IN SQLRR_RDS_COMMON_POST
IC95794 1 DB2 MAY HANG WHEN -901 ERROR IS ENCOUNTERED, YOU WILL SEE MESSAGE "APPLICATION IS ALREADY QUEUED BY A THRESHOLD"
IC91781 2 CALLING A STORED PROCEDURE FROM DB2 V9.7 FP 4 AND HIGHER FIXPACKLEVEL DATABASE SERVER MAY HIT SQL0727N SQLCODE "-7" ERROR
IC94161 2 PERFORMANCE HIT WHEN A GLOBAL VARIABLE IS FIRST REFERENCED IN A SESSION
IC94988 2 "MEMORY LEAK" ISSUE IN PACKAGE CACHE.
IC91307 2 TRANSACTIONS THAT PERFORM IMPLICIT REBINDS CAN CAUSE LOCK WAITS TO OTHER CONNECTIONS DUE TO CATALOG CACHE AND CATALOG LOCKS
IC92602 2 INSTANCE MAY TRAP WITH SEGMENTATION VIOLATION WHEN COMPILATION FAILS DURING IMPLICIT REBIND
IC92106 2 DB2 INSTANCE MIGHT TRAP IF A USER REBINDS A PACKAGE WITHOUT HAVING EXECUTE PRIVILEGE ON IT.
IC96450 2 RUNSTATS SAMPLING MIGHT BEHAVE INCORRECTLY IN DPF ENVIRONMENTS
IC93173 2 PD_GET_DIAG_HIST MAY HIT ERROR "DIA8301C NO MEMORY AVAILABLE IN THE APPLICATION HEAP"
IC91858 2 DURING IMPLICIT REBIND OF AN INOPERATIVE PACKAGE SQL0572 MAY BE RETURNED WHEN AUTO_REVAL = DISABLED
IC91180 4 USING ALL TEN PARAMETERS FOR DB2RBIND RESULTS IN SYNTAX ERROR
IC91952 4 SQL0119N RETURNED WHEN SQLCA USES DIFFERENT PARAMETER MARKERS FOR THE SAME CONSTANT
Fix Pack 3  -   Replication
JR47306 2 WHEN "ENDMQM -W" IS ISSUED, NEITHER CAPTURE, MQ, NOR THE ENDMQM COMMAND EXITS
JR47307 2 WHEN RESTARTING QCAPTURE WHEN AN INVALID SUBSCRIPTION IS ALREADYIN TRANSITION, QCAPTURE COMES DOWN
Fix Pack 3  -   Security
IC94434 1 SECURITY: DENIAL OF SERVICE VULNERABILITY IN DB2's FAST COMMUNICATIONS MANAGER. (CVE-2013-4032)
IC94757 2 SECURITY: UNAUTHORIZED ACCESS TO TABLE VULNERABILITY IN DB2 (CVE-2013-4033)
IC92498 1 SECURITY: STACK BUFFER OVERFLOW VULNERABILITY IN DB2AUD AND DB2FLACC (CVE-2013-3475).
IC91269 2 CONNECTION TO ISERIES USING KERBEROS FAILING WITH SQL30082 RC=36OR RC=4
IC89709 2 APPLICATION MAY RECEIVE SQLCODE -1307 RC 11 DURING DB2AUDIT ARCHIVE PROCESS DUE TIMING HOLE IN AUDIT RECORD I/O
IC94003 2 TRANSPARENT LDAP DOESN?T USE THE CORRECT METHOD TO GATHER THE GROUP MEMBERSHIP ON SOLARIS.
IC91275 3 SQL3119W THROWN DURING LOAD/IMPORT USING DB2AUDIT DEL FILE DUE TO COLUMN TYPE MISMATCH
IC89733 3 DB2AUDIT LOG DOESN'T INCLUDE TABLE NAME OF A LOAD INTO TABLE FORUSERS WITH DATAACCESS AUTHORITY
IC96387 3 EVENT COLUMNS OF ROWS DESCRIBE THE PARAMETER MARKERS OR HOST VARIABLES DOES NOT CONTAIN DATA KEYWORD IN TABLE FORMAT.
IC91280 3 DB2AUDIT LOG DOESN'T INCLUDE TABLE NAME OF A LOAD INTO TABLE FORUSERS WITH DATAACCESS AUTHORITY
Fix Pack 3  -   Text Search
IC92910 1 DB2TS COMMAND RETURN ERROR MESSAGE CIE00756 CONNECT FAILED ON H NAMED "LOCALHOST" AND PORT ..."
IC88213 2 UNABLE TO ENABLE THE 'RICH TEXT SUPPORT' UNDER DB2 TEST SEARCH
IC90054 2 SQLGETDIAGFIELDW() RETURNS THE STRINGLENGTHPTR AS CHARACTERS INSTEAD OF BYTES.
IC94278 2 TEXT SEARCH INDEX UPDATE ERROR "CLI0129E,THERE ARE NO MORE HANDLES TO ALLOCATE" WHEN INDEXING LARGE NUMBER OF DOCUMENTS
IC91174 2 DB2TS PROBLEM FOR TEXT INDEX WITH FORMAT OF INSO
IC96143 2 CHANGE TO ENHANCE ERROR MESSAGE REGARDING MINIMUM FREE SPACE REQUIREMENTS FOR INSTALLATION AND INSTANCE CREATE/UPDATE OPERATIONS
IC93058 3 COMMANDLINETOOLS0.LOG CREATED IN INCORRECT DIRECTORY DURING DB2IUPDT
Fix Pack 3  -   XML
IC88695 1 INSTANCE TRAP WHEN ACCESSING XML BINARY DOCUMENT
IC93900 1 DB2 MIGHT CRASH WHEN YOU ARE INSERTING XML FILE CONTAINING LARGETEXT NODE TO THE XML COLUMN
IC89818 2 INCORRECT RESULTS ON RANGE PARTITIONED TABLE WITH XML COLUMN
IC86917 2 INSTANCE TRAP OR -901 WHEN INSERT OR QUERY LARGE XML DOC
IC89702 2 DB2 XQUERY SHOWS POOR PERFORMANCE DUE TO EXPENSIVE USE OF LARGE XML SEQUENCES.
IC96391 2 SOME XML QUERIES COULD BE IMPACTED BY PERFORMANCE ISSUE ON SOLARIS AND HP-UX PLATFORMS.
Fix Pack 3  -   pureScale Services
IC89726 1 IN A TSA AUTOMATED HADR ENVIRONMENT, AN AUTOMATED HADR FAILOVER OCCURS IMMEDIATELY AFTER THE TAKEOVER HADR COMMAND IS RUN
IC92391 1 IN A DB2 HA ENVIRONMENT, IF DB2HAICU IS SETUP WITH FQHN, DB2START CAN FAIL WITH SQL6048N
IC91816 2 TSA AUTOMATED HADR DATABASE DOES NOT FAILOVER AFTER UNPLUGGING PUBLIC NETWORK CABLE FROM THE PRIMARY SERVER
IC96390 2 HA IS NOT RETRIEVING INFORMATION FROM DB2HA.SYS TO VERIFY
IC90432 2 RUNNING 'DB2HAICU -DELETE' PRODUCES DB2DIAG.LOG ERROR MESSAGES
IC91609 2 DB2GCF -S REPORTS THAT ALL PARTITIONS ARE 'OPERABLE' IF THE DEFAULT PARTITION IS STOPPED.
IC89693 2 AFTER EXECUTING "DB2STOP CF <ID>" COMMAND, A SEVERE LEVEL MESSAGE IS PRINTED IN DIAGLOG FOR ROCMCAGETSERVERUDF
IC89148 2 ERRORS REPORTED TO DB2DIAG.LOG WHEN ISSUING THE "DB2INSTANCE -LIST" COMMAND
IC89528 2 DB2: PRIMARY CLUSTER CACHING FACILITY START FAILED BECAUSE OF RECV_MRB_FAILURE ON THE PSGETSERVERROLE CALL
IC90035 2 DB2 PURESCALE ON AIX - CHANGE LOGGING LEVEL IN MOUNTV10_*.KSH SCRIPTS
IV36997 2 GPFSREADY SCRIPT SPENDS UP TO 5 MINUTES POLLING FOR SSH STATUS
IC88532 2 DB2HAICU FAILS ON SOLARIS WITH "PIPE READ FROM VENDOR PROCESS WAS INTERRUPTED"
IC89721 2 DB2HAICU FAILS ON SOLARIS WITH "PIPE READ FROM VENDOR PROCESS WAS INTERRUPTED"
IC86863 2 DB2HAICU DUMPS ADDITIONAL ERRORS IN THE DB2DIAG.LOG ON TWO ATTEMPTS TO EXECUTE CONFIGURATION
IC92342 2 UPDATING A MEMBER OR CF TO ADD A NETWORK INTERFACE LOSES THAT UPDATED AFTER A REBOOT OR FAILOVER
IC91667 2 MISSING DEPENDENCIES FROM THE DB2 PARTITION RESOURCES TO THE PUBLIC NETWORK EQUIVALENCY
IC87563 2 THE DB2 FAULT MONITOR FAILS TO RESTART INSTANCE AFTER SERVER REBOOT
IC89305 2 THE DB2VXX_MONITOR.KSH SCRIPT MAY FALSELY REPORT PARTITION 0 AS ONLINE
IC89722 2 HADR RESOURCE GROUP REMAINS LOCKED AFTER SUCCESSFUL HADR REINTEGRATION.
IC90232 2 THE 'DB2CLUSTER -CM -CREATE -DOMAIN' COMMAND FAILS DUE TO INCORRECT PERMISSIONS ON THE LIBDB2GPFS.SO FILE
IC89050 2 DB2SET DB2_DISABLE_NETWORK_ADAPTER_ADD=FALSE FAILS WITH ERROR "DBI1302E INVALID PARAMETER DETECTED"
IC95646 2 DB2GCF UTILITY UPDATES THE DB2NODES.CFG TO SHORT HOSTNAME INSTEAD OF FULLY QUALIFIED HOST NAME
IC93924 2 RUNNING "DB2HAICU -DISABLE" DOES NOT UNSET THE "CLUSTER MANAGER"DBM CFG VALUE IF A CLUSTER DOMAIN DOES NOT EXIST.
IC89339 3 DB2GCF MAY ENCOUNTER MEMORY ISSUES WHEN USED WITH ASLR ON LINUX
IC90504 3 DB2HAICU MIGHT GENERATE SEVERAL DB2DIAG.LOG ERROR MESSAGES DURING DOMAIN STARTUP.
IC91786 3 DB2CLUSTER -CFS -ENTER -MAINTENANCE -ALL WILL STOP AIX TRACE VIAMMTRACE STOP.
IC89692 3 SMALL LETTER <DBNAME> DOES NOT WORK IN "DB2CLUSTER -CM -ADD -DATABASE_MOUNTS <DBNAME>" COMMAND.
IC91748 3 AUTOMATIC HADR PAIR REINTEGRATION DID NOT OCCUR AFTER RESTARTINGSTANDBY SERVER
IC91766 3 DB2_DEINSTALL/INSTALLFIXPAK FAILS WITH MINOR ERROR ON RHEL 6 WHILE STOPPING THE FAULT MONITOR
IV48844 3 THE "DB2CLUSTER -CM -REPAIR -RESOURCES" COMMAND SHOULD FAIL IF THE INSTANCE IS STARTED


DB2 Version 10.1 Fix Pack 2
APAR Sev. Abstract
Fix Pack 2  -   Security APARs
IC86783 2 SECURITY: STACK BUFFER OVERFLOW VULNERABILITY IN SQL/PERSISTENT STORED MODULES DEBUGGING INFRASTRUCTURE (CVE-2012-4826).
Fix Pack 2  -   HIPER APARs
IC85608 2 XQUERY MIGHT RETURN INCORRECT RESULTS WHEN BOTH 'AND' AND 'OR' PREDICATES EXIST AND ALL PREDICATES CAN BE APPLIED TO XML INDEXES
IC87500 2 ROWS MIGHT BE INSERTED INTO WRONG MDC TABLE CELL AFTER PREVIOUS INSERTS IN SAME TRANSACTION ENCOUNTER TABLESPACE FULL
Fix Pack 2  -   Special Attention APARs
IC85425 2 QUERY WITH A UNION AND TWO CORRELATED BRANCHES MIGHT RETURN INCORRECT RESULTS IN PARTITIONED DATABASE ENVIRONMENTS
IC85841 2 BATCH INSERTS CAUSING DUPLICATE ROWS WHEN USING NULLIDRA (REOPT=ALWAYS) VS. NULLIDR1 (REOPT=ONCE)
IC86029 2 CREATING A UNIQUE GLOBAL INDEX ON A TABLE WITH DETACHED PARTITION AND DEPENDANT MQT MIGHT LEAD TO INCORRECT RESULT AFTER REFRESH
Fix Pack 2  -   JDBC Driver
IC88902 2 SQLJ TRANSLATOR FAILS TO PARSE IMPLEMENTS CLAUSE WITH A GENERICTYPE
IC86157 2 WHEN SETBOOLEAN IS USED TO SET THE VALUE OF A PARAMETER TO TRUE FOR INSERTING INTO A SMALLINT COLUMN, IT ENDS UP AS 256
IC87875 2 MEMORY LEAK IN CREATING GEODETIC INDEX
IC85761 2 UNACCEPTABLE CUSTOMER SPATIAL QUERY PERFORMANCE DUE TO DIRECT WRITE/READ
IC88703 2 SPATIAL QUERY USING BOTH THE ST_NEARESTPOINTS AND ST_DISTANCE FUNCTIONS MAY FAIL WITH THE SQL0430N ERROR.
Fix Pack 2  -   Administration Tools
IC88359 2 DB2LOOK RETURNING INCORRECT VALUES FOR WLM SERVICE CLASSES SYSDEFAULTSYSTEMCLASS AND SYSDEFAULTMAINTENANCECLASS
IC88620 2 DB2BATCH MAY THROW "CLI0002W DATA TRUNCATED" WHILE FETCHING VARCHAR/CHAR COLUMNS FROM DIFFERENT CODEPAGE DATABASE THAN CLIENT
IC87895 2 DB2LOOK OUTPUT CONTAINS INCONSISTENT WORD FORMAT
IC86182 2 GET_DBSIZE_INFO INCORRECTLY MULTIPLYING SPACE BY NUMBER OF MEMBERS IN PURESCALE
IC86534 2 HEALTH MONITOR ACTIVITIES AND AUTOMATIC MAINTENANCE MAY FAIL DUETO MEMORY LEAK/EXHAUSTION
IC87906 3 SQL0305N IS RETURNED FROM RUNNING DB2LOOK WITH -M (MIMIC) OPTION.
IC87893 3 FILENAME IN DB2LOOK -O PARAMETER IS CONVERTED INTO LOWER-CASE AND IT MAY INDUCE 'DB2LOOK UTILITY COULD NOT OPEN FILE' ERROR
IC87894 3 DB2LOOK WITH OPTION '-L' MAY FAIL FOR DPF DATABASE ON WINDOWS.
IC88334 3 NEW FLAG TO CONTROL " COLLECT STATISITCS " CLAUSE IN CREATE INDEX DDL
IC88635 3 AN 'ALTER TABLE, ALTER COLUMN RESTART XXX" DDL STATEMENT IS NOT BEING CAPTURED IN DB2LOOK UNTIL AN ACTUAL VALUE HAS BEEN INSERTE
IC87867 3 DB2LOOK FAILS IF THE DATABASE HAS LARGE NUMBER OF LBAC SECURITY LABEL COMPONENTS
Fix Pack 2  -   Buffer Pool Services
IC87853 1 NO AVAILABLE BUFFER POOL PAGES IN BUFFER POOL BLOCK AREA
IC87593 2 DATABASE RESTORE COULD FAIL IN PURESCALE IF STORAGE PATH MOUNTS ARE NESTED ON NON-GPFS FILE SYSTEMS
IC87283 2 SQLB_RC_PG_NUM_ERR IN SQLBLATCHPOOLRANGE CAUSING INSTANCE PANIC DURING ROLLFORWARD PROCESSING
IC87868 3 DB2 SHOWS PAGE MAP ERROR WHILE RESIZING A LARGE NUMBER OF CONTAINERS IMMEDIATELY AFTER CREATION OF TABLESPACE
IC88682 4 DURING REDIRECTED RESTORE 'SEVERE' MESSAGES MAY BE LOGGED IN DB2DIAG.LOG IF RESTORED DATABASE NAME IS DIFFERENT FROM THE BACKED
Fix Pack 2  -   Build
IC88688 1 DURING REDIRECTED RESTORE 'SEVERE' MESSAGES MAY BE LOGGED IN DB2DIAG.LOG IF RESTORED DATABASE NAME IS DIFFERENT FROM THE BACKED
Fix Pack 2  -   Client Interfaces
IC88670 1 CLP & CLI NOT PERFORMING CODE PAGE CONVERSION ON DATE VALUES FROM ZOS WHEN IDAA QUERY ACCELERATION IS ENABLED
IC88621 2 MEMORY OVERWRITE WITH NULL TERMINATOR IN CLIENTBODATETOCHAR WHENNTS ENVIRONMENT ATTRIBUTE IS SET TO FALSE AND DATETIMESTRINGFOR
IC88661 2 INSTANCE CRASH DUE TO SIGNAL #11 SIGSEGV DURING POST-CONNECT OPERATION WITH CLI DRIVER
IC88597 2 INSERTING BLOBS OF SIZE 32756 BYTES DOES NOT COMPLETE WHEN EXECUTED IN A TRANSACTION.
IC84567 2 CALL TO STORED PROCEDURE WHICH WORKS IN V8.2, FAILS IN V9.5 WITHRGBVALUE 4.
IC86898 2 CLI THROWS SQL5163 ERROR DURING CONNECT FOR HOSTNAME OF "CLIENTAFFINITYDEFINED" SECTION IN DB2DSDRIVER.CFG FILE ON SUN64.
IC88638 2 SQL COMPATIBILITY : EXIT COMMAND DOES NOT RETURN PROPER RETURN CODE FOR BIND VARIABLES WITH NUMBER DATATYPE
IC88330 2 CLPPLUS PROMPTS FOR PASSWORD TWICE.
IC85406 2 IF THE VALUE OF DSN ALIAS IN DB2DSDRIVER.CFG CONTAINS A SPACE, YOU GET ERROR CLI0124E WHEN YOU TRY TO CONNECT USING THAT ALIAS.
IC86333 2 SQL0313N ERROR RETURNED WHEN HOST VARIABLES ARE USED IN DELETE STATEMENT IN A CLI APPLICATION.
IC87080 2 SQL0516N AND POSSIBLE DATA TRUNCATION RUNNING QUERY FROM CLI BASED APPLICATION AGAINST A DB2 FOR Z/OS DATABASE WITH IDAA.
IC85658 2 SQLGETDIAGFIELDW TRUNCATES THE ERROR MESSAGE RETURNED
IC87914 2 DURING XA CONNECT,CLI ENCOUNTER ERRORS SQL0843N, CLI0119E, WHEN USING DIFFERENT NAME FOR DBALIAS AND DSN
IC88341 2 CALLING STORED PROCEDURE ON NON-LUW DATABASES FAILS TO RETURN THE RETURN CODE WRITTEN IN THE STORED PROC
IC88304 2 INSERTING DATA INTO VARCHAR COLUMN, FAILS IN CLI DRIVER WITH CLI0109E ON THE UNICODE CODESET CLIENT
IC85223 2 DISTRIBUTIONS QUICKLY GROW STALE ON AUS_COMMAND TABLE AND SLOWS AUS_REFRESH TASK
IC86343 2 SQL8007W WARNING SEEN DURING CONNECT WHEN BOTH LOCAL TRIAL LICENSE & VALID DB2 ZOS SERVER-SIDE UNLIMITED CLIENT EDITION IS USED
IC87547 2 -30108 NON-SEAMLESS BEHAVIOUR WHEN SHOULD BE SEAMLESS
IC88599 2 CLPPLUS.BAT UNABLE TO PARSE PARENTHESIS
IC88642 2 "DB2 -A" RETURNS UNEXPECTED SQLSTATE WHEN AN ADJUSTMENT WAS MADETO THE INVALID DATE CALCULATED USING DATE() WITH LITERAL VALUE.
IC88600 2 REMOVE UN-SUPPORTED SCALAR FUNCTIONS AGAINST IDS SERVER
IC87916 3 AFTER RECEIVING SQL0437W WARNING FROM THE LOAD CLIENT WHILE PERFORMING LOAD FROM CURSOR, CLP CRASHES THE BACKGROUND DB2BP PROCES
IC84798 3 'DB2DSDCFGFILL.EXE -H' IS A VALID PARAMETER, BUT THEN THE OUTPUTALSO HAS A SQL1534N
IC87917 3 SQLDESCRIBEPARAM() MAY FAIL WITH CLI0150E DRIVER NOT CAPABLE WHEN CALLING AN UNQUALIFIED STORED PROCEDURE ON DB2 FOR Z/OS
IC87922 3 CORRUPTED TEXT IN THE OUTPUT FILE GENERATED BY 'DB2' CLP COMMAND WHEN BOTH (-L AND -Z) OPTIONS POINT TO THE SAME FILE.
IC84994 3 IF NEITHER JAVA_HOME NOR PATH IS SET WITH JAVA PATH, THE CLPPLUSBATCH FILE IS THROWING ERROR.
IC88659 3 DB2 CLIENT LIBRARY RELY ON GLIBC "NEW AND DELETE" ON 32-BIT LINUX
IC89630 3 DB2 TRAPPED IN CLP_FP_EXIT
IC88617 3 SQLGETDIAGFIELDW RETURNS INCORRECT VALUE FOR PCBDIAGINFO
IC88622 3 IBM.DATA.DB2 CAN THROW A SYSTEM.INDEXOUTOFRANGEEXCEPTION OR SYSTEM.INVALIDOPERATIONEXCEPTION WHEN ESTABLISHING CONNECTIONS
IC87834 3 WHEN DB2 TRACE IS ENABLED, CALLING A DB2 Z/OS STORED PROCEDURE FROM DB2 COMMAND WINDOW, MAY CRASH DB2BP
IC87911 3 CLPPLUS DISPLAYS SERVER OUTPUT MESSAGES MULTIPLE TIMES.
IC86899 3 FOR DSDRIVER ON LINUXAMD64, EXECUTING "DB2TRC ON" AS ROOT FAILS WITH ERROR LIBDB2.SO.1 NOT FOUND ...
IC86577 1 INSTANCE CRASH WHEN USING ASSOCIATIVE ARRAY OF VARIABLE LENGTH
IC88308 1 IN SMP ENVIROMENTS, APPLICATIONS THAT DO POSITIONED UPDATE/DELETE COULD ENCOUNTER SQL0902N
IC88319 2 DB2 MAY ABEND WITH A TRAP (PRIOR TO VERSION 9.7 FIX PACK 5) OR OLAP QUERY MAY FAIL WITH SQL0901N (VERSION 9.7 FIX PACK 5 OR 6).
IC88351 2 TO_CHAR(DECFLOAT ZERO, '9') RETURNS BLANKS ONLY IN V9.7FP5 OR LATER.
IC87918 2 EXECUTING DBMS_SQL.EXECUTE_AND_FETCH PROCEDURE WITH 2 PARAMETERSFAILS WITH SQL0444N RC=4
IC88349 2 XQUERY WITH "LET" EXPRESSIONS AGGREGATING LARGE SEQUENCES WITH PREDICATE MAY PERFORM SLOWER IN V95/V97 VS. V91.
IC84593 2 A TRANSACTION REMAINS RUNNING EVENT AFTER CANCELLING OF AN APPLICATION.
IC87866 2 POSSIBLE TRAP IN SQLNO_AT_COORDINATOR WITH INTRA_PARALLEL ON
IC85193 2 ARRAY ALLOCATION FAILS IN STORED PROCEDURE WITH SQL20442N EVEN WHEN APPLHEAPSZ AND APPL_MEMORY ARE SET TO AUTOMATIC
IC85132 2 SELECT STATEMENT AGAINST AN RCT TABLE WITH A "IS NOT NULL" PREDICATE MAY CRASH.
IC87876 2 -901 REASON "EXPECTED TEMP TCB" ERROR MAY BE RAISED WITH REOPT ALWAYS AND XML TEMP TABLES.
IC85739 2 THE SUBSECTION STATUS FIELD IN THE APPLICATION SNAPSHOT MONITOR OUTPUT MAY BE INCORRECT.
IC87695 2 INSTANCE TRAP IN SQLVPUTD WHEN RUNNING SQL WITH CHAR(DATE())
IC86092 3 SYSTEM MODULE ROUTINE DBMS_ALERT.REGISTER MAY INCORRECTLY REMOVEACTIVE ALERTS.
IC84589 3 CONSECUTIVE CALLS TO DBMS_OUTPUT.GET_LINES() SKIPS A LINE IN BETWEEN EACH CALL
IC88309 3 UTL_MAIL.SEND() PROCEDURE RETURNS SQL1336N
IC88647 3 SQL0153N MAY BE RETURNED WHEN RUNNING DBMS_SQL.EXECUTE WITH SQL STATEMENT THAT IS PREFIXED BY SPACES IN ORACLE-COMPATIBLE MODE
Fix Pack 2  -   Communication
IC87436 1 DB2 NOT LISTENING FOR IPV6 CONNECTIONS WHEN THERE'S AN IPV6 ADAPTER ON THE BOX
IC87902 3 INCORRECT APPLICATION ID MAY BE WRITTEN IN DB2AUDIT LOG
Fix Pack 2  -   DB2 Tools
IC86783 1 SECURITY: STACK BUFFER OVERFLOW VULNERABILITY IN SQL/PERSISTENT STORED MODULES DEBUGGING INFRASTRUCTURE (CVE-2012-4826).
IC88628 2 DB2 CONTROL CENTER DOES NOT LIST ISERIES 7.1 IN CREATE SERVER PANEL.
IC88636 2 CONFIGURATION ASSISTANT CANNOT LAUNCH 'ADD CLI PARAMETER' DIALOGIN V9.7 FP5.
IC88326 2 CONFIGURATION ASSISTANT CAN NOT SAVE PASSWORD IN CLI SETTING PANEL DUE TO DESELECTED SAVE PASSWORD(S).
IC87882 3 TOTAL ELAPSED TIME IN THE DB2BATCH OUTPUT FOR THE SAME STATEMENTEXECUTED MORE THAN ONCE WITHIN DB2BATCH MAY NOT BE ACCURATE.
IC87795 3 SNAPSHOT ROUTINES ONLY CLEAN UP THE LAST DATA FILE FROM SQLLIB/TMP WHEN PROCESSING MULTIPLE MEMBERS
IC87907 3 DB2TOOL -TW TNAME CAN FIND NO MATCHING TABLES, BUT CAN GENERATE RELATED OBJECTS.
Fix Pack 2  -   DRDA Services
IC88689 1 RECONNECT TO SYSPLEX MEMBER EVEN IF SYSPLEX IS DISABLED
IC87879 2 DB2 CONNECT GATEWAY INSTANCE MAY CRASH DUE TO MEMORY CORRUPTION AT SQLJRPROCESSSETI()
IC84574 2 CLIENT CONNECTIONS VIA GATEWAY TO ISERIES RECEIVE DIA5000C UNICODEMGR AND CCSIDMGR SHOULD BE MUTUALLY EXCLUSIVE
IC87861 2 SOCKET TIMEOUT MESSAGES IN DB2DIAG.LOG FILE ARE DOWNGRADED TO INFORMATIONAL MESSAGES.
IC88329 2 DB2 INSTANCE TRAPPED IN SQLEUCTRUSTEDEDUTERM WHEN FORCING FEDERATED APPLICATIONS
IC88317 2 THE SQLOWAITINTERRUPT SUFFERS FROM 6 OSERR CAUSING DB2DIAG.LOG TO BE FILLED WITH 'INVALID HANDLE' ERRORS.
IC87891 2 XA AES CONNECTION TO DB2 Z/OS SERVER GETS SQL30082N RC=17
IC88704 2 SQLSTATE 58017 (SQL30073 ERROR) REPORTED WHEN A NON-DB2 CLIENT OR DRIVER ATTEMPTS TO ESTABLISH A CONNECTION
IC88313 3 WITH CONNECTION CONCENTRATOR ENABLED WE INTERMITTENTLY SENDING RDBNAM IN UNICODE INSTEAD OF EBCDIC
IC88332 3 TRAP IN SQLOEXECUTEEDUEXITLIST AS IT INCORRECTLY INVOKES SQLJRSIGNALHANDLER IN DPF ENVIRONMENT
Fix Pack 2  -   Data Management Services
IC88663 1 HIGH NUMBER OF PREFETCHER REQUESTS CAUSING HIGH SYS% AND PERFORMANCE DEGRADATION
IC87121 2 BUFFER POOL DECREASE / STMM HANG WAITING ON SPECIAL TEMP BUFFER POOL PAGE
IC84834 2 TABLE DATA OF REORG INFORMATION GETS CLEARED ON EXECUTION OF SQLRLADMINGETTABINFO VIEW
IC87920 2 DB2 MAY TRAP IN SCAN SHARING FUNCTIONS WHEN HEAVY TABLE SCANS OCCUR AND DB2 TRACE ENABLED
IC87860 2 "DB2PD -SORT" ONLY RETURNS INFO FOR SORTS THAT OCCUR WITHIN A COORDINATOR AGENT, IN DPF AND INTRAPARALLEL ENVIRONMENTS.
IC89629 2 RUNSTATS MIGHT INCORRECTLY FLAG THE TABLE TABLESPACE AS DIRTY.
IC85725 2 SIGNAL 11 IN SQLSFETC AFTER MEMORY ALLOCATION ERROR IN SQLSBINSORTALLOCMEM
IC88631 3 WE ALLOW FOR CREATION OF TABLES WITH NULL CHARACTER WITHIN ITS NAME, HOWEVER WHEN LATER WE TRY TO DROP THIS TABLE OR INSERT VALU
IC84605 3 DB2 PERFORMANCE ISSUE WHEN XML DATA IS BEING USED HEAVILY.
Fix Pack 2  -   Data Management Utilities
IC86779 1 INGEST UTILITY: UP TO 10X PERFORMANCE DEGRADATION FROM BETA1R2 TO GA WHEN INGESTING DATES, TIMES, AND TIMESTAMPS
IC87449 2 POTENTIAL SLOW LOAD PERFORMANCE WITH MDC/RP TABLE AND GPFS DUE TO MISALIGNED MEMORY BUFFER
IC87075 2 IF TABLE CONTAINS XML COLUMNS, LOAD MIGHT HANG IN LOAD PHASE WHILE RIDDER(DB2LRID) TRIES TO TERMINATE ITSELF BECAUSE OF ERROR
IC87094 2 ERROR IN SQLOGMBLK WHEN CALLED FROM SQLUMARKPOOLSOFFLINE DURING REDO
IC88596 2 INSTANCE CRASH WITH SIGSEGV OR MEMORY CORRUPTION WHEN RUNNING CLI BASED LOADS, WITH DB2_WORKLOAD=SAP
IC88605 2 LOAD WITH COPY YES MIGHT CAUSE INDEX CORRUPTION DURING SUBSEQUENT ROLLFORWARD WHEN SPECIFYING MULTIPLE COPY TARGET SESSIONS
IC88347 3 LOAD CLIENT MIGHT RETURN SQL0437W TO CLP WHILE RUNNING LOAD FROMCURSOR IN DPF SO THAT CLP ENDS UP ENDLESSLY PROMPTING
IC88346 3 LOAD CLIENT MIGHT RETURN SQL0437W TO CLP WHILE RUNNING LOAD FROMCURSOR IN DPF SO THAT CLP ENDS UP ENDLESSLY PROMPTING
IC88312 3 MINIMIZE DELAY AT LOAD STARTUP TIME RELATING TO A PREVIOUS LOAD INTO THE SAME TABLE NOT TERMINATING CLEANLY
Fix Pack 2  -   Data Recovery Services
IC88333 1 LIST INDOUBT TRANSACTIONS COMMAND DOES NOT SHOW COMMIT STATE INDOUBT TRANSACTIONS
IC88338 2 ERROR DURING RETRIVAL OF LOG FILES WHILE TAKING THE DATABASE BACKUP.
IC88310 2 ASYNCHRONOUS BACKGROUND PROCESS (ABP) IS NOT SELECTED AS DEADLOCK VICTIM ON PARTITIONED DATABASES.
IC88320 2 DB2 MAY LEAK DB HEAP EACH TIME LOG IS ARCHIVED UNDER DATABASE THAT HAS MIRRORLOGPATH BEING SET.
IC88325 2 SET WRITE SUSPEND CAN TAKE SOME AMOUNT OF TIME EXTENDING/RENAMING LOG FILES
IC85354 2 LOGS COULD BE MISTAKENLY REMOVED ON NEW PRIMARY AFTER TAKEOVER ON AIX 64 OS
IC88632 2 INCREMENTAL BACKUP FAILS WITH -2044: SQLUMCPROCESSREMAININGBUFFERS, PROBE:1769. ZRC=0X870F00B9=-2029059911=SQLO_SEM_TIMEOUT
IC87884 2 "GET DATABASE CONFIGURATION" COMMAND DISPLAYS INCORRECT VALUE FOR PARAMETER MIRRORLOGPATH.
IC87852 2 AFTER A CRASH DURING SHUTDOWN WHILE TRUNCATING A LOG FILE, CRASH RECOVERY MAY FAIL DUE TO TRUNCATED LOG.
IC88674 2 DB2 9.7FP6 "DB2ADUTL DELETE OLDER THAN N DAYS WITHOUT PROMPTING"DELETES ARCHIVE LOGS BOTH OLDER AND NEWER THAN N DAYS
IC86589 2 DB2ADUTL FAILS WITH 137 WHEN USING PASSWORDACCESS PROMPT & DB CFG TSM_PASSWORD SET TO A VALUE.
IC88345 2 DB2 MAY CRASH AFTER A RESTORE DUE TO A TIMING HOLE
IC86146 2 IN MULTIPLE DATABASE PARTITIONS ENVIRONMENT, SINGLE SYSTEM VIEW (SSV) BACKUP MAY RUN INTO VIOLATING NUM_LOG_SPAN PROBLEM WITH AD
IC84199 2 HISTORY FILE CORRUPTION MAY OCCUR WHEN THE FILESYSTEM THAT THE HISTORY FILE RESIDES ON BECOMES 100% FULL
IC88331 3 PIT ROLLFORWARD FOR A TABLE SPACE RESTORE APPEARS TO BE HANGING OR TAKE VERY LONG TIME TO RUN.
IC88616 3 DB2CKBKP REPORTS "ERROR - TABLESPACE PAGE SIZE INCONSISTENT FOR TABLESPACE ID X" WHEN ENCOUNTERING VERY OLD PAGES.
IC86709 3 ON IA32 PLATFORM(WINDOWS OR LINUX), DATABASE MARKED BAD DUE TO SQLP_BADLSN FOUND
IC88339 3 LOG RETRIEVAL DOES NOT CHECK THE FORMAT VERSION AND CAN CAUSE ERROR DURING LATER CHECKING
Fix Pack 2  -   Engine Sample
IC85977 3 SAMPLE BUILD SCRIPTS FOR DB2 ON HPUX NEED TO BE MODIFIED TO INCLUDE -MT AND -LUNWIND OPTIONS
Fix Pack 2  -   Federation
IC87869 2 PREDICATES WITH LTRIM() FUNCTION CAN NOT BE PUSHED DOWN
IC88676 2 PREDICATES LIKE FUNCTION(COL1, ...) = ? CAN NOT BE PUSHED DOWN
IC87887 2 DRDA STATEMENT CONTAINING PARAMETER MARKER RUNS IN PASSTHRU SESSION WILL CAUSE DB2 CRASH
IC88678 2 SQL0180N IS REPORTED WHEN CREATE MSSQL NICKNAME
IC88672 2 BLOCK PUSHDOWN OF <> PREDICATE WITH EMPTY STRING AGAINST ORACLE AND UDB IN ORA-COMPAT MODE
IC88648 2 FED: SQL STATEMENT FAILED WITH -901 ERROR REASON "BAD OPCODE ...(SYSIBM.DJ_RPAD)"
IC87913 2 FEDERATION SERVER INCORRECTLY SET KRB5CCNAME VARIABLE FROM DB2DJ.INI CAUSES KERBEROS SUPPORT FOR SYBASE WRAPPER NOT WORK
IC86340 2 DRDA WRAPPER REPORTS -901 ERROR IF SOURCE TABLE/VIEW HAS COLUMN WITH CHAR(0) DATA TYPE
IC88649 2 SELECT STATEMENT WITH TO_DATE MAY TRAP IN FEDERATED ENVIRONMENT.
IC88314 3 NO ERROR IS RETURNED WHEN INSERTING NULL INTO A COLUMN OF A NICKNAME THAT DOES NOT ALLOW NULL VALUE
IC86622 3 RETURN NO DATA WHEN "VARGRAPHIC(A0."C1")" IS PUSHED DOWN TO AS400 DATASOURCE
IC88681 3 ORACLE NICKNAME - BLANKS ARE RTRIMED AT THE END OF AN VARCHAR HOST VARIABLE IN INSERT/UPDATE STATEMENT
Fix Pack 2  -   Index Manager
IC87500 1 ROWS MIGHT BE INSERTED INTO WRONG MDC TABLE CELL AFTER PREVIOUS INSERTS IN SAME TRANSACTION ENCOUNTER TABLESPACE FULL
IC86957 2 PURESCALE MEMBER CRASH RECOVERY AND CONCURRENT APPLICATION ON ANOTHER MEMBER MAY HANG
IC86576 2 DB2 INSTANCE MAY ABEND WITH ERROR MESSAGE "DIA8575C AN INDEX MANAGER PROGRAMMING ERROR OCCURRED."
IC88337 2 HADR TAKEOVER MAY WAIT UNTIL REORG INDEXES OPERATION WITH "CLEANUP ONLY ALL" OPTION ON PRIMARY IS COMPLETE
IC85307 3 RUNNING ADMIN_GET_INDEX_INFO ON A TABLE THAT IS CURRENTLY RUNNING REDISTRIBUTE...DROP DBPARTITIONNUM(N) COULD RESULT IN A -901
IC86901 1 DB2PREREQCHECK REQUIRING WRONG PACKAGES WITH MELLANOX OFED
IC88306 2 SQL0901N MAY BE RETURNED WHEN DECREASING THE LENGTH OF A VARCHARTYPE COLUMN VIA ALTER TABLE STATEMENT
IC88634 2 DB2LOOK & SYSDATAPARTITIONS(LOWVALUE & HIGHVALUE) CAN PRODUCE INCORRECT STRING REPRESENTATION FOR PARTITIONING RANGE VALUES.
IC87854 2 FURTHER ENHANCEMENTS TO DB2CAT TO CHECK FOR TABLES AFFECTED BY APARS IZ39997 & IZ40001. APAR IC79996 IMPROVEMENT
IC86462 2 MISSING 64-BIT LIBDB2TSA.SO LIBRARY ON POWER LINUX
IC86029 2 CREATING A UNIQUE GLOBAL INDEX ON A TABLE WITH DETACHED PARTITION AND DEPENDANT MQT MIGHT LEAD TO INCORRECT RESULT AFTER REFRESH
IC88343 2 TRANSFER OWNERSHIP COMMAND FAILS WITH SQL0901N AND "UNKNOWN DEPENDENT OBJECT TYPE: G" ERRORS.
IC88612 2 IN A DB2 MULTI-PARTITION (DPF) ENVIRONMENT, SQL0960C AND TDA FILE ACCUMULATION CAN RESULT WHEN CREATING GLOBAL TEMPORARY TABLES.
IC85578 2 ROLLBACK MIGHT TRAP WHEN CLEANING UP CGTT OBJECTS IN SECTIONS
IC85181 2 ALL_* ORACLE DICTIONARY VIEWS ARE NOT RETURNING ALL OBJECTS IN DATABASE WHEN THE USER HAS DATAACCESS AUTHORITY
IC85915 2 DB2_INSTALL FAILS WITH NO PROPER ERROR MESSAGE IN LOG WHEN RSCT PEER DOMAIN IS ONLINE"
IC86511 2 WHILE UPGRADING A DB2 INSTANCE WITH SPATIAL EXTENDER IN DB2 V10.1 IT GIVES ERROR OF PRODUCT NOT INSTALLED.
IC88321 2 SQL0413N MAY BE RETURNED WHEN QUERYING AGAINST SYSIBMADM.DBA_INDEXES OR SYSIBMADM.DBA_IND_PARTITIONS IF FULLKEYCARD IS 0
IC85494 2 REQUEST THE REMOVAL OF GID LIMIT, THE RANGE OF 100 - 65535
IC85808 2 SYSINSTALLOJECTS MAY FAIL TO CREATE SECURED TRIGGERS ON POLICY TABLE
IC85780 3 CORE DUMPED BY DB2SETUP WHEN NIS/NIS+ IS ENABLED.
IC86582 3 PERFORMANCE ENHANCEMENT FOR CREATION OF A NEW SEQUENCE OBJECT
IC88609 3 AFTER RUNNING SPATIAL EXTENDER UPGRADE, CREATING A SPATIAL INDEXFAILS WITH -901.
IC87863 3 SYSIBMADM.PRIVILEGES AND SYSIBMADM.OBJECTOWNERS MISSING OBJECTTYPE G = CREATED TEMPORARY TABLE AND L = DETACHED TABLE
Fix Pack 2  -   Monitoring
IC88619 1 HIGH SYS CPU, PERFORMANCE IMPACT, LATCHING ISSUES WHEN USING DB2V97 NEW DEADLOCK EVENT MONITORING WITH HISTORY
IC88602 2 ADMIN_MOVE_TABLE CAN FAIL WITH SQL0010N OR A SQL0104N SYNTAX ERROR DUE TO THE LENGTH OF COMMENTS.
IC88645 2 PARTIAL EVENT MESSAGES WITH SQL443N ARE LOGGED IN DB2DIAG.LOG FROM EVMON_FORMAT_UE_TO_XML TABLE FUNCTION
IC88707 2 INSTANCE/DATABASE MIGHT ABEND DURING THE COLLECT OF EVENT DETAILS IN SQMFASTWRITERQUEUEMGR::RELEASEFASTWRITERRECORDSTOPOOL.
IC88315 2 ADMIN_MOVE_TABLE FAILS WITH SQL2103N RC 17 IF THERE ARE 3 TYPES OF INDEX ON A TABLE (PRIMARY KEY , UNIQUE , NON UNIQUE )
IC88607 2 GET SNAPSHOT MAY REPORT A VERY HIGH INCORRECT VALUE FOR "APPLICATION CONNECTS"
IC88305 2 INSTANCE HANG POSSIBLE AFTER APPLICATION HEAP MEMORY ERROR IN FUNCTION SQLRWFILTEREDAPPLICATIONITERATOR::EXECUTE
IC87910 2 THE INDEX RECREATED WITH SYSPROC.ADMIN_MOVE_TABLE PROCEDURE MIGHT HAVE WRONG DEFINITION.
IC87909 2 ADMIN_MOVE_TABLE() MAY FAIL WITH SQL0567N IF A TABLE HAS "PUBLIC" PRIVILEGE GRANTED
IC87919 2 THE INDEX RECREATED WITH SYSPROC.ADMIN_MOVE_TABLE PROCEDURE MIGHT HAVE WRONG DEFINITION.
IC86852 2 CHANGE HISTORY EVENT MONITOR SHOWS INCORRECT EVENT_TYPE VALUE FOR THE UTILLOCATION LOGICAL DATA GROUP
IC89172 2 EVENT MONITOR STMT_VALUE_DATA ELEMENT NOT POPULATED IF STMT_VALUE_TYPE IS GRAPHIC, VARGRAPHIC, NCHAR OR NVARCHAR
IC88348 2 WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES INCORRECTLY SHOWS THEREORG APPLICATION STATUS AS UOWWAIT
IC85428 2 LOCK NAMES RECORDED BY DEADLOCK EVENT MONITOR ARE NOT CORRECT
IC87857 2 SIGNAL #11 SIGSEGV CRASH CALLING CONVERTTO64BIT FROM SNAPSHOT_LOCK
IC88603 2 ADMIN_MOVE_TABLE() FAILS WITH SQL2103N, RC=17 WHEN LOB INLINE_LENGTH DIFFERS BETWEEN SOURCE AND TARGET OBJECT
IC87850 2 DB2 CAN TRAP IN SQLODIAGNOSEFREEBLOCKFAILURE WHEN USING 2 PHASECOMMIT.
IC87908 2 DATA ROW COMPRESSION SETTING DISABLED ON TARGET TABLE WHEN ADMIN_MOVE_TABLE COPY_USE_LOAD FAILS WITH SQL3508
IC87870 2 MON_GET_LOCKS DOES NOT SHOW INFORMATION WHEN USING <TABLE_SCHEMA> AND <TABLE_NAME>
IC88641 2 EXPLAIN_FROM_ACTIVITY() STORED PROC RETURNS STATUS 0 BUT NO ROWSINSERTED INTO EXPLAIN TABLES AND OUTPUT PARAMETERS ARE NULL
IC88671 2 ADMIN_MOVE_TABLE TO TERMINATE BROKEN LOAD AND RESTART A NEW LOAD
IC88686 2 DB2 MIGHT CRASH ON SQLRWSENDGETWLMTABLEFUNCTIONRESULT WHEN USINGMON_GET_LOCKS TABLE FUNCTION
IC87855 3 SYSIBM.SQLFOREIGNKEYS QUERY IS SLOWER WHEN THERE ARE NO FOREIGNKEYS WHEN RETURNALIAS=0
Fix Pack 2  -   National Language Services
IC88651 2 INSTANCE MAY TRAP WITH SIGNAL 11 IN ICU UDAT_PARSE WHILE RUNNINGLOAD
IC87901 2 SQUARE BRACKETS([ ]) AND CARET(^) CHARACTERS ARE REPLACED BY SUBSTITUTE CHARACTERS ON CODEPAGE CONVERSION FROM CP937 TO CP950.
IC87406 1 DYNAMIC PL/SQL CURSORS ARE CLOSED AFTER A COMMIT
IC85563 2 ERROR SQL0206N OCCURS WHEN SQLERRM OUTSIDE THE EXCEPTION BLOCK WITHOUT PARAMETERS
IC87896 2 SQL/PL SQLEXCEPTION HANDLER DOES NOT HANDLE SQL0973N CORRECTLY
IC88629 2 A ROLLBACK DURING EXECUTION OF AN ANONYMOUS BLOCK REPORTS SQLCODE -804 (INVALID MODE), INSTEAD OF SQLCODE -911
Fix Pack 2  -   Platform Specific
IC88355 2 DB2_PS COMMAND MAY FAIL IN DPF ENVIRONMENT WITH KSH SYNTAX ERRORS STARTING WITH DB2 V10.1 FP1
IC87595 2 NEW DB2SET SETTINGS FOR DB2_WORKLOAD = FILENET_CM
IC85395 2 OSSDIRECTORYNAME RETURNS TRAILING PATH SEPARATOR CHARS.
IC84201 2 EXCESSIVE DIAGNOSTIC LOGGING AND DUMPING FROM MULTIPLE DB2 PARTITIONS WHEN ONE PARTITION ABENDS
IC88639 2 USING DB2PRIORITIES OR DB2_RESOURCE_POLICY TO SET EDU PRIORITIESDOES NOT WORK
IC87287 3 AUTHENTICATION FAILS WITH SQL30082N RC=24 WHEN THE LOGIN CREDENTIALS ARE REDIRECTED FROM A FILE OR STDIN
IC86813 3 AUTOMATIC TUNING OF LINUX KERNEL.SHMALL PARAMETER INCORRECTLY ASSUMES THAT PAGE SIZE IS 4K
IC87865 3 ENABLE_MQFUNCTIONS UTILITY SHOWS UNSUPPORTED PARAMETER "-Q" IN USAGE MESSAGE
IC88344 3 AUTOMATIC TUNING OF LINUX KERNEL.SHMALL PARAMETER INCORRECTLY ASSUMES THAT PAGE SIZE IS 4K
Fix Pack 2  -   Problem Determination
IC87880 2 WINDOWS: DB2SUPPORT MAY RECORD A NEGATIVE VALUE FOR "TOTAL AVAILABLE VIRTUAL MEMORY IN BYTES" IN MEMUSAGE.OUT.
IC87858 2 DB2PD -BUFFERPOOL MAY RETURN INCORRECT DATLRDS INFORMATION
IC87833 2 IF THE TOTAL NUMBER OF STATISTIC EVENT LOG FILES IS 15, DB2DIAG AND PD_GET_DIAG_HIST FAIL TO RETRIEVE DATA.
IC88342 2 DB2 INSTANCE MAY ABEND WITH ERROR MESSAGE "DIA8575C AN INDEX MANAGER PROGRAMMING ERROR OCCURRED."
IC88311 2 DPF: DB2PD -MEMSETS SHOWS INCORRECT KEY INFORMATION (DOES NOT MATCH WITH IPCS -M OUTPUT) FOR PARTITIONS THAT ARE NOT 0.
IC87859 2 DB2PD -EVE RUNS DB2PD -HA WHICH IS PROHIBITED IN PURESCALE
IC87841 2 IF DIR FOR STATISTIC EVENT LOG WAS CHANGED TO DIR DIFFERENT FROMDEFAULT, PD_GET_DIAG_HIST CANNOT RECOGNIZE NEW DIR.
IC87839 3 DB2FODC -PERF GETS SYNTAX ERRORS DURING THE COLLECTION PROCESS,AND FAILS TO CAPTURE INFORMATION PROPERLY SUCH AS VMSTAT ON HP
IC87846 3 DB2TOP UTILITIES COLUMN DISPLAY MAY NOT BE INDENTED PROPERLY BY SHOWING SOME BIG NUMBERS OR HEX LIKE NUMBERS FOR LOAD OPERATION
IC85252 3 DB2DART COMPLAINS ABOUT NOT_EXIST PAGES WHEN NO PROBLEM EXISTS
IC87856 3 DB2PD -STACK ALL OR DB2FODC -HANG FULL ASK FOR THE DB2SERVICE PASSWORD SINCE IC69982 ON HP-UX
IC86463 3 DB2SUPPORT DOESNOT WORK IN PHYSICAL DATA PARTITION ENVIRONMENT ON WINDOWS PLATFORM.
IC86786 3 DB2SUPPORT DOESNOT WORK IN PHYSICAL DATA PARTITION ENVIRONMENT ON WINDOWS PLATFORM.
IC87892 3 DB2PD MAY UNDER THE COVERS RUN ALL DATABASE SCOPE OPTIONS WHEN ONLY ONE OR A FEW OPTIONS WERE REQUESTED
Fix Pack 2  -   Process Model
IC88610 1 UNABLE TO FORCE OFF APPLICATION THAT IS USING FMP CALLS
IC88373 2 CATALOG NODE FAILURE CAN LEAD TO APPLICATION AND DATABASE STAYING UP CAUSING -1229 FOR SUBSEQUENT CONNECTIONS
IC87889 2 SQL0901 TO PREVENT ABNORMAL TERMINATION OF NON-SQL ROUTINES
IC85948 2 ADMIN_SET_INTRA_PARALLEL DOESN'T TAKE EFFECT IN PURESCALE.
IC88604 2 INSTANCE MAY GO DOWN AT SQLOFREEMEMCHUNKS AFTER A SEVERE SQLERMASTERTHREADREQ MESSAGE.
IC88324 2 CHANGE MESSAGE SQLFGETDBCFG, PROBE:50 TO INFORMATIONAL
IC87844 2 DPF CATALOG NODE FAIL DEACT APP HUNG IN LOCALDEACTIVATE IN TERM LOG SYNC. SIMILAR TO APAR IC75211 (9.5) AND IC74901 (9.7)
IC87899 2 POSSIBLE CRASH/SEGV IN SQLECLEANUPFEDDAEMONANCHOR()->GETIDENTITY() DUE TO TIMING ISSUE
IC87898 2 TERMINATE DATABASE HANGS INDEFINITLY WHILE WAITING FOR ANOTHER AGENT THAT IS WAITING FOR START-USING TO COMPLETE
IC84510 2 ERROR COULD OCCUR WHEN USING CHAR ARRAY IN EXTERNAL JAVA ROUTINE
IC88637 2 DB2 DATABASE SERVER RUNS OUT OF ENTRIES IN RESYNC LIST
IC88727 3 DB2 MAY CRASH WHEN USING NON-THREADSAFE WRAPPER AND DB2FMP PROCESS IS TERMINATED
IC87040 3 MEMBER RESOURCE REMAINS OFFLINE IF THE RESOURCES ARE REPAIRED WHILE THE MEMBER IS WAITING TO FAIL BACK TO HOME HOST
IC88646 3 IN RARE CASE, A ROLLBACK TRANSACTION HITS MAX_LOG IN DB2 LUW DPF ENVIRONMENT CAUSING HANG OR MARK DATABASE BAD.
IC88316 3 SOMETIMES A CALL TO AN AUTONOMOUS PROCEDURE MAY FAIL WITH : SQL0083C A MEMORY ALLOCATION ERROR HAS OCCURRED
IC87838 3 AFTER REDIRECTED RESTORE TERMINATED WITH ERROR "-1704" WITH TOKENS "17" SUBSEQUENT DROP FAILING TO CLEAN THE CONTAINERS
IC87872 3 DB2PD DOES NOT SHOW AUTOMATIC FLAG FOR PCKCACHESZ
Fix Pack 2  -   PureScale Services
IC86704 1 SQL1517N ON DB2START ON HA/DPF SETUP WITH DB2HAICU (NON-PURESCALE)
IC87438 1 FUNCTION SUCH AS DB2_GET_CLUSTER_HOST_STATE CAN BE EXERCISED MULTIPLE TIME BY OPM FOR MANY DATABASES CONCURRENTLY. THIS FUNCTION
IC86408 2 CHANGES TO THE SOLARIS SMF DB2FM SERVICE MANIFEST AND METHODS. FIXES INCOMPLETE IMPLEMENTATION PROVIDED BY IC84200
IC88677 2 DB2 TSA SETUP SAMPLE FOR WINDOWS (MKHADR) DEFINE "CRITRSRCPROTMETHOD=5" WHICH IS INCORRECT
IC87247 2 DB2HAICU FAILS "ECF_SQLHA_HADR_VALIDATION_FAILED" ERROR WHEN FQDN ARE USED FOR HOST NAMES.
IC87471 3 USING FQDN FOR NODE NAMES DURING DB2HAICU SETUP IS BROKEN
Fix Pack 2  -   Quality Assurance
IC88687 1 DB2 MAY ABEND IN CREATE PROCEDURE IF THE DATABASE CONFIGURATION AUTO_REVAL SET TO DEFERRED_FORCE
IC88640 2 DATA ROW COMPRESSION SETTING DISABLED ON TARGET TABLE WHEN ADMIN_MOVE_TABLE COPY_USE_LOAD FAILS WITH SQL3508
IC85532 2 TO_CHAR CAN NOT HANDLE AM, MERIDIAN INDICATOR (MORNING OR EVENING) CORRECTLY IN MULTI-BYTE ENVIRONMENTS.
IC88627 2 ADMIN_MOVE_TABLE() MAY FAIL WITH SQL0567N IF A TABLE HAS "PUBLIC" PRIVILEGE GRANTED
IC88615 2 -901 REASON "EXPECTED TEMP TCB" ERROR MAY BE RAISED WITH REOPT ALWAYS AND XML TEMP TABLES.
IC88623 2 THE INDEX RECREATED WITH SYSPROC.ADMIN_MOVE_TABLE PROCEDURE MIGHT HAVE WRONG DEFINITION.
IC88626 3 DB2PD MAY UNDER THE COVERS RUN ALL DATABASE SCOPE OPTIONS WHEN ONLY ONE OR A FEW OPTIONS WERE REQUESTED
IC88625 3 SQL0305N IS RETURNED FROM RUNNING DB2LOOK WITH -M (MIMIC) OPTION.
Fix Pack 2  -   Query Compiler Optimizer
IC84600 1 OPTIMIZER MAY CHOOSE SUB-OPTIMAL ACCESS ON RANGE PARTITION TABLES EVEN WHEN THE IN PREDICATE DOES NOT FILTER ANY RECORD
IC88327 1 DB2 OPTIMIZER MIGHT CHOOSE NON-OPTIMAL NLJOIN WHEN DB2_INLIST_TO_NLJN IS ENABLED AND DETAILED INDEX STATISTICS COLLECTED
IC86792 2 OPTIMIZER UNDERESTIMATES THE NUMBER OF EXPECTED ROWS IN A SORT /GROUP BY OPERATOR, WHICH LEADS TO A BAD PERFORMING ACCESS PLAN
IC85425 2 QUERY WITH A UNION AND TWO CORRELATED BRANCHES MIGHT RETURN INCORRECT RESULTS IN PARTITIONED DATABASE ENVIRONMENTS
IC87903 2 IMPROVE ACCURACY OF FILTER FACTOR ESTIMATE FOR NON-CORRELATED EXISTS CLAUSE
IC87878 2 DB2 QUERY OPTIMIZER MIGHT CHOOSE A NON-OPTIMAL ACCESS PLAN FOR QUERIES INVOLVING JOINS ON SKEWED DATA
IC87435 2 OPTIMIZER KEEPS UNNECESSARY COLUMNS AROUND AFTER PARTIAL GB OPERATION AND MIGHT RESULT IN POOR PERFORMANCE
IC88352 2 INCORRECT VALUE IN EXPLAIN_PREDICATE.SUBQUERY WHEN EXPLAINING FROM A SECTION
IC88336 2 RUNNING DB2ADVIS TO RECOMMEND DPF PARTITIONS CAN CAUSE DB2 INSTANCE TO TRAP
IC87434 2 OPTIMIZER MIGHT PRODUCE A NON-OPTIMAL ACCESS PLAN FOR A QUERY USING MULTIPLE OLAP FUNCTIONS
IC88680 2 QUERIES WITH LARGE IN PREDICATES ON THE SAME COLUMN AS AN EQUALITY JOIN MAY PERFORM POORLY
IC88668 2 RUNNING DB2ADVIS TO RECOMMEND DPF PARTITIONS CAN CAUSE DB2 INSTANCE TO TRAP
IC85608 2 XQUERY MIGHT RETURN INCORRECT RESULTS WHEN BOTH 'AND' AND 'OR' PREDICATES EXIST AND ALL PREDICATES CAN BE APPLIED TO XML INDEXES
IC88650 2 QUERIES WITH LARGE IN PREDICATES ON THE SAME COLUMN AS AN EQUALITY JOIN MAY PERFORM POORLY
IC88598 2 HIGHER NLJOIN COSTS RESULT IN SLOWER QUERY PERFORMANCE AFTER UPGRADING TO DB2 9.7
IC87888 2 IMPROVE ACCURACY OF FILTER FACTOR ESTIMATE FOR NON-CORRELATED EXISTS CLAUSE
IC84613 2 DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING PREDICATES ON SUM.
IC87864 3 THE NO_SORT_NLJOIN AND NO_SORT_MGJOIN DB2_REDUCED_OPTIMIZATION OPTIONS ARE NOT CONSIDERED AT OPT LEVEL 7
Fix Pack 2  -   Query Compiler QGM
IC87890 1 CORRELATION TO OUTER JOIN OPERATOR (+) MAY RETURN SQL0206N
IC87897 1 DB2 MAY ABEND IN CREATE PROCEDURE IF THE DATABASE CONFIGURATION AUTO_REVAL SET TO DEFERRED_FORCE
IC88644 1 INCONSISTENT REMOVAL OF TRAILING AND LEADING ZEROS WHEN CONVERTING NUMBER LITERALS TO STRING IN NUMBER DATATYPE MODE
IC84602 2 SETTING VARIABLE WITH DURATION FAILS WITH SQL0901 SQLNQ_CONVERTNODE.
IC87900 2 2-PART NAME REFERENCES TO A FUNCTION MAY FAIL TO RE-RESOLVE AFTER A SCHEMA CHANGE
IC84604 2 ALTER TABLE WITH ALTER FOREIGN KEY DOES NOT RETURN SQL20269N WHEN SPECIFYING 'ENFORCED' OPTION TO A NICKNAME
IC85718 2 QUERY MIGHT FAIL WITH SQL0901N DUE TO PRESENCE OF NICKNAME AND NOT EXISTS PREDICATE
IC88323 2 CRASH WHEN TRIGGER BODY HAS A UPDATE/DELETE STATEMENT WHICH HAS AN EXISTENTIAL SUBQUERY THAT REFERENCES THE TABLE BEING MODIFIED
IC88675 2 TRAP MAY OCCUR WHEN A TEXT SEARCH FUNCTION REFERENCE THE RESULT OF AN OUTER JOIN
IC85198 2 DB2 MIGHT ABEND WHEN EXECUTING EXISTENTIAL SUBQUERIES WITH ROWNUM PREDICATE
IC86053 2 QUERY WITH MULTIPLE CTE AND EXISTENTIAL SUBQUERIES MIGHT PRODUCEINCORRECT RESULTS
IC89174 2 GIVE HIGHER PRIORITY TO GROUP-BY MQT AND STATISTICAL VIEW IN OPTIMIZER PLAN COSTING DECISION
IC87845 2 DB2 MAY ABEND ON A LEFT OUTER JOIN WHEN THE RIGHT TABLE IS UNIONALL VIEW
IC86927 2 DB2 SERVER TERMINATES ABNORMALLY COMPILING A SQL STATEMENT UNDERLOW MEMORY CONDITIONS
IC88340 2 JOIN PUSHDOWN THROUGH COMPLEX UNION ALL OPERATORS MAY NOT OCCUR IN DPF
IC87848 2 DB2 MIGHT ABEND OR FAIL WITH SQL0901N (BAD PLAN; UNRESOLVED QNC FOUND) DURING BIND.
IC87877 2 ORACLE COMPATIBILITY MODE USES BLANK SENSITIVE COMPARISON FOR VARGRAPHIC AND CAN LEAD TO WRONG RESULTS.
IC88350 2 SIGNAL #11 CRASH OR 901 WHEN CALLING SQL PROCEDURE WHILE CASTINGAN OUT PARAMETER MARKER OR HOST VARIABLE
IC83603 2 DYNAMIC QUERY EXECUTION FAILS WITH SQL0302 WHEN NAMED PARAMETER MARKERS ARE USED AND DEFERRED PREPARE IS ENABLED
IC87905 2 IN A HADR SYSTEM, THE REPLAY OF VIEW REGENERATION ON STANDBY DOESN'T ENABLE REPLAY ONLY WINDOW.
IC87851 2 DB2 MAY ABEND IN SQLNG_BUILD_SQLD_VALS_OBJ DURING SQL STATEMENT COMPILATION
IC88353 2 QUERY RE-WRITER UNEXPECTEDLY RE-WRITES A BAD PERFORMANCE SQL
IC87915 2 ORPHAN ENTRIES GOT CREATED FOR STATISTICAL VIEW IN CATALOG PD
IC88358 2 IN A VERY RARE CONDITION, DB2 MAY ABEND DURING THE COMPILATION TO RETRIEVE THE DEFINITION OF AN INDEX.
IC88618 2 DB2 TERMINATES ABNORMALLY WHEN A CURSOR CONSTRUCTOR IS ASSIGNED TO A PARAMETER MARKER
IC87912 2 STATEMENTS REFERENCING ARRAY OR ROW TYPES CAN FAIL WITH SQL0901NIN DPF ENVIRONMENTS
IC88354 2 ADJUST FILTER FACTOR FOR QUERIES WITH HOST VARIABLES AGAINST TABLES WITH CONSTRAINTS
IC88322 2 A UDI SQL STATEMENT THAT REFERENCES AN INVALID VIEW IN WHICH THERE IS AN UNREFERENCED INLINE VIEW CAN CRASH THE DATABASE
IC88328 3 NEW REASON CODE ADDED FOR SQL0270N
IC83801 3 VARCHAR RESULT DATA TYPE INSTEAD OF CHAR WITH VARCHAR2 ENABLED DATABASE
IC87862 3 XML INPUT STORED PROCEDURE/UDF WITH PARAMETER MARKER AND REOPT ALWAYS ENABLED CAN RETURN SQL0901N
IC87885 3 USING A COLUMN WITH EXPLICIT INLINE LENGTH MAY CAUSE BUFFER OVERRUN
Fix Pack 2  -   Relational Data Services
IC87437 1 SKIPPING CLOSING THE CF MANAGEMENT PORT CONNECTION IN SQLRWGETCFAPICMDSTATS
IC88356 1 TRAP DUE TO A TIMING HOLE IN THE SERIALIZATION LOGIC BETWEEN INVALIDATING AND DROPPING
IC88624 2 PERFORMANCE DEGRADATION WHEN PACKAGE CACHE IS FULL AND MANY STATEMENTS ARE IN THE CACHE
IC85617 2 MEMORY CORRUPTION CAUSES INSTANCE TRAP IN SQLYT_TRF_DEALLOC, SQLOFMBLKEX
IC88357 2 ANONYMOUS BLOCK DEADLOCK OCCURS WHEN RUNSTATS IS PERFORMED PREVIOUSLY IN THE SAME TRANSACTION
IC88701 2 STANDBY DATABASE FAILS TO START WITH SQL1224N WHEN CONNECT_PROC IN NOT NULL
IC87286 2 IMPROVE PARSING ROBUSTNESS FOR OPTIMIZER GUIDELINES
IC85841 2 BATCH INSERTS CAUSING DUPLICATE ROWS WHEN USING NULLIDRA (REOPT=ALWAYS) VS. NULLIDR1 (REOPT=ONCE)
IC87843 2 DRDA HAS EXTRA SQLCARD WITH DB2_DEFERRED_PREPARE_SEMANTICS=YES
IC88608 2 GROWING PACKAGE CACHE WITH INCREASED NUMBER OF STATEMENT ENTRIESON STATEMENT CONCENTRATOR ENABLED DB.
Fix Pack 2  -   Security
IC88307 3 DB2RBIND COMMAND WITH OPTION ALL RETURNS SQL0551N, AFTER RUNNINGDB2UPDV97.
Fix Pack 2  -   XML
IC87881 2 LATCH CONTENTION ISSUE IN XML PATHID CACHE COULD CAUSE PERFORMANCE ISSUES.
IC87904 2 MISSING ON RESETTING POINTER AFTER FREEING MEMORY BLOCK CAUSES UNEXPECTED CHECKING ON THE CONTENT OF POINTER.
IC87886 3 THE PCTINLINED COLUMN IN THE SYSIBM.SYSCOLUMNS TABLE DOES NOT GET UPDATED EVEN THOUGH DB2CAT SHOWS THE XML STATS ARE COLLECTED


DB2 Version 10.1 Fix Pack 1
APAR Sev. Abstract
Fix Pack 1  -   Security APARs
IC84716 1 SECURITY: SQLJ.DB2_INSTALL_JAR DIRECTORY ESCAPE VULNERABILITY (CVE-2012-2194).
IC84751 1 SECURITY: GET_WRAP_CFG_C AND GET_WRAP_CFG_C2 ALLOWS UNAUTHORIZED ACCESS XML FILES (CVE-2012-2196).
IC84755 1 SECURITY: STACK BUFFER OVERFLOW VULNERABILITY IN JAVA STORED PROCEDURE INFRASTRUCTURE (CVE-2012-2197).
IC85513 1 SECURITY: UTL_FILE could allow unauthorized access to files (CVE-2012-3324).
Fix Pack 1  -   HIPER APARs
IC83823 1 WITH REOPT ENABLED, STATEMENTS CONTAINING ARRAY OR ROW VARIABLES MIGHT PRODUCE INCORRECT OUTPUT
Fix Pack 1  -   Special Attention APARs
IC83469 1 INCORRECT RESULTS AFTER LOAD INTO TABLE WITH CONSTRAINTS FOLLOWED BY ATTACH OR DETACH
IC84856 1 INDEX CORRUPTION MAY BE INTRODUCED DURING A DATABASE UPGRADE FROM DB2 VERSION 9.5 TO DB2 VERSION 10.1
IC84899 1 DATABASE OPERATIONS MIGHT FAIL WITH "KEY DATA MISMATCH" ERRORS, OR ROWS THAT EXIST IN THE DATABASE CANNOT BE FOUND
IC85221 1 SQL WITH NESTED MATH OPERATIONS ON COLUMNS THAT ARE DEFINED WITH NOT NULL AND USING FUNCTIONS MAY RETURNED DIFFERENT RESULTS.
Fix Pack 1  -   JDBC Driver
IC84379 3 JCC T4 INCORRECTLY RETRIEVES SOME JAPANESE MULTI-BYTE KANJI CHARACTORS FROM IBM-932 DATABASE.
IC85319 2 IN BATCH UPDATE, SETDBSTRINGASBYTES() FAILS WITH ERROR CODE -4476
IC86501 2 USER IS GETTING SQL181 ERROR, WHEN THEY ATTEMPT TO INSERT A TIME STAMP INTO A Z/OS DB2 10 NFM USING JCC 3.63.75, SQL181
IC85777 2 DB2CONNECT:THE RETRY LOGIC FOR TIMESTAMP TYPE IS NOT USING DESCRIBED INFO THUS CAUSING -352 SQL ERROR
Fix Pack 1  -   Administration Tools
IC84138 2 ON DPF IF DIAGPATH IS SPLIT PER HOSTNAME OR PER HOSTNAME/NODENAME, ALL QUERY PATROLLER (QP) DIAGNOSTICS LOGS STOP BEING GENERATE
IC84213 2 AUTOMATIC BACKUP IMAGES CANNOT BE PRUNED IF THE DATABASE WAS ACTIVATED WITH THE ALIAS NAME
IC84566 2 DB2LOOK UTILITY HAS PASSWORD LIMITATION
IC84347 2 SYSPROC.ADMIN_DROP_SCHEMA FAILS WITH SQL0478 IN DATABASE ENABLEDFOR ORACLE COMPATIBILITY
IC84244 2 CALL CAPTURE_STORAGEMGMT_INFO RETURNS ERROR SQL0443N, "SQL0407 TOKEN:TBSPACEID=2, TABLEID=8, COLNO=3 ". SQLSTATE=38553
IC84354 2 DB2LOOK -D <DBNAME> -F -M -L -A -E -O DB2LOOK.TXT RETURNS SQL0811N TRYING TO SELECT ALTERNATIVE DATA TYPES.
IC84124 2 DB2LOOK GENERATES INCORRECT RESTART VALUE FOR ALTER SEQUENCE DDL
IC84155 2 DB2MOVE REPORTS ERRORS FOR SEVERAL TABLES DURING LOAD PHASE BUT EXITS WITH RETURN CODE 0 AFTERWARDS
IC84430 3 DB2DCLGN DOES NOT ADD A NULL TERMINATOR (\0) PLACE HOLDER FOR VARCHAR COLUMN WHEN GENERATING STRUCTURES FOR C LANGUAGE
IC84137 3 ADMIN_DROP_SCHEMA FAILED WHEN ONLY INOPERATIVE OBJECTS EXIST IN A SCHEMA
IC84349 3 SQL22220 OCCURS FOR CREATING TABLES DDL IN CONTROL CENTER TOOL
Fix Pack 1  -   Buffer Pool Services
IC84265 1 DB2 MAY PANIC DURING ATTEMPT TO UNFIX (SQLBUFIX) A PAGE FROM BUFFERPOOL
IC84300 1 ROLLFORWARD FAILS WITH SQL1042 OR CRASH RECOVERY FAILS WITH DB2DIAG.LOG ENTRY MESSAGE: DIA8709E.
IC84499 2 DB2 PAGE CLEANERS MAY RECEIVE SIG 11 WHEN 'DB2_USE_ALTERNATE_PAGE_CLEANING=ON' AND 'SET WRITE SUSPEND/RESUME' IS USED
IC84352 2 DB2 ABEND ON DROP TABLESPACE COMMAND
IC84529 2 A PREFETCH REQUEST AT A HIGH OFFSET INTO A LARGE TABLESPACE MAY LEAD TO A HANG SITUATION.
IC84583 2 WRONG PREFETCH SIZE CALCULATION FOR AUTOMATIC STORAGE
IC84458 2 CAN DROP A RANGE PARTITIONED TABLE WITH AN ACTIVE QUIESCE TABLESPACE LOCK, SHOULD RETURN SQL0290N INSTEAD
IC84453 2 EXTENT RECLAIM ON MDC TABLES MAY RETURN SQL0984C AND CAUSE THE INSTANCE CRASH.
IC84452 2 ALTER TABLESPACE SIZE TO A LARGE VALUE ON RAW DEVICE MAY CAUSE DB2 TRAP
IC84242 2 UNNECESSARY CHECKING FOR TEMPORARY TABLESPACE CONTAINER SIZE INHIBITS REDIRECTED RESTORE.
IC84151 2 ROLLBACK OF A DEFERRED BUFFER POOL ALTER CAUSES AN INSTANCE ABEND IN SQLBUNCHAINUCALTER
IC84313 2 A PAGE CORRUPTION WHICH WAS DETECTED BY A DB2 PREFETCHER SHOULD CREATE FODC DIRECTORY
IC84240 2 SQL0973 ERRORS, DATABASE MEMORY OVERFLOW EXHAUSTED AFTER INCREASE BUFFERPOOL FAILURE
IC84538 2 BACKUP OF SMS TABLESPACE CAN FAIL TO DETECT INVALID PAGE HEADERS
IC84596 2 INCORRECT SPACE ESTIMATION MAY RESULT IN SQL2094 DURING ALTER TABLESPACE WITH REBALANCE
IC84141 2 PERFORMANCE SLOWDOWN DURING BUFFER POOL FLUSH WHEN STMM IS ALTERING THE BUFFER POOL, ONLINE BACKUP RUNNING, AND PAGE CLEANERS PA
IC84573 3 DB2TBST NOT RETURNING PROPER STATE FOR CERTAIN HEXADECIMAL TABLESPACE STATE VALUE.
IC84295 3 THE SQLBFTPQ API FUNCTION MAY RETURN AN INCORRECT SQL2032N ERRORMESSAGE
IC84140 3 DATABASE ACTIVATION IS SLOW WHEN THERE ARE MANY DMS CONTAINERS DEFINED ON LARGE DPF SYSTEMS.
Fix Pack 1  -   Build
IC84511 2 DIAGLEVEL=0 IN DB2CLI.INI DOESN'T HAVE ANY EFFECT. 'EVENT' MSG LOGGING IN DB2DIAG.LOG IS NOT NEEDED WHEN DIAGLEVEL=0 ON CLIENT
Fix Pack 1  -   Client Interfaces
IC84563 1 WITH MULTI-ROW INSERT, AFTER AN APPLICATION ENDS CHAINING AND ITFAILS, THE NEXT SQLFETCH GETS ERROR CLI0115E
IC85627 1 TRAP CALLING SQLEXECUTE FOR AN INSERT STATEMENT FOR A DB2 FOR Z/OS DATABASE.
IC85232 1 SQL0332N ERROR RECEIVED ON SQLGETCURSORNAME WHEN EXECUTING CLI APPLICATION USING A DB2 CLIENT FROM VERSION 9.7.0.6 OR 9.7.0.5
IC85794 1 DB2TRCSTARTUPSIZE HAS NO EFFECT - PERF ISSUE WITH CLIENTS, IF NO'DB2TRC ALLOC' ISSUED ON AIX
IC85847 1 SQL0843N DURING CONNECT JUST AFTER DISCONNECT USING SAME CONNECTION HANDLE WHEN CLIENT INFO PROPERTIES ARE SET
IC84520 2 DB2DSDCFGFILL DID NOT CONVERT THE "TARGET PRINCIPAL" SETTING FORA DATABASE CATALOG ENTRY
IC83841 2 WHEN SQLGETINFO() FAILS FOR SQL_DRIVER_BLDLEVEL, SQLGETDIAGREC()IS NOT RETURNING ANY DIAGNOSTIC INFORMATION.
IC84308 2 ACCESS VIOLATION IN SQLEINITAPPLICATIONENVIRONMENT() IN MSDTC.EXE ENVIRONMENT
IC84437 2 SQL0303N IS RETURNED WHEN SELECTING VALUES OF ZOS DATA TYPES TIMESTAMP_TIMEZONE
IC84591 2 EMPTY FOLDER "C_IBM_DATA_SERVER_DRIVER_FOR_ODBC_CLI_CLIDRIVER" IS GETTING CREATED IN THE DEFAULT PATH EVEN ON PROVIDING THE APPD
IC84447 2 MACHINE.CONFIG SHOULD NOT BE UPDATED FOR NON-DEFAULT COPY
IC83844 2 DB2 CLIENT INCORRECTLY INVOKES SYSPROC.SQLPROCEDURECOLS() WHEN STORED PROCEDURE WITH TIMESTAMP INOUT/OUT PARAMS ARE CALLED
IC84335 2 IF THE CLI/ODBC CONFIGURATION KEYWORD TRACEREFRESHINTERVAL IS SET, THE VALUE OF TRACEPIDLIST MIGHT CHANGE UNEXPECTEDLY.
IC84521 2 MEMORY LEAK IN APPLICATION OR MSDTC.EXE USING IBM DS DRIVER WHENPARSING THE DB2DSDRIVER.CFG FILE & CACHE INSTANCE INFO
IC84133 2 DB2.NET MAY NOT FIND A PARAMETER IN THE DB2DSDRIVER.CFG FOR INSTANCE BASED CLIENTS.
IC83840 2 ERROR FOR EXECUTING DB2BATCH IN DB2DIAG.LOG WITH V9.7 FP5
IC84165 2 ALLOW TO TURN OFF SQLCODE MAPPING (LIKE NOMAP IN DCS PARAMETER STRING) FOR THE IBM DATA SERVER DRIVER FOR ODBC AND CLI
IC84491 2 DB2 PREP MAY RETURN SQL0008N.
IC84150 2 DB2CFIMP <FILENAME> UPDATES DBM CFG PARAMETERS INCORRECTLY WHEN VALUES SET TO AUTOMATIC; CLIENT CONNECTIONS WILL HANG
IC84191 2 GRAPHIC KEYWORD GETS RESET AFTER ENLISTING IN MSDTC. THIS CAN CAUSE SQL SERVER TO FAIL WITH -332 ERROR.
IC84350 2 CLI0100E SQLSTATE 07001 RETURNED FROM VISUAL STUDIO QUERY BUILDER USING DB2.NET PROVIDER
IC84766 2 COMPILATION ERROR DUE TO SQLCLI1.H HAVING C++ STYLE COMMENTS FORATTRIBUTE SQL_ATTR_SQLCODEMAP
IC84218 2 SYSTEM.OBJECTDISPOSEDEXCEPTION IN IBM.DATA.DB2.DB2CONNPOOL.FINALIZE() WHEN UNLOADING APPDOMAIN
IC84528 2 DB2CFEXP DOES NOT EXPORT SOME DATABASE MANAGER PARAMETERS.
IC84298 2 SQL30108N ERROR RETURNED - SEAMLESS FAILOVER WITH SCROLLABLE CURSORS AND DB2 FOR Z/OS
IC84568 2 SQLSETSTMTATTR WITH SQL_ATTR_CHAINING_END INCORRECTLY RETURNS SUCCESS
IC85803 2 USING ATTACH=TRUE DURING CONNECT THROWS SQL0843N
IC84419 2 EMBEDDED SQL APPLICATION MAY CRASH WHEN USING MULTIPLE CURSORS WITH LOB OR XML COLUMNS.
IC84280 2 DB2BULKCOPY LOADS INCORRECT VALUES WHEN THE COLUMN IS DECIMAL AND DECFLOAT(16) AND THE FIRST VALUE IN THET COLUMN IS NULL
IC83940 2 [IBM][DB2.NET] SQL0902 AN UNEXPECTED EXCEPTION HAS OCCURRED IN PROCESS. CLI DRIVER CRASHES IN CLI_CSIPOSTCONNECT
IC84342 2 DB2DATAADAPTER.UPDATE(DATASET) THROWS DB2EXCEPTION TRYING TO UPDATE ROW TO SAME VALUES
JR43257 2 MQSEND DOESN'T SEND A DATAGRAM BY DEFAULT
IC84159 2 LICENSE CACHE CHECKING CAN CAUSE SLOW DATABASE CONNECTS FROM CLIAPPLICATIONS WHEN MULTIPLE CONCURRENT CLI CONNECTIONS OCCUR
IC84420 2 A MULTITHREADED CLIENT RUNNING WITH WLB ENABLED AND CONNECTED TOA PURESCALE MEMEBER MAY TRAP.
IC84356 2 MEMORY LEAK WITH DS DRIVER WHEN PROCESSING DB2DSDRIVER.CFG KEYWORDS IN .NET
IC85879 2 CAN NOT READ PROPERTIES E.G ACR FROM DB2DSDRIVER.CFG
IC84228 2 DB2.NET ENTITY PROVIDER FAILS WITH THE CONNECTED SERVER DOESN'T SUPPORT TOP EXPRESSION ERROR.
IC84299 2 CANNOT CONNECT TO DATABASE FROM CLP WHEN USING DB2DSDRIVER.CFG. DB2DIAG.LOG ERROR: CANNOT OPEN SHARED OBJECT LIBDB2CLIXML4C.SO
IC84438 2 PRECOMPILING OR BINDING AGAINST DB2 FOR Z/OS MAY RETURN ERROR SQL0101N
IC84436 2 CLI0129E RETURNED FROM A DB2 .NET ENTITY FRAMEWORK APPLICATION
IC84442 2 DB2LOOK RETURNS ERROR SQL0083C AND TRAPS
IC84584 3 WHILE BINDING CLI PACKAGES AN ERROR IS BEING THROWN AND IS BEINGTREATED AS WARNING , INSTEAD OF THROWING A WARNING!
IC84396 3 GIVES SEGMENTATION FAULT WHEN SQLEXECUTE CALLED TO INSERT STRING VALUE IN INTEGER FIELD WITH ARRAYINPUTCHAIN
IC84592 3 CREATE VIEW STATEMENT RAN FROM .NET LOSES NEW LINE CHARACTERS WHEN STORED IN SYSCAT.VIEWS
IC84409 3 CURRENTOPTIMIZATIONPROFILE DB2CLI.INI KEYWORD IS IGNORED BY THE CLI DRIVER WHEN DB2 CLIENT IS CONFIGURED FOR MULTI-CONNECT
IC84519 3 CLI/.NET APPLICATIONS FAIL WITH SQL30020N/SQL30081N WHEN EXECUTING A STORED PROCEDURE WITH A RETURN VALUE, AND LOB IN PARAMETER
IC84427 3 .NET AND CMX SHOULD SEND THE CONNECTIONS PROPERTIES SET IN DB2DSDRIVER.CFG IN THE POSTCONN MESSAGE
IC84445 3 IMPORT FROM A REMOTE CLIENT WHERE THE IMPORT FILE IS PROCESSED ON THE SAME CLIENT FAILS WHEN THE FILE HAS EMPTY STRINGS.
IC84325 3 DB2DSDCFGFILL WILL NOT ALWAYS GENERATE PROPER DB2DSDRIVER.CFG FOR DCS ENTRIES.
IC84465 3 SQLCONNECT FAILS WITH CLI0124E WHEN CAPTUREMODE=ON AND PDQXML FILE IS NOT SPECIFIED.
IC83842 3 PROPER MESSAGE IS NOT THROWN WHEN DB2CLI INSTALL -CLEANUP -FORCEOPTION IS USED AFTER DB2CLI INSTALL -CLEANUP OPTION
IC84173 2 SQLERRM IS NOT SET WHEN A USER-DEFINED MESSAGE FOR RAISE_APPLICATION_ERROR FUNCTION EXCEEDS 70 BYTES.
IC84603 2 DATABASE CRASH DUE TO INCORRECT ROW WIDTH WHEN INSERTING INTO A TEMPORARY TABLE WITH XML COLUMNS IN A MERGE JOIN.
IC84524 2 IN DPF, XML QUERIES INCLUDING XMLTABLE EXPRESSIONS USING BIND-INHOST VARIABLES CAN RESULT IN BADPAGE ERROR DUE TO A BAD EXECUTI
IC84253 2 VARCHR_FORMAT OR TO_CHAR FUNCTION RETURNS SQL20477N IF DECIMAL-FLOATING-POINT-EXPRESSION IS LESS THAN 1E-6 IN DECIMAL NOTATION
IC84443 2 DATABASE MIGHT CRASH WITH SIGSEGV SIGNAL DURING QUERY INVOLVING CASTING.
IC84266 2 CHANCES OF MEMORY LEAK INTRODUCED IN VERSION 9.7 FIX PACK 5
IC84363 2 THE DB2EXPLN TOOL MAY HANG.
IC84322 2 DB2 INSTANCE MAY ABEND IN SQLRISECTINITXMLERROREXIT IF DATABASE APPLHEAPSZ IS EXHAUSTED
IC84129 2 DB2 DOES NOT SUPPORT DDMONYYYY TIMESTAMP FORMAT NATIVELY
IC84361 2 PANIC IN SQLDINVCURSORPOS() FUNCTION DURING A COMMIT OF A TRANSACTION INVOLVING A GLOBAL VARIABLE IN DPF
IC84185 2 SQL0303N DURING EXECUTION OF SQL STORED PROCEDURE THAT INVOLVES THE CONVERSION BETWEEN CHAR TYPES AND NCHAR/GRAPHIC TYPES
IC84236 2 QUERY RETURNS INCORRECT RESULTS FOR A CORRELATED SUBQUERY AGAINST A DATA PARTITIONED TABLE.
IC84180 2 DATABASE MIGHT CRASH WITH SIGSEGV SIGNAL DURING QUERY INVOLVING CASTING.
IC84284 2 DBMS_SQL.IS_OPEN INCORRECTLY RETURNS INTEGER INSTEAD OF BOOLEAN
IC84575 2 WRONG RESULTS FROM CONVERTING A TIMESTAMP FIELD TO A STRING TYPEWITH THE ISO WEEK FORMAT SPECIFICATION 'IW'
IC84216 2 LIKE CLAUSES MIGHT RETURN INCORRECT RESULTS FOR COLUMNS WITH VARCHAR DATA TYPE IN UNICODE DATABASES
IC84188 2 DEADLATCH IN SMP CAN LEAD TO A HANG SITUATION
IC85513 2 SECURITY: THE UTL_FILE COULD ALLOW UNAUTHORIZED ACCESS TO FILES (CVE-2012-3324).
IC84255 2 IF THERE IS A BINARY ZERO UTL_FILE WRITES CONTENTS OF THIS STRING ONLY UP TO THE FIRST BINARY ZERO
IC84656 2 DB2 MAY ABEND WITH SIGSEV WHEN USING XMLTABLE FUNCTION
IC84259 2 CHANCES OF MEMORY LEAK INTRODUCED IN VERSION 9.7 FIX PACK 5
IC85221 2 SQL WITH NESTED MATH OPERATIONS ON COLUMNS THAT ARE DEFINED WITHNOT NULL AND USING FUNCTIONS MAY RETURNED DIFFERENT RESULTS.
IC84226 3 SQL0130N IS RETURNED WHEN "LIKE NULL" PREDICATE IS USED IN A DATABASE CREATED WITH UCA500R1 COLLATING SEQUENCE
IC84128 3 DB2 ABEND WITH SIGNAL 11 DUE TO LOGGING ON ERROR IN SQLRIXMLAGG,
IC84307 3 LENGTH RESTRICTION OF FUNCTION DBMS_UTILITY.EXEC_DDL_STATEMENT
Fix Pack 1  -   Communication
IC83679 2 AFTER AN APPLICATION IS FORCED ON A WINDOWS DATABASE SERVER, THECLIENT PROGRAM HANGS.
Fix Pack 1  -   DB2 Tools
IC84751 1 SECURITY: GET_WRAP_CFG_C AND GET_WRAP_CFG_C2 ALLOWS UNAUTHORIZEDACCESS XML FILES (CVE-2012-2196).
IC84489 2 MANY TCPIP SOCKET MAY REMAIN OPEN WHILE DEBUGGING A STORED PROCEDURE WITH OPTIM DEVELOPMENT STUDIO.
IC84527 2 ADMIN_COPY_SCHEMA IS NOT WORKING WITH SJIS DATABASE IF THE INSTANCE IS STARTED WITH 819 CODEPAGE
IC84522 3 'ALTER SEQUENCE <SEQUENCE_NAME> RESTART WITH <VALUE>' STATEMENT IS NOT GENERATED BY DB2LOOK UTILITY.
IC84468 3 MEANINGLESS EVENT RECORD MIGHT BE LOGGED IN WINDOWS APPLICATION EVENT LOG
IC84535 3 AUTOMATIC IS REMOVED WHEN DB2CFEXP EXPORTS DATA
IC84523 3 LOAD USING ADMIN_CMD RETURNS SQL1191N WHEN A DELIMITED COLUMN NAME IS SPECIFIED IN METHOD N CLAUSE
IC84245 3 "DB2ADUTL DELETE LOADCOPY OLDER THAN" FAILS IN DB2 VERSION 97FP5
Fix Pack 1  -   DRDA Services
IC84551 1 DB2 ZOS V8 CLIENT REPORTS SQL0406 WHEN QUERYING BIGINT COLUMNS ON DB2 LUW V9.7 SERVER
IC84237 1 DB2 INSTANCE MAY CRASH WITH SIGNAL #11 WHEN AUTHENTICATION TYPE DATA ENCRYPTION IS IN USE.
IC84397 2 DB2 MIGHT NOT CLOSE CLIENT SIDE CURSORS IF AN XA APPLICATION INVOKES XA_ROLLBACK.
IC84257 2 CONNIDLETIME THRESHOLD EVALUATION MAY HIT SIGSEGV DUE TO A STACKCORRUPTION
IC84424 2 DB2APP.DLL HAS CAUSED A STACK OVERFLOW EXCEPTION (0XC00000FD) WHEN TRYING TO WRITE TO MEMORY LOCATION 0X00032FFC ON THREAD 0
IC84392 3 ERROR "THE DDM PARAMETER VALUE IS NOT SUPPORTED" WHEN YOU TRY TOINSERT LOB DATA INTO A COLUMN THAT IS NOT WIDE ENOUGH FOR IT.
IC84496 3 DIAGLEVEL=0 IN DB2CLI.INI DOESN'T HAVE ANY EFFECT. 'EVENT' MSG LOGGING IN DB2DIAG.LOG IS NOT NEEDED WHEN DIAGLEVEL=0 ON CLIENT
Fix Pack 1  -   Data Management Services
IC83469 1 INCORRECT RESULTS AFTER LOAD INTO TABLE WITH CONSTRAINTS FOLLOWED BY ATTACH OR DETACH
IC84167 2 TRAP IN SQLBFIX WHEN RUNNING UPDATE STATEMENT WITH WHERE CURRENTOF CURSOR (DEFINED AS WITH HOLD) CLAUSE ON A PARTITIONED TABLE
IC84189 2 INPLACE REORG FAILS IN SQLDFIX2OR3PAGES RESULTING IN AN INSTANCECRASH
IC84495 2 IN RARE TIMING SCENARIOS WHEN INTRA_PARALLEL ENABLED, A SORT OPERATION THAT SPILLS MAY FAIL WITH SQLSMERGEREC, PROBE:2050.
IC85837 2 DB2 CRASHES (FORCEDDBSHUTDOWN) AFTER HITTING AN EOF ERROR, USINGMDC OR ITC TABLES ONLY.
IC83076 2 DB2 MAY TRAP ON A STANDBY SYSTEM IN AN HADR ENVIRONMENT WHERE READS ARE BEING DONE ON THE STANDBY SYSTEM
IC84383 2 DROP TABLE COMMANDS ARE SOMETIMES SLOW IN DB2 PURESCALE ENVIRONMENTS
IC84653 2 DATABASE CRASHED WHILE CLOSING THE TEMP FILE HANDLE DURING AN UNDO OPERATION.
IC84131 2 IF A LOG FULL IS HIT BY LOAD, BLANK PAGES COULD REMAIN IN BUFFERPOOL CAUSING DATABASE TO BE MARKED BAD IF REUSED BY LOAD RESTART
IC84207 2 UPGRADE OR RESTORE CAN HANG IF TABLE HAS COMPRESSION DICTIONARY
IC84162 2 DB2 MAY TRAP WHEN UNFIXING THE LAST PAGE OF A TEMP TABLE DUE TO A TIMING HOLE ISSUE
IC84605 3 DB2 PERFORMANCE ISSUE WHEN XML DATA IS BEING USED HEAVILY.
Fix Pack 1  -   Data Management Utilities
IC84337 2 DB2 BACKEND PROCESS MIGHT CRASH WHEN EXPORTING WITH XMLSAVESCHEMA FROM AN UNDEFINED TABLE HAVING AN XML COLUMN.
IC84405 2 SYSCATSPACE MAY BE PUT IN RESTORE PENDING IF LOAD COPY FILE IS MISSING ON HADR STANDBY OR DURING ROLLFORWARD
IC84503 2 OUT OF APPLICATION HEAP MEMORY IN CLI LOAD CAN CAUSE INSTANCE ABEND
IC84362 2 LOAD INTO RANGE PARTITIONED TABLE WITH COPY YES MAY FAIL WITH SQL0901N ON SANITY CHECK WITH SQLUTRANSFORMMERGEFSCRREQUEST
IC84360 2 LOAD MIGHT FAIL WITH -2038 ON A PARTITIONING SUBAGENT WHEN LOADING CONCURRENTLY TO THE SAME TABLE WITHOUT PARTITIONING_DBPARTNUM
IC84187 2 LOAD ABENDS INSTANCE ON LOADING VARCHAR INTO LONG VARCHAR COLUMNFROM IXF FILE
IC83383 2 LOAD RESTART MIGHT INSERT INVALID TIMESTAMPS INTO TABLE WITH ROWCHANGE TIMESTAMP COLUMNS
IC83399 2 HPU MIGHT HANG WHEN RUNNING IN PARALLEL ON DIFFERENT TABLES DEFINING IN THE SAME TABLESPACES
IC84353 2 IN DPF ENV., LOADING FROM REMOTE FETCH CURSOR BETWEEN DIFFERENT ENDIAN-BASED PLATFORMS MIGHT CAUSE DATA LOSS
IC84435 2 LOAD OPERATION CAN CAUSE INSTANCE TO TRAP IN DB2LFRM AGENTS.
IC84581 2 DUPLICATE RECORDS AFTER REDISTRIBUTE ABORT
IC84154 2 LOAD CAN INSERT WRONG DATE VALUES AND / OR FAIL WITH SQL0181N
IC84467 3 WHEN IMPORT FROM FILE ENCODED IN UTF-8 INTO COLUMN DEFINED AS GRAPHIC ON UNICODE DATABASE, STRING MAY BE TRUNCATED.
IC84429 3 AN ERROR MIGHT OCCUR FOR SYSPROC.ADMIN_CMD EXECUTION OF RUNSTATS/IMPORT/LOAD WHEN NON-ASCII CHARACTERS APPEAR IN COMMAND STRING
IC84351 3 DATA BUFFER IN LIST HISTORY COMMAND IS ALWAYS DISPLAYED AS 0
IC84161 3 LOAD JOB FAILS WITH ERROR MESSAGE SQL2044 RC=1 ON THE WINDOWS PLATFORM.
IC84390 3 IMPORT UTILITY CRASHES DUE TO MISSED COLUMN
IC84391 3 IMPORT DOES NOT GIVE CORRECT ORIGINAL ERROR MESSAGE IF IT FAILS WITH AUTHORIZATION ISSUE WHILE DOING IMPLICIT BIND
IC84863 3 LOAD HANGS WITH ALL LOAD FORMATTERS(DB2LFRM) WAITING FOR SYNCUP OR TRANSFER BUFFER.
IC84263 3 REDISTRIBUTE UPDATES TABLE PACKED DESCRIPTOR AND OVERWRITES UPDATES OF RUNSTATS
IC84428 3 AN ERROR MIGHT OCCUR FOR SYSPROC.ADMIN_CMD EXECUTION OF RUNSTATS/IMPORT/LOAD WHEN NON-ASCII CHARACTERS APPEAR IN COMMAND STRING
Fix Pack 1  -   Data Recovery Services
IC84254 1 DB2ADUTL TRUNCATES THE USERNAME AND NODENAME TO 7 CHARACTERS
IC84533 1 IN SUPER ASYNC MODE, HADR STANDBY COULD CRASH IN LOCAL CATCHUP STATE AFTER DEACTIVATING PRIMARY DATABASE
IC84588 1 MEMORY LEAK COULD HAPPEN ON DB2 HADR STANDBY
IC84472 2 DB2ADUTL UPLOAD CONATINS MULTIPLE PERFORMANCE AND USABLILTY PROBLEMS
IC84125 2 DATABASE COULD BECOME OFFLINE WHEN STOPPING HADR ON PRIMARY
IC84463 2 DB2CKBKP ERRORS DURING MEDIA HEADER VALIDATION OF AN IMAGE PART,WHEN AN ERROR HAS BEEN DETECTED IN THE PREVIOUS IMAGE PART
IC84331 2 RESTORE FAILS DUE TO NOT BEING ABLE TO OPEN A LOG FILE IN SQLPGRML() PROBE 80
IC83778 2 MEMORY LEAK USING TWO_PHASE COMMIT TRANSACTIONS AND ACTIVITY INVOLVING LOG SCANNING
IC84269 2 ADD LOGFILE EXTENT NUMBER TO SQLPSUSPENDLOG MESSAGE
IC84290 2 IMPROVE DB2CKLOG TOOL TO PROVIDE MORE DIAGNOSTIC INFORMATION
IC84157 2 CRASH RECOVERY MAY FAIL IF THE MIRROR LOG IS MORE RECENT THAN THE SAME ACTIVE LOG DUE TO LOST I/O ON THE ACTIVE LOG FILE.
IC84500 2 DB2ADUTL UPLOAD CONATINS MULTIPLE PERFORMANCE AND USABLILTY PROBLEMS
IC84475 3 DB2CKBKP THROWS FALSE ERRORS WHEN CHECKING V9.1 AND V9.5 IMAGES UNDER V9.7
IC84514 3 DB2ADUTL UPLOAD CONATINS MULTIPLE PERFORMANCE AND USABLILTY PROBLEMS
IC84476 3 IMPROVED BACKUP IMAGE VALIDATION FOR DB2CKBKP
IC84418 3 ENHANCE TABLESPACE BLOCKING WAITER CONTROL BLOCK LIST DEFAULT VALUE
IC84271 3 BACKUP PERFORMANCE DEGRADATION UPGRADING TO 9.7 FP1+
IC84230 3 HADR STANDBY MAY TRY TO RETRIEVE LOG FILES EVEN WHEN LOG ARCHIVEMETHOD IS SET TO LOGRETAIN
IC84281 3 IMPROVE DIAGNOSTIC MESSAGE DURING TABLE SPACE ROLLFORWARD
IC84256 3 DB2ADUTL UPLOAD TOOL DOESN'T ACCEPT RELATIVE PATH
Fix Pack 1  -   Engine Sample
IC85977 3 SAMPLE BUILD SCRIPTS FOR DB2 ON HPUX NEED TO BE MODIFIED TO INCLUDE -MT AND -LUNWIND OPTIONS
Fix Pack 1  -   Federation
IC84234 2 ORACLE WRAPPER FAILS TO CONNECT TO ORACLE DATA SOURCE BECAUSE OFORA-28011 ERROR
IC84655 2 ODBC WRAPPER DOES NOT ROLLBACK CURRENT TRANSACTION WHEN IT GETS A GENERAL CONNECTION ERROR
IC84297 2 FEDERATION SERVER RECEIVED SQLCODE -1476 AND -430 INTERMITTENTLY. ERROR IS LOGGED IN DB2DIAG.LOG.
IC84233 2 THE DATA IS TRUNCATED WHEN THE CODEPAGES ARE DIFFERENT BETWEEN LOCAL DB2 DATABASE AND REMOTE DB2 DATABASE
IC84553 2 DRDA WRAPPER REPORTS SQL0206N WHEN ACCESSING NICKNAMES POINTING TO DB2 LUW V95 DATA SOURCE OR EARLY VERSION
IC84143 2 CREATE NICKNAME FAILED FOR AN INFORMIX TABLE WITH MORE THAN 2147483647 ROWS
JR43118 2 DELETE/UPDATE WITH WHERE CURRENT OF CURSOR CLAUSE COULD OPERATE ON THE INCORRECT RECORD
IC84532 2 CAN NOT CREATE NICKNAME FOR CLASSIC FEDERATION OBJECT BY USING ODBC WRAPPER IN V95FP9
IC84147 2 SQL1469N MAY REPORT BECAUSE DRDA WRAPPER INCORRECTLY FORWARD THECONNECT NODE NUMBER TO DATA SOURCE
IC85649 2 SELECT STATEMENT GOT SQL0901N WHEN IT HAS A LIKE PREDICATE WITHA NICKNAME
IC84448 2 FUNCTION CALLS LIKE TRUNC(SYSDATE-0.1,'HH24') CAN NOT BE PUSHED DOWN TO REMOTE ORACLE SERVER
IC84232 2 TRAP HAPPENS WHILE QUERY ON A NICKNAME OF XML WRAPPER
IC84169 2 ORACLE WRAPPER FAILS TO CONNECT TO ORACLE DATA SOURCE BECAUSE OFORA-28011 ERROR
IC84684 2 JDBC WRAPPER MAY RETURN SQL1822N WHEN A CONSTRAINT VIOLATION OCCURS.
IC84333 2 DDLS ON NICKNAME CAUSE DEADLOCK
IC84398 3 RECEIVED "UNDEFINED SYMBOL: .__MAGIC4" WHILE RAN DJXLINKINFORMIXWITH INFORMIX CLIENT SDK 3.70
IC84326 3 LATCH LEAKED MESSAGES IN THE LOGS DUE TO LATCH SQLO_LT_SQLE_FEDFMP_APP_CB__FMPAPPLATCH
Fix Pack 1  -   Index Manager
IC84509 2 AIC IS NOT PUT INTO SUSPENDED STATE AFTER RECEIVING -954 ERROR. IF AIC IS NOT IN SUSPENDED STATE, IT IS NOT INVOKED FOR RETRY.
IC85149 2 REORG TABLE WITH THE RECLAIM EXTENTS OPTION AFTER LOAD OR REDISTRIBUTE MIGHT LEAD TO MEMORY CORRUPTION
IC85405 2 REBUILDING THE INDEX OBJECT AFTER REORG INDEXES WITH THE RECLAIMOPTION MIGHT LEAD TO CORRUPTION WHEN THE TABLE SPACE GETS FULL
IC84279 2 SQLDOBJTABINSERTRID, PROBE:1152 - DATABASE MARKED BAD OCCUR AFTER ATTACHING DATA PARTITIONS ON PARTITIONED TABLE.
IC84471 2 CERTAIN TRANSACTION LOG RECORDS ARE BLOCKING WHEN BEING APPLIED DURING REPLAY
IC84857 2 PERFORMING MEMBER CRASH RECOVERY IN PURESCALE THAT REPLAYS CERTAIN LOAD OR REORG LOG RECORDS MIGHT CORRUPT THE INDEX
IC84040 2 REDISTRIBUTE DATABASE PARTITION GROUP USING INDEXING MODE REBUILD MIGHT CORRUPT BUFFER POOL IF INDEX TABLESPACE BECOMES FULL
IC84856 2 INDEX CORRUPTION MAY BE INTRODUCED DURING A DATABASE UPGRADE FROM DB2 VERSION 9.5 TO DB2 VERSION 10.1
IC84194 2 HANG REQUIRING MULTIPLE DEFERRED ROLLOUT DELETE ON MDC TABLES
IC85447 2 INSERT/UPDATE/DELETE OPERATIONS ON INSERT TIME CLUSTERED TABLES MAY FAIL WITH AN INDEX ERROR
IC82789 3 ISSUE WITH THE DUMPING OF DIAGNOSTICS IN THE SUBAGENT AND COORDINATOR AGENT
IC84570 2 DB2 LAUNCHPAD DOES NOT PROVIDE OPTION TO INSTALL NEW DB2 COPY IFTHERE IS AN EXISTING 64BIT IBM DATA SERVER DRIVER.
IC84554 2 DB2 MIGHT ENCOUNTER 'DEADLOCK' ERROR WHEN PERFORMING TWO DROP TABLE STATEMENTS SIMULTANEOUSLY.
IC84571 2 IN DPF ENVIRONMENT, DURING CONCURRENT XA TRANSACTIONS DECLARE GLOBAL TEMP TABLE MAY FAIL WITH SQL0901
IC84904 2 UNABLE TO USE SPATIAL CAPABILITIES ON EXPC AS THE CLIENT COMPONENT IS NOT AVAILABLE.
IC84221 2 CAN NOT REPRODUCE THE DATABASE OBJECTS USING V9.1 DB2LOOK OUTPUT
IC84250 2 DB2DART ERROR - UNEXPECTED LOB INLINE LENGTH
IC84461 2 DB2ICRT DOES NOT RETURN AN ERROR WHEN THE .SSH DIRECTORY EXISTS AND IT'S NOT EMPTY IN THE SHARED DISK
IC84179 2 ENHANCE THE DB2CAT TOOL TO IDENTIFY TABLE WHICH MAY STILL BE IMPACTED BY THE CONSEQUENCES OF THE APARS IZ39997 & IZ40001
IC85565 2 SQL0901N IS RETURNED WHEN MOVING A DATABASE THAT IS CREATED ON OR UPGRADED DIRECTLY TO V10.1 FP1 DOWN TO V10.1 GA
IC85410 2 SQL SCALAR, TABLE AND ROW FUNCTIONS MISS WITH GRANT PRIVILEGE FOR THE CREATOR IN A NON-RESTRICTIVE DATABASE
IC84487 2 ERROR SQL0727N WITH SYSTEM ACTION TYPE "5" AND SQLCODE "-551" CALLING A STORED PROCEDURE AFTER RUNNING: "DB2UPDV97 -A"
IC84302 2 UPDATING INSTANCE FOR USER USING CSH GIVES "AMBIGUOUS OUTPUT REDIRECT" ERROR
IC84908 2 RDF SUPPORT IS ABSENT IN DSDRIVER IMAGE
IC84426 2 WHEN SEQUENCE IS DROPPED, ITS COMMENT IS NOT AUTOMATICALLY DELETED FROM SYSIBM.SYSCOMMENTS
IC84223 2 DB2IDROP FAILS TO DROP INSTANCE AND DISPLAYS MISLEADING SUCCESS MESSAGE
IC84142 2 TRANSFER OWNERSHIP OF NICKNAME DOES NOT TRANSFER PRIVILEGES TO THE NEW OWNER
IC84275 2 DB2ISETUP FAILS TO CREATE AN INSTANCE WHEN THE SQLLIB DIRECTORY IS MISSING
IC84556 2 ALTER TABLE MAY RUN OUT OF STMTHEAP WHEN PROCESSING A LOT DEPENDENT VIEWS
IC84178 2 ADMINISTRATIVE VIEWS RETURN DUPLICATED ROWS, ALTHOUGH SHOULD RETURN ONE, WHEN MULTIPLE SOURCES OF RIGHTS EXIST IN ORA MODE.
IC84516 2 FIXPACK ROLLS BACK DURING TSA UPGRADE DUE TO HAVING A PERMANENT LICENSE INSTALLED AND A TRY AND BUY LICENSE ON THE IMAGE
IC84501 2 INSTANCE MAY TRAP WHEN DROPPING OR RENAMING A TABLE THAT HAS XSRDEPENDENT OBJECTS
IC84258 2 DB2LS DOES NOT RETURN EXPECTED OUTPUT FOR ROOT INSTALLATION
IC84815 2 SQL0902C MAY BE RETURNED WHEN DROPPING A TABLE THAT HAS INDEX ASSOCIATED WITH AN USAGE LIST
IC84175 2 SECURITY: DB2 ESCALATION OF PRIVILEGE VULNERABILITY (CVE-2011-4061)
IC84930 2 ALTER USAGE LIST MAY INCORRECTLY RETURN SQL0100W WHEN THE TARGETUSAGE LIST IS DROPPED AT THE SAME TIME
IC84340 2 AFTER UPGRADE OF DATA SERVER DRIVER PACKAGE, .NET DRIVER NOT REGISTERED
IC84198 2 DB2 MAY ENCOUNTER 'DEADLOCK' ON SYSTEM CATALOG SYSIBM.SYSCOLAUTHWHEN PERFORMING TWO DROP TABLE STATEMENTS SIMULTANEOUSLY.
IC84504 2 DGTT CREATION IN DPF ENVIRONMENT CAN RETURN -901 APPLICATION ERROR IF THERE WAS A LOCK TIME OUT WHEN CLEANING UP A PRIOR DGTT
IC84303 2 1603 : ERROR_INSTALL_FAILURE WHEN UPGRADING DB2 (VERSIONS BELOW 9.7) TO DB2 VERSION 9.7 ON WINDOWS 2008 (64 BIT)
IC84441 2 MIGRATIONUTILITY DIALOG BOX CREATES DB2DSDRIVER.CFG FILE IN THE INSTALL PATH AND NOT IN THE APPLICATION DATA PATH
IC84273 2 DB2PRECHK WITH -D OPTION DOES NOT PRESERVE TO FUNCTION CALLS IN DB2IUTIL
IC84548 3 DB2SETUP DOES NOT DISPLAY A VALID MESSAGE WHEN THE FILE COMMAND IS NOT AVAILABLE.
IC84560 3 SQL0262N IS RETURNED WHEN DETACHING PARTITION FROM A RANGE-PARTITIONED MQT IN DPF ENV
IC84168 3 COLUMN DATAPARTITIONEXPRESSION IN SYSCAT.DATAPARTITONEXPRESSION CATALOG VIEW DOESN'T GET UPDATED UPON ALTERING A COLUMN NAME
IC84193 3 THE CODE PAGE STORED IN SYSCAT.COLUMNS FOR A GRAPHIC TYPED COLUMN GETS RESET TO 0 AFTER RUNNING THE ALTER COLUMN ... COMMAND
IC84481 3 UTL_DIR MODULE ROUTINES FAIL WITH SQL0551N AFTER EXECUTING DB2UPDV97
IC84235 3 INCORRECT VALUES SET FOR CPU_SPEED & COMM_BANDWIDTH DURING DB2IUPDT FAILURE.
IC84432 3 ACS DIRECTORY UNDER $HOME/SQLLIB NOT REMOVED WHEN ACS IS UNINSTALLED.
IC84152 4 DB2 INSTALLATIONS UNDER CHINESE, KOREAN OR JAPANESE LANGUAGES RESULT IN MISALIGNED TEXT IN THE LOG FILE
Fix Pack 1  -   Monitoring
IC85420 1 MEMORY LEAK WHEN MON_OBJ_METRICS DATABASE CONFIGURATION PARAMETER IS SET TO EXTENDED OR SECTION ACTUALS ARE ENABLED.
IC84272 2 CALL TO SYSPROC.REORGCHK_IX_STATS('T','ALL') MAY PRODUCE INCORRECT RESULTS
IC84416 2 ERROR SQL0104N MAY HAPPEN WHEN CALLED ADMIN_MOVE_TABLE, IF THE TABLE HAD COMMENT ON IT.
IC83256 2 HANG ON TRANENTRY LATCH IN SQLPM_WRITE_APPL_LOCKS DURING LOCK SNAPSHOT
IC84327 2 AUTOMATIC STATISTICS COLLECTIONS CAN BE FORCED DUE TO LOCK CONFLICT WITH THE LASTUSED DAEMON.
IC84507 2 ADMIN_MOVE_TABLE WILL TRAP, IF THERE ARE MORE THAN 3072 DEPENDENT INDEXES, VIEWS & COMMENT DDL ON SOURCE TABLE
IC84414 2 ADMIN_MOVE_TABLE TAKES LONG TIME FOR SAMPLE CREATION WHEN COMPRESSION IS ENABLED FOR TABLE.
IC84329 2 ADMIN_MOVE_TABLE MAY RETURN SQL0803N OR SQL0603N DURING COPY PHASE (DUPLICATE KEYS)
IC84393 2 MON_GET_ACTIVITY_DETAILS TABLE FUNCTION MAY RETURNS INVALID XML TAGS IN THE DETAILS COLUMN
IC84537 2 DB2 MAY TRAP IN FUNCTION SQLRA_DBMON_STMT_RELEASE DURING HADR TAKE OVER.
IC85108 2 THE UPDATE SQL USED IN ADMIN_MOVE_TABLE IS NOT USING PARAMETER MARKERS, CAUSING MANY STATEMENTS IN THE PACKAGE CACHE.
IC84483 2 ADMIN_MOVE_TABLE NOT TO ALTER TABLE WHEN OPTION COPY_USE_LOAD ISUSED
IC84598 2 CALLING SNAP_WRITE_FILE MAY CAUSE MEMORY CORRUPTION IN FMP PROCESS LEADING TO OUT OF MEMORY CONDITIONS IN DB2
IC84336 2 DB2 SNAPSHOT MONITOR MAY RETURN SQL1042C ERROR WHEN THERE ARE INDOUBT TRANSACTIONS
IC84139 2 WHEN THERE ARE APPLICATIONS IN ROLLBACK OR COMMIT STATE, DB2 SNAPSHOT MONITOR MAY RETURN SQL1042C ERROR
IC84222 2 REORGCHK_IX_STATS RETURNS 0 RECORDS FOR PARTITIONED INDEXES.
IC83252 2 ACTIVITYMETRICS TABLE IS MISSING THE ACTIVATE_TIMESTAMP COLUMN
IC85525 2 XID COLUMN HAS INCORRECT DATA IN LOCK_PARTICIPANTS TABLE OF A TABLE LOCKING EVENT MONITOR
IC84482 2 SQLPROCEDURECOLS RETURN DUPPLICATE ROWS WHEN THERE ARE MORE THANONE PROCEDURE WITH THE SAME ROUTINENAME AND SPECIFICNAME
IC84450 2 TRAP IN SQM_EVMON_MGR::STOP_EVMON
IC84562 2 CONTINUATION/CANCELLATION OF ADMIN_MOVE_TABLE AFTER HADR TAKEOVER NOT POSSIBLE WITHOUT MANUAL INTERACTION
IC84395 2 TABLE COLUMN DEFINITION CHANGES AFTER MOVING TABLE TO DIFFRENT FIXPACK BY ADMIN_MOVE_TABLE
IC84957 3 PREFETCH_WAIT_TIME IS DOUBLE COUNTED IN THE TOTAL_EXTENDED_LATCH_WAIT_TIME MONITOR ELEMENT.
IC84366 3 ROUTINES TO SUPPORT JDBC DATABASEMETADATA.GETCATALOGS()
IC84098 3 SYSIBMADM.QUERY_PREP_COST ADMINISTRATIVE VIEW RETURNS A VALUE LARGER THAN 100 FOR THE PREP_TIME_PERCENT COLUMN.
IC84345 3 EVENT MONITOR FOR LOCKING MAY NOT CAPTURE ACTIVITIES OF PARTICIPANT IN SOME CASES.
IC83081 3 TABLE SPACE LOCK INFORMATION REPORTED BY MON_FORMAT_LOCK_NAME AND LOCKING EVENT MONITORS MISSING TABLE SPACE NAME
IC84547 3 ADMIN_MOVE_TABLE FAILS WITH ERROR SQL2103N WHEN THERE ARE TWO INDEXES ON THE SAME COLUMN.
IC84478 3 UNREAD_PREFETCH_PAGES DIFFERENT BETWEEN SNAPBP AND MON_GET_BUFFERPOOL OR SNAPTBSP AND MON_GET_TABLESPACE
IC84412 3 IF ADMIN_MOVE_TABLE WITH CANCEL OPTION IS INTERRUPTED SUBSEQUENT CANCEL WILL FAIL WITH SQL2104N RC=8
Fix Pack 1  -   National Language Services
IC84355 1 USING MON, MONTH, DAY, DY IN THE FORMAT STRING IN FUNCTION TO_TIMESTAMP OR TIMESTAMP_FORMAT CAN AFFECT PERFORMANCE OF QUERY
IC84241 1 DB2 SERVER MAY STOP ABNORMALLY WITH ERROR DBMARKEDBAD AFTER EXECUTING SELECT STATEMENT USING DISTINCT KEYWORD.
IC84534 2 MEMORY LEAK IN APPLICATION OR MSDTC.EXE USING IBM DS DRIVER DUE TO LEAKS IN CODEPAGE CONVERSION CACHE
IC84183 2 DB2 MAY TERMINATE ABNORMALLY WHEN CALLING AN SQL PROCEDURE WITH AN XML IN PARAMETER
IC83823 2 WITH REOPT ENABLED, STATEMENTS CONTAINING ARRAY OR ROW VARIABLESMIGHT PRODUCE INCORRECT OUTPUT
IC85724 2 CREATE OR REPLACE PACKAGE BODY STATEMENT THAT CONTAINS A PROCEDURE OR FUNCTION DECLARATION RETURNS ERROR SQL0454N
IC84083 3 SQLCODE -952 DOES NOT INTERRUPT AN SQL ROUTINE IN PROGRESS
Fix Pack 1  -   Platform Specific
IC84314 1 NUMA API INCOMPATIBILITY ON SLES11 AND RHEL6
IC84590 1 FOR WINDOWS DATA SERVER DRIVER, WHEN RUNNING 64 BIT ODBC APPLICATIONS, SQLEINITAPPLICATIONENVIRONMENT() MAY FAIL
IC84323 2 DB2 MAY ABEND WITH SIGSEV DUE TO SOCKET FD OVERFLOW WHICH CAN TOLEAD STACK CORRUPTION
IC85483 2 DB2 CONNECTION SOCKETS MAY BE INHERITED BY NEW PROCESSES
IC84135 2 STMM TUNES SHARED SORT MEMORY TOO HIGH
IC84158 2 FAILURE TO ATTACH WHILE ALLOCATING MANY SMALLER SEGMENTS TO SATISFY A LARGE ALLOCATION (> 256GB)
IC84239 2 SQLOSPAWNANDWAITFORPASSWORDCHECKEXE MAY REPORTS FALSE DEADLOCK MESSAGES IN DB2CKPWD
IC84434 2 DEPLETION OF QUEUE SHARED MEMORY CAUSES DB2 TO ABEND (PANIC) ON WINDOWS
IC84564 2 DB2START MIGHT HANG OR RESULT IN SQL1042C IF THE GLOBAL REGISTRYFILE IS MISSING.
IC84260 2 DEACTIVATION WITH LARGE BUFFERPOOL MEMORY TAKES EXCESSIVELY LONGON LARGE WINDOWS SYSTEM
IC84305 2 PERFORMING REMOTE APPLICATION SNAPSHOTS CONCURRENTLY MAY CAUSE THE INSTANCE HUNG
IC84542 2 MEMORY LEAK IN APPLICATION OR MSDTC.EXE USING IBM DS DRIVER DUE TO LEAKS IN DB2TRC MEMORY AND CACHE USED BY SECURITY
IC84204 2 DB2 MAY NOT PERFORM OPTIMALLY ON LARGE 64-BIT WINDOWS ENVIRONMENTS DUE TO USE OF MEM_TOP_DOWN FLAG
IC84283 2 DB2 CRASH WHEN CALLING OS PLUG-IN GETGRENT / GETGRENT_R TO GET GROUP NAMES
IC84190 2 AUTOMATIC RESTART OF DB2 ON REBOOT BY DB2FMCD DOES NOT WORK ON SOLARIS 10
IC84344 2 DB2 CREATE TABLESPACE COMMAND CAN CRASH THE INSTANCE IF THE CONTAINER PATH DOES NOT EXIST.
IC84149 2 TOO MANY OR PREDICATES LEAD TO STACK CORRUPTION ON HP IPF
IC84508 3 SEVERE SQLOMEMDETACHFROMSEGMENTS MESSAGE LOGGED BY DB2ROCM PROCESS USING PURESCALE FEATURE
IC84170 3 REDUCTION IN PERMISSIONS ON THE NODES.REG FILE.
IC84268 3 TRANSPARENT LDAP WITH VAS ON AIX, GETGRSET MAY RETURN A GROUP ID THAT GETGRID FAILS TO RETRIEVE FULL GROUP INFORMATION FOR
IC84316 3 DB2 MAY HANG WHILE OPENING A FILE IF THERE IS A STALE NFS MOUNT
IC84513 3 DB2 REPORTS NUMBER OF PROCESSOR CORES WITH INTEL HYPERTHREADING INCORRECTLY
Fix Pack 1  -   Problem Determination
IC83535 1 DB2DIAG.LOG ENTRIES WITHOUT A MESSAGE LEVEL CAN CAUSE A TRAP WHEN RUNNING PD_GET_DIAG_HIST
IC84559 2 DB2PREREQCHECK ADD CHECK FOR LIBPAM
IC84601 2 DB2TOP DUMPS CORE ON AIX WHEN SHOWING SQL TEXT LOGNER THAN 8028 BYTES
IC84479 2 DB2PD -REPEAT OPTION CAN NOT HANDLE MORE THAN 65535 SECONDS.
IC84285 2 DB2 INSPECT NOT CHECKING ALL PAGES FOR OBJECTS IN DROP-PENDING/UNAVAILABLE STATE
IC84261 2 STORED PROCEDURE MAY TRAP WITH SIGILL DURING RUNTIME PROCESSING
IC84196 2 "DB2FODC -PERF FULL" ON WINDOWS WITH A NON-ENGLISH LANGUAGE ENVIRONMENT MAY FAIL TO COLLECT SNAPSHOT DATA
IC84444 2 REPLACE SQLOFINDF WITH PDRLOGFINDF IN PDRLOGLEFTOVERDELETE,SINCESQLOFINDF2 MAY HANG WHEN SQLOGBLK MEMORY
IC84296 2 CURRENTLY, DB2HADRS, DB2HADRP, DB2REDOW AND DB2REDOM DO NOT REPORT THE DATABASE FIELD IN DB2DIAG.LOG.
IC84484 2 INCONSISTENCIES BETWEEN DB2PD DBCFG/DBMCFG OUTPUTS AND GET DB/DBM CFG OUTPUTS
IC84251 2 DB2TOP "TABLES" SCREEN MEMORY LEAK
IC84182 2 DB2DART /LHWM MAY FAIL WITH "ERROR: INTERNAL ERROR HAPPENED: FOUND UNEXPECTED GLOBAL INDEX OBJECT"
IC84274 2 DB2 SERVER MAY HANG AFTER A TRAPPED THREAD IS SUSTAINED
IC84365 2 DB2TRC -WC REPORTS UNEXPECTED WALL-CLOCK (-WC) TIMESTAMPS
IC84498 2 THE INDIVIDUAL DB2 DIAGNOSTIC ROTATING LOG ( DB2DIAG.#.LOG, OR <INSTANCE>.#.NFY ) IS LIMITED WITHIN 4G IN SIZE.
IC84203 2 REMOVE WORLD WRITABLE BIT FROM SOME MESSAGE LOG FILES
IC84310 3 SETTING DBM CFG PARAMETER, SUCH AS SVCENAME, THROWS OUT AN ERRORMESSAGE ABOUT DIAGSIZE.
IC84276 3 'DB2SUPPORT' THROWS AN ERROR WHEN RUN FROM DOS COMMAND PROMPT INWINDOWS
IC84530 3 DB2DIAG -E RETURNS INCORRECT DB2DIAG.LOG ENTRY
IC84456 3 DB2TOP THROWS SEGMENTATION FAULT WHEN MONITORING A LOAD UNDER THE UTILITIES SCREEN
IC84364 3 DB2DART AND INSPECT REPORTS "LOB FREE SPACE WASTED." AS ERROR, SHOULD BE REPORTED AS WARNING
IC84195 3 ADD VMSTAT -P IN DB2COS_PERF ON SOLARIS
IC84122 3 DB2DART & INSPECT NEED TO REMOVE THE CHECK DMS HEADER FREE SPACEOFFSET
Fix Pack 1  -   Process Model
IC84716 1 SECURITY: SQLJ.DB2_INSTALL_JAR DIRECTORY ESCAPE VULNERABILITY (CVE-2012-2194).
IC84755 1 SECURITY: STACK BUFFER OVERFLOW VULNERABILITY IN JAVA STORED PROCEDURE INFRASTRUCTURE (CVE-2012-2197).
IC84343 2 CATALOG NODE FAILURE CAN LEAD TO SYSTEM APPICATIONS NOT TERMINATING AND CAUSE SQL1229N ON NON-CATALOG NODES.
IC84294 2 ADD DBPARTITIONNUM FAILS WITH SQL1031N IF THE DB IS CREATED ON APATH THAT CONTAINS SYMBOLIC LINKS TO DIFFERENT PHYSICAL PATHS
IC84433 2 ON LINUX PLATFORMS, DB2 FCM THREADS (DB2FMCS AND DB2FCMR) MAY HANG IN SELECT() SYSTEM CALL
IC84517 2 ACTIVATE DATABASE COMMAND JUST AFTER DB2START MAY FAIL WITH -1224
IC84148 2 DB2WDOG CAN ABORT (SEGV/CRASH) WHEN CLEANING UP A DB2FMP ENTRY
IC84459 2 SPORADIC SQL2001N DURING STATEMENT EXECUTION
IC84171 2 INSTANCE MAY GO DOWN AT SQLOFREEMEMCHUNKS AFTER A SEVERE SQLERMASTERTHREADREQ MESSAGE.
IC84145 3 ERROR IN DB2DIAG.LOG UPON LOW PRIORITY AGENT INTERRUPT IS STILL POSSIBLE WITH FIX FOR APAR IC73608
IC84247 3 CHANGE PERMISSIONS ON FILE DB2STOP.<PID>.DAT
IC84174 3 UPDATING THE NEWLOGPATH DATABASE CONFIGURATION PARAMETER WHILE THE DATABASE IS NOT ACTIVE CAN CAUSE DB2 TO HANG
Fix Pack 1  -   PureScale Services
IC85279 1 DB2 PRIVATE MEMORY LEAK OCCURS WHEN MONITORING THE HOST STATUS IN PURESCALE
IC84200 2 AUTOMATIC RESTART OF DB2 ON REBOOT BY DB2FMCD DOES NOT WORK ON SOLARIS 10
IC84492 2 "DB2CLUSTER -CM -ENTER -MAINTENANCE -ALL" MAY GET ERROR IF ISSUED BEFORE CLUSTER STATE BECOMES ONLINE BY PREVIOUS EXIT COMMAND
IC84301 2 FAILED RESTORE/CREATE DATABASE ACTION MAY CAUSE TSAMP (TSA) MOUNT RESOURCES TO BE DELETED.
IC84594 2 RESOURCE GROUP LEFT IN A LOCKED STATE AFTER A FAILURE TO ASSOCIATE A CHILD RESOURCE TO IT
IC84163 3 UNINTENDED AUTOMATIC TAKEOVER DURING CLUSTER SETUP USING DB2HAICU
IC84488 3 CREATE DATABASE FAILS WITH SQLCODE -1051 IN A DPF SET-UP WITH TSA HA WHEN CREATING DATABASE ON A MOUNT
IC84166 3 DB2HAICU CANNOT CREATE MORE THAN ONE VIRTUAL IP USING XML FILE
Fix Pack 1  -   Quality Assurance
IC83963 2 UPGRADE TO DB2 10.1 FAILS
IC84607 2 TABLE PARTITION REMAINS LOGICALLY DETACHED AFTER DETACH FAILURE
IC83636 2 TABLE FUNCTION SYSPROC.ADMIN_GET_TAB_COMPRESS_INFO MAY RETURN SQL0901N
IC85738 2 SLOW ETHERNET FAILOVER OF PRIMARY CF ROLE
IC82804 2 LOB/LONG TABLESPACE GROWS MUCH LARGER THAN REQUIRED FOR THE ACTUAL DATA BEING STORED
IC83058 2 LOB/LONG TABLESPACE GROWS MUCH LARGER THAN REQUIRED FOR THE ACTUAL DATA BEING STORED
IC84608 3 PROBLEM WITH REORGCHK FORMULA F6
Fix Pack 1  -   Query Compiler Optimizer
IC84540 1 STATEMENT HEAP USAGE IS HIGH WHEN THERE ARE MANY JOINS AND A DATA PARTITIONING KEY IS USED IN LOCAL PREDICATES
IC84580 1 DB2 OPTIMIZER MIGHT CHOOSE SUB-OPTIMAL INDEX-ORING ACCESS PLAN EVEN WHEN THE IN PREDICATE DOES NOT FILTER ANY RECORD
IC85355 1 PERFORMANCE DEGENERATION WITH API DB2GETROWPARTNUM
IC84525 2 RECURSIVE QUERIES MAY FAIL WITH A SQL0901N (BAD OUTER COMPARE)
IC84289 2 USING ARRAY TYPE VARIABLES IN SMP MODE MAY CAUSE MEMORY LEAK
IC84136 2 XQUERY MAY CAUSE DB2 TO TRAP.
IC84558 2 MEMORY LEAK IN CATALOG CACHE WHEN AUTOMATIC STATISTICS IS ENABLED.
IC84531 2 QUERY WITH CORRELATED SUBQUERY PREDICATE AND GROUP BY CLAUSE REFERENCING THE SAME COLUMNS MIGHT RETURN INCORRECT RESULTS
IC84457 2 A FULL SCAN OF AN MDC TABLE MIGHT BE CHOSEN WHEN THERE IS A LARGE NUMBER OF OVERFLOW RECORDS
IC84192 2 COLUMN GROUP STATISTICS NOT ALWAYS APPLIED TO CYCLE OF 3 OR MOREJOINS
IC84346 2 OPTIMIZER CARDINALITY ESTIMATION ERRORS FOR INDEX SCAN OPERATIONS
IC84404 2 DB2 MAY CRASH WHEN CREATING SQL STORED PROCEDURES FROM A SCRIPT.
IC84515 2 ENGINE TRAP WITH ENTRYCALLBACK AND ATMGETHARDENINGLIST IN THE CALLSTACK
IC84502 2 ESTIMATED CARDINALITY OF UNNEST FUNCTION FOR ARRAY DATATYPE IS NOT USED DURING QUERY PLANNING
IC84518 2 MEMORY LEAK IN CATALOG CACHE WHEN AUTOMATIC STATISTICS IS ENABLED.
IC84224 2 CANNOT SET EXCLUDE XML COLUMNS CLAUSE IN STATISTICS PROFILE
IC84597 2 DB2 SQL OPTIMIZER MIGHT CHOOSE A SUBOPTIMAL ACCESS PLAN FOR QUERY WITH 'OPTIMIZE FOR N ROWS' CLAUSE AND IS NULL PREDICATE
IC84587 2 CARDINALITY MAY BE OVERESTIMATED WHEN THERE ARE MULTIPLE IN PREDICATES ON THE SAME COLUMNS AS MULTIPLE EQUALITY JOIN PREDICATE
IC84512 2 PARTITIONED INDEX STATISTICS MAY NOT BE REPRESENTATIVE WHEN DATAPARTITION DETACH HAS OCCURRED
IC84462 2 DB2 MIGHT TRAP WHILE COMPILING SQL QUERY WITH CONTAINS() FUNCTION
IC84565 2 ESTIMATED CARDINALITY OF UNNEST FUNCTION FOR ARRAY DATATYPE IS NOT USED DURING QUERY PLANNING
IC84324 2 OPTIMIZER MIGHT NOT CONSIDER A TABLESCAN OF A RANGE PARTITIONED TABLE ON THE INNER OF A NESTED LOOP JOIN
IC84177 2 -901 WHILE COMPILING A STATEMENT
IC84127 2 QUERY REFERENCING A TABLE CONTAINING A GENERATED COLUMN MIGHT PRODUCE A -901
IC85110 3 "RUNSTATS ... SET PROFILE ONLY" COMMAND LEADS SYSCAT.DATAPARTITIONS TABLES'S FIELDS TO BE UPDATED
IC84664 3 THE OPTIMIZER DOESN'T SELECT THE TABLE THAT EXISTS IN THE COORDINATOR NODE IN DPF FOR DYNAMIC SQL.
IC84493 3 THE OPTIMIZER MIGHT CHOOSE A SUB-OPTIMAL ACCESS PLAN FOR SQL USING RANGE PREDICATES WITH PLACE HOLDER VARIABLE.
IC84440 3 RUNSTATS "FOR INDEXES" CLAUSE RESETS EXISTING RANGE PARTITION TABLE STATISTICS
IC84389 3 ENOMEM ERROR ON DB2ACD PROCESS COULD LEAD TO NON-FATAL ASSERTIONFAILED
IC84595 3 INVALID APG XML GENERATED FROM EXPLAIN_SQL STORED PROCEDURE
IC84497 3 OPTIMIZER'S ESTIMATED CARDINALITY INCORRECTLY DROPS AT TQ OPERATOR WHEN QUERY CONTAINS NODENUMBER PREDICATE
IC83206 3 EXPLAIN OF FEDERATED QUERY INDICATES PREDICATE APPLIED TO WRONG OR NON-EXISTENT OPERATOR
Fix Pack 1  -   Query Compiler QGM
IC84402 1 DB2 TERMINATES ABNORMALLY DURING EXPLAIN OF A CALL OR A QUERY CONTAINING AN SQL FUNCTION REFERENCE
IC84545 1 OUTERJOIN SEMIJOIN NOT APPLIED WHEN NO PREDICATES ON PARTITIONS COLUMN(S)
IC84610 1 DYNAMIC SQL EXECUTION FAILS WITH SQL0138 WITH REOPT=ALWAYS
IC84599 1 ALTER COLUMN SET DATA TYPE NOT BLOCKED FOR ROW CHANGE TIMESTAMP COLUMN
IC84123 2 DB2 MIGHT PRODUCE A -901 WHEN RUNNING A QUERY WITH UDF HAVING ANOLAP FUNCTION AS AN ARGUMENT
IC84197 2 DB2 MIGHT ABEND WHEN EXECUTING A QUERY WITH NESTED OR PREDICATE
IC84406 2 DB2 INSTANCE MAY CRASH IF IT RUNS OUT OF THE STATEMENT HEAP MEMORY
IC84358 2 SQL0151N OR SQL0206N MAY RESULT WHEN CREATING SQL PROCEDURE CONTAINING TRUNCATE STATEMENT
IC84304 2 DECODE FUNCTION MAY NOT MATCH NULL VALUES
IC84454 2 EQUALITY JOIN PREDICATES PUSHED DOWN THRU OLAP FUNCTION FORMING A CORRELATION MAY CAUSE A PERFORMANCE DEGRADATION.
IC84330 2 POSSIBLE MEMORY LEAK IN SQLNNLITERALREPLACE() WITH STATEMENT CONCENTRATOR ON
IC84288 2 COMPARING TIMESTAMP TYPE COLUMN WITH CHAR/VARCHAR TYPE HOST VARIABLE MAY GET SUBOPTIMAL QUERY PLAN IN V97
IC84220 2 SQL412N IS RETURNED WHEN A PREDICATE THAT ALLOWS MULTIPLE COLUMNS CONTAINS MORE THAN ONE SCALAR SUBSELECTS.
IC84338 2 QUERY REFERENCING AGGREGATION AND OLAP FUNCTION IN SAME EXPRESSION MIGHT GENERATE A -901
IC84205 2 ADDING REDUNDANT JOINS TO FILTER ROWS OF AN OUTER JOIN OPERATOR MAY NOT OCCUR DUE TO AN ERROR IN THE ANALYSIS
IC82715 2 SELECT FROM AN UPDATE/DELETE/INSERT IN COMMON TABLE EXPRESSION GIVES WRONG RESULTS.
IC84219 2 DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF THE JOINOPERATION FOR FOREIGN KEY CONSTRAINT ENFORCEMENT IN DPF
IC84480 2 REFRESH MQT IN DPF ENVIRONMENT DOESN'T HONOR AN OPTIMIZATION LEVEL, PREVIOUSLY SET WITH SET CURRENT OPTIMIZATION LEVEL CMD
IC84309 2 ROLLUP OR CUBE QUERY MAY RETURN INCORRECT RESULT WHEN IT REFERENCES SAME GROUPING(EXPRESSION) MULTIPLE TIMES
IC84357 2 REPLICATED MQT NOT MATCHED FOR INSERT-FROM-SELECT WHEN SELECT QUERIES UNION ALL VIEW WITH EXISTS PREDICATE
IC84411 2 WHEN DB2_COMPATIBILITY_VECTOR IS SET TO ORA, A POSSIBLE RUNTIME TRAP MAY OCCUR SOMETIME AFTER ALTER TABLE ADD "NOT NULL DEFAULT
IC84181 2 EXPLAIN OF A STATEMENT WITH AN OPTIMIZER GUIDELINE FAILS WITH SQL0901N ERROR.
IC84270 2 ERROR SQL1585 CAN BE RETURNED WITH EXISTS CLAUSE IN STATEMENTS WITH LOB/LONG COLUMNS
IC84490 2 INCORRECT RESULT IF A NEW TABLE DATA-CHANGE-TABLE-REFERENCE OF ASIMPLE VIEW WITH A GENERATED ALWAYS AS EXPRESSION COLUM
IC84431 2 WHEN DB2_COMPATIBILITY_VECTOR IS SET TO ORA, A POSSIBLE RUNTIME TRAP MAY OCCUR SOMETIME AFTER ALTER TABLE ADD "NOT NULL DEFAULT
IC84494 2 DB2 MIGHT PRODUCE A -901 WHEN RUNNING A QUERY WITH UDF HAVING ANOLAP FUNCTION AS AN ARGUMENT
IC83536 2 UNEXPECTED SQL204N CAN OCCUR DURING THE IMPLICIT REBIND OF A PACKAGE THAT DEPENDS ON AN INVALID VIEW.
IC84451 2 SQL STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT")
IC84287 2 DB2 INSTANCE MAY CRASH WHEN REMOVING TAUTOLOGY PREDICATES DURINGQUERY REWRITE
IC84206 2 QUERIES USING OUTER JOINS AND SCALAR SUBQUERY RUNS SIGNIFICANTLYSLOWER COMPARING TO OUTER JOINS AND LOCAL PREDICATES
IC84394 2 2-PART NAME REFERENCES TO A MODULE ROUTINE MAY FAIL TO RE-RESOLVE AFTER A SCHEMA CHANGE
IC84407 2 DB2 MIGHT ABEND WHEN EXECUTING A EXISTENTIAL SUBQUERY INSIDE AN AGGREGATION FUNCTION.
IC84586 2 POSSIBLE TRAP IN SQLNQ_OPR::DROP DURING COMPILATION
IC84184 2 DB2 MAY ABEND WHEN THERE ARE MULTIPLE REPLICATED MQT AND FORCE_REPLICATED_MQT_MERGE IS SET
IC84328 2 DB2 V9.7 INSTANCE CRASHED DURING DATABASE UPGRADING FROM V8.2 TO V9.7
IC84320 2 COALESCE EXPRESSION IN THE OUTER JOIN OPERATOR (+) MAY RETURN INCORRECT RESULTS
IC84238 2 CTE0129 ERROR ON UNION ALL VIEWS WITH DIFFERENT DATA TYPES
IC84455 2 DB2 DOES NOT USE THE LATEST STATISTICS FROM OBJECTS CREATED BY CREATE GLOBAL TEMPORARY TABLE WHEN USED IN USER DEFINED FUNCTION
IC84164 2 DB2 SQL COMPILER MIGHT NOT CHOOSE AN OPTIMAL ORDER FOR PERFORMING OUTER JOINS
IC84403 2 WHEN DB2_COMPATIBILITY_VECTOR IS SET TO ORA, A POSSIBLE RUNTIME TRAP MAY OCCUR SOMETIME AFTER ALTER TABLE ADD "NOT NULL DEFAULT
IC84217 2 DB2 SQL QUERY COMPILER HAS IMPROVED THE PERFORMANCE OF SECONDARYTABLE ACCESSES DURING INCREMENTAL MQT MAINTENANCE IN DPF
IC83040 3 ALTER TABLE ON A TABLE OF WHICH AN INVALID VIEW HAS REFERENCES TO CAN ABEND DB2 WITH SIGNAL 11
IC84132 3 WHEN INNER JOIN OPERATION IS REFERENCED OUTSIDE OF FROM CLAUSE, DB2 RETURNS SQL0901N ERROR MESSAGE AND GENERATES DUMP FILES.
IC84278 3 STATISTICAL VIEW IS NOT USED BY THE OPTIMIZER IF THE QUERY CONTAINS A NODENUMBER PREDICATE
IC84422 3 REFRESH TABLE OR SET INTEGRITY ON AN MQT MAY RETURN SQL204N.
IC84312 3 WHEN CREATE PACKAGE BODY GETS ERROR SQL20481N, THE ERROR MESSAGEDOES NOT IDENTIFY THE PROCEDURE THAT REFERENCES ITSELF.
IC84292 3 -901 ERROR WHILE COMPILING QUERY HAVING MULTIPLE AGGREGATE DISTINCT
IC84293 3 INLINED SQL FUNCTION IN LIKE PATTERN EXPRESSION FAILS WITH SQLCODE -901 "UNKNOWN FUNCTION PROTOCOL
IC84862 3 DB2 DROP STOGROUP <SGNAME> RESTRICT RETURNS SQL0104N AN UNEXPECTED TOKEN "RESTRICT" WAS FOUND
IC84543 3 WHEN OPTIMIZER PLAN USES GROUP-BY MQT FOR AN INSERT STATEMENT, OPTIMIZER (I.E. NON-GROUP-BY MQT) MAY NOT BE CONSIDERED.
Fix Pack 1  -   Relational Data Services
IC84446 2 SQLRL_USERTEMPPOSTCLEANUP GETS SQLCODE -901 ERROR AS A RESULT OFUNEXPECTED CLEANUP ENTRIES
IC84277 2 DB2 INSTANCE CRASH IN DB2AGENT SECTION DUMP THAT IS TRIGGERED BYMAINTANCE ACTIVITY, FOR INSTANCE DB2FODC, DB2PD -DUMP AND ETC.
IC84401 2 DB2 WLM MAY NOT TERMINATE TRANSACTION ON UOW TOTAL TIME THRESHOLD VIOLATION IF APPLICATION IS WAITING FOR RESPONSE FROM CLIENT.
IC84549 2 TIMING CONDITIONS LEAD TO SQL0901N ENCOUNTERED BY APD CLEANUP PROCESSING DURING RANGE PARTITION DETACH
IC84176 2 CONDITION HANDLER FOR SQLWARNING IN A STORED PROCEDURE MIGHT BE INCORRECTLY INVOKED
IC84332 2 PACKAGE CACHE MAY BE FILLED UP WITH MANY VARIATIONS OF "SET CURRENT ..." STATEMENTS.
IC84126 2 WLM INCORRECTLY BLOCKS RESYNC REQUEST
IC84246 2 CONNIDLETIME THRESHOLD EVALUATION MAY HIT SIGSEGV DUE TO A STACKCORRUPTION
IC84505 2 CALLING A STORED PROCEDURE FROM DB2 V9.7 FP 4 AND FP 5 DATABASE SERVER MAY HIT SQL0727N SQLCODE "-7" ERROR
IC84202 3 DB2RBIND COMMAND RETURNS A TRUNCATED MESSAGE WHICH LOSES ITS TAIL END
IC84561 3 SPURIOUS PACKAGE CACHE OVERFLOWS REPORTED WHEN CACHE IS AT FULL UTILIZATION
Fix Pack 1  -   Security
IC84264 2 ESTALE FROM READ() OR WRITE() SYSTEM CALL COULD CAUSE LOSS OF DB2AUDIT RECORD
IC84606 2 SECURITY: GROUP PRIVILEGES SHOULD NOT BE CONSIDERED WHEN ISSUINGSTATIC DML STATEMENTS INVOLVING SEQUENCES.
IC84156 2 IN DPF, ONLY NODE 0 WOULD GET AUDIT LOG
IC84130 2 WHEN USING TRUSTED CONTEXT, SECADM AND DBADM AUTHORITIES WERE NOT TAKEN INTO ACCOUNT AT DATABASE CONNECTION TIME
IC84249 2 LONG DATABASE CONNECT TIMES IN A DPF ENVIRONMENT DUE TO LENGTHY HOSTNAME RESOLUTION
Fix Pack 1  -   Text Search
IC84153 3 MEMORY LEAK WAS OCCURRED VIA NSE.
Fix Pack 1  -   XML
IC84321 1 DB2 ABEND WITH SIG11 FOR A SELECT WITH XML QUERIES
IC84464 2 RUNSTATS DOES NOT COLLECT XML STATISTICS WHEN STATS_HEAP_SZ IS NOT BIG ENOUGH
IC84577 2 XML QUERIES WORKING WITH XML SEQUENCES MAY RETURN INCORRECT RESULTS.
IC84400 3 BAD DATA PAGE ERROR ACCESSING XML COLUMN DATA WITHIN STORED PROCEDURE


Related information

Download DB2 LUW Fix Packs

Cross reference information
Segment Product Component Platform Version Edition
Information Management DB2 Connect 10.1

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1610653

Modified date:

2014-09-18

Translate my page

Machine Translation

Content navigation