Chapter 14. Performance tuning on distributed environments 499
You can set the cache size from the administrative console using these steps:
1. In the console navigation tree, select Resources JDBC Provider.
2. Select the appropriate scope (cell, node or server), depending on your configuration.
3. Open the JDBC provider configuration by clicking the name of the provider.
4. Under Additional Properties, select the Data Sources entry.
5. Open the data source configuration by clicking the data source name.
6. Select WebSphere Application Server data source properties.
7. Use the Statement cache size field to configure the total cache size.
8. Save the configuration, and restart the affected application servers for the change to take
effect.
14.2.3 ...