Configuring the system limits:
Configuring the shared memory limits:
Configuring the swap space:
Note that the maximum cache size limit on AIX is about 1536 MB (1.5 GB = 1610612736 bytes).
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.