Configuring the Repository Server

In this section:

You will take the following steps to configure the repository server:

  1. Define the RARG_SVC service.
  2. Create a profile for the new service.
  3. Create the connection pooling user profile.
  4. Configure the Resource Management internal tables.

Top of page

x
Defining the RARG_SVC Service

How to:

Before you can configure the repository server, you must first define a new service named RARG_SVC on the server you have designated to be the Resource Analyzer repository server. This service is used to collect the monitoring data. You will use the Web Console to define the service. For instructions on accessing the Web Console see the Server Administration for UNIX, Windows, OpenVMS, IBM i, and z/OS manual.



x
Procedure: How to Define a New Service Block

If using a relational DBMS, it must first be configured with the correct user ID and password in order for the repository to be created and accessed.

  1. Launch the Web Console.
  2. On the toolbar, select Workspace, then Configuration/Monitor.
  3. In the tree, right-click Data Services, and then select New from the context menu, as shown in the following image.

    Data Service Context Menu

    Note: For a server running on MVS, select Server Mode from the New sub-menu.

    The New Data Service pane appears with default values, as shown in the following image.

    New Data Service Pane

  4. Enter the following required values to add the new service.
    1. Type a value of RARG_SVC in the service field.
    2. Select connection_pooling for the deployment option.
    3. Type a valid user ID in the pooled_user field and the password associated with the user in the pooled_password field. This user ID and password combination must be valid for the security mode of the server. It is suggested that user ID rauser be created for this purpose.

      Note: This user ID should be unique to the Resource Management product and should not be used for logon purposes by any user of the servers that are part of the Enterprise Monitoring environment.

    4. Type a value of rargsvc in the Profile field. The profile will contain the connections to the specific RDBMS used for Resource Management collection of monitor data.

    Note: For all other attributes not listed in this step, keep the default values.

    The following image shows the New Data Service pane set with the required values.

    New Data Service with Required Values

  5. Click Save and Restart Server to add the new service definition. Click OK when asked to verify that the server needs to be restarted.
  6. Verify that the new service is defined. On the toolbar, click Workspace, and then Configuration/Monitor.
  7. In the navigation pane, right-click Data Services and select Services.

    The Data Services Status window opens, as shown in the following image.

    Data Services Status Window


Top of page

x
Creating a Profile for the New Service

How to:

A profile named rargsvc is required for the RARG_SVC service. This profile contains the commands used to connect to the specific RDBMS used for Resource Management collection of monitor data.

To define the rargsvc profile you can use an existing application or create a new one with the name rargsvc and add it to the server's application path. If you select to use an existing application directory, make sure it is in the application path. You can then create the rargsvc profile in the selected application directory. On MVS PDS deployment, an existing application directory should be selected. It is not recommended to create a new one.



x
Procedure: How to Create a New Application Directory

To create a new application directory:

  1. Launch the Web Console.
  2. On the toolbar, click Applications.
  3. Click the New button above the navigation pane, and then Application Directory, as shown in the following image.

    The Create New Application window opens.

  4. Type rargsvc in the Application Name field. Make sure the Add directory to APPPATH check box is selected, as shown in the following image.

The newly created rargsvc directory is added to the server application path and appears in the Application Directories folder in the navigation pane.



x
Procedure: How to Create the Profile

Now we need to create the actual profile that is used to connect to the RDBMS where the Resource Analyzer internal tables will be created and maintained. If you do not see the newly created rargsvc Application Directory listed under the Application Directories folder in the navigation pane, as shown in the following image, click the Refresh button.

  1. Right-click rargsvc in the navigation pane (or an existing application directory if a rargsvc was not created). Select New and then Procedure from the context menu, as shown in the following image.

    A window appears in the right pane in which you will type the commands for the profile, as shown in the following image.

  2. Write the profile, which contains the commands for the server to connect to the RDBMS into which Resource Management will collect monitor data. Type each command below on a separate line.
    SQL adapter_type SET SERVER connection_name 
    SQL adapter_type SET PASSRECS OFF
    GKE %COLLECTOR

    where:

    adapter_type

    Identifies the relational adapter used to store the monitor data.

    connection name

    Identifies the connection name used when you configured the adapter.

    In the example shown in the following image, MSSQL is being used to store the monitor data.

  3. Click the Save As icon.

    The Save Procedure window opens, in which you will type the name of the profile.

  4. Enter a name of rargsvc in the entry field, as shown in the following image, and click Save.

The new procedure will appear under the rargsvc application directory, as shown in the following image.


Top of page

x
Creating the Connection Pooling User Profile

How to:

Now you must create the connection pooling user profile. The profile is used to supply connection information for the RDBMS that is storing the monitor information.



x
Procedure: How to Create the Connection Pooling User Profile
  1. On the toolbar, click Workspace, then Configuration/Monitor. In the tree, expand Configuration Files, as shown in the following image.

  2. Right-click User Profiles and select New User Profile from the context menu, as shown in the following image.

  3. Enter the command:
    SET SQLENGINE=suffix

    where:

    suffix

    Is the relational adapter used to store the monitor data.

    The example shown in the following image uses DB2 as the relational adapter type.

  4. Click the Save As icon.

    The Create new user profile pane opens, as shown in the following image.

  5. In the Name field, enter the name of the profile. Use the same name that was used as the connection pooling user ID when the RARG_SVC service was created. Click Save.

    The Edit User Profile window appears, displaying the name of the new profile. In the example shown in the following image, the profile name is rauser.


Top of page

x
Configuring the Internal Tables

How to:

You are now ready to create the internal tables for Resource Management.



x
Procedure: How to Configure the Repository Server
  1. Click Resource Management on the main page of the Web Console. The Resource Management window appears, as shown in the following image.

  2. Right-click Configure Resource Management in the navigation pane and select Configure.

    The Resource Management Configuration window opens.

  3. Enter the license key from your packing slip and click Continue.

    The Resource Management Configuration window opens, as shown in the following image.

  4. Select Relational - Repository from the Enterprise Node Type drop-down menu. Next, type in a server name. This field defaults to the host server name and the port number being used by the server, as shown in the following image.

    1. Select Relational-Repository from the Enterprise Node Type drop-down menu.
    2. Select a data adapter and the appropriate connection name from the drop-down menu.

      This connection name must be the same one that was used when creating the profile in How to Create the Profile.

    3. Set Create Repository to Yes, unless the repository has already been created using the Data Adapter’s native Data Definition Language (DDL).
    4. Provide an Owner/Schema.

      By default, the tables are created for the specified owner/schema in the default database, and the owner must be authorized to create tables in the database.

  5. Click Configure to complete the configuration process.

The Resource Management: Resource Analyzer/Governor page opens, and the navigation pane on the left appears, as shown in the following image.


WebFOCUS