invispix 10x10

DB2 - Solutions to problems

36783801-107x160Here you can find, daily actualized, the list of reported problems assorted after APAR-Numbers.

Due to restrictions of the IBM APAR-Numbers (IBM DB2 Problem-Numbers) which are branded with a lock-symbol can only be seen by registered users.

Move your mouse over an APAR-Number to show the bug description in a Tooltip.

If you click on the number, the complete description will appear in a new tab.

For full text search for bug descriptions click here

Problems reported sorted by APAR number
IT25941INDEX KEY NOT FOUND ERROR MIGHT INCORRECTLY BE REPORTED BY THE SERVER
IT25927PADIAGLOGCOLL::PARSEFILTERPARMS SHOWS UP IN DB2DIAG.LOG FREQUENTLY.
IT25915CONNECTION TIMEOUT COULD OCCUR WHEN ConnectionTimeout IS SET TO 10 SEC OR LESS.
IT25908PL/SQL PACKAGE WITH AN INITIALIZATION SECTION CAN RETURN -301 ERROR WHEN CALLED VIA JAVA OR CLPPLUS
IT25907-P <PORT> PARAMETER IS BEING IGNORED BY DB2ICRT
IT25880GATEWAY CONCENTRATOR CAN CAUSE JDBC DES CLIENTS TO FAIL TO AUTHENTICATE WHEN JDBC AES CLIENTS ARE ALSO BEING USED.
IT25879GATEWAY CONCENTRATOR CAN CAUSE JDBC DES CLIENTS TO FAIL TO AUTHENTICATE WHEN JDBC AES CLIENTS ARE ALSO BEING USED.
IT25869HADR GRACEFUL TAKEOVER ON PURESCALE COULD FAIL WITH SQL1770N RC7WHILE OLD PRIMARY DATABASE IS SWITCHING ROLE.
IT25864GRANT / REVOKE PRIVILEGE DID NOT TAKE EFFECT IN CATALOG CACHE IMMEDIATELY ON HADR STANDBY SIDE
IT25857FODC_TRAP IN RESETRESVLOGSPACEIFSTATEMENTCHANGED
IT25849GRANT / REVOKE PRIVILEGE DID NOT TAKE EFFECT IN CATALOG CACHE IMMEDIATELY ON HADR STANDBY SIDE
IT25841DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CSES AND CORRELATED SUB-QUERIES
IT25840POSSIBLE TIMING ISSUE BETWEEN APPLICATIONS DISASSOCIATING FROM ADATABASE MAY LEAD TO A CRASH.
IT25827FODC PANIC DUE TO MEMORY CORRUPTION CAUSED BY INVALID LENGTH ASSIGNMENT
IT25811INDEX KEY NOT FOUND ERROR MIGHT INCORRECTLY BE REPORTED BY THE SERVER
IT25784DB2 MAY CRASH DURING A "REORG RECLAIM EXTENT" ON AN ITC TABLE
IT25783-901 ERROR WITH TEXT "WITH HOLD BUT USAGE LOCK ARGUMENT NULL" REPORTED BY SQLRLC_REQUEST_ULOCK() AS CALLED BY SQLRLC_FED_FETCH()
IT25781DB2 MAY ABEND WHEN COMPILING A QUERY CONTAINING A SEMI-JOIN
IT25774IMPROPER WORNING MESSAGE "ACCESS NOT ALLOWED. TBLSPC RF IN PROGRESS." IS LOGGED DURING "ROLLFORWARD" COMMAND WITH "QUERY STATUS"
IT25770INSTANCE CRASHES DURING CLEANUP A VARIATION FROM THE PACKAGE CACHE
IT25769DB2XPRT TOOL IS FAILING TO FORMAT WINDOWS TRAP FILES IN SPECIAL BUILDS.
IT25767DB2TRC & DB2HAICU SEGMENTATION FAULT
IT25732DB2 IN DPF MAY HANG DURING IMPLICIT INDEX REBUILD ON COLUMNAR TABLE IF MORE THAN ONE INDEX IS RECREATED
IT25707DB2 SERVER TERMINATES ABNORMALLY DURING QUERY COMPILATION
IT25706INCORRECT RESULTS COULD HAPPEN WITH OUTER JOINS AND EXPRESSIONS IN JOIN COLUMNS
IT25680"ROLLFORWARD LAST COMMITTED TIMESTAMP" VALUE IS NOT SHOWN IN A DATABASE SNAPSHOT ISSUED AGAINST A HADR STANDBY DATABASE
IT25654DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSION,UNION AND UDF
IT25647SQL0901N "DESCRIBE LEVEL (0X3) SQLDD LEVEL (0X2)" WHEN USING DB2REPLICATION CENTER TO CREATE FEDERATED CONNECTION
IT25645DB2LOOK WITH -CT DOES NOT GENERATE SET SCHEMA DDL'S BEFORE CREATE MQT/SUMMARY TABLES WITH IMPLICIT SCHEMAS
IT25628WIN32 ONLY: DB2LEVEL GIVES SQL1022C IF INSTANCE NAME IS LONGER THAN 7 BYTES.
IT25599SQL0407N MIGHT OCCUR WHEN RUNNING QUERIES CONTAIN SCALAR SUB-QUERIES AND COMMON SUB-EXPRESSIONS
IT25589LIST HISTORY COMMAND FAILS WITH DB21018E ERROR WHEN THE HISTORY FILE CONTAINS A DROPPED TABLE EVENT WITH LONGER TABLE NAME.
IT25582SQL0407N MIGHT OCCUR WHEN RUNNING QUERIES CONTAIN SCALAR SUB-QUERIES AND COMMENT SUB-EXPRESSIONS
IT25578SQLKD_SYSERR MAPPED TO -902 BY RUNTIME, CAUSING DATABASE MARKED BAD.
IT25560Statistics event monitor traps when event monitor generation overlaps activation of the statistics event monitor.
IT25553CREATE PROCEDURE MAY CAUSE DB2 TO TERMINATE ABNORMALLY IN SQLNQ_SEM_LIMIT
IT25552UPDATING THE AUDIT DATA PATH OR THE INSTANCE DIAGPATH MAY FAIL IN AN AUTOMATED HADR ENVIRONMENT
IT25536SQLKD_SYSERR MAPPED TO -902 BY RUNTIME, CAUSING DATABASE MARKED BAD.
IT25527ADMIN_MOVE_TABLE: INDEX IS NOT GENERATED IF TARGET TABLE IS COLUMNAR
IT25525DB2 MAY TERMINATE ABNORMALLY DURING COMPILATION OF A QUERY WITH OPTIMIZER GUIDELINE
IT25522ERRORS WITH XML PROCESSING - XDBADVDOCHANDLER__ERROR, PROBE:1655
IT25519DB2INSTANCE -LIST COMMAND CAN FAIL WITH COREDUMP IF A ROUTING IS MISSING.
IT25516TRAP IN SQLRA_CLOSE_SECTIONS_ON_COMMIT IN DPF ENVIRONMENT
IT25502YOU MAY ENCOUNTER A FODC PANIC DURING DROP TABLE COMMAND in DPF.
IT25495DB2 MAY RETURN SQL0901N ERROR WHEN COMPILING A QUERY CONTAINING A GROUP BY AND OLAP FUNCTIONS
IT25493DB2 STANDBY CRASH ON SQLOGETMEMPOOLSTATSUNLATCHED WHEN DB2_HADR_ROS IS ENABLED
IT25481SQL0901N ERROR MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING NOT EXISTS SUB-QUERIES
IT25478CLP MIGHT NOT REMOVE 0x0A BYTE FROM THE STATEMENTS IF THY ARE EXECUTED FROM SHELL SCRIPT.
IT25468THE DB2MOVE COMMAND DOES NOT EXPORT PARTITIONED TABLES WHEN USED WITH OPTION: TS
IT25464DB2ROCM CONSTANTLY DUMP *SQLHA.EVENTS.BIN IF MEMBER FAILS TO START.
IT25455DB2 MAY TERMINATE ABNORMALLY DURING COMPILATION OF A QUERY WITH OPTIMIZER GUIDELINE
IT25435FLUSH PACKAGE CACHE MAY NOT REMOVE ALL ENTRIES
IT25431YOU MAY ENCOUNTER A FODC PANIC DURING DROP TABLE COMMAND in DPF.
IT25400DB2PD -HA CAN OUTPUT "COULD NOT RETRIEVE NUMBER OF RESOURCE GROUPS IN THE CLUSTER"
IT25396PURESCALE HADR STANDBY MIGHT CRASH WITH SQLO_XLATCH::RELEASECONFLICT: "UNLOCKING AN UNLATCHED LOCK"
IT25391PURESCALE HADR STANDBY MIGHT CRASH WITH SQLO_XLATCH::RELEASECONFLICT: "UNLOCKING AN UNLATCHED LOCK"
IT25390DB2 INSPECT MIGHT INCORRECTLY REPORT OUT OF RANGE ERRORS FOR BLUTABLES
IT25377GRANT STATEMENT IS MISSING FROM DB2LOOK OUTPUT.
IT25373CF MEMBER COMMUNICATION TIMEOUT LEADS TO CONNECTION RESET IMPACTING PERFORMANCE
IT25370POTENTIAL ACCESS VIOLATION IN BANKUNPACKER GETCODES
IT25368TO_NCHAR() RETURNS WRONG RESULT WITH UNION
IT25363SYSPROC.MON_GET_CONNECTION DOES NOT DIFFERENTIATE BETWEEN SECUREAND NON-SECURE CONNECTIONS TO A DATABASE.
IT25359DB2 INSPECT MIGHT INCORRECTLY REPORT OUT OF RANGE ERRORS FOR BLUTABLES
IT25342ADMIN_MOVE_TABLE FORCE_ALL DOES NOT FORCE OFF APPLICATIONS HOLDING OTHER CONFLICTING LOCKS THAN TABLE LOCKS
IT25338DB2PD -HA CAN OUTPUT "COULD NOT RETRIEVE NUMBER OF RESOURCE GROUPS IN THE CLUSTER"
IT25336INFORMATIONAL: CUSTOMERS WILL NEED A 11.1 SPECIAL BUILD TO UPGRADE FROM 10.5FP10 to 11.1.2.2 or 11.1.3.3
IT25333PERFORMANCE MAY BE AFFECTED BY DYNAMIC SQL CACHE NON REUSE
IT25326UNICODE DATA WHICH BUILT WITH SUPPLEMENTARY CHARACTERS FAILS TO CONVERT TO 1392 CODESET
IT25322db2ckupgrade fails with SQL10007N Message "5556" could not be retrieved. Reason code: "4" when upgrading from v10.5fp10 to v11.1
IT25314UNICODE DATA WHICH BUILT WITH SUPPLEMENTARY CHARACTERS FAILS TO CONVERT TO 1392 CODESET
IT25305SQL0332N WITH NVL2 FUNCTION AND VARCHAR FOR BIT DATA AND GRAPHIC
IT25302POTENTIALLY BAD PERFORMANCE WHEN USING PARAMETER MARKERS IN QUERIES CONTAINING JOINS
IT25300COLUMN BASED QUERY MAY HANG IF THE QUERY CONTAINS AGGREGATION FUNCTIONS AND DATA EXCEPTION OCCURS
IT25285DB2 PURESCALE USING CF_TRANSPORT_METHOD TCP MIGHT TRIGGER A FODC PANIC WITH "SAL: PAGE NAME MISMATCH IN RETRIEVED PAGE!"
IT25281SLOW INSERT PERFORMANCE WHEN USING MON_OBJ_METRICS EXTENDED
IT25271CLI/ODBC CONNECTION CRASHES WHEN CONNECTING TO THE HA INSTANCE OR PURESCALE CLUSTER OF DB2 ON CLOUD DUE TO LARGE HOSTNAME.
IT25267CALLING STORED PROCEDURE { ? = CALL SOMESPNAME( ?, ?, ?, ?, ? ) } RESULTS IN APPLICATION CRASH 0XC0000005
IT25229DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING REDUNDANT PREDICATE
IT25228DB2 CLIENT CACHE FILE SRVLST.XML SIZE GROWS BY 6 BYTES EVERY TIME WHEN CONNECT TO PURESCALE.
IT25195QUERIES CONTAINING OUTER JOINS AND GROUP BY CLAUSES MIGHT PRODUCE WRONG RESULTS
IT25194TO_NCHAR() RETURNS WRONG RESULT WITH UNION
IT25185DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING REDUNDANT PREDICATE
IT25183LOG_TO_FILE OPTION OF EVMON_FORMAT_UE_TO_XML TABLE FUNCTION CANNOT WRITE OUT XML DOCUMENT MORE THAN 100MB
IT25147QUERIES CONTAINING OUTER JOINS AND GROUP BY CLAUSES MIGHT PRODUCE WRONG RESULTS
IT25136QUERY EXECUTION FAILS WITH -901 "SQLRIDERIVEDUMMY FUNCTION SHOULD NEVER BE ACTUALLY CALLED"
IT25135BACKUP V9.7 DB FROM V11.1 CLIENT MIGHT FAIL WITH SQL1651N
IT25121"RECOVER DB" COMMAND IS NOT PICKING UP CORRECT DB2 BACKUP IMAGE FOR RECOVERY TILL POINT IN TIME.
IT25100MERGE BACKUP - PROGRAM FAILURE DURING THE INVENTORY PHASE
IT25072INCORRECT ROW NUMBER FOR ERROR/WARNINGS IN COMPOUND SQL STATEMENTS(statement chaining) IN .NET APPLICATIONS:
IT25070ADMIN_GET_TAB_INFO WAITING ON REORG TABLE RECLAIM EXTENTS ON ITCTABLE
IT25066SLOW MEMORY ALLOCATIONS OR POSSIBLE SEVERE DEGRADATION DURING OOM HANDLING DUE TO COALESCE MEMORY CHECK
IT25058FEDERATION QUERY MAY GET SQL0302N DUE TO STRING TRUNCATION WHEN A HOST VARIABLE IS USED FOR A REMOTE COLUMN IN DIFFERENT CODEPAG
IT25046RESTORE WITH "SHOW MASTER KEY DETAILS" DID NOT SHOW ALL THE KEY LABEL
IT25044DB2 SERVER MAY CRASH WHEN RUNNING LOOSELY COUPLED XA TRANSACTIONor using MSDTC AS TRANSACTION MANAGER
IT25038GBP CLEANUP CAN BE SLOW ON A LARGE GBP DURING MEMBER CRASH RECOVERY
IT25035DB2 MAY REPORT A 'SEVERE' LEVEL MESSAGE WITHIN THE DB2OPTSTATS LOG WHEN COLLECTING RUNSTATS ON A TABLE IN LOAD PENDING STATE
IT25029RESTORE FROM INCREMENTAL BACKUP WITH MULTIPLE STREAMS - DB2 MAY ERROR SQL2032N THE "BUFFER_NUM" PARAMETER IS NOT VALID. SQLSTATE
IT25028RESTORE FROM INCREMENTAL BACKUP WITH MULTIPLE STREAMS - DB2 MAY ERROR SQL2032N THE "BUFFER_NUM" PARAMETER IS NOT VALID. SQLSTATE
IT25025DB2 CAN TRAP WHEN USING DBMS_SQL.PARSE
IT25024RESTORE FROM INCREMENTAL BACKUP WITH MULTIPLE STREAMS - DB2 MAY ERROR SQL2032N THE "BUFFER_NUM" PARAMETER IS NOT VALID. SQLSTATE
IT25023DB2 MAY REPORT A 'SEVERE' LEVEL MESSAGE WITHIN THE DB2OPTSTATS LOG WHEN COLLECTING RUNSTATS ON A TABLE IN LOAD PENDING STATE
IT25021ADMIN_GET_TAB_INFO WAITING ON REORG TABLE RECLAIM EXTENTS ON ITCTABLE
IT24990SQL0811N ERROR MIGHT OCCUR WHEN RUNNING UPDATE STATEMENTS CONTAINING SCALAR SUB-QUERIES
IT24989SQL0420N ERROR MIGHT OCCUR WHEN RUNNING UPDATE STATEMENTS CONTAINING SCALAR SUB-QUERIES
IT24971/DB2.TMP.<PID> DIRECTORY REMAINS AFTER FIXPACK APPLICATION
IT24968CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
IT24956SQL0332N AFTER ALTERING COLUMN LENGTH
IT24954SLOW INSERT PERFORMANCE IN PURESCALE BECAUSE UNCOMMITTED DELETED SLOTS AREN'T REUSED CORRECTLY
IT24944DATABASE MARKED BAD (SQLO_INV_PARM) ON INTERRUPT IN REGULAR EXPRESSION PROCESSING
IT24919CLP CRASHES WITH DB21018E
IT24911CAPTURE ADDITIONAL DIAGNOSTIC INFORMATION IN BLU MEMORY MANAGEMENT
IT24895CAPTURE ADDITIONAL DIAGNOSTIC INFORMATION IN BLU MEMORY MANAGEMENT
IT24892APPLICATIONS ISSUING ALTER TABLE ADD/ATTACH/DROP/DETACH MAY DEADLOCK WITH APPLICATIONS REBINDING PACKAGES
IT24868POSSIBLE SIGSEGV IN SQLDRETURNDATA WITH RANGE CLUSTERED TABLES
IT24866IN A HADR HA(TSA) ENVIRONMENT, IN THE EVENT OF A PRIMARY SERVER FAILURE, THE STANDBY MAY NOT BE REINTEGRATED ON INSTANCE STARTUP
IT24863INCORRECT LOG COMPENSATION BEHAVIOUR CAN LEAD TO DATABASE CORRUPTION WHEN USING LOAD ON A TABLE WITH AN XML COLUMN
IT24847POSSIBLE SIGSEGV IN SQLDRETURNDATA WITH RANGE CLUSTERED TABLES
IT24841DB2 MIGHT TRAP WHEN EXECUTING COMPLEX QUERIES CONTAINING CSES
IT24840SECURITY: UPDATE IBM SDK, JAVA TECHNOLOGY EDITION QUARTERLY CPU - JAN 2018
IT24830STEPPING TQS MAY EXPERIENCE A HANG IN SITUATIONS WHEN WE ARE TRYING TO STOP TQ DRAINING AS A PERFORMANCE OPTIMIZATION.
IT24829LONG DURATION OF HOLDING OF THE Statement ANCHOR LATCH CAUSED LATCH CONTENTION
IT24828IUD OPERATIONS AGAINST COLUMNAR TABLES COULD ENCOUNTER AN ABEND WHEN PLAN IS COMPLEX AND NLJN IS PRESENT ABOVE IUD OPERATION
IT24827SQL1007N ERROR IN FINDING PAGES FOR AN OBJECT IN A TABLE SPACE
IT24826SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
IT24825SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
IT24824SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
IT24823SECURITY: FORMAT STRING VULNERABILITIES EXISTS IN DB2SUPP
IT24821WITH UCA COLLATION RUNSTATS CAN CAUSE THE INSTANCE TO TRAP
IT24820WITH UCA COLLATION RUNSTATS CAN CAUSE THE INSTANCE TO TRAP
IT24811STEPPING TQS MAY EXPERIENCE A HANG IN SITUATIONS WHEN WE ARE TRYING TO STOP TQ DRAINING AS A PERFORMANCE OPTIMIZATION.
IT24809DBMS_SQL.OPEN_CURSOR CAUSES MEMORY LEAK IN KRCBH POOL
IT24808INSTANCE MAY CRASH WHEN EXTERNAL CODEPAGE CONVERSION TABLES ARE IN USE ON DB2 SERVER
IT24804SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT24803SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT24802SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT24799SECURITY: MULTIPLE VULNERABILITIES IN DB2EXMIG AND DB2EXFMT
IT24788ATTEMPTING TO MOVE HADR DATABASES VIA THE DB2HAICU MAINTENANCE MENU OPTION MAY FAIL
IT24783LOAD REPLACE RESETDICTIONARYONLY INCORRECTLY REPORT ERRORS IN DB2DIAG.LOG (SQLBSTATEGETCHECK)
IT24765TIMING ISSUE IN PACKAGE CACHE WORKSPACE MAY CAUSE PANIC
IT24764DEADLOCK ON SYSIBM.SYSTABLES WHEN RUNNING LOAD ON DPF
IT24761SQL20478N REASON CODE 30 MAY OCCUR WHEN EXECUTING A DATA-CHANGE-STATEMENT
IT24752LOAD UTILITY MAY FILL DB2DIAG.LOG WHEN LOAD HITS PROBLEM DURING INITIALIZATION PHASE.
IT24750SQL0901 MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING CASE SUB-EXPRESSIONS
IT24749DB2 MAY CRASH IN SAL FLIGHT RECORDER CODE
IT24744CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
IT24743CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN ENCRYPTED DATABASE
IT24740POSSIBLE SEGV DURING CONNECTION WITH CLI IF MULTI THREADED PROGRAM AND XML SRVRLST.XML FILE EXISTS
IT24739DB2 CRASH ON -901 IN SQLRA_CACHE_FILL_SEC WITH "SECTION LENGTH MISMATCH"
IT24737AUTOMATIC ONLINE REORG FAILS WITH SQL0270N BECAUSE THE CLAUSE ALLOW WRITE ACCESS IS GENERATED AND NOT SUPPORTED ON MDC TABLE. (R
IT24735Member failback may fail with SQL1072C after rmcd process failure on member?s home host.
IT24727SQL4917N MAY BE THROWN WHEN A COBOL APPLICATION IS RUN ON A 64 BIT MACHINE
IT24722DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONSAND SCALAR AGGREGATIONS
IT24712AFTER RENAMING A TABLE A SUBSEQUENT SELECT MAY INCORRECTLY RETURN SQL0551
IT24710AFTER RENAMING A TABLE A SUBSEQUENT SELECT MAY INCORRECTLY RETURN SQL0551
IT24702THE EXPLANATION FOR SQL0338N NEEDS AN UPDATE AFTER THE ENHANCEMENT MADE SINCE 10.1 TO ALLOW SUBQUERIES IN AN ON CLAUSE
IT24696The db2support tool may remove database files, resulting in a database corruption or an instance-wide outage
IT24688QUERIES USING THE SAME UNNEST IN DIFFERENT PARTS OF THE PLAN COULD RETURN WRONG RESULTS FOR SOME COLUMNS
IT24687QUERIES USING THE SAME UNNEST IN DIFFERENT PARTS OF THE PLAN COULD RETURN WRONG RESULTS FOR SOME COLUMNS
IT24668HADR STANDBY LOG REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO BAD PAGE WHILE DOING AN INSERT
IT24665SCAN OF COLUMNAR TABLE WITH SYNOPSIS COULD PRODUCE DUPLICATE ROWS IF UNCOMMITTED INSERTS OR UPDATES WERE DONE
IT24663HADR STANDBY LOG REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO BAD PAGE WHILE DOING AN INSERT
IT24657MEMORY CORRUPTION DURING XA PROCESSING ON FEDERATED OBJECT
IT24656DB2PD CONTINUES CHECKING USER AUTHORITIES INSTEAD STOPPING AFTERCONFIRMING USER HAS THE REQUIRED AUTHORITY.
IT24655POSSIBLE TRAP / MEMORY CORRUPTION AFTER CONNECT RESET PERFORMED ON A LOAD
IT24652INDEX ACCESS MAY NOT BE CHOSEN FOR SUBPLAN WITH INSERT WITH COLUMN ORGANIZED TABLES
IT24645SECURITY: DB2CONVERT IS VULNERABLE TO BUFFER OVERFLOW
IT24642SECURITY: DB2CONVERT IS VULNERABLE TO BUFFER OVERFLOW
IT24641IN A AIX SPECIFIC PURESCALE ENV, DB2START MAY HIT SQL1659N DUE TO STATIC ROUTES NOT BEING CONFIGURED PROPERLY.
IT24632DB2 SERVER TERMINATES ABNORMALLY COMPILING A MERGE STATEMENT
IT24631DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING CORRELATED PREDICATES
IT24630DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING CORRELATED PREDICATES
IT24624INSTANCE MAY CRASH IN SQLRH_FREE_HANDLE
IT24609DB2EXPLN SEGV AND CRASHES THE SERVER
IT24602CREATING NEW CONNECTIONS BETWEEN MEMBER AND CACHING FACILITY ON PURESCALE CAN FAIL WITH A TIMEOUT ON OFED ROCE STACK
IT24592EXCEPTION MESSAGES THROWN BY .NET DRIVER ARE INCOMPLETE AND WRONG.
IT24585INSERTS TO A PAGE MAY NOT RE-USE RESERVED SPACE ON A PAGE PROPERLY WHICH CAUSES NEW PAGE ALLOCATION AND OVERFLOW RECORDS
IT24584INSERTS TO A PAGE MAY NOT RE-USE RESERVED SPACE ON A PAGE PROPERLY WHICH CAUSES NEW PAGE ALLOCATION AND OVERFLOW RECORDS
IT24578INSTALLATION OF DB2 V11.1.3.3 ON SOLARIS RAISES UNKNOWN KEYWORD "TSA_GPFS_ONLY"
IT24571IF THE LINUX ASLR FEATURE IS ENABLED, SEVERE DB2DIAG MESSAGES WITH TAG SQLO_ADDR_CONFLICT MAY BE INFREQUENTLY OBSERVED
IT24568DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING COMMON-TABLE-EXPRESSIONS
IT24567DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING COMMON-TABLE-EXPRESSIONS
IT24561ALTER TABLE ALTER COLUMN SET DEFAULT 'STRING LITERAL' ALLOWS VALUE > 254 BYTES.
IT24558ERROR SQL0102N RETURNED WHEN DB CFG VARCHAR2=ON, STMT_CONC=LITERALS AND STRING_UNITS=CODEUNITS32
IT24545DB2LOOK HAS DUPLICATE/INCORRECT COLUMN IN REFERENCES CLAUSE OF FOREIGN KEY DDL.
IT24539INSTANCE MAY CRASH IN SQLRH_FREE_HANDLE
IT24531AVOIDANCE COMPILATION AND PACKAGE CACHE FOR SET QUERY BYPASS STATEMENTS
IT24525SQL0332N AFTER ALTERING COLUMN LENGTH
IT24524RARE TIMING ISSUE MAY CAUSE INSTANCE CRASH ON BACKUP COMPLETION
IT24523DB2 PANICS DURING PARALLEL INSERT BRINGS THE INSTANCE DOWN
IT24522CAN NOT STOP ROLLFORWARD WHEN HITTING LOG CORRUPTION (PARTIAL RECORD AT THE END OF A TRUNCATED LOG FILE)
IT24520HADR LOG GAP ON AUXILARY STANDBY INCREASES SIGNFICANTLY WHILE ONLINE BACKUP IS RUNNING.
IT24519ROLLFORWARD ASKS FOR MORE LOGS THAT ARE NOT INCLUDED IN THE ONLINE BACKUP IMAGE
IT24518MANY DIFFERENT SIZED LOGS IN LOG DIRECTORY
IT24515DB2 ENGINE MIGHT HANG WHEN UPDATING STATISTICS FOR INDEXES ON XML COLUMNS
IT24513ADMIN_MOVE_TABLE: INTRODUCE OPTIONS TO PREVENT CREATION OF NON-UNIQUE INDEXES AND MODSTATE INDEX ON TARGET TABLE
IT24508DB2 ENGINE MIGHT HANG WHEN UPDATING STATISTICS FOR INDEXES ON XML COLUMNS
IT24497LOG_TO_FILE OPTION OF EVMON_FORMAT_UE_TO_XML TABLE FUNCTION CANNOT WRITE OUT XML DOCUMENT MORE THAN 100MB
IT24494OVERLAPS FUNCTION EXECUTED AGAINST COLUMNAR ORGANIZED TABLE COULD RETURN WRONG RESULTS IF INPUT COLUMNS HAVE NULL VALUES
IT24493LOCK EXCLUSIVE MDC TABLE WITH LOCKSIZE SET TO BLOCKINSERT, INSERTING ROWS WILL RESULT IN ADDITIONAL LOCKS BEING ACQUIRED.
IT24478SECURITY: BUFFER OVERFLOW IN DB2LICM
IT24477SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH
IT24476SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH
IT24475SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH
IT24474SECURITY: PRIVILEGE ESCALATION VIA UNTRUSTED LIBRARY PATH
IT24473SECURITY: BUFFER OVERFLOW IN DB2LICM
IT24466SECURITY: RAH.EXE BUFFER OVERFLOW
IT24465SECURITY: RAH.EXE BUFFER OVERFLOW
IT24464SECURITY: RAH.EXE BUFFER OVERFLOW
IT24463SECURITY: PRIVELEGE ESCALATION VULNERABILIY IN THE DB2 DAS COMPONENT ON WINDOWS
IT24462SECURITY: PRIVELEGE ESCALATION VULNERABILIY IN THE DB2 DAS COMPONENT ON WINDOWS
IT24461SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN THE DB2 DAS COMPONENT ON WINDOWS
IT24456LOCK EXCLUSIVE MDC TABLE WITH LOCKSIZE SET TO BLOCKINSERT, INSERTING ROWS WILL RESULT IN ADDITIONAL LOCKS BEING ACQUIRED.
IT24450DB2 INSTANCE MIGHT PANIC AFTER FORCEDBSHUTDOWN
IT24447AFTER DB2 RECYCLE, DB2 STARTED ARCHIVING OLD LOG FILES CAUSING ACTIVE LOG FILESYSTEM QUICK GROWTH.
IT24445IF ONE OF THE PORTS IS DOWN ON A MEMBER, EVEN IF THERE IS ANOTHER FUNCTIONING PORT, DB2START MAY TIMEOUT.
IT24439SQL0440N ERROR CAN OCCUR WHEN QUERIES CONTAIN OUTER JOINS AND INNER JOINS
IT24434CREATE NICKNAME AGAINST AN ORACLE TABLE MAY FAIL WITH ERROR SQL0802N
IT24425INDEX CORRUPTION MIGHT BE INTRODUCED ON A COMPRESSED INDEX DURING RECOVERY PROCESSING
IT24418SQL0901 SQLRI_MAX SANITY CHECK FAILED
IT24417PREREQCHECK FAILS DB2ICRT ON AIX 7.2 TL01 SP3
IT24407TRAP IN SQLBPFADDTOQ WHEN RUNNING A QUERY INVOLVING A FETCH-IXSCAN PLAN AGAINST A BLU TABLE.
IT24403THE LIMITATION CONCERNING DB2 NON-DEFAULT STORAGE GROUPS AND RESTORE IS NOT DOCUMENTED
IT24390THE "DB2HAICU -DELETE" COMMAND MAY FAIL TO DELETE RESOURCES FOR THE INSTANCE IF A RESOURCE WAS INCOMPLETELY CREATED
IT24382DB2 SERVER MAY REPORT -901 WITH ERROR MESSAGE "PARENT OBJECT SHOULD NOT HAVE A SWIZZLE DEPENDENCY"
IT24381DB2 SERVER MAY REPORT -901 WITH ERROR MESSAGE "PARENT OBJECT SHOULD NOT HAVE A SWIZZLE DEPENDENCY"
IT24361DB2 V11.1 DB2DIAG.LOG MESSAGE WITH ERROR "FILE NOT FOUND" IN "SQLPGOPENLOGEXTENT, PROBE:10000" MAY BE MISLEADING
IT24355DB2ROCM CONSTANTLY CREATES DUMP FILES WHEN THE MEMBER IS STOPPED
IT24347INDEX CORRUPTION MIGHT BE INTRODUCED ON A COMPRESSED INDEX DURING RECOVERY PROCESSING
IT24311SECURITY: RAH.EXE BUFFER OVERFLOW
IT24301QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP"
IT24299DB2 CRASH IN DPF + SMP ENVIRONMENT AFTER INTERNAL INTERRUPT (SQL0952N)
IT24295RESTART OF A PARTITIONED DATABASE FAILS WITH SQL10003C ON NON-CATALOG PARTITION
IT24283SECURITY: PRIVILEGE ESCALATION VULNERABILITY IN THE DB2 DAS COMPONENT ON WINDOWS
IT24280GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSINGCLAUSE MAY RETURN -901
IT24278GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSINGCLAUSE MAY RETURN -901 (FOR UPDATE STATEMENTS)
IT24274ATTEMPT TO INSTALL DB2 SERVER 10.5 64 BIT FIXPACK 9 FAILS DURINGUPGRADE WHEN DB2 V10.5 32 BIT ALREADY EXISTS ON WINDOWS
IT24232RARE TIMING ISSUE MAY CAUSE INSTANCE CRASH ON BACKUP COMPLETION
IT24218CLP CRASHES WITH DB21018E
IT24217SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24216SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24215SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24214DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
IT24213DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
IT24212DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
IT24201SQL507N ERROR COULD OCCUR WHEN AN UPDATE TARGET TABLE RESIDES INREMOTE DATA SOURCE
IT24200IN SPECIFIC TIMING CONDITIONS DB2READLOG API CALLER CAN THROW SQL2038N ERROR.
IT24180CHECK SYNOPSIS TABLE WHENEVER IT IS QUERIED
IT24179DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH
IT24171SECURITY: DB2 IS AFFECTED BY MULTIPLE ARBITRARY FILE OVERWRITE VULNERABILITIES
IT24170SECURITY: DB2GENP ARBITRARY FILE OVERWRITE VULNERABILITY
IT24155CONNECTIONS FAIL IN CRYPTDIGESTINIT WITH ECF_CRYPT_UNEXPECTED_ERROR
IT24131DB2 MAY DEADLATCH DURING AN INSERT INTO AN ITC TABLE WHILE THEREARE 2 OR MORE OTHER CONCURRENT IUD TRANSACTIONS
IT24129DB2 MAY DEADLATCH DURING AN INSERT INTO AN ITC TABLE WHILE THEREARE 2 OR MORE OTHER CONCURRENT IUD TRANSACTIONS
IT24126ERROR SQL0437W RC=13 WITH THE CERTAIN ROWS IN A GENERATING AN ACCESS PLAN WHEN USING AN OPTIMIZATION PROFILE.
IT24115DB2ACD MIGHT INCORRECTLY CHOOSE INDEX REBUILD DURING AUTOMATIC TABLE MAINTENANCE EVEN WHEN NO OFFLINE WINDOW IS AVAILABLE
IT24105DB2 MIGHT TRAP DURING ROLLBACK OF TRUNCATE TABLE
IT24104DB2 MIGHT TRAP DURING ROLLBACK OF TRUNCATE TABLE
IT24090AFTER DB2 RECYCLE, DB2 STARTED ARCHIVING OLD LOG FILES CAUSING ACTIVE LOG FILESYSTEM QUICK GROWTH.
IT24078DB2 MAY HIT SUSTAINABLE TRAP IN SQLNO_CREATE_TEMPORAL_KEYS PROCESSING
IT24063POSSIBLE TRAP (FODC) IN 'HDREDUACCEPTEVENT()' DUE TO INVALID CONNECTION SEQUENCE
IT24061UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT24060UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT24059SECURITY: UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT24058UPDATE GSKIT TO THE NEWEST FIPS CERTIFIED VERSION
IT24047SLOW INSERT PERFORMANCE IN PURESCALE BECAUSE UNCOMMITTED DELETED SLOTS AREN'T REUSED CORRECTLY
IT24045QUERIES USING HASH JOINS MAY HANG AND NOT BE ABLE TO BE FORCED OFF
IT24041WRONG RESULTS OR SQL901N ERROR POSSIBLE WHEN EXECUTING SQL STATEMENT WITH SCALAR SUBQUERY ON COLUMN ORGANIZED TABLES
IT24028DB2 LOG REPLAY (RECOVERY, RFWD, HADR) MIGHT HANG WITH DB2REDOM IN SQLPRGETFREEQE->WAIT AND DB2REDOWS IN SQLPRFINDQUEUE->WAIT.
IT24027DB2 LOG REPLAY (RECOVERY, RFWD, HADR) MIGHT HANG WITH DB2REDOM IN SQLPRGETFREEQE->WAIT AND DB2REDOWS IN SQLPRFINDQUEUE->WAIT.
IT24004DB2ACD MIGHT INCORRECTLY CHOOSE INDEX REBUILD DURING AUTOMATIC TABLE MAINTENANCE EVEN WHEN NO OFFLINE WINDOW IS AVAILABLE
IT23978DB2 CLP FRONT END MIGHT HANG IN CLP_FP_SIG->SQLNLSMESSAGE AND LOCK DB2DIAG.LOG FILE
IT23966bad performance when replaying TLOGPREP_XA log records
IT23954HADR STANDBY FAILS WITH DBHEAP OUT OF MEMORY UPON RECONNECT
IT23941DB2 ABEND DUE TO MEMORY CORRUPTION USING COLUMN BASED TABLES
IT23938IN CDE, INCORRECT RESULTS MIGHT BE RETURNED FOR A QUERY THAT REFERENCES A CORRELATED SCALARY SUBQUERY IN A PREDICATE
IT23929THE TO_DATE FUNCTION IS NOT PUSHED DOWN CORRECTLY IN FEDERATED SETUP
IT23918NNSTAT MIGHT FAIL WITH SQL1227N THE CATALOG STATISTIC " " FOR COLUMN " " IS OUT OF RANGE FOR ITS TARGET COLUMN
IT23915SQL901N MIGHT OCCUR WHEN RUNNING QUERIES CONTAINING UNION IN CDE
IT23909INTERMITTENT DB21018E ERROR RETURNED TO CLP DURING CONNECTION TOA DATABASE.
IT23907IN CDE, INCORRECT RESULTS MIGHT BE RETURNED FOR A QUERY THAT REFERENCES A CORRELATED SCALARY SUBQUERY IN A PREDICATE
IT23905INTERMITTENT DB21018E ERROR RETURNED TO CLP DURING CONNECTION TOA DATABASE.
IT23897DB2 SERVER TERMINATES ABNORMALLY COMPILING A MERGE STATEMENT
IT23894FEDERATION: COLUMN ALIAS IN REMOTE QUERY MAY BE MISSING, WHICH CAN CAUSE SQL0203N.
IT23875WRONG RESULTS ARE POSSIBLE WHEN EXECUTING A SQL STATEMENT ELIGIBLE FOR ZIGZAG JOIN ON A NON-PARTITIONED INDEX
IT23863APPLICATION ID IS NOT CAPTURED CORRECTLY BY ACTIVITY MONITOR, CAUSING NO INFO TO BE RETURNED WHEN RUNNING DB2EXPLN
IT23859DB2 CLP FRONT END MIGHT HANG IN CLP_FP_SIG->SQLNLSMESSAGE AND LOCK DB2DIAG.LOG FILE.
IT23848SQLCOLUMNS CLI FUNCTION MAY NOT WORK ON A TABLE NAME THAT INCLUDES MBCS CHARACTERS
IT23822MEMORY LEAK IN A DB2 PURESCALE ENVIRONMENT
IT23817RETRIEVE ARRAY GETTING FULL WHEN TWO OR MORE DB2READLOG API CALLERS TRYING TO READ FROM THE SAME LOG FILE
IT23814HADR LOG GAP ON AUXILARY STANDBY INCREASES SIGNFICANTLY WHILE ONLINE BACKUP IS RUNNING.
IT23812INSTANCE TRAP IS POSSIBLE WHEN QUERY AGAINST COLUMN ORGANIZED TABLES WITH OLAP SPECIFICATION IS RUN
IT23805.DB2TAG SHOULD BE CONVERTED TO .SWTAG AND NOT .SWIDTAG.
IT23804DB2 RESTORE MAY FAIL WITH ZRC=0X85020024=-2063466460=SQLB_TBLSPC_MAPS_TOO_BIG "MAP TOO BIG"
IT23803DB2 RESTORE MAY FAIL WITH ZRC=0X85020024=-2063466460=SQLB_TBLSPC_MAPS_TOO_BIG "MAP TOO BIG"
IT23799UNSAFE DESERIALIZATION IN DB2 JDBC DRIVER
IT23798UNSAFE DESERIALIZATION IN DB2 JDBC DRIVER
IT23797UNSAFE DESERIALIZATION IN DB2 JDBC DRIVER
IT23794SECURITY: UNSAFE DESERIALIZATION IN DB2 JDBC DRIVER
IT23791DB2 INVOKED THE USEREXIT TOO EARLY (USEREXIT WAS COPYING THE SOURCE LOG WHILE LOGGW WAS STILL WRITING NEW LOG DATA TO IT)
IT23787DATABASE MANAGER FAILS TO CREATE A NEW STRIPE SET OF CONTAINERS AND HANGS
IT23784QUERY FAILS WITH -901 FOUND ZERO CLOB.RESET OR -973
IT23775ALTER TABLE DROP COLUMN MAY TRAP
IT23768CHANGE PROBE WARNING IN DB2DIAG.LOG MESSAGE FROM "ERROR" TO "WARNING" FOR RETCODE : ZRC=0X801A006D=-2145779603=SQLZ_CA_BUILT (WL
IT23756DB2 MAY RETURN STMMSIMULATESORTMERGE ERROR AND NOT BENEFIT FROM SORT MEMORY SIMULATION
IT23742DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING OR PREDICATES AND EXISTS PREDICATES
IT23741A QUERY OVER NICKNAMES OR COLUMN ORGANIZED TABLES CONTAINING FETCH FIRST N ROWS ONLY CLAUSE MAY RETURN INCORRECT RESULTS
IT23724AMENDMENT ON SQL0270 RC= 113 MESSAGE
IT23720HADR: FAIL TO UNLOCK THE RESOURCE WHEN BOTH HOSTS COMING BACK ATSAME TIME CAUSES FREQUENT DISCONNECT AND BAD PERFORMANCE
IT23700INSTALLATION OF DATA PROTECTION SAP DB2/ORACLE FAILS WITH AN ILLEGAL INSTRUCTION EXCEPTION
IT23698DB2 MIGHT TRAP IN SQLRWPERFORMWORKLOADASSIGNMENT_NC() WHEN AGENTIS REUSED WITH ANOTHER DATABASE.
IT23694THE EXPLANATION FOR SQL0338N NEEDS AN UPDATE AFTER THE ENHANCEMENT MADE SINCE 10.1 TO ALLOW SUBQUERIES IN AN ON CLAUSE
IT23671SYSTOOLS.JSON_UPDATE CAN CRASH OR RETURN "BSON VALUE IS TOO LONG" WHEN UPDATING A NULL FIELD
IT23664A TRAP, PANIC OR A -901 SQLCODE (SQLRA_FREE_SECTION: SECTION NOT CLOSED) OCCURS IN DPF
IT23657Db2 skips verifying checksum for page from temp table
IT23650DB2 MAY TRAP WITH EXECUTING A QUERY WITH NODENUM OR DBPARTITIONNUM FUNCTION IN DPF ENVIRONMENT.
IT23649DB2 MIGHT TRAP WHEN EXECUTING A QUERY REFERENCING NODENUMBER OR DBPARTITIONNUM FUNCTION IN DPF ENVIRONMENT
IT23647DB2 MAY TRAP WITH EXECUTING A QUERY WITH NODENUM OR DBPARTITIONNUM FUNCTION IN DPF ENVIRONMENT.
IT23630RUNNING "DB2LOOK -L" IN DPF RESULTS IN VERY HIGH MEMORY USAGE - MEMORY LEAK
IT23629DB2LOOK WHEN USED WITH "-l" OPTION FAILS WITH ERROR SQL1635N orSQL1092N
IT23619TRANSACTION ID TABLE OVERFLOWED DURING HADR REPLAY
IT23617TRANSACTION ID TABLE OVERFLOWED DURING HADR REPLAY
IT23578SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR
IT23577INSTANCE CRASH WHEN CAPTURING SECTION EXPLAIN INFORMATION FOR SQL STATEMENT THAT CAN PRODUCE A VERY LARGE OPTIMIZED STATEMENT
IT23575JCC SECURITY VULNERABILITY
IT23571SQL0901N/-901 FODC_APPERR ON ALTER TABLE DROP COLUMN
IT23562SYSPROC.REORGCHK_IX_STATS RETURNING INCORRECT VALUES OF F4 COLUMN FOR PARTITIONED TABLES
IT23558DBT5513N THE DB2CKUPGRADE UTILITY FAILED BECAUSE THE SYSCATSPACETABLE SPACE REQUIRES MORE SPACE IN ORDER TO COMPLETE THE UPGRAD
IT23557FEDERATED QUERY CONTAINING ROWNUM CRITERIA MISSING IN REMOTE SQL
IT23551INSTALLING IBM DATA SERVER RUNTIME CLIENT VIA SILENT INSTALL, FAILS TO CREATE A DB2 INSTANCE
IT23550DB2CLUSTER -CHFS -LIST -LOCALOSTVERSION COULD SHOW INCORRECT GPFS VETSION.
IT23535DOCUMENTATION TO PREVENT UNWANTED RESULTS WITH THE 7.1.8 AND 8.1.2 CLIENT ENHANCEMENTS BY INCOMPATIBLE LOCAL GSKIT VERSION
IT23534DB2LOOK WARNING NUMBER OF KEYS IN INDEX LIMITED TO 16 FOR DB2Z
IT23474DB2READLOG API SOMETIMES SLOW DOWN UNDER HEAVY WORKLOAD.
IT23463DB2LOOK FAILS WITH SQL0423N LOCATOR VARIABLE "1" DOES NOT CURRENTLY REPRESENT ANY VALUE.
IT23441DB2 MEMBER IS KILLED AND RESTARTED DUE TO GPFS MOUNT RESOURCE TEMPORARILY REPORTING OFFLINE
IT23438Running db2cluster to change hostfailuredetectiontime may fail indicating that the shared file system cluster must be stopped.
IT23431STATEMENT MAY FAIL WITH FOLLOWING ERROR: PERMANENT TAOB FOR MDC BIXA OBJECT IS NULL
IT23430DUMP.BIN FILES ARE GENERATED ON HADR STANDBY SERVER
IT23421ONCE SQL0954C IS FACED WITH APPLHEAPSZ DURING DB UPGRADE MAKE THE PARAMETER AUTO INTERNALLY FOR THE UPGRADE DURATION.
IT23420THE MOUNTV111_STOP.KSH SCRIPT MAY ERRONEOUSLY RUN THE FUSER -K COMMAND AGAINST THE ROOT FILE SYSTEM
IT23419Extra spaces generated from export when using codeunits32
IT23418Extra spaces generated from export when using codeunits32
IT23403RETRIEVE ARRAY GETTING FULL WHEN TWO OR MORE DB2READLOG API CALLERS TRYING TO READ FROM THE SAME LOG FILE
IT23402"CLP SELECT STATEMENT DISPLAY FIX FOR CHAR AND VARCHAR CODEUNITS32 STRING UNITS"
IT23400THE "DB2HAICU -DELETE" COMMAND MAY FAIL TO DELETE RESOURCES FOR THE INSTANCE IF A RESOURCE WAS INCOMPLETELY CREATED
IT23377RUBY APPLICATION OCCASIONALLY HANGS DURING FETCHING DATA
IT23376SQL0901N - REASON "INT. ERROR: QUERIED PERIOD IS NOT DEFINED" WHEN USING TEMPORAL TABLES
IT23375SQL0901N - REASON "INT. ERROR: QUERIED PERIOD IS NOT DEFINED" WHEN USING TEMPORAL TABLES
IT23360DB2READLOG API CAN HANG IN PURESCALE.
IT23359WHEN RUNNING A INGEST YOU ARE ABLE TO SELECT ROWS THAT HAVE BEENCOMMIT BY INGEST EVEN THOUGH NOT COMPLETED.
IT23357LOGTS BUFFER FULL CAUSING SLOW PERFORMANCE
IT23355ADDRESS MASTER SERVER BLACKOUT ISSUE AND DEK CACHING
IT23353SQL0901/SQL0404/ABEND when compiling UPDATE statement
IT23350DB2 MAY RETURN SQL0901N: EMPTY PLAN LIST DETECTED
IT23349DB2 MAY RETURN SQL0901N: EMPTY PLAN LIST DETECTED
IT23341WRONG RESULTS ARE POSSIBLE WHEN EXECUTING A SQL STATEMENT ELIGIBLE FOR ZIGZAG JOIN ON A NON-PARTITIONED INDEX
IT23322DB2LICM -L OUTPUT ON 11.1FP2 AESE/AWSE SHOWS IBM DB2 PERFORMANCEMANAGEMENT OFFERING IS NOT LICENSED.
IT23321DB2 MIGHT PANIC WHEN ATTEMPTING TO UNLOCK AN INVALID LATCH AFTER HDRCLOSECONN CALL ON TCP/IP ERROR
IT23319-901 ERROR IN SOME CASES WHEN EXPLAIN MODE IS ON AND A STATEMENTIS RUN TWICE
IT23318INCORRECT MISSING LOG FILE NUMBER IS REPORTED IN ERROR MESSAGES
IT23315A TRAP, PANIC OR A -901 SQLCODE (SQLRA_FREE_SECTION: SECTION NOT CLOSED) OCCURS IN DPF
IT23313QUERY FAILING WITH -901 ERROR UNEXPECTED ERROR AT DATATYPEIMPL.HPP:
IT23310WHEN USING SCRIPTED INTERFACE TIMESTAMP IN PROTOCOL FILE NAME AND IN CONTENTS OF PROTOCOL FILE MAY NOT BE EQUAL
IT23308.NET APPLICATION MAY FAIL WITH SYSTEM.ACCESSVIOLATIONEXCEPTION EXCEPTION
IT23295"CLP SELECT STATEMENT DISPLAY FIX FOR CHAR AND VARCHAR CODEUNITS32 STRING UNITS"
IT23294THE CAPTURE PROGRAM OF Q-REPLICATION TERMINATES WITH SQL2038N ONDB2 PURESCALE
IT23284MQFUNCTIONS DO NOT FUNCTION PROPERLY IN DB2 V11.1 ON AIX
IT23281THE DB2HAICU UTILITY MAY APPEAR TO HANG IN A DPF HA ENVIRONMENT CONTAINING MANY HOSTS
IT23275ADMIN_MOVE_TABLE DOES NOT TRANSFER INDEX RANDOM COLUMN ORDER
IT23269"SET ENCRYPTION PASSWORD" TRIGGER/SPL CAN CAUSE SQLCODE -20143
IT23267A QUERY OVER NICKNAMES CONTAINING FETCH FIRST N ROWS ONLY CLAUSEMAY RETURN INCORRECT RESULTS
IT23265FED:UNDER QUERIES:UNION: ERROR HANDLING FOR DISTINCT FROM SELECT_LIST FOR LOLEPOP: SORT.
IT23261INCORRECT RESULTS WITH AGGREGATION ON OUTER JOINED TABLE WITH FOREIGN KEY ON NULL PRODUCING TABLE
IT23260INCORRECT RESULTS WITH AGGREGATION ON OUTER JOINED TABLE WITH FOREIGN KEY ON NULL PRODUCING TABLE
IT23256WITH INFINITE LOGGING, AFTER FAILED LOG ARCHIVAL, TRANSACTION MIGHT GET STUCK DUE TO MAXIMUM ALLOWABLE UNARCHIVED LOG
IT23254Db2 HADR standby db can shutdown when log archive path is sharedwith a different database
IT23249EXECUTING A 4-PART NAME QUERY FROM MS SQL SERVER HANGS
IT23245TRAP WHEN IN/EXISTS SUBQUERY IN SELECT LIST AND ACCESS CONTROL ACTIVATED
IT23243TRAP WHEN IN/EXISTS SUBQUERY IN SELECT LIST AND ACCESS CONTROL ACTIVATED
IT23238HANG CAUSED BY DB2VEND PROCESS IN ACTIVATION PROCESS
IT23225INSTALLATION WITH WINDOWS EXTENDED SECURITY DISABLED BEHAVES AS THOUGH WINDOWS EXTENDED SECUIRTY WAS ENABLED.
IT23214Disk full for mirror logpath hit after updating logging method from archive to circular
IT23206SQL5133N AFTER MOVING A DB2 CLIENT INSTALLATION TYPE TO SERVER TYPE
IT23205ASYNCHRONOUS INDEX CLEANUP FAILS WHEN DB2LOCK_TO_RB IS SET TO STATEMENT
IT23204ASYNCHRONOUS INDEX CLEANUP FAILS WHEN DB2LOCK_TO_RB IS SET TO STATEMENT
IT23202LOAD OF BITEMPORAL TABLES MIGHT FAIL TO DETECT DUPLICATE / OVERLAPPING ROWS WITH INDEXING MODE REBUILD
IT23198SQL0156N WHEN UPDATING STATISTICS IN SYSSTAT.TABLES
IT23197SQLO_DISK MISLEADING ERROR MESSAGE IN DB2DIAG.LOG WHEN VERIFYINGSMS BAD PAGE.
IT23185MEMORY CORRUPTION DURING XA PROCESSING ON FEDERATED OBJECT
IT23181Disk full for mirror logpath hit after updating logging method from archive to circular
IT23180POSSIBLE TRAP IN SQLNN_ERDS() + 901 WHEN RUNNING QUERY WITH NAMED PARAMETER MARKERS IN FEDERATED ENVIRONMENT
IT23177ADMIN_MOVE_TABLE COULD CAUSE DATABASE CRASH WHILE COMPLETE WITH WARNINGS
IT23174[IFIX002_FINAL] SERVER_DEC IMAGE DOES NOT HAVE CORRECT LICENSE APPLIED
IT23173DECREASED PERFORMANCE, STMMSTARTHJMONITORIFNECESSARY ERRORS LOGGED IN CONSTRAINED/VOLATILE STMM ENVIRONMENTS
IT23166ASYNCHRONOUS INDEX CLEANUP FAILS WHEN DB2LOCK_TO_RB IS SET TO STATEMENT
IT23161UNDER DB2 DEVELOPER-C EDITION LICENSE, CREATE DATABASE WILL FAIL WITH SQL1139N.
IT23158SQL0901N COULD CAUSE INSTANCE OUTAGE FOR CDE CENTERED QUERIES, IF MESSAGE IS LONGER THEN 256 BYTES.
IT23157SQLO_DISK MISLEADING ERROR MESSAGE IN DB2DIAG.LOG WHEN VERIFYINGSMS BAD PAGE.
IT23147CBITS WAS MESSED UP WHEN MIGRATE OLD V2 PAGE DURING BACKUP
IT23146DB2VAL MAY CRASH IN DB2 10.5FP9
IT23141INTERMITTENT LOAD ABNORMAL END IN THE BUILD PHASE: UNEXPECTED MSG. , 28, 0, DETECTED IN FILE:SQLUVLD.C, LINE:5506
IT23135DUMP.BIN FILES ARE GENERATED ON THE HADR PRIMARY SERVER
IT23134DUMP.BIN FILES ARE GENERATED ON HADR STANDBY SERVER
IT23132DB2TS UPDATE INDEX COMMAND FAILS WITH CIE00759 COMMUNICATION TIMEOUT AFTER 2-HOURS HANG.
IT23130POSSIBLE HANG BETWEEN 3 EDUS INVOLVING SQLO_LT_SQELOCALDATABASE__DBLATCH AND ANOTHER UNTRACKED LATCH
IT23129CREATE DATABASE RETURNS -1051
IT23128CREATE DATABASE RETURNS -1051
IT23120USING OLEDB DRIVER CALL TO SYSIBM.SQLTABLES RETURNS SQL0443N WITH CLI:=727
IT23119USING OLEDB DRIVER CALL TO SYSIBM.SQLTABLES RETURNS SQL0443N WITH CLI:=727
IT23117THE SCRIPTED INTERFACE MIGHT NOT FIND BACKUP IMAGES FROM DATABASES WHOSE NAME CONTAINS SPECIAL CHARACTERS
IT23107"MEMORY LEAK" ISSUE IN PACKAGE CACHE DUE TO "LEAKED" VARIATIONS
IT23106PURESCALE DATABASE MIGHT BE DEACTIVATED AFTER A BACKUP/RESTORE
IT23105USING OLEDB DRIVER CALL TO SYSIBM.SQLTABLES RETURNS SQL0443N WITH CLI:=727
IT23084MEMORY CORRUPTION CAN OCCUR DURING AN XML TRANSFORMATION
IT23080PURESCALE DATABASE MIGHT BE DEACTIVATED AFTER A BACKUP/RESTORE
IT23073CRASH RECOVERY OR A DATABASE ROLLFORWARD OR HADR TAKEOVER MAY FAIL DURING ONLINE RECOVERY PROCESSING.
IT23072SQL0156N WHEN UPDATING STATISTICS IN SYSSTAT.TABLES
IT23070SSL CONNECTION WITH CLI THIN DRIVER FAIL SPORADICALLY WITH SQL10013N GSKIT ERROR: 6 OR GSKIT ERROR: 155
IT23069FILEDSN IS NOT WORKING WITH V111M2FP2 : SPECIFIED DRIVER COULD NOT BE LOADED DUE TO SYSTEM ERROR 1114: A DYNAMIC LINK LIBRARY (
IT23055ERROR -518 DURING A CLI ARRAY INPUT CHAINING
IT23052RESTORE TRANSPORT MAY RESULT IN SQL0601N
IT23051RESTORE TRANSPORT MAY RESULT IN SQL0601N
IT23049SUPPORTING 1390/1390A AND 16684/16684A CONVERTERS WITH JDK 1.8
IT23033DB2 MIGHT TRY TO READ LOG RECORDS THAT DO NO LONGER EXIST AFTER LOG FILE TRUNCATION
IT23032DB2 MIGHT TRY TO READ LOG RECORDS THAT DO NO LONGER EXIST AFTER LOG FILE TRUNCATION
IT23016DB2 AUTHORITIES ARE IGNORED WITH CHANGE DATABASE CONFIGURATION
IT22993THE CAPTURE PROGRAM OF Q-REPLICATION TERMINATES WITH SQL2038N ONDB2 PURESCALE
IT22979CREATED FEDERARED PROCEDURE FOR A SP WITH NO ARGUMENTS IN ORACLEDATABASE MAY FAIL WITH -901
IT22978DB2PD HANG
IT22976ROUTINE EXECUTION MONITORING STOPS WORKING, SPAMS DB2DIAG.LOG WITH ALLOCRTNSTMTTABLE MESSAGE
IT22972QUERY INVOLVING OUTER JOINS HAS WRONG COLUMN RESULT NULLABILITY
IT22968RUNSTATS with index sampling can produce INCORRECT NLEAF OF PARTITIONED INDEX FOR LARGE RANGE PARTITIONED TABLE
IT22962CREATED FEDERARED PROCEDURE FOR A SP WITH NO ARGUMENTS IN ORACLEDATABASE MAY FAIL WITH -901
IT22946LPAD/RPAD RETURN EMPTY STRING INSTEAD OF NULL IN ORA-MODE DATABASE
IT22945SQLGETTYPEINFO RETURNS 255 FOR CHAR DATATYPE WHEN CONNECTION FROM V11 CLIENT TO V10.5 SERVER.
IT22941TRAP/901 WHEN XML COLUMN NOT REFERENCED
IT22923IMPORT REPLACE HOLDING X ROW LOCK AND IX TABLE LOCK ON SYSIBM.SYSTABLES FOR THE WHOLE DURATION
IT22921DUMP.BIN FILES ARE GENERATED ON THE HADR PRIMARY SERVER
IT22920DUMP.BIN FILES ARE GENERATED ON THE HADR STANDBY SERVER
IT22919IN ORA COMPATIBITITY MODE, ROUND FUNCTION MAY RETURN VALUES AS EXPONENT EXPRESSION
IT22906RESTORE OF A SNAPSHOT BACKUP IMAGE FROM A DOWNLEVEL RELEASE FAILS IN A PARTITIONED DATABASE ENVIRONMENT WITH SQL1031N
IT22893DB2PD HANG
IT22892LOAD IN DPF DATABASE CREATES TEMP FILES THAT ARE NOT CLEANED-UP AFTER THE LOAD IS COMPLETED
IT22884TRAP/901 WHEN XML COLUMN NOT REFERENCED
IT22880DB2 ENGINE MIGHT CRASH WHEN QUERIES HAVE OUTER JOINS, NOT EXISTSOR NOT IN PREDICATES
IT22873ADMIN TASKS NOT EXECUTED DUE TO NEXT INVOCATION TIME IN THE PAST
IT22871ADMIN TASKS NOT EXECUTED DUE TO NEXT INVOCATION TIME IN THE PAST
IT22869DB2PD -OSINFO MIGHT IN RARE TIMING CONDITIONS CRASH WITH SEGV
IT22862AGGSQLTEMPSPACE THRESHOLD DOES NOT LIMIT TEMPORARY TABLE SPACE SIZE.
IT22850DECREASED PERFORMANCE, STMMSTARTHJMONITORIFNECESSARY ERRORS LOGGED IN CONSTRAINED/VOLATILE STMM ENVIRONMENTS
IT22826WRONG RESULT WHEN PREDICATE HAS CONCATENATED CONSTANT AND COLUMN.
IT22822WRONG RESULT WHEN PREDICATE HAS CONCATENATED CONSTANT AND COLUMN.
IT22815CRASH MAY OCCUR DURING CDE JOIN WHEN PROCESSING A LARGE AMOUNT OF DATA
IT22814THE DB2.EMP DIRECTORY IS NOT REMOVED AFTER RUNNING INSTALLFIXPACK
IT22805CF STUCK IN CATCHUP STATE
IT22803MEMORY LEAK IN PRIVATE SET WHEN USING SNAPSHOTS TO RETURN THE REQUESTED STATEMENT TEXT
IT22796DB2EXPLN FAILS WITH SQL1131N
IT22791POSSIBLE WRONG RESULTS WITH VARCHAR_FORMAT WHEN USING 'DY DDD YYYY' FORMAT
IT22790BUG IN VARCHAR_FORMAT WHEN USING 'DY DDD YYYY' FORMAT
IT22783INCORRECT RESULT WHEN USING THE XMLTABLE FUNCTION AND REFERENCING ELEMENTS THAT DON"T EXIST IN THE SOURCE DOCUMENT
IT22782STORED PROCEDURE SAPTOOLS.PARTITION_MERGE SPORADICALLY FAILS WITH SQL668 REASON CODE 11
IT22780CRASH MAY OCCUR DURING CDE JOIN WHEN PROCESSING A LARGE AMOUNT OF DATA
IT22779DB2 MAY HIT DATA-INDEX MISMATCH WHEN INDEX DEFINITION USES JSON_VAL FUNCTION.
IT22776INSTALLFIXPACK PARAMETER "-P" IS INVALID FOR NON-ROOT INSTALLATION
IT22769SNAPSHOT TEMPORARY FILES LEFT IN SQLLIB/TMP AFTER FMP INTERRUPTION
IT22759DB2 AGENT/DB2FMP CAN HANG DUE TO INCOMPLETE HANDSHAKE DURING INTERRUPT
IT22757DB2 MIGHT SEEM TO HANG DURING QUERY COMPILATION
IT22750POSSIBLE WRONG RESULTS WITH VARCHAR_FORMAT WHEN USING 'DY DDD YYYY' FORMAT
IT22746FEDERATED QUERY WITH FUNCTION TEMPLATE OVER a GROUP BY or UNION may fail with -901 "No ftslpd through GB/UNION DISTINCT"
IT22744CLP crashes with DB21018E
IT22743APPLICATIONS MAY RECEIVE SQL1034C WHEN TAKEOVER HADR BY FORCE ISISSUED.
IT22740DB2 MAY TRAP IN @114@OSSPOWERPCFETCHANDNOOP64__FPVL SQLMONSZAGNT__FUI13SQM_ENTITY_IDP6SQLMAIPUIP5SQLCA
IT22735COMPONENTLIST.HTM LISTS ESE INSTEAD OF SERVER
IT22725NUM_DB_BACKUPS AND REC_HIS_RETENTN MIGHT NOT BE PROPERLY HANDLEDBY PRUNE HISTORY
IT22718DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER
IT22704HADR STANDBY ONLY WRITES ONE LOG PAGE AT A TIME TO DISK DURING REMOTE CATCHUP STATE WHICH COULD MAKE THE GAP BIGGER
IT22684SQL STATEMENTS EXECUTING AN INDEX SCAN WITH INTRA-PARTITION PARALLELISM ENABLED MIGHT RUN SLOW
IT22681INSERT into a column-organized table table might fail with errorSQL901.
IT22680SELF-BLOCKING SQL INSERT OR UPDATE - SELF-DEADLATCH IN SQLO_LT_SQLD_CCB__CCBLATCH
IT22674EXPLAIN STATEMENT INCLUDING A PARAMETER MAKER FROM JCC APPLICATION MAY CAUSE THE INSTANCE CRASH
IT22673DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER
IT22665-901 OR TRAP WHEN OUTER JOIN ON GROUP BY AND UNION
IT22658EXPLAIN STATEMENT INCLUDING A PARAMETER MAKER FROM JCC APPLICATION MAY CAUSE THE INSTANCE CRASH
IT22647STATEMENT MAY FAIL WITH FOLLOWING ERROR: PERMANENT TAOB FOR MDC BIXA OBJECT IS NULL
IT22646-901 OR TRAP WHEN OUTER JOIN ON GROUP BY AND UNION
IT22643IBM DATA SERVER CLIENT CANNOT BE DETECTED BY IBM LICENSE METRIC TOOL (ILMT)
IT22632SCRIPTS FAILS WITH SQLSTATE 42702 / SQLCODE: -204
IT22631DB2 MAY CRASH WHEN PROCESSING EXTENSIVE LIST OF TABLESPACES IN HISTORY FILE
IT22630Performance Regression might be Observed with Queries ContainingNOT EXISTS or NOT IN Predicates
IT22629UPDATING DB2LOOK -L TO WORK WITH DPF DATABASES TIMELY
IT22628GPFS ENTERS ARBITRATING STATE ON DB2CLUSTER MAINTENANCE.
IT22627DPF QUERY MAY HANG DUE WAITS ON SUBSECTIONS FOR ONE NODE
IT22626LOAD IN ENCRYPTED DATABASE WILL LEAK SOME ENCRYPTION RELATED MEMORY BLOCKS
IT22625LOAD UTILITY DOES NOT PROVIDE BENEFICIAL MESSAGES ON THE CONSTRAINT VIOLATION
IT22624DB2VAL FAILS TO VALIDATE SYSADMIN AUTHORITY IF SYSADM_GROUP IS LESS THAN 8 CHAR LONG
IT22623CONNECTION HANG ON V10.5FP8 ONLY ON SOLARIS WITH SPARC64-X
IT22622INSTANCE MAY CRASH WHEN SQLGGTSS API IS RUN WITHOUT A CONNECTION
IT22621SECURITY MECHANISM NOT SUPPORTED EXCEPTION WHEN AUTHENTICATION=CLIENT AND PASSWORD AND USER ARE PROVIDED.
IT22620DB2PREREQCHECK REPORTS MISSING OF LIBIPATHVERBS.I686 INCORRECTLY
IT22619"DB2IUPDT -COMMIT_LEVEL <INSTANCE NAME>" FAILED WITH DBI1558E SAYING CF IS NOT SAME LEVEL WITH MEMBER

© Icons by Mark James www.famfamfam.com

invispix 10x10
invispix 10x10
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.
More information Ok