CA Unified Infrastructure Management Probes
The Java Database Connectivity SQL Queries Response Monitoring (jdbc_response) probe monitors JDBC database www.cronistalascolonias.com.ar probe executes custom SQL queries to the database servers through the JDBC client interface, and measures the response time.
The Java Database Connectivity SQL Queries Response Monitoring (jdbc_response) probe monitors JDBC database www.cronistalascolonias.com.ar probe executes custom SQL queries to the database servers through the JDBC client interface, and measures the response time.
The probe currently supports monitoring SQL queries on the following databases:
- IBM DB2
- IBM Informix
This section describes the revision history for the jdbc_response probe.
Support case(s) may not be viewable to all customers.
|
|
|
Fixed a defect in which the probe did not generate any QoS data on the Linux systems even though the alarms were triggered. |
Fixed a defect in which the connection error alarm did not clear after the connection is successfully established. |
|
Upgraded the probe to support PostgreSQL database for monitoring. |
|
Fixed SOC issues for Password Added clear alarm for connection error. |
|
|
Please note that the QoS names have been changed since the Beta version as follows:
|
(From Version ) Access Prerequisites
For postgreSQL MCS profile, a user must have at least the following two privileges on the database:
Probe Specific Hardware Requirements
The jdbc_response probe should be installed on systems with the following minimum resources:
- Memory: GB of RAM. This probe OOTB configuration requires MB of RAM.
- CPU: 3 GHz dual-core processor, bit or bit
Probe Specific Software Requirements
The jdbc_response probe requires the following software environment:
- CA Unified Infrastructure Management or later
- Robot version or later (recommended)
- Probe Provisioning Manager (PPM) version or later (required for Admin Console)
- Java JRE 6 or later (required for Admin Console)
The jdbc_response probe, by default, installs the JDBC drivers for Microsoft SQL Server and Oracle databases. To monitor other databases, the appropriate driver, as a JAR file, must be downloaded and stored on a system from where the probe can access it.
For making connections and running SQL queries, a User name and Password is required for the databases being monitored.
Download the drivers for the following databases and store at the default location of the driver files. The default location of the JDBC driver JAR file is [CA UIM Installation Directory]
\probes\database\jdbc_response\lib
folder.- IBM DB2: Download the latest version of IBM DB2 JDBC driver JAR file from www.cronistalascolonias.com.ar
- IBM Informix: Search for and download the latest version of IBM Informix JDBC driver JAR file from www.cronistalascolonias.com.arYou must register on the IBM website before you can download the IBM DB2 or IBM Informix driver JAR files.
- MySQL: Download the latest version of MySQL JDBC driver JAR file from www.cronistalascolonias.com.ar
- PostgreSQL: Download the latest version of PostgreSQL JDBC driver JAR file from www.cronistalascolonias.com.ar
Restart the probe after storing the driver files in the probe installation directory.
-
-
-