How to calculate total memory assigned to instance?

winnersparadise · #1 (**permalink**) 04-16-07, 13:48

Hello Everybody,

We are on db2 8.1.4 on solaris 9. Can anybody tell me how to calculate total memory assigned to a particular instance.

thanks in advance and appreciate ur precious responses.

rahul_s80 · #2 (**permalink**) 04-17-07, 01:01

you can look for db2mtrk tool to get memory status

winnersparadise · #3 (**permalink**) 04-17-07, 13:24

thanks for the response..

i did the following

db2mtrk -i -p -w -d -v

but is there any other way to find out.

rahul_s80 · #4 (**permalink**) 04-18-07, 01:24

Instance_memory is sum of
mon_heap_sz + Audit_buffer_sz +FCM_NUM_BUFFERS+ Approx. 10% overhead

you can see all the values set from
get dbm cfg show detail

Internet Services

Web Development

Digital Marketing

Consumer Tech