pwh
美 
英
- 网络威尔斯亲王医院(Prince of Wales Hospital)；半峰宽；伟
例句
If your configuration parameters rarely change, you will have only a few rows in the appropriate PWH tables.
若配置参数很少变更，那么在相应的PWH表中将只有不多的几行。
Processes are used to collect report data (CRD), load the data into the PWH tables and create a report.
过程用于收集报告数据（CRD）、将这些数据加载到PWH表中和创建报告。
A really nice feature of the PWH queries is the ability to insert a variable into the query, which you can later fill in at run time.
PWH查询的一个非常精妙的特性是将变量插入查询的能力，用户可以在运行时对变量进行替代。
Heavy hitter queries: These queries operate on the PWH tables which have stored the data collected by the DB2 statement event monitor.
高命中率查询：这些查询对已经存储了DB2语句事件监视器所收集的数据的PWH表进行操作。
The queries are standard SQL select statements that operate against the PWH tables.
这些查询是标准的SQLselect语句，它们基于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表都非常熟悉，则该特性便会派上用场，但这并不是说必须使用该特性。
Report queries: These queries return the data contained in the PWH tables under different aspects.
报告查询：这些查询返回包含在PWH表中的不同方面的数据。
For each record in the PWH. BUFFERPOOL table, the result matrix indicates whether a warning or problem occurred for the calculated ratios.
对于PWH.BUFFERPOOL表中的每一条记录，结果矩阵都指示计算的比例是否出现警告或问题。
The data were aggregated in the background into the PWH tables from the short-term history (database, bufferpool, OS data).
在后台，把来自短期历史（数据库、缓冲区池、OS数据）的数据聚合到PWH表中。
In addition, data captured by the DB2 statement event monitor can be saved into the PWH if needed.
此外，如果必要，DB2语句事件监视器所捕获的数据也可以保存到PWH中。
Load: Snapshot, configuration, and SQL activty data is inserted into the PWH data tables.
加载：将快照、配置和SQL活动数据插入PWH数据表。
DB2 PE handles each monitor element type differently when it summarizes them from history into PWH.
在DB2PE将历史数据汇总到PWH中时，它会对各监视器元素类型进行不同的处理。
However, for reports on SQL, the data must first be collected and loaded into PWH.
但是，对于SQL报告，必须先收集数据并把数据装载到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表中。
Queries are used to analyze various aspects of the data in the PWH.
查询用于分析PWH中数据的不同方面。
Note that the PWH stores DB and DBM CFG values, but only inserts a row if a value has changed.
请注意，PWH存储DB和DBMCFG值，但某值发生变化时只插入一行。
The data stored in the PWH consists of DB2 snapshot data, DB2 event monitor data, and DB2 configuration data.
存储在PWH中的数据由DB2快照数据、DB2事件监控数据和DB2配置数据组成。
Figure 7 shows a sample ROT result matrix that is displayed after you have started ROT analysis on the PWH data.
图7所示为启动PWH数据的ROT分析后所显示的示例ROT结果矩阵。
Department Operations Manager, Department of Medicine and Therapeutics, PWH
威尔斯亲王医院内科及药物治疗学系部门运作经理
PWH data tables containing snapshot and configuration data
包含快照和配置数据的PWH数据表
PWH data tables containing SQL activity trace data
包含SQL活动跟踪数据的PWH数据表
PWH. TABLESPACE for table space snapshot data
TABLESPACE针对表空间快照数据
PWH. DBMCFG for database manager configuration data
DBMCFG针对数据库管理器配置数据
PWH. TABLE for table snapshot data
TABLE针对表快照数据
PWH. BUFFERPOOL for buffer pool snapshot data
BUFFERPOOL针对缓冲池快照数据
Here are some of the questions that can be answered by analyzing the data in the PWH
以下是可以通过分析PWH中的数据来回答的一些问题
PWH. EVM_STMT_TEXTS for statement text data
EVM_STMT_TEXTS针对语句文本数据
PWH. EVM_STMT_SUMMARY for summary information, such as prepares, warnings, errors or executions
EVM_STMT_SUMMARY针对摘要信息，如准备、警告、错误或执行
PWH. EVM_STMT_IDENTIFIER for statement information, such as package, creator or cursor
EVM_STMT_IDENTIFIER针对语句信息，如包、创建者或游标
