Auto Mode (Using CREATE SHADOW)

Go Up to Auto Mode and Manual Mode (Using CREATE SHADOW)

The AUTO keyword directs the CREATE SHADOW statement to create a shadow in AUTO mode:

CREATE SHADOW 1 AUTO 'employee.shd';

Auto mode is the default, so omitting the AUTO keyword achieves the same result.

In AUTO mode, database operation continues even if the shadow becomes inoperable. If the original shadow was created as a conditional shadow, a new shadow is automatically created. If the shadow was not conditional, you must create a new shadow manually. For more information about conditional shadows, see Conditional Shadows.