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. Troubleshooting
  13. Topic Properties Reference
  14. Frequently Asked Questions
  15. Glossary

Operations User Guide

Operations User Guide

Template Rules

Template rules are created from templates by specifying values for the parameters. You can customize these template rules based on the requirement.
Notify if the total CPU consumption of the integration service node exceeds 90 percent. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
node_system_property
Sources
Node System Monitor
Response
PowerCenter Notification Response
Persona
pcadmin
Notify if the memory consumption of the integration service node exceeds 90 percent. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
node_system_property
Sources
Node System Monitor
Analytics
get_no_running_workflow, get_no_running_task
Response
PowerCenter Notification Response
Persona
pcadmin
Notify if the CPU utilization of the integration service node exceeds 50 percent. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
node_process_property
Sources
Node Process Monitor
Response
PowerCenter Notification Response
Persona
pcadmin
Notify if the memory consumption of the integration service node exceeds 50 percent. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
node_process_property
Sources
Node Process Monitor
Response
PowerCenter Notification Response
Persona
pcadmin
Notify if the repository service database space consumption exceeds 90 percent. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
node_database_property
Sources
PowerCenter Repository Database Tablespaces
Analytics
get_no_mapping, get_no_session, get_no_transformation, get_no_workflow
Response
PowerCenter Notification Response
Persona
pcadmin
Notify if the session running time exceeds the average of the previous three runs by 25 percent. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_sessions
Sources
PowerCenter Running Sessions
Analytics
get_previous_no_of_completed_sessions, pc_getPrevNSessionTimes
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if a running session does not load any rows for 15 minutes. When this rule is activated, the response restarts the workflow where the session is not responding. Deploy this rule if you want to restart the workflow. State is draft.
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, PowerCenter Web Service Hub Workflow Control Response
Persona
pcadmin
Notify if total number of running sessions under a repository exceeds 100. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_sessions_count
Sources
PowerCenter Running Sessions Count
Analytics
get_running_sessions_count_csv
Response
PowerCenter Notification Response
Persona
pcadmin
Notify if the session running time exceeds the folder SLA of 6 minutes. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_sessions
Sources
PowerCenter Running Sessions
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if the session running time exceeds the SLA of 10 minutes. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_sessions
Sources
PowerCenter Running Sessions
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if the number of rows loaded by a session is 25 percent less than the recent average. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sess_trending
Sources
PC_OS13 Completed session cache for persistence framework
Analytics
get_previous_no_of_completed_sessions, pc_getPrevNSessionRows, get_service_resource_stats
Response
PowerCenter Notification Response
Persona
dataarchitect
Notify if the ratio of elapsed time for a session to workflow is less than 0.6. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_session_to_workflow_ratio
Sources
Session to Workflow Ratio
Analytics
pc_get_session_count_for_workflow
Response
PowerCenter Notification Response
Persona
dataarchitect
Notify if the session elapsed time exceeds the recent average by 25 percent for the monitored folders. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_sessions_trending
Sources
PC_OS13 Completed session cache for persistence framework
Analytics
get_previous_no_of_completed_sessions, pc_getPrevNSessionRows, get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if the session running time for s_m_load_sports_events exceeds the SLA of 4 minutes. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_sessions
Sources
PowerCenter Running Sessions
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if a session failed within 30 minutes since it was last saved. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_sessions
Sources
PowerCenter Running Sessions
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if a running workflow missed its schedule by three minutes. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_missed_workflows
Sources
PowerCenter Scheduler Missed Workflows
Analytics
is_workflow_running, get_service_resource_stats
Response
PowerCenter Notification Response
Persona
pcadmin
Notify if the Workflow Load Mobile records is running more than two minutes. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_workflows
Sources
PowerCenter Running Workflows
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if three errors occur in the same workflow within 60 minutes. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_failed_workflows
Sources
PC_OW6 Send notification for failed workflows
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if a workflow running time exceeds folder SLA of five minutes. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_workflows
Sources
PowerCenter Running Workflows
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if a workflow running time exceeds repository SLA by 10 minutes. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_workflows
Sources
PowerCenter Running Workflows
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if the workflow running time exceeds the recent average. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_running_workflows
Sources
PowerCenter Running Workflows
Analytics
pc_getPrevNWorkflowTimes, get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
Notify if the workflow missed its schedule by three minutes. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_missed_workflows
Sources
PowerCenter Scheduler Missed Workflows
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
pcadmin
Notify if the number of concurrent workflows exceeds the threshold of two. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_concurrent_workflows
Sources
PowerCenter Concurrent Workflows
Response
PowerCenter Notification Response
Persona
pcadmin
Notify if the workflow elapsed time exceeds the recent average by 25 percent. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_completed_workflows_trending
Sources
PC_OW11 Completed workflow cache for persistence framework
Analytics
prev_no_of_completed_workflows, pc_getPrevNWorkflowTimes, get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect

0 COMMENTS

We’d like to hear from you!