Resource Governor > Using DDL Statements to Create the Internal Tables > Overview of Creating the Resource Analyzer and Resource Governor Internal Tables

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 relational 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 will be 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 on the sidebar.
    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 Next.

    Note: For more information, see Configuring Resource Management.

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

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

  7. Click Create DDL.
  8. 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.

      Note: The DDL statements are created without a semi colon at the end of each CREATE command. If your platform requires this, for example, Mainframe Db2 via ISPF SPUFI, the semi colon must be added. Do not add it if your environment is UDB.

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

    Note: For more information, see Configuring Resource Management

  10. Select No from the Create Repository drop-down menu.
  11. Enter the same information that you used in step 6.
  12. Click Configure.

 WebFOCUS

Feedback