******************************************************************** Product Name : DB2 UDB v6.1 for Windows NT/98/95 PTF Number : WR21188 Package Date : Tue. Jun. 06 12:07:40 EDT 2000 Build Level : s000422 ******************************************************************** List of APARs that went into WR21188 APAR No. Abstract -------- ------------------------------------------------------- GG04010 LONG VARCHAR FIELDS CAN BECOME OVERLAID GG04017 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE GG04023 LONG VARCHAR FIELDS CAN BECOME OVERLAID GG04024 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS GG04025 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) GG04026 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED GG04027 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE GG04028 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. GG04031 INSERTS ARE MISSED BY CAPTURE GG04032 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE GG04033 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS GG04034 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) GG04035 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED GG04036 INSERTS ARE MISSED BY CAPTURE GG04038 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED GG04040 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS GG04041 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN GG04042 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE GG04043 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER GG04046 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. GG04048 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION GG04049 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION GG04051 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED GG04052 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE GG04053 CMPL ADDITIONAL BLANK LINE ADDED IN THE PSEUDO ASSEMBLER OUTPUT OF THE COMPILER USING REPLACE AND COPY (ALSO IN SOURCE LISTING) GG04054 CMPL ADDITIONAL BLANK LINE ADDED IN THE PSEUDO ASSEMBLER OUTPUT OF THE COMPILER USING REPLACE AND COPY (ALSO IN SOURCE LISTING) GG04055 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. GG04056 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. GG04057 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE GG04058 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. GG04060 ASNCCP DOES NOT TERMINATE WHEN "WARMNS" IS A STARTUP OPTION AND A COLD START IS NEEDED GG04061 ASNCCP DOES NOT TERMINATE WHEN "WARMNS" IS A STARTUP OPTION AND A COLD START IS NEEDED GG04062 "ASNCMD A STOP" IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE GG04063 "ASNCMD A STOP" IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE GG04064 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED GG04065 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED GG04066 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS GG04067 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN GG04068 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER GG04069 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG GG04070 CAPTURE HANGS/RETURNS SQL0204 WHEN "SCHEMA"."TABLE" HAS A SPACE GG04071 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T GG04072 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T GG04073 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 GG04074 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 GG04075 CAPTURE HANGS/RETURNS SQL0204 WHEN "SCHEMA"."TABLE" HAS A SPACE GG04076 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY04440 BUFFERED INSERT ON LOG FULL CONDITION PRODUCES INCONSISTENT RESULTS. IY06002 MODIFY PROGRAM TYPE MAIN SP ARGUMENT INDEXES TO MATCH OS/390 IY07624 PRUNE LOGFILE COMMAND RETURNS SQL1651N IF NOT CONNECT TO DATABAS E FIRST. SHOULD GIVE SQL1024 INSTEAD. IY08076 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY08077 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY08085 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY08124 INSERTS ARE MISSED BY CAPTURE IY08454 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08455 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08456 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08457 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY08458 INSERTS ARE MISSED BY CAPTURE IY08459 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08460 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08461 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08462 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY08463 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08464 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08465 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08466 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY08467 INSERTS ARE MISSED BY CAPTURE IY08468 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08469 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08470 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08472 INSERTS ARE MISSED BY CAPTURE IY08935 "ASNCMD STOP" DOES NOT STOP CAPTURE IY08937 ASNCCP DOES NOT TERMINATE WHEN "WARMNS" IS A STARTUP OPTION AND A COLD START IS NEEDED IY08938 "ASNCMD A STOP" IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE IY09042 REPLICATION SETTINGS IN CC DOES NOT ALLOW AFTER CAPTURE. IY09251 DB2 EEE V6 CRASH RECOVERY FAILS, SQL1042 IY09262 CHANGE THE DEFAULT SQL_CONCURRENCY AS READ_ONLY BASED ON THE CLAUSES PRESENT IN THE STATEMENT. IY09280 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY09615 CAPTURE HANGS/RETURNS SQL0204 WHEN "SCHEMA"."TABLE" HAS A SPACE IY09616 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T IY09633 "ASNCMD STOP", RETURNS ERRNO 2 IY09706 TRAP IN SQLCCGETATTR USING CONNECTION POOLING IY09751 DATABASE CRASH DUE TO TIMING HOLE IN CREATE TABLE ROLLBACK IY09756 NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS. REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED. IY09788 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 IY09855 CLI ENTRY CODE TRAPS TRYING TO FREE A CONNECTION THAT NO LONGER EXISTS IY09939 ERRNO IS NOT RESET BEFORE CLI TYPE CONVERSION IY10047 DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI IY10086 SQL0100W FROM SQLJ STORED PROC ON UPDATE OF NON-EXISTING ROW IY10089 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. IY10090 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. IY10092 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. IY10093 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION IY10094 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION IY10095 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION IY10096 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION IY10118 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED IY10119 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED IY10120 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED IY10121 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED IY10137 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE IY10138 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE IY10139 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE IY10140 ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE IY10144 CMPL ADDITIONAL BLANK LINE ADDED IN THE PSEUDO ASSEMBLER OUTPUT OF THE COMPILER USING REPLACE AND COPY (ALSO IN SOURCE LISTING) IY10145 CMPL ADDITIONAL BLANK LINE ADDED IN THE PSEUDO ASSEMBLER OUTPUT OF THE COMPILER USING REPLACE AND COPY (ALSO IN SOURCE LISTING) IY10146 CMPL ADDITIONAL BLANK LINE ADDED IN THE PSEUDO ASSEMBLER OUTPUT OF THE COMPILER USING REPLACE AND COPY (ALSO IN SOURCE LISTING) IY10147 CMPL ADDITIONAL BLANK LINE ADDED IN THE PSEUDO ASSEMBLER OUTPUT OF THE COMPILER USING REPLACE AND COPY (ALSO IN SOURCE LISTING) IY10148 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. IY10149 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. IY10150 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. IY10151 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. IY10167 THE SQLDA IS INITIALIZED WITHOUT FIRST CHECKING THE SIZE OF THE RESULT SET. IF IT CONTAINS MORE THAN 255 COL. WE GET A CORE DUMP IY10181 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY10182 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY10183 TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4. IY10212 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE IY10213 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE IY10214 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE IY10215 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE IY10216 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. IY10218 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. IY10219 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. IY10220 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. IY10221 "ASNCMD STOP" DOES NOT STOP CAPTURE IY10222 "ASNCMD STOP" DOES NOT STOP CAPTURE IY10223 "ASNCMD STOP" DOES NOT STOP CAPTURE IY10224 ASNCCP DOES NOT TERMINATE WHEN "WARMNS" IS A STARTUP OPTION AND A COLD START IS NEEDED IY10225 ASNCCP DOES NOT TERMINATE WHEN "WARMNS" IS A STARTUP OPTION AND A COLD START IS NEEDED IY10226 ASNCCP DOES NOT TERMINATE WHEN "WARMNS" IS A STARTUP OPTION AND A COLD START IS NEEDED IY10227 "ASNCMD A STOP" IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE IY10228 "ASNCMD A STOP" IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE IY10229 "ASNCMD A STOP" IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE IY10244 SELECT QUERY USING REVERSE INDEX SCAN FAILED WITH SQL0900 AFTER IT RAN FOR 30 MINS OR SO. IY10256 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED IY10257 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED IY10258 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED IY10259 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED IY10309 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS IY10310 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN IY10311 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER IY10313 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS IY10314 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN IY10315 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER IY10317 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY10338 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T IY10338 CAPTURE HANGS/RETURNS SQL0204 WHEN "SCHEMA"."TABLE" HAS A SPACE IY10340 "ASNCMD STOP", RETURNS ERRNO 2 IY10341 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 IY10343 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS IY10344 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN IY10345 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER IY10346 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY10347 CAPTURE HANGS/RETURNS SQL0204 WHEN "SCHEMA"."TABLE" HAS A SPACE IY10348 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T IY10349 "ASNCMD STOP", RETURNS ERRNO 2 IY10350 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 IY10351 CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS IY10352 COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN IY10353 MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER IY10355 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG IY10356 CAPTURE HANGS/RETURNS SQL0204 WHEN "SCHEMA"."TABLE" HAS A SPACE IY10357 "ASNCMD STOP", RETURNS ERRNO 2 IY10359 CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T IY10360 CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000 IY10491 SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1 IY10500 INVALID CONVERSION/TYPE FOR DOUBLE WITH STORED PROC IN DB2/MVS 6 IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY10765 APPLICATION HANG IN FCM ON VERY FAST MACHINE IY10816 CLI0111E ON INSERT OF DECIMAL <=0.00 AND >=0.99 / SQLJ STORE P JR14386 EXECDIRECT ON KEYSET CURSOR USES THE WRONG INFO FOR GETTING DATA OF THE PRIMARY KEY JR14416 OS/2: AUTHENTICATON SERVER FAILS IF SECURITY IS SAME JR14491 THE BIND FILENAME IS TRUNCATED IF > 50 CHARS IN SQLAJBND_BIND. JR14532 DB2SYNC APP SHOWS 100% COMPLETE BUT BAR IS AT 85% List of APARs that went into WR21178f APAR No. Abstract -------- ------------------------------------------------------- IC26754 IBM JDBC DRIVER CAUSES EXCEPTION IN MS J++ GARBAGE COLLECTOR. IY08857 SPECIFIC INTRA PARALLEL QUERY NOT TAKING ADVANTAGE OF HI2KEY/LO2 KEY WITH MGJN IY09146 FIX FOR PERFORMANCE PROBLEM CAUSED BY JR13499 IY09422 MANUALLY UPDATING COLVALUE COLUMN IN SYSSTAT.COLDIST TABLE WITH A DATE VALUE DISPLAYS THE UPDATED VALUE WITHOUT SINGLE QUOTES. IY09592 DB2 SENDS WRONG SIZES FOR DATA PARTITIONS TO BACKUP TO ADSM CLIE NT. IY09664 INCORRECT DATABASE SEED IN EEE ENVIRONMENT AFTER ADDING ADDITIONAL NODES SUCH THAT EVENT MONITOR FAILS ON NEW NODES. JR14385 EXECDIRECT ON KEYSET CURSOR DOES NOT QUALIFY SYSTABLE/SYCOLUMNS TABLES ON SELECT FOR TABLE INFORMATION. JR14399 CONTAINER LISTS NOT REFRESHED DURING NODE CHANGES IN THE CONTROL CENTER. JR14420 CUSTOM DPREPL.DFT SETTINGS FOR CONTROL CENTER NOT PICKED UP. JR14506 JAVA MULTIPLE SESSION PROBLEM WITH THE .APP. DRIVER. List of APARs that went into WR21178e APAR No. Abstract -------- ------------------------------------------------------- IY06432 RUNSTATS WITH DISTRIBUTION CAUSES INCORRECT FILTER FACTOR WHEN GENERATING ACCESS PLAN. IY07870 SQL1035N RETURNED WHILE DB IS IN ONLINE BACKUP AND SAME USER TRIES TO CONNECT TO IT IY08714 LOAD WITH REPLACE OPTION GIVES BAD PAGE ERROR IN DART OUTPUT IY09051 RESTORE DB FROM ADSM THROUGH CONTROL CENTER IN DB2 V6 IS FAILING WITH ERROR CODE SQL2542N. IY09342 SQL1042N TRYING TO CONNECT TO DB AFTER EVENT MONITOR PIPE READER IS GONE. IY09345 STORED PROCEDURE DOES NOT WORK WITHOUT QUALIFIER IY09402 DB2 REBIND TOOL DOES NOT UPDATE THE RDS_LEVEL COLUMN IN THE SYSIBM.SYSPLAN SYSTEM TABLE. IY09469 SELECTING TABLES FROM OS/390 WHICH CONTAIN LOBS CAUSES SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT. IY09505 INCORRECT COMPILE INSTRUCTIONS IN DB2UEXT2.CADSM FOR ADSM 3.1.6 OR HIGHER. IY09507 SQL1478 AFTER CREATE/ALTER/DROP BUFFERPOOL WHERE THE TOTAL CHANGE IS >=2GIG. THIS RESULTS IN AN INCONSISTENT SQLBP FILE. IY09605 SQL0199N ON SQLSTATISTICS AGAINST MVS WITH CURSORHOLD=0 JR14327 FIXPAK INSTALLS OF JDBC 1.1 AND 1.2 FILE MAY CAUSE FILES TO BE OVERWRITTEN JR14384 CONNECT HANGS WHEN CBIT ERROR IS ENCOUNTERED DURING CRASH RECOVERY. JR14462 DB2BATCH PROBLEM AFTER APPLYING FP12 JR14476 WORKAROUND FOR DB2 UDB TO IGNORE THE VERSION OPTION SPECIFIED AT BIND TIME WHEN USING DPROPR List of APARs that went into WR21178d APAR No. Abstract -------- ---------------------------------------------------------- IY07076 TRAPS IN SQLRISR2 SQLSFETC SQLRISRT SQLRIRST EXECUTING SQL IY08600 DATALINKS PARAM CHANGES TO N IN MIGRATIONS FROM V5 TO V6 IY08767 TIMING ISSUE IN BSU WHEN TRYING TO RETURN A DARI TO THE POOL IY09191 IMPROVE DB2DIAG.LOG MESSAGES FOR RFWD TO PIT ERRORS IY09202 SIGV IN SQLO_INIT_MULTI_THREADING IY09213 JDBC NET DRIVER PERFORMANCE. RESULTSET.CLOSE() FROM JDBC CLIENT SENDS REQUEST TO THE DB2JD SERVER AND EXPECTS NO RESPONSE. IY09223 ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER PREPARE IY09267 WHEN RUNNING RUNSTATS GETTING SQL2314W IY09275 LICENSE USE MANAGER LUM LOOPS CHECKING /DEV/HIL ON HP UX WHILE VALIDATING THE LICENCE FOR DB2 CONNECT. IY09298 DB2COUNTRY VARIABLE DEFAULTS TO A VALUE OF 0 INSTEAD OF 1 IY09314 V6.1 DB2EXPLN -L DOES NOT RESPECT PACKAGE NAME CASE IY09367 DB2 UDB - ONLINE/OFFLINE BACKUP TO MULTIPLE DISKS HANGS. NOTE: THIS IS A EXTENSION TO THE FIX FOR APAR IY04310. JR14355 INVALID MEMORY ACCESS - C0000005 TRAP IN SQLRIVAL (TRAP FILE SHOWS SQLRICONSEC ) RUNNING QUERY WITH PARALLELISM JR14415 TRAP - MTS AND STORED PROCEDURES WHICH RETURN RESULT SETS JR14416 OS/2: AUTHENTICATON SERVER FAILS IF SECURITY IS SAME JR14434 FORCE APP ALL TRAPS TYPE 2 CONNECT APP IN OTHER WINDOW WHICH HAD INVOKED DOSSLEEP JR14474 JDBC MULTIPLE SESSION PROBLEM: CLI0601 ERRORS. JR14475 (JDBC/CLI) COMMA DECIMAL SEPARATOR NOT WORKING IN NLS. JR14479 THE CONTROL CENTRE (AND INFORMATION CENTRE) DO NOT START BECAUSE DB2JAVIT.EXE FAILS IF REGISTRY INDICATES JDK 1.2 IS INSTALLED. JR14484 SQL30083 RC=1 WHEN PASSWORD IS CHANGED FROM A CLIENT List of APARs that went into WR21178c APAR No. Abstract -------- ------------------------------------------------------- IY06649 DB2CART DUMPS HUGE AMTS OF DIA3605C & DIA3855CINTO DB2DIAG.LOG IY07739 OPTIMIZER PREDICATE PROBLEM ON EEE WITH QUERY WRITTEN WITH UNION ALL IY08948 REORGCHK AT DIAGLEVEL 4 GENERATES -501 IN DB2DIAG.LOG FILE. IY09006 DB2IMIGR FAILS WITH SEGMENTATION VIOLATION, RC=139 SPECIFICALLY WITHIN DB2IMNOD. IY09149 JDBC NET DRIVER RETURNS -99 ON EXECUTEUPDATE AGAINST DB2 MVS IY09292 RESTORE USING CONTROL CENTER INCORRECT. JR14263 WRONG WEEK NUMBER RETURNED FROM WEEK FUNCTION JR14408 SQL0984C WITH 'INCORRECT USE OF THE SAVEPOINT' MSG IN DB2DIAG. JR14438 ARRAY INSERT INTERMITTANT FAILURE IF CBCOLDEF=0 SQLBINDPARAMETER JR14450 CLI0100E ERROR WHEN SETTING A DECIMAL COLUMN TO NULL List of APARs that went into WR21178b APAR No. Abstract -------- ------------------------------------------------------- IX87885 TWO PHASE COMMIT. CLIENT CALLS A STORED PROCEDURE AND THEN COMMITS IS NOT PERFORMED. IX88428 USING ADSM CONFIGURATION PARAMETERS IN DB CFG CAUSE A NULL TO BE ASSIGNED AS THE BACKUP IMAGE OWNER. IY08086 DATABASE MARKED BAD DURING RESTART DUE TO INCORRECT HANDLING OF A RETURN CODE 1 FROM SQLBFLSH IN SQLPUPDATEMINBUFFLSN IY08125 SQLTABLES() CALL IS NOT RETURNING INOPERATIVE VIEWS FROM A UDB DATABASE. IY08729 PATCH1=131072 CAUSES CONTROL CENTER HANG IN STATEMENT HISTORY IY08867 DB2CKMIG_EXE FAILS ON HP-UX 11 MACHINE 859 IY08893 SQL2306N AT LOAD WITH DBCS TABLE NAME IY08920 CC V6.1 PERFORMANCE MONITOR - START MONITOR OPTION FOR SPECIFIC DATABASE APPEARS TO HANG - NO MONITORS LISTED IY09068 EVENT ANALYSER INFORMATION FROM AIX WILL NOT DISPLAY ON NT JR14049 SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG JR14067 V6.1/NT THIN CLIENT INSTALL PROBLEM B/C MISSING LDAP KEYWORD JR14148 ALWAYS TREAT '_' AS A CHARACTER WHEN IN CALL STMT-ST.PROC NAME JR14239 DURING ROLLFORWARD RECOVERY, WE SEE ERROR MESSAGES IN THE DB2DIA G.LOG STATING 'CANNOT STEAL SPACE FROM OTHER BUFFER POOLS.' JR14279 SQLEXTENDEDFETCH RETURNS SUCCESSWITHINFO IF A FETCH OF ONE ROW FAILS DUE TO TIMEOUT OR DEADLOCK. RETURN SHOULD BE SQLERROR. JR14400 CREATE NEW PRECOMPILER SERVICE FUNCTION TO ACCEPT DIFFERENT DB V ERSIONS AND SELECT PRECOMPILER BEHAVIOUR ACCORDINGLY. JR14404 SQLCOLATTRIBUTE RETURNS INCORRECT INFORMATION JR14409 TRAP FILE SHOWS TRAP IN SQLISETKEYANDKEYDATA (IN SQLIUNDO.C). HOWEVER, ACTUAL TRAP IS IN WRITELOG. JR14412 ACCESS 2000 FAILING WITH VARCHARS > 210 CHARACTERS JR14418 JDBC 2.0 APP DRIVER SEGMENTATION FAULT WHEN EXECUTING QUERY. JR14435 CLI0165E CALLING STORED PROCEDURE WITH ASYNC ON AND BLOB COLUMN JR14436 SQLUVTUN DOES NOT INIT TIMESTAMP IS MEDIA LIST IS NULL List of APARs that went into WR21178a APAR No. Abstract -------- ------------------------------------------------------- IC26217 CLI0109E 'STRING DATA RIGHT TRUNCATION' ERROR OCCURS WHEN TRYING TO INSERT BINARY DATA IX87387 SELECT W/ OPTIMIZE FOR N ROWS AND FOR FETCH ONLY GOING AGAINST MVS RESULTS IN AN ADDITIONAL FOR FETCH ONLY BEING ADDED. IY02962 DEFUNCT CHILD PROCESSES ON SOLARIS WITH JDBC NET DRIVER IY03632 RECONCILE DLREPORT NEEDS TO BE TERMINATED WITH / IY05131 CLI0165E WHEN USING SQLEXTENDEDFETCH WITH ASYNC MODE ON IY05292 DBA2065 TRYING TO RUN OR SCHEDULE SCRIPT FROM SCRIPT CENTER. IY05325 TRAP IN SQLE_MRSPSENDDARISTART WHEN CALLING STORED PROCEDURE THROUGTH DB2 CONNECT IY06100 DATABASE COMES DOWN, SEE MESSAGE IN DB2DIAG.LOG STATING THAT FLUSH NOT ALLOWED ON ESTORE. IY06691 SQL4970 ON ROLLFORWARD TO END OF LOGS - 'UNEXPECTED FILECOUNT' IY06767 PERL FOR DB2 DISPLAYS VARGRAPHIC NULL STRINGS INCORRECTLY IY07550 SQL1042N DURING A ROLLFORWARD OF A V5.X DATABASE THAT HAS BEEN MIGRATED FROM V2.X DATABASE. IY07598 LOAD WITH MULTIPLE INDICES AND ESTORE ENABLED TRAPS THE LOAD PROCESS DB2LRID. IY07604 SQLJ SQL0309 IF HOSTVARIABLE VALUE IS NULL ON UPDATE IY07711 DB2CCLST LEAVES DEFUNCT PROCESSES ON UNIX PLATFORMS WITH MULTIPLE LOGICAL NODES. IY07809 AIX LOGIN LOGS NOT UPDATED WHEN CONNECT T