ODBC Resource Statistics attributes

After resource statistics collection is started, use the ODBC Resource Statistics attributes to get the statistics information that is collected for ODBC DSN resources. Statistics are reported for each ODBC DSN that has been accessed since the integration server started.

Active Connections The number of connections currently open to this DSN.

Aggregation Date & Time The aggregation date and time of the collection interval. The value is the same as End Date & Time.

Closed Connections The number of connections to this DSN that have ever been open, but are now closed. This number includes connections closed due to an error, forced closed by the DBMS or closed because it was no longer required (for example, thread idle for 60 seconds).

Connection Errors The number of times that a connection to this DSN has been detected to have a connection error (which might have caused the error to be closed and therefore also contributed to closed connections).

End Date & Time The end date and time of the collection interval.

Execute Failures The total number of times that any statement has failed against this DSN.

Execute Successes The total number of times any statement has been executed successfully against this DSN.

Integration Server The name of an integration server. An integration server is a process that provides the execution environment in which message flows run. Users associate message flows with integration servers during message flow assignment. This attribute is encoded in UTF8.

Node Name of the integration node (broker) or the independent servers managed system node. Valid format is an alphanumeric string. This attribute is encoded in UTF8.

Origin Node Name of the managed system that is the source of the data for the current row.

Resource Identifier The identifier of the ODBC DSN resource.

Resource Type The type of the resource. For ODBC DSN resource, this attribute is always ODBC.

Start Date & Time The start date and time of the sampling interval.