suche 36x36
  • 1.) Support - Heli (21.02.2018)
       

Service and support for Informix

Our service is as individual as your demands!

We offer single requests and advisory services on an hourly basis.
For projects and regular services we will make individual agreements with each of our customers.

For your orientation we offer a few service packages on our website.
We would be pleaesd if we could adjust a service package to your needs.

  Informix Support - telefonische AnfrageInformix Support - telefonische Anfrage  

 
Projecting

• project planning

• project assistance

• installation planning

• consulting

• auditing

• documentation

 
Architectur

• data warehouse

• enterprise replication

• high availability

• virtualization

• cloud migration

 
Optimization

• run-time analytics

• slow statements

• performance tuning

 
Administration

• Standard Admin

• Remote Admin

• Standby Admin

 
Monitoring

• control/tracing

• alerting

• improvement

 
Support

• 2nd-level support

• 7x24 Support

 
Start/Setup

• installation

• configuration

• migration

• trade-up

 
Data-
management

• import/export

• backup/recovery

• migration

• interfaces

• compression

• acces control

• data security

• archiving

 
Training

• online workshops

• online training

service request blue 1022x100

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

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

Product Name : DB2 UDB Version 10.1 Updated : Mon Jul 6 12:38:01 EDT 2015

Select a Fix Pack: 5 | 4 | 3a | 3 | 2 | 1

