SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Database property sheet
Database properties listed on this tab cannot be changed without rebuilding the database.
For information about rebuilding a database, see Rebuilding databases.
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 transaction log file for the database.
Mirror log file Shows the name and location of the transaction log mirror file for the database.
User Shows the user ID of the user connected to the database.
Connection ID Shows the connection ID 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.