TEC1735028: Querying the Smartstor database using Introscope JDBC

Document created by SergioMorales Employee on May 27, 2016Last modified by J.J. Lovett on May 27, 2016
Version 2Show Document
  • View in full screen mode

Document ID:  TEC1735028

Last Modified Date:  2/2/2015
Authored By: SergioMorales

  • Products
    • CA Application Performance Management
  • Releases
    • CA Application Performance Management:Release:9.1 SP2
    • CA Application Performance Management:Release:9.1.0
    • CA Application Performance Management:Release:9.08
    • CA Application Performance Management:Release:9.5
    • CA Application Performance Management:Release:9.6
    • CA Application Performance Management:Release:CA APM 9.5
    • CA Application Performance Management:Release:CA APM 9.6
    • CA Application Performance Management:Release:CA APM 9.7
    • CA Application Performance Management:Release:8.2
    • CA Application Performance Management:Release:8.0
  • Components
    • DATA API
    • INTROSCOPE
    • INTROSCOPE SDK

 

The below example demonstrate how to query the Introscope Smartstor database using Introscope JDBC

Step 1: Download the below files to a temporal location:

QuerySS.java

run.bat.txt

IntroscopeJDBC.jar, available from the Introscope EM\lib directory

Step 2: Rename run.bat.txt as run.bat, open the file and update the location of the JAVA_HOME and CLASSPATH environment variables as appropriate.

Step 3: Open QuerySS.java and enable the appropriate section. You have 2 possibilities:

a) Use the java variables to define the filters

 

image: http://search.ca.com/assets/SiteAssets/TEC1735028_Embeded/4.png

4.png

Output:

 

image: http://search.ca.com/assets/SiteAssets/TEC1735028_Embeded/1.png

1.png

b) Define explicitly the query

 

image: http://search.ca.com/assets/SiteAssets/TEC1735028_Embeded/2.png

2.png

Output:

 

image: http://search.ca.com/assets/SiteAssets/TEC1735028_Embeded/3.png

3.png

 

Search the Entire CA APM Knowledge Base

 

search-kb.jpg

Attachments

    Outcomes