Product Name:DB2 UDB Version 8 for Linux (Intel) (32-bit)
PTF Number:MI00046
Package Date:Wed Feb 5 20:31:54 EST 2003
Build Level:s030130
APAR fixes included in MI00046 (Fixpak 1)
APARABSTRACT
GG04317APPLY ASNLOAD ENCOUNTERS A SEGMENTATION FAULT WHEN IT ATTEMPTS TO CLOSE A NON-EXISTANT FILE
GG04331APPLY RC LOWERCASE DATABASE NAMES IN CONTROL TABLES CAUSE APPLY DATABASE CONNECTIONS TO MULTIPLY
GG04341REPLICATION ADMIN APIS AND COMPONENT CC_REPLAPI FP1
IY37394DB2SETUP SCRIPT DELETES /VAR/TMP IF THE DIRECTORY IS EMPTY
IY37845SQL_ATTR_PRESERVE_LOCALE IS NOT EFFECTIVE IN AN ODBC ENVIRONMENT
IY37876TRAP IN SQRA WHILE RUNNING GRANTS/REVOKES IN A STRESS ENVIRONMENT.
IY38897MEMORY LEAK: ALL NOT-WITH-RETURN CURSORS IN THE INVOCATION CONTROL BLOCK NEED TO BE CLOSED
IY38915ON 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
IY38942DB2 PANICS WHILE IN SQLBPURGEALLPAGESINLARGERANGE
IY38944THE CONFIG ADVISOR RECOMMENDS A WRONG VALUE FOR NUM_POOLAGENTS SO THAT DB2START MAY FAIL WITH SQL1220N
IY38949THE CONFIG ADVISOR ALWAYS CHANGES LOGSECOND PARAMETER VALUE TO 1
IY38970-901 IN SQLNO_PROP_IOA
IY38980INCORRECT CODEPAGES ARE USED FOR TAIWAN, HONGKONG, BULGARIAN AND POLISH LANGUAGES ON LINUX PLATFORM
IY38981SQL1224 ON COMPILING STORED PROCEDURES IN FEDERATED ENVIRONMENT
IY38985DB2 FOR SUN SOLARIS HANGS IN _LWP_SEMA_WAIT
IY38992SQL1032 DURING ADD NODE OPERATION.
IY38997TRAP IN SQLNO FUNCTION DUE TO CORRUPT HISTOGRAM STATISTICS.
IY38998EASE RESTRICTIONS ON LOAD_ERRS_ONLY/SETUP_AND_LOAD_ERRS
IY38999LOAD HUNG CAUSING OTHER CLIENTS HUNG
IY39003INCORRECT SQL057OW ON GRANTING PRIVILEGES TO SEQUENCES
IY39012SIG 11 SQLRLGETINDEXINFORECV,MAKE SURE (*PRPLYPP) IS NOT NULL
IY39026DJMIG: -901 WITH 'UNKNOWN TYPE'. LONG VARCHAR DATATYPE USING UDB ON DJ IS NOT MIGRATED TO THE LOB TYPES IN V8
IY39028CREATE DATABASE FAILS WITH SQL0902C REASON CODE='184' SQLSTATE=58005
IY39030INSTANCE CRASHES AND DB CORRUPTED ON SUN DURING ALTER BUFFERPOOL
IY39033LTRIM.RTRIM,UCASE,LCASE GIVE -440 POST DJ MIGRATION
IY39034-901 ON SQLRL_DGTT_RCV: BUFFER POOL ERROR
IY39131INCONSISTENT LOAD SUMMARY WHEN LOAD WITH MULTI PARTITION NODES
IY39132EEE LOAD INTO A TABLE WITH IDENTITY COLUMN ALONG WITH A PARTITIONING KEY ON A DECIMAL COLUMN MAY RESULT IN INCORRECT ROW HASHING
IY39134ASYNC IO FOR LOAD
IY39210LOAD TERMINATE FAILED WITH SQL2038 AND DB2DIAG.LOG SHOWS SQLUREGISTERLOADEND -- LBA LSN MISMATCH
IY39211SETTING ATTR_SAVECOUNT ABORTS CLI LOAD
IY39214BPS API FUNCTIONS CAN HANG IF DB2CHKPTR IS ON
IY39217LOAD IN EEE FAILED WITH FILE_TRANS_CMD OPTION WHEN MULTIPLE SOURCES ARE SPECIFIED
IY39240SIGNAL 11 IN SQLAK_CALLBDRDAOUTPUTLOB WHEN RUNNING SPATIAL QUERY
IY39241INSERT STATEMENT RETURNS A -901 WITH VALUE IS TOO LARGE FOR THE BUFFER
IY39246UNEXPECTED SIGNAL 11 AT PC=0XFFFFFFFF7ED01A40 USING THE CONTROL CENTER TO RUN LIST APPLICATIONS ON A SUN SOLARIS 64 BIT INSTANCE
IY39247FUNCTION MAPPING OPTIONS ARE NOT MIGRATED.
IY39356INSTALL: ADD DB2DJXMSG TO INSTALL IMAGE
IY39357SQL0401 ON LONG VARGRAPHIC || VARCHAR RETURNS CLOB IN UNICODE DB
IY39363SETTING LC_ALL EQUAL TO KO ON SUN MAY CAUSE INSTALL PACKAG DUPLICATE
IY39368AFTER THE INSTANCE CREATION FAILED, URE STILL TRIES TO SETUP ORACLE_HOME AND IT CRASHES.
IY39369REWRITE CHANGES FOR UNION ALL, GROUP BY AND INLIST
IY39376RESTORE FAILS TO RESTORE A LOB OBJECT, RESULTING IN POTENTIAL ERRORS WHEN TRYING TO ACCESS THE OBJECT AFTER RESTORE COMPLETES.
IY39379PACKAGE LOCK (INTERNAL P LOCK) NOT RELEASED AFTER RECEIVING SQL0719 DURING BIND
IY39414-901 ON SELECT WITH UDPS AND SQL UDF
IY39422FIX HEALTH CENTER ALERT FOR TABLESPACE CONTAINER UTILIZATION
IY39426SNAPSHOT STORED PROCEDURE CREATES INSTANCE /TMP DIRECTORY WHICH HAVE IMPROPER PERMISSIONS
IY39427COMPILING A JAVA STORED PROCEDURE WITHIN WSAD LINUX CAUSES A JAVA CORE DUMP
IY39428EXCEPTION ON VIEW SOURCE OF REXX, C, ASSEMBLY
IY39440UDF WIZARD NAVIGATION PROBLEMS.
IY39441EXITING FROM DEVELOPMENT CENTER AFTER EXISTING DC IS ALREADY UP, WILL CAUSE ALL THE DC TO BE GONE.
IY39451SQL0901 DURING UPD/DEL WITH REFETCH AND SUBQUERY TO JOIN APPLIEDTO INPUT OF UPD/DEL
IY39481VISUAL EXPLAIN IN WINDOWS RETURNS DBA3037 EXPLAIN SNAPSHOT CORRUPTED
IY39484EXPLAIN IS MISSING THE RELATIONSHIP BETWEEN THE CSE AND ALL BUT THE FIRST CONSUMERS OF THE CSE
IY39487AST FULL REFRESH CAN MISS/DUP ROWS IF UNDERLYING TBL HAS CHANGE THAT MAKES ROW MOVE BTWN PARTITIONS, BLOCKS OR WITHIN INDEX.
IY39491ALLOW DB2ICLUS /DROP TO PROCEED IF DAS DOESN'T EXIST
IY39513IF QUERY HAS A DISTINCT AND OUTER JOINS, THE DISTINCT MAY NOT BEENFORCED AFTER OUTER JOIN REORDERING - MAY GET WRONG RESULTS.
IY39522DB2EXFMT CRASHES DURING PREPARE OF EXPLAIN PLAN
IY39526SQL0973 -OUT OF MEMORY ERROR AFTER EXECUTING A LARGE NUMBER OF EXPLAIN STATEMENTS.
IY39532T3ADO CLIENTS WITH MICROSOFT OLEDB PROVIDER USING SCROLLABLE CURSORS COULD PANIC INSTANCE
IY39537SQL0302 FOR QUERY WITH INLIST OF MORE THAN 1 ELEMENT, ELEMENTS ARE PARAMETER MARKERS.
IY39540SQL0222 WHEN ROW IS UPDATED OR DELETED FROM SCROLLABLE CURSOR AND ANY BASE TABLE COLUMN IN THE CURSOR IS NULL. SQLSETPOS()
IY39638LOAD WITH STATISTICS YES PRODUCES INCORROUT STATS FOR MDC TABLE
IY39641MDC:SQLIMARKKEY PROBE:1323, CALLER ADDKEYTOLEAF, PROCLEAF2ADD
IY39642ASSERTION FAILED FROM SQLUDIRIO.C LINE:286
IY39646IN LOAD GENERATED COLUMN SUPPORT, IN FUNCTION SQLRICLS(), WE AREGOING TO SQLRICLS_SIMPLE() CODEPATH WHICH IT SHOULD NOT.
IY39647FIX DAS MULTIPLE RELEASE SUPPORT
IY39652LOAD TERMINATE RETURNED SQL1007(SQLBDMSCHECKOBJALLOC PROBE:825)
IY39659SQLBRDPG() PROBE:1110: BLK MAP HAS INCORRECT NUMBER OF ENTRIES
IY39660TRAP IN SQLUWRITERIDFILE WHILE DOING LOAD
IY39661INSTANCE CRASH DURING LOAD DELETE PHASE
IY39663-902 ON MPP LOAD WHEN IDENTITY VALUES EXHAUSTED
IY39666IN MULTIPARTION ENVIRONMENT, SQLUREGISTERLOADEND PROBE:259 -LBA LSN MISMATCH
IY39668DB2ADMIN STOP RETURNS BEFORE DAS IS STOPPED
IY39670DISCOVERY FAILED WHEN FP1 INST ENTRY ALONG WITH GA INST
IY39719INSTANCE PANIC DUE TO TRAP IN SQLOFMBLKEX
IY39720INSTANCE CRASH WITH SIGNAL 11 IN SQLRA_RPC_APM_SHIP()
IY39784CLI APPLICATION TRAPS WHEN ABNORMALLY TERMINATED. GOING AGAINST OS/390. TRAP IN SQLJRHANDLEERRORRM PROBE: 911
IY39785STREAMING OF >32K JAPANESE LOB DATA DOES NOT NECESSARILY WORK
IY39790FAIL TO READ GRAPHIC(VARGRAPHIC,LONG VARGRAPHIC) COLUMN USING APPROACH 2000.
IY39793NICKNAMES ARE NOT SHOWING UP CORRECTLY IN ALL CASES FROM WSAD V5.
IY39796CLI0117E-INVALID CURSOR STATE. SQLSETCURSORNAME( ) DOES NOT APPEAR TO BE WORKIGN IN STATIC CAPTURE MODE.
IY39800ADD SUPPORT TO SCHEMA FUNCTIONS FOR PATCH2=7 AND GRAPHIC KEYWORDS.
IY39803FORCE REPREPARE WHEN WE COME ELIGIBLE FOR BUFFERED INSERT AGAIN.
IY39806CLI TRACE DOES NOT GIVE COLUMN NAME WHEN SQLSTATE=01517
IY39807-804 WHEN PROCESSING CURSOR AFTER POSITIONED UPDATE/DELETE
IY39809ARRAYINPUT REQUEST MUST HAVE INPUT DESCRIPTOR.
IY39810CLI HANGS ON END CHAIN: V81 CLIENT/V72 SERVER
IY39811EXECUTING SQLJ PROGRAM WITH GRAPHIC DATATYPE AGAINST DB2 UDB FOR OS/390 CAUSES SQL0516N.
IY39869COBOL APPLICATION NOT HANDLING LARGE NUMBER OF HOST VARIABLES.
IY39870CREATE NICKNAME IS NOT PICKING UP THE STATISTICS FOR A DRDA HOSTTABLE.
IY39871TRAP WHEN CLI TRACING IS ON IN CLI_GETMEMTHREADINFO( ) RESULTS IN FAILURE IN SQLOGMBLK.
IY39872SEGV WITH XA ON SQLCLOSECURSOR WITH REMOTE DATABASE.
IY39873INDEX MANAGER PROGRAMMING ERROR FFFFF954 DURING RUNTIME WITH SQLIREMVIOL PROBE:1/PROBE:2
IY39875SQL QUERY GETS SQL0901N RC 0 IN SQLNO_SMP_CREATE_SHARED_SO() PROBE 200 WHEN INTRAPARALLEL IS ON.
IY39884ALTER TABLE VOLATILE CARDINALITY DOES NOT INVALIDATE THE PACKAGECACHE FOR DYNAMIC SQL CREATING BAD ACCESS PATH AND PERFORMANCE
IY39885SQL4304 CLASS NOT FOUND AFTER LOADING JAVA UDFS > 4500 TIMES
IY39888DATABASE BACKUP RETURNS SQL1042C AND THE INSTANCE CRASHES WITH SIGNAL 11 IN SQLODSHR()
IY39889POTENTIAL DEFUNCT DB2GOV CHILD PROCESSES
IY39891INSTANCE CRASH WITH SIGNAL 11 IN SQM_EVMON
IY39895RELATIONAL SCAN IS USED WHEN INDEXES SHOULD BE IN A JOIN/CORREL ATION QUERY
IY39908THE OPTIMIZER MIGHT NOT CHOOSE THE INDICES OR AN OPTIMAL JOIN ORDER FOR A JOIN INVOLVED IN A COMPLEX OR PREDICATE.
IY39912IMPLEMENT PUSHDONW OF REGULAR JOIN THROUGH OJ IF IT IS NEAR UNIQUE. AS WELL PUSH DOWN IF THERE IS MULTIPLE OJS.
IY39922CRASH WHEN LOADING INTO TABLE WITH GENERATED COLUMN(S) USING GENERATEDMISSING MODIFIER.
IY39923DURING INDEX RECREATION, BPS ERROR OF FIXING A DIRTY PAGE SQLB_NEWX.
IY39941UNRETRIEVED ERROR MESSAGE='SQLSTATE 01503: THE NUMBER OF RESULT COLUMNS IS LARGER THAN THE NUMBER OF HOST VARIABLES PROVIDED.'
IY39953DB2ADVIS SETS INVALID TIME FOR STATS_TIME FOR NEW INDEX
IY39956DB2 PANICS IN ~SQM_EVMON_IOT(), CALLED BY SHUTDOWN_EVMON, WHEN AN EVENT MONITOR ENCOUNTERS AN ERROR.
IY40015COMPLEX SUBQUERY ELEMENT NOT BEING PUSHED DOWN THROUGH UNION ALL. THIS INCLUDES FUNCTIONS, COMPLEX QGM ELEMENTS
IY40041DB2COUNTRY IGNORES DECIMAL SEPARATOR CHANGE
IY40066COSTING CHANGE TO MSJN. INCLUSION OF ADDITIONAL DETAILS IN REGARDS TO EFFHIGH2KEY.
IY40104WHEN A COLUMN IS IN THE SELECT STATEMENT MORE THEN ONCE, AND THEN THE SAME COLUMN IS IN THE ORDER BY, DB2 WILL FAIL SQL0901
IY40107AUTOMATIC INCREMENTAL RESTORE FAILS WITH SQL2571 RC=3 WHEN TABLESPACE NAME IS OF MAX LENGTH
IY40113CRASH RECOVERY FAILED WITH BUFFER POOL LOGIC ERROR SQLBREDOUPDATEEMP ON EMP OF LOB OBJECT
IY40147DB2 CRASH WHEN IMPORTING LARGE NUMBER OF XML RECORDS INTO A DATABASE WHICH IS XML ENABLED.
IY40150DURING ROLLFORWARD ON AN INDEX THAT IS DMS AND PARTIAL, WE COULD NON-EXISTENT PAGE 0 AND CAUSING THE ROLLFORWARD TO FAIL.
JR17478SQL FUNCTION UTILIZING CURRENT SCHEMA TO QUALIFY A TABLE REF. FAILS WITH -204 SHOWING A CORRUPTED NAME FOR THE QUALIFIER.
JR17736PATCH1=1024 IS NOT WORKING IN V8
JR17737AFTER MIGRATION TO V8.1, REBINDING OF PACKAGES FAIL WITH SQL 510IF THE STMT HAS AN UPDATE/DELETE WHERE CURRENT OF CURSOR
JR17802INSTANCE TRAP: SQL0901C, UNEXPECTED AUTHINFO FREE LIST COUNT WHILE DECREMENTING
JR17805PANIC/SLEEP IN SQLDINVCURSORPOS AND IN SQLDENDTRANSACTION. THIS CAN HAPPEN IN A MULTI-PARTITION SETUP.
JR17808THE CONFIG ADVISOR SETS SORTHEAP PARAMETER TOO HIGH, WHEN 'APPLYDB ONLY' IS SELECTED.
JR17809GATEWAY HUNG WHEN DB2STOP FORCE
JR17811THE KILLDB2 UTILITY MAY COLLIDE WITH DB2START ON WINDOWS
JR17812SQL1025 ON DB2STOP FORCE
JR17813DB2 PANICS IN SQLEFSEM2 ON WINDOWS
JR17816ALLOCATION OF INDEX INFO IN SQLRLGETINDEXINFO DOES NOT ACCOUNT FOR ALIGNMENT AND CORRUPTS MEMORY
JR17817DB2MSCS ON WINDOWS 64-BIT EEE CLUSTER FAILS TO CREATE FILE SHARE
JR17827CCA3051N ERROR USING THE CONFIGURATION ASSISTANT TO CONFIGURE THE CS/NT STACK.
JR17829LIST SESSION WINDOW DOES NOT SHOW TARGET SUBSYSTEM NAME
JR17830SQL0204N WHEN TRYING TO DROP A USER DEFINED DISTINCT TYPE WITH MIXED CASE SCHEMA USING THE CONTROL CENTER.
JR17831SQL0355N ERROR USING THE CONTROL CENTER WIZARD TO CREATE A TABLEWITH AN XMLCLOB COLUMN.
JR17832THE TASK CENTER LOAD WIZARD GENERATES AN INVALID LOAD COMMAND FAILING WITH AN SQL0104N ERROR FOR A PARTITIONED DATABASE.
JR17834THE CONTROL CENTER GENERATES AN INVALID KEYWORD, DEFAULTS NULL, WHEN CREATING AN INSTEAD OF TRIGGER.
JR17836JAVA DOC FILE FOR VIDEO CENTRAL IS NOT INSTALLED
JR17840INTERFACES FILE REPLACED WITH EMPTY FILE AFTER MIGRATION
JR17843SQL0901 REGARDING PLAN/ENVIRONMENT MISMATCH WHEN TURNING INTRA_PARALLEL FROM YES TO NO
JR17874INSTANCE TRAP AT SQLCC_GENERATE_SYNCLOG WHEN SP FETCHES LOB DATA
JR17875LOAD CRASHES INSTANCE ON WINDOWS WHEN TABLE CONTAINS IDENTITY COL IN FIRST POSITION AND INTO OPTION NOT USED
JR17878WHEN THE PARSER FINDS THE TWO DECIMALS, IT INSERTS A CAST FUNCIT. THIS CAUSES A SEGMENTATION FAULT.
JR17881IN THE TOOLS SETTINGS FOR COMMAND CENTER IF YOU CHECK TERMINATIOCHARACTER SETTING W/ THE BOX BLANK TOOLS SETTINGS WON'T WORK.
JR17882UNABLE TO ADD NOTIFICATION TO A STEP WITH A LONG NAME
JR17883DWC: EXPORT UTILITY EXPORTS MORE METADATA THAN IT SHOULD.
JR17887FOR QUERIES ON LOCAL VIEWS THAT CONTAIN NICKNAMES, FUNCTIONS CONTAINED IN A SELECT ON THE VIEW WILL NOT BE PUSHED DOWN
JR17888DISTINCT NOT PUSHED DOWN WHEN USING A NICKNAME
JR17890DURING LOAD MODIFIED BY CODEPAGE IBM-930, CHARACTER X4040 NOT STRIPPED OUT BY STRIPTBLANKS MODIFIER
JR17891TRIGGER COMPILATION RESULTS IN SQL0101N DUE TO INFINITE LOOP
JR17895MEMORY LEAK IN DATABASE MONITOR HEAP WHEN HANDLING SQLESETI. ERROR 0XFFFFD621 MAY BE REPORTED IN SQLE_ADD_SETINFO_FIELD
LI70138ENABLING CLI TO HANDLE NULL TERMINATING CHARACTERS TO ENABLE SET PATCH2=52 PRIOR TO FP7, OR PATCH2=53 AFTER FP7
LI70139TRAP WHILE COMPILING A QUERY. SEGV IN SQLNR_REORDER_IJ_QGM()
PQ45854INSUFFICIENT MESSAGES TO DEBUG BUILD ERRORS FOR STORED PROCEDURE BUILDER. - DSNTPSMP
PQ68979DPROPR APPLY -752 - APPLY CNTROL SERVER IS PRE V8
SE08163OSP R510 EXTENDERS XML_EXTENDER INCORROUT