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 1416GB 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.
Topic
This topic has been locked.
3 replies
Latest Post
 20121214T02:32:23Z by bluey01
ACCEPTED ANSWER
Pinned topic Memory usage in 9.5 on Windows 2008
20121206T17:01:29Z

Answered question
This question has been answered.
Unanswered question
This question has not been answered yet.
Updated on 20121214T02:32:23Z at 20121214T02:32:23Z by bluey01

ACCEPTED ANSWER
Re: Memory usage in 9.5 on Windows 2008
20121206T18:52:50Z in response to SystemAdminFrom 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 
ACCEPTED ANSWER
Re: Memory usage in 9.5 on Windows 2008
20121211T14:36:39Z in response to SystemAdminRight 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
ACCEPTED ANSWER
Re: Memory usage in 9.5 on Windows 2008
20121214T02:32:23Z in response to SystemAdminI 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.
