Administering Resource Management From the Web Console

In this section:

Resource Governor Usage Monitoring facility allows you to monitor requests as they are submitted by users, and logs information about request usage. This information includes the usage statistics associated only with data retrieval or data manipulation in the case of MODIFY or MAINTAIN. This request information is stored in Resource Governor Usage Monitoring tables. You can specify the Monitor Preference, which allows you to change what information is collected for monitored data sources.

The Web Console enables you to administer Resource Management.

You can:

Access to these tasks is provided by the Resource Management link on the toolbar.

The following image shows the hierarchical navigation menu that is available when the Resource Management link is selected.


Top of page

x
Resource Management Configuration Maintenance

In this section:

The Resource Management ribbon provides options for configuring Resource Management, as shown in the following image.

The following sections provide detailed explanations for each option in the ribbon.

Note: You can also access these options by right-clicking Resource Management - Active/Inactive in the navigation pane.



x
Enabling or Disabling Monitoring

When you enable Resource Management, it automatically turns on monitoring. However, you can disable and re-enable monitoring at any time.



x
Procedure: How to Enable or Disable Monitoring
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Monitoring group, click Enable/Disable.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive and select Enable/Disable.



x
Logging Properties

The reporting server will write all information regarding monitored sources to a log file. This log file is then archived to the Resource Management repository at predetermined intervals or limits, while the server is running. The current log is also archived when the server starts or when the administrator submits a job from the Web Console of a running server.

The intervals or limits can be configured from the Logging Properties option in the Resource Management Web Console. When configured, the log file of an active server will be archived based on the maximum number of sessions and/or the days set or based on a scheduled job configured by the administrator.

Note: Logging properties can also be set under the Workspace, Logs and Traces, Resource Management Logs option from the Web Console main menu bar.



x
Procedure: How to Set Logging Properties

Logging properties can be configured in the Resource Management Web Console. When configured, the log files will be archived based on the maximum number of sessions and days set or based on a scheduled job configured by the administrator.

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Logs group, click Logging Properties.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive and select Logging Properties.

    The Resource Management Logging Properties window opens, as shown in the following image.

    The following options are available:

    rmlog_history

    The number of archived files kept. The default value is 10.

    rmlog_max_sessions

    The number of sessions recorded in the active log file before the log is archived and a new log is started. The default value is 10000.

    rmlog_max_days

    The number of days an active log file is kept open before it is archived and a new log is started. The default value is 1.

    rmlog_schedule_archive

    When set to No, automatic archiving is active and based on the two settings above.

    When set to Yes, only the rmlog_history_entry is shown and the administrator has to configure the schedule archive settings. Selecting Yes will cause a restart of the server and you will need to schedule the archive job.

    After the server restarts, the web console will refresh. Click the Resource Management option on the toolbar. Right-click Resource Management - Active/Inactive in the navigation pane and select Logs.

    Select Schedule Save log job. The Manage Schedule pane opens. Select the Schedule the procedure check box to see additional options. The recommended schedule settings are as follows:

    • Schedule Type - Recurring
    • Interval Type - Weekly
    • In the Start and Stop fields, select the date which then will set the reoccurring day of the week. Select the time at which the job will start. Do not select Specify End Date.
    • Leave the Special data/time ranges section blank.
    • If the email notification has been configured on this server, complete the E-mail Notification section, if required.
  4. Make your desired changes and click Save and Restart Server.


x
Archive Log Files

When this option is selected, a context menu is shown with the following options:

These give the administrator the option to archive the current log file (a new log file is automatically started), as well as view previous archive jobs including any that were submitted due to server restart, and any of the intervals or limits mentioned above having been reached.



x
Procedure: How to Submit an Archive of the Current Log File
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Logs group, click Archive and then select Submit Archive job.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive, select Archive, and then select Submit Archive job.

    The Select an Option dialog box opens, as shown in the following image.

  4. Click OK to save the log data.


x
Procedure: How to List Previous Archive Jobs
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Logs group, click Archive and then select View Archive jobs.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive, select Archive, and then select View Archive jobs.

    The Deferred List opens showing the saved logs, as shown in the following image.

    Deferred List

  4. Right-clicking an item in the Defer ID column provides more options. Select Get to see the output, or Delete to delete the selection.


x
List Unarchived Log Files

Select this option to show a list, if any, of previous log files that have not been archived.



x
Procedure: How to List Unarchived Logs
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Logs group, click List Unarchived.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive and select List Unarchived.

    The Resource Management Unarchived logs list opens listing the non archived logs, as shown in the following image.

    Unarchived logs

  4. Select an unarchived log and click Next to archive the desired unarchived logs.
  5. Select a date and time to archive and click Continue.


x
Working With Repository Maintenance

