Hi all.
I'm writing a performance analysis utility that uses the snapshot
monitor C API to get statistics in the connection level. It seems that
the way I use the snapshot monitor is very inefficient : each snapshot
takes a few dozens of milliseconds and overall it consumes a lot of
CPU.
Is there a way to configure and optimize the snapshot utility ?
Is there an alternative to the snapshot monitor API ?
When working with Oracle, I'm using Oracle DMA to access the shared
memory myself, is there a way (not necessarily documented or
supported) to access DB2 shared memory and extract these statistics ?


TIA,
Yaron

Yaron Goldstein wrote:
> Hi all.
> I'm writing a performance analysis utility that uses the snapshot
> monitor C API to get statistics in the connection level. It seems that
> the way I use the snapshot monitor is very inefficient : each snapshot
> takes a few dozens of milliseconds and overall it consumes a lot of
> CPU.
> Is there a way to configure and optimize the snapshot utility ?
> Is there an alternative to the snapshot monitor API ?
> When working with Oracle, I'm using Oracle DMA to access the shared
> memory myself, is there a way (not necessarily documented or
> supported) to access DB2 shared memory and extract these statistics ?
Take a look at db2pd and see whether is has what you need.
db2pd also reads memory directly.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Hi Serge,
thanks for you quick reply.


Is there a C/C++ API to db2pd ?
I couldn't find one.

10x
Yaron