Viewing Database Properties

View editable and noneditable properties for the database.

Prerequisites

Authenticate with Sybase IQ using an account that has DBA authority.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane of the Administration Console, select IQ Servers > Schema Objects > Databases.
Select the database from the right pane and either:
- Click the drop-down arrow to the right of the name and select Properties, or,
- From the Administration Console menu bar, select Resource > Properties.

Area	Description
General	Database – Name of the database. ID – A unique number assigned by the server to each database that is started on it. The ID number lets you distinguish between databases running on the same server. Capability ID – The capability bits enabled for the database. 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 location – Path to the JRE executable file. Java main user ID – The main Java user ID. Page size – Page size of the database, in bytes. Database file – Root database file for the database. Log file – Name and location of the transaction log file for the database. Mirror log file – Name and location of the mirror log file for the database. Temporary file – Location of the temporary database file. Current user – User ID of the user connected to the database. Connection ID – Connection ID for the database connection from Sybase Control Center. Connection name – 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 – Type of communications link used by the user's connection. If the connection is between a client and network server, the link type represents the network protocol being used. Total connections – Total number of current connections to the database from all users, including the Sybase Control Center connection.
Settings	Encryption type – Type of database encryption: Simple or AES. If encryption is not supported in the database, the value is None. Encryption scope – Scope of the encryption. Ignore trailing blanks – Database ignores trailing blanks in comparisons. CHAR collation sequence – Set of separators for the collation sequence of CHAR values. CHAR collation character set encoding – Character set used for CHAR values. CHAR case sensitivity – CHAR values in the database are case-sensitive. This property applies to the data in the database, and to passwords, but not to table names, column names, and other identifiers. NCHAR collation sequence – Separators for the collation sequence of NCHAR values. NCHAR collation character set encoding – Character set used for NCHAR values. NCHAR case sensitivity – NCHAR values in the database are case-sensitive. This property applies to the data in the database, and to passwords, but not to table names, column names, and other identifiers. Checkpoint urgency(%) – Time elapsed since the last checkpoint as a percentage of the checkpoint time setting of the database. Recovery urgency(%) – An estimate of the amount of time required to recover the database. Refresh –Update the checkpoint urgency and recovery urgency values. Collect information about deadlocks that occur in this database – Information is collected on deadlocked connections to the database. Include SQL statement information for deadlocked connections – SQL statement information is included with the deadlock connection information. Clear deadlock information now – Remove all deadlock information from the system.
Database Properties	A list of all database properties, including the property value and the description of the property.

Area

Description

General

Database – Name of the database.

ID – A unique number assigned by the server to each database that is started on it. The ID number lets you distinguish between databases running on the same server.

Capability ID – The capability bits enabled for the database. 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 location – Path to the JRE executable file.

Java main user ID – The main Java user ID.

Page size – Page size of the database, in bytes.

Database file – Root database file for the database.

Log file – Name and location of the transaction log file for the database.

Mirror log file – Name and location of the mirror log file for the database.

Temporary file – Location of the temporary database file.

Current user – User ID of the user connected to the database.

Connection ID – Connection ID for the database connection from Sybase Control Center.

Connection name – 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 – Type of communications link used by the user's connection. If the connection is between a client and network server, the link type represents the network protocol being used.

Total connections – Total number of current connections to the database from all users, including the Sybase Control Center connection.

Settings

Encryption type – Type of database encryption: Simple or AES. If encryption is not supported in the database, the value is None.

Encryption scope – Scope of the encryption.

Ignore trailing blanks – Database ignores trailing blanks in comparisons.

CHAR collation sequence – Set of separators for the collation sequence of CHAR values.

CHAR collation character set encoding – Character set used for CHAR values.

CHAR case sensitivity – CHAR values in the database are case-sensitive. This property applies to the data in the database, and to passwords, but not to table names, column names, and other identifiers.

NCHAR collation sequence – Separators for the collation sequence of NCHAR values.

NCHAR collation character set encoding – Character set used for NCHAR values.

NCHAR case sensitivity – NCHAR values in the database are case-sensitive. This property applies to the data in the database, and to passwords, but not to table names, column names, and other identifiers.

Checkpoint urgency(%) – Time elapsed since the last checkpoint as a percentage of the checkpoint time setting of the database.

Recovery urgency(%) – An estimate of the amount of time required to recover the database.

Refresh –Update the checkpoint urgency and recovery urgency values.

Collect information about deadlocks that occur in this database – Information is collected on deadlocked connections to the database.

Include SQL statement information for deadlocked connections – SQL statement information is included with the deadlock connection information.

Clear deadlock information now – Remove all deadlock information from the system.

Database Properties

A list of all database properties, including the property value and the description of the property.