DB2 Version 10.1 Fix Pack 5
APAR Sev. Abstract
Fix Pack 5   -    1
IT04323 2 CLI, .NET AND EMBEDDED SQL APPLICATIONS WILL CRASH IN CLI_CSCDOPRECONNCETPROCESSING FUNCTION WHEN USING 2.1 OR EARLIER VERSIONS
IT08455 3 LEAK IN FILE DESCRIPTORS CAN CAUSE "TOO MANY OPEN FILES" ERROR FROM IBM SECURE SHELL SERVICE
Fix Pack 5   -    Abstract Data Types and Spatial Extender
IT06307 2 MEMORY LEAK IN GEO-SPATIAL CALLS WHILE ACCESSING SPECIFIC TYPE OF DATA
Fix Pack 5   -    Administration Server
IT03584 2 AFTER UPGRADING DAS TO DB2 9.7 FP9, EXECUTING A TASK WITH 'RUN NOW' FAILS
IT03583 2 THE DB2 ADMINISTRATION SERVER FAILS TO DISCOVER DATABASES BELONGING TO AN INSTANCE
Fix Pack 5   -    Administration Tools
IT01737 2 DB2BATCH CHANGED THE HEADER OUTPUT
IT00502 2 RUNNING DB2LOOK WITH "-X" AND "-CT" OPTIONS WHEN USING DB2_COMPATIBILITY_VECTOR=ORA COULD FAIL WITH AN SQL0407N ERROR.
IT00488 2 RUNNING DB2LOOK WITH "-MOD" AND "-CT" OPTIONS WHEN USING DB2_COMPATIBILITY_VECTOR=ORA COULD FAIL WITH AN SQL1131N ERROR.
IT01411 2 USING DB2MOVE WITH THE COPY OPTION TO MOVE FROM V9.5/V9.7 TO V10.1 FAILS WITH 'SQLCODE -204'
IT01338 2 RUNNING DB2LOOK WITH "-CT" OPTIONS DOES NOT PRODUCE "SET SCHEMA"OR "SET PATH" TYPE STATEMENTS.
IT08158 2 SYSPROC.ADMIN_DROP_SCHEMA RETURNS SQL0478N WHEN THE SCHEMA HAS 'CREATED GLOBAL TEMPORARY TABLE (CGTT)'
IT01911 2 DB2LOOK MIGHT SEGV (COREDUMP) IF A TABLESPACE CONTAINS MORE THAN30 STRIPES
IT06315 2 ATS MAY RANDOMLY HANG WHEN MANY JOBS ARE SCHEDULED IN IT TO RUN.
IC99726 2 CALL SYSPROC.AUTOMAINT_SET_POLICY() TO SET A NEW AUTO_REORG POLICY MAY RETURN SQL1437N - 'UNTERMINATED END TAG' DB2AUTOREORG
IT01930 3 DB2LOOK GENERATES INCORRECT SYNTAX FOR DISTINCT TYPE IF IT IS SOURCED FROM TIMESTAMP DATATYPE
IT07061 3 DB2LOOK WITH -T OPTION DOES NOT GENERATE A DEFINITION FOR A STORED PROCEDURE.
Fix Pack 5   -    Buffer Pool Services
IT02027 2 DB2 MIGHT CRASH IN SQLBUNCHAINBPDFROMBUCKET WITH SEGV
IT07575 2 DB2RELOCALTEDB MIGHT FAIL WITH SQL10007N ERROR WHEN THE CONTAINER ID IS HIGHER THAN 999.
IT05135 2 SQL1585N IS RETURNED FOR THE AVAILABLE TABLESPACES THAT ARE LISTED UNDER THE DB2_REORG_TEMP VARIABLE.
IT06072 2 DB2PD -TABLESPACES, MON_GET_TABLESPACE NEED TO REPORT DEFAULT/UNSPECIFIED SETTING FOR FILE SYSTEM CACHING ATTRIBUTE
IT04197 2 DATABASE SCHEMA TRANSPORT FAILS WITH SQL0293N ERROR ACCESSING A TABLE SPACE CONTAINER.
IT04021 2 REDIRECT RESTORE WITH REBUILD OPTION RETURNS SUCCESS EVEN THOUGHFAILS TO ALLOCATE SPACE FOR TEMP SPACES
IT05851 2 ASYNCHRONOUS WRITE TIME IS SIGNIFICANTLY UNDERSTATED IN DB2 MONITORING
IT02772 2 STANDBY CRASH ON REORG COMMAND IN FUNCTION SQLBFREEEXTENTSFOROBJECT
IT03886 2 SQLBLOCKALLDIRS, PROBE:910 IS REPORTED AS ERROR IN DB2DIAG.LOG FILE, SHOULD BE REPORTED AS WARNING INSTEAD
IT05147 2 DB2'S I/O STRATEGY FOR LONG/LOB DATA MAY CAUSE PERFORMANCE DEGRADATION
IT03657 2 DB2 INSPECT INCORRECTLY REPORTS EMP PAGE ERRORS FOR LARGE LOB TABLES
IT08296 2 FOUND SELF DEAD LATCH FOR THE EDUS HANDLING THE ALTER TABLESPACESWITCH ONLINE STATEMENT
IT01627 2 ALTER TABLESPACE REDUCE MAX CAN FAIL WITH EFBIG (27) "FILE TOO LARGE"
IT03997 2 DB2INSPECT FAILS WITH SQL1143N ERROR BECAUSE A FILE ERROR OCCURED, MISSING FODC DIRECTORY.
IT07213 2 DB2STMM MAY TRAP IN SQLBINCREASEBUFFERPOOLSIZE() AND LEAD TO INSTANCE CRASH
IT02251 3 DB2RELOCATEDB COMMAND MAY SET INCORRECT PATH FOR LOGARCHMETH1 AND LOGARCHMETH2
IT02441 3 ADDING A PARTITION TO AN EXISTING BUFFERPOOL MAY NOT COPY ALL THE BUFFERPOOL INFORMATION TO THE NEW PARTITION
IT02244 3 DIRTY LIST LATCH CONTENTION DROPPING TEMP TABLES AT COMMIT CREATED BY XML PROCESSING
IT09774 3 CHANGED NUM_IOSERVERS=AUTOMATIC BEHAVIOUR FOR DB2_WORKLOAD=SAP
Fix Pack 5   -    Build Team
IT05939 1 SECURITY: XML QUERY WILL CAUSE DB2 TO INCREASE CPU USAGE (CVE-2014-8901).
Fix Pack 5   -    Client Interfaces
IT02994 1 CLI APPLICATION MAY CRASH IN CLI_SQLDISCONNECT WHEN ACCESSING DATABASE CONNECTION HANDLES IN A MULTI-THREADED PROCESS
IT08280 1 CLI APPLICATION USING CHAINING WITH INSERT BUFFERING MAY GET SQL_SUCCESS BUT SQLROWCOUNT() GIVES 0.
IT07772 2 MEMORY LEAK WITH DB2.NET APPLICATION WRITTEN USING DB2 V10.1 /V10.5 CLIENT DRIVER
IT04194 2 FOR SQLFETCH() RGBVALUE IN CLI TRACE IS TRUNCATED WHEN USING DB2TRC -CLI OPTION
IT08005 2 PERFORMANCE IMPROVEMENT FOR DB2 .NET RUNTIME CLIENT CONNECTION WHILE CONNECTING WITH DATABASE'S CATALOGGED IN REMOTE LDAP SERVE
IT06637 2 SQL0911N WHEN STATEMENT CONTAINS AN EMBEDDED SELECT DESPITE CLI/ODBC "CONCURRENTACCESSRESOLUTION" KEYWORD
IT05791 2 POSSIBLE MEMORY CORRUPTION DUE TO A DOUBLE FREE DURING DISCONNECT
IT06427 2 CLI CONNECTION RETURN WARNING(CLI0004W) WHEN CFG FILE CONTAIN AUTHENTICATION=CLIENT
IV60790 2 DB2 SHOULD NOT ABEND IN SQLAK_CALLBDRDAINPUT() AFTER AN OUT OF MEMORY CONDITION
IT06493 2 CLP WILL FAIL WITH SQL30082N RC=17 WHEN USING DB2DSDRIVER.CFG AND CONNECTING TO SERVER WITH AUTHENTICATION=CLIENT SET
IC99918 2 CLPPLUS IS NOT ABLE TO FETCH THE PROPER "SQL AUTHORIZATION ID" VALUE IN CASE OF KERBEROS CONNECTION.
IT06361 2 DB2BP BACKEND PROCESS ARE NOT CLEANED UP EVEN IF DB2 FRONTEND PROCESS (PARENT PROCESS) IS GONE.
IT05123 2 DB2BATCH HAS ITS DEFAULT ISOLATION LEVEL AS RR WHICH MAY CAUSE PERFORMANCE ISSUES/LOCKS ON PRODUCTION
IT03984 2 WHEN LIKE CLAUSE IS USED IN SELECT STATEMENT, AND VALUE FOR LIKECLAUSE APPEARS IN THE STATEMENT AGAIN, SQL0206N MIGHT OCCUR
IC99799 2 CRASH/TRAP/CORE IN OCISESSIONGET() WHEN A CONNECTION IS ACTIVATED FROM THE IDLE SESSION POOL
IC99978 2 CLI-BASED APPLICATIONS RECEIVE SQL0501N AGAINST DB2 Z/OS WHEN STORED PROCEDURE CALL HAS MULTIPLE CURSORS
IT07891 2 PARAMETERS STORED AS STRINGS ARE NOT APPLIED BY DB2CFIMP (ERROR -5060)
IT04593 2 MISSING PASSWORD FOR REMOTE CONNECTIONS AND INVALID STATEMENT HANDLE FOR STATEMENT TYPE AND SUPPORT OF OCI_ATTR_SPOOL_AUTH
IT05855 2 SQLCREATEDB DOES NOT WORK WITH DSDRIVER BECAUSE OF MISSING .BNDFILE.
IT08006 3 CLI QUERIES WHICH NEEDS INTERNAL TRANSLATION MAY THROW CLI0118E
IT02973 3 ABEND IN SQLAK_CALLBDRDAINPUT DUE TO MISALIGNED MEMORY ACCESS, LEADING TO SIGBUS SIGNAL
IT00438 3 USE JAVA_HOME IF IT IS EXPORTED WHEN DETERMINING WHICH JVM TO USE WHEN RUNNING CLPPLUS.
IT01068 3 DB2CLI EXECUTABLE HANGS WHILE USING -EXECSQL OPTION WITH A STMT IN THE FILE WHOSE LENGTH EXCEEDS 64K
IC99388 3 DB2 .NET PROVIDER NOT PERFORMING CODE PAGE CONVERSION ON DATE, TIME, TIMESTAMP FROM ZOS WHEN IDAA QUERY ACCELERATION ENABLED
IT04050 3 DB2CFEXP TOOL EXPORTS THE REMOTE DB2 CATALOG WITH AUTHENTICATION=SERVER_ENCRYPT_AES AS AUTHENTICATION=NOTSPEC
IT03820 3 WHEN FAILOVER HAPPENS THE SQLSTATE HAS A XXXXX INSTEAD OF A NUMBER, BETTER TO HAVE AN APPROPRIATE NUMBER. A SEAMLESS FAILOVER OC
IT07116 3 BLOBS ARE NOT HANDLED CORRECTLY WHEN FETCHING THE DATA FROM CURSORS OPENED WHEN CALLING THE PROCEDURE.
IT05627 3 INSERT FROM A CLI APPLICATION FAILS WITH CLI0112E WHEN DOUBLE DATA TYPE COLUMN IS BOUND AS VARCHAR
IT04598 3 IBM DATABASE ADD-INS FOR VISUAL STUDIO TO CONNECT TO DB2 FOR Z SHOWS DM TYPE AS "NOT SUPPORTED" AND DB TYPE AS BLANK
Fix Pack 5   -    Codegen and Runtime
IT02046 1 ACCESS PLANS CONTAINING INDEX ORING BETWEEN MDC AND NON MDC INDEX MAY NOT FETCH ALL ROWS FROM SECOND EXECUTION ONWARDS
IT02593 1 SECURITY: DB2 CONTAINS A DENIAL OF SERVICE VULNERABILITY IN ALTER MODULE STATEMENT HANDLING. (CVE-2014-3094)
IT06419 1 CRASH WITH SIGSEGV IN FUNCTION SQLRIVSUM WHEN USING SUM AND GROUPY WITH A SUBSELECT THAT CONTAINS UNNEST.
IT07453 1 RARE TIMING DB2 CRASH IN SMP
IT00919 1 SIGNAL #11 CRASH/TRAP DURING THE COMPILE OF A QUERY WITH NLJN ONTHE LEFT SIDE OF A HSJN
IT07811 1 PARTIAL AGGREGATION OPERATOR CAN CAUSE MEMORY CORRUPTION LEADINGTO DB2 INSTANCE ABEND
IT01010 2 A QUERY CRASHED DB2 DUE TO THE BAD SECTION WITH DUPLICATE RELOC ENTRIES
IT04247 2 DB2 MAY TRAP WHEN CHECKING FOR PROCEDURE DATA CONFLICTS WHEN DBMS_SQL ROUTINES ARE USED
IT04394 2 INCORRECT QUERY RESULTS OR SQL0901N REASON "BAD OUTER COMPARE" IN SQL EXECUTION PLANS USING MDTQ OPERATORS
IT02098 2 RARE TIMING DB2 CRASH IN SMP
IT04085 2 WRONG RESULTS RECEIVED FOR A QUERY DUE TO INCORRECT INTERNAL COLUMN STRUCTURES
IT04520 2 INCORRECT RESULTS MIGHT BE PRODUCED IF HSJOIN HAS 2 NLJNS ON THEPROBE SIDE AND HSJN PROBE PUSH DOWN INTO THE SECOND NLJN DONE
IT08235 2 INCORRECT RESULT COULD BE RETURNED WHEN USING FULLWIDTH UNDER- SCORE CHARACTER (X'EFBCBF') IN LIKE PREDICATE AGAINST CLOB DATA
IT09595 2 SYSIBM.POWER ( EXPRESSION1, EXPRESSION2 ) WILL RETURN INCORRECT RESULTS FOR SOME VALUES WHEN THE BIGINT DATA TYPE IS USED
IT04490 2 SQL0901N (REASON "OPTBITFILTERSIZE LESS THAN MIN".) MIGHT OCCUR WHEN RUNNING A QUERY WITH HASH JOIN IN ACCESS PLAN
IT01168 2 FORCED DATABASE SHUTDOWN WHEN RUNNING SELECT WITH XML2CLOB FUNCTION
IT00341 2 INSERT OF NULL INTO XML COLUMN FAILS WITH SQL16132 WHEN STREAMPUTDATA ENABLED
IT02759 2 SQL0901 MAY BE RETURNED FOR A QUERY WITH ZIG ZAG JOIN
IT05719 2 UNDER RARE CIRCUMSTANCES, QUERY IN DPF ENVIRONMENT MIGHT HANG INMERGING DIRECTED TABLE QUEUE (MDTQ)
IT04275 2 SQL FAILS WITH SQL0901N "NO TUPLE BLOCKS" DURING EXECUTION OF HASH JOINS
IT05150 2 TRAP IN SQLRIGAPRESETSTATE
IC99473 2 EXCESSIVE POST THRESHOLD SORTS, SQL0955 ERRORS RUNNING WITH QUERY PARALLELISM AND PRIVATE SORT ENABLED
IT05234 2 UTL_FILE.FOPEN MIGHT CAUSE MEMORY LEAK IN THE KRCBH (DBMS SET).
IT08645 2 RARE TIMING DB2 CRASH IN SMP
IT06120 2 DB2 SERVER MEMORY LEAK IN APPLICATION HEAP WHEN PROCESSING LOB DATA IN A DPF ENVIRONMENT
IT06630 2 QUERY WITH UNION MIGHT FAIL WITH SQL0901N ALONG WITH REASON "RID_QNCP'S QUN IS NOT IN TABLES SET"
IT08538 2 MEMORY & PERFORMANCE IMPACT WHEN DIFFERING LENGTH VALUES REPEATEDLY ASSIGNED TO SAME SLOT OF ARRAY OF VARIABLE LENGTH DATATYPE
IT02671 2 LOAD OPERATIONS INVOLVING XML OR LOB DATA IN NON-PARALLEL ENVIRONMENTS MAY CRASH IN INTERNAL HANDLE MANIPULATION FUNCTIONS
IT02770 2 CRASH DUE TO MEMORY CORRUPTION DURING PARALLEL HSJN
IT00990 2 SQL0901N ERROR WILL OCCUR ON FUNCTION SQLRI_HSJNFLUSHBLOCKS
IT02709 2 SIGSEGV AT SQLRR_RESUME_INVOCATION
IT06274 2 HSJOIN ON SMP PARALLEL ENVIRONMENT MAY HANG INTERMITTENTLY
IT01901 2 PARALLEL-ENABLED QUERY EXECUTION MAY ALLOCATE EXCESSIVE APPLICATION HEAP MEMORY FOR REBAL OPERATOR
IT01466 2 TRAP ERROR IN FUNCTION SQLRXCON_SIMPLE WHILE DO INSERT INTO TEMPTABLE
IT04923 2 TRAP IN SQLKQSND IN DPF ENVIRONMENT DURING RUNTIME OF SQL QUERIES HAVING STACKED MDTQS
IT07562 2 IN RARE SCENARIOS COMPLEX QUERY WITH AN OLAP SPECIFICATION AND ASUBQUERY MIGHT RETURN EXTRA ROWS
IT06597 2 LARGE SORT QUERY RUNNING FAILED WITH SQL0901N ERROR
IT03320 2 DB2 LOOP IN SQLEML_UTL_TCP_READ_LINE
IT02020 2 LPAD() AND RPAD() FUNCTION WITH EMPTY STRING CAUSES THE RESULT STRING TO BE PADDED WITH '00' CHARACTERS
IT05852 2 GRANT / REVOKE PRIVILEGE DID NOT TAKE EFFECT IN CATALOG CACHE IMMEDIATELY ON HADR STANDBY SIDE
IT03737 2 SQL0901 IN SQLRIMERGESTREAM WHEN QUERY HAS MULTIPLE DISTINCT CLAUSES
IT05572 2 DB2EXPLN HANGS BECAUSE ITS ASSOCIATED DB2FMP CRASHED DUE TO "CORRUPT POOL FREE TREE NODE"
IT04933 2 PARTIAL EARLY AGGREGATION/DISTINCT RUNNING WITH REDUCED MEMORY INTO DB2DIAG.LOG
IT02056 3 DB2EXPLN FAILS WITH SQL1131N
IT04592 3 PERFORMANCE MAY BE POOR FOR DBMS_LOB.INSTR
IT02250 3 DB2EXPLN CANNOT PRINT NAME FOR CGTTS, THEN PRINTS SQL0100W INSTEAD.
IT02783 3 THE USE OF NUMERIC SCALAR FUNCTIONS PUSHING NUMERIC ARGUMENT TYPES THROUGH A JOIN OR UNION MAY PRODUCE A FODC_APPERR DIRECTORY.
Fix Pack 5   -    Control Center
IT03683 3 IN DB2CC, SQL0104N AN UNEXPECTED TOKEN "VARCHAR" WAS FOUND WHEN REVOKING EXECUTE PRIVILEGE ON A PROCEDURE
Fix Pack 5   -    DB2 Tools
IT06418 2 LOAD COMMAND USING THE ADMIN_CMD PROCEDURE DOES NOT SHOW DBPARTITIONNUM AND AGENTTYPE COLUMNS WITH DPF
IT02465 2 SQL0444 ERROR DURING ADMIN FUNCTION ADMIN_GET_TAB_COMPRESS_INFOOR ADMIN_GET_TAB_COMPRESS_INFO_V97 (WINDOWS OS PLATFORMS ONLY)
Fix Pack 5   -    DRDA Services
IT05452 2 SQLERRD REPORTS -1 AT SQLCA UNEXPECTEDLY UNDER CODE CONVERSION
IT08770 2 TRANSACTION MANGER REMAINS WAITING FOR XA_ROLLBACK AFTER ABEND ON Z/OS
IT02728 2 WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.
IT04013 2 DB2 MIGHT CRASH UNDER SQLJCHANDLESPLITWRITES DUE TO SIGSEGV
IT00589 2 MEMORY LEAK IN PRIVATE POOL WHEN USING COMPLEX DATA TYPES
IT01594 2 DB2 APPL FAILS WITH -4499 ERROR OR HANG SITUATION IF THE APPL ISUSING MANY PARAMETERS, SPECIALLY OF ARRAY TYPE OR ROW TYPE
IT05451 2 IF ACR IS IN EFFECT, CLIENT MAY SEND INTERRUPT TO OLD PRIMARY INSTEAD OF NEW PRIMARY
IT02249 2 POSSIBLE MEMORY LEAK WHEN USING 'INPUT ARRAY' AND THERE IS A FATAL ERROR WHILE EXECUTING THE STATEMENT
IT01831 2 DB2 CONNECT SERVER SENDS KEEP-ALIVE PROBES EVERY 5 SECONDS
Fix Pack 5   -    Data Management Services
IT05940 1 POTENTIAL CORRUPTION DURING READAHEAD DATA PREFETCHING WHEN A DECIMAL KEY PART IS USED WITH INDEX COMPRESSION
IT08988 1 HADR STANDBY LOG REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO SQLB_BAD_PAGE
IT03176 2 DATA CORRUPTION POSSIBLE AFTER RECREATING PAGE DICTIONARY
IT05652 2 SECURITY: MULTIPLE ALTER TABLE STATEMENTS CAN CAUSE DB2 TO TERMINATE (CVE-2014-6210).
IT07864 2 DB2 CRASHES AFTER SETTING DB2_RESOURCE_POLICY.
IT03976 2 PERFORMANCE IMPACTED CAUSED BY "SQLBGETMEMBINDINGFORPOOL".
IT07115 2 HADR REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO SQLB_BAD_PAGE
IT02385 2 SQLD_BADPAGE IN SQLDDECREMENTRESERVEDSPACE DURING INPLACE TABLE REORG
IT05028 2 RESTART DATABASE TAKES LONGER THAN NECESSARY ON SYSTEMS WITH A LARGE NUMBER OF TABLES
IT03372 2 RUNSTATS ON TABLE ... TABLESAMPLE(X) ON A RANGE PARTITIONED TABLE MAY RESULT IN A 'BADPAGE' ERROR
IT04121 2 DB2 MAY CRASH UNDER SQLRIBNO IF AN INTERNAL RECORD IS SELECTED AS PART OF A RIDLIST SCAN
IT07212 2 ASYNCHRONOUS PARTITION DETACH MIGHT FAIL ON TABLE MARKED UNAVAILABLE IF TABLE CONTAINS GENERATED COLUMN
IT03038 2 THE REORG TABLE COMMAND THROUGH ADMIN_CMD() COULD FAIL WITH SQL2203N.
IT08811 2 ROWS COULD BE OVERWRITTEN ON DATA PAGE IF INPLACE REORG UNLATCHED THEN RELATCHED A PAGE DUE TO A PAGE LATCH CONFLICT
IT04529 2 THE MONITOR INFORMATION IN TCB IS WRONG WHICH CAUSES INCORRECT REORG_LONG_TBSPC_ID VALUE
IT04049 2 REORG_CURRENT_COUNTER IS LESS THAN REORG_MAX_COUNTER ON COMPLETED REORGS IN SYSIBMADM.SNAPTAB_REORG, DB2PD AND DB2TOP.
IT02731 2 DEAD LATCH WHEN RUNNING TRUNCATE TABLE OPERATION AND ANOTHER AGENT LOOKS TO FLUSH THE BUFFERPOOL
IT02442 3 DB2PD -REORG MIGHT SHOW INCORRECT REORG END TIME FOR PARTITIONEDTABLES
IT04356 3 LOW PERFORMANCE OF QUERIES ON ADMSINTABINFO
IT07753 3 IN DB2DIAG.LOG INFORMATION "DEFERRED ADC IS SKIPPED DUE TO PRIORERROR" MIGHT BE REPORTED FOR GLOBAL TEMPORARY TABLE WITH INDEX
Fix Pack 5   -    Data Management Utilities
IT03388 1 INCORRECT INDEX SCAN OUTPUT AFTER ROLLFORWARD OF LOAD ... INDEXING MODE REBUILD FOLLOWED BY LOAD ... INDEXING MODE INCREMENTAL.
IT08551 1 INGEST: SQL0804N OR INCORRECT DECIMAL DATA LOADED BECAUSE BUFFERNOT FULLY INITIALIZED
IT05512 2 LOAD FROM CURSOR FROM CHAR TO VARGRAPHIC VALUE FAILS TO LOAD INTO THE COLUMN.
IT02935 2 IMPORT TO A COLUMN-ORGANIZED TABLE WITH INSERT_UPDATE OPTION FROM 10.1 CLIENT FAILS WITH SQL1667N.
IT03088 2 DB2 CRASHES AT SQLSBINSORTPOPULATERECPOINTERS WHEN DOING RESETTABLE SORT
IT07882 2 SQL0901N WITH REASON TEXT "SEMVAL OR SEMADJ ... OVERFLOW" OR "SEMAPHORE ID DOES NOT EXIST ..." WHEN RUNNING THE INGEST COMMAND
IT06155 2 APPLICATIONS CALLING THE SQLUGRPN() API MAY TRAP IN SQLVDATE()
IT07574 2 IMPORT WITH "MODIFIED BY IDENTITYIGNORE" OPTION IS SLOWER IN HP-UX AND SOLARIS DUE TO MISALIGNED MEMORY ACCESS
IT04458 2 AGENT TRAPS WITH -901 WHILE ATTEMPTING TO CREATE A TEMPORARY TABLE FOR SPILLING.
IT06609 2 LOAD COMMAND RECEIVES SQL2032N DESPITE SETTING OF DB2_LOAD_COPY_NO_OVERRIDE=COPY YES
IT03254 2 LOAD INTO MDC TABLE WITH VARIABLE-LENGTH ORGANIZE BY COLUMNS FAILS WITH SQL1584N
IT04835 2 IMPORT COMMAND AGAINST DATABASE ON DB2 Z/OS GOT SQL0107N
IT05816 2 LOAD COMMAND WITH 'ALLOW READ ACCESS LOCK WITH FORCE' WILL RETURN SQL0911N WHEN OTHER APPLICATIONS ARE QUERYING THE SAME TABLE.
IT06426 2 TABLESPACE STATE NOT SET TO 0X100 WHEN THE LOAD COPY TO TSM IS NOT ACCESSIBLE ON AUXILIARY HADR STANDBY
IT03954 2 PERFORMING A BACKUP INCREMENTAL DELTA TO TSM WITH THE DEDUP_DEVICE ON DPF INSTANCE MAY FAIL WITH SQL2038N (-91).
IT03504 2 SEGV ENCOUNTERED DURING LOAD WHEN TABLE HAS MANY RANGE PARTITIONS DEFINED
IT09220 2 INGEST: DELIVER SUPPORT FOR DEFAULTIF = NULL
IT05377 2 EXPORT WITH "MODIFIED BY CODEPAGE" MAY TRUNCATE THE DATA.
IT08120 3 THE "NUM_SESSIONS" VALUE PASSED BY DB2 TO THE VENDOR API SQLUVINT() WITH THE LOAD WITH COPY YES COMMAND IS ALWAYS "0"
IT07480 3 CONCURRENT LOAD IN SAME TABLE ON MULTIPLE PARTITIONS IN DPF MAY ABORT WITH: SQL3508N ERROR IN ACCESSING A FILE OR PATH OF TYPE
IT03503 3 DATA TRUNCATION ERROR IS IGNORED WITH WARNINGCOUNT WHEN LOAD AN IXF FILE AND IT HAS DIFFERENT CODE PAGE WITH DATABASE CODE PAGE
IT02248 3 UPDATING INDEX CAN FAIL WITH SQLI_NOKEY "KEY NOT FOUND WITHIN NODE"
Fix Pack 5   -    Data Recovery Services
IT03975 1 WHEN TABLESPACES ARE RESTORED FROM ONLINE BACKUP, ROLLFORWARD MAY FAIL WITH SQL4970 IF NO LOG RECORDS EXIST FOR THE TABLESPACES.
IC98723 1 INCORRECT HANDLING OF HEURISTICALLY ABORTED TRANSACTION IN DB2 PURESCALE LEAVING DATA INCONSISTENT
IT02439 1 BACKUP WILL FAIL WITH FILE SIZE TOO BIG IF LOB FILE IN A SMS TABLESPACE REACHES OVER 2TB IN SIZE.ONLY
IT02985 1 HIGH DISK I/O WHEN USING DB2READLOG API, HADR MULTIPLE STANDBY, OR HADR SUPERASYNC
IT03527 1 SINCE V10.1, DB2PD -DBCFG RETURNS INCORRECT HADR ROLES.
IT05075 1 MEMBER CRASH RECOVERY MAY CONTINUOUSLY FAIL WITH SQLB_EMP_MAP_INFO_NOT_FOUND ERROR
IT03920 2 GRACEFUL TAKEOVER IS SLOW DUE TO UNDO WAS FIGHTING LOGGR PRE-ALLOCATION
IT05307 2 BACKUP UTILITY DOES NOT DETECT CORRUPTED DATABASE FILES WHEN COMPRESS OPTION IS USED AND IS SUCCESSFUL
IC99983 2 ESTIMATED LOGFILESIZE PROVIDED BY DB2 TO TSM IS WRONG FOR TRUNCATED LOGFILES
IT04153 2 PURGING OF EXTRA LOG FILES CAN TAKE A LONG TIME
IC97815 2 STANDBY MAY FAIL TO CONNECT TO PRIMARY WITHIN HADR_TIMEOUT, WHENDB2_HADR_BUF_SIZE IS SET TO A VERY LARGE VALUE
IT06841 2 AFTER MIGRATION FROM 9.7 TO 10.5 THE OLD DB2 LOGS IN MIRRORLOGPATH ARE NOT DELETED
IT06175 2 HADR:STANDBY DATABASE MAY CRASH WITH ERROR "DIA8526C A FATAL ERROR OCCURRED IN DATA PROTECTION SERVICES"
IT02677 2 TRAP IN SQLPKILLIFWAITING AFTER DEADLOCK
IT05070 2 SLOW DATABASE ROLLFORWARD OR HADR STANDBY REPLAY DUE TO FREQUENTCALLS TO AND MESSAGES FROM SQLPRPROCESSMAXLOGFILESOPENINRECOVER
IT03303 2 SQL1762N - DISK SPACE ISSUE DURING MIGRATION FROM V9.7 TO V10.1 FP4 (OR EARLIER).
IT08105 2 CONTENTION ON SQLP_LTRN_CHAIN__ENTRY_LATCH AFTER LOCK ESCALATIONIS INTERRUPTED DEGRADES PERFORMANCE
IT07720 2 WITH INFINITE LOGGING, AFTER FAILED LOG ARCHIVAL, TRANSACTION MIGHT GET STUCK DUE TO MAXIMUM ALLOWABLE UNARCHIVED LOGS
IT02964 2 DB2 ROLLING UPDATE GIVES SQL1770N TAKEOVER HADR CANNOT COMPLETE. REASON CODE = "7" WHILE TAKE OVER COMMAND
IT03955 2 DB2 TRAP WHEN A BACKUP COMMAND DOESN'T GET ENOUGH MEMORY TO STARTUP
IT00940 2 DATABASE SCHEMA TRANSPORT FAILS ON LINUX390 WITH SQL0293N ERROR ACCESSING A TABLE SPACE CONTAINER.
IT08871 2 DB2READLOG API REPORTING SQL2654W INSTEAD OF SQL1273N FOR MISSING LOG ERROR CAUSING INCORRECT RESULT IN REPLICATION
IT00400 2 CRASH WITH "DOUBLE FREE" MESSAGE AFTER SEVERAL RESTART OF VENDORLIBRARY.
IT05117 2 DB2VEND PROCESS NAME TRUNCATED FOR LARGER EDU NUMBERS
IT04943 2 DB2RFPEN MIGHT SET INCORRECT TIME TO GLFH WHEN USING NON-DB2 OFFLINE BACKUP IMAGE
IT04850 2 DB2READLOG() API CAN RETURN RECORDS FORMATTED AS DB2READLOG_FILTER_ON EVEN WHEN DB2READLOG_FILTER_OFF WAS SET
IC96301 2 HIGH USER CPU OR SYSTEM HANG MAY BE OBSERVED WHEN LARGE AMOUNT OF LOCK RESOURCES BEING USED BY MANY CONCURRENT TRANSACTIONS
IT06420 2 ROLLBACK PERFORMANCE MIGHT BE AFFECTED BY LARGE NUMBER OF DIRTY PAGES
IT04156 2 APPLICATION PERFORMING LOCK ESCALATION CANNOT BE FORCED
IT05209 2 HADR STANDBY DATABASE MARKED BAD WITH SQLPREPLAYMASTER, PROBE:2500 SQLP_TRECOVF
IT06984 2 INCREMENTAL BACKUP MAY FAIL WITH SQL2048N
IT03928 2 DB2READLOG API, HIT ZRC=0X8610000D=-2045771763=SQLP_BADLOG "LOG FILE CANNOT BE USED" ON LOG EXTENT XXXX
IT08067 2 EXCESSIVE DIAGNOSTIC LOGGING SERVICING ASYNCHRONOUS LOG READ REQUESTS (DB2READLOG API)
IT02252 2 ENHANCE DIAGNOSTICS FOR "ROLLFORWARD IS NOT ABLE TO REACH THE END OF ONLINE BACKUP" ERROR.
IT08335 2 PRIVATE MEMORY LEAK DURING CRASH RECOVERY, ROLLFORWARD, HADR FORCED TAKEOVER
IT02972 2 DB2ADUTL REVOKE USER <USERNAME> REVOKES ALL OR DOESN'T REVOKE ANY
IC94628 2 DB2 FAILS TO MANAGE THE PARTIAL LOG RECORD AND CAUSE FAILURE ON CONSEQUENT ROLLFORWARD
IT02693 2 DURING REMOTE CATCHUP DUE TO INCORRECT MAPPING OF LOG FILE HADR SETUP FAILS ON A 32 BIT INSTANCE
IT05819 2 ERROR WHEN RUNNING MULTIPLE TABLESPACE ROLLFORWARD COMMANDS WITHINVALID TIMESTAMPS
IT06792 2 DB2LOGMGR MAY GET INTO A SELF DEADLATCH SITUATION CAUSING A HANG
IT08278 2 SMALL DBHEAP CONFIGURATIONS CAN TRIGGER SLOW CRASH RECOVERY PERFORMANCE
IT02001 2 RESTORE INTO EXISTING DATABASE MAY FAIL WITH AMD1814E INVALID LOGPATH DURING ROLLFORWARD
IT08542 3 HADR STANDBY ENCOUNTERED AN ABNORMAL CONDITION DUE TO STANDBY FOUND A BAD LOG AND THE GOOD ONE IN ACTIVE PATH GETS DELETED
IT05453 3 SQLUDCONVERTTIMESTAMPTOSQLOTIME ERROR MESSAGE WHILE DOING ONLINEBACKUP
IT02789 3 LOCK ESCALATIONS WITH REASON CODE: "2" MIGHT BE REPORTED WHEN LOCKLIST MEMORY WAS NOT EXCEEDED
IT01377 3 THE DB2CKLOG TOOL MAY INCORRECTLY REPORT A LOG FILE AS INVALID
IT03117 3 ABILITY TO DISABLE TRANSPORT OF STATISTICS DURING A DATABASE SCHEMA TRANSPORT OPERATION
IC96961 3 AUTO DELETION OF BACKUP OBJECTS NO LONGER WORKING AFTER SWITCHING BETWEEN ARCHIVAL AND CIRCULAR LOGGING
IT05614 3 REMOVE MESSAGES SQLPUPDATEMEMSTATUS, PROBE:611 FROM DB2DIAG.LOG WHEN STMM IS TUNING LOCKLIST
IT05364 3 HISTORY PRUNNING NOT BEHAVING AS DOCUMENTED
IT01914 3 HASH LATCH CONTENTION CAUSES POOR PERFORMANCE
IT05399 3 GRACEFUL TAKEOVER FAILED WITH SQL1770N RC 6 WHEN MULTIPLE DATABASE TAKEOVERS WERE DONE SIMULTANEOUSLY
IT03134 3 DB2 PRUNE HISTORY YYYYMMDDHHMMSS AND DELETE IS DELETING NECESSARY LOG WITH ONLINE BACKUPS.
IT01152 3 DB2INIDB SAMPLE AS SNAPSHOT WAS RETURNED DBT1011N UNABLE TO RESTART DATABASE "DATABASE-NAME" WITH THE WRITE RESUME OPTION. SQL
IT07686 3 BACKUP FAILS SQL2079N AN ERROR WAS REPORTED BY THE SHARED LIBRARY "DB2COMPR.DLL". RETURN CODE: "1".
Fix Pack 5   -    Federation
IT03398 2 MAY RECEIVE SQL1822N WITH ERROR MESSAGE HY014 CLI0129E WHEN CREATING NICKNAME ON MVS TABLE
JR52152 2 CREATE NICKNAME FAILS WITH SQL0901N "INVALID NICKNAME COLUMN LENGTH" WHEN USING ORACLE RDB ODBC DRIVER
IT06325 2 IN ONE PHASE COMMIT FEDERATION, EVEN SET DB2LOCK_TO_RB=STATEMENT,THE WHOLE TRANSACTION ROLLED BACK,NOT THE STATEMENT ROLLED BACK
JR50339 2 -302 ERROR HAPPENS WHEN IUD A NICKNAME WITH COLUMN LENGTH LARGE ENOUGH
IT01986 2 MEMORY LEAK HAPPENS WHEN FEDERATED SET TO 'Y'
IT03460 2 SYSPROC.NNSTAT RUNS IN INFINITE LOOP WHILE TRYING TO DELETE AN INDEX
JR51158 2 IMPORT ON SYBASE NICKNAME FAILED WITH SQL27999N RC=14
JR50919 2 WHEN THE NUMBER OF PREDICATES IN A FEDERATED QUERY HAS BEEN EXCEEDED, SQL0430 IS RETURNED.
IT02254 2 DB2 FEDERATION: UNION OF SELECT ON NICKNAMES WITH FETCH FIRST N ROW CLAUSE COULD RETURN INCORRECT RESULTS
JR50297 2 SELECT FROM A FEDERATED NICKNAME MAY RECEIVE SQL0180N ERROR WITHDATETIME/TIMESTAMP COLUMNS AFTER UPGRADE TO 10.1 FP3
IT02597 2 RECEIVE SQL0901N WITH ERROR MESSAGE "MSSQL3 UNKNOWN VERSION" WHEN INSERTING NICKNAME FOR 2012 SQL SERVER
IT02224 2 INTERRUPT RC DO NOT HANDLE CORRECTLY BY FED WHICH LEADS TO SQL1101N ERROR.
IT07500 2 NULL AS CHAR(0) IS PUSHDOWN TO ORACLE FROM DB2 WHICH CAUSES ERROR ORA-01723: ZERO-LENGTH COLUMNS ARE NOT ALLOWED
IT03929 2 DB2 MAY CRASH IN MEMCPY UNDER SQLQGRFWDFEDPREP WHEN REPLAYING FEDERATED XA LOG RECORDS
JR50468 2 REMOTE STATEMENT UNACCEPTABLE BY ORACLE DATA SOURCE. CODE "918" RECEIVED FROM DATA SOURCE.
IT02168 3 CREATE NICKNAME ON ORACLE RDB TABLE FAILS WITH AN ERROR SQL0901N "BAD COMPILER RETURN CODE"
JR49950 3 SELECT ROWNUM CAN NOT PUSHDOWN TO REMOTE ORACLE SERVER
IT01167 3 DB2LOOK GENERATES "CREATE SERVER" STATEMENTS THAT LEADS TO SQL1841N ERROR.
JR50293 3 INCORRECT DISTINCT CAUSE IN RMTQTXT WHEN USING FEDERATED PUSHDOWN = YES OPTION SO THE RESULT IS INCORRECT
IT06631 3 ABOUT HADR: COPY LOGS FROM THE OLD LOG PATH TO NEW LOG PATH
Fix Pack 5   -    Index Manager
IT00392 1 REPLAY OF REORG-INDEX-RECLAIM-EXTENTS LOG RECORDS MIGHT LEAD TO INDEX CORRUPTION
IT06019 1 DATA CORRUPTION CAUSED BY LOCKING BEHAVIOR WHEN LOCKSIZE SET TO BLOCKINSERT AND A TRANSACTION INSERTING INTO AN MDC TABLE
IT02245 2 ROLLFORWARD OF A RESTORED DATABASE MAY FAIL WITH: DIA8575C AN INDEX MANAGER PROGRAMMING ERROR OCCURED
IT04177 2 CONCURRENT INSERT AND REORG RECLAIM EXTENT ON MDC TABLE MAY ABEND SERVER WITH DIA8737C
IT03615 2 THE RECLAIM EXTENTS OPTION OF REORG INDEXES DOES NOT MOVE PAGES IN TABLESPACES UPGRADE FROM DB2 VERSION 9.5 OR EARLIER
IT03188 2 INSERT MIGHT NOT RESPOND OR BE VERY SLOW OR HANG ON PURESCALE SYSTEMS
IT05928 2 SQL1655C, SQLSTATE=38030. SQLB_BADHDR "BAD PAGE HEADER", SQLBREADPAGE CALLED FROM SQLIFIXSMP, SQLBFIXPAGE, SQLBFIX
IT06862 2 DB2 MIGHT TRAP WHILE COLLECTING STATISTICS FOR INDEXES
IT05596 2 DATABASE HANG DURING CONCURRENT INSERT, MERGE AND DELETE STATEMENTS AGAINST ITC TABLE
IT02523 2 ANONYMOUS BLOCK CLEANUP PROCEDURE IS NOT RESPECTING THE DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:<VALUE> REGISTRY VARIABLE
IT04738 2 REORG RECLAIM EXTENTS ON MDC TABLE MAY WAIT ON ONLINE BACKUP LEADING TO SQL0964C TRANSACTION LOG FULL
IT07152 2 SQL1034C, SQLSTATE=58031. DATABASE SHUTDOWN DUE TO INDEX ERROR DURING PAGE SPLIT ON COMPRESSED INDEX.
IT03317 2 REORG INDEXES OPERATION WITH CLEANUP ONLY ALL OPTION MAY NOT DETECT A FORCE REQUEST FOR A VERY LONG TIME
IT06415 2 REORG TABLE RECLAIM EXTENTS ON MDC TABLE MIGHT DEADLOCK WITH UPDATE/DELETE DUE TO IX-LOCK ON EMPTY MDC BLOCK
IT00986 3 CONCURRENT REORGS ON DIFFERENT DATA PARTITIONS OF THE SAME PARTITIONED TABLE MIGHT EXECUTE SEQUENTIALLY DURING IDXRECREAT PHASE.
Fix Pack 5   -    Install and Catalog Services
IT05128 1 DB2 INSTANCE MAY CRASH IN SQLDREMOVECACHEDTABLEENTRY()
IT06555 2 ALTER TABLE DROP COLUMN MAY TRAP
IT06588 2 UPGRADING FROM DB2 10.1 WSE TO DB2 10.1 ESE MAY FAIL WITH ERROR SQL6031N
IT03012 2 IMPLEMENTATION FIELD IN SYSCAT.ROUTINES VIEW ALSO SHOWS THE MODULE NAME FOR SOURCED FUNCTIONS.
IT06666 2 DB2CKUPGRADE UTILITY FAILS WITH "SQL1344N ORPHAN ROWS FOUND IN THE SYSTEM CATALOGS".
IT03250 2 CHANGING LOCATION OF TEMP FILES GENERATED DURING INSTALLATION BYSPECIFYING DB2TMPDIR COULD RESULT IN DBI20043E
IT05694 2 DATABASE UPGRADE FAILS WITH SQL0204N.
IT04046 2 PACKED DESCRIPTOR OF A RANGE PARTITION TABLE CAN GET CORRUPTED WHEN ATTACHING A PARTITION.
IT05632 2 MISSING 32-BIT OCI LIBRARY IN THE INSTALLATION IMAGE.
IT05916 2 "MEMBER NUMBER" AND "NUMBER OF MEMBER" TOKENS WRONG IN SQLERRM WHEN CONNECTING TO SINGLE MEMBER DPF INSTANCE DATABASE
IT01139 2 APPERR WITH -901 MIGHT OCCUR CALLING SP REFERENCING MODULE NESTED ARRAY TYPE IS CALLED BY SQLC PROGRAM
IT03658 2 DS CLIENT 'DB2UNINS' FAILS: UNABLE TO OPEN THE WINDOWS INSTALLERDATABASE 'DB2\WINDOWS\IBM DATA SERVER CLIENT.MSI'. RC=1638
IC97598 2 AFTER LOGS BECOME FULL, AN INSERT INTO A GLOBAL TEMPORARY TABLE (DGTT) FAILS WITH SQL0901N
IT02018 2 CREATE EVENT MONITOR FAILS WITH -901 IF NO 4K PAGESIZE TABLESPACE EXIST
IT05640 2 DURING THE UPGRADE OF THE DATABASE THE FOLLOWING ERROR MAYBE SEEN SQL0206N
IT05207 2 DB2 MAY PANIC WHEN TRYING TO UNLOCK AN ALREADY UNLOCKED LATCH FROM 'SQLRLC_AUTH_FIND_INSERT()'
IT02887 2 INSTALLFIXPACK FAILED WITH MAJOR ERROR AS PROCESSES RUNNING IN THE MEMORY THAT WERE HOLDING THE DB2 BINARIES.
IT03659 3 SYSTEM ODBC DSNS ARE REMOVED AFTER UPGRADING DB2 FROM AN OLDER RELEASE ON WINDOWS
IC99675 3 SYSTEM GENERATED FUNCTIONS ARE INCORRECTLY OWNED BY THE INSTANCEOWNER.
IT05801 3 DB2PREREQCHECK MIGHT REPORT DBT3589W EVEN IF IOCP IS AVAILABLE IN LOCALES OTHER THEN ENGLISH.
IT02319 3 DB2CKUPGRADE MIGHT REPORT: "SQL1344N ORPHAN ROWS FOUND" IF THERE ARE INVALID OBJECTS IN THE DATABASE
IT04043 3 DROPPING THE SAME VIEW CONCURRENTLY MAY CAUSE DEADLOCK
IT03996 3 PROFILE.ENV HAS WRONG OWNERSHIP AFTER DB2IUPGRADE, DB2ICRT, OR DB2IUPDT OF ANOTHER INSTANCE
IT01916 3 COLLATIONNAME IN SYSCAT.COLUMNS MIGHT BE CHANGED UNEXPECTEDLY TONON_UNIQUE IF LENGTH OF COLUMN IS ALTERED
IT05946 3 ACS FILES PRESENT IN $INSTHOME/SQLLIB/ACS WHEN CLIENT INSTANCE CREATED FROM SERVER INSTALL
Fix Pack 5   -    JDBC Driver
IT10271 3 TO DOCUMENT ALL THE JCC APARS THAT ARE SHIPPED WITH DB2V 101FP5 RELEASE
IT05556 3 AN APPLICATION USING THE JCC DRIVER IN TYPE 4 MODE ENCOUNTERS AN OVERLAPPINGFILELOCKEXCEPTION
IT10171 3 CONNECTION FAILS WITH A DRDA DATA STREAM SYNTAX ERROR -4499, ON A 3-TIER CONNECTION TO DB2 V10 AND ABOVE
IT03806 3 JCC: SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION IGNORED FOR EMBEDDED SELECTS
IT02478 3 NULLPOINTEREXCEPTON WHEN THERE IS A PROBLEM IN ACCESSING JCCDIAG.LOG
IT04214 1 THE JCC DRIVER WILL NOT HOLD TRANSPORT UNTIL THE END OF NEW UNIT OF WORK
IT01407 2 CLIENT AFFINITIES FAILBACK MAY NOT SUCCEED EVEN IF THE PRIMARYSERVER IS UP
IC99912 2 BUGCHECKEXCEPTION: BUG CHECK EXCEPTION THROWN DUE TO AN INTERNAL JCC ERROR SEVERITY CODE 8, ERRORCODE=-4228
Fix Pack 5   -    Monitoring
IT07497 2 ADMIN_MOVE_TABLE WITH COPY_USE_LOAD AND WITHOUT COPY_WITH_INDEXES LOADS DATA AND BUILDS ALL INDEXES IN ONE TRANSACTION
IT03887 2 MON_GET_LOCKS FAILS WITH SQL0171N
IT03582 2 APPL_ID VALUE IN CONNMEMUSE_ EVENT MONITOR TABLE HAS EXTRA GARBAGE CHARACTER AT END ON LITTLE-ENDIAN PLATFORMS (LINUX)
IT05887 2 AMT. OPTION REDIRECT FAILS ON TABLES IF PRIMARY INDEX INCLUDES ALL TABLE COLUMNS
IT01166 2 MEMORY ALLOCATED BY A MONITOR FUNCTION MIGHT NOT BE FREED UP ANDMIGHT LEAK AFTER DATABASE IS DEACTIVATED
IT07404 2 SYSPROC.ADMIN_MOVE_TABLE RETURNS SQL1224N FOR TABLES WITH SELF-REFERENCING REFERENTIAL CONSTRAINTS
IT07495 2 ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL0601N
IT06270 2 THE DB2 EVENT MONITOR TABLES REPORTS VIOLATION FOR "DB2 STORAGE OPTIMIZATION" EVEN THOUGH THERE IS NO LICENSE FOR DB2_STORAGE_OP
IT07583 2 MONITOR DATA OF BP_HITRATIO MAY RETURN WRONG RESULT
IT04412 2 SQLSTATISTICS ROUTINE, CLI/ODBC SQLSTATISTICS CALL, JDBC GETINDEXINFO CALL RETURN SQLCODE -413 FOR LARGE VALUES OF CARDINALITY
IT03718 2 INSTANCE MAY TRAP WITH SIGSEGV IN MONITORING CODE DURING DATABASE MANAGER SNAPSHOT COLLECTION AND ACTIVE AIC PROCESSING
IT08452 2 ADMIN_MOVE_TABLE CAN FAILS DURING CLEANUP WITH SQL0204N
IT06607 2 SYSPROC.ADMIN_MOVE_TABLE RETURNS SQL0614N ERROR
IT02497 2 ADMIN_MOVE_TABLE FUNCTION RECIEVES SQL3025N AFTER UPGRADE TO VERSION 10.1 FP4
IT08687 2 DB2 MAY ABEND WITH SIGSEGV IN SQLRWAGENTLOCKWAITBUILDER::EXECUTE
IT00954 2 "CALL SYSPROC.ADMIN_MOVE_TABLE WITH CANCEL" IS FAILING WITH SQL2104N RC=9 AFTER LOG FULL CONDITION.
IT03099 2 ADMIN_MOVE_TABLE MAY FAIL TO DROP UDI TRIGGERS FROM SOURCE TABLEDURING SWAP OPERATION
IT02193 2 DPF: EVENT MONITOR APPLICATION IN PENDING REMOTE REQUEST - UNABLE TO FORCE.
IT04455 3 CONFIGURING OPM V5.1 TO USE IN-MEMORY METRICS, CREATES STACK FILES, THAT CAUSES THE DB2DUMP DIRECTORY TO BE 100% FULL.
IT02974 3 PROCEDURE SYSPROC.GET_DBSIZE_INFO MAY INCORRECTLY RETURN ERROR SQL0493
IT02860 3 ADMIN_MOVE_TABLE FAILS WITH XML COLUMNS
IT00794 3 LOCK TIMEOUT INCREMENTS BEFORE ACTUAL TIMEOUT IN SYSIBMADM.SNAPDB WHEN EVENT MONITOR IS ON.
IT01061 3 ON EXECUTING "STORED PROCEDURE: SYSPROC.WLM_SET_CLIENT_INFO", THE DB2 SNAPSHOT SHOWS "FAILED STATEMENT OPERATIONS = 2"
IT04478 3 INTERNAL ROLLBACKS HAPPEN FOR "CONNECT RESET" OR "TERMINATE" ARECOUNTED THROUGH THE MONITORING ELEMENT "TOTAL_APP_ROLLBACKS"
IT08501 3 INCLUSION OF SYSTEM_APPLS IN MON_GET_XXX MONITOR TABLE FUNCTIONS
IT03517 3 DB2 ALTOBJ FAILS TO RECREATE FOREIGN KEY WHICH REFERENCES PRIMARY KEY ON SAME TABLE AND SCHEMA NAME IS 8 CHARACTERS
IT03725 4 MAX_COORDAGENTS CANNOT BE SET TO 0 VALUE
Fix Pack 5   -    Parsing and SQL PL
IT03494 1 INCREASED DB2 PRIVATE MEMORY USAGE ON 10.1 FIX PACK 4 WHEN RUNNING TRUSTED UDFS OR STORED PROCEDURES
IT05486 2 CURSOR VARIABLES REFERENCED EXTERNALLY CAN CAUSE MEMORY LEAK IN THE APPLICATION HEAP.
IT03953 3 INCORRECT STATEMENT TEXT (WRAPPED SQL09076 ...) MIGHT BE CATALOGUED IN TEXT COLUMN OF SYSCAT.ROUTINES
IC99740 3 A SQL0779N ERROR MIGHT BE RETURNED IF LABEL IS FOLLOWED BY ONE OF THE ARRAY COLLECTION METHODS.
IT06009 3 MEMORY LEAK IN APPLICATION HEAP IF A COMPOUND STATEMENT IS TERMINATED EARLY AFTER USING A LOCAL CURSOR VARIABLE.
Fix Pack 5   -    Platform Specific
IT07332 1 DB2 COREDUMP MAY BE MISSING ON LINUX IN COMPLEX TRAP SCENARIOS DUE TO NOT SETTING PR_SET_DUMPABLE
IT04485 1 ISSUING MULTIPLE DB2START RESTART COMMANDS (USUALLY THROUGH DB2GCF) CAN LEAD TO A HANG
IT03321 1 APPLICATIONS RUNNING UNDER NETWORK SERVICE ACCOUNT MAY TERMINATE/ CRASH AFTER 'ACCESS DENIED' ERROR
IT03800 2 THE OPM CPU MONITOR (OPM V5.1) USES DB2 API WHICH IS GIVING INCORRECT RESULTS
IT07970 2 RUNNING DB2IDROP OR DB2IUPDT TOOLS ON ONE INSTANCE MIGHT CAUSE DROPPING PROFILE ON ANOTHER INSTANCE FROM THE SAME INSTALLATION
IT03829 2 DB2STOP FORCE MAY HANG ON PAGE LATCHES DUE TO AN INSTANCE TRAP WHICH DID NOT TERMINATE THE INSTANCE
IT05793 2 SQLO_LATCH_ERROR_EXPECTED_HELD ERROR LEADS TO DB2 CRASH IN WINDOWS
IT03395 2 A NEWLINE CHARACTER IN DB2ENVLIST WILL RESULT IN AN INFINITE LOOP WHEN ACCESSED BY THE REG_VARIABLES VIEW CAUSING HIGH CPU.
IT03893 2 DB2 LIST DCS APPLICATION EXTENDED FAILS TO DISPLAY THE COMPLETE IP ADDRESS FOR "CLIENT NODE"
IT04758 2 OPTIMIZE PERFORMANCE OF BACKUPS THAT USE DEDUP_DEVICE
IT04171 2 DB2_KILL DOES NOT WORK FOR SINGLE NODE INSTANCE IF DBPARTITIONNUM IN DB2NODES.CFG IS NOT 0
IC90190 2 PARALLEL MODE OF DB2_ALL AND RAH CAN LEAVE PROCESSES LOOPING FOREVER SINCE DB2 V9.7 FP6, REGRESSION OF APAR IC81335
IT03821 2 MEMORY LEAK IS POSSIBLE ON WINDOWS IF CALLING ENV_GET_DB2_SYSTEM_RESOURCES
IT03830 2 DB2 IS NOT ABLE TO ACCEPT AN INCOMING CONNECTION IF NUMBER OF INSTANCE THREADS EXCEEDS RLIMIT_NPROC LIMIT
IT04103 2 DB2START AND DB2STOP FAIL WITH SQL1042C ERROR AFTER SETTINGS THEDB2PATH ENVIRONMENT VARIABLE
IT03218 2 DB2BP.EXE MIGHT LEAK "CONTROL PANEL\INTERNATIONAL" REGISTRY KEY HANDLE
IT07074 2 STMM MAXIMUM TARGETS MAY BE TEMPORARILY TOO HIGH, SOME SWAPPING MAY OCCUR ON LINUX SYSTEMS
IT02443 3 MON_GET_MEMORY_SET DISPLAYS WRONG MEMORY SET STATISTIC FOR MEMORY_SET_SIZE
IT07735 3 STMM LOG FILE PERMISSIONS ARE SET TO 666 AND SHOULD BE 644
IT06550 3 SLOW MEMORY ALLOCATIONS OR POSSIBLE SEVERE DEGRADATION DURING OOM HANDLING DUE TO COALESCE MEMORY CHECK
IT06185 3 SEMAPHORES GENERATED UNDER /DEV/SHM WITH WORLD WRITABLE PERMISSIONS.
IT02300 3 USING A FIFO FILE WITH DB2 CAN RESULT IN A SQLO_BPSE ERROR BEINGREPORTED ON AIX.
IT04014 3 PREFETCHING CAUSES DB MARKED BAD WHEN SYSTEM ERROR OCCURS IN SQLOCSEMV
IT05041 4 DB2INSTDEF SHOULD BE ENABLED ON NON-WINDOWS PLATFORMS
Fix Pack 5   -    Problem Determination
IT03913 2 PD_GET_DIAG_HIST OR DB2DIAG MAY HANG AND CONSUME 100% CPU IF PARSING DB2DIAG.LOG RECORD CONTAINING EVENT STRING FIELD
IT03023 2 PD_GET_LOG_MSGS RETURNS SQL22237N WHEN ADMIN LOG NOT EXISTING
IT07306 2 'LIST TABLESPACES SHOW DETAIL' COMMAND IN DB2SUPPORT TOOL MAY CAUSE DB2SUPPORT TO HANG IF DATABASE IS IN SET WRITE SUSPEND MODE
IT02733 2 DB2DIAG TRAPS WHEN THE TOTAL NUMBER OF ROTATING DB2DIAG.#.LOG FILES UNDER ALL THE SPLIT DIAGPATH DIRECTORIES EXCEEDS 15
IT06478 2 DB2PD -ALLDBS -INST CAN LOOP CONTINUOUSLY ON SYSTEMS WITH VERY LARGE BUFFERPOOL CONFIGURATIONS
IT05649 2 PD_LOG_GET_MSGS OR USING THE SYSIBMADM.PDLOGMSGS_LAST24HOURS MAYALLOCATE EXCESSIVE MEMORY
IT06083 2 DB2TOP MIGHT SEGV IF USER RESIZES WINDOW WHILE DB2TOP IS EXECUTING A 'CURSES' ROUTINE
IT08604 3 DB2SUPPORT WITH DB OPTION PRODUCES SQL1587N, SQL1469N IN LOG, AND PRINTS ERROR IN DB2DIAG.LOG IF IT RUNS AGAINST CF ONLY HOST.
IT00611 3 DB2SUPPORT COMMAND FAILS FOR SOLARIS 10 USERS WHEN WHOAMI COMMAND IS NOT AVAILABLE FOR SHELL
IT03452 3 DB2TOP'S UTILITY SCREEN CAN LIST UTILITIES RUNNING AGAINST DATABASE DIFFERENT FROM SPECIFIED DATABASE
IT03956 3 DB2TOP MAY TRAP WHEN DISPLAYING QUERY TEXT IN "D - DYNAMIC SQL" WINDOW DURING INTERACTIVE MODE.
IT02672 3 DB2SUPPORT CAN NOT COLLECT DB2DJ.INI, IF DB2_DJ_INI WAS SPECIFIED.
IC99344 3 DB2PDCFG -FODC[DBCFG|DBMCFG|TRAPRESILIENCE] STATUS DOES NOT WORKFOR USER WITH ONLY SYSMON AUTHORITY
Fix Pack 5   -    Process Model
IT02202 1 SET WRITE SUSPEND/RESUME MAY HANG WHEN IT IS NOT ABLE TO ACCESS THE DB CONFIG FILE
IT00810 1 THE DB2 INSTANCE MAY HANG OR TRAP ON LINUX WHEN USING A HIGH NUMDB SETTING
IT07699 1 DB2HAICU INCORRECTLY REPORTS AN IP ADDRESS AS ALIVE WHEN IT IS NOT.
IT03334 2 HADR PRIMARY OR STANDBY MIGHT TERMINATE ABNORMALLY WHEN DB2 AUDIT IS ACTIVE
JR49699 2 NONTHREADED FECNED WRAPPER MAY TRAP THE INSTANCE WHEN IT GOES INTO UNSTABLE STATE
IC97822 2 DB2 MAY TRAP IN SQLECLEANUPFEDDAEMONANCHOR DURING MULTIPLE LOGICAL NODES STARTUP
IT02255 2 TRAP IN SQLEGWRT FUNCTION DUE TO MEMORY ACCESS VIOLATION IN MULTI-THREADED ENVIRONMENT.
JR50582 2 RE-INTEGRATION OF OLD PRIMARY AS STANDBY HANGS AFTER FORCE TAKEOVER
IT01969 2 ERROR SQL0843N WHEN CONNECTING TO AN INFORMIX DATABASE WITH A NAME LONGER THAN 18 CHARACTERS
IT01072 2 SQKFCHANNEL::WAITSENDREADY RECIEVES SQLO_INTRP INTERRUPT AND RESULTS IN PANIC
IT00319 2 DB2FMP MAY LEFT FOREVER WHEN "CONNECT RESET" HAPPENED AND THE DB2FMP IS IN THE HEADER OF THE FED FMP PRCOCESS LIST
IT02661 2 INSTANCE PANIC OR TRAP IN XA ENVIRONMENT DUE TO UNLATCHING A LATCH THAT IS NOT HELD.
IT07220 3 WITH AUTOMATIC FCM_NUM_BUFFERS, IN RARE CASE IT MAY STILL HIT SQL6040C NO FCM BUFFERS ARE AVAILABLE
IT02818 3 WHEN LOGPATH INCLUDES "NODEXXXX/LOGSTREAMXXXX" IN THE PATH, NEWLOGPATH MAY NOT BE CHANGED.
IT05568 3 RUNNING 'DB2STOP FORCE' ON PASSIVE NODE OF MSCS CLUSTER CAN CAUSE THE INSTANCE TO HANG DURING SHUTDOWN
IT05317 3 SQL1084 RETURNED INSTEAD OF SQL1643 WHEN HITTING INSTANCE MEMORYLIMIT ON DATABASE ACTIVATION
IT07085 3 SQL1036C ERROR MIGHT BE RETURNED FROM DROP DATABASE COMMAND
IT02912 3 DB2PD COMMAND MAY SHOW INCORRECT NEWLOGPATH, MIRRORLOGPATH, AND OVERFLOWLOGPATH.
IT07621 4 WHEN HIT SQL5005 DUE TO FILE OPEN FAILURE, PREVIOUS DBM CFG VERSION WAS NOT RESTORED AND OUTPUT IN DB2DIAG.LOG
IT02081 4 ERROR DIA8003C IN DIAG.LOG (PURESCALE ENV), ALL SYS APPS WERE FORCED IN ORDER TO GET AN EXCLUSIVE CONNECTION TO THE DATABASE.
Fix Pack 5   -    Query Compiler Optimizer
IT09137 1 WRONG RESULT FROM STATEMENT WITH TWO OR MORE OLAP FUNCTIONS WITHCOMPATIBLE PARTITION-BY CLAUSES WITH ONE EQUATING TO CONSTANTS
IT05950 1 DB2HMON SHOULD END IMMEDIATLY WHEN RECEIVING INTERRUPT
IT02704 1 IN DPF ENVIRONMENT THE DB2 OPTIMIZER MIGHT PRODUCE A NON-OPTIMALACCESS PLAN WHEN DB2_WORKLOAD=SAP
IT03869 1 NEGATIVE COLCARD CAUSES OPTIMIZER TO CHOOSE A BAD PLAN, RESULTING IN POOR QUERY PERFORMANCE.
IT05230 2 WHEN COMPARING THE QUERY COST OF THE DEGREE=1 COMPARED TO DEGREE> 1, COST INCREASES
IT07925 2 QUERY COMPILATION MAY FAIL WITH: -901 SQLNO_GET_BEST_PLAN[200] WHEN ZIGZAG JOIN (ZZJN) IS CONSIDERED
IV64314 2 WHEN INTRA_PARALLEL ENABLED, SQL STATEMENT WITH IN PREDICATE MIGHT RETURN INCORRECT RESULTS
IT08413 2 AUTOMATIC REORG FAILS WITH SQLCODE: -2205 RC 6 FOR MDC TABLE
IT03428 2 SQL0973N ERROR RETURNED WHEN COMPILING A STAR JOIN ELIGIBLE QUERY WITH A SNOWFLAKE THAT APPLIES A SUBQUERY PREDICATE
IT04236 2 SQL STATEMENT WITH REPARTITIONED JOINS MIGHT RETURN INCORRECT RESULTS IN A DPF SYSTEM
IT07030 2 DB2 MIGHT TRAP WHILE COMPILING A QUERY THAT IS ELIGIBLE FOR ZIGZAG JOIN PROCESSING
IT05891 2 SQL STATEMENT WITH MULTIPLE SIMILAR CORRELATED SUBEXPRESSIONS MIGHT RETURN INCORRECT RESULTS
IT00500 2 AVGLEAFKEYSIZE AND AVGNLEAFKEYSIZE ARE INCORRECT WHEN RUNSTATS USING INDEXSAMPLE SYSTEM
IT08590 2 ORDER BY ON COLUMN NOT INCLUDED IN SELECTED COLUMNS IS NOT SHIPPED TO FEDERATED SOURCE
IT03319 2 DB2 MIGHT RETURN SQL0901N FOR SQL STATEMENT THAT IS ELIGIBLE FORZIGZAG JOIN
IT03888 2 RTS COLLECTING TABLE CARDINALITY AS 0 AFTER TRUNCATE AND POPULATE TABLE.
IT04888 2 OPTIMIZER MIGHT PRODUCE NON-OPTIMAL ACCESS PLAN IN DPF FOR QUERIES WITH MULTIPLE LOCAL EQUALITY PREDICATES
IT04780 2 FETCH FIRST N ROW CLAUSE IS PUSHED DOWN
IT01828 2 QUERY PERFORMANCE CAN SUFFER DUE TO INCORRECT INDEX SCAN COST CALCULATION ON DB210 ( LUW ) RELEASES
IT02074 2 UPDATE STATEMENT FAILS WITH TRAP WHEN THERE IS A MISMATCH IN THEDISTRIBUTION STATISTICS COUNT VS ACTUAL VALUES COLLECTED
IT00592 2 COMPILING SQL STATEMENT WITH JOINS AND OR PREDICATES ON PARTITIONED TABLES MIGHT RETURN SQL0101N ERROR
IT06944 2 MEMORY CORRUPTION DURING RUNSTATS 'UPDATE PROFILE' OPTION IF DUPLICATE COLUMN GROUPS ARE INVOLVED.
IT03247 2 SQL0437W MIGHT BE INDUCED BY RUNSTATS IN DATABASES THAT USE LOCALE-SENSITIVE UCA-BASED COLLATIONS
IT04444 2 TABLE CARDINALITY VARIES SIGNIFICANTLY COMPARED TO ACTUAL TABLE ROW COUNT, WHEN BOTH TABLESAMPLE AND INDEXSAMPLE IS SPECIFIED.
IT08563 2 DB2 OPTIMIZER CAN TRAP WHEN PLANNING INDEX JUMP SCAN ON RANGE PARTITIONED TABLE DEFINED WITH NULLS FIRST PARTITIONING COLUMN
IT05988 2 DB2 OPTIMIZER MIGHT CHOOSE SUBOPTIMAL ACCESS PLAN FOR SELECT STATEMENT WITH VALUES CLAUSE
IT05302 2 SQL0901N IS RETURNED WITH "EPE: NO MATCHING Z-VAL FOR PROBE KEY IN RECV TQ" ERROR IN DPF ENVIRONMENT
IT05968 2 SQL1224N ERROR DURING QUERY COMPILATION UNDER MEMORY CONSTRAINEDENVIRONMENT
IT02983 2 INSTANCE CRASH WHEN RUNSTATS ON TEMPORARY TABLE AND INDEX NAME OMITS SCHEMA NAME
IT07016 2 WHEN INTRA_PARALLEL IS ENABLED, A SQL0901N ERROR CAN BE RETURNEDWHEN COMPILING A QUERY
IT03903 2 SQL STATEMENT WITH LARGE NUMBER OF JOINS BETWEEN MULTIPLE RANGE PARTITIONED TABLES MIGHT RETURN SQL0101N ERROR
IT05347 2 QUERY PERFORMANCE CAN SUFFER DUE TO INCORRECT INDEX SCAN COST CALCULATION ON DB210 ( LUW ) RELEASES
IT07243 2 SQL0101N WHEN COMPILING QUERY WITH MANY OUTER JOINS AND GROUP BY IN DPF
IT04270 2 DB2 OPTIMIZER MIGHT CHOOSE A NON-OPTIMAL ONE-FETCH GROUP BY
IT04230 2 DB2ACD MAY CAUSE LOCK WAIT DUE TO NOT RELEASING EXCLUSIVE CATALOG CACHE LOG
IT07441 2 "NANQ" IN QUERY EXPLAIN.
IT04820 2 AUTOMATIC REORG FAILS WITH SQL0270N FUNCTION NOT SUPPORTED (REASON CODE = "57") FOR MDC TABLE
IT02722 2 INVALID FILTER FACTOR ESTIMATION FOR RANGE PREDICATE
IT00300 3 DB2 CAN RETURN SQL0973N WHEN GENERATING AN INDEX-ANDING STAR JOIN PLAN THAT CONTAINS A RECURSIVE SUBQUERY
IT07114 3 EXPLAINING A QUERY WHICH INVOLVES FGAC PROTECTED TABLES AND A UNION OPERATOR MAY RESULT IN SQL901N
IT03681 3 RUNSTATS MAY COLLECT INCORRECT VALUES FOR AVGPATITION_PAGE_FETCH
IT05804 3 MEMORY LEAK IN APPLICATION HEAP WHEN RUNSTATS COMMAND WITH USE PROFILE OPTION IS EXECUTED
IT03556 3 DB2 MIGHT TRAP WHILE COMPILING A QUERY WITH BIG INLIST PREDICATE
Fix Pack 5   -    Query Compiler QGM
IT05462 1 INCORRECT RESULTS MIGHT BE RETURNED FOR A QUERY INVOLVING AN AGGREGATION FUNCTION AND AN OUTER JOIN OPERATOR
IT03875 1 UPDATE OF TABLE WITH SPECIAL COLUMN THAT IS INDEXED CAN RESULT IN SQL0964C CONDITION
IT03192 1 DB2 MIGHT NOT SPLIT OLAP FUNCTIONS AND SUBQUERIES FROM CASE EXPRESSIONS
IT08225 1 SQL0401N ERROR RETURNED WHEN QUERY CONTAINS COMPLEX CASE EXPRESSION WITH TIMESTAMP FUNCTIONS IN WHEN CLAUSE
IT03674 1 DB2 MIGHT PRODUCE A SQL0901N WHEN PLANNING EARLY OUT NESTED LOOPJOIN
IT07507 1 QUERY COMPILATION FAILS WITH SQLCODE SQL0007N OR SQL0198N
IT08636 1 WRONG RESULT IN ORA MODE WHEN GENERATED TWIN PRED CONTAINS CHAR WITH HEX VALUES LOWER THEN SPACE
IC98964 2 SCALAR SUBQUERIES ARE NOT PUSHED DOWN THROUGH UNION ALL LEADING TO POOR PERFORMANCE
IT06501 2 QUERY CONTAINING A PREDICATE REFERENCING AN XMLTABLE COLUMN IN CORRELATED QUERY BLOCK MAY FAIL WITH SQL0901 ERROR
IT07731 2 DB2 MIGHT PRODUCE ABEND OR PRODUCE SQL0901N WHEN EXECUTING A RECURSIVE QUERY WITH A JOIN ON EXPRESSIONS
IT09606 2 SELECT ON XML USING FN:UPPER-CASE & TABLE HAS AN INDEX CAN RETURN INCORRECT RESULTS
IT04010 2 SQL101N MAY BE RETURNED WHEN SPECIAL REGISTER IS REFERENCED MANYTIMES IN THE SAME EXPRESSION IN THE SELECT LIST OR IN THE WHEN
IT06404 2 QUERY FAILURE DUE TO VIEW OR COMMON TABLE REFERENCED MULTIPLE TIMES AND NESTED FUNCTION TEMPLATE CALLS IN QUERY WITH IMPLEMENTAT
IT07230 2 AFTER A VIEW HAS BEEN ENABLED FOR OPTIMIZATION YOU MAY ENCOUNTERSQL0204N ERROR WHEN SELECTING FROM THE VIEW.
IT04365 2 DB2 MIGHT NOT CREATE IMPLIED PREDICATES ON GENERATED COLUMNS IN ORA COMPATIBILITY MODE
IT07992 2 SQL0901N WHEN A COLUMN MASK ON A NULLABLE COLUMN RETURNS A RESULT THAT IS ALWAYS NOT NULL
IT02646 2 SECURITY: DB2 CONTAINS A DENIAL OF SERVICE VULNERABILITY IN SQL COMPILER (CVE-2014-3095)
IT06949 2 DB2 MIGHT ABEND WHILE EXECUTING A QUERY WITH GROUP BY
IT06755 2 DB2 MAY BE SUSTAINED IN COMPILATION OF A COMPLICATED SQL WITH LIKE CLAUSE
IT01786 2 REORG ON A TABLE WITH FOREIGN KEY CONSTRAINT CAN RESULT IN SQL ON PARENT TABLE GETTING LOCK TIMEOUT
IT04155 2 PERFORMANCE MAY BE POOR FOR QUERIES WITH A VALUES CLAUSE AND UNION OPERATOR
IT07798 2 DB2 MIGHT PRODUCE SQL0901N ERROR WHEN EXECUTING QUERY WITH PREDICATES WITH TIMESTAMP DURATIONS
IT05326 2 DB2 MIGHT PRODUCE INCORRECT RESULT WHEN REFERENCING EMPTY TABLE WITH AGGREGATE FUNCTIONS IN SUBSELECT
IT04536 2 QUERY COMPILATION FAILS WITH SQLCODE -901 "INVALID COLLATION ID"
IT07803 2 QUERIES WITH CASE WHEN USING SUBQUERIES MAY LEAD TO PERFORMANCE ISSUE.
IT05647 2 SECURITY: ALTER TABLE ON AN IDENTITY COLUMN MAY CAUSE DB2 TO TERMINATE (CVE-2014-6209).
IT07892 2 DB2 MIGHT TRAP WHEN EXECUTING QUERY WITH COLUMN BASED ACCESS CONTROL
IT02338 2 DDLS ON NICKNAME CAUSE DEADLOCK
IT00522 2 DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERY WITH GENERATED COLUMNS OF DATATYPE DATE OR TIMESTAMP
IT05059 2 QUERY MAY GET WRONG RESULT IN VARCHAR2 ENABLED DATABASE WHEN USING MULTI-ROW, MULTI-COLUMN VALUES CLAUSE IN AN IN PREDICATE
IT02857 2 QUERY WITH A MIX OF EQUALITY AND RANGE PREDICATES IS NOT FULLY SIMPLIFIED
IT05492 2 A QUERY MAY HIT -901 ERROR WHEN IT CONTAINS PREDICATE COL=NULL
IT08504 2 INCORRECT RESULT WHEN QUERY HAS LEFT OUTER JOIN AND UNION ALL
IT02242 2 -901 FROM RUNNING A QUERY.
IT03855 2 PERFORMANCE PROBLEM WITH QUERY THAT USES A SEQUENCE IN THE PROJECTION LIST
IT03070 2 DB2 MIGHT NOT OPTIMIZE SQL QUERIES CONTAINING OUTER JOINS AND EXISTENTIAL SUBQUERIES
IT07879 2 PERFORMANCE ISSUE CAN OCCUR WITH INSERT / UPDATE STATEMENTS OVERCOMPLEX SUB-SELECTS CONTAINING PREDICATES.
IT04669 2 RENAME TABLE AGAINST AN ALIAS CAUSES THE UNDERLYING TABLE TO TAKE ON THE ALIAS' SCHEMA
IT04611 2 THE SQL0901 ERROR OF "NO FTSLPD THROUGH GB/UNION DISTINCT" IS WRONGLY RETURNED DURING FEDERATED SERVER STATEMENT COMPILATION
IT06067 2 FEDERATION: IMPORT ON NICKNAME FAILS WITH SQL27999N REASON CODE = "14".
IT07617 2 TABLE WITH INLINE TRIGGER THAT ACCESSES THE SAME TABLE MORE THANONCE IN THE TRIGGER BODY PRODUCES SQL0101N
IT01514 2 DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERIES WITH MULTIPLE NOT IN SUBQUERIES WITH CORRELATION OR FGAC
IT04135 2 DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING QUERY CONTAINING MULTIPLE SUB-SELECTS AND DISTINCT CLAUSE
IT06549 2 DB2 MIGHT FAIL WITH SQL0901N WHEN EXECUTING QUERY WITH MIX OF ANSI AND COMMA SEPARATED JOINS AND INTERDEPENDENCIES
IT07730 2 DB2 MIGHT ABEND WHEN EXECUTING QUERY WITH INLIST PREDICATES
IT01735 2 STDDEV, VAR AND VARIANCE WITH INTEGER INPUT RETURN WRONG DATA TYPE WHEN NUMBER SUPPORT IS ENABLED
IT04364 2 DB2 MIGHT ABEND WHEN EXECUTING QUERY CONTAINING A SUBSELECT WITHREDUNDANT PREDICATES
IT05385 2 QUERY MIGHT FAIL WITH SIGNAL #11 ON FUNCTION SQLNR_PULLUP_COMPENSATIONS
IT05401 2 IN A RARE CONDITION, A QUERY OF A CHAIN OF EQUALITY JOIN PREDICATES BETWEEN 4 OR MORE TABLES COULD PRODUCE EXTRA ROWS
IT03086 2 DB2 MIGHT CRASH IF A VALUES CLAUSE GENERATED TABLE IS USED AS A TARGET OF INSERT INTO STATEMENT
IT06948 2 QUERY WILL MULTIPLE SUBSUMABLE SCALAR SUBQUERIES MAY CAUSE DB2 TO ABEND
IT04474 2 "LIMIT # OFFSET #" MAY RETURN MORE ROWS THAN EXPECTED WHEN QUERIES CONTAIN UNION OR UNION ALL OPERATORS.
IT05074 2 SECURITY: DB2 MAY TERMINATE ABNORMALLY WHEN ISSUING AN ALTER TABLE STATEMENT WITH AUTO_REVAL SET TO IMMEDIATE (CVE-2014-6159).
IT04645 2 SQL20524 RC=3 RETURNED WHEN FUNCTION PARAMATER, LOCAL VARIABLE, OR TRANSITION VARIABLE USED AS PERIOD-SPECIFICATION
IT05376 3 QUERY MIGHT RETURN INCORRECTLY SORTED ROWS.
IT03056 3 TRANSLATE BUILT-IN FUNCTION FAILS WITH SQLSTATE 57017 ON UNICODEDATABASE
IT01996 3 INDIRECT JOIN PREDICATE PUSHDOWN EVALUATION FOR >1 INDIRECTION LEVELS
IT02440 3 QUERY MAY THROW RUNTIME ERROR SUCH AS OVERFLOW, DIVIDE BY 0, OR CASTING ERROR DUE TO JOIN PREDICATE EXPRESSION
IT02247 3 UNNECESSARY U-LOCKS PLACED ON STATISTICAL VIEWS DURING REFRESH MQT OR SET INTEGRITY
IT02853 4 CREATION OF A VIEW MIGHT RESULT IN SQL0973N ERROR
Fix Pack 5   -    Relational Data Services
IT07450 1 EXPLICIT AND IMPLICIT REBIND MAY RESULT IN DEADLOCK ON REBIND SEQUENCE LOCK
IT05357 1 INSTANCE CRASH IN DB2PCSD
IT04518 2 SEVERE PERFORMANCE DEGRADATION AFTER OUT OF MEMORY ERROR WHEN DB2_SQLWORKSPACE_CACHE IS SET
IT03677 2 WHEN PCKCACHESZ PARAMETER IS SET TO A VALUE > 524288, THE PACKAGE CACHE WILL BE CLEANED TOO AGGRESSIVELY.
IT07907 2 INSTANCE MAY TRAP WHEN CLOSING SECTIONS DURING INTERNAL COMMIT
IT03682 2 DB2 MIGHT TRAP IN SQLPLRQ() WITH REOPT ENABLED
IT02032 2 INSERT/UPDATE/DELETE STATEMENT THAT FIRES A TRIGGER MAY RETURN SQL0901N WITH "SECTION LENGTH MISMATCH"
IT00465 2 XA APPLICATION MAY BE FAILED BY RECEIVING -998
IT03443 2 ENABLE EXTENDED INDICATOR AND REOPT ALWAYS MAY CAUSE INSTANCE CRASH
IT08163 2 DB2 MAY TRAP IN SQLRA_GET_VAR WHEN HANDLING AN ERROR IF REOPT ISENABLED.
IT00363 2 STMM MAY UNNECESSARILY INCREASE PACKAGE CACHE SIZE
IT03464 2 SQL20540N (-1224) WHEN RUNNING AUTONOMOUS TRANSACTION DUE TO PLAN LOCK WHEN INTERNAL CLI PACKAGE IS INVALID
IT07993 3 DB2PD -ACTIVE CAN SHOW "ENTRYTIME" FOR A STATEMENT TO BE MUCH SOONER THEN IT SHOULD BE
IT07868 3 THRESHOLD TOTALMEMBERCONNECTIONS IS ENFORCED FOR USERS WITH DBADM OR WLMADM AUTHORITY.
IT03396 3 DB2 TRAP IN SQLRA_CACHE_DEL_DEP_VAR() DUE TO FREE A FREED MEMORY
IT06754 3 RUNNING TWO IDENTICAL ANONYMOUS BLOCK STATEMENT MAY RETURN SQL0901N "NOT ABLE TO LOCK VAR"
IT03724 3 "FLUSH PACKAGE CACHE" STATEMENT CLEANS UP STATIC SQL STATEMENTS BY MISTAKE
IT05141 3 MULTIPLE AGENTS WORKING WITH SAME VARIATION CAN FLOOD DB2DIAG.LOG WITH WARNING MESSAGES AT "SQLRA_FIND_VAR_VAR, PROBE:850"
Fix Pack 5   -    Routine Infrastructure
IT05205 2 DB2_FMP_COMM_HEAPSZ DOES NOT PROPERLY SET FMP HEAP/SET SIZE FOR VALUES < 256MB
IT07439 2 DB2PD -FMP SHOWS INCORRECT FORCEDTHRD VALUE
IT00786 2 NORMAL DPF QUERY PROCESSING ON DPF TRIGGERING UNNECESSARY FMP TERMINATION
IT00784 2 UNSTABLE DB2FMP PROCESSES MAY ACCUMULATE ON SYSTEM RESULTING IN EXCESSIVE MEMORY USAGE
IT02530 2 CLIENT LOAD CAN FAIL DUE TO MEMORY OVERWRITE BECAUSE OF INCORRECT INPUT PARSING
IT02199 3 MEMORY VALIDATION FAILURE WITH SQLERGETFMPIPC OR SQLERDEALLOCFMPIPC (CORRUPT POOL FREE TREE NODE)
IT06203 3 PROBLEM FIXED VIA IT00786 CAN STILL OCCUR FOR OTHER ROUTINE TYPES.
Fix Pack 5   -    Security
IT06354 1 SECURITY: INCORRECT EXTERNAL ENTITY HANDLING IN XML/XSLT (CVE-2014-8910)
IT07108 2 SECURITY: DB2 TRAPS WHEN EXECUTING A SPECIALLY-CRAFTED SQL STATEMENT WITH SCALAR FUNCTIONS (CVE-2015-0157)
IT08080 2 SECURITY: DB2 CONTAINS A FILE DISCLOSURE VULNERABILITY IN THE DATABASE AUTOMATED MAINTENANCE FEATURE (CVE-2015-1883)
IT08112 1 SECURITY: DB2 IS AFFECTED BY MULTIPLE SECURITY VULNERABILITIES IN GPFS (CVE-2015-0197, CVE-2015-0198, CVE-2015-0199)
IT08525 2 SECURITY: DB2 USER CAN DELETE TABLE DATA WITHOUT APPROPRIATE PRIVILEGES (CVE-2015-1922)
IT08536 1 SECURITY: VULNERABILITY IN RC4 STREAM CIPHER AFFECTS IBM ® DB2 ® LUW (CVE-2015-2808)
IT08543 1 SECURITY: DB2 LUW CONTAINS A VULNERABILITY IN SCALAR FUNCTION THAT MAY CAUSE DB2 SERVER TO TERMINATE ABNORMALLY (CVE-2015-1935)
IT06800 1 CRASH IN SQLEX_FIND_GROUP WHEN CUMULATIVE LENGTH OF GROUP NAMES RETURNED FOR AN USER ID IS GREATER THEN 64K
IT07646 1 SECURITY: VULNERABILITIES IN GSKIT AFFECT IBM DB2 LUW (CVE-2015-0138)
IT06004 1 KRB5CC* FILES ARE GENERATED IN /TMP/ DIRECTORY BY APPLICATION TRYING TO CONNECT TO DB2 WHEN PAM IS USED.
IT08702 2 LOAD/IMPORT REPLACE INTO A TABLE WITH LBAC/RCAC REQUIRES CONTROL/DBADM AUTHORITY
IT07553 2 SECURITY: DB2 CONTAINS A SENSITIVE INFORMATION EXPOSURE VULNERABILITY IN THE MONITORING AND AUDIT FEATURE (CVE-2014-0919)
IT04963 2 RESTORE_DB AUDIT EVENT NOT GENERATED FOR DATABASE LEVEL AUDITING.
IT06350 2 SECURITY: TLS PADDING VULNERABILITY AFFECTS IBM © DB2 © LUW (CVE-2014-8730)
IT05079 3 APPLICATION RETURNS -1042. DB2DIAG.LOG SHOWS "INVALID DATA VALUE: ICCLIB.C:989"
IT04119 3 AUD0022N MAY BE REPORTED WHEN DB2AUDIT EXTRACTS CORRUPTED AUDIT LOG
Fix Pack 5   -    Text Search
IT07463 2 AFTER UPGRADING FROM V9.7.X TO V10.1 FP3, THE "UPGRADE DATA BASE" COMMAND MAY REPORT SQL1499W
IT05635 2 INCORRECT DISTINCT CAUSE IN RMTQTXT WHEN USING FEDERATED PUSHDOWN = YES OPTION SO THE RESULT IS INCORRECT
IC96187 3 DB2VAL ERRONEOUSLY REPORTS THAT THE NET SEARCH EXTENDER FILES ARE MISSING.
IT06662 3 AN INITIAL UPDATE OF TEXT INDEX ALWAYS REPORTS CTE0360 ERROR IN DB2DIAG.LOG.
IC96622 3 XI/NOTIFY RESET USES CONNECTION ON DOWN PORT
Fix Pack 5   -    XML
IT07032 2 SEGMENTATION FAULT DURING XML QUERY "REPLACE" PROCESSING WHEN MATCHING EXTENSIVE NUMBER OF TOKENS
IT06627 3 INCORRECT XML TEMP SUBTREE SIZE CALCULATION LEADING TO VARIOUS XML PROCESSING ERRORS
Fix Pack 5   -    pureScale Services
IT03051 1 TAKEOVER HADR COMMAND SUCCEEDS BUT RESOURCE GROUP REPORTS FAILEDOFFLINE IN LSSAM OUTPUT
IT05127 1 IN A DB2 HA DPF ENVIRONMENT, PARTITION NUMBERS 997, 998 AND 999 ARE UNABLE TO FAILOVER BETWEEN SYSTEMS.
IT02495 2 IN A TSA/HADR ENVIRONMENT, THE STANDBY HADR RESOURCE MAY BE IN AFAILED OFFLINE STATE
IV65812 2 DB2STOP INSTANCE ON HOSTNAME FAILS WITH SQL1677N ERROR
IT08068 2 CHANGES IN THE MOUNT AUTOMATION SCRIPTS TO SUPPORT MOUNTS BASED ON VG'S WITH THE MULTI-NODE VARYON PROTECTION FEATURE ENABLED.
IT04075 2 USING THE DB2HAICU MAINTENANCE MODE OPTION TO MOVE HADR DATABASES MAY CAUSE THE HADR RESOURCE GROUP TO BE LOCKED
IT06469 2 ENHANCED-CAPABLE(EC) VG'S CAN REMAIN VARIED-ON IN READ-WRITE MODE ON THE STANDBY NODE.
IT08402 2 IN AN AUTOMATED HADR ENVIRONMENT, FOLLOWING A REBOOT OF THE STANDBY SERVER, THE DATABASE MAY NOT BE REINTEGRATED AS THE STANDBY
IT05545 2 HADR RESOURCE STATE REPORTS AS OFFLINE ON BOTH NODES EVEN THOUGHTHE HADR DATABASE IS IN PRIMARY STANDBY PEER STATE
IT04676 2 IN AN HADR/TSA ENVIRONMENT, DB2HAICU ONLY CREATES DEPENDENCIES AGAINST NETWORK EQUIVALENCIES NAMED AS "DB2_PUBLIC_NETWORK_X"
IT06025 2 ON RHEL 6, THE DB2FMCU COMMAND CREATES THE /ETC/INIT/DB2FMCD.CONF FILE BUT DOES NOT EXPLICITLY START/STOP THE DB2FMCD SERVICE.
IC99915 2 HADRV10_MONITOR.KSH FAILING DUE TO .BASHRC ENTRIES
IT03052 2 RUNNING DB2HAICU IN XML MODE TO SETUP A SECOND HADR DATABASE FORHIGH AVAILABILITY RETURNS AN ERROR
IT02842 2 HA FILESYSTEM IS AUTOMATICALLY REMOUNTED BY TSA WHILE THE DB2 INSTANCE IS STOPPED
IT02502 2 RUNNING THE "DB2FM -S" COMMAND RESULTS IN A SEGMENTATION FAULT ERROR.
IT08902 2 DB2 PANIC IN SAL_RELEASEPRIMARYCACASTOUTLOCKS
IT02176 2 DB2FMCU -D TERMINATED WITH SIGTERM AND RETURN CODE 143
IT08151 2 DB2HAICU MAY FAIL WHEN USING XML INPUT FILE DUE TO HOSTNAME LENGTH BEING 8 CHARACTERS OR MORE
IT05724 2 UNEXPECTED INSTANCE SHUTDOWN 8 HOURS AFTER DB2START HAS BEEN EXECUTED IN TSA ENABLED ENVIRONMENT
IT07338 2 THE DB2V10_START.KSH SCRIPT FAILS TO ACTIVATE DATABASES IN A C-SHELL (CSH) ENVIRONMENT
IT05278 2 XI/NOTIFY RESET USES CONNECTION ON DOWN PORT
IT02246 2 THE MONITOR SCRIPT USED FOR HA WITH VCS INCORRECTLY REPORTS THATTHE INSTANCE IS OFFLINE CAUSING AN INSTANCE RESTART
IT06964 2 DURING AN AUTOMATED PARTITION STOP, THE DB2GCF STOP COMMAND TIMES OUT LEADING TO THE INSTANCE BEING KILLED PREMATURELY
IT08371 2 IN A HADR HA(TSA) ENVIRONMENT, IN THE EVENT OF A PRIMARY SERVER FAILURE, THE STANDBY MAY NOT BE REINTEGRATED ON INSTANCE STARTUP
IT06702 3 DB2START MAY HANG AND LEAD TO GROUP RESTART IN PURESCALE BECAUSEOF NO PROPER TIMEOUT BEFORE CALLING TSA COMMANDS
IT07973 3 REDUCE SEVERITY OF DB2DIAG MESSAGES WHEN DISABLING FAULT MONITORING(FM) VIA DB2FM FOR AN INSTANCE THAT DOES NOT HAVE FM ENABLED
IT02885 3 LOTS OF "DB2ROCME 1 INSTANCE DB2INST 0 DB2CLUSTER GET_HOST_INFO"MESSAGES IN DB2DIAG.LOG
IT02241 3 DB2FM -D GENERATES SOME ERRORS IN DB2DIAG.LOG ON ESE SINGLE PARTITION INSTANCE
IT03487 3 IN A DPF ENVIRONMENT, THE "DB2GCF -S" COMMAND RETURNS OPERABLE STATE FOR NODE NUMBERS 997-999 WHEN THEY ARE IN AVAILABLE STATE
IT03035 3 RELAX CLUSTER COMMUNICATION GROUP SETTINGS IN A TSA/HADR ENVIRONMENT CONFIGURED USING DB2HAICU
IT02240 3 FALSE NEGATIVE ERROR MESSAGES IN DB2DIAG.LOG WHEN TAKEOVER HADR IN TSA CONFIGURED HA ENVIRONMENT
IT05945 3 LINUX ONLY: DB2GCF MIGHT REPORT INCORRECT STATUS DUE TO ASLR.

