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
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
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
IT25336INFORMATIONAL: CUSTOMERS WILL NEED A 11.1 SPECIAL BUILD TO UPGRADE FROM 10.5FP10 to 11.1.2.2 or 11.1.3.3
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
IT25305SQL0332N WITH NVL2 FUNCTION AND VARCHAR FOR BIT DATA AND GRAPHIC
IT25302POTENTIALLY BAD PERFORMANCE WHEN USING PARAMETER MARKERS IN QUERIES CONTAINING JOINS
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
IT25229DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING REDUNDANT PREDICATE
IT25195QUERIES CONTAINING OUTER JOINS AND GROUP BY CLAUSES MIGHT PRODUCE WRONG RESULTS
IT25183LOG_TO_FILE OPTION OF EVMON_FORMAT_UE_TO_XML TABLE FUNCTION CANNOT WRITE OUT XML DOCUMENT MORE THAN 100MB
IT25136QUERY EXECUTION FAILS WITH -901 "SQLRIDERIVEDUMMY FUNCTION SHOULD NEVER BE ACTUALLY CALLED"
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
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
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
IT25029RESTORE FROM INCREMENTAL BACKUP WITH MULTIPLE STREAMS - DB2 MAY ERROR SQL2032N THE "BUFFER_NUM" PARAMETER IS NOT VALID. SQLSTATE
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
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
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
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.
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)
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
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
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
IT24539INSTANCE MAY CRASH IN SQLRH_FREE_HANDLE
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
IT24473SECURITY: BUFFER OVERFLOW IN DB2LICM
IT24466SECURITY: RAH.EXE BUFFER OVERFLOW
IT24465SECURITY: RAH.EXE BUFFER OVERFLOW
IT24464SECURITY: RAH.EXE BUFFER OVERFLOW
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.
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
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 AFTER INTERNAL INTERRUPT (SQL0952N)
IT24295RESTART OF A PARTITIONED DATABASE FAILS WITH SQL10003C ON NON-CATALOG PARTITION
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
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
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
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
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
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
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.
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
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.
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
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
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
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
IT22618DB2 MIGHT INCORRECTLY LIMIT NUMBER OF CPU CORES USED WHEN RUNNING WITH CPU_LIMITED LICENSE.
IT22617FAILURE TO ALLOCATE SHM SEGMENT WITH HUGE PAGES MIGHT END UP WITH TRAP OR INCORRECT BEHAVIOR
IT22616THE "ADD DBPARTITIONNUM" STATEMENT MAY FAIL WITH SQL1483N
IT22615OWNER / QUALFIER OF STORED PROCEDURE CHANGED TO SYSIBM
IT22614RUNGSEDEMO FAILS WITH SQL0604N IF DB CFG STRING_UNITS = CODEUNITS32
IT22613ADDITIONAL CALLS IN AGENT BREATHING POINT CAUSE POOR PERFORMANCEIN LOAD UTILITY
IT22612HADR ROS FAILS WHEN A QUERY ON THE STANDBY HAS AN ORDER BY CLAUSE
IT22611SQLOAMINSTALLIMAGE LEAKING FILE DESCRIPTORS
IT22610UNDER RARE CIRCUMSTANCES WHEN HISTORY FILE GROWS MORE THAN 4 GB BACKUP CAN HANG
IT22609DATABASE RESTORE HITS ADM6091W ON TABLESPACE MAXSIZE
IT22608DB2 DUMP FILE SIZE IS GETTING BIGGER WHEN REPEATING SAME WARNINGMESSAGE IN LOG RETRIEVING
IT22607THE 512 BYTES MISALIGMENT DURING LOB PROCESSING MIGHT INTRODUCE CONTENTION ON GPFS.
IT22606A LOCKING EVENT MONITOR CAN INCORRECTLY CAPTURE STATIC STMT TEXTAND REPORT INCORRECT NUMBER OF INPUT VARIABLES
IT22605HADR STANDBY MIGHT GET CORRUPTED IN CASE FAILURE DURING MULTIPLEREORG RUNNING ON HADR PRIMARY
IT22604DB2START MIGHT HANG IN TRCATTACHSHARED() ON THE SYSTEM WITH LOW SHARED MEMORY SEGMENT SIZE LIMIT (SHMMAX)
IT22603AUTOMATIC REORG CAN KEEP OCCURRING ON TABLES IF THERE IS A SINGLE INDEX PAGE & IS PSEUDO EMPTY.
IT22599UNABLE TO LOAD MORE THAN 2GB THROUGH REMOTE EXTERNAL TABLE USINGDB2 CLIENTS.
IT22593WLM STMT THRESHOLD DO NOT STOP EXECUTION WHEN SPECIFIC SQL IS RUN.
IT22590POOR PERFORMANCE WHEN LARGE NUMBER OF EXPRESSIONS IN THE QUERY
IT22589DB2AUDIT IS NOT REPORTING SQL0551N WHEN A USER WITH INSUFFICIENTAUTHORIZATION ATTEMPTS TO CALL A PROCEDURE
IT22588DB2LOOK CORE DUMPS
IT22587DB2LOOK FOR TIMESTAMP COLUMNS GENERATES TIMESTAMP(9) WHEN DEFINED ON DB2 FOR Z/OS
IT22586POOR PERFORMANCE WHEN FORCE_REPLICATED_MQT_MERGE IS SET
IT22580CRASH MAY BE ENCOUNTERED WHILE COLLECTING EXPLAIN ON A QUERY.
IT22567DB2READLOG API CAN HANG IN PURESCALE.
IT22566DIAGPATH IS CHANGED TO SQLLIB/DB2DUMP FROM THE DEFAULT PATH DURING CREATING ESE INSTANCE
IT22560AFTER ARCHIVING TO FAILARCHPATH, ARCHRETRYDELAY SETTING IS IGNORED
IT22555DIAGPATH IS CHANGED TO SQLLIB/DB2DUMP FROM THE DEFAULT PATH DURING CREATING ESE INSTANCE
IT22548INCORRECT RESULT WHEN USING THE XMLTABLE FUNCTION AND REFERENCING ELEMENTS THAT DON"T EXIST IN THE SOURCE DOCUMENT
IT22532FAILURE ON MEMBER-CF COMMUNICATION ONCE ONE OF REDUNDANT SWITCHES IS FAILED.
IT22524HADR STANDBY CAN BECOME UNABLE TO DELETE EXTRA LOGS IN ACTIVE PATH, CAUSING LOGS TO ACCUMULATE
IT22522CHECK SYNOPSIS TABLE WHENEVER IT IS QUERIED
IT22519IN A DPF ENVIRONMENT, AN INSERT MAY FAIL WITH ERROR SQL0912N RC=1 IF THERE IS A SEQUENCE
IT22508?CA0104? ERROR ON QREP APPLY IN Z/OS WITH RETRIEVING "FOR BIT DATA? COLUMN FROM DB2 LUW
IT22505DB2 MAY INCORRECTLY RETURN SQL0420N WHILE COMPILING A QUERY CONTAINING UNION ALL OPERATORS
IT22504DB2 INVOKED THE USEREXIT TOO EARLY (USEREXIT WAS COPYING THE SOURCE LOG WHILE LOGGW WAS STILL WRITING NEW LOG DATA TO IT)
IT22494QUERY CONTAINS COUNT(CONSTANT) OR COUNT_BIG(CONSTANT) MIGHT RETURN INCORRECT RESULT
IT22464DB2DIAG.LOG FILLED WITH ERROR ON FUNCTION SQLBFINDPAGEINBPORSIMPROBE: 1952 SQL0003N THE DATABASE NAME IS NOT VALID
IT22459WLM STMT THRESHOLD DO NOT STOP EXECUTION WHEN SPECIFIC SQL IS RUN.
IT22453DB2 MAY INCORRECTLY RETURN SQL0420N WHILE COMPILING A QUERY CONTAINING UNION ALL OPERATORS
IT22447VARIOUS -901 SQLCODES AND TRAPS DURING COMPILATION RELATING TO ACCESS OF THE TABLE PACKED DESCRIPTOR
IT22446MISSING WARNING WHEN REBIND WITH APREUSE
IT22445MEMORY LEAK IN FEDERATED FMP PROCESS DUE TO USE OF PASSTHRU.
IT22443TRANSFER OWNERSHIP OF A VIEW THAT IS BASED ON A MODULE VARIABLE FAILS WITH SQL20342N
IT22440DB2 MAY HANG ON QUERIES INVOLVING INDEX COLUMNS WITH INTRA_PARALLEL ENABLED
IT22435VARIOUS -901 SQLCODES AND TRAPS DURING COMPILATION RELATING TO ACCESS OF THE TABLE PACKED DESCRIPTOR
IT22434DB2 PURESCALE HANG DUE TO MISSING LOCK NOTIFICATION
IT22432THE INSTANCE CAN TRAP IN XA FUNCTION TRAPPED IS SQLPRESETXIDINTENTRY WHEN DBHEAP IS SET TO A LOW VALUE
IT22430DB2: SILENT INSTALLATION MIGHT FAIL WITH SEGV IN ENCODEPASSWORD->STRCPY IF CRYPT() RETURNS AN ERROR (E.G. WITH FIPS_ENABLED)
IT22428THE INSTANCE CAN TRAP IN XA FUNCTION TRAPPED IS SQLPRESETXIDINTENTRY WHEN DBHEAP IS SET TO A LOW VALUE
IT22425INFINITE LOOP IN OSSCOMPUTEMONTGOMERYINVERSE32(), ROOT CAUSE UNKNOWN, ADD DIAGNOSTIC DUMPS
IT22422TRANSFER OWNERSHIP OF A VIEW THAT IS BASED ON A MODULE VARIABLE FAILS WITH SQL20342N
IT22415SECURITY: DB2 INSTALL USES WEAK PASSWORD ENCRYPTION (CVE-2017-1571)
IT22414SECURITY: DB2 INSTALL USES WEAK PASSWORD ENCRYPTION (CVE-2017-1571)
IT22413SECURITY: DB2 INSTALL USES WEAK PASSWORD ENCRYPTION (CVE-2017-1571)
IT22411SECURITY: DB2 INSTALL USES WEAK PASSWORD ENCRYPTION (CVE-2017-1571)
IT22392SQL0420 AFTER UPGRADE TO V11.1
IT22386DB2 : IF ANY COMMAND WITH RECLAIM EXTENTS OPTION IS RUN ON AN MDC TABLE DURING A BACKUP, A ROLLFORWARD ON IT COULD FAIL
IT22385DB2 : IF ANY COMMAND WITH RECLAIM EXTENTS OPTION IS RUN ON AN MDC TABLE DURING A BACKUP, A ROLLFORWARD ON IT COULD FAIL
IT22367AN SQL0901N "EXPECTING CACHED ZVAL FOR MARKED PID" IS POSSIBLE
IT22366HANG CAUSED BY SET WRITE SUSPEND/RESUME AND LOAD
IT22363SAP: POOR PERFORMANCE WHEN SAP MEMORY TABLE IN JOIN ON COLUMN ORGANIZED TABLES
IT22361SAP: POOR PERFORMANCE WHEN SAP MEMORY TABLE IN JOIN ON COLUMN ORGANIZED TABLES
IT22360WRONG RESULT WHEN EXPRESSION ON JOIN COLUMN
IT22357CALLING UTL_FILE.FCLOSE_ALL MAY CAUSE THE INSTANCE TRAP
IT22352DB2 : IF ANY COMMAND WITH RECLAIM EXTENTS OPTION IS RUN ON AN MDC TABLE DURING A BACKUP, A ROLLFORWARD ON IT COULD FAIL
IT22345WRONG RESULT WHEN EXPRESSION ON JOIN COLUMN
IT22344DB2 MAY FAIL EXECUTING QUERY DURING SEMIJOIN PROCESSING ON CDE
IT22343SQL0901N UNEXPECTED ERROR AT DATABASETABLEACCESSOR.HPP:1357"
IT22324WRONG RESULT WHEN EXPRESSION ON JOIN COLUMN
IT22297DB2 MIGHT TRAP WHEN EXECUTING COMPLEX QUERIES CONTAINING CSES
IT22284APPLICATION HEAP CAN BE EXHAUSTED BY REBAL FUNCTION AND THIS CANLEAD TO APPLICATION FAILURE WITH OUT OF MEMORY
IT22261SLOW INSERT PERFORMANCE WHEN USING MON_OBJ_METRICS EXTENDED
IT22260INSTANCE CRASH AFTER RUNNING OUT OF MEMORY
IT22243DB2CONNECT server may trap if CURRENT CLIENT_CORR_TOKEN is explicitly set by an application.
IT22237THE DB2FMCD PROCESS DOES NOT START DB2 INSTANCES AT SYSTEM BOOT TIME.
IT22221WRONG RESULTS OR SQL901N MAY OCCUR WHEN EXECUTING A SQL STATEMENT CONTAINING TWO OR MORE NOT IN OR NOT EXISTS PREDICATES
IT22216HADR STANDBY CAN BECOME UNABLE TO DELETE EXTRA LOGS IN ACTIVE PATH, CAUSING LOGS TO ACCUMULATE
IT22211QUERY PERFORMANCE ISSUE WITH SMP PARALLELISM AND "LIMIT ?" CLAUSE
IT22210QUERY PERFORMANCE ISSUE WITH SMP PARALLELISM AND "LIMIT ?" CLAUSE
IT22207SQL0901N "COLUMN NUMBER OUT OF RANGE" ERROR WHEN GROUP BY IN NULL PRODUCING SIDE OF OUTER JOIN
IT22199POSSIBLE TRAP IN SQLNGSECTALLOCATEINTERNAL() WHEN RUNNING LARGE AND COMPLEX QUERIES
IT22197SQL0901N "COLUMN NUMBER OUT OF RANGE" ERROR WHEN GROUP BY IN NULL PRODUCING SIDE OF OUTER JOIN
IT22189SUPPORTING 1390/1390A AND 16684/16684A CONVERTERS WITH JDK 1.8
IT22188REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN
IT22185ON A NAT ENVIRONMENT WITH THE REGISTRY VARIABLE DB2_HADR_NO_IP_CHECK TURNED ON, HAS ISSUES WITH MULTIPLE HADR STANDBYS.
IT22183IF A PREPARED STATEMENT HAS A COMMENT WITHOUT PROPER MATCHING SINGLE QUOTE, ERROR HAPPENS.
IT22175QUERY FAILING WITH -901 ERROR UNEXPECTED ERROR AT DATATYPEIMPL.HPP:
IT22174CLI0150E WHEN SETTING CURSORHOLD ON VIA CLI APPLICATION THAT CONNECTS TO SERVER RUNNING ON LINUX PPC 64-BIT LE ENVIRONMENT
IT22162CONVERSION BETWEEN DIFFERENT CODE PAGES CAN LEAD TO UNEXPECTED TRUNCATION OF DATA
IT22161CONVERSION BETWEEN DIFFERENT CODE PAGES CAN LEAD TO UNEXPECTED TRUNCATION OF DATA
IT22160SEVERE ERRORS IN THE DB2DIAG.LOG RELATED TO INGEST(SQLUDISHM::CLEANFORMATTERBLOCK)
IT22148SEVERE ERRORS IN THE DB2DIAG.LOG RELATED TO INGEST(SQLUDISHM::CLEANFORMATTERBLOCK)
IT22143No room for retrieved log number xxx in retrieveArray during Rollfoward or Crash recovery
IT22136HADR STANDBY ENTERS AN INFINITE LOOP BETWEEN READ FROM MEMORY AND READ FROM DISK WHEN ENCOUNTERING A LOG FILE WITH CORRUPTED XHD
IT22132THE DB2CKUPGRADE TOOL DOES NOT CHECK IF THERE IS ENOUGH FREE SPACE IN DMS TEMPORARY TABLE SPACE BEFORE UPGRADE.
IT22130THE DB2CKUPGRADE TOOL DOES NOT CHECK IF THERE IS ENOUGH FREE SPACE IN DMS TEMPORARY TABLE SPACE BEFORE UPGRADE.
IT22123PURESCALE MEMBER HITS AN FODC AND RESTARTS AFTER PRIMARY CF FAILOVER
IT22118WINDOWS EVENT HANDLE LEAK WITH PARALLELIZED QUERY PLANS (INTRA_PARALLEL YES) - MAY CAUSE OSERR 1450
IT22113"DB2INSTANCE -LIST" MAY NOT SHOW ALERTS WHEN "DB2CLUSTER -CFS -LIST -FILESYSTEM <FSNAME> -DISK" IS ISSUED BY ROOT.
IT22111CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES WHEN HASH TABLE NEEDS TO BE SPILLED FOR A GROUPBY
IT22110CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES DURING HASH TABLE JOIN
IT22100ALTER TABLE DROP COLUMN MAY TRAP
IT22091CONVERSION BETWEEN DIFFERENT CODE PAGES CAN LEAD TO UNEXPECTED TRUNCATION OF DATA
IT22077HANG IN SQLESERVICECLASSDEREGISTERSYSENTITY WHILE HOLDING SQLO_LT_SQLE_SERVICE_CLASS__SERVICECLASSLATCH
IT22058DB2RSPGN GENERATES AN INCORRECT RESPONSE FILE
IT22056QUERY INVOLVING OUTER JOINS HAS WRONG COLUMN RESULT NULLABILITY
IT22051BLU/CDE SQL STATEMENT MIGHT FAIL WITH SQL1225N IN A DPF INSTANCE.
IT22050DB2 : MISSING DATA ON QUERY WITH CURRENTLY COMMITTED FEATURE, WHEN SUCH QUERY IS EXECUTED IN THE MIDDLE OF COMMIT PROCESSING

© Icons by Mark James www.famfamfam.com

invispix 10x10
invispix 10x10
DB2 für Admins
x
DB2 Technische Infos
x
DB2 Dokumentation
x
DB2 Produktlinien
x
DB2 Newsletter
x
DB2 Bug-Recherche
x
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