sa_eng_properties system procedure

sa_eng_properties( )

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.

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.

None

The following statement returns a set of available server properties

CALL sa_eng_properties( );

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

sa_eng_properties system procedure

Syntax

Result set

Remarks

Permissions

Side effects

See also

Example