ODBC Resource Statistics Test

The Open Database Connectivity (ODBC) is a standard application programming interface (API) used for accessing data in both relational and non-relational database management systems. By using this API, database applications can access data stored in database management systems on various computers, even if each database management system uses a different data storage format and programming interface. Often administrators may want to figure out how well the ODBC DSN is utilized in the target environment. The ODBC Resource Statistics test exactly helps administrators identify the same! This test auto discovers the ODBC DSNs integrated with the IBM Integration Bus and for each ODBC DSN, reports the numerical statistics of the following:

  • Successful execution of the statements
  • Statements that failed execution
  • Active connections
  • Closed connections
  • Connections that are experiencing errors etc

Target of the test : An IBM Integration Bus

Agent deploying the test : An internal/remote agent.

Outputs of the test : One set of results for each ODBC DSN integrated with the IBM Integration Bus that is to be monitored.

Configurable parameters for the test
Parameters Description

Test period

How often should the test be executed.

Host

The host for which the test is to be configured.

Port

The port on which the specified host listens.

JNDI Namespace Location

Indicate where the JNDI namespace has been created. For this, select one of the following options: File or LDAP. Select File if the JNDI namespace is created in the same location as that of the IIB server.

SSL

If you have chosen LDAP as the JNDI Namespace Location wherein the LDAP server communicating with the IIB server that is to be monitored is an SSL-enabled server, then set the SSL flag to Yes. By default, this flag is set to No.

User DN and Password

Here, provide the credentials of the Active Directory user created as explained in Creating a user in the Active Directory server, if the target IIB server is monitored in an agentless manner. If the IIB server is to be monitored in an agent based manner, specify none against these parameters.

Confirm Password

Confirm the Password by retyping it in this text box.

JNDI Provider URL

Specify the URL that was specified as the provider URL while creating the initial context. To know the Provider URL, refer to Agent based monitoring of the IIB server if you choose to monitor the target IIB server in an agent based manner and Agentless Monitoring of the IIB server if you chose to monitor the target IIB server in an agentless manner.

TopicConnectionFactory

Specify the name of the connection factory in this text box. If you have chosen to monitor the target IIB server in an agent-based manner, refer to Creating a Connection Factory and if you have chosen to monitor the target IIB server in an agentless manner, refer to Creating a Connection Factory.

JMS Resource Stats

Specify the name of the JMS destination that you have created for storing the Resource statistics. If you chose to monitor the target IIB server in an agentless manner, refer to Creating the JMS Destinations and if you choose to monitor the target IIB server in an agent based manner, refer to Agent based monitoring of the IIB server.

JMS Flow Stats

Specify the name of the JMS destination that you have created for storing the Message flow statistics. If you chose to monitor the target IIB server in an agentless manner, refer to Creating the JMS Destinations and if you choose to monitor the target IIB server in an agent based manner, refer to Agent based monitoring of the IIB server.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Successful execution rate

Indicates the number of times statements were executed successfully through this ODBC DSN during the last measurement period.

Number

A high value is desired for this measure.

Failed execution rate

Indicates the number of times statements failed to execute through this ODBC DSN during the last measurement period.

Number

Ideally, the value of this measure should be zero.

Total Execution rate

Indicates the total number of times statements were executed through this ODBC DSN during the last measurement period.

Number

The value of this measure is cumulative of the Successful execution rate and the Failed execution rate measures.

Active connections

Indicates the number of connections that were open to this ODBC DSN during the last measurement period.

Number

 

Closed connections

Indicates the number of connections to this ODBC DSN that were closed during the last measurement period.

Number

The value of this measure includes the connections that were closed due to errors, connections forced to close by the DBMS and the connections closed by the broker because the connections were no longer required.

Connection errors

Indicates the number of times the connections to this ODBC DSN were error prone during the last measurement period.

Number

A low value is desired for this measure.