******************************************************************** Product Name : DB2 UDB for Windows 3.1 Version 5.2 PTF Number : WR21218 Package Date : 10/06/2000 Build Level : n000909 ******************************************************************** List of APARs that went into 21218 -------- ------------------------------------------------------- APAR No. Abstract -------- ------------------------------------------------------- GG03736 ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS GG03862 EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1 GG03928 SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY GG03960 APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL-551 ON THE CONTROL SERVER GG04099 ASNAPPLY FAILS WITH CORE GG04103 DURING CAPTURE PROCESSING THE ASNPATH SYSTEM VARIABLE IS BEING MISREAD GG04106 CANNOT STOP CAPTURE WITH ASNCMD STOP COMMAND GG04109 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS GG04111 DIAGNOSTIC ENHANCEMENTS FOR APPLY GG04129 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS IY09645 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038) IY10867 CASE SENSITIVITY OF BACKUP IMAGE PATH IY11081 DATABASE GETS MARKED AS BAD AFTER FCM ERRORS FFFFFC7F IN DB2DIAG.LOG FILE. EVENT MONITOR RESOURCE COULD NOT BE OBTAINED. IY11087 CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR IY11132 CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE IY11226 CAPTURE DOES NOT HANDLE LARGE TABLE ID IY11499 DB2 UDB - CRASH RECOVERY FAILS WITH AN SQL1042 ERROR. MESSAGES IN THE DB2DIAG.LOG WE FAILED WHEN TRYING TO DROP A BUFFERPOOL. IY12052 SEVERE PERFORMANCE DEGRADATION WITH HIGH SYSTEM CPU AND CONTEXT SWITCHES. OCCURS AFTER PREDICTABLE DATABASE UPTIME OF 4-16 DAYS IY12218 APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH IY12421 QUERY RETURNS INCORRECT RESULTS IY12450 SQL1224 INSTANCE CRASH ON V5.2 HP ONLY. PAGECLEANER IS TRYING TO DO AN AIOWRITE ABOVE 2GB - SQLBSERVENTRYPOINT FFFF D60C IY12536 MONITOR STATE DOES NOT RESET APPLICATION STATE ONCE COMPLETED IY12725 DB2 UDB - CREATE INDEX CAUSING DATABASE TO COME DOWN. THE DB2DIAG.LOG FILE INDICATES THAT AN OBJECT ID IS ALREADY IN USE. IY12821 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS IY13020 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED JR14749 SQL0291 TRYING TO ACCESS TEMPORARY TABLESPACE WHEN THERE ARE TEMP TABLEPSACES OF DIFFERENT PAGESIZES:'NO TEMP AVAILABLE' JR14931 EVENT ANALYZER (CONTROL CENTER) IS TOO SLOW LOADING AND SORTING EVENT FILES PQ38000 APPLY DOES NOT PROCESS CHANGE DATA PROPERLY PQ39542 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE PQ40301 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE PQ40392 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR List of APARs that went into 21193d APAR No. Abstract -------- -------------------------------------------------------- IY10156 IF DATABASE IN LINKED FILESYSTEM, AFTER UNCATALOGING AND THEN CATALOGING DB, LOCAL DB DIR. CHANGED AND DB CANNOT BE DROPPED. IY11436 DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY PROCESSING. IY11853 RETRO-FIT DEFECT 244475 INTO V5.2 FCM TRAP IY11882 AUTOLOADER USES DB2ATLD_PWFILE WHEN AUTHENTICATION IS NOT SET IY12295 SIGNAL 11 TRAPS IN MEMORY OPERATIONS (MEMHOLDSEG AND SQLOFMBLK) COMING FROM SQLNO_CLOSE_POOL JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR14795 DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442 JR14892 CHANGE WIN32 API CALL DUE TO LONG CONNECT DELAYS WHEN THERE ARE DISCONNECTED MAPPED NETWORK DRIVES: NT TERMINAL SERVER ONLY. JR14892 CHANGE WIN32 API CALL DUE TO LONG CONNECT DELAYS WHEN THERE ARE DISCONNECTED MAPPED NETWORK DRIVES: NT TERMINAL SERVER ONLY. List of APARs that went into 21193c APAR No. Abstract -------- ------------------------------------------------------- IY07604 SQLJ SQL0309 IF HOSTVARIABLE VALUE IS NULL ON UPDATE IY10484 LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973. IY10491 SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1 IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC IY10794 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY IY11030 SQL30083 RC 24 WHEN TRYING TO CHANGE A PASSWORD LOCALLY FROM THE DB2 CLP USING A VALID PASSWORD IY11097 NULL BUFFER FROM FCM PASSED TO SQLKQ_DETACH_BUFFER LEADING TO HANG ON SMP OR MPP MACHINES. IY11126 THE EVENT MONITOR'S TRANACTION EVENT OUTPUT HAS A LOCK WAIT TIME GREATER THAN THE ELAPSED TIME FROM THE START AND STOP TIMESTAMPS IY11136 NO TEMP AVAILABLE ERROR IN DB2DIAG.LOG DURING ON-LINE BACKUP. SQLB_BACKUP_IN_PROGRESS ON TEMPTABLESPACE FOR A SHORT PERIOD. IY11386 APAR IY06317 MAY RESULT IN POOR COST ESTIMATE OF MERGE JOIN IY11448 DB2IUPDT SILENTLY CALLS DLFMUPDT IY11527 DB2 UDB - SQL0901 ERROR WITH MESSAGE 'NON-PIPED PARALLEL SORT ATTEMPTED' IN DB2DIAG.LOG. IY11819 SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER. IY11842 SQLCODE -901 DURING TRIGGER USE WITH UDF IY11855 TRAP IN JNI (JAVA NATIVE INTERFACE) WHEN RUNNING A UDF REPEATEDLY. IY11901 TRAP IN SQLNO_PROJECT_QUN WHEN RUNNING A QUERY IY11940 INDEX CORRUPTION WHEREBY DART ANALYSIS REPORTS 'DUPLICATE FOUND' OR 'INDEX KEYS MISORDERED' OR 'BPS HEADER PAGE NUMBER INCORRECT' IY12016 SQL0901N ON DYNAMIC SQL 'SQLNO_CRULE_SAVE_PLANS 100:RC(0)' IY12126 TABLESPACES OF 18 CHAR LENGTH NAMES MIGHT NOT BE BACKED UP JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR14758 WITH SPECIFIC SETTINGS EVERY COMMAND ISSUED FROM COMMAND CENTER ON NT/UDB EE V5.2/FIXPACK 12 RECEIVES DB21005E ERROR. JR14815 DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED. JR14815 DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED. JR14854 NT: CONNECT HANGS RESULTING FROM LATCH ON GLOBAL INSTANCE QUEUE List of APARs that went into 21193b APAR No. Abstract -------- ------------------------------------------------------- IY11074 SQL0805N PACKAGE "NULLID.SQLC2B2F" WAS NOT FOUND. SQLSTATE=51002 IY10861 DATABASEMETADATA.GETCOLUMNS IS NOT HANDLING SCHEMAPATTERN='' CORRECTLY. JR14743 DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM. IY11063 AN APPLICATION HANGS (AN AGENT STUCK IN MONITOR CODE) IY11375 USEREXIT IS NOT BEING INVOKED JR14794 DB2 LIST TABLES COMMAND CAUSES TRAP IN DB2 V5.2 FOR OS/2 IY11161 FAILURE TO FIND A LOCK WITHIN LOCK TABLE, SQLPLUPDATETRANENTRY REPORTS FFFFF51D AT PROBE POINT 5 JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS IY10861 DATABASEMETADATA.GETCOLUMNS IS NOT HANDLING SCHEMAPATTERN='' CORRECTLY. List of APARs that went into 21193a APAR No. Abstract ------- ------------------------------------------------------- IY09385 SQL1042 DURING CRASH RECOVERY DUE TO INDEX MANAGER PROGRAMMING ERROR (DIA3875C). IY09499 RANDOM TRAP IN SQLE_DB2RA_AS_DB_OPEN IY09948 JAVA STORED PROCEDURES NOT FOUND OUTSIDE SQLLIBFUNCTION IY10029 QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204 IY10562 DB2 UDB INTRA_PARALLEL ON - QUERY RETURNS AN SQL0955 ERROR AFTER WHICH ALL QUERIES WHICH REQUIRE SHARED SORT MEMORY FAIL. IY10803 LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N. IY10839 PAGE BOUNDARY CACULATION ERROR CAUSES SQLOMMAPWRITE ERRNO EFBIG & SQL0968C FILE SYSTEM FULL IY10902 CREATE VIEW WITH SCHEMA NAME TOO LONG GIVES SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR. IY10955 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY11035 DROP TABLESPACE MAY FAIL WITH SQL0290N IF THERE IS RI CONSTRAIN EXITS IY11097 NULL BUFFER FROM FCM PASSED TO SQLKQ_DETACH_BUFFER LEADING TO HANG ON SMP OR MPP MACHINES. IY11116 DB2ATLD HANGS WHEN THE FILE_TRANSFER_CMDFAILS WITH A NON-ZERO R ETURN CODE. IY11129 MULTITHREAD JDBC APPL. CRASHED WHEN JVIEW IS USED. IY11129 MULTITHREAD JDBC APPL. CRASHED WHEN JVIEW IS USED. IY11162 SQL03181W ON LOAD WITH A SPECIFIC IXF FILE, BUT NOT ON IMPORT IY11182 SIGNAL 11 ON SQLULTERMINATE AFTRE SQL2043 DURING AUTOLOAD IY11283 ISSUING DB2IUPDT OVERWRITES THE DB2AUDIT.CFG WITH THE DEFAULT CONFIGURATION. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR14068 PCOMM ALLOWS '#' IN THE PARTNER LU NAME BUT DOES NOT ALLOW '#' I N THE SYM_DEST_NAME. JR14625 NT PERFORMANCE MONITOR NOT PROVIDEING DETAILS FOR THE SECOND AND FOLLOWING APPLICATIONS JR14648 DBA3037 ON VISUAL EXPLAIN WHEN DETAILED STATISTICS COLLECTED ON SOME BUT NOT ALL INDEXES FOR A GIVEN TABLE JR14723 SQL1112 -NOT ENOUGH SYSTEM RESOURCES WHEN TRYING TO SCHEDULE ~100 JOBS FROM THE SCRIPT CENTER JR14737 THE CLIENT IS INCORRECTLY CREATING MULTIPLE SNA CONVERSATIONS USING THE SAME LUWID. THIS IS CAUSING DB2 OS 390 TO ABEND. JR14759 LOAD OF DEL FILE WHEN BOTH' CAST(NULL AS CHAR) USED IN EXPORT' & MODIFIED BY USEDEFAULTS IN LOAD : DATE INSERTED IS WRONG List of APARs that went into 21193 APAR No. Abstract ------- ------------------------------------------------------- GG03727 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. GG04022 CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED GG04027 NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE GG04030 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION 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 GG04049 UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION GG04050 THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED 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. GG04059 CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN. 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 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 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 GG04075 CAPTURE HANGS/RETURNS SQL0204 WHEN "SCHEMA"."TABLE" HAS A SPACE GG04076 ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG GG04079 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS GG04080 APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO. GG04083 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH. GG04084 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH. GG04085 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS GG04086 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. GG04087 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. GG04088 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 GG04090 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 GG04091 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE GG04092 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE GG04093 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES GG04094 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES GG04095 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS GG04096 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS GG04097 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY GG04098 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY08453 SQL1227 RC 6 WHEN ATTEMPTING TO UPDATE STATISTICS WITH TABLE CARDINALITY OF 0 WHEN STATISTICS ALREADY EXIST IY08935 "ASNCMD STOP" DOES NOT STOP CAPTURE IY08938 "ASNCMD A STOP" IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE IY09076 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. IY09251 DB2 EEE V6 CRASH RECOVERY FAILS, SQL1042 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 IY09646 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE 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 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 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 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) 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. IY10151 MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED. IY10199 LEFT OR FULL OUTER JOIN PROBLEM WITH OPTIMIZER 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 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. 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 IY10223 "ASNCMD STOP" DOES NOT STOP CAPTURE IY10227 "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 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 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 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 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 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 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 IY10382 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES IY10474 CRASH RECOVERY FAILS BECAUSE OF INTERRUPT RECEIVED DURING UNDO IY10615 SQL10003 ERROR RETURNED TO USER APPLICATIONS, AND LOGGED IN THE DB2DIAG.LOG FILE. MEMORY LEAK IN BSU HEAP IY10644 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS IY10648 ROLLFORWARD FAILED WITH SQL4908N TABLESPACE LIST SPECIFIED FOR ROLLFORWARD RECOVERY ON DATABASE IS INVALID ON NODE(S) IY10769 EXPORT FROM A DB2 TABLE GIVE DEFAULT PERMISSION TO THE FILE OF 640. ON AIX, IT SHOULD BE 644. IY10869 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH. IY10870 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH. IY10871 CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH. IY10873 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS IY10874 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS IY10876 OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS IY10946 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. IY10948 SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL. IY10955 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY10955 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY11011 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 IY11013 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 IY11015 TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 IY11016 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE IY11018 UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE IY11019 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES IY11021 ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES IY11022 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS IY11024 SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS IY11025 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY IY11028 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR14541 TRAP IN SQLE_DB2RA_AS_DB_OPEN WHEN FORCING AN APPLICATION. OCCURS WITH PARALLEL QUERY USING CLI JR14606 EXPORT OF DEL MODIFIED BY DECPT SUBSTITUTES PERIOD FOR ANY CHARACTER FOR ITALIAN VERSION DB2 ON NT List of APARs that went into 21182e APAR No. Abstract -------- ------------------------------------------------------- IY03947 DB2DART WITH /DP OPTION ABORTS WHEN DB2_STRIPED_CONTAINERS IS USED. IY10668 MEMORY CORRUPTION CAUSED BY TQS--DIRTY PARTIAL TUPLE SAVED FLG JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR14545 SQL2034N (ADDRESS OF THE 'PASSWORD' PARAMETER NOT VALID) WHEN ATTEMPTING TO DO AN OFFLINE BACK FROM CLIENT CLP OR CC JR14589 TRAP IN SQLE_INTERRUPT_LOCALLY DURING FORCE APPLICATIONS ALL JR14592 CONNECT TO DATABASE ON NT HANGS IN STRICMP() C LIBRARY CALL JR14605 DIA3419C--NETBIOS NOT STARTED SUCCESSFULLY RC 3 List of APARs that went into 21182d APAR No. Abstract -------- ------------------------------------------------------- IY06572 SEGMENTATION FAULT WHEN BINDING A SECOND TIME TO A CURSOR IY09223 ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER PREPARE IY09420 INVOKING CLI ST. PROC AS 'CALL LIBRARYNAME!FUNCNAME()' (INSTEAD OF SCHEMA.PROCNAME) LEADS TO WRONG VALUE BEING FETCHED IN STPROC IY09663 DB2 CRASHED WITH ERROR DIA3816C CREATED BY SQM_EVMON_OSTREAM() SIG 11 IY09939 ERRNO IS NOT RESET BEFORE CLI TYPE CONVERSION IY10500 INVALID CONVERSION/TYPE FOR DOUBLE WITH STORED PROC IN DB2/MVS 6 IY10029 QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204 IY10432 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY JR14581 CONTROL CENTER TRAP ON V5.2 - EXCEPTION C0000005 IN DB2CC.EXE TRAP IS IN SQLEDTIN CALL - BROWSING DIRECTORY FOR BACKUP IY10390 TERMINATING ADSM SESSION BEFRO RE-ESTABLISHING IT. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS List of APARs that went into 21182c APAR No. Abstract -------- ------------------------------------------------------- IY10088 DIA3875C DELLEAF FAILURE USING INDEX CREATED ON PE V1.2 JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR14497 DB2 CONNECT TRAPS IN SQLJDRD1 ALONG WITH AN ACCESS VIOLATION DR. WATSON ERROR ON NT List of APARs that went into 21182b Defect No. APAR No. Abstract ---------- --------- ------------------------------------------------------- IY09751 DATABASE CRASH DUE TO TIMING HOLE IN CREATE TABLE ROLLBACK IY09764 TWO QUERIES DIFFERING ONLY IN THE ORDER OF THE PREDICATES, RETURN DIFFERENT RESULTS. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR14355 INVALID MEMORY ACCESS - C0000005 TRAP IN SQLRIVAL (TRAP FILE SHOWS SQLRICONSEC ) RUNNING QUERY WITH PARALLELISM JR14496 MIGRATION FROM V2.X TO V5.2 CAUSED PERFORMACE TO DEGRADE ON CONN ECTS DUE THE CHANGE IN LATCHING INTRODUCED IN V5.2 List of APARs that went into 21182a APAR No. Abstract -------- ------------------------------------------------------- IX87885 TWO PHASE COMMIT. CLIENT CALLS A STORED PROCEDURE AND THEN COMMITS IS NOT PERFORMED. IY04440 BUFFERED INSERT ON LOG FULL CONDITION PRODUCES INCONSISTENT RESULTS. IY06366 SELECT WITH LEFT OUTER JOIN ON A VIEW MAY HAVE SLOW PERFORMANCE WHEN IN CLAUSE IS NOT PUSHED DOWN INTO MOST INNER SELECT. IY06649 DB2CART DUMPS HUGE AMTS OF DIA3605C & DIA3855CINTO DB2DIAG.LOG IY07809 AIX LOGIN LOGS NOT UPDATED WHEN CONNECT TO DB WITH WRONG PASSWD AFTER USER ACCOUNT IS LOCKED. IY07870 SQL1035N RETURNED WHILE DB IS IN ONLINE BACKUP AND SAME USER TRIES TO CONNECT TO IT IY07880 -902 IN SQLRRSTA DURING RUNSTATS INDICATING A MEMORY HEAP ERROR. IY08060 SQL0901N REASON 'SQLNO_NUM_CHARS_SPECIFIED 200 :RC( 0)') WHEN DB2CODEPAGE=1208 IY08219 FAILURE ON DATABASE INITIALIZATION CAN LEAVE ORPHANED PREFETCHERS WRITING SQLOCSEMP MESSAGES TO DB2DIAG.LOG IN LOOP IY08318 CLI RETURNS DRIVER NOT CAPABLE FOR LONG VARCHAR TO AS/400 IY08714 LOAD WITH REPLACE OPTION GIVES BAD PAGE ERROR IN DART OUTPUT IY08857 SPECIFIC INTRA PARALLEL QUERY NOT TAKING ADVANTAGE OF HI2KEY/LO2 KEY WITH MGJN IY08948 REORGCHK AT DIAGLEVEL 4 GENERATES -501 IN DB2DIAG.LOG FILE. IY09149 JDBC NET DRIVER RETURNS -99 ON EXECUTEUPDATE AGAINST DB2 MVS IY09191 IMPROVE DB2DIAG.LOG MESSAGES FOR RFWD TO PIT ERRORS IY09202 SIGV IN SQLO_INIT_MULTI_THREADING IY09222 FFFF A602(INVALID MEMORY ADDR) IN DB2DIAG.LOG AND CLI0120E IN JDBC.LOG IY09267 WHEN RUNNING RUNSTATS GETTING SQL2314W IY09287 DB2 CRASHES AT FUNCTION SQLESRVR IY09342 SQL1042N TRYING TO CONNECT TO DB AFTER EVENT MONITOR PIPE READER IS GONE. IY09367 DB2 UDB - ONLINE/OFFLINE BACKUP TO MULTIPLE DISKS HANGS. NOTE: THIS IS A EXTENSION TO THE FIX FOR APAR IY04310. IY09422 MANUALLY UPDATING COLVALUE COLUMN IN SYSSTAT.COLDIST TABLE WITH A DATE VALUE DISPLAYS THE UPDATED VALUE WITHOUT SINGLE QUOTES. IY09439 SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR. IY09505 INCORRECT COMPILE INSTRUCTIONS IN DB2UEXT2.CADSM FOR ADSM 3.1.6 OR HIGHER. IY09605 SQL0199N ON SQLSTATISTICS AGAINST MVS WITH CURSORHOLD=0 IY09650 TRAP IN SQLKFFREEFCMRESOURCES IY09664 INCORRECT DATABASE SEED IN EEE ENVIRONMENT AFTER ADDING ADDITIONAL NODES SUCH THAT EVENT MONITOR FAILS ON NEW NODES. IY09756 NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS. REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED. IY09855 CLI ENTRY CODE TRAPS TRYING TO FREE A CONNECTION THAT NO LONGER EXISTS IY09908 ROLLFORWARD TO PIT RETURNS INCORRECT MINIMUM PIT JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR14049 SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG JR14148 ALWAYS TREAT '_' AS A CHARACTER WHEN IN CALL STMT-ST.PROC NAME JR14237 DB2GOV FAILS WHEN DB2NODES.CFG HAS BLANK LINE AT THE END JR14239 DURING ROLLFORWARD RECOVERY, WE SEE ERROR MESSAGES IN THE DB2DIA G.LOG STATING 'CANNOT STEAL SPACE FROM OTHER BUFFER POOLS.' 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. JR14409 TRAP FILE SHOWS TRAP IN SQLISETKEYANDKEYDATA (IN SQLIUNDO.C). HOWEVER, ACTUAL TRAP IS IN WRITELOG. JR14412 ACCESS 2000 FAILING WITH VARCHARS > 210 CHARACTERS JR14415 TRAP - MTS AND STORED PROCEDURES WHICH RETURN RESULT SETS JR14416 OS/2: AUTHENTICATON SERVER FAILS IF SECURITY IS SAME JR14418 JDBC 2.0 APP DRIVER SEGMENTATION FAULT WHEN EXECUTING QUERY. JR14433 PREPARED STAT GIVES NULL RESULTSET JR14434 FORCE APP ALL TRAPS TYPE 2 CONNECT APP IN OTHER WINDOW WHICH HAD INVOKED DOSSLEEP JR14435 CLI0165E CALLING STORED PROCEDURE WITH ASYNC ON AND BLOB COLUMN JR14436 SQLUVTUN DOES NOT INIT TIMESTAMP IS MEDIA LIST IS NULL JR14456 BINDING FROM A V5.2 CLIENT TO A V2 SERVER FAILS WITH SQL0206N ON DB2UIGSI.BND AS SYSIBM.SYSTABLES.ROWTYPENAME DOESN'T EXIST IN V2 JR14462 DB2BATCH THROWS AN ERROR AT THE END OF EXECUTION (DB2SYS.DLL) JR14474 JDBC MULTIPLE SESSION PROBLEM: CLI0601 ERRORS. JR14476 WORKAROUND FOR DB2 UDB TO IGNORE THE VERSION OPTION SPECIFIED AT BIND TIME WHEN USING DPROPR JR14478 SQL2032 IN APPLICATION WHEN POINTER CHECKING ENABLED (DB2CHKPTR= YES) JR14506 JAVA MULTIPLE SESSION PROBLEM WITH THE .APP. DRIVER. JR14507 DB2 CONNECT EE 6.1 CONNECTING TO DB2 UDB 5.2 OVER DRDA RESULTS IN INTERMITTED SQL30021N ERRORS. JR14526 SQL0301 WITH JDBC NET DRIVER ON INSERT/UPDATE OF MULTIPLE BLOB COLUMNS WITH NULL, NON-NULL COMBINATIONS. List of APARs that went into WR21182 APAR No. Abstract -------- ------------------------------------------------------- IY09490 QUERIES RESULTING IN LARGE DATASETS CRASHES DATABASE WITH UNEXPECTED EOF DUE TO TEMP TABLESPACE CONTAINER TRUNCATION (F609) IY03632 RECONCILE DLREPORT NEEDS TO BE TERMINATED WITH / JR13908 BETTER FILTER FACTOR FOR 'CONST = CONST' PREDICATES AND QRW NEEDS TO ELIMINATE OR(1=0) PREDICATES. IY06283 LATCH CONTENTION CAUSES HIGH SYSTEM CPU SPIKES WHEN MANY AGENTS ARE IN A TIGHT LOOP EXECUTING THE SAME DYNAMIC STATEMENT IY06649 DB2CART DUMPS HUGE AMTS OF DIA3605C & DIA3855CINTO DB2DIAG.LOG IY07951 JAVA UDFS WITH DECIMAL PARAMETERS PERFOMANCE DEGRADS IY07550 SQL1042N DURING A ROLLFORWARD OF A V5.X DATABASE THAT HAS BEEN MIGRATED FROM V2.X DATABASE. JR14312 DB2 COBOL PRECOMPILER TO GENERATE COPY 'SQLCA.CBL' INSTEAD OF COPY 'SQLCA.CBL' IY07884 JDBC APPLICTION WAS CRASHING DUE TO NULL MEMORY BEING FREED BY THE CLI LAYER IY07908 ROWCOUNT > 10000000 IN LOAD COMMAND CAUSES INSTANCE CRASH JR14279 SQLEXTENDEDFETCH RETURNS SUCCESSWITHINFO IF A FETCH OF ONE ROW FAILS DUE TO TIMEOUT OR DEADLOCK. RETURN SHOULD BE SQLERROR. IY08008 DLFM SHUT DOWN WHEN YOU FORCE THE COPY DAEMON'S ADSM SESSION TO TERMINATE OR RECYCLE THEIR ADSM SERVER. JR14263 WRONG WEEK NUMBER RETURNED FROM WEEK FUNCTION IY08125 SQLTABLES() CALL IS NOT RETURNING INOPERATIVE VIEWS FROM A UDB DATABASE. JR14337 CANNOT LOAD DDCS.DLL ON OS/2 SQL1108 ON REMOTE CLIENT CONNECTION JR14347 PATCH1=4096 DOES NOT WORK PROPERLY AGAINST MVS WHEN EARLY-CLOSE IS ENABLED IY08391 TRAP AT SQLBPFDESTROY AND PREFETCHER ERROR RC = -20444 IY09146 FIX FOR PERFORMANCE PROBLEM CAUSED BY JR13499 JR14356 SQL1331N RC=SQL_CPIC_SECURITY_NONE WHEN USING APPN TO HOST IN DB2 CONNECT EE 5.2 (FIXPAK12). IY08584 MULTIPLE IN PREDICATE WITH OUTER JOIN CAUSES EXPLAIN ERROR IY08569 ROLLFORWARD OF DATABASE CAUSES CORRUPTION OF LOB DATA 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 IY08716 HASH JOIN MAY RESULT IN ENDLESS LOOP IY08755 -901:BAD PLAN: UNRESOLVED QNC FOUND JR14401 DB2 UDB - LOAD FAILS WITH -1350: DB2DIAG.LOG FILE REPORTS -551 ERROR IN SQLR_TURNOFF_CONSTRAINTS IY07711 DB2CCLST LEAVES DEFUNCT PROCESSES ON UNIX PLATFORMS WITH MULTIPLE LOGICAL NODES. 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 IY08124 INSERTS ARE MISSED BY CAPTURE JR14383 RUNNING SCRIPTS IN SCRIPT CENTER SWITCHES OS/2 INTO LOGON MULTI MODE WHICH CAUSES RUNNING APPS (E.G., APPLY) TO WAIT FOR LOGON 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 JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS GG04000 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 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 GG04001 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE GG04002 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE 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 IY07523 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07556 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY05644 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR 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 IY07527 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07559 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07567 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR 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 IY07528 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07558 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07568 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR 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 GG04013 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES GG04012 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. 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. GG04023 LONG VARCHAR FIELDS CAN BECOME OVERLAID 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 GG03993 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES GG04019 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS GG03997 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD GG03999 CAPTURE CORE DUMPS AROUND PRINT_LSN() GG04020 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. GG04010 LONG VARCHAR FIELDS CAN BECOME OVERLAID GG04029 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE 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 GG04031 INSERTS ARE MISSED BY CAPTURE IY05988 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS IY06891 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY07053 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS IY07753 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07751 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07750 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY08076 LONG VARCHAR FIELDS CAN BECOME OVERLAID 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 IY08124 INSERTS ARE MISSED BY CAPTURE IY07744 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS. IY08007 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027 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 INSER IY08077 LONG VARCHAR FIELDS CAN BECOME OVERLAID 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 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. IY08085 LONG VARCHAR FIELDS CAN BECOME OVERLAID 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 IY08458 INSERTS ARE MISSED BY CAPTURE List of APARs that went into 21168e APAR No. Abstract -------- ------------------------------------------------------- JR14282 SQL30020, OR AN ABEND ON DB2 FOR OS/390 WHEN INVOKING A STORED PROCEDURE WITH OUTPUT PARMS LONGER THAN THE BLOCK SIZE (32K) 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 IY08223 ATTEMPT TO ALLOCATE ADDITIONAL LOGSPACE BEYOND CONFIGURED LOGS AS REQUIRED IN ORDER TO ALLOW CRASH RECOVERY TO COMPLETE IY08204 NON CONSTANT 'PULLUP' IN THE OPTIMIZER CAUSING QUERY PERFORMANCE PROBLEMS. IY08304 BP PAGESIZE WRONG WHEN CREATED ON NODE USING ALTER BUFFERPOOL IY8309 MEMORY LEAK IN UTILITY HEAP SIZE JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS List of APARs that went into 21168d APAR No. Abstract -------- ------------------------------------------------------- IY03602 SQL0980C BAD PAGE ENCOUNTED DURING LOAD RESTART JR14077 DB2/OS2: DB2SYSC.EXE TRAPS IN _UFREE (C RUNTIME) CALLED FROM _REGEN_EXCEPTION CALLED FROM SQLOADDENVSTRING JR14125 OS2 ONLY: TRAP IN GETENV() WHEN REFERENCING DAYNAME , MONTHNAME UDFS IY07986 DISCONNECT FROM THE DB SHARED MEMORY SET IY08024 DB2 UDB - PAGE CLEANERS MAY LOOP CAUSING PERFORMANCE DEGRADATION WHEN MULTIPLE BUFFERPOOLS ARE DEFINED. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS List of APARs that went into 21168c APAR No. Abstract -------- ------------------------------------------------------- IY04139 SQL5153 NEEDED INSTEAD OF SQL30081 ON CLIENT WHEN NO FCM RQBLK IS AVAILABLE. SERVER ERROR SQL6043 IS FINE. JR13887 ERRONEOUS 'FAILED TO COMMIT' MESSAGE DUMPED TO DB2DIAG.LOG LOAD INCORRECTLY HANDLES POSITIVE RETURN CODE FROM COMMIT IY06126 QUERY THAT EXECUTES IN PE 1.2 FAILS WITH SQL0101 AT OPTIMIZAITON LEVELS < 7 AND STMTHEAP < 60000 IY06432 RUNSTATS WITH DISTRIBUTION CAUSES INCORRECT FILTER FACTOR WHEN GENERATING ACCESS PLAN. 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. IY07076 TRAPS IN SQLRISR2 SQLSFETC SQLRISRT SQLRIRST EXECUTING SQL JR14112 CLI0118E WITH 'SELECT {FN UCASE(T1.COL1)} FROM TABLE1 T1' IY07110 -901:SQLNO_SMP_CREATE_TQ IY07311 HASH JOIN FAILS WITH MEMORY ALLOCATION ERROR. INITIALIZATION FAILS CAUSING SUBAGENTS TO FAIL DURING MEMORY ALLOCATION. IY07309 SQL3508 REASON 4 ON LOAD WITH DELETE PHASE OR LOAD RESTART WHEN TABLE ID > 32767 (APPEARS NEGATIVE IN SYSTEM CATALOGS). JR14169 ALTER TABLE ADD COLUMN ON A TABLE WITH CLUSTERING INDEXES CRASHES THE DATABASE IY07376 LIBPATH NEEDS TO BE SET IN DB2 INSTANCE ON AIX OTHERWISE VARIOUS PROBLEMS CAN HAPPEN. 'NO SUITABLE DRIVER' FOR EXAMPLE. JR14174 SQL1403 WHEN CONNECTING TO DATABASE ON NT USING A USERID THAT IS THE SAME AS A DOMAIN NAME IY07453 TRAP IN SQLDFIXTCB DURING LOAD DUE TO INCORRECT RETURN CODE HANDLING IN SQLU_GET_TABLE_ID IY07092 CHANGE OPTIMIZER COSTING TO HANDLE NULLS JR14003 CALLING A STORED PROCEDURE FROM A V6.1 CLIENT (FROM A CLI APPLICATION) RESULTS IN SQL0804 WITH RC=103 IY07483 STORED PROCEDURE FAILS TO PASS LOB DATA BACK TO THE CLIENT USING THE NET DRIVER JR14184 MULTITHREADED FIXES NEED TO BE DONE TO DB2JD DUE TO VARIOUS PROB LEMS (EXAMPLE: DB2JD BECOMES UNAVAILABLE INTERMITTENTLY) IY07510 TRAP IN SQLNR_SCALAR20J_ACTION JR14194 SQL0007N WITH SQLJ WHEN CALL STATEMENT INCLUDES A HOST VARIABLE IY07553 SQL0902 RETURNED WHEN SOME QUERIES THAT HAVE THE COUNT CLAUSE ARE EXECUTED. IY07600 QUERY PERFORMANCE AGAINST >4 TABLES IS NEGATIVELY AFFECTED BY THE CONTENT/LENGTH OF THE LIKE PREDICATE STRING. IY07623 SIGNAL #11 TRAP IN SQLORQUE2() IY07739 OPTIMIZER PREDICATE PROBLEM ON EEE WITH QUERY WRITTEN WITH UNION ALL IY07735 -433 SQLCODE ENCOUNTERED WHILE DOING A BUFFERED INSERT IY07737 IN SMP MODE, SORT CAN FAIL IF IT RUNS OUT OF TEMPSPACE. IY07796 CMDEAL WITH TYPE CM_DEALLOCATE_ABEND DOESN'T RETURN JR14229 SQJ0201E DURING SQLJ CUSTOMIZATION OF CALL STATEMENT IY07922 THE IN PREDICATE IN THE QUERY IS NOT PUSHED DOWN DUE TO OJ JR14234 DB2 UDB - INSTANCE CRASHES WITH A SIGNAL 11 TRAP IN FUNCTION SQLEDATABASEBAD WHEN DB2 ATTEMPTS TO MARK THE DATABASE AS BAD. JR14238 TRAP (C0000005) IN SQLUEXPM IN DB2BP.EXE DURING EXPORT - CAUSED IN PART BY A FILE SHARING VIOLATION ON THE MESSAGES FILE. IY07957 DBHEAP OUT OF MEMORY (D602) DURING CRASH RECOVERY IY07216 SELECTING 'INDEXES' FROM CC CRASHES OR HANGS THE CC. JR13651 SQL2029N, RC=28 ON RESTORE ISSUED FROM CLIENT WITH A DIFFERENT ALIAS THAN THE SERVER - USING SYTOS USEREXIT JR14077 DB2/OS2: DB2SYSC.EXE TRAPS IN _UFREE (C RUNTIME) CALLED FROM _REGEN_EXCEPTION CALLED FROM SQLOADDENVSTRING List of APARs that went into 21168b APAR No. Abstract -------- ------------------------------------------------------- IY04033 INCORRECTLY PARSING AUTOLOADER INPUT PARAMETERS. JR13185 JAVA APPLICATION RECEIVING SQL0502 DURING NORMAL COURSE OF OPERATION JR14115 SQL3324N ERROR WHEN SQLDA PROCESS UNINITIALIZE SQLVAR WHICH GIVE SQLTYPE VALUE. IY06187 LOAD TRAPS (SQLBLOADGETEXTENT) IN ERROR PROCESSING.. JR14024 INCORRECT CALL STATMENT USED WHEN CALLING STORED PROCEDURES ON AS400 SERVERS. USING LITERALS AS PARAMTERS. IY07117 SIGNAL #11 IN FROM SQLRR_DUMP_SECTION WHILE EXECUTING A DB2_CALL _STACK JR14049 SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG IY06717 DDL GENERATED BY DB2LOOK FOR UNIQUE INDEXES CAN BE IMPROVED. IY06691 SQL4970 ON ROLLFORWARD TO END OF LOGS - 'UNEXPECTED FILECOUNT' IY06791 DB2 UDB - SQL3021/SQL0204 ON IMPORT REPLACE TO A ALIAS NAME FOR A TABLE IN WHICH THE USER HAS CONTROL ACCESS TO. 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. JR14085 SQL2025 FROM LOAD WITH DB2NTNOCACHE=ON IY06932 SQL0973 QUERY_HEAP AFTER REPEATED ERRORS WHEN USING DESCRIBE DA (CLI) IY04375 LOAD AGENTS DO NOT TERMINATE WHEN INPUT PIPES ARE BLOCKED DB2 FORCE DOES NOT FORCE THESE AGENTS JR14116 -514 ON SQLEXECUTE() FOLLOWING COMMIT ON OPEN CURSORS ON HOST IY07040 SQLDESCRIBEPARAM IS CALLED ON A CALLABLE STATEMENT EVEN WHEN DISABLED. IY07038 INCORRECT RESULT WITH LARGE ASLHEAPSZ IY07111 CLIENT CONTROL CENTER CONNECT CAUSES EEE SERVER INSTANCE TO TRAP. 00/01/10 PTF PECHANGE IY07120 INSTANCE CRASHES WITH SIG#11 ON EXECUTION OF SELECT STATEMENT WITH UNION CLAUSE . JR14127 DB2 UDB V5.2 - TRAP IN FUNCTION SQLNQ_FINDFN WHEN RUNNING A SIMPLE SQL QUERY. IY07320 DROP TABLE FAILS WITH SQL1007N IY07244 SEARCH FOR FREE SPACE WHEN APPEND MODE ON TABLE. IY07235 DB2DIAG.LOG AND TRAP FILE GROWS VERY LARGE AFTER SECOND INSERT UPON TABLESPACE FULL CONDITION. JR14152 SQLJ EXHAUSTS CURSOR HANDLES AFTER 11613 STATEMENTS CLI0129E NO MORE HANDLES IS RETURNED JR12399 FROM CONTROL CENTRE WHEN TRY TO FORCE MORE THAN TWO APPLICATIONS USING APP ID'S, THE OPERATION FAILS,INVALID AGENT ID. List of APARs that went into WR21168a APAR No. Abstract -------- ------------------------------------------------------- IY06164 WHEN AUTOCOMMIT IS ON AND SQLEXECDIRECT RETURNS A NEGATIVE SQLCODE, NO COMMIT IS SENT TO THE TARGET DATABASE. IY03544 CREATE DATABASE ON LARGE NUMBER OF NODES MAY HANG IY04404 DB2CLI.INI PASSWORD SETTING (PWD) OVERRIDES AUTOLOADER.CFG PASSWORD SETTINGSO THAT DB2ATLD FAILS TO CONNECT TO DB JR13824 JAVA I/O EXCEPTION ON WRITE TO BLOB OBJECT FROM STORED PROC IY05169 SQL3015N ON LOAD INTO TABLE WITH MIXED CASE TABLE NAME. IY05294 DB2DARI PROCESS COUNTER NOT DECREMENTED IN CASE OF ABEND JR13880 RETURN THE ODBC SCALAR NUMERIC FUNCTIONS SUPPORTED BY DB2/MVS IY05535 QUERY TO DB2/MVS IS BEING TIMEDOUT EVEN IF NOT INTERRUPT ENABLED IY05732 CLI REPORTS THAT UDB DOES NOT SUPPORT INOPERATIVE VIEWS -IT DOES JR13925 HANG DUE TO SEMAPHORE WAIT CONDITION DURING SQLALLOCCONNECT IY03698 CLI ARRAY INSERT PROBLEM WHEN ALL FIELDS IN A RECORD ARE NULL IY05871 DLFM RETRIEVE_QUERY FAILS WHEN CMD LINE OPTIONS GIVEN BUT PROMPTS AND WORKS WHEN NO OPTIONS SPECIFIED JR13974 FILTER FACTOR FOR ALWAYS-TRUE PREDICATE CAUSE SLOW QUERIES IY06066 PUTTING ASYNCENABLE BACK INTO CLI IY06080 LOAD TRAPS IN DB2LTSC PROCESS - UNINITIALIZED WAITLIST POINTER IY06094 SQLJ: DB2PROFC COMMAND WITH PRECOMPILE OPTION QUALIFIER GIVES SQL0204N IY06163 NON-SELECT STATEMENT ISSUED THROUGH CLI BRINGS DOWN DATABASE ON COMMIT IY06215 SQL0998 RETURNED TO CICS APPLICATIONS ISSUING STATIC ROLLBACKS, OR STATIC COMMITS. IY06211 INCORRECT QUERY RESULTS USING WHEN CASE STATEMENT WITH IN CLAUSE. IY06234 JDBC RETRIEVAL OF NON-US CLOB TRAPPING. IY06278 EXPORT TO SELECT STATEMENT RETURNS SQL3022N ERROR WHEN SELECT STATEMENT RETURNS A WARNING '347' IY06328 JDBC APPLICTION WAS CRASHING DUE TO AN INVALID MEMORY COPY OPERATION IN THE NATIVE METHOD SQLBINDNUMERIC IY06347 TCP LISTENER HANGS IN SQLEGETAGENT UNDER HIGH WORKLOADS IY06376 SIGNAL#4 IN SQLRINTP IY06420 EVENT MONITOR RETURNS ZERO FOR PREFETCH_WAIT_TIME JR14025 SQL3181W WARNING GENERATED ON LOAD FOR A VALID IXF FILE IY06434 FIRST DB2START FAILS AFTER AIX V4.3 REBOOT IY06599 QUERY WITH UNION OVER JOINS GIVES WRONG RESULT IY06660 OPTIMIZER DOES NOT USE AN AST TABLE. IY06806 DB2 CONNECT TRAPS IN SQLE_DB2RA_AS_DB_BLOCK_FETCH, WHEN CLIENTS CONNECT TO EE/EEE DATABASES THROUGH THE GATEWAY. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13862 DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT JR13441 INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR13679 SYSLEVEL ON DB2/OS2 SERVER ALWAYS SHOWS EE PRODUCT INSTEAD OF THE INSTALLED DB2 PRODUCT. List of APARs that went into WR21168 APAR No. Abstract -------- ------------------------------------------------------- IY05892 CLP THROUGHPUT IMPROVEMENTS IY04339 TRAP IN LOAD WHEN TEMP SORT FILE > 2GB SQLU_SMGETFREEPG() IY03678 TRAP INDICATING SQLFXSYS_X AS FAILING FUNCTION. IX83660 SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS IY04310 DB2 UDB - ONLINE/OFFLINE BACKUP TO SEVERAL DISKS HANGS. IY04445 LOAD USING FASTPARSE MODIFIER AND DATE COLUMNS DEFINED AS NOT NU LL MAY DUMP 'RECORD LENGTH 0...' MESSAGES IN DB2DIAG.LOG IY04496 DB2LOOK UTILITY MISTAKES IN THE HELP TEXT WITH THE -H OPTION JR13750 MULTIPLICATION OF DECIMAL CONSTANT GIVES INCORRECT RESULT IY01325 TRAP IN SQLE_MRSPSENDDARISTAR IY05319 OPTIMIZER PROBLEM WITH THE FILTER FACTOR WHERE WE DO NO ACCOUNT FOR DATA CORRELATION LEADING TO ANOTHER INDEX BEING USED... JR13902 ROWSTATUS ARRAY INCORRECT WHEN -911 (DEADLOCK) OCCURS. IY05591 DB2 LOOPS, THROUGHT 2 LOG FILES, DURING ROLLFORWARD COMMAND IY05745 BUFFERPOOL CORRUPTION JR13927 IMPLEMENT NEW BIDI LAYOUT TRANSFORMATION ROUTINE WITH MORE STRIN GENT ERROR CHECKING, MEMORY ALLOC, AND BIDI CCSID STRING TYPES. IY05751 SQLBINDPARAMETER WITH IBSCALE CHANGING ONLY - DB2 SHOULD IGNORE THIS AND NOT 'RE-DESCRIBE' THE COLUMN. RESULT - CLI0109 ERROR. IY05590 DB2IUPDT IN FP11 RESETS DB2PROFILE 99/11/11 PTF PECHANGE IY05823 TIMING HOLE IN THE COMPUTATION OF APPLICATION IDLE TIME CAN RESULT IN NEGATIVE NUMBERS IN THE APPL_IDLE_TIME ELEMENT. IY05826 REMOTE MONITORING DOES NOT WORK FROM A CLIENT AGAINST UDB 5.2/HP-UX SERVER. IY04173 DB2ADUTL DOES NOT GUARANTEE ORDER WHEN EXTRACTING LOGS FROM ADSM IF MULTIPLE COPIES OF THE LOGS EXIST. IY05913 DB2ATLD BOUNDARY CONDITION CRASH IF LINEFEED IS ON A MULTIPLE OF THE 32K DATA FILE JR13949 DEFFERRED PREPARE RETURNS OPEN CURSOR FOR LARGE RESULT SETS. IY05910 INTERRUPTS GENERATED WITHIN COMMSERVER FLOODED DB2DAIG.LOG WITH DIA3107E ERRORNO '4'. JR13957 CURSOR WITH HOLD NOT ALLOWED IN CICS IY05980 CTRL-C APPLICATION CAUSES TRAP IN SQLEIAGT_CB JR13972 COMMIT IN LOAD WAS UNEXPECTEDLY INTERRUPTED. IY06097 SQLBINDPARAM CALL COREDUMPS AFTER SELECT IS DONE, THEN ARRAY INS ERT IS ATTEMPTED. IY06145 ASCII FUNCTION RETURNS INCORRECT OUTPUT GG03962 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP PQ30351 DPROPR APPLY, STL CMVC LEVEL PQ30351 FOR V5.2 FPK 12 IC24358 CHECK IN DJRA.EXE FOR V5.2 JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13862 DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT JR13441 INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS GG03963 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS GG03644 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 GG03965 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS 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 GG03982 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL GG03964 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS GG03967 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 GG03966 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS GG03974 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS GG03981 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS GG03983 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY04799 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS IY04843 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 IY04839 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS IY05656 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05662 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05671 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY04800 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS IY04844 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 IY04840 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS IY05658 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05663 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05672 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY04845 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 IY04841 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS IY05659 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05664 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05673 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL GG03968 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP GG03970 GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED GG03962 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP GG03969 GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED IY04848 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY04849 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP IY04850 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP List of APARs that went into WR21142c APAR No. Abstract -------- ------------------------------------------------------- JR13837 ADD CLI HANDLE INFORMATION TO DB2 TRACING IY05315 BAD ACCESS PLAN FOR WHERE IN (VAR1,VAR2....VARN) IY04471 -902 FROM SQLRIGTQ IY02577 DESCRIBE FAILS FOR UNICODE DB WITH A CODEPAGE CONVERSION IY05483 FIX FOR SPM ON SUN ULTRASPARC (SUN4U) ARCHITECTURE IY03903 AFTER A TABLESPACE RESTORE, A 'ROLLFORARD QUERY STATUS' DOES NOT SHOW INFORMATION IN THE 'NEXT LOG TO BE READ' FIELD. 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 IY04414 DARI PROCESS DOES NOT PICK UP GROUP ID FROM .FENCED FILE IY04401 SQL1042 AT RESTART DB AFTER CRASH AT ALTER BUFFERPOOL IY04656 DBSNAP.C SQLMONSS CALLED WITH SQLM_DBMON_VERSION2, SHOULD BE EIT HER SQL_DBMON_VERSION52 OR SQL_CURRENT_VERSION IY04909 SIGNAL #4 TRAP DURING BUILD PHASE OF LOAD IY04947 SQLCODE -433 RETURNED ON A BUFFERED INSERT IY05123 DB2 MONITOR LOCK SNAPSHOT MAY NOT SHOW LOCKS BEING HELD ON CATAL OG PARTITION DURING STATEMENT COMPLIATION IY05051 CATALOG CACHE MAY CAUSE LONG LOCKS TO BE HELD IN SYSTABLES JR13821 DB2FLSN CAUSES SYS3175 TRAP IN OS/2 IY05040 TRAP, SIGNAL #11, IN THE OPTIMIZER, SQLNO_CRULE_STARJN_AND(). IY05115 SELECT COLUMN LIST > 4005 AND ORDER BY CAUSES SQL1224. JR13829 ADD DB2CLIV2.BND IN .LST FILE FOR DRDA SERVERS (FUNCTION ADDED) IY05114 SQLM_COLLECTED.NODE_NUM NOT BEING SET WHEN SNAPSHOT TAKEN AGAINS T LOGICAL NODES OF A EEE INSTALLATION IY05131 CLI0165E WHEN USING SQLEXTENDEDFETCH WITH ASYNC MODE ON IY05176 DBM CRASHES DUE TO A SIGNAL #11 IN SQLVDECADDEC IY05186 CREATE TABLE IN EEE WITH PARTITIONING KEY USING HASHINGDOES NOT UPDATE PARTITION_MODE IN SYSTEM CATALOGS. IY05192 SQLSTATISTICS() QUERY FAILING WITH CLI0165E ERROR IN ROW IY05217 READX() RETURNING ZERO BYTE TRAPPED MEMTREEDEL, CORRUPTED DB2RA RECEIVED AT SERVER AND LOADED CPU IY05326 NULL INDICATORS ON OUTPUT SQLDA FROM STORED PROCEDURE NOT BEING CHECKED BY CLI WHEN WARNING ISSUED. IY05406 JAVA INSERT USING SETSTRING TO DECIMAL COL TRUNCATES DECIMALS JR13879 DB2 CONNECT GATEWAY TRAPS WHEN USING DOWNFIX CLIENT DURING STORED PROCEDURE CALL TO DB2 MVS. IY05426 SQL1034N FOLLOWED BY INTERRUPTING ROLLBACK OPERATION IY05446 ADD PATCH VALUE TO RETURN TRUE ISO TIMESTAMP FORMAT FROM CLI JR13882 TRAP IN SQLNO_PROP_BEST_SORT_KEY RUNNING QUERY ON VIEW. IY05608 CLI_MEMFREE TRAPS IN CLI_DSTFREEINFO WHEN OUT OF MEMORY JR13909 DB2LOOK INSERTS COMMAS INTO DDL INSTEAD OF DECIMAL POINT FOR FLOATING POINT NUMBERS IN CERTAIN LOCALES/TERRITORIES JR13816 CONTROL CENTRE ABENDS AFTER DISCONNECT FROM DB WHEN SNAPSHOT MONITORS RUNNING IY05292 DBA2065 TRYING TO RUN OR SCHEDULE SCRIPT FROM SCRIPT CENTER. JR13862 DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT JR13441 INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS List of APARs that went into WR21142b APAR No. Abstract -------- ------------------------------------------------------- IX87013 TEMPORARY FILES ARE CREATED USING BLOB WITH JAVA PROGRAMS JR12796 SQLCOLUMNS() CALL WITH ONLY TABLE NAME DISREGARDS SCHEMALIST AND CURRENTSQLID JR13437 TRAP IN DB2APP.DLL IN SQLFETCH OF BLOBLOCATOR 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. IY03846 EVENT MONITOR STATE IS NOT UPDATED IN THE SYSTEM CATALOGS CORRECTLY IF EVENT MONITOR DOES NOT EXIST ON THE CATALOG NODE IY03855 EVENT MONITOR WITH AUTH_ID CONDITION DO NOT FILTER FOR EXISTING CONNECTIONS WHEN AT NODE IS USED. IY04769 NODEXXXX AND CATNXXXX NOT UPDATED CORRECTLY ON BACKUP IMAGES EXTRACTED FROM ADSM WITH DB2ADUTL JR13684 SQL0901 IN FUNCTION SQLNO_SMP_CREATE_SHARED_SO IY04225 INFINITE LOOP IN DB2GOVD DURING ERROR HANDLING IF DB2GOV LOG FILES ARE REMOVED. INFINITE ERRORS TO STDOUT. 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 IY04798 TRUST APP IS USING AN INVALID MEMORY ADDRESS IY04399 TRAP, SIGNAL #11, IN THE DB MONITOR, I.E. DURING COLLECTION OF TABLESPACE COUNTERS. IY04333 -516 ON DESCRIBE CAUSING LOOPING IN CLI 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. IY04461 TRAP, SIGNAL #11 IN, SQLNN_CMPL_CLEANUP(), CLEAN UP ROUTINE IN THE OPTIMIZER IY04462 CLI0109E 'STRING DATA RIGHT TRUNCATION' ERROR OCCURS AT FIXPACK 10 LEVEL WHEN TRYING TO INSERT BINARY DATA IY04502 DB2CLI.H HEADER INCORRECT FOR SUN JR13753 JDBC SETBYTES() MEMORY OVERWRITE IF INPUT VALUE LARGER THAN COLUMN WIDTH. JR13762 TRAP IN SQLEX_RDS_GEN_DATA. IY04732 SQL0902 RC=126 AT DROP TEMP TABLESPACE JR13783 PARMLIST SYNTAX ERROR ON STORED PROCEDURE CALL TO MVS JR13795 DEFERRED PREPARE ALWAYS ON IY05015 FIRST CALL TO LOADQUERY() FAILS WITH ENOMEM IY04881 DB2 INSTANCE ABENDS WHEN ACCESSING A LONG FIELD. SPECIFICALLY A NEWX ENTRY IS PUT INTO DB2DIAG.LOG. IY04893 SETTING DB2_MMAP_READ PROBLEM COULD PREVENT FIRST CONNECT JR13653 JDBC APPS AUTOCOMMIT IF STORE PROCEDURE CALL IS MADE. EXPLICIT ROLLBACK NOT POSSIBLE AFTER STP CALL. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13782 DOSSLEEP(0) PREVENTED DB2 THREADS FROM DOING WORK WHEN HIGHER PRIORITY THREADS WERE RUNNING. JR14088 100% CPU OR HANG SYMPTOMS DURING INSERT 99/12/21 PTF PECHANGE List of APARs that went into WR21142a APAR No. Abstract -------- ------------------------------------------------------- IY02032 TABLE ACCESSABLE AFTER ROLL FORWARD THROUGH AN NONRECOVABLE LOAD JR13397 LIST HISTORY SHOWS BACKUP FILE ON WRONG NODE. JR13475 RETRIEVING A CLOB SUB-STRING GREATER THAN 32KB TRAPS ON THE GATEWAY. IY03631 DB2_RECON_AIDPACKAGING IN EE IY03689 ADDITIONAL INFORMATION TO BE DUMPED IN DB2DIAG.LOG WHEN A BAD PAGE IN MEMORY IS ENCOUNTERED. JR13645 SQLCOLUMNS RETURNS INCORRECT INFORMATION FOR DEFAULT VALUE IY03885 EVENTEVENT MONITOR WITH AT NODE DOES NOT FILTER EXISTING CONN IY03853 SQLRA_COMPILE_VAR MESSAGES AT DIAGLEVEL 4 WHEN ON ERROR OCCURRED IY04062 WHEN USING TEXT EXTENDERS AND UDB, C++ DESTRUCTORS IN LIBIBMCLS.A CAUSE TRAPS IN LIBDB2LAI.A (REF. COUNT OUT OF SYNC). IY04202 MULTI DEADLOCKS BRING DB DOWN WITH SQL0901 (STMT NOT FOUND!) IY04291 -901 IN SQLRI_CLOSE_UDF_EOT(), -1034 DBM CRAHES JR13708 CLI APP TRAPS WHEN CLI TRACE IS ON AND SQLFETCH RETURNS != SQL_SUCCESS IY04240 CERTAIN QUERIES THAT RAN ON V5 RETURN SQL0101 - QUERY TOO COMPLEX ON V5.2. JR13736 SQLDESCRIBEPARAM FAILS ON DEFERRED PREPARE OF >= 26 COLUMNS. JR13152 BEING USED: "TCP/IP". COMMUNICATION API BEING USED: "SOCKETS". LOCATION JR13152 SQL0900N THE APPLICATION STATE IS IN ERROR. A DATABASE CONNECTION DOES NOT List of APARs that went into WR21142 APAR No. Abstract -------- ------------------------------------------------------- IY04242 LOG FULL CONDITION DID NOT SAVE ENOUGH LOGSPACE FOR A TRANSACTION TO BE ROLLED BACK. IY04157 SET CURRENT PACKAGESET PRODUCES A SIGSEGV FROM WITHIN SQLJ IY03608 DB MARKED BAD AND BROUGHT DOWN WHEN LOAD INTO TABLE WITH RI. GG03943 GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS GG03944 BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET GG03945 ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE. GG03952 APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH GG03954 SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT GG03955 AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT AUTOMATICALLY CUT IN HALF TO ENABLE SUCCESSFUL PROPAGATION. GG03957 SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION. GG03923 GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS GG03924 SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT GG03933 BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET GG03946 ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE. GG03951 APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH GG03924 SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT GG03956 AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT AUTOMATICALLY CUT IN HALF TO ENABLE SUCCESSFUL PROPAGATION. GG03958 SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION. IY03189 GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS IY03192 BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET IY03195 ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE. IY03318 APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESHIY03535: SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT IY03539 AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT AUTOMATICALLY CUT IN HALF TO ENABLE SUCCESSFUL PROPAGATION. IY03514 SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION. IY03190 GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS IY03193 BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET IY03196 ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE. IY03319 APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH IY03536 SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT IY03540 AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT AUTOMATICALLY CUT IN HALF TO ENABLE SUCCESSFUL PROPAGATION. IY03542 SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION. IY03191 GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS IY03194 BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET IY03197 ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE. IY03320 APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH IY03538 SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT IY03415 THE SQL STATEMENT USED TO CALCULATE THE UPPER COPY LIMIT SPECIFIED AN INCORRECT SYNCHPOINT VALUE. IY03941 AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT AUTOMATICALLY CUT IN HALF TO ENABLE SUCCESSFUL PROPAGATION. IY03543 SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION. GG03940 ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE GG03947 DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT GG03938 UNABLE TO GET GOCAPT FOR SOME TABLES GG03949 DPROPR FAILS ASN0001E SQLCODE811 GG03959 GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION GG03939 ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE GG03941 DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT GG03948 UNABLE TO GET GOCAPT FOR SOME TABLES GG03950 DPROPR FAILS ASN0001E SQLCODE811 GG03942 GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION IY02447 ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE IY03213 DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT IY03217 UNABLE TO GET GOCAPT FOR SOME TABLES IY02809 DPROPR FAILS ASN0001E SQLCODE811 IY02448 ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE IY03214 DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT IY03218 UNABLE TO GET GOCAPT FOR SOME TABLES IY03287 DPROPR FAILS ASN0001E SQLCODE811 IY03621 GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION IY02449 ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE IY03215 DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT IY03219 UNABLE TO GET GOCAPT FOR SOME TABLES IY03288 DPROPR FAILS ASN0001E SQLCODE811 IY03622 GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION IX88428 USING ADSM CONFIGURATION PARAMETERS IN DB CFG CAUSE A NULL TO BE ASSIGNED AS THE BACKUP IMAGE OWNER. IX88829 SQL1218 THERE ARE NO PAGES CURRENTLY AVAILABLE IN BUFFERPOOL IX89397 DB2 UNIX TRAPS ON CONNECT FROM EMB SQL IF DB2INSTANCE NOT SET IY02979 BPS ESTORE LOGIC ERROR CAUSES HANG IY01190 ROLLBACK OF CREATE TABLESPACE WITH > 1 CONTAINER NEVER UNTAGS CONTAINERS PAST THE FIRST ONE IY02569 TRAP AT BEGINNING OF ONLINE BACKUP IN SQLUBCKA IY02571 SQL0433 DURING INSERT VALUES, LINEFEED CHANGED TO SPACE IY02572 LANG=JA_JP.IBM-932OR JA_JP.IBM-943SYMBOLIC LINKS NEEDED IY02730 CLI DRIVER DOESN'T HANDLE LARGE STATEMENT SIZES CORRECTLY. JR13539 TRAP IN SQLBFREEONEPOOL DURING DB RESTORE WITH LOW DBHEAP JR12984 MS ACCESS APPL ERROR FROM DB2 V2.1 VIA DB2 CONNECT V5.2 TO DB2/M VS JR13567 XA ENVIRONMENT, SETTING ISOLATION LEVEL RETURNS CLI0126E. IY03379 DB2NODE ENVIRONMENT VARIABLE DOES NOT WORK FOR ALL COMMANDS IF PARTITION NUMBER SPECIFIED IS NOT ON THE SAME PHYSICAL NODE. IY03630 RECONCILE SQL2554 DOES NOT GIVE DLFM SERVER NAME. IY03454 DB2 UDB - FIRST EXECUTION OF THE SIN UDF RESULTS IN SQL0443, RC 03. OTHER 'MATH' UDFS MAY ALSO EXPERIENCE THIS ERROR. JR13610 ERROR LOGGED FOR SQLOFMBLK WHEN USING PREPARED STATEMENTS 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. JR13624 SQLRLCLO IN SQLRL_FETCH TRAPS WHEN APPLHEAPSZ IS LOW JR13630 SQLPLRL() TRAPS AS SQLRLGTS() NOT CLOSING CURSOR IY03635 TABLESPACE FULL BRINGS DOWN DATABASE JR13633 TRAP IN MONITOR SNAPSHOT JR13634 CLI COMPOUND SQL WITH DEF PREP FAILS IF SQLPREPARE BEFORE OPEN IY03805 PROBLEMS WITH NIS AND GROUP LOOKUPS ON AIX 4.3.2 DEFECT #124182 IY03861 APAR USED TO CREATE PTF FOR DB2 V5.0 FOR AIX JR13667 DB2JDBC.DLL TRAPS WHEN RUNNING WEBSPHERE IN VISUALAGE JAVA IY04046 JDBC TRAP IF APPLICATION USES INVALID CONNECTION HANDLE IY04196 LOG FULL CONDITION WITH NODE LOG SYNC WILL CAUSE DB2 TO PANIC AN D CRASH. IY04221 EXPLICIT CONNECT FAILS WITH SQL1403 ON AIX IX77854 SQL0901 DIAG FILE REPORTS ERROR IN BUFFER QUEUE SERVICES PROBE:30 SQLKQ_DETACH_BUFFER(). INTERNAL ERR 'LOST BUFFER' IY02556 CC: JOURNAL REPORTS INCORRECT JOB STATUS GG03938 UNABLE TO GET GOCAPT FOR SOME TABLES JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. List of APARs that went into WR21120b APAR No. Abstract -------- ------------------------------------------------------- JR13103 DB2 UDB V5 FIX FOR WEBSPHERE 3.0 JR13123 SQLGETPOSITION ON BLOB LOCATOR FAILS WITH CLI0102E IY02464 -901 INDICATING BANDP NOT PUSHED DOWN IY03175 BETTER HANDLING WHEN MINBUFFLSN IS DETECTED TO BE INCORRECT IY02618 DB2 CONNECT GATEWAY TRAPS IN SQLJFM10. JR12926 GETSCHEMA IS RETURNING A NULL SET WHEN USING OPTIMIZED CATALOGS JR13499 RECOGNIZE '\' ESCAPE CHARACTER IN SCHEMA QUALIFIERS IY01489 EXTENT S0000000.LOG REQUIRED FOR RECOVERY INCORRECTLY IY03164 TRAP IN SQLT_DISPLAY_CA IY03081 DRDA AS SHOULD NOT IGNORE INTERRUPTS ON RECEIVE IY03229 STORED PROCEDURE LEAKS MEMORY FROM SQAK IX86459 SVCENAME IN ADMIN INSTANCE CHANGED USING CLP IY03129 SIGNAL #36 FROM PANIC CALL IN REMOVE_ME FUNCTION JR13545 SQLESRSP MARKS DB BAD FOR ANY NON-ZERO RC FROM SQLRRAFI JR13547 CLI0606 WHEN RETRIEVING DECIMAL DATA USING GETDOUBLE FROM NT JR13548 GOV1027N WHEN INTERVAL ABOVE 300 SECONDS IY03133 SQL0901 "UNEXPECTED COLUMN USAGE TYPE" WHEN DELETING IY03393 UNINITIALIZED MEMORY IN OPTIMIZER CAUSES SIGNAL #11 IY00980 BACKUP FAILS WITH -1062 DURING SQLE_GETDBCB List of APARs that went into WR21120a APAR No. Abstract -------- ------------------------------------------------------- JR13540 ENABLE SQLDESCRIBEPARAM TO DB2 MVS W/PRDID 0512 JR12757 SQL2032, RC=14 WHEN RESTORING BACKUP FROM ADSM JR13540 SQLGETINFO SHOWS NO SQLDESCRIBEPARAM TO DB2 OS/390 (DSN05012) IX88671 TRAP IN SQLE_DB2RA_AS_DB_OPEN IX88927 DB2ADUTL EXTRACT -> CANNOT EXTRACT IMAGES > 2G IX89959 08/99: CACHE STORED PROCEDURE DESCRIBE INFORMATION IY01172 DB2ADUTL QUERY FULL DB IN MPP NOT CORRECT JR13311 TRAP IN "SQLMON_DCS_STMT" ON DB2 CONNECT EE 5.2 IY01644 DB2 TRYING TO CLOSE CURSORS/FREE LOCKS ALREADY CLOSED/FREED. JR13334 TIMESTAMPDIFF FUNCTION ONLY RETURNING POSITIVE VALUES IY01782 DB2ADUTL CORE DUMPS WHEN -1 PASSED FOR N ON COMMAND LINE IY02049 DB2LOOK CHANGES AUTHORIZATION FROM GROUP TO USER. IY02408 DEADLATCH SITUATION ON INDEX REBUILD JR13432 TRAP IN DB2 JDBC DRIVER WHEN SETTING DATE PARAMATER TO NULL JR13433 MEMORY LEAK IN DRIVERMANAGER.GETCONNECTION IY02470 SQL -4301 WHEN CALLING STORED PROCEDURE THAT RETURNS CLOB. JR13448 SMP:TRAP IN SQLOXULTEX CLEANING UP UNFENCED UDF RESOURCES IY00843 RETURN CODE NOT INITIALIZED IN SQLEUPGRADETOEXCLUSIVEMODE IY02647 CLI TRIES TO GROW THE CONNECTION LIST IY02659 SMP/PDB: INTERMITTENT SQL0444 RC=4 IY02764 SIGILL IN SQLBDMSDOCONTAINEROP:RESTORE OR SET TABLESPACE CONTS JR13481 STATIC CURSORS NOT BEING CLOSED FOLLOWING SQLCANCEL() IY02862 OUT OF SPACE IN THE DLFM_BACKUP_DIR_NAME NOT DETECTED JR13497 SQLWARN FLAGS NOT BEING RESET AFTER EXECUTE IY02936 UNCONDITIONAL LOGGING ERROR BY SQLOOPENNODELIST, DIAGLEVEL > 1. JR13508 DRDA APPLICATION DISCONNECT LEAVES 32K MEMORY BLOCK. IY02962 DEFUNCT DB2JD CHILD PROCESS ON SOLARIS (FIXES APAR IX88969) IY03017 DB2GOV ALWAYS USE NODENUMBER 0 ON LANG!=EN_US IY01211 DEFENSIVE LOGIC TO DETECT "PREVIOUS LOG EXTENT ID" INCORRECT IY03069 LIST DCS APPLICATIONS SHOWS DUPLICATE THREADS. IY03138 DB2BATCH WITH '-Q DEL' OPTIONS PUTS BLANK LINES AFTER EVERY ROW JR12656 SQLTABLEPRIVILEGES FUNCTION - NOT DATA RETURDATA FOR PUBLICPRIV JR13123 SQLGETPOSITION ON BLOB LOCATOR FAILS WITH CLI0102E JR12938 COMMAND CTR/NT TRAP - ISSUED CONNECT TO WRONG ID # TIMES List of APARs that went into WR21120 APAR No. Abstract -------- ------------------------------------------------------- IY01167 -901:SQLNO_CRULE_SAVE_PLANS [100] JR13405 APPL_NAME OPTION DOES NOT WORK WITH CREATE EVENT MONITOR IY01933 PROBLEM WITH RETROFIT OF 120563 JR13428 MEMORY LEAK WITH UDFS WHEN RETURNING BLOBS OF VARYING SIZE IY01841 12/99:RELEASE CATALOG LOCKS ACQUIRED FOR COMPILATION JR13112 INSERT UDF CAN CRASH DB2 IY00843 FAILED TO INITIALIZE THE WAIT/POST AREA ON NT JR13290 DISABLE ASYNC BY DEFAULT IY02708 DEAD LATCH ON CREATE TABLE WITH PRIMARY KEY JR13488 SQLCOLATTRIBUTES WITH SQL_DESC_BASE_TABLE_NAME WRONG IY01548 PROPER HANDLING WHEN CRASY-RECOVERY FAILED. IY00843 IMPROVE THE HANDSHAKE BETWEEN SQE AND MONITOR CODE WHICH COULD IY01277 OFFLINE BACKUP TRAP IN SQLUHCONVSTRUCTTOLINE IY01381 TRANSACTION TABLE FULL AND OVERFLOW OCCURED WITH TUXEDO IY01547 MULTIPLE 8133 MESSAGES IN DIAGLOG DURING CRASH RECOVERY IY01898 INTERNODE COMMUNICATION ERROR RESULTS IN DB CRASH JR13333 EXECUTING A STORED PROCEDURE ON A LOCKED TABLE CAUSES TRAP. IY01933 SQL0901 REPORTED BY SQLRAFRS() JR13103 CONNECTION.GETAUTOCOMMIT() SHOULD RETURN FALSE FOR XA DRIVER WH IY02162 MIN BUFF LSN TOO HIGH, RESTART FAILS, SOME LOG RECS MISSED IY02257 OPTIMIZER COSTING PROBLEM CAUSES PERFORMANCE DEGRADATION IY02285 BADLSN FIX IY01930 CALLING SQLUIHSH() FROM UNFENCED UDF HANGS ENGINE IX83662 SIGNAL#11 IN SQLKD_RCV_DATA JR13415 RESET COUNTER NOT WORKING ON DB ALIAS JR13152 VERSION INFORMATION NOT INCLUDED IN DLL HEADER JR13152 ADD VERSION INFORMATION TO DB2NT_V3 JR13402 NAMED SHARED EVENT SEMAPHORES NOT UNIQUE List of APARs that went into WR21114a APAR No. Abstract --------- ------------------------------------------------------- IY00882 SQL1614 RC 6 STARTING EVENT MONITOR - SEMAPHORE NOT REMOVED IY01210 DB2GOV REQUIRES DB2GOVD VALIDATE IF DB2GOV START NODENUM X RUN IY01295 TUXEDO TX_BEGIN() RECEIVES TPEPROTO FOLLOWING TX_ROLLBACK() IY01397 PERFORM INTERNAL OPERATION LOCAL TO CO-ORD IF POSSIBLE: EEE IY01401 WRONG INFO REPORTED BY APPLICATION SNAPSHOT IY01525 DB2LOOK DOES NOT SHOW NOT LOGGED INITIALLY OPTION FOR A TABLE IX89396 INTEGRATE 110701 INTO DB2_V3! JR13324 CALLING STORED PROCEDURES ON AS/400 WITH MORE THAN 9 PARAMETERS JR13344 INCORRECT DESCRIBE INFO USED ON AN EXECUTE. JR13363 CCA ADD DATABASE SMARTGUIDE CANNOT TRUNCATE COMMENT FIELD IY01885 MEMORY LEAK WHEN USING ARRAYINPUT JR13156 CLI0614E RETURNED TO JAVA APPLET. INTERMITTEN. JR13354 SQL1404 (PASSWORD EXPIRED) IS IGNORED FROM A MVS WHEN USING ODB IY02027 SQL0304N WHEN SELECTING FROM REAL COLUMN ON MVS IY02029 TRAP INSIDE OF SQLEJNMSTP_SETBIGDECIMAL WHEN USING A BIGDECIMAL JR13156 PARAMETER MARKERS IN JDBC APP BOUND WITH WRONG SIZE IY02147 STARTING DB2JD HAS SEGMENTATION FAULT IF JDBCERR.TXT NOT AVAIL IY01429 -901 IN SQLNO_SMP_RUNIN_COORD WITH INTRA_PARALLEL ON JR13355 THREE WAY JOIN FOR REPLICATION FAILS THROUGH CONTROL CENTER IY02092 CHANGE USER TRAPS IN DB2CC.EXE FROM CONTROL CENTER JR13152 VERSION INFORMATION NOT INCLUDED IN DLL HEADER List of APARs that went into WR21114 APAR No. Abstract -------- ------------------------------------------------------- IX89839 27 RETURNED INSTEAD OF HEAP NAME FOR SQL0973 IY02026 BASICALLY THE PROBLEM IS THAT ON UDB(FP8)/AIX(SMP), WHEN LOAD C IY01429 -901 IN SQLNO_SMP_RUNiN_COORD WITH INTRA_PARALLEL ON IY01710 BADLSN JR13295 DB2PEM32.DLL IS NOT THREAD SAFE IY01726 -952 ON JAVA STORED PROCEDURE BECAUSE BDSCOUNTER NOT INCREMENTE JR13332 CHANGE PASSWORD FOR 8 CHAR USERID RETURNS INVALID USERID IY01883 DB MARKED BAD ERROR IN SQLBCHECKSMP4OBJDEL JR13278 THE REGISTRY INFORMATION FOR DB2CLI.DLL AND DB2ODBC.DLL STILL P JR13152 ADD VERSION INFORMATION TO DB2NT_V3 List of APARs that went into WR09106 APAR No. Abstract -------- ------------------------------------------------------- IY01762 JNI PANIC: JNI RECEIVED A NULL ARRAY (WHEN USING APP DRIVER) IY00838 NIS: CONNECT ... CHANGE PASSWORD "FAILS" WITH SQL1403N JR13169 #DELETED IN MS ACCESS WHEN QUERYING TABLE IN DB2 JR13200 USING BOTH ODBC 2 AND ODBC 3 ENVIRONMENTS AT THE SAME TIME. JR13009 RETURN ODBC ESCAPE CLAUSE FOR CALL STMT FROM SQLNATIVESQL JR12918 TABLETYPE KEYWORD NOT WORKING FOR SYNONYM IY00412 DB2JD CAN'T BE STARTED IF DISABLEMULTITHREAD=1 IN DB2CLI.INI GG03881 ASNMIG DOESNT SET/MIGRATE COLUMN SYNCHTIME IN IBMSNAP_SUBS_SET. GG03921 VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION GG03883 VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION GG03917 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS GG03919 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 GG03918 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS GG03920 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 IY01375 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS IY01378 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 IY01376 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS IY01379 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 IY01377 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS IY01380 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 PQ27660 CHECK IN REPLICATION APPLY FOR V5 FIXPAK 9 JR13194 SET ACCOUNT STRING IN THE DB2CLI.INI FOR MVS JR13315 SQL30020 AFTER PASSING SQLDA TO HOST. GG03880 DPROPR MIGRATE, STL CMVC GG03880 IY00230 CLI0601 IF FREESTMT FAILS BECAUSE OF SQL30081 ON A COMMIT. IY01371 CLIENT HANGING IN A 3-TIER ENVIRONMENT JR13157 SQLMORERESULTS FLOWING EXTRA FLOWS TO THE HOST IY01386 TRANSACTION NOT FOUND MESSAGES IN DB2DIAG.LOG, IN TUXEDO ENV IX87233 DB2_ALL CAN ONLY BE EXECUTED FROM THE INSTANCE OWNER JR12774 ADVANCED ODBC SETTINGS TRUNCATES IX89691 TRAP IN SQLE_DB2RA_AS_DB_OPEN IY00971 SNAPSHOT DOESN'T SHOW LOCKS BEING HELD AT CATALOG NODE IX87116 ADD THE OPTION TO SPECIFY THE COLUMN DELIMITER AND CHANGE THE 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() IY01392 RESERVE ENOUGH LOG SPACE FOR UNDO OF DELETE NODE FOR V5 INDEXES IX88536 V5.2:DBADM SHOULD BE PERMITTED TO ADD USER FROM CONTROL CENTER. JR12556 CONTROL CENTER CREATE DB FROM BACKUP DOESN'T FAIL WITH ONLINE JR13269 USEREXIT ARCHIVES MAX 63 LOG FILES AFTER ERROR IS CORRECTED. JR12995 JAVA APPLET (JDK1.2) TRUNCATES RESULTS FROM SELECT OF CHAR COL. JR12996 TRAPS IN SQLJMFR1.C ON DB2 CONNECT V5.2 JR13091 SQL30020 RC=124C PLUS DUMP FILES WHEN SELECTING IN ASYNC MODE IY00867 HOT: TRAP AT SQLRA_CSM_DROP_SECT IX89997 UNTYPED PARAMETER MARKERS CAST INCORRECTLY FOR IN CLAUSE JR13153 GATEWAY TRAPS IN SWITCH_DB2RA IY00229 TQ HANG JR13202 NET.COMMERCE SQL0502N AND SQL0514N: 2 STMTS USING SAME CURSOR JR13223 CALLING STORE PROCEDURE HANG OR TRAP JR13217 SQLGETINFO(SQL_ORDER_BY_COLUMNS_IN_SELECT) REPORTS 'N' FOR MVS JR13218 EXTENDING PATCH2=19 FOR DB2/390 V5.1 '(' ')' AND ON CLAUSE IY00782 SQLPGRLG() PROBE 70 : CRASH RECOVERY ENDED TOO EARLY IY00858 TRAP IN MEMTREEPUT FROM SQLM_CONN::STMT_START JR13169 PATCH2=24 NEEDS ADDITIONAL FIX IY00976 RESTORE FAILS WITH SQL0973 - OUT OF LOCK LIST HEAP IY01020 CORRELATION ADJUSTMENT DOES NOT WORK FOR LARGE QUERIES JR13270 THE NET DRIVER (DB2JD) LEAKS WHEN SELECTING BLOBS FROM JR12713 FFFFF616 FROM SQLBTERMINATEAGENT IGNORED IN SQLETERMDBCONNECT IX88394 TRAP IN CC-JOURNAL WHEN VIEWING HISTORY JR12964 V5.2:STATEMENT VIEW (EVENT MONITOR) OPENS MULITPLE CONNECTS. JR13152 VERSION INFORMATION NOT INCLUDED IN DLL HEADER GG03863 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES GG03865 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES GG03867 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT GG03869 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS GG03871 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY GG03874 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION GG03876 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH GG03891 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER GG03893 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. GG03895 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION GG03898 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 GG03905 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. GG03907 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER GG03908 APPLY ONLY PROCESSES LAST EVENT POSTED GG03909 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY GG03864 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES GG03866 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES GG03868 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT GG03870 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS GG03872 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY GG03875 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION GG03877 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH GG03892 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER GG03894 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. GG03896 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION GG03899 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 GG03906 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. GG03910 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER GG03911 APPLY ONLY PROCESSES LAST EVENT POSTED GG03912 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY IX88123 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES IX88130 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES IX88138 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT IX88142 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS IX88144 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY IX88992 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION IX88995 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH IY00603 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER IY00610 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. IY00795 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION IY00798 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 IY00986 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. IY00989 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER IY00990 APPLY ONLY PROCESSES LAST EVENT POSTED IY00473 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY IX88124 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES IX88131 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES IX88139 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT IX88141 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS IX88145 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY IX88993 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION IX88997 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH IY00604 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER IY00611 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. IY00796 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION IY00799 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 IY00987 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. IY00991 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER IY00992 APPLY ONLY PROCESSES LAST EVENT POSTED IY00995 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY IX88125 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES IX88132 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES IX88140 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT IX88143 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS IX88146 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY IX88994 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION IX88996 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH IX89665 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS IY00605 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER IY00612 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. IY00797 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 IY00800 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION IY00988 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. IY00996 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER IY00997 APPLY ONLY PROCESSES LAST EVENT POSTED IY00998 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY GG03878 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS GG03887 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS GG03903 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE GG03904 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED GG03879 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS GG03888 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS GG03885 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE GG03889 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED IX88078 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IY00045 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS IY00975 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE IY00977 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED IX89054 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IY00100 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS IY00961 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE IY00962 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED IX89055 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IY00101 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS IY00964 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE IY00965 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED List of APARs that went into WR09096i APAR No. Abstract -------- ------------------------------------------------------- IY00676 SQL1403 ON CONNECT USER/USING JR13256 PMR#33083 IY00403 PATCH FOR DEFECT 116571 IY00268 PREFETCHER PLSDIE PROTOCOL MAY CAUSE HANGING JR13169 #DELETED IN MS ACCESS WHEN QUERYING TABLE IN DB2 IY00268 LOAD TRAPS DURING THE BUILD PHASE IN SQLU_SBPREFETCH IY00674 DB2ATLD & HANGS IY00718 HASH JOIN PLAN MAY HANG IY00761 POTENTIAL NULL DEREFERENCE DURING DROP TABLE AND DB SHUTDOWN. IY00793 INCORRECT TEXT MESSAGE FOR OS/390 ERROR -965. JR12749 POINT IN TIME ROLL FORWARD RECOVERY FROM CC DOES NOT WORK JR12751 CONTROL CENTER TRAPS WITH SPECIFIC JOURNAL HISTORY FILE IY00045 DPROPR CAPTURE, STL CMVC IY00045 JR13242 SQL1042C WITH BACKUP DUE TO MIXED CASE DRIVE LETTER (MSCS) List of APARs that went into WR09096h APAR No. Abstract -------- ------------------------------------------------------- JR12812 CCA TRUNCATES BIND MESSAGES WITH INVALID CHARACTERS IX88493 DB2_CORRELATE_PREDICATES=YES GIVES WRONG CARD ESTIMATES IX88675 -Q OPTION CAUSES ALL DATE FIELDS THAT ARE NULL TO NOT ALIGN IX88801 PARALELLISM IS NOT FUNCTIONAL FOR ODBC. IX88793 FIX COUNT!=0 ON DROP TABLESPACE WHILE LOAD RUNNING IX89062 SQL0901 (REASON FLUSHBLOCKS: NO PART SMP) IX89405 SIGNAL#11 IN SQLRITTB IX89467 CURRENTSQLID IS NOT PICKED UP BY CLI APPLICATIONS. IX89871 RETROFIT: -901 (NO PLAN FOUND) SQLNO_ITR_PLAN::NEXT JR13171 LOAD UTILITY ON USAGE OF DEL FORMAT GENERATES WARNING MESSAGE IY00444 IMS HEALTH HASH JOIN FIX, PRIVATE VIRTUAL MEMORY EXHAUSTED JR13184 DURING CONFIGURATION OF CLIENT USING CCA AND IMPORT JR13187 IMPROPER CHECK ON LENGTH FIELD CAUSING A MEMORY OVERWRITE IX89535 SEE 111384 IY00403 ALLOW SOLARIS NON-THREADED LOADABLE OBJECTS FOR DB2_NOTH.SO JR13204 MEMORY LEAK CONNECTING TO LOCAL DATABASE & DB2START NOT ISSUED IY00480 ENSURE DB2AUDIT EXECUTABLE RETURNS 0 INSTEAD OF 6 WHEN SUCCESSF IX87116 DB2BATCH DEFECTS (REMOVE EXTRA SPACES EXTRA BLANK LINES, APPEN JR11822 12/98 NT: LOAD FROM A ZIP DRIVE HANGS List of APARs that went into WR09096g APAR No. Abstract -------- ------------------------------------------------------- IY00239 JDBC APP FAILS WITH CLI0601E SELECTING > 100 COLUMNS IX87450 FILE MANAGER EXPORT CONTROL FILE NOT BEING CREATED IN SOME CASE IX87741 INCORRECT ROUND FUNCTION OUTPUT IX88096 JAVA GETLONG NOT RETURNING 0 FOR NULL VALUES IX89850 USING PKGRM "DB2 PACKAGES" COMMAND ,DELETES SUN PATCHES ALSO. JR13150 QUERY WITH LIKE '' TRAPS IN SQLNO_FF_COMPUTE_LIKEPRD JR13156 PARAMETER MARKERS IN JDBC APP BOUND WITH WRONG SIZE IX87911 SAMPLE USEREXIT MAY ATTEMPT TO CLOSE A FILE WHICH IS NOT OPEN IX88660 SQLPROCEDURES PROBLEM WHEN GOING TO AS/400 STORED PROCEDURE List of APARS that went into WR09096f APAR No. Abstract -------- ------------------------------------------------------- IX89209 FP9: ABILITY TO FIX TERRITORY FIELD FOR MIGRATED DBS V2 TO V5 IX89506 REINTRODUCE APM CACHE LOGIC TO RETRY RESERVE BEFORE OVERFLOW IX89840 RENAMING LOG FILES DURING DB DEACTIVATION CAUSES ABNORMAL DB CR JR13114 DB2DEFPREP=YES NOT DISABLED FOR PREPARE WITH INTO CLAUSE IX89960 DON'T SEND FETCH TO SERVER IS SQLCODE +100 (WITH HOLD CURSOR) IX89962 GET INSTANCE COMMAND RETURNS DB21016E IX88660 FIX DB2_V3 BUILD ERROR JR13141 SQL01092N WHEN CATALOGING WITH DOMAIN USER ON WR09094 IX89426 SAME AS DEFECT 110788 IX89896 SCHEDULED BACKUP FROM DB2CC DOES NOT FUNCTION CORRECTLY JR12990 SQLTENTR_CEI_FIT1 SYMBOL NOT FOUND ON OS/2 FOR MF COBOL APP List of APARs that went into WR09096 APAR No. Abstract -------- ------------------------------------------------------- IX87839 EXCEEDING MAX APPLID SIZE OF 32 BYTES. IX87911 ERROR CODE 28 FROM SAMPLE USEREXIT WHEN LOG FILE DOES NOT EXIST JR12894 RANDOMS TRAPS IN SQLRA_DEL_VAR_CACHE IX88313 HASH_JOIN PLAN MAY PRODUCE INCORRECT RESULTS JR12745 SQLBINDPARAM WITH LENGTH 0 USING SQLPUTDATA/SQLPARAMDATA. IX87928 FIXES TO REPLICATION ADMIN TOOL, DJRA IX87156 3/99: RETROFIT SMP IXA HANG FIXES GG03848 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. GG03850 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 GG03849 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. GG03851 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 IX87076 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. IX87080 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 IX87078 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. IX87081 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 IX87079 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. IX87082 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 GG03841 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN GG03844 AUTHID COLUMN IN UOW TABLE IS INCORRECT GG03846 NULL LONG VARCHAR VALUES NOT REPLICATED GG03853 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN GG03855 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN GG03857 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD GG03856 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 GG03860 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD GG03840 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN GG03843 AUTHID COLUMN IN UOW TABLE IS INCORRECT GG03845 NULL LONG VARCHAR VALUES NOT REPLICATED GG03847 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN GG03854 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN GG03858 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD GG03859 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 GG03861 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX85990 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN IX86080 AUTHID COLUMN IN UOW TABLE IS INCORRECT IX86911 NULL LONG VARCHAR VALUES NOT REPLICATED IX87200 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN IX87047 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN IX87595 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD IX87665 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 IX87422 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX85991 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN IX86081 AUTHID COLUMN IN UOW TABLE IS INCORRECT IX86913 NULL LONG VARCHAR VALUES NOT REPLICATED IX87201 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN IX87202 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN IX87653 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD IX87667 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 IX87670 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX85992 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN IX86082 AUTHID COLUMN IN UOW TABLE IS INCORRECT IX86914 NULL LONG VARCHAR VALUES NOT REPLICATED IX87206 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN IX87205 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN IX87654 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD IX87668 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 IX87671 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX87124 BUFFER POOL ALLOCATION - SOLARIS 2.6 MEMORY MANAGEMENT CHANGES IX87172 POOR PERFORMANCE BECAUSE STAR JOIN IS NOT SELECTED IX87280 ROLLFORWARD FAILS (SQL1271W) WHILE REBALANCING IX87417 SQL2036 - INVALID PATH, IN MLN ENVIRONMENT USING DB2 LOAD IX87463 MULTIPLE LOGON WINDOWS WITH ACCESS WITH NO UID/PWD INPUT JR12814 DB2LOOK FOR REFERENTIAL CONSTRAINTS IX87540 INVALID ROW COUNT RETURNED ON UPDATE WITH STREAMS (LOB) IN JDBC IX87542 RECOVERY HISTORY FILE GOT PRUNED EVEN WHEN REC_HIS_RETENTN = -1 IX87634 TRAP IN V5 CAE WHEN EXIT HANDLER IS CALLED IX83662 NEW DEBUG CODE FOR 93096 ON SENDING SIDE OF DSS IX87720 CLI SQL_CONNECT_NODE WILL NOT ACCEPT VALUE 0 IX83104 V3: ESTORE PROBLEM WITH ATTACHED SEGMENTS IX83408 FAILING BACKUP NOT RECORDED IN HISTORY FILE JR12555 SQL2032 REMOTE BACKUP TO ADSM VIA NT CLIENT SESSIONS >1 IX84766 RESTART FAILS WITH SQL0575 WHEN REPLICATED TABLE IS INVALID IX84195 DB2LOOK MEMORY LEAK WHEN SMP INVOLVED (DFT_DEGREE > 1) JR12681 SUPPORT OPTIMIZE FOR N ROWS BY TURNING OFF PREFETCH IX82599 DB2_V5:THE START UP LOGIC FOR OUR LICENSE DEAMON IS TIME SENSIT IX86221 DB2 5.2: RESTORE HANG JR12721 IN PREDICATE WITH >284 ITEMS IN SELECT STATEMENT TRAPS ENGINE. JR12748 SYMBOLS FOR GENERIC API NOT EXPORTED FOR UDB VERSION 5/5.2 JR12790 SCRIPT CENTER JOB HAVING START CMD FAILS SQL1131 & MEM ERROR List of APARs that went into WR09086g APAR No. Abstract -------- ------------------------------------------------------- IX86733 DB2SETUP: INSTANCE CREATE FAILS ON AIX 4.3.2 JR12813 DL:EXPORT DATALINKS.ON WINNT/DOS/OS2 NO MKDIR FOR CTRL FILE JR12804 SETXXXSTREAMS BROKEN IN THE 5.2 NET DRIVER IX87377 DASILIST LINK FROM /USR/LPP/DB2_05_00/INSTACE TO ~/BIN DELETED IX87362 OUTER JOIN WITH IN PREDICATE RETURN WRONG RESULT JR12809 MEMORY LEAK IN DB2JD.EXE ON NT (9084) IX87446 UDF NOT MAKING FINAL CALL WHEN IT TERMINATES ABNORMALLY IX87478 SQLUGRPI RETURNS SQLCODE=-6044 JR12819 IMPORT OF CLIENT PROFILE GIVES CCA3002 IX86353 FETCHES LOGGED IN AUDIT CAN GET TOO WORDY JR12414 IMPLEMENT VARIABLE TAPE BLOCK SIZE FOR INTEL PLATFORM IX86368 SQLJMF10 TRAPS WHEN NULL POINTER IS IN DB2RA JR12414 IMPLEMENT VARIABLE TAPE BLOCK SIZE FOR INTEL PLATFORM List of APARs that went into WR09086f APAR No. Abstract -------- ------------------------------------------------------- IX86742 USERID CONTAINING "I" INCONSISTENTLY TRANSLATED WITHIN DB2 IX86987 SLOW INSERT PERFORMANCE ON NON-NUMERIC PARTITIONING KEY IX87048 INTERMITTENT SQL0290 JR12745 SQLBINDPARAM WITH LENGTH 0 USING SQLPUTDATA/SQLPARAMDATA. JR12788 CURRENTSQLID CAUSES CONNECTION TO TRAP TO DB2 / MVS JR12797 NULL INDICATOR NOT BEING RESET FOR JDBC APPS W/ NET DRIVER IX87376 IMPROPER CLEANUP WHEN SQLAOPTIONS FAIL WITH INVALID PREP OPTION IX87387 SCANNING CODE FOR A SELECT W/ OPTIMIZE FOR N ROWS & FOR FETCH O IX85687 IMPROVE DPS SO THAT THE DB2 HANDLES SQLOQQUE FAILURE BETTER. JR12797 NULL INDICATOR NOT BEING RESET FOR JDBC APPS W/ NET DRIVER JR12722 SQL1022C FROM DB2START DUE TO PERFORMANCE SMARTGUIDE SUGGESTION List of APARs that went into WR09086e APAR No. Abstract -------- ------------------------------------------------------- JR12732 V5.2:SQL0956 / SQL1478 AFTER ALTERING V5GA BUFFERPOOLS JR12734 CCA IMPORT FUNCTION ONLY PICKS UP ONE INSTANCE PER SYSTEM JR12753 TRAP IN SQLCCCLOSEENTRIES<> IX86991 EXPORT NOT PARSING MODIFIED BY DELIMITERS PROPERLY IX87061 CORE DUMP WITH THDSRVER.SQC SAMPLE ON DB2CONNECT TO MVS JR12780 IXF IMPORT OF V1 DATA FAILS SYS3175 IN V52, WORKS V2 AND V50 JR12683 BACKWARD FIT OF DEFECT 97937 IX83002 PROBLEM WITH 95064 IX86031 'LIST HISTORY REORG SINCE' DOES NOT REPORT ALL VALID ENTRIES IX86457 DON'T IGNORE SIGUSR1 IN SNA/6000 V3 AND NEWER JR12689 CONTROL MSG CAUSED BY CONVERSION FILES WITH DIAGLEVEL JR12719 FILE_TRANSFER_CMD OF AUTOLOADER.CFG DOESN'T CALL A BATCH FILE. JR12747 JOB RESULT IN CC JOURNAL FOR SCRIPT CENTER JOB IS PARTIAL List of APARs that went into WR09086d APAR No. Abstract -------- ------------------------------------------------------- IX86517 LOAD TRAPS IN BUILD PHASE WHEN UTIL HEAP IS FULL IX86940 DB2LOADREC DOES NOT WORK IF LOAD COPY IS MOVED IX83869 CATALOGING MORE THAN 8 ODBC DATASOURCES FROM SCRIPT GIVE ERROR IX86861 SETNULL TRAPS WITH TIMESTAMP,TIME,DATE,BIGINT AND STREAMS JR12745 SQLBINDPARAMETER() NOT HANDLING ZERO COLUMN SIZE CORRECTLY IX86901 JDBC EXECUTEQUERY() RETURNS NULL IX86966 REMOVE CHECK IN PROBE 70 OF SQLPWRITELR JR12546 NT RESTORE TRAP IX85558 DB2 STILL GETS DATA EVEN IF SQL_ATTR_RETRIEVE_RESULT IS OFF JR12669 SQLSTATE -1106 RECORDED IN DB2DIAG.LOG ON REMOTE IMPORT List of APARs that went into WR09086c APAR No. Abstract -------- ------------------------------------------------------- IX85893 SQL0901 REASON SQLRINREC: FUTURE SHOCK IX86244 USE SQLOINSTANCEPATH() TO REDUCE CALLS TO PASSWORD FILE IX86413 SIG 11 TRAPS IN ERROR HANDLING AFTER SQLRXGET/PUT HIT PROBLEMS JR12731 DDL FOR CREATE TABLE INCORRECT WITH DBNAME IX84079 SQL0859 WHEN UNFENCED STORED PROCEDURE CALLED WITHIN DUOW IX85099 V5.2 GA CLIENTS TRAP WHEN MONITOR HEAP EXHAUSTS JR12614 DB2LOOK DOES NOT WORK AGAINST REMOTE DATABASES JR12618 SYS3175 ON OS/2 WHEN RUNNING A USER EXIT TO BACKUP JR12361 SQLPREPARE HOLDS LOCKS ON SYSTEM TABLES IX85441 IF LIBPATH IS LONG, REMOTE CONNECT WITH TCPIP RETURNS SQL10013 JR12646 OS/2: SQL1038C ON DB2START WHEN USING A FAT FILESYSTEM. JR12715 SQL0193N WHEN ADD A NEW NOT NULL COLUMN WITH DEFAULT AS BLANK List of APARs that went into WR09086b APAR No. Abstract -------- ------------------------------------------------------- JR12594 V501:LOAD/IMPORT FROM ASC TO NOT NULL COLUMN IGNORES NULLINDCHR AND SQL3124W ON LOAD OF ASC FILE WITH PACKEDDECIMAL OPTION IX82027 IMPORT CAN CAUSE HANGS UNLESS YOU DO A CONNECT RESET IX84082 JAVA STORED PROCEDURE CAN ONLY RUN ONCE ON SOLARIS 2.6 IX84950 REMOVE EXPLICIT CALLS TO SET CURSOR_HOLD AND AUTOCOMMIT AS THES JR12613 CRASH RECOVERY PROBLEM: -2775, FFFFF42F. IX84935 EEE: DISTRIBUTED CLOSE FIX IMPROVE UPDATE PERFORMANCE IX85171 DB2 UDB V5.2 EE ON HP11 HAS POOR PERF. WHEN USEING LOAD UTILITY IX85342 SIGNAL #11 IN SQLRA_FIND_SHIP_VAR IX85415 DB2DCPIC_IBM.A NOT THREAD SAFE. IX85645 EXECUTEUPDATE RETURNING -1 FOR WHEN UPDATES IN THE JDBC NET DR. JR12673 INTERNAL TABLE FUNCTION TFNUMLINT AS A COMMON TABLE EXPRESSION JR12666 JR12666: AS/400 NUMERIC INCORRECTLY CONVERTED TO DECIMAL List of APARs that went into WR09086a APAR No. Abstract -------- ------------------------------------------------------- IX85764 SELECT STOPS WORKING AFTER FIXPACK 3 ON NT, GETS -670 JR12355 LOAD ASCII METHOD L WITH BLOB RETURNS SQL3408W FOR WRONG COLUMN IX85192 SQL0902 RC 26 SQLO_NOMEM_UND IN SQLRIUIN IX85286 SQLPARAM DOES NOT WORK PROPERLY WITH DATA TYPES OTHER THEN CHAR List of APARs that went into WR09086 APAR No. Abstract -------- ------------------------------------------------------- IX79991 CLI/ODBC ENHANCEMENT: REPLACING LITERAL WITH PARAMETER MARKER AND REMOVE EXTRA COMMITS (COMMIT ON RETURN MVS SP, CONNECT RESET) IX80640 DB2LOOK REVERSES DLL WHEN PK WAS CREATED ON EXISTING INDEX IX82054 SQL3326 USING DB2ATLD AND COLUMN NAME IS 18 CHARACTERS LONG IX82394 GETTING SQL6107 ON LOAD. DATA HAS BEEN PRE-SPLIT WITH DB2SPLIT. IX82487 SQL1042C ON BACKUP JR12353 RESTORE FROM MULTIPLE DISKETTES FAILS. UDB AND DB2 V2 JR12356 CACHING PROBLEMS ON on NT IX82599 DB2START MAY REMOVE MESSAGE Q 0 JR12267 ADDLLU MARKS THE ONLY LLU AS THE DEFAULT LLU JR12376 LARGE IN CLAUSE TRAPS ON NT WITH A STACK OVERFLOW EXCEPTION IX82970 SIG #11 IN SQLRIDESCRIBEINPUT IX82397 DB2BATCH -O R 0 DOES NOT WORK WITH BLOB OBJECTS JR12509 CLI LAYER CANNOT ACCOMODATE DATE AND TIME FORMAT FOR USA IX83660 ONLINE BACKUP RETURNS SQL2048N DURING MKTABLES WORKLOAD. JR12444 OUTER JOIN ESCAPE CLAUSE IX81525 SQLALLOCSTMT TRAPS DURING MEMORY CLEANUP AFTER OUT OF MEMORY JR12258 -418 WHEN MS ACCESS USES BETWEEN ? AND ? TO MVS IX81831 INDEX BUILD HANGS IX81849 SQLESETC API APPLIED TO WRONG CONTEXT IN MULTITHREADED CLI APP. JR12333 12/98:TRAP IN V5 SERVER FROM DWNLVL CAE/DOS V1.2 CLIENT IX82508 PATCH2=6 DOES NOT PREVENT A SCROLLABLE CURSOR TYPE IX82942 NODENUMBER IN THE ON CLAUSE OF A JOIN QUERY CAUSES A -901 JR12400 SQLGETDATA SUPPORT FOR 2 DIFFERENT DATA TYPES (1:SIZE; 2:DATA ) IX82992 CLI SQLCOLUMNS() RETURNS A COUNT OF ZERO COLUMNS IX83068 DB2AUTOLD LOOPS WHEN LANG=JA_JP JR12410 DB2 UDB TRAPS ON WINNT WHEN QUERY SEMENTICS INCORRECT ORDER BY JR12409 SQL_C_NUMERIC SUPPORT - PHASE I and PHASE II IX83063 NEGATIVEARRAYSIZEEXCEPTION ON EXECUTEQUERY() UPDATE JR12419 ADO: OFFSET PTR CAUSES TRAPS AND UNEXPECTED SQL_NEED_DATA RC IX83180 SQL0956C WHEN RUNNING DB2UIDDL OUTPUT. IX83197 DDB2ATLD MAY USE HOSTNAME FOR SOME COMMUNCATIONS JR12424 NULL INDICATOR NOT BEING RESET IX83238 MTS APPLICATION GET ACCESS VIOLATION IX83272 NEGATIVE RETURN CODE -502 CAUSES TRAP IN SQLJIFSR.C IX83355 LIST APPLICATIONS DOES NOT SHOW THE CORRECT NAME ON NT CLIENT. IX83441 ONLINE BACKUP PLACES IN LOCK ON TEMP TBS. IX83458 PREP RETURNS SQL4920N ON EXEC SQL CALL PROCNAME WITH IX83539 CREATE TABLE FAILS WITH -902 WHEN OUT OF DBHEAP IX83583 LOAD INSERT AFTER MIGRATION CAUSES TABLE CORRUPTION 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 IX83616 QUERY REWIRTE USING VIEWS JR12452 MEMORY LEAK IN DB2CONNECT USING CLI APPLICATION TO HOST JR12467 UNINSTALL DOES NOT REMOVE OS2.OUT BLD.OUT COMP.OUT DIFF.OUT EXTRACT.OUT LC.OUT NOHUP.OUT NT.OUT PAC IX83716 TRAP IN SQLRAGSN WHEN EXPLICIT BIND IS INTERRUPTED IX83732 ROLLFORWARD TO A POINT IN TIME (PIT) GETS A -1042 AND SQLPRFLM SEG FAULT DUE TO ACB NOT PRESENT DURING RECOVERY IX83733 DB21080 - REDIRECT RESTORE IS CASE SENSITIVE TO DB ALIAS JR12473 SQL901 WHEN SELECT AGAINST A VIEW IX83781 SQL0344 WHEN TRYING A SELECT AGAINST VIEW,BASE TABLE DATE/COLM IX84179 DISTRIBUTION STATS CAUSING BAD JOIN PLAN IX83953 THE JDBC LISTENER SHOULD ONLY READ THE INDICATOR VARIABLE IF JR12625 FIX FOR 100GB EASTWOOD/BADGER 4 MLN AUDITED RESULTS SO WE DO NO JR12498 SQLEXECUTE DOES NOT INSERT ALL COLUMNS PROPERLY IX84081 12/98:TRAP IN SQE JR12508 SQL1026N FOLLOWED BY SQL1032N WHEN MANY DB2STARTS ISSUED JR12512 MEMORY ACCESS VIOLATION OR TRAP WITH MULTIPLE ENVIRONMENTS JR12541 REVERT TO WAITING FOR DELETES DURING INDEX SCANS IX84273 THE DB2BATCH TOOL SHOULD TRIM THE TRAILING BLANKS IN OUTPUT JR12538 FOR BIT DATA INSERT OF VARCHAR DOES NOT RETURN CHARACTERS 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 IX84577 CLI0125E ON SQLSETCONNECTATTR IX76365 83177 CONT'D - ENHANCE SINGLE NODE JOIN PARTITION HANDLING AND SLOW PERFORMANCE ON A DB2 UDB EEE PLAN AND FIX 94984 - MISSING A SET OF BRAKETS IX84582 CLP LIST TABLESPACES SHOW DETAIL DOES NOT AUTO-COMMIT IX84565 WARNING SQL0437W CAUSES EXPORT TO FAIL FOR COMPLEX QUERIES. JR12563 HEX(DEGREE)=0X00 IN SYSPLAN AND -901 SQLRISIN DURING EXECUTION JR12569 SMART GUIDE ON NT DOES NOT SHOW MORE THAN 4GB ON SOLARIS JR12572 1) CALLING SQLM_DCS_APP_EXIT BEFORE SQLDBCON GETS FREED IX84760 NULL VALUES DISABLE INSERT BUF IX84780 DB2_ALL HANGS WHEN THERE IS INPUT REQUIRED BY USER IX84907 -3514 MESSAGES LOGGED IN DB2DIAG.LOG DURING LOAD EMPTY FILES IX84795 SQL0901N - SQLNQ_PID::BULDABLE_TREE(300):RC(0) JR12582 DB2 UDB V5.2 TRAPS WHEN THERE IS A TYPO WITH A SCALAR SUBSELECT JR12595 VENDOR: ALWAYS RETURN CATALOG SEPERATOR TO BE '.'LIKE PATCH2=11 IX84896 A PRE 5.2 DB2JAVA.ZIP NET DRIVER CONNECTING TO A 5.2 DB2JD IX84790 SQL10003C ERRORS DUE TO A MEMORY LEAK IX85243 DISABLE DB2ATLD -D IX85266 S LOCKS ON SYSTABLES DURING IMPORT/LOAD JR12505 TABLESPACE LISTING INCORRECT DURING TABLE COPY W/CONTROL CENTER IX84964 LOAD FAILS USING CONTROL CENTRE ON ITALIAN VERSION IX83002 NONRECOVERABLE LOAD CAUSES -1042 ON ROLLFORWARD JR12633 BY DEFAULT SQL_OUTER_JOINS = "Y" USING CAE VER 5.2 JR12634 CLI TO SEND DYNAMIC(NOT STATIC) CALL PROC STATEMENT TO AS/400. JR12649 GET SNAPSHOT FOR LOCKS -- CORRUPTED OUTPUT. JR12592 "SPM0438 THE DB2 SYNCPOINT MANAGER RECOVERY LOG IS BAD" FIX GG03794 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (OS/2) GG03796 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (OS/2) GG03798 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (OS/2) GG03808 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (OS/2) GG03810 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (OS/2) GG03825 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (OS/2) GG03822 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (OS/2) GG03839 APPLY DID AN UNEXPECTED FULLREFRESH (0S/2) GG03795 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (NT) GG03797 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (NT) GG03799 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (NT) GG03800 ASN1053E THE EXECUTION OF THE ASNLOAD PROGRAM FAILED RC6 (NT) GG03805 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (NT) GG03804 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (NT) GG03811 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (NT) GG03826 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (NT) GG03814 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (NT) GG03838 APPLY DID AN UNEXPECTED FULLREFRESH (NT) IX82922 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (AIX) IX83038 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (AIX) IX83041 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (AIX) IX83261 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (AIX) IX83847 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (AIX) IX83850 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (AIX) IX84120 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (AIX) IX84503 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (AIX) IX85653 APPLY DID AN UNEXPECTED FULLREFRESH (AIX) IX82923 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (HP10) IX83039 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (HP10) IX83042 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (HP10) IX83594 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (HP10) IX83848 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (HP10) IX83851 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (HP10) IX84562 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (HP10) IX84504 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (HP10) IX85654 APPLY DID AN UNEXPECTED FULLREFRESH (HP10) IX82924 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (SUN) IX83040 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (SUN) IX83043 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (SUN) IX83595 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (SUN) IX83849 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (SUN) IX83852 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (SUN) IX84563 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (SUN) IX84505 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (SUN) IX85655 APPLY DID AN UNEXPECTED FULLREFRESH (SUN) GG03812 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (OS/2) GG03829 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (OS/2) GG03830 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (OS/2) GG03832 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (OS/2) GG03834 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (OS/2) GG03835 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (OS/2) GG03837 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (OS/2) GG03801 ASN1056E APPLY PASSWORD FILE COULD NOT BE OPENED - ERROR CODE IS 215601 (NT) GG03792 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (NT) GG03807 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (NT) GG03802 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (NT) GG03831 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (NT) GG03833 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (NT) GG03836 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (NT) GG03806 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (NT) IX83970 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (AIX) IX84867 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (AIX) IX84871 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (AIX) IX84898 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (AIX) IX85142 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (AIX) IX85196 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (AIX) IX85508 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (AIX) IX83969 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (HP10) IX84868 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (HP10) IX84872 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (HP10) IX84899 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (HP10) IX85143 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (HP10) IX85199 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (HP10) IX85509 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (HP10) IX82548 COLD START ENHANCEMENTS FOR SQLCODE964 (SUN) IX83968 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (SUN) IX84870 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (SUN) IX84873 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (SUN) IX84900 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (SUN) IX85144 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (SUN) IX85200 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (SUN) IX85510 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (SUN) GG03803 SQLCODE407 - ASSIGNMENT OF A NULL VALUE TO A NOT NULL COLUMN IS NOT ALLOWED OCCURS WHEN WILD CARD CHARACTER NOT USED IN BUILDDB (NT) GG03813 PRUNING CONTROL ROWS GET DELETED IN V5 IF THE V1 SUBSCRIPTION HAS RUNMODE EI STATEMENTS THAT ARE OMITTED IN V1 TO V5 MIGRATION (NT) GG03821 ASN2769E SQLCODE518 - DPROPR MIGRATE PROGRAM FAILS WITH SQLCODE518 WHEN MIGRATING PRUNING CONTROL TABLE (OS/2) GG03819 SQLCODE407 WHEN MIGRATING CAPTURE FROM V1 TO V5 AND ABOVE (OS/2) GG03817 ASN2748E ASNMIG PREPARE ENDS UNSUCCESSFULLY (OS/2) GG03816 SQLCODE407 - ASSIGNMENT OF A NULL VALUE TO A NOT NULL COLUMN IS NOT ALLOWED OCCURS WHEN WILD CARD CHARACTER NOT USED IN BUILDDB (OS/2) GG03820 PRUNING CONTROL ROWS GET DELETED IN V5 IF THE V1 SUBSCRIPTION HAS RUNMODE EI STATEMENTS THAT ARE OMITTED IN V1 TO V5 MIGRATION (OS/2) List of APARs that went into WR09076 APAR No. Abstract -------- ---------------------------------------------------------- IX67258 DB2 THINKS APPLICATION IS MULTI THREADED JR11049 OBSOLETE DBMON TCB'S LEFT AFTER DATABASE PAUSE JR11013 RESTORE VIA USEREXIT WITH DIFFERENT INSTANCE NAME FAILS JR11025 SQLPRIMARYKEY/SQLFOREIGNKEY LOCKUP SYSTABLES IN AUTOCOMMIT MODE JR11073 SQL0332N - CODEPAGE CONVERSION BETWEEN 500 AND 1275 IX71266 SQL10013 - ON SIXTH INVOCATION OF STORED PROCEDURE IX70033 SQLSETENVATTR WITH SQL_ATTR_OUTPUT_NTS NOT WORKING PROPERLY WHEN IT SET TO SQL_FALSE IX71104 DB2BATCH CORE DUMPS WHEN USING -CLI AND -O WITH P > 1 EX: DB2BATCH -D SAMPLE -F -O P 3 -CLI JR11261 DB2 COMMON SERVER - 'INTERSECT ALL' RETURNS TOO MANY ROWS. JR11296 MEMORY LEAK IN JDBC APPLICATION DRIVER WITH SETSTRING/GETSTRING IX72507 VARCHAR FIELD IS PADDED WITH @ SIGNS WHEN USING JDK 1.13 WITH NATIVE THREADS CONNECTION TO MVS IX71837 USING FOR BIT DATA AND NORMAL CHAR TYPES IN A MERGE JOIN LEADS TO INCORRECT OUTPUT. JR11337 SQL3401 SQLGIMP COBOL API DOES NOT IGNORE FILLER BYTES IX71996 LOAD INTO A TABLE ALIAS FAILS WHEN RETRIEVING COLUMN DEFAULTS JR11325 THE CLI ARRAY INPUT PROCESSING IS BROKEN WHEN A SQLVAR SPILLS THE REQUESTER IO BLOCK SIZE. IX72365 IMPORT .. OF DEL MODIFIED BY CHARDEL '' RETURNS SQL3017 FOR UDB, REGRESSED FROM V2 JR11319 OS2 V3 ODBC DRIVER NOT SUPPORTED BY V2 DRIVER MANAGER IX72390 DB2 UDB - WITH THE EVENT MONITOR ON MEMORY OVERWRITE OCCURS WITH SQL STATEMENTS > 4K. IX72451 RESTORING V2 BACKUP IN V5 PLACES MESSAGE IN DIAG FILE THAT TABLSPC 0 BUFF POOL 0 DOES NOT EXIST MAPS TO BUFFPOOL 1. IX72404 SQLOPENBPF PROBE 920 DURING BACKUP JR11344 CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE JR11363 CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE JR11374 SETNULL METHOD HANDLED INCORRECTLY FOR INPUT/OUTPUT PARAMETER JR11394 SQLPROCEDURE COLUMNS RETURNS COLUMNS IN THE WRONG ORDER JR11395 HIDE EXTENDED FETCH CAPABILITY IX73014 SQLCANCEL IN JDBC DOES NOT WORK AS IT IS SERIALIZED. IX73543 INDEX CORRUPTION AFTER V2 DB MIGRATED TO UDB AND ALTERING VARCHAR COLUMN LENGTH IX73231 QUERY WAS GETTING VERY BAD PERFORMACE IN A QUERY WHEN RUNSTATS FOR A TABLE WAS RUN WITH DISTRIBUTION. IX61374 CICS/6000 TERMINATES AFTER BAD XACLOSE USING DDCS/6000 IX71898 INCORRECT OUTPUT FOR FUNCTION LOG10 JR11388 CLP LOAD REPLACE (CODEPAGE 1252) WITH IXF FILE (CODEPAGE 850) BRINGS DOWN DB2 IN NT JR11724 SQL30082N RC=0 WHEN USING SECURITY SAME IN DB2 NODE DIRECTORY IX72787 WHEN NO DEACTIVATE COMMAND ISSUED BEFORE DB2STOP ON AN ACTIVATED DATABASE CAN LEAVE PAGE CLEANERS AND PREFETCHERS ORPHANED. IX73168 DB2 V5 EEE GA CODE. POINT IN TIME TABLESPACE RECOVERY PROBLEMS. JR11428 CLI0002W DATA TRUNCATED. SQLSTATE=01004 {SQLDRIVERCONNECT} WHEN CONNECT STRING IS LONGER THAN 254 CHARACTERS IX73249 OUTBOUND APPLICATION ID PROVIDED BY DB2 LIST DCS APPLICATIONS SHOW DETAIL IS IN INCORRECT FORMAT IX73564 INVALID USE OF PTHREAD_CLEANUP_PUSH() AS THREAD EXIT HANDLER. IX73443 LOAD LOGIC SHOULD BETTER HANDLE RCF FLAG VALUES IX73537 DB2 V5 EEE: ENABLE AUTOLOADER > 2 GIG FILE SUPPORT JR11471 SQL_ATTR_CONCURRENCY ATTRIBUTE INCORRECTLY SET TO READONLY FOR A FORWARD_ONLY CURSOR JR11483 DB2 UDB: DB2 OBJECTS DO NOT SHOW UP IN NT PERFORMANCE MONITOR WHEN THE DBM CFG PARAMETER INTRA_PARALLEL IS SET TO YES. IX73675 DB2AUTOLD DOES NOT HANDLE COLUMNS STARTING WITH 'MODE' CORRECTLY IX73768 V5 EEE VERSION OF DB2LN DOES NOT SUPPORT DB2 PE V1.2 JR11502 PATCH KEYWORD IN DB2CLI.INI TO OVERRIDE OTHER SETTINGS JR11508 DB2CONNECT TO SUPPORT LOCAL DATE IX74918 PERMISSION DENIED ON HA TAKEOVER ON THE PARTITION TAKING OVER JR11348 LOAD OF SOME IXF'S TRAPS JR11526 NLJN DOES NOT PRODUCE OPTIMUM ACCESS PLAN COMPAIRED TO V1 IX73986 DB2 AGENT LOOPS ON A SNA RECEIVE WAIT AFTER HOST RETURNS 'AGENT PERMINANT ERROR REPLY MESSAGE'. JR11535 JDBC DRIVER CLI0608E USING GERMAN CODEPAGE IX73998 MEMORY OVERWRITE DURING INDEX CREATION DUE TO VARIABLE NOT LARGE ENOUGH TO HOLD PACKED DESCRIPTOR VALUES IX74044 SIGNAL #11 WHEN LOADING IN TABLE WITH 304 COLUMNS IX74232 CANNOT MIGRATE INSTANCE TO V5 IF REMOTE DATABASES CATALOGED JR11562 V5 CLIENT SHOULD NOT USE DEFERRED PREPARE WHEN GOING TO V2 V2 SERVERS (TURN IT OFF) IX74491 ADD PATCH FOR NETSCAPE LIVEWIRE TO IGNORE THE PROCSCHEMA ARGUMENT JR11577 TRANSLATE FUNCTION RETURNS -901 ON KOREAN CHARS JR11593 CLI PARSING PROBLEM ON 'SELECT'. RETURNS -518. IX73248 WHEN DISABLEMULTITHREAD IS SET TO 0 IN THE DB2CLI.INI FILE THERE EXISTS A MEMORY LEAK IN THE SQO LAYER WHEN USING CLI JR11624 SQLROWCOUNT RETURNS INCORRECT VALUE (0) AFTER UPDATE JR11629 PATCH1=1 CAUSES COUNT(DISTINCT COL) TO FAIL. IX74895 CURSOR NOT CLOSED WITH SPECIALCOLUMNS CALL ON NON INDEX TABLES IX74896 V5 CLP INCORRECTLY SETS SQLERRD STRUCTURE TO ZEROS FOR SELECT IX74904 SQLDRIVERCONNECT PROMPTS WHEN UID AND PWD IN DB2CLI.INI JR11651 'DB2 PREP TARGET IBMCOB' GIVES UNPREDICTABLE RESULTS. IX75101 FAILURE IN SQLDIOSR - NO ROOM IN SPECIFIED PAGE FOR OBJECT ID IX75217 CLI PROBLEM WITH HY009 / S1009 IX75695 JDBC APPLICATION DRIVER SHOULD NOT FREE THE ENVIRONMENT IF IT IS GARBAGE COLLECTED JR11503 A CONTROL CENTER SCHEDULED BACKUP FAILS WITH SQL2040N-- INVALID DB ALIAS, ON NT. JR11316 THE UNINSTALL ON THE WINDOWS PLATFORMS REMOVES THE REGISTRY ENTR IES OF PRODUCTS THAT WE DID NOT INSTALL LIKE WALLDATA RUMBA JR11421 'REFERENCED MEMORY CANNOT BE READ' ERROR AS A RESULT OF LOOPING ON LOADLIBRARY/FREELIBRARY OF NT KERNEL DLL'S JR11722 INTERMITTENT DB2 TRAP IN FUNCTION SQLRIRETURNSUBSTRCSOBYTES OR SQLOFMBLK GG03680 APPLY HANGS AND GENERATES C00005 EXCEPTION GG03681 UPDATE TO CCD NOT REPLICATING CORRECTLY GG03690 APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITHOUT CONTROL SERVER GG03691 APPLY FAIL WITH ERRCODE 8C0101 SQLCODE104 SQLSTATE 42601 GG03693 APPLY CONSUMES TOO MUCH SYSTEM RESOURCES WHEN SLEEP_MINUTES IS 0 IC19729 ASNSERV.EXE WAS NOT SHIPPED WITH DATAJOINER FOR NT V210. GG03696 APPLY LOOPS WHEN LASTSUCCESS IS GREATER THAN 1 MONTH OLD FROM CU RRENT DATE GG03685 APPLY V5 IS NO LONGER HOLDING THE CRITSEC LOCK WHILE IT FETCHES THE CD ROWS - IT COMMITS AFTER IT GETS THE SEQUENCE NUMBERS GG03687 ASN1051E 4A5102 THE ONLY WAY TO EXIT FROM A GAP SITUATION WHEN USING INTERNAL CCD IS TO MANUALLY UPDATE DPROPR CONTROL TABLES IX72725 CORE DUMP RUNNING APPLY/HP AND ABEND IN APPLY/MVS GG03686 OF 26 SOURCE TABLES AND REPLICAS FOR UPDATE-ANYWHERE ONLY FIRST 20 TABLES ARE PROPAGATED - SQLCODE2038 MAY OR MAY NOT BE SEEN GG03692 WHEN A LARGE OBJECT OCCURS IN THE BASE TABLE AND IS NOT REGISTERED , CAPTURE FAILS WITH PROTECTION FAULT GG03695 CPU RESOURCE UTILIZATION IS TOO HIGH FOR NT PLATFORM GG03694 CPU RESOURCE UTILIZATION IS TOO HIGH FOR OS/2 PLATFORM IX72517 AN ALTER ADDED TIMESTAMP CAUSES SQLCODE180 IX75150 CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS IX75933 OF 26 SOURCE TABLES AND REPLICAS FOR UPDATE-ANYWHERE ONLY FIRST 20 TABLES ARE PROPAGATED - SQLCODE2038 MAY OR MAY NOT BE SEEN IX75151 CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS IX74453 CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS JR11568 ASN2703E SQLCODE1001E DURING MIGRATION OF CAPTURE FROM V1 TO V5 INCORRECT CONNECT TO LOCATION NOT DB ALIAS DURING BUILDDB IX71439 LOOPING FENCED UDF NOT CLEANED UP JR11208 TRAP AFTER MANY SEQUENTIAL BACKUPS IX72460 DB2ADUTL DOES NOT USE THE ADSM PASSWORD SET WITH DSMAPIPW IX72350 TRIGGERS IN A SUBQUERY PREVENT OPTIMIZER FROM REWRITING SUBQUERY AS A JOIN. IX72697 PROGNAME VARIABLE CAUSES LINKER MESSAGES IX73445 ONLY LOG SEVERE ERRORS IN SQLDLOADTCBOBJDESC JR11417 ROW DATA BEING SENT WITH SQL100 CONFUSES DRDA AR WHEN CONNECTING TO DB2 ON OS/2 AS THE DRDA AS JR11422 DB2STOP HANG AFTER A FORCE APPLICATION ALL WITH ACCESS FEATURE. JR11433 LOG CORRUPTION WITH '504' MESSAGES IN DB2DIAG.LOG FILE IX68617 RESTORING DB2/6000 V2.1 DATABASE (WITH RAW DEVICE CONTAINERS) TO NEW AND GETTING DB2DIAG.LOG ERRORS WITH THE CONTAINERS. JR10975 LOAD TABLE FROM AN IXF ENCOUNTERED -3314N IX73368 DB2BATCH IN V5 (EVEN WITH FIRST FIXPACK) APPLIED RETURNS INCONSISTENT TIMING SUMMARIES WHEN MULTIPLES STATEMENTS ARE USED IX73417 DB2 UDB SQL1090 ERROR MESSAGE IS MISLEADING. JR11585 PROBLEM WITH LIST APPLICATIONS SHOW DETAIL - CHANGE STATUS TIME IX73875 SELECT CAUSES THE UDB INSTANCE TO GO DOWN JR11547 BACKUP TO ADSM SENDING WRONG OBJNAME.LL FROM UNINITIALIZED SQLU_MEDIA_ENTRY STRUCTURE(POINTED TO BY MEDIA_LIST.TARGET.MEDIA IX74523 SQR NOT MAPPING INTERNAL ERROR TO CLP CORRECTLY IX74524 LIST APPL. CMD FAILED AFTER TWO SUCCESSFUL CONCURRENT LOADING IX74582 INCORRECT OUTPUT IN LIST RECOVERY HISTORY FOR 'Q' OPERATION IX73521 DB2 UDB: DB2START RESULTS IN SQL1092N WHEN INSTANCE OWNER ID ON AIX HAS LOGIN=FALSE OR RLOGIN=FALSE IX74848 DB2STOP DOES NOT STOP ON LARGE NUMBER OF NODES - TIMES OUT IX75047 DB2LOOK FAILS WITH SQL0811 JR11647 MEMORY LEAK IN ODBC/CLI LAYERS IN 9014 FOR NT IX74915 ON AN SMP SOLARIS DB2 UDB, CONCURRENT LOADS RESULTS SQL1224. IX75587 PERFORMANCE DEGRADES GOING FROM COMM_BANDWIDTH 1 TO 100 IX75630 RECEIVE SQL0502 WHEN GOING TO A V2 DATAJOINER BECAUSE OF CHAINED AUTOCOMMIT IX75640 CREATE NODEGROUP RECEIVES -901 FROM SQLRKANG_CBP_I - FFFFFA604 IX72355 A TRAP WITHIN A STORED PROCDURE IN SQLE_MRSP. DB2SYSC CORE DUMP IX73136 A PASSWORD DEFINED WITHIN NIS+ WITHIN SOLARIS CANNOT BE AUTHENTI CATED BY DB2 JR11043 CONNECT TO HOST HANGS WHEN USING SYNCPOINT TWOPHASE JR11497 CONTROL CENTER DISAPPEARS ON CLICKING 'FIND' - ARABIC CODEPAGE JR11677 TRYING TO ADD A NEW SYSTEM IN CC WITH NO INSTANCES CRASHES JR11390 SQL2015 ERROR IS RETURNED WHEN CUSTOMER TRIES TO ISSUE 'CONTINUE RESTORE' V1 REXX API AFTER 'RESTORE ...' API RETURNS A WARNING. IX76273 DB2 UDB - LOAD HANGS WHEN DMS TABLESPACE FILLS UP IX76624 DB2/EEE V500 ON AIX. SIGNAL #11 IN BUFFER POOL SERVICES. JR11638 CUSTOMER CAN CONNECT FROM A V5 CLIENT TO A V2.1.2 DB WITH NO PROBLEMS. CUST RECEIVES SQL1402 WHEN ATTEMPTING A REMOTE ATTACH. IX74997 LOG FILES NOT ARCHIVE AFTER CRASH RECOVERY. JR11553 FLOATING POINT DATA TYPE RETURNS WRONG VALUE IX74229 REMOVING TRAILING PERIOD FROM DECIMAL TO CHAR. IX74969 DB TAPE RESTORE VIA CONTROL CENTER FAILS WITH SQL2042W I/O ERROR 2060 IX74540 CUST CAN'T RUN SCRIPT STORED ON SERVER FROM SCTRIPT CENTER USING RUN NOW ... OPTION. GG03707 SQLCODE206 WHEN COPYING TO CCD GG03699 SQLCODE206 WHEN COPYING TO CCD GG03700 MAX_SYNC_MINUTES VALUE OF ZERO OR LESS MEANS NULL GG03701 POSSIBLE MISSING DELETE UPDATES WHEN MORE THN 100 T GG03702 SUPPORT 18 BYTE COLUMN NAME WHEN BEFORE_IMG_PREFIX I GG03703 LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED GG03704 ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED B IX74529 APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITH IX76735 MAX_SYNC_MINUTES VALUES OF ZERO OR LESS MEANS NULL JR11484 INTERMITTENT TRAP IN SQLUBINITPROCESS DURING BACKUP JR11810 UDB NT TAPE RESTORE RETURNS SQL2530 -- IMAGE CORRUPT. IX74871 IN LOCK WAITS FOR X LOCK IX76127 DB2 RESTART DATABASE FAILS WITH SQL1042 DUE TO -4015 IX75242 ROLLFORWARD TO PIT OF A TABLESPCE RECIEVED A -1042 SQLCODE IX75463 INCORRECT NODE NUMBER IN BACKUP NAME IN ADSM IX75609 LIST APPLICATIONS CORRUPTS APP ID FOR LONG APP NAMES IX75642 DB2 RESTART FAILS AFTER HITTING EOF ON BUFFER POOL FILE(S) - FFF FF609 IX76438 ALTER TABLE RESULTS IN SQL902,126 ON DB2 UDB IX75688 DB2 SHOULD USE 'LSATTR' COMMAND TO DETERMINE MEMORY IN AIX IX75687 UNABLE TO RESTORE FROM A BACKUP TO ADSM USING MULTIPLE OPEN SESSIONS. IX75909 DB2 BRINGS DOWN INSTANCE AFTER A DYNAMIC SQL DOES NOT CLEAN UP P ACKAGES IX75945 IGNORE SQL0000W GENERATED BY POWER BUILDER APPLICATION AFTER CLI0165E ERROR 'ERROR IN ROW' IS DISPLAYED BY APPLICATION. JR11726 SPORADIC TRAPS IN SQLNQ_TABSEL_OFN_CM JR11737 DSN FIELD TRUNCATED TO FIRST LETTER IN CLI CONNECTION STRING JR11741 UNABLE TO IMPORT A CLIENT CONFIGURATION WITH CLIENT CONFIGURATIN ASSISTANT (CCA) IX76159 DB2 AUTOLOADER DOES NOT WORK WITH DUMPFILE OPTION ON MLNS IX76172 STATEMENT OBJECT CREATED BY GETBINARYSTREAM IS NOT GETTING CLOSED IX76236 SIGNAL #11 IS SQLRLLPD WHEN DROPPING TABLESPACE AND THERE ARE AND A LARGE NUMBER OF TABLES (OVER 6000) JR11763 ERROR IN CCA WHEN PRESS 'ENTER' INSTEAD OF USING MOUSE JR11773 SQL0437W CAUSES OPEN IN DEFERREDPREPARE TO BE OMITTED IX76443 PERFORMANCE PROBLEM OF A SELECT WITH AN ORDER BY JR11834 ASYNCRONOUS READ REQUESTS AND ISSUEING INTERRUPTS. IX77873 V5 FIX FOR V2 APAR IX76471. PERFORMANCE ENHANCEMENT FOR INSERT/ UPDATE BY IMPROVING FREE SPACE CONTROL MAP SCANS. IX76678 SQL1042 ON GET SNAPSHOT FOR APPLICATIONS ON SOLARIS 2.5.1 WITH SUN PATCH 104283 OR SOLARIS 2.6 JR11802 LARGE SQL STATEMENT USING DEFAULT AGENT_STACK_SZ =16 CAUSES STAC K OVERFLOW EXCEPTION ON NT IX77137 RUNSTATS WITH DISTRIBUTION PICK INCORRECT PLAN JR11818 DISABLEMULTITHREAD=1 IS NOT READ FROM DB2CLI.INI JR11821 WHEN SQL_ROWSET_SIZE>1, SQLGETDATA REPORTS INVALID CURSOR POS. IX76922 KEYWORD DATALINK IX76924 STAR JOIN DISQUALIFIED FOR STAR JOIN ELIGIBLE QUERY JR11824 TRAP IN DOSCALL1.DLL DURING CTRL-C IX77399 CRASH RECOVERY ENDS TOO EARLY. IX77067 SUN BACKING OFF FIXPAK #3 AND USING DB2IUPDT CAUSES FATAL ERROR DUE TO INCOMPATIBLE LEVELS OF CODE JR11841 SQL_OJ_CAPABILITIES DOES NOT RETURN THE PROPER INFORMATION IX77154 OUTER JOIN IN LIST PREDICATE OPTIMIZER PROBLEM IX77398 CANNOT BACKUP TO MVS TAPES VIA CLIO/S BECAUSE UDB WILL NOT ALLOW A BACKBUFSZ OF 8 IX77400 SQL.H MISSING SQL_QUERYOPT CONSTANTS FOR 2 AND 7 IX77480 DIAGNOSTIC CODE FOR NLI SITUATIONS AND BPS PROBLEMS IX77409 NIS CHECK FAILS DURING INSTALL OF ADMIN SERVER IX77439 SQL30081N ON SECOND CONNECT THROUGH SYSPLEX SERVER IX77672 INDEX CORRUPTION AFTER MIGRATING TO V5 IX77494 DB2 UDB LOAD COMMAND USING 'MODIFIED BY DUMPFILE' AND CPU PARALLISM > 1 RESULTS IN AN INCOMPLETE DUMPFILE. IX77672 DB2DART CHANGES FOR C. MCARTHUR'S INDEX TOOL IX77776 ON INDEX REBUILD SQL0404 DUE TO INCORRECT INDEX PACKED DESCRIPTOR UPDATE AFTER ALTER COLUMN IX77703 SQL1478W ON CONNECT AFTER ALTER BP AFTER FP3 IX77706 DB2START.PROCID.DAT FILES NOT BEING REMOVED FROM FILESYSTEM. THESE FILES ARE GENERATED FOR EVERY DB2START. JR11773 SQL0437W CAUSED OPEN FUNCTION TO BE SKIPPED IN DEFE JR11904 CHECK FOR IP ADDRESS BEFORE HOSTNAME FOR WIN95 TCP/IP JR11914 MIGRATING V211 DATABASE FAILS WHEN TRYING TO CONVERT HIGH2KEY AN D LOW2KEY VALUES IX78176 DB2LOOK DOES NOT EXTRACT TABLESPACE INFORMATION FOR TABLESPACES WHICH HAVE NO TABLES DEFINED WITHIN THEM IX78232 SQLBRESERVEFILETOKEN IN DB2DIAG.LOG FID TIMING PROBLEM JR11928 DB2 CONNECT HAS INTERMITENT PROBLEM LOGGED IN THE DB2DIAG.LOG: GATEWAY_DRDA_AR SQLJDRD1 PROBE:11, DIAGDATA = 34FF FFF JR11727 SQLCODE612 WHEN SUBSCRIBING TO A TABLE WITH A COLUMN NAME GREATER THAN 17 CHARACTERS OR SQLCODE107 JR11728 CONTROL CENTER LOCKS UP EXPANDING NODE OR DATABASE OBJECTS ON OS2 WARP SMP MACHINES. JR11760 THE UDB CONTROL CENTER HAS NO WAY TO SPECIFY S TO INDICATE THAT SQL BEFORE SHOULD BE RUN AT THE SOURCE SERVER JR11861 CONTROL CENTER CONNECTS TO CONTROL SERVERS OF SUBSCRIPTION SETS ORIGINATING FROM THE SOURCE DATABASE AND NOT ALL SERVERS JR11870 JOIN OF FULL REFRESH REPL. SOURCE DOESN'T CREATE NEW SOURCE IX77979 APPLY MAY COPY UNCOMMITED DATA JR11899 CAN'T VIEW OR SET CURRENTSQLID FROM CLIENT SETUP GUI IX77572 RECYCLING SCRIPT CENTRE DOESN'T ALLOW MORE SCRIPTS TO BE RUN JR11878 USER COUNTS GET MESSED UP WHEN THEY EXCEED THE MAXIMUM NUMBER JR11917 SQLCOLUMNS DOSE NOT RETURN COLUMN_DEF IX78479 BAD RETURN CODE FROM SQLOSSEMACCESS BRINGS INSTANCE DOWN IX78334 SQL0104 NOT BEING HANDLED PROPERLY IX78499 NUM_AGENTS IS INCORRECT ON LONG RUNNING SYSTEM IX78509 MEMORY LEAK IN SQLRKAIN() WHEN DOING AN IMPORT WITH -973 JR11953 SAP ARRAY INSERT TRAPS JR11917 SQLCOLUMNS DOES NOT RETURN DEFAULT DATA IX78555 IFOR_LS.CLIENT.BASE REQUISIT MISSING ON AIX 4.3 IX77770 SQL1704N RC=8 ON DATABASE MIGRATION FROM DB2 V2 TO V5 ON HP-UX IX73249 TWO SPM FIXES FOR V5.2 BETA AND V500 JR11597 6/98: RETROFIT FIXES FOR 81188 INTO FIXPAK RELEASE GG03725 DPROPR CAPTURE, STL CMVC LEVEL GG00888 JR11940 MVS GRAPHIC() COLUMN INCORRECTLY MAPPED TO UDB UDB CHAR() IX78558 DPROPR APPLY, STL CMVC LEVEL PQ16105 JR11917 DPROPR DOESN'T RECOGNIZE COLUMNS DEFINED WITH DEFAULT JR11958 CC CRASHES WHEN CHANGE SYSTEM WITH SYSTEMNAME > 21 CHARS IX78463 DPROPR CAPTURE, STL CMVC LEVEL GG03708.4 JR11498 V501 SQL2503N FROM DB2RESDB RESTORING V1 DATABASE TO V5 GG03707 SQLCODE206 WHEN COPYING TO CCD GG03709 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION GG03711 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY GG03713 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING GG03715 APPLY MAY COPY UNCOMMITED DATA GG03717 (APPLY FOR OS/2) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT GG03718 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED GG03720 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD GG03722 (APPLY FOR OS/2) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS GG03723 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET GG03724 MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL GG03731 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH GG03734 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE GG03699 SQLCODE206 WHEN COPYING TO CCD GG03700 MAX_SYNC_MINUTES VALUE OF ZERO OR LESS MEANS NULL GG03701 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET GG03702 SUPPORT 18 BYTE COLUMN NAME WHEN BEFORE_IMG_PREFIX IS SPECIFIED GG03703 (APPLY FOR NT) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT GG03704 (APPLY FOR NT) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS GG03710 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION GG03712 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY GG03714 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING GG03716 APPLY MAY COPY UNCOMMITED DATA GG03719 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED GG03721 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD GG03732 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH GG03735 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE IX74529 (APPLY FOR AIX) APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITHOUT CONTROL SERVER SPECIFIED IX76735 MAX_SYNC_MINUTES VALUES OF ZERO OR LESS MEANS NULL IX77970 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION IX77973 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY IX77976 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING IX77979 APPLY MAY COPY UNCOMMITED DATA IX78127 (APPLY FOR AIX)LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT IX78163 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED IX78166 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD IX78169 (APPLY FOR AIX) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS IX78183 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET IX78558 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH IX78760 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE IX77971 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION IX77974 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY IX77977 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING IX77980 APPLY MAY COPY UNCOMMITED DATA IX78128 (APPLY FOR HP) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT IX78164 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED IX78167 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD IX78170 (APPLY FOR HP) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS IX78184 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET IX78186 MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL IX78559 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH IX78761 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE IX77972 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION IX77975 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY IX77978 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING IX77981 APPLY MAY COPY UNCOMMITED DATA IX78130 (APPLY FOR SUN) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT IX78165 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED IX78168 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD IX78171 (APPLY FOR SUN) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS IX78185 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET IX78187 MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL IX78560 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH IX78762 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE GG03698 (CAPTURE FOR OS/2) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED GG03726 (CAPTURE FOR OS/2) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION GG03729 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS GG03697 (CAPTURE FOR NT) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED GG03708 LONG VARCHAR SUPPORT GG00888 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS GG03725 (CAPTURE FOR NT) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX75332 (CAPTURE FOR AIX) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED IX77129 LONG VARCHAR SUPPORT IX78408 (CAPTURE FOR AIX) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX78463 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS IX75975 (CAPTURE FOR HP) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED IX78409 (CAPTURE FOR HP) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX78464 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS IX75976 (CAPTURE FOR SUN) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED IX78410 (CAPTURE FOR SUN) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX78465 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS JR11735 NETBIOS LOOPS WHEN MAXNBSESSIONS IS REACHED IX76914 OVERTYPING ODBC DATASOURCE IN "CONNECTING TO DB2 DATABASE" TRAPS JR11905 SQLNUMRESULTCOLS RETURNS FUNC SEQ ERR AFTER TIMEOUT IX78630 SQLNUMRESULTCOLS() CAUSES SQLEXECUTE() TO GET SQL0301N, 07006 JR11972 JDBC METADATA GETTABLES RETURN NULLPOINTEREXCEPTION JR11981 STATIC CURSOR DOES NOT RETURN PROPER INFORMATION IX78836 ALTER TABLE ... NOT NULL DEFAULT CURRENT TIMESTAMP FAILS -193 IX78903 ARRAY INPUT FOR BLOB COLUMN INSERTS WRONG DATA IX78981 AUTHID NOT FILLED IN ACB CP OF AUTHINFO 4 INTRMDRY IN 2HP SCN IX79090 CHECK IN PROPER VERSION OF SIGNAL HANDLER IN JDBCSERVER.C IX78760 DPROPR APPLY, STL CMVC LEVEL PQ16384 JR11990 JOURNAL ALERT DATES NOT SORTING PROPERLY JR11999 EVENT ANALYZER TIME INCORRECT WHEN NT TIME IS GMT JR11952 THIN CLIENT INSTALL TO LOOK FOR ODBC FILES IN THE CUR. DIR. IX78710 EXPORT OF 167 MILLON ROWS RETURNS SQL2003 JR12040 TRAP IN SQLNO_FINAL_PHASE EXECUTING QUERY JR11872 CS ISOLATION ALLOWS UNCOMMITED READ ACCESS WITH W LOCK ON ROW. IX78975 LOAD FAILS WITH -911 RC=68 WHEN TIMEOUT = 10S JR12072 LEFT OUTER JOIN RETURNING WRONG RESULTS IX78963 INCORRECT QUERY RESULTS WITH STAR JOIN IX79235 INTERMITTENT SIGNAL 11 IN SQLULUMW JR12067 HOST VARIABLES WITH NAME LONGER THAN 18 CAN GET VALUE CLOBBERED JR12070 MEMORY LEAK IN DB2SYSC WHEN BPS INITIALIZATION (SQLBINIT) FAILS IX79301 RETROFIT 83898 TO DB2_V500 JR12093 FILTER FACTOR OFF AND NO FREQUENCY STATS ON VARCHAR COLUMN IX79867 CONNECTION TERMINATED AFTER -911, RETROFIT D83085 JR12010 GPF IN JOUNAL ON NT VIEWING JOB HISTORY FILE FROM LOAD JR12035 OPTIONS DROP AND REMOVE TRANSLATED WRONG INTO SPANISH IX79591 DPROPR APPLY, STL CMVC LEVEL PQ17223 JR12005 INTERMITTENT TRAP IN SQLODUMPEDU IX76680 SAMPLE JAVA STP RETURNS SQL10012 ON SUN sample java stp returns sql10012 on SUN IX74116 SAP: PATCH LF CORRUPTION BUG WITH DISK_PARALLELISM. JR11921 \n CHARACTER CAUSES SQL0518 WHEN BEFORE/AFTER SELECT KEYWORD IX79865 CLI0602E MEMORY ALLOCATION ERROR IN JDBC NET DRIVER WITH CLOBS IX76680 DEFINE SQLEJ_DB2JEXT_JVMSTOP IN SQLEJAVA.H ON ALL PLATFORMS GG03725 ISSUE WARNING FOR TABLE W/BEFORE-IMAGE AND 18-BYTE COLUMN NAMES JR12038 SQl4414 FOR LOCAL OPERATIONS IN CC WHEN ADMIN INSTANCE ACTIVE. IX80098 JOURNAL JOB HISTORY TIMESTAMPS GET OUT OF SYNC JR12007 JR12007: SQLCODE100 UDB DOESN'T INITIALIZE PHYS_CHANGE_OWNER JR12000 MULTITHREADED APPLICATIONS TRAP IN UDB AND HOT: TRAP WITH INVALID STMT HANDLE IX79213 LOADING TABLE HANGS INTERMITTANTLY IX80087 HOT:INCORRECT RESULTS RETURNED FROM AN SQL QUERY AFTER RUNSTATS IX78867 DB2 SHOULD NOT ACCEPT FORCE EXPIRED PASSWORDS IN NON-AIX UNIX IX77572 AIX: PROBLEM WITH RUNNING A SCRIPT NOW AFTER SCHEDULED JOB IS R JR12032 BUG CAUSING SQL1109 WHEN SPECIFYING A SCHEMA IN THE CALL STMT JR12169 MIGRATION OF THE NODE DIRECTORY FAILED JR12143 HOT :MEMORY LEAKS ON NT AFTER DISCONNECT JR12220 LOAD DOES NOT ALLOW CHARACTER DELIMITING AS A PRIORITY. JR12227 BEFORE SELECT IS CAUSING SQLEXECDIRECT TO FAIL JR12240 DEFECT 83823 BREAKS EXECUTION OF STORED PROCEDURES ON NT, OS/2 IX79292 SIGNAL #11 IN DB2LRID WHEN LOAD TERMINATES IX79456 12/98 FORCE APPLICATION CRASHES DB2 WHEN BUFFERED INSERTS IX81832 -902 ON SET EVENT MONITOR COMMAND IX81761 IF DB2AUTOLD FAILS, IT STILL RETURNS A 0 RC TO THE SHELL IX81764 DB2ATLD DOES NOT RETURN NON-ZERO RC EVEN IF IT FAILS IX81766 SQL6534 WITH DB2AUTOLD AND RESTART B/D AND NO .NETRC FILE GG03737 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (OS/2) GG03739 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (OS/2) GG03741 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (OS/2) GG03743 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (OS/2) GG03745 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (OS/2) GG03747 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (OS/2) GG03756 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (OS/2) GG03758 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (OS/2) GG03766 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (OS/2) GG03768 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (OS/2) GG03772 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (OS/2) GG03774 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (OS/2) GG03781 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (OS/2) GG03783 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS (OS/2) GG03785 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (OS/2) GG00944 THE FIRST POSITIONAL PARAMETER OF THE ASNAPPLY COMMAND (OF DB2 UDB DPROPR) IS CASE SENSITIVE IN THE WINDOWS/NT ENVIRONMENT. (NT) GG03738 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (NT) GG03740 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (NT) GG03742 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (NT) GG03744 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (NT) GG03746 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (NT) GG03748 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (NT) GG03757 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (NT) GG03759 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (NT) GG03760 MOBILE REPLICATION BETWEEN UDB PERSONAL WINDOWS 95 AND UDB ENTERPRISE EDITION AIX - CONTROL TABLES ARE ON AIX MACHINE (NT) GG03767 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (NT) GG03769 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (NT) GG03773 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (NT) GG03775 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (NT) GG03782 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (NT) GG03784 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (NT) GG03786 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS. (NT) IX79591 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (AIX) IX79598 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (AIX) IX79601 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (AIX) IX79604 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (AIX) IX79607 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (AIX) IX79616 ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION. (AIX) IX79623 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (AIX) IX80372 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (AIX) IX80375 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (AIX) IX80916 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (AIX) IX81241 ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG (AIX) IX81262 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (AIX) IX82113 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (AIX) IX82129 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (AIX) IX82233 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (AIX) IX82289 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (AIX) IX82301 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS (AIX) IX79593 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (HP) IX79599 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (HP) IX79602 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (HP) IX79605 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (HP) IX79608 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (HP) IX79627 ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION. (HP) IX79624 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (HP) IX80373 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (HP) IX80376 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (HP) IX80917 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (HP) IX81263 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (HP) IX81265 ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG (HP) IX82114 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (HP) IX82134 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (HP) IX82291 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (HP) IX82295 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (HP) IX82302 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS (HP) IX79595 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (SUN) IX79600 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (SUN) IX79603 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (SUN) IX79606 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (SUN) IX79609 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (SUN) IX79628 ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION. (SUN) IX79625 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (SUN) IX80374 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (SUN) IX80377 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (SUN) IX80918 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (SUN) IX81264 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (SUN) IX81266 ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG (SUN) IX82115 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (SUN) IX82135 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (SUN) IX82292 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (SUN) IX82296 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (SUN) IX82303 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS (SUN) GG03751 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (OS/2) GG03753 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (OS/2) GG03761 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (OS/2) GG03762 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (OS/2) GG03777 RETENTION LIMIT PRUNING OF UOW TABLE (OS/2) GG03779 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (OS/2) GG03790 COLD START ENHANCEMENTS FOR SQLCODE964 (OS/2) GG03750 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (NT) GG03754 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (NT) GG03763 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (NT) GG03764 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (NT) GG03778 RETENTION LIMIT PRUNING OF UOW TABLE (NT) GG03780 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (NT) GG03791 COLD START ENHANCEMENTS FOR SQLCODE964 (NT) IX80084 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (AIX) IX80301 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (AIX) IX80618 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (AIX) IX80800 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (AIX) IX81782 COLD START ENHANCEMENTS FOR SQLCODE964 (AIX) IX82123 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (AIX) IX82210 RETENTION LIMIT PRUNING OF UOW TABLE (AIX) IX80130 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (HP) IX80315 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (HP) IX80739 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (HP) IX80801 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (HP) IX82239 RETENTION LIMIT PRUNING OF UOW TABLE (HP) IX82243 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (HP) IX82547 COLD START ENHANCEMENTS FOR SQLCODE964 (HP) IX80131 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (SUN) IX80317 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (SUN) IX80740 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (SUN) IX80802 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (SUN) IX82240 RETENTION LIMIT PRUNING OF UOW TABLE (SUN) IX82245 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (SUN) GG00969 MIGRATION TOOL CANNOT RUN ON WINDOWS 95 & 98 ASNMIG FAILS DURING MIGRATION OF MVS DPROPR FROM V1.2.1 TO V5 (NT) GG03755 ASN2769E SQLCODE518 - DPROPR MIGRATE PROGRAM FAILS WITH SQLCODE518 WHEN MIGRATING PRUNING CONTROL TABLE (NT) GG03776 SQLCOD407 WHEN MIGRATING CAPTURE FROM V1 TO V5 AND ABOVE (NT) GG03787 ASN2748E ASNMIG PREPARE ENDS UNSUCCESSFULLY (NT) JR09992 RESTORE OF ONLINE BACKUP THROUGH DB2DD FAILS WITH SQL1261N JR11528 V501: DB2CC DOES NOT DISCONNECT USERS FROM (REMOTE) INSTANCE. JR11532 CCA DOES NOT ACCEPT UNDERSCORE IN TCP/IP HOSTNAME JR11597 DEFAULT BROWSER DOES NOT RECOGNIZE INTERNET EXPLORER JR11727 JR11727: FIX FOR APAR, PMR #22398 JR11728 6/98:CONTROL CENTER LOCKS UP EXPANDING NODE OR DATABASE OBJECTS JR11760 JR11760: DCR21010 SUBS_COLS='S' SUPPORT JR11861 JR11861: SUPPRESS SUBSCRIPTION ACTIVATE QUERY FOR OS/390 JR11870 JOIN OF FULL REFRESH REPL. SOURCES DOES NOT PRODUCE NEW SOURCE IX77979 DPROPR APPLY, STL CMVC LEVEL PQ15438 IX78344 UPDATE CONNECT SMARTGUIDE WILL NOT ALLOW .FOR TCPIP HOST NAME JR11940 MVS GRAPHIC() COLUMN INCORRECTLY MAPPED TO UDB CHAR() IX78558 DPROPR APPLY, STL CMVC LEVEL PQ16105 JR11917 DPROPR DOESN'T RECOGNIZE COLUMNS DEFINED WITH DEFAULT JR11958 CC CRASHES WHEN CHANGE SYSTEM WITH SYSTEMNAME > 21 CHARS IX78463 DPROPR CAPTURE, STL CMVC LEVEL GG03708.4 IX78760 DPROPR APPLY, STL CMVC LEVEL PQ16384 JR12010 GPF IN JOUNAL ON NT VIEWING JOB HISTORY FILE FROM LOAD JR12038 SQL4414 FOR LOCAL OPERATIONS IN CC WHEN ADMIN INSTANCE ACTIVE. JR12035 OPTIONS DROP AND REMOVE TRANSLATED WRONG INTO SPANISH. IX79247 CANNOT RESTORE NEW DB FROM BACKUP WITH DIFFERENT NAME WITH CC IX79591 DPROPR APPLY, STL CMVC LEVEL PQ17223 JR12007 JR12007: SQLCODE100 UDB DOESN'T INITIALIZE PHYS_CHANGE_OWNER IX80084 DPROPR CAPTURE, STL CMVC LEVEL IX80301 JR12172 CONTROL CENTER ALLOWS UPDATE OF SUBSCRIPTION STATUS 2 JR12273 INCORRECT "MASTER" TABLE CHOSEN IN VIEW-REPLICA SCENARIO IX82210 DPROPR CAPTURE, STL CMVC LEVEL IX82210 IX82233 DPROPR APPLY, STL CMVC LEVEL PQ19014 JR10324 DB2 BACKUP NOT FREEING ALL MEMORY AFTER OPERATION HAS COMPLETED IX73165 CUSTOMER IS ATTEMPTING TO ROLLFORWARD THROUGH LOGS AFTER RESTOR IX74116 LOAD OF IXF W/ HIGH DISK_P CORRUPTS LF DATA JR11810 NT UDB TAPE RESTORE FAIL -2530 IX74871 V501: IN LOCK WAITS FOR X LOCK ON TABLE IX76127 HOT:RESTART FAILS WITH SQL1042 DUE TO -4015 IX75242 V501: ROLLFWD OF TABLESPACE RETURNS -1042, FFFFA602 SQLOFMBLK JR11680 REMOVE 8K LIMIT ON SQL IN EXPORT STMT IX75443 OPTIMIZER FAVOUR LIST PREFETCH OVER TABLE SCAN ON TABLES<32PAGE IX75463 V501: INCORRECT NODENUMBER IN ADSM BACKUP IX75609 LIST APP CORRUPTS APP ID FOR LONG APP NAMES IX75642 V501: EOF FROM SQLBGETBUFFERPOOLDEFFROMDISK IX76438 -902 RC 126 (SQLD_IXNOEX) RETURNED ON ALTER TABLE IX75688 USE LSATTR TO CHECK MEMORY ON AIX IX75687 V501: UNABLE TO RESTORE AN ADSM BACKUP USING >=3 SESSIONS IX75909 V501: DB2 BRINGS DOWN INSTANCE WITH DYNAMIC SQL IX75945 CLI0165E ERROR FOLLOWED BY SQL0000W IN THE TRACE. JR11726 SPORADIC TRAPS IN SQLNQ_TABSEL_OFN_CM JR11735 NETBIOS LOOPS WHEN MAXNBSESSIONS IS REACHED JR11737 DSN IN CONNECT STR TRUNCATED WHEN KEYWORD KEEPSTATEMENT USED IX77088 LOAD GETS -911 OR -3508 IX80480 LOAD GETS -911 OR -3508 JR11741 UNABLE TO IMPORT CLIENT PROFILE JR11878 USER COUNTS GET MESSED UP WHEN THEY EXCEED THE MAXIMUM NUMBER O IX76159 AUTOLOADER AND DUMPFILE OPTION CANNOT WORK IN MLN ENV IX76172 STMT OBJECT IN GETBINARYSTREAM NOT BEING CLOSED IX76236 SIGNAL #11 IN SQLRLLPD WHEN DROPPING A TBSPACE WITH 6000 TABLES JR11763 ERROR IN CCA WHEN PRESS 'ENTER' INSTEAD OF USING MOUSE CLICK JR11773 SQL0437W CAUSED OPEN FUNCTION TO BE SKIPPED IN DEFERREDPREPARE IX76443 PERFORMANCE PROBLEM OF A SELECT WITH AN ORDER BY JR11834 DB2 CONNECT INTERRUPT FAILS IN ASYNC MODE IX76680 SAMPLE JAVA STP RETURNS SQL10012 ON SUN IX74116 SAP: PATCH LF CORRUPTION BUG WITH DISK_PARALLELISM. IX76678 SOLARIS 2.5.1,2.6-- SQL1042 ON GET SNAPSHOT JR11802 NT STACK EXCEPTION DUE TO LOW AGENT_STACK_SZ AND LARGE QUERY JR11817 AFTER INSERT OF SIZE>32700 IN COL, NEXT INSERT<32700 TRAPS. IX77137 RUNSTATS WITH DISTRIBUTION CHANGES TABLE SCAN TO INDEX SCAN JR11818 DISABLEMUTITHREAD=1 NOT READ FROM DB2CLI.INI JR11821 WHEN SQL_ROWSET_SIZE > 1, SQLGETDATE REPORTS INVALID CURSOR POS IX76922 KEYWORD DATALINK NOT IMPLEMENTED PROPERLY IX76914 OVERTYPING ODBC DATASOURCE IN "CONNECTING TO DB2 DATABASE"TRAPS IX76924 STAR JOIN DISQUALIFIED FOR STAR JOIN ELIGIBLE QUERY JR11824 TRAP IN DOSCALL1.DLL DURING SELECT ON SMP OS/2 WITH UDB IX78628 UPDATE DB2IUTIL FOR 2 LINE OUTPUT FROM THE BDF COMMAND IX77399 MAKE SURE CRASH RECOVERY DON'T END TOO EARLY IX77067 SUN: DB2IUPDT FAILS DUE TO MISMATCHED LEVEL OF CODE JR11841 SQL_OJ_CAPABILITIES RETURNS INCORRECT INFORMATION IX77706 DB2START.XXXX.PID/DB2STOP.XXXX.PID FILES NOT REMOVED ALWAYS IX77154 OUTER JOIN IN LIST PREDICATE OPTIMIZER PROBLEM IX77312 DB2AGNTP PROCESS HOLDING ON TO /ETC/GROUPS IX77398 HOT: BACKING UP TO HOST MVS TAPES VIA CLIO/S NEEDS BACKBUFSZ 8 IX77400 SQL.H FILE MISSING SQL_QUERYOPT CONSTANTS FOR 2 AND 7 IX77480 MODULARIZE AND ADD DEBUG CODE FOR COMMIT/ROLLBACK OF NLI TABLES IX77439 SQL30081N ON SECOND CONNECT THROUGH SYSPLEX SERVER IX77672 INDEX CORRUPTION AFTER MIGRATING TO V5 IX77494 LOAD WITH DUMPFILE AND CPU > 1 GIVES INCOMPLETE DUMPFILE IX78566 CATALOG CACHE VARIABLES ARE NOT REPORTED IN APP SNAPSHOT IX77553 BACKUP/RESTORE API PROBLEMS IX77572 RECYCLING SCRIPT CENTRE DOESN'T ALLOW MORE SCRIPTS TO BE RUN IX77672 DB2DART CHANGES FOR C. MCARTHUR'S INDEX TOOL JR11872 CS ISOLATION ALLOWS UNCOMMITED READ ACCESS WITH W LOCK ON ROW. IX77776 SQL0404 ON INDEX REBUILD JR11891 INTERMITTENT SQL1652 DOING MULTPLE SIMULTANEOUS DB2STARTS IX77770 SQL1704N RC=8 ON DATABASE MIGRATION FROM DB2 V2 TO V5 ON HP-UX IX78975 LOAD FAILS WITH -911 RC=68 WHEN TIMEOUT = 10S IX77494 MORE DUMPFILE WORK JR11905 SQLNUMRESULTCOLS RETURNS FUNC SEQ ERR AFTER TIMEOUT JR11904 WIN95 GETHOSTBYNAME PERF. PROB. JR11914 MIGRATION FAILS DUE TO BAD HIGH2KEY/LOW2KEY IX78109 NEED OPTION TO ALLOW NEWLINE TO TAKE PRECEDENCE OVER THE STRDEL JR11917 SQLCOLUMNS DOES NOT RETURN COLUMN_DEF IX78176 DB2V5:DB2LOOK DOES NOT EXTRACT EMPTY TABLESPACES IX77398 32K BUFFER SUPPORT (III) - SQLUBCHECKBUFSPACE IX78244 COMPACT BLOB EXPANDS ON REORG IX78479 BAD RETURN CODE FROM SQLOSSEMACCESS BRINGS INSTANCE DOWN JR11921 \N CHARACTER CAUSES SQL0518 WHEN BEFORE/AFTER SELECT KEYWORD IX78265 CREATE INSTANCE VIA DB2SETUP HANGS ON HP-UX JR11928 DB2 CONNECT LOGS SQLO_LIC_INVALID_USERNAME WITH VALID USERNAME IX78334 SQL0104 NOT BEING HANDLED PROPERLY IX78481 V5.2:SQL8008/8002 ON OS/2 WHEN CONNECTING TO MVS FROM THE GTWY IX78499 NUM_AGENTS IS INCORRECT ON LONG RUNNING SYSTEM IX78509 MEMORY LEAK IN SQLRKAIN() WHEN DOING AN IMPORT WITH -973 JR11953 SAP ARRAY INSERT TRAPS JR11956 TRAP IN DB2CLI.DLL ON CLIENT WHEN FORCE APPLICATION ON SERVER JR11959 -805, 07005 ON SQLEXECUTE() WITH ASLHEAPSZ 1, DEFERREDPREPARE 1 IX78630 SQLNUMRESULTCOLS() CAUSES SQLEXECUTE() TO GET SQL0301N, 07006 JR11972 JDBC METADATA GETTABLES RETURN NULLPOINTEREXCEPTION IX78710 EXPORT OF 167 MILLON ROWS RETURNS SQL2003 IX73249 TWO SPM FIXES FOR V5.2 BETA AND V500 IX78820 SQLFETCH AFTER SQLFOREIGNKEYS FAILS ( ONLY THRU GATEWAY ) JR11981 STATIC CURSOR DOES NOT RETURN PROPER INFORMATION IX78958 INVALID CONTAINER NAMES GET THROUGH SQLBSETPOOLCONT IX78836 ALTER TABLE ... NOT NULL DEFAULT CURRENT TIMESTAMP FAILS -193 IX78867 DB2 SHOULD NOT ACCEPT FORCE EXPIRED PASSWORDS IN NON-AIX UNIX IX78903 ARRAY INPUT FOR BLOB COLUMN INSERTS WRONG DATA IX78963 INCORRECT QUERY RESULTS WITH STAR JOIN IX78981 AUTHID NOT FILLED IN ACB CP OF AUTHINFO 4 INTRMDRY IN 2HP SCN JR11917 SQLCOLUMNS DOES NOT RETURN DEFAULT DATA IX79213 LOADING TABLE HANGS INTERMITTANTLY IX79090 CHECK IN PROPER VERSION OF SIGNAL HANDLER IN JDBCSERVER.C IX77572 AIX: PROBLEM WITH RUNNING A SCRIPT NOW AFTER SCHEDULED JOB IS R JR12032 BUG CAUSING SQL1109 WHEN SPECIFYING A SCHEMA IN THE CALL STMT IX79235 INTERMITTENT SIGNAL 11 IN SQLULUMW JR12040 TRAP IN SQLNO_FINAL_PHASE EXECUTING QUERY IX79292 SIGNAL #11 IN DB2LRID WHEN LOAD TERMINATES IX79318 NON-SYSADM IDS ATTEMPT TO OPEN DB2AUDIT.CFG IX79456 9/98 FORCE APPLICATION CRASHES DB2 WHEN BUFFERED INSERTS JR12070 MEMORY LEAK IN DB2SYSC WHEN BPS INITIALIZATION (SQLBINIT) FAILS IX79557 -3508 RC CALLING SQLULOAD API WITH V2 APP. JR12093 FILTER FACTOR OFF AND NO FREQUENCY STATS ON VARCHAR COLUMN IX80107 SQL1269N WITH ONLINE TABLESPACE ROLLFORWARD COMPLETE IX79866 DIA1026C XA ERROR IN DIAG FILE IX80044 EXCESSIVE SEMOP ERRORS ON FAILING LOCAL CONNECTS IX76680 DEFINE SQLEJ_DB2JEXT_JVMSTOP IN SQLEJAVA.H ON ALL PLATFORMS JR12130 BLOCKED FETCH WHICH PREFETCHES RIDS CAN LEAVE ROW LOCK ON TABLE IX80087 HOT:INCORRECT RESULTS RETURNED FROM AN SQL QUERY AFTER RUNSTATS JR12143 HOT :MEMORY LEAKS ON NT AFTER DISCONNECT IX80294 SAP:SQLEXECUTE() DOES NOT REDESCRIBE WHEN THE SQLDA CHANG IX80545 HOT: V501: RECOVERY ENDS TOO EARLY, PANIC/SLEEP JR12167 SELECT RETURNS -901 IN SQLNO_PLAN_COMPARE-- NEGATIVE PLAN COST JR12169 MIGRATION OF THE NODE DIRECTORY FAILED IX80589 OPEN IX80810 HOT:MODIFICATIONS OF OLIR CODE JR12220 LOAD DOES NOT ALLOW CHARACTER DELIMITING AS A PRIORITY. JR12227 BEFORE SELECT IS CAUSING SQLEXECDIRECT TO FAIL IX81362 SQL2038 REASON 5055 DURING RESTORE/MIGRATE JR12247 CCA ONLY SHOWS 8 CHAR OF CHEMA NAME ON HOST DATABASE JR12252 CRASH RECOVERY HANGS IX81497 DB2TRC INFO SHOWS WRONG INFO IN SOLARIS IX81647 BAD #PRAGMA WARNINGS WHEN COMPILING WITH UDB SDK/SOLARIS JR12267 GETDEFAULTLLU ASSUMES THE ONLY LLU AS THE DEFAULT LLU IX81761 IF DB2AUTOLD FAILS, IT STILL RETURNS A 0 RC TO THE SHELL IX81764 DB2ATLD DOES NOT RETURN NON-ZERO RC EVEN IF IT FAILS IX81766 SQL6534 WITH DB2AUTOLD AND RESTART B/D AND NO .NETRC FILE IX82101 EDU CRASH DURING ONLINE BACKUP TO ADSM V3 JR12282 MIGRATION FROM DB2/2 V1.2 TO DB2 UDB IX82188 SUBSEQUENT QUERIES RETURN NO DATA WHEN DEGREE > 1 IX82334 RESTORE OF DATABASE RETURNS RC -10746 (TOO MANY FILES OPEN) IX82336 UOW STOP TIMESTAMP NOT SET ON COMMIT JR12362 SQLE_DEACTIVATE_DB_API DOES NOT POPULATE SQLWARN FILED IN SQLCA JR11820 V501: SOME RESPONSE FILE KEYWORDS IGNORED DURING NT INSTALL JR11802 NT STACK EXCEPTION DUE TO LOW AGENT_STACK_SZ AND LARGE QUERY JR11952 THIN INSTALL FROM WIN NT DOES NOT INSTALL ODBC FILES CORRECTLY JR11952 THIN CLIENT INSTALL TO LOOK FOR ODBC FILES IN THE CUR. DIR. JR12143 HOT :MEMORY LEAKS ON NT AFTER DISCONNECT JR12219 CAE MISSING CONVERSION FILES FOR JDBC SUPPORT JR12345 FIXING DB2APP.DLL JR11075 DB2RESDB IS NOT RETURNING THE CORRECT OUTPUT/MESSAGE JR11498 V501 SQL2503N FROM DB2RESDB RESTORING V1 DATABASE TO V5 JR11824 TRAP IN DOSCALL1.DLL DURING SELECT ON SMP OS/2 WITH UDB IX78481 V5.2:SQL8008/8002 ON OS/2 WHEN CONNECTING TO MVS FROM THE GTWY JR12005 INTERMITTENT TRAP IN SQLODUMPEDU JR12021 TRAP IN TCP32.DLL IF DB2COMM=TCPIP AND USING TWO PHASE CONNECT JR11899 CURRENTSQLID NOT WORKING FROM CAE/WIN CLIENT SETUP GUI JR11899 SEEING DBNAME IN CURRENTSQLID FIELD IN CLIENT SETUP GUI JR12221 OPTIMIZER PROBLEM WITH HOST VARIABLE FILTER FACTORS - RUNSTATS IX76365 FIX 94984 - MISSING A SET OF BRAKETS