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:
In the Repository Manager, select the workflow in the Navigator window or in the Main window.
Choose
Edit
Truncate Log
.
The
Truncate Workflow Log
dialog box appears.
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.
If you want to delete all entries older than a certain date, enter the date and time.
Click
OK
.
The PowerCenter Repository Service deletes the workflow and session log entries from the repository.