Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data
  26. POWERCENTERHELP

Advanced Workflow Guide

Advanced Workflow Guide

PMERR_SESS

PMERR_SESS

When you choose relational database error logging, the Integration Service inserts entries into the PMERR_SESS table. This table stores metadata about the session where an error occurred.
The following table describes the structure of the PMERR_SESS table:
Column Name
Datatype
Description
REPOSITORY_GID
Varchar
Unique identifier for the repository.
WORKFLOW_RUN_ID
Integer
Unique identifier for the workflow.
WORKLET_RUN_ID
Integer
Unique identifier for the worklet. If a session is not part of a worklet, this value is “0”.
SESS_INST_ID
Integer
Unique identifier for the session.
SESS_START_TIME
Date/Time
Timestamp of the Integration Service when a session starts.
SESS_START_UTC_TIME
Integer
Coordinated Universal Time, called Greenwich Mean Time, of when the session starts.
REPOSITORY_NAME
Varchar
Repository name where sessions are stored.
FOLDER_NAME
Varchar
Specifies the folder where the mapping and session are located.
WORKFLOW_NAME
Varchar
Specifies the workflow that runs the session being logged.
TASK_INST_PATH
Varchar
Fully qualified session name that can span multiple rows. The Integration Service creates a new line for the session name. The Integration Service also creates a new line for each worklet in the qualified session name. For example, you have a session named WL1.WL2.S1. Each component of the name appears on a new line:
WL1
WL2
S1
The Integration Service writes the line number in the LINE_NO column.
MAPPING_NAME
Varchar
Specifies the mapping that the session uses.
LINE_NO
Integer
Specifies the line number for each row error entry in TASK_INST_PATH that spans multiple rows.
Use the column names in bold to join tables.


Updated July 04, 2018