Sybase Adaptive Server Anywhere - Page 1113

Appendix A Database Performance and Connection Properties
1095
Property Description
Scale
"SCALE option" on page 210
SQL_flagger_error_level
"SQL_FLAGGER_ERROR_LEVEL option" on
page 210
SQL_flagger_warning_lev
el
"SQL_FLAGGER_WARNING_LEVEL option"
on page 211
String_rtruncation
"STRING_TRUNCATION option" on page 212
TaskSwitch
The number of times the current server thread has
been changed.
Thread_count
"THREAD_COUNT option" on page 212
Time_format
"TIME_FORMAT option" on page 213
Timestamp_format
"TIMESTAMP_FORMAT option" on page 213
Truncate_Timestamp_Val
ues
"TRUNCATE_TIMESTAMP_VALUES option"
on page 215
Truncate_with_autocomm
it
"TRUNCATE_WITH_AUTO_COMMIT option"
on page 215
Tsql_hex_constant
"TSQL_HEX_CONSTANT option" on page 216
Tsql_variables
"TSQL_VARIABLES option" on page 216
UncommitOp
The number of uncommitted operations
Userid
The user ID for the connection.
Wait_for_commit
"WAIT_FOR_COMMIT option" on page 217
Server-level properties
The following table lists properties that apply across the server as a whole.
v To retrieve the value of a server property:
♦ Use the property system function: For example: the following statement
returns the number of cache pages being used to hold the main heap:
select property ( ’MainHeapPages’)
v To retrieve the values of all server properties:
♦ Use the sa_eng_properties system procedure:
call sa_eng_properties
Examples