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

DB2 10.5 APAR Fix list contains list of APARs shipped for each fix pack in DB2 Version 10.5 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.

Product Name : DB2 UDB Version 10.5 Updated : Wed Dec 23 15:26:53 EST 2015

Select a Fix Pack: 7 | 6 | 5 | 4 | 3a | 3 | 2 | 1

DB2 Version 10.5 Fix Pack 7
APAR	Sev.	Abstract
Fix Pack 7 - 1
IT13528	2	A QUERY WITH IDENTICAL SCALAR SUBQUERY(S) REFERENCED BY MULTIPLE PREDICATES WITHIN THE SAME SELECT QUERY BLOCK CAN TRAP
IT13366	2	OPTIMIZER FAVOURS HSJOIN OVER A BETTER NLJOIN WHEN JOIN COLUMN HAS LESS THAN 3 DISTINCT VALUES
IT14856	2	DATABASE CAN REPORT INCORRECT TIME WITH NONE STANDARD TIME CHANGE LIKE CHANGES IN TIMEZONES
IT07231	2	APPLICATIONS MONITORED FOR EI CAN RESULT IN MEMORY DIAGNOSTICS ERROR IF AN ERRONEOUS QUERY LONGER THAN 512 CHARACTERS IS ISSUE
IT06504	2	HADR TAKES A LONG TIME TO FAILOVER TO THE STANDBY WHEN THE DB2STAR2 BINARY IS RENAMED AND THE DB2SYSC IS KILLED ON THE PRIMARY
IT07104	2	DB2 .NET APPLICATIONS CRASH IN DB2CSCSTMT.STARTTIMER WHEN OPM EIIS DEPLOYED AND THE APPLICATION'S DATABASE IS NOT MONITORED
IT07180	2	THE PQCMX LIBRARY IS NOT PICKED UP FROM THE DEFAULT LOCATION OF SQLLIB/PQCMX/PUREQUERY/LIB64
IT06376	3	IBM SSH RETURNS "ERROR ASSIGN PROCESS TO JOB OBJECT"
IT08508	3	LEAK IN FILE DESCRIPTORS CAN CAUSE "TOO MANY OPEN FILES" ERROR FROM IBM SECURE SHELL SERVICE
Fix Pack 7 - Abstract Data Types and Spatial Extender
IT10164	2	COORDINATES CAN ONLY BE TRANSFORMED IF THEIR SPATIAL REFERENCE SYSTEMS REFER TO THE SAME COORDINATE SYSTEM
IT06377	2	MEMORY LEAK IN GEO-SPATIAL CALLS WHILE ACCESSING SPECIFIC TYPE OF DATA
Fix Pack 7 - Administration Tools
IT09468	2	ATS CAN MISS SOME TASKS IF TASK IS NOT COMMITTED BEFORE SCHEDULER WAKES UP
IT08161	2	ATS MAY RANDOMLY HANG WHEN MANY JOBS ARE SCHEDULED IN IT TO RUN.
IT08414	2	SYSPROC.ADMIN_DROP_SCHEMA RETURNS SQL0478N WHEN THE SCHEMA HAS 'CREATED GLOBAL TEMPORARY TABLE (CGTT)'
IT10551	2	GRANT STATEMENT IS NOT FOUND IN DB2LOOK RESULT UNDER ORACLE MODEDATABASE WHEN -A OPTION IS USED
IT10455	2	DB2LOOK WHEN USED WITH "-L" OPTION FAILS WITH ERROR SQL1635N ORSQL1092N
IT10480	2	RUNNING "DB2LOOK -L" IN DPF RESULTS IN VERY HIGH MEMORY USAGE - MEMORY LEAK
IT10244	2	SYSPROC.GET_DBSIZE_INFO() CAN RETURN ERROR -443 ON CERTAIN CONDITIONS
IT05282	3	DB2_COMPATIBILITY_VECTOR REGISTRY VARIABLE VALUE SET TO ORA CAN GENERATE WRONG MIN AND MAX VALUES FOR CREATE SEQUENCES DDL
Fix Pack 7 - Buffer Pool Services
IT06543	1	DB2 PANICS WHEN RELEASING CASTOUT LOCKS
IT06005	2	ASYNCHRONOUS WRITE TIME IS SIGNIFICANTLY UNDERSTATED IN DB2 MONITORING
IT06072	2	DB2PD -TABLESPACES, MON_GET_TABLESPACE NEED TO REPORT DEFAULT/UNSPECIFIED SETTING FOR FILE SYSTEM CACHING ATTRIBUTE
IV74465	2	PERFORMANCE IMPROVEMENT FOR INSERT STATEMENT IN PURESCALE WHEN EHL IS ENABLED
IT08331	2	FOUND SELF DEAD LATCH FOR THE EDUS HANDLING THE ALTER TABLESPACESWITCH ONLINE STATEMENT
IT09328	2	ROLLFORWARD CAN FAIL WITH SQL1271W ERROR
IT07344	2	SOME 'MON_GET_XXXXX()' ROUTINES PERFORMANCE WILL DECREASE BASED ON THE NUMBER OF TABLESPACES
IT07579	2	DB2RELOCALTEDB MIGHT FAIL WITH SQL10007N ERROR WHEN THE CONTAINER ID IS HIGHER THAN 999.
IT06817	2	DATABASE UPGRADE FAILS
IT09454	2	BADPAGE/ORPHANED EXTENTS DURING/AFTER ROLLFORWARD OF A SPLIT MIRROR BACKUP IMAGE IF EXTENT MOVEMENT WAS ACTIVE ON THE SOURCE DB
IT01790	3	DB2PD -UTIL AND DB2 "LIST UTILITIES SHOW DETAIL" DON'T SHOW THATREBALANCE PROCESS WAS SUSPENDED
IT09234	3	WHEN RUNNING "ALTER TABLESPACE LOWER HIGH WATER MARK", ADM6030E RC=3 MAY BE LOGGED EVEN THOUGH ALL EXTENTS ARE COMPLETELY MOVED.
IT09990	3	CHANGED NUM_IOSERVERS=AUTOMATIC BEHAVIOUR FOR DB2_WORKLOAD=SAP
Fix Pack 7 - Build Team
IT09771	2	LINK CHECK FOR XI AND NOTIFY CONNECTIONS
Fix Pack 7 - CDE Data
IT06539	2	UNEXPECTED SQL0433N DURING SINGLE ROW UPDATE OF COLUMN-ORGANIZEDTABLE WITH A CHAR[1] COLUMN IN DB2 V105 FIXPACK 5
IV74785	2	HIGH APPLICATION SHARED HEAP, DATABASE HEAP MEMORY REQUIREMENT FOR IUD ACTIVITY ON COLUMN-BASED TABLES
IT07770	2	QUERY ON COLUMN-ORGANIZED TABLE MIGHT FAIL WITH -901: UNEXPECTEDERROR AT PAGEITERATORFORTSNRANGE.CPP
IT07053	3	INSTANCE CRASHED IN SQLRICDETSNFILTER AFTER APPLYING FIX PACK
IT10265	3	DB2AGNTCOL ASSERTED WITH "AN ASSERTION 'PAGEISINCONSISTENTWITHPMI == TRUE' FAILED. ADDITIONAL INFO: UNABLE TO ACCESS TARGET PAGE
Fix Pack 7 - CDE Query
IV69754	1	CRASH IN CDE CODE GETJOINPAYLOADEVALUATOR
IV71250	2	LONG_RUNNING QUERY INCLUDING COLUMNAR TABLES EXHIBITS EXCESSIVE APPLICATION HEAP MEMORY USAGE
IT05273	2	INTERMITTENT SLOW PERFORMANCE FOR QUERIES ON COLUMN BASED TABLESWITH COUNT(DISTINCT X )
IT06780	2	POSSIBLE HANG WHEN RUNNING QUERY ON COLUMN-ORGANIZED TABLE IF NEW SUB-AGENT THREAD CANNOT BE ACQUIRED
IV69346	2	A ':' CHARACTER IN A COLUMN-ORGANIZED TABLE NAME REFERENCED IN ANESTED QUERY CAN RESULT IN AN INCORRECT EMPTY RESULT SET
IV73842	2	JOIN SPILLING IN QUERIES ON COLUMN ORGANIZED TABLES MAY RESULT IN EXCESSIVE APPLICATION HEAP USAGE
IT09017	2	INSTANCE CAN CRASH RUNNING A SQL ON COLUMN BASED TABLES(CDE).
IV72718	2	QUERY ON A COLUMNAR TABLE CAN RETURN INCORRECT RESULTS IF IT HASVARIABLE LENGTH STRINGS WITH SPECIAL CHARS LIKE TABS OR BLANKS
IV75541	2	SQL0901N IS POSSIBLE WHEN WORKING WITH COLUMNAR ORGANIZED TABLE AND COLUMN NAME STARTS WITH NUMERIC NUMBER
IV70418	2	INCORRECT RESULTS POSSIBLE AGAINST COLUMN-ORGANIZED TABLES WHEN A CAST IS USED IN THE LEFT HAND SIDE OF AN IN LIST EXPRESSION
IT06568	2	SQL0955 OUT OF MEMORY ERROR MIGHT BE RAISED WITH HIGH INTRA PARTITION PARALLELISM QUERY WITH DISTINCT CLAUSE
IT08407	2	PEFORMANCE IS DEGRADED WITH BLU WHILE COMPARING CHAR WITH VARCHAR IN WHERE CLAUSE IF DB2_COMPATIBILITY_VECTOR IS SET.
IT08600	2	DB2 BLU QUERY MIGHT CRASH INSTANCE DUE TO INSUFFICIENT AGENT_STACK_SZ
IT10218	2	IN A COLUMNAR DATABASE QUERIES MAY FAIL WITH -901 ERROR WHEN USING A CASE EXPRESSION THAT RETURNS A DECIMAL COLUMN.
IT08888	2	SQL0901N "UNEXPECTED ERROR AT HASHTABLE.HPP:2944"
IV73835	2	SEG-V OR -901 SQLCODE IN NESTED QUERY PROCESSING ON COLUMN-ORGANIZED TABLES IN VERSION 10.5 FIXPACK 4 AND 5
IT06300	3	STATEMENT RETURNS DECIMAL NUMBER LEFT JUSTIFIED WITH NO LEADING ZEROES ON A COLUMN ORGANIZED TABLE WITH DEC_TO_CHAR_FMT=V95
IT07435	4	UNNECESSARY WARNING MESSAGES WITH THROTTLECONCURRENTMERGETHREADSAND THROTTLECONCURRENTMERGETHREADS FUNCTIONS IN BLU ENVIRONMENT
Fix Pack 7 - Client Interfaces
IT10420	1	ADDED SEAMLESS FAILOVER SUPPORT FOR INSERT CHAIN AND INSERT WITHLOB STREAM(SQLPARAMDATA) FOR DB2 Z/OS
IT10629	1	"CLI0126E OPERATION INVALID AT THIS TIME, SQLSTATE=HY011" ERROR RETURNED FOR A SQL STATEMENT USING 'BEGIN ATOMIC .. END' CLAUSE
IT05796	1	CLI APPLICATION USING CHAINING WITH INSERT BUFFERING MAY GET SQL_SUCCESS BUT SQLROWCOUNT() GIVES 0.
IT07942	2	WHEN (SPECIAL)REGISTERS ARE SET IN CLI, PROTOCOL IS VIOLATED FORXA TRANSACTION IN FEDERATION ENVIRONMENT.
IT11171	2	PRECOMPILER USES THE VARIABLE NAMES IN FETCH AS DIFFERENT DATA TYPE AND HENCE WE ARE RECEIVING SQL0303N ERROR.
IT08583	2	DS DRIVER: ODBC/CLI APPLICATIONS ON WINDOWS THROWS SQL1109N ERROR WHILE CONNECTING DATABASE SERVER OVER SSL.
IT00483	2	CLPPLUS IS NOT ABLE TO FETCH THE PROPER "SQL AUTHORIZATION ID" VALUE IN CASE OF KERBEROS CONNECTION.
IT06362	2	DB2BP BACKEND PROCESS ARE NOT CLEANED UP EVEN IF DB2 FRONTEND PROCESS (PARENT PROCESS) IS GONE.
IT07273	2	TSM APPLICATION IS HANGING IN CLI FUNCTION(CLI_UTLTRACEINIT) DURING LATCH INITIALIZATION IN MULTI-THREAD ENVIRONMENT.
IT07628	2	DB2DSCFGFILL TRAPS WHEN SAME NODE IS CATALOGED FOR MULTIPLE DATABASES WITH DCS PARAM SYSPLEX.
IT09421	2	A MULTI-THREADED APPLICATION RANDOMLY FAILS WITH SQL5005C
IT07742	2	UNABLE TO SEE IBM DB2 .NET PROVIDER AS DATA SOURCE WHEN WORKING WITH VISUAL STUDIO
IT10550	2	BOOLEAN CASTING ISSUE WITH IBM DB2 .NET ENTITY PROVIDER AGAINST DB2 LUW SERVER
IT06595	2	CLP WILL FAIL WITH SQL30082N RC=17 WHEN USING DB2DSDRIVER.CFG AND CONNECTING TO SERVER WITH AUTHENTICATION=CLIENT SET
IT10197	2	SMALL MEMORY LEAK IN DB2 CLIENT/DRIVER IF THE ALTERNATE SERVER LIST IS ENABLED IN A DB2DSDRIVER.CFG FILE
IT11165	2	THE DB2CFEXP BACKUP DOES NOT EXPORT SOME DBM CFG PARAMETERS, ANDEXPORTS SOME DISCONTINUED DBM CFG PARAMATERS.
IT07837	2	MEMORY LEAK WITH DB2.NET APPLICATION WRITTEN USING DB2 V10.1 /V10.5 CLIENT DRIVER
IT06612	2	CLI CONNECTION RETURN WARNING(CLI0004W) WHEN CFG FILE CONTAIN AUTHENTICATION=CLIENT
IT07707	2	THE DB2 UPDATE DB CFG FAILS WITH SQL5133N ERROR AFTER UPDATING FROM DB2 10.5 FIX PACK 4 TO NEWER LEVEL
IT06494	2	DB2CFEXP MAY NOT PRODUCE CORRECT OUTPUT OR MAY TERMINATE WITH SQL5062N ERROR.
IT10097	2	PREPARE FOR 32BIT ON 64BIT MACHINE MAY RECEIVE SQL20537W
IT07893	2	PARAMETERS STORED AS STRINGS ARE NOT APPLIED BY DB2CFIMP (ERROR -5060)
IT05143	2	IBM.DATA.DB2.DB2EXCEPTION: ERROR [IX000] [IBM][IDS/UNIX64] WHEN TRYING TO CREATE AN ENTIY DATA MODEL
IT05124	2	DB2BATCH HAS ITS DEFAULT ISOLATION LEVEL AS RR WHICH MAY CAUSE PERFORMANCE ISSUES/LOCKS ON PRODUCTION
IT08329	2	MISSING PASSWORD FOR REMOTE CONNECTIONS AND INVALID STATEMENT HANDLE FOR STATEMENT TYPE AND SUPPORT OF OCI_ATTR_SPOOL_AUTH
IT09391	2	CREATING A DATABASE WITH NAME TCP FAILS WITH SQL0104 IN DB2 CLP V10.5
IT08007	2	PERFORMANCE IMPROVEMENT FOR DB2 .NET RUNTIME CLIENT CONNECTION WHILE CONNECTING WITH DATABASE'S CATALOGGED IN REMOTE LDAP SERVE
IT09147	2	SMALL AMOUNT OF MEMORY LEAKS IN CLP OR EMBEDDED SQL APPLICATION ON EACH TCPIP CONNECTION TO DB WITH A DB2DSDRIVER.CFG FILE
IT09181	2	USING ARRAYINPUT WITH ARRAY SIZE 1 AND APPL HAS EXPLICITLY SET ATOMIC=0, DRIVER FLOWING NOT ATOMIC CONTINUE ON EXCEPTION TO ZOS
IT09178	3	SQLCREATEDB DOES NOT WORK WITH DSDRIVER BECAUSE OF MISSING .BNDFILE.
IT10998	3	UPDATING INFORMIX COLUMNS WITH TYPE DATETIME HOURS TO SECONDS FAILS VIA ENTITY FRAMEWORK: UNKNOWN PRIMITIVETYPEKIND TIME
IT10962	3	DB21017E MAY BE RETURNED WHEN EXECUTING DESCRIBE INDEXES FOR TABLE SHOW DETAIL.
IT07170	3	BLOBS ARE NOT HANDLED CORRECTLY WHEN FETCHING THE DATA FROM CURSORS OPENED WHEN CALLING THE PROCEDURE.
IT08008	3	CLI QUERIES WHICH NEEDS INTERNAL TRANSLATION MAY THROW CLI0118E
IT08333	3	DB2CLI REFRESHLDAP TRUNCATES HOST DATABASE NAME
Fix Pack 7 - Codegen and Runtime
IT07899	1	PARTIAL AGGREGATION OPERATOR CAN CAUSE MEMORY CORRUPTION LEADINGTO DB2 INSTANCE ABEND
IT08656	1	SECURITY: DB2 LUW CONTAINS A VULNERABILITY IN SCALAR FUNCTION THAT MAY CAUSE DB2 SERVER TO TERMINATE ABNORMALLY (CVE-2015-1935)
IT09903	1	DB2 CRASH SQLO_BUFFSMALL
IT09945	2	MEMORY USAGE CAN INCREASE WHEN RUNNING SQL ON OBJECT WITH XML COLUMN.
IT09596	2	SYSIBM.POWER ( EXPRESSION1, EXPRESSION2 ) WILL RETURN INCORRECT RESULTS FOR SOME VALUES WHEN THE BIGINT DATA TYPE IS USED
IT10182	2	MEMORY & PERFORMANCE IMPACT WHEN DIFFERING LENGTH VALUES REPEATEDLY ASSIGNED TO SAME SLOT OF ARRAY OF VARIABLE LENGTH DATATYPE
IT06578	2	PARTIAL EARLY AGGREGATION/DISTINCT RUNNING WITH REDUCED MEMORY INTO DB2DIAG.LOG
IT08116	2	ASSERTIONFAILEDEXCEPTION: AN ASSERTION 'PKEY != __NULL' FAILED. ADDITIONAL INFO: PKEY IS A NULL POINTER!
IT03173	2	PARALLEL-ENABLED QUERY EXECUTION MAY ALLOCATE EXCESSIVE APPLICATION HEAP MEMORY FOR REBAL OPERATOR
IV78737	2	WRONG RESULT IS POSSIBLE WITH QUERIES AGAINST COLUMNAR TABLES WHEN PLAN HAS SHARED COMMON SUBEXPRESSION AND INDEX SCAN
IT08613	2	RARE TIMING DB2 CRASH IN SMP
IT09758	2	UNEXPECTED SQL1289W WARNING AND MISSING DATA WHILE RETRIEVING A SUBSTRING FROM A CLOB FIELD IN A UTF-8 DATABASE
IT10036	2	MEMORY LEAK IN DB2SYSC PRIVATE MEMORY WHEN AN EXTERNAL CONVERSION TABLE IS USED
IT10327	2	INSERT OF A UCS-2 LOB IF SPLIT BETWEEN BUFFERS ON A SURROGATE CHARACTER COULD INSERT BAD DATA FOR THIS SURROGATE CHARACTER
IT09614	2	INCORRECT RESULT COULD BE RETURNED WHEN USING FULLWIDTH UNDER- SCORE CHARACTER (X'EFBCBF') IN LIKE PREDICATE AGAINST CLOB DATA
IT09523	2	SQL0433N WITH UTL_MAIL.SEND_ATTACH_RAW WHEN ATTACHMENT IS LARGERTHAN 1MB
IT10280	2	DB2 MIGHT ABORT WITH SIGSEGV IN SQLRIPERKEY2
IT07146	2	ROUND() ON INTEGER DATA TYPE MIGHT PRODUCE INCORRECT OVERFLOW SQL0802N ERROR
IT06524	2	JAVA EXTERNAL ROUTINE WHICH RETRIEVES RESULT SET VIA STORED PROCEDURE CALL HAVING CURSOR MAY RETURN BUGCHECKEXCEPTION
IT09332	2	WRONG RESULTS MAY HAPPEN WHEN ACCESS PLAN CONTAINS INDEX SCAN ONTHE OUTER LEG OF THE HASH JOIN
IT10009	2	WRONG RESULTS ARE POSSIBLE WHEN USING THE SAME COLUMN TWICE IN DIFFERENT AGGREGATION FUNCTIONS
IT08264	2	POSSIBLE EXHAUSTION OF CONNECTION HANDLES DUE TO CLI HANDLE LEAKIN THE DBMS_SQL AND XCOMP MODULES CAN LEAD TO -901
IT05716	2	UNDER RARE CIRCUMSTANCES, QUERY IN DPF ENVIRONMENT MIGHT HANG INMERGING DIRECTED TABLE QUEUE (MDTQ)
IT06542	2	EMPTY RESULT OR A HANG MAY HAPPEN FOR CDE TABLE QUERY IF TABLESPACE HAS ENOUGH TABLES TO GENERATE NEGATIVE TABLE_ID
IT08456	2	INCORRECT QUERY RESULTS OR SQL0901N REASON "BAD OUTER COMPARE" IN SQL EXECUTION PLANS USING MDTQ OPERATORS
IT08683	2	WRONG INITIALIZECLI CAN LEAD TO -901 AND CRASH DUE TO INCORRECT ERROR REPORTING FUNCTION
IT06576	2	DB2EXPLN HANGS BECAUSE ITS ASSOCIATED DB2FMP CRASHED DUE TO "CORRUPT POOL FREE TREE NODE"
IT12367	2	APPLICATION ERROR REPORTING SQL0901N MAY OCCUR WHEN PERFORMING AHASH JOIN
IT06173	2	DB2 SERVER MEMORY LEAK IN APPLICATION HEAP WHEN PROCESSING LOB DATA IN A DPF ENVIRONMENT
IT06577	2	TRAP IN SQLKQSND IN DPF ENVIRONMENT DURING RUNTIME OF SQL QUERIES HAVING STACKED MDTQS
IT07420	2	SQL0901N (REASON "OPTBITFILTERSIZE LESS THAN MIN".) MIGHT OCCUR WHEN RUNNING A QUERY WITH HASH JOIN IN ACCESS PLAN
IV74977	2	SQL0901 ERROR (UNEXPECTED ERROR AT LOADNESTEDQUERYEVALUATOR.CPP:125) FOR QUERY WITH COMMON TABLE EXPRESSION
IT07520	2	QUERY WITH UNION MIGHT FAIL WITH SQL0901N ALONG WITH REASON "RID_QNCP'S QUN IS NOT IN TABLES SET"
IT05151	2	TRAP IN SQLRIGAPRESETSTATE
IT06599	2	DB2 VARCHAR_BIT_FORMAT ALLOWING ODD LENGTH INPUT
IT06107	2	ROUND AND TRUNCATE FUNCTIONS WITH DB2_COMPATIBILTY_VECTOR=ORA GIVES EXPONENT RESULT FORM FOR CALCULATION.
IT06641	3	PERFORMANCE MAY BE POOR FOR DBMS_LOB.INSTR
IT10409	3	TRUNCATION OF DATA FOR SUBSTR AGAINST COLUMN DEFINED WITH CODEUNITS32
Fix Pack 7 - Communication
IT07969	1	DB2START THROWS SQL1042C ERROR WHEN SSL IS CONFIGURED AND DB2TRCENABLED, DB2SYSC CRASHES
IT10392	2	APPLICATION STILL SHOWS AS "UOW EXECUTING" WHEN THE LOCAL CLIENTIS TERMINATED
Fix Pack 7 - DB2 Tools
IT08994	2	MS ACCESS FAILS WITH RESERVED ERROR -7749
IT10411	2	NNSTAT MIGHT REMOVE UNIQUE RULE FROM EXISTING INDEX SPECIFICATIONS ON THE NICKNAME.
IT08326	2	MS ACCESS FAILS WITH RESERVED ERROR -7732
IT07502	2	ADMIN_CMD WILL FAIL WITH ERROR SQL0104N WHEN AUTOMATIC VALUE IS USED FOR UTIL_HEAP_SZ OR HADR_SPOOL_LIMIT
IV77388	2	SHADOW NICKNAMES ARE NOT CLEANED UP AFTER ERROR IN NNSTATS
Fix Pack 7 - DRDA Services
IT11287	1	DURING ARRAY INSERT, DB2 MAY HANG IF THE CONNECTION GETS TERMINATED
IT09674	2	SMALL MEMORY LEAK IN DB2 CLIENT/DRIVER IF CLIENT AFFNITY IS ENABLED
IT08825	2	TRANSACTION MANGER REMAINS WAITING FOR XA_ROLLBACK AFTER ABEND ON Z/OS
IT09513	2	DIA5000C INVALID FD:OCA DESCRIPTOR REPORTED IN DB2DIAG.LOG FILE
IT06573	2	IF ACR IS IN EFFECT, CLIENT MAY SEND INTERRUPT TO OLD PRIMARY INSTEAD OF NEW PRIMARY
IT08830	2	CLIENTAFFINITIES TO SKIP CONNECT ATTEMPTS TO UNAVAILABLE SERVERS
IT09086	2	LUW CLIENT TO DATABASE ON Z/OS DB2 V11, USING 3-PART NAME TO ROUTE THE DRDA REQUEST TO LUW CAUSES SQL30020.
IT07411	2	ODBC APPLICATIONS RETURN NO ROW AFTER UPGRADING THE DB2 GATEWAY
IT10933	2	CONNECTION ATTEMPTS FROM 3RD PARTY DRIVERS MAY FAIL WITH UNEXPECTED SECURITY ERROR
IT06574	2	SQLERRD REPORTS -1 AT SQLCA UNEXPECTEDLY UNDER CODE CONVERSION
IT08061	2	CLI APPLICATION FAILS DURING SQLEXECUTE() WITH ERROR CLI0108E
IT07808	3	CLIENT MAY REPORT CONNECTION LOSS IF DOWN LEVEL DB2CONNECT SERVER IS IN THE CONNECTION PATH.
IT07300	3	APPLICATION MAY GET SQL1224 WITH UNICODE CLIENT IF SERVER IS DB2FOR ZOS AND DCS PARAMETER IS SET
IT11996	3	BEHAVIOUR CHANGE OF SQLJRUPDATESRVLST IN FIXPACK 5 CAUSES EXCESSIVE MESSAGE DUMP IN DB2DIAG.LOG
Fix Pack 7 - Data Management Services
IT09406	1	DB2 PREFETCHER INITIATES PANIC AND SHUTDOWN OF INSTANCE IN SQLDASSERTOBJEXISTS REPORTING INVALID BMPEXISTS LATCH IN DB2DIAG.LOG
IT03627	2	RUNSTATS ON TABLE ... TABLESAMPLE(X) ON A RANGE PARTITIONED TABLE MAY RESULT IN A 'BADPAGE' ERROR
IT05031	2	RESTART DATABASE TAKES LONGER THAN NECESSARY ON SYSTEMS WITH A LARGE NUMBER OF TABLES
IT09366	2	HANG DUE TO INPLACE REORG FAILING TO UNLATCH A PAGE
IT07689	2	DB2 CRASHES AFTER SETTING DB2_RESOURCE_POLICY.
IT08344	2	HADR REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO SQLB_BAD_PAGE
IT11482	2	LOG REPLAY FAILS WITH DB2DIAG.LOG MESSAGE SQLDLOADTCB, PROBE:10553 ZRC=SQLD_REC_DELETED "DELETED RECORD ID"
IT08250	2	PURESCALE: FUNCTION SQLPSHRVALIDATELOGSTREAMENDPOINT MIGHT GENERATE MANY WARNINGS IN DB2DIAG.LOG AND DUMP FILES REPEATEDLY
IT04530	2	THE MONITOR INFORMATION IN TCB IS WRONG WHICH CAUSES INCORRECT REORG_LONG_TBSPC_ID VALUE
IT09085	2	INDEX SCAN ON A DATA PARTITIONED TABLE MAY TRAP OR RETURN INCORRECT RESULTS IF PARTITIONS BECOME AVAILABLE DURING THE SCAN
IT02763	2	DEAD LATCH WHEN RUNNING TRUNCATE TABLE OPERATION AND ANOTHER AGENT LOOKS TO FLUSH THE BUFFERPOOL
IT06053	2	UPDATE ON EXTENDED ROW SIZE TABLE AFTER TABLE ALTER CAN RESULT IN -901 WITH MESSAGE "CONVERSION TO SQLD_TDATAREC NOT SUPPORTED"
IT09753	2	TRAP IN SQLDUNCHAINGIXCB DURING HADR TAKEOVER
IT11888	2	ONLINE REORG WITH CONCURRENT USER ACTIVITY MAY RESULT IN A BAD PAGE ERROR AND A CRASH OF THE DATABASE.
IT05797	2	ALTER TABLE STATEMENT RESULTS IN SQLCODE -901 OR POSSIBLE OBJECT TABLE CORRUPTION
IT04378	2	DB2 MAY CRASH UNDER SQLRIBNO IF AN INTERNAL RECORD IS SELECTED AS PART OF A RIDLIST SCAN
IT09420	3	IN DB2DIAG.LOG INFORMATION "DEFERRED ADC IS SKIPPED DUE TO PRIORERROR" MIGHT BE REPORTED FOR GLOBAL TEMPORARY TABLE WITH INDEX
IT11301	3	ON PARTICULARLY BUSY SYSTEM, SNAPTAB_REORG MIGHT RARELY RETURN REORG_STATUS OF '0'
IT04213	3	LOAD COMMAND WRITES ROW DATA INTO A TRANSACTION LOG WHEN THE ROWSIZE EXCEEDS THE PAGESIZE.
IT08195	3	THE SAMPLE PROGRAM, UTILRECOV.C NEED TO BE REVISED FOR V10.5.
Fix Pack 7 - Data Management Utilities
IT09394	1	INGEST: SQL0804N OR INCORRECT DECIMAL DATA LOADED WHEN DECIMAL IS IN ASCII AND PRECISIONS DO NOT MATCH
IT08717	2	INGEST FAILS WITH SQL1013N WHEN DB2DSDRIVER.CFG BUT NOT CATALOG IN THE DATABASE DIRECTORY
IT06049	2	NEW LOGGING MECHANISM CAUSE REMOTE LOAD PERFORMANCE PROBLEM
IT09393	2	SQL0901N WITH REASON TEXT "SEMVAL OR SEMADJ ... OVERFLOW" OR "SEMAPHORE ID DOES NOT EXIST ..." WHEN RUNNING THE INGEST COMMAND
IT11022	2	INGEST HANG DUE TO INTERNAL DEADLOCK BETWEEN THREADS.
IT07663	2	LOAD COMMAND WITH 'ALLOW READ ACCESS LOCK WITH FORCE' WILL RETURN SQL0911N WHEN OTHER APPLICATIONS ARE QUERYING THE SAME TABLE.
IT08459	2	TABLESPACE STATE NOT SET TO 0X100 WHEN THE LOAD COPY TO TSM IS NOT ACCESSIBLE ON AUXILIARY HADR STANDBY
IT06572	2	EXPORT WITH "MODIFIED BY CODEPAGE" MAY TRUNCATE THE DATA.
IT07284	2	APPLICATIONS CALLING THE SQLUGRPN() API MAY TRAP IN SQLVDATE()
IT07165	2	LOAD FAILS WHEN INPUT LOB FILE IS LARGER THAN 4GB
IT07578	2	IMPORT WITH "MODIFIED BY IDENTITYIGNORE" OPTION IS SLOWER IN HP-UX AND SOLARIS DUE TO MISALIGNED MEMORY ACCESS
IT12566	2	PERFORMANCE DEGRADATION IN ROLLBACK WITH V10.5 FP5 AND FP6
IT07245	2	LOAD FROM CURSOR FROM CHAR TO VARGRAPHIC VALUE FAILS TO LOAD INTO THE COLUMN.
IT09881	2	AGENT TRAPS WITH -901 WHILE ATTEMPTING TO CREATE A TEMPORARY TABLE FOR SPILLING.
IT08562	2	WHEN MANY LOAD REMOTE FETCH OPERATIONS RUN AGAINST DIFFERENT TABLES CONCURRENTLY, ONE OR MORE OF THEM MIGHT RARELY HANG.
IT07246	2	LOAD COMMAND RECEIVES SQL2032N DESPITE SETTING OF DB2_LOAD_COPY_NO_OVERRIDE=COPY YES
IT09599	2	LOAD WITH EXCEPTION TABLE FAILS WITH SQL3015N(-206) WHEN LOADINGINTO V9.7 DATABASE
IT10441	2	LOAD FROM CURSOR MAY HANG, IF DATA SOURCE REFERS TO A TABLE AND HAS INDEX WHICH NEEDS TO BE REBUILT
IT08799	2	HADR STANDBY MIGHT CRASH RARELY BY ACTIVATE DB AT STANDBY
IT05620	2	EXPORT UTILITY MIGHT EXIT WITH SOME WARNING, SUCH AS SQL0437W, AND NOT EXPORT ANY DATA.
IT10827	2	LOAD WITH ^M CHARACTER FAILS AND RETURNS SQL2038N IN DPF.
IT07912	2	DB2 INSTANCE MIGHT CRASH IF A LOAD'S DB2LRID OR DB2LCFM EDU FAILS VERY EARLY IN A SPECIFIC FUNCTION
IT06815	3	WHEN LOADING DATA INTO A COLUMN-ORGANIZED TABLE, INSTANCE MAY CRASH
IT07958	3	LOAD FROM CURSOR USING REMOTE FETCH AND MODIFIED BY CODEPAGE DOES NOT RETURN ERROR
IT02471	3	THE "NUM_SESSIONS" VALUE PASSED BY DB2 TO THE VENDOR API SQLUVINT() WITH THE LOAD WITH COPY YES COMMAND IS ALWAYS "0"
IT05113	3	LOAD UTILITY USING "FOR EXCEPTION" OPTION FAILED WITH -804 ERRORAFTER FIXPACK UPGRADE
IT07576	3	CONCURRENT LOAD IN SAME TABLE ON MULTIPLE PARTITIONS IN DPF MAY ABORT WITH: SQL3508N ERROR IN ACCESSING A FILE OR PATH OF TYPE
IT09843	4	FORMATTING ISSUE IN ERROR MESSAGE FOR SQLSFETCHNEXTTEMPRECORD RC:-2146238461 MAY CAUSE ERRORS IN USER'S ERROR HANDLING SCRIPTS
IT07462	4	DB2 LOAD COMMAND PRODUCES 'ERROR' MESSAGES DURING SUCCESSFUL OPERATION - NOT IT01013
Fix Pack 7 - Data Recovery Services
IT09671	1	TOO MANY LOGS CAUSING READS ON STANDBY DATABASE TO CRASH
IT11108	1	RESTORE DB WITH ENCROPTS "SHOW MASTER KEY DETAILS" ON NON-ENCRYPTED IMAGE CAUSES UNEXPECTED RESTORE TO COMPLETE
IT09832	1	TOO AGGRESSIVE PAGE CLEANING ISSUE ON HADR STANDBY,
IT09108	1	DB2LOGREADAPI CALL CAN HANG DUE TO LOOPING OF DB2LFR THREAD IN PONG PAGE.
IT09111	1	INSTANCE CRASH WITH SIGNAL 11 TRYING TO OBTAIN LATCH TO CHECK ROLLFORWARD TYPE
IT05722	2	DATABASE SCHEMA TRANSPORT FAILS ON LINUX390 WITH SQL0293N ERROR ACCESSING A TABLE SPACE CONTAINER.
IT08106	2	CONTENTION ON SQLP_LTRN_CHAIN__ENTRY_LATCH AFTER LOCK ESCALATIONIS INTERRUPTED DEGRADES PERFORMANCE
IT05118	2	DB2VEND PROCESS NAME TRUNCATED FOR LARGER EDU NUMBERS
IT06400	2	PREC_NUM_WOCB SETTING IN DB2BPVARS.CFG NOT TAKING EFFECT
IT07488	2	SMALL DBHEAP CONFIGURATIONS CAN TRIGGER SLOW CRASH RECOVERY PERFORMANCE
IT11458	2	DB2READLOG API REPORTING SQL2654W INSTEAD OF SQL1273N FOR MISSING LOG ERROR CAUSING INCORRECT RESULT IN REPLICATION
IT10994	2	ADDITIONAL CONSISTENCY AND VALIDATION CHECKS ON LOG PAGES IN MEMORY
IT10856	2	DEADLATCH CAN OCCUR ON SQLO_LT_SQEAPPSERVICES__M_APPSERVLATCH & SQLO_LT_SQLP_TENTRY__TRANENTRYLATCH
IT05407	2	AFTER MIGRATION FROM 9.7 TO 10.5 THE OLD DB2 LOGS IN MIRRORLOGPATH ARE NOT DELETED
IT05210	2	HADR STANDBY DATABASE MARKED BAD WITH SQLPREPLAYMASTER, PROBE:2500 SQLP_TRECOVF
IT06221	2	Q CAPTURE WARM START MIGHT FAIL DUE TO -1273 FROM DB2LOGREAD AFTER RESTORE AND RFWD, IF YOU DELETE LOGS IN PREVIOUS LOG CHAIN
IT08309	2	PRIVATE MEMORY LEAK DURING CRASH RECOVERY, ROLLFORWARD, HADR FORCED TAKEOVER
IT07139	2	RESTORE AND DB2CKBKP DO NOT WORK WITH LOCAL TAPE DEVICES ON UNIXIN DB2 V10.5 FIXPACK 5.
IT06425	2	ROLLBACK PERFORMANCE MIGHT BE AFFECTED BY LARGE NUMBER OF DIRTY PAGES
IT07652	2	HADR STANDBY TRAPPED WHEN ATTEMPTING TO LOG A MESSAGE TO DB2DIAG.LOG DUE TO ERROR IN CHANGING HADR_REMOTE_XXX DB CFG PARAMETERS
IT09683	2	"DB2PD -LOCKS" OUTPUT MAY DISPLAY TRANHDL AS LOCK OWNER FOR LOCKS BEING WAITED FOR
IT08728	2	DB2 MAY LEAK FILE HANDLES WHEN USING HADR, OR READLOG/QREP/CDC (OR ANY LOG READER).
IT08862	2	DB2 MAY LEAK FILE HANDLES WHEN RETRIEVING AN ARCHIVE LOG
IT07041	2	INCREMENTAL BACKUP MAY FAIL WITH SQL2048N
IT11173	2	DB2 MIGHT ABORT IN SQLPWRITETOLOG, PROBE:1370
IT10544	2	DATABASE UPGRADE FAILS TO RENAME OR DELETE UNARCHIVED LOGS AND LOGS WITHIN PRIMARY/MIRROR PATH
IT09743	2	HADR PRIMARY MAY HIT CONGESTION AFTER HADR STANDBY ENTERS PEER STATE QUICKLY
IT06297	2	SLOW PERFORMANCE OF UPDATE AND INSERT LOB TRANSACTIONS AFTER STOPPING ONE OR MORE MEMBERS ON A PURESCALE SYSTEM
IT07056	2	DB2 RESTORE MAY TERMINATE WITH -902 OR DB2 CONNECT WITH -1042 ONWINDOWS IF DB WAS NOT DROPPED OR FULLY REMOVED PRIOR TO RESTORE
IT04154	2	PURGING OF EXTRA LOG FILES CAN TAKE A LONG TIME
IT09414	2	EXTENSIVE DB2DIAG.LOG LOGGING IN SQLPSCANHISTFILEFORRECOVERYLISTAND SQLPSHRTHROTTLEWORKER
IT05914	2	DB2CKLOG MIGHT WRONGLY REPORT A LOGFILE AS INVALID, IF IT IS A TRUNCATED LOGFILE
IT08073	2	EXCESSIVE DIAGNOSTIC LOGGING SERVICING ASYNCHRONOUS LOG READ REQUESTS (DB2READLOG API)
IT08217	2	DB2RFPEN MIGHT SET INCORRECT TIME TO GLFH WHEN USING NON-DB2 OFFLINE BACKUP IMAGE
IT06793	2	DB2LOGMGR MAY GET INTO A SELF DEADLATCH SITUATION CAUSING A HANG
IT07687	3	BACKUP FAILS SQL2079N AN ERROR WAS REPORTED BY THE SHARED LIBRARY "DB2COMPR.DLL". RETURN CODE: "1".
IT06570	3	UNDER RARE CONDITIONS, DB2 ONLINE BACKUP MIGHT FETCH AND INCLUDE MORE LOGS THAN REQUIRED FOR THE RESTORE
IT09285	3	ROLLFORWARD MAY FAIL WITH SQL1042C WHEN MIRRORLOGPATH IS USED
IT05365	3	HISTORY PRUNNING NOT BEHAVING AS DOCUMENTED
IT08643	3	DB2UNCOMPRESSLOG REPORTS CORRUPTED LOG FILE ERROR WHEN DECOMPRESSING A LOG FILE WITH MORE THAN 1 COMPRESSED BLOCK
IT09279	3	ABOUT HADR: COPY LOGS FROM THE OLD LOG PATH TO NEW LOG PATH
IT03314	3	DB2 PRUNE HISTORY YYYYMMDDHHMMSS AND DELETE IS DELETING NECESSARY LOG WITH ONLINE BACKUPS.
IT11515	3	DB2 READLOGAPI MIGHT PRODUCE SQLPSHRVALIDATELOGSTREAMENDPOINT, PROBE:1122 MESSAGES IN THE DB2DIAG.LOG.
IT03449	3	THE ROLLFORWARD DB COMMAND PRINTED INCORRECT RESULT FOR LOG FILES PROCESSED.
IT07740	3	REMOVE MESSAGES SQLPUPDATEMEMSTATUS, PROBE:611 FROM DB2DIAG.LOG WHEN STMM IS TUNING LOCKLIST
IT06639	3	DB2FLSN RUNS VERY SLOWLY WITH NON-INSTANCE USER
IT06575	3	SQLUDCONVERTTIMESTAMPTOSQLOTIME ERROR MESSAGE WHILE DOING ONLINEBACKUP
IT10707	3	WITH MULTIPLE DB2READLOG API CALLERS (HADR, CDC, ETC), LOG FILESMAY NOT BE RENAMED RESULTING IN PRIMARY LOG PATH TO FILL UP
IT04293	3	IN PURESCALE DB2 LOG HEADER (XHDR) UPDATION INFO IS DUMPED AS WARNING ,WHICH SHOULD BE AT INFO LEVEL
IT11591	3	WARNING MESSAGE IN DB2DIAG.LOG ON STANDBY
IT09089	3	SOME DUMP FILES ARE GENERATED DURING ROLLFORWARD EVEN IT RUNS SUCCESSFULLY WITH NO ERRORS.
Fix Pack 7 - Federation
IT09939	1	DB2 MIGHT RETURN SQL0901N WHEN EXECUTING QUERY WITH ROLLUP OR GROUP BY
IT10848	1	HANG FOR QUERIES REFERENCING AT LEAST ONE COLUMN ORGANIZED TABLEAND WHEN THE QUERY CONTAINS AN EXORBITANT NUMBER OF OLAP FUNCTI
IT11765	1	DB2 MAY CRASH WITH SQLQGRFWDFEDPREP ON TOP OF CALL STACK WHEN REPLAYING FEDERATED XA LOG RECORDS
IT06579	2	IMPORT ON SYBASE NICKNAME FAILED WITH SQL27999N RC=14
IT09392	2	DB2 MAY CRASH IN MEMCPY UNDER SQLQGRFWDFEDPREP WHEN REPLAYING FEDERATED XA LOG RECORDS
IT07401	2	FEDERATED SERVER INSTANCE MIGHT CRASH WHEN STATEMENT MONITOR IS ON AND THERE ARE CONCURRENT QUERY EXECUTIONS.
JR52996	2	SELECT FROM A FEDERATED NICKNAME MAY RECEIVE SQL0180N ERROR WITHDATETIME/TIMESTAMP COLUMNS AFTER UPGRADE TO 10.1 FP3
IT07660	2	A QUERY CRASHED DB2 DUE TO THE BAD SECTION WITH DUPLICATE RELOC ENTRIES
IT07906	2	NULL AS CHAR(0) IS PUSHDOWN TO ORACLE FROM DB2 WHICH CAUSES ERROR ORA-01723: ZERO-LENGTH COLUMNS ARE NOT ALLOWED
JR52153	2	CREATE NICKNAME FAILS WITH SQL0901N "INVALID NICKNAME COLUMN LENGTH" WHEN USING ORACLE RDB ODBC DRIVER
Fix Pack 7 - Index Manager
IT06580	1	DATA CORRUPTION CAUSED BY LOCKING BEHAVIOR WHEN LOCKSIZE SET TO BLOCKINSERT AND A TRANSACTION INSERTING INTO AN MDC TABLE
IT10132	1	INFINITE LOOP DURING INSERT INTO INSERT TIME CLUSTERING TABLE RESULTING IN TRANSACTION LOG FULL
IT07065	2	REORG TABLE RECLAIM EXTENTS ON MDC TABLE MIGHT DEADLOCK WITH UPDATE/DELETE DUE TO IX-LOCK ON EMPTY MDC BLOCK
IT10184	2	UPDATE TO COLUMNAR TABLE CAN SOMETIMES LEAD TO DB2 CRASH
IT07513	2	EXCESSIVE DUMPING FROM SQLILATCHPINNED() ON NON-SEVERE ERROR RC
IT05944	2	SQL1655C, SQLSTATE=38030. SQLB_BADHDR "BAD PAGE HEADER", SQLBREADPAGE CALLED FROM SQLIFIXSMP, SQLBFIXPAGE, SQLBFIX
IT06986	2	NON-SEVERE ERROR DURING ROLLOUT PROCESSING FOR A DELETE FROM MDCTABLE WITH EXTENDED ROW SIZE MIGHT RESULT IN DATABASE SHUTDOWN
IT07091	2	PURESCALE ONLY; SQL1034C CAUSES MEMBER CRASH. PROCLEAF2DEL, PROBE:2; "KEY NOT FOUND WITHIN NODE"; SQLISEARCHTREEUNDO
IT10812	2	INDEX/DATA MISMATCH MIGHT OCCUR IN AN MDC TABLE AFTER A DEFERREDROLLOUT IS SUSPENDED
IT07050	2	DB2 MIGHT TRAP WHILE COLLECTING STATISTICS FOR INDEXES
IT07133	3	SMP ONLY WITH READAHEAD PREFETCHING. ASSERTION IN SQLRXCON2 CALLED FROM SQLILOCATESTOPSLOT. INVALID CONVERSION.
Fix Pack 7 - Install and Catalog Services
IT09842	1	DB2 MAY CRASH ON VIEW GENERATION AUTH CHECK.
IT06667	2	DB2CKUPGRADE UTILITY FAILS WITH "SQL1344N ORPHAN ROWS FOUND IN THE SYSTEM CATALOGS".
IC98880	2	LUM LIBRARY NEEDS TO BE UPDATED FOR LINUXAMD64
IT05907	2	-901 DURING ALTER FUNCTION STATEMENT
IT09270	2	DB2 WILL TRAP WITH SIGSEGV WHEN ISSUING THE SQL STATEMENT OF "REVOKE ROLE ROLE_AUTH_CONNECT FROM PUBLIC"
IT07506	2	ASYNCHRONOUS PARTITION DETACH MIGHT FAIL ON TABLE MARKED UNAVAILABLE IF TABLE CONTAINS GENERATED COLUMN
IT04141	2	IMPLEMENTATION FIELD IN SYSCAT.ROUTINES VIEW ALSO SHOWS THE MODULE NAME FOR SOURCED FUNCTIONS.
IT05744	2	RUNSTATS RESULTS IN DB2 CRASH WHEN USER DROPS THE EXISTING TABLECOLUMNS BETWEEN SET PROFILE AND USE PROFILE
IV73311	2	ADDING INTERCONNECT TO MEMBER OR CF ON AIX ROCE ENVIRONMENT TOOK A LONG TIME
IT05423	2	MISSING 32-BIT OCI LIBRARY IN THE INSTALLATION IMAGE.
IT10766	2	DB2 INSTANCE MAY CRASH WHEN RESIZING VARCHAR COLUMNS
IT08658	2	LIMIT TEMPORARY *.RSP AND _DB2XXXX CREATED IN %TMP% TO PREVENT 1603 FROM INSTALLER
IT05055	2	DB2 MAY PANIC WHEN TRYING TO UNLOCK AN ALREADY UNLOCKED LATCH FROM 'SQLRLC_AUTH_FIND_INSERT()'
IT08387	2	DATABASE UPGRADE FAILS WITH SQL0204N.
IT05100	3	WHEN YOU RUN DB2UNINS FOR DB2 10.5 ON GERMAN LANGUAGE WINDOWS ITCRASHES.
IT07501	3	INCORRECT OBJECTNAME IN SYSCAT.AUDITUSE DURING AUDIT POLICY REPLACE OPERATION FOR DATABASE
IT09426	3	DB2CKUPGRADE DOESN'T WARN ABOUT PACKAGES DEPENDING ON DISCONTINUED FUNCTIONS
IT10900	3	CHANGE TO REVERT BACK DB2AUTOSTART REGISTRY VARIABLE BEHAVIOR WITHIN DB2IUPGRADE AS WAS IN DB2 VERSION 9.7
IT07342	3	PURESCALE ADD MEMBER/CF USING DB2IUPDT -ADD FAILS DUE TO MISSING $INSTANCE_HOME/SQLLIB/CTRL/.FENCEDID FILE.
IT08328	3	DB2PREREQCHECK MIGHT REPORT DBT3589W EVEN IF IOCP IS AVAILABLE IN LOCALES OTHER THEN ENGLISH.
IT03664	3	SYSTEM ODBC DSNS ARE REMOVED AFTER UPGRADING DB2 FROM AN OLDER RELEASE ON WINDOWS
IT05425	3	ENHANCE DB2PREREQCHECK TO CHECK FOR LIBSTDC++.SO.5 ON LINUX/390
IT11034	3	USER INTERRUPT ERROR MESSAGES IN DB2DIAG.LOG DUE TO AUTO RUNSTATS
IT07416	3	WARNING MESSAGE FROM DB2AGENT GETS REPORTED TO DB2DIAG.LOG PERSISTENTLY
Fix Pack 7 - Monitoring
IT08439	1	DB2SAP: MEMORY LEAK IN SAPTOOLS.MEMORY_TABLE
IT09821	1	DB2SAP: SAPTOOLS.MEMORY_TABLE RETURNS SQL0443N WITH DIAGNOSTIC TEXT "INVALID CHAR" FOR HALF SURROGATES
IT08453	2	ADMIN_MOVE_TABLE CAN FAILS DURING CLEANUP WITH SQL0443N
IT07498	2	ADMIN_MOVE_TABLE WITH COPY_USE_LOAD AND WITHOUT COPY_WITH_INDEXES LOADS DATA AND BUILDS ALL INDEXES IN ONE TRANSACTION
IT11394	2	ADMIN_MOVE_TABLE FAILS WITH XML COLUMNS
IT08518	2	SYSPROC.MON_GET_CONNECTION DOES NOT DIFFERENTIATE BETWEEN SECUREAND NON-SECURE CONNECTIONS TO A DATABASE.
IT06435	2	THE DB2 EVENT MONITOR TABLES REPORTS VIOLATION FOR "DB2 STORAGE OPTIMIZATION" EVEN THOUGH THERE IS NO LICENSE FOR DB2_STORAGE_OP
IT08719	2	DB2 MAY ABEND WITH SIGSEGV IN SQLRWAGENTLOCKWAITBUILDER::EXECUTE
IT10240	2	ADMIN_MOVE_TABLE REPLAY ACQUIRES HUGE AMOUNT OF LOCKS ON STAGINGTABLE WHICH CAN TRIGGER LOCK ESCALATION
IT07496	2	ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL0601N
IT07659	2	MONITOR DATA OF BP_HITRATIO MAY RETURN WRONG RESULT
IT09810	2	SAPTOOLS.EXEC_CLP() ROUTINE MIGHT LEAVE A DEFUNCT PROCESS BEHIND
IT09999	2	OWNER OF INDEX IS NOT PRESERVED WHEN ADMIN_MOVE_TABLE TARGET IS A BLU TABLE
IT10838	2	ADMIN_MOVE_TABLE REPLAY ACQUIRES HUGE AMOUNT OF LOCKS ON STAGINGTABLE WHICH CAN TRIGGER LOCK ESCALATION
IT07523	2	SYSPROC.ADMIN_MOVE_TABLE RETURNS SQL1224N FOR TABLES WITH SELF-REFERENCING REFERENTIAL CONSTRAINTS
IT09684	3	CHANGE APPLICATION_ID FUNCTION FROM NON-THREADSAFE TO THREADSAFETO AVOID HIGH NUMBER OF DB2FMP PROCESSES
IT05155	3	ADMIN_MOVE_TABLE FAILS WITH SQL1191N IF TABLE CONTAINS A LOB COLUMN AND COMPRESSION IS TURNED ON
IT09179	3	ON EXECUTING "STORED PROCEDURE: SYSPROC.WLM_SET_CLIENT_INFO", THE DB2 SNAPSHOT SHOWS "FAILED STATEMENT OPERATIONS = 2"
Fix Pack 7 - Parsing and SQL PL
IT07580	1	INCREASED DB2 PRIVATE MEMORY USAGE ON 10.1 FIX PACK 4 WHEN RUNNING TRUSTED UDFS OR STORED PROCEDURES
IT09788	2	ROUTINE DATA MAY BE RETAINED IN THE PACKAGE CACHE, WHICH RESULTSIN DATA CORRUPTION DURING SUBSEQUENT INVOCATION.
IT06867	2	DB2 MAPS SQLSTATE '23001' TO THE ORACLE -2292 INTEGRITY CONSTRAINT VIOLATION, BUT NOT SQLSTATE '23504'
IT07662	2	CURSOR VARIABLES REFERENCED EXTERNALLY CAN CAUSE MEMORY LEAK IN THE APPLICATION HEAP.
IT07418	3	MEMORY LEAK IN APPLICATION HEAP IF A COMPOUND STATEMENT IS TERMINATED EARLY AFTER USING A LOCAL CURSOR VARIABLE.
Fix Pack 7 - Platform Specific
IT07716	1	PDHADDCOUNTER FAILED WITH OSERR -1073738824
IT04711	1	ISSUING MULTIPLE DB2START RESTART COMMANDS (USUALLY THROUGH DB2GCF) CAN LEAD TO A HANG
IT09222	1	DB2 COREDUMP MAY BE MISSING ON LINUX IN COMPLEX TRAP SCENARIOS DUE TO NOT SETTING PR_SET_DUMPABLE
IT07516	2	RUNNING DB2IDROP OR DB2IUPDT TOOLS ON ONE INSTANCE MIGHT CAUSE DROPPING PROFILE ON ANOTHER INSTANCE FROM THE SAME INSTALLATION
IT05112	2	DB2START FAILS WITH SQL6048N WHEN USING ALIAS IN DB2NODES.CFG
IT04978	2	OPTIMIZE PERFORMANCE OF BACKUPS THAT USE DEDUP_DEVICE
IT09824	2	ISQL FAILS WITH ERROR SQL_HANDLE_HENV
IT08659	2	DB2 FENCED PROCESSES MAY BE UNSTABLE UNDER AIX DEFAULT 128MB USER DATA LIMIT
IT07075	2	STMM MAXIMUM TARGETS MAY BE TEMPORARILY TOO HIGH, SOME SWAPPING MAY OCCUR ON LINUX SYSTEMS
IT09121	2	"DB2 REORGCHK UPDATE STATISTICS ON TABLE ALL" MAY HANG
IV75040	2	IMPROVEMENT IN GETTING CPU INFORMATION CODE
IT08292	2	CONCURRENT LOAD FROM REMOTE CURSOR MAY FAIL WITH SQL3508N ON WINDOWS PLATFORM.
IT09283	2	DB2 PAGECLEANERS WAIT FOREVER WHEN ASYNCHRONOUS I/O REQUEST DOESNOT RETURN
IT10398	2	DB2PD -OSINFO GIVES WRONG INFORMATION OF CPU USAGE.
IT04758	2	OPTIMIZE PERFORMANCE OF BACKUPS THAT USE DEDUP_DEVICE
IT06008	2	AIX MULTIHEAP, BUCKETS MALLOC OPTIONS CAUSE REGRESSION IN PRIVATE VIRTUAL MEMORY USAGE
IV74573	2	EXCESSIVE MEMORY MANAGEMENT OVERHEAD IN APPLICATION SHARED HEAP WHEN A LARGE NUMBER OF COLUMNAR TABLES ARE UPDATED
IT06540	2	EXCESSIVE OVERHEAD IN SHARED SORT MEMORY, DATABASE MEMORY WHEN EXECUTING QUERIES ON COLUMN_BASED DATA
IT07434	2	SLOW DATABASE DEACTIVATION ON WINDOWS WITH LARGE BUFFERPOOLS ANDDB_MEM_THRESH 100
IT07408	2	DB2EXTSEC GETS 87 "THE PARAMETER IS INCORRECT." ERROR
IT11036	3	DB2_LOCAL_PS RETURNS RC 1 AFTER INSTANCE IS STOPPED
IT07738	3	STMM LOG FILE PERMISSIONS ARE SET TO 666 AND SHOULD BE 644
IT07525	3	INFORMATIONAL MESSAGES FROM PAM ARE LOGGED AS WARNING
IT08356	3	USING A FIFO FILE WITH DB2 CAN RESULT IN A SQLO_BPSE ERROR BEINGREPORTED ON AIX.
IT06551	3	SLOW MEMORY ALLOCATIONS OR POSSIBLE SEVERE DEGRADATION DURING OOM HANDLING DUE TO COALESCE MEMORY CHECK
IT08874	3	DB2 INSTANCE MAY ABORT IN STMM CODE WHEN MACHINE IS RUNNING DB2 INSTANCES FROM DIFFERENT RELEASES.
IT06585	3	SEMAPHORES GENERATED UNDER /DEV/SHM WITH WORLD WRITABLE PERMISSIONS.
IT09682	3	32-BIT DB2XPRT.EXE MAY CRASH WHILE PARSING A BINARY TRAP OR STACK FILE
Fix Pack 7 - Problem Determination
IT07419	2	'LIST TABLESPACES SHOW DETAIL' COMMAND IN DB2SUPPORT TOOL MAY CAUSE DB2SUPPORT TO HANG IF DATABASE IS IN SET WRITE SUSPEND MODE
IT10715	2	PD_GET_DIAG_HIST DOES NOT RESPOND TO FORCE REQUEST.
IT10911	2	I/O IN PDLOG() IS DELAYED WHEN THE PROCESS IS WORKING IN THE FENCED OPERATION MODE ON PURESCALE.
IT10857	2	DB2PD -DMPEVREC FAILS WITH ERRNO 5 ON WINDOWS PLATFORM
IT11292	2	FODC CRASH DIAGNOSTICS IMPROVEMENTS
IT06583	2	PD_GET_LOG_MSGS RETURNS SQL22237N WHEN ADMIN LOG NOT EXISTING
IT07481	2	ADDING DB2PDCFG -FLUSHBP TO ENABLE FLUSH BUFFERPOOL ON HADR STANDBY
IT10019	2	DUMPSHM OPTION FOR DB2FODC MAY MISS MUCH OF SHARED MEMORY FOR CONFIGURATIONS LARGER THAN 4GB
IT06476	2	DB2PD -ALLDBS -INST CAN LOOP CONTINUOUSLY ON SYSTEMS WITH VERY LARGE BUFFERPOOL CONFIGURATIONS
IT06582	2	DB2TOP MIGHT SEGV IF USER RESIZES WINDOW WHILE DB2TOP IS EXECUTING A 'CURSES' ROUTINE
IT07210	2	DB2TOP LISTING UTILITIES DOESN'T SHOW AN EXECUTING LOAD TASK STARTING FROM V10.5FP5
IT08285	3	IN DB2PD -APINFO OUTPUT, ADD A FIELD THAT REPORTS THE CURRENT RUNTIME DEGREE OF A QUERY.
IT08586	3	DB2SUPPORT WITH DB OPTION PRODUCES SQL1587N, SQL1469N IN LOG, AND PRINTS ERROR IN DB2DIAG.LOG IF IT RUNS AGAINST CF ONLY HOST.
IT10107	4	RUNNING 'DB2FODC -HANG' ON WINDOWS PLATFORMS GIVES ERROR 'GOTO WAS UNEXPECTED AT THIS TIME.'
Fix Pack 7 - Process Model
IT11146	1	FCM CAN DOUBLE FREE A BUFFER WHICH LATER LEADS TO A TRAP
IT05391	1	SET WRITE SUSPEND/RESUME MAY HANG WHEN IT IS NOT ABLE TO ACCESS THE DB CONFIG FILE
IT06358	1	THE DB2 INSTANCE MAY HANG OR TRAP ON LINUX WHEN USING A HIGH NUMDB SETTING
IT09342	1	CRASH IN SQEWLPRIORITYSCHEDQUEUE
IC95496	2	DB2 MAY TRAP IN SQLECLEANUPFEDDAEMONANCHOR DURING MULTIPLE LOGICAL NODES STARTUP
IT05815	2	FAILED OFFLINE FIXPACK INSTALLATION WITH ERROR DBI1572E
IT08393	2	ADD DUMPING OF XCP_CODE IN THREE CF MRB PD FORMATTERS.
IT10459	2	AUTOCONFIGURE DOES NOT RETURN SOME PARAMETERS TO DESIRED SETTINGS
IT08654	2	DB2START CAN NOT START THE INSTANCE ON HOST THAT IS NOT A MEMBER0.
IT11388	2	IMPORT REPLACE/LOAD/REORG/TRUNCATE TABLE CAUSING SLOWDOWN IN UNRELATED WORKLOAD
IT07211	2	WHEN USING LDAP AS DIRECTORY ENTRY TYPE ON WINDOWS, THERE CAN BESOME SPORADIC SQL5005C ERRORS.
IT10696	2	DB2CKUPGRADE IN PURESCALE DOES NOT FAIL IF DATABASE IS ADD MEMBER TOPOLOGY CHANGE PENDING BUT UPGRADE DOES FAIL
IT09997	2	ON DPF INSTANCE DATABASE MARKED BAD WITH PROBE SQLKDSENDREPLY, PROBE:8888
IT09084	3	NO TIMEOUT MECHANISM IN GLM LOCK SIZE MANAGEMENT THREAD CAUSED HANG ISSUE
IT05739	3	STOPPING INSTANCE MAY REPORT SQL6048N ERROR WHEN THE CLUSTER GOES OFFLINE IN MSFC ENVIRONMENT.
IT10539	3	DB2RBIND DOESN'T REBIND INOPERATIVE PACKAGES
IT07577	3	WITH AUTOMATIC FCM_NUM_BUFFERS, IN RARE CASE IT MAY STILL HIT SQL6040C NO FCM BUFFERS ARE AVAILABLE
IT05643	3	WHEN THERE IS NO DATABASE FIXPACK UPDATE TO PRIMARY CF, EXPECTSSECONDARY TO COME UP IN PEER STATE WHICH NEVER HAPPENS.
IT07688	4	WHEN HIT SQL5005 DUE TO FILE OPEN FAILURE, PREVIOUS DBM CFG VERSION WAS NOT RESTORED AND OUTPUT IN DB2DIAG.LOG
Fix Pack 7 - Quality Assurance
IT09073	1	INCORRECT RESULTS FROM SORT OPERATIONS ON DB2 VERSION 10.5.0.5
Fix Pack 7 - Query Compiler Optimizer
IT06951	1	POSSIBLE WRONG RESULT FROM SQL STATEMENT JOINING 4 OR MORE COLUMN-ORGANIZED TABLES
IT07456	1	REAL-TIME STATISTICS COLLECTION (RTS) MIGHT RESULT IN LOCK WAITSFOR OTHER APPLICATIONS
IT09336	1	IN A RARE CONDITION, A QUERY OF A CHAIN OF EQUALITY JOIN PREDICATES BETWEEN 4 OR MORE TABLES COULD PRODUCE EXTRA ROWS
IT05825	1	WRONG RESULT FROM STATEMENT WITH TWO OR MORE OLAP FUNCTIONS WITHCOMPATIBLE PARTITION-BY CLAUSES WITH ONE EQUATING TO CONSTANTS
IT11450	1	COMPLEX QUERIES MAY EXPERIENCE POOR PERFORMANCE
IT11563	2	COMPILING A QUERY THAT HAS "DISTINCT" KEYWORD IN INTRA_PARTITIONPARALLELISM MODE CAN RESULT IN SQL901N ERROR
IT05989	2	DB2 OPTIMIZER MIGHT CHOOSE SUBOPTIMAL ACCESS PLAN FOR SELECT STATEMENT WITH VALUES CLAUSE
IV77546	2	INTERMITTENT SLOW PERFORMANCE FOR QUERIES THAT REFERENCE COLUMN STORE COMMON SUBEXPRESSIONS
IT10413	2	DB2 OPTIMIZER MIGHT CHOOSE SUBOPTIMAL JUMPSCAN INDEX ACCESS PLANFOR UPDATE/DELETE STATEMENT
IT06379	2	DB2ACD MAY CAUSE LOCK WAIT DUE TO NOT RELEASING EXCLUSIVE CATALOG CACHE LOG
IT09219	2	WRONG JOING PREDICATE IN MSJOIN
IT08649	2	WHEN INTRA_PARALLEL IS ENABLED, A SQL0901N ERROR CAN BE RETURNEDWHEN COMPILING A QUERY
IT08665	2	COMPILING SQL STATEMENT WITH JOINS AND OR PREDICATES ON PARTITIONED TABLES MIGHT RETURN SQL0101N ERROR
IT06701	2	RARE MEMORY LEAK IN CATALOG CACHE WHEN RTS IS ENABLED
IT09046	2	DB2 MIGHT CRASH WHILE COMPILING A QUERY REFERENCING COLUMN-ORGANIZED TABLES AND MULTIPLE COMMON SUBEXPRESSIONS.
IT09986	2	SQL0901N "BAD IXM LISTOF" RETURNED WHEN RUNNING DB2ADVIS
IT09568	2	QUERY MAY RECEIVE A SQL0901N WITH REASON "FOUND ZERO CLOB.RESET"
IT09214	2	NUM_NULLS NOT EXTRAPOLATED FOR RUNSTATS WITH TABLE SAMPLING
IV76831	2	EXCESSIVE SUBAGENTS AND APPLICATION HEAP MEMORY USAGE WHEN RUNNING COMPLEX QUERY ACCESSING COLUMN ORGANIZED TABLES
IT10530	2	DB2 MIGHT RETURN SQL0901N WHILE COMPILING A QUERY REFERENCING COLUMN-ORGANIZED TABLES AND MULTIPLE COMMON SUBEXPRESSIONS
IT08330	2	MEMORY CORRUPTION DURING RUNSTATS 'UPDATE PROFILE' OPTION IF DUPLICATE COLUMN GROUPS ARE INVOLVED.
IT07967	2	DB2 MIGHT RETURN SQL0901N WHILE COMPILING A SQL STATEMENT THAT IS ELIGIBLE FOR ZIGZAG JOIN
IT08591	2	ORDER BY ON COLUMN NOT INCLUDED IN SELECTED COLUMNS IS NOT SHIPPED TO FEDERATED SOURCE
IT09317	2	CRASH WITH SIGNAL#8 WHEN RUNNING EXPLAIN COMMAND
IT09161	2	DB2ACD MIGHT REPORT SQL2306 DURING TABLE REORG EVALUATION
IT08254	2	DB2 MIGHT RETURN SQL0901N FOR SQL STATEMENT THAT IS ELIGIBLE FORZIGZAG JOIN
IT08458	2	NON-OPTIMAL ACCESS PLAN MIGHT BE GENERATED FOR A COMPLEX QUERY THAT PRODUCES A SQL0437W WITH RC=1
IT10953	2	ADDITIONAL FIX ON TOP OF APAR IT07926 (CARTESIAN JOIN PREDICATES)
IT11990	2	QUERY COMPILATION MAY FAIL WITH: -901 SQLNO_GET_BEST_PLAN[200] WHEN ZIGZAG JOIN (ZZJN) IS CONSIDERED
IT04607	2	TABLE CARDINALITY VARIES SIGNIFICANTLY COMPARED TO ACTUAL TABLE ROW COUNT, WHEN BOTH TABLESAMPLE AND INDEXSAMPLE IS SPECIFIED.
IT08457	2	SQL0973N ERROR RETURNED WHEN COMPILING A STAR JOIN ELIGIBLE QUERY WITH A SNOWFLAKE THAT APPLIES A SUBQUERY PREDICATE
IT08737	2	AUTOMATIC REORG FAILS WITH SQLCODE: -2205 RC 6 FOR MDC TABLE
IT08521	2	SQL0101N WHEN COMPILING QUERY WITH MANY OUTER JOINS AND GROUP BY IN DPF
IT05366	2	RUNSTATS USE PROFILE RESULTS IN TRAP WHEN PROFILE IS SET WITH ALL COLUMNS + DISTRIBUTION ON KEY COLUMNS OPTION AND WE HAVE INDEX
IT08666	2	OPTIMIZER MIGHT PRODUCE NON-OPTIMAL ACCESS PLAN IN DPF FOR QUERIES WITH MULTIPLE LOCAL EQUALITY PREDICATES
IT08069	2	AUTOMATIC REORG FAILS WITH SQL0270N FUNCTION NOT SUPPORTED (REASON CODE = "57") FOR MDC TABLE
IT06181	2	THE OPTIMIZER CHOOSES A NON-OPTIMAL TABLESCAN TO SCAN A TABLE THAT IS BOTH PARTITIONED BY RANGE AND MDC.
IT09321	2	DB2 OPTIMIZER CAN TRAP WHEN PLANNING INDEX JUMP SCAN ON RANGE PARTITIONED TABLE DEFINED WITH NULLS FIRST PARTITIONING COLUMN
IT09649	2	DB2OPTSTAT LOG FILE CAN CONTAIN INCORRECT DETAILS FOR RUNSTATS
IT07451	3	EXPLAINING A QUERY WHICH INVOLVES FGAC PROTECTED TABLES AND A UNION OPERATOR MAY RESULT IN SQL901N
IT08218	3	MEMORY LEAK IN APPLICATION HEAP WHEN RUNSTATS COMMAND WITH USE PROFILE OPTION IS EXECUTED
IT06323	3	THERE IS A CHANGE IN ACCESS PLAN, WHICH IS TRIGGERED BY THE FIX OF DEFECT WSDBU01263929. IF WE SET BUFFERS_CAP_OFF IN DB2_EXTEND
IT07444	3	DB2DIAG.LOG SHOWS SQL5192W THE ADMIN_SET_INTRA_PARALLEL PROCEDURE FAILED ERROR DUE TO DB2HMON APPLICATION.
IT08592	3	DB2 MIGHT TRAP WHILE COMPILING A QUERY WITH BIG INLIST PREDICATE
IT10131	3	SYSCAT.COLUMNS.NUMNULLS STATISTICS MIGHT BE ZERO WHEN "EXCLUDE NULL KEYS" INDEX IS EMPTY
Fix Pack 7 - Query Compiler QGM
IT09770	1	DB2 MIGHT ABEND WHEN EXECUTING QUERIES WITH COMPLEX SUBSELECTS AND EXISTENTIAL SUBQUERIES
IT11543	1	CORRELATED SUBQUERIES IN UPDATE AND DELETE OPERATIONS ON COLUMN ORGANIZED TABLES RESULT IN PERFORMANCE DEGRADATION
IT06937	1	QUERY REFERRING TO THE COMPLEX VIEWS CAN RETURN SQL101N
IT07125	1	DB2 MIGHT PERFORM POORLY FOR NOT EXISTENTIAL SUBQUERIES CONTAINING COLUMN STORE TABLES
IT10555	1	LIMIT OF 255 INCREASED TO 1012 COLUMNS FOR INLINE SQL TABLE FUNCTIONS
IT05616	1	DB2 MIGHT NOT SPLIT OLAP FUNCTIONS AND SUBQUERIES FROM CASE EXPRESSIONS
IT10590	1	DB2 SERVER HANGS WHILE RUNNING QUERY WITH TRIM OR STRIP SCALAR FUNCTION
IT07508	1	QUERY COMPILATION FAILS WITH SQLCODE SQL0007N OR SQL0198N
IT12090	2	DB2 MIGHT PRODUCE INCORRECT RESULTS WHEN RUNNING QUERIES WITH EQUALITY CHAR/VARCHAR PREDICATES
IT06188	2	901 CAN OCCUR WHEN THE STATEMENT CONTAINS A SIMPLE SCALAR SUBQUERY REFERENCE IN THE OUTPUT OF A SUB-SELECT WHICH ALSO CONTAINS A
IT07810	2	THE DB2 SERVER TERMINATES ABNORMALLY IN SQLNQ_HANDLE_MODULE_OBJ_REF WHEN CREATING A SQL ROUTINE
IT09507	2	DB2 MIGHT RETURN INCORRECT RESULT FOR QUERY WITH MULTIPLE XMLEXISTS
IT07232	2	AFTER A VIEW HAS BEEN ENABLED FOR OPTIMIZATION YOU MAY ENCOUNTERSQL0204N ERROR WHEN SELECTING FROM THE VIEW.
IT09767	2	DB2 MIGHT ABEND WHEN EXECUTING QUERY WITH 3 OR MORE XMLEXISTS
IT06710	2	-440 WITH SYS_INIT WHEN REOPT ALWAYS OR ONCE IS USED
IT08133	2	CONCAT IN ORA MODE WITH NULL CLOB TYPES WILL RETURN NULL WHEN THE OTHER VALUE IS NOT NULL
IT09409	2	SQL0901N RECEIVED ON SELECT ON COLUMNAR TABLE DURING COMPILE
IT07303	2	QUERY CONTAINING A PREDICATE REFERENCING AN XMLTABLE COLUMN IN CORRELATED QUERY BLOCK MAY FAIL WITH SQL0901 ERROR
IT06319	2	SQL0901N ERROR ON SQLNQ_QTBTBUERCHILD WHEN "INCONSISTENT QGM: NO SELECT HAVING AFTER GROUP BY"
IV69510	2	DB2 MIGHT TAKE A LONG TIME TO COMPILE A QUERY CONTAINING LARGE NUMBER OF GROUPING SETS
IT10951	2	SQL0901N ERROR MAY OCCUR WHEN THERE ARE XML PREDICATES IN THE QUERY AND XML INDEXES DEFINED ON THE TABLE.
IT08337	2	QUERY WITH OR PREDICATE MAY RETURN WRONG RESULTS IN VARCHAR2 ENABLED DATABASE ON DB2 10.5 FIX PACK 5
IT06581	2	FEDERATION: IMPORT ON NICKNAME FAILS WITH SQL27999N REASON CODE = "14".
IT07806	2	QUERIES WITH CASE WHEN USING SUBQUERIES MAY LEAD TO PERFORMANCE ISSUE.
IT07276	2	DB2 MIGHT ABEND WHEN EXECUTING QUERY WITH INLIST PREDICATES
IT08814	2	SQL0408N RETURNED TO A PL/SQL FUNCTION CALLED WITH ARRAY PARAMETER.
IT02871	2	SQL20481N ERROR CAN BE RETURNED WHEN STORED PROCEDURE MODIFIES TABLE WITH INLINED TRIGGER DEFINED
IT02858	2	QUERY WITH A MIX OF EQUALITY AND RANGE PREDICATES IS NOT FULLY SIMPLIFIED
IC99022	2	SCALAR SUBQUERIES ARE NOT PUSHED DOWN THROUGH UNION ALL LEADING TO POOR PERFORMANCE
IT08386	2	DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERY CONTAINING MULTIPLE SUB-SELECTS AND DISTINCT CLAUSE
IT07092	2	REVOKE ROLE STATEMENT FAILS WITH SQL0901N IN ORACLE COMPAT WITH "SQLRI_DDL_COMMON: UNEXPECTED SQLCODE FOR DDL!".
IT08615	2	USE OF TEMPORAL TABLES TOGETHER WITH EXISTENTIAL SUBQUERIES CAN LEAD TO SUBOPTIMAL PERFORMANCE
IT08637	2	WRONG RESULT IN ORA MODE WHEN GENERATED TWIN PRED CONTAINS CHAR WITH HEX VALUES LOWER THEN SPACE
IT08277	2	DB2 MIGHT PERFORM POORLY FOR EXISTENTIAL SUBQUERY WITH COLUMN ORGANIZED TABLES AND COMPLEX OUTER SUBSELECTS
IT07878	2	NLS_STRING_UNITS SESSION VARIABLE NOT FUNCTIONAL IN DPF MODE
IT09456	2	IMPROVE THE HANDLING FOR RECURSIVE TRIGGER
IT09584	2	DB2 MIGHT ABEND WHILE EXECUTING A QUERY WITH GROUP BY
IT04653	2	DB2 MAY RETURN SQL0901N WHEN EXECUTING QUERY CONTAINING AN EXISTENTIAL SUBQUERY WITH A UNION OPERATOR
IT09766	2	DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERY WITH SINGLE SUBTERM INLIST
IT09419	2	INCORRECT RESULT WHEN QUERY HAS LEFT OUTER JOIN AND UNION ALL
IT11230	2	INSTANCE CAN TRAP IN SQLNG_PREPARE_SUBQ_OPERATION WHEN SQL USINGNOT EXISTS CLAUSE
IT07083	2	CASE EXPRESSION SIMPLIFICATION IN QUERY REWRITE
IT07976	2	SQL101N MAY BE RETURNED WHEN SPECIAL REGISTER IS REFERENCED MANYTIMES IN THE SAME EXPRESSION IN THE SELECT LIST OR IN THE WHEN
IT06857	2	REDUNDANT JOINS MIGHT NOT BEING PRUNED WITH A SELF JOIN QUERY ONVIEW
IT07051	2	DB2 MIGHT PRODUCE ABEND OR PRODUCE SQL0901N WHEN EXECUTING A RECURSIVE QUERY WITH A JOIN ON EXPRESSIONS
IT08490	2	COMPLEX QUERIES REFERENCING COLUMN ORGANIZED TABLES MAY EXPERIENCE SLOW PREPARE TIME
IT10949	2	DB2 SERVER TERMINATES ABNORMALLY EXECUTING DDL STATEMENT ON VERSION
IT11793	2	DB2 MIGHT PRODUCE INCORRECT RESULTS WHEN ELIMINATING CORRELATED SCALAR SUBQUERY
IT08650	2	DB2 MIGHT TRAP WHEN EXECUTING QUERY WITH COLUMN BASED ACCESS CONTROL
IT08268	2	DB2 MIGHT PERFORM POORLY FOR SUBQUERY CONTAINING CORRELATED SELECT LIST EXPRESSIONS AND COLUMN ORGANIZED TABLES
IT05865	2	UNREFERENCED UDF IN A CSE CAN LEAD TO DB2 ABEND
IT10858	2	IMPROVE DB2 PERFORMANCE FOR CORRELATED SCALAR SUBQUERIES WITH AGGREGATION
IT10683	3	DB2 MIGHT PRODUCE A SUB-OPTIMAL PLAN FOR QUERY HAVING EXISTS WITH OR ON LOCAL PREDICATE AND SUBQUERY
IT06840	3	SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY PROCEDURE AFFECTS REGULAR TABLES THAT ARE DEFINED WITH GENERATED COLUMNS
IT05005	3	FEDERATED SERVER CAN CRASH WHEN SQLNN_ADJUST_LIST CALLS MEMCPY AND USING 3-PART NAME
IT10563	3	DB2 MIGHT PRODUCE A SUB-OPTIMAL PLAN FOR QUERY WITH GROUP BY OVER NULL CONSTANT
IT10012	3	SQLCODE -302 IS RETURNED DURING STATIC SQL EXECUTION INSTEAD OF BIND/REBIND
IT10763	3	DB2 SHOULD ELIMINATE REDUNDANT CORRELATED PREDICATES (SINGLE-LEVEL)
IT05986	3	INCORRECT RESULT WHEN USING A WITH CLAUSE CONTAINING A FETCH FIRST N ROWS CLAUSE
IT01998	3	INDIRECT JOIN PREDICATE PUSHDOWN EVALUATION FOR >1 INDIRECTION LEVELS
IT09416	3	QUERY MIGHT RETURN INCORRECTLY SORTED ROWS.
IT02854	4	CREATION OF A VIEW MIGHT RESULT IN SQL0973N ERROR
Fix Pack 7 - Relational Data Services
IT06716	2	A PURESCALE MEMBER MIGHT TRAP IN MON_GET_UNIT_OF_WORK PROCESSINGWHILE ANOTHER MEMBER IS STOPPING
IT09151	2	IN DPF ENVIRONMENTS THE DB2DIAG.LOG FILE CAN GET FLOODED WITH SQLZ_RC_INTR ERRORS REPORTED BY FUNCTION SQLRKRPC_NL
IT09268	2	CATALOG LOCKS ACQUIRED DURING COMPILATION MAY NOT GET RELEASED UPON COMPILATION COMPLETES DUE TO NESTED COMPILATION
IT10121	2	DB2 FAILS TO REINITIALIZE THE PL/SQL PACKAGE AFTER RECOMPILATIONOF THE PACKAGE BODY IN AN ORACLE COMPATIBLE DATABASE.
IT09681	2	THE ERROR SQL0101N MIGHT BE RETURNED DURING REBIND PROCESSING AFTER UPGRADE OF DB2 SERVER.
IT05358	2	INSTANCE CRASH IN DB2PCSD
IT06197	2	DB2 IS FORCED SHUTDOWN WHEN IT ATTEMPTS TO END A NON-EXIST SAVE POINT
IT10776	2	WLM SQLTEMPSPACE THRESHOLD VALUE INCORRECTLY REPORTED AS EXCEEDED
IT09087	2	-727 SQL ERROR WHEN "PREPANONBLOCK" EDU TRIGGERS A LOCK CONFLICTAND DEADLOCK WITH THE ORIGINAL EDU
IT09273	2	DB2DIAG.LOG CAN BE FLOODED WITH SQLP_NOTA "TRANSACTION WAS NOT FOUND"
IT09180	2	POSSIBLE SEGV (CRASH/ABORT) IN SQLRA_GET_SECT_INFO_BY_CURSOR_NAME() WHEN REBINDING A PROGRAM CALLING A STORED PROCEDURE
IT09300	2	ENABLE EXTENDED INDICATOR AND REOPT ALWAYS MAY CAUSE INSTANCE CRASH
IT06569	2	DB2 MIGHT CRASH DURING CATALOG MIGRATION WHEN PROCESSING MQT ENTRY IN THE SYSTABLES
IT09249	2	SEVERE PERFORMANCE DEGRADATION AFTER OUT OF MEMORY ERROR WHEN DB2_SQLWORKSPACE_CACHE IS SET
IT06610	2	STATIC SQL APPLICATIONS RUNNING IN A UNEQUAL CODEPAGE ENVIRONMENTS MAY RETURN ERROR SQL0302N
IT06593	3	TRANSACTIONS WITH A FAILING DECLARE GLOBAL TEMPORARY TABLE STATEMENT AND A DYNAMIC COMPOUND STATEMENT MAY FAIL WITH -901 SQLCODE
IT08494	3	THRESHOLD TOTALMEMBERCONNECTIONS IS ENFORCED FOR USERS WITH DBADM OR WLMADM AUTHORITY.
IT07996	3	DB2PD -ACTIVE CAN SHOW "ENTRYTIME" FOR A STATEMENT TO BE MUCH SOONER THEN IT SHOULD BE
IT05397	4	UNCLEAR ERROR REPORTED IN CASE OF FAILURE DUE TO INVALID TSA LICENSE IN A PURESCALE ENVIRONMENT
Fix Pack 7 - Routine Infrastructure
IT08198	2	DB2PD -FMP SHOWS INCORRECT FORCEDTHRD VALUE
IT08496	2	CALLING SQLJ.DB2_INSTALL_JAR MAY RETURN SQL0311N
IT05206	2	DB2_FMP_COMM_HEAPSZ DOES NOT PROPERLY SET FMP HEAP/SET SIZE FOR VALUES < 256MB
IT06218	3	PROBLEM FIXED VIA IT00786 CAN STILL OCCUR FOR OTHER ROUTINE TYPES.
IT10769	3	EXECUTION OF EXTERNAL THREADSAFE ROUTINES MAY LEAD TO DB2 CRASH DUE TO MEMORY CORRUPTION.
IT11062	3	UDF'S GETTING ARGUMENTS ON FINAL CALL CAUSING DB2 TO CRASH ON FUNCTION <__INTEL_NEW_MEMCPY>
IT09499	3	SQL ERROR IN AUTOMOUS PROCEDURE CAUSES "SQLCA HAS ALREADY BEEN BUILT" MESSAGES IN DB2DIAG.LOG
Fix Pack 7 - Security
IT08753	1	SECURITY: LOCAL ESCALATION OF PRIVILEGE VULNERABILITY IN DB2(CVE-2015-1947)
IT09900	1	SECURITY: GSKIT IS AFFECTED BY SECURITY VULNERABILITIES (CVE-2015-1788)
IT06801	1	CRASH IN SQLEX_FIND_GROUP WHEN CUMULATIVE LENGTH OF GROUP NAMES RETURNED FOR AN USER ID IS GREATER THEN 64K
IT10767	1	DB2 KEEPS TRYING TO REACH THE DEMOTED DOMAIN CONTROLLER AND THE CONNECTION MAY FAIL WITH SQL1060N, SQL0551N OR SQL1092N ERRORS.
IT08689	2	DB2DIAG.LOG FILE CAN GET FLOODED WITH SQLEXENGVALIDATESECMEC, PROBE:350 MESSAGES
IT04965	2	RESTORE_DB AUDIT EVENT NOT GENERATED FOR DATABASE LEVEL AUDITING.
IT11648	2	DB2 WITH LDAP SECURITY PLUGIN-IN ENABLED ON SUN SPARC MAY FAIL WITH CONNECTION ERROR DUE TO IMPROPER SSL_KEYFILE SPECIFIED
IT11627	2	PRIVATE MEMORY LEAK DUE TO AUDIT FOR EXECUTE CATEGORY.
IT08858	2	LOAD/IMPORT REPLACE INTO A TABLE WITH LBAC/RCAC REQUIRES CONTROL/DBADM AUTHORITY
IT08320	3	NATIVE ENCRYPTION: COMPRESS BACKUP PRODUCES COMPRESS_INTERNAL FAILED:RC 100 IN DB2DIAG.LOG.
Fix Pack 7 - Text Search
IT11882	1	TEXT SEARCH MIGRATION IS FAILING DURING DB2 MIGRATION FROM VERSION 9.7 TO 10.5
IT09227	2	THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000
IT06132	2	ERRORS SUCH AS SQL20427N USING DB2 TEXT SEARCH IF THE APPLICATION CODE PAGE IS NOT UTF-8.
IT05813	2	LOAD/IMPORT REPLACE INTO A TABLE WITH LBAC/RCAC REQUIRES CONTROL/DBADM AUTHORITY
IC97846	3	DB2VAL ERRONEOUSLY REPORTS THAT THE NET SEARCH EXTENDER FILES ARE MISSING.
IT07128	3	AN INITIAL UPDATE OF TEXT INDEX ALWAYS REPORTS CTE0360 ERROR IN DB2DIAG.LOG.
Fix Pack 7 - XML
IT09255	1	SELECTING AN XML COLUMN MIGHT HANG OR ERROR OUT WITH AN OUT OF MEMORY CONDITION IF THE XML TEXT FOR ONE ELMNT IS LARGER THAN 64K
IT11131	1	POSSIBLE CRASH IN XMNVBUFFER::FILLRESULTBUFFER
IT05753	1	APPLICATION HUNG DOING INSERT/SELECT ON TABLE WITH XML COLUMNS AND COMPRESS YES
IT08611	2	UNDER RARE CONDITIONS RUNNING AN SQL WHICH USE XML COLUMN CAN RESULT IN A CRASH/TRAP.
IT07015	2	SEGMENTATION FAULT DURING XML QUERY "REPLACE" PROCESSING WHEN MATCHING EXTENSIVE NUMBER OF TOKENS
Fix Pack 7 - pureScale Services
IT10886	1	IN A PURESCALE ENVIRONMENT, A DB2 MEMBER MAY CRASH FOLLOWING SUCCESSIVE CLUSTER FAILURES(ALERTS).
IT06026	2	ON RHEL 6, THE DB2FMCU COMMAND CREATES THE /ETC/INIT/DB2FMCD.CONF FILE BUT DOES NOT EXPLICITLY START/STOP THE DB2FMCD SERVICE.
IT09278	2	RUNNING DB2HAICU IN XML MODE TO SETUP A SECOND HADR DATABASE FORHIGH AVAILABILITY RETURNS AN ERROR
IT08947	2	NEED TO CLEAR PGRP MONITOR OVERRIDE FLAGS ON REMOTE HOSTS AS PART OF DB2CLUSTER -CLEAR -ALERT
IT09561	2	IN AN AUTOMATED(TSA) HADR ENVIRONMENT, A FAILURE TO THE PUBLIC ADAPTER ON THE STANDBY HADR SERVER CAUSES DB2 TO BE STOPPED
IT10256	2	DB2 PURESCALE: RSCT APAR IV74148: BACKLEVEL RESOURCE MANAGERS MAY HANG UNDER ERROR CONDITIONS
IT10905	2	DB2HAICU MAINTENANCE MOVE OPTION ISSUES A "TAKEOVER BY FORCE PEER WINDOW ONLY" INSTEAD OF A GRACEFUL TAKEOVER
IT09859	2	MOUNTV105_MONITOR.KSH SCRIPT IS ERRONEOUSLY REPORTING THE MOUNT RESOURCE AS "FAILED OFFLINE" INSTEAD OF "OFFLINE".
IT10602	2	THE OLD PRIMARY DATABASE MAY NOT AUTOMATICALLY REINTEGRATE AS THE STANDBY AFTER RUNNING THE DB2HAICU MAINTENANCE MOVE OPTION.
IT07145	2	IN A HADR HA(TSA) ENVIRONMENT, IN THE EVENT OF A PRIMARY SERVER FAILURE, THERE MAY BE A DELAY IN REINTEGRATING THE DB AS STANDBY
IT11109	2	ENHANCE LOGGING INFORMATION WITHIN THE PURESCALE DB2 MONITOR CODE PATHS
IT08004	2	IN A HADR HA(TSA) ENVIRONMENT, IN THE EVENT OF A PRIMARY SERVER FAILURE, THE STANDBY MAY NOT BE REINTEGRATED ON INSTANCE STARTUP
IT06888	2	THE "OBJECT CREATION FAILED" ERROR DURING DB2HAICU PROCESSING IN THE MAINTENANCE MODE
IT09204	2	IN A TSA AUTOMATED HADR ENVIRONMENT, AN AUTOMATED HADR FAILOVER OCCURS IMMEDIATELY AFTER A MANUAL TAKEOVER HADR COMMAND IS RUN
IT06470	2	ENHANCED-CAPABLE(EC) VG'S CAN REMAIN VARIED-ON IN READ-WRITE MODE ON THE STANDBY NODE.
IT09541	2	DB2 PURESCALE: RSCT APAR IV68484 TB_BREAK ROUTINE CAN REPORT FALSE FAILURE ON LINUX
IT05808	2	IN AN AUTOMATED(TSA) HADR ENVIRONMENT, DATABASE APPLICATIONS/CONNECTIONS RECEIVE SQL1224N ERROR WHILE AUTOMATION IS DISABLED
IT09301	2	IN A HADR/TSA ENVIRONMENT, TSA MAY UNEXPECTEDLY FAILBACK THE HADR DATABASE FOLLOWING A MANUAL TAKEOVER
IT09134	2	SHORTEN THE TIME REQUIRED TO UPDATE THE IN-MEMORY COPY OF THE ADAPTER STATUS
IT11114	2	PURESCALE GPFS MOUNT RESOURCE MAY ERRONEOUSLY REPORT AS STUCK ONLINE INSTEAD OF ONLINE IN THE LSSAM OUTPUT
IT08146	2	DB2HAICU MAY FAIL WHEN USING XML INPUT FILE DUE TO HOSTNAME LENGTH BEING 8 CHARACTERS OR MORE
IT04666	2	LOGPATH, MIRRORLOGPATH, SPM PATH AND AUDIT PATH SHOULD NOT BE MONITORED IN PURESCALE
IT07396	2	DURING AN AUTOMATED PARTITION STOP, THE DB2GCF STOP COMMAND TIMES OUT LEADING TO THE INSTANCE BEING KILLED PREMATURELY
IV73358	2	THE 'DB2CLUSTER -CM -DELETE -RESOURCES' COMMAND MAY FAIL IF A HOSTNAME CONTAINS THE 'CF' OR 'MEMBER' SUBSTRING
IT09675	2	THE "DB2CLUSTER -CFS -VERIFY -MAINTENANCE" COMMAND HANGS IF DEBUG=1 IS SET
IT09951	2	NO AUTOMATION ACTION IS TAKEN IF THE PRIMARY HADR DATABASE CRASHES WITH SQLCODE SQL1034C
IV67580	2	MEMBER NETNAME CHANGED TO BE SAME AS CF AFTER KILL MEMBER IF MEMBER AND CF ARE CO-LOCATED AND CF HAS DIFFERENT SET OFNETNA
IT10688	2	REMOVING DATABASE MOUNTS USING DB2CLUSTER COMMAND FAILS WITH SQL1032N ERROR
IT08584	2	PURESCALE CLEANUP COULD FAIL IF PGRP FILES HAVE 0 BYTES FILE SIZE
IV67019	2	RESTART LIGHT CANNOT SUCCEED IF THE HCA INFORMATION IN HA REGISTRY AND "ISONLINE" FILE ARE OUT OF SYNC
IT08308	2	IN AN AUTOMATED HADR ENVIRONMENT, FOLLOWING A REBOOT OF THE STANDBY SERVER, THE DATABASE MAY NOT BE REINTEGRATED AS THE STANDBY
IT09418	3	DB2START MAY HANG AND LEAD TO GROUP RESTART IN PURESCALE BECAUSEOF NO PROPER TIMEOUT BEFORE CALLING TSA COMMANDS
IT05398	3	RSCT WILL NOT NOTIFY DB2 THAT THE PORT IS DOWN WHEN WE MOVE THAT PORT TO ANOTHER DIFFERENT VLAN
IT08690	3	RELAX CLUSTER COMMUNICATION GROUP SETTINGS IN A TSA/HADR ENVIRONMENT CONFIGURED USING DB2HAICU
IT08253	3	CHANGES IN THE MOUNT AUTOMATION SCRIPTS TO SUPPORT MOUNTS BASED ON VG'S WITH THE MULTI-NODE VARYON PROTECTION FEATURE ENABLED.
IT07975	3	REDUCE SEVERITY OF DB2DIAG MESSAGES WHEN DISABLING FAULT MONITORING(FM) VIA DB2FM FOR AN INSTANCE THAT DOES NOT HAVE FM ENABLED
IT09494	3	EVENT MESSAGES FROM SAL_MANAGEMENTSTRUCTUDFOPINTERNAL MIGHT FILLDB2DIAG.LOG.

DB2 Version 10.5 Fix Pack 6
APAR	Sev.	Abstract
Fix Pack 6 - 1
IT05478	2	SQL0180N IS RETURNED WHEN QUERY HAS TIMESTAMP FUNCTION OVER HOST VARIABLE
Fix Pack 6 - Administration Tools
IT08075	2	SECURITY: DB2 CONTAINS A FILE DISCLOSURE VULNERABILITY IN THE DATABASE AUTOMATED MAINTENANCE FEATURE (CVE-2015-1883)
Fix Pack 6 - Buffer Pool Services
IT06543	1	DB2 PANICS WHEN RELEASING CASTOUT LOCKS
IV71596	2	MEMBER CRASH RECOVERY MEMORY TUNING
Fix Pack 6 - Build Team
IV72020	2	CASTOUT ENGINE KEEPS DOING "CASTOUT" WORK EVEN THOUGH THERE IS NO WORKLOAD FOR A LONG TIME
Fix Pack 6 - CDE Data
IT06499	2	INCONSISTENT RUNTIME FOR QUERY ON COLUMN ORGANIZED TABLES
Fix Pack 6 - CDE Query
IT07268	2	INCORRECT RUNTIME STQ STATISTICS WITH DB2TRC -M CDE_PERF_TRACE
IV72220	2	DB2 BLU MAY CRASH WITH LATCH CONFLICT
Fix Pack 6 - Client Interfaces
IT05796	1	CLI APPLICATION USING CHAINING WITH INSERT BUFFERING MAY GET SQL_SUCCESS BUT SQLROWCOUNT() GIVES 0.
IT06494	2	DB2CFEXP MAY NOT PRODUCE CORRECT OUTPUT OR MAY TERMINATE WITH SQL5062N ERROR.
Fix Pack 6 - Codegen and Runtime
IT08656	1	SECURITY: DB2 LUW CONTAINS A VULNERABILITY IN SCALAR FUNCTION THAT MAY CAUSE DB2 SERVER TO TERMINATE ABNORMALLY (CVE-2015-1935)
IT06279	2	HSJOIN ON SMP PARALLEL ENVIRONMENT MAY HANG INTERMITTENTLY
IT07998	2	INCORRECT RESULTS WITH CDE MERGE AND ISCAN
IT07392	2	IN RARE SCENARIOS COMPLEX QUERY WITH AN OLAP SPECIFICATION AND ASUBQUERY MIGHT RETURN EXTRA ROWS
IT07109	2	SECURITY: DB2 TRAPS WHEN EXECUTING A SPECIALLY-CRAFTED SQL STATEMENT WITH SCALAR FUNCTIONS (CVE-2015-0157)
Fix Pack 6 - DRDA Services
IT03502	2	WLB ENABLED JCC CLIENTS CONNECTING TO PURESCALE SERVERS HAVE LATENCY ON ALL SUBSEQUENT QUERIES AFTER "HALT -Q" ON ONE MEMBER
Fix Pack 6 - Data Management Services
IT09018	1	HADR STANDBY LOG REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO SQLB_BAD_PAGE
IT06433	2	SLOW LOG REPLAY ON STANDBY DATABASE
IT08344	2	HADR REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO SQLB_BAD_PAGE
IT06490	2	ROW MAY BE CORRUPTED IF IT IS MOVED BY INPLACE REORG, A PAGE DICTIONARY IS RECREATED AND THE MOVE OF THE ROW IS ROLLED BACK.
IT07465	2	ROWS COULD BE OVERWRITTEN ON DATA PAGE IF INPLACE REORG UNLATCHED THEN RELATCHED A PAGE DUE TO A PAGE LATCH CONFLICT
IT06853	2	DB2 MAY FAIL TO MOVE TABLE INTO NOT_SHARED STATE
Fix Pack 6 - Data Management Utilities
IT09073	1	INCORRECT RESULTS FROM SORT OPERATIONS ON DB2 VERSION 10.5.0.5
IT07165	2	LOAD FAILS WHEN INPUT LOB FILE IS LARGER THAN 4GB
IT06049	2	NEW LOGGING MECHANISM CAUSE REMOTE LOAD PERFORMANCE PROBLEM
Fix Pack 6 - Data Recovery Services
IT07968	2	IN SPECIFIC TIMING CONDITIONS, DB2READLOG API CALLS (USED E.G BYCDC) MIGHT RESULT IN LOGS BEING LEFT IN ACTIVE LOG PATH.
IV68867	2	THE LOCK REBUILD PERFORMANCE IN RESTART LIGHT MODE MAY BE VERY POOR AND UNPREDICTABLE
IT07041	2	INCREMENTAL BACKUP MAY FAIL WITH SQL2048N
IT07405	2	THE SKIPPED LOG RECORD DATA MAY BE RETURNED ON THE SUBSEQUENT RETRY OF THE DB2READLOG API WITH EARLIER LFS NUMBER
IV68866	2	RESTART LIGHT MAY ENCOUNTER HANG ISSUE IN LOCK REBUILD PHASE
Fix Pack 6 - Index Manager
IT07050	2	DB2 MIGHT TRAP WHILE COLLECTING STATISTICS FOR INDEXES
Fix Pack 6 - Install and Catalog Services
IT08113	1	SECURITY: DB2 IS AFFECTED BY MULTIPLE SECURITY VULNERABILITIES IN GPFS (CVE-2015-0197, CVE-2015-0198, CVE-2015-0199)
IT06667	2	DB2CKUPGRADE UTILITY FAILS WITH "SQL1344N ORPHAN ROWS FOUND IN THE SYSTEM CATALOGS".
IV68351	2	DB2IUPDT TRIGGERED APPLYING ESE BASE LICENSE UNEXPECTEDLY AND RESULT IN LICENSE INFORMATION LOST IN PURESCALE ENVIRONMENT
Fix Pack 6 - Monitoring
IT08439	1	DB2SAP: MEMORY LEAK IN SAPTOOLS.MEMORY_TABLE
IT07533	2	DB2SAP: ADD SAPTOOLS.UPPER/LOWER
Fix Pack 6 - Problem Determination
IT07256	2	DB2SUPPORT FAILED TO COLLECT DATA FOR SYNOPSIS TABLES IF THE TABLES INVOLVED CONTAIN '/' IN THE TABLE NAME
Fix Pack 6 - Query Compiler Optimizer
IT07456	1	JITS MAY CAUSE OTHER APPLICATIONS IN LOCK WAIT OR LOCK TIME STATE FOR COLUMN ORGANIZED TABLES.
IT04607	2	TABLE CARDINALITY VARIES SIGNIFICANTLY COMPARED TO ACTUAL TABLE ROW COUNT, WHEN BOTH TABLESAMPLE AND INDEXSAMPLE IS SPECIFIED.
IT07926	2	PERFORMANCE MAY BE POOR FOR QUERIES INVOLVING COLUMN ORGANIZED TABLE THAT ARE REFERENCED BY CARTESIAN JOIN PREDICATES
Fix Pack 6 - Query Compiler QGM
IT07125	1	DB2 MIGHT PERFORM POORLY FOR NOT EXISTENTIAL SUBQUERIES CONTAINING COLUMN STORE TABLES
IT07861	1	CORRELATED EXISTENTIAL SUBQUERIES MIGHT BE DEPICT SLOW PERFORMANCE
IT08490	2	COMPLEX QUERIES REFERENCING COLUMN ORGANIZED TABLES MAY EXPERIENCE SLOW PREPARE TIME
IT07403	2	SELECT ON XML USING FN:UPPER-CASE & TABLE HAS AN INDEX CAN RETURN INCORRECT RESULTS
IT08680	2	SYSIBM.LEFT & SYSIBM.RIGHT MAY RETURN SQL0138N WHEN THE LENGTH CONSTANT EXPRESSED IN STRING UNITS EXCEEDS STRING LENGTH
IT06188	2	901 CAN OCCUR WHEN THE STATEMENT CONTAINS A SIMPLE SCALAR SUBQUERY REFERENCE IN THE OUTPUT OF A SUB-SELECT WHICH ALSO CONTAINS A
Fix Pack 6 - Security
IT08537	1	SECURITY: VULNERABILITY IN RC4 STREAM CIPHER AFFECTS IBMÃ‚ © DB2Ã‚ © LUW (CVE-2015-2808)
IT07635	1	SECURITY: VULNERABILITIES IN GSKIT AFFECT IBM DB2 LUW (CVE-2015-0138)
IT08526	2	SECURITY: DB2 USER CAN DELETE TABLE DATA WITHOUT APPROPRIATE PRIVILEGES (CVE-2015-1922)
IT07554	2	SECURITY: DB2 CONTAINS A SENSITIVE INFORMATION EXPOSURE VULNERABILITY IN THE MONITORING AND AUDIT FEATURE (CVE-2014-0919)
IT06351	2	SECURITY: TLS PADDING VULNERABILITY AFFECTS IBMÃ‚ © DB2Ã‚ © LUW (CVE-2014-8730)
IT08289	3	PRIVATE MEMORY LEAK DUE TO NATIVE ENCRYPTION.
Fix Pack 6 - XML
IT06353	2	SECURITY: IBM DB2 CONTAINS A FILE DISCLOSURE VULNERABILITY USINGA SELECT STATEMENT WITH XML/XSLT FUNCTION (CVE-2014-8910)
Fix Pack 6 - pureScale Services
IT08870	2	LOCK_MISMATCH;NAME_NOTFOUND,INVALID_COSTATE NOT EXPECTED UNLESS PERFORMING COMM-ERROR RETRY
IV67580	2	MEMBER NETNAME CHANGED TO BE SAME AS CF AFTER KILL MEMBER IF MEMBER AND CF ARE CO-LOCATED AND CF HAS DIFFERENT SET OFNETNA

DB2 Version 10.5 Fix Pack 5
APAR	Sev.	Abstract
Fix Pack 5 - 1
IT04630	2	AN EMBEDDED SQL APPLICATION USING POSITIONED CURSOR MIGHT DUMP CORE IF OPM EI IS ENABLED
Fix Pack 5 - Administration Server
IT03589	2	AFTER UPGRADING DAS TO DB2 9.7 FP9, EXECUTING A TASK WITH 'RUN NOW' FAILS
IT03588	2	THE DB2 ADMINISTRATION SERVER FAILS TO DISCOVER DATABASES BELONGING TO AN INSTANCE
Fix Pack 5 - Administration Tools
IC99727	2	CALL SYSPROC.AUTOMAINT_SET_POLICY() TO SET A NEW AUTO_REORG POLICY MAY RETURN SQL1437N - 'UNTERMINATED END TAG' DB2AUTOREORG
IT02269	2	DB2BATCH CHANGED THE HEADER OUTPUT
IT01912	2	DB2LOOK MIGHT SEGV (COREDUMP) IF A TABLESPACE CONTAINS MORE THAN30 STRIPES
IT01337	3	RUNNING DB2LOOK WITH "-CT" OPTIONS DOES NOT PRODUCE "SET SCHEMA"OR "SET PATH" TYPE STATEMENTS.
IT03178	3	DB2LOOK WITH -CT CANNOT ORDER CONSTRAINT DDLS BY CREATION TIME, AS TABLE CONSTRAINTS DONNOT KEEP CREATION TIME IN CATALOG VIEW
Fix Pack 5 - Buffer Pool Services
IT03662	2	DB2 INSPECT INCORRECTLY REPORTS EMP PAGE ERRORS FOR LARGE LOB TABLES
IT04393	2	DB2 MIGHT CRASH IN SQLBUNCHAINBPDFROMBUCKET WITH SEGV
IT02602	2	ALTER TABLESPACE REDUCE MAX CAN FAIL WITH EFBIG (27) "FILE TOO LARGE"
IT03889	2	SQLBLOCKALLDIRS, PROBE:910 IS REPORTED AS ERROR IN DB2DIAG.LOG FILE, SHOULD BE REPORTED AS WARNING INSTEAD
IT03998	2	DB2INSPECT FAILS WITH SQL1143N ERROR BECAUSE A FILE ERROR OCCURED, MISSING FODC DIRECTORY.
IT03970	2	PERFORMING MEMBER CRASH RECOVERY IN PURESCALE WITH EHL ENABLED MIGHT CORRUPT THE TABLE IN CERTAIN SITUATIONS
IT00927	3	DIRTY LIST LATCH CONTENTION DROPPING TEMP TABLES AT COMMIT CREATED BY XML PROCESSING
IT03906	3	CREATING A TABLESPACE IN A PARTITIONED ENVIRONMENT WITH $[NUMBER]N PARTITION EXPRESSION FOR STORAGE PATH WILL RESULT IN SQL0294N
IC99984	3	REDIRECTED RESTORE MAY CAUSE EACCES (13) "PERMISSION DENIED" ERRORS
IT02264	3	DB2RELOCATEDB COMMAND MAY SET INCORRECT PATH FOR LOGARCHMETH1 AND LOGARCHMETH2
IT02446	3	ADDING A PARTITION TO AN EXISTING BUFFERPOOL MAY NOT COPY ALL THE BUFFERPOOL INFORMATION TO THE NEW PARTITION
Fix Pack 5 - Build Team
IT05933	1	DB2 LIST DCS APPLICATION EXTENDED FAILS TO DISPLAY THE COMPLETE IP ADDRESS FOR "CLIENT NODE"
IT04363	2	BLU LOAD TEMPORARY FILES ARE NOT CLEANED UP PROPERLY WHEN LOAD FAILS.
Fix Pack 5 - CDE Data
IT05424	2	SOME UPDATE STATEMENTS ON COLUMN-ORGANIZED TABLES MAY UPDATE THESAME ROWS TWICE
IV65737	2	LOCK ESCALATION FAILS WITHOUT WARNING ON COLUMN-ORGANIZED TABLE
IT04435	2	UPDATE OR DELETE ON COLUMNAR TABLE MAY FAIL WITH SQL0901N (REASON "CANNOT FIND HEADER".)
IV64730	2	SOME I/U/D ACTIVITY AGAINST BLU TABLES CAN FILL UP LOG SPACE.
Fix Pack 5 - CDE Query
IT05613	1	SQL0901 ERROR (UNEXPECTED ERROR AT SQLERRORSANDWARNINGS.CPP) FROM COLUMN-ORGANIZED TABLE WITH CASE STATEMENT
IT04426	1	"<TIMESTAMP_COLUMN> + <DECIMAL_COLUMN> SECONDS" MIGHT PRODUCE INCORRECT RESULTS IN COLUMN-ORGANIZED TABLES
IT03844	2	TRAP IN MERGESPILLEDEARLYMERGEDHTSTOGHT WHEN RUNNING A QUERY AGAINST A COLUMN ORGANIZED TABLE.
IT04843	2	QUERY AGAINST CDE TABLE(S) COULD HANG ON DB2 V10.5 FP4
IT04307	2	INCORRECT RESULTS FROM A COLUMN-ORGANIZED TABLE WHEN OPERATIONS INCLUDE NEGATIVE FLOAT/DOUBLE VALUES AND A RESULT OF ZERO
Fix Pack 5 - Client Interfaces
IT02996	1	CLI APPLICATION MAY CRASH IN CLI_SQLDISCONNECT WHEN ACCESSING DATABASE CONNECTION HANDLES IN A MULTI-THREADED PROCESS
IT03433	2	ROW NUMBER 1 RETURNED ALWAIS AS ROW IN ERROR WHEN DURING CHAINEDINSERT ERROR CLI0113E GOT REPORTED FOR ANY ROW
IT01970	2	DB2 SHOULD NOT ABEND IN SQLAK_CALLBDRDAINPUT() AFTER AN OUT OF MEMORY CONDITION
IT03986	2	WHEN LIKE CLAUSE IS USED IN SELECT STATEMENT, AND VALUE FOR LIKECLAUSE APPEARS IN THE STATEMENT AGAIN, SQL0206N MIGHT OCCUR
IT01870	2	PERFORMING 'UPDATE' THROUGH ENTITY FRAMEWORK RESULTS IN 'SQL0104N ' ERROR WITH LOGICAL TABLES IN IBM I DATABASE SERVER
IT04388	2	PARAMETER SUBSTITUTION WORKS FINE FOR SQLS, BUT NOT FOR LOAD/EXPORT/IMPORT COMMAND
IT03916	2	AFTER SQLPUTDATA IS CALLED, CALLING SQLPARAMDATA FOR THE SAME STATEMENT FAILS WITH ERROR CLI0125E
IT04353	2	CLPPLUS FAILS WITH "DB250101E" ERROR WHEN USING SPOOL COMMAND.
IT02754	2	STORED PROCEDURE EXECUTION RETURNS ERROR SQL20440N WHEN ARGUMENTS ARE SPECIAL REGISTERS AND ARRAY
IT04616	2	IBM DATABASE ADD-INS FOR VISUAL STUDIO TO CONNECT TO DB2 FOR Z SHOWS DM TYPE AS "NOT SUPPORTED" AND DB TYPE AS BLANK
IT03281	2	CALLING SQLGETCONNECTATTR FOR SQL_ATTR_GET_LATEST_MEMBER_NAME FAILS IF SQL_ATTR_OVERRIDE_PRIMARY_AFFINITY IS SET
IT04126	2	FOR SQLFETCH() RGBVALUE IN CLI TRACE IS TRUNCATED WHEN USING DB2TRC -CLI OPTION
IT03246	2	EMPTY DATABASE CATALOG ENTRY WHEN USING DB2CFIMP
IT03147	3	UTF-32 SUPPORT IN OCILOBWRITE
IT04053	3	DB2CFEXP TOOL EXPORTS THE REMOTE DB2 CATALOG WITH AUTHENTICATION=SERVER_ENCRYPT_AES AS AUTHENTICATION=NOTSPEC
IT02149	3	STARTING THE DB2 SERVICE USING NET START WILL NOT UPDATE SYSADM/SYSCTRL/SYSMAINT/SYSMON_GROUP PARAMETERS
IT00448	3	USE JAVA_HOME IF IT IS EXPORTED WHEN DETERMINING WHICH JVM TO USE WHEN RUNNING CLPPLUS.
IT02976	3	ABEND IN SQLAK_CALLBDRDAINPUT DUE TO MISALIGNED MEMORY ACCESS, LEADING TO SIGBUS SIGNAL
IT03142	3	DB2CLI EXECUTABLE HANGS WHILE USING -EXECSQL OPTION WITH A STMT IN THE FILE WHOSE LENGTH EXCEEDS 64K
Fix Pack 5 - Codegen and Runtime
IT05009	1	SEVERE MEMORY LEAK IN DATABASE MEMORY ON DB2 10.5 FIX PACK 4 IN DPF ENVIRONMENTS WITH INTRAPARTITION PARALLELISM ENABLED
IT00943	1	SIGNAL #11 CRASH/TRAP DURING THE COMPILE OF A QUERY WITH NLJN ONTHE LEFT SIDE OF A HSJN
IT03326	2	DB2 LOOP IN SQLEML_UTL_TCP_READ_LINE
IT00343	2	INSERT OF NULL INTO XML COLUMN FAILS WITH SQL16132 WHEN STREAMPUTDATA ENABLED
IT03173	2	PARALLEL-ENABLED QUERY EXECUTION MAY ALLOCATE EXCESSIVE APPLICATION HEAP MEMORY FOR REBAL OPERATOR
IT03041	2	SIGSEGV AT SQLRR_RESUME_INVOCATION
IT05898	2	WRONG RESULTS RECEIVED FOR A QUERY DUE TO INCORRECT INTERNAL COLUMN STRUCTURES
IT02771	2	CRASH DUE TO MEMORY CORRUPTION DURING PARALLEL HSJN
IT00665	2	"CLI0111E NUMERIC VALUE OUT OF RANGE" IF THE LENGTH OF THE DECFLOAT DATA IS LONGER THAN 31 DIGITS
IT04632	2	DB2 V10.5 INSTANCE MAY TRAP WITH SIGNAL#11 IN CDEADDCACHESTATS ON MPP WHEN INTRA_PARALLEL IS ENABLED.
IT03422	2	SQL0901 MAY BE RETURNED FOR A QUERY WITH ZIG ZAG JOIN
IT01255	2	FORCED DATABASE SHUTDOWN WHEN RUNNING SELECT WITH XML2CLOB FUNCTION
IT02275	2	LPAD() AND RPAD() FUNCTION WITH EMPTY STRING CAUSES THE RESULT STRING TO BE PADDED WITH '00' CHARACTERS
IT02343	2	DB2 CRASH DUE TO AN APPLICATION GETTING SQL09015
IT02309	2	MEMORY LEAK IN THE APPLICATION HEAP IF DATABASE USE UCACCC_400R1OR UCACCC_500R1 COLLATION AND STATEMENT USE "LIKE" PREDICATES
IT05812	2	INCORRECT RESULTS MIGHT BE RETURNED FOR COLUMN-ORGANIZED TABLES WITH AN ENFORCED PRIMARY KEY OR UNIQUE CONSTRAINTS
IT03843	2	LATCH WITH SQLO_LT_SMEMPOOL__MEMLATCHTYPE__LATC WHEN USE TOCHAR FUNCTION.
IT05904	2	INCORRECT RESULTS MIGHT BE PRODUCED IF HSJOIN HAS 2 NLJNS ON THEPROBE SIDE AND HSJN PROBE PUSH DOWN INTO THE SECOND NLJN DONE
IT02673	2	LOAD OPERATIONS INVOLVING XML OR LOB DATA IN NON-PARALLEL ENVIRONMENTS MAY CRASH IN INTERNAL HANDLE MANIPULATION FUNCTIONS
IT03447	3	DB2 VARCHAR_BIT_FORMAT ALLOWING SPACES/BLANKS
IT04667	3	SQL0901N ERROR WILL OCCUR ON FUNCTION SQLRI_HSJNFLUSHBLOCKS
IT02995	3	THE USE OF NUMERIC SCALAR FUNCTIONS PUSHING NUMERIC ARGUMENT TYPES THROUGH A JOIN OR UNION MAY PRODUCE A FODC_APPERR DIRECTORY.
IT02263	3	DB2EXPLN CANNOT PRINT NAME FOR CGTTS, THEN PRINTS SQL0100W INSTEAD.
Fix Pack 5 - Control Center
IT03687	3	IN DB2CC, SQL0104N AN UNEXPECTED TOKEN "VARCHAR" WAS FOUND WHEN REVOKING EXECUTE PRIVILEGE ON A PROCEDURE
Fix Pack 5 - DB2 Tools
IT04151	2	SAPHOT:V10.5 FP4 S140813 - MON_GET_HADR CRASHES MEMBER
IT01155	2	NNSTAT ERROR SQL1227N:THE CATALOG STATISTIC "XXXXX" FOR COLUMN "FIRSTKEYCARD" IS OUT OF RANGE FOR ITS TARGET COLUMN
Fix Pack 5 - DRDA Services
IT04914	1	APPLICATION MAY SEE SQL0501N, INCORRECTLY MOVE TO A NEW MEMBER OR FAILBACK, IF SERVER IS SETUP AS PURESCALE SERVER.
IT02272	2	DB2 CONNECT SERVER SENDS KEEP-ALIVE PROBES EVERY 5 SECONDS
IT04737	2	MEMBER SUBSETTING - CLIENT DOESN'T FAIL BACK OVER AFTER MEMBER COMES BACK ONLINE
IT04016	2	DB2 MIGHT CRASH UNDER SQLJCHANDLESPLITWRITES DUE TO SIGSEGV
IT00588	2	MEMORY LEAK IN PRIVATE POOL WHEN USING COMPLEX DATA TYPES
IT01351	2	POSSIBLE MEMORY LEAK WHEN USING 'INPUT ARRAY' AND THERE IS A FATAL ERROR WHILE EXECUTING THE STATEMENT
IT02266	2	DB2 APPL FAILS WITH -4499 ERROR OR HANG SITUATION IF THE APPL ISUSING MANY PARAMETERS, SPECIALLY OF ARRAY TYPE OR ROW TYPE
Fix Pack 5 - Data Management Services
IT05068	1	POTENTIAL CORRUPTION DURING READAHEAD DATA PREFETCHING WHEN A DECIMAL KEY PART IS USED WITH INDEX COMPRESSION
IT05194	1	TABLE MAY BE INCONSISTENT AFTER INPLACE TABLE REORG IN PURESCALEWITH EXPLICIT HIERARCHICAL LOCKING ENABLED
IT03627	2	RUNSTATS ON TABLE ... TABLESAMPLE(X) ON A RANGE PARTITIONED TABLE MAY RESULT IN A 'BADPAGE' ERROR
IT05280	2	BAD PAGE ERROR "FOLLOWED REORGPOINTER BUT NO OLR IN PROGRESS!" FOLLOWING INPLACE TABLE REORG IN PURESCALE.
IC99757	2	AVOID TRAPS WITH TCB FIX COUNT != 1
IT05655	2	ROLLBACK OF INPLACE TABLE REORG MAY LEAVE PAGE CORRUPTED IN RARECASES
IT02385	2	SQLD_BADPAGE IN SQLDDECREMENTRESERVEDSPACE DURING INPLACE TABLE REORG
IT02991	2	THE REORG TABLE COMMAND THROUGH ADMIN_CMD() COULD FAIL WITH SQL2203N.
IT02763	2	DEAD LATCH WHEN RUNNING TRUNCATE TABLE OPERATION AND ANOTHER AGENT LOOKS TO FLUSH THE BUFFERPOOL
IT04052	2	REORG_CURRENT_COUNTER IS LESS THAN REORG_MAX_COUNTER ON COMPLETED REORGS IN SYSIBMADM.SNAPTAB_REORG, DB2PD AND DB2TOP.
IT02373	2	SQLD_BADPAGE IN SQLDDECREMENTRESERVEDSPACE DURING INPLACE TABLE REORG
IT05384	2	PERFORMANCE IMPACT FROM ZZ JOIN USING INDEXED TEMP TABLE
IT04378	2	DB2 MAY CRASH UNDER SQLRIBNO IF AN INTERNAL RECORD IS SELECTED AS PART OF A RIDLIST SCAN
IT04358	3	LOW PERFORMANCE OF QUERIES ON ADMSINTABINFO
IT02447	3	DB2PD -REORG MIGHT SHOW INCORRECT REORG END TIME FOR PARTITIONEDTABLES
Fix Pack 5 - Data Management Utilities
IT05799	1	ROLLFORWARD THROUGH A LOAD WITH DELETE PHASE MIGHT RESULT IN FAILURE AND INDEX CORRUPTION
IT05036	2	DATA LOST AFTER ROLLFORWARD THROUGH SUCCESSFUL LOAD ... ALLOW READ ACCESS THAT WAS RUN IN V105 FIX PACK 4.
IT03506	2	SEGV ENCOUNTERED DURING LOAD WHEN TABLE HAS MANY RANGE PARTITIONS DEFINED
IT03960	2	PERFORMING A BACKUP INCREMENTAL DELTA TO TSM WITH THE DEDUP_DEVICE ON DPF INSTANCE MAY FAIL WITH SQL2038N (-91).
IT02237	2	SORT MIGHT TRAP AT BSORTGETFIRSTPARTIALKEY DUE TO INCORRECT INCREMENTAL SORT MEMORY.
IT05225	2	IMPORT AND EXPORT RETURNS INCORRECT SQL3015N WHEN REBIND PACKAGEFAILS
IT03505	3	DATA TRUNCATION ERROR IS IGNORED WITH WARNINGCOUNT WHEN LOAD AN IXF FILE AND IT HAS DIFFERENT CODE PAGE WITH DATABASE CODE PAGE
IT01146	3	UPDATING INDEX CAN FAIL WITH SQLI_NOKEY "KEY NOT FOUND WITHIN NODE"
Fix Pack 5 - Data Recovery Services
IT03975	1	WHEN TABLESPACES ARE RESTORED FROM ONLINE BACKUP, ROLLFORWARD MAY FAIL WITH SQL4970 IF NO LOG RECORDS EXIST FOR THE TABLESPACES.
IT05071	1	MEMBER CRASH RECOVERY MAY CONTINUOUSLY FAIL WITH SQLB_EMP_MAP_INFO_NOT_FOUND ERROR
IT03716	1	SINCE V10.1, DB2PD -DBCFG RETURNS INCORRECT HADR ROLES
IT04352	1	HIGH DISK I/O WHEN USING DB2READLOG API, HADR MULTIPLE STANDBY, OR HADR SUPERASYNC
IT02268	2	ENHANCE DIAGNOSTICS FOR "ROLLFORWARD IS NOT ABLE TO REACH THE END OF ONLINE BACKUP" ERROR.
IT04158	2	APPLICATION PERFORMING LOCK ESCALATION CANNOT BE FORCED
IT04018	2	RESTORE INTO EXISTING DATABASE MAY FAIL WITH AMD1814E INVALID LOGPATH DURING ROLLFORWARD
IT03963	2	DB2 CRASHES WHEN ITS CAN'T RESERVE SPACE
IT03811	2	SANITY CHECK DUAL LOG ENTRIES IN THE CASE CRASH RECOVERY HANG DUE TO DUAL ARRAY IS FULL
IT00401	2	CRASH WITH "DOUBLE FREE" MESSAGE AFTER SEVERAL RESTART OF VENDORLIBRARY.
IT03814	2	BACKUP DATABASE FAILED WITH SQL2079N
IT05260	2	DB2CKBKP TOOL GENERATES SEGMENTATION FAULT WHEN MEMBER ID OF THEIMAGE IS GREATER THAN 128 ON AIX PLATFORMS
IT03836	2	DB2READLOG API, HIT ZRC=0X8610000D=-2045771763=SQLP_BADLOG "LOG FILE CANNOT BE USED" ON LOG EXTENT XXXX
IT04199	2	DB ROLLFORWARD FAILED WITH SQL1042C WHEN PROCESSING A ADD MEMBERLOG RECORD CAUSED BY RETRIEVING LOGS FROM OLD LOG CHAINS
IT04074	2	GRACEFUL TAKEOVER IS SLOW DUE TO UNDO WAS FIGHTING LOGGR PRE-ALLOCATION
IT05224	2	SLOW DATABASE ROLLFORWARD OR HADR STANDBY REPLAY DUE TO FREQUENTCALLS TO AND MESSAGES FROM SQLPRPROCESSMAXLOGFILESOPENINRECOVER
IT04154	2	PURGING OF EXTRA LOG FILES CAN TAKE A LONG TIME
IC94629	2	DB2 FAILS TO MANAGE THE PARTIAL LOG RECORD AND CAUSE FAILURE ON CONSEQUENT ROLLFORWARD
IT04450	2	HADR TAKEOVER CAN HANG IF CREATE TABLESPACE IS ISSUED ON CONNECTION TO NEW PRIMARY DATABASE BEFORE THE TAKEOVER COMMAND RETURNS
IT03961	2	DB2 TRAP WHEN A BACKUP COMMAND DOESN'T GET ENOUGH MEMORY TO STARTUP
IT03947	3	CONNECTION ATTEMPT FAILS WITH SQL5099N WHEN THE MIRRORLOGPATH ISINVALID
IT01543	3	DB2INIDB SAMPLE AS SNAPSHOT WAS RETURNED DBT1011N UNABLE TO RESTART DATABASE "DATABASE-NAME" WITH THE WRITE RESUME OPTION. SQL
IT02825	3	LOCK ESCALATIONS WITH REASON CODE: "2" MIGHT BE REPORTED WHEN LOCKLIST MEMORY WAS NOT EXCEEDED
IT04203	3	LOG FILES ARE RENAMED/CLEANED UP BEFORE LOGARCHMETH2 FINISHES ARCHIVING THE LOG FILE
Fix Pack 5 - Federation
IT03404	2	MAY RECEIVE SQL1822N WITH ERROR MESSAGE HY014 CLI0129E WHEN CREATING NICKNAME ON MVS TABLE
IT03481	2	WHEN THE NUMBER OF PREDICATES IN A FEDERATED QUERY HAS BEEN EXCEEDED, SQL0430 IS RETURNED.
IT02271	2	DB2 FEDERATION: UNION OF SELECT ON NICKNAMES WITH FETCH FIRST N ROW CLAUSE COULD RETURN INCORRECT RESULTS
IT02591	2	RECEIVE SQL0901N WITH ERROR MESSAGE "MSSQL3 UNKNOWN VERSION" WHEN INSERTING NICKNAME FOR 2012 SQL SERVER
IT02274	2	MEMORY LEAK HAPPENS WHEN FEDERATED SET TO 'Y'
JR50345	2	-302 ERROR HAPPENS WHEN IUD A NICKNAME WITH COLUMN LENGTH LARGE ENOUGH
IT02312	2	INTERRUPT RC DO NOT HANDLE CORRECTLY BY FED WHICH LEADS TO SQL1101N ERROR.
IT01177	3	SELECT ROWNUM CAN NOT PUSHDOWN TO REMOTE ORACLE SERVER
IT00729	3	CREATE NICKNAME ON ORACLE RDB TABLE FAILS WITH AN ERROR SQL0901N "BAD COMPILER RETURN CODE"
IT01186	3	DB2LOOK GENERATES "CREATE SERVER" STATEMENTS THAT LEADS TO SQL1841N ERROR.
Fix Pack 5 - Index Manager
IT02203	2	ANONYMOUS BLOCK CLEANUP PROCEDURE IS NOT RESPECTING THE DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:<VALUE> REGISTRY VARIABLE
IT04338	2	CONCURRENT INSERT AND REORG RECLAIM EXTENT ON MDC TABLE MAY ABEND SERVER WITH DIA8737C
IT03623	2	THE RECLAIM EXTENTS OPTION OF REORG INDEXES DOES NOT MOVE PAGES IN TABLESPACES UPGRADE FROM DB2 VERSION 9.5 OR EARLIER
IT04117	2	REORG RECLAIM EXTENTS ON MDC TABLE MAY WAIT ON ONLINE BACKUP LEADING TO SQL0964C TRANSACTION LOG FULL
IT03540	2	REORG INDEXES OPERATION WITH CLEANUP ONLY ALL OPTION MAY NOT DETECT A FORCE REQUEST FOR A VERY LONG TIME
IT03298	2	INSERT MIGHT NOT RESPOND OR BE VERY SLOW OR HANG ON PURESCALE SYSTEMS
IT00928	2	ROLLFORWARD OF A RESTORED DATABASE MAY FAIL WITH: DIA8575C AN INDEX MANAGER PROGRAMMING ERROR OCCURED
Fix Pack 5 - Install and Catalog Services
IC99289	2	POSSIBLE CACHE CORRUPTION(SEGV/CRASH): ENTRY CAN BE FREED BY ONETHREAD AND ADDED TO LRU BY ANOTHER AT THE SAME TIME
IT04054	2	DB2VAL FAILS TO VALIDATE THE INSTANCE AND RETURNS ERROR DBI1338ERC 5 WITH SYSADM GROUP DEFINED IN DOMAIN ONLY
IT05544	2	INTERMITTENT SQL8001N, SQL8027 OR ADM12008C WITH VALID LICENSE WHEN MULTIPLE SAME APPLICATIONS ARE RUNNING SIMULTANEOUSLY.
IT05043	2	DB2IUPGRADE FAILED IN UPGRADE A PURESCALE INSTANCE A SPECIAL BUILD BASED ON DB2 10.5 FP4 - DBI20164E
IT04436	2	INSTALLFIXPACK FAILED WITH MAJOR ERROR AS PROCESSES RUNNING IN THE MEMORY THAT WERE HOLDING THE DB2 BINARIES.
IT04047	2	PACKED DESCRIPTOR OF A RANGE PARTITION TABLE CAN GET CORRUPTED WHEN ATTACHING A PARTITION.
IT02116	2	CHANGING LOCATION OF TEMP FILES GENERATED DURING INSTALLATION BYSPECIFYING DB2TMPDIR COULD RESULT IN DBI20043E
IT03663	2	DS CLIENT 'DB2UNINS' FAILS: UNABLE TO OPEN THE WINDOWS INSTALLERDATABASE 'DB2\WINDOWS\IBM DATA SERVER CLIENT.MSI'. RC=1638
IT04038	3	USING THE DB2HAICU MAINTENANCE MODE OPTION TO MOVE HADR DATABASES MAY CAUSE THE HADR RESOURCE GROUP TO BE LOCKED
IT04045	3	DROPPING THE SAME VIEW CONCURRENTLY MAY CAUSE DEADLOCK
IT04060	3	PROFILE.ENV HAS WRONG OWNERSHIP AFTER DB2IUPGRADE OR DB2ICRT OF ANOTHER INSTANCE
IT04146	3	V105FP4 - CLIENT/EXP-C - DB2IDROP SUCCESS OUTSIDE.. LOG FILE HAVING FAILURE WITH RETURN CODE IS "5021".
IT04147	3	FVT:DB2_V105FP5:INSTALLFIXPACK SHOWD "LIBRARY LOADING" WHEN WE APPLY ON TOP OF DB2 INSTALL PATH WHICH HAS PURESCALE BINARIES WIT
IC97602	3	AFTER LOGS BECOME FULL, AN INSERT INTO A GLOBAL TEMPORARY TABLE (DGTT) FAILS WITH SQL0901N
IT03771	4	DB2ICRT AND DB2IUPDT SETS DB2AUTOSTART=NO
Fix Pack 5 - Monitoring
IT00956	2	"CALL SYSPROC.ADMIN_MOVE_TABLE WITH CANCEL" IS FAILING WITH SQL2104N RC=9 AFTER LOG FULL CONDITION.
IT04599	2	MON_GET_TABLESPACE TABLE FUNCTION CAN RETURN NEGATIVE VALUES FORTBSP_INITIAL_SIZE & TBSP_MAX_SIZE
IT03587	2	APPL_ID VALUE IN CONNMEMUSE_ EVENT MONITOR TABLE HAS EXTRA GARBAGE CHARACTER AT END ON LITTLE-ENDIAN PLATFORMS (LINUX)
IT04097	2	AMT. OPTION REDIRECT FAILS ON TABLES IF PRIMARY INDEX INCLUDES ALL TABLE COLUMNS
IT02498	2	ADMIN_MOVE_TABLE FUNCTION RECIEVES SQL3025N AFTER UPGRADE TO VERSION 10.5 FP3, FP3A, OR FP4
IT03100	2	ADMIN_MOVE_TABLE MAY FAIL TO DROP UDI TRIGGERS FROM SOURCE TABLEDURING SWAP OPERATION
IT02306	2	DPF: EVENT MONITOR APPLICATION IN PENDING REMOTE REQUEST - UNABLE TO FORCE.
IT03719	2	INSTANCE MAY TRAP WITH SIGSEGV IN MONITORING CODE DURING DATABASE MANAGER SNAPSHOT COLLECTION AND ACTIVE AIC PROCESSING
IT03890	2	MON_GET_LOCKS FAILS WITH SQL0171N
IT04456	3	CONFIGURING OPM V5.1 TO USE IN-MEMORY METRICS, CREATES STACK FILES, THAT CAUSES THE DB2DUMP DIRECTORY TO BE 100% FULL.
IT03516	3	DB2 ALTOBJ FAILS TO RECREATE FOREIGN KEY WHICH REFERENCES PRIMARY KEY ON SAME TABLE AND SCHEMA NAME IS 8 CHARACTERS
IT04484	3	INTERNAL ROLLBACKS HAPPEN FOR "CONNECT RESET" OR "TERMINATE" ARECOUNTED THROUGH THE MONITORING ELEMENT "TOTAL_APP_ROLLBACKS"
IT02977	3	PROCEDURE SYSPROC.GET_DBSIZE_INFO MAY INCORRECTLY RETURN ERROR SQL0493
IT03728	4	MAX_COORDAGENTS CANNOT BE SET TO 0 VALUE
Fix Pack 5 - Parsing and SQL PL
IC99745	3	A SQL0779N ERROR MIGHT BE RETURNED IF LABEL IS FOLLOWED BY ONE OF THE ARRAY COLLECTION METHODS.
IT03959	3	INCORRECT STATEMENT TEXT (WRAPPED SQL09076 ...) MIGHT BE CATALOGUED IN TEXT COLUMN OF SYSCAT.ROUTINES
Fix Pack 5 - Platform Specific
IT03327	1	APPLICATIONS RUNNING UNDER NETWORK SERVICE ACCOUNT MAY TERMINATE/ CRASH AFTER 'ACCESS DENIED' ERROR
IT04660	1	RESTORE DATABASE MIGHT INTRODUCE CORRUPTION IN OBJECTS THAT RESIDE IN SMS TABLESPACES AND ARE LARGER THAN 2GB (WINDOWS ONLY)
IT05180	2	DB2STOP FORCE MAY HANG ON PAGE LATCHES DUE TO AN INSTANCE TRAP WHICH DID NOT TERMINATE THE INSTANCE
IT03832	2	DB2 IS NOT ABLE TO ACCEPT AN INCOMING CONNECTION IF NUMBER OF INSTANCE THREADS EXCEEDS RLIMIT_NPROC LIMIT
IT05794	2	SQLO_LATCH_ERROR_EXPECTED_HELD ERROR LEADS TO DB2 CRASH IN WINDOWS
IT03220	2	DB2BP.EXE MIGHT LEAK "CONTROL PANEL\INTERNATIONAL" REGISTRY KEY HANDLE
IT05042	2	STOPSHIP: DB2INSTDEF SHOULD BE ENABLED ON NON-WINDOWS PLATFORMS
IT04104	2	DB2START AND DB2STOP FAIL WITH SQL1042C ERROR AFTER SETTINGS THEDB2PATH ENVIRONMENT VARIABLE
IT03779	2	DB2 LIST DCS APPLICATION EXTENDED FAILS TO DISPLAY THE COMPLETE IP ADDRESS FOR "CLIENT NODE"
IT05179	2	THE OPM CPU MONITOR (OPM V5.1) USES DB2 API WHICH IS GIVING INCORRECT RESULTS
IT03823	2	MEMORY LEAK IS POSSIBLE ON WINDOWS IF CALLING ENV_GET_DB2_SYSTEM_RESOURCES
IT03401	2	A NEWLINE CHARACTER IN DB2ENVLIST WILL RESULT IN AN INFINITE LOOP WHEN ACCESSED BY THE REG_VARIABLES VIEW CAUSING HIGH CPU.
IT01384	2	DECFLOAT TLS INITIALIZATION NEEDS TO BE AUTONOMIC TO ALLOW OSSDECIMAL USAGE IN CLI CODE.
IT05628	2	DB2 CRASHES WHEN FUNCTION LIO_LISTIO RECEIVES OS ERROR ENOTSUP IN SOLARIS
IT02448	3	MON_GET_MEMORY_SET DISPLAYS WRONG MEMORY SET STATISTIC FOR MEMORY_SET_SIZE
IT04017	3	PREFETCHING CAUSES DB MARKED BAD WHEN SYSTEM ERROR OCCURS IN SQLOCSEMV
Fix Pack 5 - Problem Determination
IT05072	2	INSPECT COMPLAINS ABOUT INVALID PAGE STATES WHEN NO PROBLEM EXISTS
IT05511	2	PD UDFS (PD_GET_DIAG_HIST, PD_GET_LOG_MSGS, OR PDLOGMSGS_LAST24HOURS ) MAY FAIL ON SQL0443N INTERMITTENTLY.
IT03918	2	PD_GET_DIAG_HIST OR DB2DIAG MAY HANG AND CONSUME 100% CPU IF PARSING DB2DIAG.LOG RECORD CONTAINING EVENT STRING FIELD
IT04339	2	DB2DIAG TRAPS WHEN THE TOTAL NUMBER OF ROTATING DB2DIAG.#.LOG FILES UNDER ALL THE SPLIT DIAGPATH DIRECTORIES EXCEEDS 15
IT01070	3	DB2FODC -HADR DOESN'T WORK ON SINGLE MEMBER DPF INSTANCE
IT00821	3	DB2PDCFG -FODC[DBCFG\|DBMCFG\|TRAPRESILIENCE] STATUS DOES NOT WORKFOR USER WITH ONLY SYSMON AUTHORITY
IT03962	3	DB2TOP MAY TRAP WHEN DISPLAYING QUERY TEXT IN "D - DYNAMIC SQL" WINDOW DURING INTERACTIVE MODE.
IT02942	3	COLLECTING DB2SUPPORT IN NON-PURESCALE ENVIRONMENTS ATTEMPTS TO OPEN "DB2INSTANCEINFO.REG" WHICH CAUSES MESSAGES IN DB2DIAG.LOG
IT03133	3	DB2SUPPORT WITH -FODC OPTION MIGHT TRAP IN DPF OR PURESCALE SYSTEMS.
IT02674	3	DB2SUPPORT CAN NOT COLLECT DB2DJ.INI, IF DB2_DJ_INI WAS SPECIFIED.
Fix Pack 5 - Process Model
IT01985	2	HADR STANDBY ON LINUX MIGHT TERMINATE ABNORMALLY WHEN DB2 AUDITIS ACTIVE
IT04519	2	SQKFCHANNEL::WAITSENDREADY RECIEVES SQLO_INTRP INTERRUPT AND RESULTS IN PANIC
IT04647	2	DB2 INSTANCE MAY TRAP IN SECTION CLOSE
IT02533	2	CLIENT LOAD CAN FAIL DUE TO MEMORY OVERWRITE BECAUSE OF INCORRECT INPUT PARSING
IT03143	2	INSTANCE PANIC IN XA ENVIRONMENT DUE TO UNLATCHING A LATCH THAT IS NOT HELD.
IT01072	2	SQKFCHANNEL::WAITSENDREADY RECIEVES SQLO_INTRP INTERRUPT AND RESULTS IN PANIC
IT02273	2	TRAP IN SQLEGWRT FUNCTION DUE TO MEMORY ACCESS VIOLATION IN MULTI-THREADED ENVIRONMENT.
IT02948	2	NON-DEFAULT LDAPSERVERPORT CAN'T BE CONFIGURED IN DB2DSDRIVER.CFG
IT00697	2	NONTHREADED FECNED WRAPPER MAY TRAP THE INSTANCE WHEN IT GOES INTO UNSTABLE STATE
IT04372	2	DB2DIAG.LOG FILLS WITH "UPDATING IN MEMORY VERSION OF DBM CONFIGWITH ON DISK INFORMATION (SYS PROFILE)" MESSAGES
IT00327	2	DB2FMP MAY LEFT FOREVER WHEN "CONNECT RESET" HAPPENED AND THE DB2FMP IS IN THE HEADER OF THE FED FMP PRCOCESS LIST
IT04137	3	CALLING STORED PROCEDURE ENV_GET_INSTANCE_CODE_LEVELS ON WINDOWSPLATFORM RESULTS IN SQL0444N
IT04571	3	RESTORE ON FP4 MAY FAIL WITH SQL5133N ERROR IF THE DATABASE WAS CREATED AND BACKED UP BETWEEN 10.5GA AND FP3
IT03544	3	CREATE DATABASE AS A SYSCTRL USER MAY CAUSE DATABASE CONFIGURATIONS TO NOT BE APPLIED CORRECTLY
IT03166	4	'AUTOCONFIGURE' COMMAND DOES NOT DISPLAY KEYWORD 'AUTOMATIC' FORSELF TUNED AUTOMATIC PARAMETERS.
Fix Pack 5 - Query Compiler Optimizer
IT05012	2	DB2 MIGHT TRAP WHILE COMPILING A QUERY THAT IS ELIGIBLE FOR ZIGZAG JOIN PROCESSING
IT03965	2	SQL0901N IS RETURNED WITH "EPE: NO MATCHING Z-VAL FOR PROBE KEY IN RECV TQ" ERROR IN DPF ENVIRONMENT
IT04582	2	DB2 CAN TRAP IN FUNCTION SQLNO_CRULE_NLJN UNDER RARE CIRCUMSTANCES
IT04291	2	IO COST OF NLJOIN CAN BE SIGNIFICANT LOWER THAN IO COST OF INNER(RIGHT) IXSCAN-FETCH LEG IN RARE SITUATIONS
IT05436	2	IN A RARE CONDITION, A QUERY AGGREGATING WITHOUT GROUP BY CLAUSEON A PROVABLE 0-ROW STREAM CAN RETURN INCORRECT RESULT
IT03013	2	INVALID FILTER FACTOR ESTIMATION FOR RANGE PREDICATE
IT04732	2	SQL1224N ERROR DURING QUERY COMPILATION UNDER MEMORY CONSTRAINEDENVIRONMENT
IT04173	2	SQL STATEMENT WITH MULTIPLE SIMILAR CORRELATED SUBEXPRESSIONS MIGHT RETURN INCORRECT RESULTS
IT03930	2	SQL STATEMENT WITH LARGE NUMBER OF JOINS BETWEEN MULTIPLE RANGE PARTITIONED TABLES MIGHT RETURN SQL0101N ERROR
IT03251	2	SQL0437W MIGHT BE INDUCED BY RUNSTATS IN DATABASES THAT USE LOCALE-SENSITIVE UCA-BASED COLLATIONS
IT03891	2	RTS COLLECTING TABLE CARDINALITY AS 0 AFTER TRUNCATE AND POPULATE TABLE.
IT02369	2	DB2 OPTIMIZER MIGHT NOT MATCH A STRING LITERAL WITH VALUES IN DISTRIBUTION STATS IN SOME RARE CASES
IT03792	2	NEGATIVE COLCARD CAUSES OPTIMIZER TO CHOOSE A BAD PLAN, RESULTING IN POOR QUERY PERFORMANCE.
IT04924	2	WHEN INTRA_PARALLEL ENABLED, SQL STATEMENT WITH IN PREDICATE MIGHT RETURN INCORRECT RESULTS
IT02322	2	PERFORMANCE ENHANCEMENT FOR A SINGLE PARTITION TABLE IN A DPF ENVIRONMENT.
IT05709	2	SQL0901N "ISCAN PLAN NOT FOUND" RETURNED FOR DB2 SPATIAL EXTENDER QUERY
IT05185	2	SQL STATEMENT WITH REPARTITIONED JOINS MIGHT RETURN INCORRECT RESULTS IN A DPF SYSTEM
IT01379	2	AVGLEAFKEYSIZE AND AVGNLEAFKEYSIZE ARE INCORRECT WHEN RUNSTATS USING INDEXSAMPLE SYSTEM
IT01176	3	DB2 CAN RETURN SQL0973N WHEN GENERATING AN INDEX-ANDING STAR JOIN PLAN THAT CONTAINS A RECURSIVE SUBQUERY
IT03686	3	RUNSTATS MAY COLLECT INCORRECT VALUES FOR AVGPATITION_PAGE_FETCH
IT03675	4	DB2EXMIG DOES NOT PRESERVE PERMISSIONS ON RECREATED TABLES
Fix Pack 5 - Query Compiler QGM
IT01488	2	QUERY EXECUTION FAILS WITH -901 REASON "(LIKE: SEARCH PATTERN STRUCTURE IS NULL)"
IT03087	2	DB2 MIGHT CRASH IF A VALUES CLAUSE GENERATED TABLE IS USED AS A TARGET OF INSERT INTO STATEMENT
IT02992	2	COMPILER MEMORY LEAK WHEN USING FEDERATION
IT04487	2	QUERY COMPILATION FAILS WITH SQLCODE -901 "INVALID COLLATION ID"
IT00693	2	DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERY WITH GENERATED COLUMNS OF DATATYPE DATE OR TIMESTAMP
IT03730	2	DB2 MIGHT NOT OPTIMIZE EQUIVALENCE BASED PREDICATES ON COLUMN ORGANIZED TABLES
IT04470	2	"LIMIT # OFFSET #" MAY RETURN MORE ROWS THAN EXPECTED WHEN QUERIES CONTAIN UNION OR UNION ALL OPERATORS.
IT05493	2	A QUERY MAY HIT -901 ERROR WHEN IT CONTAINS PREDICATE COL=NULL
IT03857	2	PERFORMANCE PROBLEM WITH QUERY THAT USES A SEQUENCE IN THE PROJECTION LIST
IT02568	2	DB2 MIGHT PRODUCE A SQL0901N WHEN PLANNING EARLY OUT NESTED LOOPJOIN
IT01954	2	DB2 MIGHT PRODUCE SQL0901N ERROR MESSAGE WHEN EXECUTING LEFT JOIN QUERY ON TABLE WITH RCAC
IT04157	2	PERFORMANCE MAY BE POOR FOR QUERIES WITH A VALUES CLAUSE AND UNION OPERATOR
IT04730	2	SECURITY: DB2 MAY TERMINATE ABNORMALLY WHEN ISSUING AN ALTER TABLE STATEMENT WITH AUTO_REVAL SET TO IMMEDIATE (CVE-2014-6159).
IT04354	2	SQL20524 RC=3 RETURNED WHEN FUNCTION PARAMATER, LOCAL VARIABLE, OR TRANSITION VARIABLE USED AS PERIOD-SPECIFICATION
IT05044	2	INCORRECT RESULTS MIGHT BE RETURNED FOR A QUERY INVOLVING AN AGGREGATION FUNCTION AND AN OUTER JOIN OPERATOR
IT05178	2	SQL0418 ERROR CAN BE RETURNED IF UNTYPED PARAMETER MARKER IS USED AS ARGUMENT FOR TRIM/STRIP SCALAR FUNCTION
IT02342	2	DDLS ON NICKNAME CAUSE DEADLOCK
IT02265	2	REORG ON A TABLE WITH FOREIGN KEY CONSTRAINT CAN RESULT IN SQL ON PARENT TABLE GETTING LOCK TIMEOUT
IT02178	2	MERGE STATEMENT WITH PARAMETER MARKER AS SOURCE RETURNS SQL0901NUNDER CERTAIN CONDITIONS
IT05401	2	IN A RARE CONDITION, A QUERY OF A CHAIN OF EQUALITY JOIN PREDICATES BETWEEN 4 OR MORE TABLES COULD PRODUCE EXTRA ROWS
IT03072	2	DB2 MIGHT NOT OPTIMIZE SQL QUERIES CONTAINING OUTER JOINS AND EXISTENTIAL SUBQUERIES
IT04367	2	AVIOD TO DIVISION BY ZERO SQL0801N
IT00506	2	-901 FROM RUNNING A QUERY.
IT04174	3	QUERIES THAT CAN BE ROUTED TO SHADOW TABLES MAY RETURN SQL1668N ERROR WHEN ISSUED WITHIN AN XA TRANSACTION
IT02746	3	TRANSFER OWNERSHIP COMMAND FAILED WITH SQL0607N ERROR FOR TABLESPACES SYSTOOLSPACE AND SYSTOOLSTMPSPACE
IT01144	3	UNNECESSARY U-LOCKS PLACED ON STATISTICAL VIEWS DURING REFRESH MQT OR SET INTEGRITY
IT03336	3	OBJECT CAN BE DROPPED, ALTERED, RENAMED OR TRUNCATED USING A SYNONYM IN AN ORA MODE DATABASE
IT02445	3	QUERY MAY THROW RUNTIME ERROR SUCH AS OVERFLOW, DIVIDE BY 0, OR CASTING ERROR DUE TO JOIN PREDICATE EXPRESSION
IT05177	3	"CREATE OR REPLACE" FLAG CASCADED TO PROCEDURE FROM THE UNDERLYING VIEW
IT02318	3	LOCATE_IN_STRING RETURNS 0 WHEN INSTANCE PARAMETER IS SET TO SMALLINT
Fix Pack 5 - Relational Data Services
IT03522	1	UNCONDITIONALLY ACQUIRED REBIND SEQ LOCK DOES NOT GET RELEASED IN SQLRA_RECREATE_PKG AND THE APPLICATION WILL HOLD ONTO THE SEQ
IT04326	1	PACKAGE CACHE MEMORY USE CAN EXCEED CONFIGURED SIZE RESULTING INMEMORY EXHAUSTION ON DB2 CANCUN RELEASE 10.5.0.4.
IT03512	2	SQL20540N (-1224) WHEN RUNNING AUTONOMOUS TRANSACTION DUE TO PLAN LOCK WHEN INTERNAL CLI PACKAGE IS INVALID
IT04542	2	INSTANCE MAY TRAP IN _ZN30SQLRWAPPLICATIONMETRICSBUILDER7EXECUTEEP14SQEAPPLICATION
IT00377	2	STMM MAY UNNECESSARILY INCREASE PACKAGE CACHE SIZE
IT01171	2	APPERR WITH -901 MIGHT OCCUR CALLING SP REFERENCING MODULE NESTED ARRAY TYPE IS CALLED BY SQLC PROGRAM
IT03348	2	ENABLE EXTENDED INDICATOR AND REOPT ALWAYS MAY CAUSE INSTANCE CRASH
IT03495	2	XA APPLICATION MAY BE FAILED BY RECEIVING -998
IT03727	3	"FLUSH PACKAGE CACHE" STATEMENT CLEANS UP STATIC SQL STATEMENTS BY MISTAKE
IT02710	3	AFTER UPGRADE TO V105 FP1 OR LATER, A CALL OF THE PROCEDURE MAY RETURNS SQL204N
Fix Pack 5 - Security
IT04590	2	FP4 ONLY: DB2STOP WILL RETURN SQL6037N IF DB2_NUM_CKPW_DAEMONS=0.
IT04662	2	DB2CKPW DEFUNCT PROCESSES CONSUME ALL PAGING SPACE AND RESULT INA SERVER SHUTDOWN
IT04120	3	AUD0022N MAY BE REPORTED WHEN DB2AUDIT EXTRACTS CORRUPTED AUDIT LOG
Fix Pack 5 - Text Search
IT04391	2	SUPPORT SPECIAL CHARACTERS IN TEXT SEARCH INDEX NAMES
IT03496	2	TEXT SEARCH INDEX'S DON'T GET UPDATED CORRECTLY WITH NEW DATA WHEN "FOR DATA REDISTRIBUTION" OPTON IS USED FOR INITIAL UPDATE
Fix Pack 5 - pureScale Services
IT03630	1	TAKEOVER HADR COMMAND SUCCEEDS BUT RESOURCE GROUP REPORTS FAILEDOFFLINE IN LSSAM OUTPUT
IT01082	2	THE MONITOR SCRIPT USED FOR HA WITH VCS INCORRECTLY REPORTS THATTHE INSTANCE IS OFFLINE CAUSING AN INSTANCE RESTART
IT04515	2	IN AN HADR/TSA ENVIRONMENT, DB2HAICU ONLY CREATES DEPENDENCIES AGAINST NETWORK EQUIVALENCIES NAMED AS "DB2_PUBLIC_NETWORK_X"
IT02503	2	RUNNING THE "DB2FM -S" COMMAND RESULTS IN A SEGMENTATION FAULT ERROR.
IT04628	2	DB2CLUSTER REPORTS DBI20027E ERRORS WHEN SETTING UP LOGIN BANNERVIA /ETC/SSH/SSHD_CONFIG
IT02864	2	HA FILESYSTEM IS AUTOMATICALLY REMOUNTED BY TSA WHILE THE DB2 INSTANCE IS STOPPED
IT04145	2	CONFIGURED_CF_MEM_SIZE IN MON_GET_CF FUNCTION RETURNS WRONG VALUES.
IT02132	2	DB2SETUP FAILS TO START DB2 FAULT MONITOR ON SOLARIS 10+ WITH ERROR "SVCCFG: NOT FOUND"
IT03803	2	ADDING DATABASE MOUNTS WITH DB2CLUSTER COMMAND(DB2CLUSTER -CM -ADD -DATABASE_MOUNTS) FAILS WITH SQL0969N ERROR
IT00451	3	DB2FM -D GENERATES SOME ERRORS IN DB2DIAG.LOG ON ESE SINGLE PARTITION INSTANCE
IT00450	3	FALSE NEGATIVE ERROR MESSAGES IN DB2DIAG.LOG WHEN TAKEOVER HADR IN TSA CONFIGURED HA ENVIRONMENT
IT02173	3	DB2FMCU -D TERMINATED WITH SIGTERM AND RETURN CODE 143

DB2 Version 10.5 Fix Pack 4
APAR	Sev.	Abstract
IC99728	2	OPM EI DOES NOT USE THE CLIENTINFO VALUES SET BY EMBEDDED SQL COBOL APPLICATIONS USING THE WLM_SET_CLIENT_INFO STORED PROCEDURE
Fix Pack 4 - Abstract Data Types and Spatial Extender
IC98509	3	PERFORMANCE MAY BE SLOW FOR SOME QUERIES USING DB2GSE.ST_INTERSECTS
Fix Pack 4 - Administration Server
IC95667	2	WHEN A SCRIPT RUNS IN TASK CENTRE, EXTRA SLASH ADDED TO LIBPATH CAUSING INSTANCE ENV SWITCH USING DB2PROFILE TO FAIL
Fix Pack 4 - Administration Tools
IC95545	1	DB2LOOK DOES NOT GENERATE COLUMN OPTIONS FOR TYPED TABLES
IC97156	2	DB2LOOK -T OPTION WITH TWO-PART TABLE NAMES OF THE FORMAT SCHEMA.TABLE AGAINST DB2 Z/OS IT DOES NOT FIND THE TABLE.
IC97885	2	SQL0206N "A.TYPERULES" NOT FOUND SHOULD NOT BLOCK DB2LOOK TO GENERATE DDLS FOR OTHER OBJECTS
IC99668	2	DB2LOOK -L COLLECTS CONTAINER INFORMATION FOR AUTOMATIC STORAGE TABLESPACES WHICH IS NOT NEEDED BUT COULD CAUSE SLOWNESS ON DPF
IC98510	2	DB2LOOK -M GENERATES RUNSTATS COMMAND WITH WRONG "NUM_FREQVALUES-1 NUM_QUANTILES -1" OPTIONS
IC96371	2	SQL0104N IS RETURNED WHEN UPDATING SYSSTAT.COLDIST.COLVALUE VIA DB2LOOK MIMIC MODE
IC98889	2	SQL3022N - SQL ERROR "-104" EXECUTING DB2MOVE WITH EXPORT FROM DB2 Z/OS DATABASE
IT00496	2	RUNNING DB2LOOK WITH "-X" AND "-CT" OPTIONS WHEN USING DB2_COMPATIBILITY_VECTOR=ORA COULD FAIL WITH AN SQL0407N ERROR.
IT01904	2	USING DB2MOVE WITH THE COPY OPTION TO MOVE FROM V9.5/V9.7 TO V10.5 FAILS WITH 'SQLCODE -204'
IC94656	2	FED: DB2LOOK GENERATE INCORRECT FUNCTION MAPPING DDL
IT01476	2	AUTOMATIC BACKUP DOES NOT DELETE OLD BACKUP IMAGE IN DB2 V10
IC97132	3	DB2LOOK MAY GENERATE THE SAME PREDICATE TO MIMIC STATISTICS FOR UNIQUE INDEXES.
IC96353	3	"INTERNAL HEALTH MONITOR ERROR " ERRORS DUMPED IN THE DB2DIAG.LOG FOR "DB2.MAX_SORT_PRIVMEM_UTIL" HEALTH INDICATOR
JR47705	3	DB2LOOK GENERATES INCORRECT HIGH2KEY/LOW2KEY FOR CHAR/VARCHAR WHEN VARCHAR CAPATIBILITY IS ON
IC96349	3	HEALTH MONITOR FAILS TO DIFFERENTIATE BETWEEN HADR PRIMARY AND SECONADRY AFTER HADR TAKEOVER.
Fix Pack 4 - Buffer Pool Services
IC99403	1	POSSIBLE CRASH (PANIC) OF DB2 IN SQLBREMOVEPAGEFROMTHISDIRTYLISTWITH MESSAGE "DEQUEUE W/0 PAGES ON DL"
IT03864	1	ADMIN_MOVE_TABLE DOES NOT PROVIDE CORRESPONDING LOAD OPTION "TEMPFILES PATH"
IC96714	2	TABLE SPACES HAVING ONLY ONE CONTAINER CAN NOT MAKE USE OF "VECTORED IO"
IC96370	2	DB2RELOCATEDB OR "DB2INIDB ... RELOCATE USING" MIGHT CONSTRUCT WRONG CONTAINER PATH NAME
IC99981	2	INCREMENTAL BACKUP MAY FAIL WITH SIGSEGV OR SQLO_EOF / SQL1655 DURING EMP CHAIN PROCESSING
IC95365	2	PRIVATE MEMORY LEAK ON THE DB2 SERVER BY THE DB2PFCHR THREAD
IT00454	2	OPENING A RAW DMS CONTAINER HAVING FILE SYSTEM CACHING CAN CRASHTHE DB2 INSTANCE.
IC94964	2	DROPPING ALL INDEXES FROM INDEX OBJECT FOLLOWING REORG INDEX RECLAIM EXTENTS MAY RETURN SQL1034C AND CAUSE INSTANCE ABEND
IC99226	2	IN PURESCALE, DB2PCLNR MAY RUN INTO ENDLESS LOOP IN SAL_READCCINFO EVEN IF NO WORKLOAD EXISTS
IT01207	2	INCREMENTAL BACKUP MAY FAIL WITH ZRC SQL_EOF AND SQL1655 DURING EMP PAGE PROCESSING FOR LONG DATATYPE OBJECTS
IC97608	2	CRASH RECOVERY FAIL WHEN FREEING DELETE PENDING EXTENTS
IC91474	2	REPLAYING CREATE BUFFERPOOL FAILS WITH SQL0901N (SQLB_NONSEVERE_PRGERR FROM SQLBCREATEBPONDISK) IN PURESCALE ENVIRONMENT
Fix Pack 4 - Build Team
IC95532	2	A 32-BIT CLI APPLICATION RUNNING WITH DB2 64-BIT ON AIX FAILS WITH ILLEGAL INSTRUCTION ERROR
Fix Pack 4 - CDE Data
IT01396	1	IN RARE CASES, A QUERY CAN RETURN INCOMPLETE RESULTS FROM A COLUMN ORGANIZED TABLE.
IT00826	1	SQL0901N WHEN ACCESSING A NEWLY LOADED COLUMN-ORGANIZED TABLE
IC98734	1	ON A COLUMN-ORGANIZED TABLE, QUERIES RUNNING AT THE SAME TIME ASREORG RECLAIM EXTENTS MAY FAIL WITH SQL0901N
IT00510	1	REPLAY OF REORG-INDEX-RECLAIM-EXTENTS LOG RECORDS MIGHT LEAD TO INDEX CORRUPTION
IT03045	1	WRONG RESULTS WITH CONCURRENT UPDATES AND DELETES ON A COLUMN-ORGANIZED TABLE
IT03533	1	QUERY ON COLUMN ORGANIZED TABLE AFTER INSERT IN SAME TRANSACTIONMIGHT RETURN OLD ROWS DELETED/UPDATED BY ANOTHER APPLICATION
IC99559	2	INGEST INCORRECTLY TRUNCATES FRACTIONS BEYOND TIMESTAMP(6), WHENNO FORMAT IS SPECIFIED BY INGEST.
IT01236	2	CONCURRENT DELETE CAUSED INCORRECT RESULTS IN UPDATE
IT01104	2	DELETE RUNNING CONCURRENTLY WITH A RUNSTATS MAY CAUSE INCORRECT QUERY RESULTS.
IT03642	2	INCORRECT RESULTS POSSIBLE IN CASES WHERE A COLUMN ORGANIZED TABLE IS MODIFIED BY TWO TRANSACTIONS AT THE SAME TIME
IV56219	2	TRAP DURING ROLL BACK OF WORK AGAINST A COLUMN-ORGANIZED TABLE.
IV60472	2	PANIC IN SQLOPOSTEDUWAITPOST() VIA INSERTRANGEDISTRIBUTOR::RELEASEINSERTRANGE() DURING CLIENT INTERRUPT
IT01340	2	INTEGER ( SMALLINT, INT, BIGINT ) COLUMN, WHEN LOADED THROUGH LOAD WITH CERTAIN VALUES, COULD SEE WRONG RESULTS
Fix Pack 4 - CDE Query
IC99639	1	COLUMN BASED QUERY MAY HANG IF THE QUERY CONTAINS AGGREGATION FUNCTIONS AND DATA EXCEPTION OCCURS
IV61372	1	A STATEMENT WITH TRIM AND A BLANK CHARACTER IN AN INLIST MAY CAUSE A HANG IN A COLUMN ORGANIZED TABLE.
IT00939	2	THE SQL0901N ERROR MIGHT BE RETURNED DURING COLUMNAR QUERY EXECUTION.
IT03025	2	CRASH DURING GROUP BY PROCESSING AGAINST COLUMNAR TABLE IN FUNCTION GETHASH()
IT01779	2	MEMORY LEAK IN APPLICATION HEAP EXECUTING A QUERY REFERENCING COLUMN-BASED DATA
IT00909	2	"<TIME_COLUMN> +/- <DECIMAL_COLUMN> SECONDS" MIGHT PRODUCE INCORRECT RESULTS IN COLUMN-ORGANIZED TABLES
IT02215	2	QUERY AGAINST CDE TABLE WILL PRODUCE DIFFERENT ROWCOUNT WHEN PREDICATE COMPARES NULL VS CAST(NULL AS BIGINT)
IT00712	2	INCORRECT RESULT IN COLUMN-ORGANIZED TABLES IN SQL WITH "COL >= RHS1 AND COL <= RHS2", IF BOTH DECIMALS AND DOUBLES ARE INVOLVED
IC98812	2	SQL0901N "UNEXPECTED ERROR AT PARSER.CPP:<LINE OF CODE>" IN COLUMN-ORGANIZED TABLES
IT00883	2	COLUMN-ORGANIZED TABLE WITH WRONG DATETIME STRING SYNTAX OUTPUTS A RECORD RESULT INSTEAD OF ERROR
IT03213	2	FILIADATAHOT BLU POC: QUERY HANGS DURING GROUPBY
IT01797	2	STACK TRACEBACK FILES ARE INCORRECTLY GENERATED FOR A NORMAL SQL0955 ERROR.
IT02004	2	WRONG NUMBER OF ROWS RETURNED FROM CDE TABLE WHEN WHER CLAUSE HAS OR (COLUMN IS NOT NULL AND COLUMN IS NOT NULL ) .
IT02214	2	INCORRECT RESULTS WHEN SELECTING "DISTINCT LENGTH(<VARCHAR_COLUMN>)" FROM A COLUMN-ORGANIZED TABLE
IT02052	3	POOR PERFORMANCE WITH SUBSEQUENT UPDATES IN A SINGLE UOW WITH COLUMN ORGANIZED TABLES
Fix Pack 4 - Client Interfaces
IC98990	1	WHEN APP HAVE BOTH CLIENT SIDE TRIAL LIC AND SERVER LIC, THE SQLGETINFO (CLI) FUNCTION WILL REPORT INCORRECT INFORMATION
IC97852	1	CLPPLUS DISPLAYS INCORRECT RESULT WHEN MORE THAN ONE LIKE CLAUSEIS SPECIFIED IN A SELECT STATEMENT
IC99457	2	WHEN STATEMENTCONCENTRATOR IS SET ALONG WITH SQL_ATTR_PARAMOPT_ATOMIC=0, CLI APP ERRORS OUT AGAINST DB2 Z/OS(-20186,-215, -312)
IC95320	2	MULTI-THREADED APPLICATIONS USING BOTH ESQL/C AND CLI INTERFACESMAY EXPERIENCE HANGS OR CRASHES WHEN NOT USING EXPLICIT CONTEXT
IC94555	2	DB2CFEXP DOES NOT EXPORT ALTERNATE SERVER INFORMATION
IC98689	2	WHEN INTERRUPT IS NOT DUE TO QUERYTIMEOUT AND ACR IS ENABLED, CLI MAY GO FOR RETRY.
IC98382	2	ADO.NET DB2 PROVIDER - ACCESSVIOLATIONEXCEPTION ISSUE WHEN PERFORMING ARRAY INSERT OF LARGE BINARY VALUES ON A BLOB COLUMN.
IC99803	2	SAP: SQLCREATEPKGW() API IS MISSING FROM DB2CLI64.DLL, DB2CLI.DLL AND DB2CLIO.DLL FILES.
IC98803	2	CLI APPLICATION CRASHES DUE TO ARRAY INPUT FLAG FAILS TO RESET IN CLI LAYER WHILE CLI APPLICATION PERFORMS ARRAY INPUT.
IC99778	2	OCINUMBERTOTEXT AND OCINUMBERFROMTEXT RETURN INCORRECT VALUE WHEN THE FORMAT STRING IS 99999999999999.9999
IT00505	2	ON WINDOWS IF DB2DSDRIVER_CFG_PATH IS SET TO A UNC (UNIVERSAL NAMING CONVENTION) PATH, CLI IS UNABLE TO IDENTIFY IT CORRECTLY.
IC98396	2	INCORRECT RESULTS RETURNED FOR OCINLSENVIRONMENTVARABLEGET WHEN USED WITH OCI_NLS_CHARSET_ID
IC95100	2	BLOB AND CLOB DATATYPES ARE NOT CAST CORRECTLY IN .NET ENTITY FRAMEWORK GENERATED QUERIES WHEN USING INFORMIX DATABASES
IC93858	2	CALLING SQLSETSTMTATTR WITH THE OPTION SQL_ATTR_CHAINING_END CANRETURN SQL_ERROR , BUT DOESN'T UPDATE THE ERROR HEADER.
IC95427	2	CLI0143E ON SQLBINDPARAMETER FOR TIMESTAMP OR TIMESTAMP WITH TIMEZONE TYPE WITH CBCOLDEF=-1
IT02435	2	STALE POINTER IN CURSOR HANDLING CODE CAN LEAD TO A CRASH IN FUNCTION CSMGETNEWCDBBUFFER
IC95296	2	CLPPLUS WILL THROW A JCC EXCEPTION WHEN CONNECTION FAILS TO ESTABLISH AND 'WHENEVER SQLERROR' CLAUSE IS SET.
IC98455	2	VISUAL STUDIO ENTITY DATA MODEL WIZARD MIGHT NOT SHOW ISERIES TYPE L AND TYPE P TABLES
IC95015	2	"DB2 PREP" IS FACING WITH SIGSEGV ERROR WHILE IT IS CALLED IN A MAKEFILE.
IC98586	2	STACK OVERWRITE WHEN FUNCTION OCIATTRGET() IS CALLED WITH OCI_ATTR_CHARSET_FORM
IC97844	2	SQL0902 UNEXPECTED EXCEPTION ERROR MAY OCCUR IN DB2 .NET PROVIDER DUE TO UNHANDLED RETURN CODE DURING CODE PAGE CONVERSION
IC99419	2	CLI-BASED APPLICATIONS RECEIVE SQL0501N AGAINST DB2 Z/OS WHEN STORED PROCEDURE CALL HAS MULTIPLE CURSORS
IC98104	2	DB2CFEXP DOES NOT EXPORT AUTOMATIC VALUES PROPERLY IF BACKUP CLAUSE IS SPECIFIED
IC96359	2	BATCH EXECUTION INTRODUCES INTERNAL COMMIT (EVEN WITH AUTOCOMMITOFF)
IC98634	2	TWO MINOR MEMORY LEAKS IN CLI WITH SPECIAL REGISTERS AND ONE MAJOR MEMORY LEAK IN .NET
IC98386	2	DB2CFEXP/DB2CFIMP UTILITIES FAIL TO EXPORT/IMPORT THE CORRECT SECURITY TYPE FOR NODE CREATED WITH SSL SECURITY.
IC95934	2	ERRORS SUCH AS SQL0313N AFTER A CLI APPLICATION EXECUTES DELETE OR UPDATE WITH WHERE CURRENT OF <CURSOR-NAME> CLAUSE
IC98943	2	INCORRECT RESULTS WHEN FETCHING LOB DATA VIA CLI WITH MULTI-ROW FETCH
IC95510	2	ERROR WHEN CLPPLUS PERFORMS ENVIRONMENT VARIABLE SUBSTITUTION FOR SQL STATEMENT THAT INCLUDES % CHARACTER
IC98749	2	ENTITY FRAMEWORK APPLICATION MAY GET -181 ERROR USING DATETIME AGAINST DATE COLUMN
IC98107	2	PARAMETERS STORED AS STRINGS ARE NOT APPLIED BY DB2CFIMP (ERROR -5060)
IC97841	2	CLIDRIVER AND DSDRIVER NOT WORKING ON HP PLATFORM :ERROR "SHAREDLIBRARY NOT FOUND 'LIBDB2.SO'"
IC96713	2	CLI0113E ERROR OCCURS ON TIMESTAMP LITERAL VALUE FOR OUTPUT PARAMETER OF STORED PROCEDURE WHEN IMPLICIT CAST IS DISABLED
IC99056	3	OCIATTRGET SETS AN INCORRECT VALUE WHEN PASSED VALUES OCI_ATTR_DATA_TYPE OR OCI_ATTR_CHARSET_FORM
IC95509	3	APPLICATIONS USING THE IBM DATA SERVER DRIVER RECEIVE SQL0902C ERROR IF DATABASE NAME IS NOT IN THE DB2DSDRIVER.CFG FILE.
IC98610	3	CLI RETURNS BOOLEAN SUPPORT FLAG AGAINST ISERIES AND Z/OS SERVERAS TRUE WHEN BOTH THE SERVER DOES NOT SUPPORT BOOLEAN.
IC97246	3	DB2CLI VALIDATE -DSN DATABASE RETURNED "MESSAGE : NO CHARACTER DATA IS ALLOWED BY CONTENT MODEL"
IT01141	3	REORGCHK COMMAND AND REORGCHK_TB_STATS PROCEDURE MAY NOT RECOMMEND REORG FOR PARTITIONS IN A PARTITIONED TABLE.
IC99088	3	THE COLUMN ATTRIBUTE OCI_ATTR_PRECISION WHEN USING AN EXPLICIT DESCRIBE WILL SET THE PRECISION TO SB2 PLACEHOLDER.
IC96712	3	WHEN DBALIAS IS MENTIONED IN CONNECTION STRING, CLI IS NOT PROCESSING COMMON SECTION OF DB2CLI.INI
IC99054	3	CONCURRENTACCESSRESOLUTION DS DRIVER KEYWORD DOES NOT TAKE EFFECT IF VALUE IS SPECIFIED BY STRING.
IC96358	3	DB2CLI VALIDATE -DSN <DSN> -CONNECT FAILES WITH SQL1032N ERROR
IC98476	3	ERROR CLI0199E WHEN CONNECTING TO A CATALOGED DATABASE IF AUTHENTICATION IS SPECIFIED IN CONNECTION STRING OR DB2CLI.INI
IC97249	3	THE CONNECTION ISOLATION LEVEL IS NOT PRESERVED AFTER A TRANSACTION BUT RE-SET TO THE PRODUCT DEFAULT.
IC96310	3	FORMATTING DB2TRC USING -CLI OPTION TERMINATES ABNORMALLY ON 64BIT LU PLATFORMS FOR 32BIT APPLICATIONS.
IC94404	3	USING THE DB2CFIMP TO IMPORT CONNECTIVITY CONFIGURATION PARAMETERS CAUSES AUTOMATIC VALUES TO BE RESET TO MINIMUM VALUES.
IT03901	3	CLPPLUS DOES NOT READ DB2DSDRIVER.CFG PRESENT UNDER CFG FOLDER FOR IBM DB2 PRODUCT INSTALLATION
IC98556	3	DB2FMP ABEND AND SQL1131N ERROR IS OBSERVED DURING REORGCHK_TB_STATS(..) RUN WITH DB2MEMDBG=PROTECT
IT00568	3	DB2 .NET PROVIDER NOT PERFORMING CODE PAGE CONVERSION ON DATE, TIME, TIMESTAMP FROM ZOS WHEN IDAA QUERY ACCELERATION ENABLED
IT01686	3	DB2DIAG.LOG DISPLAYS LICENSE NOT FOUND ERROR EVEN THOUGH SERVER-BASED Z/OS LICENSE WAS USED SUCCESSFULLY
Fix Pack 4 - Codegen and Runtime
IT02047	1	ACCESS PLANS CONTAINING INDEX ORING BETWEEN MDC AND NON MDC INDEX MAY NOT FETCH ALL ROWS FROM SECOND EXECUTION ONWARDS
IT01020	1	ROWS MISSING WHEN LARGE RESULT SET IS PRODUCED BY NULLS FIRST SORT ON INTEGER OR BIGINT
IC97850	2	DB2DIAG.LOG IS FILLED WITH -443 WARNING MESSAGES
IC99469	2	EXCESSIVE POST THRESHOLD SORTS, SQL0955 ERRORS RUNNING WITH QUERY PARALLELISM AND PRIVATE SORT ENABLED
IC96946	2	SQL0901N ERROR TRIGGERED IN SQLKTSND:AT SANITY CHECK IN CODE
IT00542	2	THE DBMS_LOB.COMPARE FUNCTION AND DBMS_LOB.READ PROCEDURE DO NOTPROCESS CLOBS CORRECTLY IF MULTI-BYTE CHARACTERS ARE PRESENT
IC97012	2	POOR PERFORMANCE DUE TO FREQUENT MEMORY OPERATIONS DURING QUERIES WITH 'LIKE' PREDICATES.
IC99584	2	INSTANCE MAY CRASH IF THERE INCONSISTENT STATISTICS
IC98174	2	AN ACCESS PLAN WITH NESTED MDTQ OPERATORS WITHOUT A SORT OR TEMPOPERATOR IN BETWEEN MAY HANG
IC95289	2	SOMETIMES A QUERY INVOLVING A ZIGZAG JOIN MAY FAIL WITH WITH A SQL0901N ERROR
IT01118	2	NOVEMBER AND DECEMBER 1ST-14TH 1582 INCORRECTLY RETURNS JULIAN CALENDAR DAYS INSTEAD OF USING GREGORIAN CALENDAR
IC98127	2	HEAVY WORKLOAD MAY HANG DB2
IT00585	2	SELECT INTO STATEMENT DOES NOT SET VALUE TO A GLOBAL VARIABLE
IC97603	2	INSTANCE CRASH DUE TO RUNTIME SERVICES FREEING AN XML NULL POINTER
IC97290	2	INSTANCE MIGHT ABEND OR RETURN INCORRECT RESULTS DUE TO AN INCORRECT EXECUTION SECTION FOR STAR JOIN
IC95479	2	INSTANCE MIGHT CRASH IF A QUERY THAT FEATURES A SORT IS RE-EXECUTED AFTER IT PREVIOUSY RECEIVED SQL0973.
IT00665	2	"CLI0111E NUMERIC VALUE OUT OF RANGE" IF THE LENGTH OF THE DECFLOAT DATA IS LONGER THAN 31 DIGITS
IT00930	2	COLLATION_KEY_BIT MIGHT GENERATE EMPTY STRINGS IN ORACLE MODE IFINPUT STRING CONSISTS OF BLANKS
IC95668	2	UNDER RARE MEMORY CONDITIONS, STMM HASH JOIN SIMULATION MAY FAILAND CAUSE FODC TO BE PRODUCED
IC97269	3	THE DBMS_LOB.COMPARE FUNCTION AND DBMS_LOB.READ PROCEDURE DO NOTPROCESS CLOBS CORRECTLY IF MULTI-BYTE CHARACTERS ARE PRESENT
IT02525	3	DROPPING COLUMN-ORGANIZED TABLE WITH UNFINISHED SIMULTANEOUS OPERATIONS ON IT, MIGHT LEAD TO ERROR SQL1034C.
IC99489	3	SQL20442 ERROR ATTEMPTING TO ALLOCATE APPLICATION HEAP MEMORY FOR ARRAY VALUES IN SQL PROCEDURES
IC96975	3	WITH CURRENTLY COMMITTED SEMANTICS DISABLED A STATEMENT MAY INCORRECTLY FAIL WITH SQL0901N ( REASON "IMPROPER LOCKING" )
IC97309	3	DIAGNOSTIC FIX TO COLLECT EXTRA DATA, PERFORM EXTRA CHECKS AND PREVENT TRAPS DUE TO MEMORY OVERWRITES IN TABLE QUEUES
IT00933	3	IN DB2 DPF ENVIRONMENTS ONLY, A SPECIFIC TYPE OF QUERY AND RESULTING ACCESS PLAN MIGHT RETURN WRONG RESULTS
IT01530	3	SQL0466W FUNCTION SQLRIINVOKERTRUSTED, PROBE:184 RAISED AT DEFAULT DIAGLEVEL IN DB2DIAG.LOG
IC99467	3	COPY PROCEDURE IN DBMS_LOB MODULE MIGHT FAIL AFTER 32KB DATA, ALTHOUGH DBMS_LOB MODULE SUPPORTS LOB DATA UP TO 10MB.
Fix Pack 4 - Communication
IC96360	2	RETURN ERROR WHEN MULTI-TRANSPORT TM ATTEMPTS TO XACOMMIT/XAROLLBACK WHEN THERE IS WITH-HOLD CURSOR IN USE.
IC95519	2	RESUMPTION OF SUPPORT FOR NAMED PIPES COMMUNICATION PROTOCOL.
IC97842	2	AUTHENTICATION VERY SLOW ON CERTAIN PSERIES HARDWARE WITH POWER7CPU'S
IC97577	3	APPLICATION DELAYS MAY OCCUR WHEN DISCONNECTING FROM DB2 SERVERSON WINDOWS
Fix Pack 4 - DB2 Tools
IC96574	2	SQL1096N WHEN WE TRY TO STOP/START THE DB2 INSTANCE VIA THE DB2SYSTRAY ICON.
IC99370	2	DB2FMP CRASHES WHEN RUNNING NNSTAT FOR A NICKNAME THAT HAS AN INDEX CONTAINS TOO MANY COLUMNS
IC98515	2	RUN NNSTAT FAILED WITH SQL0134N OR SQL1131N WHEN THERE IS AN INDEX INCLUDE LOB TYPE COLUMN
IC97601	2	LOAD COMMAND USING THE ADMIN_CMD PROCEDURE DOES NOT SHOW ROWS_SKIPPED, ROWS_LOADED, ROWS_DELETED, AND ROWS_COMMITTED WITH DPF
Fix Pack 4 - DRDA Services
IC98927	1	COMMEXIT IS BROKEN ON LINUX390 AND LINUXPPC
IC99151	1	DB2 DRIVER/CLIENT MAY TRAP FOR APPLICATIONS USING THE WORKLOAD BALANCING (WLB) FEATURE.
IT01174	1	AUTOMATIC CLIENT REROUTE DOES NOT RECONNECT TO THE PRIMARY OR ORIGINAL SERVER
IT02729	2	WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.
IT03053	2	CLIENTS GETTING STUCK/TERMINATED AFTER FEW ITERATIONS OF TAKEOVER WITH ALTERNATE GROUP SETTING ENABLED
IC97883	2	SQL30020N ON ROLLBACK, IF CONNECTING TO DB2 10.1 SERVER VIA DB2 CONNECT 9.7 GATEWAY
IC95492	2	SQL1001N ERROR FROM CLI APPLICATION WHEN ENLISTING THE DATABASE WITH MSDTC.
IC98077	2	DB2 INSTANCE MIGHT CRASH AFTER REPORTING 'CM PARAMETER BAD' ERROR.
IC95411	2	WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.
IT01406	2	CLI APPLICATION MAY CRASH IN CLI_EXECCMRIFLUSHARRAY() FUNCTION
IC98923	2	INSTANCE TRAPS IN SQLDDADDEXTENDEDDDENTRY()
IC99704	2	CHAR DATA CORRUPTION DURING SELECT WITH QUERY ACCELARATION.
IC97122	3	DB2 CLIENT PRINTS -1013 IN DB2DIAG.LOG WHEN USING DB2DSDRIVER.CFG AND DB NOT EXIST IN DB CATALOG.
Fix Pack 4 - Data Management Services
IC99341	1	SEVERE ERROR INDICATED WHILE READING LOB ALLOCATION MAP
IC96500	1	INSTANCE CRASH DURING CRASH RECOVERY IF INFLIGHT ONLINE REORG WORKLOAD AND TABLE SPACE IS INACCESSIBLE.
IT00795	1	SQL1476N WITH ERROR "-668" RETURNED WHEN SET INTEGRITY FOR AN MQT OF "COMPRESS YES" AND "REFRESH IMMEDIATE"
IC96727	1	SELECT OF A TABLE AFTER A TABLE SPACE ROLLFORWARD OF AN INFLIGHTONLINE REORG TRANSACTION MAY GET SQL1656C DUE TO A BAD PAGE.
IC99791	2	FAILURE DURING ONLINE TABLE REORGANIZATION MIGHT LEAD TO DATABASE HANG
IC98171	2	DATABASE CRASHES WHEN ATTEMPTING A DROP COMMAND THAT CONTAINS "NULLS"
IC95405	2	SQL STATEMENT MAY HANG DUE TO A DEADLATCH WHEN PROCESSING SUBSECTIONS OF A ZIG ZAG JOIN PLAN
IT00696	2	SQLDREPLACEROW REPORTS SQLD_BADPAGE DURING ROLL FORWARD
IC99679	2	A REORG INPLACE OPERATION ON A TABLE WITH ADAPTIVE COMPRESSION ENABLED MIGHT FAIL OR RESULT IN AN INCORRECTLY COMPRESSED ROW
IC96364	2	LOG FULL DURING TABLE TRUNCATION CAUSES CRITICAL ERROR AND MARKSDATABASE BAD
IC95871	2	TRAP(SIGSEGV) DURING A NONPARTITIONED BLOCK INDEX SCAN ON A MDC & RANGE PARTITIONED TABLE IN DPF & SMP ENVIRONMENT
IT01163	2	POTENTIAL HANG WITH A LOAD AND TWO INDEX REBUILDS
IT01180	2	POTENTIAL DEAD LATCH OR HANG WITH A LOAD AND TWO INDEX REBUILDS
IT03076	2	DATA CORRUPTION POSSIBLE AFTER RECREATING PAGE DICTIONARY
IC97639	2	SLOW CONCURRENT INSERTS INTO LARGE TABLE
IC99899	2	DB2 CRASHES WITH "UNKNOWN PROGRAM ERROR" IN SQLDFINDRIDFROMPAGECACHECOMPLEX AFTER A NON-SEVERE ERROR
IC98997	2	IN PURESCALE ENVIRNMENT, 3-WAY DEADLATCH COULD HAPPEN IN RARE TIMING SCENARIO.
IC98144	2	LATCH PROTOCOL ISSUE IN ZIG ZAG JOIN EXECUTION LEADING TO DEADLATCH BETWEEN SUBAGENTS
IC98122	2	DB2 MAY TRAP OR ABEND IF AN ERROR IS ENCOUNTERED DURING A SHAREDINDEX OR TABLE SCAN
IT00673	2	BADPAGE OR OTHER ERRORS WHEN ACCESSING TABLES IN A TABLESPACE THAT IS BEING RESTORED OR ROLLED FORWARD
IC99073	2	ADMIN_GET_TAB_COMPRESS_INFO_V97 IS SHOWING NEGATIVE NUMBER FOR ROWS_SAMPLED FOR A LARGE TABLE
Fix Pack 4 - Data Management Utilities
IT03115	1	INCORRECT INDEX SCAN OUTPUT AFTER ROLLFORWARD OF LOAD ... INDEXING MODE REBUILD FOLLOWED BY LOAD ... INDEXING MODE INCREMENTAL.
IT02347	1	REDISTRIBUTE MAY MISPLACE (ADD NODE) OR LOSE (DROP NODE) EXTENDED RECORDS FROM A TABLE WITH EXTENDED ROW SIZE SUPPORT
IC97408	2	IMPORT AND EXPORT FAIL WITH SQL1031N WHEN CONNECTING TO DB BY DB2DSDRIVER.CFG.
IC99030	2	DB2 EXPORT AND DB2 IMPORT ONLY SUPPORT STATEMENTS < 32700 BYTES AGAINST NON-LUW SERVERS
IC96659	2	ROLLFOWARD FAILURE FOR THE LOAD COPY YES INTO /DEV/NULL MAY WRONGLY LEAVE THE TABLESPACE IN NORMAL STATE
IC96099	2	REMOTE CLIENT LOAD HANGS AND COULD NOT BE KILLED
IC97065	2	A LOAD COMMAND WITH LOW WARNINGCOUNT MIGHT HANG
IT02008	2	-902 FROM SQLSSETUPINCREMENTALINSERTBUFFER
IT02765	2	SLOW PERFORMANCE FROM CLI BASED LOAD
IC96487	2	DB2 DOES NOT RESPOND TO FORCE APPLICATION OR INTERRUPT REQUEST AGAINST LOAD APPLICATION
IC99920	2	IMPORT MIGHT HIT SQL0304N ERROR AND REJECT ROWS CONTAINING TIMESTAMP DATA IF TIMESTAMPFORMAT IS SPECIFIED FOR ASC/DEL FILE
IC99746	2	FORCE APPLICATION OF LOAD FROM CURSOR MIGHT CAUSE LOAD TO HANG
IC95948	2	-901 IN REDISTRIBUTE ABORT AFTER SUCCESSFUL REDISTRIBUTE ABORT/CONTINUE WITH EXCLUDE KEYWORD.
IT00926	2	CONCURRENT LOADS TO THE SAME TABLE MIGHT RESULT IN DEADLOCK
IC99110	2	SQL1194W REPORTS A NEGATIVE COLUMN NUMBER FOR CLI LOAD AND A LOBCOLUMN.
IC97131	2	POSSIBLE CRASH (SEGV/ABORT) IN SQLDFORMATLOBLONGCOL() WITH LOAD FROM CURSOR ON TABLE WITH LOB AND CODESET CONVERSION
IT02260	2	INGEST UTILITY: ERROR SQL2038N WHEN A DISTRIBUTION KEY COLUMN TYPE IS A UDT
IC98209	2	LOAD WITH EXPRESSION BASED INDEXES FAILS DURING EXPRESSION GENERATION.
IC94997	2	DPF: DB2DART REPORTED INDEX KEY ERRORS AFTER REDISTRIBUTE ON A TABLE WITH ADAPTIVE COMPRESSION
IC98890	2	LOAD FROM REMOTE CURSOR (REMOTE FETCH LOAD) MAY HANG AFTER GETTING AN ERROR IN VERY EARLY PHASE
IC97727	2	SQL2918N RECEIVED WHEN THE INGEST COMMAND SPECIFIES BOTH ONE OF THE IMPLICITLYHIDDEN OPTIONS AND THE EXCEPTION TABLE CLAUSE
IC98200	2	LOAD MIGHT FAIL WITH SQL2043N WHEN IT IS ABOUT TO END IN A RARE TIMING-DEPENDENT SCENARIO
IC97064	3	LOAD MIGHT HANG IF INPUT DATA HAS LARGE CORRUPTED SECTION
IC99068	3	SORTS FROM SMALL INDEX BUILDS OVER-RESERVE SORT MEMORY, STMM MAYUNNECESSARILY INCREASE SORT TUNING
IT02091	3	DB2 HANG WHEN USING LOAD UTILITY WITH DUMPFILE OPTION
IC96433	3	UNDER RARE CONDITIONS, LOAD CANNOT BE FORCED OFF DURING A FORCE APPLICATION PROCESSING IN A DPF ENVIRONMENT.
IT01013	4	DB2 LOAD COMMAND PRODUCES 'ERROR' MESSAGES DURING SUCCESSFUL OPERATION
Fix Pack 4 - Data Recovery Services
IC97155	1	COMPENSATION LSN AS RETURNED FROM DB2READLOG API DIFFERS FROM THE ACTUAL VALUE
IT01656	1	TABLE SPACE ROLLFORWARD MIGHT NOT UNDO TRANSACTION CORRECTLY, LEAVING INCONSISTENT DATA
IC99566	1	ROLLFORWARD TO END OF BACKUP IMAGE MIGHT FAIL DUE TO CLOCK SKEW FOR A DPF DATABASE ON DIFFERENT PHYSICAL NODES
IC98726	1	INCORRECT HANDLING OF HEURISTICALLY ABORTED TRANSACTION IN DB2 PURESCALE LEAVING DATA INCONSISTENT
IT02397	1	BACKUP WILL FAIL WITH FILE SIZE TOO BIG IF LOB FILE IN A SMS TABLESPACE REACHES OVER 2TB IN SIZE.ONLY
IC96348	1	SLOW COMMITS WHEN STMM-MANAGED LOCKLIST GROWS INTO OVERFLOW
IT00608	1	RESTART DATABASE FAILS WITH ERROR SQL1042C
IC98804	1	DUE TO LSN CHANGES IN PURESCALE ARCHITECTURE TOOLS USING DB2READLOG API MAY SUFFER BAD PERFORMANCE IF AN OLD LSN IS REQUESTED
IC98415	2	HADR STANDBY DATABASE WAS SHUT DOWN WITH DIA8414C DUE TO NOT RECEIVING THE FINAL COPY OF XHDR
IC96356	2	ONLINE BACKUP MIGHT BLOCK TRANSACTIONS THAT ARE DOING COMMIT.
IC97605	2	RESTORE GENERATING ERRORS DUE TO COMPRESSION LIBRARY ALREADY EXISTING.
IC96086	2	HADR GRACEFUL TAKEOVER FAILS ON STANDBY THAT HAS TABLE SPACES/TRANSACTIONS IN REPAIR STATE.
IC97592	2	THE SPLIT SNAPSHOT FLAG IS NOT CLEARED DURING A SNAPSHOT BACKUP
IT01915	2	HASH LATCH CONTENTION CAUSES POOR PERFORMANCE
IC99405	2	SQLPGRETRIEVELOGFILE MAY REPORT WRONG CHAIN NUMBER IN DB2DIAG.LOG IN ERROR SCENARIO
IT01126	2	COMPRESSED ARCHIVED LOGS HAVE DIFFERENT PERMISSIONS THAN NON-COMPRESSED.
IC96739	2	DB2READLOG API WAS RETURNED SQLCODE -1273
IC95979	2	HADR STANDBY LOSES CONNECTION AND RECONNECTS FOLLOWING A GRACEFUL TAKEOVER WHEN SUPERASYNC IS USED FOR HADR_SYNCMODE
IT00945	2	A RETRIEVED LOG WAS UNEXPECTEDLY REMOVED BY ANOTHER MEMBER IN PURESCALE, CAUSING MISSING LOGS FOR ONLINE TABLESPACE ROLLFORWARD.
IT01606	2	TEST FOR FREE SPACE>LOG SPACE WILL FAIL BECAUSE ALREADY ALLOCATED LOG PRIMARY SPACE IS NOT TAKEN INTO ACCOUNT.
IC97971	2	DB2ADUTL REVOKE USER <USERNAME> REVOKES ALL OR DOESN'T REVOKE ANY
IC93281	2	NO AUTO DELETION OF OLD BACKUP IMAGES ON DISK AFTER MIGRATION TO10.1
IC96882	2	IMPROVE SQL2038N ERROR MESSAGE
IT01493	2	NO AUTO DELETION OF OLD BACKUP IMAGES FROM TSM AFTER MIGRATION TO 10.X
IT01055	2	ESTIMATED LOGFILESIZE PROVIDED BY DB2 TO TSM IS WRONG FOR TRUNCATED LOGFILES
IC96210	2	IN AN AUTOMATED HADR ENVIRONMENT THE TAKEOVER HADR COMMAND SUCCEEDS, BUT A MOVE REQUEST IS NOT SENT TO TSA
IC99582	2	SILENT SWITCH TO THE DEFAULT LOGPATH PATH
IC99052	2	ROLLFORWARD DATABASE RETURNS SQL1774N ON HADR DATABSE AFTER SNAPSHOT RESTORE AND DB2INIDB AS MIRROR
IC95669	2	TCP CONNECTIONS FROM NON-HADR DATABASE SOFTWARE TO THE STANDBY MIGHT ALTER THE HADR STATE AND STALL LOG SHIPPING ON THE PRIMARY
IC96639	2	IN DPF ENVIRONMENT PRUNE WILL NOT DELETE IMAGE FROM DISK WHERE THE DATABASE PARTITION EXPRESSION $N WAS USED IN TARGET DIRECTORY
IT02843	2	PERFORMING MEMBER CRASH RECOVERY IN PURESCALE WITH EHL ENABLED MIGHT CORRUPT THE TABLE IN CERTAIN SITUATIONS
IT02258	2	ONLINE BACKUP PERFORMANCE DEGRADATION AND ABNORMAL BACKUP IMAGE FILE SIZE VARIATIONS IN V10.1
IC95903	2	DB2 ROLLFORWARD MIGHT HANG IN BACKWARD PHASE WHEN INFINITE LOGGING IS USED
IC99738	2	DATABASE MIGRATION TO V10 CAN TAKE A LONG TIME TO COMPLETE, WHILE V10 LOGFILES ARE ALLOCATED IN BACKGROUND
IC98416	2	HADR STANDBY DOESN'T DUMP FLIGHT RECORDERS DURING ABNORMAL SHUTDOWN OF DATABASE
IC99682	2	HIGH USER CPU OR SYSTEM HANG MAY BE OBSERVED WHEN LARGE AMOUNT OF LOCK RESOURCES BEING USED BY MANY CONCURRENT TRANSACTIONS
IC97816	2	STANDBY MAY FAIL TO CONNECT TO PRIMARY WITHIN HADR_TIMEOUT, WHENDB2_HADR_BUF_SIZE IS SET TO A VERY LARGE VALUE
IT02838	2	DB2ADUTL DOES NOT CORRECTLY SET THE BACKUP NAME DURING UPLOAD
IC95430	2	DB2CKBKP REPORTS MISLEADING ERROR "NO PAGE HEADER: POSSIBLE LOB.ERROR - TABLESPACE PAGE SIZE INCONSISTENT FOR TABLESPACE ID <#>"
IC97437	2	DB2 MAY FAIL TO ARCHIVE A LOGFILE IN COMPRESSED FORMAT, LOGFILE WILL BE ARCHIVED WITHOUT COMPRESSION INSTEAD
IT02136	2	DATABASE ROLLFORWARD OR HADR STANDBY REPLAY FAILS WITH A LOG CHAIN ERROR AFTER RESTORING FROM AN ONLINE BACKUP.
IT02670	2	TRAP IN SQLPKILLIFWAITING AFTER DEADLOCK
IC97487	2	A TRANSACTION COULD HOLD DATA PARTITION LOCKS EVEN AFTER COMMIT/ROLLBACK
IC97073	2	DB2 DOES NOT REMOVE OLD LOGS DURING UPGRADE IN V10
IT03081	3	AUTO DELETION OF BACKUP OBJECTS NO LONGER WORKING AFTER SWITCHING BETWEEN ARCHIVAL AND CIRCULAR LOGGING
IC99276	3	DATABASE UPGRADE TO DB2 V10.X DOES NOT DELETE THE PRE-V10 DB2TSCHG.HIS FILE
IT01711	3	ABILITY TO DISABLE TRANSPORT OF STATISTICS DURING A DATABASE SCHEMA TRANSPORT OPERATION
IC97606	3	BACKUP LIST UTILITIES COMPLETED WORK ESTIMATE INACCURATE WHEN BACKUP-COMPRESSION ENABLED.
IC97543	3	HADR PRIMARY DISCONNECTS AND STANDBY SHOWS PEER STATE WHEN DISK IS FULL ON STANDBY.
IC98063	3	THE DB2CKLOG TOOL MAY INCORRECTLY REPORT A LOG FILE AS INVALID
IC99286	3	STANDBY_SPOOL_PERCENT MAY SHOW AN INCORRECT VALUE
IT01784	3	RECOVER USING HISTORY FILE WITH NON-EXISTING DB IN DPF MODE FAILS WITH SQL1092 INSUFFICIENT AUTHORITY ERROR
IC97177	3	HADR STANDBY DB COULD RUN INTO A TRAP WHEN IT'S REMOTE DB IS ALSO A STANDBY DB
IC99232	4	DEBUG DPS CRASH HDRSETEXPLICITSTARTED PROBE:556677 STACK IN DB2DIAG.LOG WHEN HADR DB ACTIVATED
Fix Pack 4 - Federation
IT01600	1	FEDERATION SERVER CREATE NICKNAME COMMAND REDUCES THE LENGTH OF DBCLOB COLUMN
IC97640	2	FEDERATED QUERY MAY RECEIVE SQL0418N ERROR IF FEDERATED DATABASESET STMT_CONC=LITERALS
IT03203	2	INCORRECT RESULTS MIGHT BE RETURNED WHEN USING THE UNION SET OPERATOR TO SELECT FROM COLUMN-ORGANIZED TABLES
IC99667	2	DRDA WRAPPER REPORTS SQL3324N WHEN CREATING NICKNAME FOR A TABLE USES LBAC
IC97761	2	USING SERVER OPTION DB2_REQUESTS_IO_BLOCK_BUF MAY CAUSE A DATABASE FORCED SHUTDOWN WHEN SELECT FROM NICKNAME
IC98322	2	FED:IN PREDICATE CAN NOT BE PUSHDOWN DUE TO BLANK PADDING
IT00649	2	INCORRECT RESULTS FROM INSERT WITH VALUES, WHEN INSERTING TO A COLUMN-ORGANIZED TABLE
IC95524	2	FED: UPDATE NICKNAME FAILED WITH SQL1822N WITH "HY104 INVALID PRECISION VALUE"
IC95530	2	FEDERATION SERVER MAY CRASH WHEN FORCING APP ON COOR NODE FROM NONE-COOR NODE
IC98830	2	FEDERATION SERVER QUERY RESPONSE SLOWLY EVEN IF JR47502 IS APPLIED
JR49987	2	INSTANCE MAY CRASH WHEN DROPPING CODEPAGE SERVER OPTION
JR50297	2	SELECT FROM A FEDERATED NICKNAME MAY RECEIVE SQL0180N ERROR WITHDATETIME/TIMESTAMP COLUMNS AFTER UPGRADE TO 10.1 FP3
IC96772	2	QUERIES WITH/WITHOUT PREDICATES RETURNED SAME RESULT, PUSHDOWNABLE PREDICATE IS NOT COMPOSED INTO REMOTE STATEMENT
IT00320	2	BLOCK FETCH MAY CAUSE ENGINE CRASH WHEN DB2FMP TERMINATES ABNORMALLY
IC95597	2	INSERT INTO ODBC/JDBC NICKNAME FAILED WITH SQL0901N REASON "BAD COMPILER RETURN CODE"
IC96434	2	SQL0901N ERROR WHEN CREATING NICKNAME ON NICKNAME
JR50015	3	SQL1224N ERROR AND CRASH WHEN SET VARCHAR_NO_TRAILING_BLANKS TO Y AND SEARCHED THE STRING WHICH HAVE TRAILING WHITE SPACE.
IC99849	3	PUSHDOWN PERFORMANCE ISSUE DUE TO MISSING '=' FUNCTION MAPPINGS FOR DECIMAL/DECFLOAT
Fix Pack 4 - Index Manager
IC95292	1	DATABASE MARKED BAD WHILE DROPPING AN INDEX
IC99377	1	USING LOAD FOR MDC TABLES ON CASE INSENSITIVE DATABASES MIGHT CAUSE BLOCK INDEX CORRUPTION
IT03122	1	RECOVERING A FAILED ONLINE INCREMENTAL LOAD ON AN INDEX WITH PAGE SPLIT HIGH AND PCTFREE 0 VALUES MIGHT CORRUPT THE INDEX.
IT02557	1	SQLB_BADHDR "BAD PAGE HEADER" ENCOUNTERED DURING CLASSIC REORG OF AN INSERT TIME CLUSTERING TABLE
IC97636	2	SAMPLED DETAILED INDEX RUNSTATS ON RANGE PARTITIONED TABLES CAN RESULT IN HIGH PRIVATE MEMORY USE AND LONG EXECUTION TIME
IT02292	2	SLOW INDEX INSERT/UPDATE PERFORMANCE IN DB2 ESE FOR DATABASES WHICH HAVE BEEN RESTORED FROM DB2 PURESCALE INSTANCES
IT00762	2	LOAD INTO MDC TABLE FAILS WITH SQL0902C OR SQL0990C
IC97310	2	INSTANCE MAY CRASH WITH ERROR (IN DB2DIAG.LOG) "ROLLOUT CB LIST IS NOT EMPTY AT TX BOUNDARY! "
IT02761	2	MISSING INDEX KEY OR WRONG RESULT WHEN USING EXCLUDE NULL KEYS RANDOM INDEXES AFTER SOME DATA PARTITION ATTACH OPERATION
IT00421	2	POTENTIAL INDEX CORRUPTION WHEN USING INDEX COMPRESSION AND UNICDOE DATABASES WHICH USE UCA COLLATION WITH S(STRENGTH) = 1 OR 2
IC97686	2	ASYNCHRONOUS PARTITION DETACH JOB MAY BE SUSPENDED BY ABP DUE TOINVALID AUTHID
IC98257	2	AFTER PERFORMING AN OFFLINE REORG IN HADR ENVIRONMENT, INDEX SMSTABLESPACES HAVE DIFFERENT SIZES ON PRIMARY COMPARED TO STANDBY
IT00987	3	CONCURRENT REORGS ON DIFFERENT DATA PARTITIONS OF THE SAME PARTITIONED TABLE MIGHT EXECUTE SEQUENTIALLY DURING IDXRECREAT PHASE.
Fix Pack 4 - Install and Catalog Services
IC98880	1	LUM LIBRARY NEEDS TO BE UPDATED FOR LINUXAMD64
IC99328	1	LOCK TABLE <COLUMN-ORGANIZED TABLE> IN EXCLUSIVE MODE FAILS BECAUSE OF MISSING PERMISSION ON SYNOPSIS TABLE
IC99538	2	ALTER TABLESPACE PREFETCH SIZE ON TABLEPSAPCES WITH MANY OBJECTSFLOODS CATALOG CACHE
IC94507	2	DB2CKUPGRADE PERFORMANCE IMPROVEMENT FOR TABLE LOAD PENDING CHECK
IT02749	2	FIXPACK UPDATE FAILED DUE TO CHANGE IN HOSTNAME
IC99642	2	POSSIBLE CACHE CORRUPTION(SEGV/CRASH): ENTRY CAN BE FREED BY ONETHREAD AND ADDED TO LRU BY ANOTHER AT THE SAME TIME
IC97925	2	DB2CAT LEAKS MEMORY FOR EACH TABLE PROCESSED
IT00237	2	NNSTAT MAY FAIL WITH SQL0181N/SQL0180N ERROR WITH METHOD 0 OR 1
IC97881	2	DURING VIEW REGENERATION , DROPPING OF STATISTICS DON'T SET STATISTICS_PROFILE COLUMN OF SYSTABLES CATALOG TABLE TO NULL.
IC96117	2	POST UPGRADE TO V10.5 DDL ON TABLE HAVING TEXT INDEX MAKES THE TABLE UNUSABLE
IC97091	2	CAN NOT UPDATE EXISTING DB2 V10.5 GA/FP1 PURESCALE INSTANCE USING SIMPLIFIED METHOD FROM UNIVERSAL FIX PACK IMAGE
IC95503	2	WITHOUT UPGRADE_PRIOR_VERSIONS=TRUE, THE UPGRADE IS TREATED AS ANEW INSTALLATION
IC96407	2	MARK LIBDB2XML4C57.0.A, LIBDB2CLIXML4C.A AS HYBRID FILES IN AIX64.
IC96662	2	THE ALL_ARGUMENTS AND USER_ARGUMENTS VIEWS WON'T LIST ARGUMENTS DECLARED WITHIN A MODULE.
IC95507	2	LDAP LIBRARIES ARE MISSING AFTER AN INSTALLATION DONE WITH A RESPONSE FILE GENERATED BY DB2RSPGN
IC95525	2	32-BIT IBM DB2 ODBC DRIVER NOT ENABLED FOR CONNECTION POOLING, ON 64-BIT WINDOWS INSTALL
IC97922	2	DB2START COMMAND FAILS WITH SQL1698N REASON CODE: "7" IN DB2 V10.5 AFTER INSTANCE UPGRADE.
IC96361	2	DB2 WSE : DB2LICM -G OUTPUT SHOULD DISPLAY A VIOLATION WHEN COMPRESSION IS USED
IT01768	2	DB2 INSTALLATION WITH UPGRADE OF EXISTSING DB2COPY MIGHT FAIL IFTHERE IS ANY WINDOWS SERVICE WHICH IS AUTO_START AND ITS PATH N
IC94890	2	THERE MIGHT BE A DOUBLE FREE OR LIST CORRUPTION IN THE SQLRLC_CSM_DEFUNCT() FUNCTION
IC95674	2	PACKAGE TEXT SEARCH COMPONENT IN DB2 EXPRESS EDITION ( REMOVED EARLIER VIA DEFECT:WSDBU00928276 )
IC99257	2	DATABASE UPGRADE MISSES TO UPGRADE MQT VIEW DEPENDENCY
IC96330	2	SQL0901N REASON "COLUMN NUMBER OUT OF RANGE" WHEN SELECTING FROMTABLES RELATED VIA FOREIGN KEY, AFTER ALTER DROP COLUMN
IT03454	2	SQL1499W WHEN UPGRADING DATABASE
IC94338	3	DB2SETUP WILL UPDATE SVCENAME WITH PORTNUMBER INSTEAD OF SERVICENAME.
IC99238	3	DB2ICRT COMMAND SKIPS SOME OPEN PORTS RANGE IN /ETC/SERVICES DURING FCM PORTS RESERVATION
IC98234	3	DB2PREREQCHECK MAY PRINT OUT UNNECESSARY QUOTES.
IC97602	3	AFTER LOGS BECOME FULL, AN INSERT INTO A GLOBAL TEMPORARY TABLE (DGTT) FAILS WITH SQL0901N
IC99705	3	SYSTEM GENERATED FUNCTIONS ARE INCORRECTLY OWNED BY THE INSTANCEOWNER.
IT00347	3	SQLRLC_FED_LOAD_ENTRY, PROBE:10 WAS RECORDED AS SEVERE IN DB2DIAG.LOG.
IT01917	3	COLLATIONNAME IN SYSCAT.COLUMNS MIGHT BE CHANGED UNEXPECTEDLY TONON_UNIQUE IF LENGTH OF COLUMN IS ALTERED
IT01041	3	INSTALLFIXPACK COMMAND FAILS WHEN -C OPTION IS SPECIFIED.
IC99029	3	ALTER INDEX ON TABLE CORRUPTS AUDIT LOG FILE
IT02900	3	REMOVE SOLARIS OS LEVEL VERIFICATION FROM DB2PREREQCHECK DUE TO INCONSISTENT /ETC/RELEASE VALUES
IT01225	3	DB2CKUPGRADE MIGHT REPORT: "SQL1344N ORPHAN ROWS FOUND" IF THERE ARE INVALID OBJECTS IN THE DATABASE
IC96483	3	IMPLEMENTATION FIELD IN SYSCAT.ROUTINES FOR A SOURCED FUNCTION MISSING MODULE NAME & MAY BE AMBIGUOUS IF IDENTIFIER HAS PERIODS
IC96362	3	DURING SILENT INSTALLATION OF DB2 RUNTIME CLIENT, IF CREATE_ICONIS SET TO NO, DB2.EXE IS NOT INSTALLED.
IC99342	3	DB2 NOT REGISTERED AS THE DEFAULT COPY WHEN IT IS THE ONLY COPY AND DEFAULT_COPY=NO & DEFAULT_CLIENT_INTERFACE_COPY=NO
IC97720	3	DB2START FAILS TO LOAD LIBDB2BLU.A ON AIX DUE TO INCORRECT SOFT LINK
IC98154	3	USABILITY: INSTANCE CREATION, UPGRADE, UPDATE HARD FAILS IF IT IS NOT ABLE TO RESERVE 4 PORTS IN /ETC/SERVICES FOR AN ESEINSTAN
Fix Pack 4 - JDBC Driver
IT04170	3	CONNECTION.ISVALID(INT TIMEOUT) API DOES NOT WORK EXPECTEDLY
IT04211	3	WHEN USING XADATASOURCE WITH ENABLESYSPLEXWLB=TRUE, A GRADUAL AND PERMANENT GROWTH IN TRANSPORT OBJECTS MAY OCCUR
IT00724	2	BUGCHECKEXCEPTION: BUG CHECK EXCEPTION THROWN DUE TO AN INTERNAL JCC ERROR ... SEVERITY CODE 8 ... ERRORCODE=-4228
IT04234	1	THE JCC DRIVER WILL NOT HOLD TRANSPORT UNTIL THE END OF NEW UNIT OF WORK
IT03807	3	JCC: SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION IGNORED FOR EMBEDDED SELECTS
IT02093	2	CLIENT AFFINITIES FAILBACK MAY NOT SUCCEED EVEN IF THE PRIMARYSERVER IS UP
IT02665	2	JCC PROPERTIES SUCH AS CURRENTSCHEMA ARE SOMETIMES IGNORED.A POSSIBLE SYMPTOM IS AN SQLEXCEPTION WITH SQLCODE=-204
IT04136	2	ERROR PARSING INTEGER LITERAL IF SQL CALL STATEMENT CONTAINS ANY CARRIAGE RETURN
IT04550	2	APP HANG MAY OCCUR FOR CLOB COLUMNS WHENFULLYMATERIALIZELOBDATA IS FALSE AND PROGRESSIVESTREAMING IS 2. FULLYMATERIALIZELOBDATA IS FALSE AND PROGRESSIVESTREAMING IS 2
IT04563	3	PREPAREDSTATEMENT.SETBYTES() AGAINST VARCHAR COLUMN GETS ILLEGAL CONVERSION EXCEPTION CONVERSION EXCEPTION
IT04461	3	SQLCODE -10 IS RECEIVED WHEN USING SETDB2CLIENTXXX API TO SET A VALUE THAT CONTAINS A SINGLE QUOTE
IT02152	2	XAER_PROTO. ERRORCODE=-4203, ERROR RETURNED WHEN FIRST QUERY FAILS IN A TRANSACTION
IT04609	3	TO DOCUMENT ALL THE JCC APAR AND DEFECTS SHIPPED WITH DB2V10.5FP4 RELEASE
Fix Pack 4 - Monitoring
IC96140	1	ADMIN_MOVE_TABLE AND DB2CONVERT FAIL WITH SQL2105N (REASON CODE 10) IF THE TABLE HAS CLUSTER INDEX
IC94257	1	LOCKING EVENT MONITOR CONTAINS INVALID DATA IN PARTICIPANT_ACTIVITIES WHEN PARTICIPANT IS COMPILING SQL
IC95392	1	MON_GET_PAGE_ACCESS_INFO() CAN END UP WITH SEGV (CRASH/ABORT) OREVENTUALLY MEMORY CORRUPTION
IC96028	2	POTENTIAL HANG ON TRANENTRY LATCH IN SQLPM_WRITE_APPL_LOCKS DURING LOCK SNAPSHOT
IT02311	2	PANIC IN SQLO_XLATCH::RELEASE CONFLICT WHEN UNLOCKING AN UNLATCHED LOCK
IC97955	2	ADMIN_MOVE_TABLE FAILED WITH SQL0104N IF THE SOURCE TABLE HAS NOINDEX AND THE 1ST COLUMN SIZE EXCEEDS THE MAX KEY LENGTH LIMIT
IT01066	2	ADMIN_MOVE_TABLE FAILS WITH SQL2103N RC=17 IF TARGET TABLE HAS AN INDEX NOT MATCHING THE INDEX ON SOURCE TABLE
IC94674	2	THE PROCEDURE SYSPROC.ADMIN_MOVE_TABLE STRIPS SPACES FROM OR ADDS SPACES TO THE END OF A TABLE NAME.
IT01877	2	ADMIN_MOVE_TABLE INCORRECTLY CHANGES THE TYPE OF THE TABLE FROM ROW TO COLUMN IF DFT_TABLE_ORG SET TO COLUMN
IC96779	2	ADMIN_MOVE_TABLE (AMT) CLEANUP AGAINST A SINGLE TABLE CALLS ADMIN_GET_TAB_INFO FOR THE WHOLE SCHEMA
IC98900	2	LOCKING EVENT MONITOR NOT POPULATING LOCK_ACTIVITY_VALUES_EVM_LOCK_FT1 ON DPF
IC95505	2	ADMIN_MOVE_TABLE DOESN'T RECREATE THE SECURITY LABEL ON A COLUMN
IT01362	2	IN XA ENVIRONMENT WITH ONEPHASE COMMIT OPTIMIZED TRANSACTIONS, LOW NUMBERS OF COMMITS REPORTED
IC96535	2	POTENTIAL HANG ON TRANENTRY LATCH IN SQLPM_WRITE_APPL_LOCKS DURING LOCK SNAPSHOT
IT00379	3	ADM2017C MAY BE OCURRED EVEN IF FILESYSTEM HAS ENOUGH ROOM.
IC95520	3	WHEN USING ADMIN_MOVE_TABLE, THE STAGING AND TARGET TABLE IS NOTCLEANED DURING THE CANCEL OPERATION WHEN INIT PHASE FAILS.
IC98018	3	IF A TABLE HAS DB2SECURITYLABEL COLUMN, ADMIN_MOVE_TABLE FAILED WITH SQL0683N.
IC97882	3	WHEN USING ADMIN_MOVE_TABLE WITH COPY_STATS OPTION ON SWAP PHASE, IT COULD FAILS WITH SQL2102N, REASON CODE 28.
IC97341	3	INCORRECT TABLE TYPE IN THE OUTPUT FROM MON_GET_TABLE
IC95543	3	MICROSECONDS PORTION IN RESOLUTION_TIMESTAMP IS ALWAYS 0
IC97604	3	ADMIN_MOVE_TABLE DOES NOT PROVIDE CORRESPONDING LOAD OPTION "TEMPFILES PATH"
IC95215	3	DEACTIVATE EVENT MONITOR MAY CAUSE MISLEADING SQLO_INTRP ERRORS ON NON-CATALOG PARTITION IN DB2DIAG.LOG
IT01968	3	LOCK TIMEOUT INCREMENTS BEFORE ACTUAL TIMEOUT IN SYSIBMADM.SNAPDB WHEN EVENT MONITOR IS ON.
IT01847	3	ADMIN_MOVE_TABLE MAY RETURN SQL20242N IF DEEPCOMPRESSION_SAMPLE IS SET TO A SMALL VALUE FOR A LARGE SOURCE TABLE.
IC98395	3	ON SOME RARE OCASIONS, LOCKING EVENT MONITOR MIGHT FAIL TO REPORT ALL PARTICIPANTS OF A DEADLOCK
IT01835	3	COUNTS FOR FCM METRICS DO NOT MATCH WAIT TIMES IN ROW BASED INTERFACES
Fix Pack 4 - Parsing and SQL PL
IC95897	2	CALLING A SQL STORED PROCEDURE AFTER MIGRATION FAILS WITH EITHERAN SQL1224 OR SQL0471 ERROR IT MAY ALSO TRAP
IC97062	2	SQL20046N USING STORED PROCEDURES
IC98438	3	DYNAMIC STATEMENT NOT FOUND IN STATEMENT CACHE AND RECOMPILED UNNECESSARILY RESULTING IN POOR RUN TIME PERFORMANCE
Fix Pack 4 - Platform Specific
IT01183	2	SETTING DB2PATH MAY CAUSE FAILURE TO START THE INSTANCE
IC99053	2	CURRENT TIMEZONE SPECIAL REGISTER MAY GIVE WRONG RESULT ON SUN PLATFORM BEING ACCESSED CONCURRENTLY.
IT01328	2	INSTANCE ABEND IN DB2STMM WHEN EVALUATING SCALAR AGGREGATE OPERATORS.
IC98528	2	POSSIBLE HIGH CPU USAGE OF FUNCTION STMMPCFINDSIMVAR UNDER VERY HIGH WORKLOAD
IC97734	2	DB2START RETURNS SQL6030N START OR STOP DATABASE MANAGER FAILED. REASON CODE "4".
IC98911	2	DB2 CACHES GROUP MEMBERSHIP OF LOCALSYSTEM (SYSTEM) UNTIL NEXT INSTANCE RECYCLING.
IT00394	2	IF CONNECTING TO A DATABASE ON WINDOWS THROUGH IBM SSH, SOME SQLS FROM DATA STUDIO FAIL WITH '< WRONG USAGE' MESSAGE
IC95488	2	STMM UNNECESSARILY DECREASES CONFIGURATION WHEN 0 BENEFIT DETECTED
IC95516	2	SQL30082N RC=24 ERROR MAY OCCUR USING PAM_KRB5.SO WITH TRANSPARENT LDAP
IC94990	2	GETTING PASSWORD EXPIRED WHEN USING TRANSPARENT LDAP WITH KERBEROS
IC99707	3	RUNSTATS COMMAND CAN POTENTIALLY HANG IF RUN WITH UTIL_IMPACT_PRIORITY CLAUSE.
IC97287	3	ON SOLARIS, ONCE DIO IS ENABLED THERE IS NO WAY DISABLE IT WITHIN DB2.
IC96640	3	IF THE DB2SYSC PROCESS DEPLETES THE PROCESS HEAP AN ATTEMPT TO ALLOCATE ADDITIONAL MEMORY MIGHT LEAD TO A PROCESS TRAP.
IC95528	3	STMM ON 32-BIT INSTANCE PLATFORM MAY FAIL TO UPDATE PCKCACHESZ WHEN IT IS WORKING ON 64-BIT WINDOWS
IC96751	3	LOAD FROM CURSOR MAY ACCUMULATE WINDOWS EVENT HANDLES OVER TIME
IC95506	3	DB2OSCONF DOES NOT SHOW SEMUME IN HP-UX.
IT00844	3	DB2PROFILE SCRIPT CAN CALL THE USERPFROFILE SCRIPT MORE THAN ONCE.
IC99236	3	MEMORY LEAK POSSIBLE ON WINDOWS IF A WINDOWS PERFORMANCE API FUNCTION RETURNS AN UNEXPECTED RETURN CODE
IC99100	3	SQL1042C / ECF_FILE_DEVICE_UNAVAILABLE ERROR CONNECTING TO DATABASE WITH SERVER_ENCRYPT AUTHENTICATION
IC96745	3	IN A DPF, IF AGENTPRI IS CHANGED, DB2START GETS SQL1042C AND DB2INSTANCE CAN'T START.
IT01571	3	SQL AGAINST A TABLE FAILS WITH ERROR SQL0901N , WHEN COMPLEX TRIGGERS/FUNCTIONS WITH MERGE ARE DEFINED ON THAT TABLE
IC97880	3	CONTAINER RESIZE BEYOND 16 TB DOES NOT FAIL AND CAUSES UNEXPECTED RESULTS.
Fix Pack 4 - Problem Determination
IC97389	2	IN SOME RARE CIRCUMSTANCES THE PD_GET_DIAG_HIST() TABLE FUNCTIONMAY HANG.
IT01248	2	PD_LOG_GET_MSGS OR USING THE SYSIBMADM.PDLOGMSGS_LAST24HOURS MAYALLOCATE EXCESSIVE MEMORY
IC95366	2	DB2PD AND DB2PDCFG COMMANDS TERMINATE ABNORMALLY WHEN DB2AUDIT IS ENABLED ON WINDOWS PLATFORM
IT00865	2	DB2DIAG -STRICT DISPLAYS INCORRECT OUTPUT: NO FUNCTION VALUE DISPLAYED, EDUNAME IS ISSUED ONLY PARTIALLY
IC94546	2	IN SOME CASES CALLING 'USER-SPECIFIED PROFILE' FROM DB2SUPPORT MAY CAUSE SCRIPT TIME-OUT REGARDLESS OF THE SETTING OF 'TIMEOUT'.
IC98078	2	OPTIMIZER DB2SUPPORT COLLECTION IS NOT SUCCESSFUL
IT03585	2	DB2PD -MEMBLOCK PID=<DB2SYSC PID> MAY FAIL WITH PDPROCGETMEMMAP RC = 1
IT02957	2	DB2SUPPORT WITH CL1 OPTION DOES NOT COLLECT INFORMATION FOR THE CDE COLUMNS
IC99776	2	DB2TOP GRANULARITY IN BACKGROUND MODE FOR DATABASE METRICS
IC99807	2	CRASH IN DB2TOP COLLECTOR MODE WHEN COMPRESSING THE SNAPSHOT DATA
IC97884	2	CALLING PD_GET_DIAG_HIST IN DB2 V10.1 FP3 ON PLATFORM WINDOWS RESULTS IN AN ERROR
IT01345	2	PD_GET_LOG_MSGS TABLE FUNCTION 'TIMESTAMP' PARAMETER ACTS AS IF ONLY NULL IS PASSED
IC98022	2	DB2DART CRASH IN MEMORY VALIDATION
IC94860	2	DB2TRC BUFFER ALLOCATION
IT00383	2	DB2SUPPORT WRONGLY ASSUMES SHARED PATH IF DB2DIAGPATH IS NOT SPLIT AND HAS THE SAME VALUE ON MULTIPLE NODES
IC99540	3	DB2TOP IN BACKGROUND REPLAY MODE IGNORES THE FIRST SNAPSHOT STREAM DATA
IC99235	3	DB2CAEM FAILS IF THE SQL INPUT CONTAINS A COMMENT "--" WHICH IS NOT AT THE START OF A LINE
IC99211	3	ON WINDOWS, AN ADMIN MESSAGE MAY BE LOGGED IN DB2DIAG.LOG AND WINDOWS EVENT LOG WITH DIFFERENT LEVEL
IC96247	3	A LOCK ON THE NOTIFY LOG OR DB2DIAG.LOG CAN MAKE THE ENGINE SO SLOW THAT IT WOULD LOOK LIKE A HANG
IC95457	3	DB2PD -DBP NUMBER -EVERYTHING RETURNED "INVALID -DBP SUBOPTION. PROVIDE DATABASE PARTITION NUMBER."
IT01224	3	DB2SUPPORT -PURESCALE OR -CM OPTION CANNOT COLLECT GETSADATA.
IC96431	3	DB2PD -REORG ON HADR STANDY TRAPS WHEN THE TABLE NAME OR SCHEMA HAS NOT BEEN ALLOCATED WITHIN THE TCB
IT00595	3	DB2SUPPORT COMMAND FAILS FOR SOLARIS 10 USERS WHEN WHOAMI COMMAND IS NOT AVAILABLE FOR SHELL
IC96366	3	A LOCK ON THE NOTIFY LOG OR DB2DIAG.LOG CAN MAKE THE ENGINE SO SLOW THAT IT WOULD LOOK LIKE A HANG
IC95209	3	INSTANCE CRASH DURING MIGRATING OR RESTORING DATABASE FROM LOWERRELEASE WHEN DB2TRC IS ENABLED
IC98256	3	DB2SUPPORT DOES NOT COLLECT DB2DIAG.LOG ON WINDOWS WHEN $M IS USED IN DIAGPATH
Fix Pack 4 - Process Model
IC99683	1	DB2 STORED PROCEDURES ARE UNABLE TO LOAD THE GSKIT SHIPPED WITH DB2
IT01349	1	DB2 STORED PROCEDURES ARE UNABLE TO LOAD THE GSKIT SHIPPED WITH DB2
IC96432	2	UPDATING LOGARCHMETH1 DATABASE CONFIGURATION PARAMETER WHILE A DATABASE IS BEING ACTIVATED CAN CAUSE DB2 TO HANG
IC95496	2	DB2 MAY TRAP IN SQLECLEANUPFEDDAEMONANCHOR DURING MULTIPLE LOGICAL NODES STARTUP
IT00835	2	IN LOW OR NO MEMORY CONDITIONS DB2 MAY TRAP IN SQLRR_SQL_REQUEST_PRE
IT01036	2	NORMAL DPF QUERY PROCESSING ON DPF TRIGGERING UNNECESSARY FMP TERMINATION
IC95360	2	DB2 V10.1 DB2INSTANCESTOP() API IS NOT DOWNLEVEL COMPATIBLE, DB2STOPOPTIONSSTRUCT WAS CHANGED
IT01145	2	SQL1052 WHEN DROPPING A DATABASE IN DPF ENVIRONMENT USING RELATIVE PATHS OR SOFTLINKS
IT01037	2	UNSTABLE DB2FMP PROCESSES MAY ACCUMULATE ON SYSTEM RESULTING IN EXCESSIVE MEMORY USAGE
IC98733	2	DB2STOP GOT A SEVERE SQLO_FNEX MESSAGE FOR DB2ADDND.LCK
IC95598	2	THE DB2 REGISTRY VARIABLE DB2_MAX_THREADS_PER_FMP MAY NOT WORK IN A FEDERATION ENVIRONMENT.
IC99237	2	DEADLATCH BETWEEN INSTANCE QUIESCE AND HADR START DUE TO LATCHING ORDER
IC99933	2	DATABASE REMAINS IN QUIESCE STATE AFTER INSTANCE UNQUIESCED
IC95584	2	QUERY ON SYSIBMADM.DBMCFG DOES NOT SHOW "-" WHEN PARAMETER HAS NULL VALUE
IC99935	2	DB2IUPGRADE FAILURE WHEN DB2NODES.CFG CONTAINS VIRTUAL IP ADDRESSES
IC96554	2	DB2CFEXP DOES NOT EXPORT SOME DATABASE MANAGER CONFIG PARAMETERS.
IT01659	2	DB2 AUTOCONFIGURE WILL RETURN SQL0450N IF THE DATABASE HAS A LARGE NUMBER OF BUFFER POOLS
IC98258	2	INSTANCE MAY CRASH IN SQLOCRASHONCRITICALMEMORYVALIDATIONFAILURE
IT01369	2	PANIC: UNEXPECTED VALIDITY LOTCH RC AT SQLPVALLOTCH::VERIFYRETURNEDRC, PROBE:666 DURING RECOVERY PHASE POST PROCESSING
IT02581	2	TRAPS AND/OR CRASHES IN DPF DURING QUERY ACTIVITY AGAINST A DB THAT WAS PREVIOUSLY CREATED WITH A REDIRECTED RESTORE
IT01953	2	ERROR SQL0843N WHEN CONNECTING TO AN INFORMIX DATABASE WITH A NAME LONGER THAN 18 CHARACTERS
IC98573	3	MAKE CERTAIN SQLERINVOKEFENCEDROUTINE AND SQLERRETURNFMPTOPOOL MESSAGES IN DB2DIAG.LOG WARNING INSTEAD OF ERROR OR SEVERE
IT00764	3	INCORRECT WARNING SQL1363W RAISED WHEN UPDATING A DB CFG PARAMETER ON INACTIVE DATABASE
IC97759	3	UPGRADE FROM DOWNLEVEL PERMITS OTHER CONNECTION FROM SAME USER PERFORMING UPGRADE TO CONNECT AND CRASH THE SERVER.
IT00841	3	SQL5060N RECEIVED WHEN FETCHING DATABASE MANAGER PARAMETER VALUES FROM A DOWN LEVEL INSTANCE.
IC95069	3	IN V10.5 DB2DIAG.LOG, SOME REDUNDANT MESSAGES THAT SHOULD NOT BEDUMPED MIGHT BE DUMPED WHEN DB2START.
IC96914	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
IC95245	1	DB2 CAN TRAP WHEN COMPILING A SUB-QUERY THAT IS APPLIED ON XMLQUERY()
IT01084	1	SQL STATEMENT WITH UNCORRELATED SUBQUERY PREDICATE MIGHT RETURN INCORRECT RESULTS WHEN INTRA_PARALLEL IS ENABLED
IC99630	1	PD CORRUPTION ON TABLE AFTER ALTER TABLE ADD OR REMOVE A COLUMN WHEN RTS IS ENABLED
IC97607	2	DB2ACD PROCESS CAN ABEND WHEN IT PROCESSES FEDERATED TABLES FOR AUTOMATIC RUNSTATS.
IC99122	2	PERFORMANCE COULD BE POOR WHEN A SMALL NICKNAME JOINS A LARGE NICKNAME JOIN RESULT
IC97099	2	LARGE SORT HEAP USAGE WHEN 0-CARDINALITY INDICATED ON SORT OPERATION
IC98807	2	QUERY MAY PERFORM BAD WHEN CONTAINS OR SCORE FUNCTIONS ARE USED WITH VARIABLES IN THE SEARCH STRING AND REOPT ONCE IS SPECIFIED
IT00605	2	DB2 OPTIMIZER CAN CHOOSE A NON-OPTIMAL BLOCK INDEX TO ACCESS MDCTABLE WHEN THE BLOCK INDEXES HAVE ONLY 1 LEVEL
IC98771	2	DB2 OPTIMIZER MAY USE FREQUENCY VALCOUNT IN SYSSTAT.COLDIST INCORRECTLY AND GIVE SUB-OPTIMIAL ACCESS PLAN.
IT00521	2	INCORRECT RESULT CAN BE RETURNED FOR COLUMN-ORGANIZED TABLES
IT02259	2	FORCING APPLICATION CAN TAKE A LONG TIME TO TAKE EFFECT WHEN OPTIMIZER COMPILES A COMPLEX QUERY USING GREEDY JOIN ENUMERATION
IT01024	2	POSSIBLE WRONG RESULTS WHEN INDEX JUMP SCANS ARE USED IN REFERENTIAL INTEGRITY CHECKING
IC97866	2	RUNNING DB2ADVIS TO RECOMMEND MQT CAN CAUSE DB2 TO TRAP WHEN THEINPUT QUERY CONTAINS SUB-QUERIES THAT MEET CERTAIN CONDITIONS
IT03293	2	IN DPF ENVIRONMENT THE DB2 OPTIMIZER MIGHT PRODUCE A NON-OPTIMALACCESS PLAN WHEN DB2_WORKLOAD=SAP
IT01796	2	OPTIMIZER COMPUTES INCORRECT CARDINALITY ESTIMATE IN PRESENCE OFSTATISTICAL VIEW WITH A PREDICATE THAT HAS AN EXPRESSION
IT02618	2	AUTO REORG MAY NOT RECLAIM SPACE FOR COLUMN-ORGANIZED TABLES
IC98180	2	WHEN INTRA_PARALLEL ENABLED, AN SQL STATEMENT MIGHT FAIL WITH SQL0901N IN SQLNO_SMP_CREATE_PGBY
IT01804	2	DB2 OPTIMIZER MAY CHOOSE TO DEFER PROCESSING DISTINCT CLAUSE OF A UNION-BRANCH
IC99703	2	THE SQL0437W MIGHT BE INDUCED BY RUNSTATS RESULTING IN INCORRECTCOLCARD VALUE
IC98321	2	DB2 MIGHT TRAP WHILE COMPILING A SQL STATEMENT CONSISTING OF MULTIPLE TABLES JOINED ON THE PARTITION BY RANGE COLUMNS
IT01909	2	VIRTUAL DATABASE PARTITIONING IS NOT USED WHEN EVALUATING PARTITIONING USING THE ADVISOR OR EXPLAIN IN DPF ENVIRONMENTS
IC99233	2	DB2 INSTANCE MAY TRAP WITH SIGNAL#11 WITH FUNCTION SQLNX_EXP_DUMP_DIAG_CACHE.
IV62309	2	DB2 OPTIMIZER MIGHT CHOOSE NON-OPTIMAL JOIN ORDER FOR COLUMN ORGANIZED TABLES THAT JOIN ON THE PRIMARY OR UNIQUE KEY
IT01348	2	DELETE QUERY FAILS WITH -901 ERROR "EMPTY PLAN LIST DETECTED!"
IC97840	2	RUNNING DB2ADVIS TO RECOMMEND DPF PARTITIONING IN ORACLE COMPATIBILITY MODE CAN CAUSE DB2 TO TRAP
IT01844	2	COMPILING AN UPDATE OR A DELETE SQL STATEMENT CAN RETURN SQL0901N WITH REASON "UNABLE TO FORM A PLAN FOR ALL QUNS."
IT00648	2	QUERY WITH JOINS AND SUBQUERY PREDICATES HANGS WHEN DBM CONFIG PARM INTRA_PARALLEL IS YES
IC95518	2	ATM FAILED TO REORG SOME INDEXES WHICH EXCEEDED F4 AND F5 UNDER DB2_WORKLOAD=SAP
IT01088	2	SQL STATEMENT WITH ORDERED COLUMN GROUP OR PREDICATES MIGHT RETURN INCORRECT RESULT SET WHEN JUMP SCAN USED
IT01092	2	QUERY PERFORMANCE CAN SUFFER DUE TO INCORRECT INDEX SCAN COST CALCULATION ON DB210 ( LUW ) RELEASES
JR49708	2	WHEN DB OPTIMIZATION CLASS SET TO "5"; SOME QUERIES USING NICKNAMES TO ORACLE TABLES RETURN ERROR :SQL0
IC97063	2	DB2 MIGHT ABEND WHILE COMPILING SQL QUERY.
IC98924	2	DB2 MIGHT TRAP WHILE COMPILING A SQL STATEMENT THAT IS ELIGIBLE FOR ZIGZAG JOIN
IT01742	2	INCORRECT SMP PLAN CHOSEN FOR INSERT FROM SELECT.
IT01347	2	DB2 MIGHT TRAP WHILE COMPILING A SQL STATEMENT WITH A DISTINCT CLAUSE WHEN INTRA-PARTITION PARALLELISM IS ENABLED
IT01475	2	DB2ADVIS MAY HANG ON DATABASE THAT ENABLES DATE AS TIMESTAMP (0)SUPPORT
IC97986	2	OPTIMIZER MIGHT FAVOUR HSJOIN OVER AN ORDERED NLJOIN
IC97009	3	DB2 NOT GENERATING TBSCAN ON INNER OF NLJN WHEN OUTER CAN HAVE ONLY 1 ROW
IC96658	3	DB2 OPTIMIZER MIGHT NOT CHOOSE A ONE-FETCH GROUP BY WHEN CARDINALITY IS UNDERESTIMATED
IT01794	3	QUERIES CONTAINING COMPLEX OR PREDICATE WITH THE SAME COLUMN REFERENCED IN MULTIPLE SUBTERMS MAY EXPERIENCE POOR PERFORMANCE
IT02048	3	INCORRECT STATS COLLECTED BY AUTORUNSTATS WHEN IMPORT COMMAND RUNS FOR LONGER DURATION HOLDING THE LOCK ON CATALOG TABLES
IT01173	3	SQL0901 REASON "ORDER COLS REMOVED FROM SORT OUTPUT COLS." WITH DB2_WORKLOAD=PUREDATA_OLAP
IT01941	3	DB2 CAN TRAP WHEN COMPILING A SQL STATEMENT THAT FITS THE CRITERIA FOR ZIGZAG JOIN
IT01638	3	QUERIES INVOLVING ZIGZAG JOIN MAY GET UNEXPECTED SQL0811N ERROR
IT02546	3	COMPILING A SQL STATEMENT CAN RETURN SQL0901N WITH REASON "TOO MANY COLUMNS OR RECORD LENGTH EXCEEDED."
Fix Pack 4 - Query Compiler QGM
IC95526	1	MERGE STATEMENT WITH ONLY MATCHED CONDITION AND DISTINCT MIGHT LEAD TO PERFORMANCE DEGRADATION
IT00270	1	SQL QUERY CONTAINS NOT EXISTS SUBQUERY AND NODENUMBER PREDICATE MIGHT PRODUCE AN INCORRECT RESULT
IT02262	1	DB2 MIGHT PRODUCE INCORRECT RESULTS FOR QUERY WITH MULTIPLE QUANTIFIED SUBQUERIES IN OR PREDICATE
IC99234	1	IMPROVE QUERY PERFORMANCE WHEN QUERY CONTAINS CARTESIAN JOIN OVER SELECT DISTINCT FROM ALIAS
IT00382	2	SELECT INTO GLOBAL VARIABLE WITH 'FOR UPDATE' SPECIFIED RETURNS SQL0151N ERROR
IC98910	2	A VALUE ASSIGNMENT FROM ARRAY OF ROW DATA TYPE TO ROW DATA TYPE MIGHT CAUSE AN INSTANCE CRASH.
IT00859	2	DB2 MIGHT PRODUCE SQL0901N ERROR WHEN EXECUTING QUERY WITH PREDICATES WITH TIMESTAMP DURATIONS
IT01540	2	SET INTEGRITY IMMEDIATE UNCHECKED FAILED WITH SQL20209N IF THE PARTITIONING KEY CONTAINS GENERATED COLUMN
IT02352	2	DEPENDENT OBJECTS MAY NOT GET INVALIDATED WHEN A COLUMN OF A TEMPORAL TABLE IS ALTERED OR DROPPED, LEADING TO SQL0901N ERRORS
IC96236	2	QUERY ON VARCHAR2 ENABLED DATABASE DOES NOT USE INDEX SCAN
IC99583	2	DB2 MIGHT PRODUCE INCORRECT RESULTS WHEN EXECUTING QUERY WITH MULTIPLE "IN" LIST PREDICATES ON SAME COLUMN
IT03055	2	BLOB CAST OF CHARACTER STRING HOST VARIABLES CAN CAUSE CODEPAGE CONVERSION TO DATABASE CODEPAGE
IC95329	2	DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF SIMPLE SINGLE-ROW MERGE STATEMENT
IT01253	2	DB2 TRAP IN SQLNQ_HANDLE_MODULE_OBJ_REF WHEN RUNNING CREATE PROCEDURE
IC97011	2	MQT NOT CONSIDERED FOR REWRITE MATCHING IN INSENSITIVE SCROLLABLE CURSOR QUERIES
IC99808	2	DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING NOT IN QUERY WITH CORRELATED SUBSELECT
IC99300	2	SQL20208N RC=4 WHEN DECLARING A GLOBAL TEMPORARY TABLE BASED ON MULTIPLE TABLES WITH DIFFERENT SECURITY POLICIES
IT00654	2	SQL STATEMENT COMPILE RESULTS IN SQLCODE -901 REASON "REQUEST STMT SAVEPT: STMT_SVPT_PTR NOT NULL"
IC98175	2	MERGE COMMAND WITH INSERT IN XML COLUMN RETURN ERROR SQL16084N
IC99130	2	DB2 MAY TRAP IF AGGREGATE FUNCTION NAME IS USED AS AN ARGUMENT TO NESTED PROCEDURE CALL STATEMENT
IC98829	2	A QUERY MAY HANG WHEN IT CONTAINS CONNECT BY AND LEFT OUTER JOIN
IC95383	2	QUERY WITH XQUERY/XPATH OPERATORS MAY RUN SLOWER WHEN UPGRADING FROM VERSION 9.5.
IC95335	2	PERFORMANCE DEGRADATION MIGHT BE NOTICED WITH NOT EXISTS SUBQUERY WITH MULTIPLE TABLES.
IC98378	2	DATABASE MAY CRASH WHEN A REPLICATED MQT IS ENFORCED
IC96122	2	EXPLAINING AN SQL STATEMENT ACCESSING COLUMN-ORGANIZED TABLES IN"RECOMMEND INDEXES" EXPLAIN MODE CAN RESULT IN SQL0901N
IC98756	2	DATE PARAMETER MARKER IS NOT CONVERTED TO TIMESTAMP(0) IN A DATEAS TIMESTAMP(0) ENABLED DATABASE WITH DEFERRED PREPARE ENABLED
IC96428	2	-901 WITH "NO COLUMN INFORMATION FOUND IN THE PACKED DESCRIPTOR" ON CREATE PROCEDURE
IC95426	2	QUERY CONTAINING EXISTS SUBQUERY AND FETCH FIRST N ROWS CLAUSE MIGHT PRODUCE INCORRECT RESULTS
IT02543	2	UPDATE OF TABLE WITH SPECIAL COLUMN THAT IS INDEXED CAN RESULT IN SQL0964C CONDITION
IC97635	2	SOME COMPILER REGISTRY VARIABLES MAY NOT TAKE EFFECT IMMEDIATELYWHEN UPDATED WITH THE IMMEDIATE OPTION
IT00797	2	DB2 CRASHES ON RUNSTATS WITH SQLDINDEXSTATS 'NO COLSTAT STRUCTURE FOUND FOR INDEX WITH ITOKEN' IN DB2DIAG.LOG
IT02544	2	TRAILING BLANKS SILENTLY TRUNCATED FROM LOB VALUES ON STORAGE ASSIGNMENT
IT01516	2	DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERIES WITH MULTIPLE NOT IN SUBQUERIES WITH CORRELATION OR FGAC
IT01000	2	CHAR(' ',0) RETURNS EMPTY STRING INSTEAD OF NULL IN VARCHAR2 ENABLED DATABASE.
IC98203	2	SUBSTRB MAY RETURN WRONG RESULT WHEN START OR LENGTH VALUE IS NULL
IC95288	2	POOR QUERY PERFORMANCE IF JOIN PREDICATE APPLIED TO THE FIRST AND LAST COLUMNS OF AN INDEX WITH INTERMEDIATE LOCAL PREDICATES
IT01662	2	INCORRECT RESULTS MIGHT BE PRODUCED WITH PREDICATES INVOLVING NULL CONSTANTS
IC99367	2	MAY RECEIVE SQL0811N WHEN A QUERY OR SUB-SELECT IS USED IN SCALAR CONTEXT AND RELATED TABLE IS COLUMN ORGANIZED
IC96350	2	MQT OR STATISTICAL VIEW MAY BE NOT MATCHED OR IMPROPERLY MATCHED
IC98954	2	COMPILING A QUERY CAN ABEND WHEN A TABLE IN THE QUERY HAS CGS, AND IF RTS UPDATES THE TABLE'S STATISTICS DURING COMPILATION.
IT01256	2	QUERY MIGHT HAVE OR PREDICATE WRONGLY REMOVED RESULTING IN EXTRAROWS IN THE RESULTS
IT02080	2	AN SQL STATEMENT WITH UNCORRELATED SUBQUERY USED WITH A QUANTIFIED OR IN PREDICATE MAY RETURN SQL119N
IT00755	2	DB2 MIGHT PRODUCE SQL0901N MESSAGE WHEN EXECUTING MULTIPLE SUBQUERIES USING COLUMN STORE TABLES
IC95225	2	SET VARIABLE STATEMENT MAY CAUSE DB2 TO TERMINATE ABNORMALLY.
IC95256	2	AN INSERT, UPDATE OR DELETE STATEMENT ON A TABLE WITH ROW AND COLUMN ACCESS CONTROL ENABLED MAY RESULT IN SQL901N OR SQL1224N.
IT02131	2	AN SQL QUERY WITH ROW ACCESS CONTROL AND NOT SECURED FUNCTIONS CAN RETURN SQL0901N
IT01583	2	STDDEV, VAR AND VARIANCE WITH INTEGER INPUT RETURN WRONG DATA TYPE WHEN NUMBER SUPPORT IS ENABLED
IC99952	2	USING ADMIN_MOVE_TABLE ON TABLE WITH GENERATED COLUMN REFERENCEDBY MDC KEY RESULTS IN SQL20209N
IC95490	2	QUERY WITH NOT EXISTS PREDICATES MIGHT HAVE PERFORMANCE DEGRADATION
IC99315	2	QUERY PERFORMANCE MAY BE POOR IN A FEDERATED DPF ENVIRONMENT FOR QUERIES INVOLVING THE LATERAL KEYWORD IN THE STATEMENT TEXT
IC98149	2	BUILT-IN STRING FUNCTIONS MAY RETURN AN INCORRECT RESULT OR FAILWITH SQL0901N WHEN CODEUNITS16 OR CODEUNITS32 IS SPECIFIED
IC97936	2	SQL0901N REASON "SQLNQ_PSM_SEM_ACT" FROM PL/SQL ROUTINE WITH FOR-LOOP CURSOR OVER A JOIN OF MULTIPLE COMMON TABLE EXPRESSIONS
IC99404	2	MERGE STATEMENT RETURNS SQL0901N ("COLUMN NUMBER OUT OF RANGE")
IC99546	2	ADJUST FILTER FACTOR FOR RCAC'S VERIFY_* FUNCTIONS LIKE VERIFY_ROLE_FOR_USER()
JR50091	2	PREDICATES CONVERTED FROM (Q1.COA_FUND LIKE 'P2%') HAS PROBLEM AND CAUSED UNEXPECTED RESULT
IC94038	2	SQL20454N OR SQL0204N FROM PACKAGE CURSOR QUERY CONTAINING A CURSOR PARAMETER
IC99902	2	SQLSTATE 01503 WARNING RETURNED AFTER FETCH TO ANCHORED ROW TYPEGLOBAL VARIABLE
IC99510	2	DB2 MIGHT PRODUCE SQL0551N WHEN CREATING A COMPILED ROUTINE OR TRIGGER REFERENCING DGTT
IT01542	2	QUERY CONTAINING CONSTANT BEFORE OLAP FUNCTION MAY FAIL WITH -901: UNEXPECTED NULL ZVALUE OR ABEND WITH SEGV IN SQLRISET
IC95241	2	DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF SIMPLE SINGLE-ROW MERGE STATEMENT
IC95491	2	QUERY WITH NOT EXISTS PREDICATES MIGHT HAVE PERFORMANCE DEGRADATION
IC98750	2	SUBQUERIES REFERENCING AN ALWAYS FALSE PREDICATE MIGHT NOTICE BAD PERFORMANCE
IC96363	2	QUERY WITH TABLES FUNCTIONS AND EXISTENTIAL SUBQUERY MIGHT PRODUCE SQL0901N
IC97916	2	QUERY MAY RETURN INCORRECT RESULTS WHEN IT CONTAINS A SUB-SELECTWITH CORRELATION AND A FETCH FIRST N ROWS CLAUSE
IC98527	2	INTERNAL ERROR SQL0901N WITH NOT IN PREDICATE
IT01175	2	SQL FUNCTION CONTAINING XML ARGUMENTS MIGHT CAUSE DB ABEND
IC99612	2	ERROR CODE -901 WHILE EXECUTING A SELECT STATEMENT - MESSAGE "COLUMN NUMBER OUT OF RANGE "
IT01899	2	DB2 MIGHT PRODUCE INCORRECT RESULT WHEN REFERENCING EMPTY TABLE WITH AGGREGATE FUNCTIONS IN SUBSELECT
IC96347	3	QUERY COMPILATION SHOULD RETURN SQL0418N IF IT HAS UNTYPED GROUPING SETS COLUMN
IC97349	3	IN A RARE SCENARIO, REPLICATED MQTS ARE NOT EXPLOITED TO IMPROVEPERFORMANCE OF QUERIES
IC96746	3	QUERY CONTAINING DUPLICATE BRANCHES MIGHT CAUSE PERFORMANCE DEGRADATION
IT01764	3	TRANSLATE BUILT-IN FUNCTION FAILS WITH SQLSTATE 57017 ON UNICODEDATABASE
IC97308	3	WE HAVE AN ISSUE WHEN CREATING PL/SQL FUNCTIONS WHEN AUTO_REVAL=DEFERRED_FORCE IS ENABLED
IC96373	3	UDI QUERY MIGHT PRODUCE SQL0901N WHEN EXTENDED INDICATOR OPTION IS ON
IC96973	3	SQL ROUTINES THAT USE THE SAME VARIABLE FOR BOTH THE IN AND OUT PARAMETERS MAY RETURN NULL
IC95665	3	SQL0153N INSTEAD OF SQL0783N ERROR IS RETURNED , IF DECLARE CURSOR OF FOR STATEMENT HAS UNNAMED COLUMN.
IC95549	3	TRANSLATE FUNCTION RETURNS WRONG DATA TYPE WITH MIXED GRAPHIC/NON-GRAPHIC ARGS
IT00948	3	ALTER INDEX TO SET COMPRESS ATTRIBUTE ON INDEX OF GLOBAL TEMPORARY TABLE RETURNS SQL0526 INSTEAD OF SQL0650
IC96486	3	SQL0901N WHEN INSERTING INTO TABLE WITH A TRIGGER CALLING MQ UDF
IC97760	3	QUERY PERFORMANCE ISSUE DUE TO STATISTICS PREVENTING PUSHDOWN OFJOINS
IC96354	3	GET DIAGNOSTICS RETURNS SQL0401N WHEN ROW_COUNT VARIABLE IS DECLARED AS DECIMAL
IC95432	3	VALUES STATEMENT CONTAINING THE VALUE NULL MIGHT RETURN SQL901N IN THE PARTITIONED DATABASE ENVIRONMENT
Fix Pack 4 - Relational Data Services
IT02261	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
IT03340	2	WHEN PCKCACHESZ PARAMETER IS SET TO A VALUE > 524288, THE PACKAGE CACHE WILL BE CLEANED TOO AGGRESSIVELY.
IC96830	2	QUERIES USING ORDER BY CLAUSE MAY FAIL WITH SQL1585N ON THE HADRSTANDBY SERVER(READS ON STANDBY ENABLED)
IT01409	2	DATABASE IS MARKED BAD DUE TO "NO ACTIVE SAVE POINT" ERROR FOR MISHANDLING SAVE POINT WHEN THERE IS AN INTERRUPT.
IC99051	2	RUNSTATS PROFILE DOESN'T ALLOW TO EXCLUDE COLUMNS FROM DISTRIBUTION STATISTICS COLLECTION (NUM_FREQVALUES OR NUM_QUANTILES = 0)
IT01639	2	ANONYMOUS BLOCK FAILS WITH SQL0551N AFTER 3 OR MORE HADR TAKEOVER.
IT03048	2	DATABASE SHUTS DOWN DURING ROLLBACK TO AN EXTERNAL SAVEPOINT IF AN IOE PACKAGE HAS BEEN RECREATED IN THE TRANSACTION
IT01541	2	TRAILING SPACES ON PACKAGE IDENTIFIERS ARE NOT IGNORED, WHICH MIGHT LEAD TO -901 ERROR: SECTION LENGTH MISMATCH
IT02033	2	INSERT/UPDATE/DELETE STATEMENT THAT FIRES A TRIGGER MAY RETURN SQL0901N WITH "SECTION LENGTH MISMATCH"
IC96429	2	INSTANCE MIGHT TRAP WHILE EXECUTING PL/SQL ANONYMOUS BLOCK STATEMENT IF ADDRESS CONNECTION IS USED FOR WORKLOAD ASSIGNMENT
IC97839	2	SQL0901N "ERROR LOADING TYPE PD (SQLRL_FTC_TYPEPD)" FOR EXPLICITREBIND OF A PACKAGE IN DPF
IC96430	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
IC93002	3	STATISTICS MIGHT BE INCORRECT WHEN COLLECTED VIALOAD ON MDC TABLE WITH 1 ROW PER CELL
Fix Pack 4 - Security
IT00804	1	DB2START FAILS WITH SQL1042C ERROR OR CONNECTION FROM DS DRIVER PACKAGE FAILS AFTER AN UPGRADE FROM V9.7 FP9 OR HIGHER
IC97731	1	AUTHENTICATION VERY SLOW ON CERTAIN PSERIES HARDWARE WITH POWER5+ CPU'S
IC96155	2	WHEN DOING SWITCH USER IN A TRUSTED CONNECTION, THE CLIENT OMITSTO SEND USER REGISTRY NAME (USRREGNM) TO THE DATABASE SERVER
IC98255	2	PARAMETER MARKERS CAN UNEXPECTEDLY BE LOGGED WHEN AUDITING A TABLE
IC96368	2	NEW VALUE JCC_ENFORCE_SECMEC FOR DB2 REGISTRY VARIABLE DB2AUTH TO REJECT NON-ENCRYPTED USERNAMES AND PASSWORDS FROM JCC CLIENT
IC95074	2	NEW VALUE JCC_ENFORCE_SECMEC FOR DB2 REGISTRY VARIABLE DB2AUTH TO REJECT NON-ENCRYPTED USERNAMES AND PASSWORDS FROM JCC CLIENT
IC99101	3	IN DB2 GATEWAY, WHEN REMOTE NODE IS CATALOGED WITH SSL ENABLED, MEMORY FOOTPRINT PER CONNECTION IS IMPACTED BY KEY DATABASE SIZE
IC98581	3	DB2AUDIT ERRORS FROM DB2AUD PROCESS WHEN USING KRB_SERVER_ENCRYPT
Fix Pack 4 - Text Search
IC97087	2	A TEXT SEARCH STRING THAT HAS DASH AND A WILDCARD CHARACTER '\"T-S*\"' FAILS WITH IQQS0032E ERROR MESSAGE ON V10.5
Fix Pack 4 - XML
IT01617	2	QUERIES WITH XMLTABLE FUNCTIONS MIGHT RETURN INCORRECT RESULTS WHEN MORE THAN ONE EQUAL PREDICATE IS USED IN WHERE CLAUSE
IC96518	2	CRASH IN XMLVSTREAMINGNORMSPACE ON LINUX/PPC64
IC95521	3	DECOMPOSE XML WILL FAIL TO RETURN AN SQLSTATE IN CASE OF UNSUCCESSFUL DECOMPOSITION.
Fix Pack 4 - pureScale Services
IC99951	1	DATABASE RESTORE FAILS ON PURESCALE CLUSTER DUE TO INSUFFICIENT SCA MEMORY ON THE CF (SQLE_RC_INSUFFICIENT_CA_MEMORY_FOR_SCA)
IT03410	1	DB2HAICU INCORRECTLY REPORTS AN IP ADDRESS AS ALIVE WHEN IT IS NOT.
IT01710	1	CONNECTION TO CF FAILS RESULTING IN SLOW CRASH RECOVERY
IC96369	1	IN A TSA AUTOMATED HADR ENVIRONMENT, AN AUTOMATED HADR FAILOVER OCCURS IMMEDIATELY AFTER THE TAKEOVER HADR COMMAND IS RUN
IC98874	1	DATABASE MIGRATION FROM DB2 V98 TO V10.5 FAILS
IC98615	2	IN A TSA/HADR ENVIRONMENT, AUTOMATIC REINTEGRATION OF THE HADR STANDBY DATABASE FAILS
IC99307	2	THE DB2V105_STOP.KSH SCRIPT DOES NOT KILL THE DB2SYSC PROCESS ASEXPECTED IN THE CASE WHERE THE HOME DIRECTORY IS NOT ACCESSIBLE.
IC98679	2	WHEN RUNNING DB2GCF AS ROOT TO STOP A PARTITION THE COMMAND EXITS WITH RC=3 AND ERROR MESSAGE
IT02290	2	STALE CF MANAGEMENT PORT RE-USED FOR COMMUNICATIONS.
IT02522	2	IN A TSA/HADR ENVIRONMENT, THE STANDBY HADR RESOURCE MAY BE IN AFAILED OFFLINE STATE
IC95596	2	IN A LARGE DPF/HA CLUSTER, IF ALL RESOURCES ARE STARTED AT ONCE IT IS POSSIBLE THAT CERTAIN RESOURCES ARE NOT BROUGHT ONLINE
IC96664	2	ENHANCE MOUNTV97_MONITOR.KSH TO HANDLE TEMPORARY UNEXPECTED OUTPUT OF LSLV ON AIX PLATFORM
IC99916	2	HADRV105_MONITOR.KSH FAILING DUE TO .BASHRC ENTRIES
IC99706	2	DB2HAICU FAILS TO CREATE A MOUNT RESOURCE FOR AN EXT4 BASED MOUNT POINT
IC97634	2	MOUNTV97_MONITOR.KSH TAKES ACTION WHEN TSA IS IN MANUAL MODE
IC97638	2	MAKE HADRVXX_MONITOR.KSH SCRIPT MORE ROBUST TO REDUCE FALSE NEGATIVES
IT00861	2	DB2 WILL WAIT FOR MORE THAN 8 HOURS FOR TSA TO CHANGE RESOURCE LOCK STATE APPEARING AS A HANG
IC97771	3	DB2INSTANCE COMMAND TEMPORARY SHOWS CF STATE AS ERROR
IC99809	3	VARIOUS DB2HAICU OPERATIONS FAILING IN A CONFIGURATION CONTAINING 50 OR MORE HIGHLY AVAILABLE HADR DATABASES
IT00975	3	"DB2CLUSTER -DELETE -RESOURCES -FORCE" COMMAND TO DELETE THE HAENTRIES IN HA REGISTRIES
IC99378	3	DB2V10_START.KSH SCRIPT HANGS IN CASE OF REMOTELY CATALOGED DATABASES
IC96533	3	DURING RESTART OF THE SERVER, DB2FMCD PROCESS CAN REPORT MESSAGETHERE IS ALREADY A COPY OF FAULT MONITOR DAEMON PROCESS RUNNING

DB2 Version 10.5 Fix Pack 3a
APAR	Sev.	Abstract
Fix Pack 3a - Security
IC99481	1	SECURITY: VULNERABILITY IN STORED PROCEDURE INFRASTRUCTURE CAN ALLOW ESCALATION OF PRIVILEGE TO ADMINISTRATOR (CVE-2013-6744).
IC99477	1	SECURITY: IBM DB2 IS IMPACTED BY MULTIPLE TLS/SSL SECURITY VULNERABILITIES (CVE-2013-6747, CVE-2014-0963)
IT00687	1	SECURITY: ELEVATED PRIVILEGES WITH DB2 EXECUTABLES (CVE-2014-0907)

DB2 Version 10.5 Fix Pack 3
APAR	Sev.	Abstract
IT02367	2	MANY MMKSH PROCESSES ARE SPAWNED FROM MOUNTV105_MONITOR.KSH AND MAY CONSUME HIGH CPU
Fix Pack 3 - Abstract Data Types and Spatial Extender
IC95367	2	SPATIAL UPGRADE FROM V9.5 TO V9.7 FAILS
Fix Pack 3 - Administration Tools
IC95472	2	DB2ATS MAY BE REMAINED, IF DBMS_JOB.CHANGE WAS EXECUTED.
IC95867	2	SQL0104N IS RETURNED WHEN UPDATING SYSSTAT.COLDIST.COLVALUE VIA DB2LOOK MIMIC MODE
IC95390	3	'PARAMETER STYLE GENERAL WITH NULLS' CLAUSE IS EXTRACTED WRONGLYBY DB2LOOK
IC95504	3	DB2LOOK DOES NOT WRAP THE SOURCE FUNCTIONS WITH QUOTATION MARKS WHEN GENERATES STATEMENTS FOR SOURCED FUNCTIONS
IC96372	3	ATS DAEMON MAY CAUSE A STACK OVERFLOW DUE TO RECURSIVE CALLS ANDSUBSEQUENT SEGV IF AN ERROR CONDITION IS ENCOUNTERED
IC95401	3	THE GRANT COMMAND FOR THE PROCEDURE IS NOT COLLECTED WHEN WE ISSUE THE DB2LOOK COMMAND.
IC98357	3	CALL CAPTURE_STORAGEMGMT_INFO FAILS WITH SQL0443N ON WINDOWS
IC95349	3	PAGE_FETCH_PAIRS AND AVGPARTITION_PAGE_FETCH_PAIRS STATISTICS CANNOT BE CLEARED BY MANUAL UPDATE IF VARCHAR2 COMPATIBILITY IS ON
Fix Pack 3 - Buffer Pool Services
IC96484	2	PREFETCHER ERROR WITH SQLB_BADHDR "BAD PAGE HEADER" IN SQLB_VERIFY_PAGE, PROBE:6
IC95224	2	CONTENTION DURING CONCURRENT LOADS CAUSED BY UNNECESSARY SMP PAGE SEARCHES
IC95454	2	SET WRITE SUSPEND CONSISTENTLY FAILS WITH SQL1550N RC=5 WHEN THE BUFFERPOOL IS STMM ENABLED.
IC95287	2	SET WRITE SUSPEND FAILS WITH SQL1550N RC 5 DUE TO TABLE SPACE INBACKUP PENDING OR OFFLINE STATE
IC96423	2	DB2 CREATE TABLESPACE COMMAND CAN FAIL WITH SQL0289N WHEN FILE SYSTEM SIZE EXCEEDS 16 TB
IC95388	2	EXCESSIVE MEMORY USAGE IN DATABASE HEAP WHEN FAILING ALTER TABLESPACE COMMANDS ARE ISSUED ACROSS A LARGE NUMBER OF TABLESPACES
IC95210	2	STMM BUFFERPOOL MINIMUM NORMAL PAGE AREA AND CONFIGURED BLOCK PAGE AREA ARE NOT MAINTAINED ON ACTIVATION WITH SCALE BACK
IC95365	2	PRIVATE MEMORY LEAK ON THE DB2 SERVER BY THE DB2PFCHR THREAD
IC95433	3	SPECIFYING SHARED CONTAINER PATH DURING CREATION OF DMS TABLE SPACE IN PARTITIONED ENVIRONMENT MAY CAUSE INSTANCE ABEND
IC95218	3	DB2RELOCATEDB CAN FAIL WITH DBT1015N WHEN CHANGING STORAGE_PATH
IC97095	3	GETTING SQL1763N WHEN CREATING A TABLESPACE WITH NO FILE SYSTEM CACHING OPTION ON A ZLINUX ENV
Fix Pack 3 - Build Team
IC99572	2	TO DOCUMENT ALL THE JCC APAR AND DEFECTS SHIPPED WITH DB2V10.5FP3 RELEASE
IC97080	2	IN RARE CONDITIONS, ACCESSING A VARCHAR COLUMN IN A COLUMN ORGANIZED TABLE MAY RESULT IN AN ASSERTION FAILURE OR TRAP.
IC97780	2	AFTER RESTART LIGHT, DB2 MEMBER CANNOT FAILBACK BUT KEEPS IN "WAITING_FOR_FAILBACK" STATE
IC97472	3	SECURITY: NULL POINTER DEREFERENCE IN DB2'S XSLT PARSING ENGINE (CVE-2013-5466).
Fix Pack 3 - CDE Data
IV53366	1	MINOR POSSIBILITY OF WRONG RESULTS DURING INEQUALITY PREDICATE PROCESSING ON CHAR OR GRAPHIC COLUMNS IN COLUMN-ORGANIZED TABLES
IC97614	2	MEMORY LEAKS DURING QUERIES TOUCHING A LARGE NUMBER OF RECENTLY OR CONCURRENTLY UPDATED ROWS ON A COLUMNAR TABLE.
IC95090	2	IN RARE CIRCUMSTANCES, ACCESS TO A COLUMN ORGANIZED TABLE MAY FAIL WITH A RECURRING -901 ERROR.
Fix Pack 3 - CDE Query
IC97691	1	A DELETE TABLE STATEMENT ON A COLUMN ORGANIZED TABLE COULD BRINGDOWN THE DATABASE WHEN RUNS INTO A CONDITIONAL LOCK CONFLICT.
IV53767	1	EXCESSIVE MEMORY USAGE IN APPLICATION HEAP WHEN INSERTING DATA INTO A COLUMN_BASED TABLE FROM A SUB-SELECT ON A ROW_BASED TABLE
IC96977	2	LONG RUNNING QUERY AGAINST COLUMN ORGANIZED TABLES CANNOT BE INTERRUPTED
IC94525	2	SORT MEMORY USAGE MAY SIGNIFICANTLY EXCEED SORT RESERVATION WHENISSUING QUERIES AGAINST COLUMN-BASED TABLES
Fix Pack 3 - Client Interfaces
IC96047	1	FOR DSDRIVER, LDAP DB IS MISSING FROM THE DROP DOWN LIST OF "ODBC DATA SOURCE ADMINISTRATOR" AND HENCE UNABLE TO REGISTER IT.
IC95439	2	.NET PROVIDER THROWS EXCEPTION WITH INFORMIX: A SYNTAX ERROR HASOCCURRED
IC95346	2	CLI0143E ON SQLBINDPARAMETER FOR TIMESTAMP OR TIMESTAMP WITH TIMEZONE TYPE WITH CBCOLDEF=-1
IC93858	2	CALLING SQLSETSTMTATTR WITH THE OPTION SQL_ATTR_CHAINING_END CANRETURN SQL_ERROR , BUT DOESN'T UPDATE THE ERROR HEADER.
IC95320	2	MULTI-THREADED APPLICATIONS USING BOTH ESQL/C AND CLI INTERFACESMAY EXPERIENCE HANGS OR CRASHES WHEN NOT USING EXPLICIT CONTEXT
IC95467	2	DB2CLI REGISTERDSN -ADD -ALLDSN SYSTEM HAS MISSING ODBC DSNS WITH A LARGE NUMBER OF DSNS IN DB2CLI.INI OR DB2DSDRIVER.CFG
IC95423	2	SQL1086C WHEN CREATING DATABASE IF CURRENT WORKING DIRECTORY (CWD) IS EMPTY.
IC95045	2	CLI OR .NET APPLICATION WITH PUREQUERY CLIENT OPTIMIZATION MAY THROW SQL0805N WHEN USING FORCESINGLEBINDISOLATION OPTION.
IC95428	2	'LOAD QUERY' COMMAND ENCOUNTERS SQL6024C AND HOLD LOCKS ON CATALOG TABLES
IC96570	2	EXCEPTION "THERE IS NO MORE DATA TO RETURN" WHEN USING ENTITIES W/ WFC SERVICES AND QUERYING TABLES W/ LOB COLUMNS USING EXPAND
IC95333	2	SQL_COLUMN_LENGTH RETURNS A LENGTH OF 16 INSTEAD OF 26 FOR TIMESTAMP COLUMNS WITH PATCH1=131072 ENABLED IN THE DB2CLI.INI FILE
IC94375	2	CCA3018N WHEN USING DB2CFIMP DUE TO WRITE PERMISSION MISSING ON INPUT FILE
IC95442	2	SET ECHO OFF COMMAND DOESN'T DISABLE THE DISPLAY OF COMMANDS ANDTHEIR OUTPUT
IC95394	2	ABEND POSSIBLE IN CLI_SQLDISCONNECT WITH > 512 DATABASE HANDLES ALLOCATED IN MULTITHREAD ENVIRONMENT
IC97005	2	CAST() IN QUERY USED IN .NET FRAMEWORK DOES NOT ADEQUATELY RESOLVE PRECISION OF DATETIME DATATYPE IN IDS DATABASE.
IC95395	2	CALL PROCEDURE FAILS FROM CLPPLUS COMMAND PROMPT WHEN ARGUMENT VALUE CONTAINS OPEN OR CLOSED PARATHESIS '(' / ')' AND ','
IC95527	2	APPLICATION CAN CRASH WHEN USING DB2DSDRIVER.CFG AND IF THE SRVRLST.XML FILE CANNOT BE CREATED
IC97536	2	.NET EXCEPTION WHEN SERVER SIDE PAGINATION IS ENABLED WITH ODATAWITH INFORMIX DATABASE
IC97527	2	CLPPLUS WILL THROW A JCC EXCEPTION WHEN CONNECTION FAILS TO ESTABLISH AND 'WHENEVER SQLERROR' CLAUSE IS SET.
IC97096	2	CLI0106E ERROR OCCURS DUE TO PHYSICAL NETWORK TIMEOUT BY LONG IDLE TIME
IC95348	2	SQL1086C WHEN CREATING DATABASE IF CURRENT WORKING DIRECTORY (CWD) IS EMPTY.
IC95219	2	.NET DB2BULKCOPY - CLI0125E
IC97286	2	CAST() IN QUERY USED IN .NET FRAMEWORK INCORRECTLY MAPS VARCHAR(1) TO TEXT DATATYPE IN IDS DATABASE.
IC95477	2	TYPEDEF IS NOT WORKING AS EXPECTED WHEN TWO OR MORE TYPEDEF STRUCTURES WITH SIMILAR MEMBER NAME EXIST.
IC95471	3	SQL_DIAG_ROW_NUMBER RETURNS THE WRONG ROW NUMBER WITH ARRAY INPUT CHAINING
IC95337	3	DB2 CLP DUMPS CORE WITH OPTION -L AND STATEMENTS BIGGER THAN 128K
IC95293	3	OCISESSIONBEGIN FAILS WITH OCI_STMT_CACHE MODE
IC95223	3	IBM DATA SERVER DRIVER .NET DLL FILES NOT UPGRADED AFTER INSTALLOF SPECIAL BUILD
IC95468	3	REORGCHK CURRENT STATISTICS ON TABLE MIGHT RETURN INCORRECT VALUE OF F2 FORMULA IN PARTITIONED DATABASE ENVIRONMENT
IC96563	3	OCISTMTEXECUTE() MAY GET OCI_NEED_DATA ERROR
IC96327	3	POSSIBLE ABEND DURING SQLCONNECT CALL WHEN CONNECTIONS ARE FORCED ON THE SERVER SIDE.
IC95350	3	DB21034E ERROR OCCURS WHEN BLOCK COMMENTS IS AT THE BEGINNING OFFILE AND 'WITH' SQL STATEMENT IS AFTER BLOCK COMMENT.
IC94590	3	CLPPLUS CAN NOT PUT NEW LINE WITH DBMS_OUTPUT.NEW_LINE.
IC93561	3	XA CONNECTION DRIVEN BY XA_OPEN GIVES SQL1013N IF COMMPROTOCOL=TCPIP IS MISSING IN THE DSDRIVER.CFG
Fix Pack 3 - Codegen and Runtime
IC95391	1	ON DPF, A HANG CAN OCCUR IF AN INTERRUPT IS RECEIVED DURING THE EXECUTION OF A QUERY THAT CONTAINS A CORRELATED SUB QUERY.
IC98355	1	UNDER HIGH CONCURRENCY THE FAST INTEGER SORT ( FIS ) FEATURE CANCAUSE HIGH LATCH CONTENTION AND PERFORMANCE DEGRADATION
IC97851	2	INCORRECT RESULT IN UNICODE DB WITH LIKE PREDICATE AND FULLWIDTH UNDERSCORE WILD CHARACTER ON A CLOB COLUMN
IC95357	2	INSTANCE MIGHT CRASH IF A QUERY THAT FEATURES A SORT IS RE-EXECUTED AFTER IT PREVIOUSY RECEIVED SQL0973.
IC97603	2	INSTANCE CRASH DUE TO RUNTIME SERVICES FREEING AN XML NULL POINTER
IC97535	2	POSSIBLE SEGV (CRASH/TRAP) IN SQLDROWFETCH() WHEN SQL IS USING PBT(PARAMETERIZED BASE TABLE) ACCESS IN A NESTED LOOP JOIN
IC95345	2	RETURN OF SQL0083C MAY CAUSE A HANG IN AN SMP ENVIRONMENT.
IC95446	2	PERFORMANCE ISSUE DURING OPERATIONS ON GLOBAL COLLECTIONS
IC95291	2	MEMORY CORRUPTION ISSUE WITH XML ON DPF ENV
IC98143	2	THE UTL_MAIL.SEND PROCEDURE RETURNS SQL1336 AFTER APPLYING SOLARIS PATCH
IC95440	2	ZIGZAG JOIN WITH QUERY DEGREE > 1 MAY HANG OR FAIL WHEN A SUBAGENT EXITS EARLY WITH NO ROWS FOUND IN DIMENSION PROCESSING
IC95689	2	THE ROUND FUNCTION WITH A MINIMUM VALUE FOR INTEGER AND BIGINT VALUES IS NOT RETURNING THE CORRECT RESULTS
IC95221	2	INSTANCE PANIC WHEN AGGREGATION FUNCTION(IE.MIN,MAX,SUM...) IS USED AGAINST ROWID RESULT
IC95515	2	DB2 ABEND IN FAST INTEGER SORT FUNCTIONS LIKE SQLSFASTINTDISTCOUNTSORT IF SORT MEMORY EXCEEDS 2GB
IC95386	2	IN A DPF ENVIRONMENT, AN ACCESS PLAN WITH A LISTENER TQ OPERATORMAY ENCOUTER A NULL POINTER AND CAUSE DB2 TO CRASH.
IC97269	3	THE DBMS_LOB.COMPARE FUNCTION AND DBMS_LOB.READ PROCEDURE DO NOTPROCESS CLOBS CORRECTLY IF MULTI-BYTE CHARACTERS ARE PRESENT
IC97525	3	MEMORY LEAK IN UCA500R1 COLLATION DATABASE WHEN USING COLUMN NAME IN PATTERN-EXPRESSION OF LIKE CLAUSE
IC95213	3	SQL0956C THROWN WHEN CALLING PARSE PROCEDURE WITH AN INPUT SQL STATEMENT CONTAINING A COMMENT WITH COLON (:) FOLLOWED BY A SPACE
IC95259	3	SOMETIMES A QUERY INVOLVING A ZIGZAG JOIN MAY FAIL WITH WITH A SQL0901N ERROR
IC95351	3	QUERY HANG WHEN SELECTING LARGE OBJECT COLUMNS FROM A TABLE FUNCTION ON DPF
IC97340	3	QUERIES WITH THE XMLTABLE FUNCTION MIGHT RETURN INCORRECT RESULTS
IC95356	3	GRAPH GENERATED WITH 'DB2EXPLN -G' DOES NOT CONTAIN STATISTICS
Fix Pack 3 - Communication
IC95355	2	DB2TCPCM EDU NEED TO HANDLE SETSOCKOPT() FAILURES MORE GRACEFULLY
IC97003	2	WHEN THIRD PARTY SOFTWARE LOADS GSKIT-CRYPTO INSTEAD OF FULL GSKIT , DB2 LOADS ITS LOCAL GSKIT-CRYPTO , DB2 FAILS WITH SQL1042C
IC95362	2	FALSE COMMUNICATION ERROR DETECTED BETWEEN DB2FMP PROCESS AND DB2 EDU LEADING TO INCORRECT SQL1646N ERROR RETURNED
IC95278	3	DB2 IS UNABLE TO CLEAN UP THE SSL RESOURCES CORRECTLY WHEN IT FAILS TO LOAD GSKIT AND THUS CAUSES UNRECOVERABLE ERROR
Fix Pack 3 - DB2 Tools
IC96417	1	PERFORMANCE EXPERT MAY HANG WHEN UTILIZING FUNCTIONS PROVIDED BYTHE DB2 CONTROL CENTER
IC95402	2	SYSPROC.NNSTAT PROCEDURE CAN FAIL IF USING METHOD 2 WITH SQL0206N ERROR.
IC95248	2	NNSTAT METHOD 1 OR 0 REPORTS SQL1227N RC=3 WHEN IT TRIES TO UPDATE HIGH2KEY TO SINGLE BLANK FOR AN INTEGER COLUMN
IC95514	2	SQL0108N RETURNED WHEN USING ADMIN_CMD PROCEDURE TO DO TABLE REORG WITH TEMP TABLESPACE OPTION BEING SPECIFIED
IC95513	3	MESSAGE: "POSSIBLE MEMORY CORRUPTION" IN DB2DIAG.LOG WHEN USING ADMIN_MOVE_TABLE()
Fix Pack 3 - DRDA Services
IC95227	2	DIA5000C "INVALID DDM REQUEST" AND SYNTAX ERROR REPORTED WHEN DB2 FOR ZOS ATTEMPTS TO SWITCH ID ON A TRUSTED CONNECTION
IC96416	2	DB2 CONNECT INSTANCE MAY CRASH IN THE FUTURE AFTER A COMMUNICATION ERROR WHEN LDAP SUPPORT IS ENABLED (DB2_ENABLE_LDAP=YES).
IC95389	2	XA_END MAY RETURN XA_RBOTHER INSTEAD OF XAER_RMFAIL AFTER REPORTING COMMUNICATION ERROR.
IC95736	2	XA_COMMIT() RETURNED XAER_RMFAIL(-7) WITH PURESCALE ENVIRONMENT DURING XA TRANSACTION RECOVERY, WHEN USING AFFINITIES.
IC95839	2	EXEC SQL SET CONNECTION FAILED WITH SQL0843N
IC95325	2	2 MINOR MEMORY LEAKS WHEN CONNECTING USING CLI.
IC95448	2	SQL1001N ERROR FROM CLI APPLICATION WHEN ENLISTING THE DATABASE WITH MSDTC.
IC97415	2	STORED PROCEDURE FAILS WITH SQL30020N WHEN THE NUMBER OF PARAMETERS MARKER IS GREATER OR EQUAL TO 10684
IC96631	2	SQL0998N OR XAER_PROTO WHEN DB2LIC.SYSLIC IS CALLED TO CHECK SERVER ACTIVATION
IC96306	2	SQLNN_E_SYNTAX SYNTAX ERROR ON 'CALL 47' STORED PROCEDURE CALL SEEN IN DB2DIAG.LOG
IC95412	2	XA PROTOCOL ERRORS AFTER RM_FAIL ON XA_END.
IC96608	2	AFTER UPGRADING TO V9.7 FP7, QUERY DRDA NICKNAME WILL FAIL IF DB2 REGISTRY DB2TCP_CLIENT_CONTIMEOUT IS SET
IC95238	2	WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.
IC95483	2	ACR IS NOT ENABLED FOR CONNECTIONS TO Z/OS THRU DB2 CONNECT SERVER EVEN ALTERNATE SERVER IS SET
IC95461	3	CLIENT REROUTE FAILS TO ZOS SERVER WITH ERRONEOUS MESSAGE "ENSURE APAR PM24292 IS INSTALLED ON THAT SYSTEM."
IC96420	3	DB2 CONNECT SERVER MIGHT CRASH IF DCS DIRECTORY IS CATALOGUED TOUSE MAP-FILE OPTION
Fix Pack 3 - Data Management Services
IC97849	1	INSTANCE CRASH DURING CRASH RECOVERY IF INFLIGHT ONLINE REORG WORKLOAD AND TABLE SPACE IS INACCESSIBLE.
IC95594	1	SQLE_SAL_CACHE_RAR_NODATA USING THE DB2READLOG API
IC97369	1	DISABLE ASYNC CLEANUP FOR OLR
IC98875	1	QUERY ON PARTITIONED TABLE MIGHT FAIL WITH SQLD_BADPAGE AND SQLDFETCHDIRECT PROBE: 5395 ERRORS WHEN RUNNING EHL
IC96727	1	SELECT OF A TABLE AFTER A TABLE SPACE ROLLFORWARD OF AN INFLIGHTONLINE REORG TRANSACTION MAY GET SQL1656C DUE TO A BAD PAGE.
IC95372	2	DB2CAT FAILS TO GENERATE A NEW PACKED DESCRIPTOR (-G OPTION) IN DB2 V10.1, WHEN TABLE HAS INDEXES
IC95475	2	IN RARE TIMING SCENARIO, LOAD PERFORMANCE WITH LOB VALUES MAY DEGRADE
IC96485	2	DB2 INSTANCE MIGHT CRASH WHEN USING INCORRECT TABLE DESIGNATOR VALUE FOR RID SCALAR FUNCTIONS.
IC95405	2	SQL STATEMENT MAY HANG DUE TO A DEADLATCH WHEN PROCESSING SUBSECTIONS OF A ZIG ZAG JOIN PLAN
IC95474	4	INCORRECT CUR INDEX AND START TIME VALUES IN DB2PD -REORGS INDEXAFTER AN INTERRUPTED INDEX REORG
Fix Pack 3 - Data Management Utilities
IC95146	1	THE LOAD COMMAND WITH THE REMOTE FETCH OR SOURCEUSEREXIT OPTIONSMIGHT FAIL TO INSERT SOME ROWS INTO A TABLE
IC97541	1	INGEST: RUN TIME IS 32X WORSE THAN IMPORT WHEN TABLE HAS MANY UDTS
IC95424	2	LOAD MAY FAIL WITH SQL0902C RC85 IF THERE IS AN INDEX WITH KEY LENGTH AROUND 4000 OR 8100 BYTES
IC95206	2	LOAD: RECORDS REJECTED DURING PARTITIONING ARE NOT COUNTED TOWARDS WARNINGCOUNT
IC95216	2	IMPORT NULL VALUE TO A COLUMN THAT IS A PART OF PRIMARY KEY WITHINSERT_UPDATE AND USEDEFAULTS OPTIONS WILL COMPLAIN -206 ERROR.
IC97404	2	INGEST UTILITY MIGHT INSERT NULLS INSTEAD OF CORRECT DATA TO NUMERIC COLUMNS WHEN INPUT FILE SIZE IS HUGE
IC97152	2	XML LOAD TERMINATE RESULTS IN SQL1007N (ERROR IN FINDING PAGES FOR AN OBJECT IN A TABLE SPACE.)
IC97094	2	SIGNAL 11 TRAP IN SQLSBINSORTPOPULATERECPOINTERS
IC94753	2	LOAD TRAPS WHEN TARGET TABLE HAS GENERATED COLUMN WHICH IS USINGCOMPILED COMPOUND SQL UDF; SHOULD FAIL GRACEFULLY.
IC97727	2	SQL2918N RECEIVED WHEN THE INGEST COMMAND SPECIFIES BOTH ONE OF THE IMPLICITLYHIDDEN OPTIONS AND THE EXCEPTION TABLE CLAUSE
IC95286	2	SQL2036N WHEN USING RECOVER WITH RESTORED RECOVERY HISTORY FILE FROM A BACKUP THAT HAS MORE THAN 1 SEQUENCES
IC97794	2	DB2 INGEST FAILS ON WINDOWS VISTA AND WINDOWS 7
IC94025	3	BINDING DB2UCKTB.BND AGAINST LOWER RELEASE DB2 LUW DATABASE THROWS ERROR.
IC95327	3	ON WINDOWS IMPORT UTILITY MIGHT FAIL WITH ERROR SQL0604N WHEN DB2_COMPATIBILITY_VECTOR=ORA IS SET.
IC95375	3	REDISTRIBUTE UPDATES TABLE PACKED DESCRIPTOR AND OVERWRITES UPDATES OF RUNSTATS
Fix Pack 3 - Data Recovery Services
IC96348	1	SLOW COMMITS WHEN STMM-MANAGED LOCKLIST GROWS INTO OVERFLOW
IC97245	1	REQUIRED TRANSACTION LOGS FOR ONLINE BACKUP CAN GET DELETED IN DB2 V10.X. RESULTING IN SQL2048N ERROR.
IC97805	1	UNEXPECTED LOCK ESCALATIONS ON DB2 PURESCALE SYSTEMS USING STMM LOCKLIST TUNING OR MANUAL DYNAMIC UPDATE OF LOCKLIST SETTING
IC96602	1	ARCHIVED LOG CORRUPTION POSSIBLE USING LOG COMPRESSION AND VENDOR SETTING
IC97002	2	UPGRADE CODE CHECK-IN OPTION FOR VALID RUNSTATS PROFILES
IC97848	2	HADR GRACEFUL TAKEOVER FAILS ON STANDBY THAT HAS TABLE SPACES/TRANSACTIONS IN REPAIR STATE.
IC96332	2	ONLINE BACKUP FAILS DUE TO BAD FIRSTLOS AFTER TAKEOVER
IC95469	2	DB2FLSN -Q (QUIET MODE) DOES NOT WORK CORRECTLY
IC95669	2	TCP CONNECTIONS FROM NON-HADR DATABASE SOFTWARE TO THE STANDBY MIGHT ALTER THE HADR STATE AND STALL LOG SHIPPING ON THE PRIMARY
IC93406	2	DB2PD -LOGS AND MON_GET_TRANSACTION_LOG() DO NOT RETURN RIGHT LOG CHAIN ID
IC95369	2	HADR STANDBY DATABASE ENCOUNTERS LOG PAGE CHECKSUM ERROR
IC95420	2	DB2 V10.1 DOES NOT WRITE THE "STARTED ARCHIVE FOR LOG FILE XXX"MESSAGE TO THE DB2DIAG.LOG FILE ANYMORE
IC95343	2	HADR START AS STANDBY FAILS DUE TO ENOBUFS ERROR AND RETURNS HDR_ZRC_CONFIG_LOCAL_HOST
IC97523	2	DB2FLSN -LSO MAY RETURN A WRONG LOG FILE NAME
IC96985	2	IN A PURESCALE HADR SYSTEM, HOSTS CONFIGURED WITH FULL LENGTH IPADDRESSES WILL FAIL TO FORM A PAIR WITH REMOTE DATABASE.
IC93786	2	DB2CKBKP REPORTS MISLEADING ERROR "NO PAGE HEADER: POSSIBLE LOB.ERROR - TABLESPACE PAGE SIZE INCONSISTENT FOR TABLESPACE ID <#>"
IC97520	2	"GET DATABASE CONFIGURATION" COMMAND DISPLAYS INCORRECT VALUE FOR PARAMETER MIRRORLOGPATH.
IC94732	2	SQL1042C ERROR CAN OCCUR WHILE APPLYING TRANSACTION LOGS (TILL "END OF BACKUP" OPTION) ON DB2 FOR WINDOWS.
IC98173	2	WHEN USING DB2ADUTL DELETE OLDER THAN S00000XX.LOG COMMAND THE LOG INCLUDING S00000XX.LOG WOULD BE REMOVED.
IC95484	2	DB2 ONLINE BACKUP WITH INCLUDE LOGS FAILS WITH ERROR SQL2428N
IC95431	2	ONLINE BACKUP CAN FAIL WITH SQL0100W AND INCORRECTLY REPORT BACKUP COMPLETE AS WELL AS OVERWRITING THE BACKUP TRACKING STRUCTURE
IC95902	2	DB2 ROLLFORWARD MIGHT HANG IN BACKWARD PHASE WHEN INFINITE LOGGING IS USED
IC95476	2	NO AUTO DELETION OF OLD BACKUP IMAGES ON DISK AFTER MIGRATION TO10.1
IC95244	3	SYNTAX CHECK FOR RECOVER DB USING HISTORY FILE NEEDS TO BE MOVEDFROM CLIENT TO SERVER
IC95466	3	DB2READLOG API WAS RETURNED SQLCODE -1273 DURING ONLINE BACKUP.
IC95298	3	GROUP READ PERMISSION IS REVOKED ON ARCHIVE LOG FILES.
IC95494	3	SQLUDREPAIROFFLINEBACKUPENDMARKER, PROBE:1719 ON RESTORE
Fix Pack 3 - E2E Monitoring code
IC97016	2	CLI APPLICATION MAY TRAP DUE TO MEMORY CORRUPTION
Fix Pack 3 - Federation
IC95319	2	FENCED ORACLE WRAPPER LEAKS MEMORY WHEN ITERATIVELY EXECUTES INSERT/UPDATE STATEMENTS INVOLVING A LOB COLUMN
IC95400	2	RECEIVE SQL1822N/SQL0401N ERROR WHEN QUERYING A NICKNAME IN AN ORA MODE DATABASE
IC96418	2	THE REMOTE CONNECTION'S ISOLATION LEVEL IS SERIALIZABLE WHEN USING SQL SERVER WRAPPER 2PC FEATURE
IC95361	2	SQL1822N ERROR WHEN QUERYING CURRENT DATE OR TIMESTAMP FROM NICKNAME
IC95331	2	ADD ERROR MAPPINGS FOR SOME ORACLE CONNECTION ERRORS TO DB2 ERROR SQL30080N
IC95302	2	FEDERATION SERVER QUERY RESPONSE SLOWLY
IC95435	2	DB2 MAY TRAP AT THE DESTRUCTOR OF SQLQG_REMOTE_STMTS.
IC95249	2	REPLACE OLD API OCIENVINIT AND?OCIINITIALIZE TO OCIENVCREATE SINCE ORACLE HAS NOT SUPPORT IT ANYMORE
IC96477	2	CREATE NICKNAME AGAINST ORACLE TABLE (USING ORACLE WRAPPER) MIGHT FAIL WITH ERROR SQL0802N FOR ORACLE TABLE WITH FEW BILLION ROW
IC95398	2	TO_CHAR AND OTHER BUILT-IN FUNCTIONS COULD NOT BE PUSHED DOWN
IC98350	2	A QUERY WITH AN OR PREDICATE MIGHT RETURN INCORRECT RESULTS
IC95436	2	JDBC DOESN'T REPORT SQLCODE 100 WHEN NO DATA IS UPDATED OR DELETED
IC95437	2	FEDERATED FMP TRAPPED WHEN QUERY JDBC NICKNAME WITH CLOB DATA LONGER THAN 32K
IC94036	2	REPORT SQL0901N (REASON "BAD OPCODE -9, REF_ARITY 3, SQLNQ_PID ID 941 (SYSIBM.DJ_RPAD)".)
IC96304	2	FED: ALTER NICKNAME IN ORA COMPATIBLE MODE, FAILED TO MAP REMOTEDATE TO LOCAL TIMESTAMP(0)
IC95397	2	UDF WITH STRING RESULT TYPES COULD BE BLOCKED FROM BEING PUSHED DOWN
IC97533	3	NESTED TABLE EXPRESSIONS WITH OUTER JOIN NOT PUSH DOWN
Fix Pack 3 - FORTRAN PRECOMPILER SERVICES
IC97700	2	PRE-COMPILATION OF DB2 EMBEDDED FORTRAN APPLICATIONS USING @PROCESS COMPILER DIRECTIVE IN AIX, USING XLF COMPILER FAILS
Fix Pack 3 - Index Manager
IC96355	1	ABP DAEMON (DB2TASKD EDU) STOPPED AND NOT RESTARTED IN DPF MODE AFTER A NON-CATALOG PARTITION IS FORCED AND RESTARTED
IC95250	2	INSPECT WITH THE INDEXDATA OPTION PANICS AFTER ENCOUNTERING AN INVALID RECORD ID
IC95254	2	POSSIBLE HANG IN INDEX CLEANUP LOGIC WHEN MULTIPLE ASYNCHRONOUS CLEANUP OPERATIONS ARE ACTIVE ON THE SAME TABLE
IC94438	2	RUNNING MULTIPLE CONCURRENT SAMPLED DETAILED INDEX RUNSTATS MIGHT CAUSE A SERVER ABEND OR INACCURATE INDEX STATISTICS
IC95277	2	LOG FULL DURING REORG INDEX(ES ALL) WITH THE CLEANUP ONLY ALL OPTION
IC95262	2	DATABASE MARKED BAD WHILE DROPPING AN INDEX
IC95308	2	MULTIPLE DETACH PARTITION FROM THE SAME UNIT OF WORK WILL DEADLOCK WITH EACH OTHER
IC95315	3	CREATION OF LARGE INDEXES OF LARGE INDEXES IS SLOWER THAN EXPECTED WHEN USING THE DB2 PURESCALE FEATURE
Fix Pack 3 - Install and Catalog Services
IC96573	1	DB2 CRASHES WHEN THREE PART NAME IS USED ON NON-CATALOG NODE.
IC97422	2	POSSIBLE INDEX OBJECT CORRUPTION WHEN "NOT ENFORCED" CONSTRAINT IS USED ON A ROW-ORGANIZED TABLE
IC96561	2	WLM CONFIG WIZARD RETURNS WLM51018E AND INCORRECT OBJECT IDS AREADDED TO SYSIBM.SYSHISTOGRAMTEMPLATEUSE AFTER MIGRATING TO V10
IC94507	2	DB2CKUPGRADE PERFORMANCE IMPROVEMENT FOR TABLE LOAD PENDING CHECK
IC95340	2	1603 : ERROR_INSTALL_FAILURE WHEN UPGRADING DB2 9.7 TO DB2 VERSION 10.1 ON WINDOWS (64 BIT)
IC95316	2	V10.1 ONLY: DB2IUPDT COMMAND OVERRIDES FENCEDID BY INSTANCE OWNER IF -U OPTION IS NOT SPECIFIED.
IC95231	2	DB2 INSTALLATION UNDER WINDOWS OS MAY FAIL WHEN EXTENDED SECURITY FEATURE IS ENABLED IN AD ENVIRONMENT.
IC97261	2	DATABASE UPGRADE TO DB2 V10 MAY TRAP WITH SEGMENTATION VIOLATIONIN FUNCTION SQLRLM_CHECKMIGRATEFLAG
IC95285	2	DB2PREREQCHK SHOULD DISPLAY WARNING MESSAGES INSTEAD OF ERRORS ONLY FOR /OPT WHEN SPACE REQUIREMENTS ARE NOT MET
IC96478	2	SQL0101N ERROR FOR A CREATE NICK NAME STATEMENT, WHEN THE NUMBEROF CREATED NICKNAMES EXCEEDS 3000
IC97084	2	UPGRADE DATABASE MAY TAKE LONG IN DPF ENVIRONMENT DUE TO DYNAMICSTATEMENT CACHE INVALIDATION
IC96219	2	RENAME TABLESPACE NOT HANDLING ERROR DURING SYSTEM CATALOG UPDATE AND LEAVING ORPHAN ROW(S)
IC97530	2	DB2CKUPGRADE FAILS WHEN THERE IS A CERTAIN DEPENDENCY ON SEQUENCE.
IC95447	2	DB2IUPGRADE/DB2IUPDT MAY CAUSE OPERATION TO FAIL WITH "DBI1250E APPLICATIONS ARE STILL USING THE INSTANCE"
IC96604	2	POSSIBLE ABEND IN SQLOFMBLKEX CALLED FROM SQLNQ_SEQUENCE_REF_BODY
IC95323	2	DB2IUPGRADE IS FAILING DUE TO DUPLICATE MATCHING RECORDS IN /ETC/SERVICES
IC95342	2	DB2IUPGRADE HANGS FOREVER IN THE DB2 ACS UPGRADE STEP WHEN THEREARE SPECIAL FILES LIKE NAMED PIPES LOCATED IN THE ACS DIRECTORY
IC97796	2	DROP ROLE COMMAND CAUSES A SQLOSPINLOCKCONFLICT IN SQLRLC_ROLECACHE.C AND SQLRLC_INLINES.H FUNCTIONS AND LOCKING ABOUT 52 APPLIC
IC96307	2	DB2_INSTALL FAILS WITH ERROR : DB2SETUP_EXEC: 15205012 MEMORYFAULT - CORE DUMPED
IC94890	2	THERE MIGHT BE A DOUBLE FREE OR LIST CORRUPTION IN THE SQLRLC_CSM_DEFUNCT() FUNCTION
IC97091	2	CAN NOT UPDATE EXISTING DB2 V10.5 GA/FP1 PURESCALE INSTANCE USING SIMPLIFIED METHOD FROM UNIVERSAL FIX PACK IMAGE
IC95230	2	CREATE EVENT MONITOR FAILS WITH SQL0604N ON "BLOB (32) INLINE LENGTH 32"
IC99280	2	WHILE ADDING A NEW MEMBER/CF OR NETNAME TO A MEMBER/CF YOU MAY GET THIS ERROR " RSCT PEER DOMAIN IS ONLINE "
IC95674	2	PACKAGE TEXT SEARCH COMPONENT IN DB2 EXPRESS EDITION ( REMOVED EARLIER VIA DEFECT:WSDBU00928276 )
IC97928	2	ALTER TABLE DROP COLUMN ON A TABLE WITH AN INDEX WITH RANDOM ORDERING MIGHT LEAD TO INDEX CORRUPTION
IC95276	2	A DEADLOCK MAY OCCUR,IF ALTER SEQUENCE IS EXECUTED AT THE SAME TIME.
IC95486	3	DB2IUPDT MAY SET DB2AUTOSTART TO YES.
IC94401	3	CHANGE TO REVERT BACK DB2AUTOSTART REGISTRY VARIABLE BEHAVIOUR WITHIN DB2ICRT AS WAS IN DB2 VERSION 9.7
IC95341	3	DB2ICRT FAILS TO CREATE INSTANCE, WHILE SYMBOLIC LINKS FROM OTHER DB2 COPY CREATED WITH COMMAND DB2LN EXISTS IN THE SYSTEM
IC95455	3	DB2IUPGRADE MAY RETURN MISLEADING "CTRL/.INSTUSE" ERRORS BECAUSEIT CHECKS OTHER UNRELATED INSTANCES
IC96421	3	SQL0440N ON SYSIBM BUILT IN FUNCTIONS AFTER RESTORE REPLACE EXISTING OF A DATABASE ONTO A PREVIOUS RELEASE FIX PACK
IC95497	3	ERROR DBI20073E DOING SILENT INSTALLATION (SETUP -U ...) OF DB2 ON WINDOWS IF THE CONFIGURATION PROFILE IS ON A NETWORK DRIVE
IC95498	3	CHANGE TO ENHANCE ERROR MESSAGE REGARDING MINIMUM FREE SPACE REQUIREMENTS FOR INSTALLATION AND INSTANCE CREATE/UPDATE OPERATIONS
IC95470	3	INSTALLING FIXPACK FOR DB2 CLIENT USING DB2 SERVER OR UNIVERSALIMAGE MAY REPORT A MINOR ERROR RELATED TO TSA.
IC95368	3	THE UNINSTALLER OF 64-BIT DATA SERVER CLIENT/DRIVER DOESN'T REMOVE 32BIT ODBC DATA SOURCES.
IC95243	3	DB2_INSTALL AND INSTALLFIXPACK COMMANDS CANNOT FIND THE DEFAULT FILE LOCATION OF THE NLPACK
IC94671	3	DB2PREREQCHECK DOES NOT SHOW DBT3514W AGAINST 32-BIT C LIBRARY IN THE SUMMARY.
IC95384	3	WHEN DOING THE REDIRECT RESTORE TO MIGRATE DATABASE FROM V9.7 TOV10.1, RESTORE GENERATED WARNING MESSAGES OF -1704 RC=5
Fix Pack 3 - JDBC Driver
IC99572	2	TO DOCUMENT ALL THE JCC APAR AND DEFECTS SHIPPED WITH DB2 V10.5 FP3 RELEASE
Fix Pack 3 - Monitoring
IC94257	1	LOCKING EVENT MONITOR CONTAINS INVALID DATA IN PARTICIPANT_ACTIVITIES WHEN PARTICIPANT IS COMPILING SQL
IC96365	2	LOOP IN EXPLAINREADACTUALSFROMACTEVMON() CALLED BY SYSPROC.EXPLAIN_FROM_ACTIVITY()
IC95270	2	MON_GET_PAGE_ACCESS_INFO() CAN END UP WITH SEGV (CRASH/ABORT) OREVENTUALLY MEMORY CORRUPTION
IC95493	2	SYSPROC.SNAP_GET_DYN_SQL_V95 MAY SOMETIMES FAILS WITH ERROR SQL0430N
IC95478	2	ADMIN_MOVE_TABLE REDIRECT AND CLEANUP OPERATION RETURNS WITH SQL2102N RC33, WHEN IT FAILS TO ACQUIRE THE SEMAPHORE WITHOUT RETRY
IC97532	2	THRESHOLD VIOLATIONS EVENT MONITOR IS MISSING DATA FOR SOME COLUMNS
IC94460	2	CHANGE HISTORY EVENT MONITOR CAN CAUSE INSTANCE ABEND WHEN USINGLOAD FROM CURSOR WITH LONG SQL
IC95403	2	STOPPING A FILE EVENT MONITOR MAY CAUSE DB2 TO MARK DATABASE BADAND BRING INSTANCE DOWN
IC96028	2	POTENTIAL HANG ON TRANENTRY LATCH IN SQLPM_WRITE_APPL_LOCKS DURING LOCK SNAPSHOT
IC95822	2	DB2 INSTANCE MIGHT TRAP IN SQMAGENTRTNSTACK::GETRTNCTXFORSND() WHILE CONSTRUCTING THE ROUTINE CONTEXT INFORMATION.
IC95237	2	INSTANCE MAY TRAP WITH SIGSEGV IN MONITORING CODE DURING DATABASE MANAGER SNAPSHOT COLLECTION AND ACTIVE AIC PROCESSING
IC97524	2	ON A PURESCALE INSTANCE TABLE FUNCTION ENV_GET_SYSTEM_RESOURCES CAN TRAP IF A MEMBER IS IN RESTART LIGHT MODE
IC95306	2	ADMIN_MOVE_TABLE MIGHT PRODUCE TRAP OR FAIL IF ORIGINAL TABLE HAS MORE THAN 100 REFERENCES
IC96031	2	SYSTEM APPLICATIONS INVOLVED IN A LOCKING EVENT ONLY SHOW UP AS PARTIAL EVENTS.
IC95334	2	INSTANCE MAY TRAP IN DB2 V10.1 WHEN STATEMENT MONITOR IS TURNED ON
IC95252	2	NULL VALUES OR EMPTY STRINGS IN MON_GET_MEMORY_POOL() COLUMN MEMORY_POOL_TYPE
IC95299	2	ACTIVITYSTMT TABLE OF ACTIVITIES EVENT MONITOR DOES NOT CAPTURE SQL STATEMENTS COMPILED USING THE REOPT ALWAYS BIND OPTION
IC95215	3	DEACTIVATE EVENT MONITOR MAY CAUSE MISLEADING SQLO_INTRP ERRORS ON NON-CATALOG PARTITION IN DB2DIAG.LOG
IC95309	3	SYSPROC.REORGCHK_IX_STATS STORED PROCEDURE CALL FROM A CLI APPLICATION FAILS WITH SQL0440N
IC95328	3	SYSIBMADM.SNAPUTIL MAY SHOW A NUMERIC VALUE FOR UTILITY TYPE INSTEAD OF A PROPER NAME
IC96308	3	DYNAMIC SQL SNAPSHOTS MAY EXIT WITH SQLO_DBCSTRUNC ERROR
IC95378	3	PARTIAL EVENT MESSAGES LOGGED IN DB2DIAG.LOG FROM EVMON_FORMAT_UE_TO_XML TABLE FUNCTION
IC95234	3	NEGATIVE NUMBER IS RETURNED FOR PROCESSING TIME OR WAIT TIME COUNTER FROM MON_GET TABLE FUNCTION
IC94397	3	MICROSECONDS PORTION IN RESOLUTION_TIMESTAMP IS ALWAYS 0
IC95456	3	LOCKING TABLE EVENT LOCKING MONITOR SHOULD USE NULL VALUES WHEN DATA IS UNAVAILABLE
IC94881	3	ADMIN_MOVE_TABLE MIGHT RETURN SQL2103N RC=17 IF TARGET PRIMARY KEY INDEX DO NOT MATCH SOURCE PRIMARY KEY INDEX
Fix Pack 3 - Parsing and SQL PL
IC95465	1	LOGICAL OPERATORS AND, OR MAY CAUSE SQL0104N ERROR WHEN USED IN PL/SQL INITIALIZER EXPRESSION
IC95226	2	COMPILED ROUTINE CAN CAUSE INSTANCE TRAP IN SQLRXCON_SIMPLE() AFTER UPDATE/UPGRADE
IC95324	2	SQL0480N WITH ASSOCIATE RESULT SET LOCATORS INSIDE EXCEPTION HANDLER WHEN SQLCODE > 0
IC95330	3	"SQLCODE" VARIABLE MAY HAVE AN UNEXPECTED VALUE (0) WHEN A STORED PROCEDURE IS BEING DEBUGGED IN IBM DATA STUDIO.
IC95211	3	CREATE TYPE STATEMENT FAILS WITH -104 WHEN USING A QUALIFIED OBJECTTYPE VALUE
IC95666	3	USER-DEFINED CONDITIONS IF DEFINED IN MODULES MIGHT NOT FUNCTIONCORRECTLY, IF DB CONTAINS 10000+ ENTRIES IN SYSIBM.SYSVARIABLES
Fix Pack 3 - Platform Specific
IC95382	1	THE DB2MSCS UTILITY FAILS TO CLUSTER A DB2 ESE INSTANCE ON WINDOWS SERVER 2012
IC98182	1	HANG AFTER LOG ARCHIVE
IC95487	2	DB2 ON AIX UNABLE TO FIND USER WHEN USING TRANSPARENT LDAP.
IC95364	2	WINDOWS ONLY: DB2PD WITH DB OPTIONS MIGHT RETURN BLANKS ONLY.
IC93475	2	STMM UNNECESSARILY DECREASES CONFIGURATION WHEN 0 BENEFIT DETECTED
IC94474	2	EXCESSIVE MEMORY ALLOCATION FOR DBMS MEMORY SET ON SOLARIS / SPARC ARCHITECTURE
IC95290	2	DB2VEND PROCESS CAN FAIL TO ATTACH SERVER (DATABASE MEMORY SET) SHARED MEMORY SEGMENT (SQLO_ADDR_CONFLICT IN DB2DIAG.LOG)
IC96419	2	SQLOGETFSATTRIB() FAILS TO REPORT THE CORRECT FREE DISK SIZE OF A DISK VOLUME THAT IS ON A JUNCTION POINT.
IC95499	2	STORED PROCEDURES RANDOMLY FAILS WITH ERROR SQL1124N
IC95310	2	DB2START DOES NOT REPORT AN ERROR WHEN DB2CKPWD FAILS TO START IN LOW MEMORY LINUX SERVERS
IV48094	2	EXCESSIVE DATABASE MEMORY USAGE OR ALLOCATION FAILURES DUE TO EXCESSIVE MEMORY FRAGMENTATION / OVERHEAD
IC95381	3	DB2MSCS FAILS WITH ERROR "THE OBJECT ALREADY EXISTS" WHEN ATTEMPTING TO CREATE A NETWORK SHARE THAT ALREADY EXISTS.
IC95300	3	PREVENT MESSAGE FROM FUNCTION STMMSIMULATEHJPACKPARTITIONS, PROBE:3555, FROM BEING DUMPED INTO DB2DIAG.LOG
IC95393	3	A FAILURE TO START DB2VEND PROCESS MIGHT RESULT IN SELF-KILLING OF AN INSTANCE
IC97542	3	OVERRIDE VIRTUAL AND OTHER USER LIMITS FOR DB2CKPW DAEMON IN LOWMEMORY LINUX SYSTEMS
IC95242	3	WLM THREADS LOSING THEIR ELEVATED PRIORITY WHEN USING DB2_RESOURCE_POLICY FILE WITH SCHEDULING_POLICY ELEMENT
IC95281	3	DB2 TRAPPED IN SQLOFREEOSSINTERNALMEMORY
IC95429	3	STMM ON 32-BIT INSTANCE PLATFORM MAY FAIL TO UPDATE PCKCACHESZ WHEN IT IS WORKING ON 64-BIT WINDOWS
IC95443	3	OSSGETDISKINFO REPORTS THE ERROR MESSAGE IN DB2DIAG.LOG ABOUT FILESYSTEMS NOT RELATED TO DB2
Fix Pack 3 - Problem Determination
IC95354	2	SEND SIGINT, [CTRL]+[C] TO DB2PD MAKES NO NEW CONNECTION
IC95495	2	TABLE FUNCTION SYSPROC.PD_GET_DIAG_HIST MAY TRAP WITH SIGSEGV WHEN START_TIME/END_TIME PARAMETERS ARE PROVIDED
IC95263	2	DB2PD AND DB2PDCFG COMMANDS TERMINATE ABNORMALLY WHEN DB2AUDIT IS ENABLED ON WINDOWS PLATFORM
IC95464	2	DB2TOP COLLECTOR MODE (-C) STOPS IF 2GB OUTPUT FILE SIZE IS REACHED
IC96415	2	SYSPROC.PD_GET_LOG_MSGS FUNCTION CAN FAIL WITH SQL0430N / SQLSTATE=38503
IC96346	2	PD_GET_DIAG_HIST MAY HIT ERROR "DIA8301C NO MEMORY AVAILABLE IN THE APPLICATION HEAP"
IC95501	2	DB2PD -STACK ALL OR DB2PD -DUMP ALL MAY CRASH THE INSTANCE WITH SIGNAL 11.
IC95272	2	DB2DART /RHWM COMMAND FAILS AND REPORTS ERRORS AS IT IS TRYING TO ACCESS NONEXISTING PAGE.
IC95266	2	DB2DART TRUNCATES DBPATH NAMES CONTAINING BLANKS ON WINDOWS AND LINUX
IC94546	2	IN SOME CASES CALLING 'USER-SPECIFIED PROFILE' FROM DB2SUPPORT MAY CAUSE SCRIPT TIME-OUT REGARDLESS OF THE SETTING OF 'TIMEOUT'.
IC93957	2	DB2 INSPECT: SPACE MAP PAGE INVALID PAGE STATES FOR EXTENT AT LOCATION <NNNN> IN THE SPACE MAP PAGE, EXTENT CONTAINS USED AND NO
IC97529	2	EXCESSIVE MEMORY GETS UTILIZED BY PD_GET_DIAG_HIST
IC95217	2	CLEANUP OF MESSAGES QUEUES USED TO COMMUNICATE WITH DB2AUD WHEN PROCESS INTERRUPTED BY USER
IC95240	2	DB2SUPPORT -D <DB_NAME> MIGHT HANG BECAUSE OF LOCK HELD BY OTHERAPPLICATIONS ON SYSTEM CATALOG ROWS/TABLES
IC95458	3	DB2DART FAILING TO RUN WITH SQLSPCS FILES MORE THAN 2G SIZE
IC95251	3	PROBLEM WITH HANDLING "\R" CARRIAGE RETURN ON WINDOWS DURING PARSING DB2SUPPORT.PROFILE FILE.
IC95255	3	DB2DART IS NOT DUMPING THE REFERRING PAGE IN AN INDEX CORRUPTIONDETECTION
IC95212	3	WHEN QUITTING DB2TOP INTERACTIVE MODE USING INTERRUPT KEY '^C', TRAP FILE (*.APP_TRAP.TXT) IN 0 BYTE WILL BE GENERATED.
IC97795	4	DB2DIAG MAY GIVE UNEXPECTED DIAGNOSTIC LOG ENTRY
Fix Pack 3 - Process Model
IC95376	1	ON LARGE DPF SYSTEMS, DB2START MAY FAIL WITH SQL0901 ON SOME MEMBERS DUE TO INSUFFICIENT FCM MEMORY
IC94869	2	COORDINATOR AGENT MAY HANG WITH PENDING REMOTE REQUEST STATUS DUE TO DISCARDED BUFFER.
IC95373	2	DB2 MIGHT ENCOUNTER "MEMORY CORRUPTION" ERROR AND THEN PANIC
IC95239	2	CALLS TO SQLF_FIX_DBM_CFG BY DOWNLEVEL CLIENT CAN RESULT IN EACCESS IF USER DOESN'T HAVE WRITE PERMISSION TO DB2SYSTM
IC96339	2	DB2STOP FORCE HANGS WHEN INSTANCE IS QUIESCED IN RESTRICTED ACCESS
IC97387	2	HEALTH MONITOR MAY GET WRONG ACTIVE LOG FILE NUMBER WHEN ONLINE BACKUP WAS ISSUED AND MISTAKENLY ASSUMED FLIPPED OVER BY LOGGING
IC95339	2	DB2 INTERMITTENTLY CRASHES WITH A MEMORY CORRUPTION WHEN CALLINGSQLERGETFMPIPC
IC98186	2	PARALLELISM BEING TURNED ON DUE TO REGRESSION FROM DEFECT 962791
IC95462	2	THE DB2 INSTANCE MAY HANG OR TRAP ON LINUX WHEN USING A HIGH NUM_INITAGENTS SETTING
IC96601	2	FENCED WRAPPER GETS HANG SPORADICALLY AFTER -1131 ERROR
IC95222	2	SQL0973 NO MEMORY IN PACKAGE CACHE WHEN USING INSUFFICIENT FIXEDDATABASE MEMORY SETTING
IC98914	2	TRAP OR HANG WHEN LDAP DIRECTORY ENTRIES FOR A DB2 DATABASE ARE INCONSISTENT.
IC94475	2	REMOVE SMALL AMOUNT OF UNNECESSARY OVERHEAD BUILT INTO DBMS SET SIZING
IC95279	2	SYSIBMADM.DBCFG NOT DISPLAYING FLAGS AND DEFERRED FLAGS VLAUE COMPUTED
IC97376	2	INTERRUPT POOLED DATABASE AGENTS WHICH ARE SERVING NEW APPLICATIONS THAT HAVE NOT CONNECTED TO THE DATABASE YET.
IC95297	2	DB2 TRAPPED WITH SIGSEGV IN SQLTGETS
IC95592	2	TRAP IN SQLODSHR CALLED FROM SQLESUBCOORDTERM
IC95228	2	SQL0952N : INCORRECT TIMEOUT VALUE OF -1 LEADS TO NODE FAILURES AND INTERMITTENT "LOG STATE MARKED BAD" ERRORS
IC94385	3	INCORRECT PERMISSIONS ON DB2NODES.CFG FILE AFTER FAILOVER
IC97759	3	UPGRADE FROM DOWNLEVEL PERMITS OTHER CONNECTION FROM SAME USER PERFORMING UPGRADE TO CONNECT AND CRASH THE SERVER.
IC95233	3	SQLCODE -1229 RECEIVED ON DB2LUSED CONTINUOSLY EVEN AFTER A LOT OF TIME HAS PASSED AFTER THE LAST NODE RECOVERY
Fix Pack 3 - Query Compiler Optimizer
IC95245	1	DB2 CAN TRAP WHEN COMPILING A SUB-QUERY THAT IS APPLIED ON XMLQUERY()
IV51450	2	DB2 BLU PERFORMANCE ISSUE WITH ANY2ANY IN CASE EXPRESSION WHICH DOES NOT GET MARKED TO ALLOW PUSHDOWN
IC96605	2	EXECUTION OF A QUERY USING DB2 TEXT SEARCH MIGHT BE SLOW
IC95511	2	OPTIMIZER COMPUTES INCORRECT CARDINALITY ESTIMATE IN PRESENCE OFSTATISTICAL VIEW WITH OVERLAPPING COLUMN GROUP STATISTICS
IC95445	2	DB2 CAN TRAP IN SQLNO_ZZ_STARJN_COMPUTE_INDEX_QUNS_REFD
IC96607	2	DB2 GET RECOMMENDATIONS FOR HEALTH INDICATOR DB.TB_REORG_REQ ON DATABASE RETURN WRONG RESULTS
IC99464	2	A SELECT STATEMENT WITH A PREDICATE 'IN ( ITEM-1, ITEM-2, ... ITEM-N )' MIGHT CRASH THE DB2 SERVER
IC96345	2	DB2 COMMAND EDITOR CRASHES WHILE RUNNING VISUAL EXPLAIN
IC95452	2	AUTOMATIC REORG RETURNS SQL2220W ON REORG OF EMPTY COMPRESSED TABLE AND DICTIONARYOPTION="REBUILD"
IC95246	2	INSTANCE CRASH WHEN DATABASE MANAGER HAS INTRA_PARALLEL SET TO "ON" AND MAX_QUERY_DEGREE IS GREATER THEN 1 OR IS "ANY"
IC95322	2	SQL0901 ERROR IN DPF WHEN COMPILING A QUERY WITH AN EQUALITY PREDICATE REFERENCING A NULL CONSTANT
IC95284	2	UNDER RARE CONDITIONS, AUTOMATIC STATISTICS COLLECTION MIGHT NOTOCCUR DUE TO LOST UDI INFORMATION
IC96305	2	UNDER RARE CIRCUMSTANCES A QUERY MIGHT FAIL WITH -901 WHEN COMPILING IN SMP
IC95280	2	UNDER RARE CONDITIONS, AUTOMATIC STATISTICS COLLECTION CAN LEAD TO AN ACTIVE LOG FULL CONDITION.
IC96227	2	RUNSTATS WITH SYSTEM SAMPLING ON A COLUMN-ORGANIZED TABLE MIGHT PRODUCE AN INCORRECT COLCARD STATISTIC
IC95453	2	DB2ADVIS MAY FAIL WITH SQL0304N WHEN PROCESSING LARGE INPUT FILES
IC95438	2	SMALL PRIVATE MEMORY LEAK ON THE DB2 SERVER EVERY TIME AN OPTIMIZATION PROFILE IS LOADED
IC95344	3	PAGE_FETCH_PAIRS AND AVGPARTITION_PAGE_FETCH_PAIRS STATISTICS CANNOT BE CLEARED BY MANUAL UPDATE IF VARCHAR2 COMPATIBILITY IS ON
IC96603	3	AUTOREORG USES INDEX REBUILD OPTION AGAINST PURESCALE SERVER RESULTING IN SQL1419
IC95353	3	RUNSTATS ON XML COLUMNS PRODUCES INAPPROPRIATE WARNING LEVEL DIAGNOSTIC MESSAGES.
IC96922	3	USER-DEFINED FUNCTION WITH INDEX EXTENSION EXPLOITATION MIGHT RETURN INCORRECT RESULTS IF INDEX IS NOT PRESENT
IC97414	3	SYSCAT.COLUMNS.NUMNULLS STATISTICS MIGHT BE INACCURATE AT ALL TABLE SAMPLING RATES.
IC96228	3	RUNSTATS WITH BERNOULLI SAMPLING ON A COLUMN-ORGANIZED TABLE PRODUCES INCORRECT STATISTICS
IC95387	3	DB2 MIGHT TRAP WHILE COMPILING AN SQL STATEMENT ELIGIBLE FOR STAR JOIN
Fix Pack 3 - Query Compiler QGM
IC98202	1	OUTER JOIN QUERIES WITH COMPLEX OPERANDS MAY EXPERIENCE POOR PERFORMANCE
IC97615	1	CASE EXPRESSION PREDICATES MIGHT BE INCORRECTLY REWRITTEN
IC98160	1	POSSIBLE INCORRECT RESULT ON MULTIPLE OUTER JOINS AND A COMBINATION OF EQUALITY JOIN PREDICATES AND LOCAL PREDICATES
IC95526	1	MERGE STATEMENT WITH ONLY MATCHED CONDITION AND DISTINCT MIGHT LEAD TO PERFORMANCE DEGRADATION
IC97738	1	SECURITY: QUERY WITH OLAP SPECIFICATION CAUSES DB2 SERVER TO SHUTDOWN DATABASE. (CVE-2013-6717)
IC95311	2	THE QUERY COMPILER CAN ASSUME A DEFAULT CARDINALITY FOR A CGTT
IC95522	2	THE QUERY STATEMENT WITH A SUBQUERY PREDICATE MIGHT NOT RETURN ROWS AFTER ENABLING DB2_COMPATIBILITY_VECTOR=ORA
IC95317	2	DB2 MIGHT PRODUCE SQL0901N WHEN USING RATIO_TO_REPORT OLAP FUNCTION
IC95485	2	ALTER TABLE STATEMENT REFERENCING A TABLE NAME CONTAINING TRAILING SPACES MIGHT PRODUCE SQL0901N
IC95326	2	IN A FEDERATION SYSTEM, AN UPDATE/DELETE STATEMENT DOES NOT APPLY THE PREDICATES CONTAINING FUNCTION TEMPLATES
IC95273	2	COLUMN OF XML TYPE WITH INLINE LENGTH OPTION MIGHT CAUSE MEMORY CORRUPTION
IC96560	2	INSTANCE CRASH IF A QUERY CONTAINS A SUB-SELECT STATEMENT WHICH INCLUDES ONE OR MORE OLAP FUNCTIONS
IC96572	2	CREATE COMPILED FUNCTION/PROCEDURE/TRIGGER FAILS WITH SQL0109 IFISOLATION LEVEL CLAUSE IS SPECIFIED AND CTE IS REFERENCED
IC95338	2	QUERIES USING OUTER JOINS AND SCALAR SUBQUERY RUNS SIGNIFICANTLYSLOWER COMPARING TO OUTER JOINS AND LOCAL PREDICATES
IC97098	2	CREATE FUNCTION FAILS WITH SQL0109 WHEN QUERY INCLUDES "WITH UR"
IC96653	2	CREATE STATISTICAL VIEW ON COLUMNAR STORAGE (BLU) TABLE FAILS WITH SQL1667N
IC95225	2	SET VARIABLE STATEMENT MAY CAUSE DB2 TO TERMINATE ABNORMALLY.
IC95256	2	AN INSERT, UPDATE OR DELETE STATEMENT ON A TABLE WITH ROW AND COLUMN ACCESS CONTROL ENABLED MAY RESULT IN SQL901N OR SQL1224N.
IC95304	2	FED:FEDERATED QUERY WITH A LARGE AMOUNT OF COLUMNS COULD EXPERIENCE LONG TIME COMPILATION
IC95441	2	SQL0206N ERROR REFERENCING COLUMN RETURNED FROM AN ASSOCIATIVE ARRAY OF RECORDS IN ORACLE COMPATIBILITY MODE
IC95267	2	QUERY CONTAINING EXISTS SUBQUERY AND FETCH FIRST N ROWS CLAUSE MIGHT PRODUCE INCORRECT RESULTS
IC95715	2	SQL FUNCTION DEFINER NOT GIVEN WITH GRANT OPTION (CAN LEAD TO ERRORS LIKE SQL0551N ON LATER GRANT)
IC95335	2	PERFORMANCE DEGRADATION MIGHT BE NOTICED WITH NOT EXISTS SUBQUERY WITH MULTIPLE TABLES.
IC95380	2	DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING A QUERY WITH DATETIME PREDICATES
IC97600	2	HOT: DB2 MIGHT PRODUCE INCORRECT RESULTS FOR QUERIES CONTAINING UNION ALL AND CTE OR VIEWS
IC97954	2	EXCEPTIONALLY LONG COMPILATION TIME WHILE QUERY CONTAINS GROUPING SETS, ROLLUP OR CUBE
IC95482	2	AN OUTER JOIN ON A UNION ALL VIEW MIGHT RESULT IN SQL1585N ERROR
IC95358	2	UNEXPECTED OPTIMIZED STATEMENT FOR VIEW
IC95269	2	QUERY CONTAINING MULTIPLE EQUIJOIN PREDICATES MIGHT FAIL WITH SQL0901N
IC97595	2	HOT: DB2 MIGHT PRODUCE INCORRECT RESULTS FOR QUERIES CONTAINING UNION ALL AND CTE OR VIEWS
IC96632	2	POOR QUERY PERFORMANCE IF JOIN PREDICATE APPLIED TO THE FIRST AND LAST COLUMNS OF AN INDEX WITH INTERMEDIATE LOCAL PREDICATES
IC95241	2	DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF SIMPLE SINGLE-ROW MERGE STATEMENT
IC95359	2	UNEXPECTED OPTIMIZED STATEMENT FOR VIEW
IC95491	2	QUERY WITH NOT EXISTS PREDICATES MIGHT HAVE PERFORMANCE DEGRADATION
IC96352	2	SQL FUNCTION CONTAINING XML ARGUMENTS MIGHT CAUSE DB ABEND
IC95283	2	QUERY WITH XQUERY/XPATH OPERATORS MAY RUN SLOWER WHEN UPGRADING FROM VERSION 9.5.
IC95396	2	MEMORY LEAK IN COMPILER MEMORY POOL WHEN COMPILING A SQL QUERY THAT REFERENCES A FEDERATED DATA SOURCE
IC95529	2	DB2 MAY ABEND WHILE COMPILING QUERY WITH ALWAYS FALSE PREDICATE AT LEFT OUTER JOIN ON CLAUSE
IC95247	2	DATABASE SYSTEM ERROR 'SQLCODE=-901, SQLSTATE=58004' MAY OCCUR WHILE CREATING PL/SQL PACKAGES
IC95554	3	TO_CHAR( CHARACTER-EXPRESSION, FORMAT-STRING ) RETURNS SQL20447NIN VARCHAR2 COMPATIBILITY MODE
IC95549	3	TRANSLATE FUNCTION RETURNS WRONG DATA TYPE WITH MIXED GRAPHIC/NON-GRAPHIC ARGS
IC95370	3	VALUES STATEMENT CONTAINING THE VALUE NULL MIGHT RETURN SQL901N IN THE PARTITIONED DATABASE ENVIRONMENT
IC97047	3	DB2 IS ALLOWING PL/SQL ROUTINES TO BE CREATED WHEN VARIABLES FORTHE CURSOR DO NOT MATCH THOSE IN THE FOR LOOP.
IC95385	3	DIFFERENT BEHAVIOUR IN DB2 WHEN USING ORACLE SYNTAX "CONNECT BY NOCYCLE LEVEL"
IC95261	3	QUERY WITH NOT EXISTS PREDICATES MIGHT HAVE PERFORMANCE DEGRADATION
Fix Pack 3 - Relational Data Services
IC96351	1	DB2 MAY HANG WHEN -901 ERROR IS ENCOUNTERED, YOU WILL SEE MESSAGE "APPLICATION IS ALREADY QUEUED BY A THRESHOLD"
IC95512	2	"MEMORY LEAK" ISSUE IN PACKAGE CACHE.
IC96475	2	THE SQL ROUTINE USING COMPILED COMPOUND STATEMENT MIGHT TRIGGER REPLY ONLY WINDOW ON HADR STANDBY ENABLED FOR ROS
IC96571	2	PERFORMANCE HIT WHEN A GLOBAL VARIABLE IS FIRST REFERENCED IN A SESSION
IC95352	2	INSTANCE MAY TRAP WITH SEGMENTATION VIOLATION WHEN COMPILATION FAILS DURING IMPLICIT REBIND
IC97004	2	DB2 INSTANCE MIGHT TRAP IF A USER REBINDS A PACKAGE WITHOUT HAVING EXECUTE PRIVILEGE ON IT.
IC95489	2	DB2 TRAPS WHEN DB2EXPLN TRYS TO DESCRIBE THE ACCESS PLAN OF A SQL THAT DOESN'T EXIST WITH "-CACHE" OPTION
IC95220	4	USING ALL TEN PARAMETERS FOR DB2RBIND RESULTS IN SYNTAX ERROR
Fix Pack 3 - Security
IC94939	1	SECURITY: DENIAL OF SERVICE VULNERABILITY IN DB2's FAST COMMUNICATIONS MANAGER. (CVE-2013-4032)
IC95460	2	TRANSPARENT LDAP DOESN?T USE THE CORRECT METHOD TO GATHER THE GROUP MEMBERSHIP ON SOLARIS.
IC96425	3	EXECUTE CATEGORY AUDIT LOGS CONTAIN INCORRECT EVENT VALUES WHEN VIEWED IN TABLE FORMAT
Fix Pack 3 - XML
IC97665	1	PRIVATE MEMORY LEAK IN DB2SYSC TRIGGERED BY EXECUTING XML QUERIES
IC95502	1	DB2 MIGHT CRASH WHEN YOU ARE INSERTING XML FILE CONTAINING LARGETEXT NODE TO THE XML COLUMN
IC95508	1	INSTANCE TRAP WHEN ACCESSING XML BINARY DOCUMENT
IC95379	2	INSTANCE TRAP OR -901 WHEN INSERT OR QUERY LARGE XML DOC
IC96518	2	CRASH IN XMLVSTREAMINGNORMSPACE ON LINUX/PPC64
Fix Pack 3 - pureScale Services
IC96562	1	IN A DB2 HA ENVIRONMENT, IF DB2HAICU IS SETUP WITH FQHN, DB2START CAN FAIL WITH SQL6048N
IC96568	2	RUNNING "DB2HAICU -DISABLE" DOES NOT UNSET THE "CLUSTER MANAGER"DBM CFG VALUE IF A CLUSTER DOMAIN DOES NOT EXIST.
IC95260	2	DB2GCF -S REPORTS THAT ALL PARTITIONS ARE 'OPERABLE' IF THE DEFAULT PARTITION IS STOPPED.
IC95313	2	TSA AUTOMATED HADR DATABASE DOES NOT FAILOVER AFTER UNPLUGGING PUBLIC NETWORK CABLE FROM THE PRIMARY SERVER
IC97081	2	CLUSTER CACHING FACILITY FAILS TO START
IC95450	2	DB2GCF UTILITY UPDATES THE DB2NODES.CFG TO SHORT HOSTNAME INSTEAD OF FULLY QUALIFIED HOST NAME
IC97531	3	THE "DB2CLUSTER -CM -REPAIR -RESOURCES" COMMAND SHOULD FAIL IF THE INSTANCE IS STARTED
IC95861	3	PURESCALE FAILS TO START MEMBER WHERE ONE OR MORE OF ITS ASSOCIATED GPFS FILESYSTEMS IS SET TO AUTOMOUNT
IC95912	3	THE "DB2INSTANCE -LIST" COMMAND TAKES A LONG TIME TO RETURN WHENA CLUSTER HOST IS OFFLINE
IC97771	3	DB2INSTANCE COMMAND TEMPORARY SHOWS CF STATE AS ERROR

DB2 Version 10.5 Fix Pack 2
APAR	Sev.	Abstract
Fix Pack 2 - Client Interfaces
IC94164	1	IN SOME CASES SQLGETDIAGFIELDW FUNCTION WILL TRUNCATE THE DIAGNOSTIC MESSAGE RETURNED.
IC94853	1	END COMPOUND STATEMENTS THROWS DRIVER NOT CAPABLE AGAINST INFORMIX 12.0, WORKS FINE WITH IDS 11.7
IC94126	2	.NET APPLICATION GETS SYSTEM.EXECUTIONENGINEEXCEPTION AFTER CONNECTING TO A DATABASE
Fix Pack 2 - Data Recovery Services
IC93406	2	DB2PD -LOGS AND MON_GET_TRANSACTION_LOG() DO NOT RETURN RIGHT LOG CHAIN ID
Fix Pack 2 - Install and Catalog Services
IC96199	1	DB2 PURESCALE ONLINE FIXPACK UPDATES: SHORT HOSTNAMES CAUSE ONLINE FIXPACK UPDATE TO FAIL
Fix Pack 2 - JDBC Driver
IC96732	3	TO DOCUMENT ALL THE JCC APAR AND DEFECTS SHIPPED WITH DB2V10.5FP2 RELEASE
IC95559	3	PERFORMING SQLJ CUSTOMIZATION ON A 3-TIER CONNECTION TO DB2 10.1, CONNECTION FAILS WITH A DRDA DATA STREAM SYNTAX ERROR -4499.
IC92609	3	THE NEXT() METHOD OF RESULTSET GETS AN SQLEXCEPTION WITH ERRORCODE=-4228 AFTER THE TABLE BEING QUERIED HAS BEEN ALTERED.
IC92930	3	NULLPOINTER EXCEPTION OCCURS WHEN EXECUTING A BATCH CONTAINING AN SQL WITH A 'INSERT FROM SELECT CLAUSE'
IC92579	3	NULLPOINTER EXCEPTION WHEN YOU SET SYSTEM.ERR TO NULL (System.setErr(null)) AND TRY TO CONNECT TO Z/OS USING TEMPORARY LICENSE FILE
IC94489	3	EXECUTEBATCH FAILS IF ONE OF THE STRING COLUMN IS SET USINGSETDBSTRINGASBYTES WITH SQLCODE = -302
IC92105	3	JCC DRIVER DOESN'T CLOSE NON XA TRANSACTION (WITH AUTO COMMITON) IN CASE OF EXCEPTION IN EXECUTION

DB2 Version 10.5 Fix Pack 1
APAR	Sev.	Abstract
IC99555	1	SQLPARAMDATAADONET SYSTEM.ACCESSVIOLATIONEXCEPTION .
Fix Pack 1 - Columnar data engine storage manager
IC95090	1	IN RARE CIRCUMSTANCES, ACCESS TO A COLUMN ORGANIZED TABLE MAY FAIL WITH A RECURRING -901 ERROR.
IV46859	2	LOAD INTO COLUMN-ORGANIZED TABLE MIGHT CORRUPT DATA RESULTING ININCORRECT RESULTS
IV46889	2	ERRORS AFTER RESTORING AN ONLINE BACKUP TAKEN WHILE LOADING INTOA COLUMN-ORGANIZED TABLE
Fix Pack 1 - Codegen and Runtime
IC94991	1	BITWISE SCALAR FUNCTIONS MIGHT RETURN INCORRECT RESULTS WHEN USED WITH DECFLOAT DATATYPE ON AIX POWER7
IC94133	1	INSTANCE TRAP IN SQLRI_LIKE_ALLOC()
IC94095	2	EXCESSIVELY LARGE MEMORY ALLOCATION ATTEMPTS FROM FAST INTEGER SORT DUE TO WRONG MEMORY SIZE CALCULATION
IC95295	2	QUERY WITH TABLESAMPLE SYSTEM() MIGHT HANG IN SMP MODE (INTRA_PARALLEL = YES)
IC95258	2	MEMORY OVERWRITE CAN HAPPEN WHEN ARRAYS WITH ELEMENTS OF LARGE SIZE ARE USED.
Fix Pack 1 - Communication
IC95371	2	XAER_NOTA RETURNED BY DB2 CONNECT SERVER WHEN TM TRIES TO PREPARE/COMMIT/ROLLBACK A TRANSACTION IN DISTRIBUTED ENVIRONMENT.
Fix Pack 1 - Index Manager
IC93971	1	INDEX / DATA MISMATCH MIGHT OCCUR IN AN MDC TABLE AFTER A DEFERRED ROLLOUT
Fix Pack 1 - Install and Catalog Services
IC93983	1	DB2 V10.5 SQL8029 WITH TERABYTE LICENSES
IC93384	1	CONCURRENT CREATE/ALTER TABLE STATEMENTS CONTAINING "GENERATED ALWAYS AS IDENTITY" COLUMN MIGHT END UP WITH AN INFINITE LOOP
IC95332	2	DB2IUPDT FAILS WHILE TRYING TO MOVE INSTANCE TO NEWLY INSTALLED FIXPACK LOCATION, IF FIXPACK IS INSTALLED USING UNIVERSAL IMAGE
IC94407	2	DATABASE MANAGER PARAMETERS ARE RESET TO DEFAULT AFTER INSTANCE UPDATE
IC93348	3	MICROSOFT VISUAL C++ RE-DISTRIBUTABLE TO BE INCLUDED IN VISUAL STUDIO ADD-IN INSTALL
Fix Pack 1 - Platform Specific
IC95167	2	TIMESTAMPS MAY NOT REFLECT DAYLIGHT SAVINGS TIME CHANGES IN CERTAIN SITUATIONS
IC95363	2	DB2 WINDOWS MESSAGE : ZRC=0X870F0002=-2029060094=SQLO_BPSE "DEBUG LOGIC ERROR DETECTED" WITH NO FILE SYSTEM CACHE
Fix Pack 1 - Query Compiler Optimizer
IC94298	1	RANGE PARTITIONED TABLES DEFINED WITH A NULLS FIRST PARTITIONINGCOLUMN MIGHT RETURN INCORRECT RESULTS
Fix Pack 1 - Relational Data Services
IC94758	1	SECURITY: UNAUTHORIZED ACCESS TO TABLE VULNERABILITY IN DB2 (CVE-2013-4033)
Fix Pack 1 - Text Search
IC94311	2	TEXT SEARCH INDEX UPDATE ERROR "CLI0129E,THERE ARE NO MORE HANDLES TO ALLOCATE" WHEN INDEXING LARGE NUMBER OF DOCUMENTS