I configured Cognos to be monitored by CA APM but in Backend I did not get the database backend in Backends list, but I got something like Unknown Driver:
the datawarehouse database is installed in AS400 OS.
can some help, it is urgent please because I need to get SQL requests going to DB?
It looks like the AppServer datasource defined for the Cognos database is using an unsupported driver.
You can view the supported driver list in the SQL Agent section of the Agents sheet in the Compatibility Guides: CA Application Performance Management Compatibility Guides - CA Technologies
What RDBMS & driver is being used?
for datasource they are using DB2 installed on AS400 system.
for the driver do you know how to check the driver type?
I think they are using DB2 driver see bellow links: http://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.dyn_query.10.2.1.doc/t_dqm_conn_db2_zos.html?lang=fr
is it not supported by APM 10.1?
what we can do to monitor this backend?
I am looking at the 10.1 Compatibility Guide which Lynn has the link above. I see Sysview for DB2. Looking under APM agent tab for SQL Agent, I see only Oracle and SQL Server listed. Including Lynn to describe your alternatives.
If you turn ON the debug on the agent side & start with fresh sets of logs, it will give you some more hints about the class name. That might be helpful to understand the type of DB driver being used here
I am getting this traces in Agent log:
> # Skips for Sybase JConnect 5.x, 4.x drivers
> # This class implements Statement but its impementation is dummy.
> # We will see Unknown Driver node if this class is instrumented
> SkipClassForFlag: com.sybase.jdbc2.jdbc.SybLiteral SQLAgentStatements
> SkipClassForFlag: com.sybase.jdbc3.jdbc.SybLiteral SQLAgentStatements
> TraceOneMethodWithParametersIfFlagged: SQLJSQLAgentRTStatements executeRTQuery()Lsqlj/runtime/profile/RTResultSet; SQLBackendTracer "Unknown Driver"
> TraceOneMethodWithParametersIfFlagged: SQLJSQLAgentRTStatements execute()Z SQLBackendTracer "Unknown Driver"
> TraceOneMethodWithParametersIfFlagged: SQLJSQLAgentRTStatements executeUpdate()I SQLBackendTracer "Unknown Driver"
> TraceOneMethodWithParametersIfFlagged: SQLJSQLAgentRTStatements setObject(ILjava/lang/Object;)V SQLBackendTracer "Unknown Driver"
the client use the bellow driver:
That last screenshot is for an ODBC driver, but the problem relates to the JDBC driver used in the AppServer datasource definition.
As far as I know the APM Java agent won't be able to monitor DB2 or any database via an ODBC driver connection.
I don't know much about Cognos but from these links link it seems that Tomcat is only used for part of it & the ODBC connection is part of a different tier to the Application tier:
IBM Cognos Proven Practices: IBM Cognos Express 9.5 Troubleshooting
Cognos 10 JDBC Support - Toolbox for IT Groups
Adding Guenter_Grossberger & Hiko_Davis to see if they have alternative ideas for monitoring using APM
Or it may need a UIM/Nimsoft DB probe:
db2 (DB2 Database Monitoring) Release Notes - CA Unified Infrastructure Management Probes - CA Technologies Documentatio…
Here is a TEC Doc I asked CA Support to whip up and post it. Thank huaba01 for taking care of this.
How to monitor Cognos 11 and avoid instrumentation failures.
FYI I created the KD after independently being requested by Engineering.huaba01 is more than welcome to add updates to that KD based on this thread since a lot of the above is not included.
can you provide the KD link?
Here you go How to monitor Cognos 11 and avoid instrumentation failures. This is the same one you listed above Manish.