Page History
...
Table 5-63 Response Time tab
Column Description
...
| Column | Description |
|---|---|
| Tablespace | The name of the tablespace. |
| Synchronous Read Response Time |
...
| The average Synchronous Read Response Time. |
| Asynchronous Read Response |
...
| The average Asynchronous Read Response. |
| Direct Read Response |
...
| Time | The average Direct Read Response Time. |
| Synchronous Write Response Time |
...
| The average Synchronous Write Response Time. |
| Asynchronous Write Response |
...
| The average Asynchronous Write Response. |
| Direct Write Response |
...
| Time | The average Direct Write Response Time. |
Selected Tablespace
The following table describes the information displayed in the Over Time tab.
Table 5-64 Over Time tab
| Item |
|---|
...
| Description |
|---|
| Hit |
...
| Ratio | The tablespace Hit Ratio over time. |
| I/O |
...
| Time | The tablespace I/O time breakdown over time. |
| Response Time (Avg) |
...
| The tablespace average Response Time over time. | |
| I/O |
...
| Count | The tablespace I/O Count breakdown over time (in pages). |
The following table describes the information displayed in the Overview tab.
Table 5-65 Overview tab
Item Description
...
| Item | Description |
|---|---|
| Details | Details about the selected tablespace. |
| I/O |
...
| Time | Total I/O time breakdowns (in Pie chart). |
| I/O |
...
| Count | Total I/O Count breakdowns (in Pie chart). |
| Anchor | ||||
|---|---|---|---|---|
|
Bufferpools list activity by Bufferpool. This entity is only available for the Database and Database Partition entities. To display activity by bufferpool, drill from the Database or Database Partition to the Bufferpools entity.
Bufferpool Comparison
The following table describes the information displayed in the General tab.
Table 5-66 General 66 General tab
Column Description
...
| Column | Description |
|---|---|
| Bufferpool | The name of the bufferpool. |
| I/O Time (Summed) |
...
| Total I/O time breakdown. | |
| I/O |
...
| Count | Total I/O count breakdown (in pages). |
| Page |
...
| Size | The bufferpool’s page size. |
...
| Pages | The number of pages. |
| No Victim |
...
| Available | The number of times an agent did not have a pre-selected victim buffer available |
...
| . |
The following table describes the information displayed in the I/O Time tab.
Table 5-67 I67 I/O Time tab
| Column |
|---|
...
| Description |
|---|
...
| Bufferpool |
...
| The name of the bufferpool. |
| I/O Time (Summed) |
...
| Total I/O time breakdown. | |
| Synchronous Read |
...
| Time | The total Synchronous Read Time. |
| Asynchronous Read |
...
| Time | The total Asynchronous Read Time. |
| Direct Read |
...
| Time | The total Direct Read Time. |
| Synchronous Write |
...
| Time | The total Synchronous Write Time. |
| Asynchronous Write |
...
| Time | The total Asynchronous Write Time. |
| Direct Write |
...
| Time | The total Direct Write Time |
...
| . |
The following
table describes the information displayed in the I/O Count tab.
Table 5-68 I68 I/O Count tab
Column Description
...
| Column | Description |
|---|---|
| Bufferpool | The name of the bufferpool. |
| I/O |
...
| Count | The total I/O Count. |
| Synchronous Data |
...
| Reads | The total Synchronous Data Reads. |
| Synchronous Index |
...
| Reads | The total Synchronous Index Reads. |
| Asynchronous Data |
...
| Reads | The total Asynchronous Data Reads. |
| Asynchronous Index |
...
| Reads | The total Asynchronous Index Reads. |
| Direct |
...
| Reads | The total Direct Reads. |
| Synchronous Data |
...
| Writes | The total Synchronous Data Writes. |
| Synchronous Index |
...
| Writes | The total Synchronous Index Writes. |
| Asynchronous Data |
...
| Writes | The total Asynchronous Data Writes. |
| Asynchronous Index |
...
| Writes | The total Asynchronous Index Writes. |
Table 5-68 I/O Count tab
Column Description
...
| Direct Writes | The total Direct Writes. |
The following table describes the information displayed in the Response Time tab.
Table 5-69 Response 69 Response Time tab
Column Description
...
| Column | Description |
|---|---|
| Bufferpool | The bufferpool name. |
| Synchronous Read Response Time |
...
| The average Synchronous Read Response Time. |
| Asynchronous Read Response |
...
| The average Asynchronous Read Response. |
| Direct Read Response |
...
| Time | The average Direct Read Response Time. |
| Synchronous Write Response Time |
...
| The average Synchronous Write Response Time. |
| Asynchronous Write Response |
...
| The average Asynchronous Write Response. |
| Direct Write Response |
...
| Time | The average Direct Write Response Time. |
Selected Bufferpool
The following table describes the information displayed in the Over Time tab.
Table 5-70 Over 70 Over Time tab
| Item |
|---|
...
| Description |
|---|
| Hit |
...
| Ratio | The bufferpool Hit Ratio over time. |
| I/O |
...
| Time | The bufferpool I/O time breakdown over time. |
| Response Time (Avg) |
...
| The bufferpool average Response Time over time. | |
| I/O |
...
| Count | The bufferpool I/O Count breakdown over time (in pages) |
...
| . |
The following table describes the information displayed in the Overview tab.
Table 5-71 Overview 71 Overview tab
| Item |
|---|
...
| Description |
|---|
...
| Details |
...
| Details about the selected bufferpool. |
| I/O |
...
| Time | Total I/O time breakdowns. |
| I/O |
...
| Count | Total I/O Count breakdowns |
...
...
| . |
Precise. Performance intelligence from click to storage. Learn more > >
...