Database property sheet: General tab

Database properties listed on this tab cannot be changed without rebuilding the database.

For information about rebuilding a database, see .

The General tab of the Database property sheet has the following components:

Name    Shows the name of the database.

Type    Shows the type of object.

ID    Shows a unique number assigned by the server to each database that is started on it. The number makes it possible to distinguish between databases running on the same server.

Capability ID    Shows the capability bits enabled for the database. This value only appears for Adaptive Server Anywhere databases that are version 8 and higher.

You can view a list of the capabilities that are enabled for the database on the Extended Information tab of the Database property sheet.

Java JDK version    Shows the version of the JDK supported by the database at the time of installation. If Java is not supported in the database, None appears.

Page size    Shows the page size of the database in bytes.

Database file    Shows the root database file for the database.

Log file    Shows the name and location of the file for the database.

Mirror log file    Shows the name and location of the file for the database.

User    Shows the user ID of the user connected to the database.

Connection ID    Shows the for the database's connection from Sybase Central.

Connection name    Shows the connection name for the user connected to this database. Naming your connections allows multiple connections to the same database, or multiple connections to the same or different database server, to be easily identified.

Communication link    Shows the type of communications link used by the user's connection. If the connection is between an Adaptive Server Anywhere client and network server, the link type represents the network protocol being used.

Total connections    Shows the total number of current connections to the database from all users, including the Sybase Central connection.

See also