Troubleshooting
Problem
On IBM Data Server Manager enterprise edition has a feature to store history data for analysis. However, user needs to apply and verify the setting to enable the history data collection properly.
Symptom
No history data being displayed even when data has been collected and Data Server Manager (DSM) enterprise license has been applied or monitored databases are AESE or PMO edition.
Cause
In-correct settings
Resolving The Problem
Following are the verification and validation user needs to do to make sure configuration-wise DSM and monitored databases are set correctly to collect and display history data:
#1. Check whether DSM repository database (default name REPODB) has been setup correctly.
#2. Check DB2 license of the monitor database. If DB2 license isn’t AESE or PMO, check whether DSM enterprise license has been applied.
#3. Check DB CFG parameters of the monitor database
mon_rtn_data base
mon_req_metrics base
mon_act_metrics base
mon_obj_metrics base
mon_uow_data base
#4. Check whether corresponding settings have been selected in Monitoring Profile -> Repository Persistent.
#5. Create table ibm_rtmon_data.hadrStateSummary
db2 "create table IBM_RTMON_DATA.\"hadrStateSummary\"(dbconn_int int,collected timestamp)"
#6. For upgrade scenario
Upgrade from previous release prior to 2.1:
- Create table ibm_rtmon_evmon.event_activity then restart DSM
(
dbconn_int integer not null,
event_id integer unique not null generated as identity
);
- Alter table Repository table IBMOTS.WORKLOAD_STATS
alter table IBMOTS.WORKLOAD_STATS add column TOTAL_RQST_TIME bigint;
- For enabling query history, modify file <install_path>/Config/dswebserver.properties as follow, then restart DSM.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21993038