IBM Database Server for OS/2 v4.0.1 APAR List 07/27/98 ============================================= Official FixPak 8192: APAR # Abstract ------- -------------------------------------------------------------- IC16687 CLIENT DOES NOT HANDLE OUTER JOIN IX57283 LONG FIELD DATA CORRUPTED WHEN MULTIPLE PROCESSES INSERTING LONG FIELD DATA INTO THE SAME TABLE IX58313 DB2/6000 V211 ACTIVATE, BACKUP, RESTORE, CONNECT GIVES SQL1042 IX60015 SQLURLOG_API (ASYNS LOG READ API) RETURNS WITH AN SQL2657N INCORRECTLY WHEN IT SHOULD NOT. IX60403 CALL TCP/IP _R FUNCTIONS IX60737 DUMP OSS RC CALLED FROM LOAD UTILITY WHEN REMOTE FILE IS OPENED. IX60794 DB2/6000 V2.1 BACKUP WILL LEAVE 2 IPCS AFTER COMPLETING. ONE IS A SEMAPHORE, AND THE OTHER IS A MESSAGE QUEUE. IX61036 PREP COBOL APP. WHICH HAS $SET GENRATES SQL4001 IX61101 BACKUP TO ADSM SHOULD UPDATE FILESPACE, IF IT ALREADY EXISTS IX61129 MEMORY LEAK IN LONG RUNNING CLP DOING REPEATED UDF REFERENCES IN DB2/6000 V2. IX61374 CICS/6000 TERMINATES AFTER BAD XACLOSE USING DDCS/6000 IX61923 EXPORTING LOB FILES EXCEEDS 1000. IX62275 DB2STOP HANGS INTERMITTENTLY ON AIX 3.2.5 OR 4.1.4 IX62276 GETTING LIBDB2VES.A IS UNDEFINED WITH VISUAL EXPLAIN IX62287 DB2/6000 V2.1.1 - QUERY USING CORRELATED SUBQUERY ON ONE TABLE WITH INDICES IS RETURNING WRONG NUMBER OF ROWS IN RESULT SET. IX62424 APPENDING TO BLOB COLUMNS FAILS WITH SQL0902 RC=110 IX62442 CLEAN UP ERROR PROCESSING FOR NON-ATOMIC ARRAY PROCESSING WHEN PROCESSING IN CLI IX62454 PAGE CLEANERS FLOOD THE DB2DIAG FILE AND DB2 HAS TO BE STOPPED. IX62464 BINDING TO A BLOB COLUMN CAUSES SEGMENTATION FAULT. IX62502 DB2STOP HANGS WHEN DATABASE PREVIOUSLY ACTIVATED IX62759 PROBLEM WITH DB2LOOK TOOL IN DB2/6000 V2.1.1. MIMIC OPTION IS NOT HANDLING UNIQUE INDEXES AND PRIMARY KEYS PROPERLY. IX62803 SIGNAL #11 IN SQLRCFDA DURING FREEING OF ACCESS ALLOCATIONS IX62813 RESTORE FROM TAPE TRAPS IX62897 8 TABLE JOIN TOO BUSHY AT OPTIMIZATION LEVEL 0 WHEN STATISTICS HAVE BEEN UPDATED. IX62910 DB2 LOST CONNECTION FROM CICS APPLICATION SERVER CAUSES CICS REGION TO CRASH. IX62913 DISK FULL MESSAGE WHEN OPENNING LOG FILE NEED CORRECT OS RC. IX63070 SDK FOR HP-UX V2 AND SUN V2 WILL NOT WORK BECAUSE NO DB2RTE. IX64284 FP UNDERFLOW (TOO MANY PREDS) CAUSES BAD PLAN IX64297 TEST IX65124 STORED PROCEDURE CORRUPTS A LARGE RETURN SQLDA IX65131 DEPENDENCIES INTRODUCED BY CORRELATION IN HXPS NOT WORKING OK IX65158 ONLINE BACKUP REMOVES THE LOCKS MADE BY QUIESCING AND THEN PUTS THEM BACK. IX65185 DB2/6000 V2.1 TRAPS AFTER PREFETCHERS AND/OR PAGE CLEANERS CAN NOT BE ALLOCATED PROPERLY DURING FIRST DATABASE CONNECTION. IX65188 UNABLE TO FORCE APPLICATIONS WHICH SHOW UP IN LIST APPLICATIONS IX65191 CORE FILE GENERATED IN SQLORESOLVEADDRESS WHEN UDF RTRIM INVOKED IX65400 LOAD OF A LARGE DATASET WILL FAIL IN THE BUILD OR DELETE PHASE IX65422 JAVA LINKS NOT BEING CREATED DURING INSTANCE UPDATE AFTER UPGRADING TO DB2/6000 V2.1.2 FROM V2.1.1. IX65568 SQL0444 RETURNED ON USE OF RTRIM FUNCTION. DB2CLIFN.A NOT FOUND IX65614 INVALID MEMORY BLOCK DURING PREP IN THE DIAG FILE (SQL0083). IX65659 BACKUP ON DB2/HP V2.1.2 FAILS. IX65739 LIBDJRA.A IS NOT SHIPPED AND CONNECTS TO DOWNLEVEL SERVERS WILL FAIL WITH A SQL10013. IX66149 SOUNDEX UDF IS RETURNING INCORRECT RESULTS IN DB2/6000 V2.1. DB2/2 V2.1 RETURNS THE PROPER VALUES. IX66200 MEMORY THRESHOLD USED FOR THE AGENTPOOL IX66817 LOAD LARGE TABLE WITH INDEX TRAPED IN SQLU_SBGETPG (SIG. 11) IX66913 PERIODIC SQL0902 RC 24 (INCORRECT TABLE HANDLE ENCOUNTERED) DUE TO WANDERING MEMORY OVERWRITE IX67033 DB2ADUTL DELETE KEEP... INCORRECTLY DELETES LOGS IX67077 SQL1227 WHEN UPDATING HIGH2KEY IN SYSSTAT.COLUMNS (SAP) IX67093 FORKING AND CLI CALLS ON AIX CAN RESULT IN PROBLEMS FOR THE CHILD PROCESS. IX67183 SQLPROCEDURECOLUMNS RETURNS A PRECISION OF 0 IF A PARAMETER IS DEFINED AS PARMNAME CLOB(1000) IX67258 DB2 THINKS APPLICATION IS MULTI THREADED IX67291 DB2 2.1.2 COMMAND LINE REDIRECTED RESTORED WITHOUT PROMPTING TRAPS IMMEDIATELY WITH A SQL1224 IX67296 -1042C LANG=JA_JP-ACTIVATE DB FOLLOWED BY DB2STOP LEAVES DANGLING PROCESSES AND LEADS TO NEXT CONNECTION TO DB FAILS. IX67302 TRAPPING DOING ADSM BACKUP IN WALK_LIB. IX67307 ODBC/CLI PERFORMANCE IMPROVEMENTS IN V2.1.2 IX67436 DB2/6000 V2.12 HANGS IX67458 CURRENT TIMESTAMP RETURNED BY DB2/6000 V2.1 INCORRECT WHEN THE MICROSECOND PORTION SUPPOSED TO BE ALL ZEROS. ONLY ON 604-SMP. IX67484 TRAP ON EXIT OF A FORKED CHILD DUE TO THE INTERRUPT HANDLER TRYINT TO CLEANUP INVALID CTX'S FROM INHERITED FROM PARENT IX67732 FIX VARIOUS PROBLEM FOUND BY A CUSTOMER IX67750 CLP TOKEN SIZE SHOULD BE >1024 IX67774 DDCSTRC ON -L 8000000 ... INCORRECT SYNTAX (MISSING = SIGN) WILL CAUSE A CORE DUMP ON LANG=JA_JP IX67838 POOR LOGGING LOGIC WITH LOGRETAIN + USEREXIT IX67875 DB2DD FAILS MOUNTING CONTAINERS TO A NEW VOLUME GROUP IX67928 MEMORY LEAK WHEN USING CLI IX68173 SQLCOLUMNS CALL RETURN INCORRECT RESULTS FOR USER DEFINED TYPES. IX68236 TIMESTAMP GROWS WITH HIGH # OF CONNECTIONS IX68370 CLI0131E ERROR WHEN TRYING TO 'EDIT QUERY' TO DB2/6000. IX68406 DB2 INSTALL FAILS ON SINIX 5.43 AND HIGHER IX68437 PASS ENVIRONMENT VARIABLES THROUGH TO STORED PROCEDURE. IX68441 INSERTING INTO DB2 V2.1.2 TABLE GIVES SQL0901N, REASON = 'COLUMN NUMBER OUT OF RANGE'. DUPLICATE COLUMNS EXIST IN COLUMN LIST. IX68677 DB2/6000 V2.1.2 DATABASE ROLLFORWARD FAILS WITH SQL1224N ERROR. TRAP FILE SHOWS A SIGNAL #11 IN SQLDX_WRITE_PARTIAL_PAGE(). IX68682 LIST TABLESPACES FREE PAGES NOT UPDATED FOR DMS TABLES AFTER DROP TABLE. IX68697 SQL0298 ON COMMAND LINE REDIRECTED RESTORE DB2/AIX 2.1.2 IX69111 LOAD FAILS IN BUILD PHASE IX69332 WHEN INX PAGES GET CORRUPTED , DB2AGENT GOES INTO AN INFINITE LOOP. IX69549 DB2DD GOES INTO AN INFINITE LOOP BUILDING THE COLOR MAP IX69610 JAPANESE CODE PAGES RESULT IN A CONVERSION ERROR MESSAGE IN THE DB2DIAG.LOG IX69806 HALF DATA RECD FOR DOUBLE BYTE COLS UNDER VB RDO. IX70033 SQLSETENVATTR WITH SQL_ATTR_OUTPUT_NTS NOT WORKING PROPERLY WHEN IT SET TO SQL_FALSE IX70040 DBI1105W WHEN DOING A DB2IUPDT IX70179 TAPE RESTORE FROM DB2/NT AFTER V2.1.2 GA FAILS. SQL2058W AN END-OF-MEDIA. IX70183 DB2 WILL HANG ON BACKUP IF 'WITHOUT PROMPTING' IS SPECIFIED AND THE BACKUP REACHS THE END OF THE TAPE. IX70279 UNABLE TO BREAK 64 GB BARRIER WHEN LOADING/IMPORTING LOB FIELDS. IX70344 UABLE TO LINK A HP APP TO DB2 IX70529 DB2IUPDT->DB2ICRT CALLS DB2IMDBM WHICH NULLS TP_MON_NAME IN DB2SYSTM (DBM CFG) FILE IX70903 CRASH RECOVERY COMPLETES BUT CODEPAGE MIXMATCH MARKS DB BAD. IX71104 DB2BATCH CORE DUMPS WHEN USING -CLI AND -O WITH P > 1 EX: DB2BATCH -D SAMPLE -F -O P 3 -CLI IX71266 SQL10013 - ON SIXTH INVOCATION OF STORED PROCEDURE IX71439 LOOPING FENCED UDF NOT CLEANED UP IX71612 SQL0204 FOR IMPORT WITH REPLACE OPTION INTO A TABLE OWNED BY THE USER BUT IS NOT FULLY QUALIFIED IN THE IMPORT COMMAND IX71625 CREATE DATABASE FAILS ON E30/AIX415 ON A LOB CHECK IX71837 USING FOR BIT DATA AND NORMAL CHAR TYPES IN A MERGE JOIN LEADS TO INCORRECT OUTPUT. IX71898 INCORRECT OUTPUT FOR FUNCTION LOG10 IX71992 PROBLEMS DOING A PERFORMANCE MOVE OF LOG FILE WILL CREATE NEW IX71996 LOAD INTO A TABLE ALIAS FAILS WHEN RETRIEVING COLUMN DEFAULTS IX72125 DB2ADUTL TRIES TO EXTRACT BACKUP ARCHIVE WHEN IT'S ASKED FOR LOG ARCHIVES. IX72350 TRIGGERS IN A SUBQUERY PREVENT OPTIMIZER FROM REWRITING SUBQUERY AS A JOIN. IX72355 A TRAP WITHIN A STORED PROCDURE IN SQLE_MRSP. DB2SYSC CORE DUMP IX73014 SQLCANCEL IN JDBC DOES NOT WORK AS IT IS SERIALIZED. IX73133 FIX PARTIAL SUPPORT FOR KOREAN CODEPAGE IX73136 A PASSWORD DEFINED WITHIN NIS+ WITHIN SOLARIS CANNOT BE AUTHENTI CATED BY DB2 IX73143 SQL0289 - IF CUSTOMER DELETE X NUMBER OF RECORDS AND TRY TO INSERT BACK THE SAME NUMBER OF RECORDS. IX73231 QUERY WAS GETTING VERY BAD PERFORMACE IN A QUERY WHEN RUNSTATS FOR A TABLE WAS RUN WITH DISTRIBUTION. IX73248 WHEN DISABLEMULTITHREAD IS SET TO 0 IN THE DB2CLI.INI FILE THERE EXISTS A MEMORY LEAK IN THE SQO LAYER WHEN USING CLI IX73311 -901 SQLNO_GREEDY_DISCONNECTED 250 DURING PREP IX73355 ADDITIONAL DIAGNOSTIC INFORMATION FOR -902 IN SQLSFSCB IX73959 ROLLFORWARD TABLESPACE GENERATES -1273 IF PRECEEDED WITH BACKUP/ RESTORE WITH NO WORK INBETWEEN IX73998 MEMORY OVERWRITE DURING INDEX CREATION DUE TO VARIABLE NOT LARGE ENOUGH TO HOLD PACKED DESCRIPTOR VALUES IX74229 REMOVING TRAILING PERIOD FROM DECIMAL TO CHAR. IX74997 LOG FILES NOT ARCHIVE AFTER CRASH RECOVERY. IX75097 TIMESTAMP PROBLEM IN 4WAY SMP SP2 AIX IN SQLOGMT2 IX75443 OPTIMIZER ERRONEOUSLY FAVOURS LIST PREFETCH OVER TABLE SCAN WHEN SCANNING SMS TABLES WITH LESS THAN 32 PAGES. IX75609 LIST APPLICATIONS CORRUPTS APP ID FOR LONG APP NAMES IX75687 UNABLE TO RESTORE FROM A BACKUP TO ADSM USING MULTIPLE OPEN SESSIONS. IX75937 SQL2542N FOR RESTORE OF A PREIOUS BACKUP THAT WAS DUMPED INTO 10 OR 20 OR 30/40/50/60/70/80/90 FILES IN THE SAME DIRECTORY IX76172 STATEMENT OBJECT CREATED BY GETBINARYSTREAM IS NOT GETTING CLOSED IX76443 PERFORMANCE PROBLEM OF A SELECT WITH AN ORDER BY IX76471 PERFORMANCE ENHANCEMENT TO INSERTS ON LARGE TABLES IX76678 SQL1042 ON GET SNAPSHOT FOR APPLICATIONS ON SOLARIS 2.5.1 WITH SUN PATCH 104283 OR SOLARIS 2.6 IX76834 MULTITHREADED CLI ON AIX 4.3, PROBLEM WHERE __N_PTHREADS CAN BE -1 EVEN THOUGH LINKED WITH PTHREADS IX77066 BYTE REVERSAL ERROR BETWEEN NT & AIX. IX77137 RUNSTATS WITH DISTRIBUTION PICK INCORRECT PLAN IX77333 HP: SHARED MEMORY PROBLEM - BACKWARD FIT UDB FIX FOR V2 IX77399 CRASH RECOVERY ENDS TOO EARLY. IX78244 REORG OF COMPACT BLOB EXPANDS OBJECT TO NON-COMPACT SIZE IX78307 CONNECT TO REMOTE DB FAILS WITHOUT AN ERROR.RETURNS TO A PROMPT. IX78836 ALTER TABLE ... NOT NULL DEFAULT CURRENT TIMESTAMP FAILS -193 IX79090 CHECK IN PROPER VERSION OF SIGNAL HANDLER IN JDBCSERVER.C IX79235 INTERMITTENT SIGNAL 11 IN SQLULUMW JR09106 INCORRECT UPDATE OF DB2/6000 LOGFILSIZ FROM DB2DD/2 JR09200 SQL0444N (-444) FROM AS/400 EXECUTING STORED PROCEDURE JR09226 GRAPHIC DATA TYPE PROBLEMS WITH ODBC FROM MS ACCESS JR09268 CREATING AN EVENT MONITOR IN DB2/NT V2.1.1 FROM THE CLP DOES NOT ACCEPT THE WINDOWS/NT SYNTAX FOR A LOCAL NAMED PIPE. JR09291 DB2 ODBC DRIVER CAUSES SQLTABLE TO USE TABLE SCAN ON DB2/MVS THUS RESULT IN PERFORMANCE PROBLEM JR09292 UPDATE BASED ON DATE FIELD FAILS FROM ODBC APPLICATIONS JR09293 HANG DURING EXPORT JR09307 DB2/2 V2.1 REXX API 'GET RECOVERY HISTORY FILE ENTRY' FAILS WITH SQL2165W ERROR IF BACKUP ENTRY CONTAINS MORE THAN 4 TABLESPACES. JR09314 THE PROBLEM IS DUE TO THE CONNECTION ACCESS MODE BEING CHANGED TO READ_ONLY. JR09319 CLOB FIELD RETURN INCORRECT LENGTH ON 0 LENGTH STRING WHEN SQLBIND IS + 1 OF THE ACTUAL LENGTH OF THE CLOB JR09339 LOGIC ERROR IN SQLE_DB2RA_AS_HOPDRIVER_FREE JR09350 RESTORE GOT DBABG.EXT ACCESS VIALATION 0X00000005 JR09376 16 BIT APPLICATIONS CAUSE PAGE FAULT WHEN DOING SQLCONNECT A INVALID DSN LENGTH IS SENT TO US. JR09380 OFFLINE BACKUP SHOULD NOT COMPLETE WITH MISSING TABLE DAT FILES. JR09399 HISTORY FILE IS NOT UPDATED AFTER DATABASE BACKUP TO TAPE USING SAMPLE USEREXIT. JR09419 COUNTRY CODE FOR SLOVENIA IS NOT SUPPORTED IN DB2/NT JR09424 PRECOMPILE OF A COBOL APP WITH SDK/NT LEAVES OUT A . AT THE END OF THE CALL-CONVENTION LINE IF SPECIAL-NAMES IS DEFINED ALREADY. JR09425 SQL/DS RETURNS -515 ON COMMIT JR09426 CONVERTING FROM ASCII TO FLOAT ON DB2/NT IS DEPENDANT ON THE LOCALE. IMPORTING A ASCII FILE TO A FLOAT COLUMN FAILS (SPAIN) JR09435 SQL30073 RC 0010 FROM AR IF APP USES FIXCHAR WITH LENGTH >254 JR09436 DDCS/2 GATEWAY SYS3175 NETAPI.DLL WITH SECURITY SAME JR09442 SQL_SUCCESS_WITH_INFO FROM SQLFETCH USING MS ACCESS. TABLE ON THE DB2/MVS SYSTEM WHICH HAS MORE THEN 22 FIELDS. DUPLICATE ROW JR09443 DB2 CLI ODBC DRIVERS TRUNCATE DIGITS AFTER DECIMAL POINT ON CLIENTS WHICH USES COMMA AS THE DECIMAL POINT JR09454 IMPROVE MIGRATE DIAGNOSTICS. JR09457 PREP ADDING "SPECIAL-NAMES" IN INCORRECT SECTION OF COBOL APP JR09467 CLI0102E INVALID CONVERSION ERROR ON SQLFETCH FOR AN SQLTABLES CALL WHEN GOING TO THE AS400. JR09477 EXPORT OF WSF FOR V1.2 AND V2.1 DIFFER IN THE CONTENTS OF THE FILE WHEN THE SUM FUNCTION IS PART OF THE SELECT STMT JR09518 ON A SQLDRIVERCONNECT THE SECOND CONNECT WITH A SMALLER PASSWORD RETURNS AN INCORRECT PASSWORD. (APPENDS FIRST PASSWORD TO END) JR09592 SQL_C_BINARY PASSED TO A STORED PROCEDURE GETS PROMOTED TO A SQL TYPES THAT MATCHES THE SIZE IGNORING THE TYPE IN BINDPARAMATER. JR09616 PRECOMPILE OF COBOL SOURCE CODE WITH THOUSANDS OF HOST VARIABLES MAY CAUSE SQL0083C ERROR. NEED TO INCREASE THE MEMORY POOL. JR09686 CONNECTION FROM WINDOW SUPPORT FAILS LOOKING FOR DB2CPICW.DLL JR09694 TRAP IN DB2SQL1 IN SQLNQ_GET_BASE_FCS() FROM A SELECT FOR UPDATE ON A VIEW. JR09698 BACKUP WITH USEREXIT GENERATES SQL2003, SQLCA -2024 ... 7B IN DOSOPEN - DEBUG DB2EUTIL.DLL MASKS PROBLEM JR09852 SELECT DECIMAL (-1,1,0) FAILS IN CLI JR09862 SQLGETDATA() RC=S1004 & PCBVALUE WRONG IF CALLED WITH SAME COL# JR09881 INCONSISTENT RESULTS FROM THE DB2DART TOOL JR09886 -902 REPORTED BY SQLRARVP DURING RUNSTATS JR09901 ROLL FORWARD THROUGH THE LOGS GENERATES A TRAP IN DB2DMGR.DLL IN THE SQLICKEY FUNCTION JR09902 ODBC LOGON SCREEN DOES NOT GET PLACED AS THE FRONT WINDOW JR09903 BIND SQL_C_TYPE '0' TO SQL_DECIMAL WITH SQLBINDPARAMETER() FAILS JR09912 SQL3022 ON EXPORT FROM V1.2 CLIENTS THROUGH DDCS V2.3.2 JR09914 CUMULATIVE COST AFTER NLJOIN IS TOO SMALL JR09917 CLIENT HANGS WHEN DOING A QUERY THREW DDCS TO MVS JR09920 RECEIVE A CLI0112E STATE 22005 WHEN INSERTING FROM POWER BUILDER AND CAE/WIN-OS/2 2.1.1 811+ JR09922 ADD #INCLUDE TO SAMPLES\CLI\SAMPUTIL.C JR09936 INCLUDE DEFECTS 56919,56923,57281,58767 INTO 2.1.2 JR09939 FILTER FACTOR FOR 'LIKE %' IS INCORRECT JR09950 REXX API FOR CATALOG DATABASE USES AUTHENTICATION SERVER JR09951 PROBLEMS WITH CHINESE CODEPAGE TRANSLATION WHEN CODE PAGE IS SET TO 1381 ON OS/2 AND 1383 ON AIX JR09984 DB2DD APPC CATALOG IN ERROR JR10020 'CONNECT TO :NULLSTRING' BEHAVIOUR HAS CHANGED BETWEEN DB2 V1.X AND DB2 V2.1. THE BEHAVIOUR IN V1.X IS CORRECT. JR10064 SQLSTATISTICS CALL TO A MVS HOST THAT HAS A INDEX COLUMN NAME WITH DBCS IN IT CAUSE A SUBSTITUTION ERROR (01517) JR10102 ADD FOR FETCH ONLY TO THE STATIC SCHEMA CALLS FOR DB2/400 AND DB2 MVS. JR10105 DB2 VALUES CHAR('STRING',LENGTH('STRING')) GENERATES SQL0901 SHOULD GENERATE SQL0123 JR10121 SQL0001 DURING ACTIVATE DB AFTER A CONNECTION TO THE DB WAS ESTABLISHED FROM A DIFFERENT SESSION. JR10137 POWER BUILDER ( POWERSOFT ) APPLICATION CAUSES A GPF IN DB2W.DLL JR10147 TRAP IN DB2SYSC JR10150 PROBLEM WITH MULTITHREADING IN THE CAE FOR SOLARIS JR10162 ACCESS PLAN FOR CERTAIN QUERIES DOES NOT USE A TEMP TABLE (AS WAS DONE IN V1) WHICH PRODUCES BAD PERFORMANCE VS V1. JR10169 SQLO_REMOVE_STATIC_DATA_ANCHORS IS NEVER CALLED ON NT JR10183 -305 TO AN APPLICATION MAKING A REMOTE PROCEDURE CALL TO HOST SYSTEM DUE TO MISHANDLING OF INDICATOR VALUE. DDCS JR10203 QUALIFIER SUPPLIED TO SQLTABLES CALL ARE IGNORED JR10208 TRIGGER RETURNS SQL100 FOR UPDATE INSTEAD OF SQL445. JR10212 PERFORMANCE PROBLEM WITH SQLCOLUMNS CALL AGAINST DB2/400 JR10218 MIGRATE DBASE FROM V1 TO V2 FAILS IF MAXAPPL OR MAXLOCK < 100 JR10221 BUG IN THE ERROR LOGGING PATH JR10234 AUSTRIAN CODE PAGE SUPPORT REQUIRED IN DB2 V2 JR10299 SQLTABLES CALL ON A SYSTEM TABLE THAT HAS A SYSSCHEMA THE SAME AS THE TABLE CREATOR THE TABLE TYPE WILL BE SYSTEM TABLE JR10303 SQL0902C WITH RC = 70 ON THE CLIENT WHEN A LARGE AMOUNT OF DATA IS BEING RECEIVED FROM THE SERVER JR10304 SUPPORT FOR CODE PAGE 819 LATIN 1 IN CAE FOR OS/2 JR10312 RESTORE OF DB2 V2.1.2 DATABASE FAILS WITH AN SQL0902C, RC=72 ERROR. JR10324 BACKUP OPERATION NOT RELEASING ALL MEMORY ONCE COMPLETED CAUSING RANDOM TRAPS IN DB2 AFTER A BACKUP JR10327 V2 ONLY: RETROFIT OPTIMIZE FOR N ROWS FIXES TO V2 JR10328 RUNNING MORE THAN ONE USEREXIT AT THE SAME TIME WILL CAUSE ONE TO HANG. JR10336 SYS3175 TRAP IN DB2APP.DLL DURING AN EMBEDDED SQL CONNECTION ATTEMPT IN DB2/2 V2.1.2. SQLASTRT IS THE FUNCTION ABENDING. JR10347 SQLCANEL FAILS WITH -1 WHEN EXECUTED. SQLERROR CALL RETURNS NO ERROR. JR10370 DBCS SUPPORT FOR JDBC ON JDK V1.02 ON OS/2 JR10387 SQL0902N RC 81 RUNNING DDCS/2 APP AGAINT DB2/VM AND DB2/VSE 5.1.0 JR10404 CHANGE OF DATABASE AT THE USERID AND PASSWORD PROMPT OF THE DB2 DRIVER DOES NOT TAKE EFFECT. JR10405 A QUERY AGAINST A VIEW IN DB2 COMMON SERVER V2.1.2 FAILS WITH AN SQL0901N ERROR, REASON = 'OID IMBALANCE'. JR10406 A NUMBER OF JDBC FIXES JR10446 MS-QUERY RETURNS SQL0104N ERROR WHEN TRYING TO SELECT AGAINST DB2/MVS 3.1 JR10460 VARCHAR/LONG VARCHAR ARE NOT SUPPORTED IN FORTRAN - NEED TO ADD THIS SUPPORT JR10462 DDCS/NT GATEWAY TRAP WITH DB2SYSC.EXE WHEN VOLUME IS HIGH JR10473 SQL2044 RC 4 ON FAILING LOAD. INVALID MESSAGE RECEIVED FROM A MESSAGE QUEUE. JR10474 SETTING SQLSTATE FIELD OVERWRITES SOMEOTHER FIELD IN MEMORY. JR10479 TRAP IN DB2 WHEN NON DB2 DATA IS WRITEN TO OUR TCPIP PORTS. THE TCP/IP INTERUPT PORT IS THE FAILING ONE JR10480 WHEN INSERTING A SET OF ROWS USING ODBC AND SQLPREPARE AND SQLEXECUTE A TRAP IN DB2SYSCS.EXE JR10504 SQLTABLES CALL WITH A (NOT NULL/ZERO LENGTH STRING) CATALOGNAME CAUSES AND ERROR. JR10517 SQLPUTDATA RETURN -1 WITH VALID POINTER OF 0 LENGTH INPUT JR10519 DB2 MEMORY LEAK WITH FENCED UDF CALLS JR10586 TRAP IN DB2PGIXT, DURING LOGGING RELATED: WIN95 NOT RECOGNIZING 'CMD.EXE' EXECUTABLE JR10602 TRAP IN SQLNG_PROCESS_PARSE_TREE() DURING A PREP DB2 V2 JR10607 TRAP IN DB2ASP0.DLL (NOTE, TRAP SCREEN SHOWS DB2SYSC) JR10608 IMPORT FROM SDK/WIN31 V210 FAILS WITH SQL3011C: NOT ENOUGH STORAGE TO PROCESS THE COMMAND. JR10612 RETURN ONLY UNIQUE ROWS FROM SYSIBM.SYSPROCEDURES WHEN CONNECTED TO DB2 FOR MVS. JR10615 TRANSACTION LOGGING CODE IGNORES SERIOUS ERROR JR10751 SYS3175 TRAP DURING A DATABASE CONNECTION (RESTART). PRIOR TO THIS, A REORG TRAPPED LEAVING THE DATABASE INCONSISTANT. JR10755 LOAD OF AN IXF FILE WILL CAUSE TRAP ON ANY OPERATING SYSTEM. AIX GIVES SIGNAL #4, OS/2 C0000005 IN SQLULIRA JR10785 DB2STOP TRAPS IN DB2SYS.DLL ON WARP SMP WITH LOGRETAIN ON JR10795 DB2 2.1.2 MAY INCORRECTLY UNDER-COST A PLAN AND CONSEQUENTLY CHOOSES A BAD PLAN JR10834 SUPPORT FOR JDK V1.1 JR10835 SQL0305 (SQLSTATE 22002) RETURNED WHEN USING COGNOS DUE TO NULL INDICATOR VARIABLES NOT BEING SPECIFIED. JR10837 BACKUP TO 0 GENERATES BLANK LINES IN .RST FILE THIS CAUSES TRP IN RESTORE FROM 0 (USEREXIT HAS ZIP COMMAND) JR10844 SQLNATIVESQL RETURNS MISPLACED RIGHT PARENTHESIS FOR CALL STMT JR10848 TRAP IN DB2DARI.EXE WHEN SQLDBCON GETS NULLED OUT (IN SQLERIAR_CONNECT) JR10876 LOGRETAIN NOT USING ALL AVAILABLE LOG SPACE JR10908 INVALID PARAMETER PASSED TO USER EXIT. JR10930 SQLP_ASYNCLOGREADAPI FAILURE USING DATAPROPAGATOR CAPTURE DUE TO LOG NOT BEING AVAILABLE. JR10935 RESTORE USING USEREXIT IS CHANGING LOG PATH BACK TO DEFAULT JR10940 'HIGH WATER MARK FOR DATABASE HEAP' IS NOT TRACKED CORRECTLY. JR10963 RUNSTATS UPDATES CERTAIN VALUES INCORRECTLY. JR10965 SQLSETCOLATTRIBUTES() PROBLEM WHEN STATEMENT HANDLE REUSED JR10969 CONNECTIONS CREATED VIA HOPPING DO NOT GET CLEANED UP WHEN A REMOTE CLIENT REBOOTS JR10973 GETASCIISTREAM TRAPS SERVER WHEN RETURNING ZERO LENGTH STRING JR10975 LOAD TABLE FROM AN IXF ENCOUNTERED -3314N JR10978 DB2DART DOES NOT CHECK FOR RECORD LENGTH=0 JR11011 JDBC PERFORMANCE ISSUES JR11013 RESTORE VIA USEREXIT WITH DIFFERENT INSTANCE NAME FAILS JR11025 SQLPRIMARYKEY/SQLFOREIGNKEY LOCKUP SYSTABLES IN AUTOCOMMIT MODE JR11026 CLI0112E WHEN USING COMMA DELIMITED NUMBERS THROUGH ODBC DRIVER. JR11040 INVALID QUERY USING GROUP BY CLAUSE TRAPS ENGINE JR11049 OBSOLETE DBMON TCB'S LEFT AFTER DATABASE PAUSE JR11071 APPC LISTENER MUST BE RESTARTED WITH DB2STOP JR11073 SQL0332N - CODEPAGE CONVERSION BETWEEN 500 AND 1275 JR11111 SYNC POINT MANAGER AUTHENTICATE USER INCORRECTLY JR11208 TRAP AFTER MANY SEQUENTIAL BACKUPS JR11261 DB2 COMMON SERVER - 'INTERSECT ALL' RETURNS TOO MANY ROWS. JR11296 MEMORY LEAK IN JDBC APPLICATION DRIVER WITH SETSTRING/GETSTRING JR11312 MEMORY OVERWRITTEN WHEN LOGGING SQL STATEMENTS > 4K JR11320 CONCURRENT LOADS TRAP JR11337 SQL3401 SQLGIMP COBOL API DOES NOT IGNORE FILLER BYTES JR11344 CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE JR11348 LOAD OF SOME IXF'S TRAPS JR11349 ROUND FUNCTION RETURNS INCORRECT RESULTS WHEN ARGUMENT 2 IS NEGATIVE JR11356 ODBC DRIVER RETURNING ERROR INSTEAD OF SUCCESS_WITH_INFO JR11363 CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE JR11395 HIDE EXTENDED FETCH CAPABILITY JR11417 ROW DATA BEING SENT WITH SQL100 CONFUSES DRDA AR WHEN CONNECTING TO DB2 ON OS/2 AS THE DRDA AS JR11422 DB2STOP HANG AFTER A FORCE APPLICATION ALL WITH ACCESS FEATURE. JR11428 CLI0002W DATA TRUNCATED. SQLSTATE=01004 {SQLDRIVERCONNECT} WHEN CONNECT STRING IS LONGER THAN 254 CHARACTERS JR11433 LOG CORRUPTION WITH '504' MESSAGES IN DB2DIAG.LOG FILE JR11481 DB2 NT TRAP IN DB2RDS.DLL WHEN A DESCRIBE INPUT IS BEING PROCESS ED FOR A STATEMNET THAT DOES NOT HAVE ANY PARAMETER MARKERS JR11484 INTERMITTENT TRAP IN SQLUBINITPROCESS DURING BACKUP JR11502 PATCH KEYWORD IN DB2CLI.INI TO OVERRIDE OTHER SETTINGS JR11526 NLJN DOES NOT PRODUCE OPTIMUM ACCESS PLAN COMPAIRED TO V1 JR11533 TRAP IN INDEX RECREATION PHASE OF LOAD WHEN INDEXES ARE DEFINED ON TABLE AND AFTER INTERMIM FIXPAK WR08140R IS APPLIED. JR11553 FLOATING POINT DATA TYPE RETURNS WRONG VALUE JR11585 PROBLEM WITH LIST APPLICATIONS SHOW DETAIL - CHANGE STATUS TIME JR11629 PATCH1=1 CAUSES COUNT(DISTINCT COL) TO FAIL. JR11636 TRAP IN MEMTREEPUT DUE TO MEMORY CORRUPTION JR11680 REMOVE 8K LIMIT ON SQL FOR EXPORT COMMAND JR11721 INTERMITTENT DB2 CRASH WHEN A CUSTOMER TRIED TO TAKE A SNAPSHOT JR11722 INTERMITTENT DB2 TRAP IN FUNCTION SQLRIRETURNSUBSTRCSOBYTES OR SQLOFMBLK JR11726 SPORADIC TRAPS IN SQLNQ_TABSEL_OFN_CM JR11769 AFTER 'FORCE APPLICATION ALL' COMMAND ON THE SERVER TCP/IP PORT (PORT 3700) IS NOT RELEASED FOR ABOUT 5-7 MINUTES. JR11797 UDB CLIENT THROUGH DDCS WITH SPM TO THE HOST, THE XA_RECOVER CALL FAILS. JR11810 UDB NT TAPE RESTORE RETURNS SQL2530 -- IMAGE CORRUPT. JR11817 AFTER INSERT OF DATA>32700 . THE NEXT INSERT<32700 WILL CAUSE A CRASH. JR11824 TRAP IN DOSCALL1.DLL DURING CTRL-C JR11853 SYS3175 IN SQLBTERM FUNCTION WHILE ATTEMPTING TO BRING A DATBASE DOWN THAT HAS BEEN MARKED BAD. THIS BRINGS INSTANCE DOWN JR12009 OS2 SMP:SQLOFMBLK RETURNS SQLO_INV_MEM TO SQLBINIT (PROBE:80) *********************************************************************** ** ** ** (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 1998. ** ** ALL RIGHTS RESERVED. ** ** ** ***********************************************************************