ISOLATION_LEVEL option

Controls the locking isolation level for Catalog Store tables.

0, 1, 2, or 3

0

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.