Max size of a db2agent

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?

Thanks!!
Bill LeBlanc
billyleblancAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kent OlsenData Warehouse Architect / DBACommented:
Hi billyleblanc,

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

  http://search400.techtarget.com/tip/1,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!
Kent
0
sachinwadhwaCommented:

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).

0
billyleblancAuthor Commented:
Thanks for the reply ... what about for 64 bit system?
0
Kent OlsenData Warehouse Architect / DBACommented:
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".


Kent
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.