Table of Contents

Search

  1. Preface
  2. Proactive Monitoring for PowerCenter Operations
  3. Monitoring PowerCenter Operations
  4. Manage Objects
  5. Proactive Monitoring Reports
  6. Proactive Monitoring SNMP Alerts
  7. Proactive Monitoring Watchlists
  8. Proactive Monitoring Topics
  9. Proactive Monitoring Services
  10. Proactive Monitoring Templates and Rules
  11. Proactive Monitoring Responses
  12. Appendix A: Troubleshooting
  13. Appendix B: Topic Properties Reference
  14. Appendix C: Frequently Asked Questions
  15. Appendix D: Glossary

Operations User Guide

Operations User Guide

Advanced Rules

Advanced Rules

Advanced rules do not have parameters. You can extend these rules once you are comfortable with the functioning of these rules.

PC_GS19 Check for hardcoded file paths in a session

Notify if file paths for sources and targets are hardcoded in the session. You need to deploy this rule to receive the notifications. State is draft.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Sources
PowerCenter Sessions Modified Incremental
Analytics
get_session_hardcoded_paths
Response
PowerCenter Notification Response
Persona
apparchitect

PC_O1 Aggregated Ops Analytic Rule

Triggers the PowerCenter Metadata Counts Response to insert the details into the Proactive Monitoring database. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_aggregated_ops_analytics
Sources
PowerCenter Metadata Counts
Response
PowerCenter Metadata Counts Response

PC_O10 Integration service health check

Notify if the integration service is down. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_ping
Sources
PowerCenter Web Service Hub Ping Service
Response
PowerCenter Notification Response
Persona
pcadmin

PC_O11 Repository service health check

Notify if the repository service is down. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_ping
Sources
PowerCenter Web Service Hub Ping Service
Response
PowerCenter Notification Response
Persona
pcadmin

PC_O12 Domain service health check

Notify if the domain service is down. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_ping
Sources
PowerCenter Web Service Hub Ping Service
Response
PowerCenter Notification Response
Persona
pcadmin

PC_O13 Send run time server statistics

Publish the run time server statistics. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_runtime_stats
Sources
PowerCenter Web Service Hub Runtime Statistics Receiver
Response
PowerCenter Runtime Stats Transformer Response

PC_O16 Node Agent health check

Notify if the node agent is down. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
node_agent_lifecycle_monitor
Sources
Node Agent Monitor
Response
PowerCenter Notification Response
Persona
pcadmin

PC_O17 Process Lifecycle Monitor Alert

Notifies if any of the process monitored by the node agent has stopped. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
node_process_lifecycle_monitor
Sources
Node Process Lifecycle Monitor
Response
PowerCenter Notification Response, Process Monitor table update response
Persona
pcadmin

PC_O19 All Integration services health check

Notify if all the integration services under the domain are down. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_ping
Sources
PowerCenter Web Service Hub Ping Service
Response
PowerCenter Notification Response
Persona
pcadmin

PC_O20 All Repository services health check

Notify if all the repository services under the domain are down. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_ping
Sources
PowerCenter Web Service Hub Ping Service
Response
PowerCenter Notification Response
Persona
pcadmin

PC_O21 File-Folder matched the monitoring conditions configured for Host

Notify if the file and folder statistics is matching the host monitoring configuration. This rule is used for monitoring files or folders. To enable file and folder monitoring, deploy this rule along with the source, File-Folder Monitoring Stats Publisher. State is draft.
The following table lists the rule properties:
Property
Value
Topic
node_filefolder_property
Sources
File-Folder Monitoring Stats Publisher
Analytics
compare_filefolder_stats
Response
* Notification Response
Persona
pcadmin

PC_O4 Repository service database health check

Notify if the repository service database is down. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
node_database_property
Sources
Node Database Monitor
Response
PowerCenter Notification Response
Persona
pcadmin

PC_O7 Send run time transformation statistics

Publish the run time transformation statistics. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_runtime_stats
Sources
PowerCenter Web Service Hub Runtime Statistics Receiver
Response
PowerCenter Runtime Stats Transformer Response

PC_O8 Send run time workflow statistics

Publish the run time workflow statistics. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_runtime_stats
Sources
PowerCenter Web Service Hub Runtime Statistics Receiver
Response
PowerCenter Runtime Stats Transformer Response

PC_O9 Send run time session statistics

Publish the run time session statistics. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_runtime_stats
Sources
PowerCenter Web Service Hub Runtime Statistics Receiver
Response
PowerCenter Runtime Stats Transformer Response

PC_OS10 Session contains failed rows

Notify if the completed session contains failed source or target rows. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
PowerCenter Notification Response
Persona
dataarchitect

PC_OS12 Check if session runs were successful but zero rows were loaded

Notify if the session run status is successful but zero rows are loaded. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
PowerCenter Notification Response
Persona
dataarchitect

PC_OS13 Completed session cache for persistence framework

Caches the completed session records to the RulePoint repository. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
PowerCenter Notification Response

PC_OS14 Daily report of completed sessions

Send the completed sessions report for the day. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions_table_purge
Sources
PowerCenter completed sessions shadow table pu
Analytics
get_no_rows_lp_pc_completed_sessions, get_lp_pc_completed_sessions_csv, pc_get_rtam
Response
PowerCenter RTAM Alert
Persona
pcmonitor

