Chat now with support
Chat with Support

SharePlex Manager 3.0 - User Guide

Setting Up E-mail Notifications

You can configure a SharePlex Manager alert and alarm rule so that e-mail notifications are sent out to specific users whenever the conditions of that rule are met.

Note
Setting up e-mail notifications for alert and alarm rules is a function of Foglight administration. The following instructions are meant as a quick start guide specifically for SharePlex Manager users. For more detailed instructions, see the section “Working with Rules” in the Foglight Administration and Configuration Guide.
To set up e-mail notifications for a SharePlex Manager rule:
1
Select Administration>Rules & Notifications>Manage Registry Variable.
2
In the Filter by Variable Name field, enter “mail.”
This displays the mail-specific Registry Variables.
Here you must specify the following e-mail variable settings:
•
SharePlex_To_Email_Address - the recipients of the e-mail
•
mail.host - the e-mail host machine
•
mail.from - the sender’s e-mail address
Optionally, you can also set a value for the SharePlex_Email_Subject_Prefix variable if you want to specify a different prefix in the e-mail subject line. By default, the prefix is [SharePlex Manager].
Note
For detailed descriptions of each e-mail variable, see the Foglight Administration and Configuration Guide.
3
Set the appropriate values for SharePlex_To_Email_Address, mail.from, and mail.host by clicking on the Variable Name.
This opens the Edit Registry Variable page.
4
Enter the appropriate value into the Global Default field and click Save.
After configuring the default variables for SharePlex Manager e-mail notifications, you need to enable any rules you want to trigger the e-mail, if they are not enabled already and (optionally) specify different e-mail recipients if you want to override the default recipients at a specific severity level.
Note
For instructions on modifying the default behavior and schedule of a SharePlex Manager Rule, contact Quest Support.
5
Select Administration>Rules & Notifications>Manage Rules.
6
In the Manage Rules page, select the SharePlex Manager rule you want.
7
Enable the rule, if needed.
Note
For instructions on enabling rules, see “Enabling SharePlex Manager Rules” on page 43.
8
(Optional) If you want to override the default e-mail recipient value at a specific rule severity level, do the following:
a
Open the severity level at which you want to override the default e-mail recipient value.
b
Click the Severity Level Variables tab.
c
Click the To variable.
d
In the Expression/Message field, add the e-mail address of each recipient you want with commas separating multiple entries.
You can also remove the default recipient by deleting the @ToEmail value.

Appendix: SharePlex Manager Dashboard

Contents 
Replication Overview
Instance Overview
Instance Detail
Viewing, Clearing and Ignoring Events

Replication Overview

Purpose

Replication Overview displays a list of each replication stream within the selected replication view.

How to Get Here

The Replication Overview window is the default view displayed in the SharePlex Manager Dashboard. If you switch to Instance Overview, you can return to Replication Overview by clicking Display Replication Overview.

 
Description of the View
Status
Indicates the overall status of the replication in three parts.
•
The left-hand drum indicates worst-case status of all source-related activities, including the status of SharePlex Manager's connection to the source SharePlex instance, source-related events, the state (running or not running) of Capture and Read processing tasks, and alert/alarm levels for data collected. Yellow indicates a warning and red indicates a failure.
•
The connector arrow indicates worst-case status of the replication between source and target, including the ability of SharePlex Manager to connect, or not connect, to the source machine. The source-to-target connectivity is represented by the process state (running or not running) for export process on the source or for import processes on all targets. A solid line indicates an active connection and a broken line indicates an inactive or broken connection.
•
The right-hand drum indicates worst-case status of all target-related activities, including the status of SharePlex Manager’s connection to the target SharePlex instance, the events that are target-related, the state (running or not running) of post processing tasks, and alert/alarm levels for data collected. Yellow indicates a warning and red indicates a failure.
Note
Position your cursor over a source or target drum to view a pop-up window that summarizes all the errors and warnings that have been reported for each SharePlex instance as well as the status of each process in the replication stream.
Stream Name
Name of the replication stream name.
Instance Name
Names of the source and target SharePlex instances. If there are multiple targets, the data includes the number of target instances instead of each name.
Note
You can open the SharePlex Instance Properties window for any of the instances listed. Click in the field and then in the pop-up click the name of the instance you want. For more information on the SharePlex Instance Properties window, see “Editing SharePlex Instances” on page 28.
Latency
The latency of a replication stream is the same as the latency of the slowest Post process in all the target instances included in that replication stream. Post process latency is calculated as the posted time of the target minus the source Redo log time.
Note
Click the sparkline to open an expanded view of the Latency data.
Operation Rate
The operation rate equals the current count of Oracle operations per second minus the previous operation count (current timestamp - previous timestamp).
Note
Click the sparkline to open an expanded view of the Operation Rate data.
Operations in Period
The number of Oracle operations processed over the current view period as configured in Foglight (defaults to the last 4 hours). This metric considers cases where a process is restarted and the number goes down. In this case, the value becomes the count of current operations processed.
Total Operations
The total number of operations completed for all post processes. This value decreases if a process is restarted, but it should continue to increase as operations are executed through the system. As long as data is being processed, this value will constantly change.
Note
This number increases as data is processed, which indicates that SharePlex Manager is running.
Events
The number of error (red) and warning (yellow) SharePlex Manager log entries currently written for each instance.
Note
Click in the Event column to open the embedded Event Details view.
Where To Go Next
Drill down on any Stream Name field. Links to “Instance Detail” on page 60.
Description of Embedded Views

