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

Sources

The sources fetch data from PowerCenter repositories and run-time instances which are used for rule evaluation.
The following table lists the predefined sources that are available by default after installing
Proactive Monitoring for PowerCenter Operations
:
Source Service Name
Description
Properties
State
Node Agent Monitor
Retrieves the health status of the node agent.
  • Type: Interval based SQL Service
  • Topic: node_agent_lifecycle _monitor
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 300 seconds
Deployed
Node Process Lifecycle Monitor
Retrieves the details of process monitored by node agent.
  • Type: Interval based SQL Service
  • Topic: node_process_lifecycle_monitor
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 300 seconds
Deployed
Node Process Monitor
Retrieves the CPU and memory consuming process information from all the hosts where you have started the node agent.
  • Type: Interval based SQL Service
  • Topic: node_process_property
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
Node System Monitor
Retrieves the total CPU and memory information of all the hosts where you have started the node agent.
  • Type: Interval based SQL Service
  • Topic: node_system_property
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
Node TopNStats Table Purge
This is a system source service which is used for purging node statistics table.
  • Type: SQL
  • Topic: node_topnstats_table_purge
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 2 hours
Deployed
PowerCenter Completed Sessions
Retrieve the PowerCenter completed sessions information.
  • Type: PMPC SQL Source
  • Topic: pc_completed_sessions
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter completed sessions shadow table purge
This is a system source service used by the Persistence Framework to purge the completed sessions in the shadow table.
  • Type: SQL
  • Topic: pc_completed_sessions_table_purge
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: Daily
Deployed
PowerCenter Completed Workflows
Retrieve the PowerCenter completed workflows information.
  • Type: PMPC SQL Source
  • Topic: pc_completed_workflows
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter completed workflows shadow table purge
This is a system source service used by the Persistence Framework to purge the completed workflows in the shadow table.
  • Type: SQL
  • Topic: pc_completed_workflows_table_purge
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: Daily
Deployed
PowerCenter Concurrent Workflows
Retrieve the PowerCenter workflows that have more than one instance running concurrently.
  • Type: PMPC SQL Source
  • Topic: pc_concurrent_workflows
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter Daily Alert History Purge Requestor
Retrieve alert history purge frequency from the global settings framework. The frequency is used for purging the alert history.
  • Type: SQL
  • Topic: pc_alert_history_purge_request
  • Connected to: Rulepoint Repository (pc_rp)
  • Default interval: Daily
Deployed
PowerCenter Load PMPC Global Settings from Database
Retrieve Proactive Monitoring global settings from the RulePoint database.
  • Type: SQL
  • Topic: pc_pmpc_global_settings
  • Connected to: -
  • Default interval: 21600 seconds
Deployed
PowerCenter Metadata Counts
This source extracts the aggregate count of sessions, workflows, mappings, and transformations from PowerCenter repository and stores it in Proactive Monitoring database.
  • Type: PMPC Metadata Receiver
  • Topic: pc_aggregated_ops_analytics
  • Connected to: -
  • Default interval: 21600 seconds
Deployed
PowerCenter Repository Database Tablespaces
Retrieve the database state and tablespace details from PowerCenter repository databases.
  • Type: PMPC Database Monitor
  • Topic: node_database_property
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 10 minutes
Deployed
PowerCenter Running Sessions
Retrieve information of the all running sessions of PowerCenter.
  • Type: PMPC SQL Source
  • Topic: pc_running_sessions
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter Running Sessions Count
Retrieve the total number of sessions running in the PowerCenter repository.
  • Type: PMPC SQL Source
  • Topic: pc_running_sessions_count
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter Running Workflows
Retrieve information of all running workflows of PowerCenter.
  • Type: PMPC SQL Source
  • Topic: pc_running_workflows
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter Running Sessions Workflows Count Report
Retrieve running sessions and workflows count at a particular point in time
  • Type: PMPC SQL Source
  • Topic: pc_running_sessions_workflows_count
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter Scheduler Missed Workflows
Retrieve PowerCenter workflows that missed their schedule.
  • Type: PMPC SQL Source
  • Topic: pc_missed_workflows
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter Scheduler Scheduled Workflows Incremental
Retrieve the details of the latest schedule and the next schedule of PowerCenter workflows.
  • Type: PMPC SQL Source
  • Topic: pc_scheduled_workflows
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter Session to Workflow Ratio
Retrieve the PowerCenter sessions to workflow ratio.
  • Type: PMPC SQL Source
  • Topic: pc_session_to_workflow_ratio
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 600 seconds
Deployed
PowerCenter Sessions Modified Incremental
Retrieve the details of non-reusable PowerCenter sessions inside a worklet, reusable sessions inside a folder, and non-reusable sessions inside a workflow.
  • Type: PMPC SQL Source
  • Topic: pc_sessions
  • Connected to: PowerCenter Repository (pcrs_readonly)
  • Default interval: 21600 seconds
Deployed
PowerCenter Web Service Hub Ping Service
Retrieve the health status of a Informatica domain.
  • Type: PMPC WSH Ping Service
  • Topic: pc_ping
  • Connected to: PowerCenter Web Services Hub
  • Default interval: 600 seconds
Deployed
PowerCenter Web Service Hub Runtime Statistics Receiver
Retrieve the runtime statistics for the Informatica domain server, running and scheduled workflows, and associated sessions and targets.
  • Type: PMPC WSH Runtime Statistics Receiver
  • Topic: pc_runtime_stats
  • Connected to: PowerCenter Web Services Hub
  • Default interval: 600 seconds
Deployed
File-Folder Monitoring Stats Publisher
Publishes the monitoring statistics of files and folders on the host that the node agent collects.
This source is used for monitoring files or folders. To enable file and folder monitoring, deploy this source along with the rule, PC_O21 File-Folder matched the monitoring conditions configured for Host.
  • Type: SQL
  • Topic: node_filefolder_property
  • Connected to: Rulepoint Repository (pc_rp)
  • Default interval: 600 seconds
Draft
0 COMMENTS
We’d like to hear from you!