Figure 3 contains the output of the SQL Monitor comparison containing the timings from the testing of the two optimization goals.
图3显示了测试这两种优化目标时SQL Monitor比较的输出，其中包含时间方面的数字。
The SQL baseline must be captured during the test and not after, as done for the reports on aggregated data, because a DB2 statement event monitor is started to capture the data.
必须在测试期间捕捉SQL基线，而不是像聚合数据报告那样在测试之后捕捉，这是因为要启动db2语句事件监视器来捕捉数据。
Because this event monitor causes a lot of overhead on the monitored instance, these processes to create SQL reports should be started with consideration.
因为这个事件监视器会给监视的实例带来很大开销，所以在启动创建SQL报告的过程时要仔细考虑。
The option to turn on the SQL Statement event monitor is not practical because of the overheard involved and the potential performance penalty a high transaction environment could incur.
用于打开SQL语句事件监视器的选项并不实用，由于涉及的开销和潜在的性能损失，会导致一个高事务环境。
DB2 UDB provides several tools that can be used to monitor database server activities, or to analyze how an SQL statement accesses data; each serves a different purpose.
DB 2UDB提供了多个工具，可以用于监控数据库服务器的活动，或分析sql语句如何访问数据；每个工具都服务于不同的目的。
You would use the Queries process if for a multi-partition monitored instance for which you want to collect SQL event monitor data for multiple partitions simultaneously.
对于多分区实例，可以使用查询过程同时收集多个分区的SQL事件监视器数据。
If the test you want to take a baseline on is running at night, you can schedule the report generation and the collection of SQL event monitor data by the DB2 statement event monitor.
如果要建立基线的测试在夜间运行，那么可以调度db2语句事件监视器对SQL事件监视器数据的收集和报告生成过程。
When a deadlock event monitor is created with the DETAILS HISTORY option, DB2 keeps track of the SQL statements already executed in a transaction.
使用DETAILSHISTORY选项创建死锁事件监视器时，DB 2跟踪已经在事务中执行的sql语句。
It reads the SQL statements executed from the event monitor tables and runs the Explain utility for each statement to generate the corresponding access plan.
它将读取从事件监控器表执行的sql语句，然后对每个语句运行Explain实用程序以生成对应的访问计划。
Learn how administration API enables you to monitor system activity using SQL commands.
学习如何通过管理API使用SQL命令监视系统活动？
A user name and password for a user who has sufficient privileges to start and operate a statement event monitor as well as to create a schema where the SQL Profiler holds its local data.
某用户的用户名和口令，该用户拥有足够的权限启动和操作语句事件监视器，以及创建模式，而SQLProfiler将在该模式中保存其本地数据。
If you use the long-term history, start a DB2 statement event monitor to collect SQL event monitor data and to store the collected data in the performance database of the performance Expert server.
如果使用长期历史，可以启动db2语句事件监视器来收集SQL事件监视器数据，并把收集的数据存储到PerformanceExpert服务器的性能数据库中。
The Visual Explain tool can be used on SQL statements in a monitor collection by right-clicking on a monitor and selecting the Show statements task.
可以在一个监视器集合中，通过右键单击一个监视器并选择ShowStatements任务，在sql语句上应用VisualExplain工具。
When the query is executed without distribution statistics, a snapshot for dynamic SQL returns the following monitor values (given that the required monitor switches are active).
在没有分布统计信息的情况下，执行该查询时，动态sql的一个快照返回以下监视器值(假定所需的监视器开关已激活)。
If the SQL Performance Monitor target job was a specific job and that job was started by the current user, *JOBCTL user special authority is not required.
如果SQL性能监视器目标任务是一个特定的任务，并且该任务是由当前用户启动的，那么不需要 *JOBCTL 用户特殊权限。
Note that the event monitor information is very detailed, and it will quickly grow in size if many fast SQL statements are executed in a short time.
注意，事件监视器信息十分详细，如果短时间内执行了许多快速的sql语句，那么事件监视器的信息量就会快速增长。
The center column shows the values you would observe when analyzing the SQL Performance monitor and the last column defines the values which appear within the QVC43 column of the output monitor file.
中间的列显示在分析SQL性能监视器时观察到的值，最后一列定义输出的监视器文件中QVC43列显示的值。
This article explains how to collect an SQL Performance Monitor and understand how many of the SQL queries are using SQE and why other SQL statements continue to use CQE.
本文解释如何收集SQL性能监视器，以及理解很多SQL查询在如何使用SQE，为什么其他sql语句继续使用CQE。
A new tool added in DB2 UDB V8.2, called the Activity Monitor, USES various SQL functions and procedures to retrieve performance data for a live system for analysis.
DB 2UDBV8.2中增加了一个新工具，称为ActivityMonitor。它使用各种sql函数和过程获得性能数据，对系统进行分析。
A recent enhancement to DB2 for I 6.1 makes it possible to understand the optimizer use at the SQL statement level within the SQL Performance Monitor.
DB 2fori 6.1最近的一个增强使得理解在SQL性能监视器中sql语句级使用优化器成为可能。
Using the Instances view of the Dashboard results in SQL queries being sent directly to the Monitor database.
使用Dashboard的Instances视图将导致SQL查询被直接发送到Monitor数据库。
When you are debugging SQL, the Remote debugging Monitor will launch automatically during debugging.
进行SQL调试时，远程调试监视器会在调试期间自动启动。
Generates a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is useful to monitor and tune the performance of DML statements.
该语句工具主要是研究统计sql语句的执行计划并生成报告，进而对dml语句进行检测和优化。
For remote debugging other than SQL, make sure that you are running the remote debugging Monitor on the remote computer.
对于SQL以外的远程调试，请确保您正在远程计算机上运行远程调试监视器。
For remote debugging other than SQL, make sure that you are running the remote debugging Monitor on the remote computer.
对于SQL以外的远程调试，请确保您正在远程计算机上运行远程调试监视器。
应用推荐