Repository data can be deleted once it has been used or reported on. This deletion can be by date range or, if sufficient data has been stored, the data can be deleted if it is more than one, three, or six months old.



x
Procedure: How to Submit a Maintenance Job
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Repository group, click Maintenance, and select Submit Maintenance job.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive, select Maintenance, and select Submit Maintenance job.

    The Resource Management Repository Maintenance pane opens, as shown in the following image.

    Resource Management Repository Maintenance Pane

    Note: If the range of data is older than one month, the options on the Repository Maintenance pane will be slightly different than shown in the above image.

  4. Enter a Start Date and End Date for deletion of data through that range, or click the down arrow button on the right of each date input box to choose the dates.
  5. Click Schedule.

    Note: Caution should be used when using this utility. Make sure you have a backup of the data before you proceed.

    The Submit Repository Maintenance Job window opens.

  6. Enter a date and time for the maintenance job to be executed. Click Submit.

A Deferred Execution pane opens confirming your request.



x
Procedure: How to View a List of Scheduled Maintenance Jobs
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Repository group, click Maintenance, and select View Maintenance jobs.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive, select Maintenance, and select View Maintenance jobs.

    The Deferred List pane opens, as shown in the following image.

  4. To delete any of the scheduled maintenance jobs, select the check box next to the job you want to delete, and select Delete Selected.


x
Configuration Maintenance

The Configuration command has the following options:

These give the administrator the option to see current configuration settings, as well as change the viewable application directories, perform migration, change a license key, and remove the current Resource Management configuration.



x
Setting Monitor Properties

Setting monitor properties enables you to select global settings and the component levels to be monitored. Components are split into two categories, Procedure and Command. The information that Resource Governor monitors is stored in the Usage Monitoring tables. The default settings are: Global Data request Monitoring set to off and component level set to Command. Session records are always captured.



x
Procedure: How to Set Monitor Properties

To set Resource Management Properties:

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Configuration group, click Configuration and select Properties.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive, select Configuration, and select Properties.

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

    Note: By default, all options are selected except Reference Field.

    The Resource Governor Properties pane has the following options:

    Configuration Properties
    Configuration Date

    The date that Resource Management was configured or reconfigured.

    Repository Type

    The repository that is being used.

    Data Adapter Connection

    The data adapter connection of the current configuration.

    Owner/schema

    The owner/schema name for the relational adapter that Resource Governor will use to create the repository tables.

    Data Sources monitored

    The number of application data sources and relational pass-thru data sources that have been enabled for monitoring. This will show Global monitor enabled if Data Request Monitoring is On. See the Global Settings section below for more information.

    Data Sources not monitored

    The number of application data sources and relational pass-thru data sources that have been disabled by setting the monitoring setting to OFF.

    Excluded Procedure count

    The number of procedures that have been excluded from monitoring.

    Last Maintenance Date

    The date the repository was modified using the Repository Maintenance page.

    Last Repository Update

    The last time the repository updated to include data from a log file.

    For more information on the other settings on this page, see How to Configure Resource Management Using a FOCUS or Relational Repository.

  4. Choose the type of data to be collected from the options listed under Procedure Log Records and Command Log Records.
  5. Click Save.


x
Configuring Application Paths

You can configure the application path to set the viewable directories for Resource Governor.



x
Procedure: How to Configure an Application Path
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Configuration group, click Configuration and then select Configure Application Path.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive, select Configuration and select Configure Application Path.

    The Application Path pane opens, as shown in the following image.

  4. To add or remove a directory from the application path, select the In Path check box and click Save.
  5. Refresh the navigation pane to see the newly added or removed directory.


x
Migrating Resource Management

For more information on how to migrate Resource Management, see Migrating the Resource Management Repository.



x
Working With License Keys

A license key is required to run Resource Governor. You can change the license key you are using from within Resource Management at any time.



x
Procedure: How to Change the License Key
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Configuration group, click Configuration and then select Change License Key.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive, select Configuration, and select Change License Key.

    The Resource Management Configuration pane opens showing your current license, as shown in the following image.

  4. Enter the new license into the License field and click Save.


x
Removing Resource Management

You can remove Resource Management from the server from the Resource Management Configuration pane. This is required if you want to change the repository type from FOCUS to relational, or relational to FOCUS.



x
Procedure: How to Remove Resource Management
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. On the ribbon, in the Configuration group, click Configuration and select Remove.

    or

    From the navigation pane, right-click Resource Management - Active/Inactive, select Configuration, and select Remove.

    The Resource Management Confirmation pane opens.

  4. Click Remove to remove Resource Management from the server. All system files and the Repository will be removed from the server.

Top of page

x
Working With Resource Governor

In this section:

When you right-click the Resource Governor node, a context menu is available, as shown in the following image.

The following sections provide detailed explanations for each option in this context menu.



x
Setting Monitor Properties

