buffer pool heap != buffer pool
Getting buffer pool information either through:
get snapshot for bufferpools on <dbname>
or
the "bufferpool snapshot" part in db snapshot.
Regards,
FRX

Erik Hendrix wrote:

> I've got a question, when I take a database snapshot in V8, I get 4
> bufferpools back for memory usage. But when I then do a snapshot on
> bufferpools I only get 1 back. The size in that snapshot for that 1
> bufferpool is also a lot smaller then the size specified in the database
> snapshot.
> So what is this information in the database snapshot?
>
> Memory Pool Type = Buffer Pool Heap
> Current size (bytes) = 4227072
> High water mark (bytes) = 4227072
> Maximum size allowed (bytes) = 4294950912
>
> Memory Pool Type = Buffer Pool Heap
> Current size (bytes) = 557056
> High water mark (bytes) = 557056
> Maximum size allowed (bytes) = 4294950912
>
> Memory Pool Type = Buffer Pool Heap
> Current size (bytes) = 294912
> High water mark (bytes) = 294912
> Maximum size allowed (bytes) = 4294950912
>
> Memory Pool Type = Buffer Pool Heap
> Current size (bytes) = 163840
> High water mark (bytes) = 163840
> Maximum size allowed (bytes) = 4294950912
>
> Memory Pool Type = Buffer Pool Heap
> Current size (bytes) = 98304
> High water mark (bytes) = 98304
> Maximum size allowed (bytes) = 4294950912
>
> From the bufferpool snapshot the memory information is:
> Node number = 0
> Tablespaces using bufferpool = 4
> Alter bufferpool information:
> Pages left to remove = 0
> Current size = 1000
> Post-alter size = 1000
>
> Thanks.