Specify DATASKIP Parameter

Specify DATASKIP:
 
|-- -f--+-OFF-+--+--------------+--+-----+----------------------|
        '-ON--'  '-dbspace-list-'  '- -y-'

Element	Purpose	Key Considerations
-f	Indicates to the database server that you want to change the DATASKIP default for specified dbspaces or all dbspaces	Additional Information: All changes in the DATASKIP status are recorded in the message log.
-y	Causes the database server to automatically respond yes to all prompts	None.
dbspace-list	Specifies the name of one or more dbspaces for which DATASKIP will be turned ON or OFF	References: Syntax must conform to the Identifier segment; see the IBM Informix Guide to SQL: Syntax. For more information, see "DATASKIP" on page 1-26 and the IBM Informix Performance Guide.
OFF	Turns off DATASKIP	Additional Information: If you use OFF without dbspace-list, DATASKIP is turned off for all fragments. If you use OFF with dbspace-list, only the specified fragments are set with DATASKIP off.
ON	Turns on DATASKIP	Additional Information: If you use ON without dbspace-list, DATASKIP is turned on for all fragments. If you use ON with dbspace-list, only the specified fragments are set with DATASKIP on.

The onspaces utility lets you specify DATASKIP on a dbspace level or across all dbspaces.