| APAR fixes included in U496809 (Fixpak 5) |
| APAR | 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 <USERID>/' 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 U497253 (Fixpak 4a) |
| APAR | ABSTRACT |
| JR19507 | SELECT DISTINCT ON SINGLE INT MIGHT CAUSE INCORRECT RESULTS
|