IBM Support

APAR Fix List for DB2 Version 9.8 for Linux, UNIX and Windows

Troubleshooting


Problem

DB2 9.8 APAR Fix list contains list of APARs shipped for each fix pack of the IBM® DB2® pureScale™ Feature for Enterprise Server Edition. 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 Version 9.8
Updated : Wed May 30 10:44:53 EDT 2012
************************************************************

Select a Fix Pack: 5 | 4 | 3


DB2 Version 9.8 Fix Pack 5
APAR Sev. Abstract
IC81404 2 A MEMBER WAS KILLED DUE TO ROCM EVENT TIMEOUT.
IC79552 2 THROUGHPUT DEGRADATION WITH READ ONLY TRANSACTIONS DURING RECOVERY AFTER ISSUING "HALT -Q" ON ONE OR MORE MEMBERS/CF
IC83439 2 CLUSTER CACHING FACILITY MAY FALSIFY IGNORE XI STATE
IC78853 2 RESTORE/CREATE DATABASE FAILS DUE TO LOCK STRUCTURE ALLOCATION TIMEOUT WITH LARGE CF
IC78533 2 SMALL MEMORY LEAK IN DATABASE HEAP IN PURESCALE ENVIRONMENT WHEN PERFORMING DDL OR BUFFERPOOL/TABLESPACE MONITORING
IC83797 1 DB2 V9.8 CLUSTER CACHING FACILITY MAY PROCESS WRONG REQUEST
IC83800 2 AN XI FAILURE COULD POSSIBLY RESULT IN AN UNEXPECTED DB2 PAGE EVICTION.
Buffer Pool Services               FP5
IC81851 1 INVALID TABLESPACE IN-MEMORY INFORMATION CAUSED BY CROSS MEMBER TABLESPACE OPERATIONS MIGHT CAUSE INSTANCE TO ABEND
IC82530 1 INTERRUPTING GLOBAL BUFFER POOL PURGE MAY RESULT IN DATA INCONSISTENCY BETWEEN COORDINATOR AND SUBORDINATOR PARTITIONS
IC83352 1 BAD PAGE HEADER ENCOUNTERED BY PREFETCHER DURING ONLINE BACKUP ON LINUX PLATFORM. BACKUP IMAGE MAY BE CORRUPTED.
IC81922 2 GBP-INDEPENDENT PAGES WILL SOMETIMES BE PREVENTED FROM BEING WRITTEN TO DISK WHEN THEY BELONG TO A TEMPORARY TABLESPACE
IC81849 2 NOT ALL CASTOUT ENGINES ARE HELPING WITH SYNCHRONOUS CASTOUT REQUESTS
Client Interfaces               FP5
IC77566 1 CLI FUNCTIONS RETURN SQL_SUCCESS EVEN WHEN SQL_ATTR_INSERT_BUFFERING=SQL_ATTR_INSERT_BUFFERING_IGD AND INSERT COMMAND FAILS
IC79036 2 SQLCONNECT SETS DBNAME INTO DATA SOURCE NAME EVEN IF USER SPECIFIES DBALIAS, THIS CAUSES -842/-1024 IN SUBSEQUENT API.
Common Code Infrastructure               FP5
IC81496 2 QUERIES WITH LIKE OPERATORS MIGHT RETURN INCORRECT RESULTS DUE TO AN INVALID HIGHEST PADDING CHARACTER
IC80426 3 SEVERE SQLOMEMDETACHFROMSEGMENTS MESSAGE LOGGED BY DB2ROCM PROCESS USING PURESCALE FEATURE
DRDA Services               FP5
IC78145 2 UNICODEMGR AND CCSIDMGR CONFLICT ERROR
IC83443 2 ERROR SQL30021 'MANAGER "0X1440" AT LEVEL "9" NOT SUPPORTED' CONNECTING TO DATABASE SERVER VIA AN INTERMEDIATE DB2 INSTANCE
Data Management Services               FP5
IC82728 1 DATABASE CAN BE MARKED BAD DURING RECOVERY OR HADR REPLAY WHEN XML DATA IS IN THE TABLE
IC83438 1 LOG REPLAY OF UPDATE LOB FIELD CONCATENATION CAN CAUSE CORRUPTION
IC81086 1 WITH FILE SYSTEM CACHING ENABLED, SYSTEM OUTAGE MIGHT RESULT IN CORRUPTION DURING LOB OR REORG PROCESSING
IC73860 2 REORG USING SMS TEMP TABLESPACE CAN FAIL WITH ARCHITECTURAL PAGELIMIT REACHED
Data Protection Services               FP5
IC82646 2 MEMORY LEAK IN DATABASE HEAP USING REPLICATION
IC82662 2 MEMORY LEAK USING TWO_PHASE COMMIT TRANSACTIONS AND ACTIVITY INVOLVING LOG SCANNING
Engine Infrastructure               FP5
IC81773 1 -1032 WHEN TRYING TO CONNECT TO DB EVEN THOUGH MEMBER IS STARTED
IC81405 2 ACTIVATE DATABASE COMMAND JUST AFTER DB2START MAY FAIL WITH -1224
IC78895 2 INTERRUPT DURING THE ROLLBACK REQUEST MAY RESULT IN PDB SYSTEM CONTROLLER ON REMOTE NODE TO SEND -952
IC82426 2 FCM SESSION LEAK ISSUE DURING THE STRESS RUN
IC79663 2 AFTER RESTARTING THE PRIMARY CF, THE SECONDARY CF REMAINS IN CATCHUP STATE AND NEVER REACHES PEER STATE
IC82360 2 CLUSTER CACHING FACILITY (CF) LEAKS CONNECTIONS
IC80670 2 RESTART AND RECOVER DATABASE FAIL IF MULTIPLE ALIAS ARE DEFINED
IC82472 3 WHEN DB MEMBER FAILURE OCCURS, READ ONLY TRANSACTIONS THROUGHPUTMAY DEGRADE FOR SEVERAL SECONDS.
IC82000 3 DB2START LEADS TO DEADLOCK/TIMEOUT WHEN MEMBER IS IN RESTART LIGHT
Engine Utilities               FP5
IC82907 1 DB2 MAY ABNORMALLY TERMINATE WHEN USING CLI LOAD
IC82650 1 LOAD RESTART MIGHT REMOVE WRONG DUPLICATE ROW DURING DELETE PHASE, OR BUILD CORRUPTED XML INDEX
IC82540 1 ROLLFORWARD THROUGH AN ONLINE LOAD WITH INCREMENTAL INDEXING, COPY YES AND DELETE PHASE MIGHT CORRUPT INDEX OR FAIL ROLLFORWARD
IC81467 1 WITH FILE SYSTEM CACHING ENABLED, SYSTEM OUTAGE DURING LOAD PROCESSING MIGHT RESULT IN CORRUPTION
IC82748 1 LOAD RESTART SHOULD NOT BE ALLOWED ON AN XML LOAD THAT FAILED ORWAS INTERRUPTED IN BUILD PHASE
IC83329 2 LOAD RESTART MIGHT INSERT INVALID TIMESTAMPS INTO TABLE WITH ROWCHANGE TIMESTAMP COLUMNS
High Availability               FP5
IC82593 1 GPFS FAILS TO RESTART AFTER MEMBER/CF RECOVERY
IC78609 2 "DB2CLUSTER -CM -EXIT -MAINTENANCE -ALL" MAY FAIL TO MOUNT ALL FILESYSTEMS.
IC78359 2 "DB2CLUSTER -CM -LIST -ALERT" ONLY LISTS ALERT FOR FIRST MOUNT POINT.
IC80507 2 "DB2CLUSTER -CM -ENTER -MAINTENANCE -ALL" MAY GET ERROR IF ISSUED BEFORE CLUSTER STATE BECOMES ONLINE BY PREVIOUS EXIT COMMAND
IC81749 2 DB2CLUSTER -CM -ENTER -MAINTENANCE -ALL COMMAND MAY FAIL, BUT DOMAIN MAY BECOME OFFLINE AFTER THE ERROR MESSAGE.
IC81825 2 DB2CLUSTER -CFS -EXIT -MAINTENANCE WILL COREDUMP IF ERRORS ARE ENCOUNTERED
IC80068 2 DB2CLUSTER -CREATE -FILESYSTEM FAILS WITH 0518-506 ODMGET: CANNOT OPEN OBJECT CLASS CUAT.
IC78998 2 GPFS FAILS TO RECOVER DUE TO CONDRESPV98_RESP.KSH SCRIPT BEING RUN IN PARALLEL
IC81166 2 THE DB2CLUSTER COMMAND MAY FAIL IF THE GRACE PERIOD RSCT PARAMETER IS CHANGED FROM ITS INITIAL VALUE.
IC78629 2 ADM7530W AN UNEXPECTED CLUSTER CACHING FACILITY (CF) ERROR OCCURRED DUE TO TIMING HOLE.
IC78819 2 INSTANCE NAME INCLUSION IN GPFS PATH CAUSES CAUSES THE RESOURCE STATE INCONSISTENT
IC78358 2 "DB2AUDIT CONFIGURE DATAPATH" MAY DELETE THE RESOURCE GROUP UNEXPECTEDLY.
IC78361 3 IF GPFS IS STARTED WHEN RMC IS NOT AVAILABLE, IMPROPER MESSAGE FROM GPFSREADY MAY BE LOGGED IN SYSLOG
IC80806 3 CANNOT CLEAR AN ALERT ALTHOUGH DB2CLUSTER -CM -CLEAR -ALERT WAS EXECUTED.
Index Manager               FP5
IC83130 1 INDEX CORRUPTION IN PURESCALE MODE
IC81699 2 FAILED ONLINE LOAD WITH INDEX REBUILD CAN LEAD TO MISMATCH BETWEEN TABLE AND INDEX
Install               FP5
IC81210 2 INSTALLER SHOULD HANDLE THE CASE WHEN THE ROOT UMASK IS NOT 022 FOR SD FEATURE INSTALL
IC81777 2 FIXPACK ROLLS BACK DURING TSA UPGRADE DUE TO HAVING A PERMANENT LICENSE INSTALLED AND A TRY AND BUY LICENSE ON THE IMAGE
IC79204 2 DB2AUDIT.CFG IS A LOCAL COPY ON A NODE ADDED USING DB2IUPDT: IT SHOULD BE A LINKED COPY TO SQLLIB_SHARED
IC81219 2 DB2ICRT DOES NOT RETURN AN ERROR WHEN THE .SSH DIRECTORY EXISTS AND IT'S NOT EMPTY IN THE SHARED DISK
IC79870 3 PURESCALE INSTALL FAILS WHEN AN EXISTING GPFS CLUSTER WAS CREATED USING THE IB ADAPTER AS THE HOST
Interpartition Communication               FP5
IC78785 3 SUPPRESS SOME DIAGNOSTIC MESSAGES IN ASYNCLINKCONNECT WHEN LOGICAL MEMBER IS STOPPED INTENTIONALLY
Monitoring               FP5
IC83377 1 THE SYSIBMADM.SNAPDB ADMINISTRATIVE VIEW AND THE SYSPROC.SNAP_GET_DB_V97( <DBNAME> ) TABLE FUNCTION ARE MISSING ROWS.
IC82815 2 SYSPROC.MON_GET_APPL_LOCKWAIT RETURNS NULL FOR LOCK_STATUS
IC82225 2 CERTAIN TIME SPENT METRICS RETURNED BY MON_GET_BUFFERPOOL, MON_GET_CONTAINER, MON_GET_TABLESPACE AND SNAPSHOTS ARE INCORRECT
Problem Determination               FP5
IC82610 2 DB2PD -EVE RUNS DB2PD -HA WHICH IS PROHIBITED IN PURESCALE
IC82516 2 DB2TOP DUMPS CORE ON AIX WHEN SHOWING SQL TEXT LOGNER THAN 8028 BYTES
IC79927 3 DB2TOP DUMPS CORE WHEN ENTERING AN INVALID SQL HASH STRING
Quality Assurance               FP5
IC82515 2 HOSTNAME CONTAINING THE UNDERSCORE CHARACTER CAUSES SQL1517N DURING DB2START
IC83137 2 THE FOLLOWING COMMANDS FAIL "DB2CLUSTER -CFS -[ENTER/EXIT] -MAINTENANCE" WHEN USING GPFS VERSION 3.4 WITH DB2_V98FP4
IC82747 2 LOCK EVENT MONITOR RETURNED "LOCK MODE HELD : NONE".
IC82958 2 MEMORY LEAK IN APPLICATION HEAP IN DB2 9.8 OR HIGHER USING THE DB2READLOG API OVER A PERSISTENT CONNECTION
IC82076 2 DROP TABLE COMMANDS ARE SOMETIMES SLOW IN DB2 PURESCALE ENVIRONMENTS
IC82364 2 ONLINE DATABASE BACKUP MAY FAIL WITH "BAD PAGE HEADER" MESSAGES IN PURESCALE IF DATABASE WAS MIGRATED FROM PRE 9.8 LEVEL
IC82804 2 LOB/LONG TABLESPACE GROWS MUCH LARGER THAN REQUIRED FOR THE ACTUAL DATA BEING STORED
IC82043 3 INCOMPLETE DEADLOCK INFORMATION RECORDED FOR DEADLOCK PARTICIPANTS ON DIFFERENT MEMBERS
Query Compiler, Rewrite, Optimizer               FP5
IC83436 1 INCORRECT OUTPUT MIGHT BE RETURNED BY A QUERY WITH PARTITION ELIMINATION INVOLVING MULTIPLE COLUMNS AND NON-CONSTANT KEYS
IC72605 2 DB2 MAY ABEND WHEN QUERY HAS AN OR PREDICATE WHOSE SUBTERM PREDICATES SHARE COMMON TABLE(S) WITH JOIN PREDICATE(S)
Relational Data Services               FP5
IC83464 2 SECURITY: USER CONTINUES TO HAVE PRIVILEGE TO EXECUTE A NON-DDL STATEMENT AFTER ROLE MEMBERSHIP HAS BEEN REVOKED FROM ITS GROUP
IC79680 2 UNEXPECTED SQL204N CAN OCCUR DURING THE IMPLICIT REBIND OF A PACKAGE THAT DEPENDS ON AN INVALID VIEW.
IC73615 2 INCORRECT RESULTS OR "SQL204N TABLE NOT FOUND" ERROR RETURNED WHEN SELECTING FROM VIEW.
IC80359 2 TRAP/SEG-V IN SQLPLNFD WITH EXTENDED INDICATORS AND DEFERRED PREPARE ENABLED
IC83445 2 INCORRECT RESULTS ARE RETURNED IF AN SQL QUERY CONTAINS RID(), RID_BIT() OR ROWID
Self Tuning Memory Manager               FP5
IC70473 2 SECURITY: POTENTIAL CRASH WITH STMM ENABLED AND DATABASE_MEMORY SET TO AUTOMATIC
IC83403 2 SECURITY: POTENTIAL CRASH WITH STMM ENABLED AND DATABASE_MEMORY SET TO AUTOMATIC
IC83437 1 ADMIN_MOVE_TABLE PROCEDURE RETURNS SQL0969N, SQL1188N OR SQL0408N ERROR CODE.
IC83571 2 DB2 TERMINATES ABNORMALLY DURING DATABASE UPGRADE FROM 9.7 FIX PACK 5 TO DB2 VERSION 9.8.
IC82587 2 NON-THREADED STORED PROCEDURE COMPILED IN 32 BIT MODE MAY CAUSE INSTANCE CRASH

