Modifying database server parameter values

Use the ccmsrv modify command to modify the number of users allowed on a database server. If you change the max_users option, your database server requires more memory.

This topic contains steps for both Windows and UNIX.

Read Preinstallation on Windows or Preinstallation on UNIX. Ensure that you have completed the requirements before attempting to use a command.

For more information see:

Windows: ccmsrv modify

UNIX on Informix®: ccmsrv modify

Windows

Procedure

  1. Ensure that you are an Informix-Admin group member and are working as local administrator.
  2. On the machine where Informix was installed, run the ccmsrv modify command.
  3. Change the maximum number of users allowed in the database.

    > ccmsrv modify /user max_users

    /user max_users specifies the maximum number of users allowed in the database.

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. Change the database parameter values.

    For example, change the maximum number of users allowed in hydra1 server to 200, as follows:

    $ ccmsrv modify -user 200 -y -s hydra1

    If you change the maximum number of users, you might have to change your semaphores and shared memory kernel parameters.

  4. Exit from user informix.

Feedback