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 in either Oracle, DB2, or MS SQL using DDL statements. Sample DDL are provided in the drive:\ibi\apps\ibisamp directory on Windows, in ibi/apps/ibisamp on UNIX, z/OS, and Linux, and in qualf.P.HOME.ETC on MVS. The RMUDDL.DAT file contains sections for each RDBMS. There are two sections for Oracle, one for non-UTF8 databases and one for UTF8 databases.
Top of page
x
Procedure: How to Create the Internal Tables in UNIX/Windows/Linux, and z/OS

To create the Resource Management repository tables in UNIX/Windows/Linux and z/OS:

  1. Copy the sample file to an Application directory location of your choice.

    Note:

    • The file is divided into three sections. Locate the section for the RDBMS that you will be using. Select all of the lines in the section, copy the full section to a new file, and save the file with a file type of .fex or .sql. Use .sql if you are going to use a RDBMS specific client to execute the DDL statements.
    • The order, data type, or size of each column name entry in each table cannot be deleted or modified.
  2. Edit the file as needed for use at your site:
    1. Change the OWNERID literal to the real owner ID of the Resource Management tables.
    2. Add any additional site-specific requirements. Consult the appropriate RDBMS manuals for any additional information.
  3. Using a command shell, or another product, execute the modified DDL to create the Resource Management repository tables.
  4. Start the Web Console of the server on which Resource Management will be configured.
  5. Verify the data adaptor to the database, where the Resource Management repository was created in step 3, is configured. If the data adapter has not yet been configured, you must do so now before continuing.

    Note: The same Connection Name used when configuring the data adapter will be required when configuring Resource Management in step 7.

  6. Configure Resource Management.
    1. Select Resource Management from the Web Console toolbar.
    2. Right-click Configure Resource Management in the navigation pane and select Configure from the menu.
    3. Enter the license key from the packing slip, and click Continue.

    Note: For more information, see Configuring Resource Management.

  7. For Create Repository, select No.
  8. Enter the necessary information required to configure the repositories. For Owner Name, you must provide the same value you provided for OWNERID used in the DDL in step 2. Use the Data Adapter name supplied when you configured the data adapter.
  9. Click Configure.

The following image shows an example of values used to configure Resource Management.

iWay Software