APAR fixes included in Fixpak 4 | APAR No. | Sev. | Abstract |
|
Administration Tools |
|
IZ19616 |
2 |
ERROR 'OBJECT IS INOPERATIVE IN SOURCE SCHEMA; NOT COPIED' AFTER COPYING A SCHEMA USING DB2MOVE. |
|
IZ41203 |
2 |
SQL0206N "DATAMODEL" IS NOT VALID IN THE CONTEXT WHERE IT IS USED WHEN RUNNING BIND COMMAND. |
|
LI73709 |
2 |
AUTOMAINT_SET_POLICY CAN FAIL WITH SQL1131, SQL1438 OR STORES WRONG VALUE FOR MANY ATTRIBUTES IN DB2 V9.5 FP3 |
|
IZ19094 |
3 |
DB2MOVE WITH THE COPY OPTION DOES NOT COPY TRIGGERS |
|
IZ18096 |
3 |
WHEN USING DB2MOVE TO COPY DATABASE OBJECTS, THE START VALUES OFIDENTITY COLUMN IN TARGET TABLE ARE NOT BEING PRESERVED |
|
IZ35653 |
3 |
DB2 DESIGN ADVISOR (DB2ADVIS) MAY ABEND WHEN INDEX AND MDC RECOMMENDATIONS ARE REQUESTED TOGETHER, I.E., -M IC |
|
JR31064 |
4 |
DB2LOOK DOES NOT GENERATE COLUMN LEVEL DDL WHEN USING THE -T OPTION. |
|
Buffer Pool Services |
|
IZ35046 |
1 |
ROLLFORWARD FAILS WITH SQL1042 OR CRASH RECOVERY FAILS WITH DB2DIAG.LOG ENTRY MESSAGE: DIA8709E. |
|
LI73823 |
1 |
TAKING BACKUP WHILE PERMISSIONS DENIED TO /TMP FOR INSTANCE OWNER MAY CORRUPT SQLSPCS FILE. |
|
IZ40786 |
1 |
CONTAINER OPERATIONS(DELETION AND ADDITION OF SAME CONTAINER), DOES NOT GET REPLAYED SUCCESSFULLY,USING LOGS DURING ROLLFORWARD |
|
LI73105 |
1 |
INTERNAL RESOURCE CONTENTION DURING PARALLEL ONLINE BACKUP MAY LEAD TO LESS THAN OPTIMAL THROUGHPUT |
|
IZ37888 |
2 |
DB2 PAGE CLEANER CAN BRING DOWN INSTANCE WITH SIGNAL 11 SIGSEGV AFTER RUNNING OUT OF FILE DESCRIPTORS |
|
IZ25688 |
2 |
SET WRITE SUSPEND ON A BUSY DATABASE CAN HANG FOR A VERY LONG TIME, WAITING ON THE PAGECLEANERS GETTING PAUSED |
|
IZ22989 |
2 |
DB2PD -TABLESPACES DOES NOT SHOW ALL TABLESPACES |
|
IZ40148 |
2 |
USERS SEE I/O SPIKE IN HADR STANDBY SYSTEM WHEN LARGE BUFFERPOOLIS USED. |
|
LI74126 |
2 |
DB2 INSTANCE MAY CRASH BECAUSE OF THE INVALID TIMEOUT VALUE WHENALTERNATE PAGE CLEANING IS USED. |
|
IZ20120 |
3 |
LARGE NUMBER OF "NO AVAILABLE BUFFER POOL PAGES" IN DB2DIAG.LOG |
|
IZ35325 |
3 |
DB2DIAG.LOG FILL WITH "NON-NUMERICAL VALUE USED IN DB2_SET_MAX_CONTAINER_SIZE REGISTRY VARIABLE." |
|
IZ19615 |
3 |
HIGH NUMBER OF CONCURRENT DECLARE GLOBAL TEMPORARY TABLE REQUESTCAN CAUSE PERFORMANCE ISSUES IN COMPLETING THE DGTT REQUESTS. |
|
IZ15060 |
3 |
INCORRECT SQL0968C "FILE SYSTEM FULL" FOR TABLESPACES WITH AUTOMATIC STORAGE |
|
Client |
|
JR31850 |
2 |
ADDING CONNECTION IN VISUAL STUDIO MAY FAIL WITH "ERROR OCCURREDADDING THE CONNECTION." |
|
Client Interfaces |
|
IZ44216 |
1 |
MEMORY CORRUPTION CAUSING CLI APPLICATION CRASH WHEN USING MORE THEN 16 DATA_AT_EXEC PARAMETERS |
|
IZ27551 |
1 |
SQLFREESTMT() RETURNS RC=0 WHEN INTERRUPTED BY DEADLOCK EVENT |
|
IZ30428 |
2 |
WHEN RUNNING REORGCHK MESSAGES ARE SEEN LIKE THIS. ADM4500W A PACKAGE CACHE OVERFLOW CONDITION HAS OCCURRED. |
|
JR31101 |
2 |
REORGCHK FROM V9.5 CLIENT TO V8.X SERVER CAN CRASH OR RETURN ERROR SQL0501N |
|
IZ41217 |
2 |
SLOW PERFORMANCE BECAUSE PREPARE IS DONE EACH TIME WHEN USING CLI YOU ALTERNATE BETWEEN ARRAY INSERT AND NON-ARRAY INSERT. |
|
LI73960 |
2 |
CORE DUMP WITH SSL ON LIBRARY LIBGSK7SSL_64.SO |
|
JR30656 |
2 |
AN INSTANCE CRASH CAN OCCUR WHEN SNAPSHOTS ARE RUN FROM A VERSION 9 (AND LATER) CLIENT AGAINST A VERSION 8 SERVER. |
|
JR32156 |
2 |
PREDICTIVE GOVERNOR IN DB2 V8 IS NOT IMPLEMENTED, THUS CAUSING HIS APPLICATION TO FAIL WITH A -30002 ERROR CODE |
|
IZ43449 |
2 |
WHEN MICROSOFT ENTITY FRAMEWORKS EDM DESIGNER IS USED WITH 9.1 FAMILY OF SERVERS, AN ERROR IS RETURNED. |
|
JR31169 |
2 |
ENHANCE RETURN CODE HANDLING IN CLI FUNCTION SQLSETENVATTR |
|
IZ39926 |
2 |
DATE IS RETURNED UNEXPECTEDLY IN MM/DD/YYYY FORMAT IN JA_JP ENVIRONMENT THRU SP ON V9.5. |
|
JR32078 |
2 |
MEMORY FAULT IN CLICONV |
|
JR31836 |
2 |
DB2 .NET DATA PROVIDER PREPARES ON EVERY EXECUTE METHOD CALL. |
|
JR30850 |
2 |
TEST ODBC CONNECTION MAY FAIL WHEN CONNECTING TO A DATABASE WITH A LENGTH THAT IS LONGER THAN 8 CHARACTERS |
|
IZ42198 |
2 |
INCORRECT PRODUCT SIGNATURE FOR DB2 V10 |
|
JR31611 |
2 |
ENABLE CLI KEYWORD SETTING PATCH1=1 IN DB2 UDB VERSION 9.5 |
|
IZ37887 |
2 |
DB2 GET DATABASE OR DATABASE MANAGER CONFIGURATION COMMAND DOES NOT SHOW VALUES BEHIND AUTOMATIC SETTINGS |
|
IZ40484 |
2 |
FUNC CALL SYSIBM.SQLTABLES RETURN NOTHING WHEN CATALOG NAME IS NOT NULL |
|
IZ35482 |
2 |
REORGCHK INDEX OUTPUT F5 MIGHT STILL ADVISE TO REORG AN MDC BLOCK INDEX EVEN THOUGH THE TABLE HAS BEEN REORD'ED. |
|
JR29992 |
3 |
SQLALLOCENV() AND SQLALLOCHANDLE(SQL_HANDLE_ENV,...) WILL TURN OFF A PREVIOUSLY DYNAMICALLY ACTIVATED CLI TRACE |
|
LI73802 |
3 |
REORGCHK TABLE FORMULAS F2 AND F3 MIGHT STILL ADVISE TO REORG A MDC TABLE EVEN THOUGH THE TABLE HAS BEEN REORD'ED. |
|
LI73886 |
3 |
LIST DATABASE DIRECTORY DOES NOT PRINT DIRECTORY NAME USING UTF-8 |
|
IZ33418 |
3 |
.NET DRIVER DOES NOT HANDLE WARNING/INFORMATION MESSAGE. |
|
IZ39107 |
3 |
CLI DOES NOT SUPPORT MAX VALUE THAT IS SUPPORTED BY REAL370 COLUMNS ON Z/OS |
|
JR31833 |
3 |
CONNECTION FAILS IF PASSWORD CONTAINS TWO DOLLAR SIGN '$$' |
|
IZ31784 |
3 |
CALLING AN UNQUALIFIED SP ON Z/OS RESULTS IN A DB21106E ERROR |
|
JR31727 |
3 |
IBM DATA SERVER RUNTIME CLIENT DOES NOT INSTALL DB2CLI.INI IN THE CORRECT LOCATION |
|
JR29790 |
3 |
DB2 64-BIT CLIENT DOES NOT CONTAIN 64 BIT DB2CLI.LIB |
|
JR31627 |
3 |
.NET EXCEPTION WHEN RETRIEVING THE DESCRIPTION OF SOME PROPERTIES RETURNED BY IFXCONNECTIONSTRINGBUILDER |
|
JR30733 |
3 |
ICOLUMNSINFO AND IDBSCHEMAROWSET(DBSCHEMA_COLUMNS) RETURN DIFFERENT DATATYPES FOR DECIMAL COLUMN IN OLEDB APPLICATIONS |
|
IZ15272 |
3 |
CONNECTION PERFORMANCE DEGREDATION WHEN RUNNING WITH CLI IN STATIC MATCH MODE. |
|
IZ39831 |
3 |
DB2 ?L COMMAND BEHAVIOR CHANGED IN V 9.5, TAIL ? F CANNOT READ |
|
JR31679 |
3 |
WHEN COMMUNICATION ERROR HAS OCCURED MORE THAN ONCE ON A CONNECTION, THE STATE REPORTED COULD BE WRONG |
|
JR30142 |
3 |
SYSSCHEMA IS NOT SHOWING AS AN AVAILABLE CLI SETTING IN CONFIGURATION ASSISTANT. |
|
Common Code Infrastructure |
|
IZ47448 |
1 |
DATABASE BACKUP IMAGE DOES NOT CONTAIN ALL FILES FOR SMS TABLE SPACES WITH "FILE SYSTEM CACHING" ENABLED AND DB2_MMAP_READ=ON. |
|
IZ44927 |
1 |
WHEN RUNNING LOW ON VIRTUAL MEMORY, A CRASH CAN OCCUR DUE TO AN ATTEMPT TO FREE A NULL POINTER IN FINDPRIVATEPOOLSANDBUILDLIST |
|
LI73798 |
1 |
TRAP IN GETENV |
|
IZ42228 |
1 |
ENABLING AIX TRACE CAUSES NOTICEABLE PERFORMANCE DEGRADATION |
|
JR32268 |
1 |
UNAUTHORIZED CONNECTIONS POSSIBLE ON DATABASE SERVERS WITH LDAP-BASED AUTHENTICATION |
|
IZ35535 |
2 |
LOAD PERFORMANCE PROBLEM ON WINDOWS IF THE CPU PARALLELISM APPLIED IS GREATER THAN 1 |
|
IZ42722 |
2 |
SNAPSHOT MONITOR ELEMENT FS_CACHING CAN OUTPUT VALUE OTHER THAN 0 AND 1. |
|
JR31860 |
2 |
V95FP4: FVT DB2_V95FP3(A): CONFIGURING EXTENDED SECURITY FAILURE WHEN THE GROUP NAMES HAVE THE CHAR: '.' |
|
JR30561 |
2 |
RUNNING DB2EXTSEC FOLLOWING COMPUTERNAME CHANGE RESULTS WITH ERROR: NO MAPPING BETWEEN ACCOUNT NAMES AND SECURITY IDS DONE |
|
IZ41766 |
2 |
DATE FORMAT OF MESSAGES ISSUED BY THE LOAD COMMAND IS ALWAYS MM/DD/YYYY. |
|
IZ36615 |
2 |
DB2START HANGS WHEN NOT SUPPORTED PASSWORD ALGORITHM IS SPECIFIED ON AIX 6.1 OR LATER |
|
LI73790 |
2 |
SP CONDITION HANDLER DOES NOT RETURN LOCK TIMEOUT(-911 RC=68) |
|
LI73948 |
2 |
DB2 TRY TO CHANGE THE MAPPEDBASE VARIABLE FOR LINUXIA32 BUT IT IS BROKEN IN V9.5. |
|
IZ33497 |
2 |
DB2 BACKUP CONTINUED TO WRITE TO FILE SYSTEM EVEN AFTER THE FILE SYSTEM IS FILLED UP. |
|
IZ40160 |
2 |
ERROR MESSAGE EXTRACTED BY STORED PROCEDURE IS NOT TRANSLATED TOSERVER'S LANGUAGE |
|
IZ41127 |
2 |
INSTANCE ABEND DUE TO CRASH IN FUNCTION SQLPRPUTQENTRYONQ FOR DB2REDOM EDU DURING CRASH OR ROLLFORWARD RECOVERY ON SOLARIS |
|
IZ48664 |
2 |
GROUP IDS GREATER THAN 2147483647 MAY NOT BE RECOGNIZED BY DB2. |
|
IZ33698 |
2 |
WHEN A USER BELONGS TO GROUP WITH MORE THAN 2000 MEMBERS, GROUP LOOKUP FAILS WITH SQL30082N, RC=26 ON CONNECTING TO DATABASE |
|
IZ38569 |
2 |
ALLIGN THE WRITES WHEN BLOCKSIZE IS GREATER THAN 2K BLOCKSIZE ONHP-UX USING VXFS 4.1 |
|
IZ33919 |
2 |
STMM CANNOT TUNE DATABASE MEMORY FOR MULTIPLE DATABASES ON DB2 VERSION 9.5 ON HP |
|
IZ26750 |
2 |
UNEXPECTED OUT OF MEMORY ERRORS UNDER STRESS WHEN ALL FREE "INSTANCE" MEMORY IS CACHED |
|
IZ39274 |
2 |
IBM NAS AND SOLARIS 10 UPDATE 4 DOES NOT COEXISTS WELL. |
|
LI73896 |
2 |
SIGNAL 11 IN SQLV_HEX2HEXCHARS |
|
IZ42067 |
2 |
WHEN NON-SUPPORTED CODESET SPECIFIED, DB2START ABENDS |
|
IZ39518 |
2 |
DB2 CRASH IN SQLO_VALIDATE_PWD DUE TO CORRUPT ENCRYPTED PASSWORDIN /ETC/SHADOW FILE |
|
IZ44926 |
3 |
POSSIBLE SEGMENTATION FAULT IN SQLOKERNELANALYZER OR SQLOINITCHCKPWD IF UNABLE TO ALLOCATE SMALL AMOUNT OF MEMORY |
|
IZ35818 |
3 |
DB2 SERVICEABILITY IMPROVEMENT: NEED A BETTER WAY TO VERIFY ULIMIT SETTINGS |
|
IZ38798 |
3 |
DB2PD -MEMSETS REPORTS WRONG SIZE FOR "APPCTL" MEMORY SET |
|
JR30753 |
3 |
DB2 CONFIGURATION ASSISTANT DISPLAYS FOUR DIALOG BOXES WHEN THE ROOT DRIVE IS INACCESSIBLE BY THE USER ON WINDOWS. |
|
JR31595 |
3 |
THE DB2DIAG.LOG WHICH SIZE WAS 138 MB,AND 3 STACK.BIN FILES WHICH WERE 1 GB TOTAL WERE CREATED DURING RUNNING INFORSPHERE INFO |
|
LI73900 |
3 |
INSTANCE HANG DUE TO FSTAT() FAILURE DURING FILE CLOSURE |
|
IZ28477 |
3 |
DB2 MAY HAVE TEMPORALY FILE LEFT OPEN IN THE SYSTEM. |
|
IZ39657 |
3 |
DID NOT HANDLE PRIVATE MESSAGE QUEUE WITH ID 0 PROPERLY DURING OPEN AND CLOSE. |
|
JR30952 |
3 |
EXTENDED SECURITY USED BY IBM DATA SERVER DRIVER WHERE IT SHOULDNOT |
|
IZ36532 |
3 |
DB2DASSEC TRAPS WHEN DAS TRACE IS ENABLED AND INVALID USERID/PASSWORD IS PROVIDED |
|
JR30607 |
3 |
DB2 9.5 ON WINDOWS CREATE DATABASE RESULTS IN DB2FMP64 PROCESS NOT KILLED AFTER DB2STOP AND SQL1042N WHEN RUNNING DB2START |
|
Connection Manager |
|
LI74136 |
2 |
DB2 CREATE DB STATEMENT REQUESTING A LATCH THAT IS ALREADY BEINGHELD. |
|
IZ38891 |
2 |
IN-DOUBT TRANSACTIONS MAY REMAIN ON DB2 SERVER AFTER THE SUCCESSFUL AUTOMATIC CLIENT REROUTE ON XA_PREPARE. |
|
JR31903 |
2 |
IFXBULKCOPY REPORTS SYNTAX ERROR WHEN EXECUTED WITHIN TRANSACTIONSCOPE |
|
Control Center |
|
JR30023 |
3 |
SQL -104 (SQL0104N) WHEN USING CONTROL CENTER CONNECTING TO EBCDIR DATABASE ON Z/OS WITH OBJECT NAMES IN UNICODE |
|
JR31851 |
3 |
EXPLAIN QUERY WINDOW DOESN'T APPEAR FOR DATABASE ON OTHER LOCAL INSTANCE CATALOGGED ON LOCAL NODE. |
|
JR31873 |
3 |
CONTROL CENTER HANGS INSTEAD OF DISPLAYING SQL1060 ERROR |
|
IZ39448 |
3 |
CLI0611E INVALID COLUMN NAME. SQLSTATE=S0022 WHEN CLICKING ON TABLESPACES TAB OF THE SHOW RELATED BOX IN DB2 CLIENT V9FP2 |
|
JR31185 |
4 |
DB2 CONTROL CENTER INCORRECTLY SHOWING AUTO-RESIZE AS NO FOR TABLESPACES WHICH ARE NOT LOCATED ON THE CO-ORDINATOR PARTITION |
|
DB2 Tools |
|
JR31448 |
2 |
NNSTAT FAILED WITH ERROR SQL1227N REASON CODE 3 |
|
IZ42723 |
2 |
REORGCHK_IX_STATS STORED PROCEDURE CALL MAY CAUSE SQL0100W ERROR |
|
JR30701 |
2 |
NNSTAT ERROR WITH SQL1227N, REASON CODE ='8' OR REASON CODE ='7'. |
|
IZ38749 |
2 |
DB2BACKUP API ALLOW TO USE THE EXISTING DATABASE CONNECTION, WITHOUT DROPPING IT. THIS IS NOT WORKING WITH LOOPACK DB |
|
IZ38753 |
2 |
WRONG OUPUT WITH LOAD USING ADMIN_CMD IN DPF ENVIRONMENT LOADINGINTO ONLY ONE PARTITION |
|
IZ42782 |
3 |
ATTEMPTING TO CONFIGURE ALERT NOTIFICATION IN HEALTH CENTER GIVES POP UP MESSAGE WITH SQL30082N RC=3 (PASSWORD MISSING> |
|
IZ36583 |
3 |
EXECUTING LOAD COMMANDS FROM SYSPROC.ADMIN_CMD STORED PROCEDURE ON DPF SYSTEMS ORPHANS MESSAGES FILES IN SQLLIB/TMP |
|
IZ39476 |
3 |
THE CONFIGURATION ASSISTANT CREATES INCOMPATIBLE NODE ENTRY FOR OSTYPE OS390 |
|
JR29636 |
3 |
JAVA SPLASH WINDOW ON LAUNCH OF THE CONFIGURATION ASSISTANT BY NON-ADMIN USERID |
|
DRDA Services |
|
IZ37697 |
1 |
SECURITY: MALICIOUS CONNECT DATA STREAM CAN CAUSE DENIAL OF SERVICE. |
|
IZ38874 |
1 |
DB2 CAN CRASH WHEN THIRD-PARTY DRDA CLIENT CONNECTS TO DB2 AND USES IPV6 ADDRESS FORMAT OF THE CORRELATION TOKEN |
|
IZ39653 |
1 |
SECURITY: MALICOUS DATA STREAM CAN CAUSE THE DB2 SERVER TO TRAP. |
|
IZ42432 |
2 |
PROCESS LEVEL WORK LOAD BALANCING |
|
IZ40115 |
2 |
DATA STUDIO REPORTS UNREALISTICALLY HIGH ELAPSED SERVER TIMES FOR SMALL QUERIES |
|
LI73727 |
2 |
DDCSPKGN DUMPS CORE ON LITTLE ENDIAN MACHINES LIKE INTEL/LINUX |
|
IZ42038 |
2 |
PUTD1003.TST HANGS IN LINUXIA32 AND AIX64 DOWN LEVEL TESTING |
|
IZ38848 |
2 |
V91FP7: ADD SUPPORT FOR SPECIAL REGISTER CLIENT_PROGRAMID WHEN CONNECTING TO DB2 I/OS V6.1 |
|
IZ39794 |
3 |
SQLCODE -30020 ON SWITCH USER TRUSTED CONTEXT SWITCHING AFTER COMMUNICATION ERROR. |
|
LI74191 |
4 |
CONNECTION CONCENTRATOR AND PING HOSTS THEN CONNECT TO DATABASE RESULTS IN SQLJSROLLBACKBEFORECONNECTRESET ERROR IN DB2DIAG.LOG |
|
Data Management Services |
|
IZ41199 |
2 |
SORT OPERATION MAY FAIL WHEN VARGRAPHIC WITH TRAILING BLANKS IN UCA DB WITH DB2_COMPATIBILITY_VECTOR ENABLED. |
|
LI73809 |
2 |
REORG ON TABLE FAILED WITH SQL2216 AFTER ALTER TABLE ON COLUMN ENDED WITH SQL0668N ERROR RC=7 |
|
IZ40933 |
2 |
CONCURRENT OPERATIONS USING SORT INFRASTRUCTURE THAT SPILL TO TEMP TABLES MAY FAIL WITH -901 WHILE MANIPULATING .SRT FILE. |
|
IZ40475 |
2 |
SORT MAY CRASH DUE TO INTEGER DIVIDE BY ZERO FAULT IN RARE TIMING SCENARIO WHEN INTRA_PARALLEL ON. |
|
IZ42466 |
2 |
INSERT INTO MDC TABLE CAUSES INSTANCE SUSPENSION WITH SIGNAL 31 AT FUNCTION SQLISCHA() |
|
IZ35044 |
2 |
INSPECT ROWCOMPESTIMATE MIGHT TRAP WHEN INSERTING A DICTIONARY |
|
IZ42644 |
3 |
SNAPSHOT MONITOR TOTAL_SORT_TIME OUTPUT MAY BE INCORRECT IN VMWARE ENVIRONMENTS. |
|
IZ39498 |
3 |
THE FUNCTION SQLDGETTABLEDATA IN THE DB2DIAG.LOG FILE DOESN'T IDENTIFY THE TABLESPACE AND TABLE ID OF THE TABLE. |
|
Data Protection Services |
|
IZ40430 |
2 |
THE ROLLFORWARD ERROR MESSAGE REPORTS AN INCORRECT LOG NUMBER WHEN ARCHIVED LOG FILES ARE MISSING |
|
IZ40305 |
2 |
LATCH CONTENTION ON LOG WRITER LATCH CAN OCCUR UNDER HIGH LOGGING ACTIVITY |
|
IZ29913 |
2 |
SQL2656N RETURNED WHEN RUNNING CAPTURE AFTER MIGRATING DATABASE TO VERSION 9.5 |
|
IZ36942 |
2 |
LOG RECORDS WITH A CORRUPT BACKPOINTER LSN VALUE ARE WRITTEN OUTTO DISK, LEADING TO CRASH RECOVERY FAILURE. |
|
IZ42842 |
2 |
TRANSACTION MANAGER DATABASE FOR DISTRIBUTED TRANSACTIONS FAILS TO RESOLVE INDOUBT TRANSACTIONS AFTER CRASH RECOVERY |
|
LI74070 |
2 |
DB2TAPEMGR TERMINATES WITH SEGMENTATION VIOLATION |
|
IZ20269 |
2 |
SIGSEGV IN SQLPM_WRITE_LOCKS. |
|
JR28024 |
3 |
CAPTURE ADDITIONAL DIAGNOSTIC INFORMATION TO ASSIST IN ROOT CAUSE ANALYSIS OF TRAP. |
|
IZ38921 |
3 |
SQL4970N ERROR: LOGARCHMETH2 IS NOT CONSIDERED IF LOGARCHMETH1 FAILS DURING RECOVERY'S ROLLFORWARD |
|
IZ15524 |
3 |
RESTORE FAILS IF VENDOR LIBRARY CANNOT BE INITIALIZED, DESPITE USING BACKUP IMAGE AND LOG FILES PREVIOUSLY EXTRACTED TO DISK |
|
JR32960 |
3 |
CAPTURE ADDITIONAL DIAGNOSTIC INFORMATION TO ASSIST IN ROOT CAUSE ANALYSIS OF TRAP. |
|
IZ25621 |
3 |
STANDBY FAILS DURING REMOTE CATCHUP PHASE WITH AN ERROR "HADR STANDBY FOUND BAD LOG". |
|
IZ48006 |
3 |
RECOVER COMMAND DOES NOT RESPECT THE ON ALL DBPARTITIONNUMS CLAUSE. |
|
IZ42982 |
3 |
ROLL FORWARD RECOVERY HANGS AFTER BACKWARD RECOVERY PHASE IS COMPLETE |
|
IZ33119 |
3 |
DB2 V9.5 USING USEREXIT MAY REPORT MISLEADING MESSAGE DIA8023C IN DB2DIAG.LOG |
|
IZ30809 |
3 |
AFTER UPDATING NEWLOGPATH AND BOUNCING THE INSTANCE, DB2DIAG.LOGMESSAGE POINTS TO OLD LOGPATH TO DELETE FILE. |
|
IZ30392 |
3 |
ROLLFORWARD RECOVERY ABENDS OR CAUSES INDEX OR DATA CORRUPTION. |
|
LI73482 |
3 |
HADR PRIMARY AND STANDBY DATABASE SYNCHRONIZATION PERFORMANCE ISSUES. |
|
IZ32439 |
3 |
DB2PD -LOCKS SHOWS "INVALID LOCKOBJ" IF THE LOCKOBJ TYPE IS 87. |
|
IZ26817 |
3 |
RESTORE FAILS WITH SQL0956C OUT OF MEMORY ERRORS IN DBHEAP ON SOME PLATFORMS |
|
IZ16831 |
3 |
PIT OF ROLLFORWARD DATABASE COMMAND DOES NOT SHOW UP IN DB2DIAG.LOG |
|
IZ42979 |
3 |
STMM IS INCORRECTLY BEING SHOWN AS THE TRANSACTION THAT IS HOLDING UP THE LOGS |
|
Development Infrastructure |
|
IZ41181 |
1 |
DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.53.95/4.3.111 FOR DB2 LUW V9.5 FIXPACK 4. |
|
IZ42824 |
2 |
SQL16074N : LENGTH EXCEEDS THE OPERATION OR FUNCTION LIMIT OF "32000" BYTES |
|
IZ38623 |
2 |
INSTALLATION OF UNIXODBC FAILS WITH DB2O.O ON AIX GIVING ERROR LIBDB2.EXP : FILE NOT FOUND |
|
IZ35480 |
3 |
DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.53.82/4.3.97 FOR DATA STUDIO 2.1 |
|
Documentation and Information Center |
|
IZ42597 |
3 |
NAMESPACE REFERENCES REMOVED FROM XML .NET SAMPLES |
|
IZ44805 |
3 |
THE DB2 SAMPLE STORED PROCEDURE BONUS_INCREASE YEILDS INCORRECT DATA OUTPUT |
|
Engine Infrastructure |
|
IZ42997 |
1 |
DB2 INSTANCE PANIC DUE TO MEMORY CORRUPTION IN QP VIA SQLESENDDSSQPREQUEST |
|
LI73912 |
1 |
SEGMENTATION FAULT AND DOUBLE FREE ERROR POSSIBLE IN OUT OF MEMORY CONDITION. |
|
IZ37513 |
2 |
TRAP CAUSED BY NODE FAILURE WHILE IN CREATEAPPL AND FAILING IN THE CALL TO GETCOMMSESSION |
|
IZ32772 |
2 |
THE DB2STMM AND DB2TASKD DO NOT START AFTER TAKEOVER HADR IF STANDBY WAS ACTIVATED BEFORE TAKEOVER. |
|
IZ33225 |
2 |
DB2CKMIG SHOULD CATCH ANY ORPHAN ROWS IN SYSIBM.SYSDEPENDENCIES |
|
LI73829 |
2 |
ADDING A NEW PARTITION TO A MULTI-PARTITIONED DATABASE FAILS WITH -1031 IF THE DATABASE DIRECTORY CONTAINS SYMBOLIC LINKS |
|
IZ41879 |
2 |
INSTANCE_MEMORY RESERVATION IS EXCESSIVE WITH A LARGE NUMBER OF PARTITIONS AND/OR HIGH MAX_COORDAGENTS/MAX_CONNECTIONS |
|
IZ42539 |
2 |
DB2EVMGI PROCESS CONSUMES LOTS OF CPU CYCLES, WITH NO REAL WORK DONE. |
|
IZ44894 |
2 |
TIMING ISSUE CAN CAUSE ABEND DURING DATABASE DEACTIVATION |
|
IZ39692 |
3 |
INVALID USER-SPECIFIED CODESET/TERRITORY IN CREATE DB COMMAND RETURNS "0" FOR TOKEN VALUES INSTEAD OF VALUES FROM USER |
|
IZ36972 |
3 |
ACTIVATION OF DATABASE WITH 20% OVERFLOW MAY UNNECESSARILY FAIL DUE TO HITTING INSTANCE_MEMORY LIMIT |
|
Engine Utilities |
|
LI73881 |
1 |
RESTORE FROM BACKUP SLOW AT V9.5 COMPARED TO V8 |
|
IZ34438 |
1 |
LOAD AGAINST A DATA-PARTITIONED TABLE WITH INCONSISTENT LARGE_RID ATTRIBUTES CAN CAUSE CORRUPTION. |
|
IZ38859 |
2 |
DB2 INSTANCE CRASHES WITH SIGNAL 11 DURING LOAD COMMAND WHILE REJECTING A ROW. |
|
IZ41200 |
2 |
CONFIGURATION ADVISOR SETTINGS DURING CREATE DB MAY CAUSE CONNECTIONS TO RETURN SQL1489W |
|
JR31525 |
2 |
THE GET_DB_CONFIG() UDF FAILS WITH SQL5066W WHEN STMTHEAP CONFIGURATION PARAMETER IS GREATER THAN 65535 PAGES |
|
IZ38855 |
2 |
SENDING SIGNAL TO DB2SYSC MAY CAUSE CURRENT RUNNING JOB BEING INTERRUPTED |
|
JR30901 |
2 |
DB2 EXPORT SESSION JUST HANGS IF DESTINATION FILE SYSTEM IS FULL. |
|
LI73878 |
2 |
LOAD UTILITY MAY HANG WHEN USING THE INSERT OPTION ON A TABLE USING ROW COMPRESSION. |
|
IZ38382 |
2 |
GET DATABASE CONFIGURATION ... SHOW DETAIL AND DB2PD ... -DBCFG MIGHT DISPLAY INCORRECT CURRENT VALUE FOR LOGSECOND AND LOGFILSZ |
|
LI73872 |
2 |
PERFORMING A REDISTRIBUTE, BACKUP AND THEN ANOTHER REDISTRIBUTE WITHOUT DB2STOP,CAUSES REDISTRIBUTE FAIL WITH -1224 |
|
IZ32894 |
2 |
PERFORMANCE IMPROVEMENT TO EXPORT OPERATIONS THAT WRITE TO SEPARATE LOB FILES |
|
IZ37708 |
2 |
INSTANCE CRASHS ON PRIMARY AND STANDBY WITH HADR, SQLOCRASHONCRITICALMEMORYVALIDATIONFAILURE. |
|
IZ38325 |
2 |
WHEN USING FILEMODTYPE DATETYPE="YYYYDDD" WITH LOAD OR IMPORT, THE 29 FEB ON A LEAP YEAR IS INCORRECTLY CONVERTED TO 1ST MAR |
|
IZ34980 |
2 |
TRAP OCCURS WHEN DB2 IS TERMINATED WHILE LOAD UTILITY IS RUNNING |
|
IZ27991 |
2 |
GET DB CFG FOR <DB ALIAS> OR DB2PD -DB <DB ALIAS> -DBCFG MIGHT NOT SHOW THE CORRECT 'CURRENT' VALUE FOR LOGPRIMARY. |
|
JR32802 |
2 |
ANY CUSTOMERS WHOM HAVE A TSM PASSWORD PARAMETER SET IN A V9.5 IMAGE CANNOT MIGRATE TO COBRA. |
|
IZ34916 |
2 |
DB2 AUTOMATIC TABLE MAINTAINANCE MAY SKIP TABLES FOR AUTO_REORG EVALUATION |
|
LI73761 |
2 |
DB2 CONNECT CANNOT BE DEPLOYED FROM A NETWORK PATH |
|
IZ37474 |
2 |
LOAD JOBS HANG DB2DIAG.LOG HAS MESSAGE CONTAINS MESSAGE : FAILEDTO READ LQ INFO , 0, 0, DETECTED IN FILE:SQLUSREADFILESA.C |
|
JR31469 |
2 |
IMPORT FROM DB2 UDB CLIENT TO DB2 ON VM FAILS WITH SQL0525N |
|
IZ42698 |
2 |
REDISTRIBUTE HANGS IF TABLE EVENT MONITOR RUNNING, AND MONITOR TABLE IS IN TABLE SPACE WHICH IS REDISTRIBUTED |
|
JR31529 |
2 |
INSTANCE ABEND WHEN SYSIBMADM.DBCFG ADMINISTRATIVE VIEW FAILS TOALLOCATE ENOUGH MEMORY. |
|
LI73774 |
2 |
LOAD INTO RANGE PARTITIONED TABLE WITH UNIQUE INDEX AND COPY YESMAY SEG-FAULT IF DISK_FULL OCCURS. |
|
IZ41104 |
2 |
ASSERT MAY FAIL DURRING REDISTRIBUTE RECOVERY CODE PATH. |
|
IZ40342 |
2 |
ALLOW DB2 IMPORT AND EXPORT TO OPEN THE SAME PIPE ON UNIX AND LINUX PLATFORMS |
|
IZ42839 |
2 |
SECURE SOCKET LAYER (SSL) PROTOCOL SUPPORT ADDED IN DB2 CLIENTS APARNOPUB |
|
IZ41864 |
3 |
SEVERITY OF SOME DB2DIAG.LOG REDISTRIBUTE ERROR MESSAGES ARE NOTCORRECT. |
|
LI73848 |
3 |
CLIENT LOAD WITH INCORRECT LOAD FILE NAME OR PATH CAUSES SQL0980AND DUMPS 3 FILES TO DIAGPATH. |
|
IZ35058 |
3 |
SQL1704N RC=5 RECEIVED WHEN MIGRATING TO V9.5 ON LINUX AND UNIX DUE TO CHANGES TO MAXFILOP LIMITS |
|
IZ09128 |
3 |
CONFIGURATION MINIMUM FOR FCM_NUM_BUFFERS NO LONGER VALID |
|
IZ38960 |
3 |
LOAD FROM CURSOR WITH DATABASE CLAUSE FAILS WITH -1469 IF THE REMOTE DATABASES DB2NODES.CFG IS DEFINED DIFFERENTLY THEN LOCAL. |
|
IZ17010 |
3 |
POSSIBLE HANG SITUATION DUE TO CONCURRENT EXECUTION OF LOAD AND REORG. |
|
IZ31236 |
3 |
LOAD OPERATION FAILS WITH SQL3508N RC=6 AFTER INTERRUPTING PREVIOUS LOAD. |
|
IZ37084 |
3 |
LOAD DOES NOT AUTOBIND FROM THE CORRECT DIRECTORY. |
|
IZ39921 |
3 |
UDF SYSPROC.ADMIN_LIST_HIST MAY DEADLOCK CAUSING HANG. |
|
LI74122 |
3 |
THE LOAD FROM CURSOR MAY FAIL WITH SQLCODE -901 WHEN TARGET COLUMN SIZE ISN'T BIG ENOUGH TO STORE CODEPAGE CONVERSION RESULT |
|
IZ38815 |
3 |
TRAP OCCURS WHEN DB2 IS TERMINATED WHILE LOAD UTILITY IS RUNNING |
|
LI73262 |
3 |
DB2MED PROCESS DOES NOT GENERATE CORE FILE DURING COREDUMP |
|
IZ26500 |
4 |
CORRECT THE VALUE OF CATALOGCACHE_SZ FROM MAXAPPLS*4 TO MAXAPPLS*5 |
|
Federation |
|
JR31587 |
1 |
430N ERROR(FMP PROCESS DOWN) OR DB2 PROCESS DOWN WHEN DOING SOME DROP OPERATIONS USING SYBASE WRAPPER IN V95FP3 |
|
JR31224 |
2 |
ERROR "COULD NOT LOCATE STATISTICS ..." AND "DBCC EXECUTION COMPLETED..." IN DB2DIAG.LOG WHEN CREATING NICKNAME. |
|
JR32249 |
2 |
FED: MEMORY CORRUPTION FROM SQLQGCLOSE, CALLER SQLRICJPINFREQUENT |
|
JR32190 |
2 |
ADD DATAOURCE SERVER VERSION 6.1 FOR DB2/400 SUPPORT ON DRDA WRAPPER |
|
JR32244 |
2 |
SQL0902 FROM SQLRL_DGTT_RCV ON FEDERATED RUN |
|
JR30892 |
2 |
INCORRECT VARCHAR LENGTH FOR INFORMIX NICKNAME WITH VARCHAR(M, R) COLUMN |
|
JR32250 |
2 |
FED: -902 STORED PROC NOT FOUND CASUED BY SQLRIFEDINVOKERTRUSTED |
|
IZ32538 |
2 |
WEB SERVICE WRAPPER SOAPACTION, SOAPACTIONCOLUM, URL AND URLCOLUMN INCORRECT |
|
IZ39267 |
2 |
PANIC AFTER FEDERATION DB2FMP KILLED. "UNLOCKING AN UNLATCHED LOCK" IN DB2DIAG.LOG. |
|
IZ29894 |
2 |
CRASH DUE TO A SIGSEGV IN UNFENCEDSERVER(DT) |
|
JR30975 |
2 |
MICROSOFT SQL SERVER MAY CAUSE DB2 CRASH. |
|
JR31301 |
2 |
ENGINE CRASHES WHEN DURING 'REMOTE CONNECTION LOST' CONDITION WHILE RUNNING CONCURRENT QUERIES |
|
JR32199 |
2 |
NET8 WRAPPER FAILED TO HANDLE THE INSERT OPERATION AFTER DATABASE CONNECTION |
|
JR31585 |
2 |
CREATE NICKNAME ERROR WHEN CREATING NICKNAME BY USING MICROSOFT ODBC DRIVER WITHOUT VALID CARD AND NPAGES VALUE |
|
JR32655 |
2 |
SQL0901N REPORTED WHEN QUERYING FROM NICKNAME WITH HEAD EXPRESSION LIKE COALESCE(CHAR,TIME) USING MSSQLSERVER WRAPPER |
|
JR31418 |
2 |
ENGINE CRASH IN SQLQGCLOSE WHEN POINTER IS CORRUPTED IN FENCED MODE. |
|
IZ40659 |
2 |
EXCESSIVE SUDDEN MEMORY ALLOCATION IN FEDERATED HEALTH MONITOR/DB2ACD MAY CAUSE PAGING OR HANG SYSTEM |
|
JR30698 |
3 |
NNSTAT AGAINST ORACLE WRAPPER FAILED WITH BAD TIMESTAMP FROM ORACLE. |
|
JR31096 |
3 |
FAILED WHEN CREATING TRANSPARENT TABLE WITH MORE THAN ONE VARCHAR FOR BIT COLUMN AGAINST ODBC WRAPPER |
|
JR31182 |
3 |
ODBC WRAPPER ERROR : PROTOCOL ERROR CAUSING DEALLOCATION OF CONVERSATION - DISCONNECT EXCEPTION - DB DAMAGED SQL1034N |
|
JR32226 |
3 |
OVERFLOW ERROR ISN'T REPORTED AS EXPECTED WHEN CONVERTING LOCAL LARGE TYPE VALUE TO REMOTE SMALL TYPE. |
|
JR32246 |
3 |
FED:V91FP5/ SPRS1FED / 5 TESTCASES FAILED AGAINST SYBASE125 ON NT32 |
|
JR31000 |
3 |
DB2 MAY CRASH WHEN THE ODBC DRIVER MANAGER TRIES TO REPORT AN ERROR/WARNING REPEATEDLY |
|
JR32201 |
3 |
ADD TERADATA V12 TOLERANCE SUPPORT IN TERADATA WRAPPER IN DB2 V95 FIXPACK4 |
|
High Availability |
|
IZ31839 |
2 |
THE CHECK FOR THE REDOENDLSN GIVES A FALSE ALARM CAUSING THE SECONDARY SERVER IN HADR TO FAIL. |
|
IZ37718 |
2 |
IN INTEGRATED HA ENVIRONMENT, HADR STATE MAY BE RETURNED INCORRECTLY WHEN MULTIPLE DATABASE PAIRS ARE USED |
|
LI73874 |
2 |
HADR PRIMARY CRASH TRIGGERED BY DISCONNECTION FOLLOWED BY CONNECTION QUICKLY. |
|
IZ22454 |
3 |
SUN CLUSTER SCSWITCH COMMAND ON HADR DATABASE FAILS |
|
IZ42147 |
3 |
REMOVE DEPENDENCY FAILED DURING MAINTENANCE MOVE USING DB2HAICU |
|
IZ42417 |
3 |
MISLEADING MESSAGE IN DB2DIAG.LOG OPENING DB2HA.SYS WHEN NOT USING TSA |
|
IZ40539 |
3 |
MOUNT SCRIPT NEEDS VARYONVG -B OPTION FOR AIX WHEN VARYONVG FAILS |
|
IZ39730 |
3 |
HADR STANDBY DB CRASHES AFTER PRIMARY-REINTEGRATION WITH A LOG FILE SIZE CHANGE - "STARTING LSN > ENDING LSN" |
|
IZ42623 |
3 |
DB2HAICU: XML INPUT: SUPPORT OF THE FAILOVER PREFERENCE LIST IN THE XML INPUT FILE |
|
IZ35634 |
3 |
INTERMITTENT HADR STANDBY DISCONNECTPEER AFTER FAILOVER |
|
IZ33770 |
3 |
ON STANDBY DATABASE, "THIS OPERATION IS NOT ALLOWED ON A STANDBYDATABASE" MESSAGE APPEARS AS SEVERE MESSAGE. |
|
Index Manager |
|
IZ37191 |
1 |
AUTOMATIC STATISTICS COLLECTION MAY SOMETIMES SLOW DOWN TRANSACTION PROCESSING |
|
IZ39538 |
2 |
SPLIT OF COMMITTED PSEUDO EMPTY INDEX PAGE MAY RESULT IN INDEX CORRUPTION |
|
IZ31724 |
2 |
HADR STANDBY FAILED TO START WITH ERROR SQLD_PRGERR |
|
IZ39367 |
2 |
INDEX ERROR DURING ONLINE TABLE REORG MAY RETURN INCOMPLETE RESULT |
|
IZ30026 |
2 |
"ROW NOT FOUND ON DATA FETCH FROM INDEX" RETURNED FROM INDEX SCAN ON A RANGE PARTITIONED TABLE |
|
Install |
|
IZ42989 |
1 |
INSTALLFIXPACK SCRIPT WILL APPEAR TO HANG WHEN RUN BY NON-ROOT USER. |
|
IZ35846 |
2 |
UNINSTALL OF DEFAULT DB2 COPY PROMPTS FOR SWITCHING THE DEFAULT COPY IF V9.5 DB2 MERGE MODULES WAS ALSO INSTALLED |
|
JR30718 |
2 |
A RESPONSE FILE INSTALLATION OF DB2 RUNTIME CLIENT DOES NOT REGISTER THE ODBC DATA SOURCES CORRECTLY IN REGISTRY (ODBC.INI) |
|
IZ42423 |
2 |
FIXPACK UPGRADE INSTALL ON THE SECOND V9.5 DB2 CLIENT COPY DOES NOT WORK CORRECTLY |
|
JR31149 |
2 |
DB2CLI.INI FILE IS NOT MIGRATED FROM PRE-VERSION 95 TO VERSION 95. |
|
JR30631 |
2 |
NOT ABLE TO CREATE DSN FOR IBM DB2 ODBC DRIVER IN CASE OF "DB2 THIN CLIENT". |
|
JR29835 |
2 |
CLIENT_IMPORT_PROFILE PARAM OF RESPONSE FILE GENERATOR PROGRAM 'DB2RSPGN' DOES NOT TAKE THE COMPLETE PATH OF INSTALLATION |
|
IZ38934 |
2 |
DB2_EXTSECURITY=YES AFTER APPLYING V95 FP2A, EVEN IF WAS SET TO NO IN THE DB2 REGISTRY. |
|
JR31604 |
2 |
INSTALLING DB2 DATA SERVER RUNTIME CLIENT VIA MERGE MODULES FAILS WITH ERROR: A DB2 COPY DB2COPY ALREADY EXISTS |
|
IZ40021 |
3 |
DB2 SERVICE'S STARTUP TYPE WAS CHANGED FROM AUTOMATIC TO MANUAL AFTER AN ADD-ON DB2 PRODUCT IS INSTALLED |
|
JR30983 |
3 |
DB2RSPGN FOR DB2 RUNTIME CLIENT GENERATES INCORRECT COMPONENTS IN THE RESPONSE FILE. |
|
IZ33561 |
3 |
CUSTOMER IS UNABLE TO UNINSTALL DB2 V9.5 FROM SMS UNDER THE LOCALSYSTEM ACCOUNT |
|
IZ42306 |
3 |
FAIL TO LAUNCH DB2 INSTALLATION GUI IF THE WINDOWS' LOCALE IS NOT UNSUPPORTED BY DB2 |
|
JR29114 |
3 |
FIXPACK OVERRIDES EXTENDED SECURITY SETTINGS TO USE DEFAULT GROUPS, DB2ADMNS AND DB2USERS. |
|
IZ31983 |
3 |
DB2IUPDT: DB2ICKTS CALLED WITH INCORRECT ARGUMENTS |
|
JR31800 |
3 |
RTC UNINSTALL ON WINDOWS VISTA DOES NOT CORRECTLY UPDATE THE DB2ODBC WINDOWS REGISTRY ENTRIES, MAY LEAD TO HANG. |
|
JR30659 |
3 |
INSTALL_TYPE PARAM OF RESPONSE FILE GENERATOR PROGRAM 'DB2RSPGN' IS CUSTOM WILL RESULT IN ERROR DURING INSTALLATION |
|
JR30981 |
3 |
INSTALLING DB2 9.5 RUNTIME CLIENT USING A RESPONSE FILE FAILS IFA BACKSLASH "\" IS AT THE END OF THE PATH IN THE RESPONSE FILE |
|
JR30796 |
3 |
USING JAVA GUI INSTALLER, DB2SETUP, ON UNIX NON-ENGLISH LOCALE ENVIRONMENT, SOME MESSAGES IN DB2SETUP.LOG MAY BE GARBLED. |
|
JR31048 |
3 |
DBM CONFIG PARMS NOT BEING SET DURING RSP FILE INSTALL OF DB2 RUNTIME CLIENT V9.5 . |
|
JR30547 |
3 |
DB2IDROP IN V9.5 WINDOWS DOESN'T REMOVE THE PORT RANTE ENTRIES FROM THE SERVICES FILE. |
|
JR31300 |
3 |
BACKSLASH AT END OF RESPONSE FILE PATH CAUSES RUNTIME CLIENT INSTALLATION TO FAIL |
|
JR30984 |
3 |
INSTALLING DB2 9 OR 9.5 RUNTIME CLIENT USING A RESPONSE FILE FAILS IF A VALUE IS SPECIFIED FOR THE LANG KEYWORD |
|
Interpartition Communication |
|
IZ28350 |
3 |
CURRENT RESTRICTIONS ON THE SIZE OF THE FCM SHARED MEMORY SEGMENT WILL BE LIFTED FOR LINUX PLATFORMS |
|
JDBC |
|
IZ38292 |
1 |
S04E RC00E70005 DSNXGRDS. DSNXEPAR :M120 ON ZOS WHEN CURRENTFUNCTIONPATH SET TO VALUE CONTAINING ", CURRENT PATH" |
|
IZ39352 |
1 |
JCC DRIVER NOT CHAINING COMMIT ON CURSOR CLOSE |
|
JR31711 |
1 |
THE V9 JCC DRIVER FAILOVER FUNCTIONALITY IS NOT BACKWARDS COMPATIBLE WITH THE V8 JCC FUNCTIONALITY. |
|
IZ39737 |
2 |
INSERT OF VARGRAPHIC VALUES WITH TRAILING SPACES FAIL WHEN USINGV9 JCC T4 DRIVER |
|
IZ40382 |
2 |
UNIVERSAL JDBC DRIVER FAILS TO RESOLVE INDOUBT TRANSACTIONS WHENMORE THAN ONE MEMBER OF A DB2/Z DATASHARING GROUP IS AVAILABLE |
|
IZ43314 |
2 |
NULLPOINTEREXCEPTION MAY OCCUR USING BLOB,CLOB,DBCLOB,OR XML OUTPARAMTERS ON CALLABLESTATEMENT IF PROGRESSIVE STREAMING ENABLED. |
|
JR31309 |
2 |
CLIENT REROUTE WITH THE JCC DRIVER SHOULD BE SUPPORTED/ENABLED VIA SYSPLEX WORKLOAD BALANCING AGAINST DB2 FOR Z/OS. |
|
LI73765 |
2 |
IN THE THREAD DUMP, IT APPEARS LOT OF THREADS IS WAITING FOR A JAVA.UTIL.VECTOR, HOWEVER, IT DOES NOT SHOW IN THE DUMP |
|
IC58566 |
3 |
BATCHED STATIC SQL PACKAGES FAILING WITH -312 |
|
IZ36247 |
3 |
JCC NOT CLEANING LOGWRITERS IN CASE OF CONNECTION FAILURE |
|
IZ43769 |
3 |
JCC DRIVER PERFORMING SLOWLY WHEN FETCHING DECFLOAT DATATYPES. |
|
LI73949 |
3 |
JDBC API RESULTSET.GETSTRING() RETURNS DIFFERENT FORMATS FOR BIGDECIMAL NUMERIC VALUE BETWEEN JDK 1.4 AND JDK 1.5. |
|
Life Sciences Wrappers |
|
JR32291 |
1 |
QUERY WITH ERROR SQL1224N SQLSTATE=55032 FOR XML WRAPPER ON SUN64 PLATFORM |
|
JR31167 |
2 |
WEB SERVICE CONSUMER FUNCTION ERROR WITH SQL0443N AND DIAGNOSTIC TEXT "UNEXPECTED ERROR" |
|
Monitoring |
|
IZ32777 |
2 |
DB2 EVENT MONITOR FILE CORRUPTED, IF DEADLOCK OCCURED IN NON-CATALOG NODE. |
|
IZ29307 |
2 |
PERFORMANCE DEGRADATION POSSIBLE WHEN USING WLM_CAPTURE_ACTIVITY_IN_PROGRESSS AND WITH ACTIVITY EVENT MONITOR IS OVERLOADED. |
|
LI73880 |
2 |
UNCOMMITTED CREATE AND EVENT MONITOR START-UP MIGHT LEAD TO A DEADLOCK OR HANG. |
|
IZ31151 |
2 |
POOR TABLESPACE SNAPSHOT PERFORMANCE, DUE TO THE NUMBER OF TIMESTAMP CALLS. |
|
IZ24076 |
2 |
INCORRECT AGENT_ID ASSOCIATED WITH THE TABLE DURING SNAPSHOT_LOCK() INVOCATION. |
|
IZ37018 |
2 |
DB2EVMTI HANGS TRYING TO WRITE A DEADLOCK EVENT INTO THE TABLE |
|
LI73871 |
3 |
BUFFERPOOL XDA LOGICAL/PHYSICAL READS ARE WRONG IN APPLICATION SNAPSHOT FOR XML DATA. |
|
IZ42726 |
3 |
WLM CONCURRENT_ACT_TOP STATISTICS SHOWS N + 1 WHEN CONCURRENCY THRESHOLD IS SET TO N |
|
IZ32873 |
3 |
VERY HIGH VALUES OBSERVED FOR HOST RESPONSE TIME IN DCS APPLICATION SNAPSHOTS AFTER ANY SQLERROR. |
|
JR31509 |
3 |
AUTOMATIC SETTING FOR MON_HEAP_SZ WILL NOT INCREASE DB2.MON_HEAP_MAX_SIZE |
|
Performance |
|
IZ39869 |
2 |
UNABLE TO RUN DB2BATCH AGAINST AS400 HOST FROM DB2 CLIENT, FAILSWITH CLI0150E |
|
Problem Determination |
|
JR31838 |
1 |
DB2PD CAUSES INSTANCE TRAP ON WINDOWS |
|
LI73735 |
2 |
USING DB2TRC -PERFCOUNT -T FOLLOWED BY OTHER DB2TRC ON / OFF COMMANDS WILL CAUSE THE DB2 INSTANCE TO CRASH |
|
IZ41077 |
2 |
DB2PD ABORTS WITH "CHANGING DATA STRUCTURE" MESSAGES OR HANGS/LOOPS WHEN THERE ARE A LARGE NUMBER OF EDUS |
|
IZ14589 |
2 |
DSAC IS NOT ALERTED FOR THE DB NAME IS NOT INCLUDED IN THE LOG OF ADM1827E |
|
IZ34123 |
2 |
DB2PD -MEMBLOCKS PID OPTION DOES NOT WORK ON HP PLATFORM |
|
IZ33572 |
2 |
CALLING "DB2PD -DB <DB> -THRESHOLDS <ID>" TWICE CONSECUTIVELY RESULTS IN A HANG |
|
JR29990 |
3 |
USERS IN DB2USERS GROUP CANNOT COLLECT DB2SUPPORT.ZIP FILE ON WINDOWS |
|
IZ43320 |
3 |
MESSAGE DISPLAYED IN DB2SUPPORT FILES IS NOT PRECISE FOR ENVIRONMENT SETTING. |
|
LI74133 |
3 |
IN THE DB2SUPPORT OPTIMIZER TOOL '-RA | -REFRESHAGE' (-RA ANY) IS IGNORED. |
|
IZ39992 |
3 |
DB2DART /LHWM PROVIDES INCORRECT FIGURES FOR PREDICTED HIGH WATERMARK AFTER RUNNING A REORG OPERATION |
|
IZ41210 |
3 |
DB2DIAG COMMAND CAN FAIL TO DISPLAY ENTRIES THAT MATCH SEARCH PATTERN. |
|
IZ36036 |
3 |
DB2PD OUTPUT FOR DATABASE SCOPE IS EXCESSIVE DUE TO DETAILS ON BUFFERPOOL PAGES |
|
IZ33277 |
3 |
DB2COS SCRIPT IS CALLED MULTIPLE TIMES FOR A SAME DEADLOCK EVENT |
|
LI74143 |
3 |
DB2 BUILD LEVEL INFORMATION IN TRAP FILE IS NOT ALWAYS ACCURATE IN SPECIAL BUILD |
|
IZ32782 |
3 |
DB2PD WORKS ON SOALRIS 10 U2 BUT FAILS ON U4. IT RETURNS ERROR "USER MUST HAVE SYSADM AUTHORITY TO RUN DB2PD" |
|
LI73793 |
4 |
DB2PD -LOCKS SHOWS INVALID OBJ FOR TABLE PART |
|
Quality Assurance |
|
IZ42033 |
3 |
DB2EXPLN RETURNS "ERROR -- DB2EXDYN FAILURE (-3) BUT NO TEXT" |
|
Query Compiler, Rewrite, Optimizer |
|
IZ38627 |
1 |
CRASH DURING A MERGING/SORTED TABLEQUEUE OPERATION |
|
IZ38961 |
1 |
POSSIBLE INCORRECT RESULTS WHEN REWRITING NOT EXISTS SUBQUERY |
|
IZ40627 |
1 |
POSSIBLE UNEXPECTED RESULTS IN SQL STATEMENT CONTAINING OR PREDICATE(S) WITH IN SUBQUERIES. |
|
LI74193 |
1 |
QUERY CAN RETURN WRONG RESULT USING XMLTABLE |
|
IZ40984 |
1 |
INSTANCE ABEND DURING AUTO-RUNSTATS OR REAL TIME STATISTICS COLLECTION DUE TO DATA IS RE-DISTRIBUTED IN DPF SYSTEM. |
|
JR32112 |
1 |
INSTANCE MAY ABEND WHILE PREPARING A QUERY WITH DB2_WORKLOAD=SAPSET |
|
LI73865 |
1 |
UNEXPECTED RESULTS WHEN SELECTING FROM A VIEW WITH OUTER JOIN AFTER UPGRADE TO FP17 |
|
IZ50916 |
1 |
INCORRECT RESULTS POSSIBLE IN QUERIES THAT WERE BOUND WITH REOPTONCE AND INVOLVE LIKE PREDICATES |
|
JR31480 |
2 |
RANGE JOIN PREDICATES INVOLVING DATE OR TIMESTAMP ARITHMETIC FUNCTIONS ARE NOT CONSIDERED FOR PUSHDOWN THROUGH UNION |
|
LI73942 |
2 |
ERROR SQL0901N WITH REASON "THE ENTITY IS NOT PART OF THIS RELATIONSHIP" WHEN TRYING TO CREATE A STORED PROCEDURE. |
|
IZ42996 |
2 |
SELECT FROM A VIEW RETURN NO RESULT OR RETURN SQL0901N WITH REASON "CAN NOT FIND THE SYSTEM DEFINED TYPE" |
|
IZ35195 |
2 |
A QUERY CONTAINING A REDUNDANT SELF-JOIN THAT CAN BE REMOVED DUETO A REFERENTIAL INTEGRITY CONSTRAINT MAY CAUSE SQL901 |
|
LI73966 |
2 |
TO_DATE/TIMESTAMP_FORMAT SCALAR FUNCTION WITH GRAPHIC/VARGRAPHICFORMAT-STRING CAUSES INSTANCE TO TERMINATE ABNORMALLY |
|
IZ32786 |
2 |
DB2EXFMT TRUNCATES CONSTANTS TO 128 CHARACTERS |
|
IZ39040 |
2 |
PASSWORD PROMPT LIMITED TO 8 CHARACTERS ON HP-UX |
|
IZ40721 |
2 |
LIKE PREDICATE MAY PRODUCE INCORRECT RESULTS IN VARCHAR2 COMPATIBILITY MODE. |
|
LI73839 |
2 |
DB2 INSTANCE MAY GENERATE SQL0901 WHILE RUNNING A QUERY CONTAIN ING A TABLE/TEXT SCALAR FUNCTION CORRELATED TO TABLES IN UNION. |
|
IZ13899 |
2 |
POOR QUERY PERFORMANCE FOR QUERIES HAVING OUTER JOINS WITH COMPLEX NULL PRODUCING OPERANDS |
|
IZ40479 |
2 |
INCORRECT ESTIMATED RETURNED ROWS ON TBSCAN OPERATOR WHEN UNNEST FUNCTION IS USED |
|
IZ16822 |
2 |
MQT FAILS TO BE MATCHED WHEN 2 OR MORE EQUALITY PREDICATES EXISTWITH THE SAME LITERAL |
|
IZ42926 |
2 |
THE DB2 SERVER TERMINATES ABNORMALLY WHEN CERTAIN KEYWORDS ARE USED AS THE TARGET OF AN UPDATE SET CLAUSE |
|
JR30988 |
2 |
ALTER SEQUENCE STATEMENT CAUSES MEMORY LEAK IN APPLICATION HEAP |
|
IZ35748 |
2 |
REMOVE DUPLICATE CONSTANT VALUES IN AN IN PREDICATE |
|
IZ32325 |
2 |
FAILURE TO ALLOCATE STMTHEAP MAY CAUSE INSTANCE TO CRASH. |
|
IZ26103 |
2 |
PERFORMANCE ENHANCEMENT FOR INSERT STATEMENT INTO UNION ALL VIEW |
|
IZ29808 |
2 |
EXPLAINING A SQL STATEMENT RESULTS IN DB2 SERVER ABEND |
|
IZ39544 |
2 |
INVALID DATA TYPE SIZE MAY CAUSE DB2 SERVER TO TERMINATE ABNORMALLY |
|
JR31883 |
2 |
A QUERY MAY RETURN INCORRECT RESULTS WHEN ITS OUTER JOIN OPERATOR IS EXPECTED TO OUTPUT AT MOST ONE ROW. |
|
IZ35201 |
2 |
REDUNDANT OUTER JOIN CORRELATION PREDICATE IS GENERATED |
|
IZ39966 |
2 |
LOOP IN SQLDSTATSAMPLINGINVCARDENAS WHEN RUNSTATS WITH TABLESAMPLE OPTION. |
|
JR31074 |
2 |
A SQL USING UDF WITH CORRELATION AND UNION ALL VIEW CAN ABEND DB |
|
IZ36479 |
2 |
PERFORMANCE PROBLEM IN HASH JOIN THAT RESULTS IN A LONG RUNNING QUERY THAT CANNOT BE INTERRUPTED. |
|
IZ33027 |
2 |
DB2 INSTANCE MAY ABEND DUE TO STACK OVERFLOW (INSTEAD OF DUMPING SQL0973N) WHILE PROCESSING A VERY LARGE PREDICATE |
|
IZ40974 |
2 |
FEDERATION SERVER MAY DUMP WHEN RECEIVE A LONG SQL WITH LOTS OF 'OR' |
|
IZ16959 |
2 |
OPTIMIZER NOT CHOOSING CORRECT INDEX DURING REFERENTIAL INTEGRITY CHECKING |
|
IZ37641 |
2 |
QUERY HAVING A JOIN OVER A RANGE PARTITION TABLE MAY GET INCORRECT RESULT. |
|
LI73927 |
2 |
DB2 INSTANCE MAY ABEND EXECUTING A QUERY CONTAINING A PREDICATE ON MAX/MIN APPLIED ON A CASE EXPRESSION WITH 1 OR MORE GROUP BY |
|
IZ35826 |
2 |
THE QUERY WITH XMLEXISTS PASSING XML COLUMN DEFINED IN XMLTABLE MIGHT RETURN SQL0901N INCORRECT OUTPUT. |
|
JR32320 |
2 |
A SQL QUERY INVOLVING SUBQUERIES CAN RETURN A SQL0901N ERROR. |
|
IZ33731 |
2 |
SUBSELECTS WITH VALUES CLAUSE, CONTAINING HOST VARIABLES AND GROUP BY ARE NOT CONSIDERED BY APAR IY81899 |
|
IZ36539 |
2 |
PUSH DOWN GROUP-BY SUBQUERY THROUGH OUTER JOIN |
|
IZ43316 |
2 |
INCORRECT RESULTS ON USING THE "NOT LIKE" PREDICATE ON A DATABASE CREATED WITH THE UCA500R1 COLLATION KEYWORD |
|
IZ40921 |
2 |
INTERNAL ERROR SQL0901 FROM AN INCORRECT CORRELATION CAUSED BY AN OPTIMIZATION OF SCALAR SUBQUERY |
|
JR31183 |
2 |
DB2 SERVER MAY ABEND DURING COMPILATION OF SQL STATEMENT CONTAINING CERTAIN PREDICATES WHEN AUTO_STMT_STATS IS ENABLED |
|
IZ38397 |
2 |
THE CARDINALITY COULD BE UNDERESTIMATED WHEN A CONTEXT ITEM IS USED UNDER A ROOT NODE |
|
IZ42860 |
2 |
INCORRECT RESULT MAY BE RETURNED IF QUERY HAS COMPLEX PREDICATESFOR PARTITIONED TABLE AND IS INVOKED MULTIPLE TIMES IN SQL PL. |
|
IZ08780 |
2 |
CONSIDER SEMI JOIN FOR OUTER JOIN OPERATIONS WITH GROUP BY OR OLAP AGGREGATION |
|
LI74175 |
2 |
ENABLE ORDERED COLUMN GROUP OR PREDICATE TO BE USED INDEX KEYS |
|
IZ42682 |
2 |
IN LIST PREDICATES WITH PARAMETER MARKERS AND/OR HOST VARIABLES ARE NOT BEING EXECUTING AS JOINS SO MAY IMPROVE PERFORMANCE |
|
IZ35881 |
2 |
IGNORE STATISTICS COLLECTED ON TABLES MARKED AS VOLATILE WHEN DB2_WORKLOAD=SAP IS ENABLED |
|
JR31534 |
3 |
DB2 MAY ISSUE AN SQL0901N WHEN EXECUTING A NON-ATOMIC SCALAR SQLUDF WITH A GLOBAL VARIABLE. |
|
IZ38430 |
3 |
DB2XML-CE: WRONG DEDUPE BEHAVIOR CAUSED BY RNOOPEXT AND XPMERGE |
|
JR31464 |
3 |
FED: LIKE PREDICATE IN FEDERATED STATEMENTS NOT PUSH DOWN WHEN DATABASE IS UNICODE |
|
IZ36957 |
3 |
RUNSTAT OPTIONS OF SET PROFILE ONLY AND UPDATE PROFILE ONLY FOR STATISTICAL VIEWS READS DATA AND MAKES STATISTICAL COMPUTATIONS |
|
IZ50206 |
3 |
EXP0045W WARNING AFTER PROPER RUNSTATS ON TABLE. |
|
IZ35200 |
3 |
QUERIES CONTAINING UNION MIGHT RESULT IN A LARGE NUMBER OF CONCURRENT SORTHEAP USAGES IN A DPF ENVIRONMENT. |
|
IZ37236 |
3 |
XQUERY MIGHT NOT PICK ANY INDEX WHEN ONE PREDICATE HAS $SOMEEXTRACTION/SOMEFUNCTION(). |
|
IZ45221 |
3 |
UNDER CERTAIN CONDITIONS, WHEN OR PREDICATES ARE APPLIED AGAINSTA TABLE'S MDC COLUMN(S), THE PERFORMANCE MAY BE SLOW. |
|
IZ31838 |
3 |
QUERY REWRITE TO PERFORM SUBQUERY PREDICATE PUSHDOWN ON OUTER |
|
IZ20537 |
3 |
IMPROVE QUERY REWRITE RULE TO AVOID EXHAUSTION OF RUNSTACK FOR OPTIMIZER RECURSIVE ROUTINES. |
|
IZ34150 |
3 |
QUERY PERFORMANCE DEGRADATION AFTER MIGRATING FROM V7.2 TO V8.2 DUE TO JOIN DATA SKEW. |
|
IZ39546 |
3 |
IN DPF ENVIRONMENT, WHEN INTERSECT ON NON COMPATIBLE COLUMNS, ITWILL CAST TO BIGINT |
|
IZ35515 |
3 |
SQL0551N ERROR WHEN STARTING QUERY PATROLLER. |
|
JR30820 |
3 |
DB2 INSTANCE MAY ABEND WITH A QUERY CONTAINING TAUTOLOGY PREDICATES ORED WITH CORRELATED EXISTENTIAL |
|
IZ40823 |
3 |
QUERY PERFORMANCE MAY BE POOR WHEN QUERY CONTAINS A SUB-SELECT WITH CORRELATED COLUMN REFERENCES |
|
IZ40747 |
3 |
INSERTING DATA THROUGH INSTEAD OF TRIGGER IN A NULLABLE COLUMN CREATES PROBLEM |
|
JR30986 |
3 |
TO_DATE CALL WHEN ISSUED WITH A PARAMETER MARKER CAUSES SQL0418N |
|
IZ44798 |
3 |
"CREATE TABLE LIKE NICKNAME" CLAUSE CAN'T COPY DEFAULT COLUMN VALUE OF THE DATA SOURCE TABLE |
|
IZ44813 |
3 |
FOR BIT DATA COLUMNS PUSHDOWN SHOULD BE INDEPENDENT OF COLLATING_SEQUENCE |
|
Relational Data Services |
|
IZ45284 |
1 |
CREATE OR ALTER TABLE WITH XML COLUMN FAILS WITH SQL8029E |
|
LI73844 |
1 |
DB2 INTERNAL LOGIC ERROR MAYBE CRASH DB2 INSTANCE WHEN DGTT TABLE IS USED |
|
IZ32371 |
1 |
WITH BLOCKING ENABLED, COMMIT WILL INVALIDATE ANY LOCATORS IN FETCHED BLOCK. |
|
IZ39972 |
2 |
DB2 INSTACNE MIGHT CRASH AT 'SQLRIUPD'. |
|
JR32096 |
2 |
MIGRATION OF A DATABASE FROM V8.2 TO V9.5 FAILS WITH SQL1224N IF DATABASE CREATED WITH USERNAME WITH MORE THAN 8 CHARACTERS |
|
IZ40001 |
2 |
DROP TABLE FAILING WITH -901 WHICH HAD DEPENDENT STATISTICAL VIEWS |
|
IZ41060 |
2 |
ENGINE CRASHES BECAUSE SQLR_GET_STATS_COMMAND() ATTEMPTS TO FREEA A NULL POINTER DURING RUNSTATS ERROR HANDLING |
|
IZ39013 |
2 |
ERRORS RETURNED FROM RUNNING DB2EXPLN ARE NOT MEANINGFUL OR TRUNCATED AND THIS MIGHT CAUSE DB2FMP TO CRASH WITH SIGNAL 11. |
|
IZ39649 |
2 |
TABLE FUNCTION ADMIN_GET_TAB_INFO CAUSES A MEMROY LEAK IN APPLICATION HEAP WITH DB2 V9.5 |
|
LI73860 |
2 |
APPLICATION WITH NO DGTTS, MIGHT BE ABLE TO ACCESS CACHED SQL REFERENCING A DGTT OF A DIFFERENT CONNECTION |
|
IZ36282 |
2 |
DB2 ENGINE MAY TRAP IF ERROR ENCOUNTERED WHILE REGENERATING FUNCTION |
|
IZ42237 |
2 |
TRAP IN DPF SUBAGENT PROCESSING WHEN CURRENT PACKAGE PATH IS USED AND A DROP PACKAGE IS ISSUED |
|
IZ44660 |
2 |
"CREATE PROCEDURE." TRAPPED WHEN THE NUMBER OF ROUTINE WITH SAME ROUTINETYPE, ROUTINENAME AND PARAM_COUNT >210 |
|
IZ32352 |
2 |
SQLCODE -901 RETURNED WHEN USERS DEFINED A GLOBAL VARIABLE THAT IS INITIALIZED FROM A USER DEFINED FUNCTION. |
|
LI74152 |
2 |
A DECIMAL DIVISION RETURNS AN INCORRECT RESULT IF THE RESULTING PRECISION IS 32 AND MIN_DEC_DIV_3=YES |
|
IZ24765 |
2 |
AFTER QUIESCE-ING THE DB AND UNQUIESE-ING IN A DIFFERENT SESSION, QUERIES ARE NO LONGER INTERCEPTED BY QP. |
|
IZ29939 |
2 |
DATABASE MARKED BAD WHEN INTRA-PARALLELISM ENABLED (SQLO_CPSAME ERROR IN DB2DIAG.LOG) |
|
IZ36509 |
2 |
OPTIMIZE PROCESSING OF NESTED LOPP JOIN WITH CONDITIONAL SUBQUERY |
|
IZ38792 |
2 |
INSTANCE CRASH DUE TO SIGNAL #11 SIGSEGV IN SQLRXA2F() |
|
IZ42876 |
2 |
NO AUDIT EVENT GENERATED FOR FLUSH EVENT MONITOR STATEMENTS. |
|
IZ36947 |
2 |
SQL0901N MESSAGE WITH "SQLRIAOQP: REFETCH IND 1" |
|
IZ35071 |
2 |
SELECTING FROM A VIEW CREATED PRIOR TO V9.1 USING THE UNQUALIFIED FUNCTIONS CAN RETURN SQL0901N ERROR. |
|
LI74111 |
2 |
INSTANCE ABEND CAN OCCUR WHEN TRUSTED UDF AND TRUSTED SCALAR FUNCTION ARE USED IN THE SAME QUERY |
|
IZ36183 |
2 |
DURING APPLICATION CONNECTION RESET OR TERMINATION, DB2 TRAPS WHEN TRYING TO FREE UP QUERY SECTIONS AND ITS SIBLINGS. |
|
IZ34517 |
2 |
QUERY USING A HASH JOIN MAY FAIL WITH SQL0901 - "COMPARISON FOR COLLID FAILED IN HSJN" IN DB2DIAG.LOG |
|
IZ40998 |
2 |
MIGRATION OF DATABASE TO DB2 V9.5 MAY FAIL WITH SEGMENTATION FAULTS |
|
LI74139 |
2 |
ERROR -901 REPORTED BY SQLRI_HSJNLOADTUPCOLREVER RUNNING COMPLEX QUERY |
|
IZ38639 |
2 |
SYSUSERAUTH PRIV CHECKING REPEATED ON EACH EXECUTE WHEN THERE IS AN INTERVENING COMMIT |
|
LI73955 |
2 |
QUERY WITH HASH JOIN MAY NOT RESPOND TO FORCE APPLICATION OR OTHER INTERRUPTS FOR A PERIOD OF TIME. |
|
IZ33247 |
2 |
SQL0304N ERROR RETURNED WHEN TIMESTAMP VALUE IS ASSIGNED TO A VARIABLE OF LENGTH LESSER THEN 26 CHARACTERS. |
|
IZ35146 |
2 |
SIGNAL 11 TRAP WHEN CANCELLING A FEDERATED FMP QUERY |
|
IZ41025 |
2 |
OPTIMIZER IGNORES NEW PREFETCHSIZE FOR TABLESPACE, TRANSFERRATE/OVERHEAD FOR TABLES WITH RANGE PARTITIONING |
|
IZ42319 |
3 |
OUT OF MEMORY CONDITION MAY CAUSE TRAP WHILE RETRIEVING USER PRIVILEGES |
|
IZ35330 |
3 |
SQL0423 ERROR RAISED BY DB2CAT -V IF THERE ARE MANY TABLES IN SYSIBM.SYSTABLES. |
|
IZ36567 |
3 |
INSERT AND IMPORT COMMAND CAN RECEIVE SQLO811N AS A RESULT OF THE TRIGGER PROCESSING AFTER OFFENDING ROWS WERE ALREADY DELETED |
|
JR30422 |
3 |
"ALTER TABLE ALTER COLUMN" STATEMENT DOES NOT ALTER THE CODEPAGE COLUMN IN THE SYSCAT.COLUMNS VIEW |
|
IZ44649 |
3 |
REVOKING CREATE_EXTERNAL_ROUTINE,CREATE_NOT_FENCED_ROUTINE AT THE SAME TIME FAILS WITH -558 |
|
JR30764 |
3 |
CALLING NNSTAT GETS SQL20274W WITH SQL1227 REASON CODE = "3" LOGGED IN THE NNSTAT LOG. |
|
IZ36916 |
3 |
TWO ENTRIES IN LIST HISTORY OUTPUT COMMAND FOR ONE REORG ACTION |
|
IZ23215 |
3 |
INCORRECT RESULTS FROM WLM_GET_ACTIVITY_DETAILS TABLE FUNCTION |
|
LI73967 |
3 |
WLM STATISTICS COLLECTION CAN OCCUR AN UNEXPECTED SECOND TIME AFTER A NORMAL COLLECTION INTERVAL EXPIRED |
|
IZ39319 |
3 |
WORST PREPARATION TIME IN DYNAMIC SQL SNAPSHOT FOR CREATE PROCEDURE (LANGUAGE SQL) STATEMENT IS WRONG |
|
JR31660 |
3 |
FEDERATION DDL DOESN'T CHECK NICKNAME COLUMN LENGTH |
|
IZ31419 |
3 |
SQL20139 (-20139) APPEARS IN DB2DIAG.LOG WHEN INTERRUPTING QUERY |
|
LI73747 |
4 |
ADDITIONAL '^R' CHARACTERS ARE INCLUDED IN THE DB2LOOK OUTPUT FOR TABLESPACES. |
|
IZ39086 |
4 |
DYNAMIC CACHE VARIATION INSERT TIMESTAMPS FOR INTERNAL ENTRIES DO NOT REFLECT THE INSERT TIME. |
|
LI73962 |
4 |
THE KEYCOLUSE.COLSEQ COLUMN NOT SHOWING THE CORRECT COLUMN SEQUENCE IN THE FOREIGN KEY IN V9.5 . |
|
Replication |
|
JR31289 |
2 |
THE REPLICATION CAPTURE PROGRAM SETS TOO SMALL A BUFFER SIZE FORSOME LOG ENTRIES TO BE READ. |
|
JR30979 |
3 |
REPLICATION ADMIN FIXES FOR DB2 LUW V95FP4 |
|
JR30977 |
3 |
REPLICATION ENGINE FIXES FOR V95FP4. |
|
Security |
|
IZ49520 |
1 |
PERFORMANCE DEGRADATION IF THEY ARE USING DB2 CONNECT SERVER WITH CONCENTRATOR WITH DB2 FOR ZOS. |
|
IZ40633 |
2 |
ENCRYPTING CACHED PASSWORD AT CLIENT APPLICATION SIDE CAN CAUSE PERFORMANCE PROBLEMS. |
|
IZ42964 |
2 |
TRANSFER OWNERSHIP OF DATABASE OBJECT SUCCEEDS WHEN A USER HAS ACQUIRED DBADM AUTHORITY FROM ITS GROUP MEMBERSHIP |
|
IZ41928 |
2 |
GSKIT LIBRARIES USED FOR DB2 SSL IMPLEMENTATION HAVE BEEN UPGRADED TO VERSION 7.0.4.20 |
|
IZ40408 |
3 |
DB2 AUDIT MAY CREATE AN EMPTY AUDIT LOG. |
|
Self Tuning Memory Manager |
|
IZ39928 |
2 |
PACKAGE CACHE INCREASE BY STMM CAUSES PERFORMANCE PROBLEMS. |
|
Spatial Extender |
|
IC58893 |
2 |
DEFECT 371497 |
|
JR30368 |
2 |
ST_POINTATDISTANCE AND ST_DISTANCETOPOINT FUNCTIONS DID NOT WORKAFTER MOVING FROM A 32-BIT TO 64-BIT INSTANCE. |
|
JR31501 |
2 |
SPATIAL EXTENDER TERMINATES WITH SIGNAL 9 |
|
IZ47456 |
2 |
-4302N ERROR WHEN RUNNING ITMAGENT_SET_CONFIG.ITMAGENT_SET_CONFIG |
|
IZ33562 |
2 |
ONCE THE FENCED POOL IS FILLED WITH NON-ADMIN FMP WORKERS, ADMIN_CMD CAUSE ADMIN WORKER TO BE CREATED AND TERMINATED EACH TIME |
|
IZ41032 |
2 |
DB2PD -INST , -DB , -EVERYTHING OPTIONS PRODUCE INCOMPLETE OUTPUT |
|
IZ33766 |
2 |
FENCED MODE PROCESS (DB2FMP) FAILING WITH SIGNAL 4 (SIGILL) DURING PROCESS TERMINATION |
|
IZ42987 |
2 |
DB2FMP MIGHT TRAP DUE TO BAD TRACE POINTS. |
|
LI74238 |
2 |
INCORRECT RESULTS IN AN SQL STORED PROCEDURE CONTAINING A BRANCHTO A LABELLED SET STATEMENT |
|
IZ40881 |
2 |
COLUMN NAME & DEFINITION OF TABLE WHICH HAS A DEPENDENCY CANNOT BE CHANGED USING ALTOBJ - ERROR SQL0443N |
|
IZ45227 |
2 |
PROBLEM CLEAN UP DEAD FMP ENTRY IN THE FMP TABLE |
|
JR31206 |
2 |
UNEXPECTED BEHAVIOR WHEN SQLCODE OR SQLSTATE IS REFERENCED BY SET STATEMENT IN UNDO HANDLER INSIDE STORED PROCEDURE |
|
IZ39075 |
2 |
DB2SET DB2_LIMIT_FENCED_GROUP=YES FAILS WITH RETURN VALUE "-2029059838" |
|
LI73353 |
3 |
ALTER TABLE FROM THE CONTROL CENTER FAILS WITH SQL0443N / SQL0880N FOR ALTOBJ_EXECSAVEPOINT. |
|
Text Search |
|
IZ42620 |
2 |
DB2 TEXT SEARCH UPDATE FAILS ON RICH TEXT DOCUMENT WHEN DATABASECODESET IS NON UTF-8. |
|
IZ42327 |
2 |
SUNAMD64: DB2TS START FOR TEXT FAILS WHEN DB2 TEXT SEARCH IS ENABLED FOR RICH TEXT SUPPORT |
|
JR31271 |
2 |
THE "DB2TS ENABLE DATABASE FOR TEXT" COMMAND FAILS ON WINDOWS IFTHE DATABASE IS CREATED ON A SPECIFIC PATH. |
|
LI74161 |
3 |
SCORE() RETURNS WRONG VALUES WITH SYNONYM =ON ON |
|
XML Data Services |
|
IZ33319 |
2 |
CHECK SANITY FAILED DURING RUNSTATS |
|
JR30765 |
2 |
XQUERY PERFORMANCE REGRESSION AFTER MIGRATING FROM V9.1 TO V9.5 |
|
IZ37438 |
2 |
XML RUNSTATS USED AN INCORRECT COMPARISON FUNCTION TO COMPARE 2 STRINGS |
|
IZ36323 |
2 |
SQL0901N RETURNED DURING QUERY WITH XMLEXISTS |
|
IZ42298 |
2 |
SQL0901N IS RECEIVED WHEN DECOMPOSING USING A XML SCHEMA CONTAINING AN EMPTY MODEL GROUP. |
|
IZ42820 |
2 |
DB2 CRASHED WITH REASON ADDITEM: WHEN ADDING SQLZXMLANYTYPE WITH TEMP XID, THE XID MUST POI |
|
LI73890 |
2 |
INCORRECT QUERY OUTPUT IN CERTAIN XMLEXISTS QUERIES |
|
IZ36720 |
2 |
DB2 TRAPPED ON XMLSADVANCEMATCHCURSOR |
|
IZ32759 |
3 |
SQL0101N WHEN XML DOCUMENT IS DECOMPOSED USING ANNOTATED XML SCHEMA WITH LARGE NUMBER (300+) OF MAPPED ITEMS INTO 1 TABLE. |
APAR fixes included in Fixpak 3 | APAR No. | Sev. | Abstract |
|
Administration Tools |
|
IZ26966 |
2 |
MEMORY LEAK IN ENGN/SQPI COMPONENT. |
|
IZ18656 |
2 |
DB2ADVIS CAN CAUSE INSTANCE CRASH WITH SIGNAL#11 (SIGSEGV) IN FUNCTION SQLRLGUA() -> STRLEN() IF RAN FROM NON-CATALOG NODE |
|
IZ35488 |
2 |
DB2LOOK SHOULD GENERATE AUTORESIZE CLAUSE ONLY FOR AUTOMATIC STORAGE TABLESPACES |
|
IZ25916 |
2 |
GOVERNOR RULES INVOLVING SETLIMIT AND SPECIFIC AUTHIDS ARE NOT WORKING PROPERLY |
|
IZ29945 |
2 |
DB2LOOK PRODUCES INCOMPLETE AND MIS-ORDERED CONTAINER INFORMATION IN CLUSTERED ENVIRONMENTS |
|
LI73748 |
3 |
DB2LOOK FAILS TO PUT QUOTES AROUND TABLESPACE NAMES. |
|
JR27729 |
3 |
MQT RECOMMENDATIONS GIVEN BY THE DB2 DESIGN ADVISOR (DB2ADVIS) MIGHT NOT BE IN PROPER SQL SYNTAX |
|
IZ32722 |
3 |
DB2LOOK NOT DISPLAYING AUTORESIZE INFORMATION FOR SYSTEM GENERATED TABLESPACES (#2) |
|
Application Programming Services |
|
IZ35049 |
1 |
RUNNING DB2 EMBEDDED SQL PROGRAMS THAT WERE CO-PROCESSED USING IBM COBOL COMPILER ON DB2 9.5 MAY HAVE INCORRECT OUTPUT. |
|
IZ31825 |
3 |
NULL INDICATOR MAY BE SET INCORRECTLY WHEN BINDING OUT GRAPHIC LOB DATA TO A NON-LOB HOST VARIABLE WHEN TRUNCATION OCCURS. |
|
Buffer Pool Services |
|
LI73174 |
2 |
DATABASE IS MARKED BAD AFTER ITS SMS TEMP TABLESPACE HITS DISK FULL AND ROLLBACK FAILS. |
|
IZ22825 |
2 |
POSSIBLE ADM6044E MESSAGES DURING SET WRITE SUSPEND FOR DB FOR AUTORESIZE TABLESPACES |
|
IZ28619 |
2 |
SLOW DEACTIVATION OF A DATABASE DUE TO TOO MANY DIRTY PAGES IN BUFFERPOOL. |
|
LI73234 |
3 |
ADD ADDITIONAL DIAGNOSTIC MESSAGES AND SANITY CHECKS TO SQLBFIXDATAEMP() AND LOAD'S PMDCSCRATCHAREA. |
|
Client |
|
JR30320 |
2 |
WITH VISUAL STUDIO, WHEN CONNECTING TO ISERIES, SOME TABLES (PHYSICAL FILES) WILL NOT DISPLAY IN SERVER EXPLORER |
|
JR30319 |
2 |
POOR PERFORMANCE WHEN QUERYING FILES ON ISERIES FROM .NET OR VISUAL STUDIO |
|
Client Interfaces |
|
JR30450 |
1 |
OLEDB APP RETURNS NULL INSTEAD OF EMPTY RECORDSET. |
|
JR29852 |
1 |
DB2 CRASH WITH CORRUPT STACK CALLING SYSIBM.SQLPROCEDURECOLS |
|
IZ31199 |
2 |
USING DB2 CLI SQLGETDATA2() WITH LOBS MAY RETURN WRONG LENGTH OFTHE REMAINING DATA PIECE |
|
IZ31341 |
2 |
WRITETOSERVER METHOD ON DB2BULKCOPY FAILS WHEN CALLED THE SECOND TIME |
|
IZ35720 |
2 |
DB2 CLI SQLSETCONNECTATTR CALLED WITH SQL_ATTR_SERVER_MSGTXT_SP MAY APPEND GARBAGE CHARACTERS TO THE STORED PROCEDURE NAME |
|
IZ24822 |
2 |
POSSIBLE CRASH IN CLI_SCNTRANSLATESQL |
|
JR29983 |
2 |
THROW AN EXCEPTION WHEN THE SCALE OF A DECIMAL VALUE IS LARGER THAN THE PRECISION |
|
JR30053 |
2 |
BINDING DDSCVM.LST FROM DB2 CONNECT V9.5 AGAINST DB2 VM FAILING WITH SQL0551N |
|
IZ36636 |
2 |
CLI STATIC PROFILING MAY EXECUTE SOME STATEMENTS DYNAMICALLY WHEN YOU EXPECTED THE STATEMENTS TO BE EXECUTED STATICALLY. |
|
LI73336 |
2 |
SYSPLEX CLI KEYWORD NEEDS TO BE ADDED TO HELP DISABLE CLIENT-SIDE SYSPLEX SUPPORT |
|
IZ29590 |
2 |
SQLEXECDIRECT() CAN FAIL WITH SQL_ERROR WITHOUT ANY SQLCODE BEEING RETURNED FROM THE SERVER |
|
IZ31394 |
2 |
CHANGE INPUT PARAMETER FOR SP XDBDECOMPXML100MB |
|
IZ29687 |
2 |
"DB2 -A" RETURNS UNEXPECTED SQLSTATE WHEN AN ADJUSTMENT WAS MADE TO A DATE OR TIMESTAMP VALUE |
|
JR29218 |
2 |
SQL30082 RC24 IS OCCURRED AT SQLDRIVERCONNECTW 10 TIMES |
|
IZ26462 |
2 |
APAR IZ15121 IS FIXED IN DB2 V9.1 VP5, BUT NEEDS TO BE ENABLED WITH PATCH2=78 IN THE DB2CLI.INI FILE |
|
JR29916 |
2 |
SEQUENTIAL READS FROM STREAM OBJECTS NOT POSSIBLE |
|
IZ25674 |
2 |
CLI0125E WITH SQLEXTENDEDBIND AFTER SETTING SQL_ATTR_CHAINING_BEGIN |
|
IZ22927 |
3 |
DB2 CLP MAY SHOW INCORRECT OUTPUT WITHIN COLUMN OF "STATUS". |
|
JR28839 |
3 |
DB2 CLI DRIVER PERFORMS SLOWLY WHEN ASYNC_ENABLE IS USED |
|
JR30189 |
3 |
DB2COMMANDBUILDER FAILS WHEN USED WITH GENERATED COLUMNS |
|
JR28745 |
3 |
SQLGETTYPEINFO RETURNING INCORRECT VALUE FOR CREATE_PARAMS COLUMN FOR DECIMAL COLUMNS AGAINST Z/OS |
|
IZ22194 |
3 |
CLI STATEMENT SCANNER UNABLE TO RECOGNIZE IDEOGRAPHIC SPACE |
|
IZ32616 |
3 |
INCORRECT VALUE RETURNED FOR SQL_DATABASE_CODEPAGE WHEN MULTICONNECT=3 DB2CLI.INI SETTING IS SET. |
|
JR29790 |
3 |
DB2 64-BIT CLIENT DOES NOT CONTAIN 64 BIT DB2CLI.LIB |
|
IZ17030 |
3 |
ADDING PATCH2=77 OPTION TO ALLOW DATE, TIME, AND TIMESTAMP STRING FORMATTING TO BE DEFINED BY STORED PROCEDURES ON DB2/390. |
|
JR29265 |
3 |
IFXTYPE.DATETIME NOT SUPPORTED |
|
IZ26920 |
3 |
HADR PARAMATERS IN THE DATABASE CONFIGURATION CANNOT BE SET TO DEFAULTS USING THE "DB2 UPDATE DB CFG ...." COMMAND |
|
IZ31762 |
3 |
TESTCONN UTILITY NEEDS TO COMPARE XADLL REGISTRY ENTRY WITH CASE INSENSITIVITY. |
|
IZ32761 |
4 |
SQL0104N TEXT MENTIONS DB CFG PARAM THAT'S NOT LISTED IN "UPDATE DB CFG" HELP PARAM LIST |
|
Common Code Infrastructure |
|
IZ28164 |
1 |
ON HP-UX DATABASE MIGRATION TO V95 MAY FAIL WITH SQLB_AS_INVALID_STORAGE_PATH |
|
IZ33254 |
1 |
FCM CONGESTION DEADLOCK DURING LARGE WORKLOADS WHEN DB2FCMR GETS STARVED DUE TO CONTEXT SWITCHING DURING SPAWNING OF EDU THREADS |
|
IZ27865 |
1 |
CRASH OCCURS WHEN SQLUIMPR()/DB2IMPORT() IS USED TO IMPORT TABLEUSING V9.5 WINDOWS CLIENT. |
|
IZ32758 |
1 |
DB2HAVEND SPINS IN TIGHT LOOP AFTER PARENT CRASHED/KILLED |
|
IZ29951 |
1 |
CREATE DB FAILS WITH SQL1034C IN A LATIN AMERICA LOCALE |
|
IZ35230 |
1 |
THERE IS A PERVASIVE UNIX-SPECIFIC PRIVATE MEMORY LEAK IN THE SECURITY COMPONENT. |
|
LI73842 |
2 |
CRASH OR HANG IN SQLOTHREADLEVELFILELOCKUNLOCK ON DB2 V95 |
|
IZ23418 |
2 |
DB2FMP MEMORY KEEPS GROWING |
|
JR28193 |
2 |
BIDI CHARACTER DATA PASSED TO SQLBINDPARAMETER WITH VALUETYPE SQL_C_WCHAR ENDS UP WITH INCORRECT BIDI ATTRIBUTES IN DB2 ON ZOS |
|
IZ26856 |
2 |
SUPPORT FOR DB2_WORKLOAD=CM TO BE ADDED FOR IBM CONTENT MANAGER ENVIRONMENTS |
|
LI73705 |
2 |
IN LINUX DB2SYSC CRASH (SIGNAL #11) DOES NOT CREATE CORE FILE EVENTHOUGH ULIMIT -C UNLIMITED. |
|
JR29448 |
2 |
DB2ICLUS.EXE FAILS WITH EXCEPTION IN SQLO_CLUSTER_ADDNODE() -> SQLOMCPI() WHEN THE MACHINE NAME IS NOT IN THE CLUSTER. |
|
IZ33326 |
2 |
IPCLEAN -A REMOVES THE IPCS USED BY THE MFCOBOL LICENSING DAEMON. |
|
IZ21460 |
2 |
GARBLED CHARACTERS ARE OBSERVED ON HP-UX/IA64 WITH "DB2MTRK -I -V" AND "DB2ADVIS -D DB_NAME -G" WITH LOCALE KO_KR.EUCKR |
|
IZ32522 |
2 |
SWITCHING USERS ON WINDOWS, ON A TRUSTED CONTEXT CONNECTION WILL FAIL WHEN AUTHENTICATION TYPE IS KERBEROS. |
|
JR30345 |
2 |
ERROR(S) SQL0901N, SQL0452N, "CORRELATION IDENTIFIER OVERFLOW", OR SQLJC_ERROR_ICE WHEN IMPORTING BLOBS ON WINDOWS |
|
IZ26607 |
2 |
DB2IUPDT CAN FAIL WITH DBI1282W ON SUN, ALL INSTANCE COMMANDS WILL NOT WORK AFTERWARDS |
|
IZ29981 |
2 |
CANNOT CREATE DATABASE OR PERFORM OTHER DB2 ADMINSITRATIVE WORK WHEN THE DOMAIN CONTROLLER IS NOT REACHEABLE. |
|
LI73778 |
2 |
WHEN USER DN CONTAINS ESCAPE CHARACTER, DB2 LDAP GROUP PLUGIN CAN'T FIND USER'S GROUP |
|
IZ16595 |
3 |
DB2 CORRECT THE HANDLING FOR SWEDISH LOCALE "SV" ON SOLARIS |
|
IZ26718 |
3 |
OSSGETCORESPERSOCKET, PROBE:40 ERROR IN DB2DIAG.LOG ON SOLARIS 10. |
|
LI73569 |
3 |
DB2CKPWD SPINS FOREVER IF KILLDBM IS ISSUED |
|
IZ29132 |
3 |
DB2OSCONF FAILS WHEN RUNNING ON SOLARIS LOCAL ZONE |
|
JR31145 |
3 |
DB2ILIST ON WINDOWS MAY NOT DISPLAY A CLUSTER NAME. |
|
IZ29634 |
3 |
INSTANCE HANGING WHILE LOGGING ON DB2DIAG.LOG |
|
IZ28239 |
3 |
DB2 INSTANCE MAY CRASHE WITH THE SIGBUS SYSTEM ERROR AFTER OFF-LINE BACKUP |
|
IZ26638 |
3 |
WITH DB2_NUM_CKPW_DAEMONS SET TO 3:FORK OR 0, DB2START TIMES OUTUSING A NON-INSTANCE OWNER ID. |
|
IZ16840 |
3 |
SIGBUS OR SIGSEGV IN LIBDB2OSSE LIBRARY IN _GTRACEENTRYVAR OR GTRACEATTACH |
|
JR29392 |
3 |
OSS API CALLED BY SNAPSHOT CODE CAN'T HANDLE WINDOWS RAW DEVICESCONTAINERS PROPERLY |
|
IZ12403 |
4 |
DB2 INSTALLATION CHANGES /VAR DIRECTORY OWNER AND GROUP FROM BIN:BIN TO ROOT:SYSTEM ON AIX. |
|
Communication |
|
IZ36904 |
2 |
DB2 UDB ACTS DIFFERENT AMONG PLATFORMS, WHEN DB2TCP_CLIENT_RCVTIMEOUT > 0 & ALSO WHEN USING SELECT() & RECV() |
|
IZ26748 |
2 |
DB2 CONNECT(SPM) TRAP IN <SQLCSPR_DRDA_RQS> <SQLCSPRI.C:5440>. |
|
IZ24502 |
3 |
DISCONNECT GENERATING UN-NECESSARY MESSAGES IN DIAGLOG AT DIAGLEVEL 4 |
|
IZ28487 |
3 |
"SQLCSPM_2PHASE_PROTOCOL_VIOLATION_208" CAN BE HIT ON SPM IF CLIENT REROUTE OCCURS ON DB2 CONNECT AGAINST Z/OS SYSPLEX. |
|
Connection Manager |
|
IZ31377 |
1 |
CONNECT REUSES A CONNECTION IN THE POOL AFTER LETTING ZOS KNOW IT WILL EVEN THOUGH ZOS REFUSED TO HONOR THE REUSE REQUEST. |
|
IZ19743 |
2 |
WRONG XA RC VALUE XA_RMERR (-3) IS RETURNED IN THE XA FUNCTION CALL DURING THE CONNECTION TIMEOUT CONDITION. |
|
IZ20723 |
2 |
WRONG XA_RMERR (-3) IS RETURNED IN THE XA_ROLLBACK() FUNCTION CALL IF THE CONNECTION IS ALREADY DROPPED |
|
IZ19258 |
2 |
XA APPLICATION ALWAYS GETS XA_RBDEADLOCK, WHEN SQL0911N/SQL0913NRC=2 (DEADLOCK) OR RC=68 (LOCK TIMEOUT) OCCURS. |
|
IZ19966 |
2 |
SQLPXTENTRYSWITCHIN REPORTS SQLP_NOTA IN DB2DIAG.LOG |
|
IZ31203 |
3 |
MSACCESS.EXE FAILURE |
|
Control Center |
|
JR29904 |
2 |
CREATE NICKNAME FOR WEBSERVICE FAILS TO PARSE WSDL HAVING ELEMENTS DEFINED IN THE DEFAULT NAME SPACE |
|
JR29223 |
2 |
USING COMMAND EDITOR CONNECTING TO Z/OS DB2 RESULTS IN CLAIMS (CS,C) ON THE TABLE WHICH CAUSES CONTENTION WITH Z/OS UTILITIES |
|
JR30023 |
3 |
SQL -104 (SQL0104N) WHEN USING CONTROL CENTER CONNECTING TO EBCDIR DATABASE ON Z/OS WITH OBJECT NAMES IN UNICODE |
|
DB2 Tools |
|
IZ31390 |
2 |
CONTROL CENTER PERFORMS A SEARCHED UPDATE INSTEAD OF A POSITIONED UPDATE |
|
JR29515 |
2 |
CONTROL CENTER HADR WIZARD FAILS DURING SETUP PROCESS CAUSING A JAVAW.EXE CRASH. |
|
JR30065 |
2 |
NNSTAT SETS STATISTICS TO DEFAULT -1 OR '' W/SQLCODE =0 AND CLP RC=0 WHEN CALLED BY A DB2 USER WITHOUT ENOUGH |
|
DRDA Services |
|
IZ18689 |
2 |
'SET' COMMAND RESTRICTION WITH CONNECTION CONCENTRATOR ON |
|
JR29506 |
2 |
-30005 WHEN ISSUING DELETE OR UPDATE OPERATIONS WITH ARRAY INPUTAGAINST DB2 FOR Z/OS |
|
IZ30966 |
3 |
UNEXPECTED SYSTEM ERROR IF HOST DB UNABLE TO SET A TRUSTED CONNECTION BECAUSE THE ENTITY IS NOT AUTHORIZED TO ACCESS THE RDB. |
|
LI73472 |
3 |
SOMETIMES, ADDITIONAL 'G' APPEARS AT THE END OF PACKAGE NAME IN 'DDCSPKGN' OUTPUT. |
|
Data Management Services |
|
IZ34995 |
1 |
BAD DATA PAGE ERROR WHILE DELETING FROM MDC TABLE |
|
IZ31233 |
2 |
DB2 RUNSTATS PERFORMANCE DETERIORATION ON SOLARIS PLATFORM |
|
LI73699 |
2 |
AUTOMATIC DICTIONARY CREATION (ADC) FAILS THE DRIVING OPERATION FOR A TABLE IN CHECK PENDING STATE. |
|
IZ20211 |
2 |
INSTANCE TRAP/PANIC IF SORT TRIES TO UNFIX A TEMP-PAGE THAT HAS ALREADY BEEN UNFIXED, DEFENSIVE CODE TO PREVENT PANIC. |
|
IZ32326 |
2 |
INSTANCE TRAP DURING BLOCK INDEX PREFETCH PROCESSING |
|
IZ35044 |
2 |
INSPECT ROWCOMPESTIMATE MIGHT TRAP WHEN INSERTING A DICTIONARY |
|
IZ36903 |
2 |
MDC INSERT PERFORMANCE DEGRADE, WHEN THERE IS MANY ROWS WITH DIFFERENT CELL VALUE (NOT SORTED ) GET INSERTED INTO MDC TABLE. |
|
IZ32519 |
3 |
A SORT OPERATION CAN SEG-FAULT AND BRING DOWN INSTANCE IN A SPECIFIC OUT-OF-MEMORY ERROR SCENARIO. |
|
Data Protection Services |
|
IZ29899 |
1 |
CRASH RECOEVRY HANGS DB2DIAG.LOG MESSAGE FROM DB2 UDB, SQO LATCH TRACING, SQLO_XSEMLATCH::GETCONFLICT,PROBE: EVERY MINUTE |
|
IZ27991 |
2 |
GET DB CFG FOR <DB ALIAS> OR DB2PD -DB <DB ALIAS> -DBCFG MIGHT NOT SHOW THE CORRECT 'CURRENT' VALUE FOR LOGPRIMARY. |
|
IZ21796 |
2 |
DIAGNOSTICS ENHANCEMENT DURING BAD LOG RECORD READ |
|
IZ20741 |
2 |
"DB2FLSN -LSNRANGE" COMMAND DOES NOT WORK IN "CIRCULAR LOGGING" ENVIRONMENT. |
|
LI73352 |
2 |
AUTOMATIC RUNSTATS MAY CAUSE SQL0911N, A DEADLOCK. |
|
IZ32886 |
2 |
EXCESSIVE NUMBER OF DB2REDOW PROCESSES CAUSING POOR DB2 ROLLFORWARD PERFORMANCE |
|
IZ35642 |
2 |
INSTANCE IS HUNG AFTER RUNNING DB2 WRITE SUSPEND. |
|
IZ32524 |
3 |
LOG FILES MAY NOT BE REMOVED AFTER ROLLFORWARD |
|
IZ27973 |
3 |
NOT REAL ERROR LOGGED AT "SQLPALR_ALLOCBUFFERS, PROBE:1440" DURING ONLINE BACKUP WITH CAPTURE/APPLY |
|
IZ17047 |
3 |
DURING THE BACKUP OF A SPLIT MIRROR COPY THE DB2LOGMGR MAY ATTEMPT TO BACKUP LOGS |
|
IZ16980 |
3 |
CUSTOMERS USING INCREMENTAL OR DELTA BACKUPS, MAY GET ERRORS WHEN USING RECOVER DATABASE COMMAND. |
|
Development Infrastructure |
|
IZ33881 |
1 |
DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.53.70/4.3.85 FOR DB2 LUW V9.5 FIXPACK 3 |
|
JR29801 |
2 |
V9 INSTALL DOES NOT PUT THE DB2V8 REGISTRY ENTRY DURING INSTAL |
|
JR29649 |
3 |
DB2APP.DLL DOES NOT HAVE THE DEPENDENCY MANIFEST BUILT IN |
|
Documentation and Information Center |
|
IZ36657 |
2 |
SAMPLE SSV_BACKUP_TBSP.DB2 FAILS TO RUN CORRECTLY ON NTX64 PLATFORM IN MPP MODE |
|
IZ17087 |
3 |
DBTHRDS.SQC HAS INTERMITTENT FAILURES DUE TO RELATIONSHIP VIOLATIONS |
|
IZ36123 |
3 |
JAR CF %DB2PATH%\SPSERVER.JAR SPSERVER.CLASS WHICH IS NOT ABLE TO CREATE THE JAR FILE AT REQUIRED LOCATION. |
|
Engine Infrastructure |
|
IZ33258 |
1 |
FCM TCP_SENDSPACE/TCP_RECVSPACE VALUES SHOULD USE SYSTEM VALUES INSTEAD OF HARD-CODED 64K |
|
IZ33256 |
1 |
FCM DEADLATCH INVOLVING DB2FCMR, DB2FCMS AND SOME OTHER EDU. |
|
IZ23730 |
1 |
APPLICATION HANGS AFTER CLIENT REROUTE |
|
IZ29714 |
1 |
DB2 INSTANCE PANIC DUE TO MEMORY CORRUPTION IN QP |
|
IZ33257 |
1 |
YIELD APPNODEFAILURELATCH IN APP NODE FAILURE RECOVERY BEFORE WAITING FOR BUFFERS TO BE SENT |
|
LI73601 |
1 |
TRAP IN REGISTERAGENT DURING NODE FAILURE RECOVERY IN LOCALDEACTIVATE |
|
IZ29586 |
2 |
BSU HEAP MEMORY LEAK DURING SECONDARY CONNECTIONS |
|
IZ20249 |
2 |
DB2GETSNAPSHOT API RETURNS SQL1606W MESSAGE AS AN ERROR MESSAGE TO THE DB2DIAG.LOG |
|
IZ30868 |
2 |
THE FIRST CONNECT TO A QUIESCED DATABASE CAN FAIL WITH SQL1041N IF THE NUMBER OF ACTIVATED DATABASES IS ALREADY EQUAL TO NUMDB |
|
IZ33393 |
2 |
DB2STOP MAY FAIL TO COMPLETE IN MULTI-PARTITION ENVIRONMENT IF THERE ARE INSTANCE ATTACHMENTS AND NODE FAILURE IS DETECTED |
|
LI74224 |
2 |
APPLICATION HANG DUE TO -1225 ERROR THAT IS NOT GETTING REPORTED BACK PROPERLY |
|
IZ30550 |
2 |
REROUTE SERVICE CLASS MAPPING OF COMMIT/ROLLBACK IF SERVICE CLASS IS DISABLED |
|
IZ22888 |
3 |
ABNORMAL HIGH USAGE OF FCM BUFFERS IN A PARTITIONED DATABASE ENVIRONMENT RUNNING COMPLEX QUERIES. |
|
Engine Utilities |
|
LI73856 |
1 |
INSTANCE ABEND UPON ACTIVATING DATABASE WHEN USING HA CLUSTERINGFEATURES. |
|
IZ32957 |
1 |
SIGNAL 11 IN SQLUMCSTARTRESTOREMEDIACONTROLLER |
|
IZ30864 |
1 |
SIGNAL 11 DURING LOAD INDICATING OUT OF MEMORY CONDITIONS |
|
IZ34985 |
1 |
DB2 ABEND DUE TO SORT MEMORY ERROR |
|
IZ26459 |
2 |
PROBLEM WITH ERROR HANDLING IN XML EXPORT UTILITY WHEN THE XML OUTPUT FILE IS LOCKED AND NO LONGER AVAILABLE. |
|
IZ20160 |
2 |
UTILITY HEAP PHYSICAL MEMORY USAGE IS CLOSE TO 2X LOGICAL MEMORY USAGE DUE TO INEFFICIENT MEMORY MANAGEMENT |
|
IZ29776 |
2 |
LOAD INCORRECTLY APPENDS THE LOCAL PATH TO FILES PASSED INTO THESOURCEUSEREXIT |
|
LI73752 |
2 |
RESTARTED LOAD MAY CRASH THE INSTANCE ON SQLUKILLUSEREXIT |
|
LI73512 |
2 |
SQL3009N - THE ACTION STRING PARAMETER IS NOT VALID OR IS TOO LONG, WITH CLI APPLICATION USING LOAD UTILITY |
|
JR28336 |
2 |
RESTORE USING A DB2 64BIT BACKUP IMAGE TO A DB2 32BIT ENVIRONMENT FAILS WITH SQL2038 - SQL5130 (HADR_DB_ROLE). |
|
IZ27654 |
2 |
"BAD DATA PAGE" DURING DELETE PHASE WHEN ONLINE LOAD INTO EMPTY TABLE. |
|
IZ33116 |
2 |
LOAD XML FROM CURSOR DOES NOT SUPPORT SCHEMA VALIDATION |
|
IZ22388 |
2 |
BAD PAGE DETECTED IN SQLB_VERIFY_PAGE WHILE EXEUCTING LOAD AGAINST A RANGE PARTITIONED TABLE |
|
LI73783 |
2 |
LOAD TERMINATE ISSUED AFTER CRASH RECOVERY COULD RESULT IN A BADPAGE ERROR |
|
IZ35700 |
2 |
LOAD & IMPORT UTILITIES WILL IGNORE THE LAST COMPLETELY-EMPTY ROW OF A DEL DATA FILE. |
|
LI73497 |
2 |
ABNORMAL TERMINATION OF A RESTORE IN PROGRESS CAN RESULT IN A DIA8415C ERROR AFTER COMPLETION OF A SUBSEQUENT RESTORE |
|
IZ25965 |
2 |
DB2 IS NOT HANDLING THE RETURN CODE FROM THE VENDOR LIBRARY PROPERLY |
|
LI73565 |
2 |
LOAD RESULTS IN SQL0954C "NOT ENOUGH STORAGE IS AVAILABLE IN THEAPPLICATION HEAP TO PROCESS THE STATEMENT" |
|
IZ18237 |
2 |
LOAD OF AN MDC TABLE IN V91 AND V95 MAY HANG, WITH THE DB2LRID PROCESS ACCUMULATING SIGNIFICANT CPU TIME |
|
IZ27500 |
2 |
DURING LOAD FROM CURSOR WITH DB CLAUSE AND CODEPAGE CONV., VARCHAR COL WITH 0 LENGTH MAY HAVE INCORRECT VALUES ON TARGET |
|
LI73468 |
2 |
DB2 LOAD UTILITY DOES NOT FAIL WHEN AN IPC MESSAGE QUEUE ERROR OCCURS, RESULTING IN INCORRECT ROW COUNT LOADED. |
|
IZ10113 |
2 |
ALTER TABLESPACE FAILS WITH LOCKTIMEOUT DURING ONLINE BACKUP |
|
IZ33620 |
2 |
WORKLOADS WITH ROLLBACK ACTIVITY MAY LEAK MEMORY RESULTING IN AGENT TRAPS. |
|
IZ19705 |
2 |
LOAD FAILURE CRASHES DB2 IN MULTINODE SYSTEM WITH SQLKD_INVALID_CALL |
|
IZ24034 |
3 |
DB2 CRACHES SIGNAL 11 ON CONNECT ATTEMPTS FROM CC |
|
LI73158 |
3 |
LOAD/IMPORT/EXPORT UTILITIES GENERATING LOTS OF WARNINGS MAY PERFORM EXCESSIVELY SLOW |
|
LI73373 |
3 |
IN DB2 V9.5, THE DB2BACKUP API DOES NOT REPORT THE SIZE OF THE BACKUP IMAGE. |
|
IZ28352 |
3 |
IMPORT MAY PERFORM SLIGHTLY SLOWER IN V9 VERSUS V8. |
|
IZ30543 |
3 |
ABP (ASYNCHRONOUS BACKGROUND PROCESS) AGENT MAY BE SUSPENDED AND PUT INTO SLEEP UNEXPECTEDLY |
|
IZ21899 |
3 |
"EEXIST"WARNING MESSAGES IN DB2DIAG.LOG WHILE RUNNING LOAD WITH TEMPFILES PATH OPTION IN EEE ENVIRONMENT. |
|
IZ13599 |
3 |
DB2CFGSET API CAN CHANGE TO AUTOMATIC EVEN IF THE PARAMETER DOESNOT ALLOW AUTOMATIC. |
|
Federation |
|
IZ29894 |
2 |
CRASH DUE TO A SIGSEGV IN UNFENCEDSERVER(DT) |
|
JR30108 |
2 |
CREATE NICKNAME TAKES VERY LONG TIME FOR TERADATA WRAPPER |
|
JR29864 |
2 |
STATIC BINDING OF SYBASE CLIENT LIBRARY REQUIRES XA-CAPABLE CLIENT |
|
High Availability |
|
IZ12658 |
2 |
HADR PAIR LOSE CONNECTION TO EACH OTHER IF A PROGRAM CONNECTS TO THE TCP PORT USED BY THE PAIR TO COMMUNICATE WITH EACH OTHER |
|
IZ26736 |
2 |
UNABLE TO START THE FAULT MONITOR |
|
LI73255 |
2 |
SWITCHING A HADR PRIMARY TO STANDBY AND BACK TO PRIMARY MIGHT STOP ARCHIVING NEWLY GENERATED LOGFILES |
|
IZ33129 |
3 |
DB2HAICU SERVICEABILITY ENHANCEMENT |
|
IZ27971 |
3 |
IN HADR DEACTIVATE DB IN PRIMARY MAKES STANDBY TO TAKE OVER BUT CAUSE PRIMARY CRASH. |
|
IZ24399 |
3 |
AFTER A FAILOVER, HADR MONITOR SCRIPT WOULD PREVENT THE RESTORE ON THE NEW STANDBY. |
|
Index Manager |
|
IZ25342 |
2 |
DB2DART COMMANDS IN DB2DIAG.LOG HAVE INCORRECT INFORMATION |
|
IZ35549 |
2 |
-901,REORG TABLE: UNABLE TO FIND INDEX DEFINITION |
|
JR30272 |
2 |
USER MAY OBSERVE INCORRECT SCAN RESULT WHEN QUERYING GRAPHIC TYPE COLUMNS |
|
Install |
|
IZ34104 |
1 |
FILES UNDER INSTHOME/SQLLIB/ADM HAVE THE SETGID BIT INCORRECTLY TURNED ON. |
|
IZ32948 |
1 |
DB2 SETUP FAILED DUE TO LONG COMMAND LINE PARAMETERS, WITH AN ERROR COMPLAINING COMMAND LINE PARAMETERS NOT VALID. |
|
JR30474 |
2 |
CONFIGURING QUERY PATROLLER DURING GUI INSTALL MAY BE UNSUCCESSFUL |
|
IZ31985 |
2 |
INSTALLFIXPACK UPDATES DB2 SINGLE PARTITION INSTANCES EVEN IF THE INSTANCES ARE ACTIVE |
|
JR30327 |
2 |
INSTALLING WITH NESTED ADMIN ACCOUNT FAILS WHEN MIGRATING |
|
IZ26892 |
2 |
SOME COMPONENTS CANNOT BE PRUNED BY DB2IPRUNE.EXE |
|
JR29589 |
2 |
FILES MISSING DURING SILENT INSTALLATION OF DB2. |
|
JR29500 |
2 |
INSTANCE PROFILE IN NON DEFAULT LOCATION MOVED TO INSTALL PATH DURING INSTANCE MIGRATION TO DB2 VERSION 9.5. |
|
JR29861 |
2 |
AN ERROR IS THROWN WHEN V95FP1 DB2 THIN CLIENT IS SET UP ON A WINDOWS XP SP2 WORKSTATION. |
|
IZ28234 |
3 |
INSTALLATION SETUP WIZARD: OPTIONAL FEATURES APPEAR MANDATORY |
|
IZ30663 |
3 |
"DB2LS -C -Q -B DB2DIR" DOES NOT LIST ALL MISSING PREREQUISITES |
|
LI73595 |
3 |
SUPPORT OF NONCANONICAL HOSTNAME ON THE 2ND COULUMN OF DB2NODES.CFG FOR DB2IUPDT COMMAND |
|
IZ30807 |
3 |
DB2 ADMINISTRATION SERVER (DAS) SERVICE IS NOT REMOVED DURING THE UNINSTALLATION OF A NON-DEFAULT DB2 COPY. |
|
JR30005 |
3 |
ON IBM DATA SERVER CLIENT, SQL1065W WARNING MESSAGE COMES UP ON SUBMITTING DB CREATION DUE TO NO "DB2ATS_SPS.BND" |
|
IZ23662 |
3 |
MISSING HA/XML SAMPLES FILES IN CUSTOMER BUILD |
|
IZ30300 |
3 |
DB2 V95: POST CLIENT INSTALL SHOWS EXT SEC SETUP EVEN IT WAS NOT SET IN A NON-ADMIN DB2 INSTALL |
|
IZ28711 |
3 |
COMMANDS "DB2LN -W" OR "DB2LN" DO NOT MAKE LINKS TO /USR/INCLUDE. |
|
IZ32768 |
3 |
DB2 DEFAULT COPY SWTCH WIZARD DOES NOT DISPLAY THE DETAILS OF A UPGRADED DSDRIVER OR RTCL COPY CORRECTLY |
|
IZ30770 |
3 |
INVALIED .NET DATA PROVIDER REGISTRY KEY VALUE FOR V95 DB2 AND/OR DSDRIVER |
|
JDBC |
|
JR30369 |
1 |
JCC TYPE 4 CONNECTION HANGS WHEN GOING TO A DB2 CONNECT TO A ISERIES (V6R1) |
|
JR30534 |
1 |
MEMORY LEAK IN VECTOR FIELD OF COM.IBM.DB2.JCC.AM.CONFIGURATION,SUBCLASS OF COM.IBM.JCC.DB2BASEDATASOURCE |
|
IZ28794 |
2 |
IBM DB2 DRIVER FOR JDBC AND SQLJ TRUNCATES TRAILING ZEROS WHEN RETRIEVING STRING VALUE FOR TIMESTAMP BY RESULTSET.GETSTRING(). |
|
JR30620 |
2 |
CSTMT.SETOBJECT(INT, CHARDATA) AND CSTMT.SETSTRING(CHARDATA) FAILED IF CHARDATA IS GREATER THAN 32KB |
|
IZ22295 |
3 |
AFTER DB2 SERVER RETURNS ABNUOWRM MESSAGE FOR SQL0911 ERROR, JCCDRIVER BLOCKS ALL LOCAL TRANSCATIONS WITH ERRORCODE=-4497. |
|
IZ32618 |
3 |
DEADLOCK SITUATION OBSERVED WHEN TWO OR MORE BATCH PROGRAMS RUN CONCURRENTLY ON SERVER WAS XA EDITION. |
|
JR29617 |
3 |
JCC DRIVER PROPERTY DOWNGRADEHOLDCURSORSUNDERXA=TRUE CLOSING CURSOR FOR XA LOCAL TRANSACTIONS RESULTING IN -4470 |
|
Monitoring |
|
IZ33396 |
1 |
DB2_EVMON_STMT_FILTER DOES NOT RECOGNIZE COMMANDS WHEN ONLY 1 EVMON IS SPECIFIED. |
|
IZ18587 |
2 |
PROBLEM ABSTRACT: SEVERE MSGS IN DB2DIAG.LOG, SQLMHMONCOLLHISTREADHEADER, PROBE:20 (INVALID HISTORY VERSION IN HEADER) |
|
IZ22763 |
2 |
THE APPLICATION STATUS WITHIN AN APPLICATION SNAPSHOT TAKEN ON ANON-COORDINATING NODE DOES NOT MAKE SENSE. |
|
IZ24040 |
2 |
DCS APPLICATION SNAPSHOT REPORTING INACCURATE STATEMENT COUNTS |
|
IZ32963 |
2 |
HEALTH INDICATOR IS CALCULATING WRONG VALUES FOR TRANSACTION-LOGSPACE USAGE. |
|
IZ33736 |
2 |
A FULL DATABASE RESTORE AND SNAPSHOT MONITORING IN PARALLEL CAN BRING DOWN INSTANCE |
|
IZ35821 |
2 |
LOCK NAME NOT FORMATTED CORRECTLY IN DEADLOCK EVENT MONITOR OUTPUT |
|
LI73763 |
3 |
PERCENT_WRITES_ASYNC IS 0 IN SYSIBMADM.BP_WRITE_IO VIEW |
|
IZ36494 |
3 |
ON VERY BUSY DPF SYSTEMS MAIN THREADS LIKE DB2FCMR/DB2FCMS CAN GET CPU STARVED |
|
IZ37776 |
3 |
REMOVING DEBUG LINE FROM GOVERNOR DOES NOT STOP DEBUGGER |
|
IZ27982 |
3 |
DYNAMIC_SQL SNAPSHOT STATEMENT ON MULITPLY DATABASE GETS WRONG VALUE FOR SQLM_ELM_DB_NAME (DATABASE NAME) |
|
IZ21361 |
3 |
DB2LOOK INCORRECTLY SHOWING THE NO FILE SYSTEM CACHING CLAUSE FOR TABLESPACES |
|
LI73004 |
3 |
UNWANTED MESSAGES BEING DUMPED IN THE LOG FILE FOR A FEW HEALTH INDICATORS. |
|
IZ18067 |
4 |
UNNECESSARY CODEPAGE CONVERSION FOR SQLM_ELM_CONSISTENCY_TOKEN MONITOR ELEMENT, LEADS TO SQLO_DBCSTRUNC MESSAGE IN DB2DIAG.LOG |
|
Performance |
|
IZ31230 |
3 |
INACCURATE TIMING RESULTS BEING REPORTED WITH DB2BATCH. |
|
Problem Determination |
|
IZ13844 |
2 |
ADDITIONAL DIAGNOSTICS FOR CORRUPTION PROBLEMS |
|
LI73732 |
2 |
PD_GET_DIAG_HIST STORED FUNCTION RETURNS WRONG RESULTS |
|
IZ32884 |
2 |
WHEN DB2 IS UNLOADED, LIBDB2OSSE IS STILL BEING HELD WITH CICS |
|
IZ35650 |
2 |
DB2PD -DBCFG SHOWS INCORRECT VALUE FOR PATH TO LOG FILES (DISK) |
|
JR29990 |
3 |
USERS IN DB2USERS GROUP CANNOT COLLECT DB2SUPPORT.ZIP FILE ON WINDOWS |
|
IZ17153 |
3 |
ADD FUNCTIONALITY TO DB2FODC TO COLLECT DIAGNOSTIC INFORMATION FOR NON-SEVERE PERFORMANCE RELATED PROBLEMS. |
|
IZ26167 |
3 |
MISALIGNMENT IN DB2PD OUTPUT |
|
IZ30055 |
3 |
DB2PD -DBCFG DOESNT LIST THE AUTO_STMT_STATS PARAMETER |
|
Query Compiler, Rewrite, Optimizer |
|
LI73381 |
1 |
INSTANCE MAY TRAP WITH SEGMENTATION FAULT WHILE EVALUATING AN MQT FOR POSSIBLE USE. |
|
IZ35050 |
1 |
FETCH FIRST 1 ROW WITH ORDER BY CAN LEAD TO INCORRECT RESULTS ON SYMMETRIC MULTIPROCESSOR (SMP) MODE. |
|
LI73543 |
2 |
DB2 SERVER CRASHES OR INSERTS INCORRECT VALUE WHEN USING DEFAULTVALUE FOR A NON-UPDATABLE VIEW |
|
JR30604 |
2 |
SQL1585N, SQLSTATE=54048 MAY OCCUR FOR EXTREMELY LONG SQL STATEMENTS WITH TOO MANY COLUMN EXPRESSIONS INVOLVED. |
|
IZ22373 |
2 |
BETTER FIRST JOIN PAIR WHEN USING FAST JOIN ENUMERATION ON QUERYWITH MANY TABLES AND TRANSITIVE JOIN PREDICATE NOT FILTERING ROW |
|
IZ29952 |
2 |
UNARY MINUS OR UNARY PLUS OF A DECIMAL VALUE HAS DECFLOAT RESULTWHEN NUMBER DATA TYPE IS ENABLED |
|
IZ33709 |
2 |
ERROR SQLO_BUFFSMALL CAN BE RETURNED WHEN COMPILING A QUERY |
|
IZ30030 |
2 |
DB2 INSTANCE MAY ABEND WHILE RUNNING THE DB2 DESIGN ADVISOR INDEX RECOMMENDATION MODE |
|
IZ20563 |
2 |
AN IN-LIST PREDICATE MAY NOT BE OPTIMIZED COMPLETELY WHEN DIFFERING LENGTH STRING LITERALS ARE USED. |
|
JR28916 |
2 |
SQL1585N COMPILING QUERY THAT INCLUDES A SUBQUERY IN A PREDICATE |
|
IZ31261 |
2 |
INCOMPLETE INITIALIZATION FOR INTERNAL COLUMN STATISTICS MAINTENANCE DATA STRUCTURES MIGHT LEAD TO A DB2 SERVER ABEND |
|
IZ31890 |
2 |
THE XQUERY USES UNION MIGHT RETURN INCORRECT OUTPUT. |
|
IZ28701 |
2 |
WITH THE PREFIX G OR N FOR CHARACTER LITERAL, THE PARSER DOES NOT ACCOUNT FOR ESCAPE CHARACTER ('). |
|
IZ27663 |
2 |
POTENTIAL QUERY PERFORMACE PROBLEM WITH DB2_REDUCED_OPTIMIZATIONAND DB2_WORKLOAD=SAP. |
|
IZ28612 |
2 |
-901 REASON "ORASTRINGMODE 0-LEN STR FOUND, INPUTZTYPE=0X100, INPUTFIELDNUM=0" |
|
LI73609 |
2 |
DB2 V9.5 FP1:EXPLAIN TABLES DOES NOT STORE INLIST VALUES. |
|
LI73587 |
2 |
A DB2 DPF INSTANCE ABENDS WHEN RUNNING A QUERY CONTAININING A UNION ALL CLAUSE THAT IS JOINED TO ANOTHER TABLE/SUBSELECT |
|
IZ26864 |
2 |
DB2ADVIS MAY CAUSE THE DB2 CRASH WHILE RECOMMENDING INDEXES |
|
IZ29365 |
2 |
ENGINE DOWN, RECEIVEING A SIGNAL #11 AT SQLOCRASHONCRITICALMEMORYVALIDATIONFAILURE |
|
IZ29704 |
2 |
DB2 CAN ABEND WHEN QUERY CONTAINS AN EXISTS PREDICATE IN A WHERECLAUSE AND THE FROM CLAUSE REFERENCES A SUB-SELECT WITH GROUP BY |
|
JR30616 |
2 |
SELECT/UPDATE/DELETE IN EMBEDDED SQL MAY FAILED WHEN USING HOST VARIABLE IN A WHERE CLAUSE WHOSE REMOTE TYPE IS BINARY |
|
LI73738 |
2 |
RUNNING A QUERY CONTAINING A PREDICATE USING A MAX/MIN AGGREGATEON A CONSTANT MAY CRASH THE INSTANCE (ONLY IN FIX PACK 5.) |
|
LI73593 |
2 |
MEMORY CORRUPTION IN STATEMENT HEAP LEADS TO A CRASH WHEN THE FIRST PART OF A 3 PART NAME IN A QUERY IS NOT THE DB NAME |
|
IZ31245 |
2 |
IN A SPECIFIC DATABASE CONFIGURATION SQL0901N "PARENT POINTER IS NOT NULL" CAN BE RETURNED WHEN DISTINCT TYPE IS USED |
|
JR28996 |
2 |
TO_CHAR OR VARCHAR_FORMAT ON A NICKNAME CAUSES HANG, NO QUERY RESULTS, OR SQL0100W |
|
LI73583 |
2 |
VISUAL EXPLAIN WILL CRASH WHEN A TABLE WITH A XML INDEX WITH DETAILED STATISTICS IS EXPLAINED. |
|
IZ26494 |
2 |
INSTANCE CRASH FOLLOWING ALTER TABLE |
|
IZ30210 |
2 |
PERFORMANCE DEGRADATION WITH EARLY DISTINCT PUSH DOWN |
|
IZ31350 |
2 |
SQL QUERY TAKES LONGER TO COMPILE ON DB2 VERSION 9.5 COMPARED TO THE SAME QUERY ON EARLIER VERSIONS |
|
IZ31655 |
2 |
TABLE PACK DESCRIPTOR CORRUPTION BY STATISTICS FABRICATION IN REAL-TIME-STATISTICS FEATURE. |
|
LI73148 |
2 |
IMPROVE FILTER FACTOR ESTIMATES FOR PREDICATES ON OLAP FUNCTION ROW_NUMBER() |
|
JR29109 |
2 |
-180 SQLCODE WHEN ISSUING SELECT WITH IN CLAUSE CONTAINING DATE FIELD FROM REMOTE Z/DB2 EMBEDDED SQL APPLICATION |
|
LI73730 |
2 |
DB2 MAY ABEND WITH XMLTABLE FUNCTIONS REFERENCING A TABLE WITH UNIQUE INDEX |
|
IZ26278 |
2 |
ONLY ON UNIX, SCALAR FUNCTION "LOCATE" PRODUCES WRONG RESULTS WHILE CASTING THIRD PARAMETER AS SMALLINT. |
|
IZ25220 |
2 |
THE DB2 QUERY OPTIMIZER MIS-ESTIMATES THE FILTER FACTOR OF LIKE AND NOT LIKE PREDICATES UNDER CERTAIN CONDITIONS |
|
LI73555 |
2 |
SQL0901 WITH REASON "DON'T KNOW HOW TO RESOLVE SIBLING CONFLICTS" DOING DELETE ON TABLE WITH FOREIGN KEY DESCENDANTS |
|
IZ35372 |
2 |
QUERY USING DISTINCT CLAUSE MAY FAIL WITH SQL0901N ERROR "BASE TABLE HAS NEGATIVE CARDINALITY" |
|
IZ22947 |
2 |
ENABLE BRANCH ELIMINATION ON UPDATE STATEMENTS ON UNION ALL VIEW |
|
JR30276 |
2 |
SQL0901N IS RETURNED WHEN AN SQL STATEMENT MODIFIES A TABLE AND CONTAINS MULTIPLE REFERENCES TO A VIEW OVER THE SAME TABLE |
|
IZ32946 |
2 |
WRONG RESULTS MAY BE RETURNED WHEN A COMMON TABLE EXPR. CONTAINING A GROUP-BY (GB) IS USED WITH DISTINCT AND OUTER JOIN (OJ) |
|
JR30285 |
2 |
DB2 MEMORY LEAK WHEN COMPILING XML STATEMENTS, MOST SEVERE WHEN USING HEALTH_MONITOR, AUTOMATIC MAINTENANCE, OR USING XML |
|
JR29985 |
3 |
SQL0158N ERROR OCCURS WHEN SUBSELECT WITH WITH STATEMENT IS USED WITH ORDER BY INPUT SEQUENCE CLAUSE |
|
IZ33173 |
3 |
DB2 INSTANCE ABENDS PROCESSING CREATE TABLE STATEMENT |
|
IZ35643 |
3 |
CREATE DIAGNOSTIC MESSAGE EXP0045W |
|
IZ21377 |
3 |
DB2 OPTIMIZER MAY SELECT SUB-OPTIMAL PLAN, WHERE THE TOTAL COST OF THE SUB-OPTIMAL PLAN IS WORSE THAN THE OPTIMAL PLAN |
|
IZ26830 |
3 |
THE XMLQUERY WITH . USED IN THE CONTEXT "RETURN DOCUMENT{.}" COULD RETURN THE INCORRECT RESULT. |
|
JR29427 |
3 |
IMPROVEMENT TO COALESCE AND VALUE SCALAR FUNCTION PROCESSING |
|
JR30903 |
3 |
VARIABLES IN TRIGGERS NOT PUSHED DOWN TO REMOTE DATA SOURCE |
|
IZ23005 |
3 |
QUERY WITH 'TABLESAMPLE SYSTEM(1)' FROM MDC TABLE WITH 100000+ ROWS GETS WRONG RESULTS. |
|
Relational Data Services |
|
IZ29787 |
1 |
DB2 V9.5 SIGNAL 11 IN SQLRW_SET_CURRENT_ACTIVITY_PUSH DUE TO NULL POINTER |
|
IZ24400 |
1 |
DB2 INSTANCE CRASH (SIGSEGV) AND DATABASE ABENDS WITH SQL0902N AFTER ALTER TABLE ... DROP PRIMARY KEY STATEMENT |
|
IZ14288 |
1 |
FREQUENT SQLESETI() OR SETDB2CLIENT TYPE API CALLS IN APPL. CAUSING EXTENDED COMPILING STATE AND CONSUMING HIGH CPU |
|
IZ33059 |
1 |
SIGNAL #5 IN SQLRISECTINITIALIZECOMPLEX OR OTHER TRAPS IN SECTION EXECUTION |
|
LI73626 |
1 |
-901 (INVALID LIST ENTRY WITHOUT VAR) SQLCODE, TRIGGERS TEMPORARY HANG SITUATION |
|
IZ32785 |
1 |
VARIOUS ISSUES CAN HAPPEN WHEN 2ND ARGUMENT OF THE AGGREGATE FUNCTION HAS AN EXPRESSION, BUT THE FIRST ONE DOES NOT. |
|
IZ25934 |
2 |
DB2 AGENT PROCESS MAY GET SIGNAL 11 AND THEN CAUSE DB2 INSTANCE CRASH. |
|
IZ23777 |
2 |
DB2 CRASHES WITH SQL1224N ERROR MESSAGE WHILE RUNNING AN XQUERY TRANSFORM STATEMENT WHICH USES AN OUT OF SCOPE COPY. |
|
IZ22897 |
2 |
INSTANCE CRASH DURING INDEX AND'ING ON MDC TABLE. |
|
IZ30773 |
2 |
MEMORY CORRUPTION BY DB2EXPLN LEADS TO INSTANCE TO CRASH WITH ASIGNAL #11 |
|
IZ33306 |
2 |
CONNECT TO DATABASE FAILS AFTER A ROLE, WHICH HAS ACQUIRED USAGE ON WORKLOAD PRIVILEGE, IS DROPPED |
|
IZ24364 |
2 |
UNEXPECTED LOCK-WAITS ENCOUNTERED WHILE ACCESSING RANGE PARTITIONED TABLES FROM CONCURRENT APPLICATIONS |
|
IZ26836 |
2 |
WILL REWRITE |
|
IZ30222 |
2 |
INCORRECT RESULTS GIVEN WHEN USING XMLPARSE FUNCTION TO PARSE XML DATA INTO A COLUMN WHICH IS TO BE SORTED DURING INSERT/UPDATE. |
|
IZ23838 |
2 |
NEW RESTRICTION ADDED WHEN DROPPING NODES FROM A DATABASE PARTITION GROUP |
|
LI73582 |
2 |
MQT TABLES DEPENDENT ON SYSIBM.SYSDUMMY1 AND SYSIBM.SQLTABLETYPES CATALOG VIEWS DROPPED DURING MIGARATION |
|
IZ26272 |
2 |
INSTANCE SUSPENDED WITH SIGNAL 5 DUE TO OUT OF MEMORY FAILURE ON APPLICATION MEMORY (APPLHEAPSZ) |
|
IZ20724 |
2 |
POOR PERFORMANCE WHEN COMPILING A QUERY THAT CONTAINS AN IN-LISTWITH MANY PREDICATES. |
|
IZ26790 |
2 |
DATABASE CRASHES IF THERE IS A FILE ERROR AND AUTONOMIC STATISTICS PROFILING IS ENABLED. |
|
IZ26498 |
2 |
DB2CAT FAILS TO GENERATE A NEW PACKED DESCRIPTOR (-G OPTION) IF TABLE HAS AN IDENTITY COLUMN |
|
LI73706 |
2 |
SIGNAL #11 IN SQLDDCOPYDDWHEN A SQL STORED PROCEURE IS RAN UNDER SPECIFIC CONDITIONS |
|
IZ20681 |
2 |
MEMORY LEAK IN CATALOG CACHE IN DPF ENVIRONMENT WHEN EXECUTING DDL WITH UNIQUE TABLE NAMES |
|
IZ26478 |
2 |
LOCK/LATCH "DEADLOCKED" WITH EACH OTHER, CAUSED UDP CALL AND OLRWAITING FOR EACH OTHER |
|
IZ21573 |
2 |
CATALOG CACHE HIGH WATER MARK REPORTS INCORRECT VALUE IN DATABASE SNAPSHOT |
|
IZ26112 |
2 |
DB2CAT EXECUTION RETURNS SQL ERROR SQL0304N |
|
IZ30583 |
2 |
TIMESTAMP_FORMAT() CAN GIVE INCORRECT RESULTS FOR MICROSECONDS(FF) FORMAT ELEMENT |
|
IZ25756 |
2 |
SLOW PERFORMANCE DURING QUERY COMPILATION |
|
IZ24373 |
2 |
CATALOG CACHE DEADLOCKS DETECTED WHILE ACCESSING RANGE PARTITIONED TABLES FROM CONCURRENT APPLICATIONS. |
|
IZ23815 |
2 |
DROP INDEX EXTENSION STATEMENT HAS INCOMPLETE ERROR HANDLING WHICH MAY LEAD TO ORPHAN ROWS. |
|
IZ31687 |
2 |
INDEX PREFETCH SIZE IS SET TO BE THE SAME AS THE TABLE PREFETCH SIZE IN PD AFTER ADDING A CONTAINER TO TABLE'S TABLESPACE |
|
LI73309 |
3 |
SQL0973W RETURNED FOR THE APPGROUP_MEM_SZ HEAP IN A DPF ENVIRONMENT. |
|
IZ26649 |
3 |
DB2EXPLN CAN NOT EXECUTE DUE TO LACK OF SHARED LIBLAY FILES. |
|
IZ32601 |
3 |
DB2PD -RDSAPPLCB INCORRECTLY DISPLAYS "ROLE AUTH BITMAP" DESCRIPTOR |
|
IZ25991 |
3 |
XML TRANSFORM EXPRESSION RESULTS IN SQL16082N ERROR. |
|
IZ31210 |
3 |
WLM THRESHOLDS CAN BE CREATED FOR DEFAULT SYSTEM AND MAINTENANCE CLASSES |
|
IZ28986 |
3 |
NEED TO ALLOW FOR BINDIN FROM CLOB LOCATORS TO XML |
|
IZ32594 |
3 |
DB2CKMIG SUCCEEDS BUT WRITES ERRORS IN LOG |
|
IZ22455 |
3 |
UNNECESSARY DB2DIAG.LOG ENTRIES IN THE ERROR PATH. |
|
IZ21193 |
3 |
RENAME TABLE DOES NOT UPDATE SYSCAT.COLGROUPCOLS CATALOG TABLE ENTRIES. |
|
IZ30287 |
3 |
DB2CKMIG SUCCEEDS BUT WRITES ERRORS IN LOG |
|
IZ25331 |
3 |
IN DPF ENVIROMENT QUERIES USING "CURRENT OPTIMIZATION PROFILE" AND RUN ON NON-CATALOG NODE WILL GET A WRONG RESULT. |
|
IZ30153 |
3 |
IN WLM ENVIRONMENT, A QUEUING THRESHOLD DEADLOCK SCENARIO GENERATES SQL0911 RC=68 ERROR IN DB2DIAG.LOG INCORRECTLY. |
|
Replication |
|
JR30554 |
2 |
REPLICATION CENTER RUNNING ON DB2 V9.5 FP2 CREATES IBMQREPVERNODE AND IBMQREPVERTIME IN UPPER CASE (NOT MIXED CASE) |
|
JR29498 |
3 |
REPLICATION ENGINE FIXES FOR DB2 LUW V9.5 FP3 |
|
JR29499 |
3 |
REPLICATION ADMIN FIXES FOR DB2 LUW V9.5 FP3 |
|
Security |
|
IZ32521 |
2 |
ON WINDOWS, IF THE AUDIT DATA PATH IS A NETWORK SHARED DIRECTORY, DB2 AUDIT ARCHIVE FAILS, CAUSING THE SERVER TO HANG. |
|
IZ30997 |
2 |
SYSFUN.USERS_GROUPS TABLE FUNCTION ABNORMALLY TERMINATES WITH SQL0430N. |
|
IZ32436 |
3 |
MEMORY LEAK IN APPLICATION HEAP IF DB2AUDIT CATEGORY EXECUTE IS ENABLED. |
|
IZ33183 |
3 |
USING TRUSTED CONTEXT CONNECTION, A 'CONNECT RESET' AUDIT RECORD IS BEING GENERATED WHEN THE USER IS SWITCHED |
|
Self Tuning Memory Manager |
|
IZ26663 |
2 |
STMM FREE MEMORY TARGETS ARE TOO HIGH WITH NON_AUTOMATIC INSTANCE_MEMORY SETTING |
|
JR30220 |
1 |
TRAP WITH "DOUBLE FREE." AFTER SQLERRETURNFMPTOPOOL, SQLERCLEANTHREADRESOURCE, SQLERREMOVEALLIPCFORROW IN DB2DIAG.LOG |
|
IZ22700 |
2 |
DB2 MAY CRASH WHEN A FMP(FENCED MODE PROCESS) IS TERMINATED ABNORMALLY. |
|
LI73461 |
2 |
"SQLRR_EXECUTE: PUCSTPINFO IS NULL FOR CALL" WHEN DYNAMIC CALL FEDERATED SP IN A SP. |
|
IZ29966 |
2 |
SQL PROCEDURE RETURNS SQLCODE -901 AFTER MIGRATION OR UPGRADE TO VERSION 9.5 |
|
JR29951 |
2 |
MEMORY REQUIREMENT FOR DB2FMP PROCESS ON 64-BIT AND 32-BIT DB2 VERSION 9.5 HAS INCREASED. |
|
IZ29543 |
2 |
-20139 ERROR WHEN SQL STORED PROCEDURE IS INTERRUPTED |
|
IZ25636 |
2 |
POTENTIAL TRAP IN SNAPSHOT ERROR HANDLING DUE TO MISSING FILE NAME. |
|
IZ31414 |
2 |
CRASH IN DB2 CALLING SQL SP COMPILED IN V8.1 WITH DEBUG MODE |
|
IZ18110 |
3 |
SQL1131N ERROR WHEN INVOKING MICRO FOCUS COBOL STORED PROCEDURE THAT PERFORMS I/O OPERATION ON AIX. |
|
Text Search |
|
IZ35644 |
2 |
DB2 TEXT SEARCH: QUERIES WITH NOT OPERATOR MAY RESULT IN INCOMPLETE RESULTSET |
|
XML Data Services |
|
IZ23066 |
1 |
CONCURRENCY PROBLEM WITH DB2 LATCHES ON TABLE WITH XML COLUMN |
|
IZ33223 |
2 |
DB2 CRASHES DUE TO AN ERROR IN HANDLING LARGE DOCUMENTS SPLIT ACROSS MULTIPLE PAGES WHEN OBTAINING NAMESPACES |
|
IZ35824 |
2 |
THE SQL STATEMENT LENGTH MAXIMUM FOR DECOMPOSITION REMAINS AT 64K FOR THE SUN SOLARIS PLATFORM. |
|
JR30060 |
2 |
UNKNOWN PI LIKE <?SIEBEL ARE NOT IGNORED BY XML DECOMPOSE |
|
IZ30137 |
2 |
LOW PERFORMANCE SEEN FOR XQUERIES WITH ATTRIBUTE-ONLY STEPS |
|
IZ32544 |
2 |
DB CRASHES FROM XQUERY WITH FN:ROOT AND PARENT::NODE FUNCTION USED TOGETHER |
|
IZ14938 |
3 |
XML FILES LARGER THAN 100 MB CAN'T BE SHREDDED. |
|
IZ13462 |
3 |
XMLTABLE STATEMENT RUNS INTO INFINITE LOOP ON LARGE CUSTOMER DOCUMENT |
|
IZ28778 |
3 |
FOR CERTAIN SQL/XML QUERIES, NULL IS RETURNED INCORRECTLY. |
|
IZ24320 |
3 |
INCORRECT RESULTS RETURNED FROM XQUERY FOR CHARACTERS 
 AND 
 |
APAR fixes included in Fixpak 2 | APAR No. | Sev. | Abstract |
|
Administration Tools |
|
IZ25027 |
2 |
DB2LOOK VERSION NUMBER IN THE HEADER HAS BEEN DISPLAYED OUTSIDE THE DOUBLE QUOTES |
|
IZ19528 |
2 |
LONG DB2LOOK RUNTIME WITH OPTION -L IN DB2 DPF ENVIRONMENT |
|
IZ12690 |
2 |
THE DEFINITION OF AN UDF RETRIEVED VIA "DB2LOOK" COMMAND MIGHT NOT BE CORRECT IN A DB HAVING CODESET OF "UTF-8". |
|
IZ12638 |
2 |
SUPPORT OF DB2CLI EXECUTABLE FOR THINCLI DRIVER. |
|
IZ21731 |
2 |
DB2LOOK WAS NOT GENERATING THE RUNSTAT ON VIEW DDL SPECIFIED WITH '-M' AND '-V' OPTION. |
|
LI73326 |
2 |
DB2LOOK DOES NOT PLACE DOUBLE QUOTES AROUND TABLESPACE NAMES FOR TYPED TABLES. |
|
IZ29100 |
3 |
ACTION NICE NOT SUPPORTED IN GOVERNOR CONFIGURATION |
|
JR30166 |
3 |
"COMMENT ON" IN DB2LOOK WONT WORK IF THE DATABASE CONTAINS OVERLOADED FUNCTIONS. |
|
IZ16397 |
3 |
DB2ADVIS FAILS WITH ERROR CODE -106 IF A SUBMITTED SQL STATEMENTCONTAINS TAB CHARACTERS |
|
LI73731 |
3 |
DB2LOOK GENERATED SQL CODE GIVES ERROR SQL0206N, WHEN SQL COMMENT '--' IS USED AND LINES 70+ CHARATERS LONG |
|
IZ26571 |
3 |
DB2LOOK GENERATE WRONG INFO WHEN ALTER UNIQUE/FOREIGN CONSTRAINT OF NICKNAME |
|
IZ24814 |
3 |
MESSAGE TEXT NEEDS TO BE ADDED IN THE MRI FILE |
|
IZ29581 |
3 |
DB2LOOK DOES NOT GENERATE THE DDL STATEMENT IF THE SCHEMA, AND TABLE NAMES AND/OR VIEW NAMES ENCLOSED BY "\ ARE BOTH SPECIFIED |
|
IZ28323 |
3 |
DB2SUPPORT IS NOT GENERATING BUFFERPOOL INFORMATION |
|
IZ29699 |
3 |
NLV: [JAPANESE] A BAD FORMAT MESSAGE IN EMSG\DB2LOOK.SRC |
|
IZ09719 |
3 |
SQL0551N ERROR WHILE RUNNING DB2ADVIS COMMAND. |
|
JR28557 |
3 |
FOR ACCEPTING THE EXTRA SPACE IN CALL SYSPROC.AUTOMAINT_SET_POLICY |
|
Application Programming Services |
|
JR29418 |
2 |
SQL0083C ERROR WHEN EXECUTING DB2 BIND COMMAND. |
|
IZ15335 |
2 |
COMPOUND IMPORT RETURNS INPROPER RC=2 AND SQL3149N MESSAGES WITH CLIENT REROUTE IF SERVER COMMUNICATION FAILURE OCCURS |
|
IZ22378 |
2 |
CREATE FUNCTION STATEMENT IN EMBEDDED C CAUSES SQL0104N DURING PRECOMPILE. |
|
IZ07395 |
3 |
DB2DCLGN GENERATES WRONG DESCRIPTION FOR THE DECIMAL (P,S) COLUMN WHEN P=S FOR COBOL LANGUAGE |
|
Buffer Pool Services |
|
IZ16010 |
2 |
INSTANCE CRASH DUE TO SIGSEGV WHILE DROPPING TEMPORARY TABLE |
|
IZ16049 |
2 |
STANDBY DB WILL LOSE UPDATES (LOSE DATA) WHEN CONTAINER UNAVAILABLE AND TAKEOVER HAPPENED. |
|
LI73168 |
2 |
DB2RELOCATEDB DOES NOT CHANGE DATABASE NAME IN AUTOMATIC STORAGEPATHS WHEN INSTANCE NAME IS ALSO CHANGED |
|
IZ14304 |
2 |
DB2 REBALANCER RUNGS LONGER ON V9 DUE TO THE INCREASE IN THE TABLE CONTROL BLOCK TO INCREASE LIMIT ON NO. OF CONTAINERS. |
|
IZ14166 |
2 |
PROVIDE INCREASED CONCURRENCY TO PARALLEL RECOVERY FOR LOG RECORDS ASSOCIATED WITH ADDING AN EXTENT TO A TABLE |
|
LI73417 |
2 |
DB2BACKUP API PARAMETER ICALLERACTION WITH VALUE DB2BACKUP_PARM_CHK_ONLY DOES NOT HANDLE THE IPARALLELISM OPTION |
|
LI72811 |
3 |
INCORRECT CONTAINER NAME REPLACEMENT BY DB2RELOCATEDB WHEN REGULAR CONTAINERS ARE PART OF AUTOMATIC STORAGE PATHS |
|
IZ16021 |
3 |
UNABLE TO RESTORE TABLESPACE PREVIOUSLY SHRUNK TO MINIMUM SIZE. |
|
IZ15746 |
3 |
AFTER USING DB2RELOCATEDB TO RENAME A DATABASE YOU MIGHT GET ERROR SQL1013N OR SQL30061 TRYING TO CONNECT TO ANOTHER DATABASE |
|
IZ16114 |
4 |
CHANGE UNIX TABLESPACE CONTAINER PATH PERMISSIONS TO 711 |
|
Client |
|
JR29239 |
2 |
CLR STORED PROCEDURE DEPLOYMENT TO VERSION 9 DATABASES FAILS USING VISUAL STUDIO 2003 TOOLING |
|
LI73159 |
2 |
DB2 CLIENT V9.1 ADD-INS FOR MICROSOFT VISUAL STUDIO 2005 FAILS ON INSTALLATION 64-BIT WINDOWS. |
|
JR28431 |
3 |
SECURITY VULNERABILITY IN DEPLOYMENT OF CLR STORED PROCEDURES FROM IBM DATABASE ADD-INS FOR VISUAL STUDIO |
|
Client Interfaces |
|
JR29195 |
1 |
CALLING A DB2 ZOS SP MAY FAIL WITH CLI0125E FUNCTION SEQUENCE |
|
IZ18508 |
1 |
CLP TRAPS ON CALLING A Z/OS STORED PROCEDURE |
|
IZ22867 |
2 |
THE SIGNATURE OF IFXCONNECTION.GETIFXBLOB IS INCORRECT. |
|
IZ24052 |
2 |
OUTPUT PROBLEM ON SOME SPECIAL CHARACTERS |
|
IZ24813 |
2 |
CLI RETURNS THE CORRECT VALUE BUT WRONG INDICATOR VALUES FOR DECIMAL VALUES |
|
IZ16882 |
2 |
ALLOW WITH RS USE AND KEEP UPDATE LOCKS SYNTAX FOR A SELECT FOR UPDATE STATEMENT. |
|
IZ27943 |
2 |
LOAD DATA FROM MAINFRAME TO UDB SERVER USING CURSORS HAVE INVALID DATE 00/00/0000 INSERTED |
|
IZ25221 |
2 |
CLI RE-EXECUTE OF A STATEMENT FAILING WITH SQL0301 DOES NOT KICKIN, WHEN STATEMENT CHAINING IS TURNED ON |
|
IZ22787 |
2 |
ADVANCED PROPERTIES DIALOG - PROVIDE MISSING PROPERTY DESCRIPTIONS |
|
JR28771 |
2 |
PATH FOR 64-BIT MQ LIBRARIES WITH FEDERATION SERVER SHOULD NOT REQUIRE /USR/LIB FOR INSTALL |
|
IZ24799 |
2 |
MEMORY OVERWRITE IN STATIC CLI CAPTURE FACILITY LEADING TO CRASH |
|
JR28445 |
2 |
MICROSOFT EXCEL DOES NOT WORK WITH FILEDSN |
|
IZ15129 |
2 |
SQLGETPOSITION() FAILS WITH DBCLOB DATATYPE IN UNICODE Z/OS DATABASE |
|
IZ09993 |
2 |
CLI_DB2SCHEMA_SQLCOLUMNS() DOES NOT HANDLE CLISCHEMA NAME CORRECTLY. |
|
IZ29578 |
2 |
THE "MIN POOL SIZE" CONNECTION STRING KEYWORD HAS NO EFFECT ON .NET CONNECTION POOLING. |
|
IZ29961 |
2 |
DRDA CHAINING WAS NOT SUPPOSED TO BE ENABLED FOR IDS SERVERS WITH RELEASE BEFORE 11.5. |
|
IZ28246 |
2 |
SQL0104 WHEN CALLING STORED PROCEDURE WITH A SEMI-COLON |
|
JR29343 |
2 |
UNABLE TO DISPLAY SERIALIZED EXCEPTION MESSAGES WITHOUT FIRST ESTABLISHING DATABASE CONNECTION |
|
IZ21346 |
2 |
CLI0125E RETURNED BY SQLEXTENDEDBIND ON SECOND CALL AFTER SUCCESSFUL SQLEXECUTE EXECUTION |
|
JR29256 |
2 |
NOT POSSIBLE TO INSERT STREAMS OF LENGTH=0 INTO A BLOB COLUMNS |
|
IZ23103 |
2 |
CALLING ZOS STORED PROCEDURE WITH REAL OUTPUT PARAM RETURNS -413 ERROR IN CONVERSION |
|
JR29420 |
2 |
RECOGNIZE THE ISOLATIONLEVEL SET IN TRANSACTION.CURRENT.ISOLATIONLEVEL |
|
JR28622 |
2 |
SQL1159 RC=7 WITH TESTCONN20.EXE ON 64-BIT PLATFORM WITH 32-BIT .NET DRIVER |
|
JR28919 |
2 |
POTENTIAL CRASH OR DATA CORRUPTION USING THE MQ UDFS AND CLOBS. IF THE LENGTH OF A CLOB OUTPUT PARAMETER IS LESS THAN 1M |
|
JR29953 |
2 |
DB2 CLI DRIVER NEEDS TO ISSUE AN IMPLICIT COMMIT AFTER SENDING SET OPERATIONS FOLLOWING A CONNECT OPERATION. |
|
JR29260 |
2 |
COMMONCLIENT DOES NOT ACCEPT CURLY BRACKETS {} AS COMMENT SYMBOLS |
|
IZ29629 |
2 |
SQLTABLES API WILL CRASH ON LINUXIA32 PLATFORM |
|
IZ24755 |
2 |
ENABLING CLI (RUNTIME CLIENT AND IBM DATA SERVER DRIVER FOR ODBC AND CLI) SUPPORT FOR ISERIES V6R1 |
|
IZ15143 |
2 |
JCC DRIVER USING TYPE 2 CONNECTIVITY ABNORMALLY TERMINATES AFTER CLIENT REROUTE |
|
IZ18908 |
2 |
WHEN CONNECTED TO ISERIES V5R1-V5R3 FROM A DB2 CLIENT CALLING SQLPROCEDURECOLUMNS RECEIVE SQL0206;SPECIFIC_NAME NOT VALID |
|
IZ14217 |
2 |
JCC TYPE 2 DRIVER IN A NON-XA ENVIRONMENT GENERATES SQLXA_INTERNAL_ERROR WARNING IN DB2DIAG.LOG WHEN CLIENT REROUTE OCCURS |
|
JR28437 |
2 |
MULTIBYTE CHARACTER IN LITERAL STRING MAY CAUSE SQL0104N |
|
IZ15107 |
2 |
BINDING WITH DB2CAP FAILS WITH A LARGE NUMBER OF STATEMENTS |
|
LI73176 |
3 |
THE RETRY MECHANISM IN SQLDRIVERCONNECT FOR TRUSTED CONNECTION CAUSES WINDOWS SERVICES TO HANG. |
|
IZ15272 |
3 |
CONNECTION PERFORMANCE DEGREDATION WHEN RUNNING WITH CLI IN STATIC MATCH MODE. |
|
JR28002 |
3 |
REDIRECTING THE OUTPUT OF 'LIST SYSTEM ODBC DATA SOURCES' TO A FILE (I.E THE -R <FILENAME> OPTION) DOES NOT WORK |
|
IZ09175 |
3 |
UPDATE "DB2 UPDATE DB/ DBM CFG " HELP STATEMENT |
|
JR29954 |
3 |
SQL30020N RC=124C WHEN SELECTING A CLOB FROM DB2 V7 ON Z/OS |
|
IZ23057 |
3 |
DB2 -TVF PROBLEMS WITH INVALID FILE NAMES (FILE NAME MISSING) |
|
IZ22063 |
3 |
OLEDB SCHEMA ROWSET FOR TABLES RETURNING INCORRECT NUMBER OF COLUMNS. CAN CAUSE CLI0102E ERRORS. |
|
IZ17509 |
3 |
DB21034E OCCURS FOR "SELECT" SQL STATEMENTS STARTING WITH BLOCK COMMENTS THROUGH CLP. |
|
IZ08431 |
3 |
THE DB2 UPDATE COMMAND OPTIONS USING 'M' OFF/ON RESULTS IN SQL0104N ERROR |
|
IZ23287 |
3 |
.NET TRUSTED CONTEXT CONNECTIONS MAY FAIL TO OPEN WHEN PARTICIPATING IN AN XA TRANSACTION AND CONNECTION POOLING IS ENABLED. |
|
IZ28333 |
3 |
ON AIX, WINDOWS, DB2 -O -V -R SRT -L SRT LIST DB DIRECTORY FAILES WITH DB21005E. ON LINUX, IT WORKS FINE. |
|
IZ28987 |
3 |
SQLEXTENDEDBIND WITH SQL_C_CLOB_LOCATOR/SQL_CLOB IS NOT WORKING |
|
Common Code Infrastructure |
|
IZ22467 |
1 |
SQL0901 WITH "OUTER > INNER, INPUT OUT OF ORDER" MESSAGE. |
|
IZ26634 |
1 |
APPLICATION TRAPS AND PRODUCES COREDUMP WITH STACK TRACE SHOWING ENVPRFOPEN() ON TOP OF THE STACK |
|
IZ23074 |
1 |
DB2INSTALL PROCESS WILL FAILED IF THE CUSTOMER OSLEVEL IS LIKE 5300-03-CSP-0000. |
|
LI73209 |
1 |
SIGNAL #11 INSTANCE CRASH MIGHT OCCUR AFTER CONVERTING A STRING TO UPPER OR LOWER CASE USING FUNCTIONS LOWER/LCASE/UPPER/UCASE |
|
LI73571 |
1 |
HADR_REMOTE_HOST COULD NOT BE RESOLVED WHEN USING IP ADRESSES |
|
IZ15666 |
2 |
CLI APPLICATION CAN GET STUCK IN OSSLOCKGETCONFLICT WHEN TRYING TO WRITE A MESSAGE TO THE LOG FILE. |
|
IZ16904 |
2 |
DIA8315C NO MEMORY AVAILABLE IN THE BSU HEAP MEMORY LEAK IN LOAD JOBS : ABOUT 256-512 BYTES PER AFFECTED LOAD |
|
IZ20428 |
2 |
SQL1092N WHEN STARTING DAS FROM USERID WHICH BELONGS TO DASADM |
|
IZ16855 |
2 |
BACKING SYSTEM MEMORY CANNOT BE RELEASED ON SOLARIS DUE TO USE OF LARGE PAGES - DATABASE MEMORY CANNOT BE TUNED BY STMM |
|
JR29443 |
2 |
DBM CONFIGURATION PARAMETER AGENT_STACK_SZ IS NOT RESPECTED ON WINDOWS PLATFORM |
|
IZ10888 |
2 |
DB2ICRT CAN FAIL WITH DBI1703E, SQL6031N, RC 11 |
|
LI73317 |
2 |
STACK DUMP GENERATED IN DB2DIAG.LOG WHEN AN AUTHENTICATION PLUGIN RETURNS BAD LOGIN |
|
LI73624 |
2 |
DB2 PANICS WHEN EAGAIN (FILE SHARING VIOLATION) IS RECEIVED FROM SQLOSEEKWRITE64() |
|
IZ23140 |
2 |
DB2 MAY GET PANIC WHEN TRY TO READ A PAGE FROM DISK WHEN RUNNING WITH SOLARIS 10 ON HARDWARE THAT SUPPORT 256M PAGE. |
|
IZ15294 |
2 |
IN DBCS ENVIRONMENT, FUNCTION XMLELEMENT() FAILS TO HANDLE SPACECHARACTER WITH SQL20412 ERROR. |
|
LI73627 |
2 |
HIGHER CPU CONSUMPTION AND REDUCED THROUGHPUT WHEN ACCESSING ROWS IN A COMPRESSED TABLE ON LINUX FOR SYSTEM P |
|
IZ18783 |
3 |
HIGH MEMORY USAGE/PAGING WITH LOCAL CONNECTIONS OR ATTACHMENTS USING SOLARIS 10 |
|
IZ23139 |
3 |
DURING "DB2 RECOVER DB ... TO END OF LOGS", IT CAN HAVE LOT OF ERROR MESSAGES DUMPED INTO DB2DIAG.LOG FROM SQLOREADVLOW. |
|
IZ17404 |
3 |
DB2 CAN USE DATABASE PATH FOR STORAGE EVEN THOUGH THE PATH WAS TAGGED WITH READONLY ATTRIBUTE. |
|
LI72977 |
3 |
DB2PGCLNR WILL LEAK QUEUE OF AIO. |
|
JR29393 |
3 |
EXTRA ERROR IN DB2DIAG.LOG DURING DB2STOP ON NT. |
|
IZ26647 |
3 |
LD.SO.1 PATH NAME TOO LONG AFTER DB2CHGPATH EXECUTED. |
|
IZ17052 |
3 |
DB2_KILL SCRIPT DOES NOT WORK CORRECTLY WHEN THE DATABASE NAME IS "BP5". |
|
Communication |
|
IZ16648 |
1 |
DB2 CONNECT INSTANCE SERVING A XA APPLICATION MAY CRASH DUE TO A TRAP AFTER LOOSING THE COMMUNICATION WITH THE HOST DATABASE. |
|
IZ22051 |
2 |
INCORRECT RETURN CODE FROM DB2START WHEN DB2COMM=SSL AND SSL SERVER SIDE CONFIGURATION HAS NOT BEEN COMPLETED |
|
IZ21315 |
2 |
SQLCODE -30020 BY DB2 CONNECT SERVER IN A TWO PHASE COMMIT ENVIORNMENT. |
|
IZ26737 |
2 |
DB2 COMMANDS IN DB2 VERSION 9.1 AND LATER THAT REQUIRE HOSTNAME RESOLUTION MIGHT EXPERIENCE UNEXPECTED DELAYS. |
|
Connection Manager |
|
JR30195 |
2 |
UNLIMITED CONNECTION POSSIBLE THROUGH DB2 CONNECT INSPITE OF MAX_CONNECTIONS SET TO MINIMUM |
|
IZ23382 |
2 |
DURING ROLLBACK, THE POINTER TO THE SQLCA STRUCT IS OBTAINED INCORRECTLY AND DEFERENCE OF THIS INVALID POINTER CAN CRASH DB2. |
|
LI73464 |
2 |
RUNNING A SCRIPT WHICH CREATES SOME TABLES AND PROCEDURES AND STARTS A LOAD CAUSES INSTANCE CRASH |
|
LI72637 |
2 |
SQL0100W, NO JAR INSTALLED WHEN CALL SQLJ.INSTALL_JAR() REMOTELYFROM V8 CLIENT |
|
DB2 Tools |
|
JR29848 |
2 |
CONFIGURATION ASSISTANT HANGS ATTEMPTING TO MODIFY THE DBM CONFIGURATION FOR A LOCAL OR REMOTE INSTANCE. |
|
JR28538 |
2 |
NNSTAT:IF THE CURRENT USER IS NOT THE SAME WITH THE NICKNAME CREATOR,THE INDEXES WILL BE DELETED.ANY VALID USERID SHOULD WORK |
|
JR28287 |
2 |
NNSTAT DOES NOT UPDATE STATISTICS OF INDEX ON A NICKNAME SUCCESSFULLY, ALL ARE SET TO DEFAULT VALUE -1 OR "". |
|
JR30081 |
2 |
RUNNING LOAD COMMAND WITH MANY COLUMN PAIRS VIA ADMIN_CMD CAN FAIL WITH SQL0104 |
|
IZ29539 |
2 |
"SHOW EXPLAINED STATEMENTS HISTORY" DOES NOT WORK IN V9 CONROL CENTER |
|
DRDA Services |
|
IZ16585 |
1 |
ZOS CLIENT ABEND IF COMMIT OR ROLLBACK IS CALLED WITHIN A STORED PROCEDURE RUNNING ON LUW SERVER. |
|
IZ18766 |
1 |
DB2 CONNECT SYSPLEX ALGORITHM DISTRIBUTES TRANSACTIONS IN A FLIP-FLOP MANNER EVEN AFTER APPLYING IZ06275. |
|
JR27860 |
2 |
INTERMITTENT TRAP ON THE GATEWAY IN SQLJRPREPROCESSSETI |
|
IZ23319 |
2 |
WHEN CONNECTED ZOS SYSPLEX SERVER, DB2 CONNECT WORK BALANCING ISUNEVEN AND SHOWS FLIP-FLOP BEHAVIOUR. |
|
IZ23437 |
2 |
CLIENT GENERATED DUMPS, SQLZ_RC_CMPARM, CM PARAMETER BAD |
|
IZ23432 |
3 |
AN APPLICATION CONNECTED TO A DB2 CONNECT SERVER CAN REPORT DRDA PROTOCOL. REASON: 0X1245. |
|
Data Management Services |
|
IZ23013 |
1 |
LOADORVALSUBDMSDESC, PROBE:5998 IN THE DB2DIAG.LOG DURING CRASH RECOVERY |
|
LI73142 |
1 |
REORG FAILURE FOLLOWED BY DROPPING OF TEMP TABLESAPCE CAN CAUSE CRASH RECOVERY TRAP DUE TO REORG LOG RECORD FALLING IN CR WINDOW |
|
IZ23035 |
1 |
ROLLFORWARD RECOVERY TO POINT-IN-TIME AND HIT SQLDREDOUPSERT, PROBE:1897 WITH FREE SPACE DOES NOT MATCH DURING REDO!. |
|
LI73318 |
1 |
DATA CORRUPTION WHEN A LOB OBJECT ASSOCIATED WITH A TABLE GROWS LARGER THAN 2 TB |
|
IZ23232 |
2 |
BAD PAGE IS INDICATED DURING A REDO OPERATION. |
|
IZ15337 |
2 |
REORG USING RESETDICTIONARY TO SET ROW COMPRESSION SLOW |
|
IZ20872 |
2 |
FREE_BLK_PTR OVERLAPS SLOT DIRECTORY CAUSING INSTANCE CRASH. |
|
IZ28539 |
2 |
DB2 INSTANCE ABENDS WITH SIGNAL 11, TRAP FILE SHOWS ERROR IN PDLOG COMPONENT |
|
IZ18078 |
2 |
ROLLFORWARD - SQLDCOMPRESSREC, PROBE:787 - COMPRESSION DICTIONARY IS INVALID |
|
IZ14218 |
2 |
IN DB2 ENVIRONMENTS HAVING PARALLEL FEATURE, YOU MIGHT MEET A "DEAD-LATCH" SITUATION WHEN RUNNING A COMPLEX QUERY. |
|
LI73359 |
2 |
CRASH RECOVERY FAILS AFTER CRASH DUE TO INVALID FREE_BLK_PTR |
|
IZ22035 |
2 |
DGTT INDEX CREATE/RECREATE PERFORMANCE IMPACTED BY SYNCHRONOUS I/O'S |
|
IZ19083 |
3 |
AN SMS TEMPORARY TABLESPACE ON A STANDBY (HADR) DATABASE IS IN THE 'REORG IN PROGRESS' STATE. |
|
Data Protection Services |
|
IZ17801 |
1 |
CRASH RECOVERY FAILS FOLLOWING "INTERRUPT. USER CANCEL." MESSAGE |
|
IZ16283 |
1 |
CRASH RECOVERY WITH RAW LOG MIGHT HANG WHEN NEXTLSN IS AT START OF NEW LOG. |
|
IZ26685 |
2 |
ROLLFORWARD DB AFTER REDIRECTED RESTORE CAN FAIL WITH SQL4906 |
|
IZ26690 |
2 |
"HADR STANDBY FOUND BAD LOG" MESSAGE ON STANDBY DURING REMOTE CATCHUP PHASE DUE TO TIMING ISSUE ON PRIMARY |
|
IZ24742 |
2 |
LOG FILES FROM FAILARCHPATH FAILED TO ARCHIVE WHEN DB2 GOES BACKONLINE. |
|
IZ11605 |
2 |
ROLLFORWARD FAILS AND BRINGS THE INSTANCE DOWN |
|
IZ26682 |
2 |
REDUCE MASSIVE "TOO MANY LOGS, NEED TO RECLAIM" MESSAGES TO DB2DIAG.LOG DURING ROLLFORWARD. |
|
IZ26708 |
2 |
APAR ENTERTED FOR THE ADDITION OF A NEW DB2DIAG.LOG MESSAGE WHENAN OLD LOG PAGE IS ENCOUNTERED DURING ROLLFORWARD |
|
IZ16658 |
2 |
DEFUNCT PROCESSES SHOWING UP. |
|
LI73400 |
2 |
IF LOGARCHMETH2 ONLY IS SPECIFIED A ROLLFORWARD CAN FAIL WITH SQL4970N |
|
IZ29030 |
2 |
CONNECT TO DATABASE RETURNS SQL20153, AFTER TAKE OVER |
|
IZ21190 |
2 |
CRASH RECOVERY MAY FAIL WITH SQL1471N WHEN THERE WAS COMMUNICATION PROBLEM BETWEEN THE CATALOG NODE AND A REMOTE NODE |
|
IZ29010 |
2 |
TABLESPACE ROLLFORWARD CAN GET SEGMENTATION VIOLATION AND ABEND THE SERVER DUE TO A CORRUPTED DB2TSCHG.HIS FILE |
|
IZ18155 |
2 |
CRASH RECOVERY MAY FAIL IF BOTH THE ACTIVE LOG DIRECTORY AND THE MIRRORED LOG DIRECTORY ARE MARKED BAD BY DB2. |
|
IZ17728 |
2 |
TABLESPACE ROLLFORWARD TO END OF LOGS MIGHT HANG ON INACTIVE SYSTEM |
|
IZ26709 |
2 |
A ROLLFORWARD OF A TABLESPACE CREATED AS LOWER CASE FAILS WITH A SQL02066N |
|
IZ26703 |
3 |
INSTANCE HANG WHEN OFFLINE BACKUP IS ISSUED AND DB2 HAS A LARGE AMOUNT OF LOGS TO ARCHIVE. |
|
IZ11133 |
3 |
HIGH TRANSACTION RATE WORKLOADS WITH MANY ROLLBACKS MAY SEE PERFORMANCE DEGRADATIONS AND/OR SCALABILITY ISSUES. |
|
LI73573 |
3 |
DATABASE CRASH AS A RESULT OF MANUALLY REMOVING AN OLD LOG FILE IN AN ENVIRONMENT WHERE LOG MIRRORING IS TURNED ON. |
|
LI73685 |
4 |
INSUFFICIENT INFO MESSAGES IN DB2DIAG.LOG ON DPF ENV AS COMPARED TO SINGLE PARTITION ENV FOR LOCKWAIT, LOCK MODE,APP,SQL |
|
Development Infrastructure |
|
IZ25096 |
1 |
DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.52.95 AND 4.2.73 FOR DB2 LUW V9.5 FP 2 (PART 1) |
|
IZ16345 |
2 |
DB2 DOES NOT MAKE USE OF IPC MESSAGE QUEUES GREATER THAN 64K, EVEN THOUGH MSGMNB IS GREATER THAN 64K ON HPUX |
|
IZ16414 |
2 |
XML INDEX PLANS MAY GENERATE FALSE POSITIVES. |
|
Documentation and Information Center |
|
LI73135 |
3 |
SQL1084C SHOULD DESCRIBE SHMMAX AS THE POSSIBLE CAUSE OF THE ERROR MESSAGE |
|
Engine Infrastructure |
|
IZ26781 |
1 |
DB2 ALTERNATE SERVER FEATURE CAN CORRUPT DB DIRECTORY ENTRY ON CLIENT RUNNING JAVA DB2 APPS ON MULTIPROCESSOR MACHINES. |
|
IZ20558 |
1 |
DB2 TRAP WHEN ACCESSING SERVICE CLASS CONNECTIONSLIST. |
|
IZ20357 |
1 |
INSTANCE CRASH AFTER EXHAUSTING APPLICATION HEAP. |
|
IZ28306 |
2 |
PREVENT DROPPING OF SERVICE SUBCLASS WHEN WORKLOAD OCCURRENCE IS STILL REFERENCING IT |
|
LI73197 |
2 |
WITH LDAP DIRECTORY SERVICE IS ENABLED, CONNECT FAILS WITH SQL1096N OR SQL1031N |
|
IZ22898 |
2 |
THE CUSTOMER CAN SEE A HANG DURING A DB2START FAILURE BECAUSE OF A PROCESS LIMIT THAT PREVENTS AGENTS FROM BEING CREATED. |
|
IZ16986 |
2 |
PARALLEL BACKUP USING DB2_ALL ON A MULTIPLE NODE SYSTEM MAY CAUSE SOME OF THE BACKUPS ON NON-CATALOG NODES TO FAIL. |
|
JR28583 |
2 |
CATALOG NODE ENTRY API - SQLECTND - CANNOT HANDLE THE LENGTH OF THE DEFAULT INSTANCE PROFILE PATH IN WINDOWS |
|
IZ28305 |
2 |
MAP LOAD EDUS AND SUBAGENTS TO SERVICE CLASS |
|
IZ29067 |
3 |
DB2PD -DB DBNAME -APPLICATION CAN NOT SHOW "DECOUPLED" STATUS |
|
LI73285 |
3 |
IN A WINDOWS AND VMWARE ENVIRONMENT USING DB2 V9.5,DATABASE CONNECTIONS OR SQL QUERIES MAY APPEAR TO HANG OR TAKE A LONG TIME |
|
IZ26720 |
3 |
SQL1042C INSTEAD OF SQL1225N IS RETURNED FROM DB2START IF NUM_INITAGENTS IS SET TOO HIGH |
|
Engine Utilities |
|
IZ23377 |
1 |
CRASH WHEN LOADING DATA INTO A TABLE WITH XML COLUMNS |
|
IZ23950 |
1 |
XML LOAD: RESTARTING IN BUILD PHASE IGNORES UNIQUE VALUES KEY VIOLATIONS |
|
IZ26565 |
1 |
ANY DATA MANIPULATION STATEMENT AFTER REDISTRIBUTE CRASH RECOVERY ON A COMPRESSED TABLE MAY CAUSE DB2 CRASH |
|
IZ21584 |
1 |
REDISTRIBUTE FAILS AND DB2 CRASHES (SQL6064N SQL ERROR "-1224" OCCURRED DURING DATA REDISTRIBUTION) |
|
IZ21372 |
2 |
TRAP SOMETIMES OCCURS DURING "DB2 CONNECT RESET" IF A PREVI LOAD FAILS WITH AN OUT-OF-MEMORY ERROR. |
|
JR29087 |
2 |
MEMORY LEAK IN LICENSE DAEMON WITH CONCURRENT USER POLICY. |
|
IZ18330 |
2 |
DB2 PROCESS TRAPS WHEN LOADING "BAD DATA" - SPECIFICALLY BAD DATA OF THE FORM ""XXXXXXX""(CTRL+M)\N |
|
IZ25670 |
2 |
DB2IUPDT INCORRECTLY FORCES INSTANCE_MEMORY AND MON_HEAP_SZ TO AUTOMATIC |
|
IZ20774 |
2 |
ERROR -2045837302 PERFORMING A MULTIPARTITION LOAD FROM A REMOTE CLIENT APPLICATION INTO A PARTITIONED TABLE. |
|
IZ11034 |
2 |
V9 LOAD UTILITY DOES NOT CALL A CODEPAGE CONVERSION REGARDING GRAPHIC/VARGRAPHIC COLUMNS IN IXF FILE |
|
IZ18624 |
2 |
RUNNING LOAD COMMAND FROM VERSION 9.5 CLIENT TO VERSION 9.1 DATABASE RETURNS SQL3088N |
|
IZ28722 |
2 |
FAST REDISTRIBUTE CRASH RECOVERY ( IN SOME SPECIAL CASE DUE TO CRASH ON END OF CONSISTENCY POINT) , MISSES SOME ROWS OF DATA |
|
IZ20824 |
2 |
LOAD ON THE PARTITIONED DATABASE RETURNS SQL2708N ERROR FOR ETXTBSY IF IT IS RETRIED AFTER SQL6555N ERROR |
|
IZ23038 |
2 |
IMPORT REPORTS INCORRECT ROWS_REJECTED WHEN SQL0407N ERROR OCCURS. |
|
LI73222 |
2 |
SEGMENTATION FAULT USING DB2LOAD() API FOR APPLICATIONS COMPILEDWITH V8/V9.1 LIBS |
|
JR28139 |
2 |
LOAD COMMAND FAILS WITH SQL0902C RC=98 |
|
IZ17489 |
2 |
LOAD PRE-PARTITIONING AGENTS MAY ENCOUNTER A SIGNAL 11 AFTER A MESSAGE QUEUE RELATED ERROR HAS BEEN HIT. |
|
IZ22268 |
2 |
IN MPP LOAD DATA INTO A TABLE THAT DOES NOT EXIST IN THE NODE THAT IS CONNECTED MAY CAUSE INSTANCE CRASH. |
|
LI73475 |
2 |
DB2BACKUP API FAILS WITH: SQL CODE: -2429 |
|
LI72831 |
2 |
DB2LICM CAN TRAP AND PRODUCE A CORE DUMP |
|
LI73211 |
2 |
SCHEDULED TASKS MAY BE EXECUTED MORE THAN EXPECTED AFTER THE SWITCH TO DAYLIGHT SAVING TIME IN SOME TIMEZONES |
|
LI73042 |
2 |
CLIENT LOAD FAILS WITH SQL0980C "A DISK ERROR OCCURRED" CONNECTING TO REMOTE MULTINODE SYSTEM WITH NODES ON SAME BOX. |
|
LI72976 |
2 |
"DB2 LIST HISTORY ALL FOR DBNAME" COMMAND RETURNS SQL1042C IF ISSUED FROM DB2 VERSION 8 CLIENT TO VERSION 9 SERVER |
|
LI73193 |
2 |
V9.5 INSTANCE CRASHES WHEN LOAD IS RUN FROM V8, V9.1 CLIENT AND THE TABLE CONTAINS XML COLUMN. |
|
IZ13164 |
3 |
IMPORT DOESN'T INSERT DATA CORRECTLY (ASC FILE TYPE ONLY) |
|
IZ09305 |
3 |
LOAD FROM CLIENT GETTING SQL2044 INSTEAD OF SQL0289 |
|
IZ25292 |
3 |
CREATE SERVER FAILS WITH ERROR -430 AGAINST DRDA ON HPIA64 IN FENCED MODE |
|
IZ15711 |
3 |
LOAD COMMAD CREATES TRAP FILE WITH MESSAGE IN DB2DIAG.LOG "NO AVAILABLE BUFFER POOL PAGES" |
|
IZ19012 |
3 |
PIVENDOROPTIONS ON THE INITIAL DB2 BACKUP API REQUEST SHOULD PROPOGATE TO ALL THE RESULTING DB2 PROCESSES THAT |
|
IZ26553 |
3 |
A FAILURE IN ATMSENDSTATS CAN RETURN -1042 AND SUBSEQUENTLY MARKTHE DATABASE BAD. |
|
IZ26540 |
3 |
AUTOMATIC TABLE MAINTENANCE USES AN INCORRECT CALCULATION TO DETERMINE IF AUTO-RUNSTATS SHOULD BE EXECUTED. |
|
LI72954 |
3 |
BAD DATA PAGE BELONGING TO ANOTHER TABLE ENCOUNTERED DURING BUILD PHASE OF A LOAD OPERATION AGAINST AN MDC TABLE |
|
IZ24433 |
3 |
DOCUMETID FOR XML COLUMNS ARE MISSING. |
|
IZ29248 |
3 |
REMOVE LOAD UTILITY DATA BUFFER 250000 PAGE UPPER LIMIT. |
|
IZ12459 |
3 |
THE AUTOMATED RUNSTATS FACILITY WILL NOT SCHEDULE RUNSTATS FOR NEWLY CREATED INDEXES |
|
Federation |
|
JR29115 |
1 |
FED: CANNOT USE ODBC WRAPPER WITH NON-DATADIRECT ODBC DRIVERS ON ZLINUX |
|
JR29390 |
1 |
CREATE WRAPPER STMT FOR JAVA WRAPPER SDK FAILS. USER MAPPING DDLSTATEMENTS FOR JAVA SDK & LDAP WRAPPER MAY RESULT IN SQL1034 |
|
IZ19573 |
1 |
ODBC WRAPPER TO IICF SERVER- X00680018.SOCKET SEND DATA FAILURE |
|
JR28293 |
2 |
COLUMN CLUSTERRATIO OF TABLE SYSCAT.INDEXES IS SET TO DEFAULT VALUE '0' WHEN CREATE DRDA NICKNAME |
|
JR29941 |
2 |
ORACLE WRAPPER: ERROR FROM DJXLINKORACLE WHEN LINKING WITH ORACLE V11 CLIENT |
|
JR29199 |
2 |
CREATING MSSQL SERVER AS VERSION 2005 WHILE ACTUALLY CONNECT TO MSSQL SERVER 2000 WILL CAUSE DB2 CRASH WHEN CREATING NICKNAME |
|
IZ22817 |
2 |
SQL0901N ERROR WHEN DO QUERY OPERATION ON ORACLE WITH SERVER OPTION OF DB2_HIGH_LOW_PADDING_INVARIANT 'N' |
|
JR30184 |
2 |
TRAP DUE TO ERRORS IN C USER MAPPING PLUGIN |
|
JR28683 |
2 |
QUERY RETURNS SQL0204N WITH ORA-00942 "TABLE OR VIEW DOES NOT EXIST" USING UNSUPPORTED ORACLE VERSION 8. |
|
JR28187 |
2 |
CREATE FEDERATED STORED PROCEDURE RETURNS SQL0204N FOR MS SQL SERVER 2005 IF REMOTE STORED PROCEDURE IS A DEFINED SCHEMA. |
|
JR28402 |
2 |
CREATING ORACLE NICKNAME FAILED WITH SQLCODE SQL1822N AND SQLSTATE=560BD |
|
JR29287 |
2 |
DB2_SOURCE_CLIENT_MODE OPTION ON 64-BIT WINDOWS IS NOT SUPPORTED. SUPPORT IS FOR 64 BIT AIX AND SOLARIS |
|
IZ26601 |
2 |
PRECOMPILE FAILED WITH SQL0901N AGAINST INFORMIX DS |
|
JR28526 |
2 |
CAN NOT ALTER NICKNAME COLUMN TYPE OF VARGRAPHIC TO VARCHAR FOR AN ORACLE NICKNAME |
|
JR28170 |
2 |
SQL4944 RETURNED WHEN CREATE FEDERATED STORED PROCEDURE WITH ORACLE WRAPPER. |
|
JR28308 |
2 |
DB2 CRASHES WHEN SELECT LOB AND NON-LOB MIXED COLUMNS AGAINST NICKNAME |
|
IZ24752 |
3 |
INFORMIX WRAPPER VARCHAR COLUMN LENGTH HAS PROBLEM |
|
IZ17661 |
3 |
PRODUCE WARNING MESSAGE WHEN RUN DB2FEDSVRCFG WITH IBM BRANCHED DATADIRECT DRIVER ON ZLINUX |
|
High Availability |
|
IZ21428 |
2 |
DB2HAICU MOVE COMMAND MOVES INCORRECT PARTITIONS |
|
LI73478 |
2 |
ON LINUX, USING THE INTEGRATED HA FEATURE, A FILESYSTEM MAY FAILTO BE UNMOUNTED CAUSING CLUSTER INITIATED FAILOVER TO FAIL. |
|
IZ20374 |
2 |
LOG FILES CREATED BY RCU PREVENT LCU FROM USING ARCHIVED LOG FILES |
|
IZ10681 |
2 |
SETTING DB2_HADR_BUFF_SIZE TO A VALUE OF 2GB OR LARGER RESULSTS IN THE HADR CONNECTION BEING DROPPED |
|
LI73483 |
2 |
IN DB2 V9.5 DB2GCF -I <INSTNAME> DOESN'T WORK |
|
JR28152 |
2 |
DATABASE HANG DURING HADR SOFT CHECK POINT REQUEST |
|
LI73367 |
2 |
PREVENT FAILED_OFFLINE WHEN DB2NODES.CFG 2ND COLUMN NIC IS UNPLUGGED |
|
LI73568 |
2 |
DB2HAICU: ALLOW USE OF GPFS FOR HOME DIRECTORY MOUNTS |
|
IZ21426 |
3 |
CHANGE THE DEFAULT FOR MONITORCOMMANDTIMEOUT OF "DB2MNT-DB2FS%" FROM 29 TO 120 ON AIX . |
|
LI73470 |
3 |
ERROR HANDLING BETWEEN PRIMARY AND STANDBY WHILE ONE CONNECTION IS CLOSED IN ONE CAUSES INSTANCE CRASH. |
|
Index Manager |
|
LI73603 |
1 |
INDEX SCANÿUSING EXCLUSIVE START KEY MIGHT RETURN INCORRECT RESULTS |
|
IZ26742 |
2 |
ONLINE LOAD MAY ABEND WHEN USE OPTION SPECIFIED AND DMS INDEX TABLESPACE EXTENTSIZE NOT POWER OF 2. |
|
Install |
|
IZ23240 |
1 |
V95FP1 DSDRIVER'S FIX PACK INSTALL ON TOP OF V95GA DSDRIVER FAILS. |
|
IZ19584 |
2 |
SQL5005C ERROR WHEN INSTALLING 9.5 VIA A RESPONSE FILE AFTER CHANGING THE DEFAULT VALUE FOR DB2INSTPROF |
|
IZ22278 |
2 |
64-BIT GSKIT IS NOT INSTALLED WITH V9.5 DB2 V9.5 ON 64-BIT WINDOWS |
|
IZ28639 |
2 |
"ERROR:THE USERNAME SYSTEM DOES NOT CONFORM TO THE DB2 NAMING RULES" WHEN DEPLOYING WITH SMS |
|
JR29162 |
2 |
DB2 V9 CLIENT INSTALLER DOES NOT PROCEED ON WINDOWS |
|
JR28573 |
2 |
INSTALL OF DB2 FAILS WITH "DB2INSTALLEVENTLOG.EXE HAS ENCOUNTERED A PROBLEM" |
|
IZ22277 |
2 |
2ND COPY OF V95 DSDRIVER INSTALL FAILS IF THE KEYWORD OF DEFAULT_CLIENT_INTERFACE_COPY IS NOT SPECIFIED IN THE RESPONSE FILE. |
|
JR29035 |
2 |
INSTALLATION FAILS IF THERE IS UNC PATH REFERENCE IN THE PATH ENVIRONMENT VARIABLE. |
|
IZ22274 |
2 |
IMPROPER FIXPAK UPGRADE OF A DB2 COPY, WHICH CONTAINS MULTIPLE DB2 SERVER PRODUCTS |
|
IZ14247 |
2 |
WHEN USING LDAP WITH DB2 UDB V9, CONNECTIONS TO THE DATABASE WILL FAIL WITH A SQL1031N ERROR |
|
JR29833 |
2 |
DB2 INSTALLATION DOES NOT WORK WITH SMS 2003 ADVANCED CLIENT ENVIRONMENT, WHEN IT IS LAUNCHED FROM SETUP.EXE. |
|
JR28798 |
2 |
FAIL TO INSTALL V9 DB2 ON WINDOWS PLATFORMS WITH AN EXISTING V8 DB2 INSTALLED. |
|
IZ15391 |
2 |
DB2SETUP RETURNS 1 (WARNING) INSTEAD OF 67 (ERROR) DURING SWAP SPACE OUTAGE |
|
JR29263 |
2 |
VISUAL STUDIO 2008 PROJECT TEMPLATES FOR DB2 CLASS AND DB2 CLASS LIBRARY ARE MISSING IN IBM DATABASE ADD-INS FOR VISUAL STUDIO |
|
JR28720 |
2 |
DB2 AUTOCONFIGURE GIVES SQL0444N ON DB2 PE |
|
LI73476 |
2 |
INSTALLING FIXPACK 1 TO V9.5 EXPRESS GA + SA MP COMPONENT GETS DBI1132E WARNING. |
|
IZ19515 |
2 |
TIMEOUT IN DB2IUPDT MAY CAUSE OPERATION TO FAIL WITH "DBI1250E APPLICATIONS ARE STILL USING THE INSTANCE" |
|
IZ17450 |
3 |
DB2LS PRINTS AN ERRONEOUS MESSAGE ABOUT MISSING PREREQUISITES |
|
IZ22836 |
3 |
DB2ICRT DOES NOT CREATE THE IBMLDAPSECURITY.INI FILE IN INSTHOME/SQLLIB/CFG |
|
IZ19010 |
3 |
DB2ISETUP CRASHES (SEGMENTATION FAULT) WHEN USED WITH RESPONSE FILE. |
|
IZ28582 |
3 |
FCM_NUM_BUFFERS DATABASE MANAGER CONFIGURATION PARAMETER INCORRECTLY CALCULATED DURING MIGRATION ON AIX |
|
LI73360 |
3 |
DB2SETUP AND DB2_INSTALL DO NOT CREATE THE FAULT MONITOR ENTRY IN /ETC/INITTAB |
|
IZ19011 |
3 |
DB2_DEINSTALL DOES NOT REMOVE THE .SYSTEMPREFS DIRECTORY LOCATED UNDER THE DB2 JAVA DIRECTORY |
|
IZ20807 |
4 |
QUERY PATROL INSTALLATION THROWS DB2ICHECKINSTANCESTATE NOT FOUND ERROR ON HP PLATFORMS |
|
IZ23768 |
4 |
MISSING AND INCORRECT LINKS ON DB2 LAUNCHPAD AND FIRST STEPS |
|
Interpartition Communication |
|
IZ20716 |
1 |
A QUERY MAY RETURN UNEXPECTED RESULTS IN DPF/SMP ENVIRONMENTS WHEN SELECTING A DECFLOAT COLUMN OR PERFORMING AGGREGATION ON IT |
|
IZ17011 |
2 |
QUERY AGAINST MUTIPARTITIONED TABLE CONSUMES LARGE AMOUNT OF TEMP TABLESPACE DUE TO TABLEQUEUE BUFFERS OVERFLOWED |
|
JDBC |
|
IZ21339 |
1 |
JCC DRIVER RETURNS XAER_PROTO |
|
IC57215 |
2 |
INVOKING A Z/OS SP VIA DATASTUDIO 1.1.1 MAY RESULT WITH -4499 |
|
IZ10808 |
2 |
ADD SUPPORT FOR JAVA 1.5 CHANGES TO BIGDECIMAL IN THE UNIVERSAL JDBC DRIVER |
|
IZ15539 |
2 |
THE NUMBER OF RETRIES FOR CLIENT REROUTE IS DOUBLED THAN THE MAXRETRIESFORCLIENTREROUTE SET. |
|
IZ19157 |
2 |
DB2 MAY HIT SIGSEV PROBLEM IF ERROR IS ENCOUNTERED DURING INSERT/DELETE/UPDATE/SELECT THROUGH INDEX |
|
LI73362 |
2 |
SETTING NON-ZERO QUERYTIMEOUT IN THE UNIVERSAL JDBC DRIVER MAY RESULT IN HIGH MEMORY USAGE IN HIGH THROUGHPUT ENVIRONMENTS |
|
JR29176 |
3 |
SQL ERROR -4700 WHEN USING JCC DRIVER 3.X TO CONNECT TO DB2 Z/OS V8 IN COMPATIBILITY MODE |
|
Life Sciences Wrappers |
|
JR28939 |
1 |
SELECT OF A CLOB THOUGH THE BIORS WRAPPER HAS POOR PERFORMANCE |
|
Monitoring |
|
IZ14472 |
1 |
DB2 SNAPSHOT HAS BLANK / UNRECORDED UOW STOP TIMESTAMP FOR SOME APPLICATIONS TYPICALLY XA |
|
IZ23061 |
2 |
DEREFERENCE OF A POINTER AFTER FAILING TO ATTACH TO A MEMORY SEGMENT LEADS TO A TRAP. |
|
IZ29579 |
2 |
MISSING SQL INFORMATION MAY EXIST FOR SOME SNAPSHOT INVOCATIONS. |
|
IZ14823 |
2 |
IF YOU CREATE AN ACTIVITY EVENT MONITOR (NEW IN V9.5) THAT IS WRITE TO FILE, THE ACTIVATE_TIMESTAMP ELEMENT ISN'T POPULATED. |
|
IZ19170 |
2 |
PERFORMANCE PROBLEM DEACTIVATING ACTIVITY FILE EVENT MONITOR ON UNIX/ LINUX |
|
IZ09337 |
2 |
DATABASE SNAPSHOT INCORRECTLY REPORTS PACKAGE CACHE HIGH WATER MARK ON DB2 9, 9.5 |
|
LI73513 |
2 |
THE NUMBER OF COMPILATIONS VALUE SHOULD NOT BE RESETTABLE |
|
IZ28233 |
2 |
INCORRECT LOCK WAIT START TIMESTAMP |
|
IZ28221 |
2 |
DPS NOT INITIALIZED FOR THIS APPLICATION MESSAGE DUMPED TO DB2DIAG.LOG |
|
LI72827 |
3 |
DB2 AGENT TRAP OCCURS DURING FORMATING OF DEADLOCK MONITOR INFORMATION WHEN DIAGLEVEL SET TO 4 |
|
IZ28231 |
3 |
"UOW LOG SPACE USED" IN SNAPSHOT OUTPUT CAN BE INCORRECT WHEN USING XA TRANSACTION. |
|
IZ14679 |
3 |
MEMORY LEAK IN DATABASE MEMORY HEAP WHEN DATABASE CONNECT FAILS AND BUFFERPOOL MONITOR SWITCH IS ON. |
|
IZ10927 |
3 |
PACKAGE CACHE LOOKUP COUNTER WRAPS |
|
IZ17088 |
4 |
INSUFFICIENT MEM ERROR INFORMATION IN DIAG LOG. |
|
Performance |
|
IZ26835 |
3 |
DB2BATCH ON PURE V9 CLIENT MAY RESET THE MONITOR SWITCHES WITHOUT -MSW AND -MSS OPTIONS SPECIFIED AND DB2BATCH WILL FAIL |
|
Problem Determination |
|
IZ26801 |
2 |
THREAD SUSPENSION FEATURE MAY USE INVALID SUSTAINABILITY CRITERIA FOR SOME TYPES OF TRAPS. |
|
IZ20678 |
2 |
OUTPUT OF DB2PD WITH -BUFFERPOOLS OPTION IS INCOMPLETE AND INCLUDES "CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION." |
|
IZ18657 |
2 |
WRONG LOCKNAME IN DB2PD -LOCKS OUTPUT |
|
IZ10053 |
2 |
ADDING DB2PDCFG -FLUSHBP |
|
LI72451 |
2 |
DB2INSPF UTILITY THROWS SIGNAL 11 WHEN LONG FILE NAMES ARE USED.(APAR INCLUDES MRI MESSAGES) |
|
IZ05943 |
2 |
ADD SERVICEABILTY FUNCTION TO DB2DART TO CHECK MDC CELL KEYS WITHIN EACH BLOCK |
|
IZ29156 |
3 |
DB2FODC -HANG IMPROVEMENTS |
|
LI73585 |
3 |
DBNAME FIELD IN DB2PD -UTILITIES OUTPUT MAY CONTAIN ADDITIONAL ( CONTROL ) CHARACTERS, LEADING TO GARBAGE OUTPUT |
|
Quality Assurance |
|
IZ27403 |
2 |
UNSUPPORTED CODE PAGE CONVERSION WHEN CALLING SQL PROCEDURE MIGRATED FROM VERSION 8.2 |
|
Query Compiler, Rewrite, Optimizer |
|
IZ22102 |
1 |
INCORRECT RESULTS FOR A QUERY WITH A SELECT OR INNER JOIN BETWEEN A BASE TABLE AND A SUB-SELECT WITH A GROUP BY |
|
IZ26543 |
1 |
INVALID SQL0901N MESSAGE WHEN PASSING IN OVER() FUNCTION AS PARAMETER TO USER DEFINED FUNCTION. |
|
IZ23439 |
1 |
WRONG RESULT IN QUERY WITH XMLEXISTS AND "FETCH FIRST N ROWS ONLY" |
|
IZ29118 |
1 |
INCORRECT RESULTS FOR OUTER JOINS WITH SELECT DISTINCT |
|
IZ21585 |
1 |
SQLCODE -1042 RETURNED BY VISUAL EXPLAIN TOOL IN DATA STUDIO WHEN USING THE DB2 LUW DATA SERVER. |
|
IZ22907 |
1 |
QUERIES WITH "IN" PREDICATE CAUSES THE INSTANCE TO TRAP, OR SQL0901N "FOUND ZERO CLOB.RESET"(LATTER CASE W DB2_HASH_JOIN=NO) |
|
LI73020 |
1 |
REMOVE OUTER JOIN ON CLAUSE LOCAL PREDICATE |
|
IZ19632 |
2 |
WHEN USING THE INLINE LENGTH PARAMETER DB2 WILL CRASH IF THE PAGESIZE IS 32K. |
|
IZ10364 |
2 |
OPTIMIZER IS BROADCASTING (BTQ) A REPLICATED MQT WHICH CAN CAUSESLOW PERFORMANCE |
|
LI73047 |
2 |
THE DB2 DESIGN ADVISOR (DB2ADVIS) MAY CRASH THE DATABASE INSTANCE WHEN RECOMMENDING BLOCK INDEXES FOR MDC TABLES |
|
LI73109 |
2 |
INLIST TO INDEX OR PREDICATE TRANSFORMATION NOT CONSIDERED WHEN PREDICATE IS PART OF ON CLAUSE FOR OUTER JOIN. |
|
IZ15355 |
2 |
FIX TO ADDRESS A POORLY PERFORMING QUERY INVOLVING JOING WITH 3 OR MORE TABLES. |
|
IZ27532 |
2 |
INVALID PARSING ERROR FOR SQL PROCEDURE CONTAINING SELECT WITH "GROUP BY" HAVING HOST VARIABLE |
|
IZ21400 |
2 |
DB2 MAY ISSUE SQL0901N ERROR IN QUERY OPTIMIZATION |
|
IZ18746 |
2 |
CUSTOMER COULD EXPECT WRONG RESULT IF THE PROBLEM IS NOT FIXED. |
|
IZ13111 |
2 |
POOR OUTER JOIN QUERY PERFORMANCE FROM :? = :? PREDICATE |
|
IZ24145 |
2 |
PERFORMANCE REGRESSION OF QUERIES THAT HAVE A JOIN OF MORE THAN 10 VIEWS WHEN EACH VIEW OR ALIAS CONTAINS A SINGLE TABLE. |
|
IZ26552 |
2 |
QUERY PERFORMANCE PROBLEM IF THERE ARE 200 ELEMENTS IN LIST |
|
LI73413 |
2 |
TABLE OR INDEX STATISTICS CORRUPTION MIGHT CAUSE A DB2 SERVER ABEND |
|
IZ11439 |
2 |
QUERY PERFORMANCE MAY BE SLOW WHEN DB2 FAILS TO CONVERT IN SUBQUERY TO INNER JOIN. |
|
LI73431 |
2 |
IMPROPER TABLE ELIMINATION BY OPTIMIZER ON SPECIFIC CONDITIONS |
|
LI72999 |
2 |
REPARTITION JOIN STRATEGY NOT CONSIDERED IN DPF ENVIRONMENT WHENDB2_REDUCED_OPTIMIZATION IS SET |
|
LI72728 |
2 |
IMPROVE CARDINALITY ESTIMATE FOR PREDICATES WITH COMPLEX EXPRESSIONS THAT EVALUATE TO A CONSTANT ON THE SAME COLUM AS JOIN PRED. |
|
IZ25213 |
2 |
USE OF QRYOPT ELEMENT IN OPTIMIZATION GUIDELINES CAN ABEND IN SOME CIRCUMSTANCES. |
|
IZ22971 |
2 |
TQ OPERATOR HAS A FORMAT BUG IN VISUAL EXPLAIN WHERE EXPLAIN STRUCTURES TO DATA STUDIO VISUAL EXPLAIN CANNOT BE PARSED |
|
IZ20543 |
2 |
EXCUTING CREATING A FUNCTION TEMPLATE ON A FEDERATED ENABLED DATABASE WITH TABLE OR ROW SHOULD REPORT AN ERROR. |
|
IZ22429 |
2 |
BLOCK COMPARISON OPERATION PUSHED DOWN IF CCC IS USED ON THE FEDERATION SERVER |
|
IZ28062 |
2 |
SQL901N RETURNED FROM A MERGE STATEMENT OR UPDATE STATEMENT ON A UNION ALL VIEW WITH ROW MOVEMENT |
|
IZ12510 |
2 |
INCORRECT OUTPUT CARDINALITY FROM OVERCOMPENSATING FOR CORRELATION |
|
IZ23245 |
2 |
"SQLCODE: -901" AND "SQLERRMC: PIDPSET IS EMPTY" IS FOUND IN DB2DIAG.LOG. |
|
IZ22929 |
2 |
DB2_REDUCED_OPTIMIZATION=UNIQUEINDEX DOES NOT ALWAYS WORK, SO SLOW PERFORMANCE AS INDEX SCAN USES NON-FULLY QUALIFIED INDEX. |
|
IZ22945 |
2 |
IN PREDICATE IS UNNECESSARILY APPLIED WHEN AN IN-TO-JOIN NESTED LOOP JOIN (NLJN) IS BUILT. |
|
IZ21386 |
2 |
INLIST TO JOIN TRANSFORMATION NOT CONSIDERED ANYMORE ON SPECIFICPLATFORMS AND FIXPACKS |
|
JR29140 |
2 |
EXPLAIN WITH/FOR SNAPSHOT WHEN MQT MATCHING IS ENABLED , FAILES WITH ERROR SQL0104N. |
|
IZ08740 |
2 |
SQL0119N MAY BE RETURNED BY FEDERATED QUERY CONTAINING A GROUP BY EXPERESSION |
|
JR28249 |
2 |
ERROR SQL0138N RUNNING SELECT SUBSTR(CURRENT SERVER, <START>, <LENGTH>) FROM <NICKNAME> ORDER BY ... ON A FEDERATED DATABASE |
|
IZ25820 |
2 |
DB2 INSTANCE CRASH WHEN CREATE SQL STORED PROCEDURE. |
|
IZ17662 |
2 |
ROUTING QUERY SUM (CASE STATEMENT) TO MQT SUM MAY RETURN INCORRECT RESULT |
|
IZ23086 |
2 |
DATABASE INSTANCE ABNORMALLY SHUT DOWN WITH SIGNAL#11 |
|
JR29341 |
2 |
FP5: PUSH LOCAL PRDS ON CASE EXPRESSIONS THROUGH CASE GB |
|
IZ15744 |
2 |
TRAP IN SQLRI_HSJN_UNFORMATKEY WITH MQT |
|
IZ18364 |
2 |
SUBSELECT USING INLIST PREDICATE WILL CRASH WITH SEGV -901 |
|
LI73549 |
2 |
MDC ROLLOUT DOES NOT HAPPEN DURING DELETE OPERATION IN CERTAIN SITUATIONS |
|
IZ24839 |
2 |
UNDERCOSTED ORDERED NLJOIN PICKED OVER OTHER JOINS |
|
IZ19592 |
2 |
OPTIMIZER MAY OVERESTIMATE CARDINALITY ESTIMATE OF A JOIN, WHEN THERE ARE MULTIPLE JOIN PREDICATES BETWEEN SAME PAIR OF TABLES. |
|
IZ19835 |
2 |
EXTENDING THE OPTIMIZER'S USE OF STATVIEWS |
|
IZ15858 |
2 |
THERE IS AN ERRONEOUS WARNING WHEN ISSUING "PRECOMPILE" COMMAND. |
|
IZ20124 |
2 |
XQUERY WITH NICKNAME FOR NON-RELATIONAL WRAPPER FAILS WITH -901 |
|
IZ19262 |
2 |
THE DB2 OPTIMIZER WRONGLY COMPLAINS ABOUT TEMP SPACE NOT ENOUGH EVEN WHEN IT IS AVAILABLE |
|
IZ14306 |
2 |
INVALID CURRENT TIMEZONE CONSTANT EXPRESSION |
|
LI73191 |
3 |
LACK OF CONSTANT FOLDING ON TIMESTAMP DATATYPE CAN RESULT IN TABLESCAN |
|
IZ18164 |
3 |
SQL0112N IS ISSUED WHILE THE XMLQUERY() IS USED AS THE INPUT OF AN AGGREGATION FUNCTION. |
|
LI73162 |
3 |
POSSIBLE POOR PERFORMANCE OF QUERIES WITH FFNR/OFNR AND DISTINCT |
|
IZ17092 |
3 |
COMPOUND SQL GENERATING UNECESSARY SQL0437W DURING QUERY EXECUTION |
|
IZ15363 |
3 |
THIS IS A PERFORMANCE ENHANCEMENT FIX, REGARDING SELECT WITH DISTINCT , CARTESIAN JOIN, OR PREDICATE WITH MULTIPLE SUBTERMS. |
|
JR28508 |
3 |
AN SQL QUERY INVOLVING VIEWS AND SUBQUERIES CAN RETURN A SQL0901N ERROR. |
|
IZ15688 |
3 |
WHEN CREATING TABLE WITH SCHEMA AND BLANK NAME IT DOES NOT PERMIT YOU TO CREATE ANY OTHER CREATE TYPES WITH THAT SCHEMA |
|
IZ15365 |
3 |
CASE EXPRESSION IN ORDER BY CAUSES CRASH |
|
IZ26829 |
3 |
A QUERY COULD RETURN SQL16012N ON V95FP1 BUILD WHEN FUNCTION POSITION() OR FN:POSITION() IS USED. |
|
JR28455 |
3 |
SQL1822N UNEXPECTED ERROR CODE "-440" WHEN CALLING A MAPPED FUNCTION USING CHAR() OR CAST FUNCTION WITH CONSTANT STRINGS |
|
IZ18668 |
3 |
SQL3012C WHILE LOADING WITH CLI LOAD UTILITY INTO A TABLE WITH UDT TYPE COLUMN. |
|
IZ21312 |
3 |
WRONG CARDINALITY ESTIMATED FOR A FULLY QUALIFIED SCAN OF THE PRIMARY KEY |
|
IZ26001 |
3 |
SQL0180N ERROR FOR INSERTING INTO NICKNAME AGAINST A ORACLE 11G TABLE WITH DATE TYPE FROM A DB2 TABLE WITH TIMESTAMP TYPE |
|
IZ07985 |
3 |
ENABLE DB2 TO REWRITE NOT EXISTS AND NOT IN SUBQUERIES TO USE ANTIJOIN FOR DELETE AND UPDATE STATEMENTS |
|
IZ20544 |
3 |
BLOCK ALTERING THE INFORMATIONAL CONSTRIANTS FOR NICKNAME TO BE 'ENFORCED' |
|
IZ24282 |
3 |
PERFORMANCE PROBLEM FOR QUERIES CONTAINING OUTER JOIN WITH A VERY LARGE INNER TABLE WITH NON COMPATIBLE JOIN PREDICATES |
|
IZ15364 |
3 |
POOR QUERY PERFORMANCE WHEN THE QUERY HAS "COLUMN=CONSTANT" ON CLAUSE PREDICATE FOR OUTER JOINS |
|
IZ26855 |
3 |
DB2XML-CE: CREATE PROCEDURE STATEMENT DAMAGES DATABASE |
|
Relational Data Services |
|
IZ19583 |
1 |
POTENTIAL ERROR IN QP MANAGED QUERY IF A USER HAS GROUP IDS THATARE LARGER THAN 8 BYTES AND HAVE A LENGTH NOT DIVISIBLE BY 8. |
|
LI73425 |
1 |
RANDOM CRASHES ON FUNCTION SQLRA_COMPARE_ENV_ROUTINE_AUTHS |
|
IZ20415 |
1 |
DB2XML-CE: WORK ITEM PROBLEMS WITH XQUERY DOUBLE VALUES LESS THAN 1E6 |
|
IZ26274 |
1 |
SQL901N (AND POTENTIALLY INSTANCE CRASH WITH DB MARKED BAD) AFTER COMPILING A STATEMENT WHOSE QUERY CAN BE MATCHED TO AN MQT |
|
IZ12363 |
1 |
IN AN ERROR SCENARIO (SMP OR MPP) WE COULD GET INTO A TRAP WHEN CLOSING THE SECTION. |
|
IZ23687 |
1 |
IN A SPECIAL DATABASE CONFIGUARION CONCAT ON EMPTY AND NULL STRIG VALUES (CHAR AND GRAPHIC) SHOULD RETURN NULL, BUT DOES NOT. |
|
IZ27850 |
1 |
FP2: DB2 TRAPS AFTER CALLING SQL PROCEDURE |
|
IZ18050 |
2 |
WLM_CANCEL_ACTIVITY() RETURNS -952 INSTEAD OF -4725 |
|
IZ19756 |
2 |
DB2TEXT UPDATE INDEX HANG WHEN THE DOCUMENT CONTAINS INVALI DATA |
|
IZ20732 |
2 |
TWO DEPENDENT AGENTS ENGAGED IN PROCESSING INVALIDATION OF OBJECT AND SPACE MANAGEMENT DELETION, FIRST AGENT CRASHES. |
|
IZ21575 |
2 |
REPEATED WARNING MESSAGE FROM FUNCTION SQLRIRIDC IN DB2DIAG.LOG |
|
IZ07613 |
2 |
ALLOW IMPLICITLY CREATED SCHEMAS TO BE TRANSFERRED TO THE DEFINER OF THE SCHEMA OR SECADM USER |
|
IZ08052 |
2 |
SIGSEGV IN SQLRA_CACHE_SPACE_MGMT CODEPATHS |
|
IZ17872 |
2 |
BAG PAGE FETCH ERROR WHEN RUNNING OLAP QUERIES WITH BOTH XMLQUERY AND SCALAR AGGREGATE COLS IN THE SELECT LIST WITH INDEXES USED |
|
IZ21044 |
2 |
EXECUTING A STORED PROCEDURE IN A DPF ENVIRONMENT MIGHT CRASH THE INSTANCE IN SQLRL_USERTEMPGETINFO(). |
|
IZ21920 |
2 |
INTERNAL VARIATION LOCK IS NOT RELEASED AFTER SQL0551N ERROR |
|
LI73361 |
2 |
CRASH DUE TO MEMORY OVERWRITE WHEN CONNECTING USER BELONG TO MORE THAN 255 GROUPS |
|
IZ17727 |
2 |
ALTER TABLE STATEMENT WITH MULTIPLE ADD/DROP COLUMN CLAUSES INSERTS INCORRECT VALUES IN SYSCAT.COLUMNS CATALOG TABLE. |
|
IZ21401 |
2 |
SLOWDOWN OR HANG WHEN HIGH NUMBER OF CONNECTIONS WITH CONNECTIONCONCENTRATOR ON |
|
IZ19622 |
2 |
INSTANCE CRASH WHEN EXECUTE RUNSTATS WITH RCT INDEX ONLY OPTION. |
|
IZ19553 |
2 |
OFFLINE BACKUP OF A SPLIT MIRRORED DATABASE TAKEN AFTER "DB2INIDB AS STANDBY" MAY FAIL DUE TO CATALOG TABLE CORRUPTION. |
|
IZ18705 |
2 |
INCORRECT RESULTS WHEN USING ORACLE STRING SEMANTICS AND CONCAT FUNCTION. |
|
IZ13366 |
2 |
SQL WORKSPACE IN APP SHARED HEAP DOES NOT AUTOMATICALLY REDUCE AS WORKLOAD DECLINES - ALWAYS RETAINS HWM |
|
IZ14821 |
2 |
FUNCTION 'DOUBLE' ERRORS WITH SQL00443N WHEN VALUE IS A NULL STRING. |
|
IZ19707 |
2 |
STMM INCREASES PACKAGE CACHE CONFIGURATION INCORRECTLY TO VERY HIGH VALUES |
|
IZ18773 |
2 |
INSTANCE SUSPENDED WITH SIG#23 (TRAPPED AT SQLRA_SQLW_MEM_GET_BLOCLK) |
|
IZ26559 |
2 |
SQLDCSL_GETRECDATAANDLENGTH, PROBE:2165 |
|
LI73030 |
2 |
CONCURRENT CREATE AND DROP VIEW AND/OR TABLE CAN DEADLOCK IN SYSTEM CATALOG TABLES |
|
IZ19335 |
2 |
TRAP OCCURRED POSSIBLY WHEN WE ATTEMPTED TO LATCH THE PLONGIHVLATCH |
|
IZ20011 |
3 |
SQL0901 "BAD EXIT -- IP NOT NULL ON ERROR (IP=7520:0)" WHEN AGENT RUNS OUT OF DBHEAP |
|
LI73307 |
3 |
CASTING OF A ROUND FUNCTION TO A DECIMAL CAN PRODUCE INCONSISTENT RESULTS ON WINDOWS OPERATING SYSTEMS |
|
LI72947 |
3 |
APM SEQ LOCKNAME WILL CONFLICT, IF 2 SIMILARLY NAMED PACKAGES ARE BOUND AT THE SAME TIME. |
|
IZ20542 |
3 |
WRAPPER LIBRARY NAMES WOULD BE WRONG AFTER BACKING UP FEDERATED DATABASE FROM ONE PLATFORM AND RESTORING TO ANOTHER |
|
IZ18642 |
3 |
DB2UPDV8 CRASH WITH SIGNAL 11 (SEGV) IN TRYING TO FREE UP THE SAME MEMORY BLOCK TWICE IN FUNCTION SQLRR_FREE_AUTHINFO() |
|
IZ19224 |
3 |
WLM_GET_ACTIVITY_DETAILS CORRUPTS CHARACTERS WHEN RETURNING RESULTS IN CERTAIN CODE PAGES |
|
Replication |
|
JR28797 |
2 |
REPLICATION MIGRATION V9.5 SCRIPT NEEDS TO INCLUDE AN ALTER ADD COLUMN IGNTRAN_TIME TO IBMQREP_IGNTRANTRC TABLE. |
|
JR28355 |
3 |
REPLICATION ADMIN FIXES FOR DB2 LUW V9.5 FP2 |
|
JR28354 |
4 |
REPLICATION ENGINE FIXES FOR DB2 LUW V9.5 FP2 |
|
Security |
|
LI73376 |
2 |
WHEN GSS AUTHENTICATION IS USED, DATABASE BACKUP FROM ADMIN_CMD STORE PROCEDURE FAILS WITH ERROR SQL30082N RC=25. |
|
JR28613 |
2 |
DB2 HANGS IF DB2AUDIG.LOG FILE EXISTS BUT CAN NOT OPEN. |
|
Self Tuning Memory Manager |
|
IZ19646 |
1 |
IN STMM CONTEXT, MINIMUM SIZE OF SHEAPTHRESH_SHR MAY ROLL TO 4'294'967'295 = 0XFFFFFFFF |
|
IZ18814 |
2 |
INSTANCE MAY CRASH DURING HASH JOIN WHEN STMM IS ENABLED AND IF SORT MEMORY CANNOT BE ALLOCATED |
|
IZ26166 |
2 |
STMM TARGET MEMORY CONSUMPTION TOO HIGH WHEN INSTANCE_MEMORY SET TO VALUE OTHER THAN AUTOMATIC |
|
Spatial Extender |
|
JR28833 |
2 |
GSE0214N AN INSERT STATEMENT FAILED |
|
JR29301 |
2 |
ST_DIFFERENCE APPEARS TO MISS REMOVING A VOID IN THE MIDDLE OF APOLYGON, WHEN COVERED BY THE SECOND POLYGON. |
|
JR28597 |
2 |
DEBUGGING STORED PROCEDURES WITH OVER 400 VARIABLES FAILS IN 9.5 |
|
IZ12515 |
2 |
NORMAL TERMINATION OF NON THREADED FMP PROCESS CAUSES ALARMING MESSAGE TO DB2DIAG.LOG |
|
IZ16391 |
2 |
CALLING A NON-EXISTENT FENCED PROCEDURE FROM A 32BIT LIBRARY CANCAUSE DB2AGENT TO HANG. |
|
IZ16695 |
2 |
SQL0430 OR SQL1131N RECEIVED ON EXECUTION OF A 32-BIT ROUTINE ON HP-UX IPF. |
|
JR28519 |
2 |
DB2 ON WINDOWS EXECUTING AN UDF WITH AN EXTERNAL NAME USING AN UNC PATH FAILS WITH SQL0444N |
|
IZ16818 |
2 |
TIMING ISSUE WITH CRASHING FMP CAN LEAD TO INSTANCE SHUTDOWN |
|
IZ29545 |
2 |
INCORRECT VALUE LENGTH FOR VARGRAPHIC PASSED TO DB2DARI STYLE C STORED PROCEDURE |
|
JR30059 |
3 |
FENCED STORED PROCEDURES MEMORY SEGMENT SIZE IS DOUBLED ON WINDOWS |
|
XML Data Services |
|
IZ26560 |
1 |
DB2XML-CE: WORK ITEM AN XQUERY CRASHES DB2 ON WINDOWS WHEN USING FN:CONTAINS AGAINST AN ATTRIBUTE OF TYPE XS:LIST |
|
IZ22280 |
2 |
XQUERY FN:ROOT MAY CAUSE A -901 ERROR WHEN EXECUTED ON SMALL DOCUMENTS THAT ARE CONSTRUCTED OR INLINED IN THE BASETABLE |
|
LI72650 |
2 |
XML DOCUMENT WITH UTF-8 BOM BUT WITHOUT ENCODING DECLARATION FAILS WITH SQL16132N. |
|
IZ26558 |
2 |
BUCKET XMLSQLX IS FAILING WITH ASSERTION FAILED!!! /VBS/ENGN/INCLUDE/XMLRNNODEMGR.H |
|
IZ24812 |
2 |
DB2 IS BROUGHT DOWN WHEN UPDATING XML COLUMN WITH CONSTRUCTED XML WITH A SPECIFIC STRUCTURE CONTAINING ATTRIBUTES AND NAMESPACES |
|
IZ07157 |
2 |
DB2 XQUERY DEEP-EQUAL OPERATOR MAY FAIL FOR XML DOCUMENTS WHILE COMPARING TEXT NODES. |
|
IZ24902 |
2 |
INSERT OR CREATE INDEX STATEMENT CRASHES THE DB WHILE PROCESSING XML DOCS VALIDATED AGAINST SCHEMAS WITH COMPLEX CONTENT |
|
IZ22884 |
2 |
DECOMPOSITION FAILS ON SOLARIS WITH SQL0204N IF DB2CODEPAGE IS 1208 AND XSR OBJECT NAME CONTAINS JAPANESE CHARACTERS. |
|
IZ07154 |
3 |
DB2 INSPECT OF INLINED XML DOCUMENTS ONLY EXAMINES THE FIRST NODE OF THE DOCUMENT RATHER THAN ALL NODES. |
|
IZ22345 |
3 |
ERRORS THAT OCCUR DURING XML DECOMPOSITION MAY INCORRECTLY BE MAPPED TO -901 ERRORS. |
|
XML Extender |
|
IZ22398 |
2 |
XML EXTENDER PROCEDURES RETURN SQL0313N AFTER RUNNING DXXMIGV PROGRAM DURING MIGRATION TO VERSION 9.5 |
APAR fixes included in Fixpak 1 | APAR No. | Sev. | Abstract |
|
Administration Server |
|
JR28736 |
1 |
SQL "NO DATA FOUND" IS NOT RETURNED WHEN UPDATING A ROW THAT DOESNOT EXIST. |
|
IZ12406 |
1 |
SECURITY: BUFFER OVERFLOW VULNERABILITY IN DAS SERVER PROGRAM. |
|
IZ12798 |
2 |
SECURITY: LOCAL EXPLOITATION OF A FILE CREATION VULNERABILITY INTHE ADMIN SERVER ALLOWS ATTACKERS TO ELEVATE PRIVILEGES TO ROOT |
|
Administration Tools |
|
IZ07994 |
1 |
THE DB2LOOK UTILITY SHOULD USE CATALOG VIEW FOR DL_FEATURE |
|
IZ08182 |
2 |
DB2LOOK -F OPTION NEEDS TO BE UPDATED WHEN DB2_WORKLOAD=1C |
|
IZ08183 |
2 |
DB2LOOK -L: MISSING USING CLAUSE IN OUTPUT |
|
JR28106 |
2 |
DB2MOVE COPY SCHEMA CAN FAIL WITH SQL0440N FOR SPLS DUE TO DEPENDANCY |
|
JR28245 |
2 |
DB2CLI INTERACTIVE TOOL INCORRECTLY DISPLAYS A 64-BIT LENGTH (SQLLEN) FOR THE 32-BIT DRIVER ON WINDOWS. |
|
IZ08105 |
3 |
MULTIPLE ENTRIES IN THE DATABASENAME.CFG |
|
Application Programming Services |
|
IZ10827 |
2 |
NULL INDICATOR MAY BE SET INCORRECTLY WHEN BINDING OUT LOB DATA TO A NON-LOB HOST VARIABLE WHEN TRUNCATION OCCURS. |
|
IZ08639 |
3 |
SET CURRENT PACKAGE PATH STATEMENTS CONTAINING SESSION_USER CAUSE -104 ERROR AT PRECOMPILE TIME. |
|
Buffer Pool Services |
|
IZ07930 |
1 |
DATABASE MARKED BAD BECAUSE OF A BAD PAGE DURING OR AFTER A ROLLFORWARD FROM AN OFFLOADED DB2 BACKUP IMAGE |
|
IZ07759 |
2 |
USING ALTERNATE PAGE CLEANING CAN LEAD TO EXCESSIVE CLEANING OF PAGES IN TEMPSPACE. |
|
IZ19276 |
3 |
POINTER NOT INITIALIZED UNDER SQLBCONDFREEMEM() |
|
Client |
|
JR28938 |
2 |
WSDBU00318117, WSDBU00114287, WSDBU00323215, WSDBU00103320, WSDBU00079920 AND WSDBU00079911 |
|
JR28528 |
2 |
GETTING THE SCHEMA INFORMATION FROM A ZOS DB2 DATABASE CAN CAUSEVISUAL STUDIO TO HANG UNDER CERTAIN CONDITIONS. |
|
Client Interfaces |
|
IZ12277 |
1 |
THE DB2 LIST UTILITIES COMMAND CAUSES AN ASSERTION FAILURE |
|
IZ14134 |
1 |
CLI0119E FROM DB2BP PROCESS |
|
IZ12335 |
1 |
DB2BP PROCESS CRASHES AND DB2 CLP RETURNS DB21018E |
|
IZ09579 |
1 |
ATTEMPTING A CONNECTION IN WIN64 USING THE .NET PROVIDER WILL RESULT IN AN ARITHMETIC OVERFLOW AND UNSUCCESSFUL CONNECTION. |
|
IZ14334 |
1 |
EXECUTING A STORED PROCEDURE FROM A WINDOWS CLIENT AGAINST A UNIX SERVER RETURNING ARRAY OUTPUT WOULD HIT SQL30020N |
|
IZ09517 |
2 |
SQL_ATTR_SQLERRP IS NOT CORRECT WHEN MULTICONNECT=3. |
|
IZ06831 |
2 |
NULLPOINTEREXCEPTION WHEN RETRIEVING LOBS WITH PROGRESSIVE STREAMING USING TYPE 2 JCC DRIVER |
|
JR27794 |
2 |
LEGACY JDBC APP DRIVER CREATES RESULSET AS WRITABLE BY DEFAULT. |
|
IZ12232 |
2 |
NEW DECFLOAT COLUMN IN 9.5 NOT IN RESULTSETS FOR CLI FUNCTIONS |
|
IZ16282 |
2 |
DB2CONNECTION.GETSCHEMA() MAY RETURN INCORRECT RESULTS FOR COLLECTIONS 'INDEXES', 'PRIMARYKEYS', AND 'FOREIGNKEYS'. |
|
IZ07984 |
2 |
COMMAND LINE PROCESSOR (CLP) RETURNS SQL0104N WHEN 'IMAGE' IS USED AS A DATABASE NAME. |
|
JR27933 |
2 |
ARRAY INPUT WITH EXPRESSION FAILED WITH -312 ERROR AGAINST Z/DB2V9 |
|
IZ08026 |
2 |
INCORRECT RESULTS (-1) ON ALL COLUMNS FOR REORGCHK_TB_STATS('S')WHEN MDC TABLES ARE PROCESSED BEFORE OTHER TABLES. |
|
JR28845 |
2 |
TRAILING ZEROS ARE BEING TRIMMED BY THE DB2 .NET PROVIDER WHEN ADECIMAL VALUE IS FETCHED |
|
IZ18116 |
2 |
SQL0181N RETURN WHEN IMPORT OF EXPLAIN_OBJECT TABLE DUE TO TIMESTAMP TYPE HAS ZERO VALUE. |
|
IZ13815 |
2 |
SAP: ENABLE SQLSETCONNECTATTR TO SUPPORT RETRYONERROR AND ALLOW SOME CLI KEYWORDS WHEN SQLPUTDATA IS IN PROGRESS . |
|
IZ12161 |
2 |
UNABLE TO CREATE DB WITH CODESET LENGTH MORE THAN 9 CHARACTER USING CLI DRIVER. |
|
IZ09564 |
2 |
VISUAL STUDIO 2005 DATASET WIZARD CREATES THE STORED PROCEDURES PARAMETERS IN WRONG ORDER AND WITH WRONG DATATYPE. |
|
IZ08042 |
2 |
OLE DB PROVIDER MEMORY LEAK |
|
LI72621 |
2 |
JAVACORE DUMP WHEN USING WEBSPHERE AND JCC T2 CONNECTIVITY ON LINUX |
|
JR28027 |
2 |
DB2.NET PROVIDER CAN IMPROVE PERFORMANCE BY OPTIMIZING THE CREATION OF INTERNAL OBJECTS. |
|
IZ09127 |
2 |
@<PARAMNAME>, <PARAMNAME> OF A PARAMETER IN PARAMETER COLLECTION SHOULD BE TREATED AS THE SAME FOR A NAMED PARAMETER. |
|
IZ10405 |
2 |
GETBOOLEAN() AND GETDB2BOOLEAN() ARE NOT SUPPORTED ON SMALLINT COLUMNS OF INFORMIX DYNAMIC SERVER. |
|
IZ13923 |
2 |
RESET PDBCINFO TO THE ORIGINAL PDBCINFO BEFORE CALLING CLI_ALLOCRESETSTMTINFO WHEN MULTICONNECT=3 |
|
IZ18453 |
2 |
DB2 RAN OUT OF AGENTS DUE TO DB2 .NET CONNECTION OBJECT LEAKING |
|
JR28802 |
2 |
IF DATABASE QUIESCES AND UNQUIESCES, ALL CONNECTIONS IN THE CONNECTION POOL WILL BE STALE AND A -1228 SQL ERROR WILL BE RETURNED |
|
IZ17628 |
2 |
.NET NETWORK DRIVE INSTALLS DO NOT WORK IN V9 |
|
JR28272 |
2 |
SQLGETDATA DOES NOT RETURN ALL DATA WHEN XML COLUMN HAS LARGE AMOUNTS OF DATA |
|
IZ08079 |
2 |
SWAP SPACE REQUIREMENT INCREASE ON SOLARIS/HP/WINDOWS |
|
IZ10695 |
2 |
THE IS NULL EXPRESSION EVALUATION ON THE COMMAND BUILDER GENERATED SQL |
|
IZ11436 |
2 |
DB2DATASOURCEENUMERATOR.GETDATASOURCES() METHOD WILL HANG IF A HOST SYSTEM DOES NOT RESPOND TO DAS REQUESTS. |
|
IZ06935 |
2 |
JCC T2XA SUPPORT FOR REMOTE SERVER CONNECTIONS |
|
IZ09568 |
3 |
TRAP IN SQLALLOCSTMT WHEN MULTICONNECT=3 IS USED |
|
IZ09728 |
3 |
OUTPUT OF DB2LEVEL FOR IBM DATA SERVER DRIVER FOR ODBC AND CLI IS WRONG FOR SPECIAL BUILDS |
|
IZ11754 |
3 |
DB2 MIGHT PERFORM AN INCORRECT CODE PAGE CONVERSION WITH DB2BIDI=YES |
|
JR27848 |
3 |
JCC: DATABASEMETADATA GETUSERNAME() NOT RETURNING CORRECT RESULT |
|
JR28029 |
3 |
SQL0998N RC=16 WITH DB2.NET PROVIDER WHEN MSDTC IS USED AND REGISTRY KEY IS NOT FOUND |
|
IZ16572 |
3 |
SQLGETDESCFIELD SQL_DESC_UPDATABLE ALWAYS RETURNS SQL_ATTR_READWRITE_UNKNOWN |
|
JR28398 |
3 |
UNICODE CLI APPLICATION CAN FAIL WITH CLI0119E WHEN CALLING SQLCOLATTRIBUTESW |
|
IZ09462 |
3 |
A NON-EXISTENT DATABASE NAME SET FOR THE CLI KEYWORD "DATABASE" RESULTS IN CLI0004W INSTEAD OF CLI0199E. |
|
IZ16441 |
3 |
SQL3006C I/O ERROR RUNNING EXPORT AS NON INSTANACE USER |
|
IZ08087 |
3 |
EXECUTENONQUERY RETRUN -1 FOR THE NUMBER OF ROWS AFFECTED |
|
IZ09464 |
3 |
ANY INVALID INSTANCE NAME PASSED THROUGH THE CLI INSTANCE KEYWORD LEADS TO A SUCCESSFUL CONNECTION WHICH IS INCORRECT BEHAVIOR. |
|
LI73227 |
3 |
CLP TRUNCATE OUTPUT BUFFER, IF INPUT DATA IS EBCDIC AND OUTPUT DATA IS UTF-8 IN JAPANESE. |
|
JR27891 |
4 |
INPUT REDIRECT FUNCTIONALITY IS BROKEN IN DB2CMD.EXE |
|
Common Code Infrastructure |
|
IZ07770 |
1 |
EXPORT OR SELECT FROM DB2 V8 Z/OS DBCS DATABASE MAY FAIL AND HANG CLIENT WHEN SELECTING FROM TABLE WITH MIXED FIELDS |
|
IZ11438 |
1 |
THE DB2SET DOES NOT ALLOW LINKED FILE DEFAULT.ENV UNDER <DB2 INSTALLATION PATH> DIRECTORY ON UNIX/LINUX PLATFORMS |
|
IZ09336 |
1 |
STANDALONE TOOL HANG DB2LEVEL, DB2SUPPORT, DB2TRC, ETC. |
|
IZ08501 |
1 |
CONNECTION TO HOST/ISERIES USING THE IBM DATA SERVER DRIVER FOR ODBC AND CLI ON WINDOWS RESULTS IN SQL8002N |
|
IZ08145 |
1 |
KNOWN DISCOVERY IS FAILING DUE TO DB2GENP FAILING ON LINUX |
|
IZ09059 |
1 |
ADDITION A NODE WITH DB2START COMMAND FAILS WITH "-1224" CODE |
|
JR27742 |
1 |
ICU DLL WILL NOT BE INSTALL AS THE VERSION IS THE SAM AS THE ONEALREADY INSTALLED AND WINDOWS INSTALLER DOES NOT COPY THEM. |
|
JR27843 |
2 |
DB2BATCH REPORTS FAR TOO HIGH TIME VALUES IN DB2 V9 ON WINDOWS |
|
JR28749 |
2 |
ON WINDOWS DOMAIN CONTROLLER, RUN: REGSVR32 DB2ADS.DLL, IT FAILSWITH 0XC0000005 ERROR IF MSVCR71.DLL ISN'T ON THE SAME DIRECTORY |
|
IZ13942 |
2 |
LOCK LIST IS NOT PROPERLY AFFINITIZED PER RESOURCE SET. |
|
IZ08060 |
2 |
V9FP4: SQLOGSTT API CAUSE SIGBUS ERROR IN 32 BIT HPIA PLATFORM. |
|
LI73231 |
2 |
DB2SET FAILS ON FP3 IF RUN FROM A USER THAT IS NOT THE INSTANCE OWNER. |
|
LI73057 |
2 |
REPORTED CPU USAGE IS NOT OF THE PROPER SCALE ON LINUX, SUN AND HP |
|
LI72655 |
2 |
POSSIBLE SIGBUS IN CLI FUNCTIONS ON LINUX PPC WHEN PRCTL IS USEDIN CLI APPLICATION |
|
JR28813 |
2 |
INCORRECT PERMISSIONS ON ACLS FOR DB2NODES.CFG |
|
IZ17141 |
2 |
AUDIT LOG FILE INCOMPLETE. |
|
IZ19250 |
2 |
INVOKING CLP COMMANDS DO NOT COME BACK WITH RESPONSE. |
|
IZ18661 |
2 |
SWAP SPACE REQUIREMENT INCREASE ON SOLARIS/HP/WINDOWS |
|
IZ13103 |
2 |
SQL30083N RC=24 CHANGING PASSWORD ON (RHEL) RED HAT LINUX |
|
IZ09411 |
2 |
PERFORMANCE DEGRADATION SEEN IN DB2/AIX ON VERY LARGE SMPS WHEN MOVING FROM DB2 9 TO 9.5 |
|
IZ09711 |
2 |
POSSIBLE STACK CORRUPTION CONVERTING DECFLOAT(16) TO DOUBLE |
|
JR27904 |
2 |
THE SWAP MEMORY METRICS RETURNED BY DB2 LUW ARE INCORRECT ON THE WINDOWS PLATFORMS. |
|
IZ09306 |
2 |
SENDING A SIGNAL TO EDU 1 WITH DB2PD -SIGEDU TOOL FAILED |
|
IZ14046 |
2 |
-1042 RETURN CODE CHANGED TO -1365, BUT WITH NO INFORMATION ON WHICH PLUGIN WAS CAUSING FAILURE |
|
IZ12860 |
2 |
RUNNING DB2SCHEX.EXE, RESULTS IN THE FOLLOWING ERROR: "THE SYSTEM CANNOT EXECUTE THE SPECIFIED PROGRAM." |
|
JR28136 |
3 |
DB2 PERFMON PROVIDER (DB2PERF.DLL) LEAKING HANDLES ON WINDOWS |
|
IZ08069 |
3 |
SQL1084C RETURNED BY DATABASE MIGRATION FROM V8 TO V9.5 OR ON DATABASE ACTIVATION IN V9.5 IF REGISTRY VARIABLE DB2_PINNED_BP=ON |
|
IZ11433 |
3 |
FUNCTION NAMES CORRUPTED WHEN DB2XPRT IS USED TO FORAMAT TRAP FILES |
|
JR27942 |
3 |
ON THE MSCS ENVIRONMENT, DURING THE FIX PACK UPGRADE, A TRAP WILL OCCUR IF THE CLUSTER SERVICE IS STOPPED. |
|
JR27790 |
3 |
AN APPLICATION THAT CONNECTS TO DB2 WITH SERVER_ENCRYPT AUTHENTICATION CAN HANG OR TRAP |
|
JR28451 |
3 |
UNDER THE RARE CASES WHERE A DB2 APPLICATION CONTINUALLY LOADS AND UNLOADS DB2OSSE.DLL, HANDLES ARE LEAKED |
|
JR27682 |
3 |
DB2LICM -L SHOWS WRONG NUMBER OF PROCESSORS ON THE SYSTEM WITH DUAL CORE AND HYPERTHREADING ENABLE CPU |
|
Communication |
|
IZ15408 |
2 |
WRONG SCHEMA AFTER SWITCH OPERATIONS, SQLCODE -204 |
|
Connection Manager |
|
JR28628 |
1 |
DB2 COMMON CLIENT - DATABASE NAMES WITH MORE THAN 8 CHARACTERS NEEDS TO BE SUPPORTED |
|
IZ14803 |
1 |
THE APPLICATION TERMINATES WITH SQL30020N. DB2DIAG.LOG REPORTS HDDA PROTOCOL ERROR. |
|
IZ18481 |
1 |
AGENT TRAP ON CLOSING RESULT SET, WHICH CONTAINS A UDF, RETURNEDFROM PROCEDURE AFTER DELAY |
|
JR28026 |
3 |
DB2.NET PROVIDER SHOULD NOT THROW AN INVALIDOPERATION EXCEPTION WHEN ENLISTTRANSACTION IS CALLED WITH NULL. |
|
IZ15717 |
3 |
DB2 LUW UNABLE TO FIND THE WEBSPHERE MQ PRODUCT ON SOME PLATFORMS, INCLUDING AIX, LINUX AND HP-UX IA64. |
|
LI72657 |
3 |
A TP MONITOR TUXEDO CLIENT FAILS WITH SQL0998N ON 32-BIT PLATFORMS |
|
Control Center |
|
JR27782 |
2 |
STOP BUTTON IN COMMAND EDITOR FAILS TO STOP RUNNING QUERY. |
|
JR27783 |
2 |
STOP BUTTON IN COMMAND EDITOR FAILS TO STOP RUNNING QUERY. |
|
IZ18102 |
3 |
FED: WEB SERVICES GUI NOT GENERATING CORRECT DATATYPES |
|
LI73228 |
3 |
UNABLE TO EXIT FROM USS SHELL (OS/390) SESSION AFTER STARTING DAS |
|
JR28632 |
3 |
POSSIBLE ERROR SQL0180N, SQLSTATE=22007 IN DB2ADVIS WHEN LAUCHED FROM CONTROL CENTER |
|
DB2 Tools |
|
JR28859 |
2 |
DISCOVERY FUNCTION DOES NOT WORK CORRECTLY FOR MS SQL SERVER 2005 BECAUSE OF SYSTEM TABLE CHANGES IN MS SQL SERVER |
|
IZ19008 |
3 |
DB2OSCONF NOT SUPPORTED ON SOLARIS X64, USE PROJMOD. |
|
DRDA Services |
|
LI73111 |
1 |
STORED PROCEDURE PERFORMS EXTERMELY SLOW WHEN INVOKED FORM ZOS V7 USING SQLAM LEVEL < 7 AND LOWER CLIENT |
|
JR28415 |
2 |
SQL0804N WHEN EXECUTING PACKAGE FROM REMOTE Z/OS CLIENT TO DB2 V9.5 SERVER |
|
JR27803 |
2 |
FOR DB2/ZOS DATABASE WITH BIDI CCSID (ARABIC OR HEBREW) CHARACTER DATA IN WRONG ORDER OR HAS OTHER WRONG BIDI ATTRIBUTES |
|
IZ08149 |
2 |
V9FP5: CHANGE TO RETURN REASON CODE "1" OF -30108 WHEN CONNECTION TO ZDB2 |
|
IZ07539 |
3 |
ERROR WHEN PROCESSING LOB DATA WITH PROBE POINT 424 FROM SQLJSDRDAASCBGETEXTDTADATAPTR OR SQLJSDRDAASCBGWINPUTLOB IN DB2DIAG.LOG |
|
JR27775 |
3 |
IN HADR SETUP CLIENT GETS SQL1776N AFTER TAKEOVER BY STANDBY |
|
Data Management Services |
|
IZ11933 |
1 |
IN RARE CIRCUMSTANCES, SORT COMPONENT RETURNS AN INVALID NEGATIVE RETURN-CODE, MAPS TO A -902 & CAUSES THE DB TO BE MARKED BAD |
|
IZ18392 |
1 |
FP1::TYPE 2 MIDC ROLLOUT CAUSING SUBSEQUENT SCANNER TO UPDATE BLOCK PAGE 0 AND WRITE LR WITHOUT LOCKS |
|
IZ08044 |
1 |
AN INPLACE TABLE REORG SCENARIO CAN CAUSE ABEND AND POSSIBLE CORRUPTION |
|
IZ08443 |
1 |
POSSIBILTY OF DUPLICATE OBJECT IDS IN A TABLESPACE. |
|
IZ08139 |
1 |
RUNSTATS ON DGTT WITH PAGE-LEVEL SAMPLING CRASHES DATABASE WITH -1034, MARKING DATABASE BAD |
|
IZ18557 |
1 |
PAGE AND OBJECT DO NOT MATCH - DATABASE CRASH WITH SQLBUFIX PROBE 155 DURING QUERY EXECUTION |
|
IZ11488 |
2 |
CRASH IN SQLDCALCNLOGXORONLY. SIGSEGV ON UNIX, ACCESS_VIOLATION ON WINDOWS. |
|
IZ10995 |
2 |
POSSIBLE INFINITE LOOPING WITH UCA COLLATION AND VARIABLE-LENGTH DATA DURING SORT. |
|
IZ18582 |
2 |
POSSIBLE CRASH/SEGMENTATION-FAULT USING SMP SORTS AND STMM. |
|
JR28154 |
2 |
INSTANCE CRASH DURING BINARY SORT. |
|
IZ05975 |
3 |
PAGE AND OBJECT DO NOT MATCH - DATABASE CRASH WITH SQLBUFIX PROBE 155 DURING QUERY EXECUTION |
|
Data Protection Services |
|
IZ07352 |
1 |
TRAP OCCURS WHEN ATTEMPTING TO DEREFERENCE A NULL DBCB POINTER DURING DISCONNECT. |
|
LI73244 |
2 |
TIMING HOLE CAN CAUSE SEGMENTATION FAULT WHILE ATTEMPTING TO ACQUIRE LOCK INFORMATION FOR LOCK SNAPSHOT. |
|
IZ12670 |
2 |
MINBUFLSN VALUE IN LOG CONTROL FILE NOT CORRECTLY UPDATED AT THEEND OF ROLLFORWARD COMMAND LEADING TO SLOWER ROLLFORWARD RESTART |
|
IZ08117 |
2 |
SELECT+COMMIT CAUSES LOGFULL IN FEDERATED 2 PHASE COMMIT IN V9.1 |
|
IZ08106 |
2 |
DB2AGENT IS WAITING FOR FINISHING LOG ARCHIVING OF DB2LOGMGR. |
|
IZ12177 |
2 |
TRAP DURING DATABASE CREATION/ACTIVATION/CONNECTION WITH DBM CFG PARM AGENT_STACK_SZ SET LESS THAN 256. |
|
IZ08072 |
2 |
ROLLFORWARD PIT TABLE SPACE ONLINE RECOVERY FAILS WITH A TRANSACTION WITH LARGE VOLUME OF LOG RECORDS DURING BACKWARD |
|
LI72398 |
3 |
DB2TAPEMGR NOT RECOGNISING THE DEVICE DRIVER /DEV/RTIBM0 FOR LINUX. |
|
JR28768 |
3 |
NEED TO CHANGE MESSAGE "ADM10502W HEALTH INDICATOR TABLE SPACE OPERATIONAL STATE ..." FROM WARNING TO INFORMATION. |
|
IZ18476 |
3 |
MOVE LOG SKIPPING INFORMATION IN DB2DIAG.LOG FROM DIAGLEVEL 3 TO 4 |
|
LI72668 |
3 |
SIGSEGV (SIGNAL # 11) IN FUNCTION SQLPGOLE WHEN USING ASYNCHRONOUS LOG READER TO RETRIEVE A LOG FILE. |
|
IZ07222 |
3 |
DB2_KEEPTABLELOCK PERFORMANCE ENHANCEMENT |
|
IZ07786 |
3 |
DATABASE NAME IN THE LOCKTIMEOUT REPORTING FUNCTION IS TRUNCATED. |
|
IZ10949 |
3 |
IMMEDIATE UPDATE OF THE DB CFG PARM FAILARCHPATH DOES NOT TAKE EFFECT UNTIL DATABASE IS RESTARTED. |
|
Data Warehouse |
|
IZ08092 |
3 |
POSSIBLE PERFORMANCE SLOWDOWN WHEN DB2 INSTANCE IS RESTARTED WITHOUT RESTARTING QUERY PATROLLER |
|
Development Infrastructure |
|
IZ14703 |
1 |
DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.51.90/4.1.85 FOR DB2 LUW V9.5 FP1 (PART 1) |
|
IZ15304 |
1 |
CLASSNOTFOUND JAVA EXCEPTION WHEN PUT A MESSAGE ONTO A JMS QUEUE FROM A DB2 TRIGGER+UDF |
|
IZ14404 |
2 |
INCLUDE THE TSM ACS FOR DB2 V5.5 GA RELEASE LEVEL. |
|
Documentation and Information Center |
|
IZ14335 |
3 |
TO COMPILE 32 BIT APPLICATIONS ON MFCOBOL COMPILER COBMODE SHOULD BE 32 BYDEFAULT WHICH IS 64. |
|
IZ14965 |
3 |
TRUSTEDCONTEXT.JAVA SAMPLE IS FAILING DUE TO WRONG USERIDS AND PASSWORDS BEING USED IN THE SAMPLE. |
|
Engine Infrastructure |
|
IZ08298 |
1 |
HANG DUE TO GATEWAY AGENT HOLDING DB MANAGER LATCH WHILE DISCONNECTING OUTBOUND CONNECTION |
|
IZ08280 |
1 |
TRAP IN RESERVESUBCLASS AFTER CANCELLING ACTIVITY |
|
JR28767 |
1 |
WHEN ISSUING A CREATE DATABASE STATEMENT FROM THE CLP ON A REMOTE CLIENT, DB2BP TERMINATES. |
|
IZ11542 |
1 |
DIVISION BY ZERO WHEN PROCESSING SYSPLEX SERVER LIST |
|
IZ10350 |
1 |
DROP DB FAILS, BUT WIPES OUT DB DIR WHEN DB CONNECTION EXITS ON ONE NODE ONLY |
|
LI73312 |
2 |
FOR X32 LINUX ANY/ALL ARM CALLS WILL CORRUPT DB2 RUNTIME STACK. THIS IMPACT IS TRUE FOR EWLM AND ANY OTHER ARM IMPLEMENTATION. |
|
IZ12844 |
2 |
INSTANCE SUSPENDED DURING TAKEOVER HADR COMMAND AT SQLRLCATALOGSCAN12BUILDINDEXESEV |
|
IZ08080 |
2 |
READING THE ALTERNATE SEVRER INFORMATION FROM CLIENT SQLDBDIR CAN FAIL WITH SQL10004 |
|
IZ14882 |
2 |
CONNECT USING THIN CLIENT WHEN DBNAME HAS MORE THAN 8 CHARACTERSFAILS WITH SQL0843 |
|
IZ07610 |
2 |
INSTANCE CRASH POSSIBLE DURING OFFLINE BACKUP OF QUIESCED DATABASE, IF CONNECT ATTEMPT FAILS WITH -20157 |
|
IZ08016 |
2 |
ASYNCHRONOUS BACKGROUND PROCESS (ABP) MAY, MISSINGLY, MARK DB BAD IF IT IS RUN AFTER CRASH RECOVERY TO RECOVER BAD DATABASE. |
|
IZ12676 |
2 |
DATABASE MARKED BAD ON PARTITION DUE TO FAILED ROLLBACK DURING REORG INDEX OPERATION. |
|
IZ07987 |
3 |
DB2CKMIG MAY GENERATE CORE FILE AND STOP DUE DURING AN ERROR CONDITION WHEN WRITING DIAGNOSTIC INFORMATION |
|
IZ07243 |
3 |
DB2PD -CATCH IS NOT CATCHING ERROR -1040. |
|
IZ18053 |
3 |
ENHANCE REFRESH LDAP AND CATALOG ODBC DATA SOURCE CLP COMMANDS |
|
JR27776 |
3 |
INSTANCE CRASH AT SQLELDAPREADNODE(). |
|
IZ08142 |
3 |
BACKUP OF A SPLIT MIRROR DATABASE FAILS WITH DATABASE DAMAGED ERROR IN DPF ENVIRONMENT WHEN AUTO MAINTENANCE IS ENABLED. |
|
IZ12190 |
3 |
ERROR WHEN ADD PARTITION : SQLEGETAUTOMATICSTORAGEDETAILS, PROBE:111111 |
|
IZ08383 |
3 |
CANNOT DROP USER DEFINED SERVICE SUBCLASS |
|
Engine Utilities |
|
IZ08749 |
1 |
DB2 PANIC DURING CRASH RECOVERY AFTER A CRASHED XML LOAD |
|
IZ07242 |
1 |
LOAD HIT SQLDFETCHLFD, PROBE:6371 WITH SQLD_IXNOEX "INDEX DOES NOT EXIST" |
|
IZ06798 |
1 |
INTERRUPTING A SNAPSHOT RESTORE THAT IS WAITING AT A PROMPT MAY CAUSE DB2 RESOURCES TO BE LEAKED OR CRASH THE INSTANCE. |
|
IZ18629 |
1 |
XML LOAD: DB2 CRASHED AT SQLR_UPDATE_CATALOGS DURING LOADING |
|
IZ19234 |
1 |
BUFFER MANIPULATOR EDU OUT-OF-MEMORY |
|
IZ12993 |
1 |
PERFORMANCE DEGRADATION (ON THE ORDER OF 50%) OF LOAD UTILITY ON ZLINUX AND HPUX PLATFORMS. |
|
IZ18051 |
1 |
TRAP ON DB ACTIVATE WHEN USING CLUSTER MANAGER ON LINUX390. |
|
IZ07241 |
1 |
LOAD INSERT WITH IDNEXING MODE INCREMENTAL MAY PUT DUPLICATE ROWS INTO THE XML TABLE. |
|
IZ07764 |
1 |
ADD SUPPORT FOR OFFLOADED DB2 BACKUPS USING TIVOLI STORAGE MANAGER ACS FOR DB2. |
|
IZ07248 |
1 |
XML LOAD HANGS, BUT IS INTERRUPTABLE. |
|
IZ13704 |
2 |
ERROR ON LOOKUP PATH IN XML COLUMN PATH INDEX |
|
IZ18631 |
2 |
XMLLOAD - TRAP AT XMLRNSTATS22ADDINSTANCETORESERVOIR |
|
IZ07177 |
2 |
SNAPSHOT RESTORE, DROP DATABASE AND LIST HISTORY OPERATIONS MAY CONFLICT WITH ONE ANOTHER IF ISSUED AT THE SAME TIME. |
|
LI72671 |
2 |
LOAD FAILS WITH SQL0973 DUE TO INSUFFICIENT MEMORY AVAILABLE IN THE UTILITY HEAP. |
|
JR27784 |
2 |
DBM_GET_CFG CAN RETURN SQL0443N AND SQL5066W IN THE DB2DIAG.LOG |
|
IZ07214 |
2 |
DB ALIAS FIX FOLLOWING SNAPSHOT RESTORE WHICH CHANGES DATABASE PATH |
|
IZ07757 |
2 |
ADMIN. VIEW SYSIBMADM.ENV_FEATURE_INFO RETURNS WRONG RESULT. |
|
IZ11262 |
2 |
LOAD FAILURE WITH -3026 (SQL3026N) WHEN DUMPFILE IS SPECIFIED |
|
IZ08237 |
2 |
LOAD TERMINATE CRASH XML SQLB_EMP_INDIRECT_NOT_FOUNDSQLBFIXDATAEMP : ZRC=0X84020019=-2080243687=SQLB_EMP_INDIRECT_NOT_FOUND |
|
IZ03837 |
2 |
LOAD MAY CAUSE A SEG-FAULT AND BRING DOWN THE INSTANCE IF A LOAD OF MDC OR RP TABLE FAILS BEFORE COMPLETING INITIALIZATION. |
|
IZ18669 |
3 |
TRAPPED IN ENGN_SQUS WHILE DUMPING ERROR INFORMATION |
|
IZ18495 |
3 |
SQLUVQDP/SQLUVTUN APIS TO LOG QUIESCE ENTRIES IN HISTORY FILE |
|
IZ07233 |
3 |
EXPORT, WITH STATEMENT, WITH XMLSAVESCHEMA IS NOT GIVING ANY ERROR MESSAGE. |
|
IZ06862 |
3 |
SNAPSHOT BACKUP USING ADVANCED COPY SERVICES (ACS) FAILS ON A DATABASE PARTITION BUT DOES NOT CLEAN UP ITS PARTITAL IMAGE. |
|
IZ10938 |
3 |
BACKUP USING CUSTOMIZED COMPRESSION LIBRARY WILL TRAP ON A MULTI-CPU ENV |
|
IZ08427 |
3 |
UNEXPECTED ERRORS WHEN PERFORMING BACKUP TO ALL DBPARTITIONNUMS |
|
IZ11162 |
3 |
LOAD UTILITY WRITES "LOAD LIST ELEMENT" ERROR MESSAGES IN THE DB2DIAG.LOG |
|
IZ07211 |
3 |
"DB NAME SPECIFIED MATCHES THE SPM NAME" ERROR RETURNED DURING RESTORE |
|
IZ07230 |
3 |
A LOAD TERMINATE ISSUED AFTER CRASH RECOVERY COULD RESULT IN A BAD PAGE ERROR. |
|
IZ08513 |
3 |
IMPLICIT DATABASE CONNNECTION BEFORE AUTOCONFIGURE WILL SEGV |
|
IZ07961 |
3 |
INSERT_UPDATE RETURNS SQL0100W WHEN IMPORT DATA CONTAINS NULL VALUES FOR NOT NULL COL. |
|
Federation |
|
JR27745 |
1 |
CREATING A NICKNAME FOR AN ODBC DATASOURCE RETURNED A SQL0901N |
|
JR28805 |
1 |
TRAP AT FEDERATED SERVER WHEN REMOTE DATASOURCE CONNECTION HAS BEEN DROPPED |
|
JR28811 |
1 |
FEDERATED QUERY USING ODBC DRIVER FOR MS SQL SERVER CAUSES SELECT/INSERT HNG/SPINLOCK. |
|
JR28731 |
2 |
PERFORMANCE ENHANCEMENT FOR FEDERATED QUERIES: THE FIX DISABLES CERTAIN REWRITE TRANSFORMATIONS IS REGRESS QUERY IS PUSHDOWN. |
|
IZ10917 |
2 |
SECURITY VULNERABILITY IN SYSPROC.ADMIN_SP_C |
|
IZ12454 |
2 |
CHANG LINKER FROM XL_C TO G++ IN II WRAPPERS DJXLINK*.SH ON LINUX PPC |
|
IZ17729 |
2 |
SQL0433N IS RETURNED FOR NICKNAME ON V9 IN THE CASE OF "BB" WHERE B IS A BLANK. |
|
JR27743 |
2 |
-901 ERROR WHEN BIND IN HOST VARIABLE IN A PASSTHRU SESSION |
|
IZ10776 |
3 |
SECURITY VULNERABILITY IN SYSPROC.NNSTAT. |
|
JR28829 |
3 |
ORACLE WRAPPER SELECTING DBCLOB DATA CRASHES DB2 WITH ORACLE 10G CLIENT |
|
JR28123 |
3 |
QAPPLY FAILS WITH SQL0404 WHEN INSERTING INTO A NICKNAME TO AN ORACLE UNICODE TABLE WITH COLUMNS DEFINED WITH CHAR SEMANTICS. |
|
IZ18084 |
3 |
IF THE CONSTRUCTOR FOR A WRAPPER OBJECT RETURNS AN ERROR, THE FMP WILL CRASH. |
|
JR28810 |
3 |
WS, BLAST, ENTREZ, HMMER, SCRIPT, XML WRAPPERS MAY TRAP ON ERROR |
|
JR27989 |
3 |
WEBSERVICES WRAPPER MAY CRASH WITH BAD XML |
|
JR28741 |
3 |
SQL0142N ERROR ON SELECT FROM DRDA NICKNAME WHEN THE TOTAL LENGTH OF THE SELECT COLUMNS EXCEEDS ABOUT 4005 BYTES |
|
LI72642 |
3 |
ENGINE SEGVS WHEN ATTEMPTS TO DUMP BINARY DATA FOR IDLE SUBAGENTS IN FEDERATED ENV. |
|
High Availability |
|
IZ11277 |
1 |
A FAILED HADR PEER WINDOW TAKEOVER DOESN'T UNLOCK TSA RESOURCES. |
|
IZ08096 |
1 |
AN INSTANCE TRAP OR CRASH OCCURS AFTER ISSUING A START HADR .. AS PRIMARY COMMAND |
|
IZ15508 |
1 |
DB2HAICU REQUIRES 2ND COLUMN OF DB2NODES.CFG TO BE CANONICAL HOSTNAME |
|
IZ08634 |
1 |
'CREATE DATABASE' COMMAND IN A DPF ENVIRONMENT WITH 2 OR MORE REMOTE MLNS FAILS WITH A SQL1345N SQL ERR CODE. |
|
IZ09308 |
1 |
MOVE DB PARTITIONS FAILED WHEN USING DB2HAICU |
|
IZ08292 |
2 |
DB2HAICU XML MODE EXITS ABNORMALLY WITH A SEGMENTATION FAULT AT THE STAGE OF MAKING A DB2 DATABASE HIGHLY AVAILABLE. |
|
IZ08706 |
2 |
IN TSA ENVIRONMENT, DB2START MAY TIMEOUT AND EXIT PREMATURELY WITH NON-ZERO RETURN CODE. |
|
LI72638 |
2 |
HADR REPORTS "CONGESTION" AND TRANSACTIONS STALL ON PRIMARY DATABASE AFTER LOAD OPERATION IS PERFORMED THERE. |
|
IZ10838 |
2 |
TRANSACTIONS MAY SLOW DOWN PERIODICALLY WHEN USING HADR |
|
IZ08507 |
2 |
AN UNSTABLE AUTOMATED HADR CONFIGURATION IS OBSERVED AFTER CONFIGURING AN INSTANCE FOR HIGH AVAILABILITY USING DB2HAICU. |
|
IZ09863 |
2 |
RESTRICT MOVING OF DB PARTITION 0 UNTIL ALL OTHER PARTITIONS ARE MOVED. |
|
IZ14384 |
2 |
TSA CONTROLLED HA-DB2 RESOURCES MAY BECOME 'STUCK ONLINE' WHEN TSA ATTEMPTS STOP DB2 PROCESSES. |
|
Index Manager |
|
IZ07106 |
1 |
DB2 MAY HANG WHEN RECREATING INDEXES ON A TABLE WITH XML COLUMNS THAT IS IN LOAD PENDING STATE. |
|
IZ11546 |
1 |
XML LOAD: DB2 MARKED BAD AT SQLULOADKEYDELETE WHEN DOING ONLINE LOAD |
|
IZ10357 |
1 |
ROLLFORWARD FAILS DUE TO BAD PAGE ERROR WHEN READING FROM INDEX INFO PAGE |
|
IZ19157 |
2 |
DB2 MAY HIT SIGSEV PROBLEM IF ERROR IS ENCOUNTERED DURING INSERT/DELETE/UPDATE/SELECT THROUGH INDEX |
|
IZ07740 |
3 |
INCORRECT RESULTS DURING REVERSE SCAN |
|
Install |
|
IZ18086 |
1 |
DB2 INSTANCE CREATION FAILS DURING INSTALL ON WINDOWS VISTA WHEN THE COMPUTER BELONGS TO A WORKGROUP, INSTEAD OF A DOMAIN |
|
JR27703 |
1 |
SUBSEQUENT PRODUCT INSTALL FAILS ON VISTA IF THE LOGON USER ACCOUNT IS A DOMAIN USER ID |
|
JR28821 |
1 |
THE RUN TIME CLIENT INSTALL CHECKS SCREEN RESOLUTION EVEN DURINGA SILENT INSTALL |
|
LI72627 |
2 |
THE DB2ISETUP COMMAND IN GUI MODE CRASHES FOR IBM DB2 EXPRESS EDITION VERSION 9.5 GA ON LINUX PLATFORMS |
|
IZ18065 |
2 |
FIXPAK INSTALL OR INSTALLING A 2ND DB2 PRODUCT ON TOP OF AN EXISTING DB2 COPY FAILS, IF THE COPY NAME CONTAINS UNDERSCORE "_". |
|
JR27758 |
2 |
IBM DATA SERVER RUNTIME CLIENT (RTCL) CANNOT BE UNINSTALLED WHEN THERE ARE OTHER DB2 COPIES THAT HAVE PRODUCTS OTHER THAN RTCL. |
|
JR27859 |
2 |
DB2 VERSION 9.5 DATABASE SERVER FOR WINDOWS INSTALL FAILS |
|
JR27705 |
2 |
IBM DATA SERVER RUNTIME CLIENT CANNOT BE UNINSTALLED BY NON ADMINISTRATOR ON VISTA |
|
IZ18061 |
2 |
DB2 UNINSTALLER FAILS TO CHECK FOR DEPENDENCIES |
|
LI72685 |
2 |
ALTOBJ BND FILES ARE NOT SHIPPED WITH V9 ON Z-LINUX. |
|
IZ18085 |
2 |
REGULAR NON-ADMIN USERS UNABLE TO UPDATE CLI CFG AFTER IT WAS UPDATED BY THE FIRST NON-ADMIN USER AFTER THE DB2 INSTALL |
|
IZ14558 |
2 |
CREATING 32-BIT IBM DATA SERVER DRIVER FOR ODBC AND CLI FOR AIX, HP-PARISC, HP-IPF, SOLARIS, LINUX IA64 AND LINUX AMD64 FOR V9.1 |
|
JR28239 |
2 |
V95GA DB2INSTALLATION ERROR ON WINDOWS: THE LOGIN USERNAME OF "USER.NAME" DOES NOT CONFORM TO THE DB2 NAMING RULES. |
|
LI72689 |
2 |
DURING DB2 INSTALLATION, DB2ICRT FAILS WITH DBI1281E DUE TO DB2IDBM NOT FOUND |
|
IZ09309 |
2 |
UNABLE TO EXECUTE ANY CLR STORED PROCEDURES WHEN DB2 CLIENT VERSION AND DB2 SERVER VERSION ARE DIFFERENT. |
|
JR27688 |
2 |
INFORMIX CANNOT BE DETECTED IN WINDOWS INSTALL |
|
IZ15388 |
2 |
DB2SETUP RETURNS 1 (WARNING) INSTEAD OF 67 (ERROR) IF RUN ON UNSUPPORTED PLATFORM |
|
JR28376 |
2 |
DB2IDROP TRAPS IF THE INSTANCENAME IS 8 CHARACTER LONG |
|
JR27753 |
3 |
DB2START FAILS AFTER MIGRATING MSCS INSTANCE TO V9.5 IF THE AUDIT FACILITY IS ENABLED |
|
JR27706 |
3 |
INCORRECT FAILURE MESSAGE WHEN UPGRADING A V9.5 32-BIT INSTANCE TO A V9.5 64-BIT INSTANCE |
|
JR27690 |
3 |
INCORRECT MESSAGE RECEIVED WHEN YOU MIGRATE A DB2 COPY WITH MULTIPLE DB2 PRODUCTS INSTALLED TO DB2 VERSION 9.5 ON WINDOWS. |
|
IZ15234 |
4 |
AN EXTRA COLON, :, IS ADDED TO THE PATH, IF THE ORIGINAL PATH ENDS WITH A COLON. |
|
Interpartition Communication |
|
IZ07620 |
3 |
DB2PD -FCMDETAIL COULD TRAP, PREVENTING THE COLLECTION OF FCM PD DATA. |
|
IZ08095 |
3 |
INCORRECT FCM BUFFERS MEMORY CALCULATION FOR SINGLE PARTITION ENVIRONMENT WITH INTRA_PARALLEL TURNED ON. |
|
JDBC |
|
IY98375 |
2 |
T4 XA TEST HANGS USING GATEWAY |
|
IZ01099 |
2 |
TO ENABLE RESETDB2CONNECTION() AGAINST DB2 UDB V9 |
|
IZ04224 |
2 |
THE JAVA APPLICATIONS ARE HUNG OR UNABLE TO CONNECT WHEN A SYSPLEX MEMBER IS RESTARTED AFTER ALL THE MEMBERS WERE DOWN |
|
IZ04652 |
2 |
GETS -805 ERROR WHEN SYSPLEXWLB IS ENABLE & CURRENTFUNCTIONPATH,CURRENTPACKAGESET PROPERTY ARE SPECIFIED IN THE DATASOURCE |
|
IZ07301 |
2 |
XAER_NOTA ON XA END, IF CALLING ROUTINE WHICH PERFORMS COMMIT ONRETURN |
|
JR27848 |
2 |
JCC: DATABASEMETADATA GETUSERNAME() NOT RETURNING CORRECT RESULT |
|
LI72608 |
2 |
JCC DRIVER NOT CHAINING DRDA BUFFERS CORRECTLY WHEN IN AUTOCOMMIT MODE WITH AUTO GENERATED KEYS & LOB COLUMNS |
|
LI72814 |
2 |
SOME CLASS FILES IN DB2JCC.JAR (JCC DRIVER) ARE CORRUPT. |
|
IZ03496 |
3 |
-4212: NO MEMBER OF SYSPLEX AVAILABLE FROM JCC DRIVER. |
|
IZ07562 |
3 |
BLOB.GETBYTES(1,0) THROWS SQLEXCEPTION |
|
JR27842 |
3 |
TYPE 4 UNIVERSAL JCC DRIVER RETURNS WRONG VALUE FOR DATABASE METADATA FUNCTIONS AGAINST ISERIES. |
|
Monitoring |
|
IZ12410 |
1 |
WLM EVENT MONITOR TABLES MUST TOLERATE PARTITION_NUMBER AND PARTITION_KEY IN NON DPF INSTANCES |
|
IZ08448 |
2 |
ACTIVITIES THAT VIOLATE AN SQLTEMPSPACE THRESHOLD ON A NON-COORDINATOR PARTITION WILL NOT BE COLLECTED CORRECTLY. |
|
IZ02061 |
2 |
INSTANCE HANGS DURING DATABASE DEACTIVATION |
|
IZ07918 |
2 |
WLM_CAPTURE_ACTIVITY_IN_PROGRESS PROCEDURE CAN CAPTURE AN ACTIVITY RUNNING IN A DIFFERENT DATABASE THAN ITSELF. |
|
IZ18775 |
2 |
POSSIBLE MEMORY CORRUPTION IN MONITOR HEAP DURING DYNAMIC SQL SNAPSHOT FOR REMOTE STATEMENTS. |
|
IZ07936 |
2 |
THRESHOLD VIOLATION RECORD FOR THE CONCURRENTWORKLOADOCCURRENCES THRESHOLD MAY HAVE A NON-ZERO ACITIVY_ID ON DPF SYSTEMS. |
|
IZ07941 |
2 |
INCORRECT RESULTS FOR THE QUEUE_SIZE_TOP COLUMN OF THE WLM_GET_QUEUE_STATS TABLE FUNCTION FOLLOWING A RESET OF QUEUE STATS. |
|
JR28834 |
3 |
SQLMONSS API RETURNS SQL1042 ERROR WHEN SNAPSHOT CONTAINS SUBSECTION INFO AND BYTE REVERSAL IS REQUIRED |
|
Performance |
|
IZ09465 |
1 |
DB2BATCH CAN NOT HANDLE THE COMPARISON OF A CONSTANT VALUE WITH A PARAMETER MARKER |
|
IZ09467 |
1 |
DB2BATCH DEFECT - INPUT VALUES ACROSS SEVERAL LINES |
|
IZ08432 |
2 |
RELAX C_CHAR TO SQL_GRAPHIC RESTRICTION IN DB2BATCH |
|
IZ18503 |
2 |
DB2BATCH FAILS WITH CLI0150E WHEN RAN FROM V9FP2 LUW MACHINE TO Z/OS SERVER |
|
LI72980 |
2 |
DB2BATCH SEGV WITH MEMORY FAULT WHEN THE "-O P" PERF DETAIL OPTION IS USED. |
|
IZ18592 |
3 |
GETTING SQL1606W WITH DB2BATCH. |
|
Problem Determination |
|
IZ08028 |
1 |
DB2PD CRASHES OR HANGS WHEN THE -ALLDBP OPTION IS USED ON A DPF SYSTEM WITH MORE THAN ONE PHYSICAL HOST. |
|
IZ12994 |
1 |
DB2WATCH AND DB2FREEZE HAS SOME SECURITY VULNERABILITY. |
|
IZ09086 |
2 |
DB2PD -PAGES SUMMARYONLY OPTION |
|
IZ19239 |
2 |
DB2SUPPORT RETURNS ERROR WHEN COLLECTING NODE DIRECTORY INFORMATION OR COLLECTING OPTIMIZATION PROFILE INFORMATION |
|
IZ11598 |
2 |
-1042 SQLCODE FROM PD_GET_DIAG_HIST WHEN THE QUERIES ARE FIRED MULTIPLE NUMBER OF TIMES |
|
IZ07756 |
3 |
DB2PD DOESN'T CLEARLY SHOW LOCK WAITING CHAIN |
|
IZ11656 |
3 |
MEMORY FAULT IN DB2TRC DB2 IN LINUX |
|
IZ19175 |
3 |
DB2SUPPORT REPORTS ZRC=0X860F000A=-2045837302=SQLO_FNEX "FILE NOT FOUND. |
|
IZ11660 |
3 |
INSPECT WITH INDEXDATA INSPECT OPTION MAY FAIL ABNORMALLY WHEN AN CONCURRENT ONLINE INDEX CREATION ROLLS BACK |
|
IZ19187 |
3 |
DB2SUPPORT DOES NOT EXTRACT ALL TABLES FROM CATALOG |
|
LI72206 |
3 |
DB2INSPF UTILITY THROWS SIGNAL 11 WHEN LONG FILE NAMES ARE USED.(DOES NOT INCLUDE MRI MESSAGE FIX) |
|
IZ08388 |
3 |
NEED IPC ADDRESS INFORMATION TO BE DUMPED BY DB2PD -FMP |
|
Quality Assurance |
|
IZ08195 |
2 |
ACCESSING TABLES LOCATED ON NODEGROUP ID=2 WILL BRING DOWN THE DATABASE |
|
IZ07205 |
2 |
OUT OR INOUT PARAMETERS OF SQL PROCEDURE NOT UPDATED IN CALLER IF PROCEDURE EXITS WITH SQLCODE 100 |
|
Query Compiler, Rewrite, Optimizer |
|
IZ15366 |
1 |
FIX TO GENERATE IMPLIED PREDICATE WITH JOIN CLAUSE |
|
JR28379 |
1 |
XML QUERY CAUSES INSTANCE CRASH. SELECT XMLQUERY( '$T/CONTENUTOGENERICO/METAINFO'PASSING BY REF "T.XML" ..... |
|
JR27966 |
1 |
INSERT CONTAINING A SELECT WITH EXISTS ON A NICKNAME INSERTS INCORRECT ROWS |
|
JR27774 |
1 |
SQL0901N ON QUERY RUN. |
|
IZ15212 |
1 |
INLIST PERFORMANCE ISSUES.OPTIMIZER PROCESSING ISNULL PRED |
|
LI72662 |
1 |
INSTANCE CRASH WHEN COLUMN FUNCTION INSIDE COLUMN FUNCTION UNDERORDER BY CLAUSE |
|
IZ08012 |
1 |
LIKE PREDICATE HANDLING MAY CAUSE POOR QUERY PERFORMANCE. |
|
IZ10061 |
1 |
INSTANCE CRASHES DUE TO RECURSION IN SQLNQ_FIXUP_CODEPAGE |
|
IZ10941 |
1 |
IMPROVE QUERY PERFORMANCE OF AGGREGATION FUNCTIONS COUNT, COUNT_BIG, SUM WITH DISTINCT KEYWORD |
|
IZ15213 |
1 |
ENHANCE INLIST PREDICATE TO JOIN TRANFORMATION FOR A QUERY INVOLVING INLIST WITH TWO OR MORE SUBQUERIES |
|
IZ07531 |
1 |
IMPROPER REMOVAL OF A JOINED TABLE DURING THE QUERY REWRITE PHASE OF OPTIMIZATION PRODUCES INCORRECT RESULTS. |
|
IZ07923 |
1 |
UDB MAY RETURN WRONG RESULT SET WHEN DIFFERENT SIZE OF CHARACTER OR GRAPHIC COLUMN USED AS CONDITION. |
|
JR27555 |
1 |
UNDER CERTAIN STRICT CONDITIONS A QUERY INVOLVING AN OUTERJOIN MAY RESULT IN A CRASH. |
|
LI72730 |
1 |
SQL0180/22007 ERROR CALLING PROCEDURE FROM Z/OS CLIENT |
|
LI72795 |
1 |
DUPLICATE ORDER BY COLUMN IN THE WINDOW ORDER CLAUSE OF AN OLAP FUNCTION CAUSES A CRASH |
|
IZ18083 |
1 |
INCORRECT RESULTS FROM REFERENCING NULLABLE COLUMNS WITH CHECK CONSTRAINTS |
|
JR27872 |
2 |
DB2 CAN ABEND WITH A SQL1224N MESSAGE WHEN THE DB2COMPOPT REGISTRY VARIABLE IS SET AND THE QUERY CONTAINS A GROUP BY |
|
IZ10115 |
2 |
PERFORMANCE DEGRADES DUE TO SUBQUERY COSTING WITH NLJOINS |
|
IZ08752 |
2 |
POOR QUERY PERFORMANCE FOR COMPLEX QUERIES HAVING COMPLEX CORRELATED SUB-QUERIES EXECUTED LATE IN THE QUERY EXECUTION |
|
IZ11163 |
2 |
AN SQL QUERY USING AN LEFT JOIN FAILS WITH SQL0901N ("FOUND ZERO CLOB.RESET".) |
|
IZ14885 |
2 |
OPTIMIZER ENHANCEMENT - CHECK ALWAYS TRUE/FALSE INLIST SUBTERM IN OR PREDICATE |
|
IZ18520 |
2 |
MATCHING QUERY'S SUM(C1+C2) WITH MQT.SUM(C1)+MQT.SUM(C2) IF COLUMNS C1, AND C2 ARE DEFINED AS NOT NULL |
|
JR28198 |
2 |
UNEXPECTED QUERY RESULTS WHILE USING INTERVAL IN A SUB QUERY. |
|
IZ08792 |
2 |
-901 ERROR STATING THAT A "QUN" COULD NOT BE FOUND FOR CERTAIN XQUERIES. |
|
IZ19141 |
2 |
PERFORMANCE REGRESSION IN LIMITED CIRCUMSTANCES FOR INTRAPARALLISM USERS |
|
IZ08102 |
2 |
SQL0138N WITH DB2 UDB WITH SUBSTR FUNCTION IN SQL PROCEDURE. |
|
JR27874 |
2 |
REFERENCING TO AN INVALID ADDRESS MEMORY |
|
IZ15361 |
2 |
FIX TO GENERATE IMPLIED PREDICATE WITH JOIN CLAUSE |
|
IZ14057 |
2 |
INCORRECT RESULT MAY BE RETURNED IN OPTLEVEL 5 OR HIGHER IF THE QUERY HAS A FULL OUTER JOIN USED AS AN INPUT TO UNION ALL. |
|
IZ08758 |
2 |
USAGE OF VARCHAR_BIT_FORMAT AND VARCHAR_FORMAT_BIT SCALAR FUNCTIONS MAY EXPERIENCE A PERFORMANCE DEGRADATION |
|
IZ13204 |
2 |
IMPORT WITH BUFFERED INSERT INTO A DPF TABLE CAN CREATE INVALID VALUES FOR TIMESTAMP COLUMNS WITH DEFAULT ON COORDINATOR NODE |
|
IZ13039 |
2 |
REWRITE OF CASE STATEMENT CAN LEAD TO WRONG RESULTS, REGRESSION INTRODUCED BY APAR IY69208 |
|
JR28452 |
2 |
DB2 CAN ABEND WHEN DB2_COMPOPT IS SET AND THE QUERY CONTAINS A GROUP BY OPERATION AND THERE ARE VERY FEW FREQVALUES STATISTICS |
|
IZ09120 |
2 |
WRONG RESULT FROM STATEMENT WITH TWO OR MORE OLAP FUNCTIONS WITHCOMPATIBLE PARTITION-BY CLAUSES WITH ONE BEING EMPTY |
|
IZ15216 |
2 |
REWRITE LEFT OUTERJOIN TO INNER JOIN IN MERGE STATEMENT THAT HAS UPDATE PERFORMS POORLY. |
|
IZ10351 |
2 |
JAVA STORED PROCEDURES WITH ARRAY PARAMETERS DEFINED AS FOR BIT DATA RETURN SQL4302N DURING CALL |
|
IZ08470 |
2 |
TRANSIENT DATATYPE NOT ALLOWED WITH GLOBAL TEMPORARY TABLE. |
|
LI72676 |
2 |
DB2 MAY ISSUE SQL0901N ERROR IN QUERY OPTIMIZATION |
|
JR28676 |
2 |
QUERY WITH IN CLAUSE INSIDE WHERE CLAUSE GIVES WRONG OUTPUT. |
|
IZ08154 |
2 |
COMPILING A STORED PROCEDURE RETURNS -101(RUNNING OUT OF STATEMENT HEAP) IN A DPF ENVIRONMENT |
|
JR27799 |
2 |
COLUMNS NOT LISTED IN THE FOR UPDATE OF CLAUSE SHOULD NOT BE MARKED UPDATABLE IN THE EXTENDED DESCRIBE |
|
LI73150 |
2 |
PERFORMANCE IMPACT FROM NOT ROUTING A QUERY AGAINST A UNION ALL VIEW TO A MQT |
|
IZ08120 |
2 |
POOR QUERY PERFORMANCE FOR QUERIES HAVING FETCH FIRST N ROWS CLAUSE OVER COMPLEX JOINS |
|
LI72656 |
2 |
TAUTOLOGY PREDICATE PUSH DOWN THROUGH A SELF-JOIN COMMON EXPRESSION MAY CRASH THE DATABASE |
|
IZ15530 |
2 |
INCORRECT RESULTS ARE RETURNED FOR XQUERY LET $Y := (), $Z := $Y RETURN "HELLO" ; AN EMPTY SEQUENCE IS RETURNED. |
|
IZ10872 |
2 |
AN ELIGIBLE XML VALUE INDEX MAY NOT BE PICKED UP BY OPTIMIZOR FOR A "BETWEEN" PREDICATE, RESULTING SUB-OPTIMAL QUERY PLAN. |
|
LI73126 |
2 |
CRASH IN SQLNO_PROP_TQFOR A QUERY THAT CONTAINS DISTINCT AND/OR ORDER BY CLAUSE AND INVOLVE OUTERJOINS |
|
IZ09272 |
2 |
XMLEXISTS() AND XMLTABLE() HAVE PERFORMANCE REGRESSION WITH V9.5 |
|
IZ08035 |
2 |
A POSITIONED UPDATE OR DELETE FAILS WITH SQL0509N IF A CURSOR ISOPENED AGAINST ALIAS AND UPDATE OR DELETE AGAINST BASE TABLE. |
|
IZ15897 |
2 |
IN DPF ENVIRONMENT, CORRELATED UPDATE OF UNION ALL VIEW OR CORRELATED UPDATE OF TABLE WITH SUBQUERY MAY GIVE INCORRECT RESULTS. |
|
JR27652 |
2 |
SQL1585N ERROR MESSAGE WHEN THE DB2_REDUCED_OPTIMIZATION AND DISTINCT FUNCTION ON LARGE COLUMNS (CLOB, DBCLOB, BLOB) |
|
IZ09646 |
2 |
QUERIES USING THE XUNNEST OPERATION MAY NOT USE ALL AVAILABLE XML INDEXES. |
|
JR28283 |
2 |
QUERIES FAIL TO HANDLE THE VALID CONVERTION RESULT FROM STRING TO NUMBER/DATE/TIME. |
|
IZ08351 |
2 |
UNEXPECTED SORT OVERFLOWS ON QUERIES WITH DUPLICATE ELIMINATING SORTS. |
|
JR27990 |
2 |
FED: INCORRECT QUERY RESULTS WITH COLLATING_SEQUENCE 'Y' |
|
IZ06118 |
2 |
ENHANCE MATCHING GROUPING SETS AND ROLLUP MQT THAT HAS AGGREGATEDISTINCT COLUMN |
|
IZ15701 |
2 |
MQT TABLE IS NOT PICKED UP BY USING MAX(SUBSTR( FUNCTION. |
|
LI72810 |
2 |
EARLY EVALUATION OF EXPRESSION IN SQL UDF RESULTS IN RUNTIME ERROR. |
|
IZ09631 |
2 |
ENABLE FILTERING TO BE PUSHED THROUGH SUB-SELECTS CONTAINING THE RAISE_ERROR FUNCTION TO IMPROVE PERFORMANCE. |
|
IZ15379 |
2 |
CRASH IN SQLNO_FIX_DEPEND_QUN |
|
LI72640 |
2 |
DB2 "VALUES TREAT(1 AS INT)" WILL CRASH INSTANCE |
|
JR27716 |
2 |
WRONG RESULTS: POSSIBLE WRONG NULL VALUE RETURNED WHEN DB2COMPOPT IS SET |
|
LI73338 |
2 |
INSTANCE IS CRASHING WHEN CUSTOMER RUNS LOT OF DB2 RUNSTATS SET PROFILE. |
|
LI72659 |
2 |
CASTING LITERAL CONSTANT TO A LARGE SIZE VARCHAR CORRUPTS MEMOR |
|
JR28475 |
2 |
DB2AGENT CRASH (SIGTRAP) ON INNER JOIN AND OUTER JOIN QUERY WITH MULTIPLE IN CLAUSES (CORRELATED SUBQUERY, OR PREDICATE) |
|
JR27778 |
2 |
EXPLAIN WITH/FOR SNAPSHOT WHEN MQT MATCHING IS ENABLED , FAILES WITH ERROR SQL0104N. |
|
IZ08642 |
2 |
SQL STATEMENT WITH SUM, COUNT, OR AVG OF DISTINCT COLUMN ROUTED TO GROUPING SETS MQT RETURNS WRONG RESULTS. |
|
IZ09318 |
2 |
QUERY COMPILATION FAILS WITH SQL0901 "BAD PLAN; UNRESOLVED QNC FOUND" |
|
IZ10230 |
2 |
SQL STORED PROCEDURE PERFORMS EXTREMELY SLOW WHEN IT IS INVOKED FROM A REMOTE CLIENT |
|
IZ09266 |
2 |
DIFF IN BUCKET XMLXQUERY TESTCASE XQRY233.PL DUE TO A PROBLEM WITH POSITIONAL PREDICATE REWRITING. |
|
JR27908 |
2 |
ALTERING UDB TIMESTAMP COLUMN WILL FAIL WITH ORACLE DATE COLUMN |
|
IZ18438 |
2 |
WHEN PLANNING THE INDEX ORING ALTERNATIVES, THE OPTIMIZER ENFORCES ALL PREDICATES IN A SUBTERM OF THE OR PREDICATE. |
|
IZ09197 |
3 |
A VERY COMPLEX QUERY MAY RETURN A WARNING MESSAGE SQL0437W AFTERUPGRADING TO FIX PACK 10 OR LATER |
|
IZ15307 |
3 |
SQL0348N WHEN USE NEXTVAL OR CURVAL OF SEQUENCE IN SQL |
|
IZ07609 |
3 |
IN V9.5 GA, WE DON'T SUPPORT JITS ON OBJECT(TYPED) TABLES. WE TRY TO ADD THIS SUPPORT IN V95FP1 |
|
IZ14891 |
3 |
ALLOW QUERY REWRITE TO TRANSFORM INLIST SUBTERMS OF OR PREDICATETO OR SUBTERMS |
|
JR27712 |
3 |
DB2 CAN ABEND WITH A SQL1224N OR SQL0901N MESSAGE WHEN THE DB2COMPOPT VARIABLE IS SET AND SQL USES OUTER JOINS |
|
IZ08760 |
3 |
UNION ALL QUERY POOR PERFORMANCE WHEN THERE ARE CORRELATED SUBQUERIES DUE TO PREDICATE PUSHDOWN NOT HAPPENNING |
|
IZ08135 |
3 |
RUNNING SQL CAUSING SQL0901 |
|
JR27917 |
3 |
ERROR -901 RETURNED WHEN INVOKING A FUNCTION THAT HAS THE "MODIFIES SQL DATA " ATTRIBUTE." |
|
IZ15357 |
3 |
SQL0437W RC=3 RETURNED WHEN USING OPTLEVEL=5 FOR QUERIES WITH THAT HAS DISTINCT AND THE COLUMN LIST IS LONG (IE. 33 COLS). |
|
IZ07927 |
3 |
LIKE PREDICATE HANDLING MAY CAUSE POOR QUERY PERFORMANCE. |
|
JR28168 |
3 |
IN DB2 LUW V9.5, A WRONG RESULT SET CAN BE RETURNED WHEN THERE ARE MULTIPLE SUBSELECTS CONSUMING A COMMON TABLE EXPRESSION |
|
IZ19679 |
3 |
USING V8-STYLE XMLELEMENT/XMLATTRIBUTE IN NON-UNICODE DATABASE GIVES INCORRECT OUTPUT |
|
IZ08707 |
3 |
WHEN SYNC JITS IS TRIGGERED, JITS MIGHT GET INCONSISTENT STATS. OPTIMIZER COULD THROW A 437 WARNING FOR INCONSISTENT STATS. |
|
JR27834 |
3 |
DELETE STATEMENT ON NOT LOGGED GLOBAL DECLARED TEMP TABLE DELETES ALL ROWS |
|
IZ08093 |
3 |
POSSIBLE POOR QUERY EXECUTION PERFORMANCE WHEN JOINING ON COLUMNS CONTAINING A LARGE PERCENTAGE OF NULLS |
|
IZ08802 |
3 |
XML COLUMN INTERFERES WITH DEFAULT VALUE IN INSERT/UPDATE |
|
IZ08075 |
3 |
SQL QUERY DUMPING SQLCODE -901. |
|
IZ08030 |
3 |
AUTOMATIC STATISTICS PROFILING DOES NOT POPULATE PROFILE IF NONEINITIALLY EXISTS |
|
IZ07009 |
3 |
STATS FABRICATION BEHAVIOR INCONSISTENCE WHEN TABLE IS EMPTY. |
|
LI72985 |
3 |
SIGSEGV IN SQLNO_SMP_CREATE_PART_FROM_KEY_ORDER |
|
IZ07360 |
3 |
POSSIBLE INCORRECT RESULTS AT OPTLEVEL <=3 FOR IN LISTS CONSISTING OF MULTIPLE INSTANCES OF 1 UNIQUE ELEMENT (E.G. C1 IN (5,5)) |
|
IZ09045 |
3 |
QUERY RETURNS -101 DUE TO NOT ALL TABLES ARE BEING PUSHED DOWN THROUGH UNION ALL |
|
IZ08091 |
3 |
COMPILE TIME AND MEMORY REQUIREMENTS MAY INCREASE, GREEDY JOIN MAY BE USED WHEN CONVERTING IN LIST TO JOINS - SQL0437W RC 1 |
|
IZ08076 |
3 |
RUNSTATS USING SET PROFILE ONLY WITH 'AND INDEXES ALL' ON TABLE WITHOUT INDEX DOES NOT INCLUDE 'AND INDEXES ALL' CLAUSE. |
|
JR28795 |
3 |
REMOTE QUERY TO GENERATE RTRIM FUNCTION WHEN VARCHAR_NO_TRAILING_BLANKS COLUMN SETTING IS "Y". |
|
JR27846 |
3 |
A 'NOT IN' SUBQUERY HAS BEEN INTERNALLY REWRITTEN TO FORM A COMMON SUBEXPRESSION AND PREVENT FURTHER OPTIMIZATION. |
|
IZ15264 |
4 |
FOR EXPLAIN STATEMENT, WE SUPPORT DECLARE CURSOR FOR. BUT DECLARE CURSOR SMT_NAME IS NOT SUPPORTED FOR EXPLAIN. |
|
IZ05853 |
4 |
OPTIMIZER USES DEFAULT FILTER FACTOR FOR LOWER() AND LCASE() |
|
IZ07908 |
4 |
SQL20059W WARNING NOT RAISED AT MQT CREATION WHEN SPECIAL REGISTERS ARE USED |
|
IZ15303 |
4 |
OPTIMIZER USES DEFAULT FILTER FACTOR FOR LOWER() AND LCASE() |
|
Relational Data Services |
|
IZ15700 |
1 |
REVERTING TO AN EARLIER FIX PACK LEVEL RESULTS IN -902 ERROR WHEN ATTEMPTING TO CONNECT TO DATABASE. |
|
IZ09849 |
1 |
CONNECTION IDLE TIME THRESHOLD VALUE MAY WRAP INTERNALLY AND ENDUP WITH UNPREDICTABLE VALUE |
|
IZ11307 |
1 |
POSSIBLE MEMORY LEAK IF USING ACTIVITY COLLECTION AND POSSIBLE TRAP IF USING ACTIVITY COLLECTION AND WLM QUEUING THRESHOLDS. |
|
IZ14827 |
1 |
MIGRATION FROM A DB2 UDB V8.X UNICODE DATABASE WITH NON-IDENTITYCOLLATION TO DB2 V9.5 WILL FAIL |
|
JR27762 |
1 |
SIGNAL #11 IS RECEIVED FROM SQLRLC_CHECK_AVAILABLE_MEMORY WHEN LOADING/UPDATING XML DATA |
|
IZ08458 |
1 |
FED:DB2 WILL DUMP WHEN WE ALTER A NICKNAME TO ADD INDEX AND THE REMOTE TABLE HAS TOO MANY COLUMNS |
|
JR27795 |
1 |
INCORRECT LOCK PROCESSING CAUSES DB2 DATABASE TO CRASH. |
|
IZ18690 |
1 |
MEMORY LEAK IN PRIVATE HEAP USING GATEWAY CONCENTRATOR OR TWO_PHASE COMMIT |
|
IZ13767 |
1 |
WHEN REAL-TIME STATISTICS FABRICATED STATS, IT MIGHT CORRUPT THE COLUMN PACKED DESCRIPTOR |
|
LI73261 |
1 |
MEMORY LEAK IN THE APPLICATION HEAP MEMORY. |
|
IZ09953 |
1 |
POSSIBLE CRASH LOAD IN DPF WHEN TARGET-TABLE HAS CONSTRAINTS, INDEXES, AND TBLSPC IN BACKUP PENDING STATE. |
|
LI73220 |
1 |
REAL-TIME STATISTICS ON TABLE WITH DEFAULT VALUE MAY RESULT IN -901 |
|
IZ08403 |
1 |
SQL0083C DURING SORT MEMORY ALLOCATION |
|
IZ10894 |
1 |
POTENTIAL TRAP SCENARIO - TRUNCATION OF INTERNAL LOB DESCRIPTOR - SQLRIMSO() SHOULD BE IN THE CALL STACK |
|
JR28803 |
2 |
DATABASE LOAD USING DB2LOAD API CAUSES DB2 EXCEPTION: SQLSTATE=40003 |
|
LI72660 |
2 |
DB2AGENT SIGSEGV FOLLOWING ERROR WHILE OBTAINING A TABLE QUEUE LATCH |
|
IZ09248 |
2 |
SNAPSHOT OUTPUT CAN INCORRECTLY SHOW A SUBSECTION # 0 EXECUTING AT A NON-COORDINATOR NODE. |
|
IZ09943 |
2 |
FAILED TO ADD UNIQUE CONSTRAINT WHEN CREATE NICKNAME |
|
IZ09307 |
2 |
TOTALDBPARTITIONCONNECTIONS THRESHOLD WAS CHANGED TO BEHAVE SIMILARILY TO OTHER QUEUING THRESHOLDS |
|
IZ08885 |
2 |
PANIC WHEN DROP GLOBAL TEMPORARY TABLE AFTER FEDERATES COMMIT ERROR. |
|
IZ10965 |
2 |
VAR, STDDEV, AND VARIANCE FAIL WITH 901 IN MPP MODE ON A DECFLOAT COLUMN |
|
IZ12145 |
2 |
USERS SUBMITTING QUERIES THAT DO NOT HAVE DBADM AUTHORITY MAY CAUSE POSSIBLE CONTENTION ON SYSIBM.SYSUSERAUTH SLOWING DOWN QUERY |
|
IZ08048 |
2 |
DB2 INSTANCE PANIC WHEN RUNNING ADMIN UDF FUNCTIONS |
|
IZ14700 |
2 |
MIGRATING FROM DB2 V9.1 TO DB2 V9.5 FAILED-INOPERATIVE XSROBJ |
|
LI72664 |
2 |
SQL0901 WHEN TRYING TO DROP A TABLE OR CONSTRAINT |
|
LI73053 |
2 |
DB2 ENGINE TRAP ON 32BIT LINUX OR WINDOWS WITH TRACE ON |
|
IZ08933 |
2 |
INCORRECT VALUES RETURNED FOR SOME FIELDS OF WLM_GET_ACTIVITY_DETAILS |
|
IZ08029 |
2 |
CLOB INPUTS CAUSE APPLICATION HEAP TO BE EXHAUSTED |
|
IZ08380 |
2 |
DB2 WILL APPEND ADDITIONAL CHARACTERS TO THE END OF THE QUALIFIER IN THE VIEW WHEN PERFORMING AN ALTER TABLE STATEMENT |
|
IZ13804 |
2 |
AUDIT SQL STATEMENTS INCORRECTLY. |
|
IZ12207 |
2 |
ACTIVITY RECORDS GENERATED BY WLM_CAPTURE_ACTIVITY_IN_PROGRESS ARE MISSING VALUES FOR SOME MONITOR ELEMENTS. |
|
IZ09995 |
2 |
WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES TRUNCATES CLIENT_USER, CLIENT_WRKSTNNAME, CLIENT_APPLNAME AND CLIENT_ACCTNG |
|
IZ08144 |
2 |
HIT -901 DUE TO "SECTION IDS DO NOT MATCH" WHEN PERFORM SQL QUERIES. |
|
IZ08077 |
2 |
VIEW COLUMN NULLABILITY INCORRECT AFTER MIGRATING TO DB2 VERSION 9.5 |
|
IZ12551 |
2 |
IMPORT OR LOCK TABLE ON TABLE HIERARCHY FAILING WITH SQL0551N EVEN THOUGH REQUIRED PRIVILEGES ARE HELD. |
|
IZ07143 |
2 |
SQL0302 ERROR OCCUR, AFTER DB2RBIND/DB2 REBIND EXECUTED. |
|
IZ16004 |
2 |
DISTRIBUTION PROTOCOL ERROR SQLSTATE 58009 RECEIVED WHEN RETRIEVING STORED PROCEDURE RESULT SET WITH LOB COLUMNS |
|
IZ12174 |
2 |
IDENTITY/SEQ. COLUMNS ARE RESET BACK TO 'START WITH' VALUE AFTER'RESTART' AND 'SET' ARE ISSUED IN SEQUENCE AGAINST THE TABLE |
|
IZ08107 |
2 |
DB2 TRAPS IN SQLPXTENTRYSWITCHIN WHEN NOT USING XA ENVIRONMENT. |
|
IZ12123 |
2 |
UNEXPECTED SQL0901N "COLUMN NUMBER OF OF RANGE" ERROR ACCESSING TABLE AFTER ALTER TABLE STATEMENT |
|
JR27754 |
2 |
XQUERY FAILS WITH SQL0901N (BUFFER TOO SMALL TO HOLD DATA) IF MULTI-BYTE CHARACTERS IN XISCAN. |
|
IZ07335 |
3 |
FAILED CLOSE DURING ROLLBACK DB2DIAG.LOG MESSAGE INCORRECTLY MARKED AS SEVERE LEVEL. |
|
LI72643 |
3 |
RUNTIME IS NOT GENERATING CORRECT INDEX START/STOP KEYS |
|
JR28750 |
3 |
PERF IMPACT FROM THE LARGE NUMBER OF SQLOWRITE CALLS |
|
IZ07939 |
3 |
TRAP POSSIBLE IF USING WLM_CANCEL_ACTIVITY TO CANCEL MULTPLE ACTIVITIES AND ONE ACTIVITY IS A CURSOR OPEN ON A FENCED UDF. |
|
IZ08258 |
3 |
UOWWAIT STATE RETURNED FOR WORKLOAD OCCURRENCE WHEN WORKLOAD OCCURRENCE IS WAITING ON LOCK |
|
JR28801 |
3 |
SQL0952N ON CLP OR SQL0902 RC="" IN CLI WHILE SELECTING CLOB FROM V8 CLIENT TO V9.5 SERVER. |
|
IZ09869 |
3 |
SQL0501N INCORRECTLY REPORTED ON FETCH AFTER COMMIT FOR ACTIVE WITH HOLD CURSOR, INVOLVING WLM_CANCEL_ACTIVITY OR DGTT |
|
IZ11418 |
3 |
PERFORMANCE DEGRADATION WHEN USING TABLE FUNCTIONS TO QUERY ALL TABLES IN ALL SCHEMAS. |
|
IZ18511 |
3 |
MEMORY LEAK DURING SQL STORED PROCEDURE INITIALIZATION |
|
LI72658 |
3 |
-901 AND " VAR NOT FOUND BY ID " ERRORS BEING REPORTED IN THE DB2DIAG.LOG |
|
IZ07826 |
3 |
ADD MISSING ACTIVITY PD INFORMATION |
|
IZ08638 |
3 |
UNNECESSARY DIAGNOSTIC INFORMATION IS BEING WRITTEN TO DISK FOR LOB BINDOUT SCENARIOS UNDER WORK LOAD MANAGER CONTROL |
|
IZ07947 |
3 |
CANCELLING STORED PROCEDURES USING WLM_CANCEL_ACTIVITY HAS UNPREDICTABLE BEHAVIOR. ACTIVITIES MAY OR MAY NOT BE CANCELLED. |
|
LI72663 |
3 |
AN OFFLINE TABLESPACE THAT CONTAINS TABLES WITH THE "RESTRICT ONDROP" FEATURE CANNOT BE DROPPED. |
|
IZ09060 |
3 |
DAY OF THE YEAR TOKEN DDD FOR TO_CHAR/TO_VARCHARFORMAT IS NOT VALID AT THIS MOMENT. |
|
JR27765 |
4 |
PUBLIC NOT GRANTED PERMISSION TO EXECUTE SYSIBM.SQLERRM_EXT INTERNAL FUNCTION |
|
IZ07634 |
4 |
THE DB2EXPLN REPORTS ALL DATA PARTITIONS WILL BE ACCESSED WHEN DATA PARTITION ELIMINATION HAS BEEN MARKED REDUNDANT. |
|
LI72630 |
4 |
POTENTIAL MEMORY CORRUPTION AND/OR INSTANCE CRASH DURING DB2 UDB AUTHENTICATION |
|
Replication |
|
JR27735 |
3 |
REPLICATION ADMIN FIXES FOR DB2 LUW V9.5 FP1 |
|
JR27734 |
4 |
REPLICATION ENGINE FIXES FOR DB2 LUW V9.5 FP1 |
|
Security |
|
JR28314 |
1 |
SECURITY: THE PASSWORD USED TO CONNECT TO THE DATABASE CAN BE SEEN IN CLEAR TEXT FROM A MEMORY DUMP. |
|
IZ11111 |
2 |
WHEN ISSUING A "FORCE APPLICATIONS ALL" FOLLOWED BY A DB2STOP UNPREDICTABLE RESULTS MIGHT OCCUR. |
|
IZ18556 |
2 |
WRONG NUMBER OF ',''S IN EXECUTE.DEL FILES. |
|
IZ07951 |
2 |
CLIENT CORE DUMPS WHEN TRYING TO UNLOAD A PLUG-IN. |
|
LI72665 |
2 |
SIGNAL #11 IN SQLEX_GET_OTHER_GROUP_LIST FUNCTION CAUSES INSTANCE TO CRASH IN CONNECTION CONCENTRATOR ENVIRONMENT |
|
IZ09861 |
3 |
AUDIT ERROR CODES WILL BE IN-CORRECTLY MAPPED. |
|
IZ08112 |
3 |
INCREASED ROBUSTNESS FOR THE DB2 AUTHENTICATION PLUGIN CODE. |
|
IZ18036 |
3 |
THE EXTRACT AND PRUNE OPERATIONS OF THE DB2AUDIT PROGRAM RETURNSAUD0022N AND SEGMENTATION FAULT. |
|
IZ08122 |
3 |
CORE FILE GENERATION WHILE ATTEMPTING TO REMOVE DB2 LICENSE |
|
IZ10973 |
4 |
THE FILE GENERATED BY "DB2PD -INTAUDITCB" CONTAINS INCOMPLETE DATA. |
|
Self Tuning Memory Manager |
|
IZ18366 |
2 |
ENABLING STMM TUNING OF SORTHEAP COULD CAUSE A PERFORMANCE DEGRADATION RUNNING QUERIES WITH VERY LARGE SORTS ON LINUX. |
|
Spatial Extender |
|
IC54259 |
1 |
PREDICATE NOT WORKING |
|
JR27738 |
2 |
THE UNION AGGREGATE OPERATIONS LOOSE THE Z VALUE. |
|
IZ08021 |
1 |
DB2AGENT GETS SIGNAL #11 DURING SQLERLIBRARYTRUEUNLOAD AFTER DATABASE CRASH RECOVERY HAS COMPLETED SUCCESSFULLY. |
|
IZ11168 |
1 |
NULL POINTER IS DEREFERENCED WHEN THERE IS MEMORY CORRUPTION WHILE SETTING UP THE FENCED MODE PROCESS, DB2FMP. |
|
IZ19155 |
1 |
SECURITY: DB2 SECURITY VULNERABILITY RELATED TO DB2FMP PROCESS |
|
IZ10039 |
2 |
INCONSISTENT ERROR MESSAGE RETURNED FOR BLANK HOST VARIABLES. |
|
IZ08040 |
2 |
EXCEPTIONS THROWN BY A JAVA UDF CAN CAUSE STACK OVERFLOW IN DB2 JVM |
|
IZ08474 |
2 |
MS EXCEL FILES ARE LOCKED WHEN ACCESSED USING OLEDB TABLE FUNCTIONS UNTIL THE DATABASE IS SHUT DOWN. |
|
IZ10066 |
2 |
FMP PROCESS INVOKED BY SUBAGENTS NOT RELEASED PROPERLY |
|
IZ13176 |
2 |
SQL UDF MAY GENERATE AN INCORRECT CODE SEQUENCE IN V8 DB2. |
|
IZ10771 |
2 |
PD_GET_DIAG_HIST SHOULD USE BINARY SEARCH WHEN START TIMESTAMP OR TIME INTERVAL IS USED |
|
IZ18549 |
3 |
OPTPROFILE IS NOT RECOGNIZED AS A VALID BIND OPTION DURING THE CREATION OF SQL PROCEDURES |
|
IZ10027 |
3 |
ROLLBACK WITHIN STORED PROCEDURE MAY RETURN -882 EVEN THOUGH ROLLBACK WAS SUCCESSFUL |
|
IZ07982 |
3 |
CLI APP CALLING NONEXISTENT STORED PROC WITH A NAME EXACTLY 27 CHARACTERS LONG WILL CAUSE BOTH V8 AND V9 DB SERVERS TO TRAP |
|
LI73188 |
3 |
SAME STATEMENT NAME IN MORE THAT ONE DYNAMIC CURSOR DECLARATION IN SAME SQL PROCEDURE CAUSES REBIND COMMAND TO FAIL. |
|
IZ08425 |
3 |
ENHANCEMENTS FOR DB2FMP. |
|
IZ10007 |
3 |
CURSOR NOT SHOWING UP AT THE CLIENT WHEN THERE IS COMMIT IN A PROCEDURE CALLED BY ANOTHER PROCEDURE. |
|
XML Data Services |
|
IZ09709 |
1 |
XML STATS SANITY CHECK FAILED DURING LOAD WITH REJECTED ROWS |
|
IZ12465 |
1 |
INSERTING OR EXECUTING CERTAIN QUERIES ON XML DOCS WITH LARGE TEXT NODES MAY LEAD TO INCORRECT DATA OR AN ENGINE CRASH. |
|
IZ10969 |
1 |
DEFAULT ATTRIBUTES IN VALIDATED XML DOCUMENTS ARE INSERTED INCORRECTLY BECAUSE THEY ARE NOT ASSIGNED VALID PREFIXES. |
|
LI72681 |
2 |
USING "@ATTRIBUTE" IN XMLQUERY CAUSES SQL16002N ERROR. |
|
IZ10906 |
2 |
DB2 V9.5 XSLTRANSFORM FUNCTION FAILS WITH SQL16156N WHEN "XSI:SCHEMALOCATION" ATTRIBUTE IS USED IN XML DOCUMENT. |
|
IZ18437 |
2 |
WORK-AROUND FOR POOR PERFORMANCE WHEN XDB:EXPRESSION INCLUDES SQL UDFS |
|
IZ11851 |
2 |
DECREASE IN TRANSACTION THROUGHPUT DUE TO NUMEROUS NON-MATCHING XML INDEXES. |
|
IZ09936 |
2 |
XQUERY RETURNS SQL16004N FOR A VALID XML NODE WITH CONTENT |
|
IZ09504 |
3 |
STORAGE OF VALIDATED XML DOCUMENTS WITHOUT TYPE ANNOTATIONS |
