Product Name:DB2 UDB V7 for Linux
PTF Number:U495953
Package Date:Mon Dec 15 15:26:55 EST 2003
Build Level:s031208
APAR fixes included in U495953 (Fixpak 11)
APARABSTRACT
GG04388IF THE DPROPR CAPTURE AND APPLY ARE STARTED FROM A WIN TERMINAL SERVICES (REMOTE) CLIEN SESSION THEY CAN'T BE STOPPED.
IC36896MEMORY LEAK ISSUE WHEN USING THE LOCATE
IC37743REGRESSION IN QUERY REWRITE/PUSHDOWN CODE AFTER APPLYING FP9 ON A UDB PF7 SYSTEM
IC37744INNER JOIN IS PUSHED DOWN BUT SHOULD NOT BE SINCE IT DEGRADES PERFORMANCE
IY29165PREVENT A LOCAL COMMIT ON A SUB-ORDINATOR NODE NODE LOG RECORDS HAVE BEEN WRITTEN.
IY30708WRONG RESULT FROM SELECT VIEW BASED ON CREATE A UNION ALL VIEW OVER THE LOCAL TABLE AND REMOTE NICKNAME ON REMOTE TABLE.
IY31775SQLPGRML() DOES NOT CLOSE SQLOFIND H
IY34153MEMORY CORRUPTION CAUSES INSTANCE CRASH WHEN RUNNING QUERY AGAINST MS SQL NICKNAME
IY35005TRAP IN SQLMSENDMONITORREQUEST
IY37315OUTER JOIN QUERY WITH UPPER() SHOULD USE INDEX ON GENERATED COL
IY39251SLOW PERFORMACE
IY40179SQL0723N WITH SQLCODE -950 DELETING FROM A TABLE WHOSE DELETE TRIGGER DELETES FROM A TABLE WITH RI CONSTRAINT TO ITSELF
IY40260COMPLEX TEXT EXTENDER QUERIES MAY FAIL BECAUSE COLUMNS MAY NOT BE RETRIEVED WHEN EXPECTED.
IY40777VALUES TABLE RETURNS INCORRECT VALUE AFTER FIXPAK 3. INCORRECT OUTPUT WHEN THE LAST ROW OF THE VALUES BOX IS REQUIRED.
IY41171DATABASE MARKED BAD AFTER LINK FAILURE
IY42098ERROR MESSAGE DXXQ045E IS GENERATED WHEN ATTRIBUTES HAVE THE SAME NAME.
IY43109DB2 GOVERNOR CORES IN FUNCTION SCHEDULE
IY44303ERROR ON UNFIXING A PAGE (FUNCTION SQLBUFIX ) FROM THE BUFFERPOOL CAUSING THE DB TO PANIC AND INSTANCE SHUTS DOWN.
IY44527FIXES TO POTENTIAL CRASHES IN THE XA ENVIRONMENT
IY44598UNABLE TO NICKAME SQLSERVER 2000 TABLE WITH BIGINT DATATYPE
IY44632SET EFFECTIVE COLUMN CARDINALITY EVEN IN THE ABSENCE OF STATISTICS.
IY44636IMPORVE THE STAR JOIN PROCESSING UNDER REDUCED OPTIMIZATION CONDITIONS
IY44841SECURITY PROBLEM:DMS DIRECTORY IS CREATED WITH PERMISSION 777
IY44941SQM_EVMON_MGR HOLDING THE EM_LIST_LATCH CAUSES DB2 TO HANG
IY44997DB2 DOES NOT DETECT THAT THE LSN IS REACHING 0XFFFFFFFFFFFF AND IS READY TO WRAP AROUND TO 0X0
IY45019SQL0464W MESSAGES ARE NOT PROPERLY CLEARED AND THIS MIGHT CONSUME MEMORY WHERE MEMORY GROWTH IS OBSERVED
IY45081SQL1042 WHEN ISSUING DB2STOP IF NIS IS ENABLED. PROBLEM ONLY HAPPENS ON V7.2 INSTANCES BUT NOT ON V8 INSTANCES
IY45097SQL1024N WHEN PERFORMING A BIND WITH CONNECTIONPOOLING=1 SET
IY45098CTREADONLY NOT RESENT WITH CONNECTION POOLING ON - DRDA.
IY45116SQL30082 REASON CODE 15 WHEN USING DECRYPT_CHAR() WITH A PASSWORD SET WITH SET ENCRYPTION PASSWORD IN SMP ENVIRONMENT.
IY45168'UNABLE TO FREE TEMPARY SQLCACHE STMT' MESSAGE SHOWS UP IN DB2DIAG.LOG EVEN WHEN THE RETURN CODE IS 0. (IE: NORMAL)
IY45264SQL1072 ON DB2START AFTER CREATING NEW INSTANCE. WE WILL BACKFITV8 ALGORITHM OF IPC KEY GENERATION TO AVOID THIS PROBLEM.
IY45270SQL0101N WHEN TRYING TO EXECUTE REVOKE FROM USER WHEN DOING SOME POST PROCESSING FOR DEPENENT VIEWS AND SUMMARY TABLES.
IY45507AUTOLOADER CAN CORRUPT THE DATA BY HASHING RECORDS TO THE WRONG PARTITION.
IY45515SQL1084:CONNECTIONS MAY FAIL IN EEE MLN TRYING TO REUSE A FORMER'HOP' AGENT WHICH HAS NOT CLEANED UP AFTER A BROKEN CONNECTION.
IY45529ON AIX, APP IS GETTING CLI0602E. ON WINDOWS, APP IS GETTING CLI0120E.
IY45585DB2 OLAP SERVER ANALYZER GOT CLI0602E ERROR.
IY45635DURING TABLESPACE ROLLFORWARD TO POINT IN TIME, THE SQLB_REORG_IN_PROGRESS STATE CAN BE TURNED OFF INADVERTENTLY.
IY45643SQL0954C (NOT ENOUGH STORAGE) IN THE APPLICATION HEAP - MEMORY LEAK IN SQLRA_FP_ALLOC AND SQLRA_SAVE_REG
IY45645SQL2154 ERROR DURING TABLESPACE RESTORE
IY45781POOR PERFORMANC ON QUERY WITH CSES ON A COMMON VIEW.
IY45802EXPORT FROM A MAINFRAME WITH AN '*' INSTEAD OF COLUMN NAMES FOR THE 'SELECT' STATEMENT PUTS -805 MISSING SQLUAD09 IN DB2DIAG.LOG
IY45825-900 AT CALLING A STORE POOCEDURE, IF KEPPDARI=YES. WHEN IT HAPPENS THE CREATE PROCEDURE FAILS WITH -4998 TOO
IY46025HANG: MQBACK FUNCTION HANGS ON SQLXA_ROLLBACK. WHEN AGENT IS TERMINATING CLEAN UP XATXENTRY.
IY46029PROBLEM WITH AN UNINITIALZED INPUT PARM TO THE TCP/IP KERNEL CALL THAT CHECKS FOR THE STATUS OF THE CLIENT CONNECTION.
IY46043SQL0206N WITH USER DEFINED DATA TYPES WHEN USING REPLICA TYPE TARGET
IY46124XA APP GETS SQL0998 RC=9 WHEN RECONNECTING TO DB2 AFTER A FAIL STATE 'AFTER A COMMUNICATION FAILURE'.
IY46163SYSTEM CALL MSGSND() INTERRUPTED IN SQLOCSEMV() CAUSES DATABASE MARKED AS BAD
IY46170SQLLEN RETURNS INCORRECTLY 2 FOR DATALENGTH OF 4. AS A RESULT DATA RETURNS AS '0' BY SQLGETDATAINTERNAL.
IY46174ARRAYINDEXOUTOFBOUNDSEXCEPTION USING JDBC NET DRIVER.
IY46208QUERY PERFORMANCE PROBLEM DUE TO QRW RESTRICTIONS WHEN UNION ALLIN VIEW TABLES ARE INVOLVED.
IY46295INCORRECT RESULTS WHEN ONE ARM OF A UNION ALL CONTAINS A NOT EXIST CLAUSE.
IY46323SQL0973 OUT OF DBHEAP, PACKAGE CACHE ERRORS, SQL2009 OUT OF UTILITY HEAP DUE TO MEMORY LEAK WITH MONITORING OF TEMP TABLES
IY46340DISABLE SIGBUS HANDLING ON HP
IY46374CURRENTSCHEMA AGAINST AS/400 NOT WORKING
IY46442DB2 V8 CLIENT ON WINDOWS CANNOT CONNECT TO V7 FP9 SERVER ON AIX, FOR EEE SYSTEM (BUT PROBABLY NOT EEE RELATED).
IY46446WHEN USING EXPORT/IMPORT AND REDEFINING A COLUMN FROM VARCHAR TO CLOB THE IMPORT FAILS AFTER FP 9 IS APPLIED
IY46497JDBC INCORRECTLY RETURNS +100 FROM SQLPARAMDATA
IY46499MEMORY LEAK IN RESULTSET.GETBLOB()
IY46523ALLOW EXTRACT OF TABLES WITH GRAPHIC COLUMNS IN UNICODE DATABASES USING DB2LOOK.
IY46539IMPORT CREATE FOR A UNICODE TABLE WITH GRAPHIC COLUMN FAILS WITHSQL3319
IY46576ABEND WHEN SELECTING WITH ORDER BY FROM 32K TABLESPACE
IY46660SQL30082 RC 24 WHEN CONNECTING FROM DB2 VERSION 8 TO DB2 VERSIO N 7 WITH SPECIFIC TRUSTED CLIENT AUTHENTICATION SETTINGS
IY46706SQL0104N WHEN IMPORTING DATA THAT WAS EXPORTED FROM DB2/OS390. COLUMN IS DATE TYPE AND HAS DEFAULT VALUE.
IY46786SIGNAL #11 DB2 TRAPPED IN SQLPGETNUMAPPLLOCKS CALLED BY SQM
IY46803DB2 SQLJ TO OS/390 TRAP OR SQL0516 OR SQL0303 ACCESSING BLOBS
IY46855CODEPAGE CONVERSION FILE IBM01141.UCS IS MISSING IN FP10 DB2 UDB
IY46941QUERY RETURNS INCORRECT RESULT DUE TO REDUNDANT REMOVAL OF PREDICATES WHEN IXAND IS USED.
IY47037OBJECT TABLE EXTENSION PROBLEM
IY47043ADD REPAIR FUNCTIONALITY TO ZAP PAGE COUNT FIELD OF OBJECT TABL
IY47196INCORRECT RESULTS WHEN USING FLOOR FUNCTION.
IY47213DB2 VALUES 1.0000*(0.0445/0.65) RETURNS WRONG RESULTS.
IY47229DB2 HANGS IN SQLNR_SORT_SIPS_ORDER RUNNING A BIND OR SQL COMMAND.
IY47268DB2LOOK GENERATES WRONG OUTPUT WITH -Z OPTION, WHEN IT'S RUN AGAINST DB2 ON OS/390
IY47295DYNEXPLAIN CAUSES TRAPS
IY47393FUNCTION OVERRUNS END OF BUFFER RETURNING TOO MANY BYTES AND FAILS IN MEMSET() CAUSING A DATABASE CRASH.
IY47437APP CORES ON CLICPOOL.C ON DISCONNECT DUE TO MULTITHREADING TIMING HOLE
IY47473WHEN DOING A VENDOR LOAD COPY NO, WE DO NOT FILL IN THE TIMESTAMP IN HISTORY FILE ENTRY IN LOAD WHICH CAUSE TO LOOSE THAT ENTRY
IY47484INCORRECT CONVERSION OF 'I' & 'Y' WHEN USING LOWER() FUNCTION IN A DATABASE WITH TURKISCH CODEPAGE 920
IY47497FOLLOWING A CRASH DURING LOG TRUNCATION, WE CAN CRASH AGAIN WITH THE ERROR 'LOG PAGE INCORRECTLY MARKED FOR TRUNCATION'
IY47520ERROR IN TRUNCATING LOG DURING NORMAL DATABASE SHUTDOWN RESULTS IN PARTIALLY TRUNCATED LOG FILE.
IY47562FIX FOR 32-BIT APAR IY40106 IN 64-BIT CODE
IY47636CREATE INDEX ATTEMPT AFTER FIRST CREATE INDEX ATTEMPT FAILS DUE TO LOG FULL CONDITION MAY CRASH DATABASE.
IY47664INSTANCE CRASH DURING CREATE DB WITH EXPLICITELY GIVEN TABLESPACES ON SPECIFC HP ARCHITECTURE
IY47673SQL4302N WITH CLI0115 ON THE SP CALL WITH FEW SELECT STATEMENTS (FP10 SPECIFIC).
IY47674DB2IMIGR COMMAND FAILS. 'DBI1222W THE SYSTEM DATABASE DIR IS CORRUPTED AND CANNOT BE MIGRATED.' DB2IMDBD EXIT CODE 3
IY47678SIGSEGV REPORTED IN SCROLLGETAROW2
IY47731MIGRATE DATABASE TRAPS IN SQLNQ_FINDFN
IY47787SEGV IN SQLODSHR AFTER FORCE OF STORED PROCEDURE
IY47899QUERY PATROLLER USES UPPERCASE USERNAMES BUT DB2 USES LOWERCASE
IY47919SQL1822N WITH ORA-12705 ERROR WHEN USING DB2 RC TO ACCESS ORACLESOURCE TABLE WITH CHINESE CHARACTERS VIA NICKNAME
IY47936SQL1131 WHEN CALLING SP FROM HOST COBOL APP MULTIPLE TIMES
IY47947EXPORT TO PIPE FAILS WITH SQL3001N RC = -2538, IF THE READ SIDE OF THE PIPE IS AUTOLOADER (DB2ATLD)
IY47976DB2 INSTANCE CRASH WHEN ADDING OBJS IN W2K PERF MONITOR W/ FP9
IY48209SQL1224 FROM RUNNING A UNION QUERY WITH MANY INLIST ITEMS
IY48336EXPORT FAILS WITH SQL0986 ON TABLES WITH DECIMAL COLUMNS AND CODEPAGE SPECIFIED.
IY48363SQL0304 WHEN TRYING TO USE THE 'CREATE NICKNAME' COMMAND
IY48458INSTANCE CRASH IN OPTIMIZER FUNCTION SQLNO_FIX_DEPEND_QUN FOR CERTAIN QUERIES INVOLVING HIERARCHY TABLES
IY48464INCORRECT RESULTS PRODUCED WHEN USING LIKE AND A WILDCARD, WHEN AN INDEX IS PRESENT.
IY48467NUMBERFORMATEXCEPTION IN DB2CALLABLESTATEMENT.GETBIGDECIMAL WHEN DEFAULT LOCALE'S DECIMAL SEPARATOR DIFFERS FROM '.'
IY48515THE COMPLILATION OF A QUERY THAT INVOLVES BOTH A SUMMARY TABLE AND A NICKNAME WILL CAUSE AN INSTANCE CRASH.
IY48547DB2AGENT HITS SEGV IN SQLO_LATCH_ATTEMPT_SEIZE ON NON-COORDINATE NODES (UPPER CALLER IS SQLELATCHAPPLIST).
IY48571INCORRECT RESULTS RETURNED WHEN USING 'WITH' CSE WITH REPLICATED SUMMARY TABLE REFERENCED...
IY48572INSTANCE CRASH, TRAP IN SQLCSPP_PREPARE, AFTER ORACLE INSTANCE CRASHES
IY48656IN DISK FULL SITUATION, ENGINE MISTAKENLY CREATES A NEW PAGE FORAN OBJECT, WHEN THERE IS NO SPACE.
IY48731DB2 CRASHED WHEN ACCESSING AR_FUNC
IY48734QUERY RETURNS BEFORE FINISHING AND CAUSES CLIENT TO BE DISCONNECTED WITH ONE TRAP FILE AND NO DB2DIAG.LOG MESSAGES.
IY48943DB2 BACKUP WILL GROW DISPROPORTIONATELY IN SIZE IF TABLES ARE CREATED 'UNDER' ANOTHER TABLE ( HIERARCHY ).
IY48957REBALANCING PROCESS HANG. THE REBALANCING AND SNAPSHOT OPERATIONS WAIT EACH OTHER FOR INTERNAL LATCHES
IY48970SQL STORE PROC COMPILE CRASHES INSTANCE IN FUNCTION SQLNQ_EXP::CORRELATION_TOQNC
IY48972BLOB DATATYPE LENGTH BEING DESCRIBED INCORRECTLY
IY48987INSTANCE ABENDS WITH SIGNAL 11 (0XB) ON QUERY WITH NESTED SUBSELECTS
IY49079UPDATE IS NOT UPDATING THE RIGHT NUMBER OF ROWS WHERE IT'S USINGA SELF REFERENCING SUBQUERY IN A PARTITIONED ENVIORNMENT..
IY49166WHEN HASH JOIN IS ENABLED, COLUMNS CONTAINING TRAILING SPACES MAY NOT COMPARE CORRECTLY.
IY49294PRIMARY KEY IS NOT CREATED IN THE IXF EXPORT FILE WHEN USING THE TABLE ALIAS.
IY49297PREDICATE IN SUBQUERY MARKED AS REDUNDANT AND CAUSES INCORRECT IO
IY49298TO INCLUDE ADDITIONAL OPTION FOR DB2ADVIS COMMAND. PREVENTING PASSWORD TO BE SHOWN WHEN '-A <USERID>/' IS USED.
IY49299SIG#11, TRAPPED IN SQLULOADPARTITION
IY49325DB2LOOK FAILS TO DOUBLE SINGLE QUOTES FOR COLUMN COMMENTS
IY49339DB2AUDIT EXTRACT COMMAND CREATES SEGMENTATION FAULT WITH CORE DUMP IN SOLARIS OPERATING SYSTEM
IY49359RESTORE REPLACE EXISTING MAY LEAD TO DIFFERENT COLLATING SEQUENCE ON EEE NODES IF ADDING A NEW NODE AFTER THE RESTORE.
IY49365BAD PERFORMANCE BECAUSE OF LOST PREDICATE IN QUERY PLAN.
IY49370DB2 ROLLFORWARD DB LOG BY LOG CAN RETURN SQL1265N: LOG EXTENT NOT IN CHAIN, BUT WHEN YOU LOOK AT THE LOG HEADERS, THEY ARE.
IY49437INFINITE LOOP OF SQM.SQLMONSSAGNT PROBE:1234 IN DB2DIAG.LOG AND HANG WHILE GETTING SNAPSHOT ON WRITE SUSPENDED DB.
IY49456TRAP DURING CHANGE PASSWORD
IY49489INDEX NOT USED FOR QUERY WITH OUTER JOIN AND UPPER(COLUMN).
IY49573AFTER WRITE SUSPEND AND WRITE RESUME, PROBLEMS WITH HACMP
IY49578SQL FUNCTION UTILIZING CURRENT SCHEMA TO QUALIFY A TABLE REF. FAILS WITH -204 SHOWING A CORRUPTED NAME FOR THE QUALIFIER.
IY49680SQL0525N ON GETCOLUMNS() AGAINST OS/390 DB WHEN _ OR % ARE USED
IY49736SQL30081N (*,*,0) AFTER ISSUING SQL STATEMENT.
IY49779DB2 HANGS IN EVENT MONITOR TERMINATION CODE PATH
IY49850ONLINE DATABASE BACKUP FAILS WITH SQL0902C
IY49884CLI0125E ON SQLEXECUTE() FOLLOWED BY SQLPARAMDATA()
IY49981USE OF KEYSET CURSOR RESULT IN SQLCODE -243/-228 AGAINST V8 HOST
IY49986SQLCA STRUCTURE NOT FILLED WHEN FAILING TO ALLOCATE MEMORY FOR A BLOCKING CURSOR.
IY49991EXECUTEBATCH () WITH CLOBS RETURNS CLI0109E - STRING DATA RIGHT TRUNCATION
IY50045USE OF RSH WHEN PERFORMING FAILOVER AND ORIGINAL HOST IS DOWN
IY50088CANNOT CONNECT THROUGH LDAP TO THE HOST DATABASE IF DB IS CATALOGED WITH LESS THAN 8 CHARACTERS IN DBALIAS - SQL30020 RC=124C.
IY50102INSTANCE TRAP IN SQLOFMBLKEX CAUSED BY SQLMON_DCS_APPDTV() ON GATEWAY
IY50112FEDERATED INSTANCE TRAP WHEN QUERY ON NICKNAME IS BEING FORCED OFF FROM THE DATASOURCE SERVER (ISSUE FORCE APPLICATION / CRASH)
IY50153CALL TO SETMAXFIELDSIZE DOES NOT RESET CAUSING DATA TRUNCATION
IY50181FUNCTION UCS_2_EUC_CONVERSION TRAPS BECAUSE OF AN ATTEMPT TO DIVIDE BY ZERO.
IY50182MEMORY LEAK IN DRDA AS WHEN PROCESSING QUERIES
IY50185SEGV IN SQLE_DB2RA_AR_SENDRECV TRYING TO REUSE A TERMINATED CONNECTION.
IY50191LATCH CONTENTION IN DPS CODE RESULTING IN ALL DB2 COMMANDS HANGING.
IY50222SIG #11 IN MEMTREEPUT/SQLNG_ALLOC_STORAGE/SQLNG_BUILD_SCALAG_OP
IY50244APPLICATION RECEIVING SQL0804 RC 106 (SQLAKCHECKSQLDA)
IY50268AN EXTRA COLON, :, IS ADDED TO THE PATH, IF THE ORIGINAL PATH ENDS WITH A COLON.
IY50322INCORRECT RESULTS OR INSTANCE CRASH WHEN RUNNING A QUERY
IY50323PRUNING HISTORY FILE TAKE LONG TIME DURING BACKUP IF IT HAS MANYFOR SIMULTANEOUS LOADS WITH MULTIPLE LOAD COPY TARGETS.
IY50357INSTANCE CRASH FROM AN INTERRUPTED AGENT
IY50397DBADM AUTH DOES NOT HAVE USE TABLE PRIV WHEN CREATING TABLE
IY50412DB2 CLP HIT DB21015E IF IT'S PPID AND UID ARE BIG NUMBERS.
IY50436SQLUGTPIWILL ALWAYS MISTAKENLY RETURN SQLTYPE VARGRAPHIC FOR PARTITION KEYS THAT ARE GRAPHIC.
IY50470NEED TO CHECK FOR INTERRUPTIONS WHEN DOING LEFTOVERS PHASE OF HASH JOIN
IY50769REPEATED ARCHIVE LOG COMMANDS ON A DATABASE WITH NO ACTIVITY RESULTS IN LOG FULL MESSAGES.
IY50801DB2LOOK SHOULD GENERATE 'REFRESH TABLE' STATEMENT WHEN A NEW INDEX IS CREATED ON A TABLE IN CHECK PENDING STATUS.
IY50810CALLING CLI FUNCTION SQLNUMRESULTCOLS CAUSE ERROR TO BE LOGGED IN DB2DIAG.LOG IRRESPECTIVE OF DIAGLEVEL.
IY50995TRAP IN SQLNO_CRULE_STARJN_AND. THIS IS DUE TO A NULL POINTER FOR THE PLAN LIST RETURNED BY SEMIJOIN FUNCTION.
IY51085SQL0901N WHEN MERGING TWO UNION OPERATIONS IN THE SAME QUERY DURING QUERY OPTIMIZATION.
IY51144WHEN ATTEMPTING TO ACCESS A TABLE IN A DMS TABLESPACE THAT HAS BEEN OFFLINE REORG'D, THE REQUEST FAILS WITH A SQL1007N.
IY51236SIGNAL #11 TRAP IN SQLNO_FIND_HASH_TABLE
IY51250OPTIMIZATION LEVEL OF ONE STATEMENT IS DEPENDENT ON THAT OF ANO-THER STATEMENT IN THE SAME CONNECTION. IT SHOULD BE INDEPENDENT
IY51463SMS TABLESPACE NEEDS TO CHECK IF LARGEST POOL PAGE NUMBER HAS BEEN REACHED.
IY51715SYNTAX ERROR IN DB2 GOVERNOR SCRIPT DB2GOV
IY51716DB2 CONNECT V8.1 GA IS LOOKING FOR LIBMQMAX.A IN /OPT/MQM/LIB RATHER THAN FOR LIBMQMAX.SO
IY51731ABEND:LOAD IN MPP FAILED WITH SQL2038N RC=27990 IF TARGET TABLE HAS VARGRAPHIC/GRAPHIC COLUMN USED FOR PARTITIONING KEY
IY51750POTENTIAL PERFORMANCE DEGRADATION IN SQL COMPOSITION CAUSED BY FALSE CONVERSION ERROR DETECTION.
IY51774A QUERY FAILS WITH SQL0901: BAD PLAN: UNRESOLVED QNC FOUND.
IY51794DB2 CRASH (PANIC) WHEN RUNNING WITH STATEMENT MONITOR SWITCH SET TO YES IN TABLE QUEUE CODE IN A EEE ENVIRONMENT
IY51832DATABASE INSTANCE CRASHES WHEN INSERT ROWS INTO TABLE USING JDBC
IY51838CANNOT CONNECT TO THE DATABASE LOCALLY WHEN USING THE PASSWORD THROUGH THE REMOTE LDAP.
JR05500NOT ALL STATEMENTS ARE CAPTURED IN STATIC CAPTURE.
JR05502DUMP ERROR MESSAGE IN DB2DIAG.LOG WHEN WINDOWS SERVER HITS THE MAX. OF DB2NTMEMSIZE
JR17349THERE IS NO SCROLL BAR FOR UDPS IN DATA WAREHOUSE CENTER. DWC
JR17374INCORRECT RESULTS RETURNED BY DB2ADUTL WHEN SPECIFYING A LARGE #FOR THE DELETE OLDER THAN OPTION
JR17634ERROR -1031 DURING CATALOG RESYNC IN MSCS ENVIRONMENT
JR17806EXPORT/IMPORT TO THE SAME DB2/390 TABLE FROM DB2 CONNECT GOT SQL3169N ERROR
JR17825THE TRUNCATION WARNING IS CAUSING THE IF EXPRESSION NOT TO BE EVALUATE.
JR17931INTRODUCE A NEW LDAP GLOBAL REGISTRY VARIABLE-DB2LDAP_KEEP_CONNENECTION SO THAT USER DON'T HAVE TO SET IT FOR EACH MACHINE.
JR17945-104 RESULTED FROM IMPORTI/LOAD WITH CREATE INTO OPTION.
JR18395DWC- SQLASSIST MOVING A CALCULATED COLUMN TO A SPECIFIED PLACE IN LIST OF COLUMNS, CHANGE FROM ADD TO BOTTOM OF LIST
JR18434TEMPORARY PATHNAMES WITH SPACES CAUSE SCRIPT CENTER SCRIPTS TO FAIL WITH DBA2078E.
JR18469BACKUP TO TAPE ON WINDOWS MAY CRASH INSTANCE
JR18472CONNECTING TO A V8.1 DB2 UDB ON LINUX USING V7.2 CON TROL CENTER ON WINDOWS 2000, DRILLING DOWN TO THE DBS SPINS
JR18474DECIMAL RESULT TRUNCATION WHEN USING W2K ITALIAN LOCALE
JR18475SIGNAL 11 REPORTED IN FUNCTION SQLPGSPR CAUSING INSTANCE ABEND
JR18483DWC- COPY OR MOVE OF STEP IS NOT REFRESHED WITHOUT CLOSING AND RE-OPENING NAVIGATOR,APPEARS AS MISMATCH WITH METADATA
JR18484DWC- STEP DEMOTED OR PROMOTED IN NAVIGATOR, STATUS OF LOCKS MAY NOT BE ACCURATELY DISPLAYED
JR18509DB2 TRACE FOR STORED PROCEDURE ON IBM-943 CODEPAGE GOT TRAPPED.
JR18512CLOB RETRIEVAL AGAINST 390 HOST RESULT IN ONLY 1-4K PIECES WITH THE SQLGETDATA
JR18516OLEDB DRIVER CAUSES THE WRONG INFORMATION TO BE PASSED TO SQLSETDESCREC AND THE APPLICATION RETURNS CLI0111E.
JR18518TRAP WHEN USING REGR_SCOPE
JR18520DWC- MIGRATION VW 5.2 TO DWC V7.2 GUI CODE IS DEPENDENT ON HAVING A 'DEFAULT' SECURITY GROUP
JR18541DWC - MIGRATION VW 5.2 TO DWC 7.2 FP7.... MISMATCH CAUSED BY MISSING REQ. TO SQLASSIST FOR GROUPBY
JR18544GATEWAY TRAP IN SQLE_DB2RA_PUTBUF2 WHEN CALLING SP WITH DBCS UNICODE DATA, WHEN SP ACCEPTS ONLY SPBC DATA.
JR18548DWC - SCREEN OCCASSIONALLY FREEZES (TURNS GRAY) THIS FIX IS FOR THE FLASH OF FROZEN SCREEN. TO UNFREEZE IT
JR18550DWC- SQLASSIST SEES TWO COLUMNS ATTEMPTING TO BE JOINED AS INCOMPATIBLE , BOTH CHARACTER, ONE IS FOR BIT DATA
JR18555CUT AND PASTE A JAVA STORED PROCEDURE FROM Z/OS USING THE STOREDPROCEDURE BUILDER - EXECUTION FAILS WITH AN SQL0204N ERROR.
JR18578INPUT CHAR PARAMETER CAN NOT HAVE LENGTH OF 0.
JR18582SQL1820N RC=1 STORING LARGE BLOBS VIA STORED PROCEDURE
JR18601JAVA.SQL.TYPES.DISTINCT BEING RETURNED (I.E,2001), INSTEAD OF JAVA.SQL.TYPES.CLOB( 1.E,2005).
JR18615CONTROL CENTER TRACE FAILS - EXCEPTION IN THREAD 'MAIN' JAVA.LANG.NOCLASSDEFFOUNDERROR: DATACACHE/IDATAUNIT
JR18616STORED PROCEDURE BUILDER TEXT CHANGED FROM JAPANESE TO ENGLISH BY FIXPAK 9
JR18619MIGRATION FAILURE DUE TO UDF_MEM_SZ HEAP PROBLEM.
JR18646COMP=OLE_DB_SUPPORT NOT IN SOME DEFAULT RESPONSE FILES.
JR18648DB2 CONNECT: DRDA HEAP GETS CORRUPTED WITH THE SET CURRENT STATEMENT. THIS CAN BE SEEN WITH DB2MEMDBG TURNED ON.
JR18651DWC\SQLASSIST-FOR LONG, COMPLEX SQL STATEMENTS, SQL ASSIST TAKESA LONG TIME TO CLOSE.
JR18669DSNL032I -DSNT DSNLIRTR DRDA EXCEPTION CONDITION IN REQUEST FROM REQUESTOR LOCATION...
JR18717NUMBERFORMATEXCEPTION WHEN RETRIEVING VALUE OF INOUT BIGDECIMAL
JR18730CLI0002W DATA TRUNCATED WHEN EXECUTING A CALL TO A STORED PROCEDURE
JR18740DWC - DOUBLE CLICK REMOVES TABLE FROM RIGHT COLUMN, COMMON CLASSPROBLEM
JR18748DWC - CAN NOT REMOVE SOURCE IF IT IS SQL SEVER DATABASE.
JR18762BLOB COLUMN NOT BEING SET TO NULL VIA SQLPUTDATA()
JR18783DWC - 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
JR18791DWC - DAILY SCHEDULE SKIPS A DAY IF SCHEDULE IS TO START LESS THAN 24 HOURS FROM CURRENT TIME
JR18796CLI TRAP IN SQLDESCRIBEPARAM WITH PATCH1=65536 SET
JR18797DWC - IN RESPONSE TO ONETIME ERROR 8525 # OF ELEMENTS DIFFERENT SQL CHANGE TO REPORT ALL CODES POSSIBLE FOR THIS
JR18800DB2JDS PROCESS CRASHING IN SQLOFMBLKEX() FUNCTION. THIS CAN BE SEEN IN THE DR. WATSON LOG FILE
JR18836IMPORT FAILS USING DELIMITED DATA - INT / CHAR PARSER PROBLEM
JR18837SQL1088W WHEN CREATING DATABASE WITH CONTROL CENTER
JR18849DOUBLE-BYTE LENGTHS MISINTERPRETED AS CHARS
JR18855DWC - SCHEDULE WINDOW SLOW TO RETRIEVE INFORMATION .. CODE TO REDUCE THAT RESPONSE TIME
JR18865CONTROL CENTER NOT SHOWING THE CORRECT USER SECURITY SETTINGS FOR AST TABLES
JR18872WHEN THE CONCENTRATOR IS ENABLED, CUSTOMER RECEIVES CLI0002W UPON FETCHING A STORED PROCEDURE RESULTSET.
JR18874STORED PROCEDURE BUILDER FAILS WITH ERROR SQL0440N WHEN RUNNING A JAVA STORED PROCEDURE AFTER CHANGING A PARAMETER NAME
JR18880DWC - DATES AND TIMESTAMPS DO NOT ALWAYS REFLECT CORRECT INFORMATIION IN WIP.
JR18890THE LENGTH OF THIS VARGRAPHIC FIELDS CONTENTS IS DOUBLED IN SIZE
JR18899SQL0918N ERROR DESPITE HAVING ISSUED A ROLLBACK FROM APPLICATION
JR18900DWC- SQLASSIT - SAVING CONTENTS OF ONE STEP INTO ANOTHER, SAVINGTHEN TRYING TO EDIT, BREAKS
JR18903STORED PROCEDURE BUILDER LOOSES SP COMMENTS WHEN SAVING SP GOING FROM WINDOWS TO OS/390.
JR18908EXCEPTION NOT THROWN WHEN LOCK TIMEOUT EXPERIENCED
JR18917LENGHT() CALL ON CLOB RETURNS THE NUMBER OF BYTES INSTEAD OF THE CHARACTERS IN A MULTI BYTE DATABASE
JR18947DWC-ON THE CLIENT MACHINES, ARE BEING THROWN OUT OF WAREHOUSE SPORADICALLY ON PROMOTE,DEMOTE,EXIT SQLASSIST
JR19062RESULTSET CORRUPTED ON PRE-FP9 CLIENTS WHEN CONNECTION POOLING IS ENABLED ON FP9+ DB2 CONNECT GATEWAY.
JR19066DWC - WHEN USING THE LOCATE FUNCTION WITHIN DWC IF A WILD CARD IS USED (IE. %DEPT) WRONG RESULTS ARE RETURNED.
JR19095ERROR JAVA.IO.UTFDATAFORMATEXCEPTION OCCURS WHEN USING STORED PROCEDURE BUILDER TO SAVE A PROJECT WITH JAVA SP > 64K LENGTH.
JR19097AT DIAGLEVEL 4, DB2DIAG.LOG SHOWS MANY FILE OPEN ERRORS (SQLOOPE NP) FOR MESSAGE FILES LIKE D:\SQLLIB\MSG\C\DB2SQL.MO
JR19102WHEN SHUTING DOWN THE MACHINE, DB2SYSC AND DB2DAS ARE NOT SHUTTING DOWN PROPERLY.
JR19105AFTER MODIFYING STEP, DWC SESSION IS LOST
JR19115DB2 (LDAP SERVER)-NOT PICKING UP CORRECT VALUE FOR DB2INSTANCE BEFORE STARTING DB2.
JR19137GEOCODE FAILURE
JR19149SQLGETDIAGRECW INCORRECTLY RETURNS SQL_SUCCESS FOR THE TRUNCATEDERROR MESSAGE. SHOULD BE SQL_SUCCESS_WITH_INFO
JR19153NO RESULTS RETURNED FROM A STORED PROCEDURE WHEN A JAVA SP CREATED ON WINDOWS, IS COPIED AND PASTED TO Z/OS DB2 AND REBUILT
JR19161IN RECORDSET OF ADO OBJECT USING IBMDADB2, ALL OF THE FIELDS HAVE ADFLDMAYBENULL SET TO TRUE.
JR19164DWC - DATA WAREHOUSE CENTER SERVER MAY FAIL ON WINDOWS 2000, WITH NT EVENT OF 7031
JR19166DWC - MIGRATED CONTROL DB FROM VISUAL WAREHOUSE, STEPS MAY NOT WORK.
JR19185ACCESS VIOLATION IN CLI_CPQTIMEMON
JR19186FILTER SCHEMAS WINDOW DOES NOT WORK WITH WILDCARD CHARACTER.
JR19200PROBLEM USING JDBC GENERATE.JAVA TO CALL DXXGENXML() STORED PROCEDURE. ERROR RETURNED SQL0423N,DXXM011W AND DXXG001E
JR19209TIMING HOLE IN CLI CAUSING CRASH IN SQLNUMRESULTCOLS()
JR19238OBJECT NAMES WITH QUOTES GETS CORRUPTED ON EXPORT AND IMPORT
JR19303GETROW() IS RETURNING THE WRONG RESULTS WHEN TYPE_FORWARD_ONLY IS SPECIFIED AND THE ENTIRE RESULTSET IS NOT RETRIEVED.
JR19412WINDOWS, CORRUPTED STACK CAUSES TRAP
JR19416AFTER DISABLE AND RE ENABLE OF XML EXTENDER COLUMN, UPDATE TRIGGER FAILS IS SET XMLCOLUMN = XMLCOLUMN
JR19417XML EXTENDER ADMINISTRATION WIZARD CALL db2XML.DXXENABLEDB INSTEAD OF CALLING QDBXML.DXXENABLEDB. SQL0204
JR19426SYMPTOM: STEPS IN A PROCESS REARRANGE WHEN METADATA IS MIGRATED FROM V7 AT FP5 WINDOWS TO V8 FP2 WINDOWS TO V8 AIX AT FP2.
JR19430TRAP IN SQLMEIOT AT SQM_EVMON_IOT.
JR19433SELECT ON NICKNAME CONTAINING MDL FUNCTIONS CAUSES A UDB CRASH
LI70220SQL0104N - IMPORT INTO OS/390 TABLE WHEN OS/390 DECIMAL ZPARM ISSET TO A COMMA
SA96242DWC I-SERIES AGENT REQUIRES TARGET TO HAVE COMMITMENT CONTROL
APAR fixes included in U495179 (Fixpak 10a)
APARABSTRACT
IY44816SLOW DATABASE ACTIVATION, ROLLFORWARD FAILS WITH SQL1265 , OR DATABASE CRASHES AND IS NON-RECOVERABLE
IY47653DB2LICM ALLOWS FOR USERS WITH EXECUTE PERMISSION OVER DB2LICM TO ACHIEVE ROOT PRIVILEGES
IY47686DB2 SEARCH DISCOVERY LISTENER CAN STOP RESPONDING BY SENDING A MALICIOUS NETWORK PACKET
IY47987ALL USERS WITH EXECUTE PRIVILEGE ON BINARY FILE DB2JOB CAN EXPLOIT ROOT PRIVELEGE
APAR fixes included in U488497 (Fixpak 10)
APARABSTRACT
GG04394DPROPR CAPTURE FOR WORKSTATIONS DOES NOT HANDLE UTILITY TYPE LOG RECORDS CORRECTLY. THE SYMPTOM IS UNPREDICTABLE.
IC35840WHEN CALLING ORACLE UDF VIA RELATIONAL CONNECT,PERFORMANCE IS SLOW.
IC36344V7 DB2 UDB CLIENT CALLS A STORED PROCEDURE WITH LOB PARAMETERS ON OS/390 THROUGH GATEWAY, TRAPS
IY29073JOIN OF 27 TABLES FAILS SQL0101, THIS LARGE TRANSITIVE JOIN WILLCREATE A HUGE NUMBER OF PREDICTED PREDICATES. THIS USES UP
IY29791LONG PREP TIME DUE TO EXPONENTIAL GROWTH IN THE NUMBER OF CANCATENATED KEYS.
IY30004APPLY SUPPORT FOR NEW V8 REPLICATION CONTROL TABLE STRUCTURES
IY30153INCORRECT CARD ESTIMATES IN EEE WHEN BOUND TO SINGLE NODE
IY32976DATABASE INTERMITTENTLY MARKED BADWHEN CREATING DECLARED GLOBAL TEMP TABLE -> FFFFF102 RETURNED FROM SQLRL_DGTT_RCV
IY33412IMPLEMENT PUSHDONW OF REGULAR JOIN THROUGH OJ IF IT IS NEAR UNIQUE. AS WELL PUSH DOWN IF THERE IS MULTIPLE OJS.
IY34572REMOVE THE NEED TO BE SYSADM IN ORDER TO BE ABLE TO ISSUE THE CMD 'DB2 UPDATE CLI AT GLOBAL LEVEL'
IY36278USE INLIST SIZE TO PLACE UPPER BOUND ON EFFECTIVE COLUMN CARD AS IT IMPACTS INLIST QUERIES
IY36962SIGNAL 11 GENERATED WHEN CALLING SQLJ.INSTALLJAR FROM CLIENT OR NON-CATALOG NODE.
IY37281PERFORMANCE DEGRADATION ON QUERY WITH IN LIST OF 200 OR MORE ELEMENTS AFTER UPGRADE TO FIXPAK 4
IY37712DB2CKLOG NOT DETECTING SPECIFIC LOG CHECKSUM CORRUPTION
IY38228SUPPRESSING THE SQL1427 ERROR MESSAGE IN THE DB2DIAG.LOG WHICH IS BEING LOGGED NEEDLESSLY BY THE AUTOLOADER PROCESS.
IY38451CHANGE COSTING ON REFETCH THAT IS PLACED ABOVE A HSJOIN THAT DON'T SPILL, FOR UPDATES.
IY38606DB2.O CREATING DUPLICATE LIBDB2.A LIBRARIES WHEN USING AN ODBC DRIVER MANAGER.
IY38790THE MAXIMUM LENGTH OF DEFAULT VALUE FOR CHAR COLUMN IS INCONSISTENT.
IY39222CAPTURE AND SQL0180N
IY39381TRAP THROUGH SQLMON_TS_LIST::SIZE_TS_LIST
IY39483CUSTOMER RUNNING DB2EMCRT DBALIAS. IF DB2ALIAS NOT EQUAL TO DB NAME THEN DBA5500 FOLLOWED BY DBA1154
IY39731LOAD OR IMPORT OF A LOBFILE THAT IS LARGER TAHN 2 GB WILL FAIL
IY39767SET INTEGRITY ON A TABLE WITH SELF-REFERENCING RI AND GENERATED COLUMNS COULD CAUSE AN ENGINE TRAP.
IY39799DB2 CONNECT RETURNS INCORRECT SQLCA SQLERRP VALUE FOR IDENTITY OF THE DATABASE WHEN USING TCP/IP CLIENT ON DB2/ZOS.
IY39938DROP_DLM ALWAS RETURNS, DLFM1001E:ERROR IN DROP_DLM PROCESSING
IY39950SQL1131N WHEN RUNNING NESTED STORED PROCEDURES
IY40098FRACTION PART OF DECIMAL MISSING DURING INSERT VIA JDBC.
IY40106UNPREDICTABLE OUT-OF-MEMORY FAILURES ON 32-BIT SYSTEMS WHEN DATABASE SHARED MEMORY CONFIGURATIONS ARE CLOSE TO OR EXCEED 4GB
IY40135SIGNAL #11 SIGSEGV TRAP IN SQLESRVR IN CLEANUP CODE AFTER AN SQL1034 HAS ALREADY BEEN RECEIVED.
IY40139SIGNAL 11 IN SQLRIRIDC OR SQLRI_RESTORE_DML_DSS_INFO
IY40143DBA1107 AN ERROR OCCURRED WHEN THE PERFORMANCE CONFIGURATION WIZARD TRIED TO GET SYSTEM INFORMATION FROM YOUR SERVER. LINUX.
IY40174INSTANCE CAN CRASH IN SQLE_DB2RA_GETDATAAREA() WHILE DEALING WITH STATIC BLOCKABLE CURSOR IN PASSTHROUGH MODE
IY40210USING IBM'S OLE DB PROVIDER, CUSTOMER TRIES TO RETRIEVE A RESULTSET AND GETS 'CONNECTION TO SERVER IS LOST'
IY40264BLAST DAEMON FOR BLAST WRAPPER (LIFE SCIENCES DATA CONNECT) CORES ON RED HAT 8 WITH GLIBC 2.2.93
IY40308ABNORMAL CLOSE OF STORED PROCEDURE MRSP CURSOR CAUSES MEMORY CORRUPTION, TRAP IN MEMTREEDELETE
IY40341DESCRIBEPARAM CALL FAILS ON BAD SQL AND ERROR GETS MAPPED WRONG BY IBM'S OLE DB PROVIDER.
IY40419STATEMENT CACHING CAUSES DB2 TO IMPROPERLY RETRIEVE DATA
IY40427ALLOW JCC CLIENTS TO DESCRIBE INCREMENTAL BIND SECTIONS AT RUN TIME
IY40433DB2STOP FAILS TO CLEAN UP THE DB PROCESSES UNDER LIMITED CIRCUMSTANCES
IY40438FIX DB2DATASOURCE CLASS SO IT IS THREADSAFE
IY40439INITIAL CONNECTION/ACTIVATION APPEARS SLOW
IY40515POSSIBLE INSTANCE CRASH WHEN CLI OPTION MULTICONNECT IS SET TO 3(NO TRAP FILES ARE GENERATED.)
IY40567CAPTURE COREDUMPS WHEN A BEFORE IMAGE COLUMN DOES NOT HAVE A MATCHING BASE COLUMN.
IY40568SQL30090 ERROR IN DB2/C/CICS FOR 'CURSOR WITH HOLD'
IY40583WHEN EXECUTING THE 'END COMPOUND' COMMAND AGAINST A HOST (OS/390, AS400...), DB2CLI WILL TRAP.
IY40614EEE : AUTOLOADER FAILS WITH SQL1336N WITH CORRUPT HOSTNAME
IY40639A CRASH RIGHT AFTER A CLI0135E IN A JDBC APPLICATION.
IY40728SIG11 IN DB2SYSC : WHEN RUNNING KEEPDARI = NO IT IS POSSIBLE FORTHE AGENT ITSELF TO BE FREED,
IY40749QUERY PATROLLER DQPSTART FAILS WITH A DB210064E ERROR.
IY40771ATTEMPT TO EXPLICITLY CONNECT FROM WITHIN A STORED PROCEDURE CAN CRASH THE DB2 INSTANCE
IY40781APPLICATION RECEIVES AN SQL0918 AFTER ROLLBACK DUE TO LOCKTIMEOUT IN XA ENVIRONMENT.
IY40794AFTER FAILOVER OF DB2 CONNECT IN A 2PC SPM ENVIRONMENT, RESYNC FAILS.
IY40796CANNOT INTERRUPT A SORT SPILL
IY40873SWITCHING FROM LOCATORS TO LOBS DURING FETCH CAUSING TRAP WHEN SQL_RULES_DB2 SPECIFIED.
IY40922DB2 CRASH - SIGNAL 11 TRAP IN SQLNO_FINAL_PHASE() WHEN A QUERY IS RUN ON TABLE WHICH HAS A SUMMARY TABLE AND QUERY ACCESS THAT.
IY40954ENABLING DUAL LOGGING WITH LARGE LOG FILES CREATES VERY LARGE PERFORMANCE DEGRADATION (70-100X).
IY41079INSTANCE CRASH WITH SIGNAL #11: MEMORY CORRUPTION IN FEDERATED ENVIRONMENT WITH STATEMENT MONITORING ON
IY41111SIGNAL 11 TRAP (SEGV) OCCURS IF A DB2/390 DATABASE IS CATALOGED AS A DB2/UWO DATABASE IN AN SPM ENVIRONMENT.
IY41154DB2 CLI MEMORY CORRUPTION (MULTICONNECT=3) AND 255 COLUMNS OR GREATER IN THE SELECT LIST.
IY41155INCORRECT OUTPUT DUE TO QUERY REWRITE.
IY41162SIGNAL 11 (SEGV) TRAP ON EEE WHILE USING FEDERATED LINKS TO ACCESS A REMOTE EE DATABASE
IY41164MEMORY LEAK WHEN USING LOAD WITH STATISTICS YES
IY41174F8 WHEN USING INVOKE TO CALL A SP IF IT IS SUCCESSFUL THE RC=2 INSTEAD OF RC=0
IY41185SQLNUMPARAMS DOES NOT RETURN THE CORRECT NUMBER OF PARAMETERS
IY41218INCONSISTENT BEHAVIOUR OF JDBC APP/NET DRIVER WITH CLEARPARAMETERS STATEMENT
IY41289WHILE RUNNING DB2BATCH TOOLS AS A SYSCTRL AUTHORITYGETTING AUTHORITY ERROR.
IY41292SQLSETCONNECTATTR() FAILS WITH SQL30090N (RC=20) AFTER EXECUTIONOF SQL STATEMENT WHICH RETURNS SQL_NO_DATA_FOUND
IY41325CLI0100E ON UPDATE WHEN DEFERREDPREPARE=0
IY41425DPROPR CAPTURE DOES NOT UPDATE THE SYNCHTIME IN THE GLOBAL ROW OF THE REGISTER TABLE WHEN THERE ARE NO NEW LOG RECORDS
IY41451SQL0818N TIMESTAMP CONFLICT AFTER REBINDING APPLICATION WHICH USES A CHAR PADDED WITH BLANKS FOR SET CURRENT PACKAGESET
IY41480DB2START HANGS BECAUSE DB2CHKAU IS STUCK IN A TIGHT LOOP CONSUMING CPU CYCLES.
IY41572JTA (AND XA) CONNECTION TO BIG5 DB FAILS WITH CLI0108E
IY41578FAVOUR FULLY QUALIFIED UNIQUE INDEX ACCESS OVER OTHER INDEXES ACCESSES
IY41594FIX CONNECTION POOLING CLEANUP LOGIC DURING DATABASE FAILURE
IY41601SIGNAL #11 TRAP IN SQLM_DROP_TS WHEN DROPPING A TABLESPACE
IY41643IMPORT WITH LOB'S AND DIAGLEVEL SET TO 4 RESULTS WITH -423 ENTRIES IN THE DB2DIAG.LOG (SQL0423N)
IY41651EEE : AUTOLOADER FAILING WITH SQL3508N,RC=1
IY41702SMALL TIMING HOLE WHEN RESTORING A DATABASE WHERE THE RESTORING DATABASE WILL ALLOW A CONNECTION. RESTORE FAILS WITH SQL1035N.
IY41846PREDICATE NOT BEING PUSHED DOWN FULLY, RESULTS IN NEGATIVE PERFORMANCE IMPACT.
IY41848INSTANCE CRUSHES AND TRAP GENERATED ON THE GATEWAY, WHEN CONNECTING WITH XA APPLICATION
IY41890OPTIMIZER DOES NOT CHOOSE A SUMMARY TABLE WHEN IT IS AVAILABLE.
IY41903REFRESH TABLE RETURNS SQL0901N WITH REASON 'FOUND ZERO CLOB.RESET'
IY41963UNABLE TO DROP A PROCEDURE IF THE SCHEMA NAME FOR THE PACKAGE IS LOWERCASE IN THE SYSDEPENDENCIES TABLE.
IY41970TIMING FOR INTERRUPT MAY CAUSE HANG
IY42004SQL0973N NOT ENOUGH STORAGE IS AVAILABLE IN THE 'APP_CTL_HEAP' HEAP IN QP
IY42010A CLI0114E ERROR SHOULD OCCUR WHEN EXECUTING SQL WHERE THE FRACTIONAL SECONDS FIELDS OF TYPE SQL_C_TYPE_TIMESTAMP GETS TRUNCATED
IY42075POINT IN TIME RECOVERY GOES BEYOND SPECIFIED PIT WHEN THERE IS AN INFO_ONLY LOG RECORD.
IY42097FIX THE FOR STMT OF THE FCT CHANGE_USER_IN_USERFILES IN DB2_INST_HA.LOCAL
IY42128DB2CKBKP FAILS WITH RC=-1 WHEN TOO MANY TABLESPACES ARE DEFINED
IY42145BACKUP TO TSM FAILS WITH SQL2072N RC 6646-UNABLE TO BIND TO LIBTADSM.A
IY42146DB2AUDIT.LOG CORRUPTED WHEN FILESYSTEM FILLS
IY42166INCORRECT VALUES ARE BEING RETURNED FROM VARCHAR COLUMN OF UTF-8DB USING IBMDADB2.
IY42175IN SCRIPT DB2GOVLG LOOKING FOR PWD IN /ETC/PASSWD DOES NOT WORKIN NIS ENVIRONMENT.
IY42180UDB EXPORT UTILITY RUN AGAINST AN AS400 GETS SQL0805 PACKAGE SQLUAD08 NOT FOUND
IY42267ABEND:DB2ATLD FAILED WITH COREDUMP: ERRPT SHOWS SIGNAL 11 IN THESQLOFMBLK
IY42281CORE IN CLI_SCROLGETAROW2
IY42291MISSLEADING 'DIA3847C AN ERROR OCCURRED IN A DATABASE PAGE' ERROR WHEN MAX NUMBER OF AGENTS IS REACHED.
IY42313XASTART() RETURNS XAER_PROTO, SHOULD RETURN XAER_OUTSIDE WHEN LOCAL STATEMENT EXISTS BEFORE XASTART() IS CALLED.
IY42330UDB DISTRIBUTED DRDA APPLICATION SERVER SENDS RDBUPDRM TO A DRDA AR EVEN IF IT SUPPORTS SQLAM < 3 ONLY.
IY42342DB2CAT IS FAILED FOR GABAGED TABLE NAME, IF IT HAS DBCS.
IY42344SIGNAL 11 (SIGSEGV) IN SQLRA_DEL_LRU()
IY42346AGENT SERVICING A QUERY DOESN'T FORCE WHEN FORCE APPLICATION IS ISSUED.
IY42366BUFFERPOOL ASYNC READ SNAPSHOT DATA INCORRECT
IY42387DB2 CONNECT APPLICATIONS DO NOT PROPERLY INITIALIZE THE MONITOR STATEMENT STOP TIME
IY42389SIGSEGV IN SQLUIMPM DURING LOB PROCESSING
IY42405LOGON DIALOG ALONG WITH ERROR SQL1403 DISPLAYED IN CONTROL CENTER ON FIRST ATTEMPT TO CONNECT TO DATABASE
IY42429SQLEAPPSETPRIORITY NEEDS TO HOLD THE APP TABLE LATCH
IY42476BLOCKING CURSOR ELEMENT IN SNAPSHOT MONITOR ALWAYS SHOWS NO
IY42511WHEN IMPORT WITH COMPOUND=100 USED AND ROW 100 IS REJECTED, THE ERROR MESSAGE SHOWS MISLEADING ROW NUMBER.
IY42523CLI AUTOBINDING UNNECESSARILY WHEN SOMETHING OTHER THAN A PACKAGE CANNOT BE FOUND.
IY42544SQL0803N WHEN DOING BATCH UPDATING IN A JDBC APPLICATION
IY42570LIST APPLICATIONS MAY NOT RETURN AN ACCURATE COUNT IF ONE OR MORE DATABASES ARE NOT ACTIVE.
IY42575DB2 UDB GATEWAY DOESN'T HANDLING LARGE SIZE PREPARE/DESCRIBE STATEMENT CORRECTLY. -30020 IS REPORTED
IY42605CREATING, DROPPING AND FLUSHING AN EVENT MONITOR CONCURRENTLY CAN HANG THE SERVER.
IY42617DB2 REORGCHK ON NON-EXISTENT TABLE DOES NOT RETURN ERROR OR INFORMATIONAL MESSAGE.
IY42625SQL PROCEDURE PARSING INCORRECT IN 'WHERE CURRENT OF <CURSOR>' STATEMENT.
IY42638SAVE TO FILE OPERATION IN SPB AGAINST CERTAIN STORED PROCEDURES DOES NOT DISPLAY SAVE DIRECTORY DIALOG BOX, CAN NOT SAVE.
IY42639INCORRECT ERROR HANDLING FOR OUT OF MEMORY CONDITION IN BINSORT COULD LEAD TO A TRAP
IY42652CODEPAGE CONVERSION FILE FOR 1140->UCS2 MISSING
IY42659SQLFREEENV GETTING AN INVALID SEQUENCE ERROR UNDER MULTICONNECT
IY42672SET DB2_ENABLE_LDAP=NO IN RUNTIME CLIENT'S RESPONSE FILE DOESN'TTAKE EFFECT
IY42695DB2ATLD SPLIT_ONLY JOB FAILS WITH SQL6554 WHICH IS FINE, HOWEVERIT FAILS TO RETURN NON-ZERO RC TO THE SHELL.
IY42713PROVIDE OPTION TO TURN OFF DB2 LOGGING WHEN QP INTERCEPTS INSERTSTATEMENT AND TABLE IN QUESTION HAS NOT LOGGED INITIALLY ATTRIBU
IY42837INSTANCE CRASH WHILE CALCULATING QUERY DEPENDENCIES
IY42841FP10:REVERSE INDEX SCAN IS WAITING ON A DELETED PAGE. SINCE THE PAGE IS DELETED WE ARE IN AN INFINITE LOOP.
IY42842WHEN USING A SELECT DISTINCT TO SELECT FROM A NICKNAME, THE THE DISTINCT IS NOT PUSHED DOWN TO THE DATA SOURCE
IY42846CLI0111E CONVERSION ERROR WHEN INSERTING DECIMAL OF FORM -0.AAA INTO TABLE WITH DECIMAL(A,A)
IY42854A TIMESTAMP PASSED IN A WHERE CLAUSE TO THE DATE FUNCTION RETURNSUCCESS_WITH_INFO, BUT THE CURSOR IS NOT OPENED, THE FETCH FAILS
IY42878SQL0430N UDF 'DB2XML.EXTRACTDATE' ABNORMALLY TERMINTED.
IY42897CONNECTING TO A REMOTE DATABASE USING TCPIP RETURNS SQL30081 ERRNO=4 (EINTR)
IY42978INCORRECT NTH ROW COSTING
IY43105TRAP IN SQLE_DB2RA_DELCCB WHEN SETUP IN HOP ENVIRONMENT
IY43239DPROPR CAPTURE DOES NOT CAPTURE RUNNING WITH CHGONLY OPTION DOES NOT CAPTURE CHANGES TO VARCHAR COLUMNS IN SPECIAL CONDITION
IY43253LOAD COMMAND HANGS DUE TO RIDDER CODEPATH OF THE COMMAND.
IY43269ADD CAPABILITY TO STOP AIX TRACE WHEN DB2 DETECTS DATA CORRUPTION.
IY43300JDBC RESULTSET.CLOSE() STATEMENT WILL CLOSE THE STATEMENT, AND NOT JUST THE RESULTSET.
IY43309TO ENABLE BRANCH ELIMINATION FEATURE ON INSERT/UPDATE/DELETE -SELECT SQL.
IY43323ONLINE BACKUP FAILS DUE TO LOCKTIMEOUT. HOWEVER, THERE IS NO INDICATION WHICH OBJECT IS LOCKED.
IY43366STMTHEAP RESOURCE CONSUMPTION TOO LARGE FOR COMPLEX QUERIES THATDO NOT REFERENCE REMOTE RESOURCES IN A FEDERATED ENVIRONMENT
IY43409OPTIMIZER-ROUTED MQTS OVER NICKNAME ARE NOT USED FOR QUERY OPTIMIZATION ON DB2 EEE FEDERATED SYSTEM
IY43420CONNECTION HANDLE IS NOT FREED UP AFTER FAILED ROLLBACK FOR THE FAILED (DEAD) CONNECTION.
IY43460INSTANCE ABENDS IN SQLED_CALLBDRDAOUTPUT__FP7UCINTFC + 0X16B0 WHEN TESTING JAVA SP ON 4 NODE DB2
IY43496TO FIX THE SELECTIVITY FOR SUBTERMS OF AN OR PREDICATE WHEN THE SUBTERM CONTAINS HOST VARIABLE OR PARAMETER MARKERS.
IY43534SNAPSHOTS WHOSE TEXT STRINGS ARE CODEPAGE CONVERTED CAN RESULT IN INCORRECT LENGTHS IN ELEMENT AND LOGICAL GROUP HEADERS.
IY43553SQL0413 DURING AN ATTEMPT TO CREATE NICKNAME, DUE TO THE CASTINGTHE CARDINALITY OF THE TABLE TO AN INTEGER. SHOULD BE BIGINT.
IY43562COPY TABLE IN DB2CC MAY CREATE THE TARGET TABLE IN THE WRONG TABLESPACE.
IY43575HANG - INFINITE LOOP IN INDEX MANAGER CAUSED APPLICATION HANG
IY43606DATA FOR CHAR, VARCHAR GET TRUNCATED WHEN PERFORMING LOAD WITH CODEPAGE CONVERSION AND TARGET LENGTH BIGGER THAN SOURCE (IXF)
IY43621SQL_C_DBCHAR DO NOT PROPERLY NULL TERMINATED
IY43648DB2 ALLOWS DELETE OF ROWS WHEN RI SHOULD PREVENT DELETION DUPLICATE.
IY43713SIG 11 IN SQLRI_HSJNNEWTUPLE CAUSING ENGINE CRASH
IY43715DRDA CONNECTION VERY SLOW DUE TO HIGH GATEWAY CONNECTION POOL AGENTS STOLEN
IY43755DATABASE PREFETCH_WAIT_TIME DOES NOT INCLUDE TIMES FOR TERMINATED APPLICATIONS
IY43756JDBC PREPAREDSTATEMENT EXECUTES BATCH INSTEAD OF NEW PARAMETERS.
IY43772INCORRECT MEDIA HEADER INFORMATION FROM USING SQLUV API
IY43801DPROPR APPLY DOES NOT DETECT A GAP CONDITION WHEN THE SOURCE IS A VIEW.
IY43816LOAD CANNOT LOAD MORE 27 CHARACTER LONG NUMBER INTO THE FLOAT OR DOUBLE COLUMN.
IY43841ENHANCEMENTS OF SOPMERGE RULE IN QUERY REWRITE TO ALLOW MULTIPLEUNIONS MERGED WITH SELECT BOX IN BETWEEN.
IY43845STATUS OF APPLICATION IN MONITOR MAY SHOW UP AS UOW EXECUTING WHILE ACTUALLY BEING IN (INTERALLY TRIGGERED) ROLLBACK
IY43849WHEN CHIME_STRING AND CAST FUNCTION IN A SELECT FROM A NICKNAME, THE SELECT DOES NOT WORK
IY43852QUERY GETS WRONG RESULTS FROM LINUX DB USING FEDERATED AGAINST AS400.
IY43854ADDITIONAL AUTOLOADER CODE ADDED TO DETECT IF THE AUTOLOADER TIMED OUT DUE TO PACKET DROPS ON THE NETWORK
IY43875CLEAN UP MINOR ERRORS IN THE SAMPLES SCRIPTS FOR XML EXTENDER.
IY43923ALLOW DISPLAYING OF FUNCTION NAMES IN FORMATTED WINDOWS TRAP FILES.
IY43944ERRORS NOT BEING PROPAGATED TO VB APP USING OUR OLEDB PROVIDER
IY43964DB MARKED BAD AFTER SYSTEM MEMORY LIMIT REACHED
IY43965SYBASE DBLIB WRAPPER CAUSES CRASH IF YOU CREATE NICKNAMES ON MULTIPLE SERVERS.
IY43970SQL QUERY TRAPS INSTANCE WITH SIGSEGV#11 IN DISCONNECT_TREE DURING QUERY REWRITE PHASE
IY43972FFIX THE IS_UNION_ALL DEFECT AND ENHANCE THE ETOF QRW RULE
IY43979DB2SPLIT SIGSEGV WITH CERTAIN LOCALES.
IY44092SQL30082 RC 24 WHEN TRYING TO CHANGE HOSTPWD FROM CLIENT APPLN PGM
IY44099CONNECTING TO A DB VIA CONTROL CENTER AND OPENING VIEW INFO ON 10 DIFFERENT VIEWS 10 CONNECTIONS WILL BE OPEN TO THE DATABASE.
IY44104COALESCE FUNTION IS NOT BEING PUSHED DOWN TO SYBASE DATA SRC.
IY44117SELECT * FROM TABLE IN DB2SQL92, WHERE THE BLANK BETWEEN SELECT AND STAR IS REPLACED WITH A TAB, FAILS WITH SQL0084N
IY44122THE COMPILER INCORRECTLY CHANGES THE COLUMN ORDERING IN A UNION OPERATION WHEN USING A NICKNAME
IY44156PERFORMANCE IMPROVEMENT THAT MAINLY AFFECTS FEDERATED STATEMENTSRUNNING IN A MPP ENVIRONMENT:
IY44240CERTAIN LOGS FAIL TO BE ARCHIVED BY DB2CART
IY44286INCORRECT REWRITE OF QUERY WITH OR PREDICATE TO UNION
IY44298DB2 MAY TRAP AT CLIENT SIDE AFTER FETCHING ROW DATA RETURNED BY MULTI RESULT SETS STORED PROCEDURE.
IY44307DURING A FAILED LOAD, ROLLBACK MAY FAIL BECAUSE OF THE BACKUP PENDING STATE.
IY44348DATA IS LOST WHEN RESTORING BACKUP IMAGES OF MULTI-CONTAINER, SM S TABLE SPACES WHICH CONTAIN LOB DATA.
IY44350UDB CRASHES WHEN ISSUING AN SQL STATMENT THAT CONTAINS A UNION INVOLVING NICKNAMES
IY44358SQL0401N WHEN TRYING TO TRYING TO ALTER TABLE AND ADD FOREIGN KEY CONSISTING OF DISTINCT TYPES..
IY44407BAD PAGE ENCOUNTERED IN SQLIFIX
IY44431CLI0125E MAY OCCUR ON THE SECOND EXECUTE IF THE ASKED FOR CURSORIS DOWNGRADED (FOR EXAMPLE, FROM SCROLLABLE TO FORWARD ONLY)
IY44442TO FIX MISORDERED ROWS ON REORG WITH CLUSTERED INDEX.
IY44446INSERT FAILS IF TABLE HAS VARIABLE LENGTH ROWS AND TABLESPACE IS FULL ALTHROUGH SOME PAGES HAVE FREE SPACE
IY44482SEGV IN MEMTREEDELETE WHEN CREATING A SUMMARY TABLE WITH OUTER
IY44497APPLICATION WHICH CALLS A STORED PROCEDURE WITH LOB PARAMETER AND MULTI RESULT SET, MAY GET -30020,AND REASON CODE '2202'
IY44522SIGNAL 11 AT SQLNO_CONV_CHAR2FLOAT WHEN PERFORMING A QUERY
IY44538DB2CC: CANNOT ALTER BUFFERPOOL OF EXISTING TABLE WITH THE CONTROL CENTER OF FP9
IY44556HANG IN SQLRI_BFIXAND
IY44569MISSING SPACE BETWEEN COMMA SEPARATORS CAUSES SQLCODE104.
IY44814THE DB2RELOCATEDB TOOL DOES NOT WORK PROPERLY ON HP-UX
IY44913INCORRECT RESULTS FROM FETCH FIRST N ROWS WITH A SUBQUERY
IY44939PACKAGE INVALIDATION GETS SKIPPED ON DROP OF A TABLE.
IY44954PERFORMANCE DEGRADES WHEN FEDERATED PART IS NOT RIGHT LEG OF THEUNION WITH A LOCAL QUERY
IY45432FP3: COMMAND CENTER SHOULD PROMPT FOR USERID/PASSWORD
IY45503DATABASE ROLLFORWARD COMPLAINS ABOUT PAGE HEADER PROBLEMS
IY45616THE DB2 UDB CONTROL CENTER, DB2CC , IS SLOW TO START (SEVERAL MINUTES) BY A REGULAR USER (NON-INSTANCE OWNER) ON UNIX
IY45665CONNECTNODE ATTRIBUTE SET IN APPLICATION SEEMS TO BE CACHED FOR SUBSEQUENT CONNECTIONS
IY45963JTA (XA) connection fails with SQL30090N rc=6 after application forced in DB2
JR16564MAPPING COLUMNS TAKES A LONG TIME IN THE COLUMN MAPPING PAGE
JR17331SPB IS RETURNING JAVA.LANG.NULLPOINTEREXCEPTION WHEN OPENING A PROJECT,IF TARGET HOST DB HAS SP REGISTERED WITH ROWID.
JR17597SPB USES THE -CF0 OPTION TO CREATE THE JAR FILE SENT TO OS/390. THIS PREVENTS COMPRESSION & LIMITS SIZE OF THE STORED PROCEDURE
JR17692REORGCHK OVERESTIMATES THE ISIZE
JR17799TABLESPACE LEFT IN RESTORE PENDING STATE ,AFTER RF TO EOLS.
JR17886CREATE SQL PROCEDURE FAILS WITH SQLSTATE 42904 WHEN DB2INSTPROF IS SET (DB2ICRT WITH -P OPTION), DB2UDP.DLL CANNOT BE LOADED
JR17913PROTECTING THE LOADING/UNLOADING OF DB2KBC.DLL WITH A LATCH TO MAKE IT THREAD SAFE.
JR17918SQLEXECUTE() FAILED WITH SQL0301 ERROR
JR17926ADDITIONAL CONNECTIONS BEING REFUSED AND GIVING THE MESSAGE :- NOT ENOUGH POST WAIT AREAS
JR17929INDEX KEYS MISORDERED DUE TO ERROR IN BINSORT
JR17932DB MAY CRASH W/ SEGMENTATION VIOLATION WHILE TRYING TO EVALUATE A STAR-JOIN QUERY ON SQLNO_STARJN_CHECK_JGRAP()
JR17936CONTROL CENTER DOES NOT DISPLAY CORRECT CONTRAINT
JR17940DWC NEEDS TO DELETE ORPHAN ATTRIBUTE LINKS DURING MIGRATION
JR17941PEM DLL CALLS WINCPICCLEANUP() WHICH CAUSES SEGV IN AGENT WHEN USING CONNECTION POOLING. (MS SNA FOR HOST COMMS. ONLY)
JR17955SCRIPT CENTER (WINDOWS) EXECUTES SECONDARY SUCCESS/FAILURE SCRIPTS BASED ON SUCCESS OF STARTING, NOT FINISHING, SCRIPT
JR17963IF CALL STATEMENT CONTAINS A LITERAL FOR THE INPUT INTEGER, CALLFAILS AS CANNOT LOAD LIBRARY
JR17968SQL ASSIST HANGS USING STORED PROCEDURE BUILDER WITH FIXPAK 8 ONWINDOWS PLATFORMS AND USING JDK 1.2.2
JR17987WHEN UPDATING AN SQL ASSIST GENERATED QUERY IN COMMAND CENTRE ERROR DBA2185E WITH SQLSTATE=42601 IS DISPLAYED
JR17990CLI0620E WHEN READING CLOB DATA
JR17992DB2SPB -20212 DURING JAVA EXECUTION FROM COPY/PASTE OP
JR18000THE '_' IN THE 'DB2MOVE -TN' CLAUSE IGNORES WHILE EXPORTING TABLES.
JR18026IF PATCH1=65536 IS SET, THE EXECUTION OF A SQL STATEMENT WITH SINGLE QUOTES IN THE LITERAL VALUE RETURNS SQL0104N
JR18032LOAD/IMPORT WE DO NOT TAKE INTO ACCOUNT THE NULL AT THE END OF THE DATA
JR18033SQL30020N RC=124C ON VERY LARGE CLOBS FROM OS/390 SERVER
JR18035DWC - GUI , WIP NOT SHOWING THE SAME TIMESTAMP AS THE SERVER....INSTEAD SHOWS LOCAL TIME, UNTIL LOCAL REFRESH IS DONE.
JR18058DWC - MIGRATION , CHANGES IN GROUP-BYS WHICH WERE NOT GENERATED BEFORE MIGRATION SHOWING UP DIFFERENTLY IN MIGRATED METADATA.
JR18076DB2EVMON ON OS/2 RETURNS SYS1808 - EXCEPTION C0000005 IN SQLOGMBLK
JR18086DWC- WHERE CLAUSE NOT CONVERTING WHEN MIGRATING FROM 5.2- 7.2 SQL INCLUDES THE WHERE CLAUSE ,CONDITION WINDOW DOES NOT
JR18089SP CALLED FROM CLI WITH CHAR LITERALS GETS PADDED WITH 0X00
JR18090-440 DURING IMPORT AGAINST CCSID 939 OS/390 DATABASE
JR18108ISSUE SELECT LOCATE(EXP1,CLOB,EXP3) FROM TABLE GET SQL0443N IF EXP3 >4000 WHICH SHOULD BE AVAILABLE FOR CLOBS BUT NOT VARCHAR
JR18111DB2SUPPORT TOOL NOT PARSING SPACE IN FOLDER NAME ON WINDOWS
JR18131CALL TO SP WITH OUT PARAMETERS USING IBMDADB2 DOES NOT SHOW SHOW OUTPUT IF FIRST OUT PARAMETER IS NULL.
JR18165CHAR SP RESULT SET COLUMNS ARE INCORRECTLY DESCRIBED IN CLI - PROBLEM WITH SQLDESCRIBECOLW
JR18178ROWCOUNT IS WRONG AFTER APPLICATION RUNS OUT OF APP_CTL_HEAP
JR18184DWC - 5.2 TO V7 MIGRATION IWH2REGI.EXE THAT WOULD DELETE THE RELATIONSHIP BETWEEN A MAP AND TARGET ATTRIBUTE ERRORENOUSLY.
JR18194DB2STOP ON WINDOWS TERMINATES DB2 LICENSE SERVER
JR18195SQL30090N RC=3 ON CALL TO SP ON 390. PROBLEM INTRODUCED IN FP8
JR18198TRAP IN IMPORT WITH LOBSINFILE USEDEFAULTS
JR18211THE CUST IS GETTING MEMORY ACCESS VIOLATION WHEN USING DB2 UDB XML EXTENDER. SQL1131N SQLSTATE=38503
JR18218SPECIAL CHARACTERS ARE NOT ALLOWED IN A SCHEMAN NAME WHEN USING THE EDITOR IN THE STORED PROCEDURE BUILDER.
JR18219STORED PROCEDURE BUILDER TRUNCATES A DECIMAL OUTPUT VARIABLE WHEN CALLING A Z/OS STORED PROCEDURE.
JR18221SQLTABLES RETURNS DIFFERENT RESULT SET IN FP8 THAN PRIOR FIX PACKS WHEN USING CLI KEYWORDS DBNAME AND SYSSCHEMA TOGETHER
JR18237DATE LOG ERROR
JR18244DWC CAN GENERATE SQL1226 AFTER ENOUGH MESSAGES ARE WRITTEN TO THE WIP.
JR18246JDBC RESULTSETMETADATA.GETCOLUMNCLASSNAME() RETURNS JAVA.LANG.SHORT BUT SHOULD RETURN JAVA.LANG.INTEGER OR NUMERIC FOR SMALLINT
JR18254DWC/SQLASSIST JOIN TAB PROBLEM A JOIN WAS DROPPED FROM VIEW ON TAB. SQL IS CORRECT
JR18255DWC COLUMN MAPPING PROBLEM , PROVIDE CORRELATION NAME FOR SOURCEAND TARGET WITHIN STEP
JR18256DWC VARIOUS SQLASSIST GROUPING PROBLEMS
JR18259CLI0111E ERROR USING IBMDADB2 WITH DECIMAL PARAMETERS.
JR18260SQLDESCRIBEPARAM FAILS ON CALL STATEMENT WITH NO IN/OUT PARMS
JR18262MQ_COMMIT CAUSES SQL0998N RC=222 IN FIX PACK 9 DUE TO MISMATCHEDCODE PAGES IN AN XA ENVIRONMENT WHEN USING UNICODE
JR18277DB2DCLGN DOES NOT ADD A NULL TERMINATOR (\0) PLACE HOLDER WHEN GENERATING STRUCTURES FOR C LANGUAGE
JR18279IF DB2 IS STARTED USING LANG=ZH_CN.HP15CN, WILL PRODUCE SQL4304N REASON CODE '5', WHEN RUNNING A JAVA STORED PROCEDURE.
JR18281DWC -JDK NEEDS FEATURES FROM JDK 8 TO IMPROVE SCROLLING AND MOVEMENT THROUGH DATA
JR18283DWC - CLIENTS ARE NOT SEEING EACH OTHERS UPDATES ON THE SERVER METADATA IN A TIMELY MANNER
JR18323DOING A PARTIAL COMPILE OF THE SIEBEL REPOSITORY TO A .SRF FILE RETURNS SQL0900N SQLSTATE 08003.
JR18332DWC/SQLASSIST COLUMN NEEDS SCROLLING MECHANISM FOR SELECTED COLUMNS
JR18346DWC - PUTTING PIECES OF PROCESS BACK TOGETHER AFTER BREAKING APART CAN RESULT IN LOSS OF SQL TO OLD AND NEW PROCESS
JR18351SQL STATEMENT MORE THAN 32K RETURNS -30020 DISTRIBUTED PROTOCOL ERROR OR SQL0101NERROR
JR18354THE CONTROL CENTER PERFORMANCE CONFIGURATION WIZARD CAN DISPLAY A CORRUPTED DBHEAP VALUE
JR18358SHARE LOCK HELD BY UR NO HOLD SCANNER
JR18367DWC - HEARTBEAT CHECKER FOR DWSERVER AND XTSERVER/STARTING XTSERVER AS A SERVICE.
JR18368CLI0119E WHEN UPDATING PARM MARKER WITH LOB WHEN PARM IS BOUND WITH INCORRECT DATATYPE RESULTING IN AN SQL0301N ERROR.
JR18374DWC - DATES SORT ALPHABETICALLY INSTEAD OF CHRONILOGICALLY
JR18385DWC/SQS ASSIST WHEN LINKING TWO LIKE NAME TABLES IN DWC, HANG CAUSED BY SQL ASSIST
JR18413IMPORT OF IXF WITH THE INSERT_UPDATE OPTION ON A TABLE CREATED WITH A PRIMARY KEY NAME 30 CHARS LENGTH FAILED WITH THE SQL3203N
JR18416DWC-EXPORT SHOULD EXPORT THE SELECT STATEMENT REGARDLESS OF THE AUTOGENSELECTSTMT FLAG. (MIGRATION)
JR18425STORED PROCEDURE BUILDER - BUILD FAILS - ERROR WHEN BUILDING AN SQL STORED PROCEDURE ON THE OS/390.
JR18429SQL1403 WHEN CONNECTING LOCALLY TO EEE WITHOUT USERID AND PASSWD
JR18437DWC -FROM VW 5.2 BV'S WHICH USED FLAT FILES, IN MIGRATED DWC VER. 7.2 STEPS, NO COLUMN NAMES ARE SHOWING.
JR18467OLE DB PROPERTIES NOT UPDATED WHEN A CONNECTION IS INVALIDATED DUE TO AN ERROR. (CLI0106, CLI0108)
JR18481DB2.EXE HANGS WHEN MORE THAN ONE DB2CMD.EXE STARTED CLOSELY
JR18531RECEIVED DWC07275 WITH RC2=7902 ON THE SCHEDULED STEP
JR18577DB2DIAG.LOG REPORTS "STATEMENT NOT PROTECTED" IN SQLRA_ROLLUP_DYN_STMT PROBE:20 AND/OR TRAP OCCURS IN SQLRA_CACHE_DEL_INV.
JR18603DWC XT SERVER FAILED DUE TO MEMORY LEAKS IN DDD, LOGGER AND SERVER.
JR18606REBUILD/ALTER OF SQL STORED PROCEDURE FAILING IN DEVELOPMENT CENTER
JR18643QUERY CRASHES THE INSTANCE WITH SIGNAL 11 WHILE MERGING OUTER JOIN.
LI70155LIKE CLAUSE WITH '%' FULL SELECT WILDCARD, PRODUCES POOR JOIN ORDER
LI70163FULL OUTER JOIN TREE, WITH FILTERING PREDICATE, CONVERTED TO LOJTREE, WITH FILTER AT THE TOP. ADD PUSHDOWN OF THE TOP JOIN.
LI70165DB2CLIFN.A LIBRARY CANNOT BE FOUND BY DB2 ON LINUX390
LI70203SIGNAL #11 TRAP IN SQLNR_LOCAL_OJPRD_PUSHDOWN WHEN DB2_ANTIJOIN=YES AND DOING AN INSERT WITH NOT EXIST SYNTAX
APAR fixes included in U486944 (Fixpak 9)
APARABSTRACT
GG04312DPROPR APPLY UNDER CONFLICT DETECTION SHOULD USE THE SAME PREDICATE AS IN THE WHOS_ON_FIRST = S FOR THE F DIRECTION
IC32230FOR QUERIES ON LOCAL VIEWS THAT CONTAIN NICKNAMES, FUNCTIONS CONTAINED IN A SELECT ON THE VIEW WILL NOT BE PUSHED DOWN
IC34477INCORRECT QUERY RESULT USING RELATIONAL OPERATORS
IC34926EXPORT SPATIAL DATA USING CONTROL CENTER IS NOT WORKING
IC35393UDB CHOOSES THE WRONG ACCESS PLAN FOR AN ORACLE VIEW AND UDB BASE TABLES
IY19806DB2DIAG.LOG FILLS WITH PROBE ID 1 WITH ERROR 2055 AND ALERT NUM 0 BY OPER_SYSTEM_SERVICES SQLO_ACCESS_LISTEN_QUEUE
IY28431DB2PS FOR EEE ON NUMAQ NOT SHOWING SOME PROCESSES
IY29709RETURNED DATA GETS TRUNCATED WHEN USING UNICODE(UCS-2/UTF-8).
IY30686INSTANCE CRASH WITH SIGNAL 11 IN SQM_EVMON
IY30874AUTOLOADER CORE RUNNING WITH AN ID NOT BELONGING TO THE INSTANCEOWNING THE DATABASE (REMOTE DB OR DB CATALOGUED VIA LOCAL NODE)
IY31091DB21036E ERROR ON V7.2 FP6 WHEN 'CALL' STORED PROCEDURE THAT HAS'_' UNDERSCORE IN THE SP'S SCHEMA NAME
IY31740WHEN 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
IY32689IN UNIX PLAIFORM, DB2CFIMP ENDS WITH NO ERROR WHILE IT DOESN'T IMPORT THE CONFIGURATION FILE.
IY32937FCM BUFFER SYNC-UP PROBLEM BETWEEN FCM DAEMON AND AGENTS.
IY33485SQL1629W WARNING MESSAGE FOR NON COORDINATING PARTITIONS WHEN R ESET MONITOR FOR <DB> GLOBAL IS RUN (EVEN PARTITIONS ACTIVE)
IY33866RESTORING LOAD COPY FAILES DURING ROLLFORWARD , WHEN DB ALIAS NAME IS DIFFERNT FROM DB NAME.
IY33881EXECUTEBATCH DOES NOT ADHERE TO JDBC SPECIFICATION
IY34182WHEN A COLUMN IS IN THE SELECT STATEMENT MORE THEN ONCE, AND THEN THE SAME COLUMN IS IN THE ORDER BY, DB2 WILL FAIL SQL0901
IY34253IN DB2/DATALINK/HACMP ENVIRONMENT, THE DLFMFSMD SCRIPT IS NOT ABLE TO HANDLE MULTIPLE LEVEL FILESYSTEM.
IY34262CLASS ID OF UDF CREATED IN JAVA CAN'T BE EXTRACTED WITH DB2LOOK DB2LOOK WAS USING THE IMPLEMENTATION COL. FOR THE ROUTINE NAME
IY34264SQL0313 WHEN TRYING TO IMPORT DATA USING INSERT_UPDATE WITH USEDEFAULTS.
IY34297DB2LOOK OUTPUT DOES NOT SHOW ALTER BUFFERPOOL COMMAND.
IY34394DB2ADUTL: FATAL: LIBTADSM.A: OPEN FAILED: NO SUCH FILE OR DIRECTORY : FOR 64BIT VERSION ONLY
IY34457UNRETRIEVED ERROR MESSAGE='SQLSTATE 01503: THE NUMBER OF RESULT COLUMNS IS LARGER THAN THE NUMBER OF HOST VARIABLES PROVIDED.'
IY34460SIGNAL HANDLER CAUSED MEMORY CORRUPTION IN AGENT PRIVATE MEMORY.AGENT WAS DOING A MALLOC WHEN SIGNAL WAS RECEIVED BY THE PID.
IY34527CLI0125 WHEN COMMIT OCCURS ON A STATEMENT WITH NO RESULTSETS
IY34529JAVA EXCEPTION OCCURS WHEN THE BROWSE BUTTON IN PRESSED IN CC.
IY34567QUERY PERFORMANCE FROM PUSHDOWN INNER JOIN THROUGH OUTER JOIN
IY34615USEREXIT PROGRAM DOES NOT ARCHIVE LOGS FROM THE SECONDARY LOG PATH IF THE PRIMARY LOG PATH BECOMES UNAVAILABLE.
IY34660IMPORT TABLE ENDS WITH SQL0604N - TYPE MAPPING 'CHAR(255)' IS NOT VALID
IY34833CLI0143E WHEN DESCRIBING CHAR AGAINST DB2/AS400
IY34871SQL0901N IN SQLNO_CRULE_JOIN WHEN RUNNING A STAR-CARTESIAN JOIN QUERY.
IY34909SQL0405N OCCURS WHEN SQL STATEMENT IS RUN USING STATEMENTCACHE
IY34929CLI0002W WHEN SELECT '' AS COLNAME FROM TABLE. IN TESTING CODEPAGE=819 AND APPLICATION WAS VB CONNECTED THROUGH OLEDB.
IY34942REMOTE IMPORT WITH IXF FILES
IY34944DATABASE IS BEING MARKED BAD WHEN COMMIT/ROLLBACK XA TRANSACTIONWITH USER TEMP TABLE DECLARED.
IY34963DB2SYNC ABENDS WHEN OVER 11 SUCCESSFUL SQLCODES ARE SPECIFIED IN SCRIPT.INF FILE.
IY35003FFFF FC7F FROM FCM CODE IN DB2DIAG.LOG RESULTING IN -902 AND A DATABASE CRASH
IY35055DIA4804E DUMP AS A RESULT OF TOKEN BUFFER OVERFLOW
IY35175CRASH WHEN LOADING INTO TABLE WITH GENERATED COLUMN(S) USING GENERATEDMISSING MODIFIER.
IY35200REORGCHK DOES NOT DISPLAY ALL THE TABLE. PROBLEM IS WITH NICKNAMES DEFINED IN SYSIBM.SYSTABLE
IY35289THE OPTIMIZER MIGHT NOT CHOOSE THE INDICES OR AN OPTIMAL JOIN ORDER FOR A JOIN INVOLVED IN A COMPLEX OR PREDICATE.
IY35303COMPLEX SUBQUERY ELEMENT NOT BEING PUSHED DOWN THROUGH UNION ALL. THIS INCLUDES FUNCTIONS, COMPLEX QGM ELEMENTS
IY35402WHEN ACCESSING ORACLE DB THROUGH FEDERATED SERVER, THE CHINESE CHARS ARE DISPLAYED AS '?????'
IY35406-204 USING CONNECTION CONCENTRATOR. CURRENT SQLID NOT SET CORRECTLY.
IY35471FORCE APPLICATION ON FEDERATED CONNECTION CAUSE TRAP AT SQLOFMBLKEX ON FEDERATED SERVER
IY35560RELATIONAL SCAN IS USED WHEN INDEXES SHOULD BE IN A JOIN/CORREL ATION QUERY
IY35577DB2LOOK IS MISSING 'DROPPED TABLE RECOVERY ON' CLAUSE
IY35665RANDOM FAILOVER COULD OCCUR WHEN DB2 PROCESSES NUMBER ARE MULTIPLE OF 256 DUE TO A KSH LEGACY
IY35743SQL4304 CLASS NOT FOUND AFTER LOADING JAVA UDFS > 4500 TIMES
IY35788EQUALITY PREDICATE WITH LITERAL VALUE GOES TO WRONG INDEX
IY35796SIGSEGV IN SQLM_FIND_ELEMENT() DURING GLOBAL SNAPSHOT ON BUSY MULTI-PARTITION INSTANCE
IY35855SQL QUERY GETS SQL0901N RC 0 IN SQLNO_SMP_CREATE_SHARED_SO() PROBE 200 WHEN INTRAPARALLEL IS ON.
IY35901APPLY REPORTS SQL1403N WHEN IT SHOULD REPORT SQL1040N.
IY35917MINMEM=ON CAUSES CLI0002 ERROR IN SIEBEL APPLICATION. PROBLEM WITH BUFFERS NOT BEING FLUSHED PROPERLY.
IY35935DB2 CRASH WHEN IMPORTING LARGE NUMBER OF XML RECORDS INTO A DATABASE WHICH IS XML ENABLED.
IY35942AFTER RUN UPDATE STATISTICS ON THE TABLE THE QUERY RETURNS COLUMN NUMBERS INSTEAD OF NAMES.
IY35962LONG SPS CAUSE SPB TO HANG.
IY35971MISHANDLING OF ERROR CODES AND RECOVERY OF SQL3799W WHEN DOING LOAD RECOVERY THAT CANNOT FIND THE LOAD COPY FILE.
IY35991SIGFPE IN SQLNO_HSJN_SIZE_INFO DUE TO BUG IN SQLNO_HSJN_REC_SIZEWHICH RESULTS IN AVG_REC_SIZE VALUE LESS THAN 0
IY35994SEGV WITH XA ON SQLCLOSECURSOR WITH REMOTE DATABASE.
IY35997DATABASE BACKUP RETURNS SQL1042C AND THE INSTANCE CRASHES WITH SIGNAL 11 IN SQLODSHR()
IY36061SQL0429 MAX. NUMBER OF LOB LOCATORS EXCEEDED IN PEOPLESOFT APP
IY36073INSTANCE CRASHES BECAUSE WE HIT SQLKF_CONNECT_REQ PROBE 50.
IY36114EXPORT OF TABLES WITH LOBS MAY FAIL WITH SQL3040,RC=6.
IY36148TO ADDRESS ISSUE TO PREVENT POSSIBLE TRAPS DURING FETCHING
IY36276IMPORT USING INSERT_UPDATE RETURNS SQL0100W WHEN IMPORT DATA CONTAINS NULL VALUES FOR NOT NULL COL. - SHOULD RETURN SQL3116W
IY36282WITH KEEPDARI=YES, DB2DARI PROCESSES ARE NOT CLEARLY IDENTIFIED AS IDLE VS. ACTIVE WHEN A PROCESS LISTING IS TAKEN.
IY36295PARAMETERIZED QUERY IN PASSTHRU CAUSES SEGV AND ENGINE CORE
IY36323RESULT SET ALL 0'S WHEN SELECT IS DONE FROM SAS USING PASSTHRU
IY36468ADDING AN EMAIL ADDRESS TO QUERY PATROLLER WITHOUT RESTATING IT MIGHT SEND E-MAIL TO USER ID INSTEAD.
IY36611THE UNBOUND COLUMN CASES A CORE DUMP. BECAUSE OF THAT PEOPLESOFTTRAPS. THE FIX FOR APAR#IY29709 CAUSES ALL THESE.
IY36627THREADS CONNECTIONS NOT FREED PROPERLY FROM A JAVA PROGRAM
IY36717APPEND COSTING FACTOR IN REWRITE FOR INLIST TO JOIN TRANSFORMS WITH MULTIPLE INLISTS
IY36783DB2 UTILITIES CAUSE SEGMENTATION FAULT WHEN PASSED LONG STRING
IY36794AUTOMATIC INCREMENTAL RESTORE FAILS WITH SQL2571 RC=3 WHEN TABLESPACE NAME IS OF MAX LENGTH
IY36850BAD PLAN ON SELF TABLE JOIN, WHERE CARDINALITY ON TWO OR MORE JOIN PREDICATES IS UNDER ESTIMATED.
IY36993DB2 CONNECT SYSPLEX EXPLOITATION FAILOVER NOT WORKING CORRECTLY WITH SNA CONNECTIONS.
IY37020TRANSFORMING A SELF REFERENCING SUB-QUERY INTO A SELF REFERENCING JOIN (REQUIRES A TEMP TABLE)
IY37028PERFORMANCE PROBLEM WITH LOCAL IPC CONNECTIONS TO HOST WHEN CONCENTRATOR IS ENABLED.
IY37087INSUFFICIENT SPACE FOR RESIZE TABLESPACE OPERATION CAN CAUSE DB2 TO CRASH
IY37222SIGNAL #11 TRAP IN STRCMP() WHEN CALLED BY SQLBGETQUIESCESTATE()FROM PREFETCHER CODE.
IY37238IN REPLICA SCENARIO, CAPTURE FORGETS FOREIGN UPDATES
IY37241ENGINE TRIES TO PLACE A TABLE LEVEL S LOCK ON SYSTABLES WHILE DOING 'ALTER TABLE NOT LOGGED INITIALLY WITH EMPTY TABLE'
IY37265INCORRECT RESULTS WHEN USING LIKE PREDICATE ON DBCS DATABASE WHEN TWO CHARACTERS HAVE SAME SECOND BYTE.
IY37284SQLPGETDBMONLOG REPORTS NUMBER EXTENTS HELD BY BUFFER IS GREATERTHAN EXTENTS USED IN DB2DIAG.LOG
IY37292DB2LOOK - CREATE VIEW OUTPUT DOES NOT INCLUDE THE SCHEMA INFORMATION
IY37323DATA IS INCORRECT IN A TARGET TABLE AFTER A FIXED CHAR OR GRAPHIC COLUMN IS ALTER ADDED TO A SOURCE TABLE.
IY37357FILE SHARING VIOLATION ERRORS CAUSE DATABASE CRASH
IY37513DB2CKRST MAY GIVE WRONG RESTORE SEQUENCE WITH DATABASE OPTION
IY37531IMPORT USING COMMITCOUNT OPTION DOES NOT RELEASE S LOCKS ON SYSCAT.COLUMNS TABLE ON COMPLETION
IY37535DB2MOVE <DB_NAME> EXPORT -TN <TB_NAME> DOES NOT EXPORT DATA WHENTHE TABLE NAME CONSISTS OF MULTI-BYTE CHARACTERS
IY37548CASE CLAUSE WITH EMPTY STRING IN DML GETS DIFFERENT RESULTS FROMDB2 V6 AND DB2 V7 WITH SQL0180 ERROR.
IY37568SQL0902C, RC=2 WHILE EXTENDING OR RESIZING CONTAINERS
IY37701POSSIBLE TRAP WHEN RUNING STORED PROCEDURE WITH A EUC RESULTSET
IY37702'SET WRITE' FAILS WITH -804 RC=106 IF DB2CHKPTR REGISTRY IS SET.
IY37717WHEN USING NICKNAMES FOR LARGE SYBASE TABLES, POOR PERFORMANCE OR ERRORS ARE ENCOUNTERED.
IY37739MEMORY LEAK IN SQLESINS() API WHEN SWITCHING INSTANCES.
IY37745ORPHANED DB2AGENT PROCESSES STILL PROCESSING AND HOLDING LOCKS AND RESOURCES LONG AFTER THE ASSOCIATED APP IS KILLED
IY37755XML EXTENDER: SQL ERROR MSG NOT DISPLAYED WHEN DXXDISABLEDB FAILS
IY37793FIX TO CONTROL TRANSITIVE PREDICATES AND HANDLE SELF JOINS
IY37834IMPROVED PREDICATE PUSHDOWN THROUGH FOJ
IY37855TWO STORED PROCEDURES ON OS/390, IDENTICAL NAME EXCEPT ONE HAS '_' IN NAME, CALL FROM CLP RETURN CLI0150E. UNDERSCORE=0 SET.
IY37856WHEN SHREDDING SHIFT-JIS DOCUMENT INTO UTF8 DATABASE, NOT ALL DATA ARE INSERTED INTO TABLES.
IY37892THE SELECTIVITY CALCULATION FOR OR PREDICATE IS INCORRECT
IY37956DB2ADVIS SETS INVALID TIME FOR STATS_TIME FOR NEW INDEX
IY37993BACKUP TO TSM MAY FALSELY RETURN SUCCESS WHEN TAPE STORAGE IS FULL
IY38003WEBSPHERE ADMIN CLIENT HANGS WHEN USING CLIENT AUTHENTICATION.
IY38013'\' (BACKSLASH) CHARACTER IN SQL STORED PROC DEFAULT STRING RESULTS IN INCORRECT OUTPUT, EXTRA X'00' CHARACTERS
IY38030DB2 MUST AUTHENTICATE EITHER LOCAL LOGIN OR SU ACCESS AT A MINIMUM
IY38038CRASH IN SQLBUFIX WHEN WE ATTEMPT TO UNFIX A PAGE THAT IS NOT FIXED.
IY38052INDEX MANAGER PROGRAMMING ERROR FFFFF954 DURING RUNTIME WITH SQLIREMVIOL PROBE:1/PROBE:2
IY38164LOG FILE TRUNCATED AFTER ROLLFORWARD - LOG INCLUDES DUPLICATE TRANSACTION ENTRY FOR INSERT
IY38229EXECUTING SQLPROCEDURECOLUMNS AGAINST A STORED PROCEDURE RETURN WRONG DATATYPE AND LENGTH
IY38257STACK VARIABLE OVERWRITE IN SQLOCSEMP FUNCTION
IY38286INSTANCE CRASH WITH SIGNAL 11 IN SQLBFLUSHFORDLSUBSET
IY38287CLI0119E WHEN RUNNING MUTLI-THREAD JAVA APPLICATION ON AIX
IY38297SQL0973 OUT OF DBHEAP , PACKAGE CACHE , SQL2009 OUT OF UTILITY HEAP MAY BE CAUSED BY TOO MUCH OVERHEAD FROM PACKAGE CACHE
IY38333MESSAGE QUEUE IS LEFT BEHIND AND NEVER GET CLEANED UP UNTIL THE SYSTEM CLEANED IT UP
IY38427CREATE A NICKNAME WITHOUT ANY COLUMNS AND DB2 SERVER SHUTS DOWN.
IY38480HANG IN FCM LAYER CAUSES DEADLOCK
IY38525CHANGING PASSWORD IN CCA RETURNS SQL30083N RC=24.
IY38537SQL0000W RETURN WHEN SQLMORERESULTS WITH SQL_NO_DATA_FOUND IS CALLED AFTER CALLING STORED PROCEDURE
IY38544UNICODE CHARACTERS INSERTED INTO UNICODE DATABASE THROUGH XA CONNECTIONS ARE INCORRECT DUE TO CODEPAGE CONVERSION PROBLEM
IY38550SQL0880N WHEN TRYING TO INSERT RECORDS INTO A TABLE
IY38567IN DB2LOOK COMMAND IF THE OUTPUT FILENAME USED IS EQUAL TO OR MORE THAT 32 BYTE(WITH EXTENSION), THE OUTPUT FILENAME CHANGED.
IY38572TRAP WHILE COMPILING A QUERY. SEGV IN SQLNR_REORDER_IJ_QGM()
IY38592DB2LOOK -F EXTRACTS WRONG BUFFPAGE VALUE
IY38643RETURN VALUE FROM STORED PROCEDURE MIGHT BE OVERWRITTEN, IF CURSORS ARE STILL OPEN
IY38663PERFORMING AN UPDATE WITH A SPECIFIC TRIGGER WILL TRAP IN SQLNS_ADD_CORRELATION.
IY38727DEFAULT LENGTH OF LONGRAPHICS DATATYPE IN THE PRECOMPILER IS INCOMPATIBLE WITH DB2/390
IY38738DB2 INSTANCE CRASHES WITH SIGSEGV IN SQLRA_FP_COPY AFTER DATABASE IS MARKED BAD.
IY38739THE OWNER OF THE SEQUENCE IS WRONGFULLY SET TO THE CURRENT SCHEMA.
IY38772AST MATCHING IMPROVEMENTS
IY38803NULLPOINTEREXCEPTION IN DB2STATEMENT.EXECUTE2 IF USING SCROLL_INSENSITIVE CURSOR ON DELETE FROM EMPTY TABLE
IY38846ALLOW SQL0478 TO RETURN THE ACTUAL DEPENDENCIES OF A TABLE OR FUNCTION
IY38853CRASH RECOVERY FAILED WITH BUFFER POOL LOGIC ERROR SQLBREDOUPDATEEMP ON EMP OF LOB OBJECT
IY38859NET DRIVER SENDS WRONG LENGTH TO HOST FOR VARCHAR EXCEEDING 8K
IY38874REPLICATION TERMINATES WHEN SQLCODE=0, LOGBYTESWRITTEN=0'
IY38883DB2DART CAN'T RECOGNIZE GRAPHIC/VARGRAPHIC DATA TYPE
IY38888JDBC NET DRIVER, SUBSEQUENT REBIND AND EXECUTE OF STATEMENT RETURNS SAME # OF ROWS AS FIRST EXECUTE. LAST ROW REPEATED.
IY38895DXXGENXML END ABNORMALLY WHEN IT RECEIVES AN SQL WARNING
IY38938FFFF876D FROM SQLRL_USERTEMPRELEASEFIDTIDIN THE DB2DIAG.LOG
IY38940DURING ROLLFORWARD ON AN INDEX THAT IS DMS AND PARTIAL, WE COULDNON-EXISTENT PAGE 0 AND CAUSING THE ROLLFORWARD TO FAIL.
IY39036QUERY REWRITE CHANGES FOR UNION ALL AND GROUP BY QUERIES
IY39075ENSURE THAT SUFFICIENT DISK SPACE IS RESERVED FOR OBJECTS BEING REORGANIZED WHEN MULTI-PAGE FILE ALLOCATION IS ENBABLED.
IY39193ADDITIONAL DEBUG CODE ADDED TO DIAGNOSE A PROBLEM WITH POTENTIALSOCKET CONNECT LOGIC ERROR IN THE AUTOLOADER
IY39199LEFT OUTER JOIN WITH ORDER BY CLAUSE CRASHES INSTANCE.
IY39203MINBUFFLSN GETTING INCREMENTED DURING CRASH RECOVERY DUE TO A POTENTIAL TIMING PROBLEM
IY39220ALLOW INSERT, UPDATE AND DELETE OPERATIONS INTO LOCAL PARTITIONED TABLES IN THE PRESENCE OF FEDERATED NICKNAMES.
IY39226INITIAL CORRUPTED RECORD HEADER COULD POTENTIALLY CAUSE FURTHER CORRUPTION WITHIN THE DATABASE
IY39243RECREATE THE GOVERNOR LOG FILE IF IT HAS BEEN DELETED.
IY39385DATABASE ROLLFORWARD FAILED WITH FFFFF529 (INVALID LSN) DURING THE UNDO PHASE
IY39391CALL TO SQLDRIVERCONNECT CAUSES CORE IN STRLEN(), CALLED FROM CLI_UTLINITCONNECTACCTINFO
IY39392FORCE A FUNCTION TEMPLATE IN SELECT LIST TO PUSHDOWN TO THE REMOTE DATA SOURCE FOR FEDERATED QUERIES.
IY39411CRASH CAN OCCUR IN CLI SQLEXECUTE FUNCTION IF CONNECTION TO SERVER BROKEN AND PRECONDITIONS MET
IY39448CORRECT SUPPORT FOR THE FOLD_ID AND FOLD_PW SERVER OPTIONS IN DRDA WRAPPER.
IY39449CREATING INDEXES WITH NLS COLLATION USING THAI CODE SET TIS620-1 MAY CAUSE INDEX KEYS TO BE OUT OF ORDER.
IY39505INSTANCE CRASH WHEN SMS TEMPSPACE FILLS UP IN V72 FP8.
IY39509JAVA SP SHOULD RETURN -4302 ON UNHANDLED EXCEPTION
IY39516IF QUERY HAS A DISTINCT AND OUTER JOINS, THE DISTINCT MAY NOT BEENFORCED AFTER OUTER JOIN REORDERING - MAY GET WRONG RESULTS.
IY39618A QUERY WITH A LEFT OUTTER JOIN INVOLVEING NICKNAMES TO AN ORACLE DATASOURCE RETURNS A SQL0206N
IY39654PERFORMANCE PROBLEM WITH FEDERATED QUERIES
IY39669DB2 INSTANCE CRASHES ON CONNECT. CAUSE IS TRAP IN SQLPINIT WHENCRASH RECOVERY NEEDS TO BE PERFORMED IN A LARGE CONFIGURATION.
IY39729DB2 CLI PACKAGES ARE NOT MODIFIED, EVEN WHEN EXPLICITLY REBOUND FROM CLP
IY39733ALLO WPARALLELIZE UPDATE TRIGGER HANDLING IN EEE SO UPDATE CAN BE MADE ON A SPECIFIC TABLE/PARTITION EVEN IF OTHER DPS ARE DOWN.
IY39737EXPORT STATEMENT WITH GREATER THAN 32K SELECT RETURNS ERROR.
IY39743ALLOW ACCESS TO TABLESPACE IN BACKUP PENDING STATE DURING LOAD PHASE DELETE PHASE,EVEN IF TABLESPACE IS NOT IN DELETE PENDING
IY39769A SELECT TO ORACLE USING SQLNET WRAPPER WITH A LENGTH LONGER THAT 2000 CHARACTERS RECEIVES A SQL0901N
IY39775POOR PERFORMANCE MIGHT RESULT WHEN USING NESTED OUTER JOINS ON ORACLE DATA SOURCE.
IY40016ALLOWS OUTER JOIN PREDICATES TO BE PUSHED DOWN TO THE REMOTE DATA SOURCE
IY40022DATABASE MARKED BAD IN SQLPXREG PROBE:50 , RETURNED RC=F51D
IY40053-204 WHEN USING PEOPLESOFT AND CONNECTION CONCENTRATOR IN A DB2 CONNECT ENVIRONMENT.
IY40115SQL0171N OR SQL0413N MAY OCCUR WHEN CALLING A STORED PROCEDURE WITH A DATE OUTPUT PARAMETER FROM EMBEDDED SQL COBOL APPLICATION
IY40161RUNNING A COMPLEX QUERY WITH ABSTRACT DATA TYPES CRASHES THE DB2INSTANCE.
IY40269ALTER TABLE ADD GENERATED COLUMN TRAPS WHEN SET INTEGRITY IS FOLLOWED
IY40271CRASH RECOVERY FAILS DUE TO A BAD LOG AND THE DB2DIAG.LOG DUMPS THE WRONG LOG NUMBER AS THE PROBLEM LOG.
IY40277DPROPR APPLY AND ASNLOAD HAVE PROBLEMS WHEN ASNPATH IS SET ON UNIX PLATFORMS.
IY40304ERROR SQL0301N/SQLSTATE 01517 WHEN INSERTING WITH MINMEM MODE.
IY40318TRAP WHEN UPDATING BASE TABLE FOR A SUMMARY TABLE DEFINED AS REPLICATED AND REFRESH IMMEDIATE
IY40426SIGNAL #11 CRASH SEGMENTATION FAULT ON FEDERATED ENVIRONMENT USING DRDA IN FUNCTION SQLE_CHECK_EARLY_FETCH
IY40725Incorrect query results . Select with "OR" tree. When BETWEEN predicate is not in the same query block as the ISNULL predicate
IY41090SEGMENTATION VIOLATION IN SQLE_CHECK_EARLY_FETCH. VULNERABILITY DUE TO USE OF PASSTHRU BLOCK FETCH SUPPORT ON FEDERATED.
IY41461TRAP IN SQLNO FUNCTION DUE TO CORRUPT HISTOGRAM STATISTICS.
IY41462POTENTIAL DEFUNCT DB2GOV CHILD PROCESSES
IY41493SQL_ATTR_PRESERVE_LOCALE IS NOT EFFECTIVE IN AN ODBC ENVIRONMENT
IY41508JAVA SP GET ERROR SQL4304 ON MULIPLE PHYSICAL NODES EEE INSTANCE THAT IS PARTIALLY FIXED IN APAR IY29438.
IY41604DB2 RESTORE of image split across multiple files may fail with SQL2054N - corrupt image . The image may not be corrupt.
JR04885SQL0502N HAPPENS WITH OUTER JOIN IN EXCEL
JR16561SQL BUILDER ALWAYS PUTS TEH COLUMN AT THE BOTTOM
JR17083DDD NOT DELETING RELATION ENTRY WHEN A STEP IS DELETED
JR17216DBA1117 THE VALUE FOR NUM_INITAGENTS IS NOT VALID WHILE ENTERING0.
JR17220RUNSTATS SHOULD NOT BE A VALID LIST HISTORY OPTION
JR17302FP9, V8: MISSING AUTOLOADER.CFG FROM LINUX EEE
JR17305CCA3000C RC=19 IN CCAUNCATALOGDB DURING IMPORT (CCA OR DB2CFIMP)
JR17375CC/390: CLI0125E ( HY010 ) ON VIEW OF SAMPLE CONTENS OF THE TABLE WHEN CURSORHOLD=0 IN DB2CLI.INI
JR17422DURING IXF IMPORT THE PRIMARY KEY IS NOT CREATED EVEN THOUGH IT IS DEFINED IN TABLE BEING EXPORTED
JR17454IN THE TOOLS SETTINGS FOR COMMAND CENTER IF YOU CHECK TERMINATIOCHARACTER SETTING W/ THE BOX BLANK TOOLS SETTINGS WON'T WORK.
JR17457CONTROL CENTER REMOVES SECURITY SOCKS OPTION FROM THE CATALOG ENTRY FOR NODES THAT IT ACCESSES
JR17461. EXPORT AND IMPORT NOT WKING PROPERLY THRU CCENTRE -CODEPAGE 943
JR17464BATCHUPDATEEXCEPTION RECEIVED WHEN A BATCHED UPDATE GETS BACK SQL_NO_DATA_FOUND
JR17472DGWEXT EXTRACT PROGRAM FAILED TO EXTRACT TABLE IF TABLE NAME > 18 CHAR
JR17473IMAGE COPY USING TEMPLATES WITH STACK OPTION IN CC RETURNS DSNUTILS: CC0917135814 EXECUTION FAILED. RETURN CODE: 8.
JR17474SQLPROCEDURECOLUMNS RETURNS INCORRECT VALUE OF COLUMN_SIZE AND BUFFER_LENGTH FOR GRAPHIC TYPE PARAMETERS.
JR17480CODEPAGE CONVERSION TABLES ADDED TO 7.1, MISSING FROM 7.1/7.2 BUILDS
JR17484CC SUBMITS INCORRECT SCRIPT FOR ONLINE BACKUP RESTORE REDIRECT.
JR17488EUR DATE DISPLAYED AS ISO IN CONTROL CENTER, COMMAND CENTER
JR17490MEMORY LEAK IN DATABASE MONITOR HEAP WHEN HANDLING SQLESETI. ERROR 0XFFFFD621 MAY BE REPORTED IN SQLE_ADD_SETINFO_FIELD
JR17501WRONG RESULTS RETURNED AS OPTIMIZER ELIMINATES PREDICATES OF CORRELATED SUBQUERIES
JR17504DB2COUNTRY IGNORES DECIMAL SEPARATOR CHANGE
JR17509SHRED OF TIMESTAMP VALUE FAILS IF TRAILING MICRO SECONDS ARE MISSING. FAILING SQLCODE IS SQL0723N
JR17510DWM-DDD,ERROR DURING GENERATION OF INSERT STATEMENT, WHILE FETCHING METADATA OBJECTS FOR TARGET, ERROR NOT SURFACEDD
JR17518TRAP WITH EXCEPTION C0000005 OCCURRED IN SQLOFMBLKEX CALLED BY BIDITRANSFORM, ON WINDOWS
JR17519SQLPGWLP PROBE:905 FIRSTLSN SET TO 0
JR17521IN COMMAND CENTER, CHOOSE 'SCRIPT'->'IMPORT' AND GET SQL1403N.
JR17523SQL0301 RETURNED WITH MSACCESS
JR17525DB CRASHES WITH SQL0902 B/C WRONG TEMP TBSPC IS USED BY THE OPTIMZER.
JR17543AFTER MIGRATING FROM V5.2, BV DEMOTED TO TEST, NO LONGER WORK.
JR17549GETEXPORTEDKEYS() CAUSES JVM TO CRASH WHEN RUNNING AGAINST DB2/390
JR17554NULL NOT HANDLED CORRECTLY IN AGGREGATE FUNCTIONS WITHIN OLAP (OVER/PARTITION BY) FUNCTION.
JR17555XML EXTENDER ESCAPING ENTITY CHARACTERS WITHIN A CDATA SECTION.
JR17558DATA WAREHOUSE WHEN USING SQL ASSIST TO USE JOINS. THE JOIN COMES OUTT WRONG. WHEN JOINING MORE THEN 3 TABLES.
JR17563TRAP IN SQLPRECLAIMLOGSPACEANDFLUSHBUFFERS (RECEIVED SIGNAL #5)
JR17569TRIGGER COMPILATION RESULTS IN SQL0101N DUE TO INFINITE LOOP
JR17574UNABLE TO ADD NOTIFICATION TO A STEP WITH A LONG NAME
JR17585UPDATE AND DELETE USING WHERE CURRENT OF <CURSORNAME> CANNOT HANDLE MORE THAN 1 'WHERE' IN THE SQL STATEMENT
JR17586DWC -ACTIONS PROHIBITED BY DWC SECURITY FROM PROCESS WINDOWS ARE AVAILABLE AND OPERATIONAL FROM WIP.
JR17602DB2LOOK OUTPUT DOES NOT INCLUDE THE COMMENT INFORMATION FOR TABLE COLUMNS - INPUT VIA THE COMMENT ON CLAUSE FOR EACH COLUMN.
JR17603DWC MIGRATION WILL DELETE THE RELATIONSHIP IF THE IWHID FOR THE MAP DOES NOT EXIST ANYMORE.
JR17617CLI0002W DOING QUERIES WHEN MINMEM ENABLED
JR17624SELECT WITH LIKE CLAUSE ON LOB FIELD CAN CRASH SERVER
JR17625WINDOWS DRIVE MAPPING NOT FUNCTIONING (DB2DRVMP) IN MSCS ENVIRONMENT.
JR17626WARNING -437 ON CURSOR OPEN IS SAVED ON ERROR LIST WHEN USING KEYSET CURSOR AND CAUSES CLI0125 DURING A FETCH
JR17630DISTINCT NOT PUSHED DOWN WHEN USING A NICKNAME
JR17638WHEN THE PARSER FINDS THE TWO DECIMALS, IT INSERTS A CAST FUNCIT. THIS CAUSES A SEGMENTATION FAULT.
JR17639PASSING VARGRAPHIC(TYPE NULL) OR VARGRAPHIC(3500 MAX VALUE OF VARGRAPHIC) TO A SQL STORED PROCEDURE CAUSES SQL1042C.
JR17645SELECT COUNT(*) FROM TABLEA WHERE COLUMNA IN('','S') RETURN DIFFERENT RESULTS FROM DATABASES WITH CODESET TIS620-1.
JR17646DWM V7 FP7 - NOTIFICATION DEFAULT MSG FOR E-MAILS IF STEP HAS NOSOURCE NOTIFICATION PROCESS FAILS
JR17648DWC KERNEL MAY GENERATE DUPLICATED IDS FOR EDITION NUMBER.
JR17649CURRENTPACKAGESET SETTING IN DB2CLI.INI IS TRUNCATED TO 8 CHARACTERES
JR17653UPM NEW MODE - APPLICATION LOGON ALLOW CROSS PROCESS/SAME SESSION USERID RETRIEVAL.
JR17654IMPORT CASTS A VARCHAR > 255 TO LONG VARCHAR. THIS GENERATES -97ERROR WHEN IMPORTING FROM UDB TO OS/390.
JR17665\R & \N CHARS IN /ETC/SERVICES FILE CAUSE W2K INSTALL TO ABEND
JR17669A LAN FREE RESTORE USING TSM ON NT WILL FAIL WITH SQL2062RC 109
JR17676SORTING SMALL VARIABLE SIZED DATA IN A NULLABLE COLUMN MAY BE COMPUTED INCORRECTLY
JR17678DSNL032I DSNLIRTR DRDA EXCEPTION CONDITION RC00D3101B, ABEND DSNV086E REASON=00E50702 DUE TO DB2 CONNECT RQSCRR PROTOCOL ERR
JR17681CANNOT SEE THE SPATIAL EXTENDER MENUS WHEN CONNECTING TO A DB2 AIX 7.2 FP4 DB FROM THE CONTROL CENTER
JR17686FAULT IN HOSTNAME-IP MAPPING MAY LEAD TO INCORRECT ADDRESS RESOLUTION WHEN AN ADAPTER HAS MULTIPLE ADDRESSES ASSOCIATED WITH IT.
JR17687MEMORY LEAK IN DB2 CONNECT CONNECTED TO DB2/390 WHEN DB2BIDI REGISTRY VARIABLE IS SET.
JR17690AFTER DISPLAYING ONE ENTRY IN AN APPLICATION SNAPSHOT, THE CLP ABORTS OR HANGS. OUT-OF-RESOURCE CONDITIONS MAY OCCUR ON LINUX.
JR17693DWC-MONTHLY SCHEDULING- W/ CERTAIN START DATES , SUBSEQUENT RUNSARE SCHEDULED INCORRECTLY
JR17694INCORRECTY PROCESSING THE RESULT-SET FOR AN SP, AND HANDLING IT AS A LOB WHEN THE PREVIOUS SP RESULT-SET WAS A LOB.
JR17696USING THE NET DRIVER, REBIND NOT OCCURRING WHEN SCALES OF DECIMAL PARAMETER MARKER VALUES CHANGE.
JR17700DB2 CRASHES IF SYSIBM.SYSTABAUTH.REF_BY_COLS IS REFERENCED IN VIEW.
JR17701INCORRECT RESULTS FROM A QUERY WITH INTERSECT WHEN SEARCHING FORNULL ARGUMENTS WITH CHECK CONSTRAINT DEFINED
JR17710DWC XT SERVER FAILED DUE TO MEMORY LEAKS IN DDD, LOGGER AND SERVER.
JR17743DWC EXPORT -EMAIL NOTIFICATIONS FROM MULTIPLE PROCESSES
JR17746DWC: EXPORT UTILITY EXPORTS MORE METADATA THAN IT SHOULD.
JR17747DWC TABLESPACE AND INDEX TABLESPACE: IMPORT AND EXPORT INCORRECT WITH TAG IMPORT AND EXPORT
JR17755USING THE IBM DB2 OLE DB PROVIDER, A USER WHO DOES NOT HAVE INSERT AUTHORITY ON A TABLE SHOULD RECEIVE AN SQL0551N.
JR17760INCORRECT MESSAGE OR SEGMENTATION FAULT WHEN SPECIFYING AN OUTFILE > 80 CHARS WITH DB2EXFMT.
JR17771CLI COMMAND SQLSETPOS HANGS.
JR17775CLI0129E OCCURS BECAUSE SQLFREECONNECT() RETURNS AN SQL ERROR
JR17778CLI PACKAGES REBOUND EVEN WHEN THE PACKAGE EXISTS ON OS390 SERVER (CAN LEAD TO LOCK PROBLEM WHEN CLIENT DOES BIND)
JR17784WHEN UPGRADING TO FP8 RUNNING BIND OF DB2CLI.LST, DB2SCHEM.BND MISSING
JR17788BYTE REVERSAL WITH ARRAY INPUT AND SQL_WCHARTYPE=1
JR17798UNEXPECTED SQL0303N FROM CLI ON FETCH OF A TIMESTAMP THROUGH A GATEWAY TO AN OS/390 DATABASE WHEN PATCH1=131072 IN DB2CLI.INI
JR17819CCA: IMPORT PROFILE NOT WORKING IF ODBC NAME DIFF THAN DB ALIAS
JR17824LOAD CRASHES INSTANCE ON WINDOWS WHEN TABLE CONTAINS IDENTITY COL IN FIRST POSITION AND INTO OPTION NOT USED
JR17865PROBLEM WITH THE LENGTH OF DATA RETRIEVED FROM BLOB ON THE LOCALDATABASE (DATABASE ON THE GATEWAY, WORKS FINE)
JR17866JDBC NET (TYPE III) DRIVER BATCH PROCESSING MISHANDLES SQL_NO_DATA_FOUND
JR17899ERROR MESSAGE GETS TRUCATED WHEN USING IBMDADB2
JR17902FP10: SQLSTATE 01503 ON SQLFREESTMT() WHEN SZTABLENAME FOR SQLCOLUMNSW() INCLUDES UNDERSCORE
JR17907SPATIAL EXTENDER'S RANGE PRODUCER FUNCTION IS NOT WORKING PROPERLY WHICH RESULT IN SLOW PERFORMANCE
JR17916APAR TO BACKFIT DB2LOCALE REGISTRY VARIABLE TO V7
JR17917FOR VARGRAPHIC DATA THE VALUE OF '\0' RETURNED AS A SINGLE BYTE DATA. SHOULD BE 2 BYTES.
JR17918SQLEXECUTE() FAILED WITH SQL0301 ERROR
JR17919GRANT ON GROUP >8 CHARS WILL GIVE SQL0107 HOWEVER PRIVILIGE WILLBE GIVEN IN SYSCAT.
JR17920CONTROL CENTER 'ESTIMATE SIZE...' WINDOW FOR TABLE W\ 16K PAGES DISPLAYS INCORRECT SIZE WHEN DISPLAY UNITS SET TO 'KB'.
JR17928DB2 ARCHIVE LOG COMMAND FAILS WITH SQL1224N ON OS/2
JR18098RUNNING THE INDEX ADVISTOR FROM A VERSION 7 CLIENT AGAINST A VERSION 8 DATABASE CAUSES DATABASE TO CRASH
PQ68134SOMETIMES FOREIGN UPDATES ARE RECURSIVELY APPLIED
PQ69246CAPTURE COLD START ALSO CAUSES FULLREFRESH OF TARGETS BASED ON EXTERNAL CCD TABLES
APAR fixes included in U484617 (Fixpak 8)
APARABSTRACT
GG04256ON WINDOWS 2000 SERVER DPROPR CAPTURE FAILS TO STOP WHEN ASNCMD STOP IS ISSUED
GG04305DPROPR CAPTURE- POTENTIAL DATA LOSS WHEN HANDLING DEADLOCKS ON REGISTRATIONS
GG04306DPROPR APPLY GETS ASN1067E EVEN WHEN THERE ARE NO CONFLICTS.
GG04308DPROPR APPLY GETS ASN1067E WHEN THERE SHOULD BE NO CONFLICT UNDER SPECIAL CIRCUMSTANCES.
GG04309ASNSAT SAYS IT IS SUCCESSFUL ALTHOUGH APPLY FAILED AT THE START ITSELF WITH SQL0551N
GG04311AFTER DB2 V7 FIXPACK7, WHEN REPLICATING FROM VM TO NT APPLY FAILS WITH SQL0204N ON SYSIBM.SYSTABLES
IC33488QUERY REWRITE : PREDICATE TRANSITIVE CLOSURE IS NOT APPLIED ON THE NULL PRODUCING SIDE OF OUTER JOINS
IC34446QUERIES USING THE LSDC BLAST WRAPPER AND NCBI BLASTALL VER 2.2.3WILL RETRIEVE AN INCORRECT VALUE FOR THE SCORE COLUMN
IC34516CUSTOMER USING THE INPUT SHAPE FILE THAT EXCEEDS THE MAXIMUM SIZE AND CAUSES DB2 TO CRASH.
IY16549PERFORMANCE PROBLEM WHILE DB2_CORRELATED_PREDICATES REGISTRY VARIABLE IS ON.
IY22265A MEMORY LEAK IN DB2SECD. IN A DCE CALL (GSS_ACCEPT_SEC_CONTEXT)DB2SECD INCREASES BY 4K EVERY 10 TO 60 CONNECTIONS.
IY24131NIS USER CAN CONNECT TO DB WITH EXPIRED PASSWORD
IY26331SQL0902 RC=143 ON DROP TABLE OPERATION. THE RETURN CODE CANNOT BE INTERPRETED. THE REAL PROBLEM IS A DAMAGED HISTORY FILE.
IY26388SIGNAL 11 IN SQLBLATCHUNPINNEDPAGE WHEN THERE IS A MEMORY ALLOCATION FAILURE FROM SQLBREADPAGEFROMCONTAINER.
IY27032ONLINE BACKUP TO TSM FAILS WITH -50 DUE TO ABYSMAL BACKUP PERFORMANCE.
IY28736INSERT INTO TABLE CREATED AS A LIKE OF A TABLE WITH AN IDENTITY COLUMN WHICH HAS BEEN ALTERED WITH RESTART FAILS WITH SQL0359N
IY28923ENABLING CLI TO HANDLE NULL TERMINATING CHARACTERS TO ENABLE SET PATCH2=52 PRIOR TO FP7, OR PATCH2=53 AFTER FP7
IY29136SQLGETINFO RETURNS WRONG INFO FOR SCROLLABLE CURSOR WITH 390 V7
IY29206WHEN TAKING CLI TRACE OF PERL DBI PROGRAM, VALUES PASSED DURING SQLEXECUTE NOT CAPTURED IN TRACE.
IY29327PERFORMANCE DEGRADATION IN UPDATE TRIGGER FROM V6 TO V7
IY29548ONLINE BACKUP CAUSED DEADLATCH PREVENTING NEW CONNECTIONS TO THE DATABASE TO COMPLETE SUCCESSFULLY
IY29832COSTING CHANGE TO MSJN. INCLUSION OF ADDITIONAL DETAILS IN REGARDS TO EFFHIGH2KEY.
IY29879SUM COLUMN ON SUMMARY TABLE. CONTAINED IN UNION ALL, WHICH IS PARSED DOWN TO JUST A SELECT BY CONSTRAINTS.
IY30070-551 WITH MULTICONNECT=3 IN CLI
IY30116JVM COMES DOWN AS A RESULT OF BAD POINTER PASSED TO MEMCPY BY DB2 CLIENT CODE.
IY30303THE ASNSAT PROGRAM DOES NOT DUPLICATE
IY30655V8 CLIENTS RUNNING ODBC/JDBC APPS REQUIRE A FIX TO THE DESCRIBE INPUT SUPPORT TO BE APPLIED TO THE V7 SERVER IN ORDER TO CONNECT
IY30712INDEX BUILD CHOOSES TEMPORARY TABLESPACE WITH LARGEST PAGESIZE WHEN LARGER SPACE WITH SMALLER PAGESIZE IS AVAILABLE
IY30735FORCE FAILS TO FORCE OFF AN APPLICATION IN COMPILING STATE
IY30839CONCURRENCY ERROR WITH CURSOR STABILITY ISOLATION LEVEL
IY30930SETOBJECT METHOD TRUNCATES THE VARIABLE TO 254 CHARACTERS WHEN USING TYPES.VARCHAR.
IY30938TIMING HOLE IN DARI CLEANUP LOGIC CAUSES DB2SYSC TO ABEND
IY30949SQL2009 DURING ONLINE BACKUP DUE TO FRAGMENTATION IN DATABASE SHARED MEMORY SET
IY31155LOCKS ON SYSPROCEDURES TABLE WHEN REBUILD A SP IN SPB
IY31194CREATE EXTENDED INDEX ON AN ADT COLUMN OF TYPED TABLE FAILS
IY31235SORT RECLEN LIMIT EXCEEDED IN FUNCTION SQLSTABLEINFOSETUP() WHEN DURING QUERY USING ABSTRACT DATA TYPES
IY31262THE JAVA_HEAP_SZ LIMIT WAS NOT SET WHEN STARTING JVM
IY31268DB2AGENT MEMORY FOOTPRINT INCREASED BY 600K ON V7.2 FIXPAK 3 DUETO LICENSING CHANGES - UNIX ONLY. THIS APAR REVERSES INCREASE.
IY31282DB21101E - CLP CALL SP ON AS/400 FROM THE UDB GATEWAY WHEN THE SP PARAMETER ORDER IS OUTPUT - INPUT
IY31313EXPORT FAILS TO EXPORT DBCLOB COLUMNS > 559
IY31330DB2 CRASHED IN LOG_EVENT() WITH SIGNAL #11
IY31332SQLYA_FREE_ADT_MBS: MB MUST POINT BACK TO ADT PASSED IN - WHEN RUNNING QUERY WITH ABSTRACT DATA TYPES
IY31391EEE : FCM BUFFERS CORRUPTIONS DURING GLOBAL SNAPSHOT MONITORING
IY31392EXPORT DATA UNDER ONE CODEPAGE AND LOAD UNDER NEW WILL FAIL WITHSQL1224 USING LOB/CLOB/BLOB COLUMNS
IY31449DB2OSCONF IS SENSITIVE TO THE SOLARIS OS LEVEL (32 OR 64BIT).
IY31481SQL0259 WHEN TRYING TO ADD MORE PAGES TO A DMS CONTAINER USING ALTER TABLESPACE...EXTEND COMMAND.
IY31487CONTROL CENTER FUNCTIONALITY IMPACTED IF DB2 INSTANCE NAME IS CONTAINED WITHIN THE ADMIN SERVER INSTANCE NAME.
IY31549PREVENT INVALID POOL STATE TRANS. DURING CONCURRENT BACKUPS ON SAME TBSPS
IY31614DB2LOOK ALWAYS BINDS WHEN AGAINST DB2 ON OS390
IY31621OPTIMIZER NOT CONSIDERING TO USE DISTRIBUTION STATS WHEN GRAPHICCOLUMN IS NOT CASTED.
IY31656LONG COMPILE TIME ON EEE FOR COMPLEX QUERY WITH DISTINCT AND LOJ.
IY31657RUNNING JAVA APPLICATION IN VAJ IDE TRAPS AT DB2DRIVER_SQLFREEENV.
IY31680ON UNIX MACHINES, SCRIPTS ARE ALWAYS MARKED 'SUCCESSFUL' EVEN IF THEY FAIL.
IY31691CALLING STORED PROCEDURE FROM OS/390 IN DB2 FP5+ GETS ERROR SQL30020 RC=124C (SQLSTATE 58009)
IY31714RECOVERY, ROLLFORWARD, OF A NON-RECOVERABLE LOAD MAY RESULT IN RECOVERY FAILING WITH MEMORY ERROR FROM LOB MANAGER.
IY31728INSTANCE FAILS AUTO START WITH CSH.
IY31773SQL30082 ISSUING THE AUTO USER MAPPING CMD ON FEDERATED INSTANCE
IY31783CRASH IN DURING LOAD DELETE PHASE WITH CODESET UTF-8, US.
IY31851TRAP OCCURRED IN SQLNS_EXPAND_SQL_FNCS_IN_OPR WHEN TRYING TO USEA METHOD WITH A RETURNS VARIABLE
IY31887CLI PACKAGES NOT CREATED WITH EXPLICIT BIND COMMAND AND CLIPKG
IY31954INCORRECT TABLESPACE SNAPSHOT OUTPUT FOR VALUES RELATED TO ESTORE.
IY31956CUSTOMER ATTEMPTS RETRIVE RESULT SET FROM AS400 USING DB2CONNECTWITH STORED PROCEDURE ENCOUNTERS SQL30020 AND DIA4803.
IY31958DB2DART /DDEL DOES NOT DUMP OUT DECIMAL COLUMN VALUES CORRECTLY.
IY31967ENABLE DB2 TO HANDLE TRAILING BLANK CONSISTENTLY FOR RI PD (PACKED DESCRIPTOR).
IY31970TO PROVIDE A DB2CAT TOOL TO FIX RI PD (PACKED DESCRIPTOR) FOR A TABLE.
IY32030INFINITE LOOP IN DB2 LOCK LIST FORMATTER WHEN NEXT LRB IN LOCK'STRANSACTION CHAIN IS ITSELF
IY32077SOLARIS THREAD LIBRARY BUG 4533861 CAUSES DB2 TO CRASH / HANG. DB2 NEEDS TO LINK TO THE NEW ALTERNATE THREAD LIBRARY.
IY32093WHEN PARTITIONING KEY INVOLVES UDT, AUTOLOADER RETURNS -2038 DURLOAD.
IY32104STORED PROCEDURE PERFORMANCE WITH LARGE PARAMETERS
IY32138DB2PROFC AGAINST HOSTDB GETS SQL4912N WHEN HOST VARIABLE FOR GRAPHIC COLUMN HAS LENGTH MORE THAN 127
IY32147ADD SUPPORT TO USEGRAPHICCODEPAGE MODIFIER IN IMPORT/LOAD
IY32179SQL1056N OPEN SCANS NOT RELEASED WHEN CLOSING THE CONNECTION
IY32251SQL0901 WITH RETURN MESSAGE 'BAD OUT/IN COMPARE2' RETURNED WHEN RUNNING A QUERY FOR A USER DEFINED TABLES.
IY32330DCTM WRAPPER: SUPPORT FOR DCTM_INTEGER MISSING
IY32333FFFFD602 OUT OF DATABASE HEAP MESSAGES AFTER UPGRADING TO FIXPAK4 WITH BUFFERPOOL MONITORING AND LARGE NUMBER OF TABLESPACES.
IY32340INSERT INTO CLOB FAILS IN JDBC APP DRIVER WITH SQL0138
IY32396FEDERATED DB CAUSES SLOW QUERY RESPONSE IN PASSTHRU MODE
IY32407FILTER FACTOR GETS SKEWED DUE TO STANDARD FUNCTION TYPE BEING APPLIED.
IY32463SQL2048N WITH RC=8 RECEIVED WHEN AUTOLOADER ATTEMPTS TO LOAD A LOT OF DUPLICATE ROWS INTO A TABLE.
IY32472WHILE CLP TREATS SPS AS SINGLE UOWS, CLI DOES NOT. APAR IS TO MAKE THEM MORE CONSISTENT.
IY32473REBIND NOT BEING DONE CORRECTLY WHEN THE BIND WAS NOT DONE CORRECTLY BY THE APPLICATION, CAUSING SQL0301N
IY32499SCRIPT FILE PERMISSION INCORRECT LACK EXECUTABLE PERMISSIONS /OPT/IBMDB2/V7.1/HA/UTIL
IY32506DB2 CONNECT RETURNS SQL1091 AFTER BACKING OUT A VERSION 7 FIXPAK. THIS IS AFTER THE DB2UPDV7 SCRIPT IS RUN.
IY32511DB2RA UNALIGNED ACCESSES ADVERSLY AFFECTING PERFOMANCEOF REMOTE COMMUNICATION WITH SERVER
IY32536OPTIMIZER CALCULATING SELECTIVITY INCORRECTLY IN A CASE WHERE COLUMN IS ALL NULL AND NUMNULLS > CARD.
IY32652'ALTER TABLESPACE....EXTEND' COMPLETES SUCCESSFULLY: HOWEVER, THE TABLESPACE CONTAINERS ARE NOT EXTENDED
IY32654WHEN USING THE LIKE PREDICATE FOR GRAPHIC COLUMN TYPE, WE DO NOTCONSIDER USING 'START/STOP KEY' FOR THE INDEX, WE USE SARGABLE.
IY32659DB2STOP DROP NODE NODENUM <NODENUM> FAILS
IY32675QP CRASHED AND FAILED TO RESTART. A RESTART WAS POSSIBLE ONLY AFTER DELETING ROWS OF AN INVALID USER ID IN THE IWM JOB TABLE.
IY32684DB2LOOK -F OPTION PRODUCES WRONG VALUES.
IY32709INSTANCE MIGRATION TO DB2 V7 FROM PRIOR VERSION RESULTS IN INCORRECT SQLDBDIR.
IY32762STORED PROCEDURE BUILDER BASIC PARSER NOT ABLE TO PROCESS A LARGE SIZE JAVA STORED PROCEDURE CODE
IY32783OUTER JOIN CONVERTED TO INNER JOIN WHEN OR PREDICATE IS PRESENT
IY32790NULLPOINTEREXCEPTION IN ...JDBC.APP.DB2RESULTSET.GETCOLCOUNT
IY32854SET WALKING FILTER FACTOR CORRECTION
IY32856QUERY RE-WRITE TO REMOVE 'IS NULL' WHEN NULL IS NOT POSSIBLE.
IY32886SQL_SUCCESS_WITH_INFO AFTER CODEPAGE CONVERSION
IY32934WEBSPHERE RECIEVES CLI0119 WHEN DOING AN XACONNECT WITH A BAD PASSWORD.
IY32940WRITE RESUME OPERATION HANGS WHILE A WRITE SUSPEND IS PROCESSING
IY32941-901 ON RUNNING QUERY WITH FETCH FIRST N ROWS CLAUSE
IY32943CLI0125E ON SQLFETCH WHEN AUTOCOMMIT IS TRUE AND THE BINDING COLUMN SIZE OF INPUT PARAMETER IS >4000.
IY32989APPLY AIX AT FP7 LEVEL RECEIVES SQL1403N USING PASSWORD FILE.
IY33012FIX TO AVOID A UNNECESSARY DESCRIBE WHEN DESCRIBE NOT SUPPORTED.
IY33032START WEBSPHERE ADMIN SERVER CRASH WHEN LOADING JDBC LIBRARY DUETO DB2 WRONG CODEPATH
IY33090TWO APPLICATIONS TRYING TO REBUILD THE INDEX AND WHEN ONE OF THEM FAILS IT CAN CAUSE SUBSEQUENT INDEX CORRUPTION OR -901 ERROR.
IY33092USER DEFINED TYPE MAPPING FOR FEDERATED DATABASES NOT PICKED UP IF DEFAULT TYPE MAPPING EXISTS
IY33096SQLDRIVERCONNECT() CRASHES-RUNNING-RELIABILITY TESTS SIEBLE7.5.
IY33112AFTER RECOVERY, CAPTURE RECEIVES SQL2650, RC=5
IY33122INFINITE LOOP CAUSED WHEN AN UNDO OF AN INSERT OCCURS AT THE SAME TIME AS A CURSOR SCAN.
IY33203DPROPR CAPTURE NEEDS TO READ TOO FAR IN THE DB2 LOGS UNDER CERTAIN CONDITIONS
IY33216TRAP OCCURRING WHEN SQLJG_SQLDTARD_DTA_STORE FREES MEMORY.
IY33333POSSIBLE TABLESPACE CORRUPTION WHEN ROLLFORWARD THROUGH FAILED REORG
IY33343MALLOC ERROR MESSAGE ARE GIVING WRONG ROUTINE AND WRONG SIZE OF REQUEST.
IY33357CRASH IN SQLOFMBLK CALLED FROM SQM_STMT
IY33377CREATE UNIQUE INDEX MAY GIVE SQL0603N IF INSTANCE IS 64 BIT AND DATABASE CODESET UTF-8 AND COLLATING SEQUENCE IDENTITY_16BIT
IY33385SQL0302N OR CLI0002W CODE RETURNED DEPENDING ON WHETHER DATABASEIS UNICODE OR NOT. SHOULD BE SAME CODE AS ORACLE AND MSQL.
IY33408BLAST WRAPPER: DEFLINE PARSING BROKEN
IY33432LOCK ESCALATION PROBLEM. PROBE:30 FROM SQLPLUHD IN DB2DIAG.LOG RESULTING IN DATABASE CRASH.
IY33442DB2DARI INTERMITTENLY TRAPS WHEN STORE PROCEDURE RETURNS MULTIPLE CURSORS
IY33466ALLOW BUIDING OF JAVA STORED PROCEDURES FROM V7.2 CLIENT TO A V8UDB SERVER
IY33475SQL0444N WITH FUNCTION MAPPINGS THAT HAVE A TEXT COLUMN
IY33476PASSING A 0 LENGTH DAD FILE TO THE DXXGENXML AND DXXRETRIEVEXML STORED PROCEDURE CAUSED DB2 TO CRASH.
IY33479COMPARISON OF 2 UNICODE STRINGS WAS DONE INCORRECTLY IN THE XML EXTENDER CODES, CAUSING INTERMITTENT FAILURE.
IY33517FIX INCORRECT UPDATE OPERATION CAUSED BY INCORRECT PREDICATE HANDLING.
IY33518POSSIBLE MEMORY OVERWRITE AND OR CORRUPTION OF THE STACK
IY33519TSM LIBRARY MAY CAUSE A SEGMENTATION VIOLATION WHEN ATTEMPTING ARESTORE USING A TIMESTAMP OF AN IMAGE THAT DOES NOT EXIST.
IY33528A CORRELATED SUBQUERY MIGHT BE WRONGLY DECORRELATED IF IT AND ITS OUTER QUERY REFER A SAME BASETABLE MORE THAN ONCE.
IY33543TO IMPROVE PERFORMANCE, I/O ACTIVITIES HAVE TO BE REDUCED
IY33558THERE IS A POTENTIOAL PROBLEM IN COMPOSITION USING RDB_NODE MAPPING: IT MIGHT CAUSE DB2 TO CRASH DUE TO MEMORY OVERRIDE.
IY33673WHEN THE ABSTRACT DATA TYPE IS USED IN A SELECT STATEMENT, THE INSTANCE CRASHES
IY33712PREDICATE FACTORIZATION CAUSING PERFORMANCE REGRESSION
IY33751'BYTES' NOT 'PAGES' FOR THE ROWS 'EXTENT SIZE' IN LIST TABLESPACES OUTPUT
IY33754TRAP IN CLI ON REDESCRIBE
IY33810DB2LOOK -X OPTION DOES NOT GENERATE GRANT STATEMENT FOR LOAD AUTHORITY.
IY33811SQL1042 RECEIVED WHEN ISSUING A GLOBAL MONITOR SNAPSHOT. DB2DIAG.LOG CONTAINS SQM_AGGR_SNAPSHOT_BUFFER::AGGRE ENTRIES.
IY33823SQL0206N ON BEFORE-IMAGE COLUMN NAME FOR 18 CHAR COLUMN NAMES AFTER UPGRADING TO FIXPACK7 OF V7.
IY33851A SELECT QUERY ON A VIEW CRASHES THE INSTANCE WITH SIGNAL #11 TRAPPING IN THE FUNCTION SQLNQ_QUNQPULL_UP_ORDER_OF
IY33865EXTRACTCHARS FROM XMLCLOB WILL CAUSE DB2 DARI TO TERMINATES IF THE CLOB SIZE IS GREATER THAN 512 BYTES.
IY33876WITH JDBC NET DRIVER, ONE CAN'T SETNULL(1, TYPES.BINARY) A COL DEFINED AS VARCHAR FOR BIT DATA WITHIN A JDBC BATCH OPERATION.
IY33879DOING A RUNSTATS ON A SPECIFIC INDEX AFTER ANY COLUMN ON THE TABLE IS RESIZED WILL CORRUPT THE DISTRIBUTION STATS IN THE PD
IY33897DB2BP TRAPS WHEN EXPORT/IMPORT USING HIERARCHY TABLE IS ISSUED.
IY33908SIGSEGV 11 FAILURE (CORE DUMP) IN SQLFETCH API.
IY33924REPLICATION FAILS WITH ERROR 'DIA4804E - DRDA DATASTREAM PARSINGERROR' WHEN MONITORING IS ON.
IY33946WRONG SCHEMA USED IN INCREMENTAL REBIND OF STATIC CURSORS CREATED WITH VALIDATE RUN
IY33949SQL0973N (NOT ENOUGH STORAGE) IN APP_CTL_HEAP OR SQL0423N IN SQLRH_FREE_N_HANDLE - MEMORY LEAK IN LOB PROCESSING
IY33965MEMORY LEAK WITH DPROPR CAPTURE WHEN HANDLING LONG VARCHARS
IY33999LSDC DOCUMENTUM WRAPPER FAILS TO HANDLE TIMESTAMP DATA TYPES CORRECTLY, CAUSING AN ENGINE CRASH
IY34000THE LSDC BLAST WRAPPER DOES NOT SUPPORT EXECUTION ON AN SMP SYSTEM.
IY34001MACRO TRAPS BECAUSE A POINTER TO SQLDA AREA THAT IT USES CAN SOMETIMES BE NULL.
IY34002PERFORM UPDATE TO DB2 390 WITHIN AN XA COORDINATE TRANSACTION. CALL MQCOMMIT (ISSUE XA_PREPARE AND XA_COMMIT). XA_COMMIT HANGS
IY34003TABLESPACE ROLLFORWARD THROUGH A REORG MAY FAIL IF ONE OF THE TABLESPACES IS TAKEN OFFLINE
IY34021A FEDERATED QUERY INVOLVING COMMON SUBEXPRESSIONS (CSE) CRASHES THE OPTIMIZER WHEN RUN.
IY34061SUBSEQUENT ROLLFORWARD AFTER RESTORE CAUSES SIGSEGV#11 TRAP IN SQLRL_OPEN
IY34069DATABASE HISTORY RECORD FETCH MAY FAIL WHEN READING LONG COMMANDTEXT INTO SMALL HISTORY RECORD BUFFER.
IY34101CLI REDESCRIBE CAUSES TO COMMIT JDBC'S EXECUTEBATCH
IY34108SQLSTATE 01517 FROM CLI WITH JAPANESE CODEPAGE
IY34109CLI NOT RE-INITIALIZING, WRONG HEX DATA INSERTED IN UNICODE ENV.
IY34111J2EE, JDBC SECURITY NEEDS TO USE DOPRIVILEDGED( ).
IY34122ON 64BIT MACHINE, DECRYPT_VARCHAR FUNCTION RETURN -901
IY34147SEGMENTATION FAULT IN SQLOICONV WITH UNICODE CLI APPLICATION IF CLI TRACE IS ON
IY34193KATAKANA COLUMNS RETURING '-' WHEN SELECTED FROM NICKNAME.
IY34212MALLOC WHEN PROCESSING LONG VARCHARS / COULD SOMETIMES CAUSE DATALOSS IN LONG VARCHAR COLUMNS
IY34214DB2DIAG.LOG ENTRY THAT CONTAINS A FAILURE IN SQLUHUPDATESINGLE DUE TO A PREVIOUS UNKNOWING WRITE FAILURE TO THE HISTORY FILE.
IY34218BRANCH ELIMINATION BLOCKED IN DYNEXPLN FOR A STATIC SQL STATEMENT
IY34222ALLOW DYNAMICRULES BIND BIND OPTION TO BE SPECIFIED AGAINST THE UDB SERVER FROM A NON-UDB CLIENT.
IY34251FIX SQL1279W DURING REORG ON TABLE WITH TRAILING BLANKS IN DATA.
IY34261PROVIDE SUPPORT FOR XMLVARCHAR > 3K
IY34263EVERY DB2 AGENT PROCESSES WILL USE 6MB MORE MEMORY ON SUN.
IY34302SYNC POINT MANAGER (SPM) LOG CORRUPTION DETECTED AT DB2START
IY34310PROBLEM WITH DQP_NTIER REGISTRY VARIABLE WHEN INSTALLING VIA RESPONSE FILE.
IY34333INCORRECT CALL TO SQLNG_BUILD_LEAVE_PRD.
IY34336HOST SERVER VERSION INCORRECTLY SET WHEN CONNECTION CONCENTRATORPICKS AN IDLE AGENT TO SERVICE AN ALREADY CONNECTED APPLICATION.
IY34350FIX PROCESSING OF SERVER QUERY FAILURE WHEN LOBS ARE RETURNED.
IY34363APPLY RECEIVES SQL0452N,REASON CODE 2, ATTEMPTING TO REPLICATE TABLE WITH CLOB COLUMN.
IY34401HP ONLY: RUN JAVA UDF HANGS, DB2DIAG.LOG DUMPS JAVA CORE STACK
IY34402DROP SERVER/DROP NICKNAME /DROP USER /DROP WRAPPER TRAPS WITH SIGNAL #11 WHEN ISSUING FROM NON-CATALOG NODE.
IY34405PERFORM AN IMPLICIT REPREPARE IF SQLCOLATTRIBUTES RETURNS ERROR CODE SQL0727 TO RETURN ORIGINAL ERROR CODE
IY34406ALLOW THE CONFIG ADVISOR TO FIGURE OUT THE DATABASE NAME WITHOUTANY DB ALIAS OR DB NAME INPUT IF THE INVOKER IS WEBSPHERE.
IY34451SELECT ON A VIEW USING THE ' = ' IN THE WHERE CLAUSE WILL RETURN0 ROWS
IY34514IRELNO NOT SET IN V7 DB2RA STREAM.
IY34528DSMAPIPW FAILED WITH RC '109' IN TSM LANFREE ENVIRONMENT
IY34539DPROPR CAPTURE COULD LOOSE RECORDS IF THE CD TABLE WAS LOCKED BY SOMEONE ELSE RESULTING IN DATA LOSS
IY34556SQLSPECIALCOLUMNS AGAINST OS390 FAILS WITH SQL4954 ERROR.
IY34583DPROPR APPLY WKSTN FULL REFRESH DOES NOT DELETE FROM TARGET TABLE WHEN SOURCE WAS EMPTY
IY34611SIGNAL 11 IN CLI JTASTART DURING XA ROLLBACK.
IY34666INCORRECT AUTOCOMMIT RETURNS IN XA TRANSACTION.
IY34706INDOUBT TRANS. ARE COMMITTED ON SOME NODES WHILE ROLLED BACK ON THE OTHER NODES WHERE THE TRANS. ARE CO-OR'ED BY AN EXTERNAL TM.
IY34776ERROR CONNECTING TO OR CREATING A DATABASE ON A 64-BIT INSTANCE THAT WAS MIGRATED FROM 32-BIT.
IY34836DPROPR CAPTURE COULD LOOSE DATA UNDER CERTAIN CIRCUMSTANCES IF IT HAD PREVIOSLY ABENDED BECAUSE OF AN SQL ERROR
IY34934ORG.XML.SAX.SAXPARSEEXCEPTION: AN INVALID XML CHARACTER (UNICODE: 0X0) WAS FOUND IN MARKUP AFTER THE END OF THE ELEMENT
IY35085CONCURRENT UPDATE/DELETE OF PARENT ROW,ROLLBACK ON UPDATE/DELETEOF CHILD VIOLATES REFERENTIAL CONSTRAINT IF DB2_RR_TO_RS ENABLED
IY35092RUNSTATS THAT REFERENCE INDEX CAUSES ERROR '-1224'. ENGINE WILL CRASH.
IY35194ERROR ON CREATE SERVER FOR REMOTE DB ON V8
IY35512DB2 PANICS IN ~SQM_EVMON_IOT(), CALLED BY SHUTDOWN_EVMON, WHEN AN EVENT MONITOR ENCOUNTERS AN ERROR.
IY35891TIMING HOLE DURING STATEMENT COMPILATION CAUSES DB2 INSTANCE CRASH UNDER HEAVY WORKLOAD - DB2 TRAPS UNDER SQLNR_MAGIC_ACTION
IY35999JDBC APPS USING NET DRIVER, MISSING THE LAST ROW WHEN CURSOR IS BLOCKING BUT THE ROW IS SPLIT ACROSS TWO COMM BUFFERS.
IY36322DURING INDEX RECREATION, BPS ERROR OF FIXING A DIRTY PAGE SQLB_NEWX.
IY36611THE UNBOUND COLUMN CASES A CORE DUMP. BECAUSE OF THAT PEOPLESOFTTRAPS. THE FIX FOR APAR#IY29709 CAUSES ALL THESE.
IY36669SQLDESCRIBEPARAM SYMBOL MISSING FROM DB2JMS.DLL CAUSING LINK ERROR
IY38276TYPE AND NAME MISMATCH WHEN GOING FROM V7CLT->V8GTWY->OS390V7
JR15227DURING LOAD MODIFIED BY CODEPAGE IBM-930, CHARACTER X4040 NOT STRIPPED OUT BY STRIPTBLANKS MODIFIER
JR16761REVOKE FAILS ON TABLE THAT AUTOMATIC SUMMARY TABLE (AST) DEPENDSON.
JR16787CLI STATIC PROFILING - CAPTURE FILE IS OVERWRITTEN IF THE APPLICATION FUNCTION IS REPEATED.
JR16905SQL0107 WHEN COLLECTION ID >= 8 IN STATIC PROFILING
JR16981PROBLEM WITH OUTER JOIN REORDERING FOR VIEWS
JR16986REPLICATION APPLY WITHIN DATA WAREHOUSE CAN HANG IF APPLY DOES NOT FINISH.
JR17053IF DB2CODEPAGE VARIABLE SET TO 1208, INFORMATION RETURNED BY SQLGETDIAGRECW MAY BE CORRUPTED
JR17062WHEN USING 'CALL PROCEDURE()' IN COMMAND LINE PROCESSOR, ECHO %ERRORLEVEL% RETURNS INCORRECT OUTPUT WHEN AN ERROR HAS OCCURRED
JR17063ADDBATCH() WILL GIVE ERROR CLI0628E IF NOT ALL PARAS ARE SET
JR17070SQL01014N MAKING SQLJ PROGRAM WITH FORUPDATE INTERFACE WITH SELECT WITH WITH CLAUSE (E.G. WITH RR) OR OPTIMIZE FOR N ROWS
JR17072INDEX SCAN, FETCH PLAN IS BEING SKIPPED BECAUSE OF INCORRECT IDENTIFICATION AS A HALLOWEEN SPECIAL CASE.
JR17081SQL0334N WHEN EXECUTING STORED PROCEDURE CALL TO DB2 FOR 390 V7.THIS IS A UNICODE PROBLEM.
JR17082TRAP WHEN USING A SQL_ATTR_CURSOR_TYPE ON A CONNECTION HANDLE
JR17108SQLCA NOT BEING RESET WHEN RECEIVE A CONVERSION ERROR USING CLI WITH EXECUTE CHAINING.
JR17132LOCALE PROBLEMS CONVERTING DECIMAL TO SQL_C_DOUBLE
JR17137UDB INCORRECTLY RETURNING DRDA OPNQRYRM WITH SVRCOD=4. THIS VIOLATES DRDA AND CAUSES 390 TO DETECT A DRDA EXCEPT COND.
JR17141EEE NT/WIN2000(MULTIPLE MACHINES):DB2LOOK DOESN'T PICK UP ALL THE INFO.
JR17150SAMPLE CONTENTS USES INCORRECT LOCKING.
JR17160DB2SYSP.DLL MAY NOT INSTALL CORRECTLY DURING FIXPACK INSTALLATION
JR17169SELECT WITH OUTER JOINS AND UNION RETURNS MORE ROWS THAN IT SHOULD
JR17186TWO XA PREPARE CALLS TO DB2 GIVE -7 XAER RMFAIL ERROR. RESOURCEMANAGER UNAVAILABLE.
JR17187SQL0332 ERROR EBCDIC 37 TO UNICODE 1208 FOR LOB DATA
JR17200SQLFREESTMT TRAPS IF SQLEXTENDEDBIND ARRAYS ALREADY FREED
JR17208OLEDB DRIVER GETS CATASTROPHIC FAILURE IN GETPROPERTIES AND CRASHES THE MS SQLSERVER THAT IS USING IT. CLI TRACE SEES CLI0131E.
JR17211ABSTRACT FP8:NESTED PROC CALL ALWAYS RETURNS +464 IF CALLER
JR17214SQL1822 UNEXPECTED ERROR CODE '-418'... WHEN DOING QUERY AGAINSTA FEDERATED NICKNAME
JR17217ATTEMPT TO REMOVE TABLE FROM SUBSCRIPTION SET DELETE FROM ASN.IBMSNAP_SUBS_COLS IN MISSING PREDICATES CAUSING WRONG ROW DELETION
JR17221SQL4954N : ISOLATION CHANGE INVALIDATING CACHED STMT. RE-PREPARETHE SECTION AND RE-ASSIGN A SECTION NUMBER UPON RE-EXECUTION.
JR17222RUNSTATS UPDATES THE CARD FIELD IN DB2/390 INSTEAD OF CARDF.
JR17231SILENT INSTALL FAILS IF DWCTRLDB INFORMATION IS NOT IN RESPONSE FILE, IRRESPECTIVE OF WHETHER DWCTRLDB IS INSTALLED.
JR17244ERROR WITH SIZE OF STRINGS IN FRENCH INSTALL FINAL PANEL
JR17250CONTROL CENTER - SQL0355 CREATING A TABLE WITH COLUMN XMLCLOB EVEN WITH LOGGED OPTION UN-CHECKED
JR17252SQL3070N DURING LOAD INTO V7 FIXPAK 7 FROM FIXPAK 6 AND EARLIER IXF FILES THAT USED AN IDENTITY COLUMN
JR17253SQL1131N AND MEMORY REFERENCE ERROR WHEN RUNNING OLE SP ON WINDOWS
JR17254OUT OF MEMORY ERROR FOLLOWED BY SEGMENTATION VIOLATION IN SQLRA_REST_REG WHILE DOING DB2RBIND
JR17263THE ''' CHARACTER NOT PROPERLY REPRESENTED IN CREATE TABLE DDL.
JR17267DB2 CONNECT SHOULD VERIFY THAT THE SERVER IS AT SQLAM 6 OR ABOVE(WHERE DYNAMICRULES IS DEFINED) BEFORE SENDING OUT THIS BIND.
JR17272SQL30081N WHEN FORCING APPLICATIONS
JR17281UDB CLIENT GETS RESULT SETS FROM OS390 DB SERVER RECEIVES COMMUNICATION ERROR WITH ERRNO 10014
JR17282USING KEYSET CURSORS WITH LARGE UPDATE STATEMENTS CORRUPTS THE STATEMENT
JR17285WRONG SQLSTATE WHEN CALLING UDF
JR17286JDBC PROGRAM CAUSE AN EXCEPTION IN CLI MODULE SQLGETDATAINTERNALDURING FETCHING INTO SQL_C_WCHAR WHEN DB2CLI TRACE IS ON.
JR17295INSTANCE TRAP AT SQLCC_GENERATE_SYNCLOG WHEN SP FETCHES LOB DATA
JR17298DWC Insert statement puts in wrong value for NOT NULL WITH DEFAULT
JR17300JDBC 2.0 NET DRIVER ALLOWS BLANK USERID/PASSWD TO LOGIN
JR17312INTERMITTENT DIA4804E, -30020 WHEN SQL_ATTR_QUERY_TIMEOUT USED IN CLI APP IN CONJUCTION WITH QUERYTIMEOUTINTERVAL KEYWORD
JR17317SQL0204 FROM DB2 CROSSLOADER PROGRAM.
JR17318ON FAST X86 MACHINE, DB2START FOLLOWED BY CONNECT TO DB RESULTS IN SQL1032N EVEN THOUGH DB2START ALREADY COMPLETED
JR17320ARRAYINDEXOUTOFBOUNDSEXCEPTION IN GETCOLUMNCLASSNAME
JR17325DB2CLI.DLL TRAPS/ RESULT INCORRECT WHEN CLIENT INVOKES STORED PROCEDURE THAT RETRIEVES DATA FROM UNICODE DATABASE
JR17332DB2STOP FORCE HANGS AFTER A CTRL-C AGAINST A JAVA APPLICATION
JR17333DB2UNINS.EXE RUNNING ON WINDOWS NOT DELETING ALL REGISTRY ENTRIES, NOR THE SQLLIB DIRECTORY.
JR17335-551 RECEIVED IN APPLICATION WHEN CURSORHOLD=0
JR17364IN CC WHEN CONNECT TO REMOTEDB SELECT FROM TABLE REPORTS DBA2191
JR17373CLI0601E ERROR RETURNED W/ SELECT FROM OS 390
JR17377CLI TRAPS WHEN DESCRIBE DA IS NOT PROCESSED AFTER 2ND EXECUTION
JR17380CONNECT IN COMMAND CENTER HANGS IF USER GOT NO PERMISSIONS TO C:
JR17382ATTEMPT CONVERSION FROM VARGRAPHIC TO VARCHAR USING SPB RETURNS SQL1131N DARI (STORED PROCEDURE) PROCESS BEEN TERMINATED
JR17383SIG#11 FROM SQLNO_GET_SUBQUERY_COSTS DURING QUERY EXECUATION AT OPTIMIZER LEVEL 5
JR17384CANNOT RUN SPANISH SPB SPROC WITH DEC INPUT
JR17389ADD SINGLE QUOTES IN SQL STATEMENT FOR PWD VALUE IN CRT SERVER
JR17395ENHANCEMENT REQUEST TO EXTEND THE SCOPE OF THE PATCH1=131072 VALUE TO INCLUDE RESULT SETS FROM A STORED PROCEDURE.
JR17413UDF ABNORMAL TERMINATION ON WINDOWS PLATORM RUNNING MULTI THREADED
JR17417ONTHLY(DATES) TYPE OF SCHEDULE IS NOT CORRECTLY CALCULATING THE STARTING
JR17426HASH TABLE NOT FREEING ENTRIES.
JR17427TRAP IN SQLDTSCN WILL OCCUR DURING LOCK ESCALATION IF MEMORY IS REFERENCED BEYOND THAT WHICH HAS BEEN ALLOCATED
JR17428SERVER GENERATED ROLLBACK NOT PROPERLY PROPOGATED TO A XA TRANSACTION MANAGER FROM DB2 CLIENT.XA_PREPARE=-3,XA_ROLLBACK=-6
JR17432THE GENERATE PERIOD TABLE TRANSFORMER PUTS WRONG END OF MONTH DATES
JR17433SPB BUILDS A STORED PROCEDURE BUT CANNOT RUN IT - THE MESSAGE 'WLM_ENVIRONMENT - 0 RECORD(S) SELECTED' IS DISPLAYED.
JR17482DB2DART REPORTS 'WARNING: OBJECT IN OBJECT TABLE NOT FOUND IN SYSTABLES' WHEN SYSCATSPACE IS DMS.
JR17489ROLLBACK TO SAVEPOINT IS IGNORED AND ENTIRE TRANSACTION IS ROLLED BACK INSTEAD
SA95931DWC - ISERIES AGENT DOES NOT WRITE CORRECT NUMBER OF ROWS ON AIX TARGET
SE08163OSP R510 EXTENDERS XML_EXTENDER INCORROUT
APAR fixes included in U484487 (Fixpak 7)
APARABSTRACT
GG04246DATA LOSS WITH DATAPROPAGATOR APPLY WHEN THE SET HAS A LARGE NUMBER OF MEMBERS AND THE SOURCE IS A CCD.
GG04250APPLY DOES NOT TERMINATE WHEN COPYONCE IS SPECIFIED AND THE SET FAILS WITH A -1.
GG04251APPLY COULD MISS THE HINT AND RESULT IN MISSING ROWS IF CAPTURE ENCOUNTERS -911
GG04257WHEN ASNLOAD IS CALLED BY APPLY A HIGH CPU CONDITION WOULD OCCUR FOR THE LENGTH OF THE LOAD PROCESS.
IC32991STORED PROCEDURE CALL CRASHES CLP DUE TO INVALID ARGUMENTS
IY18439BUFFER POOL LOGIC ERRORS IN SQLB_MAKE_ROOM_IN_MAP
IY20308UPDATING USER MAPPINGS FOR FEDERATED DATASOURCES ON EE / EEE IS NOT BEING SPAWNED ACROSS ALL NODES UNTIL A DB2STOP/DB2START.
IY21394THE HOST DB2 DATABASE BACKUP FAILS AS IT SEES THE LINK FILES ON DLFM ARE NOT YET BACKUPED.
IY22434SQL1042 ON CRASH RECOVERY AFTER ALTER , DROP BUFFERPOOL OPERATIONS
IY24866OPTIMIZER PROBLEM WITH UPDATE AND SELECT HIGH WORKLOAD
IY24876BUILDING A SQLJ APP WITH DECLARE STATEMENT PRODUCES A SQLJ0201E RC=1 ERROR.
IY25007JDBC DOES NOT REPORT ANY WARNINGS WHEN IT TRIES TO GET A SCROLLABLE CURSOR BUT FAILS.
IY25034CHANGE CLP REQUEST AND INPUT MESSAGE QUEUE NAME TO BE MORE UNIQUE
IY25826'SET TABLESPACE CONTAINERS' COMMAND ISSUED AT CLIENT WHILE CONNECTED TO HOST CAUSES TRAP AT THE GATEWAY.
IY26151BETTER HANDLING OF LOB FILES
IY26647DLFM_CHILD:43040 2.GROUPS ARE NOT DEFINED.. ERROR MESSAGE BEING REPORTED AS A SERIOUS ERROR ON THE DLFM SERVER
IY26861PERFORMANCE PROBLEM WITH FEDERATED QUERIES
IY26985QUERY PERFORMANCE DEGRADATION AFTER RUNNING RUNSTATS.
IY27236SIGNAL #11 DUE TO AUTOLOADER NOT HANDLING CATALOG NODE FAILURE SCENARIO
IY27879IN COMMAND CENTER, QUERY RESULTSETS FROM OS/390 DO NOT DISPALY IN QUERY RESULTS TAB
IY27987NETWORK STATISTICS API RETURNS WRONG DATA.
IY28115APPLY FAILS WITH SQL0206N ON A PREPARE IN AN UPDATE ANYWHERE SCENARIO
IY28175WAS MANAGED SERVER RESTARTS AFTER JAVACORE, ONLY HAPPENS WHEN CLI TRACING IS TURNED ON.
IY28186REORG TABLE TRAPS WHEN TYPED TABLE CONTAINS EXTENDED INDEX.
IY28247CUSTOMER SEES SQL804N ERROR WHEN RUNNING AN EMBEDDED SQL PROG. PROBLEM SEEMS TO BE CORRUPTED PACKAGENAME IN SQLDA.
IY28248PROBLEM WITH CATALOGUED TRUSTED DARI STYLE PROCEDURES.
IY282611 BYTE OVERWRITE IN SQLEJREADJAR
IY28262CARDINALITY ESTIMATES ARE OFF BY A FACTOR OF THE NUMBER OF EEE NODES.
IY28274UNICODE APPLICATION CONNECTED TO A CODEPAGE DATABASE RESULTS IN CLI0189E INCONSISTENT DESCRIPTOR INFORMATION ERRORS.
IY28275SNAPSHOT TABLE NAME IS NOT UPDATED IF THE TABLE IS RENAMED.
IY28380SELECT CASE WHEN EXISTS (SELECT * FROM LOCAL_TAB1 EXCEPT SELECT * FROM LOCAL_TAB2) THEN 1 ELSE 0 END FROM (VALUES 1) AS X' CRASH
IY28389SAME LOG FILE IS ARCHIVED TWICE
IY28395ERROR ON SQLDESCRIBEPARAM() GOING TO AS/400 DATABASE.
IY28412CLOSEOPEN WITH CHAINING DOESN'T SEEM TO CLOSE THE CURSOR IN SOMECIRCUMSTANCES.
IY28450DB2CKRST FAILS WITH RETURN CODE OF -10 SEEN AT LINE 1486
IY28455DB2 FORCE APPLICATION (APPLHANDLE#,APPLHANDLE#)' SUCCEEDED ON ONLY COORDINATOR NODE.IF ISSUED FROM ANY OTHER NODE IT FAILS
IY28490DB2_ALL AND RAH PRODUCE VARIABLE SYNTAX ERRORS WHEN USING C SHELL (CSH)
IY28522HANG ON CATALOG ACCESS AFTER SETTING EXPLAIN MODE TO EXPLAIN.
IY28541LOAD ON SMALLINT COLUMN USING MANTISSA NOTATION LOADS INCORRECT VALUES
IY28553TRAP IN SQLJDRD1 IN SQLO GET STATIC DATA
IY28611CLOB SUPPORT UNDER CLI MINMEM CRASHES
IY28632TRAPPED IN SQLNO_ESTOE_ACTION
IY28677CAPTURE WAS NOT UPDATING ALL LOB COLUMNS CORRECTLY FOR CERTAIN LOG VARIATIONS.
IY28699TRAP IN SQLEQUERYSYSPLEXNODES /DR.WATSON DB2SYSC - DEVIDE BY 0
IY28823SYSTEM ABENDS WHEN BUFFER SIZE IS TOO SMALL INSTEAD OF PROVIDINGTHE APPORIATE ERROR MESSAGE
IY28878PARSING ERROR WHEN SNAPSHOT MONITOR SETTINGS CHANGE DURING THE LIFE OF A QUERY - SQL0902CC.
IY28969CONTROL CENTER CONNECTIONS NOT CLOSED AFTER SAMPLE CONTENTS WINDOW SHUT DOWN RESULTING IN A BUILD UP OF CONNECTIONS
IY28979EEE CLP PERFORMANCE PROBLEM DUE TO READING DB2NODES.CFG
IY29051CLI AND JAVA APPLICATION GET SQL0301 OR CLI0111E WHEN THE NUMBEROF PARAMETER MARKERS IS GREATER THAN 255.
IY29061SETTING KEEPDARI=NO ON FP5 IS PRODUCING A LOT OF MESSAGES IN THEDB2DIAG.LOG -> SQLCCFREEIPCS FUNCTION CALLS
IY29230SETUNULL() ON COLUMNS W/ A NULL WILL RETURN INCORRECT RESULT
IY29232PROBLEM CAUSE BY TWO USERS CREATING A SEQUENCE WITH THE SAME NAME
IY29247DB2DART REPORTS INVALID INDEX TYPE OF 0X9101 FOR EXTENDED INDEX.
IY29266FEDERATE TO DB2 UDB SOURCE. QUERY IS NOT PUSHED-DOWN
IY29271FP7:EXTRANEOUS MESSAGES IN DB2DIAG.LOG DURING DQPSTART/STOP: SQLOOPENP PROBE:36, DQPSSEXECUTESTARTSTOPNODE PROBE:30,31,32
IY29281PERFORMANCE DEGRADATION DUE TO LATCH CONTENTION EXPERIENCED WHENSEVERAL SAME OR SIMILAR SQL QUERIES ARE ISSUED.
IY29294SQL0518 CAUSING AN INFINITE LOOP ON THE OS/390 SYSTEM.
IY29319DPROPR CAPTURE - MISMATCH IN ROW COUNT BETWEEN SOURCE AND TARGETAFTER REPLICATION
IY29339ARCHIVE TO A DIRECTORY WITH INCORRECT PERMISSIONS REPORTS SUCCESSFUL ARCHIVE, BUT NO ARCHIVE IS PERFORMED.
IY29386USE SQLCONNECTWINT( ) WHEN JAVA STORED PROCEDURES CONNECT TO DB2
IY29402NOT PUSHING DOWN PREDICATES THROUGH THE CSE THAT IS FOROMED WITHMULTIPLE USAGES OF THE VIEW.
IY29413CAPTURE PROGRAM DYING WITH SQL2650 RC=X / X={2,3,4}
IY29438JAVA SP GET ERROR SQL4304 ON MULIPLE PHYSICAL NODES EEE INSTANCEBUT WORKS FINE ON SINGLE NODE EEE INSTANCE.
IY29441DB2DART /LHWM DOES NOT COMPLETE INSPECTION PHASE ON LARGE TABLESPACE
IY29487DB2ADUTL INCORRECTLY REPORTS 'CORRUPTED BPS PAGE HEADER' WHEN VERIFYING BACKUP TAKEN WITH MULTI-PAGE FILE ALLOCATION ENABLED.
IY29541DB2 'HANGS' WHEN I/O IS WRITE SUSPENDED DUE TO LATCH CONTENTION
IY29565TURN OFF SQLB_SKIP_CONTAINER_OPS FLAG EVEN FOR CIRCULAR LOGGING
IY29569DB2UDB_SVC_START.KSH WRONGLY ADDRESS DB2NODES.CFG FOR EE PRODUCT
IY29662BLOCKING DATA TRANSFER FROM SOURCE SERVER TO FEDERATED SERVER IN PASS-THROUGH MODE.
IY29721CALL TO SP WITH PARAMETERS USING IBM OLEDB RESULTS IN CLI0100E
IY29779APPLY GETS AN SQL1822N AND FAILS WITH CPGDRL: READ THE NEXT INTENTSEQ FAILED. ERRCODE IS 812104'
IY29792ERRORS WHEN EXPORTING DATA FROM CODESET 1252 TO CODESET 1208 (UTF-8) USING CHARDEL0X0B IF THE DATA CONTAINS SPECIAL CHARS
IY29794CLI: INCORRECT/EMPTY INPUT/OUTPUT PARAMETER AGAINST MVS HOST
IY29815LOAD COPY IMAGE IS MULTIPLE TIMES LARGER THEN THE TABLESPACE BEING LOADED INTO WHEN USING LOAD COPY WITH SMALL EXTENT SIZE
IY29834WHEN PREVIOUS APPLY SHOWS STATUS=-1 AND WHEN NEXT APPLY IS RUN USING MAX_SYNCH_MINUTES, THE APPLY DOESN'T WORK CORRECTLY
IY29848VISUAL EXPLAIN HANGS AND NO ERROR MESSAGE IS RETURNED.
IY29871INCORRECT VALUES IN SYSIBM.SYSINDEXEXTENSIONPARMS FOR LENGTH
IY29873INSTANCE TRAPS ON SIGABRT IN SQLRL_GET_TYP_PREC_LIST
IY29918THIS APAR IS OPENED TO TRACK DEFECT D209176 - THE NUMBER OF COMMITS, ROLLBACKS, CONNECTS AND DISCONNECTS ARE NOT MONITORED
IY29919THIS APAR IS OPENED TO TRACK DEFECT NUMBER D209868. AFTER RESET MONITOR THE REMOTE RESPONSE TIMES ARE CORRUPTED.
IY29925THIS APAR IS OPENED TO TRACK DEFECT NUMBER D209210. SOME MONITORELEMENTS SUCH AS REMOTE RESPONSE TIME AREN'T FORMATTED CORRECTLY
IY29999JDBC DOES NOT CLOSE SOCKETS PROPERLY ON FAILED CONNECTION ATTEMPTS
IY30034REORG ON TABLE IN HIERARCHY WITH INDEX EXTENSIONS CAN ATTEMPT TO REORG THE WRONG TABLE IN THE HIERARCHY
IY30049CLI REDESCRIBE LOGIC ERROR FOR SQL_WCHAR WHICH IS INTERPRETTED AS SQL_GRAPHIC BY CLI.
IY30090CHANGE OUTPUT FROM HTML TO FLAT FILE FOR DB2SUPPORT DIAGNOSTICS
IY30119USE INTERNAL HANDLES IN CONCAT TO AVOID OVERFLOWING INTERNAL STORAGE
IY30130INSTANCE CRASH WITH SIGNAL 11 IN DB2GLOCK
IY30132QUERY PATROLLER COMMAND DQPSTART RETURNS EXIT CODE 0 EVEN WHEN THERE WAS AN ERROR.
IY30133CODE ENHANCEMENT THAT ALLOWS A VARIABLE TO BE SET THAT CAN DETERMINE WHICH QUERIES SHOULD BE INTERCEPTED.
IY30142APPLICATIONS HUNG IN UOW EXECUTING AND CAN'T BE FORCED DUE TO A SIGNAL RECEIVED IN DB2GDS
IY30159TRAP IN SQLCCGETATTR AFTER NUMBER OF SESSIONS HAS DROPPED TO ZERO AND WE TRY TO ESTABLISH A NEW CONNECTION.
IY30172CANNOT START THE GOVERNOR AS ANOTHER USER IF IT HAS PREVIOUSLY BEEN STARTED AS THE INSTANCE USER.
IY30193AUTOLOADER IS HARDCODE TO ACCEPT UP TO 100 ARGUMENTS
IY30195ALTER TABLE ... ADD COLUMN MAY CAUSE MISSING ROWS IN SYSIBM.SYCOLUMNS
IY30265MEMORY OVERWRITE BY CLI FUNCTION CAUSES TRAP FOR JAVA APPLICATION.
IY30272REMOVE UNWANTED TRACE MESSAGE FROM APPLY WHEN RUNNING WITH PARAMETER TRCPERF.
IY30299DB2DIAG.LOG REPORTS INCORRECT TABLESPACE TYPE WHEN TABLESPACE ISFULL OR FILE IS TOO LARGE (AT OS OR USER LIMIT) ERROR.
IY30301/DOC AND /UTIL NEED TO BE CREATED UNDER /OPT/IBMDB2/V7.1/HA/ FORDB2 HA AGENT FOR VERITAS CLUSTER SERVER
IY30303THE ASNSAT PROGRAM DOES NOT DUPLICATE
IY30334DB2 CRASHES AFTER 'SQLPGARL' GETS 'DIA3806C UNEXPECTED END OF FILE WAS REACHED.', ZRC=0XFFFFF609
IY30393INSTANCE CRASH WHEN TRYING TO CREATE TABLESPACE LARGER THAN MAXIMUM SIZE
IY30544SIEBEL PERFORMANCE, TRANSFORM 'IN OR IN' INTO 'EXISTS OR EXISTS'
IY30547CURSORS NOT BEING CLOSED AFTER THE ISOLATION LEVEL OF THE PARENTSTATEMENT HANDLE IS BEING CHANGED. CLI0129E
IY30551JDBC METHOD SETSHORT DOES NOT WORK CORRECTLY IN DB2 7.1 FP5
IY30563DON'T ALLOW CREATION OF EVENT MONITOR ON NON-EXISTENT PARTITION
IY30586AUTOLOADER (DB2ATLD) CRASHES WITH ERROR -6555
IY30653RESTORING LOAD COPY FAILS
IY30674DB2MOVE CORE DUMPS ON AN IMPORT IF A LINE IN THE DB2MOVE.LST FILE IS GREATER THAN 80 CHARS.
IY30678LOADING THE 16K CHAR DATA INTO LONG VARGRAPHIC COLUMN RESULT IN DATA TRUNCATION TO 8175 CHAR.
IY30682IN FENCED MODE, CUSTOMER CANNOT PASS LIBPATH INTO UDF VIA DB2ENVLIST REGISTRY VARIABLE.
IY30688PREVENT A SUSPEND WRITE I/O OPERATION FROM TRAPPING IF ANOTHER AGENT IS SIMULATENOUSLY PERFORMING A DROP TABLESPACE OPERATION.
IY30690THE RESULT OF A HASHJOIN MAYBE INCORRECT, NO ROWS, WHEN IT IS THE JOIN METHOD OF A STARJOIN ACCESS PLAN.
IY30703INSERT QUERY USING A FEDERATED JOIN FAILS WITH -901 IN A MULTI NODE DATABASE(EEE ENV). IT WORKS FINE FOR SINGLE NODE DATABASES.
IY30705TIMING HOLE TRAP IN MONITOR HANDLING FOR PARTITION FAILURE IN NODE_FAILURE_RECOVERY ()
IY30706FIX DB2 CRASH UNFIXING CERTAIN INDEX PAGES
IY30717CLI0112E: ERROR IN ASSIGNMENT. SQLSTATE=22005
IY30721DXXADM ENABLE_COLUMN -R <COLUMN_NAME> FAILS WHEN COLUMN IS DECIMAL
IY30723STORED PROCEDURE ON OS/390 DOES NOT RETURN ANYTHING IN DB2 7.1 FP5+
IY30741CRASH RECOVERY FAILS IN REDO PHASE WITH FFFFF954 FROM SQLIREDO
IY30762IN 'SATELITE ADMIN. CENTER'->GROP->APPLICATION VERSION..->EDIT- ->CHANGE, SOMETIMES,STEPS ARE MIXED UP IN 'CHANGE LEVEL' WINDOW
IY30828MEMORY PROBLEM, DB2 FAILED WITH -1224
IY30848CRASH OF DB2SQL92 WITH SEGMENTATION VIOLATION, INSTANCE NOT AFFECTED
IY30862DATABASEMETADATA.GETMAXSTATEMENTLENGTH() RETURNS WRONG VALUE
IY30896POTENTIAL FOR DATA LOSS USING 'DELETE ... WHERE ..'
IY30911SQL0100 WHEN RUNNING A SP THAT RETURNS (A) RESULT SET(S) USING FP6. -0100 IS SHOWN RIGHT AFTER THE DATA IS DISPLAYED.
IY31175CURSORED UPDATE/DELETE MAY CORRUPT DATA IF MULTIPLE OPERATIONS ARE PERFORMED ON CURRENT ROW AND EQUALITY USED IN WHERE CLAUSE.
IY31288HANG IN NETSTAT -I-R
IY31375SOME ROWS OF RESULT NOT CONVERTED TO PROPER CODEPAGE WHEN DATABASE IS SET TO IBM-850 TERRITORY PT_BR.
IY31899REDIRECTED RESTORE ALLOWS TABLESPACE LARGER THAN 64GB LIMIT
IY31973EXPORT IN WSF MODIFIED BY 3 FAILED WITH SQL0332
IY32028-901 FROM ALL SQL COMMANDS AFTER REORG
IY32062DYNAMIC SQL SNAPSHOT FIELDS 'NO. OF EXECUTIONS' AND 'NO. OF COMPILATIONS' SHOWS INCORRECT RESULTS.
IY33275FP7 ONLY:MULTIPLE APPLICATIONS WITH SAME HANDLE, VARIOUS CRASH SYMPTOMS INCLUDING TRAPS IN SQLRINTP WITH HIGH WORKLOAD
IY33407JDBC DOES NOT REPORT ANY WARNINGS WHEN IT TRIES TO GET A SCROLLABLE CURSOR BUT FAILS.
JR16415WHEN SPECIFYING AN 'IN <TABLESPACE>' CLAUSE IN AN ODBC APPLICATION FOR CREATE TABLE, <DBNAME> IN DB2CLI.INI IS IGNORED.
JR16423READING BLOB DATA FROM DB2 CAUSES MEMORY LEAK.
JR16444BIND FAILS WITH SQL0031C WHEN SPACE IN FULLY QUALIFIED PATH
JR16476IMPORT USING METHOD P USES WRONG SYNTAX: IMPORTS NULL COLUM
JR16658DATA WAREHOUSE WILL RETURN DATA EVEN WHEN AN INVALID USERID/PASSWORD IS USED.
JR16743KEYSET CURSOR OPTION CAUSES ABEND
JR16764FP6->REQUEST ALTER_REBUILD WHEN WLM ENVIRONMENT CHANGES.
JR16766NLS ENABLEMENT OF TAG FILE ON EXPORT
JR16773STEP NAME IS GENERATED ECEED 80 CHARACTERS DURING ETI/DWC INTEGRATION
JR16777APPLICATION GETS SQL0805 ERROR ON SQLLF000 PACKAGE
JR16788COMMAND CENTRE NOT GENERATING THE PROPER SQL CODE TO UPDATE A TABLE WITH A COLUMN WITH TEXT EXTENDER DATA TYPE.
JR16796PACKAGED CURSORS REFERENCING SYSIBM.SYSROUTINES DOES NOT MAKE USE OF USER CREATED INDEXES
JR16800DBA2187E IN COMMAND CENTER AT DELETING THE LAST ROW OF RESULT
JR16807LOAD EXCEPTION FAILS IF EXPT'N TABLE NAME IS PREFIX OF TARGET T
JR16818EMAIL NOTIFICATION FAILS WHEN USING MICROSOFT EXCHANGE MAIL SERVER.
JR16826TARGET TABLE NAMES STORED WITH DOUBLE QUOTES SO THE EXPORT TO OLAP INTEGRATION FAILS WITH INVALID TABLE NAMES
JR16830DWC IMPORT FAILS WITH DWC03103E
JR16831. DBCFG: PARMS DBHEAP BEING TRUNCATED TO SHORTS IN CC
JR16834SQLJ BINDING SQL_BLOB AS SQL_LONGVARBINARY, AND HENCE TRIGGERING SQL0301, DATATYPE MISMATCH, AND CAUSING REDESCRIBE.
JR16836LONGVARCHAR PARAMETER NOT BOUND WHEN USING SETASCIISTREAM TO ADDBATCH.
JR16838ENTERING AN EVENT MONITOR NAME WHICH IS TO LONG BRINGS UP DR. WATSON MSG. SAYING THE APPLICATION IS GOING DOWNS
JR16839AGENT TRAPS WHEN TOO MANY MESSAGES DURING FETCH/INSERT
JR16851JDBC RSMD GETCOLUMNTYPE API RETURNS INCORRECT VALUE WHEN UDT IS USED
JR16852DWC CREATES INVALID STATEMENT RESUME YES REPLACE ON OS/390.
JR16853EVENT LOG FILLING UP WITH ERROR MESSAGES DURING DATA PULLS IN THE DATA WAREHOUSE CENTER
JR16854DWC GUI TABLE SCHEMA PROBLEM
JR16859CC SAMPLE TABLE FAILS ON CALL GETBIGDECIMAL() IN STACK.
JR16860SQL0104 WITH TIMESTAMPDIFF FUNCTION IN AS400 V5 ENVIRONMENT
JR16863LOB OUTPUT PARAMETERS FOR A STORED PROCEDURE ARE NOT PROCESSED CORRECTLY WHEN THERE ARE RESULT SETS RETURNED.
JR16866INCORRECT RESULTS WHEN USING INTERSECT WHEN SEARCHING FOR NULL ARGUMENTS WITH CHECK CONSTRAINT DEFINED
JR16869WIN 2000: DNS LENGHT RESTRICTION <= 16 CHAR
JR16873OS/390 SPUFI DYNAMIC COMMIT IS REUSED BY OTHER STATEMENTS
JR16880SQL0901N ' BAD PLAN: UNRESOLVED QNC FOUND ' FROM SQLRFAKE / SQLNG036 INTERFACE RUNNING A QUERY INVOLVING OLAP FUNCTIONS.
JR16881THE DB2DIAG.LOG SHOWS AN ERROR OF 2201 0000 FROM THE FUNCTION SQLOINITWAITPOST AT PROBE 20 ON OS/2
JR16882USING UNC ('\\') PATHS IN WINDOWS SILENT INSTALL DOES NOT WORK PROPERLY.
JR16884STORED PROCEDURE BUILDER: RIGHT CLICK PROCEDURE, SELECT DROP, DOES NOT DROP PROCEDURE FROM DATABASE
JR16887RS.GETSTRING GETTING CLOB, CLI0002W CAUSED DATA CORRUPTION
JR16890TRUNCATED SQL30081 MESSAGE DUE TO INCORRECT UNICODE STRING LENGTH RETURNED TO APPLICATION.
JR16897ONLINE BACKUP HANG
JR16901DBA2192E ERROR WITH SQL1403 ON CONNECT, CONNECT FAILS BUT CAN STILL CREATE TABLE BUT CANNOT SELECT ANYTHING
JR16902COMMENT ON TABLE .. FAILS WITH SQL0104 IF PATCH1=65536 IS SET
JR16907SQL WARNINGS CAUSES XML EXTENDER TO FAIL.
JR16908<![CDATA[TEST / WITH SPECIAL CHARS]]> DOES NOT WORK IN SHRED.
JR16916FP5-INITIALIZATION OF CONTROL DB RETURNS -1403
JR16922SQL0804 WITH NO ERROR TOKENS WHEN CALLING A DB2XML STORED PROCEDURE WITHIN A SQL STORED PROCEDURE
JR16924RELAXING THE RESTRICTIONS THAT ARE IN PLACE WHEN DEPENDS-ON RELATIONSHIPS ARE PRESENT, RESULTING IN CHEAPER PLAN.
JR16925IDENTITY COLUMN NOT FLAGGED AS SUCH IN CONTROL CENTER
JR16938SQL0637N RETURNED WHEN USING THE OPTIMIZE FOR CLAUSE BEFORE A FETCH CLAUSE
JR16939FAILOVER BY MOVING ONE DB2 GROUP IN CLUSTER ADMINISTRATOR FROM
JR16940ERRORS WHILE USING ARRAYS OF PARAMETERS AND ODBC ESCAPE CLAUSES
JR16941EVENT VIEWER ERROR STATING THAT DB2PERF.DLL IS NOT ALIGNED ON 8 BYTE BOUNDARY WHEN VIEWING PERFORMANCE MONITOR INFO
JR16943THE FILE_WAIT SAMPLE USER-DEFINED PROGRAM DOES DELETE FILES WITHEMBEDDED BLANKS.
JR16944THE ODBCTEST.EXE PROGRAM TRAPS WHEN A TABLE OWNER NAME IS NOT SPECIFIED.
JR16947SQLCANCEL CALL TO STATEMENT HANDLE ON SEPARATE THREAD DOES NOT WORK WITH NET DRIVER.
JR16948DATE VALUE FROM DB2 FOR OS/390 IS NOT CONVERTED CORRECTLY IN CLI
JR16951DB2 CONNECT REQUESTING ORIGINAL ROWSET SIZE, INSTEAD OF OUT- STANDING ROWS, WHEN SERVER UNABLE TO RETURN THE COMPLETE ROWSET
JR16954SNAPSHOT HANGS DURING A ROLLBACK CAUSING ALL OTHER DB2 OPERATIONS TO HANG UNTIL ROLLBACK IS COMPLETE - REFER TO JR15963
JR16955USER WITH PASSWORD LONGER THAN 8 CHARS, IS NOT ABLE TO RESTORE ADB IMAGE. GETTING SQL2041 MESSAGE.
JR16959SQL0901 WHEN GOING TO AN AS/400 DATABASE THROUGH CONTROL CENTER (SIMILAR TO JR16649)
JR16968SIGNAL #10 SIGBUS 'ALIGNMENT TRAP' FOR REMOTE CONNECT ON 1.X ARCHITECTURE FOR HP
JR16969MAY CAUSE PROBLEMS IF ISSUING A DB2 RESTORE WITH A VENDOR SHAREDLIB THAT USES STATIC VAR. LIB WON'T GET UNLOADED UNTIL DB2STOP.
JR16977XML EXTENDER GETS ERROR WHEN HANDLING MULTIPLE TRANSACTIONS
JR16978CREATE NICKNAMES FOR THE HOST'S TABLES VIA THE CC GETS SQL0204
JR16989CONTROL DATABASE MIGRATION TO DO CLEANUP OF DANGLING OBJECTS
JR16990CREATE_TABLE_DDL MISSING NOT LOGGED COMPACT ATTRIBUTE
JR16994BINDING BEHAVIOUR CHANGING BETWEEN A V6 HOST AND A V7 HOST, WHENUSING STORED PROCEDURES
JR16998CHANGING SCREEN RESOLUTION BETWEEN SPB SESSIONS MAY CAUSE SPB DIALOG WINDOW TO BE TOO LARGE TO FIT ON SCREEN
JR17001COMMAND CENTER ON WIN NT WITH FIXPACK 5 CONNECT TO A REMOTEDB SELECT FROM ATABLE REPORTS DBA2191 DATABASE NOT CONNECTED
JR17004MOVE OF A DR TO A NEW IR CAUSED PROBLEM IN STEP
JR17005DBA4010 FROM CONTROL CENTER WHEN LISTING APPLICATIONS
JR17008XTSERVER HANGS WHEN VWKERNEL IS RECYCLED
JR17009TRAP IN SQLRISIN() WHEN QUERYING TABLES THAT INCLUDE A SPATIAL EXTENDER COLUMN
JR17023INTERMITTENT CLI0102 AND SQL0301 ERRORS
JR17025USING A SCHEMA OTHER THAN IWH CAUSES ERROR WHEN OPENING THE WIP
JR17032IMPORT SDE FAILS WITH CLI0612E
JR17036FETCHSIZE SUPPORT IS IN JDBC NET DRIVER BUT NOT IN APP DRIVER.
JR17039SQLSTATE=42603 WHEN USING KEYSET CURSOR WHEN LARGE TABLE
JR17042-1131 IS OCCURRING INTERMITTENTLY ON ANY JAVA SP.
JR17051NT TRAP IN SQLNR_MERGE_SCALARSUBQ
JR17052JDBC IS NOT DROPPING CONNECTION HANDLES IN CLI WHEN CONNECTION ERROR OCCURS, CAUSING HANDLES TO RUN OUT.
JR17054TRAP IS OCCURING IN SQLJGETSRVADDR IN A SYSPLEX ENVIRONMENT
JR17055JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN CONNECTING VIA COMMAND CENTRE
JR17068IMPORT AND EXPORT CAUSING HE CONTROL DATABASE TO BECOME CORRUPT
JR17114SQL20020N WHEN CREATING JAVA SP FROM REMOTE CLIENT
JR17167DB2DART TOOL MEMORY BUFFERS LIMITATION TO CHECK SMP
JR17689SPB RECEIVES CLI0102E WHEN CODE EXCEEDS 32K
APAR fixes included in U481413 (Fixpak 6)
APARABSTRACT
GG04218FULL REFRESH APPLY TROUBLE WHEN HANDLING MANY COLUMNS
GG04238ASNLOAD SHOULD NOT ISSUE RUNSTAT
IC32474CANNOT CREATE MAPPING FOR SYBASE TEXT DATA TYPE
IY18694CREATE NICKNAME IS NOT PICKING UP THE STATISTICS FOR A DRDA HOSTTABLE.
IY19335RESTORE OVER INCONSISTENT DB FAILS DURING IMPLICIT CONNECT
IY21200RELATIONAL CONNECT(TWO DBS ON TWO DB2 EEE /AIX,SELET FAILS. WHENIT'S AGAINST TWO TABLES ON TWO DBS. SELECT FROM ONE DB IS FINE)
IY21417UNION ALL ON A VIEW FAILS WITH SQL0840N
IY22389A CORE FILE WAS GENERATED WAS DUE TO A SIGNAL 11 TRAP IN THE DB2GOVD PROCESS. IT'S A 'BAD POINTER' PROBLEM.
IY23155DB_BAD_FAT MESSAGE IN DB2DIAG.LOG WHEN FORCE APPLICATIONS OCCURS.
IY23952-902 RC=147 FROM SQLRIEVS() EVENT MONITOR
IY24275AFTER DB2 PREPARESTATEMENT EXECUTEBATCH( ) COMPLETES, SAME PREPAREDSTATMENT EXECUTEBATCH( ) MAY OR MAY NOT CAUSE JVM CRASH.
IY24363INSTANCE TRAPS ON THE SECOND CONNECT TO A DB
IY24412SQLDMDRP() MARKS THE DATABASE BAD.
IY24693SIGNAL 11 ( SIGSEGV ) IN SQLNO_CALCEX.
IY24835DB2 FOR AIX V7.1 DOES NOT SUPPORT STP AND UDF BUILD WITH MF COBOL ON AIX 4.3 - REMOVE RESTRICTION
IY24873DB2 HANG / PERFORMANCE DEGRADATION / 100% SYSTEM CPU AT DIAGLEVEL 4 WITH ' PREFETCH QUEUE FULL ' MESSAGES
IY25020BIGINT NOT NULL DATA CORRUPTED ON DB2/390 BY INSERT/IMPORT
IY25407DB2CC - ADD SOLARIS DYNAMIC LIBRARY TO THE CREATE WRAPPER CODE.
IY25441PROBLEM INITIATING AGENT WHEN SYSTEM RESOURCES (SEMAPHORES) ARE EXHAUSTED. CAUSES SOME AGENTS TO HANG.
IY25640SQL0301 DB2DIAG.LOG ENTRY NOT MEANINGFUL TOKEN FOR PARAMETER
IY25683TURNING ON MONITOR SWITCH UOW AND DOING 'GET SNAPSHOT FOR ALL DCS APPLICAITONS' TRAPS THE INSTANCE.
IY25715WAS APPLICATION JAVACORE IN CLI_UTLCOPYSTRINGSHORT.
IY25777SQL0902 RC=143 TRYING TO DROP A TABLE WHICH IS RECOVERY-ENABLED UNDERLYING PROBLEM IS FILE SHARING VIOLATION ON HISTORY FILE
IY25788OPTIMIZER HAS FULLY QUALIFIED INDEX BUG WITH DETAILED STATISTICS
IY25830LOG ARCHIVAL HANGS DURING CRASH RECOVERY WHICH HANGS THE ENTIRE CRASH RECOVERY.
IY25843CAN NOT DROP A NICKNAME THAT HAS AN INDEX ON THE REMOTE TABLE
IY25845ASNLOAD BUILD PROBLEM - BIND PACKAGE NAMES NEED TO BE INCREMENTED
IY25864WHEN CREATE A NICKNAME ON AN ORACLE REMOTE TABLE, CLUSTERRATIO IN SYSCAT.INDEXES IS ALWAYS EITHER 0 OR 100. THIS IS INCORRECT.
IY25894TABLESCAN ON 390 FOR CALLING STORED PROCEDURES SHOULD USE INDEX (APAR 1 OF 2)
IY25917AUTHENTICATION SERVER_ENCRYPT NOT SUPPORTED WITH V7 FP4 ON AIX 5L
IY25918TABLESCAN PERFORMED ON MVS WHEN CALLING STORED PROCEDURE FROM UDB, WITH CUSTOMER-CREATED INDEX ON TABLE.
IY25973DB2 HANGS DUE TO DEADLATCH IN PACKAGE CACHE SPACE MANAGEMENT - MANY AGENTS IN COMPILING STATE BUT NOT ADVANCING / USING CPU
IY26007INCORRECT CODE PATH PRODUCED CORE DUMP.
IY26015LOGIC OF DELETING QUERY PATROLLER USERS HANDLED BY SQL0556 ERRORHANDLING WAS LEFT OUT OF FIXPACK 4
IY26038A DROPPED REPLICATED SUMMARY TABLE STILL GETS REFERENCED BY A PACKAGE CAUSING FFFFF47A AND THEN DB2 CRASH.
IY26083COMMAND CENTER HANGS INDEFINITELY WITH THIN CLIENT WHEN READ ONLY ACCESS IS GIVEN TO SQLLIB ON THE CODE SERVER.
IY26188WITH NET DRIVER, CLI0111E IS RECEIVED ON EXECUTION OF SECOND PREPAREDSTATEMENT IF FIRST PREPARED STATEMENT IS NOT CLOSED
IY26214LOAD WITH FORCEIN OPTION IS DOING A CODEPAGE CONVERSION, EVENTHOUGH WE SHOULD SUPPRES TRANSLATION BETWEEN CODE PAGES.
IY26261NEW FUNCTION TO ALLOW IN PREDICATE PROVING USING INEQUALITY RELATIONS
IY26268DB2 INSTANCE CRASH DUE TO MEMORY CORRUPTION : DB2 AUDIT BUFFER OVERWRITE CAUSES TRAPS - SQLE_DATABASE_CONNECT_RESET IS COMMON
IY26386SQL1004C DURING ROLLFORWARD COMPLETE AFTER DB2INIDB AS MIRROR ONPTX (NUMAQ) IF THE ACTIVE LOGS RESIDE ON RAW DEVICE.
IY26397ROLLBACK OF A LARGE INSERT OR UPDATE TRANSACTION IS VERY SLOW. INT SOME CASES, IT IS 20 TIMES THE ORIGINAL STATEMENT
IY26402EMP/SMP ERROR MESSAGES REPORTED IN DB2DART OUTPUT AFTER ROLLFORWARD, OTHER SYMPTOMS COULD BE BAD PAGES IN DB2DIAG.LOG
IY26421GET EXCEPTION: STRING INDEX OUT OF RANGE WITHNET DRIVER
IY26437SQL1610N DATA->INODENUMBER IS INVALID RETURNED FROM GET SNAPSHOT ... GLOBAL
IY26441DB2EVMON RETURNS ERRROR: INCOMPATIBLE OR CORRUPTED EVENT TRACE WHEN PRINTING OUT A LARGE STATEMENT, EXIT CODE = 31
IY26471WRONG JAVA CLASS SIGNATURE IS GENERATED WHEN CALLING THE JAVA STORED PROCEDURE SQL4306N WHEN VARCHAR FOR BIT DATA AS PARAMETER
IY26533PROBLEM WITH UNICODE IN CLI.
IY26608CUSTOMER EXPERIENCES MEMORY LEAK WHEN CALLING PREPARED STATEMENT USING JDBC ON A SOLARIS CLIENT.
IY26779DB2 CRASHED WITH SIGNAL 11 TRAP IN GETTRANS() - THE ROOT CAUSE IS PROBE 10 IN SQLPLRM.
IY26826QUERY FAILS WITH SQL0901N. PROBLEM IN SQLNQ_QTB::BOX_COPY ROUTINE.
IY26855CONNECTION CONCENTRATOR CRASHES DB2 CONNECT ON SUN
IY26865LOB MINMEM SUPPORT ADDED
IY26871DB2 CONNECT V7.2 CRASHES ON A SIMPLE QUERY WHEN USING A CLIENT OF UDB VERSION 5.2 FROM AN OS/2 OR AIX PLATFORM.
IY26890CLI0637E ERROR IF THE SQL QUERY STRING CONTAINS TAB CHARATERS
IY26904INCORRECT VALUE IN 'APPLICATIONS CONNECTED CURRENTLY' FIELD OF DATABASE SNAPSHOT
IY26946UNSUCCESSFUL TABLE REORGANIZATION CAN LEAVE DIRTY PAGES AROUND IN THE BUFFERPOOL WHICH RESULTS IN TABLESPACE EXTENT CORRUPTION
IY26954VARIOUS ERRORS (MOSTLY -952 AND -900) RECEIVED FROM VARIOUS OPERATIONS (CONNECT, SELECT, LOAD, ETC.) ON A NON-GATEWAY DB
IY26958REDIRECTED RESTORE OF TABLESPACE BACKUP FAILS WITH SQL2154N
IY26999DB2 CRASH WITH SIGNAL 11 TRAP IN SQLPPROCESSREQUEST()
IY27016SQL1007 WITH QUERY PATROLLER WHEN EXTENDED QUERY IS USED FROM CLIENT TO SERVER. DEFFERED PREPARE MUST BE 0 IN CLI.INI FOR THIS
IY27051SOME CONVERSION TABLES ARE MISSING DURING INSTALL OF DB2
IY27120QP: INTERCEPT INSERT INTO TBNAME SELECT ... STATEMENT
IY27134PROBLEMS WITH CRASH RECOVERY/RESTART AFTER INCREASING LOG FILE SIZE
IY27170CLASSPATH DOES NOT CONTAIN THE COLONS REQUIRED BY JAVA
IY27182PARTITIONING KEY NOT USE FOR GLOBAL TEMPORARY TABLE ON EEE
IY27203IN HPUX, BACKUP TO TSM FAILS WITH SQL2071N - REASON CODE '1'. IT FAILS TO LOAD LIBADSM.A
IY27295TRAP IN SQLQGAPPLICATIONTERMINATION DATAJOINER FUNCTION
IY27307SQL0311 ERROR WITH UNICODE CODEPAGES AND SQLJ PROBLEM.
IY27329CREATE SERVER WITH OPTION PASSWORD 'N' FAILS WITH SQL0551N
IY27392DATABASE COMES DOWN, SQL1042 IN DB2DIAG.LOG FROM FUNCTION SQLEGETAGENTFROMPOOL, PROBE 5.
IY27401FP4/FP5 CONNECT TAKES LONG TIME... ERRORS ARCHIVING OLD LOG EXTENTS
IY27402UDF MEMORY LEAK DIA9999E AN INTERNAL ERROR OCCURRED. REPORT THE FOLLOWING ERROR CODE : "0XFFFF876D".
IY27403DATA TRUNCATION CAUSED BY ENTITY REPLACE DURING SIDE TABLE UPDATE
IY27429CLI MISSES COMMIT AFTER A CLOSE.
IY27458SQL 1042, OR SQL 1072 OCCURS ON DB2START FOR SECOND INSTANCE STARTED ON THE SYSTEM
IY27465CLI0637-CANNOT PROCESS QUERIES WITH STARTING/ENDING BRACKETS.
IY27495ADD SUPPORT FOR SETFETCHSIZE IN JDBC NET DRIVER
IY27501SQL COMPOSITION RESULTS IN: ERRCODE = -58 MSGTEXT = DXXG002E THE SYSTEM IS OUT OF MEMORY.
IY27539MISSING COMMIT AFTER AN UPDATE A BLOB.
IY27540RESTART FAILS DUE TO CRASH RECOVERY ERROR IN SQLPGWLP
IY27544TRAPPED ON THE FILEHANDLE,WHEN DB2 WILL ATTEMPT TO RENAME/DELETETHE LOGFILE (IN SQLPGSPR)
IY27562THE ENVIRONMENT FOR 2 PHASE COMMIT CONNECTIONS OVER SNA FROM DB2/390 V6 AND V7 IS NOT CORRECTLY ENABLED.
IY27575LOW PERFORMANCE TO DISPLAY RESULT SET FOR SP RUNNING FROM SPB
IY27631SIGNAL 11 SIGSEGV IN SQLOGMBLK CALLED FROM SQLE_DB2RA_AS_DB_OPEN
IY27697CASES WHERE DB2 IS NOT KEEPING TRACK OF WHICH LOG FILES HAVE BEEN SUCCESSFULLY ARCHIVED.
IY27790CONNECTION FROM GATEWAY TO OS/390 HANGS WHEN MONITOR SWITCH FOR DFT_MON_STMT IS ON AT GATEWAY, OS/390 THEN TIMEOUT IDLE THREAD
IY27791DB2 CONNECT ABENDS IN DRDA SETUP WITH CONCENTRATOR ENABLED WHEN MULTIPLE USERS ATTEMPT TO CONNECT TO MAINFRAME DATABASE
IY27795CAPTURE MAY STOP CAPTURING DATA FOR OLDER REGISTRATION AFTER A REINIT.
IY27809INVOKING A STORED PROCEDURE THAT RETURNS RESULT SETS WITH LOB. SIGSEGV RECEIVED AT D48A8B34 IN /USR/LPP/DB2_07_01/LIB/LIBDB2.A
IY27906GET SNAPSHOT ERROR SQL1606W AND DB2DIAG.LOG MESSAGE SQM_SQLMPDBREQUESTROUTER ERROR CODE 0X646 ON BUSY SYSTEMS
IY27923SIGNAL #11 IN SQLOFMBLKEX() WHEN CALLED BY SQLRLCLO()
IY27990HASH JOIN PERFORM POORLY IN HP. ROOT CAUSE IS THAT HASH JOIN IS USING LOTS OF SMALL MEMCPY WHICH IS NOT GOOD FOR HP
IY27992SQLSTATE NOT EQUAL TO 00000 ON EXIT IF OPERATION IS SUCCESS.
IY28028SQL2519N -1001 'NOT A VALID DATABASE NAME' ERROR WHEN RESTORING AND MIGRATING AN EEE DATABASE FROM VERSION 5 TO VERSION 7.
IY28036PROBLEM WITH OUTER JOIN REORDERING.
IY28061REMOVE DIAGNOSTIC CODE/PROBES FOR MISSING GENERATED COLUMNS
IY28145DB2SPLIT USES SIGNED CHAR TO STORE THE DELIMITER, IT SHOULD HAVE BEEN UNSIGNED CHAR.
IY28151ISOLATE V7 FROM FUTURE CHANGES IN THE MESSAGING SCHEME.
IY28266INCORRECT RESULTS FROM A QUERY THAT HAS A CASTED PREDICATE
IY28323I/O BOTTLENECK OCCURS AS A RESULT OF XML EXTENDER CREATING MANY SMALL XML DOCUMENTS DURING COMPOSITION
IY28423CORRECT POTENTIAL SECURITY PROBLEM WITH DB2CKPW AND DB2CHPW
IY28448ON FAILURE OF FULL DB ONLINE BACKUP,LEAVES THE TABLESPACE BACKUPIN PORGRESS STATE
IY28478SELECT DISTINCT WITH WHERE CLAUSE RETURNS INCORRECT RESULTS
IY28519TRAP IN SQLOCPCV BECAUSE BPS SENDS A TRIPLET OF DATA WITH NUMENTRIES 1, WHEN IN-FACT THERE ARE NO ENTRIES TO BE SENT.
IY28640DATABASE IS MARKED BAD BUT IS NOT REPORTED TO THE COORDINATOR NODE
IY28721MULTIPLE DELETE THROUGH INDEX COULD DELETE WRONG LINE FROM TABLE
IY28765SQL0551N DURING CREATE TRIGGER USING NEXTVAL
IY28919DB2 CRASH, OR ERRCODE=-81:0 WITH MSGTEXT 'DXXQ021E
IY29062DB2POOLEDCONNECTION LEAK.
IY29159NO BACKUP IMAGE APPEARS ON BACKUP OF 10THE SESSION ON TSM THROUGH CC WITH ERROR DBA1605 NO BACKUP IMAGE INFORMATION WAS FOUND.
IY29167DURING ARRAY INSERT, DB2 HANGS IF THE CONNECTION IS STOPPED WHEN THE PARAMETER SIZE IS GREATER THAN WHAT WAS DECLARED.
IY29172DOING STMT = CON.PREPARECALL ("{CALL BV#TP56.JAGPROC1(?, ?}"): CLI GIVES NO ERRORS AND READS AS CALL BV#TP56.JAGPROC1(?)
IY29175DATBASE BROUGHT DOWN WHEN ENCOUNTER A HEURSTIC ROLLBACK REQUEST ON ATRANSACTION IN TABORT STATE. (EEE)
IY29176MEMORY CORRUPTION TRAP WHEN TRYING TO ENABLE EVENT MONITOR ON UDB V6.1 EEE
IY29313SQL2048,RC=4 WHEN ONE OF THE DB2RHIST* FILES IS MISSING.
IY29314CRASH RECOVERY COMPLETES EARLY
IY32714SQLGETDIAGREC() RETURNS WRONG ERROR CODE ON DB2 V7.2 FP5
IY36112ON AIX5 WITH REGATTA P690 HARDWARE, MISSING SYNC INSTRUCTIONS FROM DB2 MAY RESULT IN CRASHES OR OTHER UNEXPECTED BEHAVIOUR
JR15805KEYSET CURSOR DOWNGRADES TO FORWARD-ONLY INSTEAD OF STATIC
JR16046PROBLEMS WHEN CREATING A TABLE VIA THE CONTROL CENTER IF THE COLUMN IS A UDT DATATYPE
JR16458OLEDB NOT BINDING PARAMETERS TO STATEMENT.
JR16459ADO PARAMETERS.REFRESH DOES NOT WORK WITH CALL STATEMENTS.
JR16475SQL0901N ACCESSING MULTISITE FROM CONTROL CENTER USING DB2CODEPAGE=1208 ON CLIENT.
JR16539SAME PACKAGE NAMES BEING USED AS PREVIOUS FIX PACK IN V7 IS CAUSING DEADLOCKS
JR16564MAPPING COLUMNS TAKES A LONG TIME IN THE COLUMN MAPPING PAGE
JR16566DB2RFPEN UTILITY NOT INCLUDED IN INSTALL IMAGESFOR V7. DB2RFPE N MARKS THE DATABASE IN ROLLFORWARD PENDING STATE.
JR16584SQL30090N OPERATION INVALID FOR APPLICATION EXECUTION ENVIRONMENT. REASON CODE = '11'
JR16605DEFAULT TARGET GENERATION OF FLAT FILES WITH MIXED CASE COLUMN NAME DOES NOT WORK.
JR16613THE ORDER OF ROWS RETURNED FOR A SELECT DISTINCT STATEMENT WITH AN ORDER BY CLAUSE IS SOMETIMES INCORRECT USING DB2 FEDERATED
JR16635SQL0423 WHEN SELECTING CLOBS THROUGH OLEDB DRIVER
JR16637DWC IMPORT WITH PERIOD ('.') IN THE PATH NAME
JR16639IMPORTING A TAG FILE FROM R/O DIRECTORY RESULTS WITH ERROR
JR16649SQL0901 WHEN GOING TO AN AS/400 DATABASE THROUGH CONTROL CENTER
JR16650IMPORT FAILS WHEN IMPORTING TAG FILE WITH MORE THAN ONE FOREIGN KEY
JR16653ODBC APPLICATION GET'S SIGSEGV WHEN TRYING TO DISCONNECT FROM THE DATABASE WHEN DB2CODEPAGE IS SET TO 1208.
JR16654ADDING THE IGNORE UDT OPTION TO THE SYBASE WRAPPER FOR RELATIONAL CONNECT.
JR16663THE DB2SAMPL SCRIPT SHOULD NOT ISSUE A DB2START PRIOR TO CREATING SAMPLE DB
JR16695SQLPUTDATA ABENDS ON LOB INPUT SIZE > 64K. TRAPS AT DB2CLI!CLI_UTLCOPYSTRING
JR16699CANCELING OUT OF OPENING SPB NEW/OPEN PROJECT SCREEN CAUSES OPEN/NEW PROJECT SELECTION UNDER 'FILE' MENU OPTION TO BE DISABLED
JR16710UNABLE TO CONNECT USING SUN JNDI PROVIDER WITH LDAP.
JR16715NEED TO TRUNCATE COL SIZE FROM 1GB TO 128KB FOR SOME MSSQLNT DT
JR16717DB2CKBKP FAILES TO CHECK THE BACKUP IMAGE IF THE IMAGE IS IN MORE THAN ONE TAPE.
JR16718FLAT FILES COLUMN NAAMES END UP WITH MULTIPLE '' '' AROUND THEM
JR16722CONNECT FROM SPB TO OS/390. SELECT BUILD AND RUN A STORED PROCEDURE TWICE. THE PROGRESS INDICATOR IS NEVER CLEARED.
JR16726DATA TRUNCATION DUE TO INVALID CONVERSION DURING CASING FROM INT(4-BYTE) TO SHORT (2-BYTE) AND LOSING HIGHER ORDER BYTES
JR16729TRAP WHEN GOING AGAINST DB2 ON OS390, DUE TO MEMORY CORRUPTION
JR16731CHANGE HANDLING OF VARCHARS FOR COBOL STORED PROCEDURES, TO USE LEADING LENGTH BYTES AND NOT NULL-TERMINATED STRINGS.
JR16734WIP PROBLEMS IN DATA WAREHOUSE CENTER (DWC)
JR16744SQL3324N COLUMN 'COL1' HAS A TYPE OF '456' WHICH IS NOT RECOGNIZED ' ERROR WHEN SELECTING A VARCHAR COLUMN WITH PASSTHRU
JR16752WHEN YOU USE THE SQL BUILDER TO EDIT A USER DEFIEND COLUMN THE MAPPING FOR THAT COLUMN IS LOST.
JR16757CALLING SQLJ.REFRESH_CLASSES() ON CLP CAUSES CRASH ON DB2BP.EXE
JR16768CARRIAGE RETURN IGNORED FOR SELECTS WHEN STATEMENT TERMINATION CHARACTER OPTION UNCHECKED AND AUTO-DISPLAY QUERY RESULTS CHECKED
JR16769QUERY PATROLLER QUERY ENABLER INTERVAL REDUCING
JR16772DB2 UDB STORED PROCEDURE BUILDER VERSION 7 WITH FIXPAK 5 FAILS WITH SQL0102N (AND DB2 TRAP) WHEN BUILDING JAVA PROCEDURE
JR16774THE COMMAND HISTORY SIZE OPTION OF THE DB2 UDB COMMAND CENTER ISERRONEOUSLY RESET TO THE DEFAULT OF 20.
JR16778IMPORT INSERT_UPDATE ABEND (SQL0007N) FOR UDT WHEN COLUMN NAME LENGTH EQUALS TO 18
JR16781DB2DARI PROCESS CREATED EVEN WHEN KEEPDARI IS SET TO 'NO' IN THEDB CFG.
JR16784CASCADING PROBLEMS ENCOUNTERED DURING MIGRATION FROM V5.2 TO V7
JR16814CLI0158E. SEE ERROR IF A PARAMETER CHANGES FROM SQL_DATA_AT_EXECTO NOT. TMP FILE ISSUE WITH LOB OBJECTS.
JR16829SELECT DISTINCT IN INSERT STATEMENT DOES NOT RETURN CORRECT RESULTS.
JR16855DWC FP5 INSTALL AGENT DAEMON AUTOMATICALLY
JR16856COLUMN TRUNCATION CAUSES CLI0615
JR16894CLI0119E DURING XA CONNECT FROM JTA THEN SUBSEQUENT SQL30090N WITH RC=6. APPLICATION RESTART RESOLVES THE PROBLEM.
JR16896SQL3966N RECIEVED WHEN ATTEMPTING TO COMPLETE A PREVIOUS SYNC SESSION
JR16914CONTROL CENTER DOES NOT DISPLAY DCS DB NAME CORRECTLY WHEN HOST IS AS/400.
JR16917IN DB2 CONNECT V6.1, WHEN A EXTDTA IS SENT TO THE HOST, DB2 CONNECT SENDS 2 EXTRA BYTES THAT THE HOST DOES NOT UNDERSTAND.
PQ44819ADD PARAMETER CCSID CLAUSE TO CREATE FUNCTION AND CREATE PRECEDURE STATEMENTS
PQ57681ADD TABLE_SCHEMA COLUMN TO THE PRIMARY KEY OF THE XML_USAGE TABLE.
SE03514DB2-UDB-XML-EXTENDER PARSER ERROR -85 WITH CCSID 5035
SE03529DB2XML.GENERATE_UNIQUE PRODUCES DUPLICATE VALUES.
APAR fixes included in U480366 (Fixpak 5)
APARABSTRACT
GG04225SQLCODE313 IN CONFLICT COMPENSATION REPLICA UPDATE ANYWHERE
GG04227APPLY SKIPPED A RECORD IN 'FROM ORACLE' CASE
GG04230APPLY FAILED WITH SQLCODE100 DURING COMPENSATION
GG04233APPLY NEEDS TO TOLERATE SQLCODE +191 WHEN FETCHING ANSWERSET
GG04234ASNSAT COMMAND DISABLES SATTELITE CLIENT WHEN CONFLICT IS DETECTED AND CORRECTED
GG04235MEMORY REFERENCE ERROR RUNNING APPLY WITH UPDATE ANYWHERE SUBSCRIPTION.
GG04237USING COMMIT(N) WITH UPDATE ANYWHERE OR PEER TO PEER REPLICATIONMAY CAUSE APPLY TO FAIL WITH SQLCODE530
IC28524MSGDB1210354E QEND DOING SQL TO DB2 FOR OS/390 WHERE DECIMAL POINT IS COMMA
IC32019WHEN WRITING A QUERY USING A LOCAL DB2 VIEW INVOLVING NICKNAMES,THE PREDICATES ON THE QUERY ARE NOT PUSHED DOWN
IY17818DEFUNCT DB2SNMPD PROCESSES ARE NOT REMOVED
IY19211LOCK CONTENTION ( POSSIBLY RESULTING IN SQL0911N ) WHILE USING THE EXPORT UTILITY
IY19519PREP TIME FOR A NUMBER OF QUERIES IN AN SAP BW SYSTEM UNACCEPTABLY HIGH @ OPTLEVEL 5
IY20186TABLE QUEUE COST MODEL FIX.
IY20209CONTROL CENTER HANGS ACCESSING EEE TABLESPACE DATA
IY21446CLI APP WITH MINMEM ENABLED CRASHES WHEN INSERTING INTO DB2/390
IY21460USING DB2MOVE WITH EMPTY STRING OR SPACES FOR THE LOB FILE PATH CAUSES FILE/DIR DELETION STARTING FROM THE ROOT DIRECTORY.
IY21683SQL0802N DURING AVERAGE COMPUTE
IY21804WAS: DATABASEMETADATA.GETTYPEINFO NOT COMPLIANT WITH JDBC SPEC
IY22567AN ATTEMPT IS MADE WITHOUT USER/PASSWORD WITH ASNLOAD
IY23058DB2LOOK DROPS FOR BIT DATA IN CREATE DISTINCT TYPE DEFINITIONS
IY23067INSTANCE CRASH AND TRAP AT SQLJDRD1
IY23142DATABASE MARKED BAD DURING QUERY DUE TO SQL0902 RC=126
IY23286PARALLEL CRASH RECOVERY FAILS WHEN NO DATA ON PARTION (EEE)
IY23330GET RID OF SQLT_TRACE_INIT AND GETPID() WHICH ARE CAUSING HIGH CPU USAGE ON SOLARIS.
IY23336CREATE TRIGGER FAILS WITH SQL0551 FOR ALL NON DBADMS
IY23445CHANGE THROUGH CCA PROPERTIES BLANK OUT DCS PARAMETERS
IY23494QP CANNOT HANDLE SUFFICIENT OUTSTANDING CONNECTION REQUESTS
IY23518SOME 'SHARED SEGMENT NOT READY' ERRORS (PROBABLY OSS ERRORS) IN DB2DIAG.LOG, MAKE THE DQPSTART END UP WITH DB210045
IY23615ADDITION OF EURO SYMBOL TO THE 1143 CODEPAGE CONVERSION TABLES
IY23644INSTANCE CRASH WHEN FORCING A STORED PROCEDURE THAT IS CREATING AN INDEX
IY23655TRAP IN SQLRL_DUMP_USERTEMPS
IY23687. UNABLE TO CHANGE PASSWORD THROUGH ODBC WINDOW.
IY23717JAVA APPLICATION TRAPS ON SOLARIS MACHINE AND THE SATCK TRACEBACK IS CORRUPTED.
IY23752ALL DB2 COMMANDS HANG DURING MONITOR ACTIVITY. WAITING FOR LATCH
IY23787DB2 UDB RESTORE FROM MULTIPLE NAMED PIPES RESULTS IN ERROR SQL2546N.
IY23851CORRUPTION INNON UNIQUE INDEXES CREATED IN PARALLEL IN V72 WITH DB2_INDEX_2BYTEVARLENREGISTRY VARIABLE SET
IY23910WHEN EVENT ANALYSER IS USED TO READ AN EVENT MONITOR FILE, ERROR - DBA5357: UNEXPECTED DATA WAS FOUND AT OFFSET ...
IY23913QUERY PATROLLER MONITORING ON THE NODE ADMINISTRATION PANEL OF QUERYADMIN SHOWS THE DISK AVAILABLE FIELD AS '15,000,318,652,550
IY23944DB2 CONNECT TO DB HANGS WHEN WRITE SUSPEND IN ON AND A LOCK SNAPSHOT IS TAKEN WHILE A TRANSACTION WAS ROLLED BACK.
IY23945'SQLOCSHR' LEAKS MAPPED SHARED MEMORY IF FAILURE OCCURS IN 2ND STATE ATTACHMENT. PROBE:220IN SQLOCSHR IN DB2CART.
IY23972SIGNAL 11 TRAP IN SQLNO_POST_PASS
IY23993DB MIGRATION DOES NOT INITIALIZE CORRECT VALUE OFCOLSEQ IN SYSIBM.SYSINDEXCOLUSE FOR SOME INDEXES
IY23995DB2 UDB - DATA IS INCORRECTLY TRUNCATED WHEN IMPORTED INTO CLOB OR VARCHAR COLUMNS USING THE CODEPAGE OPTION OF IMPORT COMMAND.
IY24024ANY WITH ABILITY TO PERFORM SET INTEGRITY ... OFF ON A SINGLE TABLE MIGHT PUT THE OTHER SPECIFIED TABLES INTO CHECK PENDING
IY24037SPB HANGS WITH NULLPOINTEREXCEPTION WHEN EXECUTE SP WITH >=20 PARAMETERS
IY24068CLI PROBLEM/CORE IN MULTI-THREADED SIEBEL ENVIRONMENT
IY24076POOR PREPARE TIME WITH DISTINCT CLAUSE AND TRANSITIVITY
IY24089STORED PROC LEAVING OPEN HANDLE WHEN FEDERATED QUERY ERROR
IY24118WRONG ACCESS PATH CAUSING DEGRADED PERFORMANCE
IY24157VB APP CRASHING USING OLEDB PROVIDER IN V7.2 AFTER NETWORK CABLEREMOVED DURING APPLICATION EXECUTION
IY24178COMMAND CENTER, ATTACH TO DB USE INTERACTIVE TAB, THEN ATTACH TOSECOND DB, ISSUE QUERY, RESULTS FROM FIRST DB.
IY24187GETTING SQL0301 WHEN INSERTING TIMESTAMP INTO A DATE COLUMN
IY24281DB2DIAG.LOG ENTRY : UNABLE TO FIND/REMOVE TABLE FROM NOLOG LIST : THIS SHOULD NOT BE LOGGED FOR DECLARED USER TEMPORARY TABLES
IY24308WHEN OUTER JOIN ELIMINATION IS CHOSEN BY THE OPTIMIZER A -901 INSQLNO_FF_GET_COL_INFO OR TRAP IN SQLNR_BUILD_EQUIV MIGHT OCCUR.
IY24331ABNORMAL TERMINATION ON EXTRACT UDF'S DUE TO XML EXTENDER MEMORYLEAK
IY24370DROP NICKNAME COMMAND CAUSES TRAP IF AN ALIAS NAME FOR THE NICKNAME IS SPECIFIED INSTEAD OF THE ACTUAL NICKNAME NAME.
IY24379MONITORING CAUSES EEE RECOVERY FAILURE
IY24386WITH DB2ROUTINE_DEBUG=ON SET, EVERY OTHER TIME YOU CALL STORED PROC FROM COMMAND LINE YOU GET SQL1131.
IY24410CLI0614E WHEN USING THE NET DRIVER
IY24413DB2 TRAPS WITH MULTIPLE RESULT SETS WITH MIXED ENGINE ENVIRONMENTS (INTEL VS UNIX) - PROBLEM WITH STORED PROCEDURES.
IY24423DB2 UDB - INSTANCE CAN CRASH - TRAP IN SQLRR_CONNECT_OPTIONS WHEN MULTIPLE ACTIVATE/DEACTIVATE COMMANDS ARE ISSUED.
IY24426SQL0151N WHEN UPDATE A VIEW THAT HAS >1 EXPRESSION COLUMN IN COMMAND CENTER
IY24468DSNL500I RC=0864 MESSAGES ON THE OS/390 CONSOLE FOR EVERY TWO PHASE STRUCTURED DISCONNECT.
IY24573MEASSAGE FROM CLI_SDAINITSQLDAPARMFILING DB2DIAG.LOG FILE WITH ERROR 2064.
IY24577APPLY RECEIVES FREAD ERROR WITH RETURN CODE OF 872105.
IY24613DB2 CRASH, TRAP IN SQLJRCEPKGSNL FOR SUN SOLARIS GATEWAY USING DB2 CONCENTRATOR CALLING SP ON OS/390 RETURNING RESULT SETS
IY24650CREATE DATABASE LOGON WINDOW IS HIDDEN BEHIND PROGRESS INDICATOR
IY24684DB2 LINUX/390 DOES NOT YET SUPPORT ADSM/TSM BUT 'DB2ADUTL' AN 'DSMAPIPW' WERE SHIPPED.
IY24687IMPORTS A MULTI-COMMAND SCRIPT FROM COMMAND CENTER AND RUN SCRIPT: IT FAILS WITH SQL0104N ABOUT THE LAST STMT TERMINATION CHAR
IY24757SIGNAL #11 IN SQLBPFPRINTREQUEST
IY24767QUERY REWRITE INCORRECTLY REWRITES AN ASCENDING SORT INTO A DESCENDING SORT CAUSING INCORRECT RESULTS FROM A QUERY.
IY24804TABLESPACE TAKEN OFFLINE BY ROLLFORWARD CAN CAUSE DATA CORRUPTION IF ROLLED FORWARD AGAIN WITHOUT BEING RESTORED FIRST.
IY24807JDBC.NET.DB2DRIVER FUNCTION NEXT( ) RETURNING WRONG RESULTS
IY24808SQL0313N WITH CLI MINMEM MODE
IY24837CODE PAGE CONVERSION FROM UCS-2 TO UTF-8 TRAPS IF OUTPUT BUFFER IS TO SMALL.
IY24847BEGIN ATOMIC STATEMENTS DO NOT WORK WITH CLI - ODBC ERROR 42601 (SQL0104N) IN SQLEXECDIRECT()
IY24859SQL0901, SECTION LENGTH MISMATCH RETURNED IN SQLERRMC DURING TRANSACTION
IY24862INSTANCE HANG : WHILE RUNNING SNAPSHOTS AND TURNING STATEMENT EVENT MONITORS ON AND OFF , HANG CONDITION ENCOUNTERED
IY24904SQL0301 RETURNED AFTER AN ARRAY UPDATE WHEN ONE OR MORE PARAMETER SETS RESULTS WITH AN UNQUALIFIED WHERE CLAUSE.
IY24915SQL0901 WITH SQLNQ_STRING::NAMEFREE DURING QUERY PROCESSING
IY24971CRASH RECOVERY FAILS IN THE SQLMRDO FUNCTION, COMPLAINING ABOUT ERROR DURING REDO WITH FFFFF451
IY24982SQL0501N RETURNED WHEN CALLING SP AGAINST 390 DB AND CURRENTPACKAGESET IS SET IN CLI LAYER BUY APP OR IN DB2CLI.INI
IY24988FEDERATED QUERY OF SQL SERVER 'SYSINDEXES' TABLE RETURNS HEX INSTEAD OF ASCII EQUIVALENTS FOR THE 'NAME' COLUMN
IY25141FORCE THE OPTIMIZER TO NOT CONSIDER LIST PREFETCH IF THERE AREE PREDICATES THAT HAVE HOST VARIABLES. THIS IS NOT THE SAME AS
IY25226WE SHOULDN'T TURN ON THE 4K LOCK REGION FOR NON-AIX PLATFORMS WHEN USING LF/LOBS.
IY25264POOR INSERT PERFORMANCE OF VARIABLE LENGTH COLUMN TABLE.
IY25272. QP NO LONGER WORKS WITH GROUPS AFTER APPLYING FP4
IY25292TRAP IN SQLJIFSR WHEN GOING TO A DB2/390 V.7.1
IY25301XA CONCENTRATOR NOT COMMITING
IY25306XA AND CLI CONNECTION POOLING ARE NOT CURRENTLY COMPATIBLE
IY25314OPERAND DELIMINATION FOR UNION ALL VIEWS WITH GROUP BY
IY25356ABEND IN UDF WHEN SETXXX METHOD CALLED. JAVA UDF.
IY25366SQL0901 SQLRMGJN : CODEPAGE IS '0' INTERNALLY ON SYSINDEXCOLUSE THIS RESULTS IN INDEX KEYS IN INCORRECT ORDER ON THIS TABLE ONLY
IY25369MEMORY LEAK IN MULTI-THREAD CLI APPLICTION
IY25389TRAP IN SQLE_TERM_DJ_ACB WHEN CALLING SQLOFMBLKEX
IY25475JAR ID SCHEMA ISN'T IN SYNCH WITH PROC_SCHEMA. IT IS CASE SENSITIVE WHICH IS SHOULDN'T BE.
IY25484INSERT WITH SELECT WITH AN ORDER BY CLAUSED WAS NOT SUPPORTED. QP WAS INSERTING 1 ROW AT A TIME. VERY SLOW.
IY25644IF BLOCK_ON_LOG_DISK_FULL IS ON AND THE DUAL LOG ARRAY BECOMES FULL, DB2 MAY GET INTO AN INFINITE LOOP.
IY25658SQL30090 RC=3 WHEN CALLING SQLCOLUMNS() IN XA ENVIRONMENT
IY25720LOG SPACE FULL DURING A CREATE INDEX OPERATION. SQLDCREATEINX RETURNS D509 : LOG FILE WAS FULL
IY25748DB2 CLP SELECT JAPANESE CHARACTER GARBAGE
IY25897DUPLICATE RESULTS RETURNED BY QUERY IN EEE ENVIRONMENT
IY26093SQL0206N FOR TRAILING TAB IN COLUMN NAME LIST FOR IMPORT FROM COMMAND WINDOW
IY26097TRAP IN SQLO_TRCE WHEN USING XA & 2PC
IY26151BETTER HANDLING OF LOB FILES
IY26156REDIRECTED RESTORE LOGS MISLEADING MESSAGES IN THE DB2DIAG.LOG.
IY26186IMPROVE THE COSTING FOR QUERIES INVOLVING ANY JOIN WITH A VALUESBOX
IY26231DB2 ON HP TRAPS REPRODUCIBLY IN SQLPARAMDATA() WHEN INSERTING LOBS IN A PIECEWISE FASHION WITHIN SAP 610 ENVIRONMENT.
IY26259SMALL WINDOW FOR INDEX CORRUPTION IN INDEX CREATED WITH MINPCTUSED PARAMETER DURING RECOVERY OF AN INCOMPLETE LEAF MERGE.
IY26280INCREASE AUTOLOADER SOCKET CONNECTION TIMEOUT VALUE FOR SQL6555N
IY26387WITH INTRA_PARALLEL ON, QUERY FAILED WITH SQL0901
IY26403SNAPSHOT MONITORS DO NOT CAPUTRE THE SYSTEM/USER EXECUTION TIMESWHEN V7 CLIENT INTERACTS WITH V6 SERVER.
IY26504NULL INDICATORS FOR OUT PARMS ARE NOT BEING CLEARED PROPERLY FOR PSM MEMORY MODULE (FOR STORED PROCEDURES)
IY26530INCORRECT RESULTS FROM QUERY RELATED TO CSE PREDICATE PUSHDOWN
IY26532DB2AUDIT FAILS WITH AUD0022N WHEN FILE SIZE REACHES 4GIG
IY26533PROBLEM WITH UNICODE IN CLI.
IY26535DB2 APPEARS TO BE MASKING APPLICATION ERRORS BY RETRYING AFTER SQL0301N SQLCODE.
IY26536SQLJ IS BUILDING WRONG HOST VARIABLES FOR THE DECIMAL COLUMN.
IY26557EXCESSIVE REAL MEMORY USAGE RUNNING SIEBEL WITH DB2 ON SOLARIS.
JR15627MESSAGE QUEUE SIZE (1MB) IS NOT LARGE ENOUGH FOR A HEAVY TRANSECTION DATABASE SYSTEM.
JR15712SNAPSHOT OUTPUT SHOWS 'MAXIMUM ASSOCIATED AGENTS = 0' AND 'AGENTS ASSOCIATED WITH APPLICATION = 1' WHICH IS INCORRECT
JR15831LOAD MISTAKENLY INTERPRETS COLUMN NAMES
JR15877INSTANCE CRASH WITH EXCEPT C0000005 ON SQM_GEN_BUFFERPOOL_STREAMFUNCTION.
JR15921SQL3148W DURING IMPORT WITH INSERT_UPDATE MODE
JR15936AFTER SQL0905 FROM DB2 ON OS390, CURSOR IS NOT CLOSED AND ATTEMPTS TO ACCESS CURSOR GETS SQL0519.
JR15963LOCK SNAPSHOT HANGS DURING A ROLLBACK CAUSING ALL OTHER DB2 OPERATIONS TO HANG UNTIL ROLLBACK IS COMPLETE - WORKAROUND
JR16210DB2PROFC IS NOT USING QUALIFIER OPTION TO QUALIFY TABLES BEFORE DESCRIBING - RESULTS IN UNREPORTED SQL0204N
JR16246WHERE THE SOURCE=TARGET BUT INCREMENTAL COMMIT = ON, THE BV.ISATOMIC() FLAG SHOULD BE TRUE
JR16262NOT TO GENERATE MULTIPLE SEMIJOIN FETCH PLANS
JR16263DATE TRANSFORMER DOES NOT HANDLE INVALID DATES
JR16266CAN NOT USE DWC WITH SAMPLE DATA, IF USING ITIALIAN CODE PAGE
JR16272INSTANCE CRASHES WITH DIA9999E AND INTERNAL CODE 0XFFFFF7 WHEN EXECUTING A SPECIAL KIND OF SQL COMMAND
JR16304INIT OF DWC CONTROL DB LOCATED ON AIX ALWAYS GET -1403
JR16339CLI0104 ERROR FROM MS QUERY WHEN TRYING TO CREATE NEW DATA SOURCE
JR16346MEMORY LEAK IN IBM OLE DB DRIVER
JR16348UN ABLE TO EDIT USER DEFINED PROGRAM
JR16350EXPORT TAKES SEVERAL HOURS TO RUN.
JR16351'PART OF OLAP SCHEMA' IS DEFAULT FOR DWC CREATED TABLES.
JR16353SQLGETINFO() WITH SQL_SQL92_VALUE_EXPRESSIONS RETURNS INACCURATEINFO. WITH AS/400
JR16354WHEN RUNNING THE VWPRCPY UDB IN A STEP, THE RESULTANT LOG FILE FTPNNN.FTP SHOWS THE USERID AND PASSWORD (IN THE CLEAR).
JR16361SWAPPING EQUALITY PREDICATE WILL YEILD INCORRECT QUERY RESULTS.
JR16364SQL1022 READ_NODE_DIRECTORY()DOES NOT RETURN POINTER TO NODE DIRECTORY CACHE
JR16366CLOB VALUES NOT INSERTED PROPERLY WITH UNICODE
JR16387CLP CRASHES WHEN RUNNING FROM FILE
JR16397PASSWORD IS IN THE CLEAR, WHEN USER ATTEMPTS TO EXECUTE ETIEXMVS UDP. PASSWORD IS WRITTEN TO A FILE.
JR16412TRAP IN ADD_DCS_APPL_COUNTER, THE THIS POINTER IS OVERWRITTEN.
JR16424MISLEADING DBA3039 WHEN LAST EXPLAINED STATEMENT IS REMOVED FROM HISTORY IN CONTROL CENTER
JR16425UDP IS DOING A REPLACE BECASUE A WRONG TYPE WAS DURING MIGRATION
JR16435CONTROL CENTER PERFORMANCE WITH LDAP - REDUCE SCANNING OF LDAP
JR16441RIGHT CLICK TO ADD DEPENDENCY THE CANDIDATES LIST IS NOT SORTED
JR16443SQL0010N. TERMINATION CHARACTER IS NOT RECOGNIZED IN THE INTERACTIVE TAB IN THE COMMAND CENTER
JR16448SPB: INSERT -> SQL STORED PROCEDURE USES WRONG BUILD UTILITY
JR16449CONTROL CENTER SHOWS BLANK FOR STATUS CHANGE TIME (CONT'D FROM JR16253)
JR16453WHEN SETBYTES() IS USED TO INSERT INTO A BLOB TYPE COLUMN, SETBYTES() FAILS WITH SQL0301N ON BOTH FP3 AND FP4.
JR16456OS/390 REPLICATION SOURCE IN DATAWAREHOUSE THE COLUMN NAMES GET SWITCHED TO UPPERCASE AND THERE IN AN ERROR (CASE SENSITIVE)
JR16460WHEN CONCENTRATOR ENABLED (MAX_LOGICAGENTS > MAXAGENTS) ALONG WITH DB MONITOR SWITCHES, TRAP IN ENGN_SQE WHEN OUT OF MON HEAP
JR16462ROWSTATUSARRAY OF SQLEXTENDEDFETCH SHOULD REFLECT SQL_SUCCESS_ WITH_INFO FOR THE ROW(S) THAT GENERATED CLI0165E
JR16463MIGRATED BUSINESS VIEWS FROM VW V5.2 ARE EXECUTING INCORRECTLY IN V7.2 ENVIRONMENT.
JR16464DWC7906 DOESN'T PROVIDE THE NAME OF THE PREDESSOR STEP THAT FAILED
JR16465PLEASE SUPPORT THE DB2 IDENTITY COLUMNS IN THE WAREHOUSE. WHEN A ROW IS INSERTED IT AUTOMATICALLY ADDS A UNIQUE VALUE IN COLUMN
JR16466CLP DOES NOT TRANSLATE POUND (OTHER) CHARACTERS CORRECTLY.
JR16467DB2DRIVER FINALIZER NOT CLEANING UP JDBC AND CLI RESOURCES
JR16468MIGRATION ERROR 3110 RECEIVED BECAUSE THE BUSINESS VIEW NAME WAS TOO LONG
JR16469LOGON HANG WHEN THE CONTROL DATABASE NAME IS INVALID OR NOT CATALOGED.
JR16470SQLALLOCHANDLE() CALL HANGING IN MULTITHREADED ENVIRONMENT
JR16471RECEIVING A CONFUSING MESSEGE WHEN IMPORTING TABLE DEFINITION.
JR16472PROBLEMS UPDATING THE WAREHOUSE PROPERTIES
JR16482INSERT RETURNS SQL0358,RC=21 ON MACHINE NAMES CONTAINING HYPHEN
JR16483USEREXIT RETURNED ERROR ON ARCHIVE LOG FILE S00000000.LOG FROM C:C:\MYLOGS FOR DATABASE DBNAME
JR16486PROBLEMS WITH SQL ASSIST WHEN THE SOURCE IN AN ORACLE DATABASE
JR16488USEJDBC2.BAT FAILED BUT 'INUSE' SHOWS JDBC2.0
JR16489ERROR CODE: -11 ERROR MESSAGE: GSE0011E SPATIAL EXTENDER COULD NOT DISABLE
JR16490THE WIP PRODUCES TOO MAN DATABASE CONNECTIONS AND THEN EVENTUALLY FAILS
JR16491SQL0301N IN SQLPARAMDATA AFTER APPLYING FIXPACK 3. DEFECT INTODUCED BETWEEN FIXPACK2 AND FIXPACK3 FOR V710.
JR16493"PUBLISH TO ICM" FUNCTION WAS USING THE WRONG USERID AND PASSWORD
JR16494RUN OUT OF VIRTUAL MEMORY WHEN PUBLISHING METADATA TO INFORMATION CATALOG
JR16497DWC INITIALIZATION RUNS NEVER END
JR16498OLEDB MEMORY GROWTH WHEN CALLING SPS WITH PARAMETER MARKERS.
JR16505THIS APAR IS OPENED TO TRACK THE DEFECT#181439:PROVIDE FEDERATEDSUPPORT FOR TYPED PARAMETER MARKER TO INCREASE PERFORMANCE
JR16507NULL INDICATORS
JR16508THE SPB ERRONEOUSLY SETS INPUT VARIABLE STRINGS TO NULL EVEN IF THE USER UNCHECKS THE 'TREAT EMPTY STRINGS AS NULLS' BOX.
JR16515WRONG DB NAME WHEN CONNECTING TO DATABASE FOR EXPORT OF DATA
JR16524INCORRECT SYNTAX ERROR RETURNED FROM CC SHOW COMMAND WINDOW
JR16525CONTROL CENTER PERFORMANCE PROBLEM WHEN CREATING A SUBSCRIPTION
JR16526ADD GETCLOB() AND GETBLOB METHODS FOR CALLABLESTATEMENT
JR16529ON THE SCHEMA MODELLER SELECT VIEW ARRANGE THE SCREEN GOES BLANK
JR16530LABELS DO NOT SHOW UP ON STATISTICS WINDOW UNTIL YOU RESIZE THE WINDOW.
JR16531ZOOM FUNCTION ON SCHEMA MODELLER NEEDS TO BE DISABLED
JR16535GOING THROUGH CCA AND MANUALLY ADD A USER DSN GIVES CCA3000C RC 32 WHEN ATTEMPT TO FINISH.
JR16536CATALOGING PROFILE IMPORTS TWICE GET DIFFERENT RESULT
JR16540SQL UPDATE OF GRAPHIC FAILS. SQL0301N
JR16542SQL0804N WHEN RETRIEVING SPATIAL DATATYPE COLUMN (UDT)
JR16545DATA LINK ARROW INCORRECT IN SCHEMA MODELER
JR16547ZOOM FUNCTION NEEDS TO BE DISABLED
JR16548DATA WAREHOUSE CREATED DEFAULT TABLE IGNORES TABLE SPACE PARM.
JR16550INFORMATION NOT SAVED WHEN USER CAN'T CONNECT TO AGENT
JR16551IMPORT TABLES DOES NOT SHOW PROGRESS INDICATOR LONG ENOUGH
JR16552SINCE SB3 THE LABELS ARE MISSING FROM THE STATISTICS WINDOW
JR16555THE VIEWER FOR THE PROCESS MODELER TAKES A LONG TIME OT OPEN FOR COMPLEX PROCESSES
JR16557DB2CC SAVES WHERE CLAUSE IN LOWER CASE
JR16559ICM CHANGE ETI APP DATA RELATIONSHIP TO CONTAIN FROM LINKED
JR16575IMPORT UNABLE TO CREATE GRAPHIC,VARGRAPHIC AND BLOB COLUMN INTO UNICODE DATABASE
JR16583IMPORTING TABLE DEFINITION INTO AN EXISTING TABLE TAKES TOO LONGIN DATA WAREHOUSE CENTER.
JR16585MS INTERDEV RECEIVES UNSPECIFIED ERROR USING OLE-DB
JR16589UNABLE TO OPEN WIP WINDOW AFTER SORTING
JR16590STORED PROCEDURES W/ CHAR DECLARED DOES NOT WORK AFTER V720 FP4.
JR16591ISSUE A CONNECT STATEMENT FROM INTERACTIVE WINDOW, CONNECTION IS FINE BUT ARE PRESENTED WITH AN ATTACH WINDOW
JR16593LONG VARCHAR (UNICODE-GREEK) DATA IS NOT BEING COVERTED PROPERLYWHEN QUERYING RESULT FROM THE COMMAND CENTRE
JR16594CREATE INDEX ON NICKNAME WITH PCTFREE SPECIFIED RETURNS ERROR, BUT CREATES THE INDEX ANYWAY
JR16595JDBC DEFECTS FOUND DURING J2EE CTS TESTING.
JR16600IF YOU CREATE A TABLE AND ADD A GRAPHIC COLUMN THEN ISSUE A DB2LOOK TO GET THE DDL THE GRAPHIC COLUMNS IS DOUBLED
JR16603RADIO BUTTON IN DWC WILL NOT ENABLE I-SERIES TRANSFORMERS
JR16604THE DB2EVA SORTING WAS NOT WORKING DUE TO A PROBLEM CONVERTING DECIMAL POINT TO A COMMA. THIS IS AFFECTED BY THE SYSTEM LOCALE
JR16608TABLE SCHEMA CHANGE = NO IMPORT
JR16614FROM CLAUSE MISSING IN THE BUILD SQL WINDOW WHEN USING AN ORACLE SOURC
JR16620STORED PROCEDURE BUILDER IS NOT DISPLAYING HEX DATA CORRECTLY
JR16657WINNT DB2MSCS/DB2ICLUS SUPPORT COMPUTER NAME GREATER THAN 8 CHAR
JR16669RUNSTATS CAUSES DB2 TO TRAP IN SQLIPROCESSCOL
JR16676DB2 GATEWAY TRAPPING AFTER RECEIVING DATA FROM A STORED PROCEDURE ON OS/390.
JR16680HANDLING LOCK CONFLICT OF CONDITIONAL LOCK FOR APAR JR16242
JR16694EMBEDDED ASSOCIATE STATEMENT IN SQL PROC. STATEMENT DOES NOT LIKE QUALIFIED PROCEDURE NAMES.
JR16696INFINITE LOOP IN CLI CATALOG CALLS AGAINST VM DB2.
JR16697SIGNAL 11 IN WRITEPAGES
PQ54378IMPORT TABLES GETS 'ASN.IBMSNAP_REGISTER IS AN UNDEFINED NAME', EVEN WHEN NOT USING REPLICATION.
APAR fixes included in U478691 (Fixpak 4)
APARABSTRACT
GG04203APPLY GETS SQL -104 WHEN HANDLING MANY COLUMNS
GG04205ASNLOAD FAILED WHEN INVOKING APPLY USING A NETWORK ID.
GG04206APPLY NOT REDRIVING APPLY WHEN AN RI VIOLATION IS DETECTED IN THE 'F' DIRECTION.
GG04207APPLY IS HAVING PROBLEMS REPLICATING FROM BASE TABLE OF AS/400 BLOB FIELD TO WIN 2000 SERVER RUNNING DB2 UDB EE V7.1.
GG04213CAPTURE FAILS TO PRUNE DB2 LOG RECORDS WITH LOGRETAIN=CAPTURE.
GG04214APPLY DID NOT FULLREFRESH IF CAPTURE COLD START AT REPLICA
GG04215CAPTURE WILL NOT PRUNE LOG RECORD IF LESS THAN 100 RECORDS ARE PROCESSED DURING A START STOP CYCLE.
IC31116USING RELATIONAL CONNECT TO CONECT TO AN ORACLE DATABASE, DB2 CRASHS WITH SIGNAL#11 IN HASH_ENTRY::CLEAR()
IY15472QP CANNOT HANDLE CLI STATEMENT WITH ASYNC ENABLED
IY15730INSTANCE CRASH ON TRAP (SIGSEGV) IN SQLBLATCHPINNEDPAGE EEE ONLY. INTERNAL SYNCHRONIZATION PROBLEM EXECUTING SQL.
IY16963SECONDARY CONNECTS SHOULD NOT BE PART OF APPLICATION CONNECTS INDB SNAPSHOT
IY17251CHANGING DB2 TERMINATE BEHAVIOUR FROM ASYNCHRONOUSTO SYNCHRONOU S
IY17328IBM CLI DRIVER CLI0102E INVALID CONVERSION. SQLSTATE=07006 ENCOUNTERED DURING FETCH OF A BIGINT COLUMN.
IY17499RUNNING A CREATE PROCEDURE THRU THE STORED PROCEDURE BUILDER, CAUSES THE DB2 ENGINE TO CRASH DUE TO STACK CORRUPTION.
IY17522AN APPLICATION SENDING A BAD RID (BOOKMARK) CAUSES DB2 TO PANIC,AND AN ENGINE TRAP DURING A DIRECT FETCH.
IY17526SQL1015N, DATABASE MARKED BAD DUE TO IMPROPER SAVEPOINT HANDLING
IY17563-901, REASON 'NO CAST FUNCTION'
IY17574$N CLAUSE IN CREATE TABLESPACE PROBLEM
IY17631SIG 11 TRAP IN SQLRIRST
IY17651ONLINE DATABASE BACKUPS RETURN SQL2038N RC -3838 AFTER A FAILED CREATE TABLESPACE
IY17698APPLY UPDATED THE WRONG SYNCHPOINT AND SYNCHTIME IN PRUNCNTL TBL
IY17735FLOATING POINT CONVERSION OF STRINGS WITH >8 CHARACTERS FOR SITUATIONS WHERE THE STRING USED IS >8 CHARACTERS.
IY17791SET CURRENT PACKAGESET IS BEING IGNORED BY QUERY PATROLLER.
IY17828TABLESPACE REMAINS IN LOAD PENDING IF ASC/DEL FILE NOT ACCESSIBLE
IY17874LATCH DEADLOCK IN MONITOR CODE
IY17927CHANGE DB2DCLGN OUTPUT TO BE COMPATIBLE WITH WITH DB2 MVS DECLARATIONS.
IY17952BINDING FAILS WITH -30073 SQLCODE (SQLERROR CONTINUE)
IY17967BACKUP RETURNS SQL2048 WHEN IT SHOULD RETURN OUT OF DBHEAP
IY17973CREATE PROCEDURE CAUSES IMPROPER SAVEPOINT HANDLING - FFFFF520 -AND POSSIBLE INSTANCE TRAP
IY17975SIGNAL #11 TRAP IN SQLNR_GBPD_PARTITION DURING SELECT AT OPTLEVEL 2 OR HIGHER
IY18094AN AGENT HANGING IN TQ CODE, ANOTHER STUCK ON APM LATCH
IY18117TRAPS (SIGNAL #6) IN FUNCTION SQM_EVMON::LOG_EVENT()
IY18120APPLICATION WITH MINCOMMIT 4 AND HANGS WAITING FOR LOG DATA TO BE WRITTEN TO DISK
IY18123MEMORY LEAK IN SQLRI_LIKR_ALLOC()
IY18124MAX_SYNCH_MINUTES WITH CCD - APPLY UPDATES THE SUBS_SET SYNCHPOINT INCORRECTLY CAUSING POTENTIAL DATA LOSS
IY18138THE CLP ON SOLARIS CALLS GETPASS WHEN ISSUING AN EXPLICIT CONNECT WITHOUT A PASSWORD GIVEN WHICH LIMITS THE NUMBER OF CHARS TO 8
IY18217CATALOGING ONE DATABASE WITH TWO DIFFERENT ALIASES TO TAKE ON-LINE BACKUPS FOR EEE
IY18219SQL0902 ON SET INTEGRITY WITH IMMEDIATE CHECKED FORCE GENERATED
IY18220DLFSCM_POSTSTART.DFS->RETURNS 0->SUCCESS, BUT 'FAILED'
IY18253LOG DIR FILLS DUE TO OLD LOG FILES NOT BEING DELETED/RENAMED DURING CRASH RECOVERY, AND SAME LOG IS REPEATEDLY ARCHIVED
IY18295SAMPLE USEREXIT SHOULD INDICATE THAT 'MOVE' IS UNSUPPORTED FOR LOG ARCHIVING - ONLY 'COPY' IS SUPPORTED
IY18308A NEW DB2 HISTORY FILE IS CREATED DURING A FAILED MIGRATION, WHICH CAUSES ALL SUBSEQUENT MIGRATIONS TO FAIL.
IY18319MONITOR DCS APPLICATION CONTROL BLOCK WAS NOT CLEANED UP WHEN RUNNING WITH THE CONNECTION CONCENTRATOR ON.
IY18333DB2CFEXP DOES NOT UPDATE DB2CLI.INI SOMETIMES
IY18340SQL0973N WHEN PACKAGE CACHE NOT OVERFLOWED - CAUSED BY NOT ACCOUNTING FOR OSS OVERHEAD.
IY18346STORED PROCEDURE HANGING WHEN COMMIT IN STORED PROCEDURE AFTER INSERT STATEMENT.
IY18373APPLY SHOULD EXECUTE THE SQL BEFORE AND AFTER STATEMENTS FOR A SUBSCRIPTION SET EVEN IF THERE IS NO DATA TO REPL. IN THAT CYCLE
IY18379ON CONNECT REQUEST, TRAP: RQRIOBLK TRIPLET BAD SETUP
IY18433-901 FOLLOWED BY -4946N ON BIND.
IY18453CONTROL CENTER INCORRECTLY FOLDS USERID TO UPPER CASE USING THE NATIONAL LANGUAGE CODE PAGE INSTEAD OF THE ENGLISH CODE PAGE.
IY18499DURING CRASH RECOVERY, WE COULD HAVE A REQUEST TO FLUSH THE LOG TO AN LSN BEYOND THE TAILLSN->RECOVERY FAILS, SHOULD SUCCEED
IY18522NO REASON CODE IS RETURNED WITH SQL1550N FOR SUSPEND I/O AFTER RESTORING
IY18570BACKUP/RESTORE HANG UNTIL DB I/O'S ARE RESUMED WHEN ATTEMPTING TO BACKUP/RESTORE A DB WHICH IS SUSPENDED.
IY18571'SET WRITE SUSPEND FOR DATABASE' COMMAND HANGS UNTIL BACKUP/ RESTORE IS COMPLETE, WHEN ATTEMPGIN TO SUSPEND I/O
IY18600IN JAVA, DOING GETBIGDECIMAL()ON A COLUMN TYPE DOUBLE YOU WILL GET NUMBERFORMATEXCEPTIONIF DOUBLE IS IN EXP. FORMAT.
IY18603SQL0901 - 'COLUMN NO. OUT OF RANGE' ERROR WHEN RUNNING A QUERY FOR A VIEW OF A TABLE WITH ALIAS.
IY18611DEADLATCH IF EVMON AND SNAPSHOTS ARE CALLED IN THE SAME TIME
IY18622CLI APP HANGS FROM CLIENT VIA GATEWAY ON SELECT OF DB2/390 TABLEIF CURSOR TYPE REQUESTED IS NOT FORWARD ONLY CURSOR
IY18626DATA TYPE PROBLEM
IY18644OVERCOSTING THE I/OS OF THE RIGHT HAND (INNER) PLAN OF THE NLJN'S THAT ARE OF THE TYPE THAT THE INNER HAS NO SORTS OR TEMPS
IY18663SQL4908N IS GENERATED WHEN RF ON TABLESPACES IS ISSUED AGAIN ON TABLESPACES WHICH ARE RF PENDING STATE AND FLAG IN LFH IS ON.
IY18704RESTORE HANGS WHEN SERIES OF SUCESSFUL RESTORE OPERATIONS ARE ATTEMPTED ONE AFTER OTHER OR RESTORE EXECUTED WITH FEWER BUFFERS
IY18741MEMORY CORRUPTION OCCURS WHEN USING QP WITH AN APPLICATION.
IY18759ALL-CONTAINERS-CLAUSE ON ALTER TABLESPACE INCONSISTENT SYNTAX
IY18761DATA IS NOT LOADED COMPLETELY FOR AUTOLOAD WHEN USING MORE THAN 1 SPILIT NODE AND DATA IS REMOTELEY LOCATED IN THE HOST.
IY18798ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER PREPARE
IY18815SIGNAL BUS ERROR WHEN TRYING TO FORMAT DB2 TRACE
IY18846DYNIX/PTX ONLY: DARI TERMINATES ON TRAPS IN STRNCPY IN DARI SUPPORT CODE WHEN LARGE NUMBER OF DB2 PROCEESES ARE SPAWNED
IY18916DCS AUTHENTICATION IS NOT SET CORRECTLY FOR DRDA WRAPPERS.
IY18987TRAP IN SQLNO_CRULE_INDEX_ANDING WHEN OUT OF STMTHEAP
IY19003PERFORMANCE DEGRADATION BETWEEN V5.2 AND V71
IY19025CREATE DATABASE STATEMENT USING THE 'WITH' ARGUMENT THAT EXCEEDS30 CHARACTERS RETURNS THE INCORRECT ERROR MESSAGE
IY19033QUERY AT OPTLEVEL 3 RECEIVES A SQL0101 EVEN WITH STMTHEAP MAXED
IY19034NOT ROUTING TO MULTIPLE REPLICATED AST REFERENCES
IY19042ISERIES (OS/400) V5R1 AS A CLIENT DOES NOT INTEROPERATE WITH WORKSTATION DB2 UDB AS A SERVER
IY19084INVALID DEFAULT DATES INSERTED DURING LOAD.
IY19095DB WITH LINKS IN PATH FAILS TO RESOLVE PATH FOR BACKUP. A -1062 OR -1042 RESULTS, SUBSEQUENT CONNECTS MAY TRAP (SIG11).
IY19124CLI TRACE DOES NOT CAPTURE SOME UNICODE FUNCTIONS
IY19173SQLDREDOUPSERT REPORTS A PROBLEM DUE TO INCORRECT MINBUFFLSN DURING UNDO PHASE OF DB RECOVERY
IY19204IN THE EUREKA ENVIRONMENT, DB2QE IS NOT BEING INVOKED, THEREFOREQUERY ENABLER HANGS.
IY19208SQL0901N ' UNKNOWN MEMORY POOL ' RUNNING QUERIES , OR SQL0101N RUNNING QUERY WITH DISTINCT CLAUSE.
IY19212SQL1224 INSTANCE SHUTDOWN - TRAP IN SQLRL_OPEN ON RESTORE DB2DIAG.LOG CONTAINS SQLEFIRSTCONNECT MEMORY ALLOCATION FAILURE
IY19230QUERY REWRITE ISSUE
IY19260CLI0121E ' INVALID COLUMN NUMBER ' RECEIVED IN BRIO APPLICATION USING QUERY PATROLLER
IY19285WAS: BLOB AND SETBINARYSTREAM PROBLEM.
IY19315MS 932 IS EQUIVALENT TO IBM 943. WE ARE ACTUALLY DOING CODE PA
IY19337SMALL TIMING WINDOW WHERE THE CAPTURE READS A LOG WHILE IT IS BEING ARCHIVED -> WORKAROUND: RETRY SHOULD RESOLVE
IY19360SQL0900N: LOAD RECREATE INDEX DOES NOT UPDATE METAROOTPAGE PROPERLY.
IY19369TRAP IN SQLNR_RIJEL_ACTION
IY19386AUTOCOMMIT CANNOT BE TURNED OFF WHEN QUERY PATROLLER IS ACTIVE.
IY19494LONG PREPARE TIME FOR EEE QUERIES INVOLVING MULTIPLE JOINS, WHERE AT LEAST ONE OF THE TABLES RESIDES IN A MULTI-NODE NODEGRP
IY19511DEFAULT VALUE NOT USED FOR GLOBAL TEMP TABLE
IY19530CORRECTION OF THE OUTER_DVALS CALCULATION FOR ORDERED NLJN
IY19532CHANGE DATA LINK DATA TYPE NAME FROM URL TO DATALINK
IY19536ERROR MESSAGE DIA3808C IS INCORRECTLY DUMPED OUT IN THE DB2DIAG.LOG FILE WHEN THE ACTUAL ERROR IS SQL1013.
IY19560. SQL29007 RECEIVED WHEN THE CATALOG NODE IS NOT A QP NODE.
IY19581QUERY PATROLLER MONITOR MAINTAINS PERSISTENT CONNECTION TO DATABASE DB2 UDB EEE 7.2.
IY19606DURING THE DLFM INST MIGRATION, WE ARE NOT UNMOUNTING DLFS, WHICH CAUSES './DB2IMIGR: DLFSMNTPNTS: PARAMETER NULL OR NOT SET'
IY19610DB2BATCH RETURNS ELAPSED TIME 'NOT COLLECTED'FOR INSERT STMT
IY19657WHEN A COMMAND IS RECEIVED, CAPTURE STILL READS A LOG RECORD BUTFORGETS IT, AND READS THE NEXT RECORD AFTER PROCESSING THE CMD.
IY19659SQL5005 SYSTEM ERROR WHEN DOING MIGRATE DATABASE FOR A V5 DB
IY19704DB2LOOK -F REPORTS WRONG DB CFG INFO
IY19786JVM CRASHES WHEN PASSING NULL TO STATEMENT.EXECUTE( )
IY19797TRAP - SIGNAL 11 IN SQLPM_WRITE_LOCKS WHILE PERFORMING LOCK SNAPSHOT CRASHED THE DB2 INSTANCE
IY19809UDB EEE 7.X HAS RESTRICTION NOT ALLOWING INSERT INTO LOCAL TABLEWITH SELECT FROM NICKNAME IF PARTITIONED
IY19813HIGH CPU TIME DURING SNAPSHOTS
IY19878ALTERING SUMMARY TABLE FROM REFRESH IMMEDIATE TO REFRESH DEFERRED IS NOT REFLECTED IN SYSCAT.TABLES
IY19947CUSTOMER IS NOT ABLE TO FETCH DATA IN ITS ENTIRETY AFTER APPLYING FIXPACK 3 ON SAP SYSTEM.
IY19955AUTOLOADER HANGS WHEN USING FILE_TRANSFER_CMD AND LOAD ABORTS
IY19956SQL1042C ON CONNECT TO A CONSISTENT DATABASE TRYING TO ALLOCATE INITIAL LOGS OVER A LOG THAT WAS EXTERNALLY TRUNCATED/CORRUPT.
IY20025DB2 CRASH AFTER RUNNING A FENCED SAP UDF
IY20038DB2PFCHR,DB2PCLNR,DB2REBAL,DB2ESTOR PERSIST EVEN AFTER DBM SHUTDOWN & CONSUME CPU RESOURCES UNTIL REBOOT: RESULT POOR PERFORMAN
IY20047REVERSE INDEX SCAN CAN MISS KEYS IF HIT PARTIAL PAGE SPLIT ROLL-BACK.
IY20049REVERSE SCAN MISS KEYS IF HIT PAGE SPLIT (TIMING).
IY20063SQL0973 QUERY HEAP MEMORY LEAK - CLI ONLY WHEN DATA TYPES OF PARAMETER AND COLUMN DO NOT MATCH, DB/APP USE DIFF CODEPAGES
IY20067DB2 INSTANCE SHUTDOWN: TRAP IN SQLRA_FP_COPY ON ABNORMAL TERMINATION OF DARI AND DROPPING OF CONNECTION.
IY20069PROBLEM WITH DATAPROP/CAPTURE. TIMESTAMP NOT INITIALIZED.
IY20074ACCESS VIOLATION ON NT CLIENT WHEN CALLING STORED PROCEDURE ON UNIX SERVER (V71FP3) WHEN DB2_RUN_PSM_TRUSTED=YES ON SERVER
IY20092RECEIVING A SQL236 WHEN RUNNING LOCAL QUERYS AGAINST QUERY PATROLLER
IY20119HASH JOIN GIVES INCORRECT OUTPUT.
IY20128POOR INDEX CREATE / REORG PERFORMANCE AFTER UPGRADE TO V7.1 FP2 - MMAP I/O WRITES UNINTENTIONALLY DISABLED FOR INDEX OBJECTS
IY20144NO ROWS ARE RETURNED WHN A +437 IS RETURNED IN MINMEM
IY20152SQL0998 RC=13 AX_REG() AND AX_UNREG() NOT FOUND
IY20159ROLLFORWARD STATUS = TABLESPACE, BUT NO TABLESPACE IN THIS STATE -> RESTORE, THEN TBLSPC DROPPED B/F ROLLFORWARD
IY20221SQL4912N WITH SQLJ HOST VAR IN LIKE COMPARISON AGAINST MVS 6
IY20236SQLPUPDATEMINBUFFLSN PROBE:50 SHOULD NOT BE DUMPED INTO THE DB2DIAG.LOG AS IT IS ONLY INFORMATIONAL USED FOR DEBUGGING
IY20319SQLBGETPOOLSTATS CAN CAUSE LOG CORRUPTION
IY20326NESTED SQL SP CALLED WITHOUT QUALIFIER FAILS
IY20360MOVEMENT OF ENCRYPTED DATA BETWEEN PLATFORMS RESULTS IN ERROR SQL20146N
IY20480ADD FUNCTIONALITY TO SUPPORT EEE RESTORE FROM LEGATO AND XBSA
IY20508CATALOG CONTENTION WHEN QP JOBS ARE RUNNING (2)
IY20536TRAP IN SQLCSPC_COOR_REG WHEN HOST EXPERIENCES COMM. PROBLEMS
IY20539PROBLEM WITH V720/IBM JDK 1.2 AND USE OF JAVA SPS
IY20558ACCESSING A BASE TABLE WITH A REPLICATED TABLE DEFINED ON IT CAUSES DB2 TO CRASH - SIGNAL 11 TRAP IN SQLNO_KEY_SAT_KEY.
IY20575SQLM_GENERIC_CONVERT PROBE 10 AT INCORRECT MESSAGE LEVEL
IY20662EMBEDDED RPATH PROBLEMS ON SGI.
IY20693QUERY PATROLLER CAUSES SAS SEGMENT FAULT.
IY20793SQLPUTDATA OF ZERO BYTES IN CAUSING A MEMORY OVERWRITE
IY20795COMMAND CENTER DOES NOT HAVE A SCROLL BAR IN ITS HISTORY WINDOW.
IY20796QUERY RETURNS SQL0950N UNABLE TO DROP TABLE,DUE TO ACTIVE CURSOR
IY20802DB2 CONNECT MAY CRASH WHEN PROCESSING THE REPLY FOR AN APPLICATION THAT IS THE VICTIM OF A DEADLOCK OR TIMEOUT
IY20808SIGNAL #11 IN SQLNO_PROP_JCARD()
IY20966SELECT JOIN FROM MULTIPLE FEDERATED NICKNAMES INTO EEE TABLE => ERROR SQL0901N SQLSTATE=58004
IY20995CALLING STORED PROC. EG.{CALL PROC(1234,?)} CAUSES SQL0171
IY20997POINTER IS NOT INITIALIZED CORRECTLY
IY21046APP_CTL_HEAP_SZ RUNNING OUT OF MEMORY WHEN READING CLOB DATA VIAADO
IY21064DB2BATCH PRODUCES A COREDUMP WHEN ONE LINE EXCEEDS 3896 BYTES / SQL0100W ARE NOT DISPLAYED WHEN RUNNING DB2BATCH
IY21082BUFFER CORRUPTION CAUSES REPLICATION TO FAIL.
IY21083SPLIT MIRROR BACKUP TERMINATED - SMS TABLESPACE NOT ALLOWED.
IY21174RECEIVED SQL8011W ON DB2START WITH RESTART OPTION
IY21204WEBSPHERE STARTUP PERFORMANCE DEGREDATION.
IY21223INSTANCE TRAPS ACCESSING SEQUENCE.
IY21281TRAP IN SQLEGETAGENTFROMPOOL() WHEN CONNECTING TO SYSPLEX ENV ONHOST.
IY21295LIST DCS APPLICATIONS EXTENDED GIVE WRONG STATUS CHANGE TIME
IY21311SPLIT MIRROR ROLLFORWARD COMPLETES PREMATURELY OR SQL1042C , HANG DURING SPLIT MIRROR ROLLFORWARD.
IY21374POUND STERLING SYMBOL FAILS IN DB2 PRECOMPILE.
IY21394THE HOST DB2 DATABASE BACKUP FAILS AS IT SEES THE LINK FILES ON DLFM ARE NOT YET BACKUPED.
IY21410FORWARD FIT FOR APAR IY06126 INTO V6 AND HIGHER
IY21413DB2OPTIONS: CLP IS USING THE OSS FUNCTION SQLOFPRT
IY21443ELSE CLAUSE IN UDF OF V7 FP3 EEE ON AIX PREVENTS OUTPUT OF CORRECT RESULTSET.
IY21449LENGTH OF PARMNAME IS INCORRECT AND ADDING SPACES TO ACTUAL VALUE IN THE SYSPROCPARMS
IY21522APPLY USES THE WRONG PRUNE CONTROL ROW WHEN CAPTURE IS STARTED COLD.
IY21581SIGSEGV IN GET_DBMON_BP, WHEN DROPPING A TABLESPACE
IY21599SQL0902 RC 29 ON COMMIT USING WITH HOLD CURSOR AFTER LOCKLIST FULL CONDITIONS - SQL0912 - ON OPEN / CLOSE
IY21661TRAP / HANG WHEN LOCK ESCALATION OCCURS DURING REBIND AT DIAGLEVEL 4
IY21683SQL0802N DURING AVERAGE COMPUTE
IY21705MISSLEADING ERROR MESSAGE -31 DURING THE BINDING. THE ACTUAL MEESAGE SHOULD BE A WARNING SQL1530W.
IY21710SQL0204N DUE TO INCORRECT SQL STATEMENT BEING GENERATED WITH PATCH1=32768 SET
IY21757IMPROVE QP PERFORMANCE BY ALTERING OPTIMIZATION.
IY21767CONTROL CENTER IS VERY SLOW.
IY21820JDBC BATCHING NOT CLEANING UP OBJECTS WHEN A CLEARBATCH() IS ISSUED.
IY21838SYSFUN.POWER UDF PROBLEMS, NEGATIVE BASE TO POWER GREATER THAN TWO RETURNS INCORRECT RESULTS ...
IY21846DPROPR APPLY DOES 2 FULL REFRESHES AFTER CAPTURE COLD START.
IY21860SQL1042C WHEN LIST APLICATIONIS ISSUED AND THERE ARE CONNECTIONS.
IY21911PSM PUT ROUTINE NOT ACCEPTING STATEMENTS LARGER THAN 32765
IY21917BACKUP TO NAMED PIPES HAS SLOWER PERFORMANCE THAN BACKUP TO A FILESYSTEM
IY21941IF SQLPREP->SQLNUMRESULTCOLS GENS SQL_SUCCESS_WITH_INFO WILL SEE CLI0125E AND HAVE PROBLEMS DURING SQLEXECUTE.
IY21943VB IDE GETS "ERRORS OCCURRED" MESSAGE WHEN TRYING TO GET A LIST OF STORED PROCS WITH NAMES GREATER THAN 8 BYTES.
IY21945DB2DCLGN CHANGES JAPANESE CHARACTER '835F' INTO '832D'
IY21955CORE FILE GENERATED IF ALL PHYSICAL MEMORY USED ON CLIENT
IY21968ALLOW DB2BATCH TO SUPPORT REAL DATA TYPES
IY22003GET SNAPSHOP NEEDS TO GET THE DBCB LATCH WHEN REPORTING LOG SPACE.
IY22152SQLEEXECUTEINTERRUPT GIVEN THAT THIS CAUSES THE PDB SYSTEM CONTROLLER TO TERMINATE ABRUPTLY AND BRINGS THE INSTANCE DOWN
IY22160MEMGETCHUNK() FAILS WHILE ALLOCATING MEMORY
IY22174QP IWM_REMOTE PROCESS GOES INTO LOCK WAIT ON USER QP JOB.
IY22232DO NOT PROMOTE THE DATATYPE IN SQLBINDPARAMETER TO A LOB FROM A LONGVARCHAR IF SPEC LENG IS <32700 AND LONGDATACOMPAT=1
IY22244DB2/HACMP - NODE RECOVERY NEVER COMPLETES BECAUSE WE ARE LOOPINGIN THE SQLEEXECUTENODERECOVERY().
IY22248DB2 CRASH WITH SIGNAL 11 IN SQM_STMT_LIST()
IY22260WHILE A QUERY PATROLLER JOB IS RUNNING, IT HOLDS A Z LOCK ON ITSQUERY RESULT TABLE
IY22310QP RERFORMS POORLY WHEN LISTING JOBS
IY22311DBA2192 /SQL1403 WHEN LOG INTO COMMAND CENTER WITH NON-ADMIN ID.
IY22325USING SAMPLE CONTENTS DIAGLOG IN CONTROL CENTER LOCKS ENTIRE TABLE BEING SAMPLED AS LONG AS CONTROL CENTER REMAINS OPENED.
IY22331ENCOUNTER ARITHMATIC OVERFLOW, FOR NUMBER OF ROWS RETURNED
IY22342DURING DB2STOP DB2SYSC PROCESS GETS HIGH CPU.
IY22391TIMESTAMPS WITHOUT MILLISECONDS COPY UNINTIALIZED MEMORY TO OUTPUT
IY22407PERFORMANCE : EEE QUERY REFERENCING UDF IS NOT SMP-ENABLED WHEN ONLY 1 ROW IS SELECTED FROM A TABLE IN A JOIN
IY22473NEW USER DOES NOT HAVE PRIVILEGE TO THE RESULT TABLE SPACE
IY22490GETSCHEMAS() DOES NOT RETURN THE SCHEMA WITH APP DRIVER ON SOLARIS ONLY (DB2 V7.2)
IY22624BACKUP/RESTORE HELP IS INCORRECT
IY22633INCREMENTAL BACKUP MIGHT BE MISSING PAGES
IY22763REDUNDANT OR CLAUSES NOT FILTERED BY QUERY REWRITE
IY22828SIG11 INSTANCE CRASH TRIGGERED BY RUNNING SQL_STATS_INDEX API FOR RUNSTATS.
IY22994ENABLING TRACKMOD AND MPFA,SQLBSMSDIRECTWRITE GENERATE WARNINGS
IY23141SIGNAL 11 TRAP IN SQLBLATCHPINNEDPAGE() IN MPP/EEE ONLY INVOLVESA WHERE CURRENT OF CURSOR (WCOC) UPDATE OR DELETE STATEMENT.
IY23226ALTER TABLE DATA CAPTURE NONE NOT WORKING
IY23457APPLY DOES NOT RUN 'SQL AFTER' ON DIFFERENTIAL UPDATE WHEN CAPTURE IS FROM AS/400 AND SYNCHPOINT IS NULL
IY23460DB2ADUTL HAS A ARCHIVE LOG LIMIT OF 1023 ENTRIES.
IY23474ADDITION OF CODE TO CHECK FOR ORDER BY CLAUSE ON AN UNTYPED PARA METER MARKER
IY23475DB2 CRASHES AT FUNCTION SQLESRVR
IY23481SUBOPTIMAL PLAN CHOSEN FOR STAR JOIN
IY23487DEFECT IN CLI IN REGARDS TO HOW WE DETERMINE THE CTX USED AT THE ENVIRONMENT LEVEL.
IY23488SQLJ CUSTOMIZER SHOULD SUPPORT MULTIPLE SER CURRENT PACKAGESET STATEMENTS.
IY23491CLEANUP CODE FOR COMM. HANDLER AT WRONG PLACE - SQLFREEBUFFER CR
IY23498DIA3847C AN ERROR OCCURRED IN A DATABASE PAGE HEADER BY DB2PFCHR
IY23503DB2BATCH DOES NOT SUPPORT VARGRAPHIC, CAUSES TRAP.
IY23504DYNAMIC SQL SNAPSHOT FIELD TITLE CHANGE
IY23515TRAPS WHEN USING LOB FILE INPUT DATA
IY23517ERRORS GENERATED FROM SQLO_AUTHORIZE_SEM_POOL: SQL0465N RC=23
IY23521ONCE JOBIDS HIT 999, JOBIDS ARE REUSED. HOWEVER, JOBS ISSUED VIA 'RUN NOW' KEEP REUSING SAME JOBID
IY23522ATTRIBUTES ON SQLLIB/FUNCTION/JAR DIR FOR 'OTHER' NOT PROPER.
IY23527RUNSTATS DOESN'T UPDATE SYSIBM.SYSCOLUMNS CORRECTLY
IY23550CLI SQLEXTENDEDFETCH() GETS "NUMERIC VALUE OUT OF RANGE"
IY23574TRAPPED IN SAVEPOINT WHILE ROLLBACK,SHOULD IGNORE SQLCODE-1035 FROM REMOTE NODE
JR15226TIMING PROBLEM. TWO THREADS ACCESSING SAME MEMORY AREA WHEN NETWORK CABLE IS PULLED.
JR15385CUSTOM DPREPL.DFT SETTINGS FOR CONTROL CENTER NOT PICKED UP.
JR15645CHANGES MADE BY A STORED PROCEDURE WILL BE ROLLED BACK IF RUN FROM DWC
JR15727HOST VARIABLES SPLIT OVER MULTIPLE LINES IN COBOL APPS RESULT INSQL0306N WHEN APP IS PRECOMPILED VIA DB2 PRECOMPILER.
JR15740CURRENTSQLID NOT USED UNDER MTS TRANSACTION ENVIRONMENT.
JR15748INACCURATE DBHEAP VALUE SHOWN IN 'GET DB CFG' OUTPUT ISSUED FROMA REMOTE CLIENT.
JR15767EXECUTEQUERY() DOES NOT THROW AN EXCEPTION WHEN IT IS USED FOR SQL STATEMENTS THAT DO NOT RETURN A RESULT SET
JR15788DETAILED STATS PRODUCE BAD PLAN AT OPT 5
JR15807IMPORT USING MODIFIER IMPLIEDDECIMAL PROBLEM
JR15810IMPORT FROM CCA FAILS (HANG)
JR15811KEYSET CURSOR QUERY DOES NOT WORK AGAINST TABLE ALIASES.
JR15815RUNGSEDEMO , ENABLE DB FAILS WITH -964
JR15827CONNECTIONS TO LOCAL DATABASE CONSUME LAN CACHED CREDENTIALS ON WINDOWS 2000 WHEN NOT CONNECTED TO DOMAIN
JR15833SQL3017N DOING LOAD WITH TIMESTAMPFORMAT="YYYYMMDD" MODIFIER.
JR15838ERROR IN LAUNCHING BROWSER FROM THE INFORMATION CENTER NO DATA IS RETURNED
JR15846CONTROL CENTER PLUGIN MENU ITEMS DO NOT APPEAR FOR DB2/390 TABLES
JR15858USERIDS NEED WRITE AUTHORITY ON DAS DIRECTORY TO RUN SCRIPTS
JR15859COGNOS IMPROMPTU APPLICATION IS FAILING WITH CLI0501N WITH ASYNC=1
JR15873INTERACTIVE PAGE OF THE COMMAND CENTER REMOVES EXTRA BLANKS FROMAN EXPRESSION IN A WHERE CLAUSE
JR15878IN OLEDB, WHEN SQLMORERESULTS CALLED RATHER THAN SQLEXECUTE, COLUMNS NOT BOUND
JR15879SCROLLABLE, READ-ONLY CURSOR CRASHES THE INSTANCE WHEN TRYING ON A FEDERATED TABLE.
JR15898SMCODE=-28 FROM PERFMON AFTER CC ABNORMAL TERMINATION
JR15902GETTING CLI0114E ON INSERT OF A RECORD WITH A DATETIME DATATYPE IN A VC++ APPLICATION
JR15925QUERY PATROLER ABENDS WHEN ISSUEING MULTIPLE QUERIES.
JR15957GRANT/REVOKE STATEMENT DOES NOT VALIDATE DB GROUP NAME TO HAVE ALENGTH OF <= 8 CHARACTERS LONG.
JR15961CALLED ON NULL INPUT OPTION FOR SQL FUNCTIONS RETURNING SQL0628N
JR15975TELNET TO JDBC DAEMON (DB2JD(S)) TRAPS AFTER KEYING 10TH CHARAC TER
JR15978SIGNAL #4 IN SQLNO_FF_LIT_EQ_LIT()
JR15990IN COMMAND CENTER, RESULT SET WOULD NOT DISPLAY IN DISPLAY WINDOWHEN OPTION FOR RESULT SET IS PIPED TO FILE SELECTED
JR16006THE RESULTS OF AN SQL WITH STATEMENT ARE NEVER DISPLAYED ON THE QUERY RESULTS PAGE OF THE COMMAND CENTER
JR16007DB2BATCH ON NT CRASHES WITH AN EXCEPTION.
JR16018UNICODE RETURNS GARBAGE: DATA RETRIEVED FROM A TABLE IN AS/400 WHEN USING WAREHOUSE AND MANAGER CENTER IS RETURNED AS GARBAGE.
JR16040DB2TBST TOOL DOES NOT SHOW THE STATE OF ALL THE TABLESPACE STATEIN SQLUTIL.H
JR16051DB2 CONNECT REQUESTING ORIGINAL ROWSET SIZE, INSTEAD OF OUT-STANDING ROWS, WHEN SERVER UNABLE TO RETURN THE COMPLETE ROWSET
JR16059FIX THE SYSCAT.SEQUENCES CATALOG VIEW ON NT
JR16060LOAD WITH CLIENT OPTION RETURNS SYSTEM ERROR -91
JR16082COMMAND CENTER TAKES TOO LONG TO BE LAUCHED.
JR16088TABLE WITH INDEX AND LONG VARCHAR WILL ONLY RETURN FIRST COLUMN
JR16094INSTALL UDB 7.1 FIXPACK 3 ON TOP OF SYSTEM WITH DB2 UDB 7.1 ANDDB2 OLAP SERVER 7.1, BUT NO STARTER KIT EVER INSTALLED
JR16112CACHE DROPS VARIATION BEFORE STATEMENT IS COMPLETED RUNNING! DB2UPDV7 WILL FAIL ON SOME TYPES OF MIGRATED DATABASES
JR16113FP3 CAUSES THE COMMAND CENTER TO FREEZE WHEN SAVING A SCRIPT.
JR16127FEDERATED D.O. ICON DISSAPEARS RANDOMLY ON REFRESH
JR16129GUIS WILL HANG IN V7.2 IF THERE IS INTERACATION BETWEEN THE COMMAND CENTER AND THE FILE SYSTEM
JR16131EXECUTEUPDATE() DOES NOT THROW EXECEPTIONS FOR SELECT STATEMENTS
JR16132INTERVALTIMEOUTVALUE DEFAULT VALUE SET TO ZERO IN THE CLI.INI
JR16134ON V7.1 FP3, SETTING DB2_SQLROUTINE_PREOPTS TO A DATETIME OPTIONPRODUCES A SQL4930N
JR16135ROLLFORWARD SHOULD DETECT AN INCOMPLETE LOG FILE
JR16143HANDLE THE SQL0104 ERROR FOR VENDOR ESCAPE CLAUSES WITHIN THE DESCRIBE. SQL0007N MIGHT ALSO BE SEEN.
JR16156CLI PROBLEM, DO NOT NEED TO RESCAN DIRECTORY ON EVERY OUTPUT. THIS LDAP OPERATION IS EXPENSIVE.
JR16160SIGNAL 11 IN SQLNO_COST_MGJN
JR16170SPATIAL EXTENDERS' UDF ARE EXPANDED INTO TABLE FUNCTIONS WITH INPUT QUANTIFIERS OF TYPE 'FUNCTION ARGUMENT TABLE QUNS'.
JR16174ENABLE FOR SPATIAL EXTENDER FAILS ON DB2 EEE DATABASE
JR16181INVALID PROMOTION OF SQLSTATE 01517 WARNING TO SQL ERROR DURING DATA CONVERSION OF X'FEFD.
JR16184GETCOLUMNNAME() WITH NET DRIVER TRUNCATES COLUMN NAME TO 29 CHARACTERS IF COLUMN NAME LENGTH IS 30 CHARACTERS
JR16186FOR THE FOLLOWING QUERY INVOLVING A NICKNAME AND A SPATIAL FUNCTION, OPTIMIZER THROWS A 'PLAN NOT FOUND' ERROR.
JR16192CONTROL CENTER PERFORMANCE MONITOR DOES NOT WORK ON LOCAL ALIASED DATABASES. RESULTS IN DBA4750 WITH SMCODE -36
JR16195INCORRECT ORDER OF ORDINALS RETURNED BY SELECT FROM SYSIBM.SYSPROCEDURES CAUSES IMPORT SP PROCCESS TO FAIL.
JR16199ENFORCE GROUP NAMES TO BE 8 CHARACTERS OR LESS IN DBM CFG
JR16205GRANT USAGE ON SEQUENCE DOES NOT BEHAVE CORRECTLY.
JR16211TRAP IN SQLNO_FF_COL_RGWHEN DOING SELECT
JR16215FAILING INSTRUCTION AT 6CA95A59 OFFSET: 00000369 IN <?SQLNO_PROP_MULTIPLE_RANGE_PREDS@@YAJPAUSQLNO_GLOBALS@@JW4SQLNN
JR16221XA PASSWORD LENGTH SHOULD BE 14 CHARACTER MAX
JR16224SQLEXTENDEDFETCH RETURNS SQL_SUCCESS_WITH_INFO IF A ROW DETECTED AN ERROR AND ONLY ONE ROW BEING RETURNED.
JR16229CLI0143E ON SQLBIND PARAMETER OF OUTPUT VARCHAR TYPE
JR16230CUSTOMER RECEIVES MS ERROR -2147467259 WHEN ATTEMPTING UPDATE IBM OLEDB DRIVER.
JR16231SELECT INTO FOR SQLJ NOT RETURNING CORRECT SQLCODE
JR16234SPECIFYING AN ABSOLUTE PATH FOR THE GOVERNOR CONFIG FILE ON NT/2000, THAT PATH IS APPENDED TO DB2PATH.
JR16237SORT ORDER ON VARGRAPHIC COLUMNS ON UNICODE DBS WRONG
JR16238DB21036E WHEN CALLING SP FROM CLP WITH SP NAME THAT HAS '_'
JR16239IN INTEL PLATFORMS --> DB2LOOK GENERATES UNRELATED VIEWS FOR THESPECIFIED TABLE WHEN USING THE -T OPTION.
JR16243LOCK CONFLICT SHOULD NOT BRING DATABASE DOWN WITH -902
JR16244SQL0465 RC=27 WHEN INVOKING A UDF
JR16245USER CANNOT RETRIEVE THE ERROR MESSAGE ASSOCIATED TO A GIVEN RUNTIME ERROR FROM WITHIN AN SQL PROCEDURE.
JR16247JDBC2.0 FUNCTION EXECTUEBATCH( ) NOT WORKING AS IT SHOULD.
JR16252MEMORY READ ERROR, WHEN REFERENCING TABLENAMES CONTAING '\_' ON A AS400 USING SQLCOLUMNS() IN ASYNC MODE.
JR16253STATUS CHANGE TIME FOR GATEWAY IN CONTROL CENTER SHOWS BLANK
JR16260AT INSTALLING DB2 AT A BACKUP DOMAIN CONTROLLER ON NT, USERNAME CAN NOT BE A FULLY QUALIFIED USERNAME SINCE '/' IS NOT ACCEPTED
JR16276IN COMMAND CENTER, USING THE DB CONNECTION BUTTON, SELECT SERVERAND DATABASE, IT DISPLAYS THE PASSWORD IN PLAIN TEXT (NO MASK)
JR16286ADD ADDITIONAL DIAGNOSTICS TO SQLOIQUE() CALL MADE IN SQLPALR_OPENRESPONSEQUEUE
JR16287ADD FUNCTIONALITY TO DISABLE USEREXIT RETRIEVE, THIS IS ENHANCEMENT FOR SOME CUSTOMERS HOT STANDBY SCENARIOS.
JR16293INTERMITTENT CRASH CAUSES: THE INSTRUCTION AT 0X6D84A374 REFERENCED MEMORY AT 0X00000008
JR16296OS/2 DB2 BACKUP VIA USEREXIT WILL FAIL AT AND AFTER SUNDAY SEPTEMBER 9TH 01:46:39 2001
JR16301SQLGETDATA() FAILS TO RETRIEVE DATA AFTER SQLSETPOS()
JR16303EXTRA OR CORRUPTED DATA IN COLUMNS OF THE APPLICATIONS WINDOW OFTHE CONTROL CENTER.
JR16310COMMAND CENTER DOES NOT IMMEDIATELY DISPLAY THE TEXT TYPED IF YOU START TYPING BEFORE THE CONNECTION DIALOGUE IS RETURNED.
JR16313SQLTABLES DOESN'T GET AS400 SCHEMA WITH '_' FROM NT
JR16333JDBC IS NOT HANDLING THE SETCONNECTIONATTRIBUTE() CORRECTLY. AND THERE IS NO WORK AROUND.
JR16391DRDA_HEAP_SZ MEMORY LEAK. SYMPTOMS: SQL30081, RC= *,*,0.
JR16398DB2 IS TRAPPING IN THE FUNCTON SQLEMRSP_AS.C
JR16402DB2 ABENDS IN SQLERUNSYSCTLR DUE TO DOUBLE-FREEING OF MEMORY DARI PROCESS
JR16403PROBLEMS WITH ETIEXUNX USING SUN SOLARIS AGENT
JR16404DB2EVA CAUSED AN INVALID PAGE FAULT IN MODULE DB2ADMIN.DLL
JR16405STORED PROCEDURE BUILDER DOES NOT ENABLE ITS BUILD MENU ITEMS AND TOOLBAR ICONS WHEN CONNECTING TO DB2 FOR OS/390 VERSION 6
JR16409SQL30081 RC:10054
JR16410CREATING EVENT MONITOR ON "DATABASE A ALIAS A1" USING EVENT MONITOR GIVES DBA5500.
JR16411TRAP IN SQLE_DB2RA_AS_DB_FETCH
APAR fixes included in U475381 (Fixpak 3)
APARABSTRACT
GG03862EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1
GG03928SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY.
GG04021CAPTURE CRASHED WITH APPLICATION ERROR: THE MEMORY COULD NOT BE 'READ'
GG04044APPLY CONNECT TO THE SOURCE FOR UPDATING PRUNCNTL.SYNCHPOINT BUT IF NO CAPTURE IS RUNNING - NO SQL PROCESSED - DSNL500I MESSAGE
GG04082SQLCODE313 PRESENTED AFTER USING OFFLINE LOAD PROCEDURE
GG04108ASNAPPLY WITH PARM NOSLEEP DID NOT ISSUE A 'CONNECT RESET',WHICH LEADS TO DSNL500I CONVERSATION FAILED MESSAGES ON DB2 OS/390
GG04110NO TWO CAPTURES CAN BE STARTED WITH THE SAME DATABASE ALIAS (SRC_SERVER IN THE BOOK) IN DIFFERENT DB2 INSTANCES
GG04128IF A COMMUNICATION ERROR OCCURS (ASN1001E, SQL30081), THEN APPL RETURNS WITH RC=0 TO THE OS
GG04129APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
GG04136INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT
GG04155SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE PRUNCNTL
GG04157SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE
GG04159VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR
GG04161APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG.
GG04189FULLREFRESH FROM SECOND TIER CCD TO 3RD TIER CCD DID NOT WORK.
GG04190APPLY BINDS USING PRUNE LOCK TABLE WILL NOT BIND TO CAPTURE/VM WHICH DOES NOT HAVE THIS TABLE.
GG04194CAPTURE USES TOO MUCH MEMORY - WIN NT SPECIFIC PROBLEM
GG04196OVERRIDE THE DEFAULT PARAMETERS OF LOGREUSE AND TRLREUSE USED BY ASNSAT WHEN INVOKING APPLY.
GG04201ASNCMD STOP FAILS TO STOP DATAPROPAGATOR CAPTURE.
IY12218APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH
IY12425DBI1034W WARNING DURING DB2SETUP ON SUN INSTALL IS CONFUSING OR WRONG IF CORRECT JAVA (JDK/JRE) VERSION IS INSTALLED
IY12823REINIT CMD WAS IGNORED WHEN THERE IS NO CHANGES TO CAPTURE
IY13019TRAP (SIG 11) IN SQLNO_UNION_SETSN
IY13147COST OF THE QUERY INCREASES AS THE BUFFER POOL COUNT INCREASES. DB2EXFMT COST GROW AS THE BUFFERPOOL GETS INCREASED.
IY13655ADD NEW DB2LOOK SCHEMA OPTION REMOVED BY DEFECT 153542
IY13818-804 ERROR IN APPLY SQL0804N SQL0804
IY13958DB2ATLD WITH THE DUMPFILES OPTION IS CREATING DUMPFILES WITH THE INCORRECT OWNER ID
IY14016PATH TO DSM.SYS AND DSM.OPT WHEN USEREXIT ENABLED
IY14030ROLLFORWARD COMPLAINS 'LIFELSN MISMATCH FOR REORG-REDO
IY14152CAPTURE UNABLE TO FINISH PRUNING WHEN LOG FILE SYSTEM BECOMES FULL (SQL0964C)
IY14154CAPTURE NEEDS TO REINIT LONG FIELD DATA STRUCTURES FOR ANY NEW REGISTRATION PICKED UP BY THE REINIT COMMAND
IY14222AUTOBINDER FAILING AGAINST FEDERATED DATABASES IN DB2V7
IY14234DB2LOOK FAILS WITH TABLENAMES CONTAINING SLASHES
IY14240TO BETTER EXPLAIN COMPILER OPTIONS FOR DB2UEXT2.CADSM SAMPLE PRO GRAM
IY14278CONTOL CENTER - ALTER TABLE - ADD COLUMN FAILS WITH SQL30081 TCP/IP ERROR '*','*', '0'
IY14291CAPTURE CORE DUMPS WITH SIGABRT, LONG VARCHAR COLUMNS
IY14298CUSTOMER SELECTS, IN JOURNAL, A COMPLETED SPECIFIC JOB TO DISPLA Y AND THE DB2DAS00 GOES DOWN.
IY14463CAPTURE GETS IN A LOOP WHEN ASNCMD GETLSEQ IS IN LOCK STATE
IY14706IMPORT WITH BUFFERED INSERT CAUSES TABLE LOCK ON SYSIBM.SYSPLAN
IY14728CUSTOMER REQUIRES TO MOVE JAVA STORED PROCEDURES FROM ONE SERVER TO ANOTHER IN BATCH
IY14820ERROR DURING ALLOCATION OF LOG FILE CAUSES DATABASE TO SHUTDOWN
IY14858CAPTURE SHUTS DOWN WHENEVER IT RECEIVES SQLCODE 2653DURING COLD START.
IY15022CONVERSION TABLE ERROR MESSAGE IS INCOMPLETE
IY15068INCORRECT FILTER FACTOR COMPUTATION FOR RANGE PREDICATES
IY15085USEREXIT STOPS TO BE CALLED WITH FFFFA602 FROM SQLPGART MESSAGE
IY15091AUTOLOAD FAILS WITH SIGNAL 4 BECAUSE THE MEMORY ALLOCATION FOR THREADS ARE NOT ENOUGH.
IY15116ASN0017E RETURNED WHEN CAPTURE FAILS TO START FROM A USERID THAT IS DIFFERENT FROM THE DB2 INSTANCE OWNER
IY15122SUPPORT FOR SQL_ARD_TYPE DATA TYPE.
IY15123PARSING OF COUNT (EXPRESSION) FAILS WITH COMPLEX EXPRESSIONS
IY15152FAILED 'BACKUP DB <DBALIAS> ... ADSM ...' ARE NOT BEING CLEANED IN ADSM CAUSING 'DB2ADUTL' TO RETURN EXTRANEOUS RESULTS
IY15185CCA ON NON-DRDA CLIENTS IMPORTING SERVER PROFILE CATALOGS EXTRA NODES.
IY15189USER WITH ONLY SELECT PRIVILEGES ON A VIEW IS ABLE TO UPDATE THE TABLE USING A CURSOR UPDATE ON THE ALIAS OF THE VIEW.
IY15200CLOSING SINGLE CONNECTION AFTER MULTIPLE CONNECTION IS ESTABLISH TO REMOTE SEVER RESULTS IN CLI0106E ERROR ON IRIX PLATFORM.
IY15209SQL_INVALID_HANDLE ERROR IS RECEIVED WHEN SQLTABLES IS CALLED BEFORE SQLCOLUMNS.
IY15286CAPTURE PRUNING PROBLEMS WHEN LOGRETAIN=CAPTURE
IY15287DB2 MEMORY LEAK FOR UDF WITH CLOB PARAMETER WHERE UDF RETURNS AN ERROR
IY15297COBOL APPLICATION NOT HANDLING LARGE NUMBER OF HOST VARIABLES.
IY15354PARSER IS NOT DETECTING A SYTAX ERROR IN CREATE PROCEDURE.
IY15403FUNCTION TEMPLATE SYNTAX EXTENSION
IY15421SUBSEQUENT PARAMETER BINDINGS FOR VARCHAR WITH JDBC ARE NOT HAVING THEIR COLDEF LENGTHS UPDATED CAUSING CLI0109E
IY15428-10752 AS SQLCODE IN SQLCA ON BACKUP -> BACKUP EXISTS/VALID, BUT UPDATING HISTORY FILE WAS NOT, REPORTED AS FAILURE
IY15448CLI LAYER NOT RECOGNIZING 'I'(INCLUDE) RETURN FOR DT_SRCE_BEG IN SQLGETDATA.
IY15468AFTER CATALOGUING LOOPBACK AT SERVER, LUWID ON SERVER AND OS390 DO NOT MATCH
IY15508SQL1084 - SHARED SEGMENT NOT CLEANED UP ON INSTANCE DETACH IN MLN CONFIGURATION (EEE ONLY) USING DB2NODE OR ATTACH_NODE
IY15535WRONG RESULTS CAUSED BY A MGJN WHICH IS NOT PROPERLY ORDERED.
IY15541FROM COMMAND CENTER, CONNECT TO A DB NAME CONTAINING THE STRING 'USER' WILL RESULT IN PROMPT FOR UID/PWD
IY15572QP SECURITY VIOLATION
IY15596QUERY PATROLLER - EXPLAIN MODE = EXPLAIN FAILS
IY15665IWM_TRACKER DOES NOT PROCESS QUERIES THAT RETURN DON'T RETURN ANY COLUMNS (EG. SELECT COUNT (*) FROM TABLE1)
IY15676MULTITHREADING ENVIRONMENT CAUSES FORKED CHILD TO BE SPUN OFF IN TO MUTEX.
IY15691AFTER OS390 IS RECYCLED, CONNECTIONS TO IT RECEIVE SQL0902 UNTIL OF THE OLD CONNECTIONS IN THE CONNECTION POOL HAVE BEEN FAILED.
IY15739DB2EXMIG WILL FAIL WITH SQL0104 (SYNTAX ERROR) ON A RENAME TABLE STATEMENT
IY15749SEGMENTATION FAULT USING IWM_TRACKER
IY15758DB2LICM -A CHANGES PERMISSIONS ON /VAR/IFOR. NOBODY EXCEPT ROOT CAN COMPILE (IBM C/C++ COMPILER)
IY15793FP INSTALL BREAKS DJXLINK WHEN WORKING WITH V.8.1.X ORACLE CLIENTS
IY15798DB2DATASOURCE NOT HANDLING CONNECTIONS PROPERLY
IY15827PERFORMANCE WIZARD FROM CONTROL CENTER RECEIVES DBA1107 WHEN NLS AIX SERVER IS USED.
IY15829SIGNAL 11 IN SQLDADJUSTSEQDETPFAMOUNT
IY15846ABEND WHEN USING VARCHAR 600 FOR BIT DATA
IY15853HANG IN COMMAND CENTRE WHEN LAUNCHING VISUAL EXPLAIN
IY15858CAPTURE SHUTS DOWN WHENEVER IT RECEIVES SQLCODE 2653DURING COLD START.
IY15861USEREXIT FAILED, BECAUSE DATABASE ACTIVATED AFTER OFFLINE BACKUP
IY15865CAPTURE IGNORES SQLCODE -2038.THIS IS A WORKSTATION-ONLY PROBLEM
IY15866CAPTURE MIGRATION NOT ALLOWED DUE TO SQLCODE -2656.
IY15913CAPTURE FAILS - SQL2038 RC 32
IY15916USING QMF V7.1 FOR WINDOWS TO ACCESS PARTITIONED DATA ON DB2 UDB EEE V7.1 RESULTS IN SQL1013 'DATABASE COULD NOT BE FOUND'
IY15931HASH_JOIN MEMORY ALLOCATION PROBLEM WHICH MARKS DB BAD.
IY15949'LIST INDOUBT TRANSACTIONS' FAILS WITH DB21018E
IY15975MEMORY LEAK IN AIX APPLY
IY15976INFLATED CARDINALITIES ON EEE QUERIES USING NODENUMBER(COLUMN) PREDICATE MAY CAUSE OPTIMIZER TO CHOOSE BAD PLAN IN V6,V7
IY16009ERROR IN MIGRATING FROM DB2 V5.2 TO DB2 V6.1, SQL0293 CONTAINERS COULT NOT BE FOUND.
IY16012GETDATE() RETURNS DIFFERENT VALUES IN APP VS NET
IY16056USING CID REINSTALL INTERACTIVE QUESTIONS 'OVERWRITE YES/NO' ARE APPEARED FOR OS/2
IY16081DATABASEMETADATA.GETDRIVERNAME() RETURNS LIBDB2.A INSTEAD OF DB2
IY16113JDBC JAVA.LANG.UNSATISFIEDLINKERROR:DB2CONNECTION.SQLFREECONNECT
IY16120QUERY PATROLLER 9K OR LARGER MEMORY ERRORS
IY16123NULLABLE FIELD NOT CHANGED WHEN PICKING GUI 'GENERATE COL CONTEN
IY16159VERSIONING NOT SUPPORTED IN DB2DATASOURCE CODE
IY16162CPUSPEED AUTODETECT SET TO DEFAULT IF CPU TOO FAST
IY16164ASNCAPTURE RETURNS -1 WHICH INDICATES A FAILURE EVEN WHEN A NORMAL MOBILE STOP HAS OCCURRED.
IY16165QUERY PATROLLER ERROR WHEN GRANTING PUBLIC ACCESS TO RESULT SET
IY16208MQBACK ROOLBACK FROM MQSERIES CAUSES PROBLEMS IN EEE ENVIRONMENT
IY16210DB2DART /DDEL EXPORTS INCORRECT DATA ON NULL VALUE.
IY16221POOR PERFORMANCE ON QUERY WHEN JOIN NOT PUSHED DOWN THROUGH UNION ALL VIEW
IY16224WRONG MAPPINGS FOR ERROR MESSAGE SQL0465N AGAINST OS/390
IY16229DB2 UDB AUTOLOADER REPORTS INCORRECT VALUES FOR NUMBER OF ROWS LOADED. AUTOLOADER DOES HOWEVER SUCCESSFULLY LOAD ALL ROWS.
IY16241TCP/IP PACKET SIZE IS 512 BYTES OF PAYLOAD- PERFORMANCE IMPACT
IY16278CLI_SDAINITSQLDAPARM MSG TOO LARGE, CAUSING HP TO TRAP.
IY16281IMPORT INSERT_UPDATE UPDATES NON-TARGET COLUMNS SQL0407N
IY16294MAX COST LIMITATION WITH V6.1 QP GUI.
IY16371EXPORT TO LARGE IXF FROM V6 CLIENT TO V5.2 SERVER RESULTS IN MISSING ROWS
IY16383MISALIGNED DATA IN DB2 CAUSES HP TO TRAP
IY16394FFFF877E ON CREATE VIEW 'DUPLICATE VIEW DEPENDENCY'
IY16397SQL2025N RC=-50 ON A DB2 BACKUP TO ADSM AFTER A NODE IS ADDED THAT DOES NOT CONTAIN DATA (EG. TEMP TABLESPACE)
IY16431DB2ADUTL REPORTS INCORRECT NODE NUMBERS
IY16434DB2ADUTL RETURNS INCORRECT OUTPUT
IY16435USING MULTIPLY_ALT FUNCTION THAT IS INTRODUCED IN DB2 V7.1 FP2 CAUSES SQL0901N
IY16457SIGNAL 11 IN SQLM_A_INIT
IY16487LOAD OF TRUNCATED IXF CAUSING RECORD LENGTH <0 CAUSES EDU CRASH
IY16496QUERY FAILED WHEN THERE ARE 2 CONNECTIONS
IY16499DB2 UDB ON UNIX/OS2/WINDOWS TRAPS WHEN ACESSED FROM HOST OR AS/4
IY16508DB2_CALL_STACK CREATE SIGNAL 11 TRAP IN SQLR_DUMP_SECTION.
IY16512PACKAGE CACHE OVERFLOW AND SQL0973N.
IY16513TRAP IN SQLOFMBLKEX, BUT BAD POINTER IS FROM SQRRCOM_RDS
IY16516REDIRECTED RESTORE FAILS WHEN SPECIFYING EXISTING CONTAINERS FFFF F707 INSTANCE CRASHED
IY16518DATABASE CRASHES AFTER INTERRUPTED REORG
IY16529DB2INIDB PRODUCES A TRAP (SIGNAL 11) AND A CORE
IY16532CREATE GENERALISE REPLICATION SCRIPT -> SAT3052, CANNOT FIND DBPROBLEM RESULTS WHEN ALIAS IS NOT THE SAME AS DB NAME
IY16533INVALID GENERATED COLUMN SETTING CAUSES SET INTEGRITY TO FAIL
IY16571CAPTURE STOPS PROCESSING WHEN IT RECEIVES SQL0100 (ROW NOT FOUND ) IN THE PC TABLE.
IY16577DB2ADUTL FROM SCRIPT CENTER FAILS WITH: ERROR: INITIALISE SESSION FAILED WITH ADSM RETURN CODE 168.
IY16644JOBIDS ARE NOT REUSED WHEN 999 LIMIT IS REACHED IN SCHEDULER
IY16674CHANGING CAPTURE CODE TO PROCESS ALL THE COMMITS IN THE LOCAL NODE, WHICH WILL INCLUDE THE LOG RECORD TYPE OF 'C'
IY16678SQL1042 - INSTANCE CRASH / PANIC ON EEE WHEN MAXAPPLS IS HIT - SQL1040 - AND AN INTERRUPT OCCURS AT THE SAME TIME
IY16693SQLDESCRIBEPARAM NEEDS TO DESCRIBE 1ST PARAMETER MARKER VS 1ST PARAMETER
IY16695CHANGE THE CLI DEFAULT TO NO COMMIT ON EARLY CLOSE OF CURSOR
IY16711POOR PERFORMANCE IN SORTING ON HP DUE TO ALIGNMENT TRAPS
IY16721BAD FILTER FACTOR ESTIMATES FOR 'LIKE ?' AND ZERO FF FOR BETWEEN PREDICATES
IY16734DEBUG CODE TO DUMP INFO WHY USEREXIT STOPS ARCHIVING LOGS
IY16746INDEX STOP/START KEY LOGIC ALLOWS TOO MANY ROWS
IY16750TWO-PHASE CONNECT FAILED WITH SQL0902C 94 CCI
IY16754SQL2062N AN ERROR OCCURRED WHILE ACCESSING MEDIA '/APPS/DIT/NEWYORK/DB2/P1DBINC/SQLLIB/ADSM/LIBADSM.A'.RC:'137
IY16780TABLE BEING MARKED FOR DELETE PENDING BEFORE LOG RECORD IS WRITTEN
IY16784PRECOMPILE OF PL/I APPLICATIONS ON AIX MAY RESULT IN SQL4903 INDICATING 'RUNTIME_PID' WAS INVALID ON 'SQLASTRT_TRUSTED'
IY16790DEFAULT SCHEMA BIND OPTION NOT SET WHEN COMPILING PSM PROCEDURE
IY16799SIGNAL 11 IN SQLNO_ANALYSE_FUNC_OF_COL
IY16812GETDRIVERNAME() CALL TO RETURN OUTPUTS TO DISTINGUISH BETWEEN JDBC APP AND NET DRIVERS.
IY16814SEG FAULT WHEN RUNNING DB2EXPLN
IY16822THE FLAT FILE WRAPPER AS THE WRAPPER CAN ONLY SUPPORT ONE PREDICATE AT A TIME (PER SELECT)
IY16836DATABASE CRASHES ON FAILURE TO ALLOCATE MEMORY FOR A SMALL SORT SQLZERDM : FFFF D600 : A MEMORY HEAP ERROR HAS OCCURED
IY16854DATA CORRUPTION OCCURS ATTEMPTING TO GET BLOB FROM DBCS DB
IY16879SQL4903N SAYING THAT LENGHT OF 'RUNTIME_PID' PARAMETER OF FUNCTION 'SQLASTRT_TRUSTED' IS NOT VALID
IY16924NEED TRANSACTION BASED REPLICATION FOR READ ONLY TARGET TYPES OF PIT AND USERCOPY.
IY16934TABLESPACE RECOVERY FAILS/HANGS DURING FIRST ROLLFORWARD.
IY16937DB2ADUTL FAILS WITH ANR0445W - MAXIMUM GROUP TRANSACTION SIZE EXCEEDED.
IY16962TEMPDIR KEYWORD IN DB2CLI.INI CAUSES CLI0157 TO OCCUR
IY16978CHANGE APPLY TO INCLUDE CREATION OF /SQLLIB/DPROPR IN THEUSER'S HOME DIR TO STORE FILES LIKE PID FILE IF THE LIB IS NOT PRESENT
IY16993DB2LOOK PRODUCES OUT-OF-ORDER COLUMNS FOR FOREIGN KEYS
IY16999SQL QUERY CONTAINING EXTENDED CLAUSE GIVES SQL0007N ERROR FROM QUERY PATROLLER BECAUSE ORIGINAL QUERY TEXT IS USED
IY17006LOGSPACE INFORMATION REPORTED IN DB2 SNAPSHOT IS INCORRECT
IY17012POOR PERFORMANCE ON CERTAIN QUERIES INVOLVING UNION
IY17013EXCESSIVE COMPILE TIME FOR QUERIES WITH LARGE NUMBER OF UNION BRANCHES
IY17017CAN'T RUN DB2GOV WITH SYSADMIN GROUP USER THAT IS NOT DB2 INSTA NCE OWNER.
IY17036CLI0109 STRING DATA RIGHT TRUNCATION ERROR WHEN CLEARPARAMETER() IS USED
IY17052DB2SPLIT FAILED IF OUTPUT FILE > 2GB
IY17059DB2ATLD USES SORT BUFFER TO OVERRIDE THE SORTHEAP IN DB CFG.
IY17079DIA3711C A FILE '' COULD NOT BE FOUND MESSAGE DUMPED INTO THE DB2DIAG.LOG FILE SHOULD HAVE THE FILENAME
IY17087DBQSTART HAS MISSING ERROR CHECKING
IY17104DB2 INSTANCE CRASHED WITH SIGNAL #11 IN SQLRA_FP_COPY()
IY17134SIGNAL 11 TRAP IN SQM_SNAP_APPL_REMOTE RUNNING 'DB2 GET SNAPSHOT FOR ALL REMOTE_APPLICATIONS'.
IY17162DB2EXFMT FAILS WITH QUERY PATROLLER ENABLED SQLSTATE -805
IY17163WHEN EXTRACTING DDL FOR A TABLE USING DB2LOOK, THE OUTPUT COLLEC TED SHOWS SOME UNRELATED VIEWS.
IY17176SIGNAL#11 IN SQLIFNXT
IY17177SIGNAL#11 IN SQLE_CHECK_EARLY_FETCH
IY17181ERRNO:0000 0009 DUMPED IN LOG DURING A SUCCESSFULL BACKUP. THIS APPEARED AFTER APPLYING FP6
IY17199PRECOMPILER REJECTING THE INDICATOR VARIABLE ATTACHED WITH THE HOST VARIABLE.
IY17204DB21018E WHEN CALLING SP FROM CLP
IY17247WHITE SPACE IN THE DB2CLI.INI FILE
IY17255RESTORE DB FAILES WITH SQL5005 SQLF_MIG_REL8 FFFFEC41
IY17263GETS ERROR IN DB2DIAG.LOG SQL -901 SQLERRMC: SQLNO_CRULE_SAVE_PL ANS ě100•:RC(0) SQLERRP :SQLRFAKE WITH STAR JOIN PLANNING.
IY17264QUERY PATROLLER CAUSING CATALOG CONTENTION PROBLEM
IY17286AFTER APPLYING FP2, THE NUMBER OF CONNECTIONS TO THE DATABASE GOES DOWN WITH SQL0956C. THIS IS DUE TO -DDBMON_COMPILER_METRIC
IY17287DB2 UDB DRDA AS (APPLICATION SERVER) TRAPS WITH SIGNAL 36 WHEN TRYING TO FREE MEMORY
IY17292DURING OFFLINE BACKUPS GET INTERMITTENT SQL1042C UNEXPECTED SYST EM ERROR OCCURRED.
IY17299A FILE SHARING VIOLATION HAS OCCURRED, FILENAME WAS ''.ZRC=FFFFF 616.DB2 FAILS TO USE THE ARCHIVED LOG FILES,HELD BY OTHER APPLIC
IY17302CRASH WITH SNAPSHOT MONITORING. FFFF A602 IN DB2DIAG.LOG REPORTE D BY SQLOFMBLK
IY17304AUTOMATIC DATA LINKS BACKUP TO TSM -> RC: 2036 (SQL2036) 'UNABLE TO PREFORM AUTOMATIC BACKUP OF ...'
IY17360SQLJMF91 ATTEMPTS TO USE MEMORY THAT WAS FREED
IY17373CONNECTING TO AN OS/390 DB2 (ANY VERSION) FROM UDB V.7.1 THROUGHTHE CONTROL CENTER HANGS THE CONTROL CENTER.
IY17378SQL0902 ON BACKUP
IY17395A LARGE NUMBER OF LOCK-WAIT ON CATALOG TABLES USING NOT LOGGED INITIALLY TABLES
IY17396PROBLEM WITH RRTRIM FUNCTION.
IY17400SQLRRBCK() SHOULD NOT DUMP MESSAGES TO DB2DIAG.LOG
IY17425DB2CCOR/DB2CCWRK PAIR DOES NOT TIME OUT WHEN SPAWNED IN THE CONTEXT OF NODES STATUS MONITORING
IY17431DB2 CRASH WITH SIGNAL 11 IN SQM_INIT_SQLM_TABLESPACE()
IY17441IMPROVE QUERY PATROLLER'S PERFORMANCE FOR QUERIES WITH ORDER BY CLAUSE
IY17452OUTPUT IS CUT OFF WHEN JAPANESE(HANKAKU/KANA) IS AT THE HEAD OF THE DATA.
IY17461ERROR IN SIZE OF RETURN VALUE FOR INOUT VARCHAR PARAMETERS
IY17469MANY DEFUNCT DB2 PROCESSES WHOSE PARENT IS DB2SYSC PROCESS.
IY17472LOAD HANGS WITH 'THREAD CANNOT CHECK CHECK POINT' ERROR IN DIAG. LOG
IY17489SIGSEGV IN SQLRA_INVAL_VARS_HARD
IY17513SQL3015N - INSTANCE CRASHES DURING IMPORT BECAUSE OPEN CURSORS ARE ENCOUNTERED DURING IMPORT REPLACE
IY17516SQL0311 WHEN CALLING SP FROM JAVA WITH CLOB PARAMETER
IY17519SQL3324 ON A CREATE NICKNAME AGAINST AN AS/400 WITH ZONED DECIMA L (NUMERIC) DATA TYPE
IY17520-973 ON PACKAGE CACHE. REMOVE 256MB PACKAGE CACHE OVERFLOW LIMIT
IY17542MEMORY CORRUPTION CAUSED BY DB2 WILL CAUSE APPLICATIONS TO COME DOWN WITH SIG #11, SQLODELETE, SQLOGMBLK, ETC.
IY17548DB2START HANGS ON 64BIT SOLARIS AFTER KERNAL PATCH 108528-05
IY17576JAVA VISUAL EXPLAIN NUMERICAL LITERAL ERROR
IY17588DB2GOVD PROCESS HANGING.
IY17621SQL0510N CAUSED BY NOT REUSING SECTIONS CORRECTLY IN THE PKG
IY17629COST MISCALULATION CAUSING TABLESCAN TO BE CHOSEN VERSUS AN INDEX SCAN
IY17633CREATE NICKNAME FAILS WITH SQL902 ON EEE SERVER.
IY17656SQL SELECT STATEMENTS GIVES INCONSISTENT OUTPUT ON MULTIPLE RUNS
IY17657REORG TABLE <TB> INDEX <INDEX> RETURNS SQL2205 WHEN INDEX EXISTS
IY17745DQPSTART COMMAND HANG WHEN CHANGING DQPNODES.CFG FILE TO CONTAI N THE SWITCH NAMES RATHER THAN THE HOST NAME.
IY17755THIN CLIENT REQUIRES MSVCP50.DLL, BUT WE DO NOT SHIP THIS FILE
IY17767INVALID INPUT DURING ASCII TO PACKED DECIMAL CONVERSION CAUSES SEGV/CORE AND POSSIBLY STACK CORRUPTION (MOSTLY AT DIAGLEVEL 4)
IY17775PROBLEMS WITH THE CONTROL CENTER 'ESTIMATE SIZE' WINDOW WHEN USING THE 'RUN STATISTICS...' OPTION
IY17784ERROR IN CONVERTING STRING TO DECIMAL
IY17816THERE ARE PROBLEMS USING THE TEXT EXTENDER IN A DCE ENVIRONMENT
IY17924RESTART/CONNECT/CRASH RECOVERY FAILS WITH SQL1042C WITH INVALID LSN DUE TO A PROBLEM WHEN ABORTING A TRANSACTION
IY18114CUST CAN BACKUP THE DLFM_DB AUTOMATICALLY, BUT DATLINKS BACKUP A FILE INTO TSM, RESULTS IN A RC=-2551 IN 'DB2DIAG.LOG'
IY18159DB2DART REPORTS BPS HEADER PROBLEMS AFTER DATABASE RESTORE.
IY18255THE QUERY USED BY APPLY IS NOT EFFICIENT. PERFORMANCE. NO LONGER GENERATES U2000 DUMP ON SQLCODE
IY18784SQL0723 MESSAGE TOKENS INCORRECT
IY18785LOCALE BEHAVIOUR CHANGING ACROSS SOME CLI CALLS
IY18786STORED PROCEDURE BUILDER DOES NOT UPDATE SYSCAT.PROCEDURES
IY18787DB2 OPTIMIZER DOES NOT HANDLE 'OPTIMIZE FOR N ROWS' CORRECTLY BY FAVOURING PIPED PLANS.
IY18788DB2LOOK DOES NOT GENERATE THE DDL FOR THE CREATE USER TABLESPACE CORRECTLY. IT INSTEAD SKIPS THE USER KEYWORD
IY18789LOSS OF THE TABLE DUE TO THE IMPORT REPLACE
IY18790DB2IMIGR FAILS DURING MIGRATION FROM V5.2 TO V7.1.
IY18791DB2LDAP_BASEDN REGISTRY VARIABLE DOES NOT ACCEPT OU AND O.
IY18792SQL0901 IN SQLNO_SMP_FIX_COST DURING QUERY, INTERMITTENT
IY18796CORRECT BEHAVIOUR OF RESTORING/RLLFWDING A TABLESPACE FROM AN OFFLINE BACKUP INTO AN ONLINE DATABASE.
IY18798ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER PREPARE
IY18800DROP TABLESPACE MAY FAIL WITH SQL0290N IF THERE IS RI CONSTRAIN
IY18801DB2 UDB - DATABASE CRASHES WITH A SIGNAL 11 TRAP IN FUNCTION SQLRX_LIKE WHEN THE SET EVENT MONITOR STATEMENT IS EXECUTED.
IY18806DB2LOOK -L FAIL TO RETURN CONTAINER INFO WHEN RAN AS SYSCTRL ID.
IY18807POOR PERFORMANCE WHERE TWO PREDICATES ON COLUMNS IN THE SAME TABLE TEST FOR EQUALITY WITH IDENTICAL CONSTANTS
IY20671HOST SERVER (E.G. DB2/390) RETURNS SQL0805N DURING IMPORT DUE TOA PACKAGE NOT FOUND.
IY21392SIGNAL 11 IN SQLDADJUSTSEQDETPFAMOUNT
JR14218EVENT ANALYZER DOES NOT DISPLAY DYNAMIC SQL TEXT.
JR14271TRUNCATION OF SCRIPT EXECUTION RSULTS TAKES FIRST PORTION, INSTE AD OF THE LAST PART
JR14514CANNOT CREATE A KEYSET CURSOR IF THE KEY IS PART OF THE ORDER BY CLAUSE.
JR14532DB2SYNC APP SHOWS 100% COMPLETE BUT BAR IS AT 85%
JR14610WHEN TRYING TO ALTER A TRIGGER FROM WITHIN THE CONTROL CENTER THE TRIGGER STATEMENT IS GREYED AND CANNOT BE SELECTED FOR COPY.
JR14783RC 23 MISSING FROM DOCUMENTATION OF SQL30083
JR14807DR. WATSON WHEN ISSUING DB2 FORCE APPLICATION ALL AGAINST DRDA-2 CONNECTIONS.
JR15016CC390 COMPONENT IN UDB 7.1 DOES NOT PICK UP THE SYSSCHEMA
JR15026NLX'S AND RCB'S INCORRECT IN FORMATTED DUMP, FOR R300 ONLY
JR15035THE EXPORT TO DATAGUIDE IS GENERATING A DR. WATSON ERROR. IT ALWAYS PRODUCES THE ERROR REGARDLESS OF OBJECT TYPE
JR15146UTILITY TO SET THE PROPER UID/PWD CREDENTIALS FOR SATELLITEID IN THE SATADMIN.AUT FILE USING ORIGINAL SATELLITEID AS INPUT
JR15150ADO/DB2-SEMAPHORE LEAK CAUSES HANDLE COUNT INCREASE.
JR15228TRAP IN SQLJIDRD WHEN SQL_DISCONNECT_ABNORMAL RETURNED
JR15234INSERTING 'DIRTY' TIMESTAMP INTO DATE COLUMN RESULTS IN NO DATA INSERTED, BUT SQL_SUCCESS_WITH_INFO RETURNED TO APP
JR15243EXPORT OF PROFILE VIA CCA FAILING WITH CCA3000 RC 1
JR15255CALL TO STORED PROCEDURE USING IBM OLEDB DRIVER IBMDADB2 GIVES INCORRECT RESULTS
JR15262STATUS CHANGE TIME INCORRECTLY DISPLAYED IN CC
JR15268DB2ML.CONTENT(DOC, FILENAME) REMOVES THE LAST CHARACTER OF THE X DOCUMENT IN ERROR.
JR15273ADMIN SERVER WILL NOT CONFIGURE TCP/IP PORT ON INSTALL.
JR15283SPB'S 390 PROPERTIES TAB SHOWS THE APPLY BUTTON DISABLED
JR15284SIGNING ON IN SPB GIVES ERROR MESSAGE INDICATING BLANK PWD
JR15290ABEND IN DB2SYNCHSATTELITE* APIS IF CALLED WITHIN A .DLL
JR15308SELECT WITH DISTINCT CLAUSE RETURNS INCORRECT RESULT. DUPLICATE ROWS RETURNED.
JR15310SQLGETINFO(SQL_EXPRESSIONS_IN_ORDERBY) RETURNS 'Y' AGAINST MVS - SHOULD BE 'N'
JR15311SQLNUMRESULTCOLS CALLED PRIOR TO SQLEXECUTE IN PREPAREDSTATEMENT OBJECT.
JR15319SHOW RELATED FOR INDEXES NOT WORKING PROPERLY IN CONTROL CENTER
JR15320SPB IS MAINTAINING CONNECTION THAT ARE NO LONGER VALID
JR15324PROBLEMS WITH REPLICATING A JOIN VIEW IN DATA WAREHOUSE CENTER
JR15334FILE BROWSER PERFORMANCE WHEN ACCESSING SERVER VIA MODEM
JR15346SQL4914 WHEN USING DB2CAP WITH CAPTURE FILE WHICH CONTAINS FILTER CONDITION
JR15352SQLPRIMARYKEYS COULD RETURN NO KEYS IF SCHEMA IS NOT SPECIFIED AND USER LOGS IN WITH LOWERCASE USERID.
JR15353SQL1131N STATE 38503 WHEN DAD HAS MORE THAN 20 COLUMNS.
JR15356LIST RECOVERY HISTORY FAILS FROM COMMAND CENTER OR JOURNAL
JR15360TRAP IN SQLNO_FF_COMPUTE_LIKEPRD RUNNING QUERY USING PARAMETER MARKERS OR HOST VARIABLES.
JR15362WE REQUIRE 2ND TOKEN FROM OS/390 IN -440 ERROR RETURN
JR15368DB2_71 ON OS/2, BACKUP RETURNS SQL1224 WITH EXCEPTION C0000005
JR15369SQLTABLES RETURN NO_DATA_FOUND OR CLI0118E BECAUSE OF EXTRA DOUBLE QUOTES IN TABLETYPE SETTING IN DB2CLI.INI FILE.
JR15371OPTIMIZER WRONGLY ELIMINATES JOIN CAUSING INCORRECT RESULT
JR15376V7.1 CONTROL CENTER DOES NOT DISPLAY RESULTS WHEN TRYING TO 'SAMPLE CONTENTS' FROM A TABLE ON A PRE-V6 DATABASE
JR15382IBM OLE DB PROVIDER NOT GENERATING PROPER SQL IN NEW PROJECT.
JR15390MRI DW_REGISTRY_KEY IS TRANSLATED AND IT SHOULD NOT BE.
JR15392MISSING OS/390, MVS, VM/VSE IN ADD SYSTEM DIALOG FROM THE CC DB2 V.7, 5648D4804
JR15394TRAP IN SQLRI_PASSTHRU_DESCRIBE WHEN DOING UNSUPPORTED EXPORT IN PASSTHRU MODE.
JR15401SQL5048 WHEN CREATING A REMOTE DATABASE FROM A V.7.1 CLIENT TO A V.6.1 SERVER
JR15406INSTALL.EXE RETURNS WRONG CODES (1C02), BECAUSE ONLY WAITS FOR THE LAUNCHP.EXE TO EXIT NOT THE OS2INST.EXE (MAIN INSTALL PROG.)
JR15407HOSTNAMES > 8 CHARS DISPLAY INCORRECTLY IN SQL GENERATED BY CC
JR15408DB2 STOP FORCE FROM CC HANGS AND GENERATES A TRAP
JR15415WHEN DEFERREDPREPARE=0 CLI0150E ERROR DRIVER NOT CAPABLE IS RETU RNED
JR15416PROBLEM WITH REDIRECTED RESTORE IN THE CONTROL CENTER.
JR15428MEMORY LEAK IN SEQUENCE: BEGIN CONTEXT, CONNECT TO DATABASE, DISCONNECT FROM DATABASE, END CONTEXT.
JR15435NOT POSSIBLE TO NOT ENTER SIGN '-' (-1) FOR BP SIZE FROM THE CC
JR15463VW RETURNS WARNING WHEN ETI V4.0 PROGRAM RETURNS COMPLETION CODE
JR15466DATABASE COMES DOWN OR HANGS. TRAP FILE IS CREATED INDICATING EXCEPTION C0000005 IN FUNCTION SQLRR_DUMP_SECTION.
JR15471INSERTING NULL WITH OLEDB DOES NOT WORK
JR15483SPB ISSUES WRONG MESSAGE IF PRECISION AND SCALE ARE EQUAL FOR A DECIMAL COLUMN AND A ZERO IS PLACED TO THE LEFT OF DECIMAL POINT
JR15490CAN NOT MIGRATE 5.2 CONTROL DB INTO 7.1 DWC
JR15491SIX ESSBASE PROGRAM DOES NOT RUN DUE TO INCORRECT PASSWORD
JR15498DROP STORED PROCEDURE WITH SPECIFIC NAME >8 CHARACTERS FAILS IN V7 FIXPAK2.
JR15505NT CONTROL CENTER ALLOWS 20 CHAR MAX FOR CONTAINER PATH.
JR15506WHEN SQLDELI=QUOTE ON THE OS/390 DSNHDECM MACRO, CC390 STILL USES ' INSTEAD OF ' FOR THE DELIMITER.
JR15510OS/2 AND UPM INSTALLATION
JR15517SQLUVINT() API STRUCTURE DB2_INFO FIELDS, VERSION RELEASE LEVEL AND OBJ_LIST FIELDS ERRONEOUSLY SET NULL
JR15528'BAD' RANGE OF SORTHEAP SIZE(>1014 AND < 1038) IN THE OPTIMIZER
JR15537CODEPAGE 65535 PROBLEM PASSED BY MVS TO CLI (PADDING OCCURS IN OUTPUT) - NEEDS TO BE RECOGNIZED AS A VALID 4 BIT DATA CODEPAGE
JR15549SQLJ.EXE NO LONGER WORKS WITH WILDCARD (*.SQLJ)
JR15583CAN'T CREATE IDENTITY COLUMNS IN SP WITH V7 FP2
JR15584DB2HISTORY* APIS MAY TRAP IF UNINITIALIZED DATA PASSED IN.
JR15586SQL2650 WHEN TRYING TO TAKE ONLINE BACKUP. AFTER APPLYING FIX FOR IY15913, GET ERRORS IN SQLPALR_READPAGESDISK PROBE 158
JR15589'STATUS CHANGE TIME' WHEN ISSUING 'GET SNAPSHOT..LOCKS' DOES NOT REVEAL INFORMATION
JR15591JAVA UDF RETURNS NULL VALUE INSTEAD OF ACTUAL VALUE
JR15597FAILUER TO CREATE A NEW LOGFILE CAUSES DB2 TO PANIC INSTEAD OF D UMPING 'LOGSPACE FULL' MESSAGE.
JR15598CLI0100 UPDATING NULL DATE COLUMN USING OLEDB PROVIDER
JR15599CALLING SP WITH INOUT DECIMAL ON AN MVS SYSTEM CAUSES SQL0304
JR15602DESCRIBED COLUMN NAMES ARE INCORRECT AFTER SWITCHING CURSOR TYPE IN JAVA OR CLI APPLICATION.
JR15603CCA IS PUTTING THE KEYWORD 'MULTICONNECT' KEYWORD UNDER THE DSN ENTRY OF THE DB2CLI.INI FILES - SHOULD GO UNDER COMMON SECTION.
JR15604TRAP IN SQLOREMOVEEDUEXITLIST SEEN ON OS/2 BACKFIT TO V7.1
JR15610SQL ROUTINES MAY INCORRECTLY COPY HOST VARIABLES FOR CHAR OUTPUT PARAMETERS BY SETTING FIRST BYTE TO 0
JR15618OS2 V7 GATEWAY TRAP IN SQLCCIPCAGENTEXITLIST - DB2DIAG.LOG ALSO REPORTS SQLE_DB2RA_AS_DRIVER PROBE:57 B186 FFFF
JR15622THE ADM. CLIENT INSTALLATION THROUGH THE NORMAL GUI INSTALL, SHOWS A WRONG STIMATION OF THE SPACE REQUIRED.
JR15625EXTRA SPACE IS INSERTED TO DATA WHEN CHARACTER IS THE SAME AS TERMINATION CHARACTER DEFINED IN COMMAND CENTER.
JR15628PASSWORDS ARE LOST/CORRUPTED WITHIN DWC
JR15631DB2 CONNECT SHOULD NOT ATTEMPT TO CONVERT GRAPHIC COLUMNS FROM DOUBLE-BYTE CODEPAGE TO SINGLE-BYTE CODEPAGE. SHOULD ERROR.
JR15635DB2 FOR OS/390 CANNOT MAKE TYPE 2 CONNECTION TO UDB WHEN SPM ENABLED
JR15636INSTALL OF PRODUCT FAILS BECAUSE OF TCPIP SERVICES FILE
JR15640THE CONTROL CENTER FAILS WITH ERROR SQL0104N WHEN ATTEMPTING TO DISPLAY INDEX NAMES USING THE TURKISH LOCALE
JR15643EXPORT PROBLEM WITH IXF FILETYPE
JR15646NAME COLLISION IN THE DB2 DIRECTORY AND DCS DIRECTORY
JR15649SIG 11 IN SQLOXULT THROUGH SQLRA_CACHE_SPACE_MGMT
JR15653SIGNAL 11 IN SQLOFMBLKEX DURING LOAD. (<- SQLUTERMLOADEDU <- SQLUTERMRIDDER)
JR15654'GET SNAPSHOT FOR APPLICATIONS ON <SERVER>' HANGS AT THE SAME PL ACE EVERY TIME THE COMMAND IS ISSUED.
JR15656SOME STEPS WITH A USER DEFINED PROGRAM FAIL TO MIGRATE
JR15661TRAP IN BSORTGETNEXTPARTIALKEY ON NT
JR15666COMMAND CENTER IS NOT LOGGING THE RESULTS OF A QUERY WITH THE 'PIPE OUTPUT TO FILE' OPTION
JR15678SQLDESCRIBEPARAM CALL TO HOST RETURNING SQL0236
JR15686DUPLICATE ENTRIES IN SCRIPT CENTER
JR15688THE JVM CRASHES WHEN MAKING A QUERY ON A DATABASE USING JDBC.
JR15700DR WATSON ERROR DURING SNAPSHOT SCRIPT EXECUTION SQLJNOPREFETCH-OFFSET:110 IN SQLJMS10.C
JR15702OS/2: SQL1092 IS RETURNED INSTEAD OF SQL1093 DURING DB2START WIT HOUT THE USER BEING LOGGED ON.
JR15706TRAP IN SQLCSPC_COOR_REG.
JR15707ACCESS VIOLATION IN DB2APP.DLL WITH REXX STORED PROCS ON OS/2 FO R V7.1 OF DB2.
JR15708ERROR DBA2003 INVALID DATE WHEN USING THE CONTROL CENTER TO SCHEDULE A JOB AND THE REGIONAL SETTING IS SLOVENIA
JR15710LOAD FROM CONTROL CENTER PRODUCES INVALID NULL INDICATOR CLAUSE
JR15711ALTER COLUMN WITH CONSTRAINT ADDITIONCLAUSE SHUTS DOWN ENGINE
JR15715IMPORT FROM CCA FAILS TO UPDATE NODES ON WIN2000
JR15719SYS3175 OCCURS WHEN DB2START IS ISSUED BY A USERID THAT DOES NOT HAVE THE PROPER AUTHORITY
JR15723DXXCOMPOSEXML: ERRCODE:-85, ERRMSG:INVALID DOCUMENT STRUCTURE DXXCOMPOSEXML: ERROR CODE: -85, ERROR MSG:INVALID DOCUMENT STRUC
JR15726V7 CC/NT SAMPLE TABLE ON V6 SERVER CAUSED MEMORY LEAK ON NT: ADD TIONAL REQUEST CAUSED DR. WATSON ERROR OR RUN OUT OF MEMORY.
JR15733SORT ROUTINE CALED TWICE: ONCE DIRECTLY AND ONCE INDIRECTLY SO P PERFORMANCE IS DEGRADED.
JR15735RETURNING LARGE RESULT SET FROM THE V7.1 GUIS (CONTROL CENTER OR COMMAND CENTER) TAKES TOO LONG
JR15736DB2ADVISE MISREPORTING
JR15737PATCH2=29 CAUSES PROBLEM WITH CONVERSION IN A 0 PRECISION DECIMAL TO DOUBLE CONVERSION.
JR15739THREAD CRASHES IN 'COPY TABLE' DIALOG BOX, RENDERING IT USELESS
JR15745MTS/COM+ APPLICATION GETTING SQLCODE -913 WHEN EXECUTING, DUE TO MULTIPLE CONNECTIONS BEING USED BY MTS FOR THE SAME TRANSACTION
JR15753AN EXIT CASE IN SQLDESCRIBE CAUSES THE DATA TO BOUND AS BINARY AND HENCE SHOWING UP AS HEX IN OUTPUT
JR15755ADO PARAMETIZED QUERY SELECTS A LOB AND HAS INPUT PARAMETERS CAUSES DR.WATSON ON DB2 CONNECT.
JR15760THE RESULT SET BECOMES NULL WHEN COLUMN CONTAINS NULL VALUES IN ANY OF THE ROWS. THIS HAPPENS ONLY WHEN IT IS DONE FROM CLI.
JR15762CALLING STORED PROC ON OS/390 V6 FROM DB2 V7 FP2 ON NT RESULTS IN DB21100E.
JR15763INCORRECT CLIENT/SERVER SEARCHING WHEN TRYING TO IMPORT/EXPORTA FILE.
JR15765VISUAL BASIC ADD-IN FOR SPB FAILS ON NON-ENGLISH VB.
JR15766OPTIMIZED QUERY RETURNS INCORRECT RESULTS
JR15790PROBLEM WITH USING NOT DETERMINISTIC OPTION IN UDF
JR15796INSERTING A NULL VALUE INTO A BLOB COLUMN, WE GET THE SQL0301N
JR15799PROBLEM WITH FOREIGN KEYS AND SET NULL CONSTRAINTS
JR15837AMBIGUOUS REFERENCE COLUMN (SQL0203) WHEN QUERYING MVS LEADS TO DR. WATSON TRAP
JR15881LIST RECOVERY HISTORY FAILS FROM COMMAND CENTER OR JOURNAL
JR15884SNAPSHOT FOR SECONDARY LOGS ALLOCATED AND SECONDARY LOG SPACE DO NOT CORRESPOND
JR15885MTS APPLICATION FAILS TO RECONNECT AFTER RECYCLING DB2
JR16093SP FAILS WHEN MORE THAN 27 CURSORS, RET. DATA > 1 BUFFER
PQ46790-805 CAUSED BY CURRENT PACKAGE SET IS NOT RESET
SA91823VWPLOADI - DOES NOT WORK WITH DBCS.
APAR fixes included in U474814 (Fixpak 2a)
APARABSTRACT
IY16409TRAP IN SQLMORERESULTS()
IY16637SQL30090N WHEN DIST TRAN APP CONNECTS TO A REMOTE DB
JR15530DATA INSERTED INTO LONG VARCHAR USING 'FOR BIT' COLUMN NO LONGER WORKING AT FP 2.
APAR fixes included in U475008 (Fixpak 2)
APARABSTRACT
GG04123CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
GG04124CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
GG04131ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
GG04132ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
GG04133AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
GG04134AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
GG04138CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
GG04139CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
GG04144DIAGNOSTIC ENHANCEMENTS FOR APPLY
GG04145DIAGNOSTIC ENHANCEMENTS FOR APPLY
GG04164CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
GG04165CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
GG04166CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
GG04167CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
GG04168CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
GG04169CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
GG04170CANNOT STOP CAPTURE WITH ASNCMD STOP COMMAND.
GG04171DURING CAPTURE PROCESSING THE ASNPATH SYSTEM VARIABLE IS BEING MISREAD
GG04172CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
GG04173CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
GG04174CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
GG04175CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IC27213WRONG TIMESTAMP ON SNAPSHOT OUTPUT FOR DB2 EE 6.1 UNDER LINUX
IY03296SQL2154 ON ATTEMPTED TABLESPACE RESTORE.
IY06938IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6
IY09068EVENT ANALYSER INFORMATION FROM AIX WILL NOT DISPLAY ON NT
IY09174MIGRATION FAILS DUE TO DISK FULL
IY09385SQL1042 DURING CRASH RECOVERY DUE TO INDEX MANAGER PROGRAMMING ERROR (DIA3875C).
IY09469SELECTING TABLES FROM OS/390 WHICH CONTAIN LOBS CAUSES SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT.
IY09705DB2 FORCE APPLICATIONS HANGS ON A NON-COORDINATOR NODE
IY09961QUERY REWRITE DOESN'T PUSH DOWN PREDICATE INTO COMMON SUBESPRESS ION
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY10950UNDERSCORES IN TABLE ALIAS CAUSE MS JET ENGINE ERROR WHEN LINKIN G TABLES.
IY11074SQL0101 ERROR WHEN RUNNING A QUERY DUE TO MEMORY FRAGMENTATION PROBLEM AND LOW 'ULIMIT -D' VALUE.
IY11081DATABASE GETS MARKED AS BAD AFTER FCM ERRORS FFFFFC7F IN DB2DIAG.LOG FILE. EVENT MONITOR RESOURCE COULD NOT BE OBTAINED.
IY11136NO TEMP AVAILABLE ERROR IN DB2DIAG.LOG DURING ON-LINE BACKUP. SQLB_BACKUP_IN_PROGRESS ON TEMPTABLESPACE FOR A SHORT PERIOD.
IY11353SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM
IY11377DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11386APAR IY06317 MAY RESULT IN POOR COST ESTIMATE OF MERGE JOIN
IY11436DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY PROCESSING.
IY11499DB2 UDB - CRASH RECOVERY FAILS WITH AN SQL1042 ERROR. MESSAGES IN THE DB2DIAG.LOG WE FAILED WHEN TRYING TO DROP A BUFFERPOOL.
IY11527DB2 UDB - SQL0901 ERROR WITH MESSAGE 'NON-PIPED PARALLEL SORT ATTEMPTED' IN DB2DIAG.LOG.
IY11600RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION.
IY11648MISLEADING ERROR MESSAGE IN DB2DIAG.LOG FOR QUIESCE RESET FOR A TABLE FROM A NODE WHERE THE TABLE WAS NOT DEFINED.
IY11737QUERY PATROLLER (DQPSETUP) IS RETURNING SQL1005 WITH JA_JP CODEP AGE, BUT DBI1366E WITH EN_US CODEPAGE.
IY11766ALTER TABLE REFERENCES CLAUSE DOES NOT ACCEPT DIFFERENT COLUMN ORDERS IN FOREIGN KEY DEFINITION
IY11785DB2_ALL WITH ':' OPTION ON SUN RETURNS STRANGE MESSAGES
IY11795SQL1224 INSTANCE CRASH ON CLOSE AFTER A FAILED BIND TRAP IS IN SQLRICLS_COMPLEX
IY11819SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER.
IY11865SQL0902N ON STARTING PIPE EVENT MONITOR
IY11882AUTOLOADER USES DB2ATLD_PWFILE WHEN AUTHENTICATION IS NOT SET
IY11901TRAP IN SQLNO_PROJECT_QUN WHEN RUNNING A QUERY
IY11908DB2 calls user exit with the wrong gid
IY11932QUERY PATROLLER DOES NOT WORK PROPERLY WHEN LANGUAGE WAS SELECTE D LANG=US_ENG.
IY11940INDEX CORRUPTION WHEREBY DART ANALYSIS REPORTS 'DUPLICATE FOUND' OR 'INDEX KEYS MISORDERED' OR 'BPS HEADER PAGE NUMBER INCORRECT'
IY11945APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE ALLOCATED TO PROCESS.
IY11990ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC.
IY12016SQL0901N ON DYNAMIC SQL 'SQLNO_CRULE_SAVE_PLANS 100:RC(0)'
IY12035SIGNAL 11 TRAP IN SQLRI_RESTORE_SPEC_REG_INFO()
IY12042CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12050SQL2741N WHEN LOADING DATA AND SPECIFYING IMPLIEDDECIMAL AND PACKEDDECIMAL MODIFIERS
IY12052SEVERE PERFORMANCE DEGRADATION WITH HIGH SYSTEM CPU AND CONTEXT SWITCHES. OCCURS AFTER PREDICTABLE DATABASE UPTIME OF 4-16 DAYS
IY12074GARBAGE COLLECTION IN HISTORY FILE AND NUM_DB_BACKUPS
IY12125OWNER OPTION ON BIND MAY CAUSE INCORRECT AUTHS TO BE USED
IY12165CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N IN FP4E.
IY12168INSTANCE MIGRATION FAILS FROM V5.X TO V6.1
IY12177INDEX ON GENERATED COLUMN NOT TAKEN BY OPTIMIZER DURING INSERT,D ELETE OR UPDATE.
IY12271DB2CKMIG.BND COULD NOT BE OPEND AT DB2CKMIG COMMAND
IY12273LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN CANCELLED
IY12275CLI CONVERSION FROM CHARACTER TO NUMERIC TYPES MAY CAUSE SIGSEGV IF INVALID CHARS USED
IY12295SIGNAL 11 TRAPS IN MEMORY OPERATIONS (MEMHOLDSEG AND SQLOFMBLK) COMING FROM SQLNO_CLOSE_POOL
IY12299DB2ADUTL TO RECOGNIZE ALL TYPES OF FS_TYPE AT QUERY FOR BACKUP I MAGES
IY12396POSSTR DOES NOT WORK WITH GROUP BY (SQL0119)
IY12416-901 DUE TO INCORRECTLY SORTED INPUT STREAM OR INCORRECT ORDER BY QUERY RESULTS, MISORDERED KEYS IN INDEX LEAD TO DB MARKED BAD
IY12419BACKUP OF DATABASE CONTAINING DATALINK COLUMNS FAILS WITH SQL2424N, YET COPY DAEMON SUCCESSFULLY BACKED UP FILES.
IY12437CALLING QUALIFIED STORED PROCEDURES FROM CLP RESULTS IN CLI0150 DRIVER NOT CAPABLE ERROR
IY12449V7.1 ADD CHECK CONSTRAINT PROBLEM FROM CONTROL CENTER
IY12536MONITOR STATE DOES NOT RESET APPLICATION STATE ONCE COMPLETED
IY12545SQL0104N RETURNED WHEN RUNNING DB2BATCH IN CLI MODE. HOWEVER, RE SULT SET IS STILL CORRECT.
IY12566CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12567CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12568CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12609DB2 UDB - SQL1042 ERROR WHEN MAXAGENTS LIMIT HAS BEEN REACHED AND DB2 REQUIRES AN ADDITIONAL AGENT.
IY12642LOAD DOES NOT CHECK PARTITIONING KEY FOR EXCEPTION TABLE
IY12679DB2IUPDT -W 64 (MIGRATION OF 32BIT INSTANCE TO 64 BIT) FAILS WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE.
IY12725DB2 UDB - CREATE INDEX CAUSING DATABASE TO COME DOWN. THE DB2DIAG.LOG FILE INDICATES THAT AN OBJECT ID IS ALREADY IN USE.
IY12726DROPPING AN UNAVAILABLE TABLE ENDS WITH DIA3806C UNEXPECTED END OF FILE
IY12751STMT.GETSTRING() RETURNING NULL ON IN_OUT PARAMETER
IY12777WHEN MIGRATING FROM V5 TO V7, THE FIRST 2,3,4 KEYCARDS VALUES OF THE INDEX FROM THE ACCESS PLAN IS NOT REFLECTED IN SYSCAT.INDEX
IY12800CAN'T RUN DB2GOV WITH SYSADMIN GROUP USER THAT IS NOT DB2 INSTANCE OWNER.
IY12821ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY12946CLI ATTEMPTS TO CLOSE A CURSOR THORUGH THE CURSOR CONTROL BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP.
IY12948VISUAL EXPLAIN DISPLAYS INCORRECT '(DEFAULT)' KEYWORD UNDER THE EXPLAINED COLUMN IN THE TABLE STATISTICS WINDOW.
IY12968JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW
IY13010WHILE TAKING SNAPSHOTS COUNTERS LIKE 'TOTAL BUFFER POOL READ TIME (MS) ' ARE NOT CORRECT.
IY13012THE CUSTOMER UPGRADED TO FP4D FROM FP4 TO ADDRESS APAR IY09469. NOW THE CUSTOMER IS EXPERIENCING CLI0120E.
IY13014SIGNAL #4 #11 USING HOP DRIVER
IY13053HOST STORED PROCEDURE CALL WITH PARAMETERS RESULT IN DB21103W
IY13054MISLEADING ERROR REPORTING ( -901) FOR WRONG SCRIPT TRYING TO LINK UDF.
IY13098SQL0970N WHEN TRYING TO DROP AN SQL PROCEDURE
IY13107DB2 UDB - INDEX CORRUPTION PROBLEM CAUSES MISORDERING OF KEYS
IY13114ENCINA SERVER AND DB2 V7 INTEROPERABILITY. ADDED XA_PREPARE INSIDE ANOTHER TRANSACTION.
IY13118RUNSTATS ON AN EXTENDED INDEX LEADS TO AN INFINITE LOOP
IY13171DATABASE MIGRATION FROM V5 TO V6 FAILS WITH SQL0025W
IY13202MEMORY OVERWRITE CAUSES A TRAP IN SQLIPREDNOTSAT DURING LOCK ESCALATION
IY13226AT QUERYPATROLLER STOP TIME, WE TRY TO DELETE A MESSAGE QUEUE TH AT WAS ALREADY DELETED.
IY13252DB2DCLGN COMMAND WITH A DECIMAL RESULT IN INCORRECT OUTPUT.
IY13307SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON UDB V.7.1
IY13312QUERY OPTIMIZATION. BAD NESTED LOOP JOIN PLAN IS CHOSEN AFTER MIGRATING TO V7. IO IS SIGNIFICANTLY UNDER-COSTED.
IY13327DLFM RETRIEVE DOES NOT TAKE ANY PARAMETER
IY13329'O' OPTION IN DLFM RETRIEVE DOES NOT WORK
IY13330NO MESSAGE IS PRINTED INTO THE DB2DIAG.LOG FOR DLFMO_LOG
IY13331AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY13343IMPORT IN CCA ON A CAE IS CATALOGING DIRECTLY TO A MAINFRAME INSTEAD OF THROUGH A GATEWAY.
IY13410IMPROPER HANDLING OF LOGS WITH RAW DEVICE AS ACTIVE LOG PATH. GET SQL4970N WHEN ISSUING A ROLL FORWARD.
IY13466SQL0198N - DESCRIBING STORED PROCEDURES WITH LONG NAMES
IY13473BAD ACCESS PLAN CAN OCCUR IN EEE WITH DISTRIBUTION STATS
IY13596IN V7.1 CC, ON-LINE BACKUP OPTION FOR EEE IS GREYED OUT.
IY13598SQL1627W WHEN RUN DB2 GET MONITOR SWITCHES AFTER UPDATING THEM FROM A 7.1 CLIENT.
IY13617CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
IY13696SQL1273N ON ROLLFORWARD DATABASE (MISSING LOG FILE S0000000.LOG)
IY13705TRAPS (SIG #11) IN SQLM_GENERIC_CONVERT
IY13707NEW PATCH2=41 IN CLI TO HELP USERS DO CASE INSENSITIVE QUERIES: VIEWS HAS TO BE CREATED ON A TABLE TO UPPER CASE EVERYTHING, THE
IY13738FROM CLIENT TO AIX SERVER,JOB IS SCHEDULED THORUGH SCRIPT CENTER WITH CORRECT USERID,NO MATTER WHAT PASSWORD,JOB EXECUTES SUCESSF
IY13749SQL2038 RC=32 DURING CAPTURE ACTIVITY.
IY13774LOAD FAILURE (BUILD PHASE) MIGHT CAUSE SMP CORRUPTION
IY13799PACKAGE CACHE ENTRY FOR SELECT DOES NOT INDICATE THAT DEFAULT QUALIFIER (SCHEMA) HAS BEEN CHANGED
IY13802CONTROL CENTER DOES NOT ALLOW DEFINING A REPLICATION SUBSCRIPTION ON A VIEW REPLICATION SOURCE.
IY13807DLFMUPDT FAILED WITH DBI1282. BACKUP_INSTINFO() IN DB2IUTIL DOES N'T CONSIDER TO BACKUP DBM CFG FOR DLFMUPDT COMMAND.
IY13808SIGNAL 11 TRAP IN SQLRR_DUMP_SECTION() DURING ERROR PROCESSING
IY13832MULTIPLE STORED PROCEDURES WITH SAME SPECIFIC NAME CAUSE VARIOUS CLI/JDBC PROBLEMS
IY13841APP. CURRENT CONNECTION CHANGED WHEN USING XA COMPLIANT TRANSACT -ION MANAGER WITH DB2
IY13891QUERY PERFORMANCE DEGRADATION V6.1
IY13893ADD SUPPORT FOR THE COLUMN NAME UNDER MINMEM MODE FOR JDBC
IY13906COMMENT IN DB2CLI.INI PREVENTS DATASOURCE FROM WORKING PROPERLY IN DB2 V7.1
IY13927PROBLEMS MIGRATION OLD PL1 APPLICATIONS TO UDB V7.1 HAVING TO DO WITH THE CONNECTION INTERFACES
IY13951MINMEMUSAGE KEYWORD CAUSES INCORRECT SQL_DBMS_NAME OUTPUT IN SQLGETINFO()
IY13959SQL0270N RC=40 DURING RESIZE/EXTEND OF CONTAINERS V7.1 FP1
IY13968BAAN APPLICATION MAY EXPERIENCE -302
IY13970CCA TRUNCATES HOSTNAME TO FIRST PART OF FOUR PART NAME
IY13979-805, -818 SQLCODE RECEIVED FROM MULTITHREADED SQLJ APP IN A UNIX ENVIRONMENT.
IY13992ASNDLCOPY - INCORRECT MISLEADING MESSAGES WHEN DIR FILE CONTAINS DIRECTORY THAT DOES NOT EXIST
IY13995SQLFETCH() FAILS WITH -501 ERROR WHEN MINMEMUSAGE=1
IY13996SYSIBM.SYSVIEWS IS NOT MIGRATED PROPERLY FROM DB2 V5.2 TO DB2 V7 1 WHEN THERE ARE VIEWS THAT HAD MORE THEN 1 SEQNO IN THE TABLE.
IY14035FEDERATED CREATE SERVER COMMAND TRAPS EEE INSTANCES
IY14038DB2 UDB - IN CERTAIN SCENARIOS IF AN AGENT FAILS WITH ANSQL1040 (MAXAPPLS REACHED) ERROR, THE DATABASE WILL CRASH WITH SQL1042.
IY14081ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14082ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14089DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
IY14090DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
IY14091DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
IY14094DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
IY14095ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14096AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY14097AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY14098AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY14121CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
IY14123CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
IY14125CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
IY14126CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS
IY14155DIAGNOSTIC ENHANCEMENTS FOR APPLY
IY14156DIAGNOSTIC ENHANCEMENTS FOR APPLY
IY14158DIAGNOSTIC ENHANCEMENTS FOR APPLY
IY14159DIAGNOSITC ENHANCEMENTS FOR APPLY
IY14242CLI API SQLCOLUMNS FAILS WITH SQL0198N ERROR WHEN ISSUED AGAINST A NEW DATABASE BEFORE BINDING THE CLI BIND FILES.
IY14253MISSING PAGE IO DURING DB ROLLFORWARD (CORRUPTED LOGS)
IY14307INDEX CORRUPTION, CONTINUATION OF IY11940
IY14312KEY NOT FOUND ERROR FFFFF92C DURING DELETE OR DB2DART REPORTS KEYS OUT OF ORDER ON AN INSPECTION.
IY14314SQL1224 DB2 INSTANCE CRASH. THIS OCCURS BECAUSE OF MEMORY CORRUPTION AFTER A COMMUNICATIONS ERROR - TRAP IN MEMTREEPUT
IY14353DB2 GIVES INCORRECT ANSWERS, TERMINATE DB CONNECTION FROM CLP OR HANG WHEN QUERIES ARE RUN FROM COMMAND CENTER.
IY14370DUPLICATE KEY CREATED DURING REORG
IY14396DRDA DUMP PRODUCED WHEN USING SPUFI ON OS/390 TO ACCESS A FEDERA TED VIEW OF A NICKNAME IN UDB V.7.1
IY14406CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
IY14407CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
IY14408CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
IY14409CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATE WITH NO CHANGES.
IY14410CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14411CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14412CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14413CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14414CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY14415CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY14416CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY14417CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY14418CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY14419CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY14420CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY14421CAPTURE DOES NOT HANDLE LARGE TABLE ID
IY14422CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14423CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14424CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14425CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14500DLFM GOES DOWN FROM LOCK TMEOUT WITHIN GARBAGE COLLECTOR DAEMON
IY14639BACK LEVEL CLIENT CRASHES (SIG#11) IN SQLRR_OPEN
IY14648TRAP IN CLI WITH EARLYCLOSE, AUTOCOMMIT, AND BLOCK_FOR_NROWS SET
IY14702UPDATE ISSUE DEALING WITH STAR JOINS AND CODE GEN BUFFER REUSE VS. OVERWRITE. THE UPDATE SUCCESSFUL BUT DOES NOT UPDATE.
IY14713TRAP - EXCEPTION C0000005 IN DB2SYSCS.EXE EXECUTING SQL TRAP IS IN SQLNO_COST_MGJN DUE TO INVALID POINTER
IY14741SET INTEGRITY USING EXCEPTION TABLE FAILS WITH SQL0901 WHEN THE EXCEPTION TABLE HAS THE OPTIONAL COLUMN OF CLOB(32K)
IY14752AIX ONLY: DB2MEMDISCLAIM IS NOT INTERPRETED CORRECTLY ON VERSION 7. IF SET TO ANYTHING, IT IS OFF, IF NOT SET, IT IS ON.
IY14769SOLARIS: DEADLATCH AT V7.1 FP1 CAUSES HANG
IY14770SIGNAL 11 IN SQLVDIVIDE
IY14775CREATE TABLE LOOPS AND USES ALL OF THE LOG SPACE
IY14777PREPAREDSTATEMENT.SETLONG() CALL FAILS TO DB2/390
IY14849SQL0901N SYSTEM ERROR WITH REASON: UNRESOLVED QNC
IY14894TURNING ON THE SPECIAL FEATURE USE_LIGHT_OUTPUT_SQLDA CAUSES THE CLIENT TO HANG.
IY14901SQLFREECONNECT/SQLFREEHANDLE RELEASES THE CONNECTION LATCH
IY14979QUERY PATROLLER LIMITATION: 18 CHARACTERS FOR COLUMN NAME LENGTH
IY14989INSTANCE CRASH ON ROLLFORWARD: SIGNAL 11 IN SQLPRFWD__FP7SQLEACB8SQLP_LSNUL
IY15036GLOBAL TEMP TABLE CAUSING A TRAP WITH SIG 11
IY15049INSERT HANGS IN SQLPGPST
IY15118DB2 UTILITIES FAIL WHEN DYN_QUERY_MGMT IS TURNED ON
IY15135KEY NOT FOUND ERROR (FFFF F92C) ON AN INDEX IN A 32K PAGE TBSP
IY15192ADD FUNCTIONALITY TO OBTAIN A MINIMUM SCALE OF 6 FOR DIVISION.
IY15250AIX ONLY: DB2MEMDISCLAIM CAN CAUSE SORTHEAP ALLOCATION ERRORS, TRAPS, DEFUNCT DB2AGENTS DUE TO LEAKING VIRTUAL MEMORY.
IY15289WRONG OR DIFFERENT RESULTS RETURNED BY SELECT ON VIEWS V7.1 ONLY
IY15369QUERY RUN AT OPT LEVEL 0 RETURNED WRONG RESULTS.
IY15397CREATE PROCEDURE CALL FROM NON-CATALOGUED NODE TRAPS.
IY15469BAD OPTIMIZER PLAN LEADS TO INCORRECT RESULTS IN EEE FOR AST
IY15629INCORRECT FILE SIZE ESTIMATES FOR BACKUP TO ADSM/TSM
JR14166NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1
JR14504SQLFREESTMT TRAP DELETING CCB AFTER XA_END CALL
JR14645SQLSPECIALCOLUMNS FAILS WITH SQL0303N INSTEAD OF RETURNING NAME OF COLUMN DEFINED FOR THE PRIMARY KEY WHEN USING MS QUREY
JR14647JAVA CC DOES NOT ALLOW NUM_POOLAGENTS TO BE SET TO 0.
JR14743DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM.
JR14749SQL0291 TRYING TO ACCESS TEMPORARY TABLESPACE WHEN THERE ARE TEMP TABLEPSACES OF DIFFERENT PAGESIZES:'NO TEMP AVAILABLE'
JR14758WITH SPECIFIC SETTINGS EVERY COMMAND ISSUED FROM COMMAND CENTER ON NT/UDB EE V5.2/FIXPACK 12 RECEIVES DB21005E ERROR.
JR14777QUERY TRAPS SERVER. TRAPPING FUNCTION IS SQLKT_PACK_TUPLE.
JR14781SQL_ATTR_MAX_ROWS DOESN'T REDUCE THE RESULTSET FROM DB2/390 IF SQLEXTENDEDFETCH() IS USED TO RETRIEVE RESULTS.
JR14791SQLEXTENDEDFETCH - FETCH PRIOR - FAILS TO RETRIEVE ROW IN 1 ROW RESULT SET FOR A STATIC SCROLLABLE READ-ONLY SERVER-SIDE CURSOR.
JR14795DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442
JR14809NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER.
JR14815DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED.
JR14841AN SQL0525N ERROR OCCURS WHEN DB2BATCH IS EXECUTED AGAINST AN OS 390 DATABASE.
JR14844USERS WHICH BELONG TO THE SYSADM_GROUP DEFINED IN THE DBM CFG CA NNOT ISSUE A DB2STOP, WHETHER DOMAIN OR LOCAL USERS
JR14846CONTROL CENTER GENERATES INVALID WHEN DEFINING REPLICATION SOURCES AND SUBSCRIPTIONS IF ASN.IBMSNAP_CCPPARMS IS EMPTY
JR14854NT: CONNECT HANGS RESULTING FROM LATCH ON GLOBAL INSTANCE QUEUE
JR14860JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN
JR14867MF AND IBM STORED PROCEDURES WON'T PRECOMPILE. NEED TO PUT A VERSION CHECKING FOR CALL STATEMENTS.
JR1487608/00 duplicate object error occurs while importing to DWC
JR14892CHANGE WIN32 API CALL DUE TO LONG CONNECT DELAYS WHEN THERE ARE DISCONNECTED MAPPED NETWORK DRIVES: NT TERMINAL SERVER ONLY.
JR14894SQL0900 DATABASE CRASHES ON QUERY WITH RID SCANS AND LIST PREFETCHING IF BINSORT ENABLED
JR14895INCORRECT DISPLAY OF DECIMAL SEPARATOR: DISPLAYS ',' INSTEAD OF '.' IN CC FOR BOTH V6.1 AND V7.1
JR14897JDBC TIMING HOLE MAY ALLOW GARBAGE COLLECTOR TO CLOSE OBJECTS WE HOLD REFERENCE TO
JR14905DB2 CC - CREATING INDEXES WITH DUPLICATE NAMES WHEN DEFINING MUL TIPLE TABLES AS REPLICATION SOURCE
JR14921INSERT INTO REAL COLUMN ON DB2/390 DATABASE FAILS
JR14924INCORRECT CALL TO HOST TO RETRIEVE CURRENT TIMEZONE.
JR14926TRAP IN SQLJIFSR.C
JR14928SQL1092 ON DROP DB ON CLIENT DESPITE CATALOG_NOAUTH
JR14929TABLE UDFS WITH DECIMAL PARAMETERS SHOW LENGTH AND SCALE OF 0 IN SYSCAT.FUNCPARMS
JR14931EVENT ANALYZER (CONTROL CENTER) IS TOO SLOW LOADING AND SORTING EVENT FILES
JR14932-502 AFTER USING SQL_CLOSEOPEN CLI ATTRIBUTE
JR14933Support ETI DA version (4.x)
JR14990OUTPUT PARAMETERS NOT INITIALIZED TO NULL
JR14996CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E
JR15008SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR
JR15025DR.WATSON IN DB2SYS.DLL WHEN LOGING OFF NT (MTS AND DTC)
JR15036COMMAND CENTRE LOGON DIALOG FAILS TO GO ON THE TOP
JR15040QUERY RE-WRITE SHOULD REMOVE FALSE PREDICATES (EG. 1=0) FOR THE OPTIMIZER.
JR15042CODEPAGE V5.2 IN BACKUP IMAGE USES CODEPAGE 850 INSTEAD OF CODES ET. V6&7 WILL NOT READ THIS
JR15046RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC
JR15073EXCEPTION 5 TRAP DURING STAR JOIN PLANNING
JR15081CLI COMMIT BETWEEN PREPARE AND DESCRIBE MAY CAUSE CLI0125E FUNCTION SEQUENCE ERROR
JR15082CUS ATTEMPTS LARGE LOAD AND FAILS WHEN INDEX REBUILD.
JR15084SIGNAL #11 IN SQLNQ_MEMMGR::DESTROY. THIS APAR WILL FORCE A -901 TRACEBACK TO GATHER MORE INFO ON NEXT OCCURRANCE.
JR15085WHENEVER THE CUSTOMER GOES TO GET THE SOURCE STORED PROCEDURE CODE IN THE STORED PROCEDURE BUILDER HE GETS SQL0514.
JR15138DR.WATSON IN DB2CLI.DLL WITH JDBC APP CALLING STORED PROCEDURES
JR15141V7.1 CC'S RUNSTATS WINDOW CAN'T BE CLOSED WITH 'CANCEL' BUTTON.
JR15145APAR fix - import errors 3303 and 3807 on validate_relationshi
JR15158DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE
JR15159EXCEPT ALL IN SQL STATEMENT RETURNS SQL0415 WITH SQLSTATE 42825. AND/OR INCORRECT RESULTS DURING SQL EXECUTION.
JR15200USE OF {?=CALL SPNAME(?)} SYNTAX MAY RESULT IN CLI0102 INVALID CONVERSION ERRORS
JR15202RESTORE/MIGRATION (SQL2517W) CONTROL CENTER -> JOURNAL STATUS IS 'FAILED'
JR15206KEYSET PARSER RETURN CODE=1002 CAUSES HEAP CONSUMPTION
JR15212CONNECTION.GETCATALOG() RETURNS AN EMPTY STRING INSTEAD OF NULL
JR15213SQLMORERESULTS() DOES NOT HANDLE ERRORS FROM BATCHED COMMANDS
JR15214EXECUTEBATCH() SHOULD RETURN INTě0• IF BATCH IS EMPTY
JR15215BATCHUPDATEEXCEPTION SHOULD BE THROWN IN EXECUTEBATCH, NOT ADDBATCH IF THERE IS AN ERROR IN THE BATCH STATEMENT
JR15216JAVA APPLICATION TRAPS WHEN HDBC=0
JR15220SQLPUTDATA() MAY RESULT IN SQL0157N UNDER HIGH CONCURRENCY
JR15238INCONSISTENT RESYNC (OS/390 ABORTS, UDB COMMITS)
JR15239SETMAXFIELDSIZE(), SETMAXROWS(), SETQUERYTIMEOUT() SHOULD RETURN SQLEXCEPTION WHEN INPUT VALUE IS INVALID - JDBC
JR15250GETUDTS (JDBC) SHOULD RETURN AN EMPTY RESULTSET IF NOT SUPPORTED
JR15251STATEMENT RESULTSET SHOULD BE SET TO NULL AFTER REUSE
JR15256THIN CLIENT INSTALL DOES NOT UPGRADE THE V.1.X WINSOCK TO V.2.0 ON WINDOWS 95
JR15263SQL COMMENT LINES (STARTING WITH --) IN THE COMMAND CENTER - INTERACTIVE PANEL ARE NOT HANDLED CORRECTLY
JR15287NT/7.1FP1 - WR21198 : 'CPYSETUP.BAT...' -> 'THE SYSTEM CANNOT FIND THE FILE SPECIFIED.' -> COPY NOT USABLE -> CANNOT UPGRADE
JR15318TRAP DURING COMPARE DATE STRING AND AN EMPTY VARCHAR STRING
JR15330SQL 107 RECEIVED WHEN CALLING STORED PROCEDURES ON A HOST SYSTEM THROUGH A V7.1 GATEWAY
JR15425LOAD WITH MODIFIED BY USEDEFAULTS CLAUSE CAUSES NULL FIELDS TO BE INCORRECTLY POPULATED WITH DATA.
APAR fixes included in U472079f (Fixpak 1f)
APARABSTRACT
IY12165CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N IN FP4E.
IY13307SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON UDB V.7.1
IY13312QUERY OPTIMIZATION. BAD NESTED LOOP JOIN PLAN IS CHOSEN AFTER MIGRATING TO V7. IO IS SIGNIFICANTLY UNDER-COSTED.
IY13565DB2DIAG.LOG: DIA9999E ERROR CODE 2, SQLRA_LOAD_DYN_STMT - CAN OCCUR ON SNAPSHOT BUT IS INFORMATIONAL ONLY - NO EFFECT TO USER
IY13707NEW PATCH2=41 IN CLI TO HELP USERS DO CASE INSENSITIVE QUERIES: VIEWS HAS TO BE CREATED ON A TABLE TO UPPER CASE EVERYTHING, THE
JR15158DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE
APAR fixes included in U472079e (Fixpak 1e)
APARABSTRACT
IY12177INDEX ON GENERATED COLUMN NOT TAKEN BY OPTIMIZER DURING INSERT,D ELETE OR UPDATE.
IY13098SQL0970N WHEN TRYING TO DROP AN SQL PROCEDURE
IY13307SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON UDB V.7.1
JR14795DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442
JR15046RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC
JR15081CLI COMMIT BETWEEN PREPARE AND DESCRIBE MAY CAUSE CLI0125E FUNCTION SEQUENCE ERROR
APAR fixes included in U472079d (Fixpak 1d)
APARABSTRACT
IY11353SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM
IY12968JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW
IY13226AT QUERYPATROLLER STOP TIME, WE TRY TO DELETE A MESSAGE QUEUE TH AT WAS ALREADY DELETED.
JR14815DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED.
JR14929TABLE UDFS WITH DECIMAL PARAMETERS SHOW LENGTH AND SCALE OF 0 IN SYSCAT.FUNCPARMS
JR15008SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR
APAR fixes included in U472079c (Fixpak 1c)
APARABSTRACT
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY12751STMT.GETSTRING() RETURNING NULL ON IN_OUT PARAMETER
IY12946CLI ATTEMPTS TO CLOSE A CURSOR THORUGH THE CURSOR CONTROL BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP.
IY13118RUNSTATS ON AN EXTENDED INDEX LEADS TO AN INFINITE LOOP
JR14166NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1
JR14809NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER.
JR14996CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E
APAR fixes included in U472079b (Fixpak 1b)
APARABSTRACT
IY06938IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY11436DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY PROCESSING.
IY11908USER EXITS RUN WITH WRONG RGID ON UNIX.
IY11945APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE ALLOCATED TO PROCESS.
IY12273LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN CANCELLED
IY12679DB2IUPDT -W 64 (MIGRATION OF 32BIT INSTANCE TO 64 BIT) FAILS WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE.
JR14867MF AND IBM STORED PROCEDURES WON'T PRECOMPILE. NEED TO PUT A VERSION CHECKING FOR CALL STATEMENTS.
JR14897JDBC TIMING HOLE MAY ALLOW GARBAGE COLLECTOR TO CLOSE OBJECTS WE HOLD REFERENCE TO
JR14921INSERT INTO REAL COLUMN ON DB2/390 DATABASE FAILS
JR14924INCORRECT CALL TO HOST TO RETRIEVE CURRENT TIMEZONE.
JR14926TRAP IN SQLJIFSR.C
APAR fixes included in U472079a (Fixpak 1a)
APARABSTRACT
IY11353SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM
IY11377DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11600RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION.
IY11819SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER.
IY11990ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC.
IY12416-901 DUE TO INCORRECTLY SORTED INPUT STREAM OR INCORRECT ORDER BY QUERY RESULTS, MISORDERED KEYS IN INDEX LEAD TO DB MARKED BAD
JR14743DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM.
JR14815DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED.
JR14860JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN
JR14876DUPLICATE OBJECT ERROR OCCURS WHILE IMPORTING TO DWC
APAR fixes included in U472079 (Fixpak 1)
APARABSTRACT
IY06572SEGMENTATION FAULT WHEN BINDING A SECOND TIME TO A CURSOR
IY06740DB SIZE ESTIMATE CALCULATED INCORRECTLY FOR BACKUP TO ADSM. HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE.
IY07623SIGNAL #11 TRAP IN SQLORQUE2()
IY08453SQL1227 RC 6 WHEN ATTEMPTING TO UPDATE STATISTICS WITH TABLE CARDINALITY OF 0 WHEN STATISTICS ALREADY EXIST
IY08684SQL0107 RETURNED BY CLI DRIVER ON SQLFETCH CALL TO DB2 MVS.
IY09151LOAD REPLACE OF AN EMPTY FILE (IXF) DOES NOT REPLACE EXISTING ROWS IN THE TABLE THE EMPTY FILE IS BEING LOADED INTO.
IY09262CHANGE THE DEFAULT SQL_CONCURRENCY AS READ_ONLY BASED ON THE CLAUSES PRESENT IN THE STATEMENT.
IY09663DB2 CRASHED WITH ERROR DIA3816C CREATED BY SQM_EVMON_OSTREAM() SIG 11
IY09756NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS. REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED.
IY09764TWO QUERIES DIFFERING ONLY IN THE ORDER OF THE PREDICATES, RETURN DIFFERENT RESULTS.
IY09948JAVA STORED PROCEDURES NOT FOUND OUTSIDE SQLLIB\FUNCTION
IY09966JAVA.SQL.TIMESTAMP RECEIVING INVALID ARGUMENT(NANOS>999999999 OR <0) WHEN MULTIPLE THREADS MAKES THE CALL.
IY10004DB2JD TERIMINATES WITH EXCEPTION, WHEN USING HISTORY OPTION OF CONTROL CENTER FROM WINDOWS 95.
IY10029QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204
IY10034May13: Install V6.1 FP/EEE/NT may add incorrect EE DB2 Services
IY10047DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI
IY10180COMPOUND SQL APPLICATION CORE DUMPS WITH GREATER THAN 60 SQL STATEMENTS.
IY10183TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4.
IY10199LEFT OR FULL OUTER JOIN PROBLEM WITH OPTIMIZER
IY10280RANDOM CLI0606E/CLI0611E ERRORS FROM A MULTI-THREADED JDBC APP WHEN ALL THE THREADS USE A SINGLE CONNECTION.
IY10302PCBVALUE INCORRECTLY POPULATED ON SQLGETDATA FOR WCHAR WITH CBMAXVALUE=2 ON UNIX.
IY10390TERMINATING ADSM SESSION BEFRO RE-ESTABLISHING IT.
IY10430BACKUP IMAGE NOT FOUND ERROR RESTORING TBSP FROM FULL DB BACKUP (LEGATO SPECIFIC)
IY10432JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY
IY10469CORRUPTION IN RECOVERY HISTORY FILE ON DROP TABLE RECOVERY ITEM
IY10475IWM_TRACKER PRODUCES SQL0305N WHEN TRACKING A SUMMARY TABLE
IY10484LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973.
IY10491SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1
IY10499OPTLEVEL 5 PLAN WORSE THAN OPTLEVEL 3 PLAN
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY10562DB2 UDB INTRA_PARALLEL ON - QUERY RETURNS AN SQL0955 ERROR AFTER WHICH ALL QUERIES WHICH REQUIRE SHARED SORT MEMORY FAIL.
IY10579DB2 UDB - SIGNAL 11 TRAP IN FUNCTION SQLDHASHZVALUE WHEN RUNNING REORGCHK ON VARIOUS TABLES.
IY10585SQL0501 AFTER SQL0437W IN CLI APPLICATION. RETRY LOGIC FAULT.
IY10615SQL10003 ERROR RETURNED TO USER APPLICATIONS, AND LOGGED IN THE DB2DIAG.LOG FILE. MEMORY LEAK IN BSU HEAP
IY10625SNAPSHOT FOR TABLES, IF MORE THAN 1 TABLE HAS A NULL NAME, DB2 TRAPS.
IY10668Memory corruption caused by TQS - dirty partial_tuple_saved flg
IY10765APPLICATION HANG IN FCM ON VERY FAST MACHINE
IY10794JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY
IY10803LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N.
IY10816CLI0111E ON INSERT OF DECIMAL 0.00=<X=<0.99 IN SQLJ STORED PROC
IY10861DATABASEMETADATA.GETCOLUMNS IS NOT HANDLING SCHEMAPATTERN='' CORRECTLY.
IY10901IMPORT FROM PIPE ASC BREAKS AT END OF BUFFER. ALTHOUGH IMPORT COMPLETES SUCCESSFULLY, ALL DATA IS NOT IMPORTED.
IY10902CREATE VIEW WITH SCHEMA NAME TOO LONG GIVES SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR.
IY11030SQL30083 RC 24 WHEN TRYING TO CHANGE A PASSWORD LOCALLY FROM THE DB2 CLP USING A VALID PASSWORD
IY11063AN APPLICATION HANGS (AN AGENT STUCK IN MONITOR CODE)
IY11097NULL BUFFER FROM FCM PASSED TO SQLKQ_DETACH_BUFFER LEADING TO HANG ON SMP OR MPP MACHINES.
IY11116DB2ATLD HANGS WHEN THE FILE_TRANSFER_CMDFAILS WITH A NON-ZERO R ETURN CODE.
IY11141DB2JD TERMINATES IF IT CAN'T SPAWN ANY PROCESSES.
IY11217SQJ0001W WITH SQL0104N WHEN ISSUING DB2PROFC ON SQLJ APPLICATION
IY11218INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES
IY11255DB2LOOK -U OPTION RETURNS TABLES WITH GIVEN CREATORID AS SCHEMA INSTEAD OF TABLES THAT WERE CREATED BY THAT CREATORID
IY11275MULTISITE UPDATE HANGS WITH CC
IY11283ISSUING DB2IUPDT OVERWRITES THE DB2AUDIT.CFG WITH THE DEFAULT CONFIGURATION.
IY11343BAD PERFORMANCE WHEN A LOB IS PASSED INTO A UDF
IY11375USEREXIT IS NOT BEING INVOKED EVEN THOUGH IT HAS BEEN SET UP PROPERLY.
IY11377DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11443RECONCILE RETURNS SQL2554N RC=5.
IY11466DEADLOCK CAUSED BY NEXT KEY LOCKING IN CATALOGS
IY11620DB2 UDB - PERFORMANCE DEGRADATION DUE TO OPTIMIZER INCORRECTLY ESTIMATING THE CARDINALITY OF AN INDEX SCAN
JR13044MS INTERDEV RECEIVES CLI0002W AFTER FETCH FROM SQLPROCEDURECOLUM NS()
JR14068PCOMM ALLOWS '#' IN THE PARTNER LU NAME BUT DOES NOT ALLOW '#' I N THE SYM_DEST_NAME.
JR14349SQLDESCRIBEPARAM RETURNING CLI0150E, DRIVER NOT CAPABLE.
JR14415TRAP - MTS AND STORED PROCEDURES WHICH RETURN RESULT SETS
JR14417CPU TIME INCORRECTLY CALCULATED. RESULT IS TOO BIG.
JR14446CLI ACCESS VIOLATION USING DOWNGRADED KEYSET CURSOR AGAINST MVS
JR14491THE BIND FILENAME IS TRUNCATED IF > 50 CHARS IN SQLAJBND_BIND.
JR14517SQL1092 WHEN CREATING DB ON REMOTE SERVER FROM CLIENT. CATALOG_NOAUTH IS IGNORED.
JR14521JAVA COMMAND CENTER RESULTS GREYED OUT WHEN SCROLLING.
JR14550JAVA COMMAND CENTER WIN9X RESULTS > 4682 CHAR DISPLAY PROBLEM
JR14576JDBC NET DRIVER RETURNS SAME RESULTS WITH PREPAREDSTAMENT.
JR14592CONNECT TO DATABASE ON NT HANGS IN STRICMP() C LIBRARY CALL
JR14595SQLDRIVERCONNECT IS SIGNIFIGANTLY SLOWER IN DB2 V6.1 COMPARED TO V5.2
JR14605DIA3419C--NETBIOS NOT STARTED SUCCESSFULLY RC 3
JR14606EXPORT OF DEL MODIFIED BY DECPT SUBSTITUTES PERIOD FOR ANY CHARACTER FOR ITALIAN VERSION DB2 ON NT
JR14625NT PERFORMANCE MONITOR NOT PROVIDING DETAILS FOR THE SECOND AND FOLLOWING APPLICATIONS
JR14646ADDING XBSA SUPPORT TO DB2 NT FOR SAP
JR14648DBA3037 ON VISUAL EXPLAIN WHEN DETAILED STATISTICS COLLECTED ON SOME BUT NOT ALL INDEXES FOR A GIVEN TABLE
JR14723SQL1112 -NOT ENOUGH SYSTEM RESOURCES WHEN TRYING TO SCHEDULE ~100 JOBS FROM THE SCRIPT CENTER
JR14737THE CLIENT IS INCORRECTLY CREATING MULTIPLE SNA CONVERSATIONS USING THE SAME LUWID. THIS IS CAUSING DB2 OS 390 TO ABEND.
JR14742DB2JDS.EXE GOES DOWN ON A VERY LARGE SELECT WITH ONE PARTICULAR USER
JR14759LOAD OF DEL FILE WHEN BOTH' CAST(NULL AS CHAR) USED IN EXPORT' & MODIFIED BY USEDEFAULTS IN LOAD : DATE INSERTED IS WRONG
JR14780SQL0750N WHEN TRYING TO RENAME TABLE WITH IDENTITY COLUMN.