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.

Privileges

None

Side effects

None

Example

The following statement returns a set of available server properties

CALL sa_eng_properties( );

PropNum	PropName	...
1	IdleWrite	...
2	IdleChkPt	...
...	...	...