Increasing the Sizes or Numbers of Storage Spaces

About this task

If you notice that the dbspace or sbspace is running out of disk space, you can increase the size of the space by adding chunks to the space. You can also add additional sbspaces for .

To add a chunk to a dbspace, use onspaces -a. For example, to add a 110 kilobyte chunk with an offset of 0 to the er_dbspace dbspace, enter: 
onspaces -a er_dbspace -p /dev/raw_dev2 -o 0 -s 110

To add a chunk to an sbspace, use the same onspaces command above, however you can specify more information about the chunk that you are adding. After you add a chunk to the sbspace, you must perform a level-0 backup of the root dbspace and the sbspace.

See the sections on adding chunks to dbspaces and sbspaces in the HCL® Informix® Administrator's Guide and the HCL® Informix® Administrator's Reference for more information.

To increase the number of sbspaces that can be used for , create new sbspaces with the onspaces -c -S command and then add their names to the CDR_QDATA_SBSPACE configuration parameter with the cdr add onconfig command. For more information, see cdr add onconfig.