Configuring Resource Management

In this section:

How to:

At run time, Resource Management collects usage monitoring data in a log file. At predetermined times, such as during server startup or a user request, the log data collected is archived to a permanent repository. Before collecting the data, Resource Management must be configured.

To configure Resource Management, after the server is installed, you must:

  1. Consider security authorization for RM files and libraries.

    There are two levels of security to consider:

    • Administrator: MVS requires write authority to all datasets allocated to the EDACFG, EDAMAS, EDAACX, and SMARTLIB DD statements of the server. All other platforms require write authority to EDACONF/bin, EDACONF/catalog, and EDACONF/etc.
    • Basic user: MVS requires read authority to the dataset allocated to the SMARTLIB DD statement. All other platforms require read authority to EDACONF/etc.
  2. Enable Resource Management from the Web Console.
  3. Type your license key and select a repository type. Resource Management can be configured to create Usage Monitoring tables in a FOCUS repository or in a relational repository. The repository holds data on resource usage.
  4. Configure the repository.


Procedure: How to Configure Resource Management Using a FOCUS or Relational Repository

To enable Resource Management, you must have a valid license key. After typing the key, you can specify the type of repository to be used for Usage Monitoring. The Usage Monitoring tables are then created. This procedure shows how to create Usage Monitoring tables in a FOCUS or relational repository using a license code for Resource Governor.

Before performing the following steps, make sure the server is running.

  1. On a Windows system, from the Programs Menu, select iWay Software (or Information Builders, if you have a WebFOCUS server installation), then the server type, and click Web Console.

    If you are using an operating system other than Windows, enter

    http://ipaddress:port

    where:

    ipaddress

    Identifies the server where Resource Governor is to be configured.

    port

    Is the port number for that server.

    Note: On the Program Menu under iWay Software, the server types can include iWay Full-Function Server, or iWay DataMigrator Server. On the Program Menu under Information Builders, the server type can include a WebFOCUS Server. Resource Governor can be configured on any of these servers.

    The Web Console opens, as shown in the following image.

    Web Console
  2. Click the Resource Management link on the toolbar.

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

    Resource Management page
  3. Click Configure on the ribbon or right-click Resource Management in the navigation pane and select Configure.
  4. Type the license key from the packing slip. There are different keys: one for Resource Analyzer, one for Resource Governor, and one if both products are licensed.
  5. Click Next.

    The Resource Management Configuration pane opens.

  6. For a FOCUS Repository:
    1. Type a Server Name. Used by Resource Governor as the server name in collected data and on reports. Any identifier of up to 48 characters is acceptable, but the value should be unique across all servers where Resource Governor is installed. Host server (computer) name, along with the port used by the server, is the default. It is recommended that this value is not changed.
    2. Select FOCUS from the Repository drop-down menu.
    3. Go to step 8.
  7. For a Relational Repository:
    1. Type a Server Name. Used by Resource Governor as the server name in collected data and on reports. Any identifier up to 48 characters is acceptable, but the value should be unique across all servers where Resource Governor is installed. Host server (computer) name, along with the port used by the server, is the default. It is recommended that this value is not changed.
    2. Select Relational from the Repository drop-down menu. The following image shows the additional fields that become available.
    3. Select an adapter from the Data Adapter drop-down menu. This adapter identifies the data adapter and the connection name to be used for storing Resource Governor Usage Monitoring data. The connection name is the logical name used to identify a particular set of connection attributes. This setting also determines the SUFFIX used when creating the Master Files for these tables.

      Note: If no certified Resource Management adapter has been configured, the only option in the drop-down menu will be FOCUS.

      The current list of certified relational engines is:

      • DB2
      • Oracle
      • Informix
      • Sybase
      • Teradata
      • Ingres
      • MS SQL Server
      • RDB
      • MySQL
      • PostgreSQL
      • Generic ODBC/JDBC for Sybase SQL Anywhere Release 12 non-Unicode only.
        Note:
        • The Sybase ASA database used for the Resource Management Repository must be created with the Ignore trailing blanks in string comparisons option (or the -b option in the dbinit command).
        • If DB2 is going to be the target for the Resource Management Repository, the sites DBA should investigate the use of the parameter LOCKSIZE and change it to ANY if large volumes of data is to be stored. This value of LOCKSIZE will prevent the DB2 error message:
          The limit on the number of locks has been exceeded for the tablespace within DB2.

          If the DDL Only option is used at configuration time, then this parameter can be added to the DDL that is generated otherwise the sites DBA can add it to the existing Resource Management environment.

    4. Set Create Repository to Yes, unless the repository has already been created using the native Data Definition Language (DDL) of the Data Adapter or you are configuring a Many-to-one environment.

      When No is selected, the configuration process will not issue DROP TABLE, DROP INDEX, CREATE FILE, and CREATE INDEX commands. Because the configuration process will always initialize the repository with default data and issue the default GRANTS, the repository must exist when the commands are executed or the configuration will fail. Yes is the default value.

      For more information, see Using DDL Statements to Create the Internal Tables. For more information on Many-to-one, see Configuring Many-to-One Monitoring.

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

      If the tables are to be created in an alternate database that the owner has rights to, and the technique is supported by the RDBMS, the database name must be specified as well (for example, database.owner). Consult the appropriate RDBMS documentation for the appropriate syntax. On the System I platform, the Owner Name will be shown as Library.

    6. For servers running on z/OS, HFS, or PDS deployment where DB2 has been selected as the data adapter, provide a DB2 DBSPACE.
    7. Set Global Settings, which has the following options:
      Data Request Monitoring

      Indicates whether Data Request Monitoring is on or off. When Global Data Request Monitoring is enabled, or set to On, Resource Governor collects information on all SQL SELECT and FOCUS TABLE, TABLEF, MATCH, GRAPH, MODIFY, and MAINTAIN requests. The default value is Off. Monitoring will be by individually selected data sources.

      Procedure Request Monitoring

      Indicates the level of Procedure Request Monitoring. The following options are available:

      • Execute and Include. All executed procedures and any procedure that used -INCLUDE will be monitored. This is the default value.
      • Execute Only. Any procedure that is executed using EX or EXEC will be monitored.
      • Primary Execute Only. The only procedure monitored will be the primary procedure. Any procedure executed from within the primary (-INCLUDE or EX) will not be monitored.
  8. Click Configure.

