Sybase Adaptive Server Anywhere - Page 986

System and catalog stored procedures
968
Returns the database ID number and the Number, PropNum, PropName,
PropDescription, and Value, for each available database property.
sa_eng_properties system procedure
Reports database server property information
sa_eng_properties
None.
None
"Server-level properties" on page 1095
Returns the PropNum, PropName, PropDescription, and Value for each
available server property.
$ For a listing of available engine properties, see "System functions" on
page 310.
♦ The following statement returns a set of available server properties
call sa_eng_properties()
PropNum PropName ...
1 IdleWrite ...
2 IdleChkPt ...
... ... ...
sa_flush_cache system procedure
Empties all pages in the database server cache.
sa_flush_cache ( )
DBA authority required.
None
Database administrators can use this procedure to empty the contents of the
database server cache. This is of use in performance measurement to ensure
repeatable results.
Description
Function
Syntax
Permissions
Side effects
See also
Description
Example
Function
Syntax
Permissions
Side effects
Description