Overview of Creating the Resource Analyzer and Resource Governor Internal Tables

How to:

The Resource Management internal tables are created using the server Web Console. If you need or prefer to create the internal tables yourself, as required by your site, you can create them for any supported rational database.



Procedure: How to Create the Internal Tables

To create the Resource Management repository table:

  1. Start the Web Console of the server on which Resource Management will be configured.
  2. Verify that the data adapter is configured to the database where the Resource Management repository was created. If the data adapter is not configured, you must do so now before continuing.

    Note: The same Connection Name used when configuring the data adapter is required.

  3. Configure Resource Management.
    1. Click the Resource Management link in the toolbar.
    2. Click Configure in the ribbon or right-click Resource Management in the navigation pane and select Configure.
    3. Enter the license key from the packing slip and click Continue.

    Note: For more information, see Configuring Resource Management.

  4. Select DDL Only from the Create Repository drop-down menu.
  5. Enter the necessary information required to configure the repositories, as shown in the following image.

    For Data Adapter and Owner/Schema, you must use the same values you used when configuring the adapter.

  6. Click Create DDL.
  7. Edit the file as needed for use at your site:
    1. Add any additional site-specific requirements. Consult the appropriate RDBMS manuals for additional information.
    2. Using a command shell, or another product, execute the modified DDL to create the Resource management repository tables.
  8. Configure Resource Management.
    1. Click the Resource Management link on the toolbar.
    2. Click Configure in the ribbon or right-click Resource Management in the navigation pane and select Configure.
    3. Enter the license key from the packing slip and click Continue.

    Note: For more information, see Configuring Resource Management

  9. Select No from the Create Repository drop-down menu.
  10. Enter the same information that you used in step 5, as shown in the following image.
  11. Click Next.

    The Resource Management Configuration - Initial Properties window opens. For more information, see How to Configure Resource Management Using a FOCUS or Relational Repository.

  12. Click Configure.

WebFOCUS