Skip to Content
0
Former Member
Jun 12, 2009 at 02:41 PM

Methodology to determine value for INSTANCE MEMORY

1338 Views

System details:

DB2 v9.5 FP3a on AIX 5300-09.

SAP R3 4.7 CI and database are running together in the same system.

There is 16GB of memory allocated to the system

Question:

SAP recommends setting INSTANCE MEMORY to a value (versus AUTOMATIC), I assume to prevent the database from hogging memory needed by other processes.

I currently have INSTANCE MEMORY set to AUTOMATIC, since I reckoned DB2 could calculate a setting better than me and I wanted to see what it came up with.

What is a good methodology for determining an optimum setting for INSTANCE MEMORY on AIX?