PWH data tables containing SQL activity trace data.
包含SQL活动跟踪数据的PWH数据表。
PWH data tables containing snapshot and configuration data.
包含快照和配置数据的PWH数据表。
Queries are used to analyze various aspects of the data in the PWH.
查询用于分析pwh中数据的不同方面。
The queries are standard SQL select statements that operate against the PWH tables.
这些查询是标准的SQLselect语句，它们基于pwh表执行。
Here are some of the questions that can be answered by analyzing the data in the PWH.
以下是可以通过分析pwh中的数据来回答的一些问题。
Report queries: These queries return the data contained in the PWH tables under different aspects.
报告查询：这些查询返回包含在pwh表中的不同方面的数据。
Processes are used to collect report data (CRD), load the data into the PWH tables and create a report.
过程用于收集报告数据(CRD)、将这些数据加载到pwh表中和创建报告。
This is handy if you are not familiar with all the PWH tables, but you do not have to use the column assist.
若用户并不是对所有的PWH 表都非常熟悉，则该特性便会派上用场，但这并不是说必须使用该特性。
Figure 7 shows a sample ROT result matrix that is displayed after you have started ROT analysis on the PWH data.
图7所示为启动P WH数据的ROT分析后所显示的示例ROT结果矩阵。
At an interval configured by you, the captured short-term history data will be migrated into the PWH tables using an ETL process.
捕获的短期历史数据以用户配置的时间间隔，通过ETL过程迁移到pwh表中。
The PWH includes a Workflow Engine consisting of processes that are used to collect and load data and to create reports from the loaded data.
PWH 中包含了一个工作流引擎，它由用于收集和加载数据并用所加载的数据创建报告的过程组成。
Once long-term data has been stored into the PWH tables, you can use the predefined ROT or define your own ROT to analyse the data in the PWH.
一旦长期数据存入PWH表，就可以使用预定义的ROT或定义自己的 ROT来分析 PWH 中的数据。
Analyzing the data in the PWH helps you to identify potential performance problems or trends or to determine the effects of changing a DB2 configuration value.
分析pwh中的数据有助于识别潜在的性能问题或趋势，或确定更改某一DB 2配置值后的结果。
Analysing the data in the PWH helps you to identify potential performance problems or trends, or to determine the effects of changing a DB2 configuration value.
在PWH中分析数据有助于识别潜在的性能问题或趋势，以及确定改变DB 2配置值的效果。
If you use a strict test process where you can reset an environment back to a "zero state" before each run, the PWH data can be very valuable in proving reproducible results for a test.
若在所使用的严格测试过程中可以在每一测试开始前将环境重置回“零状态”，则PWH数据在验证某一测试的重复结果中可能非常有价值。
While the history data of DB2 PE is only retained for a short time (hours or days), once data is in the PWH, the data is available for reporting and trend analysis over much longer periods.
尽管DB 2PE的历史数据只保留较短的时间(几小时或几天)，但是一旦数据被保存在PWH中，这些数据便可在很长的时间内用于报告和趋势分析。
While the history data of DB2 PE is only retained for a short time (hours or days), once data is in the PWH, the data is available for reporting and trend analysis over much longer periods.
尽管DB 2PE的历史数据只保留较短的时间(几小时或几天)，但是一旦数据被保存在PWH中，这些数据便可在很长的时间内用于报告和趋势分析。
应用推荐