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

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.

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