************************************************************ Product Name : DB2 UDB V5.2 for OS/2 PTF Number : WR21287 Package Date : Mon Nov 19 10:37:12 EST 2001 Build Level : c010929 ************************************************************ APAR fixes included in WR21287 (Fixpak 17) APAR No. Abstract -------- -------------------------------------------------- GG04162 VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION FALLBACK GG04207 APPLY IS HAVING PROBLEMS REPLICATING FROM BASE TABLE OF AS/400 BLOB FIELD TO WIN 2000 SERVER RUNNING DB2 UDB EE V7.1. GG04208 APPLY FAILED SQLCODE911 WHEN REPLICATING FROM VM SOURCE SERVER GG04214 APPLY DID NOT FULLREFRESH IF CAPTURE COLD START AT REPLICA GG04229 APPLY DOES NOT RUN 'SQL AFTER' ON DIFFERENTIAL UPDATE WHEN CAPTURE IS FROM AS/400 AND SYNCHPOINT IS NULL IY21347 INTERNAL ERROR REPORTED IN DB2DIAG.LOG DURING THE ROLLBACK OF CHANGES TO DB FAILS WITH SQLCODE -952 IY21522 APPLY USES THE WRONG PRUNE CONTROL ROW WHEN CAPTURE IS STARTED COLD. IY23502 SUBOPTIMAL PLAN CHOSEN FOR STAR JOIN IY24652 INSTANCE CRASH AND TRAP AT SQLJDRD1 IY24682 TRAP IN SQLCSPC_COOR_REG WHEN HOST EXPERIENCES COMM. PROBLEMS IY24743 TRAP IN SQLJMQDA WHEN THE QUERY HEAP GETS EXHAUSTED IY24752 TRAP - SIGNAL 11 IN SQLPM_WRITE_LOCKS WHILE PERFORMING LOCK SNAPSHOT CRASHED THE DB2 INSTANCE IY24760 DRDA POINTER IS NOT INITIALIZED CORRECTLY IN TCP/IP COMMUNICATION. CAUSES TRAP UNDER CERTAIN CONNECTIONS USING JAVA IY24762 BUFFER CORRUPTION CAUSES REPLICATION TO FAIL. IY24853 DB2 GATEWAY TRAPPING AFTER RECEIVING DATA FROM A STORED PROCEDURE ON OS/390. JR15941 DB2 IS TRAPPING IN THE FUNCTON SQLEMRSP_AS.C JR16041 DRDA_HEAP_SZ MEMORY LEAK. SYMPTOMS: SQL30081, RC= *,*,0. JR16374 OS/2 DB2 BACKUP VIA USEREXIT WILL FAIL AT AND AFTER SUNDAY SEPTEMBER 9TH 01:46:39 2001 APAR fixes included in WR21262 (Fixpak 16) APAR No. Abstract -------- -------------------------------------------------- GG03998 ASNLOAD BLOB LIMITATION GG04044 APPLY CONNECT TO THE SOURCE FOR UPDATING PRUNCNTL.SYNCHPOINT BUTIF NO CAPTURE IS RUNNING - NO SQL PROCESSED - DSNL500I MESSAGE GG04082 SQLCODE313 PRESENTED AFTER USING OFFLINE LOAD PROCEDURE GG04108 ASNAPPLY WITH PARM NOSLEEP DID NOT ISSUE A 'CONNECT RESET',WHICHLEADS TO DSNL500I CONVERSATION FAILED MESSAGES ON DB2 OS/390 GG04128 IF A COMMUNICATION ERROR OCCURS (ASN1001E, SQL30081), THEN APPL RETURNS WITH RC=0 TO THE OS GG04135 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT GG04162 VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION FALLBACK GG04178 APPLY PUTS NULL IN CCD TARGET WHEN SOURCE COLUMN IS A TIMESTAMP AND TARGET COLUMN IS A CHAR(TIMESTAMP) GG04189 FULLREFRESH FROM SECOND TIER CCD TO 3RD TIER CCD DID NOT WORK. GG04190 APPLY BINDS USING PRUNE LOCK TABLE WILL NOT BIND TO CAPTURE/VM WHICH DOES NOT HAVE THIS TABLE. GG04194 CAPTURE USES TOO MUCH MEMORY - WIN NT SPECIFIC PROBLEM GG04196 OVERRIDE THE DEFAULT PARAMETERS OF LOGREUSE AND TRLREUSE USED BY ASNSAT WHEN INVOKING APPLY. GG04201 ASNCMD STOP FAILS TO STOP DATAPROPAGATOR CAPTURE. GG04205 ASNLOAD FAILED WHEN INVOKING APPLY USING A NETWORK ID. GG04206 APPLY NOT REDRIVING APPLY WHEN AN RI VIOLATION IS DETECTED IN THE 'F' DIRECTION. IC29866 IF A SOURCE TABLE ON A NON-IBM DATABASE IS REGISTERED FOR FULL REFRESH ONLY,DJRA SQL GENERATION FOR ADD MEMBER OR DROP MEMBER IY01998 AN AGENT HANGING IN TQ CODE, ANOTHER STUCK ON APM LATCH IY03296 SQL2154 ON ATTEMPTED TABLESPACE RESTORE. IY10950 UNDERSCORES IN TABLE ALIAS CAUSE MS JET ENGINE ERROR WHEN LINKING TABLES. IY11267 QUERY_HEAP TOO SMALL MAY CAUSE -1131 ON CALL TO STORED PROCEDURE IY12823 REINIT CMD WAS IGNORED WHEN THERE IS NO CHANGES TO CAPTURE IY13065 DB2ADUTL HAS A ARCHIVE LOG LIMIT OF 1023 ENTRIES. IY13617 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS IY13653 AUTOLOAD FAILS WITH -1350: -290 IN DIAG SQLR_TURNOFF_CONSTR. IY13696 SQL1273N ON ROLLFORWARD DATABASE (MISSING LOG FILE S0000000.LOG) IY13738 FROM CLIENT TO AIX SERVER,JOB IS SCHEDULED THORUGH SCRIPT CENTERWITH CORRECT USERID,NO MATTER WHAT PASSWORD,JOB EXECUTES SUCESSF IY13817 LOAD FASTPARSE FAILS TO LOAD AND REPORTS INCORRECT INFO IY13818 -804 ERROR IN APPLY SQL0804N SQL0804 IY13830 CAPTURE DOES NOT RETURN SQL2651 IN CCP FILE IY14059 APPLY AIX PID FILES NOT FOUND IY14117 UNEXPECTED SIGALRM RECEIVED BY DB2UDF BRINGS DOWN DB2 IY14152 CAPTURE UNABLE TO FINISH PRUNING WHEN LOG FILE SYSTEM BECOMES FULL (SQL0964C) IY14154 CAPTURE NEEDS TO REINIT LONG FIELD DATA STRUCTURES FOR ANY NEW REGISTRATION PICKED UP BY THE REINIT COMMAND IY14209 DB2LOOK -L FAIL TO RETURN CONTAINER INFO WHEN RAN AS SYSCTRL ID. IY14225 DB2ATLD CANNOT HANDLE PATH LONGER THAN 80 CHARACTERS IY14274 INSERT/UPDATE PROBLEMS FROM MVS AR AGAINST UDB AS SQL30020 RC 1245 IY14291 CAPTURE CORE DUMPS WITH SIGABRT, LONG VARCHAR COLUMNS IY14298 CUSTOMER SELECTS, IN JOURNAL, A COMPLETED SPECIFIC JOB TO DISPLAY AND THE DB2DAS00 GOES DOWN. IY14338 INCREASE DB2 PRIVATE MEMORY ALLOCATION LIMIT PER PROCESS FROM 256MB TO 2GB - AFFECTS UNIX ONLY IY14463 CAPTURE GETS IN A LOOP WHEN ASNCMD GETLSEQ IS IN LOCK STATE IY14706 IMPORT WITH BUFFERED INSERT CAUSES TABLE LOCK ON SYSIBM.SYSPLAN IY14776 CURRENT REFRESH AGE PARAMETER IS NOT BEING PICKED UP. IY14820 ERROR DURING ALLOCATION OF LOG FILE CAUSES DATABASE TO SHUTDOWN IY14980 HANG IN FCM ON FAST HARDWARE IY15004 JAVA STORED PROCEDURES FAIL WHEN RUN FENCED EVEN WHEN LOCATED IN SQLLIB/FUNCTION PATH. IY15068 INCORRECT FILTER FACTOR COMPUTATION FOR RANGE PREDICATES IY15116 ASN0017E RETURNED WHEN CAPTURE FAILS TO START FROM A USERID THATIS DIFFERENT FROM THE DB2 INSTANCE OWNER IY15290 SQL0901 RETURN - SECTION NOT CLOSED. IY15608 SIGNAL#11 IN SQLUDRSA IY15735 INSTANCE CRASH ON TRAP (SIGSEGV) IN SQLBLATCHPINNEDPAGE EEE ONLY. INTERNAL SYNCHRONIZATION PROBLEM EXECUTING SQL. IY15921 CAPTURE FAILS - SQL2038 RC 32 IY15931 HASH_JOIN MEMORY ALLOCATION PROBLEM WHICH MARKS DB BAD. IY15975 MEMORY LEAK IN AIX APPLY IY16223 WRONG MAPPINGS FOR ERROR MESSAGE SQL0465N AGAINST OS/390 IY16239 USEREXIT STOPS WORKING WHEN ACTIVATE IS ISSUED DURING AN ONLINE BACKUP IY16298 DB2 UDB - MESSAGE IS INCORRECTLY DUMPED TO THE DB2DIAG.LOG FILE FROM FUNCTION SQLERUNSYSCTLR PROBE 65. IY16466 CLI TRAPPING WHEN QUERY IS LARGER THAN 32K IY16518 DATABASE CRASHES AFTER INTERRUPTED REORG IY16644 JOBIDS ARE NOT REUSED WHEN 999 LIMIT IS REACHED IN SCHEDULER IY16734 DEBUG CODE TO DUMP INFO WHY USEREXIT STOPS ARCHIVING LOGS IY16924 NEED TRANSACTION BASED REPLICATION FOR READ ONLY TARGET TYPES OFPIT AND USERCOPY. IY16936 TABLESPACE RECOVERY FAILS/HANGS DURING FIRST ROLLFORWARD. IY17015 TABLESPACE ROLLFORWARD UNDO PHASE READS FROM DISK FOR EVERY LOG RECORD IY17049 DB2SPLIT FAILED IF OUTPUT FILE > 2GB IY17330 DESCRIBE RETURNS AN INCORRECT INFO IN DBCS IY17523 SQL1015N, DATABASE MARKED BAD DUE TO IMPROPER SAVEPOINT HANDLING IY17650 ONLINE DATABASE BACKUPS RETURN SQL2038N RC -3838 AFTER A FAILED CREATE TABLESPACE IY17698 APPLY UPDATED THE WRONG SYNCHPOINT AND SYNCHTIME IN PRUNCNTL TBL IY18124 MAX_SYNCH_MINUTES WITH CCD - APPLY UPDATES THE SUBS_SET SYNCHPOINT INCORRECTLY CAUSING POTENTIAL DATA LOSS IY18163 DB2DART REPORTS BPS HEADER PROBLEMS AFTER DATABASE RESTORE. IY18373 APPLY SHOULD EXECUTE THE SQL BEFORE AND AFTER STATEMENTS FOR A SUBSCRIPTION SET EVEN IF THERE IS NO DATA TO REPL. IN THAT CYCLE IY18376 CLICKING ON THE 'CONNECTIONS' SUB-FOLDER IN THE CONTROL CENTER TREE VIEW RESULTS IN AN INVALID PAGE FAULT IN THE DB2JD IY18901 CHANGING QUERY SORT ORDER RESULTED IN POOR PERFERMANCE IY18986 TRAPPED IN SAVEPOINT WHILE ROLLBACK,SHOULD IGNORE SQLCODE- 1035 FROM REMOTE NODE IY19059 ONCE JOBIDS HIT 999, JOBIDS ARE REUSED. HOWEVER, JOBS ISSUED VIA 'RUN NOW' KEEP REUSING SAME JOBID IY19081 SMALL TIMING WINDOW WHERE THE CAPTURE READS A LOG WHILE IT IS BEING ARCHIVED -> WORKAROUND: RETRY SHOULD RESOLVE IY19097 CANNOT RUN DB2GOV W/ SYSCTRL GROUP USER THAT IS NOT INST OWNER. IY19168 RESTART/CONNECT/CRASH RECOVERY FAILS WITH SQL1042C WITH INVALID LSN DUE TO A PROBLEM WHEN ABORTING A TRANSACTION IY19171 SAMPLE USEREXIT SHOULD INDICATE THAT 'MOVE' IS UNSUPPORTED FOR LOG ARCHIVING - ONLY 'COPY' IS SUPPORTED IY19493 LONG PREPARE TIME FOR EEE QUERIES INVOLVING MULTIPLE JOINS, WHERE AT LEAST ONE OF THE TABLES RESIDES IN A MULTI-NODE NODEGRP IY19528 ERROR MESSAGE DIA3808C IS INCORRECTLY DUMPED OUT IN THE DB2DIAG.LOG FILE WHEN THE ACTUAL ERROR IS SQL1013. IY20036 DB2PFCHR,DB2PCLNR,DB2REBAL,DB2ESTOR PERSIST EVEN AFTER DBM SHUT DOWN & CONSUME CPU RESOURCES UNTIL REBOOT: RESULT POOR PERFORMAN IY20069 PROBLEM WITH DATAPROP/CAPTURE. TIMESTAMP NOT INITIALIZED. IY20316 SQLBGETPOOLSTATS CAN CAUSE LOG CORRUPTION IY21243 REORG TABLE INDEX RETURNS SQL2205 WHEN INDEX EXISTS IY21245 AIX ONLY: DB2MEMDISCLAIM CAN CAUSE SORTHEAP ALLOCATION ERRORS, TRAPS, DEFUNCT DB2AGENTS DUE TO LEAKING VIRTUAL MEMORY. IY21262 HOST SERVER (E.G. DB2/390) RETURNS SQL0805N DURING IMPORT DUE TOA PACKAGE NOT FOUND. IY21263 DB2 STOP FORCE FROM CC HANGS AND GENERATES A TRAP IY21342 LOG DIR FILLS DUE TO OLD LOG FILES NOT BEING DELETED/RENAMED DURING CRASH RECOVERY, AND SAME LOG IS REPEATEDLY ARCHIVED IY21344 USEREXIT STOPS TO BE CALLED WITH FFFFA602 FROM SQLPGART MESSAGE IY21346 BACK LEVEL CLIENT CRASHES (SIG#11) IN SQLRR_OPEN IY21350 USE OF {?=CALL SPNAME(?)} SYNTAX MAY RESULT IN CLI0102 INVALID CONVERSION ERRORS IY21359 $N CLAUSE IN CREATE TABLESPACE PROBLEM IY21366 AUTOLOADER HANGS WHEN USING FILE_TRANSFER_CMD AND LOAD ABORTS IY21367 SQLDESCRIBEPARAM CALL TO HOST RETURNING SQL0236 IY21373 SQL4908N IS GENERATED WHEN RF ON TABLESPACES IS ISSUED AGAIN ON TABLESPACES WHICH ARE RF PENDING STATE AND FLAG IN LFH IS ON. IY21391 SIGNAL 11 IN SQLDADJUSTSEQDETPFAMOUNT IY21396 QUERY AT OPTLEVEL 3 RECEIVES A SQL0101 EVEN WITH STMTHEAP MAXED IY21398 INDEX CORRUPTION, CONTINUATION OF IY11940 IY21400 WRONG OR DIFFERENT RESULTS RETURNED BY SELECT ON VIEWS V7.1 ONLY IY21444 SQLJ.INSTALL_JAR PROBLEM IY21445 CURRENTSQLID NOT USED UNDER MTS TRANSACTION ENVIRONMENT. IY21501 SQL1224 DB2 INSTANCE CRASH. THIS OCCURS BECAUSE OF MEMORY CORRUPTION AFTER A COMMUNICATIONS ERROR - TRAP IN MEMTREEPUT IY21524 DIA1529C COULD NOT START DEADLOCK DETECTOR, GLOBAL DEADLOCK DETECTOR FAILING TO START. JR14320 SQL0501N IN DB2DIAG.LOG. NO ERRORS RETURNED TO THE APPLICATION. WE ARE TRYING TO CLOSE CLOSED CURSOR INTERNALLY IN CLI. JR14807 DR. WATSON WHEN ISSUING DB2 FORCE APPLICATION ALL AGAINST DRDA-2CONNECTIONS. JR14990 OUTPUT PARAMETERS NOT INITIALIZED TO NULL JR15228 TRAP IN SQLJIDRD WHEN SQL_DISCONNECT_ABNORMAL RETURNED JR15238 INCONSISTENT RESYNC (OS/390 ABORTS, UDB COMMITS) JR15272 LARGE TRAP FILE WHEN FREEING INVALID MEMORY BLOCK (SQLOFMBLKEX) JR15466 DATABASE COMES DOWN OR HANGS. TRAP FILE IS CREATED INDICATING EXCEPTION C0000005 IN FUNCTION SQLRR_DUMP_SECTION. JR15706 TRAP IN SQLCSPC_COOR_REG. JR15713 -805 CAUSED BY CURRENT PACKAGE SET IS NOT RESET JR15744 SIGNAL 11 IN SQLNO_JOIN_PG_SEL JR15764 MSACCESS FAILES WITH ODBC ERROR WHEN RETRIEVING CLOB FROM MVS 6.1 JR15770 XA PASSWORD LENGTH SHOULD BE 14 CHARACTER MAX JR15794 CONNECT TYPE 2 APPLICATION THAT CALLS A STORED PROC TRAPSIN SQLE_DBM_DARI - APPLICATION RECEIVING SQL1327 JR15855 USERIDS NEED WRITE AUTHORITY ON DAS DIRECTORY TO RUN SCRIPTS JR15856 CRASH RECOVERY TRAPS DUE TO INDEX CORRUPTION JR15874 DB2 ABENDS IN SQLERUNSYSCTLR DUE TO DOUBLE-FREEING OF MEMORY DARI PROCESS JR15876 SUBSCRIPTION SET FOR REPLICA WITH EVENT BASED TIMING ('E') ALWAYS GETS TIME BASED TIMING ('R') IN THE SCRIPT JR16096 FAILURE DUE TO COMPLEX ON DELETE CASCADE RI CONSTRAINTS JR16165 EXCEPTION 5 TRAP DURING STAR JOIN PLANNING JR16167 'BAD' RANGE OF SORTHEAP SIZE(>1014 AND < 1038) IN THE OPTIMIZER JR16172 WHEN DEFERREDPREPARE=0 CLI0150E ERROR DRIVER NOT CAPABLE IS RETURNED JR16175 SP FAILS WHEN MORE THAN 27 CURSORS, RET. DATA > 1 BUFFER JR16182 MTS/COM+ APPLICATION GETTING SQLCODE -913 WHEN EXECUTING, DUE TOMULTIPLE CONNECTIONS BEING USED BY MTS FOR THE SAME TRANSACTION APAR fixes included in WR21216a (Fixpak 15a) APAR No. Abstract -------- -------------------------------------------------- IY09961 QUERY REWRITE DOESN'T PUSH DOWN PREDICATE INTO COMMON SUBESPRESS ION IY12642 LOAD DOES NOT CHECK PARTITIONING KEY FOR EXCEPTION TABLE IY12968 JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW IY13054 MISLEADING ERROR REPORTING ( -901) FOR WRONG SCRIPT TRYING TO LINK UDF. IY13476 CRASH RECOVERY HANGS DURING UNDO PHASE IN INDEX MANAGER JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS JR15025 DR.WATSON IN DB2SYS.DLL WHEN LOGING OFF NT (MTS AND DTC) JR15158 DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE APAR fixes included in WR21216 (Fixpak 15) 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 TO READ 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. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. 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 APAR fixes included in WR21191d (Fixpak 14d) 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 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. APAR fixes included in WR21191c (Fixpak 14c) 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 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. JR14854 NT: CONNECT HANGS RESULTING FROM LATCH ON GLOBAL INSTANCE QUEUE APAR fixes included in WR21191b (Fixpak 14b) APAR No. Abstract -------- -------------------------------------------------- IY10861 DATABASEMETADATA.GETCOLUMNS IS NOT HANDLING SCHEMAPATTERN='' CORRECTLY. IY11063 AN APPLICATION HANGS (AN AGENT STUCK IN MONITOR CODE) IY11074 SQL0101 ERROR WHEN RUNNING A QUERY DUE TO MEMORY FRAGMENTATION PROBLEM AND LOW 'ULIMIT -D' VALUE. IY11161 FAILURE TO FIND A LOCK WITHIN LOCK TABLE, SQLPLUPDATETRANENTRY REPORTS FFFFF51D AT PROBE POINT 5 IY11375 USEREXIT IS NOT BEING INVOKED EVEN THOUGH IT HAS BEEN SET UP PROPERLY. JR14743 DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM. JR14794 DB2 LIST TABLES COMMAND CAUSES TRAP IN DB2 V5.2 FOR OS/2 APAR fixes included in WR21191a (Fixpak 14a) 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 SQLLIB\FUNCTION 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 ARE REFERENTIAL INTEGRITY CONSTRAINTS ON THE TABLES WITHIN THE TABLESPACE. 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. IY11162 SQL03181W ON LOAD WITH A SPECIFIC IXF FILE, BUT NOT ON IMPORT IY11182 SIGNAL 11 ON SQLULTERMINATE AFTER SQL2043 DURING AUTOLOAD IY11283 ISSUING DB2IUPDT OVERWRITES THE DB2AUDIT.CFG WITH THE DEFAULT CONFIGURATION. JR14068 PCOMM ALLOWS '#' IN THE PARTNER LU NAME BUT DOES NOT ALLOW '#' I N THE SYM_DEST_NAME. JR14625 NT PERFORMANCE MONITOR NOT PROVIDING 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 JR14889 CRASH WITH SQLCREATEDAT (PROBE: 100) MESSAGES IN THE DB2DIAG.LOG INDICATING THAT THE DAT OBJECT LIFE LSN IS NULL. APAR fixes included in WR21191 (Fixpak 14) 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 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. GG04054 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. 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 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. IY10145 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. IY10147 APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET. 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 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 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 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 APAR fixes included in WR21180e (Fixpak 13e) 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 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 APAR fixes included in WR21180d (Fixpak 13d) 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 IY10029 QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204 IY10390 TERMINATING ADSM SESSION BEFRO RE-ESTABLISHING IT. IY10432 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY IY10500 INVALID CONVERSION/TYPE FOR DOUBLE WITH STORED PROC IN DB2/MVS 6 JR14581 CONTROL CENTER TRAP ON V5.2 - EXCEPTION C0000005 IN DB2CC.EXE TRAP IS IN SQLEDTIN CALL - BROWSING DIRECTORY FOR BACKUP APAR fixes included in WR21180c (Fixpak 13c) APAR No. Abstract -------- -------------------------------------------------- IY10088 DIA3875C DELLEAF FAILURE USING INDEX that was CREATED ON PE V1.2 and then migrated to v5.2 JR14497 DB2 CONNECT TRAPS IN SQLJDRD1 ALONG WITH AN ACCESS VIOLATION DR. WATSON ERROR ON NT APAR fixes included in WR21180b (Fixpak 13b) 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. 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 APAR fixes included in WR21180a (Fixpak 13a) 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 Signal#11 IN SQLO_INIT_MULTI_THREADING IY09222 FFFF A602(INVALID MEMORY ADDR) IN DB2DIAG.LOG AND CLI0120E IN JDBC.LOG IY09267 RUNSTATS RECEIVES 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 Signal#11 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 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 Garbage characters in the DB2 recovery history file when using the sqluvtun API. 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. APAR fixes included in WR21180 (Fixpak 13) APAR No. Abstract -------- -------------------------------------------------- GG03649 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 GG03993 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES GG03997 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD GG03999 CAPTURE CORE DUMPS AROUND PRINT_LSN() GG04000 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE GG04001 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE GG04002 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE GG04003 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE GG04004 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR GG04005 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR GG04006 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 GG04010 LONG VARCHAR FIELDS CAN BECOME OVERLAID GG04012 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS GG04013 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES GG04014 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD GG04015 CAPTURE CORE DUMPS AROUND PRINT_LSN() GG04016 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. GG04019 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS GG04020 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. GG04023 LONG VARCHAR FIELDS CAN BECOME OVERLAID GG04024 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS GG04025 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) GG04026 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED GG04029 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE GG04031 INSERTS ARE MISSED BY CAPTURE GG04032 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE GG04033 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS GG04034 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) GG04035 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED GG04036 INSERTS ARE MISSED BY CAPTURE IY03632 RECONCILE DLREPORT NEEDS TO BE TERMINATED WITH / IY05644 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY05988 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027/ASN0017S RC9106 ASN0017 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 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. IY07523 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07527 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07528 ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE IY07550 SQL1042N DURING A ROLLFORWARD OF A V5.X DATABASE THAT HAS BEEN MIGRATED FROM V2.X DATABASE. IY07556 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07558 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07559 APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE IY07567 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07568 SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR IY07699 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07700 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07701 UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9 IY07711 DB2CCLST LEAVES DEFUNCT PROCESSES ON UNIX PLATFORMS WITH MULTIPLE LOGICAL NODES. IY07744 CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS IY07745 CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES IY07747 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD IY07748 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07749 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07750 WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT. IY07751 CAPTURE CORE DUMPS AROUND PRINT_LSN() IY07753 SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD 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. IY07884 JDBC APPLICTION WAS CRASHING DUE TO NULL MEMORY BEING FREED BY THE CLI LAYER IY07908 ROWCOUNT > 10000000 IN LOAD COMMAND CAUSES INSTANCE CRASH IY07951 JAVA UDFS WITH DECIMAL PARAMETERS PERFOMANCE DEGRADS IY08007 UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027 IY08008 DLFM SHUT DOWN WHEN YOU FORCE THE COPY DAEMON'S ADSM SESSION TO TERMINATE OR RECYCLE THEIR ADSM SERVER. IY08076 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY08077 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY08085 LONG VARCHAR FIELDS CAN BECOME OVERLAID IY08124 INSERTS ARE MISSED BY CAPTURE IY08125 SQLTABLES() CALL IS NOT RETURNING INOPERATIVE VIEWS FROM A UDB DATABASE. IY08391 TRAP AT SQLBPFDESTROY AND PREFETCHER ERROR RC = -20444 IY08454 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08455 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08456 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08457 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY08458 INSERTS ARE MISSED BY CAPTURE IY08459 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08460 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08461 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08462 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY08463 CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE IY08464 CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS IY08465 CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST) IY08466 WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED IY08467 INSERTS ARE MISSED BY CAPTURE IY08569 ROLLFORWARD OF DATABASE CAUSES CORRUPTION OF LOB DATA IY08584 MULTIPLE IN PREDICATE WITH OUTER JOIN CAUSES EXPLAIN ERROR IY08716 HASH JOIN MAY RESULT IN ENDLESS LOOP IY08755 -901:BAD PLAN: UNRESOLVED QNC FOUND IY09146 FIX FOR PERFORMANCE PROBLEM CAUSED BY JR13499 IY09490 QUERIES RESULTING IN LARGE DATA SETS CRASHES DATABASE WITH UNEXP ECTED EOF DUE TO TEMP TABLESPACES CONTAINER TRUNCATION (F609) JR13908 BETTER FILTER FACTOR FOR 'CONST = CONST' PREDICATES AND QRW NEEDS TO ELIMINATE OR(1=0) PREDICATES. JR14061 JDBC APP FAILS AGAINST UDB WHEN COMMA SEPARATOR IS USED. JR14263 WRONG WEEK NUMBER RETURNED FROM WEEK FUNCTION JR14279 SQLEXTENDEDFETCH RETURNS SUCCESSWITHINFO IF A FETCH OF ONE ROW FAILS DUE TO TIMEOUT OR DEADLOCK. RETURN SHOULD BE SQLERROR. JR14312 DB2 COBOL PRECOMPILER TO GENERATE COPY 'SQLCA.CBL' INSTEAD OF COPY 'SQLCA.CBL' 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 JR14356 SQL1331N RC=SQL_CPIC_SECURITY_NONE WHEN USING APPN TO HOST IN DB2 CONNECT EE 5.2 (FIXPAK12). 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 JR14401 DB2 UDB - LOAD FAILS WITH SQL1350. DB2DIAG.LOG FILE REPORTS - 551 ERROR IN SQLR_TURNOFF_CONSTRAINTS APAR fixes included in WR21166e (Fixpak 12e) APAR No. Abstract -------- -------------------------------------------------- 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 IY08204 NON CONSTANT 'PULLUP' IN THE OPTIMIZER CAUSING QUERY PERFORMANCE PROBLEMS. IY08223 ATTEMPT TO ALLOCATE ADDITIONAL LOGSPACE BEYOND CONFIGURED LOGS AS REQUIRED IN ORDER TO ALLOW CRASH RECOVERY TO COMPLETE IY08304 BP PAGESIZE WRONG WHEN CREATED ON NODE USING ALTER BUFFERPOOL IY8309 MEMORY LEAK IN UTILITY HEAP SIZE JR14282 SQL30020, OR AN ABEND ON DB2 FOR OS/390 WHEN INVOKING A STORED PROCEDURE WITH OUTPUT PARMS LONGER THAN THE BLOCK SIZE (32K) APAR fixes included in WR21166d (Fixpak 12d) APAR No. Abstract -------- -------------------------------------------------- IY03602 SQL0980C BAD PAGE ENCOUNTED DURING LOAD RESTART IY07986 DB2 UDB - A CONNECT ATTEMPT FAILS WITH AN OUT OF MEMORY ERROR. IY08024 DB2 UDB - PAGE CLEANERS MAY LOOP CAUSING PERFORMANCE DEGRADATION WHEN MULTIPLE BUFFERPOOLS ARE DEFINED. 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 APAR fixes included in WR21166c (Fixpak 12c) APAR No. Abstract -------- -------------------------------------------------- IY04139 SQL5153 NEEDED INSTEAD OF SQL30081 ON CLIENT WHEN NO FCM RQBLK IS AVAILABLE. SERVER ERROR SQL6043 IS FINE. 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 IY07092 CHANGE OPTIMIZER COSTING TO HANDLE NULLS IY07110 -901:SQLNO_SMP_CREATE_TQ IY07216 SELECTING 'INDEXES' FROM CC CRASHES OR HANGS THE CC. IY07309 SQL3508 REASON 4 ON LOAD WITH DELETE PHASE OR LOAD RESTART WHEN TABLE ID > 32767 (APPEARS NEGATIVE IN SYSTEM CATALOGS). IY07311 HASH JOIN FAILS WITH MEMORY ALLOCATION ERROR. INITIALIZATION FAILS CAUSING SUBAGENTS TO FAIL DURING MEMORY ALLOCATION. IY07376 LIBPATH NEEDS TO BE SET IN DB2 INSTANCE ON AIX OTHERWISE VARIOUS PROBLEMS CAN HAPPEN. 'NO SUITABLE DRIVER' FOR EXAMPLE. IY07453 TRAP IN SQLDFIXTCB DURING LOAD DUE TO INCORRECT RETURN CODE HANDLING IN SQLU_GET_TABLE_ID IY07483 STORED PROCEDURE FAILS TO PASS LOB DATA BACK TO THE CLIENT USING THE NET DRIVER IY07510 TRAP IN SQLNR_SCALAR20J_ACTION 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() IY07735 SQL0433N ENCOUNTERED WHILE DOING A BUFFERED INSERT IY07737 Signal#11 encountered during sort when tempspace is exceeded. IY07739 OPTIMIZER PREDICATE PROBLEM ON EEE WITH QUERY WRITTEN WITH UNION ALL IY07796 CMDEAL WITH TYPE CM_DEALLOCATE_ABEND DOESN'T RETURN IY07922 THE IN PREDICATE IN THE QUERY IS NOT PUSHED DOWN DUE TO OJ IY07957 DBHEAP OUT OF MEMORY (D602) DURING CRASH RECOVERY JR13651 SQL2029N, RC=28 ON RESTORE ISSUED FROM CLIENT WITH A DIFFERENT ALIAS THAN THE SERVER - USING SYTOS USEREXIT JR13887 ERRONEOUS 'FAILED TO COMMIT' MESSAGE DUMPED TO DB2DIAG.LOG LOAD INCORRECTLY HANDLES POSITIVE RETURN CODE FROM COMMIT JR14003 CALLING A STORED PROCEDURE FROM A V6.1 CLIENT (FROM A CLI APPLICATION) RESULTS IN SQL0804 WITH RC=103 JR14077 DB2/OS2: DB2SYSC.EXE TRAPS IN _UFREE (C RUNTIME) CALLED FROM _REGEN_EXCEPTION CALLED FROM SQLOADDENVSTRING JR14112 CLI0118E WITH 'SELECT {FN UCASE(T1.COL1)} FROM TABLE1 T1' JR14169 ALTER TABLE ADD COLUMN ON A TABLE WITH CLUSTERING INDEXES CRASHES THE DATABASE JR14174 SQL1403 WHEN CONNECTING TO DATABASE ON NT USING A USERID THAT IS THE SAME AS A DOMAIN NAME JR14184 MULTITHREADED FIXES NEED TO BE DONE TO DB2JD DUE TO VARIOUS PROB LEMS (EXAMPLE: DB2JD BECOMES UNAVAILABLE INTERMITTENTLY) JR14194 SQL0007N WITH SQLJ WHEN CALL STATEMENT INCLUDES A HOST VARIABLE JR14229 SQJ0201E DURING SQLJ CUSTOMIZATION OF CALL STATEMENT 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. APAR fixes included in WR21166b (Fixpak 12b) APAR No. Abstract -------- -------------------------------------------------- IY04033 INCORRECTLY PARSING AUTOLOADER INPUT PARAMETERS. IY04375 LOAD AGENTS DO NOT TERMINATE WHEN INPUT PIPES ARE BLOCKED DB2 FORCE DOES NOT FORCE THESE AGENTS IY06187 LOAD TRAPS (SQLBLOADGETEXTENT) IN ERROR PROCESSING.. IY06691 SQL4970 ON ROLLFORWARD TO END OF LOGS - 'UNEXPECTED FILECOUNT' IY06717 DDL GENERATED BY DB2LOOK FOR UNIQUE INDEXES CAN BE IMPROVED. 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. IY06932 SQL0973 QUERY_HEAP AFTER REPEATED ERRORS WHEN USING DESCRIBE DA (CLI) IY07038 INCORRECT RESULT WITH LARGE ASLHEAPSZ IY07040 SQLDESCRIBEPARAM IS CALLED ON A CALLABLE STATEMENT EVEN WHEN DISABLED. IY07111 CLIENT CONTROL CENTER CONNECT CAUSES EEE SERVER INSTANCE TO TRAP. 00/01/10 PTF PECHANGE IY07117 SIGNAL #11 IN FROM SQLRR_DUMP_SECTION WHILE EXECUTING A DB2_CALL _STACK IY07120 INSTANCE CRASHES WITH SIG#11 ON EXECUTION OF SELECT STATEMENT WITH UNION CLAUSE . IY07235 DB2DIAG.LOG AND TRAP FILE GROWS VERY LARGE AFTER SECOND INSERT UPON TABLESPACE FULL CONDITION. IY07244 SEARCH FOR FREE SPACE IS DONE EVEN IF APPEND MODE ON TABLE. IY07320 DROP TABLE FAILS WITH SQL1007N JR12399 FROM CONTROL CENTRE WHEN TRY TO FORCE MORE THAN TWO APPLICATIONS USING APP ID'S, THE OPERATION FAILS,INVALID AGENT ID. JR13185 JAVA APPLICATION RECEIVING SQL0502 DURING NORMAL COURSE OF OPERATION JR14024 INCORRECT CALL STATMENT USED WHEN CALLING STORED PROCEDURES ON AS400 SERVERS. USING LITERALS AS PARAMTERS. JR14049 SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG JR14085 SQL2025 FROM LOAD WITH DB2NTNOCACHE=ON JR14115 SQL3324N ERROR WHEN SQLDA PROCESS UNINITIALIZE SQLVAR WHICH GIVE SQLTYPE VALUE. JR14116 -514 ON SQLEXECUTE() FOLLOWING COMMIT ON OPEN CURSORS ON HOST JR14127 DB2 UDB V5.2 - TRAP IN FUNCTION SQLNQ_FINDFN WHEN RUNNING A SIMPLE SQL QUERY. JR14152 SQLJ EXHAUSTS CURSOR HANDLES AFTER 11613 STATEMENTS CLI0129E NO MORE HANDLES IS RETURNED APAR fixes included in WR21166a (Fixpak 12a) APAR No. Abstract -------- -------------------------------------------------- IY03544 CREATE DATABASE ON LARGE NUMBER OF NODES MAY HANG IY03698 CLI ARRAY INSERT PROBLEM WHEN ALL FIELDS IN A RECORD ARE NULL IY04404 DB2CLI.INI PASSWORD SETTING (PWD) OVERRIDES AUTOLOADER.CFG PASSWORD SETTINGSO THAT DB2ATLD FAILS TO CONNECT TO DB IY05169 SQL3015N ON LOAD INTO TABLE WITH MIXED CASE TABLE NAME. IY05294 DB2DARI PROCESS COUNTER NOT DECREMENTED IN CASE OF ABEND 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 IY05871 DLFM RETRIEVE_QUERY FAILS WHEN CMD LINE OPTIONS GIVEN BUT PROMPTS AND WORKS WHEN NO OPTIONS SPECIFIED 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 IY06164 WHEN AUTOCOMMIT IS ON AND SQLEXECDIRECT RETURNS A NEGATIVE SQLCODE, NO COMMIT IS SENT TO THE TARGET DATABASE. IY06211 INCORRECT QUERY RESULTS USING WHEN CASE STATEMENT WITH IN CLAUSE. IY06215 SQL0998 RETURNED TO CICS APPLICATIONS ISSUING STATIC ROLLBACKS, OR STATIC COMMITS. IY06234 JDBC RETRIEVAL OF NON-US CLOB TRAPS 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 IY06434 FIRST DB2START FAILS AFTER AIX V4.3 REBOOT IY06599 QUERY WITH UNION OVER JOINS GIVES WRONG RESULT IY06660 OPTIMIZER NEGLECTS TO CHOSE AN AST IN ITS ACCESS PLAN IY06806 DB2 CONNECT TRAPS IN SQLE_DB2RA_AS_DB_BLOCK_FETCH, WHEN CLIENTS CONNECT TO EE/EEE DATABASES THROUGH THE GATEWAY. JR13441 INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED JR13679 SYSLEVEL ON DB2/OS2 SERVER ALWAYS SHOWS EE PRODUCT INSTEAD OF THE INSTALLED DB2 PRODUCT. JR13824 JAVA I/O EXCEPTION ON WRITE TO BLOB OBJECT FROM STORED PROC JR13862 DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT JR13880 RETURN THE ODBC SCALAR NUMERIC FUNCTIONS SUPPORTED BY DB2/MVS JR13925 HANG DUE TO SEMAPHORE WAIT CONDITION DURING SQLALLOCCONNECT JR13974 FILTER FACTOR FOR ALWAYS-TRUE PREDICATE CAUSE SLOW QUERIES JR14025 SQL3181W WARNING GENERATED ON LOAD FOR A VALID IXF FILE APAR fixes included in WR21166 (Fixpak 12) APAR No. Abstract -------- -------------------------------------------------- GG03644 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 GG03962 SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP GG03963 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS GG03964 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS GG03965 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS GG03966 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS GG03967 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 GG03968 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 GG03970 GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED GG03974 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS GG03979 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS GG03980 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS GG03981 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS GG03982 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL GG03983 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IC24358 CHECK IN DJRA.EXE FOR V5.2 IX83660 SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS IY01325 TRAP IN SQLE_MRSPSENDDARISTAR IY03678 TRAP INDICATING SQLFXSYS_X AS FAILING FUNCTION. IY04173 DB2ADUTL DOES NOT GUARANTEE ORDER WHEN EXTRACTING LOGS FROM ADSM IF MULTIPLE COPIES OF THE LOGS EXIST. IY04310 DB2 UDB - ONLINE/OFFLINE BACKUP TO SEVERAL DISKS HANGS. IY04339 TRAP IN LOAD WHEN TEMP SORT FILE > 2GB SQLU_SMGETFREEPG() 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 IY04799 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS IY04800 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS IY04839 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS IY04840 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS IY04841 SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS IY04843 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 IY04844 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 IY04845 LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5 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 IY05319 OPTIMIZER PROBLEM WITH THE FILTER FACTOR WHERE WE DO NO ACCOUNT FOR DATA CORRELATION LEADING TO ANOTHER INDEX BEING USED... IY05590 DB2IUPDT IN FP11 RESETS DB2PROFILE 99/11/11 PTF PECHANGE IY05591 DB2 LOOPS, THROUGHT 2 LOG FILES, DURING ROLLFORWARD COMMAND IY05656 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05658 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05659 SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS IY05662 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05663 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05664 -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS IY05671 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05672 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05673 MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL IY05745 BUFFERPOOL CORRUPTION IY05751 SQLBINDPARAMETER WITH IBSCALE CHANGING ONLY - DB2 SHOULD IGNORE THIS AND NOT 'RE-DESCRIBE' THE COLUMN. RESULT - CLI0109 ERROR. 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. IY05892 CLP THROUGHPUT IMPROVEMENTS IY05910 INTERRUPTS GENERATED WITHIN COMMSERVER FLOODED DB2DAIG.LOG WITH DIA3107E ERRORNO '4'. IY05913 DB2ATLD BOUNDARY CONDITION CRASH IF LINEFEED IS ON A MULTIPLE OF THE 32K DATA FILE IY05980 CTRL-C APPLICATION CAUSES TRAP IN SQLEIAGT_CB IY06097 SQLBINDPARAM CALL COREDUMPS AFTER SELECT IS DONE, THEN ARRAY INS ERT IS ATTEMPTED. IY06145 ASCII FUNCTION RETURNS INCORRECT OUTPUT IY06740 DB SIZE ESTIMATE CALCULATED INCORRECTLY FOR BACKUP TO ADSM. HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE. JR13441 INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED JR13750 MULTIPLICATION OF DECIMAL CONSTANT GIVES INCORRECT RESULT JR13862 DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT JR13902 ROWSTATUS ARRAY INCORRECT WHEN -911 (DEADLOCK) OCCURS. JR13927 IMPLEMENT NEW BIDI LAYOUT TRANSFORMATION ROUTINE WITH MORE STRIN GENT ERROR CHECKING, MEMORY ALLOC, AND BIDI CCSID STRING TYPES. JR13949 DEFFERRED PREPARE RETURNS OPEN CURSOR FOR LARGE RESULT SETS. JR13957 CURSOR WITH HOLD NOT ALLOWED IN CICS JR13972 COMMIT IN LOAD WAS UNEXPECTEDLY INTERRUPTED. PQ30351 DPROPR APPLY, STL CMVC LEVEL PQ30351 FOR V5.2 FPK 12 TRCFLOW INVOCATION PARAMETERS APAR fixes included in WR21140c (Fixpak 11c) APAR No. Abstract -------- -------------------------------------------------- IY02577 DESCRIBE FAILS FOR UNICODE DB WITH A CODEPAGE CONVERSION IY03903 AFTER A TABLESPACE RESTORE, A 'ROLLFORARD QUERY STATUS' DOES NOT SHOW INFORMATION IN THE 'NEXT LOG TO BE READ' FIELD. IY04401 SQL1042 AT RESTART DB AFTER CRASH AT ALTER BUFFERPOOL IY04414 DARI PROCESS DOES NOT PICK UP GROUP ID FROM .FENCED FILE IY04471 -902 FROM SQLRIGTQ 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 IY05040 TRAP, SIGNAL #11, IN THE OPTIMIZER, SQLNO_CRULE_STARJN_AND(). IY05051 CATALOG CACHE MAY CAUSE LONG LOCKS TO BE HELD IN SYSTABLES IY05114 SQLM_COLLECTED.NODE_NUM NOT BEING SET WHEN SNAPSHOT TAKEN AGAINS T LOGICAL NODES OF A EEE INSTALLATION IY05115 SELECT COLUMN LIST > 4005 AND ORDER BY CAUSES SQL1224. IY05123 DB2 MONITOR LOCK SNAPSHOT MAY NOT SHOW LOCKS BEING HELD ON CATAL OG PARTITION DURING STATEMENT COMPLIATION 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 IY05292 DBA2065 TRYING TO RUN OR SCHEDULE SCRIPT FROM SCRIPT CENTER. IY05315 BAD ACCESS PLAN FOR WHERE IN (VAR1,VAR2....VARN) 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 IY05426 SQL1034N FOLLOWED BY INTERRUPTING ROLLBACK OPERATION IY05446 ADD PATCH VALUE TO RETURN TRUE ISO TIMESTAMP FORMAT FROM CLI IY05483 FIX FOR SPM ON SUN ULTRASPARC (SUN4U) ARCHITECTURE IY05608 CLI_MEMFREE TRAPS IN CLI_DSTFREEINFO WHEN OUT OF MEMORY JR13441 INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED 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 JR13816 CONTROL CENTRE ABENDS AFTER DISCONNECT FROM DB WHEN SNAPSHOT MONITORS RUNNING JR13821 DB2FLSN CAUSES SYS3175 TRAP IN OS/2 JR13829 ADD DB2CLIV2.BND IN .LST FILE FOR DRDA SERVERS (FUNCTION ADDED) JR13837 ADD CLI HANDLE INFORMATION TO DB2 TRACING JR13862 DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT JR13879 DB2 CONNECT GATEWAY TRAPS WHEN USING DOWNFIX CLIENT DURING STORED PROCEDURE CALL TO DB2 MVS. JR13882 TRAP IN SQLNO_PROP_BEST_SORT_KEY RUNNING QUERY ON VIEW. JR13909 DB2LOOK INSERTS COMMAS INTO DDL INSTEAD OF DECIMAL POINT FOR FLOATING POINT NUMBERS IN CERTAIN LOCALES/TERRITORIES JR13922 THIN CLIENT INSTALLING OLDER ODBC*.DLLS APAR fixes included in WR21140b (Fixpak 11b) APAR No. Abstract -------- -------------------------------------------------- IX87013 TEMPORARY FILES ARE CREATED USING BLOB WITH JAVA PROGRAMS 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. 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 IY04333 -516 ON DESCRIBE CAUSING LOOPING IN CLI IY04399 TRAP, SIGNAL #11, IN THE DB MONITOR, I.E. DURING COLLECTION OF TABLESPACE COUNTERS. IY04409 SIG#11 IN SQLSFETC IY04431 MIXED EMBSQL/CLI APP CORE DUMPS ON SQLDISCONNECT IY04446 CLI0002W WITH CLOB DATA WITH GETSTRING IF SELECT OTHER TYPE 1ST. 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 IY04732 SQL0902 RC=126 AT DROP TEMP TABLESPACE IY04769 NODEXXXX AND CATNXXXX NOT UPDATED CORRECTLY ON BACKUP IMAGES EXTRACTED FROM ADSM WITH DB2ADUTL IY04798 TRUST APP IS USING AN INVALID MEMORY ADDRESS 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 IY05015 FIRST CALL TO LOADQUERY() FAILS WITH ENOMEM JR12796 SQLCOLUMNS() CALL WITH ONLY TABLE NAME DISREGARDS SCHEMALIST AND CURRENTSQLID JR13437 TRAP IN DB2APP.DLL IN SQLFETCH OF BLOBLOCATOR JR13653 JDBC APPS AUTOCOMMIT IF STORE PROCEDURE CALL IS MADE. EXPLICIT ROLLBACK NOT POSSIBLE AFTER STP CALL. JR13684 SQL0901 IN FUNCTION SQLNO_SMP_CREATE_SHARED_SO JR13753 JDBC SETBYTES() MEMORY OVERWRITE IF INPUT VALUE LARGER THAN COLUMN WIDTH. JR13762 TRAP IN SQLEX_RDS_GEN_DATA. JR13782 DOSSLEEP(0) PREVENTED DB2 THREADS FROM DOING WORK WHEN HIGHER PRIORITY THREADS WERE RUNNING. JR13783 PARMLIST SYNTAX ERROR ON STORED PROCEDURE CALL TO MVS JR13795 DEFERRED PREPARE ALWAYS ON JR14088 100% CPU OR HANG SYMPTOMS DURING INSERT 99/12/21 PTF PE CHANGE APAR fixes included in WR21140a (Fixpak 11a) APAR No. Abstract -------- -------------------------------------------------- IY02032 TABLE ACCESSABLE AFTER ROLL FORWARD THROUGH AN NONRECOVABLE LOAD IY03631 DB2_RECON_AIDPACKAGING IN EE IY03689 ADDITIONAL INFORMATION TO BE DUMPED IN DB2DIAG.LOG WHEN A BAD PAGE IN MEMORY IS ENCOUNTERED. IY03853 SQLRA_COMPILE_VAR MESSAGES AT DIAGLEVEL 4 WHEN ON ERROR OCCURRED IY03855 EVENT MONITOR WITH AUTH_ID CONDITION DO NOT FILTER FOR EXISTING CONNECTIONS WHEN AT NODE IS USED. 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!) IY04240 CERTAIN QUERIES THAT RAN ON V5 RETURN SQL0101 - QUERY TOO COMPLEX ON V5.2. IY04291 -901 IN SQLRI_CLOSE_UDF_EOT(), -1034 DBM CRAHES JR13397 LIST HISTORY SHOWS BACKUP FILE ON WRONG NODE. JR13475 RETRIEVING A CLOB SUB-STRING GREATER THAN 32KB TRAPS ON THE GATEWAY. JR13645 SQLCOLUMNS RETURNS INCORRECT INFORMATION FOR DEFAULT VALUE JR13708 CLI APP TRAPS WHEN CLI TRACE IS ON AND SQLFETCH RETURNS != SQL_SUCCESS JR13736 SQLDESCRIBEPARAM FAILS ON DEFERRED PREPARE OF >= 26 COLUMNS. APAR fixes included in WR21140 (Fixpak 11) APAR No. Abstract -------- -------------------------------------------------- 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 GG03938 UNABLE TO GET GOCAPT FOR SOME TABLES GG03939 ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE GG03940 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 GG03942 GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION 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. GG03946 ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE. GG03947 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 GG03949 DPROPR FAILS ASN0001E SQLCODE811 GG03950 DPROPR FAILS ASN0001E SQLCODE811 GG03951 APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH 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. GG03956 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. GG03958 SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION. GG03959 GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION IX77854 SQL0901 DIAG FILE REPORTS ERROR IN BUFFER QUEUE SERVICES PROBE:30 SQLKQ_DETACH_BUFFER(). INTERNAL ERR 'LOST BUFFER' 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 IY01190 ROLLBACK OF CREATE TABLESPACE WITH > 1 CONTAINER NEVER UNTAGS CONTAINERS PAST THE FIRST ONE IY02447 ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE IY02448 ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE IY02449 ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE IY02556 CC: JOURNAL REPORTS INCORRECT JOB STATUS 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. IY02809 DPROPR FAILS ASN0001E SQLCODE811 IY02979 BPS ESTORE LOGIC ERROR CAUSES HANG IY03189 GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS IY03190 GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS IY03191 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 IY03193 BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET IY03194 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. IY03196 ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE. IY03197 ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE. IY03213 DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT IY03214 DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT IY03215 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 IY03218 UNABLE TO GET GOCAPT FOR SOME TABLES IY03219 UNABLE TO GET GOCAPT FOR SOME TABLES IY03287 DPROPR FAILS ASN0001E SQLCODE811 IY03288 DPROPR FAILS ASN0001E SQLCODE811 IY03318 APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH IY03319 APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH IY03320 APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH IY03379 DB2NODE ENVIRONMENT VARIABLE DOES NOT WORK FOR ALL CMDS IF PRTN NUM SPECIFIED IS NOT ON THE SAME PHYSICAL NODE. IY03415 THE SQL STATEMENT USED TO CALCULATE THE UPPER COPY LIMIT SPECIFIED AN INCORRECT SYNCHPOINT VALUE. IY03454 DB2 UDB - FIRST EXECUTION OF THE SIN UDF RESULTS IN SQL0443, RC 03. OTHER 'MATH' UDFS MAY ALSO EXPERIENCE THIS ERROR. IY03510 RESTORE FAILS WITH AN SQL0298N WHEN THE SAME CONTAINERS EXIST IN THE SQLNNNNN DIRECTORY... CANNOT REDIRECT THE RESTORE. IY03514 SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION. IY03529 RUNNING DB2EMPFA WHEN SMS TABLES GREATER THAN 4G EXIST CAN CORRUPT DATA. IY03536 SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT IY03538 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. 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. IY03543 SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION. IY03608 DB MARKED BAD AND BROUGHT DOWN WHEN LOAD INTO TABLE WITH RI. IY03621 GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION IY03622 GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION IY03630 RECONCILE SQL2554 DOES NOT GIVE DLFM SERVER NAME. IY03635 TABLESPACE FULL BRINGS DOWN DATABASE 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 IY03941 AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT IY04046 JDBC TRAP IF APPLICATION USES INVALID CONNECTION HANDLE IY04157 SET CURRENT PACKAGESET PRODUCES A SIGSEGV FROM WITHIN SQLJ IY04196 LOG FULL CONDITION WITH NODE LOG SYNC WILL CAUSE DB2 TO PANIC AN D CRASH. IY04221 EXPLICIT CONNECT FAILS WITH SQL1403 ON AIX IY04242 LOG FULL CONDITION DID NOT SAVE ENOUGH LOGSPACE FOR A TRANSACTION TO BE ROLLED BACK. JR12984 MS ACCESS APPL ERROR FROM DB2 V2.1 VIA DB2 CONNECT V5.2 TO DB2/M VS JR13539 TRAP IN SQLBFREEONEPOOL DURING DB RESTORE WITH LOW DBHEAP JR13567 XA ENVIRONMENT, SETTING ISOLATION LEVEL RETURNS CLI0126E. JR13610 ERROR LOGGED FOR SQLOFMBLK WHEN USING PREPARED STATEMENTS JR13624 SQLRLCLO IN SQLRL_FETCH TRAPS WHEN APPLHEAPSZ IS LOW JR13630 SQLPLRL() TRAPS AS SQLRLGTS() NOT CLOSING CURSOR JR13633 TRAP IN MONITOR SNAPSHOT JR13634 CLI COMPOUND SQL WITH DEF PREP FAILS IF SQLPREPARE BEFORE OPEN JR13667 DB2JDBC.DLL TRAPS WHEN RUNNING WEBSPHERE IN VISUALAGE JAVA APAR fixes included in WR21118b (Fixpak 10b) APAR No. Abstract -------- -------------------------------------------------- IX86459 CLP CHANGES ADMIN INSTANCE'S SVCENAME FROM 523 IY00980 BACKUP FAILS WITH SQL1062 BECAUSE OF LINKS IN THE DB PATH IY01489 LOG EXTENT 0 (S0000000.LOG) REQUESTED BY DB2 WHEN THE LOG SEQUENCE IS WELL PAST, IE. IN THE THOUSANDS. IY02464 -901 INDICATING BANDP NOT PUSHED DOWN IY02618 DB2 CONNECT GATEWAY TRAPS IN SQLJMF10. IY03081 APPLICATIONS CONNECTING TO DB2 SERVER OVER TCP/IP USING DRDA CAN NOT BE FORCED BY 'FORCE APPLICATIONS ALL' IY03129 DB2 INSTANCE COMES DOWN WITH A SIGNAL #36 DUE TO AN SQLE_PANIC CALL IN FUNCTION REMOVE_ME - EVENT MONITOR DEACTIVATION CODE. IY03133 SQL0901 'UNEXPECTED COLUMN USAGE TYPE' ON DELETE OPERATION ON TX ENABLED TABLE DUE TO TX TRIGGERS. IY03164 TRAP IN SQLT_DISPLAY_CA IY03175 EXCESSIVE MESSAGES IN DB2DIAG.LOG IY03229 FENCED DB2DARI PROCESS LEAKS 4K OF MEMORY PER INVOCATION IY03393 UNINITIALIZED MEMORY IN OPTIMIZER CAUSES SIGNAL #11 IN (SQLNO_CO PY_SETN,SQLNO_UNION_SETN) JR12926 JAVA GETSCHEMA RETURNS NULL WHEN USING OPTIMIZED CATALOG JR13103 DB2 UDB V5 FIX FOR WEBSPHERE 3.0 JR13123 WHEN USING BLOB LOCATORS, SQLGETPOSITION FAILS WITH CLI0102E INVALID CONVERSION SQLSTATE=07006. JR13499 RECOGNIZE '\' ESCAPE CHARACTER IN SCHEMA QUALIFIERS JR13545 DB2 UDB - SQLESRSP MARKS THE DATABASE AS BAD FOR ANY NON-ZERO RC FROM SQLRRAFI. SHOULD ONLY MARK DB BAD FOR CERTAIN NON- ZERO RC'S JR13547 CLI0606 WHEN RETRIEVING DECIMAL DATA WITH GETDOUBLE CALL FROM NT FOR SPANISH JR13548 INTERVAL OPTION IN THE GOVERNOR CONFIGURATION FILE DOES NOT ACCEPT VALUES OVER 300 SECONDS. GOV1027N IS RETURNED. APAR fixes included in WR21118a (Fixpak 10a) APAR No. Abstract -------- -------------------------------------------------- IX88671 TRAP IN SQLE_DB2RA_AS_DB_OPEN WHEN ATTEMPTING TO OPEN A CURSOR ON THE SPM DATABASE (AN UNSUPPORTED ACTION) IX88927 DB2ADUTL EXTRACT -> CANNOT EXTRACT IMAGES > 2G IX89959 CACHE STORED PROCEDURE DESCRIBE INFORMATION IY00843 IMPROVE THE HANDSHAKE BETWEEN SQE AND MONITOR CODE THAT CAN CAUSE A HANG IY01172 DB2ADUTL QUERY DB FULL IN MPP ENVIRONMENT DOES NOT RETURN CONSISTENT RESULTS WHEN BACKUP TIMESTAMPS IDENTICAL. IY01211 DEFENSIVE LOGIC TO DETECT 'PREVIOUS LOG EXTENT ID' BEING SET INCORRECTLY. IY01644 CURSORS/LOCKS BEING CLOSED IN XA TRANSACTIONS WHICH HAVE ALREADY BEEN CLOSED. IY01782 DB2ADUTL CORE DUMPS WHEN -1 PASSED FOR N ON THE COMMAND LINE. IY02049 DB2LOOK CHANGES AUTHORIZATION GROUP TO USER. IY02408 DB2 UDB - HANG ON INDEX REBUILD ATTEMPT. IN THIS CASE, INDEXREC WAS SET TO RESTART - SO THE CONNECT ATTEMPT WAS HANGING. IY02470 -4301 WHEN TRYING TO RUN SP THAT RETURNS CLOB IY02647 CLI TRIES TO GROW THE CONNECTION LIST (WHICH CANNOT BE DONE, THE LIMIT IS STATIC). IY02659 INTERMITTENT SQL0444 RC=4 REFERENCING UDF'S IY02764 ERROR MESSAGE FORMATTING IN ' SET TABLESPACE CONTAINERS ' MAY OVERWRITE THE STACK RESULTING IN SIGILL , SQL1224 INSTANCE CRASH IY02862 OUT OF SPACE IN THE DLFM_BACKUP_DIR_NAME NOT DETECTED IY02936 UNCONDITIONAL LOGGING ERROR ABOVE DIAGLEVEL > 1 BY OSS_2 SQLOOPENNODELIST IY02962 DEFUNCT CHILD PROCESSES ON SOLARIS WITH JDBC NET DRIVER IY03017 DB2GOV ALWAYS USE NODENUMBER 0 WHEN LANG IS JA_JP IY03069 LIST DCS APPLICATIONS LIST DUPLICATE THREADS IY03138 DB2BATCH -Q DEL INSERTS BLANK LINES AFTER EVERY ROW IN THE OUTPUT. JR12656 ODBC SQLTABLEPRIVILEGES DOES NOT RETURN THE PUBLIC PRIVILAGES JR12757 SQL2025 SHOULD BE RETURNED INSTEAD OF SQL2032, RC=14 WHEN RESTORING FROM ADSM AND TAPE IN ADSM SERVER IS OFFLINE. JR12938 COMMAND CENTER/NT TRAP AFTER ISSUED 'CONNECT TO 150/200 ROWS EXTENDERS TABLE HANGS (SQLUIHSH) IY01933 SQL0901 REPORTED BY SQLRAFRS() IY02162 MIN BUFF LSN SET TOO HIGH. THIS CAUSES RESTART TO FAIL IF SOME ESSENTIAL LOG RECORDS DO NOT GET REPLAYED. IY02257 DB2 UDB - PERFORMANCE DEGRADATION AFTER UPGRADING FROM FIXPAK 5 TO FIXPAK 8. OPTIMIZER COSTING DEFECT WAS THE CAUSE. IY02285 RANDOM VALUES COPIED INTO THE LSN SINCE VARIABLE NOT INITIALIZED IY02708 DEAD LATCH DURING CREATE TABLE WITH PRIMARY KEY JR12713 FFFFF616 IGNORED CAUSING DATABASE CORRUPTION JR13103 DB2 UDB V5 FIX FOR WEBSPHERE 3.0 JR13112 INSERT UDF CAN CRASH DB2 JR13152 IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY. JR13290 THREAD HANGS ON NT WHEN ASYNC SUPPORT IS ENABLED JR13333 EXECUTING A STORED PROCEDURE AGAINST A LOCKED TABLE CAUSES THE GATEWAY TO TRAP. JR13402 NAME SHARED EVENT SEMAPHORES MAY NOT BE UNIQUE WITH MULTIPLE INSTANCES, CAUSING THEM TO BE POSTED BY ANOTHER PROCESS. JR13405 APPL_NAME OPTION OF THE CREATE EVENT MONITOR COMMAND DOES NOT WORK. THE PROBLEM WAS DETECTED WITH NT, NOT AIX. JR13415 SMCODE -20 WHEN MONITORING ALIASED DATABASE JR13428 MEMORY LEAK WITH UDF'S IF RETURNING BLOBS OF VARYING SIZE JR13488 SQLCOLATTRIBUTES DOESN'T RETURN NULL STRING WITH SQL_DESC_BASE_T ABLE_NAME APAR fixes included in WR21112a (Fixpak 9a) APAR No. Abstract -------- -------------------------------------------------- IX89396 SIGNAL#11 IN SQLRR_OPEN IY00882 EVENT MONITORS WRITING TO PIPES NOT GETTING CLEANED UP ON DB2STOP FORCE - SQL1614 RC 6 TRYING TO RESTART EVENT MONITORS IY01210 DB2GOV MISSING DB2GOVD VALIDATE IF STARTING ON ONE NODE IY01295 TUXEDO TX_ROLLBACK() FOLLOWED BY TX_BEGIN() RESULTS IN TPEPROTO ERROR. IY01397 DB2 UDB 5.X: EEE SPECIFIC: PERFORM INTERNAL FABRICATE STATS PROC ESSING (IF REQUIRED) LOCALLY IF POSSIBLE IY01401 APPLICATION SNAPSHOT REPORTS THE WRONG INFORMATION IY01429 DB2 UDB 5.X MAY GIVE SQL0901 IF INTRA_PARALLEL ON IY01525 DB2LOOK DOES NOT SHOW A TABLE WAS CREATED WITH 'NOT LOGGED INITIALLY'. NECESSARY FOR THE 'ALTER TABLE' COMMAND. IY01885 MEMORY LEAK WHEN USING ARRAYINPUT IY02027 IF MVS COLUMN IS DEFINED AS REAL, SELECT ON IT CAN FAIL WITH SQL0304. OUR MAX OF REAL IS SMALLER THEN MVS MAX OF REAL. IY02029 TRAP INSIDE OF SQLEJNMSTP_SETBIGDECIMAL WHEN USING A BIGDECIMAL AS A PARAMETER OF A STORED PROCEDURE. IY02092 CHANGE USER FROM CONTROL CENTER TRAPS IN DB2CC.EXE IY02147 START OF DB2JD CAUSES SEGMENTATION FAULT. JR13156 PARAMETER MARKERS IN JDBC APPLICATION ARE BEING BOUND WITH THE WRONG SIZE CAUSING CLI0109E STRING DATA TRUNCTION ERRORS. JR13324 CALLING STORED PROCEDURES ON AS/400 WITH MORE THAN 9 PARAMETERS CAUSES EXTRANEOUS DATA TO BE SENT IN THE CALL JR13344 IF EXECUTE FAILS, CLI REUSES THE DESCRIBE INFO FROM A PREVIOUS STATEMENT. JR13354 SQL 1404 FROM MVS IS IGNORED BY CLI (ODBC) APPLICATIONS DEFECT # 120629 JR13355 THREE WAY JOIN OF REPLICATION TABLES FROM CONTROL CENTER CREATES INCORRECT SQL. JR13363 CCA CANNOT TRUNCATE COMMENT FIELD ON ADD DATABASE. APAR fixes included in WR21112 (Fixpak 9) APAR No. Abstract -------- -------------------------------------------------- GG03863 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES GG03864 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 GG03866 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 GG03868 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 GG03870 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 GG03872 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 GG03875 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 GG03877 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH GG03878 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS GG03879 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS GG03880 ASNMIG DOESNT SET/MIGRATE COLUMN SYNCHTIME IN IBMSNAP_SUBS_SET GG03881 ASNMIG DOESNT SET/MIGRATE COLUMN SYNCHTIME IN IBMSNAP_SUBS_SET GG03883 VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION GG03885 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE GG03887 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS GG03888 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS GG03889 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED GG03891 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER GG03892 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. GG03894 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 GG03896 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 GG03899 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 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 GG03905 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. GG03906 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 ONLY PROCESSES LAST EVENT POSTED 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 GG03917 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS GG03918 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS GG03919 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 GG03920 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 GG03921 VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION IX87116 ADD THE OPTION TO SPECIFY THE COLUMN DELIMITER AND CHANGE THE IX87233 DB2_ALL DOES NOT WORK FROM USERIDS OTHER THAN INSTANCE OWNER AFT ER APPLYING UDB EEE 5.2 IX88078 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IX88123 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES IX88124 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES IX88125 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 IX88131 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES IX88132 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 IX88139 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT IX88140 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 IX88142 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS IX88143 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 IX88145 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY IX88146 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY IX88394 TRAP IN CONTROL CENTER - JOURNAL AFTER ALTERING A TABLESPACE SUCH THAT IT IS ASSOCIATED WITH A NEW BUFFERPOOL. IX88536 DBADM SHOULD BE PERMITTED TO ADD USER FROM CONTROL CENTER. SYSADM IS CURRENTLY REQUIRED IN ORDER TO RETREIVE USERS FROM OS. IX88992 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION IX88993 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION IX88994 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 IX88996 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH IX88997 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH IX89054 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IX89055 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IX89665 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS IX89691 TRAP IN SQL_DB2RA_AS_DB_OPEN. IX89839 DB2 IS RETURNING A '27' INSTEAD OF THE '' FOR SQL0973 IX89997 UNTYPED PARAMETER MARKERS CAST INCORRECTLY WHEN IN CLAUSE USED IY00045 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE SQLCODE911 DATA LOSS IY00100 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS IY00101 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS IY00229 TQ HANG IY00230 IF SQLFREESTMT FAILS WITH -30081,DON'T RETURN SQL_ERROR ON FREE IY00412 DB2JD LISTENER CANNOT BE STARTED IF YOU HAVE DISABLEMULTITHREAD=1 IN YOUR DB2CLI.INI. IY00473 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY IY00603 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER IY00604 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER IY00605 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. IY00611 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. IY00612 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. IY00782 EINVAL IN SQLOCSHR IN DB2CART , SQLO_NO_SEG IN SQLGMRP FFFF D605 ALSO CRASH RECOVERY ENDING TO EARLY IY00795 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION IY00796 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION IY00797 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 IY00799 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 IY00800 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 IY00838 USING 'CONNECT TO USER CHANGE PASSWORD' FAILS WITH SQL1403N, BUT ACTUALLY CHANGES THE PW OK... USING NIS. IY00858 TRAP IN MEMTREEPUT FROM SQLMON_CONN::STMT_START IY00867 TRAP IN SQLRA_CSM_DROP_SECT 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 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 IY00971 SNAPSHOT DOESN'T SHOW ALL LOCKS BEING HELD IY00975 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE IY00976 RESTORE FAILS WITH SQL0973 - NOT ENOUGH SPACE IN LOCK LIST HEAP. IY00977 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED IY00986 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. IY00987 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. IY00988 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 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 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 IY01020 OPTIMIZER DOES NOT ADJUST FOR CORRELATION IN QUERIES INVOLVING L OT OF TABLES AND PREDICATES. IY01157 RESTART FAILS, DIAGLOG INDICATES: SQLPGRLG PROBE: 0 'A CORRUPT PAGE WAS ENCOUNTERED IN A LOG FILE DURING CRASH RECOVERY' IY01281 ERRONEOUS -902 IN SQR MARKS THE DB BAD IY01282 SIGNAL #11 DB MONITOR CODE AGENT_STMT_START() IY01371 THE CLIENT APPEARS TO HANG. IT ACTUALITY KEEPS CALLING SQLE_DB2RA_GETDATA(). IY01375 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS IY01376 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS IY01377 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS IY01378 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 IY01379 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 IY01380 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 IY01386 TRANSACTION NOT FOUND MESSAGES IN DB2DIAG.LOG IY01392 INDEX LOG SPACE RESERVATION IY01429 DB2 UDB 5.X MAY GIVE SQL0901 IF INTRA_PARALLEL ON IY01710 DB2LOGGER FILLS UP THE FILE SYSTEM AND BADLSN REPORTED IN THE DIAG FILE IY01726 -952 WHEN RUNNING STORED PROCEDURE TO EEE IY01762 JNI PANIC: JNI RECEIVED A NULL ARRAY (WHEN USING APP DRIVER) IY01883 DB MARKED BAD ERROR IN SQLBCHECKSMP4OBJDEL IY02026 WRONG COLUMN SPECIFICATION IN LOAD COMMAND LEADS TO CONNECITON T ERMINATION, SQL1224N,GIVES WRONG ERROR MESSAGE. JR12556 CREATE DATABASE FROM BACKUP IN CC RETURNS SUCCESS WHEN ONLINE BACKUP IMAGE IS USED WITH 'ROLLFORWARD PENDING' UNCHECKED. JR12774 ADVANCED ODBC SETTINGS ARE TRUNCATING THE PATCH1 VALUE 100973 -- DEFECT NUMBER JR12918 TABLETYPE KEYWORD NOT EXCLUDING SYNONYM TABLE TYPES JR12964 STATEMENT VIEW OF EVENT MONITOR IN CONTROL CENTER CREATES MULTIPLE CONNECTIONS. JR12995 WHEN USING A JAVA APPLET (JDK 1.2) TO SELECT FROM A CHAR COLUMN OF AN MVS TABLE, THE DATA IS SOMETIMES TRUNCATED. JR12996 TRAP IN SQLJMF06() IN SQLJMFR1.C WHEN WE TRY TO SET THE EXPECTED OUTPUTFLAG VARIABLE THAT INVOLVES SQLE_DB2RA_DB_EXECUTE_FLAGS JR13009 SQL1109N 'DLL NOT FOUND' WHEN CALLING A JSP WITH POWERBUILDER DEFECT#: 108302 JR13091 SQL30020 RC=124C PLUS DUMP FILES WHEN SELECTING FROM HOST DATABASE IN ASYNC MODE. JR13153 DB2 CONNECT GATEWAY TRAPS WHEN LARGE ARRAYS PASSED AS INPUT PARAMETERS. JR13157 MORERESULT FLOWING EXTRA FLOWS TO THE HOST ONLY. JR13169 #DELETED GETS DISPLAYED IN MS ACCESS WHEN DISPLAYING A DB2 TABLE THAT HAS A PRIMARY KEY ON A DATE COLUMN OR DECIMAL COLUMN JR13194 ADDING ACCOUNT STRING FOR MVS TO THE DB2CLI.INI FILE DEFECT ACTION PLAN: 116373 JR13200 SETTING BOTH ODBC 2.0 AND ODBC 3.0 ENVIRONMENTS DEFECT # 116384 JR13202 SQL0502N AND SQL0514N ERRORS AS A RESULT OF TIMING HOLE, WHERE IT LOOKS LIKE 2 STATEMENTS ARE USING THE SAME CURSOR. JR13217 SQLGETINFO(SQL_ORDER_BY_COLUMNS_IN_SELECT) REPORTS 'N' INSTEAD OF 'Y' FOR DB2/390 V5.1 JR13218 PARENTHESES AROUND ON CLAUSE FOR JOINS CAUSE SYNTAX ERROR FOR DB2/390. JR13223 CALLING STORED PROCEDURE AGAINST DRDA HOST RETURNS SQL - 1224, -902 OR NO RESULTS WHEN THERE SHOULD BE. DEFECT 116964 JR13269 USEREXIT ARCHIVES MAX 63 LOG FILES AFTER ERROR IS CORRECTED. JR13270 JAVA NET DRIVER MEMORY LEAK WHEN SELECTING BLOBS JR13278 REGISTRY INFORMATION INCORRECT FOR DB2CLI.DLL AND DB2ODBC.DLL JR13295 THE DB2PEM32.DLL IS NOT THREAD SAFE. SO WHEN TWO THREADS ATTEMPT TO CHANGE THE PASSWORD AT THE SAME TIME DB2PEM32.DLL TRAPS. JR13315 DRDA STREAM TERMINATING WITH CM_PROGRAM_ERROR_PURGING WHEN PASSING SQLDA TO HOST. JR13332 CHANGE PASSWORD FOR 8 CHAR USERIDS RETURNS INVALID USERID. PQ27660 CHECK IN REPLICATION APPLY FOR V5 FIXPAK 9 APAR fixes included in WR09093i (Fixpak 8i) APAR No. Abstract -------- -------------------------------------------------- IY00045 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE SQLCODE911 DATA LOSS IY00268 LOAD TRAPS DURING THE BEGINING OF THE BUILD PHASE ON 4 WAY SMP BOX WITH LOAD PARALLESIM SET TO 4 IY00403 ALLOW SOLARIS NON-THREADED LOADABLE OBJECTS FOR DB2_NOTH.SO IY00674 DB2ATLD HANGS IF PLACED IN BACKGROUND WITH & AND AUTHENTICATION = NO IY00676 SQL1403 ON CONNECT TO DB WITH USER USERID USING PASSWD. IY00718 HASH JOIN PLAN MAY HANG IN RARE CIRCUMSTATNCES IY00761 TRAP IN SQLDDELTCB (SQLDFREETCB) ON NORMAL DATABASE DEACTIVATION PROCESS IS DB2PFCHR (PREFETCHER) IY00793 MAPPING -965 FROM OS/390 TO -430 ON DB2 UDB JR12749 POINT IN TIME ROLL FORWARD RECOVERY FROM CC DOES NOT WORK JR12751 CONTROL CENTER CRASHES DUE TO JOURNAL HISTORY FILE PROBLEMS. JR13169 #DELETED GETS DISPLAYED IN MS ACCESS WHEN DISPLAYING A DB2 TABLE THAT HAS A PRIMARY KEY ON A DATE COLUMN OR DECIMAL COLUMN JR13242 BACKUP FAILS WITH SQL1042C USING MSCS DUE TO MIXED CASE DRIVE MAPPING. JR13256 BIDI LAYOUT TRANSFORMATION CODE RETURNED AN ERROR, WHEN THE INPUT AND OUTPUT BUFFER LENGTHS WERE ZERO. APAR fixes included in WR09093h (Fixpak 8h) APAR No. Abstract -------- -------------------------------------------------- IX87116 DB2BATCH DEFECTS (REMOVE EXTRA SPACES EXTRA BLANK LINES, APPEN IX88493 DB2_CORRELATED_PREDICATES=YES MAY CAUSE OVERESTIMATES OF CARDINA LITY (AND UNDERESTIMATES OF FILTER FACTORS) IX88675 DB2BATCH WITH -Q OFF OPTION DOES NOT FORMAT OUTPUT PROPERLY FOR NULLED FIELD. IX88793 -902 ON DROP TABLESPACE WHILE LOAD RUNNING IX88801 PARALLELISM NOT WORKING WITH ODBC APPS TO MVS 5.1.1 IX89062 SQL0901 WHEN HASH_JOIN PLAN IS CHOSEN IX89405 SIGNAL#11 IN SQLOLGSEMPOST IX89467 CURRENTSQLID IS NOT PICKED UP BY CLI APPLICATIONS AND THE LOGON ID IS USED INSTEAD. IX89535 SQL0433N ON QUERY WHEN CAST FUNCTION RETURNS WRONG SQLLEN IX89871 -901 SQLNO_ITR_PLAN::NEXT AT LOCATION 300 - PLAN NOT FOUND IY00403 ALLOW SOLARIS NON-THREADED LOADABLE OBJECTS FOR DB2_NOTH.SO IY00444 HASH JOIN USES UP ALL THE MEMORY AND CAUSES EDU CRASH. IY00480 ENSURE DB2AUDIT RETURNS 0 RC INSTEAD OF 6 WHEN SUCCESSFUL JR11822 LOAD OF DEL ON NT CAUSES DB2 TO TRAP, AND DB2 TO BE INCONSISTENT FUNCTION NEEDED FOR USE OF ZIP/JAZ DRIVES JR12812 BIND MESSAGES TRUNCATED IN CCA JR13171 LOAD RETURNS SQL3114W IF DATA IN DEL FILE HAS TRAILING BLANKS JR13184 DURING CONFIG. OF CLIENT USING CCA AND IMPORT PROFILE ALWAYS TAK E APPC CONNECT SYMBOLIC DESTINATION TO SYSDST0 & SESSION IBMRDB JR13187 IMPROPER CHECK ON LENGTH FIELD CAUSING A MEMORY OVERWRITE WHICH RESULTS IN A TRAP IN SQLEUPDATELIST JR13204 MEMORY LEAK CONNECTING TO LOCAL DATABASE AND DB2START NOT ISSUED APAR fixes included in WR09093g (Fixpak 8g) APAR No. Abstract -------- -------------------------------------------------- IX87450 FILE MANAGER EXPORT CONTROL FILE NOT BEING CREATED WHEN SPECIFIC COLUMNS SPECIFIED IN THE SELECT FROM THE EXPORT. IX87741 INCORRECT ROUND FUNCTION OUTPUT. IX87911 DB2 UDB ERROR 28 IS INCORRECTLY RETURNED BY THE SAMPLE USEREXIT WHEN LOG FILE WE ARE TRYING TO ARCHIVE DOES NOT EXIST. IX88096 WE ARE NOT RETURNING 0 ON A GETINT OR GETLONG IN A JAVA APP WHEN THE VALUE IS NULL. IX88660 SQL0302N WHEN INVOKING A STORED PROCEDURE ON AS/400 FROM A JAVA PROGRAM. IX89850 USING PKGRM "DB2 PACKAGES" COMMAND ,DELETES SUN PATCHES ALSO. IY00157 DB2LOOK HAS TROUBLE DISTINGUISHING BETWEEN SERIAL AND PARALLEL MODE IY00239 JDBC APPLICATION FAILS WITH CLI0601E 'INVALID HANDLE' IF A SELECT STATEMENT QUERIES MORE THAN 100 COLUMNS IY00270 SELECT WITH LIKE CLAUSE HAVING DATA WITH LEADING &TRAILING BLANKS PRODUCES ERRATIC RESULTS. IY00360 ADD OBJECT REXX SUPPORT IN UDB EEE V5.2 FOR AIX. JR13150 QUERY WITH LIKE CLAUSE TRAPS GENERATING THE ACCESS PLAN (FILTER FACTOR MORE SPECIFICALLY, IN SQLNO_FF_COMPUTE_LIKEPRD) JR13156 PARAMETER MARKERS IN JDBC APPLICATION ARE BEING BOUND WITH THE WRONG SIZE CAUSING CLI0109E STRING DATA TRUNCTION ERRORS. APAR fixes included in WR09093f (Fixpak 8f) APAR No. Abstract -------- -------------------------------------------------- IX88660 SQL0302N WHEN INVOKING A STORED PROCEDURE ON AS/400 FROM A JAVA PROGRAM. IX89209 ABILITY TO FIX TERRITORY FIELD FOR DATABASES MIGRATED FROM V2 TO V5 WHERE THE TERRITORY IN THE DB CFG FIELD IS NOT READABLE. IX89426 CALLING STORED PROCEDURE CAUSES GATEWAY TO CRASH IX89506 SPURIOUS PACKAGE CACHE OVERLOW MESSAGES IN DB2DIAG.LOG CAUSED BY TIMING HOLE IN NEW PACKAGE CACHE MANAGEMENT IX89840 REALLOCATION OF OLD LOG DURING DB TERMINATION CAUSES DB TO SHUTD OWN IX89896 SCHEDULED BACKUP FROM CONTROL CENTER WITH MULTIPLE DIRECTORIES INCORRECTLY PLACES .002 ETC. FILES UNDER %SYSTEMROOT%\SYSTEM32 IX89960 DON'T SEND EXTRA FETCH TO SERVER IF SQLCODE IS +100 IX89962 DB21016 ON 'DB2 GET INSTANCE' - SAME COMMAND HANGS WHEN TRACING. IY00034 PROGRAM FLOW ERROR IN MGJN CAUSES PERFORMANCE DEGRADATION. JR12990 SQLTENTR_CEI_FIT1 SYMBOL NOT FOUND ON OS/2 FOR MF COBOL APP JR13114 DB2DEFPREP=YES NOT DISABLED FOR PREPARE WITH INTO CLAUSE JR13141 CATALOGGING RETURNING A SQL1092 ERROR WHEN MEMBER OF ADMINISTRATOR GROUP AND A DOMAIN USER APAR fixes included in WR09093e (Fixpak 8e) APAR No. Abstract -------- -------------------------------------------------- IX71710 RECLAIMED TOO MUCH LOG SPACE APPEARS DURING CRASH RECOVERY IX88078 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IX88660 SQL0302N WHEN INVOKING A STORED PROCEDURE ON AS/400 FROM A JAVA PROGRAM. IX88868 DB2ATLD MAY WAIT ON X ROW LOCK ON SYSCOLUMNS. IX89305 DB2 REPORTS SQL1042C WITH ROLLFORWARD WHICH IS CAUSED BY AN INTERRUPT. IX89506 SPURIOUS PACKAGE CACHE OVERLOW MESSAGES IN DB2DIAG.LOG CAUSED BY TIMING HOLE IN NEW PACKAGE CACHE MANAGEMENT IX89661 SQL2038 RC=-1062 ON RESTORE OF DATABASE CREATED ON ROOT FILE SYSTEM I.E. ON '/'. IX89927 CONTAINER REMOVED WHEN ROLLING FORWARD THROUGH A FAILED ADD CONTAINER FOLLOWED BY A SUCCESSFUL ADD CONTAINER JR13043 DB2 BACKUP DATABASE COMMAND ON NT FAILS WITH SQL2025 RC 1450 ERROR_NO_SYSTEM_RESOURCES JR13076 MEMORY LEAK IN JVM WITH JAVA UDF APAR fixes included in WR09093d (Fixpak 8d) APAR No. Abstract -------- -------------------------------------------------- IX85148 -902 SQLCODE ON ROLLFORWARD OF TABLESPACE TO POINT IN TIME IX86967 DB2 USING TOO MUCH SWAP SPACE ON SOLARIS. IX87910 LOCKING BEHAVIOUR AT CS TO BE CHANGED FOR BOUNDARY CONDITIONS. IX87941 SECOND CALL TO JAVA STP FAILS WITH 'NOT ENOUGH MEM' (UNFENCED) IX88739 DB2ATLD DOES NOT LOAD DATA WHERE THE DATE COLUMN IS IN THE PARTITION KEY. IX89216 SIGSEGV WHEN GREATER THAN 100 CONNECTIONS USING JDBC IX89661 SQL2038 RC=-1062 ON RESTORE OF DATABASE CREATED ON ROOT FILE SYSTEM I.E. ON '/'. IX89677 DROP INDEX CRASHES INSTANCE DUE TO INVALID INDEX SPACE MAP HEADER INFORMATION JR12815 EXPORT DEL USES COMMA INSTEAD OF PERIOD AS DEFAULT JR12946 SELECT FAILS SQL1224N RECORD LENGTH > SQL_MAXRECL.A70F 0000 JR13006 DB2ENG.DLL TRAPS BY BACKUP USING USEREXIT ON OS/2 SMP MACHINE AND/OR INTRA_PARALLEL YES - TRAP IN SQLEBUILDBDSUNIQUEID JR13056 TRAP IN SQLNO_COST_NLJN - THIS APAR IS TO PROVIDE MORE INFORMATION IN DB2DIAG.LOG (-901) IF TRAP OCCURS AGAIN. JR13089 DB2 IMPLEMENTATION OF OS MESSAGE QUEUES APAR fixes included in WR09093c (Fixpak 8c) APAR No. Abstract -------- -------------------------------------------------- IX87063 SQL1072 ON DB2START - FTOK CAN'T GENERATE UNIQUE IPC KEYS ON SOLARIS UFS WITH NEW DIRECTORIES WHEN RANGE OF INODES IS HIGH IX87722 TRAP IN SQLEX_DDCSGW_DEL_USER_CONTEXT IX88179 THE TYPE CASTING OF VARCHARS TO DECIMAL IN THE CREATE STATEMENT FOR UDF RESULTS IN THE LOSS OF PRECISION IX88441 LOAD ISSUES WITH NONRECOVERABLE OPTION IX88761 QUEISCE EXCLUSIVE RESET IS NOT WAD. AFTER A USER IS FORCED OFF THE SYSTEM THE PHANTOM QUIESCE IS NOT ACQUIRE BY NEXT USERID. IX88966 SQLDESCRIBEPARAM TRAPS IF SQLPREPARE HAS A WARNING IX88969 DB2JD LEAVES CHILD PROCESSES WHEN APPLETS COMPLETE. IX88981 -902 ON DB2 ADD NODE IX89057 ISCAN FETCH WHEN IT SHOULD HAVE BEEN AN INDEX ONLY ACCESS IX89238 SIG#11 IN SQLNR_OPTPRE/ENV_PRD_REPLICATE WHEN QUERY EXECUTED IX89285 ALTER TABLESPACE ADD FAILS AFTER REDIRECTED RESTORE WITH SET TABLESPACE ... IGNORE ROLLFORWARD CONTAINER OPERATIONS IX89317 SAP - ACCESS PLAN CHANGED BY ADDING INDEXES WHICH ARE NOT USED IX89341 DB2ADMIN STOP FAILS WITH SQL1092N JR12885 USING ADO IN VB TO RETRIEVE PACKED TYPE FROM A MVS RECEIVES 'INVALID PRECISION' ERROR. DEFECT #103555 JR12906 DB2SNMPD NOT ISSUING AN SNMP TRAP FOR ALL DB2 ERRORS OF TYPE SEVERE JR12941 SQLOREADFILEINTERRUPT TRACEPOINTS APPEARING IN NT/DB2DIAG LOGS I NCORRECTLY JR12948 APPLETSECURITYEXCEPTION WITH APP DRIVER DUE TO SYSTEM PROPERTIES JR12962 QUERY TRAPS: SQLNO_COST_MGJN JR12982 NEWLOGPATH UPDATE IN DB CFG LOS NT ERROR EVENT, WORKS FINE JR12989 CALL TO SQLESTAT FAILS WITH SQL1428 WHEN ATTEMPTING TO COLLECT DB INFORMATION FROM BOTH LOCAL AND REMOTE DBS IN ONE PROCESS JR12998 LIST DCS APPLICATIONS DISPLAYS THE GUID INSTEAD OF THE APPLICATION NAMES AFTER APPLYING WR09084. JR13027 OPTIMIZER PLAN INCORRECT WHEN HANDLING NULLS IN INDEXES. JR13040 DB2UEXT2.C FOR NT REFERS TO DB2UEXT INSTEAD OF DB2UEXT2 IN THE COMMENTS APAR fixes included in WR09093a (Fixpak 8a) APAR No. Abstract -------- -------------------------------------------------- IX86007 SIGNAL#11 IN SQLULADDINXKEYS IX86970 NOT ENOUGH LOG SPACE RESERVED IN REORG IX87877 SIG#11 IN GET_DBMON_BP ON RESTART IX87910 LOCKING BEHAVIOUR AT CS TO BE CHANGED FOR BOUNDARY CONDITIONS. IX88041 SQLJ BINDING STRING HOST VARIABLES TO AN OS/390 DB YIELDS SQL0134. IX88274 HANG ON CRASH RECOVERY DUE TO LOCK-WAIT ON SYSTABLESPACES IX88408 POSSIBLE DATA INCONSISTENCY IX88449 POSSIBLE -902 WHEN USING SCROLLABLE CURSOR IX88454 DB2/EEE 5.2 FP#7: DB2ATLD MAY HANG WITH 'LOAD ERROR: UNABLE TO QUEISCE POOLS FOR TABLE.' IN DB2DIAG.LOG IX88563 SELECT FROM VIEW RETURNS INCORRECT ROWS IN V5, FOR V1 DATA IX88738 DB2BATCH IN MPP MODE UNEEDED HEADERS/FOOTERS IX88741 DB2BATCH IN MPP MODE DOESN'T USE NOT LOGGED INITIALLY TABLES FOR ITS TEMP TABLES IX88816 SQL2542N RESTORING PE DB WITH TAKEN AT OPTION IX88834 SEGV IN SQLNR_CORRELATED_TOQUN IX88873 DB2ATLD MAY HANG AT INITILIZATION PHASE IX88917 INCORRECT OUTPUT FOR GET SNAPHOT FOR DCS APPLICATIONS IX88942 DB2ATLD LOCK-WAIT ON SYSPARTIONMAPS IX88968 SQL1224 WITH 'SEGMENTED TABLE PAGE NUMBER WAS TOO HIGH' IN DIAG LOG. POOLPGNUM = 5A454B41 -> > ALLOWABLE RANGE. JR12750 INCORRECT DDL PRODUCED FOR CHANGE DATA TABLES CONTAINING DATE/TI ME/TIMESTAMP WITH DEFAULT DATE/TIME/TIMESTAMP JR12781 DB2START ON ACTIVE DBM DUMPS B700 IN DB2DIAG.LOG JR12816 V5.2 LOAD UTILITY DOESN'T BLOCK LOADING DATA INTO TYPED TABLES AND IT SHOULD ACCORDING TO THE V5.2 ADMIN GUIDE P. 204. JR12822 NT EVENT LOG FILLS UP WITH SQL0502 AT DIAGLEVEL 4 WITH VB (ODBC JR12912 SQL GENERATED BY CONTROL CENTER FOR REPLICATION CONTAINS DUPLICATE NAMES. TIME STAMP NOT UNIQUE. JR12915 GATEWAY CRASHES IN COLUMNNAMES LIST DURING A CALL TO A SP JR12919 UNDERDBDIR FIELD OF SQLB_TBSCONTQRY_DATA STRUCTURE IS NOT REVERSED WHEN USING SQLBTCQ API ON NT AND CONNECTING TO AIX. JR12922 API SQLESTAT CHECKING VERISON OF SERVER CODE INCORRECTLY CAUSING A TRAP. JR12936 AFTER UPGARDING GATEWAY TO WR09084, INTERMITTENT DB2 CONNECT TRAPS IN REMOVE_RDCS_DB@SQM_LIST_DCS_DB_RESETTABLE_DATA JR12958 PRECOMPILER GENERATES DIFFERENT SQL TYPE FOR CHAR HOST VARIABLES INSIDE A STRUCTURE DEPENDING ON LOCATION OF SHORT HOST VARIABLE. JR12966 DB2 CONNECT GATEWAY TRAPS IN FUNCTION SQLJMPAR JR12971 SQLJS_DDM_SYNCRSY IS TRAPPING UPON A RESYNC INITIATED BY OS/390. EVEN WHEN SPM IS NOT CONFIGURED. JR13001 UDB GATEWAY CRASHING WHILE CONNECTING CLIENT TO SERVER WITH TCP APAR fixes included in WR09093 (Fixpak 8) APAR No. Abstract -------- -------------------------------------------------- GG03840 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN GG03841 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN GG03843 AUTHID COLUMN IN UOW TABLE IS INCORRECT GG03844 AUTHID COLUMN IN UOW TABLE IS INCORRECT GG03845 NULL LONG VARCHAR VALUES NOT REPLICATED GG03846 NULL LONG VARCHAR VALUES NOT REPLICATED GG03847 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN GG03848 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. GG03849 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 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 GG03853 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN GG03854 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN GG03855 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN GG03856 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030 GG03857 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD GG03858 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD GG03859 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030 GG03860 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD GG03861 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX82599 DB2 UDB RACE CONDITION IN DB2LICD. LEADS TO REMOVAL OF IPC Q 0 (USUALLY!). UNLIKELY ON NON-MLNS, POSSIBLE ON MLNS. IX83104 ESTORE PROBLEMS DUE TO AIX MEMORY SEGMENTS NOT ATTACHING TO OPTIMUM POSITIONS. IX83408 FAILING BACKUP NOT RECORDED IN HISTORY FILE IX83662 SIGNAL#11 IN SQLKD_RCV_DATA IX84195 DBLOOK CAUSING MEMORY PROBLEMS SINCE V5.2 RELEASE IX84766 RESTART FAILS WITH SQL0575 WHEN REPLICATED TABLE IS INVALID IX85990 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN IX85991 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN IX85992 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN IX86080 AUTHID COLUMN IN UOW TABLE IS INCORRECT IX86081 AUTHID COLUMN IN UOW TABLE IS INCORRECT IX86082 AUTHID COLUMN IN UOW TABLE IS INCORRECT IX86221 DB2 5.2: RESTORE HANGS IX86911 NULL LONG VARCHAR VALUES NOT REPLICATED IX86913 NULL LONG VARCHAR VALUES NOT REPLICATED IX86914 NULL LONG VARCHAR VALUES NOT REPLICATED IX87047 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN IX87076 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. IX87078 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. IX87079 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 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 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 IX87124 SUN: ALLOCATION OF LARGE BUFFERPOOLS USING SOLARIS 2.6 (>1.6G) MAY FAIL WHEN INTRA_PARALLEL IS ON. IX87156 SMP: HANG DURING SUBAGENT SYNCHRONIZATION OF INDEX ANDING. IX87172 POOR PERFORMANCE BECAUSE STAR JOIN NOT SELECTED IX87200 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN IX87201 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN IX87202 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN IX87205 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN IX87206 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN IX87280 ROLLFORWARD FAILS WITH SQL1271W WHILE REBALANCING IX87417 SQL2036 - INVALID PATH, IN UDB EEE ENVIRONMENT USING DB2 LOAD IX87422 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX87463 MULTIPLE LOGON WINDOWS WITH MSACCESS WHEN NO UID/PWD INPUT IX87540 INVALID ROW COUNT RETURNED ON UPDATE WITH STREAMS (LOB) IX87542 RECOVERY HISTORY FILE IS PRUNED EVEN WHEN REC_HIS_RETENTN PARAMETER IS SET TO -1. IX87595 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD IX87634 DB2 TRAPS WHEN EXIT HANDLER CALLED IF RESOURCES ALREADY FREED IX87653 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD IX87654 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD IX87665 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030 IX87667 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030 IX87668 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030 IX87670 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX87671 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX87720 CLI SQL_CONNECT_NODE WOULD NOT ACCEPT VALUE 0 IX87839 EXCEEDING MAX APPLID SIZE OF 32 BYTES. DEFECT NUMBER 103039 IX87911 DB2 UDB ERROR 28 IS INCORRECTLY RETURNED BY THE SAMPLE USEREXIT WHEN LOG FILE WE ARE TRYING TO ARCHIVE DOES NOT EXIST. IX87928 FIXES TO REPLICATION ADMIN TOOL, DJRA IX88313 HASH JOIN PLAN PRODUCES INCORRECT RESULTS JR12555 REMOTE DB BACKUP TO ADSM VIA NT CLIENT CONTORL CENTER WITH SESSIONS > 1 FAILS WITH SQL2032. JR12681 EVEN WHEN THE OPTIMIZE FOR N ROWS IS ON DB2 CONNECT WILL CONTINUE SENDING PRE-FETCH REQUESTS TO THE HOST. JR12721 IF THE IN PREDICATE OF THE WHERE CLAUSE IN A SELECT STATEMENT HAS MORE THAN 284 ITEMS, THE ENGINE TRAPS. JR12745 SQLBINDPARAMETER() DOES NOT HANDLE BEING PASSED A COLUMN SIZE OF ZERO PROPERLY AT FP 7 (WR09084). JR12748 SYMBOLS FOR GENERIC API LIBRARY NOT EXPORTED IN UDB VERSION 5/5.2. NT BUILD DOES NOT EVEN HAVE THE OBJECT FILES. JR12790 SCRIPT CENTER JOB HAVING START CMD FAILS SQL1131 & MEM ERROR JR12814 DB2LOOK FOR REFERENTIAL CONSTRAINTS JR12894 RANDOM TRAPS IN SQLRA_CACHE_DEL_VAR WHICH ARE MANIFEST AS EITHER INSTANCE HANGS OR CRASHES. DIAG FILE 0XA602. APAR fixes included in WR09083g (Fixpak 7g) APAR No. Abstract -------- -------------------------------------------------- IX86353 DB2: DO NOT LOG FETCHES IN AUDIT LOG AS CONTEXT EVENTS IX86368 SQLJMF10 TRAPS WHEN SENT A NULL POINTER IN DB2RA. IX86733 DB2SETUP : INSTANCE CREATE FAILS DURING TCPIP CONFIG IX87362 QUERY WITH 'IN' PREDICATE RETURNS WRONG RESULT IX87377 LINK FROM /USR/LPP/DB2_05_00/INSTANCE/DASILIST TO ~/BIN/DASILIST DISAPPEARS AFTER BACKING OFF FIXPACK7 IX87446 UDF NOT MAKING FINAL CALL WHEN IT TERMINATES ABNORMALLY IX87478 SQLUGRPI CALL RETURNS SQL6044N JR12414 IMPLEMENT VARIALBE TAPE BLOCK SIZE FOR THE DB2 BACKUP COMMAND ON THE INTEL PLATFORM. JR12804 SETXXXSTREAMS BROKEN IN THE 5.2 NET DRIVER JR12809 MEMORY LEAK IN DB2JD.EXE DEFECT 101809 JR12813 EXPORT WITH DATALINKS COLUMN FAILS WITH NO MESSAGES RETURNED JR12819 IMPORT OF EXPORTED CLIENT PROFILE IN CCA FAILS CCA3002N IF PATH CONTAINS LONG NAMES WITH BLANKS APAR fixes included in WR09083f (Fixpak 7f) APAR No. Abstract -------- -------------------------------------------------- IX85687 IMPROVE DPS SO THAT THE DB2 HANDLES SQLOQQUE FAILURE BETTER. IX86742 TURKISH CODEPAGE: USERIDS CONTAINING THE LETTER I ARE INCORRECT- LY TRANSLATED BY DB2 INTERNALLY RESULTING IN AUTH. FAILURE. IX86987 SLOW INSERT PERFORMANCE WITH NON-NUMERIC PARTITIONING KEY IX87048 INTERMITTENT SQL0290 DURING EXECUTION OR BIND IX87376 DB2PROFC TRAPS WHEN INVALID PREPAREOPTION SPECIFIED IX87387 SELECT W/ OPTIMIZE FOR N ROWS AND FOR FETCH ONLY GOING AGAINST MVS RESULTS IN AN ADDITIONAL FOR FETCH ONLY BEING ADDED. JR12722 CHANGING TARGET MEMORY TO 70% IN THE PERFORMANCE SMARTGUIDE, CAUSES DB2START TO RETURN SQL1022C-NOT ENOUGH MEMORY. JR12745 SQLBINDPARAMETER() DOES NOT HANDLE BEING PASSED A COLUMN SIZE OF ZERO PROPERLY AT FP 7 (WR09084). JR12788 TRAP ON CONNECTION TO DB2 / MVS WHEN CURRENTSQLID SET JR12797 NULL INDICATOR NOT BEING RESET IN JDBC APPLICATION USING THE 'NET' DRIVER. APAR fixes included in WR09083e (Fixpak 7e) APAR No. Abstract -------- -------------------------------------------------- IX83002 -1042 (SYSTEM ERROR) ON ROLLFORWARD IX86031 IN DB2/UDB - 'LIST HISTORY REORG SINCE' DOES NOT REPORT ALL VALID ENTRIES. IX86457 SIGUSR1 IS IGNORED IN SNA/6000 V3 AND LATER IX86991 EXPORT NOT PARSING MODIFIED BY DELIMITERS WHEN USING WITH PROPERLY IX87061 TRAP CAUSED WHEN USING THDSRVER.SQC SAMPLE DUE TO LATCHES JR12683 SQL0542 WHEN CREATING PRIMARY KEY, BUT COLUMN IS NOT NULL JR12689 REDUCE MSGS IN DB2DIAG.LOG CAUSED BY CONVERSION FILES JR12719 FILE_TRANSFER_CMD OPTION OF THE DB2 AUTOLOADER CONFIGURATION FILE DOES NOT CALL A BATCH FILE. IT DOES CALL AN .EXE FILE. JR12732 5.2:SQL0956 / SQL1478 AFTER ALTERING V5GA BUFFERPOOLS JR12734 CCA IMPORT ONLY PICKS UP ONE INSTANCE IF MULTIPLE DEFINED FOR A SYSTEM. JR12747 JOB RSULT IN CC JOURNAL FOR SRIPT CENTER JOB IS PARTIAL JR12753 TRAP IN SQLCCCLOSEENTRIES WHEN CALLED FROM SQLEFORCEAGENTS(). JR12780 IXF IMPORT OF V1 DATA FAILS IN V52 OS2 SYS3175 APAR fixes included in WR09083d (Fixpak 7d) APAR No. Abstract -------- -------------------------------------------------- IX83869 CATALOGING MORE THAN 8 ODBC DATASOURCES FROM SCRIPT GIVE ERROR IX85558 SQL_ATTR_RETRIEVE_ROW IS STILL RETRIEVING DATA EVEN IF OFF. IX86517 LOAD TRAPS IN BUILD PHASE WHEN UTIL HEAP RUNS OUT OF SPACE. IX86861 SETNULL CAUSES TRAP WITH TIMESTAMP,TIME,DATE,BIGINT AND STREAMS IX86901 JDBC EXECUTEQUERY() RETURNS NULL IX86940 DB2LOADREC DOES NOT WORK IF LOAD COPY MOVED IX86966 REMOVE CHECK IN PROBE 70 OF SQLPWRITELR JR12546 NT: RESTORE TRAPS WHEN THE FULL PATH TO THE BACKUP IMAGE IS SPECIFIED IN THE RESTORE COMMAND (CLP OR CC). JR12669 SLQSTATE -1106 LOGGED IN DB2DIAG.LOG WHEN PERFORMING IMPORT FROM A REMOTE MACHINE TO A WINDOWS SERVER. JR12745 SQLBINDPARAMETER() DOES NOT HANDLE BEING PASSED A COLUMN SIZE OF ZERO PROPERLY AT FP 7 (WR09084). APAR fixes included in WR21102c (Fixpak 7c) APAR No. Abstract -------- -------------------------------------------------- IX84079 UNFENCED STORED PROCEDURE CAUSING SQL0859N WHEN CALLED IN A DUOW (TYPE2 CONNECTS) IX85099 V5.2 NT/W98 CLIENTS TO GATEWAY TRAPING AFTER 3-4 CONNECTIONS IX85441 IF LIBPATH IS LONG, REMOTE CONNECT WITH TCPIP RETURNS SQL10013 IX85893 SQL0901 REASON 'SQLRINREC: FUTURE SHOCK' WHEN RUNNING AN SMP ENABLED QUERY. IX86244 USE SQLOINSTANCEPATH() TO LOWER NUMBER OF CALLS TO PASSWORD FILE IX86413 DB2 - UDB: SIGNAL 11 TRAPS AFTER HITTING AN ERROR IN SQLRXGET AND SQLRXPUT IN THE DIAG. JR12361 APAR USED TO CREATE PTF FOR DB2 WIN3.1 V520 JR12614 DB2LOOK -D DOES NOT WORK AGAINST REMOTE DATABASES JR12618 SYS3175 RETURNED FROM OS/2 WHEN RUNNING A USER EXIT TO BACKUP A DATABASE REPEATEDLY... JR12646 OS/2: SQL1038C ON DB2START WHEN USING A FAT FILESYSTEM. JR12715 ADD A NEW NOT NULL COLUMN FROM THE CONTROL CENTER, GOT SQL0193N IF THE DEFAULT IS EMPTY. JR12731 DDL FOR CREATE TABLE INCORRECT WHEN DBNAME IN DB2CLI.INI FILE APAR fixes included in WR21102b (Fixpak 7b) APAR No. Abstract -------- -------------------------------------------------- IX82027 IMPORT CAN HANG SYSTEM IF THE INPUT FILE ROW COUNT IS AN EXACT MULTIPLE OF THE COMMITCOUNT IX84082 CUSTOMER CAN'T RUN A JAVA STORED PROCEDURE MORE THAN ONCE WITH SOLARIS 2.6 AND JDK 1.1.6 WITHOUT RESTARTING UDB IX84935 DB2 UDB EEE DOES DISTRIBUTED CLOSE FOR SOME OPERATIONS IX84950 JDBC DRIVER OVERRIDES THE CLI SETTING FOR CURSORHOLD. IX85171 LOAD WITH DB2 UDB V5.2 ON HP-UX 11 SMP HAS POOR PERFORMANCE... IX85342 SIGNAL 11 IN SQLRA_FIND_SHIP_VAR (#11) IX85415 DB2 DOESN'T LINK IN THREAD SAFE CPIC LIBRARY FOR DB2DCPIC_IBM.A IX85645 EXECUTEUPDATE METHOD IN JDBC STILL RETURNS -1 IF NO ROWS WERE UPDATED. THE PROBLEM IS PRESENT ONLY IN JDBC NET DRIVER. JR12594 SQL3124W ON LOAD OF ASC FILE WITH PACKEDDECIMAL OPTION WHEN THE FILE HAS CORRECT STRUCTURE. JR12613 DB2 COMMON SERVER - CRASH RECOVERY FAILS WITH -2775 MESSAGES IN THE DB2DIAG.LOG FILE. JR12666 CONTROL CENTER GENERATED SQL FOR AS/400 AS FIELD FOR NUMERIC ZONE DECIMAL AS PAC DECIMAL INSTEAD.SOURCE DOES NOT MATCH TARGET JR12673 SQL0901N INDEX OUT OF RANGE, UDB PARSER PROBLEM APAR fixes included in WR21102a (Fixpak 7a) APAR No. Abstract -------- -------------------------------------------------- IX85192 SQLO902 RC 26 SQLO_NOMEM_UND IN SQLRIUIN (CRASHES DB) IX85286 LENGTH OF INTEGER TYPE IGNORED: SQLPARAM DOES NOT WORK PROPERLY WITH OTHER THEN CHAR DATA TYPES. IX85764 DB2 UDB 5.2 EEE: BAD PLAN WITH FOR BIT PARTITIONING KEY JR12355 LOADING BLOB COLUMN LARGER THAN THE TARGET GIVES SQL3408, BUT ERROR MESSAGE REFERS TO THE PREVIOUS COLUMN. APAR fixes included in WR21102 (Fixpak 7) APAR No. Abstract -------- -------------------------------------------------- GG03792 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG GG03794 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL GG03795 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL GG03796 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE GG03797 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE GG03798 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS, ANY PLATFORM GG03799 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (NT, UNIX ALSO) GG03800 ASN1053E THE EXECUTION OF THE ASNLOAD PROGRAM FAILED RC6 GG03801 ASN1056E APPLY PASSWORD FILE COULD NOT BE OPENED - ERROR CODE IS 215601 GG03802 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON GG03803 SQLCODE407 - ASSIGNMENT OF A NULL VALUE TO A NOT NULL COLUMN IS NOT ALLOWED OCCURS WHEN WILD CARD CHARACTER NOT USED IN BUILDDB GG03804 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY GG03805 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (NT) GG03806 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT GG03807 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 GG03808 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY GG03810 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 GG03811 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 GG03812 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG GG03813 PRUNING CONTROL ROWS GET DELETED IN V5 IF THE V1 SUBSCRIPTION HAS RUNMODE EI STATEMENTS THAT ARE OMITTED IN V1 TO V5 MIGRATION GG03814 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS GG03816 SQLCODE407 - ASSIGNMENT OF A NULL VALUE TO A NOT NULL COLUMN IS NOT ALLOWED OCCURS WHEN WILD CARD CHARACTER NOT USED IN BUILDDB GG03817 ASN2748E ASNMIG PREPARE ENDS UNSUCCESSFULLY GG03819 SQLCODE407 WHEN MIGRATING CAPTURE FROM V1 TO V5 AND ABOVE GG03820 PRUNING CONTROL ROWS GET DELETED IN V5 IF THE V1 SUBSCRIPTION HAS RUNMODE EI STATEMENTS THAT ARE OMITTED IN V1 TO V5 MIGRATION GG03821 ASN2769E SQLCODE518 - DPROPR MIGRATE PROGRAM FAILS WITH SQLCODE518 WHEN MIGRATING PRUNING CONTROL TABLE GG03822 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS GG03825 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT GG03826 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT GG03829 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 GG03830 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON GG03831 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED GG03832 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED GG03833 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE LOCK CS TABLE IF APPLY FOR DB2/MVS 3.1 RUNNING GG03834 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE GG03835 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP GG03836 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP GG03837 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT GG03838 APPLY DID AN UNEXPECTED FULLREFRESH GG03839 APPLY DID AN UNEXPECTED FULLREFRESH IX76365 SLOW PERFORMANCE IX79991 CLI CHANGE: REPLACING LITERAL WITH PARAMETER MARKER IN INSERT IX80640 DB2LOOK DDL TRIES TO CREATE THE INDEX AFTER THE PRIMARY KEY CONSTRAINT WHEN KEY WAS DEFINED ON A PRE-EXISTING INDEX IX81525 SQLALLOCSTMT FAILS MEMORY CLEANUP IF OUT OF MEMORY IX81831 INDEX BUILD PHASE HUNG ON LOAD IX81849 SQLESETC API USES WRONG CONTEXT IN MULTITHREADED CLI APPS IX82054 NEW AUTOLOADER DB2ATLD ISSUES SQL3326 IF A LIST OF COLUMN NAMES ARE SPECIFIED AND ONE OF MORE NAMES ARE 18 CHARACTERS IX82394 SQL6107 WHEN TRYING TO LOAD PRE-SPLIT DATA. IX82397 DB2BATCH -O R 0 DOES NOT IF BLOB DATA IS SELECTED IX82487 OFFLINE BACKUP RETURNS SQL1042C OR SQL1084C IX82508 PATCH2=6 DOES NOT PREVENT A SCROLLABLE CURSOR TYPE IX82548 COLD START ENHANCEMENTS FOR SQLCODE964 IX82599 DB2 UDB RACE CONDITION IN DB2LICD. LEADS TO REMOVAL OF IPC Q 0 (USUALLY!). UNLIKELY ON NON-MLNS, POSSIBLE ON MLNS. IX82922 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL IX82923 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL IX82924 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL IX82942 NODENUMBER IN THE ON CLAUSE OF A JOIN QUERY CAUSES A -901 IX82970 SIG #11 IN SQLRIDESCRIBEINPUT LOADING BNI_PTR ON AN ATTEMPT TO REUSE A SECTION IN THE SQL WORK AREA. IX82992 CALLS SQLCOLUMNS() ON VIEWS RETURNS 0 COLUMNS ON ANY VIEW THAT ENCOUNTERS SQL0437. IX83002 -1042 (SYSTEM ERROR) ON ROLLFORWARD IX83038 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE IX83039 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE IX83040 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE IX83041 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS, ANY PLATFORM IX83042 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS, ANY PLATFORM IX83043 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS, ANY PLATFORM IX83063 JDBC NEGATIVEARRAYSIZEEXCEPTION() ON EXECUTEQUERY() IF UPDATE MAKES NO CHANGES. IX83068 DB2AUTOLD LOOPS WITH JA_JP ENV IX83180 WHEN RUNNING THE OUTPUT OF DB2UIDDL, AN SQL0956C IS RETURNED INDICATING DBHEAP IS EXHAUSTED. IX83197 DB2ATLD MAY USE HOSTNAME FOR SOME COMMUNICATIONS, SHOULD ONLY US E DB2NODES.CFG ENTRIES IX83238 MTS APPLICATION GETS ACCESS VIOLATION. IX83261 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (AIX) IX83272 NEGATIVE RETURN CODE -502 CAUSES TRAP IN SQLJIFSR.C IX83355 LIST APPLICATIONS DOES NOT SHOW PROGRAM NAME PROPERLY. IX83441 THE DB2DIAG.LOG SHOWS A NO TEMP AVAILABLE ERROR MESSAGE AND A TABLESPACE STATE TRANSITION ERROR 'FFFF8138' IX83458 PREP RETURNS SQL4920N WHEN EXEC SQL PROCEDURE HAS 50,60,70.. PARAMETERS. IX83539 -902 ON CREATE/DROP TABLE WHEN OUT OF DBHEAP IX83547 DYNAMIC DROP TABLE WAITS ON A INSERT THAT HOLDS AN NS LOCK IN SYSUSERAUTH IX83555 XA_END(TMSUSPEND) RETURNS XA_ERPROTO. IX83583 LOAD INSERT AFTER MIGRATION CAUSES TABLE CORRUPTION IX83594 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (HP10) IX83595 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (SUN) IX83616 QUERY REWRITE PROBLEM USING VIEWS IX83660 SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS IX83716 TRAP IN SQLRAGSN. CLIENT INTERRUPTED WHILE BINDING TO THE DB TRAPS THE SERVER. IX83732 ROLLFORWARD TO A POINT IN TIME GETS -1042 IX83733 DB21080 REDIRECTED RESTORE IS CASE SENSITIVE RE: DB ALIAS IX83781 SQL0344 RECEIVED WHEN DOING A SELECT AGAINST A VIEW WHICH HAS A BASE TABLE CONTAINING DATE/TIMESTAMP COLUMNS IX83847 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY IX83848 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY IX83849 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY IX83850 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 IX83851 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 IX83852 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 IX83953 DB2JD SHOULD NOT READ LENGTH INDICATOR FOR OUTPUT ONLY PARAMETER IX83968 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG IX83969 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG IX83970 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG IX84081 TRAP IN SQE IX84120 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT IX84179 DB2 UDB EEE: OPTIMIZER FILTER FACTOR IS INCORRECT IX84273 THE 'DB2BATCH' PERFORMANCE TOOL SHOULD TRIM THE TRAILING BLANKS FROM THE LAST COLUMN IN THE OUTPUT. IX84329 LENGTH OF OUTPUT SQLVAR IS NOT INITIALIZED IX84478 TIMESTAMP RECIEVED AS STRING SHOULD RETURN AS LENGTH 26 IX84503 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS IX84504 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS IX84505 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS IX84552 WE WERE CHOOSING A MGJN PLAN OVER A NLJN THAT WE USED TO CHOOSE IN V500. MGJN PLAN RUNS IN 300 SECONDS AS OPPOSED TO 3 SECONDS. IX84562 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT IX84563 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT IX84565 SQL0437W WARNING MESSAGE CAUSES EXPORT OPERATIONS TO FAIL. IX84577 CLI0125E ON SQLSETCONNECTATTR, AFTER PREPARE,BIND,EXECUTE,GETCH, ETDATA,SQLENDTRAN(ROLLBACK). EVERYTHING WORKS WITH EXECDIRECT. IX84582 CLP LIST TABLESPACES SHOW DETAIL DOES NOT AUTO-COMMIT. IX84760 BUF INSERT IS DISABLED WHEN NULL VALUES ARE INVOLVED FOR 5.2 IX84780 DB2_ALL HANGS WHEN INPUT REQUIRED IX84790 SQL10003C ERROR WITH DB2/UDB FOR AIX DUE TO MEMORY LEAK. IX84795 SQL901N WHEN RUNNING A QUERY THAT WORKED ON DB2 V2.X AND NOWS FA ILS ON DB2 UDB V5.2. UDB IS ATTEMPTING TO MERGE A UNION... IX84867 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 IX84868 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 IX84870 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 IX84871 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON IX84872 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON IX84873 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON IX84896 LOG ERROR WHEN DOWNLEVEL JDBC CLIENT COMING TO JDBC SERVER IX84898 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED IX84899 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED IX84900 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED IX84907 MISLEADING ERROR MSG -3514 IN DB2DIAG.LOG DURING LOAD EMPTY FILE IX84964 LOAD FAILS VIA CONTROL CENTRE ON ITALIAN UDB IX85142 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE IX85143 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE IX85144 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE IX85196 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP IX85199 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP IX85200 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP IX85243 DB2ATLD -D OPTION NOT DISABLED IX85266 S LOCKS OBTAINED ON SYSTABLES DURING IMPORT/LOAD CAN CAUSE DEADL OCKS IX85508 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT IX85509 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT IX85510 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT IX85653 APPLY DID AN UNEXPECTED FULLREFRESH IX85654 APPLY DID AN UNEXPECTED FULLREFRESH IX85655 APPLY DID AN UNEXPECTED FULLREFRESH JR12258 MS ACCESS USES TYPE TIMESTAMP FOR TYPE DATE FIELDS. JR12267 INSTALL ADDS DEFALT_LOCAL_LU_ALIAS TO THE CS NDF FILE. JR12333 TRAP IN DOWN LEVEL CLIENT. JR12353 RESTORE FROM BACKUP ON DISKETTES FAILS JR12356 NT: 192 MB FILE CACHE LIMIT HIT WHEN DB2NTNOCACHE SET TO 1. 'FFFFB5AA' MSGS IN DB2DIAG.LOG, TBSPCS PUT INTO RF PENDING. JR12376 TRAP WHEN A VERY LARGE IN CLAUSE (2000 ENTRIES) IS USED IN A QUERY ON NT. JR12400 SQLGETDATA SHOULD SUPPORT DIFFERENT DATA TYPES, IF THE FIRST ONE IS USED TO GET SIZE OF THE DATA AND THE SECOND ONE IS USED TO R JR12409 SQL_C_NUMERIC BINDING FROM VISUAL BASIC SUPPORT TO BE ADDED. JR12410 DB2 UDB V5.00 TRAPS WHEN SYNTAX OF A QUERY WITH ORDER BY IS INCORRECT ON WINNT. JR12419 ADO: OFFSET PTR CAUSES TRAPS AND UNEXPECTED SQL_NEED_DATA RC JR12424 NULL INDICATOR NOT BEING RESET JR12444 SQL0104 FOR OUTER JOIN FROM MS ACCESS TO MVS JR12452 MEMORY LEAK WHEN USING CLI APPLICATION TO HOST FROM DB2 CONNECT JR12467 UNINSTALL DOES NOT REMOVE *.OUT FILES FROM DAS INSTANCE DIRECTORY. JR12473 SQL901N WHEN SELECT * FROM RU99.CRSUBADDLMEASURE WHERE USERGUID= '2' ORDER BY SORTORDER JR12498 SQLEXECUTE DOES NOT INSERT ALL COLUMNS PROPERLY JR12505 TABLESPACE LISTING INCORRECT DURING TABLE COPY VIA CONTROL CENTER JR12508 SQL1026N FOLLOWED BY SQL1032N WHEN ISSUING MANY DB2STARTS JR12509 CLI0113E WHEN STORED PROCEDURE RETURNS DATE NOT IN ISO FORMAT TO A CLI APPLICATION. JR12512 MEMORY ACCESS VIOLATION OR TRAP WITH MULTIPLE ENV. HANDLES JR12538 FOR BIT DATA WITH VARCHAR DOES NOT RETURN CHARACTERS. JR12541 LOCKING PROTOCOL CHANGES - REVERT TO WAITING FOR DELETES DURING INDEX SCANS JR12563 FFFF877E IN DB2DIAG.LOG AND -901 IN DB2 TRACE ON INSERT/UPDATE/D ELETE JR12569 SMART GUIDE ON NT DOES NOT WORK FOR MORE THAN 4 GB MEM ON SOLARI S JR12572 -902 ERROR FROM FUNCTION SQLM_DCS_APP_EXIT JR12582 DB2 TRAPS (NT TRAPS IN DB2SQN.DLL) WHEN THERE IS A 'TYPO' AFTER A GROUP BY CLAUSE... JR12592 SPM0438 THE DB2 SYNCPOINT MANAGER RECOVER LOG IS BAD. JR12595 ALWAYS RETURN CATALOG SEPARATOR TO BE '.' INSTEAD OF HAVING TO USE PATCH2=11 JR12625 OPTIMIZER ENHANCEMENT FOR RECOSTING NESTED LOOP JOIN VS. MERGE SCAN JOIN. JR12633 IN CAE VER 5. RGBINFOVALUE='Y' FOR SQL_OUTER_JOINS WHERE AS IN C AE VER 2.1 IT IS 'N'.CUST. IS HAVING PROB. DUE TO THE ABOVE VAL. JR12634 SENDING DYNAMIC CALL PROCEDURE STATEMENT TO AS/400 INSTEAD OF STATIC ONE FROM CLI. JR12649 CLP SNAPSHOT FOR LOCKS OCCASIONALLY RETURNS INCORRECT RESULTS. APAR fixes included in WR09073 (Fixpak 6) APAR No. Abstract -------- -------------------------------------------------- GG00888 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS GG00944 THE FIRST POSITIONAL PARAMETER OF THE ANSAPPLY COMMAND ( OF DB2 UDB DPROPR ) IS CASE SENSITIVE IN THE WINDOWS/NT ENVIRONMENT. GG00969 MIGRATION TOOL CANNOT RUN ON WINDOWS 95 & 98 ASNMIG FAILS DURING MIGRATION OF MVS DPROPR FROM V1 TO V5 GG03680 APPLY HANGS AND GENERATES C00005 EXCEPTION GG03681 UPDATE TO CCD NOT REPLICATING CORRECTLY GG03685 APPLY V5 IS NO LONGER HOLDING THE CRITSEC LOCK WHILE IT FETCHES THE CD ROWS - IT COMMITS AFTER IT GETS THE SEQUENCE NUMBERS GG03686 OF 26 SOURCE TABLES AND REPLICAS FOR UPDATE-ANYWHERE ONLY FIRST 20 TABLES ARE PROPAGATED - SQLCODE2038 MAY OR MAY NOT BE SEEN GG03687 ASN1051E 4A5102 THE ONLY WAY TO EXIT FROM A GAP SITUATION WHEN USING INTERNAL CCD IS TO MANUALLY UPDATE DPROPR CONTROL TABLES GG03690 APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITHOUT CONTROL SERVER GG03691 APPLY FAIL WITH ERRCODE 8C0101 SQLCODE104 SQLSTATE 42601 GG03692 WHEN A LARGE OBJECT OCCURS IN THE BASE TABLE AND IS NOT REGISTERED , CAPTURE FAILS WITH PROTECTION FAULT GG03693 APPLY CONSUMES TOO MUCH SYSTEM RESOURCES WHEN SLEEP_MINUTES IS 0 GG03694 CPU RESOURCE UTILIZATION IS TOO HIGH FOR OS/2 PLATFORM GG03695 CPU RESOURCE UTILIZATION IS TOO HIGH FOR NT PLATFORM GG03696 APPLY LOOPS WHEN LASTSUCCESS IS GREATER THAN 1 MONTH OLD FROM CU RRENT DATE GG03697 INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED GG03698 INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED GG03699 SQLCODE206 WHEN COPYING TO CCD GG03700 MAX_SYNCH_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 I GG03703 LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED GG03704 ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED B GG03707 SQLCODE206 WHEN COPYING TO CCD GG03708 LONG VARCHAR SUPPORT GG03709 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION GG03710 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION GG03711 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY GG03712 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY GG03713 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING GG03714 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING GG03715 APPLY MAY COPY UNCOMMITED DATA GG03716 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 GG03719 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED GG03720 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD GG03721 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 GG03725 CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION GG03726 CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION GG03729 CAPTURE/OS2 JAPANESE ALWAYS STOPS WITH CHAR COLUMNS GG03731 SQLCODE803 DURING FULLREFREH GG03732 SQLCODE803 DURING FULLREFREH GG03734 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE GG03735 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE 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 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 GG03739 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED GG03740 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED GG03741 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION GG03742 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION GG03743 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED GG03744 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED GG03745 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. GG03746 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE GG03747 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER GG03748 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER GG03750 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) GG03751 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) GG03753 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY GG03754 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY GG03755 ASN2769E SQLCODE518 - DPROPR MIGRATE PROGRAM FAILS WITH SQLCODE518 WHEN MIGRATING PRUNING CONTROL TABLE GG03756 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLYTRAIL TABLE GG03757 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLYTRAIL TABLE GG03758 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 GG03759 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 GG03760 MOBILE REPLICATION BETWEEN UDB PERSONAL WINDOWS 95 AND UDB ENTERPRISE EDITION AIX - CONTROL TABLES ARE ON AIX MACHINE GG03761 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 GG03762 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES GG03763 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES GG03764 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 GG03766 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 GG03767 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 GG03768 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS GG03769 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS GG03772 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 GG03773 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 GG03774 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS GG03775 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS GG03776 SQLCODE407 WHEN MIGRATING CAPTURE FROM V1 TO V5 AND ABOVE GG03777 CD_OLD_SYNCPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD GG03778 CD_OLD_SYNCHPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD GG03779 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS GG03780 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS GG03781 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER GG03782 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER GG03783 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS GG03784 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. GG03785 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. GG03786 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS GG03787 ASN2748E ASNMIG PREPARE ENDS UNSUCCESSFULLY GG03790 COLD START ENHANCEMENTS FOR SQLCODE964 GG03791 COLD START ENHANCEMENTS FOR SQLCODE964 IC19729 ASNSERV.EXE WAS NOT SHIPPED WITH DATAJOINER FOR NT V210. IX61374 CICS/6000 TERMINATES AFTER BAD XACLOSE USING DDCS/6000 IX67258 DB2 THINKS APPLICATION IS MULTI THREADED IX68617 RESTORING DB2/6000 V2.1 DATABASE (WITH RAW DEVICE CONTAINERS) TO NEW AND GETTING DB2DIAG.LOG ERRORS WITH THE CONTAINERS. 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 IX71266 SQL10013 - ON SIXTH INVOCATION OF STORED PROCEDURE IX71439 LOOPING FENCED UDF NOT CLEANED UP IX71837 USING FOR BIT DATA AND NORMAL CHAR TYPES IN A MERGE JOIN LEADS TO INCORRECT OUTPUT. IX71898 INCORRECT OUTPUT FOR FUNCTION LOG10 IX71996 LOAD INTO A TABLE ALIAS FAILS WHEN RETRIEVING COLUMN DEFAULTS IX72350 TRIGGERS IN A SUBQUERY PREVENT OPTIMIZER FROM REWRITING SUBQUERY AS A JOIN. IX72355 A TRAP WITHIN A STORED PROCDURE IN SQLE_MRSP. DB2SYSC CORE DUMP IX72365 IMPORT .. OF DEL MODIFIED BY CHARDEL '' RETURNS SQL3017 FOR UDB, REGRESSED FROM V2 IX72390 DB2 UDB - WITH THE EVENT MONITOR ON MEMORY OVERWRITE OCCURS WITH SQL STATEMENTS > 4K. IX72404 SQLOPENBPF PROBE 920 DURING BACKUP IX72451 RESTORING V2 BACKUP IN V5 PLACES MESSAGE IN DIAG FILE THAT TABLSPC 0 BUFF POOL 0 DOES NOT EXIST MAPS TO BUFFPOOL 1. IX72460 DB2ADUTL DOES NOT USE THE ADSM PASSWORD SET WITH DSMAPIPW IX72507 VARCHAR FIELD IS PADDED WITH @ SIGNS WHEN USING JDK 1.13 WITH NA TIVE THREADS CONNECTION TO MVS IX72517 AN ALTER ADDED TIMESTAMP CAUSES SQLCODE180 IX72697 PROGNAME VARIABLE CAUSES LINKER MESSAGES IX72725 CORE DUMP RUNNING APPLY/HP AND ABEND IN APPLY/MVS IX72787 WHEN NO DEACTIVATE COMMAND ISSUED BEFORE DB2STOP ON AN ACTIVATED DATABASE CAN LEAVE PAGE CLEANERS AND PREFETCHERS ORPHANED. IX73014 SQLCANCEL IN JDBC DOES NOT WORK AS IT IS SERIALIZED. IX73136 A PASSWORD DEFINED WITHIN NIS+ WITHIN SOLARIS CANNOT BE AUTHENTI CATED BY DB2 IX73165 CUSTOMER WOULD LIKE A MORE INTUITIVE MESSAGE RETURNED WHEN ROLLI NG FORWARD THROUGH LOGS AND A LOG FILE IS MISSING. IX73168 DB2 V5 EEE GA CODE. POINT IN TIME TABLESPACE RECOVERY PROBLEMS. IX73231 QUERY WAS GETTING VERY BAD PERFORMACE IN A QUERY WHEN RUNSTATS FOR A TABLE WAS RUN WITH DISTRIBUTION. IX73248 WHEN DISABLEMULTITHREAD IS SET TO 0 IN THE DB2CLI.INI FILE THERE EXISTS A MEMORY LEAK IN THE SQO LAYER WHEN USING CLI IX73249 OUTBOUND APPLICATION ID PROVIDED BY DB2 LIST DCS APPLICATIONS SHOW DETAIL IS IN INCORRECT FORMAT 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. IX73443 LOAD LOGIC SHOULD BETTER HANDLE RCF FLAG VALUES IX73445 ONLY LOG SEVERE ERRORS IN SQLDLOADTCBOBJDESC IX73521 DB2 UDB: DB2START RESULTS IN SQL1092N WHEN INSTANCE OWNER ID ON AIX HAS LOGIN=FALSE OR RLOGIN=FALSE IX73537 DB2 V5 EEE: ENABLE AUTOLOADER > 2 GIG FILE SUPPORT IX73543 INDEX CORRUPTION AFTER V2 DB MIGRATED TO UDB AND ALTERING VARCHAR COLUMN LENGTH IX73564 INVALID USE OF PTHREAD_CLEANUP_PUSH() AS THREAD EXIT HANDLER. IX73675 DB2AUTOLD DOES NOT HANDLE COLUMNS STARTING WITH 'MODE' CORRECTLY IX73768 V5 EEE VERSION OF DB2LN DOES NOT SUPPORT DB2 PE V1.2 IX73875 SELECT CAUSES THE UDB INSTANCE TO GO DOWN IX73986 DB2 AGENT LOOPS ON A SNA RECEIVE WAIT AFTER HOST RETURNS 'AGENT PERMINANT ERROR REPLY MESSAGE'. 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 IX74116 LOAD W/ HIGH DISK_P CORRUPTS LF DATA IX74229 REMOVING TRAILING PERIOD FROM DECIMAL TO CHAR. IX74232 CANNOT MIGRATE INSTANCE TO V5 IF REMOTE DATABASES CATALOGED IX74453 CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS IX74491 ADD PATCH FOR NETSCAPE LIVEWIRE TO IGNORE THE PROCSCHEMA ARGUMENT IX74523 SQR NOT MAPPING INTERNAL ERROR TO CLP CORRECTLY IX74524 LIST APPL. CMD FAILED AFTER TWO SUCCESSFUL CONCURRENT LOADING IX74529 APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITH IX74540 CUST CAN'T RUN SCRIPT STORED ON SERVER FROM SCTRIPT CENTER USING RUN NOW ... OPTION. IX74582 INCORRECT OUTPUT IN LIST RECOVERY HISTORY FOR 'Q' OPERATION IX74848 DB2STOP DOES NOT STOP ON LARGE NUMBER OF NODES - TIMES OUT IX74871 IN LOCK WAITS FOR X LOCK 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 IX74915 ON AN SMP SOLARIS DB2 UDB, CONCURRENT LOADS RESULTS SQL1224. IX74918 PERMISSION DENIED ON HA TAKEOVER ON THE PARTITION TAKING OVER IX74969 DB TAPE RESTORE VIA CONTROL CENTER FAILS WITH SQL2042W I/O ERROR 2060 IX74997 LOG FILES NOT ARCHIVE AFTER CRASH RECOVERY. IX75047 DB2LOOK FAILS WITH SQL0811 IX75101 FAILURE IN SQLDIOSR - NO ROOM IN SPECIFIED PAGE FOR OBJECT ID IX75150 CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS IX75151 CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS IX75217 CLI PROBLEM WITH HY009 / S1009 IX75242 ROLLFORWARD TO PIT OF A TABLESPCE RECIEVED A -1042 SQLCODE IX75332 INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED IX75443 OPTIMIZER ERRONEOUSLY FAVOURS LIST PREFETCH OVER TABLE SCAN WHEN SCANNING SMS TABLES WITH LESS THAN 32 PAGES. IX75463 INCORRECT NODE NUMBER IN BACKUP NAME IN ADSM IX75587 PERFORMANCE DEGRADES GOING FROM COMM_BANDWIDTH 1 TO 100 IX75609 LIST APPLICATIONS CORRUPTS APP ID FOR LONG APP NAMES IX75630 RECEIVE SQL0502 WHEN GOING TO A V2 DATAJOINER BECAUSE OF CHAINED AUTOCOMMIT IX75640 CREATE NODEGROUP RECEIVES -901 FROM SQLRKANG_CBP_I - FFFFFA604 IX75642 DB2 RESTART FAILS AFTER HITTING EOF ON BUFFER POOL FILE(S) - FFF FF609 IX75687 UNABLE TO RESTORE FROM A BACKUP TO ADSM USING MULTIPLE OPEN SESSIONS. IX75688 DB2 SHOULD USE 'LSATTR' COMMAND TO DETERMINE MEMORY IN AIX IX75695 JDBC APPLICATION DRIVER SHOULD NOT FREE THE ENVIRONMENT IF IT IS GARBAGE COLLECTED IX75909 DB2 BRINGS DOWN INSTANCE AFTER A DYNAMIC SQL DOES NOT CLEAN UP P ACKAGES IX75933 OF 26 SOURCE TABLES AND REPLICAS FOR UPDATE-ANYWHERE ONLY FIRST 20 TABLES ARE PROPAGATED - SQLCODE2038 MAY OR MAY NOT BE SEEN IX75945 IGNORE SQL0000W GENERATED BY POWER BUILDER APPLICATION AFTER CLI0165E ERROR 'ERROR IN ROW' IS DISPLAYED BY APPLICATION. IX75975 INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED IX75976 INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED IX76127 DB2 RESTART DATABASE FAILS WITH SQL1042 DUE TO -4015 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) IX76273 DB2 UDB - LOAD HANGS WHEN DMS TABLESPACE FILLS UP IX76365 SLOW PERFORMANCE IX76438 ALTER TABLE RESULTS IN SQL902,126 ON DB2 UDB IX76443 PERFORMANCE PROBLEM OF A SELECT WITH AN ORDER BY IX76624 DB2/EEE V500 ON AIX. SIGNAL #11 IN BUFFER POOL SERVICES. IX76678 SQL1042 ON GET SNAPSHOT FOR APPLICATIONS ON SOLARIS 2.6 IX76680 SQL10012 WHEN USING STORED PROCEDURES WITH JAVA ON SUN SOLARIS IX76735 MAX_SYNC_MINUTES VALUES OF ZERO OR LESS MEANS NULL IX76914 CHANGING DATASOURCE MANUALLY IN 'CONNECTING TO DB2' WINDOW TRAPS IX76922 KEYWORD DATALINK IX76924 STAR JOIN DISQUALIFIED FOR STAR JOIN ELIGIBLE QUERY IX77067 SUN BACKING OFF FIXPAK #3 AND USING DB2IUPDT CAUSES FATAL ERROR DUE TO INCOMPATIBLE LEVELS OF CODE IX77088 DB2 LOAD TO SAME TABLESPACE IN PARALLEL GIVES -911 IX77129 LONG VARCHAR SUPPORT IX77137 RUNSTATS WITH DISTRIBUTION PICK INCORRECT PLAN IX77154 OUTER JOIN IN LIST PREDICATE OPTIMIZER PROBLEM IX77312 DB2AGNTP PROCESS HOLDING /ETC/GROUPS FILE OPEN IX77398 CANNOT BACKUP TO MVS TAPES VIA CLIO/S BECAUSE UDB WILL NOT ALLOW A BACKBUFSZ OF 8 IX77399 CRASH RECOVERY ENDS TOO EARLY. IX77400 SQL.H MISSING SQL_QUERYOPT CONSTANTS FOR 2 AND 7 IX77409 NIS CHECK FAILS DURING INSTALL OF ADMIN SERVER IX77439 SQL30081N ON SECOND CONNECT THROUGH SYSPLEX SERVER IX77480 DIAGNOSTIC CODE FOR NLI SITUATIONS AND BPS PROBLEMS IX77494 DB2 UDB LOAD COMMAND USING 'MODIFIED BY DUMPFILE' AND CPU PARALLISM > 1 RESULTS IN AN INCOMPLETE DUMPFILE. IX77553 BACKUP/RESTORE API ERRORS IX77572 RECYCLING SCRIPT CENTRE CREATES ERROR MESSAGE -> 'DBA2078E AN UNEXPECTED ERROR OCCURRED. THERE IS NO JOB OUTPUT.' IX77672 INDEX CORRUPTION AFTER MIGRATING TO V5 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. IX77770 SQL1704N RC=8 ON DATABASE MIGRATION OF DB2 V2 TO V5 ON HP-UX IX77776 ON INDEX REBUILD SQL0404 DUE TO INCORRECT INDEX PACKED DESCRIPTOR UPDATE AFTER ALTER COLUMN IX77873 V5 FIX FOR V2 APAR IX76471. PERFORMANCE ENHANCEMENT FOR INSERT/ UPDATE BY IMPROVING FREE SPACE CONTROL MAP SCANS. IX77970 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION IX77971 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION IX77972 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION IX77973 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY IX77974 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY IX77975 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY IX77976 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING IX77977 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING IX77978 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING IX77979 APPLY MAY COPY UNCOMMITED DATA IX77980 APPLY MAY COPY UNCOMMITED DATA IX77981 APPLY MAY COPY UNCOMMITED DATA IX78109 LOAD HANGS ON SMP MACHINE WHEN SINGLE ' ENCOUNTERED AND ' IS THE STRING DELIMITER IX78127 (APPLY FOR AIX)LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT IX78128 (APPLY FOR HP) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT IX78130 (APPLY FOR SUN) 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 IX78164 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED IX78165 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED IX78166 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD IX78167 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD IX78168 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 IX78170 (APPLY FOR HP) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS IX78171 (APPLY FOR SUN) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS IX78176 DB2LOOK DOES NOT EXTRACT TABLESPACE INFORMATION FOR TABLESPACES WHICH HAVE NO TABLES DEFINED WITHIN THEM IX78183 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET IX78184 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET IX78185 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET IX78186 MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL IX78187 MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL IX78232 SQLBRESERVEFILETOKEN IN DB2DIAG.LOG FID TIMING PROBLEM IX78244 REORG OF COMPACT BLOB EXPANDS OBJECT TO NON-COMPACT SIZE IX78265 CREATE INSTANCE VIA DB2SETUP HANGS ON HP-UX WHEN RUN FROM THE INSTALL DIRECTORY IX78334 CREATING TRIGGER WITH SYNTAX ERROR INTERNALL RETURNS SQL0104 BUT BRINGS DOWN THE CONNECTION RETURNING SQL1024 IX78344 UPDATE CONNECTION SMARTGUIDE WILL NOT ALLOW '.' FOR TCPIP HOST IX78408 CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX78409 CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX78410 CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX78463 CAPTURE/AIX JAPANESE ALWAYS STOPS WITH CHAR COLUMNS IX78464 CAPTURE/HP JAPANESE ALWAYS STOPS WITH CHAR COLUMNS IX78465 CAPTURE/SUN JAPANESE ALWAYS STOPS WITH CHAR COLUMNS IX78479 WHEN A SEMAPHORE SET USED BY DB2 UDB IS MISSING, DB2 WAS BROUGHT DOWN. DB2 DOES NOT NEED TO BE BROUGHT DOWN IN THIS CASE. IX78481 DB2 UDB ON OS/2 - THE DB2LICD PROCESS DOES NOT START WHEN A CONNECTION IS MADE TO THE HOST FROM THE GATEWAY. IX78499 INCORRECT OUTPUT IN GET DATABASE SNAPSHOT FOR MAX AGENTS FIELD IX78509 -973 WHEN DOING AN IMPORT FROM A COORDINATING NODE TO A REMOTE DATA NODE. MEMORY LEAK IN SQLRKAIN. RUNNING OUT OF APPLHEAP IX78555 IFOR_LS.CLIENT.BASE FIXPAK PREREQUISIT FAILS ON AIX 4.3 IX78558 APPLY FAILED WITH SQLCODE803 DURING FULLREFREH IX78559 APPLY FAILED WITH SQLCODE803 DURING FULLREFREH IX78560 APPLY FAILED WITH SQLCODE803 DURING FULLREFREH IX78566 CATALOG CACHE MONITOR VARIABLES ARE NOT RETURNED IN AN APPLICATION SNAPSHOT (THEY ARE IN A DATABASE SNAPSHOT) IX78628 DBI1069 -- SYSTEM ERROR ON HP-UX 10.20 UDBWITH ATTEMPTED INSTANCE CREATION VIA DB2ICRT OR DB2SETUP IX78630 SQLNUMRESULTCOLS() RETURNS -301 IX78710 EXPORT OF 167 MILLON ROWS RETURN SQL2003 IX78760 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE IX78761 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE IX78762 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE IX78820 SQLFETCH AFTER SQLFOREIGNKEYS FAILS IX78836 'ALTER TABLE table_name ADD COLUMN TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP' FAILS WITH SQL0193N IX78867 FORCE EXPIRED PASSWORDS STILL WORK ON NON-AIX UNIX IX78903 ARRAY INPUT FOR BLOB COLUMN INSERTS WRONG DATA IX78958 INVALID CONTAINER NAMES IN SET TABLESPACE CONTAINERS FOLLOWED BY ABORTED TABLESPACE RESTORE PREVENTS A SUBSEQUENT TBSP RESTORE. IX78963 INCORRECT OUTPUT FROM QUERY USING INDEX-BITMAP-ANDING IX78975 LOAD WITH STATISTICS YES AND LOCKTIMEOUT CAN GIVE -911 RC=68 IX78981 PROBLEM W SQLJGEN.C PROCESSING ACCRDBRM. THE AUTHID IN THE ACB C OPY OF THE AUTHINFO - NOT FILLED IN INTRMEDIARY IN 2- HOP SCENAR. IX79090 SIGNAL HANDLER NEEDED IN DB2JD IX79213 MR UNABLE TO CATCH ERROR MSG CAUASING INTERMITTANT HANG IX79235 DB2/AIX TRAP IN LOAD WHEN SYSTEM ACTIVITY IS HIGH. SIGNAL 11 IN SQLULUMW. IX79247 CANNOT RESTORE NEW DATABASE FROM BACKUP WITH DIFFERENT NAME IX79292 SIGNAL #11 IN DB2LRID WHEN LOAD IS TERMINATING IX79301 DB2 UDB EEE HANG C980331 IX79318 NON-SYSADM IDS LOG ENTRIES TO DIAG FILE AT DIAGLEVEL 3 OR 4 ON ATTEMPTED CONNECT TO DB. THESE IDS TRY TO OPEN DB2AUDIT.CFG. IX79456 FORCE APPLICATION BRINGS DOWN DB2 WHEN DOING INSERTS WITH INSER T BUFF ON AT THE SAME TIME IN AN APP. ( BUFFERED INSERTS ) IX79557 SQL3508 RC 1 USING SQLULOAD API IN AN APPLICATION COMPILED ON V2 OF DB2 RUNNING AGAINST A DATABASE ON V5 UDB. 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 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 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 IX79598 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED IX79599 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED IX79600 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED IX79601 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION IX79602 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION IX79603 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION IX79604 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED IX79605 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED IX79606 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED IX79607 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. IX79608 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. IX79609 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. IX79616 ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION IX79623 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER IX79624 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER IX79625 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER IX79627 ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION. IX79628 ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION IX79865 CLI0602E MEMORY ALLOCATION ERROR IN JDBC NET DRIVER WITH CLOBS IX79866 DIA1036C XA ERRORS (SQLPXCM2 P:20) SQLCA= -998 LOGGED TO DIAG FILE DURING 2-PHASE COMMIT SCENARIO IX79867 V5 CLI/ODBC APPL: IF AUTOCOMMIT IS ON AND THE CLIENT APPL GETS A LOCKTIMEOUT (SQLCODE=-911), THEN CONNECTION LOST (SQLCODE=-900) IX80044 SEMOP ERRORS ON EVERY FAILING LOCAL CONNECT (INVALID USERID OR PASSWORD). NET.DATA APP CAUSES DB2DIAG.LOG TO GET VERY LARGE IX80084 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) IX80087 INCORRECT RESULTS RETURNED FROM AN SQL QUERY AFTER RUNSTATS IS EXECUTED ON THE TABLES REFERENCE IN THE FROM CLAUSE. IX80098 DB2 UDB CONTROL CENTER - JOURNAL JOB HISTORY TIMESTAMPS GET OUT OF SYNC WHEN OLD JOBS ARE REMOVED. IX80107 DB2 UDB - SQL1269N/SQL1035 OCCURS WHEN ATTEMPTING AN ONLINE TABLESPACE ROLLFORWARD COMPLETE OR STOP. IX80130 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) IX80131 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) IX80294 SQLEXECUTE() DOES NOT REDESCRIBE WHEN THE SQLDA CHANGED IX80301 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY IX80315 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY IX80317 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY IX80372 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLYTRAIL TABLE IX80373 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLY TRAIL TABLE IX80374 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLYTRAIL TABLE IX80375 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 IX80376 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 IX80377 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 IX80480 DB2 V5. FAILURE TO RESTART LOAD. IX80545 DB2 V5 (ANY PRE 5.2) CRASH RECOVERY FAILS W/SQL1042. DB2DIAG.LOG SHOWS -6899 IN SQLPRESR() PROBE:0. IX80589 SQL901 WHEN RUNNING QUERY WITH INTRA_PARALLEL=YES,DFT_DEG.=-1 IX80618 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES IX80739 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES IX80740 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES IX80800 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 IX80801 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 IX80802 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 IX80810 DB2 UDB RESTART DOES NOT COMPLETE. LOOPING IN INDEX MANAGER. IX80916 SQLCODE804 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER IX80917 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 IX80918 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 IX81241 ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG IX81262 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS IX81263 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS IX81264 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS IX81265 ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG IX81266 ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG IX81362 RESTORE/MIGRATE OF V2/V4 DB RESULTS IN SQL2038 REASON 5055 IX81497 DB2TRC INFO IN SOLARIS SHOWS THE WRONG INFORMATION IX81647 BAD '#PRAGMA OPTIONS' IN SOLARIS SDK HEADER FILES IX81761 DB2AUTOLD (OLD AUTOLOADER) DOES NOT RETURN A NON-ZERO RC TO THE SHELL IF THE AUTOLOADER FAILS. IX81764 DB2ATLD (NEW AUTOLOADER) DOES NOT RETURN A NON-ZERO RETURN CODE IF AUTOLOADER FAILS IX81766 DB2AUTOLD (OLD AUTOLOADER) ISSUES AN SQL6534 WHEN DOING A RESTART OF A FAILED LOAD AND .NETRC FILE DOES NOT EXIST. IX81782 COLD START ENHANCEMENTS FOR SQLCODE964 IX81832 -902 ERROR ON SET EVENT MONITOR COMMAND IX82101 UDB CRASHES WITH ADSM V3 DURING ONLINE BACKUP IX82113 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 IX82114 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 IX82115 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 IX82123 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS IX82129 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS IX82134 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS IX82135 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS IX82188 SUBSEQUENT QUERIES RETURN NO DATA WHEN DEGREE > 1 IX82210 CD_OLD_SYNCHPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD IX82233 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. IX82239 CD_OLD_SYNCHPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD IX82240 CD_OLD_SYNCHPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD IX82243 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS IX82245 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS IX82289 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER IX82291 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER IX82292 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER IX82295 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. IX82296 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. IX82301 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS IX82302 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS IX82303 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS IX82334 RESTORE RETURNS SQL2038, RC=10746 IX82336 ERROR IN SETTING UOW STOP TIMESTAMP IN SNAPSHOTS IX82547 COLD START ENHANCEMENTS FOR SQLCODE964 JR09992 DB2DD RESTORE OF ONLINE BACKUP FAILS WITH SQL1261N JR10324 BACKUP OPERATION NOT RELEASING ALL MEMORY ONCE COMPLETED CAUSING RANDOM TRAPS IN DB2 AFTER A BACKUP JR10975 LOAD TABLE FROM AN IXF ENCOUNTERED -3314N JR11013 RESTORE VIA USEREXIT WITH DIFFERENT INSTANCE NAME FAILS JR11025 SQLPRIMARYKEY/SQLFOREIGNKEY LOCKUP SYSTABLES IN AUTOCOMMIT MODE JR11043 CONNECT TO HOST HANGS WHEN USING SYNCPOINT TWOPHASE JR11049 OBSOLETE DBMON TCB'S LEFT AFTER DATABASE PAUSE JR11073 SQL0332N - CODEPAGE CONVERSION BETWEEN 500 AND 1275 JR11075 DB2RESDB IS NOT RETURNING THE CORRECT OUTPUT/MESSAGE. JR11208 TRAP AFTER MANY SEQUENTIAL BACKUPS JR11261 DB2 COMMON SERVER - 'INTERSECT ALL' RETURNS TOO MANY ROWS. JR11296 MEMORY LEAK IN JDBC APPLICATION DRIVER WITH SETSTRING/GETSTRING JR11316 THE UNINSTALL ON THE WINDOWS PLATFORMS REMOVES THE REGISTRY ENTR IES OF PRODUCTS THAT WE DID NOT INSTALL LIKE WALLDATA RUMBA JR11319 OS2 V3 ODBC DRIVER NOT SUPPORTED BY V2 DRIVER MANAGER JR11325 THE CLI ARRAY INPUT PROCESSING IS BROKEN WHEN A SQLVAR SPILLS TH E REQUESTER IO BLOCK SIZE. JR11337 SQL3401 SQLGIMP COBOL API DOES NOT IGNORE FILLER BYTES JR11344 CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE JR11348 LOAD OF SOME IXF'S TRAPS JR11363 CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE JR11374 SETNULL METHOD HANDLED INCORRECTLY FOR INPUT/OUTPUT PARAMETER JR11388 CLP LOAD REPLACE (CODEPAGE 1252) WITH IXF FILE (CODEPAGE 850) BRINGS DOWN DB2 IN NT JR11390 SQL2015 ERROR IS RETURNED WHEN CUSTOMER TRIES TO ISSUE 'CONTINUE RESTORE' V1 REXX API AFTER 'RESTORE ...' API RETURNS A WARNING. JR11394 SQLPROCEDURE COLUMNS RETURNS COLUMNS IN THE WRONG ORDER JR11395 HIDE EXTENDED FETCH CAPABILITY JR11417 ROW DATA BEING SENT WITH SQL100 CONFUSES DRDA AR WHEN CONNECTING TO DB2 ON OS/2 AS THE DRDA AS JR11421 'REFERENCED MEMORY CANNOT BE READ' ERROR AS A RESULT OF LOOPING ON LOADLIBRARY/FREELIBRARY OF NT KERNEL DLL'S JR11422 DB2STOP HANG AFTER A FORCE APPLICATION ALL WITH ACCESS FEATURE. JR11428 CLI0002W DATA TRUNCATED. SQLSTATE=01004 {SQLDRIVERCONNECT} WHEN CONNECT STRING IS LONGER THAN 254 CHARACTERS JR11433 LOG CORRUPTION WITH '504' MESSAGES IN DB2DIAG.LOG FILE 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. JR11484 INTERMITTENT TRAP IN SQLUBINITPROCESS DURING BACKUP JR11497 CONTROL CENTER DISAPPEARS ON CLICKING 'FIND' - ARABIC CODEPAGE JR11498 SQL2503N FROM DB2RESDB RESTORING V1 DB TO V5 JR11502 PATCH KEYWORD IN DB2CLI.INI TO OVERRIDE OTHER SETTINGS JR11503 A CONTROL CENTER SCHEDULED BACKUP FAILS WITH SQL2040N-- INVALID DB ALIAS, ON NT. JR11508 DB2CONNECT TO SUPPORT LOCAL DATE JR11526 NLJN DOES NOT PRODUCE OPTIMUM ACCESS PLAN COMPAIRED TO V1 JR11528 DISCONNECT AND DETATCH FROM DB2CC DOES NOT DISCONNECT USER PROPERLY. JR11532 CCA DOES NOT ACCEPT UNDERSCORE IN TCP/IP HOSTNAME JR11535 JDBC DRIVER CLI0608E USING GERMAN CODEPAGE JR11547 BACKUP TO ADSM SENDING WRONG OBJNAME.LL FROM UNINITIALIZED SQLU_MEDIA_ENTRY STRUCTURE(POINTED TO BY MEDIA_LIST.TARGET.MEDIA JR11553 FLOATING POINT DATA TYPE RETURNS WRONG VALUE JR11562 V5 CLIENT SHOULD NOT USE DEFERRED PREPARE WHEN GOING TO V2 V2 SERVERS (TURN IT OFF) JR11568 ASN2703E SQLCODE1001E DURING MIGRATION OF CAPTURE FROM V1 TO V5 INCORRECT CONNECT TO LOCATION NOT DB ALIAS DURING BUILDDB JR11577 TRANSLATE FUNCTION RETURNS -901 ON KOREAN CHARS JR11585 PROBLEM WITH LIST APPLICATIONS SHOW DETAIL - CHANGE STATUS TIME JR11593 CLI PARSING PROBLEM ON 'SELECT'. RETURNS -518. JR11597 OPENING DB2 HTML DOCS ON UDB, DEFAULT BROWSER DOES WORK JR11624 SQLROWCOUNT RETURNS INCORRECT VALUE (0) AFTER UPDATE JR11629 PATCH1=1 CAUSES COUNT(DISTINCT COL) TO FAIL. 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. JR11647 MEMORY LEAK IN ODBC/CLI LAYERS IN 9014 FOR NT JR11651 'DB2 PREP TARGET IBMCOB' GIVES UNPREDICTABLE RESULTS. JR11677 TRYING TO ADD A NEW SYSTEM IN CC WITH NO INSTANCES CRASHES JR11680 REMOVE 8K LIMIT ON SQL FOR EXPORT COMMAND JR11722 INTERMITTENT DB2 TRAP IN FUNCTION SQLRIRETURNSUBSTRCSOBYTES OR SQLOFMBLK JR11724 SQL30082N RC=0 WHEN USING SECURITY SAME IN DB2 NODE DIRECTORY JR11726 SPORADIC TRAPS IN SQLNQ_TABSEL_OFN_CM 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. JR11735 NETBIOS LOOPS WHEN MAXNBSESSIONS IS REACHED JR11737 DSN FIELD TRUNCATED TO FIRST LETTER IN CLI CONNECTION STRING JR11741 UNABLE TO IMPORT A CLIENT CONFIGURATION WITH CLIENT CONFIGURATIN ASSISTANT (CCA) JR11760 THE UDB CONTROL CENTER HAS NO WAY TO SPECIFY S TO INDICATE THAT SQL BEFORE SHOULD BE RUN AT THE SOURCE SERVER JR11763 ERROR IN CCA WHEN PRESS 'ENTER' INSTEAD OF USING MOUSE JR11773 SQL0437W CAUSES OPEN IN DEFERREDPREPARE TO BE OMITTED JR11802 LARGE SQL STATEMENT USING DEFAULT AGENT_STACK_SZ =16 CAUSES STAC K OVERFLOW EXCEPTION ON NT JR11810 UDB NT TAPE RESTORE RETURNS SQL2530 -- IMAGE CORRUPT. JR11817 AFTER INSERT OF DATA>32700 . THE NEXT INSERT<32700 WILL CAUSE A CRASH. JR11818 DISABLEMULTITHREAD=1 IS NOT READ FROM DB2CLI.INI JR11820 CID INSTALL USING DB2.AUTHENTICATION DOES NOT WORK JR11821 WHEN SQL_ROWSET_SIZE>1, SQLGETDATA REPORTS INVALID CURSOR POS. JR11824 TRAP IN DOSCALL1.DLL DURING CTRL-C JR11834 ASYNCRONOUS READ REQUESTS AND ISSUEING INTERRUPTS. JR11841 SQL_OJ_CAPABILITIES DOES NOT RETURN THE PROPER INFORMATION 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 JR11872 CS ISOLATION LEVEL ALLOWS UNCOMMITED READ ACCESS OF A ROW WHICH CONTAINS A W LOCK. JR11878 DB2 UDB USER COUNTS ARE INCORRECTLY MANAGED WHEN THEY EXCEED THE MAXIMUM NUMBER OF LICENSES. JR11891 INTERMITTENT SQL1652 DOING SIMULTANEOUS DB2STARTS. JR11899 CAN'T VIEW OR SET CURRENTSQLID FROM CLIENT SETUP GUI JR11904 CHECK FOR IP ADDRESS BEFORE HOSTNAME FOR WIN95 TCP/IP JR11905 SQLNUMRESULTCOLS RETURNS FUNC SEQ ERR AFTER TIMEOUT JR11914 MIGRATING V211 DATABASE FAILS WHEN TRYING TO CONVERT HIGH2KEY AN D LOW2KEY VALUES JR11917 SQLCOLUMNS COLUMN_DEF RETURNS NULL EVEN WHEN THE COLUMN HAS A DEFAULT VALUE JR11921 \N CHARACTER IMMEDIATELY BEFORE/AFTER SELECT GETS SQL0518 JR11928 DB2 CONNECT HAS INTERMITENT PROBLEM LOGGED IN THE DB2DIAG.LOG: GATEWAY_DRDA_AR SQLJDRD1 PROBE:11, DIAGDATA = 34FF FFF JR11940 SQLCODE301 ON APPLY STARTUP JR11952 THIN INSTALL FROM WIN NT DOES NOT INSTALL ODBC FILES CORRECTLY JR11953 ARRAY INSERT TRAPS. JR11956 TRAP IN DB2CLI.DLL IN CLIENT WHEN FORCE APPLICATION IN SERVER JR11958 CONTROL CENTER SPLITS F Q HOSTNAME INTO TWO. FIRST PART BECOMES THE HOSTNAME, THE SECOND BECOMES THE REMOTE INSTANCE NAME. JR11959 SQL0805N ON AN SQLEXECUTE() WHEN DBM CFG ASLHEAPSZ 1 JR11972 JDBC METADATA USING GETTABLES RETURN NULLPOINTEREXCEPTION JR11981 RETRIEVING DECIMAL DATA INTO A DOUBLE WITH STATIC CURSOR DOES NOT RETURN DATA JR11990 JOURNAL ALERT DATE DOES NOT SORT PROPERLY JR11999 WHEN NT TIME IS SET TO SOMETHING OTHER THAT EST, THE EVENT MONITOR START TIME (THROUGH EVENT ANALYZER) IS INCORRECT. JR12000 MULTITHREADED APPLICATIONS TRAP IN UDB JR12005 INTERMITTENT TRAP IN SQLODUMPEDU JR12007 SQLCODE100 UDB CONTROL CENTER DOES NOT INITIALIZE THE PHYS_ CHANGE_OWNER AND PHYS_CHANGE_TABLE VALUES WHEN SOURCE IS CCD JR12010 LOAD SCRIPT RUN FROM SCRIPT CENTER CAUSES GPF IN JOURNAL WHEN VIEWING THE JOB HISTORY FILE. JR12021 TRAP IN TCP32.DLL IF DB2COMM=TCPIP AND USING TWO PHASE CONNECT JR12032 A BUG CAUSES SQL1109 WHEN USING SCHEMA IN CALL STMT IN JAVA STORT PROCEDURE (INTEL ONLY) JR12035 OPTIONS DROP AND REMOVE ARE TRANSLATED WRONG IN SPANISH CC JR12038 SQL4414 IN THE CC FOR LOCAL ADMIN FUNCTIONS IF DB2SYSTEM CONTAINS A SPACE CHARACTER JR12040 TRAP IN SQLNO_FINAL_PHASE WHEN OPTIMIZER IS CREATING VERY LARGE (DEEP) ACCESS PLANS. JR12067 PRE-UDB CLIENT TO UDB SERV, HOST VAR NAME UNIQUE TO 18TH CHAR IF 2 HV ARE SAME TO 18 CHARS, THEY MAY TREATED AS SAME VARIABLE JR12070 DB2 UDB MEMORY LEAK AFTER ATTEMPTS TO CONNECT TO DATABASE FAIL. THE CONNECT FAILURE WAS AN SQL0290 ERROR IN THIS CASE. JR12072 LEFT OUTER JOIN PROVIDES INCORRECT RESULT SET. JR12093 FILTER FACTOR OFF AND NO FREQUENCY STATS ON VARCHAR COLUMNS JR12130 AT CS A ROW LOCK REMAINS IF THE ACCESS PLAN PREFETCHES RIDS JR12143 MEMORY LEAK IN NT AFTER DISCONNECT JR12167 A LONG WHERE IN CLAUSE CAUSES AN SQL0101--STATEMENT TOO LONG IN NT OR -901 -- NEGATIVE COST IN PLAN ON AIX UDB JR12169 MIGRATION OF THE NODE DIRECTORY FAILS JR12172 CONTROL CENTER ALLOWS UPDATE OF SUBSCRIPTION STATUS 2 JR12219 CAE DOES NOT CONTAIN ALL THE CONVERSION FILES NEEDED BY JDBC JR12220 ABILITY TO USE CHARACTER DELIMITING DURING LOAD JR12221 OPTIMIZER BUG FOR HOST VARIABLE FILTER FACTORS AND RUNSTATS JR12227 RIGHT BEFORE SELECT CAUSE SQLEXECDIRECT TO FAIL. JR12240 DEFECT 83823 BREAKS NT AND OS/2 STORED PROCEDURES JR12247 CCA ONLY SHOWS 8 CHAR SCHEMA FROM AS/400. JR12252 CRASH RECOVERY HANGS JR12267 INSTALL ADDS DEFALT_LOCAL_LU_ALIAS TO THE CS NDF FILE. JR12273 THE CONTROL CENTER IS NOT CHOOSING THE CORRECT ' MASTER ' TABLE FOR THE JOIN - VIEW REPLICA SCENARIO JR12282 MIGRATION FROM DB2 V1 TO V5 FAILED DUE TO NULL VALUES IN COLUMN 'STANDARD_LEVEL' OF TABLE SYSPLAN. JR12345 SMALL TALK CANNOT CALL SQLURST, ONLY SQLURTS@92, SAME FOR BACKUP API. JR12362 WHEN CALLING THE SQLE_DEACTIVATE_DB_API DOES NOT POPULATE SQLWAR N FILED IN SQLCA PROPERLY.