DB2:getBufferPoolHitRatio

Retrieve bufferpool hit ratio information.

Type

SYNC, IMPACT__INFO

None.

Name	Type	Description
Database Name	String	Database Name.
Buffer Pool Name	String	Buffer Pool Name.
Total Hit Ratio	Double	Total hit ratio (index, XDA and data reads).
Data Hit Ratio	Double	Data hit ratio.
Index Hit Ratio	Double	Index hit ratio.
XDA Hit Ratio	Double	Auxiliary storage objects hit ratio.
DB Partition Number	Integer	The database partition from which the data was retrieved for this row.

Invoking this method you can evaluate the bufferpool hit ratio in terms of Data, Index and XDA.

Did you find this helpful?

Yes No