DATASKIP Configuration Parameter

Use the DATASKIP configuration parameter to control whether the database server skips a dbspace that is unavailable during the processing of a transaction.

onconfig.std value
Not set. No dbspaces are skipped.
See the Usage section.
takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onspaces -f command.
After you run the SQL administration API task() or admin() function with the set dataskip argument.


Whenever the database server skips over a dbspace during query processing, a warning is returned.

Enable the DATASKIP configuration parameter with caution because the results are always suspect. Only enable the parameter in the following situations:
  • You can accept the compromised integrity of transactions.
  • You can determine that the integrity of the transaction is not compromised, which can be difficult and time consuming.
Read syntax diagramSkip visual syntax diagram
Syntax for the DATASKIP configuration parameter

             |     .--------------. |   
             |     V              | |   

Table 1. Options for the DATASKIP configuration parameter value
Field Description
ALL Skip all unavailable fragments.
OFF All fragments, including unavailable fragments, are processed.
ON The dbspace_name value specifies one or more dbspaces to skip, separated by commas.

An application can use the SQL statement SET DATASKIP to override the value of the DATASKIP configuration parameter.

The previously reserved SQLCA warning flag sqlwarn.sqlwarn7 is set to W for IBM® Informix® ESQL/C.

Copyright© 2018 HCL Technologies Limited