Is there a monitoring script to keep track of how much data is replicated.
Since the monitoring scripts described below, don't offer a way to keep track of how much data volume is being replicated, a recommendation is to track of the archive log switches to keep track of how much volume is being replicated.
The SharePlex monitoring utilities/scripts reports general errors and alert you of a preset number of messages (threshold) queued up in the queues.
Below is an overview of the SharePlex monitoring utilities from the Admin Guide:
SharePlex provides the following scripts for monitoring replication:
sp_eventmon monitors the SharePlex Event Log and reports errors that you specify in a special file.
sp_logmon monitors how well Capture is keeping pace with the changes entering the redo logs. If Capture loses pace by a specified number of logs, sp_logmon alerts you before the logs wrap so that you can take corrective action.
sp_ps monitors the SharePlex processes and notifies you if one or more are stopped so that you can correct the problem before the logs wrap or the queues exceed available disk space.
sp_qstatmon monitors the status of the SharePlex queues and sends a warning if the backlog exceeds a threshold (limit) that you define. This enables you to take corrective action before the queues exceed available disk space and replication is adversely affected.
The monitoring scripts provide the following benefits:
- Less need for frequent status checks with sp_ctrl status commands.
- Flexibility to run independently at regular intervals or as a scheduled crontab job.
- Custom configuration capabilities.
- Regular output to a log file on the system being monitored.
- E-mail and/or paging notification of conditions requiring immediate attention. The subject field of the e-mail contains a brief notation of the problem, and the contents provide the full message generated by the script.
- Platform independence. All scripts are UNIX shell scripts.
Location of the monitoring utilities. The SharePlex monitoring utilities are located in the util sub-directory of the SharePlex product directory on UNIX systems.
/SharePlex_product_directory/util
For more details, refer to the SharePlex Admin Guide, CHAPTER 8, section "Unattended SharePlex Monitoring".
