Accessing database server property values

Use the PROPERTY system function to retrieve the value for an individual property and use the sa_eng_properties system procedure to retrieve the values of all database server properties.

Prerequisites

There are no prerequisites for this task.

Context and remarks

Property names are case insensitive. Database server properties apply across the database server as a whole.

Task

Use one of the following methods to access database server property values:

Option	Action
Retrieve the value of a database server property	Use the PROPERTY system function.
Retrieve the values of all database server properties	Use the sa_eng_properties system procedure.

Results

The database server property value is returned.

Example

The following statement returns the number of cache pages used for global server data structures:

SELECT PROPERTY ( 'MainHeapPages' );

Use the sa_eng_properties system procedure to retrieve the values of all database server properties:

CALL sa_eng_properties;

Accessing database server property values

Task

See also