IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

Data sources attributes

The Data sources attributes provide database usage information.

These attributes provide traffic information such as, response times for database requests, the frequencies at which database connections are created and destroyed, and how often databases are being accessed. The attributes within this group are used to build the Datasources workspace.

The attributes within this attribute group contain meaningful values only if your site has set the request data monitoring level to Level2 to collect data on data source requests.

Application ID

The unique identifier that is assigned automatically when the application is first configured and is preserved during the whole application life cycle. Format is positive integer or -1 which means that Application ID

is aggregated statistic for all applications.

ASID

The identifier (decimal) assigned to the address space running this servant region.

Average Processing Time (ms)

The total average processing time (in milliseconds) that the data source is used by an application. Format is decimal (formatted to 3 decimal places).

Average Query Processing Time (ms)

The average time (in milliseconds) per request used by queries to the data source. Format is decimal (formatted to 3 decimal places).

Average Update Processing Time (ms)

The average time (in milliseconds) per request used by updates to the data source. Format is decimal (formatted to 3 decimal places).

Connection Average Wait Time

(ms)

The average time (in milliseconds) that applications had to wait for a connection. Format is decimal (formatted to 3 decimal places).

Connection Count

The number of connections to the data source. Format is positive integer.

Connection Max Wait Time (ms)

The worst-case time (in milliseconds) that applications had to wait for a connection. Format is positive integer.

Connection Rate (per sec)

The number of connection requests (per second) created for the data source. Format is decimal (formatted to 3 decimal places).

Connection Total Wait

Time (ms)

The total time (in milliseconds) that applications had to wait for a connection to the data source. Format is positive integer.

Database Product

The name of the database product. Alphanumeric string.

Database Product Version

The version of the database product. Alphanumeric string.

Datasource Name

The name of the data source. Alphanumeric string.

Datasource Label

A shortened version of Datasource Name, used to display the data source name in the chart view. Alphanumeric string. Maximum2 characters.

Interval (sec)

The length (in seconds) of the interval. Format is positive integer.

Node Name

The name of the system on which the server is running. Alphanumeric string.

Origin Node

The name of the application server subnode. Alphanumeric string.

Process ID

The unique identifier of the process running the Java Virtual Machine (JVM). Format is positive integer.

Query Count

The number of queries performed against the data source. Format is positive integer.

Query Rate (per sec)

The number of queries (per second) being made to the data source. Format is decimal (formatted to 3 decimal places).

Sample Date and Time

The date and time the Tivoli Enterprise Management Agent collected the data. The valid format is a 12-character timestamp. For the STR and SCAN functions, the format is MM/DD/YY HH:MM:SS; the following table shows the values contained in this character string:


Format of the 12-character timestamp

Character String Meaning
MM Month
DD Day
YY Year
HH Hour
MM Minute
SS Second

Example: 09/13/06 18:32:03 indicates the data was collected on September 13, 2006, at 18:32:03.

This attribute was designed for logging and reporting data-collection times rather than for creating situations. To specify a time and date for comparison and testing, use attributes from the Universal Time or Local Time groups.

Sampling Rate (%)

The percentage of edge requests-such as servlets and JSPs-that were sampled for data source requests during the interval. Format is positive integer.

Server Name

The name of the WebSphere application server. Alphanumeric string.

Summary

Indicates that this row is a summary row of statistical totals for all rows.

Total Query Processing Time (ms)

The total time (in milliseconds) used to process queries made to the data source. Format is positive integer.

Total Update Processing Time (ms)

The total time (in milliseconds) used to update the data source. Format is positive integer.

Total Wait Time (ms)

The time (in milliseconds) that applications had to wait for connections to the data source. Format is positive integer.

Update Count

The number of updates performed against the data source. Format is positive integer.

Update Rate (per sec)

The number of updates (per second) made to the data source. Format is decimal (formatted to 3 decimal places).

Additional information:


Parent topic:

Attributes for ITCAM Agent for WebSphere Applications