English
  • PowerCenter 10.2 HotFix 2
  • All Products

Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Workflow Basics Guide

Workflow Basics Guide

Back Next

Session Logs

Session Logs

Session logs contain information about the tasks that the Integration Service performs during a session, plus load summary and transformation statistics. By default, the Integration Service creates one session log for each session it runs. If a workflow contains multiple sessions, the Integration Service creates a separate session log for each session in the workflow. When you run a session on a grid, the Integration Service creates one session log for each DTM process.
In general, a session log contains the following information:
  • Allocation of heap memory
  • Execution of pre-session commands
  • Creation of SQL commands for reader and writer threads
  • Start and end times for target loading
  • Errors encountered during the session and general information
  • Execution of post-session commands
  • Load summary of reader, writer, and DTM statistics
  • Integration Service version and build number