x

The following image shows the Resource Management page. The navigation pane is on the left and the Resource Analyzer/Governor and Reports folders are expanded in the tree.

Note: The Rule Parameters and Custom Rules folders are visible because Resource Management was configured using a license for both Resource Analyzer and Governor. For more information, see the Resource Governor Administrator’s and User’s Manual.

The navigation pane contains the following tools and context menu options. Context menus appear when you right-click a folder or on an item in an expanded folder.

Resource Management - Active/Inactive

Enable/Disable Monitoring & Governing

Enables or disables monitoring and governing.

Note: When you disable monitoring and governing, the Resource Management - Active folder will change to become Resource Management - Inactive.

Utilities

Displays the following options:

• Save log data. Submits a deferred execution job to archive the contents of the current logfile (RMDATA log) to the repository.
• List Save log jobs. Allows you to view current/previous archive jobs.
• Change License Key. Lets you change the license key for Resource Management.
• Reconfigure. Opens the Resource Management Configuration pane where you can reset configuration options, or change the repository type. For more information, see Resource Management Configuration Pane.
• Remove. Opens the Remove Resource Management pane where you can remove resource management products from the server.

Resource Analyzer/Governor

Displays the following options:

• Properties. Opens the Resource Analyzer and Governor Properties page where you can set global settings and set monitoring properties. For more information, see Resource Analyzer and Governor Properties Options.
• Repository Maintenance displays the following options:
  • Schedule Maintenance. Opens a pane where a maintenance job can be scheduled to run to delete monitored records from the repository based on a specified date range.
  • List Scheduled Maintenance. Opens a pane to list current or previously run maintenance jobs.
• Global Governing - Active/Inactive. For more information, see the Resource Governor Administrator’s and User’s Manual.

Application Directories

This folder contains your application directories, and each displays a context menu with the following options:

• Add Data Source. Opens a pane where you can set monitoring for the data sources in the selected application directory.

  Note: Data sources that are added from the Web Console display in the Resource Management Console with both application directory and synonym name, for example, ibisamp/dminv. If another synonym of the same name appears in a different application directory, (for example, baseapp/dminv), it will be ignored. Only the synonym in the directory you specify will be monitored.

• Exclude Procedure. Opens a pane where you can select procedures to be excluded from the monitoring process.

Data Adapter Sources

This folder is only visible if a relational adapter has been configured. Each relational adapter folder has the following option:

• Add Adapter Data Source. Opens the first of two panes which allow for the filtering and selection of relational data sources to be monitored.

Each monitored data source has the following context menu options:

• Properties. Displays the current usage information and lets you change the monitor status for the selected data source. For more information, see Resource Analyzer and Governor Monitored Data Properties Pane.
• Verify Monitoring. Displays sample data for the data source.
• Delete Data Source. Deletes the table from the list of monitored data sources.
• Governing. For more information, see the Resource Governor Administrator’s and User’s Manual.

Rule Parameters

For more information, see the Resource Governor Administrator’s and User’s Manual.

Custom Rules

For more information, see the Resource Governor Administrator’s and User’s Manual.

Reports

If you are licensed for Resource Analyzer and Resource Governor, the available reports for both appear in the tree. If you are licensed only for Resource Analyzer or only for Resource Governor, then only those reports for which you are licensed will appear in the tree.

In addition to Run, the Reports context menu also contains Run Deferred and List Deferred. Run Deferred prompts you for a date and time to execute the report and submits the report to the deferred queue. List Deferred lists the reports that have been submitted for deferred execution.

Each selected report will first show a filter pane where you can select the output format and data range for running of the report.

This folder contains the following reports:

• Monitored Sessions. Shows the number of user sessions by date. Session records are always captured regardless of monitoring preferences.
• Monitored Commands. Shows statistics for the commands that have been monitored (TABLE, MODIFY, SELECT, etc).
• Data Sources Never Used. Opens the Unused Master File Descriptions report which lists the data sources which have never been used.
• Procedures Never Used. Opens the Procedures Never Used report which lists the procedures which have never been executed.
• Resource Analyzer. Expands to enable access to Resource Analyzer reports. For more information on these types of reports, see Resource Analyzer Report Options.
• Resource Governor. Expands to enable access to Resource Governor reports. For more information on these types of reports, see the Resource Governor Administrator’s and User’s Manual.

x

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

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Right-click Resource Management - Active/Inactive in the navigation pane and select Enable/Disable Monitoring & Governing.

x

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Right-click Resource Management - Active/Inactive in the navigation pane, select Utilities and then select Save log data.

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

   

4. Click OK to save the log data.

x

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Right-click Resource Management - Active/Inactive in the navigation pane, select Utilities and then select List Save log jobs.

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

   

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

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Right-click Resource Management - Active/Inactive in the navigation pane, select Utilities and then 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

You can reset configuration options, or change the repository type used in Resource Management.

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Right-click Resource Management - Active/Inactive in the navigation pane and select Utilities.
4. Click Reconfigure.

   The Resource Management Configuration pane opens.

5. Make your desired changes and click Configure to save them. For more information on the options available, see Resource Management Configuration Pane.

x

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 vice versa.

1. Launch the iWay Web Console.
2. Right-click Resource Management Active/Inactive in the navigation pane.
3. Select Utilities and click Remove from the context menu.

   The Resource Management Confirmation pane opens.

4. Click Remove to remove Resource Management from the server.

x

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 Analyzer 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.

