sa_eng_properties system procedure

Reports database server property information.

Syntax
sa_eng_properties( )
Result set
Column name Data type Description
PropNum INTEGER The database server property number.
PropName VARCHAR(255) The database server property name.
PropDescription VARCHAR(255) The database server property description.
Value LONG VARCHAR The database server property value.
Remarks

Returns the PropNum, PropName, PropDescription, and Value for each available server property. Values are returned for all database server properties and statistics related to database servers. For a list of available database server properties, see System functions.

Permissions

None

Side effects

None

See also
Example

The following statement returns a set of available server properties

CALL sa_eng_properties( );
PropNum PropName ...
1 IdleWrite ...
2 IdleChkPt ...
... ... ...