************************************************************ Product Name : DB2 UDB Version 7 Updated : Thu Jul 14 11:22:12 EDT 2005 ************************************************************ APAR fixes included in Fixpak 14 APAR No. Abstract -------- -------------------------------------------------- IY55287 ON OCCASION ONE PARTITION BEING LOADED FROM THE AUTOLOADER WILL FAIL WITH SQL3025. IY57618 LOG FULL CONDITION, SQL0964C. RECYCLE DB2 TO RESOLVE. IY61733 DEADLOCK ON SYSIBM.SYSPROCEDURES WHEN CREATE/DROP STORED PROCEDURES IN PARALLEL IY62294 SQL30082N RC=24 WHEN AUTHENTICATION=CLIENT, TRUSTS_ALLCLNTS=DRDAONLY IY62643 DB2START REPORTS SQL1063N "START SUCCESSFUL" BUT DB2 IS NOT STARTED IY63059 SPB COPY/BUILD/PASTE FAILS JAVAC WITH MULTI-PART PACKAGE NAME IY63149 CONFIGURE RESET TRIGGERS MEMORY ERROR WHILE DB2AUDIT START. IY63394 LOAD TO A UTF-8 DATABASE WITH DB2SORT SET TO A VENDOR SORT LIBRARY CAUSED DB2 TO CRASH IY64842 QUERY REWRITE RULES NOT APPLIED AFTER A PERSISTENT CONNECTION COMPILES A VERY LARGE NUMBER OF DYNAMIC SQL STATEMENTS. IY64891 RECYCLING WEBSPHERE CASES JAVACORE IN CLI_MEMFREETOPOOL(). IY65522 MODIFICATIONS TO THE CLEARWARNINGS OBJECT FOR DB2INPUTSTREAM IY65560 INCORRECT RESULTS RETURNED BY QUERIES THAT USE THE ROLLUP OPERATOR IY67306 ONLINE BACKUP, TARGETTING > 256 DIRECTORIES, FAILS WITH SQL2161NIN SECOND ATTEMPT. IY67382 WHEN REMOVING DB2CLIV81 PACKAGE, BACKOUTALLPATCH 7.1.X.X SHELL AND 172XXXX-XXX DIRECTORIES IN /VAR/SADM/PATCH ON SUN ARE REMOVED JR19331 DB2BATCH WITH AN INPUT FILE WITH > 500 STATEMENTS CRASHES ON WINDOWS AND ON UNIX REPORTS INCORRECT STMT NUM WITH -S OFF JR19926 LOGICAL AGENT NOT DISASSOCIATED AFTER TRANSACTION ROLLED BACK FROM MQ SERIES. JR20387 HANG ON REPEATED EXECUTION OF THE SAMPLE SALCLADO APPLICATION. JR20431 JAVA SP PROBS WITH OUTPUT VARIABLES. JR21175 DB2 CRASH IN SPRINTF LIBRARY FUCNTION WHEN CALLED FROM DBCLI APAR fixes included in Fixpak 13 APAR No. Abstract -------- -------------------------------------------------- IY49477 SETTING CURSOR ISOLATION IN SQL WITH SQL_ATTR_MAX_ROWS CAUSES SYNTAX ERROR: SQL0104N IY51557 PERFORMANCE DEGRADES WITH VALUES BOX GENERATED BY REWRITE IY51593 CHANGE DATE/TIME/TIMESTAMP FORMAT OPTIONS ON LOAD AND IMPORT TO ALLOW CHAR DELIMITERS IN DATA IY51850 WRITE RESUME AS OPTION OF RESTART DATABASE NOT TAKEN IN ACCOUNT IF SUBMITTED WHILE BEING ALREADY CONNECTED TO THE DATABASE IY53873 USING EXPLAIN MODES EVALUATE INDEXES AND/OR RECOMMEND INDEXES MAY RESULT IN AN ERROR AN DB BEING MARKED AS BAD. IY54421 SLOW PLAN FROM INDEX SCAN ESTIMATING 0 IY54513 CANNOT USE Z/OS V7 -> V7 GATEWAY UNIX -> V8 SERVER UNIX DUE TO UNEXPECTED SYSTEM ERROR. IY54682 INSTANCE TRAPPED AFTER UNSUCCESSFUL LOCK ESCALATION ON MPP ENV -SIGNAL #11 IY55555 RESTORE FROM LOCAL TCPIP NODE BACKUP , IT FAILED WITH SQL2038N IY55595 WHEN AN APPLICATION IS IN LOCK-WAIT, THE SQLM_ELM_LOCK_WAITS COUNTER INCREMENTS BY 2 AND ONLY DECREMENTS BY 1. IY55719 CLEARPARAMETERS DOES NOT RESET THE PARAMETERS COMPLETELY IY55751 ORPHAN SEGMENT LEFTOVER BY DLFM DURING START UP OF THE INSTANCE. IY56642 DB2 SHOULD REPORT AN ERROR IF THIRD PARAMETER OF "SUBSTR" FUNCTION IS A 0 IY56740 CLI0112E DURING INSERT INTO THE DECIMAL COLUMN WHEN TRUSTAPP=1 IY56829 SOME ROLLFORWARD ERRORS NOT REPORTED UNTIL ROLLFORWARD COMPLETE IY57041 SELECT PRIVILEGE ON SYSCAT.SEQUENCES IS NOT GRANTED TO PUBLIC IY57086 DB2GETSNAPSHOTSIZE API RETURNS INCORRECT SIZE IN PARTITIONED DB ENVIRONMENT - GETS SQL1606W IY57312 CAPTURE MAY TAKE A LONG TIME STARTING IF THE START LSN IS IN THEMIDDLE OF A LONG RUNNING TRX INVOLVING NON-DATA CAPTURE TABLES. IY57520 TRAP IN SQLE_DB2RA_DELCCB WHEN DB2_RUN_PSM_TRUSTED IS ENABLED IY57539 SIDE TABLES ARE NOT UPDATED WHEN AN XML-ENABLED COLUMN IS UPDATED. IY57556 CRASH IN SQM_DCS_DB_RESETTABLE_DATA CONTRUCTOR IY57619 SQL0901 ON SQLNO_CRULE_SAVE_PLANS COMPILING OUTER JOIN QUERY IY57649 "DB2RBIND ALL" DOES NOT REBIND PACKAGES WITH MIXED CASE PACKAGE NAME. IY57847 SQL0311 RECIEVED BY A UNICODE CLIENT WHEN BINDING TO AN SQL_CHARWITH SQL_C_CHAR DATA >85 OR SQL_C_WCHAR >43 IY57882 LEAK IN APPLICATION HEAP CAUSES THE QUERY TO FAIL WITH SQL0954C WHEN THE QUERY CONSISTS OF CASE FOLLOWED BY LIKE CLAUSE IY57893 THIS PROBLEM OCCURS ONLY WHEN GARBAGE CHARACTERS ANY + "E" OR "E" HAPPEN TO FOLLOW DIGIT(S) + SPACE(S). IY58450 WHEN A DB2XADATASOURCE OBJECT FAILS TO CONNECT WITH SQL1013N, THE NAME PORTION OF THE ERROR MESSAGE IS INCORRECT. IY58457 INCORRECT RESULTS OBTAINED FROM SQL SP WHEN A VALUE IS TRUNCATEDWHEN VALUE IS TRUNCATED WHEN PUT INTO AN OUT PARM IY58592 INCORRECT RESULTS RETURNED WHEN A QUERY JOINING GRAPHIC COLUMNS OF DIFFERENT COLUMN LENGTHS USES A MERGE JOIN IY58609 SQL2008N RECEIVED WHEN TRYING TO TERMINATE A LOAD. IY58939 DB2MOVE DOES NOT CORRECTLY HANDLE DATABASES WITH > 32768 TABLES IY59004 ASNAPPLY ON V8 SOURCE SERVER TO V7 TARGET SERVER GETS SQL0413N IY59208 DART FORMATTING PROBLEMS FOR DATE DATATYPES ON SUN. IY59526 ESTORE SHARED MEMORY SEGMENTS ARE NOT FREED AFTER INSTANCE IS KILLED BY SIGNAL 11. THIS ONLY OCCURS IN V7. IY59533 NULL POINTER IN CLI_SDAINITSQLDACOL() CAUSES TRAP. IY59870 INCORRECT RESULTS WHEN SELECTING FROM ALIAS USING A NON-PRIMARY KEY JOIN COLUMN IY60452 DB2 SERVER CONFIGURED TO USE DATA LINKS CRASH IN FUNCTION DFMSAFERHASH WITH A SIGNAL #11 IY60711 SIGNAL 11 AT SQLRA_DROP_PKG WHEN PERFORMING A BIND. IY60723 FORCING A STORED PROCEDURE MAY NOT WORK, SOMETIMES RESULTING IN AN INSTANCE CRASH IN SQLODSHR IY60839 ABEND: DB2 INSTANCE CRASH DUE TO MEMORY CORRUPTION IN APPLICATION HEAP AFTER A DATABASE PARTITION RECYCLES IY61065 SELECT W/ OPTIMIZE FOR 1 ROWS AND FOR READ ONLY GOING AGAINST MVS RESULTS IN A FOR FETCH ONLY BEING ADDED. IY61073 LAS SHOULD NOT TOUCH THE IPC SHARED MEMORY IF MEM ATTACH FAILS IY61289 ENHANCE DATABASE AND APPLICATION REMOTE SNAPSHOTS, AND CORRECT APPLATCHING FOR V7. IY61386 SQLFREESTMT RETURNS UNEXPECTED SQL_NO_DATA_FOUND IY61393 INSTANCE CRASH WHEN EXECUTING CREATE PROCEDURE (SQL). IY61397 CLI0109E WITH IBMDADB2 PROVIDER WHEN INSERTING DBCS CHARACTER TO A CHAR COLUMN IN DATABASE ENCODED WITH IBM-943 (SJIS) IY61615 APPLY LOOPS WHEN MAX_SYNCH_MINUTES IS IN USE AND CD_NEW_SYNCHPOINT IS HIGHER THAN REGISTER GLOBAL SYNCHPOINT. IY62483 INCORRECT RESULT SET AFTER MERGING TWO UNION'S WHILE THE TWO UNION HAS DIFFERENT NUMBER OF COLUMNS ON THE SELECT LIST IY62484 INDEX CORRUPTION DUE TO LOADING INVALID FLOAT IN BINARY FORMAT IY62499 IMPORT COMMAND FAILS WITH SQL0302N AND SQL0301N IY62502 BAD PERFORMANCE WHEN USING ALIAS VS. BASE TABLE IN OUTER JOIN QUERY IY62522 IF DTD IN DAD IS NULL , AND VERIFICATION IS YES , INSERT AND UPDATE WILL INSERT INVALID DOCUMENTS. IY62527 SQL0901N REASON "BAD PLAN;UNRESOLVED QNC FOUND" IY62558 PREVENTING LIBRARY CONFLICT FOR DROP / CREATE PROCEDURE STATEMENTS IN V7.2 IY62672 SIGNAL #11 TRAP IN NAV_ASSIGN_MAX_LEVELSWHEN A COMPLEX QUERY IS COMPILED. IY62673 NODE FAILURE OR INTERNODE COMMUNICATION FAILURE CAN LEAVE A TRANSACTION INCONSISTENT IF IT SPANS PARTITIONS. IY62674 TRAPS OR SEVERE ERRORS DURING SUBAGENT SECTION PROCESSING AT COOR NODE FOR SOME EXECUTE-TYPE RQSTS. IY62681 LUW V72 SERVER DOESN'T HONOUR BIND OPTION "DEGREE" IF CLIENT IS LUW V8 OR ZOS OR ISERIAL IY62696 IN V8,IF CODESET ISO8859-1,TERRITORY DE_CH, DB2COUNTRY=41DB2 'V ALUES(CURRENT DATE - CURRENT DATE)'RESULT TO','INSTEAD OF 0. IY62743 SQLLIB/BIN/DXXSHRD RETURNS SQL0444N RC = 4 IF USER MAKING THE CALL DOES NOT HAVE DBADMIN PRIVILEGES IY62745 SECURITY: POTENTIAL EXPLOITABLE BUFFER OVERFLOW IY62747 SECURITY: A POTENTIAL SECURITY VULNERABILITY EXISTS IN THE SATELLITE USER-DEFINED FUNCTION SATADMIN.SATENCRYPT IY62748 SECURITY: UPDATE TO JDBC LISTENER IY62749 SECURITY: BUFFER OVERLOWS WHEN THE DB2LPORT ENVIRONMENT VARIABLEIS SET TO A LONG STRING VALUE IY63060 SECURITY: PASSING A VERY LONG PARAMETER VALUE TO SOME XML EXTENDER UDFS, MIGHT CAUSE A STACK-BASED BUFFER TO OVERFLOW JR19114 INACCURATE GROUP BY CLAUSE GENERATED BY DATA WAREHOUSE (I.E. BUILD SQL) JR19392 THE WHOLE JAVA BATCH UPDATES FAIL IF THE FIRST UPDATE FAIL WITH SQL0803N. JR19826 INSTANCE CRASHES WITH C0000005 (EQUIVALENT TO SEGMENTATION FAULTIN UNIX) THE CRASHED FUNCTION IS SQLRI_BUFFER_DISK_WRITE JR19835 CRASH IN SQLRS_HASH WHEN INTRA_PARALLEL IS SET AND WHEN SMP SORTING IS INVOLVED JR19851 CLI0111E ERROR IS THROWN WHEN INSERTING DECIMAL(30,0) INTO DECIMAL(30,0) COLUMN AFTER INSERTING DECIMAL(3,2) JR19897 SQL0104N ON IMPORT IMMEDIATELY FOLLOWING AN IMPORT OF A TABLE WITH LOB COLUMNS TO A DB2/390 DATABASE. JR19924 SINGLE UPDATE STATEMENT LEADS TO 'LOG FULL' CONDITION. JR19933 XA APPL. SETS CURRENTFUNCTIONPATH TRAPS DB2 CONNECT GATEWAY JR19944 INSTALLSHIELD ERROR 401 - SCREEN EXCEEDS BUFFER SIZE APPLYING A FIXPAK TO A FRENCH SYSTEM USING SILENT INSTALL MODE. JR19972 SNAPSHOT FOR DYNAMIC SQL SHOWS DATABASE ALIAS WITHOUT CODEPAGE CONVERSION. JR20059 C0000005 EXCEPTION ERROR WHEN A QUERY IS RUN WITH "LIKE%" OPERATOR. JR20099 LENGTH OF FETCHED BINARY DATA NOT CALCULATED CORRECTLY WHEN USING KEYSET DRIVEN SCROLLABLE CURSOR JR20119 NEW PARAMETER DEFINITIONS NOT SAVED IN SYSTEM TABLE WHEN SPB CHANGES PARAMETER DEFINITION FOR EXISTING JAVA STORED PROCEDURE JR20192 DBA2078E ERROR RUNNING AN OS COMMAND SCRIPT IN THE SCRIPT CENTERON A WINDOWS NT PLATFORM. JR20208 -998 IS A SIDE-EFFECT OF THE UNUSUAL WAY THE TRANSACTION IS BEING ROLLED BACK (CALLING XA_END WITH TMFAIL) JR20211 NEWER V8.2 LINUX SERVERS NOT RECOGNIZED BY V7.2 CLIENTS JR20274 SET INTEGRITY RECEIVES -901 "COLUMN NUMBER OUT OF RANGE". JR20278 CORRUPTION OF RESULT SET DATA THAT WAS UPDATED OR INSERTED FROM A DB2 CLI OR LEGACY TYPE 2 JDBC APPLICATION FOLLOWING A DEADLOCK JR20311 THE GOVERNOR DAEMON (DB2GOVD.EXE) ENDS UP CONSUMING 100% CPU TIME JR20325 SQLNUMPARAM DOES NOT RETURN CORRECT VALUE FOR BATCH STATEMENT IFPARAMETER MARKER IS NOT LOCATED IN FIRST POSITION. JR20334 V7 CLIENT APP RECEIVES TRUNCATED COLUMN/TABLE NAME FROM V8 390. JR20416 DB2 IS USING UP HANDLES ON OS2 JR20435 DB2_ALL COMMAND DOES NOT PRODUCE ANY OUTPUT LI70373 HIGH SYSTEM CPU USAGE WHEN DURING AUTOLOAD ON LINUX WHEN THERE ARE DISK OR NETWORK PROBLEMS LI70450 'CREATE SERVER' COMMAND IS RECEIVING A SQL0902C ERROR WITH RC=25WHEN FEDERATING TO ANOTHER DB2 DATABASE IN THE SAME INSTANCE APAR fixes included in Fixpak 12 APAR No. Abstract -------- -------------------------------------------------- GG04361 INTERRUPT/OR CANCEL ARE NOT WORKING FROM REMOTE CLIENTS WHEN BYTE REVERSAL OF DATA IS REQUIRED ON THE SERVER. GG04456 APPLY GETS SQL0103N FOR REPLICA ON CONFLICT COMPENSATION WHEN SOURCE OR TARGET SERVER IS ON MVS. IY35213 DB2ADVIS OPERATION CAUSES SIGNAL #11 IN SQLKD_SND_DATA() IY37711 MIGRATION FAILS ON EEE IF USING DB ALIAS < 8 CHARS IY40416 AUTOLOADER TRAPPING DURING FORMATTER SETUP IY41625 IMPROPER ERROR DISPLAY (SQL142C) WHEN NEWLOGPATH PERMISSION IS CHANGED IN CERTAIN SCENARIOS. IY42251 SQL1618 WHEN TRYING TO START EVENT MONITOR. IY44014 AUTHENICATION PERFORMANCE ISSUE WHEN USING NIS SERVER AND THERE ARE MANY USERS GROUPS DEFINED IN THE SYSTEM IY44815 EXPORT FROM OS/390 GETS SQL0551 IY45312 POOR JOIN PERFORMANCE IN MSJOIN WHEN MAX FUNCTION APPLIED ON JOIN PREDICATES BEFORE THE JOIN. IY45999 TRANSITIVE JOIN GIVES LARGE INTERMEDIATE RESULT SET. LEADS TO POOR PERFORMANCE ON BW OBJECTS IN SAP. IY46552 DB2 CRASHED BECAUSE WE'RE TRYING TO DUMP A BAD POINTER. IY46642 CLI SENDING DUPLICATE PREPARE STATEMENTS TO HOST. IY47881 PROTECTIVE CODE FOR WHEN SQLE_DB2RA_RCF_FETCHERR SET BUT SQLCODE NON-NEGATIVE. SQLCA WILL BE FILLED WITH -901 IY48303 BACKUP/RESTORE BUFFER HAS A MAXIMUM VALUE OF 16384 HOWEVER, DBM CFG PARAMTER BACKBUFSZ WILL ACCEPT A VALUE OF 524288. IY49240 PERFORMANCE DEGRADES WHEN QUERY USES MERGE JOIN INSTEAD OF HASH JOIN IY49349 SQL0901N SQLRL_DGTT_RCV: BUFFER POOL ERROR WHEN DECLARING & DROPPING GLOBAL TEMP TABLES REPEATEDLY WITH DB2NODE SET. IY49918 MEMORY LEAK : SQL1084 FFFFD605 ON CONNECT AFTER FAILURE TO DETACH DARI SHARED MEMORY SEGMENT WHEN KEEPDARI = NO IY50140 INSTANCE / FORCE APPLICATION HANGS ON EEE ENVIRONMENT WHEN MAX_LOGICAGENTS IS SET TO NON-DEFAULT VALUE IY50669 HIGH PREPARE TIME WITH OPTIMIZE FOR N ROW QUERIES IY50831 HANG DUE TO DEADLATCH CONDITION ON DB WITH WRITE SUSPEND ENABLED AND TRACKMOD TURNED ON IY51017 REMOVE REDUNDANT COMPLEX PREDICATES & REMOVE COMPLEX LIKE PREDICATES. IY51022 REMOVE REDUNDANT JOIN BASED ON RI CONSTRAINT. FK TABLE DOES NOT NEED TO JOIN TO PK TABLE, WHEN JOIN PRED IS FK & PK. BOOST PERF. IY51454 SQLTRANSACT WITH SQL_ROLLBACK GIVES A SQL0501NWHEN MULTICONNECT SET TO 3 IN DB2CLI.INI IY51710 DB2 UNIVERSAL DATABASE (UDB) HANGS WHEN MONITOR SWITCHES ARE SET IY51811 IMPLICIT CONNECTION WILL NOT CORRECTLY DISPLAY GRAPHIC AND VARGRAPHIC DATA TYPES IY51921 CHANGE DB2SUPPORT TO ALLOW SHARED READ AND WRITE ACCESS TO DATABASE CONTROL FILES IY51998 SQL1131 DARI CRASH WHEN RUNNING SQL STORED PROCEDURE THAT HAS A SQL WARNING HANDLER IY52114 IMPORT INTO A DB2/VM DATABASE FAILS WITH SQL0104N IY52236 DB2STOP HANG DUE TO TIMING HOLE WHERE DB2IPCCM WILL NOT RESPOND TO THE DB2SYSC IY52251 LOCK SNAPSHOT DURING A ROLLBACK MAY BLOCK ON THE TRANSACTION LATCH WHILE HOLDING THE DB LATCH AND PREVENT NEW CONNECTIONS. IY52281 INCORRECT VALUES REPORTED BY SNAPSHOT MONITORS FOR BUFFER POOL DATA LOGICAL READS AND BUFFERPOOL DATA PHYSICAL READS IY52348 SQL_ATTR_QUERY_TIMEOUT CAN CAUSE DB2 APPLICATION TO HANG ON WINDOWS. IY52356 DATABASE ACTIVATION HANGS AT LOGGER INITIALIZATION DUE TO USEREXIT NOT RESPONDING IY52456 JDBC DID NOT TROUGH SQL0911N EXCEPTION FOR TYPE_SCROLL_INSENSITIVE RESULTSET IY52461 PARALLEL REVERSE INDEX SCAN WITH EXCLUSIVE STARTKEY MAY INCORRECTLY RETURN THE STARTKEY IN THE RESULTS. IY52501 ID AND PASSWORD BEING CACHED BY JDBC CONNECTION POOL IY52702 ENTITY EXTRACTUDF NEED TO REINSTATE DTD IN NORMAL CALL IY52753 BEA CLIENTS GETS XA ERRORS - CLI0107E AND CLI0108E- USING XA TRANSACTIONS TO MAINFRAME. IY52765 PERFORMANCE DEGRADES WITH EXCESS COLUMNS NOT REFERENCED IN QUERY IY52844 MIGRATION FAILS. DXXMIGV RETURNS ERROR: FAILED TO DROP TRIGGER IY52947 SLOW PERFORMING QUERY DUE TO TQ OVERFLOW, SPILLAGE.. IY53312 BETWEEN CLAUSE TRANSFORM TO EQUALITY PREDICATE FOR SAME LITERAL IY53413 "ACTIVE SORT" NOT DECREASE AFTER THE STATEMENT GET AN ERROR. IY53417 OVERSIZED STATEMENT WILL THROW INCORRECT EXCEPTION WITH PREPAREDSTATEMENT. IY53489 IMPORT WITH LOBS AND COMPOUND_COUNT SIG11 IN FP11. IY53518 REPEATED CALLS OF SQLOEDUCODETRAPHANDLER MAY MAKE THE TRAP FILE GROW AT VERY FAST RATE AND MAY FILL UP THE FILE SYSTEM. IY53541 QUERY IS RETURNING INCORRECT RESULTS AS COLUMN WAS SKIPPED IN SQLNO_PLAN_EACH_QNC IY53597 DECLARE CURSOR WITH HOLD IN MULTI-PARTITION DATABASE, EXCLUSIVE ROW LOCK (X) REMAINS EVEN AFTER COMMIT IY53687 SQL0901 REASON "UNRECOGNIZED PRIVILEGE!" ON INSERT IY53688 AFTER CLI0109E ON THE SP CALL WITH INCORRECT PARAMETER LENGTH, THE SECOND CALL WITH CORRECT PARAMETER RETURNS CLI0125E IY53699 "GET SNAPSHOT FOR ALL BUFFERPOOLS GLOBAL" DOES NOT REPORT THE IBMDEFAULTBP FROM ALL ACTIVE DATABASE IY53715 POOR QUERY PERFORMANCE WITH VALUES BOX ON :? = :? PREDICATE IY53728 COMPILER CRASH BECAUSE OF MEMORY ALLOCATION PROBLEMS IN FEDERATED IY53783 REDIRECTED RESTORE WITH SMALLER TABLESPACES CAN GET "SEGMENTED TABLE PAGE NUMBER IS TOO HIGH". IY53833 AUTOLOADER SPLITTER PERFORMANCE DEGRADATION DUE TO REDUNDANT READS / PARSING OF DB2NODES.CFG . IY53971 DATABASE MARKED BAD WITH SELECT ON VIEW WITH UNION ALL. SQL1034 IY54024 CUSTOMER SEES THROUGHPUT BOTTLENECKS WHEN RAPID CONNECT / DISCONNECTS ARE PERFORMED IY54125 CRASH WITH SIGSEGV WITH ABNORMAL TERMINATION IN SQLEFLSR IY54175 TRAP WHEN DOING SQLFETCH ON THE BROKEN KOREAN CHARACTERS IY54369 TCB FIX COUNT CAN BE LEFT FIXED IF LOAD FAILS: SUBSEQUENT DROP TABLE WILL FAIL IY54529 REMOVE SORT IN EXIST SUBQUERY WHERE THERE IS AN ORDER BY REQUIREMENT IY54836 SQL0901 ON SORTING ZERO LENGTH KEYPARTS THAT ARE NOT NULLABLE IY54945 "POTENTIAL DATA INTEGRITY EXPOSURE PROBLEM IN UPDATE/EXTRACT UDFS" DEFECT # IS 317690 IY55027 NPE WAS FP12:ERROR IN PARSING IY55208 MULTI-COLUMN INDEX-BASED SEARCHES MIGHT CAUSE WRONG RESULTS TO BE RETURNED. IY55209 HANG CONDITION WHEN RUNNING A BATCH INSERT USING THE JDBC NET DRIVER IY55221 SQL1224 WHEN LOADING AN INVALID IXF FILE. INSTANCE IS STOPPED. SIG 4 IS SEEN AT SQLUMCPROCESSRESTORESTATES(). IY55228 SIGNAL 11 ON BSORTTRANSFMVARCHARNEXTTIME SOMETIMES. IY55286 DB2STOP HANGS DUE TO TIMING HOLE WHEN SENDING A SIGNAL TO THE DB2IPCCM PROCESS. IY55508 LINUX ONLY: DB2 HANGS DUE TO UNABLE TO ALLOCATE SECONDARY LOGS WHEN PRIMARY LOGS FILLED UP AND USER-EXIT DOES NOT WORK PROPERLY. IY55891 DASIUPDT SET WRONG PERMISSION TO DB2JOB . IY55994 INSTANCE CRASH DUE TO TID/FID NOT FOUND MESSAGE IN DB2DIAG.LOG IY56827 UNEXPECTED BEHAVIOUR WHEN DIFFERENT COLUMNS ARE REFERENCED. IY56833 INCREMENTAL BACKUP MAY CAUSE DB2 TO PANIC IF A TABLESPACE WITH SPARSE LOBS IS PART OF THE BACKUP. IY61019 INSTANCE CRASHES IN FUNCTION SQLPLKWT OR INIT_SQLM_APPL_ID_INFO DURING SNAPSHOT PROCESSING JR16864 INSTRUCTION AT "0X120507C7 REFERENCED MEMORY AT "0X00000000" COM.IBM.DB2.JDBC.DB2EXCEPTION: SQL1131N DARI (STORED PROCEDURE) JR17568 VISUAL EXPLAIN TRUNCATES NICKNAMES TO 8 CHARACTERS JR18579 USING 'SET CONNECTION' WHERE THE AS400 IS THE APPLICATION REQUESTOR USING 2 PHASE COMMIT/SNA, TRAPS THE APPLICATION SERVER JR19080 CLI0100E WHEN CALLING STORED PROCEDURE USING NET JDBC DRIVER AND STREAMED DATA INPUT PARAMETERS. JR19088 CHANGE DB2 GETHOSTBYNAME CALL TO RETURN FULLY QUALIFIED HOSTNAME JR19160 OMIT MICROSOFT SNA SERVER VERSION CHECKS WHEN STARTING SYNCPOINT MANAGER (SPM) JR19298 TERMINATING FRONTEND TOOL (E.G. CLP) WITH LONG RUNNING SQL WILL NOT NECESSARILY SIGNAL DB2BP, THUS NOT FREEING REMOTE RESSOURCES JR19325 LOAD STEP UNABLE TO GENERATE TARGET TABLE ON PROMOTION TO TEST/PRODUCTION AFTER EXPORT AND IMPORT. JR19326 DB2PROFC WITH QUALIFIER OPTION MAY WITHOUT WARNING GENERATE POOR QUERY PLAN FOR A DATABASE ON A HOST WHERE USERID DOES NOT EXIST JR19337 CONNECT FAILING WITH AS 400, WHEN AS 400 RETURNS AGENT LVL OF 3. JR19374 INCORRECT NOTIFICATION TIMESTAMP ON A FAILED STEP JR19389 LOCAL COMMIT CALLED IN SQLMORERESULTS WHEN USING XA TRANSACTION RESULTING IN XAER_PROTO ERROR JR19390 SQL30081N ERROR MESSAGE DISPLAYS A PARTIALLY WRONG TCPIP ADDRESS JR19447 INSERT NULL INTO DECIMAL COLUMN VIA OLEDB DOES NOT WORK. JR19450 CALL STATEMENT PARAMETERS LIMITED TO 1024 BYTES IN CLP. SQL0104N RETURNED. JR19487 SQLTABLES() FAILS WHEN USING DBNAME < 8 CHARACTERS AGAIN DB2/390 V8 JR19488 AFFECTS THE SQLDESCRIBECOLW() OUTPUT OF SQL_CHAR, SQL_VARCHAR & SQL_LONGVARCHAR COLUMNS - MAPS TO WIDE WITH MAPCHARTOWCHAR=1 SET JR19498 ENGINE HIT EXCEPTION IN SQLNS_RESET_SCOPE() DURING QUERY REWRITE PROCESS JR19536 SQL0901 WITH INVALID TRIPLET TYPE RETURNED FROM SELECT. JR19570 SPB INSERT FROM CLASS WIZARD DOES NOT SET ADVANCE Z/OS BUILD OPTS EG. WLM ENVIRONMENT NOT RECOGNIZED GETS SQL0104 TOKEN "LIMIT" JR19584 CONTROL CENTER FUNCTION TO SAMPLE CONTENTS TRUNCATES THE TIMESTAMP VALUE IN A COLUMN. JR19589 GATEWAY TRAP IN SQLJIFSR WHEN APP PREP-OPENS A CURSOR WITH MORE THAN 255 COLUMNS, AND THE OPEN FAILS ON THE SERVER. JR19629 C0000005 EXCEPTION ERROR IN SQLNO_COST_MGJN FUNCTION WHEN COMPARING A DEREFERENCE POINTER WHICH IS SQLNO_POP_SORT. JR19644 CODE -1042 WHEN IMPERSONATING NON-ADMIN SUER JR19653 MISSING IBM01140.UCS FILE IN DB2 V7.2 WINDOW FP10 JR19670 SQL0101N ON SELECT AGAINST FEDERATED. JR19681 DROP TYPED TABLE CRASHES INSTANCE JR19692 CLI0002W WHEN FETCHING DATA WITH DB2CONNECT_IN_APP_PROCESS=NO JR19698 ACCESS VIOLATION WHEN USING OLEDB ON V7 FP4 IF THE DATA SET IS LARGE > 1000ROWS JR19701 IN V72 CCA DB2CFIMP TOOL DOES NOT IMPORT/OVERWRITE THE EXISTING PROFILE CORRECTLY JR19712 DATA EXPANSION CAUSED BY UNICODE CLIENT -> UNICODE 390/V8 SERVERCAN CAUSE #DELETES IN MICROSOFT ACCESS, AND INCORRECT DATA JR19740 A -901 ERROR OCCURS IN SQLNO_PLAN_BEGIN_QGM AND THE TRAP FILE SHOWS A TRAP IN SQLNO_CLOSE_POOL JR19847 INCREASE DB2 SECURITY BY USING THE CREDENTIALS OF THE NAMED PIPE CLIENT FOR AUTHENTICATION. JR19849 DBCFG: PARMS DBHEAP BEING TRUNCATED TO SHORTS IN CC APAR fixes included in Fixpak 11 APAR No. Abstract -------- -------------------------------------------------- GG04388 IF THE DPROPR CAPTURE AND APPLY ARE STARTED FROM A WIN TERMINAL SERVICES (REMOTE) CLIEN SESSION THEY CAN'T BE STOPPED. IC36896 MEMORY LEAK ISSUE WHEN USING THE LOCATE IC37743 REGRESSION IN QUERY REWRITE/PUSHDOWN CODE AFTER APPLYING FP9 ON A UDB PF7 SYSTEM IC37744 INNER JOIN IS PUSHED DOWN BUT SHOULD NOT BE SINCE IT DEGRADES PERFORMANCE IY29165 PREVENT A LOCAL COMMIT ON A SUB-ORDINATOR NODE NODE LOG RECORDS HAVE BEEN WRITTEN. IY30708 WRONG RESULT FROM SELECT VIEW BASED ON CREATE A UNION ALL VIEW OVER THE LOCAL TABLE AND REMOTE NICKNAME ON REMOTE TABLE. IY31775 SQLPGRML() DOES NOT CLOSE SQLOFIND H IY34153 MEMORY CORRUPTION CAUSES INSTANCE CRASH WHEN RUNNING QUERY AGAINST MS SQL NICKNAME IY35005 TRAP IN SQLMSENDMONITORREQUEST IY37315 OUTER JOIN QUERY WITH UPPER() SHOULD USE INDEX ON GENERATED COL IY39251 SLOW PERFORMACE COMPOSITION BOTTLENECK DUE TO ROW LOCKING DEFECT 265579 IY40179 SQL0723N WITH SQLCODE -950 DELETING FROM A TABLE WHOSE DELETE TRIGGER DELETES FROM A TABLE WITH RI CONSTRAINT TO ITSELF IY40260 COMPLEX TEXT EXTENDER QUERIES MAY FAIL BECAUSE COLUMNS MAY NOT BE RETRIEVED WHEN EXPECTED. IY40777 VALUES TABLE RETURNS INCORRECT VALUE AFTER FIXPAK 3. INCORRECT OUTPUT WHEN THE LAST ROW OF THE VALUES BOX IS REQUIRED. IY41171 DATABASE MARKED BAD AFTER LINK FAILURE IY42098 ERROR MESSAGE DXXQ045E IS GENERATED WHEN ATTRIBUTES HAVE THE SAME NAME. IY43109 DB2 GOVERNOR CORES IN FUNCTION SCHEDULE IY44303 ERROR ON UNFIXING A PAGE (FUNCTION SQLBUFIX ) FROM THE BUFFERPOOL CAUSING THE DB TO PANIC AND INSTANCE SHUTS DOWN. IY44527 FIXES TO POTENTIAL CRASHES IN THE XA ENVIRONMENT IY44598 UNABLE TO NICKAME SQLSERVER 2000 TABLE WITH BIGINT DATATYPE IY44632 SET EFFECTIVE COLUMN CARDINALITY EVEN IN THE ABSENCE OF STATISTICS. IY44636 IMPORVE THE STAR JOIN PROCESSING UNDER REDUCED OPTIMIZATION CONDITIONS IY44841 SECURITY PROBLEM:DMS DIRECTORY IS CREATED WITH PERMISSION 777 IY44941 SQM_EVMON_MGR HOLDING THE EM_LIST_LATCH CAUSES DB2 TO HANG IY44997 DB2 DOES NOT DETECT THAT THE LSN IS REACHING 0XFFFFFFFFFFFF AND IS READY TO WRAP AROUND TO 0X0 IY45019 SQL0464W MESSAGES ARE NOT PROPERLY CLEARED AND THIS MIGHT CONSUME MEMORY WHERE MEMORY GROWTH IS OBSERVED IY45081 SQL1042 WHEN ISSUING DB2STOP IF NIS IS ENABLED. PROBLEM ONLY HAPPENS ON V7.2 INSTANCES BUT NOT ON V8 INSTANCES IY45097 SQL1024N WHEN PERFORMING A BIND WITH CONNECTIONPOOLING=1 SET IY45098 CTREADONLY NOT RESENT WITH CONNECTION POOLING ON - DRDA. IY45116 SQL30082 REASON CODE 15 WHEN USING DECRYPT_CHAR() WITH A PASSWORD SET WITH SET ENCRYPTION PASSWORD IN SMP ENVIRONMENT. IY45168 "UNABLE TO FREE TEMPARY SQLCACHE STMT" MESSAGE SHOWS UP IN DB2DIAG.LOG EVEN WHEN THE RETURN CODE IS 0. (IE: NORMAL) IY45264 SQL1072 ON DB2START AFTER CREATING NEW INSTANCE. WE WILL BACKFITV8 ALGORITHM OF IPC KEY GENERATION TO AVOID THIS PROBLEM. IY45270 SQL0101N WHEN TRYING TO EXECUTE REVOKE FROM USER WHEN DOING SOME POST PROCESSING FOR DEPENENT VIEWS AND SUMMARY TABLES. IY45507 AUTOLOADER CAN CORRUPT THE DATA BY HASHING RECORDS TO THE WRONG PARTITION. IY45515 SQL1084:CONNECTIONS MAY FAIL IN EEE MLN TRYING TO REUSE A FORMER"HOP" AGENT WHICH HAS NOT CLEANED UP AFTER A BROKEN CONNECTION. IY45529 ON AIX, APP IS GETTING CLI0602E. ON WINDOWS, APP IS GETTING CLI0120E. IY45585 DB2 OLAP SERVER ANALYZER GOT CLI0602E ERROR. IY45635 DURING TABLESPACE ROLLFORWARD TO POINT IN TIME, THE SQLB_REORG_IN_PROGRESS STATE CAN BE TURNED OFF INADVERTENTLY. IY45643 SQL0954C (NOT ENOUGH STORAGE) IN THE APPLICATION HEAP - MEMORY LEAK IN SQLRA_FP_ALLOC AND SQLRA_SAVE_REG IY45645 SQL2154 ERROR DURING TABLESPACE RESTORE IY45781 POOR PERFORMANC ON QUERY WITH CSES ON A COMMON VIEW. IY45802 EXPORT FROM A MAINFRAME WITH AN '*' INSTEAD OF COLUMN NAMES FOR THE 'SELECT' STATEMENT PUTS -805 MISSING SQLUAD09 IN DB2DIAG.LOG IY45825 -900 AT CALLING A STORE POOCEDURE, IF KEPPDARI=YES. WHEN IT HAPPENS THE CREATE PROCEDURE FAILS WITH -4998 TOO IY46025 HANG: MQBACK FUNCTION HANGS ON SQLXA_ROLLBACK. WHEN AGENT IS TERMINATING CLEAN UP XATXENTRY. IY46029 PROBLEM WITH AN UNINITIALZED INPUT PARM TO THE TCP/IP KERNEL CALL THAT CHECKS FOR THE STATUS OF THE CLIENT CONNECTION. IY46043 SQL0206N WITH USER DEFINED DATA TYPES WHEN USING REPLICA TYPE TARGET IY46124 XA APP GETS SQL0998 RC=9 WHEN RECONNECTING TO DB2 AFTER A FAIL STATE "AFTER A COMMUNICATION FAILURE". IY46163 SYSTEM CALL MSGSND() INTERRUPTED IN SQLOCSEMV() CAUSES DATABASE MARKED AS BAD IY46170 SQLLEN RETURNS INCORRECTLY 2 FOR DATALENGTH OF 4. AS A RESULT DATA RETURNS AS '0' BY SQLGETDATAINTERNAL. IY46174 ARRAYINDEXOUTOFBOUNDSEXCEPTION USING JDBC NET DRIVER. IY46208 QUERY PERFORMANCE PROBLEM DUE TO QRW RESTRICTIONS WHEN UNION ALLIN VIEW TABLES ARE INVOLVED. IY46295 INCORRECT RESULTS WHEN ONE ARM OF A UNION ALL CONTAINS A NOT EXIST CLAUSE. IY46323 SQL0973 OUT OF DBHEAP, PACKAGE CACHE ERRORS, SQL2009 OUT OF UTILITY HEAP DUE TO MEMORY LEAK WITH MONITORING OF TEMP TABLES IY46340 DISABLE SIGBUS HANDLING ON HP IY46374 CURRENTSCHEMA AGAINST AS/400 NOT WORKING IY46442 DB2 V8 CLIENT ON WINDOWS CANNOT CONNECT TO V7 FP9 SERVER ON AIX, FOR EEE SYSTEM (BUT PROBABLY NOT EEE RELATED). IY46446 WHEN USING EXPORT/IMPORT AND REDEFINING A COLUMN FROM VARCHAR TO CLOB THE IMPORT FAILS AFTER FP 9 IS APPLIED IY46497 JDBC INCORRECTLY RETURNS +100 FROM SQLPARAMDATA IY46499 MEMORY LEAK IN RESULTSET.GETBLOB() IY46523 ALLOW EXTRACT OF TABLES WITH GRAPHIC COLUMNS IN UNICODE DATABASES USING DB2LOOK. IY46539 IMPORT CREATE FOR A UNICODE TABLE WITH GRAPHIC COLUMN FAILS WITHSQL3319 IY46576 ABEND WHEN SELECTING WITH ORDER BY FROM 32K TABLESPACE IY46660 SQL30082 RC 24 WHEN CONNECTING FROM DB2 VERSION 8 TO DB2 VERSIO N 7 WITH SPECIFIC TRUSTED CLIENT AUTHENTICATION SETTINGS IY46706 SQL0104N WHEN IMPORTING DATA THAT WAS EXPORTED FROM DB2/OS390. COLUMN IS DATE TYPE AND HAS DEFAULT VALUE. IY46786 SIGNAL #11 DB2 TRAPPED IN SQLPGETNUMAPPLLOCKS CALLED BY SQM IY46803 DB2 SQLJ TO OS/390 TRAP OR SQL0516 OR SQL0303 ACCESSING BLOBS IY46855 CODEPAGE CONVERSION FILE IBM01141.UCS IS MISSING IN FP10 DB2 UDB IY46941 QUERY RETURNS INCORRECT RESULT DUE TO REDUNDANT REMOVAL OF PREDICATES WHEN IXAND IS USED. IY47037 OBJECT TABLE EXTENSION PROBLEM IY47043 ADD REPAIR FUNCTIONALITY TO ZAP PAGE COUNT FIELD OF OBJECT TABL IY47196 INCORRECT RESULTS WHEN USING FLOOR FUNCTION. IY47213 DB2 VALUES 1.0000*(0.0445/0.65) RETURNS WRONG RESULTS. IY47229 DB2 HANGS IN SQLNR_SORT_SIPS_ORDER RUNNING A BIND OR SQL COMMAND. IY47268 DB2LOOK GENERATES WRONG OUTPUT WITH -Z OPTION, WHEN IT'S RUN AGAINST DB2 ON OS/390 IY47295 DYNEXPLAIN CAUSES TRAPS IY47393 FUNCTION OVERRUNS END OF BUFFER RETURNING TOO MANY BYTES AND FAILS IN MEMSET() CAUSING A DATABASE CRASH. IY47437 APP CORES ON CLICPOOL.C ON DISCONNECT DUE TO MULTITHREADING TIMING HOLE IY47473 WHEN DOING A VENDOR LOAD COPY NO, WE DO NOT FILL IN THE TIMESTAMP IN HISTORY FILE ENTRY IN LOAD WHICH CAUSE TO LOOSE THAT ENTRY IY47484 INCORRECT CONVERSION OF "I" & "Y" WHEN USING LOWER() FUNCTION IN A DATABASE WITH TURKISCH CODEPAGE 920 IY47497 FOLLOWING A CRASH DURING LOG TRUNCATION, WE CAN CRASH AGAIN WITH THE ERROR "LOG PAGE INCORRECTLY MARKED FOR TRUNCATION" IY47520 ERROR IN TRUNCATING LOG DURING NORMAL DATABASE SHUTDOWN RESULTS IN PARTIALLY TRUNCATED LOG FILE. IY47562 FIX FOR 32-BIT APAR IY40106 IN 64-BIT CODE IY47636 CREATE INDEX ATTEMPT AFTER FIRST CREATE INDEX ATTEMPT FAILS DUE TO LOG FULL CONDITION MAY CRASH DATABASE. IY47664 INSTANCE CRASH DURING CREATE DB WITH EXPLICITELY GIVEN TABLESPACES ON SPECIFC HP ARCHITECTURE IY47673 SQL4302N WITH CLI0115 ON THE SP CALL WITH FEW SELECT STATEMENTS (FP10 SPECIFIC). IY47674 DB2IMIGR COMMAND FAILS. "DBI1222W THE SYSTEM DATABASE DIR IS CORRUPTED AND CANNOT BE MIGRATED." DB2IMDBD EXIT CODE 3 IY47678 SIGSEGV REPORTED IN SCROLLGETAROW2 IY47731 MIGRATE DATABASE TRAPS IN SQLNQ_FINDFN IY47787 ABEND: DB2 ABENDS AND TRAP OCCURS IN FUNCTION SQLODSHR IY47899 QUERY PATROLLER USES UPPERCASE USERNAMES BUT DB2 USES LOWERCASE IY47919 SQL1822N WITH ORA-12705 ERROR WHEN USING DB2 RC TO ACCESS ORACLESOURCE TABLE WITH CHINESE CHARACTERS VIA NICKNAME IY47920 CHINESE CHARACTERS BEING DISPLAYED AS "??" WHEN USING RC TO ACCESS ORACLE DB FOR 1ST TIME DATABASE CONNECTION SINCE DB2START IY47936 SQL1131 WHEN CALLING SP FROM HOST COBOL APP MULTIPLE TIMES IY47947 EXPORT TO PIPE FAILS WITH SQL3001N RC = -2538, IF THE READ SIDE OF THE PIPE IS AUTOLOADER (DB2ATLD) IY47976 DB2 INSTANCE CRASH WHEN ADDING OBJS IN W2K PERF MONITOR W/ FP9 IY48209 SQL1224 FROM RUNNING A UNION QUERY WITH MANY INLIST ITEMS IY48336 EXPORT FAILS WITH SQL0986 ON TABLES WITH DECIMAL COLUMNS AND CODEPAGE SPECIFIED. IY48363 SQL0304 WHEN TRYING TO USE THE 'CREATE NICKNAME' COMMAND IY48458 INSTANCE CRASH IN OPTIMIZER FUNCTION SQLNO_FIX_DEPEND_QUN FOR CERTAIN QUERIES INVOLVING HIERARCHY TABLES IY48464 INCORRECT RESULTS PRODUCED WHEN USING LIKE AND A WILDCARD, WHEN AN INDEX IS PRESENT. IY48467 NUMBERFORMATEXCEPTION IN DB2CALLABLESTATEMENT.GETBIGDECIMAL WHEN DEFAULT LOCALE'S DECIMAL SEPARATOR DIFFERS FROM "." IY48515 THE COMPLILATION OF A QUERY THAT INVOLVES BOTH A SUMMARY TABLE AND A NICKNAME WILL CAUSE AN INSTANCE CRASH. IY48547 DB2AGENT HITS SEGV IN SQLO_LATCH_ATTEMPT_SEIZE ON NON-COORDINATE NODES (UPPER CALLER IS SQLELATCHAPPLIST). IY48571 INCORRECT RESULTS RETURNED WHEN USING "WITH" CSE WITH REPLICATED SUMMARY TABLE REFERENCED... IY48572 INSTANCE CRASH, TRAP IN SQLCSPP_PREPARE, AFTER ORACLE INSTANCE CRASHES IY48656 IN DISK FULL SITUATION, ENGINE MISTAKENLY CREATES A NEW PAGE FORAN OBJECT, WHEN THERE IS NO SPACE. IY48731 DB2 CRASHED WHEN ACCESSING AR_FUNC IY48734 QUERY RETURNS BEFORE FINISHING AND CAUSES CLIENT TO BE DISCONNECTED WITH ONE TRAP FILE AND NO DB2DIAG.LOG MESSAGES. IY48943 DB2 BACKUP WILL GROW DISPROPORTIONATELY IN SIZE IF TABLES ARE CREATED "UNDER" ANOTHER TABLE ( HIERARCHY ). IY48957 REBALANCING PROCESS HANG. THE REBALANCING AND SNAPSHOT OPERATIONS WAIT EACH OTHER FOR INTERNAL LATCHES IY48970 SQL STORE PROC COMPILE CRASHES INSTANCE IN FUNCTION SQLNQ_EXP::CORRELATION_TOQNC IY48972 BLOB DATATYPE LENGTH BEING DESCRIBED INCORRECTLY IY48987 INSTANCE ABENDS WITH SIGNAL 11 (0XB) ON QUERY WITH NESTED SUBSELECTS IY49079 UPDATE IS NOT UPDATING THE RIGHT NUMBER OF ROWS WHERE IT'S USINGA SELF REFERENCING SUBQUERY IN A PARTITIONED ENVIORNMENT.. IY49166 WHEN HASH JOIN IS ENABLED, COLUMNS CONTAINING TRAILING SPACES MAY NOT COMPARE CORRECTLY. IY49294 PRIMARY KEY IS NOT CREATED IN THE IXF EXPORT FILE WHEN USING THE TABLE ALIAS. IY49297 PREDICATE IN SUBQUERY MARKED AS REDUNDANT AND CAUSES INCORRECT IO IY49298 TO INCLUDE ADDITIONAL OPTION FOR DB2ADVIS COMMAND. PREVENTING PASSWORD TO BE SHOWN WHEN "-A /" IS USED. IY49299 SIG#11, TRAPPED IN SQLULOADPARTITION IY49325 DB2LOOK FAILS TO DOUBLE SINGLE QUOTES FOR COLUMN COMMENTS IY49339 DB2AUDIT EXTRACT COMMAND CREATES SEGMENTATION FAULT WITH CORE DUMP IN SOLARIS OPERATING SYSTEM IY49359 RESTORE REPLACE EXISTING MAY LEAD TO DIFFERENT COLLATING SEQUENCE ON EEE NODES IF ADDING A NEW NODE AFTER THE RESTORE. IY49365 BAD PERFORMANCE BECAUSE OF LOST PREDICATE IN QUERY PLAN. IY49370 DB2 ROLLFORWARD DB LOG BY LOG CAN RETURN SQL1265N: LOG EXTENT NOT IN CHAIN, BUT WHEN YOU LOOK AT THE LOG HEADERS, THEY ARE. IY49437 INFINITE LOOP OF SQM.SQLMONSSAGNT PROBE:1234 IN DB2DIAG.LOG AND HANG WHILE GETTING SNAPSHOT ON WRITE SUSPENDED DB. IY49456 TRAP DURING CHANGE PASSWORD IY49489 INDEX NOT USED FOR QUERY WITH OUTER JOIN AND UPPER(COLUMN). IY49573 FAILOVER UNSUCCESSFUL FOLLOWING WRITE SUSPEND AND WRITE RESUME IY49578 SQL FUNCTION UTILIZING CURRENT SCHEMA TO QUALIFY A TABLE REF. FAILS WITH -204 SHOWING A CORRUPTED NAME FOR THE QUALIFIER. IY49680 SQL0525N ON GETCOLUMNS() AGAINST OS/390 DB WHEN _ OR % ARE USED IY49736 SQL30081N (*,*,0) AFTER ISSUING SQL STATEMENT. IY49779 DB2 HANGS IN EVENT MONITOR TERMINATION CODE PATH IY49850 ONLINE DATABASE BACKUP FAILS WITH SQL0902C IY49884 CLI0125E ON SQLEXECUTE() FOLLOWED BY SQLPARAMDATA() IY49981 USE OF KEYSET CURSOR RESULT IN SQLCODE -243/-228 AGAINST V8 HOST IY49986 SQLCA STRUCTURE NOT FILLED WHEN FAILING TO ALLOCATE MEMORY FOR A BLOCKING CURSOR. IY49991 EXECUTEBATCH () WITH CLOBS RETURNS CLI0109E - STRING DATA RIGHT TRUNCATION IY50045 USE OF RSH WHEN PERFORMING FAILOVER AND ORIGINAL HOST IS DOWN IY50088 CANNOT CONNECT THROUGH LDAP TO THE HOST DATABASE IF DB IS CATALOGED WITH LESS THAN 8 CHARACTERS IN DBALIAS - SQL30020 RC=124C. IY50102 INSTANCE TRAP IN SQLOFMBLKEX CAUSED BY SQLMON_DCS_APPDTV() ON GATEWAY IY50112 FEDERATED INSTANCE TRAP WHEN QUERY ON NICKNAME IS BEING FORCED OFF FROM THE DATASOURCE SERVER (ISSUE FORCE APPLICATION / CRASH) IY50153 CALL TO SETMAXFIELDSIZE DOES NOT RESET CAUSING DATA TRUNCATION IY50181 FUNCTION UCS_2_EUC_CONVERSION TRAPS BECAUSE OF AN ATTEMPT TO DIVIDE BY ZERO. IY50182 MEMORY LEAK IN DRDA AS WHEN PROCESSING QUERIES IY50185 SEGV IN SQLE_DB2RA_AR_SENDRECV TRYING TO REUSE A TERMINATED CONNECTION. IY50191 LATCH CONTENTION IN DPS CODE RESULTING IN ALL DB2 COMMANDS HANGING. IY50222 SIG #11 IN MEMTREEPUT/SQLNG_ALLOC_STORAGE/SQLNG_BUILD_SCALAG_OP IY50244 APPLICATION RECEIVING SQL0804 RC 106 (SQLAKCHECKSQLDA) IY50268 AN EXTRA COLON, :, IS ADDED TO THE PATH, IF THE ORIGINAL PATH ENDS WITH A COLON. IY50322 INCORRECT RESULTS OR INSTANCE CRASH WHEN RUNNING A QUERY IY50323 PRUNING HISTORY FILE TAKE LONG TIME DURING BACKUP IF IT HAS MANYFOR SIMULTANEOUS LOADS WITH MULTIPLE LOAD COPY TARGETS. IY50357 INSTANCE CRASH FROM AN INTERRUPTED AGENT IY50397 DBADM AUTH DOES NOT HAVE USE TABLE PRIV WHEN CREATING TABLE IY50412 DB2 CLP HIT DB21015E IF IT'S PPID AND UID ARE BIG NUMBERS. IY50436 SQLUGTPIWILL ALWAYS MISTAKENLY RETURN SQLTYPE VARGRAPHIC FOR PARTITION KEYS THAT ARE GRAPHIC. IY50470 NEED TO CHECK FOR INTERRUPTIONS WHEN DOING LEFTOVERS PHASE OF HASH JOIN IY50769 REPEATED ARCHIVE LOG COMMANDS ON A DATABASE WITH NO ACTIVITY RESULTS IN LOG FULL MESSAGES. IY50801 DB2LOOK SHOULD GENERATE "REFRESH TABLE" STATEMENT WHEN A NEW INDEX IS CREATED ON A TABLE IN CHECK PENDING STATUS. IY50810 CALLING CLI FUNCTION SQLNUMRESULTCOLS CAUSE ERROR TO BE LOGGED IN DB2DIAG.LOG IRRESPECTIVE OF DIAGLEVEL. IY50995 TRAP IN SQLNO_CRULE_STARJN_AND. THIS IS DUE TO A NULL POINTER FOR THE PLAN LIST RETURNED BY SEMIJOIN FUNCTION. IY51085 SQL0901N WHEN MERGING TWO UNION OPERATIONS IN THE SAME QUERY DURING QUERY OPTIMIZATION. IY51144 WHEN ATTEMPTING TO ACCESS A TABLE IN A DMS TABLESPACE THAT HAS BEEN OFFLINE REORG'D, THE REQUEST FAILS WITH A SQL1007N. IY51236 SIGNAL #11 TRAP IN SQLNO_FIND_HASH_TABLE IY51250 OPTIMIZATION LEVEL OF ONE STATEMENT IS DEPENDENT ON THAT OF ANO-THER STATEMENT IN THE SAME CONNECTION. IT SHOULD BE INDEPENDENT IY51463 SMS TABLESPACE NEEDS TO CHECK IF LARGEST POOL PAGE NUMBER HAS BEEN REACHED. IY51715 SYNTAX ERROR IN DB2 GOVERNOR SCRIPT DB2GOV IY51716 DB2 CONNECT V8.1 GA IS LOOKING FOR LIBMQMAX.A IN /OPT/MQM/LIB RATHER THAN FOR LIBMQMAX.SO IY51731 ABEND:LOAD IN MPP FAILED WITH SQL2038N RC=27990 IF TARGET TABLE HAS VARGRAPHIC/GRAPHIC COLUMN USED FOR PARTITIONING KEY IY51750 POTENTIAL PERFORMANCE DEGRADATION IN SQL COMPOSITION CAUSED BY FALSE CONVERSION ERROR DETECTION. IY51774 A QUERY FAILS WITH SQL0901: BAD PLAN: UNRESOLVED QNC FOUND. IY51794 DB2 CRASH (PANIC) WHEN RUNNING WITH STATEMENT MONITOR SWITCH SETTO YES IN TABLE QUEUE CODE IN A EEE ENVIRONMENT IY51832 DATABASE INSTANCE CRASHES WHEN INSERT ROWS INTO TABLE USING JDBC IY51838 CANNOT CONNECT TO THE DATABASE LOCALLY WHEN USING THE PASSWORD THROUGH THE REMOTE LDAP. JR05500 NOT ALL STATEMENTS ARE CAPTURED IN STATIC CAPTURE. JR05502 DUMP ERROR MESSAGE IN DB2DIAG.LOG WHEN WINDOWS SERVER HITS THE MAX. OF DB2NTMEMSIZE JR17349 THERE IS NO SCROLL BAR FOR UDPS IN DATA WAREHOUSE CENTER. DWC JR17374 INCORRECT RESULTS RETURNED BY DB2ADUTL WHEN SPECIFYING A LARGE #FOR THE DELETE OLDER THAN OPTION JR17634 ERROR -1031 DURING CATALOG RESYNC IN MSCS ENVIRONMENT JR17806 EXPORT/IMPORT TO THE SAME DB2/390 TABLE FROM DB2 CONNECT GOT SQL3169N ERROR JR17825 THE TRUNCATION WARNING IS CAUSING THE IF EXPRESSION NOT TO BE EVALUATE. JR17931 INTRODUCE A NEW LDAP GLOBAL REGISTRY VARIABLE-DB2LDAP_KEEP_CONNENECTION SO THAT USER DON'T HAVE TO SET IT FOR EACH MACHINE. JR17945 -104 RESULTED FROM IMPORTI/LOAD WITH CREATE INTO OPTION. JR18395 DWC- SQLASSIST MOVING A CALCULATED COLUMN TO A SPECIFIED PLACE IN LIST OF COLUMNS, CHANGE FROM ADD TO BOTTOM OF LIST JR18434 TEMPORARY PATHNAMES WITH SPACES CAUSE SCRIPT CENTER SCRIPTS TO FAIL WITH DBA2078E. JR18469 BACKUP TO TAPE ON WINDOWS MAY CRASH INSTANCE JR18472 CONNECTING TO A V8.1 DB2 UDB ON LINUX USING V7.2 CON TROL CENTER ON WINDOWS 2000, DRILLING DOWN TO THE DBS SPINS JR18474 DECIMAL RESULT TRUNCATION WHEN USING W2K ITALIAN LOCALE JR18475 SIGNAL 11 REPORTED IN FUNCTION SQLPGSPR CAUSING INSTANCE ABEND JR18483 DWC- COPY OR MOVE OF STEP IS NOT REFRESHED WITHOUT CLOSING AND RE-OPENING NAVIGATOR,APPEARS AS MISMATCH WITH METADATA JR18484 DWC- STEP DEMOTED OR PROMOTED IN NAVIGATOR, STATUS OF LOCKS MAY NOT BE ACCURATELY DISPLAYED JR18509 DB2 TRACE FOR STORED PROCEDURE ON IBM-943 CODEPAGE GOT TRAPPED. JR18512 CLOB RETRIEVAL AGAINST 390 HOST RESULT IN ONLY 1-4K PIECES WITH THE SQLGETDATA JR18516 OLEDB DRIVER CAUSES THE WRONG INFORMATION TO BE PASSED TO SQLSETDESCREC AND THE APPLICATION RETURNS CLI0111E. JR18518 TRAP WHEN USING REGR_SCOPE JR18520 DWC- MIGRATION VW 5.2 TO DWC V7.2 GUI CODE IS DEPENDENT ON HAVING A "DEFAULT" SECURITY GROUP JR18541 DWC - MIGRATION VW 5.2 TO DWC 7.2 FP7.... MISMATCH CAUSED BY MISSING REQ. TO SQLASSIST FOR GROUPBY JR18544 GATEWAY TRAP IN SQLE_DB2RA_PUTBUF2 WHEN CALLING SP WITH DBCS UNICODE DATA, WHEN SP ACCEPTS ONLY SPBC DATA. JR18548 DWC - SCREEN OCCASSIONALLY FREEZES (TURNS GRAY) THIS FIX IS FOR THE FLASH OF FROZEN SCREEN. TO UNFREEZE IT JR18550 DWC- SQLASSIST SEES TWO COLUMNS ATTEMPTING TO BE JOINED AS INCOMPATIBLE , BOTH CHARACTER, ONE IS FOR BIT DATA JR18555 CUT AND PASTE A JAVA STORED PROCEDURE FROM Z/OS USING THE STOREDPROCEDURE BUILDER - EXECUTION FAILS WITH AN SQL0204N ERROR. JR18578 INPUT CHAR PARAMETER CAN NOT HAVE LENGTH OF 0. JR18582 SQL1820N RC=1 STORING LARGE BLOBS VIA STORED PROCEDURE JR18601 JAVA.SQL.TYPES.DISTINCT BEING RETURNED (I.E,2001), INSTEAD OF JAVA.SQL.TYPES.CLOB( 1.E,2005). JR18615 CONTROL CENTER TRACE FAILS - EXCEPTION IN THREAD "MAIN" JAVA.LANG.NOCLASSDEFFOUNDERROR: DATACACHE/IDATAUNIT JR18616 STORED PROCEDURE BUILDER TEXT CHANGED FROM JAPANESE TO ENGLISH BY FIXPAK 9 JR18619 MIGRATION FAILURE DUE TO UDF_MEM_SZ HEAP PROBLEM. JR18646 COMP=OLE_DB_SUPPORT NOT IN SOME DEFAULT RESPONSE FILES. JR18648 DB2 CONNECT: DRDA HEAP GETS CORRUPTED WITH THE SET CURRENT STATEMENT. THIS CAN BE SEEN WITH DB2MEMDBG TURNED ON. JR18651 DWC\SQLASSIST-FOR LONG, COMPLEX SQL STATEMENTS, SQL ASSIST TAKESA LONG TIME TO CLOSE. JR18669 DSNL032I -DSNT DSNLIRTR DRDA EXCEPTION CONDITION IN REQUEST FROM REQUESTOR LOCATION... JR18717 NUMBERFORMATEXCEPTION WHEN RETRIEVING VALUE OF INOUT BIGDECIMAL JR18730 CLI0002W DATA TRUNCATED WHEN EXECUTING A CALL TO A STORED PROCEDURE JR18740 DWC - DOUBLE CLICK REMOVES TABLE FROM RIGHT COLUMN, COMMON CLASSPROBLEM JR18748 DWC - CAN NOT REMOVE SOURCE IF IT IS SQL SEVER DATABASE. JR18762 BLOB COLUMN NOT BEING SET TO NULL VIA SQLPUTDATA() JR18783 DWC - SQLASSIST, JOINS CONVERSION OF 5.2 TO 7.2 JOIN SQL DOES NOT LOOK THE SAME IN 7.2 AS IT DID IN 5.2 ALTHO' FUNCTION/SAME JR18791 DWC - DAILY SCHEDULE SKIPS A DAY IF SCHEDULE IS TO START LESS THAN 24 HOURS FROM CURRENT TIME JR18796 CLI TRAP IN SQLDESCRIBEPARAM WITH PATCH1=65536 SET JR18797 DWC - IN RESPONSE TO ONETIME ERROR 8525 # OF ELEMENTS DIFFERENT SQL CHANGE TO REPORT ALL CODES POSSIBLE FOR THIS JR18800 DB2JDS PROCESS CRASHING IN SQLOFMBLKEX() FUNCTION. THIS CAN BE SEEN IN THE DR. WATSON LOG FILE JR18836 IMPORT FAILS USING DELIMITED DATA - INT / CHAR PARSER PROBLEM JR18837 SQL1088W WHEN CREATING DATABASE WITH CONTROL CENTER JR18849 DOUBLE-BYTE LENGTHS MISINTERPRETED AS CHARS JR18855 DWC - SCHEDULE WINDOW SLOW TO RETRIEVE INFORMATION .. CODE TO REDUCE THAT RESPONSE TIME JR18865 CONTROL CENTER NOT SHOWING THE CORRECT USER SECURITY SETTINGS FOR AST TABLES JR18872 WHEN THE CONCENTRATOR IS ENABLED, CUSTOMER RECEIVES CLI0002W UPON FETCHING A STORED PROCEDURE RESULTSET. JR18874 STORED PROCEDURE BUILDER FAILS WITH ERROR SQL0440N WHEN RUNNING A JAVA STORED PROCEDURE AFTER CHANGING A PARAMETER NAME JR18880 DWC - DATES AND TIMESTAMPS DO NOT ALWAYS REFLECT CORRECT INFORMATIION IN WIP. JR18890 THE LENGTH OF THIS VARGRAPHIC FIELDS CONTENTS IS DOUBLED IN SIZE JR18899 SQL0918N ERROR DESPITE HAVING ISSUED A ROLLBACK FROM APPLICATION JR18900 DWC- SQLASSIT - SAVING CONTENTS OF ONE STEP INTO ANOTHER, SAVINGTHEN TRYING TO EDIT, BREAKS JR18903 STORED PROCEDURE BUILDER LOOSES SP COMMENTS WHEN SAVING SP GOING FROM WINDOWS TO OS/390. JR18908 EXCEPTION NOT THROWN WHEN LOCK TIMEOUT EXPERIENCED JR18917 LENGHT() CALL ON CLOB RETURNS THE NUMBER OF BYTES INSTEAD OF THE CHARACTERS IN A MULTI BYTE DATABASE JR18947 DWC-ON THE CLIENT MACHINES, ARE BEING THROWN OUT OF WAREHOUSE SPORADICALLY ON PROMOTE,DEMOTE,EXIT SQLASSIST JR19062 RESULTSET CORRUPTED ON PRE-FP9 CLIENTS WHEN CONNECTION POOLING IS ENABLED ON FP9+ DB2 CONNECT GATEWAY. JR19066 DWC - WHEN USING THE LOCATE FUNCTION WITHIN DWC IF A WILD CARD IS USED (IE. %DEPT) WRONG RESULTS ARE RETURNED. JR19095 ERROR JAVA.IO.UTFDATAFORMATEXCEPTION OCCURS WHEN USING STORED PROCEDURE BUILDER TO SAVE A PROJECT WITH JAVA SP > 64K LENGTH. JR19097 AT DIAGLEVEL 4, DB2DIAG.LOG SHOWS MANY FILE OPEN ERRORS (SQLOOPE NP) FOR MESSAGE FILES LIKE D:\SQLLIB\MSG\C\DB2SQL.MO JR19102 WHEN SHUTTING DOWN THE MACHINE, DB2SYSC AND DB2DAS ARE NOT SHUTTING DOWN PROPERLY. JR19105 AFTER MODIFYING STEP, DWC SESSION IS LOST JR19115 DB2 (LDAP SERVER)-NOT PICKING UP CORRECT VALUE FOR DB2INSTANCE BEFORE STARTING DB2. JR19137 GEOCODE FAILURE JR19149 SQLGETDIAGRECW INCORRECTLY RETURNS SQL_SUCCESS FOR THE TRUNCATEDERROR MESSAGE. SHOULD BE SQL_SUCCESS_WITH_INFO JR19153 NO RESULTS RETURNED FROM A STORED PROCEDURE WHEN A JAVA SP CREATED ON WINDOWS, IS COPIED AND PASTED TO Z/OS DB2 AND REBUILT JR19161 IN RECORDSET OF ADO OBJECT USING IBMDADB2, ALL OF THE FIELDS HAVE ADFLDMAYBENULL SET TO TRUE. JR19164 DWC - DATA WAREHOUSE CENTER SERVER MAY FAIL ON WINDOWS 2000, WITH NT EVENT OF 7031 JR19166 DWC - MIGRATED CONTROL DB FROM VISUAL WAREHOUSE, STEPS MAY NOT WORK. JR19185 ACCESS VIOLATION IN CLI_CPQTIMEMON JR19186 FILTER SCHEMAS WINDOW DOES NOT WORK WITH WILDCARD CHARACTER. JR19200 PROBLEM USING JDBC GENERATE.JAVA TO CALL DXXGENXML() STORED PROCEDURE. ERROR RETURNED SQL0423N,DXXM011W AND DXXG001E JR19209 TIMING HOLE IN CLI CAUSING CRASH IN SQLNUMRESULTCOLS() JR19238 OBJECT NAMES WITH QUOTES GETS CORRUPTED ON EXPORT AND IMPORT JR19303 GETROW() IS RETURNING THE WRONG RESULTS WHEN TYPE_FORWARD_ONLY IS SPECIFIED AND THE ENTIRE RESULTSET IS NOT RETRIEVED. JR19412 WINDOWS, CORRUPTED STACK CAUSES TRAP JR19416 AFTER DISABLE AND RE ENABLE OF XML EXTENDER COLUMN , UPDATE TRIGGER FAILS IS SET XMLCOLUMN = XMLCOLUMN JR19417 XML EXTENDER ADMINISTRATION WIZARD CALL DB2XML.DXXENABLEDB INSTEAD OF CALLING QDBXML.DXXENABLEDB. SQL0204 JR19426 SYMPTOM: STEPS IN A PROCESS REARRANGE WHEN METADATA IS MIGRATED FROM V7 AT FP5 WINDOWS TO V8 FP2 WINDOWS TO V8 AIX AT FP2. JR19430 TRAP IN SQLMEIOT AT SQM_EVMON_IOT. JR19433 SELECT ON NICKNAME CONTAINING MDL FUNCTIONS CAUSES A UDB CRASH LI70220 SQL0104N - IMPORT INTO OS/390 TABLE WHEN OS/390 DECIMAL ZPARM ISSET TO A COMMA SA96242 DWC I-SERIES AGENT REQUIRES TARGET TO HAVE COMMITMENT CONTROL APAR fixes included in Fixpak 10a APAR No. Abstract -------- -------------------------------------------------- IY44816 SLOW DATABASE ACTIVATION, ROLLFORWARD FAILS WITH SQL1265 , OR DATABASE CRASHES AND IS NON-RECOVERABLE IY47653 DB2LICM ALLOWS FOR USERS WITH EXECUTE PERMISSION OVER DB2LICM TO ACHIEVE ROOT PRIVILEGES IY47686 DB2 SEARCH DISCOVERY LISTENER CAN STOP RESPONDING BY SENDING A MALICIOUS NETWORK PACKET. IY47987 SYSADM_GROUP EXECUTE OF DB2JOB OUTPUT FILES COULD ALLOW LOCAL ROOT EXPLOIT APAR fixes included in Fixpak 10 APAR No. Abstract -------- -------------------------------------------------- GG04394 DPROPR CAPTURE FOR WORKSTATIONS DOES NOT HANDLE UTILITY TYPE LOG RECORDS CORRECTLY. THE SYMPTOM IS UNPREDICTABLE. IC35840 WHEN CALLING ORACLE UDF VIA RELATIONAL CONNECT,PERFORMANCE IS SLOW. IC36344 V7 DB2 UDB CLIENT CALLS A STORED PROCEDURE WITH LOB PARAMETERS ON OS/390 THROUGH GATEWAY, TRAPS IY29073 JOIN OF 27 TABLES FAILS SQL0101, THIS LARGE TRANSITIVE JOIN WILLCREATE A HUGE NUMBER OF PREDICTED PREDICATES. THIS USES UP IY29791 LONG PREP TIME DUE TO EXPONENTIAL GROWTH IN THE NUMBER OF CANCATENATED KEYS. IY30004 APPLY SUPPORT FOR NEW V8 REPLICATION CONTROL TABLE STRUCTURES IY30153 INCORRECT CARD ESTIMATES IN EEE WHEN BOUND TO SINGLE NODE IY32976 DATABASE INTERMITTENTLY MARKED BADWHEN CREATING DECLARED GLOBAL TEMP TABLE -> FFFFF102 RETURNED FROM SQLRL_DGTT_RCV IY33412 IMPLEMENT PUSHDONW OF REGULAR JOIN THROUGH OJ IF IT IS NEAR UNIQUE. AS WELL PUSH DOWN IF THERE IS MULTIPLE OJS. IY34572 REMOVE THE NEED TO BE SYSADM IN ORDER TO BE ABLE TO ISSUE THE CMD "DB2 UPDATE CLI AT GLOBAL LEVEL" IY36278 USE INLIST SIZE TO PLACE UPPER BOUND ON EFFECTIVE COLUMN CARD AS IT IMPACTS INLIST QUERIES IY36962 SIGNAL 11 GENERATED WHEN CALLING SQLJ.INSTALLJAR FROM CLIENT OR NON-CATALOG NODE. IY37281 PERFORMANCE DEGRADATION ON QUERY WITH IN LIST OF 200 OR MORE ELEMENTS AFTER UPGRADE TO FIXPAK 4 IY37712 DB2CKLOG NOT DETECTING SPECIFIC LOG CHECKSUM CORRUPTION IY38228 SUPPRESSING THE SQL1427 ERROR MESSAGE IN THE DB2DIAG.LOG WHICH IS BEING LOGGED NEEDLESSLY BY THE AUTOLOADER PROCESS. IY38451 CHANGE COSTING ON REFETCH THAT IS PLACED ABOVE A HSJOIN THAT DON'T SPILL, FOR UPDATES. IY38606 DB2.O CREATING DUPLICATE LIBDB2.A LIBRARIES WHEN USING AN ODBC DRIVER MANAGER. IY38790 THE MAXIMUM LENGTH OF DEFAULT VALUE FOR CHAR COLUMN IS INCONSISTENT. IY39222 CAPTURE AND SQL0180N IY39381 TRAP THROUGH SQLMON_TS_LIST::SIZE_TS_LIST IY39483 CUSTOMER RUNNING DB2EMCRT DBALIAS. IF DB2ALIAS NOT EQUAL TO DB NAME THEN DBA5500 FOLLOWED BY DBA1154 IY39728 DURING CRASH RECOVERY OF DB2 CONNECT SPM, DB2 LIST DRDA INDOUBT TRANSACTIONS, DB2STOP, DB2STOP FORCE COMMANDS HANGS. IY39731 LOAD OR IMPORT OF A LOBFILE THAT IS LARGER TAHN 2 GB WILL FAIL IY39767 SET INTEGRITY ON A TABLE WITH SELF-REFERENCING RI AND GENERATED COLUMNS COULD CAUSE AN ENGINE TRAP. IY39799 DB2 CONNECT RETURNS INCORRECT SQLCA SQLERRP VALUE FOR IDENTITY OF THE DATABASE WHEN USING TCP/IP CLIENT ON DB2/ZOS. IY39938 DROP_DLM ALWAS RETURNS, DLFM1001E:ERROR IN DROP_DLM PROCESSING IY39950 SQL1131N WHEN RUNNING NESTED STORED PROCEDURES IY40098 FRACTION PART OF DECIMAL MISSING DURING INSERT VIA JDBC. IY40106 UNPREDICTABLE OUT-OF-MEMORY FAILURES ON 32-BIT SYSTEMS WHEN DATABASE SHARED MEMORY CONFIGURATIONS ARE CLOSE TO OR EXCEED 4GB IY40118 SIGBUS ON HP 11 WITH DB2 CLIENT. IY40135 SIGNAL #11 SIGSEGV TRAP IN SQLESRVR IN CLEANUP CODE AFTER AN SQL1034 HAS ALREADY BEEN RECEIVED. IY40139 SIGNAL 11 IN SQLRIRIDC OR SQLRI_RESTORE_DML_DSS_INFO IY40143 DBA1107 AN ERROR OCCURRED WHEN THE PERFORMANCE CONFIGURATION WIZARD TRIED TO GET SYSTEM INFORMATION FROM YOUR SERVER. LINUX. IY40174 INSTANCE CAN CRASH IN SQLE_DB2RA_GETDATAAREA() WHILE DEALING WITH STATIC BLOCKABLE CURSOR IN PASSTHROUGH MODE IY40210 USING IBM'S OLE DB PROVIDER, CUSTOMER TRIES TO RETRIEVE A RESULTSET AND GETS "CONNECTION TO SERVER IS LOST" IY40264 BLAST DAEMON FOR BLAST WRAPPER (LIFE SCIENCES DATA CONNECT) CORES ON RED HAT 8 WITH GLIBC 2.2.93 IY40341 DESCRIBEPARAM CALL FAILS ON BAD SQL AND ERROR GETS MAPPED WRONG BY IBM'S OLE DB PROVIDER. IY40419 STATEMENT CACHING CAUSES DB2 TO IMPROPERLY RETRIEVE DATA IY40427 ALLOW JCC CLIENTS TO DESCRIBE INCREMENTAL BIND SECTIONS AT RUN TIME IY40433 DB2STOP FAILS TO CLEAN UP THE DB PROCESSES UNDER LIMITED CIRCUMSTANCES IY40438 FIX DB2DATASOURCE CLASS SO IT IS THREADSAFE IY40439 INITIAL CONNECTION/ACTIVATION APPEARS SLOW IY40515 POSSIBLE INSTANCE CRASH WHEN CLI OPTION MULTICONNECT IS SET TO 3(NO TRAP FILES ARE GENERATED.) IY40567 CAPTURE COREDUMPS WHEN A BEFORE IMAGE COLUMN DOES NOT HAVE A MATCHING BASE COLUMN. IY40568 SQL30090 ERROR IN DB2/C/CICS FOR "CURSOR WITH HOLD" IY40583 WHEN EXECUTING THE "END COMPOUND" COMMAND AGAINST A HOST (OS/390, AS400...), DB2CLI WILL TRAP. IY40614 EEE : AUTOLOADER FAILS WITH SQL1336N WITH CORRUPT HOSTNAME IY40639 A CRASH RIGHT AFTER A CLI0135E IN A JDBC APPLICATION. IY40728 SIG11 IN DB2SYSC : WHEN RUNNING KEEPDARI = NO IT IS POSSIBLE FORTHE AGENT ITSELF TO BE FREED, IY40749 QUERY PATROLLER DQPSTART FAILS WITH A DB210064E ERROR. IY40771 ATTEMPT TO EXPLICITLY CONNECT FROM WITHIN A STORED PROCEDURE CAN CRASH THE DB2 INSTANCE IY40781 APPLICATION RECEIVES AN SQL0918 AFTER ROLLBACK DUE TO LOCKTIMEOUT IN XA ENVIRONMENT. IY40794 AFTER FAILOVER OF DB2 CONNECT IN A 2PC SPM ENVIRONMENT, RESYNC FAILS. IY40796 CANNOT INTERRUPT A SORT SPILL IY40873 SWITCHING FROM LOCATORS TO LOBS DURING FETCH CAUSING TRAP WHEN SQL_RULES_DB2 SPECIFIED. IY40922 DB2 CRASH - SIGNAL 11 TRAP IN SQLNO_FINAL_PHASE() WHEN A QUERY IS RUN ON TABLE WHICH HAS A SUMMARY TABLE AND QUERY ACCESS THAT. IY40954 ENABLING DUAL LOGGING WITH LARGE LOG FILES CREATES VERY LARGE PERFORMANCE DEGRADATION (70-100X). IY41079 INSTANCE CRASH WITH SIGNAL #11: MEMORY CORRUPTION IN FEDERATED ENVIRONMENT WITH STATEMENT MONITORING ON IY41111 SIGNAL 11 TRAP (SEGV) OCCURS IF A DB2/390 DATABASE IS CATALOGED AS A DB2/UWO DATABASE IN AN SPM ENVIRONMENT. IY41154 DB2 CLI MEMORY CORRUPTION (MULTICONNECT=3) AND 255 COLUMNS OR GREATER IN THE SELECT LIST. IY41155 INCORRECT OUTPUT DUE TO QUERY REWRITE. IY41162 SIGNAL 11 (SEGV) TRAP ON EEE WHILE USING FEDERATED LINKS TO ACCESS A REMOTE EE DATABASE IY41164 MEMORY LEAK WHEN USING LOAD WITH STATISTICS YES IY41174 F8 WHEN USING INVOKE TO CALL A SP IF IT IS SUCCESSFUL THE RC=2 INSTEAD OF RC=0 IY41185 SQLNUMPARAMS DOES NOT RETURN THE CORRECT NUMBER OF PARAMETERS IY41218 INCONSISTENT BEHAVIOUR OF JDBC APP/NET DRIVER WITH CLEARPARAMETERS STATEMENT IY41289 WHILE RUNNING DB2BATCH TOOLS AS A SYSCTRL AUTHORITYGETTING AUTHORITY ERROR. IY41292 SQLSETCONNECTATTR() FAILS WITH SQL30090N (RC=20) AFTER EXECUTIONOF SQL STATEMENT WHICH RETURNS SQL_NO_DATA_FOUND IY41325 CLI0100E ON UPDATE WHEN DEFERREDPREPARE=0 IY41425 DPROPR CAPTURE DOES NOT UPDATE THE SYNCHTIME IN THE GLOBAL ROW OF THE REGISTER TABLE WHEN THERE ARE NO NEW LOG RECORDS IY41451 SQL0818N TIMESTAMP CONFLICT AFTER REBINDING APPLICATION WHICH USES A CHAR PADDED WITH BLANKS FOR SET CURRENT PACKAGESET IY41480 DB2START HANGS BECAUSE DB2CHKAU IS STUCK IN A TIGHT LOOP CONSUMING CPU CYCLES. IY41572 JTA (AND XA) CONNECTION TO BIG5 DB FAILS WITH CLI0108E IY41578 FAVOUR FULLY QUALIFIED UNIQUE INDEX ACCESS OVER OTHER INDEXES ACCESSES IY41594 FIX CONNECTION POOLING CLEANUP LOGIC DURING DATABASE FAILURE IY41601 SIGNAL #11 TRAP IN SQLM_DROP_TS WHEN DROPPING A TABLESPACE IY41643 IMPORT WITH LOB'S AND DIAGLEVEL SET TO 4 RESULTS WITH -423 ENTRIES IN THE DB2DIAG.LOG (SQL0423N) IY41651 EEE : AUTOLOADER FAILING WITH SQL3508N,RC=1 IY41702 SMALL TIMING HOLE WHEN RESTORING A DATABASE WHERE THE RESTORING DATABASE WILL ALLOW A CONNECTION. RESTORE FAILS WITH SQL1035N. IY41846 PREDICATE NOT BEING PUSHED DOWN FULLY, RESULTS IN NEGATIVE PERFORMANCE IMPACT. IY41848 INSTANCE CRUSHES AND TRAP GENERATED ON THE GATEWAY, WHEN CONNECTING WITH XA APPLICATION IY41890 OPTIMIZER DOES NOT CHOOSE A SUMMARY TABLE WHEN IT IS AVAILABLE. IY41903 REFRESH TABLE RETURNS SQL0901N WITH REASON "FOUND ZERO CLOB.RESET" IY41963 UNABLE TO DROP A PROCEDURE IF THE SCHEMA NAME FOR THE PACKAGE IS LOWERCASE IN THE SYSDEPENDENCIES TABLE. IY41970 TIMING FOR INTERRUPT MAY CAUSE HANG IY42004 SQL0973N NOT ENOUGH STORAGE IS AVAILABLE IN THE "APP_CTL_HEAP" HEAP IN QP IY42010 A CLI0114E ERROR SHOULD OCCUR WHEN EXECUTING SQL WHERE THE FRACTIONAL SECONDS FIELDS OF TYPE SQL_C_TYPE_TIMESTAMP GETS TRUNCATED IY42075 POINT IN TIME RECOVERY GOES BEYOND SPECIFIED PIT WHEN THERE IS AN INFO_ONLY LOG RECORD. IY42097 FIX THE FOR STMT OF THE FCT CHANGE_USER_IN_USERFILES IN DB2_INST_HA.LOCAL IY42128 DB2CKBKP FAILS WITH RC=-1 WHEN TOO MANY TABLESPACES ARE DEFINED IY42145 BACKUP TO TSM FAILS WITH SQL2072N RC 6646-UNABLE TO BIND TO LIBTADSM.A IY42146 DB2AUDIT.LOG CORRUPTED WHEN FILESYSTEM FILLS IY42166 INCORRECT VALUES ARE BEING RETURNED FROM VARCHAR COLUMN OF UTF-8DB USING IBMDADB2. IY42175 IN SCRIPT DB2GOVLG LOOKING FOR PWD IN /ETC/PASSWD DOES NOT WORKIN NIS ENVIRONMENT. IY42180 UDB EXPORT UTILITY RUN AGAINST AN AS400 GETS SQL0805 PACKAGE SQLUAD08 NOT FOUND IY42267 ABEND:DB2ATLD FAILED WITH COREDUMP: ERRPT SHOWS SIGNAL 11 IN THESQLOFMBLK IY42281 CORE IN CLI_SCROLGETAROW2 IY42291 MISSLEADING "DIA3847C AN ERROR OCCURRED IN A DATABASE PAGE" ERROR WHEN MAX NUMBER OF AGENTS IS REACHED. IY42313 XASTART() RETURNS XAER_PROTO, SHOULD RETURN XAER_OUTSIDE WHEN LOCAL STATEMENT EXISTS BEFORE XASTART() IS CALLED. IY42330 UDB DISTRIBUTED DRDA APPLICATION SERVER SENDS RDBUPDRM TO A DRDA AR EVEN IF IT SUPPORTS SQLAM < 3 ONLY. IY42342 DB2CAT IS FAILED FOR GABAGED TABLE NAME, IF IT HAS DBCS. IY42344 SIGNAL 11 (SIGSEGV) IN SQLRA_DEL_LRU() IY42346 AGENT SERVICING A QUERY DOESN'T FORCE WHEN FORCE APPLICATION IS ISSUED. IY42366 BUFFERPOOL ASYNC READ SNAPSHOT DATA INCORRECT IY42387 DB2 CONNECT APPLICATIONS DO NOT PROPERLY INITIALIZE THE MONITOR STATEMENT STOP TIME IY42389 SIGSEGV IN SQLUIMPM DURING LOB PROCESSING IY42405 LOGON DIALOG ALONG WITH ERROR SQL1403 DISPLAYED IN CONTROL CENTER ON FIRST ATTEMPT TO CONNECT TO DATABASE IY42429 SQLEAPPSETPRIORITY NEEDS TO HOLD THE APP TABLE LATCH IY42476 BLOCKING CURSOR ELEMENT IN SNAPSHOT MONITOR ALWAYS SHOWS NO IY42511 WHEN IMPORT WITH COMPOUND=100 USED AND ROW 100 IS REJECTED, THE ERROR MESSAGE SHOWS MISLEADING ROW NUMBER. IY42523 CLI AUTOBINDING UNNECESSARILY WHEN SOMETHING OTHER THAN A PACKAGE CANNOT BE FOUND. IY42544 SQL0803N WHEN DOING BATCH UPDATING IN A JDBC APPLICATION IY42570 LIST APPLICATIONS MAY NOT RETURN AN ACCURATE COUNT IF ONE OR MORE DATABASES ARE NOT ACTIVE. IY42575 DB2 UDB GATEWAY DOESN'T HANDLING LARGE SIZE PREPARE/DESCRIBE STATEMENT CORRECTLY. -30020 IS REPORTED IY42605 CREATING, DROPPING AND FLUSHING AN EVENT MONITOR CONCURRENTLY CAN HANG THE SERVER. IY42617 DB2 REORGCHK ON NON-EXISTENT TABLE DOES NOT RETURN ERROR OR INFORMATIONAL MESSAGE. IY42625 SQL PROCEDURE PARSING INCORRECT IN 'WHERE CURRENT OF ' STATEMENT. IY42638 SAVE TO FILE OPERATION IN SPB AGAINST CERTAIN STORED PROCEDURES DOES NOT DISPLAY SAVE DIRECTORY DIALOG BOX, CAN NOT SAVE. IY42639 INCORRECT ERROR HANDLING FOR OUT OF MEMORY CONDITION IN BINSORT COULD LEAD TO A TRAP IY42652 CODEPAGE CONVERSION FILE FOR 1140->UCS2 MISSING IY42659 SQLFREEENV GETTING AN INVALID SEQUENCE ERROR UNDER MULTICONNECT IY42672 SET DB2_ENABLE_LDAP=NO IN RUNTIME CLIENT'S RESPONSE FILE DOESN'TTAKE EFFECT IY42695 DB2ATLD SPLIT_ONLY JOB FAILS WITH SQL6554 WHICH IS FINE, HOWEVERIT FAILS TO RETURN NON-ZERO RC TO THE SHELL. IY42713 PROVIDE OPTION TO TURN OFF DB2 LOGGING WHEN QP INTERCEPTS INSERTSTATEMENT AND TABLE IN QUESTION HAS NOT LOGGED INITIALLY ATTRIBU IY42837 INSTANCE CRASH WHILE CALCULATING QUERY DEPENDENCIES IY42841 FP10:REVERSE INDEX SCAN IS WAITING ON A DELETED PAGE. SINCE THE PAGE IS DELETED WE ARE IN AN INFINITE LOOP. IY42842 WHEN USING A SELECT DISTINCT TO SELECT FROM A NICKNAME, THE THE DISTINCT IS NOT PUSHED DOWN TO THE DATA SOURCE IY42846 CLI0111E CONVERSION ERROR WHEN INSERTING DECIMAL OF FORM -0.AAA INTO TABLE WITH DECIMAL(A,A) IY42854 A TIMESTAMP PASSED IN A WHERE CLAUSE TO THE DATE FUNCTION RETURNSUCCESS_WITH_INFO, BUT THE CURSOR IS NOT OPENED, THE FETCH FAILS IY42878 SQL0430N UDF "DB2XML.EXTRACTDATE" ABNORMALLY TERMINTED. IY42897 CONNECTING TO A REMOTE DATABASE USING TCPIP RETURNS SQL30081 ERRNO=4 (EINTR) IY42978 INCORRECT NTH ROW COSTING IY43105 TRAP IN SQLE_DB2RA_DELCCB WHEN SETUP IN HOP ENVIRONMENT IY43239 DPROPR CAPTURE DOES NOT CAPTURE RUNNING WITH CHGONLY OPTION DOES NOT CAPTURE CHANGES TO VARCHAR COLUMNS IN SPECIAL CONDITION IY43253 LOAD COMMAND HANGS DUE TO RIDDER CODEPATH OF THE COMMAND. IY43269 ADD CAPABILITY TO STOP AIX TRACE WHEN DB2 DETECTS DATA CORRUPTION. IY43300 JDBC RESULTSET.CLOSE() STATEMENT WILL CLOSE THE STATEMENT, AND NOT JUST THE RESULTSET. IY43309 TO ENABLE BRANCH ELIMINATION FEATURE ON INSERT/UPDATE/DELETE -SELECT SQL. IY43323 ONLINE BACKUP FAILS DUE TO LOCKTIMEOUT. HOWEVER, THERE IS NO INDICATION WHICH OBJECT IS LOCKED. IY43366 STMTHEAP RESOURCE CONSUMPTION TOO LARGE FOR COMPLEX QUERIES THATDO NOT REFERENCE REMOTE RESOURCES IN A FEDERATED ENVIRONMENT IY43409 OPTIMIZER-ROUTED MQTS OVER NICKNAME ARE NOT USED FOR QUERY OPTIMIZATION ON DB2 EEE FEDERATED SYSTEM IY43420 CONNECTION HANDLE IS NOT FREED UP AFTER FAILED ROLLBACK FOR THE FAILED (DEAD) CONNECTION. IY43460 INSTANCE ABENDS IN SQLED_CALLBDRDAOUTPUT__FP7UCINTFC + 0X16B0 WHEN TESTING JAVA SP ON 4 NODE DB2 IY43496 TO FIX THE SELECTIVITY FOR SUBTERMS OF AN OR PREDICATE WHEN THE SUBTERM CONTAINS HOST VARIABLE OR PARAMETER MARKERS. IY43534 SNAPSHOTS WHOSE TEXT STRINGS ARE CODEPAGE CONVERTED CAN RESULT IN INCORRECT LENGTHS IN ELEMENT AND LOGICAL GROUP HEADERS. IY43553 SQL0413 DURING AN ATTEMPT TO CREATE NICKNAME, DUE TO THE CASTINGTHE CARDINALITY OF THE TABLE TO AN INTEGER. SHOULD BE BIGINT. IY43562 COPY TABLE IN DB2CC MAY CREATE THE TARGET TABLE IN THE WRONG TABLESPACE. IY43575 HANG - INFINITE LOOP IN INDEX MANAGER CAUSED APPLICATION HANG IY43606 DATA FOR CHAR, VARCHAR GET TRUNCATED WHEN PERFORMING LOAD WITH CODEPAGE CONVERSION AND TARGET LENGTH BIGGER THAN SOURCE (IXF) IY43621 SQL_C_DBCHAR DO NOT PROPERLY NULL TERMINATED IY43648 DB2 ALLOWS DELETE OF ROWS WHEN RI SHOULD PREVENT DELETION DUPLICATE. IY43713 SIG 11 IN SQLRI_HSJNNEWTUPLE CAUSING ENGINE CRASH IY43715 DRDA CONNECTION VERY SLOW DUE TO HIGH GATEWAY CONNECTION POOL AGENTS STOLEN IY43755 DATABASE PREFETCH_WAIT_TIME DOES NOT INCLUDE TIMES FOR TERMINATED APPLICATIONS IY43756 JDBC PREPAREDSTATEMENT EXECUTES BATCH INSTEAD OF NEW PARAMETERS. IY43772 INCORRECT MEDIA HEADER INFORMATION FROM USING SQLUV API IY43801 DPROPR APPLY DOES NOT DETECT A GAP CONDITION WHEN THE SOURCE IS A VIEW. IY43816 LOAD CANNOT LOAD MORE 27 CHARACTER LONG NUMBER INTO THE FLOAT OR DOUBLE COLUMN. IY43841 ENHANCEMENTS OF SOPMERGE RULE IN QUERY REWRITE TO ALLOW MULTIPLEUNIONS MERGED WITH SELECT BOX IN BETWEEN. IY43845 STATUS OF APPLICATION IN MONITOR MAY SHOW UP AS UOW EXECUTING WHILE ACTUALLY BEING IN (INTERALLY TRIGGERED) ROLLBACK IY43849 WHEN CHIME_STRING AND CAST FUNCTION IN A SELECT FROM A NICKNAME, THE SELECT DOES NOT WORK IY43852 QUERY GETS WRONG RESULTS FROM LINUX DB USING FEDERATED AGAINST AS400. IY43854 ADDITIONAL AUTOLOADER CODE ADDED TO DETECT IF THE AUTOLOADER TIMED OUT DUE TO PACKET DROPS ON THE NETWORK IY43875 CLEAN UP MINOR ERRORS IN THE SAMPLES SCRIPTS FOR XML EXTENDER. IY43923 ALLOW DISPLAYING OF FUNCTION NAMES IN FORMATTED WINDOWS TRAP FILES. IY43944 ERRORS NOT BEING PROPAGATED TO VB APP USING OUR OLEDB PROVIDER IY43964 DB MARKED BAD AFTER SYSTEM MEMORY LIMIT REACHED IY43965 SYBASE DBLIB WRAPPER CAUSES CRASH IF YOU CREATE NICKNAMES ON MULTIPLE SERVERS. IY43970 SQL QUERY TRAPS INSTANCE WITH SIGSEGV#11 IN DISCONNECT_TREE DURING QUERY REWRITE PHASE IY43972 FFIX THE IS_UNION_ALL DEFECT AND ENHANCE THE ETOF QRW RULE IY43979 DB2SPLIT SIGSEGV WITH CERTAIN LOCALES. IY44092 SQL30082 RC 24 WHEN TRYING TO CHANGE HOSTPWD FROM CLIENT APPLN PGM IY44099 CONNECTING TO A DB VIA CONTROL CENTER AND OPENING VIEW INFO ON 10 DIFFERENT VIEWS 10 CONNECTIONS WILL BE OPEN TO THE DATABASE. IY44104 COALESCE FUNTION IS NOT BEING PUSHED DOWN TO SYBASE DATA SRC. IY44117 SELECT * FROM TABLE IN DB2SQL92, WHERE THE BLANK BETWEEN SELECT AND STAR IS REPLACED WITH A TAB, FAILS WITH SQL0084N IY44122 THE COMPILER INCORRECTLY CHANGES THE COLUMN ORDERING IN A UNION OPERATION WHEN USING A NICKNAME IY44156 PERFORMANCE IMPROVEMENT THAT MAINLY AFFECTS FEDERATED STATEMENTSRUNNING IN A MPP ENVIRONMENT: IY44240 CERTAIN LOGS FAIL TO BE ARCHIVED BY DB2CART IY44286 INCORRECT REWRITE OF QUERY WITH OR PREDICATE TO UNION IY44298 DB2 MAY TRAP AT CLIENT SIDE AFTER FETCHING ROW DATA RETURNED BY MULTI RESULT SETS STORED PROCEDURE. IY44307 DURING A FAILED LOAD, ROLLBACK MAY FAIL BECAUSE OF THE BACKUP PENDING STATE. IY44348 DATA IS LOST WHEN RESTORING BACKUP IMAGES OF MULTI-CONTAINER, SM S TABLE SPACES WHICH CONTAIN LOB DATA. IY44350 UDB CRASHES WHEN ISSUING AN SQL STATMENT THAT CONTAINS A UNION INVOLVING NICKNAMES IY44358 SQL0401N WHEN TRYING TO TRYING TO ALTER TABLE AND ADD FOREIGN KEY CONSISTING OF DISTINCT TYPES.. IY44407 BAD PAGE ENCOUNTERED IN SQLIFIX IY44431 CLI0125E MAY OCCUR ON THE SECOND EXECUTE IF THE ASKED FOR CURSORIS DOWNGRADED (FOR EXAMPLE, FROM SCROLLABLE TO FORWARD ONLY) IY44442 TO FIX MISORDERED ROWS ON REORG WITH CLUSTERED INDEX. IY44446 INSERT FAILS IF TABLE HAS VARIABLE LENGTH ROWS AND TABLESPACE IS FULL ALTHROUGH SOME PAGES HAVE FREE SPACE IY44482 SEGV IN MEMTREEDELETE WHEN CREATING A SUMMARY TABLE WITH OUTER IY44497 APPLICATION WHICH CALLS A STORED PROCEDURE WITH LOB PARAMETER AND MULTI RESULT SET, MAY GET -30020,AND REASON CODE "2202" IY44522 SIGNAL 11 AT SQLNO_CONV_CHAR2FLOAT WHEN PERFORMING A QUERY IY44538 DB2CC: CANNOT ALTER BUFFERPOOL OF EXISTING TABLE WITH THE CONTROL CENTER OF FP9 IY44556 HANG IN SQLRI_BFIXAND IY44569 MISSING SPACE BETWEEN COMMA SEPARATORS CAUSES SQLCODE104. IY44814 THE DB2RELOCATEDB TOOL DOES NOT WORK PROPERLY ON HP-UX IY44913 INCORRECT RESULTS FROM FETCH FIRST N ROWS WITH A SUBQUERY IY44939 PACKAGE INVALIDATION GETS SKIPPED ON DROP OF A TABLE. IY44954 PERFORMANCE DEGRADES WHEN FEDERATED PART IS NOT RIGHT LEG OF THEUNION WITH A LOCAL QUERY IY45432 FP3: COMMAND CENTER SHOULD PROMPT FOR USERID/PASSWORD IY45503 DATABASE ROLLFORWARD COMPLAINS ABOUT PAGE HEADER PROBLEMS IY45616 THE DB2 UDB CONTROL CENTER, DB2CC , IS SLOW TO START (SEVERAL MINUTES) BY A REGULAR USER (NON-INSTANCE OWNER) ON UNIX. IY45665 CONNECTNODE ATTRIBUTE SET IN APPLICATION SEEMS TO BE CACHED FOR SUBSEQUENT CONNECTIONS IY45963 JTA (XA) CONNECTION FAILS WITH SQL30090N RC=6 AFTER APPLICATION FORCED IN DB2 JR16564 MAPPING COLUMNS TAKES A LONG TIME IN THE COLUMN MAPPING PAGE JR17331 SPB IS RETURNING JAVA.LANG.NULLPOINTEREXCEPTION WHEN OPENING A PROJECT,IF TARGET HOST DB HAS SP REGISTERED WITH ROWID. JR17597 SPB USES THE -CF0 OPTION TO CREATE THE JAR FILE SENT TO OS/390. THIS PREVENTS COMPRESSION & LIMITS SIZE OF THE STORED PROCEDURE JR17692 REORGCHK OVERESTIMATES THE ISIZE JR17799 TABLESPACE LEFT IN RESTORE PENDING STATE ,AFTER RF TO EOLS. JR17886 CREATE SQL PROCEDURE FAILS WITH SQLSTATE 42904 WHEN DB2INSTPROF IS SET (DB2ICRT WITH -P OPTION), DB2UDP.DLL CANNOT BE LOADED JR17913 PROTECTING THE LOADING/UNLOADING OF DB2KBC.DLL WITH A LATCH TO MAKE IT THREAD SAFE. JR17918 SQLEXECUTE() FAILED WITH SQL0301 ERROR JR17926 ADDITIONAL CONNECTIONS BEING REFUSED AND GIVING THE MESSAGE :- NOT ENOUGH POST WAIT AREAS JR17929 INDEX KEYS MISORDERED DUE TO ERROR IN BINSORT JR17932 DB MAY CRASH W/ SEGMENTATION VIOLATION WHILE TRYING TO EVALUATE A STAR-JOIN QUERY ON SQLNO_STARJN_CHECK_JGRAP() JR17936 CONTROL CENTER DOES NOT DISPLAY CORRECT CONTRAINT JR17940 DWC NEEDS TO DELETE ORPHAN ATTRIBUTE LINKS DURING MIGRATION JR17941 PEM DLL CALLS WINCPICCLEANUP() WHICH CAUSES SEGV IN AGENT WHEN USING CONNECTION POOLING. (MS SNA FOR HOST COMMS. ONLY) JR17955 SCRIPT CENTER (WINDOWS) EXECUTES SECONDARY SUCCESS/FAILURE SCRIPTS BASED ON SUCCESS OF STARTING, NOT FINISHING, SCRIPT JR17963 IF CALL STATEMENT CONTAINS A LITERAL FOR THE INPUT INTEGER, CALLFAILS AS CANNOT LOAD LIBRARY JR17968 SQL ASSIST HANGS USING STORED PROCEDURE BUILDER WITH FIXPAK 8 ONWINDOWS PLATFORMS AND USING JDK 1.2.2 JR17987 WHEN UPDATING AN SQL ASSIST GENERATED QUERY IN COMMAND CENTRE ERROR DBA2185E WITH SQLSTATE=42601 IS DISPLAYED JR17990 CLI0620E WHEN READING CLOB DATA JR17992 DB2SPB -20212 DURING JAVA EXECUTION FROM COPY/PASTE OP JR18000 THE '_' IN THE "DB2MOVE -TN" CLAUSE IGNORES WHILE EXPORTING TABLES. JR18026 IF PATCH1=65536 IS SET, THE EXECUTION OF A SQL STATEMENT WITH SINGLE QUOTES IN THE LITERAL VALUE RETURNS SQL0104N JR18032 LOAD/IMPORT WE DO NOT TAKE INTO ACCOUNT THE NULL AT THE END OF THE DATA JR18033 SQL30020N RC=124C ON VERY LARGE CLOBS FROM OS/390 SERVER JR18035 DWC - GUI , WIP NOT SHOWING THE SAME TIMESTAMP AS THE SERVER....INSTEAD SHOWS LOCAL TIME, UNTIL LOCAL REFRESH IS DONE. JR18058 DWC - MIGRATION , CHANGES IN GROUP-BYS WHICH WERE NOT GENERATED BEFORE MIGRATION SHOWING UP DIFFERENTLY IN MIGRATED METADATA. JR18076 DB2EVMON ON OS/2 RETURNS SYS1808 - EXCEPTION C0000005 IN SQLOGMBLK JR18086 DWC- WHERE CLAUSE NOT CONVERTING WHEN MIGRATING FROM 5.2- 7.2 SQL INCLUDES THE WHERE CLAUSE ,CONDITION WINDOW DOES NOT JR18089 SP CALLED FROM CLI WITH CHAR LITERALS GETS PADDED WITH 0X00 JR18090 -440 DURING IMPORT AGAINST CCSID 939 OS/390 DATABASE JR18108 ISSUE SELECT LOCATE(EXP1,CLOB,EXP3) FROM TABLE GET SQL0443N IF EXP3 >4000 WHICH SHOULD BE AVAILABLE FOR CLOBS BUT NOT VARCHAR JR18111 DB2SUPPORT TOOL NOT PARSING SPACE IN FOLDER NAME ON WINDOWS JR18131 CALL TO SP WITH OUT PARAMETERS USING IBMDADB2 DOES NOT SHOW SHOW OUTPUT IF FIRST OUT PARAMETER IS NULL. JR18165 CHAR SP RESULT SET COLUMNS ARE INCORRECTLY DESCRIBED IN CLI - PROBLEM WITH SQLDESCRIBECOLW JR18178 ROWCOUNT IS WRONG AFTER APPLICATION RUNS OUT OF APP_CTL_HEAP JR18184 DWC - 5.2 TO V7 MIGRATION IWH2REGI.EXE THAT WOULD DELETE THE RELATIONSHIP BETWEEN A MAP AND TARGET ATTRIBUTE ERRORENOUSLY. JR18194 DB2STOP ON WINDOWS TERMINATES DB2 LICENSE SERVER JR18195 SQL30090N RC=3 ON CALL TO SP ON 390. PROBLEM INTRODUCED IN FP8 JR18198 TRAP IN IMPORT WITH LOBSINFILE USEDEFAULTS JR18211 THE CUST IS GETTING MEMORY ACCESS VIOLATION WHEN USING DB2 UDB XML EXTENDER. SQL1131N SQLSTATE=38503 JR18218 SPECIAL CHARACTERS ARE NOT ALLOWED IN A SCHEMA NAME WHEN USING THE EDITOR IN THE STORED PROCEDURE BUILDER. JR18219 STORED PROCEDURE BUILDER TRUNCATES A DECIMAL OUTPUT VARIABLE WHEN CALLING A Z/OS STORED PROCEDURE. JR18221 SQLTABLES RETURNS DIFFERENT RESULT SET IN FP8 THAN PRIOR FIX PACKS WHEN USING CLI KEYWORDS DBNAME AND SYSSCHEMA TOGETHER JR18237 DATE LOG ERROR JR18244 DWC CAN GENERATE SQL1226 AFTER ENOUGH MESSAGES ARE WRITTEN TO THE WIP. CAUSED BY EXCESSIVE CONNECTIONS FROM JAVAW.EXE JR18246 JDBC RESULTSETMETADATA.GETCOLUMNCLASSNAME() RETURNS JAVA.LANG.SHORT BUT SHOULD RETURN JAVA.LANG.INTEGER OR NUMERIC FOR SMALLINT JR18254 DWC/SQLASSIST JOIN TAB PROBLEM A JOIN WAS DROPPED FROM VIEW ON TAB. SQL IS CORRECT JR18255 DWC COLUMN MAPPING PROBLEM , PROVIDE CORRELATION NAME FOR SOURCEAND TARGET WITHIN STEP JR18256 DWC VARIOUS SQLASSIST GROUPING PROBLEMS JR18259 CLI0111E ERROR USING IBMDADB2 WITH DECIMAL PARAMETERS. JR18260 SQLDESCRIBEPARAM FAILS ON CALL STATEMENT WITH NO IN/OUT PARMS JR18262 MQ_COMMIT CAUSES SQL0998N RC=222 IN FIX PACK 9 DUE TO MISMATCHEDCODE PAGES IN AN XA ENVIRONMENT WHEN USING UNICODE JR18277 DB2DCLGN DOES NOT ADD A NULL TERMINATOR (\0) PLACE HOLDER WHEN GENERATING STRUCTURES FOR C LANGUAGE JR18279 IF DB2 IS STARTED USING LANG=ZH_CN.HP15CN, WILL PRODUCE SQL4304N REASON CODE "5", WHEN RUNNING A JAVA STORED PROCEDURE. JR18281 DWC -JDK NEEDS FEATURES FROM JDK 8 TO IMPROVE SCROLLING AND MOVEMENT THROUGH DATA JR18283 DWC - CLIENTS ARE NOT SEEING EACH OTHERS UPDATES ON THE SERVER METADATA IN A TIMELY MANNER JR18323 DOING A PARTIAL COMPILE OF THE SIEBEL REPOSITORY TO A .SRF FILE RETURNS SQL0900N SQLSTATE 08003. JR18332 DWC/SQLASSIST COLUMN NEEDS SCROLLING MECHANISM FOR SELECTED COLUMNS JR18346 DWC - PUTTING PIECES OF PROCESS BACK TOGETHER AFTER BREAKING APART CAN RESULT IN LOSS OF SQL TO OLD AND NEW PROCESS JR18351 SQL STATEMENT MORE THAN 32K RETURNS -30020 DISTRIBUTED PROTOCOL ERROR OR SQL0101NERROR JR18354 THE CONTROL CENTER PERFORMANCE CONFIGURATION WIZARD CAN DISPLAY A CORRUPTED DBHEAP VALUE JR18358 SHARE LOCK HELD BY UR NO HOLD SCANNER JR18367 DWC - HEARTBEAT CHECKER FOR DWSERVER AND XTSERVER/STARTING XTSERVER AS A SERVICE. JR18368 CLI0119E WHEN UPDATING PARM MARKER WITH LOB WHEN PARM IS BOUND WITH INCORRECT DATATYPE RESULTING IN AN SQL0301N ERROR. JR18374 DWC - DATES SORT ALPHABETICALLY INSTEAD OF CHRONILOGICALLY JR18385 DWC/SQS ASSIST WHEN LINKING TWO LIKE NAME TABLES IN DWC, HANG CAUSED BY SQL ASSIST JR18413 IMPORT OF IXF WITH THE INSERT_UPDATE OPTION ON A TABLE CREATED WITH A PRIMARY KEY NAME 30 CHARS LENGTH FAILED WITH THE SQL3203N JR18416 DWC-EXPORT SHOULD EXPORT THE SELECT STATEMENT REGARDLESS OF THE AUTOGENSELECTSTMT FLAG. (MIGRATION) JR18425 STORED PROCEDURE BUILDER - BUILD FAILS - ERROR WHEN BUILDING AN SQL STORED PROCEDURE ON THE OS/390. JR18429 SQL1403 WHEN CONNECTING LOCALLY TO EEE WITHOUT USERID AND PASSWD JR18437 DWC -FROM VW 5.2 BV'S WHICH USED FLAT FILES, IN MIGRATED DWC VER. 7.2 STEPS, NO COLUMN NAMES ARE SHOWING. JR18467 OLE DB PROPERTIES NOT UPDATED WHEN A CONNECTION IS INVALIDATED DUE TO AN ERROR. (CLI0106, CLI0108) JR18481 DB2.EXE HANGS WHEN MORE THAN ONE DB2CMD.EXE STARTED CLOSELY JR18531 RECEIVED DWC07275 WITH RC2=7902 ON THE SCHEDULED STEP JR18577 DB2DIAG.LOG REPORTS "STATEMENT NOT PROTECTED" IN SQLRA_ROLLUP_ DYN_STMT PROBE:20 AND/OR TRAP OCCURS IN SQLRA_CACHE_DEL_INV. JR18603 DWC XT SERVER FAILED DUE TO MEMORY LEAKS IN DDD, LOGGER AND SERVER. JR18606 REBUILD/ALTER OF SQL STORED PROCEDURE FAILING IN DEVELOPMENT CENTER JR18643 QUERY CRASHES THE INSTANCE WITH SIGNAL 11 WHILE MERGING OUTER JOIN. LI70155 LIKE CLAUSE WITH '%' FULL SELECT WILDCARD, PRODUCES POOR JOIN ORDER LI70163 FULL OUTER JOIN TREE, WITH FILTERING PREDICATE, CONVERTED TO LOJTREE, WITH FILTER AT THE TOP. ADD PUSHDOWN OF THE TOP JOIN. LI70165 DB2CLIFN.A LIBRARY CANNOT BE FOUND BY DB2 ON LINUX390 LI70203 SIGNAL #11 TRAP IN SQLNR_LOCAL_OJPRD_PUSHDOWN WHEN DB2_ANTIJOIN=YES AND DOING AN INSERT WITH NOT EXIST SYNTAX APAR fixes included in Fixpak 1 APAR No. Abstract -------- -------------------------------------------------- IY06572 SEGMENTATION FAULT WHEN BINDING A SECOND TIME TO A CURSOR IY06740 DB SIZE ESTIMATE CALCULATED INCORRECTLY FOR BACKUP TO ADSM. HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE. IY07623 SIGNAL #11 TRAP IN SQLORQUE2() IY08453 SQL1227 RC 6 WHEN ATTEMPTING TO UPDATE STATISTICS WITH TABLE CARDINALITY OF 0 IY08684 SQL0107 RETURNED BY CLI DRIVER ON SQLFETCH CALL TO DB2 MVS. IY09151 LOAD REPLACE OF AN EMPTY FILE (IXF) DOES NOT REPLACE EXISTING ROWS IN THE TABLE THE EMPTY FILE IS BEING LOADED INTO. IY09262 CHANGE THE DEFAULT SQL_CONCURRENCY AS READ_ONLY BASED ON THE CLAUSES PRESENT IN THE STATEMENT. IY09663 DB2 CRASHED WITH ERROR DIA3816C CREATED BY SQM_EVMON_OSTREAM() SIG 11 IY09756 NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS. REDIRECTED RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED. IY09764 TWO QUERIES DIFFERING ONLY IN THE ORDER OF THE PREDICATES, RETURN DIFFERENT RESULTS. IY09948 JAVA STORED PROCEDURES NOT FOUND OUTSIDE SQLLIB\FUNCTION IY09966 JAVA.SQL.TIMESTAMP RECEIVING INVALID ARGUMENT(NANOS>999999999 OR <0) WHEN MULTIPLE THREADS MAKES THE CALL. IY10004 DB2JD TERIMINATES WITH EXCEPTION, WHEN USING HISTORY OPTION OF CONTROL CENTER FROM WINDOWS 95. IY10029 QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204 IY10034 NON-DEFAULT DB2MPP/NT/EEE INSTANCE FAILED TO START DUE TO 6.1/NTFIXPAK INSTALLED IF DB2INSTANCE IS SET TO NON-DEFAULT DB2MPP. IY10047 DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI IY10180 COMPOUND SQL APPLICATION CORE DUMPS WITH GREATER THAN 60 SQL STATEMENTS. IY10183 TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPTED STACK ONLY TRAP AT DIAGLEVEL 4. IY10199 LEFT OR FULL OUTER JOIN PROBLEM WITH OPTIMIZER IY10280 RANDOM CLI0606E/CLI0611E ERRORS FROM A MULTI-THREADED JDBC APP WHEN ALL THE THREADS USE A SINGLE CONNECTION. IY10302 PCBVALUE INCORRECTLY POPULATED ON SQLGETDATA FOR WCHAR WITH CBMAXVALUE=2 ON UNIX. IY10390 TERMINATING ADSM SESSION BEFRO RE-ESTABLISHING IT. IY10430 BACKUP IMAGE NOT FOUND ERROR RESTORING TBSP FROM FULL DB BACKUP (LEGATO SPECIFIC) IY10432 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY IY10469 CORRUPTION IN RECOVERY HISTORY FILE ON DROP TABLE RECOVERY ITEM IY10475 IWM_TRACKER PRODUCES SQL0305N WHEN TRACKING A SUMMARY TABLE IY10484 LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973. IY10491 SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1 IY10499 OPTLEVEL 5 PLAN WORSE THAN OPTLEVEL 3 PLAN IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY10562 DB2 UDB INTRA_PARALLEL ON - QUERY RETURNS AN SQL0955 ERROR AFTERWHICH ALL QUERIES WHICH REQUIRE SHARED SORT MEMORY FAIL. IY10579 DB2 UDB - SIGNAL 11 TRAP IN FUNCTION SQLDHASHZVALUE WHEN RUNNINGREORGCHK ON VARIOUS TABLES. IY10585 SQL0501 AFTER SQL0437W IN CLI APPLICATION. RETRY LOGIC FAULT. IY10615 SQL10003 ERROR RETURNED TO USER APPLICATIONS, AND LOGGED IN THE DB2DIAG.LOG FILE. MEMORY LEAK IN BSU HEAP IY10625 SNAPSHOT FOR TABLES, IF MORE THAN 1 TABLE HAS A NULL NAME, DB2 TRAPS. IY10668 SIGNAL#11/TRAP IN SQLKQ_RECEIVE_FROM_ANY_CONNECTION IY10765 APPLICATION HANG IN FCM ON VERY FAST MACHINE IY10794 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY IY10803 LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD TABLESPACE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N. IY10816 CLI0111E ON INSERT OF DECIMAL 0.00= 50 CHARS IN SQLAJBND_BIND. JR14517 SQL1092 WHEN CREATING DB ON REMOTE SERVER FROM CLIENT. CATALOG_NOAUTH IS IGNORED. JR14521 JAVA COMMAND CENTER RESULTS GREYED OUT WHEN SCROLLING. JR14550 JAVA COMMAND CENTER WIN9X RESULTS > 4682 CHAR DISPLAY PROBLEM JR14576 JDBC NET DRIVER RETURNS SAME RESULTS WITH PREPAREDSTAMENT. JR14592 CONNECT TO DATABASE ON NT HANGS IN STRICMP() C LIBRARY CALL JR14595 SQLDRIVERCONNECT IS SIGNIFIGANTLY SLOWER IN DB2 V6.1 COMPARED TO V5.2 JR14605 DIA3419C--NETBIOS NOT STARTED SUCCESSFULLY RC 3 JR14606 EXPORT OF DEL MODIFIED BY DECPT SUBSTITUTES PERIOD FOR ANY CHARACTER FOR ITALIAN VERSION DB2 ON NT JR14625 NT PERFORMANCE MONITOR NOT PROVIDING DETAILS FOR THE SECOND AND FOLLOWING APPLICATIONS JR14646 ADDING XBSA SUPPORT TO DB2 NT FOR SAP JR14648 DBA3037 ON VISUAL EXPLAIN WHEN DETAILED STATISTICS COLLECTED ON SOME BUT NOT ALL INDEXES FOR A GIVEN TABLE JR14723 SQL1112 -NOT ENOUGH SYSTEM RESOURCES WHEN TRYING TO SCHEDULE ~100 JOBS FROM THE SCRIPT CENTER JR14737 THE CLIENT IS INCORRECTLY CREATING MULTIPLE SNA CONVERSATIONS USING THE SAME LUWID. THIS IS CAUSING DB2 OS 390 TO ABEND. JR14742 DB2JDS.EXE GOES DOWN ON A VERY LARGE SELECT WITH ONE PARTICULAR USER JR14759 LOAD OF DEL FILE WHEN BOTH" CAST(NULL AS CHAR) USED IN EXPORT" &MODIFIED BY USEDEFAULTS IN LOAD : DATE INSERTED IS WRONG JR14780 SQL0750N WHEN TRYING TO RENAME TABLE WITH IDENTITY COLUMN.