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

Technote (troubleshooting)


Problem(Abstract)

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.

Resolving the problem

Tab navigation

************************************************************
Product Name : DB2 UDB Version 10.5
Updated : Mon Aug 25 16:45:53 EDT 2014
************************************************************

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


DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4)
APAR Sev. Abstract
Fix Pack 4  -  
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  -   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
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
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
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
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


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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1633303

Modified date:

2014-08-29

Translate my page

Machine Translation

Content navigation