This chapter discusses the visual tools that Ingres provides to manage and monitor Ingres performance, including:
Note: These GUI tools can be used on Windows platforms, or on UNIX platforms with the MainWin application by Mainsoft. To find out which UNIX platforms are supported, see the Ingres Corporation web site.
|
|
|
Ingres Visual Manager (IVM) provides a global view into the Ingres installation. It serves as a system console from which you can manage Ingres components and access other utilities. This utility captures events that are occurring in the system and allows them to be filtered for emphasis, based on your preferences.
IVM allows you to monitor (and start and stop) the different servers in the installation (DBMS, Name, Communications, JDBC, Data Access, Bridge, Star, ICE, and Recovery) as well as Remote Command, the Logging and Locking systems, and the Primary Transaction Log and Archiver process. It shows events occurring in the system both at the installation level and the level of each server. Using IVM, you can also edit the Ingres system and user environment variable settings.
|
|
|
Ingres Visual Manager enables you to:
|
|
|
The Ingres Visual Manager window contains a list of Ingres components. By selecting any branch of the corresponding tree, you can access information related to the branch, which correspond either to the entire Ingres installation (the root branch), an individual component configuration, or an individual instance of a given configuration.
The Visual Manager Window contains the following tabs:
Status
Displays the summary of startup status of the components of the installation, the start and stop history of any component in the configuration, and related information such as the output of the last start or stop operation.
Parameters
Displays system, user, or extra parameters.
Logged Events
Displays a list of logged events for the Ingres installation and any of its sub-branches. You can also select an event to view its corresponding message text.
Event Statistics
Displays statistics on events that have occurred for the selected component, grouped per event ID, and presented as a numerical count and in graph form.
For more information about these pages, see online help for Ingres Visual Manager.
|
|
|
The Parameters page under the Ingres Installation branch contains lists of parameters for system, user, and extra parameters along with their values and descriptions. You can add or unset a parameter and edit its value. You can also choose whether you want to view Ingres parameters that are not currently set.
For more information, see the online help topic, Parameters Page, Ingres Installation branch (Ingres Visual Manager window).
|
|
|
From IVM, you can access the Configuration Manager utility to configure parameters for each server component in the Ingres installation. To access Configuration Manager, select the desired server component in the left pane of the Ingres Visual Manager window and click the Configuration Manager toolbar button, or choose File, Configure.
For more information, see the online help topic, Configuring Ingres Components in the Ingres Visual Manager online help.
|
|
|
Using IVM, you can control how various types of Ingres error log messages are handled. The Define Message Categories and Notification Levels dialog lets you specify which messages in the errlog.log must be discarded, which are displayed normally in IVM, and which trigger a special alert. This dialog also allows you to group messages according to user-defined categories, which can be handled as a group for discard, display or alert.
To access the Define Message Categories and Notification Levels dialog, click the Categories and Notification Levels toolbar button, or choose File, Categories and Notification Levels. For information on using this dialog, see the Ingres Visual Manager online help.
|
|
|
Using the Preferences dialog in IVM, you can specify the following settings related to event monitoring.
To access the Preferences dialog, click the Preferences toolbar button, or choose File, Preferences.
|
|
|
When an Alert message is written to the Ingres errlog.log file, IVM indicates the alert through a special icon change in the tray toolbar and in the IVM window tree. IVM also lets you set additional preferences for alert notification using the Preferences dialog. These additional preferences include:
When selected, you are alerted of an event by a sound (beep).
When selected, you are alerted of an event by a message box if there are unread "Alert" messages.
When selected, the full text of all "Alert" messages resulting from new events are logged in the Operating System [Application] Event log in addition to the Ingres errlog.log file. If this option is selected, you can also set preferences for generating specific Operating System events.
To access the Preferences dialog, click the Preferences toolbar button, or choose File, Preferences. For instructions on setting these additional preferences, see the Preferences dialog topic in the Ingres Visual Manager online help.
|
|
|
IVM allows you to view an explanation for any Ingres message in the errlog.log file. To view an explanation for a message in the errlog.log file:
For details about the Message Explanation window, see the Ingres Visual Manager online help.
|
|
|
You can monitor the following components through IVM
|
|
|
For each of the following server components as well as their instances, you can use Ingres Visual Manager to monitor status, logged events, and event statistics:
For more information on monitoring server components, see online help for Ingres Visual Manager.
|
|
|
The Logged Events page displays a list of the logged events for the Logging System branch, and any of its sub-branches. However, the messages are filtered according to certain preferences you define in the Preferences dialog.
For more information, see online help for Ingres Visual Manager.
|
|
|
The Logged Events page displays a list of the logged events for the Locking System. However, the messages are filtered according to certain preferences you define in the Preferences dialog. For more information, see online help for Ingres Visual Manager.
|
|
|
IVM provides direct access to all Ingres visual tools and online documentation. (The only exception is the Ingres Service Manager, whose functionality is already provided by IVM.)
You can access Ingres tools and documentation in the following ways:
Note: Only the most frequently used tools are accessible from this toolbar.
|
|
|
Visual Performance Monitor can be used as a monitoring tool, a performance analysis tool, and a system management tool.
Visual Performance Monitor lets you monitor the following:
You can view a list of the servers that are started on an Ingres installation, and information about each server. For example, you can view the sessions that are currently active for each server. You can also remove a session or stop a server (if you are a privileged user).
Visual Performance Monitor provides the following information for a particular server:
You can monitor users for whom there are open sessions. You can find out which sessions are open for a particular user, and drill down further to reveal all the related information about those sessions (lock lists, transactions locked, databases locked, and so on).
You can view logging system summaries, transaction lists, process, and database lists. Log information can be used to monitor transaction rates, log file activity, processes, and databases in the logging system. This information is useful in determining which logging parameters need to be adjusted.
You can monitor lock information to help determine which lock parameters need to be adjusted. Viewing locking system summaries, lock lists, and resources provides you with the information you need to spot conditions when, for example, additional locking system resources need to be added.
Viewing your lock lists is useful for locating transactions that cannot proceed because they are blocked by another transaction.
You can view your performance information from a "database" point of view. This means you can access performance information using a database branch, as opposed to the root branches of Visual Performance Monitor.
You can start, stop, and monitor Replicator servers that are required for the replication scheme that has been defined in a VDBA DOM window. You can set up startup parameters for these servers, send events to these servers, view and manage collisions, and display other miscellaneous replication monitor information.
Visual Performance Monitor lets you perform the following actions:
|
|
|
The Visual Performance Monitor window contains a list of categories under which various types of Ingres performance information appears. Under each root object category are branches representing each performance entity. Under each branch are one or more sub-branches that pertain to the particular type of performance entity.
For more information, see the Visual Performance Monitor online help. For context-sensitive help on any active dialog or window, press F1.