Ways to disable SQL metrics for Java Agent
book
Article ID: 129894
calendar_today
Updated On:
Products
CA Application Performance Management Agent (APM / Wily / Introscope)
INTROSCOPE
Show More
Show Less
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.
Feedback
thumb_up
Yes
thumb_down
No