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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Database Settings Reference » Configurable properties in UltraLite

UltraLite case property Next Page

UltraLite checksum_level property


Sets the level of checksum validation in the database.

How to set it

UltraLite employs different methods for setting this property:

ContextImplemented by

From the command line    Use any utility that creates a database.

Use the following property syntax:

- o checksum_level=value

From Sybase Central    Use any wizard that creates a database.

On the New Database Storage Settings page, select the Checksum Level for Database Pages option .

From a client application    Use the create database method.

Set this property as one of the creation parameters for an API's create database method on the database manager class.

Allowed values

You can set three levels of checksum validation:

ValueDefinition
0

Do not add checksums to database pages.

1

Add checksums to important database pages (for example indexes and synchronization status pages), but not row pages.

2

Add checksums to all database pages.

Default

0

Remarks

Checksums are used to detect offline corruption, which can help reduce the chances of other data being corrupted as the result of a bad critical page. If a checksum validation fails, when the database loads a page, UltraLite stops the database and reports a fatal error. This error cannot be corrected; you must re-create your UltraLite database and report the database failure to iAnywhere.

If you unload and reload an UltraLite database with checksums enabled, the checksum level is preserved and restored.

See also