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
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.
IT24749DB2 MAY CRASH IN SAL FLIGHT RECORDER CODE
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
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
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
IT24663HADR STANDBY LOG REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO BAD PAGE WHILE DOING AN INSERT
IT24652INDEX ACCESS MAY NOT BE CHOSEN FOR SUBPLAN WITH INSERT WITH COLUMN ORGANIZED TABLES
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
IT24558ERROR SQL0102N RETURNED WHEN DB CFG VARCHAR2=ON, STMT_CONC=LITERALS AND STRING_UNITS=CODEUNITS32
IT24539INSTANCE MAY CRASH IN SQLRH_FREE_HANDLE
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
IT24493LOCK EXCLUSIVE MDC TABLE WITH LOCKSIZE SET TO BLOCKINSERT, INSERTING ROWS WILL RESULT IN ADDITIONAL LOCKS BEING ACQUIRED.
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
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
IT24301QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP"
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
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
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
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
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
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
IT23132UPDATE INDEX COMMANDS OF DB2 TEXT SEARCH FAILS OR 2-HOUR HANGS IF THE DOCUMENT CONTAINS THE EMBEDDED IMAGE.
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
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
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
IT22040DB2 MAY FAIL READING PAGES FROM LOG FILE
IT22036DB2 MAY TRAP IN SQLEXGETENCRYPTIONSTRINGS FUNCTION.
IT22013WRONG RESULT IS POSSIBLE WHEN CODEUNITS 32 IS USED IN A ROW DATATYPE ASSIGNMENT AND CAST IS USED
IT22011DB2 DOES NOT CAST THE JOIN COLUMNS CORRECTLY, LEADING TO A -901 ERROR IN CDE FOR DPF
IT22009STANDBY CRASHES IF MIRROR LOG PATH IS CHANGED AND DATABASE IS NOT REACTIVATED AFTERWARDS.
IT22008DB2DART MIGHT TRAP WHEN FACED WITH CORRUPTIONS IN BLU TABLES
IT21999SQL1038N ON CALL REORGCHK_IX_STATS('T','ALL')" WITH STMT_CONC=LITERALS
IT21996SQL0901N ERROR CAN BE HAPPENED WHEN USING AN INDEX ON EXPRESSION
IT21985DOING LIKE ON A CODEUNITES32 FIXED LENGTH COLUMN &nbsp;IN THE COLUMNAR ORGANIZED TABLE COULD RETURN AN INCORRECT RESULT
IT21982DB2CMD.EXE MAY NOT WORK PROPERLY WHEN THE COMMAND LINE IS EXTREMELY LONG
IT21981RESTORE DATABASE COMMAND HAVING HISTORY FILE OPTION FAILED AND INSTANCE CRASHED.
IT21974SECURITY: USER WITHOUT PROPER AUTHORITY CAN ACTIVATE DATABASE.
IT21973SECURITY: USER WITHOUT PROPER AUTHORITY CAN ACTIVATE DATABASE.
IT21971DOING LIKE ON A CODEUNITES32 FIXED LENGTH COLUMN &nbsp;IN THE COLUMNAR ORGANIZED TABLE COULD RETURN AN INCORRECT RESULT
IT21965DB2UNINS CANNOT BE USED FROM INSTALLED COPY
IT21948DB2 MAY RETURN WRONG RESULTS WITH ORACLE COMPATIBILITY AND SUBSTR
IT21940FIXPACK UPDATE GETS ERRORS FOR NOT EXIST "DB2" INSTANCE.
IT21939In HADR, primary database could be brought down due to no heap memory is available
IT21938DB2DART REPORT ON A COLUMN-ORGANIZED (BLU) TABLE TAKES LONG TIMETO COMPLETE
IT21937ADD TOLERATION LOGIC IN CASE A STANDBY RECEIVES A BAD LOG PAGE DUE TO NETWORK ISSUE
IT21936DB2 OPTIMIZER MIGHT PRODUCE SUB-OPTIMAL ACCESS PLAN FOR QUERY REFERENCING COLUMN ORGANIZED TABLE WITH PRIMARY KEY
IT21935FATAL ERROR WHEN TAKING MULTIPLE SNAPSHOT BACKUPS WITH NO TRANSACTION(S) IN BETWEEN
IT21934LIST INDOUBT TRANSACTIONS MAY NOT RETURN TO PROPMT
IT21933APPLICATIONS FAIL WITH ERROR SQL30020N "0X124C"("0100") WHEN CONNECTING THROUGH A GATEWAY
IT21932ADDRESS SPACE CONFLICT MAY OCCUR IN DB2GCF IF ASLR IS ENABLED
IT21931SPATIAL EXTENDERS DATA TYPES NOT CLEARED AFTER DB2SE DISABLE_DB <DATABASE> AND CANNOT BE DROPPED
IT21930If DB2 happens to be backing up the tablespace at the same time it is being altered, this could cause DB2 panic.
IT21929DB2START FAILS DUE TO THE TSA LICENSE INFORMATION GATHERED IN A LANGUAGE OTHER THAN ENGLISH
IT21928MBCS DOT CHARACTER IN JAPANESE GOT IQQS0032E ERROR IN CONTAINS FUNCTION
IT21927BLOCK DROPPING OF CF DURING ROLLING UPGRADE
IT21926WRONG TRIGGER IS BEING DROPPED FROM PACKED DESCRIPTOR RECORD IF USING LONGER SCHEMA NAME AND SAME TRIGGER NAME.
IT21925DURING NORMAL PROCESSING "ROUTINE FAILED WITH TERMINATION ERROR"ARE LOGGED AS ERROR IN DB2DIAG.LOG
IT21924MEMBER PANIC DUE TO INVALID MEMORY SIZE IN SQLEINITWLDISPATCHER()
IT21923POSSIBLE TRAP IN RELEASECONFLICT() BECAUSE PAUDITSETTINGS->AUDITSETTINGSLATCH IS ALREADY UNLOCKED
IT21922DB2AUDIT: USE OF UNINITIALIZED OBJECT SCHEMA IN AUDIT DATA.
IT21921NO ERROR MESSAGE IS RETURNED WHEN THE DATA EXCEEDS JSON ARRAY SIZE.
IT21920ALTER TABLESPACE REDUCE OPERATIONS MIGHT LEAD TO ASYNCHRONOUS HIGH WATERMARKS IN HADR SYSTEMS
IT21919THE "DB2PD -CFPOOL DETAIL" COMMAND ABNORMALLY TERMINATES
IT21918CRASH MAY OCCUR CREATING STORED PROCEDURE WITH XML QUERY WITH PASSING BY REF ON HOST VARIABLE
IT21917THE DB2 LUW COMMAND BIND USES BY DEFAULT DEALLOCATE FOR THE RELEASE OPTION
IT21916NON-ROOT fixpack update uisng installFixPack not replacing the files in the security directory.
IT21915'START HADR AS STANDBY' OPERATION MAY FAIL WITH SQL1776N RC=7 DURING REINTEGRATION IN PURESCALE
IT21914ON WINDOWS PLATFORMS, RETRIEVING AN SSL CERTIFICATE FROM THE OS CERTIFICATE STORE MIGHT FAIL FOR CLIENT PRODUCTS
IT21913INSTANCE CAN TRAP IN XMLRNPERMMNXRFORMATTER::ENDREGIONINSERT WHEN INSERTING/DELETING XML RECORDS
IT21912A REPEATED POSITIONED UPDATE ON A ROW CAN LEAD TO AN ABEND/CRASHon sqlristm
IT21911DB2CKUPGRADE FAILS WITH DBT5501N IF PATH/FILENAME CONTAINS "-D"
IT21910INSTANCE CRASHED WITH SIGSEGV IN LIBPTHREAD.SO.0
IT21909SLOW PERFORMANCE IN DB2AUDIT EXTRACT DELASC DUE TO MANY SMALL WRITES TO THE OUTPUT FILE
IT21908ATTEMPTING TO REVALIDATE A COMPLEX MASK CALLING ADMIN_REVALIDATE_DB_OBJECTS MIGHT FAIL
IT21907DB2 MIGHT HANG DURING A MANUAL 'UPDATE DATABASE CFG' TO DECREASETHE DATABASE MEMORY CONFIG SETTING
IT21906NSE CHACKNSEINDEX UTILITY MAY RETURN CTE5257E REASON CODE "2"
IT21905DB2 MIGHT PRODUCE SUBOPTIMAL PLAN FOR DEEPLY NESTED NOT EXISTENTIAL SUBQUERIES
IT21903Crash in embeddedSQL application while closing the cursor.
IT21902BACKGROUND DAEMONS MIGHT NOT START JUST AFTER TAKEOVER HADR DUE TO TIMING HOLE.
IT21897WRONG RESULT IS POSSIBLE WHEN CODEUNITS 32 IS USED IN A ROW DATATYPE ASSIGNMENT AND CAST IS USED
IT21849ALTER OF CHAR/VARCHAR COLUMN TO GRAPHIC/VARGRAPHIC DATA TYPE IN A NON-UNICODE DATABASE COULD CAUSE SQL2216N
IT21848LDAP PLUGIN NOW ALLOWS SIGNATURE ALGORITHMS TO BE SPECIFIED WHENUSING TLS 1.2
IT21847AUTO REORG FOR DATA PARTITIONS IGNORES USER SPECIFIED OPTIONS INREORG POLICY
IT21846DB2 MIGHT PRODUCE SQL0901N WHEN EXECUTING NOT EXISTS SUBQUERY WITH NESTED SUBQUERIES
IT21844DB2 MAY CRASH DURING PROCESSING OF THE OPTIMIZER PROFILE
IT21843THE CLI LOAD API MAY ABNORMALLY END (ABEND) ON CERTAIN VERSIONS OF LINUX
IT21842IN XA/PURESCALE ENVIRONMENT, XA-END COULD BE BROADCASTED TO ALL NODES EVEN IF THEY WEREN'T PART OF THE TRANSACTION.
IT21841ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL2102N RC=22 WHEN USING COPY_USE_LOAD
IT21840UNEXPECTED OOM ERRORS AFTER A LARGE DYNAMIC DATABASE CONFIGURATION INCREASE
IT21839INCONSISTENT STATE OF SYSIBMTS SCHEMA OBJECTS CANNOT BE CLEANED
IT21838THE SAME 'DATABASE NAME' IS LISTED AT 'LOCAL DATABASE ALIAS' EVEN IF 'ALIAS' AND 'NAME' ARE DIFFERENT IN DB2DSDRIVER.CFG.
IT21837IN PURESCALE ENVIRONMENT: DB2PD -REORGS DOESN'T SHOW REORG INFORMATION AFTER RUNNING ONLINE REORG SECOND TIME
IT21836ACS FILES PRESENT IN $INSTHOME/SQLLIB/ACS WHEN CLIENT INSTANCE CREATED FROM SERVER INSTALL
IT21835IMPROVE PD DIAGNOSTICS FOR DB2HACFSVERIFYMAINTENANCEMODE() AND DB2HACFSSETCLUSTERCONFIGURATION() FUNCTIONS.
IT21834DB2MOVE MAY NOT COPY UNDER SUPPORTED MULTI-BYTE CODE CONVERSION ENVIRONMENT
IT21833INGEST MAY FAIL IF 'ALIAS' AND 'NAME' IS DIFFERENT IN DB2DSDRIVER.CFG
IT21831ERROR MESSAGE SQLP_NOTA "TRANSACTION WAS NOT FOUND" FOR SQLRR_XROLLBACK IS INCORRECTLY LOGGED IN DB2DIAG.LOG
IT21830SQL0818N RETURNED TO APPLICATION WHEN SQL PROCEDURE INVOKED AFTER THE PRIOR INVOCATION WAS ROLLED BACK.
IT21829CONCURRENT INGEST MIGHT FAIL INTERMITTENTLY WITH SQL0901N "INVALID PARAMETER"
IT21827Snapshot backup might fail with error SQL2079N
IT21826EVMON_FORMAT_UE_TO_XML DOES NOT SORT PARTICIPANT PAST ACTIVITIESIN A USEFUL WAY
IT21825A COMPLICATED SELECT STATEMENT MAY RECEIVE SQL0901N RARELY
IT21824IN FEDERATION, SYSPROC.NNSTAT SEEMS TO UPDATE STATS_TIME
IT21823MEMORY LEAK IN DBHEAP IF DB2READLOG RECEIVES AN ERROR TO FIND LOG FILE.
IT21821SIGSEGV AFTER CALLING SQLBDIRTYTBSPACEFLAGSFORBACKUP
IT21820LATCHES SUCH AS SQLO_LT_SQLP_DBCB__READBUFSEM ARE NOT BEING REPORTED IN MON_GET_EXTENDED_LATCH_WAIT
IT21819TBSP_INCREASE_SIZE RETURNED BY MON_GET_TABLESPACE HAS INVALID VALUE
IT21818-30020 WITH MULTI ROW FETCH AND SPLIT BUFFER THAT CONTAINS LOB DATA
IT21817SUB-OPTIMAL PERFORMANCE OF DBMS_UTILITY.GET_HASH_VALUE
IT21816The optimizer might choose a non-optimal full table scan compared to a better performing index access on the inner of an NLJOIN
IT21814SQLDPREFETCHFORESTIMATE, PROBE:7433 ZRC=99 MAY BE SEEN WHEN USING ADMIN_GET_TAB_COMPRESS_INFO
IT21813WPLISTENER.SH FAILS TO START WITH : 75: [: -START: UNEXPECTED OPERATOR ERROR
IT21812PURESCALE MEMBER STUCK IN CRASH RECOVERY.
IT21811FEDERATION AND DBMS_SQL MAY RECEIVE SIGSEGV AT SQLEUCTRUSTEDLVLINIT

© 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