Database Properties window: General tab

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

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

Temporary file   Shows the name and location of the temporary 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 a 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