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

Add a Chunk to a Dbspace or Blobspace

Read syntax diagramSkip visual syntax diagramAdd a Chunk to a Dbspace or Blobspace:
 
|-- -a--+-dbspace---+--+- -p--pathname---------------+---------->
        '-blobspace-'  |                        (1)  |
                       '- -p--\--\--.--\--drive------'
 
>-- -o--offset-- -s--size--------------------------------------->
 
>--+- -m--pathname offset---------------+-----------------------|
   |                               (1)  |
   '- -m--\--\--.--\--drive offset------'
 
Notes:
  1. Windows Only
Element Purpose Key Considerations
-a Indicates that a chunk is to be added Additional Information: A dbspace, blobspace, or sbspace can contain up to 2047 chunks.
drive Specifies the Windows drive to allocate as unbuffered disk space The format can be either \\.\<drive>, where drive is the drive letter assigned to a disk partition, or
\\.\PhysicalDrive<number>, where PhysicalDrive is a constant value and number is the physical drive number.
References: For more information on allocating unbuffered disk space, see allocating raw disk space on Windows in the chapter on managing disk space in the IBM Informix Administrator's Guide. Example:
\\.\F:

References: For pathname syntax, see your operating-system documentation.

-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 more information, see adding a chunk to a dbspace and adding a chunk to a blobspace, 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 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 4 terabytes.

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 blobspace or dbspace that you are adding

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.
UNIX example (unbuffered device):
/dev/rdsk/c0t3d0s4
UNIX example (buffered device):
/ix/ids9.2/db1chunk
Windows example:
c:\Ifmxdata\ol_icecream\mychunk1.dat

References: For pathname syntax, see your operating-system documentation.

-s size Indicates, in kilobytes, the size of the new blobspace or dbspace 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.
blobspace Names the blobspace to which you are adding a chunk Restrictions: See adding a chunk to a blobspace 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.

dbspace Names the dbspace to which you are adding a chunk Restrictions: See adding a chunk to a dbspace, 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.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]