Hello, I am running DB2 V8.2 on AIX. I am looking for a way to get
the memory size of a specific db2 agent. I have found the db2mtrk
tool that gives me a list of all the applications and heap sizes.
Also there is "DB2 Snapshot for Application" but I am looking for a
way to capture the data for C code without having to parse through a
file. The SNAPSHOT_APPL and SNAPSHOT_APPL_I NFO table functions seem
to fall short of the information
I noted there is an admin view available in DB2 V9 that gets the same
information as db2mtrk but it does not appear to be available in V8.
So, does anyone know of a way to retrieve this data? Is it stored in
a DB2 System table somewhere or is there some other way to access the
info from memory? Maybe there is a nifty way to extract it from
SNAPSHOT without outputting to a file and parsing it. I have looked
at getting the same info from AIX but it would also require gathering
the size from a "ps" file or the like....and that is after I match the
application id to a PID.
I am looking for a "low cost" way of doing this as I do not want to
tax the system in any way to get the data. Any advise would be
helpful.
Thanks in advanced!