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.
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.
The identifier (decimal) assigned to the address space running this servant region.
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).
The number of connections to the data source. Format is positive integer.
The worst-case time (in milliseconds) that applications had to wait for a connection. Format is positive integer.
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.
The name of the database product. Alphanumeric string.
The version of the database product. Alphanumeric string.
The name of the data source. Alphanumeric string.
A shortened version of Datasource Name, used to display the data source name in the chart view. Alphanumeric string. Maximum2 characters.
The length (in seconds) of the interval. Format is positive integer.
The name of the system on which the server is running. Alphanumeric string.
The name of the application server subnode. Alphanumeric string.
The unique identifier of the process running the Java Virtual Machine (JVM). Format is positive integer.
The number of queries performed against the data source. Format is positive integer.
The number of queries (per second) being made to the data source. Format is decimal (formatted to 3 decimal places).
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.
The percentage of edge requests-such as servlets and JSPs-that were sampled for data source requests during the interval. Format is positive integer.
The name of the WebSphere application server. Alphanumeric string.
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.
The time (in milliseconds) that applications had to wait for connections to the data source. Format is positive integer.
The number of updates performed against the data source. Format is positive integer.
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