******************************************************************** 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 TO DB WITH WRONG PASSWD AFTER USER ACCOUNT IS LOCKED. IY07865 EVENT MONITOR STATE NOT UPDATED CORRECTLY. FIX FOR V6. IY07880 -902 IN SQLRRSTA DURING RUNSTATS INDICATING A MEMORY HEAP ERROR. IY07884 JDBC APPLICTION WAS CRASHING DUE TO NULL MEMORY BEING FREED BY THE CLI LAYER IY07951 JAVA UDFS WITH DECIMAL PARAMETERS PERFOMANCE DEGRADS IY07968 HANG / DEADLOCK ON PARALLEL-ENABLED QUERY IY08008 DLFM SHUT DOWN WHEN YOU FORCE THE COPY DAEMON'S ADSM SESSION TO TERMINATE OR RECYCLE THEIR ADSM SERVER. IY08060 SQL0901N REASON 'SQLNO_NUM_CHARS_SPECIFIED 200 :RC( 0)') WHEN DB2CODEPAGE=1208 IY08066 SNAPSHOT FOR DB SHOWS WRONG O/P FOR AGENTSIN V5,V6 & V7 IY08086 DATABASE MARKED BAD DURING RESTART DUE TO INCORRECT HANDLING OF A RETURN CODE 1 FROM SQLBFLSH IN SQLPUPDATEMINBUFFLSN IY08106 V5.2 TO V6.1 MIGRATION FAILS ON A -456 SQLCODE IF MIGRATION IS RUN MORE THAN ONCE AFTER A MIGRATION FAILURE IY08124 INSERTS ARE MISSED BY CAPTURE IY08204 NON CONSTANT 'PULLUP' IN THE OPTIMIZER CAUSING QUERY PERFORMANCE PROBLEMS. IY08219 FAILURE ON DATABASE INITIALIZATION CAN LEAVE ORPHANED PREFETCHERS WRITING SQLOCSEMP MESSAGES TO DB2DIAG.LOG IN LOOP IY08304 BP PAGESIZE WRONG WHEN CREATED ON NODE USING ALTER BUFFERPOOL IY08307 SQL2306 WHEN LOADING AS DBADM WITHOUT DISCONNECTING PREVIOUS CONNECTION OF ANOTHER USER IY08318 CLI RETURNS DRIVER NOT CAPABLE FOR LONG VARCHAR TO AS/400 IY08320 REBINDING OLD (V1.X) BIND FILES YIELDS SQL0436 WHEN APP. IS RUN IY08349 IF ONLY UOW MONITOR TURNED ON, UOW INFORMATION NOT COLLECTED. IY08365 DB2JSTRT DOES NOT MAKE USE OF THE VARIABLE DB2_PORT_NUMBER IY08557 SQL30081 ON THE CONNECTION WHEN DB2 CONNECT V6.1 AND IDLE THREADS ARE CANCELLED ON OS/390 SIDE. IY08569 ROLLFORWARD OF DATABASE CAUSES CORRUPTION OF LOB DATA IY08573 RUNNING 'GET SNAPSHOT FOR ALL' MULTIPLE TIME MAY CRASH DB2 IY08581 INTERRUPTED REDISTRIBUTE INCORRECTLY RETURNS SQLCODE 0 - REDISTRIBUTE COMPLETED SUCCESSFULLY IY08584 MULTIPLE IN PREDICATE WITH OUTER JOIN CAUSES EXPLAIN ERROR IY08589 BIND FILE CREATION FOR CLI PRODUCES AN INCORRECT OPTIONS STRUCT IY08716 HASH JOIN MAY RESULT IN ENDLESS LOOP IY08717 TRAP IN SQLRG_ADD_CHK_CSTRNT_HCSD IY08722 MESSAGE ERROR -- SQLZ_VALUE MAP NOT INITIALIZED USING DB2EXPLN. IY08729 PATCH1=131072 CAUSES CONTROL CENTER HANG IN STATEMENT HISTORY JR13153 DB2 CONNECT GATEWAY TRAPS WHEN LARGE ARRAYS PASSED AS INPUT PARAMETERS. JR13682 CONTROL CENTER NOT ABLE TO LIST DCS APPLICATIONS FOR A REMOTE INSTANCE. DEFECT #124825 JR13887 ERRONEOUS 'FAILED TO COMMIT' MESSAGE DUMPED TO DB2DIAG.LOG LOAD INCORRECTLY HANDLES POSITIVE RETURN CODE FROM COMMIT JR14082 FIX 12-BYTE MEMORY LEAK FOR NON-BLOCKED CURSORS JR14222 CCA BIND OF CLI UTILITIES MISSES A PACKAGE AGAINST DB2/MVS 5.1 JR14237 DB2GOV FAILS WHEN DB2NODES.CFG HAS BLANK LINE AT THE END JR14255 NO RESULT SETS RETURNED (AND POSSIBLY AN INVALID ERROR MSG) WHEN ISSUING QUERY FROM V6.1 CLIENT THROUGH DB2 V.6.1 SERVER TO DJ JR14263 WRONG WEEK NUMBER RETURNED FROM WEEK FUNCTION JR14282 SQL30020, OR AN ABEND ON DB2 FOR OS/390 WHEN INVOKING A STORED PROCEDURE WITH OUTPUT PARMS LONGER THAN THE BLOCK SIZE (32K) JR14305 TAPE SUPPORT ROUTINES ON NT DO NOT WORK WITH MAGSTAR3590 JR14311 BIND OF V5 LESS THAN FP7 CLIENT PACKAGES TO V6 SERVER JR14312 DB2 COBOL PRECOMPILER TO GENERATE COPY 'SQLCA.CBL' INSTEAD OF COPY 'SQLCA.CBL' JR14314 PROVIDE PATCH VALUE TO WORKAROUND ADO ADUSECLIENT PROBLEM. JR14337 CANNOT LOAD DDCS.DLL ON OS/2 SQL1108 ON REMOTE CLIENT CONNECTION JR14339 HOST DB CATALOGGED USING CCA USING ENABLE ENCRYPTION WITH DCS AUTHENTICATION: CONNECTION FAILS WITH SQL1403N JR14346 LICENSING DOES NOT COUNT CONCURRENT REMOTE CONNECTIONS JR14371 THE FLAG FOR FOR BIT INDICATOR IS NOT BEING INITIALIZED PROPERLY JR14373 CIRCUMVENT CLI0109 ERROR: REDESCRIBE EVERY TIME WE GET CLI0109 ERROR. KEYWORD REDESCRIBEPARMONERROR: 1 -DEFAULT, 0 -DISABLE THI JR14383 RUNNING SCRIPTS IN SCRIPT CENTER SWITCHES OS/2 INTO LOGON MULTI MODE WHICH CAUSES RUNNING APPS (E.G., APPLY) TO WAIT FOR LOGON List of APARs that went into WR21178 APAR No. Abstract -------- ------------------------------------------------------- GG03649 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 GG03991 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE GG03993 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES GG03996 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. GG03999 CAPTURE CORE DUMPS AROUND PRINT_LSN() GG04000 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE GG04001 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE GG04003 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE GG04004 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR GG04005 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR GG04006 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 GG04007 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 GG04008 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. GG04011 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD GG04012 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. GG04013 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES GG04014 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD GG04015 CAPTURE CORE DUMPS AROUND PRINT_LSN() GG04016 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IC24824 CHECK IN DJRA.EXE FOR UDB V61 IY02571 SQL0433 DURING INSERT VALUES, LINEFEED CHANGED TO SPACE IY04962 USING VOLATILE FLAG DURING R/3 UPGRADE IY05590 DB2IUPDT IN FP11 RESETS DB2PROFILE 99/11/11 PTF PECHANGE IY05988 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027 IY06283 LATCH CONTENTION CAUSES HIGH SYSTEM CPU SPIKES WHEN MANY AGENTS ARE IN A TIGHT LOOP EXECUTING THE SAME DYNAMIC STATEMENT IY06891 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY06907 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027 IY07053 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. IY07069 CLI0002W DATA TRUNCATED WHEN FETCHING CLOB FROM DB2/390 V6 IY07092 CHANGE OPTIMIZER COSTING TO HANDLE NULLS IY07110 -901:SQLNO_SMP_CREATE_TQ IY07239 JAVA UDF EXCEPTION NOT IN DB2DIAG.LOG FOR MISSING CLASS IY07309 SQL3508 REASON 4 ON LOAD WITH DELETE PHASE OR LOAD RESTART WHEN TABLE ID > 32767 (APPEARS NEGATIVE IN SYSTEM CATALOGS). IY07523 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07527 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07528 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07556 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07558 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07559 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07560 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07566 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07567 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07568 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07572 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07573 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07590 CHANGES MADE TO SQLGETDATAINTERNAL CAUSED CODE TO TRAP IY07600 QUERY PERFORMANCE AGAINST >4 TABLES IS NEGATIVELY AFFECTED BY THE CONTENT/LENGTH OF THE LIKE PREDICATE STRING. IY07699 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07700 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07701 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07702 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07709 SQL1131N WHEN CALLING SQLJ STORED PROCEDURE EMBEDDED CLIENT IY07735 -433 SQLCODE ENCOUNTERED WHILE DOING A BUFFERED INSERT IY07744 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. IY07745 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY07747 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07748 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07749 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07750 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07751 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07753 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07755 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. IY07756 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027 IY07757 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY07759 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07760 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07761 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07796 CMDEAL WITH TYPE CM_DEALLOCATE_ABEND DOESN'T RETURN IY07808 RETROFIT NEW PACKAGE NAMING ALGORITHM INTO V6 FOR STORED PROCEDURE BUILDER IY07822 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. IY07823 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027 IY07824 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY07825 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07826 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07827 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07908 ROWCOUNT > 10000000 IN LOAD COMMAND CAUSES INSTANCE CRASH IY07922 THE IN PREDICATE IN THE QUERY IS NOT PUSHED DOWN DUE TO OJ IY08058 NO DROPPED TABLE RECORD IS CREATED WHEN DROPPING A TABLE IY08124 INSERTS ARE MISSED BY CAPTURE JR13508 32K MEMORY NOT FREED PROPERLY WHEN APPLICATION DISCONNECTS IN DRDA JR13682 CONTROL CENTER NOT ABLE TO LIST DCS APPLICATIONS FOR A REMOTE INSTANCE. DEFECT #124825 JR14011 PCS_AGNT ERRORS PREVENT WINNT SHUTDOWN (USING INTEGRATED SNA ON DB2) JR14089 DB2 ALLOWS TWO FOREIGN KEYS TO CO-EXIST ALTHOUGH THEY CONTRADICT EACH OTHER. JR14168 EVENT MONITOR ALWAYS ATTACHES TO THE SAME INSTANCE IF MULTIPLE INSTANCES EXIST ON THE SAME MACHINE. JR14184 MULTITHREADED FIXES NEED TO BE DONE TO DB2JD DUE TO VARIOUS PROB LEMS (EXAMPLE: DB2JD BECOMES UNAVAILABLE INTERMITTENTLY) JR14201 GATEWAY TRAPS AT DB2SYSCS.EXE. 'ERROR IN AGENT SERVICING APPICATION WITH COOR_NODE:XXXX' IN DB2DIAG.LOG. JR14210 CLIENT CONTROL CENTER CANNOT SEE OS/390 TABLES JR14219 CLI APP INSERTS INCORRECT CHAR VALUES. EEE/MPP/CODEPAGE. JR14229 SQJ0201E DURING SQLJ CUSTOMIZATION OF CALL STATEMENT JR14271 TRUNCATION OF SCRIPT EXECUTION RSULTS TAKES FIRST PORTION, INSTE AD OF THE LAST PART List of APARs that went into WR21173d APAR No. Abstract -------- ------------------------------------------------------- IY04139 SQL5153 NEEDED INSTEAD OF SQL30081 ON CLIENT WHEN NO FCM RQBLK IS AVAILABLE. SERVER ERROR SQL6043 IS FINE. IY04310 DB2 UDB - ONLINE/OFFLINE BACKUP TO SEVERAL DISKS HANGS. IY05535 QUERY TO DB2/MVS IS BEING TIMEDOUT EVEN IF NOT INTERRUPT ENABLED IY06431 ATTEMPTING TO CHANGE A FILE DMS CONTAINER TO A DEVICE DMS CONTAI NER IN THE REDIRECTED RESTORE FAILS IY06700 DB2_ENABLE_SINGLE_NIS_GROUP CAUSES DB2START TO HANG ON HP10 IY06746 DIA5000C A DRDA AS TOKEN 'RECOVERABLE' WAS DETECTED. THE DIAGNOSTIC DATA RETURNED IS (SRVDGN). DUMPS ARE CREATED. IY06791 DB2 UDB - SQL3021/SQL0204 ON IMPORT REPLACE TO A ALIAS NAME FOR A TABLE IN WHICH THE USER HAS CONTROL ACCESS TO. IY07068 LOGPATH WITHOUT NODENUM IS SET AFTER MOVING FROM V5 EE TO V6 EEE IY07098 SQL2550N RETURNS WRONG INFORMATION WITH SECOND NODE NUMBER IY07235 DB2DIAG.LOG AND TRAP FILE GROWS VERY LARGE AFTER SECOND INSERT UPON TABLESPACE FULL CONDITION. IY07311 HASH JOIN FAILS WITH MEMORY ALLOCATION ERROR. INITIALIZATION FAILS CAUSING SUBAGENTS TO FAIL DURING MEMORY ALLOCATION. IY07319 QUERY PATROLLER 'IWM START ALL' FAILS IY07376 LIBPATH NEEDS TO BE SET IN DB2 INSTANCE ON AIX OTHERWISE VARIOUS PROBLEMS CAN HAPPEN. 'NO SUITABLE DRIVER' FOR EXAMPLE. IY07453 TRAP IN SQLDFIXTCB DURING LOAD DUE TO INCORRECT RETURN CODE HANDLING IN SQLU_GET_TABLE_ID IY07474 LOCK WAIT START TIMESTAMP = 01-01-1970 05:30:00.000000 IY07659 -901 FROM SQLNO_FIND_LOCAL_EQ_PRED JR13497 SQLWARN FLAGS ARE NOT BEING RESET AFTER EXECUTE JR13651 SQL2029N, RC=28 ON RESTORE ISSUED FROM CLIENT WITH A DIFFERENT ALIAS THAN THE SERVER - USING SYTOS USEREXIT JR13964 CHECK FOR INVALID CHARS IN HOSTNAME BEFORE INSTALL JR14049 SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG JR14066 SQLEXECDIRECT RECEIVES 'SQL0005W OPTION VALUE CHANGED' WHEN USING KEYSET CURSORS, AND THEN NO DATA IS RETURNED. JR14112 CLI0118E WITH 'SELECT {FN UCASE(T1.COL1)} FROM TABLE1 T1' JR14116 -514 ON SQLEXECUTE() FOLLOWING COMMIT ON OPEN CURSORS ON HOST JR14167 CC: CAN ONLY CONFIGURE PARTITION 0 IN EEE ENVIRONMENT JR14169 ALTER TABLE ADD COLUMN ON A TABLE WITH CLUSTERING INDEXES CRASHES THE DATABASE JR14170 SQLA.DLL AND SQLA32.DLL WERE INCLUDED IN SDK PACKAGING INSTEAD OF IN CAE JR14171 PROBLEM WITH JOURNAL SCHEDULING. JR14174 SQL1403 WHEN CONNECTING TO DATABASE ON NT USING A USERID THAT IS THE SAME AS A DOMAIN NAME JR14194 SQL0007N WITH SQLJ WHEN CALL STATEMENT INCLUDES A HOST VARIABLE List of APARs that went into WR21173c APAR No. Abstract -------- ------------------------------------------------------- IY04173 DB2ADUTL DOES NOT GUARANTEE ORDER WHEN EXTRACTING LOGS FROM ADSM IF MULTIPLE COPIES OF THE LOGS EXIST. IY04401 SQL1042 AT RESTART DB AFTER CRASH AT ALTER BUFFERPOOL IY05732 CLI REPORTS THAT UDB DOES NOT SUPPORT INOPERATIVE VIEWS -IT DOES IY05814 DB2 FAILED TO CREATE DB WHEN SET LOCALE=ZH_TW.BIG5 ON SOLARIS. IY06066 PUTTING ASYNCENABLE BACK INTO CLI IY06126 QUERY THAT EXECUTES IN PE 1.2 FAILS WITH SQL0101 AT OPTIMIZAITON LEVELS < 7 AND STMTHEAP < 60000 IY06147 ADD SUPPORT FOR CHAINING THE CLOSE OF A CURSOR TO THE NEXT OPEN IY06164 WHEN AUTOCOMMIT IS ON AND SQLEXECDIRECT RETURNS A NEGATIVE SQLCODE, NO COMMIT IS SENT TO THE TARGET DATABASE. IY06178 STORED PROCEDURE BUILDER CAUSES TRAP (SIGNAL 4-NO STACK) WHEN INVOKED BY CLIENT TO NON-CATALOG NODE. IY06234 JDBC RETRIEVAL OF NON-US CLOB TRAPPING. IY06317 CONCURRENT LONG RUNNING QUERIES CAUSE CPU TO SPIKE FOR A PERIOD OF TIME PREVENTING NET.COMMERCE APPLICATIONS FROM PROCEEDING IY06343 AUTOLOADER MYS-FUNCTION IN MULTI-THREAD ENV IY06347 TCP LISTENER HANGS IN SQLEGETAGENT UNDER HIGH WORKLOADS IY06539 TIMING PROBLEM WITH LOAD IN INCREMENTAL INDEXING MODE. IY06717 DDL GENERATED BY DB2LOOK FOR UNIQUE INDEXES CAN BE IMPROVED. IY06750 DB2LOOK DOES NOT SUPPORT DATALINK DATA TYPE IY06806 DB2 CONNECT TRAPS IN SQLE_DB2RA_AS_DB_BLOCK_FETCH, WHEN CLIENTS CONNECT TO EE/EEE DATABASES THROUGH THE GATEWAY. IY06808 INCORRECT NODE NUMBER PICKED UP IF ISSUING A CONNECT FROM A NODE THAT IS NOT IN THE DB2NODES.CFG AND DB2NODE IS NOT SET. IY06824 INDEXES ARE NOT MIGRATED DURING UDB EEE MIGRATION FROM V5 TO V6. IY06843 APPLICATION CORE DUMPS WITH DB2 V6.1 WITH THE FOLLOWING ENTRIES IN DB2DIAG.LOG: DIA1518, DIA3826C FROM LOCK_MANAGER IN SQLPLHLD. IY06912 BACKUP FAILS AT THE END WHEN UPDATING DB2RHIST.ASC FILE (BACKUP HISTORY FILE). PREVIOUS FAILED LOAD OPERATION. IY06932 SQL0973 QUERY_HEAP AFTER REPEATED ERRORS WHEN USING DESCRIBE DA (CLI) IY07040 SQLDESCRIBEPARAM IS CALLED ON A CALLABLE STATEMENT EVEN WHEN DISABLED. IY07111 CLIENT CONTROL CENTER CONNECT CAUSES EEE SERVER INSTANCE TO TRAP. IY07120 INSTANCE CRASHES WITH SIG#11 ON EXECUTION OF SELECT STATEMENT WITH UNION CLAUSE . IY07209 'FETCH FIRST N ROWS ONLY' WAITS A WHILE AFTER N TH ROW DISPLAYED JR12938 COMMAND CENTER/NT TRAP AFTER ISSUED 'CONNECT TO 18 JR14025 SQL3181W WARNING GENERATED ON LOAD FOR A VALID IXF FILE JR14034 UDB INSTANCE CRASHES IN SORTING PROCESSING JR14059 PATCH2=18 FAILS SQL0804N WITH EMPTY STRING LITERAL TO HOST DB List of APARs that went into WR21163a APAR No. Abstract -------- ------------------------------------------------------- IX77854 SQL0901 DIAG FILE REPORTS ERROR IN BUFFER QUEUE SERVICES PROBE:30 SQLKQ_DETACH_BUFFER(). INTERNAL ERR 'LOST BUFFER' IX83660 SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS IX87116 DB2BATCH OPTION TO SPECIFY COLUMN DELIMITER IY03544 CREATE DATABASE ON LARGE NUMBER OF NODES MAY HANG IY03678 TRAP INDICATING SQLFXSYS_X AS FAILING FUNCTION. IY03698 ARRAY INSERT WITH NULL RECORDS: DATA MISSALIGNED IN COMM BUFFER IY03820 REMOVE DB2START CALL FROM DB2EXFMT IY04221 EXPLICIT CONNECT FAILS WITH SQL1403 ON AIX IY04339 TRAP IN LOAD WHEN TEMP SORT FILE > 2GB SQLU_SMGETFREEPG() IY04496 DB2LOOK UTILITY MISTAKES IN THE HELP TEXT WITH THE -H OPTION IY05069 CASE/SUBSTR FUNCTION FOR AST'S IY05294 DB2DARI PROCESS COUNTER NOT DECREMENTED IN CASE OF ABEND IY05347 V61 VIA JDBC RETURNS WRONG VALUEAT SECOND SELECT TIME FOR SAME ROW SAME COLUMN. COLUMN IS BIGINT OR SMALLINT TYPE IY05361 CHECK GATEWAY VERSION FOR SQLDESCRIBEPARAM TO DB2 5.1.2 MVS IY05416 USEREXIT,DB2UEXT2,NOT COPIED TO /ADM/ IN MIGRATION FROM V5 TO V6 IY05751 SQLBINDPARAMETER WITH IBSCALE CHANGING ONLY - DB2 SHOULD IGNORE THIS AND NOT 'RE-DESCRIBE' THE COLUMN. RESULT - CLI0109 ERROR. IY05826 REMOTE MONITORING DOES NOT WORK FROM A CLIENT AGAINST UDB 5.2/HP-UX SERVER. IY05892 CLP THROUGHPUT IMPROVEMENTS IY05913 DB2ATLD BOUNDARY CONDITION CRASH IF LINEFEED IS ON A MULTIPLE OF THE 32K DATA FILE IY05980 CTRL-C APPLICATION CAUSES TRAP IN SQLEIAGT_CB IY06032 DB2CKMIG MIGRATION TEST FAILS DUE TO BUG IN SCRIPT. USER ID IS APPENDED WITH GROUP NAME. IY06047 SQL0902C RC=100 WHEN SELECTING FROM EXCEPTION TABLE AFTER LOAD. IY06094 SQLJ: DB2PROFC COMMAND WITH PRECOMPILE OPTION QUALIFIER GIVES SQL0204N IY06127 SEGV IN SQLIUNDO AFTER UNDO IS INCORRECTLY INTERRUPTED. DB2 REST ART FAILS. IY06145 ASCII FUNCTION RETURNS INCORRECT OUTPUT IY06163 NON-SELECT STATEMENT ISSUED THROUGH CLI BRINGS DOWN DATABASE ON COMMIT IY06187 LOAD TRAPS (SQLBLOADGETEXTENT) IN ERROR PROCESSING.. IY06215 SQL0998 RETURNED TO CICS APPLICATIONS ISSUING STATIC ROLLBACKS, OR STATIC COMMITS. IY06323 TRANSACTION STILL HOLD LOCKS IN CRASH RECOVERY MESSAGES IN DIAG ARE EXTRANEOUS, AS THE LOCKS ARE ACTUALLY REMOVED. JR13611 ISSUING 'UPDATE DBM CFG USING FEDERATED YES' SHOULD RETURN AN ERROR IN UDB V6.1 AS THE DATAJOINER SUPPORT IS NOT INCLUDED JR13750 MULTIPLICATION OF DECIMAL CONSTANT GIVES INCORRECT RESULT JR13824 JAVA I/O EXCEPTION ON WRITE TO BLOB OBJECT FROM STORED PROC JR13880 RETURN THE ODBC SCALAR NUMERIC FUNCTIONS SUPPORTED BY DB2/MVS JR13909 DB2LOOK INSERTS COMMAS INTO DDL INSTEAD OF DECIMAL POINT FOR FLOATING POINT NUMBERS IN CERTAIN LOCALES/TERRITORIES JR13917 A CREATE DB SCRIPT FAILED WITH ERROR SQL1024 ON GERMAN M/C(NT+DB 2 V6.1) JR13949 DEFFERRED PREPARE RETURNS OPEN CURSOR FOR LARGE RESULT SETS. JR13974 FILTER FACTOR FOR ALWAYS-TRUE PREDICATE CAUSE SLOW QUERIES JR13976 DBA1613 WHEN RESTORING DB USING VENDOR DLL IN CC JR13977 DUPLICATE TABLESPACES RETURNED IN EEE ENVIRONMENT JR13990 COMMIT FAILS WITH -902 RC=29 (FATAL LOGIC ERROR) JR14019 ADD FOREIGN KEY DIALOG IN CC IS NOT POPULATING THE PRIMARY KEY BOX INITIALLY List of APARs that went into WR21163 APAR No. Abstract -------- ------------------------------------------------------- GG03953 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K GG03961 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K GG03971 GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED GG03972 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP GG03974 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS GG03977 GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED GG03978 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP GG03979 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS GG03980 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS GG03981 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS GG03982 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL GG03983 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL GG03984 FORWARD FIT V5 APPLY APARS GG03985 FORWARD FIT V5 APPLY APARS IC24358 CHECKIN DJRA.EXE INTO UDB V6.1 IC25192 DB2 UDB VERSION 6.1 ON LINIX - DB2START HANGS DUE TO A CHANGE MADE BY RED HAT TO THEIR DYNAMIC LINKER. IX88801 PARALLELISM NOT WORKING WITH ODBC APPS TO MVS 5.1.1 IY02032 TABLE ACCESSABLE AFTER ROLL FORWARD THROUGH AN NONRECOVABLE LOAD IY03608 DB MARKED BAD AND BROUGHT DOWN WHEN LOAD INTO TABLE WITH RI. IY03903 AFTER A TABLESPACE RESTORE, A 'ROLLFORARD QUERY STATUS' DOES NOT SHOW INFORMATION IN THE 'NEXT LOG TO BE READ' FIELD. IY04033 INCORRECTLY PARSING AUTOLOADER INPUT PARAMETERS. IY04311 LIBDB2.SO NEEDS TO BE A DEPENDENCY OF LIBDB2LICM.SO IY04410 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K IY04411 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K IY04412 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K IY04471 -902 FROM SQLRIGTQ IY04651 SQL2519N ON MIGRATION TO V6. ERROR '-902' WITH TOKENS 'FIXUP SYSTRIGGER: FETCH SYSTABLES (-27) DMS RC=FFFFF840' IY04909 SIGNAL #4 TRAP DURING BUILD PHASE OF LOAD IY04947 SQLCODE -433 RETURNED ON A BUFFERED INSERT IY04961 OPTIMIZE FOR 1 ROWS PERFORMS A TABLE SCAN INSTEAD OF INDEX SCAN IY05040 TRAP, SIGNAL #11, IN THE OPTIMIZER, SQLNO_CRULE_STARJN_AND(). IY05115 SELECT COLUMN LIST > 4005 AND ORDER BY CAUSES SQL1224. IY05176 DBM CRASHES DUE TO A SIGNAL #11 IN SQLVDECADDEC IY05192 SQLSTATISTICS() QUERY FAILING WITH CLI0165E ERROR IN ROW IY05198 DMBILIST FOR V6 IAV EXTENDERS REPORTS <8D>VERSION 5 IAV EXT.... IY05315 BAD ACCESS PLAN FOR WHERE IN (VAR1,VAR2....VARN) IY05359 SNAPSHOT FOR APPLICATION REPORTS SQL10007 IN THE STATEMENT TYPE FIELD IY05364 FORWARD FIT V5 APPLY APARS IY05406 JAVA INSERT USING SETSTRING TO DECIMAL COL TRUNCATES DECIMALS IY05426 SQL1034N FOLLOWED BY INTERRUPTING ROLLBACK OPERATION IY05438 MIGRATION SETS THE SOFT FILE SIZE TO A MAXIMUM FILE SIZE. IY05446 ADD PATCH VALUE TO RETURN TRUE ISO TIMESTAMP FORMAT FROM CLI IY05481 VALUE FOR THE REFERENCE TYPE COLUMN DOES NOT REQUIRE A CAST TO THE REFERENCE TYPE IN A TYPED TABLE IY05483 FIX FOR SPM ON SUN ULTRASPARC (SUN4U) ARCHITECTURE IY05553 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY05554 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY05555 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY05608 CLI_MEMFREE TRAPS IN CLI_DSTFREEINFO WHEN OUT OF MEMORY IY05612 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY05626 ORDER BY VARGRAPHIC(),VARGRAPHIC() DOES RETURN CORRECT RESULT SET ORDER IY05656 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05658 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05659 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05660 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05662 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05663 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05664 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05671 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05672 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05673 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05674 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05815 ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K IY05816 FORWARD FIT V5 APPLY APARS IY05817 FORWARD FIT V5 APPLY APARS IY05818 FORWARD FIT V5 APPLY APARS IY06097 SQLBINDPARAM CALL COREDUMPS AFTER SELECT IS DONE, THEN ARRAY INS ERT IS ATTEMPTED. JR13711 CLI0118E ON 'SELECT{FN CONCAT(SUBSTRING('ABC',1,2),'B')} FROM T1 JR13713 SQL0804N WHEN INPUT PARAM TO STORED PROC ON HOST IS NULL JR13757 DB2 IGNORES NULL INDICATOR ON OUT STORED PROC PARAMS JR13775 CREATION OF DMS TABLESPACE VIA CONTROL CENTER INCORRECTLY CALCULATES TOTAL NO. OF PAGES WHEN PAGESIZE NOT 4K. JR13840 SQLFREESTMT(SQL_CLOSE) TRAPS WITH KEYSET CURSOR AND LOB JR13862 DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT JR13879 DB2 CONNECT GATEWAY TRAPS WHEN USING DOWNFIX CLIENT DURING STORED PROCEDURE CALL TO DB2 MVS. JR13882 TRAP IN SQLNO_PROP_BEST_SORT_KEY RUNNING QUERY ON VIEW. JR13927 IMPLEMENT NEW BIDI LAYOUT TRANSFORMATION ROUTINE WITH MORE STRIN GENT ERROR CHECKING, MEMORY ALLOC, AND BIDI CCSID STRING TYPES. JR14004 NEW INSTALL OPTION TO PREVENT DB2PERF.DLL FROM BEING REGISTERED List of APARs that went into WR21136c APAR No. Abstract -------- ------------------------------------------------------- IY02571 SQL0433 DURING INSERT VALUES, LINEFEED CHANGED TO SPACE IY02572 LANG=JA_JP.IBM-932OR JA_JP.IBM-943SYMBOLIC LINKS NEEDED IY03379 DB2NODE ENVIRONMENT VARIABLE DOES NOT WORK FOR ALL COMMANDS IF PARTITION NUMBER SPECIFIED IS NOT ON THE SAME PHYSICAL NODE. IY03805 PROBLEMS WITH NIS AND GROUP LOOKUPS ON AIX 4.3.2 DEFECT #124182 IY04414 DARI PROCESS DOES NOT PICK UP GROUP ID FROM .FENCED FILE IY04769 NODEXXXX AND CATNXXXX NOT UPDATED CORRECTLY ON BACKUP IMAGES EXTRACTED FROM ADSM WITH DB2ADUTL IY04893 SETTING DB2_MMAP_READ PROBLEM COULD PREVENT FIRST CONNECT IY04917 SIZE IN SNAPSHOT HEADER INCORRECT IN MPP ENV IF ACTIVE STATEMENT IY05051 CATALOG CACHE MAY CAUSE LONG LOCKS TO BE HELD IN SYSTABLES IY05198 DMBILIST FOR V6 IAV EXTENDERS REPORTS VERSION 5 IAV EXT.... IY05483 4K MMAP ASSUMPTIONS BREAK SPM ON SOLARIS JR13217 SQLGETINFO(SQL_ORDER_BY_COLUMNS_IN_SELECT) REPORTS 'N' INSTEAD OF 'Y' FOR DB2/390 V5.1 JR13547 CLI0606 WHEN RETRIEVING DECIMAL DATA WITH GETDOUBLE CALL FROM NT FOR SPANISH JR13604 STORED PROCEDURE BUILDER WITH A SP WITH A DATE INPUT PARAM WILL BUILD OK BUT ON EXECUTE, IT WILL EXIT WITHOUT ANY ERRORS. JR13653 JDBC APPS AUTOCOMMIT IF STORE PROCEDURE CALL IS MADE. EXPLICIT ROLLBACK NOT POSSIBLE AFTER STP CALL. JR13684 SQL0901 IN FUNCTION SQLNO_SMP_CREATE_SHARED_SO JR13755 SQLEXECUTE TRAPPING WHEN KEYSET CURSORS USED JR13758 KEYSET CURSOR FAILS TO UPDATE WHEN NULL VALUES ARE IN THE RESULTSET. JR13783 PARMLIST SYNTAX ERROR ON STORED PROCEDURE CALL TO MVS JR13827 SQLSTATISTICS AND SQLDRIVER CONNECT TAKE LONGER TO COMPLETE IN DB2 V6.1 THAN IN DB2 V5.2 JR13858 CLI PERFORMANCE IMPROVEMENT WHEN AUTOCOMMIT ON List of APARs that went into WR21136b APAR No. Abstract -------- ------------------------------------------------------- IX87013 TEMPORARY FILES ARE CREATED USING BLOB WITH JAVA PROGRAMS IY02464 -901 INDICATING BANDP NOT PUSHED DOWN IY02862 OUT OF SPACE IN THE DLFM_BACKUP_DIR_NAME NOT DETECTED IY03133 SQL0901 'UNEXPECTED COLUMN USAGE TYPE' ON DELETE OPERATION ON TX ENABLED TABLE DUE TO TX TRIGGERS. IY03393 UNINITIALIZED MEMORY IN OPTIMIZER CAUSES SIGNAL #11 IN (SQLNO_CO PY_SETN,SQLNO_UNION_SETN) IY03630 RECONCILE SQL2554 DOES NOT GIVE DLFM SERVER NAME. IY03631 DB2_RECON_AIDPACKAGING IN EE IY03698 CLI ARRAY INSERT PROBLEM WHEN ALL FIELDS IN A RECORD ARE NULL IY03820 REMOVE DB2START CALL FROM DB2EXFMT IY03823 NIS: CONNECT ... CHANGE PASSWORD 'FAILS' WITH SQL1403N. WAIT TIME IS NECESSARY FOR PASSWORD TO REFRESH BY NIS SERVER. IY04240 CERTAIN QUERIES THAT RAN ON V5 RETURN SQL0101 - QUERY TOO COMPLEX ON V5.2. IY04279 WE DO NOT FETCH DATA PROPERLY FROM CHAR(255) COLUMN ON MVS - DATA GETS TRUNCATED AS WE EXPECT IT TO BE MAX 254 CHAR LONG IY04291 -901 IN SQLRI_CLOSE_UDF_EOT(), -1034 DBM CRAHES IY04399 TRAP, SIGNAL #11, IN THE DB MONITOR, I.E. DURING COLLECTION OF TABLESPACE COUNTERS. IY04409 SIG#11 IN SQLSFETC IY04431 MIXED EMBSQL/CLI APP CORE DUMPS ON SQLDISCONNECT IY04446 CLI0002W WITH CLOB DATA WITH GETSTRING IF SELECT OTHER TYPE 1ST. IY04502 DB2CLI.H HEADER INCORRECT FOR SUN IY04555 KEYSET CURSOR PARSING DOES NOT HANDLE <> CORRECTLY. IY04557 DB2CAT FAILS WITH SQL0811 WHILE DUMPING THE RI DESCRIPTOR IY04694 LARGE SELECT AGAINST DB2/MVS 5.1.2 RESULTS IN -502 IY04732 SQL0902 RC=126 AT DROP TEMP TABLESPACE IY04798 TRUSTAPP ON SEEMS TO BE GENERATING AN INVALID MEMORY ADDRESS JR13441 INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED JR13645 SQLCOLUMNS RETURNS INCORRECT INFORMATION FOR DEFAULT VALUE JR13700 DB2DARI GROWS FOR PARAMETER STYLE JAVA STORED PROCEDURE JR13708 CLI APP TRAPS WHEN CLI TRACE IS ON AND SQLFETCH RETURNS != SQL_SUCCESS JR13736 SQLDESCRIBEPARAM FAILS ON DEFERRED PREPARE OF >= 26 COLUMNS. JR13753 JDBC SETBYTES() MEMORY OVERWRITE IF INPUT VALUE LARGER THAN COLUMN WIDTH. JR13762 TRAP IN SQLEX_RDS_GEN_DATA. JR13782 DOSSLEEP(0) PREVENTED DB2 THREADS FROM DOING WORK WHEN HIGHER PRIORITY THREADS WERE RUNNING. List of APARs that went into WR21136a APAR No. Abstract -------- ------------------------------------------------------- IX89397 DB2 UNIX TRAPS ON CONNECT FROM EMB SQL IF DB2INSTANCE NOT SET IX89959 CACHE STORED PROCEDURE DESCRIBE INFORMATION IY00980 BACKUP FAILS WITH SQL1062 BECAUSE OF LINKS IN THE DB PATH IY01190 ROLLBACK OF CREATE TABLESPACE WITH > 1 CONTAINER NEVER UNTAGS CONTAINERS PAST THE FIRST ONE IY01210 DB2GOV MISSING DB2GOVD VALIDATE IF STARTING ON ONE NODE IY01489 LOG EXTENT 0 (S0000000.LOG) REQUESTED BY DB2 WHEN THE LOG SEQUENCE IS WELL PAST, IE. IN THE THOUSANDS. IY01841 RELEASE SHARE LOCKS ACQUIRED ON SYSTABLES DURING COMPLIATION OF SQL STATEMENTS IY02556 CC: JOURNAL REPORTS INCORRECT JOB STATUS IY02569 TRAP AT BEGINNING OF ONLINE BACKUP IN SQLUBCKA IY02618 DB2 CONNECT GATEWAY TRAPS IN SQLJMF10. IY02730 CLI DRIVER DOESN'T HANDLE LARGE STATEMENT SIZES CORRECTLY. IY03175 EXCESSIVE MESSAGES IN DB2DIAG.LOG IY03229 FENCED DB2DARI PROCESS LEAKS 4K OF MEMORY PER INVOCATION IY03447 SUN: ADD SUPPORT FOR GETGROUPSBYMEMBER CALL TO SPEED UP GROUP ENUMERATION - VERSION 6 ONLY IY03454 DB2 UDB - FIRST EXECUTION OF THE SIN UDF RESULTS IN SQL0443, RC 03. OTHER 'MATH' UDFS MAY ALSO EXPERIENCE THIS ERROR. IY03510 RESTORE FAILS WITH AN SQL0298N WHEN THE SAME CONTAINERS EXIST IN THE SQLNNNNN DIRECTORY... CANNOT REDIRECT THE RESTORE. IY03529 RUNNING DB2EMPFA WHEN SMS TABLES GREATER THAN 4G EXIST CAN CORRUPT DATA. IY03602 SQL0980C BAD PAGE ENCOUNTED DURING LOAD RESTART IY03861 APAR USED TO CREATE PTF FOR DB2 V5.0 FOR AIX IY03885 EVENT MONITOR WITH AT NODE DOES NOT FILTER EXISTING CONN IY04046 JDBC TRAP IF APPLICATION USES INVALID CONNECTION HANDLE IY04157 SET CURRENT PACKAGESET PRODUCES A SIGSEGV FROM WITHIN SQLJ IY04168 APAR USED TO CREATE PTF FOR DB2 V6.1 FOR AIX IY04196 LOG FULL CONDITION WITH NODE LOG SYNC WILL CAUSE DB2 TO PANIC AN D CRASH. IY04225 INFINITE LOOP IN DB2GOVD DURING ERROR HANDLING IF DB2GOV LOG FILES ARE REMOVED. INFINITE ERRORS TO STDOUT. IY04242 LOG FULL CONDITION DID NOT SAVE ENOUGH LOGSPACE FOR A TRANSACTION TO BE ROLLED BACK. JR12656 ODBC SQLTABLEPRIVILEGES DOES NOT RETURN THE PUBLIC PRIVILAGES JR12796 SQLCOLUMNS() CALL WITH ONLY TABLE NAME DISREGARDS SCHEMALIST AND CURRENTSQLID JR12926 JAVA GETSCHEMA RETURNS NULL WHEN USING OPTIMIZED CATALOG JR13123 WHEN USING BLOB LOCATORS, SQLGETPOSITION FAILS WITH CLI0102E INVALID CONVERSION SQLSTATE=07006. JR13169 #DELETED GETS DISPLAYED IN MS ACCESS WHEN DISPLAYING A DB2 TABLE THAT HAS A PRIMARY KEY ON A DATE COLUMN OR DECIMAL COLUMN JR13334 TIMESTAMPDIFF ODBC FUNCTION DOES NOT GET NEGATIVE VALUES RETURNED WHEN CALLED IN DB2 CLI/ODBC. JR13427 CHANGING ISOLATION LEVEL AFTER EXECUTE CAUSES ERROR ON NEXT EXECUTE JR13475 RETRIEVING A CLOB SUB-STRING GREATER THAN 32KB TRAPS ON THE GATEWAY. JR13481 SQL_CURSOR_STATIC CURSORS NOT BEING CLOSED AFTER SQLCANCEL()/SQLFREESTMT(SQL_DROP) JR13499 RECOGNIZE '' ESCAPE CHARACTER IN SCHEMA QUALIFIERS JR13502 RESTORE OF A V5.2 (FP9/8) DATABASE IN V6.1 RETURNS AN SQL2548N ERROR MESSAGE - CODEPAGE OF BACKUP DOES NOT MATCH ONDISK CODEPG JR13545 DB2 UDB - SQLESRSP MARKS THE DATABASE AS BAD FOR ANY NON-ZERO RC FROM SQLRRAFI. SHOULD ONLY MARK DB BAD FOR CERTAIN NON-ZERO RC'S JR13610 ERROR LOGGED FOR SQLOFMBLK WHEN USING PREPARED STATEMENTS JR13630 SQLPLRL() TRAPS AS SQLRLGTS() NOT CLOSING CURSOR JR13633 TRAP IN MONITOR SNAPSHOT JR13661 SQL0605W WHEN CREATING TWO BI-DIRECTIONAL INDEXES WHICH USE THE SAME SET OF COLUMNS. JR13667 DB2JDBC.DLL TRAPS WHEN RUNNING WEBSPHERE IN VISUALAGE JAVA List of APARs that went into WR21136 APAR No. Abstract -------- ------------------------------------------------------- IX67422 SQL 913 RETURNED NO REASON CODE IX71710 RECLAIMED TOO MUCH LOG SPACE APPEARS DURING CRASH RECOVERY IX73726 V501: -407 SQLCODE CAUSES -984 WHICH MARKS DATABASE BAD IX76365 ENABLE FIX IN 83177 IX79991 CLI/ODBC ENHANCEMENT: REPLACING LITERAL WITH PARAMETER MARKER I IX79991 REMOVE EXTRA COMMITS (COMMIT ON RETURN MVS SP, CONNECT RESET) IX80640 DB2LOOK REVERSES DLL WHEN PK WAS CREATED ON EXISTING INDEX IX81341 12/98: DB2CKMIG FAILS DUE TO CODE PAGE CONVERSION IX81525 SQLALLOCSTMT TRAPS DURING MEMORY CLEANUP AFTER OUT OF MEMORY IX81764 DB2ATLD DOES NOT RETURN NON-ZERO RC EVEN IF IT FAILS IX81831 INDEX BUILD HANGS IX81849 SQLESETC API APPLIED TO WRONG CONTEXT IN MULTITHREADED CLI APP. IX82027 IMPORT CAN CAUSE HANGS UNLESS YOU DO A CONNECT RESET IX82054 SQL3326 USING DB2ATLD AND COLUMN NAME IS 18 CHARACTERS LONG IX82394 SQL6107 ON IX82397 DB2BATCH -O R 0 DOES NOT WORK WITH BLOB COLUMNS IX82487 SQL1042C ON BACKUP IX82508 PATCH2=6 DOES NOT PREVENT A SCROLLABLE CURSOR TYPE IX82599 DB2START MAY REMOVE MESSSAGE Q 0 IX82851 RESTART FAILS W/ -2777 FROM SQLPRESR IX82992 CLI SQLCOLUMNS() RETURNS A COUNT OF ZERO COLUMNS IX83002 NONRECOVERABLE LOAD CAUSES -1042 ON ROLLFORWARD IX83063 NEGATIVEARRAYSIZEEXCEPTION ON EXECUTEQUERY() UPDATE IX83068 DB2AUTOLD LOOPS WHEN LANG=JA_JP IX83104 V3: ESTORE PROBLEM WITH ATTACHED SEGMENTS IX83180 SQL0956C WHEN RUNNING DB2UIDDL OUTPUT. IX83197 DDB2ATLD MAY USE HOSTNAME FOR SOME COMMUNCATIONS IX83272 NEGATIVE RETURN CODE -502 CAUSES TRAP IN SQLJIFSR.C IX83408 SAP - FAILING BACKUP NOT RECORDED IN HISTORY FILE IX83441 ONLINE BACKUP PLACES IN LOCK ON TEMP TBS. IX83505 HP DB2SETUP FAILS TO CREATE INSTANCE - DBI1720E, ID/GROUP EXIST IX83539 CREATE TABLE FAILS WITH -902 WHEN OUT OF DBHEAP IX83547 LOCK WAIT - NS LOCK HELD ON SYSUSERAUTH CAUSES CATALOG LOCKING IX83555 XA_END FAILS WITH RC=XAER_PROTO WHEN XA_END(SUSPEND) IS INVOKED IX83583 LOAD INSERT AFTER MIGRATION CAUSES TABLE CORRUPTION IX83660 ONLINE BACKUP RETURNS SQL2048N DURING MKTABLES WORKLOAD. IX83662 SIGNAL#11 IN SQLKD_RCV_DATA IX83716 TRAP IN SQLRAGSN WHEN EXPLICIT BIND IS INTERRUPTED IX83733 DB21080 - REDIRECT RESTORE IS CASE SENSITIVE TO DB ALIAS IX83869 CATALOGING MORE THAN 8 ODBC DATASOURCES FROM SCRIPT GIVE ERROR IX83953 THE JDBC LISTENER SHOULD ONLY READ THE INDICATOR VARIABLE IF IX84081 12/98:TRAP IN SQE IX84082 JAVA STORED PROCEDURE CAN ONLY RUN ONCE ON SOLARIS 2.6 IX84273 THE DB2BATCH TOOL SHOULD TRIM THE TRAILING BLANKS IN OUTPUT IX84329 LENGTH OF THE OUTPUT SQLVAR IS NOT INITIALIZED. IX84478 TIMESTAMP TOSTRING() METHOD NOT WORKING PROPERLY IX84552 V5.2 CHOOSING MGJN PLAN OVER A NLJN THAT WAS CHOOSEN IN V500 IX84565 WARNING SQL0437W CAUSES EXPORT TO FAIL FOR COMPLEX QUERIES. IX84582 CLP LIST TABLESPACES SHOW DETAIL DOES NOT AUTO-COMMIT IX84780 DB2_ALL HANGS WHEN THERE IS INPUT REQUIRED BY USER IX84790 SQL10003C ERRORS DUE TO A MEMORY LEAK IX84896 A PRE 5.2 DB2JAVA.ZIP NET DRIVER CONNECTING TO A 5.2 DB2JD IX84950 REMOVE EXPLICIT CALLS TO SET CURSOR_HOLD AND AUTOCOMMIT AS THES IX85099 V5.2 GA CLIENTS TRAP WHEN MONITOR HEAP EXHAUSTS IX85148 -902 SQLCODE ON ROLLFORWARD TO POINT IN TIME - EEE IX85171 DB2 UDB V5.2 EE ON HP11 HAS POOR PERF. WHEN USEING LOAD UTILITY IX85192 SQL0902 RC 26 SQLO_NOMEM_UND IN SQLRIUIN IX85342 SIGNAL #11 IN SQLRA_FIND_SHIP_VAR IX85415 CHANGE E30_AIX_MAJOR.MAKE TO PICK UP LIBCPIC_R.A FROM AFS IX85415 LIBDCPIC_IBM.A NOT THREAD SAFE. IX85558 DB2 STILL GETS DATA EVEN IF SQL_ATTR_RETRIEVE_RESULT IS OFF IX85645 EXECUTEUPDATE RETURNING -1 FOR WHEN UPDATES IN THE JDBC NET DR. IX86007 SIGNAL#11 IN SQLULADDINXKEYS IX86031 'LIST HISTORY REORG SINCE' DOES NOT REPORT ALL VALID ENTRIES IX86221 DB2 5.2: RESTORE HANG IX86244 USE SQLOINSTANCEPATH() TO REDUCE CALLS TO PASSWORD FILE IX86368 SQLJMF10 TRAPS WHEN NULL POINTER IS IN DB2RA IX86413 SIG 11 TRAPS IN ERROR HANDLING AFTER SQLRXGET/PUT HIT PROBLEMS IX86439 AUTOLOADER COMPLETE, HOWEVER NOT ALL DATA IS LOADED. IX86457 DON'T IGNORE SIGUSR1 IN SNA/6000 V3 AND NEWER IX86498 FIX LATCH/UNLATCH OF AGENT_LIST_LATCH IN SQLEGETAGENTFROMPOOL IX86517 LOAD TRAPS IN BUILD PHASE WHEN UTIL HEAP IS FULL IX86733 DB2SETUP: INSTANCE CREATE FAILS ON AIX 4.3.2 IX86742 USERID CONTAINING "I" INCONSISTENTLY TRANSLATED WITHIN DB2 IX86861 SETNULL TRAPS WITH TIMESTAMP,TIME,DATE,BIGINT AND STREAMS IX86967 ADD SUPPORT FOR A STATICALLY BUILT DB2SYSC ON SOLARIS IX86970 NOT ENOUGH LOG SPACE RESERVED DURING REORG IX86991 EXPORT NOT PARSING MODIFIED BY DELIMITERS PROPERLY IX87048 INTERMITTENT SQL0290 IX87063 SOLARIS:SQL1072 - CAN'T GENERATE UNIQUE KEYS IF INODES ARE HIGH IX87124 BUFFER POOL ALLOCATION - SOLARIS 2.6 MEMORY MANAGEMENT CHANGES IX87172 SAP - POOR PERFORMANCE BECAUSE STAR JOIN IS NOT SELECTED IX87280 SAP - ROLLFORWARD FAILS (SQL1271W) WHILE REBALANCING IX87362 OUTER JOIN WITH IN PREDICATE RETURN WRONG RESULT IX87376 IMPROPER CLEANUP WHEN SQLAOPTIONS FAIL WITH INVALID PREP OPTION IX87446 UDF NOT MAKING FINAL CALL WHEN IT TERMINATES ABNORMALLY IX87450 FILE MANAGER EXPORT CONTROL FILE NOT BEING CREATED IN SOME CASE IX87463 MULTIPLE LOGON WINDOWS WITH ACCESS WITH NO UID/PWD INPUT IX87478 SQLUGRPI RETURNS SQLCODE=-6044 IX87540 INVALID ROW COUNT RETURNED ON UPDATE WITH STREAMS (LOB) IN JDBC IX87634 TRAP IN V5 CAE WHEN EXIT HANDLER IS CALLED IX87720 CLI SQL_CONNECT_NODE WILL NOT ACCEPT VALUE 0 IX87741 INCORRECT ROUND FUNCTION OUTPUT IX87839 EXCEEDING MAX APPLID SIZE OF 32 BYTES. IX87877 SIG#11 ON RESTART WHEN MONITOR SWITCHES ON IX87910 LOCKING BEHAVIOUR WITH CS AT BOUNDARY CONDITIONS INCORRECT IX87911 ERROR CODE 28 FROM SAMPLE USEREXIT WHEN LOG FILE DOES NOT EXIST IX88179 TYPECASTING TO DECIMAL IN UDFS RESULTS IN LOSS OF PRECISION IX88274 FIX HANG ON CRASH RECOVERY DUE TO LOCK-WAIT ON SYSTABLESPACES IX88408 SQP PROBLEM FROM CUSTOMTER AS IN PMR45929 IX88449 TEMP TCB NOT LOADED ON SCROLLABLE CURSOR APPLICATIONS IX88761 NEW FUNCTION IN DART TO SHOW OWNER OF A PHANTOM QUIESCE IX88927 DB2ADUTL EXTRACT -> CANNOT EXTRACT IMAGES > 2G IX88966 DESCRIBEPARM TRAPS IF PREPARE HAS A WARNING AND DEF.PREPARE OFF IX88968 POOLPGNUM TOO HIGH WHEN ADDING VALUES TO AN INDEX "DIA3509" IX88969 DB2JD CHILD PROCESSES ON SOLARIS IX89062 SQL0901 (REASON FLUSHBLOCKS: NO PART SMP) IX89209 FP9: ABILITY TO FIX TERRITORY FIELD FOR MIGRATED DBS V2 TO V5 IX89285 ALTER TABLESPACE ADD CONTAINER FAILS DUE TO REDIRECTED RESTORE IX89317 SAP - ACCESS PLAN CHANGED BY ADDING INDEXES WHICH ARE NOT USED IX89396 SIG#11 IN SQLRR_OPEN IX89405 SIGNAL#11 IN SQLRITTB IX89426 CALLING STORED PROCEDURE CAUSES GATEWAY TO TRAP. IX89535 HOT: SQL0433N ON RECURSIVE SQL IX89661 RESTORE COULD NOT FIND DB CFG FILE. IX89677 DROP INDEX CRASHES INSTANCE IX89691 TRAP IN SQLE_DB2RA_AS_DB_OPEN IX89840 RENAMING LOG FILES DURING DB DEACTIVATION CAUSES ABNORMAL DB CR IX89927 CONTAINER REMOVED DURING ROLLFORWARD THROUGH FAILED ADD CONTNR IX89960 DON'T SEND FETCH TO SERVER IS SQLCODE +100 (WITH HOLD CURSOR) IX89997 UNTYPED PARAMETER MARKERS CAST INCORRECTLY FOR IN CLAUSE IY00162 SEGV IN SQLRI_HSJNNEWTUPLE IY00229 TQ HANG IY00230 CLI0601 IF FREESTMT FAILS BECAUSE OF SQL30081 ON A COMMIT. IY00268 LOAD TRAPS DURING THE BUILD PHASE IN SQLU_SBPREFETCH IY00268 PREFETCHER PLSDIE PROTOCOL MAY CAUSE HANGING IY00444 IMS HEALTH HASH JOIN FIX, PRIVATE VIRTUAL MEMORY EXHAUSTED IY00480 ENSURE DB2AUDIT EXECUTABLE RETURNS 0 INSTEAD OF 6 WHEN SUCCESSF IY00674 DB2ATLD & HANGS IY00718 HASH JOIN PLAN MAY HANG IY00761 POTENTIAL NULL DEREFERENCE DURING DROP TABLE AND DB SHUTDOWN. IY00782 SQLOCSHR EINVAL IN DB2CART ; CRASH RECOVERY ENDED TOO EARLY IY00838 NIS: CONNECT ... CHANGE PASSWORD "FAILS" WITH SQL1403N IY00843 FAILED TO INITIALIZE THE WAIT/POST AREA ON NT IY00843 IMPROVE THE HANDSHAKE BETWEEN SQE AND MONITOR CODE WHICH COULD IY00882 SQL1614 RC 6 STARTING EVENT MONITOR - SEMAPHORE NOT REMOVED IY00971 SNAPSHOT DOESN'T SHOW LOCKS BEING HELD AT CATALOG NODE IY00976 RESTORE FAILS WITH SQL0973 - OUT OF LOCK LIST HEAP IY01157 NODE UNABLE TO RESTART AFTER FAILURE: POTENTIAL LOG CORRUPTION IY01281 08/99:ERRONEOUS -902 BEING REPORTED IN SQLRLFPR.C IY01282 SIGNAL #11 IN AGENT_STMT_START() IY01397 PERFORM INTERNAL OPERATION LOCAL TO CO-ORD IF POSSIBLE: EEE IY01401 WRONG INFO REPORTED BY APPLICATION SNAPSHOT IY01429 -901 IN SQLNO_SMP_RUNIN_COORD WITH INTRA_PARALLEL ON IY01525 DB2LOOK : NOT LOOGED INITIALLY IN V6 AND V6.2 IY01547 MULTIPLE 8133 MESSAGES IN DIAGLOG DURING CRASH RECOVERY IY01644 DB2 TRYING TO CLOSE CURSORS/FREE LOCKS ALREADY CLOSED/FREED. IY01726 -952 ON JAVA STORED PROCEDURE BECAUSE BDSCOUNTER NOT INCREMENTE IY01782 DB2ADUTL CORE DUMPS WHEN -1 PASSED FOR N ON COMMAND LINE IY01898 INTERNODE COMMUNICATION ERROR RESULTS IN DB CRASH IY01930 CALLING SQLUIHSH() FROM UNFENCED UDF HANGS ENGINE IY01933 SQL0901 REPORTED BY SQLRAFRS() IY02049 DB2LOOK CHANGES AUTHORIZATION FROM GROUP TO USER. IY02162 MIN BUFF LSN TOO HIGH, RESTART FAILS, SOME LOG RECS MISSED IY02408 DEADLATCH SITUATION ON INDEX REBUILD IY02708 DEAD LATCH ON CREATE TABLE WITH PRIMARY KEY IY02888 SQL1246N USING API SQLESETC JR11822 12/98 NT: LOAD FROM A ZIP DRIVE HANGS JR11966 DB2SYSC TRAPS ON SMP ASC LOAD JR12000 ACCESS VIOLATION EXCEPTION IN MULTITHREADED APPLICATION JR12221 OPTIMIZER PROBLEM WITH HOST VARIABLE FILTER FACTORS - RUNSTATS JR12258 -418 WHEN MS ACCESS USES BETWEEN ? AND ? TO MVS JR12333 12/98:TRAP IN V5 SERVER FROM DWNLVL CAE/DOS V1.2 CLIENT JR12353 RESTORE FROM MULTIPLE DISKETTES FAILS. UDB AND DB2 V2 JR12355 LOAD ASCII METHOD L WITH BLOB RETURNS SQL3408W FOR WRONG COLUMN JR12356 CACHING PROBLEMS ON NT JR12409 SQL_C_NUMERIC SUPPORT - PHASE I JR12409 SQL_C_NUMERIC SUPPORT PHASE II JR12410 DB2 UDB TRAPS ON WINNT WHEN QUERY SEMENTICS INCORRECT ORDER BY JR12414 IMPLEMENT VARIABLE TAPE BLOCK SIZE FOR INTEL PLATFORM JR12424 NULL INDICATOR NOT BEING RESET JR12444 OUTER JOIN ESCAPE CLAUSE JR12452 MEMORY LEAK IN DB2CONNECT USING CLI APPLICATION TO HOST JR12467 UNINSTALL DOES NOT REMOVE *.OUT FILES FROM DAS INSTANCE DIR. JR12498 SQLEXECUTE DOES NOT INSERT ALL COLUMNS PROPERLY JR12508 SQL1026N FOLLOWED BY SQL1032N WHEN MANY DB2STARTS ISSUED JR12509 CLI LAYER CANNOT ACCOMODATE DATE AND TIME FORMAT FOR USA JR12512 MEMORY ACCESS VIOLATION OR TRAP WITH MULTIPLE ENVIRONMENTS JR12546 NT RESTORE TRAP JR12555 SQL2032 REMOTE BACKUP TO ADSM VIA NT CLIENT SESSIONS >1 JR12563 HEX(DEGREE)=0X00 IN SYSPLAN AND -901 SQLRISIN DURING EXECUTION JR12582 DB2 UDB V5.2 TRAPS WHEN THERE IS A TYPO WITH A SCALAR SUBSELECT JR12594 V501:LOAD/IMPORT FROM ASC TO NOT NULL COLUMN IGNORES NULLINDCHR JR12595 VENDOR: ALWAYS RETURN CATALOG SEPERATOR TO BE '.'LIKE PATCH2=11 JR12611 DIA9999 MSG FOR SQLPGMRP SHOWS AFTER DB2 FAILS TO ARCHIVE LOG JR12613 DB2PDLOG: ADD CHECK FOR PAGELSN > FIRSTLSN+4K JR12618 SYS3175 ON OS/2 WHEN RUNNING A USER EXIT TO BACKUP JR12646 OS/2: SQL1038C ON DB2START WHEN USING A FAT FILESYSTEM. JR12669 SQLSTATE -1106 RECORDED IN DB2DIAG.LOG ON REMOTE IMPORT JR12673 INTERNAL TABLE FUNCTION TFNUMLINT AS A COMMON TABLE EXPRESSION JR12681 SUPPORT OPTIMIZE FOR N ROWS BY TURNING OFF PREFETCH JR12689 CONTROL MSG CAUSED BY CONVERSION FILES WITH DIAGLEVEL JR12702 DRDA AS OUTBOUND DB2RA DOES NOT WORK JR12713 FFFFF616 FROM SQLBTERMINATEAGENT IGNORED IN SQLETERMDBCONNECT JR12719 FILE_TRANSFER_CMD OF AUTOLOADER.CFG DOESN'T CALL A BATCH FILE. JR12721 IN PREDICATE WITH >284 ITEMS IN SELECT STATEMENT TRAPS ENGINE. JR12731 DDL FOR CREATE TABLE INCORRECT WITH DBNAME JR12732 V5.2:SQL0956 / SQL1478 AFTER ALTERING V5GA BUFFERPOOLS JR12734 CCA IMPORT FUNCTION ONLY PICKS UP ONE INSTANCE PER SYSTEM JR12745 SQLBINDPARAMETER() NOT HANDLING ZERO COLUMN SIZE CORRECTLY JR12748 SYMBOLS FOR GENERIC API NOT EXPORTED FOR UDB VERSION 5/5.2 JR12788 CURRENTSQLID CAUSES CONNECTION TO TRAP TO DB2 / MVS JR12797 NULL INDICATOR NOT BEING RESET FOR JDBC APPS W/ NET DRIVER JR12804 SETXXXSTREAMS BROKEN IN THE 5.2 NET DRIVER JR12809 MEMORY LEAK IN DB2JD.EXE ON NT (9084) JR12812 CCA TRUNCATES BIND MESSAGES WITH INVALID CHARACTERS JR12819 IMPORT OF CLIENT PROFILE GIVES CCA3002 JR12822 MULTIPLE SQL0502 ERRORS IN NT EVENT LOG JR12881 MEMORY CORRUPTION WHEN COPYING INTO CACHED DA. JR12885 WHEN ACCESSING A STORED PROCEDURE ON AN MVS, AND RETURNING A CO JR12894 RANDOMS TRAPS IN SQLRA_CACHE_DEL_VAR JR12915 JAVA CLIENT TRAPS IN DB2CLI.DLL RECEIVING RESULT SETS JR12918 TABLETYPE KEYWORD NOT WORKING FOR SYNONYM JR12919 BYTE REVERSING OF UNDERDBDIR NOT HAPPENING ON NT JR12948 APPLETSECURITYEXCEPTION WITH APP DRIVER AND TRUSTED APPLETS JR12958 PRECOMPILER GENERATES DIFFERENT SQL TYPE FOR CHAR HOST VARIABLE JR12989 SQLESTAT INCORERCT FUNCTIONALITY JR12995 JAVA APPLET (JDK1.2) TRUNCATES RESULTS FROM SELECT OF CHAR COL. JR12996 TRAPS IN SQLJMFR1.C ON DB2 CONNECT V5.2 JR13006 OS2 SMP BACKUP TO USEREXIT TRAPS IN SQLEBUILDBDSUNIQUEID JR13009 RETURN ODBC ESCAPE CLAUSE FOR CALL STMT FROM SQLNATIVESQL JR13027 TCG FAIL TO PROPERLY SET NULL START/STOP KEY JR13043 OUT OF RESOURCE ERROR BACKING UP DATABASE OVER 192GB ON NT JR13056 TRAP IN SQLNO_COST_NLJN JR13076 MEMORY LEAK IN JVM WITH JAVA UDF JR13103 CONNECTION.GETAUTOCOMMIT() SHOULD RETURN FALSE FOR XA DRIVER WH JR13106 LOCAL DATE FORMAT (DD.MM.YY) FOR BRAZIL DOES NOT WORK. JR13114 DB2DEFPREP=YES NOT DISABLED FOR PREPARE WITH INTO CLAUSE JR13125 UDB/FP8+ JR13141 SQL01092N WHEN CATALOGING WITH DOMAIN USER ON WR09094 JR13152 VERSION INFORMATION NOT INCLUDED IN DLL HEADER JR13153 GATEWAY TRAPS IN SWITCH_DB2RA JR13156 PARAMETER MARKERS IN JDBC APP BOUND WITH WRONG SIZE JR13169 #DELETED IN MS ACCESS WHEN QUERYING TABLE IN DB2 JR13194 SET ACCOUNT STRING IN THE DB2CLI.INI FOR MVS JR13200 USING BOTH ODBC 2 AND ODBC 3 ENVIRONMENTS AT THE SAME TIME. JR13223 CALLING STORE PROCEDURE HANG OR TRAP JR13306 CLI/VB MEMORY INTIALIZATION PROBLEM CLI0112E ERROR IN ASSIGN JR13311 TRAP IN "SQLMON_DCS_STMT" ON DB2 CONNECT EE 5.2 JR13315 SQL30020 AFTER PASSING SQLDA TO HOST. JR13332 CHANGE PASSWORD FOR 8 CHAR USERID RETURNS INVALID USERID JR13354 SQL1404 (PASSWORD EXPIRED) IS IGNORED FROM A MVS WHEN USING ODB JR13363 CCA ADD DATABASE SMARTGUIDE CANNOT TRUNCATE COMMENT FIELD JR13402 NAMED SHARED EVENT SEMAPHORES NOT UNIQUE JR13405 APPL_NAME OPTION DOES NOT WORK WITH CREATE EVENT MONITOR JR13427 CHANGING THE ISOLATION LEVEL AFTER EXECUTE CAUSES ERROR ON NEXT JR13428 MEMORY LEAK WITH UDFS WHEN RETURNING BLOBS OF VARYING SIZE JR13432 TRAP IN DB2 JDBC DRIVER WHEN SETTING DATE PARAMATER TO NULL JR13433 MEMORY LEAK IN DRIVERMANAGER.GETCONNECTION JR13448 SMP:TRAP IN SQLOXULTEX CLEANING UP UNFENCED UDF RESOURCES JR13488 SQLCOLATTRIBUTES WITH SQL_DESC_BASE_TABLE_NAME WRONG