DB2 Version 10.1 Fix Pack 4
APAR Sev. Abstract
IT02365 2 MANY MMKSH PROCESSES ARE SPAWNED FROM MOUNTV10_MONITOR.KSH AND MAY CONSUME HIGH CPU
Fix Pack 4   -    Abstract Data Types and Spatial Extender
IC98507 3 PERFORMANCE MAY BE SLOW FOR SOME QUERIES USING DB2GSE.ST_INTERSECTS
Fix Pack 4   -    Administration Server
IC96292 2 WHEN A SCRIPT RUNS IN TASK CENTRE, EXTRA SLASH ADDED TO LIBPATH CAUSING INSTANCE ENV SWITCH USING DB2PROFILE TO FAIL
IC96468 3 USERS ON AIX IN DB2 V10.1 FP3, DASJVM::INITIALIZATION ERROR IN DB2DIAG.LOG, SQLCODE: -22209 RETURNED.
Fix Pack 4   -    Administration Tools
IC96680 1 DB2LOOK DOES NOT GENERATE COLUMN OPTIONS FOR TYPED TABLES
IC98333 2 SQL3022N - SQL ERROR "-104" EXECUTING DB2MOVE WITH EXPORT FROM DB2 Z/OS DATABASE
IC96865 2 AUTOMATIC BACKUP DOES NOT DELETE OLD BACKUP IMAGE IN DB2 V10
IC98508 2 DB2LOOK -M GENERATES RUNSTATS COMMAND WITH WRONG "NUM_FREQVALUES-1 NUM_QUANTILES -1" OPTIONS
IC97811 2 SQL0206N "A.TYPERULES" NOT FOUND SHOULD NOT BLOCK DB2LOOK TO GENERATE DDLS FOR OTHER OBJECTS
IC99625 2 DB2LOOK -L COLLECTS CONTAINER INFORMATION FOR AUTOMATIC STORAGE TABLESPACES WHICH IS NOT NEEDED BUT COULD CAUSE SLOWNESS ON DPF
IC97151 2 DB2LOOK -T OPTION WITH TWO-PART TABLE NAMES OF THE FORMAT SCHEMA.TABLE AGAINST DB2 Z/OS IT DOES NOT FIND THE TABLE.
IC96693 2 SQL0104N IS RETURNED WHEN UPDATING SYSSTAT.COLDIST.COLVALUE VIA DB2LOOK MIMIC MODE
JR47442 2 FED: DB2LOOK GENERATE INCORRECT FUNCTION MAPPING DDL
IC99726 2 CALL SYSPROC.AUTOMAINT_SET_POLICY() TO SET A NEW AUTO_REORG POLICY MAY RETURN SQL1437N - 'UNTERMINATED END TAG' DB2AUTOREORG
IC98071 3 DB2IUPGRADE FAILS WHEN MOVING FROM V8.2 TO V9.7FP5 AND HIGHER
IC96302 3 "INTERNAL HEALTH MONITOR ERROR " ERRORS DUMPED IN THE DB2DIAG.LOG FOR "DB2.MAX_SORT_PRIVMEM_UTIL" HEALTH INDICATOR
IC96694 3 ATS DAEMON MAY CAUSE A STACK OVERFLOW DUE TO RECURSIVE CALLS ANDSUBSEQUENT SEGV IF AN ERROR CONDITION IS ENCOUNTERED
IC97128 3 DB2LOOK MAY GENERATE THE SAME PREDICATE TO MIMIC STATISTICS FOR UNIQUE INDEXES.
JR47702 3 DB2LOOK GENERATES INCORRECT HIGH2KEY/LOW2KEY FOR CHAR/VARCHAR WHEN VARCHAR CAPATIBILITY IS ON
IC97821 3 PAGE_FETCH_PAIRS AND AVGPARTITION_PAGE_FETCH_PAIRS STATISTICS CANNOT BE CLEARED BY MANUAL UPDATE IF VARCHAR2 COMPATIBILITY IS ON
IC96298 3 HEALTH MONITOR FAILS TO DIFFERENTIATE BETWEEN HADR PRIMARY AND SECONADRY AFTER HADR TAKEOVER.
Fix Pack 4   -    Buffer Pool Services
IC99216 1 POSSIBLE CRASH (PANIC) OF DB2 IN SQLBREMOVEPAGEFROMTHISDIRTYLISTWITH MESSAGE "DEQUEUE W/0 PAGES ON DL"
IC99381 2 DATABASE HANG DURING FORCED SHUTDOWN OR HADR TAKEOVER
IC96706 2 PREFETCHER ERROR WITH SQLB_BADHDR "BAD PAGE HEADER" IN SQLB_VERIFY_PAGE, PROBE:6
IC99961 2 INCREMENTAL BACKUP MAY FAIL WITH SIGSEGV OR SQLO_EOF / SQL1655 DURING EMP CHAIN PROCESSING
IC98005 2 DROPPING ALL INDEXES FROM INDEX OBJECT FOLLOWING REORG INDEX RECLAIM EXTENTS MAY RETURN SQL1034C AND CAUSE INSTANCE ABEND
IT01599 2 ADDING STORAGE AND HITTING DISK FULL RESULTS IN A BAD SGF FILE
IC97599 2 CRASH RECOVERY FAIL WHEN FREEING DELETE PENDING EXTENTS
IC96465 2 TABLE SPACES HAVING ONLY ONE CONTAINER CAN NOT MAKE USE OF "VECTORED IO"
IC96692 2 DB2RELOCATEDB OR "DB2INIDB ... RELOCATE USING" MIGHT CONSTRUCT WRONG CONTAINER PATH NAME
IT01115 2 INCREMENTAL BACKUP MAY FAIL WITH ZRC SQL_EOF AND SQL1655 DURING EMP PAGE PROCESSING FOR LONG DATATYPE OBJECTS
Fix Pack 4   -    Build Team
IC94760 2 XQUERY MAY GET SQL1224N AND SIGSEGV
IC90397 2 SECURITY: MULTIPLE GSKIT VULNERABILITIES IN IBM DB2 (CVE-2012-2190, CVE-2012-2191, CVE-2012-2203, CVE-2013-0169).
IC97471 3 SECURITY: NULL POINTER DEREFERENCE IN DB2'S XSLT PARSING ENGINE (CVE-2013-5466).
Fix Pack 4   -    Client Interfaces
IC99396 1 UNHANDLED EXCEPTION: SYSTEM.ACCESSVIOLATIONEXCEPTION: ATTEMPTED TO READ OR WRITE PROTECTED MEMORY.
IC98963 1 WHEN APP HAVE BOTH CLIENT SIDE TRIAL LIC AND SERVER LIC, THE SQLGETINFO (CLI) FUNCTION WILL REPORT INCORRECT INFORMATION
IC97838 1 CLPPLUS DISPLAYS INCORRECT RESULT WHEN MORE THAN ONE LIKE CLAUSEIS SPECIFIED IN A SELECT STATEMENT
IC99554 1 SQLPARAMDATAADONET SYSTEM.ACCESSVIOLATIONEXCEPTION
IC93857 2 CALLING SQLSETSTMTATTR WITH THE OPTION SQL_ATTR_CHAINING_END CANRETURN SQL_ERROR , BUT DOESN'T UPDATE THE ERROR HEADER.
IC96303 2 CONVERSION ISSUE WHEN COMPILING WITH OPTION "WCHARTYPE"
IC91407 2 ERROR WHEN CLPPLUS PERFORMS ENVIRONMENT VARIABLE SUBSTITUTION FOR SQL STATEMENT THAT INCLUDES % CHARACTER
IC99202 2 ADO.NET DB2 PROVIDER - ACCESSVIOLATIONEXCEPTION ISSUE WHEN PERFORMING ARRAY INSERT OF LARGE BINARY VALUES ON A BLOB COLUMN.
IC96684 2 BATCH EXECUTION INTRODUCES INTERNAL COMMIT (EVEN WITH AUTOCOMMITOFF)
IC96874 2 CLI0113E ERROR OCCURS ON TIMESTAMP LITERAL VALUE FOR OUTPUT PARAMETER OF STORED PROCEDURE WHEN IMPLICIT CAST IS DISABLED
IC96300 2 END COMPOUND STATEMENTS THROWS DRIVER NOT CAPABLE AGAINST INFORMIX 12.0, WORKS FINE WITH IDS 11.7
IC96716 2 TWO MINOR MEMORY LEAKS IN CLI WITH SPECIAL REGISTERS AND ONE MAJOR MEMORY LEAK IN .NET
IC96695 2 CLIDRIVER AND DSDRIVER NOT WORKING ON HP PLATFORM :ERROR "SHAREDLIBRARY NOT FOUND 'LIBDB2.SO'"
IC98360 2 CLP +W OPTION DOES NOT HIDE WARNING FOR SELECT STATEMENTS
IC97835 2 EREG :CLIDRIVER AND DSDRIVER , SUN PLATFORM ONLY, 'DB2CLI VALIDATE -DSN DSN_TEST1' THROWS SEGMENTATION FAULT(COREDUMP)
IC95854 2 ERRORS SUCH AS SQL0313N AFTER A CLI APPLICATION EXECUTES DELETE OR UPDATE WITH WHERE CURRENT OF <CURSOR-NAME> CLAUSE
IC99205 2 ADO .NET PROGRAM CRASHES WITH ACCESS VIOLATION ERROR IN A MULTI-THREADED PROGRAM FOR MULTI ROW INSERT.
IC98468 2 VISUAL STUDIO ENTITY DATA MODEL WIZARD MIGHT NOT SHOW ISERIES TYPE L AND TYPE P TABLES
IC98106 2 PARAMETERS STORED AS STRINGS ARE NOT APPLIED BY DB2CFIMP (ERROR -5060)
IC96696 2 FORMATTING DB2TRC USING -CLI OPTION TERMINATES ABNORMALLY ON 64BIT LU PLATFORMS FOR 32BIT APPLICATIONS.
IC98102 2 DB2CFEXP DOES NOT EXPORT AUTOMATIC VALUES PROPERLY IF BACKUP CLAUSE IS SPECIFIED
IC98385 2 DB2CFEXP/DB2CFIMP UTILITIES FAIL TO EXPORT/IMPORT THE CORRECT SECURITY TYPE FOR NODE CREATED WITH SSL SECURITY.
IC95014 2 "DB2 PREP" IS FACING WITH SIGSEGV ERROR WHILE IT IS CALLED IN A MAKEFILE.
IC94998 2 ENTITY FRAMEWORK APPLICATION MAY GET -181 ERROR USING DATETIME AGAINST DATE COLUMN
IC98942 2 INCORRECT RESULTS WHEN FETCHING LOB DATA VIA CLI WITH MULTI-ROW FETCH
IC99456 2 WHEN STATEMENTCONCENTRATOR IS SET ALONG WITH SQL_ATTR_PARAMOPT_ATOMIC=0, CLI APP ERRORS OUT AGAINST DB2 Z/OS(-20186,-215, -312)
IC98799 2 CLI APPLICATION CRASHES DUE TO ARRAY INPUT FLAG FAILS TO RESET IN CLI LAYER WHILE CLI APPLICATION PERFORMS ARRAY INPUT.
IC94807 2 APPLICATION CAN CRASH WHEN USING DB2DSDRIVER.CFG AND IF THE SRVRLST.XML FILE CANNOT BE CREATED
IC97834 2 SQL0902 UNEXPECTED EXCEPTION ERROR MAY OCCUR IN DB2 .NET PROVIDER DUE TO UNHANDLED RETURN CODE DURING CODE PAGE CONVERSION
IC96683 3 DB2CLI VALIDATE -DSN <DSN> -CONNECT FAILES WITH SQL1032N ERROR
IC98273 3 ERROR CLI0199E WHEN CONNECTING TO A CATALOGED DATABASE IF AUTHENTICATION IS SPECIFIED IN CONNECTION STRING OR DB2CLI.INI
IC98607 3 CLI RETURNS BOOLEAN SUPPORT FLAG AGAINST ISERIES AND Z/OS SERVERAS TRUE WHEN BOTH THE SERVER DOES NOT SUPPORT BOOLEAN.
IC97248 3 THE CONNECTION ISOLATION LEVEL IS NOT PRESERVED AFTER A TRANSACTION BUT RE-SET TO THE PRODUCT DEFAULT.
IC95944 3 WHEN DBALIAS IS MENTIONED IN CONNECTION STRING, CLI IS NOT PROCESSING COMMON SECTION OF DB2CLI.INI
IC94310 3 CLPPLUS CAN NOT PUT NEW LINE WITH DBMS_OUTPUT.NEW_LINE.
IC97827 3 APPLICATIONS USING THE IBM DATA SERVER DRIVER RECEIVE SQL0902C ERROR IF DATABASE NAME IS NOT IN THE DB2DSDRIVER.CFG FILE.
IC99430 3 DB2BATCH MAY TERMINATE ABNORMALLY WITH SEGMENTATION FAULT
IC97147 3 DB2CLI VALIDATE -DSN DATABASE RETURNED "MESSAGE : NO CHARACTER DATA IS ALLOWED BY CONTENT MODEL"
IC98852 3 CONCURRENTACCESSRESOLUTION DS DRIVER KEYWORD DOES NOT TAKE EFFECT IF VALUE IS SPECIFIED BY STRING.
IC96642 3 CLPPLUS DOES NOT READ DB2DSDRIVER.CFG PRESENT UNDER CFG FOLDER FOR IBM DATA SERVER PRODUCT INSTALLATION
Fix Pack 4   -    Codegen and Runtime
IC97719 1 UNDER HIGH CONCURRENCY THE FAST INTEGER SORT ( FIS ) FEATURE CANCAUSE HIGH LATCH CONTENTION AND PERFORMANCE DEGRADATION
IC98683 1 ROWS MISSING WHEN LARGE RESULT SET IS PRODUCED BY NULLS FIRST SORT ON INTEGER OR BIGINT
IC97456 1 INCORRECT RESULTS FOR A QUERY WITH A SORTED UNION
IC98361 2 ZIGZAG JOIN GIVES WRONG RESULTS
IC96553 2 SQL0901N ERROR TRIGGERED IN SQLKTSND:AT SANITY CHECK IN CODE
IC97379 2 THE ROUND FUNCTION WITH A MINIMUM VALUE FOR INTEGER AND BIGINT VALUES IS NOT RETURNING THE CORRECT RESULTS
IC97836 2 POOR PERFORMANCE DUE TO FREQUENT MEMORY OPERATIONS DURING QUERIES WITH 'LIKE' PREDICATES.
IC97546 2 INSTANCE CRASH DUE TO RUNTIME SERVICES FREEING AN XML NULL POINTER
IC98141 2 THE UTL_MAIL.SEND PROCEDURE RETURNS SQL1336 AFTER APPLYING SOLARIS PATCH
IC99204 2 DB2 MIGHT DUMP FODC_APPERR DUE TO CODEPAGE ERROR WHEN SELECTING XML COLUMN VIA VIEW WHEN TRUNCATION IS HAPPENING.
IC97775 2 INSTANCE MIGHT ABEND OR RETURN INCORRECT RESULTS DUE TO AN INCORRECT EXECUTION SECTION FOR STAR JOIN
IC95583 2 UNDER RARE MEMORY CONDITIONS, STMM HASH JOIN SIMULATION MAY FAILAND CAUSE FODC TO BE PRODUCED
IT00929 2 COLLATION_KEY_BIT MIGHT GENERATE EMPTY STRINGS IN ORACLE MODE IFINPUT STRING CONSISTS OF BLANKS
IC97793 2 INCORRECT RESULT IN UNICODE DB WITH LIKE PREDICATE AND FULLWIDTH UNDERSCORE WILD CHARACTER ON A CLOB COLUMN
IC97837 2 DB2DIAG.LOG IS FILLED WITH -443 WARNING MESSAGES
IC98959 2 INSTANCE MAY CRASH IF THERE INCONSISTENT STATISTICS
IC98021 2 AN ACCESS PLAN WITH NESTED MDTQ OPERATORS WITHOUT A SORT OR TEMPOPERATOR IN BETWEEN MAY HANG
IC99898 2 FIX CHECK FOR CURRENT_SPECIAL_BUILD
IC95108 2 DB2 INSTANCE MAY TRAP WITH SIGNAL #11 ON SQLKQSND FUNCTION
IC99905 2 SELECT INTO STATEMENT DOES NOT SET VALUE TO A GLOBAL VARIABLE
IC98848 3 COPY PROCEDURE IN DBMS_LOB MODULE MIGHT FAIL AFTER 32KB DATA, ALTHOUGH DBMS_LOB MODULE SUPPORTS LOB DATA UP TO 10MB.
IC97339 3 QUERIES WITH THE XMLTABLE FUNCTION MIGHT RETURN INCORRECT RESULTS
IC97304 3 DIAGNOSTIC FIX TO COLLECT EXTRA DATA, PERFORM EXTRA CHECKS AND PREVENT TRAPS DUE TO MEMORY OVERWRITES IN TABLE QUEUES
IC95046 3 THE DBMS_LOB.COMPARE FUNCTION AND DBMS_LOB.READ PROCEDURE DO NOTPROCESS CLOBS CORRECTLY IF MULTI-BYTE CHARACTERS ARE PRESENT
IC94836 3 WITH CURRENTLY COMMITTED SEMANTICS DISABLED A STATEMENT MAY INCORRECTLY FAIL WITH SQL0901N ( REASON "IMPROPER LOCKING" )
IC98114 3 IN DB2 DPF ENVIRONMENTS ONLY, A SPECIFIC TYPE OF QUERY AND RESULTING ACCESS PLAN MIGHT RETURN WRONG RESULTS
Fix Pack 4   -    Communication
IC96685 2 RETURN ERROR WHEN MULTI-TRANSPORT TM ATTEMPTS TO XACOMMIT/XAROLLBACK WHEN THERE IS WITH-HOLD CURSOR IN USE.
IC97831 2 RESUMPTION OF SUPPORT FOR NAMED PIPES COMMUNICATION PROTOCOL.
IC97833 2 AUTHENTICATION VERY SLOW ON CERTAIN PSERIES HARDWARE WITH POWER7CPU'S
IC97569 3 APPLICATION DELAYS MAY OCCUR WHEN DISCONNECTING FROM DB2 SERVERSON WINDOWS
Fix Pack 4   -    DB2 Tools
IC95264 2 SQL1096N WHEN WE TRY TO STOP/START THE DB2 INSTANCE VIA THE DB2SYSTRAY ICON.
IC97829 2 SQL0108N RETURNED WHEN USING ADMIN_CMD PROCEDURE TO DO TABLE REORG WITH TEMP TABLESPACE OPTION BEING SPECIFIED
IC98031 2 RUN NNSTAT FAILED WITH SQL0134N OR SQL1131N WHEN THERE IS AN INDEX INCLUDE LOB TYPE COLUMN
IC97830 2 LOAD COMMAND USING THE ADMIN_CMD PROCEDURE DOES NOT SHOW ROWS_SKIPPED, ROWS_LOADED, ROWS_DELETED, AND ROWS_COMMITTED WITH DPF
IC97828 3 MESSAGE: "POSSIBLE MEMORY CORRUPTION" IN DB2DIAG.LOG WHEN USING ADMIN_MOVE_TABLE()
Fix Pack 4   -    DRDA Services
IT00893 1 AUTOMATIC CLIENT REROUTE DOES NOT RECONNECT TO THE PRIMARY OR ORIGINAL SERVER
IC99147 1 DB2 DRIVER/CLIENT MAY TRAP FOR APPLICATIONS USING THE WORKLOAD BALANCING (WLB) FEATURE.
IC98074 2 DB2 INSTANCE MIGHT CRASH AFTER REPORTING 'CM PARAMETER BAD' ERROR.
IC94589 2 XA_COMMIT() RETURNED XAER_RMFAIL(-7) WITH PURESCALE ENVIRONMENT DURING XA TRANSACTION RECOVERY, WHEN USING AFFINITIES.
IC95200 2 EXEC SQL SET CONNECTION FAILED WITH SQL0843N
IC99702 2 CHAR DATA CORRUPTION DURING SELECT WITH QUERY ACCELARATION.
IT01405 2 CLI APPLICATION MAY CRASH IN CLI_EXECCMRIFLUSHARRAY() FUNCTION
IC98918 2 INSTANCE TRAPS IN SQLDDADDEXTENDEDDDENTRY()
IC97878 2 SQL30020N ON ROLLBACK, IF CONNECTING TO DB2 10.1 SERVER VIA DB2 CONNECT 9.7 GATEWAY
IC95556 2 THE SINGLE-THREADED APPLICATION CONVERTS TO MILTI-THREADED (2 THREADS)
Fix Pack 4   -    Data Management Services
IT00380 1 SQL1476N WITH ERROR "-668" RETURNED WHEN SET INTEGRITY FOR AN MQT OF "COMPRESS YES" AND "REFRESH IMMEDIATE"
IC98351 1 SEVERE ERROR INDICATED WHILE READING LOB ALLOCATION MAP
IC96825 2 DB2 INSTANCE MIGHT CRASH WHEN USING INCORRECT TABLE DESIGNATOR VALUE FOR RID SCALAR FUNCTIONS.
IT00796 2 AN SQL STATEMENT THAT REFERENCES A CREATE GLOBAL TEMPORARY TABLEON WHICH NO RUNSTATS WAS PERFORMED MAY RESULT IN SQL901N
IC94323 2 LATCH PROTOCOL ISSUE IN ZIG ZAG JOIN EXECUTION LEADING TO DEADLATCH BETWEEN SUBAGENTS
IC98167 2 DATABASE CRASHES WHEN ATTEMPTING A DROP COMMAND THAT CONTAINS "NULLS"
IC91168 2 SQL STATEMENT MAY HANG DUE TO A DEADLATCH WHEN PROCESSING SUBSECTIONS OF A ZIG ZAG JOIN PLAN
IC96823 2 LOG FULL DURING TABLE TRUNCATION CAUSES CRITICAL ERROR AND MARKSDATABASE BAD
IT00629 2 BADPAGE OR OTHER ERRORS WHEN ACCESSING TABLES IN A TABLESPACE THAT IS BEING RESTORED OR ROLLED FORWARD
IC95009 2 IN PURESCALE ENVIRNMENT, 3-WAY DEADLATCH COULD HAPPEN IN RARE TIMING SCENARIO.
IC99072 2 ADMIN_GET_TAB_COMPRESS_INFO_V97 IS SHOWING NEGATIVE NUMBER FOR ROWS_SAMPLED FOR A LARGE TABLE
IC94695 2 SLOW CONCURRENT INSERTS INTO LARGE TABLE
IT00694 2 SQLDREPLACEROW REPORTS SQLD_BADPAGE DURING ROLL FORWARD
IC99788 2 FAILURE DURING ONLINE TABLE REORGANIZATION MIGHT LEAD TO DATABASE HANG
Fix Pack 4   -    Data Management Utilities
IC99741 2 FORCE APPLICATION OF LOAD FROM CURSOR MIGHT CAUSE LOAD TO HANG
IC95947 2 -901 IN REDISTRIBUTE ABORT AFTER SUCCESSFUL REDISTRIBUTE ABORT/CONTINUE WITH EXCLUDE KEYWORD.
IC99917 2 IMPORT MIGHT HIT SQL0304N ERROR AND REJECT ROWS CONTAINING TIMESTAMP DATA IF TIMESTAMPFORMAT IS SPECIFIED FOR ASC/DEL FILE
IT01473 2 ROLLFORWARD FAILS WITH SQL1042C / "DMS DATABASE TERMINATION: FIX COUNT != 0"
IC96098 2 REMOTE CLIENT LOAD HANGS AND COULD NOT BE KILLED
IC96870 2 DB2 DOES NOT RESPOND TO FORCE APPLICATION OR INTERRUPT REQUEST AGAINST LOAD APPLICATION
IC96951 2 INGEST UTILITY MIGHT INSERT NULLS INSTEAD OF CORRECT DATA TO NUMERIC COLUMNS WHEN INPUT FILE SIZE IS HUGE
IC94696 2 DB2 EXPORT AND DB2 IMPORT ONLY SUPPORT STATEMENTS < 32700 BYTES AGAINST NON-LUW SERVERS
IC97046 2 A LOAD COMMAND WITH LOW WARNINGCOUNT MIGHT HANG
IC98199 2 LOAD MIGHT FAIL WITH SQL2043N WHEN IT IS ABOUT TO END IN A RARE TIMING-DEPENDENT SCENARIO
IC97332 2 LOAD FROM REMOTE CURSOR (REMOTE FETCH LOAD) MAY HANG AFTER GETTING AN ERROR IN VERY EARLY PHASE
IC96873 2 ROLLFOWARD FAILURE FOR THE LOAD COPY YES INTO /DEV/NULL MAY WRONGLY LEAVE THE TABLESPACE IN NORMAL STATE
IC97127 2 POSSIBLE CRASH (SEGV/ABORT) IN SQLDFORMATLOBLONGCOL() WITH LOAD FROM CURSOR ON TABLE WITH LOB AND CODESET CONVERSION
IC98479 2 INGEST UTILITY: ERROR SQL2038N WHEN A DISTRIBUTION KEY COLUMN TYPE IS A UDT
IC93301 3 SORTS FROM SMALL INDEX BUILDS OVER-RESERVE SORT MEMORY, STMM MAYUNNECESSARILY INCREASE SORT TUNING
IC97045 3 LOAD MIGHT HANG IF INPUT DATA HAS LARGE CORRUPTED SECTION
IC97902 3 INGEST COMMAND NO LONGER RETURNS SQL3604N WHEN EXCEPTION TABLE HAS DB2SECURITYLABEL COLUMN
IC96703 3 UNDER RARE CONDITIONS, LOAD CANNOT BE FORCED OFF DURING A FORCE APPLICATION PROCESSING IN A DPF ENVIRONMENT.
Fix Pack 4   -    Data Recovery Services
IC99041 1 DIVIDE BY ZERO TRAP IN PAGE_AGE CODE IN SQLPCHECKFORBAFLSH
IC97897 1 UNEXPECTED LOCK ESCALATIONS ON DB2 PURESCALE SYSTEMS USING STMM LOCKLIST TUNING OR MANUAL DYNAMIC UPDATE OF LOCKLIST SETTING
IC98278 1 DUE TO LSN CHANGES IN PURESCALE ARCHITECTURE TOOLS USING DB2READLOG API MAY SUFFER BAD PERFORMANCE IF AN OLD LSN IS REQUESTED
IC98998 1 ROLLFORWARD TO END OF BACKUP IMAGE MIGHT FAIL DUE TO CLOCK SKEW FOR A DPF DATABASE ON MULTIPLE PHYSICAL NODES
IT00609 1 RESTART DATABASE FAILS WITH ERROR SQL1042C
IC96296 1 SLOW COMMITS WHEN STMM-MANAGED LOCKLIST GROWS INTO OVERFLOW
IT01189 1 TABLE SPACE ROLLFORWARD MIGHT NOT UNDO TRANSACTION CORRECTLY, LEAVING INCONSISTENT DATA
IC97150 1 COMPENSATION LSN AS RETURNED FROM DB2READLOG API DIFFERS FROM THE ACTUAL VALUE
IC99737 2 DATABASE MIGRATION TO V10 CAN TAKE A LONG TIME TO COMPLETE, WHILE V10 LOGFILES ARE ALLOCATED IN BACKGROUND
IC96925 2 DB2ADUTL FAILS WITH SQL1019 WHEN ACQUIRING INSTANCE CONNECTION TO DETERMINE NODE NUMBER WHEN INSTANCE NAME IS LESS THAN 8 CHARAC
IC97815 2 STANDBY MAY FAIL TO CONNECT TO PRIMARY WITHIN HADR_TIMEOUT, WHENDB2_HADR_BUF_SIZE IS SET TO A VERY LARGE VALUE
IC98629 2 ROLLFORWARD DATABASE RETURNS SQL1774N ON HADR DATABSE AFTER SNAPSHOT RESTORE AND DB2INIDB AS MIRROR
IC98861 2 SILENT SWITCH TO THE DEFAULT LOGPATH PATH
IC96738 2 DB2READLOG API WAS RETURNED SQLCODE -1273
IC96682 2 ONLINE BACKUP MIGHT BLOCK TRANSACTIONS THAT ARE DOING COMMIT.
IC99671 2 DB2 DOES NOT REMOVE OLD LOGS DURING UPGRADE IN V10
IC96876 2 IMPROVE SQL2038N ERROR MESSAGE
IC98168 2 WHEN USING DB2ADUTL DELETE OLDER THAN S00000XX.LOG COMMAND THE LOG INCLUDING S00000XX.LOG WOULD BE REMOVED.
IC97591 2 THE SPLIT SNAPSHOT FLAG IS NOT CLEARED DURING A SNAPSHOT BACKUP
IC98024 2 IN PURESCALE ENV ROLLFORWARD ON MEMBER X WON'T FETCH LOGS FROM TSM FOR OTHER MEMBERS WHEN RESTORING TO NEW DATABASE NAME
IC96297 2 ONLINE BACKUP FAILS DUE TO BAD FIRSTLOS AFTER TAKEOVER
IC96871 2 IN DPF ENVIRONMENT PRUNE WILL NOT DELETE IMAGE FROM DISK WHERE THE DATABASE PARTITION EXPRESSION $N WAS USED IN TARGET DIRECTORY
IC95901 2 DB2 ROLLFORWARD MIGHT HANG IN BACKWARD PHASE WHEN INFINITE LOGGING IS USED
IC96209 2 IN AN AUTOMATED HADR ENVIRONMENT THE TAKEOVER HADR COMMAND SUCCEEDS, BUT A MOVE REQUEST IS NOT SENT TO TSA
IC94077 2 IN XA ENVIRONMENT, DB2 TRAPS WHEN PROCESSING THE JOIN WITH CURSOR CALL
IC92741 2 ONLINE BACKUP PERFORMANCE DEGRADATION AND ABNORMAL BACKUP IMAGE FILE SIZE VARIATIONS IN V10.1
IC97548 2 RESTORE GENERATING ERRORS DUE TO COMPRESSION LIBRARY ALREADY EXISTING.
IC97550 3 HADR PRIMARY DISCONNECTS AND STANDBY SHOWS PEER STATE WHEN DISK IS FULL ON STANDBY.
IC97176 3 HADR STANDBY DB COULD RUN INTO A TRAP WHEN IT'S REMOTE DB IS ALSO A STANDBY DB
IC98575 3 DATABASE UPGRADE TO DB2 V10.X DOES NOT DELETE THE PRE-V10 DB2TSCHG.HIS FILE
IC97549 3 BACKUP LIST UTILITIES COMPLETED WORK ESTIMATE INACCURATE WHEN BACKUP-COMPRESSION ENABLED.
Fix Pack 4   -    E2E Monitoring code
IC98016 2 ALL MONITORING INFORMATION SHOWS UNDER NULL CLIENT INFO VALUES ON THE OPM EI DASHBOARD
Fix Pack 4   -    Federation
IT01598 1 FEDERATION SERVER CREATE NICKNAME COMMAND REDUCES THE LENGTH OF DBCLOB COLUMN
JR48650 2 FED:PFORMANCE ENHANCEMENT FOR ORACLE
IC95657 2 FED: UPDATE NICKNAME FAILED WITH SQL1822N WITH "HY104 INVALID PRECISION VALUE"
JR48544 2 FED:IN PREDICATE CAN NOT BE PUSHDOWN DUE TO BLANK PADDING
IC98696 2 FEDERATION SERVER QUERY RESPONSE SLOWLY EVEN IF JR47502 IS APPLIED
JR48442 2 USING SERVER OPTION DB2_REQUESTS_IO_BLOCK_BUF MAY CAUSE A DATABASE FORCED SHUTDOWN WHEN SELECT FROM NICKNAME
JR47419 2 INSERT INTO ODBC/JDBC NICKNAME FAILED WITH SQL0901N REASON "BAD COMPILER RETURN CODE"
IC97633 2 FEDERATED QUERY MAY RECEIVE SQL0418N ERROR IF FEDERATED DATABASESET STMT_CONC=LITERALS
IC96771 2 QUERIES WITH/WITHOUT PREDICATES RETURNED SAME RESULT, PUSHDOWNABLE PREDICATE IS NOT COMPOSED INTO REMOTE STATEMENT
JR49446 2 INCORRECT DATA COULD BE INSERTED INTO NICKNAME WITH AN INSERT STATEMENT HAS A PLAN WITH TQ UNDER SHIP
IC96704 2 SQL0901N ERROR WHEN CREATING NICKNAME ON NICKNAME
IC95660 2 FEDERATION SERVER MAY CRASH WHEN FORCING APP ON COOR NODE FROM NONE-COOR NODE
JR49341 2 BLOCK FETCH MAY CAUSE ENGINE CRASH WHEN DB2FMP TERMINATES ABNORMALLY
IC99650 2 DRDA WRAPPER REPORTS SQL3324N WHEN CREATING NICKNAME FOR A TABLE USES LBAC
IC98030 2 RECEIVE SQL0901N REASON "UNKNOWN TYPE" WHEN QUERYING A TERADATA NICKNAME INCLUDING HUGE NUMBER OF ROWS
JR48747 2 TIMESTAMP-TIMESTAMP PREDICATE IS NOT PUSHDOWNED WHEN USING ORACLE WRAPPER IN ORACLE MODE
IC98349 2 A QUERY WITH AN OR PREDICATE MIGHT RETURN INCORRECT RESULTS
IC98826 2 FEDERATION SERVER QUERY RESPONSE SLOWLY EVEN IF JR47502 IS APPLIED
JR48649 2 FED:PERFORMANCE ENHANCEMENT FOR PLAN HINT PUSHDOWN
IC99795 3 PUSHDOWN PERFORMANCE ISSUE DUE TO MISSING '=' FUNCTION MAPPINGS FOR DECIMAL/DECFLOAT
Fix Pack 4   -    Index Manager
IC99374 1 USING LOAD FOR MDC TABLES ON CASE INSENSITIVE DATABASES MIGHT CAUSE BLOCK INDEX CORRUPTION
IC98073 1 DEADLOCK MAY OCCUR SURROUNDING ANONYMOUS BLOCKS PACKAGES WHEN DB2ABC (APM CACHE CLEANUP) AND DDL STATEMENT RUN CONCURRENTLY.
IC95923 1 ABP DAEMON (DB2TASKD EDU) STOPPED AND NOT RESTARTED IN DPF MODE AFTER A NON-CATALOG PARTITION IS FORCED AND RESTARTED
IT00335 2 LOAD INTO MDC TABLE FAILS WITH SQL0902C OR SQL0990C
IC97306 2 INSTANCE MAY CRASH WITH ERROR (IN DB2DIAG.LOG) "ROLLOUT CB LIST IS NOT EMPTY AT TX BOUNDARY! "
IC97632 2 SAMPLED DETAILED INDEX RUNSTATS ON RANGE PARTITIONED TABLES CAN RESULT IN HIGH PRIVATE MEMORY USE AND LONG EXECUTION TIME
IC98288 2 AFTER PERFORMING AN OFFLINE REORG IN HADR ENVIRONMENT, INDEX SMSTABLESPACES HAVE DIFFERENT SIZES ON PRIMARY COMPARED TO STANDBY
IC94549 2 RUNSTATS WITH SAMPLED DETAILED INDEXES ON PARTITIONED, MDC TABLEMIGHT RESULT IN EXCESSIVE MEMORY UTILIZATION AND SQL0973N ERROR
IT00423 2 POTENTIAL INDEX CORRUPTION WHEN USING INDEX COMPRESSION AND UNICDOE DATABASES WHICH USE UCA COLLATION WITH S(STRENGTH) = 1 OR 2
Fix Pack 4   -    Install and Catalog Services
IC99752 1 LUM LIBRARY NEEDS TO BE UPDATED FOR LINUXAMD64
IC95658 2 32-BIT IBM DB2 ODBC DRIVER NOT ENABLED FOR CONNECTION POOLING, ON 64-BIT WINDOWS INSTALL
IC96294 2 SQL0901N REASON "COLUMN NUMBER OUT OF RANGE" WHEN SELECTING FROMTABLES RELATED VIA FOREIGN KEY, AFTER ALTER DROP COLUMN
IC97792 2 DROP ROLE COMMAND CAUSES A SQLOSPINLOCKCONFLICT IN SQLRLC_ROLECACHE.C AND SQLRLC_INLINES.H FUNCTIONS AND LOCKING ABOUT 52 APPLIC
IC96218 2 RENAME TABLESPACE NOT HANDLING ERROR DURING SYSTEM CATALOG UPDATE AND LEAVING ORPHAN ROW(S)
IC99289 2 POSSIBLE CACHE CORRUPTION(SEGV/CRASH): ENTRY CAN BE FREED BY ONETHREAD AND ADDED TO LRU BY ANOTHER AT THE SAME TIME
JR49622 2 NNSTAT MAY FAIL WITH SQL0181N/SQL0180N ERROR WITH METHOD 0 OR 1
IC96837 2 DB2UPDV10 RETURN ERROR: SYSDEBUGPRIVATE, -204
IC97143 2 DATABASE UPGRADE FAILS WITH SQL20481N
IC97260 2 DATABASE UPGRADE TO DB2 V10 MAY TRAP WITH SEGMENTATION VIOLATIONIN FUNCTION SQLRLM_CHECKMIGRATEFLAG
IC99281 2 WHILE ADDING A NEW MEMBER/CF OR NETNAME TO A MEMBER/CF YOU MAY GET THIS ERROR " RSCT PEER DOMAIN IS ONLINE "
IC99536 2 ALTER TABLESPACE PREFETCH SIZE ON TABLEPSAPCES WITH MANY OBJECTSFLOODS CATALOG CACHE
IC95588 2 UPGRADE DATABASE MAY TAKE LONG IN DPF ENVIRONMENT DUE TO DYNAMICSTATEMENT CACHE INVALIDATION
IC98832 2 DATABASE MIGRATION FROM V9.8 PURESCALE ENV. TO V10.5 MAY TRAP WITH SQL1224N ERROR.
IC96686 2 DB2 WSE : DB2LICM -G OUTPUT SHOULD DISPLAY A VIOLATION WHEN COMPRESSION IS USED
IC97598 2 AFTER LOGS BECOME FULL, AN INSERT INTO A GLOBAL TEMPORARY TABLE (DGTT) FAILS WITH SQL0901N
IC97826 2 LDAP LIBRARIES ARE MISSING AFTER AN INSTALLATION DONE WITH A RESPONSE FILE GENERATED BY DB2RSPGN
IC97876 2 DURING VIEW REGENERATION , DROPPING OF STATISTICS DON'T SET STATISTICS_PROFILE COLUMN OF SYSTABLES CATALOG TABLE TO NULL.
IC99857 2 DB2IUPDT FAILS FOR DPF ENV WHEN VIRTUAL IPS ARE USED
IC97163 2 SQL1499W WHEN UPGRADING DATABASE
IC99006 3 ALTER INDEX ON TABLE CORRUPTS AUDIT LOG FILE
IC96901 3 DB2CFEXP DOES NOT EXPORT SOME DATABASE MANAGER CONFIG PARAMETERS.
IC92907 3 DB2PREREQCHECK MAY PRINT OUT UNNECESSARY QUOTES.
IC97302 3 DB2ICRT COMMAND SKIPS SOME OPEN PORTS RANGE IN /ETC/SERVICES DURING FCM PORTS RESERVATION
IC98154 3 USABILITY: INSTANCE CREATION, UPGRADE, UPDATE HARD FAILS IF IT IS NOT ABLE TO RESERVE 4 PORTS IN /ETC/SERVICES FOR AN ESEINSTAN
IC98881 3 DB2SETUP WILL UPDATE SVCENAME WITH PORTNUMBER INSTEAD OF SERVICENAME.
IC96687 3 DURING SILENT INSTALLATION OF DB2 RUNTIME CLIENT, IF CREATE_ICONIS SET TO NO, DB2.EXE IS NOT INSTALLED.
IC96705 3 IMPLEMENTATION FIELD IN SYSCAT.ROUTINES FOR A SOURCED FUNCTION MISSING MODULE NAME & MAY BE AMBIGUOUS IF IDENTIFIER HAS PERIODS
IC99322 3 DB2 NOT REGISTERED AS THE DEFAULT COPY WHEN IT IS THE ONLY COPY AND DEFAULT_COPY=NO & DEFAULT_CLIENT_INTERFACE_COPY=NO
Fix Pack 4   -    JDBC Driver
IT02967 3 TO DOCUMENT ALL THE JCC APAR AND DEFECTS SHIPPED WITH   DB2   V10.1FP4 RELEASE
IC99026 2 JCC PROPERTIES SUCH AS CURRENTSCHEMA ARE SOMETIMES IGNORED. A POSSIBLE SYMPTOM IS AN SQLEXCEPTION WITH SQLCODE=-204
IT02676 2 CONNECTION.ISVALID(INT TIMEOUT) API DOES NOT WORK UNEXPECTEDLY
IC97033 2 WHEN USING XADATASOURCE WITH ENABLESYSPLEXWLB=TRUE, A GRADUALAND PERMANENT GROWTH IN TRANSPORT OBJECTS MAY OCCUR
IC98295 2 XAER_PROTO. ERRORCODE=-4203, ERROR RETURNED WHEN FIRST QUERYFAILS IN AN TRANSACTION
IC94489 3 EXECUTEBATCH FAILS IF ONE OF THE STRING COLUMN IS SET USING SETDBSTRINGASBYTES WITH SQLCODE = -302
Fix Pack 4   -    Monitoring
IC95740 2 DB2 INSTANCE MIGHT TRAP IN SQMAGENTRTNSTACK::GETRTNCTXFORSND() WHILE CONSTRUCTING THE ROUTINE CONTEXT INFORMATION.
IC98138 2 GLOBAL LOCK SNAPSHOT CAN TRAP WHEN INDOUBT TRANSACTIONS ARE PRESENT IN A DPF ENVIRONMENT
IC97824 2 ADMIN_MOVE_TABLE DOESN'T RECREATE THE SECURITY LABEL ON A COLUMN
IC96688 2 LOOP IN EXPLAINREADACTUALSFROMACTEVMON() CALLED BY SYSPROC.EXPLAIN_FROM_ACTIVITY()
IC96030 2 SYSTEM APPLICATIONS INVOLVED IN A LOCKING EVENT ONLY SHOW UP AS PARTIAL EVENTS.
IC97983 2 ADMIN_MOVE_TABLE FAILED WITH SQL0104N IF THE SOURCE TABLE HAS NOINDEX AND THE 1ST COLUMN SIZE EXCEEDS THE MAX KEY LENGTH LIMIT
IC96022 2 POTENTIAL HANG ON TRANENTRY LATCH IN SQLPM_WRITE_APPL_LOCKS DURING LOCK SNAPSHOT
IC99906 3 ADM2017C MAY BE OCURRED EVEN IF FILESYSTEM HAS ENOUGH ROOM.
IC98017 3 IF A TABLE HAS DB2SECURITYLABEL COLUMN, ADMIN_MOVE_TABLE FAILED WITH SQL0683N.
IC98282 3 ON SOME RARE OCASIONS, LOCKING EVENT MONITOR MIGHT FAIL TO REPORT ALL PARTICIPANTS OF A DEADLOCK
IC99580 3 RUNNING ADMIN_MOVE_TABLE TWICE DOES NOT SET GENERATE ALWAYS AS IDENTITY VALUES CORRECTLY
IC97066 3 DBSUMMARY() METRICS BREAKDOWN MAY REPORT INACCURATE VALUES FOR POOL_READ_TIME OR POOL_WRITE_TIME COMPARED TO TOTAL_WAIT_TIME
IC97547 3 ADMIN_MOVE_TABLE DOES NOT PROVIDE CORRESPONDING LOAD OPTION "TEMPFILES PATH"
IC95655 3 WHEN USING ADMIN_MOVE_TABLE, THE STAGING AND TARGET TABLE IS NOTCLEANED DURING THE CANCEL OPERATION WHEN INIT PHASE FAILS.
IC97877 3 WHEN USING ADMIN_MOVE_TABLE WITH COPY_STATS OPTION ON SWAP PHASE, IT COULD FAILS WITH SQL2102N, REASON CODE 28.
Fix Pack 4   -    Parsing and SQL PL
IC97043 2 SQL20046N USING STORED PROCEDURES
IC95790 2 CALLING A SQL STORED PROCEDURE AFTER MIGRATION FAILS WITH EITHERAN SQL1224 OR SQL0471 ERROR IT MAY ALSO TRAP
IC97333 3 DYNAMIC STATEMENT NOT FOUND IN STATEMENT CACHE AND RECOMPILED UNNECESSARILY RESULTING IN POOR RUN TIME PERFORMANCE
IC96291 3 USER-DEFINED CONDITIONS IF DEFINED IN MODULES MIGHT NOT FUNCTIONCORRECTLY, IF DB CONTAINS 10000+ ENTRIES IN SYSIBM.SYSVARIABLES
Fix Pack 4   -    Platform Specific
IC98177 1 HANG AFTER LOG ARCHIVE
IC99076 1 DB2AIOTHR SEEMS TO STUCK IN THE SOLARIS KERNEL
IT01393 2 A HANG RELATED TO STMM MAY BE ENCOUNTERED SHOULD AN INTERNAL COUNTER TRACKING SHARED SORT HEAP PAGES BECOME NEGATIVE.
IC91295 2 POSSIBLE HIGH CPU USAGE OF FUNCTION STMMPCFINDSIMVAR UNDER VERY HIGH WORKLOAD
IT00726 2 AN ATTEMPT TO ATTACH LOCAL NODE BY DATA SERVER CLIENT MIGHT THROW SQL1032N.
IC94330 2 MEMBER FAILED TO START ON HOME HOST DUE TO SQL1677N ERROR
IC98699 2 INSTANCE ABEND IN DB2STMM WHEN EVALUATING SCALAR AGGREGATE OPERATORS.
IC98883 2 DB2 CACHES GROUP MEMBERSHIP OF LOCALSYSTEM (SYSTEM) UNTIL NEXT INSTANCE RECYCLING.
IT01182 2 SETTING DB2PATH MAY CAUSE FAILURE TO START THE INSTANCE
IC98332 2 CURRENT TIMEZONE SPECIAL REGISTER MAY GIVE WRONG RESULT ON SUN PLATFORM BEING ACCESSED CONCURRENTLY.
IC97733 2 DB2START RETURNS SQL6030N START OR STOP DATABASE MANAGER FAILED. REASON CODE "4".
IC94989 2 GETTING PASSWORD EXPIRED WHEN USING TRANSPARENT LDAP WITH KERBEROS
IC95654 2 SQL30082N RC=24 ERROR MAY OCCUR USING PAM_KRB5.SO WITH TRANSPARENT LDAP
IC98933 3 RUNSTATS COMMAND CAN POTENTIALLY HANG IF RUN WITH UTIL_IMPACT_PRIORITY CLAUSE.
IC97825 3 DB2OSCONF DOES NOT SHOW SEMUME IN HP-UX.
IC96987 3 SAP - REMOVE STMM PACKAGE CACHE CAP LIMIT FROM DB2_WORKLOAD=SAP
IC97748 3 DB2INSTDEF IS SET BY DEFAULT DURING INSTANCE CREATION EVEN IF NON-WINDOWS PLATFORMS.
IC94231 3 SQL1042C / ECF_FILE_DEVICE_UNAVAILABLE ERROR CONNECTING TO DATABASE WITH SERVER_ENCRYPT AUTHENTICATION
IC96756 3 MEMORY LEAK POSSIBLE ON WINDOWS IF A WINDOWS PERFORMANCE API FUNCTION RETURNS AN UNEXPECTED RETURN CODE
IC96666 3 LOAD FROM CURSOR MAY ACCUMULATE WINDOWS EVENT HANDLES OVER TIME
IC98002 3 INDEX CREATION ON A SMS TABLESPACE DUMPS FULL STACK IN DB2DIAG.LOG AS AN EVENT
IC95659 3 STMM ON 32-BIT INSTANCE PLATFORM MAY FAIL TO UPDATE PCKCACHESZ WHEN IT IS WORKING ON 64-BIT WINDOWS
IC97285 3 ON SOLARIS, ONCE DIO IS ENABLED THERE IS NO WAY DISABLE IT WITHIN DB2.
IC96872 3 IF THE DB2SYSC PROCESS DEPLETES THE PROCESS HEAP AN ATTEMPT TO ALLOCATE ADDITIONAL MEMORY MIGHT LEAD TO A PROCESS TRAP.
IC97875 3 CONTAINER RESIZE BEYOND 16 TB DOES NOT FAIL AND CAUSES UNEXPECTED RESULTS.
IC96875 3 IN A DPF, IF AGENTPRI IS CHANGED, DB2START GETS SQL1042C AND DB2INSTANCE CAN'T START.
Fix Pack 4   -    Problem Determination
IC98864 2 DB2TRC BUFFER ALLOCATION
IC98524 2 DB2PD -MEMBLOCK PID=<DB2SYSC PID> MAY FAIL WITH PDPROCGETMEMMAP RC = 1
IC97501 2 INSPECT UTILITY DOES NOT REPORT PAGES THAT HAVE A INCORRECT CHECK SUM
IC99774 2 DB2TOP GRANULARITY IN BACKGROUND MODE FOR DATABASE METRICS
IC99528 2 SEVERE WLMTABLEFUNCTIONMERGED MESSAGES AGAINST RUNNING OF PD_GET_DIAG_HIST TABLE FUNCTION
IC94545 2 IN SOME CASES CALLING 'USER-SPECIFIED PROFILE' FROM DB2SUPPORT MAY CAUSE SCRIPT TIME-OUT REGARDLESS OF THE SETTING OF 'TIMEOUT'.
IC96921 2 PD_GET_LOG_MSGS TABLE FUNCTION 'TIMESTAMP' PARAMETER ACTS AS IF ONLY NULL IS PASSED
IC97386 2 PD_GET_DIAG_HIST() TABLE FUNCTION WITH GIVEN TIMESTAMP PARAMETERS OR DB2DIAG TOOL WITH -H OR -T OPTION MAY HANG.
IC90716 2 IN SOME RARE CIRCUMSTANCES THE PD_GET_DIAG_HIST() TABLE FUNCTIONMAY HANG.
IC97756 2 OPTIMIZER DB2SUPPORT COLLECTION IS NOT SUCCESSFUL
IT00302 2 DB2SUPPORT WRONGLY ASSUMES SHARED PATH IF DB2DIAGPATH IS NOT SPLIT AND HAS THE SAME VALUE ON MULTIPLE NODES
IC95703 2 DB2PD -STACK ALL OR DB2PD -DUMP ALL MAY CRASH THE INSTANCE WITH SIGNAL 11.
IC96839 2 CALLING PD_GET_DIAG_HIST IN DB2 V10.1 FP3 ON PLATFORM WINDOWS RESULTS IN AN ERROR
IC98020 2 DB2DART CRASH IN MEMORY VALIDATION
IC99804 2 CRASH IN DB2TOP COLLECTOR MODE WHEN COMPRESSING THE SNAPSHOT DATA
IC98108 3 DB2PD -DBP NUMBER -EVERYTHING RETURNED "INVALID -DBP SUBOPTION. PROVIDE DATABASE PARTITION NUMBER."
IC99539 3 DB2TOP IN BACKGROUND REPLAY MODE IGNORES THE FIRST SNAPSHOT STREAM DATA
IC96862 3 DB2SUPPORT DOES NOT COLLECT DB2DIAG.LOG ON WINDOWS WHEN $M IS USED IN DIAGPATH
IC96592 3 ON WINDOWS, AN ADMIN MESSAGE MAY BE LOGGED IN DB2DIAG.LOG AND WINDOWS EVENT LOG WITH DIFFERENT LEVEL
IC96246 3 A LOCK ON THE NOTIFY LOG OR DB2DIAG.LOG CAN MAKE THE ENGINE SO SLOW THAT IT WOULD LOOK LIKE A HANG
IC99191 3 DB2CAEM FAILS IF THE SQL INPUT CONTAINS A COMMENT "--" WHICH IS NOT AT THE START OF A LINE
IC96689 3 A LOCK ON THE NOTIFY LOG OR DB2DIAG.LOG CAN MAKE THE ENGINE SO SLOW THAT IT WOULD LOOK LIKE A HANG
IC96701 3 DB2PD -REORG ON HADR STANDY TRAPS WHEN THE TABLE NAME OR SCHEMA HAS NOT BEEN ALLOCATED WITHIN THE TCB
Fix Pack 4   -    Process Model
IC95792 1 DB2HAICU INCORRECTLY REPORTS AN IP ADDRESS AS ALIVE WHEN IT IS NOT.
IC99747 1 DB2 STORED PROCEDURES ARE UNABLE TO LOAD THE GSKIT SHIPPED WITH DB2
IC98312 2 IN LOW OR NO MEMORY CONDITIONS DB2 MAY TRAP IN SQLRR_SQL_REQUEST_PRE
IC99932 2 DATABASE REMAINS IN QUIESCE STATE AFTER INSTANCE UNQUIESCED
IC99903 2 DB2IUPGRADE FAILURE WHEN DB2NODES.CFG CONTAINS VIRTUAL IP ADDRESSES
IC97822 2 DB2 MAY TRAP IN SQLECLEANUPFEDDAEMONANCHOR DURING MULTIPLE LOGICAL NODES STARTUP
IC94868 2 COORDINATOR AGENT MAY HANG WITH PENDING REMOTE REQUEST STATUS DUE TO DISCARDED BUFFER.
IC92291 2 RE-CREATING A PREVIOUSLY DROPPED DATABASE WITH DIFFERENT PATH MAY FAIL WITH SQL1031N
IC98289 2 INSTANCE MAY CRASH IN SQLOCRASHONCRITICALMEMORYVALIDATIONFAILURE
IT00907 2 SQL1052 WHEN DROPPING A DATABASE IN DPF ENVIRONMENT USING RELATIVE PATHS OR SOFTLINKS
IC97832 2 THE DB2 REGISTRY VARIABLE DB2_MAX_THREADS_PER_FMP MAY NOT WORK IN A FEDERATION ENVIRONMENT.
IC98913 2 TRAP OR HANG WHEN LDAP DIRECTORY ENTRIES FOR A DB2 DATABASE ARE INCONSISTENT.
IC97518 2 DB2 INTERMITTENTLY CRASHES WITH A MEMORY CORRUPTION WHEN CALLINGSQLERGETFMPIPC
IC99231 2 DEADLATCH BETWEEN INSTANCE QUIESCE AND HADR START DUE TO LATCHING ORDER
IC96702 2 UPDATING LOGARCHMETH1 DATABASE CONFIGURATION PARAMETER WHILE A DATABASE IS BEING ACTIVATED CAN CAUSE DB2 TO HANG
IT01368 2 TRAPS AND/OR CRASHES IN DPF DURING QUERY ACTIVITY AGAINST A DB THAT WAS PREVIOUSLY CREATED WITH A REDIRECTED RESTORE
IT00763 3 INCORRECT WARNING SQL1363W RAISED WHEN UPDATING A DB CFG PARAMETER ON INACTIVE DATABASE
IT00385 3 DROP DATABASE FAILS WITH: SQL0969N THERE IS NO MESSAGE TEXT CORRESPONDING TO SQL ERROR -2029060079"
IC95142 3 UPGRADE FROM DOWNLEVEL PERMITS OTHER CONNECTION FROM SAME USER PERFORMING UPGRADE TO CONNECT AND CRASH THE SERVER.
IC98511 3 MAKE CERTAIN SQLERINVOKEFENCEDROUTINE AND SQLERRETURNFMPTOPOOL MESSAGES IN DB2DIAG.LOG WARNING INSTEAD OF ERROR OR SEVERE
IC96909 3 IT IS POSSIBLE TO CATALOG A DATABASE WITHOUT A DB NAME OR ALIAS WHEN CREATING AN ODBC DSN IN MICROSOFT ODBC ADMINISTRATOR
Fix Pack 4   -    Query Compiler Optimizer
IC99629 1 PD CORRUPTION ON TABLE AFTER ALTER TABLE ADD OR REMOVE A COLUMN WHEN RTS IS ENABLED
IC99818 1 SQL STATEMENT WITH UNCORRELATED SUBQUERY PREDICATE MIGHT RETURN INCORRECT RESULTS WHEN INTRA_PARALLEL IS ENABLED
IC98311 1 DB2 CAN TRAP WHEN COMPILING A SQL STATEMENT THAT FITS THE CRITERIA FOR ZIGZAG JOIN
IT00482 2 DB2 OPTIMIZER CAN CHOOSE A NON-OPTIMAL BLOCK INDEX TO ACCESS MDCTABLE WHEN THE BLOCK INDEXES HAVE ONLY 1 LEVEL
IC96375 2 DB2 INSTANCE MAY TRAP WITH SIGNAL#11 WITH FUNCTION SQLNX_EXP_DUMP_DIAG_CACHE.
IC98179 2 WHEN INTRA_PARALLEL ENABLED, AN SQL STATEMENT MIGHT FAIL WITH SQL0901N IN SQLNO_SMP_CREATE_PGBY
IC96999 2 DB2 NOT GENERATING TBSCAN ON INNER OF NLJN WHEN OUTER CAN HAVE ONLY 1 ROW
IC99319 2 SQL STATEMENT WITH ORDERED COLUMN GROUP OR PREDICATES MIGHT RETURN INCORRECT RESULT SET WHEN JUMP SCAN USED
IC97297 2 OPTIMIZER COMPUTES INCORRECT CARDINALITY ESTIMATE IN PRESENCE OFSTATISTICAL VIEW WITH A PREDICATE THAT HAS AN EXPRESSION
IC98822 2 RUNSTATS PROFILE DOESN'T ALLOW TO EXCLUDE COLUMNS FROM DISTRIBUTION STATISTICS COLLECTION (NUM_FREQVALUES OR NUM_QUANTILES = 0)
IC98761 2 COMPILING A SQL STATEMENT CAN RETURN SQL0901N WITH REASON "TOO MANY COLUMNS OR RECORD LENGTH EXCEEDED."
JR49140 2 FED: ROWNUM OR FETCH FIRST N ROW CLAUSE COULD NOT BE PUSHED DOWN
IC97823 2 RUNNING DB2ADVIS TO RECOMMEND DPF PARTITIONING IN ORACLE COMPATIBILITY MODE CAN CAUSE DB2 TO TRAP
IC99408 2 THE SQL0437W MIGHT BE INDUCED BY RUNSTATS RESULTING IN INCORRECTCOLCARD VALUE
IC99521 2 DB2ADVIS MAY HANG ON DATABASE THAT ENABLES DATE AS TIMESTAMP (0)SUPPORT
IC97570 2 DB2 OPTIMIZER MAY CHOOSE TO DEFER PROCESSING DISTINCT CLAUSE OF A UNION-BRANCH
IC98806 2 QUERY MAY PERFORM BAD WHEN CONTAINS OR SCORE FUNCTIONS ARE USED WITH VARIABLES IN THE SEARCH STRING AND REOPT ONCE IS SPECIFIED
JR48968 2 PERFORMANCE COULD BE POOR WHEN A SMALL NICKNAME JOINS A LARGE NICKNAME JOIN RESULT
IC98769 2 DB2 OPTIMIZER MAY USE FREQUENCY VALCOUNT IN SYSSTAT.COLDIST INCORRECTLY AND GIVE SUB-OPTIMIAL ACCESS PLAN.
IC98320 2 DB2 MIGHT TRAP WHILE COMPILING A SQL STATEMENT CONSISTING OF MULTIPLE TABLES JOINED ON THE PARTITION BY RANGE COLUMNS
IC99102 2 AN SQL STATEMENT JOINING A TABLE TO A VALUES CLAUSE MIGHT RESULTIN SUBOPTIMAL PERFORMANCE
IC94959 2 ATM FAILED TO REORG SOME INDEXES WHICH EXCEEDED F4 AND F5 UNDER DB2_WORKLOAD=SAP
JR49139 2 FED: HANG, CRASH OR -901 WITH MEMORY DOUBLE FREE MESSAGE COULD OCCUR WHEN FUNCTION TEMPLATE IS USED
IC97715 2 DB2 MIGHT TRAP WHILE COMPILING A SQL STATEMENT THAT IS ELIGIBLE FOR ZIGZAG JOIN
IC96894 2 DB2 MIGHT TRAP WHILE COMPILING A SQL STATEMENT WITH A DISTINCT CLAUSE WHEN INTRA-PARTITION PARALLELISM IS ENABLED
IC99860 2 POSSIBLE WRONG RESULTS WHEN INDEX JUMP SCANS ARE USED IN REFERENTIAL INTEGRITY CHECKING
IC97984 2 OPTIMIZER MIGHT FAVOUR HSJOIN OVER AN ORDERED NLJOIN
IC94258 2 DELETE QUERY FAILS WITH -901 ERROR "EMPTY PLAN LIST DETECTED!"
IC97505 2 DB2ACD PROCESS CAN ABEND WHEN IT PROCESSES FEDERATED TABLES FOR AUTOMATIC RUNSTATS.
IC97044 2 DB2 MIGHT ABEND WHILE COMPILING SQL QUERY.
IC95716 3 SQL0901 REASON "ORDER COLS REMOVED FROM SORT OUTPUT COLS." WITH DB2_WORKLOAD=PUREDATA_OLAP
IC97808 3 QUERIES INVOLVING ZIGZAG JOIN MAY GET UNEXPECTED SQL0811N ERROR
IC96826 3 DB2 OPTIMIZER MIGHT NOT CHOOSE A ONE-FETCH GROUP BY WHEN CARDINALITY IS UNDERESTIMATED
IC98550 3 COLLECTING INDEX-ONLY STATISTICS CAN INCORRECTLY UPDATE SYSCAT.COLUMNS.NQUANTILES AND SYSCAT.COLUMNS.NMOSTFREQ TO -1.
Fix Pack 4   -    Query Compiler QGM
IC97737 1 SECURITY: QUERY WITH OLAP SPECIFICATION CAUSES DB2 SERVER TO SHUTDOWN DATABASE. (CVE-2013-6717)
IT00386 1 SQL QUERY CONTAINS NOT EXISTS SUBQUERY AND NODENUMBER PREDICATE MIGHT PRODUCE AN INCORRECT RESULT
IC96725 1 CASE EXPRESSION PREDICATES MIGHT BE INCORRECTLY REWRITTEN IN DB2V10.1 FIXPACK 3
IC98176 1 OUTER JOIN QUERIES WITH COMPLEX OPERANDS MAY EXPERIENCE POOR PERFORMANCE
IC99125 1 IMPROVE QUERY PERFORMANCE WHEN QUERY CONTAINS CARTESIAN JOIN OVER SELECT DISTINCT FROM ALIAS
IC98902 1 DB2 MIGHT PRODUCE INCORRECT RESULTS FOR QUERY WITH MULTIPLE QUANTIFIED SUBQUERIES IN OR PREDICATE
IT01197 2 QUERY MIGHT HAVE OR PREDICATE WRONGLY REMOVED RESULTING IN EXTRAROWS IN THE RESULTS
IC96963 2 SQL20208N RC=4 WHEN DECLARING A GLOBAL TEMPORARY TABLE BASED ON MULTIPLE TABLES WITH DIFFERENT SECURITY POLICIES
IC90465 2 PERFORMANCE DEGRADATION MIGHT BE NOTICED WITH NOT EXISTS SUBQUERY WITH MULTIPLE TABLES.
IT00414 2 DB2 MIGHT RETURN EXTRA ROWS WHEN AN EQUAL JOIN PREDICATE ON COLUMNS INVOLVES NON-CAST EXPRESSIONS.
IT00617 2 QUERY CONTAINING CONSTANT BEFORE OLAP FUNCTION MAY FAIL WITH -901: UNEXPECTED NULL ZVALUE OR ABEND WITH SEGV IN SQLRISET
IC97582 2 SOME COMPILER REGISTRY VARIABLES MAY NOT TAKE EFFECT IMMEDIATELYWHEN UPDATED WITH THE IMMEDIATE OPTION
IC99842 2 SQLSTATE 01503 WARNING RETURNED AFTER FETCH TO ANCHORED ROW TYPEGLOBAL VARIABLE
IC98336 2 INTERNAL ERROR SQL0901N WITH NOT IN PREDICATE
IC98084 2 DATABASE MAY CRASH WHEN A REPLICATED MQT IS ENFORCED
IC98953 2 COMPILING A QUERY CAN ABEND WHEN A TABLE IN THE QUERY HAS CGS, AND IF RTS UPDATES THE TABLE'S STATISTICS DURING COMPILATION.
IC99415 2 DB2 MIGHT PRODUCE INCORRECT RESULTS WHEN EXECUTING QUERY WITH MULTIPLE "IN" LIST PREDICATES ON SAME COLUMN
IC99601 2 DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING NOT IN QUERY WITH CORRELATED SUBSELECT
IC94256 2 CREATE FUCNTION FAILS WITH SQL0109 WHEN QUERY INCLUDES "WITH UR"
IC98129 2 POSSIBLE INCORRECT RESULT ON MULTIPLE OUTER JOINS AND A COMBINATION OF EQUALITY JOIN PREDICATES AND LOCAL PREDICATES
IC98379 2 BUILT-IN STRING FUNCTIONS MAY RETURN AN INCORRECT RESULT OR FAILWITH SQL0901N WHEN CODEUNITS16 OR CODEUNITS32 IS SPECIFIED
IC97001 2 MQT NOT CONSIDERED FOR REWRITE MATCHING IN INSENSITIVE SCROLLABLE CURSOR QUERIES
IC99461 2 ADJUST FILTER FACTOR FOR RCAC'S VERIFY_* FUNCTIONS LIKE VERIFY_ROLE_FOR_USER()
JR48099 2 QUERIES CONTAINING FUNCTION TEMPLATE IN FEDERATED ENVIRONMENT MAY RETURN SQL0142N
IC98772 2 QUERIES USING THE XMLSERIALIZE FUNCTION MAY NOT BENEFIT FROM THESTATEMENT CONCENTRATOR
IC97862 2 ERROR CODE -901 WHILE EXECUTING A SELECT STATEMENT - MESSAGE "COLUMN NUMBER OUT OF RANGE "
IC98694 2 A VALUE ASSIGNMENT FROM ARRAY OF ROW DATA TYPE TO ROW DATA TYPE MIGHT CAUSE AN INSTANCE CRASH.
IC99901 2 SELECT INTO GLOBAL VARIABLE WITH 'FOR UPDATE' SPECIFIED RETURNS SQL0151N ERROR
IC97072 2 DB2 MIGHT PRODUCE INCORRECT RESULTS FOR QUERIES CONTAINING UNIONALL AND CTE OR VIEWS
IC98655 2 SUBQUERIES REFERENCING AN ALWAYS FALSE PREDICATE MIGHT NOTICE BAD PERFORMANCE
IC94727 2 USING ADMIN_MOVE_TABLE ON TABLE WITH GENERATED COLUMN REFERENCEDBY MDC KEY RESULTS IN SQL20209N
IC99490 2 DB2 MIGHT PRODUCE SQL0551N WHEN CREATING A COMPILED ROUTINE OR TRIGGER REFERENCING DGTT
IC97491 2 DATE PARAMETER MARKER IS NOT CONVERTED TO TIMESTAMP(0) IN A DATEAS TIMESTAMP(0) ENABLED DATABASE WITH DEFERRED PREPARE ENABLED
IC99128 2 DB2 MAY TRAP IF AGGREGATE FUNCTION NAME IS USED AS AN ARGUMENT TO NESTED PROCEDURE CALL STATEMENT
IC96677 2 SET INTEGRITY IMMEDIATE UNCHECKED FAILED WITH SQL20209N IF THE PARTITIONING KEY CONTAINS GENERATED COLUMN
IC98170 2 MERGE COMMAND WITH INSERT IN XML COLUMN RETURN ERROR SQL16084N
IC96698 2 -901 WITH "NO COLUMN INFORMATION FOUND IN THE PACKED DESCRIPTOR" ON CREATE PROCEDURE
IC99862 2 SQL0901N REASON "SQLNQ_PSM_SEM_ACT" FROM PL/SQL ROUTINE WITH FOR-LOOP CURSOR OVER A JOIN OF MULTIPLE COMMON TABLE EXPRESSIONS
IC96822 2 QUERY WITH TABLES FUNCTIONS AND EXISTENTIAL SUBQUERY MIGHT PRODUCE SQL0901N
IC94039 2 SQL20454N RC =2 WHEN OUTER JOIN OPERATOR "(+)" IS USED IN A CURSOR WHICH IS DECLARED IN A PACKAGE
IC96050 2 A QUERY MAY HANG WHEN IT CONTAINS CONNECT BY AND LEFT OUTER JOIN
IC96681 2 SQL FUNCTION CONTAINING XML ARGUMENTS MIGHT CAUSE DB ABEND
IC95625 2 DB2 MAY ABEND WHILE COMPILING QUERY WITH ALWAYS FALSE PREDICATE AT LEFT OUTER JOIN ON CLAUSE
IC94331 2 CREATE FUNCTION FAILS WITH SQL0109 WHEN QUERY INCLUDES "WITH UR"
IT01100 2 CHAR(' ',0) RETURNS EMPTY STRING INSTEAD OF NULL IN VARCHAR2 ENABLED DATABASE.
IC96437 2 MERGE STATEMENT RETURNS SQL0901N ("COLUMN NUMBER OUT OF RANGE")
IC96268 2 IN A FEDERATION SYSTEM, AN UPDATE/DELETE STATEMENT DOES NOT APPLY THE PREDICATES CONTAINING FUNCTION TEMPLATES
IC97915 2 QUERY MAY RETURN INCORRECT RESULTS WHEN IT CONTAINS A SUB-SELECTWITH CORRELATION AND A FETCH FIRST N ROWS CLAUSE
IC96299 2 MQT OR STATISTICAL VIEW MAY BE NOT MATCHED OR IMPROPERLY MATCHED
IT00514 2 DB2 CRASHES ON RUNSTATS WITH SQLDINDEXSTATS 'NO COLSTAT STRUCTURE FOUND FOR INDEX WITH ITOKEN' IN DB2DIAG.LOG
IC99096 2 QUERY PERFORMANCE MAY BE POOR IN A FEDERATED DPF ENVIRONMENT FOR QUERIES INVOLVING THE LATERAL KEYWORD IN THE STATEMENT TEXT
IT01073 2 INCORRECT RESULTS MIGHT BE PRODUCED WITH PREDICATES INVOLVING NULL CONSTANTS
IC94117 2 UPDATE A NICKNAME WITH MORE THAN 1012 COLUMNS MAY RESULT IN SQL0901N
IC87186 3 QUERY CONTAINING DUPLICATE BRANCHES MIGHT CAUSE PERFORMANCE DEGRADATION
IC89970 3 SQL0901N WHEN INSERTING INTO TABLE WITH A TRIGGER CALLING MQ UDF
IC89047 3 GET DIAGNOSTICS RETURNS SQL0401N WHEN ROW_COUNT VARIABLE IS DECLARED AS DECIMAL
IC96295 3 QUERY COMPILATION SHOULD RETURN SQL0418N IF IT HAS UNTYPED GROUPING SETS COLUMN
IC90466 3 UDI QUERY MIGHT PRODUCE SQL0901N WHEN EXTENDED INDICATOR OPTION IS ON
IC97348 3 IN A RARE SCENARIO, REPLICATED MQTS ARE NOT EXPLOITED TO IMPROVEPERFORMANCE OF QUERIES
IC96707 3 SQL0901N WHEN INSERTING INTO TABLE WITH A TRIGGER CALLING MQ UDF
IC97757 3 QUERY PERFORMANCE ISSUE DUE TO STATISTICS PREVENTING PUSHDOWN OFJOINS
IC96967 3 SQL ROUTINES THAT USE THE SAME VARIABLE FOR BOTH THE IN AND OUT PARAMETERS MAY RETURN NULL
IC96290 3 SQL0153N INSTEAD OF SQL0783N ERROR IS RETURNED , IF DECLARE CURSOR OF FOR STATEMENT HAS UNNAMED COLUMN.
Fix Pack 4   -    Relational Data Services
IC98741 1 IN DB2 10.1, BURST OF DIA8039C/ SQLP_PROTO MAY BE SEEN AFTER DEADLOCK, WHERE AN ARRAY INSERT IS PART OF THE DEADLOCK CYCLE
IC96700 2 DB2 TRAPS WHEN DB2EXPLN TRYS TO DESCRIBE THE ACCESS PLAN OF A SQL THAT DOESN'T EXIST WITH "-CACHE" OPTION
IT01399 2 DATABASE IS MARKED BAD DUE TO "NO ACTIVE SAVE POINT" ERROR FOR MISHANDLING SAVE POINT WHEN THERE IS AN INTERRUPT.
IC97283 2 THE REBIND COMMAND FAILED WITH SQL0901N ERROR.
IC98072 2 FALSE SQL0901N WITHIN QUERY COMPILER
IC96821 2 QUERIES USING ORDER BY CLAUSE MAY FAIL WITH SQL1585N ON THE HADRSTANDBY SERVER(READS ON STANDBY ENABLED)
IC96699 2 INSTANCE MIGHT TRAP WHILE EXECUTING PL/SQL ANONYMOUS BLOCK STATEMENT IF ADDRESS CONNECTION IS USED FOR WORKLOAD ASSIGNMENT
IC99772 2 TRAILING SPACES ON PACKAGE IDENTIFIERS ARE NOT IGNORED, WHICH MIGHT LEAD TO -901 ERROR: SECTION LENGTH MISMATCH
IC98196 2 ANONYMOUS BLOCK FAILS WITH SQL0551N AFTER 3 OR MORE HADR TAKEOVER.
IC95653 2 DB2 TRAPS WHEN DB2EXPLN TRYS TO DESCRIBE THE ACCESS PLAN OF A SQL THAT DOESN'T EXIST WITH "-CACHE" OPTION
IC97714 3 MONITOR ROUTINE ALLOCATIONS FAIL WITH SQL0954
Fix Pack 4   -    Security
IC99475 1 SECURITY: IBM DB2 is impacted by multiple TLS/SSL security vulnerabilities (CVE-2013-6747, CVE-2014-0963)
IC99480 1 SECURITY: VULNERABILITY IN STORED PROCEDURE INFRASTRUCTURE CAN ALLOW ESCALATION OF PRIVILEGE TO ADMINISTRATOR (CVE-2013-6744).
IT00686 1 SECURITY: ELEVATED PRIVILEGES WITH DB2 EXECUTABLES (CVE-2014-0907)
IT00779 1 DB2START FAILS WITH SQL1042C ERROR OR CONNECTION FROM DS DRIVER PACKAGE FAILS AFTER AN UPGRADE FROM V9.7 FP9 OR HIGHER
IC98130 2 PARAMETER MARKERS CAN UNEXPECTEDLY BE LOGGED WHEN AUDITING A TABLE
IC95073 2 NEW VALUE JCC_ENFORCE_SECMEC FOR DB2 REGISTRY VARIABLE DB2AUTH TO REJECT NON-ENCRYPTED USERNAMES AND PASSWORDS FROM JCC CLIENT
IC96690 2 NEW VALUE JCC_ENFORCE_SECMEC FOR DB2 REGISTRY VARIABLE DB2AUTH TO REJECT NON-ENCRYPTED USERNAMES AND PASSWORDS FROM JCC CLIENT
IC96146 2 WHEN DOING SWITCH USER IN A TRUSTED CONNECTION, THE CLIENT OMITSTO SEND USER REGISTRY NAME (USRREGNM) TO THE DATABASE SERVER
IC97236 3 IN DB2 GATEWAY, WHEN REMOTE NODE IS CATALOGED WITH SSL ENABLED, MEMORY FOOTPRINT PER CONNECTION IS IMPACTED BY KEY DATABASE SIZE
IC98578 3 DB2AUDIT ERRORS FROM DB2AUD PROCESS WHEN USING KRB_SERVER_ENCRYPT
Fix Pack 4   -    XML
IC97664 1 PRIVATE MEMORY LEAK IN DB2SYSC TRIGGERED BY EXECUTING XML QUERIES
IC97450 2 CRASH IN XMLVSTREAMINGNORMSPACE ON LINUX/PPC64
IT00248 2 QUERIES WITH XMLTABLE FUNCTIONS MIGHT RETURN INCORRECT RESULTS WHEN MORE THAN ONE EQUAL PREDICATE IS USED IN WHERE CLAUSE
IC95656 3 DECOMPOSE XML WILL FAIL TO RETURN AN SQLSTATE IN CASE OF UNSUCCESSFUL DECOMPOSITION.
Fix Pack 4   -    pureScale Services
IC96691 1 IN A TSA AUTOMATED HADR ENVIRONMENT, AN AUTOMATED HADR FAILOVER OCCURS IMMEDIATELY AFTER THE TAKEOVER HADR COMMAND IS RUN
IC99930 1 DATABASE RESTORE FAILS ON PURESCALE CLUSTER DUE TO INSUFFICIENT SCA MEMORY ON THE CF (SQLE_RC_INSUFFICIENT_CA_MEMORY_FOR_SCA)
IC98722 2 DB2 WILL WAIT FOR MORE THAN 8 HOURS FOR TSA TO CHANGE RESOURCE LOCK STATE APPEARING AS A HANG
IC97631 2 MOUNTV97_MONITOR.KSH TAKES ACTION WHEN TSA IS IN MANUAL MODE
IC97667 2 MAKE HADRVXX_MONITOR.KSH SCRIPT MORE ROBUST TO REDUCE FALSE NEGATIVES
IC98552 2 WHEN RUNNING DB2GCF AS ROOT TO STOP A PARTITION THE COMMAND EXITS WITH RC=3 AND ERROR MESSAGE
IT01472 2 THE DB2UDB_SVC_PROBE.KSH SCRIPT USED FOR HA WITH SUN CLUSTER INCORRECTLY RETURNS WITH RC=1 CAUSING AN INSTANCE RESTART
IC97145 2 ENHANCE "DB2CLUSTER -CFS -ENTER -MAINTENANCE" TO ENSURE GPFS IS BACK TO NORMAL AFTER "-EXIT -MAINTENANCE"
IC96663 2 ENHANCE MOUNTV97_MONITOR.KSH TO HANDLE TEMPORARY UNEXPECTED OUTPUT OF LSLV ON AIX PLATFORM
IC99208 2 THE DB2V10_STOP.KSH SCRIPT DOES NOT KILL THE DB2SYSC PROCESS AS EXPECTED IN THE CASE WHERE THE HOME DIRECTORY IS NOT ACCESSIBLE.
IC99272 2 DB2HAICU FAILS TO CREATE A MOUNT RESOURCE FOR AN EXT4 BASED MOUNT POINT
IC95661 2 IN A LARGE DPF/HA CLUSTER, IF ALL RESOURCES ARE STARTED AT ONCE IT IS POSSIBLE THAT CERTAIN RESOURCES ARE NOT BROUGHT ONLINE
IC98309 2 IN A TSA/HADR ENVIRONMENT, AUTOMATIC REINTEGRATION OF THE HADR STANDBY DATABASE FAILS
IC99792 3 VARIOUS DB2HAICU OPERATIONS FAILING IN A CONFIGURATION CONTAINING 50 OR MORE HIGHLY AVAILABLE HADR DATABASES
IC96697 3 DURING RESTART OF THE SERVER, DB2FMCD PROCESS CAN REPORT MESSAGETHERE IS ALREADY A COPY OF FAULT MONITOR DAEMON PROCESS RUNNING
IC98813 3 DB2V10_START.KSH SCRIPT HANGS IN CASE OF REMOTELY CATALOGED DATABASES
IC94301 3 PURESCALE FAILS TO START MEMBER WHERE ONE OR MORE OF ITS ASSOCIATED GPFS FILESYSTEMS IS SET TO AUTOMOUNT

