Which is the reliable/trusted/suggested method to calculate the memory utilization by a DB2 Instance (assuming there is just one instance of DB2 on a server) ?
Env : DB2 V8.2 / AIX 5.3
Option 1: Using db2mtrk
MEMORY=`db2mtrk -i -d -p -v | grep Total | awk '{ print $2 }'`
TOTAL_MEMORY=0
for i in `echo $MEMORY`
do
TOTAL_MEMORY=`expr $TOTAL_MEMORY + $i`
done
Option 2: Using ps as instance owner.
DB2_MEM_LIST=$( ps gux | grep db2 | awk '{ print $6 }' | tr '\012' ' ' )
DB2MEM=0
for db2_mem in $DB2_MEM_LIST
do
(( DB2MEM=DB2MEM + $db2_mem ))
done
Pls advice. Thanks