Adding a Chunk to an Sbspace

Use the onspaces utility or ISA to add a chunk to an sbspace or temporary sbspace. You can specify a metadata area for a chunk, let the database server calculate the metadata area, or use the chunk for user data only.

To add a chunk to an sbspace using onspaces

Ensure that the database server is online, single-user, or quiescent mode, or in the cleanup phase of fast-recovery mode.
Use the onspaces -a option to create the sbspace chunk.
1. Use the -p option to specify the pathname, the -o option to specify the offset, and the -s option to specify the chunk size.
2. If you want to mirror the chunk, use the -m option to specify the mirror path and offset.
3. To specify the size and offset of the metadata space, use the -Mo and -Ms options.
  The database server allocates the specified amount of metadata area on the new chunk.
4. To allow the database server to calculate the size of the metadata for the new chunk, omit the -Mo and -Ms options.
  The database server divides the estimated average size of the smart large objects by the size of the user data area.
5. To use the chunk for user data only, specify the -U option.
  If you use the -U option, the database server does not allocate metadata space in this chunk. Instead, the sbspace uses the metadata area in one of the other chunks.
After you add a chunk to the sbspace, the database server writes the CHRESERV and CHKADJUP log records.
Perform a level-0 backup of the root dbspace and the sbspace.
Use onstat -d and oncheck -pe to monitor the amount of free space in the sbspace chunk.
For more information, see Monitoring Sbspaces.

This example adds a 10-megabyte mirror chunk to sbsp4. An offset of 200 kilobytes for both the primary and mirror chunk is specified. If you are not adding a mirror chunk, you can omit the -m option. The -U option specifies that the new chunk will contain user data exclusively.