Database properties listed on this tab cannot be changed without rebuilding the database. See Rebuilding databases.
This tab has the following components:
Encryption type Shows the encryption algorithm used in connection with the Encryption scope setting. If Encryption scope is either Database or Table (that is, either the database is encrypted, or table encryption is enabled, respectively), the encryption type is either Simple, AES, AES256, AES_FIPS, or AES256_FIPS. If Encryption scope is None, Encryption type is None.
For information about the supported encryption algorithms, see Encrypting and decrypting a database.
Encryption scope Shows whether the database is encrypted, or whether table encryption is enabled for the database. The possible values are Table, Database, or None. If the setting is Table, table encryption is enabled, and the database is not encrypted. If the setting is Database then the database is encrypted, and table encryption is not enabled. If the setting is None, the database is not encrypted, and table encryption is not enabled.
For information about encrypting databases and tables, see Encrypting and decrypting a database.
Case sensitive Shows the status of the case sensitivity feature. Returns On if the database is case sensitive. Otherwise, it returns Off. In case sensitive databases, data comparisons are case sensitive. This setting does not affect the case sensitivity of identifiers. Passwords are always case sensitive. This property applies to pre-version 10 databases. See Case sensitivity.
Ignore trailing blanks Shows whether the database ignores trailing blanks in comparisons. For example, if this option is set to No, then 'Dirk' is not the same as 'Dirk '.
Collation sequence Shows the collation algorithm for the database. SQL Anywhere supports two collation algorithms: the SQL Anywhere Collation Algorithm (SACA), and the Unicode Collation Algorithm (UCA). SACA provides fast, compact, and reasonable sorting at the expense of linguistic correctness. UCA provides linguistic correctness, but with a small expense in storage requirements and execution time. This property applies to pre-version 10 databases. See Understanding collations.
Character set encoding The character set that is used for the database. This property applies to pre-version 10 databases.
CHAR collation sequence The collation that is used for CHAR data. See Collations in a SQL Anywhere database.
CHAR character set encoding The character set that is used for CHAR data.
CHAR case sensitivity Shows the case sensitivity setting for the CHAR collation. Possible values are: Ignore, Respect, UpperFirst, and LowerFirst. This property applies to version 10 and later databases. For a description of these values, see Collation tailoring options.
NCHAR collation sequence The collation used for NCHAR data. This value is either UCA or UTF8BIN.
NCHAR character set encoding The character set that is used for NCHAR data. This is always UTF-8.
NCHAR case sensitivity Shows the case sensitivity setting for the NCHAR collation. Possible values are: Ignore, Respect, UpperFirst, and LowerFirst. This property applies to version 10 and later databases. For a description of these values, see Collation tailoring options.
Checkpoint urgency Shows the time that has elapsed since the last checkpoint, as a percentage of the checkpoint time setting of the database. Click Refresh or press F5 to update the Checkpoint urgency value.
Recovery urgency Shows an estimate of the amount of time required to recover the database. Click Refresh or press F5 to update the Recovery urgency value.
Refresh Click Refresh to update the Checkpoint Urgency and Recovery Urgency values.
Collect information for deadlocks that occur on this database Select this option to record information about deadlocks that occur in this database. To view the collected deadlock information, select the database in the Folders view in the left pane, and then select the Deadlocks tab in the right pane. See Viewing deadlocks from Sybase Central.
Include SQL statement information for deadlocked connections Select this option to record the SQL statement information for deadlocks that occur on this database. This option is only available if Collect Information for Deadlocks That Occur on This Database is selected.
Clear deadlock information now Click Clear Deadlock Information Now to clear the deadlock information immediately.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|