Skip to main content

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


Technote (troubleshooting)


Problem(Abstract)

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

Resolving the problem

************************************************************
Product Name : DB2 UDB Version 101
Updated : Fri Jan 25 14:44:19 EST 2013
************************************************************

Select a Fix Pack: 2 | 1


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


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


Related information

Download DB2 LUW Fix Packs

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

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

DB2 for Linux, UNIX and Windows


Software version:
10.1


Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows


Reference #:
1610653


Modified date:
2013-02-14

Translate my page

Content navigation