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 of the server properties, see the section “Database properties” in the chapter “Database Performance and Connection Properties” in the Adaptive Server Anywhere Database Administration Guide.

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

1. Use the sa_eng_properties system procedure.

call sa_eng_properties