We have java agents in few servers(AIX) and they are able to fetch the information like to which DB it is connecting and the queries executed like that even though we don't have agents in DB server.
But recently we have installed java agents in LInux and it is not able to fetch the one level down information like to which DB it is connecting, queries and all.
Can you please tell why this is happening.
Yes, this information is collected because JDBC or ADO.NET communication interfaces are monitored by default sensors packs.
Do you know what database you want to monitor and what communication interfaces the databases use?
For custom applications, sometimes you may need to configure a custom sensor. https://www.dynatrace.com/support/doc/appmon/administration/sensor-configuration/