They can increase logging during the REORG process.

会在REORG过程中增加日志。

When a table has been reorganized with the reorg utility.

当用REORG实用程序重新组织表时。

At last, a true low-overhead online table reorg capability.

最后，一个真正的低开销在线表格重组功能。

The REORG USES a sampling technique to build the dictionary.

REORG使用一种抽样技术来建立字典。

The dictionary gets updated for every subsequent REORG operation.

在随后的每次REORG操作中，表字典随之更新。

Behavior changes in row compression using the offline reorg utility.

使用离线reorg实用程序的行压缩中的行为的变化。

Rename, alter, reorg, refresh, nickname, comments, or lock statements.

refresh、nickname、comments和lock语句。

Here are a few things to keep in mind when using partition-level reorg.

在使用分区级别REORG时，要注意以下几个问题。

A third problem can occur when performing RUNSTATS or REORG on your table.

当对表执行RUNSTATS或REORG时，可能出现第三个问题。

You should run reorg and runstats after creating new indexes, as shown below.

您在创建新索引之后运行reorg和runstats命令，如下所示。

The REORG TABLE step between two scenarios will establish the clustering order.

两个场景之间的REORG TABLE步骤将建立聚集顺序。

Before you apply new stats to the database, I recommend you reorg the data first.

在您将新语句应用到数据库之前，我建议您首先重新组织数据。

Both the RUNSTATS and REORG utilities use log files when moving table data around.

当到处移动表数据时，RUNSTATS和REORG实用程序都使用日志文件。

Taken together, they represented the biggest reorg of the Pentagon in a generation.

两者合计，他们代表了在一代人中五角大楼最大的重组。

Use this utility after massive changes to the data and possibly after running REORG.

大量更改数据之后或运行REORG之后使用该实用程序。

While the reorg operation is running, execute the following script from another session.

在执行重组操作时，从另一会话执行下列脚本。

The following examples illustrate partition-level REORG on a table that has no global indexes.

以下例子阐明了如何在不含全局索引的表上应用分区级别reorg ？

Reorg index - For example, reorg indexes all for table .

Extra indexes also add to the CPU consumption of certain DB2 utilities, such as the REORG utility.

额外索引还会增加某些 DB2 实用工具（比如 REORG 实用工具）的 CPU 占用。

This is also why maintenance operations like REORG cannot be performed on an individual local index.

这也是无法对单个本地索引执行类似 REORG 维护操作的原因。

REORG will restore a disorganized index to a well-organized state, at a cost of some CPU consumption.

REORG将把一个组织混乱的索引恢复为良好组织状态，但要以一些CPU消耗为代价。

Based on the data and trends you observe, adjust your REORG frequency and PCTFREE number accordingly.

根据当前的数据以及您所观察到的趋势，对REORG的频率和PCTFREE的数字进行相应的调整。

In DB2 9, the default compression dictionary directive for the REORG TABLE command is KEEPDICTIONARY.

在DB 2 9中，REORG TABLE命令中的默认压缩字典指令是KEEPDICTIONARY。

DB2 provides various utilities, such as RUNSTATS, REORG and REORGCHK, to improve database performance.

DB 2提供了各种实用程序来提高数据库性能，如RUNSTATS、REORG和REORGCHK。

Just like the offline table reorg, LOAD REPLACE has both the KEEPDICTIONARY and RESETDICTIONARY options.

和离线table reorg一样，LOAD replace有keepdictionary和RESETDICTIONARY选项。

Conversations with folks at IBM reveal a viewpoint within the company that DBAs may reduce REORG frequency.

与IBM员工的谈话揭示了公司内部一个观点，DBA可能会降低reorg频率。

For more information, see the "2.4 Behavior changes in row compression using offline reorg utility" section.

欲了解更多信息，请参阅“2.4使用离线reorg实用程序的行压缩中的行为的变化”小节。

The table dictionary is built only when a REORG is performed, after which the data in the table can be compressed.

只有在执行 REORG 的时候才构建表字典，之后便可以压缩表中的数据。

In most cases, ALTER SET DATA TYPE requires table reorganization (reorg) because it changes the physical row format.

大多数情况下，ALTER SET DATA TYPE需要对表执行重组(reorg)，因为它修改了物理行格式。

Each of these operations: redistribute, table reorg, index create, and runstats require scanning the table data once.

这些操作中：redistribute、table reorg、index create和runstats，每个操作都需要扫描一次表数据。