Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » SQL Anywhere database server executable (dbsrv17, dbeng17) » Database server startup options

-phs database server option

Sets the maximum amount of memory to use for tracking property history, in allotted time or bytes.

dbsrv17 -phs { [HH:]MM:SS | size [ K | M ] | max | default }


Applies to

All operating systems.


The -phs database server option specifies the maximum size allowed for tracking property history. The size is measured in allotted time per property or bytes of memory. The size parameter also increases the initial cache size of the database server to avoid having to grow the cache during start up. This increase in initial cache size prevents long start up times. If this option is not set, then the database server uses the default setting of the PropertyHistorySize database server option.

If you specify a value for the -phs database server option, but the -phl database server option is set to OFF, then no property history is collected. If you set the -phs database database server property to 0 or to a time-based value, then no space is allocated for property history tracking.

Specifying "max" sets the maximum size for tracking property history to 2% of the cache, or 256 MB, whichever is smaller.

Specifying "default" sets the size for tracking property history to either 10 minutes or to a maximum of 2% of the cache.


If the specified size does not allow the database server to store the minimum amount of data for each tracked database server property (1024 bytes, or approximately 30 seconds), then an error is returned.