The Repository Statistics page opens, and the navigation pane on the left appears, as shown in the following image.

Navigation pane

You can now select monitoring levels for Resource Governor. For more information, see How to Set Repository Properties.



Configuring Many-to-One Monitoring

In this section:

Several considerations and steps must be taken in order to configure Resource Management to gather monitor data for multiple servers into a single repository. This feature can only be done using relational adapters. Access must be available from each server machine to the selected relational engine and a license will be needed for each individual adapter.

All servers in a cluster environment, or multiple servers on UNIX, AS/400.MVS/PDS, and Windows platforms, can collect monitor data into a single repository. If you have environments with multiple WebFOCUS or iWay servers configured for Resource Management and want to collect monitor data from those servers into a single repository, the steps in the following procedure show how to configure Resource Management using the Web Console of the servers.



Configuring Resource Governor

How to:

If you have not used the Resource Management DDL to create the repository tables, then you need to pick a server to do the initial configuration that will create the repository tables. Using the Web Console of the server you will need to perform the steps in How to Configure the First Server. If the Resource Management DDL was used to create the repository tables then go to the How to Configure Additional Servers.



Procedure: How to Configure the First Server

For the first server, configure Resource Management from the Web Console of the server using the following steps:

  1. Configure the relational data adapter for the repository, if it does not yet exist.
  2. Configure Resource Governor from the Resource Management Configuration pane.
  3. Enter the Resource Management license key. Click Continue.
  4. Select Relational from the Repository Type drop-down menu.
  5. Enter a unique name in the Server Name field, or accept the default.
  6. Select a Data Adapter and the appropriate connection name from the drop-down menu.
  7. Set Create Repository to Yes.
  8. Provide an Owner/Schema name for the relational adapter that Resource Governor will use to create the repository tables.
  9. Click Configure.

After configuration is complete, select the monitoring level for Resource Governor. For more information, see How to Set Repository Properties.



Procedure: How to Configure Additional Servers

For additional servers that will use the same repository, configure the Resource Management from the Web Console of the server using the following steps:

  1. Configure the relational data adapter for the repository, if it does not yet exist, that connects to the same database used in step 1 in How to Configure the First Server.
  2. Configure Resource Governor from the Resource Management Configuration pane.
  3. Enter the Resource Management license key. Click Continue.
  4. Select Relational from the Repository Type drop-down menu.
  5. Enter a unique name in the Server Name field, or accept the default.
  6. Select a Data Adapter and the appropriate connection name from the drop-down menu.
  7. Set Create Repository to No.

    Note: Create Repository must be set to No on each additional server so that the configuration process does not drop and recreate the repository tables. This will cause the loss of data for any of the reporting servers using the same repository tables.

    If the relational repository tables were created by the DBA using the DDLs provided with the product, then all servers have to be configured using Create Repository No.

  8. Provide an Owner/Schema name for the relational adapter that Resource Governor will use to create the repository tables.
  9. Click Configure.

After configuration is complete, select the monitoring level for Resource Governor. For more information, see How to Set Repository Properties.

Note: All administration for Resource Governor must be done on each of the servers configured to use the same repository tables.



Reference: Governing

If Governing is being used, administration for Resource Governor must be done on each server. Knowledge base rule files cannot be shared or copied from one server to another.

When rules are built for Governing, there is a knowledge base rule file built on the server. These knowledge base files can only be used on the server that they were built on. For example, if rules to govern databases are built on a UNIX server, these rules can only be used on that specific UNIX server. The same rule applies for Windows, z/OS, PDS server, and other platforms.


WebFOCUS