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
IT24078DB2 MAY HIT SUSTAINABLE TRAP IN SALNO_CREATE_TEMPORAL_KEYS PROCESSING
IT24047SLOW INSERT PERFORMANCE IN PURESCALE BECAUSE UNCOMMITTED DELETED SLOTS AREN'T REUSED CORRECTLY
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.
IT23894FEDERATION: COLUMN ALIAS IN REMOTE QUERY MAY BE MISSING, WHICH CAN CAUSE SQL0203N.
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
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"
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
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.
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
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
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.
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
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
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
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"
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.
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
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.
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
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
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
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
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
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
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)
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.
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
IT22056QUERY INVOLVING OUTER JOINS HAS WRONG COLUMN RESULT NULLABILITY
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
IT22008DB2DART MIGHT TRAP WHEN FACED WITH CORRUPTIONS IN BLU TABLES
IT21985DOING LIKE ON A CODEUNITES32 FIXED LENGTH COLUMN &nbsp;IN THE COLUMNAR ORGANIZED TABLE COULD RETURN AN INCORRECT RESULT
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
IT21936DB2 OPTIMIZER MIGHT PRODUCE SUB-OPTIMAL ACCESS PLAN FOR QUERY REFERENCING COLUMN ORGANIZED TABLE WITH PRIMARY KEY
IT21914ON WINDOWS PLATFORMS, RETRIEVING AN SSL CERTIFICATE FROM THE OS CERTIFICATE STORE MIGHT FAIL FOR CLIENT PRODUCTS
IT21910INSTANCE CRASHED WITH SIGSEGV IN LIBPTHREAD.SO.0
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
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
IT21810MEMORY CRASH WHEN CALL SYBASE WRAPPER THROUGH FEDERATED.
IT21809THE DB2SUPPORT TOOL MAY ABNORMALLY END (ABEND) ON CERTAIN VERSIONS OF LINUX
IT21808VARIOUS MEMORY LEAKS IN DB2SYSC WHEN USING TEXTSEARCH
IT21807INSTANCE MAY TRAP IN GETENV FUNCTION DURING UPDATING DB2 TEXT SEARCH INDEXES
IT21806JUMP SCAN MAY GET SIGSEGV AT SQLNO_PLAN_ARGS_SCAN
IT21805QUERY ABNORMALLY ENDS IN SQL0901N "EMPTY PLAN LIST DETECTED!"
IT21804FLUSH BUFFERPOOL ALL ON STANDBY MAY CAUSE FORCEDBSHUTDOWN
IT21803AUTO_REORG ON ITC TABLES MAY FAIL WITH SQL0960, INDEX EVALUATIONIS LOOPING
IT21802CLOB DATA GREATER THAN 32KB MIGHT BE CORRUPTED IF FEDERATION SERVER SENDS IT TO ORACLE DATABASE.
IT21801CTE0243 AND CTE0277 ERROR WHEN CALLING DB2EXT.TEXTSEARCH PROCEDURE EVEN THOUGH THE CACHE FOR THE INDEX IS ACTIVATED.
IT21800SQL901 ERROR DURING QUERY COMPILATION.
IT21799DB2 HEALTH MONITOR PROCESS (DB2ACD) MIGHT LEAK MEMORY IN HADR ENVIRONMENT AFTER A TAKEOVER
IT21798MSSQL WRAPPER MIGHT RETURN SQL1822N (HY024: INVALID ARGUMENT VALUE) IF SOURCE TABLE HAS LARGE NUMBER OF COLUMNS.
IT21797CRASH IN XMLRNSETUPXMLDD BECAUSE FAILING TO ALLOCATE MEMORY AND THEN FREEING MEMORY WE WEREN'T ABLE TO ACQUIRE
IT21796"UOW LOG SPACE USED" IN APP SNAPSHOT NEVER RESET WHEN USING XA TRANSACTION
IT21795SOME EXTRA LOG FILES REMAIN IN MIRRORLOGPATH AFTER CHANING LOGPRIMARY AND/OR LOGSECOND IN CIRCULAR LOGGING MODE
IT21793DB2 UPGRADE DATABASE MIGHT FAIL WITH SQL1704N RC 17 IF MAXSIZE LIMIT FOR SYSCATSPACE IS HIT DURING THE UPGRADE (ADM6091W)
IT21792DB2 EVENT MONITOR FOR CHANGE HISTORY IS NOT LOGGING THE ATTACH PARTITION COMMAND
IT21791MSDTC PROCESS CAN CRASH IN DB2APP64.DLL
IT21790INGEST REPORTS SQL1057W OR SQL1031N WHEN USING DS DRIVER BUT DATABASE IS NOT CATALOGED IN THE DATABASE DIRECTORY
IT21789DB2 MIGHT INCORRECTLY TRY TO ADD CONTAINER WITH A DUPLICATE NAME
IT21788DB2 REQUIRES OLDER ARCHIVE LOG FILE FOR DB2READLOG API EVEN IF REQUESTED LSN IS NEWER THAN STARTLSN OF THE CURRENT ACTIVE LOG
IT21787WHEN INTRA_PARALLEL IS ON QUERIES USING HASH JOINS MAY HANG AND NOT BE ABLE TO BE FORCED OFF
IT21786RUNNING THE "DB2CLUSTER -LIST -ALERT" COMMAND GENERATES "SQLHA EVENT RECORDER HEADER DATA" MESSAGES IN THE DB2DIAG.LOG
IT21785DB2 LOAD FAILING IN DPF ENVIRONMENT DUE TO SQL0969N THERE IS NO MESSAGE TEXT CORRESPONDING TO SQL ERROR "-2769"
IT21784MEMORY LEAK IN TASK SCHEDULER AS ATSTASK OBJECTS ARE NEVER DESTROYED
IT21783IMPROVE PD DIAGNOSTICS FOR DB2HACFSEXITMAINTENANCEMODE() AND DB2HACFSENTERMAINTENANCEMODE() FUNCTIONS.
IT21781MEMBER COULD NOT BE ACTIVATED AFTER IT WAS STOPPED IN PURESCALE.
IT21777DB2 TEXT SEARCH MAY NOT RESPOND BY ECMTS SERVER HIGH CPU USAGE
IT21772INCORRECT LENGTH FOR SQL_LOCAL_LEN AND SQL_CODESET_LEN ON AIX
IT21771SQL30082 RC=15, PASSWDEXPIRED ERRNO=22 IF MISSING 64-BIT GSA MODULE
IT21767SQL30082 RC=15, PASSWDEXPIRED ERRNO=22 IF MISSING 64-BIT GSA MODULE
IT21760DB2 MAY RETURN WRONG RESULTS WITH ORACLE COMPATIBILITY AND SUBSTR
IT21755ENTITY FRAMEWORK EXCEPTION 'MAPPING SPECIFIED IS NOT VALID' WHENUSING BOOLEAN COLUMNS WITH INFORMIX
IT21754SQL5193N RECEIVED ON WORKLOAD ASSIGNMENT WHEN ROLE IS INHERITEDFROM A TRUSTED CONTEXT
IT21753DB2LOOK -XD DOES NOT GENERATE GRANTS FOR AUTHORIZATIONS IMPLICITLY GIVEN ON THE OBJECT
IT21751DB2 EDU MIGHT TRAP IN SQMFASTWRITER::INITFASTWRITER() DURING THETAKEOVER IN HADR ENVIRONMENT AFTER SQLO_NOMEM_DBH ERROR
IT21750PRIVATE MEMORY LEAK BY DB2FCMS IN A PURESCALE ENVIRONMENT
IT21749SQLKDDISPATCHREQUEST FAILS WITH SQLKF_NODE_FAILED ERROR EVEN AFTER ROCM REPORTS DEPARTURE NOTIFICATION
IT21748SIGNAL 11 TRAPS GENERATED IN SQLMONBACKEND FUNCTION
IT21746CREATE TABLE FAILS WITH SQL1655C INTERMITTENTLY AFTER FAILED LOAD
IT21745OPTIMIZER MIGHT CHOOSE A SUBOPTIMAL TBSCAN OVER IXSCAN FOR SQL STATEMENT CONTAINING A SUBQUERY PREDICATE
IT21744-901: INVALID SVAR LEN, PRODUCING FODC_APPERR
IT21743APPLICATION INTERRUPT ERROR MESSAGES IN DB2DIAG.LOG DUE TO AUTO RUNSTATS
IT21742NOT ABLE TO DROP A PACKAGE AND INSTANCE GOING DOWN WHEN DROP PACKAGE DUE TO FUNCTIONS HAVE DEPENDENCY ON EACH OTHER
IT21741THE CHARACTER DATA IS CORRUPTED IN SYSIBMTS.TSEVENT VIEW IS INCORRECT IF DB2TS UPDATE INDEX IS SCHEDULED BY ALTER INDEX COMMAND.
IT21740DB2 Text Search Fails to Create Text Index On XML Datatype Output From UDF Due to CIE00312 Error
IT21739ADMIN_GET_TAB_COMPRESS_INFO TABLE FUNCTION RETURNED SQL0901N ERROR WITH LOAD PENDING TABLESPECE HAVING PARTITIONED TABLE.
IT21738MEMORY LEAK IN 'DB2ACD' WHEN 'AUTO REORG' IS EVALUATED
IT21737INSTANCE MIGHT CRASH WHEN WHEN THE RID WAS DELETED FROM INDEX AND MDC TABLE
IT21736TRAP IN DPF ENVIRONMENT WHEN COMPLEX QUERY WITH AGGREGATION IS RUN
IT21735QUERY MAY FAIL WITH SQL1585N LOOKING FOR A 4K TEMP TABLESPACE DESPITE OTHER TEMP SPACES ARE AVAILABLE
IT21734DB2 CONNECTS TO STANDBY EVEN PRIMARY DATA IS UP.
IT217338KB MEMORY LEAK IN CLI_SETSESSIONGLOBALVARIABLES()
IT21732DATABASE UPGRADE/RESTORE FROM PRE-10.1 MIGHT CORRUPT CONTAINER PATH IN SPCS IF SYMLINK IS USED
IT21731ERROR DURING RETRIVAL OF LOG FILES WHILE TAKING THE DATABASE BACKUP.
IT21730IN SOME CIRCUMSTANCES REVALIDATION OF INVALIDATED VIEWS MAY NOT SUCCEED
IT21728THE ROUTINE AUDIT_LIST_LOGS IS NOT ABLE NOT HANDLE 64 FILES.
IT21727CREATE DATABASE FAILS WITH "ERROR ACCESSING A TABLE SPACE CONTAINER" ON A DEVICE WITH SECTOR SIZE OTHER THAN 512 BYTES.
IT21726Deadlatch caused query on a range partitioned table to hang in aparallel environment
IT21725INDEX SCAN MAY ENCOUNTER CRASH WHEN RID IS NEEDED FOR USER DEFINED TEMP TABLE
IT21724SMALL MEMORY LEAK IN DB2 CLIENT/DRIVER IF CLIENT AFFNITY IS ENABLED
IT21723DB2FOC DOES NOT CHECK FOR ELEVATED PRIVILEGES ON WINDOWS
IT21722ON DB2 V10.5 FP7 DB2 -L /DEV/NULL <ANY OPERATION> RESULTS INTO ERROR DB21005E
IT21721SQL0901N REASON "PROBE 015 IN SQLKT_PACK_TUPLE(), MSG=INVALID LEN.CLEN(X) OR STORAGELEN" WHEN CREATING AN INDEX
IT21720DB2INIDB WILL GO INTO INFINITE LOOP IF SQLSPCS FILE IS GREATER THAN 2GB
IT21719'DB2 WRITE SUSPEND FOR DATABASE' COMMAND HUNG DUE TO DEAD LATCH WHEN USING 'EXCLUDE LOGS' OPTION
IT21718DB21018E RETURNED TO A CLP COMMAND RUN VIA NOHUP IF THE PARENT SHELL HAS EXITED.
IT21717INSTANCE MAY PANIC WHEN TRYING TO DROP AN OBJECT IF ANOTHER AGENT HAS ACCESS ON THE OBJECT WITH ERROR TCB FIX COUNT != 1 IN DB2D
IT21716DB2 CONNECTIONS WORKS FINE WHEN A PASSWORD IS EXPIRED
IT21715CLOB DATA MIGHT BE GARBLED IF SOURCE EBCDIC DBCS STRING EXCEEDS 32K.
IT21713TEST FOR -NOEXEC MOUNT INCORRECTLY FAILS IN DB2SETUP SCRIPT
IT21712SIGNIFICANT INCREASE IN SHARED APPLICATION HEAP AFTER UPGRADE TO10.5 FOR QUERIES REFERENCING RANGE PARTITIONED TABLES
IT21711REVOKING PRIVILEGES MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY
IT21710REMOVE LICENSE CHECKING FROM THE CONNECTION CREATION LOGIC ON SERVER SIDE TO IMPROVE PERFORMANCE
IT21709CLI APPLICATION RECEIVES SIGNAL SIGSEGV DURING A CALL OF A STORED PROCEDURE
IT21707ADD PDLOGS TO DB2 HA TSA WRAPPER FUNCTIONS
IT21706ALTER TABLE STATEMENT WITH AN ATTACH PARTITION CLAUSE MAY RECEIVE SQL0803N
IT21705IN DPF, DB2 TRAPS IN sqeDBMgr::LocalDeactivate IF A NODE FAILS AND THAT NODE IS THE CATALOG NODE FOR SOME DATABASE
IT21704DYNAMIC SQL SNAPSHOT MAY FAIL WITH SQL1224N WHEN CLIENT AND SERVER USE DIFFERENT CODEPAGE
IT21701"NET STOP" AND "NET START" DO NOT RELEASE THE QUIECE MODE
IT21695DB2READLOG API CALLERS THAT START READING FROM A GIVEN LFS/LSN THAT EXIST IN A MISSING LOG EXTENT MAY CAUSE SQL2654W
IT21691REORG, LOAD, TRUNCATE, DROP TABLE ON 10.5FP8 MAY BE SLOW WHEN DELETING PAGE ON CF
IT21679DB2IUPGRADE FAILS BECAUSE NO DB2_INSTANCE_END PORT IN SERVICES FILE.
IT21672SQL0408N ERROR FOR ALTER MODULE
IT21671SQL0408N ERROR FOR ALTER MODULE
IT21661AUTOMATIC RESTART(AR) INTERFERING WITH ROLLFORWARD CAUSES SQL1035
IT21623DB2CLUSTER -CFS -EXIT -MAINTENANCE MAY FAIL WITH RC=2
IT21605SQL0408N ERROR FOR ALTER MODULE
IT21604DB2 SERVER TERMINATES ABNORMALLY IN SQLNLS_UNPADDEDCHARLEN DURING QUERY COMPILATION
IT21593INGEST MAY USE EXCESSIVE AMOUNT FOR OVERFLOW MEMORY
IT21591SCA SEARCH AND INSERT LOGIC CAN LEAD TO A PERFORMANCE BOTTLENECKFOR AN XA WORKLOAD
IT21587DB2 TAKEOVER HADR COMMAND FAILS WITH SQL1387W IN AUTOMATED HADR ENVIRONMENT
IT21578FILEDSN IS NOT WORKING WITH V111M2FP2. DB2CLIO.DLL FAILS WITH SYSTEM ERROR 1114.
IT21576SQL0901N "NO SPACE TO INSERT KEY INTO CHT 85 0"
IT21569DURING CRASH RECOVERY, A LOG FILE MAY BY UNEXPECTEDLY OVERWRITTEN WHEN USING CIRCULAR LOGGING
IT21556DURING CRASH RECOVERY, A LOG FILE MAY BY UNEXPECTEDLY OVERWRITTEN WHEN USING CIRCULAR LOGGING
IT21553THE PRIMARY HADR DATABASE FAILS OVER TO THE STANDBY AFTER CONFIGURING FOR HA VIA DB2HAICU.
IT21539DB2ADUTL UPLOAD ALWAYS ESTIMATES BACKUP SIZE AT 4 MB
IT21535DB2ADUTL UPLOAD ALWAYS ESTIMATES BACKUP SIZE AT 4 MB
IT21530DB2CLUSTER ADD DISK TO A FILESYSTEM MAY FAIL IF THE FILESYSTEM CONTAINS A LARGE NUMBER OF DISKS
IT21517RUNNING INSPECT ON A TABLE SPACE MAY HANG CAUSING OTHER QUERIES ON THE SAME TABLE SPACE TO HANG
IT21509HASH FUNCTION FOR EMPTY BLOB RETURNS SQL0083C ERROR
IT21487DB2LOOK CORE DUMPS IN FUNCTION create_fkey_ddl
IT21485SCRIPTS FAILS WITH SQLSTATE 42702 / SQLCODE: -204
IT21468CRASH RECOVERY FAILED DUE TO MISSING OF ROR FILE
IT21467DB2ROCM CONSTANTLY CREATES DUMP FILES WHEN THE MEMBER IS STOPPED
IT21466SQL0901/SQL0404/ABEND when compiling UPDATE statement
IT21465SECURITY: DB2 CAN BE USED TO OVERWRITE ARBITRARY FILES OWNED BY DB2 INSTANCE
IT21464SECURITY: DB2 CAN BE USED TO OVERWRITE ARBITRARY FILES OWNED BY DB2 INSTANCE
IT21463SECURITY: DB2 CAN BE USED TO OVERWRITE ARBITRARY FILES OWNED BY DB2 INSTANCE
IT21462SECURITY: USER WITHOUT PROPER AUTHORITY CAN ACTIVATE DATABASE.
IT21460DB2_FMP_COMM_HEAPSZ VALUES GREATER THAN 1GB NOT HONORED
IT21459SECURITY: USER WITHOUT PROPER AUTHORITY CAN ACTIVATE DATABASE.
IT21458SECURITY: DB2 CAN BE USED TO OVERWRITE ARBITRARY FILES OWNED BY DB2 INSTANCE
IT21455SECURITY: DB2CONNECT SERVER CAN CRASH UNDER SPECIFIC CONDITIONS.
IT21454SECURITY: DB2CONNECT SERVER CAN CRASH UNDER SPECIFIC CONDITIONS.
IT21441PROCESSOR SPECIFIC OPTIMIZATIONS ARE NOT USED AS EXPECTED
IT21440INSTANCE CRASH EVENT MONITOR WHEN PERFORMING A LOAD VIA CURSOR
IT21437ON ENCRYPTED DATABASES RUNNING EXTENT MOVEMENT EXTENTLATCH HELD BY PAGE CLEANER NOT RELEASED CAUSING HANG
IT21430DB2 MAY ABEND WHILE TRACING IS ON
IT21424THE PRIMARY HADR DATABASE FAILS OVER TO THE STANDBY AFTER CONFIGURING FOR HA VIA DB2HAICU.
IT21422DB2 MAY ABEND WHILE TRACING IS ON
IT21413BLOCK DROPPING OF CF DURING ROLLING UPGRADE
IT21412INSTANCE CRASH EVENT MONITOR WHEN PERFORMING A LOAD VIA CURSOR
IT21406DB2LOOK FOR TIMESTAMP COLUMNS GENERATES TIMESTAMP(9) WHEN DEFINED ON DB2 FOR Z/OS
IT21403FLOATING POINT TO DECIMAL CONVERSION IN ORA MODE CAN RESULT IN LESS ACCURATE RESULTS FOR NUMBERS WITH LARGE SCALE
IT21402FLOATING POINT TO DECIMAL CONVERSION IN ORA MODE CAN RESULT IN LESS ACCURATE RESULTS FOR NUMBERS WITH LARGE SCALE
IT21400SERVER TERMINATES ABNORMALLY DURING QUERY EXECUTION
IT21396ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21395ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21394ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21379IN DPF OR PURESCALE, TRAP OR HANG POSSIBLE AFTER INTERRUPT OF INTERNAL SQL
IT21364ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21363UNKNOWN COLUMN NAME TYPE_NAME -4460
IT21361DB2 DOES NOT CAST THE JOIN COLUMNS CORRECTLY, LEADING TO A -901 ERROR IN CDE
IT21354JCC 4.22.29 INVALID PARAMETER: UNKNOWN COLUMN NAME TYPE_NAME. ERRORCODE=-4460
IT21347SECURITY: CONNECTION STRING DISPLAYED IN ERROR MESSAGE
IT21328FEDERATED QUERY WITH FUNCTION TEMPLATE OVER a GROUP BY or UNION may fail with -901 "No ftslpd through GB/UNION DISTINCT"
IT21327DB2 TAKEOVER HADR COMMAND FAILS WITH SQL1387W IN AUTOMATED HADR ENVIRONMENT
IT21317DB2 RESETS THE SYSLOG FACILITY TO USER
IT21315DURING NORMAL PROCESSING "ROUTINE FAILED WITH TERMINATION ERROR"ARE LOGGED AS ERROR IN DB2DIAG.LOG
IT21312In HADR, primary database could be brought down due to no heap memory is available
IT21309WRONG ERROR MESSAGE
IT21299THE CLI LOAD API MAY ABNORMALLY END (ABEND) ON CERTAIN VERSIONS OF LINUX
IT21273DB2AUDIT: USE OF UNINITIALIZED OBJECT SCHEMA IN AUDIT DATA.
IT21261DB2 MAY ABEND WHEN PLANS WITH SMP SORTS ARE INTERRUPTED
IT21260DB2 MAY ABEND WHEN PLANS WITH SMP SORTS ARE INTERRUPTED
IT21245DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES WHEN USING SQLDATAREADER
IT21244DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES WHEN USING SQLDATAREADER
IT21243DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES WHEN USING SQLDATAREADER
IT21242SQL0901N WHEN SAP MEMORY TABLE JOINS WITH UNION DISTINCT HAVING JOIN
IT21240SQL0083C - MEMORY ALLOCATION ERROR WHEN SAME COLUMN IN LOCAL ANDIN PREDICATE IN CASE STATEMENT
IT21236MEMBER PANIC DUE TO INVALID MEMORY SIZE IN SQLEINITWLDISPATCHER()
IT21235CLP MIGHT RETURN SQL1246N OR SQL1024N INTERMITTENTLY DUE TO DUPLICATE QUEUE ID.
IT21221LIST INDOUBT TRANSACTIONS MAY NOT RETURN TO PROPMT
IT21220CYCLIC JOIN IN STATISTICAL VIEW DEFINITION CAN LEAD TO CARDINALITY UNDER-ESTIMATION
IT21214WRONG TRIGGER IS BEING DROPPED FROM PACKED DESCRIPTOR RECORD IF USING LONGER SCHEMA NAME AND SAME TRIGGER NAME.
IT21211SLOW DATABASE ACTIVATION, CREATE/ALTER BUFFERPOOL, LOAD OPERATIONS ON LARGE WINDOWS SYSTEMS
IT21209SLOW MEMORY ALLOCATIONS OR POSSIBLE SEVERE DEGRADATION DURING OOM HANDLING DUE TO COALESCE MEMORY CHECK
IT21207SLOW MEMORY ALLOCATIONS OR POSSIBLE SEVERE DEGRADATION DURING OOM HANDLING DUE TO COALESCE MEMORY CHECK
IT21197SQL1233N AFTER MIGRATING NON-UNICODE, MBCS DATABASE TO 11.1.1.1 OR LATER
IT21182INTERRUPTED QUERY/SORT OPERATION CAUSES STMM TO UNNECESSARILY INCREASE SORT CONFIGURATION (SHEAPTHRES_SHR)
IT21181SUBOPTIMAL PERFORMANCE MAY PERSIST ON AN STMM-TUNED SYSTEM DUE TO LARGE CONSUMER NOT GIVING UP MEMORY
IT21177DB2AUDIT IS NOT REPORTING SQL0551N WHEN A USER WITH INSUFFICIENTAUTHORIZATION ATTEMPTS TO CALL A PROCEDURE
IT21176THE "DB2PD -CFPOOL DETAIL" COMMAND ABNORMALLY TERMINATES
IT21171CRASH RECOVERY FAILED DUE TO MISSING OF ROR FILE
IT21170DB2CMD.EXE MAY NOT WORK PROPERLY WHEN THE COMMAND LINE IS EXTREMELY LONG
IT21166SLOW ORDER BY WITH COLLATING SEQUENCE CLDR181
IT21164SECURITY: ESCALATION TO ROOT VULNERABILITY IN DB2.
IT21163SECURITY: ESCALATION TO ROOT VULNERABILITY IN DB2.

© Icons by Mark James www.famfamfam.com

invispix 10x10
invispix 10x10