This is a discussion on bufferpool hit ratio with the new temp data/index monitor elements within the DB2 forums, part of the Database Server Software category; --> DB2 8.1.3 introduces new monitor elements for temp data/index reads. There is not a whole lot of documentation about ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| DB2 8.1.3 introduces new monitor elements for temp data/index reads. There is not a whole lot of documentation about this in the reference manual and I was wondering if these elements need to be accounted for in the bufferpool hit ratio calculation. i.e. Should the new overall bufferpool hit ratio now be: 1 - ((pool_data_p_reads + pool_index_p_reads+ pool_temp_data_p_reads + pool_temp_index_p_reads ) / (pool_data_l_reads + pool_index_l_reads + pool_temp_data_l_reads + pool_temp_index_l_reads )) Thanks Amit ( singletonATcanadaDOTcom ) |
| Thread Tools | |
| Display Modes | |
|
|