Db2Memory



IBM's flagship relational database management system

Db2Memory

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

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

Re: Db2Memory

 

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.
Regards
Nic
NicC
Global moderator
 
Posts: 3018
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