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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » Database and application deployment » Database server deployment

 

Improving robustness on Intel storage drivers

Improve the robustness across power failures on systems using certain Intel storage drivers by specifying the EnableFlush parameter in the registry. The absence of this parameter can result in lost data and corrupted databases in the event of a power failure.

Prerequisites

There are no prerequisites for this task.

 Task
  1. Check that the following registry entry exists:

    HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\iastor\Parameters\
  2. If the registry entry exists, add a REG_DWORD value named EnableFlush within the key, and assign a data value of 1.

  3. Check that the following registry entry exists.

    HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\iastorv\Parameters\
  4. If the registry entry exists, add a REG_DWORD value named EnableFlush within the key and assign a data value of 1.

Results

The EnableFlush parameter is specified, which prevents data loss in the event of a power failure.

Example

The following example illustrates a registry file that would specify the EnableFlush parameter in both possible locations:

REGEDIT4
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\iastor\Parameters]
"EnableFlush"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\iastorv\Parameters]
"EnableFlush"=dword:00000001