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
Tab navigation
************************************************************
Product Name : DB2 Version 9.8
Updated : Wed May 30 10:44:53 EDT 2012
************************************************************
| 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"}}]
Was this topic helpful?
Document Information
Modified date:
27 January 2020
UID
swg21455035