APM v8.1.2: No data in "Slow SQL Statements " for UD agent
Albook 120000625S Visits (6355)
I have recently worked on an a problem regarding UD agent data collection where the DB2 agent was connected to an APM v8.1.2 infrastructure.
This was one of my first experience on APM v8 but I noticed something that I liked very much if compared with the ITM v6 world : the agent logs are really helpful even without activating specific diagnostic traces and this resulted in a quick and effective problem determination.
For example, in this case, after having installed the UD agent on the target server, we were able to see data for all the expected widgets, but one:
the "Slow SQL Statements - Top 5" was returning no data, just an empty box with message "No items to display".
For this kind of scenarios, the first component that needs to be investigated is the agent itself, to verify whether it is able to collect monitoring data or not.
First of all, let's have a look at the asfActivity log file.
In this file we can find rows containing data that is sent by the agent to the APM servers.
The rows look like:
1160530095418000 SEND: <ENV