reorg
- 网络重组；表重组；重组操作
reorgreorg
重组
重组（reorg）操作会重新排列表数据的物理顺序，并除去碎片数据中的空闲空间。由于删除操作不释放磁盘空间，在执行删除 …
表重组
...11.3 表和索引碎片整理 470 11.3.1 表重组(REORG) 470 11.3.2 索引重组 478 11.3.3 确定何时重组表和索引 480 11.3.4 重组 …
重组操作
4、 数据重组操作(REORG)。 5、 数据重分布操作(REDISTRIBUTE)。
表执行重组
大多数情况下，ALTER SET DATA TYPE 需要对表执行重组（reorg），因为它修改了物理行格式。可以使用 ADMIN_REVALI…
重组数据表空间
...，定期做数据备份 (COPY) 以防数据丢失 , 重组数据表空间 (REORG) 获得更访问和存储效率 , 更新表和索引的统计信息 (RU…
整理表和索引数据碎片
...开，在第五个页面“选择要配置的维护活动”页面中对“整理表和索引数据碎片（ REORG ）”这条记录中的“自动化”列打上勾即 …
重组的
有重组的（reorg）的sample不，在一本通里没看到这个参数。http://www.mainframer.cn/question.mrqa?action=view "ＱＳＡＭ…
1
A few weeks ago Natasha (my girlfriend) told me about a post she wrote on her blog (Reorg) which described some basecamp best practices.
几星期以前，我的女朋友Natasha告诉我她在其博客上写的一篇关于“Basecamp的最佳实践”的博客文章。
2
You need to monitor the system (ideally in an automated fashion) to determine when a REORG needs to be run.
您需要监控系统（最好通过自动方式）来决定何时运行REORG。
3
COMPACT ON is the default for the redistribute utility, where it performs space compaction much like an offline table reorg does.
COMPACTON是重分发实用程序的默认选项，它像离线tablereorg那样执行空间压缩。
4
Conversations with folks at IBM reveal a viewpoint within the company that DBAs may reduce REORG frequency.
与IBM员工的谈话揭示了公司内部一个观点，DBA可能会降低REORG频率。
5
REORG will restore a disorganized index to a well-organized state, at a cost of some CPU consumption.
REORG将把一个组织混乱的索引恢复为良好组织状态，但要以一些CPU消耗为代价。
6
Word disappears, and Outlook 2003 appears, showing an e-mail message addressed to Andrew Fuller with a subject of "department reorg. "
Word消失，Outlook2003出现，其中显示了一封要发给林彩瑜的电子邮件，主题是“部门重组”。
7
Taken together, they represented the biggest reorg of the Pentagon in a generation.
两者合计，他们代表了在一代人中五角大楼最大的重组。
8
Each of these operations: redistribute, table reorg, index create, and runstats require scanning the table data once.
这些操作中：redistribute、tablereorg、indexcreate和runstats，每个操作都需要扫描一次表数据。
9
For later versions of DB2 you can remove or ignore the REORG statements or their generation SQL, which are not required to be run.
对于更高版本的DB2，您可以删除或忽略REORG语句或它们生成的SQL，这并不是运行所必需的。
10
This is also why maintenance operations like REORG cannot be performed on an individual local index.
这也是无法对单个本地索引执行类似REORG维护操作的原因。
11
The table dictionary is built only when a REORG is performed, after which the data in the table can be compressed.
只有在执行REORG的时候才构建表字典，之后便可以压缩表中的数据。
12
The reorg command reorganizes the tables by reconstructing the rows to eliminate fragmented data.
reorg命令通过重新构造行来消除碎片数据，从而对表进行重新组织。
13
Also, there should not be any need to run the REORG utility.
而且，也没有任何必要去运行REORG实用程序。
14
Before you execute the generated script reorg. sql, you need to create the ALTER TABLE statements to activate value compression.
在执行生成的reorg.sql脚本之前，需要创建ALTERTABLE语句，以激活值压缩。
15
The script below will scan for AW fact tables named using the wildcard expression %_MEASURES and scripts ALTER TABLE and REORG commands.
以下脚本将使用通配符表达式%_MEASURES以及脚本ALTERTABLE和REORG命令扫描指定的AW事实表。
16
Use this utility after massive changes to the data and possibly after running REORG.
大量更改数据之后或运行REORG之后使用该实用程序。
17
In DB2 9. 1, the compression takes effect only after the table dictionary is built, which is usually during the table REORG phase.
在DB29.1中，只有在建立了表字典之后（表字典通常是在表REORG阶段建立的），压缩才能生效。
18
In addition, maintenance commands such as reorg and rebind are also included to restore the state of the database after command deployment.
此外，还包括reorg和rebind等维护命令，用于在命令部署后恢复数据库的状态。
19
However, reserving free space only trades disk space for time, potentially letting you go longer between REORGs.
尽管如此，保留空闲空间只是以时间换取磁盘空间，可能会让REORG之间耗时更长。
20
A third problem can occur when performing RUNSTATS or REORG on your table.
当对表执行RUNSTATS或REORG时，可能出现第三个问题。
21
Before you apply new stats to the database, I recommend you reorg the data first.
在您将新语句应用到数据库之前，我建议您首先重新组织数据。
22
The REORG TABLE step between two scenarios will establish the clustering order.
两个场景之间的REORGTABLE步骤将建立聚集顺序。
23
When a table has been reorganized with the REORG utility.
当用REORG实用程序重新组织表时。
24
Thus the UPDATE statement fails to find the row with the ROW CHANGE TOKEN that was retrieved before the REORG occurred.
因此，UPDATE语句无法找到具有ROWCHANGETOKEN的行，这些行是在发生REORG之前检索得到的。
25
Both the RUNSTATS and REORG utilities use log files when moving table data around.
当到处移动表数据时，RUNSTATS和REORG实用程序都使用日志文件。
26
In addition to the RUNSTATS, you can automate database backups and REORGs (defragmentation of table and index data).
除了RUNSTATS外，还可以将数据库备份和REORG（表和索引数据整理）自动化。
27
The REORG uses a sampling technique to build the dictionary.
REORG使用一种抽样技术来建立字典。
28
And since they are written in physical clustering sequence, there should be no need to REORG.
由于这些行是按照物理的群集顺序来写的，因此不需要运行REORG。
29
In most cases, ALTER SET DATA TYPE requires table reorganization (reorg) because it changes the physical row format.
大多数情况下，ALTERSETDATATYPE需要对表执行重组（reorg），因为它修改了物理行格式。
30
If you use the offline table reorg or rowcompestimate option in the inspect tool, data in the table is fully compressed.
如果在inspect工具中使用离线tablereorg或rowcompestimate选项，则表中的数据将被完全压缩。