Properties available for the server

Server properties apply across the server as a whole. This section describes how to retrieve the value of a specific server property or the values of all server properties. For descriptions of all server properties, see "Database server properties" in SQL Anywhere Server – Database Administration.

Examples

StepsRetrieving the value of a server property

  1. Use the property system function. The following statement returns the number of cache pages being used to hold the main heap:

select property ( 'MainHeapPages') from iq_dummy

StepsRetrieving the values of all server properties

  1. Use the sa_eng_properties system procedure:

call sa_eng_properties