Resilience is the ability of PowerCenter service clients to tolerate temporary network failures until the timeout period expires or you resolve the system failure. Clients that are resilient to a temporary failure can maintain connection to a service for the duration of the timeout.
There are two variables associated with resilience:
In general, it is advisable to keep all limits at the same level, to keep the interdependency even.
Reference: “Chapter 6: Managing High Availability” in Administrator Guide
Repository Service: Properties: Database properties: Optimize Database Schema: No. Enables optimization of repository database schema when you create repository contents or back up and restore an IBM DB2 or Microsoft SQL Server repository. When you enable this option, the Repository Service creates repository tables using Varchar(2000) columns instead of CLOB columns wherever possible. Using Varchar columns improves repository performance because it reduces disk input and output and because the database buffer cache can cache Varchar columns.
To use this option, the repository database must meet the following page size requirements:
What can we do to improve this information (2000 or fewer characters)