To set Resource Management Properties:

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Right-click Resource Analyzer/Governor in the navigation pane and select Properties.
4. Choose the type of data to be collected from the options listed under Procedure Log Records and Command Log Records.

   For more information on this data, see Resource Analyzer and Governor Properties Options.

5. Click Save.

x

You can delete monitor data from the repository using the Repository Maintenance pane.

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Right-click Resource Analyzer/Governor, select Repository Maintenance, and select Schedule Maintenance.

   The Resource Management Repository Maintenance pane opens, as shown in the following 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 Deferred Execution pane opens.

6. Enter a date and time for the delete request to be executed. Click Continue.

A Deferred Execution pane opens confirming your request.

x

The following image shows the Resource Analyzer and Governor Properties pane.

Note: By default, all options are selected.

The Resource Analyzer and Governor Properties pane has the following options:

Global Settings

Data Request Monitoring

Indicates whether Data Request Monitoring is on or off. When Global Data Request Monitoring is enabled, or set to On, Resource Analyzer or 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 included using -INCLUDE will be monitored. This is the default value.
• Execute Only. Any procedure that is execute 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.

Procedure Log Records

This setting allows for the customization of procedure data to be collected. The following options are available:

• Procedure. Contains information on the date and time a procedure started, the elapsed time used, the CPU time used and wait time, as well as other detailed information about the request.
• Request. The actual command as executed.
• WebFOCUS. Contains WebFOCUS specific data such as The MR Domain, the BASEDIR value, the APP Path used.

Command Log Records

This setting allows for the customization of command data to be collected. The following options are available:

• Command. Contains information on the date and time a command started, the elapsed time used, the CPU time used and wait time as well as other detailed information about the request.
• Request. The actual command as executed. i.e. TABLE FILE CAR PRINT CAR END.
• Function. Contains data about aggregate functions used on fields.
• WHERE/IF. Contains data on the Relational tests used in a request, such as the operator used, literals used, or date and time values used.
• Data Source. Contains the MFD or RDBMS table or tables used in a request.
• Field. Contains the field used, the type of field and whether it was used in a sort or group.

x

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Right-click Resource Analyzer/Governor in the navigation pane and select Global Governing.

   For more information, see the Resource Governor Administrator’s and User’s Manual.

   The Update Global Governing pane opens, as shown in the following image.

x

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

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Right-click an application directory in the navigation pane and select Add Data Source, as shown in the following image.

   

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

   

4. Select the check box(es) for the data sources you want to monitor, or click Select All to select all of the data sources listed.
5. Click Monitor.

   The Monitor Data Sources pane reopens displaying the selected data sources with monitoring enabled, as shown in the following image.

   

6. Click the Refresh button.

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

   

x

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 iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Expand the Data Adapter Sources object in the tree, click the appropriate data adapter, and select Add Adapter Data Source.

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

   

   The Resource Management Data Adapter filter pane appears, as shown in the following image.

   

4. If required, select the Filter check box and provide filter information in the appropriate fields. Click Next.

   The Monitor Data Source pane opens, as shown in the following image.

   

5. Select the check box(es) for the data sources you want to monitor, or click Select All to select all of the data sources listed. Click Monitor.

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

6. Click Refresh. The data sources you selected now appear in the tree under the adapter folder.

x

Verifying the monitor status and viewing sample data enables you to determine whether you are properly set up to access your data sources. The following procedure applies to both Application Directories and Relational Data Sources.

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Expand an application directory, or an entry under the Data Adapter Sources, in the tree.
4. To view the data source properties, click the Properties option from the context menu.

   The Resource Analyzer and Governor Monitored Data pane opens. For more information on the information shown in this pane, see Resource Analyzer and Governor Monitored Data Properties Pane.

5. To verify monitoring, right-click a monitored data source and select Verify Monitoring.

   Sample data from the data source appears, as shown in the following image.

   

x

The following image shows the Resource Analyzer and Governor Monitored Data Properties pane.

The Resource Analyzer and Governor Monitored Data Properties pane has the following fields/options:

Data Source

Is the name of the application directory and synonym being monitored in the specified application directory.

Usage Count

Is the number of times the synonym was accessed.

First Used

Is the date the synonym was first accessed.

Last Used

Is the date the synonym was last accessed.

Last User

Is the ID of the last user to run a procedure accessing the synonym.

Last Procedure

Is the name of the last procedure to run using the synonym or is ad hoc if no procedure was used.

At Line

Is the location in the procedure where the synonym is used. It will be 0 (zero) for ad hoc queries.

Database Location

Is the physical location of the data source. It will be blank for relational tables.

Monitor Status

Has the following options:

• On. Turns monitoring for the data source on.
• Off. Turns monitoring for the data source off.

Govern Status

For more information, see the Resource Governor Administrator’s and User’s Manual.

Note: The rule file cannot be changed in this section. To change the rule file, go to the Rule Files table for the data source.

x

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

1. Launch the iWay Web Console.
2. Click the Resource Management option on the toolbar.
3. Expand an application directory.
4. Click a data source and select Delete Data Source.

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

   

5. Click OK.

x

Data log files 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.

1. Launch the iWay Web Console.
2. Click the Workspace link on the toolbar, and click Configuration/Monitor.
3. Expand the Logs and Traces folder, right-click Resource Management Logs, and select Configure, as shown in the following image.

   

   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 5.

   rmlog_max_sessions

   The number of sessions recorded in the active log file which is archived and a new one 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 one is started. The default value is 1.

4. Click Save and Restart Server.