>>-SET DATASKIP--+-ON--+-------------+-+-----------------------><
                 |     | .-,-------. | |
                 |     | V         | | |
                 |     '---dbspace-+-' |
                 +-OFF-----------------+
                 '-DEFAULT-------------'
 

SET DATASKIP allows you to reset at runtime the Dataskip feature, which controls whether the database server skips a dbspace that is unavailable (for example, due to a media failure) in the course of processing a transaction.

In ESQL/C, the warning flag sqlca.sqlwarn.sqlwarn6 is set to W if a dbspace is skipped. See also the IBM Informix ESQL/C Programmer's Manual.

In Dynamic Server, this statement applies only to tables that are fragmented across dbspaces or partitions. It does not apply to blobspaces nor to sbspaces.

Specifying SET DATASKIP ON without including a dbspace instructs the database server to skip any dbspaces in the fragmentation list that are unavailable. You can use the onstat -d or -D options to determine whether a dbspace is down.

When you specify SET DATASKIP ON dbspace, you are instructing the database server to skip the specified dbspace if it is unavailable.

If you specify SET DATASKIP OFF, the Dataskip feature is disabled. If you specify SET DATASKIP DEFAULT, the database server uses the setting for the Dataskip feature from the ONCONFIG file.