Changing the Cache Database Server Thread Count

You can change the cache database (CDB) server thread count as required. The procedure for this varies depending on the type of environment the CDB server is deployed to.

Sybase has identified two scenarios: one for clustered environments and one for single node installations.
Note: You can set these values for monitoring and cluster databases as well.
Parent topic: Tuning Replication
Parent topic: Data Tier Administration Overview
Related reference
Update Properties (updateprops.bat) Utility

When data-tier in a cluster environment

  1. Stop all runtime nodes in the cluster.
  2. On the data-tier node, remove the service by running:
    <UnwiredPlatform_InstallDir>\Servers\UnwiredServer\binXX\install-sup-sqlanyXX.bat remove
  3. To change the thread count, edit the <UnwiredPlatform_InstallDir>\Servers\UnwiredServer\binXX\install-sup-sqlanyXX.bat to modify the CDB_THREADCOUNT property.
    Choose an appropriate server threadcount according to your cluster performance requirements.
    For example, this command sets the server thread count to 200:

    set CDB_THREADCOUNT=200

  4. Recreate the service again with the correct thread count by running:
    <UnwiredPlatform_InstallDir>\Servers\UnwiredServer\binXX\install-sup-sqlanyXX.bat install [auto|manual] cdb_servername cdb_serverhost cdb_serverport cdb_password cldb_serverhost cldb_serverport cldb_password monitordb_serverhost monitordb_serverport monitordb_password domainlogdb_password [shared_data_path service_username service_password]
  5. Restart all runtime nodes in the cluster.

When data-tier is in a personal or evaluation install

  1. On the Unwired server node with data-tier installed, update properties by running:
    <UnwiredPlatform_InstallDir>\Servers\UnwiredServer\bin\updateProps.bat -nv "cdb.threadcount=200"

    Choose an appropriate server threadcount according to your cluster performance requirements.

  2. Stop Unwired Server services.
  3. Start Unwired Server services.