************************************************************ Product Name : DB2 UDB Version 8 for Linux (IA64, 64-bit) PTF Number : MI00070 Package Date : Mon Feb 23 17:54:35 EST 2004 Build Level : s040212 ************************************************************ APAR fixes included in MI00070 (Fixpak 5) APAR No. Abstract -------- -------------------------------------------------- GG04362 REPLICATION CENTER (RC) UNABLE TO USE AN EXISTING TABLE IN 16K TABLESPACE IN SUBSCRIPTION GG04446 DPROPR APPLY GETS SQL0100N ON UPDATE TARGET SCHEMA.IBMSNAP_PRUNCNTL TABLE IF TARGET IS REPLICA. GG04447 DPROPR ADMIN FILES MISSING FROM DB2 8.1 CONNECT PERSONAL EDITION GG04449 DPROPR API ISN'T GENERATING THE CD VIEW DEFINITION DURING SOURCE VIEW REGISTRATION IF THE SOURCE VIEW CREATED ON TOP OF MQT. GG04452 DPRORP REPLICATION CENTER DOES NOT SHOW THE REMOTELY CATALOGED DATABASES. GG04454 SQLN311 WHEN INSERT TO UOW TABLE IN UPDATE ANYWHERE GG04457 DPROPR REPLICATION CENTER ADD SUBSCRIPTION MEMBER FAILS - SOURCE( USING REMOTE JOURNALLING ) AND TARGET TABLE NAMES ARE THE SAME GG04458 DPROPR APPLY ON WINDOWS CRASHES WHEN COMMIT_COUNT IS SET TO NULLAND RI VIOLATION IS ENCOUNTERED IN THE CURRENT CYCLE. GG04459 APPLY GETS SQL0301N WITH DATALINK COLUMNS WHEN TARGET_KEY_CHG=Y GG04461 DAYLIGHT SAVINGS TIME REPLICATION DATA LOSS FOR INFORMIX SOURCES. GG04462 SOME OF DPROPR APPLY THREADS DO NOT TERMINATE EVEN AFTER APPLY IS STOPPED. IC38604 INTERPOLATION IS DONE, BUT THE CALCULATED VALUES FOR THE Z AND M COORDINATES ARE NOT CORRECTLY RETURNED. IY45222 SQL0811 IS RETURNED WHEN A SELECT CALLS A SCALAR SUBSELECT IS RAN. IN THE ACCESS PLAN, THE SS WAS EXECUTED BEFORE WHERE CLAUSE. IY45231 POSSIBLE MEMORY CORRUPTION DURING FMP CLEANUP IY45277 SQL0551 ERROR IS NOT BEING MAPPED TO SQL0440 IN DB2DIAG.LOG IY45922 V7 CLIENT ATTEMPTING TO CHANGE PASSWORD IN CONNECT STATEMENT VIA V8 GATEWAY TO HOST GETS SQL30020 RC=1245 IY46424 HEALTH CENTER DOES NOT REMEMBER CHANGES TO SCRIPT SETTINGS. IY46958 EEE : INCONSISTENCY BETWEEN DB2NODES.CFG AND NODEGROUP INFO IN CATALOG TABLE COULD CAUSE MEMORY CORRUPTION IY47266 SQL0104N WHEN IMPORTING DATA THAT WAS EXPORTED FROM DB2/OS390. COLUMN IS DATE TYPE AND HAS DEFAULT VALUE. IY47621 TO INCLUDE ADDITIONAL OPTION FOR DB2ADVIS COMMAND. PREVENTING PASSWORD TO BE SHOWN WHEN '-A /' IS USED. IY47935 SQL30020N WHEN CONNECT TO DB WHEN THERE'S ALREADY A CONNECTION TO ANOTHER DB IY48285 PERFORMANCE DEGRADES FROM CHOOSING SMALLER AST / MQTIN EEE IY48418 WHEN RUNNING DB2IMIGR THE SYMBOLIC LINKS BETWWEN DB2PSMDR AND DB2STACS STILL POINT TO V7 DIRECTORIES IY48465 INCORRECT RESULTS PRODUCED WHEN USING LIKE AND A WILDCARD, WHEN AN INDEX IS PRESENT. IY48592 INCORRECT RESULTS RETURNED WHEN USING 'WITH' CSE WITH REPLICATED SUMMARY TABLE REFERENCED... IY48715 EXISTS NOT REWRITTEN INTO A JOIN WHERE A JOIN PREDICATE EXISTS WITHIN THE EXISTS PREDICATE WHERE COL TYPE IS CLOB.. IY48739 SQL0901 WHEN DROPPING A MDC TABLE, MESSAGE 'NO ROWS EXIST IN SYSCOLUSE' IN DB2DIAG.LOG. IY48896 SQL0456 WHEN RUNNING DB2 MIGRATE DB COMMAND IY49028 INSTANCE CRASH WHEN SENDING PAGING ALERT FROM HEALTH MONITOR IY49080 UPDATE IS NOT UPDATING THE RIGHT NUMBER OF ROWS WHERE IT'S USINGA SELF REFERENCING SUBQUERY IN A PARTITIONED ENVIORNMENT.. IY49094 RUNNING DB2AUDIT DOES NOT CREATE THE CONTEXT.DEL FILE CORRECTLY FROM THE DB2ADUIT EXTRACT. IY49107 SQL0901N: THREE WAY INNER JOIN REFERENCING A COMMON TABLE EXPRESSION CONTAINING UNION ALL. IY49170 -551 WHEN CALLING SP WHEN NESTED SP WAS DROPPED/RECREATED AGAIN. IY49190 ERROR SQL0344N WHILE ACCESSING VIEW WITH ABS FUNCTION ON DATABASE THAT WAS MIGRATED FROM V7 TO V8 IY49206 INSTALL ON LINUX390 USING A RESPONSE FILE ONLY INSTALLS 2 FILESETS AT A TIME.. IY49231 GETTING SQL0344N WHEN YOU SELECT A DATE FROM A COLUMN BASED ON AVIEW IF THE DATE IS THE SAME AS THE VIEW WAS CREATED WITH IY49234 CARDINALITY DOES NOT INCREASE AFTER A TQ TO A SINGLE NODE. (HASH DIRECTED TQ ON A CONSTANT) IY49290 HEALTH CENTER SENDS PARTIAL OR INCOMPLETE EMAIL NOTIFICATIONS. IY49344 DB2AUDIT EXTRACT COMMAND CREATES SEGMENTATION FAULT WITH CORE DUMP IN SOLARIS OPERATING SYSTEM IY49368 RESTORE REPLACE EXISTING MAY LEAD TO DIFFERENT COLLATING SEQUENCE ON EEE NODES IF ADDING A NEW NODE AFTER THE RESTORE. IY49407 PMAP SHOWS APPLICATION HEAP GROWING AFTER EACH CALL TO SQL PROCEDURE. IY49450 INSTANCE CRASH DURING BUILD PHASE OF LOAD - MEMORY ALLOCATION FAILURE REPORTED IY49531 DELETE-SELECT STATEMENT IN CLP CAN RESULT IN SQL0508N IY49537 INSERT COLUMN LIST FOR CROSSLOADER FEATURE OF CLILOAD NOT BEING HANDLED PROPERLY IY49564 CANNOT CONNECT TO THE DATABASE LOCALLY WHEN USING THE PASSWORD THROUGH THE REMOTE LDAP. IY49619 BAD PERFORMANCE: NOT PUSHING DOWN THROUGH UNION ALL IY49631 DB2NODE ENVIRONMENT VARIABLE IS NOT VISIBLE TO CLI LAYER IY49689 FREE LOCATOR STATEMENT WITH MULTIPLE PARAMETERS FAILS WITH CLI0118 IN THE CLI LAYER. IY49721 PERFORMANCE DEGRADES IN V8 FOR DISTINCT QUERY WITH UDF PREDICATE IY49744 REFERENTIAL INTEGRITY JOIN ELIMINATION RULE IS NOT CONSIDERED FOR INSERT-SELECT STATEMENT IY49935 DURING CODE CONVERSION, LOAD UTILITY TRUNCATE GRAPHIC TYPE DATA IF SOURCE DATA IS BIGGER THAN TARGET COLUMN DEFINITION IY49990 CLI0109E EXECUTING SQL STATEMENT USING XA CONNECTION FROM JAVA WITH DISABLEUNICODE=1 IY50020 SIGNAL #11 TRAP IN SQLNO_FIND_HASH_TABLE IY50032 ONLINE BACKUP OCCASIONALLY FAILS. DIAG.LOG WILL SHOW SQLUBWRITEENDLOGRECORD IY50037 INCORRECT RESULTS PRODUCED WHEN SMP > 1. OCCURS AT ON A PARTITIONED SORT. IY50064 DB2ADUTL GRANT ALL ON ALL FOR ALL GIVES ERROR 124 DUE TO TSM API INCOMPATIBILITY. IY50101 TRAP IN SQLE_DB2RA_AS_CONNECT_REPLY AFTER MIGRATE TO V8.1 FP3 FR IY50141 -501 IS INCORRECTLY RETURNED DURING IMPORT. CORRECT ERROR CODE SHOULD BE -911. THIS APPLIES TO SYSTEMS PRIOR TO V8 FP4. IY50203 DATABASE NEEDS MORE MEMORY TO START UP IN V8 THAN IN V7 IY50224 SQL0901N IN SQLNG_PROCESS_PARSE_TREE_NODE IY50247 HEALTH CENTER FAILS TO DISPLAY ANY TABLESPACE OR TABLESPACE CONTAINER INFO WHEN PROCESSING OF ANY ONE OBJECT FAILS IY50250 SQL0901N IN SQLNO_PART_SAT_REQAT PROBE 400 WHEN EXECUTING A SEL ECT QUERY IN A PARTITIONED ENVIRONMENT. SQLNN_E_BADNEWSIN TRACE IY50295 SLOW PERFORMING QUERY DUE TO TQ OVERFLOW, SPILLAGE.. IY50298 SP SYSIBM.SQLTABLES HANGS FROM A 32-BIT CLIENT TO A 64-BIT IY50403 UNNECESSARY MESSAGES (SQLEHMONCALLMODULE PROBE:20) TO DB2DIAG. IY50427 SQLUGTPIWILL ALWAYS MISTAKENLY RETURN SQLTYPE VARGRAPHIC FOR PARTITION KEYS THAT ARE GRAPHIC. IY50445 SQL1224N OR DIA8300C MEMORY HEAP ERROR FROM SQLEGETAPPCB , SQLJSINITAPP , SQLEBUILDANDREGISTERAPPGROUP , SQLCCINIT IY50512 HIGH COMPILE TIME FOR QUERIES REFERENCING MQTS IY50518 SIGNAL 11 TRAP IN ENV_GETCOMPILERVARIABLES USING DEVELOPMENT CENTER TO VIEW THE PROPERTIES OF A CONNECTION IN PROJECT VIEW IY50519 PANIC (CRASH) IN DB2 CALLED FROM SQLEASSOCAPP IY50527 TRAP IN SQLEUCAPPLICATIONENTRY WHEN A DESTRUCTOR ISSUES AN SQLDISCONNECT IY50531 SQL30020N RC=124C WHEN BIND V7 BIND FILES TO V8 DATABASE WITH BIND OPTION, QUERYOPT SET IN THE BIND FILE. IY50532 INSTANCE TRAP IN SQLOFMBLKEX CAUSED BY SQLMON_DCS_APPDTV() ON GATEWAY IY50534 UNRESOLVED LINK SQLGMFWHILE BUILDING MF COBOL APPLICATION IN HPUX ENVIRONMENT IY50576 'OPEN REMOTE CURSORS WITH BLOCKING' ELEMENT RETURNS INCORRECT RESULTS USING V7 CLIENT WITH V8 SERVER. IY50597 INSTANCE CRASH WHEN USING XML2CLOB() FUNCTION IN A QUERY IY50650 POTENTIAL PERFORMANCE DEGRADATION IN SQL COMPOSITION CAUSED BY FALSE CONVERSION ERROR DETECTION. IY50659 PRUNING HISTORY FILE TAKE LONG TIME DURING BACKUP IF IT HAS MANYFOR SIMULTANEOUS LOADS WITH MULTIPLE LOAD COPY TARGETS. IY50703 SQLFETCHSCROLL IN CLI 7.2 GETS SQL30020 RC=1245 FROM DB2 V8.1 FP3 SERVER IY50746 SPECIFYING MESSAGE FILE USING AUTLOLOADER IS IGNORED. IY50750 INVALIDATE ROUTINE CACHE WHEN ALTER ROUTINE USED IY50761 WITH XA CONNECTION CLI IGNORES THE CONNECTNODE SETTING IY50818 ERRONEOUS -507 WHEN EXECUTING A POSITIONED UPDATE/DELETE FROM AN SQLJ NON-CMP BEAN. IY50823 DRDA SQLJSPARSECONRDBNAM FAILS TO MATCH RDBNAM WITH DBALIAS. IY50832 HANG DUE TO DEADLATCH CONDITION ON DB WITH WRITE SUSPEND ENABLED AND TRACKMOD TURNED ON IY50835 DATABASE CRASHES WITH DIA8709E SEGMENTED TABLE PAGE NUMBER WAS TOO HIGH. ZRC=0X84020009 IY50934 DB2 64-BIT ON AIX CREATES A 64GB SHARED MEMORY SEGMENT FOR DATABASE MEMORY - ALLOW SETTING DATABASE_MEMORY TO OVERRIDE THIS IY50958 PATCH2=33 CHANGES BOTH TIMESTAMP AND TIME TO ISO, WHEN WE ONLY WANT TO CHANGE TIMESTAMP IY50964 RUNNING QUERY INVOLVING AVG() OF A FEDERATED TABLE'S COLUMN CAUSES INSTANCE CRASH IN SQLND_CHECK_DIV_PID_FOR_AVG. IY50994 TRAP IN SQLNO_CRULE_STARJN_AND. THIS IS DUE TO A NULL POINTER FOR THE PLAN LIST RETURNED BY SEMIJOIN FUNCTION. IY51008 ABEND: INSTANCE CRASHES WITH SIGNAL #11/SIGSEGV IN COLLECTFFDC() IY51012 ABEND: INSTANCE CRASHES WITH SIGNAL #11/SIGSEGV IN INIT_SQLM_APPL_LOCK() IY51021 REMOVE REDUNDANT COMPLEX PREDICATES & REMOVE COMPLEX LIKE PREDICATES. IY51023 REMOVE REDUNDANT JOIN BASED ON RI CONSTRAINT. FK TABLE DOES NOT NEED TO JOIN TO PK TABLE, WHEN JOIN PRED IS FK & PK. BOOST PERF. IY51027 XA TRANSACTION EXCEPTION XAER_PROTO - DIAGLOG ERROR: ATTEMPTED INVALID OPERATION ON WITHHOLD CURSOR: XA_OP = 0, XA_STATE = 0 IY51033 SIGNAL #11 IN SQLERLIBRARYSEARCHINBUCKETHASHTABLE IY51068 LOAD FAILS WITH SQL0911(LOCKTIMEOUT) DUE TO UNECESSARY LOCKING OF SYSTABLES IY51114 ABEND : SQL1224 ON MIGRATE DATABASE COMMAND - FIXPAK 4 ONLY . TRAP IS IN SQLRLM_MIGRATE_6TO8_SYSTABLES_PD IY51156 OUTER JOIN ELIMINATION USING GROUP BY CONDITION IY51202 QPSTART FAILS WITH DQP0007E OR SEGMENTATION FAULT IY51225 SIGNAL 11 IN SQLOFMBLKEX AFTER SQLCCINIT FAILURE IY51246 OPTIMIZATION LEVEL OF ONE STATEMENT IS DEPENDENT ON THAT OF ANO-THER STATEMENT IN THE SAME CONNECTION. IT SHOULD BE INDEPENDENT IY51249 LOWER THE DEFAULT CALCULATED SETTINGS FOR FCM_NUM_ANCHORS, FCM_NUM_RQB & FCM_NUM_CONNECT TO ALLOW HIGHER FCM_NUM_BUFFERS IY51253 TRAP IN SQLEDDB2RAASSP IY51286 DL_TOKEN DOES NOT PICK UP THE NEW VALUE. IY51297 SQL0802N ON INVOCATION OF STORAGEMANAGEMENT STORED PROC FROM CC WHEN CARDINALITY OF TABLE IS > 35000000 IY51322 DB2 MPP LOAD FAILED WITH -6555 EVEN AFTER STOP & RESTART THE TAKEOVER NODE IN A FAILOVER ENVIRONMENT SETUP. IY51331 INSERTING A BLOB RESULTS IN SQL0452N. IY51336 SETTIMESTAMP() FUNCTION OF JCC DRIVER USING DEFAULT TIMEZONE WAS NOT CONSTURCTING THE PROPER JDBC VALUE FOR SET & GET METHODS IY51349 CURSOR ARRAY CORRUPTION IY51383 SQL30082 REASON CODE 24 WHEN CONNECTING WITH A COBOL APPLICATION AND SPECIFYING PASSWORD USING A HOST VARIABLE. IY51444 THE TRACE IPC SHARED MEMORY SEGMENT AND SEMAPHORE ARE NOT GETTING PROPERLY CLEANED UP ON DB2STOP. IY51462 INSTANCE ABEND:TRAP IN SQLRA_CACHE_FILL_SEC USING BUFFERED INSERT. IY51485 SQL0083C - LOAD WITH LOBS AND CODEPAGE OPTION IY51488 WHEN A CONNECTION TO A REMOTE SERVER BECOMES INVALID, THE CATALOG CACHE BECOMES INVALIDATED CAUSING LINGERING MEMORY PTRS. IY51499 DB2 ABENDS AFTER FEDERATED QUERY RETURNS CLI ERROR WHEN NO USER MAPPING IS DEFINED OR A SECURITY VIOLATION IS DETECTED REMOTELY IY51522 DUMP SQLCA TO DB2DIAG.LOG WHEN MAXAPPLS EXHAUSTED(SQL1040) IY51544 JCC TYPE 4 APPLICATION GETTING 'NO POSITIONED UPDATE SECTION IS AVAILABLE FOR THE REQUESTED QUERY SECTION IN THE PACKAGE' IY51571 MEMORY LEAK IN DBHEAP USING HASH JOINS WHEN CONNECTION CONCENTRATOR IS USED IY51581 IN V8.1FP4 WE EXPANDED THE LIMITATION FOR COLDEL BUT WE MISTAKENLY INCLUDED SINGLE BYTE CODE PAGES IY51588 APPL FROM OS390 RUNING AGAINST THE UDBV81 FP4 RUNS OUTOF MEMORY HEAP FOR RESYNC HEAP WHEN APPL CONNECTS TO DBALIAS NOT DBNAME IY51590 LIBDB2COMPR.SO LIBRARY IS NOT INSTALLED WHEN APPLYING FP4 WHICH DOES NOT ALLOW THE COMPRESS OPTION TO WORK ON 64BIT INSTANCES IY51629 TRAP IN SQM_REMOTE_APP_RST::ADD_AGENT_COUNTERS DURING RESET MONITOR SWITCHES IY51630 DB2 PANICS WHEN CALLING SQLOFMBLKEX, WHICH WAS CALLED BY SQLEDDB2RASERVERDRIVER IY51649 CLP THROUGHPUT PERFORMANCE DEGREDATION ON LARGE SQL RESULT SETS. IY51682 SIG#11 IN SQNR CRASH THE DB2 INSTANCE IY51683 DB2 CONNECT CRASHES IN CSMFETCH. IY51707 DB2LOOK COREDUMP WITH -M OPTION AND LARGE TABLE DEFINITION IY51720 DATABASE MARKED BAD WITH SELECT ON VIEW WITH UNION ALL. SQL1034 IY51724 XAEXCEPTION XAER_PROTO WITH DB2 V8 UNIVERSAL JDBC DRIVER IY51771 NETNAME DEFINED IN DB2NODES.CFG IS OVERRIDEN / OVERWRITTEN BY ETHERNET HOSTNAME IY51830 IN 64-BIT FEDERATED SYSTEM, WHENEVER A REMOTE DATASOURCE RETURNS AN ERROR TO THE FEDERATED SERVER, IT WILL CRASH THE INSTANCE. IY51849 ERROR CODEPATH IN DUPCHECKPREVNORM FUNCTION WHICH IS DUMPED IN THE DB2DIAG.LOG WITH A DIA8575C INDEX MANAGER ERROR IY51861 JCC SQLEXCEPTION INVALID OPERATOR (-99999) AFTER APPLY OF FP4 IY51878 JCC TYPE 4 DRIVER RECEIVES -725 ERROR WHEN ATTEMPTING TO SET APPLNAME USING A DEFAULT VALUE IY51918 '0X9000028C TIMEOUT OCCURED WHILE CALLING A GCF' IN DB2DIAG.LOG. IY51926 DATABASE CRASH DURING ALTER TABLE ADD FOREIGN KEY CONSTRAINT IY51928 CUSTOMER USING HEALTH CENTER GETS SQL1092, SEEMS TO USE THE LOCAL LOGIN ID INSTEAD OF THE REMOTE SERVER ID FOR AUTHORIZATION IY51999 SQL1131 DARI CRASH WHEN RUNNING SQL STORED PROCEDURE THAT HAS A SQL WARNING HANDLER IY52060 DB2ADMIN STOP HANGS WITH V8 GATEWAY WHEN USING V7 CONTROL CENTERAGAINST DB2/390 IY52069 WHEN PERFORMING LOAD FROM A NAMED PIPE USING THE LOAD API, IT MAY APPEAR TO RETURN 0 BUT NOT LOAD ANYTHING. IY52071 TCB FIX COUNT != 1 WHEN DROPPING DATA OBJECT! RETURNED FROM SQLDDROPTABLE IY52103 SQL1034C / -902 PANIC DATABASE CRASH FORCING OFF APPLICATIONS IN MPP ENVIRONMENT . IY52178 MEMORY LEAK : SQL0973 , SQL0954 : WE ARE LEAKING MEMORY ON EVERYCLOSE / OPEN CURSOR ON A USER / GLOBAL TEMPORARY TABLE IY52180 TABLESPACE FULL SQL0289 DURING LOB INSERT DUE TO BAD LOGIC IN FINDING FREE SPACE RELATED TO LOWTRANLSN PROBLEM. IY52181 NEED TO SEPARATE RETURN CODE FOR DB2GCF FAILURE CASE IY52221 A PREDICATE GOES MISSING IN OPTIMIZED STATEMENT WHEN THE SAME PREDICATE EXISTS IN THE TEMP TABLE, CAUSING INCORRECT RESULT IY52303 DB2 ABENDS WRITING LOG RECORD TO THE LOGS AT THE END OF CRASH RECOVERY IF LOGS ON RAW DEVICE. SPECIFIC TO FP4 (S031027) IY52306 STORED PROCEDURES ON Z/OS DO NOT RETURN RESULTSET TO JCC T4 APP. IY52309 SQL0901N IS RECEIVED WHEN TRYING TO DROP A NICKNAME IY52423 FROM CLP, CALLING CAPTURE_STORAGEMGMT_INFO GETS SQL0443N -803 WHEN TAKING SNAPSHOT AND TABLESPACE ONLY INCLUDES INDICES IY52424 BAD PERFORMANCE BECAUSE OF LOST PREDICATE IN QUERY PLAN. IY52441 HIGH PREPARE TIME WITH OPTIMIZE FOR N ROW QUERIES IY52457 CONTROL CENTER DISPLAYS INCORRECT MINIMUM AND MAXIMUM PAGE SIZESFOR A TABLE IF THE TABLESPACE PAGE SIZE IS NOT 4K IY52480 SIGNAL 11 DURING CONCURRENT DROP TABLESPACE AND LIST TABLESPACE CONTAINERS IY52482 SLOW PERFORMANCE COMPOSITION BOTTLENECK DUE TO ROW LOCKING IY52494 IN DISK FULL SITUATION, ENGINE MISTAKENLY CREATES A NEW PAGE FORAN OBJECT, WHEN THERE IS NO SPACE. IY52497 INCORRECT RESULTS OR INSTANCE CRASH WHEN RUNNING A QUERY IY52508 DB2 VERSION 8.1.4 CRASHED ISSUEING DB2 FORCE APPLICATIONS ALL IY52571 ERROR SQL0104N DOING ON A ZOS HOST A BIND OF A DECLARE STATEMENT WHOSE CURSOR NAME CONTAINS A HYPHEN IY52694 RELAXED RESTRICTION ON FFNRO IN EEE (FETCH FIRST N ROWS). THIS INCREASES PERFORMANCE BY REMOVING A DIRECTED TQ IN A EEE ENV. IY52703 ENTITY EXTRACTUDF NEED TO REINSTATE DTD IN NORMAL CALL IY52725 SQL0525N ON GETCOLUMNS() AGAINST OS/390 DB WHEN _ OR % ARE USED IY52785 ADDING COLUMN COMMENTS THROUGH CONTROL CENTER DO NOT GET PROPERLY FORMATTED. IY52788 ONLINE DATABASE BACKUP FAILS WITH SQL0902C IY52796 DB2EXMIG FAILS TO MIGRATE PARTITIONING INFORMATION FOR THE EXPLAIN TABLES. IY52798 SQL30020N RC=1245 RECEIVED INTERMITTENTLY WHEN CONNECTING FROM DB2 CLIENT TO AN OS/390 DB VIA DB2 CONNECT V8.1 FP2 USING SNA. IY52815 WRONG RESULTS RETURNED BY QUERY DUE TO INCORRECT PREDICATE INFORMATION IY52826 SQLTRANSACT WITH SQL_ROLLBACK GIVES A SQL0501NWHEN MULTICONNECT SET TO 3 IN DB2CLI.INI IY52987 DB2 BROADCASTING WHEN USING HOST VARIABLES INSTEAD OF HASH DIRECT WHEN USING LITERALS.. IY53069 INCORRECT QUERY PLAN CHOSEN WHEN USING SELECT DISTINCT AND A SUBQUERY WITH FETCH FIRST N ROWS IY53088 FORMING A COMMON SUB EXPRESSION IN SCALAR SUBQUERIES WHICH HAVE IDENTICAL CORRELATION MAY PRODUCE DIFFERENT RESULTS. IY53281 LOB TYPE COLUMN DECRIPTORS' LOGGED FIELD IS SET TO 0 DURING MIGRATION, CAUSING PROBLEMS WITH DB2LOOK AND DROP TABLE RECOVERY IY53325 INSTALLER CAN'T CREATE TCP PORTS FOR INSTANCE IF /ETC/SERVICES IS A RELATIVE SYMBOLIC LINK IY53433 EXP_LI* FILES MISSING FROM EXPRESS PACKAGING. IY53456 INCORRECT RESULTS RETURNED WHEN REWRITING SCALAR SUBQUERY THAT IS PUSHED THROUGH A UNION ALL. IY53631 INDEX CORRUPTION MAY OCCUR IN TYPE 2 INDEXES WITH >= 3 LEVELS IY53676 DB2 TRAPS IN DESTROYAPPL WHILE FREEING AN AGENT IY53729 DB2LOOK SHOULD GENERATE "REFRESH TABLE" STATEMENT WHEN A NEW INDEX IS CREATED ON A TABLE IN CHECK PENDING STATUS. IY53734 DB2 COMES DOWN, WHEN AN UNEXPECTED SIGNAL IS DELIVERED TO THE DB 2IPCCM PROCESS DURING SOME SYSTEM CALLS. IY53839 MIGRATION FAILS. DXXMIGV RETURNS ERROR: FAILED TO DROP TRIGGER IY53845 EXPORT FROM OS/390 GETS SQL0551 IY53847 SQL0901N SQLRL_DGTT_RCV: BUFFER POOL ERROR WHEN DECLARING & DROPPING GLOBAL TEMP TABLES REPEATEDLY WITH DB2NODE SET. IY53863 USER MAYBE ABLE TO DROP A TABLE WITHOUT THE PROPER AUTHORITY IY53894 NAMED PIPE AUTHENTICATION INSTEAD OF USING AUTHENTICATION OF THE USER IT IS LOGGED IN AS. IY53919 DB MIGRATION HANG, DIA3522C ERROR, .MIG FILE ALREADY EXISTS JR05501 UDB INSTANCE CRASH ON SQLNP_INITLEX WHEN MAINFRAME CLIENTS TRY TO BIND/COMPILE AGAINST UDB DATABASE JR05503 INSTANCE TRAP IN SQLJRMONPARSESETCLIENTINFOEX() WHEN TRYING TO SET CLIENT ACCTNG ON OS390 FROM GATEWAY JR18732 HEALTH MONITOR TRAP IN OSSMEMFREE CALLED BY HMONSNAPROUTER JR18739 'LOCK WAIT TIME' FIELD IN DEADLOCK EVENT MONITOR OUTPUT IS ALWAYS BLANK JR18875 XML EXTENDER ADMINISTRATION WIZARD CALL DB2XML.DXXENABLEDB INSTEAD OF CALLING QDBXML.DXXENABLEDB. SQL0204 JR18886 DB2FMCD DOES NOT EXECUTE DB2PROFILE JR18989 GET SNAPSHOT FOR ALL REMOTE APPLICATIONS AND DATABASES GIVE DB21017E OR SQL1032 ERROR AND INSTANCE GOES DOWN. JR19000 DWC V8, SCHEMA ERROR -109 JR19002 DWC - WAREHOUSE WILL APPEAR TO HANG DURING A RUN DUE TO SOCKET 10038 ERROR JR19003 DWC - IF STEP HAS 'ON FAILURE, OR ON COMPLETION' IF DWC07251 RC2=7905 JR19057 INSTANCE CRASH IN SQLERRETURNFMPTOPOOL JR19058 SQL30020N REASON CODE 124C RECEIVING MORE THAN 32K FROM HOST. JR19061 DB2LOOK FAILS TO DOUBLE SINGLE QUOTES FOR COLUMN COMMENTS JR19077 ESTIMATED SIZE OF TABLE IN THE CONTROL CENTER DOES NOT DEPEND IF THE TABLE WAS CREATED WITH OR WITHOUT VALUE COMPRESSED JR19082 ARRAY INSERT/UPDATE/DELETE RETURNS SQL_NO_DATA_FOUND IF AT LEASTONE OF THE ELEMENTS GENERATED THIS WARNING JR19083 CREATING DATABASES SIMULTANEOUSLY FAILS SPORADICALLY JR19089 AFTER DISABLE AND RE ENABLE OF XML EXTENDER COLUMN , UPDATE TRIGGER FAILS IS SET XMLCOLUMN = XMLCOLUMN JR19092 SQLGETINFO CALL FOR SQL_DRIVER_ODBC_VER RETURNS 3.00 FOR V8.1 JR19103 SYMPTOM: STEPS IN A PROCESS REARRANGE WHEN METADATA IS MIGRATED FROM V7 AT FP5 WINDOWS TO V8 FP2 WINDOWS TO V8 AIX AT FP2. JR19104 RUNID IN WORK IN PROGRESS APPEARS TO BE REUSED. JR19107 A NEW TABLE FUNCTION SNAPSHOT_QUIESCERS GENERATE TWO WRONGS COLUMN NAMES: OUIESCER_TBS_ID AND OUIESCER_STATE JR19139 CANNOT INVOKE STORED PROCEDURE WITH MORE THAN 697 PARAMETERS JR19148 CONDITION HANDLER DECLARED INSIDE IF STATEMENT FOR SQL STORED PROCEDURE CAUSES DB2 TO ABEND JR19151 INCREASE LENGTH OF REMOTE_AUTHID TO ACOOMODATE LOTUS NOTES IDS. JR19168 WHEN DAS STARTED BY FAULT MONITOR, IT TAKES C LOCALE EVEN DEFAULT LOCALE IS JAPANESE. JR19192 IGNOREWARNINGS KEYWORD WITH SQLEXTENDEDFETCH NOT WORKING JR19207 INCORRECT MESSAGE (SQL0902N RC 188) WHEN THERE IS TRUNCATION FORINOUT PARAMETER OF SP (>30) CALLED FROM THE CLP JR19208 GETROW() IS RETURNING THE WRONG RESULTS WHEN TYPE_FORWARD_ONLY IS SPECIFIED AND THE ENTIRE RESULTSET IS NOT RETRIEVED. JR19211 IMS COMMAND CENTER DOES NOT LAUNCH IN DB2 ADMIN CLIENT IF THERE ARE NO DB2 NODE, DATABASE ENTRIES JR19232 CLI0005W PROPAGATED INTO VB APPLICATION USING IBM OLE DB PROVIDER (WHEN QUERYTIMEOUTINTERVAL=0) JR19233 DB2 CRASHES LAUNCHING SEVERAL MS ACCESS REPORTS DUE TO LARGE SORTS (>1MB) AT THE SAME TIME. TIMING ISSUE JR19245 I-SERIES CLIENT CONNECTING TO DB2 UDB 8.1 RECEIVES SQL0302 ERROR IF HOST VARIABLES ARE USED IN SQL FOR ZONED DECIMAL COLUMNS. JR19252 DB2 RETURNS A WARNING WHEN AN INFORMATIONAL MESSAGE IS ENCOUNTERED. JR19256 NEW CLI KEYWORDS BLOCKFORNROWS AND SQLOVERRIDEFILENAME JR19260 SPARODIC CRASH IN SQLMON_DCS_APP ON CONNECT FROM CLIENT JR19264 .NET DB2COMMANDBUILDER RETURNS ALL STORED PROCEDURE NAMES IF SCHEMA NAME IS NOT SPECIFIED JR19284 WAREHOUSE CREATES INEFFICIENT SQL - NESTED WHERE CLAUSES JR19291 WINDOWS: CAN NOT COMPLETE INSTALL/ISSUE DB2START WITH HYPERTHREAD ENABLED. JR19293 HEALTH MONITOR CRASHES INTERMITTENTLY IN WINDOWS 2000IN FUNCTIO N HMONFQNFINDSEPREV JR19299 CONTROL CENTER DISPLAYS INCORRECT NUMBER OF PARAMETERS FOR A STORED PROCEDURE WHEN PROCEDURE NAME AND SPECIFIC NAME ARE SAME JR19300 NO INDICATOR THAT REPLICATION CENTER IS BEING LAUNCHED IF ANOTHER GUI TOOL ALREADY LAUNCHED JR19321 CLI0112E OCCURS ON A COMMA IN A DECIMAL OPERATION WHEN USING A LOCALE THAT DEFINES A COMMA AS THE DECIMAL SYMBOL JR19328 WINDOWS, CORRUPTED STACK CAUSES TRAP JR19338 DISABLE THE DISCOVERY AND IT WILL NOT ALLOW A V8 RC TO ADMINISTER A V7 REPLICATION ENVIRONMENT JR19341 DB2LOOK DOES NOT OUTPUT CREATE VIEW STATEMENTS FOR VIEWS WHICH DO NOT DEPEND ON PHYSICAL TABLES JR19347 TRAP WITH SNAPSHOT TABLE FUNCTION JR19352 DWC - TARGET DOES NOT SHOW UP IN PULL DOWN, IF CREATED AS ODBC -> DB2 FAMILY -> DB2 FOR ESE. JR19370 DWC SQL0803 . RUNNING A SERIES OF JOBS RESULTS IN -803 JR19371 DB2EXMIG FAILS IF NOT ALL EXPLAIN TABLES EXIST JR19381 ODBC APPLICATION RECEIVES SQL5000C, SQL30020N RC=124C IF SQL_ATTR_ROW_ARRAY_SIZE > 32K JR19387 CANNOT ADD USERS ON THE SECURITY PANEL OF TASK CENTER JR19391 LEFT OUTER JOIN RETURNS WRONG VALUE JR19436 DWC V8.1 FP4 MIGRATION DROPS METADATA TABLE INDEXES JR19474 SETTING NUM_POOLAGENTS=0 IN CA RETURNS CCA5007N JR19477 TERMINATING FRONTEND TOOL (E.G. CLP) WITH LONG RUNNING SQL WILL NOT NECESSARILY SIGNAL DB2BP, THUS NOT FREEING REMOTE RESSOURCES JR19478 USING GUI TOOLS TO 390/ZOS CANNOT USE A USERID STARTING WITH @ WILL GET SQL30082 JR19500 SQL1325N ERROR AS SERVER DISCOVERY IS INITIATED AGAINST V7 INSTANCES IN REPLICATION CENTER JR19507 SELECT DISTINCT ON SINGLE INT MIGHT CAUSE INCORRECT RESULTS JR19512 COMPLEX EXPRESSIONS WITH UNIONS ARE NOT PUSHED DOWN JR19513 WHEN USING DISTINCT WHEN QUERYING A NICKNAME, PERFORMANCE IS BAD JR19514 DB2 CONFIGURATION ASSISTANT (CA) CRASHES WHEN PERFORMING BIND WITH CLI STATIC PROFILING ENABLED JR19520 LOAD STEP UNABLE TO GENERATE TARGET TABLE ON PROMOTION TO TEST/PRODUCTION AFTER EXPORT AND IMPORT. JR19521 OBJECT NAMES WITH QUOTES GETS CORRUPTED ON EXPORT AND IMPORT JR19522 DWC - MIGRATED CONTROL DB FROM VISUAL WAREHOUSE, STEPS MAY NOT WORK. JR19523 DWC - WHEN USING THE LOCATE FUNCTION WITHIN DWC IF A WILD CARD IS USED (IE. %DEPT) WRONG RESULTS ARE RETURNED. JR19548 DEVELOPMENT CENTER WRONGLY PASSES PARAMETER 12 BUILDUTILITY AS AONE-PART IDENTIFIER TO DSNTPSMP CAUSING PROBLEM WITH BUILDOWNER JR19561 WHEN SHUTTING DOWN THE MACHINE, DB2SYSC AND DB2DAS ARE NOT SHUTTING DOWN PROPERLY. JR19562 WHEN USING DB2 UDB V7.2 FIXPAK 8 OR EARLIER WITH A DB2 CONNECT V8.1 GATEWAY, DATA IS RETURNED IN AN UNEXPECTED FORMAT. JR19577 ENGINE HIT EXCEPTION IN SQLNS_RESET_SCOPE() DURING QUERY REWRITE PROCESS JR19689 INSTRUCTION AT "0X120507C7 REFERENCED MEMORY AT "0X00000000" COM.IBM.DB2.JDBC.DB2EXCEPTION: SQL1131N DARI (STORED PROCEDURE) JR19693 FP3 AND FP4 IN V8 DO NOT PICK UP THE REBOOT=Y PARM IN THE RESPONSE FILE, SO DO NOT REBOOT. LI70030 DB2LICM -L REPORTS WRONG NUMBER OF PROCESSORS ON LINUX INTEL BOXES, WHEN HYPERTHREADING IS NOT ENABLED. LI70092 CONNECTION TO OS390, USING LOOPBACK AND CONNECTION CONCENTRATOR FAILED WITH SQL ERROR SQL30081N LI70093 SQL -805 RETURNED USING SQLSETCONNECTATTRW WITH SQL_ATTR_CURREN T_PACKAGE_SET WITH UCS2 ON DB2 V8.1 FP4 LI70223 DIA8529C NO ACTIVE SAVE POINTS RETURNED BY SQLRR_PROC_APP_SVPT LI70235 HEALTH CENTER DISPLAYS GARBAGE DATA WHEN USING JAPANESE VERSION OF DB2 V8.1 (FP1+) LI70279 SQLCOLUMNS WILL FAIL WITH SQL0443N SYSIBM:CLI:-727 SQLSTATE=38553 LI70281 MESSAGES COMMAND LINE OPTION IS BEING IGNORED AND RECEIVING SQL2036N RETURN CODE WHEN RUNNING AUTOLOADER FROM SCRIPT LI70283 EXCESSIVE FLOATING-POINT ASSIST FAULT OCCURING ON LINUX IA64 LI70296 DB2BUILD TRUNCATES S. PROCEDURES WHEN IMPORTING THEM TO OS/390 LI70297 CONPE + WSE/ESE/PE/CONEE DOESN'T ALLOW CUSTOMER TO CREATE A SERVER INSTANCE LI70322 STARTING THE CONTROL CENTER DISPLAYS WINDOWS TO ATTACH TO INSTANCES LI70323 SEGV IN ALLOCATEMEMORYBLOCK ON RHEL3 (RED HAT ENTERPRISE LINUX) PQ82290 FIX PACK 5 (FP5) FOR DB2 ADMINISTRATION SERVER FOR Z/OS V8 APAR fixes included in MI00076 (Fixpak 4a) APAR No. Abstract -------- -------------------------------------------------- JR19507 SELECT DISTINCT ON SINGLE INT MIGHT CAUSE INCORRECT RESULTS APAR fixes included in MI00061 (Fixpak 4) APAR No. Abstract -------- -------------------------------------------------- GG04379 PERFORMANCE LAG DELETING REGISTRATION WITH CD TABLESPACE CHECKED. GG04387 DPROPR REPLICATING GRAPHIC COLUMNS ON I-SERIES TO CHAR COLUMNS ON WINDOWS UTF-8 DATABASE GG04398 ADD INDICATORS (HOUR GLASS) TO FIX FOR APAR#GG04390 (PERFORMANCE ENHANCEMENT). GG04401 ASNCLP & REPLICATION CENTER FAIL WHEN REGISTERING A TABLEAND US ING AN EXISTING TABLESPACE WITH MORE THAN 200 CONTAINERSFOR CD GG04402 THE STATE AND STATE_INFO STATUS FIELDS WERE DISPLAYED INCORRECTLY WHEN CONNECTING TO A 400 MACHINE. GG04403 RC API AFTER DOING A MANUAL REFRESH OF A TABLE USING RC, THE SUBSCRIPTION IN THE F DIRECTION IS NOT ACTIVATED GG04406 INCONSISTENCY WITH THE BUFFERPOOL ALLOWING EDITS WHEN THERE IS A VALID OR DROP-DOWN LIST. GG04408 INCLUDE ASNDBCON.BND, ASNSQLCD.BND, ASNSQLCF.BND AND ASNMSGT.BNDIN APPLYUR.LST GG04409 DPROPR APPLY GETS SEGMENTATION FAULT WITH COMMIT_COUNT AND RI, CCD SOURCE TABLE AND USER COPY TARGET TABLES GG04415 REPLICATION CENTER (RC) PERFORMANCE IS POOR WHEN REGISTERING VIEW WITH 400 COLUMNS AS REPLICATION SOURCE GG04418 ASNSCRT SERVICE FAILS TO START. ERROR 1075: THE DEPENDENCY SERVICE DOES NOT EXIST OR HAS BEEN MARKED FOR DELETION. GG04422 IN DPROPR REPLICATION CENTER IN ADD REGISTRATION, THE CCSID OF TABLE IS NOT DISPLAYED IN THE LIST OF AS/400 TABLES RETRIEVED. GG04423 DPROPR APPLY TRACE DISPLAYS EXTRANEOUS CHARACTERS FOR SQLDATA ON NON-AIX, UNIX PLATFORMS GG04426 DPROPR APPLY FAILS CYCLE WHEN IT GETS SQLCODE1024 GG04427 REPLICATION CENTER: SHOW RELATED FUNCTION ON REGISTERED TABLES WWINDOW FAILS. GG04429 DPROPR ASNLOAD ON LINUX FAILS WHEN THERE IS A PREDICATE FOR THAT MEMBER. GG04430 DPROPR APPLY STOPS WITH SQL0204 ON QSYS2.SYSTABLES WHEN THE SET FAILS FOR ANY REASON. GG04431 WHEN A COLUMN WITH BLANK CHARACTERS IS ADDED TO A REPLICATION SOURCE, RC GENERATES AN INCORRECT DDL FOR THE CD TABLE GG04432 SUBSCRIPTION SET DISPLAY IS SHOWING DUPLICATE ENTRIES. GG04433 RELICATION CENTER - ASN1571E WHEN ADDING MEMBER WITH UDT XMLVARCHAR GG04435 IF DECIMAL POINT IS DEFINED AS THE COMMA(,), REPLICATION CENTER FAILS TO PUT A SPACE AFTER THE SEPARATOR GG04437 CAPTURE DECODES THE LOG INCORRECTLY WHEN A TABLE IS DEFINED USING COMPRESEED RECORD FORMAT GG04439 SQL3132W WARNING CAUSES ASNLOAD TO RETURN UNSUCCESSFUL RETURN CODE TO ASNAPPLY. GG04442 WHEN MODIFYING A REPLICATION SOURCE THAT IS A VIEW, AN UNCAUGHT EXCEPTION ERROR WOULD OCCUR. GG04443 REPLICATION CENTER GENERATES CAPTURE TRIGGER THAT REFERENCES INCORRECT SCHEMA FOR SEQUENCE#. IC37830 MEMORY LEAK ISSUE WHEN USING THE LOCATE IY00017 CONNECTING TO A DB VIA CONTROL CENTER AND OPENING VIEW INFO ON 10 DIFFERENT VIEWS 10 CONNECTIONS WILL BE OPEN TO THE DATABASE. IY35081 CREATE JDBC PROCEDURE FAILES WITH SQL0449N IY38147 USING THE RESPONSE FILE THE WAY IT IS(DAS SETTINGS ARE COMMENTEDOUT WILL CAUSE MISLEADING ERROR MESSAGES IN DB2SETUP.LOG(RC5123) IY38452 CHANGE COSTING ON REFETCH THAT IS PLACED ABOVE A HSJOIN THAT DON'T SPILL, FOR UPDATES. IY40067 '\' (BACKSLASH) CHARACTER IN SQL STORED PROC DEFAULT STRING RESULTS IN INCORRECT OUTPUT, EXTRA X'00' CHARACTERS IY40734 SQLROWCOUNT() SLOW WITH SCROLLABLE CURSORS IN V8 IY40927 DB2 CRASH - SIGNAL 11 TRAP IN SQLNO_FINAL_PHASE() WHEN A QUERY IS RUN ON TABLE WHICH HAS A SUMMARY TABLE AND QUERY ACCESS THAT. IY41076 INCLUDE AREA IN 'CREATE INDEX' PANEL IS ENABLED WHEN 'UNIQUE' UNCHECKED IY41105 DB2SETUP ON 64-BIT AIX 5.1 RESULTS IN THE FOLLOWING ERROR - CREATING DB2 TOOLS CATALOG:.......FAILURE IY41525 DB2 V8 DB2CLIPK.BND CONTAINS THE WRONG RELEASENUM. IY41691 LOAD FAILS WHEN A COLUMN NAME OF 'URL' IS USED IY41840 DB2LOOK DOESN'T REFLECT ALTER BUFFERPOOL WITH DBPARTITIONNUM PARAMETER IN V8 IY42460 DATABASE CREATED BY AND EARLIER FP RELEASES FAIL TO RESTORE USING A LATER FP RELEASE IY42514 AGENT SERVICING A QUERY DOESN'T FORCE WHEN FORCE APPLICATION IS ISSUED. IY42517 WHEN IMPORT WITH COMPOUND=100 USED AND ROW 100 IS REJECTED, THE ERROR MESSAGE SHOWS MISLEADING ROW NUMBER. IY42622 INCORRECT CARD ESTIMATES IN EEE WHEN BOUND TO SINGLE NODE IY42891 ONLY 1 CONTROL CENTER INSTANCES CAN BE STARTED FOR A DB2 INSTANCE IY42942 SQL0305N SQLSTATE 22002 SQLGETDATA() RC NOT TO SPEC IY43218 IN A MULTI-PARTITIONED ENVIRONMENT, DOING A LIST APPLICATION COULD INVOLVED AN AGENT IN ITS EARLY(NOT FULLY INITIALIZED IY43313 TO ENABLE BRANCH ELIMINATION FEATURE ON INSERT/UPDATE/DELETE -SELECT SQL. IY43315 CPU USAGE INCREASES DRAMATICALLY WHILE MAKING AN APPC CONNECTION TO HOST FROM DB2 CONNECT GATEWAY. IY43325 ONLINE BACKUP FAILS DUE TO LOCKTIMEOUT. HOWEVER, THERE IS NO INDICATION WHICH OBJECT IS LOCKED. IY43373 THE DB2 UDB CONTROL CENTER, DB2CC , IS SLOW TO START (SEVERAL MINUTES) BY A REGULAR USER (NON-INSTANCE OWNER) ON UNIX. IY43550 DB2ATLD EXITS WITH RC 0 FROM SHELL WHEN PROVIDED THE WRONG CONFIG FILE. DB2ATLD -C JUNK.CFG RETURNS SQL2702N BUT ECHO $? - 0 IY43585 CUSTOMER INSTALLING V8 ON SOLARIS LOSES THE LINK BETWEEN /ETC/SERVICES AND /ETC/INET/SERVICES IY43882 IMPPORT WITH LOBS INFILE FAILS WITH SQL0973N, NOT ENOUGH STORAGEIN APP_CTL_HEAP IY44249 ROLLBACK OF A DATABASE MIGRATION TRAPPED WITH A SIGNAL 11 IY44291 V8 INSTALL ALLOWS YOU TO INSTALL THE COMMAND CENTER COMPONENT WITHOUT INSTALLING THE CONTROL CENTER COMPONENT WHICH IS NEEDED. IY44339 SIG#11, TRAPPED IN SQLULOADPARTITION IY44489 FAILURE TO WRITE TO THE RID FILE IS REPORTED CORRECTLY. IY44535 CUSTOMER USING LDAP, REGISTERING DATABASE FOR ODBC USING CA,GETSSQL1395 AND THE DBS IN HIS DIRECTORY ARE DELETED. IY44555 DB2 INSTANCE ENVIRONMENT NOT BEING SET DURING STARTUP ON SUN CLUSTER. IY44560 HANG IN SQLRI_BFIXAND IY44842 SECURITY PROBLEM:DMS DIRECTORY IS CREATED WITH PERMISSION 777 IY44887 DERIVED PRODICATES: SWITCH TO IGNORE SAFETY IY44938 ADD DUMPFILEACCESSALL FILE TYPE MODIFIER FOR THE LOAD COMMAND IY44948 SQL3523W MESSAGE UPDATE - LOAD QUERY COMMAND IY44951 SQL0193N DURING ALTER TABLE COMMAND IY44982 POOR JOIN ORDER CHOSEN WHEN MQT'S USED ON V8.1 ESE WITH 3X NODES. WE ARE INCORRECTLY PRUNING THE BETTER MQT PLANS. IY44996 CLEANUP IN LOAD AFTER DISK FULL ERROR CAUSE DUPLICATE FREEING OFMEMORY BLOCK(SQLOFMBLKEX) PANICS INSTANCE AND CRASH. IY45004 FALSE STAR JOIN MDC COSTING IY45054 ADDITION OF BINDOPTION THAT WOULD FORCE AMBIGUOUS CURSORS TO BE FOR READ ONLY IY45086 CLI0100E WRONG NUMBER OF PARAMETERS. ERROR WHEN USING JDBC APP DRIVER IY45089 ROLLFORWARD ENCOUNTERS AN I/O ERROR WHEN SPECIFYING THE OVERFLOW LOG PATH IY45202 'DB2ADUTL DELETE ...' WITH KEEP N OPTION WHERE N>0 FAILS UNDER 64 BIT INSTANCE. IY45233 CORRECT OPTIMIZER USAGE OF JOIN PREDICATES IY45236 CONTROL CENTER DISPLAYS SQL0332N MESSAGE WHEN ATTEMPTING TO MODIFY DB CFG. IY45258 CREATE PROCEDURE WITH GLOBAL TEMPORARY TABLES TRAPS INSTANCE. IY45279 SUPPORT FOR OUTER JOIN PUSH DOWN FROM A FEDERATED SERVER FOR A DB2 DATA SOURCE. IY45332 ABEND:ON A MULTI-PARTITION DATABASE, THE INSTANCE MAY TRAP/CRASHIN UNREGIS_APPLS DURING A COMMUNICATION OUTAGE. IY45417 VISUAL EXPLAIN CAUSES JAVA CORE DUMP ON AIX 5L IY45443 DB2 WILL NOT AUTOSTART ON AIX IY45456 DB2 CLP INITIALIZATION IS SLOW ON LARGE SYSTEMS DUE TO CALLING LSCFG IY45508 DLFM ADD_PREFIX COMMAND FAILS WHEN ADDING PREFIX FOR A 3 OR MORELEVEL MOUNT POINT FOR EX /A/B/C/ IY45526 DB2 ARCHIVE LOG COMMAND WHEN ISSUED ON WINDOWS CLIENT VERSION 7.2 AGAINST REMOTE DB2 SERVER VERSION 8.1 CRASHES ENGINE IY45717 CANNOT CHANGE NODE NAME WITHIN V8 CONTROL CENTER IY45757 DB2ATLD SPLITTER MISINTERPRETS '' AS NULL SENDING ROW TO WRONG PARTITION. LOAD PHASE FAILS WITH SQL2038N/27990 IY45803 DB2 CRASH (PANIC) WHEN RUNNING WITH STATEMENT MONITOR SWITCH SETTO YES IN TABLE QUEUE CODE IN A EEE ENVIRONMENT IY45815 ABEND:LOAD IN MPP FAILED WITH SQL2038N RC=27990 IF TARGET TABLE HAS VARGRAPHIC/GRAPHIC COLUMN USED FOR PARTITIONING KEY IY45873 NON-COLOCATED TABLES ARE PUSHED THROUGH A UNION ALL VIEW. THIS RESULTS IN POOR PERFORMANCE WITH PARAMETER MARKERS DUE TO TQ'S. IY45914 DATE AND WEEKDAYS DO NOT MATCH WHEN WINDOWS COUNTRY SETTING IS GERMAN. IY45917 CANNOT RUN 32 BIT APPLICATIONS ON 64 BIT SERVERS AND VICE VERSA IY46064 SELECTING AN IMPORT DELIMITER CHARACTER GREATER THAN 0X3F FAILS WITH SQL3017N ON SYSTEMS WITH UTF-8 LOCALE. IY46075 AT DIAGLEVEL 4, OSSHIPCSEMAPHORE::WAIT() PROBE:50 FILLING UP DB2DIAG.LOG WHEN HEALTH MONITOR IS ENABLED IY46167 INSTALL OF ALTERNATE FP2 FAILS IF DEFAULT PACKAGES FROM PREVIOUSINSTALL NOT CHOSEN, AND THEN A NEW PATH IS CHOSEN IY46296 INCORRECT RESULTS WHEN ONE ARM OF A UNION ALL CONTAINS A NOT EXIST CLAUSE. IY46318 'FETCH FIRST N ROWS' PROCESSING MAY RESULT IN MEMORY CORRUPTION IY46383 INDEX NOT USED FOR QUERY WITH OUTER JOIN AND UPPER(COLUMN). IY46423 CANNOT START CONTROL CENTER FOR 64-BIT WHEN USING JRE ENVIRONMENT DUE TO INCORRECT DIRECTORY STRUCTURE. IY46441 DB2DARI SPS GET SQL0450 ERROR IN DB2 V8 IY46522 PANIC OR SIGSEGV IN SQLOFMBLKEX WHICH WAS CALLED BY SQLESRSP IY46557 TURN HEALTH MONITOR ON AFTER INSTANCE IS STARTED, RESULTS IN TRAP. IY46577 PREDICATE IN SUBQUERY MARKED AS REDUNDANT AND CAUSES INCORRECT IO IY46646 DRDA CODE NEEDS TO CHECK FOR SQLTYPE IY46722 DRDA PROTOCOL VIOLATION IN EXCSQLSTT - X'80' NULL PARAMETER MARKERS PASSED TO HOST IN SQLDTA IY46742 AFTER ISSUSING DB2IUPDT AGAINST 64-BIT AIX INSTANCE, THE JAR FILES IN SQLLIB/FUNCTION DISAPPEARED. IY46760 TRAP IN SQM_WRITE_LOCK_WAITS DURING LOCK SNAPSHOT MONITORING. IY46828 MEMORY LEAK: DB2FMP PROCESS LEAKING MEMORY IN SMALL AMOUNTS ON SUCCESSIVE UDF CALLS WITH KEEPFENCED NO AND FENCED_POOL 0 IY46881 NOT ABLE TO TAKE OFFLINE ARCHIVE WHEN DATABASE IS IN QUIESCED STATE AFTER SQL CHANGES DATABASE CONSISTENT STATE TO NO. IY46931 DB2SPLIT SIGSEGV WITH CERTAIN LOCALES. IY46939 QUERY RETURNS INCORRECT RESULT DUE TO REDUNDANT REMOVAL OF PREDICATES WHEN IXAND IS USED. IY46979 THE WITH UR CLAUSE OF A SELECT STATEMENT IS BEING STRIPPED OFF CAUSING A DEADLOCK WHEN SQL_ATTR_MAX_ROWS IS SET. IY47042 DB2 API SQLURLOG CALL DOES NOT WORK IY47051 A QUERY FAILS WITH SQL0901: BAD PLAN: UNRESOLVED QNC FOUND. IY47059 SHEAPTHRES_SHR IS ALLOCATED FOR MULTI-NODE NON-SMP NON-CONCENTRATOR ENVIRONMENT IY47081 PRIMARY KEY IS NOT CREATED IN THE IXF EXPORT FILE WHEN USING THE TABLE ALIAS. IY47195 SIGNAL #11 TRAP WHEN TWO AGENTS CALL SQLM_D_EXIT AT THE SAME TIME. IY47198 SQL0954 DURING DATABASE MIGRATION TO V8. IY47240 LOAD CLIENT DOES NOT FREE MESSAGE QUEUE ON SERVER SIDE WHEN USING 'LOAD CLIENT...' SYNTAX REMOTELY. IY47252 BLOB DATATYPE LENGTH BEING DESCRIBED INCORRECTLY IY47278 DB2FMD PROCESS STARTED BY THE DB2FMCD PROCESS DOES NOT GET ALL THE SECONDARY GROUPS, CAN RESULT IN ERRORS SQL1326N, SQL2036N IY47307 STATISTICS CONTROL BLOCK MEMORY LEAKING WHEN RUNNING LOAD WITH STATISTICS YES AND FINALLY FAILS WITH SQL3011C IY47350 DATABASE IS NOT DEACTIVATED AFTER BEING MARKED BAD. IY47434 SQL0464 ERROR MESG USING CLIENT APPL THAT CONTAINS BOTH EMBEDDED SQL AND CLI FUNCTION CALLS IY47441 INCORRECT OUTPUT OF SQL0100 RETURNED FROM DROP TABLE IY47550 PERFORMANCE ENHANCEMENT TO ROUTE TO MQT WITH SUM(DECIMAL) IY47555 WHEN HASH JOIN IS ENABLED, COLUMNS CONTAINING TRAILING SPACES MAY NOT COMPARE CORRECTLY. IY47573 JAVA STORED PROCEDURES CREATED IN SPB ARE NOT MIGRATED CORRECLY FROM V7.2 TO V8.1 AND FAIL IN V8.1 IY47589 SQLODESTROYTLSKEY() GETS ZRC=0X83000010 IN DB2DIAG.LOG WHEN YOU TERMINATE CICS. IY47716 A NON UOW CLIENT UNABLE TO CREATE PSM STP (SQLCODE -332). IY47736 IMPORVE THE STAR JOIN PROCESSING UNDER REDUCED OPTIMIZATION CONDITIONS IY47750 INSTANCE ABENDS WITH SIGNAL 11 (0XB) ON QUERY WITH NESTED SUBSELECTS IY47772 THE LOGS IN THE OVERFLOWLOGPATH DON'T GET DELETED AFTER A SUCCESSFULL ROLLFORWARD OPERATION.. IY47888 CRASH RECOVERY AND ROLLFORWARD FAILS DUE TO INCONSISTENCY BETWEEN LOB LOG RECORDS AND LOB ALLOCATION PAGE. IY47895 CUSTOMER EXECUTES A SP AND TRAPS WITH SIGNAL 36 DUE TO MEMORY CORRUPTION IY47900 SIGNAL IY47901 DB MARKED BAD. DB2DIAG.LOG CONTAINES ENTRY: SQLRA_FIND_SHIP_VAR , PROBE:135 , DIA8132C CONDITIONAL LOCK , ZRC=0X80100079 IY47905 SQL30081N (*,*,0) AFTER ISSUING SQL STATEMENT. IY47914 CLI0602E WHEN UPDATING CLOB PARAMETER MARKER VIA JDBC NET DRIVERAND/OR USING OLAP ANALYZER IY47916 DB2 CRASH BECAUSE OF THE UPPER LIMIT OF THE COMMUNICATION BUFFER AS AN OPTIMIZATION IY47933 MEMORY CORRUPTION PROBLEMS RELATED TO DECLARING GLOBAL TEMPORARYTABLES IY47961 CONTROL CENTER FUNCTION TO SAMPLE CONTENTS TRUNCATES THE TIMESTAMP VALUE IN A COLUMN. IY47992 SQL1224 FROM RUNNING A UNION QUERY WITH MANY INLIST ITEMS IY48013 SP CALL FROM V8 CLIENT TO V7 FAILS WITH SQL0104N IY48101 BACKUP MAY FAIL DUE TO SQL2044, RC=4 IY48117 INSERT NAN VALUE TO DB2 OS/390 VIA TYPE 4 JCC DROPS CONNECTION IY48131 INSERTION FAILED IN STATEMENT EVENT TABLE DUE TO SEQUENCE_NO COLUMMN IS DEFINED TOO SMALL. IY48181 SQLDREMOVECACHEDTABLEENTRY CALLS SQLOFMBLKEX, WHICH THEN PANICKS IY48279 APP CAN CRASH IN CLIENTBOTIMESTAMPTOCHAR WHEN HOST VAR FOR TIMESTAMP LESS THAN 26 CHARS WIDE IY48281 INVALID CONNECTION FROM .NET DATA PROVIDER CONNECTION POOL IS NOT PURGED IY48287 JAVA EXCEPTION IN JCC WHEN PASSING NULL CLOB TO STORED PROC. IY48334 THE DB2 CLP HITS DB21015E ERROR IF THE FIRST ARGUMENT OF ITS BACKEND DB2BP PROCESS IS LONGER THAN 13 CHARACTERS IY48355 DB2 INSTALLATION SETS UTIL_IMPACT_LIM TO 0 WHICH PREVENTS USERS FROM ISSUING ANY DBM CFG UPDATES - SQL5130N IY48374 BYPASS THE RESTRICTION IN V8 OF DB2COMM=TCPIP FOR XA TO WORK ON THE SERVER IY48375 BETTER PLAN SELECTION FOR NOT IN SUBQUERY IY48421 ABSTRACTMETHODERROR WITH SQLJ APPLICATION ON JCC1.3 - FIX TO EXCEPTION CAUGHT FOR DUPQUERY IY48423 DB2FMCD IS SPAWNING MANY DEFUNCT PROCESSES IY48451 SQL1084C CONNECTING TO LOCAL DATABASE. IY48477 LOADMESSAGE DOESN'T HANDLE TOKEN LONGER THAN 32K IY48551 DB2 HANGS IN SQLNR_SORT_SIPS_ORDER RUNNING A BIND OR SQL COMMAND. IY48648 TRAP SIGSEGV 11 OCCURRING IN SQLEPROCESSSUBREQUEST() IY48653 TRAP IN SQLRR_TRAN_TERM WHEN CONNECTING TO A DATABASE IY48732 APPLICATION HANG DUE TO LATCH PROBLEM IN SQLBFIX IY48761 VIEW IS MATERIALIZE WHEN USING BEGIN ATOMIC IN UDF IY48846 PRIVATE MEMORY CORRUPTION DETECTED BY SQLERRTNAGENTPROCESSRESSETSFENCED IY48870 OUT OF SORT HEAP WHEN RECREATING INDEXES IN PARALLEL IY48902 ALTER TABLESPACE OPERATIONS DO NOT COMPLETE IY48946 TRAP WITH A SIGNAL #11 IN SQLEASSOCAPP IY48950 DB2LICM ALLOWS FOR USERS WITH EXECUTE PERMISSION OVER DB2LICM TO ACHIEVE ROOT PRIVILEGES IY48963 TRAP IN SQLEUCAGENTARINIT IY48997 INSTANCE CRASH IN OPTIMIZER FUNCTION SQLNO_FIX_DEPEND_QUN FOR CERTAIN QUERIES INVOLVING HIERARCHY TABLES IY49009 JDBC INCORRECTLY RETURNS +100 FROM SQLPARAMDATA IY49049 SYSTEM CALL MSGSND() INTERRUPTED IN SQLOCSEMV() CAUSES DATABASE MARKED AS BAD IY49072 ABEND WHEN SELECTING WITH ORDER BY FROM 32K TABLESPACE IY49082 OPTIMIZER CALCULATING SELECTIVITY INCORRECTLY IN A CASE WHERE COLUMN IS ALL NULL AND NUMNULLS > CARD. IY49083 SQL0401N WHEN TRYING TO TRYING TO ALTER TABLE AND ADD FOREIGN KEY CONSISTING OF DISTINCT TYPES. IY49084 INCORRECT RESULTS WHEN USING FLOOR FUNCTION. IY49136 DB2 DOES NOT DETECT THAT THE LSN IS REACHING 0XFFFFFFFFFFFF AND IS READY TO WRAP AROUND TO 0X0 IY49168 LOAD CANNOT LOAD MORE 27 CHARACTER LONG NUMBER INTO THE FLOAT OR DOUBLE COLUMN. IY49171 NOT EXISTS PERFORMS BETTER THAN POSSIBLY EQUIVALENT NOT IN IY49196 JVM FAILS WITH SIGNAL 11, IY49219 OFFLINE BACKUP FAILS AND PANIC IN AGENT_STMT_START IY49414 FUNCTION OVERRUNS END OF BUFFER RETURNING TOO MANY BYTES AND FAILS IN MEMSET() CAUSING A DATABASE CRASH. IY49460 ALLOW EXTRACT OF TABLES WITH GRAPHIC COLUMNS IN UNICODE DATABASES USING DB2LOOK. IY49461 IMPORT CREATE FOR A UNICODE TABLE WITH GRAPHIC COLUMN FAILS WITHSQL3319 IY49462 DB2START HANGS BECAUSE DB2CHKAU IS STUCK IN A TIGHT LOOP CONSUMING CPU CYCLES. IY49469 INCORRECT CONVERSION OF 'I' & 'Y' WHEN USING LOWER() FUNCTION IN A DATABASE WITH TURKISCH CODEPAGE 920 IY49481 DB2 VALUES 1.0000*(0.0445/0.65) RETURNS WRONG RESULTS. IY49484 WE LOADER TIMES OUT ATTEMPTING TO OPEN DB2DIAG.LOG, DB2 BLOCKS SIGCHLD. THIS CREATED DEFUNCT PROCESSES FR 03/10/23 PTF PEREMOVE IY49493 STMTHEAP RESOURCE CONSUMPTION TOO LARGE FOR COMPLEX QUERIES THATDO NOT REFERENCE REMOTE RESOURCES IN A FEDERATED ENVIRONMENT IY49501 SQL0101N WHEN TRYING TO EXECUTE REVOKE FROM USER WHEN DOING SOME POST PROCESSING FOR DEPENENT VIEWS AND SUMMARY TABLES. IY49504 WHEN ATTEMPTING TO ACCESS A TABLE IN A DMS TABLESPACE THAT HAS BEEN OFFLINE REORG'D, THE REQUEST FAILS WITH A SQL1007N. IY49505 OBJECT TABLE EXTENSION PROBLEM IY49506 ROLLFORWARD FAILS IF REORG USING INDEX ON VALUE COMPRESSION TABLE WITH 0-LENGTH LF/LOB DATA. IY49518 VIRTUAL MEMORY LEAK IF SQLGETTYPEINFO IS USED EXCESSIVELY. IY49521 COALESCE FUNTION IS NOT BEING PUSHED DOWN TO SYBASE DATA SRC. IY49553 DATA FOR CHAR, VARCHAR GET TRUNCATED WHEN PERFORMING LOAD WITH CODEPAGE CONVERSION AND TARGET LENGTH BIGGER THAN SOURCE (IXF) IY49567 DB2IMIGR SCRIPT HANGS DUE TO '-N' OPTION IN 'IF' STATEMENTS. IY49569 USE OF RSH WHEN PERFORMING FAILOVER AND ORIGINAL HOST IS DOWN IY49572 EQUALITY PREDICATE WITH LITERAL VALUE GOES TO WRONG INDEX IY49618 MEMORY LEAK IN RESULTSET.GETBLOB() IY49622 CRASH WHEN FEDERATED CONNECTION FORCED IY49623 ALLOW SCHEMA STORED PROCEDURES TO RUN IN TRUSTED MODE IY49624 INTRODUCE A NEW LDAP GLOBAL REGISTRY VARIABLE- DB2LDAP_KEEP_CONNENECTION SO THAT USER DON'T HAVE TO SET IT FOR EACH MACHINE. IY49628 DB2 CRASHED BECAUSE WE'RE TRYING TO DUMP A BAD POINTER. IY49691 UNPREDICTABLE OUT-OF-MEMORY FAILURES ON 32-BIT SYSTEMS WHEN DATABASE SHARED MEMORY CONFIGURATIONS ARE CLOSE TO OR EXCEED 4GB IY49833 INSERT FAILS IF TABLE HAS VARIABLE LENGTH ROWS AND TABLESPACE IS FULL ALTHROUGH SOME PAGES HAVE FREE SPACE IY49836 DB2CKLOG NOT DETECTING SPECIFIC LOG CHECKSUM CORRUPTION IY49837 ERROR IN TRUNCATING LOG DURING NORMAL DATABASE SHUTDOWN RESULTS IN PARTIALLY TRUNCATED LOG FILE. IY49888 FUNC MAPPINGS NOT USED IF SCHEMA > 8 CHARACTERS IY49890 QUERY PERFORMANCE PROBLEM DUE TO QRW RESTRICTIONS WHEN UNION ALLIN VIEW TABLES ARE INVOLVED. IY49891 DYNEXPLAIN CAUSES TRAPS IY49892 EXCEPTION NOT THROWN WHEN LOCK TIMEOUT EXPERIENCED IY49904 TRAP DURING CHANGE PASSWORD IY50036 SIG 11 TRAP IN SQLBFIX DURING LOAD IY50324 AIX 5.2: WHEN ISSUEING A BIND @DB2UBIND.LST WITHOUT THE MESSAGES OPTION THE SQL0091N MESSAGE IS NOT DISPLAY TO STDOUT. IY50467 DB2ADULT CAN'T FIND PATH FOR SHARED LIBRARY: LIBDB2OSSE.SL. IY50509 DB2EVMON SHOULD SAY MICROSECONDS FOR BUFFER_POOL_READ_TIME JR17727 DWC CUSTOMER STATES HE RECEIVED MESSAGE DBA1151 RC=8. HOWEVER, THE MESSAGE DID NOT HAVE ANY DESCRIPTIVE TEXT WITH IT. JR17946 -104 RESULTED FROM IMPORTI/LOAD WITH CREATE INTO OPTION. JR18008 THE '_' IN THE 'DB2MOVE -TN' CLAUSE IGNORES WHILE EXPORTING TABLES. JR18148 MRI - SHORTCUT FOR EXECUTE IN CMD CENTER SHOULD BE CTRL- ENTER, NOT ENTER JR18231 -461 WITH SQL_C_WCHAR -> SQL_CHAR (FOR BIT DATA) BINDING JR18235 V8 CONTROL CENTER FP1 - REDIRECTED RESTORE USING A NON- EXISTENT DATABASE NAME, CONTAINER OPTIONS DISAPPEARS FROM WIZARD GUI. JR18240 FILE NAMES MAY GET MANGLED WITH THE NEXT AND BACK BUTTONS IN SOME CONTROL CENTER WIZARDS (IE LOAD) JR18307 RETRIEVING CHAR(10) COL RETURNS DATA AND TRAILING 5 SPACES USINGV8 TYPE 2 JDBC DRIVER AT V8.1 DBCS, JAPANESE ENVIRONMENT. JR18371 USING THE CONTROL CENTER CHANGE INSTANCE DIALOG TO CHANGE FROM HOSTNAME TO IP ADDRESS DOES NOT REFLECT PROPERLY JR18388 BOGUS SYSTEM FOLDERS SHOW UP IN CONTROL CENTER IF YOU CATALOG A SYSTEM NAME WITH MORE THAN 21 CHAR VIA CLIENT ASSISTANT JR18396 PROBLEM WITH THE DEFAULT DB2 GOVERNOR PROCESS/SERVICE ON WIN32 PLATFORMS. SQL0567N -567 SQLCODE. JR18415 DB2 V8.1 ADMIN CLIENT INSTALLATION ON WIN WITH NOVELL IS VERY SLOW. JR18427 THE DB2 SETUP WIZARD WAS INTERRUPTED BEFORE THE DB2 HTML DOCUMENTATION COULD BE COMPLETELY INSTALLED. JR18454 INSTALL OF DB2 V8.1 ON SYSTEM WITH PREVIOUSLY UNINSTALLED DB2 V7.X DOES NOT UPDATE ODBC DRIVER IN REGISTRY UNDER ODBCINST.INI JR18480 BACKUP TO TAPE ON WINDOWS MAY CRASH INSTANCE JR18514 MEMORY LEAK IN SQLJRPARSESQLDARD JR18533 RECEIVED DWC07275 WITH RC2=7902 ON THE SCHEDULED STEP JR18537 CLI0126E (FP2) ERRONOUSLY REPLACED CLI0150E ON SQLSETCONNECTATTRFOR SQL_ATTR_ODBC_CURSORS / SQL_ATTR_PACKET_SIZE JR18567 DWC - PROMOTING AND DEMOTING A REPLICATION STEP USING XTSERVER/X TCLIENT FAILS. JR18568 IGORE TRAILING NULLS FOR DATE/TIME COLUMNS JR18592 IN THREADS WHICH SHARE THE SAME DATABASE CONTEXT SET CONNECTION INCORRECTLY RETURNS ERROR SQL0843N ( -843 ) JR18598 FAILURE TO RELEASE LATCH FLAG CAUSES EMBEDDED APP TO HANG JR18599 DB2CLI.INI PARAMETERS SUCH AS CURRENTSCHEMA ARE LOST BY COMMAND CENTER WHEN DISPLAYING RESULTS TO RESULTS PAGE JR18613 TABLESPACE NAME CAN NOT BE OVERWRITTEN (REGISTER TABLES DIALOG) JR18629 DB2/390 TWOPHASE COMMIT TO UDB 8.1 FIXPAK 2 CAUSES HOST ABEND DSNLI031I REASON 00D34442 IF FEDERATED=YES JR18631 REMOVE THE MANDATORY REQUIREMENT FOR A USER ID AND PWD TO BE INCLUDED IN THE THIN CLIENT INSTALL RESPONSE FILE JR18667 BACKUP, EXPORT, REORG FAIL IN CONTROL CENTER DUE TO SEMICOLON JR18681 DWC - WIP REPORTS SUCCESS, WHEN AIX AGENT (IWH2AGNT) IS KILLED, BEFORE ALL RECORDS ARE WRITTEN JR18686 CONFIGURATION ASSISTANT - CLI CONF. SECTION DOES NOT WORK PROPERLY FOR THIS GUI TOOL. JR18701 SQL10013N LIBRARY DB2NET8F.DLL COULD NOT BE LOADED ON CREATE NICKNAME FOR NET8 WRAPPER. SET PASSTHROU FAILS AS WELL. JR18712 SQLPRIMARYKEYSW RETURNS INCORRECT RESULT FOR THE TABLE ALIAS. JR18721 TESTING ADO CONNECTION IN CONFIGURATION ASSISTANT GIVES 'ADO CONNECTION FAILED. NON-NULL CONTROLLING UNKNOWN' JR18722 CLI0102E WITH NUMERIC/ZONE DATATYPE IN SELECT STATEMENT WITH OLEDB PROVIDER JR18731 DEVELOPMENT CENTER INVOKES THE DISTRIBUTED DEBUGGER, BUT THEN THE DEVELOPMENT CENTER FREEZES JR18733 DB2BATCH NOT RETURNING ANY RESULTS TO STANDARD OUTPUT JR18746 IN RECORDSET OF ADO OBJECT USING IBMDADB2, ALL OF THE FIELDS HAVE ADFLDMAYBENULL SET TO TRUE. JR18747 ADDITION OF CLI KEYWORDS MAPDATEDESCRIBE AND MAPTIMEDESCRIBE JR18763 PROBLEMS WITH CROSS LOADER AND CLI JR18774 RESPECT DB2CODEPAGE IN COMMAND CENTER JR18787 TRAP IN SQLMEIOT AT SQM_EVMON_IOT. JR18810 DB2DAS - DB2DAS00 IS NOT A VALID WIN32 APPLICATION JR18811 DWC - SQL20109W IF DB2DEBUG RUTIME IS SET JR18812 MISSING COMPILE OPTIONS IN WRAPPER_SDK MAKEFILE JR18834 MEMORY LEAK FOUND ON CLI WHEN CONNECTION HANDLE ALLOCATION,CONNECTION,DISCONECTION,FREE CONNECTION HABDLE WERE DONE ON THREADS. JR18838 PROBLEM WITH SQEX CODE CAUSES HANG IN V8 GA JR18839 CRASH DUE TO SEGMENTATION VIOLATION SEGV IN SQLOFICA WHEN CONNECTING TO DATABASE CATALOGED IN LDAP JR18851 SELECT UNIQUE RECORD IDENTIFIER PROBLEM (ODBC) JR18852 DWC - GENERATED SQL IS INCORRECT JR18858 SQL1182N WITH HRESULT=0X80040154 WHEN USING OLEDB TABLE FUNCTION WITH CODEPAGE 943. JR18873 ARRAY INPUT OF LOB AGAIN HOST ABENDS HOST IF LOB VARIABLES ARE NULL. JR18878 SQL_DESC_NAME AND SQL_DESC_LABEL NOT RETURNING ORDINAL POSITION WHEN DESCSTAT=NO JR18901 . THE RUNTIME-CLIENT DOES NOT USE THE GATEWAY TO ACCESS HOST DB JR18912 IN VERSION 8.1 FIX PACK 1 THE SCHEDULER PROCESS GETS SHUT DOWN BY THE SYSTEM WHEN YOU LOG OFF. JR18928 ZONED (NUMERIC ON AS/400) RETURNING INCORRECT VALUE WHEN USING IBMDADB2 JR18929 QUERY USING LIKE CLAUSE WITH DOUBLE-BYTE CHARACTERS HIT SQL0901N ERROR (REASON 'SQLNO_NUM_CHARS_SPECIFIED [200]:RC( 0) '.) JR18933 SECURITYADMAUTH (NOT IMPLEMENTED YET) IS GRANTED TO USERS WITH DBADM DURING MIGRATION TO V8.1 AND UNABLE TO REVOKE. JR18935 EXTRA 'DRIVER' IN THE CONFIG FILE CREATED BY CA JR18940 GATEWAY HANGS IF CLIENT IS GONE DURING LOBFILE BIND PROCESSING JR18944 DATABASE MIGRATION FAILS IF STORED PROCEDURES HAVE THE SAME SPECIFICNAME, EVEN IF THEY ARE IN DIFFERENT SCHEMAS JR18946 EXPORT/IMPORT TO THE SAME DB2/390 TABLE FROM DB2 CONNECT GOT SQL3169N ERROR JR18954 DB2JDS PROCESS CRASHING IN SQLOFMBLKEX() FUNCTION. THIS CAN BE SEEN IN THE DR. WATSON LOG FILE JR18963 CAN'T CALL API DB2DATABASEQUIESCE AND UNQUIESCE ON WINDOWS JR18981 GEOCODE FAILURE JR18987 CLI STATIC PROFILING SETTINGS NOT DISPLAYED OR UPDATED PROPERLY IN CONFIGURATION ASSISTANT JR18997 PROBLEM USING JDBC GENERATE.JAVA TO CALL DXXGENXML() STORED PROCEDURE. ERROR RETURNED SQL0423N,DXXM011W AND DXXG001E JR19006 DWC - WAREHOUSE CAN HANG WITH NO ERRORS. JR19009 BIG PERFORMANCE HIT IN SQLPRIMARYKEYSW FROM V72->V81 JR19016 DWC - CHANGING CONTROL DATABASES DOES NOT REFRESH WIP WITH NEW INFORMATION JR19028 ERROR -1031 DURING CATALOG RESYNC IN MSCS ENVIRONMENT JR19037 DWC - UDP FEEDBACK FILE MAY NOT GOTO CORRECT DIRECTORY IF NON ENGLISH AS/400 IS USED. JR19040 TRAP WHEN USING REGR_SCOPE JR19043 ISSUE SELECT LOCATE(EXP1,CLOB,EXP3) FROM TABLE GET SQL0443N IF EXP3 >4000 WHICH SHOULD BE AVAILABLE FOR CLOBS BUT NOT VARCHAR JR19050 THE COMPILER INCORRECTLY CHANGES THE COLUMN ORDERING IN A UNION OPERATION WHEN USING A NICKNAME JR19051 WHEN CALLING ORACLE UDF VIA RELATIONAL CONNECT,PERFORMANCE IS SLOW. JR19052 SQL -969 (-300) WHEN UPDATE HOST DBCS DATA USING JOINER NICKNAME JR19053 WHEN USING A SELECT DISTINCT TO SELECT FROM A NICKNAME, THE THE DISTINCT IS NOT PUSHED DOWN TO THE DATA SOURCE JR19060 RUNNING INSERT STATEMENT REPEATEDLY CONSUMES APPLICATION HEAP UNTIL SQL0954C IS RETURNED. JR19064 NET STOP OR STOP OF INSTANCE FROM WINDOWS SERVICES CONTROL PANEL FAILS. DB2 COMMANDS ON INSTANCE FAIL WITH SQL30081N RC=54,*,* JR19119 DB2EVMON ON OS/2 RETURNS SYS1808 - EXCEPTION C0000005 IN SQLOGMBLK JR19120 OLE DB PROPERTIES NOT UPDATED WHEN A CONNECTION IS INVALIDATED DUE TO AN ERROR. (CLI0106, CLI0108) JR19121 DWC I-SERIES AGENT REQUIRES TARGET TO HAVE COMMITMENT CONTROL JR19123 DWC- SQLASSIST MOVING A CALCULATED COLUMN TO A SPECIFIED PLACE IN LIST OF COLUMNS, CHANGE FROM ADD TO BOTTOM OF LIST JR19124 DWC - MIGRATION VW 5.2 TO DWC 7.2 FP7.... MISMATCH CAUSED BY MISSING REQ. TO SQLASSIST FOR GROUPBY JR19125 DWC - SCREEN OCCASSIONALLY FREEZES (TURNS GRAY) THIS FIX IS FOR THE FLASH OF FROZEN SCREEN. TO UNFREEZE IT JR19126 DWC- SQLASSIST SEES TWO COLUMNS ATTEMPTING TO BE JOINED AS INCOMPATIBLE , BOTH CHARACTER, ONE IS FOR BIT DATA JR19127 DWC - DOUBLE CLICK REMOVES TABLE FROM RIGHT COLUMN, COMMON CLASSPROBLEM JR19128 DWC - DAILY SCHEDULE SKIPS A DAY IF SCHEDULE IS TO START LESS THAN 24 HOURS FROM CURRENT TIME JR19129 DWC - IN RESPONSE TO ONETIME ERROR 8525 # OF ELEMENTS DIFFERENT SQL CHANGE TO REPORT ALL CODES POSSIBLE FOR THIS JR19130 DWC - SCHEDULE WINDOW SLOW TO RETRIEVE INFORMATION .. CODE TO REDUCE THAT RESPONSE TIME JR19131 DWC - DATES AND TIMESTAMPS DO NOT ALWAYS REFLECT CORRECT INFORMATIION IN WIP. JR19142 CONTROL CENTER NOT SHOWING THE CORRECT USER SECURITY SETTINGS FOR AST TABLES JR19145 TASK CENTER NOT PROPERLY INTERPRETING WINDOWS COMMAND SCRIPTS JR19146 DWC - SQLASSIST, JOINS CONVERSION OF 5.2 TO 7.2 JOIN SQL DOES NOT LOOK THE SAME IN 7.2 AS IT DID IN 5.2 ALTHO' FUNCTION/SAME JR19147 THERE IS NO SCROLL BAR FOR UDPS IN DATA WAREHOUSE CENTER. DWC JR19267 ROWCOUNT IS WRONG AFTER APPLICATION RUNS OUT OF APP_CTL_HEAP JR19268 DWC - DATA WAREHOUSE CENTER SERVER MAY FAIL ON WINDOWS 2000, WITH NT EVENT OF 7031 LI70001 DB2BFD FAILED TO RUN AGAINST A BND FILE ON LINUX LI70029 COPY TABLE IN DB2CC MAY CREATE THE TARGET TABLE IN THE WRONG TABLESPACE. LI70170 SQLBINDPARAMETER CALL WITH CBCOLDEF=-1 RESULT IN CLI0143E ERROR. LI70197 STARTING A NON-UNIQUE SAVEPOINT WITH THE SAME NAME AS PREVIOUS EXISTING NON-UNIQUE SAVEPOINT RETURNS SQL20112N LI70198 COULDN'T START THE SCHEDULER SUCCESSFULLY - SQL22213N LI70201 LOWER DIAG LEVEL OF DROPPED CONN ERRORS LI70202 NULL CONNECTION PASSED TO SQL ASSIST FROM CMD CTR LI70204 NOTIFICATIONMESSAGE FILE BECOMES CORRUPT DUE TO LOCKING PROBLEM LI70205 DB2_ALL NOT WORKING ON LINUX WHEN A SEMICOLON IS USED TO RUN COMMANDS IN PARALLEL LI70212 TRAP IN SQLRIPARSETOENDOFROW FUNCTION WHEN MAKING A CALL TO DRDALAYER TO MOVETO THE START OF THE NEXT ROW LI70214 FIX TRAP DUE TO THE INCORRECT CHECKING FOR DARI_STATE DURING CONNECT TIME LI70216 DEGRADATION IN PERFORMANCE USING JDBC TYPE 4 DRIVER WHEN USING CONNECTION.SETREADONLY(BOOLEAN) METHOD LI70218 SQL1224 OCCURS DURING ATTACH OR CONNECT FROM 32BIT TO 64BIT INSTANCE ON SAME LINUXAMD64 MACHINE LI70219 MIGRATING DATABASE CONTAING NICKNAMES FAILS WITH SQL0901N REASON 'SQLRLM_MIGRATE_6TO8_SYSTABLES_PD: FAILED ON DROP TABLE'. LI70224 HEALTH MONITOR OUTPUT FOR PERCENTAGE OF SORTS THAT OVERFLOWED IN THE EMAIL NOTIFICATION IS INCORRECT. LI70225 HANG IN SQLOSPINLOCKCONFLICT CALLED BY SQLRA_FIND_VAR_VAR LI70226 SIGNAL 11 IN SQLRR_RUNSTATS. LI70234 SIGSEGV WITH JCC T2 DRIVER WHEN USING XA, AND ENCOUNTERING AN XA RETURN CODE OF RM_FAIL LI70237 SMALL TIMING HOLE WHEN RESTORING A DATABASE WHERE THE RESTORING DATABASE WILL ALLOW A CONNECTION. RESTORE FAILS WITH SQL1035N. LI70239 EVENT MONITOR HANGS WHEN PERFORMING A CONNECT OR TERMINATE. LI70278 ARRAYINDEXOUTOFBOUNDSEXCEPTION USING JDBC NET DRIVER. PQ74663 DPROPR APPLY_SUBSFAILING ALERT CONDITIONS FAIL WITH SQLCODE - 303 WHEN COLUMN APPERRM IN TABLE ASN.IBMSNAP_APPLYTRAIL IS NULL. PQ75324 MISSING MAPING IN MMAP WHEN RC RETURNED X'7C' 124 DECIMAL APAR fixes included in MI00055 (Fixpak 3) APAR No. Abstract -------- -------------------------------------------------- GG04360 DPROPR APPLY GETS SQL0204 ON SYSIBM/SYSTABLES WHEN REPICATING FROM AN AS400 SOURCE. THE MESSAGE IS SEEN IN THE QRWTSRVR JOB. GG04363 SAVE FILE FUNCTION DOES PROVIDE OPTION TO SAVE LOCALLY. GG04383 REPLICATION PROGRAMS TERMINATE AFTER ISSUING AN ASN0506E MESSAGE GG04384 INCORRECT DDL GENERATED FOR CD VIEW WHEN REGISTERING A VIEW SOURCE. GG04386 ADD MEMBERS TO A SUBSCRIPTION FAILS WITH SQL0206N GG04389 ADD GRID (LINES) TO THE TABLE CONTAINER ON THE 'DEFINITION' PAGE IN THE REGISTER TABLES/VIEWS/NICKNAMES DIALOG. GG04390 REDUNDANT QUERY CALLS DEGRADING PERFORMANCE IN RC GUI. GG04392 DPROPR RC ERROR CAUSES ASNLOAD TO SELECT CROSSLOADER WHEN NO NICKNAME HAS BEEN DEFINED. GG04393 DPORPR API SHOULD ONLY READ THE SYSTEM CATALOG TABLE, NOT THE SOURCE TABLES,WHEN THE COL_TYPE='A'. GG04396 26 WINDOWS DISPLAYED WHEN SYSPROC MISSING ON MAINFRAME. GG04400 DPROPR APPLY GETS SQL0518N WHEN THERE ARE MORE THAN 62 MEMBERS IN THE SUBSCRIPTION SET GG04404 DPROPR APPLY IS UNABLE TO CREATE THE ASNLOAD PROCESS ON LINUX. APPLY AND THE NEW CHILD PROCESS ARE BOTH HANGING. GG04405 SQLCODE100 ON PRUNCNTL TABLE WHEN APPLY IS PROCESSING AN UPDATE ANYWHERE SUBSCRIPTION WITH VIEWS. GG04412 DPROPR ASNAPPLY/OS2 GETS ACCESS VIOLATION SYS3175 GG04413 APPLY REPORTS SQL1403N WHEN IT SHOULD REPORT SQL1040N. GG04414 DPROPR APPLY AND ASNLOAD HAVE PROBLEMS WHEN ASNPATH IS SET ON UNIX PLATFORMS. GG04417 THE *.LOB SPILL FILES CREATED BY DPROPR APPLY ARE NOT ALL DELETED. ONLY 32767 FILES ARE DELETED. GG04419 ASNAPPLY FULL REFRESH PREPARE STATEMENTS FAILS WITH COORELATION ID IY34028 SQL STORED PROCEDURE BODY CANNOT BE VIEWED IN CONTORL CENTER IY39964 LOAD OR IMPORT OF A LOBFILE THAT IS LARGER TAHN 2 GB WILL FAIL IY40718 SQL0723N WITH SQLCODE -950 DELETING FROM A TABLE WHOSE DELETE TRIGGER DELETES FROM A TABLE WITH RI CONSTRAINT TO ITSELF IY40806 V8 INSTALL IS UNINSTALLING THE EXISTING JAVA SDK ON HPUX AND REPLACES IT BY 1.3.1.02 IY41143 IN V8 SMP/MPP, FETCH FIRST N ROWS IS PARALLELIZED UNDER STRICTERRULES IY41173 PROBLEM WITH CCA USING PROFILE FROM V720 CONNECT IN V810/DB2FIMPDIRECT CONNECTION ALWAYS CONFIGURED WHICH IS NOT CORRECT. IY41550 DB2 CONNECT V8.1 GA IS LOOKING FOR LIBMQMAX.A IN /OPT/MQM/LIB RATHER THAN FOR LIBMQMAX.SO IY42135 SQLFOREIGNKEYS MISS ON PREDICATE FOR FORKEY_EEEA & FORKEY_EAEE IY42244 SQL1042N WHEN PERFORMING ROLLFORWARD TO END OF LOGS AND STOP WITH OVERFLOW LOG PATH SPECIFIED. IY42327 INCORRECT PASSWORD ON CONNECT IS DISPLAYED IN THE COMMAND CENTER IN V.8. SQL30020. IY42347 MDC TABLE CREATED AS NOT LOGGED INITIALLY, WILL LOG INSERTS, UPDATES, ETC. AFTER THE ACTIVATE NOT LOGGED INITIALLY IS RUN. IY42385 'ARCHIVE LOG' DOES NOT WORK AFTER IT'S ISSUED FIRST TIME IY42673 ADMIN CLIENT: DB2SCHEMA.BND IS MISSING IN SQLLIB\BND IY42742 SQL 30020 RC=1245 RETURNED FROM THE HOST WHEN APP IS USING SCROLABLE CURSORS. IY43009 SQLCODE: -7, SQLSTATE: 42601 WHEN USING THE UNIVERSAL DRIVER AND SQL STATEMENTS CONTAIN SPECIAL CHARACTERS. IY43098 SQL6555N IS RETURNED FROM AUTOLOADER IF AN INCORRECT RECLEN IS USED IY43162 DB2ADMIN STOP FAILS WITH AUTHENTICATION ERROR IY43227 VISUAL EXPLAIN TUTORIAL FILES CANNOT BE IMPORTED SUCCESSFULLY IY43251 SOME DOCUMENTED REGISTRY VARIABLES NOT SHOWING UP IN DB2SET - LR IY43419 THE CONTROL CENTER CANNOT START A REMOTE INSTANCE IN ADMIN MODE ON A UNIX DB2 SERVER. IY43456 CLI0112E ERROR IN ASSIGNMENT. PROBLEM DOES NOT OCCUR IN DB2 V7 IY43723 CALLING SP WITH INOUT PARAM THAT ARE OF DATA TYPE DATE, TIME OR TIMESTAMP FROM THE CLP CAUSES CLP TO TRAP IY43752 OPTIMIZATION OF REFERENTIAL INTEGRITY VERIFICATION NOT TAKING PLACE WHEN PARENT TABLE IS IN A SINGLE NODE NODEGROUP. IY43787 SQLLIB/FUNCTION/JAR EMPTY AFTER DATABASE MIGRATION IY43925 SIG11 IN FIND_PAGE WHEN RUNSTATS WITH DISTRIBUTION AND DETAILED INDEXES ALL IS RUN ON VERY LARGE TABLES ON 64-BIT INSTANCE IY44018 EEE LOAD PARTITIONING AGENT MUST REJECT INVALID DATETIME DATA. IY44270 SQL0104 RETURNED WHEN USING THE ODBC {FN } ESCAPE SEQUENCE FOR SQL92 FUNCTIONS SUCH AS COALESCE IY44327 DLFM CONNECTION MANAGER V8.1 BINDS TO A SPECIFIC IP INSTEAD OF ANY IP AS IT USED TO ON V7.2. IY44359 SELECT FROM SNAPSHOT TABLES IN V8.1 64 BIT UNIX MACHINES FAILS WITH SQLO443N WITH DIAGNOSTIC TEXT 'DBA7612' IY44360 ROLLFORWARD IN EEE WITH OVERFLOW LOG PATH FOR EACH INDIVIDUAL NODE DOES NOT GET PICKED. ONLY THE DFT LOGPATH IS USED... IY44397 V8 RETURNS -901 TO CLIENT WHEN RECEIVES ERR DURING BINDING WHICH CAUSES PACKAGES TO NOT BE BOUND EVEN WITH SQLERROR CONTINUE. IY44434 CONNECTING FROM V7 CLIENT TO V8 SERVER ON DIFFERENT OS AND BUILDING JAVA SP FAILS WITH ERROR SQL0104N FROM CLP & SPB. IY44445 TIMING HOLE DURING STOP AND STOP FORCE IY44454 IN NT, EEE WHEN DB ACTIVATED, CONNECTION EXIST AT CATLG NODE AN D ISSUING DB2STOP NODENUM FROM NON-CATALOG NODE HANGS. IY44484 TRAP IN CLI_CALLDRDAINPUT(), CLI_CALLDRDAOUTPUT(). STACK TOP MAYSHOW SQLPROCEDURECOLUMNS. CLI TRACE MAY END WITH SQLFETCH. IY44499 SQLJ APP. FAILS ON SELECT STATEMENT WITH SQLCODE 0, SQLSTATE 42122. IY44519 INTERNAL V7 STORED PROCEDURES AREN'T MIGRATED TO USE THE NEW DB2SCHEMA LIBRARY WHICH RESULTS IN SQL0444N. IY44531 SUPPORT NULL-TERMINATED STRINGS FROM ISERIES STORED PROCEDURES IY44532 SIGNAL 11 AT SQLNO_CONV_CHAR2FLOAT WHEN PERFORMING A QUERY IY44539 CONNECTION HANG WHEN USING THE SAME CONTEXT TO CONNECT TO TWO DB IN MULTITHREAD ENVIRONMENT. IY44549 IN V8 'FETCH FIRST N ROWS' FOR SELECT DEGRADES PERFORMANCE POSSIBLY FOLLOWED BY SQL0954C IY44559 INSTANCE ATTACH IS LOST AFTER A FAILURE DURING A SHOW DETAIL CLP COMMAND IY44593 MS ACCESS: DYNAMIC KEYWORD FAILS. IY44638 CONNECT CHANGING PASSWORD FAILS ON CLIENT WHEN DATABASE CONFIGURATION AUTHENTICATION = CLIENT IY44700 FILTER INDEXES WHERE TABLE TYPE = 'N'. IY44711 NON-XA CONNECTION FAILS WITH SQL1248. IY44714 BAD RESULTS WHEN WHEN TRYING TO REVISE THE DISTINCT ENFORCEMENT IY44755 ALTER TABLE COMMAND WITH COMPRESS OPTION CAUSES MEMORY CORRUPTION IY44867 CHANGING THE TIME RETURNED ON LIST INDOUBT TRANSACTIONS TO REFLECT XA_END() IY44937 CLI0115E INVALID CURSOR STATE IS RECEIVED WHEN CALLING A STORED PROCEDURE FROM DB2 V8.1 CONNECTING TO V7.1 OS/390 VIA CLP IY45005 FALSE COSTING IN EVALUATING MQT REDIRECTION IY45024 PROBLEMS WITH LOG HEADER STATE IY45067 WRONG UTF8 SUB CHAR SINCE V8 GA. IY45172 HIPER: QUERY MAY NOT BE ROUTED TO MQT ON NICKNAME ALTHOUGH IT CAN. IY45221 SQL0811 IS RETURNED WHEN A SELECT QUERY THAT CALLS SP IS EXECUTED. IN THE ACCESS PLAN, THE SP WAS EXECUTED BEFORE WHERE CLAUSE. IY45223 SEGV (SIGNAL#11) IN FUNCTION SQLRIPREFETCHBIDS(). IY45256 SQL0901N WHEN MERGING TWO UNION OPERATIONS IN THE SAME QUERY DURING QUERY OPTIMIZATION. IY45275 DC HAS DB2JCC_LICENSE_CISUZ.JAR IN CLASSPATH ON CLIENTS. IY45436 SMS TABLESPACE NEEDS TO CHECK IF LARGEST POOL PAGE NUMBER HAS BEEN REACHED. IY45505 DATABASE ROLLFORWARD COMPLAINS ABOUT PAGE HEADER PROBLEMS IY45603 Error calling a stored procedure using type 4 connection and set Object() method. IY45631 JCC driver returns message "The DDM parameter value is not supported" with value 0x113f from OS/390 stored procedure call IY45676 LOAD/IMPORT WE DO NOT TAKE INTO ACCOUNT THE NULL AT THE END OF THE DATA IY45685 XA_RECOVER() IS RETURNING TRANSACTIONS THAT ARE IN THE 'E' STATE. IY45705 SQL0955 WHEN ISSUING MULTIPLE DROP INDEX STATEMENTS IY45731 FILTER FACTOR IS WRONG WHEN COMPARING VARGRAPHIC COLUMN WITH A CONSTANT OF CHAR TYPE IY45739 POSSIBLE DATA CORRUPTION DURING AN MPP LOAD FROM DEL FILE USING MULTIPLE PARTITIONING AGENTS. IY45766 ENGINE CAN'T FIND DEFAULT COLUMN VALUE WHEN RUNSTATS, TRAPS IN SQLRLGETDEFAULT() OR SQL0901N (LOADDEFAULTS:NONE FOUND) RETURNED IY45833 CREATE EVENT MONITOR STATEMENT DOES NOT ALLOW 'ON NODE' CLAUSE IN SINGLE PARTITION DATABASE ENVIRONMENT, SQL0266N RETURNED IY45841 V8 DB2 IS CRASHING WHEN CONNECTED TO FROM SOME V7 CLIENTS IY46002 FILE_TRANSFER_CMD LOADS 0 ROWS WHEN LOAD FILE IS ON OS/390 HOST. IY46162 VALUE OF PARM_MODE CHANGED AFTER RESTORING A V7 BACKUP TO V8. IY46319 SQL0955 RC=2, OTHER OUT-OF-DATABASE MEMORY ERRORS IN DBHEAP, PACKAGE CACHE, UTILITY HEAP WHEN CONCENTRATOR IS ENABLED IY46320 SQL0973 OUT OF DBHEAP, PACKAGE CACHE ERRORS, SQL2009 OUT OF UTILITY HEAP DUE TO MEMORY LEAK WITH MONITORING OF TEMP TABLES IY46578 ERROR SQL30021 WHEN CONNECTING USING TYPE 2 CONNECT TO A DB2/390DATABASE THROUGH A DB2 CONNECT SERVER IY46603 DATABASE GOES DOWN WHILE TAKING AN INCREMENTAL BACKUP OF DMS TABLESPACE IY46652 MIGRATION FROM V7 TO V8 COMPLETES BUT SQL1088 IS RETURNED. IY46807 INSTANCE CRASH WHILE CALCULATING QUERY DEPENDENCIES IY46809 SQL30082 REASON CODE 15 WHEN USING DECRYPT_CHAR() WITH A PASSWORD SET WITH SET ENCRYPTION PASSWORD IN SMP ENVIRONMENT. IY46813 CONNECTION HANDLE IS NOT FREED UP AFTER FAILED ROLLBACK FOR THE FAILED (DEAD) CONNECTION. IY46814 TO FIX MISORDERED ROWS ON REORG WITH CLUSTERED INDEX. IY46818 PREDICATE NOT BEING PUSHED DOWN FULLY, RESULTS IN NEGATIVE PERFORMANCE IMPACT. IY46819 FIX CONNECTION POOLING CLEANUP LOGIC DURING DATABASE FAILURE IY46829 SNAPSHOTS WHOSE TEXT STRINGS ARE CODEPAGE CONVERTED CAN RESULT IN INCORRECT LENGTHS IN ELEMENT AND LOGICAL GROUP HEADERS. IY46831 WHEN CHIME_STRING AND CAST FUNCTION IN A SELECT FROM A NICKNAME, THE SELECT DOES NOT WORK IY46832 ENABLING DUAL LOGGING WITH LARGE LOG FILES CREATES VERY LARGE PERFORMANCE DEGRADATION (70-100X). IY46833 DATA IS LOST WHEN RESTORING BACKUP IMAGES OF MULTI-CONTAINER, SM S TABLE SPACES WHICH CONTAIN LOB DATA. IY46840 INSTANCE ABENDS IN SQLED_CALLBDRDAOUTPUT__FP7UCINTFC + 0X16B0 WHEN TESTING JAVA SP ON 4 NODE DB2 IY46841 PERFORMANCE DEGRADATION ON QUERY WITH IN LIST OF 200 OR MORE ELEMENTS AFTER UPGRADE TO FIXPAK 4 IY46845 status of application in monitor may show up as UOW Executing while actually being in (interally triggered) rollback IY46846 DB2CC: CANNOT ALTER BUFFERPOOL OF EXISTING TABLE WITH THE CONTROL CENTER OF FP9 IY46847 SELECT * FROM TABLE IN DB2SQL92, WHERE THE BLANK BETWEEN SELECT AND STAR IS REPLACED WITH A TAB, FAILS WITH SQL0084N IY46857 SQL QUERY TRAPS INSTANCE WITH SIGSEGV#11 IN DISCONNECT_TREE DURING QUERY REWRITE PHASE IY46858 XASTART() RETURNS XAER_PROTO, SHOULD RETURN XAER_OUTSIDE WHEN LOCAL STATEMENT EXISTS BEFORE XASTART() IS CALLED. IY46859 DB ACTIVATION TAKES A LONG TIME WITH SQLPGILT,PROBE:484 IN THE DB2DIAG.LOG IY46860 JDBC RESULTSET.CLOSE() STATEMENT WILL CLOSE THE STATEMENT, AND NOT JUST THE RESULTSET. IY46865 FAVOUR FULLY QUALIFIED UNIQUE INDEX ACCESS OVER OTHER INDEXES ACCESSES IY46869 INCORRECT REWRITE OF QUERY WITH OR PREDICATE TO UNION IY46873 PERFORMANCE DEGRADES WHEN FEDERATED PART IS NOT RIGHT LEG OF THEUNION WITH A LOCAL QUERY IY46877 OPTIMIZER DOES NOT CHOOSE A SUMMARY TABLE WHEN IT IS AVAILABLE. IY46890 OPTIMIZER-ROUTED MQTS OVER NICKNAME ARE NOT USED FOR QUERY OPTIMIZATION ON DB2 EEE FEDERATED SYSTEM IY46931 DB2SPLIT SIGSEGV WITH CERTAIN LOCALES. IY46955 LONG PREP TIME DUE TO EXPONENTIAL GROWTH IN THE NUMBER OF CANCATENATED KEYS IY46956 WHEN USING THE LIKE PREDICATE FOR GRAPHIC COLUMN TYPE, WE DO NOT CONSIDER USING START/STOP KEY FOR THE INDEX, WE USE SARGABLE IY47000 BAD PAGE ENCOUNTERED IN SQLIFIX IY47007 DB2AUDIT.LOG CORRUPTED WHEN FILESYSTEM FILLS IY47009 ERROR MESSAGE DXXQ045E IS GENERATED WHEN ATTRIBUTES HAVE THE SAME NAME. IY47010 If db2 is started using LANG=zh_CN.hp15CN, will produce SQL4304N reason code "5", when running a Java Stored Procedure. JR04896 INSTANCE CRASH IN SQLRI_CLOSE_UDF_UFOB_CLEANUP() JR17978 FP3: ESE: WIN: FIX MISSING MESSAGE DLL EVENT LOG WARNINGS JR18065 SQL0303 - SQLTYPE 488 COLUMN ON AS400 IS BEING TRANSLATED AS 488 EVEN THOUGH THERE IS NO ZONED DECIMAL IN UDB (SHOULD BE 484) JR18136 CURRENTSCHEMA IS NOT FLOWING UP TO THE HOST JR18149 FP3: COMMAND CENTER SHOULD PROMPT FOR USERID/PASSWORD JR18251 SQL30082 RC 24 WHEN TRYING TO CHANGE HOSTPWD FROM CLIENT APPLN PGM JR18268 LAUNCHING HEALTH CENTER CAUSES ATTACH REQUEST TO ALL INSTANCES CATALOGED ON THE MACHINE RUNNING HEALTH CENTER JR18322 BIND OF DDCSMVS.LST FAILS WITH SQL0551 WHEN SECOND AUTH ID IS USED. JR18362 DB2DCLGN DOES NOT ADD A NULL TERMINATOR (\0) PLACE HOLDER WHEN GENERATING STRUCTURES FOR C LANGUAGE JR18376 TOO BIG VALUE REPORTED IN BUFFER POOL EVENT MONITOR OUTPUT. JR18392 DWC-V8 , LINUX CONTROL DATABASE, COLUMN NAMES ARE LIMITED TO 18 CHARACTERS JR18406 GET DBM CFG FROM CC FOR NEW INSTANCE SHOW CORRUPTED ENTRIES JR18411 DWC - HEARTBEAT CHECKER FOR DWSERVER AND XTSERVER/STARTING XTSERVER AS A SERVICE. JR18412 DATE LOG ERROR JR18419 BACKLEVEL CLIENTS USING V8 GATEWAY TO HOST GET SQL30081 RC=15 WHEN AUTHENTICATION ON CLIENT SET TO DCS_ENCRYPT JR18442 IMPORT OF IXF WITH THE INSERT_UPDATE OPTION ON A TABLE CREATED WITH A PRIMARY KEY NAME 30 CHARS LENGTH FAILED WITH THE SQL3203N JR18446 DBA1177 WHEN TRYING TO SAVE A SCRIPT IN THE DB2 COMMAND CENTER JR18450 PRECOMPILE FAILS WHEN THERE IS UPDATE STATEMENT FOR INSTEAD TRIGGER FOLLOWING ANY OTHER DML STATEMENT JR18458 CONTROL CENTER'S DISPLAY UTILITY, GENERATES A BLANK DISPLAY UTILITY BOX WITH HALF FORMATTED BUTTONS. JR18473 ROUTINES WILL LEAK MEMORY IF AGENTS ARE BEING CREATED/DESTROYED FREQUENTLY JR18482 DB2.EXE HANGS WHEN MORE THAN ONE DB2CMD.EXE STARTED CLOSELY JR18534 STANDARD CONNECTION OF CONFIGURATION ASSISTANT FAILS WITH SQL0104N IN WINDOWS 98. JR18535 ON WINDOWS 2000 A 'DB2 FORCE APPLICATION (APPL-ID)' KILLS THE JVM AT XAEND() INSTEAD OF THROWING AN XA EXCEPTION. JR18538 APAR TO TRACK TOOL THAT MANUALLY RECATALOGS SCHEMA PROCEDURES ASTRUSTED THREAD-SAFE PROCEDURES TO IMPROVE PERFORMANCE JR18574 GET SNAPSHOT FOR ALL BUFFERPOOLS SHOWS DUPLICATE OF DIRECT READS IF THE DBM CONFIG PARM, DFT_MON_BUFPOOL IS SET TO OFF. JR18643 QUERY CRASHES THE INSTANCE WITH SIGNAL 11 WHILE MERGING OUTER JOIN. JR18735 failure to throw batch update chain break exception JR18802 REORGCHK OVERESTIMATES THE ISIZE JR18804 JDBC RESULTSETMETADATA.GETCOLUMNCLASSNAME() RETURNS JAVA.LANG.SHORT BUT SHOULD RETURN JAVA.LANG.INTEGER OR NUMERIC FOR SMALLINT JR18808 SHARE LOCK HELD BY UR NO HOLD SCANNER JR18813 MAPPING COLUMNS TAKES A LONG TIME IN THE COLUMN MAPPING PAGE JR18814 DWC - GUI , WIP NOT SHOWING THE SAME TIMESTAMP AS THE SERVER.... INSTEAD SHOWS LOCAL TIME, UNTIL LOCAL REFRESH IS DONE JR18815 DWC/SQLASSIST JOIN TAB PROBLEM A JOIN WAS DROPPED FROM VIEW ON TAB. SQL IS CORRECT JR18817 DWC COLUMN MAPPING PROBLEM , PROVIDE CORRELATION NAME FOR SOURCE AND TARGET WITHIN STEP JR18823 DWC VARIOUS SQLASSIST GROUPING PROBLEMS JR18824 DWC -JDK NEEDS FEATURES FROM JDK 8 TO IMPROVE SCROLLING AND MOVEMENT THROUGH DATA JR18825 DWC/SQLASSIST COLUMN NEEDS SCROLLING MECHANISM FOR SELECTED COLUMNS JR18826 DWC - DATES SORT ALPHABETICALLY INSTEAD OF CHRONILOGICALLY JR18827 DWC/SQS ASSIST WHEN LINKING TWO LIKE NAME TABLES IN DWC, HANG CAUSED BY SQL ASSIST JR18828 DWC -FROM VW 5.2 BV'S WHICH USED FLAT FILES, IN MIGRATED DWC VER. 7.2 STEPS, NO COLUMN NAMES ARE SHOWING. JR18829 DWC- COPY OR MOVE OF STEP IS NOT REFRESHED WITHOUT CLOSING AND RE-OPENING NAVIGATOR,APPEARS AS MISMATCH WITH METADATA JR18830 DWC- STEP DEMOTED OR PROMOTED IN NAVIGATOR, STATUS OF LOCKS MAY NOT BE ACCURATELY DISPLAYED JR18833 Migration failure due to UDF_MEM_SZ heap problem. LI70022 CREATION OF DMS TABLESPACE BY USING RAW DEVICES ON PLATFORM LINUX S/390 (ZLINUX) WILL RESULT IN ERROR SQL1422 LI70156 LIKE CLAUSE WITH '%' FULL SELECT WILDCARD, PRODUCES POOR JOIN ORDER LI70164 FULL OUTER JOIN TREE, WITH FILTERING PREDICATE, CONVERTED TO LOJTREE, WITH FILTER AT THE TOP. ADD PUSHDOWN OF THE TOP JOIN. LI70172 TRAP IN CLI_SQLCOMPLETEARRAYINPUTCALLBACK LI70192 MEMORY LEAK:ERROR IN DETACHING FROM SHARED MEMORY LEAKS MEMORY SEGMENTS ( SQLOFSHR IN DB2DIAG.LOG ),LEADS TO SQL1221 ON CONNECT LI70194 JAVA.SQL.SQLEXCEPTIONS FROM THE DB2 TYPE 4 UNIVERSAL JDBC DRIVER FAIL TO SERIALIZE. LI70195 SIGNAL #11 TRAP IN SQLNR_LOCAL_OJPRD_PUSHDOWN WHEN DB2_ANTIJOIN=YES AND DOING AN INSERT WITH NOT EXIST SYNTAX