Page History
...
- 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 | ||||
|---|---|---|---|---|
|
...
| Item | Description |
|---|---|
| Devices in Use | List of devices used by DB2 database partition. Storage Statistics information is shown for each device. Selecting one of devices will present detailed information about the selected device in other components below. |
| Device <unit name> <device number>’s Cache Hits | Historical overtime graph of read, write, and combined cache hit ratio (%) of the selected device. |
| Containers and Tablespaces on Device <unit name><device number> | List of Containers and Table spaces stored on the selected device. |
| Device <unit name> <device number>’s Requests | Historical overtime bars graph for read and write requests for the selected device. |
| Device <unit name> <device number>’s Throughput | Historical overtime graph for Throughput (Mb/Sec) of the selected device. |
| Device <unit name> <device number>’s I/O Rate | Historical overtime graph for I/O rate (Sec/Req) on the selected device. |
| Anchor | ||||
|---|---|---|---|---|
|
Databases list activity by database. All database partition information is aggregated to the database level.
...
The following table describes the information displayed in the General tab.
Table 5-11 General tab
Column Description
...
| Column | Description |
|---|---|
| Database | Name of the database where the statement is running. |
| In DB2 (Summed) |
...
| The In DB2 breakdowns. | |
| % |
...
| The In DB2 percentage as a % of total rows. |
| Statement In DB2 (Avg) |
...
| The average In DB2 time for the statement. | |
| Statement |
...
| Executions | Total statement executions within the selected time. |
| Sessions |
...
| Number of sessions. |
The following table describes the information displayed in the In DB2 tab.
Table 5-12 In 12 In DB2 tab
Column Description
...
| Column | Description |
|---|---|
| Database | Name of the database where the statement is running. |
| In DB2 (Summed) |
...
| The In DB2 breakdowns overtime. | |
| Using |
...
| CPU | In DB2 breakdown description. |
| Waiting for |
...
| CPU | In DB2 breakdown description. |
| Sync I/O |
...
| Wait | In DB2 breakdown description. |
| Direct I/O |
...
| Wait | In DB2 breakdown description. |
| Prefetch |
...
| Wait | In DB2 breakdown description. |
| Lock |
...
| Wait | In DB2 breakdown description. |
| I/O Error |
...
| Wait | In DB2 breakdown description. |
| Remote Query |
...
| Wait | In DB2 breakdown description. |
| Utility |
...
| Active | In DB2 breakdown description. |
The following table describes the information displayed in the Statistics tab.
Table 5-13 Statistics tab
Column Description
...
13 Statistics tab
| Column | Description |
|---|---|
| Database | Name of the database where the statement is running. |
| Lock |
...
| Escalations | Total number of lock escalations. |
| Lock |
...
| Timeouts | Total number of lock timeouts. |
| BP Data Read I/ |
...
| O | Total data reads (in pages). |
| BP Index Read I/ |
...
| O | Total index reads (in pages). |
| Direct Read/Write I/ |
...
| O | Total of direct reads and writes (in pages). |
| Rows |
...
| Read | Number of rows read. |
| Rows |
...
| Written | Number of rows written. |
| Rows |
...
| Selected | Number of rows selected. |
| Rows |
...
| Affected | Number of rows affected. |
| Internal Row |
...
| Affected | Number of internal rows affected. |
Selected Database
The following table describes the information displayed in the Over Time tab.
Table 5-14 Over 14 Over Time tab
| Item |
|---|
...
| Description |
|---|
| In DB2 (Summed) |
...
| The In DB2 breakdowns over time. | |
| Overall Activity (Summed) |
...
| The application’s overall activity including In DB2 over time |
...
| . | |
| Sessions | Number of sessions. |
| Compile and Recompile | The |
Sessions Number of sessions
Table 5-14 Over Time tab
Item Description
...
| time the application spent for commits & recompiles over time. |
| Commits and |
...
| Rollbacks | The time the application spent for commits & rollbacks over time. |
The following table describes the information displayed in the Overview tab.
Table 5-15 Overview 15 Overview tab
Item Description
...
| Item | Description |
|---|---|
| Details | Detailed activity information. |
| In DB2 (Summed) |
...
| The In DB2 breakdowns. | |
| Statistics |
...
| Statistic counters overview. |
The following table describes the information displayed in the Statistics tab.
Table 5-16 Statistics 16 Statistics tab
| Item |
|---|
...
| Description |
|---|
| Rows Read/ |
...
| Written | Number of rows read/written. |
| Rows Selected/ |
...
| Affected | Number of rows selected/affected. |
| Bufferpool Physical I/ |
...
| O | Physical I/O over time (in pages). |
| Locks |
...
| Number of lock escalations and lock timeouts over time. |
The following table describes the information displayed in the Storage tab.
Table 5-17 Storage 17 Storage tab
| Item |
|---|
...
| Description |
|---|
| Devices in |
...
| Use | Information about devices that are in use. |
| Device <unit name> <device number>’s Cache |
...
| Hits | The amount of Cache Hits for the selected device. |
| Containers and Tablespaces on Device <unit |
...
| name><device number> | Information on the Containers and Tablespaces that are defined for this specific device. |
| Device <unit name> <device number>’s |
...
| Requests | The amount of Requests for the selected device. |
| Device <unit name> <device number>’s |
...
| Throughput | The Throughput for the selected device. |
| Device <unit name> <device number>’s I/O |
...
| Rate | The I/O Rate for the selected device. |
| Anchor | ||
|---|---|---|
|
...
|
These are the names of programs that execute Precise for DB2 activity.
Program Comparison
The following table describes the information displayed in the General tab.
Table 5-18 General 18 General tab
| Column |
|---|
...
| Description |
|---|
...
| Program |
...
| Program name. |
| In DB2 (Summed) |
...
| The In DB2 breakdowns. | |
| % |
...
| The In DB2 percentage as a % of total rows. |
| Statement In DB2 (Avg) |
...
| The average In DB2 time for the statement. | |
| Statement |
...
| Executions | Total statement executions within the selected time. |
| Sessions |
...
| Number of sessions |
...
| . |
The following table describes the information displayed in the In DB2 tab.
Table 5-19 In DB2 tab
Column Description
Program Program name
...
Utility Active In DB2 breakdown description
The following table describes the information displayed in the Statistics tab.
Table 5-20 Statistics tab
Column Description
Program Program name
...
Rows Written Number of rows written
Table 5-20 Statistics tab
Column Description
Rows Selected Number of rows selected
...
Internal Row Affected Number of internal rows affected
Selected Program
The following table describes the information displayed in the Over Time tab.
Table 5-21 Over Time tab
Column Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Commits and Rollbacks The time the application spent for commits & rollbacks over time
The following table describes the information displayed in the Overview tab.
Table 5-22 Overview tab
Column Description
Details Detailed activity information
...
Statistics Statistic counters overview
The following table describes the information displayed in the Statistics tab.
Table 5-23 Statistics tab
Column Description
Rows Read/Written Number of rows read/written
...
Locks Number of lock escalations and lock timeouts overtime
| Anchor | ||||
|---|---|---|---|---|
|
These are the statements Precise for DB2 is executing. Statements are collapsed.
Statement Comparison
The following table describes the information displayed in the General tab.
Table 5-24 General tab
Column Description
Icon Launch to SQL tab for statement tuning
...
Executions Total statement executions within the selected time frame. Available for statements, tables, and indexes.
Text Statement text
The following table describes the information displayed in the In DB2 tab.
Table 5-25 In DB2 tab
Column Description
Icon Launch to SQL tab for statement tuning
...
Utility Active In DB2 breakdown description
Selected Statement
The following table describes the information displayed in the Over Time tab.
Table 5-26 Over Time tab
Column Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Statement Executions Total statement executions within the selected time
The following table describes the information displayed in the Overview tab.
Table 5-27 Overview tab
Column Description
Details Detailed activity information and last explain details
In DB2 (Summed) The In DB2 breakdowns
Text Statement text
| Anchor | ||
|---|---|---|
|
...
|
Lists of tables and indexes in use.
Object Comparison
The following table describes the information displayed in the General tab.
Table 5-28 General tab
Column Description
Icon Launch to Objects tab
...
No Prefetch I/O I/O time used with no prefetch
Selected Object
The following table describes the information displayed in the Overview tab.
Table 5-29 Overview tab
Column Description
Details Object details
...
Prefetched I/O (Summed) Over time information or I/O separated by Sequential prefetch, List prefetch, and No prefetch
| Anchor | ||
|---|---|---|
|
...
|
This is a list of the machines from which the users are logging in.
Machine Comparison
The following table describes the information displayed in the General tab.
Table 5-30 General tab
Column Description
Machine Machine name
...
Sessions Number of sessions
The following table describes the information displayed in the In DB2 tab.
Table 5-31 In DB2 tab
Column Description
Machine Machine name
...
Utility Active In DB2 breakdown description
The following table describes the information displayed in the Statistics tab.
Table 5-32 Statistics tab
Column Description
Machine Machine name
...
Rows Written Number of rows written
Table 5-32 Statistics tab
Column Description
Rows Selected Number of rows selected
...
Internal Row Affected Number of internal rows affected
Selected Machine
The following table describes the information displayed in the Over Time tab.
Table 5-33 Over Time tab
Item Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Commits and Rollbacks The time the application spent for commits & rollbacks over time
The following table describes the information displayed in the Overview tab.
Table 5-34 Overview tab
Item Description
Details Detailed activity information
...
Statistics Statistic counters overview
The following table describes the information displayed in the Statistics tab.
Table 5-35 Statistics tab
Item Description
Rows Read/Written Number of rows read/written
...
Locks Number of lock escalations and lock timeouts over time
| Anchor | ||
|---|---|---|
|
...
|
Modules represent the name of the package that was activated.
Module Comparison
The following table describes the information displayed in the General tab.
Table 5-36 General tab
Column Description
Module Module name
...
Sessions Number of sessions
The following table describes the information displayed in the In DB2 tab.
Table 5-37 In DB2 tab
Column Description
Module Module name
...
Utility Active In DB2 breakdown description
The following table describes the information displayed in the Statistics tab.
Table 5-38 Statistics tab
Column Description
Module Module name
...
Rows Written Number of rows written
Table 5-38 Statistics tab
Column Description
Rows Selected Number of rows selected
...
Internal Row Affected Number of internal rows affected
Selected Module
The following table describes the information displayed in the Over Time tab.
Table 5-39 Over Time tab
Item Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Commits and Rollbacks The time the application spent for commits & rollbacks over time
The following table describes the information displayed in the Overview tab.
Table 5-40 Overview tab
Item Description
Details Detailed activity information
...
Statistics Statistic counters overview
The following table describes the information displayed in the Statistics tab.
Table 5-41 Statistics tab
Item Description
Rows Read/Written Number of rows read/written
...
Locks Number of lock escalations and lock timeouts over time
| Anchor | ||
|---|---|---|
|
...
|
These are the account strings that were activated from the client information.
Action Comparison
The following table describes the information displayed in the General tab.
Table 5-42 General tab
Column Description
Action Action name
...
Sessions Number of sessions
The following table describes the information displayed in the In DB2 tab.
Table 5-43 In DB2 tab
Column Description
Action Action name
...
Utility Active In DB2 breakdown description
The following table describes the information displayed in the Statistics tab.
Table 5-44 Statistics tab
Column Description
Action Action name
...
Rows Written Number of rows written
Table 5-44 Statistics tab
Column Description
Rows Selected Number of rows selected
...
Internal Row Affected Number of internal rows affected
Selected Action
The following table describes the information displayed in the Over Time tab.
Table 5-45 Over Time tab
Item Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Commits and Rollbacks The time the application spent for commits & rollbacks over time
The following table describes the information displayed in the Overview tab.
Table 5-46 Overview tab
Item Description
Details Detailed activity information
...
Statistics Statistic counters overview
The following table describes the information displayed in the Statistics tab.
Table 5-47 Statistics tab
Item Description
Rows Read/Written Number of rows read/written
...
Locks Number of lock escalations and lock timeouts over time
| Anchor | ||
|---|---|---|
|
...
|
These are the names of the users that logged into the machine and executed activity in DB2.
OS User Comparison
The following table describes the information displayed in the General tab.
Table 5-48 General tab
Column Description
OS User OS User name
...
Sessions Number of sessions
The following table describes the information displayed in the In DB2 tab.
Table 5-49 In DB2 tab
Column Description
OS User OS User name
...
Utility Active In DB2 breakdown description
The following table describes the information displayed in the Statistics tab.
Table 5-50 Statistics tab
Column Description
OS User OS User name
...
Rows Written Number of rows written
Table 5-50 Statistics tab
Column Description
Rows Selected Number of rows selected
...
Internal Row Affected Number of internal rows affected
Selected OS User
The following table describes the information displayed in the Over Time tab.
Table 5-51 Over Time tab
Item Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Commits and Rollbacks The time the application spent for commits & rollbacks over time
The following table describes the information displayed in the Overview tab.
Table 5-52 Overview tab
Item Description
Details Detailed activity information
...
Statistics Statistic counters overview
The following
Table 5-53 Statistics tab
Item Description
Rows Read/Written Number of rows read/written
...
Locks Number of lock escalations and lock timeouts over time
| Anchor | ||
|---|---|---|
|
...
|
These are the names of the users that logged into the DB2 database.
DB User Comparison
The following table describes the information displayed in the General tab.
Table 5-54 General tab
Column Description
DB User Database User name
...
Sessions Number of sessions
The following table describes the information displayed in the In DB2 tab.
Table 5-55 In DB2 tab
Column Description
DB User Database User name
...
Utility Active In DB2 breakdown description
The following table describes the information displayed in the Statistics tab.
Table 5-56 Statistics tab
Column Description
DB User Database User name
...
Rows Written Number of rows written
Table 5-56 Statistics tab
Column Description
Rows Selected Number of rows selected
...
Internal Row Affected Number of internal rows affected
Selected DB User
The following table describes the information displayed in the Over Time tab.
Table 5-57 Over Time tab
Item Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Commits and Rollbacks The time the application spent for commits & rollbacks over time
The following table describes the information displayed in the Overview tab.
Table 5-58 Overview tab
Item Description
Details Detailed activity information
...
Statistics Statistic counters overview
The following table describes the information displayed in the Statistics tab.
Table 5-59 Statistics tab
Item Description
Rows Read/Written Number of rows read/written
...
Locks Number of lock escalations and lock timeouts over time
| Anchor | ||
|---|---|---|
|
...
|
Tablespaces list activity by Tablespace.
...
The following table describes the information displayed in the General tab.
Tablespace Comparison
Table 5-60 General tab
Column Description
Tablespace The name of the tablespace
...
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-61 I/O Time tab
Column Description
Tablespace The name of the tablespace
...
Direct Write Time The total Direct Write Time
The following table describes the information displayed in the I/O Count tab.
Table 5-62 I/O Count tab
Column Description
Tablespace The name of the tablespace
...
Direct Writes The total Direct Writes
The following table describes the information displayed in the Response Time tab.
Table 5-63 Response Time tab
Column Description
Tablespace The name of the tablespace
...
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 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
Details Details about the selected tablespace
...
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 tab
Column Description
Bufferpool The name of the bufferpool
...