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

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

Figure 1. Syntax:

1  onspaces -ren
1 dbspace
1 blobspace
1 sbspace
1 extspace
2   -n name

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 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 Informix® Administrator's Guide. The syntax must conform to the Identifier segment. For more information, see the Informix® Guide to SQL: Syntax.
blobspace Names the blobspace to be renamed Syntax must conform to the Identifier segment; see the Informix® Guide to SQL: Syntax. For more information, see renaming spaces, in the chapter on managing disk space in the 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 Informix® Guide to SQL: Syntax. For more information, see renaming spaces, in the chapter on managing disk space in the Informix® Administrator's Guide.
extspace Names the extspace to be renamed Syntax must conform to the Identifier segment; see the Informix® Guide to SQL: Syntax. For more information, see renaming spaces, in the chapter on managing disk space in the Informix® Administrator's Guide.
sbspace Names the sbspace to be renamed Syntax must conform to the Identifier segment; see the Informix® Guide to SQL: Syntax. For more information, see renaming spaces, in the chapter on managing disk space in the Informix® Administrator's Guide.