SET DATASKIP statement

This statement is an extension to the ANSI/ISO standard for SQL.

Syntax

1  SET DATASKIP
1  ON?  + , dbspace
1 OFF
1 DEFAULT

Usage

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 , the warning flag sqlca.sqlwarn.sqlwarn6 is set to W if a dbspace is skipped. See also the HCL OneDB™ ESQL/C Programmer's Manual.

In HCL OneDB, 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 that is specified in the DATASKIP configuration parameter in ONCONFIG file.

Examples

SET DATASKIP ON dbsp1;

SET DATASKIP DEFAULT;

SET DATASKIP OFF;