DATASKIP

syntax

DATASKIP state [dbspace1 dbspace2 ...]

The state entry is required. If state is ON, at least one dbspace entry is required.

onconfig.std value

None

if not present

OFF

separators

Space

range of values

ALL = Skip all unavailable fragments.
OFF = Turn off DATASKIP.
ON = Skip some unavailable fragments.

utilities

onspaces -f (See page Specify DATASKIP Parameter.)
onstat -f (See page onstat -f.)

refer to

The following material:

• Specify DATASKIP Parameter
• Your IBM Informix Performance Guide

DATASKIP lets you avoid points of media failure. This capability can result in higher availability for your data. To instruct the database server to skip some or all unavailable fragments, set this parameter. Whenever the database server skips over a dbspace during query processing, a warning is returned.

Use the following syntax in the parameter line:

DATASKIP OFF
DATASKIP ON dbspace1 dbspace2...
DATASKIP ALL

Use the -f option of the onspaces utility to alter the value of the DATASKIP parameter at runtime.

An application can use the SQL statement SET DATASKIP to override the DATASKIP value that the ONCONFIG parameter or onspaces sets. If the application then executes the SQL statement SET DATASKIP DEFAULT, the DATASKIP value for that session returns to whatever value is currently set for the database server.