Preventive Service Planning
Abstract
This document lists the fixed APARs , Known Issues (KI), and other key issues in different modifications of IBM® Db2 Data Management Console
Content
IBM Db2 Intelligence Center V1.0
12 June 2025
We’re excited to share that the new Db2 Intelligence Center (Db2IC) is now available, bringing powerful enhancements over the legacy Data Management Console. Key new features include:
• Database Assistant
• Enhanced Query Optimizer
• Database Assistant
• Enhanced Query Optimizer
• Point in time analysis
• Multi Factor Authentication (Azure)
• Replication Sets configuration
• And much more
Explore the capabilities of Db2IC using the resources below:
• Early Access Program (EAP) Download
• Early Access Program (EAP) Download
We invite you to try Db2IC today and experience the next generation of database management.
DMC is still supported, but we are not accepting new enhancements requests for DMC as Db2IC is replacing DMC.
IBM Data Management Console V3.1.13.2
30 October 2025
What is new in Version V3.1.13.2
| Known Issue | Fix Description |
| Java 21.0.8.0, Spring Framework 6.2.11, WebSphere Liberty 25.0.0.9 | |
| SQLCODE=-302 when running explain for a query with special characters | |
| DT390544 | Fixes related to several vulnerabilities |
| Fixes related to several vulnerabilities found in older DMC releases | |
| Missing code example in API documentation | |
| SQLCODE=-206 in monitor log files if the database level is 11.5.8 or older | |
| Mulitple records for 1 load utility in Utilities dashboard | |
| UC_MYMON terrible performance despite collect storage data is unselected | |
| DT244642 | Expired data deletion problems |
| DT390544 | Fixes related to several vulnerabilities |
| DT423259 | Not showing blocking SQL statement if the state of workload is UOWWAIT status |
| IT41698 | CPU aggregated data for PureScale environments |
| Adding UDA option under history tab and develop history list view page | |
| New DMC alert for Db2 CPU & Memory limit based on different Db2 license | |
| Setup improvement |
IBM Data Management Console V3.1.13.1
4 February 2025
What is new in Version V3.1.13.1
| Known Issue | Fix Description |
| dmctop V1.0.4.4 (Linux, zLinux, Windows, and AIX) | |
| Job server showing error TLSConfig.CipherSuites is missing | |
| DT423243 | Job server crashing due to GLIBC v2.34 requirement on RHEL 8 |
IBM Data Management Console V3.1.13
24 January 2025
What is new in Version V3.1.13
| Known Issue | Fix Description |
| Vulnerabilities found in V3.1.12 | WebSphere Liberty version upgraded to 24.0.0.9, Spring Framework upgraded to 6.0.17, and other fixes related to vulnerabilities |
| New feature | TLS v1.3 support |
| New feature | SNMP engine ID feature enhancement |
| Unable to run jobs due to missing credentials in integration.apikey file | |
| Ended jobs showing as still running | |
| Not able to use a different date for custom performance report | |
| Garbled characters occur in Japanese/Chinese/Korean language when downloading the report as PDF | |
| Error exporting report using XLSX file format | |
| Increase the size of drop down list for workload selection in Timespent page | |
| Additional information to collect incidents from alerts | |
| DT214301 | Concurrency issue for runSQL API |
| DT214921 | Notification center not showing detailed alert information |
| DT233389 | Statistics are no longer updated after running dmctop for a while |
| DT241125 | Job server fails to send emails, with non-TLS option |
| DT245190 | null value in this.estDiskUsed error while opening a tuning result |
| DT246723 | Replication information missing after V3.1.12 migration |
| DT247752 | Unable to see alert recommendation using browser dark mode |
| DT255178 | Unable to load job page if the repository database is using SSL connection |
| DT259113 | Missing performance data if the monitored database has a special build |
| DT270134 | Losing unsaved changes in SQL Editor if tab is closed |
| DT383200 | Job names cannot be edited if they previously contained a "." in their name prior to v3.1.12 |
| DT390471 | Custom alert showing truncated alert number |
| DT391601 | Microsoft tools like Services may display wrong status of DMC service |
| DT393212 | Query tuning for big queries resulting empty results |
| DT398559 | Script included in SNMP trap for custom alerts |
IBM Data Management Console V3.1.12
23 October 2023
What is new in Version V3.1.12
| Known Issue | Fix Description |
| DT214915 | Tuning gets error for Db2 DPF environments |
| DT222223 | Internal Error IOException converting connection profile to JSON format |
| DT222914 | Email password with special characters is saved incorrectly |
| DT223025 | Alert email notifications not received due to timeout exception and mail server not found |
| DT224675 | Monitoring query might cause db2fmp errors in db2diag.log in DPF environments |
| DT245840 | Jobs show com.jcraft.jsch.JSchException error message |
| IT43433 | Missing tables in scripts to delete old data |
IBM Data Management Console V3.1.11
22 March 2023
What is new in Version V3.1.11
| APAR | Fix Description |
| IT41098 | Utilities event monitor not capturing end-time |
| IT42841 | Database availability alert time is not the DMC server UTC time |
| IT42876 | Missing Edit option in Job Chain |
| IT42915 | Remove vulnerability issues found in 3.1.9 and 3.1.10 releases |
| IT43078 | Wrong column sorting |
IBM Data Management Console V3.1.10
16 December 2022
What is new in Version V3.1.10
| APAR | Fix Description |
| IT40535 | Deleted monitoring profiles migrated from DSM appear again after DMC restart |
| IT40978 | Query tuner failure when SQL text is not persisted in the repository database |
| IT41299 | Jobs overlapping |
| IT41313 | "An internal error has occurred" error message |
| IT41605 | Databases appear to be “disconnected” while the connection is successful |
| IT41970 | Change email the sender from noreply-monitor-report@ibm.com to the sender configured in the email configuration |
| IT41992 | SQL statement window empty if persistence configuration is off |
| IT42116 | Column names are truncated in the PDF report |
| IT42119 | Query Tuner authentication error if personal credentials are not saved in the repository database |
| IT42149 | Query with special characters shows syntax error in SQL statement window |
| IT42335 | Incorrect package cache metrics after 3.1.9 |
| IT42436 | Monitoring profile -3 not migrated from DSM |
| IT42437 | Incorrect UDA schedule |
| IT42460 | Increase script size limitation for JOB/UDA |
| IT42492 | Change the blackout API message to "full_blackout", "monitor_and_alert_blackout", or "alert_only_blackout" |
| IT42503 | Edit job runtime error for a job migrated from DSM |
| IT42628 | Showing the wrong time for the last job run in a job chain |
| IT42730 | SQL tuning errors for federated queries |
IBM Data Management Console V3.1.9
26 September 2022
| APAR | Fix Description |
| IT40773 | Job server crashes on AIX with P7_compat mode |
| IT41523 | SNMP not generating alerts in SNOW format |
| IT41524 | Pasting script in UDA definition generates wrong return error |
| IT41572 | Remove vulnerability Sweet 32 CVE-2016-2183 from Job Server |
| IT41575 | Schedule and job chain errors during the job migration from DSM |
| IT41606 | No cleanup of table TBSPACE_UTILIZATION |
| IT41792 | Connection profile creation causes HADR log replay condition |
| IT41793 | LDAP Bind errors after 3.1.8 |
| IT41885 | Change job email subject to use the same format from other alerts |
| IT41886 | Improvement in the repository database pruning batch rows to avoid -964 (transaction log full) and -952 (time out) error messages |
| IT41925 | Remove not log initially from event monitor tables for HADR databases |
| IT42068 | Performance improvement for storage KPI collection query |
| IT42069 | Job chain failure with securityMechanism!=3 |
| IT42070 | Invalid date for blackout scheduler |
| IT42071 | Skip permission check for scheduled job chain |
| IT42072 | Database availability alert if standby database has replay window active |
| IT42073 | Improve error message for user test connection when repository database is configured with restrict access = YES |
| IT42117 | Queries to capture performance data cause locks on the monitored database |
| IT42118 | Logon error when the user format is \DOMAIN\USER |
IBM Data Management Console V3.1.8
27 June 2022
| APAR | Fix Description |
| IT38910 | Remove data from a deleted monitored database |
| IT38938 | Improvements on pruning IBMCONSOLE."unitsOfWorks" repository table |
| IT38974 | Upgrade from DSM to DMC does not migrate truststore specified by LDAP setting |
| IT39633 | Create a stop button to cancel a job |
| IT39639 | API to update repository database information |
| IT39782 | No data when user name length is greater than 32 characters |
| IT40031 | Connection page blank if client application name is > 128 characters |
| IT40156 | DMCTOP member flag (-m) does not work as expect during the initialization process| |
| IT40155 | Report freezes after custom start date |
| IT40157 | DMCTOP hangs on DPF environment when member number does not start with 0 |
| IT40355 | Add database and instance name environment variables for jobs |
| IT40533 | CLI0157E Error opening a file. SQLSTATE=HY507 when use SSL connection for job repository |
| IT40534 | Log space Usage showing 100% with LOGSECOND -1 |
| IT40536 | Storage in the home page shows 100% while the database file systems are not full |
| IT40675 | Not showing the Memory/Storage information SQLCODE=-873, SQLSTATE=53090 |
| IT40690 | Missing connection profile name in the Script Library tab under run SQL |
| IT40754 | Job error: Client.Timeout exceeded while awaiting headers |
| IT40772 | DMCTOP table movements do not show running status and truncation of Copy_total_rows value |
| IT40830 | Upgrading Spring framework version to 5.3.19 due to CVE-2022-22950 |
| IT40854 | Set the http server to support the TLSv1.2 or later |
| IT40855 | NPE error when a new database is added that uses an old connection name |
| IT40942 | DMCTOP switch problem between pureScale members and display correct hostname |
| IT40955 | Enhance to prune activity event monitors when the connection termination happens |
| IT41194 | DMCTOP displays wrong numbers for Throughput -> Time spent |
| IT41297 | DMCTOP Table_Movement numbers aligned to the right |
| IT41298 | DMCTOP showing wrong query |
IBM Data Management Console V3.1.7.1
21 March 2022
| APAR | Fix Description |
| IT39937 | Scheduled jobs switch date format |
| IT40029 | StatisticsAdvisorForLUW$SAThread.run error during query tuner |
| IT40032 | Blank Top consumer page due to insufficient statement heap |
| IT40086 | Summary > Resource usage > Storage widget for nonautomatic storage group |
| IT40087 | Updating shared credentials is erasing monitoring credentials |
| IT40206 | Job is always returning success status |
| IT40706 | Running Jobs or Custom Alerts with Shell scripts when shell script content is in the shell script box |
| Performance enhancement for proxy request |
IBM Data Management Console V3.1.7
19 January 2022
| APAR | Fix Description |
| IT38138 | Error when data is inserted into ibm_rtmon_data.resource_storagegroup |
| IT38892 | Update database status when a pureScale database comes back from unavailable status |
| IT39037 | No email alerts for scheduled jobs |
| IT39143 | Change email alerts from report to work the same way as the email from jobs |
| IT39260 | Allowing customized certificate and private key to start job HTTPS server |
| IT39400 | Allowing SSL certification file name for the repository connection |
| IT39472 | Unable to add new jobs |
| IT39535 | Delete blackout job definition and history when a connection profile is deleted |
| IT39600 | Duplicated event monitor profiles |
| IT39601 | Delete monitoring profile when a connection profile is deleted |
| IT39603 | Not able to run several jobs at the same time |
| IT39651 | Run SQL not generating output with export as xlsx option |
| IT39714 | Slow daily report generation and download |
| IT39717 | DMCTOP does not show tables list |
IBM Data Management Console V3.1.6.1
28 November 2021
What is new in Version V3.1.6.1
| APAR | Fix Description |
| IT39065 | SSL connection fails after V3.1.6 migration |
IBM Data Management Console V3.1.6
1 November 2021
| APAR | Fix Description |
| IT38126 | No license for DB2 Workload Management errors |
| IT38820 | Added package cache version and individual execution panels |
| IT38821 | Alerts not generating hostnames in SNMP trap |
| IT38896 | Deadlocks caused by event monitors, causes activity event monitor table space size to grow |
| IT38897 | Hanging during the upgrade to 3.1.5.1 |
| IT38898 | SQLCODE=-104 error if ONLINERECOVERY is selected from event monitor utility |
| IT38899 | Shell script jobs do not change status until reaches timeout configuration |
| IT38912 | Data > Workload page shows subsets of workloads only |
| IT38913 | ERRORCODE=-4461 error message in DS_System.0 log file |
| IT38914 | Migration failed due to BLOCKNONLOGGED configuration set to YES in DB CFG for the repository database |
| IT38920 | The report for CPU, Memory resources on DPF system is not clear |
| IT38972 | Column sorting is incorrect on the home page |
| IT38975 | Searching a connection in the monitor profile resets the existing selected connection list |
| IT38976 | Data > Table or Data > Index or other objects can show 100 entries only |
IBM Data Management Console V3.1.5.1
22 August 2021
What is new in Version 3.1.5.1
| APAR | Fix Description |
| IT38122 | HWCCON0003E: Failed to call connection restful API /dbapi/v4/dbprofiles error |
| IT38125 | Stored procedure with timestamp parameters is failing |
| IT38127 | Jobs creator saved with lowercase |
| IT38128 | Jobs errors when schedule is 12:00 AM or 12:00 PM |
| IT38129 | REP_ERR occurred: SQLCODE = -138, SQLSTATE=22011, DRIVER=4.27.25 error |
| IT38131 | Blank top consumer page SQLCODE=-101, SQLSTATE=54001, DRIVER=4.27.25 |
| IT38133 | Event Monitor profile create table space cannot find table space from drop-down list |
| IT38134 | Cannot change the execution schedule for some UDA migrated jobs from DSM to DMC 3.1.5 |
| IT38135 | Duplicated values for index key for repository table TBSPACE_CONT_UTILIZATION, SQLCODE=-803 |
| IT38136 | Support for different notification statuses in Jobs and UDA |
| IT38137 | Extra security requirements added |
| IT38138 | Error when data is inserted into ibm_rtmon_data.resource_storagegroup |
| IT38139 | The udaMigration.sh script does not take secured (https) port |
| IT38140 | Support for timeout settings in Jobs |
| IT38142 | Wrong truncated message in SQL Editor |
IBM Data Management Console V3.1.5
20 June 2021
IBM Data Management Console V3.1.4
18 February 2021
IBM Data Management Console V3.1.3
4 November 2020
| APAR | Fix Description |
| IT32686 | Large amount of data in IBM_RTMON.ACTIVITY table |
| IT33717 | Sending wrong secondary log alerts |
IBM Data Management Console V3.1.2
19 June 2020
| APAR | Fix Description |
| IT31934 | Wrong alert for num_iocleaners and num_ioservers |
| IT31951 | Application connections with excessive lock wait over request time in seconds instead of milliseconds |
| IT32021 | Wrong dates when Oracle compatible configuration is on for the monitored database |
| IT32076 | Shows ERRORCODE=-952, SQLSTATE=57014 error |
| IT32077 | Shows SQLCODE=-206, SQLSTATE=42703 error |
| IT32480 | DIA8050E Event monitor already active or inactive messages in db2diag.log |
| IT32625 | Large amount of data in IBMCONSOLE.SQL_FACT table |
| IT33123 | The drs-agent is consuming 99-100 % cpu all the time |
IBM Data Management Console V3.1.1
23 January 2020
None
IBM Data Management Console V3.1.0
18 October 2019
None
Known issues
Here is a list of known issues, which has an APAR tracking the problem. Refer to the DMC Product Defect List for a list of known defects.
The issues will be fixed in a future release of DMC.
There is no estimated date of when the fixes are going to be available.
| APAR | Fix Description |
| IT39716 | Event monitors recreation is increasing recovery history file db2rhist.asc size |
| IT42187 | Statement alerts not closing when the query is not running anymore |
| IT43182 | Table performance misleading column names |
| IT43230 | Collecting storage data after storage data collection is disabled |
| IT43464 | Looking for 'IBMCONSOLE.RECORD_REPOSITORY_USAGE' table on the monitored databases |
| IT43465 | Inconsistencies in Lock Waits Per Min graph |
| IT43472 | Custom alerts not sending query output for SNMP trap |
| IT43504 | Remove vulnerability issues found in 3.1.11 |
| IT43563 | Unexpected password validation warning messages were logged at DMC Blackout starting timing on monitoring servers |
| IT43778 | Java reflection errors cause performance issues in query tuner |
| IT43882 | Remove Apache vulnerability |
Related Links
IBM Db2 Data Management Console - System Requirements
What's new in IBM Db2 Data Management Console
Downloading and Installing IBM Db2 Data Management Console 3.1.x
Upgrade IBM Db2 Data Management Console to the latest release or interim fix
More links
IBM Db2 Data Management Console Community
IBM Db2 Data Management Console Documentation
Db2 Data Management Console & Db2 Data Server Manager Roadmap
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFQ7S","label":"IBM Db2 Data Management Console"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF017","label":"Mac OS"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Was this topic helpful?
Document Information
Modified date:
19 November 2025
UID
ibm13152541