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.

Prérequis

There are no prerequisites for this task.

Contexte et remarques

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.

Résultat

The database server property value is returned.

Exemple

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