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.
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 HCL OneDB™ Guide to SQL: Syntax. For more information, see DATASKIP Configuration Parameter and the HCL OneDB 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. |