Page History
...
| Item | Description |
|---|---|
| Bufferpools Hit Ratio | This graph displays the bufferpool’s bufferpool's hit ratio over time. It displays separate graphs for database hit ratio, data pages hit ratio, and index pages hit ratio. |
| Physical Reads | This graph displays a stacked bar of the physical reads over time. The stacked bar is divided into synchronic, a-synchronic (for data and for index), and direct reads. |
| Read Response Time | This graph displays overtime line graphs of asynchronous read response time, synchronous read response time and direct read response time. Also displayed is a line graph for the average prefetch wait time. |
| Read Time | This graph displays a stacked bar of read time over time. The stacked bar is divided into synchronic, a-synchronic, and direct read time. |
...
| Item | Description |
|---|---|
| Sort Heap Overflows (To disk) Ratio | This graph displays the sort ratio { (Sort overflow) / (total sorts)} and hash joins ratio { (hash join overflows) / (total hash joins)} over time. This graph can indicate whether operations are performed on disk (sorts, hash joins), and whether it is needed to adjust the sort heap size. |
| Overflow Count | This graph displays a stacked bar of sort overflows, hash joins overflows, and small hash joins overflows over time. |
| Sort Time | This graph displays the sort time over time. This graph shows data only if the DB2 sort switch is on. |
...
- In the Time Frame list, choose the period of time you want to analyze.
- In the Database Partition list, choose the item you want to analyze.
- Check whether sorts overflows and hash joins overflows occur in the Overflows Count view. Check the ratio between total sorts and sort overflows and the ratio between hash joins and hash joins overflows in Sort Heap OVerflows Overflows (To Disk) Ratio graph. If the ratio is high then your sort-related parameters are probably not configured adequately.
...