Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

Truncating Workflow and Session Logs

Truncating Workflow and Session Logs

When you configure a session or workflow to archive session logs or workflow logs, the PowerCenter Integration Service saves those logs in local directories. The repository also creates an entry each time that a workflow or a session runs. If you move or delete a session log or workflow log from the workflow log directory or session log directory, you can remove the entries from the repository.
Use the Repository Manager or the
pmrep TruncateLog
command to truncate the workflow logs for workflows that have completed.
You can truncate all logs for a workflow, or logs that were created before a specified date. You cannot truncate a workflow log for a workflow that is still running. The PowerCenter Repository Service truncates the workflow log list and the session log list at the same time.
When the PowerCenter Repository Service truncates logs for sessions and workflows, it also deletes the following run-time information for the sessions and workflows:
  • Workflow details
  • Session statistics
  • Task details
  • Source and target statistics
  • Partition details
  • Performance details
When you truncate logs from a Microsoft SQL Server repository, verify that no workflow is running. If you truncate logs when a workflow is running, the workflow fails.
To truncate workflow and session logs:
  1. In the Repository Manager, select the workflow in the Navigator window or in the Main window.
  2. Choose
    Edit
    Truncate Log
    .
    The
    Truncate Workflow Log
    dialog box appears.
  3. Choose to delete all workflow and session log entries, or to delete all workflow and session log entries with an end time before a particular date.
  4. If you want to delete all entries older than a certain date, enter the date and time.
  5. Click
    OK
    .
    The PowerCenter Repository Service deletes the workflow and session log entries from the repository.

0 COMMENTS

We’d like to hear from you!