Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Anywhere Plug-in Help » Introduction to SQL Anywhere property sheets

Consolidated User property sheet: SQL Remote tab Next Page

Database property sheet: General tab


Database properties listed on this tab cannot be changed without rebuilding the 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 database 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.

Java location    Shows the location of the java.exe file for the external Java VM used by the database.

See Choosing a Java VM.

Java main user ID    Shows which database user ID should be used for the main Java connection.

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. This only applies to 9.0.2 and earlier databases.

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 makes it easy to distinguish between multiple connections to the same database, or multiple connections to the same or different database server.

Communication link    Shows the type of communications link used by the user's connection. If the connection is between a SQL Anywhere client and network database 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