Hi,

My problem is usuage of memory. All 16GB memory is used and the database is becoming slow. Our environment is

$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v8.1.0.89", "OD_14086", "U800790_14086", and
FixPak "9".
Product is installed at "/opt/IBM/db2/V8.1".

$ db2licm -l
Product Name = "DB2 Enterprise Server Edition"
Product Identifier = "DB2ESE"
Version Information = "8.2"
Expiry Date = "Permanent"
Registered Connect User Policy = "Disabled"
Number Of Entitled Connect Users = "5"
Enforcement Policy = "Soft Stop"
Number of processors = "8"
Number of licensed processors = "8"
Database partitioning feature = "Not entitled"
Annotation = ""
Other information = ""

Product Name = "DB2 High Availability Disaster Recovery Option"
Product Identifier = "DB2HADR"
Version Information = "8.2"
Expiry Date = "Permanent"
Annotation = ""
Other information = ""

Product Name = "DB2 Advanced Security Option"
Product Identifier = "DB2ASO"
Version Information = "8.2"
Expiry Date = "Permanent"
Annotation = ""
Other information = ""

Also, please find the memory status of our production server in the attached ppt.

Looked at the attached document - "good vs. bad" - that is what I call data-intensive analysis!! High memory allocation means nothing UNLESS you are paging to disk, which is probably the case here. Look at page-ins and page-outs on vmstat (and stop using these blinking lights "tools", really). Look at memory allocation by process in ps. If it is really DB2 that is at fault - not a surprise - there still were a few memory leaks in early fixpaks of V8. V9.1 and 9.5 are somewhat cleaner. Migrate by 30 April - end of support.

A 32-bit instance on AIX (it's AIX, correct?) can't possibly use 16 GB, so your assumption is incorrect. Your "ppt" shows CPU utilization, not memory.

In addition to what db2dummy1 said, you can try db2mtrk and db2pd -mempools to see the actual memory usage by DB2.

i hope db2 64 bit migration will solve the problem....

since we have memory restriction in 32bit