Adjusting operating system parameters for AIX

In order for DB2 Everyplace to operate with the highest degree of efficiency, system parameters in DB2 Universal Database need to be adjusted. Failure to do so, can result in the inability to create a new connection to the database. The extended shared memory segments should be enabled.

Note:
Only 32 bit DB2 Universal Database instances are supported.

Prerequisites

Modify the login profile to include the following: 

export DISPLAY=<workstation>:0.0

Where <workstation> is the UNIX workstation where you want to use the Mobile Devices Administration Center.

Procedure

For each DB2 instance running DB2 Everyplace:

  1. Modify the login profile (most likely /home/<username>/.profile), to include the following: 
    export EXTSHM=ON
  2. Exit the user shell.
  3. Login as the user (to make the changes effective) and open a new shell.
  4. From the shell prompt, execute the following command: 
    db2set DB2ENVLIST=EXTSHM 
  5. Restart the DB2 Universal Database instance.

Related tasks