Max size of a db2agent

Posted on 2006-04-26
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
    LVL 45

    Expert Comment

    Hi billyleblanc,

    The're a pretty good, but long, description of DB2 memory management here:,289483,sid3_gci1072314,00.html

    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!
    LVL 7

    Expert Comment


    For Version 82/8.1, see here:

    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

    Thanks for the reply ... what about for 64 bit system?
    LVL 45

    Accepted Solution

    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

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    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…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now