Overview of Creating the Resource Analyzer and Resource Governor Internal Tables
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.
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:
-
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.
-
Edit the
file as needed for use at your site:
-
Change the OWNERID literal to the real owner ID of the Resource
Management tables.
-
Add any additional site-specific requirements. Consult the appropriate
RDBMS manuals for any additional information.
-
Using a
command shell, or another product, execute the modified DDL to create
the Resource Management repository tables.
-
Start
the Web Console of the server on which Resource Management will
be configured.
-
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.
-
Configure
Resource Management.
-
Select Resource Management from the
Web Console toolbar.
-
Right-click Configure Resource Management in
the navigation pane and select Configure from
the menu.
-
Enter the license key from the packing slip, and click Continue.
Note: For more information, see Configuring Resource Management.
-
For Create Repository, select No.
-
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.
-
Click Configure.
The following
image shows an example of values used to configure Resource Management.