AIX (32-bit and 64-bit)

Configuring the system limits:

Configuring the shared memory limits:

Configuring the swap space:

On AIX (32-bit) searching on large cache tables using the stored procedure search interface requires a change to the maxdata setting of the db2fmp executable. To make these changes, log on as instance owner, and issue the following commands:

db2stop
cd ~/sqllib/adm
cp db2fmp db2fmp.org /usr/bin/echo '\0040\0\0\0' | dd of=db2fmp bs=4 count=1 
seek=19 conv=notrunc

If you still run out of memory, reduce the amount of heap storage even further as follows:

cp db2fmp db2fmp.org /usr/bin/echo '\0000 \0 \0 \0' | dd of=db2fmp bs=4 count=1 
seek=19 conv=notrunc

This reduces maxdata to 1 (256 MB).

If you want to switch back to the original setting, issue:

db2stop
cd ~/sqllib/adm
cp db2fmp.org db2fmp

Note that this change reduces the maximum heap size from 1.2 GB to 0.5 GB. This can influence other applications using this DB2 instance.