************************************************************
Product Name : DB2 UDB V7.1 for OS/2
PTF Number : WR21251
Package Date : Fri May 4 14:52:09 EDT 2001
Build Level : s010426
************************************************************
APAR fixes included in WR21251 (Fixpak 3)
APAR No. Abstract
-------- --------------------------------------------------
GG03862 EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO
-1
GG03928 SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY.
GG04021 CAPTURE CRASHED WITH APPLICATION ERROR: THE MEMORY COULD NOT
BE 'READ'
GG04044 APPLY CONNECT TO THE SOURCE FOR UPDATING PRUNCNTL.SYNCHPOINT
BUT IF NO CAPTURE IS RUNNING - NO SQL PROCESSED - DSNL500I
MESSAGE
GG04082 SQLCODE313 PRESENTED AFTER USING OFFLINE LOAD PROCEDURE
GG04108 ASNAPPLY WITH PARM NOSLEEP DID NOT ISSUE A 'CONNECT
RESET',WHICH LEADS TO DSNL500I CONVERSATION FAILED MESSAGES
ON DB2 OS/390
GG04110 NO TWO CAPTURES CAN BE STARTED WITH THE SAME DATABASE ALIAS
(SRC_SERVER IN THE BOOK) IN DIFFERENT DB2 INSTANCES
GG04128 IF A COMMUNICATION ERROR OCCURS (ASN1001E, SQL30081), THEN
APPL RETURNS WITH RC=0 TO THE OS
GG04129 APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
GG04136 INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT
REGISTERED IN CCD AS AN INSERT
GG04155 SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL
ZEROS IN PRUNE CONTROL TABLE PRUNCNTL
GG04157 SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE
WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE
GG04159 VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN
SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR
GG04161 APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS
SPACE JOBLOG.
GG04189 FULLREFRESH FROM SECOND TIER CCD TO 3RD TIER CCD DID NOT
WORK.
GG04190 APPLY BINDS USING PRUNE LOCK TABLE WILL NOT BIND TO
CAPTURE/VM WHICH DOES NOT HAVE THIS TABLE.
GG04194 CAPTURE USES TOO MUCH MEMORY - WIN NT SPECIFIC PROBLEM
GG04196 OVERRIDE THE DEFAULT PARAMETERS OF LOGREUSE AND TRLREUSE USED
BY ASNSAT WHEN INVOKING APPLY.
GG04201 ASNCMD STOP FAILS TO STOP DATAPROPAGATOR CAPTURE.
IY12218 APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH
IY12425 DBI1034W WARNING DURING DB2SETUP ON SUN INSTALL IS CONFUSING
OR WRONG IF CORRECT JAVA (JDK/JRE) VERSION IS INSTALLED
IY12823 REINIT CMD WAS IGNORED WHEN THERE IS NO CHANGES TO CAPTURE
IY13019 TRAP (SIG 11) IN SQLNO_UNION_SETSN
IY13147 COST OF THE QUERY INCREASES AS THE BUFFER POOL COUNT
INCREASES. DB2EXFMT COST GROW AS THE BUFFERPOOL GETS
INCREASED.
IY13655 ADD NEW DB2LOOK SCHEMA OPTION REMOVED BY DEFECT 153542
IY13818 -804 ERROR IN APPLY SQL0804N SQL0804
IY13958 DB2ATLD WITH THE DUMPFILES OPTION IS CREATING DUMPFILES WITH
THE INCORRECT OWNER ID
IY14016 PATH TO DSM.SYS AND DSM.OPT WHEN USEREXIT ENABLED
IY14030 ROLLFORWARD COMPLAINS 'LIFELSN MISMATCH FOR REORG-REDO
IY14152 CAPTURE UNABLE TO FINISH PRUNING WHEN LOG FILE SYSTEM BECOMES
FULL (SQL0964C)
IY14154 CAPTURE NEEDS TO REINIT LONG FIELD DATA STRUCTURES FOR ANY
NEW REGISTRATION PICKED UP BY THE REINIT COMMAND
IY14222 AUTOBINDER FAILING AGAINST FEDERATED DATABASES IN DB2V7
IY14234 DB2LOOK FAILS WITH TABLENAMES CONTAINING SLASHES
IY14240 TO BETTER EXPLAIN COMPILER OPTIONS FOR DB2UEXT2.CADSM SAMPLE
PRO GRAM
IY14278 CONTOL CENTER - ALTER TABLE - ADD COLUMN FAILS WITH SQL30081
TCP/IP ERROR '*','*', '0'
IY14291 CAPTURE CORE DUMPS WITH SIGABRT, LONG VARCHAR COLUMNS
IY14298 CUSTOMER SELECTS, IN JOURNAL, A COMPLETED SPECIFIC JOB TO
DISPLA Y AND THE DB2DAS00 GOES DOWN.
IY14463 CAPTURE GETS IN A LOOP WHEN ASNCMD GETLSEQ IS IN LOCK STATE
IY14706 IMPORT WITH BUFFERED INSERT CAUSES TABLE LOCK ON
SYSIBM.SYSPLAN
IY14728 CUSTOMER REQUIRES TO MOVE JAVA STORED PROCEDURES FROM ONE
SERVER TO ANOTHER IN BATCH
IY14820 ERROR DURING ALLOCATION OF LOG FILE CAUSES DATABASE TO
SHUTDOWN
IY14858 CAPTURE SHUTS DOWN WHENEVER IT RECEIVES SQLCODE 2653DURING
COLD START.
IY15022 CONVERSION TABLE ERROR MESSAGE IS INCOMPLETE
IY15068 INCORRECT FILTER FACTOR COMPUTATION FOR RANGE PREDICATES
IY15085 USEREXIT STOPS TO BE CALLED WITH FFFFA602 FROM SQLPGART
MESSAGE
IY15091 AUTOLOAD FAILS WITH SIGNAL 4 BECAUSE THE MEMORY ALLOCATION
FOR THREADS ARE NOT ENOUGH.
IY15116 ASN0017E RETURNED WHEN CAPTURE FAILS TO START FROM A USERID
THAT IS DIFFERENT FROM THE DB2 INSTANCE OWNER
IY15122 SUPPORT FOR SQL_ARD_TYPE DATA TYPE.
IY15123 PARSING OF COUNT (EXPRESSION) FAILS WITH COMPLEX EXPRESSIONS
IY15152 FAILED 'BACKUP DB <
DBALIAS>
... ADSM ...' ARE NOT BEING CLEANED IN ADSM CAUSING
'DB2ADUTL' TO RETURN EXTRANEOUS RESULTS
IY15185 CCA ON NON-DRDA CLIENTS IMPORTING SERVER PROFILE CATALOGS
EXTRA NODES.
IY15189 USER WITH ONLY SELECT PRIVILEGES ON A VIEW IS ABLE TO UPDATE
THE TABLE USING A CURSOR UPDATE ON THE ALIAS OF THE VIEW.
IY15200 CLOSING SINGLE CONNECTION AFTER MULTIPLE CONNECTION IS
ESTABLISH TO REMOTE SEVER RESULTS IN CLI0106E ERROR ON IRIX
PLATFORM.
IY15209 SQL_INVALID_HANDLE ERROR IS RECEIVED WHEN SQLTABLES IS CALLED
BEFORE SQLCOLUMNS.
IY15286 CAPTURE PRUNING PROBLEMS WHEN LOGRETAIN=CAPTURE
IY15287 DB2 MEMORY LEAK FOR UDF WITH CLOB PARAMETER WHERE UDF RETURNS
AN ERROR
IY15297 COBOL APPLICATION NOT HANDLING LARGE NUMBER OF HOST
VARIABLES.
IY15354 PARSER IS NOT DETECTING A SYTAX ERROR IN CREATE PROCEDURE.
IY15403 FUNCTION TEMPLATE SYNTAX EXTENSION
IY15421 SUBSEQUENT 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
IY15448 CLI LAYER NOT RECOGNIZING 'I'(INCLUDE) RETURN FOR DT_SRCE_BEG
IN SQLGETDATA.
IY15468 AFTER CATALOGUING LOOPBACK AT SERVER, LUWID ON SERVER AND
OS390 DO NOT MATCH
IY15508 SQL1084 - SHARED SEGMENT NOT CLEANED UP ON INSTANCE DETACH IN
MLN CONFIGURATION (EEE ONLY) USING DB2NODE OR ATTACH_NODE
IY15535 WRONG RESULTS CAUSED BY A MGJN WHICH IS NOT PROPERLY ORDERED.
IY15541 FROM COMMAND CENTER, CONNECT TO A DB NAME CONTAINING THE
STRING 'USER' WILL RESULT IN PROMPT FOR UID/PWD
IY15572 QP SECURITY VIOLATION
IY15596 QUERY PATROLLER - EXPLAIN MODE = EXPLAIN FAILS
IY15665 IWM_TRACKER DOES NOT PROCESS QUERIES THAT RETURN DON'T RETURN
ANY COLUMNS (EG. SELECT COUNT (*) FROM TABLE1)
IY15676 MULTITHREADING ENVIRONMENT CAUSES FORKED CHILD TO BE SPUN OFF
IN TO MUTEX.
IY15691 AFTER OS390 IS RECYCLED, CONNECTIONS TO IT RECEIVE SQL0902
UNTIL OF THE OLD CONNECTIONS IN THE CONNECTION POOL HAVE BEEN
FAILED.
IY15730 INSTANCE CRASH ON TRAP (SIGSEGV) IN SQLBLATCHPINNEDPAGE EEE
ONLY. INTERNAL SYNCHRONIZATION PROBLEM EXECUTING SQL.
IY15739 DB2EXMIG WILL FAIL WITH SQL0104 (SYNTAX ERROR) ON A RENAME
TABLE STATEMENT
IY15749 SEGMENTATION FAULT USING IWM_TRACKER
IY15758 DB2LICM -A CHANGES PERMISSIONS ON /VAR/IFOR. NOBODY EXCEPT
ROOT CAN COMPILE (IBM C/C++ COMPILER)
IY15793 FP INSTALL BREAKS DJXLINK WHEN WORKING WITH V.8.1.X ORACLE
CLIENTS
IY15798 DB2DATASOURCE NOT HANDLING CONNECTIONS PROPERLY
IY15827 PERFORMANCE WIZARD FROM CONTROL CENTER RECEIVES DBA1107 WHEN
NLS AIX SERVER IS USED.
IY15829 SIGNAL 11 IN SQLDADJUSTSEQDETPFAMOUNT
IY15846 ABEND WHEN USING VARCHAR 600 FOR BIT DATA
IY15853 HANG IN COMMAND CENTRE WHEN LAUNCHING VISUAL EXPLAIN
IY15858 CAPTURE SHUTS DOWN WHENEVER IT RECEIVES SQLCODE 2653DURING
COLD START.
IY15861 USEREXIT FAILED, BECAUSE DATABASE ACTIVATED AFTER OFFLINE
BACKUP
IY15865 CAPTURE IGNORES SQLCODE -2038.THIS IS A WORKSTATION-ONLY
PROBLEM
IY15866 CAPTURE MIGRATION NOT ALLOWED DUE TO SQLCODE -2656.
IY15913 CAPTURE FAILS - SQL2038 RC 32
IY15916 USING QMF V7.1 FOR WINDOWS TO ACCESS PARTITIONED DATA ON DB2
UDB EEE V7.1 RESULTS IN SQL1013 'DATABASE COULD NOT BE FOUND'
IY15931 HASH_JOIN MEMORY ALLOCATION PROBLEM WHICH MARKS DB BAD.
IY15949 'LIST INDOUBT TRANSACTIONS' FAILS WITH DB21018E
IY15975 MEMORY LEAK IN AIX APPLY
IY15976 INFLATED CARDINALITIES ON EEE QUERIES USING
NODENUMBER(COLUMN) PREDICATE MAY CAUSE OPTIMIZER TO CHOOSE
BAD PLAN IN V6,V7
IY16009 ERROR IN MIGRATING FROM DB2 V5.2 TO DB2 V6.1, SQL0293
CONTAINERS COULT NOT BE FOUND.
IY16012 GETDATE() RETURNS DIFFERENT VALUES IN APP VS NET
IY16056 USING CID REINSTALL INTERACTIVE QUESTIONS 'OVERWRITE YES/NO'
ARE APPEARED FOR OS/2
IY16081 DATABASEMETADATA.GETDRIVERNAME() RETURNS LIBDB2.A INSTEAD OF
DB2
IY16113 JDBC
JAVA.LANG.UNSATISFIEDLINKERROR:DB2CONNECTION.SQLFREECONNECT
IY16120 QUERY PATROLLER 9K OR LARGER MEMORY ERRORS
IY16123 NULLABLE FIELD NOT CHANGED WHEN PICKING GUI 'GENERATE COL
CONTEN
IY16159 VERSIONING NOT SUPPORTED IN DB2DATASOURCE CODE
IY16162 CPUSPEED AUTODETECT SET TO DEFAULT IF CPU TOO FAST
IY16164 ASNCAPTURE RETURNS -1 WHICH INDICATES A FAILURE EVEN WHEN A
NORMAL MOBILE STOP HAS OCCURRED.
IY16165 QUERY PATROLLER ERROR WHEN GRANTING PUBLIC ACCESS TO RESULT
SET
IY16208 MQBACK ROOLBACK FROM MQSERIES CAUSES PROBLEMS IN EEE
ENVIRONMENT
IY16210 DB2DART /DDEL EXPORTS INCORRECT DATA ON NULL VALUE.
IY16221 POOR PERFORMANCE ON QUERY WHEN JOIN NOT PUSHED DOWN THROUGH
UNION ALL VIEW
IY16224 WRONG MAPPINGS FOR ERROR MESSAGE SQL0465N AGAINST OS/390
IY16229 DB2 UDB AUTOLOADER REPORTS INCORRECT VALUES FOR NUMBER OF
ROWS LOADED. AUTOLOADER DOES HOWEVER SUCCESSFULLY LOAD ALL
ROWS.
IY16241 TCP/IP PACKET SIZE IS 512 BYTES OF PAYLOAD- PERFORMANCE
IMPACT
IY16278 CLI_SDAINITSQLDAPARM MSG TOO LARGE, CAUSING HP TO TRAP.
IY16281 IMPORT INSERT_UPDATE UPDATES NON-TARGET COLUMNS SQL0407N
IY16294 MAX COST LIMITATION WITH V6.1 QP GUI.
IY16371 EXPORT TO LARGE IXF FROM V6 CLIENT TO V5.2 SERVER RESULTS IN
MISSING ROWS
IY16383 MISALIGNED DATA IN DB2 CAUSES HP TO TRAP
IY16394 FFFF877E ON CREATE VIEW 'DUPLICATE VIEW DEPENDENCY'
IY16397 SQL2025N RC=-50 ON A DB2 BACKUP TO ADSM AFTER A NODE IS ADDED
THAT DOES NOT CONTAIN DATA (EG. TEMP TABLESPACE)
IY16431 DB2ADUTL REPORTS INCORRECT NODE NUMBERS
IY16434 DB2ADUTL RETURNS INCORRECT OUTPUT
IY16435 USING MULTIPLY_ALT FUNCTION THAT IS INTRODUCED IN DB2 V7.1
FP2 CAUSES SQL0901N
IY16457 SIGNAL 11 IN SQLM_A_INIT
IY16487 LOAD OF TRUNCATED IXF CAUSING RECORD LENGTH
<
0 CAUSES EDU CRASH
IY16496 QUERY FAILED WHEN THERE ARE 2 CONNECTIONS
IY16499 DB2 UDB ON UNIX/OS2/WINDOWS TRAPS WHEN ACESSED FROM HOST OR
AS/4
IY16508 DB2_CALL_STACK CREATE SIGNAL 11 TRAP IN SQLR_DUMP_SECTION.
IY16512 PACKAGE CACHE OVERFLOW AND SQL0973N.
IY16513 TRAP IN SQLOFMBLKEX, BUT BAD POINTER IS FROM SQRRCOM_RDS
IY16516 REDIRECTED RESTORE FAILS WHEN SPECIFYING EXISTING CONTAINERS
FFFF F707 INSTANCE CRASHED
IY16518 DATABASE CRASHES AFTER INTERRUPTED REORG
IY16529 DB2INIDB PRODUCES A TRAP (SIGNAL 11) AND A CORE
IY16533 INVALID GENERATED COLUMN SETTING CAUSES SET INTEGRITY TO FAIL
IY16571 CAPTURE STOPS PROCESSING WHEN IT RECEIVES SQL0100 (ROW NOT
FOUND ) IN THE PC TABLE.
IY16577 DB2ADUTL FROM SCRIPT CENTER FAILS WITH: ERROR: INITIALISE
SESSION FAILED WITH ADSM RETURN CODE 168.
IY16644 JOBIDS ARE NOT REUSED WHEN 999 LIMIT IS REACHED IN SCHEDULER
IY16674 CHANGING CAPTURE CODE TO PROCESS ALL THE COMMITS IN THE LOCAL
NODE, WHICH WILL INCLUDE THE LOG RECORD TYPE OF 'C'
IY16678 SQL1042 - INSTANCE CRASH / PANIC ON EEE WHEN MAXAPPLS IS HIT
- SQL1040 - AND AN INTERRUPT OCCURS AT THE SAME TIME
IY16693 SQLDESCRIBEPARAM NEEDS TO DESCRIBE 1ST PARAMETER MARKER VS
1ST PARAMETER
IY16695 CHANGE THE CLI DEFAULT TO NO COMMIT ON EARLY CLOSE OF CURSOR
IY16711 POOR PERFORMANCE IN SORTING ON HP DUE TO ALIGNMENT TRAPS
IY16721 BAD FILTER FACTOR ESTIMATES FOR 'LIKE ?' AND ZERO FF FOR
BETWEEN PREDICATES
IY16734 DEBUG CODE TO DUMP INFO WHY USEREXIT STOPS ARCHIVING LOGS
IY16746 INDEX STOP/START KEY LOGIC ALLOWS TOO MANY ROWS
IY16750 TWO-PHASE CONNECT FAILED WITH SQL0902C 94 CCI
IY16754 SQL2062N AN ERROR OCCURRED WHILE ACCESSING MEDIA
'/APPS/DIT/NEWYORK/DB2/P1DBINC/SQLLIB/ADSM/LIBADSM.A'.RC:'137
IY16780 TABLE BEING MARKED FOR DELETE PENDING BEFORE LOG RECORD IS
WRITTEN
IY16784 PRECOMPILE OF PL/I APPLICATIONS ON AIX MAY RESULT IN SQL4903
INDICATING 'RUNTIME_PID' WAS INVALID ON 'SQLASTRT_TRUSTED'
IY16790 DEFAULT SCHEMA BIND OPTION NOT SET WHEN COMPILING PSM
PROCEDURE
IY16799 SIGNAL 11 IN SQLNO_ANALYSE_FUNC_OF_COL
IY16812 GETDRIVERNAME() CALL TO RETURN OUTPUTS TO DISTINGUISH BETWEEN
JDBC APP AND NET DRIVERS.
IY16814 SEG FAULT WHEN RUNNING DB2EXPLN
IY16822 THE FLAT FILE WRAPPER AS THE WRAPPER CAN ONLY SUPPORT ONE
PREDICATE AT A TIME (PER SELECT)
IY16836 DATABASE CRASHES ON FAILURE TO ALLOCATE MEMORY FOR A SMALL
SORT SQLZERDM : FFFF D600 : A MEMORY HEAP ERROR HAS OCCURED
IY16854 DATA CORRUPTION OCCURS ATTEMPTING TO GET BLOB FROM DBCS DB
IY16879 SQL4903N SAYING THAT LENGHT OF 'RUNTIME_PID' PARAMETER OF
FUNCTION 'SQLASTRT_TRUSTED' IS NOT VALID
IY16924 NEED TRANSACTION BASED REPLICATION FOR READ ONLY TARGET TYPES
OF PIT AND USERCOPY.
IY16934 TABLESPACE RECOVERY FAILS/HANGS DURING FIRST ROLLFORWARD.
IY16937 DB2ADUTL FAILS WITH ANR0445W - MAXIMUM GROUP TRANSACTION
SIZE EXCEEDED.
IY16962 TEMPDIR KEYWORD IN DB2CLI.INI CAUSES CLI0157 TO OCCUR
IY16978 CHANGE APPLY TO INCLUDE CREATION OF /SQLLIB/DPROPR IN
THEUSER'S HOME DIR TO STORE FILES LIKE PID FILE IF THE LIB IS
NOT PRESENT
IY16993 DB2LOOK PRODUCES OUT-OF-ORDER COLUMNS FOR FOREIGN KEYS
IY16999 SQL QUERY CONTAINING EXTENDED CLAUSE GIVES SQL0007N ERROR
FROM QUERY PATROLLER BECAUSE ORIGINAL QUERY TEXT IS USED
IY17006 LOGSPACE INFORMATION REPORTED IN DB2 SNAPSHOT IS INCORRECT
IY17012 POOR PERFORMANCE ON CERTAIN QUERIES INVOLVING UNION
IY17013 EXCESSIVE COMPILE TIME FOR QUERIES WITH LARGE NUMBER OF UNION
BRANCHES
IY17017 CAN'T RUN DB2GOV WITH SYSADMIN GROUP USER THAT IS NOT DB2
INSTA NCE OWNER.
IY17036 CLI0109 STRING DATA RIGHT TRUNCATION ERROR WHEN
CLEARPARAMETER() IS USED
IY17052 DB2SPLIT FAILED IF OUTPUT FILE >
2GB
IY17059 DB2ATLD USES SORT BUFFER TO OVERRIDE THE SORTHEAP IN DB CFG.
IY17079 DIA3711C A FILE '' COULD NOT BE FOUND MESSAGE DUMPED INTO THE
DB2DIAG.LOG FILE SHOULD HAVE THE FILENAME
IY17087 DBQSTART HAS MISSING ERROR CHECKING
IY17104 DB2 INSTANCE CRASHED WITH SIGNAL #11 IN SQLRA_FP_COPY()
IY17134 SIGNAL 11 TRAP IN SQM_SNAP_APPL_REMOTE RUNNING 'DB2 GET
SNAPSHOT FOR ALL REMOTE_APPLICATIONS'.
IY17162 DB2EXFMT FAILS WITH QUERY PATROLLER ENABLED SQLSTATE -805
IY17163 WHEN EXTRACTING DDL FOR A TABLE USING DB2LOOK, THE OUTPUT
COLLEC TED SHOWS SOME UNRELATED VIEWS.
IY17176 SIGNAL#11 IN SQLIFNXT
IY17177 SIGNAL#11 IN SQLE_CHECK_EARLY_FETCH
IY17181 ERRNO:0000 0009 DUMPED IN LOG DURING A SUCCESSFULL BACKUP.
THIS APPEARED AFTER APPLYING FP6
IY17199 PRECOMPILER REJECTING THE INDICATOR VARIABLE ATTACHED WITH
THE HOST VARIABLE.
IY17204 DB21018E WHEN CALLING SP FROM CLP
IY17247 WHITE SPACE IN THE DB2CLI.INI FILE
IY17255 RESTORE DB FAILES WITH SQL5005 SQLF_MIG_REL8 FFFFEC41
IY17263 GETS ERROR IN DB2DIAG.LOG SQL -901 SQLERRMC:
SQLNO_CRULE_SAVE_PL ANS 100:RC(0) SQLERRP :SQLRFAKE WITH
STAR JOIN PLANNING.
IY17264 QUERY PATROLLER CAUSING CATALOG CONTENTION PROBLEM
IY17287 DB2 UDB DRDA AS (APPLICATION SERVER) TRAPS WITH SIGNAL 36
WHEN TRYING TO FREE MEMORY
IY17292 DURING OFFLINE BACKUPS GET INTERMITTENT SQL1042C UNEXPECTED
SYST EM ERROR OCCURRED.
IY17299 A FILE SHARING VIOLATION HAS OCCURRED, FILENAME WAS
''.ZRC=FFFFF 616.DB2 FAILS TO USE THE ARCHIVED LOG FILES,HELD
BY OTHER APPLIC
IY17302 CRASH WITH SNAPSHOT MONITORING. FFFF A602 IN DB2DIAG.LOG
REPORTE D BY SQLOFMBLK
IY17304 AUTOMATIC DATA LINKS BACKUP TO TSM ->
RC:
2036 (SQL2036) 'UNABLE TO PREFORM AUTOMATIC BACKUP OF ...'
IY17360 SQLJMF91 ATTEMPTS TO USE MEMORY THAT WAS FREED
IY17378 SQL0902 ON BACKUP
IY17395 A LARGE NUMBER OF LOCK-WAIT ON CATALOG TABLES USING NOT
LOGGED INITIALLY TABLES
IY17396 PROBLEM WITH RRTRIM FUNCTION.
IY17400 SQLRRBCK() SHOULD NOT DUMP MESSAGES TO DB2DIAG.LOG
IY17425 DB2CCOR/DB2CCWRK PAIR DOES NOT TIME OUT WHEN SPAWNED IN THE
CONTEXT OF NODES STATUS MONITORING
IY17431 DB2 CRASH WITH SIGNAL 11 IN SQM_INIT_SQLM_TABLESPACE()
IY17441 IMPROVE QUERY PATROLLER'S PERFORMANCE FOR QUERIES WITH ORDER
BY CLAUSE
IY17452 OUTPUT IS CUT OFF WHEN JAPANESE(HANKAKU/KANA) IS AT THE HEAD
OF THE DATA.
IY17461 ERROR IN SIZE OF RETURN VALUE FOR INOUT VARCHAR PARAMETERS
IY17469 MANY DEFUNCT DB2 PROCESSES WHOSE PARENT IS DB2SYSC PROCESS.
IY17472 LOAD HANGS WITH 'THREAD CANNOT CHECK CHECK POINT' ERROR IN
DIAG. LOG
IY17489 SIGSEGV IN SQLRA_INVAL_VARS_HARD
IY17513 SQL3015N - INSTANCE CRASHES DURING IMPORT BECAUSE OPEN
CURSORS ARE ENCOUNTERED DURING IMPORT REPLACE
IY17516 SQL0311 WHEN CALLING SP FROM JAVA WITH CLOB PARAMETER
IY17519 SQL3324 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
IY17542 MEMORY CORRUPTION CAUSED BY DB2 WILL CAUSE APPLICATIONS TO
COME DOWN WITH SIG #11, SQLODELETE, SQLOGMBLK, ETC.
IY17548 DB2START HANGS ON 64BIT SOLARIS AFTER KERNAL PATCH 108528-05
IY17576 JAVA VISUAL EXPLAIN NUMERICAL LITERAL ERROR
IY17588 DB2GOVD PROCESS HANGING.
IY17621 SQL0510N CAUSED BY NOT REUSING SECTIONS CORRECTLY IN THE PKG
IY17629 COST MISCALULATION CAUSING TABLESCAN TO BE CHOSEN VERSUS AN
INDEX SCAN
IY17633 CREATE NICKNAME FAILS WITH SQL902 ON EEE SERVER.
IY17656 SQL SELECT STATEMENTS GIVES INCONSISTENT OUTPUT ON MULTIPLE
RUNS
IY17657 REORG TABLE <
TB>
INDEX
<
INDEX>
RETURNS SQL2205 WHEN
INDEX EXISTS
IY17745 DQPSTART COMMAND HANG WHEN CHANGING DQPNODES.CFG FILE TO
CONTAI N THE SWITCH NAMES RATHER THAN THE HOST NAME.
IY17755 THIN CLIENT REQUIRES MSVCP50.DLL, BUT WE DO NOT SHIP THIS
FILE
IY17767 INVALID INPUT DURING ASCII TO PACKED DECIMAL CONVERSION
CAUSES SEGV/CORE AND POSSIBLY STACK CORRUPTION (MOSTLY AT
DIAGLEVEL 4)
IY17775 PROBLEMS WITH THE CONTROL CENTER 'ESTIMATE SIZE' WINDOW WHEN
USING THE 'RUN STATISTICS...' OPTION
IY17784 ERROR IN CONVERTING STRING TO DECIMAL
IY17816 THERE ARE PROBLEMS USING THE TEXT EXTENDER IN A DCE
ENVIRONMENT
IY17924 RESTART/CONNECT/CRASH RECOVERY FAILS WITH SQL1042C WITH
INVALID LSN DUE TO A PROBLEM WHEN ABORTING A TRANSACTION
IY18114 CUST CAN BACKUP THE DLFM_DB AUTOMATICALLY, BUT DATLINKS
BACKUP A FILE INTO TSM, RESULTS IN A RC=-2551 IN
'DB2DIAG.LOG'
IY18159 DB2DART REPORTS BPS HEADER PROBLEMS AFTER DATABASE RESTORE.
IY18255 THE QUERY USED BY APPLY IS NOT EFFICIENT. PERFORMANCE. NO
LONGER GENERATES U2000 DUMP ON SQLCODE
IY18784 SQL0723 MESSAGE TOKENS INCORRECT
IY18785 LOCALE BEHAVIOUR CHANGING ACROSS SOME CLI CALLS
IY18786 STORED PROCEDURE BUILDER DOES NOT UPDATE SYSCAT.PROCEDURES
IY18787 DB2 OPTIMIZER DOES NOT HANDLE 'OPTIMIZE FOR N ROWS' CORRECTLY
BY FAVOURING PIPED PLANS.
IY18788 DB2LOOK DOES NOT GENERATE THE DDL FOR THE CREATE USER
TABLESPACE CORRECTLY. IT INSTEAD SKIPS THE USER KEYWORD
IY18789 LOSS OF THE TABLE DUE TO THE IMPORT REPLACE
IY18790 DB2IMIGR FAILS DURING MIGRATION FROM V5.2 TO V7.1.
IY18791 DB2LDAP_BASEDN REGISTRY VARIABLE DOES NOT ACCEPT OU AND O.
IY18792 SQL0901 IN SQLNO_SMP_FIX_COST DURING QUERY, INTERMITTENT
IY18796 CORRECT BEHAVIOUR OF RESTORING/RLLFWDING A TABLESPACE FROM AN
OFFLINE BACKUP INTO AN ONLINE DATABASE.
IY18798 ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER
PREPARE
IY18800 DROP TABLESPACE MAY FAIL WITH SQL0290N IF THERE IS RI
CONSTRAIN
IY18801 DB2 UDB - DATABASE CRASHES WITH A SIGNAL 11 TRAP IN FUNCTION
SQLRX_LIKE WHEN THE SET EVENT MONITOR STATEMENT IS EXECUTED.
IY18806 DB2LOOK -L FAIL TO RETURN CONTAINER INFO WHEN RAN AS SYSCTRL
ID.
IY18807 POOR PERFORMANCE WHERE TWO PREDICATES ON COLUMNS IN THE SAME
TABLE TEST FOR EQUALITY WITH IDENTICAL CONSTANTS
JR14218 EVENT ANALYZER DOES NOT DISPLAY DYNAMIC SQL TEXT.
JR14271 TRUNCATION OF SCRIPT EXECUTION RSULTS TAKES FIRST PORTION,
INSTE AD OF THE LAST PART
JR14514 CANNOT CREATE A KEYSET CURSOR IF THE KEY IS PART OF THE ORDER
BY CLAUSE.
JR14532 DB2SYNC APP SHOWS 100% COMPLETE BUT BAR IS AT 85%
JR14610 WHEN TRYING TO ALTER A TRIGGER FROM WITHIN THE CONTROL CENTER
THE TRIGGER STATEMENT IS GREYED AND CANNOT BE SELECTED FOR
COPY.
JR14783 RC 23 MISSING FROM DOCUMENTATION OF SQL30083
JR14807 DR. WATSON WHEN ISSUING DB2 FORCE APPLICATION ALL AGAINST
DRDA-2 CONNECTIONS.
JR15016 CC390 COMPONENT IN UDB 7.1 DOES NOT PICK UP THE SYSSCHEMA
JR15026 NLX'S AND RCB'S INCORRECT IN FORMATTED DUMP, FOR R300 ONLY
JR15035 THE EXPORT TO DATAGUIDE IS GENERATING A DR. WATSON ERROR. IT
ALWAYS PRODUCES THE ERROR REGARDLESS OF OBJECT TYPE
JR15146 UTILITY TO SET THE PROPER UID/PWD CREDENTIALS FOR SATELLITEID
IN THE SATADMIN.AUT FILE USING ORIGINAL SATELLITEID AS INPUT
JR15150 ADO/DB2-SEMAPHORE LEAK CAUSES HANDLE COUNT INCREASE.
JR15228 TRAP IN SQLJIDRD WHEN SQL_DISCONNECT_ABNORMAL RETURNED
JR15234 INSERTING 'DIRTY' TIMESTAMP INTO DATE COLUMN RESULTS IN NO
DATA INSERTED, BUT SQL_SUCCESS_WITH_INFO RETURNED TO APP
JR15243 EXPORT OF PROFILE VIA CCA FAILING WITH CCA3000 RC 1
JR15255 CALL TO STORED PROCEDURE USING IBM OLEDB DRIVER IBMDADB2
GIVES INCORRECT RESULTS
JR15262 STATUS CHANGE TIME INCORRECTLY DISPLAYED IN CC
JR15268 DB2ML.CONTENT(DOC, FILENAME) REMOVES THE LAST CHARACTER OF
THE X DOCUMENT IN ERROR.
JR15283 SPB'S 390 PROPERTIES TAB SHOWS THE APPLY BUTTON DISABLED
JR15284 SIGNING ON IN SPB GIVES ERROR MESSAGE INDICATING BLANK PWD
JR15290 ABEND IN DB2SYNCHSATTELITE* APIS IF CALLED WITHIN A .DLL
JR15308 SELECT WITH DISTINCT CLAUSE RETURNS INCORRECT RESULT.
DUPLICATE ROWS RETURNED.
JR15310 SQLGETINFO(SQL_EXPRESSIONS_IN_ORDERBY) RETURNS 'Y' AGAINST
MVS - SHOULD BE 'N'
JR15311 SQLNUMRESULTCOLS CALLED PRIOR TO SQLEXECUTE IN
PREPAREDSTATEMENT OBJECT.
JR15319 SHOW RELATED FOR INDEXES NOT WORKING PROPERLY IN CONTROL
CENTER
JR15320 SPB IS MAINTAINING CONNECTION THAT ARE NO LONGER VALID
JR15324 PROBLEMS WITH REPLICATING A JOIN VIEW IN DATA WAREHOUSE
CENTER
JR15334 FILE BROWSER PERFORMANCE WHEN ACCESSING SERVER VIA MODEM
JR15346 SQL4914 WHEN USING DB2CAP WITH CAPTURE FILE WHICH CONTAINS
FILTER CONDITION
JR15352 SQLPRIMARYKEYS COULD RETURN NO KEYS IF SCHEMA IS NOT
SPECIFIED AND USER LOGS IN WITH LOWERCASE USERID.
JR15353 SQL1131N STATE 38503 WHEN DAD HAS MORE THAN 20 COLUMNS.
JR15356 LIST RECOVERY HISTORY FAILS FROM COMMAND CENTER OR JOURNAL
JR15360 TRAP IN SQLNO_FF_COMPUTE_LIKEPRD RUNNING QUERY USING
PARAMETER MARKERS OR HOST VARIABLES.
JR15362 WE REQUIRE 2ND TOKEN FROM OS/390 IN -440 ERROR RETURN
JR15368 DB2_71 ON OS/2, BACKUP RETURNS SQL1224 WITH EXCEPTION
C0000005
JR15369 SQLTABLES RETURN NO_DATA_FOUND OR CLI0118E BECAUSE OF EXTRA
DOUBLE QUOTES IN TABLETYPE SETTING IN DB2CLI.INI FILE.
JR15371 OPTIMIZER WRONGLY ELIMINATES JOIN CAUSING INCORRECT RESULT
JR15376 V7.1 CONTROL CENTER DOES NOT DISPLAY RESULTS WHEN TRYING TO
'SAMPLE CONTENTS' FROM A TABLE ON A PRE-V6 DATABASE
JR15382 IBM OLE DB PROVIDER NOT GENERATING PROPER SQL IN NEW PROJECT.
JR15390 MRI DW_REGISTRY_KEY IS TRANSLATED AND IT SHOULD NOT BE.
JR15392 MISSING OS/390, MVS, VM/VSE IN ADD SYSTEM DIALOG FROM THE CC
DB2 V.7, 5648D4804
JR15394 TRAP IN SQLRI_PASSTHRU_DESCRIBE WHEN DOING UNSUPPORTED EXPORT
IN PASSTHRU MODE.
JR15401 SQL5048 WHEN CREATING A REMOTE DATABASE FROM A V.7.1 CLIENT
TO A V.6.1 SERVER
JR15406 INSTALL.EXE RETURNS WRONG CODES (1C02), BECAUSE ONLY WAITS
FOR THE LAUNCHP.EXE TO EXIT NOT THE OS2INST.EXE (MAIN INSTALL
PROG.)
JR15407 HOSTNAMES >
8 CHARS DISPLAY INCORRECTLY IN
SQL GENERATED BY CC
JR15408 DB2 STOP FORCE FROM CC HANGS AND GENERATES A TRAP
JR15415 WHEN DEFERREDPREPARE=0 CLI0150E ERROR DRIVER NOT CAPABLE IS
RETU RNED
JR15416 PROBLEM WITH REDIRECTED RESTORE IN THE CONTROL CENTER.
JR15428 MEMORY LEAK IN SEQUENCE: BEGIN CONTEXT, CONNECT TO DATABASE,
DISCONNECT FROM DATABASE, END CONTEXT.
JR15435 NOT POSSIBLE TO NOT ENTER SIGN '-' (-1) FOR BP SIZE FROM THE
CC
JR15463 VW RETURNS WARNING WHEN ETI V4.0 PROGRAM RETURNS COMPLETION
CODE
JR15466 DATABASE COMES DOWN OR HANGS. TRAP FILE IS CREATED INDICATING
EXCEPTION C0000005 IN FUNCTION SQLRR_DUMP_SECTION.
JR15471 INSERTING NULL WITH OLEDB DOES NOT WORK
JR15483 SPB ISSUES WRONG MESSAGE IF PRECISION AND SCALE ARE EQUAL FOR
A DECIMAL COLUMN AND A ZERO IS PLACED TO THE LEFT OF DECIMAL
POINT
JR15490 CAN NOT MIGRATE 5.2 CONTROL DB INTO 7.1 DWC
JR15491 SIX ESSBASE PROGRAM DOES NOT RUN DUE TO INCORRECT PASSWORD
JR15498 DROP STORED PROCEDURE WITH SPECIFIC NAME >
8
CHARACTERS FAILS IN V7 FIXPAK2.
JR15505 NT CONTROL CENTER ALLOWS 20 CHAR MAX FOR CONTAINER PATH.
JR15506 WHEN SQLDELI=QUOTE ON THE OS/390 DSNHDECM MACRO, CC390 STILL
USES ' INSTEAD OF ' FOR THE DELIMITER.
JR15510 OS/2 AND UPM INSTALLATION
JR15517 SQLUVINT() 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
JR15537 CODEPAGE 65535 PROBLEM PASSED BY MVS TO CLI (PADDING OCCURS
IN OUTPUT) - NEEDS TO BE RECOGNIZED AS A VALID 4 BIT DATA
CODEPAGE
JR15549 SQLJ.EXE NO LONGER WORKS WITH WILDCARD (*.SQLJ)
JR15583 CAN'T CREATE IDENTITY COLUMNS IN SP WITH V7 FP2
JR15584 DB2HISTORY* APIS MAY TRAP IF UNINITIALIZED DATA PASSED IN.
JR15586 SQL2650 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
JR15591 JAVA UDF RETURNS NULL VALUE INSTEAD OF ACTUAL VALUE
JR15597 FAILUER TO CREATE A NEW LOGFILE CAUSES DB2 TO PANIC INSTEAD
OF D UMPING 'LOGSPACE FULL' MESSAGE.
JR15598 CLI0100 UPDATING NULL DATE COLUMN USING OLEDB PROVIDER
JR15599 CALLING SP WITH INOUT DECIMAL ON AN MVS SYSTEM CAUSES SQL0304
JR15602 DESCRIBED COLUMN NAMES ARE INCORRECT AFTER SWITCHING CURSOR
TYPE IN JAVA OR CLI APPLICATION.
JR15603 CCA IS PUTTING THE KEYWORD 'MULTICONNECT' KEYWORD UNDER THE
DSN ENTRY OF THE DB2CLI.INI FILES - SHOULD GO UNDER COMMON
SECTION.
JR15604 TRAP IN SQLOREMOVEEDUEXITLIST SEEN ON OS/2 BACKFIT TO V7.1
JR15610 SQL ROUTINES MAY INCORRECTLY COPY HOST VARIABLES FOR CHAR
OUTPUT PARAMETERS BY SETTING FIRST BYTE TO 0
JR15618 OS2 V7 GATEWAY TRAP IN SQLCCIPCAGENTEXITLIST - DB2DIAG.LOG
ALSO REPORTS SQLE_DB2RA_AS_DRIVER PROBE:57 B186 FFFF
JR15625 EXTRA SPACE IS INSERTED TO DATA WHEN CHARACTER IS THE SAME AS
TERMINATION CHARACTER DEFINED IN COMMAND CENTER.
JR15628 PASSWORDS ARE LOST/CORRUPTED WITHIN DWC
JR15631 DB2 CONNECT SHOULD NOT ATTEMPT TO CONVERT GRAPHIC COLUMNS
FROM DOUBLE-BYTE CODEPAGE TO SINGLE-BYTE CODEPAGE. SHOULD
ERROR.
JR15635 DB2 FOR OS/390 CANNOT MAKE TYPE 2 CONNECTION TO UDB WHEN SPM
ENABLED
JR15640 THE CONTROL CENTER FAILS WITH ERROR SQL0104N WHEN ATTEMPTING
TO DISPLAY INDEX NAMES USING THE TURKISH LOCALE
JR15643 EXPORT PROBLEM WITH IXF FILETYPE
JR15646 NAME COLLISION IN THE DB2 DIRECTORY AND DCS DIRECTORY
JR15649 SIG 11 IN SQLOXULT THROUGH SQLRA_CACHE_SPACE_MGMT
JR15653 SIGNAL 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.
JR15656 SOME STEPS WITH A USER DEFINED PROGRAM FAIL TO MIGRATE
JR15661 TRAP IN BSORTGETNEXTPARTIALKEY ON NT
JR15666 COMMAND CENTER IS NOT LOGGING THE RESULTS OF A QUERY WITH THE
'PIPE OUTPUT TO FILE' OPTION
JR15678 SQLDESCRIBEPARAM CALL TO HOST RETURNING SQL0236
JR15686 DUPLICATE ENTRIES IN SCRIPT CENTER
JR15688 THE JVM CRASHES WHEN MAKING A QUERY ON A DATABASE USING JDBC.
JR15700 DR WATSON ERROR DURING SNAPSHOT SCRIPT EXECUTION
SQLJNOPREFETCH-OFFSET:110 IN SQLJMS10.C
JR15702 OS/2: SQL1092 IS RETURNED INSTEAD OF SQL1093 DURING DB2START
WIT HOUT THE USER BEING LOGGED ON.
JR15706 TRAP IN SQLCSPC_COOR_REG.
JR15707 ACCESS VIOLATION IN DB2APP.DLL WITH REXX STORED PROCS ON OS/2
FO R V7.1 OF DB2.
JR15708 ERROR DBA2003 INVALID DATE WHEN USING THE CONTROL CENTER TO
SCHEDULE A JOB AND THE REGIONAL SETTING IS SLOVENIA
JR15711 ALTER COLUMN WITH CONSTRAINT ADDITIONCLAUSE SHUTS DOWN ENGINE
JR15715 IMPORT FROM CCA FAILS TO UPDATE NODES ON WIN2000
JR15719 SYS3175 OCCURS WHEN DB2START IS ISSUED BY A USERID THAT DOES
NOT HAVE THE PROPER AUTHORITY
JR15723 DXXCOMPOSEXML: ERRCODE:-85, ERRMSG:INVALID DOCUMENT STRUCTURE
DXXCOMPOSEXML: ERROR CODE: -85, ERROR MSG:INVALID DOCUMENT
STRUC
JR15726 V7 CC/NT SAMPLE TABLE ON V6 SERVER CAUSED MEMORY LEAK ON NT:
ADD TIONAL REQUEST CAUSED DR. WATSON ERROR OR RUN OUT OF
MEMORY.
JR15733 SORT ROUTINE CALED TWICE: ONCE DIRECTLY AND ONCE INDIRECTLY
SO P PERFORMANCE IS DEGRADED.
JR15735 RETURNING LARGE RESULT SET FROM THE V7.1 GUIS (CONTROL CENTER
OR COMMAND CENTER) TAKES TOO LONG
JR15736 DB2ADVISE MISREPORTING
JR15737 PATCH2=29 CAUSES PROBLEM WITH CONVERSION IN A 0 PRECISION
DECIMAL TO DOUBLE CONVERSION.
JR15739 THREAD CRASHES IN 'COPY TABLE' DIALOG BOX, RENDERING IT
USELESS
JR15745 MTS/COM+ APPLICATION GETTING SQLCODE -913 WHEN EXECUTING, DUE
TO MULTIPLE CONNECTIONS BEING USED BY MTS FOR THE SAME
TRANSACTION
JR15753 AN EXIT CASE IN SQLDESCRIBE CAUSES THE DATA TO BOUND AS
BINARY AND HENCE SHOWING UP AS HEX IN OUTPUT
JR15755 ADO PARAMETIZED QUERY SELECTS A LOB AND HAS INPUT PARAMETERS
CAUSES DR.WATSON ON DB2 CONNECT.
JR15760 THE RESULT SET BECOMES NULL WHEN COLUMN CONTAINS NULL VALUES
IN ANY OF THE ROWS. THIS HAPPENS ONLY WHEN IT IS DONE FROM
CLI.
JR15762 CALLING STORED PROC ON OS/390 V6 FROM DB2 V7 FP2 ON NT
RESULTS IN DB21100E.
JR15763 INCORRECT CLIENT/SERVER SEARCHING WHEN TRYING TO
IMPORT/EXPORTA FILE.
JR15765 VISUAL BASIC ADD-IN FOR SPB FAILS ON NON-ENGLISH VB.
JR15766 OPTIMIZED QUERY RETURNS INCORRECT RESULTS
JR15790 PROBLEM WITH USING NOT DETERMINISTIC OPTION IN UDF
JR15796 INSERTING A NULL VALUE INTO A BLOB COLUMN, WE GET THE
SQL0301N
JR15799 PROBLEM WITH FOREIGN KEYS AND SET NULL CONSTRAINTS
JR15837 AMBIGUOUS REFERENCE COLUMN (SQL0203) WHEN QUERYING MVS LEADS
TO DR. WATSON TRAP
JR15881 LIST RECOVERY HISTORY FAILS FROM COMMAND CENTER OR JOURNAL
JR15884 SNAPSHOT FOR SECONDARY LOGS ALLOCATED AND SECONDARY LOG SPACE
DO NOT CORRESPOND
JR15885 MTS APPLICATION FAILS TO RECONNECT AFTER RECYCLING DB2
PQ46790 -805 CAUSED BY CURRENT PACKAGE SET IS NOT RESET
SA91823 VWPLOADI - DOES NOT WORK WITH DBCS.
APAR fixes included in WR21241 (Fixpak 2a)
APAR No. Abstract
-------- --------------------------------------------------
IY16409 TRAP IN SQLMORERESULTS()
IY16637 SQL30090N WHEN DIST TRAN APP CONNECTS TO A REMOTE DB
JR15530 DATA INSERTED INTO LONG VARCHAR USING 'FOR BIT' COLUMN NO
LONGER WORKING AT FP 2.
APAR fixes included in WR21245 (Fixpak 2)
APAR No. Abstract
-------- --------------------------------------------------
GG04123 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
GG04124 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
GG04131 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
GG04132 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
GG04133 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
GG04134 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
GG04138 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES
AND L ONG VARCHAR COLUMNS
GG04139 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES
AND L ONG VARCHAR COLUMNS
GG04144 DIAGNOSTIC ENHANCEMENTS FOR APPLY
GG04145 DIAGNOSTIC ENHANCEMENTS FOR APPLY
GG04164 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO
CHANGE S.
GG04165 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO
CHANGE S.
GG04166 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
GG04167 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
GG04168 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO
LOGS TO READ
GG04169 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO
LOGS TO READ
GG04170 CANNOT STOP CAPTURE WITH ASNCMD STOP COMMAND.
GG04171 DURING CAPTURE PROCESSING THE ASNPATH SYSTEM VARIABLE IS
BEING MISREAD
GG04172 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS
IN ALL CAPTURE VERSIONS.
GG04173 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS
IN ALL CAPTURE VERSIONS.
GG04174 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
GG04175 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IC27213 WRONG TIMESTAMP ON SNAPSHOT OUTPUT FOR DB2 EE 6.1 UNDER LINUX
IY03296 SQL2154 ON ATTEMPTED TABLESPACE RESTORE.
IY06938 IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT
BE RETURNING SQL30090 RC=6
IY09068 EVENT ANALYSER INFORMATION FROM AIX WILL NOT DISPLAY ON NT
IY09174 MIGRATION FAILS DUE TO DISK FULL
IY09385 SQL1042 DURING CRASH RECOVERY DUE TO INDEX MANAGER
PROGRAMMING ERROR (DIA3875C).
IY09469 SELECTING TABLES FROM OS/390 WHICH CONTAIN LOBS CAUSES
SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT.
IY09705 DB2 FORCE APPLICATIONS HANGS ON A NON-COORDINATOR NODE
IY09961 QUERY REWRITE DOESN'T PUSH DOWN PREDICATE INTO COMMON
SUBESPRESS ION
IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH
JDBC
IY10950 UNDERSCORES IN TABLE ALIAS CAUSE MS JET ENGINE ERROR WHEN
LINKIN G TABLES.
IY11074 SQL0101 ERROR WHEN RUNNING A QUERY DUE TO MEMORY
FRAGMENTATION PROBLEM AND LOW 'ULIMIT -D' VALUE.
IY11081 DATABASE GETS MARKED AS BAD AFTER FCM ERRORS FFFFFC7F IN
DB2DIAG.LOG FILE. EVENT MONITOR RESOURCE COULD NOT BE
OBTAINED.
IY11136 NO TEMP AVAILABLE ERROR IN DB2DIAG.LOG DURING ON-LINE BACKUP.
SQLB_BACKUP_IN_PROGRESS ON TEMPTABLESPACE FOR A SHORT PERIOD.
IY11353 SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE
SQLDESCRIBEPARAM
IY11377 DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11386 APAR IY06317 MAY RESULT IN POOR COST ESTIMATE OF MERGE JOIN
IY11436 DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO
PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY
PROCESSING.
IY11499 DB2 UDB - CRASH RECOVERY FAILS WITH AN SQL1042 ERROR.
MESSAGES IN THE DB2DIAG.LOG WE FAILED WHEN TRYING TO DROP A
BUFFERPOOL.
IY11527 DB2 UDB - SQL0901 ERROR WITH MESSAGE 'NON-PIPED PARALLEL SORT
ATTEMPTED' IN DB2DIAG.LOG.
IY11600 RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL
TO GET LOB DATA - PERFORMANCE DEGRADATION.
IY11648 MISLEADING ERROR MESSAGE IN DB2DIAG.LOG FOR QUIESCE RESET FOR
A TABLE FROM A NODE WHERE THE TABLE WAS NOT DEFINED.
IY11737 QUERY PATROLLER (DQPSETUP) IS RETURNING SQL1005 WITH JA_JP
CODEP AGE, BUT DBI1366E WITH EN_US CODEPAGE.
IY11766 ALTER TABLE REFERENCES CLAUSE DOES NOT ACCEPT DIFFERENT
COLUMN ORDERS IN FOREIGN KEY DEFINITION
IY11785 DB2_ALL WITH ':' OPTION ON SUN RETURNS STRANGE MESSAGES
IY11795 SQL1224 INSTANCE CRASH ON CLOSE AFTER A FAILED BIND TRAP IS
IN SQLRICLS_COMPLEX
IY11819 SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO
THE JAVA APPLICATION IN OUR CLI LAYER.
IY11865 SQL0902N ON STARTING PIPE EVENT MONITOR
IY11882 AUTOLOADER USES DB2ATLD_PWFILE WHEN AUTHENTICATION IS NOT SET
IY11901 TRAP IN SQLNO_PROJECT_QUN WHEN RUNNING A QUERY
IY11908 DB2 calls user exit with the wrong gid
IY11932 QUERY PATROLLER DOES NOT WORK PROPERLY WHEN LANGUAGE WAS
SELECTE D LANG=US_ENG.
IY11940 INDEX CORRUPTION WHEREBY DART ANALYSIS REPORTS 'DUPLICATE
FOUND' OR 'INDEX KEYS MISORDERED' OR 'BPS HEADER PAGE NUMBER
INCORRECT'
IY11945 APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE
ALLOCATED TO PROCESS.
IY11990 ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC.
IY12016 SQL0901N ON DYNAMIC SQL 'SQLNO_CRULE_SAVE_PLANS 100:RC(0)'
IY12035 SIGNAL 11 TRAP IN SQLRI_RESTORE_SPEC_REG_INFO()
IY12042 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12050 SQL2741N WHEN LOADING DATA AND SPECIFYING IMPLIEDDECIMAL AND
PACKEDDECIMAL MODIFIERS
IY12052 SEVERE PERFORMANCE DEGRADATION WITH HIGH SYSTEM CPU AND
CONTEXT SWITCHES. OCCURS AFTER PREDICTABLE DATABASE UPTIME
OF 4-16 DAYS
IY12074 GARBAGE COLLECTION IN HISTORY FILE AND NUM_DB_BACKUPS
IY12125 OWNER OPTION ON BIND MAY CAUSE INCORRECT AUTHS TO BE USED
IY12165 CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST
WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N
IN FP4E.
IY12168 INSTANCE MIGRATION FAILS FROM V5.X TO V6.1
IY12177 INDEX ON GENERATED COLUMN NOT TAKEN BY OPTIMIZER DURING
INSERT,D ELETE OR UPDATE.
IY12271 DB2CKMIG.BND COULD NOT BE OPEND AT DB2CKMIG COMMAND
IY12273 LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN
CANCELLED
IY12275 CLI CONVERSION FROM CHARACTER TO NUMERIC TYPES MAY CAUSE
SIGSEGV IF INVALID CHARS USED
IY12295 SIGNAL 11 TRAPS IN MEMORY OPERATIONS (MEMHOLDSEG AND
SQLOFMBLK) COMING FROM SQLNO_CLOSE_POOL
IY12299 DB2ADUTL TO RECOGNIZE ALL TYPES OF FS_TYPE AT QUERY FOR
BACKUP I MAGES
IY12396 POSSTR 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
IY12419 BACKUP OF DATABASE CONTAINING DATALINK COLUMNS FAILS WITH
SQL2424N, YET COPY DAEMON SUCCESSFULLY BACKED UP FILES.
IY12437 CALLING QUALIFIED STORED PROCEDURES FROM CLP RESULTS IN
CLI0150 DRIVER NOT CAPABLE ERROR
IY12449 V7.1 ADD CHECK CONSTRAINT PROBLEM FROM CONTROL CENTER
IY12536 MONITOR STATE DOES NOT RESET APPLICATION STATE ONCE COMPLETED
IY12545 SQL0104N RETURNED WHEN RUNNING DB2BATCH IN CLI MODE. HOWEVER,
RE SULT SET IS STILL CORRECT.
IY12566 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12567 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12568 CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12609 DB2 UDB - SQL1042 ERROR WHEN MAXAGENTS LIMIT HAS BEEN REACHED
AND DB2 REQUIRES AN ADDITIONAL AGENT.
IY12642 LOAD DOES NOT CHECK PARTITIONING KEY FOR EXCEPTION TABLE
IY12679 DB2IUPDT -W 64 (MIGRATION OF 32BIT INSTANCE TO 64 BIT) FAILS
WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE.
IY12725 DB2 UDB - CREATE INDEX CAUSING DATABASE TO COME DOWN. THE
DB2DIAG.LOG FILE INDICATES THAT AN OBJECT ID IS ALREADY IN
USE.
IY12726 DROPPING AN UNAVAILABLE TABLE ENDS WITH DIA3806C UNEXPECTED
END OF FILE
IY12751 STMT.GETSTRING() RETURNING NULL ON IN_OUT PARAMETER
IY12777 WHEN 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
IY12800 CAN'T RUN DB2GOV WITH SYSADMIN GROUP USER THAT IS NOT DB2
INSTANCE OWNER.
IY12821 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY12946 CLI ATTEMPTS TO CLOSE A CURSOR THORUGH THE CURSOR CONTROL
BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP.
IY12948 VISUAL EXPLAIN DISPLAYS INCORRECT '(DEFAULT)' KEYWORD UNDER
THE EXPLAINED COLUMN IN THE TABLE STATISTICS WINDOW.
IY12968 JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW
IY13010 WHILE TAKING SNAPSHOTS COUNTERS LIKE 'TOTAL BUFFER POOL READ
TIME (MS) ' ARE NOT CORRECT.
IY13012 THE CUSTOMER UPGRADED TO FP4D FROM FP4 TO ADDRESS APAR
IY09469. NOW THE CUSTOMER IS EXPERIENCING CLI0120E.
IY13014 SIGNAL #4 #11 USING HOP DRIVER
IY13053 HOST STORED PROCEDURE CALL WITH PARAMETERS RESULT IN DB21103W
IY13054 MISLEADING ERROR REPORTING ( -901) FOR WRONG SCRIPT TRYING TO
LINK UDF.
IY13098 SQL0970N WHEN TRYING TO DROP AN SQL PROCEDURE
IY13107 DB2 UDB - INDEX CORRUPTION PROBLEM CAUSES MISORDERING OF KEYS
IY13114 ENCINA SERVER AND DB2 V7 INTEROPERABILITY. ADDED XA_PREPARE
INSIDE ANOTHER TRANSACTION.
IY13118 RUNSTATS ON AN EXTENDED INDEX LEADS TO AN INFINITE LOOP
IY13171 DATABASE MIGRATION FROM V5 TO V6 FAILS WITH SQL0025W
IY13202 MEMORY OVERWRITE CAUSES A TRAP IN SQLIPREDNOTSAT DURING LOCK
ESCALATION
IY13226 AT QUERYPATROLLER STOP TIME, WE TRY TO DELETE A MESSAGE QUEUE
TH AT WAS ALREADY DELETED.
IY13252 DB2DCLGN COMMAND WITH A DECIMAL RESULT IN INCORRECT OUTPUT.
IY13307 SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON
UDB V.7.1
IY13312 QUERY OPTIMIZATION. BAD NESTED LOOP JOIN PLAN IS CHOSEN
AFTER MIGRATING TO V7. IO IS SIGNIFICANTLY UNDER-COSTED.
IY13327 DLFM RETRIEVE DOES NOT TAKE ANY PARAMETER
IY13329 'O' OPTION IN DLFM RETRIEVE DOES NOT WORK
IY13330 NO MESSAGE IS PRINTED INTO THE DB2DIAG.LOG FOR DLFMO_LOG
IY13331 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY13343 IMPORT IN CCA ON A CAE IS CATALOGING DIRECTLY TO A MAINFRAME
INSTEAD OF THROUGH A GATEWAY.
IY13410 IMPROPER HANDLING OF LOGS WITH RAW DEVICE AS ACTIVE LOG PATH.
GET SQL4970N WHEN ISSUING A ROLL FORWARD.
IY13466 SQL0198N - DESCRIBING STORED PROCEDURES WITH LONG NAMES
IY13473 BAD ACCESS PLAN CAN OCCUR IN EEE WITH DISTRIBUTION STATS
IY13596 IN V7.1 CC, ON-LINE BACKUP OPTION FOR EEE IS GREYED OUT.
IY13598 SQL1627W WHEN RUN DB2 GET MONITOR SWITCHES AFTER UPDATING
THEM FROM A 7.1 CLIENT.
IY13617 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES
AND L ONG VARCHAR COLUMNS
IY13696 SQL1273N ON ROLLFORWARD DATABASE (MISSING LOG FILE
S0000000.LOG)
IY13705 TRAPS (SIG #11) IN SQLM_GENERIC_CONVERT
IY13707 NEW PATCH2=41 IN CLI TO HELP USERS DO CASE INSENSITIVE
QUERIES: VIEWS HAS TO BE CREATED ON A TABLE TO UPPER CASE
EVERYTHING, THE
IY13738 FROM CLIENT TO AIX SERVER,JOB IS SCHEDULED THORUGH SCRIPT
CENTER WITH CORRECT USERID,NO MATTER WHAT PASSWORD,JOB
EXECUTES SUCESSF
IY13749 SQL2038 RC=32 DURING CAPTURE ACTIVITY.
IY13774 LOAD FAILURE (BUILD PHASE) MIGHT CAUSE SMP CORRUPTION
IY13799 PACKAGE CACHE ENTRY FOR SELECT DOES NOT INDICATE THAT DEFAULT
QUALIFIER (SCHEMA) HAS BEEN CHANGED
IY13802 CONTROL CENTER DOES NOT ALLOW DEFINING A REPLICATION
SUBSCRIPTION ON A VIEW REPLICATION SOURCE.
IY13807 DLFMUPDT FAILED WITH DBI1282. BACKUP_INSTINFO() IN DB2IUTIL
DOES N'T CONSIDER TO BACKUP DBM CFG FOR DLFMUPDT COMMAND.
IY13808 SIGNAL 11 TRAP IN SQLRR_DUMP_SECTION() DURING ERROR
PROCESSING
IY13832 MULTIPLE STORED PROCEDURES WITH SAME SPECIFIC NAME CAUSE
VARIOUS CLI/JDBC PROBLEMS
IY13841 APP. CURRENT CONNECTION CHANGED WHEN USING XA COMPLIANT
TRANSACT -ION MANAGER WITH DB2
IY13891 QUERY PERFORMANCE DEGRADATION V6.1
IY13893 ADD SUPPORT FOR THE COLUMN NAME UNDER MINMEM MODE FOR JDBC
IY13906 COMMENT IN DB2CLI.INI PREVENTS DATASOURCE FROM WORKING
PROPERLY IN DB2 V7.1
IY13927 PROBLEMS MIGRATION OLD PL1 APPLICATIONS TO UDB V7.1 HAVING TO
DO WITH THE CONNECTION INTERFACES
IY13951 MINMEMUSAGE KEYWORD CAUSES INCORRECT SQL_DBMS_NAME OUTPUT IN
SQLGETINFO()
IY13959 SQL0270N RC=40 DURING RESIZE/EXTEND OF CONTAINERS V7.1 FP1
IY13968 BAAN APPLICATION MAY EXPERIENCE -302
IY13970 CCA TRUNCATES HOSTNAME TO FIRST PART OF FOUR PART NAME
IY13979 -805, -818 SQLCODE RECEIVED FROM MULTITHREADED SQLJ APP IN A
UNIX ENVIRONMENT.
IY13992 ASNDLCOPY - INCORRECT MISLEADING MESSAGES WHEN DIR FILE
CONTAINS DIRECTORY THAT DOES NOT EXIST
IY13995 SQLFETCH() FAILS WITH -501 ERROR WHEN MINMEMUSAGE=1
IY13996 SYSIBM.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.
IY14035 FEDERATED CREATE SERVER COMMAND TRAPS EEE INSTANCES
IY14038 DB2 UDB - IN CERTAIN SCENARIOS IF AN AGENT FAILS WITH
ANSQL1040 (MAXAPPLS REACHED) ERROR, THE DATABASE WILL CRASH
WITH SQL1042.
IY14081 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14082 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14089 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE
WHEN THE .PID FILE IS DELETED
IY14090 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE
WHEN THE .PID FILE IS DELETED
IY14091 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE
WHEN THE .PID FILE IS DELETED
IY14094 DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE
WHEN THE .PID FILE IS DELETED
IY14095 ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14096 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY14097 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY14098 AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY14121 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES
AND L ONG VARCHAR COLUMNS
IY14123 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES
AND L ONG VARCHAR COLUMNS
IY14125 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES
AND L ONG VARCHAR COLUMNS
IY14126 CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES
AND LONG VARCHAR COLUMNS
IY14155 DIAGNOSTIC ENHANCEMENTS FOR APPLY
IY14156 DIAGNOSTIC ENHANCEMENTS FOR APPLY
IY14158 DIAGNOSTIC ENHANCEMENTS FOR APPLY
IY14159 DIAGNOSITC ENHANCEMENTS FOR APPLY
IY14242 CLI API SQLCOLUMNS FAILS WITH SQL0198N ERROR WHEN ISSUED
AGAINST A NEW DATABASE BEFORE BINDING THE CLI BIND FILES.
IY14253 MISSING PAGE IO DURING DB ROLLFORWARD (CORRUPTED LOGS)
IY14307 INDEX CORRUPTION, CONTINUATION OF IY11940
IY14312 KEY NOT FOUND ERROR FFFFF92C DURING DELETE OR DB2DART REPORTS
KEYS OUT OF ORDER ON AN INSPECTION.
IY14314 SQL1224 DB2 INSTANCE CRASH. THIS OCCURS BECAUSE OF MEMORY
CORRUPTION AFTER A COMMUNICATIONS ERROR - TRAP IN MEMTREEPUT
IY14353 DB2 GIVES INCORRECT ANSWERS, TERMINATE DB CONNECTION FROM CLP
OR HANG WHEN QUERIES ARE RUN FROM COMMAND CENTER.
IY14370 DUPLICATE KEY CREATED DURING REORG
IY14396 DRDA DUMP PRODUCED WHEN USING SPUFI ON OS/390 TO ACCESS A
FEDERA TED VIEW OF A NICKNAME IN UDB V.7.1
IY14406 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO
CHANGE S.
IY14407 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO
CHANGE S.
IY14408 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO
CHANGE S.
IY14409 CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATE WITH NO
CHANGES.
IY14410 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14411 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14412 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14413 CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14414 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO
LOGS TO READ
IY14415 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO
LOGS TO READ
IY14416 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO
LOGS TO READ
IY14417 CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO
LOGS TO READ
IY14418 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS
IN ALL CAPTURE VERSIONS.
IY14419 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS
IN ALL CAPTURE VERSIONS.
IY14420 CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS
IN ALL CAPTURE VERSIONS.
IY14421 CAPTURE DOES NOT HANDLE LARGE TABLE ID
IY14422 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14423 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14424 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14425 CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14500 DLFM GOES DOWN FROM LOCK TMEOUT WITHIN GARBAGE COLLECTOR
DAEMON
IY14639 BACK LEVEL CLIENT CRASHES (SIG#11) IN SQLRR_OPEN
IY14648 TRAP IN CLI WITH EARLYCLOSE, AUTOCOMMIT, AND BLOCK_FOR_NROWS
SET
IY14702 UPDATE ISSUE DEALING WITH STAR JOINS AND CODE GEN BUFFER
REUSE VS. OVERWRITE. THE UPDATE SUCCESSFUL BUT DOES NOT
UPDATE.
IY14713 TRAP - EXCEPTION C0000005 IN DB2SYSCS.EXE EXECUTING SQL TRAP
IS IN SQLNO_COST_MGJN DUE TO INVALID POINTER
IY14741 SET INTEGRITY USING EXCEPTION TABLE FAILS WITH SQL0901 WHEN
THE EXCEPTION TABLE HAS THE OPTIONAL COLUMN OF CLOB(32K)
IY14752 AIX ONLY: DB2MEMDISCLAIM IS NOT INTERPRETED CORRECTLY ON
VERSION 7. IF SET TO ANYTHING, IT IS OFF, IF NOT SET, IT IS
ON.
IY14769 SOLARIS: DEADLATCH AT V7.1 FP1 CAUSES HANG
IY14770 SIGNAL 11 IN SQLVDIVIDE
IY14775 CREATE TABLE LOOPS AND USES ALL OF THE LOG SPACE
IY14777 PREPAREDSTATEMENT.SETLONG() CALL FAILS TO DB2/390
IY14849 SQL0901N SYSTEM ERROR WITH REASON: UNRESOLVED QNC
IY14894 TURNING ON THE SPECIAL FEATURE USE_LIGHT_OUTPUT_SQLDA CAUSES
THE CLIENT TO HANG.
IY14901 SQLFREECONNECT/SQLFREEHANDLE RELEASES THE CONNECTION LATCH
IY14979 QUERY PATROLLER LIMITATION: 18 CHARACTERS FOR COLUMN NAME
LENGTH
IY14989 INSTANCE CRASH ON ROLLFORWARD: SIGNAL 11 IN
SQLPRFWD__FP7SQLEACB8SQLP_LSNUL
IY15036 GLOBAL TEMP TABLE CAUSING A TRAP WITH SIG 11
IY15049 INSERT HANGS IN SQLPGPST
IY15118 DB2 UTILITIES FAIL WHEN DYN_QUERY_MGMT IS TURNED ON
IY15135 KEY NOT FOUND ERROR (FFFF F92C) ON AN INDEX IN A 32K PAGE
TBSP
IY15192 ADD FUNCTIONALITY TO OBTAIN A MINIMUM SCALE OF 6 FOR
DIVISION.
IY15250 AIX ONLY: DB2MEMDISCLAIM CAN CAUSE SORTHEAP ALLOCATION
ERRORS, TRAPS, DEFUNCT DB2AGENTS DUE TO LEAKING VIRTUAL
MEMORY.
IY15289 WRONG OR DIFFERENT RESULTS RETURNED BY SELECT ON VIEWS V7.1
ONLY
IY15369 QUERY RUN AT OPT LEVEL 0 RETURNED WRONG RESULTS.
IY15397 CREATE PROCEDURE CALL FROM NON-CATALOGUED NODE TRAPS.
IY15469 BAD OPTIMIZER PLAN LEADS TO INCORRECT RESULTS IN EEE FOR AST
IY15629 INCORRECT FILE SIZE ESTIMATES FOR BACKUP TO ADSM/TSM
JR14166 NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1
JR14504 SQLFREESTMT TRAP DELETING CCB AFTER XA_END CALL
JR14645 SQLSPECIALCOLUMNS FAILS WITH SQL0303N INSTEAD OF RETURNING
NAME OF COLUMN DEFINED FOR THE PRIMARY KEY WHEN USING MS
QUREY
JR14647 JAVA CC DOES NOT ALLOW NUM_POOLAGENTS TO BE SET TO 0.
JR14743 DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM.
JR14749 SQL0291 TRYING TO ACCESS TEMPORARY TABLESPACE WHEN THERE ARE
TEMP TABLEPSACES OF DIFFERENT PAGESIZES:'NO TEMP AVAILABLE'
JR14758 WITH SPECIFIC SETTINGS EVERY COMMAND ISSUED FROM COMMAND
CENTER ON NT/UDB EE V5.2/FIXPACK 12 RECEIVES DB21005E ERROR.
JR14777 QUERY TRAPS SERVER. TRAPPING FUNCTION IS SQLKT_PACK_TUPLE.
JR14781 SQL_ATTR_MAX_ROWS DOESN'T REDUCE THE RESULTSET FROM DB2/390
IF SQLEXTENDEDFETCH() IS USED TO RETRIEVE RESULTS.
JR14791 SQLEXTENDEDFETCH - FETCH PRIOR - FAILS TO RETRIEVE ROW IN 1
ROW RESULT SET FOR A STATIC SCROLLABLE READ-ONLY SERVER-SIDE
CURSOR.
JR14795 DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442
JR14809 NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2
SERVER F OR DATAJOINER.
JR14815 DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A
STATEMENT ALREADY CLOSED.
JR14841 AN SQL0525N ERROR OCCURS WHEN DB2BATCH IS EXECUTED AGAINST AN
OS 390 DATABASE.
JR14844 USERS WHICH BELONG TO THE SYSADM_GROUP DEFINED IN THE DBM CFG
CA NNOT ISSUE A DB2STOP, WHETHER DOMAIN OR LOCAL USERS
JR14846 CONTROL CENTER GENERATES INVALID WHEN DEFINING REPLICATION
SOURCES AND SUBSCRIPTIONS IF ASN.IBMSNAP_CCPPARMS IS EMPTY
JR14854 NT: CONNECT HANGS RESULTING FROM LATCH ON GLOBAL INSTANCE
QUEUE
JR14860 JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING
SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN
JR14867 MF AND IBM STORED PROCEDURES WON'T PRECOMPILE. NEED TO PUT A
VERSION CHECKING FOR CALL STATEMENTS.
JR14876 08/00 duplicate object error occurs while importing to DWC
JR14892 CHANGE WIN32 API CALL DUE TO LONG CONNECT DELAYS WHEN THERE
ARE DISCONNECTED MAPPED NETWORK DRIVES: NT TERMINAL SERVER
ONLY.
JR14894 SQL0900 DATABASE CRASHES ON QUERY WITH RID SCANS AND LIST
PREFETCHING IF BINSORT ENABLED
JR14895 INCORRECT DISPLAY OF DECIMAL SEPARATOR: DISPLAYS ',' INSTEAD
OF '.' IN CC FOR BOTH V6.1 AND V7.1
JR14897 JDBC TIMING HOLE MAY ALLOW GARBAGE COLLECTOR TO CLOSE OBJECTS
WE HOLD REFERENCE TO
JR14905 DB2 CC - CREATING INDEXES WITH DUPLICATE NAMES WHEN DEFINING
MUL TIPLE TABLES AS REPLICATION SOURCE
JR14921 INSERT INTO REAL COLUMN ON DB2/390 DATABASE FAILS
JR14924 INCORRECT CALL TO HOST TO RETRIEVE CURRENT TIMEZONE.
JR14926 TRAP IN SQLJIFSR.C
JR14928 SQL1092 ON DROP DB ON CLIENT DESPITE CATALOG_NOAUTH
JR14929 TABLE UDFS WITH DECIMAL PARAMETERS SHOW LENGTH AND SCALE OF 0
IN SYSCAT.FUNCPARMS
JR14931 EVENT ANALYZER (CONTROL CENTER) IS TOO SLOW LOADING AND
SORTING EVENT FILES
JR14932 -502 AFTER USING SQL_CLOSEOPEN CLI ATTRIBUTE
JR14933 Support ETI DA version (4.x)
JR14990 OUTPUT PARAMETERS NOT INITIALIZED TO NULL
JR14996 CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN
CLI0104E
JR15008 SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR
JR15025 DR.WATSON IN DB2SYS.DLL WHEN LOGING OFF NT (MTS AND DTC)
JR15036 COMMAND CENTRE LOGON DIALOG FAILS TO GO ON THE TOP
JR15040 QUERY RE-WRITE SHOULD REMOVE FALSE PREDICATES (EG. 1=0) FOR
THE OPTIMIZER.
JR15042 CODEPAGE V5.2 IN BACKUP IMAGE USES CODEPAGE 850 INSTEAD OF
CODES ET. V6&7 WILL NOT READ THIS
JR15046 RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN
JDBC
JR15073 EXCEPTION 5 TRAP DURING STAR JOIN PLANNING
JR15081 CLI COMMIT BETWEEN PREPARE AND DESCRIBE MAY CAUSE CLI0125E
FUNCTION SEQUENCE ERROR
JR15082 CUS ATTEMPTS LARGE LOAD AND FAILS WHEN INDEX REBUILD.
JR15084 SIGNAL #11 IN SQLNQ_MEMMGR::DESTROY. THIS APAR WILL FORCE A
-901 TRACEBACK TO GATHER MORE INFO ON NEXT OCCURRANCE.
JR15085 WHENEVER THE CUSTOMER GOES TO GET THE SOURCE STORED PROCEDURE
CODE IN THE STORED PROCEDURE BUILDER HE GETS SQL0514.
JR15138 DR.WATSON IN DB2CLI.DLL WITH JDBC APP CALLING STORED
PROCEDURES
JR15141 V7.1 CC'S RUNSTATS WINDOW CAN'T BE CLOSED WITH 'CANCEL'
BUTTON.
JR15145 APAR fix - import errors 3303 and 3807 on
validate_relationshi
JR15158 DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION
- SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY
USAGE
JR15159 EXCEPT ALL IN SQL STATEMENT RETURNS SQL0415 WITH SQLSTATE
42825. AND/OR INCORRECT RESULTS DURING SQL EXECUTION.
JR15200 USE OF {?=CALL SPNAME(?)} SYNTAX MAY RESULT IN CLI0102
INVALID CONVERSION ERRORS
JR15202 RESTORE/MIGRATION (SQL2517W) CONTROL CENTER -
>
JOURNAL STATUS IS 'FAILED'
JR15206 KEYSET PARSER RETURN CODE=1002 CAUSES HEAP CONSUMPTION
JR15212 CONNECTION.GETCATALOG() RETURNS AN EMPTY STRING INSTEAD OF
NULL
JR15213 SQLMORERESULTS() DOES NOT HANDLE ERRORS FROM BATCHED COMMANDS
JR15214 EXECUTEBATCH() SHOULD RETURN INT0 IF BATCH IS EMPTY
JR15215 BATCHUPDATEEXCEPTION SHOULD BE THROWN IN EXECUTEBATCH, NOT
ADDBATCH IF THERE IS AN ERROR IN THE BATCH STATEMENT
JR15216 JAVA APPLICATION TRAPS WHEN HDBC=0
JR15220 SQLPUTDATA() MAY RESULT IN SQL0157N UNDER HIGH CONCURRENCY
JR15238 INCONSISTENT RESYNC (OS/390 ABORTS, UDB COMMITS)
JR15239 SETMAXFIELDSIZE(), SETMAXROWS(), SETQUERYTIMEOUT() SHOULD
RETURN SQLEXCEPTION WHEN INPUT VALUE IS INVALID - JDBC
JR15250 GETUDTS (JDBC) SHOULD RETURN AN EMPTY RESULTSET IF NOT
SUPPORTED
JR15251 STATEMENT RESULTSET SHOULD BE SET TO NULL AFTER REUSE
JR15256 THIN CLIENT INSTALL DOES NOT UPGRADE THE V.1.X WINSOCK TO
V.2.0 ON WINDOWS 95
JR15263 SQL COMMENT LINES (STARTING WITH --) IN THE COMMAND CENTER -
INTERACTIVE PANEL ARE NOT HANDLED CORRECTLY
JR15287 NT/7.1FP1 - WR21198 : 'CPYSETUP.BAT...' ->
'THE SYSTEM CANNOT FIND THE FILE SPECIFIED.' -
>
COPY NOT USABLE -> CANNOT UPGRADE
JR15318 TRAP DURING COMPARE DATE STRING AND AN EMPTY VARCHAR STRING
JR15330 SQL 107 RECEIVED WHEN CALLING STORED PROCEDURES ON A HOST
SYSTEM THROUGH A V7.1 GATEWAY
JR15425 LOAD WITH MODIFIED BY USEDEFAULTS CLAUSE CAUSES NULL FIELDS
TO BE INCORRECTLY POPULATED WITH DATA.
APAR fixes included in WR21197f (Fixpak 1f)
APAR No. Abstract
-------- --------------------------------------------------
IY12165 CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST
WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N
IN FP4E.
IY13307 SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON
UDB V.7.1
IY13312 QUERY OPTIMIZATION. BAD NESTED LOOP JOIN PLAN IS CHOSEN
AFTER MIGRATING TO V7. IO IS SIGNIFICANTLY UNDER-COSTED.
IY13565 DB2DIAG.LOG: DIA9999E ERROR CODE 2, SQLRA_LOAD_DYN_STMT - CAN
OCCUR ON SNAPSHOT BUT IS INFORMATIONAL ONLY - NO EFFECT TO
USER
IY13707 NEW PATCH2=41 IN CLI TO HELP USERS DO CASE INSENSITIVE
QUERIES: VIEWS HAS TO BE CREATED ON A TABLE TO UPPER CASE
EVERYTHING, THE
JR15158 DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION
- SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY
USAGE
APAR fixes included in WR21197e (Fixpak 1e)
APAR No. Abstract
-------- --------------------------------------------------
IY12177 INDEX ON GENERATED COLUMN NOT TAKEN BY OPTIMIZER DURING
INSERT,D ELETE OR UPDATE.
IY13098 SQL0970N WHEN TRYING TO DROP AN SQL PROCEDURE
IY13307 SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON
UDB V.7.1
JR14795 DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442
JR15046 RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN
JDBC
JR15081 CLI COMMIT BETWEEN PREPARE AND DESCRIBE MAY CAUSE CLI0125E
FUNCTION SEQUENCE ERROR
APAR fixes included in WR21197d (Fixpak 1d)
APAR No. Abstract
-------- --------------------------------------------------
IY11353 SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE
SQLDESCRIBEPARAM
IY12968 JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW
IY13226 AT QUERYPATROLLER STOP TIME, WE TRY TO DELETE A MESSAGE QUEUE
TH AT WAS ALREADY DELETED.
JR14815 DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A
STATEMENT ALREADY CLOSED.
JR14929 TABLE UDFS WITH DECIMAL PARAMETERS SHOW LENGTH AND SCALE OF 0
IN SYSCAT.FUNCPARMS
JR15008 SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR
APAR fixes included in WR21197c (Fixpak 1c)
APAR No. Abstract
-------- --------------------------------------------------
IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH
JDBC
IY12751 STMT.GETSTRING() RETURNING NULL ON IN_OUT PARAMETER
IY12946 CLI ATTEMPTS TO CLOSE A CURSOR THORUGH THE CURSOR CONTROL
BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP.
IY13118 RUNSTATS ON AN EXTENDED INDEX LEADS TO AN INFINITE LOOP
JR14166 NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1
JR14809 NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2
SERVER F OR DATAJOINER.
JR14996 CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN
CLI0104E
APAR fixes included in WR21197b (Fixpak 1b)
APAR No. Abstract
-------- --------------------------------------------------
IY06938 IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT
BE RETURNING SQL30090 RC=6
IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH
JDBC
IY11436 DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO
PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY
PROCESSING.
IY11908 USER EXITS RUN WITH WRONG RGID ON UNIX.
IY11945 APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE
ALLOCATED TO PROCESS.
IY12273 LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN
CANCELLED
IY12679 DB2IUPDT -W 64 (MIGRATION OF 32BIT INSTANCE TO 64 BIT) FAILS
WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE.
JR14867 MF AND IBM STORED PROCEDURES WON'T PRECOMPILE. NEED TO PUT A
VERSION CHECKING FOR CALL STATEMENTS.
JR14897 JDBC TIMING HOLE MAY ALLOW GARBAGE COLLECTOR TO CLOSE OBJECTS
WE HOLD REFERENCE TO
JR14921 INSERT INTO REAL COLUMN ON DB2/390 DATABASE FAILS
JR14924 INCORRECT CALL TO HOST TO RETRIEVE CURRENT TIMEZONE.
JR14926 TRAP IN SQLJIFSR.C
APAR fixes included in WR21197a (Fixpak 1a)
APAR No. Abstract
-------- --------------------------------------------------
IY11353 SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE
SQLDESCRIBEPARAM
IY11377 DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11600 RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL
TO GET LOB DATA - PERFORMANCE DEGRADATION.
IY11819 SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO
THE JAVA APPLICATION IN OUR CLI LAYER.
IY11990 ADDED 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
JR14743 DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM.
JR14815 DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A
STATEMENT ALREADY CLOSED.
JR14860 JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING
SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN
JR14876 DUPLICATE OBJECT ERROR OCCURS WHILE IMPORTING TO DWC
APAR fixes included in WR21197 (Fixpak 1)
APAR No. Abstract
-------- --------------------------------------------------
IY06572 SEGMENTATION FAULT WHEN BINDING A SECOND TIME TO A CURSOR
IY06740 DB SIZE ESTIMATE CALCULATED INCORRECTLY FOR BACKUP TO ADSM.
HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE.
IY07623 SIGNAL #11 TRAP IN SQLORQUE2()
IY08453 SQL1227 RC 6 WHEN ATTEMPTING TO UPDATE STATISTICS WITH TABLE
CARDINALITY OF 0 WHEN STATISTICS ALREADY EXIST
IY08684 SQL0107 RETURNED BY CLI DRIVER ON SQLFETCH CALL TO DB2 MVS.
IY09151 LOAD REPLACE OF AN EMPTY FILE (IXF) DOES NOT REPLACE EXISTING
ROWS IN THE TABLE THE EMPTY FILE IS BEING LOADED INTO.
IY09262 CHANGE THE DEFAULT SQL_CONCURRENCY AS READ_ONLY BASED ON THE
CLAUSES PRESENT IN THE STATEMENT.
IY09663 DB2 CRASHED WITH ERROR DIA3816C CREATED BY
SQM_EVMON_OSTREAM() SIG 11
IY09756 NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS.
REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT
STRIPED.
IY09764 TWO QUERIES DIFFERING ONLY IN THE ORDER OF THE PREDICATES,
RETURN DIFFERENT RESULTS.
IY09948 JAVA STORED PROCEDURES NOT FOUND OUTSIDE SQLLIB\FUNCTION
IY09966 JAVA.SQL.TIMESTAMP RECEIVING INVALID
ARGUMENT(NANOS>
999999999 OR
<
0) WHEN MULTIPLE THREADS MAKES THE CALL.
IY10004 DB2JD TERIMINATES WITH EXCEPTION, WHEN USING HISTORY OPTION
OF CONTROL CENTER FROM WINDOWS 95.
IY10029 QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204
IY10034 May13: Install V6.1 FP/EEE/NT may add incorrect EE DB2
Services
IY10047 DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI
IY10180 COMPOUND SQL APPLICATION CORE DUMPS WITH GREATER THAN 60 SQL
STATEMENTS.
IY10183 TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/
CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4.
IY10199 LEFT OR FULL OUTER JOIN PROBLEM WITH OPTIMIZER
IY10280 RANDOM CLI0606E/CLI0611E ERRORS FROM A MULTI-THREADED JDBC
APP WHEN ALL THE THREADS USE A SINGLE CONNECTION.
IY10302 PCBVALUE INCORRECTLY POPULATED ON SQLGETDATA FOR WCHAR WITH
CBMAXVALUE=2 ON UNIX.
IY10390 TERMINATING ADSM SESSION BEFRO RE-ESTABLISHING IT.
IY10430 BACKUP IMAGE NOT FOUND ERROR RESTORING TBSP FROM FULL DB
BACKUP (LEGATO SPECIFIC)
IY10432 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION
PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY
IY10469 CORRUPTION IN RECOVERY HISTORY FILE ON DROP TABLE RECOVERY
ITEM
IY10475 IWM_TRACKER PRODUCES SQL0305N WHEN TRACKING A SUMMARY TABLE
IY10484 LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN
SQL0973.
IY10491 SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1
IY10499 OPTLEVEL 5 PLAN WORSE THAN OPTLEVEL 3 PLAN
IY10504 CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH
JDBC
IY10562 DB2 UDB INTRA_PARALLEL ON - QUERY RETURNS AN SQL0955 ERROR
AFTER WHICH ALL QUERIES WHICH REQUIRE SHARED SORT MEMORY
FAIL.
IY10579 DB2 UDB - SIGNAL 11 TRAP IN FUNCTION SQLDHASHZVALUE WHEN
RUNNING REORGCHK ON VARIOUS TABLES.
IY10585 SQL0501 AFTER SQL0437W IN CLI APPLICATION. RETRY LOGIC
FAULT.
IY10615 SQL10003 ERROR RETURNED TO USER APPLICATIONS, AND LOGGED IN
THE DB2DIAG.LOG FILE. MEMORY LEAK IN BSU HEAP
IY10625 SNAPSHOT FOR TABLES, IF MORE THAN 1 TABLE HAS A NULL NAME,
DB2 TRAPS.
IY10668 Memory corruption caused by TQS - dirty partial_tuple_saved
flg
IY10765 APPLICATION HANG IN FCM ON VERY FAST MACHINE
IY10794 JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION
PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY
IY10803 LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD
TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N.
IY10816 CLI0111E ON INSERT OF DECIMAL 0.00=<
X=<0.99
IN SQLJ STORED PROC
IY10861 DATABASEMETADATA.GETCOLUMNS IS NOT HANDLING SCHEMAPATTERN=''
CORRECTLY.
IY10901 IMPORT FROM PIPE ASC BREAKS AT END OF BUFFER. ALTHOUGH IMPORT
COMPLETES SUCCESSFULLY, ALL DATA IS NOT IMPORTED.
IY10902 CREATE VIEW WITH SCHEMA NAME TOO LONG GIVES SQL0901N THE SQL
STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR.
IY11030 SQL30083 RC 24 WHEN TRYING TO CHANGE A PASSWORD LOCALLY FROM
THE DB2 CLP USING A VALID PASSWORD
IY11063 AN APPLICATION HANGS (AN AGENT STUCK IN MONITOR CODE)
IY11097 NULL BUFFER FROM FCM PASSED TO SQLKQ_DETACH_BUFFER LEADING TO
HANG ON SMP OR MPP MACHINES.
IY11116 DB2ATLD HANGS WHEN THE FILE_TRANSFER_CMDFAILS WITH A NON-ZERO
R ETURN CODE.
IY11141 DB2JD TERMINATES IF IT CAN'T SPAWN ANY PROCESSES.
IY11217 SQJ0001W WITH SQL0104N WHEN ISSUING DB2PROFC ON SQLJ
APPLICATION
IY11218 INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES
IY11255 DB2LOOK -U OPTION RETURNS TABLES WITH GIVEN CREATORID AS
SCHEMA INSTEAD OF TABLES THAT WERE CREATED BY THAT CREATORID
IY11275 MULTISITE UPDATE HANGS WITH CC
IY11283 ISSUING DB2IUPDT OVERWRITES THE DB2AUDIT.CFG WITH THE DEFAULT
CONFIGURATION.
IY11343 BAD PERFORMANCE WHEN A LOB IS PASSED INTO A UDF
IY11375 USEREXIT IS NOT BEING INVOKED EVEN THOUGH IT HAS BEEN SET UP
PROPERLY.
IY11377 DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11443 RECONCILE RETURNS SQL2554N RC=5.
IY11466 DEADLOCK CAUSED BY NEXT KEY LOCKING IN CATALOGS
IY11620 DB2 UDB - PERFORMANCE DEGRADATION DUE TO OPTIMIZER
INCORRECTLY ESTIMATING THE CARDINALITY OF AN INDEX SCAN
JR13044 MS INTERDEV RECEIVES CLI0002W AFTER FETCH FROM
SQLPROCEDURECOLUM NS()
JR14068 PCOMM ALLOWS '#' IN THE PARTNER LU NAME BUT DOES NOT ALLOW
'#' I N THE SYM_DEST_NAME.
JR14349 SQLDESCRIBEPARAM RETURNING CLI0150E, DRIVER NOT CAPABLE.
JR14415 TRAP - MTS AND STORED PROCEDURES WHICH RETURN RESULT SETS
JR14417 CPU TIME INCORRECTLY CALCULATED. RESULT IS TOO BIG.
JR14446 CLI ACCESS VIOLATION USING DOWNGRADED KEYSET CURSOR AGAINST
MVS
JR14491 THE BIND FILENAME IS TRUNCATED IF >
50 CHARS
IN SQLAJBND_BIND.
JR14517 SQL1092 WHEN CREATING DB ON REMOTE SERVER FROM CLIENT.
CATALOG_NOAUTH IS IGNORED.
JR14521 JAVA COMMAND CENTER RESULTS GREYED OUT WHEN SCROLLING.
JR14550 JAVA COMMAND CENTER WIN9X RESULTS >
4682 CHAR
DISPLAY PROBLEM
JR14576 JDBC NET DRIVER RETURNS SAME RESULTS WITH PREPAREDSTAMENT.
JR14592 CONNECT TO DATABASE ON NT HANGS IN STRICMP() C LIBRARY CALL
JR14595 SQLDRIVERCONNECT IS SIGNIFIGANTLY SLOWER IN DB2 V6.1 COMPARED
TO V5.2
JR14605 DIA3419C--NETBIOS NOT STARTED SUCCESSFULLY RC 3
JR14606 EXPORT OF DEL MODIFIED BY DECPT SUBSTITUTES PERIOD FOR ANY
CHARACTER FOR ITALIAN VERSION DB2 ON NT
JR14625 NT PERFORMANCE MONITOR NOT PROVIDING DETAILS FOR THE SECOND
AND FOLLOWING APPLICATIONS
JR14646 ADDING XBSA SUPPORT TO DB2 NT FOR SAP
JR14648 DBA3037 ON VISUAL EXPLAIN WHEN DETAILED STATISTICS COLLECTED
ON SOME BUT NOT ALL INDEXES FOR A GIVEN TABLE
JR14723 SQL1112 -NOT ENOUGH SYSTEM RESOURCES WHEN TRYING TO SCHEDULE
~100 JOBS FROM THE SCRIPT CENTER
JR14737 THE CLIENT IS INCORRECTLY CREATING MULTIPLE SNA CONVERSATIONS
USING THE SAME LUWID. THIS IS CAUSING DB2 OS 390 TO ABEND.
JR14742 DB2JDS.EXE GOES DOWN ON A VERY LARGE SELECT WITH ONE
PARTICULAR USER
JR14759 LOAD OF DEL FILE WHEN BOTH' CAST(NULL AS CHAR) USED IN
EXPORT' & MODIFIED BY USEDEFAULTS IN LOAD : DATE INSERTED IS
WRONG
JR14780 SQL0750N WHEN TRYING TO RENAME TABLE WITH IDENTITY COLUMN.