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 instances of
SAP Mobile Server,
as well as all database services.
For a list of database services, search for SAP Mobile Platform Windows Services in System Administration.
- If you are
thread
count and user startup options in a cluster deployment, then for
each database that requires a startup option change, open the corresponding
initialization file. These files are installed to SMP_HOME\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
the
startup options in the .ini
files, for example:
-gn <threadcount> -c <cachesize>
- Ensure
all
the
database
services
are
restarted.
- Restart all SAP Mobile Servers.