Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2009
    Posts
    11

    Unanswered: How much memory a application connection takes when it connects to the database ?

    Hi,

    I would like to understand How much memory a application connection takes when it connects to the database ?

    How to calculate it?

    We are running at db2 9.1 FP4 on Sun solaris .

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Agent private memory is allocated dynamically as needed, within the limits specified by instance and database parameters. You can only calculate the maximum amount that could be allocated, not the actual number. Check the manual: Database manager shared memory
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2009
    Posts
    11
    Can you please tell how much an idle connection i.e. "UOW Waiting" takes memory?
    How much memory "Connect Completed" status takes?


    Thanks
    Surbhi

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Use application snapshots and/or db2mtrk to see actual memory usage for existing connections.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Oct 2007
    Posts
    246
    an agent consumes 8 mb of memory, kindly correct me on this
    regds
    Paul

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Mathew_paul View Post
    an agent consumes 8 mb of memory
    Why 8? You sure it's not 16? Or 16.25?
    ---
    "It does not work" is not a valid problem statement.

  7. #7
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

    Wink

    Quote Originally Posted by n_i View Post
    Why 8? You sure it's not 16? Or 16.25?
    NONSENCE! Everyone knows it is 42 (Phrases from The Hitchhiker's Guide to the Galaxy - Wikipedia, the free encyclopedia)

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Maybe this is where Mathew_paul got 8M from:
    "...each idle agent can retain up to 8MB of its private memory"

    The DB2 UDB memory model

  9. #9
    Join Date
    Oct 2007
    Posts
    246
    yes bella ur correct, apart from private memory it also use shared memory of db
    so does it means it consumes more memory apart from 8 MB , and as the statements say the idle agent consumes 8 MB , wht abt the agent which is not idle
    redgs
    Paul

  10. #10
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Mathew_paul View Post
    yes bella ur correct, apart from private memory it also use shared memory of db
    so does it means it consumes more memory apart from 8 MB , and as the statements say the idle agent consumes 8 MB , wht abt the agent which is not idle
    redgs
    Paul
    As already noted above, db2mtrk will tell you how much memory each agent is using. I don't understand what all this speculaiton is about.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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