Table of Contents

Search

  1. Preface
  2. Proactive Monitoring for PowerCenter Governance Overview
  3. Monitoring PowerCenter Governance
  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

Governance User Guide

Governance User Guide

Advanced Rules

Advanced Rules

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

PC_GM1 Check for mappings without description

Notify if the description for a mapping is NULL. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_mappings
Source
PowerCenter Mappings Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GM2 Check for duplicate mappings

Notify if the name of the mapping is duplicated. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_mappings
Analytics
pc_is_mapping_duplicate
Source
PowerCenter Mappings Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GM3 Check whether the mappings is not valid

Notify if a mapping is not valid. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_mappings
Source
PowerCenter Mappings Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GM4 Check for mapping names with spaces

Notify if the mapping name has spaces. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_mappings
Source
PowerCenter Mappings Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS1 Check whether the session is not valid

Notify if the session is not valid. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS2 Check for sessions without description

Notify if the description for a session is NULL. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Sessions Modified Incremental
Persona
apparchitect

PC_GS4 Check for duplicate sessions

Notify if a session name is repeated. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Analytics
pc_is_session_duplicate
Source
PowerCenter Sessions Incremental
Response
PowerCenter Sessions Modified Incremental
Persona
apparchitect

PC_GS5 Check whether a sessions is not reusable

Notify if a session is not reusable. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS6 Check if session log file name is not derived from the session name

Notify if the session log file name does not contain the session name. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Analytics
c_get_session_attribute
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS7 Check whether the truncate table option is set

Notify if
truncate target table
is set. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Analytics
pc_get_session_mapping_attribute
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS10 Check for disabled sessions

Notify if a session is disabled. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS11 Check for hardcoded source connection parameters in a session

Notify if the source connection value of a session does not begin with $. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Analytics
pc_get_session_attribute
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS15 Check whether both the parent fail options are not set

Notify if a session has both Fail parent if the task fails and Fail parent if this task does not run options not set. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Analytics
task_parent_failure_options
Source
Sessions Modified Incremental
Response
Notification Response
Persona
apparchitect

PC_GS17 Check whether the option fail parent if this task does not run is not set

Notify if a session has the option "
ail parent if this task does not run
not set. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Analytics
pc_get_task_parent_failure_options
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS18 Check whether target connection value is empty

Notify if a
Target connection value
is empty for a session. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Analytics
pc_get_session_attribute
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GT1 Check for transformations without description

Notify if the description for a transformation is NULL. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_transforms
Source
PowerCenter Transforms Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GT2 Check for transformations with default names

Notify if the transformation are saved with default names. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_transforms
Source
PowerCenter Transforms Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GT6 Check whether connection information option is set

Notify if the
Connection Information
option is not set. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_transforms
Analytics
pc_get_transform_attribute
Source
PowerCenter Transforms Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GMP2 Check whether the mapplet is not valid

Notify if a mapplet is not valid. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_mapplets
Source
PowerCenter Mapplets Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GWK2 Check whether the worklet is not valid

Notify if a worklet is not valid. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_worklets
Source
PowerCenter Worklets Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GW1 Check for workflows without description

Notify if the description for a workflow is NULL. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_workflows
Source
PowerCenter Mappings Modified Incremental
Response
PowerCenter Sessions Modified Incremental
Persona
apparchitect

PC_GW2 Check for duplicate workflows

Notify if a workflow name is repeated. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_workflows
Analytics
pc_is_workflow_duplicate
Source
PowerCenter Workflows Incremental
Response
PowerCenter Sessions Modified Incremental
Persona
apparchitect

PC_GW4 Check for workflows that are not valid

Notify if the workflow is not valid. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_workflows
Source
PowerCenter Workflows Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GW5 Check if the workflow is a web service

Notify if the workflow is a web service. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_workflows
Source
PowerCenter Mappings Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GW7 Check if workflow log file name is not derived from workflow name

Notify if the Workflow Log File name does not contain the workflow name. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_workflows
Analytics
pc_get_workflow_attribute
Source
PowerCenter Workflows Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GW10 Check for hardcoded UNIX path

Notify if the command tasks contain hard coded UNIX path names. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_command_tasks
Source
PowerCenter Command Tasks
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GW11 Check for illegal command tasks

Notify if the workflow contains illegal command tasks listed in the PowerCenter CLI command watchlist. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_command_tasks
Source
PowerCenter Command Tasks
Response
PowerCenter Notification Response
Persona
apparchitect

PC_S1 RTAM Notification

Generate a
Real-Time Alert Manager
notification. State is deployed.
Do not edit. For internal use.

PC_S2 Email Notification

Generate email notification. State is deployed.
Do not edit. For internal use.

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
Analytics
pc_get_alert_history_csv, pc_get_purge_cutoff_date
Source
PowerCenter Daily Alert History Purge Requestor
Response
PowerCenter
Real-Time Alert Manager
Alert
Persona
pcmonitor

PC_S4 Zero records purged from alert history

Send a daily report when zero records are purged.
The following table lists the rule properties:
Property
Value
Topic
pc_alert_history_purge_request
Analytics
pc_get_alert_history_purge_count, pc_get_purge_cutoff_date
Source
PowerCenter Daily Alert History Purge Requestor
Response
PowerCenter
Real-Time Alert Manager
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
Analytics
pc_get_alert_history_purge_count, pc_get_purge_cutoff_date
Source
PowerCenter Daily Alert History Purge Requestor
Response
PowerCenter
Real-Time Alert Manager
Alert
Persona
pcmonitor

PC_S6 Load Global Settings from Database

Generate a
Real-Time Alert Manager
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
Analytics
pc_get_rtam
Source
PowerCenter Load PMPC Global Settings from Database
Response
PowerCenter
Real-Time Alert Manager
Alert
Persona
pcmonitor

PC_S7 SNMP Notification Response

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

PC_S8 RTAM and Email Notification

Generate RTAM and Email Notification. State is deployed.
Do not edit. For internal use.
The following table lists the rule properties:

PC_GS21 Check whether the session Target Load Type is Bulk

Notify if the session "Target Load Type" is set to "Bulk." State is draft.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Analytics
pc_get_session_mapping_attribute
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

0 COMMENTS

We’d like to hear from you!