DATASKIP

syntax

DATASKIP state

or

DATASKIP

DATASKIP dbspace1,dbspace2,dbspace3,...

onconfig.std
value

None

if not present

OFF

separators

Commas

range of values

ALL tells the server to skip all unavailable fragments.
OFF turns off dataskip.
A comma-separated list of dbspace names.

utilities

onutil

refer to

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 dbspace1 dbspace2... 
DATASKIP ALL

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.

To modify the DATASKIP parameter dynamically, use the onutil SET command. Example:

% onutil
1> SET DATASKIP "space1,space2,space3";