onspaces -s: Change status of a mirrored chunk

Use the onspaces -s option to change the status of a mirrored chunk in a dbspace, a non-primary chunk within a noncritical dbspace, a blobspace, or an sbspace.

Figure 1: Syntax:

1  onspaces -s
1 dbspace
1 blobspace
1 sbspace
2   -p pathname
2   -o offset
1  -D
1  -O
3?   -y

This command has an equivalent SQL administration API function.

Element Purpose Key considerations
-D Indicates that you want to take the chunk down None.
-o offset Indicates, in kilobytes, the offset into the disk partition or unbuffered device to reach the chunk Restrictions: Unsigned integer. The starting offset must be equal to or greater than 0. The starting offset plus the chunk size cannot exceed the maximum chunk size.The offset must be a multiple of the page size.

The maximum offset is 4 terabytes.

For more information, see allocating raw disk space on UNIX™, in the chapter on managing disk space in the HCL OneDB™ Administrator's Guide.
-O Indicates that you want to restore the chunk and bring it online None.
-p pathname Indicates the disk partition or unbuffered device of the chunk The chunk can be an unbuffered device or a buffered file. When you specify a path name, you can use either a full path name or a relative path name. However, if you use a relative path name, it must be relative to the directory that was the current directory when you initialized the database server.

For path name syntax, see your operating-system documentation.

-s Indicates that you want to change the status of a chunk Restrictions: You can only change the status of a chunk in a mirrored pair or a non-primary chunk within a noncritical dbspace.

For more information, see changing the mirror status in the HCL OneDB Administrator's Guide.
-y Causes the database server to respond yes to all prompts automatically None.
blobspace Names the blobspace whose status you want to change Syntax must conform to the Identifier segment; see the HCL OneDB Guide to SQL: Syntax. For more information, see changing the mirror status in the HCL OneDB Administrator's Guide.
dbspace Names the dbspace whose status you want to change Syntax must conform to the Identifier segment; see the HCL OneDB Guide to SQL: Syntax. For more information, see changing the mirror status in the HCL OneDB Administrator's Guide.
sbspace Names the sbspace whose status you want to change Syntax must conform to the Identifier segment; see the HCL OneDB Guide to SQL: Syntax. For background information, see changing the mirror status in the HCL OneDB Administrator's Guide.