Use this command to reset the database buffer pool statistics. The buffer pool statistics consist of the following:
You can use the QUERY DB command (FORMAT=DETAILED) to display the detailed buffer pool statistics.
Privilege Class
To issue this command, you must have system privilege or analyst privilege.
Syntax
>>-RESet BUFPool-----------------------------------------------><
Parameters
None.
Examples
Task
Reset the buffer pool statistics.
Related Commands
Table 216. Commands Related to RESET BUFPOOL
Command | Description |
---|---|
QUERY DB | Displays allocation information about the database. |
RESET DBMAXUTILIZATION | Resets the maximum utilization statistic for the database. |
RESET LOGMAXUTILIZATION | Resets the maximum utilization statistic for the recovery log. |