Changing the Cache Database Server Pool Size

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.

  1. In the left navigation pane, expand the Domains folder, and select the domain for which you want to modify the connection.
  2. Select Connections.
  3. 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.
  4. Select a connection pool or template from the list.
  5. Select JDBC as the Connection pool type, and click Properties.
  6. 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.

  7. Click Save to save the changes.
Related reference
JDBC Properties