Sybase Adaptive Server Anywhere - Page 1109

Appendix A Database Performance and Connection Properties
1091
call sa_conn_properties
A separate row is displayed for each connection.
Property Description
Allow_nulls_by_default
"ALLOW_NULLS_BY_DEFAULT option" on
page 169
Ansi_blanks
"ANSI_BLANKS option" on page 169
Ansi_close_cursors_on_ro
llback
"ANSI_CLOSE_CURSORS_ON_ROLLBACK
option" on page 170
Ansi_Integer_Overflow
"ANSI_INTEGER_OVERFLOW option" on
page 170
Ansi_permissions
"ANSI_PERMISSIONS option" on page 170
Ansinull
"ANSINULL option" on page 172
AppInfo
"AppInfo connection parameter" on page 48
Automatic_timestamp
"AUTOMATIC_TIMESTAMP option" on
page 173
Background_priority
"BACKGROUND_PRIORITY option" on
page 174
BlockedOn
If the current connection is not blocked this is zero.
If it is blocked, the connection number on which
the connection is blocked due to a locking conflict.
Blocking
"BLOCKING option" on page 175
CacheHits
The number of successful reads of the cache
CacheRead
The number of database pages that have been
looked up in the cache.
CacheReadIndInt
The number of index internal-node pages that have
been read from the cache.
CacheReadIndLeaf
The number of index leaf pages that have been read
from the cache.
CacheReadTable
The number of table pages that have been read
from the cache.
Chained
"CHAINED option" on page 175
Checkpoint_time
"CHECKPOINT_TIME option" on page 177
CIS_option
Reserved
Cis_rowset_size
Reserved
ClientLibrary
Either CmdSeq for ODBC and Embedded SQL
connections, or TDS for JDBC and Open Client
connections.
Descriptions