The data collectors gather monitoring and diagnostic information from the application servers. This data can be sent to the Tivoli® Data Warehouse for long-term storage. The data can also be transformed in the SOA Domain Management Server database to display service-to-service topology information in the portal workspaces and views. Data that is related to registered services, business integration information, and application server names can be collected with discovery library adapters and transformed in the Tivoli Common Object Repository database for display in topology views in the portal desktop.
The Tivoli Data Warehouse supports IBM® DB2®, Oracle, and Microsoft SQL Server warehouse databases for collection of historical data.
You might have to consult your local system or database administrator to set up the database if it is not already defined, or refer to your Tivoli Monitoring documentation for the procedures to follow, including these tasks:
Plan the size of your warehouse database to ensure that you have a large enough database server to contain your data. To find the warehouse load projection spreadsheet in the Tivoli Integrated Service Management Library search for "warehouse load projections" or the navigation code "1TW10TM1Y" at the following URL: https://www-304.ibm.com/software/brandcatalog/ismlibrary/. This spreadsheet has a tab for the ITCAM for SOA monitoring agent.
To determine which ITCAM for SOA attribute groups can be enabled for historical data collection, see Enabling historical data collection.
IBM Web Services Navigator can be configured to display historical information that is collected by the ITCAM for SOA monitoring agent. For more information about connecting the IBM Web Services Navigator to the Tivoli Data Warehouse, see IBM Tivoli Composite Application Manager for SOA Tools.
Tivoli Common Reporting can be configured to retrieve data from the Tivoli Data Warehouse for reporting. For information about connecting Tivoli Common Reporting to the Tivoli Data Warehouse database, see the IBM Tivoli Common Reporting Information Center.
If you want to display service-to-service topology flows in Operational Flow workspaces, you must configure support for SOA Domain Management Server and its associated database.
ITCAM for SOA also includes a graphical user interface configuration utility that you use to create and configure the SOA Domain Management Server database. On Windows, Linux, and UNIX operating systems, console mode and silent mode (with a response file) are also supported.
The SOA Domain Management Server database, containing information about service-to-service relationships, can be created on a supported DB2 server, a supported Microsoft SQL server (Windows systems only), or a supported Oracle server. This server can be the same database server that is used by Tivoli Enterprise Portal Server if located on the same computer as Tivoli Enterprise Portal Server, or this server can be on a separate, remote computer.
The SOA Domain Management Server Configuration utility can create these databases for you locally, or you can create them yourself on local or remote database servers with database creation scripts provided with the product. Oracle databases must be created manually. If you create your own databases manually, you still must run the SOA Domain Management Server Configuration utility on the Tivoli Enterprise Portal Server to complete the configuration of topology support.
For more information about creating databases, creating database users, and running the SOA Domain Management Server Configuration utility, see Configuring topology support on Windows systems or Configuring topology support on Linux systems. You might have to consult your local database administrator for assistance with these tasks.
If you use service registry and business service integration information in your views, you must configure support for both SOA Domain Management Server and Tivoli Common Object Repository and their associated databases. You must also install and run one or more of the discovery library adapters that are provided with this product.
You can configure the SOA Domain Management Server to operate with or without the Tivoli Common Object Repository database.
You can configure the Tivoli Common Object Repository databases with the SOA Domain Management Server Configuration utility. On Windows, Linux, and UNIX operating systems, console mode, and silent mode (with a response file) are also supported.
The Tivoli Common Object Repository database can be created on a supported DB2 server or a supported Oracle server. The server can be installed on either the Tivoli Enterprise Portal Server computer or on a different, remote database server.
The SOA Domain Management Server Configuration utility can create the database for you locally, or you can create them yourself on local or remote database servers with database creation scripts that are provided with the product. Oracle databases must be created manually. If you create your own databases manually, you still have to run the SOA Domain Management Server Configuration utility on the Tivoli Enterprise Portal Server to complete the configuration of topology support.