ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

What are the steps required to configure Spectrum SQL Test to test a MS SQL query.

book

Article ID: 237146

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

We require to configure a Service Performance Manager (SPM) SQL Query Test (CA SystemEDGE) in Spectrum, What would be the steps necessary for that other than creating the test in Spectrum.

Cause

SQL Query tests are for SystemEDGE hosts only.

Environment

Release : 20.2

Component : Spectrum Applications

Resolution

Instructions on how to configure the SystemEDGE agent to run SQL Query test, can be obtained from SystemEDGE documentation.

For MS SQL, you can do next:

1. Change to the Install_Path/SystemEDGE/jre/lib/ext directory.
2. Check, if sqljdbc41.jar is available.
   
    If the SQL JDBC is not available, perform the following steps:
      2.1 Download the SQL JDBC 4.2 driver from https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#42
            The latest version that will work with SystemEDGE 5.9 is SQL JDBC driver 4.1, but that jar is contained in the 4.2 package.   
            The direct download link is here or here        
      2.2 Extract the downloaded driver package and copy <package>\sqljdbc_4.2\enu\jre7\sqljdbc41.jar to the Install_Path/SystemEDGE/jre/lib/ext directory.
      2.3 Restart SystemEDGE to load the new Java classes.

3. Set up a new SQL tests, from Spectrum OneClick console. Next an example:

* SQL Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
* Connect String: jdbc:sqlserver://192.168.1.170:1433;databaseName=CA_UIM;user=sa;password=RVDu!n9<

 

Attachments