Page 1 of 1

Db2Memory

PostPosted: Fri Oct 30, 2020 12:57 pm
by Rubi_20
Hello everybody
please help me understand DB2 memory

We have DB2 11.1 (Db2 and one SAP Application Server on one host) and get an error message that DB2 memory is critical.
What can be improved in the DB2 parameter configuration?

physical RAM for VM is 32 GB

PHYS_MEMSIZE 22937 MB
Global instance memory (% or 4KB) (INSTANCE_MEMORY) = 2250000
Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(2033528)
Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(40000)
Self tuning memory (SELF_TUNING_MEM) = ON

Many Thanks

Re: Db2Memory

PostPosted: Fri Oct 30, 2020 3:32 pm
by NicC
The first place to visit would be your DB2 DBA. If your job is inefficient he may be able to tell you, if DB2 parameters need to be altered he is the one that will be doing it.