Topic
  • 3 replies
  • Latest Post - ‏2012-12-14T02:32:23Z by bluey01
SystemAdmin
SystemAdmin
17917 Posts

Pinned topic Memory usage in 9.5 on Windows 2008

‏2012-12-06T17:01:29Z |
Please can someone help me, I'm at my wits end!

My DB2 skills are best described as basic and I need to find out about the memory usage on a server I 'manage'

It's a Windows 2008 R2 server with 16GB of installed memory and consistently the memory usage in Windows task manager is at the upper 14-16GB mark.

But how can I 'prove' that DB2 is using all the memory and how do I justify purchasing more memory for the server to improve DB2 performance?

Any help will be much appreciated.
Updated on 2012-12-14T02:32:23Z at 2012-12-14T02:32:23Z by bluey01
  • nivanov1
    nivanov1
    231 Posts

    Re: Memory usage in 9.5 on Windows 2008

    ‏2012-12-06T18:52:50Z  
    From the Windows point of view DB2 is just a single process, so you can easily see how much memory is allocated to it in the task manager.

    You can check how that memory is used by DB2 internally by issuing one of these commands from the DB2 command line:

    db2mtrk -i -d -p

    or

    db2pd -alldbs -inst -memsets
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: Memory usage in 9.5 on Windows 2008

    ‏2012-12-11T14:36:39Z  
    Right now the confusion sets in, the server is a virtual server (VMWare) and according to the Windows task manager the DB2 application is using 13GB.

    However our VMWare administrator is telling me that the server (the Windows server) never uses more than 46% of the total allocated memory, and adding any more memory would be a waste of time.

    results from a couple of memory usage DB2 commands are;
    Tracking Memory on: 2012/12/11 at 10:32:06

    Memory for instance

    other fcmbp monh
    18.8M 832.0K 576.0K

    Memory for database: QUARTZSE

    utilh pckcacheh other catcacheh bph (1) bph (S32K)
    64.0K 1.8M 192.0K 576.0K 1.3M 832.0K

    bph (S16K) bph (S8K) bph (S4K) lockh dbh apph (1216)
    576.0K 448.0K 384.0K 384.0K 21.0M 64.0K

    apph (60430)apph (39075)apph (36259)apph (23878)apph (16) apph (15)
    64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

    apph (14) apph (13) appshrh
    64.0K 64.0K 1.2M

    Memory for database: BASE

    utilh pckcacheh other catcacheh bph (11) bph (10)
    8.9M 101.4M 192.0K 2.8M 955.3M 81.7M

    bph (9) bph (8) bph (7) bph (6) bph (5) bph (4)
    79.2M 64.0M 2.5G 2.7G 3.7G 1.5G

    bph (3) bph (2) bph (1) bph (S32K) bph (S16K) bph (S8K)
    798.5M 1.0G 4.4M 832.0K 576.0K 448.0K

    bph (S4K) lockh dbh apph (4054) apph (4056) apph (4053)
    384.0K 67.8M 30.7M 64.0K 64.0K 64.0K

    apph (4052) apph (4051) apph (4050) apph (4049) apph (4045) apph (4033)
    128.0K 128.0K 128.0K 64.0K 64.0K 64.0K

    apph (4031) apph (4030) apph (4029) apph (4028) apph (4027) apph (4026)
    128.0K 64.0K 128.0K 64.0K 128.0K 128.0K

    apph (4025) apph (4013) apph (4012) apph (4011) apph (4010) apph (4009)
    192.0K 192.0K 128.0K 128.0K 128.0K 64.0K

    apph (3985) apph (3973) apph (3974) apph (3972) apph (3971) apph (3951)
    192.0K 192.0K 128.0K 192.0K 128.0K 128.0K

    apph (3939) apph (3937) apph (3929) apph (3926) apph (3925) apph (3917)
    192.0K 192.0K 192.0K 128.0K 128.0K 128.0K

    apph (3913) apph (3916) apph (3915) apph (3907) apph (3895) apph (3878)
    192.0K 128.0K 192.0K 192.0K 192.0K 128.0K

    apph (3873) apph (3872) apph (3860) apph (3855) apph (3817) apph (3812)
    192.0K 192.0K 128.0K 128.0K 64.0K 192.0K

    apph (3755) apph (3750) apph (3664) apph (3426) apph (3043) apph (64895)
    128.0K 192.0K 192.0K 64.0K 192.0K 64.0K

    apph (44074)apph (44073)apph (43963)apph (38) apph (37) apph (36)
    64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

    apph (35) appshrh
    64.0K 14.6M

    Memory for agent 5916

    other
    320.0K

    Memory for agent 4564

    other
    512.0K

    Memory for agent 4632

    other
    384.0K

    Memory for agent 6900

    other
    192.0K

    Memory for agent 6664

    other
    384.0K

    Memory for agent 4792

    other
    384.0K

    Memory for agent 6612

    other
    640.0K

    Memory for agent 4128

    other
    192.0K

    Memory for agent 6216

    other
    192.0K

    Memory for agent 4920

    No memory allocated

    Memory for agent 4920

    sorth sorth sorth sorth sorth other
    2.6M 128.0K 128.0K 704.0K 128.0K 512.0K

    Memory for agent 5408

    other
    512.0K

    Memory for agent 5672

    other
    704.0K

    Memory for agent 2040

    No memory allocated

    Memory for agent 2040

    sorth sorth other
    768.0K 128.0K 704.0K

    Memory for agent 6072

    other
    768.0K

    Memory for agent 5104

    No memory allocated

    Memory for agent 5104

    sorth sorth sorth sorth sorth other
    2.6M 128.0K 128.0K 704.0K 128.0K 256.0K

    Memory for agent 7400

    No memory allocated

    Memory for agent 7400

    sorth sorth sorth other
    66.2M 384.0K 128.0K 576.0K

    Memory for agent 4692

    other
    768.0K

    Memory for agent 908

    other
    1.5M

    Memory for agent 3544

    No memory allocated

    Memory for agent 3544

    sorth sorth sorth sorth sorth other
    2.3M 128.0K 128.0K 704.0K 128.0K 640.0K

    Memory for agent 7464

    No memory allocated

    Memory for agent 7464

    sorth sorth sorth sorth sorth other
    2.4M 128.0K 128.0K 704.0K 128.0K 832.0K

    Memory for agent 3968

    other
    192.0K

    Memory for agent 2780

    other
    704.0K

    Memory for agent 7532

    other
    640.0K

    Memory for agent 8200

    other
    64.0K

    Memory for agent 3672

    other
    1.4M

    Memory for agent 6020

    other
    640.0K

    Memory for agent 6200

    No memory allocated

    Memory for agent 6200

    sorth sorth sorth sorth sorth other
    2.6M 128.0K 128.0K 704.0K 128.0K 640.0K

    Memory for agent 3484

    No memory allocated

    Memory for agent 3484

    sorth sorth sorth other
    65.9M 384.0K 128.0K 576.0K

    Memory for agent 7016

    No memory allocated

    Memory for agent 7016

    sorth sorth sorth sorth other
    3.2M 384.0K 128.0K 384.0K 640.0K

    Memory for agent 4392

    other
    1.3M

    Memory for agent 8020

    other
    576.0K

    Memory for agent 4100

    No memory allocated

    Memory for agent 4100

    sorth sorth sorth sorth other
    2.4M 384.0K 128.0K 384.0K 704.0K

    Memory for agent 5920

    other
    768.0K

    Memory for agent 1772

    other
    192.0K

    Memory for agent 3048

    other
    640.0K

    Memory for agent 1448

    other
    576.0K

    Memory for agent 5572

    other
    704.0K

    Memory for agent 352

    other
    384.0K

    Memory for agent 5868

    other
    640.0K

    Memory for agent 6772

    No memory allocated

    Memory for agent 6772

    sorth sorth sorth other
    43.9M 512.0K 128.0K 640.0K

    Memory for agent 3424

    other
    640.0K

    Memory for agent 8152

    other
    704.0K

    Memory for agent 1088

    other
    320.0K

    Memory for agent 1836

    other
    192.0K

    Memory for agent 1444

    other
    768.0K

    Memory for agent 10132

    other
    192.0K

    Memory for agent 816

    No memory allocated

    Memory for agent 816

    sorth sorth sorth other
    576.0K 128.0K 704.0K 704.0K

    Memory for agent 4164

    No memory allocated

    Memory for agent 4164

    sorth sorth other
    896.0K 128.0K 704.0K

    Memory for agent 5284

    other
    576.0K

    Memory for agent 5788

    other
    1.3M

    Memory for agent 6668

    other
    384.0K

    Memory for agent 6904

    other
    704.0K

    Memory for agent 4472

    other
    320.0K

    Memory for agent 7764

    other
    640.0K

    Memory for agent 6204

    other
    448.0K

    Memory for agent 9240

    other
    640.0K

    Memory for agent 4276

    No memory allocated

    Memory for agent 4276

    sorth sorth sorth other
    160.0M 1.1M 128.0K 576.0K

    Memory for agent 4972

    other
    384.0K

    Memory for agent 7952

    other
    576.0K

    Memory for agent 6756

    other
    576.0K

    Memory for agent 6272

    other
    576.0K

    Memory for agent 5504

    No memory allocated

    Memory for agent 5504

    sorth sorth sorth other
    56.3M 384.0K 128.0K 448.0K

    Memory for agent 7816

    other
    320.0K

    Memory for agent 7092

    other
    576.0K

    Memory for agent 2172

    No memory allocated

    Memory for agent 2172

    sorth sorth sorth sorth other
    4.6M 384.0K 128.0K 384.0K 704.0K

    Memory for agent 3196

    other
    384.0K

    Memory for agent 9732

    other
    512.0K

    Memory for agent 4248

    No memory allocated

    Memory for agent 4248

    sorth sorth other
    768.0K 128.0K 704.0K
    and

    Tracking Memory on: 2012/12/11 at 10:34:59

    Memory for instance

    Other Memory is of size 19726336 bytes
    FCMBP Heap is of size 851968 bytes
    Database Monitor Heap is of size 589824 bytes
    Total: 21168128 bytes

    Memory for database: QUARTZSE

    Backup/Restore/Util Heap is of size 65536 bytes
    Package Cache is of size 1835008 bytes
    Other Memory is of size 196608 bytes
    Catalog Cache Heap is of size 589824 bytes
    Buffer Pool Heap (1) is of size 1376256 bytes
    Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes
    Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes
    Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes
    Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes
    Lock Manager Heap is of size 393216 bytes
    Database Heap is of size 22020096 bytes
    Application Heap (1216) is of size 65536 bytes
    Application Heap (60430) is of size 65536 bytes
    Application Heap (39075) is of size 65536 bytes
    Application Heap (36259) is of size 65536 bytes
    Application Heap (23878) is of size 65536 bytes
    Application Heap (16) is of size 65536 bytes
    Application Heap (15) is of size 65536 bytes
    Application Heap (14) is of size 65536 bytes
    Application Heap (13) is of size 65536 bytes
    Applications Shared Heap is of size 1245184 bytes
    Total: 30605312 bytes

    Memory for database: BASE

    Backup/Restore/Util Heap is of size 9371648 bytes
    Package Cache is of size 104660992 bytes
    Other Memory is of size 196608 bytes
    Catalog Cache Heap is of size 2883584 bytes
    Buffer Pool Heap (11) is of size 1001717760 bytes
    Buffer Pool Heap (10) is of size 85655552 bytes
    Buffer Pool Heap (9) is of size 83034112 bytes
    Buffer Pool Heap (8) is of size 67108864 bytes
    Buffer Pool Heap (7) is of size 2636316672 bytes
    Buffer Pool Heap (6) is of size 2929852416 bytes
    Buffer Pool Heap (5) is of size 3954442240 bytes
    Buffer Pool Heap (4) is of size 1590296576 bytes
    Buffer Pool Heap (3) is of size 837287936 bytes
    Buffer Pool Heap (2) is of size 1095892992 bytes
    Buffer Pool Heap (1) is of size 4587520 bytes
    Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes
    Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes
    Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes
    Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes
    Lock Manager Heap is of size 71106560 bytes
    Database Heap is of size 32178176 bytes
    Application Heap (4060) is of size 65536 bytes
    Application Heap (4059) is of size 65536 bytes
    Application Heap (4054) is of size 65536 bytes
    Application Heap (4056) is of size 65536 bytes
    Application Heap (4053) is of size 65536 bytes
    Application Heap (4052) is of size 131072 bytes
    Application Heap (4051) is of size 131072 bytes
    Application Heap (4050) is of size 131072 bytes
    Application Heap (4049) is of size 131072 bytes
    Application Heap (4045) is of size 131072 bytes
    Application Heap (4033) is of size 131072 bytes
    Application Heap (4031) is of size 131072 bytes
    Application Heap (4030) is of size 131072 bytes
    Application Heap (4029) is of size 131072 bytes
    Application Heap (4028) is of size 131072 bytes
    Application Heap (4027) is of size 131072 bytes
    Application Heap (4026) is of size 131072 bytes
    Application Heap (4025) is of size 196608 bytes
    Application Heap (4013) is of size 196608 bytes
    Application Heap (4012) is of size 131072 bytes
    Application Heap (4011) is of size 131072 bytes
    Application Heap (4010) is of size 131072 bytes
    Application Heap (4009) is of size 196608 bytes
    Application Heap (3985) is of size 196608 bytes
    Application Heap (3973) is of size 196608 bytes
    Application Heap (3974) is of size 131072 bytes
    Application Heap (3972) is of size 196608 bytes
    Application Heap (3971) is of size 131072 bytes
    Application Heap (3951) is of size 131072 bytes
    Application Heap (3939) is of size 196608 bytes
    Application Heap (3937) is of size 196608 bytes
    Application Heap (3929) is of size 196608 bytes
    Application Heap (3925) is of size 131072 bytes
    Application Heap (3913) is of size 196608 bytes
    Application Heap (3916) is of size 131072 bytes
    Application Heap (3915) is of size 196608 bytes
    Application Heap (3907) is of size 196608 bytes
    Application Heap (3895) is of size 196608 bytes
    Application Heap (3878) is of size 131072 bytes
    Application Heap (3872) is of size 196608 bytes
    Application Heap (3860) is of size 131072 bytes
    Application Heap (3855) is of size 131072 bytes
    Application Heap (3817) is of size 65536 bytes
    Application Heap (3812) is of size 131072 bytes
    Application Heap (3755) is of size 131072 bytes
    Application Heap (3750) is of size 196608 bytes
    Application Heap (3664) is of size 196608 bytes
    Application Heap (3426) is of size 65536 bytes
    Application Heap (3043) is of size 196608 bytes
    Application Heap (64895) is of size 65536 bytes
    Application Heap (44074) is of size 65536 bytes
    Application Heap (44073) is of size 65536 bytes
    Application Heap (43963) is of size 65536 bytes
    Application Heap (38) is of size 65536 bytes
    Application Heap (37) is of size 65536 bytes
    Application Heap (36) is of size 65536 bytes
    Application Heap (35) is of size 65536 bytes
    Applications Shared Heap is of size 15335424 bytes
    Total: 14531821568 bytes

    Application Memory for database: QUARTZSE

    Applications Shared Heap is of size 1245184 bytes
    Total: 1245184 bytes

    Memory for application 13

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 1216

    Application Heap is of size 65536 bytes
    Other Memory is of size 524288 bytes
    Total: 589824 bytes

    Memory for application 23878

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 16

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 39075

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 36259

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 60430

    Application Heap is of size 65536 bytes
    Other Memory is of size 655360 bytes
    Total: 720896 bytes

    Memory for application 15

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 14

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Total: 5111808 bytes

    Application Memory for database: BASE

    Applications Shared Heap is of size 15335424 bytes
    Total: 15335424 bytes

    Memory for application 4013

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2686976 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 524288 bytes
    Total: 4521984 bytes

    Memory for application 4059

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 3855

    Application Heap is of size 131072 bytes
    Other Memory is of size 524288 bytes
    Total: 655360 bytes

    Memory for application 4026

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 3664

    Application Heap is of size 196608 bytes
    Sort Heap is of size 786432 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 1835008 bytes

    Memory for application 4052

    Application Heap is of size 131072 bytes
    Other Memory is of size 786432 bytes
    Total: 917504 bytes

    Memory for application 3973

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2686976 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 262144 bytes
    Total: 4259840 bytes

    Memory for application 3907

    Application Heap is of size 196608 bytes
    Sort Heap is of size 69402624 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 70713344 bytes

    Memory for application 4045

    Application Heap is of size 131072 bytes
    Other Memory is of size 917504 bytes
    Total: 1048576 bytes

    Memory for application 4012

    Application Heap is of size 131072 bytes
    Other Memory is of size 1572864 bytes
    Total: 1703936 bytes

    Memory for application 4025

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2424832 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 4390912 bytes

    Memory for application 3913

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2555904 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 851968 bytes
    Total: 4718592 bytes

    Memory for application 38

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 3755

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 3426

    Application Heap is of size 65536 bytes
    Other Memory is of size 655360 bytes
    Other Memory is of size 65536 bytes
    Total: 786432 bytes

    Memory for application 4051

    Application Heap is of size 131072 bytes
    Other Memory is of size 1441792 bytes
    Total: 1572864 bytes

    Memory for application 3972

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2686976 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 4653056 bytes

    Memory for application 3939

    Application Heap is of size 196608 bytes
    Sort Heap is of size 69140480 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 70451200 bytes

    Memory for application 3985

    Application Heap is of size 196608 bytes
    Sort Heap is of size 4784128 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 393216 bytes
    Other Memory is of size 655360 bytes
    Total: 6553600 bytes

    Memory for application 3860

    Application Heap is of size 131072 bytes
    Other Memory is of size 1310720 bytes
    Total: 1441792 bytes

    Memory for application 4031

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 4011

    Application Heap is of size 131072 bytes
    Other Memory is of size 786432 bytes
    Total: 917504 bytes

    Memory for application 37

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 4050

    Application Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 786432 bytes

    Memory for application 3925

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 3971

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 4030

    Application Heap is of size 131072 bytes
    Sort Heap is of size 65536 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 983040 bytes

    Memory for application 3951

    Application Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 786432 bytes

    Memory for application 3872

    Application Heap is of size 196608 bytes
    Sort Heap is of size 46006272 bytes
    Sort Heap is of size 524288 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 47513600 bytes

    Memory for application 3043

    Application Heap is of size 196608 bytes
    Other Memory is of size 655360 bytes
    Total: 851968 bytes

    Memory for application 4010

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 4056

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 36

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 3878

    Application Heap is of size 131072 bytes
    Other Memory is of size 786432 bytes
    Total: 917504 bytes

    Memory for application 4049

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 3937

    Application Heap is of size 196608 bytes
    Sort Heap is of size 1179648 bytes
    Sort Heap is of size 589824 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Other Memory is of size 720896 bytes
    Total: 3538944 bytes

    Memory for application 3812

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 4029

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 43963

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 4009

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2359296 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 4390912 bytes

    Memory for application 35

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 4028

    Application Heap is of size 131072 bytes
    Sort Heap is of size 458752 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 1376256 bytes

    Memory for application 44074

    Application Heap is of size 65536 bytes
    Other Memory is of size 458752 bytes
    Total: 524288 bytes

    Memory for application 3916

    Application Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 786432 bytes

    Memory for application 3929

    Application Heap is of size 196608 bytes
    Sort Heap is of size 167772160 bytes
    Sort Heap is of size 1114112 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 169803776 bytes

    Memory for application 4054

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 3817

    Application Heap is of size 65536 bytes
    Other Memory is of size 589824 bytes
    Total: 655360 bytes

    Memory for application 4060

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 4027

    Application Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 1245184 bytes

    Memory for application 44073

    Application Heap is of size 65536 bytes
    Other Memory is of size 589824 bytes
    Total: 655360 bytes

    Memory for application 3915

    Application Heap is of size 196608 bytes
    Sort Heap is of size 58982400 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 458752 bytes
    Total: 60162048 bytes

    Memory for application 4053

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 3974

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 3895

    Application Heap is of size 196608 bytes
    Sort Heap is of size 5308416 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 393216 bytes
    Other Memory is of size 720896 bytes
    Total: 7143424 bytes

    Memory for application 64895

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 4033

    Application Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 786432 bytes

    Memory for application 3750

    Application Heap is of size 196608 bytes
    Sort Heap is of size 786432 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 1835008 bytes

    Total: 513212416 bytes
  • bluey01
    bluey01
    50 Posts

    Re: Memory usage in 9.5 on Windows 2008

    ‏2012-12-14T02:32:23Z  
    Right now the confusion sets in, the server is a virtual server (VMWare) and according to the Windows task manager the DB2 application is using 13GB.

    However our VMWare administrator is telling me that the server (the Windows server) never uses more than 46% of the total allocated memory, and adding any more memory would be a waste of time.

    results from a couple of memory usage DB2 commands are;
    Tracking Memory on: 2012/12/11 at 10:32:06

    Memory for instance

    other fcmbp monh
    18.8M 832.0K 576.0K

    Memory for database: QUARTZSE

    utilh pckcacheh other catcacheh bph (1) bph (S32K)
    64.0K 1.8M 192.0K 576.0K 1.3M 832.0K

    bph (S16K) bph (S8K) bph (S4K) lockh dbh apph (1216)
    576.0K 448.0K 384.0K 384.0K 21.0M 64.0K

    apph (60430)apph (39075)apph (36259)apph (23878)apph (16) apph (15)
    64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

    apph (14) apph (13) appshrh
    64.0K 64.0K 1.2M

    Memory for database: BASE

    utilh pckcacheh other catcacheh bph (11) bph (10)
    8.9M 101.4M 192.0K 2.8M 955.3M 81.7M

    bph (9) bph (8) bph (7) bph (6) bph (5) bph (4)
    79.2M 64.0M 2.5G 2.7G 3.7G 1.5G

    bph (3) bph (2) bph (1) bph (S32K) bph (S16K) bph (S8K)
    798.5M 1.0G 4.4M 832.0K 576.0K 448.0K

    bph (S4K) lockh dbh apph (4054) apph (4056) apph (4053)
    384.0K 67.8M 30.7M 64.0K 64.0K 64.0K

    apph (4052) apph (4051) apph (4050) apph (4049) apph (4045) apph (4033)
    128.0K 128.0K 128.0K 64.0K 64.0K 64.0K

    apph (4031) apph (4030) apph (4029) apph (4028) apph (4027) apph (4026)
    128.0K 64.0K 128.0K 64.0K 128.0K 128.0K

    apph (4025) apph (4013) apph (4012) apph (4011) apph (4010) apph (4009)
    192.0K 192.0K 128.0K 128.0K 128.0K 64.0K

    apph (3985) apph (3973) apph (3974) apph (3972) apph (3971) apph (3951)
    192.0K 192.0K 128.0K 192.0K 128.0K 128.0K

    apph (3939) apph (3937) apph (3929) apph (3926) apph (3925) apph (3917)
    192.0K 192.0K 192.0K 128.0K 128.0K 128.0K

    apph (3913) apph (3916) apph (3915) apph (3907) apph (3895) apph (3878)
    192.0K 128.0K 192.0K 192.0K 192.0K 128.0K

    apph (3873) apph (3872) apph (3860) apph (3855) apph (3817) apph (3812)
    192.0K 192.0K 128.0K 128.0K 64.0K 192.0K

    apph (3755) apph (3750) apph (3664) apph (3426) apph (3043) apph (64895)
    128.0K 192.0K 192.0K 64.0K 192.0K 64.0K

    apph (44074)apph (44073)apph (43963)apph (38) apph (37) apph (36)
    64.0K 64.0K 64.0K 64.0K 64.0K 64.0K

    apph (35) appshrh
    64.0K 14.6M

    Memory for agent 5916

    other
    320.0K

    Memory for agent 4564

    other
    512.0K

    Memory for agent 4632

    other
    384.0K

    Memory for agent 6900

    other
    192.0K

    Memory for agent 6664

    other
    384.0K

    Memory for agent 4792

    other
    384.0K

    Memory for agent 6612

    other
    640.0K

    Memory for agent 4128

    other
    192.0K

    Memory for agent 6216

    other
    192.0K

    Memory for agent 4920

    No memory allocated

    Memory for agent 4920

    sorth sorth sorth sorth sorth other
    2.6M 128.0K 128.0K 704.0K 128.0K 512.0K

    Memory for agent 5408

    other
    512.0K

    Memory for agent 5672

    other
    704.0K

    Memory for agent 2040

    No memory allocated

    Memory for agent 2040

    sorth sorth other
    768.0K 128.0K 704.0K

    Memory for agent 6072

    other
    768.0K

    Memory for agent 5104

    No memory allocated

    Memory for agent 5104

    sorth sorth sorth sorth sorth other
    2.6M 128.0K 128.0K 704.0K 128.0K 256.0K

    Memory for agent 7400

    No memory allocated

    Memory for agent 7400

    sorth sorth sorth other
    66.2M 384.0K 128.0K 576.0K

    Memory for agent 4692

    other
    768.0K

    Memory for agent 908

    other
    1.5M

    Memory for agent 3544

    No memory allocated

    Memory for agent 3544

    sorth sorth sorth sorth sorth other
    2.3M 128.0K 128.0K 704.0K 128.0K 640.0K

    Memory for agent 7464

    No memory allocated

    Memory for agent 7464

    sorth sorth sorth sorth sorth other
    2.4M 128.0K 128.0K 704.0K 128.0K 832.0K

    Memory for agent 3968

    other
    192.0K

    Memory for agent 2780

    other
    704.0K

    Memory for agent 7532

    other
    640.0K

    Memory for agent 8200

    other
    64.0K

    Memory for agent 3672

    other
    1.4M

    Memory for agent 6020

    other
    640.0K

    Memory for agent 6200

    No memory allocated

    Memory for agent 6200

    sorth sorth sorth sorth sorth other
    2.6M 128.0K 128.0K 704.0K 128.0K 640.0K

    Memory for agent 3484

    No memory allocated

    Memory for agent 3484

    sorth sorth sorth other
    65.9M 384.0K 128.0K 576.0K

    Memory for agent 7016

    No memory allocated

    Memory for agent 7016

    sorth sorth sorth sorth other
    3.2M 384.0K 128.0K 384.0K 640.0K

    Memory for agent 4392

    other
    1.3M

    Memory for agent 8020

    other
    576.0K

    Memory for agent 4100

    No memory allocated

    Memory for agent 4100

    sorth sorth sorth sorth other
    2.4M 384.0K 128.0K 384.0K 704.0K

    Memory for agent 5920

    other
    768.0K

    Memory for agent 1772

    other
    192.0K

    Memory for agent 3048

    other
    640.0K

    Memory for agent 1448

    other
    576.0K

    Memory for agent 5572

    other
    704.0K

    Memory for agent 352

    other
    384.0K

    Memory for agent 5868

    other
    640.0K

    Memory for agent 6772

    No memory allocated

    Memory for agent 6772

    sorth sorth sorth other
    43.9M 512.0K 128.0K 640.0K

    Memory for agent 3424

    other
    640.0K

    Memory for agent 8152

    other
    704.0K

    Memory for agent 1088

    other
    320.0K

    Memory for agent 1836

    other
    192.0K

    Memory for agent 1444

    other
    768.0K

    Memory for agent 10132

    other
    192.0K

    Memory for agent 816

    No memory allocated

    Memory for agent 816

    sorth sorth sorth other
    576.0K 128.0K 704.0K 704.0K

    Memory for agent 4164

    No memory allocated

    Memory for agent 4164

    sorth sorth other
    896.0K 128.0K 704.0K

    Memory for agent 5284

    other
    576.0K

    Memory for agent 5788

    other
    1.3M

    Memory for agent 6668

    other
    384.0K

    Memory for agent 6904

    other
    704.0K

    Memory for agent 4472

    other
    320.0K

    Memory for agent 7764

    other
    640.0K

    Memory for agent 6204

    other
    448.0K

    Memory for agent 9240

    other
    640.0K

    Memory for agent 4276

    No memory allocated

    Memory for agent 4276

    sorth sorth sorth other
    160.0M 1.1M 128.0K 576.0K

    Memory for agent 4972

    other
    384.0K

    Memory for agent 7952

    other
    576.0K

    Memory for agent 6756

    other
    576.0K

    Memory for agent 6272

    other
    576.0K

    Memory for agent 5504

    No memory allocated

    Memory for agent 5504

    sorth sorth sorth other
    56.3M 384.0K 128.0K 448.0K

    Memory for agent 7816

    other
    320.0K

    Memory for agent 7092

    other
    576.0K

    Memory for agent 2172

    No memory allocated

    Memory for agent 2172

    sorth sorth sorth sorth other
    4.6M 384.0K 128.0K 384.0K 704.0K

    Memory for agent 3196

    other
    384.0K

    Memory for agent 9732

    other
    512.0K

    Memory for agent 4248

    No memory allocated

    Memory for agent 4248

    sorth sorth other
    768.0K 128.0K 704.0K
    and

    Tracking Memory on: 2012/12/11 at 10:34:59

    Memory for instance

    Other Memory is of size 19726336 bytes
    FCMBP Heap is of size 851968 bytes
    Database Monitor Heap is of size 589824 bytes
    Total: 21168128 bytes

    Memory for database: QUARTZSE

    Backup/Restore/Util Heap is of size 65536 bytes
    Package Cache is of size 1835008 bytes
    Other Memory is of size 196608 bytes
    Catalog Cache Heap is of size 589824 bytes
    Buffer Pool Heap (1) is of size 1376256 bytes
    Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes
    Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes
    Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes
    Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes
    Lock Manager Heap is of size 393216 bytes
    Database Heap is of size 22020096 bytes
    Application Heap (1216) is of size 65536 bytes
    Application Heap (60430) is of size 65536 bytes
    Application Heap (39075) is of size 65536 bytes
    Application Heap (36259) is of size 65536 bytes
    Application Heap (23878) is of size 65536 bytes
    Application Heap (16) is of size 65536 bytes
    Application Heap (15) is of size 65536 bytes
    Application Heap (14) is of size 65536 bytes
    Application Heap (13) is of size 65536 bytes
    Applications Shared Heap is of size 1245184 bytes
    Total: 30605312 bytes

    Memory for database: BASE

    Backup/Restore/Util Heap is of size 9371648 bytes
    Package Cache is of size 104660992 bytes
    Other Memory is of size 196608 bytes
    Catalog Cache Heap is of size 2883584 bytes
    Buffer Pool Heap (11) is of size 1001717760 bytes
    Buffer Pool Heap (10) is of size 85655552 bytes
    Buffer Pool Heap (9) is of size 83034112 bytes
    Buffer Pool Heap (8) is of size 67108864 bytes
    Buffer Pool Heap (7) is of size 2636316672 bytes
    Buffer Pool Heap (6) is of size 2929852416 bytes
    Buffer Pool Heap (5) is of size 3954442240 bytes
    Buffer Pool Heap (4) is of size 1590296576 bytes
    Buffer Pool Heap (3) is of size 837287936 bytes
    Buffer Pool Heap (2) is of size 1095892992 bytes
    Buffer Pool Heap (1) is of size 4587520 bytes
    Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes
    Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes
    Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes
    Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes
    Lock Manager Heap is of size 71106560 bytes
    Database Heap is of size 32178176 bytes
    Application Heap (4060) is of size 65536 bytes
    Application Heap (4059) is of size 65536 bytes
    Application Heap (4054) is of size 65536 bytes
    Application Heap (4056) is of size 65536 bytes
    Application Heap (4053) is of size 65536 bytes
    Application Heap (4052) is of size 131072 bytes
    Application Heap (4051) is of size 131072 bytes
    Application Heap (4050) is of size 131072 bytes
    Application Heap (4049) is of size 131072 bytes
    Application Heap (4045) is of size 131072 bytes
    Application Heap (4033) is of size 131072 bytes
    Application Heap (4031) is of size 131072 bytes
    Application Heap (4030) is of size 131072 bytes
    Application Heap (4029) is of size 131072 bytes
    Application Heap (4028) is of size 131072 bytes
    Application Heap (4027) is of size 131072 bytes
    Application Heap (4026) is of size 131072 bytes
    Application Heap (4025) is of size 196608 bytes
    Application Heap (4013) is of size 196608 bytes
    Application Heap (4012) is of size 131072 bytes
    Application Heap (4011) is of size 131072 bytes
    Application Heap (4010) is of size 131072 bytes
    Application Heap (4009) is of size 196608 bytes
    Application Heap (3985) is of size 196608 bytes
    Application Heap (3973) is of size 196608 bytes
    Application Heap (3974) is of size 131072 bytes
    Application Heap (3972) is of size 196608 bytes
    Application Heap (3971) is of size 131072 bytes
    Application Heap (3951) is of size 131072 bytes
    Application Heap (3939) is of size 196608 bytes
    Application Heap (3937) is of size 196608 bytes
    Application Heap (3929) is of size 196608 bytes
    Application Heap (3925) is of size 131072 bytes
    Application Heap (3913) is of size 196608 bytes
    Application Heap (3916) is of size 131072 bytes
    Application Heap (3915) is of size 196608 bytes
    Application Heap (3907) is of size 196608 bytes
    Application Heap (3895) is of size 196608 bytes
    Application Heap (3878) is of size 131072 bytes
    Application Heap (3872) is of size 196608 bytes
    Application Heap (3860) is of size 131072 bytes
    Application Heap (3855) is of size 131072 bytes
    Application Heap (3817) is of size 65536 bytes
    Application Heap (3812) is of size 131072 bytes
    Application Heap (3755) is of size 131072 bytes
    Application Heap (3750) is of size 196608 bytes
    Application Heap (3664) is of size 196608 bytes
    Application Heap (3426) is of size 65536 bytes
    Application Heap (3043) is of size 196608 bytes
    Application Heap (64895) is of size 65536 bytes
    Application Heap (44074) is of size 65536 bytes
    Application Heap (44073) is of size 65536 bytes
    Application Heap (43963) is of size 65536 bytes
    Application Heap (38) is of size 65536 bytes
    Application Heap (37) is of size 65536 bytes
    Application Heap (36) is of size 65536 bytes
    Application Heap (35) is of size 65536 bytes
    Applications Shared Heap is of size 15335424 bytes
    Total: 14531821568 bytes

    Application Memory for database: QUARTZSE

    Applications Shared Heap is of size 1245184 bytes
    Total: 1245184 bytes

    Memory for application 13

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 1216

    Application Heap is of size 65536 bytes
    Other Memory is of size 524288 bytes
    Total: 589824 bytes

    Memory for application 23878

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 16

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 39075

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 36259

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 60430

    Application Heap is of size 65536 bytes
    Other Memory is of size 655360 bytes
    Total: 720896 bytes

    Memory for application 15

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 14

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Total: 5111808 bytes

    Application Memory for database: BASE

    Applications Shared Heap is of size 15335424 bytes
    Total: 15335424 bytes

    Memory for application 4013

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2686976 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 524288 bytes
    Total: 4521984 bytes

    Memory for application 4059

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 3855

    Application Heap is of size 131072 bytes
    Other Memory is of size 524288 bytes
    Total: 655360 bytes

    Memory for application 4026

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 3664

    Application Heap is of size 196608 bytes
    Sort Heap is of size 786432 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 1835008 bytes

    Memory for application 4052

    Application Heap is of size 131072 bytes
    Other Memory is of size 786432 bytes
    Total: 917504 bytes

    Memory for application 3973

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2686976 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 262144 bytes
    Total: 4259840 bytes

    Memory for application 3907

    Application Heap is of size 196608 bytes
    Sort Heap is of size 69402624 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 70713344 bytes

    Memory for application 4045

    Application Heap is of size 131072 bytes
    Other Memory is of size 917504 bytes
    Total: 1048576 bytes

    Memory for application 4012

    Application Heap is of size 131072 bytes
    Other Memory is of size 1572864 bytes
    Total: 1703936 bytes

    Memory for application 4025

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2424832 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 4390912 bytes

    Memory for application 3913

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2555904 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 851968 bytes
    Total: 4718592 bytes

    Memory for application 38

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 3755

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 3426

    Application Heap is of size 65536 bytes
    Other Memory is of size 655360 bytes
    Other Memory is of size 65536 bytes
    Total: 786432 bytes

    Memory for application 4051

    Application Heap is of size 131072 bytes
    Other Memory is of size 1441792 bytes
    Total: 1572864 bytes

    Memory for application 3972

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2686976 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 4653056 bytes

    Memory for application 3939

    Application Heap is of size 196608 bytes
    Sort Heap is of size 69140480 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 70451200 bytes

    Memory for application 3985

    Application Heap is of size 196608 bytes
    Sort Heap is of size 4784128 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 393216 bytes
    Other Memory is of size 655360 bytes
    Total: 6553600 bytes

    Memory for application 3860

    Application Heap is of size 131072 bytes
    Other Memory is of size 1310720 bytes
    Total: 1441792 bytes

    Memory for application 4031

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 4011

    Application Heap is of size 131072 bytes
    Other Memory is of size 786432 bytes
    Total: 917504 bytes

    Memory for application 37

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 4050

    Application Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 786432 bytes

    Memory for application 3925

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 3971

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 4030

    Application Heap is of size 131072 bytes
    Sort Heap is of size 65536 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 983040 bytes

    Memory for application 3951

    Application Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 786432 bytes

    Memory for application 3872

    Application Heap is of size 196608 bytes
    Sort Heap is of size 46006272 bytes
    Sort Heap is of size 524288 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 47513600 bytes

    Memory for application 3043

    Application Heap is of size 196608 bytes
    Other Memory is of size 655360 bytes
    Total: 851968 bytes

    Memory for application 4010

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 4056

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 36

    Application Heap is of size 65536 bytes
    Other Memory is of size 196608 bytes
    Total: 262144 bytes

    Memory for application 3878

    Application Heap is of size 131072 bytes
    Other Memory is of size 786432 bytes
    Total: 917504 bytes

    Memory for application 4049

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 3937

    Application Heap is of size 196608 bytes
    Sort Heap is of size 1179648 bytes
    Sort Heap is of size 589824 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Other Memory is of size 720896 bytes
    Total: 3538944 bytes

    Memory for application 3812

    Application Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 851968 bytes

    Memory for application 4029

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 43963

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 4009

    Application Heap is of size 196608 bytes
    Sort Heap is of size 2359296 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 720896 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 4390912 bytes

    Memory for application 35

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 4028

    Application Heap is of size 131072 bytes
    Sort Heap is of size 458752 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 1376256 bytes

    Memory for application 44074

    Application Heap is of size 65536 bytes
    Other Memory is of size 458752 bytes
    Total: 524288 bytes

    Memory for application 3916

    Application Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 786432 bytes

    Memory for application 3929

    Application Heap is of size 196608 bytes
    Sort Heap is of size 167772160 bytes
    Sort Heap is of size 1114112 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 169803776 bytes

    Memory for application 4054

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 3817

    Application Heap is of size 65536 bytes
    Other Memory is of size 589824 bytes
    Total: 655360 bytes

    Memory for application 4060

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 4027

    Application Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 1245184 bytes

    Memory for application 44073

    Application Heap is of size 65536 bytes
    Other Memory is of size 589824 bytes
    Total: 655360 bytes

    Memory for application 3915

    Application Heap is of size 196608 bytes
    Sort Heap is of size 58982400 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 458752 bytes
    Total: 60162048 bytes

    Memory for application 4053

    Application Heap is of size 65536 bytes
    Other Memory is of size 327680 bytes
    Total: 393216 bytes

    Memory for application 3974

    Application Heap is of size 131072 bytes
    Other Memory is of size 589824 bytes
    Total: 720896 bytes

    Memory for application 3895

    Application Heap is of size 196608 bytes
    Sort Heap is of size 5308416 bytes
    Sort Heap is of size 393216 bytes
    Sort Heap is of size 131072 bytes
    Sort Heap is of size 393216 bytes
    Other Memory is of size 720896 bytes
    Total: 7143424 bytes

    Memory for application 64895

    Application Heap is of size 65536 bytes
    Other Memory is of size 393216 bytes
    Total: 458752 bytes

    Memory for application 4033

    Application Heap is of size 131072 bytes
    Other Memory is of size 655360 bytes
    Total: 786432 bytes

    Memory for application 3750

    Application Heap is of size 196608 bytes
    Sort Heap is of size 786432 bytes
    Sort Heap is of size 131072 bytes
    Other Memory is of size 720896 bytes
    Total: 1835008 bytes

    Total: 513212416 bytes
    I have seen similar isue with how memory is reported with VMWare and windows (and also linux).

    Firstly, as its a virtual server, you could always ask the VM admin to give you more memory on temporary basis to see if this solves the problem. Then if need be buy the memory if its fixes the issue.

    What version of DB2 (ESE, WSE etc) are you using as some of these have DB2 memory limitations and this may be your issue.