sa_eng_properties system procedure

Reports database server property information.

sa_eng_properties

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Returns the PropNum, PropName, PropDescription, and Value for each available server property.

For a listing of available database server properties, see “System functions” in SQL Anywhere Server – SQL Reference. See also “Server-level properties” in SQL Anywhere Server – Database Administration.

The following statement returns a set of available server properties:

call sa_eng_properties()

The following statement returns a set of available server properties:

sa_eng_properties

0,'ActiveReq','Active requests','1'
1,'AvailIO','Number of available I/O control blocks','255'
2,'BytesReceived','Bytes received by server','85898'
3,'BytesReceivedUncomp','Bytes received after decompression','85898'
4,'BytesSent','Bytes sent to client','145053'
5,'BytesSentUncomp','Bytes sent before compression','145053'
6,'CacheAllocated','Cache pages that have been allocated for server data structures','546'
7,'CacheFile','Cache pages used to hold data from database files','600'
8,'CacheFileDirty','Cache pages that are dirty (needing a write)','2'
9,'CacheFree','Number of cache pages not being used','270'
13,'CachePanics','Number of times the cache manager has failed to find a page to allocate','0'
14,'CachePinned','Pinned cache pages','591'
15,'CacheRead','Cache reads','456801'
16,'CacheReplacements','Cache replacements','0'
17,'CacheScavengeVisited','Number of pages visited while scavenging for a page to allocate','1416'
18,'CacheScavenges','Number of times the cache manager has scavenged for a page to allocate','1416'
21,'CarverHeapPages','Cache pages used for carvers','0'
39,'ClientStmtCacheHits','Number of prepares not required because of the client statement cache','23'
40,'ClientStmtCacheMisses','Number of prepares in the client statement cache which were prepared again','3'
44,'CurrentCacheSize','Current cache size in kilobytes','49152'
51,'DiskRead','Disk reads','938'
54,'DiskReadHintScatterLimit','Imposed limit on the size (in bytes) of a scatter read hint','0'
55,'DiskRetryRead','Disk read retries','0'