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中的数据来回答的一些问题。
Processes are used to collect report data (CRD), load the data into the PWH tables and create a report.
过程用于收集报告数据(CRD)、将这些数据加载到pwh表中和创建报告。
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 中的数据。
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中,这些数据便可在很长的时间内用于报告和趋势分析。
应用推荐