Results 1 to 4 of 4

Thread: memory usage

  1. #1
    Join Date
    Feb 2009
    Posts
    11

    Unanswered:

    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.
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2009
    Posts
    114
    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.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by sholan

    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"

    ...


    Also, please find the memory status of our production server in the attached ppt.
    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.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Jan 2009
    Posts
    8
    i hope db2 64 bit migration will solve the problem....

    since we have memory restriction in 32bit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •