Change Sbspace Default Specifications:
|-- -ch--sbspace-- -Df--default list----------------------------|
| Element | Purpose | Key Considerations |
|---|---|---|
| -ch | Indicates that one or more sbspace default specifications are to be changed | None. |
| sbspace | Names the sbspace for which to change the default specifications | References: Syntax must conform to the Identifier segment; see the IBM Informix Guide to SQL: Syntax. For background information, see changing default specifications of an sbspace with onspaces in the IBM Informix Performance Guide. |
| -Df default list | Lists new default specifications for smart large objects stored in the sbspace | Restrictions: Tags are separated
by commas. If a tag is not present, system defaults take precedence. The list
must be enclosed in double quotation marks (") on the command line.
References: For a list of tags and their parameters, see Table 19. |
You can change any of the -Df tags with the onspaces -ch option. The database server applies the change to each smart large object that was created prior to changing the default specification.
For example, to turn off logging for the sbspace that you created in Creating an Sbspace with the -Df option, use the following command:
onspaces -ch eg_sbsp -Df "LOGGING=OFF"