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

Template Rules

Template Rules

You can create rules from the template rules by specifying values based on the requirement.

PC_GM5 Mapping name should begin with m_

Notify if the mapping name does not begin with m_. 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_GM6 Check if a mapping is modified 3 times within the last 60 minutes

Notify if a mapping is modified three times within the last 60 minutes. 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_GS3 Session name should begin with s_

Notify if the session name does not begin with s_. 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_GS8 Check whether rollback of transaction on error is not set

Notify if a
Rollback Transactions on Error
is not set 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_GS9 Check if session is modified 3 times within the last 60 minutes

Notify if the session is modified three times within the last 60 minutes. 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_GS12 Check whether save session log for these runs uses the global variable PMSessionLogCount

Notify if
Save session log for these runs
attribute does not use the global variable
$PMSessionLogCount
. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_sessions
Analytics
pc_get_session_attrib
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS13 Check whether stop on errors uses the global variable PMSessionErrorThreshold

Notify if
Stop on errors
attribute does not use the global variable
$PMSessionErrorThreshold
. State is deployed.
The following table lists the rule properties:
Property
Value
Topic
pc_workflows
Analytics
pc_get_session_attribute
Source
PowerCenter Sessions Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GS14 Check whether write backward compatible session log file is set

Notify whether a session does not have
Write Backward Compatible Session Log File
set. 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_GS16 Check for session where commit interval exceeds 1000 seconds

Notify if
Commit Interval
greater than equal to 1000 seconds for a session. 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_GT3 Check for transformations with lookup SQL override

Notify if the
Lookup SQL Override
for a transformation is not 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_GT4 Check for transformations with source SQL override

Notify if
SQL Query
for a transformation is not 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_GT5 Check for transformations with tracing level higher than terse

Notify if a transformation has
Tracing Level
higher than terse.
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_GT7 Check if sequence generator reset option is set

Notify if the sequence generator
Reset
option is 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_GW3 Workflow name should begin with wf_

Notify if a workflow name does not begin with wf_. 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_GW6 Check whether save workflow log for these runs used the global variable PMWorkflowLogCount

Notify if
Save workflow log for these runs
attribute does not use the global variable
$PMWorkflowLogCount
.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_GW8 Check whether backward write compatible workflow log option is set

Notify whether a workflow does not have
Write Backward Compatible Workflow Log File
set. 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_GW9 Check if Windows path name is hardcoded with drive letter C

Notify if the command task contains a hardcoded Microsoft Windows drive letter
C:\
. 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_GW13 Workflow Name should end with _DEV

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

PC_GWK3 Worklet Name should end with _DEV

Notify if the worklet name does not end with _DEV. 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_GS20 Session Name should end with _DEV

Notify if the session name does not end with _DEV. 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_GM8 Mapping Name should end with _DEV

Notify if the mapping name does not end with _DEV. 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_GMP3 Mapplet Name should end with _DEV

Notify if the mapplet name does not end with _DEV. 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_GM9 Mapping Transformation Input Port must begin with in_

Notify if transformation ports in a mapping do not start with the specified prefix. You need to deploy this rule to receive the notifications. State is draft.
The following table lists the rule properties:
Property
Value
Topic
pc_mappings
Analytics
get_mapping_ports
Source
PowerCenter Mappings Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

PC_GT8 Aggregator Transformation Name should start with AGG_

Notify if the aggregator transformation name does not start with AGG_. You need to deploy this rule to receive the notifications. State is draft.
The following table lists the rule properties:
Property
Value
Topic
pc_transforms
Source
PowerCenter Transforms Modified Incremental
Response
PowerCenter Notification Response
Persona
apparchitect

0 COMMENTS

We’d like to hear from you!