Increasing the database server dbspace

Informix® allocates space for its databases. You can increase the allocated dbspace capacity by using the ccmsrv expand command. This command expands the dbspace of an Informix server by adding a chunk file. This method is useful when you want to increase the size for a server that is running out of room in a dbspace.

This topic contains steps for both Windows and UNIX.

Attention: Do not use an existing file.

Windows

Procedure

  1. Ensure that you are an Informix-Admin group member and are working as local administrator.
  2. On the machine where the Informix server resides, run the ccmsrv expand command.

    For example, assume that you want to increase the ccm dbspace by 100 MB, and you want to use the ccm chunk path:

    c:\informix_chunkfiles_path\ccm_2.dbs > ccmsrv expand /size 100000 /
    /path c:\informix_chunkfiles_path\ccm_2.dbs
    • /size 100000 specifies by how much you want to expand the chunk size in KB.
    • /path c:\informix_chunkfiles_path\ccm_2.dbs specifies the absolute path to the new chunk file, which must be a new file on an NTFS partition.

UNIX

Before you begin

If you did not set up CCM_HOME and PATH for user informix during installation, set these environment variables now.

Procedure

  1. Log on the database server as user root.
  2. Set user to informix.
    root # su - informix
    Password: *****
  3. Expand the dbspace of the database server.
    Attention: Specify a new chunk file, not an existing chunk file.
    For example, increase the ccm dbspace on the hydra1 server by 60,000 KB (with 0 offset), using the /vol/data/informix_chunkfiles/vod_ccm_2.dbs chunk path as follows:
    $ ccmsrv expand -dbspace ccm -size 60000 -path \
    /vol/data/informix_chunkfiles/vod_ccm_2.dbs -s hydra1
  4. Exit from user informix.

    See Dbspace chunk files for more information about creating chunk files with which to expand the dbspace.


Feedback