You can change the cache database (CDB) server maximum pool (and other configuration values) through Sybase Control Center.
In a cluster environment, the CDB pools size can propagate to secondary notes.
- In the left navigation pane, expand the Domains folder, and select the domain for which you want to modify the connection.
- Select Connections.
- In the right administration pane:
- To edit the properties of a connection pool, click the Connections tab.
- To edit the properties of a connection pool template, click the Templates tab.
- Select a connection pool or template from the list.
- Select JDBC as the Connection pool type, and click Properties.
- Change the Max Pool Size value (and any other values you choose). The default value is 150, and 0 indicates no limit. Th Max Pool Size value should not be a negative value.
See Creating Connections and Connection Templates in Sybase Control Center online help, and JDBC Properties.
- Click Save to save the changes.