This view is made up of the following embedded views:

Event Details

 
Event Details
Description
Shows a detailed list of each error and warning posted to the SharePlex Manager event log for each instance in the stream. Events logged for the source instance are listed first, followed by events for each target instance in the stream.
Time
The time the log was posted.
Event Level
The type of log entry. Options include Error, Warning, and Information.
Messages
The system-generated contents of the log.
Event Count
The total number of logs entered for the same event.

Instance Overview

Purpose

The Instance Overview dashboard displays a list of each currently monitored SharePlex instance, organized by replication stream. For each stream, the source SharePlex instance is associated with the source database while each target instance is associated with its respective target database.

How to Get Here

In Replication Overview, click Display Instance Overview.

 
Description of the View
Status
Indicates the status of the source instance and each target instance in the replication stream, represented in a tree view.
•
The parent drum indicates worst-case status of all source-related activities, including the status of SharePlex Manager's connection to the source SharePlex instance, source-related events, the state (running or not running) of Capture and Read processing tasks, and alert/alarm levels for data collected.
•
The connector arrow indicates worst-case status of the replication between source and target, including the ability of SharePlex Manager to connect, or not connect, to the source machine. The source-to-target connectivity is represented by the process state (running or not running) for export process on the source or for import processes on all targets. A solid line indicates an active connection and a broken line indicates an inactive or broken connection.
•
Each child drum indicates worst-case status of all target-related activities, including the status of SharePlex Manager’s connection to the target SharePlex instance, the events that are target-related, the state (running or not running) of post processing tasks, and alert/alarm levels for data collected.
Note
Position your cursor over a source or target drum to view a pop-up window that summarizes all the errors and warnings that have been reported for that SharePlex instance, as well as the status of each associated process.
Stream Name
Name of the replication stream.
Instance Name
Names of the SharePlex source and target instances.
Note
Click the name of an instance to open the SharePlex Instance Properties window for that instance. For more information on the SharePlex Instance Properties window, see “Editing SharePlex Instances” on page 28.
Rate
Indicates completed operations per second:
•
For source instances, indicates the number of operations completed by the Export process.
•
For target instances, indicates the number of operations completed by the Post process.
Note
Click the sparkline to open an expanded view of the Rate data.
Time Remaining
Indicates the projected amount of time remaining in seconds for processing to return to its baseline operating level. For more information, see “How Time Remaining is Calculated” on page 58.
Note
Click the value to open an expanded view of the Time Remaining data, which includes separate time remaining values for each process (Capture, Read, and Export for source instances and Post for target instances).
Events
The number of error (red) and warning (yellow) SharePlex Manager log entries currently written for each instance.
Note
Click the event log to open the embedded Event Details view.
Where To Go Next

Drill down on any Stream Name field. Links to “Instance Detail” on page 60.

How Time Remaining is Calculated

In the Instance Overview dashboard, the time remaining value reported for each instance is an aggregate of the time remaining values calculated for the individual processes running on that instance:

•
For a source instance, the general time remaining value equals the highest time remaining value of all the current Export processes plus the values of the current Capture and Read process.
•
For a target instance, the general time remaining value equals the highest time remaining value of all the current Post processes.

For Capture processes, SharePlex Manager bases the time remaining value on the current latency. For Read, Export, and Post processes, the time remaining value is based on the current size of the backlog.

After determining the latency or backlog size for a process, SharePlex Manager compares that number to the baseline, which is 110% of the weekly moving metric average (latency or backlog). The extra 10% is added to take in account normal fluctuations in latency or backlog sizes.

SharePlex Manager then calculates the amount of time in seconds it should take the process to return to its baseline operating level and reports this projection as the time remaining value. Any time remaining value greater than 0 means that the latency or backlog size is higher than the baseline, while a time remaining rate of 0 means that the latency or backlog size is equal to or less than the baseline.

Note
Because the baseline is a weekly moving average, time remaining values may be misleading within the first week of monitoring the instances in a particular replication stream, especially if the replication stream was discovered while processing a large amount of data. For this reason, SharePlex Manager allows you to reset the baseline time remaining value on a particular replication stream. For more information on resetting the time remaining value, see “Editing Replication Streams” on page 31.
Description of Embedded Views

This view is made up of the following embedded views:

•
Event Details
 
 
 
 
 
 
 
Event Details
Description
Shows a detailed list of each error and warning posted to the SharePlex Manager event log for each instance in the stream. Events logged for the source instance are listed first, followed by events for each target instance in the stream.
Time
The time the log was posted.
Event Level
The type of log entry. Options include Error, Warning, and Information.
Messages
The system-generated contents of the log.
Event Count
The total number of logs entered for the same event.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating