User manual BUSINESS OBJECTS DATA INTEGRATOR 11.7.2 FOR WINDOWS AND UNIX ADMINISTRATOR GUIDE

[. . . ] Data Integrator Management Console: Administrator Guide Data Integrator Management Console: Administrator Guide Data Integrator 11. 7. 2 for Windows and UNIX 1 Patents Business Objects owns the following U. S. patents, which may cover products that are offered and sold by Business Objects: 5, 555, 403, 6, 247, 008 B1, 6, 578, 027 B2, 6, 490, 593 and 6, 289, 352. patents, which may cover products that are offered and licensed by Business Objects: 5, 555, 403; 6, 247. 008 B1; 6, 578, 027 B2; 6, 490, 593; and 6, 289, 352. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Xcelsius, Crystal Decisions, Intelligent Question, Desktop Intelligence, Crystal Enterprise, Crystal Analysis, WebIntelligence, RapidMarts, and BusinessQuery are trademarks or registered trademarks of Business Objects in the United States and/or other countries. [. . . ] This value reflects successful and unsuccessful attempts. · Time since last request start The amount of time since the Access Server last sent a request to this service provider. This value reflects successful and unsuccessful attempts. Using statistics and service parameters You can use the statistics for a service to tune the service parameters. · Average and maximum processing time If the average or maximum processing time for a service provider is equal or close to the processing timeout value resulting in processing timeouts, consider increasing the processing timeout parameter for the service. · Maximum queuing time In a tuned system, the maximum and average queuing times should be close together, the difference being an indication of the traffic distribution for this service. Values should not approach the value of the queuing timeout parameter listed for the service. If the maximum queuing time for a service provider is equal or close to the queuing timeout parameter and there are queuing timeouts listed, consider the following changes: · · Increase the queuing timeout parameter for the service Increase the number of service providers available, either controlled by the same Job Server host or by a different Job Server 104 Data Integrator Management Console: Administrator Guide Real-Time Performance Using statistics and service parameters 8 If you find that the average time in the queue is longer than the average processing time, the traffic for this service is too high for the resources provided. Consider running multiple service providers to process the same message type. You can add the same job many times in the service list, or you can add the same job controlled by a different Job Server on a separate computer to the service list. If you find that the average queuing time is growing, consider increasing the queuing timeout or adding processing resources. · Processing timeouts If you see processing timeouts and service providers restarting successfully, consider increasing the number of processing retries allowed for the service. Data Integrator Management Console: Administrator Guide 105 8 Real-Time Performance Using statistics and service parameters 106 Data Integrator Management Console: Administrator Guide Data Integrator Management Console: Administrator Guide Profile Server Management chapter 9 Profile Server Management Profile Server Management Profile Server Management This chapter describes how to use the Administrator to manage the data in the profiler repository and manage tasks on the profiler server. For information about how to execute the Data Profiler and how to view the resulting data profiler attributes, see "Using the Data Profiler" on page 335 of the Data Integrator Designer Guide . The Data Profiler executes on a profiler server to provide the following data profiler information that multiple users can view: · Column analysis--This information includes minimum value, maximum value, average value, minimum string length, and maximum string length. You can also generate detailed column analysis such as distinct count, distinct percent, median, median string length, pattern count, and pattern percent. Relationship analysis--This information identifies data mismatches between any two columns for which you define a relationship, including columns that have an existing primary key and foreign key relationship. · You can execute the Data Profiler on data contained in databases and flat files. Databases include DB2, Oracle, SQL Server, Sybase, and Attunity Connector for mainframe databases. See the Data Integrator Release Notes for the complete list of sources that the Data Profiler supports. This chapter assumes that you have already installed Data Integrator which includes the Data Profiler. This chapter describes the following steps to setup and monitor the Data Profiler on the Administrator: · · · · · Defining the profiler repository Connecting repositories to the Administrator Defining profiler users Configuring profiler task parameters Monitoring profiler tasks using the Administrator Defining the profiler repository The Data Profiler repository is a set of tables that holds information about your data that the Data Profiler generates. To define a profiler repository Create a database to use as your profiler repository. The profiler repository can be one of the following database types: DB2, MySQL, Oracle, SQL Server, or Sybase. 1. 108 Data Integrator Management Console: Administrator Guide Profile Server Management Connecting repositories to the Administrator 9 2. Create a profiler repository on the Repository Manager. For details, see "Creating or upgrading repositories" on page 81 of the Data Integrator Getting Started Guide. For details, see "Configuring Job Servers" on page 82 of the Data Integrator Getting Started Guide. 3. Connecting repositories to the Administrator The Data Integrator Administrator manages the data in the profiler repository and manages tasks in the profiler server. Use the List of Repositories page to connect an Administrator to a repository. To add a local, central, or profiler repository connection to the Administrator 1. Option Repository Name Database type Click Add on the List of Repositories page. [. . . ] Make sure that the Job Server is running by checking the Windows NT Task Manager for the Al_jobserver. ex and Al_jobservice. e processes or by opening the Designer, logging in to the repository that corresponds to the Job Server, and looking for the Job Server icon at the bottom of the window. · Job Server cannot start real-time service If this error occurs, the status for the related service and its service provider would be red and you would be able to open the error log file from the Service Provider Status page. Make sure that the job is properly indicated for the service called in the Real-Time Service Status page. Make sure that the real-time jobs are available in the repository associated with the Job Server. Make sure the repository and the Access Server are connected to the Administrator and that the repository is available. [. . . ]