ISOLATION_LEVEL Option

Controls the locking isolation level for catalog store tables.

Allowed Values

0, 1, 2, or 3

Default

0

Description

Each locking isolation level is defined as follows:

  • 0 – Allow dirty reads, nonrepeatable reads, and phantom rows.

  • 1 – Prevent dirty reads. Allow nonrepeatable reads and phantom rows.

  • 2 – Prevent dirty reads and guarantee repeatable reads. Allow phantom rows.

  • 3 – Serializable. Do not allow dirty reads, guarantee repeatable reads, and do not allow phantom rows.

ISOLATION_LEVEL determines the isolation level for tables in the catalog store. Sybase IQ always enforces level 3 for tables in the IQ store. Level 3 is equivalent to ANSI level 4.