PC_OS15 Check whether the Session Source Rejected Records is greater than Zero

Notify if a session has source rejected records greater than zero. You need to deploy this rule to receive the notifications. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
PowerCenter Notification Response
Persona
dataarchitect

PC_OS15 Check whether the Session Source Rejected Records is greater than Zero

Notify if a session has source rejected records greater than zero. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
* Notification Response
Persona
dataarchitect

PC_OS16 Check whether the Session Target Rejected Records is greater than Zero

Notify if a session has target rejected records greater than zero. You need to deploy this rule to receive the notifications.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
PowerCenter Notification Response
Persona
dataarchitect

PC_OS16 Check whether the Session Target Rejected Records is greater than Zero

Notify if a session has target rejected records greater than zero. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
* Notification Response
Persona
dataarchitect

PC_OS17 Check whether the Session Source Successful Records is equal to Zero

Notifies if a session source successful records is equal to zero. You need to deploy this rule to receive the notifications. State is draft.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
* Notification Response
Persona
dataarchitect

PC_OS18 Check whether the Session Target Successful Records is equal to Zero

Notify if a session target successful records are less than or equal to zero. You need to deploy this rule to receive the notifications. State is draft.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
* Notification Response
Persona
dataarchitect

PC_OS20 Completed session cache for reporting framework

Caches the completed session records to the PMPC repository for reporting. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
PowerCenter completed sessions report recorder response

PC_OS4 Send notification for failed sessions

Notify if the session fails. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions
Sources
PowerCenter Completed Sessions
Response
PowerCenter Notification Response
Persona
pcadmin

PC_OSW1 Running Session Workflow Counts cache for reporting framework

Caches running session workflow counts into PMPC repository for reporting. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_sessions_workflows_count
Sources
PowerCenter Running Sessions Workflows Count Report
Response
PowerCenter running session workflow count recorder response

PC_OW11 Completed workflow cache for persistence framework

Caches the completed workflow records to the RulePoint repository. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_workflows
Sources
PowerCenter Completed Workflows
Response
PowerCenter completed workflows recorder

PC_OW12 Daily report of completed workflows

Send the completed workflows report for the day. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_workflows_table_purge
Sources
PowerCenter completed workflows shadow table purge
Analytics
pc_no_rows_lp_pc_completed_workflows, get_lp_pc_completed_workflows_csv, pc_get_rtam
Response
PowerCenter RTAM Alert
Persona
pcmonitor

PC_OW14 Send notification for terminated workflows

Notify if a workflow has terminated. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_workflows
Sources
PowerCenter Completed Workflows
Response
PowerCenter Notification Response
Persona
pcadmin

PC_OW15 Completed workflow cache for reporting framework

Caches the completed workflow records to PMPC repository for reporting. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_workflows
Sources
PowerCenter Completed Workflows
Response
PowerCenter completed workflows report recorder response

PC_OW16 Check for workflows becoming unscheduled

Check if any workflow has become unscheduled. You need to deploy this rule to receive the notifications when the workflow becomes unscheduled. State is draft.
The following table lists the rule properties:
Property
Value
Topic
pc_runtime_workflow_stats
Sources
PC_O8 Send run time workflow statistics
Response
PowerCenter Notification Response
Persona
pcmonitor

PC_OW6 Publish events for failed workflows

Publish events of failed workflows to the pc_failed_workflows topic. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_workflows
Sources
PowerCenter Completed Workflows
Response
PowerCenter Runtime Stats Transformer Response

PC_OW7 Send runtime report for monitored workflow

Send runtime report for monitored workflow. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_runtime_session_stats
Sources
PowerCenter Web Service Hub Runtime Statistics Receiver
Response
PowerCenter Notification Response
Persona
pcadmin

PC_S1 RTAM Notification

Generate RTAM notification. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
Internal

PC_S2 Email Notification

Generate email notification. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
Internal

PC_S3 Daily alert history report

Send a daily report of the alert history. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_alert_history_purge_request
Sources
PowerCenter Daily Alert History Purge Requestor
Analytics
pc_get_alert_history_csv, pc_get_purge_cutoff_date
Response
PowerCenter RTAM Alert
Persona
pcmonitor

PC_S4 Zero records purged from alert history

Send a daily report when zero records are purged. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_alert_history_purge_request
Sources
PowerCenter Daily Alert History Purge Requestor
Analytics
pc_get_alert_history_purge_count, pc_get_purge_cutoff_date
Response
PowerCenter RTAM Alert
Persona
pcmonitor

PC_S5 Purge alert history

Notify when alert history is purged. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_alert_history_purge_request
Sources
PowerCenter Daily Alert History Purge Requestor
Analytics
pc_get_alert_history_purge_count, pc_get_purge_cutoff_date
Response
PowerCenter RTAM Alert
Persona
pcmonitor

PC_S6 Load Global Settings from Database

Generate RTAM alert when global settings are loaded from the database. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_pmpc_global_settings
Sources
PowerCenter Load PMPC Global Settings from Database
Analytics
pc_get_rtam
Response
PowerCenter RTAM Alert
Persona
pcmonitor

PC_S7 SNMP Notification

Generate SNMP trap for alerts. To enable sending notifications as SNMP traps, deploy this rule. State is draft.
The following table lists the rule properties:
Property
Value
Topic
pc_notifications
Response
SNMP v2 Response

0 COMMENTS

We’d like to hear from you!