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. Appendix A: Troubleshooting
  13. Appendix B: Topic Properties Reference
  14. Appendix C: Frequently Asked Questions
  15. Appendix D: Glossary

Operations User Guide

Operations User Guide

Topic Properties

Topic Properties

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 tables list the properties for the topics in Proactive Monitoring for PowerCenter Operations.
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.
The following table lists the properties for the pc_running_sessions_count topic:
Property
Description
curr_tstamp
Indicates the snapshot time when the count of running sessions was extracted.
workflow_name
Indicates the workflow name associated with the running PowerCenter sessions.
no_running_sessions
Indicates the number of sessions running associated with one single workflow.
rs
Indicates the Repository Service name associated with the running PowerCenter sessions.
folder
Indicates the folder name associated with the running PowerCenter sessions.
domain
Indicates the domain name associated with the running PowerCenter sessions.
The following table lists the properties for the pc_completed_sessions topic:
Property
Description
is_name
Indicates the Integration Service name associated with the completed PowerCenter session.
throughput_rows_per_sec
Indicates the throughput rows per second of the completed PowerCenter session.
curr_tstamp
Indicates the current time of event generation.
session_elapsed_secs
Indicates the elapsed time, in seconds, of the completed PowerCenter session.
successful_source_rows
Indicates the number of successful rows extracted from the source by the completed PowerCenter session.
failed_target_rows
Indicates the number of target failed rows of the completed PowerCenter session.
session_run_status
Indicates the running status of the completed PowerCenter session.
workflow_name
Indicates the workflow name associated with the completed PowerCenter session.
tstamp
Indicates the time stamp when the data is extracted.
session_id
Indicates the internal ID generated within PowerCenter for the session.
last_error_code
Indicates the error code of the last error message encountered within the PowerCenter session.
workflow_run_id
Indicates the workflow run ID of the workflow associated with the completed PowerCenter session.
session_run_status_code
Indicates the running status code of the completed PowerCenter session.
last_error
Indicates the last error message encountered within the PowerCenter session.
session_name
Indicates the name of the completed PowerCenter session.
successful_target_rows
Indicates the number of successful rows pushed to the target by the completed PowerCenter session.
session_start_time
Indicates the start time of the completed PowerCenter session.
session_end_time
Indicates the end time of the completed PowerCenter session.
first_error_code
Indicates the error code of the first error message encountered within the PowerCenter session.
rs
Indicates the Repository Service name associated with the completed PowerCenter session.
workflow_id
Indicates the workflow ID of the workflow associated with the completed PowerCenter session.
folder
Indicates the folder name associated with the completed PowerCenter session.
failed_source_rows
Indicates the number of failed source rows of the completed PowerCenter session.
domain
Indicates the domain name associated with the completed PowerCenter session.
The following table lists the properties for the pc_session_to_workflow_ratio topic:
Property
Description
is_name
Indicates the Integration Service name associated with the PowerCenter session and workflow.
session_name
Indicates the name of the completed PowerCenter session.
session_elapsed_secs
Indicates the elapsed time, in seconds, of the completed PowerCenter session.
session_to_workflow_ratio
Indicates the ratio of the elapsed time, in seconds, of the session with the workflow.
workflow_name
Indicates the name of the completed PowerCenter workflow.
tstamp
Indicates the time stamp when the data is extracted.
workflow_elapsed_secs
Indicates the elapsed time, in seconds, of the completed PowerCenter session.
session_start_time
Indicates the start time of the completed PowerCenter session.
session_end_time
Indicates the end time of the completed PowerCenter session.
rs
Indicates the Repository Service name associated with the completed PowerCenter session and workflow.
workflow_id
Indicates the internal ID generated within PowerCenter for the workflow.
folder
Indicates the folder name associated with the completed PowerCenter session and workflow.
domain
Indicates the domain name associated with the completed PowerCenter session and workflow.
The following table lists the properties for the pc_runtime_server_stats topic:
Property
Description
server_status
Indicates the status of the PowerCenter Integration Service.
server_startup_time
Indicates the start time of the PowerCenter Integration Service.
is_name
Indicates the name of the PowerCenter Integration Service.
server_current_time
Indicates the current time of the PowerCenter Integration Service.
workflow_name
Indicates the name of the PowerCenter workflow.
rs
Indicates the Repository Service name associated with the PowerCenter Integration Service.
folder
Indicates the folder name associated with the PowerCenter Repository Service.
message_subject
Indicates the message subject. In this case, it is - server.
num_workflows
Indicates the number of running workflows.
domain
Indicates the domain name associated with the completed PowerCenter Integration Service.
The following table lists the properties for the pc_missed_workflows topic:
Property
Description
seconds_delayed
Indicates the delayed time unit in seconds of the missed workflow.
is_name
Indicates the integration service name associated with the missed workflow.
next_schedule
Indicates the next schedule of the missed workflow.
tstamp
Indicates the current time stamp.
workflow_name
Indicates the name of the missed workflow.
rs
Indicates the Repository Service name associated with the missed workflow.
workflow_id
Indicates the internal ID generated within PowerCenter for the missed workflow.
latest_schedule
Indicates the current schedule of the missed workflow.
folder
Indicates the folder name associated with the missed workflow.
domain
Indicates the domain name associated with the missed workflow.
The following table lists the properties for the pc_concurrent_workflows topic:
Property
Description
is_name
Indicates the Integration Service name associated with the concurrent workflow.
num_instances
Indicates the number of parallel instances of the concurrent workflow.
workflow_name
Indicates the name of the concurrent workflow.
rs
Indicates the Repository Service name associated with the concurrent workflow.
max_workflow_run_id
Indicates the maximum workflow run ID of the instance within the concurrent workflow.
workflow_id
Indicates the internal ID generated within PowerCenter for the concurrent workflow.
folder
Indicates the folder name associated with the concurrent workflow.
domain
Indicates the domain name associated with the concurrent workflow.
The following table lists the properties for the pc_ping topic:
Property
Description
faulterrorcode
Indicates the error code when you ping PowerCenter services.
faultstring
Indicates the error message when you ping PowerCenter services.
is_name
Indicates the name of the PowerCenter Integration Service.
ping_rs
Indicates the status message when you ping the PowerCenter Repository Service.
ping_is
Indicates the status message when you ping the PowerCenter Integration Service.
workflow_name
Indicates the name of the PowerCenter workflow.
tstamp
Indicates the current time stamp.
rs
Indicates the name of the PowerCenter Repository Service.
ping_domain
Indicates the status message when pinging Informatica domain.
folder
Indicates the folder name associated with the PowerCenter Repository Service.
domain
Indicates the name of the Informatica domain.
The following table lists the properties for the pc_runtime_session_stats topic:
Property
Description
workflow_run_error_msg
Indicates the error message of the PowerCenter workflow associated with the PowerCenter session.
is_name
Indicates the integration service name associated with the PowerCenter session.
session_source_success_rows
Indicates the number of rows extracted successfully from the source by the PowerCenter session.
session_transform_errors
Indicates the number of transformation errors within the PowerCenter session.
session_index
Indicates the internal chronological order of the session when extracted by the PowerCenter Web Service RunTime statistics source.
session_mapping
Indicates the mapping name associated with the PowerCenter session.
session_run_error_code
Indicates the error code of the PowerCenter session run.
session_first_error_code
Indicates the error code of the first error within the PowerCenter session run.
workflow_name
Indicates the workflow name associated with the PowerCenter session.
workflow_end_time
Indicates the workflow end time associated with the PowerCenter session.
workflow_run_type
Indicates the workflow run type associated with the PowerCenter session.
session_log_file
Indicates the absolute log file name of the PowerCenter session.
session_workflow
Indicates the workflow name associated to the PowerCenter session.
session_first_error_msg
Indicates the first error message of the PowerCenter session.
workflow_run_error_code
Indicates the error code of the error message of PowerCenter workflow associated with the PowerCenter session.
rs
Indicates the Repository Service name associated with the PowerCenter session.
session_target_success_rows
Indicates the number of rows loaded successfully to the target by the PowerCenter session.
folder
Indicates the folder name associated with the PowerCenter session.
session_run_error_msg
Indicates the error message of the PowerCenter session run.
server_startup_time
Indicates the start time of the PowerCenter Integration Service.
workflow_status
Indicates the status of the workflow associated with the PowerCenter session.
workflow_elapsed_secs
Indicates the total elapsed time, in seconds, of the workflow associated with the PowerCenter session.
session_target_failed_rows
Indicates the number of failed rows not loaded to the target by the PowerCenter session.
workflow_run_id
Indicates the workflow run ID of the workflow associated with the PowerCenter session.
session_source_failed_rows
Indicates the number of failed rows not extracted by the source of the PowerCenter session.
server_status
Indicates the status of the PowerCenter Integration Service.
server_current_time
Indicates the current time stamp of the PowerCenter Integration Service.
workflow_run_instance_name
Indicates the name of the instance of the workflow associated with the PowerCenter session.
workflow_start_time
Indicates the start time of the workflow associated with the PowerCenter session.
session_folder
Indicates the folder name associated with the PowerCenter session.
workflow_id
Indicates the internal ID generated for the workflow by PowerCenter, connected to the PowerCenter session.
session_status
Indicates the run status of the PowerCenter session.
message_subject
Indicates the message subject. In this case, it is - session.
workflow_log_file_path
Indicates the absolute log file name of the workflow associated with the PowerCenter session.
workflow_index
Indicates the internal chronological order of the workflow when extracted by the PowerCenter Web Service run-time statistics source.
domain
Indicates the name of the Informatica domain associated with the PowerCenter session.
session_num_targets
Indicates the number of targets in a PowerCenter session.
session_instance
Indicates the PowerCenter session instance name.
The following table lists the properties for the pc_runtime_stats topic:
Property
Description
is_name
Indicates the Integration Service name.
session_transform_errors
Indicates the number of transformation errors within the PowerCenter session.
target_last_error_targetmessage
Indicates the last error message encountered by the target within the PowerCenter session.
session_index
Indicates the internal chronological order of the session when extracted by the PowerCenter Web Service run-time statistics source.
session_mapping
Indicates the mapping name associated with the PowerCenter session.
workflow_end_time
Indicates the workflow end time associated with the PowerCenter session.
workflow_run_type
Indicates the workflow run type associated with the PowerCenter session.
target_type
Indicates the type of the target in the mapping associated with the PowerCenter session. For example, the target can be Relational or Flat File.
rs
Indicates the Repository Service name.
target_rejected_rows
Indicates the number of rejected rows at the target of the PowerCenter session.
session_target_success_rows
Indicates the number of rows loaded successfully to the target by the PowerCenter session.
folder
Indicates the folder name associated with the PowerCenter session.
session_run_error_msg
Indicates the error message of the PowerCenter session run.
session_workflow
Indicates the workflow name associated to the PowerCenter session.
target_last_error_code
Indicates the last error code in the target of the PowerCenter session.
workflow_status
Indicates the status of the workflow associated with the PowerCenter session.
workflow_elapsed_secs
Indicates the elapsed time, in seconds, of the completed PowerCenter workflow.
session_target_failed_rows
Indicates the number of failed rows not loaded to the target by the PowerCenter session.
num_workflows
Indicates the number of workflows running.
workflow_run_id
Indicates the workflow run ID of the workflow associated with the PowerCenter session.
target_end_time
Indicates the end time of the target execution in the PowerCenter session.
workflow_run_instance_name
Indicates the name of the instance of the workflow associated with the PowerCenter session.
workflow_index
Indicates the internal chronological order of the workflow when extracted by the PowerCenter Web Service run-time statistics source.
workflow_log_file_path
Indicates the absolute log file name of the workflow associated with the PowerCenter session.
session_instance
Indicates the PowerCenter session instance name.
workflow_run_error_msg
Indicates the error message of the PowerCenter workflow associated with the PowerCenter session.
session_source_success_rows
Indicates the number of rows extracted successfully from the source by the PowerCenter session.
session_first_error_code
Indicates the error code of the first error within the PowerCenter session run.
session_run_error_code
Indicates the error code of the PowerCenter session run.
workflow_name
Indicates the name of the PowerCenter workflow.
target_name
Indicates the name of the target in the PowerCenter session.
session_log_file
Indicates the absolute log file name of the PowerCenter session.
target_throughput
Indicates the throughput rows per second of the target in the PowerCenter session.
session_first_error_msg
Indicates the first error message of the PowerCenter session.
workflow_run_error_code
Indicates the error code of the error message of PowerCenter workflow associated with the PowerCenter session.
target_index
Indicates the internal chronological order of the target within the PowerCenter session when extracted by the PowerCenter Web Service RunTime statistics source.
server_startup_time
Indicates the start time of the PowerCenter Integration Service.
target_instance_name
Indicates the name of the target instance in the PowerCenter session.
target_affected_rows
Indicates the number of loaded rows successfully to the target of the PowerCenter session.
target_applied_rows
Indicates the number of rows pushed to the target of the PowerCenter session.
session_source_failed_rows
Indicates the number of failed rows not extracted by the source of the PowerCenter session.
server_status
Indicates the status of the PowerCenter Integration Service.
server_current_time
Indicates the current time of the PowerCenter Integration Service.
workflow_start_time
Indicates the start time of the workflow associated with the PowerCenter session.
session_folder
Indicates the folder name associated with the PowerCenter session.
target_start_time
Indicates the start time of the target execution in the PowerCenter session.
message_subject
Indicates the message subject. For example, the message subject can be server or session.
session_status
Indicates the run status of the PowerCenter session.
domain
Indicates the name of the Informatica domain.
session_num_targets
Indicates the number of targets in a PowerCenter session.
target_elapsed_secs
Indicates the elapsed time, in seconds, of the target within the PowerCenter session.
The following table lists the properties for the pc_runtime_workflow_stats topic:
Property
Description
workflow_run_error_msg
Indicates the error message of the PowerCenter workflow.
server_startup_time
Indicates the start time of the PowerCenter Integration Service.
is_name
Indicates the integration service name associated with the PowerCenter workflow.
workflow_name
Indicates the PowerCenter workflow name.
workflow_status
Indicates the status of the PowerCenter workflow.
workflow_elapsed_secs
Indicates the elapsed time, in seconds, of a completed PowerCenter session.
workflow_end_time
Indicates the end time of the PowerCenter workflow execution.
workflow_run_id
Indicates the internal run ID generated for the PowerCenter workflow.
workflow_run_type
Indicates the run type of the PowerCenter workflow.
server_status
Indicates the status of the PowerCenter Integration Service.
server_current_time
Indicates the current time of the PowerCenter Integration Service.
workflow_run_instance_name
Indicates the name of the instance of the PowerCenter workflow.
workflow_start_time
Indicates the start time of the PowerCenter workflow execution.
workflow_run_error_code
Indicates the error code of the error message of PowerCenter workflow.
rs
Indicates the Repository Service name associated with the PowerCenter workflow.
message_subject
Indicates the message subject. In this case, it is - workflow.
folder
Indicates the folder name associated with the PowerCenter workflow.
workflow_log_file_path
Indicates the absolute log file name of the PowerCenter workflow.
workflow_index
Indicates the internal chronological order of the workflow when extracted by the PowerCenter Web Service RunTime statistics source.
domain
Indicates the name of the Informatica domain associated with the PowerCenter workflow.
The following table lists the properties for the pc_scheduled_workflows topic:
Property
Description
seconds_delayed
Indicates the delayed time unit in seconds of the scheduled PowerCenter workflow.
is_name
Indicates the integration service name associated with the scheduled PowerCenter workflow.
wflow_latest_schedule
Indicates the current schedule of the scheduled PowerCenter workflow.
workflow_name
Indicates the name of the scheduled PowerCenter workflow.
tstamp
Indicates the current time stamp.
rs
Indicates the Repository Service name associated with the scheduled PowerCenter workflow.
workflow_id
Indicates the internal ID generated within PowerCenter for the scheduled workflow.
latest_schedule
Indicates the current schedule of the scheduled PowerCenter workflow.
folder
Indicates the folder name associated with the scheduled PowerCenter workflow.
is_id
Indicates the internal ID generated within PowerCenter for the Integration Service.
domain
Indicates the name of the Informatica domain associated with the scheduled PowerCenter workflow.
wflow_next_schedule
Indicates the next schedule of the scheduled PowerCenter workflow.
The following table lists the properties for the pc_runtime_target_stats topic:
Property
Description
workflow_run_error_msg
Indicates the error message of the PowerCenter workflow associated with the PowerCenter session.
is_name
Indicates the Integration Service name associated with the PowerCenter session.
session_source_success_rows
Indicates the number of rows extracted successfully from the source by the PowerCenter session.
session_transform_errors
Indicates the number of transformation errors within the PowerCenter session.
target_last_error_targetmessage
Indicates the last error message encountered by the target within the PowerCenter session.
session_index
Indicates the internal chronological order of the session when extracted by the PowerCenter Web Service RunTime statistics source.
session_mapping
Indicates the mapping name associated with the PowerCenter session.
session_run_error_code
Indicates the error code of the PowerCenter session run.
session_first_error_code
Indicates the error code of the first error within the PowerCenter session run.
workflow_name
Indicates the name of the PowerCenter workflow associated with the PowerCenter session.
target_name
Indicates the name of the target in the PowerCenter session.
workflow_end_time
Indicates the workflow end time associated with the PowerCenter session.
workflow_run_type
Indicates the workflow run type associated with the PowerCenter session.
target_type
Indicates the type of the target in the mapping associated with the PowerCenter session. For example, the target type can be Relational or Flat File.
target_throughput
Indicates the throughput rows per second of the target in the PowerCenter session.
session_log_file
Indicates the absolute log file name of the PowerCenter session.
session_first_error_msg
Indicates the first error message of the PowerCenter session.
workflow_run_error_code
Indicates the error code of the error message of PowerCenter workflow associated with the PowerCenter session.
rs
Indicates the Repository Service name associated with the PowerCenter session.
target_rejected_rows
Indicates the number of rejected rows at the target of the PowerCenter session.
session_target_success_rows
Indicates the number of rows loaded successfully to the target by the PowerCenter session.
folder
Indicates the folder name associated with the PowerCenter session.
target_index
Indicates the internal chronological order of the target within the PowerCenter session when extracted by the PowerCenter Web Service RunTime statistics source.
session_run_error_msg
Indicates the error message of the PowerCenter session run.
server_startup_time
Indicates the start time of the PowerCenter Integration Service associated with the PowerCenter session.
target_instance_name
Indicates the name of the target instance in the PowerCenter session.
target_last_error_code
Indicates the last error code in the target of the PowerCenter session.
workflow_status
Indicates the status of the workflow associated with the PowerCenter session.
workflow_elapsed_secs
Indicates the elapsed time, in seconds, of the completed PowerCenter workflow associated with the PowerCenter session.
session_target_failed_rows
Indicates the number of failed rows not loaded to the target by the PowerCenter session.
target_affected_rows
Indicates the number of rows loaded successfully to the target of the PowerCenter session.
target_applied_rows
Indicates the number of rows pushed to the target of the PowerCenter session.
workflow_run_id
Indicates the workflow run ID of the workflow associated with the PowerCenter session.
session_source_failed_rows
Indicates the number of failed rows not extracted by the source of the PowerCenter session.
server_status
Indicates the status of the PowerCenter Integration Service associated with the PowerCenter session.
target_end_time
Indicates the end time of the target execution in the PowerCenter session.
server_current_time
Indicates the current time stamp of the PowerCenter Integration Service associated with the PowerCenter session.
workflow_run_instance_name
Indicates the run instance name of the PowerCenter workflow associated with the PowerCenter session.
workflow_start_time
Indicates the start time of the workflow associated with the PowerCenter session.
target_start_time
Indicates the start time of the target execution in the PowerCenter session.
session_status
Indicates the run status of the PowerCenter session.
message_subject
Indicates the message subject. In this case, it is - target.
workflow_log_file_path
Indicates the absolute log file name of the workflow associated with the PowerCenter session.
workflow_index
Indicates the internal chronological order of the workflow when extracted by the PowerCenter Web Service RunTime statistics source.
domain
Indicates the domain name associated with the completed PowerCenter session.
session_num_targets
Indicates the number of targets in a PowerCenter session.
session_instance
Indicates the PowerCenter session instance name.
target_elapsed_secs
Indicates the elapsed time, in seconds, of the target within the PowerCenter session.
The following table lists the properties for the pc_running_workflows topic:
Property
Description
workflow_run_error_msg
Indicates the error message of the running PowerCenter workflow.
is_name
Indicates the Integration Service name associated with the running PowerCenter workflow.
curr_tstamp
Indicates the snapshot time when the information about running workflows were extracted.
workflow_name
Indicates the name of the running PowerCenter workflow.
workflow_elapsed_secs
Indicates the elapsed time, in seconds, of the running PowerCenter workflow.
workflow_run_id
Indicates the internal ID generated for every run of the PowerCenter workflow.
server_current_time
Indicates the current time of the PowerCenter Integration Service.
workflow_start_time
Indicates the start time of the running PowerCenter workflow.
workflow_run_error_code
Indicates the error code of the error message in the running PowerCenter workflow.
rs
Indicates the Repository Service name associated with the running PowerCenter workflow.
workflow_id
Indicates the internal ID generated for the PowerCenter workflow.
folder
Indicates the folder name associated with the running PowerCenter workflow.
domain
Indicates the domain name associated with the running PowerCenter workflow.
workflow_log_file_path
Indicates the absolute log file name of the running PowerCenter workflow.
The following table lists the properties for the pc_completed_workflows topic:
Property
Description
workflow_run_status
Indicates the status of the completed PowerCenter workflow run.
is_name
Indicates the Integration Service name associated with the completed PowerCenter workflow.
curr_tstamp
Indicates the snapshot time when the information about completed workflows was extracted.
workflow_run_status_code
Indicates the status code of the completed PowerCenter workflow run.
tstamp
Indicates the snapshot time when the information about completed workflows were extracted.
workflow_name
Indicates the name of the completed PowerCenter workflow.
workflow_elapsed_secs
Indicates the elapsed time, in seconds, of a completed PowerCenter workflow.
workflow_end_time
Indicates the end time of the completed PowerCenter workflow.
workflow_run_id
Indicates the internal ID generated for every run of the PowerCenter workflow.
workflow_start_time
Indicates the start time of the completed PowerCenter workflow.
rs
Indicates the Repository Service name associated with the completed PowerCenter workflow.
workflow_id
Indicates the internal ID generated for the PowerCenter workflow.
folder
Indicates the folder name associated with the completed PowerCenter workflow.
is_id
Indicates the internal ID generated within PowerCenter for the Integration Service associated with the completed PowerCenter workflow.
domain
Indicates the domain name associated with the completed PowerCenter workflow.
The following table lists the properties for the pc_failed_workflows topic:
Property
Description
workflow_run_status
Indicates the status of the PowerCenter workflow run.
is_name
Indicates the Integration Service name associated with the failed PowerCenter workflow.
curr_tstamp
Indicates the snapshot time when the information about failed workflows were extracted.
workflow_run_status_code
Indicates the status code of the PowerCenter workflow run.
tstamp
Indicates the snapshot time when the information about failed workflows were extracted.
workflow_name
Indicates the name of the failed PowerCenter workflow.
workflow_elapsed_secs
Indicates the elapsed time in seconds of the failed PowerCenter workflow.
workflow_end_time
Indicates the end time of the failed PowerCenter workflow.
workflow_run_id
Indicates the internal ID generated for every run of the PowerCenter workflow.
workflow_start_time
Indicates the start time of the failed PowerCenter workflow.
rs
Indicates the Repository Service name associated with the failed PowerCenter workflow.
workflow_id
Indicates the internal ID generated for the PowerCenter workflow.
folder
Indicates the folder name associated with the failed PowerCenter workflow.
is_id
Indicates the internal ID generated within PowerCenter for the Integration Service associated with the failed PowerCenter workflow.
domain
Indicates the domain name associated with the failed PowerCenter workflow.
The following table lists the properties for the pc_running_sessions topic:
Property
Description
session_run_error_msg
Indicates the error message of the PowerCenter session run.
is_name
Indicates the Integration Service name associated with the running PowerCenter session.
curr_tstamp
Indicates the snapshot time when the information about running sessions were extracted.
session_elapsed_secs
Indicates the elapsed time, in seconds, of the running PowerCenter session.
session_run_error_code
Indicates the error code of the PowerCenter session running.
workflow_name
Indicates the name of the PowerCenter workflow associated with the running PowerCenter session.
session_id
Indicates the internal ID generated for the running PowerCenter session.
workflow_run_id
Indicates the internal ID generated for every run of the PowerCenter workflow associated with the running PowerCenter session.
server_current_time
Indicates the current time of the PowerCenter Integration Service associated with the running PowerCenter session.
session_start_time
Indicates the start time of the running PowerCenter session.
rs
Indicates the Repository Service name associated with the running PowerCenter session.
workflow_id
Indicates the internal ID generated for the PowerCenter workflow associated with the running PowerCenter session.
folder
Indicates the folder name associated with the running PowerCenter session.
domain
Indicates the domain name associated with the running PowerCenter session.
session_instance_id
Indicates the internal ID of the running PowerCenter session instance.
session_instance
Indicates the running PowerCenter session instance name.
The following table lists the properties for the node_process_property topic:
Property
Description
is_name
Indicates the Integration Service name associated with the PowerCenter node.
time_elapsed
Indicates the total process elapsed time running on the PowerCenter node.
p_memory
Indicates the total memory of the process running on the PowerCenter node.
process_name
Indicates the name of the process running on the PowerCenter node.
node_name
Indicates the name of the PowerCenter node.
tstamp
Indicates the time stamp during when the statistics was collected.
pid
Indicates the process ID of the process running on the PowerCenter node.
domain
Indicates the domain name associated with the PowerCenter node.
host_name
Indicates the host name on which the PowerCenter node is installed.
p_cpu
Indicates the total CPU of the process running on the PowerCenter node.
The following table lists the properties for the node_database_property topic:
Property
Description
perc_tablespace_usage
Indicates the total percentage of tablespace used in the database.
ping_database
Indicates the status of the database whether it is alive.
tablespace_name
Indicates the tablespace name present in the database.
tstamp
Indicates the time stamp during when the statistics were collected.
rs
Indicates the Repository Service name associated with the PowerCenter node.
total_space_in_tablespace_in_kb
Indicates the total size of tablespace in kilobytes available in the database.
connectionstring
Indicates the connection string to the database.
domain
Indicates the domain name associated with the PowerCenter node.
The following table lists the properties for the node_system_property topic:
Property
Description
is_name
Indicates the Integration Service name associated with the PowerCenter node.
system_no_proc
Indicates the number of processes running on the PowerCenter node.
system_cpu
Indicates the total system CPU of the PowerCenter node.
tstamp
Indicates the time stamp during when the statistics were collected.
domain
Indicates the domain name associated with the PowerCenter node.
host_name
Indicates the host name on which the PowerCenter node is installed.
system_memory
Indicates the total system memory of the PowerCenter node.
The following table lists the properties for the node_filefolder_property topic:
Property
Description
size_percent
Indicates the file or folder size in percentage.
size_kb
Indicates the file or folder size in kilobytes.
is_folder
Indicates whether the entity is a file or a folder.
no_files
Indicates the number of files contained in a folder.
tstamp
Indicates the time stamp during when the statistics was collected.
if_exists
Indicates whether the file or folder exists.
is_empty
Indicates whether the file or folder is empty.
host_name
Indicates the host name on which the file or folder is located.
path
Indicates the location of file or folder.
The following table lists the properties for the node_agent_lifecycle_monitor topic:
Property
Description
repo_tstamp
Indicates the internal repository time stamp updated by the node agent.
current_upd_tstamp
Indicates the internal current time stamp updated by the node agent.
domain
Indicates the domain name associated to the PowerCenter node where the node agent is installed.
host_name
Indicates the host name where the node agent is installed.
The following table lists the properties for the node_process_lifecycle_monitor topic:
Property
Description
p_args
Indicates the process arguments of the monitored process.
process_name
Indicated the name of the process monitored.
tstamp
Indicates the time stamp when the statistics was collected.
pid
Indicates the process ID of the process monitored.
p_endtime
Indicated the end time of the process monitored.
p_starttime
Indicated the start time of the process monitored.
domain
Indicates the domain name associated to the PowerCenter node where the node agent is installed.
host_name
Indicates the host name where the node agent is installed.

0 COMMENTS

We’d like to hear from you!