Monitoring database space

Informix® pre-allocates space for its databases. You can monitor this pre-allocated space to determine whether you need to increase its size or remove unneeded objects.

This topic contains steps for Windows and UNIX.

Windows

Procedure

  1. Log on as the Rational® Synergy administrator.

    You must be working as local administrator to perform this operation. You must be logged on to the machine where the database server is installed.

  2. Monitor the size of a database.

    > ccmdb info /k size \\loon\ccmdb\database_name

  3. Monitor the space utilization status of the database server named tonnyx.

    > ccmsrv status /dbspace

  4. Log off from the Rational Synergy administrator.

    To increase the Informix dbspace, see Increasing the database server dbspace. Also, Informix database server dbspaces explains the Informix Dynamic Server and the dbspace chunk files.

UNIX

Before you begin

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

Procedure

  1. Log on to the database server.
  2. Set user to ccm_root.
    $ su - ccm_root
    Password: *****
  3. Monitor the database size.

    For example, show the size of the aeanew database as follows:

    $ ccmdb info -k size /vol/hydra/ccmdb/aeanew

  4. For InformixMonitor the database server space utilization.

    For example, show the dbspace used by the tonnyx database server, as follows:

    $ ccmsrv status -dbspace -s tonnyx

  5. Exit from user ccm_root.

    For InformixTo increase the Informix dbspace, use the procedure shown in Increasing the database server dbspace.


Feedback