IBM Support

Technotes (FAQs and troubleshooting tips) for IBM Data Server Manager

Troubleshooting


Problem

Technotes (FAQs and troubleshooting tips) for IBM Data Server Manager

Resolving The Problem

Title Doc Link
Installing and upgrading IBM Data Server Manager http://www.ibm.com/support/docview.wss?uid=swg21991171
Installing and upgrading IBM Data Server Manager Version 2.1.3 and above http://www.ibm.com/support/docview.wss?uid=swg21999208
Supported platforms for IBM Data Server Manager http://www.ibm.com/support/docview.wss?uid=swg22000006
Upgrade Notice for Data Server Manager v2.1.5: Unexpected characters on the console UI after I migrated from DSM v2.1.4

http://www.ibm.com/support/docview.wss?uid=swg22012705

Known Issue for IBM Data Server Manager: Monitoring data might be lost when monitoring more than 260 databases http://www.ibm.com/support/docview.wss?uid=swg22017355
Troubleshooting the "Failed to log in to the remote dashDB Local console." message in DSM 2.1.4 http://www.ibm.com/support/docview.wss?uid=swg22005115
Troubleshooting the "SSL connection failed" message since DSM 2.1.4 http://www.ibm.com/support/docview.wss?uid=swg22004853
Secure Socket Layer (SSL) Configuration for Data Server Manager (DSM) http://www.ibm.com/support/docview.wss?uid=swg21997164
Explain does not work for SQL if they have special host variable in IBM Data Server Manager http://www.ibm.com/support/docview.wss?uid=swg22002584
DSM configurations for enabling Kerberos JDBC security connection http://www.ibm.com/support/docview.wss?uid=swg22000485
Data Server Manager (DSM) server reports Out of Memory errors http://www.ibm.com/support/docview.wss?uid=swg21990746
Data Server Manager (DSM) shows "Log Out - Your web session has expired due to an idle timeout" error http://www.ibm.com/support/docview.wss?uid=swg21990462
Data Server Manager (DSM) shows zero values as metrics http://www.ibm.com/support/docview.wss?uid=swg21990104
Data Server Manager (DSM) does not show historical data http://www.ibm.com/support/docview.wss?uid=swg21990109
Verifying and validating history data collection setting in IBM Data Server Manager http://www.ibm.com/support/docview.wss?uid=swg21993038
Memory parameter calculation on IBM Data Server Manager home page http://www.ibm.com/support/docview.wss?uid=swg21986799
Configuring LDAP authentication in Data Server Manager (DSM) http://www.ibm.com/support/docview.wss?uid=swg21997153
Managing DSM administrator accounts with LDAP http://www.ibm.com/support/docview.wss?uid=swg21995672
Data Server Manager (DSM) and HTTPS to access DSM Server http://www.ibm.com/support/docview.wss?uid=swg21989068
How to configure SSH for Data Server Manager http://www.ibm.com/support/docview.wss?uid=swg21960639
How to recreate the internal Derby database for Data Server Manager (DSM)? http://www.ibm.com/support/docview.wss?uid=swg21988408
How to reset the userid/password to connect to the Data Server Manager (DSM) repository database? http://www.ibm.com/support/docview.wss?uid=swg21985799
How to setup nginx to pass firewall for Data Server Manager

http://www.ibm.com/support/docview.wss?uid=swg22005263

Adding JDBC properties for a database connection in Data Server Manager (DSM) http://www.ibm.com/support/docview.wss?uid=swg21989378
Adding and updating connection profiles from the command line http://www.ibm.com/support/docview.wss?uid=swg21963035
IBM Data Sever Manager (DSM) update connection credential via commandline http://www.ibm.com/support/docview.wss?uid=swg21986395
IBM Data Sever Manager (DSM) update/create monitored db profile via commandline http://www.ibm.com/support/docview.wss?uid=swg21986397
Data Server Manager (DSM) showing SQLCODE=-206 "<name> is not valid in the context where it is used." http://www.ibm.com/support/docview.wss?uid=swg21983739
Data Server Manager (DSM) showing SQLCODE=-206 "T1.TOTAL_RQST_TIME" is not valid in the context where it is used http://www.ibm.com/support/docview.wss?uid=swg21979616
Data Server Manager (DSM) showing "QUERYTUNER.OQWT_QUERY_RESULT" is an undefined name SQLCODE=-204, SQLSTATE=42704 error http://www.ibm.com/support/docview.wss?uid=swg21984534
Data Server Manager (DSM) shows "IBM_RTMON_EVMON.EVENT_ACTIVITY" is an undefined name.. SQLCODE=-204, SQLSTATE=42704 error http://www.ibm.com/support/docview.wss?uid=swg21990051
Data Server Manager (DSM) shows "Invalid Credentials" status for a monitored database http://www.ibm.com/support/docview.wss?uid=swg21984623
IBM Data Server Manager is showing "Unsupported Version" for a monitored database http://www.ibm.com/support/docview.wss?uid=swg21979423
Enabling query history for individual executions in DSM v2.1 http://www.ibm.com/support/docview.wss?uid=swg21984962
Explain query from Data Server Manager (DSM) fails with warning SQL20459W http://www.ibm.com/support/docview.wss?uid=swg22009012
Known Issue for Data Server Manager: CPU utilization cannot be determined for IBM DB2 v9.7 prior to fix pack 10 on IBM AIX http://www.ibm.com/support/docview.wss?uid=swg21960417

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS5Q8A","label":"IBM Data Server Manager"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"2.1.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
18 December 2019

UID

ibm10884264