ASA Database Administration Guide
Database Performance and Connection Properties
Database properties
The following table lists properties that apply across the server as a whole.
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' )
To retrieve the values of all server properties
Use the sa_eng_properties system procedure:
call sa_eng_properties
Property | Description |
---|---|
ActiveReq | The number of server threads that are currently handling a request. |
AvailIIO | Reserved |
BuildChange | Reserved |
BuildClient | Reserved |
BuildReproducible | Reserved |
BytesReceived | The number of bytes received during client/server communications. |
BytesReceivedUncomp | The number of bytes that would have been received during client/server communications if compression was disabled. (This value is the same as the value for BytesReceived if compression is disabled.) |
BytesSent | The number of bytes sent during client/server communications. |
BytesSentUncomp | The number of bytes that would have been sent during client/server communications if compression was disabled. (This value is the same as the value for BytesSent if compression is disabled.) |
C2 |
Returns YES if the -sc option was used when the server was started. Otherwise, returns NO.
For more information, see -sc server option. |
CacheHitsEng | The number of database page lookups. |
CacheReplacements | The number of pages in the cache that have been replaced. |
CharSet | The character set in use by the database server. |
CommandLine | The command line that was used to start the server. |
CompactPlatformVer | A condensed version of the PlatformVer property. |
CompanyName | The name of the company owning this software. |
ConnsDisabled |
Returns ON or OFF, to indicate the current setting of the server option to disable new connections.
For information, see sa_server_option system procedure. |
CurrentCacheSize | The current cache size, in kilobytes. |
DefaultCollation | The collation that would be used for new databases, if none is explicitly specified. |
FreeBuffers | The number of available network buffers. |
IdleTimeout |
The default idle timeout.
For more information, see -ti server option. |
IsIQ | Returns YES if the server is an IQ server, and NO otherwise. |
IsJavaAvailable | Returns YES if the JavaVM is installed, and NO if the JavaVM is not installed. This property only indicates if the Java VM is available, not whether it is currently being used. |
IsNetworkServer | Returns YES if connected to a network database server, and NO if connected to a personal database server. |
IsRuntimeServer | Returns YES if connected to the limited desktop runtime database server, and NO otherwise. |
JavaGlobFix | Java VM global fixed size. |
Language | The locale language for the server. |
LegalCopyright | The copyright string for the software. |
LegalTrademarks | Trademark information for the software. |
LicenseCount | The number of licensed seats. |
LicensedCompany | The name of the licensed company. |
LicensedUser | The name of the licensed user. |
LicenseType | The license type. Can be either concurrent or networked seat (per-seat). |
LicensesinUse | The number of concurrent users currently connected to the network server, as determined by the number of unique client network addresses connected to the server. |
LivenessTimeout | The client liveness timeout default. |
LockedHeapPages | The number of heap pages locked in the cache. |
MachineName | The name or IP address of the computer running a database server. |
MainHeapBytes | The number of bytes used for global server data structures. |
MainHeapPages | The number of pages used for global server data structures. |
MaxCacheSize | The maximum allowed cache size, in kilobytes. |
MaxMessage | The current maximum line number that can be retrieved from the server's message window. This represents the most recent message displayed in the server's message window. |
Message, linenumber | A line from the server's message window, prefixed by the date and time the message appeared. The second parameter specifies the line number. |
MessageText, linenumber | The text associated with the specified line number in the server's message window, without a date and time prefix. The second parameter specifies the line number. |
MessageTime, linenumber | The date and time associated with the specified line number in the server's message window. The second parameter specifies the line number. |
MessageWindowSize | The maximum number of lines that can be retrieved from the server's message window. |
MinCacheSize | The minimum allowed cache size, in kilobytes. |
MultiPacketsReceived | The number of multi-packet deliveries received during client/server communications. |
MultiPacketsSent | The number of multi-packet deliveries sent during client/server communications. |
Name | The name of the server. |
NativeProcessorArchitecture |
On platforms where a processor can be emulated (such as X86 on Win64), returns a string that identifies the native processor type. In all other cases, it returns the same value as property( 'ProcessorArchitecture' ).
Values can include: 32-bit Windows (not CE) - X86 NetWare - X86 Intel Solaris - X86 CE - SH3, SH4, MIPS or ARM 64-bit Windows - IA64 or AMD64 64-bit Unix - IA64 or AMD64 Solaris - SPARC AIX - PPC MAC OS - PPC HP - PA_RISC DEC Unix - ALPHA Linux - X86, SPARC, IA64 |
NumProcessorsAvail | The number of processors on the server. |
NumProcessorsMax | The maximum number of processors used. Normally this should be 2 for dbeng.exe and 0 for dbsrv.exe. |
PacketsReceived | The number of client/server communication packets received. |
PacketsReceivedUncomp | The number of packets that would have been received during client/server communications if compression was disabled. (This value is the same as the value for PacketsReceived if compression is disabled.) |
PacketsSent | The number of client/server communication packets sent. |
PacketsSentUncomp | The number of packets that would have been sent during client/server communications if compression was disabled. (This value is the same as the value for PacketsSent if compression is disabled.) |
PageSize |
The size of the database server cache pages. This can be set using the -gp option, otherwise, it is the maximum database page size of the databases specified on the command line.
|
PeakCacheSize | The largest value the cache has reached in the current session, in kilobytes. |
Platform | The operating system on which the software is running. |
PlatformVer | The operating system on which the software is running, including build numbers, service packs, etc. |
ProcessCPU | CPU usage statistics for the server process. Values are in seconds. This property is supported on Windows NT/2000/XP, Windows 95/98/Me, and UNIX. This property is not supported on Windows CE or NetWare. |
ProcessCPUSystem | Process CPU system usage. Values are in seconds. This property is supported on Windows NT/2000/XP, Windows 95/98/Me, and UNIX. This property is not supported on Windows CE or NetWare. |
ProcessCPUUser | Process CPU user usage. Values are in seconds. This property is supported on Windows NT/2000/XP, Windows 95/98/Me, and UNIX. This property is not supported on Windows CE or NetWare. |
ProcessorArchitecture |
A string that identifies the processor type. Values can include:
32-bit Windows (not CE) - X86 NetWare - X86 Intel Solaris - X86 CE - SH3, SH4, or ARM 64-bit Windows - IA64 or AMD64 64-bit Unix - IA64 or AMD64 Solaris - SPARC AIX - PPC MAC OS - PPC HP - PA_RISC DEC Unix - ALPHA |
ProductName | The name of the software. |
ProductVersion | The version of the software being run. |
QuittingTime | Shutdown time for the server. If none is specified, the value is none. |
Req | The number of times the server has been entered to allow it to handle a new request or continue processing an existing request. |
RequestLogFile |
The name of the request-level logging filename. An empty string is returned if there is no request level logging.
For information, see sa_server_option system procedure. |
RequestLogging |
ALL, SQL, or NONE.
For information, see sa_server_option system procedure. |
RequestQueueWait | The number of times the server has had to wait for room in the request queue. |
SendFail | The number of times that the underlying communications protocols have failed to send a packet. |
StartTime | The date/time that the server started |
Tempdir | The directory in which temporary files are stored by the server. |
TimeZoneAdjustment | The number of minutes that must be added to the Coordinated Universal Time (UTC) to display time local to the server. |
TotalBuffers | The total number of network buffers. |
UnschReq | The number of requests that are currently queued up waiting for an available server thread. |