JDBC Providers

Track current and historical performance of all JDBC Providers on a server. Choose a cell, node and server from the drop-down menus. Each table row is a different JDBC Provider. Select a row to populate the trend graph with JDBC Provider performance metrics. Mouse over the trend graph to see metrics.

wsmon_jdbc_provs.gif

 

title_bar_shortNew00269.gif

 

Filter By:

 

 

 

Cell:

Choose the cell for which you want to show data.

 

Node:

Choose the node for which you want to show data.

 

Server:

Choose the server for which you want to show data.

JDBC Providers Table

Each table row is a different JDBC Provider.

 

JDBC Provider

The name of the JDBC Provider.

 

Open

The number of currently open connections.

 

Closed

The number of currently closed connections.

 

Created

The number of connections created since the server was last started.

 

Total

Refer to vendor documentation for details.

 

PoolSize

The number of connections in the pool.

 

Used

The number of used connections in the pool.

 

% Used

The percent of connections used in the pool.

 

Use Time

The average connection duration, in seconds.

 

Total

Refer to vendor documentation for details.

 

WaitTime

The average amount of time to establish a connection, in seconds.

 

WaitingThreadCount

The current number of threads waiting to establish a connection, in seconds.

 

description

Describes the JDBC provider.

 

TIME_STAMP

The date and time of the last data update.

JDBC Provider Trend Graph
The trend graph traces the following for the JDBC Provider on the selected server:

  • Open Count The number of currently open connections.

  • Created The number of connections created.

  • Pool Size The number of connections in the pool.

  • Used Pool The number of connections in the pool that are being used.

  • Use Time The average length of time of connections, in seconds.

 

 

Log Scale

Select to enable a logarithmic scale. Use Log Scale to see usage correlations for data with a wide range of values. For example, if a minority of your data is on a scale of tens, and a majority of your data is on a scale of thousands, the minority of your data is typically not visible in non-log scale graphs. Log Scale makes data on both scales visible by applying logarithmic values rather than actual values to the data.

 

 

Base at Zero

Use zero as the Y axis minimum for all graph traces.

 

 

Time Range

Select a time range from the drop down menu varying from 2 Minutes to Last 7 Days, or display All Data. To specify a time range, click Calendar button_calendar00270.gif.

trend_timerange00271.gif

By default, the time range end point is the current time. To change the time range end point, click Calendar button_calendar00272.gif and select a date and time from the calendar or enter the date and time in the text field using the following format: MMM dd, YYYY HH:MM. For example, Aug 21, 2011 12:24 PM.

Use the navigation arrows button_forwardback00273.gif to move forward or backward one time period. NOTE: The time period is determined by your selection from the Time Range drop-down menu.

Click Restore to Now to reset the time range end point to the current time.