ADD CHUNK Clause: |--ADD CHUNK--| Chunk Definition |--+-----------------------+---| '-| Mirror Definition |-'
Chunk Definition: |--"--pathname--"--+----------------+--SIZE--size--+--------+---| '-OFFSET--offset-' +-KBYTES-+ +-MBYTES-+ '-GBYTES-'
Mirror Definition: |--MIRROR--"--pathname--"--+----------------+-------------------| '-OFFSET--offset-'
Element | Purpose | Restrictions | Syntax |
---|---|---|---|
pathname | The file or raw device for the dbspace chunk that you are adding | When you specify a pathname, use a full pathname. If you use a relative pathname, it must be relative to the directory that was the current directory when you initialized the database server. | Pathname must conform to the operating-system-specific rules for pathnames. |
offset | The offset, in kilobytes, into the file or raw device to reach the chunk | Value must be greater than 0. See specifying an offset in the chapter on managing disk space in the IBM Informix: Administrator's Guide. | Unsigned integer. |
size | The chunk size of the new dbspace | Value must be greater than 0. Size must not exceed 4 gigabytes. | Unsigned integer; default size unit is kilobytes. |
Use the onutil ALTER DBSPACE command with the ADD CHUNK clause to add a chunk to an existing dbspace. You can use the following keywords.
The following example shows how to use onutil ALTER DBSPACE to add a 1000-kilobyte chunk, test_chunk, to the root dbspace:
% onutil 1> ALTER DBSPACE rootdbs 2> ADD CHUNK "/ix/mywork/test_chunk" 3> OFFSET 0 SIZE 1000; Chunk successfully added.Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]