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?