PowerCenter Repository Maintenance

PowerCenter Repository Maintenance

Overview

Overview

The PowerCenter repository can grow to a size that may start slowing the performance of the repository and make it increasingly difficult for the administrator to make backups.
The PowerCenter administrator must perform the following maintenance activities on the repository to maintain the size of the database for optimal performance:
  • Regularly back up the repository
  • Delete old versions or purged objects, folders, and logs from the repository
  • Perform repository tuning activities
The administrator can use the Repository Manager client tool, the Informatica Administrator, and the pmrep and infacmd command line programs to administer the repository.