PowerCenter Repository Maintenance

PowerCenter Repository Maintenance

Abstract

Abstract

The PowerCenter repository grows over time as you run new jobs on the development and production environments. The PowerCenter administrator must perform certain maintenance tasks on the database that hosts the repository to maintain the size of the database for optimal performance. This article provides information for the PowerCenter administrator about the activities like truncating the workflow and session log files and purging unnecessary versions from the repository to optimize the size of repository and increase its performance.


Updated July 06, 2021