Product Name:DB2 UDB V5.2 for OS/2
PTF Number:WR21287
Package Date:Mon Nov 19 10:37:12 EST 2001
Build Level:c010929
APAR fixes included in WR21287 (Fixpak 17)
APARABSTRACT
GG04162VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION FALLBACK
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
GG04229APPLY DOES NOT RUN 'SQL AFTER' ON DIFFERENTIAL UPDATE WHEN CAPTURE IS FROM AS/400 AND SYNCHPOINT IS NULL
IY21347INTERNAL ERROR REPORTED IN DB2DIAG.LOG DURING THE ROLLBACK OF CHANGES TO DB FAILS WITH SQLCODE -952
IY21522APPLY USES THE WRONG PRUNE CONTROL ROW WHEN CAPTURE IS STARTED COLD.
IY23502SUBOPTIMAL PLAN CHOSEN FOR STAR JOIN
IY24652INSTANCE CRASH AND TRAP AT SQLJDRD1
IY24682TRAP IN SQLCSPC_COOR_REG WHEN HOST EXPERIENCES COMM. PROBLEMS
IY24743TRAP IN SQLJMQDA WHEN THE QUERY HEAP GETS EXHAUSTED
IY24752TRAP - SIGNAL 11 IN SQLPM_WRITE_LOCKS WHILE PERFORMING LOCK SNAPSHOT CRASHED THE DB2 INSTANCE
IY24760DRDA POINTER IS NOT INITIALIZED CORRECTLY IN TCP/IP COMMUNICATION. CAUSES TRAP UNDER CERTAIN CONNECTIONS USING JAVA
IY24762BUFFER CORRUPTION CAUSES REPLICATION TO FAIL.
IY24853DB2 GATEWAY TRAPPING AFTER RECEIVING DATA FROM A STORED PROCEDURE ON OS/390.
JR15941DB2 IS TRAPPING IN THE FUNCTON SQLEMRSP_AS.C
JR16041DRDA_HEAP_SZ MEMORY LEAK. SYMPTOMS: SQL30081, RC= *,*,0.
JR16374OS/2 DB2 BACKUP VIA USEREXIT WILL FAIL AT AND AFTER SUNDAY SEPTEMBER 9TH 01:46:39 2001
APAR fixes included in WR21262 (Fixpak 16)
APARABSTRACT
GG03998ASNLOAD BLOB LIMITATION
GG04044APPLY CONNECT TO THE SOURCE FOR UPDATING PRUNCNTL.SYNCHPOINT BUTIF NO CAPTURE IS RUNNING - NO SQL PROCESSED - DSNL500I MESSAGE
GG04082SQLCODE313 PRESENTED AFTER USING OFFLINE LOAD PROCEDURE
GG04108ASNAPPLY WITH PARM NOSLEEP DID NOT ISSUE A 'CONNECT RESET',WHICHLEADS TO DSNL500I CONVERSATION FAILED MESSAGES ON DB2 OS/390
GG04128IF A COMMUNICATION ERROR OCCURS (ASN1001E, SQL30081), THEN APPL RETURNS WITH RC=0 TO THE OS
GG04135INSERT OF A NEW PRIMARY KEY WITH THE SAME VALUE IS NOT REGISTERED IN CCD AS AN INSERT
GG04162VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION FALLBACK
GG04178APPLY PUTS NULL IN CCD TARGET WHEN SOURCE COLUMN IS A TIMESTAMP AND TARGET COLUMN IS A CHAR(TIMESTAMP)
GG04189FULLREFRESH FROM SECOND TIER CCD TO 3RD TIER CCD DID NOT WORK.
GG04190APPLY BINDS USING PRUNE LOCK TABLE WILL NOT BIND TO CAPTURE/VM WHICH DOES NOT HAVE THIS TABLE.
GG04194CAPTURE USES TOO MUCH MEMORY - WIN NT SPECIFIC PROBLEM
GG04196OVERRIDE THE DEFAULT PARAMETERS OF LOGREUSE AND TRLREUSE USED BY ASNSAT WHEN INVOKING APPLY.
GG04201ASNCMD STOP FAILS TO STOP DATAPROPAGATOR CAPTURE.
GG04205ASNLOAD FAILED WHEN INVOKING APPLY USING A NETWORK ID.
GG04206APPLY NOT REDRIVING APPLY WHEN AN RI VIOLATION IS DETECTED IN THE 'F' DIRECTION.
IC29866IF A SOURCE TABLE ON A NON-IBM DATABASE IS REGISTERED FOR FULL REFRESH ONLY,DJRA SQL GENERATION FOR ADD MEMBER OR DROP MEMBER
IY01998AN AGENT HANGING IN TQ CODE, ANOTHER STUCK ON APM LATCH
IY03296SQL2154 ON ATTEMPTED TABLESPACE RESTORE.
IY10950UNDERSCORES IN TABLE ALIAS CAUSE MS JET ENGINE ERROR WHEN LINKING TABLES.
IY11267QUERY_HEAP TOO SMALL MAY CAUSE -1131 ON CALL TO STORED PROCEDURE
IY12823REINIT CMD WAS IGNORED WHEN THERE IS NO CHANGES TO CAPTURE
IY13065DB2ADUTL HAS A ARCHIVE LOG LIMIT OF 1023 ENTRIES.
IY13617CAPTURE CORE DUMPS DURING WARM START WITH LONG TABLESPACES AND LONG VARCHAR COLUMNS
IY13653AUTOLOAD FAILS WITH -1350: -290 IN DIAG SQLR_TURNOFF_CONSTR.
IY13696SQL1273N ON ROLLFORWARD DATABASE (MISSING LOG FILE S0000000.LOG)
IY13738FROM CLIENT TO AIX SERVER,JOB IS SCHEDULED THORUGH SCRIPT CENTERWITH CORRECT USERID,NO MATTER WHAT PASSWORD,JOB EXECUTES SUCESSF
IY13817LOAD FASTPARSE FAILS TO LOAD AND REPORTS INCORRECT INFO
IY13818-804 ERROR IN APPLY SQL0804N SQL0804
IY13830CAPTURE DOES NOT RETURN SQL2651 IN CCP FILE
IY14059APPLY AIX PID FILES NOT FOUND
IY14117UNEXPECTED SIGALRM RECEIVED BY DB2UDF BRINGS DOWN DB2
IY14152CAPTURE UNABLE TO FINISH PRUNING WHEN LOG FILE SYSTEM BECOMES FULL (SQL0964C)
IY14154CAPTURE NEEDS TO REINIT LONG FIELD DATA STRUCTURES FOR ANY NEW REGISTRATION PICKED UP BY THE REINIT COMMAND
IY14209DB2LOOK -L FAIL TO RETURN CONTAINER INFO WHEN RAN AS SYSCTRL ID.
IY14225DB2ATLD CANNOT HANDLE PATH LONGER THAN 80 CHARACTERS
IY14274INSERT/UPDATE PROBLEMS FROM MVS AR AGAINST UDB AS SQL30020 RC 1245
IY14291CAPTURE CORE DUMPS WITH SIGABRT, LONG VARCHAR COLUMNS
IY14298CUSTOMER SELECTS, IN JOURNAL, A COMPLETED SPECIFIC JOB TO DISPLAY AND THE DB2DAS00 GOES DOWN.
IY14338INCREASE DB2 PRIVATE MEMORY ALLOCATION LIMIT PER PROCESS FROM 256MB TO 2GB - AFFECTS UNIX ONLY
IY14463CAPTURE GETS IN A LOOP WHEN ASNCMD GETLSEQ IS IN LOCK STATE
IY14706IMPORT WITH BUFFERED INSERT CAUSES TABLE LOCK ON SYSIBM.SYSPLAN
IY14776CURRENT REFRESH AGE PARAMETER IS NOT BEING PICKED UP.
IY14820ERROR DURING ALLOCATION OF LOG FILE CAUSES DATABASE TO SHUTDOWN
IY14980HANG IN FCM ON FAST HARDWARE
IY15004JAVA STORED PROCEDURES FAIL WHEN RUN FENCED EVEN WHEN LOCATED IN SQLLIB/FUNCTION PATH.
IY15068INCORRECT FILTER FACTOR COMPUTATION FOR RANGE PREDICATES
IY15116ASN0017E RETURNED WHEN CAPTURE FAILS TO START FROM A USERID THATIS DIFFERENT FROM THE DB2 INSTANCE OWNER
IY15290SQL0901 RETURN - SECTION NOT CLOSED.
IY15608SIGNAL#11 IN SQLUDRSA
IY15735INSTANCE CRASH ON TRAP (SIGSEGV) IN SQLBLATCHPINNEDPAGE EEE ONLY. INTERNAL SYNCHRONIZATION PROBLEM EXECUTING SQL.
IY15921CAPTURE FAILS - SQL2038 RC 32
IY15931HASH_JOIN MEMORY ALLOCATION PROBLEM WHICH MARKS DB BAD.
IY15975MEMORY LEAK IN AIX APPLY
IY16223WRONG MAPPINGS FOR ERROR MESSAGE SQL0465N AGAINST OS/390
IY16239USEREXIT STOPS WORKING WHEN ACTIVATE IS ISSUED DURING AN ONLINE BACKUP
IY16298DB2 UDB - MESSAGE IS INCORRECTLY DUMPED TO THE DB2DIAG.LOG FILE FROM FUNCTION SQLERUNSYSCTLR PROBE 65.
IY16466CLI TRAPPING WHEN QUERY IS LARGER THAN 32K
IY16518DATABASE CRASHES AFTER INTERRUPTED REORG
IY16644JOBIDS ARE NOT REUSED WHEN 999 LIMIT IS REACHED IN SCHEDULER
IY16734DEBUG CODE TO DUMP INFO WHY USEREXIT STOPS ARCHIVING LOGS
IY16924NEED TRANSACTION BASED REPLICATION FOR READ ONLY TARGET TYPES OFPIT AND USERCOPY.
IY16936TABLESPACE RECOVERY FAILS/HANGS DURING FIRST ROLLFORWARD.
IY17015TABLESPACE ROLLFORWARD UNDO PHASE READS FROM DISK FOR EVERY LOG RECORD
IY17049DB2SPLIT FAILED IF OUTPUT FILE > 2GB
IY17330DESCRIBE RETURNS AN INCORRECT INFO IN DBCS
IY17523SQL1015N, DATABASE MARKED BAD DUE TO IMPROPER SAVEPOINT HANDLING
IY17650ONLINE DATABASE BACKUPS RETURN SQL2038N RC -3838 AFTER A FAILED CREATE TABLESPACE
IY17698APPLY UPDATED THE WRONG SYNCHPOINT AND SYNCHTIME IN PRUNCNTL TBL
IY18124MAX_SYNCH_MINUTES WITH CCD - APPLY UPDATES THE SUBS_SET SYNCHPOINT INCORRECTLY CAUSING POTENTIAL DATA LOSS
IY18163DB2DART REPORTS BPS HEADER PROBLEMS AFTER DATABASE RESTORE.
IY18373APPLY SHOULD EXECUTE THE SQL BEFORE AND AFTER STATEMENTS FOR A SUBSCRIPTION SET EVEN IF THERE IS NO DATA TO REPL. IN THAT CYCLE
IY18376CLICKING ON THE 'CONNECTIONS' SUB-FOLDER IN THE CONTROL CENTER TREE VIEW RESULTS IN AN INVALID PAGE FAULT IN THE DB2JD
IY18901CHANGING QUERY SORT ORDER RESULTED IN POOR PERFERMANCE
IY18986TRAPPED IN SAVEPOINT WHILE ROLLBACK,SHOULD IGNORE SQLCODE-1035 FROM REMOTE NODE
IY19059ONCE JOBIDS HIT 999, JOBIDS ARE REUSED. HOWEVER, JOBS ISSUED VIA 'RUN NOW' KEEP REUSING SAME JOBID
IY19081SMALL TIMING WINDOW WHERE THE CAPTURE READS A LOG WHILE IT IS BEING ARCHIVED -> WORKAROUND: RETRY SHOULD RESOLVE
IY19097CANNOT RUN DB2GOV W/ SYSCTRL GROUP USER THAT IS NOT INST OWNER.
IY19168RESTART/CONNECT/CRASH RECOVERY FAILS WITH SQL1042C WITH INVALID LSN DUE TO A PROBLEM WHEN ABORTING A TRANSACTION
IY19171SAMPLE USEREXIT SHOULD INDICATE THAT 'MOVE' IS UNSUPPORTED FOR LOG ARCHIVING - ONLY 'COPY' IS SUPPORTED
IY19493LONG PREPARE TIME FOR EEE QUERIES INVOLVING MULTIPLE JOINS, WHERE AT LEAST ONE OF THE TABLES RESIDES IN A MULTI-NODE NODEGRP
IY19528ERROR MESSAGE DIA3808C IS INCORRECTLY DUMPED OUT IN THE DB2DIAG.LOG FILE WHEN THE ACTUAL ERROR IS SQL1013.
IY20036DB2PFCHR,DB2PCLNR,DB2REBAL,DB2ESTOR PERSIST EVEN AFTER DBM SHUT DOWN & CONSUME CPU RESOURCES UNTIL REBOOT: RESULT POOR PERFORMAN
IY20069PROBLEM WITH DATAPROP/CAPTURE. TIMESTAMP NOT INITIALIZED.
IY20316SQLBGETPOOLSTATS CAN CAUSE LOG CORRUPTION
IY21243REORG TABLE <TB> INDEX <INDEX> RETURNS SQL2205 WHEN INDEX EXISTS
IY21245AIX ONLY: DB2MEMDISCLAIM CAN CAUSE SORTHEAP ALLOCATION ERRORS, TRAPS, DEFUNCT DB2AGENTS DUE TO LEAKING VIRTUAL MEMORY.
IY21262HOST SERVER (E.G. DB2/390) RETURNS SQL0805N DURING IMPORT DUE TOA PACKAGE NOT FOUND.
IY21263DB2 STOP FORCE FROM CC HANGS AND GENERATES A TRAP
IY21342LOG DIR FILLS DUE TO OLD LOG FILES NOT BEING DELETED/RENAMED DURING CRASH RECOVERY, AND SAME LOG IS REPEATEDLY ARCHIVED
IY21344USEREXIT STOPS TO BE CALLED WITH FFFFA602 FROM SQLPGART MESSAGE
IY21346BACK LEVEL CLIENT CRASHES (SIG#11) IN SQLRR_OPEN
IY21350USE OF {?=CALL SPNAME(?)} SYNTAX MAY RESULT IN CLI0102 INVALID CONVERSION ERRORS
IY21359$N CLAUSE IN CREATE TABLESPACE PROBLEM
IY21366AUTOLOADER HANGS WHEN USING FILE_TRANSFER_CMD AND LOAD ABORTS
IY21367SQLDESCRIBEPARAM CALL TO HOST RETURNING SQL0236
IY21373SQL4908N IS GENERATED WHEN RF ON TABLESPACES IS ISSUED AGAIN ON TABLESPACES WHICH ARE RF PENDING STATE AND FLAG IN LFH IS ON.
IY21391SIGNAL 11 IN SQLDADJUSTSEQDETPFAMOUNT
IY21396QUERY AT OPTLEVEL 3 RECEIVES A SQL0101 EVEN WITH STMTHEAP MAXED
IY21398INDEX CORRUPTION, CONTINUATION OF IY11940
IY21400WRONG OR DIFFERENT RESULTS RETURNED BY SELECT ON VIEWS V7.1 ONLY
IY21444SQLJ.INSTALL_JAR PROBLEM
IY21445CURRENTSQLID NOT USED UNDER MTS TRANSACTION ENVIRONMENT.
IY21501SQL1224 DB2 INSTANCE CRASH. THIS OCCURS BECAUSE OF MEMORY CORRUPTION AFTER A COMMUNICATIONS ERROR - TRAP IN MEMTREEPUT
IY21524DIA1529C COULD NOT START DEADLOCK DETECTOR, GLOBAL DEADLOCK DETECTOR FAILING TO START.
JR14320SQL0501N IN DB2DIAG.LOG. NO ERRORS RETURNED TO THE APPLICATION. WE ARE TRYING TO CLOSE CLOSED CURSOR INTERNALLY IN CLI.
JR14807DR. WATSON WHEN ISSUING DB2 FORCE APPLICATION ALL AGAINST DRDA-2CONNECTIONS.
JR14990OUTPUT PARAMETERS NOT INITIALIZED TO NULL
JR15228TRAP IN SQLJIDRD WHEN SQL_DISCONNECT_ABNORMAL RETURNED
JR15238INCONSISTENT RESYNC (OS/390 ABORTS, UDB COMMITS)
JR15272LARGE TRAP FILE WHEN FREEING INVALID MEMORY BLOCK (SQLOFMBLKEX)
JR15466DATABASE COMES DOWN OR HANGS. TRAP FILE IS CREATED INDICATING EXCEPTION C0000005 IN FUNCTION SQLRR_DUMP_SECTION.
JR15706TRAP IN SQLCSPC_COOR_REG.
JR15713-805 CAUSED BY CURRENT PACKAGE SET IS NOT RESET
JR15744SIGNAL 11 IN SQLNO_JOIN_PG_SEL
JR15764MSACCESS FAILES WITH ODBC ERROR WHEN RETRIEVING CLOB FROM MVS 6.1
JR15770XA PASSWORD LENGTH SHOULD BE 14 CHARACTER MAX
JR15794CONNECT TYPE 2 APPLICATION THAT CALLS A STORED PROC TRAPSIN SQLE_DBM_DARI - APPLICATION RECEIVING SQL1327
JR15855USERIDS NEED WRITE AUTHORITY ON DAS DIRECTORY TO RUN SCRIPTS
JR15856CRASH RECOVERY TRAPS DUE TO INDEX CORRUPTION
JR15874DB2 ABENDS IN SQLERUNSYSCTLR DUE TO DOUBLE-FREEING OF MEMORY DARI PROCESS
JR15876SUBSCRIPTION SET FOR REPLICA WITH EVENT BASED TIMING ('E') ALWAYS GETS TIME BASED TIMING ('R') IN THE SCRIPT
JR16096FAILURE DUE TO COMPLEX ON DELETE CASCADE RI CONSTRAINTS
JR16165EXCEPTION 5 TRAP DURING STAR JOIN PLANNING
JR16167'BAD' RANGE OF SORTHEAP SIZE(>1014 AND < 1038) IN THE OPTIMIZER
JR16172WHEN DEFERREDPREPARE=0 CLI0150E ERROR DRIVER NOT CAPABLE IS RETURNED
JR16175SP FAILS WHEN MORE THAN 27 CURSORS, RET. DATA > 1 BUFFER
JR16182MTS/COM+ APPLICATION GETTING SQLCODE -913 WHEN EXECUTING, DUE TOMULTIPLE CONNECTIONS BEING USED BY MTS FOR THE SAME TRANSACTION
APAR fixes included in WR21216a (Fixpak 15a)
APARABSTRACT
IY09961QUERY REWRITE DOESN'T PUSH DOWN PREDICATE INTO COMMON SUBESPRESS ION
IY12642LOAD DOES NOT CHECK PARTITIONING KEY FOR EXCEPTION TABLE
IY12968JDBC 2.0 PREVIOUS() METHOD RETURNS TRUE ON FIRST ROW
IY13054MISLEADING ERROR REPORTING ( -901) FOR WRONG SCRIPT TRYING TO LINK UDF.
IY13476CRASH RECOVERY HANGS DURING UNDO PHASE IN INDEX MANAGER
JR13152IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY.
JR13922THIN CLIENT INSTALLING OLDER ODBC*.DLLS
JR15025DR.WATSON IN DB2SYS.DLL WHEN LOGING OFF NT (MTS AND DTC)
JR15158DEFECT IN DB2 MEMORY MANAGEMENT CAUSES INTERNAL FRAGMENTATION - SYMPTOM IS SIMILAR TO A MEMORY LEAK - EXCESSIVE MEMORY USAGE
APAR fixes included in WR21216 (Fixpak 15)
APARABSTRACT
GG03736ASNLOAD FAILS WITH ASN1053E WHEN REPLICATION TABLE HAS MANY COLUMNS.
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
GG04099ASNAPPLY FAILS WITH CORE
GG04103DURING CAPTURE PROCESSING THE ASNPATH SYSTEM VARIABLE IS BEING MISREAD
GG04106CANNOT STOP CAPTURE WITH ASNCMD STOP COMMAND.
GG04109CAPTURE CORE DUMPS IF COMMANDS ARE ISSUED WHEN THERE ARE NO LOGS TO READ
GG04111DIAGNOSTIC ENHANCEMENTS FOR APPLY
GG04129APPLY FAILED SQLCODE30090 AFTER PROCESSING 'S' SQL STATEMENTS
IY09645CAPTURE SHOULD NOT IGNORE SYSTEM ERROR (SQLN2038)
IY10867CASE SENSITIVITY OF BACKUP IMAGE PATH
IY11081DATABASE GETS MARKED AS BAD AFTER FCM ERRORS FFFFFC7F IN DB2DIAG.LOG FILE. EVENT MONITOR RESOURCE COULD NOT BE OBTAINED.
IY11087CAPTURE CORE DUMP RUNNING AGAINST TABLES WITH LONG VARCHAR
IY11132CAPTURE DIDN'T CAPTURE LONG VARCHAR COLUMN WHEN TABLE IS IN LONG TABLESPACE
IY11226CAPTURE DOES NOT HANDLE LARGE TABLE ID. THIS PROBLEM EXISTS IN ALL CAPTURE VERSIONS.
IY11499DB2 UDB - CRASH RECOVERY FAILS WITH AN SQL1042 ERROR. MESSAGES IN THE DB2DIAG.LOG WE FAILED WHEN TRYING TO DROP A BUFFERPOOL.
IY12052SEVERE PERFORMANCE DEGRADATION WITH HIGH SYSTEM CPU AND CONTEXT SWITCHES. OCCURS AFTER PREDICTABLE DATABASE UPTIME OF 4-16 DAYS
IY12218APPLY SHOULD NOT INVOKE RUNSTAT AFTER DIFFERENTIAL REFRESH
IY12421QUERY RETURNS INCORRECT RESULTS
IY12450SQL1224 INSTANCE CRASH ON V5.2 HP ONLY. PAGECLEANER IS TRYING TO DO AN AIOWRITE ABOVE 2GB - SQLBSERVENTRYPOINT FFFF D60C
IY12536MONITOR STATE DOES NOT RESET APPLICATION STATE ONCE COMPLETED
IY12725DB2 UDB - CREATE INDEX CAUSING DATABASE TO COME DOWN. THE DB2DIAG.LOG FILE INDICATES THAT AN OBJECT ID IS ALREADY IN USE.
IY12821ASN.IBMSNAP_TRACE TABLE HOLDS ONLY 251 ROWS
IY13020DPROPR CAPTURE - TWO CAPTURES CAN RUN WITH THE SAME DATABASE WHEN THE .PID FILE IS DELETED
JR14749SQL0291 TRYING TO ACCESS TEMPORARY TABLESPACE WHEN THERE ARE TEMP TABLEPSACES OF DIFFERENT PAGESIZES:'NO TEMP AVAILABLE'
JR14931EVENT ANALYZER (CONTROL CENTER) IS TOO SLOW LOADING AND SORTING EVENT FILES
PQ38000APPLY DOES NOT PROCESS CHANGE DATA PROPERLY
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
APAR fixes included in WR21191d (Fixpak 14d)
APARABSTRACT
IY10156IF DATABASE IN LINKED FILESYSTEM, AFTER UNCATALOGING AND THEN CATALOGING DB, LOCAL DB DIR. CHANGED AND DB CANNOT BE DROPPED.
IY11436DIA4804E ALONG WITH SQL30020 RC1245 IN DB2DIAG.LOG. UNABLE TO PR OCESS DEADLOCK REPLY MESSAGE IN THE MIDDLE OF QUERY PROCESSING.
IY11853RETRO-FIT DEFECT 244475 INTO V5.2 FCM TRAP
IY11882AUTOLOADER USES DB2ATLD_PWFILE WHEN AUTHENTICATION IS NOT SET
IY12295SIGNAL 11 TRAPS IN MEMORY OPERATIONS (MEMHOLDSEG AND SQLOFMBLK) COMING FROM SQLNO_CLOSE_POOL
JR14795DRDA LEVEL 2 COMMIT AND ROLLBACK FAIL, RC=00D34442
JR14892CHANGE WIN32 API CALL DUE TO LONG CONNECT DELAYS WHEN THERE ARE DISCONNECTED MAPPED NETWORK DRIVES: NT TERMINAL SERVER ONLY.
APAR fixes included in WR21191c (Fixpak 14c)
APARABSTRACT
IY07604SQLJ SQL0309 IF HOSTVARIABLE VALUE IS NULL ON UPDATE
IY10484LEAK IN DRDA HEAP WHEN CALLING STORED PROCEDURES RESULTS IN SQL0973.
IY10491SQLPROCEDURES YIELDS INCORRECT QUERY TO MVS V6.1
IY10504CALL STATEMENT RESULTS IN EXCESS DESCRIBEPARAM CALLS WITH JDBC
IY10794JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY
IY11030SQL30083 RC 24 WHEN TRYING TO CHANGE A PASSWORD LOCALLY FROM THE DB2 CLP USING A VALID PASSWORD
IY11097NULL BUFFER FROM FCM PASSED TO SQLKQ_DETACH_BUFFER LEADING TO HANG ON SMP OR MPP MACHINES.
IY11126THE EVENT MONITOR'S TRANACTION EVENT OUTPUT HAS A LOCK WAIT TIME GREATER THAN THE ELAPSED TIME FROM THE START AND STOP TIMESTAMPS
IY11136NO TEMP AVAILABLE ERROR IN DB2DIAG.LOG DURING ON-LINE BACKUP. SQLB_BACKUP_IN_PROGRESS ON TEMPTABLESPACE FOR A SHORT PERIOD.
IY11386APAR IY06317 MAY RESULT IN POOR COST ESTIMATE OF MERGE JOIN
IY11448DB2IUPDT SILENTLY CALLS DLFMUPDT
IY11527DB2 UDB - SQL0901 ERROR WITH MESSAGE 'NON-PIPED PARALLEL SORT ATTEMPTED' IN DB2DIAG.LOG.
IY11819SQLTABLES() CALL DOES NOT RETURN SCHEMA NAME FROM MVS DB TO THE JAVA APPLICATION IN OUR CLI LAYER.
IY11842SQLCODE -901 DURING TRIGGER USE WITH UDF
IY11855TRAP IN JNI (JAVA NATIVE INTERFACE) WHEN RUNNING A UDF REPEATEDLY.
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'
IY12016SQL0901N ON DYNAMIC SQL 'SQLNO_CRULE_SAVE_PLANS 100:RC(0)'
IY12126TABLESPACES OF 18 CHAR LENGTH NAMES MIGHT NOT BE BACKED UP
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.
JR14854NT: CONNECT HANGS RESULTING FROM LATCH ON GLOBAL INSTANCE QUEUE
APAR fixes included in WR21191b (Fixpak 14b)
APARABSTRACT
IY10861DATABASEMETADATA.GETCOLUMNS IS NOT HANDLING SCHEMAPATTERN='' CORRECTLY.
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.
IY11161FAILURE TO FIND A LOCK WITHIN LOCK TABLE, SQLPLUPDATETRANENTRY REPORTS FFFFF51D AT PROBE POINT 5
IY11375USEREXIT IS NOT BEING INVOKED EVEN THOUGH IT HAS BEEN SET UP PROPERLY.
JR14743DB2 TRAPS WHEN THERE IS NOT ENOUGH MEMORY ON THE SYSTEM.
JR14794DB2 LIST TABLES COMMAND CAUSES TRAP IN DB2 V5.2 FOR OS/2
APAR fixes included in WR21191a (Fixpak 14a)
APARABSTRACT
IY09385SQL1042 DURING CRASH RECOVERY DUE TO INDEX MANAGER PROGRAMMING ERROR (DIA3875C).
IY09499RANDOM TRAP IN SQLE_DB2RA_AS_DB_OPEN
IY09948JAVA STORED PROCEDURES NOT FOUND OUTSIDE SQLLIB\FUNCTION
IY10029QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204
IY10562DB2 UDB INTRA_PARALLEL ON - QUERY RETURNS AN SQL0955 ERROR AFTER WHICH ALL QUERIES WHICH REQUIRE SHARED SORT MEMORY FAIL.
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
IY10902CREATE VIEW WITH SCHEMA NAME TOO LONG GIVES SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR.
IY10955CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY11035DROP TABLESPACE MAY FAIL WITH SQL0290N IF THERE ARE REFERENTIAL INTEGRITY CONSTRAINTS ON THE TABLES WITHIN THE TABLESPACE.
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.
IY11129MULTITHREAD JDBC APPL. CRASHED WHEN JVIEW IS USED.
IY11162SQL03181W ON LOAD WITH A SPECIFIC IXF FILE, BUT NOT ON IMPORT
IY11182SIGNAL 11 ON SQLULTERMINATE AFTER SQL2043 DURING AUTOLOAD
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.
JR14625NT PERFORMANCE MONITOR NOT PROVIDING DETAILS FOR THE SECOND AND FOLLOWING APPLICATIONS
JR14648DBA3037 ON VISUAL EXPLAIN WHEN DETAILED STATISTICS COLLECTED ON SOME BUT NOT ALL INDEXES FOR A GIVEN TABLE
JR14723SQL1112 -NOT ENOUGH SYSTEM RESOURCES WHEN TRYING TO SCHEDULE ~100 JOBS FROM THE SCRIPT CENTER
JR14737THE CLIENT IS INCORRECTLY CREATING MULTIPLE SNA CONVERSATIONS USING THE SAME LUWID. THIS IS CAUSING DB2 OS 390 TO ABEND.
JR14759LOAD OF DEL FILE WHEN BOTH' CAST(NULL AS CHAR) USED IN EXPORT' & MODIFIED BY USEDEFAULTS IN LOAD : DATE INSERTED IS WRONG
JR14889CRASH WITH SQLCREATEDAT (PROBE: 100) MESSAGES IN THE DB2DIAG.LOG INDICATING THAT THE DAT OBJECT LIFE LSN IS NULL.
APAR fixes included in WR21191 (Fixpak 14)
APARABSTRACT
GG03727APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO.
GG04022CAPTURE POOR PERFORMANCE - IN CASES WHERE MANY TABLES ARE REGISTERED AND SUBSCRIBED , BUT FEW UPDATES TO BE CAPTURED
GG04027NO PRUNING OCCURS BEYOND THE LOWEST SYNCHPOINT AMONG ALL TABLES IN THE PRUNCNTL TABLE
GG04030UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION
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
GG04049UDB ASNAPPLY FAILS TO COMPLETE PARTIAL REPLICATION AFTER DISRUPTION
GG04050THE LOGIC USED BY APPLY TO CONNECT TO A SERVER IS WRONG. MULTIPLE LOGONS USED
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.
GG04059CAPTURE TRIED TO UNPACK A NULL DATE COLUMN. WHEN A COLUMN IS NULL CAPTURE SHOULD NOT UNPACK THE COLUMN.
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
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
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
GG04075CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE
GG04076ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG
GG04079OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS
GG04080APPLY CODE SHOULD GENERATE A ROW IF INSERT RETURNS A SQLCODE +100 OR SQLSTATE 02000. AT THIS POINT, THE CODE DOESN'T DO SO.
GG04083CAPTURE FOR UDB INCORRECTLY HANDLES LONG VARCHAR STRINGS OF ZERO LENGTH
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
GG04090TWO 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
IY08453SQL1227 RC 6 WHEN ATTEMPTING TO UPDATE STATISTICS WITH TABLE CARDINALITY OF 0 WHEN STATISTICS ALREADY EXIST
IY08935'ASNCMD <DB_NAME> STOP' DOES NOT STOP CAPTURE
IY08938'ASNCMD A STOP' IS PADDING BLANKS IN THE MIDDLE OF THE CCP FILE
IY09076SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL.
IY09251DB2 EEE V6 CRASH RECOVERY FAILS, SQL1042
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
IY09646UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE
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
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
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
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.
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.
IY10151MISSING UPDATES WHEN MAX_SYNCH_MINUTES IS SPECIFIED.
IY10199LEFT OR FULL OUTER JOIN PROBLEM WITH OPTIMIZER
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
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.
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
IY10223'ASNCMD <DB_NAME> STOP' DOES NOT STOP CAPTURE
IY10227'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
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
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
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
IY10317ASN0001E - CAPTURE CORE DUMPS IN RELEASELOG
IY10338CAPTURE HANGS/RETURNS SQL0204 WHEN 'SCHEMA'.'TABLE' HAS A SPACE
IY10340'ASNCMD STOP' RETURNS ERRNO 2
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
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
IY10382ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES
IY10474CRASH RECOVERY FAILS BECAUSE OF INTERRUPT RECEIVED DURING UNDO
IY10615SQL10003 ERROR RETURNED TO USER APPLICATIONS, AND LOGGED IN THE DB2DIAG.LOG FILE. MEMORY LEAK IN BSU HEAP
IY10644SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS
IY10648ROLLFORWARD FAILED WITH SQL4908N TABLESPACE LIST SPECIFIED FOR ROLLFORWARD RECOVERY ON DATABASE IS INVALID ON NODE(S)
IY10769EXPORT FROM A DB2 TABLE GIVE DEFAULT PERMISSION TO THE FILE OF 640. ON AIX, IT SHOULD BE 644.
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
IY10873OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS
IY10874OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS
IY10876OS/2 FAILS WITH MEMORY EXCEPTIONS ON LONG VARCHAR COLUMNS
IY10946SQLCODE811 FOR SQL REQUEST SELECT APPLY MVS ISOLATION LEVEL.
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
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
IY11018UPDATE ON TABLE WITH LONG FIELD WHEN OLD=NEW VALUE
IY11019ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES
IY11021ADDITIONAL LONG VARCHAR RESTART AND COMPENSATION FIXES
IY11022SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS
IY11024SUPPORT A TRIGGER THAT PRE-FILTERS CD RECORDS
IY11025CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
IY11028CAPTURE IS NOT HANDLING FOREIGN UPDATES PROPERLY
JR14541TRAP IN SQLE_DB2RA_AS_DB_OPEN WHEN FORCING AN APPLICATION. OCCURS WITH PARALLEL QUERY USING CLI
JR14606EXPORT OF DEL MODIFIED BY DECPT SUBSTITUTES PERIOD FOR ANY CHARACTER FOR ITALIAN VERSION DB2 ON NT
APAR fixes included in WR21180e (Fixpak 13e)
APARABSTRACT
IY03947DB2DART WITH /DP OPTION ABORTS WHEN DB2_STRIPED_CONTAINERS IS USED.
IY10668MEMORY CORRUPTION CAUSED BY TQS--DIRTY PARTIAL TUPLE SAVED FLG
JR14545SQL2034N (ADDRESS OF THE 'PASSWORD' PARAMETER NOT VALID) WHEN ATTEMPTING TO DO AN OFFLINE BACK FROM CLIENT CLP OR CC
JR14589TRAP IN SQLE_INTERRUPT_LOCALLY DURING FORCE APPLICATIONS ALL
JR14592CONNECT TO DATABASE ON NT HANGS IN STRICMP() C LIBRARY CALL
JR14605DIA3419C--NETBIOS NOT STARTED SUCCESSFULLY RC 3
APAR fixes included in WR21180d (Fixpak 13d)
APARABSTRACT
IY06572SEGMENTATION FAULT WHEN BINDING A SECOND TIME TO A CURSOR
IY09223ASYNCENABLE WITH DEFERRED PREPARE IS BROKEN IF SET AFTER PREPARE
IY09420INVOKING CLI ST. PROC AS 'CALL LIBRARYNAME!FUNCNAME()' (INSTEAD OF SCHEMA.PROCNAME) LEADS TO WRONG VALUE BEING FETCHED IN STPROC
IY09663DB2 CRASHED WITH ERROR DIA3816C CREATED BY SQM_EVMON_OSTREAM() SIG 11
IY09939ERRNO IS NOT RESET BEFORE CLI TYPE CONVERSION
IY10029QUALIFIER BIND OPTION FAILS AGAINST UDB AS WITH SQL0204
IY10390TERMINATING ADSM SESSION BEFRO RE-ESTABLISHING IT.
IY10432JDBC APPLICATION TRAPPING DUE TO MEMORY DE-ALLOCATION PROBLEMS WHEN THE PROCESS RUNS OUT OF MEMORY
IY10500INVALID CONVERSION/TYPE FOR DOUBLE WITH STORED PROC IN DB2/MVS 6
JR14581CONTROL CENTER TRAP ON V5.2 - EXCEPTION C0000005 IN DB2CC.EXE TRAP IS IN SQLEDTIN CALL - BROWSING DIRECTORY FOR BACKUP
APAR fixes included in WR21180c (Fixpak 13c)
APARABSTRACT
IY10088DIA3875C DELLEAF FAILURE USING INDEX that was CREATED ON PE V1.2 and then migrated to v5.2
JR14497DB2 CONNECT TRAPS IN SQLJDRD1 ALONG WITH AN ACCESS VIOLATION DR. WATSON ERROR ON NT
APAR fixes included in WR21180b (Fixpak 13b)
APARABSTRACT
IY09751DATABASE CRASH DUE TO TIMING HOLE IN CREATE TABLE ROLLBACK
IY09764TWO QUERIES DIFFERING ONLY IN THE ORDER OF THE PREDICATES, RETURN DIFFERENT RESULTS.
JR14355INVALID MEMORY ACCESS - C0000005 TRAP IN SQLRIVAL (TRAP FILE SHOWS SQLRICONSEC ) RUNNING QUERY WITH PARALLELISM
JR14496MIGRATION FROM V2.X TO V5.2 CAUSED PERFORMACE TO DEGRADE ON CONN ECTS DUE THE CHANGE IN LATCHING INTRODUCED IN V5.2
APAR fixes included in WR21180a (Fixpak 13a)
APARABSTRACT
IX87885TWO PHASE COMMIT. CLIENT CALLS A STORED PROCEDURE AND THEN COMMITS IS NOT PERFORMED.
IY04440BUFFERED INSERT ON LOG FULL CONDITION PRODUCES INCONSISTENT RESULTS.
IY06366SELECT WITH LEFT OUTER JOIN ON A VIEW MAY HAVE SLOW PERFORMANCE WHEN IN CLAUSE IS NOT PUSHED DOWN INTO MOST INNER SELECT.
IY06649DB2CART DUMPS HUGE AMTS OF DIA3605C & DIA3855CINTO DB2DIAG.LOG
IY07809AIX LOGIN LOGS NOT UPDATED WHEN CONNECT TO DB WITH WRONG PASSWD AFTER USER ACCOUNT IS LOCKED.
IY07870SQL1035N RETURNED WHILE DB IS IN ONLINE BACKUP AND SAME USER TRIES TO CONNECT TO IT
IY07880-902 IN SQLRRSTA DURING RUNSTATS INDICATING A MEMORY HEAP ERROR.
IY08060SQL0901N REASON 'SQLNO_NUM_CHARS_SPECIFIED 200 :RC( 0)') WHEN DB2CODEPAGE=1208
IY08219FAILURE ON DATABASE INITIALIZATION CAN LEAVE ORPHANED PREFETCHERS WRITING SQLOCSEMP MESSAGES TO DB2DIAG.LOG IN LOOP
IY08318CLI RETURNS DRIVER NOT CAPABLE FOR LONG VARCHAR TO AS/400
IY08714LOAD WITH REPLACE OPTION GIVES BAD PAGE ERROR IN DART OUTPUT
IY08857SPECIFIC INTRA PARALLEL QUERY NOT TAKING ADVANTAGE OF HI2KEY/LO2 KEY WITH MGJN
IY08948REORGCHK AT DIAGLEVEL 4 GENERATES -501 IN DB2DIAG.LOG FILE.
IY09149JDBC NET DRIVER RETURNS -99 ON EXECUTEUPDATE AGAINST DB2 MVS
IY09191IMPROVE DB2DIAG.LOG MESSAGES FOR RFWD TO PIT ERRORS
IY09202Signal#11 IN SQLO_INIT_MULTI_THREADING
IY09222FFFF A602(INVALID MEMORY ADDR) IN DB2DIAG.LOG AND CLI0120E IN JDBC.LOG
IY09267RUNSTATS RECEIVES SQL2314W
IY09287DB2 CRASHES AT FUNCTION SQLESRVR
IY09342SQL1042N TRYING TO CONNECT TO DB AFTER EVENT MONITOR PIPE READER IS GONE.
IY09367DB2 UDB - ONLINE/OFFLINE BACKUP TO MULTIPLE DISKS HANGS. NOTE: THIS IS A EXTENSION TO THE FIX FOR APAR IY04310.
IY09422MANUALLY UPDATING COLVALUE COLUMN IN SYSSTAT.COLDIST TABLE WITH A DATE VALUE DISPLAYS THE UPDATED VALUE WITHOUT SINGLE QUOTES.
IY09439SQL0901N THE SQL STATEMENT FAILED BECAUSE OF A NON-SEVERE SYSTEM ERROR.
IY09505INCORRECT COMPILE INSTRUCTIONS IN DB2UEXT2.CADSM FOR ADSM 3.1.6 OR HIGHER.
IY09605SQL0199N ON SQLSTATISTICS AGAINST MVS WITH CURSORHOLD=0
IY09650Signal#11 IN SQLKFFREEFCMRESOURCES
IY09664INCORRECT DATABASE SEED IN EEE ENVIRONMENT AFTER ADDING ADDITIONAL NODES SUCH THAT EVENT MONITOR FAILS ON NEW NODES.
IY09756NOT POSSIBLE TO REDIRECTED RESTORE STRIPED CONTAINERS. REDIRECTE D RESTORE SUCCEEDS, RESULTED CONTAINER(S) ARE NOT STRIPED.
IY09855CLI ENTRY CODE TRAPS TRYING TO FREE A CONNECTION THAT NO LONGER EXISTS
IY09908ROLLFORWARD TO PIT RETURNS INCORRECT MINIMUM PIT
JR14049SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG
JR14148ALWAYS TREAT '_' AS A CHARACTER WHEN IN CALL STMT-ST.PROC NAME
JR14237DB2GOV FAILS WHEN DB2NODES.CFG HAS BLANK LINE AT THE END
JR14239DURING ROLLFORWARD RECOVERY, WE SEE ERROR MESSAGES IN THE DB2DIA G.LOG STATING 'CANNOT STEAL SPACE FROM OTHER BUFFER POOLS.'
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.
JR14409TRAP FILE SHOWS TRAP IN SQLISETKEYANDKEYDATA (IN SQLIUNDO.C). HOWEVER, ACTUAL TRAP IS IN WRITELOG.
JR14412ACCESS 2000 FAILING WITH VARCHARS > 210 CHARACTERS
JR14415TRAP - MTS AND STORED PROCEDURES WHICH RETURN RESULT SETS
JR14416OS/2: AUTHENTICATON SERVER FAILS IF SECURITY IS SAME
JR14418JDBC 2.0 APP DRIVER SEGMENTATION FAULT WHEN EXECUTING QUERY.
JR14433PREPARED STAT GIVES NULL RESULTSET
JR14434FORCE APP ALL TRAPS TYPE 2 CONNECT APP IN OTHER WINDOW WHICH HAD INVOKED DOSSLEEP
JR14435CLI0165E CALLING STORED PROCEDURE WITH ASYNC ON AND BLOB COLUMN
JR14436Garbage characters in the DB2 recovery history file when using the sqluvtun API.
JR14456BINDING FROM A V5.2 CLIENT TO A V2 SERVER FAILS WITH SQL0206N ON DB2UIGSI.BND AS SYSIBM.SYSTABLES.ROWTYPENAME DOESN'T EXIST IN V2
JR14462DB2BATCH THROWS AN ERROR AT THE END OF EXECUTION (DB2SYS.DLL)
JR14474JDBC MULTIPLE SESSION PROBLEM: CLI0601 ERRORS.
JR14476WORKAROUND FOR DB2 UDB TO IGNORE THE VERSION OPTION SPECIFIED AT BIND TIME WHEN USING DPROPR
JR14478SQL2032 IN APPLICATION WHEN POINTER CHECKING ENABLED (DB2CHKPTR= YES)
JR14506JAVA MULTIPLE SESSION PROBLEM WITH THE .APP. DRIVER.
JR14507DB2 CONNECT EE 6.1 CONNECTING TO DB2 UDB 5.2 OVER DRDA RESULTS IN INTERMITTED SQL30021N ERRORS.
JR14526SQL0301 WITH JDBC NET DRIVER ON INSERT/UPDATE OF MULTIPLE BLOB COLUMNS WITH NULL, NON-NULL COMBINATIONS.
APAR fixes included in WR21180 (Fixpak 13)
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
GG03993CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES
GG03997SQLCODE9082 CAPTURE_BASE_CHANGE() / LONG VARCHAR DELETE RECORD
GG03999CAPTURE CORE DUMPS AROUND PRINT_LSN()
GG04000ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
GG04001ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
GG04002APPLY FAILED WITH SQLCODE104 WHEN COPYING FROM VM SQL/DS SOURCE
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
GG04010LONG VARCHAR FIELDS CAN BECOME OVERLAID
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.
GG04019CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS
GG04020WHEN PARTITION_KEYS_CHG='Y'CAPTURE DOESN'T ALWAYS BREAK ALL UPDATE VARIATIONS TO DELETE AND INSERT.
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
GG04029CAPTURE ABENDS WITH A DR WATSON WHEN ROWS IN THE PRUNCNTL TABLE WITHOUT CORRESPONDING ROWS IN THE REGISTER TABLE
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
IY03632RECONCILE DLREPORT NEEDS TO BE TERMINATED WITH /
IY05644SQLCODE334 APPEARED DURING APPLY OPERATION. REPLICATION FROM AS/400(CAPTURE) TO RS/6000(APPLY) BY DPROPR
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
IY06649DB2CART DUMPS HUGE AMTS OF DIA3605C & DIA3855CINTO DB2DIAG.LOG
IY06891CAPTURE ABEND ON DELETE OF TABLE WITH LONG VARCHAR AND MORE LONG VARCHAR COLUMNS THAN OTHER TABLES
IY07053CAPTURE RETURNS TO OLDER LOG INSTEAD OF ADVANCING TO THE NEW LOG ON REPEATED COLD STARTS.
IY07523ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
IY07527ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
IY07528ERRCODE 7E0105 WITH NO SQLSTATE AVAILABLE
IY07550SQL1042N DURING A ROLLFORWARD OF A V5.X DATABASE THAT HAS BEEN MIGRATED FROM V2.X DATABASE.
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
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
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
IY07711DB2CCLST LEAVES DEFUNCT PROCESSES ON UNIX PLATFORMS WITH MULTIPLE LOGICAL NODES.
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
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.
IY07884JDBC APPLICTION WAS CRASHING DUE TO NULL MEMORY BEING FREED BY THE CLI LAYER
IY07908ROWCOUNT > 10000000 IN LOAD COMMAND CAUSES INSTANCE CRASH
IY07951JAVA UDFS WITH DECIMAL PARAMETERS PERFOMANCE DEGRADS
IY08007UNABLE TO START MULTIPLE CAPTURES ON UNIX SYSTEMS ASN0027W / ASN0027
IY08008DLFM SHUT DOWN WHEN YOU FORCE THE COPY DAEMON'S ADSM SESSION TO TERMINATE OR RECYCLE THEIR ADSM SERVER.
IY08076LONG VARCHAR FIELDS CAN BECOME OVERLAID
IY08077LONG VARCHAR FIELDS CAN BECOME OVERLAID
IY08085LONG VARCHAR FIELDS CAN BECOME OVERLAID
IY08124INSERTS ARE MISSED BY CAPTURE
IY08125SQLTABLES() CALL IS NOT RETURNING INOPERATIVE VIEWS FROM A UDB DATABASE.
IY08391TRAP AT SQLBPFDESTROY AND PREFETCHER ERROR RC = -20444
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
IY08569ROLLFORWARD OF DATABASE CAUSES CORRUPTION OF LOB DATA
IY08584MULTIPLE IN PREDICATE WITH OUTER JOIN CAUSES EXPLAIN ERROR
IY08716HASH JOIN MAY RESULT IN ENDLESS LOOP
IY08755-901:BAD PLAN: UNRESOLVED QNC FOUND
IY09146FIX FOR PERFORMANCE PROBLEM CAUSED BY JR13499
IY09490QUERIES RESULTING IN LARGE DATA SETS CRASHES DATABASE WITH UNEXP ECTED EOF DUE TO TEMP TABLESPACES CONTAINER TRUNCATION (F609)
JR13908BETTER FILTER FACTOR FOR 'CONST = CONST' PREDICATES AND QRW NEEDS TO ELIMINATE OR(1=0) PREDICATES.
JR14061JDBC APP FAILS AGAINST UDB WHEN COMMA SEPARATOR IS USED.
JR14263WRONG WEEK NUMBER RETURNED FROM WEEK FUNCTION
JR14279SQLEXTENDEDFETCH RETURNS SUCCESSWITHINFO IF A FETCH OF ONE ROW FAILS DUE TO TIMEOUT OR DEADLOCK. RETURN SHOULD BE SQLERROR.
JR14312DB2 COBOL PRECOMPILER TO GENERATE COPY 'SQLCA.CBL' INSTEAD OF COPY 'SQLCA.CBL'
JR14337CANNOT LOAD DDCS.DLL ON OS/2 SQL1108 ON REMOTE CLIENT CONNECTION
JR14347PATCH1=4096 DOES NOT WORK PROPERLY AGAINST MVS WHEN EARLY-CLOSE IS ENABLED
JR14356SQL1331N RC=SQL_CPIC_SECURITY_NONE WHEN USING APPN TO HOST IN DB2 CONNECT EE 5.2 (FIXPAK12).
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
JR14401DB2 UDB - LOAD FAILS WITH SQL1350. DB2DIAG.LOG FILE REPORTS -551 ERROR IN SQLR_TURNOFF_CONSTRAINTS
APAR fixes included in WR21166e (Fixpak 12e)
APARABSTRACT
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
IY08204NON CONSTANT 'PULLUP' IN THE OPTIMIZER CAUSING QUERY PERFORMANCE PROBLEMS.
IY08223ATTEMPT TO ALLOCATE ADDITIONAL LOGSPACE BEYOND CONFIGURED LOGS AS REQUIRED IN ORDER TO ALLOW CRASH RECOVERY TO COMPLETE
IY08304BP PAGESIZE WRONG WHEN CREATED ON NODE USING ALTER BUFFERPOOL
IY8309MEMORY LEAK IN UTILITY HEAP SIZE
JR14282SQL30020, OR AN ABEND ON DB2 FOR OS/390 WHEN INVOKING A STORED PROCEDURE WITH OUTPUT PARMS LONGER THAN THE BLOCK SIZE (32K)
APAR fixes included in WR21166d (Fixpak 12d)
APARABSTRACT
IY03602SQL0980C BAD PAGE ENCOUNTED DURING LOAD RESTART
IY07986DB2 UDB - A CONNECT ATTEMPT FAILS WITH AN OUT OF MEMORY ERROR.
IY08024DB2 UDB - PAGE CLEANERS MAY LOOP CAUSING PERFORMANCE DEGRADATION WHEN MULTIPLE BUFFERPOOLS ARE DEFINED.
JR14077DB2/OS2: DB2SYSC.EXE TRAPS IN _UFREE (C RUNTIME) CALLED FROM _REGEN_EXCEPTION CALLED FROM SQLOADDENVSTRING
JR14125OS2 ONLY: TRAP IN GETENV() WHEN REFERENCING DAYNAME , MONTHNAME UDFS
APAR fixes included in WR21166c (Fixpak 12c)
APARABSTRACT
IY04139SQL5153 NEEDED INSTEAD OF SQL30081 ON CLIENT WHEN NO FCM RQBLK IS AVAILABLE. SERVER ERROR SQL6043 IS FINE.
IY06126QUERY THAT EXECUTES IN PE 1.2 FAILS WITH SQL0101 AT OPTIMIZAITON LEVELS < 7 AND STMTHEAP < 60000
IY06432RUNSTATS WITH DISTRIBUTION CAUSES INCORRECT FILTER FACTOR WHEN GENERATING ACCESS PLAN.
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.
IY07076TRAPS IN SQLRISR2 SQLSFETC SQLRISRT SQLRIRST EXECUTING SQL
IY07092CHANGE OPTIMIZER COSTING TO HANDLE NULLS
IY07110-901:SQLNO_SMP_CREATE_TQ
IY07216SELECTING 'INDEXES' FROM CC CRASHES OR HANGS THE CC.
IY07309SQL3508 REASON 4 ON LOAD WITH DELETE PHASE OR LOAD RESTART WHEN TABLE ID > 32767 (APPEARS NEGATIVE IN SYSTEM CATALOGS).
IY07311HASH JOIN FAILS WITH MEMORY ALLOCATION ERROR. INITIALIZATION FAILS CAUSING SUBAGENTS TO FAIL DURING MEMORY ALLOCATION.
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
IY07483STORED PROCEDURE FAILS TO PASS LOB DATA BACK TO THE CLIENT USING THE NET DRIVER
IY07510TRAP IN SQLNR_SCALAR20J_ACTION
IY07553SQL0902 RETURNED WHEN SOME QUERIES THAT HAVE THE COUNT CLAUSE ARE EXECUTED.
IY07600QUERY PERFORMANCE AGAINST >4 TABLES IS NEGATIVELY AFFECTED BY THE CONTENT/LENGTH OF THE LIKE PREDICATE STRING.
IY07623SIGNAL #11 TRAP IN SQLORQUE2()
IY07735SQL0433N ENCOUNTERED WHILE DOING A BUFFERED INSERT
IY07737Signal#11 encountered during sort when tempspace is exceeded.
IY07739OPTIMIZER PREDICATE PROBLEM ON EEE WITH QUERY WRITTEN WITH UNION ALL
IY07796CMDEAL WITH TYPE CM_DEALLOCATE_ABEND DOESN'T RETURN
IY07922THE IN PREDICATE IN THE QUERY IS NOT PUSHED DOWN DUE TO OJ
IY07957DBHEAP OUT OF MEMORY (D602) DURING CRASH RECOVERY
JR13651SQL2029N, RC=28 ON RESTORE ISSUED FROM CLIENT WITH A DIFFERENT ALIAS THAN THE SERVER - USING SYTOS USEREXIT
JR13887ERRONEOUS 'FAILED TO COMMIT' MESSAGE DUMPED TO DB2DIAG.LOG LOAD INCORRECTLY HANDLES POSITIVE RETURN CODE FROM COMMIT
JR14003CALLING A STORED PROCEDURE FROM A V6.1 CLIENT (FROM A CLI APPLICATION) RESULTS IN SQL0804 WITH RC=103
JR14077DB2/OS2: DB2SYSC.EXE TRAPS IN _UFREE (C RUNTIME) CALLED FROM _REGEN_EXCEPTION CALLED FROM SQLOADDENVSTRING
JR14112CLI0118E WITH 'SELECT {FN UCASE(T1.COL1)} FROM TABLE1 T1'
JR14169ALTER TABLE ADD COLUMN ON A TABLE WITH CLUSTERING INDEXES CRASHES THE DATABASE
JR14174SQL1403 WHEN CONNECTING TO DATABASE ON NT USING A USERID THAT IS THE SAME AS A DOMAIN NAME
JR14184MULTITHREADED FIXES NEED TO BE DONE TO DB2JD DUE TO VARIOUS PROB LEMS (EXAMPLE: DB2JD BECOMES UNAVAILABLE INTERMITTENTLY)
JR14194SQL0007N WITH SQLJ WHEN CALL STATEMENT INCLUDES A HOST VARIABLE
JR14229SQJ0201E DURING SQLJ CUSTOMIZATION OF CALL STATEMENT
JR14234DB2 UDB - INSTANCE CRASHES WITH A SIGNAL 11 TRAP IN FUNCTION SQLEDATABASEBAD WHEN DB2 ATTEMPTS TO MARK THE DATABASE AS BAD.
JR14238TRAP (C0000005) IN SQLUEXPM IN DB2BP.EXE DURING EXPORT - CAUSED IN PART BY A FILE SHARING VIOLATION ON THE MESSAGES FILE.
APAR fixes included in WR21166b (Fixpak 12b)
APARABSTRACT
IY04033INCORRECTLY PARSING AUTOLOADER INPUT PARAMETERS.
IY04375LOAD AGENTS DO NOT TERMINATE WHEN INPUT PIPES ARE BLOCKED DB2 FORCE DOES NOT FORCE THESE AGENTS
IY06187LOAD TRAPS (SQLBLOADGETEXTENT) IN ERROR PROCESSING..
IY06691SQL4970 ON ROLLFORWARD TO END OF LOGS - 'UNEXPECTED FILECOUNT'
IY06717DDL GENERATED BY DB2LOOK FOR UNIQUE INDEXES CAN BE IMPROVED.
IY06791DB2 UDB - SQL3021/SQL0204 ON IMPORT REPLACE TO A ALIAS NAME FOR A TABLE IN WHICH THE USER HAS CONTROL ACCESS TO.
IY06808INCORRECT NODE NUMBER PICKED UP IF ISSUING A CONNECT FROM A NODE THAT IS NOT IN THE DB2NODES.CFG AND DB2NODE IS NOT SET.
IY06932SQL0973 QUERY_HEAP AFTER REPEATED ERRORS WHEN USING DESCRIBE DA (CLI)
IY07038INCORRECT RESULT WITH LARGE ASLHEAPSZ
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
IY07117SIGNAL #11 IN FROM SQLRR_DUMP_SECTION WHILE EXECUTING A DB2_CALL _STACK
IY07120INSTANCE CRASHES WITH SIG#11 ON EXECUTION OF SELECT STATEMENT WITH UNION CLAUSE .
IY07235DB2DIAG.LOG AND TRAP FILE GROWS VERY LARGE AFTER SECOND INSERT UPON TABLESPACE FULL CONDITION.
IY07244SEARCH FOR FREE SPACE IS DONE EVEN IF APPEND MODE ON TABLE.
IY07320DROP TABLE FAILS WITH SQL1007N
JR12399FROM CONTROL CENTRE WHEN TRY TO FORCE MORE THAN TWO APPLICATIONS USING APP ID'S, THE OPERATION FAILS,INVALID AGENT ID.
JR13185JAVA APPLICATION RECEIVING SQL0502 DURING NORMAL COURSE OF OPERATION
JR14024INCORRECT CALL STATMENT USED WHEN CALLING STORED PROCEDURES ON AS400 SERVERS. USING LITERALS AS PARAMTERS.
JR14049SQLM_STMT_END INCORRECTLY ENTERED IN THE DIALOG
JR14085SQL2025 FROM LOAD WITH DB2NTNOCACHE=ON
JR14115SQL3324N ERROR WHEN SQLDA PROCESS UNINITIALIZE SQLVAR WHICH GIVE SQLTYPE VALUE.
JR14116-514 ON SQLEXECUTE() FOLLOWING COMMIT ON OPEN CURSORS ON HOST
JR14127DB2 UDB V5.2 - TRAP IN FUNCTION SQLNQ_FINDFN WHEN RUNNING A SIMPLE SQL QUERY.
JR14152SQLJ EXHAUSTS CURSOR HANDLES AFTER 11613 STATEMENTS CLI0129E NO MORE HANDLES IS RETURNED
APAR fixes included in WR21166a (Fixpak 12a)
APARABSTRACT
IY03544CREATE DATABASE ON LARGE NUMBER OF NODES MAY HANG
IY03698CLI ARRAY INSERT PROBLEM WHEN ALL FIELDS IN A RECORD ARE NULL
IY04404DB2CLI.INI PASSWORD SETTING (PWD) OVERRIDES AUTOLOADER.CFG PASSWORD SETTINGSO THAT DB2ATLD FAILS TO CONNECT TO DB
IY05169SQL3015N ON LOAD INTO TABLE WITH MIXED CASE TABLE NAME.
IY05294DB2DARI PROCESS COUNTER NOT DECREMENTED IN CASE OF ABEND
IY05535QUERY TO DB2/MVS IS BEING TIMEDOUT EVEN IF NOT INTERRUPT ENABLED
IY05732CLI REPORTS THAT UDB DOES NOT SUPPORT INOPERATIVE VIEWS -IT DOES
IY05871DLFM RETRIEVE_QUERY FAILS WHEN CMD LINE OPTIONS GIVEN BUT PROMPTS AND WORKS WHEN NO OPTIONS SPECIFIED
IY06066PUTTING ASYNCENABLE BACK INTO CLI
IY06080LOAD TRAPS IN DB2LTSC PROCESS - UNINITIALIZED WAITLIST POINTER
IY06094SQLJ: DB2PROFC COMMAND WITH PRECOMPILE OPTION QUALIFIER <SHEMA N AME> GIVES SQL0204N
IY06163NON-SELECT STATEMENT ISSUED THROUGH CLI BRINGS DOWN DATABASE ON COMMIT
IY06164WHEN AUTOCOMMIT IS ON AND SQLEXECDIRECT RETURNS A NEGATIVE SQLCODE, NO COMMIT IS SENT TO THE TARGET DATABASE.
IY06211INCORRECT QUERY RESULTS USING WHEN CASE STATEMENT WITH IN CLAUSE.
IY06215SQL0998 RETURNED TO CICS APPLICATIONS ISSUING STATIC ROLLBACKS, OR STATIC COMMITS.
IY06234JDBC RETRIEVAL OF NON-US CLOB TRAPS
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
IY06347TCP LISTENER HANGS IN SQLEGETAGENT UNDER HIGH WORKLOADS
IY06376SIGNAL#4 IN SQLRINTP
IY06420EVENT MONITOR RETURNS ZERO FOR PREFETCH_WAIT_TIME
IY06434FIRST DB2START FAILS AFTER AIX V4.3 REBOOT
IY06599QUERY WITH UNION OVER JOINS GIVES WRONG RESULT
IY06660OPTIMIZER NEGLECTS TO CHOSE AN AST IN ITS ACCESS PLAN
IY06806DB2 CONNECT TRAPS IN SQLE_DB2RA_AS_DB_BLOCK_FETCH, WHEN CLIENTS CONNECT TO EE/EEE DATABASES THROUGH THE GATEWAY.
JR13441INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED
JR13679SYSLEVEL ON DB2/OS2 SERVER ALWAYS SHOWS EE PRODUCT INSTEAD OF THE INSTALLED DB2 PRODUCT.
JR13824JAVA I/O EXCEPTION ON WRITE TO BLOB OBJECT FROM STORED PROC
JR13862DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT
JR13880RETURN THE ODBC SCALAR NUMERIC FUNCTIONS SUPPORTED BY DB2/MVS
JR13925HANG DUE TO SEMAPHORE WAIT CONDITION DURING SQLALLOCCONNECT
JR13974FILTER FACTOR FOR ALWAYS-TRUE PREDICATE CAUSE SLOW QUERIES
JR14025SQL3181W WARNING GENERATED ON LOAD FOR A VALID IXF FILE
APAR fixes included in WR21166 (Fixpak 12)
APARABSTRACT
GG03644LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5
GG03962SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
GG03963APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS
GG03964APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS
GG03965SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS
GG03966SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS
GG03967LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5
GG03968SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
GG03969GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED
GG03970GETLSEQ COMMAND RETURNS THE CURRENT TIMESTAMP , NOT THE TIMESTAMP WHEN THE LOG WAS CREATED
GG03974SQLCODE100 - APPLICATIONS SUCH AS PEOPLESOFT HAVE UNIQUE INDEXES ONLY RATHER THAN PRIMARY KEYS , ALLOWING FOR NULLABLE COLUMNS
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
IC24358CHECK IN DJRA.EXE FOR V5.2
IX83660SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS
IY01325TRAP IN SQLE_MRSPSENDDARISTAR
IY03678TRAP INDICATING SQLFXSYS_X AS FAILING FUNCTION.
IY04173DB2ADUTL DOES NOT GUARANTEE ORDER WHEN EXTRACTING LOGS FROM ADSM IF MULTIPLE COPIES OF THE LOGS EXIST.
IY04310DB2 UDB - ONLINE/OFFLINE BACKUP TO SEVERAL DISKS HANGS.
IY04339TRAP IN LOAD WHEN TEMP SORT FILE > 2GB SQLU_SMGETFREEPG()
IY04445LOAD USING FASTPARSE MODIFIER AND DATE COLUMNS DEFINED AS NOT NU LL MAY DUMP 'RECORD LENGTH 0...' MESSAGES IN DB2DIAG.LOG
IY04496DB2LOOK UTILITY MISTAKES IN THE HELP TEXT WITH THE -H OPTION
IY04799APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS
IY04800APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS
IY04839SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS
IY04840SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS
IY04841SQLCODE0304 ERRORCODE=080102 DURING ASNAPPLY FUNCTION WHEN ROWS
IY04843LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5
IY04844LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5
IY04845LOSS OF CORRECT VALUE IN IBMSNAP_SUBS_SET OF APPLY/2 V5
IY04848SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
IY04849SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
IY04850SYNCHPOINT AND SYNCHTIME ARE NOT ADVANCING CORRECTLY WHEN USING THE MOBILE OPTION ON ASNCCP
IY05319OPTIMIZER PROBLEM WITH THE FILTER FACTOR WHERE WE DO NO ACCOUNT FOR DATA CORRELATION LEADING TO ANOTHER INDEX BEING USED...
IY05590DB2IUPDT IN FP11 RESETS DB2PROFILE 99/11/11 PTF PECHANGE
IY05591DB2 LOOPS, THROUGHT 2 LOG FILES, DURING ROLLFORWARD COMMAND
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
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
IY05745BUFFERPOOL CORRUPTION
IY05751SQLBINDPARAMETER WITH IBSCALE CHANGING ONLY - DB2 SHOULD IGNORE THIS AND NOT 'RE-DESCRIBE' THE COLUMN. RESULT - CLI0109 ERROR.
IY05823TIMING HOLE IN THE COMPUTATION OF APPLICATION IDLE TIME CAN RESULT IN NEGATIVE NUMBERS IN THE APPL_IDLE_TIME ELEMENT.
IY05826REMOTE MONITORING DOES NOT WORK FROM A CLIENT AGAINST UDB 5.2/HP-UX SERVER.
IY05892CLP THROUGHPUT IMPROVEMENTS
IY05910INTERRUPTS GENERATED WITHIN COMMSERVER FLOODED DB2DAIG.LOG WITH DIA3107E ERRORNO '4'.
IY05913DB2ATLD BOUNDARY CONDITION CRASH IF LINEFEED IS ON A MULTIPLE OF THE 32K DATA FILE
IY05980CTRL-C APPLICATION CAUSES TRAP IN SQLEIAGT_CB
IY06097SQLBINDPARAM CALL COREDUMPS AFTER SELECT IS DONE, THEN ARRAY INS ERT IS ATTEMPTED.
IY06145ASCII FUNCTION RETURNS INCORRECT OUTPUT
IY06740DB SIZE ESTIMATE CALCULATED INCORRECTLY FOR BACKUP TO ADSM. HENCE, THE ADSM RECOVERY LOG BECOMES VERY LARGE.
JR13441INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED
JR13750MULTIPLICATION OF DECIMAL CONSTANT GIVES INCORRECT RESULT
JR13862DB2GOV FAILED TO START IN WINNT/TERMINAL SERVER ENVIRONMENT
JR13902ROWSTATUS ARRAY INCORRECT WHEN -911 (DEADLOCK) OCCURS.
JR13927IMPLEMENT NEW BIDI LAYOUT TRANSFORMATION ROUTINE WITH MORE STRIN GENT ERROR CHECKING, MEMORY ALLOC, AND BIDI CCSID STRING TYPES.
JR13949DEFFERRED PREPARE RETURNS OPEN CURSOR FOR LARGE RESULT SETS.
JR13957CURSOR WITH HOLD NOT ALLOWED IN CICS
JR13972COMMIT IN LOAD WAS UNEXPECTEDLY INTERRUPTED.
PQ30351DPROPR APPLY, STL CMVC LEVEL PQ30351 FOR V5.2 FPK 12
TRCFLOWINVOCATION PARAMETERS
APAR fixes included in WR21140c (Fixpak 11c)
APARABSTRACT
IY02577DESCRIBE FAILS FOR UNICODE DB WITH A CODEPAGE CONVERSION
IY03903AFTER A TABLESPACE RESTORE, A 'ROLLFORARD QUERY STATUS' DOES NOT SHOW INFORMATION IN THE 'NEXT LOG TO BE READ' FIELD.
IY04401SQL1042 AT RESTART DB AFTER CRASH AT ALTER BUFFERPOOL
IY04414DARI PROCESS DOES NOT PICK UP GROUP ID FROM .FENCED FILE
IY04471-902 FROM SQLRIGTQ
IY04656DBSNAP.C SQLMONSS CALLED WITH SQLM_DBMON_VERSION2, SHOULD BE EIT HER SQL_DBMON_VERSION52 OR SQL_CURRENT_VERSION
IY04909SIGNAL #4 TRAP DURING BUILD PHASE OF LOAD
IY04947SQLCODE -433 RETURNED ON A BUFFERED INSERT
IY05040TRAP, SIGNAL #11, IN THE OPTIMIZER, SQLNO_CRULE_STARJN_AND().
IY05051CATALOG CACHE MAY CAUSE LONG LOCKS TO BE HELD IN SYSTABLES
IY05114SQLM_COLLECTED.NODE_NUM NOT BEING SET WHEN SNAPSHOT TAKEN AGAINS T LOGICAL NODES OF A EEE INSTALLATION
IY05115SELECT COLUMN LIST > 4005 AND ORDER BY CAUSES SQL1224.
IY05123DB2 MONITOR LOCK SNAPSHOT MAY NOT SHOW LOCKS BEING HELD ON CATAL OG PARTITION DURING STATEMENT COMPLIATION
IY05131CLI0165E WHEN USING SQLEXTENDEDFETCH WITH ASYNC MODE ON
IY05176DBM CRASHES DUE TO A SIGNAL #11 IN SQLVDECADDEC
IY05186CREATE TABLE IN EEE WITH PARTITIONING KEY USING HASHINGDOES NOT UPDATE PARTITION_MODE IN SYSTEM CATALOGS.
IY05192SQLSTATISTICS() QUERY FAILING WITH CLI0165E ERROR IN ROW
IY05217READX() RETURNING ZERO BYTE TRAPPED MEMTREEDEL, CORRUPTED DB2RA RECEIVED AT SERVER AND LOADED CPU
IY05292DBA2065 TRYING TO RUN OR SCHEDULE SCRIPT FROM SCRIPT CENTER.
IY05315BAD ACCESS PLAN FOR WHERE <COL> IN (VAR1,VAR2....VARN)
IY05326NULL INDICATORS ON OUTPUT SQLDA FROM STORED PROCEDURE NOT BEING CHECKED BY CLI WHEN WARNING ISSUED.
IY05406JAVA INSERT USING SETSTRING TO DECIMAL COL TRUNCATES DECIMALS
IY05426SQL1034N FOLLOWED BY INTERRUPTING ROLLBACK OPERATION
IY05446ADD PATCH VALUE TO RETURN TRUE ISO TIMESTAMP FORMAT FROM CLI
IY05483FIX FOR SPM ON SUN ULTRASPARC (SUN4U) ARCHITECTURE
IY05608CLI_MEMFREE TRAPS IN CLI_DSTFREEINFO WHEN OUT OF MEMORY
JR13441INITIALIZE TAPE RETURNS DB21059E WHEN A VALID BLOCKSIZE IS ISSUED
JR13711CLI0118E ON 'SELECT{FN CONCAT(SUBSTRING('ABC',1,2),'B')} FROM T1
JR13713SQL0804N WHEN INPUT PARAM TO STORED PROC ON HOST IS NULL
JR13816CONTROL CENTRE ABENDS AFTER DISCONNECT FROM DB WHEN SNAPSHOT MONITORS RUNNING
JR13821DB2FLSN CAUSES SYS3175 TRAP IN OS/2
JR13829ADD DB2CLIV2.BND IN .LST FILE FOR DRDA SERVERS (FUNCTION ADDED)
JR13837ADD CLI HANDLE INFORMATION TO DB2 TRACING
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.
JR13909DB2LOOK INSERTS COMMAS INTO DDL INSTEAD OF DECIMAL POINT FOR FLOATING POINT NUMBERS IN CERTAIN LOCALES/TERRITORIES
JR13922THIN CLIENT INSTALLING OLDER ODBC*.DLLS
APAR fixes included in WR21140b (Fixpak 11b)
APARABSTRACT
IX87013TEMPORARY FILES ARE CREATED USING BLOB WITH JAVA PROGRAMS
IY03820REMOVE DB2START CALL FROM DB2EXFMT
IY03823NIS: CONNECT ... CHANGE PASSWORD 'FAILS' WITH SQL1403N. WAIT TIME IS NECESSARY FOR PASSWORD TO REFRESH BY NIS SERVER.
IY03846EVENT MONITOR STATE IS NOT UPDATED IN THE SYSTEM CATALOGS CORRECTLY IF EVENT MONITOR DOES NOT EXIST ON THE CATALOG NODE
IY03855EVENT MONITOR WITH AUTH_ID CONDITION DO NOT FILTER FOR EXISTING CONNECTIONS WHEN AT NODE IS USED.
IY04225INFINITE LOOP IN DB2GOVD DURING ERROR HANDLING IF DB2GOV LOG FILES ARE REMOVED. INFINITE ERRORS TO STDOUT.
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
IY04333-516 ON DESCRIBE CAUSING LOOPING IN CLI
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.
IY04461TRAP, SIGNAL #11 IN, SQLNN_CMPL_CLEANUP(), CLEAN UP ROUTINE IN THE OPTIMIZER
IY04462CLI0109E 'STRING DATA RIGHT TRUNCATION' ERROR OCCURS AT FIXPACK 10 LEVEL WHEN TRYING TO INSERT BINARY DATA
IY04502DB2CLI.H HEADER INCORRECT FOR SUN
IY04732SQL0902 RC=126 AT DROP TEMP TABLESPACE
IY04769NODEXXXX AND CATNXXXX NOT UPDATED CORRECTLY ON BACKUP IMAGES EXTRACTED FROM ADSM WITH DB2ADUTL
IY04798TRUST APP IS USING AN INVALID MEMORY ADDRESS
IY04881DB2 INSTANCE ABENDS WHEN ACCESSING A LONG FIELD. SPECIFICALLY A NEWX ENTRY IS PUT INTO DB2DIAG.LOG.
IY04893SETTING DB2_MMAP_READ PROBLEM COULD PREVENT FIRST CONNECT
IY05015FIRST CALL TO LOADQUERY() FAILS WITH ENOMEM
JR12796SQLCOLUMNS() CALL WITH ONLY TABLE NAME DISREGARDS SCHEMALIST AND CURRENTSQLID
JR13437TRAP IN DB2APP.DLL IN SQLFETCH OF BLOBLOCATOR
JR13653JDBC APPS AUTOCOMMIT IF STORE PROCEDURE CALL IS MADE. EXPLICIT ROLLBACK NOT POSSIBLE AFTER STP CALL.
JR13684SQL0901 IN FUNCTION SQLNO_SMP_CREATE_SHARED_SO
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.
JR13783PARMLIST SYNTAX ERROR ON STORED PROCEDURE CALL TO MVS
JR13795DEFERRED PREPARE ALWAYS ON
JR14088100% CPU OR HANG SYMPTOMS DURING INSERT 99/12/21 PTF PE CHANGE
APAR fixes included in WR21140a (Fixpak 11a)
APARABSTRACT
IY02032TABLE ACCESSABLE AFTER ROLL FORWARD THROUGH AN NONRECOVABLE LOAD
IY03631DB2_RECON_AIDPACKAGING IN EE
IY03689ADDITIONAL INFORMATION TO BE DUMPED IN DB2DIAG.LOG WHEN A BAD PAGE IN MEMORY IS ENCOUNTERED.
IY03853SQLRA_COMPILE_VAR MESSAGES AT DIAGLEVEL 4 WHEN ON ERROR OCCURRED
IY03855EVENT MONITOR WITH AUTH_ID CONDITION DO NOT FILTER FOR EXISTING CONNECTIONS WHEN AT NODE IS USED.
IY04062WHEN USING TEXT EXTENDERS AND UDB, C++ DESTRUCTORS IN LIBIBMCLS.A CAUSE TRAPS IN LIBDB2LAI.A (REF. COUNT OUT OF SYNC).
IY04202MULTI DEADLOCKS BRING DB DOWN WITH SQL0901 (STMT NOT FOUND!)
IY04240CERTAIN QUERIES THAT RAN ON V5 RETURN SQL0101 - QUERY TOO COMPLEX ON V5.2.
IY04291-901 IN SQLRI_CLOSE_UDF_EOT(), -1034 DBM CRAHES
JR13397LIST HISTORY SHOWS BACKUP FILE ON WRONG NODE.
JR13475RETRIEVING A CLOB SUB-STRING GREATER THAN 32KB TRAPS ON THE GATEWAY.
JR13645SQLCOLUMNS RETURNS INCORRECT INFORMATION FOR DEFAULT VALUE
JR13708CLI APP TRAPS WHEN CLI TRACE IS ON AND SQLFETCH RETURNS != SQL_SUCCESS
JR13736SQLDESCRIBEPARAM FAILS ON DEFERRED PREPARE OF >= 26 COLUMNS.
APAR fixes included in WR21140 (Fixpak 11)
APARABSTRACT
GG03923GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS
GG03924SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT
GG03933BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET
GG03938UNABLE TO GET GOCAPT FOR SOME TABLES
GG03939ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE
GG03940ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE
GG03941DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT
GG03942GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION
GG03943GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS
GG03944BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET
GG03945ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE.
GG03946ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE.
GG03947DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT
GG03948UNABLE TO GET GOCAPT FOR SOME TABLES
GG03949DPROPR FAILS ASN0001E SQLCODE811
GG03950DPROPR FAILS ASN0001E SQLCODE811
GG03951APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH
GG03952APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH
GG03954SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT
GG03955AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT AUTOMATICALLY CUT IN HALF TO ENABLE SUCCESSFUL PROPAGATION.
GG03956AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT AUTOMATICALLY CUT IN HALF TO ENABLE SUCCESSFUL PROPAGATION.
GG03957SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION.
GG03958SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION.
GG03959GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION
IX77854SQL0901 DIAG FILE REPORTS ERROR IN BUFFER QUEUE SERVICES PROBE:30 SQLKQ_DETACH_BUFFER(). INTERNAL ERR 'LOST BUFFER'
IX88428USING ADSM CONFIGURATION PARAMETERS IN DB CFG CAUSE A NULL TO BE ASSIGNED AS THE BACKUP IMAGE OWNER.
IX88829SQL1218 THERE ARE NO PAGES CURRENTLY AVAILABLE IN BUFFERPOOL
IX89397DB2 UNIX TRAPS ON CONNECT FROM EMB SQL IF DB2INSTANCE NOT SET
IY01190ROLLBACK OF CREATE TABLESPACE WITH > 1 CONTAINER NEVER UNTAGS CONTAINERS PAST THE FIRST ONE
IY02447ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE
IY02448ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE
IY02449ADD COLUMN WITH NOT NULL WITH DEFAULT AND UPDATING TABLE CAUSES DR. WATSON WHEN RUN ASNCCP MOBILE
IY02556CC: JOURNAL REPORTS INCORRECT JOB STATUS
IY02569TRAP AT BEGINNING OF ONLINE BACKUP IN SQLUBCKA
IY02571SQL0433 DURING INSERT VALUES, LINEFEED CHANGED TO SPACE
IY02572LANG=JA_JP.IBM-932OR JA_JP.IBM-943SYMBOLIC LINKS NEEDED
IY02730CLI DRIVER DOESN'T HANDLE LARGE STATEMENT SIZES CORRECTLY.
IY02809DPROPR FAILS ASN0001E SQLCODE811
IY02979BPS ESTORE LOGIC ERROR CAUSES HANG
IY03189GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS
IY03190GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS
IY03191GETTING ASN1223E AND ASN1023S - MIXED CONFLICT_LEVELS (0,1) IN THE SAME SUBSCRIPTION SET FAILS
IY03192BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET
IY03193BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET
IY03194BUFFER OVERFLOW DUE TO LARGE NUMBER OF MEMBERS IN A SUBSCRIPTION SET
IY03195ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE.
IY03196ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE.
IY03197ROWS FETCHED FROM CCD TO PIT IS NOT ALWAYS ORDERED CORRECTLY DUE TO THE INCORRECT 'ORDER BY' CLAUSE.
IY03213DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT
IY03214DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT
IY03215DR WATSON - FOR CD TABLES THAT HAVE THE OPTIONAL LOGMARKER COLUMN , CAPTURE IS GENERATING A BAD NULL INDICATOR FOR IT
IY03217UNABLE TO GET GOCAPT FOR SOME TABLES
IY03218UNABLE TO GET GOCAPT FOR SOME TABLES
IY03219UNABLE TO GET GOCAPT FOR SOME TABLES
IY03287DPROPR FAILS ASN0001E SQLCODE811
IY03288DPROPR FAILS ASN0001E SQLCODE811
IY03318APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH
IY03319APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH
IY03320APPLY DID NOT USE MAX_SYNCH_MINUTES FOR FIRST DIFFERENTIAL UPDATE AFTER FULLREFRESH
IY03379DB2NODE ENVIRONMENT VARIABLE DOES NOT WORK FOR ALL CMDS IF PRTN NUM SPECIFIED IS NOT ON THE SAME PHYSICAL NODE.
IY03415THE SQL STATEMENT USED TO CALCULATE THE UPPER COPY LIMIT SPECIFIED AN INCORRECT SYNCHPOINT VALUE.
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.
IY03514SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION.
IY03529RUNNING DB2EMPFA WHEN SMS TABLES GREATER THAN 4G EXIST CAN CORRUPT DATA.
IY03536SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT
IY03538SQLCODE204 - ASNLOAD - APPLY DOES NOT ENCLOSE TABLE NAMES OF SMALL OR MIXED CASE IN QUOTES IN ITS SELECT STATEMENT
IY03539AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT AUTOMATICALLY CUT IN HALF TO ENABLE SUCCESSFUL PROPAGATION.
IY03540AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT AUTOMATICALLY CUT IN HALF TO ENABLE SUCCESSFUL PROPAGATION.
IY03542SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION.
IY03543SUBSCRIPTION WITH MAX_SYNCH_MINUTES LESS THAN SLEEP PERIOD AND MINIMAL ACTIVITY, STATUS SET TO 2 AND CONTINUOUS EXECUTION.
IY03608DB MARKED BAD AND BROUGHT DOWN WHEN LOAD INTO TABLE WITH RI.
IY03621GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION
IY03622GLOBAL RECORD SYNCHTIME DOES NOT MATCH POINT IN LOG, MOBILE REPLICATION WITH ENHANCED CONFLICT DETECTION
IY03630RECONCILE SQL2554 DOES NOT GIVE DLFM SERVER NAME.
IY03635TABLESPACE FULL BRINGS DOWN DATABASE
IY03805PROBLEMS WITH NIS AND GROUP LOOKUPS ON AIX 4.3.2 DEFECT #124182
IY03861APAR USED TO CREATE PTF FOR DB2 V5.0 FOR AIX
IY03941AFTER GETTING RC00C90096 THE MAX_SYNCH_MINUTES VALUE WAS NOT
IY04046JDBC TRAP IF APPLICATION USES INVALID CONNECTION HANDLE
IY04157SET CURRENT PACKAGESET PRODUCES A SIGSEGV FROM WITHIN SQLJ
IY04196LOG FULL CONDITION WITH NODE LOG SYNC WILL CAUSE DB2 TO PANIC AN D CRASH.
IY04221EXPLICIT CONNECT FAILS WITH SQL1403 ON AIX
IY04242LOG FULL CONDITION DID NOT SAVE ENOUGH LOGSPACE FOR A TRANSACTION TO BE ROLLED BACK.
JR12984MS ACCESS APPL ERROR FROM DB2 V2.1 VIA DB2 CONNECT V5.2 TO DB2/M VS
JR13539TRAP IN SQLBFREEONEPOOL DURING DB RESTORE WITH LOW DBHEAP
JR13567XA ENVIRONMENT, SETTING ISOLATION LEVEL RETURNS CLI0126E.
JR13610ERROR LOGGED FOR SQLOFMBLK WHEN USING PREPARED STATEMENTS
JR13624SQLRLCLO IN SQLRL_FETCH TRAPS WHEN APPLHEAPSZ IS LOW
JR13630SQLPLRL() TRAPS AS SQLRLGTS() NOT CLOSING CURSOR
JR13633TRAP IN MONITOR SNAPSHOT
JR13634CLI COMPOUND SQL WITH DEF PREP FAILS IF SQLPREPARE BEFORE OPEN
JR13667DB2JDBC.DLL TRAPS WHEN RUNNING WEBSPHERE IN VISUALAGE JAVA
APAR fixes included in WR21118b (Fixpak 10b)
APARABSTRACT
IX86459CLP CHANGES ADMIN INSTANCE'S SVCENAME FROM 523
IY00980BACKUP FAILS WITH SQL1062 BECAUSE OF LINKS IN THE DB PATH
IY01489LOG EXTENT 0 (S0000000.LOG) REQUESTED BY DB2 WHEN THE LOG SEQUENCE IS WELL PAST, IE. IN THE THOUSANDS.
IY02464-901 INDICATING BANDP NOT PUSHED DOWN
IY02618DB2 CONNECT GATEWAY TRAPS IN SQLJMF10.
IY03081APPLICATIONS CONNECTING TO DB2 SERVER OVER TCP/IP USING DRDA CAN NOT BE FORCED BY 'FORCE APPLICATIONS ALL'
IY03129DB2 INSTANCE COMES DOWN WITH A SIGNAL #36 DUE TO AN SQLE_PANIC CALL IN FUNCTION REMOVE_ME - EVENT MONITOR DEACTIVATION CODE.
IY03133SQL0901 'UNEXPECTED COLUMN USAGE TYPE' ON DELETE OPERATION ON TX ENABLED TABLE DUE TO TX TRIGGERS.
IY03164TRAP IN SQLT_DISPLAY_CA
IY03175EXCESSIVE MESSAGES IN DB2DIAG.LOG
IY03229FENCED DB2DARI PROCESS LEAKS 4K OF MEMORY PER INVOCATION
IY03393UNINITIALIZED MEMORY IN OPTIMIZER CAUSES SIGNAL #11 IN (SQLNO_CO PY_SETN,SQLNO_UNION_SETN)
JR12926JAVA GETSCHEMA RETURNS NULL WHEN USING OPTIMIZED CATALOG
JR13103DB2 UDB V5 FIX FOR WEBSPHERE 3.0
JR13123WHEN USING BLOB LOCATORS, SQLGETPOSITION FAILS WITH CLI0102E INVALID CONVERSION SQLSTATE=07006.
JR13499RECOGNIZE '\' ESCAPE CHARACTER IN SCHEMA QUALIFIERS
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
JR13547CLI0606 WHEN RETRIEVING DECIMAL DATA WITH GETDOUBLE CALL FROM NT FOR SPANISH
JR13548INTERVAL OPTION IN THE GOVERNOR CONFIGURATION FILE DOES NOT ACCEPT VALUES OVER 300 SECONDS. GOV1027N IS RETURNED.
APAR fixes included in WR21118a (Fixpak 10a)
APARABSTRACT
IX88671TRAP IN SQLE_DB2RA_AS_DB_OPEN WHEN ATTEMPTING TO OPEN A CURSOR ON THE SPM DATABASE (AN UNSUPPORTED ACTION)
IX88927DB2ADUTL EXTRACT -> CANNOT EXTRACT IMAGES > 2G
IX89959CACHE STORED PROCEDURE DESCRIBE INFORMATION
IY00843IMPROVE THE HANDSHAKE BETWEEN SQE AND MONITOR CODE THAT CAN CAUSE A HANG
IY01172DB2ADUTL QUERY DB FULL IN MPP ENVIRONMENT DOES NOT RETURN CONSISTENT RESULTS WHEN BACKUP TIMESTAMPS IDENTICAL.
IY01211DEFENSIVE LOGIC TO DETECT 'PREVIOUS LOG EXTENT ID' BEING SET INCORRECTLY.
IY01644CURSORS/LOCKS BEING CLOSED IN XA TRANSACTIONS WHICH HAVE ALREADY BEEN CLOSED.
IY01782DB2ADUTL CORE DUMPS WHEN -1 PASSED FOR N ON THE COMMAND LINE.
IY02049DB2LOOK CHANGES AUTHORIZATION GROUP TO USER.
IY02408DB2 UDB - HANG ON INDEX REBUILD ATTEMPT. IN THIS CASE, INDEXREC WAS SET TO RESTART - SO THE CONNECT ATTEMPT WAS HANGING.
IY02470-4301 WHEN TRYING TO RUN SP THAT RETURNS CLOB
IY02647CLI TRIES TO GROW THE CONNECTION LIST (WHICH CANNOT BE DONE, THE LIMIT IS STATIC).
IY02659INTERMITTENT SQL0444 RC=4 REFERENCING UDF'S
IY02764ERROR MESSAGE FORMATTING IN ' SET TABLESPACE CONTAINERS ' MAY OVERWRITE THE STACK RESULTING IN SIGILL , SQL1224 INSTANCE CRASH
IY02862OUT OF SPACE IN THE DLFM_BACKUP_DIR_NAME NOT DETECTED
IY02936UNCONDITIONAL LOGGING ERROR ABOVE DIAGLEVEL > 1 BY OSS_2 SQLOOPENNODELIST
IY02962DEFUNCT CHILD PROCESSES ON SOLARIS WITH JDBC NET DRIVER
IY03017DB2GOV ALWAYS USE NODENUMBER 0 WHEN LANG IS JA_JP
IY03069LIST DCS APPLICATIONS LIST DUPLICATE THREADS
IY03138DB2BATCH -Q DEL INSERTS BLANK LINES AFTER EVERY ROW IN THE OUTPUT.
JR12656ODBC SQLTABLEPRIVILEGES DOES NOT RETURN THE PUBLIC PRIVILAGES
JR12757SQL2025 SHOULD BE RETURNED INSTEAD OF SQL2032, RC=14 WHEN RESTORING FROM ADSM AND TAPE IN ADSM SERVER IS OFFLINE.
JR12938COMMAND CENTER/NT TRAP AFTER ISSUED 'CONNECT TO <DB' WITH INCORRECT ID AND PASSWORD # OF TIMES IN A ROWS.
JR13123WHEN USING BLOB LOCATORS, SQLGETPOSITION FAILS WITH CLI0102E INVALID CONVERSION SQLSTATE=07006.
JR13311TRAP IN 'SQLMON_DCS_STMT' ON DB2 CONNECT EE 5.2 WHEN MONITOR HEAP EXHAUSTS.
JR13334TIMESTAMPDIFF ODBC FUNCTION DOES NOT GET NEGATIVE VALUES RETURNED WHEN CALLED IN DB2 CLI/ODBC.
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
JR13481SQL_CURSOR_STATIC CURSORS NOT BEING CLOSED AFTER SQLCANCEL()/SQLFREESTMT(SQL_DROP)
JR13497SQLWARN FLAGS ARE NOT BEING RESET AFTER EXECUTE
JR1350832K MEMORY NOT FREED PROPERLY WHEN APPLICATION DISCONNECTS IN DRDA
JR13537FIX APAR JR12990 (CLOSED IN ERROR): SYMBOLS SQLTENTR_CEI__FIT1 AND SQLTRET_CEI__FIN21 MISSING FOR MFCOBOL ON OS2
JR13540ADD SUPPORT FOR SQLDESCRIBEPARAM TO DB2 FOR MVS 5.1.2
APAR fixes included in WR21118 (Fixpak 10)
APARABSTRACT
IX83662SIGNAL#11 IN SQLKD_RCV_DATA
IY00843IMPROVE THE HANDSHAKE BETWEEN SQE AND MONITOR CODE THAT CAN CAUSE A HANG
IY01167-901 FROM SQLNO_CRULE_SAVE_PLANS
IY01277DB2 UDB ON SUN - OFFLINE BACKUP TRAPS. TRAP FILE REPORTS TRAP IN FUNCTION SQLUHCONVSTRUCTTOLINE.
IY01381TRANSACTION TABLE FULL AND OVERFLOW WITH TUXEDO
IY01547FFFF8133 MESSAGES IN DB2DIAG.LOG DURING CRASH RECOVERY WHEN ACCESSING A TABLESPACE IN ROLLFORWARD PENDING - PERFORMANCE
IY01548TABLESPACE THROWN INTO LOAD PENDING, ROLLFORWARD PENDING WHEN CRASH RECOVERY ABENDS WHEN AFTER FAILED LOAD.
IY01841RELEASE SHARE LOCKS ACQUIRED ON SYSTABLES DURING COMPLIATION OF SQL STATEMENTS
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()
IY02162MIN BUFF LSN SET TOO HIGH. THIS CAUSES RESTART TO FAIL IF SOME ESSENTIAL LOG RECORDS DO NOT GET REPLAYED.
IY02257DB2 UDB - PERFORMANCE DEGRADATION AFTER UPGRADING FROM FIXPAK 5 TO FIXPAK 8. OPTIMIZER COSTING DEFECT WAS THE CAUSE.
IY02285RANDOM VALUES COPIED INTO THE LSN SINCE VARIABLE NOT INITIALIZED
IY02708DEAD LATCH DURING CREATE TABLE WITH PRIMARY KEY
JR12713FFFFF616 IGNORED CAUSING DATABASE CORRUPTION
JR13103DB2 UDB V5 FIX FOR WEBSPHERE 3.0
JR13112INSERT UDF CAN CRASH DB2
JR13152IBM DB2 ODBC DRIVER DOES NOT DISPLAY VERSION NUMBER IN THE ODBC DATASOURCE ADMINISTRATOR UTILITY.
JR13290THREAD HANGS ON NT WHEN ASYNC SUPPORT IS ENABLED
JR13333EXECUTING A STORED PROCEDURE AGAINST A LOCKED TABLE CAUSES THE GATEWAY TO TRAP.
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.
JR13415SMCODE -20 WHEN MONITORING ALIASED DATABASE
JR13428MEMORY LEAK WITH UDF'S IF RETURNING BLOBS OF VARYING SIZE
JR13488SQLCOLATTRIBUTES DOESN'T RETURN NULL STRING WITH SQL_DESC_BASE_T ABLE_NAME
APAR fixes included in WR21112a (Fixpak 9a)
APARABSTRACT
IX89396SIGNAL#11 IN SQLRR_OPEN
IY00882EVENT MONITORS WRITING TO PIPES NOT GETTING CLEANED UP ON DB2STOP FORCE - SQL1614 RC 6 TRYING TO RESTART EVENT MONITORS
IY01210DB2GOV MISSING DB2GOVD VALIDATE IF STARTING ON ONE NODE
IY01295TUXEDO TX_ROLLBACK() FOLLOWED BY TX_BEGIN() RESULTS IN TPEPROTO ERROR.
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.
IY01885MEMORY LEAK WHEN USING ARRAYINPUT
IY02027IF MVS COLUMN IS DEFINED AS REAL, SELECT ON IT CAN FAIL WITH SQL0304. OUR MAX OF REAL IS SMALLER THEN MVS MAX OF REAL.
IY02029TRAP INSIDE OF SQLEJNMSTP_SETBIGDECIMAL WHEN USING A BIGDECIMAL AS A PARAMETER OF A STORED PROCEDURE.
IY02092CHANGE USER FROM CONTROL CENTER TRAPS IN DB2CC.EXE
IY02147START OF DB2JD CAUSES SEGMENTATION FAULT.
JR13156PARAMETER MARKERS IN JDBC APPLICATION ARE BEING BOUND WITH THE WRONG SIZE CAUSING CLI0109E STRING DATA TRUNCTION ERRORS.
JR13324CALLING STORED PROCEDURES ON AS/400 WITH MORE THAN 9 PARAMETERS CAUSES EXTRANEOUS DATA TO BE SENT IN THE CALL
JR13344IF EXECUTE FAILS, CLI REUSES THE DESCRIBE INFO FROM A PREVIOUS STATEMENT.
JR13354SQL 1404 FROM MVS IS IGNORED BY CLI (ODBC) APPLICATIONS DEFECT # 120629
JR13355THREE WAY JOIN OF REPLICATION TABLES FROM CONTROL CENTER CREATES INCORRECT SQL.
JR13363CCA CANNOT TRUNCATE COMMENT FIELD ON ADD DATABASE.
APAR fixes included in WR21112 (Fixpak 9)
APARABSTRACT
GG03863RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES
GG03864RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES
GG03865PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES
GG03866PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES
GG03867APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT
GG03868APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT
GG03869CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS
GG03870CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS
GG03871WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY
GG03872WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY
GG03874MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION
GG03875MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION
GG03876INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH
GG03877INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH
GG03878WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS
GG03879WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS
GG03880ASNMIG DOESNT SET/MIGRATE COLUMN SYNCHTIME IN IBMSNAP_SUBS_SET
GG03881ASNMIG DOESNT SET/MIGRATE COLUMN SYNCHTIME IN IBMSNAP_SUBS_SET
GG03883VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION
GG03885CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE
GG03887WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS
GG03888WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS
GG03889CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED
GG03891APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER
GG03892APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER
GG03893STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS.
GG03894STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS.
GG03895ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION
GG03896ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION
GG03898FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269
GG03899FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269
GG03903CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE
GG03904CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED
GG03905THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME.
GG03906THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME.
GG03907PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER
GG03908APPLY ONLY PROCESSES LAST EVENT POSTED
GG03909APPLY ONLY PROCESSES LAST EVENT POSTED
GG03910PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER
GG03911APPLY ONLY PROCESSES LAST EVENT POSTED
GG03912APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY
GG03917APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS
GG03918APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS
GG03919MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431
GG03920MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431
GG03921VERSION 1 PRUNING CONTROL TABLES LOST DURING MIGRATION
IX87116ADD THE OPTION TO SPECIFY THE COLUMN DELIMITER AND CHANGE THE
IX87233DB2_ALL DOES NOT WORK FROM USERIDS OTHER THAN INSTANCE OWNER AFT ER APPLYING UDB EEE 5.2
IX88078WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS
IX88123RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES
IX88124RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES
IX88125RC00C90088 SQLCODE913 MVS 3.1 DOES NOT SUPPORT ISOLATION UR SO CAPTURE & APPLY MUST USE DPR V1 TECHNIQUES TO PROTECT RESOURCES
IX88130PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES
IX88131PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES
IX88132PREDICATES FIELD GETS INCORRECT VALUES, APPEAR TO BE OVERLAID WITH VALUES FROM PREVIOUS PREDICATES
IX88138APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT
IX88139APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT
IX88140APPLY DOES NOT FREE THE SPILL FILE ( DASD , MEMORY ) AFTER IT IS DONE USING IT
IX88141CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS
IX88142CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS
IX88143CEE0802C HEAP STORAGE CONTROL INFO DAMAGED - AUX_STMTS IN SUBS_SET DOES NOT MATCH NUMBER OF STATEMENTS IN SUBS_STMTS
IX88144WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY
IX88145WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY
IX88146WHEN BOTH EVENT-BASED AND TIME-BASED PARAMETERS ARE SET FOR THE SAME SUBSCRIPTION , APPLY RUNS CONTINUOUSLY
IX88394TRAP IN CONTROL CENTER - JOURNAL AFTER ALTERING A TABLESPACE SUCH THAT IT IS ASSOCIATED WITH A NEW BUFFERPOOL.
IX88536DBADM SHOULD BE PERMITTED TO ADD USER FROM CONTROL CENTER. SYSADM IS CURRENTLY REQUIRED IN ORDER TO RETREIVE USERS FROM OS.
IX88992MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION
IX88993MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION
IX88994MULTIPLE MVS APPLY PROCESSES HAVE CONTENTION PROBLEMS. ERROR RECORD (-1 STATUS) PLACED IN APPLYTRAIL TABLE AND NO REPLICATION
IX88995INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH
IX88996INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH
IX88997INCORROUT FUNCTION CCD TARGET TABLE FULL REFRESH
IX89054WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS
IX89055WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS
IX89665APPLY FAILS WITH SEGMENTATION FAULT IN ASNLOAD WHEN IT IS STARTED WITH LOADX AND TRCFLOW INVOCATION PARAMETERS
IX89691TRAP IN SQL_DB2RA_AS_DB_OPEN.
IX89839DB2 IS RETURNING A '27' INSTEAD OF THE '<HEAP_NAME>' FOR SQL0973
IX89997UNTYPED PARAMETER MARKERS CAST INCORRECTLY WHEN IN CLAUSE USED
IY00045WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE SQLCODE911 DATA LOSS
IY00100WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS
IY00101WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE 911 DATA LOSS
IY00229TQ HANG
IY00230IF SQLFREESTMT FAILS WITH -30081,DON'T RETURN SQL_ERROR ON FREE
IY00412DB2JD LISTENER CANNOT BE STARTED IF YOU HAVE DISABLEMULTITHREAD=1 IN YOUR DB2CLI.INI.
IY00473APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY
IY00603APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER
IY00604APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER
IY00605APPLY PERFORMANCE SUFFERED FROM A TABLE SPACE SCAN WHEN ISSUING QUERY AGAINST ASN.IBMSNAP_UOW FOR COMMITSEQ AND LOGMARKER
IY00610STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS.
IY00611STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS.
IY00612STARTING DPROP/R APPLY CODING ALL STARTPARAMETERS AND RECEIVE MSGASN1042W THERE ARE TOO MANY INVOCATION PARAMETERS.
IY00782EINVAL IN SQLOCSHR IN DB2CART , SQLO_NO_SEG IN SQLGMRP FFFF D605 ALSO CRASH RECOVERY ENDING TO EARLY
IY00795ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION
IY00796ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION
IY00797ADD NEW INVOCATION PARAMETER ERRWAIT9N) WHERE N IS THE NUMBER OF SECONDS TO WAIT BEFORE RETRY AFTER ERROR CONDITION
IY00798FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269
IY00799FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269
IY00800FIX ASSOCIATED WITH BLOCK INSERT FUNCTION FOR DATAJOINER TWIZZLE IC23269
IY00838USING 'CONNECT TO <DB> USER <USER> CHANGE PASSWORD' FAILS WITH SQL1403N, BUT ACTUALLY CHANGES THE PW OK... USING NIS.
IY00858TRAP IN MEMTREEPUT FROM SQLMON_CONN::STMT_START
IY00867TRAP IN SQLRA_CSM_DROP_SECT
IY00961CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE
IY00962CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED
IY00964CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE
IY00965CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED
IY00971SNAPSHOT DOESN'T SHOW ALL LOCKS BEING HELD
IY00975CAPTURE MOBILE IS NOT CAPTURING FIRST UPDATE AND ONLY OCCURS WHEN THE MOBILE OPTION IS SPECIFIED ON CAPTURE
IY00976RESTORE FAILS WITH SQL0973 - NOT ENOUGH SPACE IN LOCK LIST HEAP.
IY00977CAPTURE WITH MOBILE AND NOPRUNE OPTION INCORRECTLY ISSUES PRUNE WHEN EXITED
IY00986THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME.
IY00987THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME.
IY00988THE SYNCHTIME IN THE APPLY TRAIL TABLE WAS GOING BACKWARD IN TIME.
IY00989PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER
IY00990APPLY ONLY PROCESSES LAST EVENT POSTED
IY00991PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER
IY00992APPLY ONLY PROCESSES LAST EVENT POSTED
IY00995APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY
IY00996PROBLEMS WHEN USING MAX_SYNCH_MINUTES PARAMETER
IY00997APPLY ONLY PROCESSES LAST EVENT POSTED
IY00998APPLY MUST SUPPORT A PREDEFINED CORRELATION NAME FOR THE PHYSICAL SOURCE TABLE USED IN A CORRELATED SUBQUERY
IY01020OPTIMIZER DOES NOT ADJUST FOR CORRELATION IN QUERIES INVOLVING L OT OF TABLES AND PREDICATES.
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()
IY01371THE CLIENT APPEARS TO HANG. IT ACTUALITY KEEPS CALLING SQLE_DB2RA_GETDATA().
IY01375APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS
IY01376APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS
IY01377APPLY ALWAYS FULL REFRESHES SUBCRIPTIONS FROM CCD VIEWS
IY01378MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431
IY01379MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431
IY01380MSGASN1001E SQLCODE180 AFTER APPLYING PTF UQ30431
IY01386TRANSACTION NOT FOUND MESSAGES IN DB2DIAG.LOG
IY01392INDEX LOG SPACE RESERVATION
IY01429DB2 UDB 5.X MAY GIVE SQL0901 IF INTRA_PARALLEL ON
IY01710DB2LOGGER FILLS UP THE FILE SYSTEM AND BADLSN REPORTED IN THE DIAG FILE
IY01726-952 WHEN RUNNING STORED PROCEDURE TO EEE
IY01762JNI PANIC: JNI RECEIVED A NULL ARRAY (WHEN USING APP DRIVER)
IY01883DB MARKED BAD ERROR IN SQLBCHECKSMP4OBJDEL
IY02026WRONG COLUMN SPECIFICATION IN LOAD COMMAND LEADS TO CONNECITON T ERMINATION, SQL1224N,GIVES WRONG ERROR MESSAGE.
JR12556CREATE DATABASE FROM BACKUP IN CC RETURNS SUCCESS WHEN ONLINE BACKUP IMAGE IS USED WITH 'ROLLFORWARD PENDING' UNCHECKED.
JR12774ADVANCED ODBC SETTINGS ARE TRUNCATING THE PATCH1 VALUE 100973 -- DEFECT NUMBER
JR12918TABLETYPE KEYWORD NOT EXCLUDING SYNONYM TABLE TYPES
JR12964STATEMENT VIEW OF EVENT MONITOR IN CONTROL CENTER CREATES MULTIPLE CONNECTIONS.
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
JR13009SQL1109N 'DLL NOT FOUND' WHEN CALLING A JSP WITH POWERBUILDER DEFECT#: 108302
JR13091SQL30020 RC=124C PLUS DUMP FILES WHEN SELECTING FROM HOST DATABASE IN ASYNC MODE.
JR13153DB2 CONNECT GATEWAY TRAPS WHEN LARGE ARRAYS PASSED AS INPUT PARAMETERS.
JR13157MORERESULT FLOWING EXTRA FLOWS TO THE HOST ONLY.
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
JR13202SQL0502N AND SQL0514N ERRORS AS A RESULT OF TIMING HOLE, WHERE IT LOOKS LIKE 2 STATEMENTS ARE USING THE SAME CURSOR.
JR13217SQLGETINFO(SQL_ORDER_BY_COLUMNS_IN_SELECT) REPORTS 'N' INSTEAD OF 'Y' FOR DB2/390 V5.1
JR13218PARENTHESES AROUND ON CLAUSE FOR JOINS CAUSE SYNTAX ERROR FOR DB2/390.
JR13223CALLING STORED PROCEDURE AGAINST DRDA HOST RETURNS SQL -1224, -902 OR NO RESULTS WHEN THERE SHOULD BE. DEFECT 116964
JR13269USEREXIT ARCHIVES MAX 63 LOG FILES AFTER ERROR IS CORRECTED.
JR13270JAVA NET DRIVER MEMORY LEAK WHEN SELECTING BLOBS
JR13278REGISTRY INFORMATION INCORRECT FOR DB2CLI.DLL AND DB2ODBC.DLL
JR13295THE DB2PEM32.DLL IS NOT THREAD SAFE. SO WHEN TWO THREADS ATTEMPT TO CHANGE THE PASSWORD AT THE SAME TIME DB2PEM32.DLL TRAPS.
JR13315DRDA STREAM TERMINATING WITH CM_PROGRAM_ERROR_PURGING WHEN PASSING SQLDA TO HOST.
JR13332CHANGE PASSWORD FOR 8 CHAR USERIDS RETURNS INVALID USERID.
PQ27660CHECK IN REPLICATION APPLY FOR V5 FIXPAK 9
APAR fixes included in WR09093i (Fixpak 8i)
APARABSTRACT
IY00045WHEN ISOLATION CS USED FOR APPLY CAUSES CAPTURE SQLCODE911 DATA LOSS
IY00268LOAD TRAPS DURING THE BEGINING OF THE BUILD PHASE ON 4 WAY SMP BOX WITH LOAD PARALLESIM SET TO 4
IY00403ALLOW SOLARIS NON-THREADED LOADABLE OBJECTS FOR DB2_NOTH.SO
IY00674DB2ATLD HANGS IF PLACED IN BACKGROUND WITH & AND AUTHENTICATION = NO
IY00676SQL1403 ON CONNECT TO DB WITH USER USERID USING PASSWD.
IY00718HASH JOIN PLAN MAY HANG IN RARE CIRCUMSTATNCES
IY00761TRAP IN SQLDDELTCB (SQLDFREETCB) ON NORMAL DATABASE DEACTIVATION PROCESS IS DB2PFCHR (PREFETCHER)
IY00793MAPPING -965 FROM OS/390 TO -430 ON DB2 UDB
JR12749POINT IN TIME ROLL FORWARD RECOVERY FROM CC DOES NOT WORK
JR12751CONTROL CENTER CRASHES DUE TO JOURNAL HISTORY FILE PROBLEMS.
JR13169#DELETED GETS DISPLAYED IN MS ACCESS WHEN DISPLAYING A DB2 TABLE THAT HAS A PRIMARY KEY ON A DATE COLUMN OR DECIMAL COLUMN
JR13242BACKUP FAILS WITH SQL1042C USING MSCS DUE TO MIXED CASE DRIVE MAPPING.
JR13256BIDI LAYOUT TRANSFORMATION CODE RETURNED AN ERROR, WHEN THE INPUT AND OUTPUT BUFFER LENGTHS WERE ZERO.
APAR fixes included in WR09093h (Fixpak 8h)
APARABSTRACT
IX87116DB2BATCH DEFECTS (REMOVE EXTRA SPACES EXTRA BLANK LINES, APPEN
IX88493DB2_CORRELATED_PREDICATES=YES MAY CAUSE OVERESTIMATES OF CARDINA LITY (AND UNDERESTIMATES OF FILTER FACTORS)
IX88675DB2BATCH WITH -Q OFF OPTION DOES NOT FORMAT OUTPUT PROPERLY FOR NULLED FIELD.
IX88793-902 ON DROP TABLESPACE WHILE LOAD RUNNING
IX88801PARALLELISM NOT WORKING WITH ODBC APPS TO MVS 5.1.1
IX89062SQL0901 WHEN HASH_JOIN PLAN IS CHOSEN
IX89405SIGNAL#11 IN SQLOLGSEMPOST
IX89467CURRENTSQLID IS NOT PICKED UP BY CLI APPLICATIONS AND THE LOGON ID IS USED INSTEAD.
IX89535SQL0433N ON QUERY WHEN CAST FUNCTION RETURNS WRONG SQLLEN
IX89871-901 SQLNO_ITR_PLAN::NEXT AT LOCATION 300 - PLAN NOT FOUND
IY00403ALLOW SOLARIS NON-THREADED LOADABLE OBJECTS FOR DB2_NOTH.SO
IY00444HASH JOIN USES UP ALL THE MEMORY AND CAUSES EDU CRASH.
IY00480ENSURE DB2AUDIT RETURNS 0 RC INSTEAD OF 6 WHEN SUCCESSFUL
JR11822LOAD OF DEL ON NT CAUSES DB2 TO TRAP, AND DB2 TO BE INCONSISTENT FUNCTION NEEDED FOR USE OF ZIP/JAZ DRIVES
JR12812BIND MESSAGES TRUNCATED IN CCA
JR13171LOAD RETURNS SQL3114W IF DATA IN DEL FILE HAS TRAILING BLANKS
JR13184DURING CONFIG. OF CLIENT USING CCA AND IMPORT PROFILE ALWAYS TAK E APPC CONNECT SYMBOLIC DESTINATION TO SYSDST0 & SESSION IBMRDB
JR13187IMPROPER CHECK ON LENGTH FIELD CAUSING A MEMORY OVERWRITE WHICH RESULTS IN A TRAP IN SQLEUPDATELIST
JR13204MEMORY LEAK CONNECTING TO LOCAL DATABASE AND DB2START NOT ISSUED
APAR fixes included in WR09093g (Fixpak 8g)
APARABSTRACT
IX87450FILE MANAGER EXPORT CONTROL FILE NOT BEING CREATED WHEN SPECIFIC COLUMNS SPECIFIED IN THE SELECT FROM THE EXPORT.
IX87741INCORRECT ROUND FUNCTION OUTPUT.
IX87911DB2 UDB ERROR 28 IS INCORRECTLY RETURNED BY THE SAMPLE USEREXIT WHEN LOG FILE WE ARE TRYING TO ARCHIVE DOES NOT EXIST.
IX88096WE ARE NOT RETURNING 0 ON A GETINT OR GETLONG IN A JAVA APP WHEN THE VALUE IS NULL.
IX88660SQL0302N WHEN INVOKING A STORED PROCEDURE ON AS/400 FROM A JAVA PROGRAM.
IX89850USING PKGRM "DB2 PACKAGES" COMMAND ,DELETES SUN PATCHES ALSO.
IY00157DB2LOOK HAS TROUBLE DISTINGUISHING BETWEEN SERIAL AND PARALLEL MODE
IY00239JDBC APPLICATION FAILS WITH CLI0601E 'INVALID HANDLE' IF A SELECT STATEMENT QUERIES MORE THAN 100 COLUMNS
IY00270SELECT WITH LIKE CLAUSE HAVING DATA WITH LEADING &TRAILING BLANKS PRODUCES ERRATIC RESULTS.
IY00360ADD OBJECT REXX SUPPORT IN UDB EEE V5.2 FOR AIX.
JR13150QUERY WITH LIKE CLAUSE TRAPS GENERATING THE ACCESS PLAN (FILTER FACTOR MORE SPECIFICALLY, IN SQLNO_FF_COMPUTE_LIKEPRD)
JR13156PARAMETER MARKERS IN JDBC APPLICATION ARE BEING BOUND WITH THE WRONG SIZE CAUSING CLI0109E STRING DATA TRUNCTION ERRORS.
APAR fixes included in WR09093f (Fixpak 8f)
APARABSTRACT
IX88660SQL0302N WHEN INVOKING A STORED PROCEDURE ON AS/400 FROM A JAVA PROGRAM.
IX89209ABILITY TO FIX TERRITORY FIELD FOR DATABASES MIGRATED FROM V2 TO V5 WHERE THE TERRITORY IN THE DB CFG FIELD IS NOT READABLE.
IX89426CALLING STORED PROCEDURE CAUSES GATEWAY TO CRASH
IX89506SPURIOUS PACKAGE CACHE OVERLOW MESSAGES IN DB2DIAG.LOG CAUSED BY TIMING HOLE IN NEW PACKAGE CACHE MANAGEMENT
IX89840REALLOCATION OF OLD LOG DURING DB TERMINATION CAUSES DB TO SHUTD OWN
IX89896SCHEDULED BACKUP FROM CONTROL CENTER WITH MULTIPLE DIRECTORIES INCORRECTLY PLACES .002 ETC. FILES UNDER %SYSTEMROOT%\SYSTEM32
IX89960DON'T SEND EXTRA FETCH TO SERVER IF SQLCODE IS +100
IX89962DB21016 ON 'DB2 GET INSTANCE' - SAME COMMAND HANGS WHEN TRACING.
IY00034PROGRAM FLOW ERROR IN MGJN CAUSES PERFORMANCE DEGRADATION.
JR12990SQLTENTR_CEI_FIT1 SYMBOL NOT FOUND ON OS/2 FOR MF COBOL APP
JR13114DB2DEFPREP=YES NOT DISABLED FOR PREPARE WITH INTO CLAUSE
JR13141CATALOGGING RETURNING A SQL1092 ERROR WHEN MEMBER OF ADMINISTRATOR GROUP AND A DOMAIN USER
APAR fixes included in WR09093e (Fixpak 8e)
APARABSTRACT
IX71710RECLAIMED TOO MUCH LOG SPACE APPEARS DURING CRASH RECOVERY
IX88078WHEN CAPTURE ENCOUNTERS A TABLE WITH DATACAPTURE=L BUT NO LONG VARCHAR COLUMNS SUSPENDS PROCESSING LONG VARCHAR FOR OTHER TABLS
IX88660SQL0302N WHEN INVOKING A STORED PROCEDURE ON AS/400 FROM A JAVA PROGRAM.
IX88868DB2ATLD MAY WAIT ON X ROW LOCK ON SYSCOLUMNS.
IX89305DB2 REPORTS SQL1042C WITH ROLLFORWARD WHICH IS CAUSED BY AN INTERRUPT.
IX89506SPURIOUS PACKAGE CACHE OVERLOW MESSAGES IN DB2DIAG.LOG CAUSED BY TIMING HOLE IN NEW PACKAGE CACHE MANAGEMENT
IX89661SQL2038 RC=-1062 ON RESTORE OF DATABASE CREATED ON ROOT FILE SYSTEM I.E. ON '/'.
IX89927CONTAINER REMOVED WHEN ROLLING FORWARD THROUGH A FAILED ADD CONTAINER FOLLOWED BY A SUCCESSFUL ADD CONTAINER
JR13043DB2 BACKUP DATABASE COMMAND ON NT FAILS WITH SQL2025 RC 1450 ERROR_NO_SYSTEM_RESOURCES
JR13076MEMORY LEAK IN JVM WITH JAVA UDF
APAR fixes included in WR09093d (Fixpak 8d)
APARABSTRACT
IX85148-902 SQLCODE ON ROLLFORWARD OF TABLESPACE TO POINT IN TIME
IX86967DB2 USING TOO MUCH SWAP SPACE ON SOLARIS.
IX87910LOCKING BEHAVIOUR AT CS TO BE CHANGED FOR BOUNDARY CONDITIONS.
IX87941SECOND CALL TO JAVA STP FAILS WITH 'NOT ENOUGH MEM' (UNFENCED)
IX88739DB2ATLD DOES NOT LOAD DATA WHERE THE DATE COLUMN IS IN THE PARTITION KEY.
IX89216SIGSEGV WHEN GREATER THAN 100 CONNECTIONS USING JDBC
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
JR12815EXPORT DEL USES COMMA INSTEAD OF PERIOD AS DEFAULT
JR12946SELECT FAILS SQL1224N RECORD LENGTH > SQL_MAXRECL.A70F 0000
JR13006DB2ENG.DLL TRAPS BY BACKUP USING USEREXIT ON OS/2 SMP MACHINE AND/OR INTRA_PARALLEL YES - TRAP IN SQLEBUILDBDSUNIQUEID
JR13056TRAP IN SQLNO_COST_NLJN - THIS APAR IS TO PROVIDE MORE INFORMATION IN DB2DIAG.LOG (-901) IF TRAP OCCURS AGAIN.
JR13089DB2 IMPLEMENTATION OF OS MESSAGE QUEUES
APAR fixes included in WR09093c (Fixpak 8c)
APARABSTRACT
IX87063SQL1072 ON DB2START - FTOK CAN'T GENERATE UNIQUE IPC KEYS ON SOLARIS UFS WITH NEW DIRECTORIES WHEN RANGE OF INODES IS HIGH
IX87722TRAP IN SQLEX_DDCSGW_DEL_USER_CONTEXT
IX88179THE TYPE CASTING OF VARCHARS TO DECIMAL IN THE CREATE STATEMENT FOR UDF RESULTS IN THE LOSS OF PRECISION
IX88441LOAD ISSUES WITH NONRECOVERABLE OPTION
IX88761QUEISCE EXCLUSIVE RESET IS NOT WAD. AFTER A USER IS FORCED OFF THE SYSTEM THE PHANTOM QUIESCE IS NOT ACQUIRE BY NEXT USERID.
IX88966SQLDESCRIBEPARAM TRAPS IF SQLPREPARE HAS A WARNING
IX88969DB2JD LEAVES <DEFUNCT> CHILD PROCESSES WHEN APPLETS COMPLETE.
IX88981-902 ON DB2 ADD NODE
IX89057ISCAN FETCH WHEN IT SHOULD HAVE BEEN AN INDEX ONLY ACCESS
IX89238SIG#11 IN SQLNR_OPTPRE/ENV_PRD_REPLICATE WHEN QUERY EXECUTED
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
IX89341DB2ADMIN STOP FAILS WITH SQL1092N
JR12885USING ADO IN VB TO RETRIEVE PACKED TYPE FROM A MVS RECEIVES 'INVALID PRECISION' ERROR. DEFECT #103555
JR12906DB2SNMPD NOT ISSUING AN SNMP TRAP FOR ALL DB2 ERRORS OF TYPE SEVERE
JR12941SQLOREADFILEINTERRUPT TRACEPOINTS APPEARING IN NT/DB2DIAG LOGS I NCORRECTLY
JR12948APPLETSECURITYEXCEPTION WITH APP DRIVER DUE TO SYSTEM PROPERTIES
JR12962QUERY TRAPS: SQLNO_COST_MGJN
JR12982NEWLOGPATH UPDATE IN DB CFG LOS NT ERROR EVENT, WORKS FINE
JR12989CALL TO SQLESTAT FAILS WITH SQL1428 WHEN ATTEMPTING TO COLLECT DB INFORMATION FROM BOTH LOCAL AND REMOTE DBS IN ONE PROCESS
JR12998LIST DCS APPLICATIONS DISPLAYS THE GUID INSTEAD OF THE APPLICATION NAMES AFTER APPLYING WR09084.
JR13027OPTIMIZER PLAN INCORRECT WHEN HANDLING NULLS IN INDEXES.
JR13040DB2UEXT2.C FOR NT REFERS TO DB2UEXT INSTEAD OF DB2UEXT2 IN THE COMMENTS
APAR fixes included in WR09093a (Fixpak 8a)
APARABSTRACT
IX86007SIGNAL#11 IN SQLULADDINXKEYS
IX86970NOT ENOUGH LOG SPACE RESERVED IN REORG
IX87877SIG#11 IN GET_DBMON_BP ON RESTART
IX87910LOCKING BEHAVIOUR AT CS TO BE CHANGED FOR BOUNDARY CONDITIONS.
IX88041SQLJ BINDING STRING HOST VARIABLES TO AN OS/390 DB YIELDS SQL0134.
IX88274HANG ON CRASH RECOVERY DUE TO LOCK-WAIT ON SYSTABLESPACES
IX88408POSSIBLE DATA INCONSISTENCY
IX88449POSSIBLE -902 WHEN USING SCROLLABLE CURSOR
IX88454DB2/EEE 5.2 FP#7: DB2ATLD MAY HANG WITH 'LOAD ERROR: UNABLE TO QUEISCE POOLS FOR TABLE.' IN DB2DIAG.LOG
IX88563SELECT FROM VIEW RETURNS INCORRECT ROWS IN V5, FOR V1 DATA
IX88738DB2BATCH IN MPP MODE UNEEDED HEADERS/FOOTERS
IX88741DB2BATCH IN MPP MODE DOESN'T USE NOT LOGGED INITIALLY TABLES FOR ITS TEMP TABLES
IX88816SQL2542N RESTORING PE DB WITH TAKEN AT OPTION
IX88834SEGV IN SQLNR_CORRELATED_TOQUN
IX88873DB2ATLD MAY HANG AT INITILIZATION PHASE
IX88917INCORRECT OUTPUT FOR GET SNAPHOT FOR DCS APPLICATIONS
IX88942DB2ATLD LOCK-WAIT ON SYSPARTIONMAPS
IX88968SQL1224 WITH 'SEGMENTED TABLE PAGE NUMBER WAS TOO HIGH' IN DIAG LOG. POOLPGNUM = 5A454B41 -> > ALLOWABLE RANGE.
JR12750INCORRECT DDL PRODUCED FOR CHANGE DATA TABLES CONTAINING DATE/TI ME/TIMESTAMP WITH DEFAULT DATE/TIME/TIMESTAMP
JR12781DB2START ON ACTIVE DBM DUMPS B700 IN DB2DIAG.LOG
JR12816V5.2 LOAD UTILITY DOESN'T BLOCK LOADING DATA INTO TYPED TABLES AND IT SHOULD ACCORDING TO THE V5.2 ADMIN GUIDE P. 204.
JR12822NT EVENT LOG FILLS UP WITH SQL0502 AT DIAGLEVEL 4 WITH VB (ODBC
JR12912SQL GENERATED BY CONTROL CENTER FOR REPLICATION CONTAINS DUPLICATE NAMES. TIME STAMP NOT UNIQUE.
JR12915GATEWAY CRASHES IN COLUMNNAMES LIST DURING A CALL TO A SP
JR12919UNDERDBDIR FIELD OF SQLB_TBSCONTQRY_DATA STRUCTURE IS NOT REVERSED WHEN USING SQLBTCQ API ON NT AND CONNECTING TO AIX.
JR12922API SQLESTAT CHECKING VERISON OF SERVER CODE INCORRECTLY CAUSING A TRAP.
JR12936AFTER UPGARDING GATEWAY TO WR09084, INTERMITTENT DB2 CONNECT TRAPS IN REMOVE_RDCS_DB@SQM_LIST_DCS_DB_RESETTABLE_DATA
JR12958PRECOMPILER GENERATES DIFFERENT SQL TYPE FOR CHAR HOST VARIABLES INSIDE A STRUCTURE DEPENDING ON LOCATION OF SHORT HOST VARIABLE.
JR12966DB2 CONNECT GATEWAY TRAPS IN FUNCTION SQLJMPAR
JR12971SQLJS_DDM_SYNCRSY IS TRAPPING UPON A RESYNC INITIATED BY OS/390. EVEN WHEN SPM IS NOT CONFIGURED.
JR13001UDB GATEWAY CRASHING WHILE CONNECTING CLIENT TO SERVER WITH TCP
APAR fixes included in WR09093 (Fixpak 8)
APARABSTRACT
GG03840SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN
GG03841SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN
GG03843AUTHID COLUMN IN UOW TABLE IS INCORRECT
GG03844AUTHID COLUMN IN UOW TABLE IS INCORRECT
GG03845NULL LONG VARCHAR VALUES NOT REPLICATED
GG03846NULL LONG VARCHAR VALUES NOT REPLICATED
GG03847VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN
GG03848WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0.
GG03849WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0.
GG03850IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1
GG03851IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1
GG03853VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN
GG03854LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN
GG03855LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN
GG03856SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030
GG03857UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD
GG03858UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD
GG03859SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030
GG03860SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD
GG03861SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD
IX82599DB2 UDB RACE CONDITION IN DB2LICD. LEADS TO REMOVAL OF IPC Q 0 (USUALLY!). UNLIKELY ON NON-MLNS, POSSIBLE ON MLNS.
IX83104ESTORE PROBLEMS DUE TO AIX MEMORY SEGMENTS NOT ATTACHING TO OPTIMUM POSITIONS.
IX83408FAILING BACKUP NOT RECORDED IN HISTORY FILE
IX83662SIGNAL#11 IN SQLKD_RCV_DATA
IX84195DBLOOK CAUSING MEMORY PROBLEMS SINCE V5.2 RELEASE
IX84766RESTART FAILS WITH SQL0575 WHEN REPLICATED TABLE IS INVALID
IX85990SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN
IX85991SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN
IX85992SQLCODE180 - BASE TABLE IS ALTERED VIA ALTER ADD OF A NOT NULL WITH DEFAULT COLUMN
IX86080AUTHID COLUMN IN UOW TABLE IS INCORRECT
IX86081AUTHID COLUMN IN UOW TABLE IS INCORRECT
IX86082AUTHID COLUMN IN UOW TABLE IS INCORRECT
IX86221DB2 5.2: RESTORE HANGS
IX86911NULL LONG VARCHAR VALUES NOT REPLICATED
IX86913NULL LONG VARCHAR VALUES NOT REPLICATED
IX86914NULL LONG VARCHAR VALUES NOT REPLICATED
IX87047LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN
IX87076WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0.
IX87078WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0.
IX87079WHEN APPLY IS ACTIVE IT DOES NOT STOP A SUBSCRIPTION WHEN ACTIVATE IS SET TO 0.
IX87080IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1
IX87081IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1
IX87082IN APPLY QUALIFIER WITH TWO SUBSETS, SET 1 HAS TWO AUXSTMTS, SET 2 HAS 1 STMT, BUT AUXSTMTS=2 WILL EXECUTE STMT FROM SET 1
IX87124SUN: ALLOCATION OF LARGE BUFFERPOOLS USING SOLARIS 2.6 (>1.6G) MAY FAIL WHEN INTRA_PARALLEL IS ON.
IX87156SMP: HANG DURING SUBAGENT SYNCHRONIZATION OF INDEX ANDING.
IX87172POOR PERFORMANCE BECAUSE STAR JOIN NOT SELECTED
IX87200VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN
IX87201VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN
IX87202LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN
IX87205LENGTH INCORRECT FOR INSERT/UPDATE OF ALTER ADDED VARCHAR COLUMN
IX87206VIS C++ DEBUGGER - SQLCODE -105 DUE TO INCORRECTLY GENERATED LSN
IX87280ROLLFORWARD FAILS WITH SQL1271W WHILE REBALANCING
IX87417SQL2036 - INVALID PATH, IN UDB EEE ENVIRONMENT USING DB2 LOAD
IX87422SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD
IX87463MULTIPLE LOGON WINDOWS WITH MSACCESS WHEN NO UID/PWD INPUT
IX87540INVALID ROW COUNT RETURNED ON UPDATE WITH STREAMS (LOB)
IX87542RECOVERY HISTORY FILE IS PRUNED EVEN WHEN REC_HIS_RETENTN PARAMETER IS SET TO -1.
IX87595UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD
IX87634DB2 TRAPS WHEN EXIT HANDLER CALLED IF RESOURCES ALREADY FREED
IX87653UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD
IX87654UPDATE ANYWHERE SEGMENTATION FAULT PROCESSING COMMIT LOG RECORD
IX87665SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030
IX87667SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030
IX87668SYS3175 IN CAPTURE ASNCCP.EXE ACCESS VIOLATION AT 00026030 0001:00016030
IX87670SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD
IX87671SEGMENTATION FAULT PROCESSING VARCHAR UPDATE LOG RECORD
IX87720CLI SQL_CONNECT_NODE WOULD NOT ACCEPT VALUE 0
IX87839EXCEEDING MAX APPLID SIZE OF 32 BYTES. DEFECT NUMBER 103039
IX87911DB2 UDB ERROR 28 IS INCORRECTLY RETURNED BY THE SAMPLE USEREXIT WHEN LOG FILE WE ARE TRYING TO ARCHIVE DOES NOT EXIST.
IX87928FIXES TO REPLICATION ADMIN TOOL, DJRA
IX88313HASH JOIN PLAN PRODUCES INCORRECT RESULTS
JR12555REMOTE DB BACKUP TO ADSM VIA NT CLIENT CONTORL CENTER WITH SESSIONS > 1 FAILS WITH SQL2032.
JR12681EVEN WHEN THE OPTIMIZE FOR N ROWS IS ON DB2 CONNECT WILL CONTINUE SENDING PRE-FETCH REQUESTS TO THE HOST.
JR12721IF THE IN PREDICATE OF THE WHERE CLAUSE IN A SELECT STATEMENT HAS MORE THAN 284 ITEMS, THE ENGINE TRAPS.
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.
JR12790SCRIPT CENTER JOB HAVING START CMD FAILS SQL1131 & MEM ERROR
JR12814DB2LOOK FOR REFERENTIAL CONSTRAINTS
JR12894RANDOM TRAPS IN SQLRA_CACHE_DEL_VAR WHICH ARE MANIFEST AS EITHER INSTANCE HANGS OR CRASHES. DIAG FILE 0XA602.
APAR fixes included in WR09083g (Fixpak 7g)
APARABSTRACT
IX86353DB2: DO NOT LOG FETCHES IN AUDIT LOG AS CONTEXT EVENTS
IX86368SQLJMF10 TRAPS WHEN SENT A NULL POINTER IN DB2RA.
IX86733DB2SETUP : INSTANCE CREATE FAILS DURING TCPIP CONFIG
IX87362QUERY WITH 'IN' PREDICATE RETURNS WRONG RESULT
IX87377LINK FROM /USR/LPP/DB2_05_00/INSTANCE/DASILIST TO ~/BIN/DASILIST DISAPPEARS AFTER BACKING OFF FIXPACK7
IX87446UDF NOT MAKING FINAL CALL WHEN IT TERMINATES ABNORMALLY
IX87478SQLUGRPI CALL RETURNS SQL6044N
JR12414IMPLEMENT VARIALBE TAPE BLOCK SIZE FOR THE DB2 BACKUP COMMAND ON THE INTEL PLATFORM.
JR12804SETXXXSTREAMS BROKEN IN THE 5.2 NET DRIVER
JR12809MEMORY LEAK IN DB2JD.EXE DEFECT 101809
JR12813EXPORT WITH DATALINKS COLUMN FAILS WITH NO MESSAGES RETURNED
JR12819IMPORT OF EXPORTED CLIENT PROFILE IN CCA FAILS CCA3002N IF PATH CONTAINS LONG NAMES WITH BLANKS
APAR fixes included in WR09083f (Fixpak 7f)
APARABSTRACT
IX85687IMPROVE DPS SO THAT THE DB2 HANDLES SQLOQQUE FAILURE BETTER.
IX86742TURKISH CODEPAGE: USERIDS CONTAINING THE LETTER I ARE INCORRECT- LY TRANSLATED BY DB2 INTERNALLY RESULTING IN AUTH. FAILURE.
IX86987SLOW INSERT PERFORMANCE WITH NON-NUMERIC PARTITIONING KEY
IX87048INTERMITTENT SQL0290 DURING EXECUTION OR BIND
IX87376DB2PROFC TRAPS WHEN INVALID PREPAREOPTION SPECIFIED
IX87387SELECT W/ OPTIMIZE FOR N ROWS AND FOR FETCH ONLY GOING AGAINST MVS RESULTS IN AN ADDITIONAL FOR FETCH ONLY BEING ADDED.
JR12722CHANGING TARGET MEMORY TO 70% IN THE PERFORMANCE SMARTGUIDE, CAUSES DB2START TO RETURN SQL1022C-NOT ENOUGH MEMORY.
JR12745SQLBINDPARAMETER() DOES NOT HANDLE BEING PASSED A COLUMN SIZE OF ZERO PROPERLY AT FP 7 (WR09084).
JR12788TRAP ON CONNECTION TO DB2 / MVS WHEN CURRENTSQLID SET
JR12797NULL INDICATOR NOT BEING RESET IN JDBC APPLICATION USING THE 'NET' DRIVER.
APAR fixes included in WR09083e (Fixpak 7e)
APARABSTRACT
IX83002-1042 (SYSTEM ERROR) ON ROLLFORWARD
IX86031IN DB2/UDB - 'LIST HISTORY REORG SINCE' DOES NOT REPORT ALL VALID ENTRIES.
IX86457SIGUSR1 IS IGNORED IN SNA/6000 V3 AND LATER
IX86991EXPORT NOT PARSING MODIFIED BY DELIMITERS WHEN USING WITH PROPERLY
IX87061TRAP CAUSED WHEN USING THDSRVER.SQC SAMPLE DUE TO LATCHES
JR12683SQL0542 WHEN CREATING PRIMARY KEY, BUT COLUMN IS NOT NULL
JR12689REDUCE MSGS IN DB2DIAG.LOG CAUSED BY CONVERSION FILES
JR12719FILE_TRANSFER_CMD OPTION OF THE DB2 AUTOLOADER CONFIGURATION FILE DOES NOT CALL A BATCH FILE. IT DOES CALL AN .EXE FILE.
JR127325.2:SQL0956 / SQL1478 AFTER ALTERING V5GA BUFFERPOOLS
JR12734CCA IMPORT ONLY PICKS UP ONE INSTANCE IF MULTIPLE DEFINED FOR A SYSTEM.
JR12747JOB RSULT IN CC JOURNAL FOR SRIPT CENTER JOB IS PARTIAL
JR12753TRAP IN SQLCCCLOSEENTRIES WHEN CALLED FROM SQLEFORCEAGENTS().
JR12780IXF IMPORT OF V1 DATA FAILS IN V52 OS2 SYS3175
APAR fixes included in WR09083d (Fixpak 7d)
APARABSTRACT
IX83869CATALOGING MORE THAN 8 ODBC DATASOURCES FROM SCRIPT GIVE ERROR
IX85558SQL_ATTR_RETRIEVE_ROW IS STILL RETRIEVING DATA EVEN IF OFF.
IX86517LOAD TRAPS IN BUILD PHASE WHEN UTIL HEAP RUNS OUT OF SPACE.
IX86861SETNULL CAUSES TRAP WITH TIMESTAMP,TIME,DATE,BIGINT AND STREAMS
IX86901JDBC EXECUTEQUERY() RETURNS NULL
IX86940DB2LOADREC DOES NOT WORK IF LOAD COPY MOVED
IX86966REMOVE CHECK IN PROBE 70 OF SQLPWRITELR
JR12546NT: RESTORE TRAPS WHEN THE FULL PATH TO THE BACKUP IMAGE IS SPECIFIED IN THE RESTORE COMMAND (CLP OR CC).
JR12669SLQSTATE -1106 LOGGED IN DB2DIAG.LOG WHEN PERFORMING IMPORT FROM A REMOTE MACHINE TO A WINDOWS SERVER.
JR12745SQLBINDPARAMETER() DOES NOT HANDLE BEING PASSED A COLUMN SIZE OF ZERO PROPERLY AT FP 7 (WR09084).
APAR fixes included in WR21102c (Fixpak 7c)
APARABSTRACT
IX84079UNFENCED STORED PROCEDURE CAUSING SQL0859N WHEN CALLED IN A DUOW (TYPE2 CONNECTS)
IX85099V5.2 NT/W98 CLIENTS TO GATEWAY TRAPING AFTER 3-4 CONNECTIONS
IX85441IF LIBPATH IS LONG, REMOTE CONNECT WITH TCPIP RETURNS SQL10013
IX85893SQL0901 REASON 'SQLRINREC: FUTURE SHOCK' WHEN RUNNING AN SMP ENABLED QUERY.
IX86244USE SQLOINSTANCEPATH() TO LOWER NUMBER OF CALLS TO PASSWORD FILE
IX86413DB2 - UDB: SIGNAL 11 TRAPS AFTER HITTING AN ERROR IN SQLRXGET AND SQLRXPUT IN THE DIAG.
JR12361APAR USED TO CREATE PTF FOR DB2 WIN3.1 V520
JR12614DB2LOOK -D <ALIAS> DOES NOT WORK AGAINST REMOTE DATABASES
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.
JR12715ADD A NEW NOT NULL COLUMN FROM THE CONTROL CENTER, GOT SQL0193N IF THE DEFAULT IS EMPTY.
JR12731DDL FOR CREATE TABLE INCORRECT WHEN DBNAME IN DB2CLI.INI FILE
APAR fixes included in WR21102b (Fixpak 7b)
APARABSTRACT
IX82027IMPORT CAN HANG SYSTEM IF THE INPUT FILE ROW COUNT IS AN EXACT MULTIPLE OF THE COMMITCOUNT
IX84082CUSTOMER CAN'T RUN A JAVA STORED PROCEDURE MORE THAN ONCE WITH SOLARIS 2.6 AND JDK 1.1.6 WITHOUT RESTARTING UDB
IX84935DB2 UDB EEE DOES DISTRIBUTED CLOSE FOR SOME OPERATIONS
IX84950JDBC DRIVER OVERRIDES THE CLI SETTING FOR CURSORHOLD.
IX85171LOAD WITH DB2 UDB V5.2 ON HP-UX 11 SMP HAS POOR PERFORMANCE...
IX85342SIGNAL 11 IN SQLRA_FIND_SHIP_VAR (#11)
IX85415DB2 DOESN'T LINK IN THREAD SAFE CPIC LIBRARY FOR DB2DCPIC_IBM.A
IX85645EXECUTEUPDATE METHOD IN JDBC STILL RETURNS -1 IF NO ROWS WERE UPDATED. THE PROBLEM IS PRESENT ONLY IN JDBC NET DRIVER.
JR12594SQL3124W ON LOAD OF ASC FILE WITH PACKEDDECIMAL OPTION WHEN THE FILE HAS CORRECT STRUCTURE.
JR12613DB2 COMMON SERVER - CRASH RECOVERY FAILS WITH -2775 MESSAGES IN THE DB2DIAG.LOG FILE.
JR12666CONTROL CENTER GENERATED SQL FOR AS/400 AS FIELD FOR NUMERIC ZONE DECIMAL AS PAC DECIMAL INSTEAD.SOURCE DOES NOT MATCH TARGET
JR12673SQL0901N INDEX OUT OF RANGE, UDB PARSER PROBLEM
APAR fixes included in WR21102a (Fixpak 7a)
APARABSTRACT
IX85192SQLO902 RC 26 SQLO_NOMEM_UND IN SQLRIUIN (CRASHES DB)
IX85286LENGTH OF INTEGER TYPE IGNORED: SQLPARAM DOES NOT WORK PROPERLY WITH OTHER THEN CHAR DATA TYPES.
IX85764DB2 UDB 5.2 EEE: BAD PLAN WITH FOR BIT PARTITIONING KEY
JR12355LOADING BLOB COLUMN LARGER THAN THE TARGET GIVES SQL3408, BUT ERROR MESSAGE REFERS TO THE PREVIOUS COLUMN.
APAR fixes included in WR21102 (Fixpak 7)
APARABSTRACT
GG03792IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG
GG03794IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL
GG03795IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL
GG03796WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE
GG03797WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE
GG03798APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS, ANY PLATFORM
GG03799APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS (NT, UNIX ALSO)
GG03800ASN1053E THE EXECUTION OF THE ASNLOAD PROGRAM FAILED RC6
GG03801ASN1056E APPLY PASSWORD FILE COULD NOT BE OPENED - ERROR CODE IS 215601
GG03802ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON
GG03803SQLCODE407 - ASSIGNMENT OF A NULL VALUE TO A NOT NULL COLUMN IS NOT ALLOWED OCCURS WHEN WILD CARD CHARACTER NOT USED IN BUILDDB
GG03804PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY
GG03805APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (NT)
GG03806ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT
GG03807CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778
GG03808PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY
GG03810AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0
GG03811AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0
GG03812IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG
GG03813PRUNING CONTROL ROWS GET DELETED IN V5 IF THE V1 SUBSCRIPTION HAS RUNMODE EI STATEMENTS THAT ARE OMITTED IN V1 TO V5 MIGRATION
GG03814SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS
GG03816SQLCODE407 - ASSIGNMENT OF A NULL VALUE TO A NOT NULL COLUMN IS NOT ALLOWED OCCURS WHEN WILD CARD CHARACTER NOT USED IN BUILDDB
GG03817ASN2748E ASNMIG PREPARE ENDS UNSUCCESSFULLY
GG03819SQLCODE407 WHEN MIGRATING CAPTURE FROM V1 TO V5 AND ABOVE
GG03820PRUNING CONTROL ROWS GET DELETED IN V5 IF THE V1 SUBSCRIPTION HAS RUNMODE EI STATEMENTS THAT ARE OMITTED IN V1 TO V5 MIGRATION
GG03821ASN2769E SQLCODE518 - DPROPR MIGRATE PROGRAM FAILS WITH SQLCODE518 WHEN MIGRATING PRUNING CONTROL TABLE
GG03822SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS
GG03825ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT
GG03826ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT
GG03829CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778
GG03830ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON
GG03831CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED
GG03832CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED
GG03833PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE LOCK CS TABLE IF APPLY FOR DB2/MVS 3.1 RUNNING
GG03834PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE
GG03835ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP
GG03836ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP
GG03837ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT
GG03838APPLY DID AN UNEXPECTED FULLREFRESH
GG03839APPLY DID AN UNEXPECTED FULLREFRESH
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
IX81525SQLALLOCSTMT FAILS MEMORY CLEANUP IF OUT OF MEMORY
IX81831INDEX BUILD PHASE HUNG ON LOAD
IX81849SQLESETC API USES WRONG CONTEXT IN MULTITHREADED CLI APPS
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
IX82548COLD START ENHANCEMENTS FOR SQLCODE964
IX82599DB2 UDB RACE CONDITION IN DB2LICD. LEADS TO REMOVAL OF IPC Q 0 (USUALLY!). UNLIKELY ON NON-MLNS, POSSIBLE ON MLNS.
IX82922IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL
IX82923IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL
IX82924IN TARGETDB THE ASN.IBMSNAP_REGISTER.CCD_OLD_SYNCHPOINT FOR THE TWO REGISTERED CCD VIEWS IS NOT MAINTAINED - LEFT NULL
IX82942NODENUMBER IN THE ON CLAUSE OF A JOIN QUERY CAUSES A -901
IX82970SIG #11 IN SQLRIDESCRIBEINPUT LOADING BNI_PTR ON AN ATTEMPT TO REUSE A SECTION IN THE SQL WORK AREA.
IX82992CALLS SQLCOLUMNS() ON VIEWS RETURNS 0 COLUMNS ON ANY VIEW THAT ENCOUNTERS SQL0437.
IX83002-1042 (SYSTEM ERROR) ON ROLLFORWARD
IX83038WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE
IX83039WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE
IX83040WHEN COPYING SOURCE WITH VIEWS TO TARGET USING ASNCOPY , FULL REFRESH IS DONE ONLY FOR SOURCE , NOT THE VIEWS ON THE SOURCE
IX83041APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS, ANY PLATFORM
IX83042APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS, ANY PLATFORM
IX83043APPLY FAILING WITH SQLCODE100 ACCESSING IBMSNAP_UOW TABLE ON AS/400 RUNNING CAPTURE ON AS400 AND APPLY ON MVS, ANY PLATFORM
IX83063JDBC NEGATIVEARRAYSIZEEXCEPTION() ON EXECUTEQUERY() IF UPDATE MAKES NO CHANGES.
IX83068DB2AUTOLD LOOPS WITH JA_JP ENV
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
IX83238MTS APPLICATION GETS ACCESS VIOLATION.
IX83261APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (AIX)
IX83272NEGATIVE RETURN CODE -502 CAUSES TRAP IN SQLJIFSR.C
IX83355LIST APPLICATIONS DOES NOT SHOW PROGRAM NAME PROPERLY.
IX83441THE DB2DIAG.LOG SHOWS A NO TEMP AVAILABLE ERROR MESSAGE AND A TABLESPACE STATE TRANSITION ERROR 'FFFF8138'
IX83458PREP RETURNS SQL4920N WHEN EXEC SQL PROCEDURE HAS 50,60,70.. PARAMETERS.
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
IX83594APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (HP10)
IX83595APPLY TRACE OUTPUT CONTAINS PLAIN-TEXT PASSWORDS (SUN)
IX83616QUERY REWRITE PROBLEM USING VIEWS
IX83660SQL1034 DURING ONLINE BACKUP AND DROP TABLES OPERATIONS
IX83716TRAP IN SQLRAGSN. CLIENT INTERRUPTED WHILE BINDING TO THE DB TRAPS THE SERVER.
IX83732ROLLFORWARD TO A POINT IN TIME GETS -1042
IX83733DB21080 REDIRECTED RESTORE IS CASE SENSITIVE RE: DB ALIAS
IX83781SQL0344 RECEIVED WHEN DOING A SELECT AGAINST A VIEW WHICH HAS A BASE TABLE CONTAINING DATE/TIMESTAMP COLUMNS
IX83847PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY
IX83848PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY
IX83849PRUNING INCORRECT SINCE APPLY IS NOT ADVANCING THE SYNCHPOINT VALUE IN THE PRUNCNTL TABLE WHEN THERE IS NO DATA TO APPLY
IX83850AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0
IX83851AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0
IX83852AFTER AN UNSUCCESSFUL APPLY CYCLE , THE MASS_DELETE COLUMN IN THE ASN.IBMSNAP_APPLYTRAIL TABLE IS SET TO NULL WHEN STATUS=0
IX83953DB2JD SHOULD NOT READ LENGTH INDICATOR FOR OUTPUT ONLY PARAMETER
IX83968IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG
IX83969IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG
IX83970IN UPDATE ANYWHERE ASN.IBMSNAP_REGISTER.CD_OLD_SYNCHPOINT INCORR TARGET CAN MISS UPDATES.SYNCHPOINT IS ADVANCED WITH CURRENT LOG
IX84081TRAP IN SQE
IX84120ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT
IX84179DB2 UDB EEE: OPTIMIZER FILTER FACTOR IS INCORRECT
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
IX84503SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS
IX84504SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS
IX84505SQLCODE100 PRUNCNTL TABLE NOT UPDATED PROPERLY WHEN THE SUBSCRIPTION SET INCLUDES A MIX OF REPLICA AND USER COPY TARGETS
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.
IX84562ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT
IX84563ASNDONE EXIT NOT INVOKED WHEN DOING INCREMENTAL REFRESH AND SYNCHPOINT IS NULL SYNCPOINT
IX84565SQL0437W WARNING MESSAGE CAUSES EXPORT OPERATIONS TO FAIL.
IX84577CLI0125E ON SQLSETCONNECTATTR, AFTER PREPARE,BIND,EXECUTE,GETCH, ETDATA,SQLENDTRAN(ROLLBACK). EVERYTHING WORKS WITH EXECDIRECT.
IX84582CLP LIST TABLESPACES SHOW DETAIL DOES NOT AUTO-COMMIT.
IX84760BUF INSERT IS DISABLED WHEN NULL VALUES ARE INVOLVED FOR 5.2
IX84780DB2_ALL HANGS WHEN INPUT REQUIRED
IX84790SQL10003C ERROR WITH DB2/UDB FOR AIX DUE TO MEMORY LEAK.
IX84795SQL901N WHEN RUNNING A QUERY THAT WORKED ON DB2 V2.X AND NOWS FA ILS ON DB2 UDB V5.2. UDB IS ATTEMPTING TO MERGE A UNION...
IX84867CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778
IX84868CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778
IX84870CAPTURE NT ABEND C0000005 DRWATSON ERROR AFTER HAVING INSTALL THE FIX LEVEL FOR GG03778
IX84871ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON
IX84872ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON
IX84873ASNCMD STP ( CORRECT IS ASNCMD STOP ) - ASNCMD PRUNES ( CORRECT IS ASNCMD PRUNE ) INCORRECT SPELLING SHOULD NOT CAUSE DR WATSON
IX84896LOG ERROR WHEN DOWNLEVEL JDBC CLIENT COMING TO JDBC SERVER
IX84898CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED
IX84899CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED
IX84900CAPTURE DOES NOT WARM START WHEN COMMAND ISSUED
IX84907MISLEADING ERROR MSG -3514 IN DB2DIAG.LOG DURING LOAD EMPTY FILE
IX84964LOAD FAILS VIA CONTROL CENTRE ON ITALIAN UDB
IX85142PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE
IX85143PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE
IX85144PAGE FAULT AND / OR DR WATSON FOR LONG VARCHAR DATA TYPE
IX85196ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP
IX85199ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP
IX85200ASNCMD GETLSEQ SQLCODE 811, ASNCMD STOP
IX85243DB2ATLD -D OPTION NOT DISABLED
IX85266S LOCKS OBTAINED ON SYSTABLES DURING IMPORT/LOAD CAN CAUSE DEADL OCKS
IX85508ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT
IX85509ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT
IX85510ASN0001E SQLCODE180 - ROUTINE NAME IS EXEC_ISR_CD() SQL REQUEST IS EXECUTE INSERT TO CD - SYNTAX OF DATETIME VALUE IS INCORRECT
IX85653APPLY DID AN UNEXPECTED FULLREFRESH
IX85654APPLY DID AN UNEXPECTED FULLREFRESH
IX85655APPLY DID AN UNEXPECTED FULLREFRESH
JR12258MS ACCESS USES TYPE TIMESTAMP FOR TYPE DATE FIELDS.
JR12267INSTALL ADDS DEFALT_LOCAL_LU_ALIAS TO THE CS NDF FILE.
JR12333TRAP IN DOWN LEVEL CLIENT.
JR12353RESTORE FROM BACKUP ON DISKETTES FAILS
JR12356NT: 192 MB FILE CACHE LIMIT HIT WHEN DB2NTNOCACHE SET TO 1. 'FFFFB5AA' MSGS IN DB2DIAG.LOG, TBSPCS PUT INTO RF PENDING.
JR12376TRAP WHEN A VERY LARGE IN CLAUSE (2000 ENTRIES) IS USED IN A QUERY ON NT.
JR12400SQLGETDATA SHOULD SUPPORT DIFFERENT DATA TYPES, IF THE FIRST ONE IS USED TO GET SIZE OF THE DATA AND THE SECOND ONE IS USED TO R
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.
JR12419ADO: OFFSET PTR CAUSES TRAPS AND UNEXPECTED SQL_NEED_DATA RC
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.
JR12473SQL901N WHEN SELECT * FROM RU99.CRSUBADDLMEASURE WHERE USERGUID= '2' ORDER BY SORTORDER
JR12498SQLEXECUTE DOES NOT INSERT ALL COLUMNS PROPERLY
JR12505TABLESPACE LISTING INCORRECT DURING TABLE COPY VIA CONTROL CENTER
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
JR12538FOR BIT DATA WITH VARCHAR DOES NOT RETURN CHARACTERS.
JR12541LOCKING PROTOCOL CHANGES - REVERT TO WAITING FOR DELETES DURING INDEX SCANS
JR12563FFFF877E IN DB2DIAG.LOG AND -901 IN DB2 TRACE ON INSERT/UPDATE/D ELETE
JR12569SMART GUIDE ON NT DOES NOT WORK FOR MORE THAN 4 GB MEM ON SOLARI S
JR12572-902 ERROR FROM FUNCTION SQLM_DCS_APP_EXIT
JR12582DB2 TRAPS (NT TRAPS IN DB2SQN.DLL) WHEN THERE IS A 'TYPO' AFTER A GROUP BY CLAUSE...
JR12592SPM0438 THE DB2 SYNCPOINT MANAGER RECOVER LOG IS BAD.
JR12595ALWAYS RETURN CATALOG SEPARATOR TO BE '.' INSTEAD OF HAVING TO USE PATCH2=11
JR12625OPTIMIZER ENHANCEMENT FOR RECOSTING NESTED LOOP JOIN VS. MERGE SCAN JOIN.
JR12633IN CAE VER 5. RGBINFOVALUE='Y' FOR SQL_OUTER_JOINS WHERE AS IN C AE VER 2.1 IT IS 'N'.CUST. IS HAVING PROB. DUE TO THE ABOVE VAL.
JR12634SENDING DYNAMIC CALL PROCEDURE STATEMENT TO AS/400 INSTEAD OF STATIC ONE FROM CLI.
JR12649CLP SNAPSHOT FOR LOCKS OCCASIONALLY RETURNS INCORRECT RESULTS.
APAR fixes included in WR09073 (Fixpak 6)
APARABSTRACT
GG00888CAPTURE/NT JAPANESE ALWAYS STOPS WITH CHAR COLUMNS
GG00944THE FIRST POSITIONAL PARAMETER OF THE ANSAPPLY COMMAND ( OF DB2 UDB DPROPR ) IS CASE SENSITIVE IN THE WINDOWS/NT ENVIRONMENT.
GG00969MIGRATION TOOL CANNOT RUN ON WINDOWS 95 & 98 ASNMIG FAILS DURING MIGRATION OF MVS DPROPR FROM V1 TO V5
GG03680APPLY HANGS AND GENERATES C00005 EXCEPTION
GG03681UPDATE TO CCD NOT REPLICATING CORRECTLY
GG03685APPLY V5 IS NO LONGER HOLDING THE CRITSEC LOCK WHILE IT FETCHES THE CD ROWS - IT COMMITS AFTER IT GETS THE SEQUENCE NUMBERS
GG03686OF 26 SOURCE TABLES AND REPLICAS FOR UPDATE-ANYWHERE ONLY FIRST 20 TABLES ARE PROPAGATED - SQLCODE2038 MAY OR MAY NOT BE SEEN
GG03687ASN1051E 4A5102 THE ONLY WAY TO EXIT FROM A GAP SITUATION WHEN USING INTERNAL CCD IS TO MANUALLY UPDATE DPROPR CONTROL TABLES
GG03690APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITHOUT CONTROL SERVER
GG03691APPLY FAIL WITH ERRCODE 8C0101 SQLCODE104 SQLSTATE 42601
GG03692WHEN A LARGE OBJECT OCCURS IN THE BASE TABLE AND IS NOT REGISTERED , CAPTURE FAILS WITH PROTECTION FAULT
GG03693APPLY CONSUMES TOO MUCH SYSTEM RESOURCES WHEN SLEEP_MINUTES IS 0
GG03694CPU RESOURCE UTILIZATION IS TOO HIGH FOR OS/2 PLATFORM
GG03695CPU RESOURCE UTILIZATION IS TOO HIGH FOR NT PLATFORM
GG03696APPLY LOOPS WHEN LASTSUCCESS IS GREATER THAN 1 MONTH OLD FROM CU RRENT DATE
GG03697INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED
GG03698INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED
GG03699SQLCODE206 WHEN COPYING TO CCD
GG03700MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL
GG03701POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET
GG03702SUPPORT 18 BYTE COLUMN NAME WHEN BEFORE_IMG_PREFIX I
GG03703LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED
GG03704ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED B
GG03707SQLCODE206 WHEN COPYING TO CCD
GG03708LONG VARCHAR SUPPORT
GG03709NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION
GG03710NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION
GG03711ADD DELAY(N) INVOCATION PARAMETER FOR APPLY
GG03712ADD DELAY(N) INVOCATION PARAMETER FOR APPLY
GG03713SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING
GG03714SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING
GG03715APPLY MAY COPY UNCOMMITED DATA
GG03716APPLY MAY COPY UNCOMMITED DATA
GG03717(APPLY FOR OS/2) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT
GG03718APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED
GG03719APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED
GG03720SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD
GG03721SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD
GG03722(APPLY FOR OS/2) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS
GG03723POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET
GG03724MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL
GG03725CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION
GG03726CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION
GG03729CAPTURE/OS2 JAPANESE ALWAYS STOPS WITH CHAR COLUMNS
GG03731SQLCODE803 DURING FULLREFREH
GG03732SQLCODE803 DURING FULLREFREH
GG03734APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE
GG03735APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE
GG03737SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER
GG03738SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER
GG03739APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED
GG03740APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED
GG03741SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION
GG03742SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION
GG03743EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED
GG03744EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED
GG03745APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE.
GG03746APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE
GG03747APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER
GG03748APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER
GG03750SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR)
GG03751SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR)
GG03753CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY
GG03754CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY
GG03755ASN2769E SQLCODE518 - DPROPR MIGRATE PROGRAM FAILS WITH SQLCODE518 WHEN MIGRATING PRUNING CONTROL TABLE
GG03756APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLYTRAIL TABLE
GG03757APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLYTRAIL TABLE
GG03758APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0
GG03759APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0
GG03760MOBILE REPLICATION BETWEEN UDB PERSONAL WINDOWS 95 AND UDB ENTERPRISE EDITION AIX - CONTROL TABLES ARE ON AIX MACHINE
GG03761VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311
GG03762SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES
GG03763SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES
GG03764VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311
GG03766REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804
GG03767REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804
GG03768APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS
GG03769APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS
GG03772SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911
GG03773SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911
GG03774SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS
GG03775SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS
GG03776SQLCODE407 WHEN MIGRATING CAPTURE FROM V1 TO V5 AND ABOVE
GG03777CD_OLD_SYNCPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD
GG03778CD_OLD_SYNCHPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD
GG03779WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS
GG03780WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS
GG03781SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER
GG03782SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER
GG03783APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS
GG03784APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060.
GG03785APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060.
GG03786APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS
GG03787ASN2748E ASNMIG PREPARE ENDS UNSUCCESSFULLY
GG03790COLD START ENHANCEMENTS FOR SQLCODE964
GG03791COLD START ENHANCEMENTS FOR SQLCODE964
IC19729ASNSERV.EXE WAS NOT SHIPPED WITH DATAJOINER FOR NT V210.
IX61374CICS/6000 TERMINATES AFTER BAD XACLOSE USING DDCS/6000
IX67258DB2 THINKS APPLICATION IS MULTI THREADED
IX68617RESTORING DB2/6000 V2.1 DATABASE (WITH RAW DEVICE CONTAINERS) TO NEW AND GETTING DB2DIAG.LOG ERRORS WITH THE CONTAINERS.
IX70033SQLSETENVATTR WITH SQL_ATTR_OUTPUT_NTS NOT WORKING PROPERLY WHEN IT SET TO SQL_FALSE
IX71104DB2BATCH CORE DUMPS WHEN USING -CLI AND -O WITH P > 1 EX: DB2BATCH -D SAMPLE -F <FILENAME> -O P 3 -CLI
IX71266SQL10013 - ON SIXTH INVOCATION OF STORED PROCEDURE
IX71439LOOPING FENCED UDF NOT CLEANED UP
IX71837USING FOR BIT DATA AND NORMAL CHAR TYPES IN A MERGE JOIN LEADS TO INCORRECT OUTPUT.
IX71898INCORRECT OUTPUT FOR FUNCTION LOG10
IX71996LOAD INTO A TABLE ALIAS FAILS WHEN RETRIEVING COLUMN DEFAULTS
IX72350TRIGGERS IN A SUBQUERY PREVENT OPTIMIZER FROM REWRITING SUBQUERY AS A JOIN.
IX72355A TRAP WITHIN A STORED PROCDURE IN SQLE_MRSP. DB2SYSC CORE DUMP
IX72365IMPORT .. OF DEL MODIFIED BY CHARDEL '' RETURNS SQL3017 FOR UDB, REGRESSED FROM V2
IX72390DB2 UDB - WITH THE EVENT MONITOR ON MEMORY OVERWRITE OCCURS WITH SQL STATEMENTS > 4K.
IX72404SQLOPENBPF PROBE 920 DURING BACKUP
IX72451RESTORING V2 BACKUP IN V5 PLACES MESSAGE IN DIAG FILE THAT TABLSPC 0 BUFF POOL 0 DOES NOT EXIST MAPS TO BUFFPOOL 1.
IX72460DB2ADUTL DOES NOT USE THE ADSM PASSWORD SET WITH DSMAPIPW
IX72507VARCHAR FIELD IS PADDED WITH @ SIGNS WHEN USING JDK 1.13 WITH NA TIVE THREADS CONNECTION TO MVS
IX72517AN ALTER ADDED TIMESTAMP CAUSES SQLCODE180
IX72697PROGNAME VARIABLE CAUSES LINKER MESSAGES
IX72725CORE DUMP RUNNING APPLY/HP AND ABEND IN APPLY/MVS
IX72787WHEN NO DEACTIVATE COMMAND ISSUED BEFORE DB2STOP ON AN ACTIVATED DATABASE CAN LEAVE PAGE CLEANERS AND PREFETCHERS ORPHANED.
IX73014SQLCANCEL IN JDBC DOES NOT WORK AS IT IS SERIALIZED.
IX73136A PASSWORD DEFINED WITHIN NIS+ WITHIN SOLARIS CANNOT BE AUTHENTI CATED BY DB2
IX73165CUSTOMER WOULD LIKE A MORE INTUITIVE MESSAGE RETURNED WHEN ROLLI NG FORWARD THROUGH LOGS AND A LOG FILE IS MISSING.
IX73168DB2 V5 EEE GA CODE. POINT IN TIME TABLESPACE RECOVERY PROBLEMS.
IX73231QUERY WAS GETTING VERY BAD PERFORMACE IN A QUERY WHEN RUNSTATS FOR A TABLE WAS RUN WITH DISTRIBUTION.
IX73248WHEN DISABLEMULTITHREAD IS SET TO 0 IN THE DB2CLI.INI FILE THERE EXISTS A MEMORY LEAK IN THE SQO LAYER WHEN USING CLI
IX73249OUTBOUND APPLICATION ID PROVIDED BY DB2 LIST DCS APPLICATIONS SHOW DETAIL IS IN INCORRECT FORMAT
IX73368DB2BATCH IN V5 (EVEN WITH FIRST FIXPACK) APPLIED RETURNS INCONSISTENT TIMING SUMMARIES WHEN MULTIPLES STATEMENTS ARE USED
IX73417DB2 UDB SQL1090 ERROR MESSAGE IS MISLEADING.
IX73443LOAD LOGIC SHOULD BETTER HANDLE RCF FLAG VALUES
IX73445ONLY LOG SEVERE ERRORS IN SQLDLOADTCBOBJDESC
IX73521DB2 UDB: DB2START RESULTS IN SQL1092N WHEN INSTANCE OWNER ID ON AIX HAS LOGIN=FALSE OR RLOGIN=FALSE
IX73537DB2 V5 EEE: ENABLE AUTOLOADER > 2 GIG FILE SUPPORT
IX73543INDEX CORRUPTION AFTER V2 DB MIGRATED TO UDB AND ALTERING VARCHAR COLUMN LENGTH
IX73564INVALID USE OF PTHREAD_CLEANUP_PUSH() AS THREAD EXIT HANDLER.
IX73675DB2AUTOLD DOES NOT HANDLE COLUMNS STARTING WITH 'MODE' CORRECTLY
IX73768V5 EEE VERSION OF DB2LN DOES NOT SUPPORT DB2 PE V1.2
IX73875SELECT CAUSES THE UDB INSTANCE TO GO DOWN
IX73986DB2 AGENT LOOPS ON A SNA RECEIVE WAIT AFTER HOST RETURNS 'AGENT PERMINANT ERROR REPLY MESSAGE'.
IX73998MEMORY OVERWRITE DURING INDEX CREATION DUE TO VARIABLE NOT LARGE ENOUGH TO HOLD PACKED DESCRIPTOR VALUES
IX74044SIGNAL #11 WHEN LOADING IN TABLE WITH 304 COLUMNS
IX74116LOAD W/ HIGH DISK_P CORRUPTS LF DATA
IX74229REMOVING TRAILING PERIOD FROM DECIMAL TO CHAR.
IX74232CANNOT MIGRATE INSTANCE TO V5 IF REMOTE DATABASES CATALOGED
IX74453CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS
IX74491ADD PATCH FOR NETSCAPE LIVEWIRE TO IGNORE THE PROCSCHEMA ARGUMENT
IX74523SQR NOT MAPPING INTERNAL ERROR TO CLP CORRECTLY
IX74524LIST APPL. CMD FAILED AFTER TWO SUCCESSFUL CONCURRENT LOADING
IX74529APPLY LOOKED FOR WRONG PASSWORD FILE WHEN INVOKED WITH
IX74540CUST CAN'T RUN SCRIPT STORED ON SERVER FROM SCTRIPT CENTER USING RUN NOW ... OPTION.
IX74582INCORRECT OUTPUT IN LIST RECOVERY HISTORY FOR 'Q' OPERATION
IX74848DB2STOP DOES NOT STOP ON LARGE NUMBER OF NODES - TIMES OUT
IX74871IN LOCK WAITS FOR X LOCK
IX74895CURSOR NOT CLOSED WITH SPECIALCOLUMNS CALL ON NON INDEX TABLES
IX74896V5 CLP INCORRECTLY SETS SQLERRD STRUCTURE TO ZEROS FOR SELECT
IX74904SQLDRIVERCONNECT PROMPTS WHEN UID AND PWD IN DB2CLI.INI
IX74915ON AN SMP SOLARIS DB2 UDB, CONCURRENT LOADS RESULTS SQL1224.
IX74918PERMISSION DENIED ON HA TAKEOVER ON THE PARTITION TAKING OVER
IX74969DB TAPE RESTORE VIA CONTROL CENTER FAILS WITH SQL2042W I/O ERROR 2060
IX74997LOG FILES NOT ARCHIVE AFTER CRASH RECOVERY.
IX75047DB2LOOK FAILS WITH SQL0811
IX75101FAILURE IN SQLDIOSR - NO ROOM IN SPECIFIED PAGE FOR OBJECT ID
IX75150CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS
IX75151CPU RESOURCE UTILIZATION IS TOO HIGH FOR UNIX PLATFORMS
IX75217CLI PROBLEM WITH HY009 / S1009
IX75242ROLLFORWARD TO PIT OF A TABLESPCE RECIEVED A -1042 SQLCODE
IX75332INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED
IX75443OPTIMIZER ERRONEOUSLY FAVOURS LIST PREFETCH OVER TABLE SCAN WHEN SCANNING SMS TABLES WITH LESS THAN 32 PAGES.
IX75463INCORRECT NODE NUMBER IN BACKUP NAME IN ADSM
IX75587PERFORMANCE DEGRADES GOING FROM COMM_BANDWIDTH 1 TO 100
IX75609LIST APPLICATIONS CORRUPTS APP ID FOR LONG APP NAMES
IX75630RECEIVE SQL0502 WHEN GOING TO A V2 DATAJOINER BECAUSE OF CHAINED AUTOCOMMIT
IX75640CREATE NODEGROUP RECEIVES -901 FROM SQLRKANG_CBP_I - FFFFFA604
IX75642DB2 RESTART FAILS AFTER HITTING EOF ON BUFFER POOL FILE(S) - FFF FF609
IX75687UNABLE TO RESTORE FROM A BACKUP TO ADSM USING MULTIPLE OPEN SESSIONS.
IX75688DB2 SHOULD USE 'LSATTR' COMMAND TO DETERMINE MEMORY IN AIX
IX75695JDBC APPLICATION DRIVER SHOULD NOT FREE THE ENVIRONMENT IF IT IS GARBAGE COLLECTED
IX75909DB2 BRINGS DOWN INSTANCE AFTER A DYNAMIC SQL DOES NOT CLEAN UP P ACKAGES
IX75933OF 26 SOURCE TABLES AND REPLICAS FOR UPDATE-ANYWHERE ONLY FIRST 20 TABLES ARE PROPAGATED - SQLCODE2038 MAY OR MAY NOT BE SEEN
IX75945IGNORE SQL0000W GENERATED BY POWER BUILDER APPLICATION AFTER CLI0165E ERROR 'ERROR IN ROW' IS DISPLAYED BY APPLICATION.
IX75975INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED
IX75976INTERMITTENT NONUPDATE OF GLOBAL SYNCHPOINT WHEN CD_NEW_SYNCHPOINT ADVANCED
IX76127DB2 RESTART DATABASE FAILS WITH SQL1042 DUE TO -4015
IX76159DB2 AUTOLOADER DOES NOT WORK WITH DUMPFILE OPTION ON MLNS
IX76172STATEMENT OBJECT CREATED BY GETBINARYSTREAM IS NOT GETTING CLOSED
IX76236SIGNAL #11 IS SQLRLLPD WHEN DROPPING TABLESPACE AND THERE ARE AND A LARGE NUMBER OF TABLES (OVER 6000)
IX76273DB2 UDB - LOAD HANGS WHEN DMS TABLESPACE FILLS UP
IX76365SLOW PERFORMANCE
IX76438ALTER TABLE RESULTS IN SQL902,126 ON DB2 UDB
IX76443PERFORMANCE PROBLEM OF A SELECT WITH AN ORDER BY
IX76624DB2/EEE V500 ON AIX. SIGNAL #11 IN BUFFER POOL SERVICES.
IX76678SQL1042 ON GET SNAPSHOT FOR APPLICATIONS ON SOLARIS 2.6
IX76680SQL10012 WHEN USING STORED PROCEDURES WITH JAVA ON SUN SOLARIS
IX76735MAX_SYNC_MINUTES VALUES OF ZERO OR LESS MEANS NULL
IX76914CHANGING DATASOURCE MANUALLY IN 'CONNECTING TO DB2' WINDOW TRAPS
IX76922KEYWORD DATALINK
IX76924STAR JOIN DISQUALIFIED FOR STAR JOIN ELIGIBLE QUERY
IX77067SUN BACKING OFF FIXPAK #3 AND USING DB2IUPDT CAUSES FATAL ERROR DUE TO INCOMPATIBLE LEVELS OF CODE
IX77088DB2 LOAD TO SAME TABLESPACE IN PARALLEL GIVES -911
IX77129LONG VARCHAR SUPPORT
IX77137RUNSTATS WITH DISTRIBUTION PICK INCORRECT PLAN
IX77154OUTER JOIN IN LIST PREDICATE OPTIMIZER PROBLEM
IX77312DB2AGNTP PROCESS HOLDING /ETC/GROUPS FILE OPEN
IX77398CANNOT BACKUP TO MVS TAPES VIA CLIO/S BECAUSE UDB WILL NOT ALLOW A BACKBUFSZ OF 8
IX77399CRASH RECOVERY ENDS TOO EARLY.
IX77400SQL.H MISSING SQL_QUERYOPT CONSTANTS FOR 2 AND 7
IX77409NIS CHECK FAILS DURING INSTALL OF ADMIN SERVER
IX77439SQL30081N ON SECOND CONNECT THROUGH SYSPLEX SERVER
IX77480DIAGNOSTIC CODE FOR NLI SITUATIONS AND BPS PROBLEMS
IX77494DB2 UDB LOAD COMMAND USING 'MODIFIED BY DUMPFILE' AND CPU PARALLISM > 1 RESULTS IN AN INCOMPLETE DUMPFILE.
IX77553BACKUP/RESTORE API ERRORS
IX77572RECYCLING SCRIPT CENTRE CREATES ERROR MESSAGE -> 'DBA2078E AN UNEXPECTED ERROR OCCURRED. THERE IS NO JOB OUTPUT.'
IX77672INDEX CORRUPTION AFTER MIGRATING TO V5
IX77703SQL1478W ON CONNECT AFTER ALTER BP AFTER FP3
IX77706DB2START.PROCID.DAT FILES NOT BEING REMOVED FROM FILESYSTEM. THESE FILES ARE GENERATED FOR EVERY DB2START.
IX77770SQL1704N RC=8 ON DATABASE MIGRATION OF DB2 V2 TO V5 ON HP-UX
IX77776ON INDEX REBUILD SQL0404 DUE TO INCORRECT INDEX PACKED DESCRIPTOR UPDATE AFTER ALTER COLUMN
IX77873V5 FIX FOR V2 APAR IX76471. PERFORMANCE ENHANCEMENT FOR INSERT/ UPDATE BY IMPROVING FREE SPACE CONTROL MAP SCANS.
IX77970NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION
IX77971NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION
IX77972NEW NOSLEEP OPTION FOR THE APPLY SUBSCRIPTION
IX77973ADD DELAY(N) INVOCATION PARAMETER FOR APPLY
IX77974ADD DELAY(N) INVOCATION PARAMETER FOR APPLY
IX77975ADD DELAY(N) INVOCATION PARAMETER FOR APPLY
IX77976SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING
IX77977SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING
IX77978SUBSCRIPTION WITH STATUS=1 SHOULD BE ELIGIBLE FOR PROCESSING
IX77979APPLY MAY COPY UNCOMMITED DATA
IX77980APPLY MAY COPY UNCOMMITED DATA
IX77981APPLY MAY COPY UNCOMMITED DATA
IX78109LOAD HANGS ON SMP MACHINE WHEN SINGLE ' ENCOUNTERED AND ' IS THE STRING DELIMITER
IX78127(APPLY FOR AIX)LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT
IX78128(APPLY FOR HP) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT
IX78130(APPLY FOR SUN) LASTSUCCESS IN ASN.IBMSNAP_SUBS_SET IS NOT ADVANCED CORRECTLY PROBLEM WILL APPEAR AFTER DATE CHANGE AT MIDNIGHT
IX78163APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED
IX78164APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED
IX78165APPLY FAILED SQLCODE407 WHEN COMPUTED COLUMNS ARE SPECIFIED
IX78166SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD
IX78167SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD
IX78168SQLCODE407 WHEN COPYING TO NONCONDENSED INCOMPLETE CCD
IX78169(APPLY FOR AIX) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS
IX78170(APPLY FOR HP) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS
IX78171(APPLY FOR SUN) ASN1023S UPON FAILURE OF A SUBSCRIPTION DESIGNATED BY ASN1048E THE SPILL FILE DOES NOT CLOSE PROPERLY SO REOPENING IT FAILS
IX78176DB2LOOK DOES NOT EXTRACT TABLESPACE INFORMATION FOR TABLESPACES WHICH HAVE NO TABLES DEFINED WITHIN THEM
IX78183POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET
IX78184POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET
IX78185POSSIBLE MISSING DELETE UPDATES WHEN MORE THAN 100 TABLES IN SET
IX78186MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL
IX78187MAX_SYNCH_MINUTES VALUE OF ZERO OR LESS MEANS NULL
IX78232SQLBRESERVEFILETOKEN IN DB2DIAG.LOG FID TIMING PROBLEM
IX78244REORG OF COMPACT BLOB EXPANDS OBJECT TO NON-COMPACT SIZE
IX78265CREATE INSTANCE VIA DB2SETUP HANGS ON HP-UX WHEN RUN FROM THE INSTALL DIRECTORY
IX78334CREATING TRIGGER WITH SYNTAX ERROR INTERNALL RETURNS SQL0104 BUT BRINGS DOWN THE CONNECTION RETURNING SQL1024
IX78344UPDATE CONNECTION SMARTGUIDE WILL NOT ALLOW '.' FOR TCPIP HOST
IX78408CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION
IX78409CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION
IX78410CAPTURE COMES DOWN WITH DR WATSON ERROR MESSAGE AND C0000005 ACCESS VIOLATION
IX78463CAPTURE/AIX JAPANESE ALWAYS STOPS WITH CHAR COLUMNS
IX78464CAPTURE/HP JAPANESE ALWAYS STOPS WITH CHAR COLUMNS
IX78465CAPTURE/SUN JAPANESE ALWAYS STOPS WITH CHAR COLUMNS
IX78479WHEN A SEMAPHORE SET USED BY DB2 UDB IS MISSING, DB2 WAS BROUGHT DOWN. DB2 DOES NOT NEED TO BE BROUGHT DOWN IN THIS CASE.
IX78481DB2 UDB ON OS/2 - THE DB2LICD PROCESS DOES NOT START WHEN A CONNECTION IS MADE TO THE HOST FROM THE GATEWAY.
IX78499INCORRECT OUTPUT IN GET DATABASE SNAPSHOT FOR MAX AGENTS FIELD
IX78509-973 WHEN DOING AN IMPORT FROM A COORDINATING NODE TO A REMOTE DATA NODE. MEMORY LEAK IN SQLRKAIN. RUNNING OUT OF APPLHEAP
IX78555IFOR_LS.CLIENT.BASE FIXPAK PREREQUISIT FAILS ON AIX 4.3
IX78558APPLY FAILED WITH SQLCODE803 DURING FULLREFREH
IX78559APPLY FAILED WITH SQLCODE803 DURING FULLREFREH
IX78560APPLY FAILED WITH SQLCODE803 DURING FULLREFREH
IX78566CATALOG CACHE MONITOR VARIABLES ARE NOT RETURNED IN AN APPLICATION SNAPSHOT (THEY ARE IN A DATABASE SNAPSHOT)
IX78628DBI1069 -- SYSTEM ERROR ON HP-UX 10.20 UDBWITH ATTEMPTED INSTANCE CREATION VIA DB2ICRT OR DB2SETUP
IX78630SQLNUMRESULTCOLS() RETURNS -301
IX78710EXPORT OF 167 MILLON ROWS RETURN SQL2003
IX78760APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE
IX78761APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE
IX78762APPLY DID NOT REPLICATE CHANGE DATA FROM CCD SOURCE
IX78820SQLFETCH AFTER SQLFOREIGNKEYS FAILS
IX78836'ALTER TABLE table_name ADD COLUMN TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP' FAILS WITH SQL0193N
IX78867FORCE EXPIRED PASSWORDS STILL WORK ON NON-AIX UNIX
IX78903ARRAY INPUT FOR BLOB COLUMN INSERTS WRONG DATA
IX78958INVALID CONTAINER NAMES IN SET TABLESPACE CONTAINERS FOLLOWED BY ABORTED TABLESPACE RESTORE PREVENTS A SUBSEQUENT TBSP RESTORE.
IX78963INCORRECT OUTPUT FROM QUERY USING INDEX-BITMAP-ANDING
IX78975LOAD WITH STATISTICS YES AND LOCKTIMEOUT CAN GIVE -911 RC=68
IX78981PROBLEM W SQLJGEN.C PROCESSING ACCRDBRM. THE AUTHID IN THE ACB C OPY OF THE AUTHINFO - NOT FILLED IN INTRMEDIARY IN 2-HOP SCENAR.
IX79090SIGNAL HANDLER NEEDED IN DB2JD
IX79213MR UNABLE TO CATCH ERROR MSG CAUASING INTERMITTANT HANG
IX79235DB2/AIX TRAP IN LOAD WHEN SYSTEM ACTIVITY IS HIGH. SIGNAL 11 IN SQLULUMW.
IX79247CANNOT RESTORE NEW DATABASE FROM BACKUP WITH DIFFERENT NAME
IX79292SIGNAL #11 IN DB2LRID WHEN LOAD IS TERMINATING
IX79301DB2 UDB EEE HANG C980331
IX79318NON-SYSADM IDS LOG ENTRIES TO DIAG FILE AT DIAGLEVEL 3 OR 4 ON ATTEMPTED CONNECT TO DB. THESE IDS TRY TO OPEN DB2AUDIT.CFG.
IX79456FORCE APPLICATION BRINGS DOWN DB2 WHEN DOING INSERTS WITH INSER T BUFF ON AT THE SAME TIME IN AN APP. ( BUFFERED INSERTS )
IX79557SQL3508 RC 1 USING SQLULOAD API IN AN APPLICATION COMPILED ON V2 OF DB2 RUNNING AGAINST A DATABASE ON V5 UDB.
IX79591SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER
IX79593SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER
IX79595SQLCODE204 DUE TO SUBS_SET TABLE NOT BEING ON SOURCE SERVER - THERE IS NO REAL NEED FOR SUBS_SET TO BE ON SOURCE SERVER
IX79598APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED
IX79599APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED
IX79600APPLY PERFORMANCE WHEN A VIEW OF A SINGLE TABLE IS USED
IX79601SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION
IX79602SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION
IX79603SUPPORT A NEW OPTION FOR ASSOCIATING AN SQL STATEMENT OR STORED PROCEDURE CALL WITH A SUBSCRIPTION
IX79604EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED
IX79605EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED
IX79606EXTERNAL TARGET CCD TABLES NEED NOT BE AUTO-REGISTERED
IX79607APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE.
IX79608APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE.
IX79609APPLY DID NOT COPY UPDATES WHEN SOURCE TABLE AND ITS REPLICA ARE ON THE SAME DATABASE.
IX79616ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION
IX79623APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER
IX79624APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER
IX79625APPLY FAILED WITH ASN1055 WHEN CONTROL TABLES RESIDE IN SQL ANYWHERE/DATAJOINER
IX79627ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION.
IX79628ASN1049S APPLY FAILS TO START WHEN SOME TEMPORARY FILES WERE NOT DELETED FROM A PREVIOUS INVOCATION
IX79865CLI0602E MEMORY ALLOCATION ERROR IN JDBC NET DRIVER WITH CLOBS
IX79866DIA1036C XA ERRORS (SQLPXCM2 P:20) SQLCA= -998 LOGGED TO DIAG FILE DURING 2-PHASE COMMIT SCENARIO
IX79867V5 CLI/ODBC APPL: IF AUTOCOMMIT IS ON AND THE CLIENT APPL GETS A LOCKTIMEOUT (SQLCODE=-911), THEN CONNECTION LOST (SQLCODE=-900)
IX80044SEMOP ERRORS ON EVERY FAILING LOCAL CONNECT (INVALID USERID OR PASSWORD). NET.DATA APP CAUSES DB2DIAG.LOG TO GET VERY LARGE
IX80084SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR)
IX80087INCORRECT RESULTS RETURNED FROM AN SQL QUERY AFTER RUNSTATS IS EXECUTED ON THE TABLES REFERENCE IN THE FROM CLAUSE.
IX80098DB2 UDB CONTROL CENTER - JOURNAL JOB HISTORY TIMESTAMPS GET OUT OF SYNC WHEN OLD JOBS ARE REMOVED.
IX80107DB2 UDB - SQL1269N/SQL1035 OCCURS WHEN ATTEMPTING AN ONLINE TABLESPACE ROLLFORWARD COMPLETE OR STOP.
IX80130SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR)
IX80131SEGV WHEN BASE TABLE COLUMN COUNT NOT EQUAL CD (LONG VARCHAR)
IX80294SQLEXECUTE() DOES NOT REDESCRIBE WHEN THE SQLDA CHANGED
IX80301CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY
IX80315CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY
IX80317CAPTURE MARKS X'FFFF...F' IN CD_OLD_SYNCHPOINT OR CD_NEW SYNCHPOINT - THIS MAY CAUSE APPLY TO RUN CONTINUALLY
IX80372APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLYTRAIL TABLE
IX80373APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLY TRAIL TABLE
IX80374APPLY LOOPS - SLEEP_MINUTES NO LONGER HONOURED STATUS=2 ROWS INSERTED INTO APPLYTRAIL TABLE
IX80375APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0
IX80376APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0
IX80377APPLY TRAIL TABLE EFFECTIVE_MEMBERS AND MASS_DELETE SOMETIMES EQUAL NULL WHEN THE STATUS IS 0
IX80480DB2 V5. FAILURE TO RESTART LOAD.
IX80545DB2 V5 (ANY PRE 5.2) CRASH RECOVERY FAILS W/SQL1042. DB2DIAG.LOG SHOWS -6899 IN SQLPRESR() PROBE:0.
IX80589SQL901 WHEN RUNNING QUERY WITH INTRA_PARALLEL=YES,DFT_DEG.=-1
IX80618SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES
IX80739SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES
IX80740SEGV WHEN PROCESSING REPLICA FOREIGN UPDATES
IX80800VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311
IX80801VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311
IX80802VARGRAPHIC DOUBLE BYTE LENGTH CAUSES SQLCODE -311
IX80810DB2 UDB RESTART DOES NOT COMPLETE. LOOPING IN INDEX MANAGER.
IX80916SQLCODE804 REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER
IX80917REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804
IX80918REPLICATING A TIMESTAMP COLUMN TO A CHAR (26) COLUMN WITH A NAME 12 CHARACTERS OR GREATER GIVES SQLCODE804 -804
IX81241ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG
IX81262APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS
IX81263APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS
IX81264APPLY FAILED SQLCODE206 WITH COLUMN NAME IN LOWER CASE WHEN RUNNING TWO WAY REPLICATIONS
IX81265ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG
IX81266ASNLOAD ABNORMAL TERMINATION WITH NO ERROR MSG
IX81362RESTORE/MIGRATE OF V2/V4 DB RESULTS IN SQL2038 REASON 5055
IX81497DB2TRC INFO IN SOLARIS SHOWS THE WRONG INFORMATION
IX81647BAD '#PRAGMA OPTIONS' IN SOLARIS SDK HEADER FILES
IX81761DB2AUTOLD (OLD AUTOLOADER) DOES NOT RETURN A NON-ZERO RC TO THE SHELL IF THE AUTOLOADER FAILS.
IX81764DB2ATLD (NEW AUTOLOADER) DOES NOT RETURN A NON-ZERO RETURN CODE IF AUTOLOADER FAILS
IX81766DB2AUTOLD (OLD AUTOLOADER) ISSUES AN SQL6534 WHEN DOING A RESTART OF A FAILED LOAD AND .NETRC FILE DOES NOT EXIST.
IX81782COLD START ENHANCEMENTS FOR SQLCODE964
IX81832-902 ERROR ON SET EVENT MONITOR COMMAND
IX82101UDB CRASHES WITH ADSM V3 DURING ONLINE BACKUP
IX82113SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911
IX82114SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911
IX82115SQLCODE911 - WHEN SQL AFTER STORED PROCEDURE RUNS APPLY HOLDS AN X LOCK ON REGISTER TABLE AND CAPTURE TIMES OUT WITH A SQLCODE911
IX82123WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS
IX82129SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS
IX82134SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS
IX82135SQLCODE911 IF INSERT INTO CRITSEC TABLE FAILS- TABLE ALREADY IN USE APPLY SHOULD RETRY IF INSERT INTO CRITSEC TABLE FAILS
IX82188SUBSEQUENT QUERIES RETURN NO DATA WHEN DEGREE > 1
IX82210CD_OLD_SYNCHPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD
IX82233APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060.
IX82239CD_OLD_SYNCHPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD
IX82240CD_OLD_SYNCHPOINT NOT ALWAYS BEING ADVANCED CORRECTLY FOR MULTIP AGAINST SINGLE SOURCE- CAUSES APPLY FULL REFRESH AND PRUNING BAD
IX82243WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS
IX82245WHEN THERE IS NO BEFORE IMAGE ON CD TABLE & PARTITIONING KEY OPTION IS USED CAPTURE IS DELETING THE WRONG ROWS
IX82289SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER
IX82291SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER
IX82292SQLCODE900 SQLCODE911 SQLCODE904 ASN1010E - WHEN APPLY LOSES CONNECTION TO CONTROL SERVER
IX82295APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060.
IX82296APPLY SHOULD RETRY WHEN CONNECTING TO SOURCE SERVER FAILS WITH SQLCODE1060.
IX82301APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS
IX82302APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS
IX82303APPLY NEEDS TO RESET PRUNCNTL SYNCHPOINT TO NULL IF FULLREFRESH FAILS
IX82334RESTORE RETURNS SQL2038, RC=10746
IX82336ERROR IN SETTING UOW STOP TIMESTAMP IN SNAPSHOTS
IX82547COLD START ENHANCEMENTS FOR SQLCODE964
JR09992DB2DD RESTORE OF ONLINE BACKUP FAILS WITH SQL1261N
JR10324BACKUP OPERATION NOT RELEASING ALL MEMORY ONCE COMPLETED CAUSING RANDOM TRAPS IN DB2 AFTER A BACKUP
JR10975LOAD TABLE FROM AN IXF ENCOUNTERED -3314N
JR11013RESTORE VIA USEREXIT WITH DIFFERENT INSTANCE NAME FAILS
JR11025SQLPRIMARYKEY/SQLFOREIGNKEY LOCKUP SYSTABLES IN AUTOCOMMIT MODE
JR11043CONNECT TO HOST HANGS WHEN USING SYNCPOINT TWOPHASE
JR11049OBSOLETE DBMON TCB'S LEFT AFTER DATABASE PAUSE
JR11073SQL0332N - CODEPAGE CONVERSION BETWEEN 500 AND 1275
JR11075DB2RESDB IS NOT RETURNING THE CORRECT OUTPUT/MESSAGE.
JR11208TRAP AFTER MANY SEQUENTIAL BACKUPS
JR11261DB2 COMMON SERVER - 'INTERSECT ALL' RETURNS TOO MANY ROWS.
JR11296MEMORY LEAK IN JDBC APPLICATION DRIVER WITH SETSTRING/GETSTRING
JR11316THE UNINSTALL ON THE WINDOWS PLATFORMS REMOVES THE REGISTRY ENTR IES OF PRODUCTS THAT WE DID NOT INSTALL LIKE WALLDATA RUMBA
JR11319OS2 V3 ODBC DRIVER NOT SUPPORTED BY V2 DRIVER MANAGER
JR11325THE CLI ARRAY INPUT PROCESSING IS BROKEN WHEN A SQLVAR SPILLS TH E REQUESTER IO BLOCK SIZE.
JR11337SQL3401 SQLGIMP COBOL API DOES NOT IGNORE FILLER BYTES
JR11344CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE
JR11348LOAD OF SOME IXF'S TRAPS
JR11363CURSORHOLD=0 CAUSES SQL30081N AGAINST MVS DATABASE
JR11374SETNULL METHOD HANDLED INCORRECTLY FOR INPUT/OUTPUT PARAMETER
JR11388CLP LOAD REPLACE (CODEPAGE 1252) WITH IXF FILE (CODEPAGE 850) BRINGS DOWN DB2 IN NT
JR11390SQL2015 ERROR IS RETURNED WHEN CUSTOMER TRIES TO ISSUE 'CONTINUE RESTORE' V1 REXX API AFTER 'RESTORE ...' API RETURNS A WARNING.
JR11394SQLPROCEDURE COLUMNS RETURNS COLUMNS IN THE WRONG ORDER
JR11395HIDE EXTENDED FETCH CAPABILITY
JR11417ROW DATA BEING SENT WITH SQL100 CONFUSES DRDA AR WHEN CONNECTING TO DB2 ON OS/2 AS THE DRDA AS
JR11421'REFERENCED MEMORY CANNOT BE READ' ERROR AS A RESULT OF LOOPING ON LOADLIBRARY/FREELIBRARY OF NT KERNEL DLL'S
JR11422DB2STOP HANG AFTER A FORCE APPLICATION ALL WITH ACCESS FEATURE.
JR11428CLI0002W DATA TRUNCATED. SQLSTATE=01004 {SQLDRIVERCONNECT} WHEN CONNECT STRING IS LONGER THAN 254 CHARACTERS
JR11433LOG CORRUPTION WITH '504' MESSAGES IN DB2DIAG.LOG FILE
JR11471SQL_ATTR_CONCURRENCY ATTRIBUTE INCORRECTLY SET TO READONLY FOR A FORWARD_ONLY CURSOR
JR11483DB2 UDB: DB2 OBJECTS DO NOT SHOW UP IN NT PERFORMANCE MONITOR WHEN THE DBM CFG PARAMETER INTRA_PARALLEL IS SET TO YES.
JR11484INTERMITTENT TRAP IN SQLUBINITPROCESS DURING BACKUP
JR11497CONTROL CENTER DISAPPEARS ON CLICKING 'FIND' - ARABIC CODEPAGE
JR11498SQL2503N FROM DB2RESDB RESTORING V1 DB TO V5
JR11502PATCH KEYWORD IN DB2CLI.INI TO OVERRIDE OTHER SETTINGS
JR11503A CONTROL CENTER SCHEDULED BACKUP FAILS WITH SQL2040N-- INVALID DB ALIAS, ON NT.
JR11508DB2CONNECT TO SUPPORT LOCAL DATE
JR11526NLJN DOES NOT PRODUCE OPTIMUM ACCESS PLAN COMPAIRED TO V1
JR11528DISCONNECT AND DETATCH FROM DB2CC DOES NOT DISCONNECT USER PROPERLY.
JR11532CCA DOES NOT ACCEPT UNDERSCORE IN TCP/IP HOSTNAME
JR11535JDBC DRIVER CLI0608E USING GERMAN CODEPAGE
JR11547BACKUP TO ADSM SENDING WRONG OBJNAME.LL FROM UNINITIALIZED SQLU_MEDIA_ENTRY STRUCTURE(POINTED TO BY MEDIA_LIST.TARGET.MEDIA
JR11553FLOATING POINT DATA TYPE RETURNS WRONG VALUE
JR11562V5 CLIENT SHOULD NOT USE DEFERRED PREPARE WHEN GOING TO V2 V2 SERVERS (TURN IT OFF)
JR11568ASN2703E SQLCODE1001E DURING MIGRATION OF CAPTURE FROM V1 TO V5 INCORRECT CONNECT TO LOCATION NOT DB ALIAS DURING BUILDDB
JR11577TRANSLATE FUNCTION RETURNS -901 ON KOREAN CHARS
JR11585PROBLEM WITH LIST APPLICATIONS SHOW DETAIL - CHANGE STATUS TIME
JR11593CLI PARSING PROBLEM ON 'SELECT'. RETURNS -518.
JR11597OPENING DB2 HTML DOCS ON UDB, DEFAULT BROWSER DOES WORK
JR11624SQLROWCOUNT RETURNS INCORRECT VALUE (0) AFTER UPDATE
JR11629PATCH1=1 CAUSES COUNT(DISTINCT COL) TO FAIL.
JR11638CUSTOMER CAN CONNECT FROM A V5 CLIENT TO A V2.1.2 DB WITH NO PROBLEMS. CUST RECEIVES SQL1402 WHEN ATTEMPTING A REMOTE ATTACH.
JR11647MEMORY LEAK IN ODBC/CLI LAYERS IN 9014 FOR NT
JR11651'DB2 PREP <FILE> TARGET IBMCOB' GIVES UNPREDICTABLE RESULTS.
JR11677TRYING TO ADD A NEW SYSTEM IN CC WITH NO INSTANCES CRASHES
JR11680REMOVE 8K LIMIT ON SQL FOR EXPORT COMMAND
JR11722INTERMITTENT DB2 TRAP IN FUNCTION SQLRIRETURNSUBSTRCSOBYTES OR SQLOFMBLK
JR11724SQL30082N RC=0 WHEN USING SECURITY SAME IN DB2 NODE DIRECTORY
JR11726SPORADIC TRAPS IN SQLNQ_TABSEL_OFN_CM
JR11727SQLCODE612 WHEN SUBSCRIBING TO A TABLE WITH A COLUMN NAME GREATER THAN 17 CHARACTERS OR SQLCODE107
JR11728CONTROL CENTER LOCKS UP EXPANDING NODE OR DATABASE OBJECTS ON OS2 WARP SMP MACHINES.
JR11735NETBIOS LOOPS WHEN MAXNBSESSIONS IS REACHED
JR11737DSN FIELD TRUNCATED TO FIRST LETTER IN CLI CONNECTION STRING
JR11741UNABLE TO IMPORT A CLIENT CONFIGURATION WITH CLIENT CONFIGURATIN ASSISTANT (CCA)
JR11760THE UDB CONTROL CENTER HAS NO WAY TO SPECIFY S TO INDICATE THAT SQL BEFORE SHOULD BE RUN AT THE SOURCE SERVER
JR11763ERROR IN CCA WHEN PRESS 'ENTER' INSTEAD OF USING MOUSE
JR11773SQL0437W CAUSES OPEN IN DEFERREDPREPARE TO BE OMITTED
JR11802LARGE SQL STATEMENT USING DEFAULT AGENT_STACK_SZ =16 CAUSES STAC K OVERFLOW EXCEPTION ON NT
JR11810UDB NT TAPE RESTORE RETURNS SQL2530 -- IMAGE CORRUPT.
JR11817AFTER INSERT OF DATA>32700 . THE NEXT INSERT<32700 WILL CAUSE A CRASH.
JR11818DISABLEMULTITHREAD=1 IS NOT READ FROM DB2CLI.INI
JR11820CID INSTALL USING DB2.AUTHENTICATION DOES NOT WORK
JR11821WHEN SQL_ROWSET_SIZE>1, SQLGETDATA REPORTS INVALID CURSOR POS.
JR11824TRAP IN DOSCALL1.DLL DURING CTRL-C
JR11834ASYNCRONOUS READ REQUESTS AND ISSUEING INTERRUPTS.
JR11841SQL_OJ_CAPABILITIES DOES NOT RETURN THE PROPER INFORMATION
JR11861CONTROL CENTER CONNECTS TO CONTROL SERVERS OF SUBSCRIPTION SETS ORIGINATING FROM THE SOURCE DATABASE AND NOT ALL SERVERS
JR11870JOIN OF FULL REFRESH REPL. SOURCE DOESN'T CREATE NEW SOURCE
JR11872CS ISOLATION LEVEL ALLOWS UNCOMMITED READ ACCESS OF A ROW WHICH CONTAINS A W LOCK.
JR11878DB2 UDB USER COUNTS ARE INCORRECTLY MANAGED WHEN THEY EXCEED THE MAXIMUM NUMBER OF LICENSES.
JR11891INTERMITTENT SQL1652 DOING SIMULTANEOUS DB2STARTS.
JR11899CAN'T VIEW OR SET CURRENTSQLID FROM CLIENT SETUP GUI
JR11904CHECK FOR IP ADDRESS BEFORE HOSTNAME FOR WIN95 TCP/IP
JR11905SQLNUMRESULTCOLS RETURNS FUNC SEQ ERR AFTER TIMEOUT
JR11914MIGRATING V211 DATABASE FAILS WHEN TRYING TO CONVERT HIGH2KEY AN D LOW2KEY VALUES
JR11917SQLCOLUMNS COLUMN_DEF RETURNS NULL EVEN WHEN THE COLUMN HAS A DEFAULT VALUE
JR11921\N CHARACTER IMMEDIATELY BEFORE/AFTER SELECT GETS SQL0518
JR11928DB2 CONNECT HAS INTERMITENT PROBLEM LOGGED IN THE DB2DIAG.LOG: GATEWAY_DRDA_AR SQLJDRD1 PROBE:11, DIAGDATA = 34FF FFF
JR11940SQLCODE301 ON APPLY STARTUP
JR11952THIN INSTALL FROM WIN NT DOES NOT INSTALL ODBC FILES CORRECTLY
JR11953ARRAY INSERT TRAPS.
JR11956TRAP IN DB2CLI.DLL IN CLIENT WHEN FORCE APPLICATION IN SERVER
JR11958CONTROL CENTER SPLITS F Q HOSTNAME INTO TWO. FIRST PART BECOMES THE HOSTNAME, THE SECOND BECOMES THE REMOTE INSTANCE NAME.
JR11959SQL0805N ON AN SQLEXECUTE() WHEN DBM CFG ASLHEAPSZ 1
JR11972JDBC METADATA USING GETTABLES RETURN NULLPOINTEREXCEPTION
JR11981RETRIEVING DECIMAL DATA INTO A DOUBLE WITH STATIC CURSOR DOES NOT RETURN DATA
JR11990JOURNAL ALERT DATE DOES NOT SORT PROPERLY
JR11999WHEN NT TIME IS SET TO SOMETHING OTHER THAT EST, THE EVENT MONITOR START TIME (THROUGH EVENT ANALYZER) IS INCORRECT.
JR12000MULTITHREADED APPLICATIONS TRAP IN UDB
JR12005INTERMITTENT TRAP IN SQLODUMPEDU
JR12007SQLCODE100 UDB CONTROL CENTER DOES NOT INITIALIZE THE PHYS_ CHANGE_OWNER AND PHYS_CHANGE_TABLE VALUES WHEN SOURCE IS CCD
JR12010LOAD SCRIPT RUN FROM SCRIPT CENTER CAUSES GPF IN JOURNAL WHEN VIEWING THE JOB HISTORY FILE.
JR12021TRAP IN TCP32.DLL IF DB2COMM=TCPIP AND USING TWO PHASE CONNECT
JR12032A BUG CAUSES SQL1109 WHEN USING SCHEMA IN CALL STMT IN JAVA STORT PROCEDURE (INTEL ONLY)
JR12035OPTIONS DROP AND REMOVE ARE TRANSLATED WRONG IN SPANISH CC
JR12038SQL4414 IN THE CC FOR LOCAL ADMIN FUNCTIONS IF DB2SYSTEM CONTAINS A SPACE CHARACTER
JR12040TRAP IN SQLNO_FINAL_PHASE WHEN OPTIMIZER IS CREATING VERY LARGE (DEEP) ACCESS PLANS.
JR12067PRE-UDB CLIENT TO UDB SERV, HOST VAR NAME UNIQUE TO 18TH CHAR IF 2 HV ARE SAME TO 18 CHARS, THEY MAY TREATED AS SAME VARIABLE
JR12070DB2 UDB MEMORY LEAK AFTER ATTEMPTS TO CONNECT TO DATABASE FAIL. THE CONNECT FAILURE WAS AN SQL0290 ERROR IN THIS CASE.
JR12072LEFT OUTER JOIN PROVIDES INCORRECT RESULT SET.
JR12093FILTER FACTOR OFF AND NO FREQUENCY STATS ON VARCHAR COLUMNS
JR12130AT CS A ROW LOCK REMAINS IF THE ACCESS PLAN PREFETCHES RIDS
JR12143MEMORY LEAK IN NT AFTER DISCONNECT
JR12167A LONG WHERE IN CLAUSE CAUSES AN SQL0101--STATEMENT TOO LONG IN NT OR -901 -- NEGATIVE COST IN PLAN ON AIX UDB
JR12169MIGRATION OF THE NODE DIRECTORY FAILS
JR12172CONTROL CENTER ALLOWS UPDATE OF SUBSCRIPTION STATUS 2
JR12219CAE DOES NOT CONTAIN ALL THE CONVERSION FILES NEEDED BY JDBC
JR12220ABILITY TO USE CHARACTER DELIMITING DURING LOAD
JR12221OPTIMIZER BUG FOR HOST VARIABLE FILTER FACTORS AND RUNSTATS
JR12227<CR><LF> RIGHT BEFORE SELECT CAUSE SQLEXECDIRECT TO FAIL.
JR12240DEFECT 83823 BREAKS NT AND OS/2 STORED PROCEDURES
JR12247CCA ONLY SHOWS 8 CHAR SCHEMA FROM AS/400.
JR12252CRASH RECOVERY HANGS
JR12267INSTALL ADDS DEFALT_LOCAL_LU_ALIAS TO THE CS NDF FILE.
JR12273THE CONTROL CENTER IS NOT CHOOSING THE CORRECT ' MASTER ' TABLE FOR THE JOIN - VIEW REPLICA SCENARIO
JR12282MIGRATION FROM DB2 V1 TO V5 FAILED DUE TO NULL VALUES IN COLUMN 'STANDARD_LEVEL' OF TABLE SYSPLAN.
JR12345SMALL TALK CANNOT CALL SQLURST, ONLY SQLURTS@92, SAME FOR BACKUP API.
JR12362WHEN CALLING THE SQLE_DEACTIVATE_DB_API DOES NOT POPULATE SQLWAR N FILED IN SQLCA PROPERLY.