Setting monitor properties enables you to select global settings and the component levels to be monitored. Components are split into two categories, Procedure and Command. The information that Resource Governor monitors is stored in the Usage Monitoring tables. The default settings are: Global Data request Monitoring set to Off and component level set to Command. Session records are always captured.

For more information on setting monitor properties, see Setting Monitor Properties.



x
Working With Repository Maintenance

Repository data can be deleted once it has been used or reported on. This deletion can be by date range or, if sufficient data has been stored, the data can be deleted if it is more than one, three, or six months old.

For more detailed information on how to work with Repository Maintenance, see Working With Repository Maintenance.


Top of page

x
Working With Application Directories

In this section:

When you right-click an application directory, a context menu is available, as shown in the following image.

The following sections provide detailed explanations for each option in this context menu.



x
Monitoring at the Application Level

Monitoring Data Sources can be set at the Application level to monitor all Data Sources or at the individual level.



x
Procedure: How to View Application Name Properties
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Expand an application directory in the tree.
  4. To view the data source properties, click the Properties option from the context menu.

    The Properties for Application pane opens.

    The Properties for Application Pane pane has the following fields/options:

    First Used

    Is the date the synonym was first accessed.

    Last Used

    Is the date the synonym was last accessed.

    Data Sources
    Monitor On

    The number of data sources with monitoring on.

    Monitor Off

    The number of data sources with monitoring off.

    Not Monitored

    The number of data sources not being monitored.

    Total

    The total number of data sources in the selected application directory.

    Procedures
    Monitor On

    The number of procedures with monitoring on.

    Monitor Off

    The number of procedures with monitoring off.

    Total

    The total number of procedures in the selected application directory.

    Monitor Status

    For more information on setting monitor status, see How to Set Monitor Status at the Application Level.



x
Procedure: How to Set Monitor Status at the Application Level

Data sources in an application can have monitoring turned on or off at the application level. When On is selected, the Usage Monitor will collect information about all requests for all data sources in the application. When Off is selected, no monitored data for data sources in the Application is collected.

If Application monitoring has never been used, the Monitor Status will be Not Set. This is the default value.

To set monitor status for an application:

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Expand an application directory in the tree.
  4. To view the Application properties, right-click an application name and select Properties option from the context menu.

    The Properties for Application pane opens.

  5. Select the monitoring status you wish to use from the Monitor Status drop-down menu. The options are:
    • Not Set. This is the same as Off and is the default. The status will not be shown in the navigation tree when viewing data sources.
    • On. Turns monitoring for the Application on and can be seen in the navigation tree when viewing the Application list.
    • Off. Turns monitoring for the Application off and can be seen in the navigation tree when viewing the Application list.


x
Monitoring Individual Data Sources

When you right-click an application directory and select Manage Monitoring, a context menu is available, as shown in the following image.



x
Procedure: How to Monitor Individual Data Sources

Data sources must be monitored to provide monitor data, which can then be used to analyze performance.

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Right-click an application directory in the navigation pane, select Manage Monitoring and select Add Data Sources to Monitor.

    The Add Data Sources to Monitor pane opens to display all synonyms in the selected application directory, as shown in the following image.

    Add Data Sources to Monitor pane

  4. Select the check box(es) for the data sources you want to monitor, or select the Select All check box next to the Data Source Name column, to select all of the data sources listed.
  5. Click Add.

    The Add Data Sources to Monitor - Status pane opens displaying the selected data sources with monitoring enabled, as shown in the following image.

  6. Click the Close button.

    The data sources you selected now appear in the tree, as shown in the following image.



x
Procedure: How to Remove a Monitored Data Source From Being Monitored

You can remove a data source from being monitored as follows.

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Right-click an application directory in the navigation pane, select Manage Monitoring and select Remove Data Sources from Monitor.

    A confirmation window opens, as shown in the following image.

  4. Click OK.

Note: You can monitor Data Sources at the application level and then use the Remove Data Sources from Monitor option to exclude individual Data Sources within the application that you do not want to monitor.



x
Procedure: How to Remove a Procedure From Being Monitored

By default, all Application Data Source procedures are monitored. You can remove a procedure from being monitored as follows.

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Right-click an application directory in the navigation pane, select Manage Monitoring and select Remove Procedures from Monitor.

    A list of available procedures opens.

  4. Select the procedure(s) that you wish to remove from monitoring or select the Select All checkbox next to the Procedure Name column, and click Remove.

    The Remove Procedures from Monitor - Status pane opens, confirming that the selected procedure was removed.

  5. Click Close.


x
Procedure: How to Monitor Procedures

