ASA Database Administration Guide
  Database Performance and Connection Properties

Database properties

Adaptive Server Anywhere provides a set of properties that are made available to client applications. These properties describe aspects of connection, database, and database server behavior.

Accessing properties 

Each type of property can be accessed by supplying its name as an argument to a system function.

To access connection properties

• Use the connection_property system function: the following statement returns the number of pages that have been read from file by the current connection.

  select connection_property ( 'DiskRead' )

To access database properties

• Use the db_property system function. For example, the following statement returns the page size of the current database:

  select db_property ( 'PageSize' )

To access database server properties

• Use the property system function: the following statement returns the number of pages that have been read from file by the current connection.

  select property ( 'MainHeapPages' )

Connection-level properties
Server-level properties
Database-level properties