sanpshot output 
Author Message
 sanpshot output
Hi,
Could any one of you show me some pointers (DB2 manual etc.) where
I could find description of the output produced by the 'snapshot'.
For example what is ...

Buffer pool data logical reads
Buffer pool data physical reads
Asynchronous pool data page reads

etc.

Also I do I translate all these into 'buffer hit ratio'
or 'buffer miss ratio' etc.

Thanks,
Paul.



Mon, 26 Jul 2004 10:07:53 GMT
 sanpshot output

Hi, Paul
You can see "System Monitor Guide and Reference"
Regards,
Fan Ruo Xin
Quote:

> Hi,
> Could any one of you show me some pointers (DB2 manual etc.) where
> I could find description of the output produced by the 'snapshot'.
> For example what is ...

> Buffer pool data logical reads
> Buffer pool data physical reads
> Asynchronous pool data page reads

> etc.

> Also I do I translate all these into 'buffer hit ratio'
> or 'buffer miss ratio' etc.

> Thanks,
> Paul.



Mon, 26 Jul 2004 10:36:37 GMT
 sanpshot output
Logical read:  Page requested and found in the buffer pool.
Physical read:  Page requested, not found, IO exercised to bring it in.

Asynchronous reads:  Done by IO servers for prefetching.  Typically
identify reads done ahead of time in anticipation that the page will be
needed for the next requests.

The buffer pool hit ratio and these are defined in your Syst. Perf.
Monitor Guide.
HRH,  Pierre.

Quote:

> Hi,
> Could any one of you show me some pointers (DB2 manual etc.) where
> I could find description of the output produced by the 'snapshot'.
> For example what is ...

> Buffer pool data logical reads
> Buffer pool data physical reads
> Asynchronous pool data page reads

> etc.

> Also I do I translate all these into 'buffer hit ratio'
> or 'buffer miss ratio' etc.

> Thanks,
> Paul.



Tue, 27 Jul 2004 02:14:52 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Replicating (sanpshot replication) Referenced tables

2. table sanpshot

3. sanpshot replication with immediating update

4. testing last sanpshot in QNX platform

5. testing last sanpshot in QNX platform

6. sanpshot too old

7. output parameters and output recordsets

8. Handling SP output like a cursor select output.

9. Max output length 8192 for XML output

10. Can not get output value for input/output parm

11. Capture sp output from other sp output

12. truncated output from sql server 7 using cold fusion to output


 
Powered by phpBB® Forum Software