Change the database server startup options
(thread counts and user
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
Unwired
Servers.
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
startup
option 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:
- Ensure the cluster database is restarted.
- 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
Unwired Servers.