DB2 Version 10.1 Fix Pack 3a
APAR Sev. Abstract
IC97737 1 SECURITY: QUERY WITH OLAP SPECIFICATION CAUSES DB2 SERVER TO SHUTDOWN DATABASE. (CVE-2013-6717)
IC97471 1 SECURITY: NULL POINTER DEREFERENCE IN DB2'S XSLT PARSING ENGINE(CVE-2013-5466).
IC99480 1 SECURITY: VULNERABILITY IN STORED PROCEDURE INFRASTRUCTURE CAN ALLOW ESCALATION OF PRIVILEGE TO ADMINISTRATOR (CVE-2013-6744)
IC99475 1 SECURITY: IBM DB2 IS IMPACTED BY MULTIPLE TLS/SSL SECURITY VULNERABILITIES (CVE-2013-6747, CVE-2014-0963)
IT00686 1 SECURITY: ELEVATED PRIVILEGES WITH DB2 EXECUTABLES (CVE-2014-0907)

DB2 Version 10.1 Fix Pack 3
APAR Sev. Abstract
IC92832 1 FAILED BACKUP, TABLESPACES ARE MARKED AS UNMODIFIED, DATA MIGHT NOT BE INCLUDED IN SUBSEQUENT INCREMENTAL BACKUPS IMAGES
Fix Pack 3   -    Abstract Data Types and Spatial Extender
IC92698 2 SPATIAL UPGRADE FROM V9.5 TO V9.7 FAILS
Fix Pack 3   -    Administration Server
IC91732 2 DATABASE ADMINISTRATION SERVER, DAS, MAY CRASH
Fix Pack 3   -    Administration Tools
IC94074 2 DB2ATS MAY BE REMAINED, IF DBMS_JOB.CHANGE WAS EXECUTED.
IC89718 2 DB2LOOK GENERATES DDL FOR DMS TABLESPACE WITH MAXSIZE ROUNDED DOWN.
IC89707 2 IN AN EEE MULTI-PARITION ENVIROMENT, THE TEMP FILE "DB2LOOK_DUMPFILE" DOESN'T GET DELETED AFTER EXECUTION OF DB2LOOK COMMAND
IC92760 3 'PARAMETER STYLE GENERAL WITH NULLS' CLAUSE IS EXTRACTED WRONGLYBY DB2LOOK
IC91755 3 HMONSQLCONNECT, PROBE:100 ERROR WAS OCCURRED.
IC87047 3 DB2LOOK DOES NOT WRAP THE SOURCE FUNCTIONS WITH QUOTATION MARKS WHEN GENERATES STATEMENTS FOR SOURCED FUNCTIONS
IC87086 3 DB2LOOK GENERATES INCORRECT IDENTITY COLUMN RESTART VALUE FOR ALTER TABLE DDL
IC92764 3 THE GRANT COMMAND FOR THE PROCEDURE IS NOT COLLECTED WHEN WE ISSUE THE DB2LOOK COMMAND.
IC96282 3 THE GRANT COMMAND FOR THE PROCEDURE IS NOT COLLECTED WHEN WE ISSUE THE DB2LOOK COMMAND.
IC92763 3 THE GRANT COMMAND FOR THE PROCEDURE IS NOT COLLECTED WHEN WE ISSUE THE DB2LOOK COMMAND.
IC92759 3 'PARAMETER STYLE GENERAL WITH NULLS' CLAUSE IS EXTRACTED WRONGLYBY DB2LOOK
IC91746 3 "INTERNAL HEALTH MONITOR ERROR " ERRORS DUMPED IN THE DB2DIAG.LOG FOR "DB2.MAX_SORT_PRIVMEM_UTIL" HEALTH INDICATOR
Fix Pack 3   -    Buffer Pool Services
IC91607 1 TRAP IN SQLBFINDPAGEINBPORSIM FOLLOWING FAILED BUFFER POOL REDUCE
IC93806 1 LOG FILE CORRUPTION AND POSSIBLE PANIC WHILE DROPPING JUST THE GLOBAL INDEX FROM A RANGE PARTITIONED TABLE.
IC91676 2 SET WRITE SUSPEND FAILS WITH SQL1550N RC 5 DUE TO TABLE SPACE INBACKUP PENDING OR OFFLINE STATE
IC93086 2 SET WRITE SUSPEND CONSISTENTLY FAILS WITH SQL1550N RC=5 WHEN THE BUFFERPOOL IS STMM ENABLED.
IC91221 2 CONTENTION DURING CONCURRENT LOADS CAUSED BY UNNECESSARY SMP PAGE SEARCHES
IC94721 2 PREFETCHER FAILURES CAUSED BY PREADV64 PROBLEMS ON 32 BIT LINUX DISTRIBUTIONS
IC92599 2 PRIVATE MEMORY LEAK ON THE DB2 SERVER BY THE DB2PFCHR THREAD
IC93301 2 SORTS FROM SMALL INDEX BUILDS OVER-RESERVE SORT MEMORY, STMM MAYUNNECESSARILY INCREASE SORT TUNING
IC92253 2 PAGE PREFETCH REQUEST MIGHT FAIL WITH ERROR EFBIG "FILE TOO LARGE"
IC89738 2 SQL0901 FOUND IN DB2DIAG.LOG INDICATING "BAD ALLOCATION IN TABLESPACE" FROM "SQLBMOVEHIGHESTEXTENT"
IC89555 2 BACKUP OF DATABASE UPGRADED FROM PREVIOUS RELEASE FAILS WITH SQL1224N IN SHARED DATA CONFIGURATION
IC90443 2 SHORTAGE OF DATABASE HEAP MEMORY RESULTS IN INSTANCE ABEND IN SQLB_TPL::SQLBTPLITERATOR::GETCURRENTPAGE
IC90146 2 DATABASE ROLLFORWARD FAILS DURING REPLAY OF A CLASSIC REORG IF THE REQUIRED SYSTEM TEMPSPACE IS IN RF PENDING
IC91323 2 TURNING OFF AUTO-RESIZE WHILE THE SAME TABLE SPACE IS BEING EXTENDED MAY RESULT IN UNREPLAYABLE LOG RECORD SEQUENCE
IC96385 2 DB2 CREATE TABLESPACE COMMAND CAN FAIL WITH SQL0289N WHEN FILE SYSTEM SIZE EXCEEDS 16 TB
IC92805 2 FIX EMP CHAIN WALKING CODE IN INCREMENTAL BACKUP CODE PATH
IC94033 2 ROLLFORWARD FOLLOWING RESTORE FROM ONLINE BACKUP IMAGE FAILS WITH BAD PAGE AND SQL1271W IN DB2 PURESCALE ENVIRONMENT
IC90557 2 STMM BUFFERPOOL MINIMUM NORMAL PAGE AREA AND CONFIGURED BLOCK PAGE AREA ARE NOT MAINTAINED ON ACTIVATION WITH SCALE BACK
IC92661 3 GETTING SQL1763N WHEN CREATING A TABLESPACE WITH NO FILE SYSTEM CACHING OPTION ON A ZLINUX ENV
IC91790 3 SPECIFYING SHARED CONTAINER PATH DURING CREATION OF DMS TABLE SPACE IN PARTITIONED ENVIRONMENT MAY CAUSE INSTANCE ABEND
IC91762 3 PRINT ADM12512W WARNING INTO ADMINISTRATION LOG FILE WHENEVER A TABLESPACE IS NO LONGER MAINTAINED BY LOG REPLAY ON HADR STANDBY
IC91366 3 DB2RELOCATEDB CAN FAIL WITH DBT1015N WHEN CHANGING STORAGE_PATH
IC91761 4 "FODC IS IN PROGRESS" STATE IS NOT TURNED OFF AFTER DATA CAPTUREIN CERTAIN SITUATIONS
IC88781 4 SQL0083C WHEN QUERYING TABLE SPACE CONTAINERS
Fix Pack 3   -    Build Team
IC89765 2 UNDEFINED SYMBOL SQLHARESOURCEMODELRECREATE WITHIN LIBDB2O.SO
IC92566 2 DB2 INSTALLATION MAY HIT JVMJ9VM015W INITIALIZATION ERROR FOR LIBRARY JCLSE7B_26
IC92067 3 A 32-BIT CLI APPLICATION RUNNING WITH DB2 64-BIT ON AIX FAILS WITH ILLEGAL INSTRUCTION ERROR
Fix Pack 3   -    Client Interfaces
IC94163 1 IN SOME CASES SQLGETDIAGFIELDW FUNCTION WILL TRUNCATE THE DIAGNOSTIC MESSAGE RETURNED.
IC93122 1 CRASH CAN HAPPEN IN SQLFREECONNECT2 WHEN DBALIAS IS GIVEN WHILE CONNECTING.
IC91777 1 .NET APPLICATION MAY HANG AFTER RECEIVING COMMUNICATION ERROR
IC90602 1 FORMATTING DB2TRC WITH -CLI OPTION MAY TERMINATE ABNORMALLY
IC95642 2 CLI0106E ERROR OCCURS DUE TO PHYSICAL NETWORK TIMEOUT BY LONG IDLE TIME
IC93375 2 TYPEDEF IS NOT WORKING AS EXPECTED WHEN TWO OR MORE TYPEDEF STRUCTURES WITH SIMILAR MEMBER NAME EXIST.
IC89698 2 A HOST STRUCTURE DECLARED IN SQL DECLARE SECTION GENERATES ERRORS DEPENDING ON A NAME OR A LOCATION.
IC90779 2 .NET DB2BULKCOPY - CLI0125E
IC91774 2 DB2CLI VALIDATE IS GIVING IMPROPER ERROR MESSAGE WHEN DB2DSDRIVER.XSD FILE DOESN'T EXISTS
IC94344 2 CCA3018N WHEN USING DB2CFIMP DUE TO WRITE PERMISSION MISSING ON INPUT FILE
IC90047 2 SET ECHO OFF COMMAND DOESN'T DISABLE THE DISPLAY OF COMMANDS ANDTHEIR OUTPUT
IC92197 2 A HOST STRUCTURE DECLARED USING TYPEDEF IN SQL DECLARE SECTION GENERATES ERRORS DEPENDING ON A NAME OR A LOCATION.
IC91284 2 DEFAULT IBMDADB2 PROVIDER NOT REGISTERED WHEN INSTALLING IBM DATA SERVER DRIVER OR SWITCHING DEFAULT COPY TO THE DS DRIVER
IC96041 2 FOR VARCHAR COLUMN IF WE SUPPLY DATA > 32K THROUGH SQLPUTDATA ITIS THROWING RC = SQL_ERROR AND RETURNS NO ERROR.
IC91724 2 DEFAULT IBMDADB2 PROVIDER NOT REGISTERED WHEN INSTALLING IBM DATA SERVER DRIVER OR SWITCHING DEFAULT COPY TO THE DS DRIVER
IC91730 2 DTC:XA:NOT SUPPORTED ISOLATIONLEVEL IN ADO.NET SCENARIO
IC89251 2 CALL PROCEDURE FAILS FROM CLPPLUS COMMAND PROMPT WHEN ARGUMENT VALUE CONTAINS OPEN OR CLOSED PARATHESIS '(' / ')' AND ','
IC89906 2 CAST() IN QUERY USED IN .NET FRAMEWORK DOES NOT ADEQUATELY RESOLVE PRECISION OF DATETIME DATATYPE IN IDS DATABASE.
IC91731 2 SQL5060N RESULTS FROM DB2CFIMP FOR SETTING DFT_MON_UOW TO ON IN DB2 V10.1
IC96277 2 SQL1086C WHEN CREATING DATABASE IF CURRENT WORKING DIRECTORY (CWD) IS EMPTY.
IC96267 2 MULTI-THREADED APPLICATIONS USING BOTH ESQL/C AND CLI INTERFACESMAY EXPERIENCE HANGS OR CRASHES WHEN NOT USING EXPLICIT CONTEXT
IC92230 2 DB2CLI REGISTERDSN -ADD -ALLDSN SYSTEM HAS MISSING ODBC DSNS WITH A LARGE NUMBER OF DSNS IN DB2CLI.INI OR DB2DSDRIVER.CFG
IC94085 2 .NET APPLICATION GETS SYSTEM.EXECUTIONENGINEEXCEPTION AFTER CONNECTING TO A DATABASE
IC92664 2 IN CLPPLUS NON WINDOW MODE PAUSE MAKES THE CLPPLUS WINDOW HANG
JR43257 2 MQSEND DOESN'T SEND A DATAGRAM BY DEFAULT
IC94081 2 CONVERSION ISSUE WHEN COMPILING WITH OPTION "WCHARTYPE"
IC88755 2 NEEDS MERGING -- ISSUE WITH CREATE DB PROPERTY PAGESIZE(WSDBU01058320)
IC91953 2 MULTI-THREADED APPLICATIONS USING BOTH ESQL/C AND CLI INTERFACESMAY EXPERIENCE HANGS OR CRASHES WHEN NOT USING EXPLICIT CONTEXT
IC96270 2 SQL_COLUMN_LENGTH RETURNS A LENGTH OF 16 INSTEAD OF 26 FOR TIMESTAMP COLUMNS WITH PATCH1=131072 ENABLED IN THE DB2CLI.INI FILE
IC91268 2 MISSING .NET DB2EXCEPTION BECAUSE OF MISSING RECORD IN SQLGETDIAGREC()
IC91752 2 CLPPLUS SHOULD NOT GET INTO INTERACTIVE MODE WHEN USER SPECIFIESINCORRECT CREDENTIALS IN THE CONNECT STRING GIVEN WHILE LAUNCHI
IC92616 2 SQLGETDIAGFIELDW() RETURNS THE STRINGLENGTHPTR AS CHARACTERS INSTEAD OF BYTES.
IC87451 2 .NET PROVIDER THROWS EXCEPTION WITH INFORMIX: A SYNTAX ERROR HASOCCURRED
IC91739 2 CLPPLUS WILL THROW A JCC EXCEPTION WHEN CONNECTION FAILS TO ESTABLISH AND 'WHENEVER SQLERROR' CLAUSE IS SET.
IC91292 2 INCORRECT OUTPUT FROM CLPPLUS WHEN SUBSTITUTION CHARACTER "&" PRECEDED BY "O"
IC92437 2 DB2CFEXP DOES NOT EXPORT ALTERNATE SERVER INFORMATION
IC87640 2 ALTER FUNCTION STATEMENT CAN FAIL WITH SQL0104N WHEN EXECUTED VIA DB2.NET OR CLI
IC87079 2 SQLGETCONNECTATTR() WITH SQL_ATTR_PING_DB AFTER A SEAMLESS FAILOVER
IC90117 2 REORGCHK CAN RETURN INCORRECT VALUES FOR LEAF_RECSIZE & NLEAF_RECSIZE RESULT IN INCORRECT F5 & F6 VALUES.
IC94183 2 .NET EXCEPTION WHEN SERVER SIDE PAGINATION IS ENABLED WITH ODATAWITH INFORMIX DATABASE
IC89720 2 SQL0644N ON STATEMENTS AFTER SELECT WITH STMTCONCENTRATOR=LITERALS & CURSORHOLD=1
IC91725 2 CLP PLUS NOT ACCEPTING PASSWORD EXPLICITLY WHEN CONNECTING USINGA DSN.
IC95044 2 CLI OR .NET APPLICATION WITH PUREQUERY CLIENT OPTIMIZATION MAY THROW SQL0805N WHEN USING FORCESINGLEBINDISOLATION OPTION.
IC91627 2 SQL1086C WHEN CREATING DATABASE IF CURRENT WORKING DIRECTORY (CWD) IS EMPTY.
IC83840 2 ERROR FOR EXECUTING DB2BATCH IN DB2DIAG.LOG WITH V9.7 FP5
IC91734 2 DECIMAL VALUES ARE INCORRECTLY RETURNED BY A STORED PROCEDURE
IC89035 2 EXCEPTION "THERE IS NO MORE DATA TO RETURN" WHEN USING ENTITIES W/ WFC SERVICES AND QUERYING TABLES W/ LOB COLUMNS USING EXPAND
IC89703 2 DB2DSDCFGFILL CREATES DUPLICATE LINES IN THE DB2DSDRIVER.CFG FILE DUE TO MORE THAN 255 DATABASES OR NODES CATALOGED
IC92226 2 CLI0143E ON SQLBINDPARAMETER FOR TIMESTAMP TYPE WITH CBCOLDEF=-1
IC89697 2 SQL0516N ERROR RUNNING QUERY FROM THE DB2 CLP AGAINST DB2 FOR Z/OS WITH IDAA ENABLED
IC89867 2 ADD WINDOW DOES NOT APPEAR USING IBM DATA SERVER DRIVER FOR ODBCAND CLI
IC96281 2 ABEND POSSIBLE IN CLI_SQLDISCONNECT WITH > 512 DATABASE HANDLES ALLOCATED IN MULTITHREAD ENVIRONMENT
IC91791 2 'LOAD QUERY' COMMAND ENCOUNTERS SQL6024C AND HOLD LOCKS ON CATALOG TABLES
IC90805 2 CAST() IN QUERY USED IN .NET FRAMEWORK INCORRECTLY MAPS VARCHAR(1) TO TEXT DATATYPE IN IDS DATABASE.
IC92026 3 OCISESSIONBEGIN FAILS WITH OCI_STMT_CACHE MODE
IC96286 3 SQL_DIAG_ROW_NUMBER RETURNS THE WRONG ROW NUMBER WITH ARRAY INPUT CHAINING
IC89023 3 DB2DSDRIVER.XSD NOT FOUND ON INSTANCE BASED CLIENTS
IC96257 3 POSSIBLE ABEND DURING SQLCONNECT CALL WHEN CONNECTIONS ARE FORCED ON THE SERVER SIDE.
IC94378 3 USING THE DB2CFIMP TO IMPORT CONNECTIVITY CONFIGURATION PARAMETERS CAUSES AUTOMATIC VALUES TO BE RESET TO MINIMUM VALUES.
IC92594 3 REORGCHK CURRENT STATISTICS ON TABLE MIGHT RETURN INCORRECT VALUE OF F2 FORMULA IN PARTITIONED DATABASE ENVIRONMENT
IC92736 3 XA CONNECTIONS DRIVEN BY XA_OPEN DO NOT USE DB2DSDRIVER.CFG AND THROWS SQL1013N ERROR
IC89494 3 IBM DATA SERVER DRIVER .NET DLL FILES NOT UPGRADED AFTER INSTALLOF SPECIAL BUILD
IC91305 3 WHEN DATABASE IS ACTIVATED AND LIST APPLICATIONS COMMAND IS ISSUED, SQLCODE IS NOT SET CORRECTLY.
IC92517 3 DB2 CLP DUMPS CORE WITH OPTION -L AND STATEMENTS BIGGER THAN 128K
IC91721 3 A TEMPORARY FILE ON /TMP IS LEFT AFTER EXECUTING CLPPLUS
IC90908 3 DB21034E ERROR OCCURS WHEN BLOCK COMMENTS IS AT THE BEGINNING OFFILE AND 'WITH' SQL STATEMENT IS AFTER BLOCK COMMENT.
IC93000 3 OCISTMTEXECUTE() MAY GET OCI_NEED_DATA ERROR
IC91737 4 WHEN STMT_CONC IS SET TO LITERALS, CLPPLUS IS NOT DISPLAYING THEEXPLAIN PLAN FOR STATEMENTS WHICH CONTAIN LITERAL VALUES.
Fix Pack 3   -    Codegen and Runtime
IC90241 1 USING XML IN QUERIES WITH REOPT BIND OPTION OR EXTENDED INDICATORS LEAKS MEMORY IN DATABASE HEAP IN DPF ENVIRONMENTS
IC89415 1 READ STABILITY ISOLATION IS NOT ENFORCED UNDER CERTAIN SQL ACCESS PLANS
IC93811 1 IN ENVIRONMENTS WHERE SORT MEMORY IS CONSTRAINED SEGV CAN HAPPENON HASH JOIN QUERIES DOING AGGREGATION
IC93009 1 ON DPF, A HANG CAN OCCUR IF AN INTERRUPT IS RECEIVED DURING THE EXECUTION OF A QUERY THAT CONTAINS A CORRELATED SUB QUERY.
IC89044 1 INSTANCE TRAP IN SQLRI_LIKE_ALLOC()
IC91197 2 INSTANCE PANIC WHEN AGGREGATION FUNCTION(IE.MIN,MAX,SUM...) IS USED AGAINST ROWID RESULT
IC92052 2 EXCESSIVELY LARGE MEMORY ALLOCATION ATTEMPTS FROM FAST INTEGER SORT DUE TO WRONG MEMORY SIZE CALCULATION
IC91822 2 CASTING XML ATOMIC INTO ONE OF SQL CHARACTER TYPES MAY LEAD TO ADM0503C.
IC92731 2 RETURN OF SQL0083C MAY CAUSE A HANG IN AN SMP ENVIRONMENT.
IC91989 2 QUERY WITH TABLESAMPLE SYSTEM() MIGHT HANG IN SMP MODE (INTRA_PARALLEL = YES)
IC91743 2 MEMORY OVERWRITE WHEN USING UTL_FILE OR DBMS_OUTPUT.ENABLE WITH BUFFER SIZE BIGGER THEN 32K.
IC92001 2 MEMORY CORRUPTION ISSUE WITH XML ON DPF ENV
IC91639 2 MEMORY OVERWRITE CAN HAPPEN WHEN ARRAYS WITH ELEMENTS OF LARGE SIZE ARE USED.
IC90798 2 INCORRECT RESULTS MIGHT BE RETURNED FOR THE SELECT QUERY INVOLVING THE AGGREGATION FUNCTION WITH THE OLAP WINDOW FUNCTION
IC89631 2 MEMORY LEAK IN APPL HEAP WITH INTRA-PARTITION PARALLELISM AND PLANS CHOOSE TO REBALANCING ROWS BETWEEN SMP SUBAGENTS (REBAL).
IC91741 2 TRAP IN RECYCLEANDREINIT FOR AN INTERRUPTED XML QUERY IN DPF
IC90017 2 CRASH IN SQLRIMOVEDATALEN FOR A RECURSIVE QUERY WITH UNION AND HOST VARIABLES
IC91689 2 FEDERATED OBJECT REFERENCES SHOULD BE DISALLOWED WITHIN COMPILEDSQL FUNCTIONS
IC92513 2 PERFORMANCE ISSUE DURING OPERATIONS ON GLOBAL COLLECTIONS
IC93789 2 DB2 ABEND IN FAST INTEGER SORT FUNCTIONS LIKE SQLSFASTINTDISTCOUNTSORT IF SORT MEMORY EXCEEDS 2GB
IC91283 2 SQL0901N IS RETURNED FOR A QUERY THAT FEATURES A UNION ALL VIEW WITH A HOST VARIABLE PREDICATE ON THAT VIEW.
IC86715 2 FEDERATED OBJECT REFERENCES SHOULD BE DISALLOWED WITHIN COMPILEDSQL FUNCTIONS
IC90906 2 A QUERY INVOLVING AT LEAST TWO COUNT(DISTINCT ...) AGGREGATE FUNCTIONS MIGHT RETURN WRONG RESULTS
IC89710 2 PRECISION PROBLEM WHEN CONVERTING A DOUBLE TO A DECIMAL.
IC92353 2 IN A DPF ENVIRONMENT, AN ACCESS PLAN WITH A LISTENER TQ OPERATORMAY ENCOUTER A NULL POINTER AND CAUSE DB2 TO CRASH.
IC94465 2 BITWISE SCALAR FUNCTIONS MIGHT RETURN INCORRECT RESULTS WHEN USED WITH DECFLOAT DATATYPE ON AIX POWER7
IC89700 2 INSTANCE TRAP DUE TO SQLRINLJNMUSTIDOINNER
IC87452 2 DYNAMIC WINDOW COUNT ADJUSTMENTS IS TOO AGGRESSIVELY REDUCING WINDOW COUNT.
IC94377 2 POSSIBLE SEGV (CRASH/TRAP) IN SQLDROWFETCH() WHEN SQL IS USING PBT(PARAMETERIZED BASE TABLE) ACCESS IN A NESTED LOOP JOIN
IC91117 2 DB2 TRAP IN REBAL CODE DUE TO MEMORY CORRUPTION
IC90770 2 ZIGZAG JOIN WITH QUERY DEGREE > 1 MAY HANG OR FAIL WHEN A SUBAGENT EXITS EARLY WITH NO ROWS FOUND IN DIMENSION PROCESSING
IC90452 3 DB2 MIGHT CRASH WHEN RUNNING DBMS_ALERT.SET_DEFAULTS() SQL FUNCTION.
IC91744 3 SORT SHARED MEMORY COUNTER UNDERFLOW MAY CAUSE SEVERE MESSAGE INTHE DB2DIAG.LOG
IC92571 3 GRAPH GENERATED WITH 'DB2EXPLN -G' DOES NOT CONTAIN STATISTICS
IC87506 3 ON V10.1, SQLRR_APPL_TERM() MAY REPORT SEVERE SQL0901N MESSAGE
IC86835 3 SQL STATEMENT FAILS WITH SQL0901N (REASON "ASSERT ZZJN DIM TEMP TAOB HAS A DUMMY RESID ")
IC91803 3 MEMORY LEAK IN UCA500R1 COLLATION DATABASE WHEN USING COLUMN NAME IN PATTERN-EXPRESSION OF LIKE CLAUSE
IC90756 3 SQL0901 IS RETURNED FOR A QUERY THAT FETCHES ZERO-LENGTH LARGE OBJECTS ON DPF
IC92732 3 QUERY HANG WHEN SELECTING LARGE OBJECT COLUMNS FROM A TABLE FUNCTION ON DPF
IC91800 3 SQL0956C THROWN WHEN CALLING PARSE PROCEDURE WITH AN INPUT SQL STATEMENT CONTAINING A COMMENT WITH COLON (:) FOLLOWED BY A SPACE
IC91405 3 SOMETIMES A QUERY INVOLVING A ZIGZAG JOIN MAY FAIL WITH WITH A SQL0901N ERROR
Fix Pack 3   -    Communication
IC89975 2 WHEN THIRD PARTY SOFTWARE LOADS GSKIT-CRYPTO INSTEAD OF FULL GSKIT , DB2 LOADS ITS LOCAL GSKIT-CRYPTO , DB2 FAILS WITH SQL1042C
IC91990 2 FALSE COMMUNICATION ERROR DETECTED BETWEEN DB2FMP PROCESS AND DB2 EDU LEADING TO INCORRECT SQL1646N ERROR RETURNED
IC90914 2 DB2TCPCM EDU NEED TO HANDLE SETSOCKOPT() FAILURES MORE GRACEFULLY
IC89978 2 XAER_NOTA RETURNED BY DB2 CONNECT SERVER WHEN TM TRIES TO PREPARE/COMMIT/ROLLBACK A TRANSACTION IN DISTRIBUTED ENVIRONMENT.
IC89541 3 DB2 IS UNABLE TO CLEAN UP THE SSL RESOURCES CORRECTLY WHEN IT FAILS TO LOAD GSKIT AND THUS CAUSES UNRECOVERABLE ERROR
IC91756 3 ADD RETRY WHEN DB2 RECEIVES WSAEACCESS WHEN BINDING TCP SERVICE PORT IN WINDOWS.
Fix Pack 3   -    DB2 Tools
IC96394 1 PERFORMANCE EXPERT MAY HANG WHEN UTILIZING FUNCTIONS PROVIDED BYTHE DB2 CONTROL CENTER
IC89706 2 DBA7510 FROM THE CONTROL CENTER USING WIZARD: CREATE DATABASE WITH AUTOMATIC MAINTENANCE
IC91740 2 ADMIN_CMD LOOPS IF MORE THAN 32767 MSG IN SQLLIB/TMP, AND/OR ADMIN_REMOVE_MSGS FAILS WITH SQL20193N RC=10.
IC96283 2 SYSPROC.NNSTAT PROCEDURE CAN FAIL IF USING METHOD 2 WITH SQL0206N ERROR.
IC96260 2 NNSTAT METHOD 1 OR 0 REPORTS SQL1227N RC=3 WHEN IT TRIES TO UPDATE HIGH2KEY TO SINGLE BLANK FOR AN INTEGER COLUMN
JR46839 3 DB2FMP CRASHES WHEN RUNNING NNSTAT FOR A NICKNAME THAT HAS AN INDEX CONTAINS TOO MANY COLUMNS
Fix Pack 3   -    DRDA Services
IC96255 1 CONNECTION HANGS ON ACR AFTER COMMUNICATION ERROR. ALTERNATE SERVER INFORMATION FROM THE DATABASE CATALOG IS NOT USED.
IC91681 2 STORED PROCEDURE FAILS WITH SQL30020N WHEN THERE ARE 10684 PARAMETER MARKERS
IC92712 2 .NET XA APPLICATION WITH AUTOMATIC ENLISTMENT CAN CRASHE ON FIRSTCONNECT DURING LICENSE ACTIVATION
IC92173 2 2 MINOR MEMORY LEAKS WHEN CONNECTING USING CLI.
IC91776 2 AFTER UPGRADING TO V9.7 FP7, QUERY DRDA NICKNAME WILL FAIL IF DB2 REGISTRY DB2TCP_CLIENT_CONTIMEOUT IS SET
IC89783 2 AFTER AN APPLICATION IS BEING KILLED, ITS SPAWNED TRANSACTIONS ARE LEFT IN EXECUTING STATE
IC96284 2 WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.
IC96386 2 DB2 CONNECT INSTANCE MAY CRASH IN THE FUTURE AFTER A COMMUNICATION ERROR WHEN LDAP SUPPORT IS ENABLED (DB2_ENABLE_LDAP=YES).
IC91302 2 XA PROTOCOL ERRORS AFTER RM_FAIL ON XA_END.
IC92178 2 SQLNN_E_SYNTAX SYNTAX ERROR ON 'CALL 47' STORED PROCEDURE CALL SEEN IN DB2DIAG.LOG
IC91807 2 WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.
IC92966 2 XA_END MAY RETURN XA_RBOTHER INSTEAD OF XAER_RMFAIL AFTER REPORTING COMMUNICATION ERROR.
IC91805 2 DIA5000C "INVALID DDM REQUEST" AND SYNTAX ERROR REPORTED WHEN DB2 FOR ZOS ATTEMPTS TO SWITCH ID ON A TRUSTED CONNECTION
IC96287 2 ACR IS NOT ENABLED FOR CONNECTIONS TO Z/OS THRU DB2 CONNECT SERVER EVEN ALTERNATE SERVER IS SET
IC92081 2 APPLICATION MAY SEE ERROR SQL301N OR SQL30020N, IF A SQL/PL IS CREATED WITH ARRAY TYPE.
IC91771 2 SQL0998N OR XAER_PROTO WHEN DB2LIC.SYSLIC IS CALLED TO CHECK SERVER ACTIVATION
IC92079 2 APPLICATION MAY SEE ERROR SQL301N OR SQL30020N, IF A SQL/PL IS CREATED WITH ARRAY TYPE.
IC91767 2 AN OUT OF MEMORY ERROR ENCOUNTERED WHILST COPYING A DATA DESCRIPTOR COULD LEAD TO A CRASH.
IC93738 2 SQL1001N ERROR FROM CLI APPLICATION WHEN ENLISTING THE DATABASE WITH MSDTC.
IC93060 2 DB2 CONNECT SERVER CONNECTION CONCENTRATOR MAY FAIL TO RE-ESTABLISH CONNECTION OR TRUSTED CONNECTION.
IC94088 3 CLIENT REROURE FAILS TO ZOS SERVER WITH ERRONEOUS MESSAGE "ENSURE APAR PM24292 IS INSTALLED ON THAT SYSTEM."
IC91794 3 CLI EXTENDED DIAGNOSTICS, ARRAYINPUTCHAIN ENABLED AGAINST A BUSYDB2 ZOS SERVER RETURNS SQL0904N-NO REASON CODE, RESOURCE NAME
IC87379 3 ERRONEOUS MESSAGE "ENSURE APAR PM24292 IS INSTALLED" WHILE CONNECTING TO ISERIES SERVER
IC96396 3 DB2 CONNECT SERVER MIGHT CRASH IF DCS DIRECTORY IS CATALOGUED TOUSE MAP-FILE OPTION
IC96449 3 ADMIN_MOVE_TABLE MIGHT PRODUCE TRAP OR FAIL IF ORIGINAL TABLE HAS MORE THAN 100 REFERENCES
Fix Pack 3   -    Data Management Services
IC94243 1 SQLE_SAL_CACHE_RAR_NODATA USING THE DB2READLOG API
IC91306 2 WHEN DB2 UDB SERVER ENCOUNTERS BLOCK INDEX ISSUE, DB2 SERVER SHOULD RETURN SQL0901N ERROR INSTEAD OF TRAP.
IC89580 2 WHEN DB2 UDB SERVER ENCOUNTERS BLOCK INDEX ISSUE, DB2 SERVER SHOULD RETURN SQL0901N ERROR INSTEAD OF TRAP.
IC91168 2 SQL STATEMENT MAY HANG DUE TO A DEADLATCH WHEN PROCESSING SUBSECTIONS OF A ZIG ZAG JOIN PLAN
IC89100 2 REORG FAILS WITH SQL2216N (-301) ON HP DPF ENVIRONMENT
IC92799 2 IN RARE TIMING SCENARIO, LOAD PERFORMANCE WITH LOB VALUES MAY DEGRADE
IC94173 2 SIGNAL 11 TRAP IN SQLSBINSORTPOPULATERECPOINTERS
IC92699 2 DB2CAT FAILS TO GENERATE A NEW PACKED DESCRIPTOR (-G OPTION) IN DB2 V10.1, WHEN TABLE HAS INDEXES
IC94160 4 INCORRECT CUR INDEX AND START TIME VALUES IN DB2PD -REORGS INDEXAFTER AN INTERRUPTED INDEX REORG
Fix Pack 3   -    Data Management Utilities
IC95010 1 THE LOAD COMMAND WITH THE REMOTE FETCH OR SOURCEUSEREXIT OPTIONSMIGHT FAIL TO INSERT SOME ROWS INTO A TABLE
IC95993 1 INGEST: RUN TIME IS 32X WORSE THAN IMPORT WHEN TABLE HAS MANY UDTS
IC88134 2 LOAD COMMAND MIGHT HANG WHEN LOADING DATA INTO DATA PARTITIONED TABLES OR MDC TABLES
IC91763 2 RESTORE DB WITH TRANSPORT FAILS WITH ERROR SQL2590N DUE TO LOG ARCHIVING FAILURE ON STAGING DATABASE.
IC89203 2 LOAD MIGHT TRAP AND CRASH THE INSTANCE IN CERTAIN CONDITIONS
IC94720 2 LOAD TRAPS WHEN TARGET TABLE HAS GENERATED COLUMN WHICH IS USINGCOMPILED COMPOUND SQL UDF; SHOULD FAIL GRACEFULLY.
IC90269 2 'LOAD QUERY' COMMAND ENCOUNTERS SQL6024C AND HOLD LOCKS ON CATALOG TABLES
IC91801 2 IMPORT NULL VALUE TO A COLUMN THAT IS A PART OF PRIMARY KEY WITHINSERT_UPDATE AND USEDEFAULTS OPTIONS WILL COMPLAIN -206 ERROR.
IC91297 2 DB2 LOAD INTO PARTITIONED TABLE THAT CONTAINS AN XML COLUMN MAY FAIL WITH SQL0901N - "MAX PSEUDO RID REACHED"
IC94134 2 SQL2918N RECEIVED WHEN THE INGEST COMMAND SPECIFIES BOTH ONE OF THE IMPLICITLYHIDDEN OPTIONS AND THE EXCEPTION TABLE CLAUSE
IC90772 2 SQL2036N WHEN USING RECOVER WITH RESTORED RECOVERY HISTORY FILE FROM A BACKUP THAT HAS MORE THAN 1 SEQUENCES
IC91792 2 LOAD MAY FAIL WITH SQL0902C RC85 IF THERE IS AN INDEX WITH KEY LENGTH AROUND 4000 OR 8100 BYTES
IC93013 2 LOAD: RECORDS REJECTED DURING PARTITIONING ARE NOT COUNTED TOWARDS WARNINGCOUNT
IC88474 2 LOAD REMOTE FETCH MIGHT TRAP AND CRASH DB2 INSTANCE DURING THE INDEX COPY PHASE
IC91704 2 DB2 INGEST FAILS ON WINDOWS VISTA AND WINDOWS 7
IC94987 2 DPF: DB2DART REPORTED INDEX KEY ERRORS AFTER REDISTRIBUTE ON A TABLE WITH ADAPTIVE COMPRESSION
IC93053 2 XML LOAD TERMINATE RESULTS IN SQL1007N (ERROR IN FINDING PAGES FOR AN OBJECT IN A TABLE SPACE.)
IC91272 2 DB2 INSTANCE CRASH IN SQLUCONVDATATOTARGET() DURING LOAD INTO TABLE
IC89228 2 LOAD MIGHT CHANGE THE CURRENT WORKING DIRECTORY OF DB2SYSC WHEN LOADING LOB/XML DATA IN A NON-DPF ENVIRONMENT
IC89200 3 COLUMN CONTAINING INVALID CHARACTER DATA REJECTED BY LOAD REMOTEFETCH
IC93161 3 BINDING DB2UCKTB.BND AGAINST LOWER RELEASE DB2 LUW DATABASE THROWS ERROR.
IC84263 3 REDISTRIBUTE UPDATES TABLE PACKED DESCRIPTOR AND OVERWRITES UPDATES OF RUNSTATS
IC90126 3 ON WINDOWS IMPORT UTILITY MIGHT FAIL WITH ERROR SQL0604N WHEN DB2_COMPATIBILITY_VECTOR=ORA IS SET.
Fix Pack 3   -    Data Recovery Services
IC92015 1 A SECOND DATABASE RECOVERY THAT NEEDS TO REPLAY SOME LOG RECORDSREPLAYED DURING A PREVIOUS DATABASE RECOVERY MAY FAIL.
IC94728 1 REQUIRED TRANSACTION LOGS FOR ONLINE BACKUP CAN GET DELETED IN DB2 V10.X. RESULTING IN SQL2048N ERROR.
IC94114 2 DB2FLSN -LSO MAY RETURN A WRONG LOG FILE NAME
IC90510 2 DB2 ONLINE BACKUP WITH INCLUDE LOGS FAILS WITH ERROR SQL2428N
IC89675 2 GRACEFUL TAKEOVER ON A HADR READS ENABLED STANDBY RETURNS SQL1773N IF THERE ARE UNCOMMITTED IN-DOUBT TRANSACTIONS ON PRIMARY.
IC90952 2 HADR STANDBY DATABASE ENCOUNTERS LOG PAGE CHECKSUM ERROR
IC90923 2 UPGRADE CODE CHECK-IN OPTION FOR VALID RUNSTATS PROFILES
IC90695 2 ARCHIVED LOG CORRUPTION POSSIBLE USING LOG COMPRESSION AND VENDOR SETTING
IC92474 2 DB2 V10.1 DOES NOT WRITE THE "STARTED ARCHIVE FOR LOG FILE XXX"MESSAGE TO THE DB2DIAG.LOG FILE ANYMORE
IC93281 2 NO AUTO DELETION OF OLD BACKUP IMAGES ON DISK AFTER MIGRATION TO10.1
IC91656 2 HADR START AS STANDBY FAILS DUE TO ENOBUFS ERROR AND RETURNS HDR_ZRC_CONFIG_LOCAL_HOST
IC91789 2 ONLINE BACKUP CAN FAIL WITH SQL0100W AND INCORRECTLY REPORT BACKUP COMPLETE AS WELL AS OVERWRITING THE BACKUP TRACKING STRUCTURE
IC91266 2 SQL1042C ERROR CAN OCCUR WHILE APPLYING TRANSACTION LOGS (TILL "END OF BACKUP" OPTION) ON DB2 FOR WINDOWS.
IC89312 2 "DB2CKLOG CHECK -M" FAILS WITH DBT7045E IN V10.1, WHEN THE CHECKED DATABASE IS ACTIVE
IC92997 2 DB2FLSN -Q (QUIET MODE) DOES NOT WORK CORRECTLY
IC93536 2 DB2ADULT RETURNS READING OF DB CFG FILE FAILED! AND TSM RC=137 IN PURESCALE INSTANCE ENV
IC91793 2 DB2CKBKP REPORTS MISLEADING ERROR "NO PAGE HEADER: POSSIBLE LOB.ERROR - TABLESPACE PAGE SIZE INCONSISTENT FOR TABLESPACE ID <#>"
IC93405 2 DB2PD -LOGS AND MON_GET_TRANSACTION_LOG() DO NOT RETURN RIGHT LOG CHAIN ID
IC94252 2 TCP CONNECTIONS FROM NON-HADR DATABASE SOFTWARE TO THE STANDBY MIGHT ALTER THE HADR STATE AND STALL LOG SHIPPING ON THE PRIMARY
IC89732 3 DB2CKBKP RETURNS FALSE ERRORS FOR COMPRESSED BACKUPS
IC93241 3 DB2READLOG API WAS RETURNED SQLCODE -1273 DURING ONLINE BACKUP.
IC92623 3 RESTORE FAILS IF VENDOR LIBRARY CANNOT BE INITIALIZED, DESPITE USING BACKUP IMAGE AND LOG FILES PREVIOUSLY EXTRACTED TO DISK
IC91779 3 A TABLE SPACE BACKUP DOESN'T RESPONSE INTERRUPT FROM "CTROL+C" OR "FORCE APPLICATION".
IC92696 3 SQLUDREPAIROFFLINEBACKUPENDMARKER, PROBE:1719 ON RESTORE
IC90960 3 GROUP READ PERMISSION IS REVOKED ON ARCHIVE LOG FILES.
IC96259 3 SYNTAX CHECK FOR RECOVER DB USING HISTORY FILE NEEDS TO BE MOVEDFROM CLIENT TO SERVER
IC88511 3 EXCESSIVE DIAGNOSTIC LOGGING SERVICING ASYNCHRONOUS LOG READ REQUESTS (DB2READLOG API)
Fix Pack 3   -    ESE Monitoring code
IC93167 2 CLI APPLICATION MAY TRAP DUE TO MEMORY CORRUPTION
Fix Pack 3   -    Federation
JR48045 2 RUN NNSTAT FAILED WITH THE ERROR SQL1227N
IC96754 2 YOU MAY MEET SQL1227N ERROR WHEN HIGH2KEY AND LOW2KEY IS TIMESTAMP TYPE IN ORACLE MODE
IC96258 2 FED: ALTER NICKNAME IN ORA COMPATIBLE MODE, FAILED TO MAP REMOTEDATE TO LOCAL TIMESTAMP(0)
IC91455 2 ERROR RAISED INCORRECTLY FROM SQLEFEDFMPMANAGER::DISCONNECT UPONSUBAGENT CLEANUP
IC89715 2 BAD PERFORMACE WHEN USING SYBASE NICKNAME WITH BIGINT COLUMN PREDICATES
IC91289 2 ORACLE WRAPPER LEAKS MEMORY WHEN ITERATIVELY EXECUTES DYNAMIC IUD STATEMENTS IN A PACKAGE
IC96269 2 ADD ERROR MAPPINGS FOR SOME ORACLE CONNECTION ERRORS TO DB2 ERROR SQL30080N
JR47218 2 REPORT SQL0901N (REASON "BAD OPCODE -9, REF_ARITY 3, SQLNQ_PID ID 941 (SYSIBM.DJ_RPAD)".)
IC93252 2 TO_CHAR AND OTHER BUILT-IN FUNCTIONS COULD NOT BE PUSHED DOWN
IC96256 2 DB2 MAY TRAP AT THE DESTRUCTOR OF SQLQG_REMOTE_STMTS.
IC91768 2 INCORRECT OUTPUT OF DATETIME AND DATETIME2 IN SQL SERVER
IC91286 2 INCORRECT OUTPUT OF DATETIME AND DATETIME2 IN SQL SERVER
IC96275 2 SQL1822N ERROR WHEN QUERYING CURRENT DATE OR TIMESTAMP FROM NICKNAME
IC96412 2 THE FEDERATED SERVER DOES NOT SUPPORT USER-DEFINED TYPES, DISTINCT TYPES, AND REFERENCE TYPES AS COLUMNS OF NICKNAMES.
IC88789 2 INCORRECT OUTPUT OF DATETIME AND DATETIME2 IN SQL SERVER
IC96266 2 FENCED ORACLE WRAPPER LEAKS MEMORY WHEN ITERATIVELY EXECUTES INSERT/UPDATE STATEMENTS INVOLVING A LOB COLUMN
JR46877 2 CREATE NICKNAME AGAINST ORACLE TABLE (USING ORACLE WRAPPER) MIGHT FAIL WITH ERROR SQL0802N FOR ORACLE TABLE WITH FEW BILLION ROW
IC91813 2 REPLACE OLD API OCIENVINIT AND?OCIINITIALIZE TO OCIENVCREATE SINCE ORACLE HAS NOT SUPPORT IT ANYMORE
JR45770 2 FEDERATED FMP TRAPPED WHEN QUERY JDBC NICKNAME WITH CLOB DATA LONGER THAN 32K
IC87539 2 BAD PERFORMACE WHEN USING SYBASE NICKNAME WITH BIGINT COLUMN PREDICATES
IC89699 2 CREATE NICKNAME FOR A TABLE ON DB2/Z VERSION 10 FAILED WITH SQL0901N REASON "ERROR SERVER VERSION"
IC96411 2 ENHANCE FEDERATION SERVER INFORMIX WRAPPER PERFORMANCE WHEN IT HAS BIGINT
JR46425 2 JDBC DOESN'T REPORT SQLCODE 100 WHEN NO DATA IS UPDATED OR DELETED
JR46976 2 RECEIVE SQL1822N/SQL0401N ERROR WHEN QUERYING A NICKNAME IN AN ORA MODE DATABASE
IC93251 2 UDF WITH STRING RESULT TYPES COULD BE BLOCKED FROM BEING PUSHED DOWN
IC96413 2 THE REMOTE CONNECTION'S ISOLATION LEVEL IS SERIALIZABLE WHEN USING SQL SERVER WRAPPER 2PC FEATURE
IC91719 3 QUERY MAY HANG WITH FEDERATED AND DB2_COMPATIBILITY_VECTOR=ORA
IC91773 3 INCORRECT OUTPUT OF DATETIME AND DATETIME2 IN SQL SERVER
IC91775 3 INCORRECT VARCHAR2 COMPARISON PREDICATE IS PUSHED DOWN TO ORACLECAUSES -1822 ERROR
IC91780 3 "GROUP BY 1" SYNTAX IS PUSHED DOWN MSSQL INCORRECTLY
IC91722 3 ADD DIAGNOSIS INFORMATION WHEN ORACLE WRAPPER FAILED AFTER CALLING OCIENVINIT
IC91671 3 NESTED TABLE EXPRESSIONS WITH OUTER JOIN NOT PUSH DOWN
Fix Pack 3   -    Index Manager
IC92990 1 INDEX / DATA MISMATCH MIGHT OCCUR IN AN MDC TABLE AFTER A DEFERRED ROLLOUT
IC90039 2 DEADLATCH DURING MEMBER CRASH RECOVERY IN A DB2 PURESCALE ENVIRONMENT
IC92798 2 RUNNING MULTIPLE CONCURRENT SAMPLED DETAILED INDEX RUNSTATS MIGHT CAUSE A SERVER ABEND OR INACCURATE INDEX STATISTICS
IC89032 2 SQLI_SMP_ERR ERROR DURING ROLLBACK OF FREE PAGE OPERATION ON AN INDEX
IC91650 2 INSPECT WITH THE INDEXDATA OPTION PANICS AFTER ENCOUNTERING AN INVALID RECORD ID
IC89288 2 INDEX CORRUPTION MIGHT BE INTRODUCED DURING A DATABASE UPGRADE TO DB2 VERSION 10.1
IC92146 2 MULTIPLE DETACH PARTITION FROM THE SAME UNIT OF WORK WILL DEADLOCK WITH EACH OTHER
IC88239 2 MEMORY LEAK IN APPLICATION SHARED HEAP INSERTING INTO PARTITIONED MDC TABLES
IC86929 2 INCREASE CONCURRENCY OF PARALLEL RECOVERY FOR LOG RECORDS ASSOCIATED WITH RECLAIM EXTENTS OPTION OF REORG INDEXES COMMAND
IC91894 2 LOG FULL DURING REORG INDEX(ES ALL) WITH THE CLEANUP ONLY ALL OPTION
IC91709 2 DATABASE MARKED BAD WHILE DROPPING AN INDEX
IC90894 2 POSSIBLE HANG IN INDEX CLEANUP LOGIC WHEN MULTIPLE ASYNCHRONOUS CLEANUP OPERATIONS ARE ACTIVE ON THE SAME TABLE
IC91351 3 CREATION OF LARGE INDEXES OF LARGE INDEXES IS SLOWER THAN EXPECTED WHEN USING THE DB2 PURESCALE FEATURE
IC89543 3 SQLB_EMP_MAP_INFO_NOT_FOUND FROM SQLBPFTRIGGERPREFETCH IN DB2DIAG.LOG
IC93092 3 UPDATE OF UNIQUE COLUMNS MIGHT RESULT IN DUPLICATES IN A TABLE WITH A UNIQUE INDEX
Fix Pack 3   -    Install and Catalog Services
IC91824 1 CONCURRENT CREATE/ALTER TABLE STATEMENTS CONTAINING "GENERATED ALWAYS AS IDENTITY" COLUMN MIGHT END UP WITH AN INFINITE LOOP
IC95081 1 DB2 CRASHES WHEN THREE PART NAME IS USED ON NON-CATALOG NODE.
IC93982 2 WITHOUT UPGRADE_PRIOR_VERSIONS=TRUE, THE UPGRADE IS TREATED AS ANEW INSTALLATION
IC91613 2 V10.1 ONLY: DB2IUPDT COMMAND OVERRIDES FENCEDID BY INSTANCE OWNER IF -U OPTION IS NOT SPECIFIED.
IC89175 2 POSSIBLE ABEND IN SQLOFMBLKEX CALLED FROM SQLNQ_SEQUENCE_REF_BODY
IC91806 2 DB2 INSTALLATION UNDER WINDOWS OS MAY FAIL WHEN EXTENDED SECURITY FEATURE IS ENABLED IN AD ENVIRONMENT.
IC91745 2 DB2CI64.LIB IS MISSING FROM INSTALL IMAGE. ALSO MISSING IN V10 IMAGES AND SO ON.
IC91941 2 DB2IUPGRADE IS FAILING DUE TO DUPLICATE MATCHING RECORDS IN /ETC/SERVICES
IC96262 2 A DEADLOCK MAY OCCUR,IF ALTER SEQUENCE IS EXECUTED AT THE SAME TIME.
IC92405 2 DB2IUPGRADE/DB2IUPDT MAY CAUSE OPERATION TO FAIL WITH "DBI1250E APPLICATIONS ARE STILL USING THE INSTANCE"
IC91038 2 CREATE EVENT MONITOR FAILS WITH SQL0604N ON "BLOB (32) INLINE LENGTH 32"
IC96451 2 THE GRANT COMMAND FOR THE PROCEDURE IS NOT COLLECTED WHEN WE ISSUE THE DB2LOOK COMMAND.
IC91271 2 PERFORMING DB2 BRUTE FORCE UNINSTALLATION DAMAGES GSK 7(IF INSTALLED).
IC91736 2 INSTALL ISO UPDATE OF A FIXPACK FAILS WITH: "PLEASE INSERT THE DISK: 1"
IC86755 2 DB2CKUPGRADE PERFORMANCE IMPROVEMENT FOR TABLE LOAD PENDING CHECK
IC89735 2 DB2LICM -L OUTPUT IS NOT LISTING THE DB2 STORAGE OPTIMIZATION FEATURE LICENSE FOR RESTRICTED SERVER EDITIONS.
IC89957 2 INSTALLING DB2 NON-PURESCALE FAILS ON WPAR
IC89155 2 GPFS UPDATE FAILS DURING DB2 INSTALLATION IF TIVOLI.TSM.CLIENT.BA64.GPFS.BASE IS PRESENT IN THE MACHINE
IC92056 2 IN ENVIRONMENT WHERE CF AND MEMBER IS IN ON LPAR, UPDATING CF ORMEMBER CHANGES INFINIBAND INFORMATION ABNORMALLY.
IC90825 2 DB2IUPGRADE HANGS FOREVER IN THE DB2 ACS UPGRADE STEP WHEN THEREARE SPECIAL FILES LIKE NAMED PIPES LOCATED IN THE ACS DIRECTORY
IC89048 2 DB2IUPGRADE COMPLETES WITHOUT ERROR HOWEVER DOES NOT UPGRADE THEINSTANCE
IC90839 2 DB2PREREQCHK SHOULD DISPLAY WARNING MESSAGES INSTEAD OF ERRORS ONLY FOR /OPT WHEN SPACE REQUIREMENTS ARE NOT MET
IC90783 2 TRAP ON USING VARIABLE OBJECT AFTER UPGRADE TO V10.1
IC90953 2 DB2CKUPGRADE FAILS WHEN THERE IS A CERTAIN DEPENDENCY ON SEQUENCE.
IC96252 2 ENHANCE DB2CAT CATALOG VALIDATION TO CHECK FOR STATISTIC PROFILEINCONSISTENCIES
IC94634 2 THERE MIGHT BE A DOUBLE FREE OR LIST CORRUPTION IN THE SQLRLC_CSM_DEFUNCT() FUNCTION
IC90790 2 DB2UNINS CRASHES FOR MULTIPLE INSTALL AND UNINSTALL ON WIN7 PLATFORM FOR DB2 EXPC PRODUCT
IC92293 2 WLM CONFIGURATION WIZARD FAILS TO START WITH WLM51018E AFTER MIGRATING TO DB2 V10
IC89737 2 "DB2LICM -L" DOES NOT REPORT THE DATABASE PARTITIONING LICENSE EVEN AFTER THAT LICENSE HAS BEEN APPLIED (USING DB2DPF.LIC)
IC89154 2 DB2IUPGRADE OF PURESCALE FAILS IF FENCED USER'S RLOGIN IS NOT SET TO TRUE.
LI77216 2 DB2CKUPGRADE FAILS WHEN THERE IS A CERTAIN DEPENDENCY ON SEQUENCE.
IV37139 2 DB2SETUP FAILS TO UPDATE TSA EFIX WHEN TSA AND RSCT INSTALLED AND MEDIA LEVEL ARE SAME.
IC90505 2 UNABLE TO UPDATE EXISTING V10.1 FIX PACK 2 INSTALLATION ON WINDOWS 8 OR WINDOWS 2012
IC90132 2 DBI1264E ERROR DURING CLIENT INSTANCE UPGRADE USING DB2IUPGRADE COMMAND
IC90161 2 DBI1264E ERROR DURING CLIENT INSTANCE UPGRADE USING DB2IUPGRADE COMMAND
IC84303 2 1603 : ERROR_INSTALL_FAILURE WHEN UPGRADING DB2 9.7 TO DB2 VERSION 10.1 ON WINDOWS (64 BIT)
IC92497 2 DB2 V10.1 IBM DATA SERVER RUNTIME CLIENT INSTALL USING LOCAL SYSTEM ACCOUNT FAILS ON WINDOWS 64-BIT SERVER
IC91904 2 DB2_INSTALL FAILS WITH ERROR : DB2SETUP_EXEC: 15205012 MEMORYFAULT - CORE DUMPED
IC91164 2 DB2IUPDT FAILS WHILE TRYING TO MOVE INSTANCE TO NEWLY INSTALLED FIXPACK LOCATION, IF FIXPACK IS INSTALLED USING UNIVERSAL IMAGE
IC86862 3 DB2ICRT -P OPTION DOES NOT UPDATE THE SVCENAME CONFIGURATION PARAMETER WHEN PORT NUMBER IS A NUMERIC VALUE
IC96397 3 SQL0440N ON SYSIBM BUILT IN FUNCTIONS AFTER RESTORE REPLACE EXISTING OF A DATABASE ONTO A PREVIOUS RELEASE FIX PACK
IC91282 3 DEFAULT IBMDADB2 PROVIDER NOT REGISTERED WHEN INSTALLING IBM DATA SERVER DRIVER OR SWITCHING DEFAULT COPY TO THE DS DRIVER
IC91094 3 DB2VAL GETS "ERROR WHILE LOADING SHARED LIBRARIES"
IC93316 3 DB2IUPGRADE MAY RETURN MISLEADING "CTRL/.INSTUSE" ERRORS BECAUSEIT CHECKS OTHER UNRELATED INSTANCES
IC90512 3 DB2PREREQCHECK OUTPUTS FOR DB2 V10.1 ON WINDOWS 2008 R2 OR WINDOWS 2012 ARE MISLEADING
IC91727 3 DB2_INSTALL WITH "-F NOTSAMP" OPTION FAILS ON HP-UX WITH: UNKNOWN KEYWORD "INSTALL_TSAMP"
IC93074 3 DB2PREREQCHECK DOES NOT SHOW DBT3514W AGAINST 32-BIT C LIBRARY IN THE SUMMARY.
IC93123 3 INSTALLING FIXPACK FOR DB2 CLIENT USING DB2 SERVER OR UNIVERSALIMAGE MAY REPORT A MINOR ERROR RELATED TO TSA.
IC88377 3 DB2 INSTALLATION USING SETUP.EXE WITH -I EN OPTION WITH GERMAN LOCALE OS SETTINGS GETS STUCK AT THE SSH SERVER INSTALLATION PAGE
IC91349 3 THE UNINSTALLER OF 64-BIT DATA SERVER CLIENT/DRIVER DOESN'T REMOVE 32BIT ODBC DATA SOURCES.
IC90691 3 %PATH% ENVIRONMENT VARIABLE VALUE IS CHANGED TO LOWER CASE AFTERDB2 IS INSTALLED ON WINDOWS 7, 2008 R2
IC87176 3 DB2_INSTALL AND INSTALLFIXPACK COMMANDS CANNOT FIND THE DEFAULT FILE LOCATION OF THE NLPACK
IC90152 3 %PATH% ENVIRONMENT VARIABLE VALUE IS CHANGED TO LOWER CASE AFTERDB2 IS INSTALLED ON WINDOWS 7, 2008 R2
IC90574 3 CHANGE TO ENHANCE ERROR MESSAGE REGARDING MINIMUM FREE SPACE REQUIREMENTS FOR INSTALLATION AND INSTANCE CREATE/UPDATE OPERATIONS
IC90300 3 DB2ICRT FAILS TO CREATE INSTANCE, WHILE SYMBOLIC LINKS FROM OTHER DB2 COPY CREATED WITH COMMAND DB2LN EXISTS IN THE SYSTEM
IC89695 3 SQL20005N WHEN CREATING TYPES EVEN THOUGH LIMIT HAS NOT BEEN REACHED.
IC92160 3 WHEN DOING THE REDIRECT RESTORE TO MIGRATE DATABASE FROM V9.7 TOV10.1, RESTORE GENERATED WARNING MESSAGES OF -1704 RC=5
IC88767 3 CHANGE TO REVERT BACK DB2AUTOSTART REGISTRY VARIABLE BEHAVIOUR WITHIN DB2ICRT AS WAS IN DB2 VERSION 9.7
IC90826 3 CREATE OR REPLACE FUNCTION CAN REPLACE A SYSTEM-GENERATED CAST FUNCTION FOR A DISTINCT TYPE
IC90103 3 DB2SETUP FAIL WITH ERROR "TSA BINARY VALIDATION FOR NON SD HAS FAILED" EVEN IF TSAMP FEATURE IS DISABLED
IC91304 3 PACKAGEAUTH CONTAINS RECORDS WITH GRANTEE='SYSIBM' AND GRANTEETYPE='S'
IC92482 3 DB2IUPDT MAY SET DB2AUTOSTART TO YES.
IC89202 3 ADDING A MEMBER/CF USING DB2IUPDT -ADD MAY GENERATE AN ERROR IN THE DB2IUPDT LOG
Fix Pack 3   -    JDBC Driver
IC98624 2 FIXES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ SHIPPED WITH DB2 V101 FIXPACK 3
IC90437 3 TYPE 2 JCC DRIVER CONNECTED TO DB2Z RETURNS SQLFEATURENOTSUPPORTEDEXCEPTION (SQLCODE -4450) ON A SETQUERYTIMEOUT( ) CALL
IC91262 3 USING TYPE 2 JCC DRIVER, INTEGER DATATYPES GET INSERTED WITH INCORRECT VALUES
IC91171 3 INCORRECT PARSING OF TWO SINGLE QUOTES IN A CALLABLE STATEMENT AGAINST Z/OS T4 CONNECTIVITY
IC94485 3 FAILBACK TO PRIMARY DOES NOT OCCUR WHEN USING CLIENT AFFINITIES WITH AFFINITY FAILBACK INTERVAL
IC90686 3 ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN RUNNING AGAINST DB Z/OS WITH PUREQUERY IN STATIC EXECUTION MODE
IC88582 2 -401 RECEIVED FROM DB2 SERVER WHILE UPDATING A SMALLINT COLUMNWITH SETBOOLEAN METHOD
IC92105 3 JCC DRIVER DOESN'T CLOSE NON XA TRANSACTION (WITH AUTO COMMITON) IN CASE OF EXCEPTION IN EXECUTION
Fix Pack 3   -    MQListener
JR47914 2 MAY ENCOUNTER MEMORY ERROR IN DB2DIAG.LOG RANDOMLY WHEN RUNNING MQLISTENER
Fix Pack 3   -    Monitoring
IC92891 1 LOCKING EVENT MONITOR CONTAINS INVALID DATA IN PARTICIPANT_ACTIVITIES WHEN PARTICIPANT IS COMPILING SQL
IC91277 2 DB2 APPLICATION MIGHT BE STUCK IN "COMMIT ACTIVE" STATUS.
IC93638 2 ADMIN_MOVE_TABLE REDIRECT AND CLEANUP OPERATION RETURNS WITH SQL2102N RC33, WHEN IT FAILS TO ACQUIRE THE SEMAPHORE WITHOUT RETRY
IC90281 2 CHANGE HISTORY EVENT MONITOR CAN CAUSE INSTANCE ABEND WHEN USINGLOAD FROM CURSOR WITH LONG SQL
IC91475 2 TRAP IN MON_GET_PKG_CACHE_STMT IN SD OR DPF ENVIRONMENT IF EXECUTING WHILE A MEMBER IS STOPPING
IC90784 2 INSTANCE MAY TRAP WITH SIGSEGV IN MONITORING CODE DURING DATABASE MANAGER SNAPSHOT COLLECTION AND ACTIVE AIC PROCESSING
IC91753 2 ADMIN MOVE TABLE ON TABLE WITH VIEWS - GRANTS NOT PRESERVED ON VIEWS WHEN AUTO_REVAL IS DISABLED OR NO_AUTO_REVAL IS SPECIFIED
IC91616 2 NULL VALUES OR EMPTY STRINGS IN MON_GET_MEMORY_POOL() COLUMN MEMORY_POOL_TYPE
IC89816 2 SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS PERFORMS POORLY FOR TABLE OBJECTS ON LARGE DATABASES
IC91495 2 ACTIVITYSTMT TABLE OF ACTIVITIES EVENT MONITOR DOES NOT CAPTURE SQL STATEMENTS COMPILED USING THE REOPT ALWAYS BIND OPTION
IC89151 2 FILE EVENT MONITOR LEAKS PRIVATE MEMORY WHEN FAILING TO WRITE OUT EVENT HEADER
IC95141 2 THRESHOLD VIOLATIONS EVENT MONITOR IS MISSING DATA FOR SOME COLUMNS
IC93177 2 STOPPING A FILE EVENT MONITOR MAY CAUSE DB2 TO MARK DATABASE BADAND BRING INSTANCE DOWN
IC91279 2 REDUCE INPUT PARAMETER BLOB SIZE OF THE DB2 MONITORING UDFS
IC94180 2 ON A PURESCALE INSTANCE TABLE FUNCTION ENV_GET_SYSTEM_RESOURCES CAN TRAP IF A MEMBER IS IN RESTART LIGHT MODE
IC90794 2 ADMIN_MOVE_TABLE FAILS WITH SQL0206N WHEN RANGE PARTITION KEY REFERS TO A COLUMN NAME GREATER THAN 8 CHARACTERS
IC93056 2 SYSPROC.SNAP_GET_DYN_SQL_V95 MAY SOMETIMES FAILS WITH ERROR SQL0430N
IC91854 2 ADMIN_MOVE_TABLE MIGHT PRODUCE TRAP OR FAIL IF ORIGINAL TABLE HAS MORE THAN 100 REFERENCES
IC90069 2 THE PROCEDURE SYSPROC.ADMIN_MOVE_TABLE STRIPS SPACES FROM OR ADDS SPACES TO THE END OF A TABLE NAME.
IC91855 2 MON_GET_PAGE_ACCESS_INFO() CAN END UP WITH SEGV (CRASH/ABORT) OREVENTUALLY MEMORY CORRUPTION
IC91367 2 INSTANCE MAY TRAP IN DB2 V10.1 WHEN STATEMENT MONITOR IS TURNED ON
IC87633 2 THE GLOBAL FEDERATED SNAPSHOTS WILL FAIL IF FEDERATED APPLICATIONS EXIST ON MORE THAN ON MEMBER IN DPF AND SD ENVIRONMENTS.
IC91440 3 NEGATIVE NUMBER IS RETURNED FOR PROCESSING TIME OR WAIT TIME COUNTER FROM MON_GET TABLE FUNCTION
IC91322 3 MON_GET_INDEX_USAGE_LIST MAY SHOW 0 VALUE FOR OBJECT_INDEX_LBP_PAGES_FOUND AND OBJECT_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP
IC90911 3 DEACTIVATE EVENT MONITOR MAY CAUSE MISLEADING SQLO_INTRP ERRORS ON NON-CATALOG PARTITION IN DB2DIAG.LOG
IC87091 3 SYSPROC.ALTOBJ FAILS WITH -204 ERROR FOR LOWERCASE OBJECT NAMES AND -305 ERROR IN DB2_COMPATIBILITY_VECTOR
IC92831 3 LOCKING TABLE EVENT LOCKING MONITOR SHOULD USE NULL VALUES WHEN DATA IS UNAVAILABLE
IC89502 3 SQLMTABLEITERATOR::EXECUTE SQLM_RC_MON_BUFFER_FULL ERROR MESSAGESHOULD NOT BE RAISED IN DB2DIAG.LOG
IC88745 3 THE UNIT FOR MEMORY_POOL_USED AND MEMORY_POOL_USED_HWM SHOULD BEIN KB
IC96026 3 DYNAMIC SQL SNAPSHOTS MAY EXIT WITH SQLO_DBCSTRUNC ERROR
IC88994 3 CHANGING SQM___DELETE_SQLMON_STMT DB2DIAG.LOG ERROR TO INFORMATIONAL
IC94387 3 MICROSECONDS PORTION IN RESOLUTION_TIMESTAMP IS ALWAYS 0
IC96273 3 DYNAMIC SQL SNAPSHOTS MAY EXIT WITH SQLO_DBCSTRUNC ERROR
IC91715 3 SYSPROC.REORGCHK_IX_STATS STORED PROCEDURE CALL FROM A CLI APPLICATION FAILS WITH SQL0440N
IC93690 3 PARTIAL EVENT MESSAGES LOGGED IN DB2DIAG.LOG FROM EVMON_FORMAT_UE_TO_XML TABLE FUNCTION
IC92325 1 AND, OR OPERATORS MAY CAUSE -104 ERRORS IN PL/SQL INITIALIZER EXPRESSIONS
IC89879 2 SQL0480N WITH ASSOCIATE RESULT SET LOCATORS INSIDE EXCEPTION HANDLER WHEN SQLCODE > 0
IC92134 2 SQL0471N IS RETURNED UPON CALLING LANGUAGE SQL ROUTINES AFTER MIGRATION OF 32-BIT DATABASES TO 64-BIT VERSION
IC89949 2 INSTANCE TRAP IN SQLRXCON_SIMPLE()
IC89606 3 CREATE TYPE STATEMENT FAILS WITH -104 WHEN USING A QUALIFIED OBJECTTYPE VALUE
IC91825 3 "SQLCODE" VARIABLE MAY HAVE AN UNEXPECTED VALUE (0) WHEN A STORED PROCEDURE IS BEING DEBUGGED IN IBM DATA STUDIO.
IC90349 3 SQL0104N WHEN CREATING A VARIABLE CALLED PIPE IN PL/SQL STATEMENT
Fix Pack 3   -    Platform Specific
IC92793 1 THE DB2MSCS UTILITY FAILS TO CLUSTER A DB2 ESE INSTANCE ON WINDOWS SERVER 2012
IC89859 1 DB2 MAY ABEND WHEN USING DB2 TEXT EXTENDERS
IC92158 2 TIMESTAMPS MAY NOT REFLECT DAYLIGHT SAVINGS TIME CHANGES IN CERTAIN SITUATIONS
IC94172 2 DB2 ON AIX UNABLE TO FIND USER WHEN USING TRANSPARENT LDAP.
IC90242 2 EXCESSIVE MEMORY USAGE WITH XML SYSTEM TEMPORARY TABLES
IC90531 2 DB2 WINDOWS MESSAGE : ZRC=0X870F0002=-2029060094=SQLO_BPSE "DEBUG LOGIC ERROR DETECTED" WITH NO FILE SYSTEM CACHE
IC96395 2 SQLOGETFSATTRIB() FAILS TO REPORT THE CORRECT FREE DISK SIZE OF A DISK VOLUME THAT IS ON A JUNCTION POINT.
IC95167 2 TIMESTAMPS MAY NOT REFLECT DAYLIGHT SAVINGS TIME CHANGES IN CERTAIN SITUATIONS
IC94305 2 EXCESSIVE MEMORY ALLOCATION FOR DBMS MEMORY SET ON SOLARIS / SPARC ARCHITECTURE
IC87527 2 DB2START DOES NOT REPORT AN ERROR WHEN DB2CKPWD FAILS TO START IN LOW MEMORY LINUX SERVERS
IC92031 2 POSSIBLE CRASH (ABORT/SEGV) WHEN RUNNING OUT OF MEMORY BECAUSE OF RECURSION CONSUMING UP THE STACK
IC93472 2 STMM UNNECESSARILY DECREASES CONFIGURATION WHEN 0 BENEFIT DETECTED
IC91193 2 DB2VEND PROCESS CAN FAIL TO ATTACH SERVER (DATABASE MEMORY SET) SHARED MEMORY SEGMENT (SQLO_ADDR_CONFLICT IN DB2DIAG.LOG)
IC91288 2 DEADLOCK CAN BE HAPPEN BETWEEN THE IBM INFORMIX CSDK ODBC DRIVERAND THE IBM DB2 DATASERVER DRIVER WHEN USED IN THE SAME APP
IC89716 2 A VALID DOMAIN USER OF A DOMAIN GROUP WITH CONNECT PRIVILEGE GETS CONNECTION DENIED IN CASE OF GERMAN CHARACTER
IC94382 2 STORED PROCEDURES RANDOMLY FAILS WITH ERROR SQL1124N
IC96276 2 WINDOWS ONLY: DB2PD WITH DB OPTIONS MIGHT RETURN BLANKS ONLY.
IC90190 2 PARALLEL MODE OF DB2_ALL AND RAH CAN LEAVE PROCESSES LOOPING FOREVER SINCE DB2 V9.7 FP6, REGRESSION OF APAR IC81335
IC91228 2 AFTER A CRASH IN TSMAPI64.DLL, SUBSEQUENT DB2START FAILS.
IC91287 2 SQLE_ZRC_CTX_NO_CTX MIGHT BE REPORTED IN DB2DIAG.LOG
IC90501 3 OSSGETDISKINFO REPORTS THE ERROR MESSAGE IN DB2DIAG.LOG ABOUT FILESYSTEMS NOT RELATED TO DB2
IC89705 3 ENABLE_MQFUNCTIONS UTILITY SHOWS UNSUPPORTED PARAMETER "-Q" IN USAGE MESSAGE
IC89615 3 DB2 TRAPPED IN SQLOFREEOSSINTERNALMEMORY
IC92555 3 A FAILURE TO START DB2VEND PROCESS MIGHT RESULT IN SELF-KILLING OF AN INSTANCE
IC87160 3 EXPORT TO PIPE MAY FAIL WITH ERROR SQL3001C
IC91542 3 OVERRIDE VIRTUAL AND OTHER USER LIMITS FOR DB2CKPW DAEMON IN LOWMEMORY LINUX SYSTEMS
IC96271 3 STMM ON 32-BIT INSTANCE PLATFORM MAY FAIL TO UPDATE PCKCACHESZ WHEN IT IS WORKING ON 64-BIT WINDOWS
IC91409 3 WLM THREADS LOSING THEIR ELEVATED PRIORITY WHEN USING DB2_RESOURCE_POLICY FILE WITH SCHEDULING_POLICY ELEMENT
IC91810 3 WLM THREADS LOSING THEIR ELEVATED PRIORITY WHEN USING DB2_RESOURCE_POLICY FILE WITH SCHEDULING_POLICY ELEMENT
IC91728 3 IN DPF ENVIROMENT, DB2 INSTANCE MIGHT BE CRASH (SEGV/ABORT) DURING DB2START
IC96279 3 DB2MSCS FAILS WITH ERROR "THE OBJECT ALREADY EXISTS" WHEN ATTEMPTING TO CREATE A NETWORK SHARE THAT ALREADY EXISTS.
IC91913 3 PREVENT MESSAGE FROM FUNCTION STMMSIMULATEHJPACKPARTITIONS, PROBE:3555, FROM BEING DUMPED INTO DB2DIAG.LOG
IC91703 3 DB2PD -LATCHES OR -APINFO MAY RETURN NO DETAILS IF HOST HAS MULTIPLE ENTRIES IN THE /ETC/HOSTS FILE
IC91758 3 DB2 REPORTS NUMBER OF PROCESSOR CORES WITH INTEL HYPERTHREADING INCORRECTLY (CONTINUATION OF IC81317 )
Fix Pack 3   -    Problem Determination
IC91705 2 DB2DART /RHWM COMMAND FAILS AND REPORTS ERRORS AS IT IS TRYING TO ACCESS NONEXISTING PAGE.
IC94545 2 IN SOME CASES CALLING 'USER-SPECIFIED PROFILE' FROM DB2SUPPORT MAY CAUSE SCRIPT TIME-OUT REGARDLESS OF THE SETTING OF 'TIMEOUT'.
IC87014 2 DATABASE MEMORY SET ID DISPLAYED BY DB2PD -MEMSETS IS NOT CORRECT
IC93170 2 EXCESSIVE MEMORY GETS UTILIZED BY PD_GET_DIAG_HIST
IC91670 2 DB2DART TRUNCATES DBPATH NAMES CONTAINING BLANKS ON WINDOWS AND LINUX
IC91765 2 -MEMBER/-DBP PROBLEMS FOR DB2FODC COMMAND ON DPF
IC91757 2 THE DATABASE FIELD (DB : <DBNAME>) MAY NOT BE RECORDED IN DB2DIAG.LOG FOR EDU: DB2LOGGW ( DATABASE LOG WRITER )
IC90716 2 IN SOME RARE CIRCUMSTANCES THE PD_GET_DIAG_HIST() TABLE FUNCTIONMAY HANG.
IC89927 2 DB2TRC FAILS WHILE LOADING SHARED LIBRARIES LIBCA_API.SO
IC91747 2 DUMP 'DB2PD -DPSDBCD' DATA AND 'DB2PD -DPSPRCB' DATA BY 'DB2FODC-HANG' COMMAND
IC91488 2 DB2SUPPORT -D <DB_NAME> MIGHT HANG BECAUSE OF LOCK HELD BY OTHERAPPLICATIONS ON SYSTEM CATALOG ROWS/TABLES
IC89731 2 PREVENT DB2DART FROM ACCEPTING POOL RELATIVE PAGE ADDRESSES
IC94153 2 TABLE FUNCTION SYSPROC.PD_GET_DIAG_HIST MAY TRAP WITH SIGSEGV WHEN START_TIME/END_TIME PARAMETERS ARE PROVIDED
IC91823 2 CLEANUP OF MESSAGES QUEUES USED TO COMMUNICATE WITH DB2AUD WHEN PROCESS INTERRUPTED BY USER
IC96393 2 SYSPROC.PD_GET_LOG_MSGS FUNCTION CAN FAIL WITH SQL0430N / SQLSTATE=38503
IC94011 2 DB2TOP COLLECTOR MODE (-C) STOPS IF 2GB OUTPUT FILE SIZE IS REACHED
IC91251 2 DB2PD AND DB2PDCFG COMMANDS TERMINATE ABNORMALLY WHEN DB2AUDIT IS ENABLED ON WINDOWS PLATFORM
IC93932 2 DB2 INSPECT: SPACE MAP PAGE INVALID PAGE STATES FOR EXTENT AT LOCATION <NNNN> IN THE SPACE MAP PAGE, EXTENT CONTAINS USED AND NO
IC92866 2 SEND SIGINT, [CTRL]+[C] TO DB2PD MAKES NO NEW CONNECTION
IC94224 3 DB2DART FAILING TO RUN WITH SQLSPCS FILES MORE THAN 2G SIZE
IC95078 3 FFDC IMPROVEMENTS IN PARTITIONED ENVIRONMENTS
IC91799 3 WHEN QUITTING DB2TOP INTERACTIVE MODE USING INTERRUPT KEY '^C', TRAP FILE (*.APP_TRAP.TXT) IN 0 BYTE WILL BE GENERATED.
IC96261 3 PROBLEM WITH HANDLING "\R" CARRIAGE RETURN ON WINDOWS DURING PARSING DB2SUPPORT.PROFILE FILE.
IC93949 3 DB2NODES RELATED ERRORS DURING DB2SETUP/DB2ISETUP
IC91659 3 DB2DART IS NOT DUMPING THE REFERRING PAGE IN AN INDEX CORRUPTIONDETECTION
IC88212 3 WHEN QUITTING DB2TOP INTERACTIVE MODE USING INTERRUPT KEY '^C', TRAP FILE (*.APP_TRAP.TXT) IN 0 BYTE WILL BE GENERATED.
IC90056 3 DB2SUPPORT TOOL WHILE RUNNING IN OPTIMIZER MODE DOESN'T CLEANUP ALL EXPLAIN TABLES
IC91735 3 THE FUNCTION PDEDUISINDB2KERNELOPERATION MAY DETERMINE COMPONENTINCORRECTLY
IC96392 4 KERNEL TID FIELD IS CONCATENATED WITH PREVIOUS TID FIELD IN DB2PD -EDU OUTPUT
Fix Pack 3   -    Process Model
IC88925 1 ON LARGE DPF SYSTEMS, DB2START MAY FAIL WITH SQL0901 ON SOME MEMBERS DUE TO INSUFFICIENT FCM MEMORY
IC91808 2 CALLS TO SQLF_FIX_DBM_CFG BY DOWNLEVEL CLIENT CAN RESULT IN EACCESS IF USER DOESN'T HAVE WRITE PERMISSION TO DB2SYSTM
IC96337 2 DB2STOP FORCE HANGS WHEN INSTANCE IS QUIESCED IN RESTRICTED ACCESS
IC91909 2 DB2 TRAPPED WITH SIGSEGV IN SQLTGETS
IC93744 2 REGRESSION WITH WSDBU0094097; SQLOCLOSE FAILS WITH INVALID FILE HANDLE DURING FIRST CONNECT ON MEMBER SINCE WE ATTEMPT TO CLOSE
IC89727 2 HEALTH MONITOR MAY GET WRONG ACTIVE LOG FILE NUMBER WHEN ONLINE BACKUP WAS ISSUED AND MISTAKENLY ASSUMED FLIPPED OVER BY LOGGING
IC90884 2 DB2 V10.1 DB2INSTANCESTOP() API IS NOT DOWNLEVEL COMPATIBLE, DB2STOPOPTIONSSTRUCT WAS CHANGED
IC90961 2 TRAP IN SQLODSHR CALLED FROM SQLESUBCOORDTERM
IC84775 2 ENABLE NAMED LIST SUPPORT TO ADDRESS SCALABILITY OF DB2 PAGE DELETION FROM THE CLUSTER CACHING FACILITY
IC96272 2 DB2 INTERMITTENTLY CRASHES WITH A MEMORY CORRUPTION WHEN CALLINGSQLERGETFMPIPC
IC91276 2 ON A GATEWAY ENVIRONMENT, CONNECT TO A DATABASE MIGHT FAIL AND THE DATABASE WILL BE MARKED BAD
IC89704 2 DB2PD CAUSED STACK OVERFLOW
IC88374 2 UNCATALOGED STORED PROCEDURE CALLS FROM APPLICATION FAIL INTERMITTENTLY WITH SQL CODE -9999
IC89736 2 FMP TRAP ON SQLOXLTC_APP EXECUTING SYSPROC.SNAP_GET_DB_V97
IC91285 2 DB2 INSTANCE PANICS IN SETUPCTLMSGTARGETS WHEN TRYING TO ACTIVATE EVENT MONITOR WRITERS.
IC96278 2 DB2 MIGHT ENCOUNTER "MEMORY CORRUPTION" ERROR AND THEN PANIC
IC90085 2 FCM_PARALLELISM DBM CFG PARAMETER DOES NOT WORK AS EXPECTED IN DB2 V10.1
IC87355 2 DB2FMP DUMPS A CORE FILE OR CONSUMES CPU USAGE RARELY.
IC91772 2 ACTIVITYTOTALTIME THRESHOLD VALUE BREACHED BUT NOT RECORDED IN THRESHOLD VALUE TABLE
IC91242 2 SQL0973 NO MEMORY IN PACKAGE CACHE WHEN USING INSUFFICIENT FIXEDDATABASE MEMORY SETTING
IC93952 2 THE DB2 INSTANCE MAY HANG OR TRAP ON LINUX WHEN USING A HIGH NUM_INITAGENTS SETTING
IC90789 2 RESTORE DB2_VENDOR_INI REGISTRY VARIABLE
IC89712 2 FENCED WRAPPER GETS HANG SPORADICALLY AFTER -1131 ERROR
IC92927 2 UNNECESSARY INCREASE IN DBMS SET SIZE IN VERSION 10 FOR WORKLOADDISPATCHER
IC91883 2 SYSIBMADM.DBCFG NOT DISPLAYING FLAGS AND DEFERRED FLAGS VLAUE COMPUTED
IC90996 2 SQL0952N : INCORRECT TIMEOUT VALUE OF -1 LEADS TO NODE FAILURES AND INTERMITTENT "LOG STATE MARKED BAD" ERRORS
IC91361 3 SQLCODE -1229 RECEIVED ON DB2LUSED CONTINUOSLY EVEN AFTER A LOT OF TIME HAS PASSED AFTER THE LAST NODE RECOVERY
IC91476 3 INCORRECT PERMISSIONS ON DB2NODES.CFG FILE AFTER FAILOVER
IC90391 3 FOR A NONE PURESCALE INSTANCE, DB2 SHOUD NOT DISPLAY THE VALUE FOR RSTRT_LIGHT_MEM.
IC91759 3 INCORRECT MESSAGE IS DISPLAYED WHEN 'DB2 UPDATE DBM CFG ' IS ISSUED WITHOUT ATTACHING TO INSTANCE
IC96380 3 DB2 PURESCALE WILL NOT START ON REDHAT VERSION 6 IF HOSTNAME IN DB2NODES.CFG AND OUTPUT OF HOSTNAME COMMAND DO NOT MATCH.
IC88874 3 FMP ROUTINE HISTORY BUFFER IS LEAKED ON FAILED FMP STARTUP OR ONTHREADED FMP TERMINATION
IC91720 3 SQL0804N MAY BE RETURNED WHEN A WLM SQLROWSREAD THRESHOLD IS VIOLATED.
Fix Pack 3   -    Quality Assurance
IC92518 2 INSTANCE MIGHT CRASH IF A QUERY THAT FEATURES A SORT IS RE-EXECUTED AFTER IT PREVIOUSY RECEIVED SQL0973.
IC91333 2 XQUERY MAY RETURN INCORRECT RESULT WHEN WHERE CLAUSE PREDICATE HAS CERTAIN FORMAT AND XML INDEX IS USED
IC91770 3 DB2CAEM RETURNS SQL0104 WHEN SQL HAS SINGLE QUOTE
Fix Pack 3   -    Query Compiler Optimizer
IC91811 1 DB2 CAN TRAP WHEN COMPILING A SUB-QUERY THAT IS APPLIED ON XMLQUERY()
IC91848 2 INSTANCE CRASH WHEN DATABASE MANAGER HAS INTRA_PARALLEL SET TO "ON" AND MAX_QUERY_DEGREE IS GREATER THEN 1 OR IS "ANY"
IC95207 2 DB2 COMMAND EDITOR CRASHES WHILE RUNNING VISUAL EXPLAIN
IC91751 2 OPTIMIZER MIGHT CHOOSE NON-OPTIMAL JOIN IN PRESENCE OF CYCLES WHEN DB2_REDUCED_OPTIMIZATION=JOIN IS SET
IC91683 2 SQL0901 ERROR IN DPF WHEN COMPILING A QUERY WITH AN EQUALITY PREDICATE REFERENCING A NULL CONSTANT
IC91291 2 DB2 CAN RETURN A SQL0901N ERROR WITH REASON "SQLNO_ITR_PLAN::NEXT [300]:RC( 0)"
IC92065 2 DB2 CAN TRAP IN SQLRIZZDIMMAX1RUNTIME
IC90915 2 DB2 CAN TRAP IN SQLNO_ZZ_STARJN_COMPUTE_INDEX_QUNS_REFD
IC91223 2 INACCURATE DENSITY AND SEQUENTIAL_PAGES STATISTICS FOR PARTITIONED INDEXES MIGHT LEAD TO NON-OPTIMAL ACCESS PLANS
IC93059 2 RANGE PARTITIONED TABLES DEFINED WITH A NULLS FIRST PARTITIONINGCOLUMN MIGHT RETURN INCORRECT RESULTS
IC93787 2 AUTOMATIC REORG RETURNS SQL2220W ON REORG OF EMPTY COMPRESSED TABLE AND DICTIONARYOPTION="REBUILD"
IC89725 2 DB2ADVIS CAN PRODUCE A RECOMMENDATION OF UNIQUE INDEXES ON SYSTEM-MAINTAINED MQTS
IC96008 2 UNDER RARE CIRCUMSTANCES A QUERY MIGHT FAIL WITH -901 WHEN COMPILING IN SMP
IC91955 2 UNDER RARE CONDITIONS, AUTOMATIC STATISTICS COLLECTION MIGHT NOTOCCUR DUE TO LOST UDI INFORMATION
IC91884 2 "EDU HAS BEEN SUSPENDED" MESSAGE IS RETURNED WHEN USING 'COL IN (...)' PREDICATE
IC91769 2 AUTOMATIC RUNSTATS MIGHT NOT EVALUATE A TABLE IF DATABASE DEACTIVATION OCCURRED WHILE THE TABLE WAS BEING PROCESSED.
IC92016 2 SQL0901 ERROR WHEN EXECUTING AN SQL STATEMENT ELIGIBLE FOR ZIGZAG JOIN STRATEGY
IC89492 2 DB2RUNSTATS API CAN FAIL WITH SQL1197N OR UNEXPECTEDLY EXECUTE WITH INDEX SAMPLING
IC89696 2 LOAD WITH STATS COLLECTION MIGHT GENERATE NLEVEL VALUE AS 0 IN CERTAIN SCENARIO FOR PARTITIONED INDEXES.
IC90321 2 COMPILING CERTAIN SQL STATEMENT IN DPF CAN TAKE A LONG TIME OR RESULT IN SQL0101N
IC90009 2 SMALL PRIVATE MEMORY LEAK ON THE DB2 SERVER EVERY TIME AN OPTIMIZATION PROFILE IS LOADED
IC93132 2 DB2 GET RECOMMENDATIONS FOR HEALTH INDICATOR DB.TB_REORG_REQ ON DATABASE RETURN WRONG RESULTS
IC91281 2 AUTO_RUNSTATS MIGHT TERMINATE EARLY IN FEDERATED DATABASES THAT HAVE BOTH NICKNAMES AND LOCAL TABLES WITH STATISTICS PROFILES
IC91294 2 IN A DPF ENVIRONMENT THE COLLECTION OF SECTION ACTUALS MIGHT SHOW "NA" AT SOME OPERATORS IN THE EXPLAIN OUTPUT
IC93543 2 EXECUTION OF A QUERY USING DB2 TEXT SEARCH MIGHT BE SLOW
IC87037 2 DB2 MIGHT HANG WHILE COMPILING AN SQL STATEMENT ELIGIBLE FOR ZIGZAG JOIN STRATEGY.
IC96285 2 DB2ADVIS MAY FAIL WITH SQL0304N WHEN PROCESSING LARGE INPUT FILES
IC92454 2 A SELECT STATEMENT WITH A PREDICATE 'IN ( ITEM-1, ITEM-2, ... ITEM-N )' MIGHT CRASH THE DB2 SERVER
IC89701 2 CREATE INDEX COLLECT STATISTICS CAN GENERATE INCORRECT EXTERNAL INDEX STATISTICS
IC94478 2 OPTIMIZER COMPUTES INCORRECT CARDINALITY ESTIMATE IN PRESENCE OFSTATISTICAL VIEW WITH OVERLAPPING COLUMN GROUP STATISTICS
IC91299 2 ASYNCHRONOUS RUNSTATS REQUESTS MIGHT BE LOST IN DPF ENVIRONMENTSFOR TABLES THAT DO NOT RESIDE ON THE CATALOG DATABASE PARTITION
IC87969 2 EXECUTION OF SQL STATEMENT WITH DBPARTITIONNUM IS NOT PARALLELIZED WHEN USING TABLE OR LATERAL CONSTRUCT IN DPF
IC91749 2 OPTIMIZER MIGHT CHOOSE A SUB-OPTIMAL ACCESS FOR TABLE WITH THE SAME SINGLE COLUMN RANGE PARTITIONING KEY AND DISTRIBUTION KEY
IC91760 2 A QUERY WITH CORRELATION AND FLOWING XML DATA MIGHT PRODUCE INCORRECT RESULTS.
IC89724 2 IN DPF, XML QUERIES INCLUDING XMLTABLE EXPRESSIONS USING BIND-INHOST VARIABLES CAN RESULT IN BADPAGE ERROR DUE TO A BAD EXECUTI
IC91954 2 UNDER RARE CONDITIONS, AUTOMATIC STATISTICS COLLECTION CAN LEAD TO AN ACTIVE LOG FULL CONDITION.
IC89505 3 AUTOREORG USES INDEX REBUILD OPTION AGAINST PURESCALE SERVER RESULTING IN SQL1419
IC91418 3 USER-DEFINED FUNCTION WITH INDEX EXTENSION EXPLOITATION MIGHT RETURN INCORRECT RESULTS IF INDEX IS NOT PRESENT
IC90427 3 SYSCAT.COLUMNS.NUMNULLS STATISTICS MIGHT BE INACCURATE AT ALL TABLE SAMPLING RATES.
IC96274 3 RUNSTATS ON XML COLUMNS PRODUCES INAPPROPRIATE WARNING LEVEL DIAGNOSTIC MESSAGES.
IC92610 3 DB2 MIGHT TRAP WHILE COMPILING AN SQL STATEMENT ELIGIBLE FOR STAR JOIN
IC96244 3 PAGE_FETCH_PAIRS AND AVGPARTITION_PAGE_FETCH_PAIRS STATISTICS CANNOT BE CLEARED BY MANUAL UPDATE IF VARCHAR2 COMPATIBILITY IS ON
IC90180 3 RUNSTATS SAMPLING MIGHT BEHAVE INCORRECTLY IN DPF ENVIRONMENTS
Fix Pack 3   -    Query Compiler QGM
IC90517 1 ERROR SQL0171N WHEN CASTING DBCLOB COLUMN INTO CHAR OR VARCHARUSING SCALAR FUNCITON
IC95130 1 MERGE STATEMENT WITH ONLY MATCHED CONDITION AND DISTINCT MIGHT LEAD TO PERFORMANCE DEGRADATION
IC91784 1 ERROR SQL0171N WHEN CASTING DBCLOB COLUMN INTO CHAR OR VARCHARUSING SCALAR FUNCITON
IC92765 1 CREATING STORED PROCEDURES FROM APPLICATIONS CONCURRENTLY CAN CAUSE DB2 TO CRASH
IC91301 1 A PREDICATE USING CONTAINS FUNCTION ON A COLUMN DERIVED FROM A UNION ALL OPERATION MIGHT RETURN SQL0901N
IC93791 1 DB2 CRASH CAUSED BY PACKED DESCRIPTOR INCONSISTENCY AFTER ALTER TABLE SET TYPE BLOB/CLOB
IC91504 2 AN INSERT, UPDATE OR DELETE STATEMENT ON A TABLE WITH ROW AND COLUMN ACCESS CONTROL ENABLED MAY RESULT IN SQL901N OR SQL1224N.
IC90310 2 DB2 MIGHT ABEND WHEN A QUERY CONTAINS A VERY LARGE NUMBER OF LITERALS/PARAMETER MARKERS/HOST VARIABLES
IC92118 2 INSTANCE CRASH IF A QUERY CONTAINS A SUB-SELECT STATEMENT WHICH INCLUDES ONE OR MORE OLAP FUNCTIONS
IC91293 2 DB2 MIGHT ABEND WHILE EXECUTING A COMPOUND SQL STATEMENT
IC96288 2 ALTER TABLE STATEMENT REFERENCING A TABLE NAME CONTAINING TRAILING SPACES MIGHT PRODUCE SQL0901N
IC91729 2 INCORRECT SYNTAX COMBINATION OF CAST AND DATE FUNCTIONS SUCH AS DAYS, MINUTES ETC CAN CAUSE COMPILER CRASH INSTEAD OF SQL0104
IC92227 2 MEMORY LEAK IN COMPILER MEMORY POOL WHEN COMPILING A SQL QUERY THAT REFERENCES A FEDERATED DATA SOURCE
IC89749 2 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ROWID IS REFERENCED IN A TRIGGER
IC92082 2 POOR QUERY PERFORMANCE IF JOIN PREDICATE APPLIED TO THE FIRST AND LAST COLUMNS OF AN INDEX WITH INTERMEDIATE LOCAL PREDICATES
IC96263 2 QUERY WITH XQUERY/XPATH OPERATORS MAY RUN SLOWER WHEN UPGRADING FROM VERSION 9.5.
IC91788 2 IN2JOIN OPTIMIZATION GUIDELINE IS NOT APPLIED TO REWRITE IN PREDICATE TO A JOIN
IC88128 2 DB2 MIGHT ABEND WHILE COMPILING QUERY WITH MULTIPLE OUTER JOINS AND IS NULL PREDICATE
IC88178 2 -901 ERROR MAY OCCUR WHILE REVALIDATING ROUTINE WITH UNUSED CTE,FOLLOWED BY INSTANCE TRAP AT SQLNQ_FTB.
IC93193 2 AN OUTER JOIN ON A UNION ALL VIEW MIGHT RESULT IN SQL1585N ERROR
IC96253 2 DB2 MAY ABEND WHILE COMPILING QUERY HAVING NESTED OR PREDICATE WITH (NOT) EXISTS SUBTERM
IC89723 2 QUERY WITH OLAP FUNCTION AND SET OPERATIONS MIGHT PRODUCE SQL0901N
IC86717 2 PREDICATES MIGHT NOT BE PUSHED DOWN FOR QUERY CONTAINING UNION ALL AND MULTIPLE NESTED SUBQUERIES
IC91273 2 SLOWER QUERY PLAN CAN BE MADE ON VARCHAR2 COMPABILITY DB IF EQUALITY JOIN PREDICATES ON CHAR OR GRAPHIC COLS WITH HOST VARIABLES
IC89730 2 POSSIBLE PERFORMANCE REGRESSION FROM SCALAR SUBQUERY PUSH DOWN INTO OUTER JOIN
IC89913 2 UNEXPECTED OPTIMIZED STATEMENT FOR VIEW
IC91395 2 THE QUERY COMPILER CAN ASSUME A DEFAULT CARDINALITY FOR A CGTT
IC91303 2 REMOVE REDUNDANT SUBTERM PREDICATE FROM AN OR PREDICATE
IC91738 2 PREDICATE SELECTIVITY CLAUSE MAY NOT TAKE EFFECT IN LEFT OUTER JOIN QUERY
IC94331 2 CREATE FUNCTION FAILS WITH SQL0109 WHEN QUERY INCLUDES "WITH UR"
IC90636 2 DATABASE SYSTEM ERROR 'SQLCODE=-901, SQLSTATE=58004' MAY OCCUR WHILE CREATING PL/SQL PACKAGES
IC89458 2 DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF SIMPLE SINGLE-ROW MERGE STATEMENT
IC89846 2 TABLE MAY INHERIT WRONG COLLATION FROM A CATALOG TABLE OR VIEW
IC91051 2 EXCEPTIONALLY LONG COMPILATION TIME WHILE QUERY CONTAINS GROUPING SETS, ROLLUP OR CUBE
IC88658 2 QUERY CONTAINING "NOT IN" PREDICATE WITH A PARAMETER MARKER MIGHT CAUSE DB2 TO ABEND
IC90465 2 PERFORMANCE DEGRADATION MIGHT BE NOTICED WITH NOT EXISTS SUBQUERY WITH MULTIPLE TABLES.
IC92697 2 DB2 MIGHT PRODUCE INCORRECT RESULT WHEN EXECUTING A QUERY WITH DATETIME PREDICATES
IC89937 2 A MERGE STATEMENT AGAINST AN ALIAS MAY CAUSE DB2 SERVER TO TERMINATE ABNORMALLY
IC94360 2 QUERY CONTAINING EXISTENTIAL SUBQUERIES WITH MULTIPLE TABLES MIGHT HAVE PERFORMANCE DEGRADATION
IC91229 2 SQL FUNCTION DEFINER NOT GIVEN WITH GRANT OPTION (CAN LEAD TO ERRORS LIKE SQL0551N ON LATER GRANT)
IC89714 2 POSSIBLE ABEND DUE TO DOUBLE FREE IN STMTHEAP MEMORY WHEN COMPILING A COMPLEX QUERY WITH MULTIPLE GROUP-BY SUBQUERIES
IC89297 2 QUERIES WITH A NOT EXISTS OR NOT IN PREDICATE, AND A PREDICATE REFERENCING GENERATED COLUMNS MAY CAUSE SQL0901N
IC89237 2 QUERY CONTAINING MULTIPLE EQUIJOIN PREDICATES MIGHT FAIL WITH SQL0901N
IC96264 2 FED:FEDERATED QUERY WITH A LARGE AMOUNT OF COLUMNS COULD EXPERIENCE LONG TIME COMPILATION
IC88197 2 QUERY WITH LEFT OUTER JOIN AND IS NULL PREDICATE MIGHT FAIL WITHSQL0901N
IC90174 2 REROUTING A QUERY TO MQT MAY RETURN INCORRECT RESULT
IC91812 2 QUERY CONTAINING EXISTS SUBQUERY AND FETCH FIRST N ROWS CLAUSE MIGHT PRODUCE INCORRECT RESULTS
IC89750 2 SQL20253N RETURNED WHEN MULTIPLE UPDATES ON THE SAME COLUMN FOR COMPILED TRIGGERS
IC84206 2 QUERIES USING OUTER JOINS AND SCALAR SUBQUERY RUNS SIGNIFICANTLYSLOWER COMPARING TO OUTER JOINS AND LOCAL PREDICATES
IC89439 2 QUERY MIGHT FAIL WITH SQL0901N - BAD PLAN, UNRESOLVED QNC FOUND
IC95053 2 THE QUERY STATEMENT WITH A SUBQUERY PREDICATE MIGHT NOT RETURN ROWS AFTER ENABLING DB2_COMPATIBILITY_VECTOR=ORA
IC89491 2 SQL0206N ERROR REFERENCING COLUMN RETURNED FROM A ASSOCIATIVE ARRAY OR RECORDS ORACLE COMPATIBILITY MODE
IC87433 2 AFTER DATA TYPE IS ALTERED ON A COLUMN WITH DEFAULT VALUE, DDLS AND DMLS MIGHT FAIL WITH SQL0901N "BAD DEFAULT"
IC94328 2 DATABASE UPGRADE FAILS WITH SQLCODE -727 SQLSTATE=56098
IC89912 2 UNEXPECTED OPTIMIZED STATEMENT FOR VIEW
IC91783 2 PERFORMANCE DEGRADATION WHEN SEQUENCE IS PRESENT IN THE SELECT LIST COLUMN
IC91690 2 QUERY WITH NUMEROUS PARAMETER MARKERS IN AN IN LIST HANGS DURINGCOMPILATION
IC91809 2 DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF SIMPLE SINGLE-ROW MERGE STATEMENT
IC96254 2 LOCAL PREDICATES MAY NOT BE PUSHED DOWN BELOW A UNION OPERATOR WHEN THE UNION OPERATOR IS REFERENCED MORE THAN ONCE.
IC94359 2 QUERY WITH EXISTS OR EXISTS PREDICATES MIGHT HAVE PERFORMANCE DEGRADATION
IC96232 2 QUERY ON VARCHAR2 ENABLED DATABASE DOES NOT USE INDEX SCAN
IC96265 2 DB2 MIGHT PRODUCE SQL0901N WHEN USING RATIO_TO_REPORT OLAP FUNCTION
IC91296 2 DB2 MAY ABEND WHILE COMPILING QUERY THAT CONTAINS THE QUARTER FUNCTION
IC91804 2 SET VARIABLE STATEMENT MAY CAUSE DB2 TO TERMINATE ABNORMALLY.
IC91876 2 COLUMN OF XML TYPE WITH INLINE LENGTH OPTION MIGHT CAUSE MEMORY CORRUPTION
IC88471 3 SQL0901N ERROR MAY BE RETURNED WHEN CREATING AN INDEX ON A USER-DEFINED TEMPORARY TABLE.
IC90170 3 DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ROWID IS USED IN AN INSERT OR UPDATE STATEMENT
IC90500 3 QUERY WITH NOT EXISTS PREDICATES MIGHT HAVE PERFORMANCE DEGRADATION
IC91723 3 XMLTABLE() RETURNING MULTIPLE XML NODES MAY RETURN SQL16003N
IC90093 3 QUERY CONTAINING AN ORDER BY CLAUSE REFERENCING AN AGGREGATE FUNCTION MIGHT PRODUCE A SQL0901N
IC96280 3 DIFFERENT BEHAVIOUR IN DB2 WHEN USING ORACLE SYNTAX "CONNECT BY NOCYCLE LEVEL"
IC90655 3 DB2 SERVER TERMINATES ABNORMALLY COMPILING A QUERY WITH EXTENDEDINDICATORS ENABLED
IC91787 3 VALUES STATEMENT CONTAINING THE VALUE NULL MIGHT RETURN SQL901N IN THE PARTITIONED DATABASE ENVIRONMENT
IC89708 3 DB2 RETURNS -901 FOR TARGET TYPE IS NOT TYPED WHEN COMPILING MERGE STATEMENT
IC94356 3 TO_CHAR( CHARACTER-EXPRESSION, FORMAT-STRING ) RETURNS SQL20447NIN VARCHAR2 COMPATIBILITY MODE
IC92186 3 TRANSLATE FUNCTION RETURNS WRONG DATA TYPE WITH MIXED GRAPHIC/NON-GRAPHIC ARGS
IC89584 3 DB2 IS ALLOWING PL/SQL ROUTINES TO BE CREATED WHEN VARIABLES FORTHE CURSOR DO NOT MATCH THOSE IN THE FOR LOOP.
IC90071 4 OUTER JOIN PREDICATE ON EXPRESSIONS USING THE HASH JOIN MIGHT RETURN SQL0901N
Fix Pack 3   -    Relational Data Services
IC92080 1 INSTANCE TRAP IN SQLRR_RDS_COMMON_POST
IC95794 1 DB2 MAY HANG WHEN -901 ERROR IS ENCOUNTERED, YOU WILL SEE MESSAGE "APPLICATION IS ALREADY QUEUED BY A THRESHOLD"
IC91781 2 CALLING A STORED PROCEDURE FROM DB2 V9.7 FP 4 AND HIGHER FIXPACKLEVEL DATABASE SERVER MAY HIT SQL0727N SQLCODE "-7" ERROR
IC94161 2 PERFORMANCE HIT WHEN A GLOBAL VARIABLE IS FIRST REFERENCED IN A SESSION
IC94988 2 "MEMORY LEAK" ISSUE IN PACKAGE CACHE.
IC91307 2 TRANSACTIONS THAT PERFORM IMPLICIT REBINDS CAN CAUSE LOCK WAITS TO OTHER CONNECTIONS DUE TO CATALOG CACHE AND CATALOG LOCKS
IC92602 2 INSTANCE MAY TRAP WITH SEGMENTATION VIOLATION WHEN COMPILATION FAILS DURING IMPLICIT REBIND
IC92106 2 DB2 INSTANCE MIGHT TRAP IF A USER REBINDS A PACKAGE WITHOUT HAVING EXECUTE PRIVILEGE ON IT.
IC96450 2 RUNSTATS SAMPLING MIGHT BEHAVE INCORRECTLY IN DPF ENVIRONMENTS
IC93173 2 PD_GET_DIAG_HIST MAY HIT ERROR "DIA8301C NO MEMORY AVAILABLE IN THE APPLICATION HEAP"
IC91858 2 DURING IMPLICIT REBIND OF AN INOPERATIVE PACKAGE SQL0572 MAY BE RETURNED WHEN AUTO_REVAL = DISABLED
IC91180 4 USING ALL TEN PARAMETERS FOR DB2RBIND RESULTS IN SYNTAX ERROR
IC91952 4 SQL0119N RETURNED WHEN SQLCA USES DIFFERENT PARAMETER MARKERS FOR THE SAME CONSTANT
Fix Pack 3   -    Replication
JR47306 2 WHEN "ENDMQM -W" IS ISSUED, NEITHER CAPTURE, MQ, NOR THE ENDMQM COMMAND EXITS
JR47307 2 WHEN RESTARTING QCAPTURE WHEN AN INVALID SUBSCRIPTION IS ALREADYIN TRANSITION, QCAPTURE COMES DOWN
Fix Pack 3   -    Security
IC94434 1 SECURITY: DENIAL OF SERVICE VULNERABILITY IN DB2's FAST COMMUNICATIONS MANAGER. (CVE-2013-4032)
IC94757 2 SECURITY: UNAUTHORIZED ACCESS TO TABLE VULNERABILITY IN DB2 (CVE-2013-4033)
IC92498 1 SECURITY: STACK BUFFER OVERFLOW VULNERABILITY IN DB2AUD AND DB2FLACC (CVE-2013-3475).
IC91269 2 CONNECTION TO ISERIES USING KERBEROS FAILING WITH SQL30082 RC=36OR RC=4
IC89709 2 APPLICATION MAY RECEIVE SQLCODE -1307 RC 11 DURING DB2AUDIT ARCHIVE PROCESS DUE TIMING HOLE IN AUDIT RECORD I/O
IC94003 2 TRANSPARENT LDAP DOESN?T USE THE CORRECT METHOD TO GATHER THE GROUP MEMBERSHIP ON SOLARIS.
IC91275 3 SQL3119W THROWN DURING LOAD/IMPORT USING DB2AUDIT DEL FILE DUE TO COLUMN TYPE MISMATCH
IC89733 3 DB2AUDIT LOG DOESN'T INCLUDE TABLE NAME OF A LOAD INTO TABLE FORUSERS WITH DATAACCESS AUTHORITY
IC96387 3 EVENT COLUMNS OF ROWS DESCRIBE THE PARAMETER MARKERS OR HOST VARIABLES DOES NOT CONTAIN DATA KEYWORD IN TABLE FORMAT.
IC91280 3 DB2AUDIT LOG DOESN'T INCLUDE TABLE NAME OF A LOAD INTO TABLE FORUSERS WITH DATAACCESS AUTHORITY
Fix Pack 3   -    Text Search
IC92910 1 DB2TS COMMAND RETURN ERROR MESSAGE CIE00756 CONNECT FAILED ON H NAMED "LOCALHOST" AND PORT ..."
IC88213 2 UNABLE TO ENABLE THE 'RICH TEXT SUPPORT' UNDER DB2 TEST SEARCH
IC90054 2 SQLGETDIAGFIELDW() RETURNS THE STRINGLENGTHPTR AS CHARACTERS INSTEAD OF BYTES.
IC94278 2 TEXT SEARCH INDEX UPDATE ERROR "CLI0129E,THERE ARE NO MORE HANDLES TO ALLOCATE" WHEN INDEXING LARGE NUMBER OF DOCUMENTS
IC91174 2 DB2TS PROBLEM FOR TEXT INDEX WITH FORMAT OF INSO
IC96143 2 CHANGE TO ENHANCE ERROR MESSAGE REGARDING MINIMUM FREE SPACE REQUIREMENTS FOR INSTALLATION AND INSTANCE CREATE/UPDATE OPERATIONS
IC93058 3 COMMANDLINETOOLS0.LOG CREATED IN INCORRECT DIRECTORY DURING DB2IUPDT
Fix Pack 3   -    XML
IC88695 1 INSTANCE TRAP WHEN ACCESSING XML BINARY DOCUMENT
IC93900 1 DB2 MIGHT CRASH WHEN YOU ARE INSERTING XML FILE CONTAINING LARGETEXT NODE TO THE XML COLUMN
IC89818 2 INCORRECT RESULTS ON RANGE PARTITIONED TABLE WITH XML COLUMN
IC86917 2 INSTANCE TRAP OR -901 WHEN INSERT OR QUERY LARGE XML DOC
IC89702 2 DB2 XQUERY SHOWS POOR PERFORMANCE DUE TO EXPENSIVE USE OF LARGE XML SEQUENCES.
IC96391 2 SOME XML QUERIES COULD BE IMPACTED BY PERFORMANCE ISSUE ON SOLARIS AND HP-UX PLATFORMS.
Fix Pack 3   -    pureScale Services
IC89726 1 IN A TSA AUTOMATED HADR ENVIRONMENT, AN AUTOMATED HADR FAILOVER OCCURS IMMEDIATELY AFTER THE TAKEOVER HADR COMMAND IS RUN
IC92391 1 IN A DB2 HA ENVIRONMENT, IF DB2HAICU IS SETUP WITH FQHN, DB2START CAN FAIL WITH SQL6048N
IC91816 2 TSA AUTOMATED HADR DATABASE DOES NOT FAILOVER AFTER UNPLUGGING PUBLIC NETWORK CABLE FROM THE PRIMARY SERVER
IC96390 2 HA IS NOT RETRIEVING INFORMATION FROM DB2HA.SYS TO VERIFY
IC90432 2 RUNNING 'DB2HAICU -DELETE' PRODUCES DB2DIAG.LOG ERROR MESSAGES
IC91609 2 DB2GCF -S REPORTS THAT ALL PARTITIONS ARE 'OPERABLE' IF THE DEFAULT PARTITION IS STOPPED.
IC89693 2 AFTER EXECUTING "DB2STOP CF <ID>" COMMAND, A SEVERE LEVEL MESSAGE IS PRINTED IN DIAGLOG FOR ROCMCAGETSERVERUDF
IC89148 2 ERRORS REPORTED TO DB2DIAG.LOG WHEN ISSUING THE "DB2INSTANCE -LIST" COMMAND
IC89528 2 DB2: PRIMARY CLUSTER CACHING FACILITY START FAILED BECAUSE OF RECV_MRB_FAILURE ON THE PSGETSERVERROLE CALL
IC90035 2 DB2 PURESCALE ON AIX - CHANGE LOGGING LEVEL IN MOUNTV10_*.KSH SCRIPTS
IV36997 2 GPFSREADY SCRIPT SPENDS UP TO 5 MINUTES POLLING FOR SSH STATUS
IC88532 2 DB2HAICU FAILS ON SOLARIS WITH "PIPE READ FROM VENDOR PROCESS WAS INTERRUPTED"
IC89721 2 DB2HAICU FAILS ON SOLARIS WITH "PIPE READ FROM VENDOR PROCESS WAS INTERRUPTED"
IC86863 2 DB2HAICU DUMPS ADDITIONAL ERRORS IN THE DB2DIAG.LOG ON TWO ATTEMPTS TO EXECUTE CONFIGURATION
IC92342 2 UPDATING A MEMBER OR CF TO ADD A NETWORK INTERFACE LOSES THAT UPDATED AFTER A REBOOT OR FAILOVER
IC91667 2 MISSING DEPENDENCIES FROM THE DB2 PARTITION RESOURCES TO THE PUBLIC NETWORK EQUIVALENCY
IC87563 2 THE DB2 FAULT MONITOR FAILS TO RESTART INSTANCE AFTER SERVER REBOOT
IC89305 2 THE DB2VXX_MONITOR.KSH SCRIPT MAY FALSELY REPORT PARTITION 0 AS ONLINE
IC89722 2 HADR RESOURCE GROUP REMAINS LOCKED AFTER SUCCESSFUL HADR REINTEGRATION.
IC90232 2 THE 'DB2CLUSTER -CM -CREATE -DOMAIN' COMMAND FAILS DUE TO INCORRECT PERMISSIONS ON THE LIBDB2GPFS.SO FILE
IC89050 2 DB2SET DB2_DISABLE_NETWORK_ADAPTER_ADD=FALSE FAILS WITH ERROR "DBI1302E INVALID PARAMETER DETECTED"
IC95646 2 DB2GCF UTILITY UPDATES THE DB2NODES.CFG TO SHORT HOSTNAME INSTEAD OF FULLY QUALIFIED HOST NAME
IC93924 2 RUNNING "DB2HAICU -DISABLE" DOES NOT UNSET THE "CLUSTER MANAGER"DBM CFG VALUE IF A CLUSTER DOMAIN DOES NOT EXIST.
IC89339 3 DB2GCF MAY ENCOUNTER MEMORY ISSUES WHEN USED WITH ASLR ON LINUX
IC90504 3 DB2HAICU MIGHT GENERATE SEVERAL DB2DIAG.LOG ERROR MESSAGES DURING DOMAIN STARTUP.
IC91786 3 DB2CLUSTER -CFS -ENTER -MAINTENANCE -ALL WILL STOP AIX TRACE VIAMMTRACE STOP.
IC89692 3 SMALL LETTER <DBNAME> DOES NOT WORK IN "DB2CLUSTER -CM -ADD -DATABASE_MOUNTS <DBNAME>" COMMAND.
IC91748 3 AUTOMATIC HADR PAIR REINTEGRATION DID NOT OCCUR AFTER RESTARTINGSTANDBY SERVER
IC91766 3 DB2_DEINSTALL/INSTALLFIXPAK FAILS WITH MINOR ERROR ON RHEL 6 WHILE STOPPING THE FAULT MONITOR
IV48844 3 THE "DB2CLUSTER -CM -REPAIR -RESOURCES" COMMAND SHOULD FAIL IF THE INSTANCE IS STARTED

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

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

[Download DB2 LUW Fix Packs