onspaces -ren: Rename a dbspace, blobspace, sbspace, or extspace

Use the onspaces -ren option to rename a dbspace, blobspace, sbspace, or extspace.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onspaces -ren--+-dbspace---+-- -n--name---------------------><
                  +-blobspace-+              
                  +-sbspace---+              
                  '-extspace--'              

This command has an equivalent SQL administration API function.

Element Purpose Key considerations
-ren Causes the database server to rename the specified blobspace, dbspace, extspace, or sbspace Restrictions: You can rename a blobspace, dbspace, extspace, or sbspace when the database server is in quiescent mode. For more information, see the chapter on managing disk space in the HCL Informix® Administrator's Guide.
-n name Specifies the new name for the blobspace, dbspace, extspace, or sbspace Restrictions: The blobspace, dbspace, external space, or sbspace name must be unique and cannot exceed 128 bytes. It must begin with a letter or underscore and must contain only letters, numbers, underscores, or the $ character.

For more information, see the chapter on managing disk space in the HCL Informix Administrator's Guide. The syntax must conform to the Identifier segment. For more information, see the HCL Informix Guide to SQL: Syntax.

blobspace Names the blobspace to be renamed Syntax must conform to the Identifier segment; see the HCL Informix Guide to SQL: Syntax. For more information, see renaming spaces, in the chapter on managing disk space in the HCL Informix Administrator's Guide.
dbspace Names the dbspace to be renamed Restrictions: You cannot rename a critical dbspace, such as the root dbspace or a dbspace that contains physical logs.

Additional Information: If you rename dbspaces that are included in the DATASKIP list, update the DATASKIP configuration parameter with the new names using the onspaces -f command.

Syntax must conform to the Identifier segment; see the HCL Informix Guide to SQL: Syntax. For more information, see renaming spaces, in the chapter on managing disk space in the HCL Informix Administrator's Guide.

extspace Names the extspace to be renamed Syntax must conform to the Identifier segment; see the HCL Informix Guide to SQL: Syntax. For more information, see renaming spaces, in the chapter on managing disk space in the HCL Informix Administrator's Guide.
sbspace Names the sbspace to be renamed Syntax must conform to the Identifier segment; see the HCL Informix Guide to SQL: Syntax. For more information, see renaming spaces, in the chapter on managing disk space in the HCL Informix Administrator's Guide.

Copyright© 2019 HCL Technologies Limited