reorg

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

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

This provided some improvement on the table reorg problem , because you could use these options to perform a partial reorganization in the background without taking the table offline .

这为表重组问题提供了一些改进，因为您可以使用这些选项来在后台执行一个部分重组，而不需要让表处于脱机状态。

REORG also helps us implement another performance feature of DB2 .

REORG还帮助我们实现DB2的另一个性能特性。

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

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

The REORG utility can be used in many ways beyond purging data .

除了清理数据，REORG实用程序可以通过多种方式使用。

The REORG uses a sampling technique to build the dictionary .

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

Also , there should not be any need to run the REORG utility .

而且，也没有任何必要去运行REORG实用程序。

They can increase logging during the REORG process .

会在REORG过程中增加日志。

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

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

The dictionary gets updated for every subsequent REORG operation .

对于以后的每次REORG操作，更新表词典。

At a later time , REORG can be used to put the rows back in cluster order .

一段时间以后，REORG可用来将各行以集群顺序放回。

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

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

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

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

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

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

Deploying table spaces on SSDs can reduce the need to REORG .

在SSD上部署表空间可以减少REORG的需要。

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

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

And since they are written in physical clustering sequence , there should be no need to REORG .

由于这些行是按照物理的群集顺序来写的，因此不需要运行REORG。

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

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

He reminds his team to use the reorg utility , which clusters the data for efficient access .

他提醒他的团队使用重新组织实用工具，该工具会收集数据以实现有效访问。

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

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

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

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

When a table has been reorganized with the REORG utility .

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

Remember , REORG is basically an unload and a reload of data .

请记住，REORG从根本上说是卸载和重新加载数据。

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

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

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

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

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

大多数情况下，ALTERSETDATATYPE需要对表执行重组（reorg），因为它修改了物理行格式。

In this policy , the REORG TABLESPACE and LOAD utilities are being monitored for specific syntax parameters .

在这个策略中，REORGTABLESPACE和LOAD实用程序正在受到监视，监视它们是否使用特定的语法参数。

However , you can only create a compression dictionary using either the offline reorg table command or the inspect utility .

但是，只能使用离线reorgtable命令或inspect实用程序来创建压缩字典。

Therefore , REORG usually produces a dictionary that is more representative of the data in the entire table space or partition .

因此，REORG常常可以产生更能代表整个表空间或分区中的数据的字典。

You need to monitor the system ( ideally in an automated fashion ) to determine when a REORG needs to be run .

您需要监控系统（最好通过自动方式）来决定何时运行REORG。