To have the ability to add procedures, they will need to be removed from monitoring first. For more details, see How to Remove a Procedure From Being Monitored.

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Right-click an application directory in the navigation pane, select Manage Monitoring and select Add Procedures to Monitor.

    The Add Procedures to Monitor pane opens to display all procedures in the selected application directory, as shown in the following image.

    Add Procedures to Monitor

  4. Select the check box(es) for the procedures you want to monitor, or select the Select All check box next to the Procedure Name column, to select all of the procedures listed.
  5. Click Add.

    The Add Procedures to Monitor - Status pane opens displaying the selected procedures with monitoring enabled, as shown in the following image.

  6. Click the Close button.

    The procedures you selected now appear in the tree under the selected application directory.


Top of page

x
Monitoring Relational Adapters

In this section:

When you right-click a relational adapter folder, a context menu is available, as shown in the following image.

The following sections provide detailed explanations for each option in this context menu.



x
Relational Adapter Properties


x
Procedure: How to View Relational Adapter Properties
  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Expand the Relational Adapters folder.
  4. Right-click a relational adapter directory in the tree and select Properties.
  5. Select a connection name from the Connection Name drop-down menu.

    Note: If there is only one connection name available, the properties for that connection will be shown immediately.

    The Properties for Relational Adapter for the selected connection pane opens, as shown in the following image.

    Properties

    The Properties for Relational Adapter pane has the following fields/options:

    Connection Name

    Allows you to select the connection name from the drop-down menu.

    First Used

    Is the date the relational adapter was first accessed.

    Last Used

    Is the date the relational adapter was last accessed.

    Data Sources
    Monitor On

    The number of data sources with monitoring on.

    Monitor Off

    The number of data sources with monitoring off.

    Not Monitored

    The number of data sources not being monitored.

    Total

    The total number of data sources in the selected application directory.

    Procedures
    Monitor On

    The number of procedures with monitoring on.

    Monitor Off

    The number of procedures with monitoring off.

    Total

    The total number of procedures in the selected application directory.



x
Monitoring Relational Data Adapter Sources

When you right-click a relational adapter and select Manage Monitoring, a context menu is available, as shown in the following image.

In the example shown, the MS SQL Server is the adapter selected for relational source monitoring.



x
Procedure: How to Monitor Relational Data Adapter Sources

Monitoring relational data adapter sources means monitoring SQL direct passthru requests to relational sources that do not use synonyms. Relational sources must be monitored to provide monitor data, which can then be used to analyze performance or govern usage.

Note: The following procedure can only be done if a relational adapter has been configured.

To monitor relational sources:

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Expand the Relational Adapters folder in the tree, right-click the appropriate data adapter, select Manage Monitoring and select Add Data Sources to Monitor.

    The Add Data Sources to Monitor pane opens, as shown in the following image.

  4. Select the connection name from the drop-down menu.
  5. If required, select the Filter check box and provide filter information in the appropriate fields. Click Next.

    The Add Data Sources pane opens, as shown in the following image.

  6. Select the check box(es) for the data sources you want to monitor, or select the Select All check box next to the Owner column to select all of the data sources listed. Click Add.

    The Add Data Sources pane reopens displaying the selected data sources with monitoring enabled.

  7. Click Close. The data sources you selected now appear in the tree under the adapter folder.


x
Procedure: How to Remove a Data Source for a Relational Adapter From Being Monitored

You can remove a data source from being monitored as follows.

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Right-click a relational adapter directory, select Manage Monitoring, and click Remove Data Sources from Monitor.

    A confirmation window opens.

  4. Click OK.


x
Procedure: How to Remove a Procedure for a Relational Adapter From Being Monitored

By default, all relational procedures are monitored. You can remove a procedure from being monitored as follows.

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Right-click a relational adapter directory, select Manage Monitoring, and click Remove Procedures from Monitor.

    The Remove Procedures from Monitor pane opens, as shown in the following image.

  4. Select the connection name from the drop-down menu and click Next.

    The Remove Procedures from Monitor pane opens, showing the list of available procedures.

  5. Select the procedure(s) you wish to remove from monitoring, and click Remove.

    The Remove Procedures from Monitor - Status pane opens, confirming that the selected procedure was removed.

  6. Click Close.


x
Procedure: How to Monitor Procedures

To have the ability to add procedures, they will need to be removed from monitoring first. For more details, see How to Remove a Procedure for a Relational Adapter From Being Monitored.

  1. Launch the Web Console.
  2. Click the Resource Management option on the toolbar.
  3. Right-click a relational adapter directory in the navigation pane, select Manage Monitoring and select Add Procedures to Monitor.

    The Add Procedures to Monitor pane opens.

  4. Select the connection name from the drop-down menu and click Next.
  5. Select the check box(es) for the procedures you want to monitor, or select the Select All check box next to the Owner column to select all of the listed procedures.
  6. Click Add.

    The Add Procedures to Monitor - Status pane opens displaying the selected procedures with monitoring enabled, as shown in the following image.

  7. Click the Close button.

WebFOCUS