************************************************************ Product Name : DB2 UDB V7 for OS/2 PTF Number : WR21312 Package Date : Tue Nov 19 10:49:53 EST 2002 Build Level : s021110 ************************************************************ APAR fixes included in WR21312 (Fixpak 8) APAR No. Abstract -------- -------------------------------------------------- GG04256 ON WINDOWS 2000 SERVER DPROPR CAPTURE FAILS TO STOP WHEN ASNCMD STOP IS ISSUED GG04305 DPROPR CAPTURE- POTENTIAL DATA LOSS WHEN HANDLING DEADLOCKS ON REGISTRATIONS GG04306 DPROPR APPLY GETS ASN1067E EVEN WHEN THERE ARE NO CONFLICTS. GG04308 DPROPR APPLY GETS ASN1067E WHEN THERE SHOULD BE NO CONFLICT UNDER SPECIAL CIRCUMSTANCES. GG04309 ASNSAT SAYS IT IS SUCCESSFUL ALTHOUGH APPLY FAILED AT THE START ITSELF WITH SQL0551N GG04311 AFTER DB2 V7 FIXPACK7, WHEN REPLICATING FROM VM TO NT APPLY FAILS WITH SQL0204N ON SYSIBM.SYSTABLES IC33488 QUERY REWRITE : PREDICATE TRANSITIVE CLOSURE IS NOT APPLIED ON THE NULL PRODUCING SIDE OF OUTER JOINS IC34446 QUERIES USING THE LSDC BLAST WRAPPER AND NCBI BLASTALL VER 2.2.3WILL RETRIEVE AN INCORRECT VALUE FOR THE SCORE COLUMN IC34516 CUSTOMER USING THE INPUT SHAPE FILE THAT EXCEEDS THE MAXIMUM SIZE AND CAUSES DB2 TO CRASH. IY16549 PERFORMANCE PROBLEM WHILE DB2_CORRELATED_PREDICATES REGISTRY VARIABLE IS ON. IY22265 A MEMORY LEAK IN DB2SECD. IN A DCE CALL (GSS_ACCEPT_SEC_CONTEXT)DB2SECD INCREASES BY 4K EVERY 10 TO 60 CONNECTIONS. IY24131 NIS USER CAN CONNECT TO DB WITH EXPIRED PASSWORD IY26331 SQL0902 RC=143 ON DROP TABLE OPERATION. THE RETURN CODE CANNOT BE INTERPRETED. THE REAL PROBLEM IS A DAMAGED HISTORY FILE. IY26388 SIGNAL 11 IN SQLBLATCHUNPINNEDPAGE WHEN THERE IS A MEMORY ALLOCATION FAILURE FROM SQLBREADPAGEFROMCONTAINER. IY27032 ONLINE BACKUP TO TSM FAILS WITH -50 DUE TO ABYSMAL BACKUP PERFORMANCE. IY28736 INSERT INTO TABLE CREATED AS A LIKE OF A TABLE WITH AN IDENTITY COLUMN WHICH HAS BEEN ALTERED WITH RESTART FAILS WITH SQL0359N IY28923 ENABLING CLI TO HANDLE NULL TERMINATING CHARACTERS TO ENABLE SET PATCH2=52 PRIOR TO FP7, OR PATCH2=53 AFTER FP7 IY29136 SQLGETINFO RETURNS WRONG INFO FOR SCROLLABLE CURSOR WITH 390 V7 IY29206 WHEN TAKING CLI TRACE OF PERL DBI PROGRAM, VALUES PASSED DURING SQLEXECUTE NOT CAPTURED IN TRACE. IY29327 PERFORMANCE DEGRADATION IN UPDATE TRIGGER FROM V6 TO V7 IY29548 ONLINE BACKUP CAUSED DEADLATCH PREVENTING NEW CONNECTIONS TO THE DATABASE TO COMPLETE SUCCESSFULLY IY29832 COSTING CHANGE TO MSJN. INCLUSION OF ADDITIONAL DETAILS IN REGARDS TO EFFHIGH2KEY. IY30070 -551 WITH MULTICONNECT=3 IN CLI IY30116 JVM COMES DOWN AS A RESULT OF BAD POINTER PASSED TO MEMCPY BY DB2 CLIENT CODE. IY30303 THE ASNSAT PROGRAM DOES NOT DUPLICATE IY30655 V8 CLIENTS RUNNING ODBC/JDBC APPS REQUIRE A FIX TO THE DESCRIBE INPUT SUPPORT TO BE APPLIED TO THE V7 SERVER IN ORDER TO CONNECT IY30712 INDEX BUILD CHOOSES TEMPORARY TABLESPACE WITH LARGEST PAGESIZE WHEN LARGER SPACE WITH SMALLER PAGESIZE IS AVAILABLE IY30735 FORCE FAILS TO FORCE OFF AN APPLICATION IN COMPILING STATE IY30839 CONCURRENCY ERROR WITH CURSOR STABILITY ISOLATION LEVEL IY30930 SETOBJECT METHOD TRUNCATES THE VARIABLE TO 254 CHARACTERS WHEN USING TYPES.VARCHAR. IY30938 TIMING HOLE IN DARI CLEANUP LOGIC CAUSES DB2SYSC TO ABEND IY30949 SQL2009 DURING ONLINE BACKUP DUE TO FRAGMENTATION IN DATABASE SHARED MEMORY SET IY31155 LOCKS ON SYSPROCEDURES TABLE WHEN REBUILD A SP IN SPB IY31194 CREATE EXTENDED INDEX ON AN ADT COLUMN OF TYPED TABLE FAILS IY31235 SORT RECLEN LIMIT EXCEEDED IN FUNCTION SQLSTABLEINFOSETUP() WHEN DURING QUERY USING ABSTRACT DATA TYPES IY31262 THE JAVA_HEAP_SZ LIMIT WAS NOT SET WHEN STARTING JVM IY31268 DB2AGENT MEMORY FOOTPRINT INCREASED BY 600K ON V7.2 FIXPAK 3 DUETO LICENSING CHANGES - UNIX ONLY. THIS APAR REVERSES INCREASE. IY31282 DB21101E - CLP CALL SP ON AS/400 FROM THE UDB GATEWAY WHEN THE SP PARAMETER ORDER IS OUTPUT - INPUT IY31313 EXPORT FAILS TO EXPORT DBCLOB COLUMNS > 559 IY31330 DB2 CRASHED IN LOG_EVENT() WITH SIGNAL #11 IY31332 SQLYA_FREE_ADT_MBS: MB MUST POINT BACK TO ADT PASSED IN - WHEN RUNNING QUERY WITH ABSTRACT DATA TYPES IY31391 EEE : FCM BUFFERS CORRUPTIONS DURING GLOBAL SNAPSHOT MONITORING IY31392 EXPORT DATA UNDER ONE CODEPAGE AND LOAD UNDER NEW WILL FAIL WITHSQL1224 USING LOB/CLOB/BLOB COLUMNS IY31449 DB2OSCONF IS SENSITIVE TO THE SOLARIS OS LEVEL (32 OR 64BIT). IY31481 SQL0259 WHEN TRYING TO ADD MORE PAGES TO A DMS CONTAINER USING ALTER TABLESPACE...EXTEND COMMAND. IY31487 CONTROL CENTER FUNCTIONALITY IMPACTED IF DB2 INSTANCE NAME IS CONTAINED WITHIN THE ADMIN SERVER INSTANCE NAME. IY31549 PREVENT INVALID POOL STATE TRANS. DURING CONCURRENT BACKUPS ON SAME TBSPS IY31614 DB2LOOK ALWAYS BINDS WHEN AGAINST DB2 ON OS390 IY31621 OPTIMIZER NOT CONSIDERING TO USE DISTRIBUTION STATS WHEN GRAPHICCOLUMN IS NOT CASTED. IY31656 LONG COMPILE TIME ON EEE FOR COMPLEX QUERY WITH DISTINCT AND LOJ. IY31657 RUNNING JAVA APPLICATION IN VAJ IDE TRAPS AT DB2DRIVER_SQLFREEENV. IY31680 ON UNIX MACHINES, SCRIPTS ARE ALWAYS MARKED 'SUCCESSFUL' EVEN IF THEY FAIL. IY31691 CALLING STORED PROCEDURE FROM OS/390 IN DB2 FP5+ GETS ERROR SQL30020 RC=124C (SQLSTATE 58009) IY31714 RECOVERY, ROLLFORWARD, OF A NON-RECOVERABLE LOAD MAY RESULT IN RECOVERY FAILING WITH MEMORY ERROR FROM LOB MANAGER. IY31728 INSTANCE FAILS AUTO START WITH CSH. IY31773 SQL30082 ISSUING THE AUTO USER MAPPING CMD ON FEDERATED INSTANCE IY31783 CRASH IN DURING LOAD DELETE PHASE WITH CODESET UTF-8, US. IY31851 TRAP OCCURRED IN SQLNS_EXPAND_SQL_FNCS_IN_OPR WHEN TRYING TO USEA METHOD WITH A RETURNS VARIABLE IY31887 CLI PACKAGES NOT CREATED WITH EXPLICIT BIND COMMAND AND CLIPKG IY31954 INCORRECT TABLESPACE SNAPSHOT OUTPUT FOR VALUES RELATED TO ESTORE. IY31956 CUSTOMER ATTEMPTS RETRIVE RESULT SET FROM AS400 USING DB2CONNECTWITH STORED PROCEDURE ENCOUNTERS SQL30020 AND DIA4803. IY31958 DB2DART /DDEL DOES NOT DUMP OUT DECIMAL COLUMN VALUES CORRECTLY. IY31967 ENABLE DB2 TO HANDLE TRAILING BLANK CONSISTENTLY FOR RI PD (PACKED DESCRIPTOR). IY31970 TO PROVIDE A DB2CAT TOOL TO FIX RI PD (PACKED DESCRIPTOR) FOR A TABLE. IY32030 INFINITE LOOP IN DB2 LOCK LIST FORMATTER WHEN NEXT LRB IN LOCK'STRANSACTION CHAIN IS ITSELF IY32077 SOLARIS THREAD LIBRARY BUG 4533861 CAUSES DB2 TO CRASH / HANG. DB2 NEEDS TO LINK TO THE NEW ALTERNATE THREAD LIBRARY. IY32093 WHEN PARTITIONING KEY INVOLVES UDT, AUTOLOADER RETURNS -2038 DURLOAD. IY32104 STORED PROCEDURE PERFORMANCE WITH LARGE PARAMETERS IY32138 DB2PROFC AGAINST HOSTDB GETS SQL4912N WHEN HOST VARIABLE FOR GRAPHIC COLUMN HAS LENGTH MORE THAN 127 IY32147 ADD SUPPORT TO USEGRAPHICCODEPAGE MODIFIER IN IMPORT/LOAD IY32179 SQL1056N OPEN SCANS NOT RELEASED WHEN CLOSING THE CONNECTION IY32251 SQL0901 WITH RETURN MESSAGE 'BAD OUT/IN COMPARE2' RETURNED WHEN RUNNING A QUERY FOR A USER DEFINED TABLES. IY32330 DCTM WRAPPER: SUPPORT FOR DCTM_INTEGER MISSING IY32333 FFFFD602 OUT OF DATABASE HEAP MESSAGES AFTER UPGRADING TO FIXPAK4 WITH BUFFERPOOL MONITORING AND LARGE NUMBER OF TABLESPACES. IY32340 INSERT INTO CLOB FAILS IN JDBC APP DRIVER WITH SQL0138 IY32396 FEDERATED DB CAUSES SLOW QUERY RESPONSE IN PASSTHRU MODE IY32407 FILTER FACTOR GETS SKEWED DUE TO STANDARD FUNCTION TYPE BEING APPLIED. IY32463 SQL2048N WITH RC=8 RECEIVED WHEN AUTOLOADER ATTEMPTS TO LOAD A LOT OF DUPLICATE ROWS INTO A TABLE. IY32472 WHILE CLP TREATS SPS AS SINGLE UOWS, CLI DOES NOT. APAR IS TO MAKE THEM MORE CONSISTENT. IY32473 REBIND NOT BEING DONE CORRECTLY WHEN THE BIND WAS NOT DONE CORRECTLY BY THE APPLICATION, CAUSING SQL0301N IY32499 SCRIPT FILE PERMISSION INCORRECT LACK EXECUTABLE PERMISSIONS /OPT/IBMDB2/V7.1/HA/UTIL IY32506 DB2 CONNECT RETURNS SQL1091 AFTER BACKING OUT A VERSION 7 FIXPAK. THIS IS AFTER THE DB2UPDV7 SCRIPT IS RUN. IY32511 DB2RA UNALIGNED ACCESSES ADVERSLY AFFECTING PERFOMANCEOF REMOTE COMMUNICATION WITH SERVER IY32536 OPTIMIZER CALCULATING SELECTIVITY INCORRECTLY IN A CASE WHERE COLUMN IS ALL NULL AND NUMNULLS > CARD. IY32652 'ALTER TABLESPACE....EXTEND' COMPLETES SUCCESSFULLY: HOWEVER, THE TABLESPACE CONTAINERS ARE NOT EXTENDED IY32654 WHEN USING THE LIKE PREDICATE FOR GRAPHIC COLUMN TYPE, WE DO NOTCONSIDER USING 'START/STOP KEY' FOR THE INDEX, WE USE SARGABLE. IY32659 DB2STOP DROP NODE NODENUM FAILS IY32675 QP CRASHED AND FAILED TO RESTART. A RESTART WAS POSSIBLE ONLY AFTER DELETING ROWS OF AN INVALID USER ID IN THE IWM JOB TABLE. IY32684 DB2LOOK -F OPTION PRODUCES WRONG VALUES. IY32709 INSTANCE MIGRATION TO DB2 V7 FROM PRIOR VERSION RESULTS IN INCORRECT SQLDBDIR. IY32762 STORED PROCEDURE BUILDER BASIC PARSER NOT ABLE TO PROCESS A LARGE SIZE JAVA STORED PROCEDURE CODE IY32783 OUTER JOIN CONVERTED TO INNER JOIN WHEN OR PREDICATE IS PRESENT IY32790 NULLPOINTEREXCEPTION IN ...JDBC.APP.DB2RESULTSET.GETCOLCOUNT IY32854 SET WALKING FILTER FACTOR CORRECTION IY32856 QUERY RE-WRITE TO REMOVE 'IS NULL' WHEN NULL IS NOT POSSIBLE. IY32886 SQL_SUCCESS_WITH_INFO AFTER CODEPAGE CONVERSION IY32934 WEBSPHERE RECIEVES CLI0119 WHEN DOING AN XACONNECT WITH A BAD PASSWORD. IY32940 WRITE RESUME OPERATION HANGS WHILE A WRITE SUSPEND IS PROCESSING IY32941 -901 ON RUNNING QUERY WITH FETCH FIRST N ROWS CLAUSE IY32943 CLI0125E ON SQLFETCH WHEN AUTOCOMMIT IS TRUE AND THE BINDING COLUMN SIZE OF INPUT PARAMETER IS >4000. IY32989 APPLY AIX AT FP7 LEVEL RECEIVES SQL1403N USING PASSWORD FILE. IY33012 FIX TO AVOID A UNNECESSARY DESCRIBE WHEN DESCRIBE NOT SUPPORTED. IY33032 START WEBSPHERE ADMIN SERVER CRASH WHEN LOADING JDBC LIBRARY DUETO DB2 WRONG CODEPATH IY33090 TWO APPLICATIONS TRYING TO REBUILD THE INDEX AND WHEN ONE OF THEM FAILS IT CAN CAUSE SUBSEQUENT INDEX CORRUPTION OR -901 ERROR. IY33092 USER DEFINED TYPE MAPPING FOR FEDERATED DATABASES NOT PICKED UP IF DEFAULT TYPE MAPPING EXISTS IY33096 SQLDRIVERCONNECT() CRASHES-RUNNING-RELIABILITY TESTS SIEBLE7.5. IY33112 AFTER RECOVERY, CAPTURE RECEIVES SQL2650, RC=5 IY33122 INFINITE LOOP CAUSED WHEN AN UNDO OF AN INSERT OCCURS AT THE SAME TIME AS A CURSOR SCAN. IY33203 DPROPR CAPTURE NEEDS TO READ TOO FAR IN THE DB2 LOGS UNDER CERTAIN CONDITIONS IY33216 TRAP OCCURRING WHEN SQLJG_SQLDTARD_DTA_STORE FREES MEMORY. IY33333 POSSIBLE TABLESPACE CORRUPTION WHEN ROLLFORWARD THROUGH FAILED REORG IY33343 MALLOC ERROR MESSAGE ARE GIVING WRONG ROUTINE AND WRONG SIZE OF REQUEST. IY33357 CRASH IN SQLOFMBLK CALLED FROM SQM_STMT IY33377 CREATE UNIQUE INDEX MAY GIVE SQL0603N IF INSTANCE IS 64 BIT AND DATABASE CODESET UTF-8 AND COLLATING SEQUENCE IDENTITY_16BIT IY33385 SQL0302N OR CLI0002W CODE RETURNED DEPENDING ON WHETHER DATABASEIS UNICODE OR NOT. SHOULD BE SAME CODE AS ORACLE AND MSQL. IY33408 BLAST WRAPPER: DEFLINE PARSING BROKEN IY33432 LOCK ESCALATION PROBLEM. PROBE:30 FROM SQLPLUHD IN DB2DIAG.LOG RESULTING IN DATABASE CRASH. IY33442 DB2DARI INTERMITTENLY TRAPS WHEN STORE PROCEDURE RETURNS MULTIPLE CURSORS IY33466 ALLOW BUIDING OF JAVA STORED PROCEDURES FROM V7.2 CLIENT TO A V8UDB SERVER IY33475 SQL0444N WITH FUNCTION MAPPINGS THAT HAVE A TEXT COLUMN IY33476 PASSING A 0 LENGTH DAD FILE TO THE DXXGENXML AND DXXRETRIEVEXML STORED PROCEDURE CAUSED DB2 TO CRASH. IY33479 COMPARISON OF 2 UNICODE STRINGS WAS DONE INCORRECTLY IN THE XML EXTENDER CODES, CAUSING INTERMITTENT FAILURE. IY33517 FIX INCORRECT UPDATE OPERATION CAUSED BY INCORRECT PREDICATE HANDLING. IY33518 POSSIBLE MEMORY OVERWRITE AND OR CORRUPTION OF THE STACK IY33519 TSM LIBRARY MAY CAUSE A SEGMENTATION VIOLATION WHEN ATTEMPTING ARESTORE USING A TIMESTAMP OF AN IMAGE THAT DOES NOT EXIST. IY33528 A CORRELATED SUBQUERY MIGHT BE WRONGLY DECORRELATED IF IT AND ITS OUTER QUERY REFER A SAME BASETABLE MORE THAN ONCE. IY33543 TO IMPROVE PERFORMANCE, I/O ACTIVITIES HAVE TO BE REDUCED IY33558 THERE IS A POTENTIOAL PROBLEM IN COMPOSITION USING RDB_NODE MAPPING: IT MIGHT CAUSE DB2 TO CRASH DUE TO MEMORY OVERRIDE. IY33673 WHEN THE ABSTRACT DATA TYPE IS USED IN A SELECT STATEMENT, THE INSTANCE CRASHES IY33712 PREDICATE FACTORIZATION CAUSING PERFORMANCE REGRESSION IY33751 'BYTES' NOT 'PAGES' FOR THE ROWS 'EXTENT SIZE' IN LIST TABLESPACES OUTPUT IY33754 TRAP IN CLI ON REDESCRIBE IY33810 DB2LOOK -X OPTION DOES NOT GENERATE GRANT STATEMENT FOR LOAD AUTHORITY. IY33811 SQL1042 RECEIVED WHEN ISSUING A GLOBAL MONITOR SNAPSHOT. DB2DIAG.LOG CONTAINS SQM_AGGR_SNAPSHOT_BUFFER::AGGRE ENTRIES. IY33823 SQL0206N ON BEFORE-IMAGE COLUMN NAME FOR 18 CHAR COLUMN NAMES AFTER UPGRADING TO FIXPACK7 OF V7. IY33851 A SELECT QUERY ON A VIEW CRASHES THE INSTANCE WITH SIGNAL #11 TRAPPING IN THE FUNCTION SQLNQ_QUNQPULL_UP_ORDER_OF IY33865 EXTRACTCHARS FROM XMLCLOB WILL CAUSE DB2 DARI TO TERMINATES IF THE CLOB SIZE IS GREATER THAN 512 BYTES. IY33876 WITH JDBC NET DRIVER, ONE CAN'T SETNULL(1, TYPES.BINARY) A COL DEFINED AS VARCHAR FOR BIT DATA WITHIN A JDBC BATCH OPERATION. IY33879 DOING A RUNSTATS ON A SPECIFIC INDEX AFTER ANY COLUMN ON THE TABLE IS RESIZED WILL CORRUPT THE DISTRIBUTION STATS IN THE PD IY33897 DB2BP TRAPS WHEN EXPORT/IMPORT USING HIERARCHY TABLE IS ISSUED. IY33908 SIGSEGV 11 FAILURE (CORE DUMP) IN SQLFETCH API. IY33924 REPLICATION FAILS WITH ERROR 'DIA4804E - DRDA DATASTREAM PARSINGERROR' WHEN MONITORING IS ON. IY33946 WRONG SCHEMA USED IN INCREMENTAL REBIND OF STATIC CURSORS CREATED WITH VALIDATE RUN IY33949 SQL0973N (NOT ENOUGH STORAGE) IN APP_CTL_HEAP OR SQL0423N IN SQLRH_FREE_N_HANDLE - MEMORY LEAK IN LOB PROCESSING IY33965 MEMORY LEAK WITH DPROPR CAPTURE WHEN HANDLING LONG VARCHARS IY33999 LSDC DOCUMENTUM WRAPPER FAILS TO HANDLE TIMESTAMP DATA TYPES CORRECTLY, CAUSING AN ENGINE CRASH IY34000 THE LSDC BLAST WRAPPER DOES NOT SUPPORT EXECUTION ON AN SMP SYSTEM. IY34001 MACRO TRAPS BECAUSE A POINTER TO SQLDA AREA THAT IT USES CAN SOMETIMES BE NULL. IY34002 PERFORM UPDATE TO DB2 390 WITHIN AN XA COORDINATE TRANSACTION. CALL MQCOMMIT (ISSUE XA_PREPARE AND XA_COMMIT). XA_COMMIT HANGS IY34003 TABLESPACE ROLLFORWARD THROUGH A REORG MAY FAIL IF ONE OF THE TABLESPACES IS TAKEN OFFLINE IY34021 A FEDERATED QUERY INVOLVING COMMON SUBEXPRESSIONS (CSE) CRASHES THE OPTIMIZER WHEN RUN. IY34061 SUBSEQUENT ROLLFORWARD AFTER RESTORE CAUSES SIGSEGV#11 TRAP IN SQLRL_OPEN IY34069 DATABASE HISTORY RECORD FETCH MAY FAIL WHEN READING LONG COMMANDTEXT INTO SMALL HISTORY RECORD BUFFER. IY34101 CLI REDESCRIBE CAUSES TO COMMIT JDBC'S EXECUTEBATCH IY34108 SQLSTATE 01517 FROM CLI WITH JAPANESE CODEPAGE IY34109 CLI NOT RE-INITIALIZING, WRONG HEX DATA INSERTED IN UNICODE ENV. IY34111 J2EE, JDBC SECURITY NEEDS TO USE DOPRIVILEDGED( ). IY34122 ON 64BIT MACHINE, DECRYPT_VARCHAR FUNCTION RETURN -901 IY34147 SEGMENTATION FAULT IN SQLOICONV WITH UNICODE CLI APPLICATION IF CLI TRACE IS ON IY34193 KATAKANA COLUMNS RETURING '-' WHEN SELECTED FROM NICKNAME. IY34212 MALLOC WHEN PROCESSING LONG VARCHARS / COULD SOMETIMES CAUSE DATALOSS IN LONG VARCHAR COLUMNS IY34214 DB2DIAG.LOG ENTRY THAT CONTAINS A FAILURE IN SQLUHUPDATESINGLE DUE TO A PREVIOUS UNKNOWING WRITE FAILURE TO THE HISTORY FILE. IY34218 BRANCH ELIMINATION BLOCKED IN DYNEXPLN FOR A STATIC SQL STATEMENT IY34222 ALLOW DYNAMICRULES BIND BIND OPTION TO BE SPECIFIED AGAINST THE UDB SERVER FROM A NON-UDB CLIENT. IY34251 FIX SQL1279W DURING REORG ON TABLE WITH TRAILING BLANKS IN DATA. IY34261 PROVIDE SUPPORT FOR XMLVARCHAR > 3K IY34263 EVERY DB2 AGENT PROCESSES WILL USE 6MB MORE MEMORY ON SUN. IY34302 SYNC POINT MANAGER (SPM) LOG CORRUPTION DETECTED AT DB2START IY34310 PROBLEM WITH DQP_NTIER REGISTRY VARIABLE WHEN INSTALLING VIA RESPONSE FILE. IY34333 INCORRECT CALL TO SQLNG_BUILD_LEAVE_PRD. IY34336 HOST SERVER VERSION INCORRECTLY SET WHEN CONNECTION CONCENTRATORPICKS AN IDLE AGENT TO SERVICE AN ALREADY CONNECTED APPLICATION. IY34350 FIX PROCESSING OF SERVER QUERY FAILURE WHEN LOBS ARE RETURNED. IY34363 APPLY RECEIVES SQL0452N,REASON CODE 2, ATTEMPTING TO REPLICATE TABLE WITH CLOB COLUMN. IY34401 HP ONLY: RUN JAVA UDF HANGS, DB2DIAG.LOG DUMPS JAVA CORE STACK IY34402 DROP SERVER/DROP NICKNAME /DROP USER /DROP WRAPPER TRAPS WITH SIGNAL #11 WHEN ISSUING FROM NON-CATALOG NODE. IY34405 PERFORM AN IMPLICIT REPREPARE IF SQLCOLATTRIBUTES RETURNS ERROR CODE SQL0727 TO RETURN ORIGINAL ERROR CODE IY34406 ALLOW THE CONFIG ADVISOR TO FIGURE OUT THE DATABASE NAME WITHOUTANY DB ALIAS OR DB NAME INPUT IF THE INVOKER IS WEBSPHERE. IY34451 SELECT ON A VIEW USING THE ' = ' IN THE WHERE CLAUSE WILL RETURN0 ROWS IY34514 IRELNO NOT SET IN V7 DB2RA STREAM. IY34528 DSMAPIPW FAILED WITH RC '109' IN TSM LANFREE ENVIRONMENT IY34539 DPROPR CAPTURE COULD LOOSE RECORDS IF THE CD TABLE WAS LOCKED BY SOMEONE ELSE RESULTING IN DATA LOSS IY34556 SQLSPECIALCOLUMNS AGAINST OS390 FAILS WITH SQL4954 ERROR. IY34583 DPROPR APPLY WKSTN FULL REFRESH DOES NOT DELETE FROM TARGET TABLE WHEN SOURCE WAS EMPTY IY34611 SIGNAL 11 IN CLI JTASTART DURING XA ROLLBACK. IY34666 INCORRECT AUTOCOMMIT RETURNS IN XA TRANSACTION. IY34706 INDOUBT TRANS. ARE COMMITTED ON SOME NODES WHILE ROLLED BACK ON THE OTHER NODES WHERE THE TRANS. ARE CO-OR'ED BY AN EXTERNAL TM. IY34776 ERROR CONNECTING TO OR CREATING A DATABASE ON A 64-BIT INSTANCE THAT WAS MIGRATED FROM 32-BIT. IY34836 DPROPR CAPTURE COULD LOOSE DATA UNDER CERTAIN CIRCUMSTANCES IF IT HAD PREVIOSLY ABENDED BECAUSE OF AN SQL ERROR IY34934 ORG.XML.SAX.SAXPARSEEXCEPTION: AN INVALID XML CHARACTER (UNICODE: 0X0) WAS FOUND IN MARKUP AFTER THE END OF THE ELEMENT IY35085 CONCURRENT UPDATE/DELETE OF PARENT ROW,ROLLBACK ON UPDATE/DELETEOF CHILD VIOLATES REFERENTIAL CONSTRAINT IF DB2_RR_TO_RS ENABLED IY35092 RUNSTATS THAT REFERENCE INDEX CAUSES ERROR '-1224'. ENGINE WILL CRASH. IY35194 ERROR ON CREATE SERVER FOR REMOTE DB ON V8 IY35512 DB2 PANICS IN ~SQM_EVMON_IOT(), CALLED BY SHUTDOWN_EVMON, WHEN AN EVENT MONITOR ENCOUNTERS AN ERROR. IY35891 TIMING HOLE DURING STATEMENT COMPILATION CAUSES DB2 INSTANCE CRASH UNDER HEAVY WORKLOAD - DB2 TRAPS UNDER SQLNR_MAGIC_ACTION IY35999 JDBC APPS USING NET DRIVER, MISSING THE LAST ROW WHEN CURSOR IS BLOCKING BUT THE ROW IS SPLIT ACROSS TWO COMM BUFFERS. IY36322 DURING INDEX RECREATION, BPS ERROR OF FIXING A DIRTY PAGE SQLB_NEWX. IY36611 THE UNBOUND COLUMN CASES A CORE DUMP. BECAUSE OF THAT PEOPLESOFTTRAPS. THE FIX FOR APAR#IY29709 CAUSES ALL THESE. IY36669 SQLDESCRIBEPARAM SYMBOL MISSING FROM DB2JMS.DLL CAUSING LINK ERROR JR15227 DURING LOAD MODIFIED BY CODEPAGE IBM-930, CHARACTER X4040 NOT STRIPPED OUT BY STRIPTBLANKS MODIFIER JR16761 REVOKE FAILS ON TABLE THAT AUTOMATIC SUMMARY TABLE (AST) DEPENDSON. JR16787 CLI STATIC PROFILING - CAPTURE FILE IS OVERWRITTEN IF THE APPLICATION FUNCTION IS REPEATED. JR16905 SQL0107 WHEN COLLECTION ID >= 8 IN STATIC PROFILING JR16981 PROBLEM WITH OUTER JOIN REORDERING FOR VIEWS JR16986 REPLICATION APPLY WITHIN DATA WAREHOUSE CAN HANG IF APPLY DOES NOT FINISH. JR17053 IF DB2CODEPAGE VARIABLE SET TO 1208, INFORMATION RETURNED BY SQLGETDIAGRECW MAY BE CORRUPTED JR17062 WHEN USING 'CALL PROCEDURE()' IN COMMAND LINE PROCESSOR, ECHO %ERRORLEVEL% RETURNS INCORRECT OUTPUT WHEN AN ERROR HAS OCCURRED JR17063 ADDBATCH() WILL GIVE ERROR CLI0628E IF NOT ALL PARAS ARE SET JR17070 SQL01014N MAKING SQLJ PROGRAM WITH FORUPDATE INTERFACE WITH SELECT WITH WITH CLAUSE (E.G. WITH RR) OR OPTIMIZE FOR N ROWS JR17072 INDEX SCAN, FETCH PLAN IS BEING SKIPPED BECAUSE OF INCORRECT IDENTIFICATION AS A HALLOWEEN SPECIAL CASE. JR17081 SQL0334N WHEN EXECUTING STORED PROCEDURE CALL TO DB2 FOR 390 V7.THIS IS A UNICODE PROBLEM. JR17082 TRAP WHEN USING A SQL_ATTR_CURSOR_TYPE ON A CONNECTION HANDLE JR17108 SQLCA NOT BEING RESET WHEN RECEIVE A CONVERSION ERROR USING CLI WITH EXECUTE CHAINING. JR17132 LOCALE PROBLEMS CONVERTING DECIMAL TO SQL_C_DOUBLE JR17137 UDB INCORRECTLY RETURNING DRDA OPNQRYRM WITH SVRCOD=4. THIS VIOLATES DRDA AND CAUSES 390 TO DETECT A DRDA EXCEPT COND. JR17141 EEE NT/WIN2000(MULTIPLE MACHINES):DB2LOOK DOESN'T PICK UP ALL THE INFO. JR17150 SAMPLE CONTENTS USES INCORRECT LOCKING. JR17160 DB2SYSP.DLL MAY NOT INSTALL CORRECTLY DURING FIXPACK INSTALLATION JR17169 SELECT WITH OUTER JOINS AND UNION RETURNS MORE ROWS THAN IT SHOULD JR17186 TWO XA PREPARE CALLS TO DB2 GIVE -7 XAER RMFAIL ERROR. RESOURCEMANAGER UNAVAILABLE. JR17187 SQL0332 ERROR EBCDIC 37 TO UNICODE 1208 FOR LOB DATA JR17200 SQLFREESTMT TRAPS IF SQLEXTENDEDBIND ARRAYS ALREADY FREED JR17208 OLEDB DRIVER GETS CATASTROPHIC FAILURE IN GETPROPERTIES AND CRASHES THE MS SQLSERVER THAT IS USING IT. CLI TRACE SEES CLI0131E. JR17211 ABSTRACT FP8:NESTED PROC CALL ALWAYS RETURNS +464 IF CALLER JR17214 SQL1822 UNEXPECTED ERROR CODE '-418'... WHEN DOING QUERY AGAINSTA FEDERATED NICKNAME JR17217 ATTEMPT TO REMOVE TABLE FROM SUBSCRIPTION SET DELETE FROM ASN.IBMSNAP_SUBS_COLS IN MISSING PREDICATES CAUSING WRONG ROW DELETION JR17221 SQL4954N : ISOLATION CHANGE INVALIDATING CACHED STMT. RE- PREPARETHE SECTION AND RE-ASSIGN A SECTION NUMBER UPON RE- EXECUTION. JR17222 RUNSTATS UPDATES THE CARD FIELD IN DB2/390 INSTEAD OF CARDF. JR17231 SILENT INSTALL FAILS IF DWCTRLDB INFORMATION IS NOT IN RESPONSE FILE, IRRESPECTIVE OF WHETHER DWCTRLDB IS INSTALLED. JR17244 ERROR WITH SIZE OF STRINGS IN FRENCH INSTALL FINAL PANEL JR17250 CONTROL CENTER - SQL0355 CREATING A TABLE WITH COLUMN XMLCLOB EVEN WITH LOGGED OPTION UN-CHECKED JR17252 SQL3070N DURING LOAD INTO V7 FIXPAK 7 FROM FIXPAK 6 AND EARLIER IXF FILES THAT USED AN IDENTITY COLUMN JR17253 SQL1131N AND MEMORY REFERENCE ERROR WHEN RUNNING OLE SP ON WINDOWS JR17254 OUT OF MEMORY ERROR FOLLOWED BY SEGMENTATION VIOLATION IN SQLRA_REST_REG WHILE DOING DB2RBIND JR17263 THE ''' CHARACTER NOT PROPERLY REPRESENTED IN CREATE TABLE DDL. JR17267 DB2 CONNECT SHOULD VERIFY THAT THE SERVER IS AT SQLAM 6 OR ABOVE(WHERE DYNAMICRULES IS DEFINED) BEFORE SENDING OUT THIS BIND. JR17272 SQL30081N WHEN FORCING APPLICATIONS JR17281 UDB CLIENT GETS RESULT SETS FROM OS390 DB SERVER RECEIVES COMMUNICATION ERROR WITH ERRNO 10014 JR17282 USING KEYSET CURSORS WITH LARGE UPDATE STATEMENTS CORRUPTS THE STATEMENT JR17285 WRONG SQLSTATE WHEN CALLING UDF JR17286 JDBC PROGRAM CAUSE AN EXCEPTION IN CLI MODULE SQLGETDATAINTERNALDURING FETCHING INTO SQL_C_WCHAR WHEN DB2CLI TRACE IS ON. JR17295 INSTANCE TRAP AT SQLCC_GENERATE_SYNCLOG WHEN SP FETCHES LOB DATA JR17298 DWC Insert statement puts in wrong value for NOT NULL WITH DEFAULT JR17300 JDBC 2.0 NET DRIVER ALLOWS BLANK USERID/PASSWD TO LOGIN JR17312 INTERMITTENT DIA4804E, -30020 WHEN SQL_ATTR_QUERY_TIMEOUT USED IN CLI APP IN CONJUCTION WITH QUERYTIMEOUTINTERVAL KEYWORD JR17317 SQL0204 FROM DB2 CROSSLOADER PROGRAM. JR17318 ON FAST X86 MACHINE, DB2START FOLLOWED BY CONNECT TO DB RESULTS IN SQL1032N EVEN THOUGH DB2START ALREADY COMPLETED JR17320 ARRAYINDEXOUTOFBOUNDSEXCEPTION IN GETCOLUMNCLASSNAME JR17325 DB2CLI.DLL TRAPS/ RESULT INCORRECT WHEN CLIENT INVOKES STORED PROCEDURE THAT RETRIEVES DATA FROM UNICODE DATABASE JR17332 DB2STOP FORCE HANGS AFTER A CTRL-C AGAINST A JAVA APPLICATION JR17333 DB2UNINS.EXE RUNNING ON WINDOWS NOT DELETING ALL REGISTRY ENTRIES, NOR THE SQLLIB DIRECTORY. JR17335 -551 RECEIVED IN APPLICATION WHEN CURSORHOLD=0 JR17364 IN CC WHEN CONNECT TO REMOTEDB SELECT FROM TABLE REPORTS DBA2191 JR17373 CLI0601E ERROR RETURNED W/ SELECT FROM OS 390 JR17377 CLI TRAPS WHEN DESCRIBE DA IS NOT PROCESSED AFTER 2ND EXECUTION JR17380 CONNECT IN COMMAND CENTER HANGS IF USER GOT NO PERMISSIONS TO C: JR17382 ATTEMPT CONVERSION FROM VARGRAPHIC TO VARCHAR USING SPB RETURNS SQL1131N DARI (STORED PROCEDURE) PROCESS BEEN TERMINATED JR17383 SIG#11 FROM SQLNO_GET_SUBQUERY_COSTS DURING QUERY EXECUATION AT OPTIMIZER LEVEL 5 JR17384 CANNOT RUN SPANISH SPB SPROC WITH DEC INPUT JR17389 ADD SINGLE QUOTES IN SQL STATEMENT FOR PWD VALUE IN CRT SERVER JR17395 ENHANCEMENT REQUEST TO EXTEND THE SCOPE OF THE PATCH1=131072 VALUE TO INCLUDE RESULT SETS FROM A STORED PROCEDURE. JR17413 UDF ABNORMAL TERMINATION ON WINDOWS PLATORM RUNNING MULTI THREADED JR17417 ONTHLY(DATES) TYPE OF SCHEDULE IS NOT CORRECTLY CALCULATING THE STARTING JR17426 HASH TABLE NOT FREEING ENTRIES. JR17427 TRAP IN SQLDTSCN WILL OCCUR DURING LOCK ESCALATION IF MEMORY IS REFERENCED BEYOND THAT WHICH HAS BEEN ALLOCATED JR17428 SERVER GENERATED ROLLBACK NOT PROPERLY PROPOGATED TO A XA TRANSACTION MANAGER FROM DB2 CLIENT.XA_PREPARE=- 3,XA_ROLLBACK=-6 JR17432 THE GENERATE PERIOD TABLE TRANSFORMER PUTS WRONG END OF MONTH DATES JR17433 SPB BUILDS A STORED PROCEDURE BUT CANNOT RUN IT - THE MESSAGE 'WLM_ENVIRONMENT - 0 RECORD(S) SELECTED' IS DISPLAYED. JR17482 DB2DART REPORTS 'WARNING: OBJECT IN OBJECT TABLE NOT FOUND IN SYSTABLES' WHEN SYSCATSPACE IS DMS. JR17489 ROLLBACK TO SAVEPOINT IS IGNORED AND ENTIRE TRANSACTION IS ROLLED BACK INSTEAD SA95931 DWC - ISERIES AGENT DOES NOT WRITE CORRECT NUMBER OF ROWS ON AIX TARGET SE08163 OSP R510 EXTENDERS XML_EXTENDER INCORROUT APAR fixes included in WR21310 (Fixpak 7) APAR No. Abstract -------- -------------------------------------------------- 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 GG04257 WHEN ASNLOAD IS CALLED BY APPLY A HIGH CPU CONDITION WOULD OCCUR FOR THE LENGTH OF THE LOAD PROCESS. IC32991 STORED PROCEDURE CALL CRASHES CLP DUE TO INVALID ARGUMENTS IY18439 BUFFER POOL LOGIC ERRORS IN SQLB_MAKE_ROOM_IN_MAP IY20308 UPDATING USER MAPPINGS FOR FEDERATED DATASOURCES ON EE / EEE IS NOT BEING SPAWNED ACROSS ALL NODES UNTIL A DB2STOP/DB2START. IY21394 THE HOST DB2 DATABASE BACKUP FAILS AS IT SEES THE LINK FILES ON DLFM ARE NOT YET BACKUPED. IY22434 SQL1042 ON CRASH RECOVERY AFTER ALTER , DROP BUFFERPOOL OPERATIONS IY24866 OPTIMIZER PROBLEM WITH UPDATE AND SELECT HIGH WORKLOAD IY24876 BUILDING A SQLJ APP WITH DECLARE STATEMENT PRODUCES A SQLJ0201E RC=1 ERROR. IY25007 JDBC DOES NOT REPORT ANY WARNINGS WHEN IT TRIES TO GET A SCROLLABLE CURSOR BUT FAILS. IY25034 CHANGE CLP REQUEST AND INPUT MESSAGE QUEUE NAME TO BE MORE UNIQUE IY25826 'SET TABLESPACE CONTAINERS' COMMAND ISSUED AT CLIENT WHILE CONNECTED TO HOST CAUSES TRAP AT THE GATEWAY. IY26151 BETTER HANDLING OF LOB FILES IY26647 DLFM_CHILD:43040 2.GROUPS ARE NOT DEFINED.. ERROR MESSAGE BEING REPORTED AS A SERIOUS ERROR ON THE DLFM SERVER IY26861 PERFORMANCE PROBLEM WITH FEDERATED QUERIES IY26985 QUERY PERFORMANCE DEGRADATION AFTER RUNNING RUNSTATS. IY27236 SIGNAL #11 DUE TO AUTOLOADER NOT HANDLING CATALOG NODE FAILURE SCENARIO IY27879 IN COMMAND CENTER, QUERY RESULTSETS FROM OS/390 DO NOT DISPALY IN QUERY RESULTS TAB IY27987 NETWORK STATISTICS API RETURNS WRONG DATA. IY28115 APPLY FAILS WITH SQL0206N ON A PREPARE IN AN UPDATE ANYWHERE SCENARIO IY28175 WAS MANAGED SERVER RESTARTS AFTER JAVACORE, ONLY HAPPENS WHEN CLI TRACING IS TURNED ON. IY28186 REORG TABLE TRAPS WHEN TYPED TABLE CONTAINS EXTENDED INDEX. IY28247 CUSTOMER SEES SQL804N ERROR WHEN RUNNING AN EMBEDDED SQL PROG. PROBLEM SEEMS TO BE CORRUPTED PACKAGENAME IN SQLDA. IY28248 PROBLEM WITH CATALOGUED TRUSTED DARI STYLE PROCEDURES. IY28261 1 BYTE OVERWRITE IN SQLEJREADJAR IY28262 CARDINALITY ESTIMATES ARE OFF BY A FACTOR OF THE NUMBER OF EEE NODES. IY28274 UNICODE APPLICATION CONNECTED TO A CODEPAGE DATABASE RESULTS IN CLI0189E INCONSISTENT DESCRIPTOR INFORMATION ERRORS. IY28275 SNAPSHOT TABLE NAME IS NOT UPDATED IF THE TABLE IS RENAMED. IY28380 SELECT CASE WHEN EXISTS (SELECT * FROM LOCAL_TAB1 EXCEPT SELECT * FROM LOCAL_TAB2) THEN 1 ELSE 0 END FROM (VALUES 1) AS X' CRASH IY28389 SAME LOG FILE IS ARCHIVED TWICE IY28395 ERROR ON SQLDESCRIBEPARAM() GOING TO AS/400 DATABASE. IY28412 CLOSEOPEN WITH CHAINING DOESN'T SEEM TO CLOSE THE CURSOR IN SOMECIRCUMSTANCES. IY28450 DB2CKRST FAILS WITH RETURN CODE OF -10 SEEN AT LINE 1486 IY28455 DB2 FORCE APPLICATION (APPLHANDLE#,APPLHANDLE#)' SUCCEEDED ON ONLY COORDINATOR NODE.IF ISSUED FROM ANY OTHER NODE IT FAILS IY28490 DB2_ALL AND RAH PRODUCE VARIABLE SYNTAX ERRORS WHEN USING C SHELL (CSH) IY28522 HANG ON CATALOG ACCESS AFTER SETTING EXPLAIN MODE TO EXPLAIN. IY28541 LOAD ON SMALLINT COLUMN USING MANTISSA NOTATION LOADS INCORRECT VALUES IY28553 TRAP IN SQLJDRD1 IN SQLO GET STATIC DATA IY28611 CLOB SUPPORT UNDER CLI MINMEM CRASHES IY28632 TRAPPED IN SQLNO_ESTOE_ACTION IY28677 CAPTURE WAS NOT UPDATING ALL LOB COLUMNS CORRECTLY FOR CERTAIN LOG VARIATIONS. IY28699 TRAP IN SQLEQUERYSYSPLEXNODES /DR.WATSON DB2SYSC - DEVIDE BY 0 IY28823 SYSTEM ABENDS WHEN BUFFER SIZE IS TOO SMALL INSTEAD OF PROVIDINGTHE APPORIATE ERROR MESSAGE IY28878 PARSING ERROR WHEN SNAPSHOT MONITOR SETTINGS CHANGE DURING THE LIFE OF A QUERY - SQL0902CC. IY28969 CONTROL CENTER CONNECTIONS NOT CLOSED AFTER SAMPLE CONTENTS WINDOW SHUT DOWN RESULTING IN A BUILD UP OF CONNECTIONS IY28979 EEE CLP PERFORMANCE PROBLEM DUE TO READING DB2NODES.CFG IY29051 CLI AND JAVA APPLICATION GET SQL0301 OR CLI0111E WHEN THE NUMBEROF PARAMETER MARKERS IS GREATER THAN 255. IY29061 SETTING KEEPDARI=NO ON FP5 IS PRODUCING A LOT OF MESSAGES IN THEDB2DIAG.LOG -> SQLCCFREEIPCS FUNCTION CALLS IY29230 SETUNULL() ON COLUMNS W/ A NULL WILL RETURN INCORRECT RESULT IY29232 PROBLEM CAUSE BY TWO USERS CREATING A SEQUENCE WITH THE SAME NAME IY29247 DB2DART REPORTS INVALID INDEX TYPE OF 0X9101 FOR EXTENDED INDEX. IY29266 FEDERATE TO DB2 UDB SOURCE. QUERY IS NOT PUSHED-DOWN IY29271 FP7:EXTRANEOUS MESSAGES IN DB2DIAG.LOG DURING DQPSTART/STOP: SQLOOPENP PROBE:36, DQPSSEXECUTESTARTSTOPNODE PROBE:30,31,32 IY29281 PERFORMANCE DEGRADATION DUE TO LATCH CONTENTION EXPERIENCED WHENSEVERAL SAME OR SIMILAR SQL QUERIES ARE ISSUED. IY29294 SQL0518 CAUSING AN INFINITE LOOP ON THE OS/390 SYSTEM. IY29319 DPROPR CAPTURE - MISMATCH IN ROW COUNT BETWEEN SOURCE AND TARGETAFTER REPLICATION IY29339 ARCHIVE TO A DIRECTORY WITH INCORRECT PERMISSIONS REPORTS SUCCESSFUL ARCHIVE, BUT NO ARCHIVE IS PERFORMED. IY29386 USE SQLCONNECTWINT( ) WHEN JAVA STORED PROCEDURES CONNECT TO DB2 IY29402 NOT PUSHING DOWN PREDICATES THROUGH THE CSE THAT IS FOROMED WITHMULTIPLE USAGES OF THE VIEW. IY29413 CAPTURE PROGRAM DYING WITH SQL2650 RC=X / X={2,3,4} IY29438 JAVA SP GET ERROR SQL4304 ON MULIPLE PHYSICAL NODES EEE INSTANCEBUT WORKS FINE ON SINGLE NODE EEE INSTANCE. IY29441 DB2DART /LHWM DOES NOT COMPLETE INSPECTION PHASE ON LARGE TABLESPACE IY29487 DB2ADUTL INCORRECTLY REPORTS 'CORRUPTED BPS PAGE HEADER' WHEN VERIFYING BACKUP TAKEN WITH MULTI-PAGE FILE ALLOCATION ENABLED. IY29541 DB2 'HANGS' WHEN I/O IS WRITE SUSPENDED DUE TO LATCH CONTENTION IY29565 TURN OFF SQLB_SKIP_CONTAINER_OPS FLAG EVEN FOR CIRCULAR LOGGING IY29569 DB2UDB_SVC_START.KSH WRONGLY ADDRESS DB2NODES.CFG FOR EE PRODUCT IY29662 BLOCKING DATA TRANSFER FROM SOURCE SERVER TO FEDERATED SERVER IN PASS-THROUGH MODE. IY29721 CALL TO SP WITH PARAMETERS USING IBM OLEDB RESULTS IN CLI0100E IY29779 APPLY GETS AN SQL1822N AND FAILS WITH CPGDRL: READ THE NEXT INTENTSEQ FAILED. ERRCODE IS 812104' IY29792 ERRORS WHEN EXPORTING DATA FROM CODESET 1252 TO CODESET 1208 (UTF-8) USING CHARDEL0X0B IF THE DATA CONTAINS SPECIAL CHARS IY29794 CLI: INCORRECT/EMPTY INPUT/OUTPUT PARAMETER AGAINST MVS HOST IY29815 LOAD COPY IMAGE IS MULTIPLE TIMES LARGER THEN THE TABLESPACE BEING LOADED INTO WHEN USING LOAD COPY WITH SMALL EXTENT SIZE IY29834 WHEN PREVIOUS APPLY SHOWS STATUS=-1 AND WHEN NEXT APPLY IS RUN USING MAX_SYNCH_MINUTES, THE APPLY DOESN'T WORK CORRECTLY IY29848 VISUAL EXPLAIN HANGS AND NO ERROR MESSAGE IS RETURNED. IY29871 INCORRECT VALUES IN SYSIBM.SYSINDEXEXTENSIONPARMS FOR LENGTH IY29873 INSTANCE TRAPS ON SIGABRT IN SQLRL_GET_TYP_PREC_LIST IY29918 THIS APAR IS OPENED TO TRACK DEFECT D209176 - THE NUMBER OF COMMITS, ROLLBACKS, CONNECTS AND DISCONNECTS ARE NOT MONITORED IY29919 THIS APAR IS OPENED TO TRACK DEFECT NUMBER D209868. AFTER RESET MONITOR THE REMOTE RESPONSE TIMES ARE CORRUPTED. IY29925 THIS APAR IS OPENED TO TRACK DEFECT NUMBER D209210. SOME MONITORELEMENTS SUCH AS REMOTE RESPONSE TIME AREN'T FORMATTED CORRECTLY IY29999 JDBC DOES NOT CLOSE SOCKETS PROPERLY ON FAILED CONNECTION ATTEMPTS IY30034 REORG ON TABLE IN HIERARCHY WITH INDEX EXTENSIONS CAN ATTEMPT TO REORG THE WRONG TABLE IN THE HIERARCHY IY30049 CLI REDESCRIBE LOGIC ERROR FOR SQL_WCHAR WHICH IS INTERPRETTED AS SQL_GRAPHIC BY CLI. IY30090 CHANGE OUTPUT FROM HTML TO FLAT FILE FOR DB2SUPPORT DIAGNOSTICS IY30119 USE INTERNAL HANDLES IN CONCAT TO AVOID OVERFLOWING INTERNAL STORAGE IY30130 INSTANCE CRASH WITH SIGNAL 11 IN DB2GLOCK IY30132 QUERY PATROLLER COMMAND DQPSTART RETURNS EXIT CODE 0 EVEN WHEN THERE WAS AN ERROR. IY30133 CODE ENHANCEMENT THAT ALLOWS A VARIABLE TO BE SET THAT CAN DETERMINE WHICH QUERIES SHOULD BE INTERCEPTED. IY30142 APPLICATIONS HUNG IN UOW EXECUTING AND CAN'T BE FORCED DUE TO A SIGNAL RECEIVED IN DB2GDS IY30159 TRAP IN SQLCCGETATTR AFTER NUMBER OF SESSIONS HAS DROPPED TO ZERO AND WE TRY TO ESTABLISH A NEW CONNECTION. IY30172 CANNOT START THE GOVERNOR AS ANOTHER USER IF IT HAS PREVIOUSLY BEEN STARTED AS THE INSTANCE USER. IY30193 AUTOLOADER IS HARDCODE TO ACCEPT UP TO 100 ARGUMENTS IY30195 ALTER TABLE ... ADD COLUMN MAY CAUSE MISSING ROWS IN SYSIBM.SYCOLUMNS IY30265 MEMORY OVERWRITE BY CLI FUNCTION CAUSES TRAP FOR JAVA APPLICATION. IY30272 REMOVE UNWANTED TRACE MESSAGE FROM APPLY WHEN RUNNING WITH PARAMETER TRCPERF. IY30299 DB2DIAG.LOG REPORTS INCORRECT TABLESPACE TYPE WHEN TABLESPACE ISFULL OR FILE IS TOO LARGE (AT OS OR USER LIMIT) ERROR. IY30301 /DOC AND /UTIL NEED TO BE CREATED UNDER /OPT/IBMDB2/V7.1/HA/ FORDB2 HA AGENT FOR VERITAS CLUSTER SERVER IY30303 THE ASNSAT PROGRAM DOES NOT DUPLICATE IY30334 DB2 CRASHES AFTER 'SQLPGARL' GETS 'DIA3806C UNEXPECTED END OF FILE WAS REACHED.', ZRC=0XFFFFF609 IY30393 INSTANCE CRASH WHEN TRYING TO CREATE TABLESPACE LARGER THAN MAXIMUM SIZE IY30544 SIEBEL PERFORMANCE, TRANSFORM 'IN OR IN' INTO 'EXISTS OR EXISTS' IY30547 CURSORS NOT BEING CLOSED AFTER THE ISOLATION LEVEL OF THE PARENTSTATEMENT HANDLE IS BEING CHANGED. CLI0129E IY30551 JDBC METHOD SETSHORT DOES NOT WORK CORRECTLY IN DB2 7.1 FP5 IY30563 DON'T ALLOW CREATION OF EVENT MONITOR ON NON-EXISTENT PARTITION IY30586 AUTOLOADER (DB2ATLD) CRASHES WITH ERROR -6555 IY30653 RESTORING LOAD COPY FAILS IY30674 DB2MOVE CORE DUMPS ON AN IMPORT IF A LINE IN THE DB2MOVE.LST FILE IS GREATER THAN 80 CHARS. IY30678 LOADING THE 16K CHAR DATA INTO LONG VARGRAPHIC COLUMN RESULT IN DATA TRUNCATION TO 8175 CHAR. IY30682 IN FENCED MODE, CUSTOMER CANNOT PASS LIBPATH INTO UDF VIA DB2ENVLIST REGISTRY VARIABLE. IY30688 PREVENT A SUSPEND WRITE I/O OPERATION FROM TRAPPING IF ANOTHER AGENT IS SIMULATENOUSLY PERFORMING A DROP TABLESPACE OPERATION. IY30690 THE RESULT OF A HASHJOIN MAYBE INCORRECT, NO ROWS, WHEN IT IS THE JOIN METHOD OF A STARJOIN ACCESS PLAN. IY30703 INSERT QUERY USING A FEDERATED JOIN FAILS WITH -901 IN A MULTI NODE DATABASE(EEE ENV). IT WORKS FINE FOR SINGLE NODE DATABASES. IY30705 TIMING HOLE TRAP IN MONITOR HANDLING FOR PARTITION FAILURE IN NODE_FAILURE_RECOVERY () IY30706 FIX DB2 CRASH UNFIXING CERTAIN INDEX PAGES IY30717 CLI0112E: ERROR IN ASSIGNMENT. SQLSTATE=22005 IY30721 DXXADM ENABLE_COLUMN -R FAILS WHEN COLUMN IS DECIMAL IY30723 STORED PROCEDURE ON OS/390 DOES NOT RETURN ANYTHING IN DB2 7.1 FP5+ IY30741 CRASH RECOVERY FAILS IN REDO PHASE WITH FFFFF954 FROM SQLIREDO IY30762 IN 'SATELITE ADMIN. CENTER'->GROP->APPLICATION VERSION..- >EDIT- ->CHANGE, SOMETIMES,STEPS ARE MIXED UP IN 'CHANGE LEVEL' WINDOW IY30828 MEMORY PROBLEM, DB2 FAILED WITH -1224 IY30848 CRASH OF DB2SQL92 WITH SEGMENTATION VIOLATION, INSTANCE NOT AFFECTED IY30862 DATABASEMETADATA.GETMAXSTATEMENTLENGTH() RETURNS WRONG VALUE IY30896 POTENTIAL FOR DATA LOSS USING 'DELETE ... WHERE ..' IY30911 SQL0100 WHEN RUNNING A SP THAT RETURNS (A) RESULT SET(S) USING FP6. -0100 IS SHOWN RIGHT AFTER THE DATA IS DISPLAYED. IY31175 CURSORED UPDATE/DELETE MAY CORRUPT DATA IF MULTIPLE OPERATIONS ARE PERFORMED ON CURRENT ROW AND EQUALITY USED IN WHERE CLAUSE. IY31288 HANG IN NETSTAT -I-R IY31375 SOME ROWS OF RESULT NOT CONVERTED TO PROPER CODEPAGE WHEN DATABASE IS SET TO IBM-850 TERRITORY PT_BR. IY31899 REDIRECTED RESTORE ALLOWS TABLESPACE LARGER THAN 64GB LIMIT IY31973 EXPORT IN WSF MODIFIED BY 3 FAILED WITH SQL0332 IY32028 -901 FROM ALL SQL COMMANDS AFTER REORG IY32062 DYNAMIC SQL SNAPSHOT FIELDS 'NO. OF EXECUTIONS' AND 'NO. OF COMPILATIONS' SHOWS INCORRECT RESULTS. IY33275 FP7 ONLY:MULTIPLE APPLICATIONS WITH SAME HANDLE, VARIOUS CRASH SYMPTOMS INCLUDING TRAPS IN SQLRINTP WITH HIGH WORKLOAD IY33407 JDBC DOES NOT REPORT ANY WARNINGS WHEN IT TRIES TO GET A SCROLLABLE CURSOR BUT FAILS. JR16415 WHEN SPECIFYING AN 'IN ' CLAUSE IN AN ODBC APPLICATION FOR CREATE TABLE, IN DB2CLI.INI IS IGNORED. JR16423 READING BLOB DATA FROM DB2 CAUSES MEMORY LEAK. JR16444 BIND FAILS WITH SQL0031C WHEN SPACE IN FULLY QUALIFIED PATH JR16476 IMPORT USING METHOD P USES WRONG SYNTAX: IMPORTS NULL COLUM JR16658 DATA WAREHOUSE WILL RETURN DATA EVEN WHEN AN INVALID USERID/PASSWORD IS USED. JR16743 KEYSET CURSOR OPTION CAUSES ABEND JR16764 FP6->REQUEST ALTER_REBUILD WHEN WLM ENVIRONMENT CHANGES. JR16766 NLS ENABLEMENT OF TAG FILE ON EXPORT JR16773 STEP NAME IS GENERATED ECEED 80 CHARACTERS DURING ETI/DWC INTEGRATION JR16777 APPLICATION GETS SQL0805 ERROR ON SQLLF000 PACKAGE JR16788 COMMAND CENTRE NOT GENERATING THE PROPER SQL CODE TO UPDATE A TABLE WITH A COLUMN WITH TEXT EXTENDER DATA TYPE. JR16796 PACKAGED CURSORS REFERENCING SYSIBM.SYSROUTINES DOES NOT MAKE USE OF USER CREATED INDEXES JR16800 DBA2187E IN COMMAND CENTER AT DELETING THE LAST ROW OF RESULT JR16807 LOAD EXCEPTION FAILS IF EXPT'N TABLE NAME IS PREFIX OF TARGET T JR16818 EMAIL NOTIFICATION FAILS WHEN USING MICROSOFT EXCHANGE MAIL SERVER. JR16826 TARGET TABLE NAMES STORED WITH DOUBLE QUOTES SO THE EXPORT TO OLAP INTEGRATION FAILS WITH INVALID TABLE NAMES JR16830 DWC IMPORT FAILS WITH DWC03103E JR16831 . DBCFG: PARMS DBHEAP BEING TRUNCATED TO SHORTS IN CC JR16834 SQLJ BINDING SQL_BLOB AS SQL_LONGVARBINARY, AND HENCE TRIGGERING SQL0301, DATATYPE MISMATCH, AND CAUSING REDESCRIBE. JR16836 LONGVARCHAR PARAMETER NOT BOUND WHEN USING SETASCIISTREAM TO ADDBATCH. JR16838 ENTERING AN EVENT MONITOR NAME WHICH IS TO LONG BRINGS UP DR. WATSON MSG. SAYING THE APPLICATION IS GOING DOWNS JR16839 AGENT TRAPS WHEN TOO MANY MESSAGES DURING FETCH/INSERT JR16851 JDBC RSMD GETCOLUMNTYPE API RETURNS INCORRECT VALUE WHEN UDT IS USED JR16852 DWC CREATES INVALID STATEMENT RESUME YES REPLACE ON OS/390. JR16853 EVENT LOG FILLING UP WITH ERROR MESSAGES DURING DATA PULLS IN THE DATA WAREHOUSE CENTER JR16854 DWC GUI TABLE SCHEMA PROBLEM JR16859 CC SAMPLE TABLE FAILS ON CALL GETBIGDECIMAL() IN STACK. JR16860 SQL0104 WITH TIMESTAMPDIFF FUNCTION IN AS400 V5 ENVIRONMENT JR16863 LOB OUTPUT PARAMETERS FOR A STORED PROCEDURE ARE NOT PROCESSED CORRECTLY WHEN THERE ARE RESULT SETS RETURNED. JR16866 INCORRECT RESULTS WHEN USING INTERSECT WHEN SEARCHING FOR NULL ARGUMENTS WITH CHECK CONSTRAINT DEFINED JR16869 WIN 2000: DNS LENGHT RESTRICTION <= 16 CHAR JR16873 OS/390 SPUFI DYNAMIC COMMIT IS REUSED BY OTHER STATEMENTS JR16880 SQL0901N ' BAD PLAN: UNRESOLVED QNC FOUND ' FROM SQLRFAKE / SQLNG036 INTERFACE RUNNING A QUERY INVOLVING OLAP FUNCTIONS. JR16881 THE DB2DIAG.LOG SHOWS AN ERROR OF 2201 0000 FROM THE FUNCTION SQLOINITWAITPOST AT PROBE 20 ON OS/2 JR16882 USING UNC ('\\') PATHS IN WINDOWS SILENT INSTALL DOES NOT WORK PROPERLY. JR16884 STORED PROCEDURE BUILDER: RIGHT CLICK PROCEDURE, SELECT DROP, DOES NOT DROP PROCEDURE FROM DATABASE JR16887 RS.GETSTRING GETTING CLOB, CLI0002W CAUSED DATA CORRUPTION JR16890 TRUNCATED SQL30081 MESSAGE DUE TO INCORRECT UNICODE STRING LENGTH RETURNED TO APPLICATION. JR16897 ONLINE BACKUP HANG JR16901 DBA2192E ERROR WITH SQL1403 ON CONNECT, CONNECT FAILS BUT CAN STILL CREATE TABLE BUT CANNOT SELECT ANYTHING JR16902 COMMENT ON TABLE .. FAILS WITH SQL0104 IF PATCH1=65536 IS SET JR16907 SQL WARNINGS CAUSES XML EXTENDER TO FAIL. JR16908 DOES NOT WORK IN SHRED. JR16916 FP5-INITIALIZATION OF CONTROL DB RETURNS -1403 JR16922 SQL0804 WITH NO ERROR TOKENS WHEN CALLING A DB2XML STORED PROCEDURE WITHIN A SQL STORED PROCEDURE JR16924 RELAXING THE RESTRICTIONS THAT ARE IN PLACE WHEN DEPENDS-ON RELATIONSHIPS ARE PRESENT, RESULTING IN CHEAPER PLAN. JR16925 IDENTITY COLUMN NOT FLAGGED AS SUCH IN CONTROL CENTER JR16938 SQL0637N RETURNED WHEN USING THE OPTIMIZE FOR CLAUSE BEFORE A FETCH CLAUSE JR16939 FAILOVER BY MOVING ONE DB2 GROUP IN CLUSTER ADMINISTRATOR FROM JR16940 ERRORS WHILE USING ARRAYS OF PARAMETERS AND ODBC ESCAPE CLAUSES JR16941 EVENT VIEWER ERROR STATING THAT DB2PERF.DLL IS NOT ALIGNED ON 8 BYTE BOUNDARY WHEN VIEWING PERFORMANCE MONITOR INFO JR16943 THE FILE_WAIT SAMPLE USER-DEFINED PROGRAM DOES DELETE FILES WITHEMBEDDED BLANKS. JR16944 THE ODBCTEST.EXE PROGRAM TRAPS WHEN A TABLE OWNER NAME IS NOT SPECIFIED. JR16947 SQLCANCEL CALL TO STATEMENT HANDLE ON SEPARATE THREAD DOES NOT WORK WITH NET DRIVER. JR16948 DATE VALUE FROM DB2 FOR OS/390 IS NOT CONVERTED CORRECTLY IN CLI JR16951 DB2 CONNECT REQUESTING ORIGINAL ROWSET SIZE, INSTEAD OF OUT- STANDING ROWS, WHEN SERVER UNABLE TO RETURN THE COMPLETE ROWSET JR16954 SNAPSHOT HANGS DURING A ROLLBACK CAUSING ALL OTHER DB2 OPERATIONS TO HANG UNTIL ROLLBACK IS COMPLETE - REFER TO JR15963 JR16955 USER WITH PASSWORD LONGER THAN 8 CHARS, IS NOT ABLE TO RESTORE ADB IMAGE. GETTING SQL2041 MESSAGE. JR16959 SQL0901 WHEN GOING TO AN AS/400 DATABASE THROUGH CONTROL CENTER (SIMILAR TO JR16649) JR16968 SIGNAL #10 SIGBUS 'ALIGNMENT TRAP' FOR REMOTE CONNECT ON 1.X ARCHITECTURE FOR HP JR16969 MAY CAUSE PROBLEMS IF ISSUING A DB2 RESTORE WITH A VENDOR SHAREDLIB THAT USES STATIC VAR. LIB WON'T GET UNLOADED UNTIL DB2STOP. JR16977 XML EXTENDER GETS ERROR WHEN HANDLING MULTIPLE TRANSACTIONS JR16978 CREATE NICKNAMES FOR THE HOST'S TABLES VIA THE CC GETS SQL0204 JR16989 CONTROL DATABASE MIGRATION TO DO CLEANUP OF DANGLING OBJECTS JR16990 CREATE_TABLE_DDL MISSING NOT LOGGED COMPACT ATTRIBUTE JR16994 BINDING BEHAVIOUR CHANGING BETWEEN A V6 HOST AND A V7 HOST, WHENUSING STORED PROCEDURES JR16998 CHANGING SCREEN RESOLUTION BETWEEN SPB SESSIONS MAY CAUSE SPB DIALOG WINDOW TO BE TOO LARGE TO FIT ON SCREEN JR17001 COMMAND CENTER ON WIN NT WITH FIXPACK 5 CONNECT TO A REMOTEDB SELECT FROM ATABLE REPORTS DBA2191 DATABASE NOT CONNECTED JR17004 MOVE OF A DR TO A NEW IR CAUSED PROBLEM IN STEP JR17005 DBA4010 FROM CONTROL CENTER WHEN LISTING APPLICATIONS JR17008 XTSERVER HANGS WHEN VWKERNEL IS RECYCLED JR17009 TRAP IN SQLRISIN() WHEN QUERYING TABLES THAT INCLUDE A SPATIAL EXTENDER COLUMN JR17023 INTERMITTENT CLI0102 AND SQL0301 ERRORS JR17025 USING A SCHEMA OTHER THAN IWH CAUSES ERROR WHEN OPENING THE WIP JR17032 IMPORT SDE FAILS WITH CLI0612E JR17036 FETCHSIZE SUPPORT IS IN JDBC NET DRIVER BUT NOT IN APP DRIVER. JR17039 SQLSTATE=42603 WHEN USING KEYSET CURSOR WHEN LARGE TABLE JR17042 -1131 IS OCCURRING INTERMITTENTLY ON ANY JAVA SP. JR17051 NT TRAP IN SQLNR_MERGE_SCALARSUBQ JR17052 JDBC IS NOT DROPPING CONNECTION HANDLES IN CLI WHEN CONNECTION ERROR OCCURS, CAUSING HANDLES TO RUN OUT. JR17054 TRAP IS OCCURING IN SQLJGETSRVADDR IN A SYSPLEX ENVIRONMENT JR17055 JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN CONNECTING VIA COMMAND CENTRE JR17068 IMPORT AND EXPORT CAUSING HE CONTROL DATABASE TO BECOME CORRUPT JR17114 SQL20020N WHEN CREATING JAVA SP FROM REMOTE CLIENT JR17167 DB2DART TOOL MEMORY BUFFERS LIMITATION TO CHECK SMP APAR fixes included in WR21298 (Fixpak 6) APAR No. Abstract -------- -------------------------------------------------- GG04218 FULL REFRESH APPLY TROUBLE WHEN HANDLING MANY COLUMNS GG04238 ASNLOAD SHOULD NOT ISSUE RUNSTAT IC32474 CANNOT CREATE MAPPING FOR SYBASE TEXT DATA TYPE IY18694 CREATE NICKNAME IS NOT PICKING UP THE STATISTICS FOR A DRDA HOSTTABLE. IY19335 RESTORE OVER INCONSISTENT DB FAILS DURING IMPLICIT CONNECT IY21200 RELATIONAL CONNECT(TWO DBS ON TWO DB2 EEE /AIX,SELET FAILS. WHENIT'S AGAINST TWO TABLES ON TWO DBS. SELECT FROM ONE DB IS FINE) IY21417 UNION ALL ON A VIEW FAILS WITH SQL0840N IY22389 A CORE FILE WAS GENERATED WAS DUE TO A SIGNAL 11 TRAP IN THE DB2GOVD PROCESS. IT'S A 'BAD POINTER' PROBLEM. IY23155 DB_BAD_FAT MESSAGE IN DB2DIAG.LOG WHEN FORCE APPLICATIONS OCCURS. IY23952 -902 RC=147 FROM SQLRIEVS() EVENT MONITOR IY24275 AFTER DB2 PREPARESTATEMENT EXECUTEBATCH( ) COMPLETES, SAME PREPAREDSTATMENT EXECUTEBATCH( ) MAY OR MAY NOT CAUSE JVM CRASH. IY24363 INSTANCE TRAPS ON THE SECOND CONNECT TO A DB IY24412 SQLDMDRP() MARKS THE DATABASE BAD. IY24693 SIGNAL 11 ( SIGSEGV ) IN SQLNO_CALCEX. IY24835 DB2 FOR AIX V7.1 DOES NOT SUPPORT STP AND UDF BUILD WITH MF COBOL ON AIX 4.3 - REMOVE RESTRICTION IY24873 DB2 HANG / PERFORMANCE DEGRADATION / 100% SYSTEM CPU AT DIAGLEVEL 4 WITH ' PREFETCH QUEUE FULL ' MESSAGES IY25020 BIGINT NOT NULL DATA CORRUPTED ON DB2/390 BY INSERT/IMPORT IY25407 DB2CC - ADD SOLARIS DYNAMIC LIBRARY TO THE CREATE WRAPPER CODE. IY25441 PROBLEM INITIATING AGENT WHEN SYSTEM RESOURCES (SEMAPHORES) ARE EXHAUSTED. CAUSES SOME AGENTS TO HANG. IY25640 SQL0301 DB2DIAG.LOG ENTRY NOT MEANINGFUL TOKEN FOR PARAMETER IY25683 TURNING ON MONITOR SWITCH UOW AND DOING 'GET SNAPSHOT FOR ALL DCS APPLICAITONS' TRAPS THE INSTANCE. IY25715 WAS APPLICATION JAVACORE IN CLI_UTLCOPYSTRINGSHORT. IY25777 SQL0902 RC=143 TRYING TO DROP A TABLE WHICH IS RECOVERY- ENABLED UNDERLYING PROBLEM IS FILE SHARING VIOLATION ON HISTORY FILE IY25788 OPTIMIZER HAS FULLY QUALIFIED INDEX BUG WITH DETAILED STATISTICS IY25830 LOG ARCHIVAL HANGS DURING CRASH RECOVERY WHICH HANGS THE ENTIRE CRASH RECOVERY. IY25843 CAN NOT DROP A NICKNAME THAT HAS AN INDEX ON THE REMOTE TABLE IY25845 ASNLOAD BUILD PROBLEM - BIND PACKAGE NAMES NEED TO BE INCREMENTED IY25864 WHEN CREATE A NICKNAME ON AN ORACLE REMOTE TABLE, CLUSTERRATIO IN SYSCAT.INDEXES IS ALWAYS EITHER 0 OR 100. THIS IS INCORRECT. IY25894 TABLESCAN ON 390 FOR CALLING STORED PROCEDURES SHOULD USE INDEX (APAR 1 OF 2) IY25917 AUTHENTICATION SERVER_ENCRYPT NOT SUPPORTED WITH V7 FP4 ON AIX 5L IY25918 TABLESCAN PERFORMED ON MVS WHEN CALLING STORED PROCEDURE FROM UDB, WITH CUSTOMER-CREATED INDEX ON TABLE. IY25973 DB2 HANGS DUE TO DEADLATCH IN PACKAGE CACHE SPACE MANAGEMENT - MANY AGENTS IN COMPILING STATE BUT NOT ADVANCING / USING CPU IY26007 INCORRECT CODE PATH PRODUCED CORE DUMP. IY26015 LOGIC OF DELETING QUERY PATROLLER USERS HANDLED BY SQL0556 ERRORHANDLING WAS LEFT OUT OF FIXPACK 4 IY26038 A DROPPED REPLICATED SUMMARY TABLE STILL GETS REFERENCED BY A PACKAGE CAUSING FFFFF47A AND THEN DB2 CRASH. IY26083 COMMAND CENTER HANGS INDEFINITELY WITH THIN CLIENT WHEN READ ONLY ACCESS IS GIVEN TO SQLLIB ON THE CODE SERVER. IY26188 WITH NET DRIVER, CLI0111E IS RECEIVED ON EXECUTION OF SECOND PREPAREDSTATEMENT IF FIRST PREPARED STATEMENT IS NOT CLOSED IY26214 LOAD WITH FORCEIN OPTION IS DOING A CODEPAGE CONVERSION, EVENTHOUGH WE SHOULD SUPPRES TRANSLATION BETWEEN CODE PAGES. IY26261 NEW FUNCTION TO ALLOW IN PREDICATE PROVING USING INEQUALITY RELATIONS IY26268 DB2 INSTANCE CRASH DUE TO MEMORY CORRUPTION : DB2 AUDIT BUFFER OVERWRITE CAUSES TRAPS - SQLE_DATABASE_CONNECT_RESET IS COMMON IY26386 SQL1004C DURING ROLLFORWARD COMPLETE AFTER DB2INIDB AS MIRROR ONPTX (NUMAQ) IF THE ACTIVE LOGS RESIDE ON RAW DEVICE. IY26397 ROLLBACK OF A LARGE INSERT OR UPDATE TRANSACTION IS VERY SLOW. INT SOME CASES, IT IS 20 TIMES THE ORIGINAL STATEMENT IY26402 EMP/SMP ERROR MESSAGES REPORTED IN DB2DART OUTPUT AFTER ROLLFORWARD, OTHER SYMPTOMS COULD BE BAD PAGES IN DB2DIAG.LOG IY26421 GET EXCEPTION: STRING INDEX OUT OF RANGE WITHNET DRIVER IY26437 SQL1610N DATA->INODENUMBER IS INVALID RETURNED FROM GET SNAPSHOT ... GLOBAL IY26441 DB2EVMON RETURNS ERRROR: INCOMPATIBLE OR CORRUPTED EVENT TRACE WHEN PRINTING OUT A LARGE STATEMENT, EXIT CODE = 31 IY26471 WRONG JAVA CLASS SIGNATURE IS GENERATED WHEN CALLING THE JAVA STORED PROCEDURE SQL4306N WHEN VARCHAR FOR BIT DATA AS PARAMETER IY26533 PROBLEM WITH UNICODE IN CLI. IY26608 CUSTOMER EXPERIENCES MEMORY LEAK WHEN CALLING PREPARED STATEMENT USING JDBC ON A SOLARIS CLIENT. IY26779 DB2 CRASHED WITH SIGNAL 11 TRAP IN GETTRANS() - THE ROOT CAUSE IS PROBE 10 IN SQLPLRM. IY26826 QUERY FAILS WITH SQL0901N. PROBLEM IN SQLNQ_QTB::BOX_COPY ROUTINE. IY26855 CONNECTION CONCENTRATOR CRASHES DB2 CONNECT ON SUN IY26865 LOB MINMEM SUPPORT ADDED IY26871 DB2 CONNECT V7.2 CRASHES ON A SIMPLE QUERY WHEN USING A CLIENT OF UDB VERSION 5.2 FROM AN OS/2 OR AIX PLATFORM. IY26890 CLI0637E ERROR IF THE SQL QUERY STRING CONTAINS TAB CHARATERS IY26904 INCORRECT VALUE IN 'APPLICATIONS CONNECTED CURRENTLY' FIELD OF DATABASE SNAPSHOT IY26946 UNSUCCESSFUL TABLE REORGANIZATION CAN LEAVE DIRTY PAGES AROUND IN THE BUFFERPOOL WHICH RESULTS IN TABLESPACE EXTENT CORRUPTION IY26954 VARIOUS ERRORS (MOSTLY -952 AND -900) RECEIVED FROM VARIOUS OPERATIONS (CONNECT, SELECT, LOAD, ETC.) ON A NON-GATEWAY DB IY26958 REDIRECTED RESTORE OF TABLESPACE BACKUP FAILS WITH SQL2154N IY26999 DB2 CRASH WITH SIGNAL 11 TRAP IN SQLPPROCESSREQUEST() IY27016 SQL1007 WITH QUERY PATROLLER WHEN EXTENDED QUERY IS USED FROM CLIENT TO SERVER. DEFFERED PREPARE MUST BE 0 IN CLI.INI FOR THIS IY27051 SOME CONVERSION TABLES ARE MISSING DURING INSTALL OF DB2 IY27120 QP: INTERCEPT INSERT INTO TBNAME SELECT ... STATEMENT IY27134 PROBLEMS WITH CRASH RECOVERY/RESTART AFTER INCREASING LOG FILE SIZE IY27170 CLASSPATH DOES NOT CONTAIN THE COLONS REQUIRED BY JAVA IY27182 PARTITIONING KEY NOT USE FOR GLOBAL TEMPORARY TABLE ON EEE IY27203 IN HPUX, BACKUP TO TSM FAILS WITH SQL2071N - REASON CODE '1'. IT FAILS TO LOAD LIBADSM.A IY27295 TRAP IN SQLQGAPPLICATIONTERMINATION DATAJOINER FUNCTION IY27307 SQL0311 ERROR WITH UNICODE CODEPAGES AND SQLJ PROBLEM. IY27329 CREATE SERVER WITH OPTION PASSWORD 'N' FAILS WITH SQL0551N IY27392 DATABASE COMES DOWN, SQL1042 IN DB2DIAG.LOG FROM FUNCTION SQLEGETAGENTFROMPOOL, PROBE 5. IY27401 FP4/FP5 CONNECT TAKES LONG TIME... ERRORS ARCHIVING OLD LOG EXTENTS IY27402 UDF MEMORY LEAK DIA9999E AN INTERNAL ERROR OCCURRED. REPORT THE FOLLOWING ERROR CODE : "0XFFFF876D". IY27403 DATA TRUNCATION CAUSED BY ENTITY REPLACE DURING SIDE TABLE UPDATE IY27429 CLI MISSES COMMIT AFTER A CLOSE. IY27458 SQL 1042, OR SQL 1072 OCCURS ON DB2START FOR SECOND INSTANCE STARTED ON THE SYSTEM IY27465 CLI0637-CANNOT PROCESS QUERIES WITH STARTING/ENDING BRACKETS. IY27495 ADD SUPPORT FOR SETFETCHSIZE IN JDBC NET DRIVER IY27501 SQL COMPOSITION RESULTS IN: ERRCODE = -58 MSGTEXT = DXXG002E THE SYSTEM IS OUT OF MEMORY. IY27539 MISSING COMMIT AFTER AN UPDATE A BLOB. IY27540 RESTART FAILS DUE TO CRASH RECOVERY ERROR IN SQLPGWLP IY27544 TRAPPED ON THE FILEHANDLE,WHEN DB2 WILL ATTEMPT TO RENAME/DELETETHE LOGFILE (IN SQLPGSPR) IY27562 THE ENVIRONMENT FOR 2 PHASE COMMIT CONNECTIONS OVER SNA FROM DB2/390 V6 AND V7 IS NOT CORRECTLY ENABLED. IY27575 LOW PERFORMANCE TO DISPLAY RESULT SET FOR SP RUNNING FROM SPB IY27631 SIGNAL 11 SIGSEGV IN SQLOGMBLK CALLED FROM SQLE_DB2RA_AS_DB_OPEN IY27697 CASES WHERE DB2 IS NOT KEEPING TRACK OF WHICH LOG FILES HAVE BEEN SUCCESSFULLY ARCHIVED. IY27790 CONNECTION FROM GATEWAY TO OS/390 HANGS WHEN MONITOR SWITCH FOR DFT_MON_STMT IS ON AT GATEWAY, OS/390 THEN TIMEOUT IDLE THREAD IY27791 DB2 CONNECT ABENDS IN DRDA SETUP WITH CONCENTRATOR ENABLED WHEN MULTIPLE USERS ATTEMPT TO CONNECT TO MAINFRAME DATABASE IY27795 CAPTURE MAY STOP CAPTURING DATA FOR OLDER REGISTRATION AFTER A REINIT. IY27809 INVOKING A STORED PROCEDURE THAT RETURNS RESULT SETS WITH LOB. SIGSEGV RECEIVED AT D48A8B34 IN /USR/LPP/DB2_07_01/LIB/LIBDB2.A IY27906 GET SNAPSHOT ERROR SQL1606W AND DB2DIAG.LOG MESSAGE SQM_SQLMPDBREQUESTROUTER ERROR CODE 0X646 ON BUSY SYSTEMS IY27923 SIGNAL #11 IN SQLOFMBLKEX() WHEN CALLED BY SQLRLCLO() IY27990 HASH JOIN PERFORM POORLY IN HP. ROOT CAUSE IS THAT HASH JOIN IS USING LOTS OF SMALL MEMCPY WHICH IS NOT GOOD FOR HP IY27992 SQLSTATE NOT EQUAL TO 00000 ON EXIT IF OPERATION IS SUCCESS. IY28028 SQL2519N -1001 'NOT A VALID DATABASE NAME' ERROR WHEN RESTORING AND MIGRATING AN EEE DATABASE FROM VERSION 5 TO VERSION 7. IY28036 PROBLEM WITH OUTER JOIN REORDERING. IY28061 REMOVE DIAGNOSTIC CODE/PROBES FOR MISSING GENERATED COLUMNS IY28145 DB2SPLIT USES SIGNED CHAR TO STORE THE DELIMITER, IT SHOULD HAVE BEEN UNSIGNED CHAR. IY28151 ISOLATE V7 FROM FUTURE CHANGES IN THE MESSAGING SCHEME. IY28266 INCORRECT RESULTS FROM A QUERY THAT HAS A CASTED PREDICATE IY28323 I/O BOTTLENECK OCCURS AS A RESULT OF XML EXTENDER CREATING MANY SMALL XML DOCUMENTS DURING COMPOSITION IY28423 CORRECT POTENTIAL SECURITY PROBLEM WITH DB2CKPW AND DB2CHPW IY28448 ON FAILURE OF FULL DB ONLINE BACKUP,LEAVES THE TABLESPACE BACKUPIN PORGRESS STATE IY28478 SELECT DISTINCT WITH WHERE CLAUSE RETURNS INCORRECT RESULTS IY28519 TRAP IN SQLOCPCV BECAUSE BPS SENDS A TRIPLET OF DATA WITH NUMENTRIES 1, WHEN IN-FACT THERE ARE NO ENTRIES TO BE SENT. IY28640 DATABASE IS MARKED BAD BUT IS NOT REPORTED TO THE COORDINATOR NODE IY28721 MULTIPLE DELETE THROUGH INDEX COULD DELETE WRONG LINE FROM TABLE IY28765 SQL0551N DURING CREATE TRIGGER USING NEXTVAL IY28919 DB2 CRASH, OR ERRCODE=-81:0 WITH MSGTEXT 'DXXQ021E IY29062 DB2POOLEDCONNECTION LEAK. IY29159 NO BACKUP IMAGE APPEARS ON BACKUP OF 10THE SESSION ON TSM THROUGH CC WITH ERROR DBA1605 NO BACKUP IMAGE INFORMATION WAS FOUND. IY29167 DURING ARRAY INSERT, DB2 HANGS IF THE CONNECTION IS STOPPED WHEN THE PARAMETER SIZE IS GREATER THAN WHAT WAS DECLARED. IY29172 DOING STMT = CON.PREPARECALL ("{CALL BV#TP56.JAGPROC1(?, ?}"): CLI GIVES NO ERRORS AND READS AS CALL BV#TP56.JAGPROC1(?) IY29175 DATBASE BROUGHT DOWN WHEN ENCOUNTER A HEURSTIC ROLLBACK REQUEST ON ATRANSACTION IN TABORT STATE. (EEE) IY29176 MEMORY CORRUPTION TRAP WHEN TRYING TO ENABLE EVENT MONITOR ON UDB V6.1 EEE IY29313 SQL2048,RC=4 WHEN ONE OF THE DB2RHIST* FILES IS MISSING. IY29314 CRASH RECOVERY COMPLETES EARLY IY32714 SQLGETDIAGREC() RETURNS WRONG ERROR CODE ON DB2 V7.2 FP5 IY36112 ON AIX5 WITH REGATTA P690 HARDWARE, MISSING SYNC INSTRUCTIONS FROM DB2 MAY RESULT IN CRASHES OR OTHER UNEXPECTED BEHAVIOUR JR15805 KEYSET CURSOR DOWNGRADES TO FORWARD-ONLY INSTEAD OF STATIC JR16046 PROBLEMS WHEN CREATING A TABLE VIA THE CONTROL CENTER IF THE COLUMN IS A UDT DATATYPE JR16458 OLEDB NOT BINDING PARAMETERS TO STATEMENT. JR16459 ADO PARAMETERS.REFRESH DOES NOT WORK WITH CALL STATEMENTS. JR16475 SQL0901N ACCESSING MULTISITE FROM CONTROL CENTER USING DB2CODEPAGE=1208 ON CLIENT. JR16539 SAME PACKAGE NAMES BEING USED AS PREVIOUS FIX PACK IN V7 IS CAUSING DEADLOCKS JR16564 MAPPING COLUMNS TAKES A LONG TIME IN THE COLUMN MAPPING PAGE JR16566 DB2RFPEN UTILITY NOT INCLUDED IN INSTALL IMAGESFOR V7. DB2RFPE N MARKS THE DATABASE IN ROLLFORWARD PENDING STATE. JR16584 SQL30090N OPERATION INVALID FOR APPLICATION EXECUTION ENVIRONMENT. REASON CODE = '11' JR16605 DEFAULT TARGET GENERATION OF FLAT FILES WITH MIXED CASE COLUMN NAME DOES NOT WORK. JR16613 THE ORDER OF ROWS RETURNED FOR A SELECT DISTINCT STATEMENT WITH AN ORDER BY CLAUSE IS SOMETIMES INCORRECT USING DB2 FEDERATED JR16635 SQL0423 WHEN SELECTING CLOBS THROUGH OLEDB DRIVER JR16637 DWC IMPORT WITH PERIOD ('.') IN THE PATH NAME JR16639 IMPORTING A TAG FILE FROM R/O DIRECTORY RESULTS WITH ERROR JR16649 SQL0901 WHEN GOING TO AN AS/400 DATABASE THROUGH CONTROL CENTER JR16650 IMPORT FAILS WHEN IMPORTING TAG FILE WITH MORE THAN ONE FOREIGN KEY JR16653 ODBC APPLICATION GET'S SIGSEGV WHEN TRYING TO DISCONNECT FROM THE DATABASE WHEN DB2CODEPAGE IS SET TO 1208. JR16654 ADDING THE IGNORE UDT OPTION TO THE SYBASE WRAPPER FOR RELATIONAL CONNECT. JR16663 THE DB2SAMPL SCRIPT SHOULD NOT ISSUE A DB2START PRIOR TO CREATING SAMPLE DB JR16695 SQLPUTDATA ABENDS ON LOB INPUT SIZE > 64K. TRAPS AT DB2CLI!CLI_UTLCOPYSTRING JR16699 CANCELING OUT OF OPENING SPB NEW/OPEN PROJECT SCREEN CAUSES OPEN/NEW PROJECT SELECTION UNDER 'FILE' MENU OPTION TO BE DISABLED JR16710 UNABLE TO CONNECT USING SUN JNDI PROVIDER WITH LDAP. JR16715 NEED TO TRUNCATE COL SIZE FROM 1GB TO 128KB FOR SOME MSSQLNT DT JR16717 DB2CKBKP FAILES TO CHECK THE BACKUP IMAGE IF THE IMAGE IS IN MORE THAN ONE TAPE. JR16718 FLAT FILES COLUMN NAAMES END UP WITH MULTIPLE '' '' AROUND THEM JR16722 CONNECT FROM SPB TO OS/390. SELECT BUILD AND RUN A STORED PROCEDURE TWICE. THE PROGRESS INDICATOR IS NEVER CLEARED. JR16726 DATA TRUNCATION DUE TO INVALID CONVERSION DURING CASING FROM INT(4-BYTE) TO SHORT (2-BYTE) AND LOSING HIGHER ORDER BYTES JR16729 TRAP WHEN GOING AGAINST DB2 ON OS390, DUE TO MEMORY CORRUPTION JR16731 CHANGE HANDLING OF VARCHARS FOR COBOL STORED PROCEDURES, TO USE LEADING LENGTH BYTES AND NOT NULL-TERMINATED STRINGS. JR16734 WIP PROBLEMS IN DATA WAREHOUSE CENTER (DWC) JR16744 SQL3324N COLUMN 'COL1' HAS A TYPE OF '456' WHICH IS NOT RECOGNIZED ' ERROR WHEN SELECTING A VARCHAR COLUMN WITH PASSTHRU JR16752 WHEN YOU USE THE SQL BUILDER TO EDIT A USER DEFIEND COLUMN THE MAPPING FOR THAT COLUMN IS LOST. JR16757 CALLING SQLJ.REFRESH_CLASSES() ON CLP CAUSES CRASH ON DB2BP.EXE JR16768 CARRIAGE RETURN IGNORED FOR SELECTS WHEN STATEMENT TERMINATION CHARACTER OPTION UNCHECKED AND AUTO-DISPLAY QUERY RESULTS CHECKED JR16769 QUERY PATROLLER QUERY ENABLER INTERVAL REDUCING JR16772 DB2 UDB STORED PROCEDURE BUILDER VERSION 7 WITH FIXPAK 5 FAILS WITH SQL0102N (AND DB2 TRAP) WHEN BUILDING JAVA PROCEDURE JR16774 THE COMMAND HISTORY SIZE OPTION OF THE DB2 UDB COMMAND CENTER ISERRONEOUSLY RESET TO THE DEFAULT OF 20. JR16778 IMPORT INSERT_UPDATE ABEND (SQL0007N) FOR UDT WHEN COLUMN NAME LENGTH EQUALS TO 18 JR16781 DB2DARI PROCESS CREATED EVEN WHEN KEEPDARI IS SET TO 'NO' IN THEDB CFG. JR16784 CASCADING PROBLEMS ENCOUNTERED DURING MIGRATION FROM V5.2 TO V7 JR16814 CLI0158E. SEE ERROR IF A PARAMETER CHANGES FROM SQL_DATA_AT_EXECTO NOT. TMP FILE ISSUE WITH LOB OBJECTS. JR16829 SELECT DISTINCT IN INSERT STATEMENT DOES NOT RETURN CORRECT RESULTS. JR16855 DWC FP5 INSTALL AGENT DAEMON AUTOMATICALLY JR16856 COLUMN TRUNCATION CAUSES CLI0615 JR16894 CLI0119E DURING XA CONNECT FROM JTA THEN SUBSEQUENT SQL30090N WITH RC=6. APPLICATION RESTART RESOLVES THE PROBLEM. JR16896 SQL3966N RECIEVED WHEN ATTEMPTING TO COMPLETE A PREVIOUS SYNC SESSION JR16914 CONTROL CENTER DOES NOT DISPLAY DCS DB NAME CORRECTLY WHEN HOST IS AS/400. JR16917 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. PQ44819 ADD PARAMETER CCSID CLAUSE TO CREATE FUNCTION AND CREATE PRECEDURE STATEMENTS PQ57681 ADD TABLE_SCHEMA COLUMN TO THE PRIMARY KEY OF THE XML_USAGE TABLE. SE03514 DB2-UDB-XML-EXTENDER PARSER ERROR -85 WITH CCSID 5035 SE03529 DB2XML.GENERATE_UNIQUE PRODUCES DUPLICATE VALUES. APAR fixes included in WR21293 (Fixpak 5) APAR No. Abstract -------- -------------------------------------------------- GG04225 SQLCODE313 IN CONFLICT COMPENSATION REPLICA UPDATE ANYWHERE GG04227 APPLY SKIPPED A RECORD IN 'FROM ORACLE' CASE GG04230 APPLY FAILED WITH SQLCODE100 DURING COMPENSATION GG04233 APPLY NEEDS TO TOLERATE SQLCODE +191 WHEN FETCHING ANSWERSET GG04234 ASNSAT COMMAND DISABLES SATTELITE CLIENT WHEN CONFLICT IS DETECTED AND CORRECTED GG04235 MEMORY REFERENCE ERROR RUNNING APPLY WITH UPDATE ANYWHERE SUBSCRIPTION. GG04237 USING COMMIT(N) WITH UPDATE ANYWHERE OR PEER TO PEER REPLICATIONMAY CAUSE APPLY TO FAIL WITH SQLCODE530 IC28524 MSGDB1210354E QEND DOING SQL TO DB2 FOR OS/390 WHERE DECIMAL POINT IS COMMA IC32019 WHEN WRITING A QUERY USING A LOCAL DB2 VIEW INVOLVING NICKNAMES,THE PREDICATES ON THE QUERY ARE NOT PUSHED DOWN IY17818 DEFUNCT DB2SNMPD PROCESSES ARE NOT REMOVED IY19211 LOCK CONTENTION ( POSSIBLY RESULTING IN SQL0911N ) WHILE USING THE EXPORT UTILITY IY19519 PREP TIME FOR A NUMBER OF QUERIES IN AN SAP BW SYSTEM UNACCEPTABLY HIGH @ OPTLEVEL 5 IY20186 TABLE QUEUE COST MODEL FIX. IY20209 CONTROL CENTER HANGS ACCESSING EEE TABLESPACE DATA IY21446 CLI APP WITH MINMEM ENABLED CRASHES WHEN INSERTING INTO DB2/390 IY21460 USING DB2MOVE WITH EMPTY STRING OR SPACES FOR THE LOB FILE PATH CAUSES FILE/DIR DELETION STARTING FROM THE ROOT DIRECTORY. IY21683 SQL0802N DURING AVERAGE COMPUTE IY21804 WAS: DATABASEMETADATA.GETTYPEINFO NOT COMPLIANT WITH JDBC SPEC IY22567 AN ATTEMPT IS MADE WITHOUT USER/PASSWORD WITH ASNLOAD IY23058 DB2LOOK DROPS FOR BIT DATA IN CREATE DISTINCT TYPE DEFINITIONS IY23067 INSTANCE CRASH AND TRAP AT SQLJDRD1 IY23142 DATABASE MARKED BAD DURING QUERY DUE TO SQL0902 RC=126 IY23286 PARALLEL CRASH RECOVERY FAILS WHEN NO DATA ON PARTION (EEE) IY23330 GET RID OF SQLT_TRACE_INIT AND GETPID() WHICH ARE CAUSING HIGH CPU USAGE ON SOLARIS. IY23336 CREATE TRIGGER FAILS WITH SQL0551 FOR ALL NON DBADMS IY23445 CHANGE THROUGH CCA PROPERTIES BLANK OUT DCS PARAMETERS IY23494 QP CANNOT HANDLE SUFFICIENT OUTSTANDING CONNECTION REQUESTS IY23518 SOME 'SHARED SEGMENT NOT READY' ERRORS (PROBABLY OSS ERRORS) IN DB2DIAG.LOG, MAKE THE DQPSTART END UP WITH DB210045 IY23615 ADDITION OF EURO SYMBOL TO THE 1143 CODEPAGE CONVERSION TABLES IY23644 INSTANCE CRASH WHEN FORCING A STORED PROCEDURE THAT IS CREATING AN INDEX IY23655 TRAP IN SQLRL_DUMP_USERTEMPS IY23687 . UNABLE TO CHANGE PASSWORD THROUGH ODBC WINDOW. IY23717 JAVA APPLICATION TRAPS ON SOLARIS MACHINE AND THE SATCK TRACEBACK IS CORRUPTED. IY23752 ALL DB2 COMMANDS HANG DURING MONITOR ACTIVITY. WAITING FOR LATCH IY23787 DB2 UDB RESTORE FROM MULTIPLE NAMED PIPES RESULTS IN ERROR SQL2546N. IY23851 CORRUPTION INNON UNIQUE INDEXES CREATED IN PARALLEL IN V72 WITH DB2_INDEX_2BYTEVARLENREGISTRY VARIABLE SET IY23910 WHEN EVENT ANALYSER IS USED TO READ AN EVENT MONITOR FILE, ERROR - DBA5357: UNEXPECTED DATA WAS FOUND AT OFFSET ... IY23913 QUERY PATROLLER MONITORING ON THE NODE ADMINISTRATION PANEL OF QUERYADMIN SHOWS THE DISK AVAILABLE FIELD AS '15,000,318,652,550 IY23944 DB2 CONNECT TO DB HANGS WHEN WRITE SUSPEND IN ON AND A LOCK SNAPSHOT IS TAKEN WHILE A TRANSACTION WAS ROLLED BACK. IY23945 'SQLOCSHR' LEAKS MAPPED SHARED MEMORY IF FAILURE OCCURS IN 2ND STATE ATTACHMENT. PROBE:220IN SQLOCSHR IN DB2CART. IY23972 SIGNAL 11 TRAP IN SQLNO_POST_PASS IY23993 DB MIGRATION DOES NOT INITIALIZE CORRECT VALUE OFCOLSEQ IN SYSIBM.SYSINDEXCOLUSE FOR SOME INDEXES IY23995 DB2 UDB - DATA IS INCORRECTLY TRUNCATED WHEN IMPORTED INTO CLOB OR VARCHAR COLUMNS USING THE CODEPAGE OPTION OF IMPORT COMMAND. IY24024 ANY WITH ABILITY TO PERFORM SET INTEGRITY ... OFF ON A SINGLE TABLE MIGHT PUT THE OTHER SPECIFIED TABLES INTO CHECK PENDING IY24037 SPB HANGS WITH NULLPOINTEREXCEPTION WHEN EXECUTE SP WITH >=20 PARAMETERS IY24068 CLI PROBLEM/CORE IN MULTI-THREADED SIEBEL ENVIRONMENT IY24076 POOR PREPARE TIME WITH DISTINCT CLAUSE AND TRANSITIVITY IY24089 STORED PROC LEAVING OPEN HANDLE WHEN FEDERATED QUERY ERROR IY24118 WRONG ACCESS PATH CAUSING DEGRADED PERFORMANCE IY24157 VB APP CRASHING USING OLEDB PROVIDER IN V7.2 AFTER NETWORK CABLEREMOVED DURING APPLICATION EXECUTION IY24178 COMMAND CENTER, ATTACH TO DB USE INTERACTIVE TAB, THEN ATTACH TOSECOND DB, ISSUE QUERY, RESULTS FROM FIRST DB. IY24187 GETTING SQL0301 WHEN INSERTING TIMESTAMP INTO A DATE COLUMN IY24281 DB2DIAG.LOG ENTRY : UNABLE TO FIND/REMOVE TABLE FROM NOLOG LIST : THIS SHOULD NOT BE LOGGED FOR DECLARED USER TEMPORARY TABLES IY24308 WHEN OUTER JOIN ELIMINATION IS CHOSEN BY THE OPTIMIZER A -901 INSQLNO_FF_GET_COL_INFO OR TRAP IN SQLNR_BUILD_EQUIV MIGHT OCCUR. IY24331 ABNORMAL TERMINATION ON EXTRACT UDF'S DUE TO XML EXTENDER MEMORYLEAK IY24370 DROP NICKNAME COMMAND CAUSES TRAP IF AN ALIAS NAME FOR THE NICKNAME IS SPECIFIED INSTEAD OF THE ACTUAL NICKNAME NAME. IY24379 MONITORING CAUSES EEE RECOVERY FAILURE IY24386 WITH DB2ROUTINE_DEBUG=ON SET, EVERY OTHER TIME YOU CALL STORED PROC FROM COMMAND LINE YOU GET SQL1131. IY24410 CLI0614E WHEN USING THE NET DRIVER IY24413 DB2 TRAPS WITH MULTIPLE RESULT SETS WITH MIXED ENGINE ENVIRONMENTS (INTEL VS UNIX) - PROBLEM WITH STORED PROCEDURES. IY24423 DB2 UDB - INSTANCE CAN CRASH - TRAP IN SQLRR_CONNECT_OPTIONS WHEN MULTIPLE ACTIVATE/DEACTIVATE COMMANDS ARE ISSUED. IY24426 SQL0151N WHEN UPDATE A VIEW THAT HAS >1 EXPRESSION COLUMN IN COMMAND CENTER IY24468 DSNL500I RC=0864 MESSAGES ON THE OS/390 CONSOLE FOR EVERY TWO PHASE STRUCTURED DISCONNECT. IY24573 MEASSAGE FROM CLI_SDAINITSQLDAPARMFILING DB2DIAG.LOG FILE WITH ERROR 2064. IY24577 APPLY RECEIVES FREAD ERROR WITH RETURN CODE OF 872105. IY24613 DB2 CRASH, TRAP IN SQLJRCEPKGSNL FOR SUN SOLARIS GATEWAY USING DB2 CONCENTRATOR CALLING SP ON OS/390 RETURNING RESULT SETS IY24650 CREATE DATABASE LOGON WINDOW IS HIDDEN BEHIND PROGRESS INDICATOR IY24684 DB2 LINUX/390 DOES NOT YET SUPPORT ADSM/TSM BUT 'DB2ADUTL' AN 'DSMAPIPW' WERE SHIPPED. IY24687 IMPORTS A MULTI-COMMAND SCRIPT FROM COMMAND CENTER AND RUN SCRIPT: IT FAILS WITH SQL0104N ABOUT THE LAST STMT TERMINATION CHAR IY24757 SIGNAL #11 IN SQLBPFPRINTREQUEST IY24767 QUERY REWRITE INCORRECTLY REWRITES AN ASCENDING SORT INTO A DESCENDING SORT CAUSING INCORRECT RESULTS FROM A QUERY. IY24804 TABLESPACE TAKEN OFFLINE BY ROLLFORWARD CAN CAUSE DATA CORRUPTION IF ROLLED FORWARD AGAIN WITHOUT BEING RESTORED FIRST. IY24807 JDBC.NET.DB2DRIVER FUNCTION NEXT( ) RETURNING WRONG RESULTS IY24808 SQL0313N WITH CLI MINMEM MODE IY24837 CODE PAGE CONVERSION FROM UCS-2 TO UTF-8 TRAPS IF OUTPUT BUFFER IS TO SMALL. IY24847 BEGIN ATOMIC STATEMENTS DO NOT WORK WITH CLI - ODBC ERROR 42601 (SQL0104N) IN SQLEXECDIRECT() IY24859 SQL0901, SECTION LENGTH MISMATCH RETURNED IN SQLERRMC DURING TRANSACTION IY24862 INSTANCE HANG : WHILE RUNNING SNAPSHOTS AND TURNING STATEMENT EVENT MONITORS ON AND OFF , HANG CONDITION ENCOUNTERED IY24904 SQL0301 RETURNED AFTER AN ARRAY UPDATE WHEN ONE OR MORE PARAMETER SETS RESULTS WITH AN UNQUALIFIED WHERE CLAUSE. IY24915 SQL0901 WITH SQLNQ_STRING::NAMEFREE DURING QUERY PROCESSING IY24971 CRASH RECOVERY FAILS IN THE SQLMRDO FUNCTION, COMPLAINING ABOUT ERROR DURING REDO WITH FFFFF451 IY24982 SQL0501N RETURNED WHEN CALLING SP AGAINST 390 DB AND CURRENTPACKAGESET IS SET IN CLI LAYER BUY APP OR IN DB2CLI.INI IY24988 FEDERATED QUERY OF SQL SERVER 'SYSINDEXES' TABLE RETURNS HEX INSTEAD OF ASCII EQUIVALENTS FOR THE 'NAME' COLUMN IY25141 FORCE THE OPTIMIZER TO NOT CONSIDER LIST PREFETCH IF THERE AREE PREDICATES THAT HAVE HOST VARIABLES. THIS IS NOT THE SAME AS IY25226 WE SHOULDN'T TURN ON THE 4K LOCK REGION FOR NON-AIX PLATFORMS WHEN USING LF/LOBS. IY25264 POOR INSERT PERFORMANCE OF VARIABLE LENGTH COLUMN TABLE. IY25272 . QP NO LONGER WORKS WITH GROUPS AFTER APPLYING FP4 IY25292 TRAP IN SQLJIFSR WHEN GOING TO A DB2/390 V.7.1 IY25301 XA CONCENTRATOR NOT COMMITING IY25306 XA AND CLI CONNECTION POOLING ARE NOT CURRENTLY COMPATIBLE IY25314 OPERAND DELIMINATION FOR UNION ALL VIEWS WITH GROUP BY IY25356 ABEND IN UDF WHEN SETXXX METHOD CALLED. JAVA UDF. IY25366 SQL0901 SQLRMGJN : CODEPAGE IS '0' INTERNALLY ON SYSINDEXCOLUSE THIS RESULTS IN INDEX KEYS IN INCORRECT ORDER ON THIS TABLE ONLY IY25369 MEMORY LEAK IN MULTI-THREAD CLI APPLICTION IY25389 TRAP IN SQLE_TERM_DJ_ACB WHEN CALLING SQLOFMBLKEX IY25475 JAR ID SCHEMA ISN'T IN SYNCH WITH PROC_SCHEMA. IT IS CASE SENSITIVE WHICH IS SHOULDN'T BE. IY25484 INSERT WITH SELECT WITH AN ORDER BY CLAUSED WAS NOT SUPPORTED. QP WAS INSERTING 1 ROW AT A TIME. VERY SLOW. IY25644 IF BLOCK_ON_LOG_DISK_FULL IS ON AND THE DUAL LOG ARRAY BECOMES FULL, DB2 MAY GET INTO AN INFINITE LOOP. IY25658 SQL30090 RC=3 WHEN CALLING SQLCOLUMNS() IN XA ENVIRONMENT IY25720 LOG SPACE FULL DURING A CREATE INDEX OPERATION. SQLDCREATEINX RETURNS D509 : LOG FILE WAS FULL IY25748 DB2 CLP SELECT JAPANESE CHARACTER GARBAGE IY25897 DUPLICATE RESULTS RETURNED BY QUERY IN EEE ENVIRONMENT IY26093 SQL0206N FOR TRAILING TAB IN COLUMN NAME LIST FOR IMPORT FROM COMMAND WINDOW IY26097 TRAP IN SQLO_TRCE WHEN USING XA & 2PC IY26151 BETTER HANDLING OF LOB FILES IY26156 REDIRECTED RESTORE LOGS MISLEADING MESSAGES IN THE DB2DIAG.LOG. IY26186 IMPROVE THE COSTING FOR QUERIES INVOLVING ANY JOIN WITH A VALUESBOX IY26231 DB2 ON HP TRAPS REPRODUCIBLY IN SQLPARAMDATA() WHEN INSERTING LOBS IN A PIECEWISE FASHION WITHIN SAP 610 ENVIRONMENT. IY26259 SMALL WINDOW FOR INDEX CORRUPTION IN INDEX CREATED WITH MINPCTUSED PARAMETER DURING RECOVERY OF AN INCOMPLETE LEAF MERGE. IY26280 INCREASE AUTOLOADER SOCKET CONNECTION TIMEOUT VALUE FOR SQL6555N IY26387 WITH INTRA_PARALLEL ON, QUERY FAILED WITH SQL0901 IY26403 SNAPSHOT MONITORS DO NOT CAPUTRE THE SYSTEM/USER EXECUTION TIMESWHEN V7 CLIENT INTERACTS WITH V6 SERVER. IY26504 NULL INDICATORS FOR OUT PARMS ARE NOT BEING CLEARED PROPERLY FOR PSM MEMORY MODULE (FOR STORED PROCEDURES) IY26530 INCORRECT RESULTS FROM QUERY RELATED TO CSE PREDICATE PUSHDOWN IY26532 DB2AUDIT FAILS WITH AUD0022N WHEN FILE SIZE REACHES 4GIG IY26533 PROBLEM WITH UNICODE IN CLI. IY26535 DB2 APPEARS TO BE MASKING APPLICATION ERRORS BY RETRYING AFTER SQL0301N SQLCODE. IY26536 SQLJ IS BUILDING WRONG HOST VARIABLES FOR THE DECIMAL COLUMN. IY26557 EXCESSIVE REAL MEMORY USAGE RUNNING SIEBEL WITH DB2 ON SOLARIS. JR15627 MESSAGE QUEUE SIZE (1MB) IS NOT LARGE ENOUGH FOR A HEAVY TRANSECTION DATABASE SYSTEM. JR15712 SNAPSHOT OUTPUT SHOWS 'MAXIMUM ASSOCIATED AGENTS = 0' AND 'AGENTS ASSOCIATED WITH APPLICATION = 1' WHICH IS INCORRECT JR15831 LOAD MISTAKENLY INTERPRETS COLUMN NAMES JR15877 INSTANCE CRASH WITH EXCEPT C0000005 ON SQM_GEN_BUFFERPOOL_STREAMFUNCTION. JR15921 SQL3148W DURING IMPORT WITH INSERT_UPDATE MODE JR15936 AFTER SQL0905 FROM DB2 ON OS390, CURSOR IS NOT CLOSED AND ATTEMPTS TO ACCESS CURSOR GETS SQL0519. JR15963 LOCK SNAPSHOT HANGS DURING A ROLLBACK CAUSING ALL OTHER DB2 OPERATIONS TO HANG UNTIL ROLLBACK IS COMPLETE - WORKAROUND JR16210 DB2PROFC IS NOT USING QUALIFIER OPTION TO QUALIFY TABLES BEFORE DESCRIBING - RESULTS IN UNREPORTED SQL0204N JR16246 WHERE THE SOURCE=TARGET BUT INCREMENTAL COMMIT = ON, THE BV.ISATOMIC() FLAG SHOULD BE TRUE JR16262 NOT TO GENERATE MULTIPLE SEMIJOIN FETCH PLANS JR16263 DATE TRANSFORMER DOES NOT HANDLE INVALID DATES JR16266 CAN NOT USE DWC WITH SAMPLE DATA, IF USING ITIALIAN CODE PAGE JR16272 INSTANCE CRASHES WITH DIA9999E AND INTERNAL CODE 0XFFFFF7 WHEN EXECUTING A SPECIAL KIND OF SQL COMMAND JR16304 INIT OF DWC CONTROL DB LOCATED ON AIX ALWAYS GET -1403 JR16339 CLI0104 ERROR FROM MS QUERY WHEN TRYING TO CREATE NEW DATA SOURCE JR16346 MEMORY LEAK IN IBM OLE DB DRIVER JR16348 UN ABLE TO EDIT USER DEFINED PROGRAM JR16350 EXPORT TAKES SEVERAL HOURS TO RUN. JR16351 'PART OF OLAP SCHEMA' IS DEFAULT FOR DWC CREATED TABLES. JR16353 SQLGETINFO() WITH SQL_SQL92_VALUE_EXPRESSIONS RETURNS INACCURATEINFO. WITH AS/400 JR16354 WHEN RUNNING THE VWPRCPY UDB IN A STEP, THE RESULTANT LOG FILE FTPNNN.FTP SHOWS THE USERID AND PASSWORD (IN THE CLEAR). JR16361 SWAPPING EQUALITY PREDICATE WILL YEILD INCORRECT QUERY RESULTS. JR16364 SQL1022 READ_NODE_DIRECTORY()DOES NOT RETURN POINTER TO NODE DIRECTORY CACHE JR16366 CLOB VALUES NOT INSERTED PROPERLY WITH UNICODE JR16387 CLP CRASHES WHEN RUNNING FROM FILE JR16397 PASSWORD IS IN THE CLEAR, WHEN USER ATTEMPTS TO EXECUTE ETIEXMVS UDP. PASSWORD IS WRITTEN TO A FILE. JR16412 TRAP IN ADD_DCS_APPL_COUNTER, THE THIS POINTER IS OVERWRITTEN. JR16424 MISLEADING DBA3039 WHEN LAST EXPLAINED STATEMENT IS REMOVED FROM HISTORY IN CONTROL CENTER JR16425 UDP IS DOING A REPLACE BECASUE A WRONG TYPE WAS DURING MIGRATION JR16435 CONTROL CENTER PERFORMANCE WITH LDAP - REDUCE SCANNING OF LDAP JR16441 RIGHT CLICK TO ADD DEPENDENCY THE CANDIDATES LIST IS NOT SORTED JR16443 SQL0010N. TERMINATION CHARACTER IS NOT RECOGNIZED IN THE INTERACTIVE TAB IN THE COMMAND CENTER JR16448 SPB: INSERT -> SQL STORED PROCEDURE USES WRONG BUILD UTILITY JR16449 CONTROL CENTER SHOWS BLANK FOR STATUS CHANGE TIME (CONT'D FROM JR16253) JR16453 WHEN SETBYTES() IS USED TO INSERT INTO A BLOB TYPE COLUMN, SETBYTES() FAILS WITH SQL0301N ON BOTH FP3 AND FP4. JR16456 OS/390 REPLICATION SOURCE IN DATAWAREHOUSE THE COLUMN NAMES GET SWITCHED TO UPPERCASE AND THERE IN AN ERROR (CASE SENSITIVE) JR16460 WHEN CONCENTRATOR ENABLED (MAX_LOGICAGENTS > MAXAGENTS) ALONG WITH DB MONITOR SWITCHES, TRAP IN ENGN_SQE WHEN OUT OF MON HEAP JR16462 ROWSTATUSARRAY OF SQLEXTENDEDFETCH SHOULD REFLECT SQL_SUCCESS_ WITH_INFO FOR THE ROW(S) THAT GENERATED CLI0165E JR16463 MIGRATED BUSINESS VIEWS FROM VW V5.2 ARE EXECUTING INCORRECTLY IN V7.2 ENVIRONMENT. JR16464 DWC7906 DOESN'T PROVIDE THE NAME OF THE PREDESSOR STEP THAT FAILED JR16465 PLEASE SUPPORT THE DB2 IDENTITY COLUMNS IN THE WAREHOUSE. WHEN A ROW IS INSERTED IT AUTOMATICALLY ADDS A UNIQUE VALUE IN COLUMN JR16466 CLP DOES NOT TRANSLATE POUND (OTHER) CHARACTERS CORRECTLY. JR16467 DB2DRIVER FINALIZER NOT CLEANING UP JDBC AND CLI RESOURCES JR16468 MIGRATION ERROR 3110 RECEIVED BECAUSE THE BUSINESS VIEW NAME WAS TOO LONG JR16469 LOGON HANG WHEN THE CONTROL DATABASE NAME IS INVALID OR NOT CATALOGED. JR16470 SQLALLOCHANDLE() CALL HANGING IN MULTITHREADED ENVIRONMENT JR16471 RECEIVING A CONFUSING MESSEGE WHEN IMPORTING TABLE DEFINITION. JR16472 PROBLEMS UPDATING THE WAREHOUSE PROPERTIES JR16482 INSERT RETURNS SQL0358,RC=21 ON MACHINE NAMES CONTAINING HYPHEN JR16483 USEREXIT RETURNED ERROR ON ARCHIVE LOG FILE S00000000.LOG FROM C:C:\MYLOGS FOR DATABASE DBNAME JR16486 PROBLEMS WITH SQL ASSIST WHEN THE SOURCE IN AN ORACLE DATABASE JR16488 USEJDBC2.BAT FAILED BUT 'INUSE' SHOWS JDBC2.0 JR16489 ERROR CODE: -11 ERROR MESSAGE: GSE0011E SPATIAL EXTENDER COULD NOT DISABLE JR16490 THE WIP PRODUCES TOO MAN DATABASE CONNECTIONS AND THEN EVENTUALLY FAILS JR16491 SQL0301N IN SQLPARAMDATA AFTER APPLYING FIXPACK 3. DEFECT INTODUCED BETWEEN FIXPACK2 AND FIXPACK3 FOR V710. JR16493 "PUBLISH TO ICM" FUNCTION WAS USING THE WRONG USERID AND PASSWORD JR16494 RUN OUT OF VIRTUAL MEMORY WHEN PUBLISHING METADATA TO INFORMATION CATALOG JR16497 DWC INITIALIZATION RUNS NEVER END JR16498 OLEDB MEMORY GROWTH WHEN CALLING SPS WITH PARAMETER MARKERS. JR16505 THIS APAR IS OPENED TO TRACK THE DEFECT#181439:PROVIDE FEDERATEDSUPPORT FOR TYPED PARAMETER MARKER TO INCREASE PERFORMANCE JR16507 NULL INDICATORS JR16508 THE SPB ERRONEOUSLY SETS INPUT VARIABLE STRINGS TO NULL EVEN IF THE USER UNCHECKS THE 'TREAT EMPTY STRINGS AS NULLS' BOX. JR16515 WRONG DB NAME WHEN CONNECTING TO DATABASE FOR EXPORT OF DATA JR16524 INCORRECT SYNTAX ERROR RETURNED FROM CC SHOW COMMAND WINDOW JR16525 CONTROL CENTER PERFORMANCE PROBLEM WHEN CREATING A SUBSCRIPTION JR16526 ADD GETCLOB() AND GETBLOB METHODS FOR CALLABLESTATEMENT JR16529 ON THE SCHEMA MODELLER SELECT VIEW ARRANGE THE SCREEN GOES BLANK JR16530 LABELS DO NOT SHOW UP ON STATISTICS WINDOW UNTIL YOU RESIZE THE WINDOW. JR16531 ZOOM FUNCTION ON SCHEMA MODELLER NEEDS TO BE DISABLED JR16535 GOING THROUGH CCA AND MANUALLY ADD A USER DSN GIVES CCA3000C RC 32 WHEN ATTEMPT TO FINISH. JR16536 CATALOGING PROFILE IMPORTS TWICE GET DIFFERENT RESULT JR16540 SQL UPDATE OF GRAPHIC FAILS. SQL0301N JR16542 SQL0804N WHEN RETRIEVING SPATIAL DATATYPE COLUMN (UDT) JR16545 DATA LINK ARROW INCORRECT IN SCHEMA MODELER JR16547 ZOOM FUNCTION NEEDS TO BE DISABLED JR16548 DATA WAREHOUSE CREATED DEFAULT TABLE IGNORES TABLE SPACE PARM. JR16550 INFORMATION NOT SAVED WHEN USER CAN'T CONNECT TO AGENT JR16551 IMPORT TABLES DOES NOT SHOW PROGRESS INDICATOR LONG ENOUGH JR16552 SINCE SB3 THE LABELS ARE MISSING FROM THE STATISTICS WINDOW JR16555 THE VIEWER FOR THE PROCESS MODELER TAKES A LONG TIME OT OPEN FOR COMPLEX PROCESSES JR16557 DB2CC SAVES WHERE CLAUSE IN LOWER CASE JR16559 ICM CHANGE ETI APP DATA RELATIONSHIP TO CONTAIN FROM LINKED JR16575 IMPORT UNABLE TO CREATE GRAPHIC,VARGRAPHIC AND BLOB COLUMN INTO UNICODE DATABASE JR16583 IMPORTING TABLE DEFINITION INTO AN EXISTING TABLE TAKES TOO LONGIN DATA WAREHOUSE CENTER. JR16585 MS INTERDEV RECEIVES UNSPECIFIED ERROR USING OLE-DB JR16589 UNABLE TO OPEN WIP WINDOW AFTER SORTING JR16590 STORED PROCEDURES W/ CHAR DECLARED DOES NOT WORK AFTER V720 FP4. JR16591 ISSUE A CONNECT STATEMENT FROM INTERACTIVE WINDOW, CONNECTION IS FINE BUT ARE PRESENTED WITH AN ATTACH WINDOW JR16593 LONG VARCHAR (UNICODE-GREEK) DATA IS NOT BEING COVERTED PROPERLYWHEN QUERYING RESULT FROM THE COMMAND CENTRE JR16594 CREATE INDEX ON NICKNAME WITH PCTFREE SPECIFIED RETURNS ERROR, BUT CREATES THE INDEX ANYWAY JR16595 JDBC DEFECTS FOUND DURING J2EE CTS TESTING. JR16600 IF YOU CREATE A TABLE AND ADD A GRAPHIC COLUMN THEN ISSUE A DB2LOOK TO GET THE DDL THE GRAPHIC COLUMNS IS DOUBLED JR16603 RADIO BUTTON IN DWC WILL NOT ENABLE I-SERIES TRANSFORMERS JR16604 THE DB2EVA SORTING WAS NOT WORKING DUE TO A PROBLEM CONVERTING DECIMAL POINT TO A COMMA. THIS IS AFFECTED BY THE SYSTEM LOCALE JR16608 TABLE SCHEMA CHANGE = NO IMPORT JR16614 FROM CLAUSE MISSING IN THE BUILD SQL WINDOW WHEN USING AN ORACLE SOURC JR16620 STORED PROCEDURE BUILDER IS NOT DISPLAYING HEX DATA CORRECTLY JR16657 WINNT DB2MSCS/DB2ICLUS SUPPORT COMPUTER NAME GREATER THAN 8 CHAR JR16669 RUNSTATS CAUSES DB2 TO TRAP IN SQLIPROCESSCOL JR16676 DB2 GATEWAY TRAPPING AFTER RECEIVING DATA FROM A STORED PROCEDURE ON OS/390. JR16680 HANDLING LOCK CONFLICT OF CONDITIONAL LOCK FOR APAR JR16242 JR16694 EMBEDDED ASSOCIATE STATEMENT IN SQL PROC. STATEMENT DOES NOT LIKE QUALIFIED PROCEDURE NAMES. JR16696 INFINITE LOOP IN CLI CATALOG CALLS AGAINST VM DB2. JR16697 SIGNAL 11 IN WRITEPAGES PQ54378 IMPORT TABLES GETS 'ASN.IBMSNAP_REGISTER IS AN UNDEFINED NAME', EVEN WHEN NOT USING REPLICATION. APAR fixes included in WR21269 (Fixpak 4) APAR No. Abstract -------- -------------------------------------------------- GG04203 APPLY GETS SQL -104 WHEN HANDLING MANY COLUMNS GG04205 ASNLOAD FAILED WHEN INVOKING APPLY USING A NETWORK ID. 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. GG04213 CAPTURE FAILS TO PRUNE DB2 LOG RECORDS WITH LOGRETAIN=CAPTURE. GG04214 APPLY DID NOT FULLREFRESH IF CAPTURE COLD START AT REPLICA GG04215 CAPTURE WILL NOT PRUNE LOG RECORD IF LESS THAN 100 RECORDS ARE PROCESSED DURING A START STOP CYCLE. IC31116 USING RELATIONAL CONNECT TO CONECT TO AN ORACLE DATABASE, DB2 CRASHS WITH SIGNAL#11 IN HASH_ENTRY::CLEAR() IY15472 QP CANNOT HANDLE CLI STATEMENT WITH ASYNC ENABLED IY15730 INSTANCE CRASH ON TRAP (SIGSEGV) IN SQLBLATCHPINNEDPAGE EEE ONLY. INTERNAL SYNCHRONIZATION PROBLEM EXECUTING SQL. IY16963 SECONDARY CONNECTS SHOULD NOT BE PART OF APPLICATION CONNECTS INDB SNAPSHOT IY17251 CHANGING DB2 TERMINATE BEHAVIOUR FROM ASYNCHRONOUSTO SYNCHRONOU S IY17328 IBM CLI DRIVER CLI0102E INVALID CONVERSION. SQLSTATE=07006 ENCOUNTERED DURING FETCH OF A BIGINT COLUMN. IY17499 RUNNING A CREATE PROCEDURE THRU THE STORED PROCEDURE BUILDER, CAUSES THE DB2 ENGINE TO CRASH DUE TO STACK CORRUPTION. IY17522 AN APPLICATION SENDING A BAD RID (BOOKMARK) CAUSES DB2 TO PANIC,AND AN ENGINE TRAP DURING A DIRECT FETCH. IY17526 SQL1015N, DATABASE MARKED BAD DUE TO IMPROPER SAVEPOINT HANDLING IY17563 -901, REASON 'NO CAST FUNCTION' IY17574 $N CLAUSE IN CREATE TABLESPACE PROBLEM IY17631 SIG 11 TRAP IN SQLRIRST IY17651 ONLINE DATABASE BACKUPS RETURN SQL2038N RC -3838 AFTER A FAILED CREATE TABLESPACE IY17698 APPLY UPDATED THE WRONG SYNCHPOINT AND SYNCHTIME IN PRUNCNTL TBL IY17735 FLOATING POINT CONVERSION OF STRINGS WITH >8 CHARACTERS FOR SITUATIONS WHERE THE STRING USED IS >8 CHARACTERS. IY17791 SET CURRENT PACKAGESET IS BEING IGNORED BY QUERY PATROLLER. IY17828 TABLESPACE REMAINS IN LOAD PENDING IF ASC/DEL FILE NOT ACCESSIBLE IY17874 LATCH DEADLOCK IN MONITOR CODE IY17927 CHANGE DB2DCLGN OUTPUT TO BE COMPATIBLE WITH WITH DB2 MVS DECLARATIONS. IY17952 BINDING FAILS WITH -30073 SQLCODE (SQLERROR CONTINUE) IY17967 BACKUP RETURNS SQL2048 WHEN IT SHOULD RETURN OUT OF DBHEAP IY17973 CREATE PROCEDURE CAUSES IMPROPER SAVEPOINT HANDLING - FFFFF520 -AND POSSIBLE INSTANCE TRAP IY17975 SIGNAL #11 TRAP IN SQLNR_GBPD_PARTITION DURING SELECT AT OPTLEVEL 2 OR HIGHER IY18094 AN AGENT HANGING IN TQ CODE, ANOTHER STUCK ON APM LATCH IY18117 TRAPS (SIGNAL #6) IN FUNCTION SQM_EVMON::LOG_EVENT() IY18120 APPLICATION WITH MINCOMMIT 4 AND HANGS WAITING FOR LOG DATA TO BE WRITTEN TO DISK IY18123 MEMORY LEAK IN SQLRI_LIKR_ALLOC() IY18124 MAX_SYNCH_MINUTES WITH CCD - APPLY UPDATES THE SUBS_SET SYNCHPOINT INCORRECTLY CAUSING POTENTIAL DATA LOSS IY18138 THE CLP ON SOLARIS CALLS GETPASS WHEN ISSUING AN EXPLICIT CONNECT WITHOUT A PASSWORD GIVEN WHICH LIMITS THE NUMBER OF CHARS TO 8 IY18217 CATALOGING ONE DATABASE WITH TWO DIFFERENT ALIASES TO TAKE ON-LINE BACKUPS FOR EEE IY18219 SQL0902 ON SET INTEGRITY WITH IMMEDIATE CHECKED FORCE GENERATED IY18220 DLFSCM_POSTSTART.DFS->RETURNS 0->SUCCESS, BUT 'FAILED' IY18253 LOG DIR FILLS DUE TO OLD LOG FILES NOT BEING DELETED/RENAMED DURING CRASH RECOVERY, AND SAME LOG IS REPEATEDLY ARCHIVED IY18295 SAMPLE USEREXIT SHOULD INDICATE THAT 'MOVE' IS UNSUPPORTED FOR LOG ARCHIVING - ONLY 'COPY' IS SUPPORTED IY18308 A NEW DB2 HISTORY FILE IS CREATED DURING A FAILED MIGRATION, WHICH CAUSES ALL SUBSEQUENT MIGRATIONS TO FAIL. IY18319 MONITOR DCS APPLICATION CONTROL BLOCK WAS NOT CLEANED UP WHEN RUNNING WITH THE CONNECTION CONCENTRATOR ON. IY18333 DB2CFEXP DOES NOT UPDATE DB2CLI.INI SOMETIMES IY18340 SQL0973N WHEN PACKAGE CACHE NOT OVERFLOWED - CAUSED BY NOT ACCOUNTING FOR OSS OVERHEAD. IY18346 STORED PROCEDURE HANGING WHEN COMMIT IN STORED PROCEDURE AFTER INSERT STATEMENT. 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 IY18379 ON CONNECT REQUEST, TRAP: RQRIOBLK TRIPLET BAD SETUP IY18433 -901 FOLLOWED BY -4946N ON BIND. IY18453 CONTROL CENTER INCORRECTLY FOLDS USERID TO UPPER CASE USING THE NATIONAL LANGUAGE CODE PAGE INSTEAD OF THE ENGLISH CODE PAGE. IY18499 DURING CRASH RECOVERY, WE COULD HAVE A REQUEST TO FLUSH THE LOG TO AN LSN BEYOND THE TAILLSN->RECOVERY FAILS, SHOULD SUCCEED IY18522 NO REASON CODE IS RETURNED WITH SQL1550N FOR SUSPEND I/O AFTER RESTORING IY18570 BACKUP/RESTORE HANG UNTIL DB I/O'S ARE RESUMED WHEN ATTEMPTING TO BACKUP/RESTORE A DB WHICH IS SUSPENDED. IY18571 'SET WRITE SUSPEND FOR DATABASE' COMMAND HANGS UNTIL BACKUP/ RESTORE IS COMPLETE, WHEN ATTEMPGIN TO SUSPEND I/O IY18600 IN JAVA, DOING GETBIGDECIMAL()ON A COLUMN TYPE DOUBLE YOU WILL GET NUMBERFORMATEXCEPTIONIF DOUBLE IS IN EXP. FORMAT. IY18603 SQL0901 - 'COLUMN NO. OUT OF RANGE' ERROR WHEN RUNNING A QUERY FOR A VIEW OF A TABLE WITH ALIAS. IY18611 DEADLATCH IF EVMON AND SNAPSHOTS ARE CALLED IN THE SAME TIME IY18622 CLI APP HANGS FROM CLIENT VIA GATEWAY ON SELECT OF DB2/390 TABLEIF CURSOR TYPE REQUESTED IS NOT FORWARD ONLY CURSOR IY18626 DATA TYPE PROBLEM IY18644 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 IY18663 SQL4908N IS GENERATED WHEN RF ON TABLESPACES IS ISSUED AGAIN ON TABLESPACES WHICH ARE RF PENDING STATE AND FLAG IN LFH IS ON. IY18704 RESTORE HANGS WHEN SERIES OF SUCESSFUL RESTORE OPERATIONS ARE ATTEMPTED ONE AFTER OTHER OR RESTORE EXECUTED WITH FEWER BUFFERS IY18741 MEMORY CORRUPTION OCCURS WHEN USING QP WITH AN APPLICATION. IY18759 ALL-CONTAINERS-CLAUSE ON ALTER TABLESPACE INCONSISTENT SYNTAX IY18761 DATA IS NOT LOADED COMPLETELY FOR AUTOLOAD WHEN USING MORE THAN 1 SPILIT NODE AND DATA IS REMOTELEY LOCATED IN THE HOST. IY18798 ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER PREPARE IY18815 SIGNAL BUS ERROR WHEN TRYING TO FORMAT DB2 TRACE IY18846 DYNIX/PTX ONLY: DARI TERMINATES ON TRAPS IN STRNCPY IN DARI SUPPORT CODE WHEN LARGE NUMBER OF DB2 PROCEESES ARE SPAWNED IY18916 DCS AUTHENTICATION IS NOT SET CORRECTLY FOR DRDA WRAPPERS. IY18987 TRAP IN SQLNO_CRULE_INDEX_ANDING WHEN OUT OF STMTHEAP IY19003 PERFORMANCE DEGRADATION BETWEEN V5.2 AND V71 IY19025 CREATE DATABASE STATEMENT USING THE 'WITH' ARGUMENT THAT EXCEEDS30 CHARACTERS RETURNS THE INCORRECT ERROR MESSAGE IY19033 QUERY AT OPTLEVEL 3 RECEIVES A SQL0101 EVEN WITH STMTHEAP MAXED IY19034 NOT ROUTING TO MULTIPLE REPLICATED AST REFERENCES IY19042 ISERIES (OS/400) V5R1 AS A CLIENT DOES NOT INTEROPERATE WITH WORKSTATION DB2 UDB AS A SERVER IY19084 INVALID DEFAULT DATES INSERTED DURING LOAD. IY19095 DB WITH LINKS IN PATH FAILS TO RESOLVE PATH FOR BACKUP. A -1062 OR -1042 RESULTS, SUBSEQUENT CONNECTS MAY TRAP (SIG11). IY19124 CLI TRACE DOES NOT CAPTURE SOME UNICODE FUNCTIONS IY19173 SQLDREDOUPSERT REPORTS A PROBLEM DUE TO INCORRECT MINBUFFLSN DURING UNDO PHASE OF DB RECOVERY IY19204 IN THE EUREKA ENVIRONMENT, DB2QE IS NOT BEING INVOKED, THEREFOREQUERY ENABLER HANGS. IY19208 SQL0901N ' UNKNOWN MEMORY POOL ' RUNNING QUERIES , OR SQL0101N RUNNING QUERY WITH DISTINCT CLAUSE. IY19212 SQL1224 INSTANCE SHUTDOWN - TRAP IN SQLRL_OPEN ON RESTORE DB2DIAG.LOG CONTAINS SQLEFIRSTCONNECT MEMORY ALLOCATION FAILURE IY19230 QUERY REWRITE ISSUE IY19260 CLI0121E ' INVALID COLUMN NUMBER ' RECEIVED IN BRIO APPLICATION USING QUERY PATROLLER IY19285 WAS: BLOB AND SETBINARYSTREAM PROBLEM. IY19315 MS 932 IS EQUIVALENT TO IBM 943. WE ARE ACTUALLY DOING CODE PA IY19337 SMALL TIMING WINDOW WHERE THE CAPTURE READS A LOG WHILE IT IS BEING ARCHIVED -> WORKAROUND: RETRY SHOULD RESOLVE IY19360 SQL0900N: LOAD RECREATE INDEX DOES NOT UPDATE METAROOTPAGE PROPERLY. IY19369 TRAP IN SQLNR_RIJEL_ACTION IY19386 AUTOCOMMIT CANNOT BE TURNED OFF WHEN QUERY PATROLLER IS ACTIVE. IY19494 LONG PREPARE TIME FOR EEE QUERIES INVOLVING MULTIPLE JOINS, WHERE AT LEAST ONE OF THE TABLES RESIDES IN A MULTI-NODE NODEGRP IY19511 DEFAULT VALUE NOT USED FOR GLOBAL TEMP TABLE IY19530 CORRECTION OF THE OUTER_DVALS CALCULATION FOR ORDERED NLJN IY19532 CHANGE DATA LINK DATA TYPE NAME FROM URL TO DATALINK IY19536 ERROR MESSAGE DIA3808C IS INCORRECTLY DUMPED OUT IN THE DB2DIAG.LOG FILE WHEN THE ACTUAL ERROR IS SQL1013. IY19560 . SQL29007 RECEIVED WHEN THE CATALOG NODE IS NOT A QP NODE. IY19581 QUERY PATROLLER MONITOR MAINTAINS PERSISTENT CONNECTION TO DATABASE DB2 UDB EEE 7.2. IY19606 DURING THE DLFM INST MIGRATION, WE ARE NOT UNMOUNTING DLFS, WHICH CAUSES './DB2IMIGR: DLFSMNTPNTS: PARAMETER NULL OR NOT SET' IY19610 DB2BATCH RETURNS ELAPSED TIME 'NOT COLLECTED'FOR INSERT STMT IY19657 WHEN A COMMAND IS RECEIVED, CAPTURE STILL READS A LOG RECORD BUTFORGETS IT, AND READS THE NEXT RECORD AFTER PROCESSING THE CMD. IY19659 SQL5005 SYSTEM ERROR WHEN DOING MIGRATE DATABASE FOR A V5 DB IY19704 DB2LOOK -F REPORTS WRONG DB CFG INFO IY19786 JVM CRASHES WHEN PASSING NULL TO STATEMENT.EXECUTE( ) IY19797 TRAP - SIGNAL 11 IN SQLPM_WRITE_LOCKS WHILE PERFORMING LOCK SNAPSHOT CRASHED THE DB2 INSTANCE IY19809 UDB EEE 7.X HAS RESTRICTION NOT ALLOWING INSERT INTO LOCAL TABLEWITH SELECT FROM NICKNAME IF PARTITIONED IY19813 HIGH CPU TIME DURING SNAPSHOTS IY19878 ALTERING SUMMARY TABLE FROM REFRESH IMMEDIATE TO REFRESH DEFERRED IS NOT REFLECTED IN SYSCAT.TABLES IY19947 CUSTOMER IS NOT ABLE TO FETCH DATA IN ITS ENTIRETY AFTER APPLYING FIXPACK 3 ON SAP SYSTEM. IY19955 AUTOLOADER HANGS WHEN USING FILE_TRANSFER_CMD AND LOAD ABORTS IY19956 SQL1042C ON CONNECT TO A CONSISTENT DATABASE TRYING TO ALLOCATE INITIAL LOGS OVER A LOG THAT WAS EXTERNALLY TRUNCATED/CORRUPT. IY20025 DB2 CRASH AFTER RUNNING A FENCED SAP UDF IY20038 DB2PFCHR,DB2PCLNR,DB2REBAL,DB2ESTOR PERSIST EVEN AFTER DBM SHUTDOWN & CONSUME CPU RESOURCES UNTIL REBOOT: RESULT POOR PERFORMAN IY20047 REVERSE INDEX SCAN CAN MISS KEYS IF HIT PARTIAL PAGE SPLIT ROLL-BACK. IY20049 REVERSE SCAN MISS KEYS IF HIT PAGE SPLIT (TIMING). IY20063 SQL0973 QUERY HEAP MEMORY LEAK - CLI ONLY WHEN DATA TYPES OF PARAMETER AND COLUMN DO NOT MATCH, DB/APP USE DIFF CODEPAGES IY20067 DB2 INSTANCE SHUTDOWN: TRAP IN SQLRA_FP_COPY ON ABNORMAL TERMINATION OF DARI AND DROPPING OF CONNECTION. IY20069 PROBLEM WITH DATAPROP/CAPTURE. TIMESTAMP NOT INITIALIZED. IY20074 ACCESS VIOLATION ON NT CLIENT WHEN CALLING STORED PROCEDURE ON UNIX SERVER (V71FP3) WHEN DB2_RUN_PSM_TRUSTED=YES ON SERVER IY20092 RECEIVING A SQL236 WHEN RUNNING LOCAL QUERYS AGAINST QUERY PATROLLER IY20119 HASH JOIN GIVES INCORRECT OUTPUT. IY20128 POOR INDEX CREATE / REORG PERFORMANCE AFTER UPGRADE TO V7.1 FP2 - MMAP I/O WRITES UNINTENTIONALLY DISABLED FOR INDEX OBJECTS IY20144 NO ROWS ARE RETURNED WHN A +437 IS RETURNED IN MINMEM IY20152 SQL0998 RC=13 AX_REG() AND AX_UNREG() NOT FOUND IY20159 ROLLFORWARD STATUS = TABLESPACE, BUT NO TABLESPACE IN THIS STATE -> RESTORE, THEN TBLSPC DROPPED B/F ROLLFORWARD IY20221 SQL4912N WITH SQLJ HOST VAR IN LIKE COMPARISON AGAINST MVS 6 IY20236 SQLPUPDATEMINBUFFLSN PROBE:50 SHOULD NOT BE DUMPED INTO THE DB2DIAG.LOG AS IT IS ONLY INFORMATIONAL USED FOR DEBUGGING IY20319 SQLBGETPOOLSTATS CAN CAUSE LOG CORRUPTION IY20326 NESTED SQL SP CALLED WITHOUT QUALIFIER FAILS IY20360 MOVEMENT OF ENCRYPTED DATA BETWEEN PLATFORMS RESULTS IN ERROR SQL20146N IY20480 ADD FUNCTIONALITY TO SUPPORT EEE RESTORE FROM LEGATO AND XBSA IY20508 CATALOG CONTENTION WHEN QP JOBS ARE RUNNING (2) IY20536 TRAP IN SQLCSPC_COOR_REG WHEN HOST EXPERIENCES COMM. PROBLEMS IY20539 PROBLEM WITH V720/IBM JDK 1.2 AND USE OF JAVA SPS IY20558 ACCESSING A BASE TABLE WITH A REPLICATED TABLE DEFINED ON IT CAUSES DB2 TO CRASH - SIGNAL 11 TRAP IN SQLNO_KEY_SAT_KEY. IY20575 SQLM_GENERIC_CONVERT PROBE 10 AT INCORRECT MESSAGE LEVEL IY20662 EMBEDDED RPATH PROBLEMS ON SGI. IY20693 QUERY PATROLLER CAUSES SAS SEGMENT FAULT. IY20793 SQLPUTDATA OF ZERO BYTES IN CAUSING A MEMORY OVERWRITE IY20795 COMMAND CENTER DOES NOT HAVE A SCROLL BAR IN ITS HISTORY WINDOW. IY20796 QUERY RETURNS SQL0950N UNABLE TO DROP TABLE,DUE TO ACTIVE CURSOR IY20802 DB2 CONNECT MAY CRASH WHEN PROCESSING THE REPLY FOR AN APPLICATION THAT IS THE VICTIM OF A DEADLOCK OR TIMEOUT IY20808 SIGNAL #11 IN SQLNO_PROP_JCARD() IY20966 SELECT JOIN FROM MULTIPLE FEDERATED NICKNAMES INTO EEE TABLE => ERROR SQL0901N SQLSTATE=58004 IY20995 CALLING STORED PROC. EG.{CALL PROC(1234,?)} CAUSES SQL0171 IY20997 POINTER IS NOT INITIALIZED CORRECTLY IY21046 APP_CTL_HEAP_SZ RUNNING OUT OF MEMORY WHEN READING CLOB DATA VIAADO IY21064 DB2BATCH PRODUCES A COREDUMP WHEN ONE LINE EXCEEDS 3896 BYTES / SQL0100W ARE NOT DISPLAYED WHEN RUNNING DB2BATCH IY21082 BUFFER CORRUPTION CAUSES REPLICATION TO FAIL. IY21083 SPLIT MIRROR BACKUP TERMINATED - SMS TABLESPACE NOT ALLOWED. IY21174 RECEIVED SQL8011W ON DB2START WITH RESTART OPTION IY21204 WEBSPHERE STARTUP PERFORMANCE DEGREDATION. IY21223 INSTANCE TRAPS ACCESSING SEQUENCE. IY21281 TRAP IN SQLEGETAGENTFROMPOOL() WHEN CONNECTING TO SYSPLEX ENV ONHOST. IY21295 LIST DCS APPLICATIONS EXTENDED GIVE WRONG STATUS CHANGE TIME IY21311 SPLIT MIRROR ROLLFORWARD COMPLETES PREMATURELY OR SQL1042C , HANG DURING SPLIT MIRROR ROLLFORWARD. IY21374 POUND STERLING SYMBOL FAILS IN DB2 PRECOMPILE. IY21394 THE HOST DB2 DATABASE BACKUP FAILS AS IT SEES THE LINK FILES ON DLFM ARE NOT YET BACKUPED. IY21410 FORWARD FIT FOR APAR IY06126 INTO V6 AND HIGHER IY21413 DB2OPTIONS: CLP IS USING THE OSS FUNCTION SQLOFPRT IY21443 ELSE CLAUSE IN UDF OF V7 FP3 EEE ON AIX PREVENTS OUTPUT OF CORRECT RESULTSET. IY21449 LENGTH OF PARMNAME IS INCORRECT AND ADDING SPACES TO ACTUAL VALUE IN THE SYSPROCPARMS IY21522 APPLY USES THE WRONG PRUNE CONTROL ROW WHEN CAPTURE IS STARTED COLD. IY21581 SIGSEGV IN GET_DBMON_BP, WHEN DROPPING A TABLESPACE IY21599 SQL0902 RC 29 ON COMMIT USING WITH HOLD CURSOR AFTER LOCKLIST FULL CONDITIONS - SQL0912 - ON OPEN / CLOSE IY21661 TRAP / HANG WHEN LOCK ESCALATION OCCURS DURING REBIND AT DIAGLEVEL 4 IY21683 SQL0802N DURING AVERAGE COMPUTE IY21705 MISSLEADING ERROR MESSAGE -31 DURING THE BINDING. THE ACTUAL MEESAGE SHOULD BE A WARNING SQL1530W. IY21710 SQL0204N DUE TO INCORRECT SQL STATEMENT BEING GENERATED WITH PATCH1=32768 SET IY21757 IMPROVE QP PERFORMANCE BY ALTERING OPTIMIZATION. IY21767 CONTROL CENTER IS VERY SLOW. IY21820 JDBC BATCHING NOT CLEANING UP OBJECTS WHEN A CLEARBATCH() IS ISSUED. IY21838 SYSFUN.POWER UDF PROBLEMS, NEGATIVE BASE TO POWER GREATER THAN TWO RETURNS INCORRECT RESULTS ... IY21846 DPROPR APPLY DOES 2 FULL REFRESHES AFTER CAPTURE COLD START. IY21860 SQL1042C WHEN LIST APLICATIONIS ISSUED AND THERE ARE CONNECTIONS. IY21911 PSM PUT ROUTINE NOT ACCEPTING STATEMENTS LARGER THAN 32765 IY21917 BACKUP TO NAMED PIPES HAS SLOWER PERFORMANCE THAN BACKUP TO A FILESYSTEM IY21941 IF SQLPREP->SQLNUMRESULTCOLS GENS SQL_SUCCESS_WITH_INFO WILL SEE CLI0125E AND HAVE PROBLEMS DURING SQLEXECUTE. IY21943 VB IDE GETS "ERRORS OCCURRED" MESSAGE WHEN TRYING TO GET A LIST OF STORED PROCS WITH NAMES GREATER THAN 8 BYTES. IY21945 DB2DCLGN CHANGES JAPANESE CHARACTER '835F' INTO '832D' IY21955 CORE FILE GENERATED IF ALL PHYSICAL MEMORY USED ON CLIENT IY21968 ALLOW DB2BATCH TO SUPPORT REAL DATA TYPES IY22003 GET SNAPSHOP NEEDS TO GET THE DBCB LATCH WHEN REPORTING LOG SPACE. IY22152 SQLEEXECUTEINTERRUPT GIVEN THAT THIS CAUSES THE PDB SYSTEM CONTROLLER TO TERMINATE ABRUPTLY AND BRINGS THE INSTANCE DOWN IY22160 MEMGETCHUNK() FAILS WHILE ALLOCATING MEMORY IY22174 QP IWM_REMOTE PROCESS GOES INTO LOCK WAIT ON USER QP JOB. IY22232 DO NOT PROMOTE THE DATATYPE IN SQLBINDPARAMETER TO A LOB FROM A LONGVARCHAR IF SPEC LENG IS <32700 AND LONGDATACOMPAT=1 IY22244 DB2/HACMP - NODE RECOVERY NEVER COMPLETES BECAUSE WE ARE LOOPINGIN THE SQLEEXECUTENODERECOVERY(). IY22248 DB2 CRASH WITH SIGNAL 11 IN SQM_STMT_LIST() IY22260 WHILE A QUERY PATROLLER JOB IS RUNNING, IT HOLDS A Z LOCK ON ITSQUERY RESULT TABLE IY22310 QP RERFORMS POORLY WHEN LISTING JOBS IY22311 DBA2192 /SQL1403 WHEN LOG INTO COMMAND CENTER WITH NON-ADMIN ID. IY22325 USING SAMPLE CONTENTS DIAGLOG IN CONTROL CENTER LOCKS ENTIRE TABLE BEING SAMPLED AS LONG AS CONTROL CENTER REMAINS OPENED. IY22331 ENCOUNTER ARITHMATIC OVERFLOW, FOR NUMBER OF ROWS RETURNED IY22342 DURING DB2STOP DB2SYSC PROCESS GETS HIGH CPU. IY22391 TIMESTAMPS WITHOUT MILLISECONDS COPY UNINTIALIZED MEMORY TO OUTPUT IY22407 PERFORMANCE : EEE QUERY REFERENCING UDF IS NOT SMP-ENABLED WHEN ONLY 1 ROW IS SELECTED FROM A TABLE IN A JOIN IY22473 NEW USER DOES NOT HAVE PRIVILEGE TO THE RESULT TABLE SPACE IY22490 GETSCHEMAS() DOES NOT RETURN THE SCHEMA WITH APP DRIVER ON SOLARIS ONLY (DB2 V7.2) IY22624 BACKUP/RESTORE HELP IS INCORRECT IY22633 INCREMENTAL BACKUP MIGHT BE MISSING PAGES IY22763 REDUNDANT OR CLAUSES NOT FILTERED BY QUERY REWRITE IY22828 SIG11 INSTANCE CRASH TRIGGERED BY RUNNING SQL_STATS_INDEX API FOR RUNSTATS. IY22994 ENABLING TRACKMOD AND MPFA,SQLBSMSDIRECTWRITE GENERATE WARNINGS IY23141 SIGNAL 11 TRAP IN SQLBLATCHPINNEDPAGE() IN MPP/EEE ONLY INVOLVESA WHERE CURRENT OF CURSOR (WCOC) UPDATE OR DELETE STATEMENT. IY23226 ALTER TABLE DATA CAPTURE NONE NOT WORKING IY23457 APPLY DOES NOT RUN 'SQL AFTER' ON DIFFERENTIAL UPDATE WHEN CAPTURE IS FROM AS/400 AND SYNCHPOINT IS NULL IY23460 DB2ADUTL HAS A ARCHIVE LOG LIMIT OF 1023 ENTRIES. IY23474 ADDITION OF CODE TO CHECK FOR ORDER BY CLAUSE ON AN UNTYPED PARA METER MARKER IY23475 DB2 CRASHES AT FUNCTION SQLESRVR IY23481 SUBOPTIMAL PLAN CHOSEN FOR STAR JOIN IY23487 DEFECT IN CLI IN REGARDS TO HOW WE DETERMINE THE CTX USED AT THE ENVIRONMENT LEVEL. IY23488 SQLJ CUSTOMIZER SHOULD SUPPORT MULTIPLE SER CURRENT PACKAGESET STATEMENTS. IY23491 CLEANUP CODE FOR COMM. HANDLER AT WRONG PLACE - SQLFREEBUFFER CR IY23498 DIA3847C AN ERROR OCCURRED IN A DATABASE PAGE HEADER BY DB2PFCHR IY23503 DB2BATCH DOES NOT SUPPORT VARGRAPHIC, CAUSES TRAP. IY23504 DYNAMIC SQL SNAPSHOT FIELD TITLE CHANGE IY23515 TRAPS WHEN USING LOB FILE INPUT DATA IY23517 ERRORS GENERATED FROM SQLO_AUTHORIZE_SEM_POOL: SQL0465N RC=23 IY23521 ONCE JOBIDS HIT 999, JOBIDS ARE REUSED. HOWEVER, JOBS ISSUED VIA 'RUN NOW' KEEP REUSING SAME JOBID IY23522 ATTRIBUTES ON SQLLIB/FUNCTION/JAR DIR FOR 'OTHER' NOT PROPER. IY23527 RUNSTATS DOESN'T UPDATE SYSIBM.SYSCOLUMNS CORRECTLY IY23550 CLI SQLEXTENDEDFETCH() GETS "NUMERIC VALUE OUT OF RANGE" IY23574 TRAPPED IN SAVEPOINT WHILE ROLLBACK,SHOULD IGNORE SQLCODE- 1035 FROM REMOTE NODE JR15226 TIMING PROBLEM. TWO THREADS ACCESSING SAME MEMORY AREA WHEN NETWORK CABLE IS PULLED. JR15385 CUSTOM DPREPL.DFT SETTINGS FOR CONTROL CENTER NOT PICKED UP. JR15645 CHANGES MADE BY A STORED PROCEDURE WILL BE ROLLED BACK IF RUN FROM DWC JR15727 HOST VARIABLES SPLIT OVER MULTIPLE LINES IN COBOL APPS RESULT INSQL0306N WHEN APP IS PRECOMPILED VIA DB2 PRECOMPILER. JR15740 CURRENTSQLID NOT USED UNDER MTS TRANSACTION ENVIRONMENT. JR15748 INACCURATE DBHEAP VALUE SHOWN IN 'GET DB CFG' OUTPUT ISSUED FROMA REMOTE CLIENT. JR15767 EXECUTEQUERY() DOES NOT THROW AN EXCEPTION WHEN IT IS USED FOR SQL STATEMENTS THAT DO NOT RETURN A RESULT SET JR15788 DETAILED STATS PRODUCE BAD PLAN AT OPT 5 JR15807 IMPORT USING MODIFIER IMPLIEDDECIMAL PROBLEM JR15810 IMPORT FROM CCA FAILS (HANG) JR15811 KEYSET CURSOR QUERY DOES NOT WORK AGAINST TABLE ALIASES. JR15815 RUNGSEDEMO , ENABLE DB FAILS WITH -964 JR15827 CONNECTIONS TO LOCAL DATABASE CONSUME LAN CACHED CREDENTIALS ON WINDOWS 2000 WHEN NOT CONNECTED TO DOMAIN JR15833 SQL3017N DOING LOAD WITH TIMESTAMPFORMAT="YYYYMMDD" MODIFIER. JR15838 ERROR IN LAUNCHING BROWSER FROM THE INFORMATION CENTER NO DATA IS RETURNED JR15846 CONTROL CENTER PLUGIN MENU ITEMS DO NOT APPEAR FOR DB2/390 TABLES JR15858 USERIDS NEED WRITE AUTHORITY ON DAS DIRECTORY TO RUN SCRIPTS JR15859 COGNOS IMPROMPTU APPLICATION IS FAILING WITH CLI0501N WITH ASYNC=1 JR15873 INTERACTIVE PAGE OF THE COMMAND CENTER REMOVES EXTRA BLANKS FROMAN EXPRESSION IN A WHERE CLAUSE JR15878 IN OLEDB, WHEN SQLMORERESULTS CALLED RATHER THAN SQLEXECUTE, COLUMNS NOT BOUND JR15879 SCROLLABLE, READ-ONLY CURSOR CRASHES THE INSTANCE WHEN TRYING ON A FEDERATED TABLE. JR15898 SMCODE=-28 FROM PERFMON AFTER CC ABNORMAL TERMINATION JR15902 GETTING CLI0114E ON INSERT OF A RECORD WITH A DATETIME DATATYPE IN A VC++ APPLICATION JR15925 QUERY PATROLER ABENDS WHEN ISSUEING MULTIPLE QUERIES. JR15957 GRANT/REVOKE STATEMENT DOES NOT VALIDATE DB GROUP NAME TO HAVE ALENGTH OF <= 8 CHARACTERS LONG. JR15961 CALLED ON NULL INPUT OPTION FOR SQL FUNCTIONS RETURNING SQL0628N JR15975 TELNET TO JDBC DAEMON (DB2JD(S)) TRAPS AFTER KEYING 10TH CHARAC TER JR15978 SIGNAL #4 IN SQLNO_FF_LIT_EQ_LIT() JR15990 IN COMMAND CENTER, RESULT SET WOULD NOT DISPLAY IN DISPLAY WINDOWHEN OPTION FOR RESULT SET IS PIPED TO FILE SELECTED JR16006 THE RESULTS OF AN SQL WITH STATEMENT ARE NEVER DISPLAYED ON THE QUERY RESULTS PAGE OF THE COMMAND CENTER JR16007 DB2BATCH ON NT CRASHES WITH AN EXCEPTION. JR16018 UNICODE RETURNS GARBAGE: DATA RETRIEVED FROM A TABLE IN AS/400 WHEN USING WAREHOUSE AND MANAGER CENTER IS RETURNED AS GARBAGE. JR16040 DB2TBST TOOL DOES NOT SHOW THE STATE OF ALL THE TABLESPACE STATEIN SQLUTIL.H JR16051 DB2 CONNECT REQUESTING ORIGINAL ROWSET SIZE, INSTEAD OF OUT- STANDING ROWS, WHEN SERVER UNABLE TO RETURN THE COMPLETE ROWSET JR16059 FIX THE SYSCAT.SEQUENCES CATALOG VIEW ON NT JR16060 LOAD WITH CLIENT OPTION RETURNS SYSTEM ERROR -91 JR16082 COMMAND CENTER TAKES TOO LONG TO BE LAUCHED. JR16088 TABLE WITH INDEX AND LONG VARCHAR WILL ONLY RETURN FIRST COLUMN JR16094 INSTALL UDB 7.1 FIXPACK 3 ON TOP OF SYSTEM WITH DB2 UDB 7.1 ANDDB2 OLAP SERVER 7.1, BUT NO STARTER KIT EVER INSTALLED JR16112 CACHE DROPS VARIATION BEFORE STATEMENT IS COMPLETED RUNNING! DB2UPDV7 WILL FAIL ON SOME TYPES OF MIGRATED DATABASES JR16113 FP3 CAUSES THE COMMAND CENTER TO FREEZE WHEN SAVING A SCRIPT. JR16127 FEDERATED D.O. ICON DISSAPEARS RANDOMLY ON REFRESH JR16129 GUIS WILL HANG IN V7.2 IF THERE IS INTERACATION BETWEEN THE COMMAND CENTER AND THE FILE SYSTEM JR16131 EXECUTEUPDATE() DOES NOT THROW EXECEPTIONS FOR SELECT STATEMENTS JR16132 INTERVALTIMEOUTVALUE DEFAULT VALUE SET TO ZERO IN THE CLI.INI JR16134 ON V7.1 FP3, SETTING DB2_SQLROUTINE_PREOPTS TO A DATETIME OPTIONPRODUCES A SQL4930N JR16135 ROLLFORWARD SHOULD DETECT AN INCOMPLETE LOG FILE JR16143 HANDLE THE SQL0104 ERROR FOR VENDOR ESCAPE CLAUSES WITHIN THE DESCRIBE. SQL0007N MIGHT ALSO BE SEEN. JR16156 CLI PROBLEM, DO NOT NEED TO RESCAN DIRECTORY ON EVERY OUTPUT. THIS LDAP OPERATION IS EXPENSIVE. JR16160 SIGNAL 11 IN SQLNO_COST_MGJN JR16170 SPATIAL EXTENDERS' UDF ARE EXPANDED INTO TABLE FUNCTIONS WITH INPUT QUANTIFIERS OF TYPE 'FUNCTION ARGUMENT TABLE QUNS'. JR16174 ENABLE FOR SPATIAL EXTENDER FAILS ON DB2 EEE DATABASE JR16181 INVALID PROMOTION OF SQLSTATE 01517 WARNING TO SQL ERROR DURING DATA CONVERSION OF X'FEFD. JR16184 GETCOLUMNNAME() WITH NET DRIVER TRUNCATES COLUMN NAME TO 29 CHARACTERS IF COLUMN NAME LENGTH IS 30 CHARACTERS JR16186 FOR THE FOLLOWING QUERY INVOLVING A NICKNAME AND A SPATIAL FUNCTION, OPTIMIZER THROWS A 'PLAN NOT FOUND' ERROR. JR16192 CONTROL CENTER PERFORMANCE MONITOR DOES NOT WORK ON LOCAL ALIASED DATABASES. RESULTS IN DBA4750 WITH SMCODE -36 JR16195 INCORRECT ORDER OF ORDINALS RETURNED BY SELECT FROM SYSIBM.SYSPROCEDURES CAUSES IMPORT SP PROCCESS TO FAIL. JR16199 ENFORCE GROUP NAMES TO BE 8 CHARACTERS OR LESS IN DBM CFG JR16205 GRANT USAGE ON SEQUENCE DOES NOT BEHAVE CORRECTLY. JR16211 TRAP IN SQLNO_FF_COL_RGWHEN DOING SELECT JR16215 FAILING INSTRUCTION AT 6CA95A59 OFFSET: 00000369 IN DB2LOOK GENERATES UNRELATED VIEWS FOR THESPECIFIED TABLE WHEN USING THE -T OPTION. JR16243 LOCK CONFLICT SHOULD NOT BRING DATABASE DOWN WITH -902 JR16244 SQL0465 RC=27 WHEN INVOKING A UDF JR16245 USER CANNOT RETRIEVE THE ERROR MESSAGE ASSOCIATED TO A GIVEN RUNTIME ERROR FROM WITHIN AN SQL PROCEDURE. JR16247 JDBC2.0 FUNCTION EXECTUEBATCH( ) NOT WORKING AS IT SHOULD. JR16252 MEMORY READ ERROR, WHEN REFERENCING TABLENAMES CONTAING '\_' ON A AS400 USING SQLCOLUMNS() IN ASYNC MODE. JR16253 STATUS CHANGE TIME FOR GATEWAY IN CONTROL CENTER SHOWS BLANK JR16260 AT INSTALLING DB2 AT A BACKUP DOMAIN CONTROLLER ON NT, USERNAME CAN NOT BE A FULLY QUALIFIED USERNAME SINCE '/' IS NOT ACCEPTED JR16276 IN COMMAND CENTER, USING THE DB CONNECTION BUTTON, SELECT SERVERAND DATABASE, IT DISPLAYS THE PASSWORD IN PLAIN TEXT (NO MASK) JR16286 ADD ADDITIONAL DIAGNOSTICS TO SQLOIQUE() CALL MADE IN SQLPALR_OPENRESPONSEQUEUE JR16287 ADD FUNCTIONALITY TO DISABLE USEREXIT RETRIEVE, THIS IS ENHANCEMENT FOR SOME CUSTOMERS HOT STANDBY SCENARIOS. JR16293 INTERMITTENT CRASH CAUSES: THE INSTRUCTION AT 0X6D84A374 REFERENCED MEMORY AT 0X00000008 JR16296 OS/2 DB2 BACKUP VIA USEREXIT WILL FAIL AT AND AFTER SUNDAY SEPTEMBER 9TH 01:46:39 2001 JR16301 SQLGETDATA() FAILS TO RETRIEVE DATA AFTER SQLSETPOS() JR16303 EXTRA OR CORRUPTED DATA IN COLUMNS OF THE APPLICATIONS WINDOW OFTHE CONTROL CENTER. JR16310 COMMAND CENTER DOES NOT IMMEDIATELY DISPLAY THE TEXT TYPED IF YOU START TYPING BEFORE THE CONNECTION DIALOGUE IS RETURNED. JR16313 SQLTABLES DOESN'T GET AS400 SCHEMA WITH '_' FROM NT JR16333 JDBC IS NOT HANDLING THE SETCONNECTIONATTRIBUTE() CORRECTLY. AND THERE IS NO WORK AROUND. JR16391 DRDA_HEAP_SZ MEMORY LEAK. SYMPTOMS: SQL30081, RC= *,*,0. JR16398 DB2 IS TRAPPING IN THE FUNCTON SQLEMRSP_AS.C JR16402 DB2 ABENDS IN SQLERUNSYSCTLR DUE TO DOUBLE-FREEING OF MEMORY DARI PROCESS JR16403 PROBLEMS WITH ETIEXUNX USING SUN SOLARIS AGENT JR16404 DB2EVA CAUSED AN INVALID PAGE FAULT IN MODULE DB2ADMIN.DLL JR16405 STORED PROCEDURE BUILDER DOES NOT ENABLE ITS BUILD MENU ITEMS AND TOOLBAR ICONS WHEN CONNECTING TO DB2 FOR OS/390 VERSION 6 JR16409 SQL30081 RC:10054 JR16410 CREATING EVENT MONITOR ON "DATABASE A ALIAS A1" USING EVENT MONITOR GIVES DBA5500. JR16411 TRAP IN SQLE_DB2RA_AS_DB_FETCH APAR fixes included in WR21251 (Fixpak 3) APAR No. Abstract -------- -------------------------------------------------- GG03862 EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1 GG03928 SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY. 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 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 GG04129 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS GG04136 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT GG04155 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE PRUNCNTL GG04157 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE GG04159 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR GG04161 APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG. GG04189 FULLREFRESH FROM SECOND TIER CCD TO 3RD TIER CCD DID NOT WORK. GG04190 APPLY BINDS USING PRUNE LOCK TABLE WILL NOT BIND TO CAPTURE/VM WHICH DOES NOT HAVE THIS TABLE. GG04194 CAPTURE USES TOO MUCH MEMORY - WIN NT SPECIFIC PROBLEM GG04196 OVERRIDE THE DEFAULT PARAMETERS OF LOGREUSE AND TRLREUSE USED BY ASNSAT WHEN INVOKING APPLY. GG04201 ASNCMD STOP FAILS TO STOP DATAPROPAGATOR CAPTURE. IY12218 APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH IY12425 DBI1034W WARNING DURING DB2SETUP ON SUN INSTALL IS CONFUSING OR WRONG IF CORRECT JAVA (JDK/JRE) VERSION IS INSTALLED IY12823 REINIT CMD WAS IGNORED WHEN THERE IS NO CHANGES TO CAPTURE 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. IY13655 ADD NEW DB2LOOK SCHEMA OPTION REMOVED BY DEFECT 153542 IY13818 -804 ERROR IN APPLY SQL0804N SQL0804 IY13958 DB2ATLD WITH THE DUMPFILES OPTION IS CREATING DUMPFILES WITH THE INCORRECT OWNER ID IY14016 PATH TO DSM.SYS AND DSM.OPT WHEN USEREXIT ENABLED IY14030 ROLLFORWARD COMPLAINS 'LIFELSN MISMATCH FOR REORG-REDO IY14152 CAPTURE UNABLE TO FINISH PRUNING WHEN LOG FILE SYSTEM BECOMES FULL (SQL0964C) IY14154 CAPTURE NEEDS TO REINIT LONG FIELD DATA STRUCTURES FOR ANY NEW REGISTRATION PICKED UP BY THE REINIT COMMAND IY14222 AUTOBINDER FAILING AGAINST FEDERATED DATABASES IN DB2V7 IY14234 DB2LOOK FAILS WITH TABLENAMES CONTAINING SLASHES IY14240 TO BETTER EXPLAIN COMPILER OPTIONS FOR DB2UEXT2.CADSM SAMPLE PRO GRAM IY14278 CONTOL CENTER - ALTER TABLE - ADD COLUMN FAILS WITH SQL30081 TCP/IP ERROR '*','*', '0' IY14291 CAPTURE CORE DUMPS WITH SIGABRT, LONG VARCHAR COLUMNS IY14298 CUSTOMER SELECTS, IN JOURNAL, A COMPLETED SPECIFIC JOB TO DISPLA Y AND THE DB2DAS00 GOES DOWN. IY14463 CAPTURE GETS IN A LOOP WHEN ASNCMD GETLSEQ IS IN LOCK STATE IY14706 IMPORT WITH BUFFERED INSERT CAUSES TABLE LOCK ON SYSIBM.SYSPLAN IY14728 CUSTOMER REQUIRES TO MOVE JAVA STORED PROCEDURES FROM ONE SERVER TO ANOTHER IN BATCH IY14820 ERROR DURING ALLOCATION OF LOG FILE CAUSES DATABASE TO SHUTDOWN IY14858 CAPTURE SHUTS DOWN WHENEVER IT RECEIVES SQLCODE 2653DURING COLD START. IY15022 CONVERSION TABLE ERROR MESSAGE IS INCOMPLETE IY15068 INCORRECT FILTER FACTOR COMPUTATION FOR RANGE PREDICATES 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. IY15116 ASN0017E RETURNED WHEN CAPTURE FAILS TO START FROM A USERID THAT IS DIFFERENT FROM THE DB2 INSTANCE OWNER IY15122 SUPPORT FOR SQL_ARD_TYPE DATA TYPE. IY15123 PARSING OF COUNT (EXPRESSION) FAILS WITH COMPLEX EXPRESSIONS IY15152 FAILED 'BACKUP DB ... ADSM ...' ARE NOT BEING CLEANED IN ADSM CAUSING 'DB2ADUTL' TO RETURN EXTRANEOUS RESULTS IY15185 CCA ON NON-DRDA CLIENTS IMPORTING SERVER PROFILE CATALOGS EXTRA NODES. 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. IY15200 CLOSING SINGLE CONNECTION AFTER MULTIPLE CONNECTION IS ESTABLISH TO REMOTE SEVER RESULTS IN CLI0106E ERROR ON IRIX PLATFORM. IY15209 SQL_INVALID_HANDLE ERROR IS RECEIVED WHEN SQLTABLES IS CALLED BEFORE SQLCOLUMNS. IY15286 CAPTURE PRUNING PROBLEMS WHEN LOGRETAIN=CAPTURE IY15287 DB2 MEMORY LEAK FOR UDF WITH CLOB PARAMETER WHERE UDF RETURNS AN ERROR IY15297 COBOL APPLICATION NOT HANDLING LARGE NUMBER OF HOST VARIABLES. IY15354 PARSER IS NOT DETECTING A SYTAX ERROR IN CREATE PROCEDURE. IY15403 FUNCTION TEMPLATE SYNTAX EXTENSION IY15421 SUBSEQUENT PARAMETER BINDINGS FOR VARCHAR WITH JDBC ARE NOT HAVING THEIR COLDEF LENGTHS UPDATED CAUSING CLI0109E 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. IY15468 AFTER CATALOGUING LOOPBACK AT SERVER, LUWID ON SERVER AND OS390 DO NOT MATCH IY15508 SQL1084 - SHARED SEGMENT NOT CLEANED UP ON INSTANCE DETACH IN MLN CONFIGURATION (EEE ONLY) USING DB2NODE OR ATTACH_NODE IY15535 WRONG RESULTS CAUSED BY A MGJN WHICH IS NOT PROPERLY ORDERED. IY15541 FROM COMMAND CENTER, CONNECT TO A DB NAME CONTAINING THE STRING 'USER' WILL RESULT IN PROMPT FOR UID/PWD IY15572 QP SECURITY VIOLATION IY15596 QUERY PATROLLER - EXPLAIN MODE = EXPLAIN FAILS IY15665 IWM_TRACKER DOES NOT PROCESS QUERIES THAT RETURN DON'T RETURN ANY COLUMNS (EG. SELECT COUNT (*) FROM TABLE1) 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. IY15739 DB2EXMIG WILL FAIL WITH SQL0104 (SYNTAX ERROR) ON A RENAME TABLE STATEMENT IY15749 SEGMENTATION FAULT USING IWM_TRACKER IY15758 DB2LICM -A CHANGES PERMISSIONS ON /VAR/IFOR. NOBODY EXCEPT ROOT CAN COMPILE (IBM C/C++ COMPILER) IY15793 FP INSTALL BREAKS DJXLINK WHEN WORKING WITH V.8.1.X ORACLE CLIENTS 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 IY15846 ABEND WHEN USING VARCHAR 600 FOR BIT DATA IY15853 HANG IN COMMAND CENTRE WHEN LAUNCHING VISUAL EXPLAIN IY15858 CAPTURE SHUTS DOWN WHENEVER IT RECEIVES SQLCODE 2653DURING COLD START. IY15861 USEREXIT FAILED, BECAUSE DATABASE ACTIVATED AFTER OFFLINE BACKUP IY15865 CAPTURE IGNORES SQLCODE -2038.THIS IS A WORKSTATION-ONLY PROBLEM IY15866 CAPTURE MIGRATION NOT ALLOWED DUE TO SQLCODE -2656. IY15913 CAPTURE FAILS - SQL2038 RC 32 IY15916 USING QMF V7.1 FOR WINDOWS TO ACCESS PARTITIONED DATA ON DB2 UDB EEE V7.1 RESULTS IN SQL1013 'DATABASE COULD NOT BE FOUND' IY15931 HASH_JOIN MEMORY ALLOCATION PROBLEM WHICH MARKS DB BAD. IY15949 'LIST INDOUBT TRANSACTIONS' FAILS WITH DB21018E IY15975 MEMORY LEAK IN AIX APPLY IY15976 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. IY16012 GETDATE() RETURNS DIFFERENT VALUES IN APP VS NET IY16056 USING CID REINSTALL INTERACTIVE QUESTIONS 'OVERWRITE YES/NO' ARE APPEARED FOR OS/2 IY16081 DATABASEMETADATA.GETDRIVERNAME() RETURNS LIBDB2.A INSTEAD OF DB2 IY16113 JDBC JAVA.LANG.UNSATISFIEDLINKERROR:DB2CONNECTION.SQLFREECONNECT IY16120 QUERY PATROLLER 9K OR LARGER MEMORY ERRORS IY16123 NULLABLE FIELD NOT CHANGED WHEN PICKING GUI 'GENERATE COL CONTEN IY16159 VERSIONING NOT SUPPORTED IN DB2DATASOURCE CODE IY16162 CPUSPEED AUTODETECT SET TO DEFAULT IF CPU TOO FAST IY16164 ASNCAPTURE RETURNS -1 WHICH INDICATES A FAILURE EVEN WHEN A NORMAL MOBILE STOP HAS OCCURRED. IY16165 QUERY PATROLLER ERROR WHEN GRANTING PUBLIC ACCESS TO RESULT SET IY16208 MQBACK ROOLBACK FROM MQSERIES CAUSES PROBLEMS IN EEE ENVIRONMENT IY16210 DB2DART /DDEL EXPORTS INCORRECT DATA ON NULL VALUE. IY16221 POOR PERFORMANCE ON QUERY WHEN JOIN NOT PUSHED DOWN THROUGH UNION ALL VIEW IY16224 WRONG MAPPINGS FOR ERROR MESSAGE SQL0465N AGAINST OS/390 IY16229 DB2 UDB AUTOLOADER REPORTS INCORRECT VALUES FOR NUMBER OF ROWS LOADED. AUTOLOADER DOES HOWEVER SUCCESSFULLY LOAD ALL ROWS. IY16241 TCP/IP PACKET SIZE IS 512 BYTES OF PAYLOAD- PERFORMANCE IMPACT IY16278 CLI_SDAINITSQLDAPARM MSG TOO LARGE, CAUSING HP TO TRAP. IY16281 IMPORT INSERT_UPDATE UPDATES NON-TARGET COLUMNS SQL0407N IY16294 MAX COST LIMITATION WITH V6.1 QP GUI. IY16371 EXPORT TO LARGE IXF FROM V6 CLIENT TO V5.2 SERVER RESULTS IN MISSING ROWS IY16383 MISALIGNED DATA IN DB2 CAUSES HP TO TRAP IY16394 FFFF877E ON CREATE VIEW 'DUPLICATE VIEW DEPENDENCY' IY16397 SQL2025N RC=-50 ON A DB2 BACKUP TO ADSM AFTER A NODE IS ADDED THAT DOES NOT CONTAIN DATA (EG. TEMP TABLESPACE) IY16431 DB2ADUTL REPORTS INCORRECT NODE NUMBERS IY16434 DB2ADUTL RETURNS INCORRECT OUTPUT IY16435 USING MULTIPLY_ALT FUNCTION THAT IS INTRODUCED IN DB2 V7.1 FP2 CAUSES SQL0901N IY16457 SIGNAL 11 IN SQLM_A_INIT IY16487 LOAD OF TRUNCATED IXF CAUSING RECORD LENGTH <0 CAUSES EDU CRASH IY16496 QUERY FAILED WHEN THERE ARE 2 CONNECTIONS IY16499 DB2 UDB ON UNIX/OS2/WINDOWS TRAPS WHEN ACESSED FROM HOST OR AS/4 IY16508 DB2_CALL_STACK CREATE SIGNAL 11 TRAP IN SQLR_DUMP_SECTION. IY16512 PACKAGE CACHE OVERFLOW AND SQL0973N. IY16513 TRAP IN SQLOFMBLKEX, BUT BAD POINTER IS FROM SQRRCOM_RDS IY16516 REDIRECTED RESTORE FAILS WHEN SPECIFYING EXISTING CONTAINERS FFFF F707 INSTANCE CRASHED IY16518 DATABASE CRASHES AFTER INTERRUPTED REORG IY16529 DB2INIDB PRODUCES A TRAP (SIGNAL 11) AND A CORE IY16532 CREATE GENERALISE REPLICATION SCRIPT -> SAT3052, CANNOT FIND DBPROBLEM RESULTS WHEN ALIAS IS NOT THE SAME AS DB NAME IY16533 INVALID GENERATED COLUMN SETTING CAUSES SET INTEGRITY TO FAIL 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. IY16644 JOBIDS ARE NOT REUSED WHEN 999 LIMIT IS REACHED IN SCHEDULER IY16674 CHANGING CAPTURE CODE TO PROCESS ALL THE COMMITS IN THE LOCAL NODE, WHICH WILL INCLUDE THE LOG RECORD TYPE OF 'C' IY16678 SQL1042 - INSTANCE CRASH / PANIC ON EEE WHEN MAXAPPLS IS HIT - SQL1040 - AND AN INTERRUPT OCCURS AT THE SAME TIME IY16693 SQLDESCRIBEPARAM NEEDS TO DESCRIBE 1ST PARAMETER MARKER VS 1ST PARAMETER IY16695 CHANGE THE CLI DEFAULT TO NO COMMIT ON EARLY CLOSE OF CURSOR IY16711 POOR PERFORMANCE IN SORTING ON HP DUE TO ALIGNMENT TRAPS IY16721 BAD FILTER FACTOR ESTIMATES FOR 'LIKE ?' AND ZERO FF FOR BETWEEN PREDICATES IY16734 DEBUG CODE TO DUMP INFO WHY USEREXIT STOPS ARCHIVING LOGS IY16746 INDEX STOP/START KEY LOGIC ALLOWS TOO MANY ROWS IY16750 TWO-PHASE CONNECT FAILED WITH SQL0902C 94 CCI IY16754 SQL2062N AN ERROR OCCURRED WHILE ACCESSING MEDIA '/APPS/DIT/NEWYORK/DB2/P1DBINC/SQLLIB/ADSM/LIBADSM.A'.RC:'137 IY16780 TABLE BEING MARKED FOR DELETE PENDING BEFORE LOG RECORD IS WRITTEN IY16784 PRECOMPILE OF PL/I APPLICATIONS ON AIX MAY RESULT IN SQL4903 INDICATING 'RUNTIME_PID' WAS INVALID ON 'SQLASTRT_TRUSTED' IY16790 DEFAULT SCHEMA BIND OPTION NOT SET WHEN COMPILING PSM PROCEDURE IY16799 SIGNAL 11 IN SQLNO_ANALYSE_FUNC_OF_COL IY16812 GETDRIVERNAME() CALL TO RETURN OUTPUTS TO DISTINGUISH BETWEEN JDBC APP AND NET DRIVERS. IY16814 SEG FAULT WHEN RUNNING DB2EXPLN IY16822 THE FLAT FILE WRAPPER AS THE WRAPPER CAN ONLY SUPPORT ONE PREDICATE AT A TIME (PER SELECT) IY16836 DATABASE CRASHES ON FAILURE TO ALLOCATE MEMORY FOR A SMALL SORT SQLZERDM : FFFF D600 : A MEMORY HEAP ERROR HAS OCCURED IY16854 DATA CORRUPTION OCCURS ATTEMPTING TO GET BLOB FROM DBCS DB IY16879 SQL4903N SAYING THAT LENGHT OF 'RUNTIME_PID' PARAMETER OF FUNCTION 'SQLASTRT_TRUSTED' IS NOT VALID IY16924 NEED TRANSACTION BASED REPLICATION FOR READ ONLY TARGET TYPES OF PIT AND USERCOPY. IY16934 TABLESPACE RECOVERY FAILS/HANGS DURING FIRST ROLLFORWARD. IY16937 DB2ADUTL FAILS WITH ANR0445W - MAXIMUM GROUP TRANSACTION SIZE EXCEEDED. IY16962 TEMPDIR KEYWORD IN DB2CLI.INI CAUSES CLI0157 TO OCCUR IY16978 CHANGE APPLY TO INCLUDE CREATION OF /SQLLIB/DPROPR IN THEUSER'S HOME DIR TO STORE FILES LIKE PID FILE IF THE LIB IS NOT PRESENT IY16993 DB2LOOK PRODUCES OUT-OF-ORDER COLUMNS FOR FOREIGN KEYS IY16999 SQL QUERY CONTAINING EXTENDED CLAUSE GIVES SQL0007N ERROR FROM QUERY PATROLLER BECAUSE ORIGINAL QUERY TEXT IS USED IY17006 LOGSPACE INFORMATION REPORTED IN DB2 SNAPSHOT IS INCORRECT IY17012 POOR PERFORMANCE ON CERTAIN QUERIES INVOLVING UNION IY17013 EXCESSIVE COMPILE TIME FOR QUERIES WITH LARGE NUMBER OF UNION BRANCHES IY17017 CAN'T RUN DB2GOV WITH SYSADMIN GROUP USER THAT IS NOT DB2 INSTA NCE OWNER. IY17036 CLI0109 STRING DATA RIGHT TRUNCATION ERROR WHEN CLEARPARAMETER() IS USED IY17052 DB2SPLIT FAILED IF OUTPUT FILE > 2GB IY17059 DB2ATLD USES SORT BUFFER TO OVERRIDE THE SORTHEAP IN DB CFG. IY17079 DIA3711C A FILE '' COULD NOT BE FOUND MESSAGE DUMPED INTO THE DB2DIAG.LOG FILE SHOULD HAVE THE FILENAME IY17087 DBQSTART HAS MISSING ERROR CHECKING IY17104 DB2 INSTANCE CRASHED WITH SIGNAL #11 IN SQLRA_FP_COPY() IY17134 SIGNAL 11 TRAP IN SQM_SNAP_APPL_REMOTE RUNNING 'DB2 GET SNAPSHOT FOR ALL REMOTE_APPLICATIONS'. IY17162 DB2EXFMT FAILS WITH QUERY PATROLLER ENABLED SQLSTATE -805 IY17163 WHEN EXTRACTING DDL FOR A TABLE USING DB2LOOK, THE OUTPUT COLLEC TED SHOWS SOME UNRELATED VIEWS. IY17176 SIGNAL#11 IN SQLIFNXT IY17177 SIGNAL#11 IN SQLE_CHECK_EARLY_FETCH IY17181 ERRNO:0000 0009 DUMPED IN LOG DURING A SUCCESSFULL BACKUP. THIS APPEARED AFTER APPLYING FP6 IY17199 PRECOMPILER REJECTING THE INDICATOR VARIABLE ATTACHED WITH THE HOST VARIABLE. IY17204 DB21018E WHEN CALLING SP FROM CLP IY17247 WHITE SPACE IN THE DB2CLI.INI FILE IY17255 RESTORE DB FAILES WITH SQL5005 SQLF_MIG_REL8 FFFFEC41 IY17263 GETS ERROR IN DB2DIAG.LOG SQL -901 SQLERRMC: SQLNO_CRULE_SAVE_PL ANS ́100•:RC(0) SQLERRP :SQLRFAKE WITH STAR JOIN PLANNING. IY17264 QUERY PATROLLER CAUSING CATALOG CONTENTION PROBLEM IY17286 AFTER APPLYING FP2, THE NUMBER OF CONNECTIONS TO THE DATABASE GOES DOWN WITH SQL0956C. THIS IS DUE TO - DDBMON_COMPILER_METRIC IY17287 DB2 UDB DRDA AS (APPLICATION SERVER) TRAPS WITH SIGNAL 36 WHEN TRYING TO FREE MEMORY IY17292 DURING OFFLINE BACKUPS GET INTERMITTENT SQL1042C UNEXPECTED SYST EM ERROR OCCURRED. IY17299 A FILE SHARING VIOLATION HAS OCCURRED, FILENAME WAS ''.ZRC=FFFFF 616.DB2 FAILS TO USE THE ARCHIVED LOG FILES,HELD BY OTHER APPLIC IY17302 CRASH WITH SNAPSHOT MONITORING. FFFF A602 IN DB2DIAG.LOG REPORTE D BY SQLOFMBLK IY17304 AUTOMATIC DATA LINKS BACKUP TO TSM -> RC: 2036 (SQL2036) 'UNABLE TO PREFORM AUTOMATIC BACKUP OF ...' IY17360 SQLJMF91 ATTEMPTS TO USE MEMORY THAT WAS FREED IY17373 CONNECTING TO AN OS/390 DB2 (ANY VERSION) FROM UDB V.7.1 THROUGHTHE CONTROL CENTER HANGS THE CONTROL CENTER. IY17378 SQL0902 ON BACKUP IY17395 A LARGE NUMBER OF LOCK-WAIT ON CATALOG TABLES USING NOT LOGGED INITIALLY TABLES IY17396 PROBLEM WITH RRTRIM FUNCTION. IY17400 SQLRRBCK() SHOULD NOT DUMP MESSAGES TO DB2DIAG.LOG IY17425 DB2CCOR/DB2CCWRK PAIR DOES NOT TIME OUT WHEN SPAWNED IN THE CONTEXT OF NODES STATUS MONITORING IY17431 DB2 CRASH WITH SIGNAL 11 IN SQM_INIT_SQLM_TABLESPACE() IY17441 IMPROVE QUERY PATROLLER'S PERFORMANCE FOR QUERIES WITH ORDER BY CLAUSE IY17452 OUTPUT IS CUT OFF WHEN JAPANESE(HANKAKU/KANA) IS AT THE HEAD OF THE DATA. IY17461 ERROR IN SIZE OF RETURN VALUE FOR INOUT VARCHAR PARAMETERS IY17469 MANY DEFUNCT DB2 PROCESSES 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 IY17513 SQL3015N - INSTANCE CRASHES DURING IMPORT BECAUSE OPEN CURSORS ARE ENCOUNTERED DURING IMPORT REPLACE IY17516 SQL0311 WHEN CALLING SP FROM JAVA WITH CLOB PARAMETER IY17519 SQL3324 ON A CREATE NICKNAME AGAINST AN AS/400 WITH ZONED DECIMA L (NUMERIC) DATA TYPE IY17520 -973 ON PACKAGE CACHE. REMOVE 256MB PACKAGE CACHE OVERFLOW LIMIT IY17542 MEMORY CORRUPTION CAUSED BY DB2 WILL CAUSE APPLICATIONS TO COME DOWN WITH SIG #11, SQLODELETE, SQLOGMBLK, ETC. IY17548 DB2START HANGS ON 64BIT SOLARIS AFTER KERNAL PATCH 108528-05 IY17576 JAVA VISUAL EXPLAIN NUMERICAL LITERAL ERROR IY17588 DB2GOVD PROCESS HANGING. IY17621 SQL0510N CAUSED BY NOT REUSING SECTIONS CORRECTLY IN THE PKG IY17629 COST MISCALULATION CAUSING TABLESCAN TO BE CHOSEN VERSUS AN INDEX SCAN IY17633 CREATE NICKNAME FAILS WITH SQL902 ON EEE SERVER. IY17656 SQL SELECT STATEMENTS GIVES INCONSISTENT OUTPUT ON MULTIPLE RUNS IY17657 REORG TABLE INDEX RETURNS SQL2205 WHEN INDEX EXISTS IY17745 DQPSTART COMMAND HANG WHEN CHANGING DQPNODES.CFG FILE TO CONTAI N THE SWITCH NAMES RATHER THAN THE HOST NAME. IY17755 THIN CLIENT REQUIRES MSVCP50.DLL, BUT WE DO NOT SHIP THIS FILE IY17767 INVALID INPUT DURING ASCII TO PACKED DECIMAL CONVERSION CAUSES SEGV/CORE AND POSSIBLY STACK CORRUPTION (MOSTLY AT DIAGLEVEL 4) IY17775 PROBLEMS WITH THE CONTROL CENTER 'ESTIMATE SIZE' WINDOW WHEN USING THE 'RUN STATISTICS...' OPTION IY17784 ERROR IN CONVERTING STRING TO DECIMAL IY17816 THERE ARE PROBLEMS USING THE TEXT EXTENDER IN A DCE ENVIRONMENT IY17924 RESTART/CONNECT/CRASH RECOVERY FAILS WITH SQL1042C WITH INVALID LSN DUE TO A PROBLEM WHEN ABORTING A TRANSACTION IY18114 CUST CAN BACKUP THE DLFM_DB AUTOMATICALLY, BUT DATLINKS BACKUP A FILE INTO TSM, RESULTS IN A RC=-2551 IN 'DB2DIAG.LOG' IY18159 DB2DART REPORTS BPS HEADER PROBLEMS AFTER DATABASE RESTORE. IY18255 THE QUERY USED BY APPLY IS NOT EFFICIENT. PERFORMANCE. NO LONGER GENERATES U2000 DUMP ON SQLCODE IY18784 SQL0723 MESSAGE TOKENS INCORRECT IY18785 LOCALE BEHAVIOUR CHANGING ACROSS SOME CLI CALLS IY18786 STORED PROCEDURE BUILDER DOES NOT UPDATE SYSCAT.PROCEDURES IY18787 DB2 OPTIMIZER DOES NOT HANDLE 'OPTIMIZE FOR N ROWS' CORRECTLY BY FAVOURING PIPED PLANS. IY18788 DB2LOOK DOES NOT GENERATE THE DDL FOR THE CREATE USER TABLESPACE CORRECTLY. IT INSTEAD SKIPS THE USER KEYWORD IY18789 LOSS OF THE TABLE DUE TO THE IMPORT REPLACE IY18790 DB2IMIGR FAILS DURING MIGRATION FROM V5.2 TO V7.1. IY18791 DB2LDAP_BASEDN REGISTRY VARIABLE DOES NOT ACCEPT OU AND O. IY18792 SQL0901 IN SQLNO_SMP_FIX_COST DURING QUERY, INTERMITTENT IY18796 CORRECT BEHAVIOUR OF RESTORING/RLLFWDING A TABLESPACE FROM AN OFFLINE BACKUP INTO AN ONLINE DATABASE. IY18798 ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER PREPARE IY18800 DROP TABLESPACE MAY FAIL WITH SQL0290N IF THERE IS RI CONSTRAIN IY18801 DB2 UDB - DATABASE CRASHES WITH A SIGNAL 11 TRAP IN FUNCTION SQLRX_LIKE WHEN THE SET EVENT MONITOR STATEMENT IS EXECUTED. IY18806 DB2LOOK -L FAIL TO RETURN CONTAINER INFO WHEN RAN AS SYSCTRL ID. IY18807 POOR PERFORMANCE WHERE TWO PREDICATES ON COLUMNS IN THE SAME TABLE TEST FOR EQUALITY WITH IDENTICAL CONSTANTS IY20671 HOST SERVER (E.G. DB2/390) RETURNS SQL0805N DURING IMPORT DUE TOA PACKAGE NOT FOUND. IY21392 SIGNAL 11 IN SQLDADJUSTSEQDETPFAMOUNT JR14218 EVENT ANALYZER DOES NOT DISPLAY DYNAMIC SQL TEXT. JR14271 TRUNCATION OF SCRIPT EXECUTION RSULTS TAKES FIRST PORTION, INSTE AD OF THE LAST PART JR14514 CANNOT CREATE A KEYSET CURSOR IF THE KEY IS PART OF THE ORDER BY CLAUSE. JR14532 DB2SYNC APP SHOWS 100% COMPLETE BUT BAR IS AT 85% JR14610 WHEN TRYING TO ALTER A TRIGGER FROM WITHIN THE CONTROL CENTER THE TRIGGER STATEMENT IS GREYED AND CANNOT BE SELECTED FOR COPY. JR14783 RC 23 MISSING FROM DOCUMENTATION OF SQL30083 JR14807 DR. WATSON WHEN ISSUING DB2 FORCE APPLICATION ALL AGAINST DRDA-2 CONNECTIONS. JR15016 CC390 COMPONENT IN UDB 7.1 DOES NOT PICK UP THE SYSSCHEMA JR15026 NLX'S AND RCB'S INCORRECT IN FORMATTED DUMP, FOR R300 ONLY JR15035 THE EXPORT TO DATAGUIDE IS GENERATING A DR. WATSON ERROR. IT ALWAYS PRODUCES THE ERROR REGARDLESS OF OBJECT TYPE JR15146 UTILITY TO SET THE PROPER UID/PWD CREDENTIALS FOR SATELLITEID IN THE SATADMIN.AUT FILE USING ORIGINAL SATELLITEID AS INPUT JR15150 ADO/DB2-SEMAPHORE LEAK CAUSES HANDLE COUNT INCREASE. JR15228 TRAP IN SQLJIDRD WHEN SQL_DISCONNECT_ABNORMAL RETURNED JR15234 INSERTING 'DIRTY' TIMESTAMP INTO DATE COLUMN RESULTS IN NO DATA INSERTED, BUT SQL_SUCCESS_WITH_INFO RETURNED TO APP JR15243 EXPORT OF PROFILE VIA CCA FAILING WITH CCA3000 RC 1 JR15255 CALL TO STORED PROCEDURE USING IBM OLEDB DRIVER IBMDADB2 GIVES INCORRECT RESULTS JR15262 STATUS CHANGE TIME INCORRECTLY DISPLAYED IN CC JR15268 DB2ML.CONTENT(DOC, FILENAME) REMOVES THE LAST CHARACTER OF THE X DOCUMENT IN ERROR. JR15273 ADMIN SERVER WILL NOT CONFIGURE TCP/IP PORT ON INSTALL. JR15283 SPB'S 390 PROPERTIES TAB SHOWS THE APPLY BUTTON DISABLED JR15284 SIGNING ON IN SPB GIVES ERROR MESSAGE INDICATING BLANK PWD JR15290 ABEND IN DB2SYNCHSATTELITE* APIS IF CALLED WITHIN A .DLL JR15308 SELECT WITH DISTINCT CLAUSE RETURNS INCORRECT RESULT. DUPLICATE ROWS RETURNED. JR15310 SQLGETINFO(SQL_EXPRESSIONS_IN_ORDERBY) RETURNS 'Y' AGAINST MVS - SHOULD BE 'N' JR15311 SQLNUMRESULTCOLS CALLED PRIOR TO SQLEXECUTE IN PREPAREDSTATEMENT OBJECT. JR15319 SHOW RELATED FOR INDEXES NOT WORKING PROPERLY IN CONTROL CENTER JR15320 SPB IS MAINTAINING CONNECTION THAT ARE NO LONGER VALID JR15324 PROBLEMS WITH REPLICATING A JOIN VIEW IN DATA WAREHOUSE CENTER JR15334 FILE BROWSER PERFORMANCE WHEN ACCESSING SERVER VIA MODEM JR15346 SQL4914 WHEN USING DB2CAP WITH CAPTURE FILE WHICH CONTAINS FILTER CONDITION JR15352 SQLPRIMARYKEYS COULD RETURN NO KEYS IF SCHEMA IS NOT SPECIFIED AND USER LOGS IN WITH LOWERCASE USERID. JR15353 SQL1131N STATE 38503 WHEN DAD HAS MORE THAN 20 COLUMNS. 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 JR15368 DB2_71 ON OS/2, BACKUP RETURNS SQL1224 WITH EXCEPTION C0000005 JR15369 SQLTABLES RETURN NO_DATA_FOUND OR CLI0118E BECAUSE OF EXTRA DOUBLE QUOTES IN TABLETYPE SETTING IN DB2CLI.INI FILE. JR15371 OPTIMIZER WRONGLY ELIMINATES JOIN CAUSING INCORRECT RESULT JR15376 V7.1 CONTROL CENTER DOES NOT DISPLAY RESULTS WHEN TRYING TO 'SAMPLE CONTENTS' FROM A TABLE ON A PRE-V6 DATABASE JR15382 IBM OLE DB PROVIDER NOT GENERATING PROPER SQL IN NEW PROJECT. JR15390 MRI DW_REGISTRY_KEY IS TRANSLATED AND IT SHOULD NOT BE. JR15392 MISSING OS/390, MVS, VM/VSE IN ADD SYSTEM DIALOG FROM THE CC DB2 V.7, 5648D4804 JR15394 TRAP IN SQLRI_PASSTHRU_DESCRIBE WHEN DOING UNSUPPORTED EXPORT IN PASSTHRU MODE. JR15401 SQL5048 WHEN CREATING A REMOTE DATABASE FROM A V.7.1 CLIENT TO A V.6.1 SERVER JR15406 INSTALL.EXE RETURNS WRONG CODES (1C02), BECAUSE ONLY WAITS FOR THE LAUNCHP.EXE TO EXIT NOT THE OS2INST.EXE (MAIN INSTALL PROG.) JR15407 HOSTNAMES > 8 CHARS DISPLAY INCORRECTLY IN SQL GENERATED BY CC 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. JR15428 MEMORY LEAK IN SEQUENCE: BEGIN CONTEXT, CONNECT TO DATABASE, DISCONNECT FROM DATABASE, END CONTEXT. JR15435 NOT POSSIBLE TO NOT ENTER SIGN '-' (-1) FOR BP SIZE FROM THE CC JR15463 VW RETURNS WARNING WHEN ETI V4.0 PROGRAM RETURNS COMPLETION CODE JR15466 DATABASE COMES DOWN OR HANGS. TRAP FILE IS CREATED INDICATING EXCEPTION C0000005 IN FUNCTION SQLRR_DUMP_SECTION. JR15471 INSERTING NULL WITH OLEDB DOES NOT WORK JR15483 SPB ISSUES WRONG MESSAGE IF PRECISION AND SCALE ARE EQUAL FOR A DECIMAL COLUMN AND A ZERO IS PLACED TO THE LEFT OF DECIMAL POINT JR15490 CAN NOT MIGRATE 5.2 CONTROL DB INTO 7.1 DWC JR15491 SIX ESSBASE PROGRAM DOES NOT RUN DUE TO INCORRECT PASSWORD JR15498 DROP STORED PROCEDURE WITH SPECIFIC NAME >8 CHARACTERS FAILS IN V7 FIXPAK2. JR15505 NT CONTROL CENTER ALLOWS 20 CHAR MAX FOR CONTAINER PATH. JR15506 WHEN SQLDELI=QUOTE ON THE OS/390 DSNHDECM MACRO, CC390 STILL USES ' INSTEAD OF ' FOR THE DELIMITER. JR15510 OS/2 AND UPM INSTALLATION JR15517 SQLUVINT() API STRUCTURE DB2_INFO FIELDS, VERSION RELEASE LEVEL AND OBJ_LIST FIELDS ERRONEOUSLY SET NULL JR15528 'BAD' RANGE OF SORTHEAP SIZE(>1014 AND < 1038) IN THE OPTIMIZER JR15537 CODEPAGE 65535 PROBLEM PASSED BY MVS TO CLI (PADDING OCCURS IN OUTPUT) - NEEDS TO BE RECOGNIZED AS A VALID 4 BIT DATA CODEPAGE JR15549 SQLJ.EXE NO LONGER WORKS WITH WILDCARD (*.SQLJ) JR15583 CAN'T CREATE IDENTITY COLUMNS IN SP WITH V7 FP2 JR15584 DB2HISTORY* APIS MAY TRAP IF UNINITIALIZED DATA PASSED IN. JR15586 SQL2650 WHEN TRYING TO TAKE ONLINE BACKUP. AFTER APPLYING FIX FOR IY15913, GET ERRORS IN SQLPALR_READPAGESDISK PROBE 158 JR15589 'STATUS CHANGE TIME' WHEN ISSUING 'GET SNAPSHOT..LOCKS' DOES NOT REVEAL INFORMATION JR15591 JAVA UDF RETURNS NULL VALUE INSTEAD OF ACTUAL VALUE JR15597 FAILUER TO CREATE A NEW LOGFILE CAUSES DB2 TO PANIC INSTEAD OF D UMPING 'LOGSPACE FULL' MESSAGE. JR15598 CLI0100 UPDATING NULL DATE COLUMN USING OLEDB PROVIDER JR15599 CALLING SP WITH INOUT DECIMAL ON AN MVS SYSTEM CAUSES SQL0304 JR15602 DESCRIBED COLUMN NAMES ARE INCORRECT AFTER SWITCHING CURSOR TYPE IN JAVA OR CLI APPLICATION. JR15603 CCA IS PUTTING THE KEYWORD 'MULTICONNECT' KEYWORD UNDER THE DSN ENTRY OF THE DB2CLI.INI FILES - SHOULD GO UNDER COMMON SECTION. JR15604 TRAP IN SQLOREMOVEEDUEXITLIST SEEN ON OS/2 BACKFIT TO V7.1 JR15610 SQL ROUTINES MAY INCORRECTLY COPY HOST VARIABLES FOR CHAR OUTPUT PARAMETERS BY SETTING FIRST BYTE TO 0 JR15618 OS2 V7 GATEWAY TRAP IN SQLCCIPCAGENTEXITLIST - DB2DIAG.LOG ALSO REPORTS SQLE_DB2RA_AS_DRIVER PROBE:57 B186 FFFF JR15622 THE ADM. CLIENT INSTALLATION THROUGH THE NORMAL GUI INSTALL, SHOWS A WRONG STIMATION OF THE SPACE REQUIRED. JR15625 EXTRA SPACE IS INSERTED TO DATA WHEN CHARACTER IS THE SAME AS TERMINATION CHARACTER DEFINED IN COMMAND CENTER. JR15628 PASSWORDS ARE LOST/CORRUPTED WITHIN DWC JR15631 DB2 CONNECT SHOULD NOT ATTEMPT TO CONVERT GRAPHIC COLUMNS FROM DOUBLE-BYTE CODEPAGE TO SINGLE-BYTE CODEPAGE. SHOULD ERROR. JR15635 DB2 FOR OS/390 CANNOT MAKE TYPE 2 CONNECTION TO UDB WHEN SPM ENABLED JR15636 INSTALL OF PRODUCT FAILS BECAUSE OF TCPIP SERVICES FILE JR15640 THE CONTROL CENTER FAILS WITH ERROR SQL0104N WHEN ATTEMPTING TO DISPLAY INDEX NAMES USING THE TURKISH LOCALE JR15643 EXPORT PROBLEM WITH IXF FILETYPE JR15646 NAME COLLISION IN THE DB2 DIRECTORY AND DCS DIRECTORY JR15649 SIG 11 IN SQLOXULT THROUGH SQLRA_CACHE_SPACE_MGMT JR15653 SIGNAL 11 IN SQLOFMBLKEX DURING LOAD. (<- SQLUTERMLOADEDU <- SQLUTERMRIDDER) JR15654 'GET SNAPSHOT FOR APPLICATIONS ON ' HANGS AT THE SAME PL ACE EVERY TIME THE COMMAND IS ISSUED. JR15656 SOME STEPS WITH A USER DEFINED PROGRAM FAIL TO MIGRATE JR15661 TRAP IN BSORTGETNEXTPARTIALKEY ON NT JR15666 COMMAND CENTER IS NOT LOGGING THE RESULTS OF A QUERY WITH THE 'PIPE OUTPUT TO FILE' OPTION JR15678 SQLDESCRIBEPARAM CALL TO HOST RETURNING SQL0236 JR15686 DUPLICATE ENTRIES IN SCRIPT CENTER JR15688 THE JVM CRASHES WHEN MAKING A QUERY ON A DATABASE USING JDBC. JR15700 DR WATSON ERROR DURING SNAPSHOT SCRIPT EXECUTION SQLJNOPREFETCH-OFFSET:110 IN SQLJMS10.C JR15702 OS/2: SQL1092 IS RETURNED INSTEAD OF SQL1093 DURING DB2START WIT HOUT THE USER BEING LOGGED ON. JR15706 TRAP IN SQLCSPC_COOR_REG. JR15707 ACCESS VIOLATION IN DB2APP.DLL WITH REXX STORED PROCS ON OS/2 FO R V7.1 OF DB2. JR15708 ERROR DBA2003 INVALID DATE WHEN USING THE CONTROL CENTER TO SCHEDULE A JOB AND THE REGIONAL SETTING IS SLOVENIA JR15710 LOAD FROM CONTROL CENTER PRODUCES INVALID NULL INDICATOR CLAUSE JR15711 ALTER COLUMN WITH CONSTRAINT ADDITIONCLAUSE SHUTS DOWN ENGINE JR15715 IMPORT FROM CCA FAILS TO UPDATE NODES ON WIN2000 JR15719 SYS3175 OCCURS WHEN DB2START IS ISSUED BY A USERID THAT DOES NOT HAVE THE PROPER AUTHORITY JR15723 DXXCOMPOSEXML: ERRCODE:-85, ERRMSG:INVALID DOCUMENT STRUCTURE DXXCOMPOSEXML: ERROR CODE: -85, ERROR MSG:INVALID DOCUMENT STRUC JR15726 V7 CC/NT SAMPLE TABLE ON V6 SERVER CAUSED MEMORY LEAK ON NT: ADD TIONAL REQUEST CAUSED DR. WATSON ERROR OR RUN OUT OF MEMORY. JR15733 SORT ROUTINE CALED TWICE: ONCE DIRECTLY AND ONCE INDIRECTLY SO P PERFORMANCE IS DEGRADED. JR15735 RETURNING LARGE RESULT SET FROM THE V7.1 GUIS (CONTROL CENTER OR COMMAND CENTER) TAKES TOO LONG JR15736 DB2ADVISE MISREPORTING JR15737 PATCH2=29 CAUSES PROBLEM WITH CONVERSION IN A 0 PRECISION DECIMAL TO DOUBLE CONVERSION. JR15739 THREAD CRASHES IN 'COPY TABLE' DIALOG BOX, RENDERING IT USELESS JR15745 MTS/COM+ APPLICATION GETTING SQLCODE -913 WHEN EXECUTING, DUE TO MULTIPLE CONNECTIONS BEING USED BY MTS FOR THE SAME TRANSACTION JR15753 AN EXIT CASE IN SQLDESCRIBE CAUSES THE DATA TO BOUND AS BINARY AND HENCE SHOWING UP AS HEX IN OUTPUT JR15755 ADO PARAMETIZED QUERY SELECTS A LOB AND HAS INPUT PARAMETERS CAUSES DR.WATSON ON DB2 CONNECT. JR15760 THE RESULT SET BECOMES NULL WHEN COLUMN CONTAINS NULL VALUES IN ANY OF THE ROWS. THIS HAPPENS ONLY WHEN IT IS DONE FROM CLI. JR15762 CALLING STORED PROC ON OS/390 V6 FROM DB2 V7 FP2 ON NT RESULTS IN DB21100E. JR15763 INCORRECT CLIENT/SERVER SEARCHING WHEN TRYING TO IMPORT/EXPORTA FILE. JR15765 VISUAL BASIC ADD-IN FOR SPB FAILS ON NON-ENGLISH VB. JR15766 OPTIMIZED QUERY RETURNS INCORRECT RESULTS JR15790 PROBLEM WITH USING NOT DETERMINISTIC OPTION IN UDF JR15796 INSERTING A NULL VALUE INTO A BLOB COLUMN, WE GET THE SQL0301N JR15799 PROBLEM WITH FOREIGN KEYS AND SET NULL CONSTRAINTS JR15837 AMBIGUOUS REFERENCE COLUMN (SQL0203) WHEN QUERYING MVS LEADS TO DR. WATSON TRAP JR15881 LIST RECOVERY HISTORY FAILS FROM COMMAND CENTER OR JOURNAL JR15884 SNAPSHOT FOR SECONDARY LOGS ALLOCATED AND SECONDARY LOG SPACE DO NOT CORRESPOND JR15885 MTS APPLICATION FAILS TO RECONNECT AFTER RECYCLING DB2 JR16093 SP FAILS WHEN MORE THAN 27 CURSORS, RET. DATA > 1 BUFFER PQ46790 -805 CAUSED BY CURRENT PACKAGE SET IS NOT RESET SA91823 VWPLOADI - DOES NOT WORK WITH DBCS. APAR fixes included in WR21241 (Fixpak 2a) APAR No. Abstract -------- -------------------------------------------------- IY16409 TRAP IN SQLMORERESULTS() IY16637 SQL30090N WHEN DIST TRAN APP CONNECTS TO A REMOTE DB JR15530 DATA INSERTED INTO LONG VARCHAR USING 'FOR BIT' COLUMN NO LONGER WORKING AT FP 2. APAR fixes included in WR21245 (Fixpak 2) APAR No. Abstract -------- -------------------------------------------------- GG04123 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED GG04124 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED 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 GG04138 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS GG04139 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS GG04144 DIAGNOSTIC ENHANCEMENTS FOR APPLY GG04145 DIAGNOSTIC ENHANCEMENTS FOR APPLY GG04164 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. GG04165 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. GG04166 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) GG04167 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) GG04168 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ GG04169 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ GG04170 CANNOT STOP CAPTURE WITH ASNCMD STOP COMMAND. GG04171 DURING CAPTURE PROCESSING THE ASNPATH SYSTEM VARIABLE IS BEING MISREAD GG04172 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. GG04173 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. GG04174 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY GG04175 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IC27213 WRONG TIMESTAMP ON SNAPSHOT OUTPUT FOR DB2 EE 6.1 UNDER LINUX IY03296 SQL2154 ON ATTEMPTED TABLESPACE RESTORE. 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 IY09174 MIGRATION FAILS DUE TO DISK FULL IY09385 SQL1042 DURING CRASH RECOVERY DUE TO INDEX MANAGER PROGRAMMING ERROR (DIA3875C). IY09469 SELECTING TABLES FROM OS/390 WHICH CONTAIN LOBS CAUSES SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT. IY09705 DB2 FORCE APPLICATIONS HANGS ON A NON-COORDINATOR NODE IY09961 QUERY REWRITE DOESN'T PUSH DOWN PREDICATE INTO COMMON SUBESPRESS ION IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY10950 UNDERSCORES IN TABLE ALIAS CAUSE MS JET ENGINE ERROR WHEN LINKIN G TABLES. IY11074 SQL0101 ERROR WHEN RUNNING A QUERY DUE TO MEMORY FRAGMENTATION PROBLEM AND LOW 'ULIMIT -D' VALUE. IY11081 DATABASE GETS MARKED AS BAD AFTER FCM ERRORS FFFFFC7F IN DB2DIAG.LOG FILE. EVENT MONITOR RESOURCE COULD NOT BE OBTAINED. IY11136 NO TEMP AVAILABLE ERROR IN DB2DIAG.LOG DURING ON-LINE BACKUP. SQLB_BACKUP_IN_PROGRESS ON TEMPTABLESPACE FOR A SHORT PERIOD. IY11353 SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM IY11377 DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC. 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. IY11499 DB2 UDB - CRASH RECOVERY FAILS WITH AN SQL1042 ERROR. MESSAGES IN THE DB2DIAG.LOG WE FAILED WHEN TRYING TO DROP A BUFFERPOOL. IY11527 DB2 UDB - SQL0901 ERROR WITH MESSAGE 'NON-PIPED PARALLEL SORT ATTEMPTED' IN DB2DIAG.LOG. IY11600 RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION. IY11648 MISLEADING ERROR MESSAGE IN DB2DIAG.LOG FOR QUIESCE RESET FOR A TABLE FROM A NODE WHERE THE TABLE WAS NOT DEFINED. IY11737 QUERY PATROLLER (DQPSETUP) IS RETURNING SQL1005 WITH JA_JP CODEP AGE, BUT DBI1366E WITH EN_US CODEPAGE. 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 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. IY11865 SQL0902N ON STARTING PIPE EVENT MONITOR IY11882 AUTOLOADER USES DB2ATLD_PWFILE WHEN AUTHENTICATION IS NOT SET IY11901 TRAP IN SQLNO_PROJECT_QUN WHEN RUNNING A QUERY IY11908 DB2 calls user exit with the wrong gid IY11932 QUERY PATROLLER DOES NOT WORK PROPERLY WHEN LANGUAGE WAS SELECTE D LANG=US_ENG. 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)' IY12035 SIGNAL 11 TRAP IN SQLRI_RESTORE_SPEC_REG_INFO() IY12042 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED IY12050 SQL2741N WHEN LOADING DATA AND SPECIFYING IMPLIEDDECIMAL AND PACKEDDECIMAL MODIFIERS 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 IY12125 OWNER OPTION ON BIND MAY CAUSE INCORRECT AUTHS TO BE USED IY12165 CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N IN FP4E. IY12168 INSTANCE MIGRATION FAILS FROM V5.X TO V6.1 IY12177 INDEX ON GENERATED COLUMN NOT TAKEN BY OPTIMIZER DURING INSERT,D ELETE OR UPDATE. IY12271 DB2CKMIG.BND COULD NOT BE OPEND AT DB2CKMIG COMMAND IY12273 LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN CANCELLED IY12275 CLI CONVERSION FROM CHARACTER TO NUMERIC TYPES MAY CAUSE SIGSEGV IF INVALID CHARS USED IY12295 SIGNAL 11 TRAPS IN MEMORY OPERATIONS (MEMHOLDSEG AND SQLOFMBLK) COMING FROM SQLNO_CLOSE_POOL IY12299 DB2ADUTL TO RECOGNIZE ALL TYPES OF FS_TYPE AT QUERY FOR BACKUP I MAGES IY12396 POSSTR DOES NOT WORK WITH GROUP BY (SQL0119) IY12416 -901 DUE TO INCORRECTLY SORTED INPUT STREAM OR INCORRECT ORDER BY QUERY RESULTS, MISORDERED KEYS IN INDEX LEAD TO DB MARKED BAD IY12419 BACKUP OF DATABASE CONTAINING DATALINK COLUMNS FAILS WITH SQL2424N, YET COPY DAEMON SUCCESSFULLY BACKED UP FILES. IY12437 CALLING QUALIFIED STORED PROCEDURES FROM CLP RESULTS IN CLI0150 DRIVER NOT CAPABLE ERROR IY12449 V7.1 ADD CHECK CONSTRAINT PROBLEM FROM CONTROL CENTER 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. 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 IY12609 DB2 UDB - SQL1042 ERROR WHEN MAXAGENTS LIMIT HAS BEEN REACHED AND DB2 REQUIRES AN ADDITIONAL AGENT. IY12642 LOAD DOES NOT CHECK PARTITIONING KEY FOR EXCEPTION TABLE IY12679 DB2IUPDT -W 64 (MIGRATION OF 32BIT INSTANCE TO 64 BIT) FAILS WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE. IY12725 DB2 UDB - CREATE INDEX CAUSING DATABASE TO COME DOWN. THE DB2DIAG.LOG FILE INDICATES THAT AN OBJECT ID IS ALREADY IN USE. IY12726 DROPPING AN UNAVAILABLE TABLE ENDS WITH DIA3806C UNEXPECTED END OF FILE 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 INSTANCE OWNER. IY12821 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS 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 IY13010 WHILE TAKING SNAPSHOTS COUNTERS LIKE 'TOTAL BUFFER POOL READ TIME (MS) ' ARE NOT CORRECT. IY13012 THE CUSTOMER UPGRADED TO FP4D FROM FP4 TO ADDRESS APAR IY09469. NOW THE CUSTOMER IS EXPERIENCING CLI0120E. IY13014 SIGNAL #4 #11 USING HOP DRIVER IY13053 HOST STORED PROCEDURE CALL WITH PARAMETERS RESULT IN DB21103W IY13054 MISLEADING ERROR REPORTING ( -901) FOR WRONG SCRIPT TRYING TO LINK UDF. IY13098 SQL0970N WHEN TRYING TO DROP AN SQL PROCEDURE IY13107 DB2 UDB - INDEX CORRUPTION PROBLEM CAUSES MISORDERING OF KEYS IY13114 ENCINA SERVER AND DB2 V7 INTEROPERABILITY. ADDED XA_PREPARE INSIDE ANOTHER TRANSACTION. IY13118 RUNSTATS ON AN EXTENDED INDEX LEADS TO AN INFINITE LOOP IY13171 DATABASE MIGRATION FROM V5 TO V6 FAILS WITH SQL0025W IY13202 MEMORY OVERWRITE CAUSES A TRAP IN SQLIPREDNOTSAT DURING LOCK ESCALATION IY13226 AT QUERYPATROLLER STOP TIME, WE TRY TO DELETE A MESSAGE QUEUE TH AT WAS ALREADY DELETED. IY13252 DB2DCLGN COMMAND WITH A DECIMAL RESULT IN INCORRECT OUTPUT. IY13307 SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON UDB V.7.1 IY13312 QUERY OPTIMIZATION. BAD NESTED LOOP JOIN PLAN IS CHOSEN AFTER MIGRATING TO V7. IO IS SIGNIFICANTLY UNDER-COSTED. 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 IY13331 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START IY13343 IMPORT IN CCA ON A CAE IS CATALOGING DIRECTLY TO A MAINFRAME INSTEAD OF THROUGH A GATEWAY. IY13410 IMPROPER HANDLING OF LOGS WITH RAW DEVICE AS ACTIVE LOG PATH. GET SQL4970N WHEN ISSUING A ROLL FORWARD. IY13466 SQL0198N - DESCRIBING STORED PROCEDURES WITH LONG NAMES IY13473 BAD ACCESS PLAN CAN OCCUR IN EEE WITH DISTRIBUTION STATS IY13596 IN V7.1 CC, ON-LINE BACKUP OPTION FOR EEE IS GREYED OUT. IY13598 SQL1627W WHEN RUN DB2 GET MONITOR SWITCHES AFTER UPDATING THEM FROM A 7.1 CLIENT. IY13617 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS IY13696 SQL1273N ON ROLLFORWARD DATABASE (MISSING LOG FILE S0000000.LOG) IY13705 TRAPS (SIG #11) IN SQLM_GENERIC_CONVERT 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 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. IY13774 LOAD FAILURE (BUILD PHASE) MIGHT CAUSE SMP CORRUPTION IY13799 PACKAGE CACHE ENTRY FOR SELECT DOES NOT INDICATE THAT DEFAULT QUALIFIER (SCHEMA) HAS BEEN CHANGED IY13802 CONTROL CENTER DOES NOT ALLOW DEFINING A REPLICATION SUBSCRIPTION ON A VIEW REPLICATION SOURCE. IY13807 DLFMUPDT FAILED WITH DBI1282. BACKUP_INSTINFO() IN DB2IUTIL DOES N'T CONSIDER TO BACKUP DBM CFG FOR DLFMUPDT COMMAND. IY13808 SIGNAL 11 TRAP IN SQLRR_DUMP_SECTION() DURING ERROR PROCESSING 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 IY13891 QUERY PERFORMANCE DEGRADATION V6.1 IY13893 ADD SUPPORT FOR THE COLUMN NAME UNDER MINMEM MODE FOR JDBC IY13906 COMMENT IN DB2CLI.INI PREVENTS DATASOURCE FROM WORKING PROPERLY IN DB2 V7.1 IY13927 PROBLEMS MIGRATION OLD PL1 APPLICATIONS TO UDB V7.1 HAVING TO DO WITH THE CONNECTION INTERFACES IY13951 MINMEMUSAGE KEYWORD CAUSES INCORRECT SQL_DBMS_NAME OUTPUT IN SQLGETINFO() IY13959 SQL0270N RC=40 DURING RESIZE/EXTEND OF CONTAINERS V7.1 FP1 IY13968 BAAN APPLICATION MAY EXPERIENCE -302 IY13970 CCA TRUNCATES HOSTNAME TO FIRST PART OF FOUR PART NAME IY13979 -805, -818 SQLCODE RECEIVED FROM MULTITHREADED SQLJ APP IN A UNIX ENVIRONMENT. IY13992 ASNDLCOPY - INCORRECT MISLEADING MESSAGES WHEN DIR FILE CONTAINS DIRECTORY THAT DOES NOT EXIST IY13995 SQLFETCH() FAILS WITH -501 ERROR WHEN MINMEMUSAGE=1 IY13996 SYSIBM.SYSVIEWS IS NOT MIGRATED PROPERLY FROM DB2 V5.2 TO DB2 V7 1 WHEN THERE ARE VIEWS THAT HAD MORE THEN 1 SEQNO IN THE TABLE. IY14035 FEDERATED CREATE SERVER COMMAND TRAPS EEE INSTANCES IY14038 DB2 UDB - IN CERTAIN SCENARIOS IF AN AGENT FAILS WITH ANSQL1040 (MAXAPPLS REACHED) ERROR, THE DATABASE WILL CRASH WITH SQL1042. IY14081 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS IY14082 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS IY14089 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED 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 IY14121 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS IY14123 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS IY14125 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS IY14126 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS IY14155 DIAGNOSTIC ENHANCEMENTS FOR APPLY IY14156 DIAGNOSTIC ENHANCEMENTS FOR APPLY IY14158 DIAGNOSTIC ENHANCEMENTS FOR APPLY IY14159 DIAGNOSITC ENHANCEMENTS FOR APPLY IY14242 CLI API SQLCOLUMNS FAILS WITH SQL0198N ERROR WHEN ISSUED AGAINST A NEW DATABASE BEFORE BINDING THE CLI BIND FILES. IY14253 MISSING PAGE IO DURING DB ROLLFORWARD (CORRUPTED LOGS) 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 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 IY14396 DRDA DUMP PRODUCED WHEN USING SPUFI ON OS/390 TO ACCESS A FEDERA TED VIEW OF A NICKNAME IN UDB V.7.1 IY14406 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. IY14407 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. IY14408 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. IY14409 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATE WITH NO CHANGES. IY14410 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) IY14411 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) IY14412 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) IY14413 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) IY14414 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ IY14415 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ IY14416 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ IY14417 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ IY14418 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. IY14419 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. IY14420 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. IY14421 CAPTURE DOES NOT HANDLE LARGE TABLE ID IY14422 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY14423 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY14424 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY14425 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY14500 DLFM GOES DOWN FROM LOCK TMEOUT WITHIN GARBAGE COLLECTOR DAEMON 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. IY14769 SOLARIS: DEADLATCH AT V7.1 FP1 CAUSES HANG IY14770 SIGNAL 11 IN SQLVDIVIDE IY14775 CREATE TABLE LOOPS AND USES ALL OF THE LOG SPACE IY14777 PREPAREDSTATEMENT.SETLONG() CALL FAILS TO DB2/390 IY14849 SQL0901N SYSTEM ERROR WITH REASON: UNRESOLVED QNC IY14894 TURNING ON THE SPECIAL FEATURE USE_LIGHT_OUTPUT_SQLDA CAUSES THE CLIENT TO HANG. IY14901 SQLFREECONNECT/SQLFREEHANDLE RELEASES THE CONNECTION LATCH IY14979 QUERY PATROLLER LIMITATION: 18 CHARACTERS FOR COLUMN NAME LENGTH IY14989 INSTANCE CRASH ON ROLLFORWARD: SIGNAL 11 IN SQLPRFWD__FP7SQLEACB8SQLP_LSNUL IY15036 GLOBAL TEMP TABLE CAUSING A TRAP WITH SIG 11 IY15049 INSERT HANGS IN SQLPGPST IY15118 DB2 UTILITIES FAIL WHEN DYN_QUERY_MGMT IS TURNED ON IY15135 KEY NOT FOUND ERROR (FFFF F92C) ON AN INDEX IN A 32K PAGE TBSP IY15192 ADD FUNCTIONALITY TO OBTAIN A MINIMUM SCALE OF 6 FOR DIVISION. IY15250 AIX ONLY: DB2MEMDISCLAIM CAN CAUSE SORTHEAP ALLOCATION ERRORS, TRAPS, DEFUNCT DB2AGENTS DUE TO LEAKING VIRTUAL MEMORY. IY15289 WRONG OR DIFFERENT RESULTS RETURNED BY SELECT ON VIEWS V7.1 ONLY IY15369 QUERY RUN AT OPT LEVEL 0 RETURNED WRONG RESULTS. IY15397 CREATE PROCEDURE CALL FROM NON-CATALOGUED NODE TRAPS. IY15469 BAD OPTIMIZER PLAN LEADS TO INCORRECT RESULTS IN EEE FOR AST IY15629 INCORRECT FILE SIZE ESTIMATES FOR BACKUP TO ADSM/TSM JR14166 NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1 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 JR14647 JAVA CC DOES NOT ALLOW NUM_POOLAGENTS TO BE SET TO 0. JR14743 DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM. JR14749 SQL0291 TRYING TO ACCESS TEMPORARY TABLESPACE WHEN THERE ARE TEMP TABLEPSACES OF DIFFERENT PAGESIZES:'NO TEMP AVAILABLE' JR14758 WITH SPECIFIC SETTINGS EVERY COMMAND ISSUED FROM COMMAND CENTER ON NT/UDB EE V5.2/FIXPACK 12 RECEIVES DB21005E ERROR. JR14777 QUERY TRAPS SERVER. TRAPPING FUNCTION IS SQLKT_PACK_TUPLE. 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. JR14795 DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442 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. JR14841 AN SQL0525N ERROR OCCURS WHEN DB2BATCH IS EXECUTED AGAINST AN OS 390 DATABASE. JR14844 USERS WHICH BELONG TO THE SYSADM_GROUP DEFINED IN THE DBM CFG CA NNOT ISSUE A DB2STOP, WHETHER DOMAIN OR LOCAL USERS 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 JR14860 JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN JR14867 MF AND IBM STORED PROCEDURES WON'T PRECOMPILE. NEED TO PUT A VERSION CHECKING FOR CALL STATEMENTS. JR14876 08/00 duplicate object error occurs while importing to DWC 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. JR14926 TRAP IN SQLJIFSR.C 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 JR14932 -502 AFTER USING SQL_CLOSEOPEN CLI ATTRIBUTE JR14933 Support ETI DA version (4.x) JR14990 OUTPUT PARAMETERS NOT INITIALIZED TO NULL JR14996 CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E JR15008 SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR JR15025 DR.WATSON IN DB2SYS.DLL WHEN LOGING OFF NT (MTS AND DTC) JR15036 COMMAND CENTRE LOGON DIALOG FAILS TO GO ON THE TOP 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 JR15046 RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC 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. JR15084 SIGNAL #11 IN SQLNQ_MEMMGR::DESTROY. THIS APAR WILL FORCE A -901 TRACEBACK TO GATHER MORE INFO ON NEXT OCCURRANCE. JR15085 WHENEVER THE CUSTOMER GOES TO GET THE SOURCE STORED PROCEDURE CODE IN THE STORED PROCEDURE BUILDER HE GETS SQL0514. JR15138 DR.WATSON IN DB2CLI.DLL WITH JDBC APP CALLING STORED PROCEDURES JR15141 V7.1 CC'S RUNSTATS WINDOW CAN'T BE CLOSED WITH 'CANCEL' BUTTON. JR15145 APAR fix - import errors 3303 and 3807 on validate_relationshi JR15158 DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE JR15159 EXCEPT ALL IN SQL STATEMENT RETURNS SQL0415 WITH SQLSTATE 42825. AND/OR INCORRECT RESULTS DURING SQL EXECUTION. JR15200 USE OF {?=CALL SPNAME(?)} SYNTAX MAY RESULT IN CLI0102 INVALID CONVERSION ERRORS JR15202 RESTORE/MIGRATION (SQL2517W) CONTROL CENTER -> JOURNAL STATUS IS 'FAILED' JR15206 KEYSET PARSER RETURN CODE=1002 CAUSES HEAP CONSUMPTION JR15212 CONNECTION.GETCATALOG() RETURNS AN EMPTY STRING INSTEAD OF NULL JR15213 SQLMORERESULTS() DOES NOT HANDLE ERRORS FROM BATCHED COMMANDS JR15214 EXECUTEBATCH() SHOULD RETURN INT́0• 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 JR15220 SQLPUTDATA() MAY RESULT IN SQL0157N UNDER HIGH CONCURRENCY 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 JR15256 THIN CLIENT INSTALL DOES NOT UPGRADE THE V.1.X WINSOCK TO V.2.0 ON WINDOWS 95 JR15263 SQL COMMENT LINES (STARTING WITH --) IN THE COMMAND CENTER - INTERACTIVE PANEL ARE NOT HANDLED CORRECTLY JR15287 NT/7.1FP1 - WR21198 : 'CPYSETUP.BAT...' -> 'THE SYSTEM CANNOT FIND THE FILE SPECIFIED.' -> COPY NOT USABLE -> CANNOT UPGRADE JR15318 TRAP DURING COMPARE DATE STRING AND AN EMPTY VARCHAR STRING JR15330 SQL 107 RECEIVED WHEN CALLING STORED PROCEDURES ON A HOST SYSTEM THROUGH A V7.1 GATEWAY JR15425 LOAD WITH MODIFIED BY USEDEFAULTS CLAUSE CAUSES NULL FIELDS TO BE INCORRECTLY POPULATED WITH DATA. APAR fixes included in WR21197f (Fixpak 1f) APAR No. Abstract -------- -------------------------------------------------- IY12165 CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N IN FP4E. IY13307 SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON UDB V.7.1 IY13312 QUERY OPTIMIZATION. BAD NESTED LOOP JOIN PLAN IS CHOSEN AFTER MIGRATING TO V7. IO IS SIGNIFICANTLY UNDER-COSTED. IY13565 DB2DIAG.LOG: DIA9999E ERROR CODE 2, SQLRA_LOAD_DYN_STMT - CAN OCCUR ON SNAPSHOT BUT IS INFORMATIONAL ONLY - NO EFFECT TO USER 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 JR15158 DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE APAR fixes included in WR21197e (Fixpak 1e) APAR No. Abstract -------- -------------------------------------------------- IY12177 INDEX ON GENERATED COLUMN NOT TAKEN BY OPTIMIZER DURING INSERT,D ELETE OR UPDATE. IY13098 SQL0970N WHEN TRYING TO DROP AN SQL PROCEDURE IY13307 SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON UDB V.7.1 JR14795 DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442 JR15046 RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC JR15081 CLI COMMIT BETWEEN PREPARE AND DESCRIBE MAY CAUSE CLI0125E FUNCTION SEQUENCE ERROR APAR fixes included in WR21197d (Fixpak 1d) APAR No. Abstract -------- -------------------------------------------------- IY11353 SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM IY12968 JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW IY13226 AT QUERYPATROLLER STOP TIME, WE TRY TO DELETE A MESSAGE QUEUE TH AT WAS ALREADY DELETED. JR14815 DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED. JR14929 TABLE UDFS WITH DECIMAL PARAMETERS SHOW LENGTH AND SCALE OF 0 IN SYSCAT.FUNCPARMS JR15008 SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR APAR fixes included in WR21197c (Fixpak 1c) APAR No. Abstract -------- -------------------------------------------------- IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY12751 STMT.GETSTRING() RETURNING NULL ON IN_OUT PARAMETER IY12946 CLI ATTEMPTS TO CLOSE A CURSOR THORUGH THE CURSOR CONTROL BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP. IY13118 RUNSTATS ON AN EXTENDED INDEX LEADS TO AN INFINITE LOOP JR14166 NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1 JR14809 NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER. JR14996 CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E APAR fixes included in WR21197b (Fixpak 1b) APAR No. Abstract -------- -------------------------------------------------- IY06938 IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6 IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY11436 DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY PROCESSING. IY11908 USER EXITS RUN WITH WRONG RGID ON UNIX. IY11945 APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE ALLOCATED TO PROCESS. IY12273 LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN CANCELLED IY12679 DB2IUPDT -W 64 (MIGRATION OF 32BIT INSTANCE TO 64 BIT) FAILS WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE. JR14867 MF AND IBM STORED PROCEDURES WON'T PRECOMPILE. NEED TO PUT A VERSION CHECKING FOR CALL STATEMENTS. 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 WR21197a (Fixpak 1a) APAR No. Abstract -------- -------------------------------------------------- IY11353 SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM IY11377 DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC. IY11600 RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION. IY11819 SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER. IY11990 ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC. IY12416 -901 DUE TO INCORRECTLY SORTED INPUT STREAM OR INCORRECT ORDER BY QUERY RESULTS, MISORDERED KEYS IN INDEX LEAD TO DB MARKED BAD JR14743 DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM. 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 JR14876 DUPLICATE OBJECT ERROR OCCURS WHILE IMPORTING TO DWC APAR fixes included in WR21197 (Fixpak 1) APAR No. Abstract -------- -------------------------------------------------- IY06572 SEGMENTATION FAULT WHEN BINDING A SECOND TIME TO A CURSOR IY06740 DB SIZE ESTIMATE CALCULATED INCORRECTLY FOR BACKUP TO ADSM. HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE. IY07623 SIGNAL #11 TRAP IN SQLORQUE2() IY08453 SQL1227 RC 6 WHEN ATTEMPTING TO UPDATE STATISTICS WITH TABLE CARDINALITY OF 0 WHEN STATISTICS ALREADY EXIST IY08684 SQL0107 RETURNED BY CLI DRIVER ON SQLFETCH CALL TO DB2 MVS. IY09151 LOAD REPLACE OF AN EMPTY FILE (IXF) DOES NOT REPLACE EXISTING ROWS IN THE TABLE THE EMPTY FILE IS BEING LOADED INTO. IY09262 CHANGE THE DEFAULT SQL_CONCURRENCY AS READ_ONLY BASED ON THE CLAUSES PRESENT IN THE STATEMENT. IY09663 DB2 CRASHED WITH ERROR DIA3816C CREATED BY SQM_EVMON_OSTREAM() SIG 11 IY09756 NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS. REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED. IY09764 TWO QUERIES DIFFERING ONLY IN THE ORDER OF THE PREDICATES, RETURN DIFFERENT RESULTS. IY09948 JAVA STORED PROCEDURES NOT FOUND OUTSIDE SQLLIB\FUNCTION IY09966 JAVA.SQL.TIMESTAMP RECEIVING INVALID ARGUMENT(NANOS>999999999 OR <0) WHEN MULTIPLE THREADS MAKES THE CALL. IY10004 DB2JD TERIMINATES WITH EXCEPTION, WHEN USING HISTORY OPTION OF CONTROL CENTER FROM WINDOWS 95. IY10029 QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204 IY10034 May13: Install V6.1 FP/EEE/NT may add incorrect EE DB2 Services IY10047 DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI IY10180 COMPOUND SQL APPLICATION CORE DUMPS WITH GREATER THAN 60 SQL STATEMENTS. IY10183 TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4. IY10199 LEFT OR FULL OUTER JOIN PROBLEM WITH OPTIMIZER IY10280 RANDOM CLI0606E/CLI0611E ERRORS FROM A MULTI-THREADED JDBC APP WHEN ALL THE THREADS USE A SINGLE CONNECTION. IY10302 PCBVALUE INCORRECTLY POPULATED ON SQLGETDATA FOR WCHAR WITH CBMAXVALUE=2 ON UNIX. IY10390 TERMINATING ADSM SESSION BEFRO RE-ESTABLISHING IT. IY10430 BACKUP IMAGE NOT FOUND ERROR RESTORING TBSP FROM FULL DB BACKUP (LEGATO SPECIFIC) IY10432 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY IY10469 CORRUPTION IN RECOVERY HISTORY FILE ON DROP TABLE RECOVERY ITEM IY10475 IWM_TRACKER PRODUCES SQL0305N WHEN TRACKING A SUMMARY TABLE IY10484 LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973. IY10491 SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1 IY10499 OPTLEVEL 5 PLAN WORSE THAN OPTLEVEL 3 PLAN IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY10562 DB2 UDB INTRA_PARALLEL ON - QUERY RETURNS AN SQL0955 ERROR 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. IY10585 SQL0501 AFTER SQL0437W IN CLI APPLICATION. RETRY LOGIC FAULT. IY10615 SQL10003 ERROR RETURNED TO USER APPLICATIONS, AND LOGGED IN THE DB2DIAG.LOG FILE. MEMORY LEAK IN BSU HEAP IY10625 SNAPSHOT FOR TABLES, IF MORE THAN 1 TABLE HAS A NULL NAME, DB2 TRAPS. IY10668 Memory corruption caused by TQS - dirty partial_tuple_saved flg IY10765 APPLICATION HANG IN FCM ON VERY FAST MACHINE IY10794 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY IY10803 LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N. IY10816 CLI0111E ON INSERT OF DECIMAL 0.00= 50 CHARS IN SQLAJBND_BIND. JR14517 SQL1092 WHEN CREATING DB ON REMOTE SERVER FROM CLIENT. CATALOG_NOAUTH IS IGNORED. JR14521 JAVA COMMAND CENTER RESULTS GREYED OUT WHEN SCROLLING. JR14550 JAVA COMMAND CENTER WIN9X RESULTS > 4682 CHAR DISPLAY PROBLEM JR14576 JDBC NET DRIVER RETURNS SAME RESULTS WITH PREPAREDSTAMENT. JR14592 CONNECT TO DATABASE ON NT HANGS IN STRICMP() C LIBRARY CALL JR14595 SQLDRIVERCONNECT IS SIGNIFIGANTLY SLOWER IN DB2 V6.1 COMPARED TO V5.2 JR14605 DIA3419C--NETBIOS NOT STARTED SUCCESSFULLY RC 3 JR14606 EXPORT OF DEL MODIFIED BY DECPT SUBSTITUTES PERIOD FOR ANY CHARACTER FOR ITALIAN VERSION DB2 ON NT JR14625 NT PERFORMANCE MONITOR NOT PROVIDING DETAILS FOR THE SECOND AND FOLLOWING APPLICATIONS JR14646 ADDING XBSA SUPPORT TO DB2 NT FOR SAP JR14648 DBA3037 ON VISUAL EXPLAIN WHEN DETAILED STATISTICS COLLECTED ON SOME BUT NOT ALL INDEXES FOR A GIVEN TABLE JR14723 SQL1112 -NOT ENOUGH SYSTEM RESOURCES WHEN TRYING TO SCHEDULE ~100 JOBS FROM THE SCRIPT CENTER JR14737 THE CLIENT IS INCORRECTLY CREATING MULTIPLE SNA CONVERSATIONS USING THE SAME LUWID. THIS IS CAUSING DB2 OS 390 TO ABEND. JR14742 DB2JDS.EXE GOES DOWN ON A VERY LARGE SELECT WITH ONE PARTICULAR USER JR14759 LOAD OF DEL FILE WHEN BOTH' CAST(NULL AS CHAR) USED IN EXPORT' & MODIFIED BY USEDEFAULTS IN LOAD : DATE INSERTED IS WRONG JR14780 SQL0750N WHEN TRYING TO RENAME TABLE WITH IDENTITY COLUMN.