Max size of a db2agent

Posted on 2006-04-26
Medium Priority
Last Modified: 2008-01-09
Hi ...
I have a quick question that I cannot find the answer to ...

What is the max amount of memory that can be allocated to a db2agent? What I've found so far is that the amount of memory allocated to each agent depends on what that agent is doing. It allocates memory as required.

Can someone shed some light on this for me?

Bill LeBlanc
Question by:billyleblanc
  • 2
LVL 46

Expert Comment

by:Kent Olsen
ID: 16543661
Hi billyleblanc,

The're a pretty good, but long, description of DB2 memory management here:


The bottom line is that on a 32-bit system, ALL of the db2agent's memory must fit within 4GB or 2GB depending on the underlying platform (Some systems use 32-bit addressing, others use 31-bit).  So the Agent has 4GB/2GB to map to the three major shared memories and the rest for its private memory.  Here are the memory groups

    * Instance shared memory
    * Database shared memory
    * Application group shared memory
    * Agent private memory

Good Luck!

Expert Comment

ID: 16543997

For Version 82/8.1, see here: http://publib.boulder.ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/admin/r0000265.htm

In DB2 version 9.1 (still in Beta, due summer 2006), DB2 can be configured to allocate memory as required (depending on system memory available).


Author Comment

ID: 16544074
Thanks for the reply ... what about for 64 bit system?
LVL 46

Accepted Solution

Kent Olsen earned 900 total points
ID: 16544151
Hi billyleblanc,

There is a theoretical limit of 2^64, but no system has yet been built with that much memory.  :)  For practical purposes you can safely consider it "unlimited".


Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Integration Management Part 2
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question