Product Name:DB2 UDB V6.1 for OS/2
PTF Number:WR21301
Package Date:Fri Jun 14 10:33:39 EDT 2002
Build Level:s020401
APAR fixes included in WR21301 (Fixpak 11)
APARABSTRACT
GG04217ASNLMAIN.EXE TRAPS WHILE REPLICATING DB2/VSE DATA TO DB2/NT
GG04218FULL REFRESH APPLY TROUBLE WHEN HANDLING MANY COLUMNS
GG04233APPLY NEEDS TO TOLERATE SQLCODE +191 WHEN FETCHING ANSWERSET
GG04238ASNLOAD SHOULD NOT ISSUE RUNSTAT
GG04239INCORRECT SOURCE AND TARGET TABLE INFORMATION POSTED IN THE APPLY TRAIL TABLE DURING CONFLICT DETECTION AND COMPENSATION.
GG04246DATA LOSS WITH DATAPROPAGATOR APPLY WHEN THE SET HAS A LARGE NUMBER OF MEMBERS AND THE SOURCE IS A CCD.
GG04250APPLY DOES NOT TERMINATE WHEN COPYONCE IS SPECIFIED AND THE SET FAILS WITH A -1.
GG04251APPLY COULD MISS THE HINT AND RESULT IN MISSING ROWS IF CAPTURE ENCOUNTERS -911
GG04256ON WINDOWS 2000 SERVER DPROPR CAPTURE FAILS TO STOP WHEN ASNCMD STOP IS ISSUED
IY09902FILES IN TOOL DIR. MODIFY CHANGES IN REGRESSION BUCKET CLIFP GOING AGAINST LOCAL, ODBC AND MVS DB'S.
IY11281CREATE OF TABLE LIKE ONE IN SYSIBM SCHEMA THAT NEEDS UPDATING CRASHES INSTANCE (I.E. CREATE TABLE T1 LIKE SYSIBM.SYSTABLES)
IY14751IMPORT INSERT_UPDATE ABEND (SQL0007N) FOR UDT WHEN COLUMN NAME LENGTH EQUALS TO 18
IY14802SQL0206N FOR TRAILING TAB IN COLUMN NAME LIST FOR IMPORT FROM COMMAND WINDOW
IY18345ERRORS GENERATED FROM SQLO_AUTHORIZE_SEM_POOL: SQL0465N RC=23
IY19585UNION ALL ON A VIEW FAILS WITH SQL0840N
IY21010DB2GOVD: ROWSREAD CHECK LOOKS IF ROWSSEL == -1 TO CLEAR FLAG
IY21672REDIRECTED RESTORE ALLOWS TABLESPACE LARGER THAN 64GB LIMIT
IY23734INCREASE AUTOLOADER SOCKET CONNECTION TIMEOUT VALUE FOR SQL6555N
IY23791DB2/HACMP - NODE RECOVERY NEVER COMPLETES BECAUSE WE ARE LOOPINGIN THE SQLEEXECUTENODERECOVERY().
IY24309REDIRECTED RESTORE LOGS MISLEADING MESSAGES IN THE DB2DIAG.LOG.
IY24577APPLY RECEIVES FREAD ERROR WITH RETURN CODE OF 872105.
IY24872DB2 HANG / PERFORMANCE DEGRADATION / 100% SYSTEM CPU AT DIAGLEVEL 4 WITH ' PREFETCH QUEUE FULL ' MESSAGES
IY25304NO BACKUP IMAGE APPEARS ON BACKUP OF 10THE SESSION ON TSM THROUGH CC WITH ERROR DBA1605 NO BACKUP IMAGE INFORMATION WAS FOUND.
IY25339BIGINT NOT NULL DATA CORRUPTED ON DB2/390 BY INSERT/IMPORT
IY25370SQL0901 SQLRMGJN : CODEPAGE IS '0' INTERNALLY ON SYSINDEXCOLUSE THIS RESULTS IN INDEX KEYS IN INCORRECT ORDER ON THIS TABLE ONLY
IY25677DO NOT INVOKE RUNSTAT FROM APPLY
IY26007INCORRECT CODE PATH PRODUCED CORE DUMP.
IY26255DB2 INSTANCE CRASH DUE TO MEMORY CORRUPTION : DB2 AUDIT BUFFER OVERWRITE CAUSES TRAPS - SQLE_DATABASE_CONNECT_RESET IS COMMON
IY26607SQLJ DOES NOT GENERATE .CLASS FILES.
IY26652CRASH RECOVERY COMPLETES EARLY
IY26945UNSUCCESSFUL TABLE REORGANIZATION CAN LEAVE DIRTY PAGES AROUND IN THE BUFFERPOOL WHICH RESULTS IN TABLESPACE EXTENT CORRUPTION
IY27103DATBASE BROUGHT DOWN WHEN ENCOUNTER A HEURSTIC ROLLBACK REQUEST ON ATRANSACTION IN TABORT STATE. (EEE)
IY27532SIGNAL #11 SIGSEGV IN SQLRINIT DURING APPLICATION HEAP FULL
IY27795CAPTURE MAY STOP CAPTURING DATA FOR OLDER REGISTRATION AFTER A REINIT.
IY27991DURING ARRAY INSERT, DB2 HANGS IF THE CONNECTION IS STOPPED WHEN THE PARAMETER SIZE IS GREATER THAN WHAT WAS DECLARED.
IY28013SQL 1042, OR SQL 1072 OCCURS ON DB2START FOR SECOND INSTANCE STARTED ON THE SYSTEM
IY28115APPLY FAILS WITH SQL0206N ON A PREPARE IN AN UPDATE ANYWHERE SCENARIO
IY28606LONG DBCS QUERY GETS SQL0104N BECAUSE OF STRING TRUNCATION THROUGH JDBC CODE CONVERSION.
IY28626DSNL500I IN APPLY IN CONTINUOUS REPLICATION
IY28677CAPTURE WAS NOT UPDATING ALL LOB COLUMNS CORRECTLY FOR CERTAIN LOG VARIATIONS.
IY29319DPROPR CAPTURE - MISMATCH IN ROW COUNT BETWEEN SOURCE AND TARGETAFTER REPLICATION
IY29779APPLY GETS AN SQL1822N AND FAILS WITH CPGDRL: READ THE NEXT INTENTSEQ FAILED. ERRCODE IS 812104'
IY29834WHEN PREVIOUS APPLY SHOWS STATUS=-1 AND WHEN NEXT APPLY IS RUN USING MAX_SYNCH_MINUTES, THE APPLY DOESN'T WORK CORRECTLY
IY31543EMP/SMP ERROR MESSAGES REPORTED IN DB2DART OUTPUT AFTER ROLLFORWARD, OTHER SYMPTOMS COULD BE BAD PAGES IN DB2DIAG.LOG.
IY31545DUPLICATE RESULTS RETURNED BY QUERY IN EEE ENVIRONMENT
IY31548TRAP IN SQLOCPCV BECAUSE BPS SENDS A TRIPLET OF DATA WITH NUMENTRIES 1, WHEN IN-FACT THERE ARE NO ENTRIES TO BE SENT. IN
IY31550SQL0311 ERROR WITH UNICODE CODEPAGES AND SQLJ PROBLEM.
IY31551JDBC.NET.DB2DRIVER FUNCTION NEXT( ) RETURNING WRONG RESULTS
IY31552CLI0637-CANNOT PROCESS QUERIES WITH STARTING/ENDING BRACKETS.
IY31553SIGNAL #11 IN SQLOFMBLKEX() WHEN CALLED BY SQLRLCLO()
IY31554CUSTOMER EXPERIENCES MEMORY LEAK WHEN CALLING PREPARED STATEMENT USING JDBC ON A SOLARIS CLIENT.
IY31555SQL0901N - SQL STATEMENT FAILED, REASON - COLUMN NUMBER OUT OF RANGE
IY31556ALTER TABLE ... ADD COLUMN MAY CAUSE MISSING ROWS IN SYSIBM.SYCOLUMNS
IY31560A DROPPED REPLICATED SUMMARY TABLE STILL GETS REFERENCED BY A PACKAGE CAUSING FFFFF47A AND THEN DB2 CRASH.
IY31562WAS: DATABASEMETADATA.GETTYPEINFO NOT COMPLIANT WITH JDBC SPEC
IY31600"SQLOCSHR" LEAKS MAPPED SHARED MEMORY IF FAILURE OCCURS IN 2ND STATE ATTACHMENT. PROBE:220IN SQLOCSHR IN DB2CART.
IY31603DB2DART REPORTS INVALID INDEX TYPE OF 0X9101 FOR EXTENDED INDEX.
IY31618MISSING COMMIT AFTER AN UPDATE A BLOB.
IY31619INVOKING A STORED PROCEDURE THAT RETURNS RESULT SETS WITH LOB.SIGSEGV RECEIVED AT D48A8B34 IN /USR/LPP/DB2_07_01/LIB/LIBDB2.A
IY31622GET EXCEPTION: STRING INDEX OUT OF RANGE WITHNET DRIVER
IY31648TRAP IN SQLJIFSR WHEN GOING TO A DB2/390 V.7.1
IY31663CLI0637E ERROR IF THE SQL QUERY STRING CONTAINS TAB CHARATERS
JR16278EXECUTEQUERY() DOES NOT THROW AN EXCEPTION WHEN IT IS USED FOR SQL STATEMENTS THAT DO NOT RETURN A RESULT SET
JR16401DB2 ABENDS IN SQLERUNSYSCTLR DUE TO DOUBLE-FREEING OF MEMORY DARI PROCESS
JR16569SQL0901, SECTION LENGTH MISMATCH RETURNED IN SQLERRMC DURING TRANSACTION
JR16670IN DB2 CONNECT V6.1, WHEN A EXTDTA IS SENT TO THE HOST, DB2 CONNECT SENDS 2 EXTRA BYTES THAT THE HOST DOES NOT UNDERSTAND.
JR16724CLI0119E DURING XA CONNECT FROM JTA THEN SUBSEQUENT SQL30090N WITH RC=6. APPLICATION RESTART RESOLVES THE PROBLEM.
JR16753DB2DART TOOL MEMORY BUFFERS LIMITATION TO CHECK SMP
JR17125COLUMN TRUNCATION CAUSES CLI0615
JR17126CREATE_TABLE_DDL MISSING NOT LOGGED COMPACT ATTRIBUTE
JR17127ADD GETCLOB() AND GETBLOB METHODS FOR CALLABLESTATEMENT
JR17128JDBC DEFECTS FOUND DURING J2EE CTS TESTING.
JR17130INSTANCE CRASHES WITH DIA9999E AND INTERNAL CODE 0XFFFFF7 WHEN EXECUTING A SPECIAL KIND OF SQL COMMAND
JR17140DATA TRUNCATION DUE TO INVALID CONVERSION DURING CASING FROM INT (4-BYTE) TO SHORT (2-BYTE) AND LOSING HIGHER ORDER BYTES
APAR fixes included in WR21296 (Fixpak 10)
APARABSTRACT
IC32940CORRECT POTENTIAL SECURITY PROBLEM WITH DB2CKPW AND DB2CHPW
IY13665POOR PREPARE TIME WITH DISTINCT CLAUSE AND TRANSITIVITY
IY15783DB2AUDIT FAILS WITH AUD0022N WHEN FILE SIZE REACHES 4GIG
IY18143MEASSAGE FROM CLI_SDAINITSQLDAPARMFILING DB2DIAG.LOG FILE WITH ERROR 2064.
IY18754EXCESSIVE REAL MEMORY USAGE RUNNING SIEBEL WITH DB2 ON SOLARIS.
IY19481SQL0502 ERROR OCCURING WHEN USING JTA THROUGH A V6.1 GATEWAY TO A HOST DATABASE.
IY19513PREP TIME FOR A NUMBER OF QUERIES IN AN SAP BW SYSTEM UNACCEPTABLY HIGH @ OPTLEVEL 5
IY21438SNAPSHOT COUNTER LEAK FOR ACTIVE SORTS
IY21575SIGNAL 11 IN __CT__9SQLNQ_EHD/ SQLNR_CONVERT_MONTH_PRD
IY21678SQL RUN WITH WHERE CLAUSE CREATES BAD ACCESS PLAN WHEREAS THE SAME SQL WITH UNION RUNS WITH GOOD ACCESS PLAN.
IY21679SQL0802N DURING AVERAGE COMPUTE
IY21798INCORRECT RESULTS FROM QUERY RELATED TO CSE PREDICATE PUSHDOWN
IY21936IN JAVA, DOING GETBIGDECIMAL()ON A COLUMN TYPE DOUBLE YOU WILL GET NUMBERFORMATEXCEPTIONIF DOUBLE IS IN EXP. FORMAT.
IY21954CORE FILE GENERATED IF ALL PHYSICAL MEMORY USED ON CLIENT
IY22199FP10WAS STUDIO: FUNCTION SEQUENCE ERROR. CLI0125E.
IY22435WITH INTRA_PARALLEL ON, QUERY FAILED WITH SQL0901
IY22756BETTER HANDLING OF LOB FILES
IY23183SIGNAL 11 IN WRITEPAGES
IY23322TRAP WHILE RUNNING DB2ADVIS
IY23339IMPROVE THE COSTING FOR QUERIES INVOLVING ANY JOIN WITH A VALUESBOX
IY23440SNAPSHOT MONITORS DO NOT CAPUTRE THE SYSTEM/USER EXECUTION TIMESWHEN V7 CLIENT INTERACTS WITH V6 SERVER.
IY23979SQLJ IS BUILDING WRONG HOST VARIABLES FOR THE DECIMAL COLUMN.
IY24019DB2LOOK DROPS FOR BIT DATA IN CREATE DISTINCT TYPE DEFINITIONS
IY24025ANY WITH ABILITY TO PERFORM SET INTEGRITY ... OFF ON A SINGLE TABLE MIGHT PUT THE OTHER SPECIFIED TABLES INTO CHECK PENDING
IY24282DB2DIAG.LOG ENTRY : UNABLE TO FIND/REMOVE TABLE FROM NOLOG LIST : THIS SHOULD NOT BE LOGGED FOR DECLARED USER TEMPORARY TABLES
IY24324DB2DIAG.LOG SHOWS INDEX KEY COULD NOT BE FOUND (SRCHTREE ERROR: FFFF F92C), MARK DB BAD, PANIC AND SLEEP.
IY24644DRDA POINTER IS NOT INITIALIZED CORRECTLY IN TCP/IP COMMUNICATION. CAUSES TRAP UNDER CERTAIN CONNECTIONS USING JAVA
IY24645BUFFER CORRUPTION CAUSES REPLICATION TO FAIL.
IY24647INSTANCE CRASH AND TRAP AT SQLJDRD1
IY24806TABLESPACE TAKEN OFFLINE BY ROLLFORWARD CAN CAUSE DATA CORRUPTION IF ROLLED FORWARD AGAIN WITHOUT BEING RESTORED FIRST.
IY24826TRAP IN SQLO_TRCE WHEN USING XA & 2PC
IY24836THE COST IS WAY UNDERESTIMATED WHEN USING THE DB2PIPEDPLANS REGISTRY LEADING TO MSJN OVER NLJN..
JR15142NOT TO GENERATE MULTIPLE SEMIJOIN FETCH PLANS
JR15908INSERTING A NULL VALUE INTO A BLOB COLUMN, WE GET THE SQL0301N
JR15934AFTER SQL0905 FROM DB2 ON OS390, CURSOR IS NOT CLOSED AND ATTEMPTS TO ACCESS CURSOR GETS SQL0519.
JR15958INVALID SQL GENERATED WHEN DEFINE JOIN ON REPLICATION SOURCE
JR15964LOCK SNAPSHOT HANGS DURING A ROLLBACK CAUSING ALL OTHER DB2 OPERATIONS TO HANG UNTIL ROLLBACK IS COMPLETE - WORKAROUND
JR16028DB2_71 ON OS/2, BACKUP RETURNS SQL1224 WITH EXCEPTION C0000005
JR16187CLEANUP CODE FOR COMM. HANDLER AT WRONG PLACE - SQLFREEBUFFER CR
JR16191SQL3966N RECIEVED WHEN ATTEMPTING TO COMPLETE A PREVIOUS SYNC SESSION
JR16208DB2PROFC IS NOT USING QUALIFIER OPTION TO QUALIFY TABLES BEFORE DESCRIBING - RESULTS IN UNREPORTED SQL0204N
JR16242LOCK CONFLICT SHOULD NOT BRING DATABASE DOWN WITH -902
JR16321INCORRECT COMPILATION INSTRUCTION IN SAMPLE DB2UEXT2.CADSM (NT)
JR16341WINNT DB2MSCS/DB2ICLUS SUPPORT COMPUTER NAME GREATER THAN 8 CHAR
JR16372JDBC IS NOT HANDLING THE SETCONNECTIONATTRIBUTE() CORRECTLY. AND THERE IS NO WORK AROUND.
JR16386JDBC2.0 FUNCTION EXECTUEBATCH( ) NOT WORKING AS IT SHOULD.
JR16396SORT ROUTINE CALED TWICE: ONCE DIRECTLY AND ONCE INDIRECTLY SO PERFORMANCE IS DEGRADED.
JR16416TRAP IN SQLJ WHEN FREEING MEMORY FROM A CURSOR CONTROL BLOCK (DRDA)
JR16419INFINITE LOOP IN CLI CATALOG CALLS AGAINST VM DB2.
JR16420COGNOS IMPROMPTU APPLICATION IS FAILING WITH CLI0501N WITH ASYNC=1
JR16422DB2 GATEWAY TRAPPING AFTER RECEIVING DATA FROM A STORED PROCEDURE ON OS/390.
JR16428GETCOLUMNNAME() WITH NET DRIVER TRUNCATES COLUMN NAME TO 29 CHARACTERS IF COLUMN NAME LENGTH IS 30 CHARACTERS
JR16430SELECT INTO FOR SQLJ NOT RETURNING CORRECT SQLCODE
JR16431DB21036E WHEN CALLING SP FROM CLP WITH SP NAME THAT HAS '_'
JR16450SORT ORDER ON VARGRAPHIC COLUMNS ON UNICODE DBS WRONG
JR16481ROWSTATUSARRAY OF SQLEXTENDEDFETCH SHOULD REFLECT SQL_SUCCESS_ WITH_INFO FOR THE ROW(S) THAT GENERATED CLI0165E
JR16487TRAP IN SQLPGETDBMON DURING A DATABASE RESTORE
JR16567HANDLING LOCK CONFLICT OF CONDITIONAL LOCK FOR APAR JR16242
JR16579USEJDBC2.BAT FAILED BUT 'INUSE' SHOWS JDBC2.0
APAR fixes included in WR21260 (Fixpak 9)
APARABSTRACT
GG04206APPLY NOT REDRIVING APPLY WHEN AN RI VIOLATION IS DETECTED IN THE 'F' DIRECTION.
GG04207APPLY IS HAVING PROBLEMS REPLICATING FROM BASE TABLE OF AS/400 BLOB FIELD TO WIN 2000 SERVER RUNNING DB2 UDB EE V7.1.
GG04208APPLY FAILED SQLCODE911 WHEN REPLICATING FROM VM SOURCE SERVER
GG04214APPLY DID NOT FULLREFRESH IF CAPTURE COLD START AT REPLICA
IY15200CLOSING SINGLE CONNECTION AFTER MULTIPLE CONNECTION IS ESTABLISHTO REMOTE SEVER RESULTS IN CLI0106E ERROR ON IRIX PLATFORM.
IY15734INSTANCE CRASH ON TRAP (SIGSEGV) IN SQLBLATCHPINNEDPAGE EEE ONLY. INTERNAL SYNCHRONIZATION PROBLEM EXECUTING SQL.
IY16367IF SQLEXECUTE FOR A CALL STATEMENT RETURNS SQL_SUCCESS_WITH_INFO-THE JDBC APPLET SERVER DOESN'T WRITE OUT THE OUTPUT PARAMETERS.
IY16754SQL2062N AN ERROR OCCURRED WHILE ACCESSING MEDIA '/APPS/DIT/NEWYORK/DB2/P1DBINC/SQLLIB/ADSM/LIBADSM.A'.RC:'137
IY17199PRECOMPILER REJECTING THE INDICATOR VARIABLE ATTACHED WITH THE HOST VARIABLE.
IY17394SQL0900N: LOAD RECREATE INDEX DOES NOT UPDATE METAROOTPAGE PROPERLY.
IY17521AN APPLICATION SENDING A BAD RID (BOOKMARK) CAUSES DB2 TO PANIC,AND AN ENGINE TRAP DURING A DIRECT FETCH.
IY17652TRAPS WHEN USING LOB FILE INPUT DATA
IY18124MAX_SYNCH_MINUTES WITH CCD - APPLY UPDATES THE SUBS_SET SYNCHPOINT INCORRECTLY CAUSING POTENTIAL DATA LOSS
IY18178VB IDE GETS 'ERRORS OCCURRED' MESSAGE WHEN TRYING TO GET A LIST OF STORED PROCS WITH NAMES GREATER THAN 8 BYTES.
IY18246AST ROUTING USES INCORRECT CARDINALITY ESTIMATE
IY18293SAMPLE USEREXIT SHOULD INDICATE THAT 'MOVE' IS UNSUPPORTED FOR LOG ARCHIVING - ONLY 'COPY' IS SUPPORTED
IY18327DIA3847C AN ERROR OCCURRED IN A DATABASE PAGE HEADER BY DB2PFCHR
IY18373APPLY SHOULD EXECUTE THE SQL BEFORE AND AFTER STATEMENTS FOR A SUBSCRIPTION SET EVEN IF THERE IS NO DATA TO REPL. IN THAT CYCLE
IY18386DB2AUDIT, NO DATABASE NAME FOR CHECKING EVENT BY SUBAGENT
IY18418RUNSTATS DOESN'T UPDATE SYSIBM.SYSCOLUMNS CORRECTLY
IY18781SQL0973N WHEN PACKAGE CACHE NOT OVERFLOWED - CAUSED BY NOT ACCOUNTING FOR OSS OVERHEAD.
IY18975OVERCOSTING THE I/OS OF THE RIGHT HAND (INNER) PLAN OF THE NLJN'S THAT ARE OF THE TYPE THAT THE INNER HAS NO SORTS OR TEMPS
IY18990TRAP IN SQLNO_CRULE_INDEX_ANDING WHEN OUT OF STMTHEAP
IY19041ISERIES (OS/400) V5R1 AS A CLIENT DOES NOT INTEROPERATE WITH WORKSTATION DB2 UDB AS A SERVER
IY19053TRAPPED IN SAVEPOINT WHILE ROLLBACK,SHOULD IGNORE SQLCODE-1035 FROM REMOTE NODE
IY19086TELNET TO JDBC DAEMON (DB2JD(S)) TRAPS AFTER KEYING 10TH CHARAC TER
IY19116OPTIMIZED QUERY RETURNS INCORRECT RESULTS
IY19336SMALL TIMING WINDOW WHERE THE CAPTURE READS A LOG WHILE IT IS BEING ARCHIVED -> WORKAROUND: RETRY SHOULD RESOLVE
IY19492LONG PREPARE TIME FOR EEE QUERIES INVOLVING MULTIPLE JOINS, WHERE AT LEAST ONE OF THE TABLES RESIDES IN A MULTI-NODE NODEGRP
IY19535ERROR MESSAGE DIA3808C IS INCORRECTLY DUMPED OUT IN THE DB2DIAG.LOG FILE WHEN THE ACTUAL ERROR IS SQL1013.
IY19657WHEN A COMMAND IS RECEIVED, CAPTURE STILL READS A LOG RECORD BUTFORGETS IT, AND READS THE NEXT RECORD AFTER PROCESSING THE CMD.
IY19670TRAP - SIGNAL 11 IN SQLPM_WRITE_LOCKS WHILE PERFORMING LOCK SNAPSHOT CRASHED THE DB2 INSTANCE
IY19934ATTRIBUTES ON SQLLIB/FUNCTION/JAR DIR FOR 'OTHER' NOT PROPER.
IY19939ADDITION OF CODE TO CHECK FOR ORDER BY CLAUSE ON AN UNTYPED PARAMETER MARKER
IY19954SQL1042C ON CONNECT TO A CONSISTENT DATABASE TRYING TO ALLOCATE INITIAL LOGS OVER A LOG THAT WAS EXTERNALLY TRUNCATED/CORRUPT.
IY20037DB2PFCHR,DB2PCLNR,DB2REBAL,DB2ESTOR PERSIST EVEN AFTER DBM SHUT DOWN & CONSUME CPU RESOURCES UNTIL REBOOT: RESULT POOR PERFORMAN
IY20046REVERSE INDEX SCAN CAN MISS KEYS IF HIT PARTIAL PAGE SPLIT ROLL-BACK
IY20048REVERSE SCAN MISS KEYS IF HIT PAGE SPLIT (TIMING).
IY20064SQL0973 QUERY HEAP MEMORY LEAK - CLI ONLY WHEN DATA TYPES OF PARAMETER AND COLUMN DO NOT MATCH, DB/APP USE DIFF CODEPAGES
IY20069PROBLEM WITH DATAPROP/CAPTURE. TIMESTAMP NOT INITIALIZED.
IY20090CLI SQLEXTENDEDFETCH() GETS "NUMERIC VALUE OUT OF RANGE"
IY20157ROLLFORWARD STATUS = TABLESPACE, BUT NO TABLESPACE IN THIS STATE -> RESTORE, THEN TBLSPC DROPPED B/F ROLLFORWARD
IY20179LOAD SEEMS TO HANG
IY20191SQLJ.INSTALL_JAR PROBLEM
IY20221SQL4912N WITH SQLJ HOST VAR IN LIKE COMPARISON AGAINST MVS 6
IY20235SQLPUPDATEMINBUFFLSN PROBE:50 SHOULD NOT BE DUMPED INTO THE DB2DIAG.LOG AS IT IS ONLY INFORMATIONAL USED FOR DEBUGGING
IY20285THE HOST DB2 DATABASE BACKUP FAILS AS IT SEES THE LINK FILES ON DLFM ARE NOT YET BACKUPED.
IY20318SQLBGETPOOLSTATS CAN CAUSE LOG CORRUPTION
IY20457TRAP BECAUSE DB2 V6 CONNECTION POOLING DOES NOT SUPPORT CLIENT USING IPC CONNECTION TO CONNECT TO GATEWAY.
IY20474ADD FUNCTIONALITY TO SUPPORT EEE RESTORE FROM LEGATO AND XBSA
IY20656DB2OPTIONS: CLP IS USING THE OSS FUNCTION SQLOFPRT
IY20673HOST SERVER (E.G. DB2/390) RETURNS SQL0805N DURING IMPORT DUE TO A PACKAGE NOT FOUND.
IY20814DB2 CONNECT MAY CRASH WHEN PROCESSING THE REPLY FOR AN APPLICATION THAT IS THE VICTIM OF A DEADLOCK OR TIMEOUT
IY20969SIGNAL 11 TRAP IN SQLNO_SHRINK_POOL.
IY21022SUBOPTIMAL PLAN CHOSEN FOR STAR JOIN
IY21341LOG DIR FILLS DUE TO OLD LOG FILES NOT BEING DELETED/RENAMED DURING CRASH RECOVERY, AND SAME LOG IS REPEATEDLY ARCHIVED
IY21375SQL4908N IS GENERATED WHEN RF ON TABLESPACES IS ISSUED AGAIN ON TABLESPACES WHICH ARE RF PENDING STATE AND FLAG IN LFH IS ON.
IY21415DEADLATCH IF EVMON AND SNAPSHOTS ARE CALLED IN THE SAME TIME
IY21846DPROPR APPLY DOES 2 FULL REFRESHES AFTER CAPTURE COLD START.
IY21936IN JAVA, DOING GETBIGDECIMAL()ON A COLUMN TYPE DOUBLE YOU WILL GET NUMBERFORMATEXCEPTIONIF DOUBLE IS IN EXP. FORMAT.
IY21937JVM CRASHES WHEN PASSING NULL TO STATEMENT.EXECUTE( )
IY21938NO ROWS ARE RETURNED WHN A +437 IS RETURNED IN MINMEM
IY21939SQL0998 RC=13 AX_REG() AND AX_UNREG() NOT FOUND
IY21940SQLPUTDATA OF ZERO BYTES IN CAUSING A MEMORY OVERWRITE
IY21947SQL2025N RC=-50 ON A DB2 BACKUP TO ADSM AFTER A NODE IS ADDED THAT DOES NOT CONTAIN DATA (EG. TEMP TABLESPACE)
IY21951SIGNAL 11 TRAPS IN MEMORY OPERATIONS (MEMHOLDSEG AND SQLOFMBLK) COMING FROM SQLNO_CLOSE_POOL
IY21952IMPORT WITH BUFFERED INSERT CAUSES TABLE LOCK ON SYSIBM.SYSPLAN
IY21953APPLICATION WITH MINCOMMIT 4 AND HANGS WAITING FOR LOG DATA TO BE WRITTEN TO DISK
IY21995QUERY AT OPTLEVEL 3 RECEIVES A SQL0101 EVEN WITH STMTHEAP MAXED
IY22008ONCE JOBIDS HIT 999, JOBIDS ARE REUSED. HOWEVER, JOBS ISSUED VIA 'RUN NOW' KEEP REUSING SAME JOBID
IY22291TRAP IN SQLCSPC_COOR_REG WHEN HOST EXPERIENCES COMM. PROBLEMS
IY22298DB2BATCH DOES NOT SUPPORT VARGRAPHIC, CAUSES TRAP.
IY22459MS 932 IS EQUIVALENT TO IBM 943. WE ARE ACTUALLY DOING CODE PA
IY22698SCHEDULED JOB NO LONGER RUNNING IN SCRIPT CENTER AFTER APPLYING FIXPAK8 (V6.1) B/C THE DB2JOB2 IS MISSING IN FIXPAK8
IY22985DB2 INSTANCE CRASHED WITH SIGNAL #11 IN SQLRA_FP_COPY()
IY22988TABLESPACE REMAINS IN LOAD PENDING IF ASC/DEL FILE NOT ACCESSIBLE
IY22990AUTOLOADER HANGS WHEN USING FILE_TRANSFER_CMD AND LOAD ABORTS
IY23140SIGNAL 11 TRAP IN SQLBLATCHPINNEDPAGE() IN MPP/EEE ONLY INVOLVES A WHERE CURRENT OF CURSOR (WCOC) UPDATE OR DELETE STATEMENT.
IY23205A NEW DB2 HISTORY FILE IS CREATED DURING A FAILED MIGRATION, WHICH CAUSES ALL SUBSEQUENT MIGRATIONS TO FAIL.
IY23210THE CLP ON SOLARIS CALLS GETPASS WHEN ISSUING AN EXPLICIT CONNECT WITHOUT A PASSWORD GIVEN WHICH LIMITS THE NUMBER OF CHARS TO 8
IY23227DB2BATCH RETURNS ELAPSED TIME "NOT COLLECTED"FOR INSERT STMT
IY23245SQL3015N - INSTANCE CRASHES DURING IMPORT BECAUSE OPEN CURSORS ARE ENCOUNTERED DURING IMPORT REPLACE
IY23321LOAD WITH FASTPARSE REJECTED DATE DATA BECAUSE DATE CONVERSION ROUTINES RAN AGAINST COLUMNS INDICATED (IND) AS NULL.
IY23455CONTROL CENTER INCORRECTLY FOLDS USERID TO UPPER CASE USING THE NATIONAL LANGUAGE CODE PAGE INSTEAD OF THE ENGLISH CODE PAGE.
IY23456CLI TRACE DOES NOT CAPTURE SOME UNICODE FUNCTIONS
IY23458HASH JOIN GIVES INCORRECT OUTPUT.
IY23459DB2ADUTL HAS A ARCHIVE LOG LIMIT OF 1023 ENTRIES.
IY23476DB2 CRASHES AT FUNCTION SQLESRVR
JR15209DR. WATSON OR HANG ON TEST CONNECTION IN CCA ON DB2 V6.1 FP5
JR15220SQLPUTDATA() MAY RESULT IN SQL0157N UNDER HIGH CONCURRENCY
JR15234INSERTING 'DIRTY' TIMESTAMP INTO DATE COLUMN RESULTS IN NO DATA INSERTED, BUT SQL_SUCCESS_WITH_INFO RETURNED TO APP
JR15540RUNSTATS CAUSES DB2 TO TRAP IN SQLIPROCESSCOL
JR15786DETAILED STATS PRODUCE BAD PLAN AT OPT 5
JR15857USERIDS NEED WRITE AUTHORITY ON DAS DIRECTORY TO RUN SCRIPTS
JR15880SQL30081 RC:10054
JR15899TRAP IN SQLOFMBLKEX DURING RESTORE FROM DISK DUE TO MEMORY CORRUPTION
JR15908INSERTING A NULL VALUE INTO A BLOB COLUMN, WE GET THE SQL0301N
JR15909HOSTNAMES > 8 CHARS DISPLAY INCORRECTLY IN SQL GENERATED BY CC
JR16025SQLGETDATA() FAILS TO RETRIEVE DATA AFTER SQLSETPOS()
JR16028DB2_71 ON OS/2, BACKUP RETURNS SQL1224 WITH EXCEPTION C0000005
JR16039DB2TBST TOOL DOES NOT SHOW THE STATE OF ALL THE TABLESPACE STATEIN SQLUTIL.H
JR16079TRAP IN SQLJMBCQ BECAUSE THE DRDA HEAP IS EXHAUSTED
JR16133ROLLFORWARD SHOULD DETECT AN INCOMPLETE LOG FILE
JR16218WHENEVER THE CUSTOMER GOES TO GET THE SOURCE STORED PROCEDURE CODE IN THE STORED PROCEDURE BUILDER HE GETS SQL0514.
JR16219KEYSET PARSER RETURN CODE=1002 CAUSES HEAP CONSUMPTION
JR16220XA PASSWORD LENGTH SHOULD BE 14 CHARACTER MAX
JR16222KEYSET CURSOR QUERY DOES NOT WORK AGAINST TABLE ALIASES.
JR16223SQLEXTENDEDFETCH RETURNS SQL_SUCCESS_WITH_INFO IF A ROW DETECTEDAN ERROR AND ONLY ONE ROW BEING RETURNED.
JR16225GETTING CLI0114E ON INSERT OF A RECORD WITH A DATETIME DATATYPE IN A VC++ APPLICATION
JR16226TABLE WITH INDEX AND LONG VARCHAR WILL ONLY RETURN FIRST COLUMN
JR16227EXECUTEUPDATE() DOES NOT THROW EXECEPTIONS FOR SELECT STATEMENTS
JR16274SMCODE=-28 FROM PERFMON AFTER CC ABNORMAL TERMINATION
JR16277ASNCCP.EXE IS REPORTING SQL2657 ERROR AND DB2DIAG.LOG REPORTS LOG FILE SIZE PROBLEM.
JR16278EXECUTEQUERY() DOES NOT THROW AN EXCEPTION WHEN IT IS USED FOR SQL STATEMENTS THAT DO NOT RETURN A RESULT SET
JR16294OS/2 DB2 BACKUP VIA USEREXIT WILL FAIL AT AND AFTER SUNDAY SEPTEMBER 9TH 01:46:39 2001
JR16355TRAP IN SQLE_DB2RA_AS_DB_FETCH
JR16372JDBC IS NOT HANDLING THE SETCONNECTIONATTRIBUTE() CORRECTLY.AND THERE IS NO WORK AROUND.
JR16389CONNECTIONS TO LOCAL DATABASE CONSUME LAN CACHED CREDENTIALS ON WINDOWS 2000 WHEN NOT CONNECTED TO DOMAIN
JR16390DRDA_HEAP_SZ MEMORY LEAK. SYMPTOMS: SQL30081, RC= *,*,0.
JR16395DB2 IS TRAPPING IN THE FUNCTON SQLEMRSP_AS.C
JR16396SORT ROUTINE CALED TWICE: ONCE DIRECTLY AND ONCE INDIRECTLY SO PERFORMANCE IS DEGRADED.
APAR fixes included in WR21255 (Fixpak 8)
APARABSTRACT
GG04082SQLCODE313 PRESENTED AFTER USING OFFLINE LOAD PROCEDURE
GG04108ASNAPPLY WITH PARM NOSLEEP DID NOT ISSUE A 'CONNECT RESET',WHICH LEADS TO DSNL500I CONVERSATION FAILED MESSAGES ON DB2 OS/390
GG04110NO TWO CAPTURES CAN BE STARTED WITH THE SAME DATABASE ALIAS (SRC_SERVER IN THE BOOK) IN DIFFERENT DB2 INSTANCES
GG04128IF A COMMUNICATION ERROR OCCURS (ASN1001E, SQL30081), THEN APPL RETURNS WITH RC=0 TO THE OS
GG04196OVERRIDE THE DEFAULT PARAMETERS OF LOGREUSE AND TRLREUSE USED BY ASNSAT WHEN INVOKING APPLY.
GG04201ASNCMD STOP FAILS TO STOP DATAPROPAGATOR CAPTURE.
GG04205ASNLOAD FAILED WHEN INVOKING APPLY USING A NETWORK ID.
IY13152USING VARCHAR AGAINST MVS IS LIMITED TO 254 CHARACTERS USING CLI
IY13799PACKAGE CACHE ENTRY FOR SELECT DOES NOT INDICATE THAT DEFAULT QUALIFIER (SCHEMA) HAS BEEN CHANGED
IY14526PROBLEM EXECUTING UPDATE QUERY AFTER INDEX ON AST
IY14777PREPAREDSTATEMENT.SETLONG() CALL FAILS TO DB2/390
IY15022CONVERSION TABLE ERROR MESSAGE IS INCOMPLETE
IY15093WRONG MAPPINGS FOR ERROR MESSAGE SQL0465N AGAINST OS/390
IY15533WRONG RESULTS CAUSED BY A MGJN WHICH IS NOT PROPERLY ORDERED.
IY15942DB2 OPTIMIZER DOES NOT HANDLE 'OPTIMIZE FOR N ROWS' CORRECTLY BY FAVOURING PIPED PLANS.
IY15977INFLATED CARDINALITIES ON EEE QUERIES USING NODENUMBER(COLUMN) PREDICATE MAY CAUSE OPTIMIZER TO CHOOSE BAD PLAN IN V6,V7
IY16009ERROR IN MIGRATING FROM DB2 V5.2 TO DB2 V6.1, SQL0293 CONTAINERS COULT NOT BE FOUND.
IY16164ASNCAPTURE RETURNS -1 WHICH INDICATES A FAILURE EVEN WHEN A NORMAL MOBILE STOP HAS OCCURRED.
IY16208MQBACK ROOLBACK FROM MQSERIES CAUSES PROBLEMS IN EEE ENVIRONMENT
IY16210DB2DART /DDEL EXPORTS INCORRECT DATA ON NULL VALUE.
IY16294MAX COST LIMITATION WITH V6.1 QP GUI.
IY16316CONTROL CENTER HANGS WHEN ACCESSING TABLESPACE DATA FOR DB2 UDB ENTERPRISE EXTENDED EDITION (EEE)
IY16434DB2ADUTL RETURNS INCORRECT OUTPUT
IY16487LOAD OF TRUNCATED IXF CAUSING RECORD LENGTH <0 CAUSES EDU CRASH
IY16498. DB2 UDB ON UNIX/OS2/WINDOWS TRAPS WHEN ACCESSED FROM HOST SYSTEM
IY16513TRAP IN SQLOFMBLKEX, BUT BAD POINTER IS FROM SQRRCOM_RDS
IY16521DATABASE CRASHES AFTER INTERRUPTED REORG
IY16571CAPTURE STOPS PROCESSING WHEN IT RECEIVES SQL0100 (ROW NOT FOUND ) IN THE PC TABLE.
IY16577DB2ADUTL FROM SCRIPT CENTER FAILS WITH: ERROR: INITIALISE SESSION FAILED WITH ADSM RETURN CODE 168.
IY16639CREATE TRIGGER STATEMENTS GENERATED BY DB2LOOK FAIL TO RUN DUE TO THE LINE BREAK IN SCRIPT
IY16674CHANGING CAPTURE CODE TO PROCESS ALL THE COMMITS IN THE LOCAL NODE, WHICH WILL INCLUDE THE LOG RECORD TYPE OF 'C'
IY16677SQL1042 - INSTANCE CRASH / PANIC ON EEE WHEN MAXAPPLS IS HIT - SQL1040 - AND AN INTERRUPT OCCURS AT THE SAME TIME
IY16687DB2ICRT SUCCESSFUL BUT ERROR MESSAGE: MV: CANNOT RENAME /../SQLLIB/ADM/DB2SYSC.AIX433 TO /.../SQLLIB/ADM/DB2SYSC
IY16693SQLDESCRIBEPARAM NEEDS TO DESCRIBE 1ST PARAMETER MARKER VS 1ST PARAMETER
IY16721BAD FILTER FACTOR ESTIMATES FOR 'LIKE ?' AND ZERO FF FOR BETWEEN PREDICATES
IY16746INDEX STOP/START KEY LOGIC ALLOWS TOO MANY ROWS
IY16750TWO-PHASE CONNECT FAILED WITH SQL0902C 94 CCI
IY16758SQLEXTENDEDFETCH FAILS WITH CLI0115E
IY16800INCORRECT NUMBER OF ROWS READ/WRITTEN IN SQLCACHE
IY16814SEG FAULT WHEN RUNNING DB2EXPLN
IY16937DB2ADUTL FAILS WITH ANR0445W - MAXIMUM GROUP TRANSACTION SIZE EXCEEDED.
IY16951F51D IN SQLPGILT DURING RESTART DB OR CONNECT
IY16958SQL0901 IN SQLNO_SMP_FIX_COST DURING QUERY, INTERMITTENT
IY16971SQLJ CUSTOMIZER SHOULD SUPPORT MULTIPLE SER CURRENT PACKAGESET STATEMENTS.
IY16975WHEN USING SETSTRING(), DATA IS TRUNCATED IN STORED PROCEDURE
IY16992DB2LOOK PRODUCES OUT-OF-ORDER COLUMNS FOR FOREIGN KEYS
IY17006LOGSPACE INFORMATION REPORTED IN DB2 SNAPSHOT IS INCORRECT
IY17011IMPORT PROFILE FAILS TO CREATE DCS DB CATALOGS
IY17036CLI0109 STRING DATA RIGHT TRUNCATION ERROR WHEN CLEARPARAMETER() IS USED
IY17053DB2SPLIT FAILED IF OUTPUT FILE > 2GB
IY17056DB2ATLD USES SORT BUFFER TO OVERRIDE THE SORTHEAP IN DB CFG.
IY17075DB WITH LINKS IN PATH FAILS TO RESOLVE PATH FOR BACKUP. A -1062 OR -1042 RESULTS, SUBSEQUENT CONNECTS MAY TRAP (SIG11).
IY17077INSTANCE DARI'S HAVE NULL DBCONN AND SHOULDN'T TRY TO WRITE RESULT SET INFO.
IY17079DIA3711C A FILE '' COULD NOT BE FOUND MESSAGE DUMPED INTO THE DB2DIAG.LOG FILE SHOULD HAVE THE FILENAME
IY17163WHEN EXTRACTING DDL FOR A TABLE USING DB2LOOK, THE OUTPUT COLLEC TED SHOWS SOME UNRELATED VIEWS.
IY17179SIGNAL#11 IN SQLUDRSA
IY17191READING THE LENGTH OF A VARCHAR INCORRECTLY IN THE INSTALL JAR C ODE: IT CHECKS AGAINST A 128 BYTE URL LENGTH.
IY17255RESTORE DB FAILES WITH SQL5005 SQLF_MIG_REL8 FFFFEC41
IY17260CORRECTION OF THE OUTER_DVALS CALCULATION FOR ORDERED NLJN
IY17290DB2 UDB DRDA AS (APPLICATION SERVER) TRAPS WITH SIGNAL 36 WHEN TRYING TO FREE MEMORY
IY17293WITH NON-ADMIN USER, ICLUI COMMAND CENTER, WHILE REGISTRY IS BEING UPDATED, THROWS AN ACCESS EXCEPTION IN WINDOWS2K.
IY17296SQL4301 RC=4, AFTER INVOCATION OF JAVA STORED PROCEDURE, THE JNI OBJECT IS NOT DEALLOCATED FOR TIMESTAMP, TIME AND DATE PARMS
IY17360SQLJMF91 ATTEMPTS TO USE MEMORY THAT WAS FREED
IY17378SQL0902 ON BACKUP
IY17406DATABASE CRASH WHEN ATTEMPTING TO UNFIX A PAGE IN THE BUFFERPOOL WHICH WAS NOT FIXED.
IY17429DB2 CRASH WITH SIGNAL 11 IN SQM_INIT_SQLM_TABLESPACE()
IY17468MANY DEFUNCT DB2 PROCESSES OWNED BY THE FENCED ID AND WHOSE PARENT IS DB2SYSC PROCESS.
IY17472LOAD HANGS WITH 'THREAD CANNOT CHECK CHECK POINT' ERROR IN DIAG. LOG
IY17489SIGSEGV IN SQLRA_INVAL_VARS_HARD
IY17525SQL1015N, DATABASE MARKED BAD DUE TO IMPROPER SAVEPOINT HANDLING
IY17542MEMORY CORRUPTION CAUSED BY DB2 WILL CAUSE APPLICATIONS TO COME DOWN WITH SIG #11, SQLODELETE, SQLOGMBLK, ETC.
IY17576JAVA VISUAL EXPLAIN NUMERICAL LITERAL ERROR
IY17577INCONSISTENT RESULT FROM DB2ADUTL WHEN .LOG IS SPECIFIED VERSUS NOT.
IY17591DB2EXFMT OUTPUT SHOWS A NEGATIVE COST FOR AN ACCESS PLAN
IY17600SIG. 11 TRAP IN RETRIEVEBATCH
IY17619DIA1529C COULD NOT START DEADLOCK DETECTOR, GLOBAL DEADLOCK DETECTOR FAILING TO START.
IY17649ONLINE DATABASE BACKUPS RETURN SQL2038N RC -3838 AFTER A FAILED CREATE TABLESPACE
IY17657REORG TABLE <TB> INDEX <INDEX> RETURNS SQL2205 WHEN INDEX EXISTS
IY17698APPLY UPDATED THE WRONG SYNCHPOINT AND SYNCHTIME IN PRUNCNTL TBL
IY17767INVALID INPUT DURING ASCII TO PACKED DECIMAL CONVERSION CAUSES SEGV/CORE AND POSSIBLY STACK CORRUPTION (MOSTLY AT DIAGLEVEL 4)
IY17851NULL TERMINATED STRING CAUSES DB2 TO TRAP WHEN WE HAVE TO REDESCRIBE A STORED PROCEDURE CALL STATEMENT
IY17853'INVALID EXECUTE FLAG' DB2DIAG.LOG ENTRY WILL ALSO CAUSE SQLCODE -901.
IY17922RESTART/CONNECT/CRASH RECOVERY FAILS WITH SQL1042C WITH INVALID LSN DUE TO A PROBLEM WHEN ABORTING A TRANSACTION
IY18093AN AGENT HANGING IN TQ CODE, ANOTHER STUCK ON APM LATCH
IY18119STATEMANT MONITOR EVENT LIST CORRUPTION
IY18121TRAPS (SIGNAL #6) IN FUNCTION SQM_EVMON::LOG_EVENT()
IY18122MEMORY LEAK IN SQLRI_LIKR_ALLOC()
IY18162DB2DART REPORTS BPS HEADER PROBLEMS AFTER DATABASE RESTORE.
IY18231DB2 APPEARS TO BE 'HUNG' WHILE TRYING TO ACCESS A TABLE
IY18373APPLY SHOULD EXECUTE THE SQL BEFORE AND AFTER STATEMENTS FOR A SUBSCRIPTION SET EVEN IF THERE IS NO DATA TO REPL. IN THAT CYCLE
IY19007GETS ERROR IN DB2DIAG.LOG SQL -901 SQLERRMC: SQLNO_CRULE_SAVE_PL ANS ì100•:RC(0) SQLERRP :SQLRFAKE WITH STAR JOIN PLANNING.
IY19009A FILE SHARING VIOLATION HAS OCCURRED, FILENAME WAS ''.ZRC=FFFFF 616.DB2 FAILS TO USE THE ARCHIVED LOG FILES,HELD BY OTHER APPLIC
IY19012SQL0567 : DB2LOOK -X PUTS GROUP BEFORE PUBLIC . GROUP CANNOT BE USED BEFORE PUBLIC IN GRANT OR REVOKE STATEMENT
IY19019COMMENT IN DB2CLI.INI PREVENTS DATASOURCE FROM WORKING PROPERLY
IY19020DATABASEMETADATA.GETDRIVERNAME() RETURNS LIBDB2.A INSTEAD OF DB2
IY19021VERSIONING NOT SUPPORTED IN DB2DATASOURCE CODE
IY19022ERROR IN SIZE OF RETURN VALUE FOR INOUT VARCHAR PARAMETERS
IY19023SQL0510N CAUSED BY NOT REUSING SECTIONS CORRECTLY IN THE PKG
IY19024DB2CCOR/DB2CCWRK PAIR DOES NOT TIME OUT WHEN SPAWNED IN THE CONTEXT OF NODES STATUS MONITORING
IY19026ABEND WHEN USING VARCHAR 600 FOR BIT DATA
IY19027SUPPORT FOR SQL_ARD_TYPE DATA TYPE.
IY19028GETDRIVERNAME() CALL TO RETURN OUTPUTS TO DISTINGUISH BETWEEN JDBC APP AND NET DRIVERS.
IY19030DATA CORRUPTION OCCURS ATTEMPTING TO GET BLOB FROM DBCS DB
IY19031TABLE BEING MARKED FOR DELETE PENDING BEFORE LOG RECORD IS WRITTEN
IY19035INCORRECT FILTER FACTOR COMPUTATION FOR RANGE PREDICATES
IY19037USING QMF V7.1 FOR WINDOWS TO ACCESS PARTITIONED DATA ON DB2 UDB EEE V7.1 RESULTS IN SQL1013 'DATABASE COULD NOT BE FOUND'
IY19038OUTPUT IS CUT OFF WHEN JAPANESE(HANKAKU/KANA) IS AT THE HEAD OF THE DATA.
IY19055SQL SELECT STATEMENTS GIVES INCONSISTENT OUTPUT ON MULTIPLE RUNS
IY19056SQL0803 ON REBIND OF APPLICATION
IY19057SNAPSHOT OUTPUT SHOWS 'MAXIMUM ASSOCIATED AGENTS = 0' AND 'AGENTS ASSOCIATED WITH APPLICATION = 1' WHICH IS INCORRECT
IY19058JOBIDS ARE NOT REUSED WHEN 999 LIMIT IS REACHED IN SCHEDULER
IY19098CANNOT RUN DB2GOV W/ SYSCTRL GROUP USER THAT IS NOT INST OWNER.
IY19114$N CLAUSE IN CREATE TABLESPACE PROBLEM
IY19115ERROR IN CONVERTING STRING TO DECIMA
IY19116OPTIMIZED QUERY RETURNS INCORRECT RESULTS
IY19117DEBUG CODE TO DUMP INFO WHY USEREXIT STOPS ARCHIVING LOGS
JR14514CANNOT CREATE A KEYSET CURSOR IF THE KEY IS PART OF THE ORDER BY CLAUSE.
JR14610WHEN TRYING TO ALTER A TRIGGER FROM WITHIN THE CONTROL CENTER THE TRIGGER STATEMENT IS GREYED AND CANNOT BE SELECTED FOR COPY.
JR14868FFFFA602 AT DB2GOV START GOVERNOR
JR15150ADO/DB2-SEMAPHORE LEAK CAUSES HANDLE COUNT INCREASE.
JR15310SQLGETINFO(SQL_EXPRESSIONS_IN_ORDERBY) RETURNS 'Y' AGAINST MVS - SHOULD BE 'N'
JR15369SQLTABLES RETURN NO_DATA_FOUND OR CLI0118E BECAUSE OF EXTRA DOUBLE QUOTES IN TABLETYPE SETTING IN DB2CLI.INI FILE.
JR15435NOT POSSIBLE TO NOT ENTER SIGN '-' (-1) FOR BP SIZE FROM THE CC
JR15528'BAD' RANGE OF SORTHEAP SIZE(>1014 AND < 1038) IN THE OPTIMIZER
JR15574SQL0502 WITH SQLMATHWARN=ON
JR15581DB2 TRAPS AT TRACE FUNCTION WHEN BAD DATA IN BUFFER IS LOGGED TO DB2DIAG.LOG DURING INSTANCE CRASH (REFER DEFECT 136377)
JR15585DB2HISTORY* APIS MAY TRAP IF UNINITIALIZED DATA PASSED IN.
JR15599CALLING SP WITH INOUT DECIMAL ON AN MVS SYSTEM CAUSES SQL0304
JR15606MTS APPLICATION FAILS TO RECONNECT AFTER RECYCLING DB2
JR15631DB2 CONNECT SHOULD NOT ATTEMPT TO CONVERT GRAPHIC COLUMNS FROM DOUBLE-BYTE CODEPAGE TO SINGLE-BYTE CODEPAGE. SHOULD ERROR.
JR15640THE CONTROL CENTER FAILS WITH ERROR SQL0104N WHEN ATTEMPTING TO DISPLAY INDEX NAMES USING THE TURKISH LOCALE
JR15655-443 ERROR ON SIEBEL UDF AFTER UPGRADE FROM FP5 TO FP6ON NT SQLERRMC: SIEBEL.NEXTSEQ NEXTSEQ UNABLE TO ACCESS SEGMENT
JR15661TRAP IN BSORTGETNEXTPARTIALKEY ON NT
JR15671AMBIGUOUS REFERENCE COLUMN (SQL0203) WHEN QUERYING MVS LEADS TO DR. WATSON TRAP
JR15704SQLM_STMT_START AND SQLM_STMT_END (FFFFFFFF) ARE LOGGED IN THE DB2DIAG.LOG
JR15712SNAPSHOT OUTPUT SHOWS 'MAXIMUM ASSOCIATED AGENTS = 0' AND 'AGENTS ASSOCIATED WITH APPLICATION = 1' WHICH IS INCORRECT
JR15728CC/ITALIAN DIDN'T DISPLAY ',' SEPARATOR VIA SAMPLING A TABLE.
JR15737PATCH2=29 CAUSES PROBLEM WITH CONVERSION IN A 0 PRECISION DECIMAL TO DOUBLE CONVERSION.
JR15750DB2EVA CAUSED AN INVALID PAGE FAULT IN MODULE DB2ADMIN.DLL
JR15756INSTANCE TRAP IN SQM_EVMON_OSTREAM::WRITE_DATA
JR15769CREATING EVENT MONITOR ON 'DATABASE A ALIAS A1' USING EVENT MONITOR GIVES DBA5500.
JR15785TRAP IN JDBC IF RESULTSETMETADATA IS USED WHEN CONNECTION CLOSED
JR15799PROBLEM WITH FOREIGN KEYS AND SET NULL CONSTRAINTS
JR15904DR.WATSON IN DB2CLI.DLL WITH JDBC APP CALLING STORED PROCEDURES
JR15905SQLMORERESULTS() DOES NOT HANDLE ERRORS FROM BATCHED COMMANDS
JR15906CCA IS PUTTING THE KEYWORD 'MULTICONNECT' KEYWORD UNDER THE DSN ENTRY OF THE DB2CLI.INI FILES - SHOULD GO UNDER COMMON SECTION.
JR15907-805 CAUSED BY CURRENT PACKAGE SET IS NOT RESET
JR15908INSERTING A NULL VALUE INTO A BLOB COLUMN, WE GET THE SQL0301N
JR15909HOSTNAMES > 8 CHARS DISPLAY INCORRECTLY IN SQL GENERATED BY CC
JR15910CONNECT TYPE 2 APPLICATION THAT CALLS A STORED PROC TRAPSIN SQLE_DBM_DARI - APPLICATION RECEIVING SQL1327
JR15911DB2 FOR OS/390 CANNOT MAKE TYPE 2 CONNECTION TO UDB WHEN SPM ENABLED
JR15912CURRENTSQLID NOT USED UNDER MTS TRANSACTION ENVIRONMENT.
JR15913SQLDESCRIBEPARAM CALL TO HOST RETURNING SQL0236
JR15914DESCRIBED COLUMN NAMES ARE INCORRECT AFTER SWITCHING CURSOR TYPE IN JAVA OR CLI APPLICATION.
JR15915SQL2650 WHEN TRYING TO TAKE ONLINE BACKUP. AFTER APPLYING FIX FOR IY15913, GET ERRORS IN SQLPALR_READPAGESDISK PROBE 158
JR15916TIMING PROBLEM. TWO THREADS ACCESSING SAME MEMORY AREA WHEN NET WORK CABLE IS PULLED.
JR15917LOAD FROM CONTROL CENTER PRODUCES INVALID NULL INDICATOR CLAUSE
JR15919THREAD CRASHES IN 'COPY TABLE' DIALOG BOX, RENDERING IT USELESS
JR15922ALERT CENTER DOESN'T INVOKE WHEN THRESHOLD IS REACHED
JR15923TRAP IN SQLCSPC_COOR_REG.
JR15927SIG 11 IN SQLOXULT THROUGH SQLRA_CACHE_SPACE_MGMT
JR15928ALTER COLUMN WITH CONSTRAINT ADDITIONCLAUSE SHUTS DOWN ENGINE
APAR fixes included in WR21237 (Fixpak 7)
APARABSTRACT
GG04021CAPTURE CRASHED WITH APPLICATION ERROR: THE MEMORY COULD NOT BE 'READ'
GG04044APPLY CONNECT TO THE SOURCE FOR UPDATING PRUNCNTL.SYNCHPOINT BUT IF NO CAPTURE IS RUNNING - NO SQL PROCESSED - DSNL500I MESSAGE
IY10950UNDERSCORES IN TABLE ALIAS CAUSE MS JET ENGINE ERROR WHEN LINKIN G TABLES.
IY12035SIGNAL 11 TRAP IN SQLRI_RESTORE_SPEC_REG_INFO()
IY12393INSTALLER SHOULD SET DB2CCMSRV TO A VALUE DIFFERENT FROM 523
IY13019TRAP (SIG 11) IN SQLNO_UNION_SETSN
IY13147COST OF THE QUERY INCREASES AS THE BUFFER POOL COUNT INCREASES. DB2EXFMT COST GROW AS THE BUFFERPOOL GETS INCREASED.
IY13393IMPORT DOES NOT USE CURRENT SCHEMA CORRECTLY
IY13410IMPROPER HANDLING OF LOGS WITH RAW DEVICE AS ACTIVE LOG PATH. GET SQL4970N WHEN ISSUING A ROLL FORWARD.
IY13468DEFECT IN CLI IN REGARDS TO HOW WE DETERMINE THE CTX USED AT THE ENVIRONMENT LEVEL.
IY13598SQL1627W WHEN RUN DB2 GET MONITOR SWITCHES AFTER UPDATING THEM FROM A 7.1 CLIENT.
IY13655ADD NEW DB2LOOK SCHEMA OPTION REMOVED BY DEFECT 153542
IY13696SQL1273N ON ROLLFORWARD DATABASE (MISSING LOG FILE S0000000.LOG)
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.
IY13751STP.SQLJ STORED PROCEDURE SAMPLE, DOES NOT CONTAIN CODE FOR CLEA N UP.
IY13807DLFMUPDT FAILED WITH DBI1282. BACKUP_INSTINFO() IN DB2IUTIL DOES N'T CONSIDER TO BACKUP DBM CFG FOR DLFMUPDT COMMAND.
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
IY13893ADD SUPPORT FOR THE COLUMN NAME UNDER MINMEM MODE FOR JDBC
IY13970CCA TRUNCATES HOSTNAME TO FIRST PART OF FOUR PART NAME
IY13979-805, -818 SQLCODE RECEIVED FROM MULTITHREADED SQLJ APP IN A UNIX ENVIRONMENT.
IY13995SQLFETCH() FAILS WITH -501 ERROR WHEN MINMEMUSAGE=1
IY14000SQL0723 MESSAGE TOKENS INCORRECT
IY14016PATH TO DSM.SYS AND DSM.OPT WHEN USEREXIT ENABLED
IY14030ROLLFORWARD COMPLAINS 'LIFELSN MISMATCH FOR REORG-REDO
IY14038DB2 UDB - IN CERTAIN SCENARIOS IF AN AGENT FAILS WITH ANSQL1040 (MAXAPPLS REACHED) ERROR, THE DATABASE WILL CRASH WITH SQL1042.
IY14053DB2 UDB - DATABASE CRASHES WITH A SIGNAL 11 TRAP IN FUNCTION SQLRX_LIKE WHEN THE SET EVENT MONITOR STATEMENT IS EXECUTED.
IY14117UNEXPECTED SIGALRM RECEIVED BY DB2UDF BRINGS DOWN DB2
IY14198POOR PERFORMANCE WHERE TWO PREDICATES ON COLUMNS IN THE SAME TABLE TEST FOR EQUALITY WITH IDENTICAL CONSTANTS
IY14209DB2LOOK -L FAIL TO RETURN CONTAINER INFO WHEN RAN AS SYSCTRL ID.
IY14234DB2LOOK FAILS WITH TABLENAMES CONTAINING SLASHES
IY14240TO BETTER EXPLAIN COMPILER OPTIONS FOR DB2UEXT2.CADSM SAMPLE PRO GRAM
IY14242CLI API SQLCOLUMNS FAILS WITH SQL0198N ERROR WHEN ISSUED AGAINST A NEW DATABASE BEFORE BINDING THE CLI BIND FILES.
IY14298CUSTOMER SELECTS, IN JOURNAL, A COMPLETED SPECIFIC JOB TO DISPLA Y AND THE DB2DAS00 GOES DOWN.
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
IY14346RESTART FAILS AFTER DB CRASHES BEFORE LOG WRITTEN BUT AFTER DB MARK INCONSISTENT
IY14353DB2 GIVES INCORRECT ANSWERS, TERMINATE DB CONNECTION FROM CLP OR HANG WHEN QUERIES ARE RUN FROM COMMAND CENTER.
IY14370DUPLICATE KEY CREATED DURING REORG
IY14500DLFM GOES DOWN FROM LOCK TMEOUT WITHIN GARBAGE COLLECTOR DAEMON
IY14515SIG 11 IN SQLPTRSP WHEN BUFFER MANIPULATOR RUNS OUT OF LOG SPACE
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.
IY14770SIGNAL 11 IN SQLVDIVIDE
IY14775CREATE TABLE LOOPS AND USES ALL OF THE LOG SPACE
IY14820ERROR DURING ALLOCATION OF LOG FILE CAUSES DATABASE TO SHUTDOWN
IY14849SQL0901N SYSTEM ERROR WITH REASON: UNRESOLVED QNC
IY14901SQLFREECONNECT/SQLFREEHANDLE RELEASES THE CONNECTION LATCH
IY14989INSTANCE CRASH ON ROLLFORWARD: SIGNAL 11 IN SQLPRFWD__FP7SQLEACB8SQLP_LSNUL
IY15085USEREXIT STOPS TO BE CALLED WITH FFFFA602 FROM SQLPGART MESSAGE
IY15091AUTOLOAD FAILS WITH SIGNAL 4 BECAUSE THE MEMORY ALLOCATION FOR THREADS ARE NOT ENOUGH.
IY15121GET SNAPSHOT FOR ALL DCS DB GIVES INCORRECT OUTPUT
IY15123PARSING OF COUNT (EXPRESSION) FAILS WITH COMPLEX EXPRESSIONS
IY15135KEY NOT FOUND ERROR (FFFF F92C) ON AN INDEX IN A 32K PAGE TBSP.
IY15152FAILED 'BACKUP DB <DBALIAS> ... ADSM ...' ARE NOT BEING CLEANED IN ADSM CAUSING 'DB2ADUTL' TO RETURN EXTRANEOUS RESULTS
IY15189USER WITH ONLY SELECT PRIVILEGES ON A VIEW IS ABLE TO UPDATE THE TABLE USING A CURSOR UPDATE ON THE ALIAS OF THE VIEW.
IY15201TABLESPACE ROLLFORWARD UNDO PHASE READS FROM DISK FOR EVERY LOG RECORD
IY15209SQL_INVALID_HANDLE ERROR IS RECEIVED WHEN SQLTABLES IS CALLED BEFORE SQLCOLUMNS.
IY15250AIX ONLY: DB2MEMDISCLAIM CAN CAUSE SORTHEAP ALLOCATION ERRORS, TRAPS, DEFUNCT DB2AGENTS DUE TO LEAKING VIRTUAL MEMORY.
IY15287DB2 MEMORY LEAK FOR UDF WITH CLOB PARAMETER WHERE UDF RETURNS AN ERROR
IY15289WRONG OR DIFFERENT RESULTS RETURNED BY SELECT ON VIEWS V7.1 ONLY
IY15290SQL0901 RETURN - SECTION NOT CLOSED.
IY15367USING SETASCIISTREAM METHOD IN JAVA IS ALWAYS TRANSLATING TO SQL_CLOB.
IY15421SUBSEQUENT PARAMETER BINDINGS FOR VARCHAR WITH JDBC ARE NOT HAVING THEIR COLDEF LENGTHS UPDATED CAUSING CLI0109E
IY15423ERRNO:0000 0009 DUMPED IN LOG DURING A SUCCESSFULL BACKUP. THIS APPEARED AFTER APPLYING FP6
IY15428-10752 AS SQLCODE IN SQLCA ON BACKUP -> BACKUP EXISTS/VALID, BUT UPDATING HISTORY FILE WAS NOT, REPORTED AS FAILURE
IY15448CLI LAYER NOT RECOGNIZING 'I'(INCLUDE) RETURN FOR DT_SRCE_BEG IN SQLGETDATA.
IY15592WHERE CLAUSE RETURNS A WRONG OUTPUT IN FP6. (1=1 OR 1=2) AND (1= 1 OR (1=2 AND 2=2)) RETURNS FALSE.
IY15629INCORRECT FILE SIZE ESTIMATES FOR BACKUP TO ADSM/TSM
IY15676MULTITHREADING ENVIRONMENT CAUSES FORKED CHILD TO BE SPUN OFF IN TO MUTEX.
IY15691AFTER OS390 IS RECYCLED, CONNECTIONS TO IT RECEIVE SQL0902 UNTIL OF THE OLD CONNECTIONS IN THE CONNECTION POOL HAVE BEEN FAILED.
IY15777DB2 PANIC/SLEEP IN SQLDINVCURSORPOS
IY15798DB2DATASOURCE NOT HANDLING CONNECTIONS PROPERLY
IY15827PERFORMANCE WIZARD FROM CONTROL CENTER RECEIVES DBA1107 WHEN NLS AIX SERVER IS USED.
IY15829SIGNAL 11 IN SQLDADJUSTSEQDETPFAMOUNT
IY15861USEREXIT FAILED, BECAUSE DATABASE ACTIVATED AFTER OFFLINE BACKUP
IY15881SQL2032, RC=14 DURING RESTORING FROM ADSM. THE APPROPRIATE ERROR MESSAGE SHOULD BE SQL2033, RC=14.
IY15913CAPTURE FAILS - SQL2038 RC 32
IY15931HASH_JOIN MEMORY ALLOCATION PROBLEM WHICH MARKS DB BAD.
IY16012GETDATE() RETURNS DIFFERENT VALUES IN APP VS NET
IY16054SIGNAL#11 IN SQLE_CHECK_EARLY_FETCH
IY16241TCP/IP PACKET SIZE IS 512 BYTES OF PAYLOAD- PERFORMANCE IMPACT
IY16243SIGNAL#11 IN SQLIFNXT
IY16383MISALIGNED DATA IN DB2 CAUSES HP TO TRAP
IY16457SIGNAL 11 IN SQLM_A_INIT
IY16933TABLESPACE RECOVERY FAILS/HANGS DURING FIRST ROLLFORWARD.
JR14218EVENT ANALYZER DOES NOT DISPLAY DYNAMIC SQL TEXT.
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
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.
JR14807DR. WATSON WHEN ISSUING DB2 FORCE APPLICATION ALL AGAINST DRDA-2 CONNECTIONS.
JR14990OUTPUT PARAMETERS NOT INITIALIZED TO NULL
JR15084SIGNAL #11 IN SQLNQ_MEMMGR::DESTROY. THIS APAR WILL FORCE A -901 TRACEBACK TO GATHER MORE INFO ON NEXT OCCURRANCE.
JR15136EXPORT TO LARGE IXF FROM V6 CLIENT TO V5.2 SERVER RESULTS IN MISSING ROWS
JR15146UTILITY TO SET THE PROPER UID/PWD CREDENTIALS FOR SATELLITEID IN THE SATADMIN.AUT FILE USING ORIGINAL SATELLITEID AS INPUT
JR15159EXCEPT ALL IN SQL STATEMENT RETURNS SQL0415 WITH SQLSTATE 42825. AND/OR INCORRECT RESULTS DURING SQL EXECUTION.
JR15180INCONSISTENT RESULTS WITH SNAPSHOT MONITOR ELEMENT APPL_ID_OLDEST_XACT
JR15200USE OF {?=CALL SPNAME(?)} SYNTAX MAY RESULT IN CLI0102 INVALID CONVERSION ERRORS
JR15207QUERY EXCEEDS SORTLIMIT AFTER INCREASE IN COLUMN NAME SIZE
JR15212CONNECTION.GETCATALOG() RETURNS AN EMPTY STRING INSTEAD OF NULL
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
JR15228TRAP IN SQLJIDRD WHEN SQL_DISCONNECT_ABNORMAL RETURNED
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
JR15262STATUS CHANGE TIME INCORRECTLY DISPLAYED IN CC
JR15272LARGE TRAP FILE WHEN FREEING INVALID MEMORY BLOCK (SQLOFMBLKEX)
JR15285GETTING AN ERROR PROGRAMMING THE XA_SWITCH.
JR15290ABEND IN DB2SYNCHSATTELITE* APIS IF CALLED WITHIN A .DLL
JR15307'DB2TASDM.DLL' IS NOT IN THE VERSION OS/2 6.1FP5/6 INSTALL. THIS IS REQUIRED FOR 'DB2 BACKUP ... ADSM ...'
JR15308SELECT WITH DISTINCT CLAUSE RETURNS INCORRECT RESULT. DUPLICATE ROWS RETURNED.
JR15311SQLNUMRESULTCOLS CALLED PRIOR TO SQLEXECUTE IN PREPAREDSTATEMENT OBJECT.
JR15318TRAP DURING COMPARE DATE STRING AND AN EMPTY VARCHAR STRING
JR15352SQLPRIMARYKEYS COULD RETURN NO KEYS IF SCHEMA IS NOT SPECIFIED AND USER LOGS IN WITH LOWERCASE USERID.
JR15356LIST RECOVERY HISTORY FAILS FROM COMMAND CENTER OR JOURNAL
JR15360TRAP IN SQLNO_FF_COMPUTE_LIKEPRD RUNNING QUERY USING PARAMETER MARKERS OR HOST VARIABLES.
JR15362WE REQUIRE 2ND TOKEN FROM OS/390 IN -440 ERROR RETURN
JR15363SQL1224N & TRAP IN SQLR_CREATE_TABLE_DDL DURING DROP VIEW/TABLE
JR15408DB2 STOP FORCE FROM CC HANGS AND GENERATES A TRAP
JR15415WHEN DEFERREDPREPARE=0 CLI0150E ERROR DRIVER NOT CAPABLE IS RETU RNED
JR15416PROBLEM WITH REDIRECTED RESTORE IN THE CONTROL CENTER.
JR15425LOAD WITH MODIFIED BY USEDEFAULTS CLAUSE CAUSES NULL FIELDS TO BE INCORRECTLY POPULATED WITH DATA.
JR15428MEMORY LEAK IN SEQUENCE: BEGIN CONTEXT, CONNECT TO DATABASE, DISCONNECT FROM DATABASE, END CONTEXT.
JR15466DATABASE COMES DOWN OR HANGS. TRAP FILE IS CREATED INDICATING EXCEPTION C0000005 IN FUNCTION SQLRR_DUMP_SECTION.
JR15517SQLUVINT() API STRUCTURE DB2_INFO FIELDS, VERSION RELEASE LEVEL AND OBJ_LIST FIELDS ERRONEOUSLY SET NULL
JR15530DATA INSERTED INTO LONG VARCHAR USING 'FOR BIT' COLUMN NO LONGER WORKING AT FP 2.
JR15537CODEPAGE 65535 PROBLEM PASSED BY MVS TO CLI (PADDING OCCURS IN OUTPUT) - NEEDS TO BE RECOGNIZED AS A VALID 4 BIT DATA CODEPAGE
JR15539CREATE TABLE LIKE AND CREATE VIEW SPORADICALLY FAILS WITH SQL0901 'WRONG HIERARCHY PACKED DESCRIPTOR'
APAR fixes included in WR21222 (Fixpak 6)
APARABSTRACT
GG03862EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1
GG03928SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY.
GG03960APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER
GG04111DIAGNOSTIC ENHANCEMENTS FOR APPLY
GG04129APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
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
GG04135INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT
GG04136INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT
GG04138CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS
GG04139CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS
GG04140SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY
GG04142APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER
GG04144DIAGNOSITC ENHANCEMENTS FOR APPLY
GG04146APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
GG04147APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
GG04148EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1
GG04150APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH
GG04151APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH
GG04152APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY
GG04153APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY
GG04154SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE
GG04155SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE
GG04156SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE
GG04157SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE
GG04158VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR
GG04159VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR
GG04160APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG
GG04161APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG
IY03296SQL2154 ON ATTEMPTED TABLESPACE RESTORE.
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
IY12218APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH
IY12275CLI CONVERSION FROM CHARACTER TO NUMERIC TYPES MAY CAUSE SIGSEGV IF INVALID CHARS USED
IY12396POSSTR DOES NOT WORK WITH GROUP BY (SQL0119)
IY12664FILE SHARING VIOLATION ON SUN
IY12726DROPPING AN UNAVAILABLE TABLE ENDS WITH DIA3806C UNEXPECTED END OF FILE
IY12821ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY13012THE CUSTOMER UPGRADED TO FP4D FROM FP4 TO ADDRESS APAR IY09469. NOW THE CUSTOMER IS EXPERIENCING CLI0120E.
IY13020DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
IY13054MISLEADING ERROR REPORTING ( -901) FOR WRONG SCRIPT TRYING TO LINK UDF.
IY13107DB2 UDB - INDEX CORRUPTION PROBLEM CAUSES MISORDERING OF KEYS
IY13331AFTER MIGRATION TO A NEW RELEASE, CAPTURE CANNOT WARM START
IY13402COPY_DAEMON ON DLFM SHOULD NOT COPY GARBAGE FILES (I.E. FILES TH AT GET LINKED AND UNLINKED WITHIN THE SAME TRANSACTION.)
IY13410IMPROPER HANDLING OF LOGS WITH RAW DEVICE AS ACTIVE LOG PATH. GET SQL4970N WHEN ISSUING A ROLL FORWARD.
IY13473BAD ACCESS PLAN CAN OCCUR IN EEE WITH DISTRIBUTION STATS
IY13476CRASH RECOVERY HANGS DURING UNDO PHASE IN INDEX MANAGER
IY13617CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND L ONG VARCHAR COLUMNS
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
IY13774LOAD FAILURE (BUILD PHASE) MIGHT CAUSE SMP CORRUPTION
IY13802CONTROL CENTER DOES NOT ALLOW DEFINING A REPLICATION SUBSCRIPTION ON A VIEW REPLICATION SOURCE.
IY13808SIGNAL 11 TRAP IN SQLRR_DUMP_SECTION() DURING ERROR PROCESSING
IY13841APP. CURRENT CONNECTION CHANGED WHEN USING XA COMPLIANT TRANSACT -ION MANAGER WITH DB2
IY13951MINMEMUSAGE KEYWORD CAUSES INCORRECT SQL_DBMS_NAME OUTPUT IN SQLGETINFO()
IY13968BAAN APPLICATION MAY EXPERIENCE -302
IY14081ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY14082ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
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
IY14123CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS
IY14125CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS
IY14126CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS
IY14127INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT
IY14128INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT
IY14129INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT
IY14130INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT
IY14145SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY
IY14146SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY
IY14147SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY
IY14148SYNPOINT IN REGISTER TABLE IS UPDATING INCORRECTLY
IY14149APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER
IY14150APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER
IY14151APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER
IY14153APPLY SHOULD STOP WHEN IT ENCOUNTERS AN SQL -551 ON THE CONTROL SERVER
IY14155DIAGNOSITC ENHANCEMENTS FOR APPLY
IY14156DIAGNOSITC ENHANCEMENTS FOR APPLY
IY14158DIAGNOSITC ENHANCEMENTS FOR APPLY
IY14159DIAGNOSITC ENHANCEMENTS FOR APPLY
IY14160APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
IY14161APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
IY14162APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
IY14163APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
IY14165EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1
IY14166EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1
IY14167EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1
IY14168EVENT DRIVEN SUBSCRIPTION FAILS & SETS THE SUBS_SET STATUS TO -1
IY14170APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH
IY14171APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH
IY14172APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH
IY14173APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY
IY14174APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY
IY14175APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY
IY14176APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY
IY14177SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE
IY14178SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE
IY14179SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE
IY14180SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE
IY14182SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE
IY14183SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE
IY14184SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE
IY14185SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE
IY14186VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR
IY14187VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR
IY14188VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR
IY14189VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR
IY14190APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG
IY14191APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG
IY14192APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG
IY14193APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG
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
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.
JR15158DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE
JR15210-902 ON A DESCRIBE OR PREPARE
PQ38000APPLY DOES NOT PROCESS CHANGE DATA CORRECTLY
PQ39542SQLCODE333 INCORRECT TRANSLATION OF SYNCHPOINT COLUMN TO ALL ZEROS IN PRUNE CONTROL TABLE
PQ40301SQLCODE305 WITH FULL REFRESH SUBSCRIPTION -- NULL VALUE WITHOUT NULL INDICATOR VARIABLE ON REGISTER TABLE
PQ40392VERY LARGE SPILL FILES AND UNEXPECTED RESULTS WHEN SUBSCRIPTION MEMBER HAS A PREDICATE WITH OR
PQ41610APPLY PRODUCING DSNL500I MESSAGES INTO THE DP41MSTR ADDRESS SPACE JOBLOG
PQ41936INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT
APAR fixes included in WR21201b (Fixpak 5b)
APARABSTRACT
IY09961QUERY REWRITE DOESN'T PUSH DOWN PREDICATE INTO COMMON SUBESPRESS ION
IY11081DATABASE GETS MARKED AS BAD AFTER FCM ERRORS FFFFFC7F IN DB2DIAG.LOG FILE. EVENT MONITOR RESOURCE COULD NOT BE OBTAINED.
IY11648MISLEADING ERROR MESSAGE IN DB2DIAG.LOG FOR QUIESCE RESET FOR A TABLE FROM A NODE WHERE THE TABLE WAS NOT DEFINED.
IY12165CLI LAYER APPENDS EXTRA SET OF DOUBLE QUOTES TO SCHEMALIST WHEN RUNNING MS ACCESS CAUSING SQL0312N IN FP4B AND SQL0206N IN FP4E.
IY12299DB2ADUTL TO RECOGNIZE ALL TYPES OF FS_TYPE AT QUERY FOR BACKUP I MAGES
IY12642LOAD DOES NOT CHECK PARTITIONING KEY FOR EXCEPTION TABLE
IY13027A BUG IN 'DLFM RETRIEVE' TOOL, WHEN THE ARCHIVE SERVER IS ADSM. FILES EXIST IN THE ADSM SERVER BUT REPORT AS E2 (INSTEAD OF E1)
IY13171DATABASE MIGRATION FROM V5 TO V6 FAILS WITH SQL0025W
IY13252DB2DCLGN COMMAND WITH A DECIMAL RESULT IN INCORRECT OUTPUT.
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
IY13466SQL0198N - DESCRIBING STORED PROCEDURES WITH LONG NAMES
JR15008SQLCONNECT FAILS WITH MEMORY CORRUPTION ERROR
JR15014DEFER CONVERSION OF IN SUBQUERY TO JOIN AFTER SUBQUERY PUSHDOWN THROUGH THE OUTER JOIN.
JR15025DR.WATSON IN DB2SYS.DLL WHEN LOGING OFF NT (MTS AND DTC)
JR15046RETURN UNRETREIVED ERROR MESSAGE FROM SQLDESCRIBEPARAM IN JDBC
APAR fixes included in WR21201a (Fixpak 5a)
APARABSTRACT
IC27213WRONG TIMESTAMP ON SNAPSHOT OUTPUT FOR DB2 EE 6.1 UNDER LINUX
IY06938IN AN MTS ENVIRONMENT ON A CONNECTION FAILURE WE SHOULD NOT BE RETURNING SQL30090 RC=6
IY10484LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973.
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY11218INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES
IY11353SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM
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.
IY11819SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER.
IY11865SQL0902N ON STARTING PIPE EVENT MONITOR
IY11908DB2 CALLS USER EXIT WITH THE WRONG GID
IY11932QUERY PATROLLER DOES NOT WORK PROPERLY WHEN LANGUAGE WAS SELECTE D LANG=US_ENG.
IY11945APPLICATION PROCESS MAY CORE DUMP IF NO MORE MEMORY CAN BE ALLOCATED TO PROCESS.
IY11990ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC.
IY12050SQL2741N WHEN LOADING DATA AND SPECIFYING IMPLIEDDECIMAL AND PACKEDDECIMAL MODIFIERS
IY12273LIST DCS APPLICATIONS SHOW CONNECTIONS THAT HAD BEEN CANCELLED
IY12419BACKUP OF DATABASE CONTAINING DATALINK COLUMNS FAILS WITH SQL2424N, YET COPY DAEMON SUCCESSFULLY BACKED UP FILES.
IY12536MONITOR STATE DOES NOT RESET APPLICATION STATE ONCE COMPLETED
IY12545SQL0104N RETURNED WHEN RUNNING DB2BATCH IN CLI MODE. HOWEVER, RE SULT SET IS STILL CORRECT.
IY12725DB2 UDB - CREATE INDEX CAUSING DATABASE TO COME DOWN. THE DB2DIAG.LOG FILE INDICATES THAT AN OBJECT ID IS ALREADY IN USE.
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 INSTA NCE OWNER.
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
IY13014SIGNAL #4 #11 USING HOP DRIVER
IY13019TRAP (SIG 11) IN SQLNO_UNION_SETSN
IY13033GOV1027 WHEN INTERVAL ABOVE 300 SECONDS
JR14390AFTER BACKUP TO THE DISK IN ZIP DRIVE THROUGH CONTROL CENTER,DB2 DOESN'T RELEASE FILE HANDLER OF ZIP DRIVE
JR14749SQL0291 TRYING TO ACCESS TEMPORARY TABLESPACE WHEN THERE ARE TEMP TABLEPSACES OF DIFFERENT PAGESIZES:'NO TEMP AVAILABLE'
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.
JR14860JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN
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.
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
JR14996CONNECTION ATTEMPT TO DB2 V7.1 VIA MS EXCEL RESULTS IN CLI0104E
APAR fixes included in WR21201 (Fixpak 5)
APARABSTRACT
GG03736ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS.
GG03752CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH
GG04079OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS
GG04084CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH
GG04085OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS
GG04086SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL.
GG04087SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL.
GG04088TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094
GG04089TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094
GG04091UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE
GG04092UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE
GG04093ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES
GG04094ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES
GG04095SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS
GG04096SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS
GG04097CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
GG04098CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
GG04099ASNAPPLY FAILS WITH CORE
GG04101CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR
GG04102CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR
GG04103DURING CAPTURE PROCESSING THE ASNPATH SYSTEM VARIABLE IS BEING MISREAD
GG04104CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE
GG04105CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE
GG04106CANNOT STOP CAPTURE WITH ASNCMD STOP COMMAND.
GG04109CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
GG04112ASNAPPLY FAILS WITH CORE
GG04114ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS.
GG04115ASNAPPLY FAILS WITH CORE
GG04116CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
GG04118CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
GG04119CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
GG04120CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
GG04122CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
GG04123CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
GG04124CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
GG04126CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
GG04127CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
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
IY09645CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY09646UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE
IY10382ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES
IY10484LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973.
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY10644SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS
IY10869CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH
IY10870CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH
IY10871CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH
IY10872CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH (Linux).
IY10873OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS
IY10874OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS
IY10875OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS (Linux).
IY10876OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS
IY10945SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL.
IY10946SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL.
IY10947SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL (Linux).
IY10948SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL.
IY10955CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY11011TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094
IY11013TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094
IY11014TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094 (Linux).
IY11015TWO CAPTURES RUNNING AT THE SAME TIME FOR THE SAME SOURCE DATABASE ON A DB2 UDB FOR AIX BOX - DEFECT 1094
IY11016UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE
IY11017UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE (Linux).
IY11018UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE
IY11019ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES
IY11020ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES (Linux).
IY11021ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES
IY11022SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS
IY11023SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS (Linux).
IY11024SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS
IY11025CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY11027CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY (Linux).
IY11028CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
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.
IY11136NO TEMP AVAILABLE ERROR IN DB2DIAG.LOG DURING ON-LINE BACKUP. SQLB_BACKUP_IN_PROGRESS ON TEMPTABLESPACE FOR A SHORT PERIOD.
IY11161FAILURE TO FIND A LOCK WITHIN LOCK TABLE, SQLPLUPDATETRANENTRY REPORTS FFFFF51D AT PROBE POINT 5
IY11218INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES
IY11267QUERY_HEAP TOO SMALL MAY CAUSE -1131 ON CALL TO STORED PROCEDURE
IY11323CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR
IY11324CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR
IY11325CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR (Linux).
IY11326CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR
IY11327CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE
IY11328CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE
IY11329CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE (Linux).
IY11330CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE
IY11353SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM
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.
IY11527DB2 UDB - SQL0901 ERROR WITH MESSAGE 'NON-PIPED PARALLEL SORT ATTEMPTED' IN DB2DIAG.LOG.
IY11595ALLOW DB2 INTERNAL ROLLBACK IN STORED PROCEDURE AFTER DEADLOCK
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.
IY11901TRAP IN SQLNO_PROJECT_QUN WHEN RUNNING A QUERY
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)'
IY12042CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12068MULTIPLE CONCURRENT IMPORT COMMANDS FOR DIFFERENT TABLE GIVES SQL3188N.
IY12125OWNER OPTION ON BIND MAY CAUSE INCORRECT AUTHS TO BE USED
IY12126TABLESPACES OF 18 CHAR LENGTH NAMES MIGHT NOT BE BACKED UP
IY12168INSTANCE MIGRATION FAILS FROM V5.X TO V6.1
IY12271DB2CKMIG.BND COULD NOT BE OPEND AT DB2CKMIG COMMAND
IY12349CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
IY12416-901 DUE TO INCORRECTLY SORTED INPUT STREAM OR INCORRECT ORDER BY QUERY RESULTS, MISORDERED KEYS IN INDEX LEAD TO DB MARKED BAD
IY12513ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS.
IY12514ASNAPPLY FAILS WITH CORE
IY12515ASNAPPLY FAILS WITH CORE
IY12516ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS.
IY12517ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS (linux).
IY12518ASNAPPLY FAILS WITH CORE (Linux).
IY12520ASNAPPLY FAILS WITH CORE
IY12521ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS.
IY12554CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
IY12555CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATE WITH NO CHANGES (Linux).
IY12558CAPTURE CORE DUMPS WHEN LONG VARCHAR ROWS UPDATED WITH NO CHANGE S.
IY12559CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY12560CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (Linux).
IY12561CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY12562CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY12563CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY12564CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS (Linux).
IY12565CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
IY12566CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12567CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED
IY12568CAPTURE CORE DUMPS WHEN DB2 IS NOT STARTED (Linux).
IY12569CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY12570CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY12571CAPTURE DOES NOT HANDLE LARGE TABLE ID (Linux).
IY12572CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY12599DB2 UDB - LOAD AGENTS CANNOT BE FORCED OFF AFTER LOAD IS TERMINATED. SEE ALSO APAR IY04375 FOR DETAILS.
IY12609DB2 UDB - SQL1042 ERROR WHEN MAXAGENTS LIMIT HAS BEEN REACHED AND DB2 REQUIRES AN ADDITIONAL AGENT.
JR13927IMPLEMENT NEW BIDI LAYOUT TRANSFORMATION ROUTINE WITH MORE STRIN GENT ERROR CHECKING, MEMORY ALLOC, AND BIDI CCSID STRING TYPES.
JR14166NODE DIRECTORY MIGRATION FAILS FROM V5 TO V6.1
JR14791SQLEXTENDEDFETCH - FETCH PRIOR - FAILS TO RETRIEVE ROW IN 1 ROW RESULT SET FOR A STATIC SCROLLABLE READ-ONLY SERVER-SIDE CURSOR.
JR14809NEED SUPPORT FOR BLOB COLUMNS WHEN GOING AGAINST DB2 V2 SERVER F OR DATAJOINER.
JR14811SQL0104 GENERATED WHEN ISSUING A VALID ROLLBACK COMMAND FROM THE CLP
JR14815DB2JDBC.DLL TRAPS WHEN ISSUING AN EXECUTEQUERY() ON A STATEMENT ALREADY CLOSED.
JR14844USERS WHICH BELONG TO THE SYSADM_GROUP DEFINED IN THE DBM CFG CA NNOT ISSUE A DB2STOP, WHETHER DOMAIN OR LOCAL USERS
JR14860JDBC2.0 DRIVER FAILS WITH A CLASSCASTEXCEPTION WHEN USING SETUNICODESTREAM METHOD TO INSERT INTO A CLOB COLUMN
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 WR21187e (Fixpak 4e)
APARABSTRACT
IY10009CONTROL CENTER(FOR V6) FREEZES WHEN CHANGE BUTTON FOR DB GROUPS UNDER USER AND GROUP OBJECTS IS CHOSEN
IY10803LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N.
IY11116DB2ATLD HANGS WHEN THE FILE_TRANSFER_CMDFAILS WITH A NON-ZERO R ETURN CODE.
IY11126THE EVENT MONITOR'S TRANACTION EVENT OUTPUT HAS A LOCK WAIT TIME GREATER THAN THE ELAPSED TIME FROM THE START AND STOP TIMESTAMPS
IY11218INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES
IY11353SUPPORT SETOBJECT METHOD FOR JDBC & DON'T ISSUE SQLDESCRIBEPARAM
IY11377DB2 UDB - SQL0901 ERROR IN FUNCTION SQLNO_RESOLVE_QNC.
IY11466DEADLOCK CAUSED BY NEXT KEY LOCKING IN CATALOGS
IY11600RESULTSET.GETBINARYSTREAM() METHOD MAY USE BYTEWISE RETRIEVAL TO GET LOB DATA - PERFORMANCE DEGRADATION.
IY11717INSTANCE CRASH IN SQLM_GENERIC_CONVERT.
IY11766ALTER TABLE REFERENCES CLAUSE DOES NOT ACCEPT DIFFERENT COLUMN ORDERS IN FOREIGN KEY DEFINITION
IY11785DB2_ALL WITH ':' OPTION ON SUN RETURNS STRANGE MESSAGES
IY11990ADDED SUPPORT FOR MINMEMUSAGE=1 FOR JDBC.
IY12029DB2ATLD FAILED WITH SQL1403N USERNAME AND/OR PASSWORD SUPPLIED INCORRECT-> TRACE SHOWS SQLOPDBISNODEPARTOFCLUSTER()RC=1 FAILED
JR14403THE RANGE SHOWN FOR LOGFILSIZ IN THE CC HINT IS WRONG FOR NT
JR14743DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM.
JR14758WITH SPECIFIC SETTINGS EVERY COMMAND ISSUED FROM COMMAND CENTER ON NT/UDB EE V5.2/FIXPACK 12 RECEIVES DB21005E ERROR.
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.
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
APAR fixes included in WR21187d (Fixpak 4d)
APARABSTRACT
IY09174MIGRATION FAILS DUE TO DISK FULL
IY09469SELECTING TABLES FROM OS/390 WHICH CONTAIN LOBS CAUSES SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT.
IY10901IMPORT FROM PIPE ASC BREAKS AT END OF BUFFER. ALTHOUGH IMPORT COMPLETES SUCCESSFULLY, ALL DATA IS NOT IMPORTED.
IY11063AN APPLICATION HANGS (AN AGENT STUCK IN MONITOR CODE)
IY11074SQL0101 ERROR WHEN RUNNING A QUERY DUE TO MEMORY FRAGMENTATION PROBLEM AND LOW 'ULIMIT -D' VALUE.
IY11218INTERMITTENT CLI0125E IN SQLJ STORED PROCEDURES
IY11343BAD PERFORMANCE WHEN A LOB IS PASSED INTO A UDF
IY11501DB2IUPDT SILENTLY CALLS DLFMUPDT IF IT IS A DLFM INSTANCE
IY11502SIG11 TRAP IN SQLOCSEMREMOVE AFTER A BACKUP FAILURE
IY11595ALLOW DB2 INTERNAL ROLLBACK IN STORED PROCEDURE AFTER DEADLOCK
IY11620DB2 UDB - PERFORMANCE DEGRADATION DUE TO OPTIMIZER INCORRECTLY ESTIMATING THE CARDINALITY OF AN INDEX SCAN
IY11625CORRUPTED UNIQUE INDEX AND DUPLICATE KEYS
IY11629I/O ERROR DURING MONITOR PROCESSING CAUSES PANIC IN REMOVE_ME FN
IY12356BACKUP TO ADSM WILL FAIL WITH RETURN CODE 11 OR 157
JR14403THE RANGE SHOWN FOR LOGFILSIZ IN THE CC HINT IS WRONG FOR NT
JR14646ADDING XBSA SUPPORT TO DB2 NT FOR SAP
JR14647JAVA CC DOES NOT ALLOW NUM_POOLAGENTS TO BE SET TO 0.
JR14649BACKUP IMAGE PATH IS CASE SENSITIVE ON INTEL - SQL2542N AT RESTORE
JR14723SQL1112 -NOT ENOUGH SYSTEM RESOURCES WHEN TRYING TO SCHEDULE ~100 JOBS FROM THE SCRIPT CENTER
JR14724IMPLEMENT MULTIPLE SESSIONS USING ADSM IN V6.1 ON NT AND OS2
JR14757BINDING THROUGH THE CCA TO VM HANGS IN CLP PACKAGES
JR14777QUERY TRAPS SERVER. TRAPPING FUNCTION IS SQLKT_PACK_TUPLE.
JR14793NT PERFORMANCE MONITOR HANGS WHILE MONITORING DCS APPLICATIONS
JR14795DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442
JR14812SPB FAILURE IN LIBJITC.DLL. NEED TO INITIALIZE WITH NOJIT OPTION.
JR14847CONTROL CENTER FOR V6 DOES NOT INCLUDE DAS - ADMIN SERVER - CANNOT BE USED FOR REPLICATION ADMINISTRATION ON MVS
APAR fixes included in WR21187c (Fixpak 4c)
APARABSTRACT
IY10585SQL0501 AFTER SQL0437W IN CLI APPLICATION. RETRY LOGIC FAULT.
IY10794JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY
IY11097NULL BUFFER FROM FCM PASSED TO SQLKQ_DETACH_BUFFER LEADING TO HANG ON SMP OR MPP MACHINES.
IY11141DB2JD TERMINATES IF IT CAN'T SPAWN ANY PROCESSES.
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
IY11375USEREXIT IS NOT BEING INVOKED EVEN THOUGH IT HAS BEEN SET UP PROPERLY.
IY11443RECONCILE RETURNS SQL2554N RC=5.
JR13044MS INTERDEV RECEIVES CLI0002W AFTER FETCH FROM SQLPROCEDURECOLUM NS()
JR14600V6 STORED PROCEDURE BUILDER CAN'T CONNECT V7 DB2 UDB
JR14889CRASH WITH SQLCREATEDAT (PROBE: 100) MESSAGES IN THE DB2DIAG.LOG INDICATING THAT THE DAT OBJECT LIFE LSN IS NULL.
APAR fixes included in WR21187b (Fixpak 4b)
APARABSTRACT
IY09385SQL1042 DURING CRASH RECOVERY DUE TO INDEX MANAGER PROGRAMMING ERROR (DIA3875C).
IY10199LEFT OR FULL OUTER JOIN PROBLEM WITH OPTIMIZER
IY10803LOG RECORDS BELONGING TO TABLESPACES NOT IN ROLLFORWARD TABLESPA CE LIST CAUSES ROLLFORWARD TO FAIL WITH SQL1272N.
IY10839PAGE BOUNDARY CACULATION ERROR CAUSES SQLOMMAPWRITE ERRNO EFBIG & SQL0968C FILE SYSTEM FULL
IY10861DATABASEMETADATA.GETCOLUMNS IS NOT HANDLING SCHEMAPATTERN='' CORRECTLY.
IY10902CREATE VIEW WITH SCHEMA NAME TOO LONG GIVES SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR.
IY11162SQL03181W ON LOAD WITH A SPECIFIC IXF FILE, BUT NOT ON IMPORT
IY11169IN DB2 CC CONNECTION IS NOT BEING REUSED/RELEASED PROPERLY.
IY11182SIGNAL 11 ON SQLULTERMINATE AFTER SQL2043 DURING AUTOLOAD
IY11211SILENT INSTALL DOESN'T POPULATE WIN REGISTRY PROPERLY
IY11217SQJ0001W WITH SQL0104N WHEN ISSUING DB2PROFC ON SQLJ APPLICATION
IY11275MULTISITE UPDATE HANGS WITH CC
IY11283ISSUING DB2IUPDT OVERWRITES THE DB2AUDIT.CFG WITH THE DEFAULT CONFIGURATION.
JR14068PCOMM ALLOWS '#' IN THE PARTNER LU NAME BUT DOES NOT ALLOW '#' I N THE SYM_DEST_NAME.
JR14234DB2 UDB - INSTANCE CRASHES WITH A SIGNAL 11 TRAP IN FUNCTION SQLEDATABASEBAD WHEN DB2 ATTEMPTS TO MARK THE DATABASE AS BAD.
JR14508V6.1 CLIENTS SHOW WRONG SCHEMA NAMES FOR ALIASES CREATED AGAINST DB(FOR V5.2/V6.1)
JR14595SQLDRIVERCONNECT IS SIGNIFIGANTLY SLOWER IN DB2 V6.1 COMPARED TO V5.2
JR14600V6 STORED PROCEDURE BUILDER CAN'T CONNECT V7 DB2 UDB
JR14605DIA3419C--NETBIOS NOT STARTED SUCCESSFULLY RC 3
JR14646ADDING XBSA SUPPORT TO DB2 NT FOR SAP
JR14737THE CLIENT IS INCORRECTLY CREATING MULTIPLE SNA CONVERSATIONS USING THE SAME LUWID. THIS IS CAUSING DB2 OS 390 TO ABEND.
JR14740%PATH%:%PATH%: GETS ADDED TO THE PATH EACH TIME DB2 IS INSTALLED ON WIN 98 (SAME THING HAPPENS WITH CLASSPATH)
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
APAR fixes included in WR21187a (Fixpak 4a)
APARABSTRACT
IY03947DB2DART WITH /DP OPTION ABORTS WHEN DB2_STRIPED_CONTAINERS IS USED.
IY06572SEGMENTATION FAULT WHEN BINDING A SECOND TIME TO A CURSOR
IY07623SIGNAL #11 TRAP IN SQLORQUE2()
IY08453SQL1227 RC 6 WHEN ATTEMPTING TO UPDATE STATISTICS WITH TABLE CARDINALITY OF 0 WHEN STATISTICS ALREADY EXIST
IY09151LOAD REPLACE OF AN EMPTY FILE (IXF) DOES NOT REPLACE EXISTING ROWS IN THE TABLE THE EMPTY FILE IS BEING LOADED INTO.
IY09439SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR.
IY09663DB2 CRASHED WITH ERROR DIA3816C CREATED BY SQM_EVMON_OSTREAM() SIG 11
IY09764TWO QUERIES DIFFERING ONLY IN THE ORDER OF THE PREDICATES, RETURN DIFFERENT RESULTS.
IY09856SELECT COUNT(*) FROM VIEW RETURNS INCORRECT RESULTS
IY09948JAVA STORED PROCEDURES NOT FOUND OUTSIDE SQLLIB\FUNCTION
IY09966JAVA.SQL.TIMESTAMP RECEIVING INVALID ARGUMENT(NANOS>999999999 OR <0) WHEN MULTIPLE THREADS MAKES THE CALL.
IY10004DB2JD TERIMINATES WITH EXCEPTION, WHEN USING HISTORY OPTION OF CONTROL CENTER FROM WINDOWS 95.
IY10029QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204
IY10047DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI
IY10080APAR IY07376 (DEFECT 138307) ADDED A LIBPATH SECTION YO DB2PROFI LE RESULTING SOME C PROGRAMS TO FAIL
IY10165SQL0910N - REASON 'COLUMN NUMBER OUT OF RANGE' WHEN SQL QUERY CO NTAINS MULTIPLE DISTINCT CLAUSE.
IY10183TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4.
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.
IY10371DB2AUDIT EXTRACT OUTPUT SHOW UNREADABLE CHARACTERS IN THE PACKAG E SCHEMA FIELD OF CHECKING EVENT.
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
IY10499OPTLEVEL 5 PLAN WORSE THAN OPTLEVEL 3 PLAN
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.
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
IY10901IMPORT FROM PIPE ASC BREAKS AT END OF BUFFER. ALTHOUGH IMPORT COMPLETES SUCCESSFULLY, ALL DATA IS NOT IMPORTED.
IY11030SQL30083 RC 24 WHEN TRYING TO CHANGE A PASSWORD LOCALLY FROM THE DB2 CLP USING A VALID PASSWORD
JR13854LANGUAGE SETTING DOES NOT WORK FOR THE STORED PROCEDURE BUILDER (SPB) ENVIRONMENT
JR14191KEYSET PARSER RETURN CODE=107 WHEN TRYING TO USE KEYSET CURSORS ADO W/ DB2 CONNECT V6.1.
JR14417CPU TIME INCORRECTLY CALCULATED. RESULT IS TOO BIG.
JR14497DB2 CONNECT TRAPS IN SQLJDRD1 ALONG WITH AN ACCESS VIOLATION DR. WATSON ERROR ON NT
JR14517SQL1092 WHEN CREATING DB ON REMOTE SERVER FROM CLIENT. CATALOG_NOAUTH IS IGNORED.
JR14521JAVA COMMAND CENTER RESULTS GREYED OUT WHEN SCROLLING.
JR14541TRAP IN SQLE_DB2RA_AS_DB_OPEN WHEN FORCING AN APPLICATION. OCCURS WITH PARALLEL QUERY USING CLI
JR14545SQL2034N (ADDRESS OF THE 'PASSWORD' PARAMETER NOT VALID) WHEN ATTEMPTING TO DO AN OFFLINE BACK FROM CLIENT CLP OR CC
JR14546CC FOR EEE/NT RETURNS SQL4414 ON NON-INSTANCE OWNNING MACHINE
JR14550JAVA COMMAND CENTER WIN9X RESULTS > 4682 CHAR DISPLAY PROBLEM
JR14592CONNECT TO DATABASE ON NT HANGS IN STRICMP() C LIBRARY CALL
JR14606EXPORT OF DEL MODIFIED BY DECPT SUBSTITUTES PERIOD FOR ANY CHARACTER FOR ITALIAN VERSION DB2 ON NT
JR14623PERF MONITOR (ACCESSED THROUGH CC IN V6) DOES NOT LIST ANY VALUES.
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
APAR fixes included in WR21187 (Fixpak 4)
APARABSTRACT
GG04010LONG VARCHAR FIELDS CAN BECOME OVERLAID
GG04017CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE
GG04023LONG VARCHAR FIELDS CAN BECOME OVERLAID
GG04024CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS
GG04025CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST)
GG04026WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED
GG04027NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE
GG04028CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN.
GG04031INSERTS ARE MISSED BY CAPTURE
GG04032CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE
GG04033CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS
GG04034CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST)
GG04035WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED
GG04036INSERTS ARE MISSED BY CAPTURE
GG04038THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED
GG04040CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS
GG04041COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN
GG04042ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE
GG04043MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER
GG04046APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO.
GG04048UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION
GG04049UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION
GG04051THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED
GG04052ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE
GG04053APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET.
GG04054APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET.
GG04055MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED.
GG04056MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED.
GG04057NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE
GG04058CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN.
GG04060ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED
GG04061ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED
GG04062'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE
GG04063'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE
GG04064CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED
GG04065CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED
GG04066CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS
GG04067COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN
GG04068MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER
GG04069ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG
GG04070CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE
GG04071CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T
GG04072CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T
GG04073CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000
GG04074CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000
GG04075CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE
GG04076ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG
IY04440BUFFERED INSERT ON LOG FULL CONDITION PRODUCES INCONSISTENT RESULTS.
IY06002MODIFY PROGRAM TYPE MAIN SP ARGUMENT INDEXES TO MATCH OS/390
IY07624PRUNE LOGFILE COMMAND RETURNS SQL1651N IF NOT CONNECT TO DATABAS E FIRST. SHOULD GIVE SQL1024 INSTEAD.
IY08076LONG VARCHAR FIELDS CAN BECOME OVERLAID
IY08077LONG VARCHAR FIELDS CAN BECOME OVERLAID
IY08085LONG VARCHAR FIELDS CAN BECOME OVERLAID
IY08124INSERTS ARE MISSED BY CAPTURE
IY08454CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE
IY08455CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS
IY08456CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST)
IY08457WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED
IY08458INSERTS ARE MISSED BY CAPTURE
IY08459CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE
IY08460CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS
IY08461CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST)
IY08462WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED
IY08463CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE
IY08464CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS
IY08465CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST)
IY08466WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED
IY08467INSERTS ARE MISSED BY CAPTURE
IY08468CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE
IY08469CAPTURE CORE DUMPS WITH ROWS CONTAINING MULTIPLE LONG VARCHAR COLUMNS
IY08470CHANGE CAPTURE TO SUPPORT AUTOMATIC SUMMARY TABLES (AST)
IY08472INSERTS ARE MISSED BY CAPTURE
IY08684SQL0107 RETURNED BY CLI DRIVER ON SQLFETCH CALL TO DB2 MVS.
IY08935'ASNCMD <DB_NAME> STOP' DOES NOT STOP CAPTURE
IY08937ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED
IY08938'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE
IY09042REPLICATION SETTINGS IN CC DOES NOT ALLOW AFTER CAPTURE.
IY09251DB2 EEE V6 CRASH RECOVERY FAILS, SQL1042
IY09262CHANGE THE DEFAULT SQL_CONCURRENCY AS READ_ONLY BASED ON THE CLAUSES PRESENT IN THE STATEMENT.
IY09280ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG
IY09615CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE
IY09616CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T
IY09633'ASNCMD STOP' RETURNS ERRNO 2
IY09706TRAP IN SQLCCGETATTR USING CONNECTION POOLING
IY09751DATABASE CRASH DUE TO TIMING HOLE IN CREATE TABLE ROLLBACK
IY09756NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS. REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED.
IY09788CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000
IY09855CLI ENTRY CODE TRAPS TRYING TO FREE A CONNECTION THAT NO LONGER EXISTS
IY09939ERRNO IS NOT RESET BEFORE CLI TYPE CONVERSION
IY10047DB2 TRACE ON CAUSES SQL1131N WHEN STORED PROCEDURE USES CLI
IY10086SQL0100W FROM SQLJ STORED PROC ON UPDATE OF NON-EXISTING ROW
IY10089APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO.
IY10090APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO.
IY10092APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO.
IY10093UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION
IY10094UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION
IY10095UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION
IY10096UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION
IY10118THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED
IY10119THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED
IY10120THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED
IY10121THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED
IY10137ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE
IY10138ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE
IY10139ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE
IY10140ADD A NEW APPLY INVOCATION PARAMETER SQLERRCONTINUE
IY10144APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET.
IY10145APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET.
IY10146CMPL ADDITIONAL BLANK LINE ADDED IN THE PSEUDO ASSEMBLER OUTPUT OF THE COMPILER USING REPLACE AND COPY (ALSO IN SOURCE LISTING)
IY10147APPLY ALWAYS REWORKED AN UPDATE INTO INSERT AND THEN FAILED SQLCODE803 WHEN PROCESSING REPLICA TARGET.
IY10148MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED.
IY10149MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED.
IY10150MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED.
IY10151MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED.
IY10167THE SQLDA IS INITIALIZED WITHOUT FIRST CHECKING THE SIZE OF THE RESULT SET. IF IT CONTAINS MORE THAN 255 COL. WE GET A CORE DUMP
IY10181LONG VARCHAR FIELDS CAN BECOME OVERLAID
IY10182WHEN PART KEY=Y, DELETE FOR FAILED UPD DIDN NOT GET COMPENSATED
IY10183TRAP/SIGNAL 11 - SQLPLWAITEEINFO (SUN): SQLPLFND (AIX W/ CORRUPT ED STACK ONLY TRAP AT DIAGLEVEL 4.
IY10212NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE
IY10213NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE
IY10214NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE
IY10215NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE
IY10216CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN.
IY10218CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN.
IY10219CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN.
IY10220CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN.
IY10221'ASNCMD <DB_NAME> STOP' DOES NOT STOP CAPTURE
IY10222"ASNCMD <DB_NAME> STOP" DOES NOT STOP CAPTURE
IY10223'ASNCMD <DB_NAME> STOP' DOES NOT STOP CAPTURE
IY10224ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED
IY10225ASNCCP DOES NOT TERMINATE WHEN "WARMNS" IS A STARTUP OPTION AND A COLD START IS NEEDED
IY10226ASNCCP DOES NOT TERMINATE WHEN 'WARMNS' IS A STARTUP OPTION AND A COLD START IS NEEDED
IY10227'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE
IY10228"ASNCMD A STOP" IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE
IY10229'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE
IY10244SELECT QUERY USING REVERSE INDEX SCAN FAILED WITH SQL0900 AFTER IT RAN FOR 30 MINS OR SO.
IY10256CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED
IY10257CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED
IY10258CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED
IY10259CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED
IY10309CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS
IY10310COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN
IY10311MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER
IY10313CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS
IY10314COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN
IY10315MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER
IY10317ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG
IY10338CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE
IY10340'ASNCMD STOP' RETURNS ERRNO 2
IY10341CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000
IY10343CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS
IY10344COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN
IY10345MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER
IY10346ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG
IY10347CAPTURE HANGS/RETURNS SQL0204 WHEN "SCHEMA"."TABLE" HAS A SPACE
IY10348CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T
IY10349"ASNCMD STOP", RETURNS ERRNO 2
IY10350CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000
IY10351CAPTURE RESTART ON LONG VARCHAR RECORDS MAY HAVE UNPREDICTABLE RESULTS
IY10352COMPENSATION OF DELETE FROM THE CD TABLE FAILS WHEN THE DELETE LOG RECORD CONTAINS ANY LONG VARCHAR COLUMN
IY10353MULTIPLE LOB COLUMNS CAUSES CORE DUMP IN DECODER
IY10355ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG
IY10356CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE
IY10357'ASNCMD STOP' RETURNS ERRNO 2
IY10359CAPTURE CRASH WHEN THE SRC TABLE HAS LF, BUT CD TABLE DOESN'T
IY10360CAPTURE STOPS WHEN TRYING TO HANDLE A VARCHAR COLUMN OF LENGTH 30000
IY10491SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1
IY10500INVALID CONVERSION/TYPE FOR DOUBLE WITH STORED PROC IN DB2/MVS 6
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY10765APPLICATION HANG IN FCM ON VERY FAST MACHINE
IY10816CLI0111E ON INSERT OF DECIMAL 0.00=<X=<0.99 IN SQLJ STORED PROC
JR14349SQLDESCRIBEPARAM RETURNING CLI0150E, DRIVER NOT CAPABLE.
JR14386EXECDIRECT ON KEYSET CURSOR USES THE WRONG INFO FOR GETTING DATA OF THE PRIMARY KEY
JR14416OS/2: AUTHENTICATON SERVER FAILS IF SECURITY IS SAME
JR14491THE BIND FILENAME IS TRUNCATED IF > 50 CHARS IN SQLAJBND_BIND.
JR14525REDO THE DESCRIBE IF EXECUTE OF A CACHED PROC FAILS.
JR14532DB2SYNC APP SHOWS 100% COMPLETE BUT BAR IS AT 85%
APAR fixes included in WR21172f (Fixpak 3f)
APARABSTRACT
IC26754IBM JDBC DRIVER CAUSES EXCEPTION IN MS J++ GARBAGE COLLECTOR.
IY08857SPECIFIC INTRA PARALLEL QUERY NOT TAKING ADVANTAGE OF HI2KEY/LO2 KEY WITH MGJN
IY09146FIX FOR PERFORMANCE PROBLEM CAUSED BY JR13499
IY09422MANUALLY UPDATING COLVALUE COLUMN IN SYSSTAT.COLDIST TABLE WITH A DATE VALUE DISPLAYS THE UPDATED VALUE WITHOUT SINGLE QUOTES.
IY09592DB2 SENDS WRONG SIZES FOR DATA PARTITIONS TO BACKUP TO ADSM CLIENT.
IY09664INCORRECT DATABASE SEED IN EEE ENVIRONMENT AFTER ADDING ADDITIONAL NODES SUCH THAT EVENT MONITOR FAILS ON NEW NODES.
JR14385EXECDIRECT ON KEYSET CURSOR DOES NOT QUALIFY SYSTABLE/SYCOLUMNS TABLES ON SELECT FOR TABLE INFORMATION.
JR14399CONTAINER LISTS NOT REFRESHED DURING NODE CHANGES IN THE CONTROL CENTER.
JR14420CUSTOM DPREPL.DFT SETTINGS FOR CONTROL CENTER NOT PICKED UP.
JR14506JAVA MULTIPLE SESSION PROBLEM WITH THE .APP. DRIVER.
APAR fixes included in WR21172e (Fixpak 3e)
APARABSTRACT
IY06432RUNSTATS WITH DISTRIBUTION CAUSES INCORRECT FILTER FACTOR WHEN GENERATING ACCESS PLAN.
IY07870SQL1035N RETURNED WHILE DB IS IN ONLINE BACKUP AND SAME USER TRIES TO CONNECT TO IT
IY08714LOAD WITH REPLACE OPTION GIVES BAD PAGE ERROR IN DART OUTPUT
IY09051RESTORE DB FROM ADSM THROUGH CONTROL CENTER IN DB2 V6 IS FAILING WITH ERROR CODE SQL2542N.
IY09342SQL1042N TRYING TO CONNECT TO DB AFTER EVENT MONITOR PIPE READER IS GONE.
IY09345STORED PROCEDURE DOES NOT WORK WITHOUT QUALIFIER
IY09402DB2 REBIND TOOL DOES NOT UPDATE THE RDS_LEVEL COLUMN IN THE SYSIBM.SYSPLAN SYSTEM TABLE.
IY09469SELECTING TABLES FROM OS/390 WHICH CONTAIN LOBS CAUSES SQL0902 OR SQL30020 RC 124C TO BE RECEIVED BY CLIENT.
IY09505INCORRECT COMPILE INSTRUCTIONS IN DB2UEXT2.CADSM FOR ADSM 3.1.6 OR HIGHER.
IY09507SQL1478 AFTER CREATE/ALTER/DROP BUFFERPOOL WHERE THE TOTAL CHANGE IS >=2GIG. THIS RESULTS IN AN INCONSISTENT SQLBP FILE.
IY09605SQL0199N ON SQLSTATISTICS AGAINST MVS WITH CURSORHOLD=0
JR14327FIXPAK INSTALLS OF JDBC 1.1 AND 1.2 FILE MAY CAUSE FILES TO BE OVERWRITTEN
JR14384CONNECT HANGS WHEN CBIT ERROR IS ENCOUNTERED DURING CRASH RECOVERY.
JR14462DB2BATCH THROWS AN ERROR AT THE END OF EXECUTION (DB2SYS.DLL)
JR14476WORKAROUND FOR DB2 UDB TO IGNORE THE VERSION OPTION SPECIFIED AT BIND TIME WHEN USING DPROPR
APAR fixes included in WR21172d (Fixpak 3d)
APARABSTRACT
IY07076TRAPS IN SQLRISR2 SQLSFETC SQLRISRT SQLRIRST EXECUTING SQL
IY08600DATALINKS PARAM CHANGES TO N IN MIGRATIONS FROM V5 TO V6
IY08767TIMING ISSUE IN BSU WHEN TRYING TO RETURN A DARI TO THE POOL
IY09191IMPROVE DB2DIAG.LOG MESSAGES FOR RFWD TO PIT ERRORS
IY09202Signal#11 IN SQLO_INIT_MULTI_THREADING
IY09213JDBC NET DRIVER PERFORMANCE. RESULTSET.CLOSE() FROM JDBC CLIENT SENDS REQUEST TO THE DB2JD SERVER AND EXPECTS NO RESPONSE.
IY09223ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER PREPARE
IY09267RUNSTATS RECEIVES SQL2314W
IY09275LICENSE USE MANAGER LUM LOOPS CHECKING /DEV/HIL ON HP UX WHILE VALIDATING THE LICENCE FOR DB2 CONNECT.
IY09298DB2COUNTRY VARIABLE DEFAULTS TO A VALUE OF 0 INSTEAD OF 1
IY09314DB2EXPLN WITH -L OPTION doesn't RESPECT PACKAGE NAME CASE
IY09367DB2 UDB - ONLINE/OFFLINE BACKUP TO MULTIPLE DISKS HANGS. NOTE: THIS IS A EXTENSION TO THE FIX FOR APAR IY04310.
JR14355INVALID MEMORY ACCESS - C0000005 TRAP IN SQLRIVAL (TRAP FILE SHOWS SQLRICONSEC ) RUNNING QUERY WITH PARALLELISM
JR14415TRAP - MTS AND STORED PROCEDURES WHICH RETURN RESULT SETS
JR14416OS/2: AUTHENTICATON SERVER FAILS IF SECURITY IS SAME
JR14434FORCE APP ALL TRAPS TYPE 2 CONNECT APP IN OTHER WINDOW WHICH HAD INVOKED DOSSLEEP
JR14474JDBC MULTIPLE SESSION PROBLEM: CLI0601 ERRORS.
JR14475(JDBC/CLI) COMMA DECIMAL SEPARATOR NOT WORKING IN NLS.
JR14479THE CONTROL CENTRE (AND INFORMATION CENTRE) DO NOT START BECAUSE DB2JAVIT.EXE FAILS IF REGISTRY INDICATES JDK 1.2 IS INSTALLED.
JR14484SQL30083 RC=1 WHEN PASSWORD IS CHANGED FROM A CLIENT
APAR fixes included in WR21172c (Fixpak 3c)
APARABSTRACT
IY06649DB2CART DUMPS HUGE AMTS OF DIA3605C & DIA3855CINTO DB2DIAG.LOG
IY07739OPTIMIZER PREDICATE PROBLEM ON EEE WITH QUERY WRITTEN WITH UNION ALL
IY08948REORGCHK AT DIAGLEVEL 4 GENERATES -501 IN DB2DIAG.LOG FILE.
IY09006DB2IMIGR FAILS WITH SEGMENTATION VIOLATION, RC=139 SPECIFICALLY WITHIN DB2IMNOD.
IY09149JDBC NET DRIVER RETURNS -99 ON EXECUTEUPDATE AGAINST DB2 MVS
IY09292RESTORE USING CONTROL CENTER INCORRECT.
JR14263WRONG WEEK NUMBER RETURNED FROM WEEK FUNCTION
JR14408SQL0984C WITH 'INCORRECT USE OF THE SAVEPOINT' MSG IN DB2DIAG.
JR14438ARRAY INSERT INTERMITTENT FAILURE IF CBCOLDEF=0 SQLBINDPARAMETER
JR14450CLI0100E ERROR WHEN SETTING A DECIMAL COLUMN TO NULL
APAR fixes included in WR21172b (Fixpak 3b)
APARABSTRACT
IX87885TWO PHASE COMMIT. CLIENT CALLS A STORED PROCEDURE AND THEN COMMITS IS NOT PERFORMED.
IX88428USING ADSM CONFIGURATION PARAMETERS IN DB CFG CAUSE A NULL TO BE ASSIGNED AS THE BACKUP IMAGE OWNER.
IY08086DATABASE MARKED BAD DURING RESTART DUE TO INCORRECT HANDLING OF A RETURN CODE 1 FROM SQLBFLSH IN SQLPUPDATEMINBUFFLSN
IY08125SQLTABLES() CALL IS NOT RETURNING INOPERATIVE VIEWS FROM A UDB DATABASE.
IY08729PATCH1=131072 CAUSES CONTROL CENTER HANG IN STATEMENT HISTORY
IY08867DB2CKMIG_EXE FAILS ON HP-UX 11 MACHINE 859
IY08893SQL2306N AT LOAD WITH DBCS TABLE NAME
IY08920CC V6.1 PERFORMANCE MONITOR - START MONITOR OPTION FOR SPECIFIC DATABASE APPEARS TO HANG - NO MONITORS LISTED
IY09068EVENT ANALYSER INFORMATION FROM AIX WILL NOT DISPLAY ON NT
JR14049SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG
JR14067V6.1/NT THIN CLIENT INSTALL PROBLEM B/C MISSING LDAP KEYWORD
JR14148ALWAYS TREAT '_' AS A CHARACTER WHEN IN CALL STMT-ST.PROC NAME
JR14239DURING ROLLFORWARD RECOVERY, WE SEE ERROR MESSAGES IN THE DB2DIA G.LOG STATING 'CANNOT STEAL SPACE FROM OTHER BUFFER POOLS.'
JR14279SQLEXTENDEDFETCH RETURNS SUCCESSWITHINFO IF A FETCH OF ONE ROW FAILS DUE TO TIMEOUT OR DEADLOCK. RETURN SHOULD BE SQLERROR.
JR14400CREATE NEW PRECOMPILER SERVICE FUNCTION TO ACCEPT DIFFERENT DB V ERSIONS AND SELECT PRECOMPILER BEHAVIOUR ACCORDINGLY.
JR14404SQLCOLATTRIBUTE RETURNS INCORRECT INFORMATION
JR14409TRAP FILE SHOWS TRAP IN SQLISETKEYANDKEYDATA (IN SQLIUNDO.C). HOWEVER, ACTUAL TRAP IS IN WRITELOG.
JR14412ACCESS 2000 FAILING WITH VARCHARS > 210 CHARACTERS
JR14418JDBC 2.0 APP DRIVER SEGMENTATION FAULT WHEN EXECUTING QUERY.
JR14435CLI0165E CALLING STORED PROCEDURE WITH ASYNC ON AND BLOB COLUMN
JR14436Garbage characters in the DB2 recovery history file when using the sqluvtun API.
APAR fixes included in WR21172a (Fixpak 3a)
APARABSTRACT
IC26217CLI0109E 'STRING DATA RIGHT TRUNCATION' ERROR OCCURS WHEN TRYING TO INSERT BINARY DATA
IX87387SELECT W/ OPTIMIZE FOR N ROWS AND FOR FETCH ONLY GOING AGAINST MVS RESULTS IN AN ADDITIONAL FOR FETCH ONLY BEING ADDED.
IY02962DEFUNCT CHILD PROCESSES ON SOLARIS WITH JDBC NET DRIVER
IY03632RECONCILE DLREPORT NEEDS TO BE TERMINATED WITH /
IY05131CLI0165E WHEN USING SQLEXTENDEDFETCH WITH ASYNC MODE ON
IY05292DBA2065 TRYING TO RUN OR SCHEDULE SCRIPT FROM SCRIPT CENTER.
IY05325TRAP IN SQLE_MRSPSENDDARISTART WHEN CALLING STORED PROCEDURE THROUGTH DB2 CONNECT
IY06100DATABASE COMES DOWN, SEE MESSAGE IN DB2DIAG.LOG STATING THAT FLUSH NOT ALLOWED ON ESTORE.
IY06691SQL4970 ON ROLLFORWARD TO END OF LOGS - 'UNEXPECTED FILECOUNT'
IY06767PERL FOR DB2 DISPLAYS VARGRAPHIC NULL STRINGS INCORRECTLY
IY07550SQL1042N DURING A ROLLFORWARD OF A V5.X DATABASE THAT HAS BEEN MIGRATED FROM V2.X DATABASE.
IY07598LOAD WITH MULTIPLE INDICES AND ESTORE ENABLED TRAPS THE LOAD PROCESS DB2LRID.
IY07604SQLJ SQL0309 IF HOSTVARIABLE VALUE IS NULL ON UPDATE
IY07711DB2CCLST LEAVES DEFUNCT PROCESSES ON UNIX PLATFORMS WITH MULTIPLE LOGICAL NODES.
IY07809AIX LOGIN LOGS NOT UPDATED WHEN CONNECT TO DB WITH WRONG PASSWD AFTER USER ACCOUNT IS LOCKED.
IY07865EVENT MONITOR STATE NOT UPDATED CORRECTLY.
IY07880-902 IN SQLRRSTA DURING RUNSTATS INDICATING A MEMORY HEAP ERROR.
IY07884JDBC APPLICTION WAS CRASHING DUE TO NULL MEMORY BEING FREED BY THE CLI LAYER
IY07951JAVA UDFS WITH DECIMAL PARAMETERS PERFOMANCE DEGRADS
IY07968HANG / DEADLOCK ON PARALLEL-ENABLED QUERY
IY08008DLFM SHUT DOWN WHEN YOU FORCE THE COPY DAEMON'S ADSM SESSION TO TERMINATE OR RECYCLE THEIR ADSM SERVER.
IY08060SQL0901N REASON 'SQLNO_NUM_CHARS_SPECIFIED 200 :RC( 0)') WHEN DB2CODEPAGE=1208
IY08066SNAPSHOT FOR DB SHOWS WRONG O/P FOR AGENTSIN V5,V6 & V7
IY08086DATABASE MARKED BAD DURING RESTART DUE TO INCORRECT HANDLING OF A RETURN CODE 1 FROM SQLBFLSH IN SQLPUPDATEMINBUFFLSN
IY08106V5.2 TO V6.1 MIGRATION FAILS ON A SQL0456N IF MIGRATION IS RUN MORE THAN ONCE AFTER A MIGRATION FAILURE
IY08124INSERTS ARE MISSED BY CAPTURE
IY08204NON CONSTANT 'PULLUP' IN THE OPTIMIZER CAUSING QUERY PERFORMANCE PROBLEMS.
IY08219FAILURE ON DATABASE INITIALIZATION CAN LEAVE ORPHANED PREFETCHERS WRITING SQLOCSEMP MESSAGES TO DB2DIAG.LOG IN LOOP
IY08304BP PAGESIZE WRONG WHEN CREATED ON NODE USING ALTER BUFFERPOOL
IY08307SQL2306 WHEN LOADING AS DBADM WITHOUT DISCONNECTING PREVIOUS CONNECTION OF ANOTHER USER
IY08318CLI RETURNS DRIVER NOT CAPABLE FOR LONG VARCHAR TO AS/400
IY08320REBINDING OLD (V1.X) BIND FILES YIELDS SQL0436 WHEN APP. IS RUN
IY08349IF ONLY UOW MONITOR TURNED ON, UOW INFORMATION NOT COLLECTED.
IY08365DB2JSTRT DOES NOT MAKE USE OF THE VARIABLE DB2_PORT_NUMBER
IY08557SQL30081 ON THE CONNECTION WHEN DB2 CONNECT V6.1 AND IDLE THREADS ARE CANCELLED ON OS/390 SIDE.
IY08569ROLLFORWARD OF DATABASE CAUSES CORRUPTION OF LOB DATA
IY08573RUNNING 'GET SNAPSHOT FOR ALL' MULTIPLE TIME MAY CRASH DB2
IY08581INTERRUPTED REDISTRIBUTE INCORRECTLY RETURNS SQLCODE 0 - REDISTRIBUTE COMPLETED SUCCESSFULLY
IY08584MULTIPLE IN PREDICATE WITH OUTER JOIN CAUSES EXPLAIN ERROR
IY08589BIND FILE CREATION FOR CLI PRODUCES AN INCORRECT OPTIONS STRUCT
IY08716HASH JOIN MAY RESULT IN ENDLESS LOOP
IY08717Signal#11 IN SQLRG_ADD_CHK_CSTRNT_HCSD
IY08722MESSAGE ERROR -- SQLZ_VALUE MAP NOT INITIALIZED USING DB2EXPLN.
IY08729PATCH1=131072 CAUSES CONTROL CENTER HANG IN STATEMENT HISTORY
JR13153DB2 CONNECT GATEWAY TRAPS WHEN LARGE ARRAYS PASSED AS INPUT PARAMETERS.
JR13682CONTROL CENTER NOT ABLE TO LIST DCS APPLICATIONS FOR A REMOTE INSTANCE. DEFECT #124825
JR13887ERRONEOUS 'FAILED TO COMMIT' MESSAGE DUMPED TO DB2DIAG.LOG LOAD INCORRECTLY HANDLES POSITIVE RETURN CODE FROM COMMIT
JR14082FIX 12-BYTE MEMORY LEAK FOR NON-BLOCKED CURSORS
JR14222CCA BIND OF CLI UTILITIES MISSES A PACKAGE AGAINST DB2/MVS 5.1
JR14237DB2GOV FAILS WHEN DB2NODES.CFG HAS BLANK LINE AT THE END
JR14255NO RESULT SETS RETURNED (AND POSSIBLY AN INVALID ERROR MSG) WHEN ISSUING QUERY FROM V6.1 CLIENT THROUGH DB2 V.6.1 SERVER TO DJ
JR14263WRONG WEEK NUMBER RETURNED FROM WEEK FUNCTION
JR14282SQL30020, OR AN ABEND ON DB2 FOR OS/390 WHEN INVOKING A STORED PROCEDURE WITH OUTPUT PARMS LONGER THAN THE BLOCK SIZE (32K)
JR14305TAPE SUPPORT ROUTINES ON NT DO NOT WORK WITH MAGSTAR3590
JR14311BIND OF V5 LESS THAN FP7 CLIENT PACKAGES TO V6 SERVER
JR14312DB2 COBOL PRECOMPILER TO GENERATE COPY 'SQLCA.CBL' INSTEAD OF COPY 'SQLCA.CBL'
JR14314PROVIDE PATCH VALUE TO WORKAROUND ADO ADUSECLIENT PROBLEM.
JR14337CANNOT LOAD DDCS.DLL ON OS/2 SQL1108 ON REMOTE CLIENT CONNECTION
JR14339HOST DB CATALOGGED USING CCA USING ENABLE ENCRYPTION WITH DCS AUTHENTICATION: CONNECTION FAILS WITH SQL1403N
JR14346LICENSING DOES NOT COUNT CONCURRENT REMOTE CONNECTIONS
JR14371THE FLAG FOR FOR BIT INDICATOR IS NOT BEING INITIALIZED PROPERLY
JR14373CIRCUMVENT CLI0109 ERROR: REDESCRIBE EVERY TIME WE GET CLI0109 ERROR. KEYWORD REDESCRIBEPARMONERROR: 1 -DEFAULT, 0 -DISABLE THI
JR14383RUNNING SCRIPTS IN SCRIPT CENTER SWITCHES OS/2 INTO LOGON MULTI MODE WHICH CAUSES RUNNING APPS (E.G., APPLY) TO WAIT FOR LOGON
APAR fixes included in WR21172 (Fixpak 3)
APARABSTRACT
GG03649UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9
GG03991APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE
GG03993CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES
GG03996CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS
GG03999CAPTURE CORE DUMPS AROUND PRINT_LSN()
GG04000ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
GG04001ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
GG04003APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE
GG04004SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR
GG04005SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR
GG04006UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9
GG04007UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9
GG04008WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT.
GG04011SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD
GG04012CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS
GG04013CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES
GG04014SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD
GG04015CAPTURE CORE DUMPS AROUND PRINT_LSN()
GG04016WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT.
IC24824CHECK IN DJRA.EXE FOR UDB V61
IY02571SQL0433 DURING INSERT VALUES, LINEFEED CHANGED TO SPACE
IY04962USING VOLATILE FLAG DURING R/3 UPGRADE
IY05590DB2IUPDT IN FP11 RESETS DB2PROFILE 99/11/11 PTF PECHANGE
IY05988UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027/ASN0017S RC9106 ASN0017
IY06283LATCH CONTENTION CAUSES HIGH SYSTEM CPU SPIKES WHEN MANY AGENTS ARE IN A TIGHT LOOP EXECUTING THE SAME DYNAMIC STATEMENT
IY06740DB SIZE ESTIMATE CALCULATED INCORRECTLY FOR BACKUP TO ADSM. HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE.
IY06891CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES
IY06907UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027
IY07053CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS.
IY07069CLI0002W DATA TRUNCATED WHEN FETCHING CLOB FROM DB2/390 V6
IY07092CHANGE OPTIMIZER COSTING TO HANDLE NULLS
IY07110-901:SQLNO_SMP_CREATE_TQ
IY07239JAVA UDF EXCEPTION NOT IN DB2DIAG.LOG FOR MISSING CLASS
IY07309SQL3508 REASON 4 ON LOAD WITH DELETE PHASE OR LOAD RESTART WHEN TABLE ID > 32767 (APPEARS NEGATIVE IN SYSTEM CATALOGS).
IY07523ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
IY07527ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
IY07528ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
IY07556APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE
IY07558APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE
IY07559APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE
IY07560SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR
IY07566SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR
IY07567SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR
IY07568SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR
IY07572ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
IY07573APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE
IY07590CHANGES MADE TO SQLGETDATAINTERNAL CAUSED CODE TO TRAP
IY07600QUERY PERFORMANCE AGAINST >4 TABLES IS NEGATIVELY AFFECTED BY THE CONTENT/LENGTH OF THE LIKE PREDICATE STRING.
IY07699UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9
IY07700UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9
IY07701UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9
IY07702UPDATING THE ASN.IBM_SNAP_SUBS_EVENTS, COLUMN EVENT_TIME TO 0001 01-01-00.00.00DOES NOT STOP PROCESSING THE SUBSCRIBTION IN FP9
IY07709SQL1131N WHEN CALLING SQLJ STORED PROCEDURE EMBEDDED CLIENT
IY07735SQL0433N ENCOUNTERED WHILE DOING A BUFFERED INSERT
IY07744CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS
IY07745CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES
IY07747SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD
IY07748CAPTURE CORE DUMPS AROUND PRINT_LSN()
IY07749WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT.
IY07750WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT.
IY07751CAPTURE CORE DUMPS AROUND PRINT_LSN()
IY07753SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD
IY07755CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS.
IY07756UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027
IY07757CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES
IY07759SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD
IY07760CAPTURE CORE DUMPS AROUND PRINT_LSN()
IY07761WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT.
IY07796CMDEAL WITH TYPE CM_DEALLOCATE_ABEND DOESN'T RETURN
IY07808RETROFIT NEW PACKAGE NAMING ALGORITHM INTO V6 FOR STORED PROCEDURE BUILDER
IY07822CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS
IY07823UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027
IY07824CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES
IY07825SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD
IY07826CAPTURE CORE DUMPS AROUND PRINT_LSN()
IY07827WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT.
IY07908ROWCOUNT > 10000000 IN LOAD COMMAND CAUSES INSTANCE CRASH
IY07922THE IN PREDICATE IN THE QUERY IS NOT PUSHED DOWN DUE TO OJ
IY08058NO DROPPED TABLE RECORD IS CREATED WHEN DROPPING A TABLE
IY08124INSERTS ARE MISSED BY CAPTURE
IY09479SQL2154 ON ATTEMPTED TABLESPACE RESTORE - TRAP MAY ALSO OCCUR.
JR1350832K MEMORY NOT FREED PROPERLY WHEN APPLICATION DISCONNECTS IN DRDA
JR13682CONTROL CENTER NOT ABLE TO LIST DCS APPLICATIONS FOR A REMOTE INSTANCE. DEFECT #124825
JR14011PCS_AGNT ERRORS PREVENT WINNT SHUTDOWN (USING INTEGRATED SNA ON DB2)
JR14089DB2 ALLOWS TWO FOREIGN KEYS TO CO-EXIST ALTHOUGH THEY CONTRADICT EACH OTHER.
JR14168EVENT MONITOR ALWAYS ATTACHES TO THE SAME INSTANCE IF MULTIPLE INSTANCES EXIST ON THE SAME MACHINE.
JR14184MULTITHREADED FIXES NEED TO BE DONE TO DB2JD DUE TO VARIOUS PROB LEMS (EXAMPLE: DB2JD BECOMES UNAVAILABLE INTERMITTENTLY)
JR14201GATEWAY TRAPS AT DB2SYSCS.EXE. 'ERROR IN AGENT SERVICING APPICATION WITH COOR_NODE:XXXX' IN DB2DIAG.LOG.
JR14210CLIENT CONTROL CENTER CANNOT SEE OS/390 TABLES
JR14219CLI APP INSERTS INCORRECT CHAR VALUES. EEE/MPP/CODEPAGE.
JR14229SQJ0201E DURING SQLJ CUSTOMIZATION OF CALL STATEMENT
JR14271In Satellite Edition, the results of TRUNCATe script EXECUTION, outputs the FIRST PORTION, INSTEAD OF THE LAST portion
APAR fixes included in WR21162d (Fixpak 2d)
APARABSTRACT
IY04139SQL5153 NEEDED INSTEAD OF SQL30081 ON CLIENT WHEN NO FCM RQBLK IS AVAILABLE. SERVER ERROR SQL6043 IS FINE.
IY04310DB2 UDB - ONLINE/OFFLINE BACKUP TO SEVERAL DISKS HANGS.
IY05535QUERY TO DB2/MVS IS BEING TIMEDOUT EVEN IF NOT INTERRUPT ENABLED
IY06431ATTEMPTING TO CHANGE A FILE DMS CONTAINER TO A DEVICE DMS CONTAI NER IN THE REDIRECTED RESTORE FAILS
IY06700DB2_ENABLE_SINGLE_NIS_GROUP CAUSES DB2START TO HANG ON HP10
IY06746DIA5000C A DRDA AS TOKEN 'RECOVERABLE' WAS DETECTED. THE DIAGNOSTIC DATA RETURNED IS (SRVDGN). DUMPS ARE CREATED.
IY06791DB2 UDB - SQL3021/SQL0204 ON IMPORT REPLACE TO A ALIAS NAME FOR A TABLE IN WHICH THE USER HAS CONTROL ACCESS TO.
IY07068LOGPATH WITHOUT NODENUM IS SET AFTER MOVING FROM V5 EE TO V6 EEE
IY07098SQL2550N RETURNS WRONG INFORMATION WITH SECOND NODE NUMBER
IY07235DB2DIAG.LOG AND TRAP FILE GROWS VERY LARGE AFTER SECOND INSERT UPON TABLESPACE FULL CONDITION.
IY07311HASH JOIN FAILS WITH MEMORY ALLOCATION ERROR. INITIALIZATION FAILS CAUSING SUBAGENTS TO FAIL DURING MEMORY ALLOCATION.
IY07319QUERY PATROLLER 'IWM START ALL' FAILS
IY07376LIBPATH NEEDS TO BE SET IN DB2 INSTANCE ON AIX OTHERWISE VARIOUS PROBLEMS CAN HAPPEN. 'NO SUITABLE DRIVER' FOR EXAMPLE.
IY07453TRAP IN SQLDFIXTCB DURING LOAD DUE TO INCORRECT RETURN CODE HANDLING IN SQLU_GET_TABLE_ID
IY07474INCORRECT TIMESTAMP 01-01-1970 IN APPLICATION SNAPSHOT OF LOCK WAIT STATE APPLICATION. IT SHOULD HAVE CORRECT TIMESTAMP.
IY07659-901 FROM SQLNO_FIND_LOCAL_EQ_PRED
JR13497SQLWARN FLAGS ARE NOT BEING RESET AFTER EXECUTE
JR13651SQL2029N, RC=28 ON RESTORE ISSUED FROM CLIENT WITH A DIFFERENT ALIAS THAN THE SERVER - USING SYTOS USEREXIT
JR13964CHECK FOR INVALID CHARS IN HOSTNAME BEFORE INSTALL
JR14049SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG
JR14066SQLEXECDIRECT RECEIVES 'SQL0005W OPTION VALUE CHANGED' WHEN USING KEYSET CURSORS, AND THEN NO DATA IS RETURNED.
JR14112CLI0118E WITH 'SELECT {FN UCASE(T1.COL1)} FROM TABLE1 T1'
JR14116-514 ON SQLEXECUTE() FOLLOWING COMMIT ON OPEN CURSORS ON HOST
JR14167CC: CAN ONLY CONFIGURE PARTITION 0 IN EEE ENVIRONMENT
JR14169ALTER TABLE ADD COLUMN ON A TABLE WITH CLUSTERING INDEXES CRASHES THE DATABASE
JR14170SQLA.DLL AND SQLA32.DLL WERE INCLUDED IN SDK PACKAGING INSTEAD OF IN CAE
JR14171REMOVING JOURNAL ENTRIES FROM CC CAUSES SQL1058.
JR14174SQL1403 WHEN CONNECTING TO DATABASE ON NT USING A USERID THAT IS THE SAME AS A DOMAIN NAME
JR14194SQL0007N WITH SQLJ WHEN CALL STATEMENT INCLUDES A HOST VARIABLE
APAR fixes included in WR21162c (Fixpak 2c)
APARABSTRACT
IY04173DB2ADUTL DOES NOT GUARANTEE ORDER WHEN EXTRACTING LOGS FROM ADSM IF MULTIPLE COPIES OF THE LOGS EXIST.
IY04401SQL1042 AT RESTART DB AFTER CRASH AT ALTER BUFFERPOOL
IY05732CLI REPORTS THAT UDB DOES NOT SUPPORT INOPERATIVE VIEWS -IT DOES
IY05814DB2 FAILED TO CREATE DB WHEN SET LOCALE=ZH_TW.BIG5 ON SOLARIS.
IY06066PUTTING ASYNCENABLE BACK INTO CLI
IY06126QUERY THAT EXECUTES IN PE 1.2 FAILS WITH SQL0101 AT OPTIMIZAITON LEVELS < 7 AND STMTHEAP < 60000
IY06147ADD SUPPORT FOR CHAINING THE CLOSE OF A CURSOR TO THE NEXT OPEN
IY06164WHEN AUTOCOMMIT IS ON AND SQLEXECDIRECT RETURNS A NEGATIVE SQLCODE, NO COMMIT IS SENT TO THE TARGET DATABASE.
IY06178STORED PROCEDURE BUILDER CAUSES TRAP (SIGNAL 4-NO STACK) WHEN INVOKED BY CLIENT TO NON-CATALOG NODE.
IY06234JDBC RETRIEVAL OF NON-US CLOB TRAPS
IY06317CONCURRENT LONG RUNNING QUERIES CAUSE CPU TO SPIKE FOR A PERIOD OF TIME PREVENTING NET.COMMERCE APPLICATIONS FROM PROCEEDING
IY06343AUTOLOADER MAY HANG IN SOLARIS
IY06347TCP LISTENER HANGS IN SQLEGETAGENT UNDER HIGH WORKLOADS
IY06539TIMING PROBLEM WITH LOAD IN INCREMENTAL INDEXING MODE.
IY06717DDL GENERATED BY DB2LOOK FOR UNIQUE INDEXES CAN BE IMPROVED.
IY06750DB2LOOK DOES NOT SUPPORT DATALINK DATA TYPE
IY06806DB2 CONNECT TRAPS IN SQLE_DB2RA_AS_DB_BLOCK_FETCH, WHEN CLIENTS CONNECT TO EE/EEE DATABASES THROUGH THE GATEWAY.
IY06808INCORRECT NODE NUMBER PICKED UP IF ISSUING A CONNECT FROM A NODE THAT IS NOT IN THE DB2NODES.CFG AND DB2NODE IS NOT SET.
IY06824INDEXES ARE NOT MIGRATED DURING UDB EEE MIGRATION FROM V5 TO V6.
IY06843APPLICATION CORE DUMPS WITH DB2 V6.1 WITH THE FOLLOWING ENTRIES IN DB2DIAG.LOG: DIA1518, DIA3826C FROM LOCK_MANAGER IN SQLPLHLD.
IY06912BACKUP FAILS AT THE END WHEN UPDATING DB2RHIST.ASC FILE (BACKUP HISTORY FILE). PREVIOUS FAILED LOAD OPERATION.
IY06932SQL0973 QUERY_HEAP AFTER REPEATED ERRORS WHEN USING DESCRIBE DA (CLI)
IY07040SQLDESCRIBEPARAM IS CALLED ON A CALLABLE STATEMENT EVEN WHEN DISABLED.
IY07111CLIENT CONTROL CENTER CONNECT CAUSES EEE SERVER INSTANCE TO TRAP. 00/01/10 PTF PECHANGE
IY07120INSTANCE CRASHES WITH SIG#11 ON EXECUTION OF SELECT STATEMENT WITH UNION CLAUSE .
IY07209'FETCH FIRST N ROWS ONLY' WAITS A WHILE AFTER N TH ROW DISPLAYED
IY07499SQL0443N WHEN EXP2 IS GREATERTHAN EXP1 IN LEFT/RIGHT()
JR12938COMMAND CENTER/NT TRAP AFTER ISSUED 'CONNECT TO <DB' WITH INCORRECT ID AND PASSWORD # OF TIMES IN A ROWS.
JR13185JAVA APPLICATION RECEIVING SQL0502 DURING NORMAL COURSE OF OPERATION
JR13902ROWSTATUS ARRAY INCORRECT WHEN -911 (DEADLOCK) OCCURS.
JR13908BETTER FILTER FACTOR FOR 'CONST = CONST' PREDICATES AND QRW NEEDS TO ELIMINATE OR(1=0) PREDICATES.
JR13925HANG DUE TO SEMAPHORE WAIT CONDITION DURING SQLALLOCCONNECT
JR13980CC ROLLFORWARD TO POINT-IN-TIME ACTUALLY ROLLS FORWARD TO END OF LOGS
JR13983SQJ BINDS PACKAGE REGISTER WITH INCORRECT DATA TYPE (SQL0804)
JR13999LOCKING INCORRECT USING DB2 CLI KEYSET CURSOR
JR14003CALLING A STORED PROCEDURE FROM A V6.1 CLIENT (FROM A CLI APPLICATION) RESULTS IN SQL0804 WITH RC=103
JR14004NEW INSTALL OPTION TO PREVENT DB2PERF.DLL FROM BEING REGISTERED
JR14033TRAP USING FETCH FIRST N ROWS - IN SQLDROWFETCH
JR14046SQL2048 RC 4 CORRUPTED HISTORY FILE . GARBAGE COLLECTION USING NUM_DB_BACKUPS TRUNCATES TABLESPACE NAMES OF MAXIMUM LENGTH (18)
JR14047ADO KEYSET CURSOR PROBLEMS WHEN PARSING DOUBLE CONSTANTS
JR14053OPTIMIZEFORNROWS CLI KEYWORD DOES NOT CHECK FOR DUPLICATE
JR14057SQL1403 FROM CREATE DATABASE WHEN AUTHENTICATION = SERVER_ENCRYPT
JR14077DB2/OS2: DB2SYSC.EXE TRAPS IN _UFREE (C RUNTIME) CALLED FROM _REGEN_EXCEPTION CALLED FROM SQLOADDENVSTRING
JR14078CURSOR WITH HOLD NOT WORKING FOR SQLJ AND DB2 6.1
JR14082FIX 12-BYTE MEMORY LEAK FOR NON-BLOCKED CURSORS
JR14083FIXING THE LOGIC FOR CHECKING IF MORE SNA LRS NEED TO BE RECEIVED IF DATA IS TRUNCATED.
JR14091DB2START HANGS AFTER MIGRATION USING DB2MSCS.EXE
JR14095TRAP WHEN USING KEYSET CURSORS
JR14125OS2 ONLY: TRAP IN GETENV() WHEN REFERENCING DAYNAME , MONTHNAME UDFS
JR14152SQLJ EXHAUSTS CURSOR HANDLES AFTER 11613 STATEMENTS CLI0129E NO MORE HANDLES IS RETURNED
APAR fixes included in WR21162b (Fixpak 2b)
APARABSTRACT
IY04404DB2CLI.INI PASSWORD SETTING (PWD) OVERRIDES AUTOLOADER.CFG PASSWORD SETTINGSO THAT DB2ATLD FAILS TO CONNECT TO DB
IY05591DB2 LOOPS, THROUGHT 2 LOG FILES, DURING ROLLFORWARD COMMAND
IY05871DLFM RETRIEVE_QUERY FAILS WHEN CMD LINE OPTIONS GIVEN BUT PROMPTS AND WORKS WHEN NO OPTIONS SPECIFIED
IY06278EXPORT TO SELECT STATEMENT RETURNS SQL3022N ERROR WHEN SELECT STATEMENT RETURNS A WARNING '347'
IY06328JDBC APPLICTION WAS CRASHING DUE TO AN INVALID MEMORY COPY OPERATION IN THE NATIVE METHOD SQLBINDNUMERIC
IY06411'REORGCHK CURRENT STATISTICS ON TABLE ALL' OMITS ONE OF THE SCHEMAS.
IY06434FIRST DB2START FAILS AFTER AIX V4.3 REBOOT
IY06482SQLPUTDATA DOES NOT WORK ON HP FOR BLOB DATA
IY06596SQL0901N - NON-SEVERE SYSTEM ERROR AT SQLNO_FF_GET_COL_INFO 80 WHEN EXTERNAL KEY SPECIFIED
IY06599QUERY WITH UNION OVER JOINS GIVES WRONG RESULT
JR13900APPLICATION SNAPSHOT SHOWS SAME CLIENT PID'S. COORDINATING AGENT TID'S ARE CORRECT.
JR13917A CREATE DB SCRIPT FAILED WITH ERROR SQL1024 ON GERMAN M/C(NT+DB 2 V6.1)
JR13980CC ROLLFORWARD TO POINT-IN-TIME ACTUALLY ROLLS FORWARD TO END OF LOGS
JR14001STRING CONVERSION NOT THREADSAFE IN JNI.
JR14002SQLCOLUMNS FAILS IF TABLE LENGTH PLUS ESCAPE CHAR > 18
JR14025SQL3181W WARNING GENERATED ON LOAD FOR A VALID IXF FILE
JR14034UDB INSTANCE CRASHES. TRAP IN BSORTGETFIRSTPARTIALKEY FUNCTION
JR14059PATCH2=18 FAILS WITH SQL0804N WITH EMPTY STRING LITERAL TO HOST DB
APAR fixes included in WR21162a (Fixpak 2a)
APARABSTRACT
IX77854SQL0901 DIAG FILE REPORTS ERROR IN BUFFER QUEUE SERVICES PROBE:30 SQLKQ_DETACH_BUFFER(). INTERNAL ERR 'LOST BUFFER'
IX83660SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS
IX87116DB2BATCH OPTION TO SPECIFY COLUMN DELIMITER
IY03544CREATE DATABASE ON LARGE NUMBER OF NODES MAY HANG
IY03678TRAP INDICATING SQLFXSYS_X AS FAILING FUNCTION.
IY03698CLI ARRAY INSERT PROBLEM WHEN ALL FIELDS IN A RECORD ARE NULL
IY03820REMOVE DB2START CALL FROM DB2EXFMT
IY04221EXPLICIT CONNECT FAILS WITH SQL1403 ON AIX
IY04339TRAP IN LOAD WHEN TEMP SORT FILE > 2GB SQLU_SMGETFREEPG()
IY04496DB2LOOK UTILITY MISTAKES IN THE HELP TEXT WITH THE -H OPTION
IY05069CASE/SUBSTR FUNCTION FOR AST'S
IY05294DB2DARI PROCESS COUNTER NOT DECREMENTED IN CASE OF ABEND
IY05347V61 VIA JDBC RETURNS WRONG VALUEAT SECOND SELECT TIME FOR SAME ROW SAME COLUMN. COLUMN IS BIGINT OR SMALLINT TYPE
IY05361CHECK GATEWAY VERSION FOR SQLDESCRIBEPARAM TO DB2 5.1.2 MVS
IY05416USEREXIT,DB2UEXT2,NOT COPIED TO /ADM/ IN MIGRATION FROM V5 TO V6
IY05751SQLBINDPARAMETER WITH IBSCALE CHANGING ONLY - DB2 SHOULD IGNORE THIS AND NOT 'RE-DESCRIBE' THE COLUMN. RESULT - CLI0109 ERROR.
IY05826REMOTE MONITORING DOES NOT WORK FROM A CLIENT AGAINST UDB 5.2/HP-UX SERVER.
IY05892CLP THROUGHPUT IMPROVEMENTS
IY05913DB2ATLD BOUNDARY CONDITION CRASH IF LINEFEED IS ON A MULTIPLE OF THE 32K DATA FILE
IY05980CTRL-C APPLICATION CAUSES TRAP IN SQLEIAGT_CB
IY06032DB2CKMIG MIGRATION FAILS (DATABASE DOESN'T EXIST) EVEN THOUGH DATABASE EXISTS.
IY06047SQL0902C RC=100 WHEN SELECTING FROM EXCEPTION TABLE AFTER LOAD.
IY06094SQLJ: DB2PROFC COMMAND WITH PRECOMPILE OPTION QUALIFIER <SHEMA N AME> GIVES SQL0204N
IY06127SEGV IN SQLIUNDO AFTER UNDO IS INCORRECTLY INTERRUPTED. DB2 RESTART FAILS.
IY06145ASCII FUNCTION RETURNS INCORRECT OUTPUT
IY06163NON-SELECT STATEMENT ISSUED THROUGH CLI BRINGS DOWN DATABASE ON COMMIT
IY06187LOAD TRAPS (SQLBLOADGETEXTENT) IN ERROR PROCESSING..
IY06215SQL0998 RETURNED TO CICS APPLICATIONS ISSUING STATIC ROLLBACKS, OR STATIC COMMITS.
IY06323TRANSACTION STILL HOLD LOCKS IN CRASH RECOVERY MESSAGES IN DIAG ARE EXTRANEOUS, AS THE LOCKS ARE ACTUALLY REMOVED.
JR13611ISSUING 'UPDATE DBM CFG USING FEDERATED YES' SHOULD RETURN AN ERROR IN UDB V6.1 AS THE DATAJOINER SUPPORT IS NOT INCLUDED
JR13750MULTIPLICATION OF DECIMAL CONSTANT GIVES INCORRECT RESULT
JR13824JAVA I/O EXCEPTION ON WRITE TO BLOB OBJECT FROM STORED PROC
JR13880RETURN THE ODBC SCALAR NUMERIC FUNCTIONS SUPPORTED BY DB2/MVS
JR13909DB2LOOK INSERTS COMMAS INTO DDL INSTEAD OF DECIMAL POINT FOR FLOATING POINT NUMBERS IN CERTAIN LOCALES/TERRITORIES
JR13917A CREATE DB SCRIPT FAILED WITH ERROR SQL1024 ON GERMAN M/C(NT+DB 2 V6.1)
JR13949DEFFERRED PREPARE RETURNS OPEN CURSOR FOR LARGE RESULT SETS.
JR13974FILTER FACTOR FOR ALWAYS-TRUE PREDICATE CAUSE SLOW QUERIES
JR13976DBA1613 WHEN RESTORING DB USING VENDOR DLL IN CC
JR13977DUPLICATE TABLESPACES RETURNED IN EEE ENVIRONMENT
JR13990COMMIT FAILS WITH -902 RC=29 (FATAL LOGIC ERROR)
JR14019ADD FOREIGN KEY DIALOG IN CC IS NOT POPULATING THE PRIMARY KEY BOX INITIALLY
APAR fixes included in WR21162 (Fixpak 2)
APARABSTRACT
GG03953ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K
GG03961ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K
GG03971GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED
GG03972SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
GG03974SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS
GG03977GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED
GG03978SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
GG03979SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS
GG03980-1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS
GG03981-1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS
GG03982MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL
GG03983MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL
GG03984FORWARD FIT V5 APPLY APARS.
GG03985FORWARD FIT V5 APPLY APARS.
IC24358CHECKIN DJRA.EXE INTO UDB V6.1
IC25192DB2 UDB VERSION 6.1 ON LINIX - DB2START HANGS DUE TO A CHANGE MADE BY RED HAT TO THEIR DYNAMIC LINKER.
IX88801PARALLELISM NOT WORKING WITH ODBC APPS TO MVS 5.1.1
IY02032TABLE ACCESSABLE AFTER ROLL FORWARD THROUGH AN NONRECOVABLE LOAD
IY03608DB MARKED BAD AND BROUGHT DOWN WHEN LOAD INTO TABLE WITH RI.
IY03903AFTER A TABLESPACE RESTORE, A 'ROLLFORARD QUERY STATUS' DOES NOT SHOW INFORMATION IN THE 'NEXT LOG TO BE READ' FIELD.
IY04033INCORRECTLY PARSING AUTOLOADER INPUT PARAMETERS.
IY04311LIBDB2.SO NEEDS TO BE A DEPENDENCY OF LIBDB2LICM.SO
IY04410ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K
IY04411ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K
IY04412ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K
IY04471-902 FROM SQLRIGTQ
IY04651SQL2519N ON MIGRATION TO V6. ERROR '-902' WITH TOKENS 'FIXUP SYSTRIGGER: FETCH SYSTABLES (-27) DMS RC=FFFFF840'
IY04909SIGNAL #4 TRAP DURING BUILD PHASE OF LOAD
IY04947SQLCODE -433 RETURNED ON A BUFFERED INSERT
IY04961OPTIMIZE FOR 1 ROWS PERFORMS A TABLE SCAN INSTEAD OF INDEX SCAN
IY05040TRAP, SIGNAL #11, IN THE OPTIMIZER, SQLNO_CRULE_STARJN_AND().
IY05115SELECT COLUMN LIST > 4005 AND ORDER BY CAUSES SQL1224.
IY05176DBM CRASHES DUE TO A SIGNAL #11 IN SQLVDECADDEC
IY05192SQLSTATISTICS() QUERY FAILING WITH CLI0165E ERROR IN ROW
IY05198DMBILIST FOR V6 IAV EXTENDERS REPORTS VERSION 5 IAV EXT....Ù
IY05315BAD ACCESS PLAN FOR WHERE <COL> IN (VAR1,VAR2....VARN)
IY05359SNAPSHOT FOR APPLICATION REPORTS SQL10007 IN THE STATEMENT TYPE FIELD
IY05364FORWARD FIT V5 APPLY APARS.
IY05406JAVA INSERT USING SETSTRING TO DECIMAL COL TRUNCATES DECIMALS
IY05426SQL1034N FOLLOWED BY INTERRUPTING ROLLBACK OPERATION
IY05438MIGRATION SETS THE SOFT FILE SIZE TO A MAXIMUM FILE SIZE.
IY05446ADD PATCH VALUE TO RETURN TRUE ISO TIMESTAMP FORMAT FROM CLI
IY05481VALUE FOR THE REFERENCE TYPE COLUMN DOES NOT REQUIRE A CAST TO THE REFERENCE TYPE IN A TYPED TABLE
IY05483FIX FOR SPM ON SUN ULTRASPARC (SUN4U) ARCHITECTURE
IY05553SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
IY05554SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
IY05555SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
IY05608CLI_MEMFREE TRAPS IN CLI_DSTFREEINFO WHEN OUT OF MEMORY
IY05612SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
IY05626ORDER BY VARGRAPHIC(),VARGRAPHIC() DOES RETURN CORRECT RESULT SET ORDER
IY05656SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS
IY05658SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS
IY05659SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS
IY05660SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS -1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS
IY05662-1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS
IY05663-1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS
IY05664-1 IN ASN.IBMSNAP_APPLYTRAIL BUT NO MESSAGE TEXT APPEARS
IY05671MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL
IY05672MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL
IY05673MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL
IY05674MESSAGE WHEN APPLY ENCOUNTERS TABLESPACE FULL IS NOT MEANINGFUL
IY05815ASNLOAD FAILED WHEN THE TABLE INCLUDED CLOB COLUMN OF LENGTH GREATER THAN 32K
IY05816FORWARD FIT V5 APPLY APARS.
IY05817FORWARD FIT V5 APPLY APARS.
IY05818FORWARD FIT V5 APPLY APARS
IY06097SQLBINDPARAM CALL COREDUMPS AFTER SELECT IS DONE, THEN ARRAY INS ERT IS ATTEMPTED.
JR13711CLI0118E ON 'SELECT{FN CONCAT(SUBSTRING('ABC',1,2),'B')} FROM T1
JR13713SQL0804N WHEN INPUT PARAM TO STORED PROC ON HOST IS NULL
JR13757DB2 IGNORES NULL INDICATOR ON OUT STORED PROC PARAMS
JR13775CREATION OF DMS TABLESPACE VIA CONTROL CENTER INCORRECTLY CALCULATES TOTAL NO. OF PAGES WHEN PAGESIZE NOT 4K.
JR13840SQLFREESTMT(SQL_CLOSE) TRAPS WITH KEYSET CURSOR AND LOB
JR13862DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT
JR13879DB2 CONNECT GATEWAY TRAPS WHEN USING DOWNFIX CLIENT DURING STORED PROCEDURE CALL TO DB2 MVS.
JR13882TRAP IN SQLNO_PROP_BEST_SORT_KEY RUNNING QUERY ON VIEW.
JR13927IMPLEMENT NEW BIDI LAYOUT TRANSFORMATION ROUTINE WITH MORE STRIN GENT ERROR CHECKING, MEMORY ALLOC, AND BIDI CCSID STRING TYPES.
APAR fixes included in WR21135c (Fixpak 1c)
APARABSTRACT
IY02571SQL0433 DURING INSERT VALUES, LINEFEED CHANGED TO SPACE
IY02572LANG=JA_JP.IBM-932OR JA_JP.IBM-943SYMBOLIC LINKS NEEDED
IY03379DB2NODE ENVIRONMENT VARIABLE DOES NOT WORK FOR ALL CMDS IF PRTN NUM SPECIFIED IS NOT ON THE SAME PHYSICAL NODE.
IY03805PROBLEMS WITH NIS AND GROUP LOOKUPS ON AIX 4.3.2 DEFECT #124182
IY04414DARI PROCESS DOES NOT PICK UP GROUP ID FROM .FENCED FILE
IY04769NODEXXXX AND CATNXXXX NOT UPDATED CORRECTLY ON BACKUP IMAGES EXTRACTED FROM ADSM WITH DB2ADUTL
IY04893SETTING DB2_MMAP_READ PROBLEM COULD PREVENT FIRST CONNECT
IY04917SIZE IN SNAPSHOT HEADER INCORRECT IN MPP ENV IF ACTIVE STATEMENT
IY05051CATALOG CACHE MAY CAUSE LONG LOCKS TO BE HELD IN SYSTABLES
IY05198DMBILIST FOR V6 IAV EXTENDERS REPORTS VERSION 5 IAV EXT....Ù
IY05483FIX FOR SPM ON SUN ULTRASPARC (SUN4U) ARCHITECTURE
JR13217SQLGETINFO(SQL_ORDER_BY_COLUMNS_IN_SELECT) REPORTS 'N' INSTEAD OF 'Y' FOR DB2/390 V5.1
JR13547CLI0606 WHEN RETRIEVING DECIMAL DATA WITH GETDOUBLE CALL FROM NT FOR SPANISH
JR13604STORED PROCEDURE BUILDER WITH A SP WITH A DATE INPUT PARAM WILL BUILD OK BUT ON EXECUTE, IT WILL EXIT WITHOUT ANY ERRORS.
JR13653JDBC APPS AUTOCOMMIT IF STORE PROCEDURE CALL IS MADE. EXPLICIT ROLLBACK NOT POSSIBLE AFTER STP CALL.
JR13684SQL0901 IN FUNCTION SQLNO_SMP_CREATE_SHARED_SO
JR13755SQLEXECUTE TRAPPING WHEN KEYSET CURSORS USED
JR13758KEYSET CURSOR FAILS TO UPDATE WHEN NULL VALUES ARE IN THE RESULTSET.
JR13783PARMLIST SYNTAX ERROR ON STORED PROCEDURE CALL TO MVS
JR13827SQLSTATISTICS AND SQLDRIVER CONNECT TAKE LONGER TO COMPLETE IN DB2 V6.1 THAN IN DB2 V5.2
JR13858CLI PERFORMANCE IMPROVEMENT WHEN AUTOCOMMIT ON
APAR fixes included in WR21135b (Fixpak 1b)
APARABSTRACT
IX87013TEMPORARY FILES ARE CREATED USING BLOB WITH JAVA PROGRAMS
IY02464-901 INDICATING BANDP NOT PUSHED DOWN
IY02862OUT OF SPACE IN THE DLFM_BACKUP_DIR_NAME NOT DETECTED
IY03133SQL0901 'UNEXPECTED COLUMN USAGE TYPE' ON DELETE OPERATION ON TX ENABLED TABLE DUE TO TX TRIGGERS.
IY03393UNINITIALIZED MEMORY IN OPTIMIZER CAUSES SIGNAL #11 IN (SQLNO_CO PY_SETN,SQLNO_UNION_SETN)
IY03630RECONCILE SQL2554 DOES NOT GIVE DLFM SERVER NAME.
IY03631DB2_RECON_AIDPACKAGING IN EE
IY03698CLI ARRAY INSERT PROBLEM WHEN ALL FIELDS IN A RECORD ARE NULL
IY03820REMOVE DB2START CALL FROM DB2EXFMT
IY03823NIS: CONNECT ... CHANGE PASSWORD 'FAILS' WITH SQL1403N. WAIT TIME IS NECESSARY FOR PASSWORD TO REFRESH BY NIS SERVER.
IY04240CERTAIN QUERIES THAT RAN ON V5 RETURN SQL0101 - QUERY TOO COMPLEX ON V5.2.
IY04279WE DO NOT FETCH DATA PROPERLY FROM CHAR(255) COLUMN ON MVS - DATA GETS TRUNCATED AS WE EXPECT IT TO BE MAX 254 CHAR LONG
IY04291-901 IN SQLRI_CLOSE_UDF_EOT(), -1034 DBM CRAHES
IY04399TRAP, SIGNAL #11, IN THE DB MONITOR, I.E. DURING COLLECTION OF TABLESPACE COUNTERS.
IY04409SIG#11 IN SQLSFETC
IY04431MIXED EMBSQL/CLI APP CORE DUMPS ON SQLDISCONNECT
IY04446CLI0002W WITH CLOB DATA WITH GETSTRING IF SELECT OTHER TYPE 1ST.
IY04502DB2CLI.H HEADER INCORRECT FOR SUN
IY04555KEYSET CURSOR PARSING DOES NOT HANDLE <> CORRECTLY.
IY04557DB2CAT FAILS WITH SQL0811 WHILE DUMPING THE RI DESCRIPTOR
IY04694LARGE SELECT AGAINST DB2/MVS 5.1.2 RESULTS IN -502
IY04732SQL0902 RC=126 AT DROP TEMP TABLESPACE
IY04798TRUST APP IS USING AN INVALID MEMORY ADDRESS
JR13441INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED
JR13645SQLCOLUMNS RETURNS INCORRECT INFORMATION FOR DEFAULT VALUE
JR13700DB2DARI GROWS FOR PARAMETER STYLE JAVA STORED PROCEDURE
JR13708CLI APP TRAPS WHEN CLI TRACE IS ON AND SQLFETCH RETURNS != SQL_SUCCESS
JR13736SQLDESCRIBEPARAM FAILS ON DEFERRED PREPARE OF >= 26 COLUMNS.
JR13753JDBC SETBYTES() MEMORY OVERWRITE IF INPUT VALUE LARGER THAN COLUMN WIDTH.
JR13762TRAP IN SQLEX_RDS_GEN_DATA.
JR13782DOSSLEEP(0) PREVENTED DB2 THREADS FROM DOING WORK WHEN HIGHER PRIORITY THREADS WERE RUNNING.
APAR fixes included in WR21135a (Fixpak 1a)
APARABSTRACT
IX89397DB2 UNIX TRAPS ON CONNECT FROM EMB SQL IF DB2INSTANCE NOT SET
IX89959CACHE STORED PROCEDURE DESCRIBE INFORMATION
IY00980BACKUP FAILS WITH SQL1062 BECAUSE OF LINKS IN THE DB PATH
IY01190ROLLBACK OF CREATE TABLESPACE WITH > 1 CONTAINER NEVER UNTAGS CONTAINERS PAST THE FIRST ONE
IY01210DB2GOV MISSING DB2GOVD VALIDATE IF STARTING ON ONE NODE
IY01489LOG EXTENT 0 (S0000000.LOG) REQUESTED BY DB2 WHEN THE LOG SEQUENCE IS WELL PAST, IE. IN THE THOUSANDS.
IY01841RELEASE SHARE LOCKS ACQUIRED ON SYSTABLES DURING COMPLIATION OF SQL STATEMENTS
IY02556CC: JOURNAL REPORTS INCORRECT JOB STATUS
IY02569TRAP AT BEGINNING OF ONLINE BACKUP IN SQLUBCKA
IY02618DB2 CONNECT GATEWAY TRAPS IN SQLJMF10.
IY02730CLI DRIVER DOESN'T HANDLE LARGE STATEMENT SIZES CORRECTLY.
IY03175EXCESSIVE MESSAGES IN DB2DIAG.LOG
IY03229FENCED DB2DARI PROCESS LEAKS 4K OF MEMORY PER INVOCATION
IY03447SUN: ADD SUPPORT FOR GETGROUPSBYMEMBER CALL TO SPEED UP GROUP ENUMERATION - VERSION 6 ONLY
IY03454DB2 UDB - FIRST EXECUTION OF THE SIN UDF RESULTS IN SQL0443, RC 03. OTHER 'MATH' UDFS MAY ALSO EXPERIENCE THIS ERROR.
IY03510RESTORE FAILS WITH AN SQL0298N WHEN THE SAME CONTAINERS EXIST IN THE SQLNNNNN DIRECTORY... CANNOT REDIRECT THE RESTORE.
IY03529RUNNING DB2EMPFA WHEN SMS TABLES GREATER THAN 4G EXIST CAN CORRUPT DATA.
IY03602SQL0980C BAD PAGE ENCOUNTED DURING LOAD RESTART
IY03861APAR USED TO CREATE PTF FOR DB2 V5.0 FOR AIX
IY03885EVENT MONITOR WITH AT NODE DOES NOT FILTER EXISTING CONN
IY04046JDBC TRAP IF APPLICATION USES INVALID CONNECTION HANDLE
IY04157SET CURRENT PACKAGESET PRODUCES A SIGSEGV FROM WITHIN SQLJ
IY04168APAR USED TO CREATE PTF FOR DB2 V6.1 FOR AIX
IY04196LOG FULL CONDITION WITH NODE LOG SYNC WILL CAUSE DB2 TO PANIC AN D CRASH.
IY04225INFINITE LOOP IN DB2GOVD DURING ERROR HANDLING IF DB2GOV LOG FILES ARE REMOVED. INFINITE ERRORS TO STDOUT.
IY04242LOG FULL CONDITION DID NOT SAVE ENOUGH LOGSPACE FOR A TRANSACTION TO BE ROLLED BACK.
JR12656ODBC SQLTABLEPRIVILEGES DOES NOT RETURN THE PUBLIC PRIVILAGES
JR12796SQLCOLUMNS() CALL WITH ONLY TABLE NAME DISREGARDS SCHEMALIST AND CURRENTSQLID
JR12926JAVA GETSCHEMA RETURNS NULL WHEN USING OPTIMIZED CATALOG
JR13123WHEN USING BLOB LOCATORS, SQLGETPOSITION FAILS WITH CLI0102E INVALID CONVERSION SQLSTATE=07006.
JR13169#DELETED GETS DISPLAYED IN MS ACCESS WHEN DISPLAYING A DB2 TABLE THAT HAS A PRIMARY KEY ON A DATE COLUMN OR DECIMAL COLUMN
JR13334TIMESTAMPDIFF ODBC FUNCTION DOES NOT GET NEGATIVE VALUES RETURNED WHEN CALLED IN DB2 CLI/ODBC.
JR13427CHANGING ISOLATION LEVEL AFTER EXECUTE CAUSES ERROR ON NEXT EXECUTE
JR13475RETRIEVING A CLOB SUB-STRING GREATER THAN 32KB TRAPS ON THE GATEWAY.
JR13481SQL_CURSOR_STATIC CURSORS NOT BEING CLOSED AFTER SQLCANCEL()/SQLFREESTMT(SQL_DROP)
JR13499RECOGNIZE '\' ESCAPE CHARACTER IN SCHEMA QUALIFIERS
JR13502RESTORE OF A V5.2 (FP9/8) DATABASE IN V6.1 RETURNS AN SQL2548N ERROR MESSAGE - CODEPAGE OF BACKUP DOES NOT MATCH ONDISK CODEPG
JR13545DB2 UDB - SQLESRSP MARKS THE DATABASE AS BAD FOR ANY NON-ZERO RC FROM SQLRRAFI. SHOULD ONLY MARK DB BAD FOR CERTAIN NON-ZERO RC'S
JR13610ERROR LOGGED FOR SQLOFMBLK WHEN USING PREPARED STATEMENTS
JR13630SQLPLRL() TRAPS AS SQLRLGTS() NOT CLOSING CURSOR
JR13633TRAP IN MONITOR SNAPSHOT
JR13661SQL0605W WHEN CREATING TWO BI-DIRECTIONAL INDEXES WHICH USE THE SAME SET OF COLUMNS.
JR13667DB2JDBC.DLL TRAPS WHEN RUNNING WEBSPHERE IN VISUALAGE JAVA
JR13675RI PACKED DESCRIPTOR OVERFLOW IS CAUSED BY TABLENAMES > 18 CHARA CTERS
APAR fixes included in WR21135 (Fixpak 1)
APARABSTRACT
IX67422NO REASON CODE IN DB2 MSG WITH SQLCODE -913.
IX71710RECLAIMED TOO MUCH LOG SPACE APPEARS DURING CRASH RECOVERY
IX73726V501: -407 SQLCODE CAUSES -984 WHICH MARKS DATABASE BAD
IX76365SLOW PERFORMANCE
IX79991CLI CHANGE: REPLACING LITERAL WITH PARAMETER MARKER IN INSERT
IX80640DB2LOOK DDL TRIES TO CREATE THE INDEX AFTER THE PRIMARY KEY CONSTRAINT WHEN KEY WAS DEFINED ON A PRE-EXISTING INDEX
IX81341DB2CKMIG SETS LOCALE AND MESSAGES PATH WHEN IT SHOULD ONLY SET THE MESSAGES PATH (RESULT CAN BE A FAILURE TO MIGRATE V2 TO V5)
IX81525SQLALLOCSTMT FAILS MEMORY CLEANUP IF OUT OF MEMORY
IX81764DB2ATLD (NEW AUTOLOADER) DOES NOT RETURN A NON-ZERO RETURN CODE IF AUTOLOADER FAILS
IX81831INDEX BUILD PHASE HUNG ON LOAD
IX81849SQLESETC API USES WRONG CONTEXT IN MULTITHREADED CLI APPS
IX82027IMPORT CAN HANG SYSTEM IF THE INPUT FILE ROW COUNT IS AN EXACT MULTIPLE OF THE COMMITCOUNT
IX82054NEW AUTOLOADER DB2ATLD ISSUES SQL3326 IF A LIST OF COLUMN NAMES ARE SPECIFIED AND ONE OF MORE NAMES ARE 18 CHARACTERS
IX82394SQL6107 WHEN TRYING TO LOAD PRE-SPLIT DATA.
IX82397DB2BATCH -O R 0 DOES NOT IF BLOB DATA IS SELECTED
IX82487OFFLINE BACKUP RETURNS SQL1042C OR SQL1084C
IX82508PATCH2=6 DOES NOT PREVENT A SCROLLABLE CURSOR TYPE
IX82599DB2 UDB RACE CONDITION IN DB2LICD. LEADS TO REMOVAL OF IPC Q 0 (USUALLY!). UNLIKELY ON NON-MLNS, POSSIBLE ON MLNS.
IX82851DB2 UDB EEE C980509 (LIKELY ALSO AFFECTS EE) RESTART FAILURE WITH RC=-2777 CAUSING SQL1042C
IX82992CALLS SQLCOLUMNS() ON VIEWS RETURNS 0 COLUMNS ON ANY VIEW THAT ENCOUNTERS SQL0437.
IX83002-1042 (SYSTEM ERROR) ON ROLLFORWARD
IX83063JDBC NEGATIVEARRAYSIZEEXCEPTION() ON EXECUTEQUERY() IF UPDATE MAKES NO CHANGES.
IX83068DB2AUTOLD LOOPS WITH JA_JP ENV
IX83104ESTORE PROBLEMS DUE TO AIX MEMORY SEGMENTS NOT ATTACHING TO OPTIMUM POSITIONS.
IX83180WHEN RUNNING THE OUTPUT OF DB2UIDDL, AN SQL0956C IS RETURNED INDICATING DBHEAP IS EXHAUSTED.
IX83197DB2ATLD MAY USE HOSTNAME FOR SOME COMMUNICATIONS, SHOULD ONLY US E DB2NODES.CFG ENTRIES
IX83272NEGATIVE RETURN CODE -502 CAUSES TRAP IN SQLJIFSR.C
IX83408FAILING BACKUP NOT RECORDED IN HISTORY FILE
IX83441THE DB2DIAG.LOG SHOWS A NO TEMP AVAILABLE ERROR MESSAGE AND A TABLESPACE STATE TRANSITION ERROR 'FFFF8138'
IX83505ON HP-UX, DB2SETUP FAILS TO CREATE AN INSTANCE WITH DBI1720E WHILE NIS IS RUNNING... USERID AND GROUP ALREADY EXIST.
IX83539-902 ON CREATE/DROP TABLE WHEN OUT OF DBHEAP
IX83547DYNAMIC DROP TABLE WAITS ON A INSERT THAT HOLDS AN NS LOCK IN SYSUSERAUTH
IX83555XA_END(TMSUSPEND) RETURNS XA_ERPROTO.
IX83583LOAD INSERT AFTER MIGRATION CAUSES TABLE CORRUPTION
IX83660SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS
IX83662SIGNAL#11 IN SQLKD_RCV_DATA
IX83716TRAP IN SQLRAGSN. CLIENT INTERRUPTED WHILE BINDING TO THE DB TRAPS THE SERVER.
IX83733DB21080 REDIRECTED RESTORE IS CASE SENSITIVE RE: DB ALIAS
IX83869CATALOGING MORE THAN 8 ODBC DATASOURCES FROM SCRIPT GIVE ERROR
IX83953DB2JD SHOULD NOT READ LENGTH INDICATOR FOR OUTPUT ONLY PARAMETER
IX84081TRAP IN SQE
IX84082CUSTOMER CAN'T RUN A JAVA STORED PROCEDURE MORE THAN ONCE WITH SOLARIS 2.6 AND JDK 1.1.6 WITHOUT RESTARTING UDB
IX84273THE 'DB2BATCH' PERFORMANCE TOOL SHOULD TRIM THE TRAILING BLANKS FROM THE LAST COLUMN IN THE OUTPUT.
IX84329LENGTH OF OUTPUT SQLVAR IS NOT INITIALIZED
IX84478TIMESTAMP RECIEVED AS STRING SHOULD RETURN AS LENGTH 26
IX84552WE WERE CHOOSING A MGJN PLAN OVER A NLJN THAT WE USED TO CHOOSE IN V500. MGJN PLAN RUNS IN 300 SECONDS AS OPPOSED TO 3 SECONDS.
IX84565SQL0437W WARNING MESSAGE CAUSES EXPORT OPERATIONS TO FAIL.
IX84582CLP LIST TABLESPACES SHOW DETAIL DOES NOT AUTO-COMMIT.
IX84780DB2_ALL HANGS WHEN INPUT REQUIRED
IX84790SQL10003C ERROR WITH DB2/UDB FOR AIX DUE TO MEMORY LEAK.
IX84896LOG ERROR WHEN DOWNLEVEL JDBC CLIENT COMING TO JDBC SERVER
IX84950JDBC DRIVER OVERRIDES THE CLI SETTING FOR CURSORHOLD.
IX85099V5.2 NT/W98 CLIENTS TO GATEWAY TRAPING AFTER 3-4 CONNECTIONS
IX85148-902 SQLCODE ON ROLLFORWARD OF TABLESPACE TO POINT IN TIME
IX85171LOAD WITH DB2 UDB V5.2 ON HP-UX 11 SMP HAS POOR PERFORMANCE...
IX85192SQLO902 RC 26 SQLO_NOMEM_UND IN SQLRIUIN (CRASHES DB)
IX85342SIGNAL 11 IN SQLRA_FIND_SHIP_VAR (#11)
IX85415DB2 DOESN'T LINK IN THREAD SAFE CPIC LIBRARY FOR DB2DCPIC_IBM.A
IX85558SQL_ATTR_RETRIEVE_ROW IS STILL RETRIEVING DATA EVEN IF OFF.
IX85645EXECUTEUPDATE METHOD IN JDBC STILL RETURNS -1 IF NO ROWS WERE UPDATED. THE PROBLEM IS PRESENT ONLY IN JDBC NET DRIVER.
IX86007SIGNAL#11 IN SQLULADDINXKEYS
IX86031IN DB2/UDB - 'LIST HISTORY REORG SINCE' DOES NOT REPORT ALL VALID ENTRIES.
IX86221DB2 5.2: RESTORE HANGS
IX86244USE SQLOINSTANCEPATH() TO LOWER NUMBER OF CALLS TO PASSWORD FILE
IX86368SQLJMF10 TRAPS WHEN SENT A NULL POINTER IN DB2RA.
IX86413DB2 - UDB: SIGNAL 11 TRAPS AFTER HITTING AN ERROR IN SQLRXGET AND SQLRXPUT IN THE DIAG.
IX86439AUTOLOADER GENERATES 'SEVERE ERROR' WHILE SPLITTING DATA. HOWEVER THE LOAD COMPLETES SUCCESSFULLY BUT DATA IS MISSING.
IX86457SIGUSR1 IS IGNORED IN SNA/6000 V3 AND LATER
IX86498FIX LATCH/UNLATCH OF AGENT_LIST_LATCH IN SQLEGETAGENTFROMPOOL
IX86517LOAD TRAPS IN BUILD PHASE WHEN UTIL HEAP RUNS OUT OF SPACE.
IX86733DB2SETUP : INSTANCE CREATE FAILS DURING TCPIP CONFIG
IX86742TURKISH CODEPAGE: USERIDS CONTAINING THE LETTER I ARE INCORRECT- LY TRANSLATED BY DB2 INTERNALLY RESULTING IN AUTH. FAILURE.
IX86861SETNULL CAUSES TRAP WITH TIMESTAMP,TIME,DATE,BIGINT AND STREAMS
IX86967DB2 USING TOO MUCH SWAP SPACE ON SOLARIS.
IX86970NOT ENOUGH LOG SPACE RESERVED IN REORG
IX86991EXPORT NOT PARSING MODIFIED BY DELIMITERS WHEN USING WITH PROPERLY
IX87048INTERMITTENT SQL0290 DURING EXECUTION OR BIND
IX87063SQL1072 ON DB2START - FTOK CAN'T GENERATE UNIQUE IPC KEYS ON SOLARIS UFS WITH NEW DIRECTORIES WHEN RANGE OF INODES IS HIGH
IX87124SUN: ALLOCATION OF LARGE BUFFERPOOLS USING SOLARIS 2.6 (>1.6G) MAY FAIL WHEN INTRA_PARALLEL IS ON.
IX87172POOR PERFORMANCE BECAUSE STAR JOIN NOT SELECTED
IX87280ROLLFORWARD FAILS WITH SQL1271W WHILE REBALANCING
IX87362QUERY WITH 'IN' PREDICATE RETURNS WRONG RESULT
IX87376DB2PROFC TRAPS WHEN INVALID PREPAREOPTION SPECIFIED
IX87446UDF NOT MAKING FINAL CALL WHEN IT TERMINATES ABNORMALLY
IX87450FILE MANAGER EXPORT CONTROL FILE NOT BEING CREATED WHEN SPECIFIC COLUMNS SPECIFIED IN THE SELECT FROM THE EXPORT.
IX87463MULTIPLE LOGON WINDOWS WITH MSACCESS WHEN NO UID/PWD INPUT
IX87478SQLUGRPI CALL RETURNS SQL6044N
IX87540INVALID ROW COUNT RETURNED ON UPDATE WITH STREAMS (LOB)
IX87634DB2 TRAPS WHEN EXIT HANDLER CALLED IF RESOURCES ALREADY FREED
IX87720CLI SQL_CONNECT_NODE WOULD NOT ACCEPT VALUE 0
IX87741INCORRECT ROUND FUNCTION OUTPUT.
IX87839EXCEEDING MAX APPLID SIZE OF 32 BYTES. DEFECT NUMBER 103039
IX87877SIG#11 IN GET_DBMON_BP ON RESTART
IX87910LOCKING BEHAVIOUR AT CS TO BE CHANGED FOR BOUNDARY CONDITIONS.
IX87911DB2 UDB ERROR 28 IS INCORRECTLY RETURNED BY THE SAMPLE USEREXIT WHEN LOG FILE WE ARE TRYING TO ARCHIVE DOES NOT EXIST.
IX88179THE TYPE CASTING OF VARCHARS TO DECIMAL IN THE CREATE STATEMENT FOR UDF RESULTS IN THE LOSS OF PRECISION
IX88274HANG ON CRASH RECOVERY DUE TO LOCK-WAIT ON SYSTABLESPACES
IX88408POSSIBLE DATA INCONSISTENCY
IX88449POSSIBLE -902 WHEN USING SCROLLABLE CURSOR
IX88761QUEISCE EXCLUSIVE RESET IS NOT WAD. AFTER A USER IS FORCED OFF THE SYSTEM THE PHANTOM QUIESCE IS NOT ACQUIRE BY NEXT USERID.
IX88927DB2ADUTL EXTRACT -> CANNOT EXTRACT IMAGES > 2G
IX88966SQLDESCRIBEPARAM TRAPS IF SQLPREPARE HAS A WARNING
IX88968SQL1224 WITH 'SEGMENTED TABLE PAGE NUMBER WAS TOO HIGH' IN DIAG LOG. POOLPGNUM = 5A454B41 -> > ALLOWABLE RANGE.
IX88969DB2JD LEAVES <DEFUNCT> CHILD PROCESSES WHEN APPLETS COMPLETE.
IX89062SQL0901 WHEN HASH_JOIN PLAN IS CHOSEN
IX89209ABILITY TO FIX TERRITORY FIELD FOR DATABASES MIGRATED FROM V2 TO V5 WHERE THE TERRITORY IN THE DB CFG FIELD IS NOT READABLE.
IX89285ALTER TABLESPACE ADD <CONTAINER> FAILS AFTER REDIRECTED RESTORE WITH SET TABLESPACE ... IGNORE ROLLFORWARD CONTAINER OPERATIONS
IX89317SAP - ACCESS PLAN CHANGED BY ADDING INDEXES WHICH ARE NOT USED
IX89396SIGNAL#11 IN SQLRR_OPEN
IX89405SIGNAL#11 IN SQLOLGSEMPOST
IX89426CALLING STORED PROCEDURE CAUSES GATEWAY TO CRASH
IX89535SQL0433N ON QUERY WHEN CAST FUNCTION RETURNS WRONG SQLLEN
IX89661SQL2038 RC=-1062 ON RESTORE OF DATABASE CREATED ON ROOT FILE SYSTEM I.E. ON '/'.
IX89677DROP INDEX CRASHES INSTANCE DUE TO INVALID INDEX SPACE MAP HEADER INFORMATION
IX89691TRAP IN SQL_DB2RA_AS_DB_OPEN.
IX89840REALLOCATION OF OLD LOG DURING DB TERMINATION CAUSES DB TO SHUTD OWN
IX89927CONTAINER REMOVED WHEN ROLLING FORWARD THROUGH A FAILED ADD CONTAINER FOLLOWED BY A SUCCESSFUL ADD CONTAINER
IX89960DON'T SEND EXTRA FETCH TO SERVER IF SQLCODE IS +100
IX89997UNTYPED PARAMETER MARKERS CAST INCORRECTLY WHEN IN CLAUSE USED
IY00162SEGV IN SQLRI_HSJNNEWTUPLE() USING HASH JOINS
IY00229TQ HANG
IY00230IF SQLFREESTMT FAILS WITH -30081,DON'T RETURN SQL_ERROR ON FREE
IY00268LOAD TRAPS DURING THE BEGINING OF THE BUILD PHASE ON 4 WAY SMP BOX WITH LOAD PARALLESIM SET TO 4
IY00444HASH JOIN USES UP ALL THE MEMORY AND CAUSES EDU CRASH.
IY00480ENSURE DB2AUDIT RETURNS 0 RC INSTEAD OF 6 WHEN SUCCESSFUL
IY00674DB2ATLD HANGS IF PLACED IN BACKGROUND WITH & AND AUTHENTICATION = NO
IY00718HASH JOIN PLAN MAY HANG IN RARE CIRCUMSTATNCES
IY00761TRAP IN SQLDDELTCB (SQLDFREETCB) ON NORMAL DATABASE DEACTIVATION PROCESS IS DB2PFCHR (PREFETCHER)
IY00782EINVAL IN SQLOCSHR IN DB2CART , SQLO_NO_SEG IN SQLGMRP FFFF D605 ALSO CRASH RECOVERY ENDING TO EARLY
IY00838USING 'CONNECT TO <DB> USER <USER> CHANGE PASSWORD' FAILS WITH SQL1403N, BUT ACTUALLY CHANGES THE PW OK... USING NIS.
IY00843IMPROVE THE HANDSHAKE BETWEEN SQE AND MONITOR CODE THAT CAN CAUSE A HANG
IY00882EVENT MONITORS WRITING TO PIPES NOT GETTING CLEANED UP ON DB2STOP FORCE - SQL1614 RC 6 TRYING TO RESTART EVENT MONITORS
IY00971SNAPSHOT DOESN'T SHOW ALL LOCKS BEING HELD
IY00976RESTORE FAILS WITH SQL0973 - NOT ENOUGH SPACE IN LOCK LIST HEAP.
IY01157RESTART FAILS, DIAGLOG INDICATES: SQLPGRLG PROBE: 0 'A CORRUPT PAGE WAS ENCOUNTERED IN A LOG FILE DURING CRASH RECOVERY'
IY01281ERRONEOUS -902 IN SQR MARKS THE DB BAD
IY01282SIGNAL #11 DB MONITOR CODE AGENT_STMT_START()
IY01397DB2 UDB 5.X: EEE SPECIFIC: PERFORM INTERNAL FABRICATE STATS PROC ESSING (IF REQUIRED) LOCALLY IF POSSIBLE
IY01401APPLICATION SNAPSHOT REPORTS THE WRONG INFORMATION
IY01429DB2 UDB 5.X MAY GIVE SQL0901 IF INTRA_PARALLEL ON
IY01525DB2LOOK DOES NOT SHOW A TABLE WAS CREATED WITH 'NOT LOGGED INITIALLY'. NECESSARY FOR THE 'ALTER TABLE' COMMAND.
IY01547FFFF8133 MESSAGES IN DB2DIAG.LOG DURING CRASH RECOVERY WHEN ACCESSING A TABLESPACE IN ROLLFORWARD PENDING - PERFORMANCE
IY01644CURSORS/LOCKS BEING CLOSED IN XA TRANSACTIONS WHICH HAVE ALREADY BEEN CLOSED.
IY01726-952 WHEN RUNNING STORED PROCEDURE TO EEE
IY01782DB2ADUTL CORE DUMPS WHEN -1 PASSED FOR N ON THE COMMAND LINE.
IY01898-1042 FROM SQLEGETAGENTFROMPOOL IN MPP WHEN THERE IS A SEND/RECEIVE COMMUNICATION PROBLEM BETWEEN NODES.DB MAY CRASH.
IY01930UPDATE/INSERT OF >150/200 ROWS EXTENDERS TABLE HANGS (SQLUIHSH)
IY01933SQL0901 REPORTED BY SQLRAFRS()
IY02049DB2LOOK CHANGES AUTHORIZATION GROUP TO USER.
IY02162MIN BUFF LSN SET TOO HIGH. THIS CAUSES RESTART TO FAIL IF SOME ESSENTIAL LOG RECORDS DO NOT GET REPLAYED.
IY02408DB2 UDB - HANG ON INDEX REBUILD ATTEMPT. IN THIS CASE, INDEXREC WAS SET TO RESTART - SO THE CONNECT ATTEMPT WAS HANGING.
IY02708DEAD LATCH DURING CREATE TABLE WITH PRIMARY KEY
IY02888SQL1246N USING API SQLESETC
JR11822LOAD OF DEL ON NT CAUSES DB2 TO TRAP, AND DB2 TO BE INCONSISTENT FUNCTION NEEDED FOR USE OF ZIP/JAZ DRIVES
JR11966DB2SYSC TRAPS ON NT LOAD OF ASC
JR12000MULTITHREADED APPLICATIONS TRAP IN UDB
JR12221OPTIMIZER BUG FOR HOST VARIABLE FILTER FACTORS AND RUNSTATS
JR12258MS ACCESS USES TYPE TIMESTAMP FOR TYPE DATE FIELDS.
JR12333TRAP IN DOWN LEVEL CLIENT.
JR12353RESTORE FROM BACKUP ON DISKETTES FAILS
JR12355LOADING BLOB COLUMN LARGER THAN THE TARGET GIVES SQL3408, BUT ERROR MESSAGE REFERS TO THE PREVIOUS COLUMN.
JR12356NT: 192 MB FILE CACHE LIMIT HIT WHEN DB2NTNOCACHE SET TO 1. 'FFFFB5AA' MSGS IN DB2DIAG.LOG, TBSPCS PUT INTO RF PENDING.
JR12409SQL_C_NUMERIC BINDING FROM VISUAL BASIC SUPPORT TO BE ADDED.
JR12410DB2 UDB V5.00 TRAPS WHEN SYNTAX OF A QUERY WITH ORDER BY IS INCORRECT ON WINNT.
JR12414IMPLEMENT VARIALBE TAPE BLOCK SIZE FOR THE DB2 BACKUP COMMAND ON THE INTEL PLATFORM.
JR12424NULL INDICATOR NOT BEING RESET
JR12444SQL0104 FOR OUTER JOIN FROM MS ACCESS TO MVS
JR12452MEMORY LEAK WHEN USING CLI APPLICATION TO HOST FROM DB2 CONNECT
JR12467UNINSTALL DOES NOT REMOVE *.OUT FILES FROM DAS INSTANCE DIRECTORY.
JR12498SQLEXECUTE DOES NOT INSERT ALL COLUMNS PROPERLY
JR12508SQL1026N FOLLOWED BY SQL1032N WHEN ISSUING MANY DB2STARTS
JR12509CLI0113E WHEN STORED PROCEDURE RETURNS DATE NOT IN ISO FORMAT TO A CLI APPLICATION.
JR12512MEMORY ACCESS VIOLATION OR TRAP WITH MULTIPLE ENV. HANDLES
JR12546NT: RESTORE TRAPS WHEN THE FULL PATH TO THE BACKUP IMAGE IS SPECIFIED IN THE RESTORE COMMAND (CLP OR CC).
JR12555REMOTE DB BACKUP TO ADSM VIA NT CLIENT CONTORL CENTER WITH SESSIONS > 1 FAILS WITH SQL2032.
JR12563FFFF877E IN DB2DIAG.LOG AND -901 IN DB2 TRACE ON INSERT/UPDATE/D ELETE
JR12582DB2 TRAPS (NT TRAPS IN DB2SQN.DLL) WHEN THERE IS A 'TYPO' AFTER A GROUP BY CLAUSE...
JR12594SQL3124W ON LOAD OF ASC FILE WITH PACKEDDECIMAL OPTION WHEN THE FILE HAS CORRECT STRUCTURE.
JR12595ALWAYS RETURN CATALOG SEPARATOR TO BE '.' INSTEAD OF HAVING TO USE PATCH2=11
JR12611MESSAGE DIA99999 IN FUNCTION SQLPGMRP PROBE:100 SHOWS AFTER DB2 FAILS TO ARCHIVE A LOG
JR12613DB2 COMMON SERVER - CRASH RECOVERY FAILS WITH -2775 MESSAGES IN THE DB2DIAG.LOG FILE.
JR12618SYS3175 RETURNED FROM OS/2 WHEN RUNNING A USER EXIT TO BACKUP A DATABASE REPEATEDLY...
JR12646OS/2: SQL1038C ON DB2START WHEN USING A FAT FILESYSTEM.
JR12669SLQSTATE -1106 LOGGED IN DB2DIAG.LOG WHEN PERFORMING IMPORT FROM A REMOTE MACHINE TO A WINDOWS SERVER.
JR12673SQL0901N INDEX OUT OF RANGE, UDB PARSER PROBLEM
JR12681EVEN WHEN THE OPTIMIZE FOR N ROWS IS ON DB2 CONNECT WILL CONTINUE SENDING PRE-FETCH REQUESTS TO THE HOST.
JR12689REDUCE MSGS IN DB2DIAG.LOG CAUSED BY CONVERSION FILES
JR12702DRDA AS TRAPS OUTBOUND TO ANOTHER LOCAL INSTANCE
JR12713FFFFF616 IGNORED CAUSING DATABASE CORRUPTION
JR12719FILE_TRANSFER_CMD OPTION OF THE DB2 AUTOLOADER CONFIGURATION FILE DOES NOT CALL A BATCH FILE. IT DOES CALL AN .EXE FILE.
JR12721IF THE IN PREDICATE OF THE WHERE CLAUSE IN A SELECT STATEMENT HAS MORE THAN 284 ITEMS, THE ENGINE TRAPS.
JR12731DDL FOR CREATE TABLE INCORRECT WHEN DBNAME IN DB2CLI.INI FILE
JR127325.2:SQL0956 / SQL1478 AFTER ALTERING V5GA BUFFERPOOLS
JR12734CCA IMPORT ONLY PICKS UP ONE INSTANCE IF MULTIPLE DEFINED FOR A SYSTEM.
JR12745SQLBINDPARAMETER() DOES NOT HANDLE BEING PASSED A COLUMN SIZE OF ZERO PROPERLY AT FP 7 (WR09084).
JR12748SYMBOLS FOR GENERIC API LIBRARY NOT EXPORTED IN UDB VERSION 5/5.2. NT BUILD DOES NOT EVEN HAVE THE OBJECT FILES.
JR12788TRAP ON CONNECTION TO DB2 / MVS WHEN CURRENTSQLID SET
JR12797NULL INDICATOR NOT BEING RESET IN JDBC APPLICATION USING THE 'NET' DRIVER.
JR12804SETXXXSTREAMS BROKEN IN THE 5.2 NET DRIVER
JR12809MEMORY LEAK IN DB2JD.EXE DEFECT 101809
JR12812BIND MESSAGES TRUNCATED IN CCA
JR12819IMPORT OF EXPORTED CLIENT PROFILE IN CCA FAILS CCA3002N IF PATH CONTAINS LONG NAMES WITH BLANKS
JR12822NT EVENT LOG FILLS UP WITH SQL0502 AT DIAGLEVEL 4 WITH VB (ODBC
JR12881MEMORY CORRUPTION WHEN COPYING INTO CACHED DA.
JR12885USING ADO IN VB TO RETRIEVE PACKED TYPE FROM A MVS RECEIVES 'INVALID PRECISION' ERROR. DEFECT #103555
JR12894RANDOM TRAPS IN SQLRA_CACHE_DEL_VAR WHICH ARE MANIFEST AS EITHER INSTANCE HANGS OR CRASHES. DIAG FILE 0XA602.
JR12915GATEWAY CRASHES IN COLUMNNAMES LIST DURING A CALL TO A SP
JR12918TABLETYPE KEYWORD NOT EXCLUDING SYNONYM TABLE TYPES
JR12919UNDERDBDIR FIELD OF SQLB_TBSCONTQRY_DATA STRUCTURE IS NOT REVERSED WHEN USING SQLBTCQ API ON NT AND CONNECTING TO AIX.
JR12948APPLETSECURITYEXCEPTION WITH APP DRIVER DUE TO SYSTEM PROPERTIES
JR12958PRECOMPILER GENERATES DIFFERENT SQL TYPE FOR CHAR HOST VARIABLES INSIDE A STRUCTURE DEPENDING ON LOCATION OF SHORT HOST VARIABLE.
JR12989CALL TO SQLESTAT FAILS WITH SQL1428 WHEN ATTEMPTING TO COLLECT DB INFORMATION FROM BOTH LOCAL AND REMOTE DBS IN ONE PROCESS
JR12995WHEN USING A JAVA APPLET (JDK 1.2) TO SELECT FROM A CHAR COLUMN OF AN MVS TABLE, THE DATA IS SOMETIMES TRUNCATED.
JR12996TRAP IN SQLJMF06() IN SQLJMFR1.C WHEN WE TRY TO SET THE EXPECTED OUTPUTFLAG VARIABLE THAT INVOLVES SQLE_DB2RA_DB_EXECUTE_FLAGS
JR13006DB2ENG.DLL TRAPS BY BACKUP USING USEREXIT ON OS/2 SMP MACHINE AND/OR INTRA_PARALLEL YES - TRAP IN SQLEBUILDBDSUNIQUEID
JR13009SQL1109N 'DLL NOT FOUND' WHEN CALLING A JSP WITH POWERBUILDER DEFECT#: 108302
JR13027OPTIMIZER PLAN INCORRECT WHEN HANDLING NULLS IN INDEXES.
JR13043DB2 BACKUP DATABASE COMMAND ON NT FAILS WITH SQL2025 RC 1450 ERROR_NO_SYSTEM_RESOURCES
JR13056TRAP IN SQLNO_COST_NLJN - THIS APAR IS TO PROVIDE MORE INFORMATION IN DB2DIAG.LOG (-901) IF TRAP OCCURS AGAIN.
JR13076MEMORY LEAK IN JVM WITH JAVA UDF
JR13103DB2 UDB V5 FIX FOR WEBSPHERE 3.0
JR13106BRAZIL LOCAL DATE FORMAT (DD.MM.YY) DOES NOT WORK (ISO INSTEAD)
JR13114DB2DEFPREP=YES NOT DISABLED FOR PREPARE WITH INTO CLAUSE
JR13125SELECT STAT WITH MULTIPLE WHERE CLAUSES SEPERATED BY OR DOES NOT RETURN ALL OF THE DATA
JR13141CATALOGGING RETURNING A SQL1092 ERROR WHEN MEMBER OF ADMINISTRATOR GROUP AND A DOMAIN USER
JR13152IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY.
JR13153DB2 CONNECT GATEWAY TRAPS WHEN LARGE ARRAYS PASSED AS INPUT PARAMETERS.
JR13156PARAMETER MARKERS IN JDBC APPLICATION ARE BEING BOUND WITH THE WRONG SIZE CAUSING CLI0109E STRING DATA TRUNCTION ERRORS.
JR13169#DELETED GETS DISPLAYED IN MS ACCESS WHEN DISPLAYING A DB2 TABLE THAT HAS A PRIMARY KEY ON A DATE COLUMN OR DECIMAL COLUMN
JR13194ADDING ACCOUNT STRING FOR MVS TO THE DB2CLI.INI FILE DEFECT ACTION PLAN: 116373
JR13200SETTING BOTH ODBC 2.0 AND ODBC 3.0 ENVIRONMENTS DEFECT # 116384
JR13223CALLING STORED PROCEDURE AGAINST DRDA HOST RETURNS SQL -1224, -902 OR NO RESULTS WHEN THERE SHOULD BE. DEFECT 116964
JR13306CLI MEMORY INTIALIZATION PROBLEM CLI0112E ERROR IN ASSIGNMENT
JR13311TRAP IN 'SQLMON_DCS_STMT' ON DB2 CONNECT EE 5.2 WHEN MONITOR HEAP EXHAUSTS.
JR13315DRDA STREAM TERMINATING WITH CM_PROGRAM_ERROR_PURGING WHEN PASSING SQLDA TO HOST.
JR13332CHANGE PASSWORD FOR 8 CHAR USERIDS RETURNS INVALID USERID.
JR13354SQL 1404 FROM MVS IS IGNORED BY CLI (ODBC) APPLICATIONS DEFECT # 120629
JR13363CCA CANNOT TRUNCATE COMMENT FIELD ON ADD DATABASE.
JR13402NAME SHARED EVENT SEMAPHORES MAY NOT BE UNIQUE WITH MULTIPLE INSTANCES, CAUSING THEM TO BE POSTED BY ANOTHER PROCESS.
JR13405APPL_NAME OPTION OF THE CREATE EVENT MONITOR COMMAND DOES NOT WORK. THE PROBLEM WAS DETECTED WITH NT, NOT AIX.
JR13427CHANGING ISOLATION LEVEL AFTER EXECUTE CAUSES ERROR ON NEXT EXECUTE
JR13428MEMORY LEAK WITH UDF'S IF RETURNING BLOBS OF VARYING SIZE
JR13432JDBC 2.0 SETDATE(NULL) FOR DATE PARAMETER MARKER TRAPS
JR13433JDBC DRIVER TRAPS AFTER MANY FAILED CONNECT ATTEMPTS
JR13448TRAP IN SQLOXULTEX RUNNING UNFENCED UDF ON SMP
JR13488SQLCOLATTRIBUTES DOESN'T RETURN NULL STRING WITH SQL_DESC_BASE_T ABLE_NAME