DATA SOURCES Page
The Manager DATA SOURCES page provides information about all data sources added to the TDV Server, including:
• A consolidated overview of all the data sources in the repository.
• The overall status of the data sources with a count of warnings if any.
• An aggregated count of the active requests and an accumulated count of the total number of requests handled by TDV since the last restart.
• Estimations of the total volume of data passed from TDV to all data sources and back to TDV since the last TDV restart.
This section includes:
DATA SOURCES Summary Information
Summary information at the top of the DATA SOURCES page includes:
• Status - displays the current status which can be OK (green), Disabled (grey), # Warnings (yellow), DOWN or # Errors (red), where # is the number of warnings or failures for the module listed. A single warning or critical error will change the status from green to yellow, or from yellow to red depending on the failure severity and the module.
• Requests - Displays the number of active requests and the total number of requests since server restart.
• Bytes - Displays the number of bytes sent to the data sources and number of bytes received from the data sources.
Work with the DATA SOURCES Page
You can select one or more data sources by check box and then perform the following actions those data sources:
• Enable or disable the data source - the Change Enabling button toggles the status of the data source. Enabling makes the data source accessible through TDV definitions and configurations. Disabled takes the data source offline and makes it inaccessible to TDV defined channels.
• Clear the currently allocated pool connections. The Clear Connection Pool(s) button drops the current connection pool allowing current processes to restart connections when necessary.
• Verify the data source connection using the Test Data Source(s) button.
You can also test the current status all data sources by clicking the Test All button. An Administrative user with the Modify All Status right can use the Test All button.
The DATA SOURCES Table
The following columns are shown for each data source in TDV.
Name - User-defined name for the datasource.
Path - Fully-qualified path to the data source. For example, if the data source ds_orders reside in /shared/sources, the path to ds_orders would be: /shared/sources.
Status - Overall status for the data source, which can be one of the following:
Status | Indicates |
DISABLED | The data source is disabled; represented by a gray circle. |
DOWN | The data source is inaccessible; represented by a red circle. |
NOT TESTED | The status of the data source has not been tested. |
UP | The data source is connected to the TDV Server; represented by a green circle. |
Type - Native data source type, some of the more common supported data sources categories include: DB2, Composite, Custom Java Procedure, Infirmity, FileCache, LDAP, Microsoft Access, Microsoft Excel, Microsoft SQL Server, PostgreSQL, Netezza, Oracle, Sybase, Teradata, WSDL, XML, and XmlHttp
Category - Can be File, LDAP, Relational, WSDL, XML/HTTP.
Owner - Resource owner.
Active Requests - Current count of all outstanding data source requests
Total Requests - Cumulative count of all requests made on data sources (through TDV) since start of the TDV.
Pool Size (In Use) - Current connection-pool size for relational data sources
Allocated Pool Size - Current number of connections allocated for TDV for a particular relational data source
Max Pool Size - Maximum connection-pool size for a relational data source, zero is unlimited or not applicable.
Pool Utilization - Usage of pool represented as a percentage where allocated connections is divided maximum connections for a relational data source.
Data Source Details
Name - User-defined name for the data source.
Path - Fully-qualified path to the data source. For example, if the data source ds_orders reside in /shared/sources, the path to ds_orders would be: /shared/sources.
Status - Current status, which can be UP, DOWN, or NOT TESTED.
Category - Can be File, LDAP, Relational, WSDL, XML/HTTP.
Type - Kind of data source within the category to which it belongs.
Total Requests - Total number of requests (including active requests) made to the server since last startup.
Active Requests - Number of in-progress requests to the server.
Bytes From Data Source (Estimated) - An estimate of the total number of bytes of data received by the server from this data source.
Bytes Into Data Source (Estimated) - An estimate of the total number of bytes of data sent to this data source from the server.
Pool Size (In Use) - Current connection-pool size, if the data source is relational.
Allocated Pool Size - Current number of actual connections both idle and active allocated by TDV for a particular relational data source.
Max Pool Size - Configurable setting for maximum connection-pool size used to limit the number of connections allowed to burden a relational data source.
Pool Utilization - Usage of pool represented in percentage, if the data source is relational.
Number of Logins - The number of times a connection to the data source is made in the connection pool.
Number of Logouts - The number of connections to the data source that were manually destroyed by logout from the connection pool.