DB2 Version 9.8 Fix Pack 4
APAR Sev. Abstract
Administration Tools               FP4
IC68915 2 GET_DBSIZE_INFO WRONG, DATABASECAPACITY SHOWS INCORRECT VALUE
IC69806 2 DB2 MOVE WITH COPY OPTION FROM V9.5/V9.1 TO V9.7 GIVES SQL0206N
IC69262 3 DB2LOOK DOESNT GENERATE THE MODULE STATEMENTS IN ORDER WHEN -CORAND -CT OPTION SPECIFIED TOGETHER
IC69698 3 SEGMENTATION FAULT(COREDUMP) WHILE RUNNING DB2LOOK -D <DBNAME> -E, WHEN THERE ARE MORE THAN 1000 USER DEFINED TYPES
IC77517 3 SYSPROC.AUTOMAINT_GET_POLICYFILE CALL FOR REORG POLICY TRUNCATESTHE REORG TABLE SIZE VALUE IF IT CONTAINS > 6 DIGITS
IC74871 3 DB2INSTACE -LIST SHOWING MISLEADING STATUS FOR SECONDARY CF DURING MEMBER FAIL OVER
IC74467 2 DB2 BACKUP DATABASE DBNAME ONLINE USE TSM WILL HANG
IC75477 2 DB2STOP -FORCE FAILS TO SHUTDOWN DB2 PURESCALE INSTANCE
IC69109 3 DB2LOOK DOES NOT GENERATE CREATE OR REPLACE FOR PACKAGES WHEN -COR OPTION IS GIVEN
Buffer Pool Services               FP4
IC69967 1 DATABASE UPGRADE TO 9.7 FAILS WITH SQL1042C DUE TO ERROR SQLB_BPSE IN SQLBMIGRATEPOOLONDISK
IC71080 1 HWM TOO LOW DUE TO TIMING WINDOW WHEN NEW SMP EXTENT ALLOCATED, CAN LEAD TO DATA CORRUPTION
IC68736 1 DB2 V9.7 : LOAD TERMINATE GIVES SQL0901 (REASON "CANNOT FIND LRB") THEREFORE UNABLE TO ACCESS TABLE
IC76458 1 POSSIBLE ONLINE BACKUP IMAGE CORRUPTION FROM PURE SCALE ENVIRONMENT
IC68345 2 CAPTURE ADDITIONAL DIAGNOSTIC INFORMATION WHEN TRAPPING IN SQLBFREEEXTENTSFOROBJECT
IC77343 2 SHUTTING DOWN THE CLUSTER CACHING FACILITY WITH DIRTY DB2 PAGES MAY RESULT IN LOSS OF DATA
IC69320 2 SELECT FROM SYSIBMADM.ADMINTABINFO CRASHES DATABASE WITH BFIX DETECTED AN ERROR
IC69857 2 ONLINE BACKUP HANGS UP ON DEADLATCH CONDITION BETWEEN DB2BM AND PREFETCHERS
IC77527 2 SET WRITE SUSPEND CONSISTENTLY FAILS WITH SQL1550N RC=5 WHEN THE BUFFERPOOL IS STMM ENABLED.
IC68519 3 CREATE DATABASE / ADD NODE DOES NOT NEED TO CHECK BASE STORAGE PATH PERMISSION IF UNDERLYING SUB-DIRECTORIES CREATED BY USER
Client Interfaces               FP4
IC71323 1 CLI APP THROWS "INVALID CONNECTION STRING ATTRIBUTE" ERR WHEN 'COMMPROTOCOL' IS USED IN DSDRIVER.CFG AND DATABASE IS CATALOGED.
IC68787 2 SQLFREEHANDLE() FOR ENVIRONMENT HANDLE IN CLI APPLICATION RETURNS -1 ON DB2 V9.7 FP1
IC67355 2 HANG WHEN SCHEDULING DB2 COMMAND SCRIPT THROUGH TASK CENTER
IC68375 2 DLL MODULES CAN NOT BE LOADED DUE TO MISSING VC LIBRARIES IN NATIONAL LANGUAGE DIRECTORY OF DATA SERVER DRIVER PACKAGE
IC68586 2 .NET DB2 BULK COPY FOR LOAD OPERATION PRODUCES INCORRECT RESULTS
IC68710 2 RUNNING COBOL APPLICATION MAY FAIL WILL MEMORY BOUNDARY ERRORS.
IC77520 2 DB2 MAY TRAP OR HANG WHEN THE TRACEREFRESHINTERVAL OR QUERYTIMEINTERVAL KEYWORD IS USED WITH A TRUSTED ROUTINE
IC69669 2 CRASH IN DB2APP!CLI_SMPMAPSTATE
IC69931 2 INADEQUATE ERROR MESSAGE WHEN TRANSACTIONTIMEOUT IS REACHED WHILE READING ROWS VIA IFXDATAREADER
IC68483 2 NEED TO HAVE A CLI ERROR REPORTED IN PLACE OF SQL0954C "OUT OF APPLICATION HEAP"
IC69228 2 LIBDB2O.SO MISSING IN ODBC PACKAGES ON V97
IC69970 2 DB2COMMANDBUILDER STATEMENTS RESULT IN TABLE NOT FOUND ERROR WHEN EXECUTING AGAINST IDS ANSI MODE DATABASES.
IC70402 2 THE ENTITY DATA MODEL IS GETTING GENERATED ONLY FOR TABLE TYPE=T.
IC70084 2 POSSIBLE SIGBUS IN CLI FUNCTIONS ON LINUX PLATFORMS
IC71239 3 DB2 CLIENT LIBRARY RELY ON GLIBC "NEW AND DELETE"
IC67579 3 SELECT QUERY ON DATATYPE DATE AND REGISTER CURRENT DATE WITHIN STORED PROCEDURE MAY RETURN UNEXPECTED RESULT ON SOME LOCALES
IC69281 3 ZOS: THE PROVIDER THROWS INVALIDCASTEXCEPTION FOR GETSCHEMA("DATATYPES")
IC68796 3 DB2 CLP CAN HANG OR RETURNS AN ERROR, WHEN ONE DB2 CLP OUPUT IS PIPED INTO A SECOND DB2 CLP COMMAND
IC69626 3 ASSERTION IN SQLEXECUTE AFTER BINDIN THE RAW DATA OF SQL_C_CHAR TO SQL_DECFLOAT WITH PRECESSION VALUE ZERO FAILS.
IC68233 3 CLI KEYWORD TRACESTMTONLY=1 CAUSES CLI TRACE TO NOT DISPLAY RETURN CALL TO SQLEXECUTEOLEDB()
IC68947 3 ROWSAFFECTED VALUE IS NOT RETURNED CORRECTLY WHEN INSERT, DELETE, UPDATE COMMANDS OF DATAADAPTER HAVE DIFFERENT CONNECTIONS
IC77550 3 .NET EXCEPTION IS THROWN WHEN DB2.NET TRACE IS ENABLED
IC69568 3 DERIVEPARAMETERS THROWS EXCEPTION ON STORED PROCEDURE ARRAY PARAMETERS
IC71114 3 DB2 CATALOG USER ODBC DATA SOURCE DOES NOT UPDATE DB2CLI.INI
IC71175 3 STORED PROCEDURE PARAMETERS CORRUPTED DURING PREPARE USING EXECUTEREADER METHOD OF ODBC INTERFACE AND C# PROGRAM
IC69671 3 UNKNOWN OPTION IN DB2CLI FOR PING-DB
IC69279 3 PROVIDER THROWS EXCEPTION DURING BULKCOPY.WRITETOSERVER
IC69700 4 REORGCHK TABLE FORMULAS F3 AND F5 MIGHT STILL ADVISE TO REORG A TABLE EVEN THOUGH THE TABLE HAS BEEN REORG'ED.
Common Code Infrastructure               FP4
IC70442 1 WLM ON 9.7 FIX PACK 2 FAILS TO CHANGE THE AGENT PRIORITY. LINUXONLY
IC68542 2 LOAD FAILING WITH ERROR SQL2044 (RC=3)
IC69022 2 V9.5 FP4/FP5 DIFFERS FROM V9.5 FP3 WHEN ISSUING [CTRL]+[C] FOR PASSWORD PROMPT.
IC71195 2 IMPLICIT CONNECTION RETURNS SQL30082N RC=36 WHEN USING KERBEROS AUTHENTICATION
IC68447 2 FUTURE-DATED TIMESTAMPS REPORTED BY THE DEADLOCK MONITOR ON SOLARIS X86-64
IC69539 2 SETTING A RELATIVE AGENT PRIORITY OF -1 HAS NO EFFECT - 'DB2PD -AGENTS' WILL INCORRECTLY REPORT -1 PRIORITIES
IC67533 2 THE WRONG ROW MIGHT BE FETCHED WHEN USING ADO WITH ODBC OR USINGCLI WITH SQL_ATTR_RETRIEVE_DATA=0 IN A SCROLLABLE CURSOR.
IC67670 2 ERROR HANDLING LOGIC IN THE FUNCTION 'SQLNLSCPREQUESTPKGINFO' MAY LEAD TO A TRAP.
IC67867 2 V9.5 FP4/FP5 DIFFERS FROM V9.5 FP3 WHEN ISSUING AN EXPLICIT CONNECT COMBINED WITH OUTPUT REDIRECTION
IC68800 2 SQL4401C DURING DB2START ON WINDOWS DUE TO TERMINAL SERVICES IN APPLICATION SERVER MODE
IC76633 2 DURING DB2 INSTANCE STARTUP THE DIAGPATH SETTING FOR DB2DIAG.LOG LOCATION IS NOT HONORED FOR A FIRST INFO MESSAGE FROM DB2SYSC
IC69249 2 GETMNTENT() FUNCTION CAUSING TABLESPACES TO RETURN SQL0290N
IC68445 2 MEMORY ALLOCATION DOES NOT SANITY CHECK SIZE REQUESTED ON 64 BITPLATFORM.
IC77545 2 EXPORT COMMAND WITH DEL TYPE GETS ABOUT TWICE SLOWER AFTER DATABASE MIGRATION FROM V8.2 TO V9.5
IC68789 2 WHEN RUNNING DB2 V97 WITH DB2TRC -T -PERFCOUNT, DB2START MAY FAIL, DB2 CONNECT MAY FAIL
IC68464 2 SQL0973 MEMORY ALLOCATION FAILURE FROM LOAD UTILITY
IC68269 2 PERFORMANCE ENHANCEMENT TO MEMORY ALLOCATION CODE FOR CONCURRENTINSERT/UPDATE WITH CODE PAGE CONVERSION
IC69055 2 V9.5 FP4/FP5 DIFFERS FROM V9.5 FP3 WHEN ISSUING [CTRL]+[C] FOR PASSWORD PROMPT.
IC77247 3 DB2DIAG.LOG ENTRY "THE NTP DAEMON IS INACTIVE" IN NON-ENGLISH ENVIRONMENTS.
IC68329 3 VIRTUAL MEMORY LIMIT SET ON LINUX IS NOT OVERWRITTEN BY DB2 START TO UNLIMITED CAUSING MEMORY LIMITATIONS ON VIRTUAL MEMORY.
IC68621 3 ERROR MESSAGE DURING DB2START ON ZLINUX
IC77558 3 IMPORT FROM IXF FILES MAY BE SLOWER THAN EXPECTED WHEN THE ROWCOUNT ATTRIBUTE IS SPECIFIED
IC77120 3 WHEN DIAGPATH IS SET TO SPLIT PER NODE ( $N ), DB2ROCM PROCESS ON CF KEEPS ON LOGGING ERRORS, AND DB2TOP MAY FAIL ON CF BOX
IC68283 3 INCORRECT MAPPING OF RC=2 I.E. ENOENT (FILE DOESN'T EXIST), TO ZRC=2 (WHICH MEANS DEADLOCK), INSIDE LOAD()
Communication               FP4
IC76637 2 INTERRUPTING CLIENT MIGHT LEAD TO ENGINE HANG DUE TO AGENT STUCKIN SEMOP().
IC69140 2 LOCAL CLIENT ABNORMAL TERMINATION STAYS UNDETECTED BY DATABASE ON WINDOWS.
Connection Manager               FP4
IC68404 2 DB2 CRASHES IN FUNCTION WRITETOKEN WITH SEGMENTATION VIOLATION (SIGNAL #11).
IC69709 2 ON 32 WINDOWS, UPGRADING A DATABASE FROM A PREVIOUS VERSION OF DB2 TO 9.7 FP2 REPORTS STACK OVERFLOW EXCEPTION
IC69397 2 DB2 CLIENT TRAPPED IN FUNCTION SQLEUCLOCKCONNECTION USING MSDTC
IC69628 2 MEMORY LEAK WHILE CALLING NESTED STORED PROCEDURES
IC68180 3 RECEIVE TIMEOUT IS RESET TO 0 WHEN BOTH OF DB2TCP_CLIENT_ RCVTIMEOUT AND DB2TCP_CLIENT_CONTIMEOUT ARE SET
IC67663 3 DB2 SERVER MAY HANG ON CALL SYSPROC.WLM_SET_CLIENT_INFO WHEN APPLICATION AND SERVER CODEPAGES ARE DIFFERENT.
Control Center               FP4
IC67718 3 CAN'T FILTER IN CONTROL CENTER WHEN COLUMNS ARE SPECIAL CHARACTERS
DB2 Tools               FP4
IC69675 1 IN DB2LOOK '-COR' OPTION DOESN'T GENERATE CREATE OR REPLACE DDL WHEN THE USER HAS CREATED THE OBJECT WITH BRACKETED COMMENTS I
IC67779 2 THE CONTROL CENTER HADR WIZARD CRASHES DURING EXECUTION OF THE HADR SETUP COMMANDS.
IC69079 2 FOR DB2 ROUTINES WHICH ARE APPENDED WITH "COMMENTS" DURING CREATION, DB2LOOK FAILS TO RE-CREATE THE OBJECT FROM THE DB2LOOK OUTP
IC69168 2 DB2LOOK DOES NOT OBEY -TD; PARSES INCORRECT DELIMITER FOR SUMMARY TABLES
IC69375 2 "RESOURCE GROUP MOVE" COMMAND IN DB2HAICU EXITS SUCCESSFULLY WITH PERSISTENT REQUEST ON THE RESOURCE DUE TO INCORROUT CHECK.
IC68079 3 NNSTAT METHOD 2 FAILS WITH SQL1233N WHEN CALLED TO COLLECT GRAPHIC COLUMNS STATISTICS ON NON-UNICODE FEDERATED DATABASE.
IC72450 3 SYSPROC.ADMIN_REMOVE_MSGS DOES NOT DELETE MESSAGE FILES(GENERATED BY ADMIN_CMD) WHOSE NAME IS APPENDED WITH UNDERSCORE(_).
IC77548 3 CONFIGURE AUTOMATIC MAINTANANCE FROM DB2CC DOESN'T WORK WHEN THERE IS NO VALID ADMIN NODE CONFUGURED FOR THE DATABASE
DRDA Services               FP4
IC69888 1 MISMATCH BETWEEN UNICODEMGR AND CCSIDMGR DRDA LEVELS
IC71392 1 CONNECTION LEVEL LOAD BALANCING OCCURS EVEN WHEN ENABLEWLB IS NOT SET
IC68053 2 STORED PROCEDURE MAY FAIL WITH SQL30073N WHEN THERE ARE 10780 PARAMETER MARKERS
IC77552 2 -30020(SYNTAX ERROR) IS RETURNED WHEN MSDTC GETS A TIMEOUT WHILESTREAMING IS IN PROGRESS
IC67965 3 WHEN TRYING TO RESOLVE INDOUBT TRANSACTIONS, ZOS CLIENT CONNECTED TO DB2 LUW SERVER GETS THE ERROR DSNL414E.
Data Management Services               FP4
IC68206 2 A SORT THAT ENCOUNTERS AN ERROR MIGHT ALSO SEGFAULT IN STMMSTOPSORTLISTMONITORONFAILURE()
IC69581 2 ALTER TABLE OPERATION MAY LEAVE THE TABLE IN ALTER PENDING STATE AND RETURN SQL0668N RC=8 EVEN IF DB2 HAS BEEN RESTARTED.
IC67634 2 DB2 CRASH WHEN CTRL+C IS PRESSED DURING MDC REFRESHING, WHEN NOTLOGGED INITIALLY IS ACTIVATED
IC69178 2 DB2 ENCOUNTERS "UNLOCKING AN UNLATCHED LOCK" ERROR AND PANICS.
Data Protection Services               FP4
IC68208 2 IN RARE TIMING SCENARIOS DB2 TERMINATE MAY SEGFAULT AFTER A RESTORE OPERATION.
IC68553 2 ROLLFORWARD COMMAND FAILED WITH SQL4970N ERROR
IC68222 2 CRASH RECOVERY FAILED WITH -1042 ERROR WHICH MARKED THE DB BAD. IT FAILED WIRH "FILE COUNT <= TAILINDEX" ERROR IN DB2DIAG.LOG.
IC68252 2 ROLLFORWARD FAILS WITH SQL1265N "NOT ASSOCIATED WITH THE CURRENTLOG SEQUENCE" AFTER DB2INIDB
IC68612 2 CONCENTRATOR CAUSES PERFORMANCE HIT FOR READ LOG AGENT DUE TO NEW LOG RETRIEVAL NECESSARY WHEN AGENT SWITCHES OUT.
IC68138 2 A DATABASE WITH CIRCULAR LOGGING CAN FAIL IN CRASH RECOVERY TRYING TO OPEN LOG FILES THAT DO NOT EXIST ON DISK
IC67452 3 SLOW PERFORMANCE FOR ROLLFORWARD AND HADR STANDBY
Development Infrastructure               FP4
IC69784 3 REMOVE DEPENDENCY ON LIBSTREAM.SO FROM LIBDB2.SO
Engine Infrastructure               FP4
IC68011 2 WHEN A SERVER INSTANCE IS ATTEMPTED TO BE STOPPED FROM A CLIENT,MESSAGE RETURNED IS INCORRECT
IC70318 2 USE TRUSTED CONTEXT CONNECT AUTHORIZATION BASE UPON CONNECTION USING SYSTEM AUTHORIZATION ID
IC67990 2 DB2 CONFIGURATION ASSISTANT CAN REPORT CCA3061N ERROR WHEN DISCOVERING REMOTE DB2 SERVERS.
IC68731 2 IF CUSTOMER USING COMBINATION OF REMOTE CONNECT (FROM DIFFERENT BOX) AND LOCAL CONNECT (FROM THE SAME BOX) AND THE DB IS CATALOG
IC68273 2 SQL0901N RETURNED WHEN ATTEMPTING TO STOP/START REMOTE INSTANCE ON WINDOWS 64-BIT (NTX64 PLATFORM)
IC68369 2 DB2START AND DB2STOP ONLY HANDLES 200 NODES AT A TIME, STOPPING DB2 IS SLOW
IC75131 2 DB2 V9.5, V9.7 MAY GET SIGSEV WHEN HITTING TIMING HOLE BETWEEN CONCURRENT CONNECTION REQUESTS
IC68510 3 ACTIVATE DB DURING OFFLINE BACKUP SHOULD FAIL
IC75132 3 DB2SYSC AND OTHER PROCESSES REMAIN AFTER THE DB2WDOG PROCESS TERMINATES OR IS KILLED.
Engine Monitor               FP4
IC68439 3 USER INTERRUPT MAY BE DETECTED BY EVENT MONITOR IN DB2DIAG.LOG WHEN THE LAST CONNECTION IS TERMINATED.
Engine Utilities               FP4
IC67761 2 INFOSPHERE WAREHOUSE PRODUCTS HAVE MISSING NON-RELATIONAL WRAPPER FUNCTION
IC68116 2 THE ESTIMATED SIZE OF TABLESPACE LEVEL BACKUP IS CALCULATED FOR THE ENTIRE DATABASE INSTEAD OF THE GIVEN TABLESPACES
IC70665 2 LOAD SHOULD NOT TRY TO OPEN HISTORY FILE IF IF WE ARE FILTERING OUT (NOT WRITING TO HISTORY FILE) LOAD RECORDS.
IC69134 2 BACKUP OF A TABLE IN LOAD_PENDING STATE IN SMS TABLESPACE MAY FAIL WITH BADPAGE ERROR AND SQL1655E.
IC69548 2 DB2PD -DBCFG AND GET DB CFG SHOW DETAIL WILL ALWAYS DISPLAY 0 ASCURRENT VALUE FOR LOGSECOND, WHEN IT SHOULD BE -1
IC77555 2 DEFERRED ASLHEAPSZ VALUE IS USED BY PROCESSES SPAWNED OUTSIDE OFTHE DB2SYSC PROCESS.
IC68213 2 DURING OFFLINE BACKUP MULTIPLE SESSIONS ARE REOPENED TO BACKUP THE LFH FILE. THEY ARE UNUSED SESSIONS AND SHOULD NOT BE OPENED.
IC68488 2 SLOW DB2START IN MICROSOFT CLUSTER (MSCS) ENVIRONMENT
IC66430 2 IN DPF ENVIRONMENT, THE FINAL SQLCA RETURNED BY LOAD IS NOT PRINTED INTO THE MESSAGES FILE.
IC68414 2 "RECOVER DB" COMMAND IS NOT PICKING UP CORRECT DB2 BACKUP IMAGE FOR RECOVERY TILL POINT IN TIME.
IC68725 2 A LOAD WITH CLIENT KEYWORD THAT IS INTERRUPTED MAY TRAP IF CONNECT-RESET IS INVOKED AFTERWARD.
IC69627 3 IMPROVE SQL5153N MESSAGE BY SHOWING WHAT THE <CONDITION> IS UNDER WHEN A RESTORE FAILS DUE TO THIS MESSAGE.
IC77544 3 INSTANCE DEFUNCT PROCESSES CREATED UPON LOADS
IC68142 3 "SET AUTOMATICALLY BY DB2" OPTION NOT AVAILABLE
Federation               FP4
IC69112 2 VARCHAR CAST FUNCITONS IN VARCHAR2 COMPATIBILITY MODE NOT PUSHEDDOWN TO ORACLE DATA SOURCE
IC68158 2 WHEN QUERYING REMOTE TABLE, MS SQL SERVER WRAPPER MAY REPORT SQL1822N ERROR WITH ERROR MESSAGE "INVALID CURSOR STATE".
IC69202 3 CREATE TABLE FAILED AND RETURN ERROR CODE -487 WHEN USER MAPPINGDEFINED WITH ACCOUNTING OPTION.
IC68426 3 INFORMIX WRAPPER RETURNS SQL1822N ERROR WHEN USING RTRIM FUNCTION
IC66953 3 SERVER OPTION DB2_SELECT_SCALAR_SQ COULD CAUSE NICKNAME QUERY WITH A SUBQUERY NOT TO BE PUSHED DOWN TO MVS SERVER
IC67930 3 ILLEGAL CHARACTERS IN SUBSTR OR LIKE PREDICATES GENERATED FOR INFORMIX DATA SOURCE IN NON-UNICODE ENVIRONMENT CAUSING SQL1822N
IC67877 3 SYBASE WRAPPER DOES NOT SUPPORT SYBASE 15 DATASOURCE SYSTEM DEFINED DATATYPE 'LONGSYSNAME'
IC67872 3 MAY GET SQL1822N ERROR WHEN EXECUTED NESTED SELECT QUERY
IC67968 3 SQL0104N ERROR OCCURS WHEN PERFORMING FULL JOIN AGAINST VM
IC67878 3 IT THROWS "ERROR SERVER VERSION" WHEN CREATE SERVER TYPE FOR AS400 V6R1.
High Availability               FP4
IC68900 1 HADR STANDBY MAY PANIC WITH SQLP_BADLOG ERROR 'TAILPAGE 0 DOES NOT PAGELSN XXXXXXXXXXXX AND FIRSTLSN XXXXXXXXXXXX'
IC77547 2 REBOOT HADR STANDBY DATABASE ALSO REBOOT PRIMARY DATABASE
IC68048 2 DB2STOP TAKES A LONG TIME ON HADR SYSTEM IF STANDBY IS OFFLINE AND DATABASE NOT ACTIVATED
IC69641 2 A CLEAN HADR TAKEOVER PROCESS (WHILE THE DATABASES ARE IN PEER STATE) CAN BE SLOW IF THE HISTORY FILE IS VERY LARGE.
IC70050 2 LOG RENAME ARRAY GETS FULL IN HADR ENVIRONMENT
IC68884 2 IN HA ENVIRONMENT, FILESYSTEMS FAIL TO MOUNT DUE TO A CONFLICT BETWEEN THE MOUNTV98_MONITOR.KSH AND MOUNTV98_START.KSH SCRIPTS
IC68378 2 HADR PRIMARY REINTEGRATION SEEMS TO SUCCEED BUT THEN OLD PRIMARYFAILS WITH ERROR "PRIMARY/STANDBY MISMATCH"
IC77539 3 SECURITY: INCORRECT FILE PERMISSION AND AUTHORIZATION FOR HA SCRIPTSWHEN INSTALLED VIA V9.5.
IC67725 3 HA_ZRC_RESOURCE_NOT_FOUND ERRORS FOR NON-HA HADR DATABASES
IC67828 3 WHEN HADR PRIMARY IS IN 'WRITE SUSPEND' STATE, ISSUING AN HADR TAKEOVER WILL MAKE BOTH PRIMARY AND STANDBY INACCESSIBLE.
IC77557 3 DAS INSTANCE IS NOT AUTO STARTING AFTER REBOOT DESPITE CORRECT DASAUTO SETTINGS ARE IN PLACE.
Index Manager               FP4
IC69812 1 POTENTIAL CORRUPTION WHEN REPLAYING LOG RECORDS THAT INSERT KEYSINTO AN INDEX AND TRIGGER PAGE SPLITS
IC69801 2 REPLAY OF CERTAIN INTERNAL INDEX OPERATIONS DURING ROLLFORWARD OR CRASH RECOVERY MAY FAIL WITH ERROR DIA8575C
IC76856 2 DB2STOP FORCE HANGS
IC77559 2 INSERT OR UPDATE WITH INDEX COMPRESSION MAY CAUSE MEMORY CORRUPTION AND CRASH
Install               FP4
IC76723 1 PURESCALE INSTALLER ON AIX DOES NOT SET UP RESERVE_POLICY OR ALGORITHM OF TIE-BREAKER DISK FOR REMOTE HOSTS.
IC68607 2 AFTER INSTALLING A FIXPACK AS NON-ROOT ALL FILES UNDER ~/SQLLIB/ADM HAVE WRONG PERMISSIONS
IC70119 2 INSTALLFIXPACK FAILS TO APPLY ON TOP OF CLIENT INSTALL CONTAININGA CLIENT INSTANCE
IC68937 2 IN 64BIT DB2 INSTALL OF V97GA ONX64 WIN2008/VISTA, NO DB2 REGISTRY KEYS WERE CREATED UNDER 64BIT HIVE.
IC76506 2 ENSURE DB2IUPDT RUNS FIXTOPOLOGY WHENEVER 'DB2START ADD MEMBER' RETURNS A NON-SUCCESS RETURN CODE.
IC69316 3 THE MESSAGEBOX DISPLAYED DURING DB2 INSTALL IS NOT IN CORRECT FORMAT WHEN IT IS INSTALLED IN ARABIC LANGUAGE
IC66620 3 DB2 INSTALLATION COPIES DB2JCC_LICENSE_CUSIZ.JAR AS DB2JCC_LICENSE_CU.JAR OVERWRITING EXISTING DB2JCC_LICENSE_CU.JAR
IC68832 3 ONLY THE BUILD-IN SYSTEM ACCOUNT HAS THE AUTHORITIIES TO ACCESS AND GRANT ACCESS TO THE DATABASES CREATED IN A SILENT INSTALL
IC69898 3 DB2IPRUNE.EXE DOES NOT WORK CORRECTLY WHEN IT IS USED TO PRUNE THE MERGED DB2 INSTALL IMAGES: SERVER, UNIVERSAL
IC69778 3 DB2VAL.EXE ALWAYS REPORTS ERROR WHEN IT IS USED TO VALIDATE A V97 FIXPAK UPGRADE INSTALL ON WINDOWS
IC68141 3 INCORRECT CODE RETURNED DURING SILENT INSTALLATION
Interpartition Communication               FP4
IC68775 2 FCM SENDER IS NOT SELECTING DESIGNATED NETWORK INTERFACE TO SENDDATA
IC68270 2 CONTROL DYNAMIC DOWNWARD ADJUSTMENT OF FCM RESOURCES
IC68726 2 WHEN NO MORE FCM BUFFER AVAILABLE, IT MAY CAUSE DB2 OPERATIONS (E.G. SNAPSHOT MONITORING) TO HANG.
Monitoring               FP4
IC70421 2 DB2 CAN TRAP IN SQLRWWLOMETRICSBUILDER::EXECUTE WHEN RUNNING MON_GET_UNIT_OF_WORK TABLE FUNCTION.
IC71440 2 DB2 LIST DCS APPLICATIONS MAY CAUSE DB2 TO TRAP
IC69789 2 MEMORY LEAK IN APPLICATION HEAP FOR DB2LUSED
IC67724 2 POSSIBLE HANG DUE TO INFINITE LOOP IN SQLMON_CONN::LOOKUP_STMT()
IC69807 2 DB2 MAY TRAP WITH SIGNAL #11 AT FUNCTION STRCMP ON HPUX PLATFORM DURING SNAPSHOT PROCESSING
IC76441 2 AN ENTRY IS ADDED TO STATEMENT LIST PRIOR TO RESOLVING PACKAGE PATH RESULTING INTO A LARGE MONITOR STATEMENT LIST.
IC69631 2 MON_CURRENT_SQL CAN RETURN INCORRECT METRICS WHEN MULTIPLE STATEMENTS OPEN CONCURRENTLY.
IC77521 2 DB2ACD (HEALTH MONITOR PROCESS) MAY MEMORY LEAK MSGALERTACTION OBJECTS IF AN ACTION SCRIPT XML CONFIGURATION IS USED
IC69495 2 SECURITY: MONITOR ADMINISTRATIVE VIEWS IN SYSIBMADM SCHEMA ARE VIEWABLE BY PUBLIC.
IC68721 2 DEADLOCK EVENT MONITOR MAY GET STUCK IN "PENDING REMOTE" STATUS IF GLOBAL EVENT MONITOR RUNS OUT OF DATABASE MONITOR HEAP.
IC69173 2 LOCK_WAIT_TIME REPORTED BY MONITOR TABLE FUNCTIONS WILL NOT UPDATE WHILE A LOCK IS HELD IF A LOCK TIMEOUT IS BEING USED.
IC68429 2 SIGNAL #11 CRASH OR HIGH CPU USAGE WHEN IPV6 CLIENT CONNECTED.
IC69632 3 WRONG VALUES DISPLAYED FOR STMT_TYPE_ID IN MON_GET_PKG_CACHE_STMT
IC68349 3 DB2EVMON SQLCA OUTPUT HAS CHANGED COMPARED TO DB2 V9.1 AND CANNOT BE PARSED EASILY
IC69655 3 CLEANUP CODE TRIGGERED BY OUT OF MEMORY CONDITIONS IN DB2 MONITORING AREA CAN CRASH THE INSTANCE.
IC68326 3 UPDATE HEALTH NOTIFICATION CONTACT LIST COMMAND IS NOT WORKING ON NTX64 PLATFORM FOR ALL RELEASES
Problem Determination               FP4
IC68786 2 INSTANCE MAY GO DOWN WHEN DISK FULL OR OTHER CRITICAL ERROR APPEARS.
IC67424 2 DB2DART FAILS TO IDENTIFY INITIALIZED BUT UNUSED EXTENT MAP PAGES THAT ARE CORRUPT
IC69218 2 DB2DART AND INSPECT FAIL ON VERY OLD PAGE HEADERS FROM PREVIOUS DB2 RELEASES IN DB2 V9.7
IC68066 3 REMOVE THE RESTRICTION FOR /DHWM ON TABLESPACE 0
IC67788 4 INTERACTIVE DB2TOP HADR SCREEN DOES NOT DISPLAY MILLISECONDS (MS) AFTER THE VALUE FOR LOG WTIME
Quality Assurance               FP4
IC68118 3 UPDATE DB CFG PARAMETERS MORE THAN 64 AT A TIME, MAY RESULT IN UNEXPECTED BEHAVIOUR.
IC74776 3 SQL5160N MAY OCCUR WHEN UPDATING MIRRORLOGPATH ON PURESCALE
IC75328 2 INFINIBAND ADAPTER HAD HARDWARE MALFUNCTION WHILE DB2 INTANCE IS STOPPED, SUBSEQUENT DB2START WILL ENCOUNTER SQL1517N
Query Compiler, Rewrite, Optimizer               FP4
IC68419 1 POSSIBLE WRONG RESULTS: COALESCE ON FULL OUTER JOIN OF 2 SUBSELECTS THAT OUTPUT >= 1 NOT-NULL COLUMNS AND A LITERAL OR GROUP BY
IC67765 1 QUERY WITH RANGE PARTITIONED TABLE CAN FAIL WITH SQL0901 "BAD PLAN; UNRESOLVED QNC FOUND" IF PREDICATES ELIMINATE ALL PARTITIONS
IC68732 1 INSTANCE CRASHES WHEN QUERY COMPUTES NULLIF EXPRESSION
IC71333 1 EXECUTING A QUERY WITH LEFT OUTER JOIN AND AN IS NULL PREDICATE MAY CAUSE A REVERSE COLUMN OUTPUT OR PRODUCE A SQL0901N ERROR
IC74790 1 DB2 MAY RETURN INCORRECT RESULTS WITH CORRELATED PREDICATE AND OLAP FUNCTIONS IN DPF MODE
IC71254 1 POSSIBLE INCORRECT RESULT ON RECURSIVE VIEWS JOIN TO A TABLE ON UNIQUE COLUMN
IC71669 1 CREATE OR REPLACE ALIAS MAKES SYSTEM CATALOG TABLES INCONSISTENTWHEN ACTING ON TABLE OR VIEW
IC68256 1 LONG COMPILE TIME DUE FOR QUERIES INVOLVING NULL_EQUAL_NULL JOINPREDICATES.
IC73582 2 NESTED-LOOP JOIN WITH EARLYOUT FOR GROUPBY CLAUSES YIELDS INCORRECT RESULTS WHEN JOIN COLUMNS ARE OF DIFFERENT DATA TYPES
IC67911 2 CREATE SECURITY LABEL COMMAND ALLOWS IMPROPER SYNTAX
IC66819 2 DISTINCT QUERY CAN RETURN INCORRECT RESULTS WHEN IT IS ROUTED TO AN MQT
IC70047 2 -901 ERROR IS RETURNED WHILE CREATING EVENT MONITOR ERROR MESSAGE: THIS IS NOT A CONSTANT QNC
IC72816 2 TO_DATE SCALAR FUNCTION IN IF STATEMENT FAILS WITH SQL20448N
IC77508 2 ENABLING REGISTRY VARIABLE DB2_EXTENDED_OPTIMIZATION=IXOR UNDER THE DB2_WORKLOAD=SAP AGGREGATED REGISTRY VARIABLE.
IC68261 2 POSSIBLE INCORRECT RESULTS OPTIMIZING A <COLUMN> = ? PREDICATE ON A UNION ALL VIEW USED AS A COMMON SUB-EXPRESSION
IC69834 2 PREDICATES WITH COMPARISON EXPRESSION NOT PUSHED DOWN TO DB2 DATA SOURCES WHEN IFS IS IN DATA COMPATABILITY MODE.
IC68278 2 SQL0901N MAY BE ISSUED IN A DPF ENABLED DATABASE COMPILING A QUERY CONTAINING AN IN LIST AND A CORRELATED SUBQUERY PREDICATE
IC67789 2 INSERT INTO A VIEW THAT IS BASED ON A VIEW WITH INSTEAD-OF TRIGGER MAY RETURN SQL0901N.
IC68772 2 CONCAT OR "||" NOT PUSHED DOWN TO ORACLE DATA SOURCE
IC68630 2 OPTIMIZE UNION ALL JOIN PUSHDOWN AND BRANCH ELIMINATION
IC69071 2 AUTOMATIC SETTING FOR STATEMENT HEAP MAY RESULT IN INCONSISTENT PERFORMANCE DUE TO EARLY FALLBACK TO GREEDY JOIN OPTIMIZATION
IC68993 2 PERFORMANCE ISSUE WHEN CAST AROUND LITERAL FOR BIT DATA IS PRESENT
IC69861 2 A TWO-WAY JOIN QUERY WITH OR JOIN PREDICATE MAY BE REWRITTEN TO UNION
IC68287 2 DB2 MAY ISSUE SQL0901N EXECUTING A QUERY WITH CORRELATED REFERENCES TO A TABLE FROM AN OUTER JOIN
IC68492 2 SQL0901N WHEN INNER JOIN IS USED IN AN UPDATE OR SELECT QUERY
IC69825 2 EXECUTION OF SQL STATEMENT WITH DBPARTITIONNUM IS NOT PARALLELIZED FOR CERTAIN SCENARIOS IN DPF
IC70344 2 DB2 QUERY REWRITE MAY NOT COMPLETELY OPTIMIZE A QUERY CONTAININGNODENUMBER LOCAL PREDICATE
IC69331 2 DB2 INSTANCE MAY ABEND DUE TO STACK OVERFLOW (INSTEAD OF DUMPINGSQL0973N) WHILE PROCESSING A VERY LARGE PREDICATE
IC68001 2 UPDATE OF A GENERATED IDENTITY COLUMN OF A UNION ALL VIEW OF 3 OR MORE TABLES MAY FAIL WITH SQL0407N
IC66876 2 STATEMENT COMPILATION MIGHT RETURN -101 FOR QUERY WITH CARTESIANPRODUCTS WHEN STMTHEAP IS AUTOMATIC.
IC77537 2 IMPROVE THE HANDLING OF CONVERSION TO NLJOIN FROM MULTIPLE IN PREDICATES
IC69478 2 RUNNING RUNSTATS IMMEDIATELY AFTER CONNECTING TO A DATABASE MIGHT LEAD TO SEGMENTATION FAULTS.
IC68346 2 SQL407N RETURNED WHEN INSERTING INTO OR UPDATING TABLE WITH GENERATED BY DEFAULT ROW CHANGE TIMESTAMP COLUMN AND BEFORE TRIGGER
IC69872 2 AN OR PREDICATE CONTAINING INLIST SUBTERM MAY BE REWRITTEN TO UNION
IC77526 2 SQL0901N MAY BE RETURNED FROM RUNNING A QUERY (THIS->OPRPRD.OP()!= NULLP).
IC67537 2 IMPROVEMENT ON PROCESSING FETCH FIRST N ROWS IN DPF ENVIRONMENT
IC68766 2 ERROR SQL0440N IS RETURNED WHILE COMPILING QUERY THAT HAS AN OR PREDICATE ON USER DEFINED TYPE COLUMN
IC67776 2 TOO MANY OR PREDICATES MAY LEAD TO STACK EXHAUSTION AND CRASH WHEN COMPILING THE QUERY
IC70090 2 INCORRECTLY BLANK PADDED OR CASE INSENSITIVE RESULTS ARE RETURNEDWHEN COMPARING COLUMNS OF CERTAIN DATATYPES
IC68451 2 DB2_ANTIJOIN, DB2 SHOULD CONVERT ELIGIBLE OUTER JOIN TO ANTIJOIN
IC69696 2 INACCURATE NLEAF STATISTIC FOR PARTITIONED INDEXES OF A PARTITIONED TABLE MAY LEAD TO NON-OPTIMAL ACCESS PLANS.
IC75609 2 RECEIVING SQL0104N ERROR FROM DATA SOURCE WHEN EXECUTING JOINS IN FROM TABLE-LIST ON FEDERATION SERVER
IC68503 2 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN CERTAIN KEYWORDS ARE USED IN THE TARGET COLUMN LIST OF AN INSERT STATEMENT
IC69032 2 STATISTICAL AND REGRESSION AGGREGATE FUNCTIONS SHOULD RETURN DECFLOAT IN NUMBER COMPATIBILITY MODE
IC69847 2 POSSIBLE SUB-OPTIMAL QUERY PERFORMANCE WITH DB2_WORKLOAD SET TO SAP AND CATALOG TABLE STRING COLUMN(S) USED IN COMPARISON(S)
IC77524 3 INCORRECT RESULTS MAY BE RETURNED ON DPF WHEN QUERY CONTAINS NODENUMBER SCALAR ON EACH JOINED TABLE.
IC68774 3 TRAP IN SQLNQ_VIEWSEL_OFN_SM() WHEN CREATING A VIEW WITH USING A QUERY WITH CONNECT BY BASED ON ANOTHER VIEW
IC68477 3 THE DB2 OPTIMIZER MAY MIS-ESTIMATE THE JOIN CARDINALITY OF AN IN-TO-JOIN TRANSFORMATION IN A DPF ENVIRONMENT
IC68061 3 INCORRECT CARIDNALITY ESTIMATE WHEN MORE THAN ONE EQUALITY LOCAL PREDICATES ON A TABLE THAT ARE FULLY QUALIFIED IN UNIQUE INDEX
IC68559 3 AUTOMATICALLY REWRITE OR PREDICATE IN SELECT DISTINCT QUERY INTOUNION OPERATOR
IC69679 3 THE DB2 QUERY OPTIMIZER MAY OVERESTIMATE THE COST OF A PARTITIONED INDEX ACCESS WHICH MAY RESULT IN A LESS-THAN-OPTIMAL QUERY AC
IC67520 3 DB2EXFMT OR ACCESS PLAN GRAPH FROM OPTIM QUERY TUNER MIGHT FAIL WITH SQLCODE -551.
IC68455 3 THE SQL QUERY OPTIMIZER MAY ADD AN UNNECESSARY TABLE QUEUE OPERATION UNDER CERTAIN CONDITIONS
IC66191 3 SQL0901N RETURNED WHEN >=4 QUERY ORDER BY COLUMNS ARE EQUIVALENTTO CONSTANTS
IC70337 3 INSTANCE ABEND DUE TO STACK OVERFLOW WITH FUNCTION NOTPD_TRAVERSE__9SQLNQ_PIDFP9SQLNQ_OPRI
Relational Data Services               FP4
IC69695 1 CRASHED INVOLVING NESTED FUNCTION CALLS AND PL/SQL CODE IN SQLRIINVOKERTRUSTED
IC69289 1 HANG IN SMP WHEN PERFORMING HASH JOIN. QUERY CAN NOT BE FORCED OFF.
IC68660 1 THE WRONG DECIMAL FIELD MAY BE GET INSERTED INTO A DATABASE FROMAN APPLICATION WHEN USING A LINUX 32-BIT CLIENT.
IC68983 1 -901 SQLCODE DURING DGTT CREATION IN DPF AFTER A NODEFAILURE
IC68219 2 TO AVOID ERROR SQL0551, PACKAGES SHOULD GET AUTOMATICALLY BOUND EVEN IF THE USER HAS NO BIND AUTHORITY
IC68801 2 INDEX EXTENSION IN SQL GENERATES SQL0901N.
IC68033 2 FAILURE DURING A FETCH FROM A CURSOR MAY CAUSE AN INSTANCE CRASHWITH SIGNAL SEGV IN DPF ENVIRONMENT
IC68702 2 CALLING STORED PROCEDURE WITH ARRAY OUTPUT PARAMEMETERS CAN RESULT IN SERVER CRASH
IC69650 2 -901 SQLCODE DURING A FAILED REBIND IN DPF
IC68527 2 MANY DECLARES AND DROPS (OR DECLARE...WITH REPLACE) OF GLOBAL TEMPORARY TABLES IN SAME TRANSACTION INCREASES APPLHEAP USAGE
IC69731 2 DB2LOOK OR DROP MQT CAN RETURN AN SQL0901N ERROR OR TRAP IF THE DDL TEXT IN SYSCAT.VIEWS DOES NOT BEGIN WITH 'CREATE' OR 'ALTER'
IC69720 2 INCORRECT ROWCOUNT IN SQLERRD[2] (OR FROM GET DIAGNOSTICS) WHEN A GLOBAL VARIABLE IS INSTANTIATED
IC69386 2 BIND FROM DB2SQLJCUSTOMIZE OR DB2SQLJBIND CAN CREATE PACKAGE DESPITE FAILURE
IC69647 2 INSENSITIVE CURSOR DOES NOT RETURN ITS RESULT SET AFTER A TRUNCATE TABLE
IC69283 2 DB2UPDV97 TO REPAIR UTL_SMTP.OPEN_CONNECTION PROCEDURE FOR EXISTING DATABASES
IC68328 2 SELECT AGAINST A TABLE CAN RESULT IN INSTANCE SHUTDOWN/ABEND WITH SQLRIMOVEDATAPTR AT THE TOP OF CORRESPONDING THE TRAP FILE
IC67732 2 SQL0802 - FMOD() RETURNS NAN ON WINDOWS PLATFORM
IC68972 2 SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN INTRA_PARALLEL IS SET TO YES
IC69142 2 SQLEXECUTE IN CLI RETURNS SQL401N FOR COMPARISON OPERATORS WHEN USING DEFERRED PREPARE AGAINST A NON-UNICODE TARGET DATABASE
IC69444 2 STATIC SQL FAILS WITH -901 (REASON: CACHED_SECTPTR IS NULL) AFTERPACKAGE CACHE IS FULL.
IC69280 2 MEMORY LEAK IS POSSIBLE IF CULTURALLY CORRECT DATABASE IS USED AND QUERY HAS LIKE PREDICATE
IC68468 2 SYSIBM.INSERT AND SYSIBM.OVERLAY SCALAR FUNCTIONS RETURN SQL0138N, IF LENGTH>LENGTH(SOURCE-STRING)-START+1.
IC69543 2 QUERIES ON VIEWS RETURN SQL0204N ON UPGRADED DATABASE IF BASE VIEWS CALL COALESCE OR VALUES FUNCTION
IC68120 2 CRASH FOR QUERY THAT CONTAINS LIKE IN A MIXED/EUC CODEPAGE DATABASE.
IC67426 2 DB2 ABENDS USING SCALAR AGGREGATION FUNCTION WITH CONNECTION CONCENTRATOR ENABLED
IC69680 2 PERFORMANCE DEGRADATION AFTER THE UPGRADE TO DB2 V97 FROM EARLIER DB2 VERSIONS WHEN STMT_CONC IS ON.
IC70184 2 CALL OF A PROCEDURE OR REFERENCE TO A FUNCTION DEFINED WITHIN A MODULE WILL CAUSE A RECOMPILE RATHER THAN A PACKAGE CACHE HIT.
IC69743 2 SQL0950N WHEN THE SQL QUERY BEING ISSUED CONTAINS REFERENCE TO ASQL BODIED PROCEDURE, FUNCTION OR METHOD.
IC69854 2 INCORRECT OUTPUT FOR DB2CAT -P SYSPLAN WHEN DB2_COMPATIBILITY_VECTOR = ORA
IC68332 3 OPTIMIZATION PROFILES WITH SCHEMA NAMES CONTAINING # CHARACTERS WILL REPORT EXP0037W IN THE EXPLAIN EXTENDED DIAGNOSTIC SECTION
IC69504 3 CHANGES MAY NOT BE EFFECTIVE WHEN ALTERING TABLE ATTRIBUTE AND COLUMN INLINE LENGTH IN A SINGLE ALTER TABLE STATEMENT
IC69390 3 ALGORITHM OF LATCH WAITING ON SQLO_LT_SQLRA_ANCHOR_STMT__INVALID_VAR_LATCH SHOULD BE CHANGED TO CONDITIONAL FROM UNCONDITIONAL.
IC68471 3 WHEN TRUNCATION HAPPENS IN STORED PROCEDURE, SQLCODE AND MESSAGE TOKEN FOR TRUNCATION WARNING ARE NOT SET
IC68331 3 INFINITE LOOP IN WLM_SET_CLIENT_INFO IF DATABASE CODEPAGE AND APPLICATION CODEPAGE IS NOT SAME.
IC69454 3 UPPER FUNCTION RETURNS SQL0171N WHEN RECORD LENGTH OF THE RECORDIS GREATER THAN THE PREVIOUS INSERTED RECORD
Replication               FP4
IC77560 1 REPLICATION ENGINE FIXES FOR DB2 LUW V97 FP3A
IC67091 2 REPL ENGINE APAR FOR V95FP6
IC71226 2 REPLICATION ADMIN FIXES FOR DB2 LUW V97 FP3A
IC69217 3 ENGINE FIXES FOR V97FP3
Security               FP4
IC77509 2 SUPPORT THE COMBINATION OF SERVER ON CLIENT AND SERVER_ENCRYPT ON GATEWAY.
IC76902 2 SECURITY: REMOTE DENIAL OF SERVICE OF DB2 SERVER.
Self Tuning Memory Manager               FP4
IC68481 2 STMM CALCULATES INCORRECT DATABASE MEMORY TARGETS WHEN UNCOMMITED MEMORY IS HIGH AND EXCEEDS AVAILABLE SYSTEM MEMORY
IC68243 3 MESSAGE : UNABLE TO FIND DONOR TO SATISFY MINSIZE CONSTRAINT SHOULD BE INFO ONLY AND/OR MOVED TO STMM LOG
Spatial Extender               FP4
IC69127 3 SHAPEFILE IMPORT AFTER SHAPEFILE EXPORT OF TIME AND TIMESTAMP VALUES FAILS
IC69198 1 SYSPROC.ADMIN_MOVE_TABLE CRASHES
IC68300 2 ISSUE WITH VISUAL STUDIO 2005 AND 2008 WHEN USING THE DB2 ODBC OR JDBC TYPE 2 DRIVER CLI LAYER.
IC69019 3 OTM FAILED WITH SQL2032N DUE TO LEADING WHITE SPACES IN THE 'LOAD_MSGPATH' OPTION
IC77546 3 THE ADMINISTRATIVE PROCEDURE REORGCHK_TB_STATS MIGHT RETURN WRONG TABLE SIZE AND F2 VALUES FOR PARTITIONS IN A PARTITIONED TABLE
Text Search               FP4
IC67991 2 LARGE QUERY STRING THROWS CTE0157 SYNTAX ERROR.
XML Data Services               FP4
IC70186 1 DB2 INSTANCE CRASHED IN DPF WHEN APPLICATION USES XML HOST VARIABLES
IC70689 2 PSM XML QUERIES IN DPF ENCOUNTER A SQL0901N (REASON "EXPECTED TEMP TCB".)
IC69725 3 EVMON_FORMAT_UE_TO_TABLES() RECEIVING "SQL0818N A TIMESTAMP CONFLICT OCCURRED."

DB2 Version 9.8 Fix Pack 3
APAR Sev. Abstract
Administration Tools               FP3
IC66954 2 DB2LOOK GENERATE INCORRECT VIEW/PROCEDURE/FUNCTION/TRIGGER ... DDL IF COMMENT CONTAINING A 'REPLACE' KEYWORD HAS BEEN ADDED AS P
IC66486 2 DB2LOOK SUPPORT TO GENERATE OBFUSCATED VERSIONS OF DDL STATEMENTS FOR ROUTINES, PROCEDURES, TRIGGERS AND VIEWS
IC66592 2 SYSPROC.AUTOMAINT_SET_POLICY DOES NOT ALLOW TO SET DAYSOFMONTH INCLUDE 8 OR 18
IC66651 2 DB2LOOK CORE DUMPS WHILE GENERATING ALTER STATEMENTS TO ADD FOREIGN KEY
IZ68271 2 DB2LOOK CORE DUMPS WHEN TRYING TO GENERATE DDL FOR OBJECTS WHICHHAVE MORE THAN 90 PARAMETERS
IC66849 3 DB2 DESIGN ADVISOR (DB2ADVIS) MAY NOT RECOMMEND INDEX CANDIDATESCONSISTENTLY FOR THE SAME WORKLOAD ON WINDOWS PLATFORMS
IC68087 3 DB2LOOK IS NOT INSERTING THE COMMENTS FOR TABLE AND COLUMNS INTOSYSTOOLS.DB2LOOK_INFO TABLE FOR SYSPROC.ALTOBJ() TO REFER.
IC67125 3 RUNNING DB2MOVE TOOL WITH -TS OPTION AND ACTIONS OTHER THAN EXPORT, MAY LEAD TO PROGRAM ABEND OR OTHER INCORRECT BEHAVIOUR
IC66309 3 DB2LOOK FAILS TO INSERT A COMMA INCASE THERE IS NO CONSECUTIVE ELEMENT CREATED FOR COMPONENTS LISTED.
IC66628 3 V97FP1/FP2: DB2LOOK -WLM MISSES PRODUCING FORCE APPLICATION CLAUSE FOR CREATE THRESHOLD UOWTOTALTIME
Buffer Pool Services               FP3
IC66809 1 IN DB2 V9.7 FP1 ONLINE BACKUP MAY FAIL WITH SQL2048 RC = 5, ERRORRAISED IN SQLUBRESIZEBUFSPACE PROBE 472 OR IT MAY HANG.
IC67696 1 ONLINE BACKUP PERFORMANCE SLOW AT V9.1FP7 IF TABLESPACES HAVE MANY CONTAINERS
IC66974 2 DB2 PAGE CLEANER HANGS MAY LEAD TO DATABASE HANGING
IC67123 2 BAD ARGUMENT -443 IN UTL_TCP.IMP_READ_LINE() FROM CALL TO UTL_SMTP.OPEN_CONNECTION
IC66682 2 DBMS_UTILITY.GET_DEPENDENCY RETURNS WRONG RESULTS IF A FUNCTION WAS CREATED WITHOUT SPECIFIC NAME SET TO THE FUNCTION NAME
Client Interfaces               FP3
IC66593 1 NEED SQLRELOADCONFIGW NEED TO RETURN IN UNICODE FORMAT
IC66448 2 [WINDOWS, THINCLIENT] TEST CONNECTION TO DATABASE FAILS FROM ODBCAD32.EXE WHEN PARAMETERS ARE SPECIFIED IN DB2DSDRIVER.CFG
IC66589 2 WHEN EXPLAIN MODE IS SET AND SERVEROUTPUT ON,ALL COMMANDS INCLUDING SET CURRENT EXPLAIN MODE USING CLP RESULTS IN ENDLESS LOOP
IC71217 2 THE REORGCHK COMMAND MIGHT STOP RESPONDING (HANG), IF THE COMMAND RECEIVES SQL ERROR.
IC67433 2 "[IBM] CLI0196E SWITCH USER OPERATION INVALID AT THIS TIME. SQLSTATE=HY011" CAN OCCUR WHEN OPENING A TRUSTED CONTEXT CONNECTION
IC67539 2 X LOCKS LEFT ON CATALOG CACHE AFTER EXECUTION OF REORGCHK COMMAND
IC69210 2 SQL30082N ERROR WITH RC=3 ("PASSWORD MISSING") OCCURS WHEN ONE ATTEMPTS TO UPDATE A REMOTE DATABASE'S DB CFG PARAMETER
IC67541 2 DB2CMD PERFORMANCE ISSUE
IC66444 2 REORGCHK COMMAND HANGS
IC66663 2 INSERTING A ROW ON DB2 FOR Z/OS WITH ENTITY FRAMEWORK FAILS WITHERROR SQL0199N
IC67352 2 MEMORY LEAK IN DB2 WHEN CALLING UNFENCED CLI ROUTINES
IC71211 2 DESCRIBE INDEXES DO NOT DISPLAY ANY CLUSTER INDEXES IN DB2 V9.7.0.0.
IC66408 2 APPLICATION CRASH IN DB2APP.DLL IF TIMEOUT HAPPENS IN A MULTI-THREAD APPLICATION
IC67124 3 "DB2TRC ON" COMMAND DOESN'T WORK WITH "-CLI" OPTION.
IC66631 3 SYNTAX ERROR FROM IFXBULKCOPY.WRITETOSERVER WHEN THE TARGET TABLE CONTAINS A SERIAL TYPE
IC66438 3 IFXBULKCOPY RETURNS "CLI0112E ERROR IN ASSIGNMENT" FOR COLUMNS DEFINED AS FIXED POINT DECIMAL(P,S)
IC66496 3 SAP:RELOAD OF DB2DSDRIVER.CFG DOES NOT LIKE LOWER CASE <ACR>
IC67005 3 WORKING CLI/ODBC APPLICATIONS WILL EXIT ABNORMALLY WHEN DB2TRC IS ON
IC66840 3 SETTING NEW TRANSACTION GIVE ERROR IN BUSY FETCHING
Common Code Infrastructure               FP3
IC66519 1 IN PROCESS OF LOADING A LIBRARY FOR THE TRUSTED ROUTINE DB2 IS LEAKING A FILE DESCRIPTOR
IC67972 2 DB2PREREQCHECK FAILS WITH SEGMENTATION FAULT IN LINUX
IC66835 2 CAN'T START TDS SERVICE VIA WINDOWS SERVICES
IC66406 2 DB2FMCD COMMAND DOES NOT WORK IF BLANK LINES ARE APPENDED AFTER FMC ENTRY IN /ETC/INITTAB FILE.
IC66403 2 ADDING AN INVALID MSCS DB2 RESOURCE CAUSES THE CLUSTER ADMINISTRATOR TO FAILS.
IC67250 2 SYSIBMADM.ENV_SYS_RESOURCES - MEMORY_SWAP_FREE IS GREATER THAN MEMORY_SWAP_TOTAL (KMA)
IC66394 2 DB2 FAILS TO ALLOCATE MEMORY WHEN DB2_LARGE_PAGE_MEM=* CONFIG PARAMETER IS SET ON WINDOWS SERVER.
IC67903 2 ERROR MESSAGE FROM ACCEPTSECURITYCONTEXT MAY BE WRITTEN IN DB2DIAG.LOG, EVEN THOUGH THERE IS NO ERROR IN THE CONNECT.
IC67205 3 SETTING PRIORITY OF EDU VIA DB2_RESOURCE_POLICY EDU_PRIORITY DOESN'T WORK ON LINUX
IC66964 3 SEVERE ERROR IS REPORTED IN SLES 11 ENV. 'COULD NOT FIND /USR/BIN/SPIDENT'
IC66582 3 DB2PD -DBPTNMEM GETS AN ERROR WHEN THERE ARE MANY LOCAL CONNECTIONS.
IC66465 3 WINDOWS PERFMON NOT GENERATING DCS COUNTER INFORMATION
IC66977 3 SQL30082N ERROR UPON CONNECTION TO A DATABASE ON HP-UX WITH A PASSWORD LONGER THAN 8 CHARACTERS
IC66640 3 THE MESSAGES LOGGED BY SQLNLSICUCONVERTTODEFAULTDATEFORMAT FUNCTION IN DB2DIAG.LOG ARE LOGGED AS ERROR.
IC66770 3 DB2 ON LINUX: SQLOKADETERMINEKERNELINTEGRITY "INDETERMINABLE OPERATING SYSTEM" MESSAGE IN DB2DIAG.LOG
IC66517 3 DB2 UDB, OPER SYSTEM SERVICES, SQLOINITCHCKPWD, PROBE:52 IS RECORDED IN DB2DIAG.LOG
IC67016 3 SNAPSHOT TIMESTAMP AND CURRENT TIMESTAMP MAY BE DIFFERENT ON SOME MACHINES.
IC66488 3 DB2MSCS -U RETURN "DB2MSCS PROCESSING COMPLETE, RC = 1503"
Communication               FP3
IC66504 4 THE DIA3208E ERROR IS LOGGED IN DB2DIAG.LOG WHEN DB2STOP IS CALLED WHILE THE INSTANCE IS STOPED SUCCESSFULLY
Connection Manager               FP3
IC66823 2 TO PROVIDE THE SUPPORT FOR LDAP FOR CLI ODBC DRIVER (DS DRIVER) WHICH IS MISSING AND DOCUMENTED IN INFOCENTER
Control Center               FP3
IC66627 3 CANNOT CREATE TERADATA WRAPPER IN CONTROL CENTER ON LINUX PLATFORMS
IC67241 3 INCORRECT DATABASE STATE REPORTED BY CONTROL CENTER.
IC66884 3 SELECT "ESTIMATE SIZE" IN CONTROL CENTER 9.7, THEN CONTROL CENTER "HANGS".
DB2 Tools               FP3
IC66851 2 ADMIN_GET_MSGS() FAILS IF DATABASE CODE PAGE DIFFERS TO SERVER CODE PAGE, WHEN CALLED FROM A JAVA PROGRAM.
IC67002 2 MEMORY FAULT IN DB2TOP FROM BOTTLENECKS SCREEN
IC66948 2 USER MAY GET FOLLOWING ERROR IN DB2DIAG.LOG WHEN THE HEALTH CENTER GUI IS STARTED ON WINDOWS PLATFORM.
IC66873 3 CONTROL CENTER UNRESPONSIVE WHEN UPDATING TEXT BASED DBM CFG PARAMETER
IC66503 4 SPACE IN COLUMN NAME CREATES INRECOGNIZABLE DB2LOOK STATEMENT FOR THE COLUMN -WHILE RUNNING DB2LOOK OUTPUT.
DRDA Services               FP3
IC66676 1 CREATING A PACKAGE WHEN CONECTING FROM ISERIES TO A DB2 LUW DATABASE FAILS WITH MESSAGE SQL9004
IC66483 2 ATTEMPTS BY ZOS CLIENT TO CONNECT TO DB2 LUW V9.5 SERVER RANDOMLY FAIL WITH SQLCODE:-30020, REASON CODE:124C
IC66572 2 VARIOUS ERROR MESSAGES IN DB2DIAG.LOG WHEN DTC GETS A TIMEOUT WHILE STREAMING IS IN PROGRESS
IC67467 2 AUTOMATIC CLIENT REROUTE IS NOT RETRYING WHEN TIMEOUT VALUE IS SET.
IC67391 3 WHEN CONNECTED THROUGH THE GATEWAY, CLIENTS USING DOWNLEVEL JDBCDRIVER MIGHT CAUSE DB2 TO GENERATE ERROR SQLZ_RC_CMPARM
Data Management Services               FP3
IC67479 1 CRASH RECOVERY FAILS WITH ERROR IN SQLDUPDATETDIRTCB
IC72223 2 IF REORG TABLE INCLUDING INDEX, TABLESPACE + LONGTABLESPACE, IT MAY CAUSE HISTORY LOG CORRUPTION.
IC72099 2 IN RARE TIMING SCENARIOS WHEN INTRA_PARALLEL ENABLED, A SORT OPERATION THAT SPILLS MAY FAIL WITH SQLSMERGEREC, PROBE:2050.
IC66132 2 EXTRANEOUS DB2DIAG.LOG MESSAGES AT DIAGLEVEL 3 DURING DATABASE MIGRATION
IC66760 2 DELETING DATA FROM MULTIDIMENSIONAL CLUSTERED (MDC) TABLES RETURNS INACCURATE RESULTS DUE TO DEFERRED ROLLOUT PROCESSING
IC67471 2 ROLLFORWARD FAILS WITH MESSAGE: SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004
IC66852 3 UNNECESSARY DB2DIAG.LOG MESSAGES MAY GET LOGGED DURING INTERRUPTS
IC66117 3 WHEN ROW LENGTH EXCEEDS TEMPORARY TABLESPACE PAGE SIZE, RETURN -901 ERROR INSTEAD OF MARKING DATABASE BAD
Data Protection Services               FP3
IC66476 1 POINT-IN-TIME TABLESPACE ROLLFORWARD COMMAND MAY CONSUME ALL TEMPSPACES AND HITS DISK FULL CONDITION.
IC66428 2 HITTING INSTANCE MEMORY LIMIT SHOULD NOT BRING DOWN THE DATABASE
IC71279 2 DB2READLOGFILTERDATA RETURNS FALSE SQL0204N CAUSING UNNECESSARY FULL REFRESH DURING REPLICATION
IC67157 2 A RE-STARTED RECOVER COMMAND CAUSES DB2 TO ENTER INFINITE LOOP.
IC66897 2 TRAP IN DB2LOGMGR DUE TO UNEXPECTED CONDITION
IC68006 3 AFTER A DATABASE RESTORE, PATH TO LOG FILE CHANGES TO THE DEFAULT PATH
IC67452 3 SLOW PERFORMANCE FOR ROLLFORWARD AND HADR STANDBY
IC66896 4 "TOO MANY LOGS, NEED TO RECLAIM" IN STANDBY DB2DIAG.LOG FILE
Engine Infrastructure               FP3
IC68297 2 INSTANCE TRAPS AT FUNCTION SQLPENDUOWRUNTIME DUE TO OUT OF MEMORY FAILURE FOR DATABASE HEAP
IZ66828 2 IN DPF, CONNECTING TO A QUIESCED DATABASE BY A USER WHO HAS QUIESCE_CONNECT AUTHORITY MAY STILL THROW A SQL20157N ERROR
IC66908 2 AFTER MULTIPLE IMMEDIATE TAKEOVERS (IN A WHILE LOOP) THE SUBSEQUENT TAKEOVER GETS AN ERROR SQL1035N (DATABASE CURRENTLY IN USE.)
IC66321 2 IF CRASH RECOVERY FAILS WITH HADR STARTED THE DATABASE WILL STAYONLINE BUT WILL STILL BE INCONSISTENT RESULTING WITH SQL1015N.
IC67253 2 DB2START RESTART NEEDS SERIAL FAILOVER CODE RE-USE FROM V91 IN V98
IC66587 3 RETURN CODE SQLKD_NOMORE_DATA RECEIVED FOR SQLRKRPC_NL COULD LEAD TO SQLCODE -901.
Engine Utilities               FP3
IC67602 1 DB2 LOAD MIGHT CRASH THE DB2 INSTANCE IF THE DB2LRID PROCESS HITS OUT-OF-MEMORY ERROR VERY EARLY ON
IC67549 2 ERROR "SQLUXCOMMITROLLBACKREQUEST" OCCURRED BEFORE ONLINE BACKUPIS DONE
IC66522 2 ON WINDOWS PLATFORM, REMOTE LOAD MAY FAIL WITH "ACCESS DENIED" ERROR
IC66423 2 DB2 ENGINE MAY TRAP IN SQLULIGN() WHILE LOADING DATA FROM IXF FILE.
IC66507 2 ARCHIVE LOG DOES NOT WORK USING TSM PASSWORD PROMPT
IC66418 2 POSSIBLE DATABASE ABEND DURING DROP TABLE STATEMENT WHEN USING HIGH PERFORMANCE UNLOADER ( DB2HPU )
IC67222 2 UNEXPECTED SQLCODE RETURNED FROM API DB2GETROWPARTNUM AND DB2GETDISTMAP DUE TO NOT INITIALIZED SQLCA.
IC66093 2 MEMORY LEAK OF 36548 OR 514 BYTES WHEN EXECUTING LOAD COMMAND
IC67134 2 A LOAD OPERATION FROM CURSOR WHICH CONSISTS OF DATA WITH BAD CHARACTERS CAUSES DB2 TO CRASH.
IC68214 2 REDIRECT RESTORE OF DATABASE FAILS WITH SQL5153N
IC67128 2 IN DPF ENVIRONMENT WITHOUT NODE 0, AN SQL STATEMENT THAT PROCEEDS AN IMPORT WITH ALLOW WRITE ACCESS MAY HANG
IC67042 2 INSTANCE HANG WHEN RUNNING REDISTRIBUTE COMMAND WHICH RECREATE INDEX AND COLLECT STATISTICS INTERNALLY
IC66523 2 DB2 INSTANCES TERMINATES ABNORMALLY OR RETURNS -901 COMPILING A QUERY
IC67173 2 LOAD OF TIMESTAMP VALUES CAN FAIL WITH SQL0180 ON NON-DELIMITED ASCII FILE FORMAT
IC67138 2 A CLIENT PROCESS RUNNING IMPORT OPERATION MIGHT CRASH IF IT RUNSINTO OUT-OF-MEMORY ERROR
IC68201 2 TABLESPACE IS LEFT IN STATE "LOAD IN PROGRESS" (0X20000) AFTER ALOAD WITH COPY NO OPTION FAILED
IC66532 2 DB2 EXPORT CREATES EXCESSIVE LOCKING ON CATALOG TABLES.
LI75002 3 LOAD SHOW ERROR MESSAGE IN DB2DIAG.LOG. "SQLUREMOVETEMPDIRS: COULD NOT READ LOC FILE PROPERLY! , -2146107283"
IC66534 3 ATS THROW ADM15503E WHEN TASK TABLES DOESN'T EXIST
IC66597 3 ADD ADDITIONAL DETAILS ABOUT LOAD UTILITY OPERATION TO THE LIST-HISTORY ENTRY.
IC68082 3 SLOW RESTORE INTO A NEW DATABASE ON AIX DUE TO HAVING ONLY 3 PREFETCHERS STARTED.
IC66426 3 IMPORT WITH METHOD P MODIFIER MAY PRODUCE SQL3114W TRUNCATION WARNINGS WHEN CHARACTER DELIMITERS EXIST IN DATA.
IC66955 3 CONTROLCENTER DOES NOT SHOW THE PENDING VALUE FOR APPL_MEMORY ASAUTOMATIC VALUE
Federation               FP3
IC66696 3 MINOR MEMORY LEAK WHEN USING FEDERATION PASSTHRU FEATURE.
High Availability               FP3
IC67196 1 INVALID FORMAT IN EXTENT HEADER BRINGS DOWN HADR STANDBY
IC67535 2 HADR STANDBY IN LOCAL CATCHUP HAS TOO MANY 'EXTENT MAY BE STALE'MESSAGES IN DB2DIAG.LOG
IC67757 2 AFTER AN ABNORMAL SHUTDOWN OF HADR STANDBY, THE ACTIVATION OF THE DATABASE WILL START THE LOCAL CATCHUP WAY BACK IN TIME.
IC66579 2 HADR STANDBY (DB2HADRS) MIGHT PANIC IF IT CANNOT CLOSE SQLOGMIR.LFH DURING SHUTDOWN.
IC72336 2 DB2/AIX PURESCALE: CLUSTER CACHING FACILITY CA-SERVER PROCESS TRAPS ON FIX PACK 2
IC66569 2 DB2HAICU XML IMPORT ONLY SUPPORTS ONE VIRTUAL IP PER PARTITION
IC67078 2 SLOW LOG RETRIEVAL ON A HADR STANDBY CAUSES IT TO MOVE TO REMOTECATCHUP
IC66724 2 EXCESSIVE MESSAGES ON HADR STANDBY: "EXTENT NNNN IN LOG PATH MAYBE STALE. TRYING ARCHIVE"
IC66736 3 DB2HAICU CANNOT HANDLE EXISTING FIXED TSA RESOURCES AND EXIT WITH ERROR.
Index Manager               FP3
IC67149 2 TRAP IN SQLICOMPAREKEYS WHEN A SHARED BLOCK INDEX SCAN INVOLVES A NULL START/STOP KEY ON A NON-NULLABLE COLUMN
IC67386 2 DABASE MARKED BAD AND CRASH WHEN ALTER INLINE LENGTH OF COLUMN ON WHICH SPATIAL INDEX IS DEFINED
IC67521 2 SCAN SHARING FOR MDC BLOCK INDEX SCAN CAUSES MEMORY LEAK ON DBHEAP.
IC67249 3 COMPRESSION RATIO VALUE IN SYSCAT.INDEXES NOT VERY ACCURATE WHEN USING RANGE PARTITIONED TABLES AND PARTITIONED INDEXES
Install               FP3
IC68398 1 SAMPLE UNINSTALL RESPONSE FILE CONTAINS AN INCORRECT ENTRY OF MKC
IC70199 1 INSTALLFIXPACK WRITES TO FILES IN THE INSTANCE'S SQLLIB FOLDER REGARDLESS IF THE DIRECTORY EXISTS OR NOT.
IC67314 1 QUERY PATROLLER INSTALLATION IS FAILING WITH MAJOR ERROR
IC69907 1 INSTALLFIXPACK FAILS TO INSTALL IN A HA ENVIRONMENT DUE TO INSTANCES NOT MOUNTED.
IC67175 2 INSTALLATION COMPLETES SUCCESSFULLY BUT INSTANCE IS NOT MIGRATEDCORRECTLY IN SILENT INSTALL IF DB2.NAME IS KEPT BLANK
IC68104 2 DB2ICRT SHOULD REFUSE TO CREATE AN INSTANCE UNDER DB2DIR DURING FIXPAK INSTALLATION.
IC68392 2 DB2IMIGR SETS INCORRECT PERMISSIONS FOR KERBEROS CATALOG DIRECTORIES IN SQLDBDIR (SQLKRB)
IC66843 2 DB2 .NET DATA PROVIDERS ARE NOT CONFIGURED IN MACHINE.CONFIG WHEN V97 64-BIT DS DRIVER IS INSTALLED ON 64-BIT WINDOWS
IC68253 2 UPGRADING A NON-ROOT COPY FROM DB2 V95 TO V97 FIX PACK 2 FAILS
IC68584 3 DB2UNINS WITH -U OPTION (TO DO SILENT UNINSTALLATION) SHOULD NOTRETURN UNTIL THE UNINSTALLATION IS FINISHED
IC67943 3 INSTALLFIXPACK MAY NOT INFORM CORRECT ERRORS
IC66988 3 DB2IUPGRADE FAILS SOMETIMES WITH "DBT5025N THE DB2CHECKSD UTILITY FAILED WITH AN UNHANDLED ERROR"
IC66969 3 SERVICE OF DB2 SATELLITE INSTANCE IS NOT REMOVED AFTER UNINSTALLATION OF DB2
IC67132 3 THE FILES THAT CONTAIN THE STORED PROCEDURES ARE NOT WORLD READABLE
IC67212 3 UNINSTALLATION OF DB2 DOES NOT REMOVE DB2 RESERVED SERVICE/PORT ENTRIES IN WINDOWS SERVICES FILE
IC69502 3 DB2PROCESSORS INSTANCE PROFILE VARIABLE IS NOT NEEDED ANYMORE
Interpartition Communication               FP3
IZ68053 2 HIGH CPU USAGE IN A SCENARIO WITH TABLE QUEUE SPILLING
IZ67999 2 PERFORMANCE DEGRADATION CAUSED BY TABLE QUEUE SPILLING
Monitoring               FP3
IC66518 2 AGENT MAPPED TO WRONG SERVICE SUBCLASS WHEN CURSOR IS CANCELED WITHIN NESTED ACTIVITY
IC67131 2 DEADLOCK MONITOR ELEMENT MAY NOT GET UPDATED IN APPLICATION SNAPSHOT.
IC67114 2 MEMORY LEAK IN MON_GET_LOCKS, MON_GET_APPL_LOCKWAIT TABLE FUNCTIONS AND MON_LOCKWAITS ADMIN VIEW
IC66933 2 THE MON_GET_LOCKS TABLE FUNCTION SOMETIMES REPORTS CACHED, UNUSED LOCK STRUCTURES
IC66473 2 MONITOR NOT CAPTURING UNIT OF WORK RECORD WHEN COMMIT IS CHAINEDFROM JCC
IC68293 2 DB2 EDU MAY KEEP LOOPING IN SIGNAL HANDLER AND NEVER RETURN WHENLOAD COMMANDS ARE CALLED FROM STORED PROCEDURES
IC68429 2 SIGNAL #11 CRASH OR HIGH CPU USAGE WHEN IPV6 CLIENT CONNECTED.
IC66647 3 "LOCK_COUNT" VALUE RETURN FROM MON_GET_LOCKS TABLE FUNCTION IS NOT CORRECT.
IC66991 3 DATA_PARTITION_ID COLUMN FROM SYSIBMADM.MON_LOCKWAITS ADMIN VIEWIS INCORRECT
IC66588 3 ACTION SCRIPTS IS EXECUTED WHEN FIRST EVALUATIONS OF HEALTH INDICATORS IF ACTION CONDITION IS SET AS ALLALERTS.
IC67209 3 POOL_ASYNC_WRITE_TIME AND POOL_WRITE_TIME MONITOR ELEMENTS MAYBE LARGER THAN THE ACTUAL VALUE.
Problem Determination               FP3
IC67894 1 RUNNING DB2PDCFG UTILITY WITHOUT ANY OPTION MAY CRASH INSTANCE IN WINDOWS PLATFORM
IC66714 2 DB2TOP EXITS WITH ERROR "FUNCTION NOT IMPLEMENTED (NG_MINIMIZE)"
IC66994 3 DB2PD SHOWS INCORRECT VALUES FOR LOGSECOND, AS A UNSIGNED INTEGER
Quality Assurance               FP3
IC67151 4 ADDING SYSTEM TIME TO DB2PD OUTPUTS
Query Compiler, Rewrite, Optimizer               FP3
IC67896 1 CALL SYSPROC.NNSTAT() RETURNS SQL0309N
IC66311 1 RUNSTATS GENERATES EXCESSIVE LOCKING IN SYSCOLUMNS AND LOCK TIMEOUTS
IC66888 1 FEDERATED QUERY HAVING SCALAR CORRELATED SUBQUERY PREDICATE COULD RETURN INCORRECT RESULT.
IC67297 2 ROLLBACK IS NOT ALLOWED TO ROLLBACK BEYOND BEGINNING OF ANONYMOUS BLOCK
IC67532 2 SET SESSION AUTHORIZATION/SET SESSION_USER WITH STRING CONSTANT INSIDE SQL ROUTINE CAUSES TRAP
IC67263 2 CREATION OF SUBVIEW SUCCEEDS BUT SHOULD FAIL WITH SQLCODE SQL20053 REASON CODE 2, SQLSTATE 428EA
IC66601 2 SQL0901N MAY BE ISSUED COMPILING A QUERY CONTAINING A TABLE WITHDEPENDENT MQT(S) AND A NON-EQUALITY PREDICATE
IC71236 2 INSTANCE MAY ABEND DURING COMPILATION OF A QUERY CONTAINING IMPLICITLY EQUIVALENT COLUMNS AND A PREDICATE WITH AN EMPTY STRING
IC66653 2 DB2 INSTANCE ENDS ABNORMALLY COMPILING QUERY WITH A LARGE NUMBEROF UNIONS
IC67552 2 SQL338N IS RETURNED WHEN AN ON CLAUSE OF A JOIN OPERATION REFERENCES A COMPILED SQL FUNCTION
IC67983 2 QUERY PERFORMANCE CAN BE POOR WHEN JOINING TO A DATA PARTITIONEDTABLE USING THE DATA PARTITIONING COLUMNS.
IC67557 2 USING PRIOR AS A COLUMN NAME WILL GIVE SQL0104N ALTHOUGH DB2_COMPATIBILITY_VECTOR IS NOT SET
IC66783 2 DB2 MAY ABEND IN FUNCTION SQLNG_BUILD_SQLD_VALS_OBJ WHEN REFERENCING A LARGE NUMBER OF XML COLUMNS IN A GROUP BY SUB-SELECT
IC68316 2 EXECUTION OF A QUERY CONTAINING SCALAR SUBQUERY OUTPUT COLUMN REFERENCE MAY FAIL WITH SQL0901N IN A DPF ENVIRONMENT
IC68058 2 REPLACE('AAA','A','') DOES NOT RETURN NULL IN VARCHAR2 COMPATIBILITY MODE
IC67332 2 STRING TRUNCATION DOES NOT RAISE AN EXCEPTION IN PL/SQL CODE
IC68031 2 THE OPTIMIZER MAY FAVOR A FULLY QUALIFIED UNIQUE INDEX WITH FEWER COLUMNS OVER A UNIQUE NOT FULLY QUALIFIED UNIQUE INDEX
IC67155 2 DB2EXFMT TAKES A LONG TIME TO COMPLETE ( 5+ HOURS) AFTER RUNNINGA QUERY THAT LOADS THE LARGE AMOUNT OF DATA INTO EXPLAIN TABLES.
IC67271 2 QUERY FAILS WITH SQL0204N WHEN REFERENCED VIEW IS DROPPED AND RECREATED IN ANOTHER TRANSACTION.
IC66641 2 JDBC-STYLE '?' PARAMETER MARKERS NOT SUPPORTED IN PL/SQL ROUTINES
IC67992 2 QUERY AGAINST SYSCAT.MODULES MAY RETURN UNEXPECTED RESULT SET INORACLE COMPATIBLE DATABASE
IC66945 2 SQL0901N RETURNED WITH REASON CODE "INVALID QNC ASSIGNMENT"
IC66574 2 DB2ADVIS MAY EXIT WITH ERROR CODE -220. ALTERNATIVELY, COMPILATION UNDER ANY ADVISOR EXPLAIN MODES MAY FAIL WITH SQL0220N
IC67966 2 -104 FROM CURSOR DECLARATION WITH HYPHENATED CURSOR NAME
IC67895 2 SQL0502N(CURSOR ALREADY OPEN) WHEN TWO FOR LOOPS USE THE SAME CURSOR IN THE SAME PL/SQL ROUTINE
IZ67166 2 DB2 CAN CRASH REMOVING DUPLICATE PREDICATES FROM THE OPTIMIZERS REWRITTEN QUERY
IC67860 2 COMPILATION OF MODULE OR PACKAGE WITH PROCEDURE THAT CONTAINS MORE THAN 90 PARAMETERS RETURNS INCORRECT -442 ERROR
IC67678 2 A QUERY CONTAINING MAX OR MIN AGGREGATE FUNCTION AND REFERRING TO MQT WITH GROUP BY CLAUSE CAUSES AN INSTANCE CRASH
IC66906 2 LEFT AND RIGHT SCALAR FUNCTIONS DO NOT ALLOW LEN > LEN(STR)
IC67248 2 SQLEXECUTE IN CLI RETURNS SQL401N FOR COMPARISON OPERATORS WHEN USING DEFERRED PREPARE AGAINST A NON-UNICODE TARGET DATABASE
IC66886 2 SELECT INTO IN COMPOUND STATEMENT DISALLOWED WHEN ISSUED BY CLI OR JDBC
IC66926 2 DB2 CAN NOT HOOK NO_DATA_FOUND INSIDE OF A FOR CURSOR LOOP IN PL/SQL.
IC66443 2 STATEMENT COMPILATION MAY FAIL TO USE THE STATISTICS COLLECTED FOR A GLOBAL TEMPORARY TABLE.
IC67684 3 SQL0803N "DUPLICATE VALUES FOR THE INDEX KEY" IN EXPLAIN_DIAGNOSTIC TABLE
IC67187 3 COMPRESSION STATISTIC PCTPAGESSAVED MAY BE INACCURATE.
IC66315 3 CARDINALITY OF OR PREDICATE IS UNDERESTIMATED WHEN LIKE PREDICATE IS A SUBTERM OF AN OR PREDICATE.
IC67458 3 EXPLAIN SHOWS INCORRECT INDEX TABLESPACE WHEN INDEXES ARE IN A DIFFERENT TABLESPACE THAN THE TABLE
IC70399 3 PREDICATE OF THE FORM "<CONCAT EXPRESSION> = G'CONSTANT'" RESULTS IN WRONG DATA RETURNED FROM QUERY
Relational Data Services               FP3
IC67850 1 INSERT STATEMENT MAY ABNORMALLY TERMINATE WHEN RUNNING CONCURRENTLY WITH CREATE (SPATIAL) INDEX DDL
IC67213 2 THE TABLE FUNCTIONS SYSPROC.ADMIN_GET_INDEX_COMPRESS_INFO AND SYCAUSE DB MARKED BAD IN DATA PRATITIONED ENV.
IC67153 2 WHEN ROW CHANGE TIMESTAMP IS SPECIFIED FOR USER TEMPORARY TABLESAN ERROR IS NOT RETURNED.
IC66405 2 DB2 INSTANCE CRASHED DUE TO DOUBLE FREEING A MEMORY BLOCK IN THESHARED APPLICATION CONTROL HEAP
IC68239 2 MEMORY LEAK IN APPLICATION HEAP WHEN CLIENT AND SERVER HAVE DIFFERENT CODE PAGE AND CONNECTION CONCENTRATOR IS ON
IC67475 2 CREATE EVENT MONITOR DDL MAY ABNORMALLY TERMINATE WITH SQL1224N
IC66831 2 QUERY MIGHT RETURN SQL0501N.
IC70026 2 AFTER RUNNING DB2UPDV97, THE DB2RBIND COMMAND WITH OPTION ALL RETURNS SQL0551N
IC69555 2 XQUERY CEILING FUNCTION RETURNS INCORRECT RESULTS WHEN IN ORACLECOMPATIBILITY MODE
IC67162 2 UNNECESSARY TABLE TRUNCATION ON COMMIT/ROLLBACK CAN IMPACT PERFORMANCE
IC69319 2 TRAP POSSIBLE DURING THE ROLLBACK OF A TRANSACTION THAT INCLUDESTHE CREATION OF A DECLARED GLOBAL TEMPORARY TABLE
IC66514 2 QUERY AGAINST A PARAMETERIZED BASED TABLE MAY INCORRECTLY RETURN SQL0100W IF THE SAME STATEMENT FAILED PREVIOUSLY.
IZ62796 2 DB2 DO NOT SUPPORT THE DECIMAL DATA TYPE ON COBOL ON DB2V95
IC67959 2 IN DPF, POSSIBLE TRAP WHEN RUNNING TABLE FUNCTION MON_GET_UNIT_OF_WORK OR MON_GET_UNIT_OF_WORK_DETAILS IN LOW MEMORY SITUATION
IC68468 2 SYSIBM.INSERT AND SYSIBM.OVERLAY SCALAR FUNCTIONS RETURN SQL0138N, IF LENGTH>LENGTH(SOURCE-STRING)-START+1.
IZ67926 2 MEMORY LEAK IN APPLICATION SHARED MEMORY IF INTRA_PARALLEL IS ONAND THE INSTANCE IS DPF.
IZ68314 2 FOR EACH ROW TRIGGER WITH MERGE STATEMENT MAY PRODUCE INCORRECT BEHAVIOUR.
IC67716 2 CONCURRENT CREATE OR REPLACE VIEW STATEMENTS MAY DEADLOCK INVOLVING SYSIBM.SYSCOLAUTH TABLE
IC67034 2 SYSTEM GRANTED PRIVILEGES NOT REGENERATED ON VIEWS WHEN AUTO_REVAL IS SET TO IMMEDIATE
IC66478 2 DELETE FROM TABLE MAY RETURN SQL0440N AFTER A COLUMN WAS DROPPEDFROM ITS DEPENDENT/PARENT TABLE IN A FOREIGN KEY CONSTRAINT
IC67523 3 RUNNING TWO CREATE FUNCTION STATEMENTS CONCURRENTLY MAY DEADLOCKWITH SQL0911 RC=2
IC66477 3 EXCESSIVE SQLZ_CA_BUILT MESSAGE MAY BE LOGGED IN DB2DIAG.LOG WITH SEVERE LEVEL DURING ALTER TABLE
IC67049 3 REBIND CONSERVATIVE MAY FAIL WITH SQL0440N
IZ69153 3 EXPLAIN FROM SECTION SHOWS INCORRECT ESTIMATED CARDINALITY IN DPF ENVIRONMENTS
Replication               FP3
IC67091 2 REPL ENGINE APAR FOR V95FP6
Security               FP3
IC72242 2 THE "USERID" AND "AUTHID" FOR ALL EVENTS IN THE AUDIT CATEGORY ARE INCORRECT.
IC67907 2 FILE SHARING VIOLATION (AS IN SOMETHING EXTERNAL TO DB2 HOLDING A LOCK ON WINDOWS FOR THE DB2AUDIT FILE)
IC68516 2 A DEFUNCT PROCESS COULD BE CREATED AFTER A CHANGE PASSWORD OPERATION.
IC66304 2 DB2 AUDIT FACILITY MAY NOT CAPTURE CONNECTION EVENTS USING DATABASE-LEVEL AUDIT SETTINGS EVEN THE DATABASE IS ACTIVATED
Spatial Extender               FP3
IC66825 2 DB2 SPATIAL EXTENDER SHAPEFILE IMPORT FAILURES
IC67730 1 SQLCODE 100 ENCOUNTERED WHILE ATTEMPTING TO DROP SQL PROCEDURE OR FUNCTION
IC67728 1 SQL0727N REPORTED AFTER CREATE OR REPLACE FUNCTION OF COMPILED SQL FUNCTION
IC67059 2 OTM FAILS WITH SQL20303N ERROR WHEN EXISTING UNIQUE INDEX NO LONGER INCLUDES ALL PARTITIONING KEYS ON THE TARGET TABLE
IC67563 2 OTM MIGHT DEADLOCK IF MULTIPLE OTM OPERATIONS ARE RUNNING ON DIFFERENT TABLES IN PARALLEL
IC66983 2 INSTANCE MAY CRASH IF THE DOUBLE FREE OCCURS WHEN GETAUTHORITIESTRIES TO FREE THE MEMORY ALREADY FREED.
IC67350 2 ADMIN MOVE TABLE REPLAY PHASE FAILS ON TABLES WITH UNIQUE COLUMNS DUE TO UNIQUE CONSTRAINT VIOLATION
IC66521 2 DB2 DO NOT SUPPORT THE DECIMAL DATA TYPE ON COBOL ON DB2V95
XML Data Services               FP3
IC67201 1 SQL1224N MAY OCCUR WHEN DOING AN INSERT OR UPDATE ON AN XML INLINE COLUMN AND THE COLUMN IS DEFINED IN A TABLE USING A 32K PAGE
IC67171 2 THE INSTANCE CAN CRASH BY RESTORING OR MIGRATING DATABASE INCLUDING XML COLUMN TABLE FROM OLDER VERSION DATABASE
IC67204 2 XML UPDATE REMOVES ELEMENT NAMESPACES WHEN USING "MODIFY DO INSERT <SOURCE-EXPRESSION> AFTER <TARGET-EXPRESSION>"
IC66524 2 SELECT OF AN CLOB COLUMN FROM AN XMLTABLE CAUSED DB2 TO CRASH.
IC66735 2 ORDER BY WITH XMLTABLE INVOLVING CONSTRUCTED OR INLINED XML DOCUMENTS MAY CRASH INSTANCE.
IC67170 2 ON DPF ENVIRONMENT, DATABASE MIGHT CRASH DURING INSERT FROM XMLTABLE WHEN XMLCAST WITH PARAMETER MARKER INPUT IS INVOLVED.
IC69734 2 A "SQL1034C THE DATABASE IS DAMAGED" ERROR MAY OCCUR IN CERTAIN XML QUERIES OR XMLTABLE

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"OTHER - Uncategorised","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"9.8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 January 2020

UID

swg21455035