IBM's flagship relational database management system


Postby Rubi_20 » Fri Oct 30, 2020 12:57 pm

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

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
Posts: 1
Joined: Fri Oct 30, 2020 12:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Db2Memory

Postby NicC » Fri Oct 30, 2020 3:32 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Return to DB2