************************************************************ Product Name : DB2 UDB V6.1 for SUN PTF Number : U482116 Package Date : Fri Jun 14 10:33:39 EDT 2002 Build Level : s020401 ************************************************************ APAR fixes included in U482116 (Fixpak 11) APAR No. Abstract -------- -------------------------------------------------- GG04217 ASNLMAIN.EXE TRAPS WHILE REPLICATING DB2/VSE DATA TO DB2/NT GG04218 FULL REFRESH APPLY TROUBLE WHEN HANDLING MANY COLUMNS GG04233 APPLY NEEDS TO TOLERATE SQLCODE +191 WHEN FETCHING ANSWERSET GG04238 ASNLOAD SHOULD NOT ISSUE RUNSTAT GG04239 INCORRECT SOURCE AND TARGET TABLE INFORMATION POSTED IN THE APPLY TRAIL TABLE DURING CONFLICT DETECTION AND COMPENSATION. GG04246 DATA LOSS WITH DATAPROPAGATOR APPLY WHEN THE SET HAS A LARGE NUMBER OF MEMBERS AND THE SOURCE IS A CCD. GG04250 APPLY DOES NOT TERMINATE WHEN COPYONCE IS SPECIFIED AND THE SET FAILS WITH A -1. GG04251 APPLY COULD MISS THE HINT AND RESULT IN MISSING ROWS IF CAPTURE ENCOUNTERS -911 GG04256 ON WINDOWS 2000 SERVER DPROPR CAPTURE FAILS TO STOP WHEN ASNCMD STOP IS ISSUED IY09902 FILES IN TOOL DIR. MODIFY CHANGES IN REGRESSION BUCKET CLIFP GOING AGAINST LOCAL, ODBC AND MVS DB'S. IY11281 CREATE OF TABLE LIKE ONE IN SYSIBM SCHEMA THAT NEEDS UPDATING CRASHES INSTANCE (I.E. CREATE TABLE T1 LIKE SYSIBM.SYSTABLES) IY14751 IMPORT INSERT_UPDATE ABEND (SQL0007N) FOR UDT WHEN COLUMN NAME LENGTH EQUALS TO 18 IY14802 SQL0206N FOR TRAILING TAB IN COLUMN NAME LIST FOR IMPORT FROM COMMAND WINDOW IY18345 ERRORS GENERATED FROM SQLO_AUTHORIZE_SEM_POOL: SQL0465N RC=23 IY19585 UNION ALL ON A VIEW FAILS WITH SQL0840N IY21010 DB2GOVD: ROWSREAD CHECK LOOKS IF ROWSSEL == -1 TO CLEAR FLAG IY21672 REDIRECTED RESTORE ALLOWS TABLESPACE LARGER THAN 64GB LIMIT IY23734 INCREASE AUTOLOADER SOCKET CONNECTION TIMEOUT VALUE FOR SQL6555N IY23791 DB2/HACMP - NODE RECOVERY NEVER COMPLETES BECAUSE WE ARE LOOPINGIN THE SQLEEXECUTENODERECOVERY(). IY24309 REDIRECTED RESTORE LOGS MISLEADING MESSAGES IN THE DB2DIAG.LOG. IY24577 APPLY RECEIVES FREAD ERROR WITH RETURN CODE OF 872105. IY24872 DB2 HANG / PERFORMANCE DEGRADATION / 100% SYSTEM CPU AT DIAGLEVEL 4 WITH ' PREFETCH QUEUE FULL ' MESSAGES IY25304 NO BACKUP IMAGE APPEARS ON BACKUP OF 10THE SESSION ON TSM THROUGH CC WITH ERROR DBA1605 NO BACKUP IMAGE INFORMATION WAS FOUND. IY25339 BIGINT NOT NULL DATA CORRUPTED ON DB2/390 BY INSERT/IMPORT IY25370 SQL0901 SQLRMGJN : CODEPAGE IS '0' INTERNALLY ON SYSINDEXCOLUSE THIS RESULTS IN INDEX KEYS IN INCORRECT ORDER ON THIS TABLE ONLY IY25677 DO NOT INVOKE RUNSTAT FROM APPLY IY26007 INCORRECT CODE PATH PRODUCED CORE DUMP. IY26255 DB2 INSTANCE CRASH DUE TO MEMORY CORRUPTION : DB2 AUDIT BUFFER OVERWRITE CAUSES TRAPS - SQLE_DATABASE_CONNECT_RESET IS COMMON IY26607 SQLJ DOES NOT GENERATE .CLASS FILES. IY26652 CRASH RECOVERY COMPLETES EARLY IY26945 UNSUCCESSFUL TABLE REORGANIZATION CAN LEAVE DIRTY PAGES AROUND IN THE BUFFERPOOL WHICH RESULTS IN TABLESPACE EXTENT CORRUPTION IY27103 DATBASE BROUGHT DOWN WHEN ENCOUNTER A HEURSTIC ROLLBACK REQUEST ON ATRANSACTION IN TABORT STATE. (EEE) IY27532 SIGNAL #11 SIGSEGV IN SQLRINIT DURING APPLICATION HEAP FULL IY27795 CAPTURE MAY STOP CAPTURING DATA FOR OLDER REGISTRATION AFTER A REINIT. IY27991 DURING ARRAY INSERT, DB2 HANGS IF THE CONNECTION IS STOPPED WHEN THE PARAMETER SIZE IS GREATER THAN WHAT WAS DECLARED. IY28013 SQL 1042, OR SQL 1072 OCCURS ON DB2START FOR SECOND INSTANCE STARTED ON THE SYSTEM IY28115 APPLY FAILS WITH SQL0206N ON A PREPARE IN AN UPDATE ANYWHERE SCENARIO IY28606 LONG DBCS QUERY GETS SQL0104N BECAUSE OF STRING TRUNCATION THROUGH JDBC CODE CONVERSION. IY28626 DSNL500I IN APPLY IN CONTINUOUS REPLICATION IY28677 CAPTURE WAS NOT UPDATING ALL LOB COLUMNS CORRECTLY FOR CERTAIN LOG VARIATIONS. IY29319 DPROPR CAPTURE - MISMATCH IN ROW COUNT BETWEEN SOURCE AND TARGETAFTER REPLICATION IY29779 APPLY GETS AN SQL1822N AND FAILS WITH CPGDRL: READ THE NEXT INTENTSEQ FAILED. ERRCODE IS 812104' IY29834 WHEN PREVIOUS APPLY SHOWS STATUS=-1 AND WHEN NEXT APPLY IS RUN USING MAX_SYNCH_MINUTES, THE APPLY DOESN'T WORK CORRECTLY IY31543 EMP/SMP ERROR MESSAGES REPORTED IN DB2DART OUTPUT AFTER ROLLFORWARD, OTHER SYMPTOMS COULD BE BAD PAGES IN DB2DIAG.LOG. IY31545 DUPLICATE RESULTS RETURNED BY QUERY IN EEE ENVIRONMENT IY31548 TRAP IN SQLOCPCV BECAUSE BPS SENDS A TRIPLET OF DATA WITH NUMENTRIES 1, WHEN IN-FACT THERE ARE NO ENTRIES TO BE SENT. IN IY31550 SQL0311 ERROR WITH UNICODE CODEPAGES AND SQLJ PROBLEM. IY31551 JDBC.NET.DB2DRIVER FUNCTION NEXT( ) RETURNING WRONG RESULTS IY31552 CLI0637-CANNOT PROCESS QUERIES WITH STARTING/ENDING BRACKETS. IY31553 SIGNAL #11 IN SQLOFMBLKEX() WHEN CALLED BY SQLRLCLO() IY31554 CUSTOMER EXPERIENCES MEMORY LEAK WHEN CALLING PREPARED STATEMENT USING JDBC ON A SOLARIS CLIENT. IY31555 SQL0901N - SQL STATEMENT FAILED, REASON - COLUMN NUMBER OUT OF RANGE IY31556 ALTER TABLE ... ADD COLUMN MAY CAUSE MISSING ROWS IN SYSIBM.SYCOLUMNS IY31560 A DROPPED REPLICATED SUMMARY TABLE STILL GETS REFERENCED BY A PACKAGE CAUSING FFFFF47A AND THEN DB2 CRASH. IY31562 WAS: DATABASEMETADATA.GETTYPEINFO NOT COMPLIANT WITH JDBC SPEC IY31600 "SQLOCSHR" LEAKS MAPPED SHARED MEMORY IF FAILURE OCCURS IN 2ND STATE ATTACHMENT. PROBE:220IN SQLOCSHR IN DB2CART. IY31603 DB2DART REPORTS INVALID INDEX TYPE OF 0X9101 FOR EXTENDED INDEX. IY31618 MISSING COMMIT AFTER AN UPDATE A BLOB. IY31619 INVOKING A STORED PROCEDURE THAT RETURNS RESULT SETS WITH LOB.SIGSEGV RECEIVED AT D48A8B34 IN /USR/LPP/DB2_07_01/LIB/LIBDB2.A IY31622 GET EXCEPTION: STRING INDEX OUT OF RANGE WITHNET DRIVER IY31648 TRAP IN SQLJIFSR WHEN GOING TO A DB2/390 V.7.1 IY31663 CLI0637E ERROR IF THE SQL QUERY STRING CONTAINS TAB CHARATERS JR16278 EXECUTEQUERY() DOES NOT THROW AN EXCEPTION WHEN IT IS USED FOR SQL STATEMENTS THAT DO NOT RETURN A RESULT SET JR16401 DB2 ABENDS IN SQLERUNSYSCTLR DUE TO DOUBLE-FREEING OF MEMORY DARI PROCESS JR16569 SQL0901, SECTION LENGTH MISMATCH RETURNED IN SQLERRMC DURING TRANSACTION JR16670 IN DB2 CONNECT V6.1, WHEN A EXTDTA IS SENT TO THE HOST, DB2 CONNECT SENDS 2 EXTRA BYTES THAT THE HOST DOES NOT UNDERSTAND. JR16724 CLI0119E DURING XA CONNECT FROM JTA THEN SUBSEQUENT SQL30090N WITH RC=6. APPLICATION RESTART RESOLVES THE PROBLEM. JR16753 DB2DART TOOL MEMORY BUFFERS LIMITATION TO CHECK SMP JR17125 COLUMN TRUNCATION CAUSES CLI0615 JR17126 CREATE_TABLE_DDL MISSING NOT LOGGED COMPACT ATTRIBUTE JR17127 ADD GETCLOB() AND GETBLOB METHODS FOR CALLABLESTATEMENT JR17128 JDBC DEFECTS FOUND DURING J2EE CTS TESTING. JR17130 INSTANCE CRASHES WITH DIA9999E AND INTERNAL CODE 0XFFFFF7 WHEN EXECUTING A SPECIAL KIND OF SQL COMMAND JR17140 DATA TRUNCATION DUE TO INVALID CONVERSION DURING CASING FROM INT (4-BYTE) TO SHORT (2-BYTE) AND LOSING HIGHER ORDER BYTES APAR fixes included in U482112 (Fixpak 10) APAR No. Abstract -------- -------------------------------------------------- IC32940 CORRECT POTENTIAL SECURITY PROBLEM WITH DB2CKPW AND DB2CHPW IY13665 POOR PREPARE TIME WITH DISTINCT CLAUSE AND TRANSITIVITY IY15783 DB2AUDIT FAILS WITH AUD0022N WHEN FILE SIZE REACHES 4GIG IY18143 MEASSAGE FROM CLI_SDAINITSQLDAPARMFILING DB2DIAG.LOG FILE WITH ERROR 2064. IY18754 EXCESSIVE REAL MEMORY USAGE RUNNING SIEBEL WITH DB2 ON SOLARIS. IY19481 SQL0502 ERROR OCCURING WHEN USING JTA THROUGH A V6.1 GATEWAY TO A HOST DATABASE. IY19513 PREP TIME FOR A NUMBER OF QUERIES IN AN SAP BW SYSTEM UNACCEPTABLY HIGH @ OPTLEVEL 5 IY21438 SNAPSHOT COUNTER LEAK FOR ACTIVE SORTS IY21575 SIGNAL 11 IN __CT__9SQLNQ_EHD/ SQLNR_CONVERT_MONTH_PRD IY21678 SQL RUN WITH WHERE CLAUSE CREATES BAD ACCESS PLAN WHEREAS THE SAME SQL WITH UNION RUNS WITH GOOD ACCESS PLAN. IY21679 SQL0802N DURING AVERAGE COMPUTE IY21798 INCORRECT RESULTS FROM QUERY RELATED TO CSE PREDICATE PUSHDOWN IY21936 IN JAVA, DOING GETBIGDECIMAL()ON A COLUMN TYPE DOUBLE YOU WILL GET NUMBERFORMATEXCEPTIONIF DOUBLE IS IN EXP. FORMAT. IY21954 CORE FILE GENERATED IF ALL PHYSICAL MEMORY USED ON CLIENT IY22199 FP10WAS STUDIO: FUNCTION SEQUENCE ERROR. CLI0125E. IY22435 WITH INTRA_PARALLEL ON, QUERY FAILED WITH SQL0901 IY22756 BETTER HANDLING OF LOB FILES IY23183 SIGNAL 11 IN WRITEPAGES IY23322 TRAP WHILE RUNNING DB2ADVIS IY23339 IMPROVE THE COSTING FOR QUERIES INVOLVING ANY JOIN WITH A VALUESBOX IY23440 SNAPSHOT MONITORS DO NOT CAPUTRE THE SYSTEM/USER EXECUTION TIMESWHEN V7 CLIENT INTERACTS WITH V6 SERVER. IY23979 SQLJ IS BUILDING WRONG HOST VARIABLES FOR THE DECIMAL COLUMN. IY24019 DB2LOOK DROPS FOR BIT DATA IN CREATE DISTINCT TYPE DEFINITIONS IY24025 ANY WITH ABILITY TO PERFORM SET INTEGRITY ... OFF ON A SINGLE TABLE MIGHT PUT THE OTHER SPECIFIED TABLES INTO CHECK PENDING IY24282 DB2DIAG.LOG ENTRY : UNABLE TO FIND/REMOVE TABLE FROM NOLOG LIST : THIS SHOULD NOT BE LOGGED FOR DECLARED USER TEMPORARY TABLES IY24324 DB2DIAG.LOG SHOWS INDEX KEY COULD NOT BE FOUND (SRCHTREE ERROR: FFFF F92C), MARK DB BAD, PANIC AND SLEEP. IY24644 DRDA POINTER IS NOT INITIALIZED CORRECTLY IN TCP/IP COMMUNICATION. CAUSES TRAP UNDER CERTAIN CONNECTIONS USING JAVA IY24645 BUFFER CORRUPTION CAUSES REPLICATION TO FAIL. IY24647 INSTANCE CRASH AND TRAP AT SQLJDRD1 IY24806 TABLESPACE TAKEN OFFLINE BY ROLLFORWARD CAN CAUSE DATA CORRUPTION IF ROLLED FORWARD AGAIN WITHOUT BEING RESTORED FIRST. IY24826 TRAP IN SQLO_TRCE WHEN USING XA & 2PC IY24836 THE COST IS WAY UNDERESTIMATED WHEN USING THE DB2PIPEDPLANS REGISTRY LEADING TO MSJN OVER NLJN.. JR15142 NOT TO GENERATE MULTIPLE SEMIJOIN FETCH PLANS JR15908 INSERTING A NULL VALUE INTO A BLOB COLUMN, WE GET THE SQL0301N JR15934 AFTER SQL0905 FROM DB2 ON OS390, CURSOR IS NOT CLOSED AND ATTEMPTS TO ACCESS CURSOR GETS SQL0519. JR15958 INVALID SQL GENERATED WHEN DEFINE JOIN ON REPLICATION SOURCE JR15964 LOCK SNAPSHOT HANGS DURING A ROLLBACK CAUSING ALL OTHER DB2 OPERATIONS TO HANG UNTIL ROLLBACK IS COMPLETE - WORKAROUND JR16028 DB2_71 ON OS/2, BACKUP RETURNS SQL1224 WITH EXCEPTION C0000005 JR16187 CLEANUP CODE FOR COMM. HANDLER AT WRONG PLACE - SQLFREEBUFFER CR JR16191 SQL3966N RECIEVED WHEN ATTEMPTING TO COMPLETE A PREVIOUS SYNC SESSION JR16208 DB2PROFC IS NOT USING QUALIFIER OPTION TO QUALIFY TABLES BEFORE DESCRIBING - RESULTS IN UNREPORTED SQL0204N JR16242 LOCK CONFLICT SHOULD NOT BRING DATABASE DOWN WITH -902 JR16321 INCORRECT COMPILATION INSTRUCTION IN SAMPLE DB2UEXT2.CADSM (NT) JR16341 WINNT DB2MSCS/DB2ICLUS SUPPORT COMPUTER NAME GREATER THAN 8 CHAR JR16372 JDBC IS NOT HANDLING THE SETCONNECTIONATTRIBUTE() CORRECTLY. AND THERE IS NO WORK AROUND. JR16386 JDBC2.0 FUNCTION EXECTUEBATCH( ) NOT WORKING AS IT SHOULD. JR16396 SORT ROUTINE CALED TWICE: ONCE DIRECTLY AND ONCE INDIRECTLY SO PERFORMANCE IS DEGRADED. JR16416 TRAP IN SQLJ WHEN FREEING MEMORY FROM A CURSOR CONTROL BLOCK (DRDA) JR16419 INFINITE LOOP IN CLI CATALOG CALLS AGAINST VM DB2. JR16420 COGNOS IMPROMPTU APPLICATION IS FAILING WITH CLI0501N WITH ASYNC=1 JR16422 DB2 GATEWAY TRAPPING AFTER RECEIVING DATA FROM A STORED PROCEDURE ON OS/390. JR16428 GETCOLUMNNAME() WITH NET DRIVER TRUNCATES COLUMN NAME TO 29 CHARACTERS IF COLUMN NAME LENGTH IS 30 CHARACTERS JR16430 SELECT INTO FOR SQLJ NOT RETURNING CORRECT SQLCODE JR16431 DB21036E WHEN CALLING SP FROM CLP WITH SP NAME THAT HAS '_' JR16450 SORT ORDER ON VARGRAPHIC COLUMNS ON UNICODE DBS WRONG JR16481 ROWSTATUSARRAY OF SQLEXTENDEDFETCH SHOULD REFLECT SQL_SUCCESS_ WITH_INFO FOR THE ROW(S) THAT GENERATED CLI0165E JR16487 TRAP IN SQLPGETDBMON DURING A DATABASE RESTORE JR16567 HANDLING LOCK CONFLICT OF CONDITIONAL LOCK FOR APAR JR16242 JR16579 USEJDBC2.BAT FAILED BUT 'INUSE' SHOWS JDBC2.0 APAR fixes included in U478300 (Fixpak 9) APAR No. Abstract -------- -------------------------------------------------- GG04206 APPLY NOT REDRIVING APPLY WHEN AN RI VIOLATION IS DETECTED IN THE 'F' DIRECTION. GG04207 APPLY IS HAVING PROBLEMS REPLICATING FROM BASE TABLE OF AS/400 BLOB FIELD TO WIN 2000 SERVER RUNNING DB2 UDB EE V7.1. GG04208 APPLY FAILED SQLCODE911 WHEN REPLICATING FROM VM SOURCE SERVER GG04214 APPLY DID NOT FULLREFRESH IF CAPTURE COLD START AT REPLICA IY15200 CLOSING SINGLE CONNECTION AFTER MULTIPLE CONNECTION IS ESTABLISHTO REMOTE SEVER RESULTS IN CLI0106E ERROR ON IRIX PLATFORM. IY15734 INSTANCE CRASH ON TRAP (SIGSEGV) IN SQLBLATCHPINNEDPAGE EEE ONLY. INTERNAL SYNCHRONIZATION PROBLEM EXECUTING SQL. IY16367 IF SQLEXECUTE FOR A CALL STATEMENT RETURNS SQL_SUCCESS_WITH_INFO-THE JDBC APPLET SERVER DOESN'T WRITE OUT THE OUTPUT PARAMETERS. IY16754 SQL2062N AN ERROR OCCURRED WHILE ACCESSING MEDIA '/APPS/DIT/NEWYORK/DB2/P1DBINC/SQLLIB/ADSM/LIBADSM.A'.RC:'137 IY17199 PRECOMPILER REJECTING THE INDICATOR VARIABLE ATTACHED WITH THE HOST VARIABLE. IY17394 SQL0900N: LOAD RECREATE INDEX DOES NOT UPDATE METAROOTPAGE PROPERLY. IY17521 AN APPLICATION SENDING A BAD RID (BOOKMARK) CAUSES DB2 TO PANIC,AND AN ENGINE TRAP DURING A DIRECT FETCH. IY17652 TRAPS WHEN USING LOB FILE INPUT DATA IY18124 MAX_SYNCH_MINUTES WITH CCD - APPLY UPDATES THE SUBS_SET SYNCHPOINT INCORRECTLY CAUSING POTENTIAL DATA LOSS IY18178 VB IDE GETS 'ERRORS OCCURRED' MESSAGE WHEN TRYING TO GET A LIST OF STORED PROCS WITH NAMES GREATER THAN 8 BYTES. IY18246 AST ROUTING USES INCORRECT CARDINALITY ESTIMATE IY18293 SAMPLE USEREXIT SHOULD INDICATE THAT 'MOVE' IS UNSUPPORTED FOR LOG ARCHIVING - ONLY 'COPY' IS SUPPORTED IY18327 DIA3847C AN ERROR OCCURRED IN A DATABASE PAGE HEADER BY DB2PFCHR IY18373 APPLY SHOULD EXECUTE THE SQL BEFORE AND AFTER STATEMENTS FOR A SUBSCRIPTION SET EVEN IF THERE IS NO DATA TO REPL. IN THAT CYCLE IY18386 DB2AUDIT, NO DATABASE NAME FOR CHECKING EVENT BY SUBAGENT IY18418 RUNSTATS DOESN'T UPDATE SYSIBM.SYSCOLUMNS CORRECTLY IY18781 SQL0973N WHEN PACKAGE CACHE NOT OVERFLOWED - CAUSED BY NOT ACCOUNTING FOR OSS OVERHEAD. IY18975 OVERCOSTING THE I/OS OF THE RIGHT HAND (INNER) PLAN OF THE NLJN'S THAT ARE OF THE TYPE THAT THE INNER HAS NO SORTS OR TEMPS IY18990 TRAP IN SQLNO_CRULE_INDEX_ANDING WHEN OUT OF STMTHEAP IY19041 ISERIES (OS/400) V5R1 AS A CLIENT DOES NOT INTEROPERATE WITH WORKSTATION DB2 UDB AS A SERVER IY19053 TRAPPED IN SAVEPOINT WHILE ROLLBACK,SHOULD IGNORE SQLCODE- 1035 FROM REMOTE NODE IY19086 TELNET TO JDBC DAEMON (DB2JD(S)) TRAPS AFTER KEYING 10TH CHARAC TER IY19116 OPTIMIZED QUERY RETURNS INCORRECT RESULTS IY19336 SMALL TIMING WINDOW WHERE THE CAPTURE READS A LOG WHILE IT IS BEING ARCHIVED -> WORKAROUND: RETRY SHOULD RESOLVE IY19492 LONG PREPARE TIME FOR EEE QUERIES INVOLVING MULTIPLE JOINS, WHERE AT LEAST ONE OF THE TABLES RESIDES IN A MULTI-NODE NODEGRP IY19535 ERROR MESSAGE DIA3808C IS INCORRECTLY DUMPED OUT IN THE DB2DIAG.LOG FILE WHEN THE ACTUAL ERROR IS SQL1013. IY19657 WHEN A COMMAND IS RECEIVED, CAPTURE STILL READS A LOG RECORD BUTFORGETS IT, AND READS THE NEXT RECORD AFTER PROCESSING THE CMD. IY19670 TRAP - SIGNAL 11 IN SQLPM_WRITE_LOCKS WHILE PERFORMING LOCK SNAPSHOT CRASHED THE DB2 INSTANCE IY19934 ATTRIBUTES ON SQLLIB/FUNCTION/JAR DIR FOR 'OTHER' NOT PROPER. IY19939 ADDITION OF CODE TO CHECK FOR ORDER BY CLAUSE ON AN UNTYPED PARAMETER MARKER IY19954 SQL1042C ON CONNECT TO A CONSISTENT DATABASE TRYING TO ALLOCATE INITIAL LOGS OVER A LOG THAT WAS EXTERNALLY TRUNCATED/CORRUPT. IY20037 DB2PFCHR,DB2PCLNR,DB2REBAL,DB2ESTOR PERSIST EVEN AFTER DBM SHUT DOWN & CONSUME CPU RESOURCES UNTIL REBOOT: RESULT POOR PERFORMAN IY20046 REVERSE INDEX SCAN CAN MISS KEYS IF HIT PARTIAL PAGE SPLIT ROLL-BACK IY20048 REVERSE SCAN MISS KEYS IF HIT PAGE SPLIT (TIMING). IY20064 SQL0973 QUERY HEAP MEMORY LEAK - CLI ONLY WHEN DATA TYPES OF PARAMETER AND COLUMN DO NOT MATCH, DB/APP USE DIFF CODEPAGES IY20069 PROBLEM WITH DATAPROP/CAPTURE. TIMESTAMP NOT INITIALIZED. IY20090 CLI SQLEXTENDEDFETCH() GETS "NUMERIC VALUE OUT OF RANGE" IY20157 ROLLFORWARD STATUS = TABLESPACE, BUT NO TABLESPACE IN THIS STATE -> RESTORE, THEN TBLSPC DROPPED B/F ROLLFORWARD IY20179 LOAD SEEMS TO HANG IY20191 SQLJ.INSTALL_JAR PROBLEM IY20221 SQL4912N WITH SQLJ HOST VAR IN LIKE COMPARISON AGAINST MVS 6 IY20235 SQLPUPDATEMINBUFFLSN PROBE:50 SHOULD NOT BE DUMPED INTO THE DB2DIAG.LOG AS IT IS ONLY INFORMATIONAL USED FOR DEBUGGING IY20285 THE HOST DB2 DATABASE BACKUP FAILS AS IT SEES THE LINK FILES ON DLFM ARE NOT YET BACKUPED. IY20318 SQLBGETPOOLSTATS CAN CAUSE LOG CORRUPTION IY20457 TRAP BECAUSE DB2 V6 CONNECTION POOLING DOES NOT SUPPORT CLIENT USING IPC CONNECTION TO CONNECT TO GATEWAY. IY20474 ADD FUNCTIONALITY TO SUPPORT EEE RESTORE FROM LEGATO AND XBSA IY20656 DB2OPTIONS: CLP IS USING THE OSS FUNCTION SQLOFPRT IY20673 HOST SERVER (E.G. DB2/390) RETURNS SQL0805N DURING IMPORT DUE TO A PACKAGE NOT FOUND. IY20814 DB2 CONNECT MAY CRASH WHEN PROCESSING THE REPLY FOR AN APPLICATION THAT IS THE VICTIM OF A DEADLOCK OR TIMEOUT IY20969 SIGNAL 11 TRAP IN SQLNO_SHRINK_POOL. IY21022 SUBOPTIMAL PLAN CHOSEN FOR STAR JOIN IY21341 LOG DIR FILLS DUE TO OLD LOG FILES NOT BEING DELETED/RENAMED DURING CRASH RECOVERY, AND SAME LOG IS REPEATEDLY ARCHIVED IY21375 SQL4908N IS GENERATED WHEN RF ON TABLESPACES IS ISSUED AGAIN ON TABLESPACES WHICH ARE RF PENDING STATE AND FLAG IN LFH IS ON. IY21415 DEADLATCH IF EVMON AND SNAPSHOTS ARE CALLED IN THE SAME TIME IY21846 DPROPR APPLY DOES 2 FULL REFRESHES AFTER CAPTURE COLD START. IY21936 IN JAVA, DOING GETBIGDECIMAL()ON A COLUMN TYPE DOUBLE YOU WILL GET NUMBERFORMATEXCEPTIONIF DOUBLE IS IN EXP. FORMAT. IY21937 JVM CRASHES WHEN PASSING NULL TO STATEMENT.EXECUTE( ) IY21938 NO ROWS ARE RETURNED WHN A +437 IS RETURNED IN MINMEM IY21939 SQL0998 RC=13 AX_REG() AND AX_UNREG() NOT FOUND IY21940 SQLPUTDATA OF ZERO BYTES IN CAUSING A MEMORY OVERWRITE IY21947 SQL2025N RC=-50 ON A DB2 BACKUP TO ADSM AFTER A NODE IS ADDED THAT DOES NOT CONTAIN DATA (EG. TEMP TABLESPACE) IY21951 SIGNAL 11 TRAPS IN MEMORY OPERATIONS (MEMHOLDSEG AND SQLOFMBLK) COMING FROM SQLNO_CLOSE_POOL IY21952 IMPORT WITH BUFFERED INSERT CAUSES TABLE LOCK ON SYSIBM.SYSPLAN IY21953 APPLICATION WITH MINCOMMIT 4 AND HANGS WAITING FOR LOG DATA TO BE WRITTEN TO DISK IY21995 QUERY AT OPTLEVEL 3 RECEIVES A SQL0101 EVEN WITH STMTHEAP MAXED IY22008 ONCE JOBIDS HIT 999, JOBIDS ARE REUSED. HOWEVER, JOBS ISSUED VIA 'RUN NOW' KEEP REUSING SAME JOBID IY22291 TRAP IN SQLCSPC_COOR_REG WHEN HOST EXPERIENCES COMM. PROBLEMS IY22298 DB2BATCH DOES NOT SUPPORT VARGRAPHIC, CAUSES TRAP. IY22459 MS 932 IS EQUIVALENT TO IBM 943. WE ARE ACTUALLY DOING CODE PA IY22698 SCHEDULED JOB NO LONGER RUNNING IN SCRIPT CENTER AFTER APPLYING FIXPAK8 (V6.1) B/C THE DB2JOB2 IS MISSING IN FIXPAK8 IY22985 DB2 INSTANCE CRASHED WITH SIGNAL #11 IN SQLRA_FP_COPY() IY22988 TABLESPACE REMAINS IN LOAD PENDING IF ASC/DEL FILE NOT ACCESSIBLE IY22990 AUTOLOADER HANGS WHEN USING FILE_TRANSFER_CMD AND LOAD ABORTS IY23140 SIGNAL 11 TRAP IN SQLBLATCHPINNEDPAGE() IN MPP/EEE ONLY INVOLVES A WHERE CURRENT OF CURSOR (WCOC) UPDATE OR DELETE STATEMENT. IY23205 A NEW DB2 HISTORY FILE IS CREATED DURING A FAILED MIGRATION, WHICH CAUSES ALL SUBSEQUENT MIGRATIONS TO FAIL. IY23210 THE CLP ON SOLARIS CALLS GETPASS WHEN ISSUING AN EXPLICIT CONNECT WITHOUT A PASSWORD GIVEN WHICH LIMITS THE NUMBER OF CHARS TO 8 IY23227 DB2BATCH RETURNS ELAPSED TIME "NOT COLLECTED"FOR INSERT STMT IY23245 SQL3015N - INSTANCE CRASHES DURING IMPORT BECAUSE OPEN CURSORS ARE ENCOUNTERED DURING IMPORT REPLACE IY23321 LOAD WITH FASTPARSE REJECTED DATE DATA BECAUSE DATE CONVERSION ROUTINES RAN AGAINST COLUMNS INDICATED (IND) AS NULL. IY23455 CONTROL CENTER INCORRECTLY FOLDS USERID TO UPPER CASE USING THE NATIONAL LANGUAGE CODE PAGE INSTEAD OF THE ENGLISH CODE PAGE. IY23456 CLI TRACE DOES NOT CAPTURE SOME UNICODE FUNCTIONS IY23458 HASH JOIN GIVES INCORRECT OUTPUT. IY23459 DB2ADUTL HAS A ARCHIVE LOG LIMIT OF 1023 ENTRIES. IY23476 DB2 CRASHES AT FUNCTION SQLESRVR JR15209 DR. WATSON OR HANG ON TEST CONNECTION IN CCA ON DB2 V6.1 FP5 JR15220 SQLPUTDATA() MAY RESULT IN SQL0157N UNDER HIGH CONCURRENCY JR15234 INSERTING 'DIRTY' TIMESTAMP INTO DATE COLUMN RESULTS IN NO DATA INSERTED, BUT SQL_SUCCESS_WITH_INFO RETURNED TO APP JR15540 RUNSTATS CAUSES DB2 TO TRAP IN SQLIPROCESSCOL JR15786 DETAILED STATS PRODUCE BAD PLAN AT OPT 5 JR15857 USERIDS NEED WRITE AUTHORITY ON DAS DIRECTORY TO RUN SCRIPTS JR15880 SQL30081 RC:10054 JR15899 TRAP IN SQLOFMBLKEX DURING RESTORE FROM DISK DUE TO MEMORY CORRUPTION JR15908 INSERTING A NULL VALUE INTO A BLOB COLUMN, WE GET THE SQL0301N JR15909 HOSTNAMES > 8 CHARS DISPLAY INCORRECTLY IN SQL GENERATED BY CC JR16025 SQLGETDATA() FAILS TO RETRIEVE DATA AFTER SQLSETPOS() JR16028 DB2_71 ON OS/2, BACKUP RETURNS SQL1224 WITH EXCEPTION C0000005 JR16039 DB2TBST TOOL DOES NOT SHOW THE STATE OF ALL THE TABLESPACE STATEIN SQLUTIL.H JR16079 TRAP IN SQLJMBCQ BECAUSE THE DRDA HEAP IS EXHAUSTED JR16133 ROLLFORWARD SHOULD DETECT AN INCOMPLETE LOG FILE JR16218 WHENEVER THE CUSTOMER GOES TO GET THE SOURCE STORED PROCEDURE CODE IN THE STORED PROCEDURE BUILDER HE GETS SQL0514. JR16219 KEYSET PARSER RETURN CODE=1002 CAUSES HEAP CONSUMPTION JR16220 XA PASSWORD LENGTH SHOULD BE 14 CHARACTER MAX JR16222 KEYSET CURSOR QUERY DOES NOT WORK AGAINST TABLE ALIASES. JR16223 SQLEXTENDEDFETCH RETURNS SQL_SUCCESS_WITH_INFO IF A ROW DETECTEDAN ERROR AND ONLY ONE ROW BEING RETURNED. JR16225 GETTING CLI0114E ON INSERT OF A RECORD WITH A DATETIME DATATYPE IN A VC++ APPLICATION JR16226 TABLE WITH INDEX AND LONG VARCHAR WILL ONLY RETURN FIRST COLUMN JR16227 EXECUTEUPDATE() DOES NOT THROW EXECEPTIONS FOR SELECT STATEMENTS JR16274 SMCODE=-28 FROM PERFMON AFTER CC ABNORMAL TERMINATION JR16277 ASNCCP.EXE IS REPORTING SQL2657 ERROR AND DB2DIAG.LOG REPORTS LOG FILE SIZE PROBLEM. JR16278 EXECUTEQUERY() DOES NOT THROW AN EXCEPTION WHEN IT IS USED FOR SQL STATEMENTS THAT DO NOT RETURN A RESULT SET JR16294 OS/2 DB2 BACKUP VIA USEREXIT WILL FAIL AT AND AFTER SUNDAY SEPTEMBER 9TH 01:46:39 2001 JR16355 TRAP IN SQLE_DB2RA_AS_DB_FETCH JR16372 JDBC IS NOT HANDLING THE SETCONNECTIONATTRIBUTE() CORRECTLY.AND THERE IS NO WORK AROUND. JR16389 CONNECTIONS TO LOCAL DATABASE CONSUME LAN CACHED CREDENTIALS ON WINDOWS 2000 WHEN NOT CONNECTED TO DOMAIN JR16390 DRDA_HEAP_SZ MEMORY LEAK. SYMPTOMS: SQL30081, RC= *,*,0. JR16395 DB2 IS TRAPPING IN THE FUNCTON SQLEMRSP_AS.C JR16396 SORT ROUTINE CALED TWICE: ONCE DIRECTLY AND ONCE INDIRECTLY SO PERFORMANCE IS DEGRADED. APAR fixes included in U476111 (Fixpak 8) APAR No. Abstract -------- -------------------------------------------------- GG04082 SQLCODE313 PRESENTED AFTER USING OFFLINE LOAD PROCEDURE GG04108 ASNAPPLY WITH PARM NOSLEEP DID NOT ISSUE A 'CONNECT RESET',WHICH LEADS TO DSNL500I CONVERSATION FAILED MESSAGES ON DB2 OS/390 GG04110 NO TWO CAPTURES CAN BE STARTED WITH THE SAME DATABASE ALIAS (SRC_SERVER IN THE BOOK) IN DIFFERENT DB2 INSTANCES GG04128 IF A COMMUNICATION ERROR OCCURS (ASN1001E, SQL30081), THEN APPL RETURNS WITH RC=0 TO THE OS GG04196 OVERRIDE THE DEFAULT PARAMETERS OF LOGREUSE AND TRLREUSE USED BY ASNSAT WHEN INVOKING APPLY. GG04201 ASNCMD STOP FAILS TO STOP DATAPROPAGATOR CAPTURE. GG04205 ASNLOAD FAILED WHEN INVOKING APPLY USING A NETWORK ID. IY13152 USING VARCHAR AGAINST MVS IS LIMITED TO 254 CHARACTERS USING CLI IY13799 PACKAGE CACHE ENTRY FOR SELECT DOES NOT INDICATE THAT DEFAULT QUALIFIER (SCHEMA) HAS BEEN CHANGED IY14526 PROBLEM EXECUTING UPDATE QUERY AFTER INDEX ON AST IY14777 PREPAREDSTATEMENT.SETLONG() CALL FAILS TO DB2/390 IY15022 CONVERSION TABLE ERROR MESSAGE IS INCOMPLETE IY15093 WRONG MAPPINGS FOR ERROR MESSAGE SQL0465N AGAINST OS/390 IY15533 WRONG RESULTS CAUSED BY A MGJN WHICH IS NOT PROPERLY ORDERED. IY15942 DB2 OPTIMIZER DOES NOT HANDLE 'OPTIMIZE FOR N ROWS' CORRECTLY BY FAVOURING PIPED PLANS. IY15977 INFLATED CARDINALITIES ON EEE QUERIES USING NODENUMBER(COLUMN) PREDICATE MAY CAUSE OPTIMIZER TO CHOOSE BAD PLAN IN V6,V7 IY16009 ERROR IN MIGRATING FROM DB2 V5.2 TO DB2 V6.1, SQL0293 CONTAINERS COULT NOT BE FOUND. IY16164 ASNCAPTURE RETURNS -1 WHICH INDICATES A FAILURE EVEN WHEN A NORMAL MOBILE STOP HAS OCCURRED. IY16208 MQBACK ROOLBACK FROM MQSERIES CAUSES PROBLEMS IN EEE ENVIRONMENT IY16210 DB2DART /DDEL EXPORTS INCORRECT DATA ON NULL VALUE. IY16294 MAX COST LIMITATION WITH V6.1 QP GUI. IY16316 CONTROL CENTER HANGS WHEN ACCESSING TABLESPACE DATA FOR DB2 UDB ENTERPRISE EXTENDED EDITION (EEE) IY16434 DB2ADUTL RETURNS INCORRECT OUTPUT IY16487 LOAD OF TRUNCATED IXF CAUSING RECORD LENGTH <0 CAUSES EDU CRASH IY16498 . DB2 UDB ON UNIX/OS2/WINDOWS TRAPS WHEN ACCESSED FROM HOST SYSTEM IY16513 TRAP IN SQLOFMBLKEX, BUT BAD POINTER IS FROM SQRRCOM_RDS IY16521 DATABASE CRASHES AFTER INTERRUPTED REORG IY16571 CAPTURE STOPS PROCESSING WHEN IT RECEIVES SQL0100 (ROW NOT FOUND ) IN THE PC TABLE. IY16577 DB2ADUTL FROM SCRIPT CENTER FAILS WITH: ERROR: INITIALISE SESSION FAILED WITH ADSM RETURN CODE 168. IY16639 CREATE TRIGGER STATEMENTS GENERATED BY DB2LOOK FAIL TO RUN DUE TO THE LINE BREAK IN SCRIPT IY16674 CHANGING CAPTURE CODE TO PROCESS ALL THE COMMITS IN THE LOCAL NODE, WHICH WILL INCLUDE THE LOG RECORD TYPE OF 'C' IY16677 SQL1042 - INSTANCE CRASH / PANIC ON EEE WHEN MAXAPPLS IS HIT - SQL1040 - AND AN INTERRUPT OCCURS AT THE SAME TIME IY16687 DB2ICRT SUCCESSFUL BUT ERROR MESSAGE: MV: CANNOT RENAME /../SQLLIB/ADM/DB2SYSC.AIX433 TO /.../SQLLIB/ADM/DB2SYSC IY16693 SQLDESCRIBEPARAM NEEDS TO DESCRIBE 1ST PARAMETER MARKER VS 1ST PARAMETER IY16721 BAD FILTER FACTOR ESTIMATES FOR 'LIKE ?' AND ZERO FF FOR BETWEEN PREDICATES IY16746 INDEX STOP/START KEY LOGIC ALLOWS TOO MANY ROWS IY16750 TWO-PHASE CONNECT FAILED WITH SQL0902C 94 CCI IY16758 SQLEXTENDEDFETCH FAILS WITH CLI0115E IY16800 INCORRECT NUMBER OF ROWS READ/WRITTEN IN SQLCACHE IY16814 SEG FAULT WHEN RUNNING DB2EXPLN IY16937 DB2ADUTL FAILS WITH ANR0445W - MAXIMUM GROUP TRANSACTION SIZE EXCEEDED. IY16951 F51D IN SQLPGILT DURING RESTART DB OR CONNECT IY16958 SQL0901 IN SQLNO_SMP_FIX_COST DURING QUERY, INTERMITTENT IY16971 SQLJ CUSTOMIZER SHOULD SUPPORT MULTIPLE SER CURRENT PACKAGESET STATEMENTS. IY16975 WHEN USING SETSTRING(), DATA IS TRUNCATED IN STORED PROCEDURE IY16992 DB2LOOK PRODUCES OUT-OF-ORDER COLUMNS FOR FOREIGN KEYS IY17006 LOGSPACE INFORMATION REPORTED IN DB2 SNAPSHOT IS INCORRECT IY17011 IMPORT PROFILE FAILS TO CREATE DCS DB CATALOGS IY17036 CLI0109 STRING DATA RIGHT TRUNCATION ERROR WHEN CLEARPARAMETER() IS USED IY17053 DB2SPLIT FAILED IF OUTPUT FILE > 2GB IY17056 DB2ATLD USES SORT BUFFER TO OVERRIDE THE SORTHEAP IN DB CFG. IY17075 DB WITH LINKS IN PATH FAILS TO RESOLVE PATH FOR BACKUP. A - 1062 OR -1042 RESULTS, SUBSEQUENT CONNECTS MAY TRAP (SIG11). IY17077 INSTANCE DARI'S HAVE NULL DBCONN AND SHOULDN'T TRY TO WRITE RESULT SET INFO. IY17079 DIA3711C A FILE '' COULD NOT BE FOUND MESSAGE DUMPED INTO THE DB2DIAG.LOG FILE SHOULD HAVE THE FILENAME IY17163 WHEN EXTRACTING DDL FOR A TABLE USING DB2LOOK, THE OUTPUT COLLEC TED SHOWS SOME UNRELATED VIEWS. IY17179 SIGNAL#11 IN SQLUDRSA IY17191 READING THE LENGTH OF A VARCHAR INCORRECTLY IN THE INSTALL JAR C ODE: IT CHECKS AGAINST A 128 BYTE URL LENGTH. IY17255 RESTORE DB FAILES WITH SQL5005 SQLF_MIG_REL8 FFFFEC41 IY17260 CORRECTION OF THE OUTER_DVALS CALCULATION FOR ORDERED NLJN IY17290 DB2 UDB DRDA AS (APPLICATION SERVER) TRAPS WITH SIGNAL 36 WHEN TRYING TO FREE MEMORY IY17293 WITH NON-ADMIN USER, ICLUI COMMAND CENTER, WHILE REGISTRY IS BEING UPDATED, THROWS AN ACCESS EXCEPTION IN WINDOWS2K. IY17296 SQL4301 RC=4, AFTER INVOCATION OF JAVA STORED PROCEDURE, THE JNI OBJECT IS NOT DEALLOCATED FOR TIMESTAMP, TIME AND DATE PARMS IY17360 SQLJMF91 ATTEMPTS TO USE MEMORY THAT WAS FREED IY17378 SQL0902 ON BACKUP IY17406 DATABASE CRASH WHEN ATTEMPTING TO UNFIX A PAGE IN THE BUFFERPOOL WHICH WAS NOT FIXED. IY17429 DB2 CRASH WITH SIGNAL 11 IN SQM_INIT_SQLM_TABLESPACE() IY17468 MANY DEFUNCT DB2 PROCESSES OWNED BY THE FENCED ID AND WHOSE PARENT IS DB2SYSC PROCESS. IY17472 LOAD HANGS WITH 'THREAD CANNOT CHECK CHECK POINT' ERROR IN DIAG. LOG IY17489 SIGSEGV IN SQLRA_INVAL_VARS_HARD IY17525 SQL1015N, DATABASE MARKED BAD DUE TO IMPROPER SAVEPOINT HANDLING IY17542 MEMORY CORRUPTION CAUSED BY DB2 WILL CAUSE APPLICATIONS TO COME DOWN WITH SIG #11, SQLODELETE, SQLOGMBLK, ETC. IY17576 JAVA VISUAL EXPLAIN NUMERICAL LITERAL ERROR IY17577 INCONSISTENT RESULT FROM DB2ADUTL WHEN .LOG IS SPECIFIED VERSUS NOT. IY17591 DB2EXFMT OUTPUT SHOWS A NEGATIVE COST FOR AN ACCESS PLAN IY17600 SIG. 11 TRAP IN RETRIEVEBATCH IY17619 DIA1529C COULD NOT START DEADLOCK DETECTOR, GLOBAL DEADLOCK DETECTOR FAILING TO START. IY17649 ONLINE DATABASE BACKUPS RETURN SQL2038N RC -3838 AFTER A FAILED CREATE TABLESPACE IY17657 REORG TABLE INDEX RETURNS SQL2205 WHEN INDEX EXISTS IY17698 APPLY UPDATED THE WRONG SYNCHPOINT AND SYNCHTIME IN PRUNCNTL TBL IY17767 INVALID INPUT DURING ASCII TO PACKED DECIMAL CONVERSION CAUSES SEGV/CORE AND POSSIBLY STACK CORRUPTION (MOSTLY AT DIAGLEVEL 4) IY17851 NULL TERMINATED STRING CAUSES DB2 TO TRAP WHEN WE HAVE TO REDESCRIBE A STORED PROCEDURE CALL STATEMENT IY17853 'INVALID EXECUTE FLAG' DB2DIAG.LOG ENTRY WILL ALSO CAUSE SQLCODE -901. IY17922 RESTART/CONNECT/CRASH RECOVERY FAILS WITH SQL1042C WITH INVALID LSN DUE TO A PROBLEM WHEN ABORTING A TRANSACTION IY18093 AN AGENT HANGING IN TQ CODE, ANOTHER STUCK ON APM LATCH IY18119 STATEMANT MONITOR EVENT LIST CORRUPTION IY18121 TRAPS (SIGNAL #6) IN FUNCTION SQM_EVMON::LOG_EVENT() IY18122 MEMORY LEAK IN SQLRI_LIKR_ALLOC() IY18162 DB2DART REPORTS BPS HEADER PROBLEMS AFTER DATABASE RESTORE. IY18231 DB2 APPEARS TO BE 'HUNG' WHILE TRYING TO ACCESS A TABLE IY18373 APPLY SHOULD EXECUTE THE SQL BEFORE AND AFTER STATEMENTS FOR A SUBSCRIPTION SET EVEN IF THERE IS NO DATA TO REPL. IN THAT CYCLE IY19007 GETS ERROR IN DB2DIAG.LOG SQL -901 SQLERRMC: SQLNO_CRULE_SAVE_PL ANS 100:RC(0) SQLERRP :SQLRFAKE WITH STAR JOIN PLANNING. IY19009 A FILE SHARING VIOLATION HAS OCCURRED, FILENAME WAS ''.ZRC=FFFFF 616.DB2 FAILS TO USE THE ARCHIVED LOG FILES,HELD BY OTHER APPLIC IY19012 SQL0567 : DB2LOOK -X PUTS GROUP BEFORE PUBLIC . GROUP CANNOT BE USED BEFORE PUBLIC IN GRANT OR REVOKE STATEMENT IY19019 COMMENT IN DB2CLI.INI PREVENTS DATASOURCE FROM WORKING PROPERLY IY19020 DATABASEMETADATA.GETDRIVERNAME() RETURNS LIBDB2.A INSTEAD OF DB2 IY19021 VERSIONING NOT SUPPORTED IN DB2DATASOURCE CODE IY19022 ERROR IN SIZE OF RETURN VALUE FOR INOUT VARCHAR PARAMETERS IY19023 SQL0510N CAUSED BY NOT REUSING SECTIONS CORRECTLY IN THE PKG IY19024 DB2CCOR/DB2CCWRK PAIR DOES NOT TIME OUT WHEN SPAWNED IN THE CONTEXT OF NODES STATUS MONITORING IY19026 ABEND WHEN USING VARCHAR 600 FOR BIT DATA IY19027 SUPPORT FOR SQL_ARD_TYPE DATA TYPE. IY19028 GETDRIVERNAME() CALL TO RETURN OUTPUTS TO DISTINGUISH BETWEEN JDBC APP AND NET DRIVERS. IY19030 DATA CORRUPTION OCCURS ATTEMPTING TO GET BLOB FROM DBCS DB IY19031 TABLE BEING MARKED FOR DELETE PENDING BEFORE LOG RECORD IS WRITTEN IY19035 INCORRECT FILTER FACTOR COMPUTATION FOR RANGE PREDICATES IY19037 USING QMF V7.1 FOR WINDOWS TO ACCESS PARTITIONED DATA ON DB2 UDB EEE V7.1 RESULTS IN SQL1013 'DATABASE COULD NOT BE FOUND' IY19038 OUTPUT IS CUT OFF WHEN JAPANESE(HANKAKU/KANA) IS AT THE HEAD OF THE DATA. IY19055 SQL SELECT STATEMENTS GIVES INCONSISTENT OUTPUT ON MULTIPLE RUNS IY19056 SQL0803 ON REBIND OF APPLICATION IY19057 SNAPSHOT OUTPUT SHOWS 'MAXIMUM ASSOCIATED AGENTS = 0' AND 'AGENTS ASSOCIATED WITH APPLICATION = 1' WHICH IS INCORRECT IY19058 JOBIDS ARE NOT REUSED WHEN 999 LIMIT IS REACHED IN SCHEDULER IY19098 CANNOT RUN DB2GOV W/ SYSCTRL GROUP USER THAT IS NOT INST OWNER. IY19114 $N CLAUSE IN CREATE TABLESPACE PROBLEM IY19115 ERROR IN CONVERTING STRING TO DECIMA IY19116 OPTIMIZED QUERY RETURNS INCORRECT RESULTS IY19117 DEBUG CODE TO DUMP INFO WHY USEREXIT STOPS ARCHIVING LOGS JR14514 CANNOT CREATE A KEYSET CURSOR IF THE KEY IS PART OF THE ORDER BY CLAUSE. JR14610 WHEN TRYING TO ALTER A TRIGGER FROM WITHIN THE CONTROL CENTER THE TRIGGER STATEMENT IS GREYED AND CANNOT BE SELECTED FOR COPY. JR14868 FFFFA602 AT DB2GOV START GOVERNOR JR15150 ADO/DB2-SEMAPHORE LEAK CAUSES HANDLE COUNT INCREASE. JR15310 SQLGETINFO(SQL_EXPRESSIONS_IN_ORDERBY) RETURNS 'Y' AGAINST MVS - SHOULD BE 'N' JR15369 SQLTABLES RETURN NO_DATA_FOUND OR CLI0118E BECAUSE OF EXTRA DOUBLE QUOTES IN TABLETYPE SETTING IN DB2CLI.INI FILE. JR15435 NOT POSSIBLE TO NOT ENTER SIGN '-' (-1) FOR BP SIZE FROM THE CC JR15528 'BAD' RANGE OF SORTHEAP SIZE(>1014 AND < 1038) IN THE OPTIMIZER JR15574 SQL0502 WITH SQLMATHWARN=ON JR15581 DB2 TRAPS AT TRACE FUNCTION WHEN BAD DATA IN BUFFER IS LOGGED TO DB2DIAG.LOG DURING INSTANCE CRASH (REFER DEFECT 136377) JR15585 DB2HISTORY* APIS MAY TRAP IF UNINITIALIZED DATA PASSED IN. JR15599 CALLING SP WITH INOUT DECIMAL ON AN MVS SYSTEM CAUSES SQL0304 JR15606 MTS APPLICATION FAILS TO RECONNECT AFTER RECYCLING DB2 JR15631 DB2 CONNECT SHOULD NOT ATTEMPT TO CONVERT GRAPHIC COLUMNS FROM DOUBLE-BYTE CODEPAGE TO SINGLE-BYTE CODEPAGE. SHOULD ERROR. JR15640 THE CONTROL CENTER FAILS WITH ERROR SQL0104N WHEN ATTEMPTING TO DISPLAY INDEX NAMES USING THE TURKISH LOCALE JR15655 -443 ERROR ON SIEBEL UDF AFTER UPGRADE FROM FP5 TO FP6ON NT SQLERRMC: SIEBEL.NEXTSEQ NEXTSEQ UNABLE TO ACCESS SEGMENT JR15661 TRAP IN BSORTGETNEXTPARTIALKEY ON NT JR15671 AMBIGUOUS REFERENCE COLUMN (SQL0203) WHEN QUERYING MVS LEADS TO DR. WATSON TRAP JR15704 SQLM_STMT_START AND SQLM_STMT_END (FFFFFFFF) ARE LOGGED IN THE DB2DIAG.LOG JR15712 SNAPSHOT OUTPUT SHOWS 'MAXIMUM ASSOCIATED AGENTS = 0' AND 'AGENTS ASSOCIATED WITH APPLICATION = 1' WHICH IS INCORRECT JR15728 CC/ITALIAN DIDN'T DISPLAY ',' SEPARATOR VIA SAMPLING A TABLE. JR15737 PATCH2=29 CAUSES PROBLEM WITH CONVERSION IN A 0 PRECISION DECIMAL TO DOUBLE CONVERSION. JR15750 DB2EVA CAUSED AN INVALID PAGE FAULT IN MODULE DB2ADMIN.DLL JR15756 INSTANCE TRAP IN SQM_EVMON_OSTREAM::WRITE_DATA JR15769 CREATING EVENT MONITOR ON 'DATABASE A ALIAS A1' USING EVENT MONITOR GIVES DBA5500. JR15785 TRAP IN JDBC IF RESULTSETMETADATA IS USED WHEN CONNECTION CLOSED JR15799 PROBLEM WITH FOREIGN KEYS AND SET NULL CONSTRAINTS JR15904 DR.WATSON IN DB2CLI.DLL WITH JDBC APP CALLING STORED PROCEDURES JR15905 SQLMORERESULTS() DOES NOT HANDLE ERRORS FROM BATCHED COMMANDS JR15906 CCA IS PUTTING THE KEYWORD 'MULTICONNECT' KEYWORD UNDER THE DSN ENTRY OF THE DB2CLI.INI FILES - SHOULD GO UNDER COMMON SECTION. JR15907 -805 CAUSED BY CURRENT PACKAGE SET IS NOT RESET JR15908 INSERTING A NULL VALUE INTO A BLOB COLUMN, WE GET THE SQL0301N JR15909 HOSTNAMES > 8 CHARS DISPLAY INCORRECTLY IN SQL GENERATED BY CC JR15910 CONNECT TYPE 2 APPLICATION THAT CALLS A STORED PROC TRAPSIN SQLE_DBM_DARI - APPLICATION RECEIVING SQL1327 JR15911 DB2 FOR OS/390 CANNOT MAKE TYPE 2 CONNECTION TO UDB WHEN SPM ENABLED JR15912 CURRENTSQLID NOT USED UNDER MTS TRANSACTION ENVIRONMENT. JR15913 SQLDESCRIBEPARAM CALL TO HOST RETURNING SQL0236 JR15914 DESCRIBED COLUMN NAMES ARE INCORRECT AFTER SWITCHING CURSOR TYPE IN JAVA OR CLI APPLICATION. JR15915 SQL2650 WHEN TRYING TO TAKE ONLINE BACKUP. AFTER APPLYING FIX FOR IY15913, GET ERRORS IN SQLPALR_READPAGESDISK PROBE 158 JR15916 TIMING PROBLEM. TWO THREADS ACCESSING SAME MEMORY AREA WHEN NET WORK CABLE IS PULLED. JR15917 LOAD FROM CONTROL CENTER PRODUCES INVALID NULL INDICATOR CLAUSE JR15919 THREAD CRASHES IN 'COPY TABLE' DIALOG BOX, RENDERING IT USELESS JR15922 ALERT CENTER DOESN'T INVOKE WHEN THRESHOLD IS REACHED JR15923 TRAP IN SQLCSPC_COOR_REG. JR15927 SIG 11 IN SQLOXULT THROUGH SQLRA_CACHE_SPACE_MGMT JR15928 ALTER COLUMN WITH CONSTRAINT ADDITIONCLAUSE SHUTS DOWN ENGINE APAR fixes included in U474781 (Fixpak 7) APAR No. Abstract -------- -------------------------------------------------- GG04021 CAPTURE CRASHED WITH APPLICATION ERROR: THE MEMORY COULD NOT BE 'READ' GG04044 APPLY CONNECT TO THE SOURCE FOR UPDATING PRUNCNTL.SYNCHPOINT BUT IF NO CAPTURE IS RUNNING - NO SQL PROCESSED - DSNL500I MESSAGE IY10950 UNDERSCORES IN TABLE ALIAS CAUSE MS JET ENGINE ERROR WHEN LINKIN G TABLES. IY12035 SIGNAL 11 TRAP IN SQLRI_RESTORE_SPEC_REG_INFO() IY12393 INSTALLER SHOULD SET DB2CCMSRV TO A VALUE DIFFERENT FROM 523 IY13019 TRAP (SIG 11) IN SQLNO_UNION_SETSN IY13147 COST OF THE QUERY INCREASES AS THE BUFFER POOL COUNT INCREASES. DB2EXFMT COST GROW AS THE BUFFERPOOL GETS INCREASED. IY13393 IMPORT DOES NOT USE CURRENT SCHEMA CORRECTLY IY13410 IMPROPER HANDLING OF LOGS WITH RAW DEVICE AS ACTIVE LOG PATH. GET SQL4970N WHEN ISSUING A ROLL FORWARD. IY13468 DEFECT IN CLI IN REGARDS TO HOW WE DETERMINE THE CTX USED AT THE ENVIRONMENT LEVEL. IY13598 SQL1627W WHEN RUN DB2 GET MONITOR SWITCHES AFTER UPDATING THEM FROM A 7.1 CLIENT. IY13655 ADD NEW DB2LOOK SCHEMA OPTION REMOVED BY DEFECT 153542 IY13696 SQL1273N ON ROLLFORWARD DATABASE (MISSING LOG FILE S0000000.LOG) IY13738 FROM CLIENT TO AIX SERVER,JOB IS SCHEDULED THORUGH SCRIPT CENTER WITH CORRECT USERID,NO MATTER WHAT PASSWORD,JOB EXECUTES SUCESSF IY13749 SQL2038 RC=32 DURING CAPTURE ACTIVITY. IY13751 STP.SQLJ STORED PROCEDURE SAMPLE, DOES NOT CONTAIN CODE FOR CLEA N UP. IY13807 DLFMUPDT FAILED WITH DBI1282. BACKUP_INSTINFO() IN DB2IUTIL DOES N'T CONSIDER TO BACKUP DBM CFG FOR DLFMUPDT COMMAND. IY13832 MULTIPLE STORED PROCEDURES WITH SAME SPECIFIC NAME CAUSE VARIOUS CLI/JDBC PROBLEMS IY13841 APP. CURRENT CONNECTION CHANGED WHEN USING XA COMPLIANT TRANSACT -ION MANAGER WITH DB2 IY13893 ADD SUPPORT FOR THE COLUMN NAME UNDER MINMEM MODE FOR JDBC IY13970 CCA TRUNCATES HOSTNAME TO FIRST PART OF FOUR PART NAME IY13979 -805, -818 SQLCODE RECEIVED FROM MULTITHREADED SQLJ APP IN A UNIX ENVIRONMENT. IY13995 SQLFETCH() FAILS WITH -501 ERROR WHEN MINMEMUSAGE=1 IY14000 SQL0723 MESSAGE TOKENS INCORRECT IY14016 PATH TO DSM.SYS AND DSM.OPT WHEN USEREXIT ENABLED IY14030 ROLLFORWARD COMPLAINS 'LIFELSN MISMATCH FOR REORG-REDO IY14038 DB2 UDB - IN CERTAIN SCENARIOS IF AN AGENT FAILS WITH ANSQL1040 (MAXAPPLS REACHED) ERROR, THE DATABASE WILL CRASH WITH SQL1042. IY14053 DB2 UDB - DATABASE CRASHES WITH A SIGNAL 11 TRAP IN FUNCTION SQLRX_LIKE WHEN THE SET EVENT MONITOR STATEMENT IS EXECUTED. IY14117 UNEXPECTED SIGALRM RECEIVED BY DB2UDF BRINGS DOWN DB2 IY14198 POOR PERFORMANCE WHERE TWO PREDICATES ON COLUMNS IN THE SAME TABLE TEST FOR EQUALITY WITH IDENTICAL CONSTANTS IY14209 DB2LOOK -L FAIL TO RETURN CONTAINER INFO WHEN RAN AS SYSCTRL ID. IY14234 DB2LOOK FAILS WITH TABLENAMES CONTAINING SLASHES IY14240 TO BETTER EXPLAIN COMPILER OPTIONS FOR DB2UEXT2.CADSM SAMPLE PRO GRAM IY14242 CLI API SQLCOLUMNS FAILS WITH SQL0198N ERROR WHEN ISSUED AGAINST A NEW DATABASE BEFORE BINDING THE CLI BIND FILES. IY14298 CUSTOMER SELECTS, IN JOURNAL, A COMPLETED SPECIFIC JOB TO DISPLA Y AND THE DB2DAS00 GOES DOWN. IY14307 INDEX CORRUPTION, CONTINUATION OF IY11940 IY14312 KEY NOT FOUND ERROR FFFFF92C DURING DELETE OR DB2DART REPORTS KEYS OUT OF ORDER ON AN INSPECTION. IY14314 SQL1224 DB2 INSTANCE CRASH. THIS OCCURS BECAUSE OF MEMORY CORRUPTION AFTER A COMMUNICATIONS ERROR - TRAP IN MEMTREEPUT IY14346 RESTART FAILS AFTER DB CRASHES BEFORE LOG WRITTEN BUT AFTER DB MARK INCONSISTENT IY14353 DB2 GIVES INCORRECT ANSWERS, TERMINATE DB CONNECTION FROM CLP OR HANG WHEN QUERIES ARE RUN FROM COMMAND CENTER. IY14370 DUPLICATE KEY CREATED DURING REORG IY14500 DLFM GOES DOWN FROM LOCK TMEOUT WITHIN GARBAGE COLLECTOR DAEMON IY14515 SIG 11 IN SQLPTRSP WHEN BUFFER MANIPULATOR RUNS OUT OF LOG SPACE IY14639 BACK LEVEL CLIENT CRASHES (SIG#11) IN SQLRR_OPEN IY14648 TRAP IN CLI WITH EARLYCLOSE, AUTOCOMMIT, AND BLOCK_FOR_NROWS SET IY14702 UPDATE ISSUE DEALING WITH STAR JOINS AND CODE GEN BUFFER REUSE VS. OVERWRITE. THE UPDATE SUCCESSFUL BUT DOES NOT UPDATE. IY14713 TRAP - EXCEPTION C0000005 IN DB2SYSCS.EXE EXECUTING SQL TRAP IS IN SQLNO_COST_MGJN DUE TO INVALID POINTER IY14741 SET INTEGRITY USING EXCEPTION TABLE FAILS WITH SQL0901 WHEN THE EXCEPTION TABLE HAS THE OPTIONAL COLUMN OF CLOB(32K) IY14752 AIX ONLY: DB2MEMDISCLAIM IS NOT INTERPRETED CORRECTLY ON VERSION 7. IF SET TO ANYTHING, IT IS OFF, IF NOT SET, IT IS ON. IY14770 SIGNAL 11 IN SQLVDIVIDE IY14775 CREATE TABLE LOOPS AND USES ALL OF THE LOG SPACE IY14820 ERROR DURING ALLOCATION OF LOG FILE CAUSES DATABASE TO SHUTDOWN IY14849 SQL0901N SYSTEM ERROR WITH REASON: UNRESOLVED QNC IY14901 SQLFREECONNECT/SQLFREEHANDLE RELEASES THE CONNECTION LATCH IY14989 INSTANCE CRASH ON ROLLFORWARD: SIGNAL 11 IN SQLPRFWD__FP7SQLEACB8SQLP_LSNUL IY15085 USEREXIT STOPS TO BE CALLED WITH FFFFA602 FROM SQLPGART MESSAGE IY15091 AUTOLOAD FAILS WITH SIGNAL 4 BECAUSE THE MEMORY ALLOCATION FOR THREADS ARE NOT ENOUGH. IY15121 GET SNAPSHOT FOR ALL DCS DB GIVES INCORRECT OUTPUT IY15123 PARSING OF COUNT (EXPRESSION) FAILS WITH COMPLEX EXPRESSIONS IY15135 KEY NOT FOUND ERROR (FFFF F92C) ON AN INDEX IN A 32K PAGE TBSP. IY15152 FAILED 'BACKUP DB ... ADSM ...' ARE NOT BEING CLEANED IN ADSM CAUSING 'DB2ADUTL' TO RETURN EXTRANEOUS RESULTS IY15189 USER WITH ONLY SELECT PRIVILEGES ON A VIEW IS ABLE TO UPDATE THE TABLE USING A CURSOR UPDATE ON THE ALIAS OF THE VIEW. IY15201 TABLESPACE ROLLFORWARD UNDO PHASE READS FROM DISK FOR EVERY LOG RECORD IY15209 SQL_INVALID_HANDLE ERROR IS RECEIVED WHEN SQLTABLES IS CALLED BEFORE SQLCOLUMNS. IY15250 AIX ONLY: DB2MEMDISCLAIM CAN CAUSE SORTHEAP ALLOCATION ERRORS, TRAPS, DEFUNCT DB2AGENTS DUE TO LEAKING VIRTUAL MEMORY. IY15287 DB2 MEMORY LEAK FOR UDF WITH CLOB PARAMETER WHERE UDF RETURNS AN ERROR IY15289 WRONG OR DIFFERENT RESULTS RETURNED BY SELECT ON VIEWS V7.1 ONLY IY15290 SQL0901 RETURN - SECTION NOT CLOSED. IY15367 USING SETASCIISTREAM METHOD IN JAVA IS ALWAYS TRANSLATING TO SQL_CLOB. IY15421 SUBSEQUENT PARAMETER BINDINGS FOR VARCHAR WITH JDBC ARE NOT HAVING THEIR COLDEF LENGTHS UPDATED CAUSING CLI0109E IY15423 ERRNO:0000 0009 DUMPED IN LOG DURING A SUCCESSFULL BACKUP. THIS APPEARED AFTER APPLYING FP6 IY15428 -10752 AS SQLCODE IN SQLCA ON BACKUP -> BACKUP EXISTS/VALID, BUT UPDATING HISTORY FILE WAS NOT, REPORTED AS FAILURE IY15448 CLI LAYER NOT RECOGNIZING 'I'(INCLUDE) RETURN FOR DT_SRCE_BEG IN SQLGETDATA. IY15592 WHERE CLAUSE RETURNS A WRONG OUTPUT IN FP6. (1=1 OR 1=2) AND (1= 1 OR (1=2 AND 2=2)) RETURNS FALSE. IY15629 INCORRECT FILE SIZE ESTIMATES FOR BACKUP TO ADSM/TSM IY15676 MULTITHREADING ENVIRONMENT CAUSES FORKED CHILD TO BE SPUN OFF IN TO MUTEX. IY15691 AFTER OS390 IS RECYCLED, CONNECTIONS TO IT RECEIVE SQL0902 UNTIL OF THE OLD CONNECTIONS IN THE CONNECTION POOL HAVE BEEN FAILED. IY15777 DB2 PANIC/SLEEP IN SQLDINVCURSORPOS IY15798 DB2DATASOURCE NOT HANDLING CONNECTIONS PROPERLY IY15827 PERFORMANCE WIZARD FROM CONTROL CENTER RECEIVES DBA1107 WHEN NLS AIX SERVER IS USED. IY15829 SIGNAL 11 IN SQLDADJUSTSEQDETPFAMOUNT IY15861 USEREXIT FAILED, BECAUSE DATABASE ACTIVATED AFTER OFFLINE BACKUP IY15881 SQL2032, RC=14 DURING RESTORING FROM ADSM. THE APPROPRIATE ERROR MESSAGE SHOULD BE SQL2033, RC=14. IY15913 CAPTURE FAILS - SQL2038 RC 32 IY15931 HASH_JOIN MEMORY ALLOCATION PROBLEM WHICH MARKS DB BAD. IY16012 GETDATE() RETURNS DIFFERENT VALUES IN APP VS NET IY16054 SIGNAL#11 IN SQLE_CHECK_EARLY_FETCH IY16241 TCP/IP PACKET SIZE IS 512 BYTES OF PAYLOAD- PERFORMANCE IMPACT IY16243 SIGNAL#11 IN SQLIFNXT IY16383 MISALIGNED DATA IN DB2 CAUSES HP TO TRAP IY16457 SIGNAL 11 IN SQLM_A_INIT IY16933 TABLESPACE RECOVERY FAILS/HANGS DURING FIRST ROLLFORWARD. JR14218 EVENT ANALYZER DOES NOT DISPLAY DYNAMIC SQL TEXT. JR14504 SQLFREESTMT TRAP DELETING CCB AFTER XA_END CALL JR14645 SQLSPECIALCOLUMNS FAILS WITH SQL0303N INSTEAD OF RETURNING NAME OF COLUMN DEFINED FOR THE PRIMARY KEY WHEN USING MS QUREY JR14781 SQL_ATTR_MAX_ROWS DOESN'T REDUCE THE RESULTSET FROM DB2/390 IF SQLEXTENDEDFETCH() IS USED TO RETRIEVE RESULTS. JR14791 SQLEXTENDEDFETCH - FETCH PRIOR - FAILS TO RETRIEVE ROW IN 1 ROW RESULT SET FOR A STATIC SCROLLABLE READ-ONLY SERVER-SIDE CURSOR. JR14807 DR. WATSON WHEN ISSUING DB2 FORCE APPLICATION ALL AGAINST DRDA-2 CONNECTIONS. JR14990 OUTPUT PARAMETERS NOT INITIALIZED TO NULL JR15084 SIGNAL #11 IN SQLNQ_MEMMGR::DESTROY. THIS APAR WILL FORCE A -901 TRACEBACK TO GATHER MORE INFO ON NEXT OCCURRANCE. JR15136 EXPORT TO LARGE IXF FROM V6 CLIENT TO V5.2 SERVER RESULTS IN MISSING ROWS JR15146 UTILITY TO SET THE PROPER UID/PWD CREDENTIALS FOR SATELLITEID IN THE SATADMIN.AUT FILE USING ORIGINAL SATELLITEID AS INPUT JR15159 EXCEPT ALL IN SQL STATEMENT RETURNS SQL0415 WITH SQLSTATE 42825. AND/OR INCORRECT RESULTS DURING SQL EXECUTION. JR15180 INCONSISTENT RESULTS WITH SNAPSHOT MONITOR ELEMENT APPL_ID_OLDEST_XACT JR15200 USE OF {?=CALL SPNAME(?)} SYNTAX MAY RESULT IN CLI0102 INVALID CONVERSION ERRORS JR15207 QUERY EXCEEDS SORTLIMIT AFTER INCREASE IN COLUMN NAME SIZE JR15212 CONNECTION.GETCATALOG() RETURNS AN EMPTY STRING INSTEAD OF NULL JR15214 EXECUTEBATCH() SHOULD RETURN INT0 IF BATCH IS EMPTY JR15215 BATCHUPDATEEXCEPTION SHOULD BE THROWN IN EXECUTEBATCH, NOT ADDBATCH IF THERE IS AN ERROR IN THE BATCH STATEMENT JR15216 JAVA APPLICATION TRAPS WHEN HDBC=0 JR15228 TRAP IN SQLJIDRD WHEN SQL_DISCONNECT_ABNORMAL RETURNED JR15238 INCONSISTENT RESYNC (OS/390 ABORTS, UDB COMMITS) JR15239 SETMAXFIELDSIZE(), SETMAXROWS(), SETQUERYTIMEOUT() SHOULD RETURN SQLEXCEPTION WHEN INPUT VALUE IS INVALID - JDBC JR15250 GETUDTS (JDBC) SHOULD RETURN AN EMPTY RESULTSET IF NOT SUPPORTED JR15251 STATEMENT RESULTSET SHOULD BE SET TO NULL AFTER REUSE JR15262 STATUS CHANGE TIME INCORRECTLY DISPLAYED IN CC JR15272 LARGE TRAP FILE WHEN FREEING INVALID MEMORY BLOCK (SQLOFMBLKEX) JR15285 GETTING AN ERROR PROGRAMMING THE XA_SWITCH. JR15290 ABEND IN DB2SYNCHSATTELITE* APIS IF CALLED WITHIN A .DLL JR15307 'DB2TASDM.DLL' IS NOT IN THE VERSION OS/2 6.1FP5/6 INSTALL. THIS IS REQUIRED FOR 'DB2 BACKUP ... ADSM ...' JR15308 SELECT WITH DISTINCT CLAUSE RETURNS INCORRECT RESULT. DUPLICATE ROWS RETURNED. JR15311 SQLNUMRESULTCOLS CALLED PRIOR TO SQLEXECUTE IN PREPAREDSTATEMENT OBJECT. JR15318 TRAP DURING COMPARE DATE STRING AND AN EMPTY VARCHAR STRING JR15352 SQLPRIMARYKEYS COULD RETURN NO KEYS IF SCHEMA IS NOT SPECIFIED AND USER LOGS IN WITH LOWERCASE USERID. JR15356 LIST RECOVERY HISTORY FAILS FROM COMMAND CENTER OR JOURNAL JR15360 TRAP IN SQLNO_FF_COMPUTE_LIKEPRD RUNNING QUERY USING PARAMETER MARKERS OR HOST VARIABLES. JR15362 WE REQUIRE 2ND TOKEN FROM OS/390 IN -440 ERROR RETURN JR15363 SQL1224N & TRAP IN SQLR_CREATE_TABLE_DDL DURING DROP VIEW/TABLE JR15408 DB2 STOP FORCE FROM CC HANGS AND GENERATES A TRAP JR15415 WHEN DEFERREDPREPARE=0 CLI0150E ERROR DRIVER NOT CAPABLE IS RETU RNED JR15416 PROBLEM WITH REDIRECTED RESTORE IN THE CONTROL CENTER. JR15425 LOAD WITH MODIFIED BY USEDEFAULTS CLAUSE CAUSES NULL FIELDS TO BE INCORRECTLY POPULATED WITH DATA. JR15428 MEMORY LEAK IN SEQUENCE: BEGIN CONTEXT, CONNECT TO DATABASE, DISCONNECT FROM DATABASE, END CONTEXT. JR15466 DATABASE COMES DOWN OR HANGS. TRAP FILE IS CREATED INDICATING EXCEPTION C0000005 IN FUNCTION SQLRR_DUMP_SECTION. JR15517 SQLUVINT() API STRUCTURE DB2_INFO FIELDS, VERSION RELEASE LEVEL AND OBJ_LIST FIELDS ERRONEOUSLY SET NULL JR15530 DATA INSERTED INTO LONG VARCHAR USING 'FOR BIT' COLUMN NO LONGER WORKING AT FP 2. JR15537 CODEPAGE 65535 PROBLEM PASSED BY MVS TO CLI (PADDING OCCURS IN OUTPUT) - NEEDS TO BE RECOGNIZED AS A VALID 4 BIT DATA CODEPAGE JR15539 CREATE TABLE LIKE AND CREATE VIEW SPORADICALLY FAILS WITH SQL0901 'WRONG HIERARCHY PACKED DESCRIPTOR' APAR fixes included in U473546 (Fixpak 6) APAR No. Abstract -------- -------------------------------------------------- GG03862 EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1 GG03928 SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY. GG03960 APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER GG04111 DIAGNOSTIC ENHANCEMENTS FOR APPLY GG04129 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS GG04131 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS GG04132 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS GG04133 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START GG04134 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START GG04135 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT GG04136 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT GG04138 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS GG04139 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS GG04140 SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY GG04142 APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER GG04144 DIAGNOSITC ENHANCEMENTS FOR APPLY GG04146 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS GG04147 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS GG04148 EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1 GG04150 APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH GG04151 APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH GG04152 APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY GG04153 APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY GG04154 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE GG04155 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE GG04156 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE GG04157 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE GG04158 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR GG04159 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR GG04160 APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG GG04161 APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG IY03296 SQL2154 ON ATTEMPTED TABLESPACE RESTORE. IY12052 SEVERE PERFORMANCE DEGRADATION WITH HIGH SYSTEM CPU AND CONTEXT SWITCHES. OCCURS AFTER PREDICTABLE DATABASE UPTIME OF 4-16 DAYS IY12074 GARBAGE COLLECTION IN HISTORY FILE AND NUM_DB_BACKUPS IY12218 APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH IY12275 CLI CONVERSION FROM CHARACTER TO NUMERIC TYPES MAY CAUSE SIGSEGV IF INVALID CHARS USED IY12396 POSSTR DOES NOT WORK WITH GROUP BY (SQL0119) IY12664 FILE SHARING VIOLATION ON SUN IY12726 DROPPING AN UNAVAILABLE TABLE ENDS WITH DIA3806C UNEXPECTED END OF FILE IY12821 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS IY13012 THE CUSTOMER UPGRADED TO FP4D FROM FP4 TO ADDRESS APAR IY09469. NOW THE CUSTOMER IS EXPERIENCING CLI0120E. IY13020 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED IY13054 MISLEADING ERROR REPORTING ( -901) FOR WRONG SCRIPT TRYING TO LINK UDF. IY13107 DB2 UDB - INDEX CORRUPTION PROBLEM CAUSES MISORDERING OF KEYS IY13331 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START IY13402 COPY_DAEMON ON DLFM SHOULD NOT COPY GARBAGE FILES (I.E. FILES TH AT GET LINKED AND UNLINKED WITHIN THE SAME TRANSACTION.) IY13410 IMPROPER HANDLING OF LOGS WITH RAW DEVICE AS ACTIVE LOG PATH. GET SQL4970N WHEN ISSUING A ROLL FORWARD. IY13473 BAD ACCESS PLAN CAN OCCUR IN EEE WITH DISTRIBUTION STATS IY13476 CRASH RECOVERY HANGS DURING UNDO PHASE IN INDEX MANAGER IY13617 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS IY13707 NEW PATCH2=41 IN CLI TO HELP USERS DO CASE INSENSITIVE QUERIES: VIEWS HAS TO BE CREATED ON A TABLE TO UPPER CASE EVERYTHING, THE IY13774 LOAD FAILURE (BUILD PHASE) MIGHT CAUSE SMP CORRUPTION IY13802 CONTROL CENTER DOES NOT ALLOW DEFINING A REPLICATION SUBSCRIPTION ON A VIEW REPLICATION SOURCE. IY13808 SIGNAL 11 TRAP IN SQLRR_DUMP_SECTION() DURING ERROR PROCESSING IY13841 APP. CURRENT CONNECTION CHANGED WHEN USING XA COMPLIANT TRANSACT -ION MANAGER WITH DB2 IY13951 MINMEMUSAGE KEYWORD CAUSES INCORRECT SQL_DBMS_NAME OUTPUT IN SQLGETINFO() IY13968 BAAN APPLICATION MAY EXPERIENCE -302 IY14081 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS IY14082 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS IY14090 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED IY14091 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED IY14094 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED IY14095 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS IY14096 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START IY14097 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START IY14098 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START IY14123 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS IY14125 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS IY14126 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS IY14127 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT IY14128 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT IY14129 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT IY14130 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT IY14145 SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY IY14146 SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY IY14147 SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY IY14148 SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY IY14149 APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER IY14150 APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER IY14151 APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER IY14153 APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER IY14155 DIAGNOSITC ENHANCEMENTS FOR APPLY IY14156 DIAGNOSITC ENHANCEMENTS FOR APPLY IY14158 DIAGNOSITC ENHANCEMENTS FOR APPLY IY14159 DIAGNOSITC ENHANCEMENTS FOR APPLY IY14160 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS IY14161 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS IY14162 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS IY14163 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS IY14165 EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1 IY14166 EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1 IY14167 EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1 IY14168 EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1 IY14170 APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH IY14171 APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH IY14172 APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH IY14173 APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY IY14174 APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY IY14175 APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY IY14176 APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY IY14177 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE IY14178 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE IY14179 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE IY14180 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE IY14182 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE IY14183 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE IY14184 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE IY14185 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE IY14186 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR IY14187 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR IY14188 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR IY14189 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR IY14190 APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG IY14191 APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG IY14192 APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG IY14193 APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG JR15040 QUERY RE-WRITE SHOULD REMOVE FALSE PREDICATES (EG. 1=0) FOR THE OPTIMIZER. JR15042 CODEPAGE V5.2 IN BACKUP IMAGE USES CODEPAGE 850 INSTEAD OF CODES ET. V6&7 WILL NOT READ THIS JR15073 EXCEPTION 5 TRAP DURING STAR JOIN PLANNING JR15081 CLI COMMIT BETWEEN PREPARE AND DESCRIBE MAY CAUSE CLI0125E FUNCTION SEQUENCE ERROR JR15082 CUS ATTEMPTS LARGE LOAD AND FAILS WHEN INDEX REBUILD. JR15158 DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE JR15210 -902 ON A DESCRIBE OR PREPARE PQ38000 APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY PQ39542 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE PQ40301 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE PQ40392 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR PQ41610 APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG PQ41936 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT APAR fixes included in U472728b (Fixpak 5b) APAR No. Abstract -------- -------------------------------------------------- IY09961 QUERY REWRITE DOESN'T PUSH DOWN PREDICATE INTO COMMON SUBESPRESS ION IY11081 DATABASE GETS MARKED AS BAD AFTER FCM ERRORS FFFFFC7F IN DB2DIAG.LOG FILE. EVENT MONITOR RESOURCE COULD NOT BE OBTAINED. IY11648 MISLEADING ERROR MESSAGE IN DB2DIAG.LOG FOR QUIESCE RESET FOR A TABLE FROM A NODE WHERE THE TABLE WAS NOT DEFINED. IY12165 CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N IN FP4E. IY12299 DB2ADUTL TO RECOGNIZE ALL TYPES OF FS_TYPE AT QUERY FOR BACKUP I MAGES IY12642 LOAD DOES NOT CHECK PARTITIONING KEY FOR EXCEPTION TABLE IY13027 A BUG IN 'DLFM RETRIEVE' TOOL, WHEN THE ARCHIVE SERVER IS ADSM. FILES EXIST IN THE ADSM SERVER BUT REPORT AS E2 (INSTEAD OF E1) IY13171 DATABASE MIGRATION FROM V5 TO V6 FAILS WITH SQL0025W IY13252 DB2DCLGN COMMAND WITH A DECIMAL RESULT IN INCORRECT OUTPUT. IY13327 DLFM RETRIEVE DOES NOT TAKE ANY PARAMETER IY13329 'O' OPTION IN DLFM RETRIEVE DOES NOT WORK IY13330 NO MESSAGE IS PRINTED INTO THE DB2DIAG.LOG FOR DLFMO_LOG IY13466 SQL0198N - DESCRIBING STORED PROCEDURES WITH LONG NAMES JR15008 SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR JR15014 DEFER CONVERSION OF IN SUBQUERY TO JOIN AFTER SUBQUERY PUSHDOWN THROUGH THE OUTER JOIN. JR15025 DR.WATSON IN DB2SYS.DLL WHEN LOGING OFF NT (MTS AND DTC) JR15046 RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC APAR fixes included in U472728a (Fixpak 5a) APAR No. Abstract -------- -------------------------------------------------- IC27213 WRONG TIMESTAMP ON SNAPSHOT OUTPUT FOR DB2 EE 6.1 UNDER LINUX IY06938 IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6 IY10484 LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973. IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY11218 INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES IY11353 SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM IY11436 DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY PROCESSING. IY11499 DB2 UDB - CRASH RECOVERY FAILS WITH AN SQL1042 ERROR. MESSAGES IN THE DB2DIAG.LOG WE FAILED WHEN TRYING TO DROP A BUFFERPOOL. IY11819 SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER. IY11865 SQL0902N ON STARTING PIPE EVENT MONITOR IY11908 DB2 CALLS USER EXIT WITH THE WRONG GID IY11932 QUERY PATROLLER DOES NOT WORK PROPERLY WHEN LANGUAGE WAS SELECTE D LANG=US_ENG. IY11945 APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE ALLOCATED TO PROCESS. IY11990 ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC. IY12050 SQL2741N WHEN LOADING DATA AND SPECIFYING IMPLIEDDECIMAL AND PACKEDDECIMAL MODIFIERS IY12273 LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN CANCELLED IY12419 BACKUP OF DATABASE CONTAINING DATALINK COLUMNS FAILS WITH SQL2424N, YET COPY DAEMON SUCCESSFULLY BACKED UP FILES. IY12536 MONITOR STATE DOES NOT RESET APPLICATION STATE ONCE COMPLETED IY12545 SQL0104N RETURNED WHEN RUNNING DB2BATCH IN CLI MODE. HOWEVER, RE SULT SET IS STILL CORRECT. IY12725 DB2 UDB - CREATE INDEX CAUSING DATABASE TO COME DOWN. THE DB2DIAG.LOG FILE INDICATES THAT AN OBJECT ID IS ALREADY IN USE. IY12751 STMT.GETSTRING() RETURNING NULL ON IN_OUT PARAMETER IY12777 WHEN MIGRATING FROM V5 TO V7, THE FIRST 2,3,4 KEYCARDS VALUES OF THE INDEX FROM THE ACCESS PLAN IS NOT REFLECTED IN SYSCAT.INDEX IY12800 CAN'T RUN DB2GOV WITH SYSADMIN GROUP USER THAT IS NOT DB2 INSTA NCE OWNER. IY12946 CLI ATTEMPTS TO CLOSE A CURSOR THORUGH THE CURSOR CONTROL BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP. IY12948 VISUAL EXPLAIN DISPLAYS INCORRECT '(DEFAULT)' KEYWORD UNDER THE EXPLAINED COLUMN IN THE TABLE STATISTICS WINDOW. IY12968 JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW IY13014 SIGNAL #4 #11 USING HOP DRIVER IY13019 TRAP (SIG 11) IN SQLNO_UNION_SETSN IY13033 GOV1027 WHEN INTERVAL ABOVE 300 SECONDS JR14390 AFTER BACKUP TO THE DISK IN ZIP DRIVE THROUGH CONTROL CENTER,DB2 DOESN'T RELEASE FILE HANDLER OF ZIP DRIVE JR14749 SQL0291 TRYING TO ACCESS TEMPORARY TABLESPACE WHEN THERE ARE TEMP TABLEPSACES OF DIFFERENT PAGESIZES:'NO TEMP AVAILABLE' JR14809 NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER. JR14815 DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED. JR14860 JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN JR14892 CHANGE WIN32 API CALL DUE TO LONG CONNECT DELAYS WHEN THERE ARE DISCONNECTED MAPPED NETWORK DRIVES: NT TERMINAL SERVER ONLY. JR14894 SQL0900 DATABASE CRASHES ON QUERY WITH RID SCANS AND LIST PREFETCHING IF BINSORT ENABLED JR14895 INCORRECT DISPLAY OF DECIMAL SEPARATOR: DISPLAYS ',' INSTEAD OF '.' IN CC FOR BOTH V6.1 AND V7.1 JR14897 JDBC TIMING HOLE MAY ALLOW GARBAGE COLLECTOR TO CLOSE OBJECTS WE HOLD REFERENCE TO JR14905 DB2 CC - CREATING INDEXES WITH DUPLICATE NAMES WHEN DEFINING MUL TIPLE TABLES AS REPLICATION SOURCE JR14921 INSERT INTO REAL COLUMN ON DB2/390 DATABASE FAILS JR14924 INCORRECT CALL TO HOST TO RETRIEVE CURRENT TIMEZONE. JR14928 SQL1092 ON DROP DB ON CLIENT DESPITE CATALOG_NOAUTH JR14929 TABLE UDFS WITH DECIMAL PARAMETERS SHOW LENGTH AND SCALE OF 0 IN SYSCAT.FUNCPARMS JR14931 EVENT ANALYZER (CONTROL CENTER) IS TOO SLOW LOADING AND SORTING EVENT FILES JR14996 CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E APAR fixes included in U472728 (Fixpak 5) APAR No. Abstract -------- -------------------------------------------------- GG03736 ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS. GG03752 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH GG04079 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS GG04084 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH GG04085 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS GG04086 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. GG04087 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. GG04088 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 GG04089 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 GG04091 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE GG04092 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE GG04093 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES GG04094 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES GG04095 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS GG04096 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS GG04097 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY GG04098 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY GG04099 ASNAPPLY FAILS WITH CORE GG04101 CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR GG04102 CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR GG04103 DURING CAPTURE PROCESSING THE ASNPATH SYSTEM VARIABLE IS BEING MISREAD GG04104 CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE GG04105 CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE GG04106 CANNOT STOP CAPTURE WITH ASNCMD STOP COMMAND. GG04109 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ GG04112 ASNAPPLY FAILS WITH CORE GG04114 ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS. GG04115 ASNAPPLY FAILS WITH CORE GG04116 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. GG04118 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. GG04119 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) GG04120 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) GG04122 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ GG04123 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED GG04124 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED GG04126 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. GG04127 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. IY06938 IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6 IY09068 EVENT ANALYSER INFORMATION FROM AIX WILL NOT DISPLAY ON NT IY09645 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) IY09646 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE IY10382 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES IY10484 LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973. IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY10644 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS IY10869 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH IY10870 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH IY10871 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH IY10872 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH (Linux). IY10873 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS IY10874 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS IY10875 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS (Linux). IY10876 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS IY10945 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. IY10946 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. IY10947 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL (Linux). IY10948 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. IY10955 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY11011 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 IY11013 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 IY11014 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 (Linux). IY11015 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 IY11016 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE IY11017 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE (Linux). IY11018 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE IY11019 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES IY11020 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES (Linux). IY11021 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES IY11022 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS IY11023 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS (Linux). IY11024 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS IY11025 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY11027 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY (Linux). IY11028 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY11097 NULL BUFFER FROM FCM PASSED TO SQLKQ_DETACH_BUFFER LEADING TO HANG ON SMP OR MPP MACHINES. IY11116 DB2ATLD HANGS WHEN THE FILE_TRANSFER_CMDFAILS WITH A NON-ZERO R ETURN CODE. IY11136 NO TEMP AVAILABLE ERROR IN DB2DIAG.LOG DURING ON-LINE BACKUP. SQLB_BACKUP_IN_PROGRESS ON TEMPTABLESPACE FOR A SHORT PERIOD. IY11161 FAILURE TO FIND A LOCK WITHIN LOCK TABLE, SQLPLUPDATETRANENTRY REPORTS FFFFF51D AT PROBE POINT 5 IY11218 INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES IY11267 QUERY_HEAP TOO SMALL MAY CAUSE -1131 ON CALL TO STORED PROCEDURE IY11323 CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR IY11324 CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR IY11325 CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR (Linux). IY11326 CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR IY11327 CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE IY11328 CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE IY11329 CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE (Linux). IY11330 CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE IY11353 SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM IY11386 APAR IY06317 MAY RESULT IN POOR COST ESTIMATE OF MERGE JOIN IY11436 DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY PROCESSING. IY11527 DB2 UDB - SQL0901 ERROR WITH MESSAGE 'NON-PIPED PARALLEL SORT ATTEMPTED' IN DB2DIAG.LOG. IY11595 ALLOW DB2 INTERNAL ROLLBACK IN STORED PROCEDURE AFTER DEADLOCK IY11795 SQL1224 INSTANCE CRASH ON CLOSE AFTER A FAILED BIND TRAP IS IN SQLRICLS_COMPLEX IY11819 SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER. IY11901 TRAP IN SQLNO_PROJECT_QUN WHEN RUNNING A QUERY IY11940 INDEX CORRUPTION WHEREBY DART ANALYSIS REPORTS 'DUPLICATE FOUND' OR 'INDEX KEYS MISORDERED' OR 'BPS HEADER PAGE NUMBER INCORRECT' IY11945 APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE ALLOCATED TO PROCESS. IY11990 ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC. IY12016 SQL0901N ON DYNAMIC SQL 'SQLNO_CRULE_SAVE_PLANS 100:RC(0)' IY12042 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED IY12068 MULTIPLE CONCURRENT IMPORT COMMANDS FOR DIFFERENT TABLE GIVES SQL3188N. IY12125 OWNER OPTION ON BIND MAY CAUSE INCORRECT AUTHS TO BE USED IY12126 TABLESPACES OF 18 CHAR LENGTH NAMES MIGHT NOT BE BACKED UP IY12168 INSTANCE MIGRATION FAILS FROM V5.X TO V6.1 IY12271 DB2CKMIG.BND COULD NOT BE OPEND AT DB2CKMIG COMMAND IY12349 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. IY12416 -901 DUE TO INCORRECTLY SORTED INPUT STREAM OR INCORRECT ORDER BY QUERY RESULTS, MISORDERED KEYS IN INDEX LEAD TO DB MARKED BAD IY12513 ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS. IY12514 ASNAPPLY FAILS WITH CORE IY12515 ASNAPPLY FAILS WITH CORE IY12516 ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS. IY12517 ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS (linux). IY12518 ASNAPPLY FAILS WITH CORE (Linux). IY12520 ASNAPPLY FAILS WITH CORE IY12521 ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS. IY12554 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. IY12555 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATE WITH NO CHANGES (Linux). IY12558 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. IY12559 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) IY12560 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (Linux). IY12561 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) IY12562 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ IY12563 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ IY12564 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS (Linux). IY12565 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ IY12566 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED IY12567 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED IY12568 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED (Linux). IY12569 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. IY12570 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. IY12571 CAPTURE DOES NOT HANDLE LARGE TABLE ID (Linux). IY12572 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. IY12599 DB2 UDB - LOAD AGENTS CANNOT BE FORCED OFF AFTER LOAD IS TERMINATED. SEE ALSO APAR IY04375 FOR DETAILS. IY12609 DB2 UDB - SQL1042 ERROR WHEN MAXAGENTS LIMIT HAS BEEN REACHED AND DB2 REQUIRES AN ADDITIONAL AGENT. JR13927 IMPLEMENT NEW BIDI LAYOUT TRANSFORMATION ROUTINE WITH MORE STRIN GENT ERROR CHECKING, MEMORY ALLOC, AND BIDI CCSID STRING TYPES. JR14166 NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1 JR14791 SQLEXTENDEDFETCH - FETCH PRIOR - FAILS TO RETRIEVE ROW IN 1 ROW RESULT SET FOR A STATIC SCROLLABLE READ-ONLY SERVER-SIDE CURSOR. JR14809 NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER. JR14811 SQL0104 GENERATED WHEN ISSUING A VALID ROLLBACK COMMAND FROM THE CLP JR14815 DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED. JR14844 USERS WHICH BELONG TO THE SYSADM_GROUP DEFINED IN THE DBM CFG CA NNOT ISSUE A DB2STOP, WHETHER DOMAIN OR LOCAL USERS JR14860 JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN JR14897 JDBC TIMING HOLE MAY ALLOW GARBAGE COLLECTOR TO CLOSE OBJECTS WE HOLD REFERENCE TO JR14921 INSERT INTO REAL COLUMN ON DB2/390 DATABASE FAILS JR14924 INCORRECT CALL TO HOST TO RETRIEVE CURRENT TIMEZONE. JR14926 TRAP IN SQLJIFSR.C APAR fixes included in U471242e (Fixpak 4e) APAR No. Abstract -------- -------------------------------------------------- IY10009 CONTROL CENTER(FOR V6) FREEZES WHEN CHANGE BUTTON FOR DB GROUPS UNDER USER AND GROUP OBJECTS IS CHOSEN IY10803 LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N. IY11116 DB2ATLD HANGS WHEN THE FILE_TRANSFER_CMDFAILS WITH A NON-ZERO R ETURN CODE. IY11126 THE EVENT MONITOR'S TRANACTION EVENT OUTPUT HAS A LOCK WAIT TIME GREATER THAN THE ELAPSED TIME FROM THE START AND STOP TIMESTAMPS IY11218 INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES IY11353 SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM IY11377 DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC. IY11466 DEADLOCK CAUSED BY NEXT KEY LOCKING IN CATALOGS IY11600 RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION. IY11717 INSTANCE CRASH IN SQLM_GENERIC_CONVERT. IY11766 ALTER TABLE REFERENCES CLAUSE DOES NOT ACCEPT DIFFERENT COLUMN ORDERS IN FOREIGN KEY DEFINITION IY11785 DB2_ALL WITH ':' OPTION ON SUN RETURNS STRANGE MESSAGES IY11990 ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC. IY12029 DB2ATLD FAILED WITH SQL1403N USERNAME AND/OR PASSWORD SUPPLIED INCORRECT-> TRACE SHOWS SQLOPDBISNODEPARTOFCLUSTER()RC=1 FAILED JR14403 THE RANGE SHOWN FOR LOGFILSIZ IN THE CC HINT IS WRONG FOR NT JR14743 DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM. JR14758 WITH SPECIFIC SETTINGS EVERY COMMAND ISSUED FROM COMMAND CENTER ON NT/UDB EE V5.2/FIXPACK 12 RECEIVES DB21005E ERROR. JR14815 DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED. JR14841 AN SQL0525N ERROR OCCURS WHEN DB2BATCH IS EXECUTED AGAINST AN OS 390 DATABASE. JR14846 CONTROL CENTER GENERATES INVALID WHEN DEFINING REPLICATION SOURCES AND SUBSCRIPTIONS IF ASN.IBMSNAP_CCPPARMS IS EMPTY JR14854 NT: CONNECT HANGS RESULTING FROM LATCH ON GLOBAL INSTANCE QUEUE APAR fixes included in U471242d (Fixpak 4d) APAR No. Abstract -------- -------------------------------------------------- IY09174 MIGRATION FAILS DUE TO DISK FULL IY09469 SELECTING TABLES FROM OS/390 WHICH CONTAIN LOBS CAUSES SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT. IY10901 IMPORT FROM PIPE ASC BREAKS AT END OF BUFFER. ALTHOUGH IMPORT COMPLETES SUCCESSFULLY, ALL DATA IS NOT IMPORTED. IY11063 AN APPLICATION HANGS (AN AGENT STUCK IN MONITOR CODE) IY11074 SQL0101 ERROR WHEN RUNNING A QUERY DUE TO MEMORY FRAGMENTATION PROBLEM AND LOW 'ULIMIT -D' VALUE. IY11218 INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES IY11343 BAD PERFORMANCE WHEN A LOB IS PASSED INTO A UDF IY11501 DB2IUPDT SILENTLY CALLS DLFMUPDT IF IT IS A DLFM INSTANCE IY11502 SIG11 TRAP IN SQLOCSEMREMOVE AFTER A BACKUP FAILURE IY11595 ALLOW DB2 INTERNAL ROLLBACK IN STORED PROCEDURE AFTER DEADLOCK IY11620 DB2 UDB - PERFORMANCE DEGRADATION DUE TO OPTIMIZER INCORRECTLY ESTIMATING THE CARDINALITY OF AN INDEX SCAN IY11625 CORRUPTED UNIQUE INDEX AND DUPLICATE KEYS IY11629 I/O ERROR DURING MONITOR PROCESSING CAUSES PANIC IN REMOVE_ME FN IY12356 BACKUP TO ADSM WILL FAIL WITH RETURN CODE 11 OR 157 JR14403 THE RANGE SHOWN FOR LOGFILSIZ IN THE CC HINT IS WRONG FOR NT JR14646 ADDING XBSA SUPPORT TO DB2 NT FOR SAP JR14647 JAVA CC DOES NOT ALLOW NUM_POOLAGENTS TO BE SET TO 0. JR14649 BACKUP IMAGE PATH IS CASE SENSITIVE ON INTEL - SQL2542N AT RESTORE JR14723 SQL1112 -NOT ENOUGH SYSTEM RESOURCES WHEN TRYING TO SCHEDULE ~100 JOBS FROM THE SCRIPT CENTER JR14724 IMPLEMENT MULTIPLE SESSIONS USING ADSM IN V6.1 ON NT AND OS2 JR14757 BINDING THROUGH THE CCA TO VM HANGS IN CLP PACKAGES JR14777 QUERY TRAPS SERVER. TRAPPING FUNCTION IS SQLKT_PACK_TUPLE. JR14793 NT PERFORMANCE MONITOR HANGS WHILE MONITORING DCS APPLICATIONS JR14795 DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442 JR14812 SPB FAILURE IN LIBJITC.DLL. NEED TO INITIALIZE WITH NOJIT OPTION. JR14847 CONTROL CENTER FOR V6 DOES NOT INCLUDE DAS - ADMIN SERVER - CANNOT BE USED FOR REPLICATION ADMINISTRATION ON MVS APAR fixes included in U471242c (Fixpak 4c) APAR No. Abstract -------- -------------------------------------------------- IY10585 SQL0501 AFTER SQL0437W IN CLI APPLICATION. RETRY LOGIC FAULT. IY10794 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY IY11097 NULL BUFFER FROM FCM PASSED TO SQLKQ_DETACH_BUFFER LEADING TO HANG ON SMP OR MPP MACHINES. IY11141 DB2JD TERMINATES IF IT CAN'T SPAWN ANY PROCESSES. IY11218 INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES IY11255 DB2LOOK -U OPTION RETURNS TABLES WITH GIVEN CREATORID AS SCHEMA INSTEAD OF TABLES THAT WERE CREATED BY THAT CREATORID IY11375 USEREXIT IS NOT BEING INVOKED EVEN THOUGH IT HAS BEEN SET UP PROPERLY. IY11443 RECONCILE RETURNS SQL2554N RC=5. JR13044 MS INTERDEV RECEIVES CLI0002W AFTER FETCH FROM SQLPROCEDURECOLUM NS() JR14600 V6 STORED PROCEDURE BUILDER CAN'T CONNECT V7 DB2 UDB JR14889 CRASH WITH SQLCREATEDAT (PROBE: 100) MESSAGES IN THE DB2DIAG.LOG INDICATING THAT THE DAT OBJECT LIFE LSN IS NULL. APAR fixes included in U471242b (Fixpak 4b) APAR No. Abstract -------- -------------------------------------------------- IY09385 SQL1042 DURING CRASH RECOVERY DUE TO INDEX MANAGER PROGRAMMING ERROR (DIA3875C). IY10199 LEFT OR FULL OUTER JOIN PROBLEM WITH OPTIMIZER IY10803 LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N. IY10839 PAGE BOUNDARY CACULATION ERROR CAUSES SQLOMMAPWRITE ERRNO EFBIG & SQL0968C FILE SYSTEM FULL IY10861 DATABASEMETADATA.GETCOLUMNS IS NOT HANDLING SCHEMAPATTERN='' CORRECTLY. IY10902 CREATE VIEW WITH SCHEMA NAME TOO LONG GIVES SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR. IY11162 SQL03181W ON LOAD WITH A SPECIFIC IXF FILE, BUT NOT ON IMPORT IY11169 IN DB2 CC CONNECTION IS NOT BEING REUSED/RELEASED PROPERLY. IY11182 SIGNAL 11 ON SQLULTERMINATE AFTER SQL2043 DURING AUTOLOAD IY11211 SILENT INSTALL DOESN'T POPULATE WIN REGISTRY PROPERLY IY11217 SQJ0001W WITH SQL0104N WHEN ISSUING DB2PROFC ON SQLJ APPLICATION IY11275 MULTISITE UPDATE HANGS WITH CC IY11283 ISSUING DB2IUPDT OVERWRITES THE DB2AUDIT.CFG WITH THE DEFAULT CONFIGURATION. JR14068 PCOMM ALLOWS '#' IN THE PARTNER LU NAME BUT DOES NOT ALLOW '#' I N THE SYM_DEST_NAME. JR14234 DB2 UDB - INSTANCE CRASHES WITH A SIGNAL 11 TRAP IN FUNCTION SQLEDATABASEBAD WHEN DB2 ATTEMPTS TO MARK THE DATABASE AS BAD. JR14508 V6.1 CLIENTS SHOW WRONG SCHEMA NAMES FOR ALIASES CREATED AGAINST DB(FOR V5.2/V6.1) JR14595 SQLDRIVERCONNECT IS SIGNIFIGANTLY SLOWER IN DB2 V6.1 COMPARED TO V5.2 JR14600 V6 STORED PROCEDURE BUILDER CAN'T CONNECT V7 DB2 UDB JR14605 DIA3419C--NETBIOS NOT STARTED SUCCESSFULLY RC 3 JR14646 ADDING XBSA SUPPORT TO DB2 NT FOR SAP JR14737 THE CLIENT IS INCORRECTLY CREATING MULTIPLE SNA CONVERSATIONS USING THE SAME LUWID. THIS IS CAUSING DB2 OS 390 TO ABEND. JR14740 %PATH%:%PATH%: GETS ADDED TO THE PATH EACH TIME DB2 IS INSTALLED ON WIN 98 (SAME THING HAPPENS WITH CLASSPATH) 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 APAR fixes included in U471242a (Fixpak 4a) APAR No. Abstract -------- -------------------------------------------------- IY03947 DB2DART WITH /DP OPTION ABORTS WHEN DB2_STRIPED_CONTAINERS IS USED. IY06572 SEGMENTATION FAULT WHEN BINDING A SECOND TIME TO A CURSOR IY07623 SIGNAL #11 TRAP IN SQLORQUE2() IY08453 SQL1227 RC 6 WHEN ATTEMPTING TO UPDATE STATISTICS WITH TABLE CARDINALITY OF 0 WHEN STATISTICS ALREADY EXIST IY09151 LOAD REPLACE OF AN EMPTY FILE (IXF) DOES NOT REPLACE EXISTING ROWS IN THE TABLE THE EMPTY FILE IS BEING LOADED INTO. IY09439 SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR. IY09663 DB2 CRASHED WITH ERROR DIA3816C CREATED BY SQM_EVMON_OSTREAM() SIG 11 IY09764 TWO QUERIES DIFFERING ONLY IN THE ORDER OF THE PREDICATES, RETURN DIFFERENT RESULTS. IY09856 SELECT COUNT(*) FROM VIEW RETURNS INCORRECT 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 IY10047 DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI IY10080 APAR IY07376 (DEFECT 138307) ADDED A LIBPATH SECTION YO DB2PROFI LE RESULTING SOME C PROGRAMS TO FAIL IY10165 SQL0910N - REASON 'COLUMN NUMBER OUT OF RANGE' WHEN SQL QUERY CO NTAINS MULTIPLE DISTINCT CLAUSE. IY10183 TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4. 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. IY10371 DB2AUDIT EXTRACT OUTPUT SHOW UNREADABLE CHARACTERS IN THE PACKAG E SCHEMA FIELD OF CHECKING EVENT. 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 IY10499 OPTLEVEL 5 PLAN WORSE THAN OPTLEVEL 3 PLAN IY10562 DB2 UDB INTRA_PARALLEL ON - QUERY RETURNS AN SQL0955 ERROR AFTER WHICH ALL QUERIES WHICH REQUIRE SHARED SORT MEMORY FAIL. IY10579 DB2 UDB - SIGNAL 11 TRAP IN FUNCTION SQLDHASHZVALUE WHEN RUNNING REORGCHK ON VARIOUS TABLES. 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 MEMORY CORRUPTION CAUSED BY TQS - DIRTY PARTIAL TUPLE SAVED FLG IY10901 IMPORT FROM PIPE ASC BREAKS AT END OF BUFFER. ALTHOUGH IMPORT COMPLETES SUCCESSFULLY, ALL DATA IS NOT IMPORTED. IY11030 SQL30083 RC 24 WHEN TRYING TO CHANGE A PASSWORD LOCALLY FROM THE DB2 CLP USING A VALID PASSWORD JR13854 LANGUAGE SETTING DOES NOT WORK FOR THE STORED PROCEDURE BUILDER (SPB) ENVIRONMENT JR14191 KEYSET PARSER RETURN CODE=107 WHEN TRYING TO USE KEYSET CURSORS ADO W/ DB2 CONNECT V6.1. JR14417 CPU TIME INCORRECTLY CALCULATED. RESULT IS TOO BIG. JR14497 DB2 CONNECT TRAPS IN SQLJDRD1 ALONG WITH AN ACCESS VIOLATION DR. WATSON ERROR ON NT JR14517 SQL1092 WHEN CREATING DB ON REMOTE SERVER FROM CLIENT. CATALOG_NOAUTH IS IGNORED. JR14521 JAVA COMMAND CENTER RESULTS GREYED OUT WHEN SCROLLING. JR14541 TRAP IN SQLE_DB2RA_AS_DB_OPEN WHEN FORCING AN APPLICATION. OCCURS WITH PARALLEL QUERY USING CLI JR14545 SQL2034N (ADDRESS OF THE 'PASSWORD' PARAMETER NOT VALID) WHEN ATTEMPTING TO DO AN OFFLINE BACK FROM CLIENT CLP OR CC JR14546 CC FOR EEE/NT RETURNS SQL4414 ON NON-INSTANCE OWNNING MACHINE JR14550 JAVA COMMAND CENTER WIN9X RESULTS > 4682 CHAR DISPLAY PROBLEM JR14592 CONNECT TO DATABASE ON NT HANGS IN STRICMP() C LIBRARY CALL JR14606 EXPORT OF DEL MODIFIED BY DECPT SUBSTITUTES PERIOD FOR ANY CHARACTER FOR ITALIAN VERSION DB2 ON NT JR14623 PERF MONITOR (ACCESSED THROUGH CC IN V6) DOES NOT LIST ANY VALUES. 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 APAR fixes included in U471242 (Fixpak 4) APAR No. Abstract -------- -------------------------------------------------- GG04010 LONG VARCHAR FIELDS CAN BECOME OVERLAID GG04017 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE GG04023 LONG VARCHAR FIELDS CAN BECOME OVERLAID GG04024 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS GG04025 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) GG04026 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED GG04027 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE GG04028 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. GG04031 INSERTS ARE MISSED BY CAPTURE GG04032 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE GG04033 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS GG04034 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) GG04035 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED GG04036 INSERTS ARE MISSED BY CAPTURE GG04038 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED GG04040 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS GG04041 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN GG04042 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE GG04043 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER GG04046 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. GG04048 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION GG04049 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION GG04051 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED GG04052 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE GG04053 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. GG04054 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. GG04055 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. GG04056 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. GG04057 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE GG04058 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. GG04060 ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED GG04061 ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED GG04062 'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE GG04063 'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE GG04064 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED GG04065 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED GG04066 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS GG04067 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN GG04068 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER GG04069 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG GG04070 CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE GG04071 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T GG04072 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T GG04073 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 GG04074 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 GG04075 CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE GG04076 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY04440 BUFFERED INSERT ON LOG FULL CONDITION PRODUCES INCONSISTENT RESULTS. IY06002 MODIFY PROGRAM TYPE MAIN SP ARGUMENT INDEXES TO MATCH OS/390 IY07624 PRUNE LOGFILE COMMAND RETURNS SQL1651N IF NOT CONNECT TO DATABAS E FIRST. SHOULD GIVE SQL1024 INSTEAD. IY08076 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY08077 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY08085 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY08124 INSERTS ARE MISSED BY CAPTURE IY08454 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08455 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08456 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08457 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY08458 INSERTS ARE MISSED BY CAPTURE IY08459 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08460 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08461 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08462 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY08463 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08464 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08465 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08466 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY08467 INSERTS ARE MISSED BY CAPTURE IY08468 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08469 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08470 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08472 INSERTS ARE MISSED BY CAPTURE IY08684 SQL0107 RETURNED BY CLI DRIVER ON SQLFETCH CALL TO DB2 MVS. IY08935 'ASNCMD STOP' DOES NOT STOP CAPTURE IY08937 ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED IY08938 'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE IY09042 REPLICATION SETTINGS IN CC DOES NOT ALLOW AFTER CAPTURE. IY09251 DB2 EEE V6 CRASH RECOVERY FAILS, SQL1042 IY09262 CHANGE THE DEFAULT SQL_CONCURRENCY AS READ_ONLY BASED ON THE CLAUSES PRESENT IN THE STATEMENT. IY09280 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY09615 CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE IY09616 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T IY09633 'ASNCMD STOP' RETURNS ERRNO 2 IY09706 TRAP IN SQLCCGETATTR USING CONNECTION POOLING IY09751 DATABASE CRASH DUE TO TIMING HOLE IN CREATE TABLE ROLLBACK IY09756 NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS. REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED. IY09788 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 IY09855 CLI ENTRY CODE TRAPS TRYING TO FREE A CONNECTION THAT NO LONGER EXISTS IY09939 ERRNO IS NOT RESET BEFORE CLI TYPE CONVERSION IY10047 DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI IY10086 SQL0100W FROM SQLJ STORED PROC ON UPDATE OF NON-EXISTING ROW IY10089 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. IY10090 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. IY10092 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. IY10093 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION IY10094 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION IY10095 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION IY10096 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION IY10118 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED IY10119 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED IY10120 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED IY10121 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED IY10137 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE IY10138 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE IY10139 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE IY10140 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE IY10144 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. IY10145 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. IY10146 CMPL ADDITIONAL BLANK LINE ADDED IN THE PSEUDO ASSEMBLER OUTPUT OF THE COMPILER USING REPLACE AND COPY (ALSO IN SOURCE LISTING) IY10147 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. IY10148 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. IY10149 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. IY10150 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. IY10151 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. IY10167 THE SQLDA IS INITIALIZED WITHOUT FIRST CHECKING THE SIZE OF THE RESULT SET. IF IT CONTAINS MORE THAN 255 COL. WE GET A CORE DUMP IY10181 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY10182 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY10183 TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4. IY10212 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE IY10213 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE IY10214 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE IY10215 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE IY10216 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. IY10218 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. IY10219 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. IY10220 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. IY10221 'ASNCMD STOP' DOES NOT STOP CAPTURE IY10222 "ASNCMD STOP" DOES NOT STOP CAPTURE IY10223 'ASNCMD STOP' DOES NOT STOP CAPTURE IY10224 ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED IY10225 ASNCCP DOES NOT TERMINATE WHEN "WARMNS" IS A STARTUP OPTION AND A COLD START IS NEEDED IY10226 ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED IY10227 'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE IY10228 "ASNCMD A STOP" IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE IY10229 'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE IY10244 SELECT QUERY USING REVERSE INDEX SCAN FAILED WITH SQL0900 AFTER IT RAN FOR 30 MINS OR SO. IY10256 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED IY10257 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED IY10258 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED IY10259 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED IY10309 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS IY10310 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN IY10311 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER IY10313 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS IY10314 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN IY10315 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER IY10317 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY10338 CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE IY10340 'ASNCMD STOP' RETURNS ERRNO 2 IY10341 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 IY10343 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS IY10344 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN IY10345 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER IY10346 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY10347 CAPTURE HANGS/RETURNS SQL0204 WHEN "SCHEMA"."TABLE" HAS A SPACE IY10348 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T IY10349 "ASNCMD STOP", RETURNS ERRNO 2 IY10350 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 IY10351 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS IY10352 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN IY10353 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER IY10355 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY10356 CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE IY10357 'ASNCMD STOP' RETURNS ERRNO 2 IY10359 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T IY10360 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 IY10491 SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1 IY10500 INVALID CONVERSION/TYPE FOR DOUBLE WITH STORED PROC IN DB2/MVS 6 IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY10765 APPLICATION HANG IN FCM ON VERY FAST MACHINE IY10816 CLI0111E ON INSERT OF DECIMAL 0.00= 50 CHARS IN SQLAJBND_BIND. JR14525 REDO THE DESCRIBE IF EXECUTE OF A CACHED PROC FAILS. JR14532 DB2SYNC APP SHOWS 100% COMPLETE BUT BAR IS AT 85% APAR fixes included in U469704f (Fixpak 3f) APAR No. Abstract -------- -------------------------------------------------- IC26754 IBM JDBC DRIVER CAUSES EXCEPTION IN MS J++ GARBAGE COLLECTOR. IY08857 SPECIFIC INTRA PARALLEL QUERY NOT TAKING ADVANTAGE OF HI2KEY/LO2 KEY WITH MGJN IY09146 FIX FOR PERFORMANCE PROBLEM CAUSED BY JR13499 IY09422 MANUALLY UPDATING COLVALUE COLUMN IN SYSSTAT.COLDIST TABLE WITH A DATE VALUE DISPLAYS THE UPDATED VALUE WITHOUT SINGLE QUOTES. IY09592 DB2 SENDS WRONG SIZES FOR DATA PARTITIONS TO BACKUP TO ADSM CLIENT. IY09664 INCORRECT DATABASE SEED IN EEE ENVIRONMENT AFTER ADDING ADDITIONAL NODES SUCH THAT EVENT MONITOR FAILS ON NEW NODES. JR14385 EXECDIRECT ON KEYSET CURSOR DOES NOT QUALIFY SYSTABLE/SYCOLUMNS TABLES ON SELECT FOR TABLE INFORMATION. JR14399 CONTAINER LISTS NOT REFRESHED DURING NODE CHANGES IN THE CONTROL CENTER. JR14420 CUSTOM DPREPL.DFT SETTINGS FOR CONTROL CENTER NOT PICKED UP. JR14506 JAVA MULTIPLE SESSION PROBLEM WITH THE .APP. DRIVER. APAR fixes included in U469704e (Fixpak 3e) APAR No. Abstract -------- -------------------------------------------------- IY06432 RUNSTATS WITH DISTRIBUTION CAUSES INCORRECT FILTER FACTOR WHEN GENERATING ACCESS PLAN. IY07870 SQL1035N RETURNED WHILE DB IS IN ONLINE BACKUP AND SAME USER TRIES TO CONNECT TO IT IY08714 LOAD WITH REPLACE OPTION GIVES BAD PAGE ERROR IN DART OUTPUT IY09051 RESTORE DB FROM ADSM THROUGH CONTROL CENTER IN DB2 V6 IS FAILING WITH ERROR CODE SQL2542N. IY09342 SQL1042N TRYING TO CONNECT TO DB AFTER EVENT MONITOR PIPE READER IS GONE. IY09345 STORED PROCEDURE DOES NOT WORK WITHOUT QUALIFIER IY09402 DB2 REBIND TOOL DOES NOT UPDATE THE RDS_LEVEL COLUMN IN THE SYSIBM.SYSPLAN SYSTEM TABLE. IY09469 SELECTING TABLES FROM OS/390 WHICH CONTAIN LOBS CAUSES SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT. IY09505 INCORRECT COMPILE INSTRUCTIONS IN DB2UEXT2.CADSM FOR ADSM 3.1.6 OR HIGHER. IY09507 SQL1478 AFTER CREATE/ALTER/DROP BUFFERPOOL WHERE THE TOTAL CHANGE IS >=2GIG. THIS RESULTS IN AN INCONSISTENT SQLBP FILE. IY09605 SQL0199N ON SQLSTATISTICS AGAINST MVS WITH CURSORHOLD=0 JR14327 FIXPAK INSTALLS OF JDBC 1.1 AND 1.2 FILE MAY CAUSE FILES TO BE OVERWRITTEN JR14384 CONNECT HANGS WHEN CBIT ERROR IS ENCOUNTERED DURING CRASH RECOVERY. JR14462 DB2BATCH THROWS AN ERROR AT THE END OF EXECUTION (DB2SYS.DLL) JR14476 WORKAROUND FOR DB2 UDB TO IGNORE THE VERSION OPTION SPECIFIED AT BIND TIME WHEN USING DPROPR APAR fixes included in U469704d (Fixpak 3d) APAR No. Abstract -------- -------------------------------------------------- IY07076 TRAPS IN SQLRISR2 SQLSFETC SQLRISRT SQLRIRST EXECUTING SQL IY08600 DATALINKS PARAM CHANGES TO N IN MIGRATIONS FROM V5 TO V6 IY08767 TIMING ISSUE IN BSU WHEN TRYING TO RETURN A DARI TO THE POOL IY09191 IMPROVE DB2DIAG.LOG MESSAGES FOR RFWD TO PIT ERRORS IY09202 Signal#11 IN SQLO_INIT_MULTI_THREADING IY09213 JDBC NET DRIVER PERFORMANCE. RESULTSET.CLOSE() FROM JDBC CLIENT SENDS REQUEST TO THE DB2JD SERVER AND EXPECTS NO RESPONSE. IY09223 ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER PREPARE IY09267 RUNSTATS RECEIVES SQL2314W IY09275 LICENSE USE MANAGER LUM LOOPS CHECKING /DEV/HIL ON HP UX WHILE VALIDATING THE LICENCE FOR DB2 CONNECT. IY09298 DB2COUNTRY VARIABLE DEFAULTS TO A VALUE OF 0 INSTEAD OF 1 IY09314 DB2EXPLN WITH -L OPTION doesn't RESPECT PACKAGE NAME CASE IY09367 DB2 UDB - ONLINE/OFFLINE BACKUP TO MULTIPLE DISKS HANGS. NOTE: THIS IS A EXTENSION TO THE FIX FOR APAR IY04310. JR14355 INVALID MEMORY ACCESS - C0000005 TRAP IN SQLRIVAL (TRAP FILE SHOWS SQLRICONSEC ) RUNNING QUERY WITH PARALLELISM JR14415 TRAP - MTS AND STORED PROCEDURES WHICH RETURN RESULT SETS JR14416 OS/2: AUTHENTICATON SERVER FAILS IF SECURITY IS SAME JR14434 FORCE APP ALL TRAPS TYPE 2 CONNECT APP IN OTHER WINDOW WHICH HAD INVOKED DOSSLEEP JR14474 JDBC MULTIPLE SESSION PROBLEM: CLI0601 ERRORS. JR14475 (JDBC/CLI) COMMA DECIMAL SEPARATOR NOT WORKING IN NLS. JR14479 THE CONTROL CENTRE (AND INFORMATION CENTRE) DO NOT START BECAUSE DB2JAVIT.EXE FAILS IF REGISTRY INDICATES JDK 1.2 IS INSTALLED. JR14484 SQL30083 RC=1 WHEN PASSWORD IS CHANGED FROM A CLIENT APAR fixes included in U469704c (Fixpak 3c) APAR No. Abstract -------- -------------------------------------------------- IY06649 DB2CART DUMPS HUGE AMTS OF DIA3605C & DIA3855CINTO DB2DIAG.LOG IY07739 OPTIMIZER PREDICATE PROBLEM ON EEE WITH QUERY WRITTEN WITH UNION ALL IY08948 REORGCHK AT DIAGLEVEL 4 GENERATES -501 IN DB2DIAG.LOG FILE. IY09006 DB2IMIGR FAILS WITH SEGMENTATION VIOLATION, RC=139 SPECIFICALLY WITHIN DB2IMNOD. IY09149 JDBC NET DRIVER RETURNS -99 ON EXECUTEUPDATE AGAINST DB2 MVS IY09292 RESTORE USING CONTROL CENTER INCORRECT. JR14263 WRONG WEEK NUMBER RETURNED FROM WEEK FUNCTION JR14408 SQL0984C WITH 'INCORRECT USE OF THE SAVEPOINT' MSG IN DB2DIAG. JR14438 ARRAY INSERT INTERMITTENT FAILURE IF CBCOLDEF=0 SQLBINDPARAMETER JR14450 CLI0100E ERROR WHEN SETTING A DECIMAL COLUMN TO NULL APAR fixes included in U469704b (Fixpak 3b) APAR No. Abstract -------- -------------------------------------------------- IX87885 TWO PHASE COMMIT. CLIENT CALLS A STORED PROCEDURE AND THEN COMMITS IS NOT PERFORMED. IX88428 USING ADSM CONFIGURATION PARAMETERS IN DB CFG CAUSE A NULL TO BE ASSIGNED AS THE BACKUP IMAGE OWNER. IY08086 DATABASE MARKED BAD DURING RESTART DUE TO INCORRECT HANDLING OF A RETURN CODE 1 FROM SQLBFLSH IN SQLPUPDATEMINBUFFLSN IY08125 SQLTABLES() CALL IS NOT RETURNING INOPERATIVE VIEWS FROM A UDB DATABASE. IY08729 PATCH1=131072 CAUSES CONTROL CENTER HANG IN STATEMENT HISTORY IY08867 DB2CKMIG_EXE FAILS ON HP-UX 11 MACHINE 859 IY08893 SQL2306N AT LOAD WITH DBCS TABLE NAME IY08920 CC V6.1 PERFORMANCE MONITOR - START MONITOR OPTION FOR SPECIFIC DATABASE APPEARS TO HANG - NO MONITORS LISTED IY09068 EVENT ANALYSER INFORMATION FROM AIX WILL NOT DISPLAY ON NT JR14049 SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG JR14067 V6.1/NT THIN CLIENT INSTALL PROBLEM B/C MISSING LDAP KEYWORD JR14148 ALWAYS TREAT '_' AS A CHARACTER WHEN IN CALL STMT-ST.PROC NAME JR14239 DURING ROLLFORWARD RECOVERY, WE SEE ERROR MESSAGES IN THE DB2DIA G.LOG STATING 'CANNOT STEAL SPACE FROM OTHER BUFFER POOLS.' JR14279 SQLEXTENDEDFETCH RETURNS SUCCESSWITHINFO IF A FETCH OF ONE ROW FAILS DUE TO TIMEOUT OR DEADLOCK. RETURN SHOULD BE SQLERROR. JR14400 CREATE NEW PRECOMPILER SERVICE FUNCTION TO ACCEPT DIFFERENT DB V ERSIONS AND SELECT PRECOMPILER BEHAVIOUR ACCORDINGLY. JR14404 SQLCOLATTRIBUTE RETURNS INCORRECT INFORMATION JR14409 TRAP FILE SHOWS TRAP IN SQLISETKEYANDKEYDATA (IN SQLIUNDO.C). HOWEVER, ACTUAL TRAP IS IN WRITELOG. JR14412 ACCESS 2000 FAILING WITH VARCHARS > 210 CHARACTERS JR14418 JDBC 2.0 APP DRIVER SEGMENTATION FAULT WHEN EXECUTING QUERY. JR14435 CLI0165E CALLING STORED PROCEDURE WITH ASYNC ON AND BLOB COLUMN JR14436 Garbage characters in the DB2 recovery history file when using the sqluvtun API. APAR fixes included in U469704a (Fixpak 3a) APAR No. Abstract -------- -------------------------------------------------- IC26217 CLI0109E 'STRING DATA RIGHT TRUNCATION' ERROR OCCURS WHEN TRYING TO INSERT BINARY DATA IX87387 SELECT W/ OPTIMIZE FOR N ROWS AND FOR FETCH ONLY GOING AGAINST MVS RESULTS IN AN ADDITIONAL FOR FETCH ONLY BEING ADDED. IY02962 DEFUNCT CHILD PROCESSES ON SOLARIS WITH JDBC NET DRIVER IY03632 RECONCILE DLREPORT NEEDS TO BE TERMINATED WITH / IY05131 CLI0165E WHEN USING SQLEXTENDEDFETCH WITH ASYNC MODE ON IY05292 DBA2065 TRYING TO RUN OR SCHEDULE SCRIPT FROM SCRIPT CENTER. IY05325 TRAP IN SQLE_MRSPSENDDARISTART WHEN CALLING STORED PROCEDURE THROUGTH DB2 CONNECT IY06100 DATABASE COMES DOWN, SEE MESSAGE IN DB2DIAG.LOG STATING THAT FLUSH NOT ALLOWED ON ESTORE. IY06691 SQL4970 ON ROLLFORWARD TO END OF LOGS - 'UNEXPECTED FILECOUNT' IY06767 PERL FOR DB2 DISPLAYS VARGRAPHIC NULL STRINGS INCORRECTLY IY07550 SQL1042N DURING A ROLLFORWARD OF A V5.X DATABASE THAT HAS BEEN MIGRATED FROM V2.X DATABASE. IY07598 LOAD WITH MULTIPLE INDICES AND ESTORE ENABLED TRAPS THE LOAD PROCESS DB2LRID. IY07604 SQLJ SQL0309 IF HOSTVARIABLE VALUE IS NULL ON UPDATE IY07711 DB2CCLST LEAVES DEFUNCT PROCESSES ON UNIX PLATFORMS WITH MULTIPLE LOGICAL NODES. IY07809 AIX LOGIN LOGS NOT UPDATED WHEN CONNECT TO DB WITH WRONG PASSWD AFTER USER ACCOUNT IS LOCKED. IY07865 EVENT MONITOR STATE NOT UPDATED CORRECTLY. IY07880 -902 IN SQLRRSTA DURING RUNSTATS INDICATING A MEMORY HEAP ERROR. IY07884 JDBC APPLICTION WAS CRASHING DUE TO NULL MEMORY BEING FREED BY THE CLI LAYER IY07951 JAVA UDFS WITH DECIMAL PARAMETERS PERFOMANCE DEGRADS IY07968 HANG / DEADLOCK ON PARALLEL-ENABLED QUERY IY08008 DLFM SHUT DOWN WHEN YOU FORCE THE COPY DAEMON'S ADSM SESSION TO TERMINATE OR RECYCLE THEIR ADSM SERVER. IY08060 SQL0901N REASON 'SQLNO_NUM_CHARS_SPECIFIED 200 :RC( 0)') WHEN DB2CODEPAGE=1208 IY08066 SNAPSHOT FOR DB SHOWS WRONG O/P FOR AGENTSIN V5,V6 & V7 IY08086 DATABASE MARKED BAD DURING RESTART DUE TO INCORRECT HANDLING OF A RETURN CODE 1 FROM SQLBFLSH IN SQLPUPDATEMINBUFFLSN IY08106 V5.2 TO V6.1 MIGRATION FAILS ON A SQL0456N IF MIGRATION IS RUN MORE THAN ONCE AFTER A MIGRATION FAILURE IY08124 INSERTS ARE MISSED BY CAPTURE IY08204 NON CONSTANT 'PULLUP' IN THE OPTIMIZER CAUSING QUERY PERFORMANCE PROBLEMS. IY08219 FAILURE ON DATABASE INITIALIZATION CAN LEAVE ORPHANED PREFETCHERS WRITING SQLOCSEMP MESSAGES TO DB2DIAG.LOG IN LOOP IY08304 BP PAGESIZE WRONG WHEN CREATED ON NODE USING ALTER BUFFERPOOL IY08307 SQL2306 WHEN LOADING AS DBADM WITHOUT DISCONNECTING PREVIOUS CONNECTION OF ANOTHER USER IY08318 CLI RETURNS DRIVER NOT CAPABLE FOR LONG VARCHAR TO AS/400 IY08320 REBINDING OLD (V1.X) BIND FILES YIELDS SQL0436 WHEN APP. IS RUN IY08349 IF ONLY UOW MONITOR TURNED ON, UOW INFORMATION NOT COLLECTED. IY08365 DB2JSTRT DOES NOT MAKE USE OF THE VARIABLE DB2_PORT_NUMBER IY08557 SQL30081 ON THE CONNECTION WHEN DB2 CONNECT V6.1 AND IDLE THREADS ARE CANCELLED ON OS/390 SIDE. IY08569 ROLLFORWARD OF DATABASE CAUSES CORRUPTION OF LOB DATA IY08573 RUNNING 'GET SNAPSHOT FOR ALL' MULTIPLE TIME MAY CRASH DB2 IY08581 INTERRUPTED REDISTRIBUTE INCORRECTLY RETURNS SQLCODE 0 - REDISTRIBUTE COMPLETED SUCCESSFULLY IY08584 MULTIPLE IN PREDICATE WITH OUTER JOIN CAUSES EXPLAIN ERROR IY08589 BIND FILE CREATION FOR CLI PRODUCES AN INCORRECT OPTIONS STRUCT IY08716 HASH JOIN MAY RESULT IN ENDLESS LOOP IY08717 Signal#11 IN SQLRG_ADD_CHK_CSTRNT_HCSD IY08722 MESSAGE ERROR -- SQLZ_VALUE MAP NOT INITIALIZED USING DB2EXPLN. IY08729 PATCH1=131072 CAUSES CONTROL CENTER HANG IN STATEMENT HISTORY JR13153 DB2 CONNECT GATEWAY TRAPS WHEN LARGE ARRAYS PASSED AS INPUT PARAMETERS. JR13682 CONTROL CENTER NOT ABLE TO LIST DCS APPLICATIONS FOR A REMOTE INSTANCE. DEFECT #124825 JR13887 ERRONEOUS 'FAILED TO COMMIT' MESSAGE DUMPED TO DB2DIAG.LOG LOAD INCORRECTLY HANDLES POSITIVE RETURN CODE FROM COMMIT JR14082 FIX 12-BYTE MEMORY LEAK FOR NON-BLOCKED CURSORS JR14222 CCA BIND OF CLI UTILITIES MISSES A PACKAGE AGAINST DB2/MVS 5.1 JR14237 DB2GOV FAILS WHEN DB2NODES.CFG HAS BLANK LINE AT THE END JR14255 NO RESULT SETS RETURNED (AND POSSIBLY AN INVALID ERROR MSG) WHEN ISSUING QUERY FROM V6.1 CLIENT THROUGH DB2 V.6.1 SERVER TO DJ JR14263 WRONG WEEK NUMBER RETURNED FROM WEEK FUNCTION JR14282 SQL30020, OR AN ABEND ON DB2 FOR OS/390 WHEN INVOKING A STORED PROCEDURE WITH OUTPUT PARMS LONGER THAN THE BLOCK SIZE (32K) JR14305 TAPE SUPPORT ROUTINES ON NT DO NOT WORK WITH MAGSTAR3590 JR14311 BIND OF V5 LESS THAN FP7 CLIENT PACKAGES TO V6 SERVER JR14312 DB2 COBOL PRECOMPILER TO GENERATE COPY 'SQLCA.CBL' INSTEAD OF COPY 'SQLCA.CBL' JR14314 PROVIDE PATCH VALUE TO WORKAROUND ADO ADUSECLIENT PROBLEM. JR14337 CANNOT LOAD DDCS.DLL ON OS/2 SQL1108 ON REMOTE CLIENT CONNECTION JR14339 HOST DB CATALOGGED USING CCA USING ENABLE ENCRYPTION WITH DCS AUTHENTICATION: CONNECTION FAILS WITH SQL1403N JR14346 LICENSING DOES NOT COUNT CONCURRENT REMOTE CONNECTIONS JR14371 THE FLAG FOR FOR BIT INDICATOR IS NOT BEING INITIALIZED PROPERLY JR14373 CIRCUMVENT CLI0109 ERROR: REDESCRIBE EVERY TIME WE GET CLI0109 ERROR. KEYWORD REDESCRIBEPARMONERROR: 1 -DEFAULT, 0 - DISABLE THI JR14383 RUNNING SCRIPTS IN SCRIPT CENTER SWITCHES OS/2 INTO LOGON MULTI MODE WHICH CAUSES RUNNING APPS (E.G., APPLY) TO WAIT FOR LOGON APAR fixes included in U469704 (Fixpak 3) APAR No. Abstract -------- -------------------------------------------------- GG03649 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 GG03991 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE GG03993 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES GG03996 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS GG03999 CAPTURE CORE DUMPS AROUND PRINT_LSN() GG04000 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE GG04001 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE GG04003 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE GG04004 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR GG04005 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR GG04006 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 GG04007 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 GG04008 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. GG04011 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD GG04012 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS GG04013 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES GG04014 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD GG04015 CAPTURE CORE DUMPS AROUND PRINT_LSN() GG04016 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IC24824 CHECK IN DJRA.EXE FOR UDB V61 IY02571 SQL0433 DURING INSERT VALUES, LINEFEED CHANGED TO SPACE IY04962 USING VOLATILE FLAG DURING R/3 UPGRADE IY05590 DB2IUPDT IN FP11 RESETS DB2PROFILE 99/11/11 PTF PECHANGE IY05988 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027/ASN0017S RC9106 ASN0017 IY06283 LATCH CONTENTION CAUSES HIGH SYSTEM CPU SPIKES WHEN MANY AGENTS ARE IN A TIGHT LOOP EXECUTING THE SAME DYNAMIC STATEMENT IY06740 DB SIZE ESTIMATE CALCULATED INCORRECTLY FOR BACKUP TO ADSM. HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE. IY06891 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY06907 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027 IY07053 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. IY07069 CLI0002W DATA TRUNCATED WHEN FETCHING CLOB FROM DB2/390 V6 IY07092 CHANGE OPTIMIZER COSTING TO HANDLE NULLS IY07110 -901:SQLNO_SMP_CREATE_TQ IY07239 JAVA UDF EXCEPTION NOT IN DB2DIAG.LOG FOR MISSING CLASS IY07309 SQL3508 REASON 4 ON LOAD WITH DELETE PHASE OR LOAD RESTART WHEN TABLE ID > 32767 (APPEARS NEGATIVE IN SYSTEM CATALOGS). IY07523 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07527 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07528 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07556 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07558 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07559 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07560 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07566 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07567 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07568 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07572 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07573 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07590 CHANGES MADE TO SQLGETDATAINTERNAL CAUSED CODE TO TRAP IY07600 QUERY PERFORMANCE AGAINST >4 TABLES IS NEGATIVELY AFFECTED BY THE CONTENT/LENGTH OF THE LIKE PREDICATE STRING. IY07699 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07700 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07701 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07702 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07709 SQL1131N WHEN CALLING SQLJ STORED PROCEDURE EMBEDDED CLIENT IY07735 SQL0433N ENCOUNTERED WHILE DOING A BUFFERED INSERT IY07744 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS IY07745 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY07747 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07748 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07749 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07750 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07751 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07753 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07755 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. IY07756 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027 IY07757 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY07759 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07760 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07761 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07796 CMDEAL WITH TYPE CM_DEALLOCATE_ABEND DOESN'T RETURN IY07808 RETROFIT NEW PACKAGE NAMING ALGORITHM INTO V6 FOR STORED PROCEDURE BUILDER IY07822 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS IY07823 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027 IY07824 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY07825 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07826 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07827 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07908 ROWCOUNT > 10000000 IN LOAD COMMAND CAUSES INSTANCE CRASH IY07922 THE IN PREDICATE IN THE QUERY IS NOT PUSHED DOWN DUE TO OJ IY08058 NO DROPPED TABLE RECORD IS CREATED WHEN DROPPING A TABLE IY08124 INSERTS ARE MISSED BY CAPTURE IY09479 SQL2154 ON ATTEMPTED TABLESPACE RESTORE - TRAP MAY ALSO OCCUR. JR13508 32K MEMORY NOT FREED PROPERLY WHEN APPLICATION DISCONNECTS IN DRDA JR13682 CONTROL CENTER NOT ABLE TO LIST DCS APPLICATIONS FOR A REMOTE INSTANCE. DEFECT #124825 JR14011 PCS_AGNT ERRORS PREVENT WINNT SHUTDOWN (USING INTEGRATED SNA ON DB2) JR14089 DB2 ALLOWS TWO FOREIGN KEYS TO CO-EXIST ALTHOUGH THEY CONTRADICT EACH OTHER. JR14168 EVENT MONITOR ALWAYS ATTACHES TO THE SAME INSTANCE IF MULTIPLE INSTANCES EXIST ON THE SAME MACHINE. JR14184 MULTITHREADED FIXES NEED TO BE DONE TO DB2JD DUE TO VARIOUS PROB LEMS (EXAMPLE: DB2JD BECOMES UNAVAILABLE INTERMITTENTLY) JR14201 GATEWAY TRAPS AT DB2SYSCS.EXE. 'ERROR IN AGENT SERVICING APPICATION WITH COOR_NODE:XXXX' IN DB2DIAG.LOG. JR14210 CLIENT CONTROL CENTER CANNOT SEE OS/390 TABLES JR14219 CLI APP INSERTS INCORRECT CHAR VALUES. EEE/MPP/CODEPAGE. JR14229 SQJ0201E DURING SQLJ CUSTOMIZATION OF CALL STATEMENT JR14271 In Satellite Edition, the results of TRUNCATe script EXECUTION, outputs the FIRST PORTION, INSTEAD OF THE LAST portion APAR fixes included in U469454d (Fixpak 2d) APAR No. Abstract -------- -------------------------------------------------- IY04139 SQL5153 NEEDED INSTEAD OF SQL30081 ON CLIENT WHEN NO FCM RQBLK IS AVAILABLE. SERVER ERROR SQL6043 IS FINE. IY04310 DB2 UDB - ONLINE/OFFLINE BACKUP TO SEVERAL DISKS HANGS. IY05535 QUERY TO DB2/MVS IS BEING TIMEDOUT EVEN IF NOT INTERRUPT ENABLED IY06431 ATTEMPTING TO CHANGE A FILE DMS CONTAINER TO A DEVICE DMS CONTAI NER IN THE REDIRECTED RESTORE FAILS IY06700 DB2_ENABLE_SINGLE_NIS_GROUP CAUSES DB2START TO HANG ON HP10 IY06746 DIA5000C A DRDA AS TOKEN 'RECOVERABLE' WAS DETECTED. THE DIAGNOSTIC DATA RETURNED IS (SRVDGN). DUMPS ARE CREATED. IY06791 DB2 UDB - SQL3021/SQL0204 ON IMPORT REPLACE TO A ALIAS NAME FOR A TABLE IN WHICH THE USER HAS CONTROL ACCESS TO. IY07068 LOGPATH WITHOUT NODENUM IS SET AFTER MOVING FROM V5 EE TO V6 EEE IY07098 SQL2550N RETURNS WRONG INFORMATION WITH SECOND NODE NUMBER IY07235 DB2DIAG.LOG AND TRAP FILE GROWS VERY LARGE AFTER SECOND INSERT UPON TABLESPACE FULL CONDITION. IY07311 HASH JOIN FAILS WITH MEMORY ALLOCATION ERROR. INITIALIZATION FAILS CAUSING SUBAGENTS TO FAIL DURING MEMORY ALLOCATION. IY07319 QUERY PATROLLER 'IWM START ALL' FAILS IY07376 LIBPATH NEEDS TO BE SET IN DB2 INSTANCE ON AIX OTHERWISE VARIOUS PROBLEMS CAN HAPPEN. 'NO SUITABLE DRIVER' FOR EXAMPLE. IY07453 TRAP IN SQLDFIXTCB DURING LOAD DUE TO INCORRECT RETURN CODE HANDLING IN SQLU_GET_TABLE_ID IY07474 INCORRECT TIMESTAMP 01-01-1970 IN APPLICATION SNAPSHOT OF LOCK WAIT STATE APPLICATION. IT SHOULD HAVE CORRECT TIMESTAMP. IY07659 -901 FROM SQLNO_FIND_LOCAL_EQ_PRED JR13497 SQLWARN FLAGS ARE NOT BEING RESET AFTER EXECUTE JR13651 SQL2029N, RC=28 ON RESTORE ISSUED FROM CLIENT WITH A DIFFERENT ALIAS THAN THE SERVER - USING SYTOS USEREXIT JR13964 CHECK FOR INVALID CHARS IN HOSTNAME BEFORE INSTALL JR14049 SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG JR14066 SQLEXECDIRECT RECEIVES 'SQL0005W OPTION VALUE CHANGED' WHEN USING KEYSET CURSORS, AND THEN NO DATA IS RETURNED. JR14112 CLI0118E WITH 'SELECT {FN UCASE(T1.COL1)} FROM TABLE1 T1' JR14116 -514 ON SQLEXECUTE() FOLLOWING COMMIT ON OPEN CURSORS ON HOST JR14167 CC: CAN ONLY CONFIGURE PARTITION 0 IN EEE ENVIRONMENT JR14169 ALTER TABLE ADD COLUMN ON A TABLE WITH CLUSTERING INDEXES CRASHES THE DATABASE JR14170 SQLA.DLL AND SQLA32.DLL WERE INCLUDED IN SDK PACKAGING INSTEAD OF IN CAE JR14171 REMOVING JOURNAL ENTRIES FROM CC CAUSES SQL1058. JR14174 SQL1403 WHEN CONNECTING TO DATABASE ON NT USING A USERID THAT IS THE SAME AS A DOMAIN NAME JR14194 SQL0007N WITH SQLJ WHEN CALL STATEMENT INCLUDES A HOST VARIABLE APAR fixes included in U469454c (Fixpak 2c) APAR No. Abstract -------- -------------------------------------------------- IY04173 DB2ADUTL DOES NOT GUARANTEE ORDER WHEN EXTRACTING LOGS FROM ADSM IF MULTIPLE COPIES OF THE LOGS EXIST. IY04401 SQL1042 AT RESTART DB AFTER CRASH AT ALTER BUFFERPOOL IY05732 CLI REPORTS THAT UDB DOES NOT SUPPORT INOPERATIVE VIEWS -IT DOES IY05814 DB2 FAILED TO CREATE DB WHEN SET LOCALE=ZH_TW.BIG5 ON SOLARIS. IY06066 PUTTING ASYNCENABLE BACK INTO CLI IY06126 QUERY THAT EXECUTES IN PE 1.2 FAILS WITH SQL0101 AT OPTIMIZAITON LEVELS < 7 AND STMTHEAP < 60000 IY06147 ADD SUPPORT FOR CHAINING THE CLOSE OF A CURSOR TO THE NEXT OPEN IY06164 WHEN AUTOCOMMIT IS ON AND SQLEXECDIRECT RETURNS A NEGATIVE SQLCODE, NO COMMIT IS SENT TO THE TARGET DATABASE. IY06178 STORED PROCEDURE BUILDER CAUSES TRAP (SIGNAL 4-NO STACK) WHEN INVOKED BY CLIENT TO NON-CATALOG NODE. IY06234 JDBC RETRIEVAL OF NON-US CLOB TRAPS IY06317 CONCURRENT LONG RUNNING QUERIES CAUSE CPU TO SPIKE FOR A PERIOD OF TIME PREVENTING NET.COMMERCE APPLICATIONS FROM PROCEEDING IY06343 AUTOLOADER MAY HANG IN SOLARIS IY06347 TCP LISTENER HANGS IN SQLEGETAGENT UNDER HIGH WORKLOADS IY06539 TIMING PROBLEM WITH LOAD IN INCREMENTAL INDEXING MODE. IY06717 DDL GENERATED BY DB2LOOK FOR UNIQUE INDEXES CAN BE IMPROVED. IY06750 DB2LOOK DOES NOT SUPPORT DATALINK DATA TYPE IY06806 DB2 CONNECT TRAPS IN SQLE_DB2RA_AS_DB_BLOCK_FETCH, WHEN CLIENTS CONNECT TO EE/EEE DATABASES THROUGH THE GATEWAY. IY06808 INCORRECT NODE NUMBER PICKED UP IF ISSUING A CONNECT FROM A NODE THAT IS NOT IN THE DB2NODES.CFG AND DB2NODE IS NOT SET. IY06824 INDEXES ARE NOT MIGRATED DURING UDB EEE MIGRATION FROM V5 TO V6. IY06843 APPLICATION CORE DUMPS WITH DB2 V6.1 WITH THE FOLLOWING ENTRIES IN DB2DIAG.LOG: DIA1518, DIA3826C FROM LOCK_MANAGER IN SQLPLHLD. IY06912 BACKUP FAILS AT THE END WHEN UPDATING DB2RHIST.ASC FILE (BACKUP HISTORY FILE). PREVIOUS FAILED LOAD OPERATION. IY06932 SQL0973 QUERY_HEAP AFTER REPEATED ERRORS WHEN USING DESCRIBE DA (CLI) IY07040 SQLDESCRIBEPARAM IS CALLED ON A CALLABLE STATEMENT EVEN WHEN DISABLED. IY07111 CLIENT CONTROL CENTER CONNECT CAUSES EEE SERVER INSTANCE TO TRAP. 00/01/10 PTF PECHANGE IY07120 INSTANCE CRASHES WITH SIG#11 ON EXECUTION OF SELECT STATEMENT WITH UNION CLAUSE . IY07209 'FETCH FIRST N ROWS ONLY' WAITS A WHILE AFTER N TH ROW DISPLAYED IY07499 SQL0443N WHEN EXP2 IS GREATERTHAN EXP1 IN LEFT/RIGHT() JR12938 COMMAND CENTER/NT TRAP AFTER ISSUED 'CONNECT TO 18 JR14025 SQL3181W WARNING GENERATED ON LOAD FOR A VALID IXF FILE JR14034 UDB INSTANCE CRASHES. TRAP IN BSORTGETFIRSTPARTIALKEY FUNCTION JR14059 PATCH2=18 FAILS WITH SQL0804N WITH EMPTY STRING LITERAL TO HOST DB APAR fixes included in U468277a (Fixpak 2a) APAR No. Abstract -------- -------------------------------------------------- IX77854 SQL0901 DIAG FILE REPORTS ERROR IN BUFFER QUEUE SERVICES PROBE:30 SQLKQ_DETACH_BUFFER(). INTERNAL ERR 'LOST BUFFER' IX83660 SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS IX87116 DB2BATCH OPTION TO SPECIFY COLUMN DELIMITER IY03544 CREATE DATABASE ON LARGE NUMBER OF NODES MAY HANG IY03678 TRAP INDICATING SQLFXSYS_X AS FAILING FUNCTION. IY03698 CLI ARRAY INSERT PROBLEM WHEN ALL FIELDS IN A RECORD ARE NULL IY03820 REMOVE DB2START CALL FROM DB2EXFMT IY04221 EXPLICIT CONNECT FAILS WITH SQL1403 ON AIX IY04339 TRAP IN LOAD WHEN TEMP SORT FILE > 2GB SQLU_SMGETFREEPG() IY04496 DB2LOOK UTILITY MISTAKES IN THE HELP TEXT WITH THE -H OPTION IY05069 CASE/SUBSTR FUNCTION FOR AST'S IY05294 DB2DARI PROCESS COUNTER NOT DECREMENTED IN CASE OF ABEND IY05347 V61 VIA JDBC RETURNS WRONG VALUEAT SECOND SELECT TIME FOR SAME ROW SAME COLUMN. COLUMN IS BIGINT OR SMALLINT TYPE IY05361 CHECK GATEWAY VERSION FOR SQLDESCRIBEPARAM TO DB2 5.1.2 MVS IY05416 USEREXIT,DB2UEXT2,NOT COPIED TO /ADM/ IN MIGRATION FROM V5 TO V6 IY05751 SQLBINDPARAMETER WITH IBSCALE CHANGING ONLY - DB2 SHOULD IGNORE THIS AND NOT 'RE-DESCRIBE' THE COLUMN. RESULT - CLI0109 ERROR. IY05826 REMOTE MONITORING DOES NOT WORK FROM A CLIENT AGAINST UDB 5.2/HP-UX SERVER. IY05892 CLP THROUGHPUT IMPROVEMENTS IY05913 DB2ATLD BOUNDARY CONDITION CRASH IF LINEFEED IS ON A MULTIPLE OF THE 32K DATA FILE IY05980 CTRL-C APPLICATION CAUSES TRAP IN SQLEIAGT_CB IY06032 DB2CKMIG MIGRATION FAILS (DATABASE DOESN'T EXIST) EVEN THOUGH DATABASE EXISTS. IY06047 SQL0902C RC=100 WHEN SELECTING FROM EXCEPTION TABLE AFTER LOAD. IY06094 SQLJ: DB2PROFC COMMAND WITH PRECOMPILE OPTION QUALIFIER GIVES SQL0204N IY06127 SEGV IN SQLIUNDO AFTER UNDO IS INCORRECTLY INTERRUPTED. DB2 RESTART FAILS. IY06145 ASCII FUNCTION RETURNS INCORRECT OUTPUT IY06163 NON-SELECT STATEMENT ISSUED THROUGH CLI BRINGS DOWN DATABASE ON COMMIT IY06187 LOAD TRAPS (SQLBLOADGETEXTENT) IN ERROR PROCESSING.. IY06215 SQL0998 RETURNED TO CICS APPLICATIONS ISSUING STATIC ROLLBACKS, OR STATIC COMMITS. IY06323 TRANSACTION STILL HOLD LOCKS IN CRASH RECOVERY MESSAGES IN DIAG ARE EXTRANEOUS, AS THE LOCKS ARE ACTUALLY REMOVED. JR13611 ISSUING 'UPDATE DBM CFG USING FEDERATED YES' SHOULD RETURN AN ERROR IN UDB V6.1 AS THE DATAJOINER SUPPORT IS NOT INCLUDED JR13750 MULTIPLICATION OF DECIMAL CONSTANT GIVES INCORRECT RESULT JR13824 JAVA I/O EXCEPTION ON WRITE TO BLOB OBJECT FROM STORED PROC JR13880 RETURN THE ODBC SCALAR NUMERIC FUNCTIONS SUPPORTED BY DB2/MVS JR13909 DB2LOOK INSERTS COMMAS INTO DDL INSTEAD OF DECIMAL POINT FOR FLOATING POINT NUMBERS IN CERTAIN LOCALES/TERRITORIES JR13917 A CREATE DB SCRIPT FAILED WITH ERROR SQL1024 ON GERMAN M/C(NT+DB 2 V6.1) JR13949 DEFFERRED PREPARE RETURNS OPEN CURSOR FOR LARGE RESULT SETS. JR13974 FILTER FACTOR FOR ALWAYS-TRUE PREDICATE CAUSE SLOW QUERIES JR13976 DBA1613 WHEN RESTORING DB USING VENDOR DLL IN CC JR13977 DUPLICATE TABLESPACES RETURNED IN EEE ENVIRONMENT JR13990 COMMIT FAILS WITH -902 RC=29 (FATAL LOGIC ERROR) JR14019 ADD FOREIGN KEY DIALOG IN CC IS NOT POPULATING THE PRIMARY KEY BOX INITIALLY APAR fixes included in U469454 (Fixpak 2) APAR No. Abstract -------- -------------------------------------------------- GG03953 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K GG03961 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K GG03971 GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED GG03972 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP GG03974 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS GG03977 GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED GG03978 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP GG03979 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS GG03980 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS GG03981 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS GG03982 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL GG03983 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL GG03984 FORWARD FIT V5 APPLY APARS. GG03985 FORWARD FIT V5 APPLY APARS. IC24358 CHECKIN DJRA.EXE INTO UDB V6.1 IC25192 DB2 UDB VERSION 6.1 ON LINIX - DB2START HANGS DUE TO A CHANGE MADE BY RED HAT TO THEIR DYNAMIC LINKER. IX88801 PARALLELISM NOT WORKING WITH ODBC APPS TO MVS 5.1.1 IY02032 TABLE ACCESSABLE AFTER ROLL FORWARD THROUGH AN NONRECOVABLE LOAD IY03608 DB MARKED BAD AND BROUGHT DOWN WHEN LOAD INTO TABLE WITH RI. IY03903 AFTER A TABLESPACE RESTORE, A 'ROLLFORARD QUERY STATUS' DOES NOT SHOW INFORMATION IN THE 'NEXT LOG TO BE READ' FIELD. IY04033 INCORRECTLY PARSING AUTOLOADER INPUT PARAMETERS. IY04311 LIBDB2.SO NEEDS TO BE A DEPENDENCY OF LIBDB2LICM.SO IY04410 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K IY04411 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K IY04412 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K IY04471 -902 FROM SQLRIGTQ IY04651 SQL2519N ON MIGRATION TO V6. ERROR '-902' WITH TOKENS 'FIXUP SYSTRIGGER: FETCH SYSTABLES (-27) DMS RC=FFFFF840' IY04909 SIGNAL #4 TRAP DURING BUILD PHASE OF LOAD IY04947 SQLCODE -433 RETURNED ON A BUFFERED INSERT IY04961 OPTIMIZE FOR 1 ROWS PERFORMS A TABLE SCAN INSTEAD OF INDEX SCAN IY05040 TRAP, SIGNAL #11, IN THE OPTIMIZER, SQLNO_CRULE_STARJN_AND(). IY05115 SELECT COLUMN LIST > 4005 AND ORDER BY CAUSES SQL1224. IY05176 DBM CRASHES DUE TO A SIGNAL #11 IN SQLVDECADDEC IY05192 SQLSTATISTICS() QUERY FAILING WITH CLI0165E ERROR IN ROW IY05198 DMBILIST FOR V6 IAV EXTENDERS REPORTS VERSION 5 IAV EXT.... IY05315 BAD ACCESS PLAN FOR WHERE IN (VAR1,VAR2....VARN) IY05359 SNAPSHOT FOR APPLICATION REPORTS SQL10007 IN THE STATEMENT TYPE FIELD IY05364 FORWARD FIT V5 APPLY APARS. IY05406 JAVA INSERT USING SETSTRING TO DECIMAL COL TRUNCATES DECIMALS IY05426 SQL1034N FOLLOWED BY INTERRUPTING ROLLBACK OPERATION IY05438 MIGRATION SETS THE SOFT FILE SIZE TO A MAXIMUM FILE SIZE. IY05446 ADD PATCH VALUE TO RETURN TRUE ISO TIMESTAMP FORMAT FROM CLI IY05481 VALUE FOR THE REFERENCE TYPE COLUMN DOES NOT REQUIRE A CAST TO THE REFERENCE TYPE IN A TYPED TABLE IY05483 FIX FOR SPM ON SUN ULTRASPARC (SUN4U) ARCHITECTURE IY05553 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY05554 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY05555 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY05608 CLI_MEMFREE TRAPS IN CLI_DSTFREEINFO WHEN OUT OF MEMORY IY05612 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY05626 ORDER BY VARGRAPHIC(),VARGRAPHIC() DOES RETURN CORRECT RESULT SET ORDER IY05656 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05658 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05659 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05660 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05662 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05663 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05664 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05671 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05672 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05673 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05674 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05815 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K IY05816 FORWARD FIT V5 APPLY APARS. IY05817 FORWARD FIT V5 APPLY APARS. IY05818 FORWARD FIT V5 APPLY APARS IY06097 SQLBINDPARAM CALL COREDUMPS AFTER SELECT IS DONE, THEN ARRAY INS ERT IS ATTEMPTED. JR13711 CLI0118E ON 'SELECT{FN CONCAT(SUBSTRING('ABC',1,2),'B')} FROM T1 JR13713 SQL0804N WHEN INPUT PARAM TO STORED PROC ON HOST IS NULL JR13757 DB2 IGNORES NULL INDICATOR ON OUT STORED PROC PARAMS JR13775 CREATION OF DMS TABLESPACE VIA CONTROL CENTER INCORRECTLY CALCULATES TOTAL NO. OF PAGES WHEN PAGESIZE NOT 4K. JR13840 SQLFREESTMT(SQL_CLOSE) TRAPS WITH KEYSET CURSOR AND LOB JR13862 DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT JR13879 DB2 CONNECT GATEWAY TRAPS WHEN USING DOWNFIX CLIENT DURING STORED PROCEDURE CALL TO DB2 MVS. JR13882 TRAP IN SQLNO_PROP_BEST_SORT_KEY RUNNING QUERY ON VIEW. JR13927 IMPLEMENT NEW BIDI LAYOUT TRANSFORMATION ROUTINE WITH MORE STRIN GENT ERROR CHECKING, MEMORY ALLOC, AND BIDI CCSID STRING TYPES. APAR fixes included in U465424c (Fixpak 1c) APAR No. Abstract -------- -------------------------------------------------- IY02571 SQL0433 DURING INSERT VALUES, LINEFEED CHANGED TO SPACE IY02572 LANG=JA_JP.IBM-932OR JA_JP.IBM-943SYMBOLIC LINKS NEEDED IY03379 DB2NODE ENVIRONMENT VARIABLE DOES NOT WORK FOR ALL CMDS IF PRTN NUM SPECIFIED IS NOT ON THE SAME PHYSICAL NODE. IY03805 PROBLEMS WITH NIS AND GROUP LOOKUPS ON AIX 4.3.2 DEFECT #124182 IY04414 DARI PROCESS DOES NOT PICK UP GROUP ID FROM .FENCED FILE IY04769 NODEXXXX AND CATNXXXX NOT UPDATED CORRECTLY ON BACKUP IMAGES EXTRACTED FROM ADSM WITH DB2ADUTL IY04893 SETTING DB2_MMAP_READ PROBLEM COULD PREVENT FIRST CONNECT IY04917 SIZE IN SNAPSHOT HEADER INCORRECT IN MPP ENV IF ACTIVE STATEMENT IY05051 CATALOG CACHE MAY CAUSE LONG LOCKS TO BE HELD IN SYSTABLES IY05198 DMBILIST FOR V6 IAV EXTENDERS REPORTS VERSION 5 IAV EXT.... IY05483 FIX FOR SPM ON SUN ULTRASPARC (SUN4U) ARCHITECTURE JR13217 SQLGETINFO(SQL_ORDER_BY_COLUMNS_IN_SELECT) REPORTS 'N' INSTEAD OF 'Y' FOR DB2/390 V5.1 JR13547 CLI0606 WHEN RETRIEVING DECIMAL DATA WITH GETDOUBLE CALL FROM NT FOR SPANISH JR13604 STORED PROCEDURE BUILDER WITH A SP WITH A DATE INPUT PARAM WILL BUILD OK BUT ON EXECUTE, IT WILL EXIT WITHOUT ANY ERRORS. JR13653 JDBC APPS AUTOCOMMIT IF STORE PROCEDURE CALL IS MADE. EXPLICIT ROLLBACK NOT POSSIBLE AFTER STP CALL. JR13684 SQL0901 IN FUNCTION SQLNO_SMP_CREATE_SHARED_SO JR13755 SQLEXECUTE TRAPPING WHEN KEYSET CURSORS USED JR13758 KEYSET CURSOR FAILS TO UPDATE WHEN NULL VALUES ARE IN THE RESULTSET. JR13783 PARMLIST SYNTAX ERROR ON STORED PROCEDURE CALL TO MVS JR13827 SQLSTATISTICS AND SQLDRIVER CONNECT TAKE LONGER TO COMPLETE IN DB2 V6.1 THAN IN DB2 V5.2 JR13858 CLI PERFORMANCE IMPROVEMENT WHEN AUTOCOMMIT ON APAR fixes included in U465424b (Fixpak 1b) APAR No. Abstract -------- -------------------------------------------------- IX87013 TEMPORARY FILES ARE CREATED USING BLOB WITH JAVA PROGRAMS IY02464 -901 INDICATING BANDP NOT PUSHED DOWN IY02862 OUT OF SPACE IN THE DLFM_BACKUP_DIR_NAME NOT DETECTED IY03133 SQL0901 'UNEXPECTED COLUMN USAGE TYPE' ON DELETE OPERATION ON TX ENABLED TABLE DUE TO TX TRIGGERS. IY03393 UNINITIALIZED MEMORY IN OPTIMIZER CAUSES SIGNAL #11 IN (SQLNO_CO PY_SETN,SQLNO_UNION_SETN) IY03630 RECONCILE SQL2554 DOES NOT GIVE DLFM SERVER NAME. IY03631 DB2_RECON_AIDPACKAGING IN EE IY03698 CLI ARRAY INSERT PROBLEM WHEN ALL FIELDS IN A RECORD ARE NULL IY03820 REMOVE DB2START CALL FROM DB2EXFMT IY03823 NIS: CONNECT ... CHANGE PASSWORD 'FAILS' WITH SQL1403N. WAIT TIME IS NECESSARY FOR PASSWORD TO REFRESH BY NIS SERVER. IY04240 CERTAIN QUERIES THAT RAN ON V5 RETURN SQL0101 - QUERY TOO COMPLEX ON V5.2. IY04279 WE DO NOT FETCH DATA PROPERLY FROM CHAR(255) COLUMN ON MVS - DATA GETS TRUNCATED AS WE EXPECT IT TO BE MAX 254 CHAR LONG IY04291 -901 IN SQLRI_CLOSE_UDF_EOT(), -1034 DBM CRAHES IY04399 TRAP, SIGNAL #11, IN THE DB MONITOR, I.E. DURING COLLECTION OF TABLESPACE COUNTERS. IY04409 SIG#11 IN SQLSFETC IY04431 MIXED EMBSQL/CLI APP CORE DUMPS ON SQLDISCONNECT IY04446 CLI0002W WITH CLOB DATA WITH GETSTRING IF SELECT OTHER TYPE 1ST. IY04502 DB2CLI.H HEADER INCORRECT FOR SUN IY04555 KEYSET CURSOR PARSING DOES NOT HANDLE <> CORRECTLY. IY04557 DB2CAT FAILS WITH SQL0811 WHILE DUMPING THE RI DESCRIPTOR IY04694 LARGE SELECT AGAINST DB2/MVS 5.1.2 RESULTS IN -502 IY04732 SQL0902 RC=126 AT DROP TEMP TABLESPACE IY04798 TRUST APP IS USING AN INVALID MEMORY ADDRESS JR13441 INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED JR13645 SQLCOLUMNS RETURNS INCORRECT INFORMATION FOR DEFAULT VALUE JR13700 DB2DARI GROWS FOR PARAMETER STYLE JAVA STORED PROCEDURE JR13708 CLI APP TRAPS WHEN CLI TRACE IS ON AND SQLFETCH RETURNS != SQL_SUCCESS JR13736 SQLDESCRIBEPARAM FAILS ON DEFERRED PREPARE OF >= 26 COLUMNS. JR13753 JDBC SETBYTES() MEMORY OVERWRITE IF INPUT VALUE LARGER THAN COLUMN WIDTH. JR13762 TRAP IN SQLEX_RDS_GEN_DATA. JR13782 DOSSLEEP(0) PREVENTED DB2 THREADS FROM DOING WORK WHEN HIGHER PRIORITY THREADS WERE RUNNING. APAR fixes included in U465424a (Fixpak 1a) APAR No. Abstract -------- -------------------------------------------------- IX89397 DB2 UNIX TRAPS ON CONNECT FROM EMB SQL IF DB2INSTANCE NOT SET IX89959 CACHE STORED PROCEDURE DESCRIBE INFORMATION IY00980 BACKUP FAILS WITH SQL1062 BECAUSE OF LINKS IN THE DB PATH IY01190 ROLLBACK OF CREATE TABLESPACE WITH > 1 CONTAINER NEVER UNTAGS CONTAINERS PAST THE FIRST ONE IY01210 DB2GOV MISSING DB2GOVD VALIDATE IF STARTING ON ONE NODE IY01489 LOG EXTENT 0 (S0000000.LOG) REQUESTED BY DB2 WHEN THE LOG SEQUENCE IS WELL PAST, IE. IN THE THOUSANDS. IY01841 RELEASE SHARE LOCKS ACQUIRED ON SYSTABLES DURING COMPLIATION OF SQL STATEMENTS IY02556 CC: JOURNAL REPORTS INCORRECT JOB STATUS IY02569 TRAP AT BEGINNING OF ONLINE BACKUP IN SQLUBCKA IY02618 DB2 CONNECT GATEWAY TRAPS IN SQLJMF10. IY02730 CLI DRIVER DOESN'T HANDLE LARGE STATEMENT SIZES CORRECTLY. IY03175 EXCESSIVE MESSAGES IN DB2DIAG.LOG IY03229 FENCED DB2DARI PROCESS LEAKS 4K OF MEMORY PER INVOCATION IY03447 SUN: ADD SUPPORT FOR GETGROUPSBYMEMBER CALL TO SPEED UP GROUP ENUMERATION - VERSION 6 ONLY IY03454 DB2 UDB - FIRST EXECUTION OF THE SIN UDF RESULTS IN SQL0443, RC 03. OTHER 'MATH' UDFS MAY ALSO EXPERIENCE THIS ERROR. IY03510 RESTORE FAILS WITH AN SQL0298N WHEN THE SAME CONTAINERS EXIST IN THE SQLNNNNN DIRECTORY... CANNOT REDIRECT THE RESTORE. IY03529 RUNNING DB2EMPFA WHEN SMS TABLES GREATER THAN 4G EXIST CAN CORRUPT DATA. IY03602 SQL0980C BAD PAGE ENCOUNTED DURING LOAD RESTART IY03861 APAR USED TO CREATE PTF FOR DB2 V5.0 FOR AIX IY03885 EVENT MONITOR WITH AT NODE DOES NOT FILTER EXISTING CONN IY04046 JDBC TRAP IF APPLICATION USES INVALID CONNECTION HANDLE IY04157 SET CURRENT PACKAGESET PRODUCES A SIGSEGV FROM WITHIN SQLJ IY04168 APAR USED TO CREATE PTF FOR DB2 V6.1 FOR AIX IY04196 LOG FULL CONDITION WITH NODE LOG SYNC WILL CAUSE DB2 TO PANIC AN D CRASH. IY04225 INFINITE LOOP IN DB2GOVD DURING ERROR HANDLING IF DB2GOV LOG FILES ARE REMOVED. INFINITE ERRORS TO STDOUT. IY04242 LOG FULL CONDITION DID NOT SAVE ENOUGH LOGSPACE FOR A TRANSACTION TO BE ROLLED BACK. JR12656 ODBC SQLTABLEPRIVILEGES DOES NOT RETURN THE PUBLIC PRIVILAGES JR12796 SQLCOLUMNS() CALL WITH ONLY TABLE NAME DISREGARDS SCHEMALIST AND CURRENTSQLID JR12926 JAVA GETSCHEMA RETURNS NULL WHEN USING OPTIMIZED CATALOG JR13123 WHEN USING BLOB LOCATORS, SQLGETPOSITION FAILS WITH CLI0102E INVALID CONVERSION SQLSTATE=07006. JR13169 #DELETED GETS DISPLAYED IN MS ACCESS WHEN DISPLAYING A DB2 TABLE THAT HAS A PRIMARY KEY ON A DATE COLUMN OR DECIMAL COLUMN JR13334 TIMESTAMPDIFF ODBC FUNCTION DOES NOT GET NEGATIVE VALUES RETURNED WHEN CALLED IN DB2 CLI/ODBC. JR13427 CHANGING ISOLATION LEVEL AFTER EXECUTE CAUSES ERROR ON NEXT EXECUTE JR13475 RETRIEVING A CLOB SUB-STRING GREATER THAN 32KB TRAPS ON THE GATEWAY. JR13481 SQL_CURSOR_STATIC CURSORS NOT BEING CLOSED AFTER SQLCANCEL()/SQLFREESTMT(SQL_DROP) JR13499 RECOGNIZE '\' ESCAPE CHARACTER IN SCHEMA QUALIFIERS JR13502 RESTORE OF A V5.2 (FP9/8) DATABASE IN V6.1 RETURNS AN SQL2548N ERROR MESSAGE - CODEPAGE OF BACKUP DOES NOT MATCH ONDISK CODEPG JR13545 DB2 UDB - SQLESRSP MARKS THE DATABASE AS BAD FOR ANY NON-ZERO RC FROM SQLRRAFI. SHOULD ONLY MARK DB BAD FOR CERTAIN NON- ZERO RC'S JR13610 ERROR LOGGED FOR SQLOFMBLK WHEN USING PREPARED STATEMENTS JR13630 SQLPLRL() TRAPS AS SQLRLGTS() NOT CLOSING CURSOR JR13633 TRAP IN MONITOR SNAPSHOT JR13661 SQL0605W WHEN CREATING TWO BI-DIRECTIONAL INDEXES WHICH USE THE SAME SET OF COLUMNS. JR13667 DB2JDBC.DLL TRAPS WHEN RUNNING WEBSPHERE IN VISUALAGE JAVA JR13675 RI PACKED DESCRIPTOR OVERFLOW IS CAUSED BY TABLENAMES > 18 CHARA CTERS APAR fixes included in U465424 (Fixpak 1) APAR No. Abstract -------- -------------------------------------------------- IX67422 NO REASON CODE IN DB2 MSG WITH SQLCODE -913. IX71710 RECLAIMED TOO MUCH LOG SPACE APPEARS DURING CRASH RECOVERY IX73726 V501: -407 SQLCODE CAUSES -984 WHICH MARKS DATABASE BAD IX76365 SLOW PERFORMANCE IX79991 CLI CHANGE: REPLACING LITERAL WITH PARAMETER MARKER IN INSERT IX80640 DB2LOOK DDL TRIES TO CREATE THE INDEX AFTER THE PRIMARY KEY CONSTRAINT WHEN KEY WAS DEFINED ON A PRE-EXISTING INDEX IX81341 DB2CKMIG SETS LOCALE AND MESSAGES PATH WHEN IT SHOULD ONLY SET THE MESSAGES PATH (RESULT CAN BE A FAILURE TO MIGRATE V2 TO V5) IX81525 SQLALLOCSTMT FAILS MEMORY CLEANUP IF OUT OF MEMORY IX81764 DB2ATLD (NEW AUTOLOADER) DOES NOT RETURN A NON-ZERO RETURN CODE IF AUTOLOADER FAILS IX81831 INDEX BUILD PHASE HUNG ON LOAD IX81849 SQLESETC API USES WRONG CONTEXT IN MULTITHREADED CLI APPS IX82027 IMPORT CAN HANG SYSTEM IF THE INPUT FILE ROW COUNT IS AN EXACT MULTIPLE OF THE COMMITCOUNT IX82054 NEW AUTOLOADER DB2ATLD ISSUES SQL3326 IF A LIST OF COLUMN NAMES ARE SPECIFIED AND ONE OF MORE NAMES ARE 18 CHARACTERS IX82394 SQL6107 WHEN TRYING TO LOAD PRE-SPLIT DATA. IX82397 DB2BATCH -O R 0 DOES NOT IF BLOB DATA IS SELECTED IX82487 OFFLINE BACKUP RETURNS SQL1042C OR SQL1084C IX82508 PATCH2=6 DOES NOT PREVENT A SCROLLABLE CURSOR TYPE IX82599 DB2 UDB RACE CONDITION IN DB2LICD. LEADS TO REMOVAL OF IPC Q 0 (USUALLY!). UNLIKELY ON NON-MLNS, POSSIBLE ON MLNS. IX82851 DB2 UDB EEE C980509 (LIKELY ALSO AFFECTS EE) RESTART FAILURE WITH RC=-2777 CAUSING SQL1042C IX82992 CALLS SQLCOLUMNS() ON VIEWS RETURNS 0 COLUMNS ON ANY VIEW THAT ENCOUNTERS SQL0437. IX83002 -1042 (SYSTEM ERROR) ON ROLLFORWARD IX83063 JDBC NEGATIVEARRAYSIZEEXCEPTION() ON EXECUTEQUERY() IF UPDATE MAKES NO CHANGES. IX83068 DB2AUTOLD LOOPS WITH JA_JP ENV IX83104 ESTORE PROBLEMS DUE TO AIX MEMORY SEGMENTS NOT ATTACHING TO OPTIMUM POSITIONS. IX83180 WHEN RUNNING THE OUTPUT OF DB2UIDDL, AN SQL0956C IS RETURNED INDICATING DBHEAP IS EXHAUSTED. IX83197 DB2ATLD MAY USE HOSTNAME FOR SOME COMMUNICATIONS, SHOULD ONLY US E DB2NODES.CFG ENTRIES IX83272 NEGATIVE RETURN CODE -502 CAUSES TRAP IN SQLJIFSR.C IX83408 FAILING BACKUP NOT RECORDED IN HISTORY FILE IX83441 THE DB2DIAG.LOG SHOWS A NO TEMP AVAILABLE ERROR MESSAGE AND A TABLESPACE STATE TRANSITION ERROR 'FFFF8138' IX83505 ON HP-UX, DB2SETUP FAILS TO CREATE AN INSTANCE WITH DBI1720E WHILE NIS IS RUNNING... USERID AND GROUP ALREADY EXIST. IX83539 -902 ON CREATE/DROP TABLE WHEN OUT OF DBHEAP IX83547 DYNAMIC DROP TABLE WAITS ON A INSERT THAT HOLDS AN NS LOCK IN SYSUSERAUTH IX83555 XA_END(TMSUSPEND) RETURNS XA_ERPROTO. IX83583 LOAD INSERT AFTER MIGRATION CAUSES TABLE CORRUPTION IX83660 SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS IX83662 SIGNAL#11 IN SQLKD_RCV_DATA IX83716 TRAP IN SQLRAGSN. CLIENT INTERRUPTED WHILE BINDING TO THE DB TRAPS THE SERVER. IX83733 DB21080 REDIRECTED RESTORE IS CASE SENSITIVE RE: DB ALIAS IX83869 CATALOGING MORE THAN 8 ODBC DATASOURCES FROM SCRIPT GIVE ERROR IX83953 DB2JD SHOULD NOT READ LENGTH INDICATOR FOR OUTPUT ONLY PARAMETER IX84081 TRAP IN SQE IX84082 CUSTOMER CAN'T RUN A JAVA STORED PROCEDURE MORE THAN ONCE WITH SOLARIS 2.6 AND JDK 1.1.6 WITHOUT RESTARTING UDB IX84273 THE 'DB2BATCH' PERFORMANCE TOOL SHOULD TRIM THE TRAILING BLANKS FROM THE LAST COLUMN IN THE OUTPUT. IX84329 LENGTH OF OUTPUT SQLVAR IS NOT INITIALIZED IX84478 TIMESTAMP RECIEVED AS STRING SHOULD RETURN AS LENGTH 26 IX84552 WE WERE CHOOSING A MGJN PLAN OVER A NLJN THAT WE USED TO CHOOSE IN V500. MGJN PLAN RUNS IN 300 SECONDS AS OPPOSED TO 3 SECONDS. IX84565 SQL0437W WARNING MESSAGE CAUSES EXPORT OPERATIONS TO FAIL. IX84582 CLP LIST TABLESPACES SHOW DETAIL DOES NOT AUTO-COMMIT. IX84780 DB2_ALL HANGS WHEN INPUT REQUIRED IX84790 SQL10003C ERROR WITH DB2/UDB FOR AIX DUE TO MEMORY LEAK. IX84896 LOG ERROR WHEN DOWNLEVEL JDBC CLIENT COMING TO JDBC SERVER IX84950 JDBC DRIVER OVERRIDES THE CLI SETTING FOR CURSORHOLD. IX85099 V5.2 NT/W98 CLIENTS TO GATEWAY TRAPING AFTER 3-4 CONNECTIONS IX85148 -902 SQLCODE ON ROLLFORWARD OF TABLESPACE TO POINT IN TIME IX85171 LOAD WITH DB2 UDB V5.2 ON HP-UX 11 SMP HAS POOR PERFORMANCE... IX85192 SQLO902 RC 26 SQLO_NOMEM_UND IN SQLRIUIN (CRASHES DB) IX85342 SIGNAL 11 IN SQLRA_FIND_SHIP_VAR (#11) IX85415 DB2 DOESN'T LINK IN THREAD SAFE CPIC LIBRARY FOR DB2DCPIC_IBM.A IX85558 SQL_ATTR_RETRIEVE_ROW IS STILL RETRIEVING DATA EVEN IF OFF. IX85645 EXECUTEUPDATE METHOD IN JDBC STILL RETURNS -1 IF NO ROWS WERE UPDATED. THE PROBLEM IS PRESENT ONLY IN JDBC NET DRIVER. IX86007 SIGNAL#11 IN SQLULADDINXKEYS IX86031 IN DB2/UDB - 'LIST HISTORY REORG SINCE' DOES NOT REPORT ALL VALID ENTRIES. IX86221 DB2 5.2: RESTORE HANGS IX86244 USE SQLOINSTANCEPATH() TO LOWER NUMBER OF CALLS TO PASSWORD FILE IX86368 SQLJMF10 TRAPS WHEN SENT A NULL POINTER IN DB2RA. IX86413 DB2 - UDB: SIGNAL 11 TRAPS AFTER HITTING AN ERROR IN SQLRXGET AND SQLRXPUT IN THE DIAG. IX86439 AUTOLOADER GENERATES 'SEVERE ERROR' WHILE SPLITTING DATA. HOWEVER THE LOAD COMPLETES SUCCESSFULLY BUT DATA IS MISSING. IX86457 SIGUSR1 IS IGNORED IN SNA/6000 V3 AND LATER IX86498 FIX LATCH/UNLATCH OF AGENT_LIST_LATCH IN SQLEGETAGENTFROMPOOL IX86517 LOAD TRAPS IN BUILD PHASE WHEN UTIL HEAP RUNS OUT OF SPACE. IX86733 DB2SETUP : INSTANCE CREATE FAILS DURING TCPIP CONFIG IX86742 TURKISH CODEPAGE: USERIDS CONTAINING THE LETTER I ARE INCORRECT- LY TRANSLATED BY DB2 INTERNALLY RESULTING IN AUTH. FAILURE. IX86861 SETNULL CAUSES TRAP WITH TIMESTAMP,TIME,DATE,BIGINT AND STREAMS IX86967 DB2 USING TOO MUCH SWAP SPACE ON SOLARIS. IX86970 NOT ENOUGH LOG SPACE RESERVED IN REORG IX86991 EXPORT NOT PARSING MODIFIED BY DELIMITERS WHEN USING WITH PROPERLY IX87048 INTERMITTENT SQL0290 DURING EXECUTION OR BIND IX87063 SQL1072 ON DB2START - FTOK CAN'T GENERATE UNIQUE IPC KEYS ON SOLARIS UFS WITH NEW DIRECTORIES WHEN RANGE OF INODES IS HIGH IX87124 SUN: ALLOCATION OF LARGE BUFFERPOOLS USING SOLARIS 2.6 (>1.6G) MAY FAIL WHEN INTRA_PARALLEL IS ON. IX87172 POOR PERFORMANCE BECAUSE STAR JOIN NOT SELECTED IX87280 ROLLFORWARD FAILS WITH SQL1271W WHILE REBALANCING IX87362 QUERY WITH 'IN' PREDICATE RETURNS WRONG RESULT IX87376 DB2PROFC TRAPS WHEN INVALID PREPAREOPTION SPECIFIED IX87446 UDF NOT MAKING FINAL CALL WHEN IT TERMINATES ABNORMALLY IX87450 FILE MANAGER EXPORT CONTROL FILE NOT BEING CREATED WHEN SPECIFIC COLUMNS SPECIFIED IN THE SELECT FROM THE EXPORT. IX87463 MULTIPLE LOGON WINDOWS WITH MSACCESS WHEN NO UID/PWD INPUT IX87478 SQLUGRPI CALL RETURNS SQL6044N IX87540 INVALID ROW COUNT RETURNED ON UPDATE WITH STREAMS (LOB) IX87634 DB2 TRAPS WHEN EXIT HANDLER CALLED IF RESOURCES ALREADY FREED IX87720 CLI SQL_CONNECT_NODE WOULD NOT ACCEPT VALUE 0 IX87741 INCORRECT ROUND FUNCTION OUTPUT. IX87839 EXCEEDING MAX APPLID SIZE OF 32 BYTES. DEFECT NUMBER 103039 IX87877 SIG#11 IN GET_DBMON_BP ON RESTART IX87910 LOCKING BEHAVIOUR AT CS TO BE CHANGED FOR BOUNDARY CONDITIONS. IX87911 DB2 UDB ERROR 28 IS INCORRECTLY RETURNED BY THE SAMPLE USEREXIT WHEN LOG FILE WE ARE TRYING TO ARCHIVE DOES NOT EXIST. IX88179 THE TYPE CASTING OF VARCHARS TO DECIMAL IN THE CREATE STATEMENT FOR UDF RESULTS IN THE LOSS OF PRECISION IX88274 HANG ON CRASH RECOVERY DUE TO LOCK-WAIT ON SYSTABLESPACES IX88408 POSSIBLE DATA INCONSISTENCY IX88449 POSSIBLE -902 WHEN USING SCROLLABLE CURSOR IX88761 QUEISCE EXCLUSIVE RESET IS NOT WAD. AFTER A USER IS FORCED OFF THE SYSTEM THE PHANTOM QUIESCE IS NOT ACQUIRE BY NEXT USERID. IX88927 DB2ADUTL EXTRACT -> CANNOT EXTRACT IMAGES > 2G IX88966 SQLDESCRIBEPARAM TRAPS IF SQLPREPARE HAS A WARNING IX88968 SQL1224 WITH 'SEGMENTED TABLE PAGE NUMBER WAS TOO HIGH' IN DIAG LOG. POOLPGNUM = 5A454B41 -> > ALLOWABLE RANGE. IX88969 DB2JD LEAVES CHILD PROCESSES WHEN APPLETS COMPLETE. IX89062 SQL0901 WHEN HASH_JOIN PLAN IS CHOSEN IX89209 ABILITY TO FIX TERRITORY FIELD FOR DATABASES MIGRATED FROM V2 TO V5 WHERE THE TERRITORY IN THE DB CFG FIELD IS NOT READABLE. IX89285 ALTER TABLESPACE ADD FAILS AFTER REDIRECTED RESTORE WITH SET TABLESPACE ... IGNORE ROLLFORWARD CONTAINER OPERATIONS IX89317 SAP - ACCESS PLAN CHANGED BY ADDING INDEXES WHICH ARE NOT USED IX89396 SIGNAL#11 IN SQLRR_OPEN IX89405 SIGNAL#11 IN SQLOLGSEMPOST IX89426 CALLING STORED PROCEDURE CAUSES GATEWAY TO CRASH IX89535 SQL0433N ON QUERY WHEN CAST FUNCTION RETURNS WRONG SQLLEN IX89661 SQL2038 RC=-1062 ON RESTORE OF DATABASE CREATED ON ROOT FILE SYSTEM I.E. ON '/'. IX89677 DROP INDEX CRASHES INSTANCE DUE TO INVALID INDEX SPACE MAP HEADER INFORMATION IX89691 TRAP IN SQL_DB2RA_AS_DB_OPEN. IX89840 REALLOCATION OF OLD LOG DURING DB TERMINATION CAUSES DB TO SHUTD OWN IX89927 CONTAINER REMOVED WHEN ROLLING FORWARD THROUGH A FAILED ADD CONTAINER FOLLOWED BY A SUCCESSFUL ADD CONTAINER IX89960 DON'T SEND EXTRA FETCH TO SERVER IF SQLCODE IS +100 IX89997 UNTYPED PARAMETER MARKERS CAST INCORRECTLY WHEN IN CLAUSE USED IY00162 SEGV IN SQLRI_HSJNNEWTUPLE() USING HASH JOINS IY00229 TQ HANG IY00230 IF SQLFREESTMT FAILS WITH -30081,DON'T RETURN SQL_ERROR ON FREE IY00268 LOAD TRAPS DURING THE BEGINING OF THE BUILD PHASE ON 4 WAY SMP BOX WITH LOAD PARALLESIM SET TO 4 IY00444 HASH JOIN USES UP ALL THE MEMORY AND CAUSES EDU CRASH. IY00480 ENSURE DB2AUDIT RETURNS 0 RC INSTEAD OF 6 WHEN SUCCESSFUL IY00674 DB2ATLD HANGS IF PLACED IN BACKGROUND WITH & AND AUTHENTICATION = NO IY00718 HASH JOIN PLAN MAY HANG IN RARE CIRCUMSTATNCES IY00761 TRAP IN SQLDDELTCB (SQLDFREETCB) ON NORMAL DATABASE DEACTIVATION PROCESS IS DB2PFCHR (PREFETCHER) IY00782 EINVAL IN SQLOCSHR IN DB2CART , SQLO_NO_SEG IN SQLGMRP FFFF D605 ALSO CRASH RECOVERY ENDING TO EARLY IY00838 USING 'CONNECT TO USER CHANGE PASSWORD' FAILS WITH SQL1403N, BUT ACTUALLY CHANGES THE PW OK... USING NIS. IY00843 IMPROVE THE HANDSHAKE BETWEEN SQE AND MONITOR CODE THAT CAN CAUSE A HANG IY00882 EVENT MONITORS WRITING TO PIPES NOT GETTING CLEANED UP ON DB2STOP FORCE - SQL1614 RC 6 TRYING TO RESTART EVENT MONITORS IY00971 SNAPSHOT DOESN'T SHOW ALL LOCKS BEING HELD IY00976 RESTORE FAILS WITH SQL0973 - NOT ENOUGH SPACE IN LOCK LIST HEAP. IY01157 RESTART FAILS, DIAGLOG INDICATES: SQLPGRLG PROBE: 0 'A CORRUPT PAGE WAS ENCOUNTERED IN A LOG FILE DURING CRASH RECOVERY' IY01281 ERRONEOUS -902 IN SQR MARKS THE DB BAD IY01282 SIGNAL #11 DB MONITOR CODE AGENT_STMT_START() IY01397 DB2 UDB 5.X: EEE SPECIFIC: PERFORM INTERNAL FABRICATE STATS PROC ESSING (IF REQUIRED) LOCALLY IF POSSIBLE IY01401 APPLICATION SNAPSHOT REPORTS THE WRONG INFORMATION IY01429 DB2 UDB 5.X MAY GIVE SQL0901 IF INTRA_PARALLEL ON IY01525 DB2LOOK DOES NOT SHOW A TABLE WAS CREATED WITH 'NOT LOGGED INITIALLY'. NECESSARY FOR THE 'ALTER TABLE' COMMAND. IY01547 FFFF8133 MESSAGES IN DB2DIAG.LOG DURING CRASH RECOVERY WHEN ACCESSING A TABLESPACE IN ROLLFORWARD PENDING - PERFORMANCE IY01644 CURSORS/LOCKS BEING CLOSED IN XA TRANSACTIONS WHICH HAVE ALREADY BEEN CLOSED. IY01726 -952 WHEN RUNNING STORED PROCEDURE TO EEE IY01782 DB2ADUTL CORE DUMPS WHEN -1 PASSED FOR N ON THE COMMAND LINE. IY01898 -1042 FROM SQLEGETAGENTFROMPOOL IN MPP WHEN THERE IS A SEND/RECEIVE COMMUNICATION PROBLEM BETWEEN NODES.DB MAY CRASH. IY01930 UPDATE/INSERT OF >150/200 ROWS EXTENDERS TABLE HANGS (SQLUIHSH) IY01933 SQL0901 REPORTED BY SQLRAFRS() IY02049 DB2LOOK CHANGES AUTHORIZATION GROUP TO USER. IY02162 MIN BUFF LSN SET TOO HIGH. THIS CAUSES RESTART TO FAIL IF SOME ESSENTIAL LOG RECORDS DO NOT GET REPLAYED. IY02408 DB2 UDB - HANG ON INDEX REBUILD ATTEMPT. IN THIS CASE, INDEXREC WAS SET TO RESTART - SO THE CONNECT ATTEMPT WAS HANGING. IY02708 DEAD LATCH DURING CREATE TABLE WITH PRIMARY KEY IY02888 SQL1246N USING API SQLESETC JR11822 LOAD OF DEL ON NT CAUSES DB2 TO TRAP, AND DB2 TO BE INCONSISTENT FUNCTION NEEDED FOR USE OF ZIP/JAZ DRIVES JR11966 DB2SYSC TRAPS ON NT LOAD OF ASC JR12000 MULTITHREADED APPLICATIONS TRAP IN UDB JR12221 OPTIMIZER BUG FOR HOST VARIABLE FILTER FACTORS AND RUNSTATS JR12258 MS ACCESS USES TYPE TIMESTAMP FOR TYPE DATE FIELDS. JR12333 TRAP IN DOWN LEVEL CLIENT. JR12353 RESTORE FROM BACKUP ON DISKETTES FAILS JR12355 LOADING BLOB COLUMN LARGER THAN THE TARGET GIVES SQL3408, BUT ERROR MESSAGE REFERS TO THE PREVIOUS COLUMN. JR12356 NT: 192 MB FILE CACHE LIMIT HIT WHEN DB2NTNOCACHE SET TO 1. 'FFFFB5AA' MSGS IN DB2DIAG.LOG, TBSPCS PUT INTO RF PENDING. JR12409 SQL_C_NUMERIC BINDING FROM VISUAL BASIC SUPPORT TO BE ADDED. JR12410 DB2 UDB V5.00 TRAPS WHEN SYNTAX OF A QUERY WITH ORDER BY IS INCORRECT ON WINNT. JR12414 IMPLEMENT VARIALBE TAPE BLOCK SIZE FOR THE DB2 BACKUP COMMAND ON THE INTEL PLATFORM. JR12424 NULL INDICATOR NOT BEING RESET JR12444 SQL0104 FOR OUTER JOIN FROM MS ACCESS TO MVS JR12452 MEMORY LEAK WHEN USING CLI APPLICATION TO HOST FROM DB2 CONNECT JR12467 UNINSTALL DOES NOT REMOVE *.OUT FILES FROM DAS INSTANCE DIRECTORY. JR12498 SQLEXECUTE DOES NOT INSERT ALL COLUMNS PROPERLY JR12508 SQL1026N FOLLOWED BY SQL1032N WHEN ISSUING MANY DB2STARTS JR12509 CLI0113E WHEN STORED PROCEDURE RETURNS DATE NOT IN ISO FORMAT TO A CLI APPLICATION. JR12512 MEMORY ACCESS VIOLATION OR TRAP WITH MULTIPLE ENV. HANDLES JR12546 NT: RESTORE TRAPS WHEN THE FULL PATH TO THE BACKUP IMAGE IS SPECIFIED IN THE RESTORE COMMAND (CLP OR CC). JR12555 REMOTE DB BACKUP TO ADSM VIA NT CLIENT CONTORL CENTER WITH SESSIONS > 1 FAILS WITH SQL2032. JR12563 FFFF877E IN DB2DIAG.LOG AND -901 IN DB2 TRACE ON INSERT/UPDATE/D ELETE JR12582 DB2 TRAPS (NT TRAPS IN DB2SQN.DLL) WHEN THERE IS A 'TYPO' AFTER A GROUP BY CLAUSE... JR12594 SQL3124W ON LOAD OF ASC FILE WITH PACKEDDECIMAL OPTION WHEN THE FILE HAS CORRECT STRUCTURE. JR12595 ALWAYS RETURN CATALOG SEPARATOR TO BE '.' INSTEAD OF HAVING TO USE PATCH2=11 JR12611 MESSAGE DIA99999 IN FUNCTION SQLPGMRP PROBE:100 SHOWS AFTER DB2 FAILS TO ARCHIVE A LOG JR12613 DB2 COMMON SERVER - CRASH RECOVERY FAILS WITH -2775 MESSAGES IN THE DB2DIAG.LOG FILE. JR12618 SYS3175 RETURNED FROM OS/2 WHEN RUNNING A USER EXIT TO BACKUP A DATABASE REPEATEDLY... JR12646 OS/2: SQL1038C ON DB2START WHEN USING A FAT FILESYSTEM. JR12669 SLQSTATE -1106 LOGGED IN DB2DIAG.LOG WHEN PERFORMING IMPORT FROM A REMOTE MACHINE TO A WINDOWS SERVER. JR12673 SQL0901N INDEX OUT OF RANGE, UDB PARSER PROBLEM JR12681 EVEN WHEN THE OPTIMIZE FOR N ROWS IS ON DB2 CONNECT WILL CONTINUE SENDING PRE-FETCH REQUESTS TO THE HOST. JR12689 REDUCE MSGS IN DB2DIAG.LOG CAUSED BY CONVERSION FILES JR12702 DRDA AS TRAPS OUTBOUND TO ANOTHER LOCAL INSTANCE JR12713 FFFFF616 IGNORED CAUSING DATABASE CORRUPTION JR12719 FILE_TRANSFER_CMD OPTION OF THE DB2 AUTOLOADER CONFIGURATION FILE DOES NOT CALL A BATCH FILE. IT DOES CALL AN .EXE FILE. JR12721 IF THE IN PREDICATE OF THE WHERE CLAUSE IN A SELECT STATEMENT HAS MORE THAN 284 ITEMS, THE ENGINE TRAPS. JR12731 DDL FOR CREATE TABLE INCORRECT WHEN DBNAME IN DB2CLI.INI FILE JR12732 5.2:SQL0956 / SQL1478 AFTER ALTERING V5GA BUFFERPOOLS JR12734 CCA IMPORT ONLY PICKS UP ONE INSTANCE IF MULTIPLE DEFINED FOR A SYSTEM. JR12745 SQLBINDPARAMETER() DOES NOT HANDLE BEING PASSED A COLUMN SIZE OF ZERO PROPERLY AT FP 7 (WR09084). JR12748 SYMBOLS FOR GENERIC API LIBRARY NOT EXPORTED IN UDB VERSION 5/5.2. NT BUILD DOES NOT EVEN HAVE THE OBJECT FILES. JR12788 TRAP ON CONNECTION TO DB2 / MVS WHEN CURRENTSQLID SET JR12797 NULL INDICATOR NOT BEING RESET IN JDBC APPLICATION USING THE 'NET' DRIVER. JR12804 SETXXXSTREAMS BROKEN IN THE 5.2 NET DRIVER JR12809 MEMORY LEAK IN DB2JD.EXE DEFECT 101809 JR12812 BIND MESSAGES TRUNCATED IN CCA JR12819 IMPORT OF EXPORTED CLIENT PROFILE IN CCA FAILS CCA3002N IF PATH CONTAINS LONG NAMES WITH BLANKS JR12822 NT EVENT LOG FILLS UP WITH SQL0502 AT DIAGLEVEL 4 WITH VB (ODBC JR12881 MEMORY CORRUPTION WHEN COPYING INTO CACHED DA. JR12885 USING ADO IN VB TO RETRIEVE PACKED TYPE FROM A MVS RECEIVES 'INVALID PRECISION' ERROR. DEFECT #103555 JR12894 RANDOM TRAPS IN SQLRA_CACHE_DEL_VAR WHICH ARE MANIFEST AS EITHER INSTANCE HANGS OR CRASHES. DIAG FILE 0XA602. JR12915 GATEWAY CRASHES IN COLUMNNAMES LIST DURING A CALL TO A SP JR12918 TABLETYPE KEYWORD NOT EXCLUDING SYNONYM TABLE TYPES JR12919 UNDERDBDIR FIELD OF SQLB_TBSCONTQRY_DATA STRUCTURE IS NOT REVERSED WHEN USING SQLBTCQ API ON NT AND CONNECTING TO AIX. JR12948 APPLETSECURITYEXCEPTION WITH APP DRIVER DUE TO SYSTEM PROPERTIES JR12958 PRECOMPILER GENERATES DIFFERENT SQL TYPE FOR CHAR HOST VARIABLES INSIDE A STRUCTURE DEPENDING ON LOCATION OF SHORT HOST VARIABLE. JR12989 CALL TO SQLESTAT FAILS WITH SQL1428 WHEN ATTEMPTING TO COLLECT DB INFORMATION FROM BOTH LOCAL AND REMOTE DBS IN ONE PROCESS JR12995 WHEN USING A JAVA APPLET (JDK 1.2) TO SELECT FROM A CHAR COLUMN OF AN MVS TABLE, THE DATA IS SOMETIMES TRUNCATED. JR12996 TRAP IN SQLJMF06() IN SQLJMFR1.C WHEN WE TRY TO SET THE EXPECTED OUTPUTFLAG VARIABLE THAT INVOLVES SQLE_DB2RA_DB_EXECUTE_FLAGS JR13006 DB2ENG.DLL TRAPS BY BACKUP USING USEREXIT ON OS/2 SMP MACHINE AND/OR INTRA_PARALLEL YES - TRAP IN SQLEBUILDBDSUNIQUEID JR13009 SQL1109N 'DLL NOT FOUND' WHEN CALLING A JSP WITH POWERBUILDER DEFECT#: 108302 JR13027 OPTIMIZER PLAN INCORRECT WHEN HANDLING NULLS IN INDEXES. JR13043 DB2 BACKUP DATABASE COMMAND ON NT FAILS WITH SQL2025 RC 1450 ERROR_NO_SYSTEM_RESOURCES JR13056 TRAP IN SQLNO_COST_NLJN - THIS APAR IS TO PROVIDE MORE INFORMATION IN DB2DIAG.LOG (-901) IF TRAP OCCURS AGAIN. JR13076 MEMORY LEAK IN JVM WITH JAVA UDF JR13103 DB2 UDB V5 FIX FOR WEBSPHERE 3.0 JR13106 BRAZIL LOCAL DATE FORMAT (DD.MM.YY) DOES NOT WORK (ISO INSTEAD) JR13114 DB2DEFPREP=YES NOT DISABLED FOR PREPARE WITH INTO CLAUSE JR13125 SELECT STAT WITH MULTIPLE WHERE CLAUSES SEPERATED BY OR DOES NOT RETURN ALL OF THE DATA JR13141 CATALOGGING RETURNING A SQL1092 ERROR WHEN MEMBER OF ADMINISTRATOR GROUP AND A DOMAIN USER JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13153 DB2 CONNECT GATEWAY TRAPS WHEN LARGE ARRAYS PASSED AS INPUT PARAMETERS. JR13156 PARAMETER MARKERS IN JDBC APPLICATION ARE BEING BOUND WITH THE WRONG SIZE CAUSING CLI0109E STRING DATA TRUNCTION ERRORS. JR13169 #DELETED GETS DISPLAYED IN MS ACCESS WHEN DISPLAYING A DB2 TABLE THAT HAS A PRIMARY KEY ON A DATE COLUMN OR DECIMAL COLUMN JR13194 ADDING ACCOUNT STRING FOR MVS TO THE DB2CLI.INI FILE DEFECT ACTION PLAN: 116373 JR13200 SETTING BOTH ODBC 2.0 AND ODBC 3.0 ENVIRONMENTS DEFECT # 116384 JR13223 CALLING STORED PROCEDURE AGAINST DRDA HOST RETURNS SQL - 1224, -902 OR NO RESULTS WHEN THERE SHOULD BE. DEFECT 116964 JR13306 CLI MEMORY INTIALIZATION PROBLEM CLI0112E ERROR IN ASSIGNMENT JR13311 TRAP IN 'SQLMON_DCS_STMT' ON DB2 CONNECT EE 5.2 WHEN MONITOR HEAP EXHAUSTS. JR13315 DRDA STREAM TERMINATING WITH CM_PROGRAM_ERROR_PURGING WHEN PASSING SQLDA TO HOST. JR13332 CHANGE PASSWORD FOR 8 CHAR USERIDS RETURNS INVALID USERID. JR13354 SQL 1404 FROM MVS IS IGNORED BY CLI (ODBC) APPLICATIONS DEFECT # 120629 JR13363 CCA CANNOT TRUNCATE COMMENT FIELD ON ADD DATABASE. JR13402 NAME SHARED EVENT SEMAPHORES MAY NOT BE UNIQUE WITH MULTIPLE INSTANCES, CAUSING THEM TO BE POSTED BY ANOTHER PROCESS. JR13405 APPL_NAME OPTION OF THE CREATE EVENT MONITOR COMMAND DOES NOT WORK. THE PROBLEM WAS DETECTED WITH NT, NOT AIX. JR13427 CHANGING ISOLATION LEVEL AFTER EXECUTE CAUSES ERROR ON NEXT EXECUTE JR13428 MEMORY LEAK WITH UDF'S IF RETURNING BLOBS OF VARYING SIZE JR13432 JDBC 2.0 SETDATE(NULL) FOR DATE PARAMETER MARKER TRAPS JR13433 JDBC DRIVER TRAPS AFTER MANY FAILED CONNECT ATTEMPTS JR13448 TRAP IN SQLOXULTEX RUNNING UNFENCED UDF ON SMP JR13488 SQLCOLATTRIBUTES DOESN'T RETURN NULL STRING WITH SQL_DESC_BASE_T ABLE_NAME