************************************************************ Product Name : DB2 UDB Version 8 for Windows (32-bit) PTF Number : WR21316 Package Date : Wed Feb 5 20:31:54 EST 2003 Build Level : s030130 ************************************************************ APAR fixes included in WR21316 (Fixpak 1) APAR No. Abstract -------- -------------------------------------------------- GG04317 APPLY ASNLOAD ENCOUNTERS A SEGMENTATION FAULT WHEN IT ATTEMPTS TO CLOSE A NON-EXISTANT FILE GG04331 APPLY RC LOWERCASE DATABASE NAMES IN CONTROL TABLES CAUSE APPLY DATABASE CONNECTIONS TO MULTIPLY GG04341 REPLICATION ADMIN APIS AND COMPONENT CC_REPLAPI FP1 IY37394 DB2SETUP SCRIPT DELETES /VAR/TMP IF THE DIRECTORY IS EMPTY IY37845 SQL_ATTR_PRESERVE_LOCALE IS NOT EFFECTIVE IN AN ODBC ENVIRONMENT IY37876 TRAP IN SQRA WHILE RUNNING GRANTS/REVOKES IN A STRESS ENVIRONMENT. IY38897 MEMORY LEAK: ALL NOT-WITH-RETURN CURSORS IN THE INVOCATION CONTROL BLOCK NEED TO BE CLOSED IY38915 ON SINGLE PARTITION SETUP, GLOBAL TEMP TABLES ARE NOT DETECTED BY LOAD. TRYING TO LOAD INTO THEM RESULTS IN SQL3304N. IY38918 -901 IN SQLNO_CRULE_JOIN IY38942 DB2 PANICS WHILE IN SQLBPURGEALLPAGESINLARGERANGE IY38944 THE CONFIG ADVISOR RECOMMENDS A WRONG VALUE FOR NUM_POOLAGENTS SO THAT DB2START MAY FAIL WITH SQL1220N IY38949 THE CONFIG ADVISOR ALWAYS CHANGES LOGSECOND PARAMETER VALUE TO 1 IY38970 -901 IN SQLNO_PROP_IOA IY38980 INCORRECT CODEPAGES ARE USED FOR TAIWAN, HONGKONG, BULGARIAN AND POLISH LANGUAGES ON LINUX PLATFORM IY38981 SQL1224 ON COMPILING STORED PROCEDURES IN FEDERATED ENVIRONMENT IY38985 DB2 FOR SUN SOLARIS HANGS IN _LWP_SEMA_WAIT IY38992 SQL1032 DURING ADD NODE OPERATION. IY38997 TRAP IN SQLNO FUNCTION DUE TO CORRUPT HISTOGRAM STATISTICS. IY38998 EASE RESTRICTIONS ON LOAD_ERRS_ONLY/SETUP_AND_LOAD_ERRS IY38999 LOAD HUNG CAUSING OTHER CLIENTS HUNG IY39003 INCORRECT SQL057OW ON GRANTING PRIVILEGES TO SEQUENCES IY39012 SIG 11 SQLRLGETINDEXINFORECV,MAKE SURE (*PRPLYPP) IS NOT NULL IY39026 DJMIG: -901 WITH 'UNKNOWN TYPE'. LONG VARCHAR DATATYPE USING UDB ON DJ IS NOT MIGRATED TO THE LOB TYPES IN V8 IY39028 CREATE DATABASE FAILS WITH SQL0902C REASON CODE='184' SQLSTATE=58005 IY39030 INSTANCE CRASHES AND DB CORRUPTED ON SUN DURING ALTER BUFFERPOOL IY39033 LTRIM.RTRIM,UCASE,LCASE GIVE -440 POST DJ MIGRATION IY39034 -901 ON SQLRL_DGTT_RCV: BUFFER POOL ERROR IY39131 INCONSISTENT LOAD SUMMARY WHEN LOAD WITH MULTI PARTITION NODES IY39132 EEE LOAD INTO A TABLE WITH IDENTITY COLUMN ALONG WITH A PARTITIONING KEY ON A DECIMAL COLUMN MAY RESULT IN INCORRECT ROW HASHING IY39134 ASYNC IO FOR LOAD IY39210 LOAD TERMINATE FAILED WITH SQL2038 AND DB2DIAG.LOG SHOWS SQLUREGISTERLOADEND -- LBA LSN MISMATCH IY39211 SETTING ATTR_SAVECOUNT ABORTS CLI LOAD IY39214 BPS API FUNCTIONS CAN HANG IF DB2CHKPTR IS ON IY39217 LOAD IN EEE FAILED WITH FILE_TRANS_CMD OPTION WHEN MULTIPLE SOURCES ARE SPECIFIED IY39240 SIGNAL 11 IN SQLAK_CALLBDRDAOUTPUTLOB WHEN RUNNING SPATIAL QUERY IY39241 INSERT STATEMENT RETURNS A -901 WITH VALUE IS TOO LARGE FOR THE BUFFER IY39246 UNEXPECTED SIGNAL 11 AT PC=0XFFFFFFFF7ED01A40 USING THE CONTROL CENTER TO RUN LIST APPLICATIONS ON A SUN SOLARIS 64 BIT INSTANCE IY39247 FUNCTION MAPPING OPTIONS ARE NOT MIGRATED. IY39356 INSTALL: ADD DB2DJXMSG TO INSTALL IMAGE IY39357 SQL0401 ON LONG VARGRAPHIC || VARCHAR RETURNS CLOB IN UNICODE DB IY39363 SETTING LC_ALL EQUAL TO KO ON SUN MAY CAUSE INSTALL PACKAG DUPLICATE IY39368 AFTER THE INSTANCE CREATION FAILED, URE STILL TRIES TO SETUP ORACLE_HOME AND IT CRASHES. IY39369 REWRITE CHANGES FOR UNION ALL, GROUP BY AND INLIST IY39376 RESTORE FAILS TO RESTORE A LOB OBJECT, RESULTING IN POTENTIAL ERRORS WHEN TRYING TO ACCESS THE OBJECT AFTER RESTORE COMPLETES. IY39379 PACKAGE LOCK (INTERNAL P LOCK) NOT RELEASED AFTER RECEIVING SQL0719 DURING BIND IY39414 -901 ON SELECT WITH UDPS AND SQL UDF IY39422 FIX HEALTH CENTER ALERT FOR TABLESPACE CONTAINER UTILIZATION IY39426 SNAPSHOT STORED PROCEDURE CREATES INSTANCE /TMP DIRECTORY WHICH HAVE IMPROPER PERMISSIONS IY39427 COMPILING A JAVA STORED PROCEDURE WITHIN WSAD LINUX CAUSES A JAVA CORE DUMP IY39428 EXCEPTION ON VIEW SOURCE OF REXX, C, ASSEMBLY IY39440 UDF WIZARD NAVIGATION PROBLEMS. IY39441 EXITING FROM DEVELOPMENT CENTER AFTER EXISTING DC IS ALREADY UP, WILL CAUSE ALL THE DC TO BE GONE. IY39451 SQL0901 DURING UPD/DEL WITH REFETCH AND SUBQUERY TO JOIN APPLIEDTO INPUT OF UPD/DEL IY39481 VISUAL EXPLAIN IN WINDOWS RETURNS DBA3037 EXPLAIN SNAPSHOT CORRUPTED IY39484 EXPLAIN IS MISSING THE RELATIONSHIP BETWEEN THE CSE AND ALL BUT THE FIRST CONSUMERS OF THE CSE IY39487 AST FULL REFRESH CAN MISS/DUP ROWS IF UNDERLYING TBL HAS CHANGE THAT MAKES ROW MOVE BTWN PARTITIONS, BLOCKS OR WITHIN INDEX. IY39491 ALLOW DB2ICLUS /DROP TO PROCEED IF DAS DOESN'T EXIST IY39513 IF QUERY HAS A DISTINCT AND OUTER JOINS, THE DISTINCT MAY NOT BEENFORCED AFTER OUTER JOIN REORDERING - MAY GET WRONG RESULTS. IY39522 DB2EXFMT CRASHES DURING PREPARE OF EXPLAIN PLAN IY39526 SQL0973 -OUT OF MEMORY ERROR AFTER EXECUTING A LARGE NUMBER OF EXPLAIN STATEMENTS. IY39532 T3ADO CLIENTS WITH MICROSOFT OLEDB PROVIDER USING SCROLLABLE CURSORS COULD PANIC INSTANCE IY39537 SQL0302 FOR QUERY WITH INLIST OF MORE THAN 1 ELEMENT, ELEMENTS ARE PARAMETER MARKERS. IY39540 SQL0222 WHEN ROW IS UPDATED OR DELETED FROM SCROLLABLE CURSOR AND ANY BASE TABLE COLUMN IN THE CURSOR IS NULL. SQLSETPOS() IY39638 LOAD WITH STATISTICS YES PRODUCES INCORROUT STATS FOR MDC TABLE IY39641 MDC:SQLIMARKKEY PROBE:1323, CALLER ADDKEYTOLEAF, PROCLEAF2ADD IY39642 ASSERTION FAILED FROM SQLUDIRIO.C LINE:286 IY39646 IN LOAD GENERATED COLUMN SUPPORT, IN FUNCTION SQLRICLS(), WE AREGOING TO SQLRICLS_SIMPLE() CODEPATH WHICH IT SHOULD NOT. IY39647 FIX DAS MULTIPLE RELEASE SUPPORT IY39652 LOAD TERMINATE RETURNED SQL1007(SQLBDMSCHECKOBJALLOC PROBE:825) IY39659 SQLBRDPG() PROBE:1110: BLK MAP HAS INCORRECT NUMBER OF ENTRIES IY39660 TRAP IN SQLUWRITERIDFILE WHILE DOING LOAD IY39661 INSTANCE CRASH DURING LOAD DELETE PHASE IY39663 -902 ON MPP LOAD WHEN IDENTITY VALUES EXHAUSTED IY39666 IN MULTIPARTION ENVIRONMENT, SQLUREGISTERLOADEND PROBE:259 - LBA LSN MISMATCH IY39668 DB2ADMIN STOP RETURNS BEFORE DAS IS STOPPED IY39670 DISCOVERY FAILED WHEN FP1 INST ENTRY ALONG WITH GA INST IY39719 INSTANCE PANIC DUE TO TRAP IN SQLOFMBLKEX IY39720 INSTANCE CRASH WITH SIGNAL 11 IN SQLRA_RPC_APM_SHIP() IY39784 CLI APPLICATION TRAPS WHEN ABNORMALLY TERMINATED. GOING AGAINST OS/390. TRAP IN SQLJRHANDLEERRORRM PROBE: 911 IY39785 STREAMING OF >32K JAPANESE LOB DATA DOES NOT NECESSARILY WORK IY39790 FAIL TO READ GRAPHIC(VARGRAPHIC,LONG VARGRAPHIC) COLUMN USING APPROACH 2000. IY39793 NICKNAMES ARE NOT SHOWING UP CORRECTLY IN ALL CASES FROM WSAD V5. IY39796 CLI0117E-INVALID CURSOR STATE. SQLSETCURSORNAME( ) DOES NOT APPEAR TO BE WORKIGN IN STATIC CAPTURE MODE. IY39800 ADD SUPPORT TO SCHEMA FUNCTIONS FOR PATCH2=7 AND GRAPHIC KEYWORDS. IY39803 FORCE REPREPARE WHEN WE COME ELIGIBLE FOR BUFFERED INSERT AGAIN. IY39806 CLI TRACE DOES NOT GIVE COLUMN NAME WHEN SQLSTATE=01517 IY39807 -804 WHEN PROCESSING CURSOR AFTER POSITIONED UPDATE/DELETE IY39809 ARRAYINPUT REQUEST MUST HAVE INPUT DESCRIPTOR. IY39810 CLI HANGS ON END CHAIN: V81 CLIENT/V72 SERVER IY39811 EXECUTING SQLJ PROGRAM WITH GRAPHIC DATATYPE AGAINST DB2 UDB FOR OS/390 CAUSES SQL0516N. IY39869 COBOL APPLICATION NOT HANDLING LARGE NUMBER OF HOST VARIABLES. IY39870 CREATE NICKNAME IS NOT PICKING UP THE STATISTICS FOR A DRDA HOSTTABLE. IY39871 TRAP WHEN CLI TRACING IS ON IN CLI_GETMEMTHREADINFO( ) RESULTS IN FAILURE IN SQLOGMBLK. IY39872 SEGV WITH XA ON SQLCLOSECURSOR WITH REMOTE DATABASE. IY39873 INDEX MANAGER PROGRAMMING ERROR FFFFF954 DURING RUNTIME WITH SQLIREMVIOL PROBE:1/PROBE:2 IY39875 SQL QUERY GETS SQL0901N RC 0 IN SQLNO_SMP_CREATE_SHARED_SO() PROBE 200 WHEN INTRAPARALLEL IS ON. IY39884 ALTER TABLE VOLATILE CARDINALITY DOES NOT INVALIDATE THE PACKAGECACHE FOR DYNAMIC SQL CREATING BAD ACCESS PATH AND PERFORMANCE IY39885 SQL4304 CLASS NOT FOUND AFTER LOADING JAVA UDFS > 4500 TIMES IY39888 DATABASE BACKUP RETURNS SQL1042C AND THE INSTANCE CRASHES WITH SIGNAL 11 IN SQLODSHR() IY39889 POTENTIAL DEFUNCT DB2GOV CHILD PROCESSES IY39891 INSTANCE CRASH WITH SIGNAL 11 IN SQM_EVMON IY39895 RELATIONAL SCAN IS USED WHEN INDEXES SHOULD BE IN A JOIN/CORREL ATION QUERY IY39908 THE OPTIMIZER MIGHT NOT CHOOSE THE INDICES OR AN OPTIMAL JOIN ORDER FOR A JOIN INVOLVED IN A COMPLEX OR PREDICATE. IY39912 IMPLEMENT PUSHDONW OF REGULAR JOIN THROUGH OJ IF IT IS NEAR UNIQUE. AS WELL PUSH DOWN IF THERE IS MULTIPLE OJS. IY39922 CRASH WHEN LOADING INTO TABLE WITH GENERATED COLUMN(S) USING GENERATEDMISSING MODIFIER. IY39923 DURING INDEX RECREATION, BPS ERROR OF FIXING A DIRTY PAGE SQLB_NEWX. IY39941 UNRETRIEVED ERROR MESSAGE='SQLSTATE 01503: THE NUMBER OF RESULT COLUMNS IS LARGER THAN THE NUMBER OF HOST VARIABLES PROVIDED.' IY39953 DB2ADVIS SETS INVALID TIME FOR STATS_TIME FOR NEW INDEX IY39956 DB2 PANICS IN ~SQM_EVMON_IOT(), CALLED BY SHUTDOWN_EVMON, WHEN AN EVENT MONITOR ENCOUNTERS AN ERROR. IY40015 COMPLEX SUBQUERY ELEMENT NOT BEING PUSHED DOWN THROUGH UNION ALL. THIS INCLUDES FUNCTIONS, COMPLEX QGM ELEMENTS IY40041 DB2COUNTRY IGNORES DECIMAL SEPARATOR CHANGE IY40066 COSTING CHANGE TO MSJN. INCLUSION OF ADDITIONAL DETAILS IN REGARDS TO EFFHIGH2KEY. IY40104 WHEN A COLUMN IS IN THE SELECT STATEMENT MORE THEN ONCE, AND THEN THE SAME COLUMN IS IN THE ORDER BY, DB2 WILL FAIL SQL0901 IY40107 AUTOMATIC INCREMENTAL RESTORE FAILS WITH SQL2571 RC=3 WHEN TABLESPACE NAME IS OF MAX LENGTH IY40113 CRASH RECOVERY FAILED WITH BUFFER POOL LOGIC ERROR SQLBREDOUPDATEEMP ON EMP OF LOB OBJECT IY40147 DB2 CRASH WHEN IMPORTING LARGE NUMBER OF XML RECORDS INTO A DATABASE WHICH IS XML ENABLED. IY40150 DURING ROLLFORWARD ON AN INDEX THAT IS DMS AND PARTIAL, WE COULD NON-EXISTENT PAGE 0 AND CAUSING THE ROLLFORWARD TO FAIL. JR17478 SQL FUNCTION UTILIZING CURRENT SCHEMA TO QUALIFY A TABLE REF. FAILS WITH -204 SHOWING A CORRUPTED NAME FOR THE QUALIFIER. JR17736 PATCH1=1024 IS NOT WORKING IN V8 JR17737 AFTER MIGRATION TO V8.1, REBINDING OF PACKAGES FAIL WITH SQL 510IF THE STMT HAS AN UPDATE/DELETE WHERE CURRENT OF CURSOR JR17802 INSTANCE TRAP: SQL0901C, UNEXPECTED AUTHINFO FREE LIST COUNT WHILE DECREMENTING JR17805 PANIC/SLEEP IN SQLDINVCURSORPOS AND IN SQLDENDTRANSACTION. THIS CAN HAPPEN IN A MULTI-PARTITION SETUP. JR17808 THE CONFIG ADVISOR SETS SORTHEAP PARAMETER TOO HIGH, WHEN 'APPLYDB ONLY' IS SELECTED. JR17809 GATEWAY HUNG WHEN DB2STOP FORCE JR17811 THE KILLDB2 UTILITY MAY COLLIDE WITH DB2START ON WINDOWS JR17812 SQL1025 ON DB2STOP FORCE JR17813 DB2 PANICS IN SQLEFSEM2 ON WINDOWS JR17816 ALLOCATION OF INDEX INFO IN SQLRLGETINDEXINFO DOES NOT ACCOUNT FOR ALIGNMENT AND CORRUPTS MEMORY JR17817 DB2MSCS ON WINDOWS 64-BIT EEE CLUSTER FAILS TO CREATE FILE SHARE JR17827 CCA3051N ERROR USING THE CONFIGURATION ASSISTANT TO CONFIGURE THE CS/NT STACK. JR17829 LIST SESSION WINDOW DOES NOT SHOW TARGET SUBSYSTEM NAME JR17830 SQL0204N WHEN TRYING TO DROP A USER DEFINED DISTINCT TYPE WITH MIXED CASE SCHEMA USING THE CONTROL CENTER. JR17831 SQL0355N ERROR USING THE CONTROL CENTER WIZARD TO CREATE A TABLEWITH AN XMLCLOB COLUMN. JR17832 THE TASK CENTER LOAD WIZARD GENERATES AN INVALID LOAD COMMAND FAILING WITH AN SQL0104N ERROR FOR A PARTITIONED DATABASE. JR17834 THE CONTROL CENTER GENERATES AN INVALID KEYWORD, DEFAULTS NULL, WHEN CREATING AN INSTEAD OF TRIGGER. JR17836 JAVA DOC FILE FOR VIDEO CENTRAL IS NOT INSTALLED JR17840 INTERFACES FILE REPLACED WITH EMPTY FILE AFTER MIGRATION JR17843 SQL0901 REGARDING PLAN/ENVIRONMENT MISMATCH WHEN TURNING INTRA_PARALLEL FROM YES TO NO JR17874 INSTANCE TRAP AT SQLCC_GENERATE_SYNCLOG WHEN SP FETCHES LOB DATA JR17875 LOAD CRASHES INSTANCE ON WINDOWS WHEN TABLE CONTAINS IDENTITY COL IN FIRST POSITION AND INTO OPTION NOT USED JR17878 WHEN THE PARSER FINDS THE TWO DECIMALS, IT INSERTS A CAST FUNCIT. THIS CAUSES A SEGMENTATION FAULT. JR17881 IN THE TOOLS SETTINGS FOR COMMAND CENTER IF YOU CHECK TERMINATIOCHARACTER SETTING W/ THE BOX BLANK TOOLS SETTINGS WON'T WORK. JR17882 UNABLE TO ADD NOTIFICATION TO A STEP WITH A LONG NAME JR17883 DWC: EXPORT UTILITY EXPORTS MORE METADATA THAN IT SHOULD. JR17887 FOR QUERIES ON LOCAL VIEWS THAT CONTAIN NICKNAMES, FUNCTIONS CONTAINED IN A SELECT ON THE VIEW WILL NOT BE PUSHED DOWN JR17888 DISTINCT NOT PUSHED DOWN WHEN USING A NICKNAME JR17890 DURING LOAD MODIFIED BY CODEPAGE IBM-930, CHARACTER X4040 NOT STRIPPED OUT BY STRIPTBLANKS MODIFIER JR17891 TRIGGER COMPILATION RESULTS IN SQL0101N DUE TO INFINITE LOOP JR17895 MEMORY LEAK IN DATABASE MONITOR HEAP WHEN HANDLING SQLESETI. ERROR 0XFFFFD621 MAY BE REPORTED IN SQLE_ADD_SETINFO_FIELD LI70138 ENABLING CLI TO HANDLE NULL TERMINATING CHARACTERS TO ENABLE SET PATCH2=52 PRIOR TO FP7, OR PATCH2=53 AFTER FP7 LI70139 TRAP WHILE COMPILING A QUERY. SEGV IN SQLNR_REORDER_IJ_QGM() PQ45854 INSUFFICIENT MESSAGES TO DEBUG BUILD ERRORS FOR STORED PROCEDURE BUILDER. - DSNTPSMP PQ68979 DPROPR APPLY -752 - APPLY CNTROL SERVER IS PRE V8 SE08163 OSP R510 EXTENDERS XML_EXTENDER INCORROUT