When a table has been reorganized with the reorg utility.
当用REORG实用程序重新组织表时。
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时，要注意以下几个问题。
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.
两个场景之间的REORGTABLE步骤将建立聚集顺序。
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.
两者合计，他们代表了在一代人中五角大楼最大的重组。
The following examples illustrate partition-level REORG on a table that has no global indexes.
以下例子阐明了如何在不含全局索引的表上应用分区级别reorg ？
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 29中，REORGTABLE命令中的默认压缩字典指令是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一样，LOADreplace有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.
大多数情况下，ALTERSETDATATYPE需要对表执行重组(reorg)，因为它修改了物理行格式。
Each of these operations: redistribute, table reorg, index create, and runstats require scanning the table data once.
这些操作中：redistribute、table reorg、indexcreate和runstats，每个操作都需要扫描一次表数据。
Thus the UPDATE statement fails to find the row with the row CHANGE TOKEN that was retrieved before the REORG occurred.
因此，update语句无法找到具有ROWCHANGETOKEN的行，这些行是在发生REORG之前检索得到的。
Additionally, DSNACCOX with DB2 10 has specific code to reduce the REORG requirements for table Spaces residing on SSDs.
另外，DB 210的DSNACCOX具有特定的代码来降低对驻留在SSD上的磁盘空间的REORG需求。
If you use the offline table reorg or rowcompestimate option in the inspect tool, data in the table is fully compressed.
如果在inspect工具中使用离线table reorg或rowcompestimate选项，则表中的数据将被完全压缩。
In order to synchronize with the new ADC feature, the behavior of KEEPDICTIONARY for the offline table reorg has changed.
为了与新的adc特性同步，离线table reorg的KEEPDICTIONARY行为已经被更改。
Therefore, REORG usually produces a dictionary that is more representative of the data in the entire table space or partition.
因此，REORG常常可以产生更能代表整个表空间或分区中的数据的字典。
The following REORGCHK command examines whether the REORG is required and also updates the statistics on table bench.customer.
下列REORGCHK命令检查是否需要REORG，并且更新关于表bench .customer的统计信息。
Reorg in Progress 0x400 This is a transient state that is only in effect during a reorg operation. Issue a reorg TABLE command.
reorginProgress0x400这是一种只在进行重组(reorg)操作期间才有效的临时状态。
应用推荐