Page History
This section includes the following topics:
- About Precise for DB2
- Components of Precise for DB2
- How Precise for DB2 works
- What you can do with Precise for DB2
- Where to get more information
| Anchor | ||||
|---|---|---|---|---|
|
Addressing the needs of DBAs, system administrators, managers, quality assurance specialists and planners, Precise for DB2 (Precise for DB2) provides a complete view of database performance by capturing, measuring, and correlating performance metrics from all critical system components.
...
The PMDB is the repository of the Precise product suite which stores application performance data for long-term analysis and trending reports. For more information, see the Precise Administration Guide.
| Anchor | ||||
|---|---|---|---|---|
|
Precise for DB2 employs a client/server architecture to provide high performance database monitoring and tuning. Precise for DB2 consists of the following components:
...
If ERP support is installed, the Collector provides detailed information on the activities and resource consumption of "packaged application" entities. It enables you to identify ERP users, transactions, reports, and so on, that are heavy users of DB2 resources and to drill down to the statements executed by them and the objects they accessed. See the Precise Installation Guide or the Precise Administration Guide.
| Anchor | ||||
|---|---|---|---|---|
|
Precise for DB2 stores a complete history of your database activity in the PMDB. This provides you with a performance tracking tool that gives you the ability to assess database performance trends and analyze changes in database activities over long periods of time. This data is vital for identifying patterns in resource consumption and predicting future resource consumption in your DB2 database.
...
| Overall Activity state | Description |
|---|---|
| In DB2 (Summed) | Time spent by the selected item or items in the selected category executing an SQL statement. |
| UOW Waiting | Time spent by the application waiting for a request or input. For example, a Unit Of Work wait takes place when (1) a user starts a Command Line Processor session, connect to the database and then do nothing, (2) a client application executes an SQL statement, displays its result set on a window and waits for next GUI request while still connected, (3) export application writes fetched rows to an output file. |
| Decoupled from DB agent | Time spent by the application when a database agent (process) is not assigned to the connected application. This happens when using connection concentrator (MAX_CONNECTIONS > MAXCAGENTS). It is impossible to tell whether the application is idle or the application is waiting for an available database agent. |
| Connect Pending | Time spent by the application waiting for DB2 to complete connect request. |
| Disconnect Pending | Time spent by the application waiting for DB2 to complete disconnect request. |
| Wait for Remote Request | Time spent by the application waiting for a remote DB2 server to complete SQL execution. |
| Wait for Commit Phase II | Time spent by the application waiting for the coordinator to request DB2 to start commit phase II. This state is also known as an in-doubt transaction. |
| Anchor | ||||
|---|---|---|---|---|
|
Use Precise for DB2 to detect, diagnose and resolve performance problems in your DB2 database. Precise for DB2 lets you identify real-time performance problems (for example, locking problems) and monitor a complete history of your DB2 database.
...
- See your whole application status at a glance
- Support very large installations – hundreds of databases and partitions
- Resolve performance problems by identifying their root cause and improving statement performance
- Proactively monitor, analyze, and tune Precise for DB2 data partitions
- Analyze and tune locking problems
- Determine whether an I/O problem is caused by a Precise for DB2 application
- Tune a database object rather than a specific statement that accesses the database object
- Perform I/O tuning of storage devices
- Identify the most resource-consuming SQL statement and view a detailed explanation of the execution plan of the SQL statement
- Recommend which index would provide a better execution plan and reduce resource consumption
- Monitor your system's current state as well as previous states
| Anchor | ||||
|---|---|---|---|---|
|
More information on Precise, its products, technical notes, and so on, can be found in the Release Notes document for this version.
...