onspaces -f: Specify DATASKIP parameter

Use the onspaces -f option to specify the value of the DATASKIP configuration parameter on a dbspace level or across all dbspaces.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onspaces -f--+-OFF-+--+--------------+--+-----+-------------><
                '-ON--'  '-dbspace-list-'  '- -y-'   

This command has an equivalent SQL administration API function.

Element Purpose Key considerations
-f Indicates to the database server that you want to change the DATASKIP default for specified dbspaces or all dbspaces 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 Syntax must conform to the Identifier segment; see the IBM® Informix® Guide to SQL: Syntax. For more information, see DATASKIP Configuration Parameter and the IBM Informix Performance Guide.
OFF Turns off DATASKIP 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 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.

Copyright© 2018 HCL Technologies Limited