Allocating additional server memory

Allocate more memory on the server if there are indications that your server is low on memory resources. Refer to your operating system’s documentation for information about adding memory.

Tip: The amount of memory that Db2 uses might contribute to reports that show that the operating system is out of memory. You can limit the amount of memory that Db2 uses by including the DBMEMPERCENT option. The DBMEMPERCENT option specifies the percentage of virtual address space that is dedicated to the database manager processes.

Complete the following actions to allocate additional storage resources for the server:

  • AIX operating systemsEnsure that there is sufficient paging space. You can also use SMIT (System Management Interface Tool) to determine if the number of applications is causing a memory shortage.
  • Windows operating systemsThe preferred method of solving a low memory condition is to add physical memory to the system. Otherwise, from the control panel, increase the amount of the virtual storage by running the system applet and increasing the total paging file size.