ulinit   --checksum_level=value

0, 1, 2

0

Checksums are used to detect offline corruption on pages stored to disk, flash, or memory, which can help reduce the chances of other data being corrupted as the result of a bad critical page. Depending on the level you choose, UltraLite calculates and records a checksum for each database page before it writes the page to storage.

If the calculated checksum does not match the stored checksum for a page read from storage, the page has been modified or became corrupted during the storage/retrieval of the 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.

The following values are supported for the checksum_level:

From Sybase Central, you can configure the use of checksums in 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, set this parameter as one of the creation parameters for the create database method on the database manager class.

• checksum_level database property: UltraLite database properties
• UltraLite Initialize Database utility (ulinit)
• UltraLite Load XML to Database utility (ulload)
• UltraLite for embedded SQL: ULCreateDatabase method
• UltraLite for C++: CreateDatabase method
• UltraLite.NET: CreateDatabase method
• UltraLite for M-Business Anywhere: createDatabase method
• UltraLite performance and optimization
• UltraLite page_size creation parameter
• Connecting to an UltraLite database