Contents Index Connection-level properties Database-level properties

ASA Database Administration Guide
  Database Performance and Connection Properties
    Database properties

Server-level properties


The following table lists properties that apply across the server as a whole.

Examples 

To retrieve the value of a server property

To retrieve the values of all server properties

Descriptions 
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.

Contents Index Connection-level properties Database-level properties