Ways to disable SQL metrics for Java Agent

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

This articles intent to explain some ways to disable SQL metrics for Java Agent.

Environment

Any Introscope Java Agent release.

Resolution

OPTION 1
Try to disable it inside Agent.Profile by leaving below Agent section as below:

introscope.agent.sqlagent.sql.turnoffmetrics=true 
introscope.agent.sqlagent.sql.artonly=false 
introscope.agent.sqlagent.sql.turnofftrace=true 
introscope.agent.sqlagent.sql.rawsql=false 

OPTION 2

1) Open your Agent.Profile 
2) Go to "Directives Files" it is calling something as "APPLICATION-typical.pbl" 
3) Open the file corresponding to the listed inside "Directives Files", once more, should be something like "APPLICATION-typical.pbl" 
4) Inside search for "Directives Files" as well, you will see a series of PDB, as like these: 

> toggles-typical.pbd 
> required.pbd 
> apm-common.pbd 
> java${JVMCOMPATIBILITY}socket.pbd 
> jvm.pbd 
> j2ee.pbd 
> java2.pbd 
> struts.pbd 
> taglibs.pbd 
> oraclejdbc.pbd 
> sqlagent.pbd 
> errors.pbd 
> jboss4x.pbd 
> jsf-toggles-typical.pbd 
> jsf.pbd 
> biz-trx-http.pbd 
> appmap.pbd 
> appmap-ejb.pbd 
> #bizrecording.pbd 
> di.pbd 
> intelligent.pbd 
> endUserEndpoints.pbd 
> httpcorrelation.pbd 
> httpbackendmetrics.pbd 
> appmap-http.pbd 
> jms.pbd 

5) Comment the "sqlagent.pbd" and "oraclejdbc.pbd ", it will stay as this way: 

#sqlagent.pbd 
#oraclejdbc.pbd 

6) Save the file. 
7) Restart the application, you should not see these metrics anymore.