Change the database server startup options to control the performance of a SQLAnywhere database server.
Depending on the type of installation you have performed, the servers you can change startup options for varies:
- In single node deployment, a single database server named CacheDB supports all installed databases.
- In a cluster deployment, two servers are used: the monitor and domain log databases use a server called LogDataDB, the default database used for the cache data uses the CacheDB server, and the cluster database uses the ClusterDB server.
- Stop all instances of Unwired Server, as well as all database services.
For a list of database services, search for Unwired Platform Windows Services in System Administration.
- If you are updating ports in a cluster deployment, then for each database that requires a port change, open the corresponding initialization file. These files are installed to <UnwiredPlatform_InstallDir>\Servers\SQLAnywhere12\binxx:
- For the cache database, open cdboptions.ini.
- For the cluster database, open cldboptions.ini.
- For the log database, open monitoroptions.ini.
- Modify one of these properties: *.threadcount or *.useroptions in the .ini files, for example:
- For all deployments, run the update properties utility to propagate changes to all runtime servers:
updateProps.bat -u user -p pwd -d dsn -nv "property1=newvalue#property2=newvalue
- Restart all database services, then all Unwired Servers.