Product Name:DB2 UDB Version 8 for Linux (x86, 32-bit)
PTF Number:MI00069
Package Date:Mon Feb 23 17:54:35 EST 2004
Build Level:s040212
APAR fixes included in MI00069 (Fixpak 5)
APARABSTRACT
GG04362REPLICATION CENTER (RC) UNABLE TO USE AN EXISTING TABLE IN 16K TABLESPACE IN SUBSCRIPTION
GG04446DPROPR APPLY GETS SQL0100N ON UPDATE TARGET SCHEMA.IBMSNAP_PRUNCNTL TABLE IF TARGET IS REPLICA.
GG04447DPROPR ADMIN FILES MISSING FROM DB2 8.1 CONNECT PERSONAL EDITION
GG04449DPROPR API ISN'T GENERATING THE CD VIEW DEFINITION DURING SOURCE VIEW REGISTRATION IF THE SOURCE VIEW CREATED ON TOP OF MQT.
GG04452DPRORP REPLICATION CENTER DOES NOT SHOW THE REMOTELY CATALOGED DATABASES.
GG04454SQLN311 WHEN INSERT TO UOW TABLE IN UPDATE ANYWHERE
GG04457DPROPR REPLICATION CENTER ADD SUBSCRIPTION MEMBER FAILS - SOURCE( USING REMOTE JOURNALLING ) AND TARGET TABLE NAMES ARE THE SAME
GG04458DPROPR APPLY ON WINDOWS CRASHES WHEN COMMIT_COUNT IS SET TO NULLAND RI VIOLATION IS ENCOUNTERED IN THE CURRENT CYCLE.
GG04459APPLY GETS SQL0301N WITH DATALINK COLUMNS WHEN TARGET_KEY_CHG=Y
GG04461DAYLIGHT SAVINGS TIME REPLICATION DATA LOSS FOR INFORMIX SOURCES.
GG04462SOME OF DPROPR APPLY THREADS DO NOT TERMINATE EVEN AFTER APPLY IS STOPPED.
IC38604INTERPOLATION IS DONE, BUT THE CALCULATED VALUES FOR THE Z AND M COORDINATES ARE NOT CORRECTLY RETURNED.
IY45222SQL0811 IS RETURNED WHEN A SELECT CALLS A SCALAR SUBSELECT IS RAN. IN THE ACCESS PLAN, THE SS WAS EXECUTED BEFORE WHERE CLAUSE.
IY45231POSSIBLE MEMORY CORRUPTION DURING FMP CLEANUP
IY45277SQL0551 ERROR IS NOT BEING MAPPED TO SQL0440 IN DB2DIAG.LOG
IY45922V7 CLIENT ATTEMPTING TO CHANGE PASSWORD IN CONNECT STATEMENT VIA V8 GATEWAY TO HOST GETS SQL30020 RC=1245
IY46424HEALTH CENTER DOES NOT REMEMBER CHANGES TO SCRIPT SETTINGS.
IY46958EEE : INCONSISTENCY BETWEEN DB2NODES.CFG AND NODEGROUP INFO IN CATALOG TABLE COULD CAUSE MEMORY CORRUPTION
IY47266SQL0104N WHEN IMPORTING DATA THAT WAS EXPORTED FROM DB2/OS390. COLUMN IS DATE TYPE AND HAS DEFAULT VALUE.
IY47621TO INCLUDE ADDITIONAL OPTION FOR DB2ADVIS COMMAND. PREVENTING PASSWORD TO BE SHOWN WHEN '-A <USERID>/' IS USED.
IY47935SQL30020N WHEN CONNECT TO DB WHEN THERE'S ALREADY A CONNECTION TO ANOTHER DB
IY48285PERFORMANCE DEGRADES FROM CHOOSING SMALLER AST / MQTIN EEE
IY48418WHEN RUNNING DB2IMIGR THE SYMBOLIC LINKS BETWWEN DB2PSMDR AND DB2STACS STILL POINT TO V7 DIRECTORIES
IY48465INCORRECT RESULTS PRODUCED WHEN USING LIKE AND A WILDCARD, WHEN AN INDEX IS PRESENT.
IY48592INCORRECT RESULTS RETURNED WHEN USING 'WITH' CSE WITH REPLICATED SUMMARY TABLE REFERENCED...
IY48715EXISTS NOT REWRITTEN INTO A JOIN WHERE A JOIN PREDICATE EXISTS WITHIN THE EXISTS PREDICATE WHERE COL TYPE IS CLOB..
IY48739SQL0901 WHEN DROPPING A MDC TABLE, MESSAGE 'NO ROWS EXIST IN SYSCOLUSE' IN DB2DIAG.LOG.
IY48896SQL0456 WHEN RUNNING DB2 MIGRATE DB COMMAND
IY49028INSTANCE CRASH WHEN SENDING PAGING ALERT FROM HEALTH MONITOR
IY49080UPDATE IS NOT UPDATING THE RIGHT NUMBER OF ROWS WHERE IT'S USINGA SELF REFERENCING SUBQUERY IN A PARTITIONED ENVIORNMENT..
IY49094RUNNING DB2AUDIT DOES NOT CREATE THE CONTEXT.DEL FILE CORRECTLY FROM THE DB2ADUIT EXTRACT.
IY49107SQL0901N: THREE WAY INNER JOIN REFERENCING A COMMON TABLE EXPRESSION CONTAINING UNION ALL.
IY49170-551 WHEN CALLING SP WHEN NESTED SP WAS DROPPED/RECREATED AGAIN.
IY49190ERROR SQL0344N WHILE ACCESSING VIEW WITH ABS FUNCTION ON DATABASE THAT WAS MIGRATED FROM V7 TO V8
IY49206INSTALL ON LINUX390 USING A RESPONSE FILE ONLY INSTALLS 2 FILESETS AT A TIME..
IY49231GETTING SQL0344N WHEN YOU SELECT A DATE FROM A COLUMN BASED ON AVIEW IF THE DATE IS THE SAME AS THE VIEW WAS CREATED WITH
IY49234CARDINALITY DOES NOT INCREASE AFTER A TQ TO A SINGLE NODE. (HASH DIRECTED TQ ON A CONSTANT)
IY49290HEALTH CENTER SENDS PARTIAL OR INCOMPLETE EMAIL NOTIFICATIONS.
IY49344DB2AUDIT EXTRACT COMMAND CREATES SEGMENTATION FAULT WITH CORE DUMP IN SOLARIS OPERATING SYSTEM
IY49368RESTORE REPLACE EXISTING MAY LEAD TO DIFFERENT COLLATING SEQUENCE ON EEE NODES IF ADDING A NEW NODE AFTER THE RESTORE.
IY49407PMAP SHOWS APPLICATION HEAP GROWING AFTER EACH CALL TO SQL PROCEDURE.
IY49450INSTANCE CRASH DURING BUILD PHASE OF LOAD - MEMORY ALLOCATION FAILURE REPORTED
IY49531DELETE-SELECT STATEMENT IN CLP CAN RESULT IN SQL0508N
IY49537INSERT COLUMN LIST FOR CROSSLOADER FEATURE OF CLILOAD NOT BEING HANDLED PROPERLY
IY49564CANNOT CONNECT TO THE DATABASE LOCALLY WHEN USING THE PASSWORD THROUGH THE REMOTE LDAP.
IY49619BAD PERFORMANCE: NOT PUSHING DOWN THROUGH UNION ALL
IY49631DB2NODE ENVIRONMENT VARIABLE IS NOT VISIBLE TO CLI LAYER
IY49689FREE LOCATOR STATEMENT WITH MULTIPLE PARAMETERS FAILS WITH CLI0118 IN THE CLI LAYER.
IY49721PERFORMANCE DEGRADES IN V8 FOR DISTINCT QUERY WITH UDF PREDICATE
IY49744REFERENTIAL INTEGRITY JOIN ELIMINATION RULE IS NOT CONSIDERED FOR INSERT-SELECT STATEMENT
IY49935DURING CODE CONVERSION, LOAD UTILITY TRUNCATE GRAPHIC TYPE DATA IF SOURCE DATA IS BIGGER THAN TARGET COLUMN DEFINITION
IY49990CLI0109E EXECUTING SQL STATEMENT USING XA CONNECTION FROM JAVA WITH DISABLEUNICODE=1
IY50020SIGNAL #11 TRAP IN SQLNO_FIND_HASH_TABLE
IY50032ONLINE BACKUP OCCASIONALLY FAILS. DIAG.LOG WILL SHOW SQLUBWRITEENDLOGRECORD
IY50037INCORRECT RESULTS PRODUCED WHEN SMP > 1. OCCURS AT ON A PARTITIONED SORT.
IY50064DB2ADUTL GRANT ALL ON ALL FOR ALL GIVES ERROR 124 DUE TO TSM API INCOMPATIBILITY.
IY50101TRAP 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.
IY50203DATABASE NEEDS MORE MEMORY TO START UP IN V8 THAN IN V7
IY50224SQL0901N IN SQLNG_PROCESS_PARSE_TREE_NODE
IY50247HEALTH CENTER FAILS TO DISPLAY ANY TABLESPACE OR TABLESPACE CONTAINER INFO WHEN PROCESSING OF ANY ONE OBJECT FAILS
IY50250SQL0901N IN SQLNO_PART_SAT_REQAT PROBE 400 WHEN EXECUTING A SEL ECT QUERY IN A PARTITIONED ENVIRONMENT. SQLNN_E_BADNEWSIN TRACE
IY50295SLOW PERFORMING QUERY DUE TO TQ OVERFLOW, SPILLAGE..
IY50298SP SYSIBM.SQLTABLES HANGS FROM A 32-BIT CLIENT TO A 64-BIT
IY50403UNNECESSARY MESSAGES (SQLEHMONCALLMODULE PROBE:20) TO DB2DIAG.
IY50427SQLUGTPIWILL ALWAYS MISTAKENLY RETURN SQLTYPE VARGRAPHIC FOR PARTITION KEYS THAT ARE GRAPHIC.
IY50445SQL1224N OR DIA8300C MEMORY HEAP ERROR FROM SQLEGETAPPCB , SQLJSINITAPP , SQLEBUILDANDREGISTERAPPGROUP , SQLCCINIT
IY50512HIGH COMPILE TIME FOR QUERIES REFERENCING MQTS
IY50518SIGNAL 11 TRAP IN ENV_GETCOMPILERVARIABLES USING DEVELOPMENT CENTER TO VIEW THE PROPERTIES OF A CONNECTION IN PROJECT VIEW
IY50519PANIC (CRASH) IN DB2 CALLED FROM SQLEASSOCAPP
IY50527TRAP IN SQLEUCAPPLICATIONENTRY WHEN A DESTRUCTOR ISSUES AN SQLDISCONNECT
IY50531SQL30020N RC=124C WHEN BIND V7 BIND FILES TO V8 DATABASE WITH BIND OPTION, QUERYOPT SET IN THE BIND FILE.
IY50532INSTANCE TRAP IN SQLOFMBLKEX CAUSED BY SQLMON_DCS_APPDTV() ON GATEWAY
IY50534UNRESOLVED 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.
IY50597INSTANCE CRASH WHEN USING XML2CLOB() FUNCTION IN A QUERY
IY50650POTENTIAL PERFORMANCE DEGRADATION IN SQL COMPOSITION CAUSED BY FALSE CONVERSION ERROR DETECTION.
IY50659PRUNING HISTORY FILE TAKE LONG TIME DURING BACKUP IF IT HAS MANYFOR SIMULTANEOUS LOADS WITH MULTIPLE LOAD COPY TARGETS.
IY50703SQLFETCHSCROLL IN CLI 7.2 GETS SQL30020 RC=1245 FROM DB2 V8.1 FP3 SERVER
IY50746SPECIFYING MESSAGE FILE USING AUTLOLOADER IS IGNORED.
IY50750INVALIDATE ROUTINE CACHE WHEN ALTER ROUTINE USED
IY50761WITH XA CONNECTION CLI IGNORES THE CONNECTNODE SETTING
IY50818ERRONEOUS -507 WHEN EXECUTING A POSITIONED UPDATE/DELETE FROM AN SQLJ NON-CMP BEAN.
IY50823DRDA SQLJSPARSECONRDBNAM FAILS TO MATCH RDBNAM WITH DBALIAS.
IY50832HANG DUE TO DEADLATCH CONDITION ON DB WITH WRITE SUSPEND ENABLED AND TRACKMOD TURNED ON
IY50835DATABASE CRASHES WITH DIA8709E SEGMENTED TABLE PAGE NUMBER WAS TOO HIGH. ZRC=0X84020009
IY50934DB2 64-BIT ON AIX CREATES A 64GB SHARED MEMORY SEGMENT FOR DATABASE MEMORY - ALLOW SETTING DATABASE_MEMORY TO OVERRIDE THIS
IY50958PATCH2=33 CHANGES BOTH TIMESTAMP AND TIME TO ISO, WHEN WE ONLY WANT TO CHANGE TIMESTAMP
IY50964RUNNING QUERY INVOLVING AVG() OF A FEDERATED TABLE'S COLUMN CAUSES INSTANCE CRASH IN SQLND_CHECK_DIV_PID_FOR_AVG.
IY50994TRAP IN SQLNO_CRULE_STARJN_AND. THIS IS DUE TO A NULL POINTER FOR THE PLAN LIST RETURNED BY SEMIJOIN FUNCTION.
IY51008ABEND: INSTANCE CRASHES WITH SIGNAL #11/SIGSEGV IN COLLECTFFDC()
IY51012ABEND: INSTANCE CRASHES WITH SIGNAL #11/SIGSEGV IN INIT_SQLM_APPL_LOCK()
IY51021REMOVE REDUNDANT COMPLEX PREDICATES & REMOVE COMPLEX LIKE PREDICATES.
IY51023REMOVE REDUNDANT JOIN BASED ON RI CONSTRAINT. FK TABLE DOES NOT NEED TO JOIN TO PK TABLE, WHEN JOIN PRED IS FK & PK. BOOST PERF.
IY51027XA TRANSACTION EXCEPTION XAER_PROTO - DIAGLOG ERROR: ATTEMPTED INVALID OPERATION ON WITHHOLD CURSOR: XA_OP = 0, XA_STATE = 0
IY51033SIGNAL #11 IN SQLERLIBRARYSEARCHINBUCKETHASHTABLE
IY51068LOAD FAILS WITH SQL0911(LOCKTIMEOUT) DUE TO UNECESSARY LOCKING OF SYSTABLES
IY51114ABEND : SQL1224 ON MIGRATE DATABASE COMMAND - FIXPAK 4 ONLY . TRAP IS IN SQLRLM_MIGRATE_6TO8_SYSTABLES_PD
IY51156OUTER JOIN ELIMINATION USING GROUP BY CONDITION
IY51202QPSTART FAILS WITH DQP0007E OR SEGMENTATION FAULT
IY51225SIGNAL 11 IN SQLOFMBLKEX AFTER SQLCCINIT FAILURE
IY51246OPTIMIZATION LEVEL OF ONE STATEMENT IS DEPENDENT ON THAT OF ANO-THER STATEMENT IN THE SAME CONNECTION. IT SHOULD BE INDEPENDENT
IY51249LOWER THE DEFAULT CALCULATED SETTINGS FOR FCM_NUM_ANCHORS, FCM_NUM_RQB & FCM_NUM_CONNECT TO ALLOW HIGHER FCM_NUM_BUFFERS
IY51253TRAP IN SQLEDDB2RAASSP
IY51286DL_TOKEN DOES NOT PICK UP THE NEW VALUE.
IY51297SQL0802N ON INVOCATION OF STORAGEMANAGEMENT STORED PROC FROM CC WHEN CARDINALITY OF TABLE IS > 35000000
IY51322DB2 MPP LOAD FAILED WITH -6555 EVEN AFTER STOP & RESTART THE TAKEOVER NODE IN A FAILOVER ENVIRONMENT SETUP.
IY51331INSERTING A BLOB RESULTS IN SQL0452N.
IY51336SETTIMESTAMP() FUNCTION OF JCC DRIVER USING DEFAULT TIMEZONE WAS NOT CONSTURCTING THE PROPER JDBC VALUE FOR SET & GET METHODS
IY51349CURSOR ARRAY CORRUPTION
IY51383SQL30082 REASON CODE 24 WHEN CONNECTING WITH A COBOL APPLICATION AND SPECIFYING PASSWORD USING A HOST VARIABLE.
IY51444THE TRACE IPC SHARED MEMORY SEGMENT AND SEMAPHORE ARE NOT GETTING PROPERLY CLEANED UP ON DB2STOP.
IY51462INSTANCE ABEND:TRAP IN SQLRA_CACHE_FILL_SEC USING BUFFERED INSERT.
IY51485SQL0083C - LOAD WITH LOBS AND CODEPAGE OPTION
IY51488WHEN A CONNECTION TO A REMOTE SERVER BECOMES INVALID, THE CATALOG CACHE BECOMES INVALIDATED CAUSING LINGERING MEMORY PTRS.
IY51499DB2 ABENDS AFTER FEDERATED QUERY RETURNS CLI ERROR WHEN NO USER MAPPING IS DEFINED OR A SECURITY VIOLATION IS DETECTED REMOTELY
IY51522DUMP SQLCA TO DB2DIAG.LOG WHEN MAXAPPLS EXHAUSTED(SQL1040)
IY51544JCC TYPE 4 APPLICATION GETTING 'NO POSITIONED UPDATE SECTION IS AVAILABLE FOR THE REQUESTED QUERY SECTION IN THE PACKAGE'
IY51571MEMORY LEAK IN DBHEAP USING HASH JOINS WHEN CONNECTION CONCENTRATOR IS USED
IY51581IN V8.1FP4 WE EXPANDED THE LIMITATION FOR COLDEL BUT WE MISTAKENLY INCLUDED SINGLE BYTE CODE PAGES
IY51588APPL FROM OS390 RUNING AGAINST THE UDBV81 FP4 RUNS OUTOF MEMORY HEAP FOR RESYNC HEAP WHEN APPL CONNECTS TO DBALIAS NOT DBNAME
IY51590LIBDB2COMPR.SO LIBRARY IS NOT INSTALLED WHEN APPLYING FP4 WHICH DOES NOT ALLOW THE COMPRESS OPTION TO WORK ON 64BIT INSTANCES
IY51629TRAP IN SQM_REMOTE_APP_RST::ADD_AGENT_COUNTERS DURING RESET MONITOR SWITCHES
IY51630DB2 PANICS WHEN CALLING SQLOFMBLKEX, WHICH WAS CALLED BY SQLEDDB2RASERVERDRIVER
IY51649CLP THROUGHPUT PERFORMANCE DEGREDATION ON LARGE SQL RESULT SETS.
IY51682SIG#11 IN SQNR CRASH THE DB2 INSTANCE
IY51683DB2 CONNECT CRASHES IN CSMFETCH.
IY51707DB2LOOK COREDUMP WITH -M OPTION AND LARGE TABLE DEFINITION
IY51720DATABASE MARKED BAD WITH SELECT ON VIEW WITH UNION ALL. SQL1034
IY51724XAEXCEPTION XAER_PROTO WITH DB2 V8 UNIVERSAL JDBC DRIVER
IY51771NETNAME DEFINED IN DB2NODES.CFG IS OVERRIDEN / OVERWRITTEN BY ETHERNET HOSTNAME
IY51830IN 64-BIT FEDERATED SYSTEM, WHENEVER A REMOTE DATASOURCE RETURNS AN ERROR TO THE FEDERATED SERVER, IT WILL CRASH THE INSTANCE.
IY51849ERROR CODEPATH IN DUPCHECKPREVNORM FUNCTION WHICH IS DUMPED IN THE DB2DIAG.LOG WITH A DIA8575C INDEX MANAGER ERROR
IY51861JCC SQLEXCEPTION INVALID OPERATOR (-99999) AFTER APPLY OF FP4
IY51878JCC 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.
IY51926DATABASE CRASH DURING ALTER TABLE ADD FOREIGN KEY CONSTRAINT
IY51928CUSTOMER USING HEALTH CENTER GETS SQL1092, SEEMS TO USE THE LOCAL LOGIN ID INSTEAD OF THE REMOTE SERVER ID FOR AUTHORIZATION
IY51999SQL1131 DARI CRASH WHEN RUNNING SQL STORED PROCEDURE THAT HAS A SQL WARNING HANDLER
IY52060DB2ADMIN STOP HANGS WITH V8 GATEWAY WHEN USING V7 CONTROL CENTERAGAINST DB2/390
IY52069WHEN PERFORMING LOAD FROM A NAMED PIPE USING THE LOAD API, IT MAY APPEAR TO RETURN 0 BUT NOT LOAD ANYTHING.
IY52071TCB FIX COUNT != 1 WHEN DROPPING DATA OBJECT! RETURNED FROM SQLDDROPTABLE
IY52103SQL1034C / -902 PANIC DATABASE CRASH FORCING OFF APPLICATIONS IN MPP ENVIRONMENT .
IY52178MEMORY LEAK : SQL0973 , SQL0954 : WE ARE LEAKING MEMORY ON EVERYCLOSE / OPEN CURSOR ON A USER / GLOBAL TEMPORARY TABLE
IY52180TABLESPACE FULL SQL0289 DURING LOB INSERT DUE TO BAD LOGIC IN FINDING FREE SPACE RELATED TO LOWTRANLSN PROBLEM.
IY52181NEED TO SEPARATE RETURN CODE FOR DB2GCF FAILURE CASE
IY52221A PREDICATE GOES MISSING IN OPTIMIZED STATEMENT WHEN THE SAME PREDICATE EXISTS IN THE TEMP TABLE, CAUSING INCORRECT RESULT
IY52303DB2 ABENDS WRITING LOG RECORD TO THE LOGS AT THE END OF CRASH RECOVERY IF LOGS ON RAW DEVICE. SPECIFIC TO FP4 (S031027)
IY52306STORED PROCEDURES ON Z/OS DO NOT RETURN RESULTSET TO JCC T4 APP.
IY52309SQL0901N IS RECEIVED WHEN TRYING TO DROP A NICKNAME
IY52423FROM CLP, CALLING CAPTURE_STORAGEMGMT_INFO GETS SQL0443N -803 WHEN TAKING SNAPSHOT AND TABLESPACE ONLY INCLUDES INDICES
IY52424BAD PERFORMANCE BECAUSE OF LOST PREDICATE IN QUERY PLAN.
IY52441HIGH PREPARE TIME WITH OPTIMIZE FOR N ROW QUERIES
IY52457CONTROL CENTER DISPLAYS INCORRECT MINIMUM AND MAXIMUM PAGE SIZESFOR A TABLE IF THE TABLESPACE PAGE SIZE IS NOT 4K
IY52480SIGNAL 11 DURING CONCURRENT DROP TABLESPACE AND LIST TABLESPACE CONTAINERS
IY52482SLOW PERFORMANCE COMPOSITION BOTTLENECK DUE TO ROW LOCKING
IY52494IN DISK FULL SITUATION, ENGINE MISTAKENLY CREATES A NEW PAGE FORAN OBJECT, WHEN THERE IS NO SPACE.
IY52497INCORRECT RESULTS OR INSTANCE CRASH WHEN RUNNING A QUERY
IY52508DB2 VERSION 8.1.4 CRASHED ISSUEING DB2 FORCE APPLICATIONS ALL
IY52571ERROR SQL0104N DOING ON A ZOS HOST A BIND OF A DECLARE STATEMENT WHOSE CURSOR NAME CONTAINS A HYPHEN
IY52694RELAXED RESTRICTION ON FFNRO IN EEE (FETCH FIRST N ROWS). THIS INCREASES PERFORMANCE BY REMOVING A DIRECTED TQ IN A EEE ENV.
IY52703ENTITY EXTRACTUDF NEED TO REINSTATE DTD IN NORMAL CALL
IY52725SQL0525N ON GETCOLUMNS() AGAINST OS/390 DB WHEN _ OR % ARE USED
IY52785ADDING COLUMN COMMENTS THROUGH CONTROL CENTER DO NOT GET PROPERLY FORMATTED.
IY52788ONLINE DATABASE BACKUP FAILS WITH SQL0902C
IY52796DB2EXMIG FAILS TO MIGRATE PARTITIONING INFORMATION FOR THE EXPLAIN TABLES.
IY52798SQL30020N RC=1245 RECEIVED INTERMITTENTLY WHEN CONNECTING FROM DB2 CLIENT TO AN OS/390 DB VIA DB2 CONNECT V8.1 FP2 USING SNA.
IY52815WRONG RESULTS RETURNED BY QUERY DUE TO INCORRECT PREDICATE INFORMATION
IY52826SQLTRANSACT WITH SQL_ROLLBACK GIVES A SQL0501NWHEN MULTICONNECT SET TO 3 IN DB2CLI.INI
IY52987DB2 BROADCASTING WHEN USING HOST VARIABLES INSTEAD OF HASH DIRECT WHEN USING LITERALS..
IY53069INCORRECT QUERY PLAN CHOSEN WHEN USING SELECT DISTINCT AND A SUBQUERY WITH FETCH FIRST N ROWS
IY53088FORMING A COMMON SUB EXPRESSION IN SCALAR SUBQUERIES WHICH HAVE IDENTICAL CORRELATION MAY PRODUCE DIFFERENT RESULTS.
IY53281LOB TYPE COLUMN DECRIPTORS' LOGGED FIELD IS SET TO 0 DURING MIGRATION, CAUSING PROBLEMS WITH DB2LOOK AND DROP TABLE RECOVERY
IY53325INSTALLER CAN'T CREATE TCP PORTS FOR INSTANCE IF /ETC/SERVICES IS A RELATIVE SYMBOLIC LINK
IY53433EXP_LI* FILES MISSING FROM EXPRESS PACKAGING.
IY53456INCORRECT RESULTS RETURNED WHEN REWRITING SCALAR SUBQUERY THAT IS PUSHED THROUGH A UNION ALL.
IY53631INDEX CORRUPTION MAY OCCUR IN TYPE 2 INDEXES WITH >= 3 LEVELS
IY53676DB2 TRAPS IN DESTROYAPPL WHILE FREEING AN AGENT
IY53729DB2LOOK SHOULD GENERATE "REFRESH TABLE" STATEMENT WHEN A NEW INDEX IS CREATED ON A TABLE IN CHECK PENDING STATUS.
IY53734DB2 COMES DOWN, WHEN AN UNEXPECTED SIGNAL IS DELIVERED TO THE DB 2IPCCM PROCESS DURING SOME SYSTEM CALLS.
IY53839MIGRATION FAILS. DXXMIGV RETURNS ERROR: FAILED TO DROP TRIGGER
IY53845EXPORT FROM OS/390 GETS SQL0551
IY53847SQL0901N SQLRL_DGTT_RCV: BUFFER POOL ERROR WHEN DECLARING & DROPPING GLOBAL TEMP TABLES REPEATEDLY WITH DB2NODE SET.
IY53863USER MAYBE ABLE TO DROP A TABLE WITHOUT THE PROPER AUTHORITY
IY53894NAMED PIPE AUTHENTICATION INSTEAD OF USING AUTHENTICATION OF THE USER IT IS LOGGED IN AS.
IY53919DB MIGRATION HANG, DIA3522C ERROR, .MIG FILE ALREADY EXISTS
JR05501UDB INSTANCE CRASH ON SQLNP_INITLEX WHEN MAINFRAME CLIENTS TRY TO BIND/COMPILE AGAINST UDB DATABASE
JR05503INSTANCE TRAP IN SQLJRMONPARSESETCLIENTINFOEX() WHEN TRYING TO SET CLIENT ACCTNG ON OS390 FROM GATEWAY
JR18732HEALTH MONITOR TRAP IN OSSMEMFREE CALLED BY HMONSNAPROUTER
JR18739'LOCK WAIT TIME' FIELD IN DEADLOCK EVENT MONITOR OUTPUT IS ALWAYS BLANK
JR18875XML EXTENDER ADMINISTRATION WIZARD CALL DB2XML.DXXENABLEDB INSTEAD OF CALLING QDBXML.DXXENABLEDB. SQL0204
JR18886DB2FMCD DOES NOT EXECUTE DB2PROFILE
JR18989GET SNAPSHOT FOR ALL REMOTE APPLICATIONS AND DATABASES GIVE DB21017E OR SQL1032 ERROR AND INSTANCE GOES DOWN.
JR19000DWC V8, SCHEMA ERROR -109
JR19002DWC - WAREHOUSE WILL APPEAR TO HANG DURING A RUN DUE TO SOCKET 10038 ERROR
JR19003DWC - IF STEP HAS 'ON FAILURE, OR ON COMPLETION' IF DWC07251 RC2=7905
JR19057INSTANCE CRASH IN SQLERRETURNFMPTOPOOL
JR19058SQL30020N REASON CODE 124C RECEIVING MORE THAN 32K FROM HOST.
JR19061DB2LOOK FAILS TO DOUBLE SINGLE QUOTES FOR COLUMN COMMENTS
JR19077ESTIMATED SIZE OF TABLE IN THE CONTROL CENTER DOES NOT DEPEND IF THE TABLE WAS CREATED WITH OR WITHOUT VALUE COMPRESSED
JR19082ARRAY INSERT/UPDATE/DELETE RETURNS SQL_NO_DATA_FOUND IF AT LEASTONE OF THE ELEMENTS GENERATED THIS WARNING
JR19083CREATING DATABASES SIMULTANEOUSLY FAILS SPORADICALLY
JR19089AFTER DISABLE AND RE ENABLE OF XML EXTENDER COLUMN , UPDATE TRIGGER FAILS IS SET XMLCOLUMN = XMLCOLUMN
JR19092SQLGETINFO CALL FOR SQL_DRIVER_ODBC_VER RETURNS 3.00 FOR V8.1
JR19103SYMPTOM: STEPS IN A PROCESS REARRANGE WHEN METADATA IS MIGRATED FROM V7 AT FP5 WINDOWS TO V8 FP2 WINDOWS TO V8 AIX AT FP2.
JR19104RUNID IN WORK IN PROGRESS APPEARS TO BE REUSED.
JR19107A NEW TABLE FUNCTION SNAPSHOT_QUIESCERS GENERATE TWO WRONGS COLUMN NAMES: OUIESCER_TBS_ID AND OUIESCER_STATE
JR19139CANNOT INVOKE STORED PROCEDURE WITH MORE THAN 697 PARAMETERS
JR19148CONDITION HANDLER DECLARED INSIDE IF STATEMENT FOR SQL STORED PROCEDURE CAUSES DB2 TO ABEND
JR19151INCREASE LENGTH OF REMOTE_AUTHID TO ACOOMODATE LOTUS NOTES IDS.
JR19168WHEN DAS STARTED BY FAULT MONITOR, IT TAKES C LOCALE EVEN DEFAULT LOCALE IS JAPANESE.
JR19192IGNOREWARNINGS KEYWORD WITH SQLEXTENDEDFETCH NOT WORKING
JR19207INCORRECT MESSAGE (SQL0902N RC 188) WHEN THERE IS TRUNCATION FORINOUT PARAMETER OF SP (>30) CALLED FROM THE CLP
JR19208GETROW() IS RETURNING THE WRONG RESULTS WHEN TYPE_FORWARD_ONLY IS SPECIFIED AND THE ENTIRE RESULTSET IS NOT RETRIEVED.
JR19211IMS COMMAND CENTER DOES NOT LAUNCH IN DB2 ADMIN CLIENT IF THERE ARE NO DB2 NODE, DATABASE ENTRIES
JR19232CLI0005W PROPAGATED INTO VB APPLICATION USING IBM OLE DB PROVIDER (WHEN QUERYTIMEOUTINTERVAL=0)
JR19233DB2 CRASHES LAUNCHING SEVERAL MS ACCESS REPORTS DUE TO LARGE SORTS (>1MB) AT THE SAME TIME. TIMING ISSUE
JR19245I-SERIES CLIENT CONNECTING TO DB2 UDB 8.1 RECEIVES SQL0302 ERROR IF HOST VARIABLES ARE USED IN SQL FOR ZONED DECIMAL COLUMNS.
JR19252DB2 RETURNS A WARNING WHEN AN INFORMATIONAL MESSAGE IS ENCOUNTERED.
JR19256NEW CLI KEYWORDS BLOCKFORNROWS AND SQLOVERRIDEFILENAME
JR19260SPARODIC CRASH IN SQLMON_DCS_APP ON CONNECT FROM CLIENT
JR19264.NET DB2COMMANDBUILDER RETURNS ALL STORED PROCEDURE NAMES IF SCHEMA NAME IS NOT SPECIFIED
JR19284WAREHOUSE CREATES INEFFICIENT SQL - NESTED WHERE CLAUSES
JR19291WINDOWS: CAN NOT COMPLETE INSTALL/ISSUE DB2START WITH HYPERTHREAD ENABLED.
JR19293HEALTH MONITOR CRASHES INTERMITTENTLY IN WINDOWS 2000IN FUNCTIO N HMONFQNFINDSEPREV
JR19299CONTROL CENTER DISPLAYS INCORRECT NUMBER OF PARAMETERS FOR A STORED PROCEDURE WHEN PROCEDURE NAME AND SPECIFIC NAME ARE SAME
JR19300NO INDICATOR THAT REPLICATION CENTER IS BEING LAUNCHED IF ANOTHER GUI TOOL ALREADY LAUNCHED
JR19321CLI0112E OCCURS ON A COMMA IN A DECIMAL OPERATION WHEN USING A LOCALE THAT DEFINES A COMMA AS THE DECIMAL SYMBOL
JR19328WINDOWS, CORRUPTED STACK CAUSES TRAP
JR19338DISABLE THE DISCOVERY AND IT WILL NOT ALLOW A V8 RC TO ADMINISTER A V7 REPLICATION ENVIRONMENT
JR19341DB2LOOK DOES NOT OUTPUT CREATE VIEW STATEMENTS FOR VIEWS WHICH DO NOT DEPEND ON PHYSICAL TABLES
JR19347TRAP WITH SNAPSHOT TABLE FUNCTION
JR19352DWC - TARGET DOES NOT SHOW UP IN PULL DOWN, IF CREATED AS ODBC -> DB2 FAMILY -> DB2 FOR ESE.
JR19370DWC SQL0803 . RUNNING A SERIES OF JOBS RESULTS IN -803
JR19371DB2EXMIG FAILS IF NOT ALL EXPLAIN TABLES EXIST
JR19381ODBC APPLICATION RECEIVES SQL5000C, SQL30020N RC=124C IF SQL_ATTR_ROW_ARRAY_SIZE > 32K
JR19387CANNOT ADD USERS ON THE SECURITY PANEL OF TASK CENTER
JR19391LEFT OUTER JOIN RETURNS WRONG VALUE
JR19436DWC V8.1 FP4 MIGRATION DROPS METADATA TABLE INDEXES
JR19474SETTING NUM_POOLAGENTS=0 IN CA RETURNS CCA5007N
JR19477TERMINATING FRONTEND TOOL (E.G. CLP) WITH LONG RUNNING SQL WILL NOT NECESSARILY SIGNAL DB2BP, THUS NOT FREEING REMOTE RESSOURCES
JR19478USING GUI TOOLS TO 390/ZOS CANNOT USE A USERID STARTING WITH @ WILL GET SQL30082
JR19500SQL1325N ERROR AS SERVER DISCOVERY IS INITIATED AGAINST V7 INSTANCES IN REPLICATION CENTER
JR19507SELECT DISTINCT ON SINGLE INT MIGHT CAUSE INCORRECT RESULTS
JR19512COMPLEX EXPRESSIONS WITH UNIONS ARE NOT PUSHED DOWN
JR19513WHEN USING DISTINCT WHEN QUERYING A NICKNAME, PERFORMANCE IS BAD
JR19514DB2 CONFIGURATION ASSISTANT (CA) CRASHES WHEN PERFORMING BIND WITH CLI STATIC PROFILING ENABLED
JR19520LOAD STEP UNABLE TO GENERATE TARGET TABLE ON PROMOTION TO TEST/PRODUCTION AFTER EXPORT AND IMPORT.
JR19521OBJECT NAMES WITH QUOTES GETS CORRUPTED ON EXPORT AND IMPORT
JR19522DWC - MIGRATED CONTROL DB FROM VISUAL WAREHOUSE, STEPS MAY NOT WORK.
JR19523DWC - WHEN USING THE LOCATE FUNCTION WITHIN DWC IF A WILD CARD IS USED (IE. %DEPT) WRONG RESULTS ARE RETURNED.
JR19548DEVELOPMENT CENTER WRONGLY PASSES PARAMETER 12 BUILDUTILITY AS AONE-PART IDENTIFIER TO DSNTPSMP CAUSING PROBLEM WITH BUILDOWNER
JR19561WHEN SHUTTING DOWN THE MACHINE, DB2SYSC AND DB2DAS ARE NOT SHUTTING DOWN PROPERLY.
JR19562WHEN USING DB2 UDB V7.2 FIXPAK 8 OR EARLIER WITH A DB2 CONNECT V8.1 GATEWAY, DATA IS RETURNED IN AN UNEXPECTED FORMAT.
JR19577ENGINE HIT EXCEPTION IN SQLNS_RESET_SCOPE() DURING QUERY REWRITE PROCESS
JR19689INSTRUCTION AT "0X120507C7 REFERENCED MEMORY AT "0X00000000" COM.IBM.DB2.JDBC.DB2EXCEPTION: SQL1131N DARI (STORED PROCEDURE)
JR19693FP3 AND FP4 IN V8 DO NOT PICK UP THE REBOOT=Y PARM IN THE RESPONSE FILE, SO DO NOT REBOOT.
LI70030DB2LICM -L REPORTS WRONG NUMBER OF PROCESSORS ON LINUX INTEL BOXES, WHEN HYPERTHREADING IS NOT ENABLED.
LI70092CONNECTION TO OS390, USING LOOPBACK AND CONNECTION CONCENTRATOR FAILED WITH SQL ERROR SQL30081N
LI70093SQL -805 RETURNED USING SQLSETCONNECTATTRW WITH SQL_ATTR_CURREN T_PACKAGE_SET WITH UCS2 ON DB2 V8.1 FP4
LI70223DIA8529C NO ACTIVE SAVE POINTS RETURNED BY SQLRR_PROC_APP_SVPT
LI70235HEALTH CENTER DISPLAYS GARBAGE DATA WHEN USING JAPANESE VERSION OF DB2 V8.1 (FP1+)
LI70279SQLCOLUMNS WILL FAIL WITH SQL0443N SYSIBM:CLI:-727 SQLSTATE=38553
LI70281MESSAGES COMMAND LINE OPTION IS BEING IGNORED AND RECEIVING SQL2036N RETURN CODE WHEN RUNNING AUTOLOADER FROM SCRIPT
LI70283EXCESSIVE FLOATING-POINT ASSIST FAULT OCCURING ON LINUX IA64
LI70296DB2BUILD TRUNCATES S. PROCEDURES WHEN IMPORTING THEM TO OS/390
LI70297CONPE + WSE/ESE/PE/CONEE DOESN'T ALLOW CUSTOMER TO CREATE A SERVER INSTANCE
LI70322STARTING THE CONTROL CENTER DISPLAYS WINDOWS TO ATTACH TO INSTANCES
LI70323SEGV IN ALLOCATEMEMORYBLOCK ON RHEL3 (RED HAT ENTERPRISE LINUX)
PQ82290FIX PACK 5 (FP5) FOR DB2 ADMINISTRATION SERVER FOR Z/OS V8
APAR fixes included in MI00075 (Fixpak 4a)
APARABSTRACT
JR19507SELECT DISTINCT ON SINGLE INT MIGHT CAUSE INCORRECT RESULTS
APAR fixes included in MI00060 (Fixpak 4)
APARABSTRACT
GG04379PERFORMANCE LAG DELETING REGISTRATION WITH CD TABLESPACE CHECKED.
GG04387DPROPR REPLICATING GRAPHIC COLUMNS ON I-SERIES TO CHAR COLUMNS ON WINDOWS UTF-8 DATABASE
GG04398ADD INDICATORS (HOUR GLASS) TO FIX FOR APAR#GG04390 (PERFORMANCE ENHANCEMENT).
GG04401ASNCLP & REPLICATION CENTER FAIL WHEN REGISTERING A TABLEAND US ING AN EXISTING TABLESPACE WITH MORE THAN 200 CONTAINERSFOR CD
GG04402THE STATE AND STATE_INFO STATUS FIELDS WERE DISPLAYED INCORRECTLY WHEN CONNECTING TO A 400 MACHINE.
GG04403RC API AFTER DOING A MANUAL REFRESH OF A TABLE USING RC, THE SUBSCRIPTION IN THE F DIRECTION IS NOT ACTIVATED
GG04406INCONSISTENCY WITH THE BUFFERPOOL ALLOWING EDITS WHEN THERE IS A VALID OR DROP-DOWN LIST.
GG04408INCLUDE ASNDBCON.BND, ASNSQLCD.BND, ASNSQLCF.BND AND ASNMSGT.BNDIN APPLYUR.LST
GG04409DPROPR APPLY GETS SEGMENTATION FAULT WITH COMMIT_COUNT AND RI, CCD SOURCE TABLE AND USER COPY TARGET TABLES
GG04415REPLICATION CENTER (RC) PERFORMANCE IS POOR WHEN REGISTERING VIEW WITH 400 COLUMNS AS REPLICATION SOURCE
GG04418ASNSCRT SERVICE FAILS TO START. ERROR 1075: THE DEPENDENCY SERVICE DOES NOT EXIST OR HAS BEEN MARKED FOR DELETION.
GG04422IN DPROPR REPLICATION CENTER IN ADD REGISTRATION, THE CCSID OF TABLE IS NOT DISPLAYED IN THE LIST OF AS/400 TABLES RETRIEVED.
GG04423DPROPR APPLY TRACE DISPLAYS EXTRANEOUS CHARACTERS FOR SQLDATA ON NON-AIX, UNIX PLATFORMS
GG04426DPROPR APPLY FAILS CYCLE WHEN IT GETS SQLCODE1024
GG04427REPLICATION CENTER: SHOW RELATED FUNCTION ON REGISTERED TABLES WWINDOW FAILS.
GG04429DPROPR ASNLOAD ON LINUX FAILS WHEN THERE IS A PREDICATE FOR THAT MEMBER.
GG04430DPROPR APPLY STOPS WITH SQL0204 ON QSYS2.SYSTABLES WHEN THE SET FAILS FOR ANY REASON.
GG04431WHEN A COLUMN WITH BLANK CHARACTERS IS ADDED TO A REPLICATION SOURCE, RC GENERATES AN INCORRECT DDL FOR THE CD TABLE
GG04432SUBSCRIPTION SET DISPLAY IS SHOWING DUPLICATE ENTRIES.
GG04433RELICATION CENTER - ASN1571E WHEN ADDING MEMBER WITH UDT XMLVARCHAR
GG04435IF DECIMAL POINT IS DEFINED AS THE COMMA(,), REPLICATION CENTER FAILS TO PUT A SPACE AFTER THE SEPARATOR
GG04437CAPTURE DECODES THE LOG INCORRECTLY WHEN A TABLE IS DEFINED USING COMPRESEED RECORD FORMAT
GG04439SQL3132W WARNING CAUSES ASNLOAD TO RETURN UNSUCCESSFUL RETURN CODE TO ASNAPPLY.
GG04442WHEN MODIFYING A REPLICATION SOURCE THAT IS A VIEW, AN UNCAUGHT EXCEPTION ERROR WOULD OCCUR.
GG04443REPLICATION CENTER GENERATES CAPTURE TRIGGER THAT REFERENCES INCORRECT SCHEMA FOR SEQUENCE#.
IC37830MEMORY LEAK ISSUE WHEN USING THE LOCATE
IY00017CONNECTING TO A DB VIA CONTROL CENTER AND OPENING VIEW INFO ON 10 DIFFERENT VIEWS 10 CONNECTIONS WILL BE OPEN TO THE DATABASE.
IY35081CREATE JDBC PROCEDURE FAILES WITH SQL0449N
IY38147USING THE RESPONSE FILE THE WAY IT IS(DAS SETTINGS ARE COMMENTEDOUT WILL CAUSE MISLEADING ERROR MESSAGES IN DB2SETUP.LOG(RC5123)
IY38452CHANGE 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
IY40734SQLROWCOUNT() SLOW WITH SCROLLABLE CURSORS IN V8
IY40927DB2 CRASH - SIGNAL 11 TRAP IN SQLNO_FINAL_PHASE() WHEN A QUERY IS RUN ON TABLE WHICH HAS A SUMMARY TABLE AND QUERY ACCESS THAT.
IY41076INCLUDE AREA IN 'CREATE INDEX' PANEL IS ENABLED WHEN 'UNIQUE' UNCHECKED
IY41105DB2SETUP ON 64-BIT AIX 5.1 RESULTS IN THE FOLLOWING ERROR - CREATING DB2 TOOLS CATALOG:.......FAILURE
IY41525DB2 V8 DB2CLIPK.BND CONTAINS THE WRONG RELEASENUM.
IY41691LOAD FAILS WHEN A COLUMN NAME OF 'URL' IS USED
IY41840DB2LOOK DOESN'T REFLECT ALTER BUFFERPOOL WITH DBPARTITIONNUM PARAMETER IN V8
IY42460DATABASE CREATED BY AND EARLIER FP RELEASES FAIL TO RESTORE USING A LATER FP RELEASE
IY42514AGENT SERVICING A QUERY DOESN'T FORCE WHEN FORCE APPLICATION IS ISSUED.
IY42517WHEN IMPORT WITH COMPOUND=100 USED AND ROW 100 IS REJECTED, THE ERROR MESSAGE SHOWS MISLEADING ROW NUMBER.
IY42622INCORRECT CARD ESTIMATES IN EEE WHEN BOUND TO SINGLE NODE
IY42891ONLY 1 CONTROL CENTER INSTANCES CAN BE STARTED FOR A DB2 INSTANCE
IY42942SQL0305N SQLSTATE 22002 SQLGETDATA() RC NOT TO SPEC
IY43218IN A MULTI-PARTITIONED ENVIRONMENT, DOING A LIST APPLICATION COULD INVOLVED AN AGENT IN ITS EARLY(NOT FULLY INITIALIZED
IY43313TO ENABLE BRANCH ELIMINATION FEATURE ON INSERT/UPDATE/DELETE -SELECT SQL.
IY43315CPU USAGE INCREASES DRAMATICALLY WHILE MAKING AN APPC CONNECTION TO HOST FROM DB2 CONNECT GATEWAY.
IY43325ONLINE BACKUP FAILS DUE TO LOCKTIMEOUT. HOWEVER, THERE IS NO INDICATION WHICH OBJECT IS LOCKED.
IY43373THE DB2 UDB CONTROL CENTER, DB2CC , IS SLOW TO START (SEVERAL MINUTES) BY A REGULAR USER (NON-INSTANCE OWNER) ON UNIX.
IY43550DB2ATLD EXITS WITH RC 0 FROM SHELL WHEN PROVIDED THE WRONG CONFIG FILE. DB2ATLD -C JUNK.CFG RETURNS SQL2702N BUT ECHO $? - 0
IY43585CUSTOMER INSTALLING V8 ON SOLARIS LOSES THE LINK BETWEEN /ETC/SERVICES AND /ETC/INET/SERVICES
IY43882IMPPORT WITH LOBS INFILE FAILS WITH SQL0973N, NOT ENOUGH STORAGEIN APP_CTL_HEAP
IY44249ROLLBACK OF A DATABASE MIGRATION TRAPPED WITH A SIGNAL 11
IY44291V8 INSTALL ALLOWS YOU TO INSTALL THE COMMAND CENTER COMPONENT WITHOUT INSTALLING THE CONTROL CENTER COMPONENT WHICH IS NEEDED.
IY44339SIG#11, TRAPPED IN SQLULOADPARTITION
IY44489FAILURE TO WRITE TO THE RID FILE IS REPORTED CORRECTLY.
IY44535CUSTOMER USING LDAP, REGISTERING DATABASE FOR ODBC USING CA,GETSSQL1395 AND THE DBS IN HIS DIRECTORY ARE DELETED.
IY44555DB2 INSTANCE ENVIRONMENT NOT BEING SET DURING STARTUP ON SUN CLUSTER.
IY44560HANG IN SQLRI_BFIXAND
IY44842SECURITY PROBLEM:DMS DIRECTORY IS CREATED WITH PERMISSION 777
IY44887DERIVED PRODICATES: SWITCH TO IGNORE SAFETY
IY44938ADD DUMPFILEACCESSALL FILE TYPE MODIFIER FOR THE LOAD COMMAND
IY44948SQL3523W MESSAGE UPDATE - LOAD QUERY COMMAND
IY44951SQL0193N DURING ALTER TABLE COMMAND
IY44982POOR JOIN ORDER CHOSEN WHEN MQT'S USED ON V8.1 ESE WITH 3X NODES. WE ARE INCORRECTLY PRUNING THE BETTER MQT PLANS.
IY44996CLEANUP IN LOAD AFTER DISK FULL ERROR CAUSE DUPLICATE FREEING OFMEMORY BLOCK(SQLOFMBLKEX) PANICS INSTANCE AND CRASH.
IY45004FALSE STAR JOIN MDC COSTING
IY45054ADDITION OF BINDOPTION THAT WOULD FORCE AMBIGUOUS CURSORS TO BE FOR READ ONLY
IY45086CLI0100E WRONG NUMBER OF PARAMETERS. ERROR WHEN USING JDBC APP DRIVER
IY45089ROLLFORWARD 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.
IY45233CORRECT OPTIMIZER USAGE OF JOIN PREDICATES
IY45236CONTROL CENTER DISPLAYS SQL0332N MESSAGE WHEN ATTEMPTING TO MODIFY DB CFG.
IY45258CREATE PROCEDURE WITH GLOBAL TEMPORARY TABLES TRAPS INSTANCE.
IY45279SUPPORT FOR OUTER JOIN PUSH DOWN FROM A FEDERATED SERVER FOR A DB2 DATA SOURCE.
IY45332ABEND:ON A MULTI-PARTITION DATABASE, THE INSTANCE MAY TRAP/CRASHIN UNREGIS_APPLS DURING A COMMUNICATION OUTAGE.
IY45417VISUAL EXPLAIN CAUSES JAVA CORE DUMP ON AIX 5L
IY45443DB2 WILL NOT AUTOSTART ON AIX
IY45456DB2 CLP INITIALIZATION IS SLOW ON LARGE SYSTEMS DUE TO CALLING LSCFG
IY45508DLFM ADD_PREFIX COMMAND FAILS WHEN ADDING PREFIX FOR A 3 OR MORELEVEL MOUNT POINT FOR EX /A/B/C/
IY45526DB2 ARCHIVE LOG COMMAND WHEN ISSUED ON WINDOWS CLIENT VERSION 7.2 AGAINST REMOTE DB2 SERVER VERSION 8.1 CRASHES ENGINE
IY45717CANNOT CHANGE NODE NAME WITHIN V8 CONTROL CENTER
IY45757DB2ATLD SPLITTER MISINTERPRETS '' AS NULL SENDING ROW TO WRONG PARTITION. LOAD PHASE FAILS WITH SQL2038N/27990
IY45803DB2 CRASH (PANIC) WHEN RUNNING WITH STATEMENT MONITOR SWITCH SETTO YES IN TABLE QUEUE CODE IN A EEE ENVIRONMENT
IY45815ABEND:LOAD IN MPP FAILED WITH SQL2038N RC=27990 IF TARGET TABLE HAS VARGRAPHIC/GRAPHIC COLUMN USED FOR PARTITIONING KEY
IY45873NON-COLOCATED TABLES ARE PUSHED THROUGH A UNION ALL VIEW. THIS RESULTS IN POOR PERFORMANCE WITH PARAMETER MARKERS DUE TO TQ'S.
IY45914DATE AND WEEKDAYS DO NOT MATCH WHEN WINDOWS COUNTRY SETTING IS GERMAN.
IY45917CANNOT RUN 32 BIT APPLICATIONS ON 64 BIT SERVERS AND VICE VERSA
IY46064SELECTING AN IMPORT DELIMITER CHARACTER GREATER THAN 0X3F FAILS WITH SQL3017N ON SYSTEMS WITH UTF-8 LOCALE.
IY46075AT DIAGLEVEL 4, OSSHIPCSEMAPHORE::WAIT() PROBE:50 FILLING UP DB2DIAG.LOG WHEN HEALTH MONITOR IS ENABLED
IY46167INSTALL OF ALTERNATE FP2 FAILS IF DEFAULT PACKAGES FROM PREVIOUSINSTALL NOT CHOSEN, AND THEN A NEW PATH IS CHOSEN
IY46296INCORRECT RESULTS WHEN ONE ARM OF A UNION ALL CONTAINS A NOT EXIST CLAUSE.
IY46318'FETCH FIRST N ROWS' PROCESSING MAY RESULT IN MEMORY CORRUPTION
IY46383INDEX NOT USED FOR QUERY WITH OUTER JOIN AND UPPER(COLUMN).
IY46423CANNOT START CONTROL CENTER FOR 64-BIT WHEN USING JRE ENVIRONMENT DUE TO INCORRECT DIRECTORY STRUCTURE.
IY46441DB2DARI SPS GET SQL0450 ERROR IN DB2 V8
IY46522PANIC OR SIGSEGV IN SQLOFMBLKEX WHICH WAS CALLED BY SQLESRSP
IY46557TURN HEALTH MONITOR ON AFTER INSTANCE IS STARTED, RESULTS IN TRAP.
IY46577PREDICATE IN SUBQUERY MARKED AS REDUNDANT AND CAUSES INCORRECT IO
IY46646DRDA CODE NEEDS TO CHECK FOR SQLTYPE
IY46722DRDA PROTOCOL VIOLATION IN EXCSQLSTT - X'80' NULL PARAMETER MARKERS PASSED TO HOST IN SQLDTA
IY46742AFTER ISSUSING DB2IUPDT AGAINST 64-BIT AIX INSTANCE, THE JAR FILES IN SQLLIB/FUNCTION DISAPPEARED.
IY46760TRAP IN SQM_WRITE_LOCK_WAITS DURING LOCK SNAPSHOT MONITORING.
IY46828MEMORY LEAK: DB2FMP PROCESS LEAKING MEMORY IN SMALL AMOUNTS ON SUCCESSIVE UDF CALLS WITH KEEPFENCED NO AND FENCED_POOL 0
IY46881NOT ABLE TO TAKE OFFLINE ARCHIVE WHEN DATABASE IS IN QUIESCED STATE AFTER SQL CHANGES DATABASE CONSISTENT STATE TO NO.
IY46931DB2SPLIT SIGSEGV WITH CERTAIN LOCALES.
IY46939QUERY RETURNS INCORRECT RESULT DUE TO REDUNDANT REMOVAL OF PREDICATES WHEN IXAND IS USED.
IY46979THE WITH UR CLAUSE OF A SELECT STATEMENT IS BEING STRIPPED OFF CAUSING A DEADLOCK WHEN SQL_ATTR_MAX_ROWS IS SET.
IY47042DB2 API SQLURLOG CALL DOES NOT WORK
IY47051A QUERY FAILS WITH SQL0901: BAD PLAN: UNRESOLVED QNC FOUND.
IY47059SHEAPTHRES_SHR IS ALLOCATED FOR MULTI-NODE NON-SMP NON-CONCENTRATOR ENVIRONMENT
IY47081PRIMARY KEY IS NOT CREATED IN THE IXF EXPORT FILE WHEN USING THE TABLE ALIAS.
IY47195SIGNAL #11 TRAP WHEN TWO AGENTS CALL SQLM_D_EXIT AT THE SAME TIME.
IY47198SQL0954 DURING DATABASE MIGRATION TO V8.
IY47240LOAD CLIENT DOES NOT FREE MESSAGE QUEUE ON SERVER SIDE WHEN USING 'LOAD CLIENT...' SYNTAX REMOTELY.
IY47252BLOB DATATYPE LENGTH BEING DESCRIBED INCORRECTLY
IY47278DB2FMD PROCESS STARTED BY THE DB2FMCD PROCESS DOES NOT GET ALL THE SECONDARY GROUPS, CAN RESULT IN ERRORS SQL1326N, SQL2036N
IY47307STATISTICS CONTROL BLOCK MEMORY LEAKING WHEN RUNNING LOAD WITH STATISTICS YES AND FINALLY FAILS WITH SQL3011C
IY47350DATABASE IS NOT DEACTIVATED AFTER BEING MARKED BAD.
IY47434SQL0464 ERROR MESG USING CLIENT APPL THAT CONTAINS BOTH EMBEDDED SQL AND CLI FUNCTION CALLS
IY47441INCORRECT OUTPUT OF SQL0100 RETURNED FROM DROP TABLE
IY47550PERFORMANCE ENHANCEMENT TO ROUTE TO MQT WITH SUM(DECIMAL)
IY47555WHEN HASH JOIN IS ENABLED, COLUMNS CONTAINING TRAILING SPACES MAY NOT COMPARE CORRECTLY.
IY47573JAVA STORED PROCEDURES CREATED IN SPB ARE NOT MIGRATED CORRECLY FROM V7.2 TO V8.1 AND FAIL IN V8.1
IY47589SQLODESTROYTLSKEY() GETS ZRC=0X83000010 IN DB2DIAG.LOG WHEN YOU TERMINATE CICS.
IY47716A NON UOW CLIENT UNABLE TO CREATE PSM STP (SQLCODE -332).
IY47736IMPORVE THE STAR JOIN PROCESSING UNDER REDUCED OPTIMIZATION CONDITIONS
IY47750INSTANCE ABENDS WITH SIGNAL 11 (0XB) ON QUERY WITH NESTED SUBSELECTS
IY47772THE LOGS IN THE OVERFLOWLOGPATH DON'T GET DELETED AFTER A SUCCESSFULL ROLLFORWARD OPERATION..
IY47797TRAP WITH MEMORY CORRUPTION IN SQLUREMOVERESOURCEENTRY DURING LOAD FROM PIPE
IY47888CRASH RECOVERY AND ROLLFORWARD FAILS DUE TO INCONSISTENCY BETWEEN LOB LOG RECORDS AND LOB ALLOCATION PAGE.
IY47895CUSTOMER EXECUTES A SP AND TRAPS WITH SIGNAL 36 DUE TO MEMORY CORRUPTION
IY47900SIGNAL
IY47901DB MARKED BAD. DB2DIAG.LOG CONTAINES ENTRY: SQLRA_FIND_SHIP_VAR , PROBE:135 , DIA8132C CONDITIONAL LOCK , ZRC=0X80100079
IY47905SQL30081N (*,*,0) AFTER ISSUING SQL STATEMENT.
IY47914CLI0602E WHEN UPDATING CLOB PARAMETER MARKER VIA JDBC NET DRIVERAND/OR USING OLAP ANALYZER
IY47916DB2 CRASH BECAUSE OF THE UPPER LIMIT OF THE COMMUNICATION BUFFER AS AN OPTIMIZATION
IY47933MEMORY CORRUPTION PROBLEMS RELATED TO DECLARING GLOBAL TEMPORARYTABLES
IY47961CONTROL CENTER FUNCTION TO SAMPLE CONTENTS TRUNCATES THE TIMESTAMP VALUE IN A COLUMN.
IY47992SQL1224 FROM RUNNING A UNION QUERY WITH MANY INLIST ITEMS
IY48013SP CALL FROM V8 CLIENT TO V7 FAILS WITH SQL0104N
IY48101BACKUP MAY FAIL DUE TO SQL2044, RC=4
IY48117INSERT NAN VALUE TO DB2 OS/390 VIA TYPE 4 JCC DROPS CONNECTION
IY48131INSERTION FAILED IN STATEMENT EVENT TABLE DUE TO SEQUENCE_NO COLUMMN IS DEFINED TOO SMALL.
IY48157SQL3342N CREATE NICKNAME USING A SASODBC DRIVER
IY48181SQLDREMOVECACHEDTABLEENTRY CALLS SQLOFMBLKEX, WHICH THEN PANICKS
IY48279APP CAN CRASH IN CLIENTBOTIMESTAMPTOCHAR WHEN HOST VAR FOR TIMESTAMP LESS THAN 26 CHARS WIDE
IY48281INVALID CONNECTION FROM .NET DATA PROVIDER CONNECTION POOL IS NOT PURGED
IY48287JAVA EXCEPTION IN JCC WHEN PASSING NULL CLOB TO STORED PROC.
IY48334THE DB2 CLP HITS DB21015E ERROR IF THE FIRST ARGUMENT OF ITS BACKEND DB2BP PROCESS IS LONGER THAN 13 CHARACTERS
IY48355DB2 INSTALLATION SETS UTIL_IMPACT_LIM TO 0 WHICH PREVENTS USERS FROM ISSUING ANY DBM CFG UPDATES - SQL5130N
IY48374BYPASS THE RESTRICTION IN V8 OF DB2COMM=TCPIP FOR XA TO WORK ON THE SERVER
IY48375BETTER PLAN SELECTION FOR NOT IN SUBQUERY
IY48421ABSTRACTMETHODERROR WITH SQLJ APPLICATION ON JCC1.3 - FIX TO EXCEPTION CAUGHT FOR DUPQUERY
IY48423DB2FMCD IS SPAWNING MANY DEFUNCT PROCESSES
IY48451SQL1084C CONNECTING TO LOCAL DATABASE.
IY48477LOADMESSAGE DOESN'T HANDLE TOKEN LONGER THAN 32K
IY48551DB2 HANGS IN SQLNR_SORT_SIPS_ORDER RUNNING A BIND OR SQL COMMAND.
IY48648TRAP SIGSEGV 11 OCCURRING IN SQLEPROCESSSUBREQUEST()
IY48653TRAP IN SQLRR_TRAN_TERM WHEN CONNECTING TO A DATABASE
IY48732APPLICATION HANG DUE TO LATCH PROBLEM IN SQLBFIX
IY48761VIEW IS MATERIALIZE WHEN USING BEGIN ATOMIC IN UDF
IY48846PRIVATE MEMORY CORRUPTION DETECTED BY SQLERRTNAGENTPROCESSRESSETSFENCED
IY48870OUT OF SORT HEAP WHEN RECREATING INDEXES IN PARALLEL
IY48902ALTER TABLESPACE OPERATIONS DO NOT COMPLETE
IY48946TRAP WITH A SIGNAL #11 IN SQLEASSOCAPP
IY48950DB2LICM ALLOWS FOR USERS WITH EXECUTE PERMISSION OVER DB2LICM TO ACHIEVE ROOT PRIVILEGES
IY48963TRAP IN SQLEUCAGENTARINIT
IY48997INSTANCE CRASH IN OPTIMIZER FUNCTION SQLNO_FIX_DEPEND_QUN FOR CERTAIN QUERIES INVOLVING HIERARCHY TABLES
IY49009JDBC INCORRECTLY RETURNS +100 FROM SQLPARAMDATA
IY49049SYSTEM CALL MSGSND() INTERRUPTED IN SQLOCSEMV() CAUSES DATABASE MARKED AS BAD
IY49072ABEND WHEN SELECTING WITH ORDER BY FROM 32K TABLESPACE
IY49082OPTIMIZER CALCULATING SELECTIVITY INCORRECTLY IN A CASE WHERE COLUMN IS ALL NULL AND NUMNULLS > CARD.
IY49083SQL0401N WHEN TRYING TO TRYING TO ALTER TABLE AND ADD FOREIGN KEY CONSISTING OF DISTINCT TYPES.
IY49084INCORRECT RESULTS WHEN USING FLOOR FUNCTION.
IY49136DB2 DOES NOT DETECT THAT THE LSN IS REACHING 0XFFFFFFFFFFFF AND IS READY TO WRAP AROUND TO 0X0
IY49168LOAD CANNOT LOAD MORE 27 CHARACTER LONG NUMBER INTO THE FLOAT OR DOUBLE COLUMN.
IY49171NOT EXISTS PERFORMS BETTER THAN POSSIBLY EQUIVALENT NOT IN
IY49196JVM FAILS WITH SIGNAL 11,
IY49219OFFLINE BACKUP FAILS AND PANIC IN AGENT_STMT_START
IY49414FUNCTION OVERRUNS END OF BUFFER RETURNING TOO MANY BYTES AND FAILS IN MEMSET() CAUSING A DATABASE CRASH.
IY49460ALLOW EXTRACT OF TABLES WITH GRAPHIC COLUMNS IN UNICODE DATABASES USING DB2LOOK.
IY49461IMPORT CREATE FOR A UNICODE TABLE WITH GRAPHIC COLUMN FAILS WITHSQL3319
IY49462DB2START HANGS BECAUSE DB2CHKAU IS STUCK IN A TIGHT LOOP CONSUMING CPU CYCLES.
IY49469INCORRECT CONVERSION OF 'I' & 'Y' WHEN USING LOWER() FUNCTION IN A DATABASE WITH TURKISCH CODEPAGE 920
IY49481DB2 VALUES 1.0000*(0.0445/0.65) RETURNS WRONG RESULTS.
IY49484WE LOADER TIMES OUT ATTEMPTING TO OPEN DB2DIAG.LOG, DB2 BLOCKS SIGCHLD. THIS CREATED DEFUNCT PROCESSES FR 03/10/23 PTF PEREMOVE
IY49493STMTHEAP RESOURCE CONSUMPTION TOO LARGE FOR COMPLEX QUERIES THATDO NOT REFERENCE REMOTE RESOURCES IN A FEDERATED ENVIRONMENT
IY49501SQL0101N WHEN TRYING TO EXECUTE REVOKE FROM USER WHEN DOING SOME POST PROCESSING FOR DEPENENT VIEWS AND SUMMARY TABLES.
IY49504WHEN ATTEMPTING TO ACCESS A TABLE IN A DMS TABLESPACE THAT HAS BEEN OFFLINE REORG'D, THE REQUEST FAILS WITH A SQL1007N.
IY49505OBJECT TABLE EXTENSION PROBLEM
IY49506ROLLFORWARD FAILS IF REORG USING INDEX ON VALUE COMPRESSION TABLE WITH 0-LENGTH LF/LOB DATA.
IY49518VIRTUAL MEMORY LEAK IF SQLGETTYPEINFO IS USED EXCESSIVELY.
IY49521COALESCE FUNTION IS NOT BEING PUSHED DOWN TO SYBASE DATA SRC.
IY49553DATA FOR CHAR, VARCHAR GET TRUNCATED WHEN PERFORMING LOAD WITH CODEPAGE CONVERSION AND TARGET LENGTH BIGGER THAN SOURCE (IXF)
IY49567DB2IMIGR SCRIPT HANGS DUE TO '-N' OPTION IN 'IF' STATEMENTS.
IY49569USE OF RSH WHEN PERFORMING FAILOVER AND ORIGINAL HOST IS DOWN
IY49572EQUALITY PREDICATE WITH LITERAL VALUE GOES TO WRONG INDEX
IY49618MEMORY LEAK IN RESULTSET.GETBLOB()
IY49622CRASH WHEN FEDERATED CONNECTION FORCED
IY49623ALLOW SCHEMA STORED PROCEDURES TO RUN IN TRUSTED MODE
IY49624INTRODUCE A NEW LDAP GLOBAL REGISTRY VARIABLE-DB2LDAP_KEEP_CONNENECTION SO THAT USER DON'T HAVE TO SET IT FOR EACH MACHINE.
IY49628DB2 CRASHED BECAUSE WE'RE TRYING TO DUMP A BAD POINTER.
IY49691UNPREDICTABLE OUT-OF-MEMORY FAILURES ON 32-BIT SYSTEMS WHEN DATABASE SHARED MEMORY CONFIGURATIONS ARE CLOSE TO OR EXCEED 4GB
IY49833INSERT FAILS IF TABLE HAS VARIABLE LENGTH ROWS AND TABLESPACE IS FULL ALTHROUGH SOME PAGES HAVE FREE SPACE
IY49836DB2CKLOG NOT DETECTING SPECIFIC LOG CHECKSUM CORRUPTION
IY49837ERROR IN TRUNCATING LOG DURING NORMAL DATABASE SHUTDOWN RESULTS IN PARTIALLY TRUNCATED LOG FILE.
IY49888FUNC MAPPINGS NOT USED IF SCHEMA > 8 CHARACTERS
IY49890QUERY PERFORMANCE PROBLEM DUE TO QRW RESTRICTIONS WHEN UNION ALLIN VIEW TABLES ARE INVOLVED.
IY49891DYNEXPLAIN CAUSES TRAPS
IY49892EXCEPTION NOT THROWN WHEN LOCK TIMEOUT EXPERIENCED
IY49904TRAP DURING CHANGE PASSWORD
IY50036SIG 11 TRAP IN SQLBFIX DURING LOAD
IY50252SQL1131N ERROR WITH MSACCESS SQLTABLES CALL. TRAP IN SQLJRPREPROCESSSETI
IY50324AIX 5.2: WHEN ISSUEING A BIND @DB2UBIND.LST WITHOUT THE MESSAGES OPTION THE SQL0091N MESSAGE IS NOT DISPLAY TO STDOUT.
IY50467DB2ADULT CAN'T FIND PATH FOR SHARED LIBRARY: LIBDB2OSSE.SL.
IY50509DB2EVMON SHOULD SAY MICROSECONDS FOR BUFFER_POOL_READ_TIME
IY50585LATCH CONTENTION IN DPS CODE RESULTING IN ALL DB2 COMMANDS HANGING.
JR17727DWC 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.
JR18008THE '_' IN THE 'DB2MOVE -TN' CLAUSE IGNORES WHILE EXPORTING TABLES.
JR18148MRI - SHORTCUT FOR EXECUTE IN CMD CENTER SHOULD BE CTRL-ENTER, NOT ENTER
JR18231-461 WITH SQL_C_WCHAR -> SQL_CHAR (FOR BIT DATA) BINDING
JR18235V8 CONTROL CENTER FP1 - REDIRECTED RESTORE USING A NON-EXISTENT DATABASE NAME, CONTAINER OPTIONS DISAPPEARS FROM WIZARD GUI.
JR18240FILE NAMES MAY GET MANGLED WITH THE NEXT AND BACK BUTTONS IN SOME CONTROL CENTER WIZARDS (IE LOAD)
JR18307RETRIEVING CHAR(10) COL RETURNS DATA AND TRAILING 5 SPACES USINGV8 TYPE 2 JDBC DRIVER AT V8.1 DBCS, JAPANESE ENVIRONMENT.
JR18371USING THE CONTROL CENTER CHANGE INSTANCE DIALOG TO CHANGE FROM HOSTNAME TO IP ADDRESS DOES NOT REFLECT PROPERLY
JR18388BOGUS SYSTEM FOLDERS SHOW UP IN CONTROL CENTER IF YOU CATALOG A SYSTEM NAME WITH MORE THAN 21 CHAR VIA CLIENT ASSISTANT
JR18396PROBLEM WITH THE DEFAULT DB2 GOVERNOR PROCESS/SERVICE ON WIN32 PLATFORMS. SQL0567N -567 SQLCODE.
JR18415DB2 V8.1 ADMIN CLIENT INSTALLATION ON WIN WITH NOVELL IS VERY SLOW.
JR18427THE DB2 SETUP WIZARD WAS INTERRUPTED BEFORE THE DB2 HTML DOCUMENTATION COULD BE COMPLETELY INSTALLED.
JR18454INSTALL OF DB2 V8.1 ON SYSTEM WITH PREVIOUSLY UNINSTALLED DB2 V7.X DOES NOT UPDATE ODBC DRIVER IN REGISTRY UNDER ODBCINST.INI
JR18480BACKUP TO TAPE ON WINDOWS MAY CRASH INSTANCE
JR18514MEMORY LEAK IN SQLJRPARSESQLDARD
JR18533RECEIVED DWC07275 WITH RC2=7902 ON THE SCHEDULED STEP
JR18537CLI0126E (FP2) ERRONOUSLY REPLACED CLI0150E ON SQLSETCONNECTATTRFOR SQL_ATTR_ODBC_CURSORS / SQL_ATTR_PACKET_SIZE
JR18567DWC - PROMOTING AND DEMOTING A REPLICATION STEP USING XTSERVER/X TCLIENT FAILS.
JR18568IGORE TRAILING NULLS FOR DATE/TIME COLUMNS
JR18592IN THREADS WHICH SHARE THE SAME DATABASE CONTEXT SET CONNECTION INCORRECTLY RETURNS ERROR SQL0843N ( -843 )
JR18598FAILURE TO RELEASE LATCH FLAG CAUSES EMBEDDED APP TO HANG
JR18599DB2CLI.INI PARAMETERS SUCH AS CURRENTSCHEMA ARE LOST BY COMMAND CENTER WHEN DISPLAYING RESULTS TO RESULTS PAGE
JR18613TABLESPACE NAME CAN NOT BE OVERWRITTEN (REGISTER TABLES DIALOG)
JR18629DB2/390 TWOPHASE COMMIT TO UDB 8.1 FIXPAK 2 CAUSES HOST ABEND DSNLI031I REASON 00D34442 IF FEDERATED=YES
JR18631REMOVE THE MANDATORY REQUIREMENT FOR A USER ID AND PWD TO BE INCLUDED IN THE THIN CLIENT INSTALL RESPONSE FILE
JR18667BACKUP, EXPORT, REORG FAIL IN CONTROL CENTER DUE TO SEMICOLON
JR18681DWC - WIP REPORTS SUCCESS, WHEN AIX AGENT (IWH2AGNT) IS KILLED, BEFORE ALL RECORDS ARE WRITTEN
JR18686CONFIGURATION ASSISTANT - CLI CONF. SECTION DOES NOT WORK PROPERLY FOR THIS GUI TOOL.
JR18701SQL10013N LIBRARY DB2NET8F.DLL COULD NOT BE LOADED ON CREATE NICKNAME FOR NET8 WRAPPER. SET PASSTHROU FAILS AS WELL.
JR18712SQLPRIMARYKEYSW RETURNS INCORRECT RESULT FOR THE TABLE ALIAS.
JR18721TESTING ADO CONNECTION IN CONFIGURATION ASSISTANT GIVES 'ADO CONNECTION FAILED. NON-NULL CONTROLLING UNKNOWN'
JR18722CLI0102E WITH NUMERIC/ZONE DATATYPE IN SELECT STATEMENT WITH OLEDB PROVIDER
JR18731DEVELOPMENT CENTER INVOKES THE DISTRIBUTED DEBUGGER, BUT THEN THE DEVELOPMENT CENTER FREEZES
JR18733DB2BATCH NOT RETURNING ANY RESULTS TO STANDARD OUTPUT
JR18746IN RECORDSET OF ADO OBJECT USING IBMDADB2, ALL OF THE FIELDS HAVE ADFLDMAYBENULL SET TO TRUE.
JR18747ADDITION OF CLI KEYWORDS MAPDATEDESCRIBE AND MAPTIMEDESCRIBE
JR18763PROBLEMS WITH CROSS LOADER AND CLI
JR18774RESPECT DB2CODEPAGE IN COMMAND CENTER
JR18787TRAP IN SQLMEIOT AT SQM_EVMON_IOT.
JR18810DB2DAS - DB2DAS00 IS NOT A VALID WIN32 APPLICATION
JR18811DWC - SQL20109W IF DB2DEBUG RUTIME IS SET
JR18812MISSING COMPILE OPTIONS IN WRAPPER_SDK MAKEFILE
JR18834MEMORY LEAK FOUND ON CLI WHEN CONNECTION HANDLE ALLOCATION,CONNECTION,DISCONECTION,FREE CONNECTION HABDLE WERE DONE ON THREADS.
JR18838PROBLEM WITH SQEX CODE CAUSES HANG IN V8 GA
JR18839CRASH DUE TO SEGMENTATION VIOLATION SEGV IN SQLOFICA WHEN CONNECTING TO DATABASE CATALOGED IN LDAP
JR18851SELECT UNIQUE RECORD IDENTIFIER PROBLEM (ODBC)
JR18852DWC - GENERATED SQL IS INCORRECT
JR18858SQL1182N WITH HRESULT=0X80040154 WHEN USING OLEDB TABLE FUNCTION WITH CODEPAGE 943.
JR18873ARRAY INPUT OF LOB AGAIN HOST ABENDS HOST IF LOB VARIABLES ARE NULL.
JR18878SQL_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
JR18912IN VERSION 8.1 FIX PACK 1 THE SCHEDULER PROCESS GETS SHUT DOWN BY THE SYSTEM WHEN YOU LOG OFF.
JR18928ZONED (NUMERIC ON AS/400) RETURNING INCORRECT VALUE WHEN USING IBMDADB2
JR18929QUERY USING LIKE CLAUSE WITH DOUBLE-BYTE CHARACTERS HIT SQL0901N ERROR (REASON 'SQLNO_NUM_CHARS_SPECIFIED [200]:RC( 0) '.)
JR18933SECURITYADMAUTH (NOT IMPLEMENTED YET) IS GRANTED TO USERS WITH DBADM DURING MIGRATION TO V8.1 AND UNABLE TO REVOKE.
JR18935EXTRA 'DRIVER' IN THE CONFIG FILE CREATED BY CA
JR18940GATEWAY HANGS IF CLIENT IS GONE DURING LOBFILE BIND PROCESSING
JR18944DATABASE MIGRATION FAILS IF STORED PROCEDURES HAVE THE SAME SPECIFICNAME, EVEN IF THEY ARE IN DIFFERENT SCHEMAS
JR18946EXPORT/IMPORT TO THE SAME DB2/390 TABLE FROM DB2 CONNECT GOT SQL3169N ERROR
JR18954DB2JDS PROCESS CRASHING IN SQLOFMBLKEX() FUNCTION. THIS CAN BE SEEN IN THE DR. WATSON LOG FILE
JR18963CAN'T CALL API DB2DATABASEQUIESCE AND UNQUIESCE ON WINDOWS
JR18981GEOCODE FAILURE
JR18987CLI STATIC PROFILING SETTINGS NOT DISPLAYED OR UPDATED PROPERLY IN CONFIGURATION ASSISTANT
JR18997PROBLEM USING JDBC GENERATE.JAVA TO CALL DXXGENXML() STORED PROCEDURE. ERROR RETURNED SQL0423N,DXXM011W AND DXXG001E
JR19006DWC - WAREHOUSE CAN HANG WITH NO ERRORS.
JR19009BIG PERFORMANCE HIT IN SQLPRIMARYKEYSW FROM V72->V81
JR19016DWC - CHANGING CONTROL DATABASES DOES NOT REFRESH WIP WITH NEW INFORMATION
JR19028ERROR -1031 DURING CATALOG RESYNC IN MSCS ENVIRONMENT
JR19037DWC - UDP FEEDBACK FILE MAY NOT GOTO CORRECT DIRECTORY IF NON ENGLISH AS/400 IS USED.
JR19040TRAP WHEN USING REGR_SCOPE
JR19043ISSUE SELECT LOCATE(EXP1,CLOB,EXP3) FROM TABLE GET SQL0443N IF EXP3 >4000 WHICH SHOULD BE AVAILABLE FOR CLOBS BUT NOT VARCHAR
JR19050THE COMPILER INCORRECTLY CHANGES THE COLUMN ORDERING IN A UNION OPERATION WHEN USING A NICKNAME
JR19051WHEN CALLING ORACLE UDF VIA RELATIONAL CONNECT,PERFORMANCE IS SLOW.
JR19052SQL -969 (-300) WHEN UPDATE HOST DBCS DATA USING JOINER NICKNAME
JR19053WHEN USING A SELECT DISTINCT TO SELECT FROM A NICKNAME, THE THE DISTINCT IS NOT PUSHED DOWN TO THE DATA SOURCE
JR19060RUNNING INSERT STATEMENT REPEATEDLY CONSUMES APPLICATION HEAP UNTIL SQL0954C IS RETURNED.
JR19064NET STOP OR STOP OF INSTANCE FROM WINDOWS SERVICES CONTROL PANEL FAILS. DB2 COMMANDS ON INSTANCE FAIL WITH SQL30081N RC=54,*,*
JR19119DB2EVMON ON OS/2 RETURNS SYS1808 - EXCEPTION C0000005 IN SQLOGMBLK
JR19120OLE DB PROPERTIES NOT UPDATED WHEN A CONNECTION IS INVALIDATED DUE TO AN ERROR. (CLI0106, CLI0108)
JR19121DWC I-SERIES AGENT REQUIRES TARGET TO HAVE COMMITMENT CONTROL
JR19123DWC- SQLASSIST MOVING A CALCULATED COLUMN TO A SPECIFIED PLACE IN LIST OF COLUMNS, CHANGE FROM ADD TO BOTTOM OF LIST
JR19124DWC - MIGRATION VW 5.2 TO DWC 7.2 FP7.... MISMATCH CAUSED BY MISSING REQ. TO SQLASSIST FOR GROUPBY
JR19125DWC - SCREEN OCCASSIONALLY FREEZES (TURNS GRAY) THIS FIX IS FOR THE FLASH OF FROZEN SCREEN. TO UNFREEZE IT
JR19126DWC- SQLASSIST SEES TWO COLUMNS ATTEMPTING TO BE JOINED AS INCOMPATIBLE , BOTH CHARACTER, ONE IS FOR BIT DATA
JR19127DWC - DOUBLE CLICK REMOVES TABLE FROM RIGHT COLUMN, COMMON CLASSPROBLEM
JR19128DWC - DAILY SCHEDULE SKIPS A DAY IF SCHEDULE IS TO START LESS THAN 24 HOURS FROM CURRENT TIME
JR19129DWC - IN RESPONSE TO ONETIME ERROR 8525 # OF ELEMENTS DIFFERENT SQL CHANGE TO REPORT ALL CODES POSSIBLE FOR THIS
JR19130DWC - SCHEDULE WINDOW SLOW TO RETRIEVE INFORMATION .. CODE TO REDUCE THAT RESPONSE TIME
JR19131DWC - DATES AND TIMESTAMPS DO NOT ALWAYS REFLECT CORRECT INFORMATIION IN WIP.
JR19142CONTROL CENTER NOT SHOWING THE CORRECT USER SECURITY SETTINGS FOR AST TABLES
JR19145TASK CENTER NOT PROPERLY INTERPRETING WINDOWS COMMAND SCRIPTS
JR19146DWC - 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
JR19147THERE IS NO SCROLL BAR FOR UDPS IN DATA WAREHOUSE CENTER. DWC
JR19156SQL30082N RC=17 WHEN UPDATING TWICE DB PARAMETERS FROM CLIENT
JR19267ROWCOUNT IS WRONG AFTER APPLICATION RUNS OUT OF APP_CTL_HEAP
JR19268DWC - DATA WAREHOUSE CENTER SERVER MAY FAIL ON WINDOWS 2000, WITH NT EVENT OF 7031
JR19359SELECT AGAINST DECIMAL COLUMN WHEN USING II, GET SQL901 (REASON "CANNOT PRINT DECIMAL COLUMN".)
LI70001DB2BFD FAILED TO RUN AGAINST A BND FILE ON LINUX
LI70029COPY TABLE IN DB2CC MAY CREATE THE TARGET TABLE IN THE WRONG TABLESPACE.
LI70170SQLBINDPARAMETER CALL WITH CBCOLDEF=-1 RESULT IN CLI0143E ERROR.
LI70197STARTING A NON-UNIQUE SAVEPOINT WITH THE SAME NAME AS PREVIOUS EXISTING NON-UNIQUE SAVEPOINT RETURNS SQL20112N
LI70198COULDN'T START THE SCHEDULER SUCCESSFULLY - SQL22213N
LI70201LOWER DIAG LEVEL OF DROPPED CONN ERRORS
LI70202NULL CONNECTION PASSED TO SQL ASSIST FROM CMD CTR
LI70204NOTIFICATIONMESSAGE FILE BECOMES CORRUPT DUE TO LOCKING PROBLEM
LI70205DB2_ALL NOT WORKING ON LINUX WHEN A SEMICOLON IS USED TO RUN COMMANDS IN PARALLEL
LI70212TRAP IN SQLRIPARSETOENDOFROW FUNCTION WHEN MAKING A CALL TO DRDALAYER TO MOVETO THE START OF THE NEXT ROW
LI70214FIX TRAP DUE TO THE INCORRECT CHECKING FOR DARI_STATE DURING CONNECT TIME
LI70216DEGRADATION IN PERFORMANCE USING JDBC TYPE 4 DRIVER WHEN USING CONNECTION.SETREADONLY(BOOLEAN) METHOD
LI70218SQL1224 OCCURS DURING ATTACH OR CONNECT FROM 32BIT TO 64BIT INSTANCE ON SAME LINUXAMD64 MACHINE
LI70219MIGRATING DATABASE CONTAING NICKNAMES FAILS WITH SQL0901N REASON 'SQLRLM_MIGRATE_6TO8_SYSTABLES_PD: FAILED ON DROP TABLE'.
LI70224HEALTH MONITOR OUTPUT FOR PERCENTAGE OF SORTS THAT OVERFLOWED IN THE EMAIL NOTIFICATION IS INCORRECT.
LI70225HANG IN SQLOSPINLOCKCONFLICT CALLED BY SQLRA_FIND_VAR_VAR
LI70226SIGNAL 11 IN SQLRR_RUNSTATS.
LI70234SIGSEGV WITH JCC T2 DRIVER WHEN USING XA, AND ENCOUNTERING AN XA RETURN CODE OF RM_FAIL
LI70237SMALL TIMING HOLE WHEN RESTORING A DATABASE WHERE THE RESTORING DATABASE WILL ALLOW A CONNECTION. RESTORE FAILS WITH SQL1035N.
LI70239EVENT MONITOR HANGS WHEN PERFORMING A CONNECT OR TERMINATE.
LI70278ARRAYINDEXOUTOFBOUNDSEXCEPTION USING JDBC NET DRIVER.
LI70282TEMP TABLE CLEANUP FAILURE ON CONNECT RESET IN CERTAIN CONDITIONS
PQ74663DPROPR APPLY_SUBSFAILING ALERT CONDITIONS FAIL WITH SQLCODE -303 WHEN COLUMN APPERRM IN TABLE ASN.IBMSNAP_APPLYTRAIL IS NULL.
PQ75324MISSING MAPING IN MMAP WHEN RC RETURNED X'7C' 124 DECIMAL
APAR fixes included in MI00054 (Fixpak 3)
APARABSTRACT
GG04360DPROPR APPLY GETS SQL0204 ON SYSIBM/SYSTABLES WHEN REPICATING FROM AN AS400 SOURCE. THE MESSAGE IS SEEN IN THE QRWTSRVR JOB.
GG04363SAVE FILE FUNCTION DOES PROVIDE OPTION TO SAVE LOCALLY.
GG04383REPLICATION PROGRAMS TERMINATE AFTER ISSUING AN ASN0506E MESSAGE
GG04384INCORRECT DDL GENERATED FOR CD VIEW WHEN REGISTERING A VIEW SOURCE.
GG04386ADD MEMBERS TO A SUBSCRIPTION FAILS WITH SQL0206N
GG04389ADD GRID (LINES) TO THE TABLE CONTAINER ON THE 'DEFINITION' PAGE IN THE REGISTER TABLES/VIEWS/NICKNAMES DIALOG.
GG04390REDUNDANT QUERY CALLS DEGRADING PERFORMANCE IN RC GUI.
GG04392DPROPR RC ERROR CAUSES ASNLOAD TO SELECT CROSSLOADER WHEN NO NICKNAME HAS BEEN DEFINED.
GG04393DPORPR API SHOULD ONLY READ THE SYSTEM CATALOG TABLE, NOT THE SOURCE TABLES,WHEN THE COL_TYPE='A'.
GG0439626 WINDOWS DISPLAYED WHEN SYSPROC MISSING ON MAINFRAME.
GG04400DPROPR APPLY GETS SQL0518N WHEN THERE ARE MORE THAN 62 MEMBERS IN THE SUBSCRIPTION SET
GG04404DPROPR APPLY IS UNABLE TO CREATE THE ASNLOAD PROCESS ON LINUX. APPLY AND THE NEW CHILD PROCESS ARE BOTH HANGING.
GG04405SQLCODE100 ON PRUNCNTL TABLE WHEN APPLY IS PROCESSING AN UPDATE ANYWHERE SUBSCRIPTION WITH VIEWS.
GG04412DPROPR ASNAPPLY/OS2 GETS ACCESS VIOLATION SYS3175
GG04413APPLY REPORTS SQL1403N WHEN IT SHOULD REPORT SQL1040N.
GG04414DPROPR APPLY AND ASNLOAD HAVE PROBLEMS WHEN ASNPATH IS SET ON UNIX PLATFORMS.
GG04417THE *.LOB SPILL FILES CREATED BY DPROPR APPLY ARE NOT ALL DELETED. ONLY 32767 FILES ARE DELETED.
GG04419ASNAPPLY FULL REFRESH PREPARE STATEMENTS FAILS WITH COORELATION ID
IY34028SQL STORED PROCEDURE BODY CANNOT BE VIEWED IN CONTORL CENTER
IY39964LOAD OR IMPORT OF A LOBFILE THAT IS LARGER TAHN 2 GB WILL FAIL
IY40718SQL0723N WITH SQLCODE -950 DELETING FROM A TABLE WHOSE DELETE TRIGGER DELETES FROM A TABLE WITH RI CONSTRAINT TO ITSELF
IY40806V8 INSTALL IS UNINSTALLING THE EXISTING JAVA SDK ON HPUX AND REPLACES IT BY 1.3.1.02
IY41143IN V8 SMP/MPP, FETCH FIRST N ROWS IS PARALLELIZED UNDER STRICTERRULES
IY41173PROBLEM WITH CCA USING PROFILE FROM V720 CONNECT IN V810/DB2FIMPDIRECT CONNECTION ALWAYS CONFIGURED WHICH IS NOT CORRECT.
IY41550DB2 CONNECT V8.1 GA IS LOOKING FOR LIBMQMAX.A IN /OPT/MQM/LIB RATHER THAN FOR LIBMQMAX.SO
IY42135SQLFOREIGNKEYS MISS ON PREDICATE FOR FORKEY_EEEA & FORKEY_EAEE
IY42244SQL1042N WHEN PERFORMING ROLLFORWARD TO END OF LOGS AND STOP WITH OVERFLOW LOG PATH SPECIFIED.
IY42327INCORRECT PASSWORD ON CONNECT IS DISPLAYED IN THE COMMAND CENTER IN V.8. SQL30020.
IY42347MDC 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
IY42673ADMIN CLIENT: DB2SCHEMA.BND IS MISSING IN SQLLIB\BND
IY42742SQL 30020 RC=1245 RETURNED FROM THE HOST WHEN APP IS USING SCROLABLE CURSORS.
IY43009SQLCODE: -7, SQLSTATE: 42601 WHEN USING THE UNIVERSAL DRIVER AND SQL STATEMENTS CONTAIN SPECIAL CHARACTERS.
IY43098SQL6555N IS RETURNED FROM AUTOLOADER IF AN INCORRECT RECLEN IS USED
IY43162DB2ADMIN STOP FAILS WITH AUTHENTICATION ERROR
IY43227VISUAL EXPLAIN TUTORIAL FILES CANNOT BE IMPORTED SUCCESSFULLY
IY43251SOME DOCUMENTED REGISTRY VARIABLES NOT SHOWING UP IN DB2SET -LR
IY43419THE CONTROL CENTER CANNOT START A REMOTE INSTANCE IN ADMIN MODE ON A UNIX DB2 SERVER.
IY43456CLI0112E ERROR IN ASSIGNMENT. PROBLEM DOES NOT OCCUR IN DB2 V7
IY43723CALLING SP WITH INOUT PARAM THAT ARE OF DATA TYPE DATE, TIME OR TIMESTAMP FROM THE CLP CAUSES CLP TO TRAP
IY43752OPTIMIZATION OF REFERENTIAL INTEGRITY VERIFICATION NOT TAKING PLACE WHEN PARENT TABLE IS IN A SINGLE NODE NODEGROUP.
IY43787SQLLIB/FUNCTION/JAR EMPTY AFTER DATABASE MIGRATION
IY43925SIG11 IN FIND_PAGE WHEN RUNSTATS WITH DISTRIBUTION AND DETAILED INDEXES ALL IS RUN ON VERY LARGE TABLES ON 64-BIT INSTANCE
IY44018EEE LOAD PARTITIONING AGENT MUST REJECT INVALID DATETIME DATA.
IY44270SQL0104 RETURNED WHEN USING THE ODBC {FN } ESCAPE SEQUENCE FOR SQL92 FUNCTIONS SUCH AS COALESCE
IY44327DLFM CONNECTION MANAGER V8.1 BINDS TO A SPECIFIC IP INSTEAD OF ANY IP AS IT USED TO ON V7.2.
IY44359SELECT FROM SNAPSHOT TABLES IN V8.1 64 BIT UNIX MACHINES FAILS WITH SQLO443N WITH DIAGNOSTIC TEXT 'DBA7612'
IY44360ROLLFORWARD IN EEE WITH OVERFLOW LOG PATH FOR EACH INDIVIDUAL NODE DOES NOT GET PICKED. ONLY THE DFT LOGPATH IS USED...
IY44397V8 RETURNS -901 TO CLIENT WHEN RECEIVES ERR DURING BINDING WHICH CAUSES PACKAGES TO NOT BE BOUND EVEN WITH SQLERROR CONTINUE.
IY44434CONNECTING FROM V7 CLIENT TO V8 SERVER ON DIFFERENT OS AND BUILDING JAVA SP FAILS WITH ERROR SQL0104N FROM CLP & SPB.
IY44445TIMING HOLE DURING STOP AND STOP FORCE
IY44454IN NT, EEE WHEN DB ACTIVATED, CONNECTION EXIST AT CATLG NODE AN D ISSUING DB2STOP NODENUM FROM NON-CATALOG NODE HANGS.
IY44484TRAP IN CLI_CALLDRDAINPUT(), CLI_CALLDRDAOUTPUT(). STACK TOP MAYSHOW SQLPROCEDURECOLUMNS. CLI TRACE MAY END WITH SQLFETCH.
IY44499SQLJ APP. FAILS ON SELECT STATEMENT WITH SQLCODE 0, SQLSTATE 42122.
IY44519INTERNAL V7 STORED PROCEDURES AREN'T MIGRATED TO USE THE NEW DB2SCHEMA LIBRARY WHICH RESULTS IN SQL0444N.
IY44531SUPPORT NULL-TERMINATED STRINGS FROM ISERIES STORED PROCEDURES
IY44532SIGNAL 11 AT SQLNO_CONV_CHAR2FLOAT WHEN PERFORMING A QUERY
IY44539CONNECTION HANG WHEN USING THE SAME CONTEXT TO CONNECT TO TWO DB IN MULTITHREAD ENVIRONMENT.
IY44549IN V8 'FETCH FIRST N ROWS' FOR SELECT DEGRADES PERFORMANCE POSSIBLY FOLLOWED BY SQL0954C
IY44559INSTANCE ATTACH IS LOST AFTER A FAILURE DURING A SHOW DETAIL CLP COMMAND
IY44593MS ACCESS: DYNAMIC KEYWORD FAILS.
IY44638CONNECT CHANGING PASSWORD FAILS ON CLIENT WHEN DATABASE CONFIGURATION AUTHENTICATION = CLIENT
IY44700FILTER INDEXES WHERE TABLE TYPE = 'N'.
IY44711NON-XA CONNECTION FAILS WITH SQL1248.
IY44714BAD RESULTS WHEN WHEN TRYING TO REVISE THE DISTINCT ENFORCEMENT
IY44755ALTER TABLE COMMAND WITH COMPRESS OPTION CAUSES MEMORY CORRUPTION
IY44867CHANGING THE TIME RETURNED ON LIST INDOUBT TRANSACTIONS TO REFLECT XA_END()
IY44937CLI0115E INVALID CURSOR STATE IS RECEIVED WHEN CALLING A STORED PROCEDURE FROM DB2 V8.1 CONNECTING TO V7.1 OS/390 VIA CLP
IY45005FALSE COSTING IN EVALUATING MQT REDIRECTION
IY45024PROBLEMS WITH LOG HEADER STATE
IY45067WRONG UTF8 SUB CHAR SINCE V8 GA.
IY45172HIPER: QUERY MAY NOT BE ROUTED TO MQT ON NICKNAME ALTHOUGH IT CAN.
IY45221SQL0811 IS RETURNED WHEN A SELECT QUERY THAT CALLS SP IS EXECUTED. IN THE ACCESS PLAN, THE SP WAS EXECUTED BEFORE WHERE CLAUSE.
IY45223SEGV (SIGNAL#11) IN FUNCTION SQLRIPREFETCHBIDS().
IY45256SQL0901N WHEN MERGING TWO UNION OPERATIONS IN THE SAME QUERY DURING QUERY OPTIMIZATION.
IY45275DC HAS DB2JCC_LICENSE_CISUZ.JAR IN CLASSPATH ON CLIENTS.
IY45436SMS TABLESPACE NEEDS TO CHECK IF LARGEST POOL PAGE NUMBER HAS BEEN REACHED.
IY45505DATABASE ROLLFORWARD COMPLAINS ABOUT PAGE HEADER PROBLEMS
IY45603Error calling a stored procedure using type 4 connection and set Object() method.
IY45631JCC driver returns message "The DDM parameter value is not supported" with value 0x113f from OS/390 stored procedure call
IY45676LOAD/IMPORT WE DO NOT TAKE INTO ACCOUNT THE NULL AT THE END OF THE DATA
IY45685XA_RECOVER() IS RETURNING TRANSACTIONS THAT ARE IN THE 'E' STATE.
IY45705SQL0955 WHEN ISSUING MULTIPLE DROP INDEX STATEMENTS
IY45731FILTER FACTOR IS WRONG WHEN COMPARING VARGRAPHIC COLUMN WITH A CONSTANT OF CHAR TYPE
IY45739POSSIBLE DATA CORRUPTION DURING AN MPP LOAD FROM DEL FILE USING MULTIPLE PARTITIONING AGENTS.
IY45766ENGINE CAN'T FIND DEFAULT COLUMN VALUE WHEN RUNSTATS, TRAPS IN SQLRLGETDEFAULT() OR SQL0901N (LOADDEFAULTS:NONE FOUND) RETURNED
IY45833CREATE EVENT MONITOR STATEMENT DOES NOT ALLOW 'ON NODE' CLAUSE IN SINGLE PARTITION DATABASE ENVIRONMENT, SQL0266N RETURNED
IY45841V8 DB2 IS CRASHING WHEN CONNECTED TO FROM SOME V7 CLIENTS
IY46002FILE_TRANSFER_CMD LOADS 0 ROWS WHEN LOAD FILE IS ON OS/390 HOST.
IY46162VALUE OF PARM_MODE CHANGED AFTER RESTORING A V7 BACKUP TO V8.
IY46319SQL0955 RC=2, OTHER OUT-OF-DATABASE MEMORY ERRORS IN DBHEAP, PACKAGE CACHE, UTILITY HEAP WHEN CONCENTRATOR IS ENABLED
IY46320SQL0973 OUT OF DBHEAP, PACKAGE CACHE ERRORS, SQL2009 OUT OF UTILITY HEAP DUE TO MEMORY LEAK WITH MONITORING OF TEMP TABLES
IY46578ERROR SQL30021 WHEN CONNECTING USING TYPE 2 CONNECT TO A DB2/390DATABASE THROUGH A DB2 CONNECT SERVER
IY46603DATABASE GOES DOWN WHILE TAKING AN INCREMENTAL BACKUP OF DMS TABLESPACE
IY46652MIGRATION FROM V7 TO V8 COMPLETES BUT SQL1088 IS RETURNED.
IY46807INSTANCE CRASH WHILE CALCULATING QUERY DEPENDENCIES
IY46809SQL30082 REASON CODE 15 WHEN USING DECRYPT_CHAR() WITH A PASSWORD SET WITH SET ENCRYPTION PASSWORD IN SMP ENVIRONMENT.
IY46813CONNECTION HANDLE IS NOT FREED UP AFTER FAILED ROLLBACK FOR THE FAILED (DEAD) CONNECTION.
IY46814TO FIX MISORDERED ROWS ON REORG WITH CLUSTERED INDEX.
IY46818PREDICATE NOT BEING PUSHED DOWN FULLY, RESULTS IN NEGATIVE PERFORMANCE IMPACT.
IY46819FIX CONNECTION POOLING CLEANUP LOGIC DURING DATABASE FAILURE
IY46829SNAPSHOTS WHOSE TEXT STRINGS ARE CODEPAGE CONVERTED CAN RESULT IN INCORRECT LENGTHS IN ELEMENT AND LOGICAL GROUP HEADERS.
IY46831WHEN CHIME_STRING AND CAST FUNCTION IN A SELECT FROM A NICKNAME, THE SELECT DOES NOT WORK
IY46832ENABLING DUAL LOGGING WITH LARGE LOG FILES CREATES VERY LARGE PERFORMANCE DEGRADATION (70-100X).
IY46833DATA IS LOST WHEN RESTORING BACKUP IMAGES OF MULTI-CONTAINER, SM S TABLE SPACES WHICH CONTAIN LOB DATA.
IY46840INSTANCE ABENDS IN SQLED_CALLBDRDAOUTPUT__FP7UCINTFC + 0X16B0 WHEN TESTING JAVA SP ON 4 NODE DB2
IY46841PERFORMANCE DEGRADATION ON QUERY WITH IN LIST OF 200 OR MORE ELEMENTS AFTER UPGRADE TO FIXPAK 4
IY46845status of application in monitor may show up as UOW Executing while actually being in (interally triggered) rollback
IY46846DB2CC: CANNOT ALTER BUFFERPOOL OF EXISTING TABLE WITH THE CONTROL CENTER OF FP9
IY46847SELECT * FROM TABLE IN DB2SQL92, WHERE THE BLANK BETWEEN SELECT AND STAR IS REPLACED WITH A TAB, FAILS WITH SQL0084N
IY46857SQL QUERY TRAPS INSTANCE WITH SIGSEGV#11 IN DISCONNECT_TREE DURING QUERY REWRITE PHASE
IY46858XASTART() RETURNS XAER_PROTO, SHOULD RETURN XAER_OUTSIDE WHEN LOCAL STATEMENT EXISTS BEFORE XASTART() IS CALLED.
IY46859DB ACTIVATION TAKES A LONG TIME WITH SQLPGILT,PROBE:484 IN THE DB2DIAG.LOG
IY46860JDBC RESULTSET.CLOSE() STATEMENT WILL CLOSE THE STATEMENT, AND NOT JUST THE RESULTSET.
IY46865FAVOUR FULLY QUALIFIED UNIQUE INDEX ACCESS OVER OTHER INDEXES ACCESSES
IY46869INCORRECT REWRITE OF QUERY WITH OR PREDICATE TO UNION
IY46873PERFORMANCE DEGRADES WHEN FEDERATED PART IS NOT RIGHT LEG OF THEUNION WITH A LOCAL QUERY
IY46877OPTIMIZER DOES NOT CHOOSE A SUMMARY TABLE WHEN IT IS AVAILABLE.
IY46890OPTIMIZER-ROUTED MQTS OVER NICKNAME ARE NOT USED FOR QUERY OPTIMIZATION ON DB2 EEE FEDERATED SYSTEM
IY46931DB2SPLIT SIGSEGV WITH CERTAIN LOCALES.
IY46955LONG PREP TIME DUE TO EXPONENTIAL GROWTH IN THE NUMBER OF CANCATENATED KEYS
IY46956WHEN USING THE LIKE PREDICATE FOR GRAPHIC COLUMN TYPE, WE DO NOT CONSIDER USING START/STOP KEY FOR THE INDEX, WE USE SARGABLE
IY47000BAD PAGE ENCOUNTERED IN SQLIFIX
IY47007DB2AUDIT.LOG CORRUPTED WHEN FILESYSTEM FILLS
IY47009ERROR MESSAGE DXXQ045E IS GENERATED WHEN ATTRIBUTES HAVE THE SAME NAME.
IY47010If db2 is started using LANG=zh_CN.hp15CN, will produce SQL4304N reason code "5", when running a Java Stored Procedure.
JR04896INSTANCE CRASH IN SQLRI_CLOSE_UDF_UFOB_CLEANUP()
JR17978FP3: ESE: WIN: FIX MISSING MESSAGE DLL EVENT LOG WARNINGS
JR18065SQL0303 - SQLTYPE 488 COLUMN ON AS400 IS BEING TRANSLATED AS 488 EVEN THOUGH THERE IS NO ZONED DECIMAL IN UDB (SHOULD BE 484)
JR18136CURRENTSCHEMA IS NOT FLOWING UP TO THE HOST
JR18149FP3: COMMAND CENTER SHOULD PROMPT FOR USERID/PASSWORD
JR18251SQL30082 RC 24 WHEN TRYING TO CHANGE HOSTPWD FROM CLIENT APPLN PGM
JR18268LAUNCHING HEALTH CENTER CAUSES ATTACH REQUEST TO ALL INSTANCES CATALOGED ON THE MACHINE RUNNING HEALTH CENTER
JR18322BIND OF DDCSMVS.LST FAILS WITH SQL0551 WHEN SECOND AUTH ID IS USED.
JR18362DB2DCLGN DOES NOT ADD A NULL TERMINATOR (\0) PLACE HOLDER WHEN GENERATING STRUCTURES FOR C LANGUAGE
JR18376TOO BIG VALUE REPORTED IN BUFFER POOL EVENT MONITOR OUTPUT.
JR18392DWC-V8 , LINUX CONTROL DATABASE, COLUMN NAMES ARE LIMITED TO 18 CHARACTERS
JR18406GET DBM CFG FROM CC FOR NEW INSTANCE SHOW CORRUPTED ENTRIES
JR18411DWC - HEARTBEAT CHECKER FOR DWSERVER AND XTSERVER/STARTING XTSERVER AS A SERVICE.
JR18412DATE LOG ERROR
JR18419BACKLEVEL CLIENTS USING V8 GATEWAY TO HOST GET SQL30081 RC=15 WHEN AUTHENTICATION ON CLIENT SET TO DCS_ENCRYPT
JR18442IMPORT OF IXF WITH THE INSERT_UPDATE OPTION ON A TABLE CREATED WITH A PRIMARY KEY NAME 30 CHARS LENGTH FAILED WITH THE SQL3203N
JR18446DBA1177 WHEN TRYING TO SAVE A SCRIPT IN THE DB2 COMMAND CENTER
JR18450PRECOMPILE FAILS WHEN THERE IS UPDATE STATEMENT FOR INSTEAD TRIGGER FOLLOWING ANY OTHER DML STATEMENT
JR18458CONTROL CENTER'S DISPLAY UTILITY, GENERATES A BLANK DISPLAY UTILITY BOX WITH HALF FORMATTED BUTTONS.
JR18473ROUTINES WILL LEAK MEMORY IF AGENTS ARE BEING CREATED/DESTROYED FREQUENTLY
JR18482DB2.EXE HANGS WHEN MORE THAN ONE DB2CMD.EXE STARTED CLOSELY
JR18534STANDARD CONNECTION OF CONFIGURATION ASSISTANT FAILS WITH SQL0104N IN WINDOWS 98.
JR18535ON WINDOWS 2000 A 'DB2 FORCE APPLICATION (APPL-ID)' KILLS THE JVM AT XAEND() INSTEAD OF THROWING AN XA EXCEPTION.
JR18538APAR TO TRACK TOOL THAT MANUALLY RECATALOGS SCHEMA PROCEDURES ASTRUSTED THREAD-SAFE PROCEDURES TO IMPROVE PERFORMANCE
JR18574GET SNAPSHOT FOR ALL BUFFERPOOLS SHOWS DUPLICATE OF DIRECT READS IF THE DBM CONFIG PARM, DFT_MON_BUFPOOL IS SET TO OFF.
JR18643QUERY CRASHES THE INSTANCE WITH SIGNAL 11 WHILE MERGING OUTER JOIN.
JR18735failure to throw batch update chain break exception
JR18802REORGCHK OVERESTIMATES THE ISIZE
JR18804JDBC RESULTSETMETADATA.GETCOLUMNCLASSNAME() RETURNS JAVA.LANG.SHORT BUT SHOULD RETURN JAVA.LANG.INTEGER OR NUMERIC FOR SMALLINT
JR18808SHARE LOCK HELD BY UR NO HOLD SCANNER
JR18813MAPPING COLUMNS TAKES A LONG TIME IN THE COLUMN MAPPING PAGE
JR18814DWC - GUI , WIP NOT SHOWING THE SAME TIMESTAMP AS THE SERVER.... INSTEAD SHOWS LOCAL TIME, UNTIL LOCAL REFRESH IS DONE
JR18815DWC/SQLASSIST JOIN TAB PROBLEM A JOIN WAS DROPPED FROM VIEW ON TAB. SQL IS CORRECT
JR18817DWC COLUMN MAPPING PROBLEM , PROVIDE CORRELATION NAME FOR SOURCE AND TARGET WITHIN STEP
JR18823DWC VARIOUS SQLASSIST GROUPING PROBLEMS
JR18824DWC -JDK NEEDS FEATURES FROM JDK 8 TO IMPROVE SCROLLING AND MOVEMENT THROUGH DATA
JR18825DWC/SQLASSIST COLUMN NEEDS SCROLLING MECHANISM FOR SELECTED COLUMNS
JR18826DWC - DATES SORT ALPHABETICALLY INSTEAD OF CHRONILOGICALLY
JR18827DWC/SQS ASSIST WHEN LINKING TWO LIKE NAME TABLES IN DWC, HANG CAUSED BY SQL ASSIST
JR18828DWC -FROM VW 5.2 BV'S WHICH USED FLAT FILES, IN MIGRATED DWC VER. 7.2 STEPS, NO COLUMN NAMES ARE SHOWING.
JR18829DWC- COPY OR MOVE OF STEP IS NOT REFRESHED WITHOUT CLOSING AND RE-OPENING NAVIGATOR,APPEARS AS MISMATCH WITH METADATA
JR18830DWC- STEP DEMOTED OR PROMOTED IN NAVIGATOR, STATUS OF LOCKS MAY NOT BE ACCURATELY DISPLAYED
JR18833Migration failure due to UDF_MEM_SZ heap problem.
LI70022CREATION OF DMS TABLESPACE BY USING RAW DEVICES ON PLATFORM LINUX S/390 (ZLINUX) WILL RESULT IN ERROR SQL1422
LI70156LIKE CLAUSE WITH '%' FULL SELECT WILDCARD, PRODUCES POOR JOIN ORDER
LI70164FULL OUTER JOIN TREE, WITH FILTERING PREDICATE, CONVERTED TO LOJTREE, WITH FILTER AT THE TOP. ADD PUSHDOWN OF THE TOP JOIN.
LI70172TRAP IN CLI_SQLCOMPLETEARRAYINPUTCALLBACK
LI70192MEMORY LEAK:ERROR IN DETACHING FROM SHARED MEMORY LEAKS MEMORY SEGMENTS ( SQLOFSHR IN DB2DIAG.LOG ),LEADS TO SQL1221 ON CONNECT
LI70194JAVA.SQL.SQLEXCEPTIONS FROM THE DB2 TYPE 4 UNIVERSAL JDBC DRIVER FAIL TO SERIALIZE.
LI70195SIGNAL #11 TRAP IN SQLNR_LOCAL_OJPRD_PUSHDOWN WHEN DB2_ANTIJOIN=YES AND DOING AN INSERT WITH NOT EXIST SYNTAX
APAR fixes included in MI00048 (Fixpak 2)
APARABSTRACT
GG04357DPROPR ASNLOAD DOES NOT SUPPORT LOGRETAIN VALUE OF CAPTURE
GG04358DPROPR APPLY WITH COPYONCE OPTION ALWAYS RETURNS A RETURN CODE OF 0, NO MATTER WHAT HAPPENS (SUCCESS OR ERROR)
GG04359APPLY FAILS TO RECONNECT TO A SERVER AFTER ITS CONNECTION TO THE SERVER HAS BEEN TERMINATED.
GG04372WHEN DPROPR CAPTURE OR APPLY IS STOPPED EITHER WITH A COMMAND OR CTRL-C, USER MAY GET SIGSEGV.
GG04380DPROPR APPLY: COMMIT(N) SUPPORT FOR CCD TABLES
GG04381APPLY GETS A ASN1020S ON FP8
IC36180MIGRATE SPATIAL ENABLED DATABASE ERROR: GSE0219N AN EXECUTE IMMEDIATE STATEMENT FAILED.
IY33144CLI0119E WHEN RUNNING MUTLI-THREAD JAVA APPLICATION ON AIX
IY38280DB2DIR STILL POINTING ON /USR/LPP/DB2_07_01 AFTER MIGRATION INSTANCE TO V.8
IY38385FIX DB2ISETUP TO SUPPORT RESPONSE FILE INSTANCE CREATION
IY38508CONFIGURATION ASSISTANT REPORTING INCORRECT VALUES.
IY38693INTRODUCE DB2 KEYWORD TO ALLOW V7 FUNCTIONALITY FOR UNCOMMITTED UNITS OF WORK ON UNIX SYSTEMS.
IY38715DB2SYSC LOOPS IN SQLESRL THOUGH FUNCTION SQLOPOST, WHEN THERE ISA MISMATCH BETWEEN DATABASE LOCALE AND DB2CODESET
IY38821PARTIAL (TRUNCATED) OUTPUT IN SYSTEM OUTPUT ASCII FILES FROM DB2SUPPORT (E.G., OSLEVEL.OUT , UNAME_A.OUT).
IY38983DB2LOOK FOR FEDERATED OBJECTS DOES NOT SHOW GRANTOR INFORMATION FOR GRANT PRIVILEGE DDL'S
IY39029SIG 5 IN SQLRKRPC_SEND_REPLY
IY39069ENSURE THAT SUFFICIENT DISK SPACE IS RESERVED FOR OBJECTS BEING REORGANIZED WHEN MULTI-PAGE FILE ALLOCATION IS ENBABLED.
IY39127FAIL TO SET PORT RANGE FROM REGISTER VARIABLE DB2ATLD_PORTS
IY39130DURING MPP LOAD, INCORRECT PARTITION HASHING WITH DECIMAL COLUMNDEFINED IN THE PARTITIONING KEY
IY39229ISOLATION LEVEL CHANGES TO ACCOUNT FOR INCREMENTAL REFRESH OF AST
IY39361PREREQUISITE DB2 LINUX/UNIX/WINDOWS CONNECT V8 SERVICE FOR USE WITH WEBSPHERE WORKFLOW AND MQSERIES
IY39362NO ENTRY FOR INFORMIX WRAPPER IS SET IN DB2DJ.INI DURING INSTANCE MIGRATION (DJ=>V8.1FP1) PROCESS.
IY39430OS/390 CANNOT CHANGE SCHEMA AND REBUILD WHEN CONNECTING FROM DEVELOPMENT CENTER ON UDB.
IY39450SQL22201N RC=1 ON V8 DAS AUTHENTICATION HP-UX TRUSTED MODE
IY39489DAS API CALLS HANG DUE TO INSUFFICIENT FILE PERMISSION
IY39667SQL3218C FROM LOAD RESTART (COPY YES ALLOW NO ACCESS)
IY39675DB2 INSTANCE CRASHES ON CONNECT. CAUSE IS TRAP IN SQLPINIT WHENCRASH RECOVERY NEEDS TO BE PERFORMED IN A LARGE CONFIGURATION.
IY39803FORCE REPREPARE WHEN WE COME ELIGIBLE FOR BUFFERED INSERT AGAIN.
IY39953DB2ADVIS SETS INVALID TIME FOR STATS_TIME FOR NEW INDEX
IY40029DATABASE MARKED BAD IN SQLPXREG PROBE:50 , RETURNED RC=F51D
IY40044CREATING INDEX WITH NLS COLLATION USING THAI CODESET TIS620-1 MAY CAUSE INDEX KEYS TO BE OUT OF ORDER.
IY40136SIGNAL 11 IN SQLRIRIDC OR SQLRI_RESTORE_DML_DSS_INFO
IY40152ISSUEING DB2ADMIN START ON V8 AIX SERVER GETS -8050 AND -4401 ERRORS IN DB2DIAG.LOG AND DAS PROCESS DOES NOT START
IY40319SELECT RETURNING VERY LARGE RESULTSET FAILS WITH SQL0804 N RC=''PARTWAY THROUGH (85 MB)
IY40344TRAP IN SQLEDDB2RAASSP WHEN SP CALLED BY BACK LEVEL CLIENT
IY40549DB MIGRATION TO V8 FAILS WITH SQLCODE -569 FOLLOWED BY -501 AT GRANT_PRIVILEGE() PROBE 56 AND SQLJRDRDAARCALL() PROBE 110
IY40718SQL0723N WITH SQLCODE -950 DELETING FROM A TABLE WHOSE DELETE TRIGGER DELETES FROM A TABLE WITH RI CONSTRAINT TO ITSELF
IY40776VALUES TABLE RETURNS INCORRECT VALUE AFTER FIXPAK 3. INCORRECT OUTPUT WHEN THE LAST ROW OF THE VALUES BOX IS REQUIRED.
IY40813WMQ5.3 TRAPS WHEN USED WITH DB2V81. THE MQ APPLICATION RECEIVES A SQL0998 WITH REASON CODE 6.
IY40827INSTANCE CRASH DURING LIST HISTORY WITH LARGE NUMBER OF TABLESPACES.
IY41108SHOULD NOT ALLOW MULTIPLE PARTITIONG AGENTS WITH DISFILE
IY41120DB2IUPDT DELETES ALL USER FILES IN THE SQLLIB/ADM DIRECTORY.
IY41156INCORRECT OUTPUT DUE TO QUERY REWRITE.
IY41223DB2 RESTORE OF IMAGE SPLIT ACROSS MULTIPLE FILES MAY FAIL WITH SQL2054N - CORRUPT IMAGE . THE IMAGE MAY NOT BE CORRUPT.
IY41228CREATION OF GLOBAL TEMPORARY TABLES WITHIN SQL PROCEDURE FAILS WITH SQL0551
IY41232THE DB2 FAULT MONITOR CONTROLLER (DB2FMCD) AUTOMATICALLY CREATESA LOG FILE (FMCD.LOG) IN THE ROOT (/) DIRECTORY.
IY41294WHILE RUNNING DB2BATCH TOOLS AS A SYSCTRL AUTHORITYGETTING AUTHORITY ERROR.
IY41319SQLDRIVERCONNECT()TRAPS WHEN STACK OVERWRITTEN
IY41460MIGRATION CAUSES CORRUPTION IN COLUMNS CONTAINING DEFAULT VALUE
IY41544QUERY WITH AN INLIST PREDICATE RETURNSINCORRECT RESULTS
IY41600DB2START REMOTE INSTANCE FAILING ON WINDOWS DUE TO LIBRARY NOT FOUND
IY41700MEMORY LEAK IN QUERY HEAP CAN RESULT IN ERROR SQL0973N NOT ENOUGH STORAGE IS AVAILABLE IN QUERY_HEAP_SZ
IY41830GRAPHIC TO SQL_C_WCHAR IS NOT NULL TERMINATED
IY41847SQL0204N WHEN CREATING NICKNAME AGAINST DB2 AS/400
IY41870CONNECT TO DATABASE HANGS DUE TO MEMORY LATCHING CONTENTION AS ARESULT OF AN AUTOSTART EVENT MONITOR
IY41902ABEND IN SQM_WRITE_LOCK_WAITS FUNCTION
IY41933V8 AUTOLOADER IS NOT CREATING MESSAGE FILE
IY41956MIGRATION TO V8 CAN FAIL IF IT ENCOUNTERS A LOWERCASE SCHEMA NAME IN SYSDEPENDENCIES
IY41965DB2BATCH -CLI RETURNS INCORRECT NUMBER OF ROWS WHEN ROWS_OUT IS ZERO
IY42321DB MARKED BAD AFTER SYSTEM MEMORY LIMIT REACHED
IY42333DB2 TRAPPING IN SQLERSENDFMPSTART WHEN UDF IS EXECUTED.
IY42348PERFORMANCE PROBLEMS WITH LOGGER CAUSING AGENTS TO WAIT
IY42391BAD UTF-8 DATA IN DB CAUSES INFINITE LOOP IN CODEPAGE CONVERSION
IY42491SIGNAL #11 TRAP IN FUNCTION SQLM_DROP_TS, GET_DBMON_BP OR LOOKUP_DBMON_BP WHEN DROPPING A TABLESPACE
IY42513DB2 ? LIST DATABASE PARTITION & DB2 ? LIST DBPARTITIONNUMS DO NOT RETURN THE CORRECT HELP RESULTS IN V8
IY42526SQL STORE PROC COMPILE CRASHES INSTANCE IN FUNCTION SQLNQ_EXP::CORRELATION_TOQNC
IY42562IN SCRIPT DB2GOVLG LOOKING FOR PWD IN /ETC/PASSWD DOES NOT WORKIN NIS ENVIRONMENT.
IY42569DROP COMMAND LEAVES ORPHAN ENTRIES IN SOME CATALOG TABLES. THIS PREVENTS A TABLE WITH THE SAME NAME TO BE CREATED.
IY42663MEMORY LEAK IN DB2AGENT PROCESS WHEN USING HEALTH MONITOR
IY43034IN MULTI-PARTITION ENV, WRITE TO TABLE EVENT MONITOR FOR DB WILLHANG DB,IF DB2STOP FORCE IS ISSUED WHEN EVENT MONITOR ISRUNNING
IY43135ERROR 'SQL2038N A DATABASE SYSTEM ERROR '27990' OCCURRED' MAY BE RETURNED WHEN LOADING NON-DELIMITED FIXED LENGTH DATA.
IY43271OUTER JOIN QUERY WITH UPPER() SHOULD USE INDEX ON GENERATED COL
IY43273APPEND COSTING FACTOR IN REWRITE FOR INLIST TO JOIN TRANSFORMS WITH MULTIPLE INLISTS
IY43283ENHANCEMENT FOR MDC INDEX ON GENERATED COLUMNS ON DATE, TIME
IY43285DB2.O CREATING DUPLICATE LIBDB2.A LIBRARIES WHEN USING AN ODBC DRIVER MANAGER.
IY43286JDBC TRACE TO SHOW WHICH DB2JAVA.ZIP VERSION IS BEING LOADED.
IY43287DEFAULT LENGTH OF LONGRAPHICS DATATYPE IN THE PRECOMPILER IS INCOMPATIBLE WITH DB2/390
IY43317UNICODE CHARACTERS INSERTED INTO UNICODE DATABASE THROUGH XA CONNECTIONS ARE INCORRECT DUE TO CODEPAGE CONVERSION PROBLEM
IY43319MEMORY LEAK IN SQLESINS() API WHEN SWITCHING INSTANCES.
IY43324AFTER FAILOVER OF DB2 CONNECT IN A 2PC SPM ENVIRONMENT, RESYNC FAILS.
IY43329THE MAXIMUM LENGTH OF DEFAULT VALUE FOR CHAR COLUMN IS INCONSISTENT.
IY43336TWO STORED PROCEDURES ON OS/390, IDENTICAL NAME EXCEPT ONE HAS '_' IN NAME, CALL FROM CLP RETURN CLI0150E. UNDERSCORE=0 SET.
IY43337WHEN USING DB2 UDB + CONN EE TO OS/390 HOST DB ON DB2. EXPORT FROM CLIENT TO IXF LOSSES THE OPTION DEFAULT FROM A TBL DEFINTION
IY43340MINBUFFLSN GETTING INCREMENTED DURING CRASH RECOVERY DUE TO A POTENTIAL TIMING PROBLEM
IY43341ROLLFORWARD RETRIEVING LOG FILES BELONGING TO OLD LOG CHAIN
IY43345RESTART OF DB FAILS
IY43353ALLOWS OUTER JOIN PREDICATES TO BE PUSHED DOWN TO THE REMOTE DATA SOURCE
IY43357CRASH RECOVERY FAILS DUE TO A BAD LOG AND THE DB2DIAG.LOG DUMPS THE WRONG LOG NUMBER AS THE PROBLEM LOG.
IY43358ADDITIONAL DEBUG CODE ADDED TO DIAGNOSE A PROBLEM WITH POTENTIALSOCKET CONNECT LOGIC ERROR IN THE AUTOLOADER
IY43360SIGNAL #11 TRAP IN STRCMP() WHEN CALLED BY SQLBGETQUIESCESTATE()FROM PREFETCHER CODE.
IY43367SET INTEGRITY ON A TABLE WITH SELF-REFERENCING RI AND GENERATED COLUMNS COULD CAUSE AN ENGINE TRAP.
IY43369RECREATE THE GOVERNOR LOG FILE IF IT HAS BEEN DELETED.
IY43370DB2DIAG.LOG FILLS WITH PROBE ID 1 WITH ERROR 2055 AND ALERT NUM 0 BY OPER_SYSTEM_SERVICES SQLO_ACCESS_LISTEN_QUEUE
IY43375CLI0143E WHEN DESCRIBING CHAR AGAINST DB2/AS400
IY43380RESTORING LOAD COPY FAILES DURING ROLLFORWARD , WHEN DB ALIAS NAME IS DIFFERNT FROM DB NAME.
IY43383XML EXTENDER: SQL ERROR MSG NOT DISPLAYED WHEN DXXDISABLEDB FAILS
IY43384WHEN SHREDDING SHIFT-JIS DOCUMENT INTO UTF8 DATABASE, NOT ALL DATA ARE INSERTED INTO TABLES.
IY43385FIX THE FOR STMT OF THE FCT CHANGE_USER_IN_USERFILES IN DB2_INST_HA.LOCAL
IY43387DXXGENXML END ABNORMALLY WHEN IT RECEIVES AN SQL WARNING
IY43388INSTANCE CRASHES BECAUSE WE HIT SQLKF_CONNECT_REQ PROBE 50.
IY43389MESSAGE QUEUE IS LEFT BEHIND AND NEVER GET CLEANED UP UNTIL THE SYSTEM CLEANED IT UP
IY43390REMOTE IMPORT WITH IXF FILES
IY43408PERFORMING AN UPDATE WITH A SPECIFIC TRIGGER WILL TRAP IN SQLNS_ADD_CORRELATION.
IY43423EXPORT ACCEPTS INVALID LOB PATH - NO TERMINATING / OR \
IY43424SQL0313 WHEN TRYING TO IMPORT DATA USING INSERT_UPDATE WITH USEDEFAULTS.
IY43425CHANGING PASSWORD IN CCA RETURNS SQL30083N RC=24.
IY43426IMPORT USING COMMITCOUNT OPTION DOES NOT RELEASE S LOCKS ON SYSCAT.COLUMNS TABLE ON COMPLETION
IY43427FIX DB2DATASOURCE CLASS SO IT IS THREADSAFE
IY43429DB2LOOK -F EXTRACTS WRONG BUFFPAGE VALUE
IY43431INCORRECT RESULTS WHEN USING LIKE PREDICATE ON DBCS DATABASE WHEN TWO CHARACTERS HAVE SAME SECOND BYTE.
IY43432AST MATCHING IMPROVEMENTS
IY43433DATABASE ROLLFORWARD FAILED WITH FFFFF529 (INVALID LSN) DURING THE UNDO PHASE
IY43434DB2LOOK IS MISSING 'DROPPED TABLE RECOVERY ON' CLAUSE
IY43436INSTANCE CRASH WITH SIGNAL 11 IN SQLBFLUSHFORDLSUBSET
IY43437IMPORT TABLE ENDS WITH SQL0604N - TYPE MAPPING 'CHAR(255)' IS NOT VALID
IY43438DB2MOVE <DB_NAME> EXPORT -TN <TB_NAME> DOES NOT EXPORT DATA WHENTHE TABLE NAME CONSISTS OF MULTI-BYTE CHARACTERS
IY43443REORGCHK DOES NOT DISPLAY ALL THE TABLE. PROBLEM IS WITH NICKNAMES DEFINED IN SYSIBM.SYSTABLE
IY43445CLASS ID OF UDF CREATED IN JAVA CAN'T BE EXTRACTED WITH DB2LOOK DB2LOOK WAS USING THE IMPLEMENTATION COL. FOR THE ROUTINE NAME
IY43446ERROR SQL0301N/SQLSTATE 01517 WHEN INSERTING WITH MINMEM MODE.
IY43447ALTER TABLE ADD GENERATED COLUMN TRAPS WHEN SET INTEGRITY IS FOLLOWED
IY43448THE SELECTIVITY CALCULATION FOR OR PREDICATE IS INCORRECT
IY43449SORTING SMALL VARIABLE SIZED DATA IN A NULLABLE COLUMN MAY BE COMPUTED INCORRECTLY
IY43450INCORRECT QUERY RESULTS . SELECT WITH 'OR' TREE. WHEN BETWEEN PREDICATE IS NOT IN THE SAME QUERY BLOCK AS THE ISNULL PREDICATE
IY43451DB2LOOK - CREATE VIEW OUTPUT DOES NOT INCLUDE THE SCHEMA INFORMATION
IY43452IMPORT USING INSERT_UPDATE RETURNS SQL0100W WHEN IMPORT DATA CONTAINS NULL VALUES FOR NOT NULL COL. - SHOULD RETURN SQL3116W
IY43453INCONSISTENT BEHAVIOUR OF JDBC APP/NET DRIVER WITH CLEARPARAMETERS STATEMENT
IY43455REMOVE THE NEED TO BE SYSADM IN ORDER TO BE ABLE TO ISSUE THE CMD 'DB2 UPDATE CLI AT GLOBAL LEVEL'
IY43459ORPHANED DB2AGENT PROCESSES STILL PROCESSING AND HOLDING LOCKS AND RESOURCES LONG AFTER THE ASSOCIATED APP IS KILLED
IY43463EXPLAIN OUTPUT MISSES INDEX OBJECTS.
IY43464CLI0002W WHEN SELECT '' AS COLNAME FROM TABLE. IN TESTING CODEPAGE=819 AND APPLICATION WAS VB CONNECTED THROUGH OLEDB.
IY43465THE OWNER OF THE SEQUENCE IS WRONGFULLY SET TO THE CURRENT SCHEMA.
IY43468AUTOLOADER TRAPPING DURING FORMATTER SETUP
IY43470NULLPOINTEREXCEPTION IN DB2STATEMENT.EXECUTE2 IF USING SCROLL_INSENSITIVE CURSOR ON DELETE FROM EMPTY TABLE
IY43471CALL TO SQLDRIVERCONNECT CAUSES CORE IN STRLEN(), CALLED FROM CLI_UTLINITCONNECTACCTINFO
IY43472FIX TO CONTROL TRANSITIVE PREDICATES AND HANDLE SELF JOINS
IY43478DB2LOOK -O PARAMETER, IF YOU SPECIFY AN OUTPUT FILENAME IN UPPERCASE LETTERS THE FILENAME IS ALWAYS CREATED IN LOWERCASE.
IY43479DB2LOOK -X OPTION DOES NOT RETRIEVE COLUMN LEVEL UPDATES FOR GRANTS
IY43488SIGNAL HANDLER CAUSED MEMORY CORRUPTION IN AGENT PRIVATE MEMORY.AGENT WAS DOING A MALLOC WHEN SIGNAL WAS RECEIVED BY THE PID.
IY43493SQLPGETDBMONLOG REPORTS NUMBER EXTENTS HELD BY BUFFER IS GREATERTHAN EXTENTS USED IN DB2DIAG.LOG
IY43494A CRASH RIGHT AFTER A CLI0135E IN A JDBC APPLICATION.
IY43497DB2LOOK OUTPUT DOES NOT SHOW ALTER BUFFERPOOL COMMAND.
IY43498IN DB2LOOK COMMAND IF THE OUTPUT FILENAME USED IS EQUAL TO OR MORE THAT 32 BYTE(WITH EXTENSION), THE OUTPUT FILENAME CHANGED.
IY43500SQL0880N WHEN TRYING TO INSERT RECORDS INTO A TABLE
IY43521TRANSFORMING A SELF REFERENCING SUB-QUERY INTO A SELF REFERENCING JOIN (REQUIRES A TEMP TABLE)
IY43522BAD PLAN ON SELF TABLE JOIN, WHERE CARDINALITY ON TWO OR MORE JOIN PREDICATES IS UNDER ESTIMATED.
IY43523WHEN USING NICKNAMES FOR LARGE SYBASE TABLES, POOR PERFORMANCE OR ERRORS ARE ENCOUNTERED.
IY43526EXPORT STATEMENT WITH GREATER THAN 32K SELECT RETURNS ERROR.
IY43528CANNOT INTERRUPT A SORT SPILL
IY43529HANG IN FCM LAYER CAUSES DEADLOCK
IY43532DB2SYNC ABENDS WHEN OVER 11 SUCCESSFUL SQLCODES ARE SPECIFIED IN SCRIPT.INF FILE.
IY43533DB2 MUST AUTHENTICATE EITHER LOCAL LOGIN OR SU ACCESS AT A MINIMUM
IY43545THREADS CONNECTIONS NOT FREED PROPERLY FROM A JAVA PROGRAM
IY43551ENGINE TRIES TO PLACE A TABLE LEVEL S LOCK ON SYSTABLES WHILE DOING 'ALTER TABLE NOT LOGGED INITIALLY WITH EMPTY TABLE'
IY43554ABEND IN SQLGETTYPEINFO DURING WMQI INITIAL DEPLOY TO A BROKER
IY43559JDBC NET DRIVER, SUBSEQUENT REBIND AND EXECUTE OF STATEMENT RETURNS SAME # OF ROWS AS FIRST EXECUTE. LAST ROW REPEATED.
IY43563SIGSEGV IN SQLM_FIND_ELEMENT() DURING GLOBAL SNAPSHOT ON BUSY MULTI-PARTITION INSTANCE
IY43580DB2 UDB ESE V8.1 FOR AIX INSTALLATION PROBLEM WHILE UPDATING DASADM_GRP TO 'ESADB2AS' FOR DB2 ADMINISTRATION SERVER.
IY43581SQL0405N OCCURS WHEN SQL STATEMENT IS RUN USING STATEMENTCACHE
IY43596F8 WHEN USING INVOKE TO CALL A SP IF IT IS SUCCESSFUL THE RC=2 INSTEAD OF RC=0
IY43607INSTANCE CRASH WHEN SELECTING FROM A VIEW.
IY43647NET DRIVER SENDS WRONG LENGTH TO HOST FOR VARCHAR EXCEEDING 8K
IY43703Function sqlePeekDb2raBuffer traps when peeking invalid buffer
IY4384664-BIT SUPPORT FOR SPATIAL EXTENDER IS NOT INCLUDED IN V8 FP1
IY43882IMPPORT WITH LOBS INFILE FAILS WITH SQL0973N, NOT ENOUGH STORAGEIN APP_CTL_HEAP
IY43949LIST APPLICATIONS MAY NOT RETURN AN ACCURATE COUNT IF ONE OR MORE DATABASES ARE NOT ACTIVE.
IY43953SQL0430N UDF 'DB2XML.EXTRACTDATE' ABNORMALLY TERMINTED. DEFFECT NUMBER 275384
IY43974INCORRECT ERROR HANDLING FOR OUT OF MEMORY CONDITION IN BINSORT COULD LEAD TO A TRAP
IY43976REFRESH TABLE RETURNS SQL0901N WITH REASON 'FOUND ZERO CLOB.RESET'
IY43977EEE : AUTOLOADER FAILING WITH SQL3508N,RC=1
IY43978DATABASE PREFETCH_WAIT_TIME DOES NOT INCLUDE TIMES FOR TERMINATED APPLICATIONS
IY43982SIG 11 IN SQLRI_HSJNNEWTUPLE CAUSING ENGINE CRASH
IY43990A CLI0114E ERROR SHOULD OCCUR WHEN EXECUTING SQL WHERE THE FRACTIONAL SECONDS FIELDS OF TYPE SQL_C_TYPE_TIMESTAMP GETS TRUNCATED
IY43991SQLFREEENV GETTING AN INVALID SEQUENCE ERROR UNDER MULTICONNECT
IY44001ENHANCEMENTS OF SOPMERGE RULE IN QUERY REWRITE TO ALLOW MULTIPLEUNIONS MERGED WITH SELECT BOX IN BETWEEN.
IY44003TO FIX THE SELECTIVITY FOR SUBTERMS OF AN OR PREDICATE WHEN THE SUBTERM CONTAINS HOST VARIABLE OR PARAMETER MARKERS.
IY44004SIGNAL #11 IN SQLNO_PROP_JCARD()
IY44015SIGSEGV IN SQLUIMPM DURING LOB PROCESSING
IY44017FIX SORTING PROBLEM FOR IDENTITY_16BIT COLLATING SEQUENCE ON CH AR KEYPARTS.
IY44019SIGNAL 11 GENERATED WHEN CALLING SQLJ.INSTALLJAR FROM CLIENT OR NON-CATALOG NODE.
IY44030DB2 REORGCHK ON NON-EXISTENT TABLE DOES NOT RETURN ERROR OR INFORMATIONAL MESSAGE.
IY44168BLOCKING CURSOR ELEMENT IN SNAPSHOT MONITOR ALWAYS SHOWS NO
IY44198POINT IN TIME RECOVERY GOES BEYOND SPECIFIED PIT WHEN THERE IS AN INFO_ONLY LOG RECORD.
IY44380v72 Client hangs against v81 (migrated from v72) DB
IY44390ONLINE BACKUP WILL WAIT FOR RELEASE OF LOCK ON AN IMPORT JOB.
IY44399DB2 ALLOWS DELETE OF ROWS WHEN RI SHOULD PREVENT DELETION DUPLICATE.
IY45245DB2DIAG.LOG REPORTS "STATEMENT NOT PROTECTED" IN SQLRA_ROLLUP_DYN_STMT PROBE:20 AND/OR TRAP OCCURS IN SQLRA_CACHE_DEL_INV.
JR04895CLI0125E ON SQLFREEHANDLE() IN MULTITHREADED APPL.
JR17661START APPLY/CAPTURE WITH NON INSTANCE-OWNER USER FAILS
JR17685CAN NOT HAVE A DB NAME > 8 WHEN SETTING UP A DSN IN V8
JR17781CPYSETUP.BAT FOR DB2 V8.1 GA IS NOT FUNCTIONING.
JR17796MEMORY LEAK IN DB2 CONNECT CONNECTED TO DB2/390 WHEN DB2BIDI REGISTRY VARIABLE IS SET.
JR17800TABLESPACE LEFT IN RESTORE PENDING STATE ,AFTER RF TO EOLS.
JR17833RUNSTATS FAILS FOR SOME DATABASE SYSTEM TABLES WHEN ISSUED USINGTHE TASK CENTER.
JR17867JDBC NET (TYPE III) DRIVER BATCH PROCESSING MISHANDLES SQL_NO_DATA_FOUND
JR17878WHEN THE PARSER FINDS THE TWO DECIMALS, IT INSERTS A CAST FUNCIT. THIS CAUSES A SEGMENTATION FAULT.
JR17880METHOD INVOCATION BROKEN WHEN RESULT IS A DISTINCT TYPE. USAGE WILL RESULT IN SQL0901 RC='NO CAST FUNCTION'
JR17891TRIGGER COMPILATION RESULTS IN SQL0101N DUE TO INFINITE LOOP
JR17901SQL0901N LENGTH MISMATCH FROM SQLRA_FP_CONVERT_UNDEC_TO_STRUCT
JR17903DWC/8.1 REMOVING SOURCE - FUI REMOVE NOT SHOWING
JR17905DWC 8.1 DDD TO CONTINUE IF NO CORRELATION ON REMOVE OF TARGET
JR17921CONTROL CENTER 'ESTIMATE SIZE...' WINDOW FOR TABLE W\ 16K PAGES DISPLAYS INCORRECT SIZE WHEN DISPLAY UNITS SET TO 'KB'.
JR17925SYMPT/QUES: RUN GETSTART_INSERTDTD IN XML TUTORIAL GOT SQL0444N ERROR, CAN NOT ACCESS DB2XMLFN.DLL
JR17933CANNOT CONNECT THROUGH LDAP TO THE HOST DATABASE IF DB IS CATALOGED WITH LESS THAN 8 CHARACTERS IN DBALIAS - SQL30020 RC=124C.
JR17944MISLEADING WARNING MSG SQL0100 WHEN USING TRIGGER WITH INSTEAD OF INSERT IN A USER DEFINED FUCNTION IN C
JR17948INDEX CORRUPTION ON CONCURRENT INDEX CREATE OR ONLINE REORG ON WINDOWS
JR17994INCORRECT BEHAVIOR FOR CLP COMMAND LINE ARGUMENTS
JR18022DB2 V8 SQL GUIDE LISTS LONGEST FUNCTION PARAMETER NAME AS 128BYTES, BUT WILL FAIL IF GREATER THAN 18BYTES.
JR18028CLI0150E WITH SQLDESCRIBEPARAM FOR STORED PROCEDURE
JR18051DURING IXF IMPORT THE PRIMARY KEY IS NOT CREATED EVEN THOUGH IT IS DEFINED IN TABLE BEING EXPORTED
JR18060INDEX KEYS MISORDERED DUE TO ERROR IN BINSORT
JR18061RETURNING VARCHAR INFORMATION FROM STORED PROCEDURE SHOWS GARBAGE DATA.
JR18071SCHEDULAR BECOMES DISABLED WHEN REMOVING TASK BEFORE IT SCHEDULED EXECUTION.
JR18074CREATING A STORED PROCEDURE WITHOUT PARAMETERS AND TRYING TO VIEW THROUGH CONTROL CENTER DOES NOT SHOW YOUR STORED PROCEDURE.
JR18078REBUILD/ALTER OF SQL STORED PROCEDURE FAILING IN DEVELOPMENT CENTER
JR18091-440 DURING IMPORT AGAINST CCSID 939 OS/390 DATABASE
JR18099SQL22212 ATTEMPTING TO COPY TABLE OR REMOTE DATABASE VIA CONTROLCENTER
JR18102ARRAY INPUT PROCESSING FOR LOB FAILS ON ASSERT
JR18133REMOVING A DB CATALOG IN V.8 ALSO REMOVES THE NODE ENTRY FOR THAT DATABASE EVEN IF OTHER DATABASES DEPEND ON IT.
JR18145DWC XT SERVER FAILED DUE TO MEMORY LEAKS IN DDD, LOGGER AND SERVER.
JR18183WRONG SQL GETS GENERATED WHILE ALTERING A DB PARTITION GROUP FROM ANOTHER ALREADY EXISTING PARTITION VIA CONTROL CENTER.
JR18185CREATE WRAPPER USING EXTERNAL LIBRARY GIVES ERROR SQL1034C
JR18210SQL0440N IN EXECUTING A SELECT ON A VIEW THAT HAD BEEN CREATED ON DB2 V7 DATABASE AND WAS RESTORED TO A DB2 V8 DATABASE.
JR18212LOAD API:ARRAY THEN NON-ARRY INSERT CAUSING HANG OR INSTANCE CRASH
JR18236MEMORY LEAK IN DB2BP ORIGINATING FROM SQLJRPARSESQLDARD
JR18247DWC WHEN AN AGENT IS SENDING AN ERROR TO THE DWC SERVER RC CODE NEED ONLY BE A WARNING
JR18248DWC -ACTIONS PROHIBITED BY DWC SECURITY FROM PROCESS WINDOWS ARE AVAILABLE AND OPERATIONAL FROM WIP.
JR18263CLI COMMAND SQLSETPOS HANGS.
JR18267CONTROL CENTER NOT REFRESHING PROPERLY
JR18269IMPORT CASTS A VARCHAR > 255 TO LONG VARCHAR. THIS GENERATES -97ERROR WHEN IMPORTING FROM UDB TO OS/390.
JR18272IN COMMAND CENTER, CHOOSE 'SCRIPT'->'IMPORT' AND GET SQL1403N.
JR18273DB CRASHES WITH SQL0902 B/C WRONG TEMP TBSPC IS USED BY THE OPTIMZER.
JR18274SHRED OF TIMESTAMP VALUE FAILS IF TRAILING MICRO SECONDS ARE MISSING. FAILING SQLCODE IS SQL0723N
JR18275XML EXTENDER ESCAPING ENTITY CHARACTERS WITHIN A CDATA SECTION.
JR18278DB2DART REPORTS 'WARNING: OBJECT IN OBJECT TABLE NOT FOUND IN SYSTABLES' WHEN SYSCATSPACE IS DMS.
JR18280INCORRECT RESULTS FROM A QUERY WITH INTERSECT WHEN SEARCHING FORNULL ARGUMENTS WITH CHECK CONSTRAINT DEFINED
JR18282GRANT ON GROUP >8 CHARS WILL GIVE SQL0107 HOWEVER PRIVILIGE WILLBE GIVEN IN SYSCAT.
JR18284NULL NOT HANDLED CORRECTLY IN AGGREGATE FUNCTIONS WITHIN OLAP (OVER/PARTITION BY) FUNCTION.
JR18285. EXPORT AND IMPORT NOT WKING PROPERLY THRU CCENTRE -CODEPAGE 943
JR18287USING THE NET DRIVER, REBIND NOT OCCURRING WHEN SCALES OF DECIMAL PARAMETER MARKER VALUES CHANGE.
JR18288SQLEXECUTE() FAILED WITH SQL0301 ERROR
JR18293DB MAY CRASH W/ SEGMENTATION VIOLATION WHILE TRYING TO EVALUATE A STAR-JOIN QUERY ON SQLNO_STARJN_CHECK_JGRAP()
JR18294SQLPGWLP PROBE:905 FIRSTLSN SET TO 0
JR18295UPDATE AND DELETE USING WHERE CURRENT OF <CURSORNAME> CANNOT HANDLE MORE THAN 1 'WHERE' IN THE SQL STATEMENT
JR18298PROBLEM WITH THE LENGTH OF DATA RETRIEVED FROM BLOB ON THE LOCALDATABASE (DATABASE ON THE GATEWAY, WORKS FINE)
JR18301DATA WAREHOUSE WHEN USING SQL ASSIST TO USE JOINS. THE JOIN COMES OUTT WRONG. WHEN JOINING MORE THEN 3 TABLES.
JR18302DWC- WHERE CLAUSE NOT CONVERTING WHEN MIGRATING FROM 5.2- 7.2 SQL INCLUDES THE WHERE CLAUSE ,CONDITION WINDOW DOES NOT
JR18303DWM V7 FP7 - NOTIFICATION DEFAULT MSG FOR E-MAILS IF STEP HAS NOSOURCE NOTIFICATION PROCESS FAILS
JR18304DWC-MONTHLY SCHEDULING- W/ CERTAIN START DATES , SUBSEQUENT RUNSARE SCHEDULED INCORRECTLY
JR18306DWC MIGRATION WILL DELETE THE RELATIONSHIP IF THE IWHID FOR THE MAP DOES NOT EXIST ANYMORE.
JR18311SPATIAL EXTENDER'S RANGE PRODUCER FUNCTION IS NOT WORKING PROPERLY WHICH RESULT IN SLOW PERFORMANCE
JR18314UNEXPECTED SQL0303N FROM CLI ON FETCH OF A TIMESTAMP THROUGH A GATEWAY TO AN OS/390 DATABASE WHEN PATCH1=131072 IN DB2CLI.INI
JR18319SELECT WITH LIKE CLAUSE ON LOB FIELD CAN CRASH SERVER
JR18321CREATE SQL PROCEDURE FAILS WITH SQLSTATE 42904 WHEN DB2INSTPROF IS SET (DB2ICRT WITH -P OPTION), DB2UDP.DLL CANNOT BE LOADED
JR18327POSSIBLE WINDOWS/V81 MEMLEAK THROUGH CONNECT/DISCONNECT
JR18328FAULT IN HOSTNAME-IP MAPPING MAY LEAD TO INCORRECT ADDRESS RESOLUTION WHEN AN ADAPTER HAS MULTIPLE ADDRESSES ASSOCIATED WITH IT.
JR18338SQL BUILDER ALWAYS PUTS TEH COLUMN AT THE BOTTOM
JR18339WINDOWS DRIVE MAPPING NOT FUNCTIONING (DB2DRVMP) IN MSCS ENVIRONMENT.
JR18352THE TRUNCATION WARNING IS CAUSING THE IF EXPRESSION NOT TO BE EVALUATE.
JR18353CONTROL CENTER REMOVES SECURITY SOCKS OPTION FROM THE CATALOG ENTRY FOR NODES THAT IT ACCESSES
JR18365CREATE NICKNAME ON INFORMIX FRAGMENTED TABLE RETURNS SQL1822N RC= -857 'ROWIDS DO NOT EXIST ON TABLE'
JR18378THE CUST IS GETTING MEMORY ACCESS VIOLATION WHEN USING DB2 UDB XML EXTENDER. SQL1131N SQLSTATE=38503
JR18379V8.1 INSTALL WIN 2000 DOES NOT VALIDATE PASSWORD FOR ALLOWABLE DB2 CHARACTERS.
LI70128SQL20154 ON INSERT THROUGH UNION ALL VIEW ON LINUX 64-BIT
LI70140CATALOG TOOLS DATABASE CREATION FAILS ON LINUX
LI70153INVOCATION OF SNAPSHOT AT SNAPSHOT VER 5 (SQLM_DBMON_VERSION5*) CAUSES ENGINE TRAP.
LI70159DB2START CHANGES SHMMAX SETTINGS ON LINUX - SLES WHEN INITIALLY SET TO EXACTLY 2GB.
LI70167SQLGETINFO() FOR SQL_DRIVER_VER AND SQL_DBMS_VER INCORRECT
LI70169CANNOT BIND PACKAGES WHEN CONNECTING FROM AS/400 CLIENT TO UNIX SERVER
LI70173MISSING COMPILATION OF GENCOL AND BEFORE TRIGGERS
LI70174BIND OPTIONS OWNER AND QUALIFIER ARE WRONGLY CODEPAGE CONVERTED BY DRDA AR
LI70182DBA1107 AN ERROR OCCURRED WHEN THE PERFORMANCE CONFIGURATION WIZARD TRIED TO GET SYSTEM INFORMATION FROM YOUR SERVER. LINUX.
LI70193CONNECTING TO A REMOTE DATABASE USING TCPIP RETURNS SQL30081 ERRNO=4 (EINTR)
PQ67887APPLY PROBLEMS WHEN THE TARGET STRUCTURE IS 7
PQ68470CAPTURE WILL NOT STAY UP: CMVS DEFECT # 257284.
PQ68517WHEN APPLY ENCOUNTERS AN ERROR, DURING THE SECOND CYCLE, IT CAMEDOWN BECAUSE IT CANNOT THE OPEN THE WORKFILE.
PQ68518HIGH CPU USAGE WHEN DELAY=0 SPECIFIED FOR Z/OS APPLY.
PQ68976DPROPR: ASNLOAD WAS CREATING THE TEMPORARY FILES IN THE HLQ OF THE JOB RUNNING APPLY
PQ70613SQLCODE -104 WITH APPLY
PQ70632MIGRATION WAS NOT HANDLING THE 'DECIMAL' SET TO COMMA CAUSING SQLCODE OF -170 AND -104 IN ASNMI68.
PQ70944SQL -803 INSERTING INTO CD TABLE
PQ71507DPROPR APPLY ABEND0C4 FOR UPDATE OPERATIONS DURING TRANSACTIONAL MODE PROCESSING WHEN TARGET_KEY_CHG=Y IS SPECIFIED
PQ71631DURING TRANSACTIONAL MODE PROCESSING, THE INTERMEDIATE COMMITS BY APPLY ARE NOT RECORDED.
PQ71885WHEN DPROPR APPLY STOPS IN THE MIDDLE OF CYCLE, THE CONTROL TABLES ARE NOT UPDATED
PQ72463DPROPR APPLY FAILED WITH ASN1021E IN A REPLICA SCENARIO AFTER ENCOUNTERING RI ERROR.
PQ72564APPLY DOES NOT RECOGNIZE DISABLE_REFRESH=Y AND TERMINATE THE SUBSCRIPTION WITH STATUS=-1
PQ73455WHEN STARTING CAPTURE, APPLY OR MONITOR UNDER CERTAIN CONDITIONSTHE REPLICATION PROGRAM WILL CORE AND GIVE A SIGSEGV ERROR.
APAR fixes included in MI00046 (Fixpak 1)
APARABSTRACT
GG04317APPLY ASNLOAD ENCOUNTERS A SEGMENTATION FAULT WHEN IT ATTEMPTS TO CLOSE A NON-EXISTANT FILE
GG04331APPLY RC LOWERCASE DATABASE NAMES IN CONTROL TABLES CAUSE APPLY DATABASE CONNECTIONS TO MULTIPLY
GG04341REPLICATION ADMIN APIS AND COMPONENT CC_REPLAPI FP1
IY37394DB2SETUP SCRIPT DELETES /VAR/TMP IF THE DIRECTORY IS EMPTY
IY37771POSSIBLE DATABASE CORRUPTION DURING CRASH OR ROLLFORWARD RECOVERY, WHERE RECOVERY INCLUDES AN IN-PLACE TABLE REORG
IY37845SQL_ATTR_PRESERVE_LOCALE IS NOT EFFECTIVE IN AN ODBC ENVIRONMENT
IY37876TRAP IN SQRA WHILE RUNNING GRANTS/REVOKES IN A STRESS ENVIRONMENT.
IY38897MEMORY LEAK: ALL NOT-WITH-RETURN CURSORS IN THE INVOCATION CONTROL BLOCK NEED TO BE CLOSED
IY38915ON SINGLE PARTITION SETUP, GLOBAL TEMP TABLES ARE NOT DETECTED BY LOAD. TRYING TO LOAD INTO THEM RESULTS IN SQL3304N.
IY38918-901 IN SQLNO_CRULE_JOIN
IY38942DB2 PANICS WHILE IN SQLBPURGEALLPAGESINLARGERANGE
IY38944THE CONFIG ADVISOR RECOMMENDS A WRONG VALUE FOR NUM_POOLAGENTS SO THAT DB2START MAY FAIL WITH SQL1220N
IY38949THE CONFIG ADVISOR ALWAYS CHANGES LOGSECOND PARAMETER VALUE TO 1
IY38970-901 IN SQLNO_PROP_IOA
IY38980INCORRECT CODEPAGES ARE USED FOR TAIWAN, HONGKONG, BULGARIAN AND POLISH LANGUAGES ON LINUX PLATFORM
IY38981SQL1224 ON COMPILING STORED PROCEDURES IN FEDERATED ENVIRONMENT
IY38985DB2 FOR SUN SOLARIS HANGS IN _LWP_SEMA_WAIT
IY38992SQL1032 DURING ADD NODE OPERATION.
IY38997TRAP IN SQLNO FUNCTION DUE TO CORRUPT HISTOGRAM STATISTICS.
IY38998EASE RESTRICTIONS ON LOAD_ERRS_ONLY/SETUP_AND_LOAD_ERRS
IY38999LOAD HUNG CAUSING OTHER CLIENTS HUNG
IY39003INCORRECT SQL057OW ON GRANTING PRIVILEGES TO SEQUENCES
IY39012SIG 11 SQLRLGETINDEXINFORECV,MAKE SURE (*PRPLYPP) IS NOT NULL
IY39026DJMIG: -901 WITH 'UNKNOWN TYPE'. LONG VARCHAR DATATYPE USING UDB ON DJ IS NOT MIGRATED TO THE LOB TYPES IN V8
IY39028CREATE DATABASE FAILS WITH SQL0902C REASON CODE='184' SQLSTATE=58005
IY39030INSTANCE CRASHES AND DB CORRUPTED ON SUN DURING ALTER BUFFERPOOL
IY39033LTRIM.RTRIM,UCASE,LCASE GIVE -440 POST DJ MIGRATION
IY39034-901 ON SQLRL_DGTT_RCV: BUFFER POOL ERROR
IY39110SQL1244 RETURNED AFTER ISSUING DB2STOP FORCE, DB2START, DB2 TERMINATE
IY39131INCONSISTENT LOAD SUMMARY WHEN LOAD WITH MULTI PARTITION NODES
IY39132EEE LOAD INTO A TABLE WITH IDENTITY COLUMN ALONG WITH A PARTITIONING KEY ON A DECIMAL COLUMN MAY RESULT IN INCORRECT ROW HASHING
IY39134ASYNC IO FOR LOAD
IY39210LOAD TERMINATE FAILED WITH SQL2038 AND DB2DIAG.LOG SHOWS SQLUREGISTERLOADEND -- LBA LSN MISMATCH
IY39211SETTING ATTR_SAVECOUNT ABORTS CLI LOAD
IY39214BPS API FUNCTIONS CAN HANG IF DB2CHKPTR IS ON
IY39217LOAD IN EEE FAILED WITH FILE_TRANS_CMD OPTION WHEN MULTIPLE SOURCES ARE SPECIFIED
IY39240SIGNAL 11 IN SQLAK_CALLBDRDAOUTPUTLOB WHEN RUNNING SPATIAL QUERY
IY39241INSERT STATEMENT RETURNS A -901 WITH VALUE IS TOO LARGE FOR THE BUFFER
IY39246UNEXPECTED SIGNAL 11 AT PC=0XFFFFFFFF7ED01A40 USING THE CONTROL CENTER TO RUN LIST APPLICATIONS ON A SUN SOLARIS 64 BIT INSTANCE
IY39247FUNCTION MAPPING OPTIONS ARE NOT MIGRATED.
IY39356INSTALL: ADD DB2DJXMSG TO INSTALL IMAGE
IY39357SQL0401 ON LONG VARGRAPHIC || VARCHAR RETURNS CLOB IN UNICODE DB
IY39363SETTING LC_ALL EQUAL TO KO ON SUN MAY CAUSE INSTALL PACKAG DUPLICATE
IY39368AFTER THE INSTANCE CREATION FAILED, URE STILL TRIES TO SETUP ORACLE_HOME AND IT CRASHES.
IY39369REWRITE CHANGES FOR UNION ALL, GROUP BY AND INLIST
IY39376RESTORE FAILS TO RESTORE A LOB OBJECT, RESULTING IN POTENTIAL ERRORS WHEN TRYING TO ACCESS THE OBJECT AFTER RESTORE COMPLETES.
IY39379PACKAGE LOCK (INTERNAL P LOCK) NOT RELEASED AFTER RECEIVING SQL0719 DURING BIND
IY39414-901 ON SELECT WITH UDPS AND SQL UDF
IY39422FIX HEALTH CENTER ALERT FOR TABLESPACE CONTAINER UTILIZATION
IY39426SNAPSHOT STORED PROCEDURE CREATES INSTANCE /TMP DIRECTORY WHICH HAVE IMPROPER PERMISSIONS
IY39427COMPILING A JAVA STORED PROCEDURE WITHIN WSAD LINUX CAUSES A JAVA CORE DUMP
IY39428EXCEPTION ON VIEW SOURCE OF REXX, C, ASSEMBLY
IY39440UDF WIZARD NAVIGATION PROBLEMS.
IY39441EXITING FROM DEVELOPMENT CENTER AFTER EXISTING DC IS ALREADY UP, WILL CAUSE ALL THE DC TO BE GONE.
IY39451SQL0901 DURING UPD/DEL WITH REFETCH AND SUBQUERY TO JOIN APPLIEDTO INPUT OF UPD/DEL
IY39481VISUAL EXPLAIN IN WINDOWS RETURNS DBA3037 EXPLAIN SNAPSHOT CORRUPTED
IY39484EXPLAIN IS MISSING THE RELATIONSHIP BETWEEN THE CSE AND ALL BUT THE FIRST CONSUMERS OF THE CSE
IY39487AST FULL REFRESH CAN MISS/DUP ROWS IF UNDERLYING TBL HAS CHANGE THAT MAKES ROW MOVE BTWN PARTITIONS, BLOCKS OR WITHIN INDEX.
IY39491ALLOW DB2ICLUS /DROP TO PROCEED IF DAS DOESN'T EXIST
IY39513IF QUERY HAS A DISTINCT AND OUTER JOINS, THE DISTINCT MAY NOT BEENFORCED AFTER OUTER JOIN REORDERING - MAY GET WRONG RESULTS.
IY39522DB2EXFMT CRASHES DURING PREPARE OF EXPLAIN PLAN
IY39526SQL0973 -OUT OF MEMORY ERROR AFTER EXECUTING A LARGE NUMBER OF EXPLAIN STATEMENTS.
IY39532T3ADO CLIENTS WITH MICROSOFT OLEDB PROVIDER USING SCROLLABLE CURSORS COULD PANIC INSTANCE
IY39537SQL0302 FOR QUERY WITH INLIST OF MORE THAN 1 ELEMENT, ELEMENTS ARE PARAMETER MARKERS.
IY39540SQL0222 WHEN ROW IS UPDATED OR DELETED FROM SCROLLABLE CURSOR AND ANY BASE TABLE COLUMN IN THE CURSOR IS NULL. SQLSETPOS()
IY39638LOAD WITH STATISTICS YES PRODUCES INCORROUT STATS FOR MDC TABLE
IY39641MDC:SQLIMARKKEY PROBE:1323, CALLER ADDKEYTOLEAF, PROCLEAF2ADD
IY39642ASSERTION FAILED FROM SQLUDIRIO.C LINE:286
IY39646IN LOAD GENERATED COLUMN SUPPORT, IN FUNCTION SQLRICLS(), WE AREGOING TO SQLRICLS_SIMPLE() CODEPATH WHICH IT SHOULD NOT.
IY39647FIX DAS MULTIPLE RELEASE SUPPORT
IY39652LOAD TERMINATE RETURNED SQL1007(SQLBDMSCHECKOBJALLOC PROBE:825)
IY39659SQLBRDPG() PROBE:1110: BLK MAP HAS INCORRECT NUMBER OF ENTRIES
IY39660TRAP IN SQLUWRITERIDFILE WHILE DOING LOAD
IY39661INSTANCE CRASH DURING LOAD DELETE PHASE
IY39663-902 ON MPP LOAD WHEN IDENTITY VALUES EXHAUSTED
IY39666IN MULTIPARTION ENVIRONMENT, SQLUREGISTERLOADEND PROBE:259 -LBA LSN MISMATCH
IY39668DB2ADMIN STOP RETURNS BEFORE DAS IS STOPPED
IY39670DISCOVERY FAILED WHEN FP1 INST ENTRY ALONG WITH GA INST
IY39719INSTANCE PANIC DUE TO TRAP IN SQLOFMBLKEX
IY39720INSTANCE CRASH WITH SIGNAL 11 IN SQLRA_RPC_APM_SHIP()
IY39784CLI APPLICATION TRAPS WHEN ABNORMALLY TERMINATED. GOING AGAINST OS/390. TRAP IN SQLJRHANDLEERRORRM PROBE: 911
IY39785STREAMING OF >32K JAPANESE LOB DATA DOES NOT NECESSARILY WORK
IY39790FAIL TO READ GRAPHIC(VARGRAPHIC,LONG VARGRAPHIC) COLUMN USING APPROACH 2000.
IY39793NICKNAMES ARE NOT SHOWING UP CORRECTLY IN ALL CASES FROM WSAD V5.
IY39796CLI0117E-INVALID CURSOR STATE. SQLSETCURSORNAME( ) DOES NOT APPEAR TO BE WORKIGN IN STATIC CAPTURE MODE.
IY39800ADD SUPPORT TO SCHEMA FUNCTIONS FOR PATCH2=7 AND GRAPHIC KEYWORDS.
IY39806CLI TRACE DOES NOT GIVE COLUMN NAME WHEN SQLSTATE=01517
IY39807-804 WHEN PROCESSING CURSOR AFTER POSITIONED UPDATE/DELETE
IY39809ARRAYINPUT REQUEST MUST HAVE INPUT DESCRIPTOR.
IY39810CLI HANGS ON END CHAIN: V81 CLIENT/V72 SERVER
IY39811EXECUTING SQLJ PROGRAM WITH GRAPHIC DATATYPE AGAINST DB2 UDB FOR OS/390 CAUSES SQL0516N.
IY39869COBOL APPLICATION NOT HANDLING LARGE NUMBER OF HOST VARIABLES.
IY39870CREATE NICKNAME IS NOT PICKING UP THE STATISTICS FOR A DRDA HOSTTABLE.
IY39871TRAP WHEN CLI TRACING IS ON IN CLI_GETMEMTHREADINFO( ) RESULTS IN FAILURE IN SQLOGMBLK.
IY39872SEGV WITH XA ON SQLCLOSECURSOR WITH REMOTE DATABASE.
IY39873INDEX MANAGER PROGRAMMING ERROR FFFFF954 DURING RUNTIME WITH SQLIREMVIOL PROBE:1/PROBE:2
IY39875SQL QUERY GETS SQL0901N RC 0 IN SQLNO_SMP_CREATE_SHARED_SO() PROBE 200 WHEN INTRAPARALLEL IS ON.
IY39884ALTER TABLE VOLATILE CARDINALITY DOES NOT INVALIDATE THE PACKAGECACHE FOR DYNAMIC SQL CREATING BAD ACCESS PATH AND PERFORMANCE
IY39885SQL4304 CLASS NOT FOUND AFTER LOADING JAVA UDFS > 4500 TIMES
IY39888DATABASE BACKUP RETURNS SQL1042C AND THE INSTANCE CRASHES WITH SIGNAL 11 IN SQLODSHR()
IY39889POTENTIAL DEFUNCT DB2GOV CHILD PROCESSES
IY39891INSTANCE CRASH WITH SIGNAL 11 IN SQM_EVMON
IY39895RELATIONAL SCAN IS USED WHEN INDEXES SHOULD BE IN A JOIN/CORREL ATION QUERY
IY39908THE OPTIMIZER MIGHT NOT CHOOSE THE INDICES OR AN OPTIMAL JOIN ORDER FOR A JOIN INVOLVED IN A COMPLEX OR PREDICATE.
IY39912IMPLEMENT PUSHDONW OF REGULAR JOIN THROUGH OJ IF IT IS NEAR UNIQUE. AS WELL PUSH DOWN IF THERE IS MULTIPLE OJS.
IY39922CRASH WHEN LOADING INTO TABLE WITH GENERATED COLUMN(S) USING GENERATEDMISSING MODIFIER.
IY39923DURING INDEX RECREATION, BPS ERROR OF FIXING A DIRTY PAGE SQLB_NEWX.
IY39941UNRETRIEVED ERROR MESSAGE='SQLSTATE 01503: THE NUMBER OF RESULT COLUMNS IS LARGER THAN THE NUMBER OF HOST VARIABLES PROVIDED.'
IY39953DB2ADVIS SETS INVALID TIME FOR STATS_TIME FOR NEW INDEX
IY39956DB2 PANICS IN ~SQM_EVMON_IOT(), CALLED BY SHUTDOWN_EVMON, WHEN AN EVENT MONITOR ENCOUNTERS AN ERROR.
IY40015COMPLEX SUBQUERY ELEMENT NOT BEING PUSHED DOWN THROUGH UNION ALL. THIS INCLUDES FUNCTIONS, COMPLEX QGM ELEMENTS
IY40041DB2COUNTRY IGNORES DECIMAL SEPARATOR CHANGE
IY40066COSTING CHANGE TO MSJN. INCLUSION OF ADDITIONAL DETAILS IN REGARDS TO EFFHIGH2KEY.
IY40104WHEN A COLUMN IS IN THE SELECT STATEMENT MORE THEN ONCE, AND THEN THE SAME COLUMN IS IN THE ORDER BY, DB2 WILL FAIL SQL0901
IY40107AUTOMATIC INCREMENTAL RESTORE FAILS WITH SQL2571 RC=3 WHEN TABLESPACE NAME IS OF MAX LENGTH
IY40113CRASH RECOVERY FAILED WITH BUFFER POOL LOGIC ERROR SQLBREDOUPDATEEMP ON EMP OF LOB OBJECT
IY40147DB2 CRASH WHEN IMPORTING LARGE NUMBER OF XML RECORDS INTO A DATABASE WHICH IS XML ENABLED.
IY40150DURING ROLLFORWARD ON AN INDEX THAT IS DMS AND PARTIAL, WE COULD NON-EXISTENT PAGE 0 AND CAUSING THE ROLLFORWARD TO FAIL.
IY40216DB2STOP HANGS OR TIMES OUT SQL6037N WHEN HEALTH MONITOR OR HEALTH CENTER IS ACTIVATED.
IY49782DB2 HANGS IN THE EVENT MONITOR TERMINATION CODE PATH
JR17478SQL FUNCTION UTILIZING CURRENT SCHEMA TO QUALIFY A TABLE REF. FAILS WITH -204 SHOWING A CORRUPTED NAME FOR THE QUALIFIER.
JR17736PATCH1=1024 IS NOT WORKING IN V8
JR17737AFTER MIGRATION TO V8.1, REBINDING OF PACKAGES FAIL WITH SQL 510IF THE STMT HAS AN UPDATE/DELETE WHERE CURRENT OF CURSOR
JR17802INSTANCE TRAP: SQL0901C, UNEXPECTED AUTHINFO FREE LIST COUNT WHILE DECREMENTING
JR17805PANIC/SLEEP IN SQLDINVCURSORPOS AND IN SQLDENDTRANSACTION. THIS CAN HAPPEN IN A MULTI-PARTITION SETUP.
JR17808THE CONFIG ADVISOR SETS SORTHEAP PARAMETER TOO HIGH, WHEN 'APPLYDB ONLY' IS SELECTED.
JR17809GATEWAY HUNG WHEN DB2STOP FORCE
JR17811THE KILLDB2 UTILITY MAY COLLIDE WITH DB2START ON WINDOWS
JR17812SQL1025 ON DB2STOP FORCE
JR17813DB2 PANICS IN SQLEFSEM2 ON WINDOWS
JR17816ALLOCATION OF INDEX INFO IN SQLRLGETINDEXINFO DOES NOT ACCOUNT FOR ALIGNMENT AND CORRUPTS MEMORY
JR17817DB2MSCS ON WINDOWS 64-BIT EEE CLUSTER FAILS TO CREATE FILE SHARE
JR17827CCA3051N ERROR USING THE CONFIGURATION ASSISTANT TO CONFIGURE THE CS/NT STACK.
JR17829LIST SESSION WINDOW DOES NOT SHOW TARGET SUBSYSTEM NAME
JR17830SQL0204N WHEN TRYING TO DROP A USER DEFINED DISTINCT TYPE WITH MIXED CASE SCHEMA USING THE CONTROL CENTER.
JR17831SQL0355N ERROR USING THE CONTROL CENTER WIZARD TO CREATE A TABLEWITH AN XMLCLOB COLUMN.
JR17832THE TASK CENTER LOAD WIZARD GENERATES AN INVALID LOAD COMMAND FAILING WITH AN SQL0104N ERROR FOR A PARTITIONED DATABASE.
JR17834THE CONTROL CENTER GENERATES AN INVALID KEYWORD, DEFAULTS NULL, WHEN CREATING AN INSTEAD OF TRIGGER.
JR17836JAVA DOC FILE FOR VIDEO CENTRAL IS NOT INSTALLED
JR17840INTERFACES FILE REPLACED WITH EMPTY FILE AFTER MIGRATION
JR17843SQL0901 REGARDING PLAN/ENVIRONMENT MISMATCH WHEN TURNING INTRA_PARALLEL FROM YES TO NO
JR17874INSTANCE TRAP AT SQLCC_GENERATE_SYNCLOG WHEN SP FETCHES LOB DATA
JR17875LOAD CRASHES INSTANCE ON WINDOWS WHEN TABLE CONTAINS IDENTITY COL IN FIRST POSITION AND INTO OPTION NOT USED
JR17878WHEN THE PARSER FINDS THE TWO DECIMALS, IT INSERTS A CAST FUNCIT. THIS CAUSES A SEGMENTATION FAULT.
JR17881IN THE TOOLS SETTINGS FOR COMMAND CENTER IF YOU CHECK TERMINATIOCHARACTER SETTING W/ THE BOX BLANK TOOLS SETTINGS WON'T WORK.
JR17882UNABLE TO ADD NOTIFICATION TO A STEP WITH A LONG NAME
JR17883DWC: EXPORT UTILITY EXPORTS MORE METADATA THAN IT SHOULD.
JR17887FOR QUERIES ON LOCAL VIEWS THAT CONTAIN NICKNAMES, FUNCTIONS CONTAINED IN A SELECT ON THE VIEW WILL NOT BE PUSHED DOWN
JR17888DISTINCT NOT PUSHED DOWN WHEN USING A NICKNAME
JR17890DURING LOAD MODIFIED BY CODEPAGE IBM-930, CHARACTER X4040 NOT STRIPPED OUT BY STRIPTBLANKS MODIFIER
JR17891TRIGGER COMPILATION RESULTS IN SQL0101N DUE TO INFINITE LOOP
JR17895MEMORY LEAK IN DATABASE MONITOR HEAP WHEN HANDLING SQLESETI. ERROR 0XFFFFD621 MAY BE REPORTED IN SQLE_ADD_SETINFO_FIELD
LI70138ENABLING CLI TO HANDLE NULL TERMINATING CHARACTERS TO ENABLE SET PATCH2=52 PRIOR TO FP7, OR PATCH2=53 AFTER FP7
LI70139TRAP WHILE COMPILING A QUERY. SEGV IN SQLNR_REORDER_IJ_QGM()
PQ45854INSUFFICIENT MESSAGES TO DEBUG BUILD ERRORS FOR STORED PROCEDURE BUILDER. - DSNTPSMP
PQ68979DPROPR APPLY -752 - APPLY CNTROL SERVER IS PRE V8
SE08163OSP R510 EXTENDERS XML_EXTENDER INCORROUT