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

Governance User Guide

Governance User Guide

Topic Properties

Topic Properties

The tables list the properties for the topics in Proactive Monitoring for PowerCenter Governance:
The following table lists the properties for the pc_sessions topic:
Property
Description
session_is_valid
Indicates whether the session status is valid.
session_is_impacted
Indicates whether there is an impact on a session status when a user makes a change in the session.
curr_tstamp
Indicates the current time of event generation.
version_number
Indicates the version number of the PowerCenter session that a user modifies within the incremental time window.
session_last_saved
Indicates the time stamp when the PowerCenter session was last saved within the incremental time window.
workflow_name
Indicates the workflow name of the associated PowerCenter session.
tstamp
Indicates the time stamp when the PowerCenter session was last saved within the incremental time window.
session_id
Indicates the internal ID generated within PowerCenter for the session.
mapping_last_saved
Indicates the last saved time for the mapping associated with the PowerCentre session.
is_reusable
Indicates whether you can reuse the session.
is_enabled
Indicates whether you can enable or disable the session.
session_name
Indicates the name of the PowerCenter session.
mapping_name
Indicates the mapping name associated with the PowerCenter session.
rs
Indicates the Repository Service name associated with the PowerCenter session.
session_comments
Provides the comments in the section content of the session.
folder
Indicates the folder name associated with the session.
domain
Indicates the domain name associated with the session.
user_name
Indicates the name of the user who enforced a change to the PowerCenter session within the incremental time window.
The following table lists the properties for the pc_mapplets topic:
Property
Description
comments
Provides the comments in the section content of the mapplet.
mapplet_name
Indicates the name of the PowerCenter mapplet.
last_saved
Indicates the time stamp when the PowerCenter mapplet was last saved within the incremental time window.
is_valid
Indicates whether the mapplet status is valid.
mapplet_id
Indicates the internal ID generated within PowerCenter for the mapplet.
rs
Indicates the Repository Service name associated with the PowerCenter mapplet.
folder
Indicates the folder name associated with the mapplet.
domain
Indicates the domain name associated with the mapplet.
user_name
Indicates the name of the user who enforced a change to the PowerCenter mapplet within the incremental time window.
version_number
Indicates the version number of the PowerCenter mapplet that a user modifies within the incremental time window.
tstamp
Indicates the time stamp when the PowerCenter mapplet was last saved within the incremental time window.
The following table lists the properties for the pc_worklets topic:
Property
Description
worklet_id
Indicates the internal ID generated within PowerCenter for the worklet.
comments
Provides comments of the PowerCenter worklet.
last_saved
Indicates the time stamp when the PowerCenter worklet was last saved within the incremental time window.
version_number
Indicates the version number of the modified PowerCenter worklet within the incremental time window.
worklet_name
Indicates the name of the PowerCenter worklet.
tstamp
Indicates the time stamp when the PowerCenter worklet was last saved within the incremental time window.
workflow_name
Indicates the workflow name associated with the PowerCenter worklet.
is_valid
Indicates whether the worklet status is valid.
rs
Indicates the Repository Service name associated with the PowerCenter worklet.
folder
Indicates the folder name associated with the PowerCenter worklet.
domain
Indicates the domain name associated with the PowerCenter worklet.
user_name
Indicates the name of the user who enforced a change to the PowerCenter worklet within the incremental time window.
The following table lists the properties for the pc_transforms topic:
Property
Description
mapping_id
Indicates the internal ID generated within PowerCenter for the mapping.
transform_type
Indicates the type of PowerCenter transformation. For example, type can be Source Definition or Target Definition.
last_saved
Indicates the time stamp when the PowerCenter transformation was last saved within the incremental time window.
transform_type_id
Provides the internal ID of the transformation type.
version_number
Indicates the version number of the modified PowerCenter transformation within the incremental time window.
transform_description
Provides the description of the PowerCenter transformation.
transform_name
Indicates the name of the PowerCenter transformation.
transform_id
Indicates the internal ID generated within PowerCenter for the transformation.
tstamp
Indicates the time stamp when the PowerCenter transformation was last saved within the incremental time window.
workflow_name
Indicates the workflow name associated with the PowerCenter transformation.
mapping_name
Indicates the mapping name associated with the PowerCenter transformation.
rs
Indicates the Repository Service name associated with the PowerCenter transformation.
folder
Indicates the folder name associated with the PowerCenter transformation.
domain
Indicates the domain name associated with the PowerCenter transformation.
user_name
Indicates the name of the user who enforced a change to the PowerCenter transformation within the incremental time window.
The following table lists the properties for the pc_mappings topic:
Property
Description
mapping_id
Indicates the internal ID generated within PowerCenter for the mapping.
mapping_is_valid
Indicates whether the mapping status is valid.
version_number
Indicates the version number of the modified PowerCenter mapping within the incremental time window.
tstamp
Indicates the time stamp when the PowerCenter mapping was last saved within the incremental time window.
workflow_name
Indicates the workflow name associated with the PowerCenter mapping.
mapping_name
Indicates the name of this PowerCenter mapping.
rs
Indicates the Repository Service name associated with the PowerCenter mapping.
mapping_last_saved
Indicates the time stamp when the PowerCenter mapping was last saved within the incremental time window.
folder
Indicates the folder name associated with the PowerCenter mapping.
domain
Indicates the domain name associated with the PowerCenter mapping.
mapping_description
Provides the description of the PowerCenter mapping.
user_name
Indicates the name of the user who enforced a change to the PowerCenter mapping within the incremental time window.
Property
Description
mapping_id
Indicates the internal ID generated within PowerCenter for the mapping.
mapping_is_valid
Indicates whether the mapping status is valid.
version_number
Indicates the version number of the modified PowerCenter mapping within the incremental time window.
tstamp
Indicates the time stamp when the PowerCenter mapping was last saved within the incremental time window.
workflow_name
Indicates the workflow name associated with the PowerCenter mapping.
mapping_name
Indicates the name of this PowerCenter mapping.
rs
Indicates the Repository Service name associated with the PowerCenter mapping.
mapping_last_saved
Indicates the time stamp when the PowerCenter mapping was last saved within the incremental time window.
folder
Indicates the folder name associated with the PowerCenter mapping.
domain
Indicates the domain name associated with the PowerCenter mapping.
mapping_description
Provides the description of the PowerCenter mapping.
user_name
Indicates the name of the user who enforced a change to the PowerCenter mapping within the incremental time window.
The following table lists the properties for the pc_workflows topic:
Property
Description
workflow_last_saved
Indicates the time stamp when the PowerCenter workflow was last saved within the incremental time window.
workflow_is_valid
Indicates whether the workflow status is valid.
workflow_is_runnable_service
Indicates whether the workflow is runnable, is valid, and is assigned to an Integration Service that is accessible.
version_number
Indicates the version number of the modified PowerCenter workflow within the incremental time window.
workflow_comments
Provides the comments of the PowerCenter workflow.
workflow_is_service
Indicates whether the workflow is a service workflow. You can only run a service workflow.
workflow_name
Indicates the name of the PowerCenter workflow.
tstamp
Indicates the time stamp when the PowerCenter workflow was last saved within the incremental time window.
rs
Indicates the Repository Service name associated with the PowerCenter workflow.
workflow_id
Indicates the internal ID generated within PowerCenter for the workflow.
folder
Indicates the folder name associated with the PowerCenter workflow.
domain
Indicates the domain name associated with the PowerCenter workflow.
user_name
Indicates the name of the user who enforced a change to the PowerCenter workflow within the incremental time window.
The following table lists the properties for the pc_command_tasks topic:
Property
Description
is_enabled
Indicates whether the command task is enabled.
task_name
Indicates the name of the PowerCenter command task.
version_number
Indicates the version number of the modified PowerCenter command task within the incremental time window.
workflow_name
Indicates the workflow name associated with the PowerCenter command task.
tstamp
Indicates the time stamp when the PowerCenter command task was last saved within the incremental time window.
type
Indicates the type of PowerCenter task. For example, task type can be Session, Command Task, or Start Task.
rs
Indicates the Repository Service name associated with the PowerCenter command task.
task_id
Indicates the internal ID generated within PowerCenter for the command task.
folder
Indicates the folder name associated with the PowerCenter command task.
attribute
Indicates the attribute name associated with the PowerCenter command task.
domain
Indicates the domain name associated with the PowerCenter command task.
user_name
Indicates the name of the user who enforced a change to the PowerCenter command task within the incremental time window.
The following table lists the properties for the pc_running_sessions_workflows_count topic:
Property
Description
is_name
Indicates the Integration Service name associated with the PowerCenter sessions and workflows that are running.
session_cnt
Indicates the number of sessions running within the Informatica domain.
tstamp
Indicates the snapshot time when the count of running sessions and workflows was extracted.
rs
Indicates the Repository Service name associated with the running PowerCenter sessions and worflows.
workflow_cnt
Indicates the number of workflows that run within the Informatica domain.
domain
Indicates the domain name associated with the running PowerCenter sessions and worflows.

0 COMMENTS

We’d like to hear from you!