ftp://ftp.software.ibm.com/ps/pr ... b2_v82/APARLIST.TXT
************************************************************
Product Name : DB2 UDB Version 8
Updated : Thu Dec 21 14:27:17 EST 2006
************************************************************
APAR fixes included in Fixpak 14
APAR No. Abstract
-------- --------------------------------------------------
GG04567 DPROPR - CAPTURE FAILS ON FILES LARGER THAN 2 GIG
GG04661 WHEN RIGHT CLICK THE SUB SET AND CHOOSE 'ADD THE MEMBER', IT GOTNO
RESPONSE IF THIS CAPTURE SERVER IS NOT A DB2 DATABASE.
GG04663 DUPLICATE ROWS IN REGISTER TABLE SCREEN OF REPLICATION CENTER WHEN
COLUMNS ARE SORTED BY NAME + BEFORE/AFTER IMAGE ARE CHECKED
GG04667 DPROPR APPLY HOLDS CS LOCK ON SOURCE CCD TABLE DURING DIFFERENTIAL
REFRESH
GG04676 SHOW APPLY REPORT IS NOT DISPLAYING SET NAME CORRECTLY IN REPLICATION
CENTER.
GG04677 DPROPR RC ASN1562E THE REPLICATION ACTION ENDED IN ERROR. AN
UNEXPECTED ERROR OCCURRED.REF CODE "FR50NP". AGAINST ORACLE 8I
GG04678 DPROPR RC SHOULD SET THE PRNCNTL SYNCHPOINT TO NULL FOR THE SET WHEN
THE SOURCE IS AN AS400 WHEN INITIATING AN AUTOMATIC REFRESH
GG04693 ASNLOAD DOES NOT PICK UP PREDICATES VALUE FROM ASN.IBMSNAP_SUBS_MEMBR
IN FIXPACK13
IY72506 ENABLE JOIN PUSHDOWN THROUGH AGGREGATION TO PUSH JOINS DOWN THROUGH
OLAP FUNCTIONS
IY76435 POOR ACCESS PLANS DUE TO OPTIMIZER IGNORING COMBINED JOIN SELECTIVITY
IY77749 DB2 RESTART DB WITH WRITE RESUME OPTION DOES NOT RESET ALL
WRITESUSPEND FLAGS
IY78650 PESSIMISTIC LOCKING FOR CLI SQL_CONCUR_LOCK NO LONGER WORKING INV8
IY80872 EXTEND THE HEURISTIC WITH COSTING ON THE JOIN RESULT FOR OUTER JOINS
IN ORDER TO DECIDE IF THE REODERING SHALL BE CARRIED.
IY82632 TWO DATABASES WITH THE SAME DATABASE SEED CANNOT BE STARTED AS HADR
STANDBY UNDER THE SAME INSTANCE
IY83500 CLI: SET CURRENT SCHEMA DO NOT STRIP OFF THE SINGLE QUOTES OF
THESCHEMA NAME, IF THERE ARE SOME AROUND IT.
IY84615 "ROLLFORWARD DB DB1 QUERY STATUS" PUTS ERROR IN THE DB2DIAG.LOG.
IY85138 FIRST ACTIVE LOG FILE DOESN'T CHANGE TIMELY IN STANDBY HADR SERVER
IY85162 BINDING WITH DB2CAP FAILS WITH A LARGE NUMBER OF STATEMENTS
IY85488 INDEX SCAN CAN NOT PICK UP START/STOP KEY DUE TO MISSING ONCE-ONLY
COMPUTATION FOR STRING CASTINGS IN SQL COMPILER
IY85495 DB2 CLP DB CFG OUTPUT REPORTS WRONG ROLLFORWARD PENDING STATE
IY85552 EXECUTING AN SQL WITH TOO MANY UNION ALL TAKES TOO MUCH TIME
ANDREMAINS IN A COMPILING STATE FOR A LONG TIME.
IY85895 IMPROVE CARDINALITY ESTIMATES FOR JOINS OVER NON BASE TABLES
IY86315 A REMOTE "LOAD CLIENT" ON WINDOWS RETURNS AN ERROR FOR DEL/ASC FILES
WHEN LOADING TO DB2 ON UNIX.
IY86427 VISUAL EXPLAIN RETURNS AMBIGUOUS DBA3065E MESSAGE
IY86605 SUPPORT THE COMBINATION OF SERVER ON CLIENT AND SERVER_ENCRYPT ON
GATEWAY.
IY86656 WHEN CONNECTED TO Z/OS DB2, PERFORMANCE DEGRADES WHEN PROCESSING AN
ARRAY INPUT FOR DELETE AND MULTIPLE FAILURES OCCUR
IY86689 MESSAGES BEING DUMPED IN THE DB2DIAG.LOG ON THE DLFM SIDE AS ERRORS
BUT SHOULD JUST BE INFORMATIONAL IF THE RC=0
IY86711 UDF EXECUTED WITH FENCED USERID IS ABLE TO ACCESS DIRECTORIES NOT
AUTHORISED TO THE FENCED USER.
IY86760 ADD SUPPORT FOR DESCRIBE ON A DYNAMIC ATOMIC SQL BLOCK.
IY86767 DB2DART/INSPECT REPORTS INVALID ERRORS WHEN OUTER HEADER RESERVED
FIELD IS NOT 0
IY86837 DB2LOOK -L OPTION REPORTS WARNINGS IN THE DB2DIAG.LOG IN FUNCTION
SQLESRSP, PROBE:116.
IY86905 PROVIDER ERROR '80040E5D',PARAMETER NAME IS UNRECOGNIZED.
IY86971 TRAP IN SQLKQOPN DURING BUFFERED INSERT FROM CLI IF DATA FORMAT
ERRORS RECEIVED DURING THE INSERT
IY86986 DB2LOOK DOESN'T GENERATE GRANT STATEMENT FOR SYSTEM GENERATED
SEQUENCES.
IY87008 DLFM: NOT AUTHORIZED TO LINK FILE ERRORS INTERMITTENLY DUMPED IN THE
DB2DIAG.LOG FILE IN A DLFM ENVIRONMENT
IY87035 QUERY PATROLLER HISTORICAL DATA GATHERING MISS RECORDS.
IY87085 IN DPF ENVIRONMENT LOAD WITH TEMPFILES PATH OPTION LEAVES EMPTY
SUBDIRECTORIES IN DB DIRECTORY UNDER LOAD DIRECTORY
IY87131 DB2 WRITING DUMP FILES AFTER SUCCESSFUL EXECUTION OF DB2UPDV8
IY87138 -901 IN REWRITING AN OR SUBTERM WITH A FALSE PREDICATE IN A SUBQUERY
IY87143 WRITE RESUME COMMAND MAY HANG IN SOME SITUATIONS DUE TO A DEADLATCH
IY87153 NUMBER OF EXPORTED ROW IS NEGATIVE
IY87157 MEMORY LEAK MAY OCCUR IN DBHEAP WHEN A CONNECT TO THE DATABASE FAILS
IY87184 CLI CLIENT CRASH IN CLI_UTLCONVERTCP DURING MULTI ROW - ARRAY INSERT
IF CLI KEYWORD WARNINGLIST OR IGNOREWARNINGLIST IS SET
IY87196 DB CRASHES WHEN A TABLE IS ACCESSED THAT WAS DROPPED WITH TRALING
SPACES IN THE TABLE NAME
IY87213 DB2 INSTANCE TRAPS AT SQLEGSCA WHEN RUNNING LOAD OPERATION
IY87288 DB2LOOK ONLY CREATES ONE INDEX IF PRIMARY KEY AND ANOTHER INDEX HAVE
THE SAME COLUMNS IN A DIFFERENT ORDER
IY87303 THE FIRST ROW COST OF A MERGE JOIN CAN BE UNDERESTIMATED BY THE QUERY
OPTIMIZER
IY87382 DB2OSCONF UTILITY NOT SUGGESTING RIGHT VALUES FOR SEMUME
IY87538 V820/AIX5.2ML05 (AIX5.3TL05) FMP PROCESS DEADLOCK/LATCHING ISSUES ON
DB2STOP.
IY87600 WHEN A DATABASE GETS MARKED BAD IN DPF ENV, SOME INTERNAL
COMMUNICATION ERRORS CAN BE ENCOUNTERED.
IY87640 INCORRECT COST CALCULATION IN MERGE SORT JOIN OPERATOR IF PLAN
CONTAINS CARDINALITY ESTIMATE LESS THAN 1
IY87775 DB2 LUW SHOULD SEND DRDA TYPDEVOVR CODEPOINT FOR EVERY EXCSQLSTT
COMMAND IN BATCH UPDATES
IY87800 SIMULTANEOUS IMPORTS CAN BOTH ATTEMPT TO ALLOCATE THE SAME MESSAGE
FILE, MAKING IT APPEAR THEY ONE IMPORT WAS RUN TWICE.
IY87823 CARDINALITY UNDERESTIMATION AT DUPLICATE-ELIMINATING SORT OPERATOR.
IY87847 COST OVERFLOW IN STARJOIN CARTESIAN PLANNING LEADING TO LONG PREPARE
TIME AND FAILING WITH SQL0101N.
IY87922 SQL4410C WHEN STARTING DB2 ADMIN SERVER (DAS)
IY87962 A QUERY USING TEXT EXTENDER UDFS FAILS WITH SQL0443N, WITH DIAGNOSTIC
CODE CTE0198, BUT THE INDEX EXISTS.
IY87973 INTERACTIVE CLP RETURN NO PROMPT WHEN ONLY ENTRY KEY PRESSED DURING
"DB2 (CONT.) =>" PROMPT.
IY87976 EXTRA BLANK LINES AT END OF DB2NODES.CFG CAUSES DB2GOVLG TO FAIL
WITH: DB2GOVLG[136]: HOSTNUM: BAD NUMBER
IY87978 MULTIPLE REFERENCES TO SYSIBM.SYSDUMMY1 COULD RETURN SQL0901N REASON
"BAD PLAN; UNRESOLVED QNC FOUND".
IY87988 PUSH DOWN TO DATASOURCE FOR BINARY COLUMNS IS NOT ENABLED FOR MSSQL
SERVER
IY88139 SQL "NOT DETERMINISTIC" OR "EXTERNAL ACTION" FUNCTIONS MAY NOT BE
ALWAYS RE-EVALUATED IF INPUT PARAMETERS DO NOT CHANGE
IY88160 A QUERY WITH A GROUP BY CLAUSE INCORRECTLY RETURNS A SINGLE ROW
IY88192 DB2 BUILTIN PROC REORGCHK_TB_STATS() OR REORGCHK_IX_STATS() MAY
RETURN WITH RETURN STATUS = 0 BUT WILL NOT PRODUCE ANY OUTPUT
IY88193 HEALTH MONITOR GIVES WRONG REORG RECOMMENDATION FOR MDC TABLE WITH
ADDITIONAL RID INDEX WHEN F4 FORMULA IS EXCEEDED
IY88510 DB2 MAY TRAP IF RESTART DATABASE AND ACTIVATE DATABASE ARE ISSUED
FROM DIFFERENT WINDOWS WITH AUTOSTART EVENT MONITORS
IY88524 LOG_READ_TIME & LOG_WRITE_TIME SHOULD BE IN MICROSECONDS NOT
NANOSECONDS FOR DATABASE WRITE TO TABLE EVENT MONITORS
IY88525 INSTALLFIXPAK RETURNS ZERO DESPITE AN INSTALL FAILURE
IY88550 THREADSAFE JAVA STORED PROCEDURE CAUSES MEMORY LEAK IN DB2FMP
PROCESS.
IY88600 POOR PERFORMANCE IN FIXPAK 13 DUE TO UNDERESTIMATED COST OF AN NLJOIN
WHOSE INNER IS A REVERSE INDEX SCAN
IY88630 INCORRECT COMPARISON BETWEEN TWO FOR BIT DATA STRING VARIABLES IN A
SQL PROCEDURE
IY88633 I/O CAUSED BY SUB-AGENTS ARE NOT ACCOUNTED FOR IN THE APPLICATION
SNAPSHOT
IY88670 THE DB2DIAG.LOG FILE FILLS UP WITH A LOG ENTRY FOR THE
SQLEGETNEXTAPPFORDATABASE() FUNCTION PROBE: 101.
IY88680 "RUNSTATS ... USE PROFILE" IGNORES NUM_FREQVALUES VALUE FOR A COLUMN
IY88683 DB2 V7 USED TO HAVE MAXCONN FEATURE BUT IT WAS REMOVED DUE TO NETBIOS
IS NO LONGER SUPPORTED. THIS APAR IS TO REINTRODUCE IT.
IY88697 [IBM][CLI DRIVER] CLI0191E INVALID ATTRIBUTE VALUE. SQLSTATE=HY0
IY88704 INCORRECT VALUE FOR PERCENTAGE AND TOTAL WORK REPORTED BY LIST
UTILITIES SHOW DETAIL DURING DATABASE BACKUP
IY88721 A DATABASE WILL CRASH IF AUTO STORAGE IS ENABLED AND THE DATABASE
CONFIGURATION PARAMETERS ARE RESET.
IY88753 DOWNLEVEL V7 CLIENTS CANNOT CONNECT TO V8 FP13 SERVER WITH DIFFERENT
"ENDIANS"
IY88766 FP14:THEOREM PROVER CAUSES INFINITE LOOP IN SQLNR_LINK_CONST
IY88823 QUIESCE INSTANCE RETURNS SUCCESSFULLY EVEN WHEN QUIESCE HAS FAILED
IY88864 RENAME INDEX FAILS WITH SQL0803N IF A PACKAGE DEPENDS ON TWO INDEXES,
THEN DROP ONE AND RENAME THE OTHER ONE TO DROPPED ONE.
IY88917 TO INCLUDE THE LOG FILE NO. OF THE MISSING LOG IN THE DB2DIAG.LOG
MESSAGE.
IY88925 TRAP,SQLOCRASHONCRITICALMEMORYVALIDATIONFAILURE,DURING REVOKE ALL ON
BASE TABLE THAT HAS A DEPENDENT MQT CREATED BY ANOTHER USER
IY88926 DB2 FAILS TO CONNECT TO A DATABASE IF USING BSD/LINUX MD5 PASSWORD
ENCRYPTION ALGORITHM ON PLATFORMS OTHER THAN LINUX
IY89012 THE DB2LOOK TOOL CRASHES WHEN GENERATING THE DDL FOR A TABLE ON
COLUMN UNDER A 32-BIT INSTANCE.
IY89110 EMPTY RESULTSET FROM JAVA STORED PROCEDURE RETURNS BLANK IN V8.XVS.
NULL FOR V7.2
IY89132 FAILED REDIRECTED RESTORE OF A DB TO THE SAME INSTANCE CAN DELETE
LOGICAL LOG FILES FROM THE ORIGINAL DB DURING CLEANUP
IY89176 LOCK SNAPSHOT ON THE DB THAT HAS INDOUBT TRANSACTION MAY OUTPUT AS
DIFFERENT APPLICATIONS HAVE LOCKS FOR THE SAME OBJECT.
IY89204 OBJMAINT.DEL FILE INTERMITTENTLY MISSING USERID FOR DB2AUDIT.
IY89215 IF BSU HEAP MEMORY IS EXHAUSTED A TRAP MAY OCCUR IN
SQLEX_SERVER_DEL_USER_CONTEXT
IY89235 QUIESCE/UNQUIESCE COMMANDS THE RETURN DIFFERENT SQLCODE IF ALREADY IN
THAT STATE AND RETURN CODE IS 4.
IY89244 GOVERNOR LOG SHOWS INCORRECT ELAPSED TIME (ET) FOR FORCED APPS.
IY89274 IN EEE, THE OPTIMIZER MISESTIMATES THE SELECTIVITY OF AN IN-TO-JOIN
PREDICATE.
IY89312 IN A MULTI-PARTITION ENVIRONMENT, IF LOAD OPERATION ENCOUNTERS AN
INSUFFICIENT SYSTEM RESOURCES ERROR IN ITS EARLY PREPARATION
IY89354 ERROR -313 (SQLN313) WHEN RUNNING EXPORT FROM DB2 FP13 CLIENT AND
SERVER IS Z/OS DB2 (MVS)
IY89376 DB2LOOK CAN GENERATE INCORRECT "GRANT EXECUTE ON PROCEDURE"
STATEMENTS CAUSING SQL0458N
IY89485 SQL0901N REASON "
ROBE 030 IN SQLKT_PACK_TUPLE(), MSG=COLD=NULLABLE
ZVALUE=NONULLS COL(".) SQLSTATE=58004
IY89488 THE FUNCTION DFM_GET_QUALIFIED_NAME RETURNS THE FSID INCORRECTLY
IY89502 BAD DATA PAGE ENCOUNTERED DURING BUILD PHASE OF A LOAD
OPERATIONAGAINST A MDC TABLE RESIDES IN DMS TABLESPCE IN DPF ENVIRONMENT
IY89591 TRAP IN BCOPY RUNNING AN UPDATE STATEMENT
IY89605 MULTI-PARTITIONED INSTANCE, WITH MULTIPLE ACTIVE DATABASES CAN
POTENTIALLY CRASH WHILE UPDATING DBM CFG MONITOR SWITCHES
IY89612 DON'T CALL CLIENT REROUTE WHEN TWO-PHASE COMMIT PROCESSING
FAILSDURING SPM COMMIT
IY89617 ONLINE REORG COMPLETION STATUS IS NOT UPDATED FROM -1 TO 0 FOR
SUCCESSFUL REOG AFTER A FAILURE
IY89833 THE DB2AUDIT WITH THE EXTRACT OPTION CAN NOT HANDLE AUTHENTICATION
TYPE DATA_ENCRYPT. THE ERROR RETURNED IS AUD0022N
IY89865 MEMORY OVERWRITE OF RESULT SET DATA WITH SQL_ATTR_OUTPUT_NTS SETTO
FALSE AND DATETIMESTRINGFORMAT SET IN DB2CLI.INI FILE
IY90197 RUNNING SNAPSHOT TABLE FUNCTIONS CAN CORRUPT MEMORY INSIDE THE DB2FMP
(C) PROCESS DUE TO STACK OVERFLOW.
IY90322 DB2 FOR WINDOWS 64-BIT DOES NOT INCLUDE 32-BIT LICENSE DLL
IY90430 DB2LANGDIR NOT FOUND ERRORS WHEN EXECUTING INSTANCE COMMANDS, COULD
RESULT IN CONNECT ERRORS DUE TO CODEPAGE NOT SET
IY90463 JDKPATCH is required for US and Canadian DST change commenced in
March 2007. It is embedded in DB2 UDB on Windows V8 FP14.
IY90549 INSTANCE CRASH DUE TO SQLO_EDU_WAIT_TIMEOUT "EDU WAIT TIMED OUT
ERRORS"
IY90635 OPTIMIZER MAY CHOSE REVERSE INDEX SCAN OVER NORMAL FORWARD SCAN
NEEDING A TEMP TABLE AFTERWARDS, CAN LEAD TO BAD PERFORMANCE
IY90679 FCM PROGRAMMING ERROR THAT LEADS TO NODE FAILURE. ERROR INCORRECTLY
REPORTED AS SEVERE.
IY91103 WHEN A QUERY HAS AN IS NULL PREDICATE ON AN EXPRESSION, IT MAY CRASH
DB2 INSTANCE
IY91114 CRASH IN SQLCCGETBUFFER WHEN THE CONNECTION CONCENTRATOR IS ENABLED.
IY91847 SECURITY: REMOTE DENIAL OF SERVICE DURING CONNECT / ATTACH PROCESSING
JR22767 SLOW PERFORMANCE OF QUERY THAT REFERENCES A COLUMN TWICE
JR23133 CONTROL CENTER (DB2CC) RETURNS DEFAULT VALUE DBHEAP AND LOCKLIST
JR23551 RESTORE USING A DB2 64BIT BACKUP IMAGE TO A DB2 32BIT ENVIRON- MENT
FAILS WITH SQL2038 - SQL5130 (HADR_DB_ROLE).
JR23594 DB2FMP PROCESS MAY LEAK MEMORY WHEN KEEPFENCED=YES AND NUMBER
OFCONCURRENT UDF OR SP EXCEEDS VALUE OF FENCED_POOL - WINDOWS ONLY
JR23820 ENTREZ WRAPPER INCORRECTLY PARSING XML DATE FIELDS.
JR23973 SLOW QUERY PERFORMANCE WHEN SELECTING MORE THAN 256 COLUMNS FROMAN
ORACLE SOURCE
JR24071 TRAP ON DB2 V8 SERVER WHEN TRYING TO LOAD FROM V7 OS/2 CLIENT.
JR24217 DB2ADMINMSGWRITE API DOES NOT WRITE PROPER ENTRIES IN THE
NOTIFICATION LOG
JR24289 SQL1882N ERROR WITH BIORS NICKNAME CREATION IF COLUMN NAME IS GREATER
THAN 20 CHARACTERS
JR24290 WRONG RESULTS FOR QUERY WITH WHERE CLAUSE CONTAINING CASE EXPRESSION
WITH IS NULL - QUERY REWRITE OMMITS PREDICATE
JR24292 IMPORTING A VALID STORED PROCEDURE IN DEVELOPMENT CENTER CAN FAIL
WITH UNSUPPORTED DATA TYPE PARAMTERS
JR24296 DB2 OLEDB METHOD GETPARAMETERINFO() IS NOT SETTING *PPNAMESBUFFER TO
NULL WHEN PCPARAMS IS ZERO.
JR24297 POOR PERFORMANCE DUE TO LOCAL PREDICATE NOT PUSHED BELOW UNION
JR24392 APPLICATION HANGS DURING EXPORT OR IMPORT WHEN USING DB2 API FUNTIONS
JR24437 SQL30020N RC=124C WHEN SELECTING A CLOB FROM DB2 V7 ON Z/OS
JR24461 CHANGE ERROR LEVEL FROM "SEVERE" TO "ERROR" IN THE DB2DIAG.LOG
JR24486 INSTANCE CRASH WHEN RUNNING FEDERATED QUERY.
JR24535 SELECT STATEMENT VIA LEGACY JDBC TYPE2 DRIVER MAY GET SQL0104N
JR24604 ALTER_ID NOT RETURNED BY SYSPROC.ALTOBJ PROCEDURE WHEN THE PROCEDURE
EXECUTION RETURNS AN ERROR.
JR24620 TRAP IN SQLRIREL WHEN DUPLICATE COLUMNS ARE REFERENCED IN AN
MATERIALIZED QUERY TABLE. CONTINUATION OF APAR JR23435
JR24633 SELECT TO ACCESS NICKNANAME VIA SQL SERVER WRAPPER CAUSE II TO TRAP
WHEN USER DATAREADER PERMISSION IS REMOVED ON SQL SERVER
JR24668 DB2PD OUTPUT IS TRUNCATED OR HAS ERROR MESSAGES
JR24670 CODEPAGE CONVERSION PROBLEM 0930 UCS2.
JR24675 BACKUP UTILITY DOES NOT SET PARENT DIRECTORY PERMISSIONS FOR BACKUP
SUBDIRECTORIES ON WINDOWS PLATFORMS
JR24683 NOT NULLABLE COL IN OUTER JOIN ON OPTIMIZER REWRITE TO INNER JOIN IS
STILL CONSIDERED NULLABLE AND DOES NOT MATCH MQT.
JR24708 THE DEVELOPMENT CENTER DOES NOT CALL WLM_REFRESH() IF "WLM
ENVIRONMENT" OPTION IS NOT SPECIFIED IN THE SQL SP SOURCE CODE
JR24739 CLI CALL COMMAND FAILS WITH A CLI0118E ERROR WHEN CONNECTED TO A DB2
FOR Z/OS DATABASE SERVER.
JR24769 'G' SHOULD BE ADDED TO THE FRONT OF DOUBLE-BYTE LITERALS IN A CLI
APPLICATION WITH OPTIONAL KEYWORD/PATCH VALUE
JR24773 LIKE PREDICATE MAY PRODUCE INCORRECT RESULTS
JR24776 SQL SERVER cannot handle both PACKED DECIMAL and ZONED DECIMAL when
using the IBM OLE DB Provider
JR24784 DPROPR RC ASN1562E THE REPLICATION ACTION ENDED IN ERROR. AN
UNEXPECTED ERROR. REFERENCE CODE "FC14NP".
JR24799 IF ACCESSS TO THE ROOT DIRECTORY IS RESTICTED, DB2STOP WILL FAILTO
STOP THE INSTANCE AND NO MESSAGE IS RETURNED
JR24818 SQL30082N REASON 3 " PASSWORD MISSING " OR SQL1013N WHEN CALLING
GET_DB_CONFIG STORED PROCEDURE .
JR24825 DB2 CAN CRASH ON SQLJSDRDAASCBCOMPLETION WHILST MANAGING DRDA
CORRELATION IDS STACK
JR24859 IN CONTROL CENTER'S STORAGE MANAGEMENT UTILITY, UNABLE TO VIEW
HISTORICAL SNAPSHOT ANALYSIS FOR TABLES
JR24870 QAPPLY - DATA IN IBMQREP_EXCEPTIONS TABLE UNREADABLE FOR CHAR BEFORE
AND AFTER VALUES WHEN CONVERTING FROM CODEPAGE 37 TO 1208
JR24881 CD TABLES NOT GETTING PRUNED WHILE REPLICATING FROM MSSQL TO DB2,
"MODIFY THE PRUNCNTL_TRIGGER BY ADDING "SET NOCOUNT ON:"
JR24911 NAMESPACE PREFIXES DON'T GET RESOLVED WITH APACHE ENGINE.
JR25083 DB2 FAILS TO CHECK IF CONNECTION CONCENTRATOR CAN BE SWITCHED ONWHEN
FEDERATED IS ENABLED.
JR25138 -902 ERROR CAUSED INFORMATION INTEGRATION THREAD DUMP
LI70026 DB2 V7 CLIENT DB2RA CONNECTION IS CLOSED BY DB2 V8.2 FP13 SERVER,
WHEN NO NEW REQUEST IS RECIEVED FOR MORE THAN 2 MINUTES
LI70945 TRAP IN DEFERFORCEDBCONNECTIONS WHEN AUTOMATIC TABLE
MAINTENANCETRIGGERS A BACKUP
LI70947 OPTIMIZER MAY GENERATE NEGATIVE COST FOR ACCESS PLAN WHEN PREFECTH
SIZE IS ZERO FOR TABLESPACE.
LI71019 THE ORDER OF DDL GENERATED BY SYSPROC.ALTOBJ MAY RESULT IN AN
SQL0669N WHEN BOTH A PRIMARY KEY AND INDEX EXIST ON A COLUMN.
LI71094 VALUE OF F2 FORMULA OUTPUT BY REORGCHK_TB_STATS() MAY BE WRONG
LI71314 FALSE WARNING MESSAGE "UNABLE TO FIND LOG FILE FOR LOGARCHMETH1 OR
LOGARCHMETH2" IN DB2DIAG.LOG
LI71339 ADD SUPPORT FOR CASTING BLOB TO VARCHAR FOR BIT DATA
LI71376 SNAPSHOT MONITORING RETURNS INVALID CLIENT PID FOR JCC APPLICATIONS
LI71401 STMTPROFILE IS NOT USED WHEN THE SQL STATEMENT IS WRITTEN IN LOWER
CASE
LI71404 Function sqlr_gtype_to_aud returns unrecognized gtype follow by an
instance crash with SIGSEGV.
LI71416 WITH CONSECUTIVE SNAPSHOTS AGENT_USER_CPU_TIME AND AGENT_SYS_CPU_TIME
MAY GO BACKWARDS IN VALUE.
LI71417 POOL_ASYNC_INDEX_WRITES GREATER THAN POOL_INDEX_WRITES WHICH IS NOT
CORRECT LEADING TO ASYNC WRITE PRECENTAGE > 100%
LI71424 ON MORE RECENT LINUX SOFTWARE LEVELS, DB2'S TRAP DUMP FILES CAN HAVE
AN INCOMPLETE STACK TRACEBACK SHOWN FOR SIGNAL 6.
LI71428 A 'BEFORE UPDATE' TRIGGER PASSING IT AS AN OUT ARGUMENT TO A STORED
PROCEDURE DOES NOT UPDATE TRANSITION VARIABLE'S TARGET VALUE
LI71441 DB2LOOK GENERATES REFRESH STATEMENT FOR USER MAINTAINED MQT
LI71485 WHEN THE GETPWUID_R() RETURNS AN ERROR THE RC PASSED ON BY THE DB2
FUNCTION IS NOT BEING RESET
LI71571 MEMORY LEAK OR GRADUAL SLOWDOWN OF DB2 CLIENT APPLICATION IF ID OF
THREAD EXCEEDS A 32-BIT VALUE.
LI71586 REMOVAL OF INFORMATIONAL MESSAGE REGARDING SYSPLEX MEMBER INFO1 FROM
DB2DISP
LI71587 GATEWAY CRASH IN SQLJRPREPROCESSSETI.
LI71605 ERROR SQL1042C/SQL1131N ON LINUX WHEN CALLING A JAVA ROUTINE
LI71655 DC CONNECTION WIZARD SETS PRECOMPILE OPTIONS AT THE INSTANCE LEVEL.
LI71656 DB2 Connect Server (gateway) V8.2 traps in
sqljGetApplicationIdentifier when servicing downlevel(V7)clients
APAR fixes included in Fixpak 13
APAR No. Abstract
-------- --------------------------------------------------
GG04641 CAPTURE DIES SHORTLY AFTER IT STARTS ON WINDOWS 2003 32-BIT WITHDB2
V8 FIXPAK 11
GG04644 APPLY FAILS WITH SQL0206N ERROR ON THE BEFORE IMAGE OF THE KEY WHEN
THE CONFLICT LEVEL IS 1 WITH LOBS IN A REPLICA SCENARIO
GG04656 REPLICATION CENTER - ASN2222E ON A CONSTRAINT MISMATCH BETWWEN
SOURCE/TARGET TABLES, AND FAILS TO CREATE SUBSCRIPTION.
GG04659 DPROPR RC IMPROVED TO INCLUDE A COLUMN FOR NON_DB2 SERVER WHEN
SELECTING A SERVER IN MANAGE TARGET OBJECT PROFILES
GG04674 ASNLOAD SUPPORT FOR USER TABLE TO COMPLETE CCD
GG04683 APPLY DOES NOT CONNECT TO TARGET SERVER TO EXECUTE 'A' STMT IF NO ROW
IS FETCHED FROM SOURCE.
GG04686 TO CORRECT THE PROMOTE FUNCTION WITHIN THE REPLICATION CENTER TOOL.
IC50030 SPATIAL EXTENDER ERROR AFTER MIGRATE FROM DB2 UDB 8.2 FIXPACK 6 TO
DB2 UDB FIXPACK 11. SQL0440N NO AUTHORIZED ROUTINE NAME..
IY72555 COMPRESSED BACKUPS BECOME PLATFORM DEPENDENT. DB2CKBKP RETURNS
"WARNING: UNABLE TO DECOMPRESS IMAGE FROM DIFFERENT PLATFORM."
IY73258 DB2LOOK CAN CRASH WHILE PROCESSING NICKNAMES
IY78939 EVENT MONITOR IS RETURNING RESULTS FOR 'USERID' WHEN THAT USERID IS
EXCLUDED IN THE EVENT MONITOR STATEMENT.
IY78984 POOR PERFORMANCE FROM UNDERCOSTED MSJOIN PLAN
IY79202 "GET DB CFG" RETURNS SQL1009N WHEN DATABASE CATALOGED AS A CIRCULAR
LOOPBACK IN DATABASE DIRECTORY.
IY79907 INCORRECT INFORMATION SENT TO TSM DURING UNDO PHASE OF RECOVERY.
IY80178 DB2 LOAD COMMAND CAN FAIL WITH "OPEN LOCFILE FOR READ FAILED"
IY81038 SYSTEM HANGS DUE TO THREADSAFE FMP SHUTDOWN FAILURE
IY81418 COMMON - OSSE - OSSHFILE MESSAGES APPEAR IN DB2DIAG.LOG REPEATEDLY
IY81617 DESIGN ADVISOR CAN HANG AFTER MIGRATING TO DB2 V8.2 LEAVING MULTIPLE
JAVAW.EXE PROCESSES.
IY81688 USING DB2IDROP/DB2ISTOP FOR THE 64BIT INSTANCE ON AIX 5.3, LOAD ERROR
MESSAGE IS DISPLAYED, BUT IT WORKS CORRECTLY.
IY81698 A DB2MOVE EXECUTED RIGHT AFTER A RESTORE DATABASE MIGHT FAIL WITH
SQLCODE -3015 AND SQL ERROR -501
IY81818 ON A EE AND MAX_LOG > 0 YOU RECEIVED SQL0964C INSTEAD OF SQL1224N.
IY81913 MPP ONLY : EXPORT PERFORMANCE DEGRADATION AFTER UPGRADE TO V8.2 FP8
WHEN RAN FROM NON CATALOG NODE
IY81924 STANDY DB DEACTIVATED AND HADR STATUS ON PRIMARY CHANGED TO
"DISCONNECTED" AS A RESULT OF EXTENSION FAILURE ON STANDY SITE.
IY82103 TERADATA WRAPPER DOES NOT PUSH DOWN THE WHERE CLAUSE WITH IN LIST
MORE THEN 255 ITEMS.
IY82140 IN HADR, THE COMMUNICATION FAILURE BETWEEN THE PRIMARY AND THE
STANDBY HAS A LITTLE CHANCE TO BRING THE PRIMARY DB DOWN.
IY82473 TASK SCHEDULER DOES NOT START SCHEDULED JOB INTERMITTENTLY UNDERVERY
HEAVY LOAD.
IY82984 INPLACE REORG AGAINST AN ACTIVATED EVENT MONITOR TABLE HANGS ANDCAN
NOT BE FORCED.
IY83138 DB2DISP PROCESS MAY WAKE UP TOO OFTEN.
IY83152 SQLEATTCHTOCTX() CAUSES A CRASH DUE TO A SIGSEGV WHEN USED IN A
MULTI-THREADED APPLICATION
IY83184 DEFAULT FOR MAX_COORDAGENTS IS INCORRECTLY DISPLAYED BY CLP AS
(MAXAGENTS - NUM_INITAGENTS) FOR NON-PARTITIONED ESE INSTANCE
IY83275 SQL1042C ON CONNECT OR ACTIVATE OR CRASH RECOVERY OF A DATABASE WITH
" UNEXPECTED SIZE FOR <LOGFILE> " MESSAGE
IY83305 POSSIBLE CORRUPTION OF DB2TSCHG.HIS FILE ON HITTING A DISK FULL
CONDITION.
IY83341 TRAP IN OSSSNPRINTF DURING REORG INDEXES.
IY83363 THIS APAR RESOLVES MISORDERED VARGRAPHIC ROWS IN SORT.
IY83454 THE RID COMPARISON FUNCTION IS INCORRECTLY SETUP FOR UNIQUE INDEXES
WITH INCLUDE COLUMNS.
IY83504 REPLICATED TABLE NOT USED WHEN STATEMENT IS NOT A SELECT STATEMENT.
IY83539 CRASH AT THE FUNCTION SQLNR_OJ_REORDER_FOR_MAXIMAL_PUSHDOWN
IY83545 AFTER A SPLIT MIRROR BACKUP DB2 INCORRECTLY DETERMINES MINIMUM ALLOWD
PIT FOR ROLLFORWARD ON STANDBY IMAGE - DPF ONLY
IY83547 A LARGE DATA DESCRIPTOR GENERATED BY THE DRDA APPLICATION REQUESTER
WILL BE REJECTED WITH CLI0108E AND SQLSTATE 40003.
IY83788 ONLINE BACKUP HANG WHEN DB2BM RUN INTO LOG FULL SITUATION DURINGDOING
ONLINE BACKUP
IY83826 APPLICATION STATUS MAY SHOW AS UOW EXECUTING WHILE IT IS BEING ROLLED
BACK TO SAVEPOINT.
IY83840 EXTEND PREDICATE FACTORIZATION AND GENERATE IMPLIED PREDICATES IN
CASES WHERE THERE IS SELF-JOIN PREDICATES
IY83895 CHANGING INSTANCE PATH RESULTS IN -444 ERRORS WHEN CALLING STORED
PROCEDURES
IY83961 VERY SMALL CARDINALITIES CAN BE INCORRECTLY HANDLED, LEADING TO
SQL0437W, RC=3 OR RC=4
IY83989 PARTITION CRASHED DB MARKED BAD
IY84009 REMOVE REDUNDANT PREDICATE IN REWRITE PHASE FOR OUTER JOINS
IY84067 INSTANCE CRASH IN SQLOGMBLKEX CALLED BY RECURSIVE_QGM DURING
DB2SUPPORT -SF OR .DB2SERVICE
IY84131 DB2LOOK RETURNS SQL0104N WHEN THE NAME OF THE TABLE INCLUDES SINGLE
QUOTE.
IY84157 NESTED FENCED 32-BIT UDF IN 64-BIT INSTANCE SYNCHRONIZATION ISSUE
IY84159 JDBC: SQLGETDATA MAY RETURN BAD DATA WHEN OUT OF MEMORY CONDITION IS
REACHED.
IY84161 SIGNAL 11 IN SQLCCIPCINIT() WHEN CALLING 32-BIT NESTED UDF IN 64-BIT
INSTANCE
IY84169 INCONSISTENT STATISTICS WITH 'CREATE INDEX ... COLLECT STATISTICS'
COMMAND AND 'RUNSTATS' COMMAND WHEN VIEWING THE CATALOG
IY84286 QUERY PERFORMS BETTER WHEN USING UNION ALL INSTEAD OF OR CLAUSE.
IY84403 SOME UPDATES DURING IN-PLACE TABLE REORGANIZATION COULD CAUSE
DATABASE FAILURE OR CORRUPTION
IY84404 NEW REGISTRY VARIABLE VALUE DB2_REDUCED_OPTIMIZATION=LIMIT_CART TO
IMPROVE PERFORMANCE FOR SOME QUERIES WITH CARTESIAN JOINS.
IY84499 THE OPERATION TO 'REFERENCED TABLE' MAY CHOOSE AN POOR PLAN .
IY84591 POSSIBLE HANG WHEN THE CACHE BECOMES FULL WHILE TRYING TO CLEAN UP A
DEFUNCT CACHE ENTRY FOR WHICH AN APP STILL HOLDING A LOCK
IY84595 ENSURE IDLE APPS ARE NOT ACTED UPON BY THE GOVERNOR IF THEY ARE NOT
THE COORDINATOR
IY84661 DB21016E WHEN CALLING STORED PROCEDURE WITH 16+ PARAMETERS FROM CLP.
IY84776 -901 WITH "SQLRIMSO: START" MESSAGES LOGGED WHEN RETRIEVING
LONGVARGRAPHIC DATA
IY84899 THE GETCOLUMNS FUNCTION ONLY RETURNS THE FIRST 18 OF 22
METADATACOLUMNS.
IY84906 INLIST TO NLJOIN TRANSFORM STILL INCLUDES PREDICATE INLIST IF RAND
FUNCTION PRESENT
IY84913 HEALTH SNAPSHOT / HEALTH CENTER / REORGCHK SUGGEST REORG ON AN
NON-CLUSTER INDEX WHEN A CLUSTER INDEX EXISTS.
IY84966 SQLDXALLOCBSEGFORTHISPAGE, PROBE:869. GETTING A LOB ERROR IN
DMSTABLESPACE
IY85062 DATABASE CAN CRASH DURING ONLINE TABLESPACE PIT ROLLFORWARD IN AMULTI
PARTITION ENVIRONMENT ON ONE NODE
IY85064 SQL1035N RETURNED FROM ROLLFORWARD DATABASE COMMAND IN A PARTITIONED
ENVIRONMENT
IY85072 FILESYSTEM FULL WHEN RUNNING DB2'S TABLE SNAPSHOT UDFS.
IY85122 BAD PAGE ERROR DURING/AFTER A ROLLFORWARD THROUGH A LOAD-RESTART WITH
'COPY YES' RECOVERY
IY85123 OPERATION FAILS WITH SQL0955N (INSUFFICIENT SORT MEMORY) DUE TO
INVALID MEMORY CALCULATION FOR SORT MERGE PASS
IY85133 SQL0443 ON ROUTINE ALTOBJ WITH DIAGNOSTIC TEXT SQL104 WHEN TABLEHAS
INDEX AND LOCALE IS SET TO A NON ENGLISH LANGUAGE LIKE DE_DE
IY85134 FOR THE ALIAS OF NICKNAME, DROP NICKNAME LEADS TO INSTANCE CRASHAND
ALTER NICKNAME LEADS TO SQL0901N ERROR
IY85136 INSTANCE CRASH IN QUERY REWRITE PHASE OF SQL STATMENT COMPILATION
IY85139 WHEN USING MULTICONNECT=3 IN THE DB2CLI.INI A LOCKOUT TIMEOUT RESULTS
WHEN 2 DISTICT SELECT FOR UPDATES RUN ON DIFF CONNECTIONS
IY85171 SQL0181N return when import of EXPLAIN_OBJECT table due to timestamp
type has ZERO value.
IY85172 REORGCHK INCORRECTLY RECOMMENDS REORG FOR F5 FORMULA ON MDC TABLES
THAT ARE SPREAD OVER MULTIPLE PARTITIONS.
IY85190 PROVIDE SUPPORT OF SYBASE VERSION 15.0 WITH DB2 II
(INFORMATIONINTEGRATOR) V82.
IY85199 THE OUTPUT OF SORT MAY BE UNDERESTIMATED BY THE OPTIMIZER, WHEN UNION
ALL VIEW IS INVOLVED IN A QUERY.
IY85211 INCORRECT CONVERSION VARCHAR FOR BIT DATA PARAMATERS TO IN CLAUSE
IY85284 THE MINM IS NOT CALCULATED CORRECTLY
IY85320 DB2 FAULT MONITOR ( FM ) FAILS TO SEND E-MAIL NOTIFICATIONS WITHDIAG
LOG ERROR -22295 FROM FMEMAILNOTIFY
IY85352 A RESERVE OUTER HASH JOIN PLAN IS INCORRECTLY CHOSEN WHEN A
JOINCONTAINS A NULLABLE COLUMN
IY85366 A QUERY ON A UNION ALL VIEW WITH HOST VARIABLE OR PARAMETER MARKER
GETS A 901 ERROR "NO ROOT FOR POST ORDER CURSOR"
IY85368 DB2ADVIS CAUSES ENGINE CRASH
IY85419 DATABASE HANG DUE TO MISSING TIMEOUT DURING CONNECT RESET.
IY85455 MDC ROLLOUT MAY TRAP WHEN ONLINE INDEX CREATION ROLLBACKS.
IY85499 DB2CKBKP UTILITY WILL NOT DETECT CORRUPTION IN SQLSPCS FILE IN THE
BACKUP IMAGE
IY85577 DB2HMON PROCESS WILL SEGV ON SOLARIS 10 WITH SOLARIS PATCH 119963-04
IY85616 MAPPING -1224N ERROR TO -30081N FOR SIEBEL APPLICATION.
IY85655 LOG FILE NAME IS NOT GIVEN WHEN DB2LOGMGR PROCESS CAN NOT LOCATE IT.
IY85702 TABLESPACE_CURRENT_SIZE MONITOR ELEMENT MAY REPORT AN INCORRECT VALUE
FOR LARGE TABLESPACE PAGESIZES
IY85746 SUPPRESS INFORMATION DISPLAYED BY DB2PD -LOCKS
IY85772 DB2 PANICS WHEN EAGAIN IS RECEIVED FROM IO_GETEVENTS() IN
SQLOLIOAIOCOLLECT().
IY85782 LIST (DRDA) INDOUBT TRANSACTIONS COMMAND CAUSES SQL1224N
SQLSTATE=55032.
IY85840 INCORRECTLY FEDERATING TO Z/OS WHEN USING CONNECTION CONCENTRATOR MAY
CAUSE CRASH IN SQLJRPOSTCONNECT
IY85855 MEMORY TRAP IN DB2ADVIS AND IN EVALUATE AST MODE. ALSO, NEGATIVECOST
BENEFIT IN MDC RECOMMENDATION MODE.
IY85887 SQL0960C ERROR RETURNED WHEN USING DGTT'S IN AN XA ENVIROMENT
IY85889 V8 CLIENT RETURNS SQL0444N WHEN RUNNING DB2EXPLN AGAINST A V9 SERVER
IY85897 DB2 MAY CRASH IN SQLNG_BUILD_SQLD_VALS_OBJ WHILE COMPILING A QUERY
IY85946 APPLICATION HANG OR SQLCODE -430 WHEN FENCED UDF USED AS ARGUMENT TO
FENCED PROCEDURE
IY85962 AN XA_END REQUEST RECEIVES AN XAER_PROTO ERROR IF CLIENT RE-ROUTE
ACTIVATES AND SUCCEEDS ON THE TRANSACTION.
IY85971 DB IS MARKED BAD WHEN CLOB SIZE EXCEEDS 2G CREATED BY XML2CLOB()AND
XMLAGG() FUNCTION
IY85974 ROLLFORWARD WITH AUTO-STORAGE TABLESPACES AND LOAD LOG RECORDS MAY
TRAP UNDER LIMITED CIRCUMSTANCES.
IY85977 LOAD INTO MDC TABLE TRAPS DUE TO INTERNAL LOGIC ERROR RELATED TOMDC
BLOCK MAP.
IY86027 ROLLBACK OF AN INDOUBT TRANSACTION MAY FAIL or MAY CAUSE DATA orINDEX
CORRUPTION
IY86072 TO ENABLE TRANSFORMATION OF SPECIAL TYPE OF DATE/TIMESTAMP
LOCALPREDICATE TO LET LOCAL COLUMN BE PRESENT AT ONE SIDE ALONE.
IY86076 OVERWRITE OF MEMORY WHEN CORRECTING THE CARDINALITY ESTIMATES TO
ACCOUNT FOR STATISTICAL CORRELATION.
IY86102 CRASH (SIG #11) OCCURS ON DB2START AND/OR DB2LICM DUE TO STACK
CORRUPTION SINCE CHIP_ID IS MORE THAN 128 ON SOLARIS.
IY86158 DB2LOAD() CALL GETS SEGMENTATION FAULT IF THE PIDATADESCRIPTOR IS
NULL AND THE PINULLINDICATORS IS NOT NULL IN DB2LOADSTRUCT
IY86164 SAMPLING STATS CAN CAUSE THE DATABASE TO COME DOWN IN RARE
CIRCUMSTANCES.
IY86184 DSS QUERIES OF TYPE FACT-DIMENSION (STAR JOIN) HAVE BAD PLAN.
IY86189 SYSPROC.ALTOBJ MAY RETURNS SQL0443N ERROR WITH DIAGNOSTIC TEXT
SQL1227 or SQL0100
IY86205 INPLACE (ONLINE) REORG OPERATION CAUSES ROLLFORWARD/CRASH RECOVERY TO
FAIL.
IY86210 INSTANCE TRAP DUE TO MEMORY CORRUPTION
IY86233 DQT0007E ERROR IS RETURNED FROM QP WITH STACK INCLUDING
INVALIDUTF8CHARACTERENCODING, WHILE USING HISTORICAL ANALYSIS
IY86235 OPERATIONS WHICH PURGE PAGES OUT OF THE BUFFERPOOL MAY CAUSE
BUFFERPOOL SLOTS TO LEAK
IY86241 DATABASE MAY BE MARKED BAD, WHEN, DUE TO AN SQL STATEMENT, DB2 IS
PROCESSING A LOB THAT EXCEEDS COLUMN SIZE.
IY86244 INCORRECT CARDINALITY ESTIMATES WHEN USING LIKE PREDICATES WHEREAN
MQT EXISTS
IY86264 POOR PERFORMANCE OF QUERIES THAT CONTAIN MULTIPLE REFERENCES TO AN
OUTER JOIN COMMON TABLE EXPRESSION / VIEW
IY86347 DB2 QUERY COMPILER INCORRECTLY REMOVES A CORRELATED JOIN PREDICATE
LEADING TO AN INCORRECT RESULT SET.
IY86370 SQL0910N INCORRECTLY RECEIVED WHEN ACCESSING A SEQUENCE THAT HASBEEN
ALTERED IN THE SAME UNIT OF WORK
IY86380 ON V8 FP11, STORE PROCEDURE/FUCTION/SQL COULD ENCOUNTER SQL0101N THE
STATEMENT IS TOO LONG OR TOO COMPLEX
IY86390 THIS APAR IS FOR UNIX DATA WAREHOUSE USERS THAT WANT TO SWITCH TO
V5.1 ODBC DRIVER MANAGER AND DRIVERS.
IY86401 BUILD OF XML EXTENDER SAMPLES FAILS ON SUN PLATFORM
IY86415 RUNNING JVM ON SUN PLATFORM MAY TRAP IN ICC.
IY86481 QUERY COMPILATION CRASHES THE INSTANCE WITH THE FAILING FUNCTION,
SQLNO_ANALYZE_COUNTINGSQ
IY86498 POTENTIAL DEADLATCH ON HP DUE TO LACK OF ATOMIC OPERATIONS
IY86508 LIST APPLICATIONS GLOBAL SHOWS BLANK AUTH ID AND APPL. HANDLE IS0
IY86672 INFORMATION DISPLAYED BY THE -MEMPOOLS AND -MEMSETS OF DB2PD DOES NOT
MATCH
IY86682 EVEN WHEN DB2TCP_CLIENT_CONTIMEOUT IS SET, CLIENT REROUTE RETRIES
CONNECTION FOR 10 MINUTES
IY86685 EIGHT OR MORE NESTED SAVEPOINT AND ROLLBACK LEVELS CAN LEAD TO MEMORY
CORRUPTION
IY86688 SQL FUNCTION OR DYNAMIC COMPOUND STATEMENT INVOCATION CRASHES DB2
IY86739 DEFINE SQLLEN AS 64BIT FOR DB2 ODBC DRIVER ON UNIX
IY86749 DB CRASHES WHEN A TABLE IS ACCESSED THAT WAS DROPPED FROM A STORED
PROCEDURE INVOKED FROM ANOTHER STORED PROCEDURE
IY86774 AN OLAP AGGREGATE FUNCTION WITHOUT A COLUMN REFERENCE CAUSES A TRAP.
IY86917 SECURITY: Remote denial of service during CONNECT / ATTACH
processing.
IY86932 A JOIN PERFORMED ON A NICKNAME OF A JAVA WRAPPER ON A STRING COLUMN
MIGHT FAIL WITH AN ERROR MESSAGE.
IY86943 MULTI-BYTE LOB DATA, WITH INCOMPLETE LAST CHARACTER, IS INCORRECTLY
WRITTEN TO OUTPUT LOB FILE.
IY86970 DB2TRC TRAPS WHEN TRACING SQLO COMPONENT SECGETGROUPS().
IY87011 POSSIBLE CORRUPTION WITH REORG OF MDC TABLE.
IY87012 "LOCKS CURRENTLY HELD" DB SNAPSHOT MONITOR VALUE MAY OVERSTATE THE
NUMBER OF LOCKS ACTUALLY HELD.
IY87014 ADO MAY RETURN EMPTY RESULTSET WHEN USING DB2'S OLE DB PROVIDER
IBMDADB2 TO CALL STORED PROCEDURES ON V5R2/V5R3
IY87025 NICKNAMES WILL NOT BE VISIBLE WHEN USING V8.2 CONTROL CENTER TO
ACCESS A V9 VERSION OF A DB2 SERVER.
IY87060 GSE_SHAPE_STP(NTSPECIFIC)SQL QUERY RETURNS GSE3009W
IY87210 DB2 CONNECT COULD TRAP WHEN XA APPLICATIONS RUN THROUGH IT AGAINST
Z/OS SYSPLEX
IY87211 SECURITY: Remote denial of service after CONNECT processing.
IY87233 THE LOAD UTILITY MAY WRITE FEWER RECORDS TO THE DATABASE THEN THE
TOTAL NUMBER OF RECORDS PROCESSED FROM THE DATA FILE.
IY87245 DB2EXFMT EMITS MISLEADING MESSAGES ABOUT MISSING TABLE AND INDEXSTATS
MISSING FOR NICKNAMES/INDEXES
IY87250 LOGS INCREASE AND BECOME FULL AS HMON/AUTO RUNSTATS ARE ENABLED.
IY87292 DLFM GOES DOWN, AS THE FILE TO BE LINKED GETS MODIFIED BETWEEN TWO
PHASES OF COMMIT.
IY87359 FP13: COUNT(UDF W/ EXT ACTION GIVES WRONG RESULT
IY87944 THIS APAR WILL ADD A TIMESTAMP TO THE STANDARD HEADER OUTPUT OF DB2PD
COMMANDS TO CLARIFY THE TIME THE COMMANDS WERE RUN
JR22067 SQL0567N RETURNED WHEN CURRENTSCHEMA CLI KEYWORD IS SET IN DB2CLI.INI
FILE.
JR22198 IMPORT FROM CLIENT RESULTS IN ZRC=0X870F0038 IN DB2DIAG.LOG
JR22405 REQUIRED VALUES FOR EXTERNAL TRIGGER PROGRAM ARE NOT IN THE CLASSPATH
JR22663 IN WINDOWS, ERROR SQL0298N WHEN CREATING A DATABASE WITH AN
UNFORMATTED PARTITION AS A CONTAINER IN "CREATE DATABASE WIZARD"
JR22674 Value of DB2 CFG Parameter HADR_SYNCMODE SHOWN IN CONTROL
CENTERMISMATCHes THE ONE SHOWN IN DB2 CLP OR SNAPSHOT
JR22690 INCORRECT RESULTS FROM MULTIPLE 'GROUP BY' SUBQUERIES WITH SELF-JOIN
AND ALMOST MATCHED PREDICATES
JR22705 DB2SET ON WINDOWS. CORRECTION SO THAT SYSADM WHO IS NOT A
LOCALADMINISTRATOR CAN UPDATE THE REGISTRY.
JR22808 SQL30090 ERROR WITHIN FEDERATED ENVIRONMENT
JR22859 SQL20203N RETURNED AT RUNTIME WHEN INVALID RETURN TYPE WAS SPECIFIED
AT CREATION TIME OF UDF.
JR22911 THE HEALTH CENTER DISPLAYS SENSITIVITY IN MINUTES BUT DOES NOT DO A
CONVERSION FROM AND TO SECONDS RETURNED BY THE API
JR23107 TRUNCATED RESULTS WITH LEGACY DRIVER AGAINST HOST.
JR23159 INSTANCE CRASH WHEN USING FUNCTION LENGTH IN SQL QUERY AGAINST TABLE
WITH SPATIAL EXTENDER FIELD
JR23435 DUPLICATE COLUMN REFERENCE IN AN MQT MAY RESULT IN A TRAP DURING AN
INDEX SCAN IF ONE COLUMN IS IN INDEX AND OTHER IS NOT.
JR23451 SQLDRIVERCONNECT DIALOG DOES NOT PROMPT TO CHANGE PASSWORD
JR23461 COLUMN MAPPINGS GET SCRAMBLED WHEN MODIFYING FILE DEFINITION
JR23490 CLI0102E WHEN USING SQL_ATTR_BLOCK_FOR_NROWS AND FIRST ROW CONTAINS
NULL LOB, AND SECOND ROW CONTAINS NON-NULL LOB
JR23603 NET8 WRAPPER:NICKNAME IS NOT CREATED CORRECTORY WHEN FEDERATED INDEX
USING DOUBLE BYTES CHARACTER FOR INDEX NAME .
JR23609 ROLLBACK IN STORED PROCEDURES MAY CAUSE ISSUES IN UNIVERSAL
JDBCAPPLICATIONS - BUGCHECKEXCEPTION ERROR ON SERVER
JR23641 VERSION 8 VE IS NOT HANDLING NON-ORDINARY IDENTIFIERS FOR OBJECTNAMES
CORRECTLY
JR23719 OPTIMIZER INCORRECTLY RETURN AN SQL0901 ERROR ON A QUERY FOR WHICH AN
MQT IS DEFINED AN THERE IS A COLUMN DEF MORE THAN 1TIME
JR23733 SQL22287 encountered when trying to execute task from task using"Run
Now"
JR23740 Tasks in the Task Center cannot run under an ID that does not have
the "log on locally" user privilege
JR23762 WORKLOAD PAGE DOES NOT POPULATE IF THERE ARE NULL VALUES IN THE
'COMPILABLE' COLUMN OF ADVISE_WORKLOAD
JR23763 THE WORKLOAD EDITOR DIALOG HAS NO PROGRESS INDICATOR
JR23770 OUTER JOIN NOT PUSHED DOWN WITH SERVER TYPE DB2/ZOS
JR23801 FP13: NULLPOINTEREXCEPTION IN EXPORT DIALOG
JR23835 V.8.2FP11 CONTROL CENTER. REDIRECTED RESTORE USING NON-EXISTENT
DATABASE NAME.TABLE SPACE WITH CONTAINERS TO BE REDIRECTED EMPTY
JR23852 LEGACY JDBC TYPE 2 DRIVER, DATABASEMETADATA GET METHOD CRASHES JVM
JR23855 INSTANCE CRASHES IN SQLULMW() WHILE PERFORMING A LOAD.
JR23868 TASK CENTER FAILS TO SEND NOTIFICATION VIA QMAIL SMTP SERVER;
SQL22295 IS RETURNED.
JR23914 DB2 SPATIAL EXTENDER, DELETE ROW ON TABLE WITH INDEX ON SPATIAL
COLUMN GETS SQL1034C
JR23916 CANNOT USE THE REPLICATION CENTER TO REMOVE THE VALUE IN
SEARCH_CONDITION IN ASN.IBMQREP_SUBS.
JR23934 SQL0804N WHEN INVOKING A STORED PROCEDURE AFTER EXPLICITLY BINDING
THE PACKAGE FOR THAT STORED PROCEDURE FROM THE SAME APP.
JR23952 DB2/UDB/DATA WAREHOUSE MANAGER ONLY ANY USER CAN IMPORT TABLES
REGARDLESS OF SECURITY ACCESS
JR23961 IN COMMAND CENTER, EXPLAINING A SQL STATEMENT FAILS WITH ERROR
SQL0010N IF SQL STATEMENT INCLUDES '--' AS STRING.
JR23999 DB2 CONNECT USES IP ADDRESS OF RESYNC SERVER RECEIVED FROM Z/OS
JR24010 ERROR MESSAGE "UNABLE TO FIND THE STRING RESOURCE 3574:......
FAILURE" IN THE INSTALL LOG WHEN V8.2 ESE INSTALLED ON WINDOWS
JR24011 'ASNPWD LIST', APPLY, AND CAPTURE DO NOT WORK ON X86-64 PLATFORMS.
JR24018 CLI APPLICATION CAN TRAP WHEN PERFORMING NON ATOMIC ARRAY INSERTS
WHERE ARRAY SIZE CHANGES FROM SOME LARGE POSITIVE VALUE TO 1
JR24033 ASNCLP FAILS WITH ASN1952E
JR24041 PROBLEMS WITH REPLICATION MONITOR MONPARMS TABLE.
JR24042 CANNOT SET 'MANUAL' LOAD USING REPLICATION CENTER ON AIX
JR24065 SQLURCON() API RETURNS -204 ERROR WHEN A DOUBLE-BYTE LITERAL IS USED
AS THE SCHEMA AND/OR TABLE NAME
JR24100 REPLICATION CENTER/ASNCLP FAILS WITH ASN2125E WHEN CREATING Q-SUB
WITH A VARCHAR FOR BIT DATA COLUMN AND TARGET IS ORACLE
JR24109 CREATE NICKNAME DOES NOT POPULATE CORRECTLY THE DEFAULT VALUE FOR
DEFAULT COLUMN ON SYSCAT.COLUMNS TABLE
JR24123 SHAPE FILE IMPORT INTO WINDOWS , BUT THE SAME SHAPE FILES FAIL TO
IMPORT IN LINUX
JR24139 RUNSTATS COMMAND FAILS ON A DATABASE WITH UCA400_NO COLLATING
SEQUENCE.
JR24148 KEEPDYNAMIC KEYWORD REQUIRED FOR DB2 CONNECT CONCENTRATOR WITH
ISERIES V5R4
JR24151 OLEDB DRIVER PROPOGATES BACK A WARNING SUCH AS A CLI0002W AS AN ERROR
INSTEAD OF AS A WARNING.
JR24152 FEDERATED QUERIES FAIL WITH SQL1101N WHEN DB2_FENCED=Y AND NO USER
MAPS EXIST.
JR24156 WE CAN GET INTO A SCENARIO WHERE CLI_SQLCOMPLETECALLBACK TRAPS
BECAUSE OF THE WRONG PROCESSING IN XA.
JR24202 DPROPR RC SOURCE OBJECT PROFILE IMPROVED TO INCLUDE INDEX PRIMARY AND
SECONDARY SPACE ALLOCATION FOR Z-OS
JR24219 CLOSING COMMAND EDITOR WINDOW DOES NOT CANCEL QUERY
JR24244 WRONG ESTIMATIONS OF THE IOCOST FOR NLJN
JR24301 SQL0438N SQLSTATE=70001 WHEN ISSUING MERGE IN COMBINATION WITH
INSTEAD OF INSERT AND UPDATE TRIGGERS.
JR24322 Q REPLICATION - REPLICATION CENTER WHERE THE ROWID COLUMN IS
NOTAUTOMATICLALY SELECTED FOR Q SUBSCRIPTION
JR24324 Q REPLICATION - THE STATE_INFO COLUMN IN IBMQREP_SUBS TABLE IS NOT
CORRECT WHEN A SUB IS DEACTIVATED.
JR24329 When using DB2 v8 FP12 or DB2 v9 GA, the CATALOG ODBC DATA SOURCE
sometimes fail with error DB21036E.
JR24349 Q REPLICATION - TRIGGERS ARE DROPPED AFTER Q SUB IS DROPPED
JR24376 DB2_MINIMUM_CLIENT_LEVEL CAN BE SET ON V82FP12/HIGHER TO BLOCK V7/V8
CLIENTS LOWER THAN THE LEVELS IN THE REGISTRY VARIABLE.
JR24402 DWC ONLY- TARGET COLUMN THAT DWC GENERATES IS INVALID AND WILL CAUSE
THE CREATE TABLE TO FAIL
JR24403 DWC ONLY- A CANCELLED PROCESS --> MOVE OPERATION WILL NOT FREE THE
LOCK THE GUI USES TO CONTROL ACCESS TO OBJECTS.
JR24406 DB2 USERS ON WINDOWS 64-BIT PLATFORMS MAY NOT BE ABLE TO CONNECTTO
THE DATABASE IF THEY ARE NOT LOGGED ON AT THE CONSOLE.
JR24474 USER SEES STACK CORRUPTION ERROR WHILE EXECUTING A FEDERATED QUERY ON
WINDOWS.
JR24475 Q CAPTURE - CAPTURE CRASHES ON SHUTDOWN IF THERE IS AN ADMIN MESSAGE
IN THE ADMIN QUEUE
LI70024 IF INSTANCE OWNER ISSUES A COMMAND INCLUDING "DB2SYSC" ON STAND BY
NODE, MONITOR SCRIPT RETURNS RC=1, TSA STOPS DB2 UNEXPECTEDLY
LI70935 SIGNAL #11 CRASH IN SQLRIBNO WHEN A STORED PROCEDURE IS CALLED WHICH
INVOKES THE SYSPROC.REBIND_ROUTINE_PACKAGE PROCEDURE.
LI70936 DB2_ALL IN PARALLEL, I.E. DB2_ALL "|| CMD" CAN TAKE UP TO 45 SECONDS
BEFORE RETURNING THE VALUES UNDER LINUX
LI70944 Slow query performance when additive expressions are used in an
equality predicate with UNION ALL partitioning ranges of values
LI70946 ALTER TABLE STATEMENTS MAY RESULT IN TABLE PACKED DESCRIPTOR
CORRUPTION.
LI71166 Dispatcher hang in tcprecv OR DB2 Connect concentrator replays
authorisation info on every transaction
LI71190 DATABASE MARKED DAMAGED DUE TO SORT NOT ABLE TO FIND A TEMPORARY FILE
CAUSING THE INSTANCE TO CRASH..
LI71204 DB2 HANG WHEN WRITING TO INTERNAL LOG BUFFER
LI71213 GENERATE HISTORICAL_DATA COMMAND GIVES ERROR IN QUERY PATROLLER LOG
WHEN RUNNING AGAINST A DATABASE WITH CODEPAGE 1254
LI71224 DB2BATCH NEEDS UPDATING WRT TO PLATFORMS SUPPORTED
LI71226 MULTISELECTABLE PLUGIN MENU DOES NOT GET FULL LIST
LI71250 DURING ONLINE DB BACKUP, DB2LOGTS OR DB2BM MAY GET ERROR ETXTBSY (26)
"TEXT FILE BUSY" WHEN OPENING FILE DB2TSCHG.HIS
LI71254 OPTIMIZER NOT RECOGNIZING ORDERED NLJOIN FOR OUTER JOINS
LI71255 CRASH RECOVERY FAILURE DUE TO CHECKSUM ERROR WHEN READING PAGE 1FROM
LOG FILE WHERE THE CRASH RECOVERY STARTED
LI71256 COALESCE FUNCTION INCORRECTLY DECIDES NULLABILITY ON FIRST VALUEONLY
LI71263 ACTIVATING AN ACTIVATED EVENT MONITOR LOGS ERROR TO DB2DIAG.LOG
LI71265 DB2LOOK CRASHES WHEN GENERATING DDL FOR A VIEW
LI71267 CRASH RECOVERY FAILS AND CRASHES THE INSTANCE. DB2DIAG.LOG SHOWS A
MESSAGE, "RESET TAILINDEX X TO Y"
LI71273 CC RECREATES MQTS FOR DROPPED USER UNDER THE CURRENT USER SCHEMA,
INSTEAD OF THE ORIGINAL SCHEMA.
LI71281 DB2LOOK FAILS TO GENERATE AN MQT TABLE THAT ARE CREATED WITH ALTER
TABLE COMMAND.
LI71285 CRASH RECOVERY FAILS WITH SQL1224N WHILE "
OOL FLAGS ARE NOT VALID"
IS REPORTED IN DB2DIAG.LOG
LI71319 DB2PD -DB <DBNAME> -LOCKS IS DISPLAYING 'INVALID LOCKOBJ' FOR TYPE:
"TABLE PART"
LI71328 ADD MORE DESCRIPTIVE DIAG LOGGING ON MEMORY SEGMENT ATTACH SHMATERROR
SQL1084C
LI71332 DRDA PARAMETER RLSCONV(REUSE) INCORRECTLY SENT DURING DISCONNECT.
LI71334 ONLYUSEBIGPACKAGES=1 DB2CLI.INI KEYWORD STILL REFERENCES A
SMALLPACKAGE FOR CERTAIN SQL STATEMENTS
LI71337 QUERY FAILS WITH SQL0901 IN SQLNQ_FCS
OPULATE_FROM_CD WITH ERROR:
FCS COLUMN DESCRIPTOR POINTER DOES NOT EXIST
LI71340 USING BATCH SQL AND DATA_AT_EXEC TOGETHER IN AN ODBC/CLI APPLICATION
CAN CAUSE PROBLEMS.
LI71343 DB2RBIND DOESN'T FLAG -L OPTION AS MANDATORY
LI71355 DB2 CONNECT INSTANCE TRAPS WITH SIGNAL 11 IN SQLJRLISTTOCONNECT().
APAR fixes included in Fixpak 12
APAR No. Abstract
-------- --------------------------------------------------
GG02577 REPLICATION CENTER CHANGED NOT TO CHECK FOR D TYPE INDEXES WHEN
ADDING A MEMBER, IMPROVING PERFORMANCE
GG02835 DPROPR - CREATE INDEX FAILS WITH ASN1569E IF A TARGET CCD TABLE IS >
18 CHARS
GG03196 DPROPR APPLY CHANGED TO COMMIT AFTER INSERTING RECORDS TO THE TARGET
BEFORE EXECUTING THE SQL AFTER STATEMENT
GG04573 QCAPTURE HANGS AFTER RECEIVING LOADDONE FROM QAPPLY ON RHEL3. THIS
HAPPENS ON JAPANESE CODE SET DATABASES.
GG04649 APPLY SHOULD NOT READ TARGET REGISTER INFORMATION WHEN IT FAILS TO
CONNECT TO TARGET SERVER FOR REPLICA.
GG04651 REPLICATION CENTER - API - GENERATE ALTER STATEMENT DURING PROMOTE ON
AN EXISTING SOURCE TABLE
GG04652 IF SOURCE IS ZOS AND THE REGISTRATION IS ALTERED USING RC TOADD A
BEFORE IMAGE, RCINCORRECTLY GENERATES THIS COLUMN AS NOT NULL
GG04655 ERROR ASN1806E, REASON CODE 16 AND REPLICATION CENTER GUI HANGING.
GG04658 CAPTURE COLD START CAN NOT TRIGGER A FULL REFRESH TO THE WHOLE SET
WHEN NEW MEMBER EXISTS IN THE SET.
GG04664 ASNAPPLY: LARGE SPILL FILE (>2GIG) SUPPORT ON SUN OS
GG04665 64 BIT ASNLOAD SET COMMIT COUNT TO 0 WHEN IT IMPORTS INTO NICKNAMES
GG04666 Q REPLICATION SUPPORT NEEDED ON LINUX AMD64
GG04668 ASN1563E THE REPLICATION ACTION "SERVER INFO OR CONNECTION OBJECT"
GG04669 ASNCLP - DOES NOT ALLOW FOR THE OPTION TO CREATE A SEGMENTED
TABLESPACE FOR CHANGE DATA TABLES ON Z/OS.
GG04671 APPLY REMOVES PID FILE WHEN USER STARTS APPLY MORE THAN ONE TIME,
CAUSING MULTIPLE APPLY INSTANCES RUNNING AT THE SAME TIME.
IY66728 "SIGNATURE TEST FAILURE" ERROR FROM TIVOLI ICC LIBRARY V1.2.2
EMBEDDED IN DB2 V8.2
IY69741 IF STATEMENT LEVEL ISOLATION IS SPECIFIED FOR SELECT STATEMENT,
GENERATE TABLE LOCKING HINTS FOR MSSQL REMOTE SQL STATEMENT
IY72506 ENABLE JOIN PUSHDOWN THROUGH AGGREGATION TO PUSH JOINS DOWN THROUGH
OLAP FUNCTIONS
IY73358 A LOGIC ERROR MAY CAUSE A STORED PROCEDURE TO HANG
IY73361 INCORRECT ERROR MESSAGE SQL0444N WHILE BUILDING A SP
IY75433 CLI CFG PARAMETER IGNOREWARNLIST WORKS DIFFERENTLY IN VERSION 8 THAN
IN VERSION 7
IY75566 Rollforward using Data Protection for mySAP may fail due to inability
to RETRIEVE a log file
IY76731 TSIZE CALCULATED WRONG / DIFFERENT WITH REORGCHK COMMAND AND
REORGCHK_TB_STATS PROCEDURE AND DISTINCT DATA TYPES
IY76767 INSTANCE CRASHES DUE TO STACK CORRUPTION DURING LOAD IF COLUMN LIST
IS TOO LONG OR INCORRECT COLUMN DELIMITER IS USED
IY77128 THE INDEX PCTFREE VALUE IS NOT RETAINED DURING IMPORT IF IT IS SET TO
1 OR LESS
IY77341 THE INDEX CLUSTER ATTRIBUTE IS NOT RETAINED DURING IMPORT CREATE
IY77372 RELAX CONSTRAINTS FOR CASTING FUNCTION ON MQTS
IY77433 PERFORMING INSTANCE OPERATIONS FROM VERSION 7 CLIENT CONTROL CENTER
CAUSES DB2 VERSION 8 SERVER TO CRASH.
IY77558 LAST COMMITTED TRANSACTION VALUE INCORRECT PRIOR TO RUNNING
ROLLFORWARD ON DATABASE.
IY77628 DB2 TRAP WHEN TWO SUBAGENTS FOR THE SAME APPLICATION MODIFY THE
PREVVALLIST STRUCTURE AT THE SAME TIME.
IY77652 LOAD WITH STATISTICS NOT INVALIDATING RELEVANT PLANS IN THE PACKAGE
CACHE
IY78005 INDEX CORRUPTION WITH DB2_BINSORT ENABLED & COLLATE UCA400_LSK.
IY78061 ADDITIONAL PREPARE TIME REDUCTION STRATEGIES.
IY78073 IN A MULTI-NODE SETUP THE FILE SYSTEM SIZE FROM THE STORAGE MANAGER
IS ONLY RECORDING THE FIRST NODE INFO FOR ALL NODES
IY78105 INCORRECT STATISTICAL CORRELATION COULD LEAD OPTIMIZER TO CHOOSEBAD
PLAN CAUSING QUERY PERFORMANCE ISSUES
IY78177 TAB or New Line after semi-colon causes stmt to process batch
IY78353 USERID TRUNCATED IN GLOBAL SNAPSHOT WITH EVENT MONITOR ENABLED
IY78433 CHARACTER DEVICES DON'T SHOW UP IN CONTROL CENTER WHEN DOING A
BACKUP.
IY78534 DB2 CLI MEMORY LEAK WHEN USING MULTI-ROW INSERT OR FETCH
AGAINSTMAINFRAME DB2
IY78538 JDBC/CLI BATCH APPLICATION TRAPS IN CLI_CALLBDRDAPARAMWISEARRAYINPUT
IY78615 MATERIALIZED QUERY TABLE NOT PICKED DUE TO A RESTRICTION ON
AGGREGATION FUNCTION ON REJOIN TABLES
IY78641 LONG PERPARATION TIMES SEEN ON QUERIES WITH A LOT OF JOINS WHEREMOST
OF THE JOIN PREDICATES ARE EFFECTIVELY CARTESIAN PREDICATES
IY78646 CARDINALITY OVERESTIMATION IN THE PRESENCE OF MULTIPLE JOIN
PREDICATES REFERENCING THE SAME COLUMN
IY78761 RUNNING CLI LOAD WHEN INSERTING AN ARRAY OF ROWS WHERE ARRAY_SIZE =1
CAUSES CLI0125E
IY78806 SQL22212N WHEN PERFORMING TASKS ON A LOCAL DATABASE IN CONTROL CENTER
IY78811 DB2 INSTANCE TRAPS AT WRITE_DUMP_DATA
IY78812 REORG MAY MARK THE DATABASE DOWN DURING LOG FULL SITUATION.
IY78868 SQL30020 WHEN CHAINING STATEMENT AND BINDING DECIMAL COLUMN
IY78904 SELECT ON COMPLEX VIEW WITH DISTINCT TYPES CAN RETURN SQL0101
IY78910 SQL QUERY RETURNING SQL ERROR SQL0901
IY78915 FAILURE TO CREATE TOOLS CATALOG OR START THE DAS SCHEDULER WITH JDK
JDK 1.4.2 on AIX
IY78982 AUTOMATIC PREFETCH SIZE IS NOT DISABLED IF A VALUE IS USER SPECIFIED
DURING CREATE DATABASE STATEMENT
IY78992 STORED PROCEDURE RETURNED ANOTHER ERROR INSTEAD OF SQL0880.
IY78999 ON WINDOWS PLATFORM ONLY, SQL0998N IS GENERATED BY A CICS OR ENCINA
TRANSACTION FOLLOWING FAILURE TO LOAD LIBENCSERVER.DLL
IY79014 ALLOW CONTROL OF OLAP FUNCTIONS OF APPLHEAP SPACE
IY79016 CRASH IN AUTHENTICATION PLUGIN OCCURS WHEN SWAMP SPACE IS LOW.
IY79050 DB2AUDIT LOGS DB2START & DB2STOP AS INSTANCE OWNER INSTEAD OF USERID
THAT ISSUED THE COMMAND
IY79063 LOAD 'USE TABLESPACE' GETS SQL3341N ERROR WITH UNICODE DB.
IY79067 DB2FMP MAY EXIT AT SQLCCIPCDARIHANDSHAKE() WITH SQLO_INTRP WHEN
RUNNING DB2PD -STACKS
IY79126 JCC DRIVER'S PREPAREDSTATEMENT.SETTIMESTAMP() METHOD WITH THE
CALENDAR ARGUMENT DOES NOT CONVERTS THE TIME CORRECTLY
IY79181 PUSHDOWN OF OUTER JOIN (OJ) THROUGH UNION ALL.
IY79204 SERVER CRASH DUE TO CORRUPT PACKAGE INFORMATION SENT FROM DOWNLEVEL
CLIENT
IY79209 DB2 abend when trying to truncate or drop a DGTT because the table
did not exist.
IY79229 LOAD WITH LARGE # OF INPUT DATA FILES CRASHES PARTITIONED DATABASE.
IY79251 ERROR MESSAGES MAY APPEAR IN DB2DIAG.LOG DURING ONLINE BACKUP WITH
CAPTURE/APPLY.
IY79320 APAR CREATED FOR V8.2 5765F4100
IY79342 PERFORMANCE ISSUE CALLING SQLFOREIGNKEYS
IY79388 HIGH DB2BP CPU USAGE WHEN CONNECT/CONNECT RESET CONTINUOUSLY USING
SNA
IY79418 ROLLFORWARD PERFORMANCE SLOW DUE TO EXCESSIVE WARNINGS IN DB2DIAG.LOG
IY79432 PERFORMANCE OPTIMIZATION FOR FEDERATED "=" PREDICATES
IY79451 QUERY WITH GROUP BY CLAUSE AND NO AGGREGATE FUNCTIONS DOES NOT MATCH
MQTS
IY79469 USING SYSTEM TEMP TABLESPACE DEFINED AS DMS FILE YIELDS POORER
PERFORMANCE THAN SYSTEM TEMP TABLESPACE DEFINED AS SMS.
IY79513 PAGE CLEANERS CONSUMING HIGH AMOUNTS OF CPU
IY79527 SQL0901N BAD SCROLL STATE ON EOF WHEN USING SENSITIVE SCROLLABLE
CURSOR WITH ISOLATION RS OR RR
IY79590 INSTANCE CRASH IN SQLNO_FF_CORR_MINMAX_SQ WHILE RESOLVING A
NON-TRIVIAL EXPRESSION IN MIN() OR MAX()
IY79627 AN INSERT INTO A TABLE WITH A BEFORE INSERT/UPDATE TRIGGER AND
ASEQEUNCE CAN TRAP IF THE SEQUENCE IS ALTERED BETWEEN INSERTS
IY79665 MQT TABLE NOT CHOSEN IN OPTIMIZED QUERY DUE TO GROUP BY NOT BEING
PUSHED DOWN IN QUERY REWRITE PHASE.
IY79684 LOAD FALSE WITH EINTR WHEN READING DATA FROM NAME PIPE.
IY79722 REDUNDANT INTEGER CAST RESULTS IN PREDICATE APPLIED AS SARGABLE
IY79723 PERFORMANCE DEGRADATION DUE TO CONTENTION ON STATISTICS MAINTAINED
FOR MEMORY TRACKER
IY79737 OPTIMIZER ADDS AN EXTRA SORT FOR A 'FOR BIT DATA'
IY79746 FENCED UDF RECEIVING SQLCODE -444 RESULTS IN MEMORY LEAK
IY79764 DB2 INSTANCE CRASH DURING BACKUP/RESTORE OR LOAD COPY WHEN USING3RD
PARTY VENDORS.
IY79782 EVENT MONITOR WRITE TO TABLE, THE STMT_TEXT IS ALWAYS EMPTY AND NOT
RECORDED FOR MULTIPLE PARTITION ENVIORNMENT.
IY79873 THE DB2PD -REORGS OPTION SHOWS WRONG INFORMATION FOR THE "MAXCOUNT"
AND "END" COLUMNS.
IY79978 ATTEMPT TO MERGE TWO OR MORE PREDICATES OF A COMMON TABLE EXPRESSION
CREATES MUTUAL CORRELATION AND CAUSES AN INTERNAL ERROR
IY79992 FROM DESIGN ADVISOR,THE SORT DIRECTION IS SET, BUT THE SORT ORDINAL
IS NOT THAT WILL FORCE THE SORT TO OCCUR.
IY79994 A DATABASE USING IDENTITY_16BIT COLLATING SEQUENCE MAY EXPERIENCE AN
INCORRECT SORTING PROBLEM.
IY80031 INSTANCE CRASH WHILE RENAMING A TABLESPACE AFTER THE PARTITION GROUP
IT BELONGS TO HAS BEEN EXTENDED.
IY80053 POSSIBLE INCORRECT RESULTS FOR A UNION ALL OF A PBT USING MULTIPLE
INDEX SCANS ON DIFFERENT INDEXES
IY80102 PROVIDE SIMPLER WAY TO ACTIVATE FIX FOR APAR IY75348
IY80126 DB2 TRAPS IN GLOBAL DEADLOCK DETECTOR WHEN FREEING MEMORY BLOCK
IY80148 WHEN THE LOAD IS INVOKED WITH A LONG DATAFILE AND IF IT DOES
NOTEXIST, DATABASE MAY CRASH BECAUSE OF MEMORY CORRUPTION.
IY80150 RUNSTATS MAY CRASH THE DATABASE WHEN THE NUMBER OF ROWS IN A TABLE IS
CLOSER TO 2*10^9
IY80161 DB2COMMANDBUILDER.DERIVEPARAMETERS() WITH .NET MANAGED PROVIDER FAILS
TO RETURN RESULTSET IF PROCEDURE IS UNQUALIFIED.
IY80214 DB2AUDIT RECORDS OBJECT TYPE OF NICKNAMES AS UNKNOWN.
IY80224 SLOW QUERY COMPILATION WITH A LARGE IN-LIST AND UNION
IY80258 MIN,MAX SLOW FROM A VIEW OF UNION ALL COMPARED TO DIRECT TABLES
IY80286 LEGACY JDBC TYPE2 DRIVER DOES NOT THROW SQL0952N WHEN
SCROLLABLECURSOR IS USED.
IY80302 DB2 may leave a useless package section in cache
IY80304 MERGE OUTER JOIN WHEN MULTIPLE OUTER JOINS ARE INNER JOINED WITHTHE
SAME OUTER JOIN
IY80308 EXECUTING QUERY IN EXPLAIN MODE HITS SQL0804N IF SOME DECIMAL
COLUMN'S DISTRIBUTION STATISTICS IS BLANKED OUT.
IY80310 SQL0104N UNEXPECTED TOKEN ERROR CAN OCCUR IF SQL STATEMENT CONTAINS A
SLASH FOLLOWED BY AN ASTERISK ("/*")
IY80313 CRASH RECOVERY SLOW - DO NOT PERFORM DROPPED TABLE RECOVERY IF THE
DATABASE IS NOT RECOVERABLE
IY80361 DB2START RUNS AS EFFECTIVE UID OF ROOT WHEN VIRTUAL MACHINE NAMEUSED
IN DB2NODES.CFG AND ERRORS DURING ACCESS OF /DEV/KSYMS
IY80411 APPLICATION NAME IS NOT FILLED WITH DATA IN A HP-UX 64 BIT
ENVIRONMENT WITH DB2 V8.2 32 BIT
IY80476 DEVELOPMENT CENTER SHOWS INCORRECT ERROR MESSAGE WHEN CREATING AN
OVERLOADED UDF
IY80551 .NET APPLICATION FAILS TO CONNECT IN TURKISH ENVIRINMENT WITH CAPITAL
'UID=...' IN THE CONNECTION STRING
IY80565 EVENT MONITOR: SQLM_ELM_COORD_NODE_NUM ALWAYS DISPLAYS THE VALUE OF
SQLM_ELM_AGENT_ID
IY80577 FREEING THE MASTER CONTEXT IN SQLEFREECTX() SHOULD NOT BE REPORTED AS
A SEVERE ERROR.
IY80631 MISALIGNED MEMORY ACCESS ON HPUX
IY80753 MEMORY CORRUPTION DURING PACKAGE CACHE CLEANUP
IY80805 INTERMITTENT SQL30081N ON CONNECT FROM V7 CLIENT TO V8 DATABASE
IY80847 MESSAGES IN DB2DIAG.LOG ABOUT POOL THAT OWNS MEMORY BLOCK HAVING
ALREADY BEEN FREED WHEN USING THE DB2.NET DRIVER
IY80865 UDB MAY CRASH DURING LOCK ESCALATION IF A TABLE CONTAINING A
LOBCOLUMN IS DROPPED.
IY80916 FDOCA DATA ERRORS IN CLIENT DIAG LOG
IY80922 HIT -901 "SQLRICLS_NULL_SECTPTR: SECTION PTR NULL AND LOADED" WHEN A
CLI LOAD JOB IS ROLLING BACK DUE TO LOG FULL
IY80990 CRASH IN SQLOCRASHONCRITICALMEMORYVALIDATIONFAILURE WHEN SELECTING
MORE THAN 300 COLUMNS FROM A TERADATA NICKNAME
IY81008 CONTROL CENTER KEEPS CREATING NEW CONNECTIONS WHEN THE PREVIOUS
PREVIOUS ONE HASN'T RETURNED AFTER 5 MINUTES
IY81015 DB2LOOK GENERATES INCORRECT EXTERNAL NAME FOR UDF
IY81048 TRAP IN SQLRA_STATS_VAR_REF
IY81049 HANG IN APPLICATION DURING ROLLBACK (SQL0911N) IN CLI_SQLFETCH.
IY81072 LEGACY JDBC APPLICATION WILL CRASH IN CLIENTBISTRINGCONVERSIONS IF
BINDING PARAMETER MARKERS IN CERTAIN ORDER
IY81105 Mix of literals and parameter markers in predicates on a table leads
to cardinality overestimate and poor plan choice
IY81109 MDC ROLLOUT DELETE WHILE ONLINE CREATE INDEX MAY CAUSE INDEX
CORRUPTION.
IY81177 QUERIES USING A 3 PART NAME FROM A Z/OS CLIENT TO A UDB SERVER
RESULTS IN SQL0204N ERROR.
IY81178 SQL8100 RETURNED ON INSERT/UPDATE DUE TO MISSING CHECK ON LONG OR LOB
FIELDS FOR DMS TABLESPACES
IY81212 DB2 LOAD MAY HANG IF SQL0659N ERROR OCCURS DURING LOAD AND
CPU_PARALLELISM = 1
IY81421 CC PLUGIN DISPLAYS ADDED TOOLBAR ADDED IN THE SAME POSITION.
IY81459 WHEN THE CLOB DATA IS CORRUPTED, RETRIEVING THE DATA FROM A
JDBCPROGRAM WILL HANG UNTIL SYSTEM MEMORY IS USED UP.
IY81501 DB2FMP MEMORY LEAK IN 8 BYTES EVERYTIME THREADSAFE STORED PROCEDURE
WITH NICKNAME QUERIES IS CALLED.
IY81507 AFTER LOG PAGE CHECKSUM MISMATCH ERROR DURING REMOTE CATCHUP ON
STANDBY, A START HADR...AS STANDBY OR ACTIVATE DB CMD WILL HANG
IY81604 HACMP FAILS TO PERFORM TAKEOVER OF HADR DATABASE WITH RC=100 RETURNED
FROM RC.HADR.START AND RC.HADR.MONITOR OR RC.HADR.STOP
IY81605 SNAP_XXX() UDFs CAUSE SIGSGV WHEN IT RECEIVED SQL1611W.
IY81614 "
ANIC" CRASH IN DB2 DURING COMMIT PROCESSING WHEN NESTED
PROCEDURE/UDF CALLS ARE INVOLVED.
IY81685 NEW ADDED CONTAINERS ADDED ON A NEW NODE WILL NOT RESPECT EXISTING
TABLESPACE ATTRIBS. FILE SYSTEM CACHING ALWAY ENABLED
IY81686 OUT OF APPLICATION HEAP COULD CAUSE INSTANCE CRASH DURING QUERY
REWRITE PHASE
IY81687 PERFORMANCE OF STAR JOIN INDEX-ANDING PLAN
IY81693 SQL0119N ERROR PREPARING/EXECUTING SQL STATEMENT
IY81843 LENGTH NOT PUSHED DOWN TO FEDERATED SOURCE
IY81852 DATABASEMETADATA.GETUDTS() IGNORES CURSORHOLD=0
IY81872 DB SELECTION INCORRECTLY REFRESHING DB LIST
IY81896 AFTER A SPLIT MIRROR BACKUP DB2 INCORRECTLY DETERMINES MINIMUM
ALLOWED PIT FOR ROLLFORWARD ON STANDBY IMAGE
IY81899 USING "IN" AND "BETWEEN" PREDICATES INVOLVING HOST VARIABLES MAYNOT
APPLY THE IN PREDICATE TO AN ELIGIBLE INDEX AT OPTLEVEL 5
IY81923 CARDINALITY UNDERESTIMATION WHEN USING PREDICATES OF THE TYPE LIKE ?
OR LIKE ?
IY81933 Error SQL30020 when an interrupt is issued while DB2 Connect gateway
is generating a LOB value to send to the server.
IY81936 NESTED FENCED ROUTINES, WHEN 1ST ROUTINE CONNECTS TO SHMEM SET, 2ND
ROUTINE GETS OUT OF MEMORY AND DISCONECTS THEN 1ST TRAPS.
IY81948 INSTANCE CRASH WITH FEDERATED SELECT WHEN DB2_FENCED=Y.
IY81949 SQL PROCEDURE THAT USES THE ADMIN_CMD SP TO EXECUTE EXPORT COMMAND
SILENTLY ABORTS.
IY81980 COMPILER CRASHES WHEN DB2TRC ENABLED AND APPLICATION HEAP EXHAUSTED
IY81987 SQL_C_DEFAULT WITH FOR BIT DATA IS NOT TRANSLATING TO BINARY DATA AND
WILL HAVE A NULL TERMINATOR AS THE LAST BYTE.
IY82069 SIGNAL #11 IN MEMDETACHFROMSHAREDMEMORY FROM DB2STOP FORCE
IY82098 CORRUPTION OF METADATA BY THE CLP COMMAND: ADD/UPDATE THE
CONTACTGROUP (INDEXOUTOFBOUNDS FROM THE GUI TOOLS).
IY82104 A 30020 ERROR OCCURS DURING A LEFT OUTER JOIN ON A NON-NULLABLE
COLUMN.
IY82116 DB2PD CAUSES A MEMORY LEAK IN THE DB2 INSTANCE (DB2SYSCS.EXE) ON
WINDOWS ONLY
IY82124 POOR CONNECT PERFORMANCE BY THIRD PARTY DRDA DRIVER AS WE TRY
TORESOLVE HOST NAME
IY82182 APPLICATION STATUS IN GLOBAL SNAPSHOT MONITOR OUTPUT SHOWS UP AS0
(UNKNOWN APPLICATION STATUS CODE 0)
IY82192 ENUM VALUES NOT INSERTED CORRECTLY
IY82246 EXCESSIVE IDENTITY_VAL_LOCAL() MESSAGES IN QPDIAG.LOG
IY82249 DB2 INSTANCE CRASH: RARE TIMING HOLE CAUSES MEMORY CORRUPTION WHEN
RUNNING DATABASE SNAPSHOT OR MEMORY TRACKER
IY82266 CREATE TOOLS CATALOG FAILS ON HP IA64
IY82274 HADR STANDBY DATABASE SHUTS DOWN OR CRASHES DURING REMOTE CATCHUP
WITH ERROR " TAILPAGE DOES NOT MATCH PAGELSN "
IY82305 SQLDESCRIBEPARAM SHOULD FAIL WHEN DESCRIBECALL=0 IS SET WHEN
DESCRIBING PARAMETERS FOR A CALL STATEMENT.
IY82336 NEW DB2PD OPTION TO DISPLAY FMP INFORMATION.
IY82489 AGENT TRAP ON CLOSING RESULT SET, WHICH CONTAINS A UDF, RETURNEDFROM
PROCEDURE AFTER DELAY
IY82526 ENSURE STATISTICS ARE UPDATED FOR DESIGN ADVISOR TO MAKE MQT ANDINDEX
RECOMMENDATIONS
IY82566 IN DB2PD -AGENTS OUTPUT, SOME MORE DETAILS ARE NEEDED TO MAKE IT MORE
CLEAR WHICH AGENTS ARE CURRENTLY ALLOCATED
IY82583 BINDING AN SQLJ PACKAGE CRASHES DB2 INSTANCE.
IY82585 SQL SUBQUERY WITH INVALID CORRELATED COLUMN REFERENCE IN AGGREGATE
FUNCTION CRASHES WITH SQLQN_QUN_QNC_EXPLICIT_NAME
IY82596 IGNORE ANY ERRORS DURING ARITHEMETIC CONSTANT FOLDING INSIDE THE
STORED PROCEDURES
IY82723 DB2CKRST -D <DBNAME> -T <TIMESTAMP> RETURNS ERROR: DB2CKRST - MEMORY
ALLOCATION. RETURN CODE OF -6 SEEN AT LINE 1272.
IY82725 DB2 INSTANCE CRASH WHEN EXECUTING SQL WHICH HAS LONG IN CLAUSE.
IY82732 DB2LDAP_BASEDN VARIABLE CAN BE CHANGED IF THE LDAP SERVER GOES DOWN
AND ANOTHER ONE TAKE OVER.
IY82758 DB2 WEB SERVICE COMPONENT ASSUMES WRONG ENCODING IN CASE OF
INCOMPLETE XML PROLOG IN SOAP RESPONSE
IY82776 EVALUATE UNCOMMITTED SCANS AGAINST MULTI-DIMENSIONAL CLUSTERING (MDC)
TABLES MAY HANG INDEFINITELY.
IY82793 THE DB2 ADVISOR (DB2ADVIS) SUGGESTS MDC DIMENSIONS ON A TABLE THAT
CAUSES THE TABLE SIZE TO INCREASE BY FACTORS.
IY82805 OUT OF MEMORY IN THE MONITOR HEAP CAUSES SERVER OBJECTIN FEDERA TED
ENVIORNMENT TO BE PARTIALLY CONSTRUCTED CAUSING HANG/CRASH
IY82815 A DYNAMIC SELECT FROM A TABLE CAN DEADLOCK WITH A RENAME TABLE FROM
ANOTHER SESSION ON THE SAME TABLE
IY82816 VIEW CONTAINING A COMMON SUB EXPRESSION
