pwh

美 　英

• 網(wǎng)絡(luò)威爾斯親王醫(yī)院(Prince of Wales Hospital)；半峰寬；偉

例句

If your configuration parameters rarely change, you will have only a few rows in the appropriate PWH tables.

若配置參數(shù)很少變更，那么在相應(yīng)的PWH表中將只有不多的幾行。

Processes are used to collect report data (CRD), load the data into the PWH tables and create a report.

過程用于收集報(bào)告數(shù)據(jù)（CRD）、將這些數(shù)據(jù)加載到PWH表中和創(chuàng)建報(bào)告。

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查詢的一個(gè)非常精妙的特性是將變量插入查詢的能力，用戶可以在運(yùn)行時(shí)對變量進(jìn)行替代。

Heavy hitter queries: These queries operate on the PWH tables which have stored the data collected by the DB2 statement event monitor.

高命中率查詢：這些查詢對已經(jīng)存儲(chǔ)了DB2語句事件監(jiān)視器所收集的數(shù)據(jù)的PWH表進(jìn)行操作。

The queries are standard SQL select statements that operate against the PWH tables.

這些查詢是標(biāo)準(zhǔn)的SQLselect語句，它們基于PWH表執(zhí)行。

This is handy if you are not familiar with all the PWH tables, but you do not have to use the column assist.

若用戶并不是對所有的PWH表都非常熟悉，則該特性便會(huì)派上用場，但這并不是說必須使用該特性。

Report queries: These queries return the data contained in the PWH tables under different aspects.

報(bào)告查詢：這些查詢返回包含在PWH表中的不同方面的數(shù)據(jù)。

For each record in the PWH. BUFFERPOOL table, the result matrix indicates whether a warning or problem occurred for the calculated ratios.

對于PWH.BUFFERPOOL表中的每一條記錄，結(jié)果矩陣都指示計(jì)算的比例是否出現(xiàn)警告或問題。

The data were aggregated in the background into the PWH tables from the short-term history (database, bufferpool, OS data).

在后臺(tái)，把來自短期歷史（數(shù)據(jù)庫、緩沖區(qū)池、OS數(shù)據(jù)）的數(shù)據(jù)聚合到PWH表中。

In addition, data captured by the DB2 statement event monitor can be saved into the PWH if needed.

此外，如果必要，DB2語句事件監(jiān)視器所捕獲的數(shù)據(jù)也可以保存到PWH中。

Load: Snapshot, configuration, and SQL activty data is inserted into the PWH data tables.

加載：將快照、配置和SQL活動(dòng)數(shù)據(jù)插入PWH數(shù)據(jù)表。

DB2 PE handles each monitor element type differently when it summarizes them from history into PWH.

在DB2PE將歷史數(shù)據(jù)匯總到PWH中時(shí)，它會(huì)對各監(jiān)視器元素類型進(jìn)行不同的處理。

However, for reports on SQL, the data must first be collected and loaded into PWH.

但是，對于SQL報(bào)告，必須先收集數(shù)據(jù)并把數(shù)據(jù)裝載到PWH中。

At an interval configured by you, the captured short-term history data will be migrated into the PWH tables using an ETL process.

捕獲的短期歷史數(shù)據(jù)以用戶配置的時(shí)間間隔，通過ETL過程遷移到PWH表中。

Queries are used to analyze various aspects of the data in the PWH.

查詢用于分析PWH中數(shù)據(jù)的不同方面。

Note that the PWH stores DB and DBM CFG values, but only inserts a row if a value has changed.

請注意，PWH存儲(chǔ)DB和DBMCFG值，但某值發(fā)生變化時(shí)只插入一行。

The data stored in the PWH consists of DB2 snapshot data, DB2 event monitor data, and DB2 configuration data.

存儲(chǔ)在PWH中的數(shù)據(jù)由DB2快照數(shù)據(jù)、DB2事件監(jiān)控數(shù)據(jù)和DB2配置數(shù)據(jù)組成。

Figure 7 shows a sample ROT result matrix that is displayed after you have started ROT analysis on the PWH data.

圖7所示為啟動(dòng)PWH數(shù)據(jù)的ROT分析后所顯示的示例ROT結(jié)果矩陣。

Department Operations Manager, Department of Medicine and Therapeutics, PWH

威爾斯親王醫(yī)院內(nèi)科及藥物治療學(xué)系部門運(yùn)作經(jīng)理

PWH data tables containing snapshot and configuration data

包含快照和配置數(shù)據(jù)的PWH數(shù)據(jù)表

PWH data tables containing SQL activity trace data

包含SQL活動(dòng)跟蹤數(shù)據(jù)的PWH數(shù)據(jù)表

PWH. TABLESPACE for table space snapshot data

TABLESPACE針對表空間快照數(shù)據(jù)

PWH. DBMCFG for database manager configuration data

DBMCFG針對數(shù)據(jù)庫管理器配置數(shù)據(jù)

PWH. TABLE for table snapshot data

TABLE針對表快照數(shù)據(jù)

PWH. BUFFERPOOL for buffer pool snapshot data

BUFFERPOOL針對緩沖池快照數(shù)據(jù)

Here are some of the questions that can be answered by analyzing the data in the PWH

以下是可以通過分析PWH中的數(shù)據(jù)來回答的一些問題

PWH. EVM_STMT_TEXTS for statement text data

EVM_STMT_TEXTS針對語句文本數(shù)據(jù)

PWH. EVM_STMT_SUMMARY for summary information, such as prepares, warnings, errors or executions

EVM_STMT_SUMMARY針對摘要信息，如準(zhǔn)備、警告、錯(cuò)誤或執(zhí)行

PWH. EVM_STMT_IDENTIFIER for statement information, such as package, creator or cursor

EVM_STMT_IDENTIFIER針對語句信息，如包、創(chuàng)建者或游標(biāo)