******************************************************************** Product Name : DB2 for HP-UX-v11 Version 5.2 PTF Number : U465115 Package Date : Fri Aug 13 14:43:54 EDT 1999 Build Level : c990717 ******************************************************************** List of APARs that went into U465115 APAR No. Abstract -------- ------------------------------------------------------- IY01167 -901:SQLNO_CRULE_SAVE_PLANS [100] JR13405 APPL_NAME OPTION DOES NOT WORK WITH CREATE EVENT MONITOR IY01933 PROBLEM WITH RETROFIT OF 120563 JR13428 MEMORY LEAK WITH UDFS WHEN RETURNING BLOBS OF VARYING SIZE IY01841 12/99:RELEASE CATALOG LOCKS ACQUIRED FOR COMPILATION JR13112 INSERT UDF CAN CRASH DB2 IY00843 FAILED TO INITIALIZE THE WAIT/POST AREA ON NT JR13290 DISABLE ASYNC BY DEFAULT IY02708 DEAD LATCH ON CREATE TABLE WITH PRIMARY KEY JR13488 SQLCOLATTRIBUTES WITH SQL_DESC_BASE_TABLE_NAME WRONG IY01548 PROPER HANDLING WHEN CRASY-RECOVERY FAILED. IY00843 IMPROVE THE HANDSHAKE BETWEEN SQE AND MONITOR CODE WHICH COULD IY01277 OFFLINE BACKUP TRAP IN SQLUHCONVSTRUCTTOLINE IY01381 TRANSACTION TABLE FULL AND OVERFLOW OCCURED WITH TUXEDO IY01547 MULTIPLE 8133 MESSAGES IN DIAGLOG DURING CRASH RECOVERY IY01898 INTERNODE COMMUNICATION ERROR RESULTS IN DB CRASH JR13333 EXECUTING A STORED PROCEDURE ON A LOCKED TABLE CAUSES TRAP. IY01933 SQL0901 REPORTED BY SQLRAFRS() JR13103 CONNECTION.GETAUTOCOMMIT() SHOULD RETURN FALSE FOR XA DRIVER WH IY02162 MIN BUFF LSN TOO HIGH, RESTART FAILS, SOME LOG RECS MISSED IY02257 OPTIMIZER COSTING PROBLEM CAUSES PERFORMANCE DEGRADATION IY02285 BADLSN FIX IY01930 CALLING SQLUIHSH() FROM UNFENCED UDF HANGS ENGINE IX83662 SIGNAL#11 IN SQLKD_RCV_DATA JR13415 RESET COUNTER NOT WORKING ON DB ALIAS JR13152 VERSION INFORMATION NOT INCLUDED IN DLL HEADER JR13152 ADD VERSION INFORMATION TO DB2NT_V3 JR13402 NAMED SHARED EVENT SEMAPHORES NOT UNIQUE List of APARs that went into 465094a APAR No. Abstract --------- ------------------------------------------------------- IY00882 SQL1614 RC 6 STARTING EVENT MONITOR - SEMAPHORE NOT REMOVED IY01210 DB2GOV REQUIRES DB2GOVD VALIDATE IF DB2GOV START NODENUM X RUN IY01295 TUXEDO TX_BEGIN() RECEIVES TPEPROTO FOLLOWING TX_ROLLBACK() IY01397 PERFORM INTERNAL OPERATION LOCAL TO CO-ORD IF POSSIBLE: EEE IY01401 WRONG INFO REPORTED BY APPLICATION SNAPSHOT IY01525 DB2LOOK DOES NOT SHOW NOT LOGGED INITIALLY OPTION FOR A TABLE IX89396 INTEGRATE 110701 INTO DB2_V3! JR13324 CALLING STORED PROCEDURES ON AS/400 WITH MORE THAN 9 PARAMETERS JR13344 INCORRECT DESCRIBE INFO USED ON AN EXECUTE. JR13363 CCA ADD DATABASE SMARTGUIDE CANNOT TRUNCATE COMMENT FIELD IY01885 MEMORY LEAK WHEN USING ARRAYINPUT JR13156 CLI0614E RETURNED TO JAVA APPLET. INTERMITTEN. JR13354 SQL1404 (PASSWORD EXPIRED) IS IGNORED FROM A MVS WHEN USING ODB IY02027 SQL0304N WHEN SELECTING FROM REAL COLUMN ON MVS IY02029 TRAP INSIDE OF SQLEJNMSTP_SETBIGDECIMAL WHEN USING A BIGDECIMAL JR13156 PARAMETER MARKERS IN JDBC APP BOUND WITH WRONG SIZE IY02147 STARTING DB2JD HAS SEGMENTATION FAULT IF JDBCERR.TXT NOT AVAIL IY01429 -901 IN SQLNO_SMP_RUNIN_COORD WITH INTRA_PARALLEL ON JR13355 THREE WAY JOIN FOR REPLICATION FAILS THROUGH CONTROL CENTER IY02092 CHANGE USER TRAPS IN DB2CC.EXE FROM CONTROL CENTER JR13152 VERSION INFORMATION NOT INCLUDED IN DLL HEADER List of APARs that went into U465094 APAR No. Abstract -------- ------------------------------------------------------- IX89839 27 RETURNED INSTEAD OF HEAP NAME FOR SQL0973 IY02026 BASICALLY THE PROBLEM IS THAT ON UDB(FP8)/AIX(SMP), WHEN LOAD C IY01429 -901 IN SQLNO_SMP_RUNiN_COORD WITH INTRA_PARALLEL ON IY01710 BADLSN JR13295 DB2PEM32.DLL IS NOT THREAD SAFE IY01726 -952 ON JAVA STORED PROCEDURE BECAUSE BDSCOUNTER NOT INCREMENTE JR13332 CHANGE PASSWORD FOR 8 CHAR USERID RETURNS INVALID USERID IY01883 DB MARKED BAD ERROR IN SQLBCHECKSMP4OBJDEL JR13278 THE REGISTRY INFORMATION FOR DB2CLI.DLL AND DB2ODBC.DLL STILL P JR13152 ADD VERSION INFORMATION TO DB2NT_V3 List of APARs that went into U464885 APAR No. Abstract -------- ------------------------------------------------------- IY01762 JNI PANIC: JNI RECEIVED A NULL ARRAY (WHEN USING APP DRIVER) IY00838 NIS: CONNECT ... CHANGE PASSWORD "FAILS" WITH SQL1403N JR13169 #DELETED IN MS ACCESS WHEN QUERYING TABLE IN DB2 JR13200 USING BOTH ODBC 2 AND ODBC 3 ENVIRONMENTS AT THE SAME TIME. JR13009 RETURN ODBC ESCAPE CLAUSE FOR CALL STMT FROM SQLNATIVESQL JR12918 TABLETYPE KEYWORD NOT WORKING FOR SYNONYM IY00412 DB2JD CAN'T BE STARTED IF DISABLEMULTITHREAD=1 IN DB2CLI.INI GG03881 ASNMIG DOESNT SET/MIGRATE COLUMN SYNCHTIME IN IBMSNAP_SUBS_SET. GG03921 VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION GG03883 VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION GG03917 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS GG03919 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 GG03918 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS GG03920 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 IY01375 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS IY01378 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 IY01376 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS IY01379 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 IY01377 APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS IY01380 MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431 PQ27660 CHECK IN REPLICATION APPLY FOR V5 FIXPAK 9 JR13194 SET ACCOUNT STRING IN THE DB2CLI.INI FOR MVS JR13315 SQL30020 AFTER PASSING SQLDA TO HOST. GG03880 DPROPR MIGRATE, STL CMVC GG03880 IY00230 CLI0601 IF FREESTMT FAILS BECAUSE OF SQL30081 ON A COMMIT. IY01371 CLIENT HANGING IN A 3-TIER ENVIRONMENT JR13157 SQLMORERESULTS FLOWING EXTRA FLOWS TO THE HOST IY01386 TRANSACTION NOT FOUND MESSAGES IN DB2DIAG.LOG, IN TUXEDO ENV IX87233 DB2_ALL CAN ONLY BE EXECUTED FROM THE INSTANCE OWNER JR12774 ADVANCED ODBC SETTINGS TRUNCATES IX89691 TRAP IN SQLE_DB2RA_AS_DB_OPEN IY00971 SNAPSHOT DOESN'T SHOW LOCKS BEING HELD AT CATALOG NODE IX87116 ADD THE OPTION TO SPECIFY THE COLUMN DELIMITER AND CHANGE THE IY01157 NODE UNABLE TO RESTART AFTER FAILURE: POTENTIAL LOG CORRUPTION IY01281 08/99:ERRONEOUS -902 BEING REPORTED IN SQLRLFPR.C IY01282 SIGNAL #11 IN AGENT_STMT_START() IY01392 RESERVE ENOUGH LOG SPACE FOR UNDO OF DELETE NODE FOR V5 INDEXES IX88536 V5.2:DBADM SHOULD BE PERMITTED TO ADD USER FROM CONTROL CENTER. JR12556 CONTROL CENTER CREATE DB FROM BACKUP DOESN'T FAIL WITH ONLINE JR13269 USEREXIT ARCHIVES MAX 63 LOG FILES AFTER ERROR IS CORRECTED. JR12995 JAVA APPLET (JDK1.2) TRUNCATES RESULTS FROM SELECT OF CHAR COL. JR12996 TRAPS IN SQLJMFR1.C ON DB2 CONNECT V5.2 JR13091 SQL30020 RC=124C PLUS DUMP FILES WHEN SELECTING IN ASYNC MODE IY00867 HOT: TRAP AT SQLRA_CSM_DROP_SECT IX89997 UNTYPED PARAMETER MARKERS CAST INCORRECTLY FOR IN CLAUSE JR13153 GATEWAY TRAPS IN SWITCH_DB2RA IY00229 TQ HANG JR13202 NET.COMMERCE SQL0502N AND SQL0514N: 2 STMTS USING SAME CURSOR JR13223 CALLING STORE PROCEDURE HANG OR TRAP JR13217 SQLGETINFO(SQL_ORDER_BY_COLUMNS_IN_SELECT) REPORTS 'N' FOR MVS JR13218 EXTENDING PATCH2=19 FOR DB2/390 V5.1 '(' ')' AND ON CLAUSE IY00782 SQLPGRLG() PROBE 70 : CRASH RECOVERY ENDED TOO EARLY IY00858 TRAP IN MEMTREEPUT FROM SQLM_CONN::STMT_START JR13169 PATCH2=24 NEEDS ADDITIONAL FIX IY00976 RESTORE FAILS WITH SQL0973 - OUT OF LOCK LIST HEAP IY01020 CORRELATION ADJUSTMENT DOES NOT WORK FOR LARGE QUERIES JR13270 THE NET DRIVER (DB2JD) LEAKS WHEN SELECTING BLOBS FROM JR12713 FFFFF616 FROM SQLBTERMINATEAGENT IGNORED IN SQLETERMDBCONNECT IX88394 TRAP IN CC-JOURNAL WHEN VIEWING HISTORY JR12964 V5.2:STATEMENT VIEW (EVENT MONITOR) OPENS MULITPLE CONNECTS. JR13152 VERSION INFORMATION NOT INCLUDED IN DLL HEADER GG03863 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES GG03865 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES GG03867 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT GG03869 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS GG03871 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY GG03874 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION GG03876 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH GG03891 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER GG03893 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. GG03895 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION GG03898 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 GG03905 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. GG03907 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER GG03908 APPLY ONLY PROCESSES LAST EVENT POSTED GG03909 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY GG03864 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES GG03866 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES GG03868 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT GG03870 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS GG03872 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY GG03875 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION GG03877 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH GG03892 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER GG03894 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. GG03896 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION GG03899 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 GG03906 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. GG03910 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER GG03911 APPLY ONLY PROCESSES LAST EVENT POSTED GG03912 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY IX88123 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES IX88130 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES IX88138 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT IX88142 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS IX88144 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY IX88992 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION IX88995 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH IY00603 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER IY00610 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. IY00795 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION IY00798 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 IY00986 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. IY00989 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER IY00990 APPLY ONLY PROCESSES LAST EVENT POSTED IY00473 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY IX88124 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES IX88131 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES IX88139 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT IX88141 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS IX88145 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY IX88993 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION IX88997 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH IY00604 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER IY00611 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. IY00796 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION IY00799 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 IY00987 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. IY00991 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER IY00992 APPLY ONLY PROCESSES LAST EVENT POSTED IY00995 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY IX88125 RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES IX88132 PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES IX88140 APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT IX88143 CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS IX88146 WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY IX88994 MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION IX88996 INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH IX89665 APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS IY00605 APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER IY00612 STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS. IY00797 FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269 IY00800 ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION IY00988 THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME. IY00996 PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER IY00997 APPLY ONLY PROCESSES LAST EVENT POSTED IY00998 APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY GG03878 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS GG03887 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS GG03903 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE GG03904 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED GG03879 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS GG03888 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS GG03885 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE GG03889 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED IX88078 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IY00045 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS IY00975 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE IY00977 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED IX89054 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IY00100 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS IY00961 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE IY00962 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED IX89055 WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS IY00101 WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS IY00964 CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE IY00965 CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED List of APARs that went into 462902i APAR No. Abstract -------- ------------------------------------------------------- IY00676 SQL1403 ON CONNECT USER/USING JR13256 PMR#33083 IY00403 PATCH FOR DEFECT 116571 IY00268 PREFETCHER PLSDIE PROTOCOL MAY CAUSE HANGING JR13169 #DELETED IN MS ACCESS WHEN QUERYING TABLE IN DB2 IY00268 LOAD TRAPS DURING THE BUILD PHASE IN SQLU_SBPREFETCH IY00674 DB2ATLD & HANGS IY00718 HASH JOIN PLAN MAY HANG IY00761 POTENTIAL NULL DEREFERENCE DURING DROP TABLE AND DB SHUTDOWN. IY00793 INCORRECT TEXT MESSAGE FOR OS/390 ERROR -965. JR12749 POINT IN TIME ROLL FORWARD RECOVERY FROM CC DOES NOT WORK JR12751 CONTROL CENTER TRAPS WITH SPECIFIC JOURNAL HISTORY FILE IY00045 DPROPR CAPTURE, STL CMVC IY00045 JR13242 SQL1042C WITH BACKUP DUE TO MIXED CASE DRIVE LETTER (MSCS) List of APARs that went into 462902h APAR No. Abstract -------- ------------------------------------------------------- JR12812 CCA TRUNCATES BIND MESSAGES WITH INVALID CHARACTERS IX88493 DB2_CORRELATE_PREDICATES=YES GIVES WRONG CARD ESTIMATES IX88675 -Q OPTION CAUSES ALL DATE FIELDS THAT ARE NULL TO NOT ALIGN IX88801 PARALELLISM IS NOT FUNCTIONAL FOR ODBC. IX88793 FIX COUNT!=0 ON DROP TABLESPACE WHILE LOAD RUNNING IX89062 SQL0901 (REASON FLUSHBLOCKS: NO PART SMP) IX89405 SIGNAL#11 IN SQLRITTB IX89467 CURRENTSQLID IS NOT PICKED UP BY CLI APPLICATIONS. IX89871 RETROFIT: -901 (NO PLAN FOUND) SQLNO_ITR_PLAN::NEXT JR13171 LOAD UTILITY ON USAGE OF DEL FORMAT GENERATES WARNING MESSAGE IY00444 IMS HEALTH HASH JOIN FIX, PRIVATE VIRTUAL MEMORY EXHAUSTED JR13184 DURING CONFIGURATION OF CLIENT USING CCA AND IMPORT JR13187 IMPROPER CHECK ON LENGTH FIELD CAUSING A MEMORY OVERWRITE IX89535 SEE 111384 IY00403 ALLOW SOLARIS NON-THREADED LOADABLE OBJECTS FOR DB2_NOTH.SO JR13204 MEMORY LEAK CONNECTING TO LOCAL DATABASE & DB2START NOT ISSUED IY00480 ENSURE DB2AUDIT EXECUTABLE RETURNS 0 INSTEAD OF 6 WHEN SUCCESSF IX87116 DB2BATCH DEFECTS (REMOVE EXTRA SPACES EXTRA BLANK LINES, APPEN JR11822 12/98 NT: LOAD FROM A ZIP DRIVE HANGS List of APARs that went into 462902g APAR No. Abstract -------- ------------------------------------------------------- IY00270 LIKE CLAUSE WITH FORMAT '%....%' GENERATES ERRATIC RESULTS IY00157 CREATING CODB2LOOK RETURNS SQL1008N-INVALID TABLESPACE ID IY00360 ADD OBJECT REXX SUPPORT IN DB2 UDB EEE 5.2 ON AIX (C990318) IY00239 JDBC APP FAILS WITH CLI0601E SELECTING > 100 COLUMNS IX87450 FILE MANAGER EXPORT CONTROL FILE NOT BEING CREATED IN SOME CASE IX87741 INCORRECT ROUND FUNCTION OUTPUT IX88096 JAVA GETLONG NOT RETURNING 0 FOR NULL VALUES IX89850 USING PKGRM "DB2 PACKAGES" COMMAND ,DELETES SUN PATCHES ALSO. JR13150 QUERY WITH LIKE '' TRAPS IN SQLNO_FF_COMPUTE_LIKEPRD JR13156 PARAMETER MARKERS IN JDBC APP BOUND WITH WRONG SIZE IX87911 SAMPLE USEREXIT MAY ATTEMPT TO CLOSE A FILE WHICH IS NOT OPEN IX88660 SQLPROCEDURES PROBLEM WHEN GOING TO AS/400 STORED PROCEDURE List of APARs that went into 462902f APAR No. Abstract -------- ------------------------------------------------------- IY00034 PROGRAM FLOW ERROR IN MGJN IX89209 FP9: ABILITY TO FIX TERRITORY FIELD FOR MIGRATED DBS V2 TO V5 IX89506 REINTRODUCE APM CACHE LOGIC TO RETRY RESERVE BEFORE OVERFLOW IX89840 RENAMING LOG FILES DURING DB DEACTIVATION CAUSES ABNORMAL DB CR JR13114 DB2DEFPREP=YES NOT DISABLED FOR PREPARE WITH INTO CLAUSE IX89960 DON'T SEND FETCH TO SERVER IS SQLCODE +100 (WITH HOLD CURSOR) IX89962 GET INSTANCE COMMAND RETURNS DB21016E IX88660 FIX DB2_V3 BUILD ERROR JR13141 SQL01092N WHEN CATALOGING WITH DOMAIN USER ON WR09094 IX89426 SAME AS DEFECT 110788 IX89896 SCHEDULED BACKUP FROM DB2CC DOES NOT FUNCTION CORRECTLY JR12990 SQLTENTR_CEI_FIT1 SYMBOL NOT FOUND ON OS/2 FOR MF COBOL APP List of APARs that went into 462902e APAR No. Abstract -------- ------------------------------------------------------- JR13043 OUT OF RESOURCE ERROR BACKING UP DATABASE OVER 192GB ON NT IX88660 SQL0302N WHEN INVOKING STORED PROCEDURE ON AS/400 FROM JAVA IX88868 DB2ATLD LOCK-WAITS ON AN X ROW LOCK ON SYSCOLUMNS IX89305 ROLLFORWARD RETURNS SQL1042C FOR AN INTERRUPT IX89506 REINTRODUCE APM CACHE LOGIC TO RETRY RESERVE BEFORE OVERFLOW JR13076 MEMORY LEAK IN JVM WITH JAVA UDF IX71710 RECLAIMED TOO MUCH LOG SPACE APPEARS DURING CRASH RECOVERY IX89661 HOT BLD NT: CONNECTION FAILS BECAUSE OF BACKUP PENDING (CF022) IX89927 CONTAINER REMOVED DURING ROLLFORWARD THROUGH FAILED ADD CONTNR IX88078 DPROPR CAPTURE, STL CMVC LEVEL IX88078 List of APARs that went into 462902d APAR No. Abstract -------- ------------------------------------------------------- IX89661 HOT BLD NT: CONNECTION FAILS BECAUSE OF BACKUP PENDING (CF022) IX86967 ADD SUPPORT FOR A STATICALLY BUILT DB2SYSC ON SOLARIS JR12815 EXPORT TO DEL USES COMMA INSTEAD OF PERIOD FOR DOUBLE IX87941 SECOND CALL TO JAVA STP FAILS WITH "NOT ENOUGH MEM" (UNFENCED) JR12946 SELECT FAILS SQL1224N RECORD LENGTH > SQL_MAXRECL.A70F 0000 IX89216 SIGSEGV WHEN MORE THAN 100 CONNECTIONS USING APP DRIVER IX87910 HOT: DB MARKED BAD DURING UPDATE DUE TO ERROR IN INDEX MANAGER JR13006 OS2 SMP BACKUP TO USEREXIT TRAPS IN SQLEBUILDBDSUNIQUEID JR13089 DB2_V5: ADD ENVIRONMENTAL VARIABLE TO TURN OFF USE OF THE QUEUE IX88739 ADD ADDITIONAL FUNCTION JR13056 TRAP IN SQLNO_COST_NLJN IX89661 RESTORE COULD NOT FIND DB CFG FILE. IX89677 DROP INDEX CRASHES INSTANCE IX85148 -902 SQLCODE ON ROLLFORWARD TO POINT IN TIME - EEE List of APARs that went into 462902c APAR No. Abstract -------- ------------------------------------------------------- IX89057 ISCAN FETCH WHEN IT SHOULD HAVE BEEN AN INDEX ONLY ACCESS IX89317 SAP - ACCESS PLAN CHANGED BY ADDING INDEXES WHICH ARE NOT USED IX87063 SOLARIS:SQL1072 - CAN'T GENERATE UNIQUE KEYS IF INODES ARE HIGH IX87063 ADDITIONAL FIX FOR 100891 - FTOK IX87722 TRAP IN SQLEX_DDCS_DEL_USER_CONTEXT JR12885 WHEN ACCESSING A STORED PROCEDURE ON AN MVS, AND RETURNING A CO JR12906 FAILS TO GENERATE APPROPRIATE TRAP FOR SIGNIFICANT EVENTS IX88179 TYPECASTING TO DECIMAL IN UDFS RESULTS IN LOSS OF PRECISION IX88441 DB2 LOAD ISSUES WITH THE NONRECOVERABLE OPTION JR12948 APPLETSECURITYEXCEPTION WITH APP DRIVER AND TRUSTED APPLETS JR12941 SQLOREADFILEINTERRUPT TRACEPOINT APPEARING IN NT/DB2DIAG.LOG JR12982 NEWLOGPATH UPDATE LOGS NT ERROR EVENT, BUT WORKS FINE JR12989 SQLESTAT INCORERCT FUNCTIONALITY JR12998 AFTER APPLY FIXPACK 7 TO CAE/NT, LIST DCS APPLICATIONS DISPLAYS IX88966 DESCRIBEPARM TRAPS IF PREPARE HAS A WARNING AND DEF.PREPARE OFF IX88969 DB2JD CHILD PROCESSES ON SOLARIS IX88981 DB2 ADD NODE RETURNS -902 JR13027 TCG FAIL TO PROPERLY SET NULL START/STOP KEY IX89285 ALTER TABLESPACE ADD CONTAINER FAILS DUE TO REDIRECTED RESTORE IX88761 NEW FUNCTION IN DART TO SHOW OWNER OF A PHANTOM QUIESCE IX89238 RETRO-FITTING TRANSITIVITY FIX TO DB2_V3 IX89341 DB2ADMIN STOP FAILS WITH SQL1092N JR13040 DB2UEXT2.C FOR NT HAS COMMENTS REFERRING TO DB2UEXT.C List of APARs that went into 462902a APAR No. Abstract -------- ------------------------------------------------------- IX86970 NOT ENOUGH LOG SPACE RESERVED DURING REORG JR12781 DB2START ON ACTIVE DBM DUMPS B700 INTO DB2DIAG.LOG JR12822 MULTIPLE SQL0502 ERRORS IN NT EVENT LOG IX87877 SIG#11 ON RESTART WHEN MONITOR SWITCHES ON IX87910 LOCKING BEHAVIOUR WITH CS AT BOUNDARY CONDITIONS INCORRECT JR12816 BLOCKING LOAD REQUEST ON TYPED TABLES. IX88041 SQL0134 WHEN USING SQLJ WITH A STRING HOST VARIABLE. JR12922 SQLESTAT PROBLEM ON V5 CLIENT. IX88274 FIX HANG ON CRASH RECOVERY DUE TO LOCK-WAIT ON SYSTABLESPACES JR12919 BYTE REVERSING OF UNDERDBDIR NOT HAPPENING ON NT IX88408 SQP PROBLEM FROM STATEFARM AS IN PMR45929 JR12936 DB2 CONNECT TRAP AT SQM_LIST_DCS_DB_RESETTABLE_DATA IX88449 TEMP TCB NOT LOADED ON SCROLLABLE CURSOR APPLICATIONS IX88454 DB2ATLD MAY HANG WITH ENTRIES IN DIAG UNABLE TO QUIESCE POOLS JR12958 PRECOMPILER GENERATES DIFFERENT SQL TYPE FOR CHAR HOST VARIABLE IX88738 DB2BATCH -P D OPTION DOES NOT CREATE NLI TEMP TABLES IX88563 SELECT FROM VIEW RETURNS INCORRECT ROWS IN V5 FOR V1 DATA JR12966 TRAP IN SQLJMPAR JR12971 TRAP WHEN TRYING TO RESYNC AN INDOUBT WITH UDB OS/390 IX88816 SQL2542N AT RESTORE PE V1.2 DB WITH TAKEN AT OPTION JR13001 UDB GATEWAY CRASHING WHILE CONNECTING CLIENT TO SERVER WITH TCP IX88834 SEGV IN SQLNR_CORRELATED_TOQUN IX88917 COUNTER NOT BEING INITIALIZED FOR DCS SNAPSHOT. OUTPUT FOR SQL IX88741 DB2BATCH PRODUCING EXTRANEOUS HEADER/FOOTER OUTPUT IX88873 DB2ATLD MAY HANG AT INITIALIZATION IX88942 LOCKING MECHANISM IN SQLUGTPI. SEE NOTES ATTACHED. WE NEED FIX IX88968 POOLPGNUM TOO HIGH WHEN ADDING VALUES TO AN INDEX "DIA3509" IX86007 SIGNAL#11 IN SQLULADDINXKEYS JR12915 JAVA CLIENT TRAPS IN DB2CLI.DLL RECEIVING RESULT SETS JR12750 INVALID DDL BEING CREATED FOR CHANGE DATA TABLES JR12912 DUPLICATE INDEX NAME GENERATED IX88738 SPLITTER NOT HANDLING YYYYMMDD DATES FOR DEL. List of APARs that went into U462902 APAR No. Abstract -------- ------------------------------------------------------- IX87839 EXCEEDING MAX APPLID SIZE OF 32 BYTES. IX87911 ERROR CODE 28 FROM SAMPLE USEREXIT WHEN LOG FILE DOES NOT EXIST JR12894 RANDOMS TRAPS IN SQLRA_DEL_VAR_CACHE IX88313 HASH_JOIN PLAN MAY PRODUCE INCORRECT RESULTS JR12745 SQLBINDPARAM WITH LENGTH 0 USING SQLPUTDATA/SQLPARAMDATA. IX87928 FIXES TO REPLICATION ADMIN TOOL, DJRA IX87156 3/99: RETROFIT SMP IXA HANG FIXES GG03848 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. GG03850 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 GG03849 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. GG03851 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 IX87076 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. IX87080 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 IX87078 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. IX87081 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 IX87079 WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0. IX87082 IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1 GG03841 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN GG03844 AUTHID COLUMN IN UOW TABLE IS INCORRECT GG03846 NULL LONG VARCHAR VALUES NOT REPLICATED GG03853 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN GG03855 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN GG03857 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD GG03856 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 GG03860 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD GG03840 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN GG03843 AUTHID COLUMN IN UOW TABLE IS INCORRECT GG03845 NULL LONG VARCHAR VALUES NOT REPLICATED GG03847 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN GG03854 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN GG03858 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD GG03859 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 GG03861 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX85990 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN IX86080 AUTHID COLUMN IN UOW TABLE IS INCORRECT IX86911 NULL LONG VARCHAR VALUES NOT REPLICATED IX87200 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN IX87047 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN IX87595 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD IX87665 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 IX87422 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX85991 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN IX86081 AUTHID COLUMN IN UOW TABLE IS INCORRECT IX86913 NULL LONG VARCHAR VALUES NOT REPLICATED IX87201 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN IX87202 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN IX87653 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD IX87667 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 IX87670 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX85992 SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN IX86082 AUTHID COLUMN IN UOW TABLE IS INCORRECT IX86914 NULL LONG VARCHAR VALUES NOT REPLICATED IX87206 VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN IX87205 LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN IX87654 UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD IX87668 SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 IX87671 SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD IX87124 BUFFER POOL ALLOCATION - SOLARIS 2.6 MEMORY MANAGEMENT CHANGES IX87172 POOR PERFORMANCE BECAUSE STAR JOIN IS NOT SELECTED IX87280 ROLLFORWARD FAILS (SQL1271W) WHILE REBALANCING IX87417 SQL2036 - INVALID PATH, IN MLN ENVIRONMENT USING DB2 LOAD IX87463 MULTIPLE LOGON WINDOWS WITH ACCESS WITH NO UID/PWD INPUT JR12814 DB2LOOK FOR REFERENTIAL CONSTRAINTS IX87540 INVALID ROW COUNT RETURNED ON UPDATE WITH STREAMS (LOB) IN JDBC IX87542 RECOVERY HISTORY FILE GOT PRUNED EVEN WHEN REC_HIS_RETENTN = -1 IX87634 TRAP IN V5 CAE WHEN EXIT HANDLER IS CALLED IX83662 NEW DEBUG CODE FOR 93096 ON SENDING SIDE OF DSS IX87720 CLI SQL_CONNECT_NODE WILL NOT ACCEPT VALUE 0 IX83104 V3: ESTORE PROBLEM WITH ATTACHED SEGMENTS IX83408 FAILING BACKUP NOT RECORDED IN HISTORY FILE JR12555 SQL2032 REMOTE BACKUP TO ADSM VIA NT CLIENT SESSIONS >1 IX84766 RESTART FAILS WITH SQL0575 WHEN REPLICATED TABLE IS INVALID IX84195 DB2LOOK MEMORY LEAK WHEN SMP INVOLVED (DFT_DEGREE > 1) JR12681 SUPPORT OPTIMIZE FOR N ROWS BY TURNING OFF PREFETCH IX82599 DB2_V5:THE START UP LOGIC FOR OUR LICENSE DEAMON IS TIME SENSIT IX86221 DB2 5.2: RESTORE HANG JR12721 IN PREDICATE WITH >284 ITEMS IN SELECT STATEMENT TRAPS ENGINE. JR12748 SYMBOLS FOR GENERIC API NOT EXPORTED FOR UDB VERSION 5/5.2 JR12790 SCRIPT CENTER JOB HAVING START CMD FAILS SQL1131 & MEM ERROR List of APARs that went into 461712g APAR No. Abstract -------- ------------------------------------------------------- IX86733 DB2SETUP: INSTANCE CREATE FAILS ON AIX 4.3.2 JR12813 DL:EXPORT DATALINKS.ON WINNT/DOS/OS2 NO MKDIR FOR CTRL FILE JR12804 SETXXXSTREAMS BROKEN IN THE 5.2 NET DRIVER IX87377 DASILIST LINK FROM /USR/LPP/DB2_05_00/INSTACE TO ~/BIN DELETED IX87362 OUTER JOIN WITH IN PREDICATE RETURN WRONG RESULT JR12809 MEMORY LEAK IN DB2JD.EXE ON NT (9084) IX87446 UDF NOT MAKING FINAL CALL WHEN IT TERMINATES ABNORMALLY IX87478 SQLUGRPI RETURNS SQLCODE=-6044 JR12819 IMPORT OF CLIENT PROFILE GIVES CCA3002 IX86353 FETCHES LOGGED IN AUDIT CAN GET TOO WORDY JR12414 IMPLEMENT VARIABLE TAPE BLOCK SIZE FOR INTEL PLATFORM IX86368 SQLJMF10 TRAPS WHEN NULL POINTER IS IN DB2RA JR12414 IMPLEMENT VARIABLE TAPE BLOCK SIZE FOR INTEL PLATFORM List of APARs that went into 461712f APAR No. Abstract -------- ------------------------------------------------------- IX86742 USERID CONTAINING "I" INCONSISTENTLY TRANSLATED WITHIN DB2 IX86987 SLOW INSERT PERFORMANCE ON NON-NUMERIC PARTITIONING KEY IX87048 INTERMITTENT SQL0290 JR12745 SQLBINDPARAM WITH LENGTH 0 USING SQLPUTDATA/SQLPARAMDATA. JR12788 CURRENTSQLID CAUSES CONNECTION TO TRAP TO DB2 / MVS JR12797 NULL INDICATOR NOT BEING RESET FOR JDBC APPS W/ NET DRIVER IX87376 IMPROPER CLEANUP WHEN SQLAOPTIONS FAIL WITH INVALID PREP OPTION IX87387 SCANNING CODE FOR A SELECT W/ OPTIMIZE FOR N ROWS & FOR FETCH O IX85687 IMPROVE DPS SO THAT THE DB2 HANDLES SQLOQQUE FAILURE BETTER. JR12797 NULL INDICATOR NOT BEING RESET FOR JDBC APPS W/ NET DRIVER JR12722 SQL1022C FROM DB2START DUE TO PERFORMANCE SMARTGUIDE SUGGESTION List of APARs that went into 461712e APAR No. Abstract -------- ------------------------------------------------------- JR12732 V5.2:SQL0956 / SQL1478 AFTER ALTERING V5GA BUFFERPOOLS JR12734 CCA IMPORT FUNCTION ONLY PICKS UP ONE INSTANCE PER SYSTEM JR12753 TRAP IN SQLCCCLOSEENTRIES<> IX86991 EXPORT NOT PARSING MODIFIED BY DELIMITERS PROPERLY IX87061 CORE DUMP WITH THDSRVER.SQC SAMPLE ON DB2CONNECT TO MVS JR12780 IXF IMPORT OF V1 DATA FAILS SYS3175 IN V52, WORKS V2 AND V50 JR12683 BACKWARD FIT OF DEFECT 97937 IX83002 PROBLEM WITH 95064 IX86031 'LIST HISTORY REORG SINCE' DOES NOT REPORT ALL VALID ENTRIES IX86457 DON'T IGNORE SIGUSR1 IN SNA/6000 V3 AND NEWER JR12689 CONTROL MSG CAUSED BY CONVERSION FILES WITH DIAGLEVEL JR12719 FILE_TRANSFER_CMD OF AUTOLOADER.CFG DOESN'T CALL A BATCH FILE. JR12747 JOB RESULT IN CC JOURNAL FOR SCRIPT CENTER JOB IS PARTIAL List of APARs that went into 461712d APAR No. Abstract -------- ------------------------------------------------------- IX86517 LOAD TRAPS IN BUILD PHASE WHEN UTIL HEAP IS FULL IX86940 DB2LOADREC DOES NOT WORK IF LOAD COPY IS MOVED IX83869 CATALOGING MORE THAN 8 ODBC DATASOURCES FROM SCRIPT GIVE ERROR IX86861 SETNULL TRAPS WITH TIMESTAMP,TIME,DATE,BIGINT AND STREAMS JR12745 SQLBINDPARAMETER() NOT HANDLING ZERO COLUMN SIZE CORRECTLY IX86901 JDBC EXECUTEQUERY() RETURNS NULL IX86966 REMOVE CHECK IN PROBE 70 OF SQLPWRITELR JR12546 NT RESTORE TRAP IX85558 DB2 STILL GETS DATA EVEN IF SQL_ATTR_RETRIEVE_RESULT IS OFF JR12669 SQLSTATE -1106 RECORDED IN DB2DIAG.LOG ON REMOTE IMPORT List of APARs that went into 461712c APAR No. Abstract -------- ------------------------------------------------------- IX85893 SQL0901 REASON SQLRINREC: FUTURE SHOCK IX86244 USE SQLOINSTANCEPATH() TO REDUCE CALLS TO PASSWORD FILE IX86413 SIG 11 TRAPS IN ERROR HANDLING AFTER SQLRXGET/PUT HIT PROBLEMS JR12731 DDL FOR CREATE TABLE INCORRECT WITH DBNAME IX84079 SQL0859 WHEN UNFENCED STORED PROCEDURE CALLED WITHIN DUOW IX85099 V5.2 GA CLIENTS TRAP WHEN MONITOR HEAP EXHAUSTS JR12614 DB2LOOK DOES NOT WORK AGAINST REMOTE DATABASES JR12618 SYS3175 ON OS/2 WHEN RUNNING A USER EXIT TO BACKUP JR12361 SQLPREPARE HOLDS LOCKS ON SYSTEM TABLES IX85441 IF LIBPATH IS LONG, REMOTE CONNECT WITH TCPIP RETURNS SQL10013 JR12646 OS/2: SQL1038C ON DB2START WHEN USING A FAT FILESYSTEM. JR12715 SQL0193N WHEN ADD A NEW NOT NULL COLUMN WITH DEFAULT AS BLANK List of APARs that went into 461712b APAR No. Abstract -------- ------------------------------------------------------- JR12594 V501:LOAD/IMPORT FROM ASC TO NOT NULL COLUMN IGNORES NULLINDCHR AND SQL3124W ON LOAD OF ASC FILE WITH PACKEDDECIMAL OPTION IX82027 IMPORT CAN CAUSE HANGS UNLESS YOU DO A CONNECT RESET IX84082 JAVA STORED PROCEDURE CAN ONLY RUN ONCE ON SOLARIS 2.6 IX84950 REMOVE EXPLICIT CALLS TO SET CURSOR_HOLD AND AUTOCOMMIT AS THES JR12613 CRASH RECOVERY PROBLEM: -2775, FFFFF42F. IX84935 EEE: DISTRIBUTED CLOSE FIX IMPROVE UPDATE PERFORMANCE IX85171 DB2 UDB V5.2 EE ON HP11 HAS POOR PERF. WHEN USEING LOAD UTILITY IX85342 SIGNAL #11 IN SQLRA_FIND_SHIP_VAR IX85415 DB2DCPIC_IBM.A NOT THREAD SAFE. IX85645 EXECUTEUPDATE RETURNING -1 FOR WHEN UPDATES IN THE JDBC NET DR. JR12673 INTERNAL TABLE FUNCTION TFNUMLINT AS A COMMON TABLE EXPRESSION JR12666 JR12666: AS/400 NUMERIC INCORRECTLY CONVERTED TO DECIMAL List of APARs that went into 461712a APAR No. Abstract -------- ------------------------------------------------------- IX85764 SELECT STOPS WORKING AFTER FIXPACK 3 ON NT, GETS -670 JR12355 LOAD ASCII METHOD L WITH BLOB RETURNS SQL3408W FOR WRONG COLUMN IX85192 SQL0902 RC 26 SQLO_NOMEM_UND IN SQLRIUIN IX85286 SQLPARAM DOES NOT WORK PROPERLY WITH DATA TYPES OTHER THEN CHAR List of APARs that went into U461712 APAR No. Abstract -------- ------------------------------------------------------- IX79991 CLI/ODBC ENHANCEMENT: REPLACING LITERAL WITH PARAMETER MARKER AND REMOVE EXTRA COMMITS (COMMIT ON RETURN MVS SP, CONNECT RESET) IX80640 DB2LOOK REVERSES DLL WHEN PK WAS CREATED ON EXISTING INDEX IX82054 SQL3326 USING DB2ATLD AND COLUMN NAME IS 18 CHARACTERS LONG IX82394 GETTING SQL6107 ON LOAD. DATA HAS BEEN PRE-SPLIT WITH DB2SPLIT. IX82487 SQL1042C ON BACKUP JR12353 RESTORE FROM MULTIPLE DISKETTES FAILS. UDB AND DB2 V2 JR12356 CACHING PROBLEMS ON on NT IX82599 DB2START MAY REMOVE MESSAGE Q 0 JR12267 ADDLLU MARKS THE ONLY LLU AS THE DEFAULT LLU JR12376 LARGE IN CLAUSE TRAPS ON NT WITH A STACK OVERFLOW EXCEPTION IX82970 SIG #11 IN SQLRIDESCRIBEINPUT IX82397 DB2BATCH -O R 0 DOES NOT WORK WITH BLOB OBJECTS JR12509 CLI LAYER CANNOT ACCOMODATE DATE AND TIME FORMAT FOR USA IX83660 ONLINE BACKUP RETURNS SQL2048N DURING MKTABLES WORKLOAD. JR12444 OUTER JOIN ESCAPE CLAUSE IX81525 SQLALLOCSTMT TRAPS DURING MEMORY CLEANUP AFTER OUT OF MEMORY JR12258 -418 WHEN MS ACCESS USES BETWEEN ? AND ? TO MVS IX81831 INDEX BUILD HANGS IX81849 SQLESETC API APPLIED TO WRONG CONTEXT IN MULTITHREADED CLI APP. JR12333 12/98:TRAP IN V5 SERVER FROM DWNLVL CAE/DOS V1.2 CLIENT IX82508 PATCH2=6 DOES NOT PREVENT A SCROLLABLE CURSOR TYPE IX82942 NODENUMBER IN THE ON CLAUSE OF A JOIN QUERY CAUSES A -901 JR12400 SQLGETDATA SUPPORT FOR 2 DIFFERENT DATA TYPES (1:SIZE; 2:DATA ) IX82992 CLI SQLCOLUMNS() RETURNS A COUNT OF ZERO COLUMNS IX83068 DB2AUTOLD LOOPS WHEN LANG=JA_JP JR12410 DB2 UDB TRAPS ON WINNT WHEN QUERY SEMENTICS INCORRECT ORDER BY JR12409 SQL_C_NUMERIC SUPPORT - PHASE I and PHASE II IX83063 NEGATIVEARRAYSIZEEXCEPTION ON EXECUTEQUERY() UPDATE JR12419 ADO: OFFSET PTR CAUSES TRAPS AND UNEXPECTED SQL_NEED_DATA RC IX83180 SQL0956C WHEN RUNNING DB2UIDDL OUTPUT. IX83197 DDB2ATLD MAY USE HOSTNAME FOR SOME COMMUNCATIONS JR12424 NULL INDICATOR NOT BEING RESET IX83238 MTS APPLICATION GET ACCESS VIOLATION IX83272 NEGATIVE RETURN CODE -502 CAUSES TRAP IN SQLJIFSR.C IX83355 LIST APPLICATIONS DOES NOT SHOW THE CORRECT NAME ON NT CLIENT. IX83441 ONLINE BACKUP PLACES IN LOCK ON TEMP TBS. IX83458 PREP RETURNS SQL4920N ON EXEC SQL CALL PROCNAME WITH IX83539 CREATE TABLE FAILS WITH -902 WHEN OUT OF DBHEAP IX83583 LOAD INSERT AFTER MIGRATION CAUSES TABLE CORRUPTION IX83547 LOCK WAIT - NS LOCK HELD ON SYSUSERAUTH CAUSES CATALOG LOCKING IX83555 XA_END FAILS WITH RC=XAER_PROTO WHEN XA_END(SUSPEND) IS INVOKED IX83616 QUERY REWIRTE USING VIEWS JR12452 MEMORY LEAK IN DB2CONNECT USING CLI APPLICATION TO HOST JR12467 UNINSTALL DOES NOT REMOVE OS2.OUT BLD.OUT COMP.OUT DIFF.OUT EXTRACT.OUT LC.OUT NOHUP.OUT NT.OUT PAC IX83716 TRAP IN SQLRAGSN WHEN EXPLICIT BIND IS INTERRUPTED IX83732 ROLLFORWARD TO A POINT IN TIME (PIT) GETS A -1042 AND SQLPRFLM SEG FAULT DUE TO ACB NOT PRESENT DURING RECOVERY IX83733 DB21080 - REDIRECT RESTORE IS CASE SENSITIVE TO DB ALIAS JR12473 SQL901 WHEN SELECT AGAINST A VIEW IX83781 SQL0344 WHEN TRYING A SELECT AGAINST VIEW,BASE TABLE DATE/COLM IX84179 DISTRIBUTION STATS CAUSING BAD JOIN PLAN IX83953 THE JDBC LISTENER SHOULD ONLY READ THE INDICATOR VARIABLE IF JR12625 FIX FOR 100GB EASTWOOD/BADGER 4 MLN AUDITED RESULTS SO WE DO NO JR12498 SQLEXECUTE DOES NOT INSERT ALL COLUMNS PROPERLY IX84081 12/98:TRAP IN SQE JR12508 SQL1026N FOLLOWED BY SQL1032N WHEN MANY DB2STARTS ISSUED JR12512 MEMORY ACCESS VIOLATION OR TRAP WITH MULTIPLE ENVIRONMENTS JR12541 REVERT TO WAITING FOR DELETES DURING INDEX SCANS IX84273 THE DB2BATCH TOOL SHOULD TRIM THE TRAILING BLANKS IN OUTPUT JR12538 FOR BIT DATA INSERT OF VARCHAR DOES NOT RETURN CHARACTERS IX84329 LENGTH OF THE OUTPUT SQLVAR IS NOT INITIALIZED. IX84478 TIMESTAMP TOSTRING() METHOD NOT WORKING PROPERLY IX84552 V5.2 CHOOSING MGJN PLAN OVER A NLJN THAT WAS CHOOSEN IN V500 IX84577 CLI0125E ON SQLSETCONNECTATTR IX76365 83177 CONT'D - ENHANCE SINGLE NODE JOIN PARTITION HANDLING AND SLOW PERFORMANCE ON A DB2 UDB EEE PLAN AND FIX 94984 - MISSING A SET OF BRAKETS IX84582 CLP LIST TABLESPACES SHOW DETAIL DOES NOT AUTO-COMMIT IX84565 WARNING SQL0437W CAUSES EXPORT TO FAIL FOR COMPLEX QUERIES. JR12563 HEX(DEGREE)=0X00 IN SYSPLAN AND -901 SQLRISIN DURING EXECUTION JR12569 SMART GUIDE ON NT DOES NOT SHOW MORE THAN 4GB ON SOLARIS JR12572 1) CALLING SQLM_DCS_APP_EXIT BEFORE SQLDBCON GETS FREED IX84760 NULL VALUES DISABLE INSERT BUF IX84780 DB2_ALL HANGS WHEN THERE IS INPUT REQUIRED BY USER IX84907 -3514 MESSAGES LOGGED IN DB2DIAG.LOG DURING LOAD EMPTY FILES IX84795 SQL0901N - SQLNQ_PID::BULDABLE_TREE(300):RC(0) JR12582 DB2 UDB V5.2 TRAPS WHEN THERE IS A TYPO WITH A SCALAR SUBSELECT JR12595 VENDOR: ALWAYS RETURN CATALOG SEPERATOR TO BE '.'LIKE PATCH2=11 IX84896 A PRE 5.2 DB2JAVA.ZIP NET DRIVER CONNECTING TO A 5.2 DB2JD IX84790 SQL10003C ERRORS DUE TO A MEMORY LEAK IX85243 DISABLE DB2ATLD -D IX85266 S LOCKS ON SYSTABLES DURING IMPORT/LOAD JR12505 TABLESPACE LISTING INCORRECT DURING TABLE COPY W/CONTROL CENTER IX84964 LOAD FAILS USING CONTROL CENTRE ON ITALIAN VERSION IX83002 NONRECOVERABLE LOAD CAUSES -1042 ON ROLLFORWARD JR12633 BY DEFAULT SQL_OUTER_JOINS = "Y" USING CAE VER 5.2 JR12634 CLI TO SEND DYNAMIC(NOT STATIC) CALL PROC STATEMENT TO AS/400. JR12649 GET SNAPSHOT FOR LOCKS -- CORRUPTED OUTPUT. JR12592 "SPM0438 THE DB2 SYNCPOINT MANAGER RECOVERY LOG IS BAD" FIX GG03794 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (OS/2) GG03796 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (OS/2) GG03798 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (OS/2) GG03808 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (OS/2) GG03810 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (OS/2) GG03825 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (OS/2) GG03822 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (OS/2) GG03839 APPLY DID AN UNEXPECTED FULLREFRESH (0S/2) GG03795 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (NT) GG03797 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (NT) GG03799 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (NT) GG03800 ASN1053E THE EXECUTION OF THE ASNLOAD PROGRAM FAILED RC6 (NT) GG03805 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (NT) GG03804 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (NT) GG03811 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (NT) GG03826 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (NT) GG03814 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (NT) GG03838 APPLY DID AN UNEXPECTED FULLREFRESH (NT) IX82922 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (AIX) IX83038 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (AIX) IX83041 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (AIX) IX83261 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (AIX) IX83847 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (AIX) IX83850 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (AIX) IX84120 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (AIX) IX84503 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (AIX) IX85653 APPLY DID AN UNEXPECTED FULLREFRESH (AIX) IX82923 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (HP10) IX83039 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (HP10) IX83042 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (HP10) IX83594 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (HP10) IX83848 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (HP10) IX83851 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (HP10) IX84562 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (HP10) IX84504 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (HP10) IX85654 APPLY DID AN UNEXPECTED FULLREFRESH (HP10) IX82924 IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL (SUN) IX83040 WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE (SUN) IX83043 APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (SUN) IX83595 APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (SUN) IX83849 PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY (SUN) IX83852 AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0 (SUN) IX84563 ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT (SUN) IX84505 SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS (SUN) IX85655 APPLY DID AN UNEXPECTED FULLREFRESH (SUN) GG03812 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (OS/2) GG03829 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (OS/2) GG03830 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (OS/2) GG03832 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (OS/2) GG03834 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (OS/2) GG03835 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (OS/2) GG03837 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (OS/2) GG03801 ASN1056E APPLY PASSWORD FILE COULD NOT BE OPENED - ERROR CODE IS 215601 (NT) GG03792 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (NT) GG03807 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (NT) GG03802 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (NT) GG03831 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (NT) GG03833 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (NT) GG03836 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (NT) GG03806 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (NT) IX83970 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (AIX) IX84867 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (AIX) IX84871 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (AIX) IX84898 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (AIX) IX85142 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (AIX) IX85196 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (AIX) IX85508 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (AIX) IX83969 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (HP10) IX84868 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (HP10) IX84872 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (HP10) IX84899 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (HP10) IX85143 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (HP10) IX85199 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (HP10) IX85509 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (HP10) IX82548 COLD START ENHANCEMENTS FOR SQLCODE964 (SUN) IX83968 IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG (SUN) IX84870 CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778 (SUN) IX84873 ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON (SUN) IX84900 CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED (SUN) IX85144 PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE (SUN) IX85200 ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP (SUN) IX85510 ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT (SUN) GG03803 SQLCODE407 - ASSIGNMENT OF A NULL VALUE TO A NOT NULL COLUMN IS NOT ALLOWED OCCURS WHEN WILD CARD CHARACTER NOT USED IN BUILDDB (NT) GG03813 PRUNING CONTROL ROWS GET DELETED IN V5 IF THE V1 SUBSCRIPTION HAS RUNMODE EI STATEMENTS THAT ARE OMITTED IN V1 TO V5 MIGRATION (NT) GG03821 ASN2769E SQLCODE518 - DPROPR MIGRATE PROGRAM FAILS WITH SQLCODE518 WHEN MIGRATING PRUNING CONTROL TABLE (OS/2) GG03819 SQLCODE407 WHEN MIGRATING CAPTURE FROM V1 TO V5 AND ABOVE (OS/2) GG03817 ASN2748E ASNMIG PREPARE ENDS UNSUCCESSFULLY (OS/2) GG03816 SQLCODE407 - ASSIGNMENT OF A NULL VALUE TO A NOT NULL COLUMN IS NOT ALLOWED OCCURS WHEN WILD CARD CHARACTER NOT USED IN BUILDDB (OS/2) GG03820 PRUNING CONTROL ROWS GET DELETED IN V5 IF THE V1 SUBSCRIPTION HAS RUNMODE EI STATEMENTS THAT ARE OMITTED IN V1 TO V5 MIGRATION (OS/2) List of APARs that went into U459872 APAR No. Abstract -------- ---------------------------------------------------------- IX67258 DB2 THINKS APPLICATION IS MULTI THREADED JR11049 OBSOLETE DBMON TCB'S LEFT AFTER DATABASE PAUSE JR11013 RESTORE VIA USEREXIT WITH DIFFERENT INSTANCE NAME FAILS JR11025 SQLPRIMARYKEY/SQLFOREIGNKEY LOCKUP SYSTABLES IN AUTOCOMMIT MODE JR11073 SQL0332N - CODEPAGE CONVERSION BETWEEN 500 AND 1275 IX71266 SQL10013 - ON SIXTH INVOCATION OF STORED PROCEDURE IX70033 SQLSETENVATTR WITH SQL_ATTR_OUTPUT_NTS NOT WORKING PROPERLY WHEN IT SET TO SQL_FALSE IX71104 DB2BATCH CORE DUMPS WHEN USING -CLI AND -O WITH P > 1 EX: DB2BATCH -D SAMPLE -F -O P 3 -CLI JR11261 DB2 COMMON SERVER - 'INTERSECT ALL' RETURNS TOO MANY ROWS. JR11296 MEMORY LEAK IN JDBC APPLICATION DRIVER WITH SETSTRING/GETSTRING IX72507 VARCHAR FIELD IS PADDED WITH @ SIGNS WHEN USING JDK 1.13 WITH NATIVE THREADS CONNECTION TO MVS IX71837 USING FOR BIT DATA AND NORMAL CHAR TYPES IN A MERGE JOIN LEADS TO INCORRECT OUTPUT. JR11337 SQL3401 SQLGIMP COBOL API DOES NOT IGNORE FILLER BYTES IX71996 LOAD INTO A TABLE ALIAS FAILS WHEN RETRIEVING COLUMN DEFAULTS JR11325 THE CLI ARRAY INPUT PROCESSING IS BROKEN WHEN A SQLVAR SPILLS THE REQUESTER IO BLOCK SIZE. IX72365 IMPORT .. OF DEL MODIFIED BY CHARDEL '' RETURNS SQL3017 FOR UDB, REGRESSED FROM V2 JR11319 OS2 V3 ODBC DRIVER NOT SUPPORTED BY V2 DRIVER MANAGER IX72390 DB2 UDB - WITH THE EVENT MONITOR ON MEMORY OVERWRITE OCCURS WITH SQL STATEMENTS > 4K. IX72451 RESTORING V2 BACKUP IN V5 PLACES MESSAGE IN DIAG FILE THAT TABLSPC 0 BUFF POOL 0 DOES NOT EXIST MAPS TO BUFFPOOL 1. IX72404 SQLOPENBPF PROBE 920 DURING BACKUP JR11344 CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE JR11363 CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE JR11374 SETNULL METHOD HANDLED INCORRECTLY FOR INPUT/OUTPUT PARAMETER JR11394 SQLPROCEDURE COLUMNS RETURNS COLUMNS IN THE WRONG ORDER JR11395 HIDE EXTENDED FETCH CAPABILITY IX73014 SQLCANCEL IN JDBC DOES NOT WORK AS IT IS SERIALIZED. IX73543 INDEX CORRUPTION AFTER V2 DB MIGRATED TO UDB AND ALTERING VARCHAR COLUMN LENGTH IX73231 QUERY WAS GETTING VERY BAD PERFORMACE IN A QUERY WHEN RUNSTATS FOR A TABLE WAS RUN WITH DISTRIBUTION. IX61374 CICS/6000 TERMINATES AFTER BAD XACLOSE USING DDCS/6000 IX71898 INCORRECT OUTPUT FOR FUNCTION LOG10 JR11388 CLP LOAD REPLACE (CODEPAGE 1252) WITH IXF FILE (CODEPAGE 850) BRINGS DOWN DB2 IN NT JR11724 SQL30082N RC=0 WHEN USING SECURITY SAME IN DB2 NODE DIRECTORY IX72787 WHEN NO DEACTIVATE COMMAND ISSUED BEFORE DB2STOP ON AN ACTIVATED DATABASE CAN LEAVE PAGE CLEANERS AND PREFETCHERS ORPHANED. IX73168 DB2 V5 EEE GA CODE. POINT IN TIME TABLESPACE RECOVERY PROBLEMS. JR11428 CLI0002W DATA TRUNCATED. SQLSTATE=01004 {SQLDRIVERCONNECT} WHEN CONNECT STRING IS LONGER THAN 254 CHARACTERS IX73249 OUTBOUND APPLICATION ID PROVIDED BY DB2 LIST DCS APPLICATIONS SHOW DETAIL IS IN INCORRECT FORMAT IX73564 INVALID USE OF PTHREAD_CLEANUP_PUSH() AS THREAD EXIT HANDLER. IX73443 LOAD LOGIC SHOULD BETTER HANDLE RCF FLAG VALUES IX73537 DB2 V5 EEE: ENABLE AUTOLOADER > 2 GIG FILE SUPPORT JR11471 SQL_ATTR_CONCURRENCY ATTRIBUTE INCORRECTLY SET TO READONLY FOR A FORWARD_ONLY CURSOR JR11483 DB2 UDB: DB2 OBJECTS DO NOT SHOW UP IN NT PERFORMANCE MONITOR WHEN THE DBM CFG PARAMETER INTRA_PARALLEL IS SET TO YES. IX73675 DB2AUTOLD DOES NOT HANDLE COLUMNS STARTING WITH 'MODE' CORRECTLY IX73768 V5 EEE VERSION OF DB2LN DOES NOT SUPPORT DB2 PE V1.2 JR11502 PATCH KEYWORD IN DB2CLI.INI TO OVERRIDE OTHER SETTINGS JR11508 DB2CONNECT TO SUPPORT LOCAL DATE IX74918 PERMISSION DENIED ON HA TAKEOVER ON THE PARTITION TAKING OVER JR11348 LOAD OF SOME IXF'S TRAPS JR11526 NLJN DOES NOT PRODUCE OPTIMUM ACCESS PLAN COMPAIRED TO V1 IX73986 DB2 AGENT LOOPS ON A SNA RECEIVE WAIT AFTER HOST RETURNS 'AGENT PERMINANT ERROR REPLY MESSAGE'. JR11535 JDBC DRIVER CLI0608E USING GERMAN CODEPAGE IX73998 MEMORY OVERWRITE DURING INDEX CREATION DUE TO VARIABLE NOT LARGE ENOUGH TO HOLD PACKED DESCRIPTOR VALUES IX74044 SIGNAL #11 WHEN LOADING IN TABLE WITH 304 COLUMNS IX74232 CANNOT MIGRATE INSTANCE TO V5 IF REMOTE DATABASES CATALOGED JR11562 V5 CLIENT SHOULD NOT USE DEFERRED PREPARE WHEN GOING TO V2 V2 SERVERS (TURN IT OFF) IX74491 ADD PATCH FOR NETSCAPE LIVEWIRE TO IGNORE THE PROCSCHEMA ARGUMENT JR11577 TRANSLATE FUNCTION RETURNS -901 ON KOREAN CHARS JR11593 CLI PARSING PROBLEM ON 'SELECT'. RETURNS -518. IX73248 WHEN DISABLEMULTITHREAD IS SET TO 0 IN THE DB2CLI.INI FILE THERE EXISTS A MEMORY LEAK IN THE SQO LAYER WHEN USING CLI JR11624 SQLROWCOUNT RETURNS INCORRECT VALUE (0) AFTER UPDATE JR11629 PATCH1=1 CAUSES COUNT(DISTINCT COL) TO FAIL. IX74895 CURSOR NOT CLOSED WITH SPECIALCOLUMNS CALL ON NON INDEX TABLES IX74896 V5 CLP INCORRECTLY SETS SQLERRD STRUCTURE TO ZEROS FOR SELECT IX74904 SQLDRIVERCONNECT PROMPTS WHEN UID AND PWD IN DB2CLI.INI JR11651 'DB2 PREP TARGET IBMCOB' GIVES UNPREDICTABLE RESULTS. IX75101 FAILURE IN SQLDIOSR - NO ROOM IN SPECIFIED PAGE FOR OBJECT ID IX75217 CLI PROBLEM WITH HY009 / S1009 IX75695 JDBC APPLICATION DRIVER SHOULD NOT FREE THE ENVIRONMENT IF IT IS GARBAGE COLLECTED JR11503 A CONTROL CENTER SCHEDULED BACKUP FAILS WITH SQL2040N-- INVALID DB ALIAS, ON NT. JR11316 THE UNINSTALL ON THE WINDOWS PLATFORMS REMOVES THE REGISTRY ENTR IES OF PRODUCTS THAT WE DID NOT INSTALL LIKE WALLDATA RUMBA JR11421 'REFERENCED MEMORY CANNOT BE READ' ERROR AS A RESULT OF LOOPING ON LOADLIBRARY/FREELIBRARY OF NT KERNEL DLL'S JR11722 INTERMITTENT DB2 TRAP IN FUNCTION SQLRIRETURNSUBSTRCSOBYTES OR SQLOFMBLK GG03680 APPLY HANGS AND GENERATES C00005 EXCEPTION GG03681 UPDATE TO CCD NOT REPLICATING CORRECTLY GG03690 APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITHOUT CONTROL SERVER GG03691 APPLY FAIL WITH ERRCODE 8C0101 SQLCODE104 SQLSTATE 42601 GG03693 APPLY CONSUMES TOO MUCH SYSTEM RESOURCES WHEN SLEEP_MINUTES IS 0 IC19729 ASNSERV.EXE WAS NOT SHIPPED WITH DATAJOINER FOR NT V210. GG03696 APPLY LOOPS WHEN LASTSUCCESS IS GREATER THAN 1 MONTH OLD FROM CU RRENT DATE GG03685 APPLY V5 IS NO LONGER HOLDING THE CRITSEC LOCK WHILE IT FETCHES THE CD ROWS - IT COMMITS AFTER IT GETS THE SEQUENCE NUMBERS GG03687 ASN1051E 4A5102 THE ONLY WAY TO EXIT FROM A GAP SITUATION WHEN USING INTERNAL CCD IS TO MANUALLY UPDATE DPROPR CONTROL TABLES IX72725 CORE DUMP RUNNING APPLY/HP AND ABEND IN APPLY/MVS GG03686 OF 26 SOURCE TABLES AND REPLICAS FOR UPDATE-ANYWHERE ONLY FIRST 20 TABLES ARE PROPAGATED - SQLCODE2038 MAY OR MAY NOT BE SEEN GG03692 WHEN A LARGE OBJECT OCCURS IN THE BASE TABLE AND IS NOT REGISTERED , CAPTURE FAILS WITH PROTECTION FAULT GG03695 CPU RESOURCE UTILIZATION IS TOO HIGH FOR NT PLATFORM GG03694 CPU RESOURCE UTILIZATION IS TOO HIGH FOR OS/2 PLATFORM IX72517 AN ALTER ADDED TIMESTAMP CAUSES SQLCODE180 IX75150 CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS IX75933 OF 26 SOURCE TABLES AND REPLICAS FOR UPDATE-ANYWHERE ONLY FIRST 20 TABLES ARE PROPAGATED - SQLCODE2038 MAY OR MAY NOT BE SEEN IX75151 CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS IX74453 CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS JR11568 ASN2703E SQLCODE1001E DURING MIGRATION OF CAPTURE FROM V1 TO V5 INCORRECT CONNECT TO LOCATION NOT DB ALIAS DURING BUILDDB IX71439 LOOPING FENCED UDF NOT CLEANED UP JR11208 TRAP AFTER MANY SEQUENTIAL BACKUPS IX72460 DB2ADUTL DOES NOT USE THE ADSM PASSWORD SET WITH DSMAPIPW IX72350 TRIGGERS IN A SUBQUERY PREVENT OPTIMIZER FROM REWRITING SUBQUERY AS A JOIN. IX72697 PROGNAME VARIABLE CAUSES LINKER MESSAGES IX73445 ONLY LOG SEVERE ERRORS IN SQLDLOADTCBOBJDESC JR11417 ROW DATA BEING SENT WITH SQL100 CONFUSES DRDA AR WHEN CONNECTING TO DB2 ON OS/2 AS THE DRDA AS JR11422 DB2STOP HANG AFTER A FORCE APPLICATION ALL WITH ACCESS FEATURE. JR11433 LOG CORRUPTION WITH '504' MESSAGES IN DB2DIAG.LOG FILE IX68617 RESTORING DB2/6000 V2.1 DATABASE (WITH RAW DEVICE CONTAINERS) TO NEW AND GETTING DB2DIAG.LOG ERRORS WITH THE CONTAINERS. JR10975 LOAD TABLE FROM AN IXF ENCOUNTERED -3314N IX73368 DB2BATCH IN V5 (EVEN WITH FIRST FIXPACK) APPLIED RETURNS INCONSISTENT TIMING SUMMARIES WHEN MULTIPLES STATEMENTS ARE USED IX73417 DB2 UDB SQL1090 ERROR MESSAGE IS MISLEADING. JR11585 PROBLEM WITH LIST APPLICATIONS SHOW DETAIL - CHANGE STATUS TIME IX73875 SELECT CAUSES THE UDB INSTANCE TO GO DOWN JR11547 BACKUP TO ADSM SENDING WRONG OBJNAME.LL FROM UNINITIALIZED SQLU_MEDIA_ENTRY STRUCTURE(POINTED TO BY MEDIA_LIST.TARGET.MEDIA IX74523 SQR NOT MAPPING INTERNAL ERROR TO CLP CORRECTLY IX74524 LIST APPL. CMD FAILED AFTER TWO SUCCESSFUL CONCURRENT LOADING IX74582 INCORRECT OUTPUT IN LIST RECOVERY HISTORY FOR 'Q' OPERATION IX73521 DB2 UDB: DB2START RESULTS IN SQL1092N WHEN INSTANCE OWNER ID ON AIX HAS LOGIN=FALSE OR RLOGIN=FALSE IX74848 DB2STOP DOES NOT STOP ON LARGE NUMBER OF NODES - TIMES OUT IX75047 DB2LOOK FAILS WITH SQL0811 JR11647 MEMORY LEAK IN ODBC/CLI LAYERS IN 9014 FOR NT IX74915 ON AN SMP SOLARIS DB2 UDB, CONCURRENT LOADS RESULTS SQL1224. IX75587 PERFORMANCE DEGRADES GOING FROM COMM_BANDWIDTH 1 TO 100 IX75630 RECEIVE SQL0502 WHEN GOING TO A V2 DATAJOINER BECAUSE OF CHAINED AUTOCOMMIT IX75640 CREATE NODEGROUP RECEIVES -901 FROM SQLRKANG_CBP_I - FFFFFA604 IX72355 A TRAP WITHIN A STORED PROCDURE IN SQLE_MRSP. DB2SYSC CORE DUMP IX73136 A PASSWORD DEFINED WITHIN NIS+ WITHIN SOLARIS CANNOT BE AUTHENTI CATED BY DB2 JR11043 CONNECT TO HOST HANGS WHEN USING SYNCPOINT TWOPHASE JR11497 CONTROL CENTER DISAPPEARS ON CLICKING 'FIND' - ARABIC CODEPAGE JR11677 TRYING TO ADD A NEW SYSTEM IN CC WITH NO INSTANCES CRASHES JR11390 SQL2015 ERROR IS RETURNED WHEN CUSTOMER TRIES TO ISSUE 'CONTINUE RESTORE' V1 REXX API AFTER 'RESTORE ...' API RETURNS A WARNING. IX76273 DB2 UDB - LOAD HANGS WHEN DMS TABLESPACE FILLS UP IX76624 DB2/EEE V500 ON AIX. SIGNAL #11 IN BUFFER POOL SERVICES. JR11638 CUSTOMER CAN CONNECT FROM A V5 CLIENT TO A V2.1.2 DB WITH NO PROBLEMS. CUST RECEIVES SQL1402 WHEN ATTEMPTING A REMOTE ATTACH. IX74997 LOG FILES NOT ARCHIVE AFTER CRASH RECOVERY. JR11553 FLOATING POINT DATA TYPE RETURNS WRONG VALUE IX74229 REMOVING TRAILING PERIOD FROM DECIMAL TO CHAR. IX74969 DB TAPE RESTORE VIA CONTROL CENTER FAILS WITH SQL2042W I/O ERROR 2060 IX74540 CUST CAN'T RUN SCRIPT STORED ON SERVER FROM SCTRIPT CENTER USING RUN NOW ... OPTION. GG03707 SQLCODE206 WHEN COPYING TO CCD GG03699 SQLCODE206 WHEN COPYING TO CCD GG03700 MAX_SYNC_MINUTES VALUE OF ZERO OR LESS MEANS NULL GG03701 POSSIBLE MISSING DELETE UPDATES WHEN MORE THN 100 T GG03702 SUPPORT 18 BYTE COLUMN NAME WHEN BEFORE_IMG_PREFIX I GG03703 LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED GG03704 ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED B IX74529 APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITH IX76735 MAX_SYNC_MINUTES VALUES OF ZERO OR LESS MEANS NULL JR11484 INTERMITTENT TRAP IN SQLUBINITPROCESS DURING BACKUP JR11810 UDB NT TAPE RESTORE RETURNS SQL2530 -- IMAGE CORRUPT. IX74871 IN LOCK WAITS FOR X LOCK IX76127 DB2 RESTART DATABASE FAILS WITH SQL1042 DUE TO -4015 IX75242 ROLLFORWARD TO PIT OF A TABLESPCE RECIEVED A -1042 SQLCODE IX75463 INCORRECT NODE NUMBER IN BACKUP NAME IN ADSM IX75609 LIST APPLICATIONS CORRUPTS APP ID FOR LONG APP NAMES IX75642 DB2 RESTART FAILS AFTER HITTING EOF ON BUFFER POOL FILE(S) - FFF FF609 IX76438 ALTER TABLE RESULTS IN SQL902,126 ON DB2 UDB IX75688 DB2 SHOULD USE 'LSATTR' COMMAND TO DETERMINE MEMORY IN AIX IX75687 UNABLE TO RESTORE FROM A BACKUP TO ADSM USING MULTIPLE OPEN SESSIONS. IX75909 DB2 BRINGS DOWN INSTANCE AFTER A DYNAMIC SQL DOES NOT CLEAN UP P ACKAGES IX75945 IGNORE SQL0000W GENERATED BY POWER BUILDER APPLICATION AFTER CLI0165E ERROR 'ERROR IN ROW' IS DISPLAYED BY APPLICATION. JR11726 SPORADIC TRAPS IN SQLNQ_TABSEL_OFN_CM JR11737 DSN FIELD TRUNCATED TO FIRST LETTER IN CLI CONNECTION STRING JR11741 UNABLE TO IMPORT A CLIENT CONFIGURATION WITH CLIENT CONFIGURATIN ASSISTANT (CCA) IX76159 DB2 AUTOLOADER DOES NOT WORK WITH DUMPFILE OPTION ON MLNS IX76172 STATEMENT OBJECT CREATED BY GETBINARYSTREAM IS NOT GETTING CLOSED IX76236 SIGNAL #11 IS SQLRLLPD WHEN DROPPING TABLESPACE AND THERE ARE AND A LARGE NUMBER OF TABLES (OVER 6000) JR11763 ERROR IN CCA WHEN PRESS 'ENTER' INSTEAD OF USING MOUSE JR11773 SQL0437W CAUSES OPEN IN DEFERREDPREPARE TO BE OMITTED IX76443 PERFORMANCE PROBLEM OF A SELECT WITH AN ORDER BY JR11834 ASYNCRONOUS READ REQUESTS AND ISSUEING INTERRUPTS. IX77873 V5 FIX FOR V2 APAR IX76471. PERFORMANCE ENHANCEMENT FOR INSERT/ UPDATE BY IMPROVING FREE SPACE CONTROL MAP SCANS. IX76678 SQL1042 ON GET SNAPSHOT FOR APPLICATIONS ON SOLARIS 2.5.1 WITH SUN PATCH 104283 OR SOLARIS 2.6 JR11802 LARGE SQL STATEMENT USING DEFAULT AGENT_STACK_SZ =16 CAUSES STAC K OVERFLOW EXCEPTION ON NT IX77137 RUNSTATS WITH DISTRIBUTION PICK INCORRECT PLAN JR11818 DISABLEMULTITHREAD=1 IS NOT READ FROM DB2CLI.INI JR11821 WHEN SQL_ROWSET_SIZE>1, SQLGETDATA REPORTS INVALID CURSOR POS. IX76922 KEYWORD DATALINK IX76924 STAR JOIN DISQUALIFIED FOR STAR JOIN ELIGIBLE QUERY JR11824 TRAP IN DOSCALL1.DLL DURING CTRL-C IX77399 CRASH RECOVERY ENDS TOO EARLY. IX77067 SUN BACKING OFF FIXPAK #3 AND USING DB2IUPDT CAUSES FATAL ERROR DUE TO INCOMPATIBLE LEVELS OF CODE JR11841 SQL_OJ_CAPABILITIES DOES NOT RETURN THE PROPER INFORMATION IX77154 OUTER JOIN IN LIST PREDICATE OPTIMIZER PROBLEM IX77398 CANNOT BACKUP TO MVS TAPES VIA CLIO/S BECAUSE UDB WILL NOT ALLOW A BACKBUFSZ OF 8 IX77400 SQL.H MISSING SQL_QUERYOPT CONSTANTS FOR 2 AND 7 IX77480 DIAGNOSTIC CODE FOR NLI SITUATIONS AND BPS PROBLEMS IX77409 NIS CHECK FAILS DURING INSTALL OF ADMIN SERVER IX77439 SQL30081N ON SECOND CONNECT THROUGH SYSPLEX SERVER IX77672 INDEX CORRUPTION AFTER MIGRATING TO V5 IX77494 DB2 UDB LOAD COMMAND USING 'MODIFIED BY DUMPFILE' AND CPU PARALLISM > 1 RESULTS IN AN INCOMPLETE DUMPFILE. IX77672 DB2DART CHANGES FOR C. MCARTHUR'S INDEX TOOL IX77776 ON INDEX REBUILD SQL0404 DUE TO INCORRECT INDEX PACKED DESCRIPTOR UPDATE AFTER ALTER COLUMN IX77703 SQL1478W ON CONNECT AFTER ALTER BP AFTER FP3 IX77706 DB2START.PROCID.DAT FILES NOT BEING REMOVED FROM FILESYSTEM. THESE FILES ARE GENERATED FOR EVERY DB2START. JR11773 SQL0437W CAUSED OPEN FUNCTION TO BE SKIPPED IN DEFE JR11904 CHECK FOR IP ADDRESS BEFORE HOSTNAME FOR WIN95 TCP/IP JR11914 MIGRATING V211 DATABASE FAILS WHEN TRYING TO CONVERT HIGH2KEY AN D LOW2KEY VALUES IX78176 DB2LOOK DOES NOT EXTRACT TABLESPACE INFORMATION FOR TABLESPACES WHICH HAVE NO TABLES DEFINED WITHIN THEM IX78232 SQLBRESERVEFILETOKEN IN DB2DIAG.LOG FID TIMING PROBLEM JR11928 DB2 CONNECT HAS INTERMITENT PROBLEM LOGGED IN THE DB2DIAG.LOG: GATEWAY_DRDA_AR SQLJDRD1 PROBE:11, DIAGDATA = 34FF FFF JR11727 SQLCODE612 WHEN SUBSCRIBING TO A TABLE WITH A COLUMN NAME GREATER THAN 17 CHARACTERS OR SQLCODE107 JR11728 CONTROL CENTER LOCKS UP EXPANDING NODE OR DATABASE OBJECTS ON OS2 WARP SMP MACHINES. JR11760 THE UDB CONTROL CENTER HAS NO WAY TO SPECIFY S TO INDICATE THAT SQL BEFORE SHOULD BE RUN AT THE SOURCE SERVER JR11861 CONTROL CENTER CONNECTS TO CONTROL SERVERS OF SUBSCRIPTION SETS ORIGINATING FROM THE SOURCE DATABASE AND NOT ALL SERVERS JR11870 JOIN OF FULL REFRESH REPL. SOURCE DOESN'T CREATE NEW SOURCE IX77979 APPLY MAY COPY UNCOMMITED DATA JR11899 CAN'T VIEW OR SET CURRENTSQLID FROM CLIENT SETUP GUI IX77572 RECYCLING SCRIPT CENTRE DOESN'T ALLOW MORE SCRIPTS TO BE RUN JR11878 USER COUNTS GET MESSED UP WHEN THEY EXCEED THE MAXIMUM NUMBER JR11917 SQLCOLUMNS DOSE NOT RETURN COLUMN_DEF IX78479 BAD RETURN CODE FROM SQLOSSEMACCESS BRINGS INSTANCE DOWN IX78334 SQL0104 NOT BEING HANDLED PROPERLY IX78499 NUM_AGENTS IS INCORRECT ON LONG RUNNING SYSTEM IX78509 MEMORY LEAK IN SQLRKAIN() WHEN DOING AN IMPORT WITH -973 JR11953 SAP ARRAY INSERT TRAPS JR11917 SQLCOLUMNS DOES NOT RETURN DEFAULT DATA IX78555 IFOR_LS.CLIENT.BASE REQUISIT MISSING ON AIX 4.3 IX77770 SQL1704N RC=8 ON DATABASE MIGRATION FROM DB2 V2 TO V5 ON HP-UX IX73249 TWO SPM FIXES FOR V5.2 BETA AND V500 JR11597 6/98: RETROFIT FIXES FOR 81188 INTO FIXPAK RELEASE GG03725 DPROPR CAPTURE, STL CMVC LEVEL GG00888 JR11940 MVS GRAPHIC() COLUMN INCORRECTLY MAPPED TO UDB UDB CHAR() IX78558 DPROPR APPLY, STL CMVC LEVEL PQ16105 JR11917 DPROPR DOESN'T RECOGNIZE COLUMNS DEFINED WITH DEFAULT JR11958 CC CRASHES WHEN CHANGE SYSTEM WITH SYSTEMNAME > 21 CHARS IX78463 DPROPR CAPTURE, STL CMVC LEVEL GG03708.4 JR11498 V501 SQL2503N FROM DB2RESDB RESTORING V1 DATABASE TO V5 GG03707 SQLCODE206 WHEN COPYING TO CCD GG03709 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION GG03711 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY GG03713 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING GG03715 APPLY MAY COPY UNCOMMITED DATA GG03717 (APPLY FOR OS/2) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT GG03718 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED GG03720 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD GG03722 (APPLY FOR OS/2) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS GG03723 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET GG03724 MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL GG03731 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH GG03734 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE GG03699 SQLCODE206 WHEN COPYING TO CCD GG03700 MAX_SYNC_MINUTES VALUE OF ZERO OR LESS MEANS NULL GG03701 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET GG03702 SUPPORT 18 BYTE COLUMN NAME WHEN BEFORE_IMG_PREFIX IS SPECIFIED GG03703 (APPLY FOR NT) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT GG03704 (APPLY FOR NT) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS GG03710 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION GG03712 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY GG03714 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING GG03716 APPLY MAY COPY UNCOMMITED DATA GG03719 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED GG03721 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD GG03732 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH GG03735 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE IX74529 (APPLY FOR AIX) APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITHOUT CONTROL SERVER SPECIFIED IX76735 MAX_SYNC_MINUTES VALUES OF ZERO OR LESS MEANS NULL IX77970 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION IX77973 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY IX77976 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING IX77979 APPLY MAY COPY UNCOMMITED DATA IX78127 (APPLY FOR AIX)LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT IX78163 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED IX78166 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD IX78169 (APPLY FOR AIX) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS IX78183 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET IX78558 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH IX78760 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE IX77971 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION IX77974 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY IX77977 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING IX77980 APPLY MAY COPY UNCOMMITED DATA IX78128 (APPLY FOR HP) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT IX78164 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED IX78167 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD IX78170 (APPLY FOR HP) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS IX78184 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET IX78186 MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL IX78559 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH IX78761 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE IX77972 NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION IX77975 ADD DELAY(N) INVOCATION PARAMETER FOR APPLY IX77978 SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING IX77981 APPLY MAY COPY UNCOMMITED DATA IX78130 (APPLY FOR SUN) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT IX78165 APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED IX78168 SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD IX78171 (APPLY FOR SUN) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS IX78185 POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET IX78187 MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL IX78560 APPLY FAILED WITH SQLCODE803 DURING FULLREFRESH IX78762 APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE GG03698 (CAPTURE FOR OS/2) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED GG03726 (CAPTURE FOR OS/2) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION GG03729 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS GG03697 (CAPTURE FOR NT) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED GG03708 LONG VARCHAR SUPPORT GG00888 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS GG03725 (CAPTURE FOR NT) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX75332 (CAPTURE FOR AIX) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED IX77129 LONG VARCHAR SUPPORT IX78408 (CAPTURE FOR AIX) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX78463 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS IX75975 (CAPTURE FOR HP) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED IX78409 (CAPTURE FOR HP) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX78464 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS IX75976 (CAPTURE FOR SUN) INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCPOINT ADVANCED IX78410 (CAPTURE FOR SUN) CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION IX78465 CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS JR11735 NETBIOS LOOPS WHEN MAXNBSESSIONS IS REACHED IX76914 OVERTYPING ODBC DATASOURCE IN "CONNECTING TO DB2 DATABASE" TRAPS JR11905 SQLNUMRESULTCOLS RETURNS FUNC SEQ ERR AFTER TIMEOUT IX78630 SQLNUMRESULTCOLS() CAUSES SQLEXECUTE() TO GET SQL0301N, 07006 JR11972 JDBC METADATA GETTABLES RETURN NULLPOINTEREXCEPTION JR11981 STATIC CURSOR DOES NOT RETURN PROPER INFORMATION IX78836 ALTER TABLE ... NOT NULL DEFAULT CURRENT TIMESTAMP FAILS -193 IX78903 ARRAY INPUT FOR BLOB COLUMN INSERTS WRONG DATA IX78981 AUTHID NOT FILLED IN ACB CP OF AUTHINFO 4 INTRMDRY IN 2HP SCN IX79090 CHECK IN PROPER VERSION OF SIGNAL HANDLER IN JDBCSERVER.C IX78760 DPROPR APPLY, STL CMVC LEVEL PQ16384 JR11990 JOURNAL ALERT DATES NOT SORTING PROPERLY JR11999 EVENT ANALYZER TIME INCORRECT WHEN NT TIME IS GMT JR11952 THIN CLIENT INSTALL TO LOOK FOR ODBC FILES IN THE CUR. DIR. IX78710 EXPORT OF 167 MILLON ROWS RETURNS SQL2003 JR12040 TRAP IN SQLNO_FINAL_PHASE EXECUTING QUERY JR11872 CS ISOLATION ALLOWS UNCOMMITED READ ACCESS WITH W LOCK ON ROW. IX78975 LOAD FAILS WITH -911 RC=68 WHEN TIMEOUT = 10S JR12072 LEFT OUTER JOIN RETURNING WRONG RESULTS IX78963 INCORRECT QUERY RESULTS WITH STAR JOIN IX79235 INTERMITTENT SIGNAL 11 IN SQLULUMW JR12067 HOST VARIABLES WITH NAME LONGER THAN 18 CAN GET VALUE CLOBBERED JR12070 MEMORY LEAK IN DB2SYSC WHEN BPS INITIALIZATION (SQLBINIT) FAILS IX79301 RETROFIT 83898 TO DB2_V500 JR12093 FILTER FACTOR OFF AND NO FREQUENCY STATS ON VARCHAR COLUMN IX79867 CONNECTION TERMINATED AFTER -911, RETROFIT D83085 JR12010 GPF IN JOUNAL ON NT VIEWING JOB HISTORY FILE FROM LOAD JR12035 OPTIONS DROP AND REMOVE TRANSLATED WRONG INTO SPANISH IX79591 DPROPR APPLY, STL CMVC LEVEL PQ17223 JR12005 INTERMITTENT TRAP IN SQLODUMPEDU IX76680 SAMPLE JAVA STP RETURNS SQL10012 ON SUN sample java stp returns sql10012 on SUN IX74116 SAP: PATCH LF CORRUPTION BUG WITH DISK_PARALLELISM. JR11921 \n CHARACTER CAUSES SQL0518 WHEN BEFORE/AFTER SELECT KEYWORD IX79865 CLI0602E MEMORY ALLOCATION ERROR IN JDBC NET DRIVER WITH CLOBS IX76680 DEFINE SQLEJ_DB2JEXT_JVMSTOP IN SQLEJAVA.H ON ALL PLATFORMS GG03725 ISSUE WARNING FOR TABLE W/BEFORE-IMAGE AND 18-BYTE COLUMN NAMES JR12038 SQl4414 FOR LOCAL OPERATIONS IN CC WHEN ADMIN INSTANCE ACTIVE. IX80098 JOURNAL JOB HISTORY TIMESTAMPS GET OUT OF SYNC JR12007 JR12007: SQLCODE100 UDB DOESN'T INITIALIZE PHYS_CHANGE_OWNER JR12000 MULTITHREADED APPLICATIONS TRAP IN UDB AND HOT: TRAP WITH INVALID STMT HANDLE IX79213 LOADING TABLE HANGS INTERMITTANTLY IX80087 HOT:INCORRECT RESULTS RETURNED FROM AN SQL QUERY AFTER RUNSTATS IX78867 DB2 SHOULD NOT ACCEPT FORCE EXPIRED PASSWORDS IN NON-AIX UNIX IX77572 AIX: PROBLEM WITH RUNNING A SCRIPT NOW AFTER SCHEDULED JOB IS R JR12032 BUG CAUSING SQL1109 WHEN SPECIFYING A SCHEMA IN THE CALL STMT JR12169 MIGRATION OF THE NODE DIRECTORY FAILED JR12143 HOT :MEMORY LEAKS ON NT AFTER DISCONNECT JR12220 LOAD DOES NOT ALLOW CHARACTER DELIMITING AS A PRIORITY. JR12227 BEFORE SELECT IS CAUSING SQLEXECDIRECT TO FAIL JR12240 DEFECT 83823 BREAKS EXECUTION OF STORED PROCEDURES ON NT, OS/2 IX79292 SIGNAL #11 IN DB2LRID WHEN LOAD TERMINATES IX79456 12/98 FORCE APPLICATION CRASHES DB2 WHEN BUFFERED INSERTS IX81832 -902 ON SET EVENT MONITOR COMMAND IX81761 IF DB2AUTOLD FAILS, IT STILL RETURNS A 0 RC TO THE SHELL IX81764 DB2ATLD DOES NOT RETURN NON-ZERO RC EVEN IF IT FAILS IX81766 SQL6534 WITH DB2AUTOLD AND RESTART B/D AND NO .NETRC FILE GG03737 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (OS/2) GG03739 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (OS/2) GG03741 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (OS/2) GG03743 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (OS/2) GG03745 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (OS/2) GG03747 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (OS/2) GG03756 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (OS/2) GG03758 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (OS/2) GG03766 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (OS/2) GG03768 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (OS/2) GG03772 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (OS/2) GG03774 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (OS/2) GG03781 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (OS/2) GG03783 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS (OS/2) GG03785 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (OS/2) GG00944 THE FIRST POSITIONAL PARAMETER OF THE ASNAPPLY COMMAND (OF DB2 UDB DPROPR) IS CASE SENSITIVE IN THE WINDOWS/NT ENVIRONMENT. (NT) GG03738 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (NT) GG03740 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (NT) GG03742 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (NT) GG03744 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (NT) GG03746 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (NT) GG03748 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (NT) GG03757 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (NT) GG03759 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (NT) GG03760 MOBILE REPLICATION BETWEEN UDB PERSONAL WINDOWS 95 AND UDB ENTERPRISE EDITION AIX - CONTROL TABLES ARE ON AIX MACHINE (NT) GG03767 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (NT) GG03769 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (NT) GG03773 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (NT) GG03775 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (NT) GG03782 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (NT) GG03784 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (NT) GG03786 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS. (NT) IX79591 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (AIX) IX79598 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (AIX) IX79601 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (AIX) IX79604 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (AIX) IX79607 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (AIX) IX79616 ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION. (AIX) IX79623 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (AIX) IX80372 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (AIX) IX80375 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (AIX) IX80916 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (AIX) IX81241 ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG (AIX) IX81262 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (AIX) IX82113 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (AIX) IX82129 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (AIX) IX82233 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (AIX) IX82289 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (AIX) IX82301 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS (AIX) IX79593 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (HP) IX79599 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (HP) IX79602 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (HP) IX79605 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (HP) IX79608 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (HP) IX79627 ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION. (HP) IX79624 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (HP) IX80373 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (HP) IX80376 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (HP) IX80917 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (HP) IX81263 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (HP) IX81265 ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG (HP) IX82114 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (HP) IX82134 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (HP) IX82291 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (HP) IX82295 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (HP) IX82302 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS (HP) IX79595 SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER (SUN) IX79600 APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED (SUN) IX79603 SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION (SUN) IX79606 EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED (SUN) IX79609 APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE. (SUN) IX79628 ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION. (SUN) IX79625 APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER (SUN) IX80374 APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED (SUN) IX80377 APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0 (SUN) IX80918 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804 (SUN) IX81264 APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS (SUN) IX81266 ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG (SUN) IX82115 SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911 (SUN) IX82135 SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS (SUN) IX82292 SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER (SUN) IX82296 APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060. (SUN) IX82303 APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS (SUN) GG03751 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (OS/2) GG03753 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (OS/2) GG03761 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (OS/2) GG03762 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (OS/2) GG03777 RETENTION LIMIT PRUNING OF UOW TABLE (OS/2) GG03779 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (OS/2) GG03790 COLD START ENHANCEMENTS FOR SQLCODE964 (OS/2) GG03750 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (NT) GG03754 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (NT) GG03763 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (NT) GG03764 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (NT) GG03778 RETENTION LIMIT PRUNING OF UOW TABLE (NT) GG03780 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (NT) GG03791 COLD START ENHANCEMENTS FOR SQLCODE964 (NT) IX80084 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (AIX) IX80301 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (AIX) IX80618 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (AIX) IX80800 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (AIX) IX81782 COLD START ENHANCEMENTS FOR SQLCODE964 (AIX) IX82123 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (AIX) IX82210 RETENTION LIMIT PRUNING OF UOW TABLE (AIX) IX80130 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (HP) IX80315 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (HP) IX80739 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (HP) IX80801 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (HP) IX82239 RETENTION LIMIT PRUNING OF UOW TABLE (HP) IX82243 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (HP) IX82547 COLD START ENHANCEMENTS FOR SQLCODE964 (HP) IX80131 SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR) (SUN) IX80317 CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT (SUN) IX80740 SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES (SUN) IX80802 VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311 (SUN) IX82240 RETENTION LIMIT PRUNING OF UOW TABLE (SUN) IX82245 WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS (SUN) GG00969 MIGRATION TOOL CANNOT RUN ON WINDOWS 95 & 98 ASNMIG FAILS DURING MIGRATION OF MVS DPROPR FROM V1.2.1 TO V5 (NT) GG03755 ASN2769E SQLCODE518 - DPROPR MIGRATE PROGRAM FAILS WITH SQLCODE518 WHEN MIGRATING PRUNING CONTROL TABLE (NT) GG03776 SQLCOD407 WHEN MIGRATING CAPTURE FROM V1 TO V5 AND ABOVE (NT) GG03787 ASN2748E ASNMIG PREPARE ENDS UNSUCCESSFULLY (NT) JR09992 RESTORE OF ONLINE BACKUP THROUGH DB2DD FAILS WITH SQL1261N JR11528 V501: DB2CC DOES NOT DISCONNECT USERS FROM (REMOTE) INSTANCE. JR11532 CCA DOES NOT ACCEPT UNDERSCORE IN TCP/IP HOSTNAME JR11597 DEFAULT BROWSER DOES NOT RECOGNIZE INTERNET EXPLORER JR11727 JR11727: FIX FOR APAR, PMR #22398 JR11728 6/98:CONTROL CENTER LOCKS UP EXPANDING NODE OR DATABASE OBJECTS JR11760 JR11760: DCR21010 SUBS_COLS='S' SUPPORT JR11861 JR11861: SUPPRESS SUBSCRIPTION ACTIVATE QUERY FOR OS/390 JR11870 JOIN OF FULL REFRESH REPL. SOURCES DOES NOT PRODUCE NEW SOURCE IX77979 DPROPR APPLY, STL CMVC LEVEL PQ15438 IX78344 UPDATE CONNECT SMARTGUIDE WILL NOT ALLOW .FOR TCPIP HOST NAME JR11940 MVS GRAPHIC() COLUMN INCORRECTLY MAPPED TO UDB CHAR() IX78558 DPROPR APPLY, STL CMVC LEVEL PQ16105 JR11917 DPROPR DOESN'T RECOGNIZE COLUMNS DEFINED WITH DEFAULT JR11958 CC CRASHES WHEN CHANGE SYSTEM WITH SYSTEMNAME > 21 CHARS IX78463 DPROPR CAPTURE, STL CMVC LEVEL GG03708.4 IX78760 DPROPR APPLY, STL CMVC LEVEL PQ16384 JR12010 GPF IN JOUNAL ON NT VIEWING JOB HISTORY FILE FROM LOAD JR12038 SQL4414 FOR LOCAL OPERATIONS IN CC WHEN ADMIN INSTANCE ACTIVE. JR12035 OPTIONS DROP AND REMOVE TRANSLATED WRONG INTO SPANISH. IX79247 CANNOT RESTORE NEW DB FROM BACKUP WITH DIFFERENT NAME WITH CC IX79591 DPROPR APPLY, STL CMVC LEVEL PQ17223 JR12007 JR12007: SQLCODE100 UDB DOESN'T INITIALIZE PHYS_CHANGE_OWNER IX80084 DPROPR CAPTURE, STL CMVC LEVEL IX80301 JR12172 CONTROL CENTER ALLOWS UPDATE OF SUBSCRIPTION STATUS 2 JR12273 INCORRECT "MASTER" TABLE CHOSEN IN VIEW-REPLICA SCENARIO IX82210 DPROPR CAPTURE, STL CMVC LEVEL IX82210 IX82233 DPROPR APPLY, STL CMVC LEVEL PQ19014 JR10324 DB2 BACKUP NOT FREEING ALL MEMORY AFTER OPERATION HAS COMPLETED IX73165 CUSTOMER IS ATTEMPTING TO ROLLFORWARD THROUGH LOGS AFTER RESTOR IX74116 LOAD OF IXF W/ HIGH DISK_P CORRUPTS LF DATA JR11810 NT UDB TAPE RESTORE FAIL -2530 IX74871 V501: IN LOCK WAITS FOR X LOCK ON TABLE IX76127 HOT:RESTART FAILS WITH SQL1042 DUE TO -4015 IX75242 V501: ROLLFWD OF TABLESPACE RETURNS -1042, FFFFA602 SQLOFMBLK JR11680 REMOVE 8K LIMIT ON SQL IN EXPORT STMT IX75443 OPTIMIZER FAVOUR LIST PREFETCH OVER TABLE SCAN ON TABLES<32PAGE IX75463 V501: INCORRECT NODENUMBER IN ADSM BACKUP IX75609 LIST APP CORRUPTS APP ID FOR LONG APP NAMES IX75642 V501: EOF FROM SQLBGETBUFFERPOOLDEFFROMDISK IX76438 -902 RC 126 (SQLD_IXNOEX) RETURNED ON ALTER TABLE IX75688 USE LSATTR TO CHECK MEMORY ON AIX IX75687 V501: UNABLE TO RESTORE AN ADSM BACKUP USING >=3 SESSIONS IX75909 V501: DB2 BRINGS DOWN INSTANCE WITH DYNAMIC SQL IX75945 CLI0165E ERROR FOLLOWED BY SQL0000W IN THE TRACE. JR11726 SPORADIC TRAPS IN SQLNQ_TABSEL_OFN_CM JR11735 NETBIOS LOOPS WHEN MAXNBSESSIONS IS REACHED JR11737 DSN IN CONNECT STR TRUNCATED WHEN KEYWORD KEEPSTATEMENT USED IX77088 LOAD GETS -911 OR -3508 IX80480 LOAD GETS -911 OR -3508 JR11741 UNABLE TO IMPORT CLIENT PROFILE JR11878 USER COUNTS GET MESSED UP WHEN THEY EXCEED THE MAXIMUM NUMBER O IX76159 AUTOLOADER AND DUMPFILE OPTION CANNOT WORK IN MLN ENV IX76172 STMT OBJECT IN GETBINARYSTREAM NOT BEING CLOSED IX76236 SIGNAL #11 IN SQLRLLPD WHEN DROPPING A TBSPACE WITH 6000 TABLES JR11763 ERROR IN CCA WHEN PRESS 'ENTER' INSTEAD OF USING MOUSE CLICK JR11773 SQL0437W CAUSED OPEN FUNCTION TO BE SKIPPED IN DEFERREDPREPARE IX76443 PERFORMANCE PROBLEM OF A SELECT WITH AN ORDER BY JR11834 DB2 CONNECT INTERRUPT FAILS IN ASYNC MODE IX76680 SAMPLE JAVA STP RETURNS SQL10012 ON SUN IX74116 SAP: PATCH LF CORRUPTION BUG WITH DISK_PARALLELISM. IX76678 SOLARIS 2.5.1,2.6-- SQL1042 ON GET SNAPSHOT JR11802 NT STACK EXCEPTION DUE TO LOW AGENT_STACK_SZ AND LARGE QUERY JR11817 AFTER INSERT OF SIZE>32700 IN COL, NEXT INSERT<32700 TRAPS. IX77137 RUNSTATS WITH DISTRIBUTION CHANGES TABLE SCAN TO INDEX SCAN JR11818 DISABLEMUTITHREAD=1 NOT READ FROM DB2CLI.INI JR11821 WHEN SQL_ROWSET_SIZE > 1, SQLGETDATE REPORTS INVALID CURSOR POS IX76922 KEYWORD DATALINK NOT IMPLEMENTED PROPERLY IX76914 OVERTYPING ODBC DATASOURCE IN "CONNECTING TO DB2 DATABASE"TRAPS IX76924 STAR JOIN DISQUALIFIED FOR STAR JOIN ELIGIBLE QUERY JR11824 TRAP IN DOSCALL1.DLL DURING SELECT ON SMP OS/2 WITH UDB IX78628 UPDATE DB2IUTIL FOR 2 LINE OUTPUT FROM THE BDF COMMAND IX77399 MAKE SURE CRASH RECOVERY DON'T END TOO EARLY IX77067 SUN: DB2IUPDT FAILS DUE TO MISMATCHED LEVEL OF CODE JR11841 SQL_OJ_CAPABILITIES RETURNS INCORRECT INFORMATION IX77706 DB2START.XXXX.PID/DB2STOP.XXXX.PID FILES NOT REMOVED ALWAYS IX77154 OUTER JOIN IN LIST PREDICATE OPTIMIZER PROBLEM IX77312 DB2AGNTP PROCESS HOLDING ON TO /ETC/GROUPS IX77398 HOT: BACKING UP TO HOST MVS TAPES VIA CLIO/S NEEDS BACKBUFSZ 8 IX77400 SQL.H FILE MISSING SQL_QUERYOPT CONSTANTS FOR 2 AND 7 IX77480 MODULARIZE AND ADD DEBUG CODE FOR COMMIT/ROLLBACK OF NLI TABLES IX77439 SQL30081N ON SECOND CONNECT THROUGH SYSPLEX SERVER IX77672 INDEX CORRUPTION AFTER MIGRATING TO V5 IX77494 LOAD WITH DUMPFILE AND CPU > 1 GIVES INCOMPLETE DUMPFILE IX78566 CATALOG CACHE VARIABLES ARE NOT REPORTED IN APP SNAPSHOT IX77553 BACKUP/RESTORE API PROBLEMS IX77572 RECYCLING SCRIPT CENTRE DOESN'T ALLOW MORE SCRIPTS TO BE RUN IX77672 DB2DART CHANGES FOR C. MCARTHUR'S INDEX TOOL JR11872 CS ISOLATION ALLOWS UNCOMMITED READ ACCESS WITH W LOCK ON ROW. IX77776 SQL0404 ON INDEX REBUILD JR11891 INTERMITTENT SQL1652 DOING MULTPLE SIMULTANEOUS DB2STARTS IX77770 SQL1704N RC=8 ON DATABASE MIGRATION FROM DB2 V2 TO V5 ON HP-UX IX78975 LOAD FAILS WITH -911 RC=68 WHEN TIMEOUT = 10S IX77494 MORE DUMPFILE WORK JR11905 SQLNUMRESULTCOLS RETURNS FUNC SEQ ERR AFTER TIMEOUT JR11904 WIN95 GETHOSTBYNAME PERF. PROB. JR11914 MIGRATION FAILS DUE TO BAD HIGH2KEY/LOW2KEY IX78109 NEED OPTION TO ALLOW NEWLINE TO TAKE PRECEDENCE OVER THE STRDEL JR11917 SQLCOLUMNS DOES NOT RETURN COLUMN_DEF IX78176 DB2V5:DB2LOOK DOES NOT EXTRACT EMPTY TABLESPACES IX77398 32K BUFFER SUPPORT (III) - SQLUBCHECKBUFSPACE IX78244 COMPACT BLOB EXPANDS ON REORG IX78479 BAD RETURN CODE FROM SQLOSSEMACCESS BRINGS INSTANCE DOWN JR11921 \N CHARACTER CAUSES SQL0518 WHEN BEFORE/AFTER SELECT KEYWORD IX78265 CREATE INSTANCE VIA DB2SETUP HANGS ON HP-UX JR11928 DB2 CONNECT LOGS SQLO_LIC_INVALID_USERNAME WITH VALID USERNAME IX78334 SQL0104 NOT BEING HANDLED PROPERLY IX78481 V5.2:SQL8008/8002 ON OS/2 WHEN CONNECTING TO MVS FROM THE GTWY IX78499 NUM_AGENTS IS INCORRECT ON LONG RUNNING SYSTEM IX78509 MEMORY LEAK IN SQLRKAIN() WHEN DOING AN IMPORT WITH -973 JR11953 SAP ARRAY INSERT TRAPS JR11956 TRAP IN DB2CLI.DLL ON CLIENT WHEN FORCE APPLICATION ON SERVER JR11959 -805, 07005 ON SQLEXECUTE() WITH ASLHEAPSZ 1, DEFERREDPREPARE 1 IX78630 SQLNUMRESULTCOLS() CAUSES SQLEXECUTE() TO GET SQL0301N, 07006 JR11972 JDBC METADATA GETTABLES RETURN NULLPOINTEREXCEPTION IX78710 EXPORT OF 167 MILLON ROWS RETURNS SQL2003 IX73249 TWO SPM FIXES FOR V5.2 BETA AND V500 IX78820 SQLFETCH AFTER SQLFOREIGNKEYS FAILS ( ONLY THRU GATEWAY ) JR11981 STATIC CURSOR DOES NOT RETURN PROPER INFORMATION IX78958 INVALID CONTAINER NAMES GET THROUGH SQLBSETPOOLCONT IX78836 ALTER TABLE ... NOT NULL DEFAULT CURRENT TIMESTAMP FAILS -193 IX78867 DB2 SHOULD NOT ACCEPT FORCE EXPIRED PASSWORDS IN NON-AIX UNIX IX78903 ARRAY INPUT FOR BLOB COLUMN INSERTS WRONG DATA IX78963 INCORRECT QUERY RESULTS WITH STAR JOIN IX78981 AUTHID NOT FILLED IN ACB CP OF AUTHINFO 4 INTRMDRY IN 2HP SCN JR11917 SQLCOLUMNS DOES NOT RETURN DEFAULT DATA IX79213 LOADING TABLE HANGS INTERMITTANTLY IX79090 CHECK IN PROPER VERSION OF SIGNAL HANDLER IN JDBCSERVER.C IX77572 AIX: PROBLEM WITH RUNNING A SCRIPT NOW AFTER SCHEDULED JOB IS R JR12032 BUG CAUSING SQL1109 WHEN SPECIFYING A SCHEMA IN THE CALL STMT IX79235 INTERMITTENT SIGNAL 11 IN SQLULUMW JR12040 TRAP IN SQLNO_FINAL_PHASE EXECUTING QUERY IX79292 SIGNAL #11 IN DB2LRID WHEN LOAD TERMINATES IX79318 NON-SYSADM IDS ATTEMPT TO OPEN DB2AUDIT.CFG IX79456 9/98 FORCE APPLICATION CRASHES DB2 WHEN BUFFERED INSERTS JR12070 MEMORY LEAK IN DB2SYSC WHEN BPS INITIALIZATION (SQLBINIT) FAILS IX79557 -3508 RC CALLING SQLULOAD API WITH V2 APP. JR12093 FILTER FACTOR OFF AND NO FREQUENCY STATS ON VARCHAR COLUMN IX80107 SQL1269N WITH ONLINE TABLESPACE ROLLFORWARD COMPLETE IX79866 DIA1026C XA ERROR IN DIAG FILE IX80044 EXCESSIVE SEMOP ERRORS ON FAILING LOCAL CONNECTS IX76680 DEFINE SQLEJ_DB2JEXT_JVMSTOP IN SQLEJAVA.H ON ALL PLATFORMS JR12130 BLOCKED FETCH WHICH PREFETCHES RIDS CAN LEAVE ROW LOCK ON TABLE IX80087 HOT:INCORRECT RESULTS RETURNED FROM AN SQL QUERY AFTER RUNSTATS JR12143 HOT :MEMORY LEAKS ON NT AFTER DISCONNECT IX80294 SAP:SQLEXECUTE() DOES NOT REDESCRIBE WHEN THE SQLDA CHANG IX80545 HOT: V501: RECOVERY ENDS TOO EARLY, PANIC/SLEEP JR12167 SELECT RETURNS -901 IN SQLNO_PLAN_COMPARE-- NEGATIVE PLAN COST JR12169 MIGRATION OF THE NODE DIRECTORY FAILED IX80589 OPEN IX80810 HOT:MODIFICATIONS OF OLIR CODE JR12220 LOAD DOES NOT ALLOW CHARACTER DELIMITING AS A PRIORITY. JR12227 BEFORE SELECT IS CAUSING SQLEXECDIRECT TO FAIL IX81362 SQL2038 REASON 5055 DURING RESTORE/MIGRATE JR12247 CCA ONLY SHOWS 8 CHAR OF CHEMA NAME ON HOST DATABASE JR12252 CRASH RECOVERY HANGS IX81497 DB2TRC INFO SHOWS WRONG INFO IN SOLARIS IX81647 BAD #PRAGMA WARNINGS WHEN COMPILING WITH UDB SDK/SOLARIS JR12267 GETDEFAULTLLU ASSUMES THE ONLY LLU AS THE DEFAULT LLU IX81761 IF DB2AUTOLD FAILS, IT STILL RETURNS A 0 RC TO THE SHELL IX81764 DB2ATLD DOES NOT RETURN NON-ZERO RC EVEN IF IT FAILS IX81766 SQL6534 WITH DB2AUTOLD AND RESTART B/D AND NO .NETRC FILE IX82101 EDU CRASH DURING ONLINE BACKUP TO ADSM V3 JR12282 MIGRATION FROM DB2/2 V1.2 TO DB2 UDB IX82188 SUBSEQUENT QUERIES RETURN NO DATA WHEN DEGREE > 1 IX82334 RESTORE OF DATABASE RETURNS RC -10746 (TOO MANY FILES OPEN) IX82336 UOW STOP TIMESTAMP NOT SET ON COMMIT JR12362 SQLE_DEACTIVATE_DB_API DOES NOT POPULATE SQLWARN FILED IN SQLCA JR11820 V501: SOME RESPONSE FILE KEYWORDS IGNORED DURING NT INSTALL JR11802 NT STACK EXCEPTION DUE TO LOW AGENT_STACK_SZ AND LARGE QUERY JR11952 THIN INSTALL FROM WIN NT DOES NOT INSTALL ODBC FILES CORRECTLY JR11952 THIN CLIENT INSTALL TO LOOK FOR ODBC FILES IN THE CUR. DIR. JR12143 HOT :MEMORY LEAKS ON NT AFTER DISCONNECT JR12219 CAE MISSING CONVERSION FILES FOR JDBC SUPPORT JR12345 FIXING DB2APP.DLL JR11075 DB2RESDB IS NOT RETURNING THE CORRECT OUTPUT/MESSAGE JR11498 V501 SQL2503N FROM DB2RESDB RESTORING V1 DATABASE TO V5 JR11824 TRAP IN DOSCALL1.DLL DURING SELECT ON SMP OS/2 WITH UDB IX78481 V5.2:SQL8008/8002 ON OS/2 WHEN CONNECTING TO MVS FROM THE GTWY JR12005 INTERMITTENT TRAP IN SQLODUMPEDU JR12021 TRAP IN TCP32.DLL IF DB2COMM=TCPIP AND USING TWO PHASE CONNECT JR11899 CURRENTSQLID NOT WORKING FROM CAE/WIN CLIENT SETUP GUI JR11899 SEEING DBNAME IN CURRENTSQLID FIELD IN CLIENT SETUP GUI JR12221 OPTIMIZER PROBLEM WITH HOST VARIABLE FILTER FACTORS - RUNSTATS IX76365 FIX 94984 - MISSING A SET OF BRAKETS