Product Name:DB2 UDB V7.1 for AIX 64-bit
PTF Number:U475366
Package Date:Mon Apr 9 16:25:50 EDT 2001
Build Level:s010326
APAR fixes included in U475366 (client build)
APARABSTRACT
IY15122SUPPORT FOR SQL_ARD_TYPE DATA TYPE.
IY15798DB2DATASOURCE NOT HANDLING CONNECTIONS PROPERLY
IY16081DATABASEMETADATA.GETDRIVERNAME() RETURNS LIBDB2.A INSTEAD OF DB2
IY16159VERSIONING NOT SUPPORTED IN DB2DATASOURCE CODE
IY16278CLI_SDAINITSQLDAPARM MSG TOO LARGE, CAUSING HP TO TRAP.
IY16383MISALIGNED DATA IN DB2 CAUSES HP TO TRAP
IY16695CHANGE THE CLI DEFAULT TO NO COMMIT ON EARLY CLOSE OF CURSOR
IY16812GETDRIVERNAME() CALL TO RETURN OUTPUTS TO DISTINGUISH BETWEEN JDBC APP AND NET DRIVERS.
IY16879SQL4903N SAYING THAT LENGHT OF 'RUNTIME_PID' PARAMETER OF FUNCTION 'SQLASTRT_TRUSTED' IS NOT VALID
IY16962TEMPDIR KEYWORD IN DB2CLI.INI CAUSES CLI0157 TO OCCUR
IY17247WHITE SPACE IN THE DB2CLI.INI FILE
IY17516SQL0311 WHEN CALLING SP FROM JAVA WITH CLOB PARAMETER
IY17621SQL0510N CAUSED BY NOT REUSING SECTIONS CORRECTLY IN THE PKG
JR15346SQL4914 WHEN USING DB2CAP WITH CAPTURE FILE WHICH CONTAINS FILTER CONDITION
JR15352SQLPRIMARYKEYS COULD RETURN NO KEYS IF SCHEMA IS NOT SPECIFIED AND USER LOGS IN WITH LOWERCASE USERID.
JR15549SQLJ.EXE NO LONGER WORKS WITH WILDCARD (*.SQLJ)
JR15599CALLING SP WITH INOUT DECIMAL ON AN MVS SYSTEM CAUSES SQL0304
JR15602DESCRIBED COLUMN NAMES ARE INCORRECT AFTER SWITCHING CURSOR TYPE IN JAVA OR CLI APPLICATION.
JR15678SQLDESCRIBEPARAM CALL TO HOST RETURNING SQL0236
APAR fixes included in U474809 (Fixpak 2a)
APARABSTRACT
IY16409TRAP IN SQLMORERESULTS()
IY16637SQL30090N WHEN DIST TRAN APP CONNECTS TO A REMOTE DB
JR15530DATA INSERTED INTO LONG VARCHAR USING 'FOR BIT' COLUMN NO LONGER WORKING AT FP 2.
APAR fixes included in U475004 (Fixpak 2)
APARABSTRACT
GG04123CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
GG04124CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
GG04131ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
GG04132ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
GG04133AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
GG04134AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
GG04138CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
GG04139CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
GG04144DIAGNOSTIC ENHANCEMENTS FOR APPLY
GG04145DIAGNOSTIC ENHANCEMENTS FOR APPLY
GG04164CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
GG04165CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
GG04166CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
GG04167CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
GG04168CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
GG04169CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
GG04170CANNOT STOP CAPTURE WITH ASNCMD STOP COMMAND.
GG04171DURING CAPTURE PROCESSING THE ASNPATH SYSTEM VARIABLE IS BEING MISREAD
GG04172CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
GG04173CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
GG04174CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
GG04175CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IC27213WRONG TIMESTAMP ON SNAPSHOT OUTPUT FOR DB2 EE 6.1 UNDER LINUX
IY03296SQL2154 ON ATTEMPTED TABLESPACE RESTORE.
IY06938IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6
IY09068EVENT ANALYSER INFORMATION FROM AIX WILL NOT DISPLAY ON NT
IY09174MIGRATION FAILS DUE TO DISK FULL
IY09385SQL1042 DURING CRASH RECOVERY DUE TO INDEX MANAGER PROGRAMMING ERROR (DIA3875C).
IY09469SELECTING TABLES FROM OS/390 WHICH CONTAIN LOBS CAUSES SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT.
IY09705DB2 FORCE APPLICATIONS HANGS ON A NON-COORDINATOR NODE
IY09961QUERY REWRITE DOESN'T PUSH DOWN PREDICATE INTO COMMON SUBESPRESS ION
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY10950UNDERSCORES IN TABLE ALIAS CAUSE MS JET ENGINE ERROR WHEN LINKIN G TABLES.
IY11074SQL0101 ERROR WHEN RUNNING A QUERY DUE TO MEMORY FRAGMENTATION PROBLEM AND LOW 'ULIMIT -D' VALUE.
IY11081DATABASE GETS MARKED AS BAD AFTER FCM ERRORS FFFFFC7F IN DB2DIAG.LOG FILE. EVENT MONITOR RESOURCE COULD NOT BE OBTAINED.
IY11136NO TEMP AVAILABLE ERROR IN DB2DIAG.LOG DURING ON-LINE BACKUP. SQLB_BACKUP_IN_PROGRESS ON TEMPTABLESPACE FOR A SHORT PERIOD.
IY11353SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM
IY11377DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11386APAR IY06317 MAY RESULT IN POOR COST ESTIMATE OF MERGE JOIN
IY11436DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY PROCESSING.
IY11499DB2 UDB - CRASH RECOVERY FAILS WITH AN SQL1042 ERROR. MESSAGES IN THE DB2DIAG.LOG WE FAILED WHEN TRYING TO DROP A BUFFERPOOL.
IY11527DB2 UDB - SQL0901 ERROR WITH MESSAGE 'NON-PIPED PARALLEL SORT ATTEMPTED' IN DB2DIAG.LOG.
IY11600RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION.
IY11648MISLEADING ERROR MESSAGE IN DB2DIAG.LOG FOR QUIESCE RESET FOR A TABLE FROM A NODE WHERE THE TABLE WAS NOT DEFINED.
IY11737QUERY PATROLLER (DQPSETUP) IS RETURNING SQL1005 WITH JA_JP CODEP AGE, BUT DBI1366E WITH EN_US CODEPAGE.
IY11766ALTER TABLE REFERENCES CLAUSE DOES NOT ACCEPT DIFFERENT COLUMN ORDERS IN FOREIGN KEY DEFINITION
IY11785DB2_ALL WITH ':' OPTION ON SUN RETURNS STRANGE MESSAGES
IY11795SQL1224 INSTANCE CRASH ON CLOSE AFTER A FAILED BIND TRAP IS IN SQLRICLS_COMPLEX
IY11819SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER.
IY11865SQL0902N ON STARTING PIPE EVENT MONITOR
IY11882AUTOLOADER USES DB2ATLD_PWFILE WHEN AUTHENTICATION IS NOT SET
IY11901TRAP IN SQLNO_PROJECT_QUN WHEN RUNNING A QUERY
IY11908DB2 calls user exit with the wrong gid
IY11932QUERY PATROLLER DOES NOT WORK PROPERLY WHEN LANGUAGE WAS SELECTE D LANG=US_ENG.
IY11940INDEX CORRUPTION WHEREBY DART ANALYSIS REPORTS 'DUPLICATE FOUND' OR 'INDEX KEYS MISORDERED' OR 'BPS HEADER PAGE NUMBER INCORRECT'
IY11945APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE ALLOCATED TO PROCESS.
IY11990ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC.
IY12016SQL0901N ON DYNAMIC SQL 'SQLNO_CRULE_SAVE_PLANS 100:RC(0)'
IY12035SIGNAL 11 TRAP IN SQLRI_RESTORE_SPEC_REG_INFO()
IY12042CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12050SQL2741N WHEN LOADING DATA AND SPECIFYING IMPLIEDDECIMAL AND PACKEDDECIMAL MODIFIERS
IY12052SEVERE PERFORMANCE DEGRADATION WITH HIGH SYSTEM CPU AND CONTEXT SWITCHES. OCCURS AFTER PREDICTABLE DATABASE UPTIME OF 4-16 DAYS
IY12074GARBAGE COLLECTION IN HISTORY FILE AND NUM_DB_BACKUPS
IY12125OWNER OPTION ON BIND MAY CAUSE INCORRECT AUTHS TO BE USED
IY12165CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N IN FP4E.
IY12168INSTANCE MIGRATION FAILS FROM V5.X TO V6.1
IY12177INDEX ON GENERATED COLUMN NOT TAKEN BY OPTIMIZER DURING INSERT,D ELETE OR UPDATE.
IY12271DB2CKMIG.BND COULD NOT BE OPEND AT DB2CKMIG COMMAND
IY12273LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN CANCELLED
IY12275CLI CONVERSION FROM CHARACTER TO NUMERIC TYPES MAY CAUSE SIGSEGV IF INVALID CHARS USED
IY12295SIGNAL 11 TRAPS IN MEMORY OPERATIONS (MEMHOLDSEG AND SQLOFMBLK) COMING FROM SQLNO_CLOSE_POOL
IY12299DB2ADUTL TO RECOGNIZE ALL TYPES OF FS_TYPE AT QUERY FOR BACKUP I MAGES
IY12396POSSTR DOES NOT WORK WITH GROUP BY (SQL0119)
IY12416-901 DUE TO INCORRECTLY SORTED INPUT STREAM OR INCORRECT ORDER BY QUERY RESULTS, MISORDERED KEYS IN INDEX LEAD TO DB MARKED BAD
IY12419BACKUP OF DATABASE CONTAINING DATALINK COLUMNS FAILS WITH SQL2424N, YET COPY DAEMON SUCCESSFULLY BACKED UP FILES.
IY12437CALLING QUALIFIED STORED PROCEDURES FROM CLP RESULTS IN CLI0150 DRIVER NOT CAPABLE ERROR
IY12449V7.1 ADD CHECK CONSTRAINT PROBLEM FROM CONTROL CENTER
IY12536MONITOR STATE DOES NOT RESET APPLICATION STATE ONCE COMPLETED
IY12545SQL0104N RETURNED WHEN RUNNING DB2BATCH IN CLI MODE. HOWEVER, RE SULT SET IS STILL CORRECT.
IY12566CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12567CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12568CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12609DB2 UDB - SQL1042 ERROR WHEN MAXAGENTS LIMIT HAS BEEN REACHED AND DB2 REQUIRES AN ADDITIONAL AGENT.
IY12642LOAD DOES NOT CHECK PARTITIONING KEY FOR EXCEPTION TABLE
IY12679DB2IUPDT -W 64 (MIGRATION OF 32BIT INSTANCE TO 64 BIT) FAILS WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE.
IY12725DB2 UDB - CREATE INDEX CAUSING DATABASE TO COME DOWN. THE DB2DIAG.LOG FILE INDICATES THAT AN OBJECT ID IS ALREADY IN USE.
IY12726DROPPING AN UNAVAILABLE TABLE ENDS WITH DIA3806C UNEXPECTED END OF FILE
IY12751STMT.GETSTRING() RETURNING NULL ON IN_OUT PARAMETER
IY12777WHEN MIGRATING FROM V5 TO V7, THE FIRST 2,3,4 KEYCARDS VALUES OF THE INDEX FROM THE ACCESS PLAN IS NOT REFLECTED IN SYSCAT.INDEX
IY12800CAN'T RUN DB2GOV WITH SYSADMIN GROUP USER THAT IS NOT DB2 INSTANCE OWNER.
IY12821ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY12946CLI ATTEMPTS TO CLOSE A CURSOR THORUGH THE CURSOR CONTROL BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP.
IY12948VISUAL EXPLAIN DISPLAYS INCORRECT '(DEFAULT)' KEYWORD UNDER THE EXPLAINED COLUMN IN THE TABLE STATISTICS WINDOW.
IY12968JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW
IY13010WHILE TAKING SNAPSHOTS COUNTERS LIKE 'TOTAL BUFFER POOL READ TIME (MS) ' ARE NOT CORRECT.
IY13012THE CUSTOMER UPGRADED TO FP4D FROM FP4 TO ADDRESS APAR IY09469. NOW THE CUSTOMER IS EXPERIENCING CLI0120E.
IY13014SIGNAL #4 #11 USING HOP DRIVER
IY13053HOST STORED PROCEDURE CALL WITH PARAMETERS RESULT IN DB21103W
IY13054MISLEADING ERROR REPORTING ( -901) FOR WRONG SCRIPT TRYING TO LINK UDF.
IY13098SQL0970N WHEN TRYING TO DROP AN SQL PROCEDURE
IY13107DB2 UDB - INDEX CORRUPTION PROBLEM CAUSES MISORDERING OF KEYS
IY13114ENCINA SERVER AND DB2 V7 INTEROPERABILITY. ADDED XA_PREPARE INSIDE ANOTHER TRANSACTION.
IY13118RUNSTATS ON AN EXTENDED INDEX LEADS TO AN INFINITE LOOP
IY13171DATABASE MIGRATION FROM V5 TO V6 FAILS WITH SQL0025W
IY13202MEMORY OVERWRITE CAUSES A TRAP IN SQLIPREDNOTSAT DURING LOCK ESCALATION
IY13226AT QUERYPATROLLER STOP TIME, WE TRY TO DELETE A MESSAGE QUEUE TH AT WAS ALREADY DELETED.
IY13252DB2DCLGN COMMAND WITH A DECIMAL RESULT IN INCORRECT OUTPUT.
IY13307SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON UDB V.7.1
IY13312QUERY OPTIMIZATION. BAD NESTED LOOP JOIN PLAN IS CHOSEN AFTER MIGRATING TO V7. IO IS SIGNIFICANTLY UNDER-COSTED.
IY13327DLFM RETRIEVE DOES NOT TAKE ANY PARAMETER
IY13329'O' OPTION IN DLFM RETRIEVE DOES NOT WORK
IY13330NO MESSAGE IS PRINTED INTO THE DB2DIAG.LOG FOR DLFMO_LOG
IY13331AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY13343IMPORT IN CCA ON A CAE IS CATALOGING DIRECTLY TO A MAINFRAME INSTEAD OF THROUGH A GATEWAY.
IY13410IMPROPER HANDLING OF LOGS WITH RAW DEVICE AS ACTIVE LOG PATH. GET SQL4970N WHEN ISSUING A ROLL FORWARD.
IY13466SQL0198N - DESCRIBING STORED PROCEDURES WITH LONG NAMES
IY13473BAD ACCESS PLAN CAN OCCUR IN EEE WITH DISTRIBUTION STATS
IY13596IN V7.1 CC, ON-LINE BACKUP OPTION FOR EEE IS GREYED OUT.
IY13598SQL1627W WHEN RUN DB2 GET MONITOR SWITCHES AFTER UPDATING THEM FROM A 7.1 CLIENT.
IY13617CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
IY13696SQL1273N ON ROLLFORWARD DATABASE (MISSING LOG FILE S0000000.LOG)
IY13705TRAPS (SIG #11) IN SQLM_GENERIC_CONVERT
IY13707NEW PATCH2=41 IN CLI TO HELP USERS DO CASE INSENSITIVE QUERIES: VIEWS HAS TO BE CREATED ON A TABLE TO UPPER CASE EVERYTHING, THE
IY13738FROM CLIENT TO AIX SERVER,JOB IS SCHEDULED THORUGH SCRIPT CENTER WITH CORRECT USERID,NO MATTER WHAT PASSWORD,JOB EXECUTES SUCESSF
IY13749SQL2038 RC=32 DURING CAPTURE ACTIVITY.
IY13774LOAD FAILURE (BUILD PHASE) MIGHT CAUSE SMP CORRUPTION
IY13799PACKAGE CACHE ENTRY FOR SELECT DOES NOT INDICATE THAT DEFAULT QUALIFIER (SCHEMA) HAS BEEN CHANGED
IY13802CONTROL CENTER DOES NOT ALLOW DEFINING A REPLICATION SUBSCRIPTION ON A VIEW REPLICATION SOURCE.
IY13807DLFMUPDT FAILED WITH DBI1282. BACKUP_INSTINFO() IN DB2IUTIL DOES N'T CONSIDER TO BACKUP DBM CFG FOR DLFMUPDT COMMAND.
IY13808SIGNAL 11 TRAP IN SQLRR_DUMP_SECTION() DURING ERROR PROCESSING
IY13832MULTIPLE STORED PROCEDURES WITH SAME SPECIFIC NAME CAUSE VARIOUS CLI/JDBC PROBLEMS
IY13841APP. CURRENT CONNECTION CHANGED WHEN USING XA COMPLIANT TRANSACT -ION MANAGER WITH DB2
IY13891QUERY PERFORMANCE DEGRADATION V6.1
IY13893ADD SUPPORT FOR THE COLUMN NAME UNDER MINMEM MODE FOR JDBC
IY13906COMMENT IN DB2CLI.INI PREVENTS DATASOURCE FROM WORKING PROPERLY IN DB2 V7.1
IY13927PROBLEMS MIGRATION OLD PL1 APPLICATIONS TO UDB V7.1 HAVING TO DO WITH THE CONNECTION INTERFACES
IY13951MINMEMUSAGE KEYWORD CAUSES INCORRECT SQL_DBMS_NAME OUTPUT IN SQLGETINFO()
IY13959SQL0270N RC=40 DURING RESIZE/EXTEND OF CONTAINERS V7.1 FP1
IY13968BAAN APPLICATION MAY EXPERIENCE -302
IY13970CCA TRUNCATES HOSTNAME TO FIRST PART OF FOUR PART NAME
IY13979-805, -818 SQLCODE RECEIVED FROM MULTITHREADED SQLJ APP IN A UNIX ENVIRONMENT.
IY13992ASNDLCOPY - INCORRECT MISLEADING MESSAGES WHEN DIR FILE CONTAINS DIRECTORY THAT DOES NOT EXIST
IY13995SQLFETCH() FAILS WITH -501 ERROR WHEN MINMEMUSAGE=1
IY13996SYSIBM.SYSVIEWS IS NOT MIGRATED PROPERLY FROM DB2 V5.2 TO DB2 V7 1 WHEN THERE ARE VIEWS THAT HAD MORE THEN 1 SEQNO IN THE TABLE.
IY14035FEDERATED CREATE SERVER COMMAND TRAPS EEE INSTANCES
IY14038DB2 UDB - IN CERTAIN SCENARIOS IF AN AGENT FAILS WITH ANSQL1040 (MAXAPPLS REACHED) ERROR, THE DATABASE WILL CRASH WITH SQL1042.
IY14081ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14082ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14089DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
IY14090DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
IY14091DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
IY14094DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
IY14095ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14096AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY14097AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY14098AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY14121CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
IY14123CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
IY14125CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
IY14126CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS
IY14155DIAGNOSTIC ENHANCEMENTS FOR APPLY
IY14156DIAGNOSTIC ENHANCEMENTS FOR APPLY
IY14158DIAGNOSTIC ENHANCEMENTS FOR APPLY
IY14159DIAGNOSITC ENHANCEMENTS FOR APPLY
IY14242CLI API SQLCOLUMNS FAILS WITH SQL0198N ERROR WHEN ISSUED AGAINST A NEW DATABASE BEFORE BINDING THE CLI BIND FILES.
IY14253MISSING PAGE IO DURING DB ROLLFORWARD (CORRUPTED LOGS)
IY14307INDEX CORRUPTION, CONTINUATION OF IY11940
IY14312KEY NOT FOUND ERROR FFFFF92C DURING DELETE OR DB2DART REPORTS KEYS OUT OF ORDER ON AN INSPECTION.
IY14314SQL1224 DB2 INSTANCE CRASH. THIS OCCURS BECAUSE OF MEMORY CORRUPTION AFTER A COMMUNICATIONS ERROR - TRAP IN MEMTREEPUT
IY14353DB2 GIVES INCORRECT ANSWERS, TERMINATE DB CONNECTION FROM CLP OR HANG WHEN QUERIES ARE RUN FROM COMMAND CENTER.
IY14370DUPLICATE KEY CREATED DURING REORG
IY14396DRDA DUMP PRODUCED WHEN USING SPUFI ON OS/390 TO ACCESS A FEDERA TED VIEW OF A NICKNAME IN UDB V.7.1
IY14406CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
IY14407CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
IY14408CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
IY14409CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATE WITH NO CHANGES.
IY14410CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14411CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14412CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14413CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY14414CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY14415CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY14416CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY14417CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY14418CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY14419CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY14420CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY14421CAPTURE DOES NOT HANDLE LARGE TABLE ID
IY14422CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14423CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14424CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14425CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY14500DLFM GOES DOWN FROM LOCK TMEOUT WITHIN GARBAGE COLLECTOR DAEMON
IY14639BACK LEVEL CLIENT CRASHES (SIG#11) IN SQLRR_OPEN
IY14648TRAP IN CLI WITH EARLYCLOSE, AUTOCOMMIT, AND BLOCK_FOR_NROWS SET
IY14702UPDATE ISSUE DEALING WITH STAR JOINS AND CODE GEN BUFFER REUSE VS. OVERWRITE. THE UPDATE SUCCESSFUL BUT DOES NOT UPDATE.
IY14713TRAP - EXCEPTION C0000005 IN DB2SYSCS.EXE EXECUTING SQL TRAP IS IN SQLNO_COST_MGJN DUE TO INVALID POINTER
IY14741SET INTEGRITY USING EXCEPTION TABLE FAILS WITH SQL0901 WHEN THE EXCEPTION TABLE HAS THE OPTIONAL COLUMN OF CLOB(32K)
IY14752AIX ONLY: DB2MEMDISCLAIM IS NOT INTERPRETED CORRECTLY ON VERSION 7. IF SET TO ANYTHING, IT IS OFF, IF NOT SET, IT IS ON.
IY14769SOLARIS: DEADLATCH AT V7.1 FP1 CAUSES HANG
IY14770SIGNAL 11 IN SQLVDIVIDE
IY14775CREATE TABLE LOOPS AND USES ALL OF THE LOG SPACE
IY14777PREPAREDSTATEMENT.SETLONG() CALL FAILS TO DB2/390
IY14849SQL0901N SYSTEM ERROR WITH REASON: UNRESOLVED QNC
IY14894TURNING ON THE SPECIAL FEATURE USE_LIGHT_OUTPUT_SQLDA CAUSES THE CLIENT TO HANG.
IY14901SQLFREECONNECT/SQLFREEHANDLE RELEASES THE CONNECTION LATCH
IY14979QUERY PATROLLER LIMITATION: 18 CHARACTERS FOR COLUMN NAME LENGTH
IY14989INSTANCE CRASH ON ROLLFORWARD: SIGNAL 11 IN SQLPRFWD__FP7SQLEACB8SQLP_LSNUL
IY15036GLOBAL TEMP TABLE CAUSING A TRAP WITH SIG 11
IY15049INSERT HANGS IN SQLPGPST
IY15118DB2 UTILITIES FAIL WHEN DYN_QUERY_MGMT IS TURNED ON
IY15135KEY NOT FOUND ERROR (FFFF F92C) ON AN INDEX IN A 32K PAGE TBSP
IY15192ADD FUNCTIONALITY TO OBTAIN A MINIMUM SCALE OF 6 FOR DIVISION.
IY15250AIX ONLY: DB2MEMDISCLAIM CAN CAUSE SORTHEAP ALLOCATION ERRORS, TRAPS, DEFUNCT DB2AGENTS DUE TO LEAKING VIRTUAL MEMORY.
IY15289WRONG OR DIFFERENT RESULTS RETURNED BY SELECT ON VIEWS V7.1 ONLY
IY15369QUERY RUN AT OPT LEVEL 0 RETURNED WRONG RESULTS.
IY15397CREATE PROCEDURE CALL FROM NON-CATALOGUED NODE TRAPS.
IY15469BAD OPTIMIZER PLAN LEADS TO INCORRECT RESULTS IN EEE FOR AST
IY15629INCORRECT FILE SIZE ESTIMATES FOR BACKUP TO ADSM/TSM
JR14166NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1
JR14504SQLFREESTMT TRAP DELETING CCB AFTER XA_END CALL
JR14645SQLSPECIALCOLUMNS FAILS WITH SQL0303N INSTEAD OF RETURNING NAME OF COLUMN DEFINED FOR THE PRIMARY KEY WHEN USING MS QUREY
JR14647JAVA CC DOES NOT ALLOW NUM_POOLAGENTS TO BE SET TO 0.
JR14743DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM.
JR14749SQL0291 TRYING TO ACCESS TEMPORARY TABLESPACE WHEN THERE ARE TEMP TABLEPSACES OF DIFFERENT PAGESIZES:'NO TEMP AVAILABLE'
JR14758WITH SPECIFIC SETTINGS EVERY COMMAND ISSUED FROM COMMAND CENTER ON NT/UDB EE V5.2/FIXPACK 12 RECEIVES DB21005E ERROR.
JR14777QUERY TRAPS SERVER. TRAPPING FUNCTION IS SQLKT_PACK_TUPLE.
JR14781SQL_ATTR_MAX_ROWS DOESN'T REDUCE THE RESULTSET FROM DB2/390 IF SQLEXTENDEDFETCH() IS USED TO RETRIEVE RESULTS.
JR14791SQLEXTENDEDFETCH - FETCH PRIOR - FAILS TO RETRIEVE ROW IN 1 ROW RESULT SET FOR A STATIC SCROLLABLE READ-ONLY SERVER-SIDE CURSOR.
JR14795DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442
JR14809NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER.
JR14815DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED.
JR14841AN SQL0525N ERROR OCCURS WHEN DB2BATCH IS EXECUTED AGAINST AN OS 390 DATABASE.
JR14844USERS WHICH BELONG TO THE SYSADM_GROUP DEFINED IN THE DBM CFG CA NNOT ISSUE A DB2STOP, WHETHER DOMAIN OR LOCAL USERS
JR14846CONTROL CENTER GENERATES INVALID WHEN DEFINING REPLICATION SOURCES AND SUBSCRIPTIONS IF ASN.IBMSNAP_CCPPARMS IS EMPTY
JR14854NT: CONNECT HANGS RESULTING FROM LATCH ON GLOBAL INSTANCE QUEUE
JR14860JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN
JR14867MF AND IBM STORED PROCEDURES WON'T PRECOMPILE. NEED TO PUT A VERSION CHECKING FOR CALL STATEMENTS.
JR1487608/00 duplicate object error occurs while importing to DWC
JR14892CHANGE WIN32 API CALL DUE TO LONG CONNECT DELAYS WHEN THERE ARE DISCONNECTED MAPPED NETWORK DRIVES: NT TERMINAL SERVER ONLY.
JR14894SQL0900 DATABASE CRASHES ON QUERY WITH RID SCANS AND LIST PREFETCHING IF BINSORT ENABLED
JR14895INCORRECT DISPLAY OF DECIMAL SEPARATOR: DISPLAYS ',' INSTEAD OF '.' IN CC FOR BOTH V6.1 AND V7.1
JR14897JDBC TIMING HOLE MAY ALLOW GARBAGE COLLECTOR TO CLOSE OBJECTS WE HOLD REFERENCE TO
JR14905DB2 CC - CREATING INDEXES WITH DUPLICATE NAMES WHEN DEFINING MUL TIPLE TABLES AS REPLICATION SOURCE
JR14921INSERT INTO REAL COLUMN ON DB2/390 DATABASE FAILS
JR14924INCORRECT CALL TO HOST TO RETRIEVE CURRENT TIMEZONE.
JR14926TRAP IN SQLJIFSR.C
JR14928SQL1092 ON DROP DB ON CLIENT DESPITE CATALOG_NOAUTH
JR14929TABLE UDFS WITH DECIMAL PARAMETERS SHOW LENGTH AND SCALE OF 0 IN SYSCAT.FUNCPARMS
JR14931EVENT ANALYZER (CONTROL CENTER) IS TOO SLOW LOADING AND SORTING EVENT FILES
JR14932-502 AFTER USING SQL_CLOSEOPEN CLI ATTRIBUTE
JR14933Support ETI DA version (4.x)
JR14990OUTPUT PARAMETERS NOT INITIALIZED TO NULL
JR14996CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E
JR15008SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR
JR15025DR.WATSON IN DB2SYS.DLL WHEN LOGING OFF NT (MTS AND DTC)
JR15036COMMAND CENTRE LOGON DIALOG FAILS TO GO ON THE TOP
JR15040QUERY RE-WRITE SHOULD REMOVE FALSE PREDICATES (EG. 1=0) FOR THE OPTIMIZER.
JR15042CODEPAGE V5.2 IN BACKUP IMAGE USES CODEPAGE 850 INSTEAD OF CODES ET. V6&7 WILL NOT READ THIS
JR15046RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC
JR15073EXCEPTION 5 TRAP DURING STAR JOIN PLANNING
JR15081CLI COMMIT BETWEEN PREPARE AND DESCRIBE MAY CAUSE CLI0125E FUNCTION SEQUENCE ERROR
JR15082CUS ATTEMPTS LARGE LOAD AND FAILS WHEN INDEX REBUILD.
JR15084SIGNAL #11 IN SQLNQ_MEMMGR::DESTROY. THIS APAR WILL FORCE A -901 TRACEBACK TO GATHER MORE INFO ON NEXT OCCURRANCE.
JR15085WHENEVER THE CUSTOMER GOES TO GET THE SOURCE STORED PROCEDURE CODE IN THE STORED PROCEDURE BUILDER HE GETS SQL0514.
JR15138DR.WATSON IN DB2CLI.DLL WITH JDBC APP CALLING STORED PROCEDURES
JR15141V7.1 CC'S RUNSTATS WINDOW CAN'T BE CLOSED WITH 'CANCEL' BUTTON.
JR15145APAR fix - import errors 3303 and 3807 on validate_relationshi
JR15158DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE
JR15159EXCEPT ALL IN SQL STATEMENT RETURNS SQL0415 WITH SQLSTATE 42825. AND/OR INCORRECT RESULTS DURING SQL EXECUTION.
JR15200USE OF {?=CALL SPNAME(?)} SYNTAX MAY RESULT IN CLI0102 INVALID CONVERSION ERRORS
JR15202RESTORE/MIGRATION (SQL2517W) CONTROL CENTER -<CODE>></CODE> JOURNAL STATUS IS 'FAILED'
JR15206KEYSET PARSER RETURN CODE=1002 CAUSES HEAP CONSUMPTION
JR15212CONNECTION.GETCATALOG() RETURNS AN EMPTY STRING INSTEAD OF NULL
JR15213SQLMORERESULTS() DOES NOT HANDLE ERRORS FROM BATCHED COMMANDS
JR15214EXECUTEBATCH() SHOULD RETURN INTě0• IF BATCH IS EMPTY
JR15215BATCHUPDATEEXCEPTION SHOULD BE THROWN IN EXECUTEBATCH, NOT ADDBATCH IF THERE IS AN ERROR IN THE BATCH STATEMENT
JR15216JAVA APPLICATION TRAPS WHEN HDBC=0
JR15220SQLPUTDATA() MAY RESULT IN SQL0157N UNDER HIGH CONCURRENCY
JR15238INCONSISTENT RESYNC (OS/390 ABORTS, UDB COMMITS)
JR15239SETMAXFIELDSIZE(), SETMAXROWS(), SETQUERYTIMEOUT() SHOULD RETURN SQLEXCEPTION WHEN INPUT VALUE IS INVALID - JDBC
JR15250GETUDTS (JDBC) SHOULD RETURN AN EMPTY RESULTSET IF NOT SUPPORTED
JR15251STATEMENT RESULTSET SHOULD BE SET TO NULL AFTER REUSE
JR15256THIN CLIENT INSTALL DOES NOT UPGRADE THE V.1.X WINSOCK TO V.2.0 ON WINDOWS 95
JR15263SQL COMMENT LINES (STARTING WITH --) IN THE COMMAND CENTER - INTERACTIVE PANEL ARE NOT HANDLED CORRECTLY
JR15287NT/7.1FP1 - WR21198 : 'CPYSETUP.BAT...' -<CODE>></CODE> 'THE SYSTEM CANNOT FIND THE FILE SPECIFIED.' -<CODE>></CODE> COPY NOT USABLE -> CANNOT UPGRADE
JR15318TRAP DURING COMPARE DATE STRING AND AN EMPTY VARCHAR STRING
JR15330SQL 107 RECEIVED WHEN CALLING STORED PROCEDURES ON A HOST SYSTEM THROUGH A V7.1 GATEWAY
JR15425LOAD WITH MODIFIED BY USEDEFAULTS CLAUSE CAUSES NULL FIELDS TO BE INCORRECTLY POPULATED WITH DATA.
APAR fixes included in 472895f (Fixpak 1f)
APARABSTRACT
IY12165CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N IN FP4E.
IY13307SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON UDB V.7.1
IY13312QUERY OPTIMIZATION. BAD NESTED LOOP JOIN PLAN IS CHOSEN AFTER MIGRATING TO V7. IO IS SIGNIFICANTLY UNDER-COSTED.
IY13565DB2DIAG.LOG: DIA9999E ERROR CODE 2, SQLRA_LOAD_DYN_STMT - CAN OCCUR ON SNAPSHOT BUT IS INFORMATIONAL ONLY - NO EFFECT TO USER
IY13707NEW PATCH2=41 IN CLI TO HELP USERS DO CASE INSENSITIVE QUERIES: VIEWS HAS TO BE CREATED ON A TABLE TO UPPER CASE EVERYTHING, THE
JR15158DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE
APAR fixes included in 472895e (Fixpak 1e)
APARABSTRACT
IY12177INDEX ON GENERATED COLUMN NOT TAKEN BY OPTIMIZER DURING INSERT,D ELETE OR UPDATE.
IY13098SQL0970N WHEN TRYING TO DROP AN SQL PROCEDURE
IY13307SQL1185 WHEN BINDING FROM OS/390 TO A FEDERATED DATABASE ON UDB V.7.1
JR14795DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442
JR15046RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC
JR15081CLI COMMIT BETWEEN PREPARE AND DESCRIBE MAY CAUSE CLI0125E FUNCTION SEQUENCE ERROR
APAR fixes included in 472895d (Fixpak 1d)
APARABSTRACT
IY11353SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM
IY12968JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW
IY13226AT QUERYPATROLLER STOP TIME, WE TRY TO DELETE A MESSAGE QUEUE TH AT WAS ALREADY DELETED.
JR14815DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED.
JR14929TABLE UDFS WITH DECIMAL PARAMETERS SHOW LENGTH AND SCALE OF 0 IN SYSCAT.FUNCPARMS
JR15008SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR
APAR fixes included in 472895c (Fixpak 1c)
APARABSTRACT
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY12751STMT.GETSTRING() RETURNING NULL ON IN_OUT PARAMETER
IY12946CLI ATTEMPTS TO CLOSE A CURSOR THORUGH THE CURSOR CONTROL BLOCK THAT HAS ALREADY BEEN CLOSED, CAUSING A TRAP.
IY13118RUNSTATS ON AN EXTENDED INDEX LEADS TO AN INFINITE LOOP
JR14166NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1
JR14809NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER.
JR14996CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E
APAR fixes included in 472895b (Fixpak 1b)
APARABSTRACT
IY06938IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY11436DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY PROCESSING.
IY11908USER EXITS RUN WITH WRONG RGID ON UNIX.
IY11945APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE ALLOCATED TO PROCESS.
IY12273LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN CANCELLED
IY12679DB2IUPDT -W 64 (MIGRATION OF 32BIT INSTANCE TO 64 BIT) FAILS WIT H SQL1707N UNABLE TO MIGRATE THE INSTANCE WORD SIZE.
JR14867MF AND IBM STORED PROCEDURES WON'T PRECOMPILE. NEED TO PUT A VERSION CHECKING FOR CALL STATEMENTS.
JR14897JDBC TIMING HOLE MAY ALLOW GARBAGE COLLECTOR TO CLOSE OBJECTS WE HOLD REFERENCE TO
JR14921INSERT INTO REAL COLUMN ON DB2/390 DATABASE FAILS
JR14924INCORRECT CALL TO HOST TO RETRIEVE CURRENT TIMEZONE.
JR14926TRAP IN SQLJIFSR.C
APAR fixes included in 472895a (Fixpak 1a)
APARABSTRACT
IY11353SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM
IY11377DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11600RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION.
IY11819SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER.
IY11990ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC.
IY12416-901 DUE TO INCORRECTLY SORTED INPUT STREAM OR INCORRECT ORDER BY QUERY RESULTS, MISORDERED KEYS IN INDEX LEAD TO DB MARKED BAD
JR14743DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM.
JR14815DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED.
JR14860JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN
JR14876DUPLICATE OBJECT ERROR OCCURS WHILE IMPORTING TO DWC
APAR fixes included in U472895 (Fixpak 1)
APARABSTRACT
IY06572SEGMENTATION FAULT WHEN BINDING A SECOND TIME TO A CURSOR
IY06740DB SIZE ESTIMATE CALCULATED INCORRECTLY FOR BACKUP TO ADSM. HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE.
IY07623SIGNAL #11 TRAP IN SQLORQUE2()
IY08453SQL1227 RC 6 WHEN ATTEMPTING TO UPDATE STATISTICS WITH TABLE CARDINALITY OF 0 WHEN STATISTICS ALREADY EXIST
IY08684SQL0107 RETURNED BY CLI DRIVER ON SQLFETCH CALL TO DB2 MVS.
IY09151LOAD REPLACE OF AN EMPTY FILE (IXF) DOES NOT REPLACE EXISTING ROWS IN THE TABLE THE EMPTY FILE IS BEING LOADED INTO.
IY09262CHANGE THE DEFAULT SQL_CONCURRENCY AS READ_ONLY BASED ON THE CLAUSES PRESENT IN THE STATEMENT.
IY09663DB2 CRASHED WITH ERROR DIA3816C CREATED BY SQM_EVMON_OSTREAM() SIG 11
IY09756NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS. REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED.
IY09764TWO QUERIES DIFFERING ONLY IN THE ORDER OF THE PREDICATES, RETURN DIFFERENT RESULTS.
IY09948JAVA STORED PROCEDURES NOT FOUND OUTSIDE SQLLIB\FUNCTION
IY09966JAVA.SQL.TIMESTAMP RECEIVING INVALID ARGUMENT(NANOS<CODE>></CODE>999999999 OR <CODE><</CODE>0) WHEN MULTIPLE THREADS MAKES THE CALL.
IY10004DB2JD TERIMINATES WITH EXCEPTION, WHEN USING HISTORY OPTION OF CONTROL CENTER FROM WINDOWS 95.
IY10029QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204
IY10034May13: Install V6.1 FP/EEE/NT may add incorrect EE DB2 Services
IY10047DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI
IY10180COMPOUND SQL APPLICATION CORE DUMPS WITH GREATER THAN 60 SQL STATEMENTS.
IY10183TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4.
IY10199LEFT OR FULL OUTER JOIN PROBLEM WITH OPTIMIZER
IY10280RANDOM CLI0606E/CLI0611E ERRORS FROM A MULTI-THREADED JDBC APP WHEN ALL THE THREADS USE A SINGLE CONNECTION.
IY10302PCBVALUE INCORRECTLY POPULATED ON SQLGETDATA FOR WCHAR WITH CBMAXVALUE=2 ON UNIX.
IY10390TERMINATING ADSM SESSION BEFRO RE-ESTABLISHING IT.
IY10430BACKUP IMAGE NOT FOUND ERROR RESTORING TBSP FROM FULL DB BACKUP (LEGATO SPECIFIC)
IY10432JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY
IY10469CORRUPTION IN RECOVERY HISTORY FILE ON DROP TABLE RECOVERY ITEM
IY10475IWM_TRACKER PRODUCES SQL0305N WHEN TRACKING A SUMMARY TABLE
IY10484LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973.
IY10491SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1
IY10499OPTLEVEL 5 PLAN WORSE THAN OPTLEVEL 3 PLAN
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY10562DB2 UDB INTRA_PARALLEL ON - QUERY RETURNS AN SQL0955 ERROR AFTER WHICH ALL QUERIES WHICH REQUIRE SHARED SORT MEMORY FAIL.
IY10579DB2 UDB - SIGNAL 11 TRAP IN FUNCTION SQLDHASHZVALUE WHEN RUNNING REORGCHK ON VARIOUS TABLES.
IY10585SQL0501 AFTER SQL0437W IN CLI APPLICATION. RETRY LOGIC FAULT.
IY10615SQL10003 ERROR RETURNED TO USER APPLICATIONS, AND LOGGED IN THE DB2DIAG.LOG FILE. MEMORY LEAK IN BSU HEAP
IY10625SNAPSHOT FOR TABLES, IF MORE THAN 1 TABLE HAS A NULL NAME, DB2 TRAPS.
IY10668Memory corruption caused by TQS - dirty partial_tuple_saved flg
IY10765APPLICATION HANG IN FCM ON VERY FAST MACHINE
IY10794JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY
IY10803LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N.
IY10816CLI0111E ON INSERT OF DECIMAL 0.00=<CODE><</CODE>X=<0.99 IN SQLJ STORED PROC
IY10861DATABASEMETADATA.GETCOLUMNS IS NOT HANDLING SCHEMAPATTERN='' CORRECTLY.
IY10901IMPORT FROM PIPE ASC BREAKS AT END OF BUFFER. ALTHOUGH IMPORT COMPLETES SUCCESSFULLY, ALL DATA IS NOT IMPORTED.
IY10902CREATE VIEW WITH SCHEMA NAME TOO LONG GIVES SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR.
IY11030SQL30083 RC 24 WHEN TRYING TO CHANGE A PASSWORD LOCALLY FROM THE DB2 CLP USING A VALID PASSWORD
IY11063AN APPLICATION HANGS (AN AGENT STUCK IN MONITOR CODE)
IY11097NULL BUFFER FROM FCM PASSED TO SQLKQ_DETACH_BUFFER LEADING TO HANG ON SMP OR MPP MACHINES.
IY11116DB2ATLD HANGS WHEN THE FILE_TRANSFER_CMDFAILS WITH A NON-ZERO R ETURN CODE.
IY11141DB2JD TERMINATES IF IT CAN'T SPAWN ANY PROCESSES.
IY11217SQJ0001W WITH SQL0104N WHEN ISSUING DB2PROFC ON SQLJ APPLICATION
IY11218INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES
IY11255DB2LOOK -U OPTION RETURNS TABLES WITH GIVEN CREATORID AS SCHEMA INSTEAD OF TABLES THAT WERE CREATED BY THAT CREATORID
IY11275MULTISITE UPDATE HANGS WITH CC
IY11283ISSUING DB2IUPDT OVERWRITES THE DB2AUDIT.CFG WITH THE DEFAULT CONFIGURATION.
IY11343BAD PERFORMANCE WHEN A LOB IS PASSED INTO A UDF
IY11375USEREXIT IS NOT BEING INVOKED EVEN THOUGH IT HAS BEEN SET UP PROPERLY.
IY11377DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11443RECONCILE RETURNS SQL2554N RC=5.
IY11466DEADLOCK CAUSED BY NEXT KEY LOCKING IN CATALOGS
IY11620DB2 UDB - PERFORMANCE DEGRADATION DUE TO OPTIMIZER INCORRECTLY ESTIMATING THE CARDINALITY OF AN INDEX SCAN
JR13044MS INTERDEV RECEIVES CLI0002W AFTER FETCH FROM SQLPROCEDURECOLUM NS()
JR14068PCOMM ALLOWS '#' IN THE PARTNER LU NAME BUT DOES NOT ALLOW '#' I N THE SYM_DEST_NAME.
JR14349SQLDESCRIBEPARAM RETURNING CLI0150E, DRIVER NOT CAPABLE.
JR14415TRAP - MTS AND STORED PROCEDURES WHICH RETURN RESULT SETS
JR14417CPU TIME INCORRECTLY CALCULATED. RESULT IS TOO BIG.
JR14446CLI ACCESS VIOLATION USING DOWNGRADED KEYSET CURSOR AGAINST MVS
JR14491THE BIND FILENAME IS TRUNCATED IF <CODE>></CODE> 50 CHARS IN SQLAJBND_BIND.
JR14517SQL1092 WHEN CREATING DB ON REMOTE SERVER FROM CLIENT. CATALOG_NOAUTH IS IGNORED.
JR14521JAVA COMMAND CENTER RESULTS GREYED OUT WHEN SCROLLING.
JR14550JAVA COMMAND CENTER WIN9X RESULTS <CODE>></CODE> 4682 CHAR DISPLAY PROBLEM
JR14576JDBC NET DRIVER RETURNS SAME RESULTS WITH PREPAREDSTAMENT.
JR14592CONNECT TO DATABASE ON NT HANGS IN STRICMP() C LIBRARY CALL
JR14595SQLDRIVERCONNECT IS SIGNIFIGANTLY SLOWER IN DB2 V6.1 COMPARED TO V5.2
JR14605DIA3419C--NETBIOS NOT STARTED SUCCESSFULLY RC 3
JR14606EXPORT OF DEL MODIFIED BY DECPT SUBSTITUTES PERIOD FOR ANY CHARACTER FOR ITALIAN VERSION DB2 ON NT
JR14625NT PERFORMANCE MONITOR NOT PROVIDING DETAILS FOR THE SECOND AND FOLLOWING APPLICATIONS
JR14646ADDING XBSA SUPPORT TO DB2 NT FOR SAP
JR14648DBA3037 ON VISUAL EXPLAIN WHEN DETAILED STATISTICS COLLECTED ON SOME BUT NOT ALL INDEXES FOR A GIVEN TABLE
JR14723SQL1112 -NOT ENOUGH SYSTEM RESOURCES WHEN TRYING TO SCHEDULE ~100 JOBS FROM THE SCRIPT CENTER
JR14737THE CLIENT IS INCORRECTLY CREATING MULTIPLE SNA CONVERSATIONS USING THE SAME LUWID. THIS IS CAUSING DB2 OS 390 TO ABEND.
JR14742DB2JDS.EXE GOES DOWN ON A VERY LARGE SELECT WITH ONE PARTICULAR USER
JR14759LOAD OF DEL FILE WHEN BOTH' CAST(NULL AS CHAR) USED IN EXPORT' & MODIFIED BY USEDEFAULTS IN LOAD : DATE INSERTED IS WRONG
JR14780SQL0750N WHEN TRYING TO RENAME TABLE WITH IDENTITY COLUMN.