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.
...
- 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 you allocated enough log space in the Log Space view. Identify whether secondary log space is used. If so, you probably need to allocate more primary log space.
- Check whether your log read and write time are adequate by looking in the Log Time view. This may indicate whether the current disk is adequate for logging.