Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Informatica Proactive Monitoring 3.0 HotFix 1
  • All Products

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

Back Next

Proactive Monitoring Templates

Templates provide an easier way to create rules. You can create rules from predefined templates. You can restrict input from users by adding simple validations to the template. You can add specific user assistance wherever required to make the use of the template easier.
Sends a notification if the session elapsed time exceeds the recent average. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_completed_sessions_trending
Analytics
get_previous_no_of_completed_sessions, getPrevNSessionTimes, get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
Minimum Elapsed Minutes
Minimum elapsed minutes for the session.
count
Count of the previous N runs to be used for computing average.
percent
Percentage increase over average.
Sends a notification if the workflow running time exceeds the specified repository SLA. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_running_workflows
Sources
PowerCenter Running Workflows
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
Minimum Elapsed Minutes
Minimum elapsed minutes for the workflow.
num_runs
Number of runs to compute average.
percent
Percentage increase over average.
Notify if the session running time exceeds the folder SLA. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_running_sessions
Sources
PowerCenter Running Sessions
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
folder
PowerCenter folder name to be monitored for SLA.
sla
Enter the number of minutes that is the SLA for this folder.
Notify if total number of running sessions under a repository exceeds the threshold. The state is draft.
The following table lists the template 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
The following table describes the template parameters:
Parameter
Description
p_threshold
The threshold value for the number of running sessions.
Notify if session running time exceeds repository SLA. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_running_sessions
Sources
PowerCenter Running Sessions
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
sla
Enter the number of minutes that is the SLA for this folder.
Notify if the session running time exceeds the specified session SLA. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_running_sessions
Sources
PowerCenter Running Sessions
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
p_session_name
PowerCenter session name.
p_workflow_name
PowerCenter workflow that contains the session.
p_folder
PowerCenter folder that contains the session.
sla
Enter the number of minutes that is the SLA for this session.
Notify if the number of rows loaded for a session are less than the recent average. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_completed_sessions_trending
Sources
PowerCenter Session to Workflow Ratio
Analytics
pc_prev_no_of_completed_sessions, pc_getPrevNSessionRows, pc_get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
num_runs
Number of Runs to compute average.
percent
Percent decrease over average.
Notify if the session running exceeds the recent average by the specified threshold. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_running_sessions
Sources
PowerCenter Running Sessions
Analytics
prev_no_of_completed_sessions, getPrevNSessionTimes
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
Minimum Elapsed Minutes
Minimum elapsed minutes for the workflow
num_runs
Number of runs to compute average.
percent
Percentage increase over average.
Notify if session to workflow elapsed time ratio is less than the specified threshold. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_session_to_workflow_ratio
Sources
PowerCenter Session to Workflow Ratio
Analytics
pc_session_count_for_workflow, get_service_resource_stats
Response
PowerCenter Notification Response
Persona
datarchitect
The following table describes the template parameters:
Parameter
Description
ratio
Threshold for session to workflow elapsed time.
Notify if the session is non-responsive for a specified duration. The state is draft.
The following table lists the template 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
The following table describes the template parameters:
Parameter
Description
low_watermark
Number of rows that were processed during the last time window specified. The session is considered non-responsive only if the number of rows processed is less than this value.
p_duration
Enter the time window in minutes for which the above low watermark applies. If you set it to 60, the alert will fire if no more than the low watermark rows were processed during the past hour.
Notify if session has failed after it was saved. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_completed_sessions, pc_sessions
Sources
PowerCenter Completed Sessions, PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
duration
Enter the duration in minutes to watch for correlation between session saved and workflow failed.
Notify if the memory usage on the node exceeds the set threshold. The state is draft.
The following table lists the template properties:
Property
Value
Topic
node_system_property
Sources
Node System Monitor
Response
PowerCenter Notification Response
Persona
pcadmin
The following table describes the template parameters:
Parameter
Description
memory_perc_usage
Threshold value for memory usage in percentage.
Notify when tablespace usage exceeds the set threshold. The state is draft.
The following table lists the template properties:
Property
Value
Topic
node_database_property
Sources
Node Database Monitor
Analytics
get_no_mapping, get_no_session, get_no_transformation, get_no_workflow
Response
PowerCenter Notification Response
Persona
pcadmin
The following table describes the template parameters:
Parameter
Description
database_usage_threshold
Threshold value for database tablespace usage in percentage.
Notify with statistics when tablespace usage exceeds the set threshold. The state is draft.
The following table lists the template properties:
Property
Value
Topic
node_database_property
Sources
Node Database Monitor
Analytics
get_no_mapping, get_no_session, get_no_transformation, get_no_workflow
Response
PowerCenter Notification Response
Persona
pcadmin
The following table describes the template parameters:
Parameter
Description
database_usage_threshold
Threshold value for database tablespace usage in percentage.
no_mapping_threshold
Threshold for total number of mappings.
no_session_threshold
Threshold for total number of sessions.
no_transformations_threshold
Threshold for total number of transformations.
no_workflows_threshold
Threshold for total number of workflows.
Notify if the total CPU consumption on the integration service node exceeds the specified threshold. The state is draft.
The following table lists the template properties:
Property
Value
Topic
node_system_property
Sources
Node System Monitor
Response
PowerCenter Notification Response
Persona
pcadmin
The following table describes the template parameters:
Parameter
Description
cpu_perc_usage
Threshold value for CPU usage in percentage.
Notify if CPU utilization for a process running on the integration service exceeds the threshold value. The state is draft.
The following table lists the template properties:
Property
Value
Topic
node_process_property
Sources
Node Process Monitor
Response
PowerCenter Notification Response
Persona
pcadmin
The following table describes the template parameters:
Parameter
Description
cpu_usage_threshold
Threshold value for CPU usage in percentage.
Notify if memory usage for a process running on the integration service exceeds the threshold value. The state is draft.
The following table lists the template properties:
Property
Value
Topic
node_process_property
Sources
Node Process Monitor
Response
PowerCenter Notification Response
Persona
pcadmin
The following table describes the template parameters:
Parameter
Description
memory_usage_threshold
Threshold value for memory usage in percentage.
Notify if the workflow misses its schedule by the specified duration. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_missed_workflows
Sources
PowerCenter Scheduler Missed Workflows
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
pcadmin
The following table describes the template parameters:
Parameter
Description
minutes
Threshold delay expressed in minutes.
Notify if the number of concurrent workflows exceeds the specified threshold. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_concurrent_workflows
Sources
PowerCenter Concurrent Workflows
Response
PowerCenter Notification Response
Persona
pcadmin
The following table describes the template parameters:
Parameter
Description
count
Threshold for concurrent number of workflow instances.
Notify if the workflow elapsed time exceeds previous average. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_completed_workflows_trending
Sources
PC_OW11 Completed workflow cache for persistence framework
Analytics
prev_no_of_completed_workflows, PrevNWorkflowTimes, get_service_resource_stats
Response
PowerCenter Notification
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
Minimum Elapsed Minutes
Minimum elapsed minutes for the workflow.
num_runs
Number of runs to compute average.
percent
Percentage increase over average
Notify if the running workflow misses its next scheduled run by the specified SLA. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_missed_workflows
Sources
PowerCenter Scheduler Missed Workflows
Analytics
pc_is_workflow_running, get_service_resource_stats
Response
PowerCenter Notification Response
Persona
pcadmin
The following table describes the template parameters:
Parameter
Description
minutes
Threshold delay expressed in minutes.
Notify if the workflow running time exceeds the recent average for the specified number of runs. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_running_workflows
Sources
PowerCenter Running Workflows
Analytics
pc_getPrevNWorkflowTimes, get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
Minimum Elapsed Minutes
Minimum elapsed minutes for the workflow
num_runs
Number of runs to compute average.
percent
Percentage increase over average.
Notify if the workflow running time exceeds the specified workflow SLA. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_running_workflows
Sources
PowerCenter Running Workflows
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
p_workflow_name
PowerCenter workflow name.
p_folder
PowerCenter folder name that contains the workflow.
sla
Number of minutes that is the SLA for this workflow.
Notify if the workflow running time exceeds the specified folder SLA. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_running_workflows
Sources
PowerCenter Running Workflows
Analytics
get_service_resource_stats
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
folder
PowerCenter folder.
sla
Number of minutes that is the SLA for this workflow.
Notify if number of errors in a workflow for a specified duration matches the threshold. The state is draft.
The following table lists the template properties:
Property
Value
Topic
pc_failed_workflows
Sources
PC_OW6 Send notification for failed workflows
Response
PowerCenter Notification Response
Persona
apparchitect
The following table describes the template parameters:
Parameter
Description
count
Number of errors that will trigger the alert.
duration
Specify the duration threshold you want to check for.
0 COMMENTS
We’d like to hear from you!