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

surbhi_gt1 · #1 (**permalink**) 03-17-10, 10:57

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

n_i · #2 (**permalink**) 03-17-10, 11:18

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

surbhi_gt1 · #3 (**permalink**) 03-17-10, 12:54

Can you please tell how much an idle connection i.e. "UOW Waiting" takes memory?
How much memory "Connect Completed" status takes?

Thanks
Surbhi

n_i · #4 (**permalink**) 03-17-10, 14:51

Use application snapshots and/or db2mtrk to see actual memory usage for existing connections.

Mathew_paul · #5 (**permalink**) 03-19-10, 03:03

an agent consumes 8 mb of memory, kindly correct me on this
regds
Paul

n_i · #6 (**permalink**) 03-19-10, 08:34

Quote:

Originally Posted by Mathew_paul

an agent consumes 8 mb of memory

Why 8? You sure it's not 16? Or 16.25?

dr_te_z · #7 (**permalink**) 03-19-10, 09:04

Quote:

Originally Posted by n_i

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)

db2girl · #8 (**permalink**) 03-20-10, 00:48

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

Mathew_paul · #9 (**permalink**) 03-20-10, 04:19

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

Marcus_A · #10 (**permalink**) 03-20-10, 10:45

Quote:

Originally Posted by Mathew_paul

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech