Resource Analyzer 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 Analyzer 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 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 Business 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.
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.
Displays the following options:
Displays the following options:
Note: For more information on other options that may be displayed in this menu, see Migrating the Resource Management Repository.
Displays the following options:
This folder contains your application directories, and each displays a context menu with the following options:
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.
This folder is only visible if a relational adapter has been configured. Each relational adapter folder has the following option:
Each monitored data source has the following context menu options:
For more information, see the Resource Governor Administrator’s and User’s Manual.
For more information, see the Resource Governor Administrator’s and User’s Manual.
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:
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.
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.
The Resource Management Logging Properties window opens.
The Select an option dialog box opens, as shown in the following image.
The Deferred List opens showing the saved logs, as shown in the following image.
The Resource Management Non Archived logs list opens listing the non archived logs, as shown in the following image.
The following image shows the Resource Management Logging Properties window.
The following options are available:
The number of archived files kept. The default value is 10.
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.
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.
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 checkbox to see additional options. The recommended schedule settings are as follows:
You can reset configuration options, or change the repository type used in Resource Management.
The Resource Management Configuration pane opens.
The Resource Management Configuration pane opens showing your current license, as shown in the following image.
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.
The Resource Management Confirmation pane opens.
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:
For more information on this data, see Resource Analyzer and Governor Properties Options.
You can delete monitor data from the repository using the Repository Maintenance pane.
The Resource Management Repository Maintenance pane opens, as shown in the following image.
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.
A Deferred Execution pane opens confirming your request.
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:
The date that Resource Management was configured or reconfigured.
The repository that is being used.
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.
The number of application data sources and relational pass-thru data sources that have been disabled by setting the monitoring setting to OFF.
The number of procedures that have been excluded from monitoring.
The date the repository was modified using the Repository Maintenance page.
The last time the repository updated to include data from a log file.
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.
Indicates the level of Procedure Request Monitoring. The following options are available:
Indicates whether SQL Data Manipulation Language (DML) is enabled or disabled when monitoring is active. When SQL DML Monitoring is enabled, or set to On, Resource Management will monitor SQL INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP requests in addition to the standard data request commands. The default value is OFF. This setting should be used to replace the use of SET SMARTMODE = DML, which is now a depreciated setting.
This setting allows for the customization of procedure data to be collected. The following options are available:
This setting allows for the customization of command data to be collected. The following options are available:
The following table shows the comparisons between the Monitoring settings in 7.6, and earlier releases, and the Command Log records settings in release 7.7.
Release 7.6 |
Release 7.7 |
---|---|
Monitoring Settings |
Command Log Records |
All Data |
Select all |
Query, Froms, Relations, and Columns |
Commands, Request, Data Sources, WHERE/IF, and Fields |
Query, Froms, and Relations |
Commands, Request, Data Sources, and WHERE/IF |
Query and Froms |
Commands, Request, and Data Sources |
Query only |
Commands and Requests |
Note: The All Data option in release 7.6 also collects SORT and Functions. In release 7.7, SORT has been included in Fields, and Functions has its own select box.
The commands option in release 7.7 will also collect information about Remote requests from a HUB-SUB configuration and, if active, Resource Governor records.
For more information, see the Resource Governor Administrator’s and User’s Manual.
Data sources must be monitored to provide monitor data, which can then be used to analyze performance or govern usage.
The Monitor Data Sources pane opens to display all unmonitored synonyms in the selected application directory, as shown in the following image.
The Monitor Data Sources pane reopens displaying the selected data sources with monitoring enabled, as shown in the following image.
The data sources you selected now appear in the tree, as shown in the following image.
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:
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.
The Monitor Data Source pane opens, as shown in the following image.
The Monitor Data Sources pane reopens displaying the selected data sources with monitoring enabled.
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.
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.
Sample data from the data source appears, as shown in the following image.
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:
Is the name of the application directory and synonym being monitored in the specified application directory.
Is the number of times the synonym was accessed.
Is the date the synonym was first accessed.
Is the date the synonym was last accessed.
Is the ID of the last user to run a procedure accessing the synonym.
Is the name of the last procedure to run using the synonym or is ad hoc if no procedure was used.
Is the location in the procedure where the synonym is used. It will be 0 (zero) for ad hoc queries.
Is the physical location of the data source. It will be blank for relational tables.
Has the following options:
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.
You can remove a data source from being monitored as follows.
A confirmation window opens, as shown in the following image.
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.
The Resource Management Logging Properties window opens.
WebFOCUS |