| APAR fixes included in WR21254 (Fixpak 3) |
| APAR | ABSTRACT |
| GG03862 | EVENT DRIVEN SUBSCRI
PTION 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 N
OSLEEP 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 E
RROR OCCURS (ASN1001E, SQL30081), THEN APPL RETURNS WITH RC=0 TO THE OS |
| GG04129 | APPLY FAILED SQLCODE
30090 AFTER PROCESSING 'S' SQL STATEMENTS |
| GG04136 | INSERT OF A NEW PRIM
ARY 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 FIL
ES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR |
| GG04161 | APPLY PRODUCING DSNL
500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG. |
| GG04189 | FULLREFRESH FROM SEC
OND TIER CCD TO 3RD TIER CCD DID NOT WORK. |
| GG04190 | APPLY BINDS USING PR
UNE LOCK TABLE WILL NOT BIND TO CAPTURE/VM WHICH DOES NOT HAVE THIS TABLE. |
| GG04194 | CAPTURE USES TOO MUC
H 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 INV
OKE RUNSTAT AFTER DIFFERENTIAL REFRESH |
| IY12425 | DBI1034W WARNING DUR
ING DB2SETUP ON SUN INSTALL IS CONFUSING OR WRONG IF CORRECT JAVA (JDK/JRE) VERSION IS INSTALLED |
| IY12823 | REINIT CMD WAS IGNOR
ED WHEN THERE IS NO CHANGES TO CAPTURE |
| IY13019 | TRAP (SIG 11) IN SQL
NO_UNION_SETSN |
| IY13147 | COST OF THE QUERY IN
CREASES AS THE BUFFER POOL COUNT INCREASES. DB2EXFMT COST GROW AS THE BUFFERPOOL GETS INCREASED. |
| IY13655 | ADD NEW DB2LOOK SCHE
MA OPTION REMOVED BY DEFECT 153542 |
| IY13818 | -804 ERROR IN APPLY
SQL0804N SQL0804 |
| IY13958 | DB2ATLD WITH THE DUM
PFILES OPTION IS CREATING DUMPFILES WITH THE INCORRECT OWNER ID |
| IY14016 | PATH TO DSM.SYS AND
DSM.OPT WHEN USEREXIT ENABLED |
| IY14030 | ROLLFORWARD COMPLAIN
S 'LIFELSN MISMATCH FOR REORG-REDO |
| IY14152 | CAPTURE UNABLE TO FI
NISH PRUNING WHEN LOG FILE SYSTEM BECOMES FULL (SQL0964C) |
| IY14154 | CAPTURE NEEDS TO REI
NIT LONG FIELD DATA STRUCTURES FOR ANY NEW REGISTRATION PICKED UP BY THE REINIT COMMAND |
| IY14222 | AUTOBINDER FAILING A
GAINST FEDERATED DATABASES IN DB2V7 |
| IY14234 | DB2LOOK FAILS WITH T
ABLENAMES CONTAINING SLASHES |
| IY14240 | TO BETTER EXPLAIN CO
MPILER OPTIONS FOR DB2UEXT2.CADSM SAMPLE PRO GRAM |
| IY14278 | CONTOL CENTER - ALTE
R TABLE - ADD COLUMN FAILS WITH SQL30081 TCP/IP ERROR '*','*', '0' |
| IY14291 | CAPTURE CORE DUMPS W
ITH 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 LO
OP 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 ALLOCAT
ION OF LOG FILE CAUSES DATABASE TO SHUTDOWN |
| IY14858 | CAPTURE SHUTS DOWN W
HENEVER IT RECEIVES SQLCODE 2653DURING COLD START. |
| IY15022 | CONVERSION TABLE ERR
OR MESSAGE IS INCOMPLETE |
| IY15068 | INCORRECT FILTER FAC
TOR 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 WH
EN 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 (EX
PRESSION) FAILS WITH COMPLEX EXPRESSIONS |
| IY15152 | FAILED 'BACKUP DB <CODE><</CODE>DBALIAS<CODE>></CODE> ... ADSM ...' ARE NOT BEING CLEANED IN ADSM CAUSING 'DB2ADUTL' TO RETURN EXTRANEOUS RE
SULTS |
| IY15185 | CCA ON NON-DRDA CLIE
NTS IMPORTING SERVER PROFILE CATALOGS EXTRA NODES. |
| IY15189 | USER WITH ONLY SELEC
T PRIVILEGES ON A VIEW IS ABLE TO UPDATE THE TABLE USING A CURSOR UPDATE ON THE ALIAS OF THE VIEW. |
| IY15200 | CLOSING SINGLE CONNE
CTION AFTER MULTIPLE CONNECTION IS ESTABLISH TO REMOTE SEVER RESULTS IN CLI0106E ERROR ON IRIX PLATFORM. |
| IY15209 | SQL_INVALID_HANDLE E
RROR IS RECEIVED WHEN SQLTABLES IS CALLED BEFORE SQLCOLUMNS. |
| IY15286 | CAPTURE PRUNING PROB
LEMS WHEN LOGRETAIN=CAPTURE |
| IY15287 | DB2 MEMORY LEAK FOR
UDF WITH CLOB PARAMETER WHERE UDF RETURNS AN ERROR |
| IY15297 | COBOL APPLICATION NO
T HANDLING LARGE NUMBER OF HOST VARIABLES. |
| IY15354 | PARSER IS NOT DETECT
ING A SYTAX ERROR IN CREATE PROCEDURE. |
| IY15403 | FUNCTION TEMPLATE SY
NTAX 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 -<CODE>></CODE> BACKUP EXISTS/VALID, BUT UPDATING HISTORY FILE WAS NOT, REPORTED AS FAILURE |
| IY15448 | CLI LAYER NOT RECOGN
IZING 'I'(INCLUDE) RETURN FOR DT_SRCE_BEG IN SQLGETDATA. |
| IY15468 | AFTER CATALOGUING LO
OPBACK AT SERVER, LUWID ON SERVER AND OS390 DO NOT MATCH |
| IY15508 | SQL1084 - SHARED SEG
MENT 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 VIOLATIO
N |
| IY15596 | QUERY PATROLLER - EX
PLAIN MODE = EXPLAIN FAILS |
| IY15665 | IWM_TRACKER DOES NOT
PROCESS QUERIES THAT RETURN DON'T RETURN ANY COLUMNS (EG. SELECT COUNT (*) FROM TABLE1) |
| IY15676 | MULTITHREADING ENVIR
ONMENT CAUSES FORKED CHILD TO BE SPUN OFF IN TO MUTEX. |
| IY15691 | AFTER OS390 IS RECYC
LED, CONNECTIONS TO IT RECEIVE SQL0902 UNTIL OF THE OLD CONNECTIONS IN THE CONNECTION POOL HAVE BEEN FAILED. |
| IY15730 | INSTANCE CRASH ON TR
AP (SIGSEGV) IN SQLBLATCHPINNEDPAGE EEE ONLY. INTERNAL SYNCHRONIZATION PROBLEM EXECUTING SQL. |
| IY15739 | DB2EXMIG WILL FAIL W
ITH SQL0104 (SYNTAX ERROR) ON A RENAME TABLE STATEMENT |
| IY15749 | SEGMENTATION FAULT U
SING IWM_TRACKER |
| IY15758 | DB2LICM -A CHANGES P
ERMISSIONS ON /VAR/IFOR. NOBODY EXCEPT ROOT CAN COMPILE (IBM C/C++ COMPILER) |
| IY15793 | FP INSTALL BREAKS DJ
XLINK WHEN WORKING WITH V.8.1.X ORACLE CLIENTS |
| IY15798 | DB2DATASOURCE NOT HA
NDLING CONNECTIONS PROPERLY |
| IY15827 | PERFORMANCE WIZARD F
ROM CONTROL CENTER RECEIVES DBA1107 WHEN NLS AIX SERVER IS USED. |
| IY15829 | SIGNAL 11 IN SQLDADJ
USTSEQDETPFAMOUNT |
| IY15846 | ABEND WHEN USING VAR
CHAR 600 FOR BIT DATA |
| IY15853 | HANG IN COMMAND CENT
RE WHEN LAUNCHING VISUAL EXPLAIN |
| IY15858 | CAPTURE SHUTS DOWN W
HENEVER IT RECEIVES SQLCODE 2653DURING COLD START. |
| IY15861 | USEREXIT FAILED, BEC
AUSE DATABASE ACTIVATED AFTER OFFLINE BACKUP |
| IY15865 | CAPTURE IGNORES SQLC
ODE -2038.THIS IS A WORKSTATION-ONLY PROBLEM |
| IY15866 | CAPTURE MIGRATION NO
T ALLOWED DUE TO SQLCODE -2656. |
| IY15913 | CAPTURE FAILS - SQL2
038 RC 32 |
| IY15916 | USING QMF V7.1 FOR W
INDOWS TO ACCESS PARTITIONED DATA ON DB2 UDB EEE V7.1 RESULTS IN SQL1013 'DATABASE COULD NOT BE FOUND' |
| IY15931 | HASH_JOIN MEMORY ALL
OCATION PROBLEM WHICH MARKS DB BAD. |
| IY15949 | 'LIST INDOUBT TRANSA
CTIONS' FAILS WITH DB21018E |
| IY15975 | MEMORY LEAK IN AIX A
PPLY |
| IY15976 | INFLATED CARDINALITI
ES ON EEE QUERIES USING NODENUMBER(COLUMN) PREDICATE MAY CAUSE OPTIMIZER TO CHOOSE BAD PLAN IN V6,V7 |
| IY16009 | ERROR IN MIGRATING F
ROM DB2 V5.2 TO DB2 V6.1, SQL0293 CONTAINERS COULT NOT BE FOUND. |
| IY16012 | GETDATE() RETURNS DI
FFERENT VALUES IN APP VS NET |
| IY16056 | USING CID REINSTALL
INTERACTIVE QUESTIONS 'OVERWRITE YES/NO' ARE APPEARED FOR OS/2 |
| IY16081 | DATABASEMETADATA.GET
DRIVERNAME() RETURNS LIBDB2.A INSTEAD OF DB2 |
| IY16113 | JDBC JAVA.LANG.UNSAT
ISFIEDLINKERROR:DB2CONNECTION.SQLFREECONNECT |
| IY16120 | QUERY PATROLLER 9K O
R LARGER MEMORY ERRORS |
| IY16123 | NULLABLE FIELD NOT C
HANGED WHEN PICKING GUI 'GENERATE COL CONTEN |
| IY16159 | VERSIONING NOT SUPPO
RTED 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 ERRO
R WHEN GRANTING PUBLIC ACCESS TO RESULT SET |
| IY16208 | MQBACK ROOLBACK FROM
MQSERIES CAUSES PROBLEMS IN EEE ENVIRONMENT |
| IY16210 | DB2DART /DDEL EXPORT
S INCORRECT DATA ON NULL VALUE. |
| IY16221 | POOR PERFORMANCE ON
QUERY WHEN JOIN NOT PUSHED DOWN THROUGH UNION ALL VIEW |
| IY16224 | WRONG MAPPINGS FOR E
RROR MESSAGE SQL0465N AGAINST OS/390 |
| IY16229 | DB2 UDB AUTOLOADER R
EPORTS INCORRECT VALUES FOR NUMBER OF ROWS LOADED. AUTOLOADER DOES HOWEVER SUCCESSFULLY LOAD ALL ROWS. |
| IY16241 | TCP/IP PACKET SIZE I
S 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 D
B2 CAUSES HP TO TRAP |
| IY16394 | FFFF877E ON CREATE V
IEW '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 INC
ORRECT NODE NUMBERS |
| IY16434 | DB2ADUTL RETURNS INC
ORRECT OUTPUT |
| IY16435 | USING MULTIPLY_ALT F
UNCTION THAT IS INTRODUCED IN DB2 V7.1 FP2 CAUSES SQL0901N |
| IY16457 | SIGNAL 11 IN SQLM_A_
INIT |
| IY16487 | LOAD OF TRUNCATED IX
F CAUSING RECORD LENGTH <CODE><</CODE>0 CAUSES EDU CRASH |
| IY16496 | QUERY FAILED WHEN TH
ERE ARE 2 CONNECTIONS |
| IY16499 | DB2 UDB ON UNIX/OS2/
WINDOWS TRAPS WHEN ACESSED FROM HOST OR AS/4 |
| IY16508 | DB2_CALL_STACK CREAT
E SIGNAL 11 TRAP IN SQLR_DUMP_SECTION. |
| IY16512 | PACKAGE CACHE OVERFL
OW AND SQL0973N. |
| IY16513 | TRAP IN SQLOFMBLKEX,
BUT BAD POINTER IS FROM SQRRCOM_RDS |
| IY16516 | REDIRECTED RESTORE F
AILS WHEN SPECIFYING EXISTING CONTAINERS FFFF F707 INSTANCE CRASHED |
| IY16518 | DATABASE CRASHES AFT
ER INTERRUPTED REORG |
| IY16529 | DB2INIDB PRODUCES A
TRAP (SIGNAL 11) AND A CORE |
| IY16533 | INVALID GENERATED CO
LUMN SETTING CAUSES SET INTEGRITY TO FAIL |
| IY16571 | CAPTURE STOPS PROCES
SING 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 REUSE
D WHEN 999 LIMIT IS REACHED IN SCHEDULER |
| IY16674 | CHANGING CAPTURE COD
E TO PROCESS ALL THE COMMITS IN THE LOCAL NODE, WHICH WILL INCLUDE THE LOG RECORD TYPE OF 'C' |
| IY16678 | SQL1042 - INSTANCE C
RASH / PANIC ON EEE WHEN MAXAPPLS IS HIT - SQL1040 - AND AN INTERRUPT OCCURS AT THE SAME TIME |
| IY16693 | SQLDESCRIBEPARAM NEE
DS TO DESCRIBE 1ST PARAMETER MARKER VS 1ST PARAMETER |
| IY16695 | CHANGE THE CLI DEFAU
LT TO NO COMMIT ON EARLY CLOSE OF CURSOR |
| IY16711 | POOR PERFORMANCE IN
SORTING ON HP DUE TO ALIGNMENT TRAPS |
| IY16721 | BAD FILTER FACTOR ES
TIMATES FOR 'LIKE ?' AND ZERO FF FOR BETWEEN PREDICATES |
| IY16734 | DEBUG CODE TO DUMP I
NFO WHY USEREXIT STOPS ARCHIVING LOGS |
| IY16746 | INDEX STOP/START KEY
LOGIC ALLOWS TOO MANY ROWS |
| IY16750 | TWO-PHASE CONNECT FA
ILED WITH SQL0902C 94 CCI |
| IY16754 | SQL2062N AN ERROR O
CCURRED WHILE ACCESSING MEDIA '/APPS/DIT/NEWYORK/DB2/P1DBINC/SQLLIB/ADSM/LIBADSM.A'.RC:'137 |
| IY16780 | TABLE BEING MARKED F
OR DELETE PENDING BEFORE LOG RECORD IS WRITTEN |
| IY16784 | PRECOMPILE OF PL/I A
PPLICATIONS 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_A
NALYSE_FUNC_OF_COL |
| IY16812 | GETDRIVERNAME() CALL
TO RETURN OUTPUTS TO DISTINGUISH BETWEEN JDBC APP AND NET DRIVERS. |
| IY16814 | SEG FAULT WHEN RUNNI
NG DB2EXPLN |
| IY16822 | THE FLAT FILE WRAPPE
R 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 OCCU
RS 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 BAS
ED 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 D
B2CLI.INI CAUSES CLI0157 TO OCCUR |
| IY16978 | CHANGE APPLY TO INCL
UDE 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 TI
ME FOR QUERIES WITH LARGE NUMBER OF UNION BRANCHES |
| IY17017 | CAN'T RUN DB2GOV WIT
H 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 O
UTPUT FILE <CODE>></CODE> 2GB |
| IY17059 | DB2ATLD USES SORT BU
FFER TO OVERRIDE THE SORTHEAP IN DB CFG. |
| IY17079 | DIA3711C A FILE '' C
OULD 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 SQ
M_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 SQLIFNX
T |
| IY17177 | SIGNAL#11 IN SQLE_CH
ECK_EARLY_FETCH |
| IY17181 | ERRNO:0000 0009 DUMP
ED IN LOG DURING A SUCCESSFULL BACKUP. THIS APPEARED AFTER APPLYING FP6 |
| IY17199 | PRECOMPILER REJECTIN
G THE INDICATOR VARIABLE ATTACHED WITH THE HOST VARIABLE. |
| IY17204 | DB21018E WHEN CALLIN
G SP FROM CLP |
| IY17247 | WHITE SPACE IN THE D
B2CLI.INI FILE |
| IY17255 | RESTORE DB FAILES WI
TH SQL5005 SQLF_MIG_REL8 FFFFEC41 |
| IY17263 | GETS ERROR IN DB2DIA
G.LOG SQL -901 SQLERRMC: SQLNO_CRULE_SAVE_PL ANS ́100•:RC(0) SQLERRP :SQLRFAKE WITH STAR JOIN PLANNING. |
| IY17264 | QUERY PATROLLER CAUS
ING CATALOG CONTENTION PROBLEM |
| IY17287 | DB2 UDB DRDA AS (APP
LICATION SERVER) TRAPS WITH SIGNAL 36 WHEN TRYING TO FREE MEMORY |
| IY17292 | DURING OFFLINE BACKU
PS GET INTERMITTENT SQL1042C UNEXPECTED SYST EM ERROR OCCURRED. |
| IY17299 | A FILE SHARING VIOLA
TION 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 -<CODE>></CODE> 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 LO
CK-WAIT ON CATALOG TABLES USING NOT LOGGED INITIALLY TABLES |
| IY17396 | PROBLEM WITH RRTRIM
FUNCTION. |
| IY17400 | SQLRRBCK() SHOULD NO
T DUMP MESSAGES TO DB2DIAG.LOG |
| IY17425 | DB2CCOR/DB2CCWRK PAI
R DOES NOT TIME OUT WHEN SPAWNED IN THE CONTEXT OF NODES STATUS MONITORING |
| IY17431 | DB2 CRASH WITH SIGNA
L 11 IN SQM_INIT_SQLM_TABLESPACE() |
| IY17441 | IMPROVE QUERY PATROL
LER'S PERFORMANCE FOR QUERIES WITH ORDER BY CLAUSE |
| IY17452 | OUTPUT IS CUT OFF WH
EN JAPANESE(HANKAKU/KANA) IS AT THE HEAD OF THE DATA. |
| IY17461 | ERROR IN SIZE OF RET
URN VALUE FOR INOUT VARCHAR PARAMETERS |
| IY17469 | MANY DEFUNCT DB2 PRO
CESSES WHOSE PARENT IS DB2SYSC PROCESS. |
| IY17472 | LOAD HANGS WITH 'THR
EAD CANNOT CHECK CHECK POINT' ERROR IN DIAG. LOG |
| IY17489 | SIGSEGV IN SQLRA_INV
AL_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 CACH
E. REMOVE 256MB PACKAGE CACHE OVERFLOW LIMIT |
| IY17542 | MEMORY CORRUPTION CA
USED BY DB2 WILL CAUSE APPLICATIONS TO COME DOWN WITH SIG #11, SQLODELETE, SQLOGMBLK, ETC. |
| IY17548 | DB2START HANGS ON 64
BIT SOLARIS AFTER KERNAL PATCH 108528-05 |
| IY17576 | JAVA VISUAL EXPLAIN
NUMERICAL LITERAL ERROR |
| IY17588 | DB2GOVD PROCESS HANG
ING. |
| IY17621 | SQL0510N CAUSED BY N
OT REUSING SECTIONS CORRECTLY IN THE PKG |
| IY17629 | COST MISCALULATION C
AUSING TABLESCAN TO BE CHOSEN VERSUS AN INDEX SCAN |
| IY17633 | CREATE NICKNAME FAIL
S WITH SQL902 ON EEE SERVER. |
| IY17656 | SQL SELECT STATEMENT
S GIVES INCONSISTENT OUTPUT ON MULTIPLE RUNS |
| IY17657 | REORG TABLE &l
t;CODE><</CODE>TB<CODE>></CODE> INDEX <CODE><</CODE>INDEX
<CODE>></CODE> RETURNS SQL2205 WHEN INDEX EXISTS |
| IY17745 | DQPSTART COMMAND HA
NG 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 CO
NTROL CENTER 'ESTIMATE SIZE' WINDOW WHEN USING THE 'RUN STATISTICS...' OPTION |
| IY17784 | ERROR IN CONVERTING
STRING TO DECIMAL |
| IY17816 | THERE ARE PROBLEMS U
SING THE TEXT EXTENDER IN A DCE ENVIRONMENT |
| IY17924 | RESTART/CONNECT/CRAS
H 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 AP
PLY IS NOT EFFICIENT. PERFORMANCE. NO LONGER GENERATES U2000 DUMP ON SQLCODE |
| IY18784 | SQL0723 MESSAGE TOKE
NS INCORRECT |
| IY18785 | LOCALE BEHAVIOUR CHA
NGING ACROSS SOME CLI CALLS |
| IY18786 | STORED PROCEDURE BUI
LDER DOES NOT UPDATE SYSCAT.PROCEDURES |
| IY18787 | DB2 OPTIMIZER DOES N
OT HANDLE 'OPTIMIZE FOR N ROWS' CORRECTLY BY FAVOURING PIPED PLANS. |
| IY18788 | DB2LOOK DOES NOT GEN
ERATE THE DDL FOR THE CREATE USER TABLESPACE CORRECTLY. IT INSTEAD SKIPS THE USER KEYWORD |
| IY18789 | LOSS OF THE TABLE DU
E TO THE IMPORT REPLACE |
| IY18790 | DB2IMIGR FAILS DURIN
G MIGRATION FROM V5.2 TO V7.1. |
| IY18791 | DB2LDAP_BASEDN REGIS
TRY 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 DEF
ERRED PREPARE IS BROKEN IF SET AFTER PREPARE |
| IY18800 | DROP TABLESPACE MAY
FAIL WITH SQL0290N IF THERE IS RI CONSTRAIN |
| IY18801 | DB2 UDB - DATABASE C
RASHES WITH A SIGNAL 11 TRAP IN FUNCTION SQLRX_LIKE WHEN THE SET EVENT MONITOR STATEMENT IS EXECUTED. |
| IY18806 | DB2LOOK -L FAIL TO R
ETURN CONTAINER INFO WHEN RAN AS SYSCTRL ID. |
| IY18807 | POOR PERFORMANCE WHE
RE 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 KEYS
ET CURSOR IF THE KEY IS PART OF THE ORDER BY CLAUSE. |
| JR14532 | DB2SYNC APP SHOWS 10
0% 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 D
OCUMENTATION OF SQL30083 |
| JR14807 | DR. WATSON WHEN ISSU
ING DB2 FORCE APPLICATION ALL AGAINST DRDA-2 CONNECTIONS. |
| JR15016 | CC390 COMPONENT IN U
DB 7.1 DOES NOT PICK UP THE SYSSCHEMA |
| JR15026 | NLX'S AND RCB'S INCO
RRECT IN FORMATTED DUMP, FOR R300 ONLY |
| JR15035 | THE EXPORT TO DATAGU
IDE IS GENERATING A DR. WATSON ERROR. IT ALWAYS PRODUCES THE ERROR REGARDLESS OF OBJECT TYPE |
| JR15146 | UTILITY TO SET THE P
ROPER UID/PWD CREDENTIALS FOR SATELLITEID IN THE SATADMIN.AUT FILE USING ORIGINAL SATELLITEID AS INPUT |
| JR15150 | ADO/DB2-SEMAPHORE LE
AK CAUSES HANDLE COUNT INCREASE. |
| JR15228 | TRAP IN SQLJIDRD WHE
N SQL_DISCONNECT_ABNORMAL RETURNED |
| JR15234 | INSERTING 'DIRTY' TI
MESTAMP INTO DATE COLUMN RESULTS IN NO DATA INSERTED, BUT SQL_SUCCESS_WITH_INFO RETURNED TO APP |
| JR15243 | EXPORT OF PROFILE VI
A CCA FAILING WITH CCA3000 RC 1 |
| JR15255 | CALL TO STORED PROCE
DURE USING IBM OLEDB DRIVER IBMDADB2 GIVES INCORRECT RESULTS |
| JR15262 | STATUS CHANGE TIME I
NCORRECTLY DISPLAYED IN CC |
| JR15268 | DB2ML.CONTENT(DOC, F
ILENAME) 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 GI
VES ERROR MESSAGE INDICATING BLANK PWD |
| JR15290 | ABEND IN DB2SYNCHSAT
TELITE* APIS IF CALLED WITHIN A .DLL |
| JR15308 | SELECT WITH DISTINCT
CLAUSE RETURNS INCORRECT RESULT. DUPLICATE ROWS RETURNED. |
| JR15310 | SQLGETINFO(SQL_EXPRE
SSIONS_IN_ORDERBY) RETURNS 'Y' AGAINST MVS - SHOULD BE 'N' |
| JR15311 | SQLNUMRESULTCOLS CAL
LED PRIOR TO SQLEXECUTE IN PREPAREDSTATEMENT OBJECT. |
| JR15319 | SHOW RELATED FOR IND
EXES NOT WORKING PROPERLY IN CONTROL CENTER |
| JR15320 | SPB IS MAINTAINING C
ONNECTION THAT ARE NO LONGER VALID |
| JR15324 | PROBLEMS WITH REPLIC
ATING A JOIN VIEW IN DATA WAREHOUSE CENTER |
| JR15334 | FILE BROWSER PERFORM
ANCE WHEN ACCESSING SERVER VIA MODEM |
| JR15346 | SQL4914 WHEN USING D
B2CAP 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 HISTOR
Y FAILS FROM COMMAND CENTER OR JOURNAL |
| JR15360 | TRAP IN SQLNO_FF_COM
PUTE_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, BACK
UP 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 EL
IMINATES 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_PASSTH
RU_DESCRIBE WHEN DOING UNSUPPORTED EXPORT IN PASSTHRU MODE. |
| JR15401 | SQL5048 WHEN CREATIN
G 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 <
CODE>></CODE> 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 REDIREC
TED RESTORE IN THE CONTROL CENTER. |
| JR15428 | MEMORY LEAK IN SEQUE
NCE: 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 W
HEN 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 MES
SAGE 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 PROCEDUR
E WITH SPECIFIC NAME <CODE>></CODE>8 CHARACTERS FAILS IN V7 FIXPAK2. |
| JR15505 | NT CONTROL CENTER AL
LOWS 20 CHAR MAX FOR CONTAINER PATH. |
| JR15506 | WHEN SQLDELI=QUOTE O
N THE OS/390 DSNHDECM MACRO, CC390 STILL USES ' INSTEAD OF ' FOR THE DELIMITER. |
| JR15510 | OS/2 AND UPM INSTALL
ATION |
| JR15517 | SQLUVINT() API STRUC
TURE DB2_INFO FIELDS, VERSION RELEASE LEVEL AND OBJ_LIST FIELDS ERRONEOUSLY SET NULL |
| JR15528 | 'BAD' RANGE OF SORTH
EAP SIZE(<CODE>></CODE>1014 AND <CODE><</CODE> 1038) IN THE OPTIMIZER |
| JR15537 | CODEPAGE 65535 PROBL
EM 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 W
ORKS WITH WILDCARD (*.SQLJ) |
| JR15583 | CAN'T CREATE IDENTIT
Y 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 NUL
L 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 NUL
L DATE COLUMN USING OLEDB PROVIDER |
| JR15599 | CALLING SP WITH INOU
T DECIMAL ON AN MVS SYSTEM CAUSES SQL0304 |
| JR15602 | DESCRIBED COLUMN NAM
ES ARE INCORRECT AFTER SWITCHING CURSOR TYPE IN JAVA OR CLI APPLICATION. |
| JR15603 | CCA IS PUTTING THE K
EYWORD 'MULTICONNECT' KEYWORD UNDER THE DSN ENTRY OF THE DB2CLI.INI FILES - SHOULD GO UNDER COMMON SECTION. |
| JR15604 | TRAP IN SQLOREMOVEED
UEXITLIST SEEN ON OS/2 BACKFIT TO V7.1 |
| JR15610 | SQL ROUTINES MAY INC
ORRECTLY 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 INSER
TED TO DATA WHEN CHARACTER IS THE SAME AS TERMINATION CHARACTER DEFINED IN COMMAND CENTER. |
| JR15628 | PASSWORDS ARE LOST/C
ORRUPTED WITHIN DWC |
| JR15631 | DB2 CONNECT SHOULD N
OT ATTEMPT TO CONVERT GRAPHIC COLUMNS FROM DOUBLE-BYTE CODEPAGE TO SINGLE-BYTE CODEPAGE. SHOULD ERROR. |
| JR15635 | DB2 FOR OS/390 CANNO
T MAKE TYPE 2 CONNECTION TO UDB WHEN SPM ENABLED |
| JR15640 | THE CONTROL CENTER F
AILS WITH ERROR SQL0104N WHEN ATTEMPTING TO DISPLAY INDEX NAMES USING THE TURKISH LOCALE |
| JR15643 | EXPORT PROBLEM WITH
IXF FILETYPE |
| JR15646 | NAME COLLISION IN TH
E DB2 DIRECTORY AND DCS DIRECTORY |
| JR15649 | SIG 11 IN SQLOXULT T
HROUGH SQLRA_CACHE_SPACE_MGMT |
| JR15653 | SIGNAL 11 IN SQLOFMB
LKEX DURING LOAD. (<CODE><</CODE>- SQLUTERMLOADEDU <CODE><</CODE>- SQLUTERMRIDDER) |
| JR15654 | 'GET SNAPSHOT FOR AP
PLICATIONS ON <CODE><</CODE>SERVER<CODE>></CODE>' HANGS AT THE SAME PL ACE EVERY TIME THE COMMAND IS ISSUED. | <
/TR>
| JR15656 | SOME STEPS WITH A US
ER DEFINED PROGRAM FAIL TO MIGRATE |
| JR15661 | TRAP IN BSORTGETNEXT
PARTIALKEY ON NT |
| JR15666 | COMMAND CENTER IS NO
T LOGGING THE RESULTS OF A QUERY WITH THE 'PIPE OUTPUT TO FILE' OPTION |
| JR15678 | SQLDESCRIBEPARAM CAL
L 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 DURI
NG SNAPSHOT SCRIPT EXECUTION SQLJNOPREFETCH-OFFSET:110 IN SQLJMS10.C |
| JR15702 | OS/2: SQL1092 IS RET
URNED 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 INVALI
D DATE WHEN USING THE CONTROL CENTER TO SCHEDULE A JOB AND THE REGIONAL SETTING IS SLOVENIA |
| JR15711 | ALTER COLUMN WITH CO
NSTRAINT ADDITIONCLAUSE SHUTS DOWN ENGINE |
| JR15715 | IMPORT FROM CCA FAIL
S TO UPDATE NODES ON WIN2000 |
| JR15719 | SYS3175 OCCURS WHEN
DB2START IS ISSUED BY A USERID THAT DOES NOT HAVE THE PROPER AUTHORITY |
| JR15723 | DXXCOMPOSEXML: ERRCO
DE:-85, ERRMSG:INVALID DOCUMENT STRUCTURE DXXCOMPOSEXML: ERROR CODE: -85, ERROR MSG:INVALID DOCUMENT STRUC |
| JR15726 | V7 CC/NT SAMPLE TABL
E ON V6 SERVER CAUSED MEMORY LEAK ON NT: ADD TIONAL REQUEST CAUSED DR. WATSON ERROR OR RUN OUT OF MEMORY. |
| JR15733 | SORT ROUTINE CALED T
WICE: ONCE DIRECTLY AND ONCE INDIRECTLY SO P PERFORMANCE IS DEGRADED. |
| JR15735 | RETURNING LARGE RESU
LT SET FROM THE V7.1 GUIS (CONTROL CENTER OR COMMAND CENTER) TAKES TOO LONG |
| JR15736 | DB2ADVISE MISREPORTI
NG |
| JR15737 | PATCH2=29 CAUSES PRO
BLEM WITH CONVERSION IN A 0 PRECISION DECIMAL TO DOUBLE CONVERSION. |
| JR15739 | THREAD CRASHES IN 'C
OPY 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 SQLD
ESCRIBE CAUSES THE DATA TO BOUND AS BINARY AND HENCE SHOWING UP AS HEX IN OUTPUT |
| JR15755 | ADO PARAMETIZED QUER
Y SELECTS A LOB AND HAS INPUT PARAMETERS CAUSES DR.WATSON ON DB2 CONNECT. |
| JR15760 | THE RESULT SET BECOM
ES 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/SER
VER SEARCHING WHEN TRYING TO IMPORT/EXPORTA FILE. |
| JR15765 | VISUAL BASIC ADD-IN
FOR SPB FAILS ON NON-ENGLISH VB. |
| JR15766 | OPTIMIZED QUERY RETU
RNS INCORRECT RESULTS |
| JR15790 | PROBLEM WITH USING N
OT DETERMINISTIC OPTION IN UDF |
| JR15796 | INSERTING A NULL VAL
UE 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 HISTOR
Y FAILS FROM COMMAND CENTER OR JOURNAL |
| JR15884 | SNAPSHOT FOR SECONDA
RY LOGS ALLOCATED AND SECONDARY LOG SPACE DO NOT CORRESPOND |
| JR15885 | MTS APPLICATION FAIL
S TO RECONNECT AFTER RECYCLING DB2 |
| PQ46790 | -805 CAUSED BY CURRE
NT PACKAGE SET IS NOT RESET |
| SA91823 | VWPLOADI - DOES NOT
WORK WITH DBCS. |
| APAR fixes included in WR21250 (Fixpak 2a) |
| APAR | ABSTRACT |
| IY16409 | TRAP IN SQLMORERESUL
TS() |
| IY16637 | SQL30090N WHEN DIST
TRAN APP CONNECTS TO A REMOTE DB |
| JR15530 | DATA INSERTED INTO L
ONG VARCHAR USING 'FOR BIT' COLUMN NO LONGER WORKING AT FP 2. |
| APAR fixes included in WR21246 (Fixpak 2) |
| APAR | ABSTRACT |
| GG04123 | CAPTURE CORE DUMPS W
HEN DB2 IS NOT STARTED |
| GG04124 | CAPTURE CORE DUMPS W
HEN DB2 IS NOT STARTED |
| GG04131 | ASN.IBMSNAP_TRACE TA
BLE HOLDS ONLY 251 ROWS |
| GG04132 | ASN.IBMSNAP_TRACE TA
BLE 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 D
URING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS |
| GG04139 | CAPTURE CORE DUMPS D
URING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS |
| GG04144 | DIAGNOSTIC ENHANCEME
NTS FOR APPLY |
| GG04145 | DIAGNOSTIC ENHANCEME
NTS FOR APPLY |
| GG04164 | CAPTURE CORE DUMPS W
HEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. |
| GG04165 | CAPTURE CORE DUMPS W
HEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. |
| GG04166 | CAPTURE SHOULD NOT I
GNORE SYSTEM ERROR (SQLN2038) |
| GG04167 | CAPTURE SHOULD NOT I
GNORE SYSTEM ERROR (SQLN2038) |
| GG04168 | CAPTURE CORE DUMPS I
F COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ |
| GG04169 | CAPTURE CORE DUMPS I
F COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ |
| GG04170 | CANNOT STOP CAPTURE
WITH ASNCMD STOP COMMAND. |
| GG04171 | DURING CAPTURE PROCE
SSING THE ASNPATH SYSTEM VARIABLE IS BEING MISREAD |
| GG04172 | CAPTURE DOES NOT HAN
DLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. |
| GG04173 | CAPTURE DOES NOT HAN
DLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. |
| GG04174 | CAPTURE IS NOT HANDL
ING FOREIGN UPDATES PROPERLY |
| GG04175 | CAPTURE IS NOT HANDL
ING FOREIGN UPDATES PROPERLY |
| IC27213 | WRONG TIMESTAMP ON S
NAPSHOT OUTPUT FOR DB2 EE 6.1 UNDER LINUX |
| IY03296 | SQL2154 ON ATTEMPTED
TABLESPACE RESTORE. |
| IY06938 | IN AN MTS ENVIRONMEN
T ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6 |
| IY09068 | EVENT ANALYSER INFOR
MATION 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 FRO
M OS/390 WHICH CONTAIN LOBS CAUSES SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT. |
| IY09705 | DB2 FORCE APPLICATIO
NS HANGS ON A NON-COORDINATOR NODE |
| IY09961 | QUERY REWRITE DOESN'
T PUSH DOWN PREDICATE INTO COMMON SUBESPRESS ION |
| IY10504 | CALL STATEMENT RESUL
TS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC |
| IY10950 | UNDERSCORES IN TABLE
ALIAS CAUSE MS JET ENGINE ERROR WHEN LINKIN G TABLES. |
| IY11074 | SQL0101 ERROR WHEN R
UNNING 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 ER
ROR IN DB2DIAG.LOG DURING ON-LINE BACKUP. SQLB_BACKUP_IN_PROGRESS ON TEMPTABLESPACE FOR A SHORT PERIOD. |
| IY11353 | SUPPORT SETOBJECT ME
THOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM |
| IY11377 | DB2 UDB - SQL0901 ER
ROR IN FUNCTION SQLNO_RESOLVE_QNC. |
| IY11386 | APAR IY06317 MAY RES
ULT 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 RECO
VERY FAILS WITH AN SQL1042 ERROR. MESSAGES IN THE DB2DIAG.LOG WE FAILED WHEN TRYING TO DROP A BUFFERPOOL. |
| IY11527 | DB2 UDB - SQL0901 ER
ROR WITH MESSAGE 'NON-PIPED PARALLEL SORT ATTEMPTED' IN DB2DIAG.LOG. |
| IY11600 | RESULTSET.GETBINARYS
TREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION. |
| IY11648 | MISLEADING ERROR MES
SAGE IN DB2DIAG.LOG FOR QUIESCE RESET FOR A TABLE FROM A NODE WHERE THE TABLE WAS NOT DEFINED. |
| IY11737 | QUERY PATROLLER (DQP
SETUP) IS RETURNING SQL1005 WITH JA_JP CODEP AGE, BUT DBI1366E WITH EN_US CODEPAGE. |
| IY11766 | ALTER TABLE REFERENC
ES CLAUSE DOES NOT ACCEPT DIFFERENT COLUMN ORDERS IN FOREIGN KEY DEFINITION |
| IY11785 | DB2_ALL WITH ':' OPT
ION ON SUN RETURNS STRANGE MESSAGES |
| IY11795 | SQL1224 INSTANCE CRA
SH ON CLOSE AFTER A FAILED BIND TRAP IS IN SQLRICLS_COMPLEX |
| IY11819 | SQLTABLES() CALL DOE
S 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 DB2A
TLD_PWFILE WHEN AUTHENTICATION IS NOT SET |
| IY11901 | TRAP IN SQLNO_PROJEC
T_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 WHE
REBY 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 MI
NMEMUSAGE=1 FOR JDBC. |
| IY12016 | SQL0901N ON DYNAMIC
SQL 'SQLNO_CRULE_SAVE_PLANS 100:RC(0)' |
| IY12035 | SIGNAL 11 TRAP IN SQ
LRI_RESTORE_SPEC_REG_INFO() |
| IY12042 | CAPTURE CORE DUMPS W
HEN DB2 IS NOT STARTED |
| IY12050 | SQL2741N WHEN LOADIN
G DATA AND SPECIFYING IMPLIEDDECIMAL AND PACKEDDECIMAL MODIFIERS |
| IY12052 | SEVERE PERFORMANCE D
EGRADATION WITH HIGH SYSTEM CPU AND CONTEXT SWITCHES. OCCURS AFTER PREDICTABLE DATABASE UPTIME OF 4-16 DAYS |
| IY12074 | GARBAGE COLLECTION I
N HISTORY FILE AND NUM_DB_BACKUPS |
| IY12125 | OWNER OPTION ON BIND
MAY CAUSE INCORRECT AUTHS TO BE USED |
| IY12165 | CLI LAYER APPENDS EX
TRA SET OF DOUBLE QUOTES TO SCHEMALIST WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N IN FP4E. |
| IY12168 | INSTANCE MIGRATION F
AILS FROM V5.X TO V6.1 |
| IY12177 | INDEX ON GENERATED C
OLUMN NOT TAKEN BY OPTIMIZER DURING INSERT,D ELETE OR UPDATE. |
| IY12271 | DB2CKMIG.BND COULD N
OT BE OPEND AT DB2CKMIG COMMAND |
| IY12273 | LIST DCS APPLICATION
S 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 M
EMORY OPERATIONS (MEMHOLDSEG AND SQLOFMBLK) COMING FROM SQLNO_CLOSE_POOL |
| IY12299 | DB2ADUTL TO RECOGNIZ
E ALL TYPES OF FS_TYPE AT QUERY FOR BACKUP I MAGES |
| IY12396 | POSSTR DOES NOT WORK
WITH GROUP BY (SQL0119) |
| IY12416 | -901 DUE TO INCORREC
TLY SORTED INPUT STREAM OR INCORRECT ORDER BY QUERY RESULTS, MISORDERED KEYS IN INDEX LEAD TO DB MARKED BAD |
| IY12419 | BACKUP OF DATABASE C
ONTAINING DATALINK COLUMNS FAILS WITH SQL2424N, YET COPY DAEMON SUCCESSFULLY BACKED UP FILES. |
| IY12437 | CALLING QUALIFIED ST
ORED PROCEDURES FROM CLP RESULTS IN CLI0150 DRIVER NOT CAPABLE ERROR |
| IY12449 | V7.1 ADD CHECK CONST
RAINT PROBLEM FROM CONTROL CENTER |
| IY12536 | MONITOR STATE DOES N
OT RESET APPLICATION STATE ONCE COMPLETED |
| IY12545 | SQL0104N RETURNED WH
EN RUNNING DB2BATCH IN CLI MODE. HOWEVER, RE SULT SET IS STILL CORRECT. |
| IY12566 | CAPTURE CORE DUMPS W
HEN DB2 IS NOT STARTED |
| IY12567 | CAPTURE CORE DUMPS W
HEN DB2 IS NOT STARTED |
| IY12568 | CAPTURE CORE DUMPS W
HEN DB2 IS NOT STARTED |
| IY12609 | DB2 UDB - SQL1042 ER
ROR 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 (MIGR
ATION OF 32BIT INSTANCE TO 64 BIT) FAILS WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE. |
| IY12725 | DB2 UDB - CREATE IND
EX CAUSING DATABASE TO COME DOWN. THE DB2DIAG.LOG FILE INDICATES THAT AN OBJECT ID IS ALREADY IN USE. |
| IY12726 | DROPPING AN UNAVAILA
BLE TABLE ENDS WITH DIA3806C UNEXPECTED END OF FILE |
| IY12751 | STMT.GETSTRING() RET
URNING 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 WIT
H SYSADMIN GROUP USER THAT IS NOT DB2 INSTANCE OWNER. |
| IY12821 | ASN.IBMSNAP_TRACE TA
BLE HOLDS ONLY 251 ROWS |
| IY12946 | CLI ATTEMPTS TO CLOS
E A CURSOR THORUGH THE CURSOR CONTROL BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP. |
| IY12948 | VISUAL EXPLAIN DISPL
AYS 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 SNAPSHO
TS COUNTERS LIKE 'TOTAL BUFFER POOL READ TIME (MS) ' ARE NOT CORRECT. |
| IY13012 | THE CUSTOMER UPGRADE
D TO FP4D FROM FP4 TO ADDRESS APAR IY09469. NOW THE CUSTOMER IS EXPERIENCING CLI0120E. |
| IY13014 | SIGNAL #4 #11 USING
HOP DRIVER |
| IY13053 | HOST STORED PROCEDUR
E CALL WITH PARAMETERS RESULT IN DB21103W |
| IY13054 | MISLEADING ERROR REP
ORTING ( -901) FOR WRONG SCRIPT TRYING TO LINK UDF. |
| IY13098 | SQL0970N WHEN TRYING
TO DROP AN SQL PROCEDURE |
| IY13107 | DB2 UDB - INDEX CORR
UPTION PROBLEM CAUSES MISORDERING OF KEYS |
| IY13114 | ENCINA SERVER AND DB
2 V7 INTEROPERABILITY. ADDED XA_PREPARE INSIDE ANOTHER TRANSACTION. |
| IY13118 | RUNSTATS ON AN EXTEN
DED INDEX LEADS TO AN INFINITE LOOP |
| IY13171 | DATABASE MIGRATION F
ROM V5 TO V6 FAILS WITH SQL0025W |
| IY13202 | MEMORY OVERWRITE CAU
SES A TRAP IN SQLIPREDNOTSAT DURING LOCK ESCALATION |
| IY13226 | AT QUERYPATROLLER ST
OP TIME, WE TRY TO DELETE A MESSAGE QUEUE TH AT WAS ALREADY DELETED. |
| IY13252 | DB2DCLGN COMMAND WIT
H 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 N
OT TAKE ANY PARAMETER |
| IY13329 | 'O' OPTION IN DLFM R
ETRIEVE DOES NOT WORK |
| IY13330 | NO MESSAGE IS PRINTE
D INTO THE DB2DIAG.LOG FOR DLFMO_LOG |
| IY13331 | AFTER MIGRATION TO A
NEW RELEASE, CAPTURE CANNOT WARM START |
| IY13343 | IMPORT IN CCA ON A C
AE 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 - DESCRIBIN
G 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 DB
2 GET MONITOR SWITCHES AFTER UPDATING THEM FROM A 7.1 CLIENT. |
| IY13617 | CAPTURE CORE DUMPS D
URING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS |
| IY13696 | SQL1273N ON ROLLFORW
ARD DATABASE (MISSING LOG FILE S0000000.LOG) |
| IY13705 | TRAPS (SIG #11) IN S
QLM_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 S
ERVER,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 SQ
LRR_DUMP_SECTION() DURING ERROR PROCESSING |
| IY13832 | MULTIPLE STORED PROC
EDURES WITH SAME SPECIFIC NAME CAUSE VARIOUS CLI/JDBC PROBLEMS |
| IY13841 | APP. CURRENT CONNECT
ION CHANGED WHEN USING XA COMPLIANT TRANSACT -ION MANAGER WITH DB2 |
| IY13891 | QUERY PERFORMANCE DE
GRADATION V6.1 |
| IY13893 | ADD SUPPORT FOR THE
COLUMN NAME UNDER MINMEM MODE FOR JDBC |
| IY13906 | COMMENT IN DB2CLI.IN
I PREVENTS DATASOURCE FROM WORKING PROPERLY IN DB2 V7.1 |
| IY13927 | PROBLEMS MIGRATION O
LD 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 DURIN
G RESIZE/EXTEND OF CONTAINERS V7.1 FP1 |
| IY13968 | BAAN APPLICATION MAY
EXPERIENCE -302 |
| IY13970 | CCA TRUNCATES HOSTNA
ME TO FIRST PART OF FOUR PART NAME |
| IY13979 | -805, -818 SQLCODE R
ECEIVED FROM MULTITHREADED SQLJ APP IN A UNIX ENVIRONMENT. |
| IY13992 | ASNDLCOPY - INCORREC
T MISLEADING MESSAGES WHEN DIR FILE CONTAINS DIRECTORY THAT DOES NOT EXIST |
| IY13995 | SQLFETCH() FAILS WIT
H -501 ERROR WHEN MINMEMUSAGE=1 |
| IY13996 | SYSIBM.SYSVIEWS IS N
OT 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 SER
VER 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 TA
BLE HOLDS ONLY 251 ROWS |
| IY14082 | ASN.IBMSNAP_TRACE TA
BLE 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 TA
BLE 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 D
URING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS |
| IY14123 | CAPTURE CORE DUMPS D
URING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS |
| IY14125 | CAPTURE CORE DUMPS D
URING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS |
| IY14126 | CAPTURE CORE DUMPS D
URING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS |
| IY14155 | DIAGNOSTIC ENHANCEME
NTS FOR APPLY |
| IY14156 | DIAGNOSTIC ENHANCEME
NTS FOR APPLY |
| IY14158 | DIAGNOSTIC ENHANCEME
NTS FOR APPLY |
| IY14159 | DIAGNOSITC ENHANCEME
NTS FOR APPLY |
| IY14242 | CLI API SQLCOLUMNS F
AILS WITH SQL0198N ERROR WHEN ISSUED AGAINST A NEW DATABASE BEFORE BINDING THE CLI BIND FILES. |
| IY14253 | MISSING PAGE IO DURI
NG DB ROLLFORWARD (CORRUPTED LOGS) |
| IY14307 | INDEX CORRUPTION, CO
NTINUATION 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 CREATE
D DURING REORG |
| IY14396 | DRDA DUMP PRODUCED W
HEN USING SPUFI ON OS/390 TO ACCESS A FEDERA TED VIEW OF A NICKNAME IN UDB V.7.1 |
| IY14406 | CAPTURE CORE DUMPS W
HEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. |
| IY14407 | CAPTURE CORE DUMPS W
HEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. |
| IY14408 | CAPTURE CORE DUMPS W
HEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S. |
| IY14409 | CAPTURE CORE DUMPS W
HEN LONG VARCHAR ROWS UPDATE WITH NO CHANGES. |
| IY14410 | CAPTURE SHOULD NOT I
GNORE SYSTEM ERROR (SQLN2038) |
| IY14411 | CAPTURE SHOULD NOT I
GNORE SYSTEM ERROR (SQLN2038) |
| IY14412 | CAPTURE SHOULD NOT I
GNORE SYSTEM ERROR (SQLN2038) |
| IY14413 | CAPTURE SHOULD NOT I
GNORE SYSTEM ERROR (SQLN2038) |
| IY14414 | CAPTURE CORE DUMPS I
F COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ |
| IY14415 | CAPTURE CORE DUMPS I
F COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ |
| IY14416 | CAPTURE CORE DUMPS I
F COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ |
| IY14417 | CAPTURE CORE DUMPS I
F COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ |
| IY14418 | CAPTURE DOES NOT HAN
DLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. |
| IY14419 | CAPTURE DOES NOT HAN
DLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. |
| IY14420 | CAPTURE DOES NOT HAN
DLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS. |
| IY14421 | CAPTURE DOES NOT HAN
DLE LARGE TABLE ID |
| IY14422 | CAPTURE IS NOT HANDL
ING FOREIGN UPDATES PROPERLY |
| IY14423 | CAPTURE IS NOT HANDL
ING FOREIGN UPDATES PROPERLY |
| IY14424 | CAPTURE IS NOT HANDL
ING FOREIGN UPDATES PROPERLY |
| IY14425 | CAPTURE IS NOT HANDL
ING FOREIGN UPDATES PROPERLY |
| IY14500 | DLFM GOES DOWN FROM
LOCK TMEOUT WITHIN GARBAGE COLLECTOR DAEMON |
| IY14639 | BACK LEVEL CLIENT CR
ASHES (SIG#11) IN SQLRR_OPEN |
| IY14648 | TRAP IN CLI WITH EAR
LYCLOSE, 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 C00
00005 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: DB2MEMDISC
LAIM IS NOT INTERPRETED CORRECTLY ON VERSION 7. IF SET TO ANYTHING, IT IS OFF, IF NOT SET, IT IS ON. |
| IY14769 | SOLARIS: DEADLATCH A
T V7.1 FP1 CAUSES HANG |
| IY14770 | SIGNAL 11 IN SQLVDIV
IDE |
| IY14775 | CREATE TABLE LOOPS A
ND USES ALL OF THE LOG SPACE |
| IY14777 | PREPAREDSTATEMENT.SE
TLONG() CALL FAILS TO DB2/390 |
| IY14849 | SQL0901N SYSTEM ERRO
R WITH REASON: UNRESOLVED QNC |
| IY14894 | TURNING ON THE SPECI
AL FEATURE USE_LIGHT_OUTPUT_SQLDA CAUSES THE CLIENT TO HANG. |
| IY14901 | SQLFREECONNECT/SQLFR
EEHANDLE RELEASES THE CONNECTION LATCH |
| IY14979 | QUERY PATROLLER LIMI
TATION: 18 CHARACTERS FOR COLUMN NAME LENGTH |
| IY14989 | INSTANCE CRASH ON RO
LLFORWARD: SIGNAL 11 IN SQLPRFWD__FP7SQLEACB8SQLP_LSNUL |
| IY15036 | GLOBAL TEMP TABLE CA
USING A TRAP WITH SIG 11 |
| IY15049 | INSERT HANGS IN SQLP
GPST |
| IY15118 | DB2 UTILITIES FAIL W
HEN 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: DB2MEMDISC
LAIM CAN CAUSE SORTHEAP ALLOCATION ERRORS, TRAPS, DEFUNCT DB2AGENTS DUE TO LEAKING VIRTUAL MEMORY. |
| IY15289 | WRONG OR DIFFERENT R
ESULTS RETURNED BY SELECT ON VIEWS V7.1 ONLY |
| IY15369 | QUERY RUN AT OPT LEV
EL 0 RETURNED WRONG RESULTS. |
| IY15397 | CREATE PROCEDURE CAL
L FROM NON-CATALOGUED NODE TRAPS. |
| IY15469 | BAD OPTIMIZER PLAN L
EADS TO INCORRECT RESULTS IN EEE FOR AST |
| IY15629 | INCORRECT FILE SIZE
ESTIMATES FOR BACKUP TO ADSM/TSM |
| JR14166 | NODE DIRECTORY MIGRA
TION FAILS FROM V5 TO V6.1 |
| JR14504 | SQLFREESTMT TRAP DEL
ETING CCB AFTER XA_END CALL |
| JR14645 | SQLSPECIALCOLUMNS FA
ILS WITH SQL0303N INSTEAD OF RETURNING NAME OF COLUMN DEFINED FOR THE PRIMARY KEY WHEN USING MS QUREY |
| JR14647 | JAVA CC DOES NOT ALL
OW NUM_POOLAGENTS TO BE SET TO 0. |
| JR14743 | DB2 TRAPS WHEN THERE
IS NOT ENOUGH MEMORY ON THE SYSTEM. |
| JR14749 | SQL0291 TRYING TO AC
CESS TEMPORARY TABLESPACE WHEN THERE ARE TEMP TABLEPSACES OF DIFFERENT PAGESIZES:'NO TEMP AVAILABLE' |
| JR14758 | WITH SPECIFIC SETTIN
GS 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 DO
ESN'T REDUCE THE RESULTSET FROM DB2/390 IF SQLEXTENDEDFETCH() IS USED TO RETRIEVE RESULTS. |
| JR14791 | SQLEXTENDEDFETCH - F
ETCH 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 BLO
B COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER. |
| JR14815 | DB2JDBC.DLL TRAPS WH
EN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED. |
| JR14841 | AN SQL0525N ERROR OC
CURS WHEN DB2BATCH IS EXECUTED AGAINST AN OS 390 DATABASE. |
| JR14844 | USERS WHICH BELONG T
O THE SYSADM_GROUP DEFINED IN THE DBM CFG CA NNOT ISSUE A DB2STOP, WHETHER DOMAIN OR LOCAL USERS |
| JR14846 | CONTROL CENTER GENER
ATES INVALID WHEN DEFINING REPLICATION SOURCES AND SUBSCRIPTIONS IF ASN.IBMSNAP_CCPPARMS IS EMPTY |
| JR14854 | NT: CONNECT HANGS RE
SULTING 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 PR
OCEDURES WON'T PRECOMPILE. NEED TO PUT A VERSION CHECKING FOR CALL STATEMENTS. |
| JR14876 | 08/00 duplicate obje
ct error occurs while importing to DWC |
| JR14892 | CHANGE WIN32 API CAL
L DUE TO LONG CONNECT DELAYS WHEN THERE ARE DISCONNECTED MAPPED NETWORK DRIVES: NT TERMINAL SERVER ONLY. |
| JR14894 | SQL0900 DATABASE CRA
SHES 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 IN
DEXES WITH DUPLICATE NAMES WHEN DEFINING MUL TIPLE TABLES AS REPLICATION SOURCE |
| JR14921 | INSERT INTO REAL COL
UMN ON DB2/390 DATABASE FAILS |
| JR14924 | INCORRECT CALL TO HO
ST TO RETRIEVE CURRENT TIMEZONE. |
| JR14926 | TRAP IN SQLJIFSR.C |
| JR14928 | SQL1092 ON DROP DB O
N CLIENT DESPITE CATALOG_NOAUTH |
| JR14929 | TABLE UDFS WITH DECI
MAL PARAMETERS SHOW LENGTH AND SCALE OF 0 IN SYSCAT.FUNCPARMS |
| JR14931 | EVENT ANALYZER (CONT
ROL CENTER) IS TOO SLOW LOADING AND SORTING EVENT FILES |
| JR14932 | -502 AFTER USING SQL
_CLOSEOPEN CLI ATTRIBUTE |
| JR14933 | Support ETI DA versi
on (4.x) |
| JR14990 | OUTPUT PARAMETERS NO
T INITIALIZED TO NULL |
| JR14996 | CONNECTION ATTEMPT T
O DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E |
| JR15008 | SQLCONNECT FAILS WIT
H 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 SHOUL
D REMOVE FALSE PREDICATES (EG. 1=0) FOR THE OPTIMIZER. |
| JR15042 | CODEPAGE V5.2 IN BAC
KUP IMAGE USES CODEPAGE 850 INSTEAD OF CODES ET. V6&7 WILL NOT READ THIS |
| JR15046 | RETURN UNRETREIVED E
RROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC |
| JR15073 | EXCEPTION 5 TRAP DUR
ING STAR JOIN PLANNING |
| JR15081 | CLI COMMIT BETWEEN P
REPARE AND DESCRIBE MAY CAUSE CLI0125E FUNCTION SEQUENCE ERROR |
| JR15082 | CUS ATTEMPTS LARGE L
OAD 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 CUSTOME
R 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 W
INDOW CAN'T BE CLOSED WITH 'CANCEL' BUTTON. |
| JR15145 | APAR fix - import er
rors 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 ST
ATEMENT RETURNS SQL0415 WITH SQLSTATE 42825. AND/OR INCORRECT RESULTS DURING SQL EXECUTION. |
| JR15200 | USE OF {?=CALL SPNAM
E(?)} SYNTAX MAY RESULT IN CLI0102 INVALID CONVERSION ERRORS |
| JR15202 | RESTORE/MIGRATION (S
QL2517W) CONTROL CENTER -<CODE>></CODE> JOURNAL STATUS IS 'FAILED' |
| JR15206 | KEYSET PARSER RETURN
CODE=1002 CAUSES HEAP CONSUMPTION |
| JR15212 | CONNECTION.GETCATALO
G() RETURNS AN EMPTY STRING INSTEAD OF NULL |
| JR15213 | SQLMORERESULTS() DOE
S NOT HANDLE ERRORS FROM BATCHED COMMANDS |
| JR15214 | EXECUTEBATCH() SHOUL
D RETURN INT́0• 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 TRA
PS WHEN HDBC=0 |
| JR15220 | SQLPUTDATA() MAY RES
ULT IN SQL0157N UNDER HIGH CONCURRENCY |
| JR15238 | INCONSISTENT RESYNC
(OS/390 ABORTS, UDB COMMITS) |
| JR15239 | SETMAXFIELDSIZE(), S
ETMAXROWS(), SETQUERYTIMEOUT() SHOULD RETURN SQLEXCEPTION WHEN INPUT VALUE IS INVALID - JDBC |
| JR15250 | GETUDTS (JDBC) SHOUL
D 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 (S
TARTING WITH --) IN THE COMMAND CENTER - INTERACTIVE PANEL ARE NOT HANDLED CORRECTLY |
| JR15287 | NT/7.1FP1 - WR21198
: 'CPYSETUP.BAT...' -<CODE>></CODE> 'THE SYSTEM CANNOT FIND THE FILE SPECIFIED.' -<CODE>></CODE> COPY NOT USABLE -&
gt; CANNOT UPGRADE |
| JR15318 | TRAP DURING COMPARE
DATE STRING AND AN EMPTY VARCHAR STRING |
| JR15330 | SQL 107 RECEIVED WHE
N CALLING STORED PROCEDURES ON A HOST SYSTEM THROUGH A V7.1 GATEWAY |
| JR15425 | LOAD WITH MODIFIED B
Y USEDEFAULTS CLAUSE CAUSES NULL FIELDS TO BE INCORRECTLY POPULATED WITH DATA. |
| APAR fixes included in WR21198f (Fixpak 1f) |
| APAR | ABSTRACT |
| IY12165 | CLI LAYER APPENDS EX
TRA 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: DIA9999
E 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 WR21198e (Fixpak 1e) |
| APAR | ABSTRACT |
| IY12177 | INDEX ON GENERATED C
OLUMN 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 E
RROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC |
| JR15081 | CLI COMMIT BETWEEN P
REPARE AND DESCRIBE MAY CAUSE CLI0125E FUNCTION SEQUENCE ERROR |
| APAR fixes included in WR21198d (Fixpak 1d) |
| APAR | ABSTRACT |
| IY11353 | SUPPORT SETOBJECT ME
THOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM |
| IY12968 | JDBC 2.0 PREVIOUS()
METHOD RETURNS TRUE ON FIRST ROW |
| IY13226 | AT QUERYPATROLLER ST
OP TIME, WE TRY TO DELETE A MESSAGE QUEUE TH AT WAS ALREADY DELETED. |
| JR14815 | DB2JDBC.DLL TRAPS WH
EN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED. |
| JR14929 | TABLE UDFS WITH DECI
MAL PARAMETERS SHOW LENGTH AND SCALE OF 0 IN SYSCAT.FUNCPARMS |
| JR15008 | SQLCONNECT FAILS WIT
H MEMORY CORRUPTION ERROR |
| APAR fixes included in WR21198c (Fixpak 1c) |
| APAR | ABSTRACT |
| IY10504 | CALL STATEMENT RESUL
TS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC |
| IY12751 | STMT.GETSTRING() RET
URNING NULL ON IN_OUT PARAMETER |
| IY12946 | CLI ATTEMPTS TO CLOS
E A CURSOR THORUGH THE CURSOR CONTROL BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP. |
| IY13118 | RUNSTATS ON AN EXTEN
DED INDEX LEADS TO AN INFINITE LOOP |
| JR14166 | NODE DIRECTORY MIGRA
TION FAILS FROM V5 TO V6.1 |
| JR14809 | NEED SUPPORT FOR BLO
B COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER. |
| JR14996 | CONNECTION ATTEMPT T
O DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E |
| APAR fixes included in WR21198b (Fixpak 1b) |
| APAR | ABSTRACT |
| IY06938 | IN AN MTS ENVIRONMEN
T ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6 |
| IY10504 | CALL STATEMENT RESUL
TS 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 APPLICATION
S SHOW CONNECTIONS THAT HAD BEEN CANCELLED |
| IY12679 | DB2IUPDT -W 64 (MIGR
ATION OF 32BIT INSTANCE TO 64 BIT) FAILS WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE. |
| JR14867 | MF AND IBM STORED PR
OCEDURES 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 COL
UMN ON DB2/390 DATABASE FAILS |
| JR14924 | INCORRECT CALL TO HO
ST TO RETRIEVE CURRENT TIMEZONE. |
| JR14926 | TRAP IN SQLJIFSR.C |
| APAR fixes included in WR21198a (Fixpak 1a) |
| APAR | ABSTRACT |
| IY11353 | SUPPORT SETOBJECT ME
THOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM |
| IY11377 | DB2 UDB - SQL0901 ER
ROR IN FUNCTION SQLNO_RESOLVE_QNC. |
| IY11600 | RESULTSET.GETBINARYS
TREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION. |
| IY11819 | SQLTABLES() CALL DOE
S NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER. |
| IY11990 | ADDED SUPPORT FOR MI
NMEMUSAGE=1 FOR JDBC. |
| IY12416 | -901 DUE TO INCORREC
TLY 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 WH
EN 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 ERR
OR OCCURS WHILE IMPORTING TO DWC |
| APAR fixes included in WR21198 (Fixpak 1) |
| APAR | ABSTRACT |
| IY06572 | SEGMENTATION FAULT W
HEN BINDING A SECOND TIME TO A CURSOR |
| IY06740 | DB SIZE ESTIMATE CAL
CULATED INCORRECTLY FOR BACKUP TO ADSM. HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE. |
| IY07623 | SIGNAL #11 TRAP IN S
QLORQUE2() |
| IY08453 | SQL1227 RC 6 WHEN AT
TEMPTING 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 E
MPTY FILE (IXF) DOES NOT REPLACE EXISTING ROWS IN THE TABLE THE EMPTY FILE IS BEING LOADED INTO. |
| IY09262 | CHANGE THE DEFAULT S
QL_CONCURRENCY AS READ_ONLY BASED ON THE CLAUSES PRESENT IN THE STATEMENT. |
| IY09663 | DB2 CRASHED WITH ERR
OR DIA3816C CREATED BY SQM_EVMON_OSTREAM() SIG 11 |
| IY09756 | NOT POSSIBLE TO REDI
RECTED RESTORE STRIPED CONTAINERS. REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED. |
| IY09764 | TWO QUERIES DIFFERIN
G ONLY IN THE ORDER OF THE PREDICATES, RETURN DIFFERENT RESULTS. |
| IY09948 | JAVA STORED PROCEDUR
ES NOT FOUND OUTSIDE SQLLIB\FUNCTION |
| IY09966 | JAVA.SQL.TIMESTAMP R
ECEIVING INVALID ARGUMENT(NANOS<CODE>></CODE>999999999 OR <CODE><</CODE>0) WHEN MULTIPLE THREADS MAKES THE CALL. |
| IY10004 | DB2JD TERIMINATES WI
TH EXCEPTION, WHEN USING HISTORY OPTION OF CONTROL CENTER FROM WINDOWS 95. |
| IY10029 | QUALIFIER BIND OPTIO
N 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 APPLICA
TION CORE DUMPS WITH GREATER THAN 60 SQL STATEMENTS. |
| IY10183 | TRAP/SIGNAL 11 - SQL
PLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4. |
| IY10199 | LEFT OR FULL OUTER J
OIN PROBLEM WITH OPTIMIZER |
| IY10280 | RANDOM CLI0606E/CLI0
611E 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 SES
SION BEFRO RE-ESTABLISHING IT. |
| IY10430 | BACKUP IMAGE NOT FOU
ND ERROR RESTORING TBSP FROM FULL DB BACKUP (LEGATO SPECIFIC) |
| IY10432 | JDBC APPLICATION TRA
PPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY |
| IY10469 | CORRUPTION IN RECOVE
RY HISTORY FILE ON DROP TABLE RECOVERY ITEM |
| IY10475 | IWM_TRACKER PRODUCES
SQL0305N WHEN TRACKING A SUMMARY TABLE |
| IY10484 | LEAK IN DRDA HEAP WH
EN CALLING STORED PROCEDURES RESULTS IN SQL0973. |
| IY10491 | SQLPROCEDURES YIELDS
INCORRECT QUERY TO MVS V6.1 |
| IY10499 | OPTLEVEL 5 PLAN WORS
E THAN OPTLEVEL 3 PLAN |
| IY10504 | CALL STATEMENT RESUL
TS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC |
| IY10562 | DB2 UDB INTRA_PARALL
EL 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 SQL043
7W IN CLI APPLICATION. RETRY LOGIC FAULT. |
| IY10615 | SQL10003 ERROR RETUR
NED 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 ca
used by TQS - dirty partial_tuple_saved flg |
| IY10765 | APPLICATION HANG IN
FCM ON VERY FAST MACHINE |
| IY10794 | JDBC APPLICATION TRA
PPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY |
| IY10803 | LOG RECORDS BELONGIN
G TO TABLESPACES NOT IN ROLLFORWARD TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N. |
| IY10816 | CLI0111E ON INSERT O
F DECIMAL 0.00=<CODE><</CODE>X=<0.99 IN SQLJ STORED PROC |
| IY10861 | DATABASEMETADATA.GET
COLUMNS 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 SCH
EMA 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 T
HE FILE_TRANSFER_CMDFAILS WITH A NON-ZERO R ETURN CODE. |
| IY11141 | DB2JD TERMINATES IF
IT CAN'T SPAWN ANY PROCESSES. |
| IY11217 | SQJ0001W WITH SQL010
4N WHEN ISSUING DB2PROFC ON SQLJ APPLICATION |
| IY11218 | INTERMITTENT CLI0125
E IN SQLJ STORED PROCEDURES |
| IY11255 | DB2LOOK -U OPTION RE
TURNS TABLES WITH GIVEN CREATORID AS SCHEMA INSTEAD OF TABLES THAT WERE CREATED BY THAT CREATORID |
| IY11275 | MULTISITE UPDATE HAN
GS WITH CC |
| IY11283 | ISSUING DB2IUPDT OVE
RWRITES THE DB2AUDIT.CFG WITH THE DEFAULT CONFIGURATION. |
| IY11343 | BAD PERFORMANCE WHEN
A LOB IS PASSED INTO A UDF |
| IY11375 | USEREXIT IS NOT BEIN
G INVOKED EVEN THOUGH IT HAS BEEN SET UP PROPERLY. |
| IY11377 | DB2 UDB - SQL0901 ER
ROR IN FUNCTION SQLNO_RESOLVE_QNC. |
| IY11443 | RECONCILE RETURNS SQ
L2554N RC=5. |
| IY11466 | DEADLOCK CAUSED BY N
EXT KEY LOCKING IN CATALOGS |
| IY11620 | DB2 UDB - PERFORMANC
E 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 RET
URNING CLI0150E, DRIVER NOT CAPABLE. |
| JR14415 | TRAP - MTS AND STORE
D 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 <CODE>></CODE> 50 CHARS IN SQLAJBND_BIND. |
| JR14517 | SQL1092 WHEN CREATIN
G 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 <CODE>></CODE> 4682 CHAR DISPLAY PROBLEM |
| JR14576 | JDBC NET DRIVER RETU
RNS 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 NO
T STARTED SUCCESSFULLY RC 3 |
| JR14606 | EXPORT OF DEL MODIFI
ED BY DECPT SUBSTITUTES PERIOD FOR ANY CHARACTER FOR ITALIAN VERSION DB2 ON NT |
| JR14625 | NT PERFORMANCE MONIT
OR NOT PROVIDING DETAILS FOR THE SECOND AND FOLLOWING APPLICATIONS |
| JR14646 | ADDING XBSA SUPPORT
TO DB2 NT FOR SAP |
| JR14648 | DBA3037 ON VISUAL EX
PLAIN 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 INCORR
ECTLY 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 WHE
N 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. |