Page History
...
The following entities can be examined in the Activity tab:
- About All DB2 Databases
- About Database Partitions
- About Databases
- About Programs
- About Statements
- About Objects
- About Machines
- About Modules
- About Actions
- About OS Users
- About DB Users
- About Tablespaces
- About Bufferpools
| Anchor | ||||
|---|---|---|---|---|
|
DB2 instances aggregate information from all the databases.
The following table describes the information displayed in the Over Time tab.
Table 5-1 Over 1 Over Time tab
| Item |
|---|
...
| Description |
|---|
| In DB2 (Summed) |
...
| The In DB2 breakdowns over time. | |
| Overall Activity (Summed) |
...
| Application overall activity over time. | |
| Sessions |
...
| Number of sessions over time. |
| Compile and |
...
| Recompile | The time the application spent for compiles and recompiles over time. |
| Commits and |
...
| Rollbacks | The time the application spent for commits and rollbacks over time. |
The following table describes the information displayed in the Overview tab.
Table 5-2 Overview 2 Overview tab
Item Description
...
| Item | Description |
|---|---|
| Details | Summed information for the chosen time frame of Total In db2, Sessions, etc. |
| In DB2 (Summed) |
...
| The summed In DB2 breakdowns. | |
| Statistics |
...
| Summed statistics information such as locks escalations, locks timeouts, etc. |
The following table describes the information displayed in the Statistics tab.
Table 5-3 Statistics 3 Statistics tabItem Description
| Item | Description |
|---|---|
| Rows Read/ |
...
| Written | The number of rows read and written over time. |
| Rows Selected/ |
...
| Affected | The number of rows selected and rows affected over time. |
| Bufferpool Physical I/ |
...
| O | Pages read over time. |
| Locks |
...
| Locks escalations and locks timeouts over time. |
| Anchor | ||||
|---|---|---|---|---|
|
Database partitions list all the information taking place in the database partitions.
...