Add a Chunk to an Sbspace

Home | Previous Page | Next Page Administrative Utilities > Managing Storage Spaces with the onspaces Utility >

Add a Chunk to an Sbspace

Add a Chunk to an Sbspace:
 
|-- -a--sbspace-- -p--pathname-- -o--offset-- -s--size---------->
 
>--+----------------------+--+--------------+------------------->
   '- -m--pathname offset-'  '- -Ms--mdsize-'
 
>--+----------------+--+-----+----------------------------------|
   '- -Mo--mdoffset-'  '- -U-'

Element	Purpose	Key Considerations
-a	Indicates that a chunk is to be added	Additional Information: An sbspace can contain up to 32,766 chunks.
-m pathname offset	Specifies an optional pathname and offset to the chunk that mirrors the new chunk Also see the entries for pathname and offset in this table.	References: For background information, see adding a chunk to an sbspace, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
-Mo mdoffset	Indicates, in kilobytes, the offset into the disk partition or into the device where metadata should be stored	Restrictions: Value can be an integer between 0 and the chunk size. You cannot specify an offset that causes the end of the metadata space to be past the end of the chunk. References: For background information, see sizing sbspace metadata, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
-Ms mdsize	Specifies the size, in kilobytes, of the metadata area allocated in the initial chunk. The remainder is user-data space	Restrictions: Value can be an integer between 0 and the chunk size. References: For background information, see sizing sbspace metadata, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
-o offset	After the -a option, offset indicates, in kilobytes, the offset into the disk partition or into the unbuffered device to reach the initial chunk of the new blobspace or dbspace.	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 maximum offset is 2 or 4 gigabytes, depending on the platform. References: For more information, see allocating raw disk space on UNIX, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
-p pathname	Indicates the disk partition or unbuffered device of the initial chunk of the sbspace that you are creating The chunk must be an existing unbuffered device or buffered file.	Additional Information: The chunk name can be up to 128 characters. When you specify a pathname, you can use either a full pathname or a relative pathname. However, if you use a relative pathname, it must be relative to the directory that was the current directory when you initialized the database server. References: For pathname syntax, see your operating-system documentation.
-U	Specifies that the entire chunk should be used to store user data	Restrictions: The -M and -U options are mutually exclusive. References: For background information, see adding a chunk to an sbspace, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
-s size	Indicates, in kilobytes, the size of the new sbspace chunk	Restrictions: Unsigned integer. The size must be equal to or greater than 1000 kilobytes and a multiple of the page size. The starting offset plus the chunk size cannot exceed the maximum chunk size. The maximum offset is 4 terabytes.
sbspace	Names the sbspace to which you are adding a chunk	Restrictions: See adding a chunk to an sbspace in the chapter on managing disk space in the IBM Informix Administrator's Guide. References: Syntax must conform to the Identifier segment; see the IBM Informix Guide to SQL: Syntax.