Database properties allow you to obtain information about connections and the current database server and database. Many properties available to Sybase IQ users apply only to Adaptive Server Anywhere or to the Catalog Store, for example, properties related to fragmentation, query plans and optimization, histograms, cache use, free pages, product version, indexes, and triggers. Properties that show the state of database options used in IQ, network communications, collation, and reads and writes, apply to IQ databases.
Several new properties are available in this release and summarized in this section, or with related features elsewhere in this chapter.
For more information about database properties at the connection, server, and database level, see Adaptive Server Anywhere Database Administration Guide.
New server property specifies how many concurrent
users are connected to the IQ server The new LicensesInUse property determines the numbers of concurrent
users currently connected to the IQ server. Each concurrent user
is determined by the number of unique client network addresses connected
to the server, not the number of connections. For example, if three
client machines are connected to a server, and each client machine
has two connections, select property ( 'LicensesInUse'
) returns '3'.
For more information, see “Server-level properties” in the Adaptive Server Anywhere Database Administration Guide.
Two new Catalog Store properties added Two new properties have been added: FileSize and FreePages. Each of these properties can take an optional argument which specifies the dbspace for which the property is being requested. These properties apply to Catalog Store dbspaces only.
For more information on database properties, see Adaptive Server Anywhere Database Administration Guide.
New startup command line server property The new server property CommandLine gives you the line that was used to start the server.
For more information, see “Server-level properties” in Adaptive Server Anywhere Database Administration Guide.
Two new server properties identify processor type Two new server-level properties have been added. ProcessorArchitecture identifies the processor type, and on platforms where a processor can be emulated NativeProcessorArchitecture identifies the native processor type.
For more information, see “Server-level properties” in Adaptive Server Anywhere Database Administration Guide.
New connection property returns the name of the communication link for the connection The new CommNetworkLink connection property returns the name of the communication link for the connection.
For more information, see “Connection-level properties” in Adaptive Server Anywhere Database Administration Guide.
Properties and statistics removed (behavior change) The ServerIdleWaits database property, and the TaskSwitch and CurrTaskSwitch connection properties have been removed, along with their corresponding performance monitor statistics: Context Switches, Server Idle Waits/sec, Request Queue Waits/sec.
Fragmentation statistics for Catalog Store File, table, and index fragmentation can all decrease performance. In Sybase IQ 12.6, when you start a database on Windows platforms, the server automatically displays information about the number of file fragments in each Catalog Store dbspace.
The new system procedure sa_table_fragmentation allows database administrators to obtain information about the fragmentation in Catalog Store tables. For more information, see Adaptive Server Anywhere SQL Reference.
